{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Digital Signature-Instructions","Setup","BituminousWS","Sheet1","Template","Accuracy"],"not_rendered":{"charts":0,"images":9,"macros":1,"external_links":0,"defined_names":32,"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":"Digital Signature-Instructions","index":0,"n_rows":160,"n_cols":3,"rows_kept":160,"cut":false,"hidden":false,"merged":[[20,2,20,13],[50,2,50,12],[73,2,73,13],[158,0,158,2],[159,1,159,14]]}
[]
["1.",null,"Save document. Enter required information in the \"Setup Tab\"."]
[]
["2.",null,"In the \"BituminousWS\" tab, verify information for accuracy. "]
[]
["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."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["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."]

{"sheet":"Setup","index":1,"n_rows":53,"n_cols":11,"rows_kept":53,"cut":false,"hidden":false,"merged":[[6,2,6,3],[48,6,49,15],[6,5,6,15],[8,2,8,3],[8,5,8,15],[10,2,10,3],[10,5,10,15],[20,2,20,6],[20,8,20,15],[16,2,16,15],[12,14,12,15],[22,9,22,12],[22,14,22,15],[18,2,18,6],[18,8,18,15],[12,2,12,3],[0,1,0,16],[1,1,1,16],[2,1,2,16],[3,5,3,9],[3,10,3,12],[21,2,21,5],[22,4,22,7],[12,5,12,9],[12,10,12,12],[24,1,24,2],[24,4,24,7],[24,8,24,12],[24,14,24,15],[28,2,28,15],[30,2,30,6],[30,8,30,15],[44,1,44,2],[40,8,40,15],[32,14,32,15],[42,9,42,12],[44,4,44,7],[44,8,44,12],[32,4,32,7],[32,9,32,12],[40,2,40,6],[42,4,42,7],[52,1,52,3],[34,1,34,2],[34,4,34,7],[34,8,34,12],[34,14,34,15],[38,2,38,15],[39,1,39,16],[42,14,42,15],[51,1,51,3],[44,14,44,15]]}
[null,"Contractor's Certification of Quantities Worksheet"]
[null,"Asphalt Mixes with Modified and Unmodified Binders"]
[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,"Asphalt Mixes with Unmodified Binders (PG 67 & Lower)"]
[]
[null,null,"Asphalt Tonnage Placed:"]
[]
[null,null,"Additional Gallons (ARMI*):"]
[null,null,"*Asphalt Rubber Membrane Interlayer"]
[null,null,"Base Index Month:",null,null,null,null,null,null,"Base Asphalt Price Index:"]
[]
[null,"Current Index Month:",null,null,null,null,null,null,"Current Asphalt Price Index:"]
[]
[]
[]
[null,null,"Asphalt Mixes with Modified Binders (PG 76 & Higher)"]
[]
[null,null,"Polymer Tonnage Placed:"]
[]
[null,null,"Base Index Month:",null,null,null,null,null,null,"Base Polymer Price Index:"]
[]
[null,"Current Index Month:",null,null,null,null,null,null,"Current Polymer Price Index:"]
[]
[]
[]
[null,null,"Asphalt Material"]
[null," (ASPHALT TREATED PERMEABLE BASE)"]
[null,null,"Asphalt Tonnage Placed:"]
[]
[null,null,"Base Index Month:",null,null,null,null,null,null,"Base Asphalt Price Index:"]
[]
[null,"Current Index Month:",null,null,null,null,null,null,"Current Asphalt Price Index:"]
[]
[]
[]
[null,null,null,null,null,null,"Navigation Functions"]
[]
[]
[null,"Effective January 2007 Letting"]
[null,"(Updated 11/07/2016)"]

{"sheet":"BituminousWS","index":2,"n_rows":54,"n_cols":11,"rows_kept":54,"cut":false,"hidden":false,"merged":[[54,10,54,11],[10,1,10,2],[10,3,10,9],[28,6,28,9],[21,1,21,4],[21,6,21,9],[22,1,22,4],[22,6,22,9],[23,1,23,4],[23,6,23,9],[24,1,24,4],[24,6,24,9],[25,1,25,4],[25,6,25,9],[18,1,18,4],[18,6,18,9],[19,1,19,4],[19,6,19,9],[28,1,28,4],[12,3,12,9],[14,1,14,10],[15,2,15,4],[15,6,15,7],[15,8,15,9],[33,1,33,4],[33,6,33,9],[42,6,42,9],[41,6,41,9],[42,1,42,4],[34,1,34,4],[34,6,34,9],[3,1,3,10],[4,1,4,10],[5,1,5,10],[32,1,32,4],[32,6,32,9],[29,1,29,4],[29,6,29,9],[30,1,30,4],[30,6,30,9],[31,1,31,4],[31,6,31,9],[7,2,7,5],[7,6,7,7],[20,1,20,4],[20,6,20,9],[11,3,11,9],[54,4,54,7],[37,1,37,4],[37,6,37,9],[38,1,38,4],[38,6,38,9],[39,6,39,9],[40,6,40,9],[40,1,40,4],[48,1,48,11],[50,6,50,11],[46,1,46,10],[47,1,47,10],[50,1,50,4],[52,1,52,4],[53,7,53,11],[51,7,52,11]]}
[]
[]
[]
[null,"CONTRACTOR'S CERTIFICATION OF QUANTITIES WORKSHEET"]
[null,"ASPHALT MIXES WITH MODIFIED AND UNMODIFIED BONDERS"]
[null,"(DESIGN BUILD AND LUMP SUM PROJECTS)"]
[]
[null,null,"WORKSHEET NO. ",null,null,null,{"$f":"CertificationNumber","v":0}]
[]
[]
[null,"FINANCIAL PROJECT ID.",null,{"$f":"FinancialIDNumber","v":0}]
[null,"CONTRACTOR",null,{"$f":"ContractorName","v":0}]
[null,"CONTRACT NO.",null,{"$f":"ContractNumber","v":0}]
[]
[null,"PERIOD REPRESENTED:"]
[null,"FROM (MO/DAY/YR)",{"$f":"DateFrom","v":"00:00:00"},null,null,null,"TO (MO/DAY/YR)",null,{"$f":"DateTo","v":"00:00:00"}]
[]
[null,"ASPHALT MIXES WITH UNMODIFIED BINDERS (PG 67 & LOWER)"]
[null,"ASPHALT TONNAGE PLACED",null,null,null,null,{"$f":"AsphaltTonnagePlaced","v":0},null,null,null,{"$f":"IF(G19,\"TN\",\"\")","v":""}]
[null,"GALLONS OF ASPHALT CEMENT USED IN MIX *",null,null,null,null,{"$f":"ROUND(IF(G19=0,0,(G19*2.331*6.25)),0)","v":0},null,null,null,{"$f":"IF(G20,\"GA\",\"\")","v":""}]
[null,"ADDITIONAL GALLONS (ARMI*)",null,null,null,null,{"$f":"AsphaltVolumeAdditional","v":0},null,null,null,{"$f":"IF(G21,\"GA\",\"\")","v":""}]
[null,"TOTAL GALLONS",null,null,null,null,{"$f":"IF(G19=0,0,(G20+G21))","v":0},null,null,null,{"$f":"IF(G22,\"GA\",\"\")","v":""}]
[null,{"$f":"CONCATENATE(\"BASE ASPHALT PRICE INDEX FOR (\",IF(AsphaltBaseIndexMonth<>\"\",CONCATENATE(MONTH(AsphaltBaseIndexMonth),\"/\",YEAR(AsphaltBaseIndexMonth)), \"______\"), \"):\")","v":"BASE ASPHALT PRICE INDEX FOR (______):"},null,null,null,null,{"$f":"BaseAsphaltPriceIndex","v":0}]
[null,{"$f":"CONCATENATE(\"CURRENT ASPHALT PRICE INDEX FOR (\",IF(AsphaltCurrentIndexMonth<>\"\",CONCATENATE(MONTH(AsphaltCurrentIndexMonth),\"/\",YEAR(AsphaltCurrentIndexMonth)), \"______\"), \"):\")","v":"CURRENT ASPHALT PRICE INDEX FOR (______):"},null,null,null,null,{"$f":"CurrentAsphaltPriceIndex","v":0}]
[null,"ASPHALT PRICE INDEX DIFFERENCE:",null,null,null,null,{"$f":"IF(G19,IF((G23*1.05)<G24,G24-(G23*1.05),IF((G23*0.95)>G24,G24-(G23*0.95),0.00000000001)),0)","v":0}]
[null,"MONTHLY DOLLAR AMOUNT:",null,null,null,null,{"$f":"ROUND(G22,0)*ROUND(G25,4)","v":0}]
[]
[null,"ASPHALT MIXES WITH MODIFIED BINDERS (PG 76 & HIGHER)"]
[null,"POLYMER TONNAGE PLACED",null,null,null,null,{"$f":"PolymerTonnagePlaced","v":0},null,null,null,{"$f":"IF(G29,\"TN\",\"\")","v":""}]
[null,"GALLONS OF POLYMER USED IN MIX *",null,null,null,null,{"$f":"ROUND(IF(G29=0,0,(G29*2.331*6.25)),0)","v":0},null,null,null,{"$f":"IF(G30,\"GA\",\"\")","v":""}]
[null,"TOTAL GALLONS",null,null,null,null,{"$f":"IF(G29=0,0,(G30))","v":0},null,null,null,{"$f":"IF(G31,\"GA\",\"\")","v":""}]
[null,{"$f":"CONCATENATE(\"BASE POLYMER PRICE INDEX FOR (\",IF(PolymerBaseIndexMonth<>\"\",CONCATENATE(MONTH(PolymerBaseIndexMonth),\"/\",YEAR(PolymerBaseIndexMonth)), \"______\"), \"):\")","v":"BASE POLYMER PRICE INDEX FOR (______):"},null,null,null,null,{"$f":"BasePolymerPriceIndex","v":0}]
[null,{"$f":"CONCATENATE(\"CURRENT POLYMER PRICE INDEX FOR (\",IF(PolymerCurrentIndexMonth<>\"\",CONCATENATE(MONTH(PolymerCurrentIndexMonth),\"/\",YEAR(PolymerCurrentIndexMonth)), \"______\"), \"):\")","v":"CURRENT POLYMER PRICE INDEX FOR (______):"},null,null,null,null,{"$f":"CurrentPolymerPriceIndex","v":0}]
[null,"POLYMER PRICE INDEX DIFFERENCE:",null,null,null,null,{"$f":"IF(G29,IF((G32*1.05)<G33,G33-(G32*1.05),IF((G32*0.95)>G33,G33-(G32*0.95),0.00000000001)),0)","v":0}]
[null,"MONTHLY DOLLAR AMOUNT:",null,null,null,null,{"$f":"ROUND(G31,0)*ROUND(G34,4)","v":0}]
[]
[null,"ASPHALT MATERIAL (ASPHALT TREATED PERMEABLE BASE)"]
[null,"ASPHALT TONNAGE PLACED",null,null,null,null,{"$f":"PermeableAsphaltTonnagePlaced","v":0},null,null,null,{"$f":"IF(G38,\"TN\",\"\")","v":""}]
[null,"GALLONS OF ASPHALT CEMENT USED IN MIX*",null,null,null,null,{"$f":"ROUND(IF(G38=0,0,(G38*2.331*3)),0)","v":0},null,null,null,{"$f":"IF(G39,\"GA\",\"\")","v":""}]
[null,{"$f":"CONCATENATE(\"BASE PRICE INDEX FOR (\",IF(permeablebaseindexmonth<>\"\",CONCATENATE(MONTH(permeablebaseindexmonth),\"/\",YEAR(permeablebaseindexmonth)), \"______\"), \"):\")","v":"BASE PRICE INDEX FOR (______):"},null,null,null,null,{"$f":"permeablebasepriceindex","v":0}]
[null,{"$f":"CONCATENATE(\"CURRENT ASPHALT PRICE INDEX FOR (\",IF(permeablecurrentindexmonth<>\"\",CONCATENATE(MONTH(permeablecurrentindexmonth),\"/\",YEAR(permeablecurrentindexmonth)), \"______\"), \"):\")","v":"CURRENT ASPHALT PRICE INDEX FOR (______):"},null,null,null,null,{"$f":"permeableasphaltpriceindex","v":0}]
[null,"ASPHALT PRICE INDEX DIFFERENCE:",null,null,null,null,{"$f":"IF(G38,IF((G40*1.05)<G41,G41-(G40*1.05),IF((G40*0.95)>G41,G41-(G40*0.95),0.00000000001)),0)","v":0}]
[null,"MONTHLY DOLLAR AMOUNT:",null,null,null,null,{"$f":"ROUND(G39,0)*ROUND(G42,4)","v":0}]
[]
[]
[]
[null,"I certify that, based on my personal knowledge and well-founded belief following my own reasonable investigation, the"]
[null,"tons and gallons (metric tons and liters) represented by this Certification are true and correct."]
[null,"* Calculations based on Specifications."]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Name of Company and email address"]

{"sheet":"Sheet1","index":3,"n_rows":1,"n_cols":2,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["2016-05-16","Change decimals for tonnage input on the Setup tab."]

{"sheet":"Template","index":4,"n_rows":55,"n_cols":11,"rows_kept":55,"cut":false,"hidden":true,"merged":[[32,6,32,9],[28,1,28,4],[30,6,30,9],[30,1,30,4],[36,1,36,4],[32,1,32,4],[46,1,46,4],[34,1,34,4],[48,1,48,4],[48,6,48,9],[40,1,40,4],[44,6,44,9],[38,1,38,2],[44,1,44,4],[3,2,3,8],[24,6,24,9],[26,6,26,9],[28,6,28,9],[10,3,10,9],[12,3,12,9],[14,3,14,9],[4,2,4,8],[7,2,7,5],[7,6,7,7],[10,1,10,2],[5,2,5,8],[24,1,24,4],[16,1,16,10],[22,1,22,4],[20,1,20,2],[54,1,54,10],[18,6,18,7],[18,8,18,9],[18,2,18,4],[42,1,42,4],[22,6,22,9],[50,1,50,4],[26,1,26,4],[52,1,52,4],[52,6,52,9],[34,6,34,9],[46,6,46,9],[40,6,40,9],[42,6,42,9],[36,6,36,9],[50,6,50,9]]}
[]
[]
[]
[null,null,"CONTRACTOR'S ESTIMATE WORKSHEET"]
[null,null,"BITUMINOUS AND POLYMER MATERIAL"]
[null,null,"(DESIGN BUILD AND LUMP SUM PROJECTS)"]
[]
[null,null,"WORKSHEET NO. ",null,null,null,{"$f":"CertificationNumber","v":0}]
[]
[]
[null,"FINANCIAL PROJECT ID.",null,{"$f":"FinancialIDNumber","v":0}]
[]
[null,"CONTRACTOR",null,{"$f":"ContractorName","v":0}]
[]
[null,"CONTRACT NO.",null,{"$f":"ContractNumber","v":0}]
[]
[null,"PERIOD REPRESENTED BY WORKSHEET:"]
[]
[null,"FROM (MO/DAY/YR)",{"$f":"DateFrom","v":"00:00:00"},null,null,null,"TO (MO/DAY/YR)",null,{"$f":"DateTo","v":"00:00:00"}]
[]
[null,"ASPHALT MATERIAL"]
[]
[null,"ASPHALT TONNAGE PLACED",null,null,null,null,{"$f":"AsphaltTonnagePlaced","v":0},null,null,null,{"$f":"IF(G23,\"TN\",\"\")","v":""}]
[]
[null,"GALLONS OF ASPHALT CEMENT USED IN MIX *",null,null,null,null,{"$f":"ROUND(IF(G23=0,0,(G23*2.331*6.25)),0)","v":0},null,null,null,{"$f":"IF(G25,\"GA\",\"\")","v":""}]
[]
[null,"ADDITIONAL GALLONS (ARMI)",null,null,null,null,{"$f":"AsphaltVolumeAdditional","v":0},null,null,null,{"$f":"IF(G27,\"GA\",\"\")","v":""}]
[]
[null,"TOTAL GALLONS",null,null,null,null,{"$f":"IF(G23=0,0,(G25+G27))","v":0},null,null,null,{"$f":"IF(G29,\"GA\",\"\")","v":""}]
[]
[null,{"$f":"CONCATENATE(\"BASE ASPHALT PRICE INDEX FOR (\",IF(AsphaltBaseIndexMonth<>\"\",CONCATENATE(MONTH(AsphaltBaseIndexMonth),\"/\",YEAR(AsphaltBaseIndexMonth)), \"______\"), \"):\")","v":"BASE ASPHALT PRICE INDEX FOR (______):"},null,null,null,null,{"$f":"BaseAsphaltPriceIndex","v":0}]
[]
[null,{"$f":"CONCATENATE(\"CURRENT ASPHALT PRICE INDEX FOR (\",IF(AsphaltCurrentIndexMonth<>\"\",CONCATENATE(MONTH(AsphaltCurrentIndexMonth),\"/\",YEAR(AsphaltCurrentIndexMonth)), \"______\"), \"):\")","v":"CURRENT ASPHALT PRICE INDEX FOR (______):"},null,null,null,null,{"$f":"CurrentAsphaltPriceIndex","v":0}]
[]
[null,"ASPHALT PRICE INDEX DIFFERENCE:",null,null,null,null,{"$f":"IF(G23,IF((G31*1.05)<G33,G33-(G31*1.05),IF((G31*0.95)>G33,G33-(G31*0.95),0.00000000001)),0)","v":0}]
[]
[null,"MONTHLY DOLLAR AMOUNT:",null,null,null,null,{"$f":"ROUND(G29,0)*ROUND(G35,4)","v":0}]
[]
[null,"POLYMER MATERIAL"]
[]
[null,"POLYMER TONNAGE PLACED",null,null,null,null,{"$f":"PolymerTonnagePlaced","v":0},null,null,null,{"$f":"IF(G41,\"TN\",\"\")","v":""}]
[]
[null,"GALLONS OF POLYMER USED IN MIX *",null,null,null,null,{"$f":"ROUND(IF(G41=0,0,(G41*2.331*6.25)),0)","v":0},null,null,null,{"$f":"IF(G43,\"GA\",\"\")","v":""}]
[]
[null,"TOTAL GALLONS",null,null,null,null,{"$f":"IF(G41=0,0,(G43))","v":0},null,null,null,{"$f":"IF(G45,\"GA\",\"\")","v":""}]
[]
[null,{"$f":"CONCATENATE(\"BASE POLYMER PRICE INDEX FOR (\",IF(PolymerBaseIndexMonth<>\"\",CONCATENATE(MONTH(PolymerBaseIndexMonth),\"/\",YEAR(PolymerBaseIndexMonth)), \"______\"), \"):\")","v":"BASE POLYMER PRICE INDEX FOR (______):"},null,null,null,null,{"$f":"BasePolymerPriceIndex","v":0}]
[]
[null,{"$f":"CONCATENATE(\"CURRENT POLYMER PRICE INDEX FOR (\",IF(PolymerCurrentIndexMonth<>\"\",CONCATENATE(MONTH(PolymerCurrentIndexMonth),\"/\",YEAR(PolymerCurrentIndexMonth)), \"______\"), \"):\")","v":"CURRENT POLYMER PRICE INDEX FOR (______):"},null,null,null,null,{"$f":"CurrentPolymerPriceIndex","v":0}]
[]
[null,"POLYMER PRICE INDEX DIFFERENCE:",null,null,null,null,{"$f":"IF(G41,IF((G47*1.05)<G49,G49-(G47*1.05),IF((G47*0.95)>G49,G49-(G47*0.95),0.00000000001)),0)","v":0}]
[]
[null,"MONTHLY DOLLAR AMOUNT:",null,null,null,null,{"$f":"ROUND(G45,0)*ROUND(G51,4)","v":0}]
[]
[null,"* Calculations based on Specifications."]

{"sheet":"Accuracy","index":5,"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"]