you can manually fudge the spreadsheet by using old fashioned math to calculate the various multi attack rates with Raetic inclided,
Possible to elaborate a bit more about this?
Say if I have 20%(1/5) proc rate from raetic, and 5 QA, 20 TA, 30 DA in melee TP set.
I just manually change the MA rate to 1% attack 5 times(1/5 of QA rate), 8% QA(remaining 4% base QA+1/5 of base TA rate), 22% TA(remaining 16% TA + 1/5 of base DA rate), 24% DA (4/5 of base DA rate)?
Also how do I add values for QA+1 proc?
Basically, start at the highest column and add a rate equal to the Raetic + previous MA rate round combination occurrance rate, and proceed down. For example, let's say you have 400 MP for 20% Raetic Rate (let's call it RA), 20% DA, 20% TA, and 5% QA.
First, you calculate QuintA, with RA * QA = 1%. That's 5 attacks out of 100, so when we're done, we'll add 1% to QA (+3/100) and 1% to TA (+2/100).
Next, we move onto QA. Your new QA is RA * TA + QA = 9 QA, so manually add 5 QA on the spreadsheet under the custom row (with 1 QA for the QuintA calculations), so your total QA is 10%.
Your new TA is RA * DA + TA = 24% TA, so manually add 5 TA (with 1 TA for the QuintA calculations), so your total TA is 25%.
Your new DA is the combined chances of RA or DA proccing, which is (1-(100-RA)*(100-DA)) = 36%. Manually add 16% to your DA rate here, so your total DA is 36%.
Finally, go to the data sheet and find how many attacks per round each weapon gets on average. Then, add (10)/(Average Attacks per Round) to the STP cell in the custom row. So, if you average 3 attacks per round, add 3 STP there.
Two things to keep in mind. First, this method only works when single wielding or dual wielding Raetic weapons only, as you can't add stats to the custom row that only apply to one weapon but not the other. To separate the weapons, you'd have to head to the Data sheet and do your adjustments there, which is probably possible, but I haven't done it (as I've only calculated Raetic DPSs for two handed weapons).
Second, there are three sources of skewing due to basically brute forcing it:
1: We cannot directly input Quintuple Attacks; splitting them up between QA and TA gives you the same total number of additional attacks per round, but is sometimes slightly different in terms of when you reach 1000 TP. Depending on the TP scaling your WS of choice has, this can skew the DPS either higher or lower than it actually is (given realistic QA rates).
2: We cannot input STP only on the first hit of a weapon's round, so we're averaging it with the average number of hits per round. This introduces rounding errors (more significant with lower Raetic rates), and will rarely misrepresent (in both directions) whether you barely hit 1000 TP in a round or not. Depending on the direction of your STP rounding, this can skew your DPS in either direction.
2: If you're dual wielding two Raetic Weapons, spreading out Quintuple attacks removes the effect of the 8 attack per round cap. In the actual game, if you get two QuintA procs, you lose 2 hits that round, and if you get a QuintA and a QA proc, you lose 1 hit that round. This never happens when you spread them between QA and TA, so the spreadsheet calculation never has you losing hits. With realistic QA and Raetic rates, this will only rarely happen, but it does have an effect. This will slightly skew your DPS higher than it actually is.