{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["HeadSign","LeftHeader","ItemsTemplate","RawItems","RawContractInfo","Projects","Menu"],"not_rendered":{"charts":0,"images":10,"macros":1,"external_links":0,"defined_names":36,"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":"HeadSign","index":0,"n_rows":23,"n_cols":25,"rows_kept":23,"cut":false,"hidden":true,"merged":[[26,1,26,5],[26,7,26,11],[26,12,26,13],[26,15,26,20],[26,21,26,24],[1,9,1,16],[22,1,22,24],[24,1,24,5],[24,8,24,14],[24,15,24,20],[24,21,24,24],[2,9,2,16],[7,7,7,9],[7,5,7,6],[7,13,7,17],[7,10,7,12],[3,4,3,8],[5,5,5,8],[5,17,5,19],[3,9,3,16],[7,22,7,23],[2,23,5,24],[7,18,7,19],[17,7,17,11],[15,8,15,14],[15,15,15,20],[17,15,17,20],[17,12,17,13],[17,21,17,24],[15,21,15,24],[13,1,13,24],[5,20,5,21],[7,20,7,21],[3,1,3,3],[7,1,7,4],[5,1,5,4]]}
[]
[null,null,null,null,null,null,null,null,null,"STATE OF FLORIDA, DEPARTMENT OF TRANSPORTATION",null,null,null,null,null,null,null,null,null,null,null,null,null,"Page No.","Page  2 of  2"]
[null,null,null,null,null,null,null,null,null,"CONTRACTORS CERTIFICATION OF QUANTITIES",null,null,null,null,null,null,null,null,null,null,null,null,null,"FORM 700-050-62A\nCONSTRUCTION\n6/20"]
[null,"CONTRACTOR:",null,null,"RANGER CONSTRUCTION INDUSTRIES, INC.",null,null,null,null,"MAINTENANCE OF TRAFFIC SHEET"]
[]
[null,"CERTIFICATION NO.:",null,null,null," ",null,null,null,null,null,null,null,null,null,null,null,"STATE ROAD NO.:"]
[]
[null,"FINANCIAL ID NUMBER:",null,null,null,43232615201,null,"CONTRACT NO.:",null,null,"E4R80",null,null,"PERIOD REPRESENTED BY CERTIFICATION",null,null,null,null,"FROM: (MO/DY/YR)",null,null,null,"TO: (MO/DY/YR)"]
[]
[]
[]
[]
[]
[null,"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."]
[]
[null,"Prime Contractor's Authorized Agent (Print Name & Co.):",null,null,null,null,null,null,null,null,null,null,null,null,null," Contractor's Work Site Traffic Supervisor (Signature)"]
[]
[null,"Prime Contractor's Authorized Agent (Signature):",null,null,null,null,null,null,null,null,null,null,"Date:",null,null,"Contractor's Work Site Traffic Supervisor (Print Name)"]
[]
[]
[]
[]
[null,"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."]

{"sheet":"LeftHeader","index":1,"n_rows":6,"n_cols":4,"rows_kept":6,"cut":false,"hidden":true,"merged":[[24,1,24,3],[26,1,26,3],[25,1,25,3],[18,1,18,3],[20,1,20,3],[21,1,21,3],[22,1,22,3],[23,1,23,3],[14,1,14,3],[37,1,37,3],[27,1,27,3],[28,1,28,3],[29,1,29,3],[30,1,30,3],[31,1,31,3],[32,1,32,3],[33,1,33,3],[34,1,34,3],[35,1,35,3],[36,1,36,3],[15,1,15,3],[16,1,16,3],[19,1,19,3],[17,1,17,3],[2,1,2,2],[3,1,3,2],[4,1,4,3],[5,1,5,3],[6,1,6,3],[12,1,12,3],[13,1,13,3],[11,1,11,3],[7,1,7,3],[8,1,8,3],[10,1,10,3],[9,1,9,3]]}
[]
[]
[null,"PAY ITEM N).",null,">"]
[null,"DESCRIPTION",null,">"]
[]
[null,"MONTH/DAY"]

{"sheet":"ItemsTemplate","index":2,"n_rows":49,"n_cols":23,"rows_kept":49,"cut":false,"hidden":true,"merged":[[48,20,48,22],[26,20,26,22],[27,20,27,22],[28,20,28,22],[29,20,29,22],[30,20,30,22],[43,20,43,22],[44,20,44,22],[45,20,45,22],[46,20,46,22],[47,20,47,22],[0,17,0,18],[0,20,0,22],[1,17,1,19],[2,17,2,19],[3,17,3,19],[9,17,9,19],[6,20,6,22],[7,20,7,22],[1,20,1,21],[2,20,2,21],[3,20,3,22],[4,20,4,22],[5,20,5,22],[5,17,5,19],[6,17,6,19],[7,17,7,19],[4,17,4,19],[9,20,9,22],[8,20,8,22],[8,17,8,19],[8,1,8,2],[9,1,9,2],[23,20,23,22],[25,20,25,22],[27,1,27,2],[15,17,15,19],[16,17,16,19],[17,17,17,19],[21,1,21,2],[20,1,20,2],[20,20,20,22],[21,20,21,22],[24,20,24,22],[12,1,12,2],[13,1,13,2],[14,1,14,2],[15,1,15,2],[16,1,16,2],[18,1,18,2],[10,1,10,2],[11,1,11,2],[19,1,19,2],[17,1,17,2],[14,20,14,22],[22,20,22,22],[13,20,13,22],[10,17,10,19],[11,17,11,19],[12,17,12,19],[13,17,13,19],[14,17,14,19],[44,17,44,19],[45,17,45,19],[28,17,28,19],[29,17,29,19],[30,17,30,19],[43,17,43,19],[11,20,11,22],[12,20,12,22],[10,20,10,22],[15,20,15,22],[18,20,18,22],[16,20,16,22],[17,20,17,22],[19,20,19,22],[18,17,18,19],[36,17,36,19],[36,20,36,22],[48,1,48,2],[19,17,19,19],[20,17,20,19],[21,17,21,19],[22,17,22,19],[23,17,23,19],[24,17,24,19],[25,17,25,19],[26,17,26,19],[27,17,27,19],[46,17,46,19],[47,17,47,19],[48,17,48,19],[22,1,22,2],[47,1,47,2],[46,1,46,2],[30,1,30,2],[23,1,23,2],[24,1,24,2],[31,1,31,2],[29,1,29,2],[25,1,25,2],[28,1,28,2],[26,1,26,2],[1,13,1,15],[2,13,2,15],[7,1,7,2],[0,13,0,15],[0,1,0,3],[0,5,0,7],[0,9,0,11],[1,9,1,11],[2,9,2,11],[1,1,1,3],[2,1,2,3],[2,5,2,7],[1,5,1,7],[3,1,3,2],[4,1,4,2],[5,1,5,2],[6,1,6,2],[41,1,41,2],[42,1,42,2],[43,1,43,2],[44,1,44,2],[45,1,45,2],[31,17,31,19],[31,20,31,22],[32,17,32,19],[32,20,32,22],[33,17,33,19],[33,20,33,22],[41,17,41,19],[41,20,41,22],[42,17,42,19],[42,20,42,22],[33,1,33,2],[32,1,32,2],[34,1,34,2],[34,17,34,19],[34,20,34,22],[35,1,35,2],[35,17,35,19],[35,20,35,22],[36,1,36,2],[40,1,40,2],[40,17,40,19],[40,20,40,22],[37,1,37,2],[37,17,37,19],[37,20,37,22],[38,1,38,2],[38,17,38,19],[38,20,38,22],[39,1,39,2],[39,17,39,19],[39,20,39,22]]}
[null,"Regular Items",null,null,null,"Cop Items",null,null,null,"Message Board Items",null,null,null,"Linar Foot Items",null,null,null,"Remarks",null,null,"Item Label"]
[null,"0102107  1",null,null,null,"0102 14",null,null,null,"0102 99",null,null,null,"0102 71 21",null,null,null,null,null,null,"PAY ITEM N0.",null,">"]
[null,"TEMP TRAFFIC DETECTION ..",null,null,null,"TRAFFIC CONTROL OFFICER",null,null,null,"PORTABLE CHANGEABLE MES..",null,null,null,"BARRIER WALL,TEMP,REL,C..",null,null,null,null,null,null,"DESCRIPTION",null,">"]
[null,"TOTAL",null,"ACCRUED",null,"TOTAL","MIN.","ACCRUED",null,"TOTAL","ACCRUED"," APL",null,"TOTAL"," APL","ACCRUED",null,"REMARKS",null,null,"DAY"]
[null,"TODAY",null,"TOTAL",null,"TODAY",null,"TOTAL",null,"TODAY","TOTAL","NUMBER(S)",null,"TODAY","NUMBER(S)","TOTAL",null,null,null,null,"OF THE"]
[null,"(ED)",null,"(ED)",null,"(MH)","(MH)","(MH)",null,"(ED)","(ED)",null,null,"(LF)",null,"(LF)",null,null,null,null,"MONTH"]
[null,null,null,{"$f":"IF(B7=\"\",\"\",B7)","v":""},null,null,{"$f":"IF(F7=0,0,IF(AND(F7>0,F7<4),4-F7,0))","v":0},{"$f":"IF(F7=\"\",\"\",(F7+G7))","v":""},null,null,{"$f":"IF(J7=\"\",\"\",J7)","v":""},null,null,null,null,{"$f":"IF(N7=\"\",\"\",N7)","v":""}]
[null,null,null,{"$f":"IF(D7=\"\",\"\",IF(B8=\"\",\"\",(B8+D7)))","v":""},null,null,{"$f":"IF(F8=0,0,IF(AND(F8>0,F8<4),4-F8,0))","v":0},{"$f":"IF(H7=\"\",\"\",IF(F8=\"\",\"\",(F8+G8+H7)))","v":""},null,null,{"$f":"IF(K7=\"\",\"\",IF(J8=\"\",\"\",(J8+K7)))","v":""},null,null,null,null,{"$f":"IF(P7=\"\",\"\",IF(N8=\"\",\"\",(N8+P7)))","v":""}]
[null,null,null,{"$f":"IF(D8=\"\",\"\",IF(B9=\"\",\"\",(B9+D8)))","v":""},null,null,0,{"$f":"IF(H8=\"\",\"\",IF(F9=\"\",\"\",(F9+G9+H8)))","v":""},null,null,{"$f":"IF(K8=\"\",\"\",IF(J9=\"\",\"\",(J9+K8)))","v":""},null,null,null,null,{"$f":"IF(P8=\"\",\"\",IF(N9=\"\",\"\",(N9+P8)))","v":""}]
[null,null,null,"",null,null,0,"",null,null,"",null,null,null,null,""]
[null,null,null,"",null,null,0,"",null,null,"",null,null,null,null,""]
[null,null,null,"",null,null,0,"",null,null,"",null,null,null,null,""]
[null,null,null,"",null,null,0,"",null,null,"",null,null,null,null,""]
[null,null,null,"",null,null,0,"",null,null,"",null,null,null,null,""]
[null,null,null,"",null,null,0,"",null,null,"",null,null,null,null,""]
[null,null,null,"",null,null,0,"",null,null,"",null,null,null,null,""]
[null,null,null,"",null,null,0,"",null,null,"",null,null,null,null,""]
[null,null,null,"",null,null,0,"",null,null,"",null,null,null,null,""]
[null,null,null,"",null,null,0,"",null,null,"",null,null,null,null,""]
[null,null,null,"",null,null,0,"",null,null,"",null,null,null,null,""]
[null,null,null,"",null,null,0,"",null,null,"",null,null,null,null,""]
[null,null,null,"",null,null,0,"",null,null,"",null,null,null,null,""]
[null,null,null,"",null,null,0,"",null,null,"",null,null,null,null,""]
[null,null,null,"",null,null,0,"",null,null,"",null,null,null,null,""]
[null,null,null,"",null,null,0,"",null,null,"",null,null,null,null,""]
[null,null,null,"",null,null,0,"",null,null,"",null,null,null,null,""]
[null,null,null,"",null,null,0,"",null,null,"",null,null,null,null,""]
[null,null,null,"",null,null,0,"",null,null,"",null,null,null,null,""]
[null,null,null,"",null,null,0,"",null,null,"",null,null,null,null,""]
[null,null,null,"",null,null,0,"",null,null,"",null,null,null,null,""]
[null,null,null,"",null,null,0,"",null,null,"",null,null,null,null,{"$f":"IF(P30=\"\",\"\",IF(N31=\"\",\"\",(N31+P30)))","v":""}]
[null,null,null,"",null,null,0,"",null,null,"",null,null,null,null,""]
[null,null,null,"",null,null,0,"",null,null,"",null,null,null,null,""]
[null,null,null,"",null,null,0,"",null,null,{"$f":"IF(K33=\"\",\"\",IF(J34=\"\",\"\",(J34+K33)))","v":""},null,null,null,null,""]
[null,null,null,{"$f":"IF(D34=\"\",\"\",IF(B35=\"\",\"\",(B35+D34)))","v":""},null,null,{"$f":"IF(F35=0,0,IF(AND(F35>0,F35<4),4-F35,0))","v":0},{"$f":"IF(H34=\"\",\"\",IF(F35=\"\",\"\",(F35+G35+H34)))","v":""},null,null,{"$f":"IF(K34=\"\",\"\",IF(J35=\"\",\"\",(J35+K34)))","v":""},null,null,null,null,{"$f":"IF(P34=\"\",\"\",IF(N35=\"\",\"\",(N35+P34)))","v":""}]
[null,null,null,"",null,null,0,"",null,null,"",null,null,null,null,""]
[null,null,null,"",null,null,0,"",null,null,"",null,null,null,null,""]
[null,null,null,"",null,null,0,"",null,null,"",null,null,null,null,""]
[null,null,null,"",null,null,0,"",null,null,"",null,null,null,null,""]
[null,null,null,"",null,null,0,"",null,null,"",null,null,null,null,""]
[null,null,null,"",null,null,0,"",null,null,"",null,null,null,null,""]
[null,null,null,"",null,null,0,"",null,null,"",null,null,null,null,""]
[null,null,null,"",null,null,0,"",null,null,"",null,null,null,null,""]
[null,null,null,"",null,null,0,"",null,null,"",null,null,null,null,""]
[null,null,null,"",null,null,0,"",null,null,"",null,null,null,null,""]
[null,null,null,"",null,null,0,"",null,null,"",null,null,null,null,""]
[null,null,null,"",null,null,0,"",null,null,"",null,null,null,null,""]
[null,null,null,"",null,null,0,"",null,null,"",null,null,null,null,""]
[null,null,null,"",null,null,0,"",null,null,"",null,null,null,null,""]

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

{"sheet":"RawContractInfo","index":4,"n_rows":2,"n_cols":17,"rows_kept":2,"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"]
[null,4,"Const Contract","SR-615/NORTH 25TH STREET",43232615201,"N/A",94,"ST LUCIE","F592098662","RANGER CONSTRUCTION INDUSTRIES, INC.",20161202,20161227,20170112,2142842.36,190,2142842.36,269094.65000000002]

{"sheet":"Projects","index":5,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
[43232615201]

{"sheet":"Menu","index":6,"n_rows":17,"n_cols":10,"rows_kept":17,"cut":false,"hidden":false,"merged":[[5,7,5,8],[14,1,14,8],[16,1,21,8],[0,0,0,9],[2,9,7,16],[9,9,21,16]]}
["Main Menu"]
[]
[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,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,"Message Center"]
[]
[null,"Ready."]