POB Equipment Spreadsheet

[Ionic Inc.]

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.

---

VIEW SPREADSHEET HERE!

[Xenon]

Thanks for the effort and time spent, cheers

---

NEBULA INFORMATION BOT ☆ NEBULA DISCORD SERVER
XENON WEAPONS MARKET ☆ NEBULA GRAND PLAZA ☆ NEBULA TECHNOLOGIES
THE DISCOVERY POBCAST ☆ DISCOVERY SERVER RULES

[Ashyur]

Thanks for the effort and time spent, cheers

Also this ? ? (meant to be 2 emojy with heart eyes,didn't worked posting)

you could format the numbers to have decimals so you can read it better, also for commodity names you could add in "(full commodity name)" so that new players can understand it better

anyways it's crazy one turret gets to be "only" 25mils

[Tenshi Kuonji]

You are damn A-WE-SO-ME
Me and Nano would which wanna extend my grattitude of your hard-work
Man its been a lot of effort and time in doing so
Thank you from the deep of heart, very much thank you :3

---

Discord : Tenshi Kuonji#3786 ✙|✙ Other Networks : Tenshi Hidden Links
Best Ranks Ever: 1|IC Kaiserliche Polizei Rheinland (KPR| Tagged Vessels)
The Arctic Trickster:Tales of Foxy Tenshi ✙|✙ Links: (soon)
Blogger | Amino | Medium | WordPress | DevArtStories

And so shall they fall, all who bear our mark. No matter who they are, no rank, nor title, nor power shall shield them. When the mark finds them, their time is nigh.

[Nodoka Hanamura]

.. For this, Ionic will be spared Nationalization when Ouroboros comes to power in Kusari. /s

Great work, m8.

---

[Ionic Inc.]

Thanks for the kind words.
Added thousands separators in the prices.

I don't know how I could add the full names. Obviously they don't fit in the column boxes without making the whole thing absurdly wide; I guess I could add notes to every single commodity, but most of them are probably clear anyway. I'd recommend adding such notes yourself in your own copy if necessary.

[Ashyur]

Thanks for the kind words.
Added thousands separators in the prices.

I don't know how I could add the full names. Obviously they don't fit in the column boxes without making the whole thing absurdly wide; I guess I could add notes to every single commodity, but most of them are probably clear anyway. I'd recommend adding such notes yourself in your own copy if necessary.

it doesn't need to be auto fitted the columns , like so ..

Attached Files

  Screenshot 2024-11-10 201930.png (Size: 6.59 KB / Downloads: 6)