Aces High Bulletin Board

Special Events Forums => Friday Squad Operations => Topic started by: AKDogg on December 06, 2009, 06:58:06 PM

Title: Updated Fuel calculator
Post by: AKDogg on December 06, 2009, 06:58:06 PM
Here is the latest rev including the p47M.

 AK Fuel Calculator  (http://www.arabian-knights.org/files/fso/AK_Fuel_Calculator.xls)
Title: Re: Updated Fuel calculator
Post by: daddog on December 06, 2009, 06:58:51 PM
Thank you sir! I just started using this in the past few months. :)
Title: Re: Updated Fuel calculator
Post by: AKDogg on December 06, 2009, 07:01:21 PM
Had to wait till HT fixed the fuel bug in the p47M.  I had it added since the intial release of the P47M, but the fuel bug postponed the update for this,lol. :salute
Title: Re: Updated Fuel calculator
Post by: TUK on December 06, 2009, 08:09:19 PM
Thanks  AKDogg!  Great tool for all.....  :rock
 :salute
Title: Re: Updated Fuel calculator
Post by: dmdchief on December 19, 2009, 02:41:05 AM
Ok I'll be the first to show my stupidity, how do you change the multiplier?
Title: Re: Updated Fuel calculator
Post by: RSLQK186 on December 19, 2009, 07:16:41 AM
Open with Xcell and double click with curser just behind the multiplier show at the top. Hit backspace to erase it. Type in the burn rate for FSO or Scinario you want to fly in and hit enter.
Title: Re: Updated Fuel calculator
Post by: RSLQK186 on December 19, 2009, 07:25:07 AM
Just noticed that the 163 does not change no matter what the multipler- even at .0001 it does not change. No biggie. I'm a glider a lot longer than I'm in powered flight with it anyway. Making it home is sometimes harder than hitting somthing w/o ramming it :O
Title: Re: Updated Fuel calculator
Post by: AKDogg on December 19, 2009, 08:12:46 AM
Just noticed that the 163 does not change no matter what the multipler- even at .0001 it does not change. No biggie. I'm a glider a lot longer than I'm in powered flight with it anyway. Making it home is sometimes harder than hitting somthing w/o ramming it :O

That is because the fuel burn on the ME163 is not changeable in AH.  Fuel burn for that plane is hard coded in the model.  Even if u set the multiplier to .5, u will still get 5-7 mins at fuel throttle like it was set at 2.0.
Title: Re: Updated Fuel calculator
Post by: RSLQK186 on December 19, 2009, 09:49:24 AM
Never relised that. TY for clearing that up. I'm thinking had you not known that then the spreadsheet would have given false info when someone changed the burn rate. Good catch.
Title: Re: Updated Fuel calculator
Post by: dmdchief on December 19, 2009, 11:55:41 AM
thanks for info  I really like this
Title: Re: Updated Fuel calculator
Post by: BluTrain on December 30, 2009, 11:11:19 PM
Very nice but the multiplier value seems to be "protected" when using Open Office....anyone know how to fix this?  :pray  Otherwise I'll have to bite the bullet and buy Excel/MS Office
Title: Re: Updated Fuel calculator
Post by: jd on January 02, 2010, 11:09:58 AM
What if you carry ORD's? Am I missing the application, or what? Not trying to be difficult, honest.

MajChaos~S~
Title: Re: Updated Fuel calculator
Post by: AKDogg on January 02, 2010, 02:36:14 PM
Here is a Open office version:

http://www.arabian-knights.org/files/fso/AK_Fuel_Calculator.ods
Title: Re: Updated Fuel calculator
Post by: AKDogg on January 02, 2010, 02:37:56 PM
What if you carry ORD's? Am I missing the application, or what? Not trying to be difficult, honest.

MajChaos~S~
This is a generic fuel calculator based on amount of time of flight with a givin amount of fuel and fuel multiplier.  Ords will not effect time but only the distance you can travel.
Title: Re: Updated Fuel calculator
Post by: RTHolmes on January 03, 2010, 07:26:43 AM
Very nice but the multiplier value seems to be "protected" when using Open Office

same with Excel :(
Title: Re: Updated Fuel calculator
Post by: AKDogg on January 03, 2010, 08:58:40 AM
same with Excel :(

I just downloaded the file I posted for excel and it works fine.  What version of office u have?  This file is backward compatable file.  Suppose to work from 97-2007.  I have 2003 and 2007.  Works in both of those version for sure.
Title: Re: Updated Fuel calculator
Post by: RTHolmes on January 03, 2010, 10:02:41 AM
office 2000, says the worksheet is protected.
Title: Re: Updated Fuel calculator
Post by: AKDogg on January 03, 2010, 10:28:20 AM
hhmm, well I don't want to unprotect the entire worksheet because it will cause lots of problems for me as people make changes to formulas without knowing what they did and then saying the calculator is broken.  I want to keep it dummy proof if u know what I mean.  Download open office then and get the open office version if you want to use it.  That is the only option I will give at this time since I no longer have office 2000 in my aresonal of programs,lol.

You can get Open office for free here:

http://www.openoffice.org/
Title: Re: Updated Fuel calculator
Post by: BluTrain on January 03, 2010, 10:50:49 AM
Here is a Open office version:

http://www.arabian-knights.org/files/fso/AK_Fuel_Calculator.ods

 :aok Open Office version working great.  Thanks AKDogg!  :salute
Title: Re: Updated Fuel calculator
Post by: jd on January 03, 2010, 11:21:32 AM
 good stuff , thanks for sharing
This is a generic fuel calculator based on amount of time of flight with a givin amount of fuel and fuel multiplier.  Ords will not effect time but only the distance you can travel.
:aok