LBB 2 and/or High Guard Starship Design Spreadsheet

[Gruffty]

Has anyone got an Excel spreadsheet that will allow me build LBB 2 starships, or High Guard starships?

I think they've been mentioned in the past but I've searched and can't find any links to them.

Cheers, ducks

 

[Granpafishy]

I have one that I picked up from some where, but don't remember where. I also haven't really tried it out since I use T4's various systems. From the quick look I did at it though, it looks like it works. Let me know where you would like it sent.

 

[fredofmars]

For High Guard, you may want to try the High Guard Shipyard program by Andrew Moffatt-Vallence. One link to it is (scroll down a bit):
http://www.asbf58.dsl.pipex.com/BITS_website/

Andrew's program is not a spreadsheet (if you are specifically looking for that kind of interface), but it does a marvelous job of automating HG ship creation. I highly recommend it!

I know I have seen spreadsheets for LBB2 ship creation, but the LBB2 sequence is almost too easy to benefit from automation in my opinion. Automation for HG is quite helpful, and for the other sequences (MT, FF&S, etc.) is almost a necessity.

 

[robject]

I had some JavaScript that built Book 2 ships... it's almost absurd to write code and spreadsheets for Book 2, but still...

 

[Bob Weaver]

I agree with Robject. No offense to anyone, but BK2 design is so straitforward that all you'd need to do is make a simple 'accounting table' setup. Use Excel's formula format to keep a running count of total weight and cost as you add components for the different areas of the ship. IIRC, there are a few examples of simple and complex spreadsheets to be found over at the Yahoo Groups CT-Starships list. You have to subscribe to the group to access the files, but it's free and easy to do. Besides all the useful discussions that have gone on there.

Best Regards,

Bob

 

[Fritz_Brown]

I have an Excel sheet, Grufty. PM me and let me know where to email it. (I have sent it ot Andy Fralix, before.)

 

[Gruffty]

Thanks to you all - I don't think I was very clear about what I wanted.

Thanks Frtiz88, PM is on its way.

 

[robject]

Here's the JavaScript I wrote ten years ago. It ain't pretty, and I don't even think it's right. It does things that Book 2 isn't supposed to do... and it doesn't do things in an orthodox way. And it doesn't do weapons!

So it's not really any help for you, I guess. But I thought I'd post it for amusement value. And mine. On second thought, I may actually tweak this a bit. Hmmmm.

http://eaglestone.pocketempires.com/scripts/SDC.html

My goodness... it's some unholy combination of Book 2 and High Guard. And it seems to work. I'm going through the code to see if there are any obvious bugs.

The drive volumes are per High Guard. In fact, it seems to be rather more High Guardian than Book 2. So it's not Book 2 after all. That makes sense, because there aren't any drive charts.

Hmmm, I bet I could adapt this to my Technical Architecture scripts... hmmmm.

 

[Ulsyus]

I have an Excel sheet, Grufty. PM me and let me know where to email it. (I have sent it ot Andy Fralix, before.)

Any chance of getting a copy of your spreadsheet?

 

[aramis]

I've got a decent one for Apple's Numbers. But I've noticed that Mac users are rare on COTI...

 

[agorski]

I've got a decent one for Apple's Numbers. But I've noticed that Mac users are rare on COTI...

Is that the one that I did a few years back for High Guard? It might be convertible to Excel. The zip archive includes a version in Excel format that I exported out of Numbers, but since I don't have Excel I can't tell if it will work or not.

If anyone's interested, it's here:

http://rpggeek.com/filepage/57088/high-guard-ship-design-spreadsheet-v1

There's also a small craft design spreadsheet in the RPGGeek files section under High Guard as well.

 

[aramis]

Is that the one that I did a few years back for High Guard? It might be convertible to Excel. The zip archive includes a version in Excel format that I exported out of Numbers, but since I don't have Excel I can't tell if it will work or not.

If anyone's interested, it's here:

http://rpggeek.com/filepage/57088/high-guard-ship-design-spreadsheet-v1

There's also a small craft design spreadsheet in the RPGGeek files section under High Guard as well.

Nope. I built from scratch.