Topic: Fighter Spreadsheet

I'm having a bunch of fun with the new ship builder so I decided to create one for fighters, strikers, and seekers:

http://spreadsheets.google.com/pub?key= … hJCHsNaHbA

Re: Fighter Spreadsheet

ToddW wrote:

I'm having a bunch of fun with the new ship builder so I decided to create one for fighters, strikers, and seekers:

Man, but I'm feeling technologically incompetent lately.

I can't make it do anything. sad

Daniel Kast
Majestic Twelve Games
cricket@mj12games.com

Re: Fighter Spreadsheet

cricket wrote:
ToddW wrote:

I'm having a bunch of fun with the new ship builder so I decided to create one for fighters, strikers, and seekers:

Man, but I'm feeling technologically incompetent lately.

I can't make it do anything. sad

Don't feel bad Dan. I got bunko as well. :?

Re: Fighter Spreadsheet

Might help if you just made an Open Office sheet - that page comes up as HTML for me...

Re: Fighter Spreadsheet

It's probably my fault.  I'm not sure how to allow others to use the file I posted to google.

Re: Fighter Spreadsheet

ToddW wrote:

It's probably my fault.  I'm not sure how to allow others to use the file I posted to google.

If it's an Excel spreadsheet, for now can't you post it in the files section over on the egroup?

Re: Fighter Spreadsheet

Where is the e-group?

Re: Fighter Spreadsheet

http://games.groups.yahoo.com/group/mj12games/

Technically, it's a *Yahoo* group.....
big_smile

I confused you with Todd Pote. I don't know why, as he's 'googleplex' here on the forum...
smile

Re: Fighter Spreadsheet

:twisted:

Re: Fighter Spreadsheet

Chalk it up to high blood sugar and low caffeine.

When ToddW asked about the Yahoo group, I was like "Wait a sec..."

DOH!

Re: Fighter Spreadsheet

thedugan wrote:

http://games.groups.yahoo.com/group/mj12games/

Technically, it's a *Yahoo* group.....
big_smile

I confused you with Todd Pote. I don't know why, as he's 'googleplex' here on the forum...
smile

Thanks, it's been a while since I logged into the group.  I uploaded the file.

BTW, I'm the better looking Todd  :oops:

Re: Fighter Spreadsheet

ToddW wrote:
thedugan wrote:

http://games.groups.yahoo.com/group/mj12games/

Technically, it's a *Yahoo* group.....
big_smile

I confused you with Todd Pote. I don't know why, as he's 'googleplex' here on the forum...
smile

Thanks, it's been a while since I logged into the group.  I uploaded the file.

BTW, I'm the better looking Todd  :oops:

Probably true there. *chuckles*

Re: Fighter Spreadsheet

Been playing with the spreadsheet, and I've noticed it doesn't calculate the value of the fighter flight.....unless that's something that didn't make it when Open Office converted the sheet.

Also, looking over the PDF and trying to make Hydrans, I can see that we still don't have a way to build 'shuttles'....unless we make a really wimpy fighter and assume it's a shuttle. Not a real problem, just asking if anyone thinks it might be.

Also, anyone else wondered about how to make a 'ground assault shuttle' that carries troops?

Re: Fighter Spreadsheet

Perhaps and after calculation additional SU so if a ground assault shuttle was a standard fighter that carried 25 SU of aux: troops it would require 50+25=75 SU.

What do you mean by Hydrans?

Re: Fighter Spreadsheet

Cepheus wrote:

Perhaps and after calculation additional SU so if a ground assault shuttle was a standard fighter that carried 25 SU of aux: troops it would require 50+25=75 SU.

Hmmm.. just like Boarding pods. Okay, I didn't think to look there.

Cepheus wrote:

What do you mean by Hydrans?

Obviously, I couldn't CALL them Hydrans, but something like the Hydrans from Star Fleet Battles. They just came to mind because of the discussion about the fighter spreadsheet, nothing that I'm doing a lot of work on right now.

There was a discussion about converting SFB to StarmadaX a while back and I recently asked about it being ported to the S:A Edition....

Re: Fighter Spreadsheet

thedugan wrote:

Hmmm.. just like Boarding pods. Okay, I didn't think to look there.

Actually that just came off the top of my head. Which page does it state that on? I can not find it.

Re: Fighter Spreadsheet

thedugan wrote:

Also, looking over the PDF and trying to make Hydrans, I can see that we still don't have a way to build 'shuttles'....unless we make a really wimpy fighter and assume it's a shuttle. Not a real problem, just asking if anyone thinks it might be.

What would be the difference (in game play) between a shuttle and a fighter?

Also, anyone else wondered about how to make a 'ground assault shuttle' that carries troops?

Off the top of my head, I could see assigning an auxiliary capacity to fighter flights at a slight discount (80%?) since they are designed for short-range transport. e.g. a flight with Cargo (10) would add 8 to its capacity requirement.

Daniel Kast
Majestic Twelve Games
cricket@mj12games.com

Re: Fighter Spreadsheet

Cepheus wrote:
thedugan wrote:

Hmmm.. just like Boarding pods. Okay, I didn't think to look there.

Actually that just came off the top of my head. Which page does it state that on? I can not find it.

Color PDF, Page 38:  Appendix B(7) under Boarding Pods

Re: Fighter Spreadsheet

cricket wrote:

Off the top of my head, I could see assigning an auxiliary capacity to fighter flights at a slight discount (80%?)

Actually, I could go as low as 50%. Consider that a ship with Transport (100) is already "paying" for the mass of the troops -- so the "ground attack shuttle" would only need to account for the extra volume required to get the troops from the ship to the surface.

Daniel Kast
Majestic Twelve Games
cricket@mj12games.com

Re: Fighter Spreadsheet

thedugan wrote:

Color PDF, Page 38:  Appendix B(7) under Boarding Pods

I must be blind. Still not seeing it.  A standard Striker is 20 points and a boarding pod is 25, but if you are customizing do you just throw in 5 points at the end and if so where does it state that? Loosing my mind.  :roll:

Re: Fighter Spreadsheet

Cepheus wrote:
thedugan wrote:

Color PDF, Page 38:  Appendix B(7) under Boarding Pods

I must be blind. Still not seeing it.  A standard Striker is 20 points and a boarding pod is 25, but if you are customizing do you just throw in 5 points at the end and if so where does it state that? Loosing my mind.  :roll:

I am going to go hide in shame now. Too sleepy. I figured out what you meant now. Sheesh. Night all.

It's late, and I may have misread it... the capacity requirement of the BP's is 25.

This is why I stink at writing rules. ;/

Re: Fighter Spreadsheet

cricket wrote:
thedugan wrote:

Also, looking over the PDF and trying to make Hydrans, I can see that we still don't have a way to build 'shuttles'....unless we make a really wimpy fighter and assume it's a shuttle. Not a real problem, just asking if anyone thinks it might be.

What would be the difference (in game play) between a shuttle and a fighter?

Nothing, other than not having a gun and being explicitly able to carry things like cargo and troops. I think that we deferred some things like this until we started to work on settings, didn't we? It simply occured to me to ask (if sorta backing into it) if anyone really had a problem with it not being explicitly in there.

cricket wrote:
thedugan wrote:

Also, anyone else wondered about how to make a 'ground assault shuttle' that carries troops?

Off the top of my head, I could see assigning an auxiliary capacity to fighter flights at a slight discount (80%?) since they are designed for short-range transport. e.g. a flight with Cargo (10) would add 8 to its capacity requirement.

Good enough for me.

I like all the questions and such that are being brought up, it gives us an idea of what to look at later in the setting books.

I've gotten 4 or 5 digests in less than two days!

Re: Fighter Spreadsheet

thedugan wrote:

Nothing, other than not having a gun and being explicitly able to carry things like cargo and troops.

Oh, right. The "no weapon" bit would cause problems in the capacity requirement calculation, wouldn't it? smile

The other problem is that, whereas ships don't "pay" for their auxiliary space in terms of combat rating, fighters will inevitably do so, since capacity requirement = combat rating. So adding the ability for a fighter to carry cargo or troops or whatever will end up increasing the ship's CR (or make it use up some of the CR made up from its carrier value for fighters that have no combat usefulness)

I must stew upon this.

Daniel Kast
Majestic Twelve Games
cricket@mj12games.com

Re: Fighter Spreadsheet

cricket wrote:
thedugan wrote:

Nothing, other than not having a gun and being explicitly able to carry things like cargo and troops.

Oh, right. The "no weapon" bit would cause problems in the capacity requirement calculation, wouldn't it? smile

The other problem is that, whereas ships don't "pay" for their auxiliary space in terms of combat rating, fighters will inevitably do so, since capacity requirement = combat rating. So adding the ability for a fighter to carry cargo or troops or whatever will end up increasing the ship's CR (or make it use up some of the CR made up from its carrier value for fighters that have no combat usefulness)

I must stew upon this.

I think this is why we didn't address it, we knew starting down this way would be a long debate. It's not unsolvable, just more complications...and it's not essential.

I could not define the problem previously, but it was nagging me that somethign wasn't 'right' - you just defined the problem.

Hope I'm not making a stink. smile