{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Agg. Tonnage","Agg. Location","Sheet3"],"not_rendered":{"charts":1,"images":1,"macros":0,"external_links":0,"defined_names":10,"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":"Agg. Tonnage","index":0,"n_rows":30,"n_cols":8,"rows_kept":30,"cut":false,"hidden":false,"merged":[[27,4,27,5],[26,4,26,5],[25,4,25,5],[12,4,12,5],[13,4,13,5],[17,4,17,5],[18,4,18,5],[19,4,19,5],[20,4,20,5],[21,4,21,5],[22,4,22,5],[23,4,23,5],[24,4,24,5],[16,4,16,5],[10,0,10,2],[13,1,13,3],[14,4,14,5],[15,4,15,5],[9,6,10,7],[9,0,9,4],[10,4,10,5],[1,5,1,7],[3,5,3,7],[5,5,5,7],[7,5,7,7],[1,0,1,4],[3,0,3,4],[5,0,5,4],[7,0,7,4],[0,1,0,3],[2,1,2,3],[4,1,4,3],[6,1,6,3],[8,1,8,3],[36,1,36,7],[29,1,29,7],[31,1,31,7],[33,1,33,7],[35,1,35,7],[30,1,30,7],[32,1,32,7],[34,1,34,7]]}
["ITEM DESC:",null,null,null,null,"PROJECT I.D."]
[]
["ITEM #:",null,null,null,null,"ROADWAY"]
[]
["SOURCE:",null,null,null,null,"DESCRIPTION"]
[]
["ENTERED:",null,null,null,null,"COUNTY"]
[]
["CHECKED:"]
[null,null,null,null,null,null,"(F9 to calculate)"]
["Placement Tonnage:",null,null,null,"Unit"]
[]
[null,null,null,null,"Random",null,"Tonnage for"]
["Sample No.","Tonnage Range",null,null,"Number",null,"Sampling","Comments"]
[1,0,"to",{"$f":"IF(D11<=30000, D11,IF(D11>30000, 30000, 0))","v":0},{"$f":"RAND()","v":0.41640900434218719},null,{"$f":"(D15-B15)*E15","v":0}]
[{"$f":"IF($D$11>30000,3,\"\")","v":""},{"$f":"IF($D$11<=30000,\"\",30000)","v":""},{"$f":"IF(A16=\"\",\"\",\"to\")","v":""},{"$f":"IF($D$11<=30000,\"\",IF($D$11<=60000,$D$11,60000))","v":""},{"$f":"IF($D$11>30000,RAND(),\"\")","v":""},null,{"$f":"IF(E16=\"\",\"\",((D16-B16)*E16)+B16)","v":""}]
[{"$f":"IF($D$11>60000,4,\"\")","v":""},{"$f":"IF($D$11<=60000,\"\",60000)","v":""},{"$f":"IF(A17=\"\",\"\",\"to\")","v":""},{"$f":"IF($D$11<=60000,\"\",IF($D$11<=90000,$D$11,90000))","v":""},{"$f":"IF($D$11>60000,RAND(),\"\")","v":""},null,""]
[{"$f":"IF($D$11>90000,5,\"\")","v":""},{"$f":"IF($D$11<=90000,\"\",90000)","v":""},"",{"$f":"IF($D$11<=90000,\"\",IF($D$11<=120000,$D$11,120000))","v":""},{"$f":"IF($D$11>90000,RAND(),\"\")","v":""},null,""]
[{"$f":"IF($D$11>120000,6,\"\")","v":""},{"$f":"IF($D$11<=120000,\"\",120000)","v":""},"",{"$f":"IF($D$11<=120000,\"\",IF($D$11<=150000,$D$11,150000))","v":""},{"$f":"IF($D$11>120000,RAND(),\"\")","v":""},null,""]
[{"$f":"IF($D$11>150000,7,\"\")","v":""},{"$f":"IF($D$11<=150000,\"\",150000)","v":""},"",{"$f":"IF($D$11<=150000,\"\",IF($D$11<=180000,$D$11,180000))","v":""},{"$f":"IF($D$11>150000,RAND(),\"\")","v":""},null,""]
[{"$f":"IF($D$11>180000,8,\"\")","v":""},{"$f":"IF($D$11<=180000,\"\",180000)","v":""},"",{"$f":"IF($D$11<=180000,\"\",IF($D$11<=210000,$D$11,210000))","v":""},{"$f":"IF($D$11>180000,RAND(),\"\")","v":""},null,""]
[{"$f":"IF($D$11>210000,9,\"\")","v":""},{"$f":"IF($D$11<=210000,\"\",210000)","v":""},"",{"$f":"IF($D$11<=210000,\"\",IF($D$11<=240000,$D$11,240000))","v":""},{"$f":"IF($D$11>210000,RAND(),\"\")","v":""},null,""]
[{"$f":"IF($D$11>240000,10,\"\")","v":""},{"$f":"IF($D$11<=240000,\"\",240000)","v":""},"",{"$f":"IF($D$11<=240000,\"\",IF($D$11<=270000,$D$11,270000))","v":""},{"$f":"IF($D$11>240000,RAND(),\"\")","v":""},null,""]
[{"$f":"IF($D$11>270000,11,\"\")","v":""},{"$f":"IF($D$11<=270000,\"\",270000)","v":""},"",{"$f":"IF($D$11<=270000,\"\",IF($D$11<=300000,$D$11,300000))","v":""},{"$f":"IF($D$11>270000,RAND(),\"\")","v":""},null,""]
[{"$f":"IF($D$11>300000,12,\"\")","v":""},{"$f":"IF($D$11<=300000,\"\",300000)","v":""},"",{"$f":"IF($D$11<=300000,\"\",IF($D$11<=330000,$D$11,330000))","v":""},{"$f":"IF($D$11>300000,RAND(),\"\")","v":""},null,""]
[{"$f":"IF($D$11>330000,13,\"\")","v":""},{"$f":"IF($D$11<=330000,\"\",330000)","v":""},"",{"$f":"IF($D$11<=330000,\"\",IF($D$11<=360000,$D$11,360000))","v":""},{"$f":"IF($D$11>330000,RAND(),\"\")","v":""},null,""]
[{"$f":"IF($D$11>360000,14,\"\")","v":""},{"$f":"IF($D$11<=360000,\"\",360000)","v":""},"",{"$f":"IF($D$11<=360000,\"\",IF($D$11<=390000,$D$11,390000))","v":""},{"$f":"IF($D$11>360000,RAND(),\"\")","v":""},null,""]
[{"$f":"IF($D$11>390000,15,\"\")","v":""},{"$f":"IF($D$11<=390000,\"\",390000)","v":""},"",{"$f":"IF($D$11<=390000,\"\",IF($D$11<=420000,$D$11,420000))","v":""},{"$f":"IF($D$11>390000,RAND(),\"\")","v":""},null,""]
[]
["REMARKS:"]

{"sheet":"Agg. Location","index":1,"n_rows":38,"n_cols":7,"rows_kept":38,"cut":false,"hidden":false,"merged":[[16,6,16,9],[6,1,6,3],[8,1,8,3],[5,5,5,9],[7,5,7,9],[15,3,15,4],[16,3,16,4],[11,5,11,7],[45,1,45,9],[1,0,1,3],[3,0,3,3],[0,1,0,3],[2,1,2,3],[1,5,1,9],[3,5,3,9],[9,0,9,3],[17,6,17,9],[5,0,5,3],[7,0,7,3],[4,1,4,3],[10,0,10,1],[11,0,11,1],[14,6,14,8],[15,6,15,9],[44,1,44,9],[17,3,17,4],[38,1,38,9],[40,1,40,9],[42,1,42,9],[37,1,37,9],[39,1,39,9],[41,1,41,9],[43,1,43,9]]}
["ITEM DESC:",{"$f":"Description","v":"Structure Backfill"},null,null,null,"PROJECT I.D."]
[null,null,null,null,null,{"$f":"ProjID","v":0}]
["ITEM #:",{"$f":"Item","v":209.21},null,null,null,"ROADWAY"]
[null,null,null,null,null,{"$f":"Roadway","v":0}]
["SOURCE:",{"$f":"Source","v":321},null,null,null,"DESCRIPTION"]
[null,null,null,null,null,{"$f":"Descrip","v":0}]
["ENTERED:",{"$f":"Entered","v":0},null,null,null,"COUNTY"]
[null,null,null,null,null,{"$f":"County","v":"Fond du Lac"}]
["CHECKED:",{"$f":"Checked","v":0}]
[]
["Begin Station:"]
["Placement Width:",null,null,null,null,"(F9 to calculate)"]
[]
[null,"Random",null,"Random"]
["Increments","Numbers","Station","Numbers",null,"Offset","Comments"]
[1,{"$f":"RAND()","v":0.81149062796790628},{"$f":"(100*B16)+$C$11","v":81.149062796790631},{"$f":"RAND()","v":0.16553757343072872},null,{"$f":"$C$12*D16","v":0}]
[2,{"$f":"RAND()","v":0.80923089882396304},{"$f":"(100*B17)+$C$11","v":80.923089882396297},0.60422577733588356,null,{"$f":"$C$12*D17","v":0}]
[3,0.4672436729734819,46.724367297348188,0.18573749437704878,null,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["REMARKS:"]

{"sheet":"Sheet3","index":2,"n_rows":31,"n_cols":1,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
["Granular Backfill"]
["Structure Backfill"]
[]
[]
[209.11]
[209.15]
[209.21]
[209.25]
[210.11]
[210.15]
[210.21]
[210.25]
[]
[]
["Unit"]
["TONS"]
["CY"]
[]
[]
[]
["Brown"]
["Calumet"]
["Door"]
["Fond du Lac"]
["Kewaunee"]
["Manitowoc"]
["Marinette"]
["Oconto"]
["Outagamie"]
["Sheboygan"]
["Winnebago"]