Topic: Perpetuum Manufacturing Spreadsheet
Greetings All,
Finished my spreadsheet for manufacturing. Have both formulas for refining and mass production inputted into it.
To use, just modify the sections mostly in "white" for Material Ratio Points and CT ratio.
You can also adjust "your value" of Raw Materials.
Finally, input the number of commodities needed by the "base" item you want to produce, NOT the adjusted required at the factory terminal.
I've inputted "base" value for Fragments, which you are also able to change as needed, that section is not in white however.
This spreadsheet will allow you to see the "difference" in Nic value when adding "points" into the Material Effeciency and Refining extensions, as well as the changes based on market values of minerals. It will also allow you to look at the "value" of a commodity, and then you can decide whether to refine yourself, or put up buy orders.
REMEMBER to use the points you get at the terminals you plan on crafting at. The current listed on the spreadsheet is my production guys. It is a total of Facility, Relations, and Extensions, as well as the CT bonus for mass production.
Reply here if it's useful to folks, or if you find any mistakes in my formulas.
I'm planning on revising it to be more in depth for my personal uses, and will post updates here as I do for the Perpetuum crafting community.
Good luck and have fun all.