--> Economy Overhaul Mod Version <--
**Mod Link
This is a quite substantial overhaul, or pretty much a replacement, to my Storage Estimator previously. When updating I was not very happy about how data was imported into the workbook, how the input tables were, and if ever someone wanted the datafiles updated to say a completely different economy with different wares, modules, etc., it would be too cumbersome to do. The new workbook also allows me to handle X4 updates to the economy, new modules, etc. more easily.
I am publishing this as a Beta, given I have not gone through every nook and cranny to catch any errors but see nothing major thus far and the VBA macros are working very well so thought I'd share to you wonderful folks

Will provide some detail below on the Tool:
OVERVIEW
The Empire Logistics Tool is a Macro-Enabled Microsoft Excel Workbook that allows players to have a deeper look into the production chain, habitat, storage, profit data, and base construction costs of multiple stations in a single location. Players can either create stations from scratch or import all current station plots from their save game using the Workbook. To allow future input into the Workbook - players can import construction plans to the Workbook which adds the construction plans to the bottom of the existing data.
*Note that you need to download to your local computer and run via the main Excel application; web browsers will not function. Ensure you "Enable Macros" when after downloading - not doing so will not allow the spreadsheet to function.
FEATURES & BENEFITS
- Production and Logistical Analysis
- Provide detailed analysis on the production chain of all stations within a game file.
- Allow stations to be set to a logistic group to redistribute wares between stations as necessary.
- Estimate required station storage needs based on a station's desired production time, and distinguish excess storage requirements for final products and/or intermediate products.
- Provide overall summaries for storage allocation and deficits, target ware storage levels (for setting in-game module settings within the Logistical Overview), station production mass balance, and logistic group mass balance.
- Allow stations to be set to fill habitats to maximum capacity (e.g. ship-production stations like shipyards), to see the impact on food and medical consumption.
- Accurate production bonuses due to workforce efficiency (per cycle calculations, as opposed to per hour like other tools).
- Ability to specify priority wares for Scrap Recyclers, to only produce one type of ware over another (doubles throughput for prioritized ware).
- Finances
- Provide base station building costs for all stations (using minimum, average, and maximum ware prices).
- Provide profit/loss per hour metrics based on best-case, average, and worse-case scenarios.
- Clearly show when stations need to purchase from other factions when a shortfall is occurring.
- Allow stations to be set to mine raw resources to avoid purchasing these inputs from external factions.
- User Interface
- Support multiple game versions (for version-locked games) and any combination of DLCs (or none at all).
- Provide dynamic drop-down menus to align with available sectors, modules, and wares for the specified game version and active DLCs (if any).
- Provide multi-language support for dynamic drop-down menus:
- Czech (Čeština)
- French (Français)
- German (Deutsch)
- Italian (Italiano)
- Japanese (日本語)
- Korean (한국어)
- Polish (Polski)
- Portuguese (Português)
- Spanish (Español)
- Turkish (Türkçe)
- Ukranian (Українська)
- Provide easy and quick way to import new stations into an existing Workbook.
- Assign stations to X4 Sectors to set correct production-related parameters [e.g. Solar Output].
- Allow build method to be defined (only applicable for select modules shared between COP and Terran economies (e.g. Scrap Processors, Observation Decks, etc.)
- Ensure production time and excess storage space requirements can be specified globally for all stations, or be overridden on a per-station level or per-production module level.
The Workbook uses various data tables to store information regarding wares, station modules, production methods, storage data, habitat data, and workforce consumption data that were generated from importing actual X4 data files using XML mapping. These data tables are used in a variety of dynamic ranges and formulas utilizing mainly LET(), XLOOKUP(), and INDEX() functions; some calculations, such as redistributing wares, requires the use of custom functions created in Excel VBA. Game / construction template importing, updating languages within data entries, and updating the core production analysis table all use Excel VBA macros to perform necessary actions.
Game file import needs the uncompressed XML file (*.xml, not *.xml.gz). Just unzip the .gz file to get the XML file - and you're done (it's that easy!).
All Excel VBA macros are open to anyone to view. I've tried to add in comments in case anyone is interested to somewhat understand what is happening. Macros only read external files selected by the "File Open" dialog when executing specific import macros, and does not write to your computer. As you do need to run this with Macros enabled - you need to download the file to your computer and run using the full Excel application (using the web browser will not work).
BETA PARTICIPATION
I always welcome any comments or suggestions to improving the worksheet. Please reply to this post if you encounter something wrong

Some things I have in mind, but have not figured out yet (likely a wish list at the moment):
- Handling a station being part of multiple logistic groups...
- Results page for summarizing Logistic Overview Settings for handling intermediate wares (i.e. Buy all but, Sell all but)...
- Production optimizer (e.g. auto-update production module quantities to meet station production chain requirements)...
- Station cost minimizer (e.g. using 1x M Container module vs 2x S Container Module [e.g. the 2x S Container is more expensive than 1x M Container even though it has less storage space])...
Happy managing!