Steve Jackson Games - Site Navigation
Home General Info Follow Us Search Illuminator Store Forums What's New Other Games Ogre GURPS Munchkin Our Games: Home

Go Back   Steve Jackson Games Forums > Roleplaying > Traveller

Reply
 
Thread Tools Display Modes
Old 08-08-2011, 09:29 AM   #1
nik1979
 
nik1979's Avatar
 
Join Date: Oct 2004
Location: Philippines, Makati
Default How do you calculat ksf?

How do you calculate ksf?

I'm trying to learn more spreadsheet functions and decided to try making a spreadsheet that generates ships in LibreOffice Calc (with "Form Controls").

I tried the ff:
surface area = ((((dtons*500)^(1/3))^2)*6)/1000 from Gurps vehicles and a function that allows me to round off to two significant digits.

and It doesnt seem to be the same formula
__________________
GMing Blog
MIB#2428
nik1979 is offline   Reply With Quote
Old 08-08-2011, 05:00 PM   #2
tjoneslo
 
Join Date: Aug 2004
Location: Vermont
Default Re: How do you calculat ksf?

That is the correct formula for Gurps Vehicles, what are you comparing it to specifcally? The table in Starships won't match exactly because the streamlining rules modify the hull size. Blame it on the strange streamlining rules in Vehicles.
__________________
Thomas Jones-Low: tjoneslow@gmail.com
Vehicle Builder Guru and gearhead
Librarian at Traveller Wiki
tjoneslo is offline   Reply With Quote
Old 08-08-2011, 06:35 PM   #3
nik1979
 
nik1979's Avatar
 
Join Date: Oct 2004
Location: Philippines, Makati
Default Re: How do you calculat ksf?

Figured it out, the clue was in structure costs and modifications: Sphere had x1 area modifier and x1 cost modifier. It also worked

=(4*(PI())* ((((dtons*500)/(4/3))/(PI()))^(1/3))^2)/1000

gets the radius through volume, and uses radius to get surface area
__________________
GMing Blog
MIB#2428
nik1979 is offline   Reply With Quote
Reply

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
Fnords are Off
[IMG] code is Off
HTML code is Off

Forum Jump


All times are GMT -6. The time now is 11:20 PM.


Powered by vBulletin® Version 3.8.9
Copyright ©2000 - 2021, vBulletin Solutions, Inc.