I was working on one of my own like 30 min ago, took a break and found this, quite similar but if I may suggest a couple of changes, which will add into same results, but kinda clearer and easier to interpret
2) This is a bigger one, but nice and easier to understand. I perfectly understand your formula for E1, and how yo apply APS (attacks per second from now on), and ASP (attack speed from now on), but people maybe gets confused.
a) On A3 instead of total attacks/second add input Attack speed bonus, yes I know on blizz chart does´t come, but is important if you are in the AH, and you want to see if a weapon is better or not. Why? with your way, people cannot not the Total APS if they have + ASP gear on them without equipping the weapon, and if you are in the AH you don´t own it yet to equip.
so we add a row to input ASP and yes, people has to add ALL (including weapons regardless of following formula) ASP on their gear so if they have a neck with +12% a chest with +15 and a weapon with 15% then you have 12+15+15 = 42, pretty easy.
On D2 we put weapons attack speed, and let E2 to add the number, where we only add something if the weapon has attack speed
on F2 we put =(B2/(1+(E2/100))) obtaining the really weapons APS
Then on D3 we put total attacks/second and on E3 the following formula =(F2*(1+(B3/100))) and we have total attacks per second taking into account all the gear, then on E15 change change B3 for E3 and done.
Seems messy like this, but if you want I can send you those changes to see if you like them on the spreadsheet, this way people can really know they number that will be shown before buying a weapon
Having this number we put t