Doctor Archive
Thread: buff power formulae
Page 1 of 1
Ojes
Mon Oct 04, 2004 8:27 am
#1
I know there isa link to an excel spreadsheet somewhere in these doctor posts. I pulled it some time ago and have been using it ever since. Give it the resource stats and it will generate the max power on your aCRDM, aSDS, aBEC, and buffpack.
I will give the formula that I have in my spreadsheet. The resources are listed in columnA starting in row 2 (Avian, Reactive, Herb, Class4, Oats, Dolovite, Berries, Water). Columns B, C, and D represent the OQ, PE, and DR of those stats. Here are the formula:
aLS Power = ROUND(10+((((B8+B9)/2*2/3000)+(C8*1/3000))*190),0)
aBEC Power = 12
aCRDM Power = ROUND(10+((((B4+B5)/2*2/3000)+((C4+C5)/2*1/3000))*65),0)
aSDS Power = ROUND(10+((((B6+B7)/2*2/3000)+(C6*1/3000))*65),0)
Buff Power = ROUND(+(((B2+C2+B3)/3)*0.76)+40+E15+E16+E17,0)
Buff Duration = +(((0.4*B2)+(0.6*D2)+(0.4*B3)+(0.6*D3))/20)*130+1200
Note that aBEC Power is a constant since I experiment aBECs for charges rather than power.
Ojes
Mon Oct 04, 2004 8:30 am
#2
Oh yeah - the power of the subcomponents are stored in column E in the order the formula are listed:
E14 = aLS
E15 = aBEC
E16 = aCRDM
E17 = aSDS
EdieBauer
Mon Oct 04, 2004 8:51 am
#3
Does anyone have the same formulas for Stims?
Is there a formula for the ABEC?
Marrow1
Mon Oct 04, 2004 9:18 am
#4
For Enhance D:
Power = Sum of all power of the sub components + 40 + 0.76 * (OQgas+OQavian+PEavian)/3
Duration = 1200 + 13 * (6*DRgas + 4*OQgas + 6*DRavian + 4*OQavian)/20
Charges = ABEC charges - 5 + 0.02 * (OQgas + OQavian + 0)/3
I believe the sub components keep fractions even thought they are not shown so you mayoff a little here or there.
Dafim
Mon Oct 04, 2004 12:14 pm
#5
was wondering if anyone knew a formulae to calculate the power of your buffpack from the components, meat and gas
Page 1 of 1