{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["ContractData","PayitemData","Template","Main","PivotData","PivotItem"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":1,"defined_names":38,"comments":0,"pivot_tables":1},"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":"ContractData","index":0,"n_rows":1,"n_cols":16,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["Contract","Ditrict","Contract Type","Contract Description","Primary FinProj","Federal Proj Id","County Id","County Description","Vendor Id","Vendor Name","Letting","Award","Executed","Award Amount","Awarded Days","Present Amount"]

{"sheet":"PayitemData","index":1,"n_rows":1,"n_cols":5,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["Fin Proj","Line Item","Payitem Code","Payitem Description","Unit"]

{"sheet":"Template","index":2,"n_rows":47,"n_cols":16,"rows_kept":47,"cut":false,"hidden":true,"merged":[[13,2,13,13],[8,13,10,16],[4,0,4,1],[4,10,4,11],[4,12,4,13],[6,0,6,1],[6,2,6,3],[6,4,6,5],[6,7,6,10],[6,11,6,12],[8,0,10,1],[8,2,10,7],[8,8,10,8],[8,9,10,10],[8,11,10,12],[0,2,0,13],[0,15,2,16],[1,2,1,13],[2,0,2,1],[2,2,2,5],[2,6,2,9],[14,2,14,13],[14,15,17,16],[15,0,15,1],[15,2,15,5],[15,6,15,9],[17,0,17,1],[17,6,17,9],[17,10,17,11],[17,12,17,13],[19,14,19,15],[19,0,19,1],[19,2,19,3],[19,4,19,5],[21,0,23,1],[21,2,23,7],[21,8,23,8],[21,9,23,10],[21,11,23,12],[21,13,23,16]]}
[null,null,"STATE OF FLORIDA, DEPARTMENT OF TRANSPORTATION",null,null,null,null,null,null,null,null,null,null,null,null,"FORM 700-050-67\nCONSTRUCTION\n1/18"]
[null,null,"DAILY WORKSHEET"]
["CONTRACTOR:",null,{"$f":"ContractData!$J$2","v":0},null,null,null,{"$f":"\"   Traffic Stripes and Markings\"","v":"   Traffic Stripes and Markings"}]
[]
["CERTIFICATION NO.:",null,null,null,null,null,null,null,null,null,"PROJECT DESCRIPTION:",null,{"$f":"ContractData!$D$2","v":0},null,"DATE:"]
[]
["FINANCIAL PROJECT ID:",null,20769915201,null,"CONTRACT NO.:",null,{"$f":"ContractData!$A$2","v":0},"PERIOD REPRESENTED BY CERTIFICATION",null,null,null,"PRINT NAME:"]
[]
["PAY ITEM NUMBER",null,"ITEM DESCRIPTION",null,null,null,null,null,"UNIT","QUANTITY",null,"LOCATION",null,"REMARKS"]
[]
[]
[]
[]
[null,null,"STATE OF FLORIDA, DEPARTMENT OF TRANSPORTATION",null,null,null,null,null,null,null,null,null,null,null,null,"Page No."]
[null,null,"CONTRACTORS MONTHLY CERTIFICATION OF QUANTITIES",null,null,null,null,null,null,null,null,null,null,null,null,"FORM 700-050-68\nCONSTRUCTION\n1/24"]
["CONTRACTOR:",null,{"$f":"ContractData!$J$2","v":0},null,null,null,"MAINTENANCE OF TRAFFIC SHEET"]
[]
["CERTIFICATION NO.:",null,null,null,null,null,{"$f":"\"   Traffic Stripes and Markings\"","v":"   Traffic Stripes and Markings"},null,null,null,"PROJECT DESCRIPTION:",null,{"$f":"ContractData!$D$2","v":0}]
[]
["FINANCIAL PROJECT ID:",null,20779015201,null,"CONTRACT NO.:",null,{"$f":"ContractData!$A$2","v":0},"PERIOD REPRESENTED BY CERTIFICATION",null,null,null,null,"FROM: (MO/DY/YR)",null,"TO: (MO/DY/YR)"]
[]
["PAY ITEM NUMBER",null,"DESCRIPTION",null,null,null,null,null,"UNIT","THIS ESTIMATE",null,"LOCATION",null,"REMARKS"]
[]
[]
["Blank Row - Do Not delete"]
[]
[]
[]
["I certify that, based on my personal knowledge and well-founded belief following my own reasonable investigation, the above counts, measurements, and quality of products are correct and accurate."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Note: Submit this certification to FDOT as an excel file after digital signatures are applied."]
[]
[]
[]
["I certify that, based on my personal knowledge and well-founded belief following my own reasonable investigation, the above counts, measurements, and quality of products are correct and accurate."]
[]
["Prime Contractor's Authorized Agent (Print Name & Co.):",null,null,null,null,null,null,null,null,"Contractor's Work Site Traffic Supervisor (Signature)"]
[]
["Prime Contractor's Authorized Agent (Signature):",null,null,null,null,null,null,"Date:",null,"Contractor's Work Site Traffic Supervisor (Print Name)"]

{"sheet":"Main","index":3,"n_rows":21,"n_cols":12,"rows_kept":21,"cut":false,"hidden":false,"merged":[[2,11,7,18],[20,1,23,8],[2,0,8,9],[0,0,0,9],[12,1,17,8],[10,1,10,8],[10,11,22,18]]}
["Main Menu"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Note: Check this box to use digital signatures only.\n\nDigital signatures are required for use on projects let July 2016 and after."]
[]
[]
[]
[]
[]
[]
[]
[null,"Message Center",null,null,null,null,null,null,null,null,null,"Prior to applying your digital signature in Excel, ensure Calculation Options are set to Manual, then click Calculate Now."]
[]
[null,"Checking Internet Connection"]
[]
[]
[]
[]
[]
[]
[]
[null,"Click Here for Form Instructions"]

{"sheet":"PivotData","index":4,"n_rows":2,"n_cols":4,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["PAY ITEM NUMBER","ITEM DESCRIPTION","UNIT","Sum of QUANTITY"]
["(blank)","(blank)","(blank)"]

{"sheet":"PivotItem","index":5,"n_rows":1,"n_cols":4,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["PAY ITEM NUMBER","ITEM DESCRIPTION","UNIT","QUANTITY"]