Back

Guides

Community created guides, helpful strategies, and more.
TOPIC | [TOOL] Progress to Level Calculator
I was looking for something like this, but couldn't find anything exactly like it. So I learned to code and made my own. There might be a better way to do it, but this works for me. This spreadsheet shows the exact percentage you are towards your dragon's desired level. [img]https://i.imgur.com/bUchiDy.png[/img] Step 1: make a copy of this spreadsheet: [url=https://docs.google.com/spreadsheets/d/12Ya2ds_awnbjQviOyhAy0IWAhOXC5tEnyEpnBBwL6s8/edit?usp=drivesdk][TEMPLATE] Namira's Progress to Level Calculator[/url]. Step 2: Put your dragon's name in the column labeled "Name." Step 3: Put your dragon's [b]desired level[/b] in the column labeled "Level goal." Step 4: Put your dragon's [b]current level[/b] in the column labeled "Current level." Step 5: Go into the coliseum and find the [b]first number[/b] (before the slash, see image below) on your dragon's [b]experience bar[/b] (either in "Organize Party" or after a battle). Put that number in the column labeled "Progress bar #." This will give you an [i]exact[/i] view of your progress including the experience you've earned since reaching your current level, rather than relying on only the experience at the start of your current level. [img]https://i.imgur.com/FTLXhkf.png[/img] [b]Do not edit the red fields in columns E-G or the level reference in columns J-K the auto calculation will break.[/b] That's it! Just keep your current level and progress bar number updated as you gain experience and the sheet will automatically calculate the percentage you are towards your goal. Once you get to 100%, the progress percentage box for that dragon [i]should[/i] turn green if I did it right. Please let me know if you find any errors or have any questions! I'm running on coffee and not enough sleep right now lol.
I was looking for something like this, but couldn't find anything exactly like it. So I learned to code and made my own. There might be a better way to do it, but this works for me.

This spreadsheet shows the exact percentage you are towards your dragon's desired level.

bUchiDy.png

Step 1: make a copy of this spreadsheet: [TEMPLATE] Namira's Progress to Level Calculator.

Step 2: Put your dragon's name in the column labeled "Name."

Step 3: Put your dragon's desired level in the column labeled "Level goal."

Step 4: Put your dragon's current level in the column labeled "Current level."

Step 5: Go into the coliseum and find the first number (before the slash, see image below) on your dragon's experience bar (either in "Organize Party" or after a battle). Put that number in the column labeled "Progress bar #." This will give you an exact view of your progress including the experience you've earned since reaching your current level, rather than relying on only the experience at the start of your current level.

FTLXhkf.png

Do not edit the red fields in columns E-G or the level reference in columns J-K the auto calculation will break.

That's it! Just keep your current level and progress bar number updated as you gain experience and the sheet will automatically calculate the percentage you are towards your goal. Once you get to 100%, the progress percentage box for that dragon should turn green if I did it right.

Please let me know if you find any errors or have any questions! I'm running on coffee and not enough sleep right now lol.
MUYNhfy.png
VPnffeY.png
Gay (MLM/gay man flag)
rix3ppo.png
WKtl2lb.png
J7D1quC.png
l4bF82r.pngR9wtXaf.pngiZMfJug.pngwE8InSj.pngBjG9OOU.pnga6YPmbH.gif47CqiMq.gif
ASbXVY4.png
bYt72YT.png
tqGkHih.png
4SE4T9N.png
KrIo0N3.png
t6zNkmJ.png
9JeQCtz.png
Hi! I found this and have been using it to track my progress with leveling some of my dragons, and ended up adding some math and was wondering if anyone was interested in implementing it for their own sheets? (sorry for removing your formatting. also sorry for the long screenshot)

A screenshot of Google sheets, with a modified version of the leveling progress sheet.

Data shown here is specifically for the Crystal Pools, so you'd probably have to adjust the EXP history and/or # of enemies.

Current EXP vs new current vs diff is for calculating how much exp you just earned specifically to find the values of how much exp per group of enemies, +3, +4, and +1 adds the exp for that number of enemies to your current exp so you can copypaste it instead of re-typing the number. The white columms with "# enemies" is roughly how many battles you'd have, not including the 5% exp bonus you can sometimes get - though it wouldn't be too hard to add. I also averaged groups of 3 and 4 enemies since bosses are rare-ish. My math columns are blue, editable ones are yellow, except the +5% exp history part because I forgot.
Hi! I found this and have been using it to track my progress with leveling some of my dragons, and ended up adding some math and was wondering if anyone was interested in implementing it for their own sheets? (sorry for removing your formatting. also sorry for the long screenshot)

A screenshot of Google sheets, with a modified version of the leveling progress sheet.

Data shown here is specifically for the Crystal Pools, so you'd probably have to adjust the EXP history and/or # of enemies.

Current EXP vs new current vs diff is for calculating how much exp you just earned specifically to find the values of how much exp per group of enemies, +3, +4, and +1 adds the exp for that number of enemies to your current exp so you can copypaste it instead of re-typing the number. The white columms with "# enemies" is roughly how many battles you'd have, not including the 5% exp bonus you can sometimes get - though it wouldn't be too hard to add. I also averaged groups of 3 and 4 enemies since bosses are rare-ish. My math columns are blue, editable ones are yellow, except the +5% exp history part because I forgot.