Formula for bonus structure calculations - Page 3

snakeye · #21 May 6th, 2003, 03:32 PM

I forgot to thank Loser for his/her motivation for me to do this. Took me back to my school days and was a nice trip down memory lane. Thank you again bud. I dont have the graphs on the spreadsheet you requested, but would be nice to create them.

Loser · #22 May 6th, 2003, 03:58 PM

Christ in Drag!

Snakeye you rock! This verbose post belongs in the FAQ, I'd think. I am ecstatic to have this lengthy and complete explanation and even more pleased that you enjoyed pursuing my suggestion. You are more than welcome.

I'm sure someone can tell you where and how to upload that spreadsheet, and I was just joking about the graphs and the rest of the Alro Guthrie gibberish.

FadingSuns · #23 May 6th, 2003, 04:26 PM

Rock! Now this is what I'm talking about, math finally coming in handy for something other than figuring out all the deductions out of my paycheck. Snakeye, this really should go into the FAQ, you've just solved one of those questions that everyone has sooner or later about remote mining. Great job

Suicide Junkie · #24 May 6th, 2003, 05:59 PM

Quote:

-Player has already built the ship that he is going to construct BEFORE, so the maintenance cost is known. [sorry guys, thats the only way i know how to get the maintenance values. if someone has a better way, please let me know!]

Start at 25%. Subtract your maintenance reduction racial characteristic. (Commonly boosted to 20%; 25%-20% = 5%)
This is your actual maintenance cost per turn.

Multiply you ship's build cost by the above maintenance rate.
If you are looking at a base, rather than a ship, divide by 2.

If you have a crystalline restructuring plant in the system, take off another 5 to 15% depending on tech level.

This is how much you spend each turn for maintenance.

Fyron · #25 May 6th, 2003, 06:27 PM

Quote:

Commonly boosted to 20%

That isn't very common, as it is extremely expensive to do that, esp. in 2000 point games.

snakeye · #26 May 7th, 2003, 05:56 PM

anybody knows where i can upload a spreadsheet that has the formulae already in? Would be helpfull i think for anybody to use. As far as the maintenance is concerned, I think leaving the maintenance cost as a figure is less complicated.

Fyron · #27 May 7th, 2003, 07:55 PM

Go to the main Intel Forums page, and click on the Scenario/Mods Upload Category (first one). Upload it to the appropriate SE4 thread in there (probably Other Helpful Tools/Information).

snakeye · #28 May 16th, 2003, 02:18 PM

As promised, the excel file that utilises the formulae mentioned in the thread. I took the liberty and put some sample data into it to aid the understand of its functionality.

1053087403.zip

ENJOY!

[ May 16, 2003, 13:18: Message edited by: snakeye ]