Block Time Calculator

[SWZ]

I've begun to use a spreadsheet so i can manage my fleet better.

I'm trying to come up with a Calculator that allows me to see the furthest airport I can fly an aircraft to, given the block time left on it.

But I have managed to mess up the formula and now I am unbelievably confused..and I have a headache.

What am I doing wrong in this formula?

Longest Possible Route (Distance) = ((Remaining Block Time - Turn Time - Turn Time) * Speed)   

According to this formula a particular a/c in my fleet had enough time left to fly to an airport just 47nm away.. yet when I tried to launch the route, this a/c wasn't available 

So what is wrong with my formula above?  Help please coz it's driving me crazy!

[dktc]

Distance = ( Remaining Time / 2 - turn time ) * speed

You calculated 2 turn time, but forgot to divide the distance in 2.

[pseudoswede]

He mean dividing the block time by 2, but that is assuming you wanted a 1-frequency flight...

[DistanceAvailable] = Speed * [(RemainingBlockTime / 2) - TurnTime]

If you just wanted a 0.5-frequency flight...

[DistanceAvailable] = Speed * [RemainingBlockTime - TurnTime]


I've also found that the game is rather finicky when stretching the limits of aircraft usage. I used to calculate routes using literally all 24 hours; however, there were times when it wouldn't accept it because the actual aircraft usage was actually 24.001 hours.

[SWZ]

Thanks for the replies.

OK, so using these formulas, an a/c with speed 265 and 0.84hrs left of operable time with 0.26 turn time (and assuming 1-freq route) can only go 42.4nm.  Right?

Just want to make sure I've got this right...then I can go lie down and recover from this headache!

[pseudoswede]

OK, so using these formulas, an a/c with speed 265 and 0.84hrs left of operable time with 0.26 turn time (and assuming 1-freq route) can only go 42.4nm.  Right?

Correct. However, just be prepared for some disappointment if you actually do find a 42nm route to fly.