Resource: PoB Cargo Management Spreadsheet

Resource: PoB Cargo Management Spreadsheet - Printable Version

+- Discovery Gaming Community (https://discoverygc.com/forums)
+-- Forum: Welcome (https://discoverygc.com/forums/forumdisplay.php?fid=399)
+--- Forum: Help & Support (https://discoverygc.com/forums/forumdisplay.php?fid=26)
+---- Forum: Tutorials & Tools (https://discoverygc.com/forums/forumdisplay.php?fid=178)
+----- Forum: Community Technical Guides (https://discoverygc.com/forums/forumdisplay.php?fid=745)
+----- Thread: Resource: PoB Cargo Management Spreadsheet (/showthread.php?tid=189921)

Resource: PoB Cargo Management Spreadsheet - TheKusari - 10-01-2021

GOOGLE SHEETS LINK

Sup, everyone.

With the tutorials made for player bases, I thought I'd create a spreadsheet where you fill in your PoB's information and it would give you details on your cargo management, import pricing, consumption rates etc. Take into consideration that this sheet is meant to be used when your base is at 100% health. I have not (and probably will not) add in functionality for repair speeds and such. Just dump all three repair items and wait a while.

The file is a Google Sheets thing, so it's best if you download it and then upload to your own account for your own use. When you look at it, it may seem overwhelming. I'll itemize each piece of it so you can understand what I have created. Here's a screenshot of what it looks like:

All the information displayed in that screenshot is of my own player base, just as an example. There's hidden calculations and code everywhere to make this guy work, so bear with me. Everything highlighted in orange is what you're supposed to edit. I'll go through these one by one in a list format.

Orange Highlighted Stuff

Once all the information has been put in, you'll find that the rest of the sheet fills itself out. The key things to look out for are the Food, Oxygen, Water and Reinforced Alloy numbers under Cargo Management. When you edit the FOWRA Runtime, you'll find that those four numbers change to reflect how much you need to run for the specified time. In my case, the number is set to 40 days. All the misc commodities, FOWRA numbers, shield fuel will all be subtracted from the total cargo to show how much cargo you will have left. The import pricing, resupply transport cargo and timed runs will give you an idea of how much it costs for your base to run per day, and per period of time you set (40 days) aswell as how long it will take for you to non-stop supply your base until it's full.

At this point, you'll fiddle with the FOWRA duration to try get the Free Cargo number to as close to zero as possible. The colour will change to orange when you close and to red when you're over.

I understand if this is a little unorganised, but any feedback on this would be appreciated. Just wanted to create a neat little tool for players to use for their PoBs. Any Google Sheets savvy people may download and add in whatever they wish. My knowledge is limited, however I accomplished what I wanted to do with this.

Also I'm in hotel quarantine, god help me Tongue

RE: Resource: PoB Cargo Management Spreadsheet - Save My Soul - 10-01-2021

I guess (bitter)vets should know about this thing. Honestly, I don't know if that information is relevant at the moment. But I just leave it here for an alternative.

→ POB Supply Chain

P.S.: Didn't look at sheet because ain't interested tbh, but I'm sure a good job has been done. Keep it up, @TheKusari!

RE: Resource: PoB Cargo Management Spreadsheet - Groshyr - 10-01-2021

Thank you for this sheet, it's very useful for people like me who have pretty much fish's memory