Post reply

Warning: this topic has not been posted in for at least 120 days.
Unless you're sure you want to reply, please consider starting a new topic.

Note: this post will not display until it's been approved by a moderator.

Name:
Email:
Subject:
Message icon:

shortcuts: hit alt+s to submit/post or alt+p to preview

Please read the rules before you post!


Topic Summary

Posted by: Cocyte
« on: February 08, 2013, 11:28:47 AM »

Can't find the source for the terraforming sheet... well, whatever.

Here is the thing :
http://www.petit-creux.fr/vrac/aurora/Aurora_l2.xls
on a general note :
- green cells are user-editable
- blue cells are automatically computed/filled
- purple cells are also automatically computed fields that are directly useable somewhere in game

"Missile est." is a way to design missiles of a given size. it is roughly equivalent of the Aurora missile designer, just even more confusing. And with rounding issues sometime...
"Missile lib" is a sheet for storing missiles designs. The macros are used to retrieve the data from the designer and export them back to the designer.
"Missile constants" stores the various tech levels relevant for the previous two sheets

"Terraforming" is the modified version of <sorry I can't remember who>'s terraforming sheet, taking into account the existing atmospheres of bodies and giving a rough estimation of the value of a given world.

The next three tabs are for prebuilding ship components...
"Eq Def" stores the definition of the various components. Only the name and the cost of the components are useful. (Also, the "color code" is not relevant on this sheet - it was just a way to ease readability of the otherwise horrible list)
"Ship def" holds the list of buildable components for the various ships
"Prebuild planning" allows to select a given ship, choose how many of those you'll want to build and how much industry you'll put on the job.
It will output the number and percentage allocation for each components.

Have fun, but don't expect much customer service...

EDIT :
A decent computer available, at last! Updated the spreadsheet...

- Added the "Sync planning" sheet (can be used to plan simultaneous impact of missile salvos with different speeds for example)
- Added sensor calculations in the "missile est." sheet
- Updated the "Missile lib." sheet and macro accordingly
- Added an indication of the final colony cost of partially terraformable worlds and multiple race management in the terraform sheet (for the few gene engineers or the more common conquerors of alien nations)
- 2014-07-31 : Added multiple ship selection on the component prebuild planning sheet - Up to 3 different classes can be selected.

As usual, any form of customer service is purely coincidental.
Posted by: Garfunkel
« on: February 03, 2013, 12:11:26 PM »

I need to start an Excel sheet as well, thanks for the idea. How I didn't realize that on my own, I'll never know...  :-[
Posted by: rawghi
« on: January 24, 2013, 02:24:26 AM »

Does anyone else see the irony in this thread? :)

John

I feel it after I clicked the "post" button! :)
Posted by: Conscript Gary
« on: January 23, 2013, 09:20:25 PM »

Found it. The missile sheet in particular was useful for keeping track of submunition release ranges.
Of course this was before the sensor buoy fixes of 6.2, so the game itself died.
Posted by: sloanjh
« on: January 23, 2013, 09:19:16 PM »

Posted by: Execrated1
« on: January 23, 2013, 09:13:15 PM »

That is one of the biggest problems I have.  For immersion purposes I always invent companies to make different components.  And then I forget which company makes what lol.  I've taken to writing it down.  Benckiser makes commercial engines, MHill Tek and Prism Industries make active sensors, Tokyo Electric makes passive sensors, , and I can't remember the rest now that I'm not near my computer desk.
Posted by: Conscript Gary
« on: January 23, 2013, 08:43:29 PM »

For a recent game I set up a google doc to keep straight the myriad corporations I had chosen to manufacture my components, as well as said components in a way the tech report wasn't quite capable of.
Posted by: Execrated1
« on: January 23, 2013, 07:46:11 PM »

Yes sir, a game based on pen and paper 4x space sims, designed to get rid of said pen and paper, needs pen and paper to make things more manageable.  It's the circle of life.
Posted by: sloanjh
« on: January 23, 2013, 07:21:39 PM »

Does anyone else see the irony in this thread? :)

John
Posted by: rawghi
« on: January 23, 2013, 11:27:48 AM »

I'm also using an excel sheet for a lot of planning.
- One sheet is for fleet synchronisation/ETA computations
- 3 sheets are for missiles (One for missile design, one for the library, one for the various constants)
- A single sheet for terraforming computation (how many gasses are needed, estimated duration for terraforming, estimation of the terraforming class of the planet...)
- 3 sheets for ship component prebuilding planning (one listing the components, the second the ship setup, the last one giving the industry percentages to use for each component in order to have them all built on the same day. Did you know you can use decimal percentages on industry allocation?)

Perhaps I should share it... Trouble is the terraforming sheet is (a quite modified version of) a sheet from someone else, and I can't remember who this "someone else" was... and I don't want to looks like stealing his work.

 :o holy s....!!
they must be helpful, especially the terraforming ones
Posted by: Cocyte
« on: January 23, 2013, 11:17:26 AM »

I'm also using an excel sheet for a lot of planning.
- One sheet is for fleet synchronisation/ETA computations
- 3 sheets are for missiles (One for missile design, one for the library, one for the various constants)
- A single sheet for terraforming computation (how many gasses are needed, estimated duration for terraforming, estimation of the terraforming class of the planet...)
- 3 sheets for ship component prebuilding planning (one listing the components, the second the ship setup, the last one giving the industry percentages to use for each component in order to have them all built on the same day. Did you know you can use decimal percentages on industry allocation?)

Perhaps I should share it... Trouble is the terraforming sheet is (a quite modified version of) a sheet from someone else, and I can't remember who this "someone else" was... and I don't want to looks like stealing his work.
Posted by: rawghi
« on: January 23, 2013, 10:51:18 AM »

Hi mates!
I'm just curious to know what you'll use to better handle your Aurora games, software, tools, sheets, etc...
I usually use an Excel file with a tons of sheets, usually organized in this way:

Ship registry (registry of the ships)
Ship classes (list of classes)
Defence systems (shields, ciws, etc..)
Engines
Beam weapons
missiles
naming conventions
formulas (HP to tons etc..)
and much more...

but I'm also struggling to thinking about some sort of visual representation of my fleets/systems without finding a proper solution (I've also tried to make custom starhips with GalCiv 2 but I finished spending more time on it than in aurora...)

And you?