Pilot Archive

I've made this for myself to check on my ships total Drains with Overloads on incase of a WO3 fix. Anyway i've tidied it up for public consumption and thought i'd put it out here.

Its simple spreadsheet, put your reactor energy in the top column and then the drain stats in the appropriate boxes, and the levels of the overload you're using and it calculates the overloaded drain and adds up the total drain. There's a nice big warning sign at the bottom that tells you when you've over as a added bonus.

Anyway, if anyone has any problems with it, just post it here.

EDIT: Last one i hope. This should be fully working.

Message Edited by Higginsis on 09-27-2005 05:01 PM

As always, most of you Corr folk make this game livable despite the devs best attempts to sabotage it

Thank you for this.

I have a word program that does something similar, but nothing neat and tidy.

Did something similar a while back:

Links to my old Excel spreadsheets for REing (zeroed out, yet still have hot-coded cells):

Capacitors (covers L4, 6, 8, & 10)

Engines (covers L6, 8, 10)

Shields (covers L8 and 10)

Weapons (covers L5-10)

For those of you who are Excel-inclined, the formulae driving the cells are located in white text one or two cells right of the MAX/MIN data column. Highlight them and you should be able to see. Obviously - if you were to retool these, the Weapons would be the best place to start, as it offers the greatest cross-section.

It also calculates averages and post-RE values as well as earmarks your personal bests in the categories.

double check the engine over load drain, it doesnt show up for me.

Good stuff.

As mentioned, some of the formulae are off (you're using the wrong values for the weapon drain, the weapon drain formula is referencing the wrong cells,and the engine total is calculating). You can also get away with not using $ cell references. Sheetsscale better when it's not static like that.

Also, I'm pretty sure its not x + (x*%). Based on one of my current setups, your sheet says I can't run EO4, which my opponents can tell you isn't the case I think it's actually just x*%.

If you'd like, you can check the changes I made: http://www.idolatry.org/uploads/OverloadReactorCalc.xls

perhaps we'll need this sooner rather than later.

---

quadpers0n wrote:

perhaps we'll need this sooner rather than later.

---

You know something we don't? *pokepoke*

Message Edited by quadpers0n on 09-27-2005 04:26 AM

---

quadpers0n wrote:

---

Can you, then, confirm or deny that you're currently bound by an NDA?

So you're just rumour-mongering then, and just getting us all excited over nothing?