Search found 103 matches

by bluekieran
Fri Mar 10, 2017 3:36 pm
Forum: Traveller
Topic: High Guard 2e Ship Design Spreadsheet v1.1 (Google Docs)
Replies: 53
Views: 9666

Re: High Guard 2e Ship Design Spreadsheet v1.1 (Google Docs)

Morning PST bluekieran, Should I be providing feedback here or is there another route that I should be following? Here is fine, I am on pretty frequently. I've been trying for an hour to open the latest version with out success my Firefox browser returns the message the connection has timed out. Ho...
by bluekieran
Fri Mar 10, 2017 1:29 pm
Forum: Traveller
Topic: High Guard 2e Ship Design Spreadsheet v1.1 (Google Docs)
Replies: 53
Views: 9666

Re: High Guard 2e Ship Design Spreadsheet v1.1 (Google Docs)

Just wanted to add my appreciation for creating and sharing this sheet. It's really helpful, thanks. Dan. Thanks, it's been an interesting project. I'm thinking about picking up the Vehicle Handbook and doing that one as a website, as I've at least as little web-coding clue as I had spreadsheet clu...
by bluekieran
Fri Mar 10, 2017 8:29 am
Forum: Traveller
Topic: High Guard 2e Ship Design Spreadsheet v1.1 (Google Docs)
Replies: 53
Views: 9666

Re: High Guard 2e Ship Design Spreadsheet v1.1 (Google Docs)

Yup, that would be correct. Yeah. So power plants are much more fuel-efficient in 10-ton increments, because technical reasons; a 1-ton or 11-ton plant is a real gas-guzzler. I do want the sheet to be usable for people playing RAW though; I'll put in a "Rules as Written / Accurate" drop-down choice.
by bluekieran
Fri Mar 10, 2017 8:03 am
Forum: Traveller
Topic: High Guard 2e Ship Design Spreadsheet v1.1 (Google Docs)
Replies: 53
Views: 9666

Re: High Guard 2e Ship Design Spreadsheet v1.1 (Google Docs)

I was also going over the fuel for X weeks operation formula today, as I was aware it was way off the example ships in HG. Turns out the HG rules round up when getting the 4 week figure, then just multiply that, which I guess you could justify somehow, but I don't love. i.e. 12 weeks operation will ...
by bluekieran
Wed Mar 08, 2017 7:28 pm
Forum: Traveller
Topic: Pocket Trader
Replies: 39
Views: 4460

Re: Pocket Trader

PsiTraveller wrote:
Wed Mar 08, 2017 5:28 pm
Bluekieran: That is why I added 4 tons of extra M Drive and 5 more tons of Jump Drive to maintain the Jump 2 capacity and Thrust 2. 5 Tons of Jump Drive allows 100 more tons of J2, so it is a good investment.
I missed that, apologies!
by bluekieran
Wed Mar 08, 2017 3:35 pm
Forum: Traveller
Topic: Pocket Trader
Replies: 39
Views: 4460

Re: Pocket Trader

Good catch, I missed the streamlined restriction. Jump Net it is then. You lose a ton of cargo space to carry 100 tons of cargo. It will pay for itself in 2 trips. It does restrict you to the Highport until you unload the Net. The extra mass also reduces your jump/thrust scores, so you may only be ...
by bluekieran
Wed Mar 08, 2017 3:26 pm
Forum: Traveller
Topic: High Guard 2e Ship Design Spreadsheet v1.1 (Google Docs)
Replies: 53
Views: 9666

Re: High Guard 2e Ship Design Spreadsheet v1.1 (Google Docs)

Since I do not have access to Google Docs I tried converting the work into MS Excel and OpenOffice Calc. The conversion to Excel found and deleted three items that were not compatible and I'm trying to figure out why. OpenOffice Calc is not playing well with the "regexmatch" found in Main Cells D52...
by bluekieran
Wed Mar 08, 2017 1:29 pm
Forum: Traveller
Topic: Pocket Trader
Replies: 39
Views: 4460

Re: Pocket Trader

AnotherDilbert wrote:
Wed Mar 08, 2017 12:36 pm
I agree, but:
Streamlined or distributed ships may not use external cargo mounts.
Is guess "distributed" should read "dispersed"?
by bluekieran
Tue Mar 07, 2017 8:58 pm
Forum: Traveller
Topic: Pocket Trader
Replies: 39
Views: 4460

Re: Pocket Trader

Tried building this to test my sheet: https://docs.google.com/spreadsheets/d/14GIVRFqR2DJPMrGxqhB3BAwAocMocmGq02FDBH3zaHA/edit?usp=sharing (I've collapsed a lot of the unused options to make it a bit more readable) I make it MCr26.73, though I'm not sure about the weapons; is it a pop-up fixed mount...
by bluekieran
Tue Mar 07, 2017 1:55 pm
Forum: Traveller
Topic: High Guard 2e Ship Design Spreadsheet v1.1 (Google Docs)
Replies: 53
Views: 9666

v1.5 - Hardening and Primitive/Advanced now in.

Version 1.5 now up at http://bit.ly/2naoqqI It wasn't until I was doing Primitive/Advanced stuff that I realised what a mistake I was making mixing values and formulas earlier in an attempt to make the whole thing a bit more compact... have learned a lot about spreadsheets doing this! I've also alte...
by bluekieran
Mon Mar 06, 2017 5:18 pm
Forum: Traveller
Topic: Hardened Bridge?
Replies: 18
Views: 2082

Re: Hardened Bridge?

Jak Nazryth wrote:
Mon Mar 06, 2017 5:16 pm
So basically, "not getting hit" is the only defense against Ion weapons? ;)
You can still harden any system that draws power - i.e. has a power "score". The M-drive would be a logical place to start, as you don't want that going offline, and/or perhaps the J-drive.
by bluekieran
Mon Mar 06, 2017 4:40 pm
Forum: Traveller
Topic: Hardened Bridge?
Replies: 18
Views: 2082

Re: Hardened Bridge?

No... and Ion weapons don't effect the bridge. Haven't seen anything about how EMP works, if different.
by bluekieran
Mon Mar 06, 2017 1:33 pm
Forum: Traveller
Topic: Hardened Bridge?
Replies: 18
Views: 2082

Re: Hardened Bridge?

How much power does the bridge and/or computer draw? Yeah, I see what you mean... I could argue that they draw some but a negligible amount, but as they don't have a listed power requirement I wonder if Ion weapons would even have an effect on them? If not, they don't need to be hardened... though ...
by bluekieran
Mon Mar 06, 2017 10:52 am
Forum: Traveller
Topic: Ships/personal Computers and software
Replies: 1
Views: 452

Re: Ships/personal Computers and software

Ship computers and software are all in the Computer section of my spreadsheet (linked in .sig), though I don't include the descriptions.
by bluekieran
Mon Mar 06, 2017 10:04 am
Forum: Traveller
Topic: Hardened Bridge?
Replies: 18
Views: 2082

Re: Hardened Bridge?

High Guard p46, "Hardened Systems":
Any system that draws power from the power plant can
be Hardened to render it immune to Ion weapons. A
Hardened system has its cost increased by +50%.
by bluekieran
Sat Mar 04, 2017 7:12 pm
Forum: Traveller
Topic: High Guard 2e Ship Design Spreadsheet v1.1 (Google Docs)
Replies: 53
Views: 9666

Re: High Guard 2e Ship Design Spreadsheet v1.1 (Google Docs)

Version 1.3 now up at https://docs.google.com/spreadsheets/d/ ... sp=sharing

TLs are now shown, though I haven't yet set it up so you can have advanced/primitive drives and so forth; I suspect that will make it even more ponderous!
by bluekieran
Sat Mar 04, 2017 4:37 pm
Forum: Traveller
Topic: Belt mining
Replies: 15
Views: 1869

Re: Belt mining

Quickie spreadsheet - https://docs.google.com/spreadsheets/d/1uTmLRpxJzbwlW4kTBvNHG5yG75zIhA9Cjeb9mYWI6ZI/edit?usp=sharing (make a copy if you want to edit). A quick play with the numbers suggests it would be quite easy to become a billionaire selling claims, and I don't expect it would take more th...
by bluekieran
Sat Mar 04, 2017 3:43 pm
Forum: Traveller
Topic: Cargo bays and vacuum
Replies: 39
Views: 4762

Re: Cargo bays and vacuum

The description in the books does say an airlock has machinery to pump atmosphere in and out of the space. I'm assuming(?) this isn't normally possible in other portions of a ship. That said, no pumping the air from a cargo hold before opening the hatch then replacing it once sealed again. I imagin...
by bluekieran
Sat Mar 04, 2017 9:16 am
Forum: Traveller
Topic: Cargo bays and vacuum
Replies: 39
Views: 4762

Re: Cargo bays and vacuum

Cargo Hatches Any area designated for cargo can be given a cargo hatch of any size but this is not an airlock . Generally speaking, cargo areas are capable of being sealed and so are effectively one large airlock unto themselves, but this can cause problems when needing to unload cargo in a hostile...
by bluekieran
Fri Mar 03, 2017 5:40 pm
Forum: Traveller
Topic: Belt mining
Replies: 15
Views: 1869

Re: Belt mining

Reynard wrote:
Fri Mar 03, 2017 5:07 pm
This is especially true when you begin mining which will be measured in days rather than hours.
Are you better off mining rather than continuing to scan with the intent of selling off the rights, I wonder?