Bug list for VFR Flight Planner

The latest version of this spreadsheet is ver 1.20.  All known errors and bugs have been fixed in the latest version.

History
The spreadsheet was developed using Excel 5.0 and 7.0. A couple of bugs were reported to me when ver 0.6a was released run with Excel 97 under Windows 95/NT in early Feb '98. However, without access to NT or to new releases of Excel, I could not confirm them. I recently, however, upgraded to MS Office 97 and have managed to duplicate these bugs under Windows 95.  Version 0.6a had no problems when run under Excel 5.0/7.0 but had problems when run under Excel 97.  Thanks to all those who have taken the time to report problems.

The bugs in ver 0.6 have been fixed with some help from Microsoft. The conversion from 5.0/7.0 to Excel 97 caused some data corruption causing the program to crash or become impossible to save to itself or another file name. By the way, if you require this spreadsheet in a particular Excel version, please e-mail me.
 
 
 

Bug list, updated Nov 5, 2000
Bug# 
 ver
Description
Date reported
Operating Sys
Severity
Action(s) taken
Workarounds/Suggestions
0.6.1
 0.6 In the CG graph, extra line segment that appears to go to origin.
1 Feb '98
Windows 95 and NT (Svc Pack 3)
minor
Fixed. Update in ver 0.6c.
N/A
0.6.2
 0.6 Exception error (Win NT) or invalid page fault error (Win 95) when saving/exiting the spreadsheet.
1 Feb '98
Windows 95 and NT (Svc Pack 3)
major
Fixed - 30 March, '98. Update in ver 0.6c
N/A
0.6.3 0.6c Sign error in use of magnetic variation in one cell column causing errors in Flight Plan sheet. This is a gross error, please do not use v0.6c.
30 April '98
-
major
Fixed - 1 May '98. Update in ver 0.6d
N/A
0.6.4
 0.6d Syntax error in 2nd SUM function in 'W&B'!C12
11 May '98
-
minor
Corrected in ver 0.70
Replace current formula in cell with this one
0.8.1 0.80 Fields A24 and A25 locked
24 July '98
-
minor
update next version
 Unprotect Flt Plan sheet, unlock cells A24 and A25, reprotect the sheet if desired.
1.0.1 1.00 Timezone info not used correctly in reverse plan sheet
5 Apr '99
-
minor
updated ver 1.01
-
1.0.2 1.01 Magnetic heading (rev flt plan) has mag variation cell reference error.  12 Dec '99
-
 average
fixed in ver 1.10
 replace B28 ref in MH column in rev plan to B30 in all rows.
1.0.3 1.01 Incorrect or incomplete usage of daylight savings info for destination airport
-
-
minor
fixed in ver 1.10
-
1.1.1 1.10 Error in Q19 calculation 10 Sep '00
-
minor
fixed in ver 1.20
  enter =Q18+O19+Z22 in Q19 field
1.1.2 1.10 Inaccurate sunrise/sunset times 1 Nov, '00
-
minor
fixed in ver 1.20
  no easy fix, new formulae in ver 1.20

I would appreciate it if you could e-mail me any problems as soon as you find them. Suggestions for improvements also welcome. Thanks very much.

Return to Aviation page