{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Qsc","Section"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"Qsc","index":0,"n_rows":2,"n_cols":9,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,{"$f":"SUM(I2:I45)","v":0}]
[null,null,{"$f":"I1","v":0},null,null,null,null,null,""]

{"sheet":"Section","index":1,"n_rows":77,"n_cols":36,"rows_kept":77,"cut":false,"hidden":false,"merged":[[56,1,56,4],[10,28,10,29],[11,28,11,29],[12,28,12,29],[13,28,13,30],[14,28,15,29],[14,30,15,30],[4,28,4,29],[4,31,4,32],[5,28,5,30],[5,31,5,32],[6,28,7,29],[6,30,7,30],[6,31,6,32],[1,28,1,29],[1,31,1,32],[2,28,2,29],[2,31,2,32],[3,28,3,29],[3,31,3,32],[5,3,5,4],[1,0,1,1],[1,2,1,5],[6,3,6,4],[7,3,7,4],[2,3,2,4],[3,3,3,4],[4,3,4,4],[2,0,2,1],[3,0,3,1],[4,0,4,1],[6,0,6,2],[7,0,8,1],[7,2,8,2],[5,0,5,1]]}
[]
["Section:",null,"Line or Route/Direction/Lane",null,null,null,null,"Qs:",{"$f":"IF(OR(C5=\"\",C6=\"\"),\"\",SUM(H11:H28)*((((C4-C3)*(AVERAGE(C5,C6))-((C8)*C5))/9*((F3/2000)*I3+(F4/2000)*I4+(F5/2000)*I5+(F6/2000)*I6+(F7/2000)*I7+(F8/2000)*I8))))","v":""},null,null,null,null,null,null,null,null,"Bridge Approach",null,null,null,null,null,null,null,null,null,null,"Start Station:",null,null,"Surface Lay Rate:",null,null,"lb/sys","Unit Price:"]
["Start Station:",null,null,"Surface Lay Rate:",null,null,"lb/sys","Unit Price:",null,null,null,null,null,null,null,null,null,"Railroad",null,null,null,null,null,null,null,null,null,null,"End Station:",null,null,"Intermediate Lay Rate:",null,null,"lb/sys","Unit Price:"]
["End Station:",null,null,"Intermediate Lay Rate:",null,null,"lb/sys","Unit Price:",null,null,null,null,null,null,null,null,null,"Casting",null,null,null,null,null,null,null,null,null,null,"Start Width:",null,null,"Base Lay Rate:",null,null,"lb/sys","Unit Price:"]
["Start Width:",null,null,"Base Lay Rate:",null,null,"lb/sys","Unit Price:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"End Width:",null,null,"Intermediate OG Lay Rate:",null,null,"lb/sys","Unit Price:"]
["End Width:",null,null,"Intermediate OG Lay Rate:",null,null,"lb/sys","Unit Price:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Omitted Areas for Exceptions and  Materials",null,null,"Base OG Lay Rate:",null,null,"lb/sys","Unit Price:"]
["Omitted Areas for Exceptions",null,null,"Base OG Lay Rate:",null,null,"lb/sys","Unit Price:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Enter total LFT of failed sublot within this section",null,null,"Additional Mix Lay Rate:",null,null,"lb/sys","Unit Price:"]
["Total LFT of Exceptions within this section",null,{"$f":"+E77","v":0},"Additional Mix Lay Rate:",null,null,"lb/sys","Unit Price:"]
[]
[null,null,"Max IRI","Min IRI","LW %","RW %","PF","J"]
[null,null,"∞",85,null,null,0.94,{"$f":"0.5*(G11-1)*0.01*(F11+E11)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Start Station:",null,null,null,null,null,null,"Unit Price:"]
[null,null,85,80,null,null,0.96,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"End Station:"]
[null,null,80,75,null,null,0.97,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Width:"]
[null,null,75,70,null,null,0.98,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Omitted Areas for Exceptions and Materials "]
[null,null,70,65,null,null,1,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Enter total LFT of failed sublot within this section"]
[null,null,65,60,null,null,1,0]
[null,null,60,55,null,null,1,0]
[null,null,55,50,null,null,1.02,0]
[null,null,50,45,null,null,1.03,0]
[null,null,45,40,null,null,1.04,0]
[null,null,40,35,null,null,1.06,0]
[null,null,35,30,null,null,1.06,0]
[null,null,30,25,null,null,1.06,0]
[null,null,25,20,null,null,1.06,0]
[null,null,20,15,null,null,1.06,0]
[null,null,15,10,null,null,1.06,0]
[null,null,10,5,null,null,1.06,0]
[null,null,5,0,null,null,1.06,0]
[]
[null,null,null,null,null,null,"Bonus/Penalty",{"$f":"SUM(H11:H28)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Omitted Areas for Exceptions"]
[null,"Type","Description (i.e. STR 3)","Length","Total"]
[null,null,null,null,{"$f":"IF(D59=\"\",\"\",D59+100)","v":""}]
[null,null,null,null,{"$f":"IF(D60=\"\",\"\",D60+100)","v":""}]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,{"$f":"SUM(E59:E76)","v":0}]