POB Equipment Spreadsheet - Printable Version

Hello, viewers;

I've put together a spreadsheet for players making equipment on player bases. The basic idea is to have a list of commodities, all the ones that are needed, and every possible recipe that can be made, with the appropriate amounts. Then, you will get a number of how much it costs to make, and you can adapt that number according to your preferences. I want to share this spreadsheet so that other players can copy it for their own bases, or just look at it to get a feel for what needs what.
The existing values are those used by Ionic, so they are obviously not useful to you unless your base happens to be in southern Shikoku (hello BMI!), but I'm leaving them in as a point of reference.

I think the operations are fairly self-explanatory, but to go over it:

- The rows are the equipment, the columns are the goods required, with the last two being the prices.
- Columns B and C are the recipe list index and the specific item index number. The former is totally useless for any base that isn't mine so I've left it blank, but the latter is the same anywhere.
- Then there's the fat commodity list. I've tried to keep them grouped in a way that makes sense, and name them in a way that makes sense, but if you're confused about any of them, go ahead and ask.
- Column BD is just the sum of what it costs to make any thing given any commodity price; column BE is that with a multiplier, which is what the base gets. Adjust as necessary if you want your base to get more or less of a margin.
- Off to the right, there are modifiers for Docking Modules and "high-tech gear", aka Jump Drives and Cloak stuff. If your base has IFF bonuses, enter them accordingly, which will modify the prices.
- "Common" snub codes are made in batches of four, but the amounts are listed per unit.

I tried to pay close attention, but it's possible that something was entered incorrectly. Please tell me if you find a mistake.
This was created with the recipes as the current base_recipes config had them listed; I will try to keep it up to date when there are changes, hopefully the devs will include such changes in the patchlogs so I know to enter them.