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 August 16th, 2019, 03:45 PM
AnotherDilbert AnotherDilbert is online now
Citizen: SOC-14
 
Join Date: May 2008
Location: Stockholm 🇸🇪
Posts: 1,654
Gallery : 0
AnotherDilbert Citizen+AnotherDilbert Citizen+AnotherDilbert Citizen+
Default MT Ship and Grav Vehicle Spreadsheet

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.

You should be able to get more Mixed Turret and Gun Turret rows by inserting 4 new rows and copying the existing 4 rows.

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

Red numbers means something is wrong...

This is an Excel spreadsheet without any macros so should work in e.g. LibreOffice.

Edit: LibreOffice does not seem to want to recalculate the sheet completely... You may have to do Recalculate Hard [Cmd/Ctrl+Shift+F9] a few times to force a complete recalculation after major changes or if power is not correct.

LibreOffice: Don't change anything too much, e.g. don't change size by more than 10 times at a time. So if you want to make a 75000 Dt ship, change displacement from 100 to 1000, then to 10000, and finally to 75000, then force recalculate.

Note: This spreadsheet uses circular references, you must turn on iterative calculations to solve them.

If you can't find the latest version later in this thread, you may find the latest version here:
https://www.dropbox.com/s/1h59jxcbgd...tive.xlsx?dl=1

Simple walkthrough in this thread:
http://www.travellerrpg.com/CotI/Dis...d.php?p=605470


As per 2019-09-26 the latest updated version can be found in post #53:
http://www.travellerrpg.com/CotI/Dis...3&postcount=53
Attached Files
File Type: email MT Ship Template Iterative.xlsx (81.5 KB, 11 views)

Last edited by AnotherDilbert; September 28th, 2019 at 12:30 PM..
Reply With Quote

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

Bookmarks

Tags
design, megatraveller, ship, vehicle

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
Grav vehicle movement Peter the Swede Traveller Wargames 36 March 17th, 2015 04:11 AM
Overflown by a grav vehicle McPerth Imperial Research Station 17 February 24th, 2014 12:01 PM
I need Grav Vehicle pics. Darkhstarr The Lone Star 7 August 29th, 2009 12:54 AM
Grav vehicle telltale Icosahedron Ship's Locker 18 February 15th, 2007 03:21 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.