Production Cost Analysis @ sourceforge.net

[SirGrey]

Current Release 1.17.50.0.0

Monitor Releases (RSS-FEED)

The Production Cost Analysis went to sourceforge.net! The Spreadsheet will be released over sourceforge.net from now on – you will find a download link on the main page of the project. We will keep track of all the work that must be done or any bugs or other requests using the tracking system provided by sourceforge. To make it easier for You here are some direct links:

((Main Page / DOWNLOAD))

Bug Tracking / Support Requests

If you are interested in helping us to maintain this spreadsheet, please register at sourceforge.net using this link, visit the project main page and send a message to the project admin, so he can add you to the developer team.
You can also support this project with your Donation.

Description
This spreadsheet should help everyone who is involved in the economy to calculate the production costs of any item he is producing. It is not intended to be used as a buyers guide.
Within the spreadsheet you will have multiple options to set it up for your personal needs. I.e. you can choose what structures you call your own and it will also keep track of the turn in rates at the euro traders regarding your reputation.

Content
- All recipes available in game
- All recipes with detailed lists of resources needed
- Prices tab with Quick Calculation, Multipe Sales Calculation and detailed price overview
- Euro trades tab with all possible Euro turn ins, including Euro-Turnin-Tracker
- An Economy Administration Tab, to administrate economy groups.

History
The first version of this spreadsheet was released by Monthar while the game was still in closed beta. At the point while the game went live there was an intention to have one society webpage to provide the sheet exclusively. After a few weeks it was brought back to the FLS forums again and Monthar maintained it up to Version 1.2.x. After Monthar was caught by his real life, the work was taken over by several people, but overall it took pretty long to keep the sheet up to date. With version 1.5.48.0.0 SirGrey decided to bring up this decent work up to sourceforge.net to give it a kind of revival. The intention was that the sourceforge system would make it easier to maintain the spreadsheet and provide it.

Credits:
Initial Work: Monthar
Current Maintainer: SirGrey
Contributors: Monthar, Valeroth, SirGrey, Compass Rose, FantastickMaman, denmj, TomSavage, shadowsong42, kurtilator, taronstar and the countless folks who pointed out any errors or missed recipe changes. Shadowsong42 gave better, dynamic, rounding formulas for the prices page, which are now in place.

[Cpt Crunch]

You guys are fantastic, and I cannot thank you enough for keeping this tool maintained and updated.

Cheers, and well done!

[SirGrey]

Just want to ask you guys, if you would be interested in something like a "shopping cart".

I am thinking about a clickable button in the prices tab wich will ad the selected item to a specific table. Well unfortunetaly i think this could only be solved using a macro and I know that many ppl dont like them. So let me know what u are thinking about this idea.

[Capitán Franco]

I downloaded the new version and began changing a few settings. However, the tax settings do not coincide with the game. There is not a 30, 60 or 80% option.

[SirGrey]

Originally Posted by Capitán Franco I downloaded the new version and began changing a few settings. However, the tax settings do not coincide with the game. There is not a 30, 60 or 80% option.

please make a bug report on the sourceforge site and we will take care of it

[Capitán Franco]

Originally Posted by SirGrey please make a bug report on the sourceforge site and we will take care of it

Will do from home, for some reason SourceForge keeps crashing my work PC. By the way, thanks so much for maintaining this awesome tool, MUCH APPRECIATED!

[TheRooster]

Originally Posted by Capitán Franco I downloaded the new version and began changing a few settings. However, the tax settings do not coincide with the game. There is not a 30, 60 or 80% option.

Just go to the "Drop Down Menus" page and change the values in the top left corner to 5, 30, 40, 60, 80.

BTW SirGrey, if you would like some help with this I have quite a few improvements I always make to my copy and others might like.

I think instead of a shopping cart, we just add a column to the prices page for QTY and then add a cell for each item that list the total price. I think we can simplify the price sheet down to one percentage markup.

I also want to tweak the hours column on the price sheet to show the total hours for a part including the hours of all the components required to make the part. Maybe just add a new column.

[SirGrey]

I just finished the update to v1.5.48.4.1. I decided to release this version before I go on vacation for 6 days, so you will be able to test it.
It should be stable and all submitted bugs are solved, except one. This issue is postponed until FLS is responding to my ticket, because it seems that there is an issue on their side. For details check the Tracker system.

So happy hunting and trading guys. CU next week.

[SirGrey]

You can monitor releases without reading this thread all the time. To do so, you must be registered on sourceforge.net. Once you are monitoring the releases you will get an email on every change that is made. To monitor releases use the following link:

Monitor Releases

[Huneypie]

Thanks All for doing this.

Since v1.4 the Consumable Items: General
Bandages & Smelling Salts
were collasped into the rest of the Consumable Items.

Now added as Feature Request on SourceForge Tracker