The Trek BBS statistics

Posts: 5,804,087
Members: 26,065
Currently online: 547

Retro Review: Learning Curve
By: Michelle on Jul 31

Star Trek: The Exhibition In Washington State
By: T'Bonz on Jul 31

August-September 2015 Trek Conventions And Appearances
By: T'Bonz on Jul 31

Shatner To Pen Book On Nimoy
By: T'Bonz on Jul 31

Star Trek Beyond Building Continues
By: T'Bonz on Jul 31

Trinneer In Western Horror
By: T'Bonz on Jul 30

Beam Me Up Scotty Figurines
By: T'Bonz on Jul 30

UK Auction To Feature Spock Costume
By: T'Bonz on Jul 30

Pine To Star In Wonder Woman
By: T'Bonz on Jul 29

Pegg Teases Elba Character
By: T'Bonz on Jul 29

 The Trek BBS Warp speed calculations in Excel

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

 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.
 August 4 2013, 03:20 AM #2 R. Star Rear Admiral     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
 August 4 2013, 03:27 AM #3 Melakon Admiral     Location: Unmarked grave 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. __________________ Dr. Howard, Dr. Fine, Dr. Howard: For duty and humanity! --Men in Black (1934)
 August 4 2013, 03:36 AM #4 R. Star Rear Admiral     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
August 4 2013, 03:49 AM   #5
Dream

Re: Warp speed calculations in Excel

 R. Star wrote: 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!

 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.
 August 4 2013, 04:51 AM #7 Melakon Admiral     Location: Unmarked grave 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." __________________ Dr. Howard, Dr. Fine, Dr. Howard: For duty and humanity! --Men in Black (1934)
 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?'
 August 4 2013, 12:43 PM #9 Hando Lieutenant Commander 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.
August 4 2013, 12:56 PM   #10
Commishsleer
Fleet Captain

Location: CommishSleer
Re: Warp speed calculations in Excel

 R. Star wrote: 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.

August 5 2013, 12:59 PM   #11
Crazyewok
Commander

Re: Warp speed calculations in Excel

 R. Star wrote: 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.

 August 5 2013, 03:12 PM #12 Bry_Sinclair Commodore     Location: Tactical withdrawl along the Klingon border 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 Naya, U.S.S. Renown NCC-1415 [Star Trek: Four Years War] Manip by: JM1776 (STPMA.net)
 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.
August 5 2013, 05:34 PM   #14
R. Star

Location: Shangri-La
Re: Warp speed calculations in Excel

Crazyewok wrote:
 R. Star wrote: 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

August 5 2013, 06:05 PM   #15
Crazyewok
Commander

Re: Warp speed calculations in Excel

 R. Star wrote: 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.

 Bookmarks