[Spaceships] Design Spreadsheet/Form - Page 2

SpaceGurper · 03-26-2009, 04:35 PM

I was wondering if someone with much more experiance then me could make an Excel or pdf (using livecycle) Form that can calculate spaceship stats.

I'm a noob when it comes to spreadsheets that include dropdown and link/calculate values in another cell.

I've created some but nothing as complex as designing a spaceship with upto SM+20 (1 Billion ton hull) (SM+15 will work too) Reason for the additional +5 SM is for building venerable dreadnaughts or mobile spacestations etc.

I know of the calculator at http://101010.org/gurps/ss_cost_calc.html? but I'd like something that I could use offline to make the spaceship design process quicker and easier. That also includes down grading and building your ships weapons.

I'm sure it's not an easy thing to do but I've just recently figured out how to make drop downs in excel and referencing values on a seperate sheet with the VLOOKUP formula.

My main issue is figuring out how I can reference multiple things like "if SM+5 = value" or "if SM+11 = value". Since the book is all scale based.

03-26-2009, 04:35 PM	#1
SpaceGurper Join Date: Feb 2005	[Spaceships] Design Spreadsheet/Form I was wondering if someone with much more experiance then me could make an Excel or pdf (using livecycle) Form that can calculate spaceship stats. I'm a noob when it comes to spreadsheets that include dropdown and link/calculate values in another cell. I've created some but nothing as complex as designing a spaceship with upto SM+20 (1 Billion ton hull) (SM+15 will work too) Reason for the additional +5 SM is for building venerable dreadnaughts or mobile spacestations etc. I know of the calculator at http://101010.org/gurps/ss_cost_calc.html? but I'd like something that I could use offline to make the spaceship design process quicker and easier. That also includes down grading and building your ships weapons. I'm sure it's not an easy thing to do but I've just recently figured out how to make drop downs in excel and referencing values on a seperate sheet with the VLOOKUP formula. My main issue is figuring out how I can reference multiple things like "if SM+5 = value" or "if SM+11 = value". Since the book is all scale based. __________________ All these lasers and blasters. But still, you can't beat a slugthrower with hyperdense ammo. Last edited by SpaceGurper; 03-26-2009 at 04:48 PM.