{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Digital Signature-Instructions","Setup","FuelWS","Sheet2","Instructions - Pay Item adj's","Template","Accuracy","FuelFactors"],"not_rendered":{"charts":0,"images":13,"macros":1,"external_links":0,"defined_names":25,"comments":1,"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":"Digital Signature-Instructions","index":0,"n_rows":137,"n_cols":3,"rows_kept":137,"cut":false,"hidden":false,"merged":[[82,2,82,14],[0,0,14,12],[16,1,16,14],[15,1,15,14],[62,2,62,12],[36,2,36,14]]}
["Prior to applying your digital signature in Excel, \nensure Calculation Options are set to Manual, then click Calculate Now."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Note:"]
[null,"If emailing this file, do not use the \"Share\" option in Excel. This will remove the digital signature/certificate. Instead, attach the digitally signed file to an email.\n\nTo save the attached file to an email, save using \"Drag and Drop\" or \"Right Click\" on the file and select \"Save As\". Otherwise, a new version of the document will be created, which will invalidate the digital signature."]
[]
["1.",null,"Save document (i.e., \"File\", \"Save As\"). Enter required information in the \"Setup Tab\"."]
[]
["2.",null,"Enter quantities in the \"FuelWS\" Tab as applicable."]
[]
["3.",null,"Select the \"View Signatures\" button in the \"Yellow ribbon\" above."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["4.",null,"The \"Signatures\" window will open. Select \"Contractor's Authorized Agent\". Then click on the drop arrow and select \"Sign…\""]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["5.",null,"Enter the name of the Contractor's Authorized Agent.\nOptional: Select \"Details...\" to enter contact information (i.e., address).\nSelect \"Sign\" to finalize digital signature."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["6.",null,"Notice that any edits done to the document after it has ben digitally signed will invalidate the signature certificate. The document will have to be created and signed again."]
[]
[]
[]
["7.",null,"View/access the signature after document has been digitally signed:"]
[]
[null,"a.","Select \"File\"."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"b.","Select \"View Signatures\"."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"c.","Select the drop down arrow and select \"Signature Details…\""]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"d.","Select the different options to see the desired signature details."]

{"sheet":"Setup","index":1,"n_rows":32,"n_cols":15,"rows_kept":32,"cut":false,"hidden":false,"merged":[[1,1,1,16],[2,1,2,16],[3,1,3,16],[4,10,4,12],[33,1,33,3],[27,6,27,15],[23,10,23,12],[23,14,23,15],[32,1,32,3],[30,1,30,3],[31,1,31,3],[11,5,11,15],[7,5,7,15],[7,2,7,3],[9,2,9,3],[9,5,9,15],[11,2,11,3],[13,2,13,3],[13,5,13,9],[13,10,13,12],[13,14,13,15],[17,3,17,8],[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]]}
[]
[]
[null,"Contractor's Certification of Fuel Adjustment"]
[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,"Effective April 2021 Letting"]
[null,"(Revision 10/01/21)"]

{"sheet":"FuelWS","index":2,"n_rows":303,"n_cols":14,"rows_kept":303,"cut":false,"hidden":false,"merged":[[1,2,1,13],[2,2,2,13],[66,0,66,3],[66,9,66,10],[68,0,68,9],[47,2,47,3],[48,2,48,3],[7,3,7,4],[5,3,5,4],[3,3,3,4],[9,7,11,8],[22,2,22,3],[9,1,11,1],[14,2,14,3],[37,2,37,3],[35,2,35,3],[201,3,201,6],[69,0,69,2],[38,2,38,3],[39,2,39,3],[40,2,40,3],[41,2,41,3],[42,2,42,3],[43,2,43,3],[44,2,44,3],[45,2,45,3],[46,2,46,3],[65,4,65,5],[63,2,63,3],[36,2,36,3],[20,2,20,3],[21,2,21,3],[34,2,34,3],[9,2,11,3],[12,2,12,3],[9,13,11,14],[9,11,11,12],[19,2,19,3],[18,2,18,3],[9,5,11,6],[9,9,11,10],[17,2,17,3],[13,2,13,3],[15,2,15,3],[9,4,11,4],[64,11,64,14],[64,4,64,5],[71,7,71,11],[104,7,104,11],[72,7,72,11],[73,0,73,16383]]}
[]
[null,null,"CONTRACTOR'S CERTIFICATION OF FUEL ADJUSTMENT"]
[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,"ITEM NUMBER(S)","ITEM DESCRIPTION",null,"UNIT","QUANTITY",null,"GASOLINE\n(GALLONS)",null,"DIESEL\n(GALLONS)",null,"GASOLINE\nFACTOR",null,"DIESEL\nFACTOR"]
[]
[]
[null,"0120-1",{"$f":"VLOOKUP(B13,FuelFactorDataRange,2,FALSE)","v":"Regular Excavation"},null,{"$f":"VLOOKUP(B13,FuelFactorDataRange,3,FALSE)","v":"CY"},null,null,{"$f":"ROUND(F13*L13,0)","v":0},null,{"$f":"ROUND(F13*N13,0)","v":0},null,4.9999999999999992E-3,null,0.32560800000000001]
[null,"0120-2-2","Borrow Excavation",null,"CY",null,null,{"$f":"ROUND(F14*L14,0)","v":0},null,0,null,6.2500000000000003E-3,null,0.47600200000000004]
[null,"0120-3","Lateral Ditch Excavation",null,"CY",null,321321,{"$f":"ROUND(F15*L15,0)","v":0},null,{"$f":"ROUND(F15*N15,0)","v":0},null,1.0999999999999999E-2,null,0.32969300000000001]
[null,"0120-4 ","Excavation Subsoil",null,"CY",null,321321,0,null,0,null,6.7860000000000004E-3,null,0.37409700000000001]
[null,"0120-5","Channel Excavation",null,"CY",null,null,0,null,0,null,0.375,null,0.34926699999999999]
[null,"0120-6","Embankment",null,"CY",null,321321,0,null,0,null,3.1250000000000002E-3,null,0.242148]
[null,"0160-4","Type B Stabilization",null,"SY",null,321321,0,null,0,null,7.0690000000000006E-3,null,0.34140800000000004]
[null,"0285-701 thru 285-708","Optional Base (Base Group 01 thru Group 08)",null,"SY",null,321321,{"$f":"ROUND(F20*L20,0)","v":0},null,0,null,6.3850000000000001E-3,null,0.39591900000000002]
[null,"0285-709 thru 285-715","Optional Base (Base Group 09 thru Group 15)",null,"SY",null,null,{"$f":"ROUND(F21*L21,0)","v":0},null,0,null,1.2217E-2,null,0.78184900000000002]
[null,"0285-701 thru 285-708","Optional Base (Base Group 01 thru 08)  (Asphalt Only)",null,"SY",null,null,0,null,0,null,1.0107E-2,null,0.66379900000000003]
[null,"0285-709 thru 285-715","Optional Base (Base Group 09 thru 15)  (Asphalt Only)",null,"SY",null,null,0,null,0,null,1.6612999999999999E-2,null,1.0911770000000001]
[null,"0285-733","Optional Base (18\" Graded Aggregate) Project 435816-1-52-01",null,"SY",null,null,{"$f":"ROUND(F24*L24,0)","v":0},null,{"$f":"ROUND(F24*N24,0)","v":0},null,1.6274999999999998E-2,null,1.0277620000000001]
[null,"0285-737","Optional Base (18\" Graded Aggregate) Project 410981-8-52-01",null,"SY",null,null,0,null,0,null,1.6274999999999998E-2,null,1.0277620000000001]
[null,"0285-738","Optional Base (18\" Graded Aggregate) Project 431883-6-52-01",null,"SY",null,null,0,null,0,null,1.6274999999999998E-2,null,1.0277620000000001]
[null,"0285-739","Optional Base (18\" Graded Aggregate) Project 439892-1-52-01",null,"SY",null,null,0,null,0,null,1.6274999999999998E-2,null,1.0277620000000001]
[null,"0285-740","Optional Base (18\" Graded Aggregate) Project 217910-4-32-01",null,"SY",null,null,0,null,0,null,1.6274999999999998E-2,null,1.0277620000000001]
[null,"0285-742","Optional Base (21\" Graded Aggregate) Project 218594-2-52-01",null,"SY",null,null,0,null,0,null,2.0237999999999999E-2,null,1.2392559999999999]
[null,"0285-748","Optional Base (15\" Graded Aggregate) Project 441882-1-52-01",null,"SY",null,null,0,null,0,null,1.4813000000000002E-2,null,0.89824700000000002]
[null,"0285-749","Optional Base (20\" Graded Aggregate) Project 442915-1-52-01",null,"SY",null,null,0,null,0,null,1.9750999999999998E-2,null,1.19621]
[null,"0285-750","Optional Base (20\" Graded Aggregate) Project 437763-1-52-01",null,"SY",null,null,null,null,null,null,1.9750999999999998E-2,null,1.19621]
[null,"0285-753","Optional Base (16\" Graded Aggregate) Project 439740-1-52-01",null,"SY",null,null,null,null,null,null,1.5299000000000002E-2,null,0.94128699999999998]
[null,"0285-754","Optional Base (17\" Graded Aggregate) Project 222539-3-52-01",null,"SY",null,null,null,null,null,null,1.5788999999999997E-2,null,0.98471799999999998]
[null,"0286-1","Turnout Construction",null,"SY",null,321321,0,null,0,null,6.3735E-2,null,0.36090100000000003]
[null,"0286-2","Turnout Construction",null,"TN",null,321321,0,null,0,null,3.5442000000000001E-2,null,1.272316]
[null,"0287-1","Permeable Base (Asphalt Treated) added 9/1/09",null,"CY",null,321321,{"$f":"ROUND(F37*L37,0)","v":0},null,{"$f":"ROUND(F37*N37,0)","v":0},null,5.3699999999999998E-2,null,2.701117]
[null,"0334-1-11","Superpave Asphalt Concrete (Traffic Level A)",null,"TN",null,321321,{"$f":"ROUND(F38*L38,0)","v":0},null,{"$f":"ROUND(F38*N38,0)","v":0},null,5.3699999999999998E-2,null,2.701117]
[null,"0334-1-12","Superpave Asphalt Concrete (Traffic Level B)",null,"TN",null,null,0,null,0,null,5.3699999999999998E-2,null,2.701117]
[null,"0334-1-13","Superpave Asphalt Concrete (Traffic Level C)",null,"TN",null,null,{"$f":"ROUND(F40*L40,0)","v":0},null,0,null,5.3699999999999998E-2,null,2.701117]
[null,"0334-1-14","Superpave Asphalt Concrete (Traffic Level D)",null,"TN",null,null,0,null,0,null,5.3699999999999998E-2,null,2.701117]
[null,"0334-1-15","Superpave Asphalt Concrete (Traffic Level E)",null,"TN",null,null,0,null,0,null,5.3699999999999998E-2,null,2.701117]
[null,"0334-1-52","Superpave Asphalt Concrete (Traffic B) PG76-22 ",null,"TN",null,null,{"$f":"ROUND(F43*L43,0)","v":0},null,{"$f":"ROUND(F43*N43,0)","v":0},null,5.3699999999999998E-2,null,2.701117]
[null,"0334-1-53","Superpave Asphalt Concrete (Traffic C) PG76-22 ",null,"TN",null,null,{"$f":"ROUND(F44*L44,0)","v":0},null,{"$f":"ROUND(F44*N44,0)","v":0},null,5.3699999999999998E-2,null,2.701117]
[null,"0334-1-54","Superpave Asphalt Concrete (Traffic D) PG76-22 ",null,"TN",null,null,{"$f":"ROUND(F45*L45,0)","v":0},null,{"$f":"ROUND(F45*N45,0)","v":0},null,5.3699999999999998E-2,null,2.701117]
[null,"0334-1-55","Superpave Asphalt Concrete (Traffic E) PG76-22 ",null,"TN",null,null,{"$f":"ROUND(F46*L46,0)","v":0},null,{"$f":"ROUND(F46*N46,0)","v":0},null,5.3699999999999998E-2,null,2.701117]
[null,"0334-1-56","Superpave Asphalt Concrete (Traffic B) High Polymer",null,"TN",null,null,{"$f":"ROUND(F47*L47,0)","v":0},null,{"$f":"ROUND(F47*N47,0)","v":0},null,5.3699999999999998E-2,null,2.701117]
[null,"0334-1-57","Superpave Asphalt Concrete (Traffic C) High Polymer",null,"TN",null,null,{"$f":"ROUND(F48*L48,0)","v":0},null,{"$f":"ROUND(F48*N48,0)","v":0},null,5.3699999999999998E-2,null,2.701117]
[null,"0334-1-58","Superpave Asphalt Concrete (Traffic D) High Polymer",null,"TN",null,null,{"$f":"ROUND(F49*L49,0)","v":0},null,{"$f":"ROUND(F49*N49,0)","v":0},null,5.3699999999999998E-2,null,2.701117]
[null,"0334-1-59","Superpave Asphalt Concrete (Traffic E) High Polymer",null,"TN",null,null,0,null,0,null,5.3699999999999998E-2,null,2.701117]
[null,"0337-7-25","Asp Conc.Friction Course Incl. Bit, (FC5) PG 76-22",null,"TN",null,null,{"$f":"ROUND(F51*L51,0)","v":0},null,{"$f":"ROUND(F51*N51,0)","v":0},null,5.3699999999999998E-2,null,2.701117]
[null,"0337-7-26","Asp Conc.Friction Course Incl. Bit, (FC5) PG 76-22 High Polymer",null,"TN",null,null,{"$f":"ROUND(F52*L52,0)","v":0},null,{"$f":"ROUND(F52*N52,0)","v":0},null,5.3699999999999998E-2,null,2.701117]
[null,"0337-7-80","Asp Conc.Fric Course (Traffic B)(FC9.5) PG76.22",null,"TN",null,null,{"$f":"ROUND(F53*L53,0)","v":0},null,{"$f":"ROUND(F53*N53,0)","v":0},null,5.3699999999999998E-2,null,2.701117]
[null,"0337-7-81","Asp Conc.Fric Course (Traffic B)(FC12.5) PG76.22",null,"TN",null,null,{"$f":"ROUND(F54*L54,0)","v":0},null,{"$f":"ROUND(F54*N54,0)","v":0},null,5.3699999999999998E-2,null,2.701117]
[null,"0337-7-82","Asp Conc.Fric Course (Traffic C)(FC9.5) PG76.22",null,"TN",null,null,{"$f":"ROUND(F55*L55,0)","v":0},null,{"$f":"ROUND(F55*N55,0)","v":0},null,5.3699999999999998E-2,null,2.701117]
[null,"0337-7-83","Asp Conc.Fric Course (Traffic C)(FC12.5) PG76.22",null,"TN",null,null,{"$f":"ROUND(F56*L56,0)","v":0},null,{"$f":"ROUND(F56*N56,0)","v":0},null,5.3699999999999998E-2,null,2.701117]
[null,"0337-7-85","Asp Conc.Fric Course (Traffic D)(FC12.5) PG76.22",null,"TN",null,null,{"$f":"ROUND(F57*L57,0)","v":0},null,{"$f":"ROUND(F57*N57,0)","v":0},null,5.3699999999999998E-2,null,2.701117]
[null,"0337-7-88","Asp Conc.Fric Course (Traffic E)(FC12.5) PG76.22",null,"TN",null,null,{"$f":"ROUND(F58*L58,0)","v":0},null,{"$f":"ROUND(F58*N58,0)","v":0},null,5.3699999999999998E-2,null,2.701117]
[null,"0337-7-90","Asp Conc.Fric Course (Traffic B)(FC9.5), High Polymer",null,"TN",null,null,{"$f":"ROUND(F59*L59,0)","v":0},null,{"$f":"ROUND(F59*N59,0)","v":0},null,5.3699999999999998E-2,null,2.701117]
[null,"0337-7-91","Asp Conc.Fric Course (Traffic B)(FC12.5), High Polymer",null,"TN",null,null,null,null,null,null,5.3699999999999998E-2,null,2.701117]
[null,"0337-7-92","Asp Conc.Fric Course (Traffic C)(FC9.5), High Polymer",null,"TN",null,null,null,null,null,null,5.3699999999999998E-2,null,2.701117]
[null,"0337-7-93","Asp Conc.Fric Course (Traffic C)(FC12.5), High Polymer",null,"TN",null,null,{"$f":"ROUND(F62*L62,0)","v":0},null,{"$f":"ROUND(F62*N62,0)","v":0},null,5.3699999999999998E-2,null,2.701117]
[null,"0337-7-94","Asp Conc.Fric Course (Traffic D)(FC12.5), High Polymer",null,"TN",null,null,{"$f":"ROUND(F63*L63,0)","v":0},null,{"$f":"ROUND(F63*N63,0)","v":0},null,5.3699999999999998E-2,null,2.701117]
[null,"0339-1","Miscellaneous Asphalt Pavement",null,"TN",null,321321,0,null,0,null,0.1074,null,2.4684569999999999]
[null,"Updated 10-01-2021",null,null,"TOTAL (GALLONS)",null,null,{"$f":"SUM(H13:H64)","v":0},null,{"$f":"SUM(J13:J64)","v":0},null,"MONTHLY MONETARY AMOUNT"]
[null,"* Quantity for LS pay items = Total Quantity of Secondary unit X % of work completed",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}]
[]
[]
["I certify that, based on my personal knowledge and well-founded belief following my own reasonable investigation, the gallons (metric tons and liters) represented by this Certification are true and correct."]
["* Calculations based on Specifications."]
[]
[]
[]
[" (Name of Company and email address)"]
[]
[null,"Updated 2-09-2021"]
[null,"0285-754"]
[null,"Updated 7-07-2020"]
[null,"0285-753"]
[null,"Updated 6-11-2020"]
[null,"0285-752"]
[null,"Updated 5-07-2020"]
[null,"0285-751"]
[null,"Updated 4-07-2020"]
[null,"0285-748"]
[null,"0285-749"]
[null,"0285-750"]
[null,"Updated 2-06-2020"]
[null,"0285-747"]
[null,"Updated 12-10-2019"]
[null,"0285-745"]
[null,"0285-746"]
[null,"Updated 11-05-2019"]
[null,"0285-743"]
[null,"0285-744"]
[null,"0430885-30"]
[null,"Updated 8-06-2019"]
[null,"0285-742"]
[null,"0327-70-46"]
[null,"0425-1921"]
[null,"0425-1922"]
[null,"0425-1923"]
[null,"0425-1924"]
[null,"0425-1925"]
[null,"Updated 6-06-2019"]
[null,"0285-741"]
[null,"0455-34-125"]
[null,"Updated 5-09-2019"]
[null,"0285-740"]
[null,"0430-175-199"]
[null,"Updated 4-08-2019"]
[null,"0285-739"]
[null,"0450-8-31"]
[null,"Updated 3-11-2019"]
[null,"0285-738"]
[null,"0407-1-11"]
[null,"0407-1-21"]
[null,"0425-1795"]
[null,"0521-9-1"]
[null,"Updated 2-13-2019"]
[null,"0350-3-6"]
[null,"0425-1785"]
[null,"0520-5-52"]
[null,"Updated 1-07-2019"]
[null,"0285-736"]
[null,"0285-737"]
[null,"0570-1-3"]
[null,"Updated 11-05-2018"]
[null,"0425-1782"]
[null,"0521-72-42"]
[null,"0521-72-44"]
[null,"Updated 10-03-2018"]
[null,"0285-735"]
[null,"Updated 09-06-2018"]
[null,"0425-1781"]
[null,"0425-1783"]
[null,"0425-1791"]
[null,"0425-1792"]
[null,"0425-1793"]
[null,"0425-1799"]
[null,"0450-8-32"]
[null,"0521-72-60"]
[null,"0521-72-61"]
[null,"Updated 08-06-2018"]
[null,"0521-5-22"]
[null,"0521-8-8"]
[null,"0521-72-41"]
[null,"Updated 07-06-2018"]
[null,"0450-8-14"]
[null,"0521-5-14"]
[null,"0521-72-24"]
[null,"Updated 06-06-2018"]
[null,"0285-734"]
[null,"0521-72-43"]
[null,"Updated 05-07-2018"]
[null,"0430885-24"]
[null,"0430886-24"]
[null,"Updated 03-05-2018"]
[null,"0285-733"]
[null,"0425-1482"]
[null,"0430-886-36"]
[null,"0521-72-27"]
[null,"Updated 02-05-2018"]
[null,"0430-886-60"]
[null,"0450-8-11"]
[null,"0521-72-56"]
[null,"Updated 01-08-2018"]
[null,"   0285-732"]
[null,"   0521-72-40"]
[null,"Updated 11-06-2017"]
[null,"   0120-1-900"]
[null,"   0120-4-900"]
[null,"   0120-6-900"]
[null,"   0160-4-900"]
[null,"   0285-701-900"]
[null,"   0285-709-900"]
[null,"   0521-1-11"]
[null,"   0521-1-12"]
[null,"   0521-1-13"]
[null,"   0521-1-14"]
[null,"Updated 09-06-2017"]
[null,"0334-1-59"]
[null,"0460-94"]
[null,"0521-8-7"]
[null,"0521-8-11"]
[null,"Updated 08-03-2017"]
[null,"0285-731"]
[null,"Updated 07-14-2017"]
[null,"0285-730"]
[null,"0327-70-45"]
[null,"Updated 06-07-2017"]
[null,"0337-7-91"]
[null,"0337-7-92"]
[null,"0521-5-12"]
[null,"Updated 05-08-2017"]
[null,"0285-722"]
[null,"0350-3-15"]
[null,"0415-2-4"]
[null,"0415-2-5"]
[null,"0415-2-9"]
[null,"Updated 04-10-2017"]
[null,"0327-70-44"]
[null,"Updated 03-06-2017"]
[null,"0350-3-14"]
[null,"Updated 02-06-2017"]
[null,"0337-7-80"]
[null,"0337-7-81"]
[null,"0337-7-82"]
[null,"0337-7-83"]
[null,"0337-7-85"]
[null,"0337-7-88"]
[null,"Updated 12-13-2016"]
[null,"0450-8-13"]
[null,"0450-8-33"]
[null,"Updated 11-06-2016"]
[null,"0334-1-58"]
[null,"0337-7-26"]
[null,"0337-7-94"]
[null,"Updated 10-06-2016"]
[null,"0110-4-10"]
[null,"0407-1-52"]
[null,"0430-885-12"]
[null,"0430-885-18"]
[null,"0430-885-36"]
[null,"0430-885-42"]
[null,"0430-885-48"]
[null,"0430-885-60"]
[null,"0444-74-1"]
[null,"0444-74-2"]
[null,"0455-34-25"]
[null,"0455-143-25"]
[null,"Updated 09-06-2016"]
[null,"0110-4-3"]
[null,"0110-4-4"]
[null,"0110-4-5"]
[null,"0110-4-6"]
[null,"0110-4-7"]
[null,"0110-4-11"]
[null,"0110-4-12"]
[null,"0110-4-13"]
[null,"0110-4-15"]
[null,"0110-4-16"]
[null,"0110-4-17"]
[null,"0334-1-52"]
[null,"0334-1-53"]
[null,"0334-1-54"]
[null,"0334-1-55"]
[null,"0334-1-56"]
[null,"0334-1-57"]
[null,"0337-7-25"]
[null,"0337-7-90"]
[null,"0337-7-93"]
[null,"0430-611-023"]
[null,"Updated 08-05-2016"]
[null,"0455-14-23"]
[null,"0521-5-13"]
[null,"Updated 07-01-2016"]
[null,"0430-613-229"]
[null,"Updated 06-06-2016"]
[null,"0450-8-23"]
[null,"0450-8-24"]
[null,"Updated 03-08-2016"]
[null,"0400-4-47"]
[null,"0425-3-62"]
[null,"0450-8-12"]
[null,"Updated 02-16-2016"]
[null,"0400-4-40"]
[null,"0400-4-6"]
[null,"Updated 02-09-2016"]
[null,"0350-30-5"]
[null,"0450-8-21"]
[null,"Updated 01-25-2016"]
[null,"0455-35-12"]
[null,"0455-35-13"]
[null,"Updated 12-02-2015"]
[null,"0400-8-4"]
[null,"0450-3-33"]
[null,"0455-35-10"]
[null,"0455-35-11"]
[null,"0521-8-6"]
[null,"Updated 11-01-2015"]
[null,"0455-14-24"]
[null,"0455-34-23"]
[null,"0455-143-23"]
[null,"Updated 10-05-2015"]
[null,"0327-70-42"]
[null,"0455-143-103"]
[null,"0455-143-105"]
[null,"0455-143-203"]
[null,"0455-143-105"]
[null,"Updated 08-05-2015"]
[null,"0450-4-15"]
[null,"0450-7-6"]
[null,"0455-34-103"]
[null,"0455-34-105"]
[null,"0455-34-106"]
[null,"0455-34-107"]
[null,"0455-34-120"]
[null,"0455-34-121"]
[null,"0455-34-203"]
[null,"0455-34-205"]
[null,"0455-34-206"]
[null,"0455-34-207"]

{"sheet":"Sheet2","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Instructions - Pay Item adj's","index":4,"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":5,"n_rows":66,"n_cols":14,"rows_kept":66,"cut":false,"hidden":true,"merged":[[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],[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],[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],[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],[9,1,11,1],[13,2,13,3],[25,2,25,3],[26,2,26,3],[12,2,12,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":6,"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":7,"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"]