Sheet to help with Recource for production and building

[Fenhris]

EDIT 27-03-2016:
New link for the file:
http://fenhris.dk/XRfiles/X-Rebirth%20S ... lding.xlsm

This new link should work, and shouldnt stop all of a sudden. I am hoping to make new changes to the file, but I am still somewhat weak after a nasty flu or something .

Disclaimer:
This sheet is pretty useless without Macros switched on. Should your computer call it self "Skynet" and start a neuclear war, I will not take responsibility.
This is a pretty early stage. It works, but not any way near perfect.
I am hoping to write some instructions for it, if I see interest for this sheet, but for now? I am a little tired, so you will need to experiment
You will need some basic understanding of Excel to use, and preferably knowledge of Pivot tables.
You can add stations, but you cannot automatically remove them. This has to be done manually, if you can find the right sheet.
I may have a few numbers wrong. Its a LOT of data collecting.
It is easy to make mistakes with this. If you know excel, you should be able to find it pretty easy, delete faulty modules, and start over
This sheet blindly adds the module to your station that you request. I am hoping to change that at some point.
The dropdown lists are a working a bit odd. You may have to rechoose an option, even if the sheet is showing an option as chosen, before it filters to sub lists.

The only instruction you will have for now:
If you add data to the "Station Data" tab, make absolutely sure you add the right data to the right columns.
When you are finished be sure to push the green button at the top left corner, or your data will not be used propperly.
You can correct or add data to the "warelist", no update button needed here, but be aware that you need to fill in right data for right columns.
Also, if you add a station that produces/needs a ware not in the warelist, data will not be usefull for that ware/station.

The reset button in the WIP sheet is in case the sheet comes out with an error.
After an error, you will notice that the sheet doesnt update dropdown lists, and the reset button will make sure this is reactivated.

Ok. enough for now. Hope someone can use it, even in the state it is now.

Fenhris.

[Stonehouse]

Dont want to create an acc there, or does it work without?

[Fenhris]

Dont want to create an acc there, or does it work without?

If you manually copy the right data from the "Station Data" to "MyStations" and "Build Cost", insert the right formulas and update the 3 Pivot tebles, then yes, it will.

You may encounter some problems if you are adding more data to "Station Data", as this need updating on 2 sheets that are xlhidden.
You can manually make the 2 hidden sheets visible, and copy data in to those manually. I cannot promise instructions will be made on this, so you have to study the sheet carefully

I am also updating a few functions in the sheet making it slightly easier to see where you should do what. Will be uploaded to night I expect.

[Fenhris]

Dont want to create an acc there, or does it work without?

If you manually copy the right data from the "Station Data" to "MyStations" and "Build Cost", insert the right formulas and update the 3 Pivot tebles, then yes, it will.

You may encounter some problems if you are adding more data to "Station Data", as this need updating on 2 sheets that are xlhidden.
You can manually make the 2 hidden sheets visible, and copy data in to those manually. I cannot promise instructions will be made on this, so you have to study the sheet carefully

I am also updating a few functions in the sheet making it slightly easier to see where you should do what. Will be uploaded to night I expect.

Ok, forget that post, just woke up, and didnt quite get what you ment, sorry

I thought the link should work without making an account at one.com, I am pretty sure other links to savefiles etc. worked?
Someone else having troubles?

[Stonehouse]

Nevermind ... Firefox didnt like it...opera worked

Nice work, i searched for a calculator



may take a look at:

arms tech fab : Plate Foundry

how did u get the production of Reinforced Metal Plating?

392 looks like u added the static bonus already (batch size: 320/h)

so u added 15% secondary to 392...may that didnt work

and if i choose the Plate Foundry twice... the 15% summed to 30% may i think it should still be 15% because u calculate the bonus for each modul on its own (foundry 1 gets 15% for secondary and foundry 2 gets 15%)

or did u calculate an other way and i'm wrong?

[Fenhris]

It is fairly easy to screw up the calculations in this sheet, atleast the way it is now.
In the Arms Tech you can only make one Plate Foundry for each station. This is why I made an option to give each station a unigue id. So, if you have 2 Arms Tech, you can make one ArmsTech called Albion, and another one called DeVries, the calculation should then seperate the bonuses.

Also, keep in mind that you have a base calculation, and the "Full" calculation that takes into account any bonuses.
In each production line the base calculation takes the basic bonuses that the module is born with, like Zoltek Bridges etc., but not the bonus for Sec. recource or specialists.
If you want to add specialist to a module you can only do so as you add the module. This is then done by writing a name in the field next to the "Specialist?" field.

I am uploading a new version of the sheet that should make it a bit easier to see what is what. It is only visual apearance, and then I locked the WIP sheet to make it easier to navigate without overwriting something.

There is no password for unlocking the sheet.

The Blue fields are for dropdown list, the green fields are for writing texts (Id of station and Name of specialist)

Very quick description of the 3 Pivot Tables in the sheet:
First one is a station overview. You can watch each station and see how each module produce, and watch the overall consumption and surplus of the station. Negative numbers are consumption, positive are surplus.

Second table is what I personally find the most usefull. Once you have keyed in all your stations (only Albion stations are in yet, and unfortunately not all modules or stations), you can see which wares you are not producing enough off for your empire, and which ones you might be able to use for sales. I usually use the sort tab in the sheet to eliminate things like missiles, turrets, empty and shields (anything you can be certain will not be needed for production elsewhere). This makes it a bit easier.

Third table is for planning of building stations. You can see how much material you need for building a certain amount of modules, and how space it will take on your construction vehicle. I find this usefull if you want to make a new station in an area that does not have access to building material (like Devries and Maelstrom), and then making sure the CV have the materials loaded before moving to the build site.

As said before:
Lots of data are still missing, and I am hoping to add them as I progress the game. However it is taking its sweet time, so if you dont want to add data yourself, you will need to be patient.

I am still hoping to make a manual for this sheet if interest is high enough, but as this will take some time, people will have to be patient.

If you have data to add to the sheet and are not sure how to add it, please upload an excelsheet with the data, and I will have it put into the sheet and upload the new version.

[Baconnaise]

This is interesting. Seems to work fine in Libre Office. I'm a little skeptical on how useful this actually is though.

[UniTrader]

regarding Data Collection: did you consider the possibility to read it directly from the Game Data?
it is definietly doable since all is defined in xml.
Ressources for all Wares are really simple because their production is defined in a single file, where for each ware one or more production methods are listed and for each method a product can be mmade there are the necesary primary ressources, time and secondary ressources (the latter with related production modifier, currently there are only speedups for production iirc)

second part is a bit more complicated: all factories are defined in a file for each (all in the same folder) and have production modules which produce a product with a certain method - combine this list with the former and you can create a complete List for all stations automatially

[Fenhris]

regarding Data Collection: did you consider the possibility to read it directly from the Game Data?
it is definietly doable since all is defined in xml.
Ressources for all Wares are really simple because their production is defined in a single file, where for each ware one or more production methods are listed and for each method a product can be mmade there are the necesary primary ressources, time and secondary ressources (the latter with related production modifier, currently there are only speedups for production iirc)

second part is a bit more complicated: all factories are defined in a file for each (all in the same folder) and have production modules which produce a product with a certain method - combine this list with the former and you can create a complete List for all stations automatially

Thanks an awfull lot for the tip, I will be looking into this very soon. Not sure anyone uses it besides me, but I for one will surely be happy to get all that data!


EDIT: Oh, by the way, will I have to do some unpacking of files for this? I tried looking through the mod instructions for extracting certain files for use in modding, made my head spin .

[YorrickVander]

I think it would be a very useful project. I was actually mulling something similar over - a localhosted map made from the xml for use in steam browser. There's a couple of nice maps out there but all are outdated and none can take installed mods into account. As roguey is no longer supporting X, the info on his site will become increasingly out of date too so again a locally generated browser tool would be ideal Go go go!

[Sparky Sparkycorp]

This sort of thing is very useful and will be more-so as industry is patched. Thank you very much!

[Fenhris]

OK, trying to look through the files from the XR.
I tried to extract everything, but after searching quite some time I have been unable to find the needed Data. I have been mostly looking through the "structures" in the "assets" directory.

Anyone have any help here? Where should I look?

I am absolutely NOOB when it comes to game files etc.

[Santi]

Found this some time ago, cannot remember who to credit for it so sorry about that, but I put in my Rebirth bookmarks, no a clue if is any help:

http://stuff.incertum.net/x-rebirth/

[Fenhris]

Found this some time ago, cannot remember who to credit for it so sorry about that, but I put in my Rebirth bookmarks, no a clue if is any help:

http://stuff.incertum.net/x-rebirth/

Thanks for looking Santi, but I found the XML file in the Rebirth Game Data.

To begin with I will use this data to update the data in the existing sheet, and make sure all wares and production needs are in.
- Once done I will upload a sheet with the added data

Second I will try and figuere how to extract the data for station building, and then update the sheet with that.
- Once done I will upload a sheet with the added data

Third, and this one will probably be a pretty big project, atleast for me ), I will try an figuere out how to connect to the datafiles in the XR dir. I am expecting that to begin with maybe the user will have to manually connect the sheet, and then later I will try and see if I can make the sheet automatically connect.

Fenhris

[UniTrader]

sorry, forgot to check for replies here ^^'' if you have specific questions feel free to PM me

for the Wares/Production Values look into libraries/wares.xml, there are all Product/Ressource combinations defined

for the Stations the Files you need are in assets/structures/buildtrees/macros, but those are juust refering to entrys in assets/structure/economy/*/macros (the former one defines which parts a Station is made of and at which building progress, the latter defines the individual parts of the Station and which Products they make)

[Ognjen85]

@Fenhris:

It seems that links you provided are no logger valid (files cannot be found).

Have you removed them?

I'm also doing some build projects atm (still on small scale) and having something like this would help a lot.

Perhaps if ES will improve NPC traders to work on universe scale I may start again DV re-civilization project

[Fenhris]

@Ognjen85:

Nope, didnt remove them, very strange they dont work. I will try and figuere it out within this week. Will also make sure to put in the complete build data for all stations.
I probably wont do it very soon, as I am just starting work after 3 weeks vacation, and I am somewhat tired

[Ognjen85]

Np. will monitor this thread for any news. I understand that putting all of that data in excel is not exactly an easy task to do and can become pain in the b...t... Stations productions and wares zhave changed a lot since x3 days and these calculations are not as simple as they used to be...

[Sparky Sparkycorp]

The new download link is working fine, thanks for updating it