FFXIV Crafting Calculator (Microsoft Excel)

[Mary_Read]

Hi M1uu, thank you for the kind words.

In a nutshell, I am using lists. Lots and lots of lists and vlookups. Every recipe is hand written out with a separate list keeping track of what items are raw materials (non synthed), and another list tracking synths using only raw mats, another list with items that require tier 1 synths, and another list for items requiring tier 2 synths. When the user inputs a quantity for a desired item, multiplication happens and sends the requested materials to the calculator, which in turn goes a bit further. All those lists activate, and synthed items have their recipes duplicated (or triplicated, or quadruplicated), adding to the final total required materials *and* what kind of supporting synths you will need to complete your requested project.

It's something I just kind of made up on the fly. The downside is this method requires circular references which can tax computers. So the spreadsheet can be slow while it is calculating everything.

It is an earnest desire and goal of mine to find a way to eliminate iterative calculations (circular references) from this workbook, which will dramatically speed everything up. Less lag is always good. I am not afraid of asking for help if this goal is too daunting for me alone (heh).

*edit* Well, hell. That was easy. I had a rogue column of formulas in a place they shouldn't have been. Circular reference solved.


I am also 70% done tweaking some formulas to make a google docs version of this 100% viable.

As far as hosting goes, a simple Excel file that can be downloaded and used locally was my ultimate goal. Something that can be used without being at the mercy of a website. Of course, a lot of people use Google docs, so I am hard at work to provide those folks a way to use this as well. Google is basically the final boss of the internet. If Google ever goes down, we're all in trouble.