Traveller Store CotI Features New Posts Mark Forums Read Register


Go Back TravellerRPG.com > Citizens of the Imperium > File Library > Spreadsheets

Reply
 
Thread Tools Display Modes
  #1  
Old October 6th, 2019, 10:46 AM
AnotherDilbert AnotherDilbert is offline
Citizen: SOC-14
 
Join Date: May 2008
Location: Stockholm 🇸🇪
Posts: 1,654
Gallery : 0
AnotherDilbert Citizen+AnotherDilbert Citizen+AnotherDilbert Citizen+
Default T5.10 ShipMaker spreadsheet

Optional simplified overview design on tab "Simple". Just skip it and go directly to tab "Ship" if you don't care for it.

Simple LBB2-style textual description on "Description" tab.

Text code block to post the ship on forums in cell C163 on the "Ship" tab.


The spreadsheet tried to default as much as possible. Crew, Passenger, and Bridge space is input as Comfort, Demand, and Ergonomics respectively and space added as needed.

Only change values in grey cells. Start with TL top left. Columns are added together at the top, green good and red bad. Empty space is allocated to Cargo.

Over-/under-tonnage calculated. Wings and external craft are included in overtonnage, unless included in Total Displacement.

Stages are input as numbers between -3 to +4 with 0 being Standard, -0.5 Basic, and 0.5 Generic. You get as good a stage as can be achieved at the given TL, so you might not get exactly what you asked for.

You should be able to get more Sensor or weapon rows by copying an entire row and inserting a new row.

If you need more rows insert entire rows, not just a few cells.

Red numbers means something is wrong...


Tutorial in this thread:
http://www.travellerrpg.com/CotI/Dis...ad.php?t=40407


This is an old version, the latest version with added functionality and bugfixes can be found later in this thread, or:
https://www.dropbox.com/s/u6jdeivbza...late.xlsx?dl=1
Attached Files
File Type: email T5.10 Ship Template.xlsx (242.1 KB, 9 views)

Last edited by AnotherDilbert; October 9th, 2019 at 10:01 PM.. Reason: Added dropbox link to newer version.
Reply With Quote

Welcome!
To see more of this thread, please login or register.
Reply

Bookmarks

Tags
ship design, shipmaker, spreadsheet, t5.10

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Q&D T5 ShipMaker Spreadsheet Walk-through AnotherDilbert Traveller 5 13 August 21st, 2018 09:06 AM
Simple ShipMaker spreadsheet AnotherDilbert Traveller 5 3 February 19th, 2018 03:23 PM
WTH Spreadsheet? Icosahedron The Lone Star 3 November 5th, 2010 03:48 AM
Spreadsheet help please Icosahedron The Lone Star 4 October 23rd, 2009 05:45 AM

This website and its contents are copyright ©2010- Far Future Enterprises. All rights reserved. Traveller is a registered trademark of Far Future Enterprises .
Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright (c) 2010-2013, Far Future Enterprises. All Rights Reserved.