Bolt & Fahrenheit Calculator

[suxerz]

Though I know that calculating damage from bolts and Fahrenheit is not that hard and not really important; but since I have this quite a while ago in excel, I feel like sharing it here using googledocs --> LINK (https://spreadsheets.google.com/ccc?key=0ApI-50p2LmlcdG92RXNJcTQ0YktSNVdTcmg3VmFLRFE&hl=en&authkey=COzI2JMJ)

It is simple to use - just put the numbers in the yellow boxes and you'll get the damage or quanta needed. Just don't mess up the formulas and the "refBolt" sheet.

The "Minimum Quanta Calculator" is probably what I like the least since I'm not a math wiz and I couldn't figure out the formula, so I end up using a lookup function (which is quite terrible with a crappy connection). However, I feel it is more useful than the rest of the "calculators" in some scenarios. If you like it and want it to be more efficient, you can transfer it to your excel.

Feel free to put any questions/comments/suggestions. Also, if any math wiz would like to help/discuss the calculation for "Minimum Quanta Calculator", it'd be great.



_{p/s: I know that something similar (http://elementscommunity.org/forum/index.php/topic,1854.0.html) like this has been posted earlier, but I hate bumping old thread and besides, I think those links don't work anymore.}

[Wonder]

Thanks for sharing ^^

[Sodomir]

Can you improve the function, so that the damage is caused by bolts needn't to be dividable by three? Maybe some rounding?

Otherwise is a great tool for my lazy days, when I have no desire to use mental arithmetic.  8)

[plastiqe]

Fire Element Damage Tables (http://elementsthegame.wikia.com/wiki/Fire_Element_damage)

[suxerz]

Can you improve the function, so that the damage is caused by bolts needn't to be dividable by three? Maybe some rounding?

Otherwise is a great tool for my lazy days, when I have no desire to use mental arithmetic.  8)

Ugh.. It looks like somebody messed up with the formulas. -.-

I'm assuming that you are referring to the "minimum quanta calculator" (the 1st one).
To answer you question, it already has rounding function and the division depends on the spell damage that you enter in the "spell cost". When changing the spell cost to 2, it will work for ice bolt and drain life. In fact, this will work if in the future we have a card where it will inflict let's say 4 damage per 10 quanta as long as the mechanic is the same with the current bolt spells.

I've fixed the formulas and it should work as intended. googledoc don't have function to protect cells. Again, just a reminder - only cells in yellow should be changed.

[Dragoon]

The "Minimum Quanta Calculator" is probably what I like the least since I'm not a math wiz and I couldn't figure out the formula, so I end up using a lookup function (which is quite terrible with a crappy connection). However, I feel it is more useful than the rest of the "calculators" in some scenarios. If you like it and want it to be more efficient, you can transfer it to your excel.

Feel free to put any questions/comments/suggestions. Also, if any math wiz would like to help/discuss the calculation for "Minimum Quanta Calculator", it'd be great.

I took a stab at trying to figure out a formula for the "minimum quanta calculator" but had no luck.  It's a tough nut to crack.  I tried several different formulas but they all fell apart in different situations.  I gave up.   : P

It was a fun exercise though, and inspired me to build my  own version (https://spreadsheets.google.com/ccc?key=0AvzXeWJKVKrsdFhFZlpXSW41RXRSTzhzRDhLUTNjWWc&hl=en&authkey=CO_Ska8P) of the calculator.  Thanks for the idea and work.

[suxerz]

The "Minimum Quanta Calculator" is probably what I like the least since I'm not a math wiz and I couldn't figure out the formula, so I end up using a lookup function (which is quite terrible with a crappy connection). However, I feel it is more useful than the rest of the "calculators" in some scenarios. If you like it and want it to be more efficient, you can transfer it to your excel.

Feel free to put any questions/comments/suggestions. Also, if any math wiz would like to help/discuss the calculation for "Minimum Quanta Calculator", it'd be great.

I took a stab at trying to figure out a formula for the "minimum quanta calculator" but had no luck.  It's a tough nut to crack.  I tried several different formulas but they all fell apart in different situations.  I gave up.   : P

It was a fun exercise though, and inspired me to build my own version (https://spreadsheets.google.com/ccc?key=0AvzXeWJKVKrsdHVYSFozeDFMU3Vha1hCVUgyRklQclE&hl=en&authkey=CNuCh4IL) of the calculator.  Thanks for the idea and work.

Tee hee.. yeah, the problem that I have with the formula is figuring the round down (floor/ceiling terms in math?). I just don't know how to play around with those stuff in an algebra equation.

Your version is much more pleasant looking and the cap is at 300 (that is one long reference table!) and better formula in handling the "damage needed" exceptions. One minor thing - you should probably use a different name for each column in the reference table. Funny things will show up if you put 1, 2, 3, 4, 5 or 6 as the damage needed. Also, any other low values will show ">300" for the later bolts, but then again who would need to use this for calculating that low damage?


_{p/s: someone deleted a whole chunk of formulas in my sheet again. *sigh* Thanks revision history!}

[Dragoon]

Tee hee.. yeah, the problem that I have with the formula is figuring the round down (floor/ceiling terms in math?). I just don't know how to play around with those stuff in an algebra equation.

Your version is much more pleasant looking and the cap is at 300 (that is one long reference table!) and better formula in handling the "damage needed" exceptions. One minor thing - you should probably use a different name for each column in the reference table. Funny things will show up if you put 1, 2, 3, 4, 5 or 6 as the damage needed. Also, any other low values will show ">300" for the later bolts, but then again who would need to use this for calculating that low damage?


_{p/s: someone deleted a whole chunk of formulas in my sheet again. *sigh* Thanks revision history!}

Haha, I didn't notice those.   

Thanks for pointing them out.  I think they're fixed now.

Making a big reference table isn't too bad since it's all formulas (even that 1-300 quanta list!).  Originally I had 500 but I figured it would slow things down too much for the minimal benefit it brings.  You need ~430 water/darkness quanta to kill 500HP, but I doubt you could actually save that much before you decked out.  At ~280 quanta though, you can take out 500HP with 6 Fire Bolts.  So I went with a 300 quanta cap.

[jumpoffduck]

I was bored, so here's an alternate bolt calculator (http://jumpoffduck.co.cc/elements/bolt.htm)

It supports "minimum quanta" calculations

[hrmmm]

hehe, a cute little tool from you, jumpoffduck^^
added (http://elementscommunity.org/forum/index.php/topic,16745.0.html)

[Dragoon]

I was bored, so here's an alternate bolt calculator (http://jumpoffduck.co.cc/elements/bolt.htm)

It supports "minimum quanta" calculations

hehe, a cute little tool from you, jumpoffduck^^
added (http://elementscommunity.org/forum/index.php/topic,16745.0.html)

Yes, very nice indeed.  Now I'm curious how you did the minimum quanta calculations.   

[jumpoffduck]

hehe, a cute little tool from you, jumpoffduck^^
added (http://elementscommunity.org/forum/index.php/topic,16745.0.html)

A typo in the link - it should be .htm, not .html

Yes, very nice indeed.  Now I'm curious how you did the minimum quanta calculations.   

Didn't feel like figuring it out, so I brute forced it (started at 0 quanta, calculated the damage and incremented quanta until damage >= hp) ^.^