RSS iconTwitter iconFacebook icon

The Trek BBS title image

The Trek BBS statistics

Threads: 139,600
Posts: 5,424,527
Members: 24,810
Currently online: 537
Newest member: David Ellerman

TrekToday headlines

September Loot Crate Features Trek Surprise
By: T'Bonz on Sep 16

USS Enterprise Miniature Out For Refit
By: T'Bonz on Sep 16

Star Trek/Planet of the Apes Comic Crossover
By: T'Bonz on Sep 16

Trek 3 Shooting Next Spring?
By: T'Bonz on Sep 16

Star Trek: Alien Domain Game Announced
By: T'Bonz on Sep 15

Red Shirt Diaries Episode Three
By: T'Bonz on Sep 15

Made Out Of Mudd Photonovel
By: T'Bonz on Sep 15

Takei Has Growth Removed
By: T'Bonz on Sep 15

Retro Review: Tears of the Prophets
By: Michelle on Sep 12

New Wizkids Attack Wing Ships
By: T'Bonz on Sep 12


Welcome! The Trek BBS is the number one place to chat about Star Trek with like-minded fans. Please login to see our full range of forums as well as the ability to send and receive private messages, track your favourite topics and of course join in the discussions.

If you are a new visitor, join us for free. If you are an existing member please login below. Note: for members who joined under our old messageboard system, please login with your display name not your login name.


Go Back   The Trek BBS > Welcome to the Trek BBS! > General Trek Discussion

General Trek Discussion Trek TV and cinema subjects not related to any specific series or movie.

Reply
 
Thread Tools
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
Old August 4 2013, 03:20 AM   #2
R. Star
Rear Admiral
 
R. Star's Avatar
 
Location: Shangri-La
Re: Warp speed calculations in Excel

I don't mean to discourage you at all if number crunching is your thing, but... travel time in Trek is a highly variable concept dependent on the needs of the plot.
__________________
"I was never a Star Trek fan." J.J. Abrams
R. Star is offline   Reply With Quote
Old August 4 2013, 03:27 AM   #3
Melakon
Vice Admiral
 
Melakon's Avatar
 
Location: Unmarked grave, Ekos
Re: Warp speed calculations in Excel

Depending on the story, going from Point A to Point B might take 3 days, 7 hours, 47 minutes at Warp 5 in an episode. In another episode, we might learn the actual distance is 14.3 lightyears. Then in a third story, it might take twice as long at Warp 6 to go that same distance.
__________________
Curly: If at first you don't succeed, keep on suckin' til you do succeed.
--Movie Maniacs (1936)
Melakon is online now   Reply With Quote
Old August 4 2013, 03:36 AM   #4
R. Star
Rear Admiral
 
R. Star's Avatar
 
Location: Shangri-La
Re: Warp speed calculations in Excel

http://www.anycalculator.com/warpcalculator.htm

There's a website with a working calculator. But even that's flawed. I checked Voyager's 75,000 LY to get home at their max cruising speed of 9.975 and it showed me a bit over 5 years. Maybe they knew Janeway would stop to inspect every spec of space dust in between here and there when they cited the 70 year number.
__________________
"I was never a Star Trek fan." J.J. Abrams
R. Star is offline   Reply With Quote
Old August 4 2013, 03:49 AM   #5
Dream
Admiral
 
Dream's Avatar
 
Re: Warp speed calculations in Excel

R. Star wrote: View Post
http://www.anycalculator.com/warpcalculator.htm

There's a website with a working calculator. But even that's flawed. I checked Voyager's 75,000 LY to get home at their max cruising speed of 9.975 and it showed me a bit over 5 years. Maybe they knew Janeway would stop to inspect every spec of space dust in between here and there when they cited the 70 year number.
Blame Janeway for wasting so much power on the holodecks, when they could have gotten home in season five!
Dream is offline   Reply With Quote
Old August 4 2013, 04:27 AM   #6
JJohnson
Captain
 
Location: Jacksonville, FL
Re: Warp speed calculations in Excel

I absolutely know the warp speed is as fast as the needs of the plot. But, I'm trying to avoid that in my story, so if it says it's a 12 day, 8 hour, 12 minute trip at warp 4, that's how long it'll take.
JJohnson is offline   Reply With Quote
Old August 4 2013, 04:51 AM   #7
Melakon
Vice Admiral
 
Melakon's Avatar
 
Location: Unmarked grave, Ekos
Re: Warp speed calculations in Excel

There are probably dozens of warp factor scales worked out by fans over the last 40 years for every series. Find one appropriate for ENT, perhaps one that's commonly accepted by those who explore such things (like the guys in the Trek Tech forum), and use it as your model.

After you write the story, someone will eventually pop up and say "but such-and-such says..." and you can say "I used this particular scale here."
__________________
Curly: If at first you don't succeed, keep on suckin' til you do succeed.
--Movie Maniacs (1936)
Melakon is online now   Reply With Quote
Old August 4 2013, 05:14 AM   #8
JJohnson
Captain
 
Location: Jacksonville, FL
Re: Warp speed calculations in Excel

I'm working on the warp^3 formula. My question's more along the lines of 'how do I get Excel to show years, days, hours, minutes, seconds the right way?'
JJohnson is offline   Reply With Quote
Old August 4 2013, 12:43 PM   #9
Hando
Lieutenant Commander
 
Hando's Avatar
 
Send a message via ICQ to Hando Send a message via AIM to Hando Send a message via Windows Live Messenger to Hando Send a message via Yahoo to Hando
Re: Warp speed calculations in Excel

Take a look at mine


But the problem is what do you consider a year: 365 days or 365.25 or 365.2425 or some more correct...
__________________
The end justifies the means. So do not put canon on a pedestal. We are here to talk Star Trek not only one of its facets.

Last edited by Hando; August 4 2013 at 09:18 PM.
Hando is offline   Reply With Quote
Old August 4 2013, 12:56 PM   #10
CommishSleer
Fleet Captain
 
CommishSleer's Avatar
 
Location: At the After Party Still...
View CommishSleer's Twitter Profile
Re: Warp speed calculations in Excel

R. Star wrote: View Post
http://www.anycalculator.com/warpcalculator.htm

There's a website with a working calculator. But even that's flawed. I checked Voyager's 75,000 LY to get home at their max cruising speed of 9.975 and it showed me a bit over 5 years. Maybe they knew Janeway would stop to inspect every spec of space dust in between here and there when they cited the 70 year number.


What about the theory that they changed the Warp scale between TOS and TNG because they went over Warp 10 in TOS heaps of time without once devolving or any other creepy things happening.
CommishSleer is offline   Reply With Quote
Old August 5 2013, 12:59 PM   #11
Crazyewok
Commander
 
Re: Warp speed calculations in Excel

R. Star wrote: View Post
http://www.anycalculator.com/warpcalculator.htm

There's a website with a working calculator. But even that's flawed. I checked Voyager's 75,000 LY to get home at their max cruising speed of 9.975 and it showed me a bit over 5 years. Maybe they knew Janeway would stop to inspect every spec of space dust in between here and there when they cited the 70 year number.


Well i go by the idea that yeah if the went warp 9+ they could have done it in years.....

But theres a diffrence to making that speed and maintaining it. Yeah the ship can ho 9.975 but only for a few minutes, longer and you risk tearing the ship apart or burning the engines out. Hence why warp 6 seems to be used alot. Maybe its the ideal speed to avoid damage and give the best fuel economy?

Last edited by Crazyewok; August 5 2013 at 04:11 PM.
Crazyewok is offline   Reply With Quote
Old August 5 2013, 03:12 PM   #12
Bry_Sinclair
Commodore
 
Bry_Sinclair's Avatar
 
Location: Along the border of Talarian space
Re: Warp speed calculations in Excel

Then there's super-mega-hyper-warp in NuTrek, which allows a ship to travel from Earth to Vulcan in minutes.
__________________
Avatar: Captain Susanna Leijten, U.S.S. Silverfin NCC-4470, Border Service Third Cutter Squadron
Manip by: FltCpt. Bossco (STPMA)
Bry_Sinclair is offline   Reply With Quote
Old August 5 2013, 04:13 PM   #13
Crazyewok
Commander
 
Re: Warp speed calculations in Excel

I also think there may be subspace lanes were warp is faster and easier to maintain. Hence why even the NX-Ent was able to reach some distant places quicker than it should.
Crazyewok is offline   Reply With Quote
Old August 5 2013, 05:34 PM   #14
R. Star
Rear Admiral
 
R. Star's Avatar
 
Location: Shangri-La
Re: Warp speed calculations in Excel

Crazyewok wrote: View Post
R. Star wrote: View Post
http://www.anycalculator.com/warpcalculator.htm

There's a website with a working calculator. But even that's flawed. I checked Voyager's 75,000 LY to get home at their max cruising speed of 9.975 and it showed me a bit over 5 years. Maybe they knew Janeway would stop to inspect every spec of space dust in between here and there when they cited the 70 year number.


Well i go by the idea that yeah if the went warp 9+ they could have done it in years.....

But theres a diffrence to making that speed and maintaining it. Yeah the ship can ho 9.975 but only for a few minutes, longer and you risk tearing the ship apart or burning the engines out. Hence why warp 6 seems to be used alot. Maybe its the ideal speed to avoid damage and give the best fuel economy?
In the pilot of Voyager they made a point of saying "sustainable cruise velocity of Warp 9.975."
__________________
"I was never a Star Trek fan." J.J. Abrams
R. Star is offline   Reply With Quote
Old August 5 2013, 06:05 PM   #15
Crazyewok
Commander
 
Re: Warp speed calculations in Excel

R. Star wrote: View Post
In the pilot of Voyager they made a point of saying "sustainable cruise velocity of Warp 9.975."
And my rule of if it stupid then its wrong applies...

The writters obviosly had a brain fart and made a mistake seeing as voyger and most of startfleet never seem to use warp 9 unless its a emergancy.
Crazyewok is offline   Reply With Quote
Reply

Bookmarks

Thread Tools

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



All times are GMT +1. The time now is 01:56 AM.

Powered by vBulletin® Version 3.8.6
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
FireFox 2+ or Internet Explorer 7+ highly recommended.