Woodcutting/Mining Calculator

[pyroblaze]

Just a simple woodcutting and mining calculator I made to see how much wood and ores you can harvest a day, and how upgrades effect how much. Only change the values with a black background. 

If anyone knows of the calculations for the amount of gold/AP for the next level of woodcutting and the wood/AP for mining, please respond and I'll add it in.

Download link is at the bottom.

Math for the calculations are below. Please let me know of any errors.

Logs/HP - Amount of logs gained per HP - # of logs gained/ HP =C13/B13

Logs/Cut - Amount of logs gained per cut - (# of logs gained / # of cuts to complete level) * chance of double logs = (C13/(ROUNDUP((B13/$B$6),0)))*$B$4

# of cuts to complete level - (This is always rounded up to the nearest integer) - HP / Effective DMG = (C13/(ROUNDUP((B13/$B$6),0)))

Effective DMG - Cut Damage * Critical Chance =B2*B3

% Increase - % Increase of resource gained compared to previous level - ((Current level logs/cut / Previous level logs/cut) * 100) - 100 = ((E14/E13)*100)-100

Logs/Day - Amount of resource gained in a day on average using every energy - 30 * 24 * logs/cut * NRG  = (60/2)*24*$B$5*E13





Added V 3.0:

-Added in % damage from ascension bonus
-Fixed some of the maths
-ONLY input current level of your skills now, everything else is calculated!


Added V 2.0:

-Now takes into account Woodcutting NRG reduction from trophy upgrades
-Now able to control play time, instead of the max of 24 hours
-Calculations for most cost-effective purchases for log upgrades