I got some mails asking about more updates to the utility.Well the answer is yes. We are working on it and made lot of improvements such as complete database replacement, weather conditions autofill from net resources, lots of bug corrections and much more.Feel free to bring up more bugs/suggestions/requests.We hope to finish soon, though it is not easy since wagner and I are thousands miles apart...Later,IlanP.s. - couldn't help myself - here are two screenshots of the work in progress..

I gave the spreadsheet a whirl for the first time this weekend and the first thing that popped out at me is that the UTC (the spreadsheet incorrectly says GMT) offsets are incorrect for the airports I checked. If I recall correctly, the spreadsheet shows the offset for KSFO as -2 hours while in real life it is -8 hrs (-7 hrs DST).I can see the problem with calculating the offset during Daylight Savings TIme but I'm sure I can come up with a nested IF statement that covers it. By referencing the date on the first sheet of the spreadsheet, one could check for certain conditions such as DST and adjust the UTC offset accordingly.Secondly the logic used to calculate the weight in pounds on the Weight Analysis page needs checking. Maybe I doing something wrong but the graph keeps showing me I need to top up the center tank with 150 percent (physically impossible) of fuel for a KSFO-KJFK flight.These were my initial observations and not criticisms of the spreadsheet. I immediately thought of unhiding the data sheets and doing the changes I thought necessary but I didn't want to change anything without permission; I don't read Dutch, and I'd prefer to share any changes with the larger group.Is there any chance that there will be a version that's totally in pounds? Unfortunately, those of us who do not use the metric system have difficulty conceptualizing in those terms; even the aircraft data on the first page is stated in metric units....confusing to say the least.

Last thing first - new version already contains metric-imperial conversions. You just have to select your desired measuring system on the "general" tab, and all will be presented in the desired units.I am finishing the complete conversion of all data, it will be OK.regarding UTC offsets - it was a database problem, and as I said, the database was replaced with a more reliable one.I said more reliable, not totaly reliable: I'm sure there will be some errors, but we will fix them whenever discovered.Regarding daylight saving time: you can mark a tickbox if DST is in act, it is already in the sheet you have.BTW nested if won't do if DST info for every airport is not in the database.Last thing - about the fuel problem: right, it was a bug now fixed (conversion problem). I'll probably update the file for download soon with this fix. Thanks!Bye for now,IlanP.S - for thosae who missed Wagner's original post: the file is defined as a public beta, it was published to hear your bug report and requests, so keep it coming!

>Last thing first - new version already contains >metric-imperial conversions. You just have to select your >desired measuring system on the "general" tab, and all will >be presented in the desired units. >I am finishing the complete conversion of all data, it will >be OK. New version meaning the released beta (3b61)or the one you're working on now? I am aware of the metric/imperial conversion; I'm just not sure it works correctly....just check the column of imperial weight conversion in the left side of the Weight Analysis page.Also, much of the data, particularly the aircraft specs on the opening page of the spreadsheet is stated in metric units. It would be nice to have a radio button on the General Settings page that when selected will convert ALL units to either metric or imperial.>>regarding UTC offsets - it was a database problem, and as I >said, the database was replaced with a more reliable one. >I said more reliable, not totaly reliable: I'm sure there >will be some errors, but we will fix them whenever >discovered. >>Regarding daylight saving time: you can mark a tickbox if >DST is in act, it is already in the sheet you have. >BTW nested if won't do if DST info for every airport is not >in the database. I saw the tickbox but when it was checked it really had no impact, given that the offset was incorrect in the first place. With DST selected, the offset at KSFO went from -2 hours to -3. Both of those are incorrect. So in addition to correcting the value of the offsets, the direction of the change when DST is selected needs checking too.Here are my thoughts on a possible nested IF statement. I haven't examined the spreadsheet in detail so this is just a preliminary thought.The spreadsheet already contains the time and date on the first page. The date could be extracted as a serial value and checked against either a lookup table or a nested @IF statement similar to the following: @IF(date value) is => than "some value", then "DST Offset,"@IF(date value) is =< "some value" then "UTC offset," ELSE(do nothing).If you go to this website, http://webexhibits.org/daylightsaving/g.html, you can find the rules for DST so they can be incorporated into the spreadsheet logic and be transparent to the user, albeit with some difficulty. I'm sure with some thought there might be an easier and more elegant solution.Maybe even a custom VBA function could do the trick.>>Last thing - about the fuel problem: right, it was a bug now >fixed (conversion problem). I'll probably update the file >for download soon with this fix. Thanks! Good to know that it was fixed. I didn't check mathematical accuracy when I looked at the spreadsheet, but comparing the results to real world flight plans I noticed that the metric values were spot on but the imperial values were a bit off.Also, while I have your attention, will the logic for reserves be addressed at some stage? I think the spreadsheet is using ICAO reserves but US reserves would be a nice option too.Just my random thoughts.>>>Bye for now, >Ilan >>>>P.S - for thosae who missed Wagner's original post: the file >is defined as a public beta, it was published to hear your >bug report and requests, so keep it coming!

Hi Ilan,One more issue I have encountered. Overall the fuel figures seem to be pretty close for the 500-1000nm flights I tested it on. But the figures for Holding Point (HP) to Top of Climb (TOC) are too low. I burn often 3-4000 lbs more, but as the flight goes on it evens out.Thanks again for your work,[email protected]