Game DB Encyclopedia (Locations, Stats, Industry, and more!)

[Mike Takumi]

This game feels so similar to Eve, I had to make a giant spreadsheet to go with it. This is fully filterable and pulls the default startup DB entries, so note that some of the economy stuff could adjust availabilities over time of things. Feedback is appreciated! Note the Station and Sector DB tabs should not be toyed with.




*****Database/Game Data scrubbing Google Docs Sheet*****
-DB references (Events, Missions, Medals, etc)
-Refinery breakdowns (will be moved to Production sheet)
-Ore/Salvage spawn locations and amounts
-Station services/Skill training locations
-Ship Stats and locations
-Module/Ammo stats and locations
-Material buy/sell locations
-Note, station amounts only valid for Career Game start

(Updated 4/20/2020)
Google Docs version
https://docs.google.com/spreadsheets/d/13h_IctsI33iOhiw6X_qq9CkdOzw5LQC1
Downloadable XLS format (Static data!)
https://drive.google.com/open?id=13h_IctsI33iOhiw6X_qq9CkdOzw5LQC1




*****Dynamic Game Data Scrubbing Excel Sheet*****
-Same features as above, except works for In progress games and sandbox! (Validated with maximum systems/stations)
-You must enable Macros and Data Connections for it to pull
-Just put the directory extension into the yellow block on Start tab and hit load (This may take a few minutes to complete, especially if you have very large galaxy settings)
-To update Station/Sector info, just go to Data>Connections>Refresh
-Only click load if you are changing game save/directory being used

(Updated 4/20/20)
Downloadable XLSM
https://drive.google.com/open?id=19gSup4G8jzil3bKeoq4FDDdvtoRTJaql




*****Industry Reference and Calculator*****
-Excavator turret comparison
-Refinery breakdown, by m3 size and raw mined amounts
-Step by step production breakdowns
-An "order" tab where you can set an amount to build and see how much ore, materials, and amounts of intermediates you need to build start to finish (Download only)
-Profit calculator if you are trying to maximize your income from mining (Download only)

(Updated 4/20/20)
Google Docs version
https://docs.google.com/spreadsheets/d/1GLjbvKxP8341ZNoYjoM3D-akyGgwkSwU
Downloadable XLS
https://drive.google.com/open?id=1bo-xtjLM6wMpTFu0A0j4ltUqIt4BvWPp



To Do:
-Add Blueprint finder into the DB sheet


Coming soon:
-A kind of spreadsheet "EFT"

[Mike Takumi]

KNOWN ISSUES:
-(DB sheet) Sorting is a bit finicky, Filtering works fine, but sort can cause Excel to crash
---Fix: Clear and remake the filter before you filter

-(DB Sheet) Super large galaxies may cause some things to break, mostly around import/refresh, it's better to manually refresh specific pulls that bugged

-(Industry Sheet) There may be some issues with the calculations due to quantities and item ID's conflicting on some tabs. There 100% is on the Orders tab and Value Checker tab at least


IMPORTANT:
-(DB Sheet) The Google Doc data is ONLY valid for game start in career mode. The game economy and your actions may change availability of items as you play

-(DB Sheet) In the XSLM, you MUST NOT use \ at the end of your save path, it will break things. Just use the root folder of the specific game save you want to use as indicated (...\MOD\saves\[namehere])

-(DB Sheet) Ore/Salvage amounts are the approximate maximum amounts in a fresh/fully respawned system and are the raw db used numbers, so 10000 Adam ore may not be equivalent to 10000 Zai ore, but within the columns they do compared properly (20k Adam is twice as much in system A compared to 10k Adam in system B)

-(Industry Sheet) Mining amount is the same regardless of ore size, so if you can mine 50 Adam ore in one turret cycle, you will mine 50 Zai ore or 50 Zai orbs.

-(Industry Sheet) In the Orders tab, input the amount of what you want to build into "To Build" column, then you can filter the "Needed" column of all 0s. You can even "order" multiple items at the same time and calc it all at once. Ore amounts are approximate minimums needed, you'll always have some extra resources.



Other info/Questions:
-I could use help/suggestions in how to structure the Ship Sales tab. Plopping all the ships in sorted by alphabetical name seems...a bit much. Maybe Shuttle/Escort/Utility/Frigate/Cruiser blocks?
-Y'all want trade goods data on locations?

[Mike Takumi]

4/19 Changes
-Reordered tabs again, DB info is at the extreme right end as it's mostly just reference for calculations
-Refining amounts are on the left in preparation for removal/migration to production sheet
-All sheet calculations updated to be faster(surprise, calculations searching entire sheets can really take an effort)
-Structure of XLS/GDoc mapped to match the Direct download Macro version in OP

4/20 Blaze it
-Fixed sector name mismatch problem
-Added Industry sheet and download

[Arbadacarba]

Great resource thank you for putting this together

Also if you have the time, maybe throw all this into a guide within steam?

[Soulmate]

Thx for doing this

[DiDi]

Just wanted to ask if this is till working as I downloaded it but cant get it to show me data.
Thanks for the support.