View Single Post
Old August 4 2013, 02:57 AM   #1
JJohnson
Captain
 
Location: Jacksonville, FL
Warp speed calculations in Excel

I'm working on an Excel spreadsheet that'll calculate the years, days, hours, minutes, and seconds it'll take to travel a given distance in light years.

What I have so far only works for warp 1, and I can't seem to find out why it doesn't work for anything higher.

So far, I enter a warp speed (TOS scale), it gives me the multiple of light, then m/s, kps, kph.

warp: 2
c: =b6^3
m/s: =B7*299792458 (definition of light speed)
kps: =B8/1000
kph: =B9*3600

light year: 9460730472580800 meters
ly (km): =B12/1000

so, Alpha Centauri is 4.37 ly.

time to travel at warp 2: =(F8*$B$13)/$B$9

or: (4.37*9460730472580.8)/2398339.66

which gives: 17,238,339 seconds

That is a little over half a year, with a year being 31,557,600 seconds.

now how would I convert that reliably to years, days, hours, minutes, seconds, so that I see:
0 years
150 days
4 hours
8 minutes
10 seconds

when I enter a given warp speed?

I've got the distance in light years to the closest 20 stars entered, so it'll calculate the time to travel automatically for all those stars, or at least, that's the hope anyhow.

If anyone's good with Excel, I'd appreciate any help.
JJohnson is offline   Reply With Quote