Steve Jackson Games Forums How do you calculat ksf?
 Register FAQ Calendar Mark Forums Read

 08-08-2011, 09:29 AM #1 nik1979     Join Date: Oct 2004 Location: Philippines, Makati 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
 08-08-2011, 05:00 PM #2 tjoneslo   Join Date: Aug 2004 Location: Vermont 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
 08-08-2011, 06:35 PM #3 nik1979     Join Date: Oct 2004 Location: Philippines, Makati 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

 Thread Tools Display Modes Linear Mode

 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 Rules
 Forum Jump User Control Panel Private Messages Subscriptions Who's Online Search Forums Forums Home Illuminati Headquarters     SJ Games Discussion     Daily Illuminator     Forum Feedback and Help Warehouse 23     Warehouse 23 General Discussion     Warehouse 23 Digital     Pyramid Munchkin     Munchkin 101     Munchkin     Munchkin Collectible Card Game     Other Munchkin Games Roleplaying     Dungeon Fantasy Roleplaying Game         DFRPG Resources     GURPS         GURPS Resources         GURPS Character Assistant     Transhuman Space     Traveller     The Fantasy Trip         The Fantasy Trip: House Rules     In Nomine     Roleplaying in General     Play By Post Board and Card Games     Car Wars         Car Wars Old Editions     Ogre and G.E.V.         Ogre Video Game         Ogre Scenarios     Board and Dice Games     Card Games     Miniatures The Gnomes of Zurich     The Industry     Conventions     Trading Post     Gamer Finder

All times are GMT -6. The time now is 01:38 PM.

 -- Default Style ---- Classic Forum Colors Contact Us - Steve Jackson Games - Privacy Statement - Top