IO Mats Calculator

Resource

https://docs.google.com/spreadsheets/d/1p4FV0XeY-VZS_GyT3Yl1X4YDtubmC3lGMOFveNTsDd8/edit?usp=sharing

​

I set up this spreadsheet to figure out what I need to farm in the next few days in IO, sharing in case others might find it useful. You'll need to File > Make Copy in order to edit for your own use since the link is view only.

​

On the first sheet, you should only edit B2:B17 to represent what your current dojo levels are and C2:C17 for what your target dojo levels are. Totals needed will display in the box to the right. You can edit M2:M13 to add any additional mats for things like weapons or high dragon wyrmprints.

​

This is about the extent of my spreadsheet knowledge so if you can improve it feel free to make edits and post here!

Posted Apr 8, 2019, 3:59 AM UTC

147
itsasharkattackOP•

My conclusion from this, even with 350 stocked exquisite honey, I'm probably not gonna hit my goal >.<

6
bf_zelniteLinLin•

Thanks. I only need to farm 29209 total insignias left. See you all in 3025.

4
Machicto•

bless your soul

2
-pkpkay-•

Great calculator. TY.

Small bug but I'm trying to figure out how it's calculating costs for 31+ dojo levels =P

On a side note, this calculator made me realize how much more of a grind I have left....

I currently have 120 of the 6 wing ashes....so that's 360 runs. If I'm averaging 7 insignias per run....that's only 2520 insignias. I still need over 10k insignias and most of my dojos are around 26. Oh boy.

1
itsasharkattackOP•

If you put in 31 as a target it should be functionally the same as 30. 32+ as a target will pick up the "totals" row (33) from the Costs tab which will add huge numbers :) You could just delete that row and then anything over 30 should be the same, I just had the totals there to confirm my numbers matched the wiki after I typed them all in

​

Edit: Added a validation to only allow integers 1-30 for current/target

1
gkumelon•

Just letting you know, Dyrenell Aureus will be the most bottle neck for upgrading them to level 30.

You will need 7200 of them to upgrade all dojos from 25 to 30. You get 2-4 drops per run during the event, that’s roughly more than 2000 runs.

1
Televis10n•

I added a chart that includes converting insignias, added wyrmprints, weapons, made specific things and categories toggleable, and added an estimated runs needed table

https://docs.google.com/spreadsheets/d/1TdGN0bXQ0SFy5gzI1YkM63xAfQlPU1FqKBvMrzy7uOc/edit?usp=drivesdk

1
MattMamba•

this is very useful.. hope you'll be updating this to reflect the upgraded dojos!

1
Televis10nJohanna•

I actually did a revamp to the sheet to get a schedule of how long each IO is needed by including daily chest drops, and I also currently have my personal estimates included on levels 31-35 dojos. You'll have to make a fresh copy of the sheet to get any changes. Here is the updated link (and I'll update it again when the update rolls out and I get the new numbers)

https://docs.google.com/spreadsheets/d/1KfBhCCGMdpAsOZ_jiosL2evTK1jlY3VdXNEcPY5DmAs/edit?usp=drivesdk

3