First pass at getting station build data from the game files

ZonedOut · Post by **ZonedOut** » Tue, 15. Jul 14, 05:19

I did a couple of quick checks and everything seemed correct,, but this data should be treated with skepticism until it has been more thoroughly checked.

Also if anyone knows the proper method for extracting the sequence titles from the game files - a hint would be appreciated. The primary sequence in particular has no name in this version.

https://www.dropbox.com/s/m1bbil7hu27wsz9/stations.7z

Simoom · Post by **Simoom** » Wed, 16. Jul 14, 12:54

Very nice! ^_^

I once tried doing something similar (it was a station-building guide + economy guide) but I didn't know how to extract the game data, so I just used the in-game CV to check the starting materials. I didn't list all the materials for each phase of the construction.

I am interested in seeing you expand upon this... may be do some sort of X3-styled factory calculator? So people know how to set up proper production chains?

Fenhris · Post by **Fenhris** » Wed, 16. Jul 14, 19:39

Fantastic!

Been looking for those data for this project: http://forum.egosoft.com/viewtopic.php?t=367879

Hope you dont mind me using it for this project. I will try and use your link to have the sheet extract the data by it self later.

ZonedOut · Post by **ZonedOut** » Wed, 16. Jul 14, 23:25

Fenhris wrote:Fantastic!

Been looking for those data for this project: http://forum.egosoft.com/viewtopic.php?t=367879

Hope you dont mind me using it for this project. I will try and use your link to have the sheet extract the data by it self later.

The data is free for anyone to use.

I hope to enhance the available data to including other things such as min/avg/max build costs, production and input requirements. But that may take a few days depending on my available spare time.

Fenhris · Post by **Fenhris** » Thu, 17. Jul 14, 00:17

ZonedOut wrote:
The data is free for anyone to use.

I hope to enhance the available data to including other things such as min/avg/max build costs, production and input requirements. But that may take a few days depending on my available spare time.

Well, data for production are pretty easy, if I could only figuere out where to find what sub parts each module consists of, like Soltek Bridges etc. I would have each module with exact output amount.

ZonedOut · Post by **ZonedOut** » Thu, 17. Jul 14, 03:28

Updated the data to include min/avg/max pricing for the stages and overall station. Cleaned up the format, and made the sequence titles fairly close to what the architect displays in-game (still some work to do).

https://www.dropbox.com/s/x3t7d4eaml8uo ... ns-7-16.7z

@Fenhris, I think?? what you are asking for are the wares entries in the /libraries/wares.xml file with component elements on them ???

/wares/ware/component/ref will be equal to the macro name of the station element. The production/primary/ware<s> will give you the recipe.

ZonedOut · Post by **ZonedOut** » Sun, 20. Jul 14, 05:00

Added primary calculation for profit from station production facilities. All calculations are on average cost for input materials and average cost on sale of goods (no secondary goods or specialist effects).

Profit calculations for stations with rotating production queues on a single stage are not present in this data set.

Accuracy checking by anyone would be appreciated.

https://www.dropbox.com/s/i7fk3w3wmnafp ... ons0720.7z

ZonedOut · Post by **ZonedOut** » Thu, 31. Jul 14, 01:52

07/30/14 update. Things to note all triplet sets of values in ()'s are min/avg/max sets. A couple of station sequences with primary modules which have no production ability are not named correctly. Bonuses are shown, but not all the possible permutations of their applications. Proof checking/critisim is not only accepted but encouraged, and if anyone can suggest a more compact format to convey the same amount of info please speak up.

https://www.dropbox.com/s/7g4nc1f1ve4x7 ... ons0730.7z

nponoBegHuk · Post by **nponoBegHuk** » Tue, 7. Oct 14, 03:09

Wow, this is amazing! Incredibly useful! Thanks for your effort.

ZonedOut · Post by **ZonedOut** » Wed, 9. Mar 16, 23:42

Updated for Home of Light, as always I checked a few stations so if you spot anything wrong please let me know asap.

https://www.dropbox.com/s/lfsrugq7249xx ... ns.7z?dl=0

Simoom · Post by **Simoom** » Sun, 13. Mar 16, 13:41

Hey there ZonedOut,

I am about to do a major update to my XR station building guide by compiling your data and reorganize it in a way that's easier for people to digest. I was wondering (since you seem much more technically-knowledgeable than me) if it's possible for you to alter your data sheet to output the station data in the following format:

=========================
Station Name:

Production Modules:
- [module name] x [number of modules]
Total Ware Production (per hour):
- [total number of wares] x [ware name] ( [number of wares per module] x [number of modules] )
Total Ware Consumption (per hour):
- [total number of wares] x [ware name] ( [number of wares per module] x [number of modules] )

=========================
Here are some examples of what I have done... so you can see the formatting I am using.

Solar Energy Farm:
- Production Modules:
  - Solar Channel x3
- Ware Production (per hour):
  - 25200 Energy Cells (8400 x3)
- Ware Consumption (per hour):
  - 144 Food Rations (48 x3)
Wheat Plantation:
- Production Modules:
  - Valley Forge x2
- Ware Production (per hour):
  - 10800 Wheat (5400 x2)
- Ware Consumption (per hour):
  - 4800 Energy Cells (2400 x2)
  - 6000 Water (3000 x2)
Water Distillery:
- Production Modules:
  - Condenser Still x2
- Ware Production (per hour):
  - 28800 Water (14400 x2)
- Ware Consumption (per hour):
  - 4800 Energy Cells (2400 x2)
  - 24000 Ice (12000 x2)

If this is too difficult, would it at least be possible to change the way the ware production/consumption is currently listed in your sheet? Right now ware production/consumption rate is listed by number of seconds, and the range vary (I am guessing because they "tick" at different rates), but as you can imagine it is a nightmare for me as I have to punch in all the values into a calculator manually to arrive at a hourly value.

Thanks!

toby_p · Post by **toby_p** » Sun, 13. Mar 16, 21:36

Hi Simoom,
I'm not ZonedOut but I think I can help you here nevertheless. I have been writing a parser for ZonedOut's text file recently and have already included the HoL update. It should not be too difficult to adapt it to print stuff out the way you want it. I'll post my results here as soon as I'm finished. Do you need building costs and/or secondary resources as well? Also, since HoL and Albion use the same stations (and same station names), do you maybe want the stations like this:
1. Solar Energy Farm (Albion):

Greetings,
Toby

toby_p · Post by **toby_p** » Sat, 19. Mar 16, 12:16

Well, that took some time, but it's done! Let me know if there is anything (format-wise or content-wise) you'd like me to change. Cosmetic changes especially are very easy. Content-wise, there are some things which I have already implemented for my project that would be easy to include here, if you need them (e.g. building costs and secondary resources).

Note: I have omitted the amount of producing/consuming modules in brackets after a product's/resources' name (as in "4800 Energy Cells (2400 x2)"), since there often are different modules consuming the same resource and therefore it would not make sense to write it this way.

Here is the file: https://www.dropbox.com/s/90nrf7bffzihk ... m.txt?dl=0

Edit (12:37): I fixed a mistake resulting in module names being printed multiple times. I have only spot-checked the data, so if you find anything inconsistent with ZonedOut's file, please tell me.

Simoom · Post by **Simoom** » Sun, 20. Mar 16, 01:35

Hey there Toby!

Thanks for working on the parser. Thing is because ZonedOut didn't get back to me for a few days, I ended up parsing all the station stats manually (I ended up including production bonuses for all the factories, since I assume most people would want to fully upgrade and crew their factories anyway). I didn't see your posts until I was done... sorry! xD

You can see the results in my guide here:
http://forum.egosoft.com/viewtopic.php?t=363137

If you are knowledgeable in coding, though... I was wondering if I might recruit you for a more ambitious project: Namely, we really need a XR production calculator (in similar fashion to the X3 one).

Would you happen to know how to make something like that?

toby_p · Post by **toby_p** » Sun, 20. Mar 16, 11:29

Oh my - you did all that by hand?

That's quite perseverant! Well, I'll leave my file up anyways just in case somebody else can use it.
Great work on your guide, I posted some feedback in it's thread.
As for the production calculator... It was the reason I wrote a parser for ZonedOut's data in the first place! So yes, I am working on it. My role model is the excellent XAdrian factory complex calculator, though I fear mine will be far from the completeness and quality of that one. Since I haven't exactly written such a program before, it might be a while before I release anything, but I'm on it!

Post by **Sparky Sparkycorp** » Sun, 20. Mar 16, 11:58

Simoom wrote:I have waited, and waited, and waited... for someone to do a factory production calculator for XR... and nobody took up the mantle.
(The required data has been sitting around for a long while, too...)

Simoom wrote:If you are knowledgeable in coding, though... I was wondering if I might recruit you for a more ambitious project: Namely, we really need a XR production calculator (in similar fashion to the X3 one).

Would you happen to know how to make something like that?

On the same day that you first replied to the thread, Fenhris replied to mention a project which produced an Excel-based production calculator.

Whilst the download links are not working in that thread now, Fenhris is still posting so it would probably make more sense to contact that person before making one from scratch.

toby_p wrote: So yes, I am working on it.

Same comment as above - might save some time and hair-pulling

Simoom · Post by **Simoom** » Sun, 20. Mar 16, 21:32

toby_p wrote:Oh my - you did all that by hand? That's quite perseverant! Well, I'll leave my file up anyways just in case somebody else can use it.
Great work on your guide, I posted some feedback in it's thread.
As for the production calculator... It was the reason I wrote a parser for ZonedOut's data in the first place! So yes, I am working on it. My role model is the excellent XAdrian factory complex calculator, though I fear mine will be far from the completeness and quality of that one. Since I haven't exactly written such a program before, it might be a while before I release anything, but I'm on it!

Haha, yes I did - so hopefully I didn't make any mistakes (I punched most numbers twice per station to make sure they check out).

And great to hear you are working on a calculator! I've been dying for something like that.

I remember Xadrian's calculator back in the X3 days, I used it a lot!

Sparky Sparkycorp wrote:
Simoom wrote:I have waited, and waited, and waited... for someone to do a factory production calculator for XR... and nobody took up the mantle.
(The required data has been sitting around for a long while, too...)

Simoom wrote:If you are knowledgeable in coding, though... I was wondering if I might recruit you for a more ambitious project: Namely, we really need a XR production calculator (in similar fashion to the X3 one).

Would you happen to know how to make something like that?
On the same day that you first replied to the thread, Fenhris replied to mention a project which produced an Excel-based production calculator.

Whilst the download links are not working in that thread now, Fenhris is still posting so it would probably make more sense to contact that person before making one from scratch.

Sorry, but Fenhris's reply was from July of last year. Since no production calculator has surfaced, I just assumed the project fell through.

I'll take a look at his thread and see if there's any updates...

Edit - Yeah looks like both file links are down and there has been no new post in his thread since August. :/

Ezarkal · Post by **Ezarkal** » Mon, 21. Mar 16, 14:53

A while ago I made an excel spreadsheet on how many production module of each wares each station had. It's not much, but it's a good quick reference to figure out which station would be the best to patch up the holes in your production.

I can post it later tonight if anyone's interested.

ZonedOut · Post by **ZonedOut** » Wed, 30. Mar 16, 05:57

Ok, folks I had a few free moments this weekend and tonight. Here's a set of csv files with a wares dump, and a station production module dump. There are also 2 .odf file with pivot tables from the data. This stuff needs a lot of work and if someone can suggest a better arrangement for the data (or even a format that would allow for an sql import) I can probably pretty easily accomplish it.

Unfortunately it's not as straight forward as you would think as many station segments have no production modules, some have multiple production modules, and some modules rotate between mfg multiple wares. Again, any thoughts on how to express all this are welcome!

I should have the station build info in a similar format in a few days.

****Needless to say this code is very immature at this point so please check for accuracy when/where possible.

https://www.dropbox.com/s/89fp1pc1ax4vf ... ts.7z?dl=0

ZonedOut · Post by **ZonedOut** » Thu, 6. Jul 17, 22:32

Haven't played in a while, but since I have some time off this week I ran the 4.10 data files through:

https://www.dropbox.com/s/v8owdh05i8o31 ... xt.7z?dl=0

If anyone is still using them enjoy!