• From: Denver, CO
  • Registered: 2005-03-27
  • Posts: 3,578

Topic: Excel stat worksheet

No one you Know wrote:

> Please forgive my ignorance, but what does the pink box next
> to the combat rating represent? On some new ships I've
> designed it is sometimes a positive number and on some a
> negative number. Should it be the same as the rating? The
> Mass? Zero? A little help would be appreciated!
>
> I'm really enjoying working with this sheet (a breeze
> compared to Full Thrust, no offense!), but I want to
> understand if I've unbalanced my ships...

The pink box represents the number of Space Units remaining on your ship. If it is a negative value, then you need to take some things off... smile

Daniel Kast
Majestic Twelve Games
cricket@mj12games.com

mj12games's Website

  • Registered: 2005-03-28
  • Posts: 158

Re: Excel stat worksheet

Any chance the spreadsheet will get updated to *not* include the tech level modifier to those pieces of equipment that have been deemend uneffected by such considerations?

  • Registered: 2005-03-28
  • Posts: 158

Re: Excel stat worksheet

Can I get the list of equipment that is (semi-) officially not effected by tech? I know, someone told me before... I just cannot find the lest right now.

  • Registered: 2005-03-29
  • Posts: 859

Re: Excel stat worksheet

IIRC, it was a post by Dan around March...

I'll find it for you...

  • Registered: 2005-03-29
  • Posts: 859

Re: Excel stat worksheet

Armor Plating
Armored Gun Batteries
Cargo Bays
Construction Bay
Ionic Shielding
Medical Bay
Organic Hull
Passengers (100)
Redundant Shielding
Repair Bay
Science Lab
Shockwave
Stutterdrive
Troops (250)
Vehicle Bay

Here you go...:D

  • From: Denver, CO
  • Registered: 2005-03-27
  • Posts: 3,578

Re: Excel stat worksheet

KDLadage wrote:

Any chance the spreadsheet will get updated to *not* include the tech level modifier to those pieces of equipment that have been deemend uneffected by such considerations?

Done.

http://www.mj12games.com/starmada/sxca.xlt

Daniel Kast
Majestic Twelve Games
cricket@mj12games.com

mj12games's Website

  • Registered: 2005-03-28
  • Posts: 158

Re: Excel stat worksheet

Have I said lately what a great guy you are, Dan?

smile

  • Registered: 2005-03-28
  • Posts: 287

Re: Excel stat worksheet

Security teams are affected by tech level?

And stutterdrives aren't?

  • From: Denver, CO
  • Registered: 2005-03-27
  • Posts: 3,578

Re: Excel stat worksheet

Taltos wrote:

Security teams are affected by tech level?

Yup. I assume the space requirements for security teams (and marines, for that matter) represent equipment and such, not just "people space" as for troops and passengers.

And stutterdrives aren't?

Actually, stutterdrives are affected by tech level -- but it's the Engines TL, not the Special Equipment TL. (Stutterdrives take up 20% of the total engine mass).

Daniel Kast
Majestic Twelve Games
cricket@mj12games.com

mj12games's Website

  • Registered: 2005-03-28
  • Posts: 287

Re: Excel stat worksheet

cricket wrote:
Taltos wrote:

Security teams are affected by tech level?

Yup. I assume the space requirements for security teams (and marines, for that matter) represent equipment and such, not just "people space" as for troops and passengers.

For Marines I believe it - launch pods, heavy combat gear etc.
But small arms and flak vests don't seem like that much extra stuff... They are fighters but not combat troops. So I think our vision of security guards may be different.  smile

cricket wrote:
Taltos wrote:

And stutterdrives aren't?

Actually, stutterdrives are affected by tech level -- but it's the Engines TL, not the Special Equipment TL. (Stutterdrives take up 20% of the total engine mass).

I'll buy that.

  • From: Denver, CO
  • Registered: 2005-03-27
  • Posts: 3,578

Re: Excel stat worksheet

Taltos wrote:

For Marines I believe it - launch pods, heavy combat gear etc.
But small arms and flak vests don't seem like that much extra stuff... They are fighters but not combat troops. So I think our vision of security guards may be different.  smile

Perhaps.

But since TLs don't affect Combat Rating, we can have different versions of what is affected by TL and what isn't... and still have balanced fleets.

Ain't Starmada grand? smile

Daniel Kast
Majestic Twelve Games
cricket@mj12games.com

mj12games's Website

  • From: Denver, CO
  • Registered: 2005-03-27
  • Posts: 3,578

Re: Excel stat worksheet

samuel i. ulmschneider wrote:

> Just though I'd chime in here...if we were to see a revamp of
> the SXCA, some of the stuff I'd love to see included is:
>
> 1) A create-your-own Special Equipment, where you just enter
> the DefRat modifier, Orat modifier and SU % of the given
> system and it plugs it in with the rest.
>
> 2) Inclusion of the optional fighters, and the other fighter
> squadron rule we were brainstorming on here a while ago.
>
> 3) Allowing an option for the use of the
> Energy/Ballistic/Kinetic system from B & K, along with B&K
> special equipment, like datalinks.
>
> I'm no Excel master, so I dunno how hard these would be to
> pull off, especially the fist -- but they seem like good
> ideas from here.

Indeed... they are all good ideas. And not TOO difficult to implement... smile

Daniel Kast
Majestic Twelve Games
cricket@mj12games.com

mj12games's Website

  • Registered: 2005-03-28
  • Posts: 287

Re: Excel stat worksheet

many have been implemented in a version the VBAMers are using...

big_smile