Hey guys!

As some of you might have begun to notice, I kinda like creating calculators on Google Sheets.

For those of you who want to find out how much materials and time you need for the items you want, here's a calculator made specially for that!

As usual, send me any feedback, bug reports, suggestions, and questions by commenting right here in this thread, or by sending me a Reddit PM.

P.S. If you're interested, try out my Unit Calculator.

P.P.S Help out the community by submitting your Collection Point drops!

UPDATE

A little bit later than planned, but I've made a few modifications to my calculator.

You can now:

1. Modify the sheet directly, so you don't have to go through the hassle of making a copy, or downloading it.

2. Specify how many of each material (and mogcakes) you already have on hand, thus providing a more accurate time estimation.

3. Get an estimate of how many Dwarves' Forge and/or Maranda Coast full runs you need to do (and the NRG cost). These cells draw their data directly from /u/Ithiria's data collection for this event. Don't forget to contribute to that!

4. View the countdown timers to the end of farming, and the end of crafting/claiming. Refresh the page, or modify any random BLANK cell for the countdown timers to refresh.

These updates were based on suggestions from /u/itchyd, so you can thank him/her if you find these added utilities useful!

Click here to get permission to edit the sheet, and start calculating.

EDIT2:

You can now:

1. Input number of full stacks, so you don't have to do the math (suggestion by /u/Ithiria).

2. Find out how many complete Dwarves' Forge/ Maranda Coast runs you need to do a day to hit your target before the farming deadline.

3. Know immediately if you can craft everything in time, or if you have to use lapis, and therefore adjust your needs accordingly.

Also, formatting changes.

EDIT3:

Minor edit. Added the section where you can input how many mogcakes you have baking so that will take away from your total mogcakes needed.