excel formulas

Modifier column (BH):
=$BH$129*<N>
Where $BH$129 is a reference to the cell containing the constant modifier - the ones that are assumed to always be present.
Where <N> is the additional modifier depending on the current attunement.

Damage column (BI):
=IFERROR(ROUNDDOWN((IF(AQ132="Swing",969,$M$135)*$F$146*AZ132*BH132)/$E$136*(1+0.01*$H$133),0),0)

Average damage column (BJ):
=IFERROR(ROUNDDOWN((BI132*(1-IF(AQ132="Swing",$F$147+(180/21/100),$F$147)))+(BI132*IF(AQ132="Swing",$F$147+(180/21/100),$F$147)*(IF(AQ132="Swing",$F$148+0.05,$F$148)+1.5)),0),0)

DPS calculation:
=ROUND(SUM(BJ132:BJ190)/SUM(AY132:AY190),0)
Where SUM(BJ132:BJ190) is the total damage, and SUM(AY132:AY190) is the total time.