CC.xls V2.1! & FCC.exe V2.0.0.2 ("the old thread")
Posted: Tue, 10. Jan 06, 21:10
Please use the new thread for discussion and download of Merroc's Complex Calculator:
http://forum2.egosoft.com/viewtopic.php?t=165330
Dave Toome Standalone Factory Complex Calculator has its own thread as well:
http://forum2.egosoft.com/viewtopic.php?t=165356
--Old text below--
This sheet has a lot of functions. The main one being a complex calculator, with which you can calculate (amongst other things) the input and output of your complex.
Some other features are a data sheet of all factories, prices of wares, asteroids and a yield calculator.
I shall demonstrate the use of the main function with a small example.
As you can see in the following picture, I have already entered all the factories in my sheet, including the number of factories and for the Silicon Mine the yield of the asteroid I built it on. All I have to do now is hit the big "Calculate Already!" In the upper left of the sheet.
[ external image ]
(1600x1200 203kb)
Entering the data is very easy with a drop down list for the race and for the factory. If the race doesnt sell the selected factory, you will see a number of red exclamation marks in the blue column to the right. The number of factories and the yield are just plain numbers.
With "I already own this factory" you can specify whether this factory's price will be included in the total cost of this complex. Leaving it blank (as i have done) will be the same as saying "No" (I have to buy this factory). The "Cost per factory" and "cost per factory type" are filled in automatically and shouldnt require changing.
That is all the input work you need to do. Everything right of the first blue column is output data (except one small bit, as you will see).
The output side is a bit to the left, and will look like the following after I hit the calculate button.
[ external image ]
(1600x1200 236kb)
The only thing you might want to alter here is the price column. The prices which are taken by default (open cell) are the average prices mentioned on the prices sheet.
As you can see, every ware important for your complex is mentioned in the output. Together with its max stock, excess or shortage, production efficiency (the excess/shortage in percentages, 100% means you produce as much as you use), whether the ware is a product, recourse or intermediate. How many NPC (S-size) factories you need in your direct surroundings to be able to sell of the excess (or buy the shortage, but they can be off in several occasions).
As already mentioned in the prices column you can enter your own prices which you have set for your complex. If you need to know the range, you can look at the Prices Data sheet. From the prices and excess/shortage the Turnover/Costs per hour are calculated.
Clearly I should include an Ore Mine and perhaps a bigger Rastar Refinery. As I seem to have a shortage of these two wares. Of course I could also choose to buy these wares from the NPC factories.
Between the last two blue columns you will see the 'totals' of your complex. Most should be self-explanatory. To highlight the two that might mean the least, Efficiency means how much percentage of the max achievable profit you earn at these price levels. And number of free nodes is to help with the Complex CTD discussion going on in the forums.
Finally I want to explain the two buttons and checkbox next to the Calculate button. "Export" will copy all the contents of this sheet to a new one. It will remove all buttons, however you will still be able to set your prices. For this it will ask you a new name for the sheet generated. The new sheet will be placed right in front of the complex calculator sheet and after that, the input side of the complex calculator will be cleared so you can enter a new complex.
"Clear Input quickly clears the input so you don't have to do it yourself and risk you remove an essential formula.
"Check if you sell the excess ore/silicon & buy the needed crystals", this option is turned off by default. If you check this box, the situation is default. e.g. normally you will have a small crystal shortage per SPP-Crystal Fab combination (about 2 per hour per SPP M). However with this box unchecked (since most people will prefer this) the sheet will simply lower the total production of EC by the ammount of Crystals you would otherwise buy. The same happens with the Silicon/Ore only this time you usually have an excess, with this box unchecked you will not sell this excess and thus save a couple of Energy Cells. In the above example I have this box unckecked. This situation would look as the following with the box checked:
[ external image ]
(1600x1200 238kb)
As a final (and most important note): This sheet is only compatible with Excel. Not the windows Excel viewer and Not Open Office.
===== Old topic text =====
Wondering whether to build that complex? Want to know how much you are actually earning with that complex? Or simply wondering what your next complex can be? Well, here's the answer!
I have made you all a nice Complex Calculator (in Excel naturrally)!
I seriously want to start by saying: you need to enable macro's, else the sheet is (on the complex side) useless.
And now, the question thats burning on all your lips, what does your sheet do?
Well, as the name already suggests it makes calculations about a Complex. What kind of calculations?
Well, here's a list:
Per Ware:
Max Stock
For Sale / hour
To Buy / hour
Product / Intermediate / Recourse
Turnover / hour
Costs / hour
Totals:
Turnover/hour
Costs/hour
Profit/hour
Total Costs Complex
Break Even (hour)
Profit/day
Max Profit/hour
Avg Profit/hour
Min Profit/hour
Does that sound as impressive as the masses of formula's and VBA code thats behind it? I do hope so!
For more information, i suggest you download the workbook, as there is quite some text there.
I hope its very usefull for you and that you may have lots of profitsss with it .
Feedback is very much wanted! Ideas, pointers, errors, please: LET ME KNOW. I want to improve it. Im especially interested in what kind of data (useless for all i care) about the complex. A lot is posible, please give me ideas .
==== Standalone version by Dave Toome V2.0.0.0 ====
http://forum2.egosoft.com/viewtopic.php ... 95#1561795
Thank you for taking the time to read this.
Original Asteroids sheet topic:
Asteroid Sheet *spoiler*
Cheers,
Merroc
V2.1 - 20 / 12 / 06
V2.0! - 10 / 11 / 06
V1.15 - 16 / 06 / 06
V1.14 - 18 / 04 / 06
V1.13 - hasnt been made public
V1.12 - 22 / 02 / 06
V1.11 - 17 / 02 / 06
V1.10 - 12 / 02 / 06
V1.09 - 26 / 01 / 06
V1.08 - 24 / 01 / 06
V1.07 - 16 / 01 / 06
V1.06 - 16 / 01 / 06
V1.05 - 12 / 01 / 06
V1.04 - 11 / 01 / 06
V1.03 - 11 / 01 / 06
V1.02 - 11 / 01 / 06
V1.01 - 10 / 01 / 06
http://forum2.egosoft.com/viewtopic.php?t=165330
Dave Toome Standalone Factory Complex Calculator has its own thread as well:
http://forum2.egosoft.com/viewtopic.php?t=165356
--Old text below--
This sheet has a lot of functions. The main one being a complex calculator, with which you can calculate (amongst other things) the input and output of your complex.
Some other features are a data sheet of all factories, prices of wares, asteroids and a yield calculator.
I shall demonstrate the use of the main function with a small example.
As you can see in the following picture, I have already entered all the factories in my sheet, including the number of factories and for the Silicon Mine the yield of the asteroid I built it on. All I have to do now is hit the big "Calculate Already!" In the upper left of the sheet.
[ external image ]
(1600x1200 203kb)
Entering the data is very easy with a drop down list for the race and for the factory. If the race doesnt sell the selected factory, you will see a number of red exclamation marks in the blue column to the right. The number of factories and the yield are just plain numbers.
With "I already own this factory" you can specify whether this factory's price will be included in the total cost of this complex. Leaving it blank (as i have done) will be the same as saying "No" (I have to buy this factory). The "Cost per factory" and "cost per factory type" are filled in automatically and shouldnt require changing.
That is all the input work you need to do. Everything right of the first blue column is output data (except one small bit, as you will see).
The output side is a bit to the left, and will look like the following after I hit the calculate button.
[ external image ]
(1600x1200 236kb)
The only thing you might want to alter here is the price column. The prices which are taken by default (open cell) are the average prices mentioned on the prices sheet.
As you can see, every ware important for your complex is mentioned in the output. Together with its max stock, excess or shortage, production efficiency (the excess/shortage in percentages, 100% means you produce as much as you use), whether the ware is a product, recourse or intermediate. How many NPC (S-size) factories you need in your direct surroundings to be able to sell of the excess (or buy the shortage, but they can be off in several occasions).
As already mentioned in the prices column you can enter your own prices which you have set for your complex. If you need to know the range, you can look at the Prices Data sheet. From the prices and excess/shortage the Turnover/Costs per hour are calculated.
Clearly I should include an Ore Mine and perhaps a bigger Rastar Refinery. As I seem to have a shortage of these two wares. Of course I could also choose to buy these wares from the NPC factories.
Between the last two blue columns you will see the 'totals' of your complex. Most should be self-explanatory. To highlight the two that might mean the least, Efficiency means how much percentage of the max achievable profit you earn at these price levels. And number of free nodes is to help with the Complex CTD discussion going on in the forums.
Finally I want to explain the two buttons and checkbox next to the Calculate button. "Export" will copy all the contents of this sheet to a new one. It will remove all buttons, however you will still be able to set your prices. For this it will ask you a new name for the sheet generated. The new sheet will be placed right in front of the complex calculator sheet and after that, the input side of the complex calculator will be cleared so you can enter a new complex.
"Clear Input quickly clears the input so you don't have to do it yourself and risk you remove an essential formula.
"Check if you sell the excess ore/silicon & buy the needed crystals", this option is turned off by default. If you check this box, the situation is default. e.g. normally you will have a small crystal shortage per SPP-Crystal Fab combination (about 2 per hour per SPP M). However with this box unchecked (since most people will prefer this) the sheet will simply lower the total production of EC by the ammount of Crystals you would otherwise buy. The same happens with the Silicon/Ore only this time you usually have an excess, with this box unchecked you will not sell this excess and thus save a couple of Energy Cells. In the above example I have this box unckecked. This situation would look as the following with the box checked:
[ external image ]
(1600x1200 238kb)
As a final (and most important note): This sheet is only compatible with Excel. Not the windows Excel viewer and Not Open Office.
===== Old topic text =====
Wondering whether to build that complex? Want to know how much you are actually earning with that complex? Or simply wondering what your next complex can be? Well, here's the answer!
I have made you all a nice Complex Calculator (in Excel naturrally)!
I seriously want to start by saying: you need to enable macro's, else the sheet is (on the complex side) useless.
And now, the question thats burning on all your lips, what does your sheet do?
Well, as the name already suggests it makes calculations about a Complex. What kind of calculations?
Well, here's a list:
Per Ware:
Max Stock
For Sale / hour
To Buy / hour
Product / Intermediate / Recourse
Turnover / hour
Costs / hour
Totals:
Turnover/hour
Costs/hour
Profit/hour
Total Costs Complex
Break Even (hour)
Profit/day
Max Profit/hour
Avg Profit/hour
Min Profit/hour
Does that sound as impressive as the masses of formula's and VBA code thats behind it? I do hope so!
For more information, i suggest you download the workbook, as there is quite some text there.
I hope its very usefull for you and that you may have lots of profitsss with it .
Feedback is very much wanted! Ideas, pointers, errors, please: LET ME KNOW. I want to improve it. Im especially interested in what kind of data (useless for all i care) about the complex. A lot is posible, please give me ideas .
==== Standalone version by Dave Toome V2.0.0.0 ====
http://forum2.egosoft.com/viewtopic.php ... 95#1561795
Thank you for taking the time to read this.
Original Asteroids sheet topic:
Asteroid Sheet *spoiler*
Cheers,
Merroc
V2.1 - 20 / 12 / 06
V2.0! - 10 / 11 / 06
V1.15 - 16 / 06 / 06
V1.14 - 18 / 04 / 06
V1.13 - hasnt been made public
V1.12 - 22 / 02 / 06
V1.11 - 17 / 02 / 06
V1.10 - 12 / 02 / 06
V1.09 - 26 / 01 / 06
V1.08 - 24 / 01 / 06
V1.07 - 16 / 01 / 06
V1.06 - 16 / 01 / 06
V1.05 - 12 / 01 / 06
V1.04 - 11 / 01 / 06
V1.03 - 11 / 01 / 06
V1.02 - 11 / 01 / 06
V1.01 - 10 / 01 / 06