{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Setup","FuelWS","Instructions - Pay Item adj's","Template","Accuracy","FuelFactors"],"not_rendered":{"charts":0,"images":7,"macros":1,"external_links":0,"defined_names":24,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Setup","index":0,"n_rows":34,"n_cols":15,"rows_kept":34,"cut":false,"hidden":false,"merged":[[21,3,21,8],[17,14,17,15],[17,10,17,12],[19,10,19,12],[19,14,19,15],[21,14,21,15],[21,10,21,12],[19,3,19,8],[13,2,13,3],[13,5,13,9],[13,10,13,12],[13,14,13,15],[17,3,17,8],[11,5,11,15],[7,5,7,15],[7,2,7,3],[9,2,9,3],[9,5,9,15],[11,2,11,3],[33,1,33,3],[27,6,27,15],[23,10,23,12],[23,14,23,15],[32,1,32,3],[1,1,1,16],[2,1,2,16],[3,1,3,16],[4,10,4,12],[4,5,4,9]]}
[]
[]
[null,"Contractor's Estimated Fuel Worksheet"]
[null,"(Design Build and Lump Sum Projects)"]
[null,null,null,null,null,"Worksheet No."]
[]
[]
[null,null,"Financial Project ID:"]
[]
[null,null,"Contractor:"]
[]
[null,null,"Contract Number:"]
[]
[null,null,"From (Mo/Day/Yr):",null,null,null,null,null,null,null,"To (Mo/Day/Yr):"]
[]
[]
[]
[null,null,null,"Month / Year",null,null,null,null,null,null,"Gasoline Index",null,null,null,"Diesel Index"]
[]
[null,null,"Base Index:"]
[]
[null,null,"Current Index:"]
[]
[null,null,"Index Difference:",null,null,null,null,null,null,null,{"$f":"IF((GasolineBaseIndex*1.05)<=GasolineCurrentIndex,GasolineCurrentIndex-(GasolineBaseIndex*1.05),IF((GasolineBaseIndex*0.95)>=GasolineCurrentIndex,GasolineCurrentIndex-(GasolineBaseIndex*0.95),0))","v":0},null,null,null,{"$f":"IF((DieselBaseIndex*1.05)<=DieselCurrentIndex,DieselCurrentIndex-(DieselBaseIndex*1.05),IF((DieselBaseIndex*0.95)>=DieselCurrentIndex,DieselCurrentIndex-(DieselBaseIndex*0.95),0))","v":0}]
[]
[]
[]
[null,null,null,null,null,null,"Navigation Functions"]
[]
[]
[]
[]
[null,"Effective January 2007 Letting"]
[null,"(Revision 02/12/08)"]

{"sheet":"FuelWS","index":1,"n_rows":85,"n_cols":14,"rows_kept":85,"cut":false,"hidden":false,"merged":[[43,2,43,3],[67,11,67,14],[67,4,67,5],[63,2,63,3],[64,2,64,3],[65,2,65,3],[66,2,66,3],[9,13,11,14],[9,11,11,12],[23,2,23,3],[22,2,22,3],[21,2,21,3],[20,2,20,3],[9,5,11,6],[9,9,11,10],[19,2,19,3],[16,2,16,3],[18,2,18,3],[9,1,11,1],[30,2,30,3],[12,2,12,3],[34,2,34,3],[17,2,17,3],[33,2,33,3],[27,2,27,3],[31,2,31,3],[28,2,28,3],[1,2,1,11],[7,3,7,4],[5,3,5,4],[59,2,59,3],[62,2,62,3],[61,2,61,3],[57,2,57,3],[58,2,58,3],[55,2,55,3],[53,2,53,3],[2,3,2,7],[3,3,3,4],[9,7,11,8],[56,2,56,3],[52,2,52,3],[38,2,38,3],[68,4,68,5],[26,2,26,3],[9,2,11,3],[9,4,11,4],[15,2,15,3],[25,2,25,3],[24,2,24,3],[39,2,39,3],[42,2,42,3],[51,2,51,3],[41,2,41,3],[49,2,49,3],[48,2,48,3],[35,2,35,3],[36,2,36,3],[46,2,46,3]]}
[]
[null,null,"CONTRACTOR'S ESTIMATED FUEL WORKSHEET"]
[null,null,null,"(DESIGN BUILD AND LUMP SUM PROJECTS)"]
[null,"CONTRACTOR:",{"$f":"ContractorName","v":0},"DATE FROM:",null,{"$f":"DateFrom","v":"00:00:00"},null,null,null,"MONTH / YEAR",null,"GASOLINE INDEX",null,"DIESEL INDEX"]
[]
[null,"WORKSHEET NO.:",{"$f":"CertificationNumber","v":0},"DATE TO:",null,{"$f":"DateTo","v":"00:00:00"},null,"BASE INDEX:",null,{"$f":"BaseIndexMonth","v":"00:00:00"},null,{"$f":"GasolineBaseIndex","v":0},null,{"$f":"DieselBaseIndex","v":0}]
[]
[null,"FINANCIAL PROJECT ID:",{"$f":"FinancialIDNumber","v":0},"CONTRACT NO.:",null,{"$f":"ContractNumber","v":0},null,"CURRENT INDEX:",null,{"$f":"CurrentIndexMonth","v":"00:00:00"},null,{"$f":"GasolineCurrentIndex","v":0},null,{"$f":"DieselCurrentIndex","v":0}]
[]
[null,"PAY ITEM NUMBER(S)","ITEM DESCRIPTION",null,"UNIT","QUANTITY",null,"GASOLINE\n(GALLONS)",null,"DIESEL\n(GALLONS)",null,"GASOLINE\nFACTOR",null,"DIESEL\nFACTOR"]
[]
[]
[null,"0110-1-1",{"$f":"VLOOKUP(B13,FuelFactorDataRange,2,FALSE)","v":"Clearing & Grubbing"},null,{"$f":"VLOOKUP(B13,FuelFactorDataRange,3,FALSE)","v":"LS/AC"},null,null,null,null,null,null,{"$f":"VLOOKUP(B13,FuelFactorDataRange,4,FALSE)","v":32},null,{"$f":"VLOOKUP(B13,FuelFactorDataRange,5,FALSE)","v":45.64}]
[null,"0110-15","Arborist Work, Complete",null,"LS/AC",null,null,null,null,null,null,32,null,45.64]
[null,"0110-20-1 and 110-20-2","Removal of Existing Wall/ MSE or Retaining Wall",null,"LS/",null,null,null,null,null,null,32,null,45.64]
[null,"0120-1",{"$f":"VLOOKUP(B16,FuelFactorDataRange,2,FALSE)","v":"Regular Excavation"},null,"CY",null,null,null,null,null,null,2.8E-3,null,0.20150000000000001]
[null,"0120-2-2","Borrow Excavation",null,"CY",null,null,null,null,null,null,3.8999999999999998E-3,null,0.44409999999999999]
[null,"0120-3","Lateral Ditch Excavation",null,"CY",null,null,null,null,null,null,{"$f":"VLOOKUP(B18,FuelFactorDataRange,4,FALSE)","v":9.9999999999999994E-12},null,5.33E-2]
[null,"0120-4 to 120-5","Subsoil or Channel Excavation",null,"CY",null,321321,{"$f":"ROUND(F19*L19,0)","v":0},null,{"$f":"ROUND(F19*N19,0)","v":0},null,4.3E-3,null,0.27879999999999999]
[null,"0120-6","Embankment",null,"CY",null,321321,0,null,0,null,3.4099999999999998E-2,null,0.51749999999999996]
[null,"0160-4","Type B Stabilization",null,"SY",null,321321,0,null,0,null,3.0599999999999999E-2,null,0.1196]
[null,"0162","Soil Layer",null,"SY",null,321321,0,null,0,null,9.9999999999999994E-12,null,6.0000000000000001E-3]
[null,"0285-701 to 0285-708","Base Optional (Group 01 to 08) ",null,"SY",null,321321,0,null,0,null,5.6007000000000001E-2,null,0.215614]
[null,"0285-709 to 0285-715","Base Optional (Group 09 to 15) ",null,"SY",null,321321,0,null,0,null,9.2254000000000003E-2,null,0.43591600000000003]
[null,"0285-701 to 0285-708 (Asph)","Base Superpave Type 12.5  (Asphalt Only)",null,"SY",null,321321,0,null,0,null,4.0149999999999998E-2,null,0.97328800000000004]
[null,"0285-709 to 0285-715 (Asph)","Base Superpave Type 12.5  (Asphalt Only)",null,"SY",null,321321,0,null,0,null,6.6000000000000003E-2,null,1.5999570000000001]
[null,"0286-1","Turnout Construction",null,"SY",null,321321,0,null,0,null,2.64E-2,null,0.6925]
[null,"0286-2","Turnout Construction",null,"TN",null,321321,0,null,0,null,0.17599999999999999,null,4.6220109999999996]
[null,"0287-1*","Permeable Base (Asphalt Treated) added 9/1/09",null,"CY",null,321321,{"$f":"ROUND(F29*L29,0)","v":0},null,{"$f":"ROUND(F29*N29,0)","v":0},null,8.7900000000000006E-2,null,1.5212000000000001]
[null,"0324-1","Rework Asphalt Concrete",null,"SY",null,null,{"$f":"ROUND(F30*L30,0)","v":0},null,{"$f":"ROUND(F30*N30,0)","v":0},null,9.7000000000000003E-3,null,3.1600000000000003E-2]
[null,"0327-70-1 to 0327-70-13","Mill Existing Asphalt Pavement",null,"SY",null,321321,0,null,0,null,2.7969000000000001E-2,null,9.1162000000000007E-2]
[null,"0327-70-14 to 0327-70-25, 26","Mill Existing Asphalt Pavement added 7/11/08",null,"SY",null,321321,0,null,{"$f":"ROUND(F32*N32,0)","v":0},null,4.1224999999999998E-2,null,0.13389499999999999]
[null,"0327-70-27, 28, 29,30","Mill Existing Asphalt Pavement",null,"SY",null,null,{"$f":"ROUND(F33*L33,0)","v":0},null,{"$f":"ROUND(F33*N33,0)","v":0},null,4.1224999999999998E-2,null,0.13389499999999999]
[null,"0334-","Superpave Asphalt Concrete",null,"TN",null,321321,{"$f":"ROUND(F34*L34,0)","v":0},null,{"$f":"ROUND(F34*N34,0)","v":0},null,0.17599999999999999,null,4.6220109999999996]
[null,"0337-","Asphalt Concrete Friction Course",null,"TN",null,321321,0,null,0,null,0.17599999999999999,null,4.6220109999999996]
[null,"0339-1","Miscellaneous Asphalt Pavement",null,"TN",null,321321,0,null,0,null,0.17599999999999999,null,4.6220109999999996]
[null,"0350-1 to 0350-2","Cement Concrete Pavement, Plain",null,"SY",null,321321,0,null,0,null,0.125637,null,0.28075800000000001]
[null,"0350-2-12 added 6-6-2011","Cement Concrete Pavement, Reinforced 11\"",null,"SY",null,null,{"$f":"ROUND(F38*L38,0)","v":0},null,{"$f":"ROUND(F38*N38,0)","v":0},null,0.17918600000000001,null,0.110795]
[null,"0400-1- to 0400-4- & 400-0-13","Concrete Class I to IV  added 5/6/09",null,"CY",null,321321,0,null,0,null,0.25506699999999999,null,1.8677330000000001]
[null,"0400-8-","Concrete Class V",null,"CY",null,321321,0,null,0,null,0.25714999999999999,null,1.8555999999999999]
[null,"0400-16","Class VI added 7/11/08",null,"CY",null,321321,0,null,0,null,0.25506699999999999,null,1.8677330000000001]
[null,"0410-70-","Precast Concrete Box Culvert",null,"LF",null,321321,0,null,0,null,0.26340000000000002,null,3.2593000000000001]
[null,"0415-1-","Reinforcing Steel",null,"LB",null,321321,0,null,0,null,9.9999999999999994E-12,null,1.3110000000000001E-3]
[null,"0425-1- to 0425-3-",{"$f":"VLOOKUP(B44,FuelFactorDataRange,2,FALSE)","v":"Drainage Inlets, Manholes or Junction Boxes"},null,"EA",null,321321,0,null,0,null,1.3169999999999999,null,7.9226000000000001]
[null,"0425- 7","Manhole Cover-Replace 10-9-2012",null,"EA",null,null,{"$f":"ROUND(F45*L45,0)","v":0},null,{"$f":"ROUND(F45*N45,0)","v":0},null,1.3169999999999999,null,7.9226000000000001]
[null,"0425-1213 and 1575","Inlets, Curb, Type 10, J Bot <10'",null,"EA",null,321321,{"$f":"ROUND(F46*L46,0)","v":0},null,{"$f":"ROUND(F46*N46,0)","v":0},null,1.3169999999999999,null,7.9226000000000001]
[null,"0430-171- to 0430-174- &175","Pipe Concrete Culvert   added 4/27/09",null,"LF",null,321321,0,null,0,null,0.16947799999999999,null,0.56260399999999999]
[null,"0430-610,611,612,613","Pipe Concrete Culvert   added 7/11/08",null,"LF",null,321321,0,null,0,null,0.16947799999999999,null,0.56260399999999999]
[null,"0430-721-","Pipe Concrete Culvert",null,"LF",null,321321,{"$f":"ROUND(F49*L49,0)","v":0},null,{"$f":"ROUND(F49*N49,0)","v":0},null,0.16947799999999999,null,0.56260399999999999]
[null,"0450-1-","Prestressed Beams",null,"LF",null,321321,0,null,0,null,3.5099999999999999E-2,null,0.86040000000000005]
[null,"0450-2-45 to 84","Prestressed Beams - Florida-I Beams 45\" to 84\"",null,"LF",null,321321,{"$f":"ROUND(F51*L51,0)","v":0},null,{"$f":"ROUND(F51*N51,0)","v":0},null,3.5099999999999999E-2,null,0.86040000000000005]
[null,"0450-3-",{"$f":"VLOOKUP(B52,FuelFactorDataRange,2,FALSE)","v":"Prestressed Slabs"},null,"LF",null,321321,0,null,0,null,3.5099999999999999E-2,null,0.86780000000000002]
[null,"0450-4-","Prestressed Beams",null,"LF",null,321321,0,null,0,null,3.5099999999999999E-2,null,0.86040000000000005]
[null,"0455-14- to 0455-35-","Piling (Prestressed Concrete)",null,"LF",null,321321,0,null,0,null,4.6800000000000001E-2,null,0.20080000000000001]
[null,"0455-35-1 and 20","Steel Piling HP 8X36 & 18\" Dia. Pipe  added 6-6-11  ",null,"LF",null,2345,{"$f":"ROUND(F55*L55,0)","v":0},null,{"$f":"ROUND(F55*N55,0)","v":0},null,0.14369699999999999,null,0.391735]
[null,"0455-88-","Drilled Shaft",null,"LF",null,321321,0,null,0,null,2.2810000000000001,null,5.5301]
[null,"0455-143- to 0455-144-","Test Pile",null,"LF",null,null,0,null,0,null,4.6800000000000001E-2,null,0.20080000000000001]
[null,"0460-1-","Structural Steel, Rehabilitation",null,{"$f":"VLOOKUP(B58,FuelFactorDataRange,3,FALSE)","v":"LB"},null,null,{"$f":"ROUND(F58*L58,0)","v":0},null,0,null,{"$f":"VLOOKUP(B58,FuelFactorDataRange,4,FALSE)","v":6.0000000000000002E-5},null,{"$f":"VLOOKUP(B58,FuelFactorDataRange,5,FALSE)","v":1.65E-3}]
[null,"0460-2-","Structural Steel, New Construction",null,"LS/LB",null,null,{"$f":"ROUND(F59*L59,0)","v":0},null,0,null,6.0000000000000002E-5,null,1.65E-3]
[null,"0460-6 & 460-6-2","Ladders & Platforms /Rehab",null,"LB",null,null,{"$f":"ROUND(F60*L60,0)","v":0},null,{"$f":"ROUND(F60*N60,0)","v":0},null,6.0000000000000002E-5,null,1.65E-3]
[null,"0460-15","Stainless Steel Vermin Guard (Maint/Rehab job only)",null,"EA",null,null,{"$f":"ROUND(F61*L61,0)","v":0},null,{"$f":"ROUND(F61*N61,0)","v":0},null,6.0000000000000002E-5,null,1.65E-3]
[null,"0460-95","Structural Steel Repair",null,"LB",null,321321,{"$f":"ROUND(F62*L62,0)","v":0},null,0,null,6.0000000000000002E-5,null,1.65E-3]
[null,"0520-1- to 0520-7","Concrete Curb & Gutter, Traffic Separator, etc.",null,"LF",null,321321,null,null,0,null,9.9999999999999994E-12,null,0.180531]
[null,"0521- & 521-6-11 & 12","Concrete Barier Wall/Parapet(ped./bic. 27\" & 42\")",null,"LF",null,null,{"$f":"ROUND(F64*L64,0)","v":0},null,{"$f":"ROUND(F64*N64,0)","v":0},null,1.84E-2,null,0.15989999999999999]
[null,"0522-","Conc Sidewalk",null,{"$f":"VLOOKUP(B65,FuelFactorDataRange,3,FALSE)","v":"SY"},null,null,{"$f":"ROUND(F65*L65,0)","v":0},null,{"$f":"ROUND(F65*N65,0)","v":0},null,{"$f":"VLOOKUP(B65,FuelFactorDataRange,4,FALSE)","v":9.9999999999999994E-12},null,{"$f":"VLOOKUP(B65,FuelFactorDataRange,5,FALSE)","v":0.28070000000000001}]
[null,"0524-","Concrete Ditch or Slope Pavement",null,{"$f":"VLOOKUP(B66,FuelFactorDataRange,3,FALSE)","v":"SY"},null,321321,0,null,0,null,{"$f":"VLOOKUP(B66,FuelFactorDataRange,4,FALSE)","v":0.36},null,{"$f":"VLOOKUP(B66,FuelFactorDataRange,5,FALSE)","v":0.16900000000000001}]
[null,"0570-1","Performance Turf",null,"SY",null,321321,0,null,0,null,0.01,null,9.9999999999999994E-12]
[null,"Added 327-70-26; 400-16; 400-610 thru 613 on 7/11/08",null,null,"TOTAL (GALLONS)",null,null,{"$f":"SUM(H13:H67)","v":0},null,{"$f":"SUM(J13:J67)","v":0},null,"MONTHLY MONETARY AMOUNT"]
[null,"Added 430-175 on 4/27/09",null,null,"INDEX DIFFERENCE",null,null,{"$f":"IF((L6*1.05)<L8,L8-(L6*1.05),IF((L6*0.95)>L8,L8-(L6*0.95),0.00000000001))","v":9.9999999999999994E-12},null,{"$f":"IF((N6*1.05)<N8,N8-(N6*1.05),IF((N6*0.95)>N8,N8-(N6*0.95),0.00000000001))","v":9.9999999999999994E-12},null,{"$f":"IF((H68*H69)=0,0.000000001,H68*H69)","v":1.0000000000000001E-9},null,{"$f":"IF((J68*J69)=0,0.000000001,J68*J69)","v":1.0000000000000001E-9}]
[null,"Added 400-0-13 on 5/6/09"]
[null,"Added 425-1213 and group 450-2-45, 54, 63, 72, 78 & 84 on 7/1/09"]
[null,"Added  287-1on 9/1/09 (For all on-going jobs)"]
[null,"Added 324-1; 327-70-27 and 520-7 on 3/18/2011"]
[null,"Added 327-70-28 and 521-6-31 on 4/4/2011"]
[null,"Added 350-2-12 & 455-35-20 on 6-6-2011"]
[null,"Added 337 7 51, 337 7 53, 400 3 45 12/7/11"]
[null,"Added 425-1575 on 1/18/2012"]
[null,"Added 334-1-42, and - 43 also added 337-7-60, 337-7-63 and 337-7-66 on 2-1-2012"]
[null,"Added 521-6-12 4-4-2012"]
[null,"Added 521-6-11 5-2-2012"]
[null,"Added 460-15 on 6-4-2012"]
[null,"Added 337 7-23, 110-15, 110-20-2, and 460-6-2 on 8/10/2012"]
[null,"Added 337-7-52 and 425-7 on 9-18/12-2012"]
[null,"Added 110-20-1, 450-1251 & 455-35-1 on 12/5/2012 "]
[null,"Added 425-1-809 & 520-5-26 on 1/2/2013"]

{"sheet":"Instructions - Pay Item adj's","index":2,"n_rows":28,"n_cols":4,"rows_kept":28,"cut":false,"hidden":true,"merged":[[21,0,21,1],[24,0,25,0],[26,0,27,0],[25,2,25,3]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Change the code"]
["Step 1","Open the Microsoft Visual Basic Window (ALT+F11)"]
["Step 2:","Open the code window for Sheet 1 (Setup)"]
["Step 3:","Change the values MainFormRowVALUE and TemplateRowVALUE to the number of pay items + 1. "]
[null,"i.e. For the range of B13:N64, there are 52 items + 1, makes the correct one be 53 for the value.","Adjust the \"Template\" worksheet's range"]
["Step 4:","Change the ranges MainFormRANGE and TemplateRANGE to match the range on the \"FuelWS\" sheet","Step 5: ","Unhide the Template worksheet"]
[null,"i.e. \"B13:N64\" -- First cell (B13), Last Cell (N64) ; Last cell is  the one you'll be changing to match the last row.","Step 6:","Add or remove rows to match the number of rows in the \"FuelWS\" worksheet"]

{"sheet":"Template","index":3,"n_rows":66,"n_cols":14,"rows_kept":66,"cut":false,"hidden":true,"merged":[[9,1,11,1],[13,2,13,3],[25,2,25,3],[26,2,26,3],[12,2,12,3],[64,11,64,14],[30,2,30,3],[63,2,63,3],[42,2,42,3],[62,2,62,3],[36,2,36,3],[40,2,40,3],[32,2,32,3],[64,2,64,3],[43,2,43,3],[37,2,37,3],[41,2,41,3],[33,2,33,3],[1,2,1,11],[2,2,2,11],[38,2,38,3],[7,3,7,4],[15,2,15,3],[3,3,3,4],[16,2,16,3],[27,2,27,3],[5,3,5,4],[9,2,11,3],[22,2,22,3],[17,2,17,3],[29,2,29,3],[28,2,28,3],[24,2,24,3],[9,13,11,14],[9,11,11,12],[21,2,21,3],[20,2,20,3],[19,2,19,3],[18,2,18,3],[9,9,11,10],[9,7,11,8],[9,5,11,6],[65,2,65,3],[35,2,35,3],[9,4,11,4],[14,2,14,3],[31,2,31,3],[34,2,34,3],[65,4,65,5],[23,2,23,3],[64,4,64,5],[39,2,39,3]]}
[]
[null,null,"CONTRACTOR'S ESTIMATED FUEL WORKSHEET"]
[null,null,"(DESIGN BUILD AND LUMP SUM PROJECTS)"]
[null,"CONTRACTOR:",{"$f":"ContractorName","v":0},"DATE FROM:",null,{"$f":"DateFrom","v":"00:00:00"},null,null,null,"MONTH / YEAR",null,"GASOLINE INDEX",null,"DIESEL INDEX"]
[]
[null,"WORKSHEET NO.:",{"$f":"CertificationNumber","v":0},"DATE TO:",null,{"$f":"DateTo","v":"00:00:00"},null,"BASE INDEX:",null,{"$f":"BaseIndexMonth","v":"00:00:00"},null,{"$f":"GasolineBaseIndex","v":0},null,{"$f":"DieselBaseIndex","v":0}]
[]
[null,"FINANCIAL PROJECT ID:",{"$f":"FinancialIDNumber","v":0},"CONTRACT NO.:",null,{"$f":"ContractNumber","v":0},null,"CURRENT INDEX:",null,{"$f":"CurrentIndexMonth","v":"00:00:00"},null,{"$f":"GasolineCurrentIndex","v":0},null,{"$f":"DieselCurrentIndex","v":0}]
[]
[null,"PAY ITEM NUMBER(S)","ITEM DESCRIPTION",null,"UNIT","QUANTITY",null,"GASOLINE\n(GALLONS)",null,"DIESEL\n(GALLONS)",null,"GASOLINE\nFACTOR",null,"DIESEL\nFACTOR"]
[]
[]
[null,null,null,null,null,null,null,{"$f":"ROUND(F13*L13,0)","v":0},null,{"$f":"ROUND(F13*N13,0)","v":0}]
[null,null,null,null,null,null,null,{"$f":"ROUND(F14*L14,0)","v":0},null,{"$f":"ROUND(F14*N14,0)","v":0}]
[null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,{"$f":"ROUND(F45*L45,0)","v":0},null,{"$f":"ROUND(F45*N45,0)","v":0}]
[null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,"TOTAL (GALLONS)",null,null,{"$f":"SUM(H13:H64)","v":0},null,{"$f":"SUM(J13:J64)","v":0},null,"MONTHLY MONETARY AMOUNT"]
[null,null,null,null,"INDEX DIFFERENCE",null,null,{"$f":"IF((L6*1.05)<L8,L8-(L6*1.05),IF((L6*0.95)>L8,L8-(L6*0.95),0.00000000001))","v":9.9999999999999994E-12},null,{"$f":"IF((N6*1.05)<N8,N8-(N6*1.05),IF((N6*0.95)>N8,N8-(N6*0.95),0.00000000001))","v":9.9999999999999994E-12},null,{"$f":"IF((H65*H66)=0,0.000000001,H65*H66)","v":1.0000000000000001E-9},null,{"$f":"IF((J65*J66)=0,0.000000001,J65*J66)","v":1.0000000000000001E-9}]

{"sheet":"Accuracy","index":4,"n_rows":29,"n_cols":10,"rows_kept":29,"cut":false,"hidden":true,"merged":[[2,2,2,3],[2,7,2,9],[28,1,28,4],[14,2,14,3],[14,7,14,9]]}
[]
[]
[null,null,"Pay Item Accuracy Table",null,null,null,null,"Pay Item Units Table"]
[]
[null,null,"Rounding Display","Round Function",null,null,null,"Units","Directory Name","Accuracy"]
[null,null,null,"Value",null,null,null,null,null,"(Decimal Places)"]
[]
[null,null,1E-3,3,null,null,null,"English","eng","1"]
[null,null,0.01,2,null,null,null,"Metric","met","1"]
[null,null,0.1,1]
[null,null,1,0]
[]
[]
[]
[null,null,"Area Conversion Table",null,null,null,null,"Weight/Volume Units Table"]
[]
[null,null,"Pay Item Units","Conversion Factor",null,null,null,"Units","Weight","Volume"]
[]
[null,null,"AC",43560,null,null,null,"CY",null,"(CY)"]
[null,null,"HA",10000,null,null,null,"GA",null,"(GA)"]
[null,null,"M2",1,null,null,null,"KG","(KG)"]
[null,null,"SF",1,null,null,null,"KL",null,"(KL)"]
[null,null,"SY",9,null,null,null,"LB","(LB)"]
[null,null,null,null,null,null,null,"LI",null,"(LI)"]
[null,null,null,null,null,null,null,"MG",null,"(MG)"]
[null,null,null,null,null,null,null,"MT","(MT)"]
[null,null,null,null,null,null,null,"M3",null,"(M3)"]
[null,null,null,null,null,null,null,"TN","(TN)"]
[null,"NOTE: Do Not Change"]

{"sheet":"FuelFactors","index":5,"n_rows":48,"n_cols":8,"rows_kept":48,"cut":false,"hidden":true,"merged":[[2,4,2,7]]}
[]
[]
[null,null,"English or Metric","English or Metric","English"]
[null,null,"Pay Item Number(s)","Description","Unit","Gasoline ","Diesel ","Accuracy"]
[null,null,null,null,null,"Factor","Factor"]
[]
[null,null,"0110-1-1","Clearing & Grubbing","LS/AC",32,45.64,"1"]
[null,null,"0120-1","Regular Excavation","CY",2.8E-3,0.20150000000000001,"1"]
[null,null,"0120-2-2","Borrow Excavation","CY",3.8999999999999998E-3,0.44409999999999999,"1"]
[null,null,"0120-3","Lateral Ditch Excavation","CY",9.9999999999999994E-12,5.33E-2,"1"]
[null,null,"0120-4 to 120-5","Subsoil or Channel Excavation","CY",4.3E-3,0.27879999999999999,"1"]
[null,null,"0120-6","Embankment","CY",3.4099999999999998E-2,0.51749999999999996,"1"]
[null,null,"0160-4","Type B Stabilization","SY",3.0599999999999999E-2,0.1196,"1"]
[null,null,"0162","Soil Layer","SY",9.9999999999999994E-12,6.0000000000000001E-3,"1"]
[null,null,"0285-701 to 0285-708","Base Optional (Group 01 to 08) ","SY",5.6007000000000001E-2,0.215614,"1"]
[null,null,"0285-709 to 0285-715","Base Optional (Group 09 to 15) ","SY",9.2254000000000003E-2,0.43591600000000003,"1"]
[null,null,"0285-701 to 0285-708 (Asph)","Base Superpave Type 12.5  (Asphalt Only)","SY",4.0149999999999998E-2,0.97328800000000004,"1"]
[null,null,"0285-709 to 0285-715 (Asph)","Base Superpave Type 12.5  (Asphalt Only)","SY",6.6000000000000003E-2,1.5999570000000001,"1"]
[null,null,"0286-1","Turnout Construction","SY",2.64E-2,0.6925,"1"]
[null,null,"0286-2","Turnout Construction","TN",0.17599999999999999,4.6220109999999996,"1"]
[null,null,"0327-70-1 to 0327-70-13","Mill Existing Asphalt Pavement","SY",2.7969000000000001E-2,9.1162000000000007E-2,"1"]
[null,null,"0327-70-14 to 0327-70-25","Mill Existing Asphalt Pavement","SY",4.1224999999999998E-2,0.13389499999999999,"1"]
[null,null,"0334-","Superpave Asphalt Concrete","TN",0.17599999999999999,4.6220109999999996,"1"]
[null,null,"0337-","Asphalt Concrete Friction Course (Rubber)","TN",0.17599999999999999,4.6220109999999996,"1"]
[null,null,"0339-1","Miscellaneous Asphalt Pavement","TN",0.17599999999999999,4.6220109999999996,"1"]
[null,null,"0350-1 to 0350-2","Cement Concrete Pavement, Plain","SY",0.12562699999999999,0.28075800000000001,"1"]
[null,null,"0400-1- to 0400-4-","Concrete Class I to IV","CY",0.25506699999999999,1.8677330000000001,"1"]
[null,null,"0400-8-","Concrete Class V","CY",0.25714999999999999,1.8555999999999999,"1"]
[null,null,"0410-70-","Precast Concrete Box Culvert","LF",0.26340000000000002,3.2593000000000001,"1"]
[null,null,"0415-1-","Reinforcing Steel","LB",9.9999999999999994E-12,1.3110000000000001E-3,"1"]
[null,null,"0425-1- to 0425-3-","Drainage Inlets, Manholes or Junction Boxes","EA",1.3169999999999999,7.9226000000000001,"1"]
[null,null,"0430-171- to 0430-174-","Pipe Concrete Culvert","LF",0.16947799999999999,0.56260399999999999,"1"]
[null,null,"0430-721-","Pipe Concrete Culvert","LF",0.16947799999999999,0.56260399999999999,"1"]
[null,null,"0450-1-","Prestressed Beams","LF",3.5099999999999999E-2,0.86040000000000005,"1"]
[null,null,"0450-3-","Prestressed Slabs","LF",3.5099999999999999E-2,0.86780000000000002,"1"]
[null,null,"0450-4-","Prestressed Beams","LF",3.5099999999999999E-2,0.86040000000000005,"1"]
[null,null,"0455-14- to 0455-35-","Piling (Prestressed Concrete)","LF",4.6800000000000001E-2,0.20080000000000001,"1"]
[null,null,"0455-88-","Drilled Shaft","LF",2.2810000000000001,5.5301,"1"]
[null,null,"0455-143- to 0455-144-","Test Pile","LF",4.6800000000000001E-2,0.20080000000000001,"1"]
[null,null,"0460-1-","Structural Steel, Rehabilitation","LB",6.0000000000000002E-5,1.65E-3,"1"]
[null,null,"0460-2-","Structural Steel, New Construction","LS/LB",6.0000000000000002E-5,1.65E-3,"1"]
[null,null,"0460-6","Ladders & Platforms","LB",6.0000000000000002E-5,1.65E-3,"1"]
[null,null,"0460-95","Structural Steel Repair","LB",6.0000000000000002E-5,1.65E-3,"1"]
[null,null,"0520-1- to 0520-7","Concrete Curb & Gutter, Traffic Separator, etc.","LF",9.9999999999999994E-12,0.180531,"1"]
[null,null,"0521-","Barrier Wall Concrete","LF",1.84E-2,0.15989999999999999,"1"]
[null,null,"0522-","Conc Sidewalk","SY",9.9999999999999994E-12,0.28070000000000001,"1"]
[null,null,"0524-","Concrete Ditch or Slope Pavement","SY",0.36,0.16900000000000001,"1"]
[null,null,"0570-1","Performance Turf","SY",0.01,9.9999999999999994E-12,"1"]