We have discovered a bug in the VGM Bid Calculator Worksheets at http://www.vgmncbservices.com/bid_calculators.asp. 

In all 100 CBA worksheets the oxygen category (only) includes 5 “payment class” cells in which potential bidders can enter a fixed “desired” bid amount in column G, or a bid discount percent in column H. 

Column M indicates the percentage of the overall composite bid that the five payment categories represent.  The software will sum the input and indicate a discounted composite bid in cell L20 and the overall category discount in cell L21. 

The bug exists in that the category discount did not reflect Payment Class “B”, the Portable Equipment Only class.  The composite bid amount was accurate (and hence there are no issues of an erroneous dollar amount)…but the overall category discount appeared less than the input data.

We are correcting all 100 files now. 

If you would like to manually correct a downloaded copy, it is easy: 

Unhide Column F.  This may be done by shifting and putting your cursor over columns E and G.  Hold the shift and right click the “Unhide” option.  Column F will appear!  The second of the five weighted bid limits (Portable Only) in this column is blank.  Simply copy the function of d7 * e7 and then the correction will take place.  Resave the file (or simply download the updated one from the link above; these will be complete by 1:00 CST today).

Thank you.