Doctor Archive
Thread: My Excel Schedule Buff Formulas
Page 1 of 1
BrJLa
Thu Jul 15, 2004 7:10 am
#1
I didn't figure this out myself, but I put this together based on info on the forums and it works.
ACRDM Power:
=ROUND(10+((((B19+B20)/2*2/3000)+((C19+C20)/2*1/3000))*65),0)
B19: Herb OQ
B20: Class 4 OQ
C19: Herb PE
C20: Class 4 PE
ASDS Power:
=ROUND(10+((((B25+B26)/2*2/3000)+(C25*1/3000))*65),0)
B25: Domesticated Oats OQ
B26: Dolovite OQ
C25: Domesticated Oats PE
[NOTE: This is the same formula as ACRDM, except Dolovite doesn't have a PE]
Buff Power:
=ROUND(+(((B2+C2+B3)/3)*0.76)+40+E4+E5+E6,0)
B2: Avian (or Organic)OQ
C2:Avian (or Organic) PE
B3: Reactive Gas (or Inorganic) OQ
E4: ABEC Power
E5: ACRDM Power
E6: ASDS Power
Buff Power Conversion:
[Converts Buff Power to actual enhancement, assuming Master Doc with 110 Droid, +25 Bivoli, +25 Clothes]
=ROUND(+B10*1.1*2.5,0)
B10: Buff Power
Buff Duration:
=+(((0.4*B2)+(0.6*D2)+(0.4*B3)+(0.6*D3))/20)*130+1200
B2: Avian (or Organic)
D2: Avian (or Organic) DR
B3: Reactive Gas (or Inorganic) OQ
D3: Reactive Gas (or Inorganic) DR
This is in seconds. You can translate to minutes by dividing by 60, and hours by dividing by 60 again.
I don't calculate the power for my ABEC's. The formula exists, but I don't use it since it gives you the theoretical max, and I don't really want to max power on my ABEC's.
On buffs, 873 is the power required for a Master Doc to hit for 2400.That's what I aim for on all my packs. I calculate what I'll be able to achieve with all my other resources, then back into what my ABEC power has to be to get to 873. ABEC's contribute so little, though, that normally I only need 7 or 8 power on my ABEC's to get to 873.
This spreadsheet is incredibly useful in helping me conserve my uber resources, since I can calculate whether my second-tier resources (Class 4, Dolovite) will still let me get to my magic number of 873. I don't want to use my uberDolovite to get a 71 Power ASDS, if my ASDS power only needs to be 55 to get me to 873.
And it's also helpful in trying to match organics/inorganics so I don't use my avian and reactive gas on Action. My goal on Action is to have power that exceeds the rest of the set, and a duration that's within 4 or 5 minutes of the rest of the set.
Wizenobi
Fri Jul 16, 2004 2:49 pm
#2
Based on this information you put together: assuming the ASDS maximum power theory is 75: thus when I put together this forumula:
ASDS Power:
=ROUND(10+((((B25+B26)/2*2/3000)+(C25*1/3000))*65),0)
B25: Domesticated Oats OQ
B26: Dolovite OQ
C25: Domesticated Oats PE
Imagine all the Stat has 1000 OQ/PE (We can dream, can we 
)
)=ROUND(10+((1000+1000)/2*2/3000)+(1000*1/3000)*65,0)
It gives me result of: 32
So the question remains:
If OQ/PE has 1000 and OQ both have 66% value while PE has 33% value, how can we get this to 75 pt maximum power?
Hope I make sense...
Marlow_Cat
Fri Jul 16, 2004 4:02 pm
#3
Nice information. I have been working on a excel sheet of my own to figure out profit margin per resource cost, eventually I'll tackle the power/usage formulas too.
My first crafting profession, I'm enjoying nerding it out.
My first crafting profession, I'm enjoying nerding it out.
Wizenobi
Fri Jul 16, 2004 4:31 pm
#4
I did another possibilities on mathematical solution:
Old formula:
Imagine all the Stat has 1000 OQ/PE (We can dream, can we )
=ROUND(10+((1000+1000)/2*2/3000)+(1000*1/3000)*65,0)
It gives me result of: 32
New formula:
=ROUND(10+(((1000+1000)/3000)+(1000/3000))*65,0)
It gives me result of 75
Page 1 of 1