Constants.js

var invoiceSheetName = "Invoice";
var productsSheetName = "Products";
var bolSheetName = "BoL";
var summarySheetName = "Invoice Summary";
var sixtelProductString = "1/6 bbl Keg"
var halfBblProductString = "1/2 bbl Keg";
var productNameColumn = 1;
var productSizeColumn = 2;
var productWholesalePriceColumn = 3;
var productVolumeColumn = 5;
var productWeightColumn = 6;
var invoiceProductColumn = 5;
var invoiceProductStartRow = 18;
var invoiceProductEndRow = 35;
var invoicePriceColumn = 7;
var invoiceSizeColumn = 2;
var invoiceVolumeColumn = 3;
var invoiceQuantityColumn = 1;
var invoiceDateRow = 4;
var invoiceDateColumn = 7;
var invoiceNumberRow = 4;
var invoiceNumberColumn = 8;
var invoiceBeerTotalSaleRow = 36;
var invoiceTotalSaleRow = 39;
var invoiceTotalSaleColumn = 8;
var invoiceTotalVolumeRow = 39;
var invoiceTotalVolumeColumn = 4;
var bolProductColumn = 5;
var bolProductStartRow = 17;
var bolProductEndRow = 34;
var bolWeightColumn = 7;
var bolVolumeColumn = 3;
var bolQuantityColumn = 1;
var bolSizeColumn = 2;
var bolNumberRow = 4;
var bolNumberColumn = 8;
var bolDateRow = 4;
var bolDateColumn = 7;
var invoiceSummaryDateColumn = 2;
var invoiceSummaryInvoiceNumberColumn = 2;
var invoiceSummaryBoLNumberColumn = 3;
var invoiceSummaryBeerSalesTotalColumn = 4;
var invoiceSummaryTotalSalesTotalColumn = 5;
var invoiceSummaryVolumeTotalColumn = 6;
var kegReturnRow = 16;
var halfReturnColumn = 5;
var sixtelReturnColumn = 3;