Complex Calculator V3.0!!

[Merroc]

Download link: http://homepage.uvt.nl/~s108174/ComplexCalculations3.0.rar (136 kb).

Old topic (now locked): http://forum2.egosoft.com/viewtopic.php?t=120355
Topic for Dave's Factory Complex Calculator: http://forum2.egosoft.com/viewtopic.php?t=165356

With OpenOffice3 you can use this sheet as if it were Excel. I dont know details, but you might have to turn on a few options to get the macro working. With Windows Excel Viewer you can only read the file, but not use the macro or edit anything.
If you're having problems running the macro in Excel, it might help to download and install .net and the SP 1. Since i had no problems myself (maybe because i already have it) i cant see if this actually helps, but according to TomasArafel who pointed this out to me, it does...

If you dont have Excel, or having problems with my sheet, please check this online calculator by em3e3 (linked because im a nice person).

We all know what it does, well most of you do. So i'll keep it short in this new thread (more info to be found in the old thread though).

It does what the title says it does. It calculates the information you want for your complex. How much profit it will make, etc. But its much more than that. There's a lot of data in it as well.
Be sure to read the FAQ, it explains how you should use it. In short, every yellowish cell is something you might want to adjust, anything else, you better stay out of. you dont want to accidently remove an important formula .

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 you would like to know. A lot is posible, please give me ideas . Also if you think you've found a bug, please read the faq, see if it might be a feature .

As a final note, please do not link directly to the download link or host this file yourself (without explicit approval of myself). All links should either point to this thread (from now on) or to the old thread.

Original Asteroids sheet topic:
X3R: Asteroid Sheet *spoiler* (got brutally locked, i hope i dont have to change it!! )
X3TC: Merroc's Asteroid List (TC 1.4) (more spoilers inside)

Cheers,
Merroc

Filehistory:
V3.0 - 22 / 02 / 09 (yay 2 years later, time flies)
V2.2 - 9 / 01 / 07
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 (har har i was the first!! )

<- moar smileys because i can.

[Merroc]

You might be wondering why im making a new topic:
short reason: expandability for Dave's own Standalone Factory Complex Calculator. It deserves its own thread anyway. You will hopefully see his thread popping up soon .

(also i was getting confused by some replies thinking it was about my complex calculator, while it was about Dave's... )

[Merroc]

I'd like to make a note for users of Solar Power Plants in the sector Loomanckstrats Legacy. Due to its 0% sunlight, Solar Power Plants behave differntly in that sector. However, because its only one sector and who builds in 0% sunlight anyway? I have decided not to alter my sheet for this (too much work for too little gain imho).

See this thread for details about loomanckstrats legacy's SPP problem:
http://forum3.egosoft.com/viewtopic.php?t=165262

[western]

One quick question.

I have just started a new game and intend to use the XL factory script.

When can you integrate this mod into your BRILLIANT software?

Kind regards
Western

[Merroc]

How do you mean? You want to download Ashley's mod together with my sheet? Or do you mean i have to add the data and such from Ashley's mod?
If its the former: i wont. ever.
If its the latter: look again, i already did.

And if you;re talking about the Factory Complex Calculator, you might want to try the correct thread for that.

[golruul]

(2.1, macros enabled)
is anyone having trouble with the "Factories" sheet? It lists the Argon factories fine, but the other races' factories all have "#N/A" in the cells.

For what it's worth, I also have the 1.15 version and everything works great there.

[Merroc]

1600+ downloads this year alone and only just someone found out?
What do you all download it for?
Anyway, uploaded a same-version-number-fix.

[golruul]

[golruul]

in "Factories" sheet,

1 GJ S, L, and XL shield have the same Production/Turn values, resulting in negatives in the fourth column for L and XL


EDIT
Max Stock is also the same at 8
END EDIT

[Merroc]

Fine fine fine . Updated to 2.2. Also extended the Yield Calculator, saw i missed support for XL and XXL mines. And two other minor adjustments.

BTW, tomorrow i can celebrate the first aniversary of the complex calculator . I suspect an evening full of alcohol (something i would never *cough* ever *cough* do otherwise ).

[Litcube]

Is the Beta PBE Forge Meatstake Cahoona requirement correct? Version 2.2.

[Merroc]

It should be, i calculated it from the relvals... So i have no reason to suspect otherwise. Unless someone can prove me wrong ingame. Do note that they're L and XL...

[Litcube]

Every L sized laser requires an L sized Cahoona bakery. In this case, the output of cahoonas is 100% of the requirement.

Every XL sized laser requires an XL sized Cahoona bakery. In this case, the output of cahoonas is 100% of the requirement.

Except the Beta PBE Forge.

An XL Cahoona bakery only outputs 99.1% of the XL Beta PBE Forge. An L Cahoona bakery only outputs 99.1% of the L Beta PBE Forge.

[Merroc]

Looks like a typo sneaked in. Beta PBE L EC usage per cycle should be 11000, not 11100. Hence the Beta PBE XL EC usage is wrong and ditto for the Meatsteak/Ore usage. (caluclated directly from the EC usage).
This should be as followed:

[Litcube]

Oopsie Daisy!

Dude, that's some hardcore data entry. Why not write a script that outputs that stuff for you, and have excel auto-calculate for you? Or have you, and just kept the result data?