Have fun!
NEW COR Spreadsheet >.>
As always it's a shared folder so the link has not changed:
https://drive.google.com/drive/folders/0B28ENNCAVh_sc3VEazl1VzJVSXc
I have not changed the way WSD is working ATM because I truly believe it will have a fix incoming. If nothing happens by Oct's update then I'll change.
September 16th to 21st, 2018
Wildfire and Leaden Salute: MDmg wasn't calced in the sheet for Ranged Weapons Skills only Quick Draw.
Edit: Ok I added MDmg calcs to the sheet but forgot to add them in the final calc for WF/LS. Also I noticed magic WSes don't have the math for post lvl 99. Working on it atm.
Read the post below on Rev3.
**It's still not in the sheet for Melee WSes but ATM there are no magic melee WSes in the sheet so doesn't matter.
Changed ODT Rate (Ranged) on Setup sheet to Empy AM and made it a drop down list 0%, 30%, 40% and 50%. Added a check later on to make sure you're actually wearing Arma or it doesn't count.
Foods: Altana's Repast (NQ, +1, & +2)
**MAB added to food calculations.
Necks: JSE x6 Base and Rank Max (NQ, +1, & +2)
Rings: Epaminondas's, Mummu Ring
**(Mummu +2 Set Bonus added: 8-32 Dex, Agi, & Chr)
Head: Lanun +2/+3, Mummu +2
Body: Lanun +2/+3, Mummu +2
**(Nisroch Jerkin had 0 STP fixed to 7, True Shot +5 added -Oversight when I added True Shot as stat to the "Gear List" instead of hard coded like it use to be.)
Hands: Lanun +2/+3, Mummu +2
**(Mummu NQ & +1 weren't listed as %.)
**(Relic(Lanun) +3 Triple Shot to Quad Shot calc added. Assumes 50% really need better testing done imo.)
Legs: Lanun +2/+3, Mummu +2
Feet: Lanun +2/+3, Mummu +2
Ranged: Augged EMP weapons added.
**Going to assume it's just addtive with older REMA WSDMG increases since no one seems to be testing this and ATM I can't.
**Added new sections for Emp and Aeonic in the calculation for respective weaponskills.
Daggers: Commodore's, Lanun and Rostam added too. For Commodore's & Lanun if you're in dyna give yourself +10 more acc manually.
**Will say depending on buffs Path A and B can jump bigly into first place between each other.
Weapons: FUA(M/O) (Follow up Attack) (Main/Offhand) added to "Gear Lists" stats and ODDM (Occ deals double DMG mainhand).
***FUAM added ic calcs but ghettoly (Rate x 0.99) for main hand added to AVG hits while this works 100% it should be added even better so you can see probability like the rest of Multi Attack but wasn't a big priotity since most fo you just care about the deeps(DPS) outcome. Sorry, this part never got saved.
Swords: Blurred Sword +1 changed to 40% from 45% to be inline with Blurred Dagger +1.
Mobs: Copied the Stats of WoC and Apex Bats (136) from the DNC Spreadsheet.
Lets talk about Mythic and COR/RNG spreadsheet...
**Mythic AM 1
***Mythic AM 1 R.Acc wasn't on sheet at all, added to RA, RA WS and Barrage calcs. Made proper section on "Setup" sheet and a table on the "Data" sheet.
**Mythic AM 2
***AM2 had left over checks for Melee Att on melee only but could never go off since it looked for Carnwenhan... RNG sheet has this check too. I ripped it out on COR sheet now.
***AM2 had no calcs for R.Atk at all, added to RA, RA WS and Barrage calcs.
**Mythic AM3
***Mythic AM3 was adding Occ shoots twice to twice in RA calculations :( IDK who added this part it came after Mote's last version. Hugely big *** up
***Mythic AM3 ODD/ODT DMG Ranged Set 1 was calculating DMG lower then it should have by checking "D Rating" a second time.
***Mythic AM3 ODD/ODT DMG Ranged Set 2 was calculating DMG lower then it should have by checking "Over all Ranged ACC". It's the cell before "D Rating" :/
***Death Penalty 119 III wasn't adding ODD/ODT DMG to Ranged Attacks nor would have "Death Penalty 119 III Aug".
Should have all the proper checks to not count them if you don't actually have Mythic equipped. >.>
Also has checks to cancel out lower lvl AMs if you have a higher one turned out.
Verde fixed but left some of this in the RNG spreadsheet too. Some of it was from Moletenn's time and others that edited COR before I took over. I may have forgot some checks when III came out but I think III weapons were in it before I started.
Not added:
Orpheus's Sash (I need more info first.)
Raetic (Soon)
I don't think I ever made a public version of the below.
Post May 25th, 2017 to early 2018 - This is a bit fuzzy since I forgot to log this stuff down as I went.
Swift Blade added.
4 New Swords added. (Hepa)
WSAcc is now a listed stat not the old list it as Acc with a (WS) tag on the piece of gear.
Regal Ring now counts for set Bonus.
WSAcc Listed in Gear/R_Gear.
Fotia Gear added so that it can later be added to Calc +1% proc rate.
Embrava Haste Calc new info. Not Skill/20 its really Skill/20 + 1. Also never had fixed for set 2.
T2 of Rapid Shot added with a level check.
Added a 99% cap to Rapid Shot in Sets both Barrage and Ranged Attack 1/2.
ToDo:
Add Raetic and get FUAO calculations added so it works.
Change Staff Affinity to it's own term since it is different from other affinity.
Add Volte Harness Set at Afinia's request.
Figure out how I want Fotia gear to be displayed.
There is ton of stuff I like that Bradon did on the DRG spreadsheet that at some point I'd like to do. Killer effects, mob weakness(piercing etc), cheer effects...
If you find any mistakes PM me them please.
Update: Oct 4th, 2018:
All 4 Hepa Swords did not have their DMG or Delay added to sheet that has been fixed.