{"text_format":"1","workbook":"xlsx","n_sheets":19,"sheets":["sht mgr","EDA","GT","GY","MN","MD","TYP LEGEND","GG001","GG002","Pavement","Plan","Traffic Control","Earthwork","end area","XS (1)","XS","0811 Bridge","2062 Bridge","HW RT"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":5,"defined_names":138,"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":"sht mgr","index":0,"n_rows":63,"n_cols":30,"rows_kept":63,"cut":false,"hidden":false,"merged":[]}
["File Name","Model Name","Title Property","Comments Property","PID","Sheet Title","Sub-Title","Sub-Title 2","Sheet Number","Sheet Total","Subset Number","Subset Total","Designer","Checker","Reviewer","Review Date","SFN1","SFN2","Scale2","Scale3","Scale4","CRS","DesignAgencyCellName","XBaseLength","YBaseLength","AgencyBoxBaseLowerXDist","AgencyBoxBaseLowerYDist","AgencyBoxBaseWidth","AgencyBoxBaseHeight","PlacedAgencyCells"]
["01 Active Projects\\District 06\\Morrow\\96213\\400-Engineering\\Roadway\\Sheets\\96213_GT001.dgn","96213_GT001","Roadway Title Sheet",null,"96213","PID #96213 MRW-314-(8.11) (20.62)","---NA---","---NA---","P.1",{"$f":"$I$55","v":"P.54"},"---NA---","---NA---","AMH","---NA---","KLM","2023-09-12","---NA---","---NA---","---NA---","---NA---","---NA---","MRW-314-(8.11) (20.62)","ODOT_ZEPHYR","34","22","32","2.5","1.5","2","Placed Agency Cells: ODOT_ZEPHYR"]
["01 Active Projects\\District 06\\Morrow\\96213\\400-Engineering\\Roadway\\Sheets\\96213_GY001.dgn","96213_GY001","Roadway Typical Sections Sheet",null,"96213","TYPICAL SECTIONS","---NA---","---NA---","P.2","P.54","---NA---","---NA---","AMH","---NA---","LW","2023-08-23","---NA---","---NA---","---NA---","---NA---","---NA---","MRW-314-(8.11) (20.62)","ODOT_ZEPHYR","34","22","32","2.5","1.5","2","Placed Agency Cells: ODOT_ZEPHYR"]
["01 Active Projects\\District 06\\Morrow\\96213\\400-Engineering\\Roadway\\Sheets\\96213_GN001.dgn","96213_GN001","Roadway General Notes Sheet",null,"96213","GENERAL NOTES","---NA---","---NA---","P.3","P.54","---NA---","---NA---","AMH","---NA---","KLM","2023-09-12","---NA---","---NA---","---NA---","---NA---","---NA---","MRW-314-(8.11) (20.62)","ODOT_ZEPHYR","34","22","32","2.5","1.5","2","Placed Agency Cells: ODOT_ZEPHYR"]
["01 Active Projects\\District 06\\Morrow\\96213\\400-Engineering\\MOT\\Sheets\\96213_MN001.dgn","96213_MN001","MOT Notes Sheet",null,"96213","MAINTENANCE OF TRAFFIC NOTES","---NA---","---NA---","P.4","P.54","---NA---","---NA---","AMH","---NA---","VP","2023-09-14","---NA---","---NA---","---NA---","---NA---","---NA---","MRW-314-(8.11) (20.62)","ODOT_ZEPHYR","34","22","32","2.5","1.5","2","Placed Agency Cells: ODOT_ZEPHYR"]
["01 Active Projects\\District 06\\Morrow\\96213\\400-Engineering\\MOT\\Sheets\\96213_MN001.dgn","96213_MN002","MOT Notes Sheet",null,"96213","MAINTENANCE OF TRAFFIC NOTES","---NA---","---NA---","P.5","P.54","---NA---","---NA---","AMH","---NA---","VP","2023-09-14","---NA---","---NA---","---NA---","---NA---","---NA---","MRW-314-(8.11) (20.62)","ODOT_ZEPHYR","34","22","32","2.5","1.5","2","Placed Agency Cells: ODOT_ZEPHYR"]
["01 Active Projects\\District 06\\Morrow\\96213\\400-Engineering\\MOT\\Sheets\\96213_MN001.dgn","96213_MN003","MOT Notes Sheet",null,"96213","MAINTENANCE OF TRAFFIC NOTES","---NA---","---NA---","P.6","P.54","---NA---","---NA---","AMH","---NA---","VP","2023-09-14","---NA---","---NA---","---NA---","---NA---","---NA---","MRW-314-(8.11) (20.62)","ODOT_ZEPHYR","34","22","32","2.5","1.5","2","Placed Agency Cells: ODOT_ZEPHYR"]
["01 Active Projects\\District 06\\Morrow\\96213\\400-Engineering\\MOT\\Sheets\\96213_MD001.dgn","96213_MD001","MOT Detour Plan Sheet",null,"96213","MAINTENANCE OF TRAFFIC PLAN","DETOUR SIGNAGE ","---NA---","P.7","P.54","---NA---","---NA---","AMH","---NA---","VP","2023-09-14","---NA---","---NA---","---NA---","---NA---","---NA---","MRW-314-(8.11) (20.62)","ODOT_ZEPHYR","34","22","32","2.5","1.5","2","Placed Agency Cells: ODOT_ZEPHYR"]
["01 Active Projects\\District 06\\Morrow\\96213\\400-Engineering\\MOT\\Sheets\\96213_MD001.dgn","96213_MD002","MOT Detour Plan Sheet",null,"96213","MAINTENANCE OF TRAFFIC PLAN","DETOUR - LOCATION 1","---NA---","P.8","P.54","---NA---","---NA---","AMH","---NA---","VP","2023-09-14","---NA---","---NA---","1250","2500",5000,"MRW-314-(8.11) (20.62)","ODOT_ZEPHYR","34","22","32","2.5","1.5","2","Placed Agency Cells: ODOT_ZEPHYR"]
["01 Active Projects\\District 06\\Morrow\\96213\\400-Engineering\\MOT\\Sheets\\96213_MD001.dgn","96213_MD003","MOT Detour Plan Sheet",null,"96213","MAINTENANCE OF TRAFFIC PLAN","DETOUR PLAN - LOCATION 2","---NA---","P.9","P.54","---NA---","---NA---","AMH","---NA---","VP","2023-09-14","---NA---","---NA---","1250","2500",5000,"MRW-314-(8.11) (20.62)","ODOT_ZEPHYR","34","22","32","2.5","1.5","2","Placed Agency Cells: ODOT_ZEPHYR"]
["01 Active Projects\\District 06\\Morrow\\96213\\400-Engineering\\Roadway\\Sheets\\96213_GG001.dgn","96213_GG001","Roadway General Summary Sheet",null,"96213","GENERAL SUMMARY","---NA---","---NA---","P.10","P.54","---NA---","---NA---","AMH","---NA---","DKR","2023-08-02","---NA---","---NA---","---NA---","---NA---","---NA---","MRW-314-(8.11) (20.62)","ODOT_ZEPHYR","34","22","32","2.5","1.5","2","Placed Agency Cells: ODOT_ZEPHYR"]
["01 Active Projects\\District 06\\Morrow\\96213\\400-Engineering\\Roadway\\Sheets\\96213_GG001.dgn","96213_GG002","Roadway General Summary Sheet",null,"96213","GENERAL SUMMARY","---NA---","---NA---","P.11","P.54","---NA---","---NA---","AMH","---NA---","DKR","2023-08-02","---NA---","---NA---","---NA---","---NA---","---NA---","MRW-314-(8.11) (20.62)","ODOT_ZEPHYR","34","22","32","2.5","1.5","2","Placed Agency Cells: ODOT_ZEPHYR"]
["01 Active Projects\\District 06\\Morrow\\96213\\400-Engineering\\Roadway\\Sheets\\96213_GS001.dgn","96213_GS001","Roadway Sub-Summary Sheet",null,"96213","PAVEMENT CALCULATIONS","---NA---","---NA---","P.12","P.54","---NA---","---NA---","AMH","---NA---","DKR","2023-08-02","---NA---","---NA---","---NA---","---NA---","---NA---","MRW-314-(8.11) (20.62)","ODOT_ZEPHYR","34","22","32","2.5","1.5","2","Placed Agency Cells: ODOT_ZEPHYR"]
["01 Active Projects\\District 06\\Morrow\\96213\\400-Engineering\\Roadway\\Sheets\\96213_GS001.dgn","96213_GS002","Roadway Sub-Summary Sheet",null,"96213","PLAN SUBSUMMARY","---NA---","---NA---","P.13","P.54","---NA---","---NA---","AMH","---NA---","DKR","2023-08-02","---NA---","---NA---","---NA---","---NA---","---NA---","MRW-314-(8.11) (20.62)","ODOT_ZEPHYR","34","22","32","2.5","1.5","2","Placed Agency Cells: ODOT_ZEPHYR"]
["01 Active Projects\\District 06\\Morrow\\96213\\400-Engineering\\Roadway\\Sheets\\96213_GS001.dgn","96213_GS003","Roadway Sub-Summary Sheet",null,"96213","EARTHWORK SUBSUMMARY","---NA---","---NA---","P.14","P.54","---NA---","---NA---","AMH","---NA---","DKR","2023-08-02","---NA---","---NA---","---NA---","---NA---","---NA---","MRW-314-(8.11) (20.62)","ODOT_ZEPHYR","34","22","32","2.5","1.5","2","Placed Agency Cells: ODOT_ZEPHYR"]
["01 Active Projects\\District 06\\Morrow\\96213\\400-Engineering\\Roadway\\Sheets\\96213_GP100.dgn","CLX_SR314 - Plan 2 [Sheet]","Roadway Plan and Profile or Plan Sheet","Location 1","96213","PLAN AND PROFILE - LOCATION 1","STA. 4+00.00 TO STA. 4+67.44","---NA---","P.15","P.54","---NA---","---NA---","JPH","---NA---","KLM","2023-09-12","---NA---","---NA---","10","20","40","MRW-314-(8.11) (20.62)","ODOT_ZEPHYR","34","22","32","2.5","1.5","2","Placed Agency Cells: ODOT_ZEPHYR"]
["01 Active Projects\\District 06\\Morrow\\96213\\400-Engineering\\Roadway\\Sheets\\96213_GP002.dgn","96213_GP002","Roadway Plan and Profile or Plan Sheet",null,"96213","PLAN AND PROFILE - LOCATION 2","STA. 10+00.00 TO 14+50.00","---NA---","P.16","P.54","---NA---","---NA---","AMH","---NA---","KLM","2023-09-12","---NA---","---NA---","10","20","40","MRW-314-(8.11) (20.62)","ODOT_ZEPHYR","---NA---","---NA---","---NA---","---NA---","---NA---","---NA---","Placed Agency Cells: ODOT_ZEPHYR"]
["01 Active Projects\\District 06\\Morrow\\96213\\400-Engineering\\Roadway\\Sheets\\96213_XS100.dgn","CLX_SR315 - 1+00.00 [Sheet]","Roadway Cross Sections Sheet",null,"96213","CROSS SECTIONS - LOCATION 1","STA. 1+00.00 TO STA. 1+50.00","---NA---","P.17","P.54","---NA---","---NA---","JPH","---NA---","KLM","2023-09-12","---NA---","---NA---","---NA---","---NA---","---NA---","MRW-314-(8.11) (20.62)","ODOT_ZEPHYR","34","22","32","2.5","1.5","2","Placed Agency Cells: ODOT_ZEPHYR"]
["01 Active Projects\\District 06\\Morrow\\96213\\400-Engineering\\Roadway\\Sheets\\96213_XS100.dgn","CLX_SR315 - 1+75.00 [Sheet]","Roadway Cross Sections Sheet",null,"96213","CROSS SECTIONS - LOCATION 1","STA. 1+75.00 TO STA. 2+00.00","---NA---","P.18","P.54","---NA---","---NA---","JPH","---NA---","KLM","2023-09-12","---NA---","---NA---","---NA---","---NA---","---NA---","MRW-314-(8.11) (20.62)","ODOT_ZEPHYR","34","22","32","2.5","1.5","2","Placed Agency Cells: ODOT_ZEPHYR"]
["01 Active Projects\\District 06\\Morrow\\96213\\400-Engineering\\Roadway\\Sheets\\96213_XS100.dgn","CLX_SR315 - 2+25.00 [Sheet]","Roadway Cross Sections Sheet",null,"96213","CROSS SECTIONS - LOCATION 1","STA. 2+25.00 TO STA. 2+50.00","---NA---","P.19","P.54","---NA---","---NA---","JPH","---NA---","KLM","2023-09-12","---NA---","---NA---","---NA---","---NA---","---NA---","MRW-314-(8.11) (20.62)","ODOT_ZEPHYR","34","22","32","2.5","1.5","2","Placed Agency Cells: ODOT_ZEPHYR"]
["01 Active Projects\\District 06\\Morrow\\96213\\400-Engineering\\Roadway\\Sheets\\96213_XS100.dgn","CLX_SR315 - 2+75.00 [Sheet]","Roadway Cross Sections Sheet",null,"96213","CROSS SECTIONS - LOCATION 1","STA. 2+75.00 TO STA. 3+00.00","---NA---","P.20","P.54","---NA---","---NA---","JPH","---NA---","KLM","2023-09-12","---NA---","---NA---","---NA---","---NA---","---NA---","MRW-314-(8.11) (20.62)","ODOT_ZEPHYR","34","22","32","2.5","1.5","2","Placed Agency Cells: ODOT_ZEPHYR"]
["01 Active Projects\\District 06\\Morrow\\96213\\400-Engineering\\Roadway\\Sheets\\96213_XS100.dgn","CLX_SR315 - 3+25.00 [Sheet]","Roadway Cross Sections Sheet",null,"96213","CROSS SECTIONS - LOCATION 1","STA. 3+25.00 TO STA. 3+50.00","---NA---","P.21","P.54","---NA---","---NA---","JPH","---NA---","KLM","2023-09-12","---NA---","---NA---","---NA---","---NA---","---NA---","MRW-314-(8.11) (20.62)","ODOT_ZEPHYR","34","22","32","2.5","1.5","2","Placed Agency Cells: ODOT_ZEPHYR"]
["01 Active Projects\\District 06\\Morrow\\96213\\400-Engineering\\Roadway\\Sheets\\96213_XS100.dgn","CLX_SR315 - 3+75.00 [Sheet]","Roadway Cross Sections Sheet",null,"96213","CROSS SECTIONS - LOCATION 1","STA. 3+75.00 TO STA. 4+25.00","---NA---","P.22","P.54","---NA---","---NA---","JPH","---NA---","KLM","2023-09-12","---NA---","---NA---","---NA---","---NA---","---NA---","MRW-314-(8.11) (20.62)","ODOT_ZEPHYR","34","22","32","2.5","1.5","2","Placed Agency Cells: ODOT_ZEPHYR"]
["01 Active Projects\\District 06\\Morrow\\96213\\400-Engineering\\Roadway\\Sheets\\96213_XS100.dgn","CLX_SR315 - 4+50.00 [Sheet]","Roadway Cross Sections Sheet",null,"96213","CROSS SECTIONS - LOCATION 1","STA. 4+50.00 TO STA. 4+67.44","---NA---","P.23","P.54","---NA---","---NA---","JPH","---NA---","KLM","2023-09-12","---NA---","---NA---","---NA---","---NA---","---NA---","MRW-314-(8.11) (20.62)","ODOT_ZEPHYR","34","22","32","2.5","1.5","2","Placed Agency Cells: ODOT_ZEPHYR"]
["01 Active Projects\\District 06\\Morrow\\96213\\400-Engineering\\Roadway\\Sheets\\96213_XS002.dgn","96213_XS201","Roadway Cross Sections Sheet","Cross Sections for Bridge MRW-314-2062","96213","CROSS SECTIONS - LOCATION 2","STA. 10+50.00 TO STA. 11+00.00","---NA---","P.24","P.54","---NA---","---NA---","AMH","---NA---","KLM","2023-09-12","---NA---","---NA---","---NA---","---NA---","---NA---","MRW-314-(8.11) (20.62)","ODOT_ZEPHYR","34","22","32","2.5","1.5","2","Placed Agency Cells: ODOT_ZEPHYR"]
["01 Active Projects\\District 06\\Morrow\\96213\\400-Engineering\\Roadway\\Sheets\\96213_XS002.dgn","96213_XS202","Roadway Cross Sections Sheet","Cross Sections for Bridge MRW-314-2062","96213","CROSS SECTIONS - LOCATION 2","STA. 11+25.00 TO STA. 11+75.00","---NA---","P.25","P.54","---NA---","---NA---","AMH","---NA---","KLM","2023-09-12","---NA---","---NA---","---NA---","---NA---","---NA---","MRW-314-(8.11) (20.62)","ODOT_ZEPHYR","34","22","32","2.5","1.5","2","Placed Agency Cells: ODOT_ZEPHYR"]
["01 Active Projects\\District 06\\Morrow\\96213\\400-Engineering\\Roadway\\Sheets\\96213_XS002.dgn","96213_XS203","Roadway Cross Sections Sheet","Cross Sections for Bridge MRW-314-2062","96213","CROSS SECTIONS - LOCATION 2","STA. 12+00.00 TO STA. 12+25.00","---NA---","P.26","P.54","---NA---","---NA---","AMH","---NA---","KLM","2023-09-12","---NA---","---NA---","---NA---","---NA---","---NA---","MRW-314-(8.11) (20.62)","ODOT_ZEPHYR","34","22","32","2.5","1.5","2","Placed Agency Cells: ODOT_ZEPHYR"]
["01 Active Projects\\District 06\\Morrow\\96213\\400-Engineering\\Roadway\\Sheets\\96213_XS002.dgn","96213_XS204","Roadway Cross Sections Sheet","Cross Sections for Bridge MRW-314-2062","96213","CROSS SECTIONS - LOCATION 2","STA. 12+50.00 TO STA. 13+00.00","---NA---","P.27","P.54","---NA---","---NA---","AMH","---NA---","KLM","2023-09-12","---NA---","---NA---","---NA---","---NA---","---NA---","MRW-314-(8.11) (20.62)","ODOT_ZEPHYR","34","22","32","2.5","1.5","2","Placed Agency Cells: ODOT_ZEPHYR"]
["01 Active Projects\\District 06\\Morrow\\96213\\400-Engineering\\Roadway\\Sheets\\96213_XS002.dgn","96213_XS205","Roadway Cross Sections Sheet","Cross Sections for Bridge MRW-314-2062","96213","CROSS SECTIONS - LOCATION 2","STA. 13+25.00 TO STA. 13+75.00","---NA---","P.28","P.54","---NA---","---NA---","AMH","---NA---","KLM","2023-09-12","---NA---","---NA---","---NA---","---NA---","---NA---","MRW-314-(8.11) (20.62)","ODOT_ZEPHYR","34","22","32","2.5","1.5","2","Placed Agency Cells: ODOT_ZEPHYR"]
["01 Active Projects\\District 06\\Morrow\\96213\\400-Engineering\\Structures\\SFN_5903034\\Sheets\\96213_SFN_5903034_SN001.dgn","96213_SFN_5903034_SN001","Bridge General Notes Sheet",null,"96213","STRUCTURE NOTES","MRW-314-0811","OVER HOWARD RUN","P.29","P.54",1,{"$f":"$K$37","v":8},"JPH","AMH","AMH","2023-11-02",5903034,"---NA---","---NA---","---NA---","---NA---","MRW-314-(8.11) (20.62)","ODOT_ZEPHYR","34","22","32","3","1.5","2","Placed Agency Cells: ODOT_ZEPHYR"]
["01 Active Projects\\District 06\\Morrow\\96213\\400-Engineering\\Structures\\SFN_5903034\\Sheets\\96213_SFN_5903034_SQ001.dgn","96213_SFN_5903034_SQ001","Bridge Estimated Quantities Sheet",null,"96213","ESTIMATED QUANTITIES","MRW-314-0811","OVER HOWARD RUN","P.30","P.54",2,{"$f":"$K$37","v":8},"JPH","AMH","AMH","2023-11-02",5903034,"---NA---","---NA---","---NA---","---NA---","MRW-314-(8.11) (20.62)","ODOT_ZEPHYR","34","22","32","3","1.5","2","Placed Agency Cells: ODOT_ZEPHYR"]
["01 Active Projects\\District 06\\Morrow\\96213\\400-Engineering\\Structures\\SFN_5903034\\Sheets\\96213_SFN_5903034_SP001.dgn","96213_SFN_5903034_SP001","Bridge Site Plan Sheet",null,"96213","SITE PLAN","MRW-314-0811","OVER HOWARD RUN","P.31","P.54",3,8,"JPH","AMH","AMH","2023-11-02",5903034,"---NA---","---NA---","---NA---","---NA---","MRW-314-(8.11) (20.62)","ODOT_ZEPHYR","34","22","32","3","1.5","2","Placed Agency Cells: ODOT_ZEPHYR"]
["01 Active Projects\\District 06\\Morrow\\96213\\400-Engineering\\Structures\\SFN_5903034\\Sheets\\96213_SFN_5903034_SG001.dgn","96213_SG001","Bridge General Plan Sheet",null,"96213","FOOTING LAYOUT PLAN","MRW-314-0811","OVER HOWARD RUN","P.32","P.54",4,8,"JPH","AMH","AMH","2023-11-02",5903034,"---NA---","---NA---","---NA---","---NA---","MRW-314-(8.11) (20.62)","ODOT_ZEPHYR","34","22","32","3","1.5","2","Placed Agency Cells: ODOT_ZEPHYR"]
["01 Active Projects\\District 06\\Morrow\\96213\\400-Engineering\\Structures\\SFN_5903034\\Sheets\\96213_SFN_5903034_SG001.dgn","96213_SG002","Bridge General Plan Sheet",null,"96213","FOOTING DETAILS","MRW-314-0811","OVER HOWARD RUN","P.33","P.54",5,8,"JPH","AMH","AMH","2023-11-02",5903034,"---NA---","---NA---","---NA---","---NA---","MRW-314-(8.11) (20.62)","ODOT_ZEPHYR","34","22","32","3","1.5","2","Placed Agency Cells: ODOT_ZEPHYR"]
["01 Active Projects\\District 06\\Morrow\\96213\\400-Engineering\\Structures\\SFN_5903034\\Sheets\\96213_SFN_5903034_SG001.dgn","96213_SG003","Bridge General Plan Sheet",null,"96213","WINGWALL DETAILS","MRW-314-0811","OVER HOWARD RUN","P.34","P.54",6,8,"JPH","AMH","AMH","2023-11-02",5903034,"---NA---","---NA---","---NA---","---NA---","MRW-314-(8.11) (20.62)","ODOT_ZEPHYR","34","22","32","3","1.5","2","Placed Agency Cells: ODOT_ZEPHYR"]
["01 Active Projects\\District 06\\Morrow\\96213\\400-Engineering\\Structures\\SFN_5903034\\Sheets\\96213_SFN_5903034_SG001.dgn","96213_SG003A","Bridge General Plan Sheet",null,"96213","STEEL PLATE DETAILS","MRW-314-0811","OVER HOWARD RUN","P.35","P.52",7,8,"AMH",null,null,null,"5903034","---NA---","---NA---","---NA---","---NA---","MRW-314-(8.11) (20.62)","ODOT_ZEPHYR","34","22","32","3","1.5","2","Placed Agency Cells: ODOT_ZEPHYR"]
["01 Active Projects\\District 06\\Morrow\\96213\\400-Engineering\\Structures\\SFN_5903034\\Sheets\\96213_SFN_5903034_SG001.dgn","96213_SL001","Bridge General Plan Sheet",null,"96213","REINFORCING STEEL LIST","MRW-314-0811","OVER HOWARD RUN","P.36","P.54",8,8,"JPH","AMH","AMH","2023-11-02",5903034,"---NA---","---NA---","---NA---","---NA---","MRW-314-(8.11) (20.62)","ODOT_ZEPHYR","34","22","32","3","1.5","2","Placed Agency Cells: ODOT_ZEPHYR"]
["01 Active Projects\\District 06\\Morrow\\96213\\400-Engineering\\Structures\\SFN_5903395\\Sheets\\96213_SFN_5903395_SN001.dgn","96213_SFN5903395_SN001","Drainage Notes Sheet","For Bridge 2062","96213","STRUCTURE NOTES","MRW-314-2062","OVER WILCOX RUN","P.37","P.54",1,{"$f":"$K$48","v":11},"AMH","JPH","JPH","2023-11-02",5903395,"---NA---","---NA---","---NA---","---NA---","MRW-314-(8.11) (20.62)","ODOT_ZEPHYR","34","22","32","3","1.5","2","Placed Agency Cells: ODOT_ZEPHYR"]
["01 Active Projects\\District 06\\Morrow\\96213\\400-Engineering\\Structures\\SFN_5903395\\Sheets\\96213_SFN_5903395_SQ001.dgn","96213_SFN_5903395_SQ001","Bridge Estimated Quantities Sheet",null,"96213","ESTIMATED QUANTITIES","MRW-314-2062","OVER WILCOX RUN","P.38","P.54",2,{"$f":"$K$48","v":11},"AMH","JPH","JPH","2023-11-02",5903395,"---NA---","---NA---","---NA---","---NA---","MRW-314-(8.11) (20.62)","ODOT_ZEPHYR","34","22","32","3","1.5","2","Placed Agency Cells: ODOT_ZEPHYR"]
["01 Active Projects\\District 06\\Morrow\\96213\\400-Engineering\\Structures\\SFN_5903395\\Sheets\\96213_SFN_5903395_SP001.dgn","96213_SFN_5903395_SP001","Bridge Site Plan Sheet",null,"96213","SITE PLAN","MRW-314-2062","OVER WILCOX RUN","P.39","P.54",3,11,"AMH","JPH","JPH","2023-11-02",5903395,"---NA---","2.5","5","10","MRW-314-(8.11) (20.62)","ODOT_ZEPHYR","34","22","32","3","1.5","2","Placed Agency Cells: ODOT_ZEPHYR"]
["01 Active Projects\\District 06\\Morrow\\96213\\400-Engineering\\Structures\\SFN_5903395\\Sheets\\96213_SFN_5903395_SM001.dgn","96213_SFN_5903395_SM001","Bridge Miscellaneous Details Sheet",null,"96213","FOOTING LAYOUT PLAN","MRW-314-2062","OVER WILCOX RUN","P.40","P.54",4,11,"AMH","JPH","JPH","2023-11-02",5903395,"---NA---","---NA---","---NA---","---NA---","MRW-314-(8.11) (20.62)","ODOT_ZEPHYR","34","22","32","3","1.5","2","Placed Agency Cells: ODOT_ZEPHYR"]
["01 Active Projects\\District 06\\Morrow\\96213\\400-Engineering\\Structures\\SFN_5903395\\Sheets\\96213_SFN_5903395_SM001.dgn","96213_SFN_5903395_SM002","Bridge Miscellaneous Details Sheet",null,"96213","FOOTING DETAILS","MRW-314-2062","OVER WILCOX RUN","P.41","P.54",5,11,"AMH","JPH","JPH","2023-11-02",5903395,"---NA---","---NA---","---NA---","---NA---","MRW-314-(8.11) (20.62)","ODOT_ZEPHYR","34","22","32","3","1.5","2","Placed Agency Cells: ODOT_ZEPHYR"]
["01 Active Projects\\District 06\\Morrow\\96213\\400-Engineering\\Structures\\SFN_5903395\\Sheets\\96213_SFN_5903395_SM001.dgn","96213_SFN_5903395_SM003","Bridge Miscellaneous Details Sheet",null,"96213","WINGWALL ELEVATIONS","MRW-314-2062","OVER WILCOX RUN","P.42","P.54",6,11,"AMH","JPH","JPH","2023-11-02",5903395,"---NA---","---NA---","---NA---","---NA---","MRW-314-(8.11) (20.62)","ODOT_ZEPHYR","34","22","32","3","1.5","2","Placed Agency Cells: ODOT_ZEPHYR"]
["01 Active Projects\\District 06\\Morrow\\96213\\400-Engineering\\Structures\\SFN_5903395\\Sheets\\96213_SFN_5903395_SM001.dgn","96213_SFN_5903395_SM004","Bridge Miscellaneous Details Sheet",null,"96213","INLET WINGWALL DETAILS","MRW-314-2062","OVER WILCOX RUN","P.43","P.54",7,11,"AMH","JPH","JPH","2023-11-02",5903395,"---NA---","---NA---","---NA---","---NA---","MRW-314-(8.11) (20.62)","ODOT_ZEPHYR","34","22","32","3","1.5","2","Placed Agency Cells: ODOT_ZEPHYR"]
["01 Active Projects\\District 06\\Morrow\\96213\\400-Engineering\\Structures\\SFN_5903395\\Sheets\\96213_SFN_5903395_SM001.dgn","96213_SFN_5903395_SM005","Bridge Miscellaneous Details Sheet",null,"96213","OUTLET WINGWALL DETAILS","MRW-314-2062","OVER WILCOX RUN","P.44","P.54",8,11,"AMH","JPH","JPH","2023-11-02",5903395,"---NA---","---NA---","---NA---","---NA---","MRW-314-(8.11) (20.62)","ODOT_ZEPHYR","34","22","32","3","1.5","2","Placed Agency Cells: ODOT_ZEPHYR"]
["01 Active Projects\\District 06\\Morrow\\96213\\400-Engineering\\Structures\\SFN_5903395\\Sheets\\96213_SFN_5903395_SM001.dgn","96213_SFN_5903395_SM006","Bridge Miscellaneous Details Sheet",null,"96213","FORESLOPE WALL DETAILS","MRW-314-2062","OVER WILCOX RUN","P.45","P.54",9,11,"AMH","JPH","JPH","2023-11-02",5903395,"---NA---","---NA---","---NA---","---NA---","MRW-314-(8.11) (20.62)","ODOT_ZEPHYR","34","22","32","3","1.5","2","Placed Agency Cells: ODOT_ZEPHYR"]
["01 Active Projects\\District 06\\Morrow\\96213\\400-Engineering\\Structures\\SFN_5903395\\Sheets\\96213_SFN_5903395_SM001.dgn","96213_SFN_5903395_SM006A","Bridge Miscellaneous Details Sheet",null,"96213","STEEL PLATE DETAILS","MRW-314-2062","OVER WILCOX RUN","P.46","P.52",10,11,"AMH",null,null,null,"5903395","---NA---","---NA---","---NA---","---NA---","MRW-314-(8.11) (20.62)","ODOT_ZEPHYR","34","22","32","3","1.5","2","Placed Agency Cells: ODOT_ZEPHYR"]
["01 Active Projects\\District 06\\Morrow\\96213\\400-Engineering\\Structures\\SFN_5903395\\Sheets\\96213_SFN_5903395_SM001.dgn","96213_SFN_5903395_SM007","Bridge Miscellaneous Details Sheet",null,"96213","REINFORCING STEEL LIST","MRW-314-2062","OVER WILCOX RUN","P.47","P.54",11,11,"AMH","JPH","JPH","2023-11-02",5903395,"---NA---","---NA---","---NA---","---NA---","MRW-314-(8.11) (20.62)","ODOT_ZEPHYR","34","22","32","3","1.5","2","Placed Agency Cells: ODOT_ZEPHYR"]
["01 Active Projects\\District 06\\Morrow\\96213\\400-Engineering\\Geotechnical\\Sheets\\96213_ZC001.dgn","Sheet","Geotechnical Structure Foundation Exploration Cover Sheet",null,"96213","GEOTECHNICAL PROFILE - CULVERT","CULV. NO. MRW-314-0808 OVER HOWARD RUN & CULV. NO. MRW-314-2057 OVER WILCOX RUN","---NA---","P.48","P.54","1","7","ARR","---NA---","SAT","09/14/22","---NA---","---NA---","---NA---","---NA---","---NA---","MRW-314-(8.11) (20.62)","ODOT_ZEPHYR","---NA---","---NA---","---NA---","---NA---","---NA---","---NA---","Placed Agency Cells: ODOT_ZEPHYR"]
["01 Active Projects\\District 06\\Morrow\\96213\\400-Engineering\\Geotechnical\\Sheets\\96213_ZP101.dgn","CLX_Howard_Run - Plan 1 [Sheet]","Geotechnical Structure Foundation Exploration Plan and Profile Sheet","MRW-314-8.08","96213","GEOTECHNICAL PROFILE - CULVERT","CULVERT NO. MRW-314-0808 OVER HOWARD RUN","---NA---","P.49","P.54","2","7","ARR","---NA---","SAT","09/14/22","---NA---","---NA---","5","10","20","MRW-314-(8.11) (20.62)","ODOT_ZEPHYR","---NA---","---NA---","---NA---","---NA---","---NA---","---NA---","Placed Agency Cells: ODOT_ZEPHYR"]
["01 Active Projects\\District 06\\Morrow\\96213\\400-Engineering\\Geotechnical\\Sheets\\96213_ZP201.dgn","CLP_1 - Plan 1 [Sheet]","Geotechnical Structure Foundation Exploration Plan and Profile Sheet",null,"96213","GEOTECHNICAL PROFILE - CULVERT","CULVERT NO. MRW-314-2057 OVER WILCOX RUN","---NA---","P.50","P.54","3","7","ARR","---NA---","SAT","09/14/22","---NA---","---NA---","5","10","20","MRW-314-(8.11) (20.62)","ODOT_ZEPHYR","---NA---","---NA---","---NA---","---NA---","---NA---","---NA---","Placed Agency Cells: ODOT_ZEPHYR"]
["01 Active Projects\\District 06\\Morrow\\96213\\400-Engineering\\Geotechnical\\Sheets\\96213_ZL101.dgn","Sheet","Geotechnical Structure Foundation Exploration Boring Logs Sheet",null,"96213","GEOTECHNICAL PROFILE - CULVERT","CULVERT NO. MRW-314-0808 OVER HOWARD RUN","HISTORIC BORING LOG B-001-0-72","P.51","P.54","4","7","ARR","---NA---","SAT","09/14/22","---NA---","---NA---","---NA---","---NA---","---NA---","MRW-314-(8.11) (20.62)","ODOT_ZEPHYR","---NA---","---NA---","---NA---","---NA---","---NA---","---NA---","Placed Agency Cells: ODOT_ZEPHYR"]
["01 Active Projects\\District 06\\Morrow\\96213\\400-Engineering\\Geotechnical\\Sheets\\96213_ZL102.dgn","Sheet","Geotechnical Structure Foundation Exploration Boring Logs Sheet",null,"96213","GEOTECHNICAL PROFILE - CULVERT","CULVERT NO. MRW-314-0808 OVER HOWARD RUN","HISTORIC BORING LOG B-003-0-72","P.52","P.54","5","7","ARR","---NA---","SAT","09/14/22","---NA---","---NA---","---NA---","---NA---","---NA---","MRW-314-(8.11) (20.62)","ODOT_ZEPHYR","---NA---","---NA---","---NA---","---NA---","---NA---","---NA---","Placed Agency Cells: ODOT_ZEPHYR"]
["01 Active Projects\\District 06\\Morrow\\96213\\400-Engineering\\Geotechnical\\Sheets\\96213_ZL201.dgn","Sheet","Geotechnical Structure Foundation Exploration Boring Logs Sheet",null,"96213","GEOTECHNICAL PROFILE - CULVERT","CULVERT NO. MRW-314-2057 OVER WILCOX RUN","BORING LOG B-001-0-19","P.53","P.54","6","7","ARR","---NA---","SAT","09/14/22","---NA---","---NA---","---NA---","---NA---","---NA---","MRW-314-(8.11) (20.62)","ODOT_ZEPHYR","---NA---","---NA---","---NA---","---NA---","---NA---","---NA---","Placed Agency Cells: ODOT_ZEPHYR"]
["01 Active Projects\\District 06\\Morrow\\96213\\400-Engineering\\Geotechnical\\Sheets\\96213_ZL202.dgn","Sheet","Geotechnical Structure Foundation Exploration Boring Logs Sheet",null,"96213","GEOTECHNICAL PROFILE - CULVERT","CULVERT NO. MRW-314-2057 OVER WILCOX RUN","BORING LOG B-002-0-19","P.54",{"$f":"$I$55","v":"P.54"},"7","7","ARR","---NA---","SAT","09/14/22","---NA---","---NA---","---NA---","---NA---","---NA---","MRW-314-(8.11) (20.62)","ODOT_ZEPHYR","---NA---","---NA---","---NA---","---NA---","---NA---","---NA---","Placed Agency Cells: ODOT_ZEPHYR"]
[null,null,null,null,null,null,null,1,"P.53"]
[null,null,null,null,null,null,null,2,"P.54"]
[null,null,null,null,null,null,null,3,"P.55"]
[null,null,null,null,null,null,null,4,"P.56"]
[null,null,null,null,null,null,null,5,"P.57"]
[null,null,null,null,null,null,null,6,"P.58"]
[null,null,null,null,null,null,null,7,"P.59"]
[null,null,null,null,null,null,null,8,"P.60"]

{"sheet":"EDA","index":1,"n_rows":6,"n_cols":4,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[null,null,"EDA",{"$f":"Earthwork!G47/4840","v":0.34958677685950412}]

{"sheet":"GT","index":2,"n_rows":33,"n_cols":24,"rows_kept":33,"cut":false,"hidden":false,"merged":[[0,3,0,5],[24,23,24,24],[25,23,25,24],[26,23,26,24],[27,23,27,24],[22,23,22,24],[23,23,23,24],[14,13,15,20],[14,21,14,22],[15,21,15,22],[21,23,21,24],[14,23,14,24],[15,23,15,24],[20,23,20,24],[16,23,19,24],[7,0,7,1],[8,0,8,1],[9,0,9,1],[10,0,10,1],[7,2,7,3],[8,2,8,3],[9,2,9,3],[10,2,10,3],[2,0,2,1],[3,0,3,1],[4,0,4,1],[5,0,5,1],[6,0,6,1]]}
[]
[null,null,"MRW-314-8.11","MRW-314-20.62"]
["CURRENT ADT (2024)____________________________",null,2600,2900]
["DESIGN YEAR ADT (2044)_________________________",null,3200,3000]
["DESIGN HOURLY VOLUME (2044)__________________",null,400,400]
["DIRECTIONAL DISTRIBUTION_____________________",null,0.51,0.56000000000000005]
["TRUCKS (24 HOUR B&C)_________________________",null,0.2,0.11]
["DESIGN SPEED_________________________________",null,"55 MPH"]
["LEGAL SPEED__________________________________",null,"55 MPH"]
["DESIGN FUNCTIONAL CLASSIFICATION:",null,"05 MAJOR COLLECTOR (RURAL)"]
["NHS PROJECT________________________________",null,"NO"]
[]
[]
[]
[null,null,null,null,null,null,"INDEX OF SHEETS",null,null,null,null,null,null,"STANDARD CONSTRUCTION DRAWINGS",null,null,null,null,null,null,null,"SUPPLEMENTAL",null,"SPECIAL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SPECIFICATIONS",null,"PROVISIONS"]
[null,null,null,null,null,null,"TITLE",null,null,{"$f":"'sht mgr'!I2","v":"P.1"},null,null,null,"BP-3.1","2022-01-21","TC-42.20","2013-10-18","MT-97.10","2019-04-19","DM-1.1","2020-07-17",800,"2023-10-20","WATERWAY PERMIT CONDITIONS 9/12/2023"]
[null,null,null,null,null,null,"TYPICAL SECTIONS",null,null,{"$f":"'sht mgr'!I3","v":"P.2"},null,null,null,null,null,"TC-52.10","2013-10-18","MT-101.60","2023-04-21","DM-4.4","2016-01-15",832,"2023-07-21"]
[null,null,null,null,null,null,"GENERAL NOTES",null,null,{"$f":"'sht mgr'!I4","v":"P.3"},null,null,null,"MGS-1.1","2021-07-16","TC-52.20","2021-01-15","MT-101.90","2020-07-17",null,null,851,"2022-01-21"]
[null,null,null,null,null,null,"MAINTENANCE OF TRAFFIC NOTES",{"$f":"'sht mgr'!I5","v":"P.4"},"-",{"$f":"'sht mgr'!I7","v":"P.6"},null,null,null,"MGS-2.1","2018-01-19","TC-61.30","2019-07-19","MT-105.10","2020-01-17",null,null,878,"2022-01-21"]
[null,null,null,null,null,null,"MAINTENANCE OF TRAFFIC PLAN",{"$f":"'sht mgr'!I8","v":"P.7"},"-",{"$f":"'sht mgr'!I10","v":"P.9"},null,null,null,"MGS-2.3","2023-01-20","TC-65.10","2014-01-17"]
[null,null,null,null,null,null,"GENERAL SUMMARY",{"$f":"'sht mgr'!I11","v":"P.10"},"-",{"$f":"'sht mgr'!I12","v":"P.11"},null,null,null,"MGS-4.2","2013-07-19","TC-65.11","2022-07-15"]
[null,null,null,null,null,null,"PAVEMENT CALCULATIONS",null,null,{"$f":"'sht mgr'!I13","v":"P.12"},null,null,null,"MGS-5.3","2016-07-15"]
[null,null,null,null,null,null,"PLAN SUBSUMMARY",null,null,{"$f":"'sht mgr'!I14","v":"P.13"}]
[null,null,null,null,null,null,"EARTHWORK SUBSUMMARY",null,null,{"$f":"'sht mgr'!I15","v":"P.14"}]
[null,null,null,null,null,null,"ROADWAY PLAN - LOCATION 1",null,null,{"$f":"'sht mgr'!I16","v":"P.15"}]
[null,null,null,null,null,null,"ROADWAY PLAN - LOCATION 2",null,null,{"$f":"'sht mgr'!I17","v":"P.16"}]
[null,null,null,null,null,null,"CROSS SECTIONS - LOCATION 1",{"$f":"'sht mgr'!I18","v":"P.17"},"-",{"$f":"'sht mgr'!I24","v":"P.23"}]
[null,null,null,null,null,null,"CROSS SECTIONS - LOCATION 2",{"$f":"'sht mgr'!I25","v":"P.24"},"-",{"$f":"'sht mgr'!I29","v":"P.28"}]
[null,null,null,null,null,null,"STRUCTURES (20 FOOT SPAN AND UNDER)"]
[null,null,null,null,null,null,"          MRW-314-0811",{"$f":"'sht mgr'!I30","v":"P.29"},"-",{"$f":"'sht mgr'!I37","v":"P.36"}]
[null,null,null,null,null,null,"          MRW-314-2062",{"$f":"'sht mgr'!I38","v":"P.37"},"-",{"$f":"'sht mgr'!I48","v":"P.47"}]
[null,null,null,null,null,null,"GEOTECHNICAL DATA",{"$f":"'sht mgr'!I49","v":"P.48"},"-",{"$f":"'sht mgr'!I55","v":"P.54"}]

{"sheet":"GY","index":3,"n_rows":14,"n_cols":7,"rows_kept":14,"cut":false,"hidden":false,"merged":[[7,0,7,6],[1,0,1,6],[4,0,4,1],[2,0,2,1],[11,0,11,1],[8,0,8,1]]}
[]
["TYPICAL SECTION #1 - FULL-DEPTH PAVEMENT REPLACEMENT"]
["LOCATION 1"]
["STA.",{"$f":"D10","v":270},"TO STA.",{"$f":"B11","v":341},"=",{"$f":"ROUND(D4-B4,0)","v":71},"FT"]
["LOCATION 2"]
["STA.",{"$f":"D13","v":1190},"TO STA.",{"$f":"B14","v":1250},"=",{"$f":"ROUND(D6-B6,0)","v":60},"FT"]
[]
["TYPICAL SECTION #2 - 1.50\" RESURFACING"]
["LOCATION 1"]
["STA.",245,"TO STA.",270,"=",{"$f":"ROUND(D10-B10,0)","v":25},"FT"]
["STA.",341,"TO STA.",366,"=",25,"FT"]
["LOCATION 2"]
["STA.",1165,"TO STA.",1190,"=",{"$f":"ROUND(D13-B13,0)","v":25},"FT"]
["STA.",{"$f":"1250","v":1250},"TO STA.",{"$f":"1275","v":1275},"=",25,"FT"]

{"sheet":"MN","index":4,"n_rows":22,"n_cols":14,"rows_kept":22,"cut":false,"hidden":false,"merged":[[9,3,11,3],[12,3,12,6],[13,3,14,3],[15,3,15,6],[6,3,6,6],[7,3,8,3],[7,4,8,4],[18,12,18,13],[7,5,8,5],[7,6,8,6],[18,11,19,11],[18,10,19,10],[18,9,19,9]]}
[]
[]
[]
[]
[]
[]
[null,null,null,"NOTIFICATION TIME FRAME TABLE"]
[null,null,null,"ITEM","DURATION OF CLOSURE","NOTIFICATION DUE TO DISTRICT 6 COMMUNICATIONS OFFICE","SIGN DISPLAYED TO PUBLIC"]
[]
[null,null,null,"RAMP & ROAD CLOSURES",">= 2 WEEKS","21 CALENDAR DAYS PRIOR TO CLOSURE","14 CALENDAR DAYS PRIOR TO CLOSURE"]
[null,null,null,null,"> 12 HOURS & < 2 WEEKS","14 CALENDAR DAYS PRIOR TO CLOSURE","7 CALENDAR DAYS PRIOR TO CLOSURE"]
[null,null,null,null,"<= 12 HOURS","4 BUSINESS DAYS PRIOR TO CLOSURE","2 CALENDAR DAYS PRIOR TO CLOSURE"]
[]
[null,null,null,"LANE CLOSURES & RESTRICTIONS",">= 2 WEEKS","14 CALENDAR DAYS PRIOR TO CLOSURE"]
[null,null,null,null,"< 2 WEEKS","5 BUSINESS DAYS PRIOR TO CLOSURE"]
[]
[null,null,null,"START OF CONSTRUCTION & TRAFFIC PATTERN CHANGES","N/A","14 CALENDAR DAYS PRIOR TO IMPLEMENTATION"]
[]
[null,null,null,null,null,null,null,null,null,"DESCRIPTION OF CRITICAL WORK","DAYS TO COMPLETE","DISINCENTIVE $ PER DAY","WORK WINDOW"]
[null,null,null,null,null,null,null,null,null,null,null,null,"START","END"]
[null,null,null,null,null,null,null,null,null,"COMPLETE STRUCTURE REPLACEMENT AT MRW-314-0811 (LOCATION 1). INCLUDES FULL-DEPTH PAVEMENT AND PERMANENT PAVEMENT MARKINGS.","21 DAYS",4000,"CONTRACT EXECUTION DATE","CONTRACT COMPLETION DATE"]
[null,null,null,null,null,null,null,null,null,"COMPLETE STRUCTURE REPLACEMENT AT MRW-314-2062 (LOCATION 2). INCLUDES FULL-DEPTH PAVEMENT AND PERMANENT PAVEMENT MARKINGS.","21 DAYS",4000,"CONTRACT EXECUTION DATE","CONTRACT COMPLETION DATE"]

{"sheet":"MD","index":5,"n_rows":12,"n_cols":22,"rows_kept":12,"cut":false,"hidden":false,"merged":[[9,17,9,21],[9,9,9,14]]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"R11-3B-60"]
[null,null,null,null,null,null,null,null,null,"LOCATION 1",null,null,null,null,null,null,null,"LOCATION 2"]
[null,null,null,null,null,null,null,null,null,"SR-314 & SR-95","SR-314 & SHURR RD","SR-314 & PENLAN RD","SR-314 & LEVERING RD","SR-314 & PROSPECT MT VERNON RD","SR-314 & SR-229",null,null,"SR-314 & US-42","SR-314 & W POINT BELLVILLE RD","SR-314 & ST JAMES BELLVILLE RD","SR-314 & STEAM CORNERS-LEXINGTON RD","SR-314 & SR-97"]
[null,null,null,null,null,null,null,null,"TEXT FOR R-11-3B-60",1.8,1.2,0.5,1.6,3.4,4,null,"TEXT FOR R-11-3B-60",0.6,0.4,1.4,3.4,5]

{"sheet":"TYP LEGEND","index":6,"n_rows":14,"n_cols":2,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["LEGEND"]
["A","APPROX. 13\" EXISTING ASPHALT - SEE GEOTECHNICAL DATA"]
[1,"ITEM 202 - PAVEMENT REMOVED"]
[2,"ITEM 203 - EXCAVATION"]
[3,"ITEM 204 - SUBGRADE COMPACTION"]
[4,"ITEM 254 - PAVEMENT PLANING, ASPHALT CONCRETE, 1.50\""]
[5,"ITEM 301 - 10.00\" ASPHALT CONCRETE BASE, PG64-22, (449) (TWO 5.00\" LIFTS)"]
[6,"ITEM 304 - 6.00\" AGGREGATE BASE*"]
["6A","ITEM 304 - 13.00\" AGGREGATE BASE"]
[7,"ITEM 407 - NON-TRACKING TACK COAT (RATE PER CMS TABLE 407.06-1)"]
[8,"ITEM 441 - 1.50\" ASPHALT CONCRETE SURFACE COURSE, TYPE 1, (449), PG64-22"]
[9,"ITEM 441 - 3.00\" ASPHALT CONCRETE SURFACE COURSE, TYPE 1, (449), PG64-22 (TWO 1.50\" LIFTS)"]
[10,"ITEM 605 - AGGREGATE DRAINS"]
[11,"ITEM 659 - SEEDING AND MULCHING"]

{"sheet":"GG001","index":7,"n_rows":71,"n_cols":25,"rows_kept":71,"cut":false,"hidden":false,"merged":[[0,0,1,11],[3,0,4,11],[3,12,7,12],[3,13,4,13],[0,12,2,12],[7,22,7,24],[3,14,4,14],[3,15,4,15],[3,16,4,16],[3,17,4,17]]}
[null,null,null,null,null,null,null,null,null,null,null,null,"PARTICIPATION"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SEE"]
["SHEET NUMBER",null,null,null,null,null,null,null,null,null,null,null,"01/STR/10","ITEM","ITEM","GRAND","UNIT","DESCRIPTION","SHEET"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NO."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EXT","TOTAL"]
[]
[{"$f":"'sht mgr'!I4","v":"P.3"},{"$f":"'sht mgr'!I5&\"-\"&'sht mgr'!I7","v":"P.4-P.6"},{"$f":"'sht mgr'!I13","v":"P.12"},{"$f":"'sht mgr'!I14","v":"P.13"},{"$f":"'sht mgr'!I15","v":"P.14"},{"$f":"'sht mgr'!I31","v":"P.30"},{"$f":"'sht mgr'!I39","v":"P.38"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CHECKS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ROADWAY",null,null,null,null,"QTY","UNIT","DESC"]
[null,null,null,null,null,"LS","LS",null,null,null,null,null,"LS",{"$f":"LEFT('0811 Bridge'!A3,3)","v":"201"},{"$f":"RIGHT('0811 Bridge'!A3,5)","v":"11000"},"LS",null,{"$f":"'0811 Bridge'!D3","v":"CLEARING AND GRUBBING"},null,null,{"$f":"N10&\"E\"&O10","v":"201E11000"},null,{"$f":"IF(P10=[4]SimpleForm!AC14,1,\"BAD\")","v":1},{"$f":"IF(Q10=[4]SimpleForm!AD14,1,\"BAD\")","v":1},{"$f":"IF(R10=[4]SimpleForm!AE14,1,\"BAD\")","v":1}]
[null,null,{"$f":"Pavement!J24","v":349},null,null,null,null,null,null,null,null,null,{"$f":"SUM(A11:L11)","v":349},{"$f":"LEFT(Pavement!J2,3)","v":"202"},{"$f":"RIGHT(Pavement!J2,5)","v":"23000"},{"$f":"M11","v":349},{"$f":"Pavement!J10","v":"SY"},{"$f":"Pavement!J3","v":"PAVEMENT REMOVED"},null,null,{"$f":"N11&\"E\"&O11","v":"202E23000"},null,{"$f":"IF(P11=[4]SimpleForm!AC15,1,\"BAD\")","v":1},{"$f":"IF(Q11=[4]SimpleForm!AD15,1,\"BAD\")","v":1},{"$f":"IF(R11=[4]SimpleForm!AE15,1,\"BAD\")","v":1}]
[null,null,null,{"$f":"Plan!I28","v":5},null,null,null,null,null,null,null,null,5,{"$f":"LEFT(Plan!I2,3)","v":"202"},{"$f":"RIGHT(Plan!I2,5)","v":"35200"},5,{"$f":"Plan!I14","v":"FT"},{"$f":"Plan!I3","v":"PIPE REMOVED, OVER 24\""},null,null,{"$f":"N12&\"E\"&O12","v":"202E35200"},null,{"$f":"IF(P12=[4]SimpleForm!AC16,1,\"BAD\")","v":1},{"$f":"IF(Q12=[4]SimpleForm!AD16,1,\"BAD\")","v":1},{"$f":"IF(R12=[4]SimpleForm!AE16,1,\"BAD\")","v":1}]
[null,null,null,{"$f":"Plan!J28","v":24},null,null,null,null,null,null,null,null,24,{"$f":"LEFT(Plan!J2,3)","v":"202"},{"$f":"RIGHT(Plan!J2,5)","v":"75000"},24,{"$f":"Plan!J14","v":"FT"},{"$f":"Plan!J3","v":"FENCE REMOVED"},null,null,"202E75000",null,{"$f":"IF(P13=[4]SimpleForm!AC17,1,\"BAD\")","v":1},{"$f":"IF(Q13=[4]SimpleForm!AD17,1,\"BAD\")","v":1},{"$f":"IF(R13=[4]SimpleForm!AE17,1,\"BAD\")","v":1}]
[null,null,null,{"$f":"Plan!K28","v":300},null,null,null,null,null,null,null,null,300,{"$f":"LEFT(Plan!K2,3)","v":"202"},{"$f":"RIGHT(Plan!K2,5)","v":"38001"},300,{"$f":"Plan!K14","v":"FT"},{"$f":"Plan!K3","v":"GUARDRAIL REMOVED, AS PER PLAN"},{"$f":"A8","v":"P.3"},null,"202E38001",null,{"$f":"IF(P14=[4]SimpleForm!AC18,1,\"BAD\")","v":1},{"$f":"IF(Q14=[4]SimpleForm!AD18,1,\"BAD\")","v":1},{"$f":"IF(R14=[4]SimpleForm!AE18,1,\"BAD\")","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(P15=[4]SimpleForm!AC19,1,\"BAD\")","v":1},{"$f":"IF(Q15=[4]SimpleForm!AD19,1,\"BAD\")","v":1},{"$f":"IF(R15=[4]SimpleForm!AE19,1,\"BAD\")","v":1}]
[null,null,null,{"$f":"Plan!L28","v":6},null,null,null,null,null,null,null,null,6,{"$f":"LEFT(Plan!L2,3)","v":"202"},{"$f":"RIGHT(Plan!L2,5)","v":"42001"},6,{"$f":"Plan!L14","v":"EACH"},{"$f":"Plan!L3","v":"ANCHOR ASSEMBLY REMOVED, TYPE A, AS PER PLAN"},{"$f":"A8","v":"P.3"},null,"202E42001",null,{"$f":"IF(P16=[4]SimpleForm!AC20,1,\"BAD\")","v":1},{"$f":"IF(Q16=[4]SimpleForm!AD20,1,\"BAD\")","v":1},{"$f":"IF(R16=[4]SimpleForm!AE20,1,\"BAD\")","v":1}]
[null,null,{"$f":"Pavement!K24","v":87},null,{"$f":"Earthwork!E47","v":133},null,null,null,null,null,null,null,220,{"$f":"LEFT(Pavement!K2,3)","v":"203"},{"$f":"RIGHT(Pavement!K2,5)","v":"10000"},220,{"$f":"Pavement!K10","v":"CY"},{"$f":"Pavement!K3","v":"EXCAVATION"},null,null,"203E10000",null,{"$f":"IF(P17=[4]SimpleForm!AC21,1,\"BAD\")","v":1},{"$f":"IF(Q17=[4]SimpleForm!AD21,1,\"BAD\")","v":1},{"$f":"IF(R17=[4]SimpleForm!AE21,1,\"BAD\")","v":1}]
[null,null,null,null,{"$f":"Earthwork!F47","v":174},null,null,null,null,null,null,null,174,203,20000,174,"CY",{"$f":"Earthwork!F2","v":"EMBANKMENT"},null,null,"203E20000",null,{"$f":"IF(P18=[4]SimpleForm!AC22,1,\"BAD\")","v":1},{"$f":"IF(Q18=[4]SimpleForm!AD22,1,\"BAD\")","v":1},{"$f":"IF(R18=[4]SimpleForm!AE22,1,\"BAD\")","v":1}]
[null,null,{"$f":"Pavement!L24","v":389},null,null,null,null,null,null,null,null,null,389,{"$f":"LEFT(Pavement!L2,3)","v":"204"},{"$f":"RIGHT(Pavement!L2,5)","v":"10000"},389,{"$f":"Pavement!L10","v":"SY"},{"$f":"Pavement!L3","v":"SUBGRADE COMPACTION"},null,null,"204E10000",null,{"$f":"IF(P19=[4]SimpleForm!AC23,1,\"BAD\")","v":1},{"$f":"IF(Q19=[4]SimpleForm!AD23,1,\"BAD\")","v":1},{"$f":"IF(R19=[4]SimpleForm!AE23,1,\"BAD\")","v":1}]
[null,null,null,{"$f":"Plan!M28","v":737.5},null,null,null,null,null,null,null,null,737.5,{"$f":"LEFT(Plan!M2,3)","v":"606"},{"$f":"RIGHT(Plan!M2,5)","v":"15050"},737.5,{"$f":"Plan!M14","v":"FT"},{"$f":"Plan!M3","v":"GUARDRAIL, TYPE MGS"},null,null,"606E15050",null,{"$f":"IF(P20=[4]SimpleForm!AC24,1,\"BAD\")","v":1},{"$f":"IF(Q20=[4]SimpleForm!AD24,1,\"BAD\")","v":1},{"$f":"IF(R20=[4]SimpleForm!AE24,1,\"BAD\")","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(P21=[4]SimpleForm!AC25,1,\"BAD\")","v":1},{"$f":"IF(Q21=[4]SimpleForm!AD25,1,\"BAD\")","v":1},{"$f":"IF(R21=[4]SimpleForm!AE25,1,\"BAD\")","v":1}]
[null,null,null,{"$f":"Plan!N28","v":25},null,null,null,null,null,null,null,null,25,{"$f":"LEFT(Plan!N2,3)","v":"606"},{"$f":"RIGHT(Plan!N2,5)","v":"15150"},25,{"$f":"Plan!N14","v":"FT"},{"$f":"Plan!N3","v":"GUARDRAIL, TYPE MGS HALF POST SPACING"},null,null,"606E15150",null,{"$f":"IF(P22=[4]SimpleForm!AC26,1,\"BAD\")","v":1},{"$f":"IF(Q22=[4]SimpleForm!AD26,1,\"BAD\")","v":1},{"$f":"IF(R22=[4]SimpleForm!AE26,1,\"BAD\")","v":1}]
[null,null,null,{"$f":"Plan!O28","v":43.75},null,null,null,null,null,null,null,null,43.75,{"$f":"LEFT(Plan!O2,3)","v":"606"},{"$f":"RIGHT(Plan!O2,5)","v":"15300"},43.75,{"$f":"Plan!O14","v":"FT"},{"$f":"Plan!O3","v":"GUARDRAIL, TYPE MGS QUARTER POST SPACING WITH LONG POSTS"},null,null,"606E15300",null,{"$f":"IF(P23=[4]SimpleForm!AC27,1,\"BAD\")","v":1},{"$f":"IF(Q23=[4]SimpleForm!AD27,1,\"BAD\")","v":1},{"$f":"IF(R23=[4]SimpleForm!AE27,1,\"BAD\")","v":1}]
[null,null,null,{"$f":"Plan!P28","v":6},null,null,null,null,null,null,null,null,6,{"$f":"LEFT(Plan!P2,3)","v":"606"},{"$f":"RIGHT(Plan!P2,5)","v":"26151"},6,{"$f":"Plan!P14","v":"EACH"},{"$f":"Plan!P3","v":"ANCHOR ASSEMBLY, MGS TYPE E, AS PER PLAN (MASH2016)"},{"$f":"'sht mgr'!I4","v":"P.3"},null,"606E26151",null,{"$f":"IF(P24=[4]SimpleForm!AC28,1,\"BAD\")","v":1},{"$f":"IF(Q24=[4]SimpleForm!AD28,1,\"BAD\")","v":1},{"$f":"IF(R24=[4]SimpleForm!AE28,1,\"BAD\")","v":1}]
[null,null,null,{"$f":"Plan!Q28","v":2},null,null,null,null,null,null,null,null,2,{"$f":"LEFT(Plan!Q2,3)","v":"606"},{"$f":"RIGHT(Plan!Q2,5)","v":"26550"},2,{"$f":"Plan!Q14","v":"EACH"},{"$f":"Plan!Q3","v":"ANCHOR ASSEMBLY, MGS TYPE T"},null,null,"606E26550",null,{"$f":"IF(P25=[4]SimpleForm!AC29,1,\"BAD\")","v":1},{"$f":"IF(Q25=[4]SimpleForm!AD29,1,\"BAD\")","v":1},{"$f":"IF(R25=[4]SimpleForm!AE29,1,\"BAD\")","v":1}]
[25,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(A26:L26)","v":25},606,98000,{"$f":"M26","v":25},"FT","GUARDRAIL, MISC.: ALTERNATIVE GUARDRAIL PLACEMENT",{"$f":"A8","v":"P.3"},null,"606E98000",null,{"$f":"IF(P26=[4]SimpleForm!AC30,1,\"BAD\")","v":1},{"$f":"IF(Q26=[4]SimpleForm!AD30,1,\"BAD\")","v":1},{"$f":"IF(R26=[4]SimpleForm!AE30,1,\"BAD\")","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(P27=[4]SimpleForm!AC31,1,\"BAD\")","v":1},{"$f":"IF(Q27=[4]SimpleForm!AD31,1,\"BAD\")","v":1},{"$f":"IF(R27=[4]SimpleForm!AE31,1,\"BAD\")","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,"LS",878,25000,"LS",null,"INSPECTION AND COMPACTION TESTING OF UNBOUND MATERIALS",null,null,"878E25000",null,{"$f":"IF(P28=[4]SimpleForm!AC32,1,\"BAD\")","v":1},{"$f":"IF(Q28=[4]SimpleForm!AD32,1,\"BAD\")","v":1},{"$f":"IF(R28=[4]SimpleForm!AE32,1,\"BAD\")","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(P29=[4]SimpleForm!AC33,1,\"BAD\")","v":1},{"$f":"IF(Q29=[4]SimpleForm!AD33,1,\"BAD\")","v":1},{"$f":"IF(R29=[4]SimpleForm!AE33,1,\"BAD\")","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EROSION CONTROL",null,null,null,{"$f":"R30","v":"EROSION CONTROL"},{"$f":"IF(P30=[4]SimpleForm!AC34,1,\"BAD\")","v":1},{"$f":"IF(Q30=[4]SimpleForm!AD34,1,\"BAD\")","v":1},{"$f":"IF(R30=[4]SimpleForm!AE34,1,\"BAD\")","v":1}]
[null,null,null,null,null,{"$f":"'0811 Bridge'!B17","v":23},{"$f":"'2062 Bridge'!B18","v":11},null,null,null,null,null,{"$f":"SUM(A31:L31)","v":34},{"$f":"LEFT('0811 Bridge'!A17,3)","v":"601"},{"$f":"RIGHT('0811 Bridge'!A17,5)","v":"11000"},{"$f":"M31","v":34},{"$f":"'0811 Bridge'!C17","v":"SY"},{"$f":"'0811 Bridge'!D17","v":"RIPRAP, TYPE D"},null,null,"601E11000",null,{"$f":"IF(P31=[4]SimpleForm!AC35,1,\"BAD\")","v":1},{"$f":"IF(Q31=[4]SimpleForm!AD35,1,\"BAD\")","v":1},{"$f":"IF(R31=[4]SimpleForm!AE35,1,\"BAD\")","v":1}]
[null,null,null,null,null,{"$f":"'0811 Bridge'!B18","v":100},{"$f":"'2062 Bridge'!B19","v":90},null,null,null,null,null,190,{"$f":"LEFT('0811 Bridge'!A18,3)","v":"601"},{"$f":"RIGHT('0811 Bridge'!A18,5)","v":"32100"},190,{"$f":"'0811 Bridge'!C18","v":"CY"},{"$f":"'0811 Bridge'!D18","v":"ROCK CHANNEL PROTECTION, TYPE B WITH FILTER"},null,null,"601E32100",null,{"$f":"IF(P32=[4]SimpleForm!AC36,1,\"BAD\")","v":1},{"$f":"IF(Q32=[4]SimpleForm!AD36,1,\"BAD\")","v":1},{"$f":"IF(R32=[4]SimpleForm!AE36,1,\"BAD\")","v":1}]
[null,null,null,{"$f":"Plan!S28","v":4},null,null,null,null,null,null,null,null,{"$f":"SUM(A33:L33)","v":4},{"$f":"LEFT(Plan!S2,3)","v":"601"},{"$f":"RIGHT(Plan!S2,5)","v":"32200"},4,{"$f":"Plan!S14","v":"CY"},{"$f":"Plan!S3","v":"ROCK CHANNEL PROTECTION, TYPE C WITH FILTER"},null,null,"601E32200",null,{"$f":"IF(P33=[4]SimpleForm!AC37,1,\"BAD\")","v":1},{"$f":"IF(Q33=[4]SimpleForm!AD37,1,\"BAD\")","v":1},{"$f":"IF(R33=[4]SimpleForm!AE37,1,\"BAD\")","v":1}]
[null,null,null,null,{"$f":"Earthwork!L15","v":189},null,null,null,null,null,null,null,{"$f":"SUM(A34:L34)","v":189},"659","00300",189,"CY","TOPSOIL",null,null,"659E00300",null,{"$f":"IF(P34=[4]SimpleForm!AC38,1,\"BAD\")","v":1},{"$f":"IF(Q34=[4]SimpleForm!AD38,1,\"BAD\")","v":1},{"$f":"IF(R34=[4]SimpleForm!AE38,1,\"BAD\")","v":1}]
[null,null,null,null,{"$f":"Earthwork!G47","v":1692},null,null,null,null,null,null,null,1692,"659","00530",1692,"SY","SEEDING AND MULCHING, CLASS 3B",null,null,"659E00530",null,{"$f":"IF(P35=[4]SimpleForm!AC39,1,\"BAD\")","v":1},{"$f":"IF(Q35=[4]SimpleForm!AD39,1,\"BAD\")","v":1},{"$f":"IF(R35=[4]SimpleForm!AE39,1,\"BAD\")","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(P36=[4]SimpleForm!AC40,1,\"BAD\")","v":1},{"$f":"IF(Q36=[4]SimpleForm!AD40,1,\"BAD\")","v":1},{"$f":"IF(R36=[4]SimpleForm!AE40,1,\"BAD\")","v":1}]
[null,null,null,null,{"$f":"Earthwork!S15","v":85},null,null,null,null,null,null,null,85,659,14000,85,"SY","REPAIR SEEDING AND MULCHING",null,null,"659E14000",null,{"$f":"IF(P37=[4]SimpleForm!AC41,1,\"BAD\")","v":1},{"$f":"IF(Q37=[4]SimpleForm!AD41,1,\"BAD\")","v":1},{"$f":"IF(R37=[4]SimpleForm!AE41,1,\"BAD\")","v":1}]
[null,null,null,null,{"$f":"Earthwork!S28","v":85},null,null,null,null,null,null,null,85,659,15000,85,"SY","INTER-SEEDING",null,null,"659E15000",null,{"$f":"IF(P38=[4]SimpleForm!AC42,1,\"BAD\")","v":1},{"$f":"IF(Q38=[4]SimpleForm!AD42,1,\"BAD\")","v":1},{"$f":"IF(R38=[4]SimpleForm!AE42,1,\"BAD\")","v":1}]
[null,null,null,null,{"$f":"Earthwork!M31","v":0.23},null,null,null,null,null,null,null,0.23,"659","20000",0.23,"TON","COMMERCIAL FERTILIZER",null,null,"659E20000",null,{"$f":"IF(P39=[4]SimpleForm!AC43,1,\"BAD\")","v":1},{"$f":"IF(Q39=[4]SimpleForm!AD43,1,\"BAD\")","v":1},{"$f":"IF(R39=[4]SimpleForm!AE43,1,\"BAD\")","v":1}]
[null,null,null,null,{"$f":"Earthwork!M45","v":0.35},null,null,null,null,null,null,null,0.35,"659","31000",0.35,"ACRE","LIME",null,null,"659E31000",null,{"$f":"IF(P40=[4]SimpleForm!AC44,1,\"BAD\")","v":1},{"$f":"IF(Q40=[4]SimpleForm!AD44,1,\"BAD\")","v":1},{"$f":"IF(R40=[4]SimpleForm!AE44,1,\"BAD\")","v":1}]
[null,null,null,null,{"$f":"Earthwork!S45","v":9.1199999999999992},null,null,null,null,null,null,null,9.1199999999999992,"659","35000",9.1199999999999992,"MGAL","WATER",null,null,"659E35000",null,{"$f":"IF(P41=[4]SimpleForm!AC45,1,\"BAD\")","v":1},{"$f":"IF(Q41=[4]SimpleForm!AD45,1,\"BAD\")","v":1},{"$f":"IF(R41=[4]SimpleForm!AE45,1,\"BAD\")","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(P42=[4]SimpleForm!AC46,1,\"BAD\")","v":1},{"$f":"IF(Q42=[4]SimpleForm!AD46,1,\"BAD\")","v":1},{"$f":"IF(R42=[4]SimpleForm!AE46,1,\"BAD\")","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,2500,832,"30000",{"$f":"M43","v":2500},"EACH","EROSION CONTROL",null,null,"832E30000",null,{"$f":"IF(P43=[4]SimpleForm!AC47,1,\"BAD\")","v":1},{"$f":"IF(Q43=[4]SimpleForm!AD47,1,\"BAD\")","v":1},{"$f":"IF(R43=[4]SimpleForm!AE47,1,\"BAD\")","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(P44=[4]SimpleForm!AC48,1,\"BAD\")","v":1},{"$f":"IF(Q44=[4]SimpleForm!AD48,1,\"BAD\")","v":1},{"$f":"IF(R44=[4]SimpleForm!AE48,1,\"BAD\")","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DRAINAGE",null,null,null,{"$f":"R45","v":"DRAINAGE"},{"$f":"IF(P45=[4]SimpleForm!AC49,1,\"BAD\")","v":1},{"$f":"IF(Q45=[4]SimpleForm!AD49,1,\"BAD\")","v":1},{"$f":"IF(R45=[4]SimpleForm!AE49,1,\"BAD\")","v":1}]
[null,null,null,null,null,null,{"$f":"'2062 Bridge'!B21","v":120},null,null,null,null,null,{"$f":"SUM(A46:L46)","v":120},{"$f":"LEFT('2062 Bridge'!A21,3)","v":"605"},{"$f":"RIGHT('2062 Bridge'!A21,5)","v":"11000"},{"$f":"M46","v":120},{"$f":"'2062 Bridge'!C21","v":"FT"},{"$f":"'2062 Bridge'!D21","v":"6\" CONSTRUCTION UNDERDRAINS"},null,null,{"$f":"N46&\"E\"&O46","v":"605E11000"},null,{"$f":"IF(P46=[4]SimpleForm!AC50,1,\"BAD\")","v":1},{"$f":"IF(Q46=[4]SimpleForm!AD50,1,\"BAD\")","v":1},{"$f":"IF(R46=[4]SimpleForm!AE50,1,\"BAD\")","v":1}]
[null,null,{"$f":"Pavement!S24","v":40},null,null,null,null,null,null,null,null,null,40,{"$f":"LEFT(Pavement!S2,3)","v":"605"},{"$f":"RIGHT(Pavement!S2,5)","v":"31100"},40,{"$f":"Pavement!S10","v":"FT"},{"$f":"Pavement!S3","v":"AGGREGATE DRAINS"},null,null,"605E31100",null,{"$f":"IF(P47=[4]SimpleForm!AC51,1,\"BAD\")","v":1},{"$f":"IF(Q47=[4]SimpleForm!AD51,1,\"BAD\")","v":1},{"$f":"IF(R47=[4]SimpleForm!AE51,1,\"BAD\")","v":1}]
[null,null,null,{"$f":"Plan!T28","v":37},null,null,null,null,null,null,null,null,37,{"$f":"LEFT(Plan!T2,3)","v":"611"},{"$f":"RIGHT(Plan!T2,5)","v":"04900"},37,{"$f":"Plan!T14","v":"FT"},{"$f":"Plan!T3","v":"12\" CONDUIT, TYPE D"},null,null,"611E04900",null,{"$f":"IF(P48=[4]SimpleForm!AC52,1,\"BAD\")","v":1},{"$f":"IF(Q48=[4]SimpleForm!AD52,1,\"BAD\")","v":1},{"$f":"IF(R48=[4]SimpleForm!AE52,1,\"BAD\")","v":1}]
[null,null,null,{"$f":"Plan!U28","v":23},null,null,null,null,null,null,null,null,23,{"$f":"LEFT(Plan!U2,3)","v":"611"},{"$f":"RIGHT(Plan!U2,5)","v":"16600"},23,{"$f":"Plan!U14","v":"FT"},{"$f":"Plan!U3","v":"36\" CONDUIT, TYPE C"},null,null,"611E16600",null,{"$f":"IF(P49=[4]SimpleForm!AC53,1,\"BAD\")","v":1},{"$f":"IF(Q49=[4]SimpleForm!AD53,1,\"BAD\")","v":1},{"$f":"IF(R49=[4]SimpleForm!AE53,1,\"BAD\")","v":1}]
[null,null,null,null,null,null,{"$f":"'2062 Bridge'!B22","v":42},null,null,null,null,null,42,{"$f":"LEFT('2062 Bridge'!A22,3)","v":"611"},{"$f":"RIGHT('2062 Bridge'!A22,5)","v":"96330"},42,{"$f":"'2062 Bridge'!C22","v":"FT"},{"$f":"'2062 Bridge'!D22","v":"14' X 8' CONDUIT, TYPE A, 706.05"},null,null,"611E96330",null,{"$f":"IF(P50=[4]SimpleForm!AC54,1,\"BAD\")","v":1},{"$f":"IF(Q50=[4]SimpleForm!AD54,1,\"BAD\")","v":1},{"$f":"IF(R50=[4]SimpleForm!AE54,1,\"BAD\")","v":1}]
[]
[null,null,null,null,null,{"$f":"'0811 Bridge'!B19","v":48},null,null,null,null,null,null,48,{"$f":"LEFT('0811 Bridge'!A19,3)","v":"611"},{"$f":"RIGHT('0811 Bridge'!A19,5)","v":"96470"},48,{"$f":"'0811 Bridge'!C19","v":"FT"},{"$f":"'0811 Bridge'!D19","v":"18' X 7' CONDUIT, TYPE A, 706.05"},null,null,"611E96470",null,{"$f":"IF(P52=[4]SimpleForm!AC56,1,\"BAD\")","v":1},{"$f":"IF(Q52=[4]SimpleForm!AD56,1,\"BAD\")","v":1},{"$f":"IF(R52=[4]SimpleForm!AE56,1,\"BAD\")","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(P53=[4]SimpleForm!AC57,1,\"BAD\")","v":1},{"$f":"IF(Q53=[4]SimpleForm!AD57,1,\"BAD\")","v":1},{"$f":"IF(R53=[4]SimpleForm!AE57,1,\"BAD\")","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PAVEMENT",null,null,null,{"$f":"R54","v":"PAVEMENT"},{"$f":"IF(P54=[4]SimpleForm!AC58,1,\"BAD\")","v":1},{"$f":"IF(Q54=[4]SimpleForm!AD58,1,\"BAD\")","v":1},{"$f":"IF(R54=[4]SimpleForm!AE58,1,\"BAD\")","v":1}]
[null,null,{"$f":"Pavement!M24","v":268},null,null,null,null,null,null,null,null,null,268,{"$f":"LEFT(Pavement!M2,3)","v":"254"},{"$f":"RIGHT(Pavement!M2,5)","v":"01000"},268,{"$f":"Pavement!M10","v":"SY"},{"$f":"Pavement!M3","v":"PAVEMENT PLANING, ASPHALT CONCRETE, 1.50\""},null,null,"254E01000",null,{"$f":"IF(P55=[4]SimpleForm!AC59,1,\"BAD\")","v":1},{"$f":"IF(Q55=[4]SimpleForm!AD59,1,\"BAD\")","v":1},{"$f":"IF(R55=[4]SimpleForm!AE59,1,\"BAD\")","v":1}]
[null,850,null,null,null,null,null,null,null,null,null,null,850,254,"01000",850,"SY","PAVEMENT PLANING, ASPHALT CONCRETE, VARIABLE DEPTH",null,null,"254E01000",null,{"$f":"IF(P56=[4]SimpleForm!AC60,1,\"BAD\")","v":1},{"$f":"IF(Q56=[4]SimpleForm!AD60,1,\"BAD\")","v":1},{"$f":"IF(R56=[4]SimpleForm!AE60,1,\"BAD\")","v":1}]
[null,null,{"$f":"Pavement!N24","v":103},null,null,null,null,null,null,null,null,null,103,{"$f":"LEFT(Pavement!N2,3)","v":"301"},{"$f":"RIGHT(Pavement!N2,5)","v":"56000"},103,{"$f":"Pavement!N10","v":"CY"},{"$f":"Pavement!N3","v":"ASPHALT CONCRETE BASE, PG64-22, (449)"},null,null,"301E56000",null,{"$f":"IF(P57=[4]SimpleForm!AC61,1,\"BAD\")","v":1},{"$f":"IF(Q57=[4]SimpleForm!AD61,1,\"BAD\")","v":1},{"$f":"IF(R57=[4]SimpleForm!AE61,1,\"BAD\")","v":1}]
[null,null,{"$f":"Pavement!O24","v":87},null,null,null,null,null,null,null,null,null,87,{"$f":"LEFT(Pavement!O2,3)","v":"304"},{"$f":"RIGHT(Pavement!O2,5)","v":"20000"},87,{"$f":"Pavement!O10","v":"CY"},{"$f":"Pavement!O3","v":"AGGREGATE BASE"},null,null,"304E20000",null,{"$f":"IF(P58=[4]SimpleForm!AC62,1,\"BAD\")","v":1},{"$f":"IF(Q58=[4]SimpleForm!AD62,1,\"BAD\")","v":1},{"$f":"IF(R58=[4]SimpleForm!AE62,1,\"BAD\")","v":1}]
[null,50,{"$f":"Pavement!Q24","v":85},null,null,null,null,null,null,null,null,null,135,{"$f":"LEFT(Pavement!Q2,3)","v":"407"},{"$f":"RIGHT(Pavement!Q2,5)","v":"20000"},135,{"$f":"Pavement!Q10","v":"GAL"},{"$f":"Pavement!Q3","v":"NON-TRACKING TACK COAT"},null,null,"407E20000",null,{"$f":"IF(P59=[4]SimpleForm!AC63,1,\"BAD\")","v":1},{"$f":"IF(Q59=[4]SimpleForm!AD63,1,\"BAD\")","v":1},{"$f":"IF(R59=[4]SimpleForm!AE63,1,\"BAD\")","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(P60=[4]SimpleForm!AC64,1,\"BAD\")","v":1},{"$f":"IF(Q60=[4]SimpleForm!AD64,1,\"BAD\")","v":1},{"$f":"IF(R60=[4]SimpleForm!AE64,1,\"BAD\")","v":1}]
[null,null,{"$f":"Pavement!R24","v":42},null,null,null,null,null,null,null,null,null,42,{"$f":"LEFT(Pavement!R2,3)","v":"441"},{"$f":"RIGHT(Pavement!R2,5)","v":"70000"},42,{"$f":"Pavement!R10","v":"CY"},{"$f":"Pavement!R3","v":"ASPHALT CONCRETE SURFACE COURSE, TYPE 1, (449), PG64-22"},null,null,"441E70000",null,{"$f":"IF(P61=[4]SimpleForm!AC65,1,\"BAD\")","v":1},{"$f":"IF(Q61=[4]SimpleForm!AD65,1,\"BAD\")","v":1},{"$f":"IF(R61=[4]SimpleForm!AE65,1,\"BAD\")","v":1}]
[null,10,null,null,null,null,null,null,null,null,null,null,10,{"$f":"LEFT(Plan!V2,3)","v":"617"},{"$f":"RIGHT(Plan!V2,5)","v":"10100"},10,"CY","COMPACTED AGGREGATE",null,null,"617E10100",null,{"$f":"IF(P62=[4]SimpleForm!AC66,1,\"BAD\")","v":1},{"$f":"IF(Q62=[4]SimpleForm!AD66,1,\"BAD\")","v":1},{"$f":"IF(R62=[4]SimpleForm!AE66,1,\"BAD\")","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(P63=[4]SimpleForm!AC67,1,\"BAD\")","v":1},{"$f":"IF(Q63=[4]SimpleForm!AD67,1,\"BAD\")","v":1},{"$f":"IF(R63=[4]SimpleForm!AE67,1,\"BAD\")","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TRAFFIC CONTROL",null,null,null,{"$f":"R64","v":"TRAFFIC CONTROL"},{"$f":"IF(P64=[4]SimpleForm!AC68,1,\"BAD\")","v":1},{"$f":"IF(Q64=[4]SimpleForm!AD68,1,\"BAD\")","v":1},{"$f":"IF(R64=[4]SimpleForm!AE68,1,\"BAD\")","v":1}]
[null,null,null,{"$f":"'Traffic Control'!F15","v":4},null,null,null,null,null,null,null,null,4,{"$f":"LEFT('Traffic Control'!F2,3)","v":"621"},{"$f":"RIGHT('Traffic Control'!F2,5)","v":"00100"},4,{"$f":"'Traffic Control'!F10","v":"EACH"},{"$f":"'Traffic Control'!F3","v":"RPM"},null,null,"621E00100",null,{"$f":"IF(P65=[4]SimpleForm!AC69,1,\"BAD\")","v":1},{"$f":"IF(Q65=[4]SimpleForm!AD69,1,\"BAD\")","v":1},{"$f":"IF(R65=[4]SimpleForm!AE69,1,\"BAD\")","v":1}]
[null,null,null,{"$f":"'Traffic Control'!G15","v":4},null,null,null,null,null,null,null,null,4,{"$f":"LEFT('Traffic Control'!G2,3)","v":"621"},{"$f":"RIGHT('Traffic Control'!G2,5)","v":"54000"},4,{"$f":"'Traffic Control'!G10","v":"EACH"},{"$f":"'Traffic Control'!G3","v":"RAISED PAVEMENT MARKER REMOVED"},null,null,"621E54000",null,{"$f":"IF(P66=[4]SimpleForm!AC70,1,\"BAD\")","v":1},{"$f":"IF(Q66=[4]SimpleForm!AD70,1,\"BAD\")","v":1},{"$f":"IF(R66=[4]SimpleForm!AE70,1,\"BAD\")","v":1}]
[null,null,null,{"$f":"Plan!W28","v":17},null,null,null,null,null,null,null,null,17,{"$f":"LEFT(Plan!W2,3)","v":"626"},{"$f":"RIGHT(Plan!W2,5)","v":"00110"},17,{"$f":"Plan!W14","v":"EACH"},{"$f":"Plan!W3","v":"BARRIER REFLECTOR, TYPE 2, BI-DIRECTIONAL"},null,null,"626E00110",null,{"$f":"IF(P67=[4]SimpleForm!AC71,1,\"BAD\")","v":1},{"$f":"IF(Q67=[4]SimpleForm!AD71,1,\"BAD\")","v":1},{"$f":"IF(R67=[4]SimpleForm!AE71,1,\"BAD\")","v":1}]
[null,0.2,null,null,null,null,null,null,null,null,null,null,0.2,642,"00100",0.2,"MILE","EDGE LINE, 4\", TYPE 1",null,null,"642E00100",null,{"$f":"IF(P68=[4]SimpleForm!AC72,1,\"BAD\")","v":1},{"$f":"IF(Q68=[4]SimpleForm!AD72,1,\"BAD\")","v":1},{"$f":"IF(R68=[4]SimpleForm!AE72,1,\"BAD\")","v":1}]
[null,null,null,{"$f":"'Traffic Control'!H15","v":0.08},null,null,null,null,null,null,null,null,0.08,{"$f":"LEFT('Traffic Control'!H2,3)","v":"642"},{"$f":"RIGHT('Traffic Control'!H2,5)","v":"00104"},0.08,{"$f":"'Traffic Control'!H10","v":"MILE"},{"$f":"'Traffic Control'!H3","v":"EDGE LINE, 6\", TYPE 1"},null,null,"642E00104",null,{"$f":"IF(P69=[4]SimpleForm!AC73,1,\"BAD\")","v":1},{"$f":"IF(Q69=[4]SimpleForm!AD73,1,\"BAD\")","v":1},{"$f":"IF(R69=[4]SimpleForm!AE73,1,\"BAD\")","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(P70=[4]SimpleForm!AC74,1,\"BAD\")","v":1},{"$f":"IF(Q70=[4]SimpleForm!AD74,1,\"BAD\")","v":1},{"$f":"IF(R70=[4]SimpleForm!AE74,1,\"BAD\")","v":1}]
[null,null,null,{"$f":"'Traffic Control'!I15","v":0.04},null,null,null,null,null,null,null,null,0.04,{"$f":"LEFT('Traffic Control'!I2,3)","v":"642"},{"$f":"RIGHT('Traffic Control'!I2,5)","v":"00300"},0.04,{"$f":"'Traffic Control'!I10","v":"MILE"},{"$f":"'Traffic Control'!I3","v":"CENTER LINE, TYPE 1"},null,null,"642E00300",null,{"$f":"IF(P71=[4]SimpleForm!AC75,1,\"BAD\")","v":1},{"$f":"IF(Q71=[4]SimpleForm!AD75,1,\"BAD\")","v":1},{"$f":"IF(R71=[4]SimpleForm!AE75,1,\"BAD\")","v":1}]

{"sheet":"GG002","index":8,"n_rows":52,"n_cols":25,"rows_kept":52,"cut":false,"hidden":false,"merged":[[7,22,7,24],[3,15,4,15],[3,16,4,16],[3,17,4,17],[0,0,1,11],[0,12,2,12],[3,0,4,11],[3,12,7,12],[3,13,4,13],[3,14,4,14]]}
[null,null,null,null,null,null,null,null,null,null,null,null,"PARTICIPATION"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SEE"]
["SHEET NUMBER",null,null,null,null,null,null,null,null,null,null,null,"01/STR/10","ITEM","ITEM","GRAND","UNIT","DESCRIPTION","SHEET"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NO."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EXT","TOTAL"]
[]
[{"$f":"'sht mgr'!I4","v":"P.3"},{"$f":"'sht mgr'!I5&\"-\"&'sht mgr'!I7","v":"P.4-P.6"},{"$f":"'sht mgr'!I13","v":"P.12"},{"$f":"'sht mgr'!I14","v":"P.13"},{"$f":"'sht mgr'!I15","v":"P.14"},{"$f":"'sht mgr'!I31","v":"P.30"},{"$f":"'sht mgr'!I39","v":"P.38"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CHECKS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STRUCTURE 20 FOOT SPAN AND UNDER (MRW-314-0811, SFN: 5903034)",null,null,null,{"$f":"R9","v":"STRUCTURE 20 FOOT SPAN AND UNDER (MRW-314-0811, SFN: 5903034)"},"QTY","UNIT","DESC"]
[null,null,null,null,null,{"$f":"'0811 Bridge'!B4","v":"LS"},null,null,null,null,null,null,{"$f":"F10","v":"LS"},{"$f":"LEFT('0811 Bridge'!A4,3)","v":"202"},{"$f":"RIGHT('0811 Bridge'!A4,5)","v":"11000"},{"$f":"M10","v":"LS"},null,{"$f":"'0811 Bridge'!D4","v":"STRUCTURE REMOVED"},null,null,{"$f":"N10&\"E\"&O10","v":"202E11000"},null,{"$f":"IF(P10=[4]SimpleForm!AC78,1,\"BAD\")","v":1},{"$f":"IF(Q10=[4]SimpleForm!AD78,1,\"BAD\")","v":1},{"$f":"IF(R10=[4]SimpleForm!AE78,1,\"BAD\")","v":1}]
[null,null,null,null,null,{"$f":"'0811 Bridge'!B5","v":"LS"},null,null,null,null,null,null,"LS",{"$f":"LEFT('0811 Bridge'!A5,3)","v":"503"},{"$f":"RIGHT('0811 Bridge'!A5,5)","v":"11100"},"LS",null,{"$f":"'0811 Bridge'!D5","v":"COFFERDAMS AND EXCAVATION BRACING"},null,null,"503E11100",null,{"$f":"IF(P11=[4]SimpleForm!AC79,1,\"BAD\")","v":1},{"$f":"IF(Q11=[4]SimpleForm!AD79,1,\"BAD\")","v":1},{"$f":"IF(R11=[4]SimpleForm!AE79,1,\"BAD\")","v":1}]
[null,null,null,null,null,{"$f":"'0811 Bridge'!B6","v":"LS"},null,null,null,null,null,null,"LS",{"$f":"LEFT('0811 Bridge'!A6,3)","v":"503"},{"$f":"RIGHT('0811 Bridge'!A6,5)","v":"21300"},"LS",null,{"$f":"'0811 Bridge'!D6","v":"UNCLASSIFIED EXCAVATION"},null,null,"503E21300",null,{"$f":"IF(P12=[4]SimpleForm!AC80,1,\"BAD\")","v":1},{"$f":"IF(Q12=[4]SimpleForm!AD80,1,\"BAD\")","v":1},{"$f":"IF(R12=[4]SimpleForm!AE80,1,\"BAD\")","v":1}]
[null,null,null,null,null,{"$f":"'0811 Bridge'!B7","v":4235},null,null,null,null,null,null,4235,{"$f":"LEFT('0811 Bridge'!A7,3)","v":"509"},{"$f":"RIGHT('0811 Bridge'!A7,5)","v":"10000"},4235,{"$f":"'0811 Bridge'!C7","v":"LB"},{"$f":"'0811 Bridge'!D7","v":"EPOXY COATED STEEL REINFORCEMENT"},null,null,"509E10000",null,{"$f":"IF(P13=[4]SimpleForm!AC81,1,\"BAD\")","v":1},{"$f":"IF(Q13=[4]SimpleForm!AD81,1,\"BAD\")","v":1},{"$f":"IF(R13=[4]SimpleForm!AE81,1,\"BAD\")","v":1}]
[null,null,null,null,null,{"$f":"'0811 Bridge'!B9","v":55},null,null,null,null,null,null,55,{"$f":"LEFT('0811 Bridge'!A9,3)","v":"511"},{"$f":"RIGHT('0811 Bridge'!A9,5)","v":"46510"},55,{"$f":"'0811 Bridge'!C9","v":"CY"},{"$f":"'0811 Bridge'!D9","v":"CLASS QC1 CONCRETE, FOOTING"},null,null,"511E46510",null,{"$f":"IF(P14=[4]SimpleForm!AC82,1,\"BAD\")","v":1},{"$f":"IF(Q14=[4]SimpleForm!AD82,1,\"BAD\")","v":1},{"$f":"IF(R14=[4]SimpleForm!AE82,1,\"BAD\")","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(P15=[4]SimpleForm!AC83,1,\"BAD\")","v":1},{"$f":"IF(Q15=[4]SimpleForm!AD83,1,\"BAD\")","v":1},{"$f":"IF(R15=[4]SimpleForm!AE83,1,\"BAD\")","v":1}]
[null,null,null,null,null,{"$f":"'0811 Bridge'!B10","v":1},null,null,null,null,null,null,1,{"$f":"LEFT('0811 Bridge'!A10,3)","v":"511"},{"$f":"RIGHT('0811 Bridge'!A10,5)","v":"46610"},1,{"$f":"'0811 Bridge'!C10","v":"CY"},{"$f":"'0811 Bridge'!D10","v":"CLASS QC1 CONCRETE, HEADWALL"},null,null,"511E46610",null,{"$f":"IF(P16=[4]SimpleForm!AC84,1,\"BAD\")","v":1},{"$f":"IF(Q16=[4]SimpleForm!AD84,1,\"BAD\")","v":1},{"$f":"IF(R16=[4]SimpleForm!AE84,1,\"BAD\")","v":1}]
[null,null,null,null,null,{"$f":"'0811 Bridge'!B11","v":94},null,null,null,null,null,null,94,{"$f":"LEFT('0811 Bridge'!A11,3)","v":"512"},{"$f":"RIGHT('0811 Bridge'!A11,5)","v":"10050"},94,{"$f":"'0811 Bridge'!C11","v":"SY"},{"$f":"'0811 Bridge'!D11","v":"SEALING OF CONCRETE SURFACES (NON-EPOXY)"},null,null,"512E10050",null,{"$f":"IF(P17=[4]SimpleForm!AC85,1,\"BAD\")","v":1},{"$f":"IF(Q17=[4]SimpleForm!AD85,1,\"BAD\")","v":1},{"$f":"IF(R17=[4]SimpleForm!AE85,1,\"BAD\")","v":1}]
[null,null,null,null,null,{"$f":"'0811 Bridge'!B12","v":112},null,null,null,null,null,null,112,{"$f":"LEFT('0811 Bridge'!A12,3)","v":"512"},{"$f":"RIGHT('0811 Bridge'!A12,5)","v":"33000"},112,{"$f":"'0811 Bridge'!C12","v":"SY"},{"$f":"'0811 Bridge'!D12","v":"TYPE 2 WATERPROOFING"},null,null,"512E33000",null,{"$f":"IF(P18=[4]SimpleForm!AC86,1,\"BAD\")","v":1},{"$f":"IF(Q18=[4]SimpleForm!AD86,1,\"BAD\")","v":1},{"$f":"IF(R18=[4]SimpleForm!AE86,1,\"BAD\")","v":1}]
[null,null,null,null,null,{"$f":"'0811 Bridge'!B13","v":115},null,null,null,null,null,null,115,{"$f":"LEFT('0811 Bridge'!A13,3)","v":"512"},{"$f":"RIGHT('0811 Bridge'!A13,5)","v":"33010"},115,{"$f":"'0811 Bridge'!C13","v":"SY"},{"$f":"'0811 Bridge'!D13","v":"TYPE 3 WATERPROOFING"},null,null,"512E33010",null,{"$f":"IF(P19=[4]SimpleForm!AC87,1,\"BAD\")","v":1},{"$f":"IF(Q19=[4]SimpleForm!AD87,1,\"BAD\")","v":1},{"$f":"IF(R19=[4]SimpleForm!AE87,1,\"BAD\")","v":1}]
[null,null,null,null,null,{"$f":"'0811 Bridge'!B15","v":42},null,null,null,null,null,null,42,{"$f":"LEFT('0811 Bridge'!A15,3)","v":"516"},{"$f":"RIGHT('0811 Bridge'!A15,5)","v":"13601"},42,{"$f":"'0811 Bridge'!C15","v":"SF"},{"$f":"'0811 Bridge'!D15","v":"1\" PREFORMED EXPANSION JOINT FILLER, AS PER PLAN"},{"$f":"'sht mgr'!I30","v":"P.29"},null,"516E13601",null,{"$f":"IF(P20=[4]SimpleForm!AC88,1,\"BAD\")","v":1},{"$f":"IF(Q20=[4]SimpleForm!AD88,1,\"BAD\")","v":1},{"$f":"IF(R20=[4]SimpleForm!AE88,1,\"BAD\")","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(P21=[4]SimpleForm!AC89,1,\"BAD\")","v":1},{"$f":"IF(Q21=[4]SimpleForm!AD89,1,\"BAD\")","v":1},{"$f":"IF(R21=[4]SimpleForm!AE89,1,\"BAD\")","v":1}]
[null,null,null,null,null,{"$f":"'0811 Bridge'!B16","v":29},null,null,null,null,null,null,29,{"$f":"LEFT('0811 Bridge'!A16,3)","v":"518"},{"$f":"RIGHT('0811 Bridge'!A16,5)","v":"21200"},29,{"$f":"'0811 Bridge'!C16","v":"CY"},{"$f":"'0811 Bridge'!D16","v":"POROUS BACKFILL WITH GEOTEXTILE FABRIC"},null,null,"518E21200",null,{"$f":"IF(P22=[4]SimpleForm!AC90,1,\"BAD\")","v":1},{"$f":"IF(Q22=[4]SimpleForm!AD90,1,\"BAD\")","v":1},{"$f":"IF(R22=[4]SimpleForm!AE90,1,\"BAD\")","v":1}]
[null,null,null,null,null,{"$f":"'0811 Bridge'!B21","v":564},null,null,null,null,null,null,564,{"$f":"LEFT('0811 Bridge'!A21,3)","v":"851"},{"$f":"RIGHT('0811 Bridge'!A21,5)","v":"10000"},564,{"$f":"'0811 Bridge'!C21","v":"SF"},{"$f":"'0811 Bridge'!D21","v":"PRECAST GRAVITY AND SEMIGRAVITY RETAINING WALL"},null,null,"851E10000",null,{"$f":"IF(P23=[4]SimpleForm!AC91,1,\"BAD\")","v":1},{"$f":"IF(Q23=[4]SimpleForm!AD91,1,\"BAD\")","v":1},{"$f":"IF(R23=[4]SimpleForm!AE91,1,\"BAD\")","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(P24=[4]SimpleForm!AC92,1,\"BAD\")","v":1},{"$f":"IF(Q24=[4]SimpleForm!AD92,1,\"BAD\")","v":1},{"$f":"IF(R24=[4]SimpleForm!AE92,1,\"BAD\")","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STRUCTURE 20 FOOT SPAN AND UNDER (MRW-314-2062, SFN: 5903395)",null,null,null,{"$f":"R25","v":"STRUCTURE 20 FOOT SPAN AND UNDER (MRW-314-2062, SFN: 5903395)"},{"$f":"IF(P25=[4]SimpleForm!AC93,1,\"BAD\")","v":1},{"$f":"IF(Q25=[4]SimpleForm!AD93,1,\"BAD\")","v":1},{"$f":"IF(R25=[4]SimpleForm!AE93,1,\"BAD\")","v":1}]
[null,null,null,null,null,null,{"$f":"'2062 Bridge'!B4","v":"LS"},null,null,null,null,null,{"$f":"G26","v":"LS"},{"$f":"LEFT('2062 Bridge'!A4,3)","v":"202"},{"$f":"RIGHT('2062 Bridge'!A4,5)","v":"11000"},{"$f":"M26","v":"LS"},null,{"$f":"'2062 Bridge'!D4","v":"STRUCTURE REMOVED"},null,null,"202E11000",null,{"$f":"IF(P26=[4]SimpleForm!AC94,1,\"BAD\")","v":1},{"$f":"IF(Q26=[4]SimpleForm!AD94,1,\"BAD\")","v":1},{"$f":"IF(R26=[4]SimpleForm!AE94,1,\"BAD\")","v":1}]
[null,null,null,null,null,null,{"$f":"'2062 Bridge'!B5","v":"LS"},null,null,null,null,null,"LS",{"$f":"LEFT('2062 Bridge'!A5,3)","v":"503"},{"$f":"RIGHT('2062 Bridge'!A5,5)","v":"11100"},"LS",null,{"$f":"'2062 Bridge'!D5","v":"COFFERDAMS AND EXCAVATION BRACING"},null,null,"503E11100",null,{"$f":"IF(P27=[4]SimpleForm!AC95,1,\"BAD\")","v":1},{"$f":"IF(Q27=[4]SimpleForm!AD95,1,\"BAD\")","v":1},{"$f":"IF(R27=[4]SimpleForm!AE95,1,\"BAD\")","v":1}]
[null,null,null,null,null,null,{"$f":"'2062 Bridge'!B6","v":"LS"},null,null,null,null,null,"LS",{"$f":"LEFT('2062 Bridge'!A6,3)","v":"503"},{"$f":"RIGHT('2062 Bridge'!A6,5)","v":"21300"},"LS",null,{"$f":"'2062 Bridge'!D6","v":"UNCLASSIFIED EXCAVATION"},null,null,"503E21300",null,{"$f":"IF(P28=[4]SimpleForm!AC96,1,\"BAD\")","v":1},{"$f":"IF(Q28=[4]SimpleForm!AD96,1,\"BAD\")","v":1},{"$f":"IF(R28=[4]SimpleForm!AE96,1,\"BAD\")","v":1}]
[null,null,null,null,null,null,{"$f":"'2062 Bridge'!B7","v":60},null,null,null,null,null,60,{"$f":"LEFT('2062 Bridge'!A7,3)","v":"503"},{"$f":"RIGHT('2062 Bridge'!A7,5)","v":"21101"},60,{"$f":"'2062 Bridge'!C7","v":"CY"},{"$f":"'2062 Bridge'!D7","v":"UNCLASSIFIED EXCAVATION, AS PER PLAN"},{"$f":"'sht mgr'!I38","v":"P.37"},null,"503E21101",null,{"$f":"IF(P29=[4]SimpleForm!AC97,1,\"BAD\")","v":1},{"$f":"IF(Q29=[4]SimpleForm!AD97,1,\"BAD\")","v":1},{"$f":"IF(R29=[4]SimpleForm!AE97,1,\"BAD\")","v":1}]
[null,null,null,null,null,null,{"$f":"'2062 Bridge'!B9","v":5176},null,null,null,null,null,5176,{"$f":"LEFT('2062 Bridge'!A9,3)","v":"509"},{"$f":"RIGHT('2062 Bridge'!A9,5)","v":"10000"},5176,{"$f":"'2062 Bridge'!C9","v":"LB"},{"$f":"'2062 Bridge'!D9","v":"EPOXY COATED STEEL REINFORCEMENT"},null,null,"509E10000",null,{"$f":"IF(P30=[4]SimpleForm!AC98,1,\"BAD\")","v":1},{"$f":"IF(Q30=[4]SimpleForm!AD98,1,\"BAD\")","v":1},{"$f":"IF(R30=[4]SimpleForm!AE98,1,\"BAD\")","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(P31=[4]SimpleForm!AC99,1,\"BAD\")","v":1},{"$f":"IF(Q31=[4]SimpleForm!AD99,1,\"BAD\")","v":1},{"$f":"IF(R31=[4]SimpleForm!AE99,1,\"BAD\")","v":1}]
[null,null,null,null,null,null,{"$f":"'2062 Bridge'!B10","v":82},null,null,null,null,null,82,{"$f":"LEFT('2062 Bridge'!A10,3)","v":"511"},{"$f":"RIGHT('2062 Bridge'!A10,5)","v":"46510"},82,{"$f":"'2062 Bridge'!C10","v":"CY"},{"$f":"'2062 Bridge'!D10","v":"CLASS QC1 CONCRETE, FOOTING"},null,null,"511E46510",null,{"$f":"IF(P32=[4]SimpleForm!AC100,1,\"BAD\")","v":1},{"$f":"IF(Q32=[4]SimpleForm!AD100,1,\"BAD\")","v":1},{"$f":"IF(R32=[4]SimpleForm!AE100,1,\"BAD\")","v":1}]
[null,null,null,null,null,null,{"$f":"'2062 Bridge'!B11","v":1},null,null,null,null,null,1,{"$f":"LEFT('2062 Bridge'!A11,3)","v":"511"},{"$f":"RIGHT('2062 Bridge'!A11,5)","v":"46610"},1,{"$f":"'2062 Bridge'!C11","v":"CY"},{"$f":"'2062 Bridge'!D11","v":"CLASS QC1 CONCRETE, HEADWALL"},null,null,"511E46610",null,{"$f":"IF(P33=[4]SimpleForm!AC101,1,\"BAD\")","v":1},{"$f":"IF(Q33=[4]SimpleForm!AD101,1,\"BAD\")","v":1},{"$f":"IF(R33=[4]SimpleForm!AE101,1,\"BAD\")","v":1}]
[null,null,null,null,null,null,{"$f":"'2062 Bridge'!B12","v":89},null,null,null,null,null,89,{"$f":"LEFT('2062 Bridge'!A12,3)","v":"512"},{"$f":"RIGHT('2062 Bridge'!A12,5)","v":"10050"},89,{"$f":"'2062 Bridge'!C12","v":"SY"},{"$f":"'2062 Bridge'!D12","v":"SEALING OF CONCRETE SURFACES (NON-EPOXY)"},null,null,"512E10050",null,{"$f":"IF(P34=[4]SimpleForm!AC102,1,\"BAD\")","v":1},{"$f":"IF(Q34=[4]SimpleForm!AD102,1,\"BAD\")","v":1},{"$f":"IF(R34=[4]SimpleForm!AE102,1,\"BAD\")","v":1}]
[null,null,null,null,null,null,{"$f":"'2062 Bridge'!B13","v":101},null,null,null,null,null,101,{"$f":"LEFT('2062 Bridge'!A13,3)","v":"512"},{"$f":"RIGHT('2062 Bridge'!A13,5)","v":"33000"},101,{"$f":"'2062 Bridge'!C13","v":"SY"},{"$f":"'2062 Bridge'!D13","v":"TYPE 2 WATERPROOFING"},null,null,"512E33000",null,{"$f":"IF(P35=[4]SimpleForm!AC103,1,\"BAD\")","v":1},{"$f":"IF(Q35=[4]SimpleForm!AD103,1,\"BAD\")","v":1},{"$f":"IF(R35=[4]SimpleForm!AE103,1,\"BAD\")","v":1}]
[null,null,null,null,null,null,{"$f":"'2062 Bridge'!B15","v":81},null,null,null,null,null,81,{"$f":"LEFT('2062 Bridge'!A15,3)","v":"512"},{"$f":"RIGHT('2062 Bridge'!A15,5)","v":"33010"},81,{"$f":"'2062 Bridge'!C15","v":"SY"},{"$f":"'2062 Bridge'!D15","v":"TYPE 3 WATERPROOFING"},null,null,"512E33010",null,{"$f":"IF(P36=[4]SimpleForm!AC104,1,\"BAD\")","v":1},{"$f":"IF(Q36=[4]SimpleForm!AD104,1,\"BAD\")","v":1},{"$f":"IF(R36=[4]SimpleForm!AE104,1,\"BAD\")","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(P37=[4]SimpleForm!AC105,1,\"BAD\")","v":1},{"$f":"IF(Q37=[4]SimpleForm!AD105,1,\"BAD\")","v":1},{"$f":"IF(R37=[4]SimpleForm!AE105,1,\"BAD\")","v":1}]
[null,null,null,null,null,null,{"$f":"'2062 Bridge'!B16","v":53},null,null,null,null,null,53,{"$f":"LEFT('2062 Bridge'!A16,3)","v":"516"},{"$f":"RIGHT('2062 Bridge'!A16,5)","v":"13601"},53,{"$f":"'2062 Bridge'!C16","v":"SF"},{"$f":"'2062 Bridge'!D16","v":"1\" PREFORMED EXPANSION JOINT FILLER, AS PER PLAN"},{"$f":"'sht mgr'!I38","v":"P.37"},null,"516E13601",null,{"$f":"IF(P38=[4]SimpleForm!AC106,1,\"BAD\")","v":1},{"$f":"IF(Q38=[4]SimpleForm!AD106,1,\"BAD\")","v":1},{"$f":"IF(R38=[4]SimpleForm!AE106,1,\"BAD\")","v":1}]
[null,null,null,null,null,null,{"$f":"'2062 Bridge'!B17","v":53},null,null,null,null,null,53,{"$f":"LEFT('2062 Bridge'!A17,3)","v":"518"},{"$f":"RIGHT('2062 Bridge'!A17,5)","v":"21200"},53,{"$f":"'2062 Bridge'!C17","v":"CY"},{"$f":"'2062 Bridge'!D17","v":"POROUS BACKFILL WITH GEOTEXTILE FABRIC"},null,null,"518E21200",null,{"$f":"IF(P39=[4]SimpleForm!AC107,1,\"BAD\")","v":1},{"$f":"IF(Q39=[4]SimpleForm!AD107,1,\"BAD\")","v":1},{"$f":"IF(R39=[4]SimpleForm!AE107,1,\"BAD\")","v":1}]
[null,null,null,null,null,null,{"$f":"'2062 Bridge'!B23","v":802},null,null,null,null,null,802,{"$f":"LEFT('2062 Bridge'!A23,3)","v":"851"},{"$f":"RIGHT('2062 Bridge'!A23,5)","v":"10000"},802,{"$f":"'2062 Bridge'!C23","v":"SF"},{"$f":"'2062 Bridge'!D23","v":"PRECAST GRAVITY AND SEMIGRAVITY RETAINING WALL"},null,null,"851E10000",null,{"$f":"IF(P40=[4]SimpleForm!AC108,1,\"BAD\")","v":1},{"$f":"IF(Q40=[4]SimpleForm!AD108,1,\"BAD\")","v":1},{"$f":"IF(R40=[4]SimpleForm!AE108,1,\"BAD\")","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(P41=[4]SimpleForm!AC109,1,\"BAD\")","v":1},{"$f":"IF(Q41=[4]SimpleForm!AD109,1,\"BAD\")","v":1},{"$f":"IF(R41=[4]SimpleForm!AE109,1,\"BAD\")","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MAINTENANCE OF TRAFFIC",null,null,null,{"$f":"R42","v":"MAINTENANCE OF TRAFFIC"},{"$f":"IF(P42=[4]SimpleForm!AC110,1,\"BAD\")","v":1},{"$f":"IF(Q42=[4]SimpleForm!AD110,1,\"BAD\")","v":1},{"$f":"IF(R42=[4]SimpleForm!AE110,1,\"BAD\")","v":1}]
[null,48,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(A43:L43)","v":48},614,11110,{"$f":"M43","v":48},"HOUR","LAW ENFORCEMENT OFFICER WITH PATROL CAR FOR ASSISTANCE",null,null,"614E11110",null,{"$f":"IF(P43=[4]SimpleForm!AC111,1,\"BAD\")","v":1},{"$f":"IF(Q43=[4]SimpleForm!AD111,1,\"BAD\")","v":1},{"$f":"IF(R43=[4]SimpleForm!AE111,1,\"BAD\")","v":1}]
[null,"LS",null,null,null,null,null,null,null,null,null,null,{"$f":"B44","v":"LS"},614,12420,{"$f":"M44","v":"LS"},null,"DETOUR SIGNING",null,null,"614E12420",null,{"$f":"IF(P44=[4]SimpleForm!AC112,1,\"BAD\")","v":1},{"$f":"IF(Q44=[4]SimpleForm!AD112,1,\"BAD\")","v":1},{"$f":"IF(R44=[4]SimpleForm!AE112,1,\"BAD\")","v":1}]
[null,70,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(A45:L45)","v":70},614,13000,{"$f":"M45","v":70},"CY","ASPHALT CONCRETE FOR MAINTAINING TRAFFIC",null,null,"614E13000",null,{"$f":"IF(P45=[4]SimpleForm!AC113,1,\"BAD\")","v":1},{"$f":"IF(Q45=[4]SimpleForm!AD113,1,\"BAD\")","v":1},{"$f":"IF(R45=[4]SimpleForm!AE113,1,\"BAD\")","v":1}]
[null,6,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(A46:L46)","v":6},614,18600,{"$f":"M46","v":6},"SNMT","PORTABLE CHANGEABLE MESSAGE SIGN",null,null,"614E18600",null,{"$f":"IF(P46=[4]SimpleForm!AC114,1,\"BAD\")","v":1},{"$f":"IF(Q46=[4]SimpleForm!AD114,1,\"BAD\")","v":1},{"$f":"IF(R46=[4]SimpleForm!AE114,1,\"BAD\")","v":1}]
[null,2,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(A47:L47)","v":2},616,10000,{"$f":"M47","v":2},"MGAL","WATER",null,null,"616E10000",null,{"$f":"IF(P47=[4]SimpleForm!AC115,1,\"BAD\")","v":1},{"$f":"IF(Q47=[4]SimpleForm!AD115,1,\"BAD\")","v":1},{"$f":"IF(R47=[4]SimpleForm!AE115,1,\"BAD\")","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(P48=[4]SimpleForm!AC116,1,\"BAD\")","v":1},{"$f":"IF(Q48=[4]SimpleForm!AD116,1,\"BAD\")","v":1},{"$f":"IF(R48=[4]SimpleForm!AE116,1,\"BAD\")","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"INCIDENTALS",null,null,null,{"$f":"R49","v":"INCIDENTALS"},{"$f":"IF(P49=[4]SimpleForm!AC117,1,\"BAD\")","v":1},{"$f":"IF(Q49=[4]SimpleForm!AD117,1,\"BAD\")","v":1},{"$f":"IF(R49=[4]SimpleForm!AE117,1,\"BAD\")","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,"LS",614,11000,"LS",null,"MAINTAINING TRAFFIC",null,null,"614E11000",null,{"$f":"IF(P50=[4]SimpleForm!AC118,1,\"BAD\")","v":1},{"$f":"IF(Q50=[4]SimpleForm!AD118,1,\"BAD\")","v":1},{"$f":"IF(R50=[4]SimpleForm!AE118,1,\"BAD\")","v":1}]
["LS",null,null,null,null,null,null,null,null,null,null,null,"LS",623,10000,"LS",null,"CONSTRUCTION LAYOUT STAKES AND SURVEYING",null,null,"623E10000",null,{"$f":"IF(P51=[4]SimpleForm!AC119,1,\"BAD\")","v":1},{"$f":"IF(Q51=[4]SimpleForm!AD119,1,\"BAD\")","v":1},{"$f":"IF(R51=[4]SimpleForm!AE119,1,\"BAD\")","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,"LS",624,10000,"LS",null,"MOBILIZATION",null,null,"624E10000",null,{"$f":"IF(P52=[4]SimpleForm!AC120,1,\"BAD\")","v":1},{"$f":"IF(Q52=[4]SimpleForm!AD120,1,\"BAD\")","v":1},{"$f":"IF(R52=[4]SimpleForm!AE120,1,\"BAD\")","v":1}]

{"sheet":"Pavement","index":9,"n_rows":24,"n_cols":19,"rows_kept":24,"cut":false,"hidden":false,"merged":[[23,14,23,15],[0,9,0,18],[2,14,4,15],[5,15,8,15],[5,14,8,14],[0,0,0,2],[1,0,9,0],[23,0,23,8],[2,18,8,18],[1,1,9,1],[1,2,9,2],[2,13,8,13],[0,3,0,8],[2,7,8,7],[21,3,21,7],[1,3,9,3],[2,10,8,10],[1,4,8,4],[15,3,15,7],[2,17,8,17],[1,5,1,7],[1,8,8,8],[2,9,8,9],[2,11,8,11],[2,16,8,16],[2,5,8,5],[2,6,8,6],[2,12,8,12],[1,14,1,15]]}
["LOCATION",null,null,"DESIGN",null,null,null,null,null,"QUANTITIES"]
["LOCATION","BEGIN STA","END STA","SECTION","LENGTH","AVG. WIDTH",null,null,"TOTAL \nPAVEMENT AREA","202E23000","203E10000","204E10000","254E01000","301E56000","304E20000",null,"407E20000","441E70000","605E31100"]
[null,null,null,null,null,"LEFT SHOULDER","LANES","RIGHT SHOULDER",null,"PAVEMENT REMOVED","EXCAVATION","SUBGRADE COMPACTION","PAVEMENT PLANING, ASPHALT CONCRETE, 1.50\"","ASPHALT CONCRETE BASE, PG64-22, (449)","AGGREGATE BASE",null,"NON-TRACKING TACK COAT","ASPHALT CONCRETE SURFACE COURSE, TYPE 1, (449), PG64-22","AGGREGATE DRAINS"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PAVEMENT BASE (8\" OVER STRUC., 6\" OTHERWISE)","AGG. SHLDR (2.76 SF/LF EACH SIDE)"]
[]
[]
[]
[null,null,null,null,"FT","FT","FT","FT","SY","SY","CY","SY","SY","CY","CY","CY","GAL","CY","FT"]
[]
[1,{"$f":"GY!B10","v":245},{"$f":"GY!D10","v":270},2,{"$f":"ROUND(C12-B12,0)","v":25},1,22,1,{"$f":"ROUND(SUM(F12:H12)*E12/9,0)","v":67},null,null,null,{"$f":"I12","v":67},null,null,null,{"$f":"ROUNDUP(0.085*M12,0)","v":6},{"$f":"ROUNDUP(1.5/12/3*M12,0)","v":3}]
[1,{"$f":"GY!B4","v":270},{"$f":"GY!D4","v":341},1,{"$f":"ROUND(C13-B13,0)","v":71},1,22,1,{"$f":"ROUND(SUM(F13:H13)*E13/9,0)","v":189},{"$f":"I13","v":189},{"$f":"O13+P13","v":47},{"$f":"I13+ROUNDUP(16/12/3*E13/3*2,0)","v":211},null,{"$f":"ROUNDUP(0.4167/3*25/3*E13/3,0)+ROUNDUP(0.4167/3*24.67/3*E13/3,0)","v":56},{"$f":"ROUNDUP(0.5/3*26.67/3*(E13-16)/3,0)+ROUNDUP(0.67/3*26.67/3*16/3,0)","v":39},{"$f":"ROUNDUP(2.76/9*E13/3,0)","v":8},{"$f":"ROUNDUP(0.055*I13,0)*2+ROUNDUP(0.055*(24.67*E13/9),0)","v":33},{"$f":"ROUNDUP(3/12/3*I13,0)","v":16},20]
[1,{"$f":"GY!B11","v":341},{"$f":"GY!D11","v":366},2,25,1,22,1,{"$f":"ROUND(SUM(F14:H14)*E14/9,0)","v":67},null,null,null,{"$f":"I14","v":67},null,null,null,{"$f":"ROUNDUP(0.085*M14,0)","v":6},{"$f":"ROUNDUP(1.5/12/3*M14,0)","v":3}]
[]
[1,450,null,"PROP. FIELD DRIVE",null,null,null,null,73]
[]
[2,{"$f":"GY!B13","v":1165},{"$f":"GY!D13","v":1190},2,{"$f":"ROUND(C18-B18,0)","v":25},1,22,1,{"$f":"ROUND(SUM(F18:H18)*E18/9,0)","v":67},null,null,null,{"$f":"I18","v":67},null,null,null,{"$f":"ROUNDUP(0.085*M18,0)","v":6},{"$f":"ROUNDUP(1.5/12/3*M18,0)","v":3}]
[2,{"$f":"GY!B6","v":1190},{"$f":"GY!D6","v":1250},1,{"$f":"ROUND(C19-B19,0)","v":60},1,22,1,{"$f":"ROUND(SUM(F19:H19)*E19/9,0)","v":160},{"$f":"I19","v":160},{"$f":"O19+P19","v":40},{"$f":"I19+ROUNDUP(16/12/3*E19/3*2,0)","v":178},null,{"$f":"ROUNDUP(0.4167/3*25/3*E19/3,0)+ROUNDUP(0.4167/3*24.67/3*E19/3,0)","v":47},{"$f":"ROUNDUP(0.5/3*26.67/3*(E19-14)/3,0)+ROUNDUP(0.67/3*26.67/3*14/3,0)","v":33},{"$f":"ROUNDUP(2.76/9*E19/3,0)","v":7},{"$f":"ROUNDUP(0.055*I19,0)*2+ROUNDUP(0.055*(24.67*E19/9),0)","v":28},{"$f":"ROUNDUP(3/12/3*I19,0)","v":14},20]
[2,{"$f":"GY!B14","v":1250},{"$f":"GY!D14","v":1275},2,25,1,22,1,{"$f":"ROUND(SUM(F20:H20)*E20/9,0)","v":67},null,null,null,{"$f":"I20","v":67},null,null,null,{"$f":"ROUNDUP(0.085*M20,0)","v":6},{"$f":"ROUNDUP(1.5/12/3*M20,0)","v":3}]
[]
[2,1138.5,1177.3,"PROP. FIELD DRIVE",null,null,null,null,27]
[]
["TOTALS CARRIED TO GENERAL SUMMARY",null,null,null,null,null,null,null,null,{"$f":"SUM(J11:J23)","v":349},87,389,268,103,{"$f":"SUM(O11:O23,P11:P23)","v":87},null,85,42,40]

{"sheet":"Plan","index":10,"n_rows":28,"n_cols":27,"rows_kept":28,"cut":false,"hidden":false,"merged":[[2,18,12,18],[27,1,27,6],[1,2,13,2],[2,12,12,12],[2,14,12,14],[2,13,12,13],[2,8,12,8],[2,9,12,9],[0,1,0,6],[0,7,0,23],[1,1,13,1],[1,3,13,3],[1,4,13,4],[1,5,13,5],[1,6,13,6],[2,7,12,7],[2,10,12,10],[2,11,12,11],[2,15,12,15],[2,21,12,21],[2,22,12,22],[2,16,12,16],[2,20,12,20],[2,19,12,19]]}
[null,"LOCATION",null,null,null,null,null,"QUANTITIES"]
[null,"SHEET","LOCATION","REF","BEGIN STA.","END STA.","SIDE",null,"202E35200","202E75000","202E38001","202E42001","606E15050","606E15150","606E15300","606E26151","606E26550",null,"601E32200","611E04900","611E16600","617E10100","626E00110"]
[null,null,null,null,null,null,null,null,"PIPE REMOVED, OVER 24\"","FENCE REMOVED","GUARDRAIL REMOVED, AS PER PLAN","ANCHOR ASSEMBLY REMOVED, TYPE A, AS PER PLAN","GUARDRAIL, TYPE MGS","GUARDRAIL, TYPE MGS HALF POST SPACING","GUARDRAIL, TYPE MGS QUARTER POST SPACING WITH LONG POSTS","ANCHOR ASSEMBLY, MGS TYPE E, AS PER PLAN (MASH2016)","ANCHOR ASSEMBLY, MGS TYPE T",null,"ROCK CHANNEL PROTECTION, TYPE C WITH FILTER","12\" CONDUIT, TYPE D","36\" CONDUIT, TYPE C","COMPACTED AGGREGATE \n(3\" LIFT x 1' WIDE FOR BERM REPLACEMENT)","BARRIER REFLECTOR, TYPE 2, BI-DIRECTIONAL"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"FT","FT","FT","EACH","FT","FT","FT","EACH","EACH",null,"CY","FT","FT","CY","EACH",null,null,"LON DOWN","LON UP"]
[]
[null,{"$f":"'sht mgr'!I16","v":"P.15"},1,"GR-1",114.2,412.3,"RT",null,null,null,100,2,187.5,null,null,2,null,null,null,null,null,{"$f":"ROUNDUP(3/12/3*((F16-E16)-Pavement!E13)/3*1/3,0)","v":3},{"$f":"ROUNDUP((M16++O16+52*P16)/100,0)+1","v":4},null,null,133.31,396.09]
[null,{"$f":"B16","v":"P.15"},1,"GR-2",190.2,474.6,"LT",null,null,null,100,2,{"$f":"25+25+100","v":150},25,null,2,null,null,null,null,null,{"$f":"ROUNDUP(3/12/3*((F17-E17)-Pavement!E13)/3*1/3,0)","v":2},{"$f":"ROUNDUP((M17++O17+52*P17)/100,0)+1","v":4},null,null,219.45,453.01]
[]
[null,{"$f":"B16","v":"P.15"},1,"DR-1",433.73,470.71,"RT",null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(2*52.7/27,0)","v":4},37]
[]
[null,{"$f":"'sht mgr'!I17","v":"P.16"},2,"GR-3",1014.4,1349.2,"RT",null,null,null,50,1,{"$f":"162.5+37.5","v":200},null,25,2,null,null,null,null,null,{"$f":"ROUNDUP(3/12/3*((F21-E21)-Pavement!E19)/3*1/3,0)","v":3},{"$f":"ROUNDUP((M21++O21+52*P21)/100,0)+1","v":5},null,null,1039.5,1332.2]
[null,{"$f":"B21","v":"P.16"},2,"GR-4",1171.8,1403.9,"LT",null,null,null,50,1,200,null,18.75,null,2,null,null,null,null,{"$f":"ROUNDUP(3/12/3*((F22-E22)-Pavement!E20)/3*1/3,0)","v":2},{"$f":"ROUNDUP((M22+12.5*Q22)/100,0)+1","v":4},null,null,1173.5999999999999,1400.5]
[]
[null,{"$f":"B21","v":"P.16"},2,"DR-2",1179.3,1202,"LT",null,5,null,null,null,null,null,null,null,null,null,null,null,23]
[]
[null,{"$f":"B24","v":"P.16"},2,"F-1",1062,null,"RT",null,null,24]
[]
[null,"TOTALS CARRIED TO GENERAL SUMMARY ",null,null,null,null,null,null,{"$f":"SUM(I15:I27)","v":5},24,{"$f":"SUM(K15:K27)","v":300},6,737.5,25,43.75,6,{"$f":"SUM(Q15:Q27)","v":2},null,{"$f":"SUM(S15:S27)","v":4},37,23,10,{"$f":"SUM(W15:W27)","v":17}]

{"sheet":"Traffic Control","index":11,"n_rows":15,"n_cols":11,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,9,8,9],[1,10,9,10],[14,0,14,4],[0,0,0,4],[0,7,0,9],[1,0,9,0],[1,1,9,1],[1,2,9,2],[1,3,8,3],[1,4,8,4],[0,5,0,6],[2,7,7,7],[2,8,8,8],[2,6,8,6],[2,5,8,5]]}
["LOCATION",null,null,null,null,"ITEM 621 - RPM",null,"ITEM 642 - TRAFFIC PAINT",null,null,"REMARKS"]
["LOCATION","BEGINS STA.","END STA.","LENGTH","LENGTH","621E00100","621E54000","642E00104","642E00300"]
[null,null,null,null,null,"RPM","RAISED PAVEMENT MARKER REMOVED","EDGE LINE, 6\", TYPE 1","CENTER LINE, TYPE 1"]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"WHITE"]
[null,null,null,"MI","FT","EACH","EACH","MILE","MILE"]
[]
[1,{"$f":"Pavement!B12","v":245},{"$f":"Pavement!C14","v":366},{"$f":"ROUND(E12/5280,2)","v":0.02},{"$f":"ROUND(C12-B12,0)","v":121},2,2,{"$f":"D12*2","v":0.04},{"$f":"D12","v":0.02}]
[2,{"$f":"Pavement!B18","v":1165},{"$f":"Pavement!C20","v":1275},{"$f":"ROUND(E13/5280,2)","v":0.02},{"$f":"ROUND(C13-B13,0)","v":110},2,2,{"$f":"D13*2","v":0.04},{"$f":"D13","v":0.02}]
[]
["TOTALS CARRIED TO THE GENERAL SUMMARY",null,null,null,null,{"$f":"SUM(F11:F14)","v":4},{"$f":"SUM(G11:G14)","v":4},{"$f":"SUM(H11:H14)","v":0.08},{"$f":"SUM(I11:I14)","v":0.04}]

{"sheet":"Earthwork","index":12,"n_rows":47,"n_cols":20,"rows_kept":47,"cut":false,"hidden":false,"merged":[[46,0,46,3],[1,7,3,7],[0,0,4,0],[0,1,4,1],[1,4,3,4],[1,5,3,5],[1,6,3,6]]}
["SHEET NUMBER","LOCATION",null,null,203,203,659]
[null,null,null,null,"EXCAVATION","EMBANKMENT","SEEDING AND MULCHING, CLASS 3B"]
[null,null,"STATIONS","STATIONS"]
[]
[null,null,null,null,"CY","CY","SY"]
[null,null,null,null,null,null,null,null,null,"ITEM 659 - TOPSOIL:",null,null,null,null,null,"ITEM 659 - REPAIR SEEDING AND MULCHING:"]
[{"$f":"'sht mgr'!I18","v":"P.17"},1,{"$f":"'end area'!B19","v":100},{"$f":"'end area'!B20","v":125},null,{"$f":"'end area'!E20","v":1},{"$f":"'end area'!I20","v":14},null,null,"THE APPLICATION RATE FOR THIS ITEM IS",null,null,null,null,null,"THE APPLICATION RATE FOR THIS ITEM IS"]
[{"$f":"A7","v":"P.17"},1,{"$f":"D7","v":125},{"$f":"'end area'!B21","v":150},{"$f":"'end area'!G21","v":8},{"$f":"'end area'!E21","v":1},{"$f":"'end area'!I21","v":50},null,null,"111 CU YDS PER 1000 SQ YDS OF SEEDING",null,null,null,null,null,"5% OF THE SEEDING AREA."]
[{"$f":"A8&\"-\"&A10","v":"P.17-P.18"},1,{"$f":"D8","v":150},{"$f":"'end area'!B22","v":175},{"$f":"'end area'!G22","v":15},{"$f":"'end area'!E22","v":2},{"$f":"'end area'!I22","v":75}]
[{"$f":"'sht mgr'!I19","v":"P.18"},1,175,{"$f":"'end area'!B23","v":200},{"$f":"'end area'!G23","v":20},{"$f":"'end area'!E23","v":3},{"$f":"'end area'!I23","v":98},null,null,{"$f":"CONCATENATE(G47,\" SQ YD / 1000 =\")","v":"1692 SQ YD / 1000 ="},{"$f":"ROUND((G47/1000),1)","v":1.7},null,null,null,null,{"$f":"G47","v":1692},"SQ YD OF SEEDING AND"]
[{"$f":"A10&\"-\"&A12","v":"P.18-P.19"},1,200,{"$f":"'end area'!B24","v":225},{"$f":"'end area'!G24","v":22},{"$f":"'end area'!E24","v":5},{"$f":"'end area'!I24","v":114},null,null,null,null,null,null,null,null,null,"MULCHING (FROM TABLE)"]
[{"$f":"'sht mgr'!I20","v":"P.19"},1,225,{"$f":"'end area'!B25","v":250},{"$f":"'end area'!G25","v":10},{"$f":"'end area'!E25","v":8},{"$f":"'end area'!I25","v":80},null,null,{"$f":"CONCATENATE(K10, \" X 111 CU YDS =\" )","v":"1.7 X 111 CU YDS ="},{"$f":"ROUND((K10*111),0)","v":189},"CU YDS",null,null,null,{"$f":"CONCATENATE(P10, \" SQ YD X 0.05 =\")","v":"1692 SQ YD X 0.05 ="},null,{"$f":"ROUND((P10*0.05),0)","v":85},"SQ YDS"]
[{"$f":"A12&\"-\"&A14","v":"P.19-P.20"},1,250,{"$f":"'end area'!B26","v":275},{"$f":"'end area'!G26","v":1},{"$f":"'end area'!E26","v":8},{"$f":"'end area'!I26","v":48}]
[{"$f":"'sht mgr'!I21","v":"P.20"},1,275,{"$f":"'end area'!B27","v":300},null,{"$f":"'end area'!E27","v":6},{"$f":"'end area'!I27","v":42},null,null,"TOTAL CARRIED TO GENERAL SUMMARY:",null,null,null,null,null,"TOTAL CARRIED TO GENERAL SUMMARY:"]
[{"$f":"A14&\"-\"&A16","v":"P.20-P.21"},1,300,{"$f":"'end area'!B28","v":325},{"$f":"'end area'!G28","v":3},{"$f":"'end area'!E28","v":10},{"$f":"'end area'!I28","v":75},null,null,"ITEM 659 - TOPSOIL =",null,{"$f":"K12","v":189},"CU YD",null,null,"ITEM 659 - REPAIR SEEDING =",null,null,{"$f":"R12","v":85},"SQ YD"]
[{"$f":"'sht mgr'!I22","v":"P.21"},1,325,{"$f":"'end area'!B29","v":350},{"$f":"'end area'!G29","v":10},{"$f":"'end area'!E29","v":11},{"$f":"'end area'!I29","v":110},null,null,null,null,null,null,null,null,"           AND MULCHING"]
[{"$f":"A16&\"-\"&A18","v":"P.21-P.22"},1,350,{"$f":"'end area'!B30","v":375},{"$f":"'end area'!G30","v":13},{"$f":"'end area'!E30","v":10},{"$f":"'end area'!I30","v":125}]
[{"$f":"'sht mgr'!I23","v":"P.22"},1,375,{"$f":"'end area'!B31","v":400},{"$f":"'end area'!G31","v":11},{"$f":"'end area'!E31","v":13},{"$f":"'end area'!I31","v":136},null,null,"ITEM 659 - COMMERCIAL FERTILIZER:"]
[{"$f":"'sht mgr'!I23","v":"P.22"},1,400,{"$f":"'end area'!B32","v":425},{"$f":"'end area'!G32","v":11},{"$f":"'end area'!E32","v":14},{"$f":"'end area'!I32","v":114},null,null,"THE APPLICATION RATE FOR THIS ITEM IS",null,null,null,null,null,"ITEM 659 - INTER-SEEDING:"]
[{"$f":"A19&\"-\"&A21","v":"P.22-P.23"},1,425,{"$f":"'end area'!B33","v":450},{"$f":"'end area'!G33","v":7},{"$f":"'end area'!E33","v":15},{"$f":"'end area'!I33","v":67},null,null,"30 POUNDS PER 1000 SQ FT OF SEEDING.",null,null,null,null,null,"THE APPLICATION RATE FOR THIS ITEM IS"]
[{"$f":"'sht mgr'!I24","v":"P.23"},1,450,{"$f":"'end area'!B34","v":467.44},null,{"$f":"'end area'!E34","v":13},{"$f":"'end area'!I34","v":49},null,null,null,null,null,null,null,null,"5% OF THE SEEDING AREA."]
[null,null,null,null,null,null,null,null,null,{"$f":"G47","v":1692},"SQ YD OF SEEDING AND"]
[null,null,null,null,null,null,null,null,null,null,"MULCHING (FROM TABLE)",null,null,null,null,{"$f":"G47","v":1692},"SQ YD OF SEEDING AND"]
[{"$f":"'sht mgr'!I25","v":"P.24"},2,{"$f":"Plan!E21","v":1014.4},1050,null,{"$f":"'end area'!E3","v":1},{"$f":"'end area'!I3","v":18},null,null,{"$f":"CONCATENATE(F47, \" X 9 SQ FT / SQ YD =\")","v":"174 X 9 SQ FT / SQ YD ="},null,{"$f":"ROUND((J22*9),0)","v":15228},"SQ FT",null,null,null,"MULCHING (FROM TABLE)"]
[{"$f":"A24","v":"P.24"},2,{"$f":"D24","v":1050},{"$f":"C25+25","v":1075},null,{"$f":"'end area'!E4","v":1},{"$f":"'end area'!I4","v":21},null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(P23, \" SQ YD X 0.05 =\")","v":"1692 SQ YD X 0.05 ="},null,{"$f":"ROUND((P23*0.05),0)","v":85},"SQ YDS"]
[{"$f":"A24","v":"P.24"},2,{"$f":"D25","v":1075},{"$f":"C26+25","v":1100},null,{"$f":"'end area'!E5","v":1},{"$f":"'end area'!I5","v":21},null,null,{"$f":"CONCATENATE(L24,\" / 1,000 =\")","v":"15228 / 1,000 ="},{"$f":"L24/1000","v":15.228}]
[{"$f":"A26&\"-\"&A28","v":"P.24-P.25"},2,{"$f":"D26","v":1100},{"$f":"C27+25","v":1125},null,{"$f":"'end area'!E6","v":1},{"$f":"'end area'!I6","v":19},null,null,null,null,null,null,null,null,"TOTAL CARRIED TO GENERAL SUMMARY:"]
[{"$f":"'sht mgr'!I26","v":"P.25"},2,1125,1150,null,{"$f":"'end area'!E7","v":6},{"$f":"'end area'!I7","v":30},null,null,{"$f":"CONCATENATE(K26, \" X 30 POUNDS =\")","v":"15.228 X 30 POUNDS ="},{"$f":"ROUND((K26*30),1)","v":456.8},"POUNDS = ",{"$f":"ROUND(K28/2000,2)","v":0.23},"TONS",null,"ITEM 659 - INTER-SEEDING =",null,null,{"$f":"R25","v":85},"SQ YD"]
[{"$f":"'sht mgr'!I26","v":"P.25"},2,1150,1175,null,{"$f":"'end area'!E8","v":10},{"$f":"'end area'!I8","v":48}]
[{"$f":"A29&\"-\"&A31","v":"P.25-P.26"},2,1175,1200,{"$f":"'end area'!G9","v":1},{"$f":"'end area'!E9","v":6},{"$f":"'end area'!I9","v":50},null,null,"TOTAL CARRIED TO GENERAL SUMMARY:"]
[{"$f":"'sht mgr'!I27","v":"P.26"},2,1200,1225,{"$f":"'end area'!G10","v":1},{"$f":"'end area'!E10","v":3},{"$f":"'end area'!I10","v":36},null,null,"ITEM 659 - COMMERCIAL FERTILIZER =",null,null,{"$f":"M28","v":0.23},"TON",null,"ITEM 659 - WATER:"]
[{"$f":"A31&\"-\"&A33","v":"P.26-P.27"},2,1225,1250,null,{"$f":"'end area'!E11","v":4},{"$f":"'end area'!I11","v":25},null,null,null,null,null,null,null,null,"THE APPLICATION RATE FOR THIS ITEM IS"]
[{"$f":"'sht mgr'!I28","v":"P.27"},2,1250,1275,null,{"$f":"'end area'!E12","v":5},{"$f":"'end area'!I12","v":35},null,null,null,null,null,null,null,null,"2 APPLICATIONS OF 300 GALLONS PER 1000 "]
[{"$f":"A33","v":"P.27"},2,1275,1300,null,{"$f":"'end area'!E13","v":5},{"$f":"'end area'!I13","v":47},null,null,"ITEM 659 - LIME:",null,null,null,null,null,"SQ FT OF SEEDING"]
[{"$f":"A34&\"-\"&A36","v":"P.27-P.28"},2,1300,1325,null,{"$f":"'end area'!E14","v":4},{"$f":"'end area'!I14","v":45},null,null,"THE APPLICATION RATE FOR THIS ITEM IS"]
[{"$f":"'sht mgr'!I29","v":"P.28"},2,1325,1350,null,{"$f":"'end area'!E15","v":4},{"$f":"'end area'!I15","v":44},null,null,"BASED ON THE AREA OF SEEDING.",null,null,null,null,null,{"$f":"G47","v":1692},"SQ YD OF SEEDING AND"]
[{"$f":"A36","v":"P.28"},2,1350,1375,null,{"$f":"'end area'!E16","v":2},{"$f":"'end area'!I16","v":34},null,null,null,null,null,null,null,null,null,"MULCHING (FROM TABLE)"]
[{"$f":"A36","v":"P.28"},2,{"$f":"D37","v":1375},{"$f":"Plan!F22","v":1403.9},null,{"$f":"'end area'!E17","v":1},{"$f":"'end area'!I17","v":22},null,null,{"$f":"G47","v":1692},"SQ YD OF SEEDING AND",null,null,null,null,{"$f":"CONCATENATE(P36, \" X 9 SQ FT / SQ YD =\")","v":"1692 X 9 SQ FT / SQ YD ="},null,null,{"$f":"P36*9","v":15228},"SQ FT"]
[null,null,null,null,null,null,null,null,null,null,"MULCHING (FROM TABLE)"]
[null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(J38, \" X 9 SQ FT / SQ YD =\")","v":"1692 X 9 SQ FT / SQ YD ="},null,{"$f":"J38*9","v":15228},"SQ FT",null,null,{"$f":"CONCATENATE(S38, \" / 1,000 =\")","v":"15228 / 1,000 ="},null,{"$f":"ROUND((S38/1000),1)","v":15.2}]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(L40, \" / 43,560 SQ FT / ACRE =\")","v":"15228 / 43,560 SQ FT / ACRE ="},null,null,{"$f":"ROUND((L40/43560),2)","v":0.35},"ACRE",null,{"$f":"CONCATENATE(R40, \" X 300 GAL. X 2 =\")","v":"15.2 X 300 GAL. X 2 ="},null,{"$f":"ROUND((R40*300*2),0)","v":9120},"GALLONS =",{"$f":"ROUND((R42/1000),2)","v":9.1199999999999992}]
[]
[null,null,null,null,null,null,null,null,null,"TOTAL CARRIED TO GENERAL SUMMARY:",null,null,null,null,null,"TOTAL CARRIED TO GENERAL SUMMARY:"]
[null,null,null,null,null,null,null,null,null,"ITEM 659 - LIME =",null,null,{"$f":"M42","v":0.35},"ACRE",null,"ITEM 659 - WATER =",null,null,{"$f":"T42","v":9.1199999999999992},"M GAL"]
[]
["TOTALS CARRIED TO GENERAL SUMMARY",null,null,null,{"$f":"SUM(E6:E46)","v":133},{"$f":"SUM(F6:F46)","v":174},{"$f":"SUM(G6:G46)","v":1692}]

{"sheet":"end area","index":13,"n_rows":34,"n_cols":9,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[null,"station","length","area","embank","area","excavate","seeding length","area"]
["loc 2",1025,null,null,null,null,null,6]
[null,1050,{"$f":"B3-B2","v":25},0.4,{"$f":"ROUNDUP((D3+D2)/2*C3/27,0)","v":1},null,{"$f":"ROUNDUP((F3+F2)/2*C3/27,0)","v":0},6.3,{"$f":"ROUNDUP(((H3+H2)/2)*C3/9,0)","v":18}]
[null,1075,{"$f":"B4-B3","v":25},1.1000000000000001,{"$f":"ROUNDUP((D4+D3)/2*C4/27,0)","v":1},null,{"$f":"ROUNDUP((F4+F3)/2*C4/27,0)","v":0},8.3000000000000007,{"$f":"ROUNDUP(((H4+H3)/2)*C4/9,0)","v":21}]
[null,1100,{"$f":"B5-B4","v":25},1,1,null,0,6.5,21]
[null,1125,25,1,1,null,0,7,19]
[null,1150,25,11.5,6,null,0,14.2,30]
[null,1175,25,8.8000000000000007,10,null,0,20.2,48]
[null,1200,25,4,6,0.5,1,15.7,50]
[null,1225,25,2.4,3,null,1,9.6,36]
[null,1250,25,5.6,4,null,0,7.9,25]
[null,1275,25,4.7,5,null,0,16.8,35]
[null,1300,25,5.2,5,null,0,16.7,47]
[null,1325,25,3.2,4,null,0,15.2,45]
[null,1350,25,3.3,4,null,0,16.3,44]
[null,1375,25,1,2,null,0,7.7,34]
[null,1400,{"$f":"B17-B16","v":25},1,{"$f":"ROUNDUP((D17+D16)/2*C17/27,0)","v":1},null,0,7.7,{"$f":"ROUNDUP(((H17+H16)/2)*C17/9,0)","v":22}]
[]
["loc 1",100]
[null,125,25,0.98,1,0.34,1,9.5,14]
[null,150,25,0.97,1,15.1,8,26.4,50]
[null,175,25,1.8,2,16.399999999999999,15,26.9,75]
[null,200,25,3.8,3,25.25,20,{"$f":"2.4+2+16.4+7.8+9+5.9","v":43.499999999999993},98]
[null,225,25,{"$f":"4.7+0.6","v":5.3},5,{"$f":"21.3","v":21.3},22,{"$f":"8.8+3.9+7.9+2.5+2+13.4","v":38.5},114]
[null,250,25,11.9,8,0.2,10,{"$f":"9.1+5.5+4.4","v":19},80]
[null,275,25,3.7,8,0,1,15.1,48]
[null,300,25,{"$f":"3.9+4.1","v":8},6,0,0,{"$f":"7.7+7.4","v":15.100000000000001},42]
[null,325,25,{"$f":"9.1+2.7","v":11.8},10,{"$f":"5.8","v":5.8},3,{"$f":"8.8+4.5+22.1+3.1","v":38.500000000000007},75]
[null,350,25,{"$f":"8+2","v":10},11,{"$f":"13.97","v":13.97},10,{"$f":"7.4+5.6+4.4+17.5+3.8+2","v":40.699999999999996},110]
[null,375,25,{"$f":"6.8+4.1","v":10.899999999999999},10,{"$f":"13.75","v":13.75},13,{"$f":"8.4+9.5+8.6+17.2+2+3.3","v":49},125]
[null,400,25,{"$f":"8.8+6.4","v":15.200000000000001},13,{"$f":"8.8","v":8.8000000000000007},11,{"$f":"8.2+10.1+9.1+15.9+2+3.3","v":48.599999999999994},136]
[null,425,25,{"$f":"13.3","v":13.3},14,{"$f":"13.6","v":13.6},11,{"$f":"9.8+10.8+11.4+1","v":33},114]
[null,450,25,{"$f":"12.1+6.5","v":18.600000000000001},15,0,7,{"$f":"2.8+11.9+0","v":14.7},67]
[null,467.44,17.439999999999998,{"$f":"6.5+12.8","v":19.3},13,0,0,{"$f":"12.8+3.1+19.3","v":35.200000000000003},49]

{"sheet":"XS (1)","index":14,"n_rows":79,"n_cols":4,"rows_kept":79,"cut":false,"hidden":false,"merged":[]}
[{"$f":"'end area'!B19","v":100}]
["CUT AREA (SF):",{"$f":"VLOOKUP($A$1,'end area'!$B$19:$I$34,5)","v":0},"CUT VOLUME (CY):",{"$f":"VLOOKUP($A$1,'end area'!$B$19:$I$34,6)","v":0}]
["FILL AREA (SF):",{"$f":"VLOOKUP($A$1,'end area'!$B$19:$I$34,3)","v":0},"FILL VOLUME (CY):",{"$f":"VLOOKUP($A$1,'end area'!$B$19:$I$34,4)","v":0}]
["SEED WIDTH (FT):",{"$f":"VLOOKUP($A$1,'end area'!$B$19:$I$34,7)","v":0},"SEED AREA (SY):",{"$f":"VLOOKUP($A$1,'end area'!$B$19:$I$34,8)","v":0}]
[]
[{"$f":"A1+25","v":125}]
["CUT AREA (SF):",{"$f":"VLOOKUP(A6,'end area'!$B$19:$I$34,5)","v":0.34},"CUT VOLUME (CY):",{"$f":"VLOOKUP(A6,'end area'!$B$19:$I$34,6)","v":1}]
["FILL AREA (SF):",{"$f":"VLOOKUP(A6,'end area'!$B$19:$I$34,3)","v":0.98},"FILL VOLUME (CY):",{"$f":"VLOOKUP(A6,'end area'!$B$19:$I$34,4)","v":1}]
["SEED WIDTH (FT):",{"$f":"VLOOKUP(A6,'end area'!$B$19:$I$34,7)","v":9.5},"SEED AREA (SY):",{"$f":"VLOOKUP(A6,'end area'!$B$19:$I$34,8)","v":14}]
[]
[{"$f":"A6+25","v":150}]
["CUT AREA (SF):",{"$f":"VLOOKUP(A11,'end area'!$B$19:$I$34,5)","v":15.1},"CUT VOLUME (CY):",{"$f":"VLOOKUP(A11,'end area'!$B$19:$I$34,6)","v":8}]
["FILL AREA (SF):",{"$f":"VLOOKUP(A11,'end area'!$B$19:$I$34,3)","v":0.97},"FILL VOLUME (CY):",{"$f":"VLOOKUP(A11,'end area'!$B$19:$I$34,4)","v":1}]
["SEED WIDTH (FT):",{"$f":"VLOOKUP(A11,'end area'!$B$19:$I$34,7)","v":26.4},"SEED AREA (SY):",{"$f":"VLOOKUP(A11,'end area'!$B$19:$I$34,8)","v":50}]
[]
[{"$f":"A11+25","v":175}]
["CUT AREA (SF):",{"$f":"VLOOKUP(A16,'end area'!$B$19:$I$34,5)","v":16.399999999999999},"CUT VOLUME (CY):",{"$f":"VLOOKUP(A16,'end area'!$B$19:$I$34,6)","v":15}]
["FILL AREA (SF):",{"$f":"VLOOKUP(A16,'end area'!$B$19:$I$34,3)","v":1.8},"FILL VOLUME (CY):",{"$f":"VLOOKUP(A16,'end area'!$B$19:$I$34,4)","v":2}]
["SEED WIDTH (FT):",{"$f":"VLOOKUP(A16,'end area'!$B$19:$I$34,7)","v":26.9},"SEED AREA (SY):",{"$f":"VLOOKUP(A16,'end area'!$B$19:$I$34,8)","v":75}]
[]
[{"$f":"A16+25","v":200}]
["CUT AREA (SF):",{"$f":"VLOOKUP(A21,'end area'!$B$19:$I$34,5)","v":25.25},"CUT VOLUME (CY):",{"$f":"VLOOKUP(A21,'end area'!$B$19:$I$34,6)","v":20}]
["FILL AREA (SF):",{"$f":"VLOOKUP(A21,'end area'!$B$19:$I$34,3)","v":3.8},"FILL VOLUME (CY):",{"$f":"VLOOKUP(A21,'end area'!$B$19:$I$34,4)","v":3}]
["SEED WIDTH (FT):",{"$f":"VLOOKUP(A21,'end area'!$B$19:$I$34,7)","v":43.499999999999993},"SEED AREA (SY):",{"$f":"VLOOKUP(A21,'end area'!$B$19:$I$34,8)","v":98}]
[]
[{"$f":"A21+25","v":225}]
["CUT AREA (SF):",{"$f":"VLOOKUP(A26,'end area'!$B$19:$I$34,5)","v":21.3},"CUT VOLUME (CY):",{"$f":"VLOOKUP(A26,'end area'!$B$19:$I$34,6)","v":22}]
["FILL AREA (SF):",{"$f":"VLOOKUP(A26,'end area'!$B$19:$I$34,3)","v":5.3},"FILL VOLUME (CY):",{"$f":"VLOOKUP(A26,'end area'!$B$19:$I$34,4)","v":5}]
["SEED WIDTH (FT):",{"$f":"VLOOKUP(A26,'end area'!$B$19:$I$34,7)","v":38.5},"SEED AREA (SY):",{"$f":"VLOOKUP(A26,'end area'!$B$19:$I$34,8)","v":114}]
[]
[{"$f":"A26+25","v":250}]
["CUT AREA (SF):",{"$f":"VLOOKUP(A31,'end area'!$B$19:$I$34,5)","v":0.2},"CUT VOLUME (CY):",{"$f":"VLOOKUP(A31,'end area'!$B$19:$I$34,6)","v":10}]
["FILL AREA (SF):",{"$f":"VLOOKUP(A31,'end area'!$B$19:$I$34,3)","v":11.9},"FILL VOLUME (CY):",{"$f":"VLOOKUP(A31,'end area'!$B$19:$I$34,4)","v":8}]
["SEED WIDTH (FT):",{"$f":"VLOOKUP(A31,'end area'!$B$19:$I$34,7)","v":19},"SEED AREA (SY):",{"$f":"VLOOKUP(A31,'end area'!$B$19:$I$34,8)","v":80}]
[]
[{"$f":"A31+25","v":275}]
["CUT AREA (SF):",null,"CUT VOLUME (CY):",{"$f":"VLOOKUP(A36,'end area'!$B$19:$I$34,6)","v":1}]
["FILL AREA (SF):",{"$f":"VLOOKUP(A36,'end area'!$B$19:$I$34,3)","v":3.7},"FILL VOLUME (CY):",{"$f":"VLOOKUP(A36,'end area'!$B$19:$I$34,4)","v":8}]
["SEED WIDTH (FT):",{"$f":"VLOOKUP(A36,'end area'!$B$19:$I$34,7)","v":15.1},"SEED AREA (SY):",{"$f":"VLOOKUP(A36,'end area'!$B$19:$I$34,8)","v":48}]
[]
[{"$f":"A36+25","v":300}]
["CUT AREA (SF):",null,"CUT VOLUME (CY):"]
["FILL AREA (SF):",{"$f":"VLOOKUP(A41,'end area'!$B$19:$I$34,3)","v":8},"FILL VOLUME (CY):",{"$f":"VLOOKUP(A41,'end area'!$B$19:$I$34,4)","v":6}]
["SEED WIDTH (FT):",{"$f":"VLOOKUP(A41,'end area'!$B$19:$I$34,7)","v":15.100000000000001},"SEED AREA (SY):",{"$f":"VLOOKUP(A41,'end area'!$B$19:$I$34,8)","v":42}]
[]
[{"$f":"A41+25","v":325}]
["CUT AREA (SF):",{"$f":"VLOOKUP(A46,'end area'!$B$19:$I$34,5)","v":5.8},"CUT VOLUME (CY):",{"$f":"VLOOKUP(A46,'end area'!$B$19:$I$34,6)","v":3}]
["FILL AREA (SF):",{"$f":"VLOOKUP(A46,'end area'!$B$19:$I$34,3)","v":11.8},"FILL VOLUME (CY):",{"$f":"VLOOKUP(A46,'end area'!$B$19:$I$34,4)","v":10}]
["SEED WIDTH (FT):",{"$f":"VLOOKUP(A46,'end area'!$B$19:$I$34,7)","v":38.500000000000007},"SEED AREA (SY):",{"$f":"VLOOKUP(A46,'end area'!$B$19:$I$34,8)","v":75}]
[]
[{"$f":"A46+25","v":350}]
["CUT AREA (SF):",{"$f":"VLOOKUP(A51,'end area'!$B$19:$I$34,5)","v":13.97},"CUT VOLUME (CY):",{"$f":"VLOOKUP(A51,'end area'!$B$19:$I$34,6)","v":10}]
["FILL AREA (SF):",{"$f":"VLOOKUP(A51,'end area'!$B$19:$I$34,3)","v":10},"FILL VOLUME (CY):",{"$f":"VLOOKUP(A51,'end area'!$B$19:$I$34,4)","v":11}]
["SEED WIDTH (FT):",{"$f":"VLOOKUP(A51,'end area'!$B$19:$I$34,7)","v":40.699999999999996},"SEED AREA (SY):",{"$f":"VLOOKUP(A51,'end area'!$B$19:$I$34,8)","v":110}]
[]
[{"$f":"A51+25","v":375}]
["CUT AREA (SF):",{"$f":"VLOOKUP(A56,'end area'!$B$19:$I$34,5)","v":13.75},"CUT VOLUME (CY):",{"$f":"VLOOKUP(A56,'end area'!$B$19:$I$34,6)","v":13}]
["FILL AREA (SF):",{"$f":"VLOOKUP(A56,'end area'!$B$19:$I$34,3)","v":10.899999999999999},"FILL VOLUME (CY):",{"$f":"VLOOKUP(A56,'end area'!$B$19:$I$34,4)","v":10}]
["SEED WIDTH (FT):",{"$f":"VLOOKUP(A56,'end area'!$B$19:$I$34,7)","v":49},"SEED AREA (SY):",{"$f":"VLOOKUP(A56,'end area'!$B$19:$I$34,8)","v":125}]
[]
[{"$f":"A56+25","v":400}]
["CUT AREA (SF):",{"$f":"VLOOKUP(A61,'end area'!$B$19:$I$34,5)","v":8.8000000000000007},"CUT VOLUME (CY):",{"$f":"VLOOKUP(A61,'end area'!$B$19:$I$34,6)","v":11}]
["FILL AREA (SF):",{"$f":"VLOOKUP(A61,'end area'!$B$19:$I$34,3)","v":15.200000000000001},"FILL VOLUME (CY):",{"$f":"VLOOKUP(A61,'end area'!$B$19:$I$34,4)","v":13}]
["SEED WIDTH (FT):",{"$f":"VLOOKUP(A61,'end area'!$B$19:$I$34,7)","v":48.599999999999994},"SEED AREA (SY):",{"$f":"VLOOKUP(A61,'end area'!$B$19:$I$34,8)","v":136}]
[]
[{"$f":"A61+25","v":425}]
["CUT AREA (SF):",{"$f":"VLOOKUP(A66,'end area'!$B$19:$I$34,5)","v":13.6},"CUT VOLUME (CY):",{"$f":"VLOOKUP(A66,'end area'!$B$19:$I$34,6)","v":11}]
["FILL AREA (SF):",{"$f":"VLOOKUP(A66,'end area'!$B$19:$I$34,3)","v":13.3},"FILL VOLUME (CY):",{"$f":"VLOOKUP(A66,'end area'!$B$19:$I$34,4)","v":14}]
["SEED WIDTH (FT):",{"$f":"VLOOKUP(A66,'end area'!$B$19:$I$34,7)","v":33},"SEED AREA (SY):",{"$f":"VLOOKUP(A66,'end area'!$B$19:$I$34,8)","v":114}]
[]
[{"$f":"A66+25","v":450}]
["CUT AREA (SF):",null,"CUT VOLUME (CY):",{"$f":"VLOOKUP(A71,'end area'!$B$19:$I$34,6)","v":7}]
["FILL AREA (SF):",{"$f":"VLOOKUP(A71,'end area'!$B$19:$I$34,3)","v":18.600000000000001},"FILL VOLUME (CY):",{"$f":"VLOOKUP(A71,'end area'!$B$19:$I$34,4)","v":15}]
["SEED WIDTH (FT):",{"$f":"VLOOKUP(A71,'end area'!$B$19:$I$34,7)","v":14.7},"SEED AREA (SY):",{"$f":"VLOOKUP(A71,'end area'!$B$19:$I$34,8)","v":67}]
[]
[{"$f":"'end area'!B34","v":467.44}]
["CUT AREA (SF):",null,"CUT VOLUME (CY):"]
["FILL AREA (SF):",{"$f":"VLOOKUP(A76,'end area'!$B$19:$I$34,3)","v":19.3},"FILL VOLUME (CY):",{"$f":"VLOOKUP(A76,'end area'!$B$19:$I$34,4)","v":13}]
["SEED WIDTH (FT):",{"$f":"VLOOKUP(A76,'end area'!$B$19:$I$34,7)","v":35.200000000000003},"SEED AREA (SY):",{"$f":"VLOOKUP(A76,'end area'!$B$19:$I$34,8)","v":49}]

{"sheet":"XS","index":15,"n_rows":69,"n_cols":4,"rows_kept":69,"cut":false,"hidden":false,"merged":[]}
[{"$f":"'end area'!B3","v":1050}]
["CUT AREA (SF):",null,"CUT VOLUME (CY):"]
["FILL AREA (SF):",{"$f":"VLOOKUP(XS!A1,'end area'!$B$2:$I$17,3)","v":0.4},"FILL VOLUME (CY):",{"$f":"VLOOKUP(XS!A1,'end area'!$B$2:$I$17,4)","v":1}]
["SEED WIDTH (FT):",{"$f":"VLOOKUP(XS!A1,'end area'!$B$2:$I$17,7)","v":6.3},"SEED AREA (SY):",{"$f":"VLOOKUP(XS!A1,'end area'!$B$2:$I$17,8)","v":18}]
[]
[{"$f":"A1+25","v":1075}]
["CUT AREA (SF):",null,"CUT VOLUME (CY):"]
["FILL AREA (SF):",{"$f":"VLOOKUP(XS!A6,'end area'!$B$2:$I$17,3)","v":1.1000000000000001},"FILL VOLUME (CY):",{"$f":"VLOOKUP(XS!A6,'end area'!$B$2:$I$17,4)","v":1}]
["SEED WIDTH (FT):",{"$f":"VLOOKUP(XS!A6,'end area'!$B$2:$I$17,7)","v":8.3000000000000007},"SEED AREA (SY):",{"$f":"VLOOKUP(XS!A6,'end area'!$B$2:$I$17,8)","v":21}]
[]
[{"$f":"A6+25","v":1100}]
["CUT AREA (SF):",null,"CUT VOLUME (CY):"]
["FILL AREA (SF):",{"$f":"VLOOKUP(XS!A11,'end area'!$B$2:$I$17,3)","v":1},"FILL VOLUME (CY):",{"$f":"VLOOKUP(XS!A11,'end area'!$B$2:$I$17,4)","v":1}]
["SEED WIDTH (FT):",{"$f":"VLOOKUP(XS!A11,'end area'!$B$2:$I$17,7)","v":6.5},"SEED AREA (SY):",{"$f":"VLOOKUP(XS!A11,'end area'!$B$2:$I$17,8)","v":21}]
[]
[{"$f":"A11+25","v":1125}]
["CUT AREA (SF):",null,"CUT VOLUME (CY):"]
["FILL AREA (SF):",{"$f":"VLOOKUP(XS!A16,'end area'!$B$2:$I$17,3)","v":1},"FILL VOLUME (CY):",{"$f":"VLOOKUP(XS!A16,'end area'!$B$2:$I$17,4)","v":1}]
["SEED WIDTH (FT):",{"$f":"VLOOKUP(XS!A16,'end area'!$B$2:$I$17,7)","v":7},"SEED AREA (SY):",{"$f":"VLOOKUP(XS!A16,'end area'!$B$2:$I$17,8)","v":19}]
[]
[{"$f":"A16+25","v":1150}]
["CUT AREA (SF):",null,"CUT VOLUME (CY):"]
["FILL AREA (SF):",{"$f":"VLOOKUP(XS!A21,'end area'!$B$2:$I$17,3)","v":11.5},"FILL VOLUME (CY):",{"$f":"VLOOKUP(XS!A21,'end area'!$B$2:$I$17,4)","v":6}]
["SEED WIDTH (FT):",{"$f":"VLOOKUP(XS!A21,'end area'!$B$2:$I$17,7)","v":14.2},"SEED AREA (SY):",{"$f":"VLOOKUP(XS!A21,'end area'!$B$2:$I$17,8)","v":30}]
[]
[{"$f":"A21+25","v":1175}]
["CUT AREA (SF):",null,"CUT VOLUME (CY):"]
["FILL AREA (SF):",{"$f":"VLOOKUP(XS!A26,'end area'!$B$2:$I$17,3)","v":8.8000000000000007},"FILL VOLUME (CY):",{"$f":"VLOOKUP(XS!A26,'end area'!$B$2:$I$17,4)","v":10}]
["SEED WIDTH (FT):",{"$f":"VLOOKUP(XS!A26,'end area'!$B$2:$I$17,7)","v":20.2},"SEED AREA (SY):",{"$f":"VLOOKUP(XS!A26,'end area'!$B$2:$I$17,8)","v":48}]
[]
[{"$f":"A26+25","v":1200}]
["CUT AREA (SF):",{"$f":"VLOOKUP(XS!A31,'end area'!$B$2:$I$17,5)","v":0.5},"CUT VOLUME (CY):",{"$f":"VLOOKUP(XS!A31,'end area'!$B$2:$I$17,6)","v":1}]
["FILL AREA (SF):",{"$f":"VLOOKUP(XS!A31,'end area'!$B$2:$I$17,3)","v":4},"FILL VOLUME (CY):",{"$f":"VLOOKUP(XS!A31,'end area'!$B$2:$I$17,4)","v":6}]
["SEED WIDTH (FT):",{"$f":"VLOOKUP(XS!A31,'end area'!$B$2:$I$17,7)","v":15.7},"SEED AREA (SY):",{"$f":"VLOOKUP(XS!A31,'end area'!$B$2:$I$17,8)","v":50}]
[]
[{"$f":"A31+25","v":1225}]
["CUT AREA (SF):",null,"CUT VOLUME (CY):",{"$f":"VLOOKUP(XS!A36,'end area'!$B$2:$I$17,6)","v":1}]
["FILL AREA (SF):",{"$f":"VLOOKUP(XS!A36,'end area'!$B$2:$I$17,3)","v":2.4},"FILL VOLUME (CY):",{"$f":"VLOOKUP(XS!A36,'end area'!$B$2:$I$17,4)","v":3}]
["SEED WIDTH (FT):",{"$f":"VLOOKUP(XS!A36,'end area'!$B$2:$I$17,7)","v":9.6},"SEED AREA (SY):",{"$f":"VLOOKUP(XS!A36,'end area'!$B$2:$I$17,8)","v":36}]
[]
[{"$f":"A36+25","v":1250}]
["CUT AREA (SF):",null,"CUT VOLUME (CY):"]
["FILL AREA (SF):",{"$f":"VLOOKUP(XS!A41,'end area'!$B$2:$I$17,3)","v":5.6},"FILL VOLUME (CY):",{"$f":"VLOOKUP(XS!A41,'end area'!$B$2:$I$17,4)","v":4}]
["SEED WIDTH (FT):",{"$f":"VLOOKUP(XS!A41,'end area'!$B$2:$I$17,7)","v":7.9},"SEED AREA (SY):",{"$f":"VLOOKUP(XS!A41,'end area'!$B$2:$I$17,8)","v":25}]
[]
[{"$f":"A41+25","v":1275}]
["CUT AREA (SF):",null,"CUT VOLUME (CY):"]
["FILL AREA (SF):",{"$f":"VLOOKUP(XS!A46,'end area'!$B$2:$I$17,3)","v":4.7},"FILL VOLUME (CY):",{"$f":"VLOOKUP(XS!A46,'end area'!$B$2:$I$17,4)","v":5}]
["SEED WIDTH (FT):",{"$f":"VLOOKUP(XS!A46,'end area'!$B$2:$I$17,7)","v":16.8},"SEED AREA (SY):",{"$f":"VLOOKUP(XS!A46,'end area'!$B$2:$I$17,8)","v":35}]
[]
[{"$f":"A46+25","v":1300}]
["CUT AREA (SF):",null,"CUT VOLUME (CY):"]
["FILL AREA (SF):",{"$f":"VLOOKUP(XS!A51,'end area'!$B$2:$I$17,3)","v":5.2},"FILL VOLUME (CY):",{"$f":"VLOOKUP(XS!A51,'end area'!$B$2:$I$17,4)","v":5}]
["SEED WIDTH (FT):",{"$f":"VLOOKUP(XS!A51,'end area'!$B$2:$I$17,7)","v":16.7},"SEED AREA (SY):",{"$f":"VLOOKUP(XS!A51,'end area'!$B$2:$I$17,8)","v":47}]
[]
[{"$f":"A51+25","v":1325}]
["CUT AREA (SF):",null,"CUT VOLUME (CY):"]
["FILL AREA (SF):",{"$f":"VLOOKUP(XS!A56,'end area'!$B$2:$I$17,3)","v":3.2},"FILL VOLUME (CY):",{"$f":"VLOOKUP(XS!A56,'end area'!$B$2:$I$17,4)","v":4}]
["SEED WIDTH (FT):",{"$f":"VLOOKUP(XS!A56,'end area'!$B$2:$I$17,7)","v":15.2},"SEED AREA (SY):",{"$f":"VLOOKUP(XS!A56,'end area'!$B$2:$I$17,8)","v":45}]
[]
[{"$f":"A56+25","v":1350}]
["CUT AREA (SF):",null,"CUT VOLUME (CY):"]
["FILL AREA (SF):",{"$f":"VLOOKUP(XS!A61,'end area'!$B$2:$I$17,3)","v":3.3},"FILL VOLUME (CY):",{"$f":"VLOOKUP(XS!A61,'end area'!$B$2:$I$17,4)","v":4}]
["SEED WIDTH (FT):",{"$f":"VLOOKUP(XS!A61,'end area'!$B$2:$I$17,7)","v":16.3},"SEED AREA (SY):",{"$f":"VLOOKUP(XS!A61,'end area'!$B$2:$I$17,8)","v":44}]
[]
[{"$f":"A61+25","v":1375}]
["CUT AREA (SF):",null,"CUT VOLUME (CY):"]
["FILL AREA (SF):",{"$f":"VLOOKUP(XS!A66,'end area'!$B$2:$I$17,3)","v":1},"FILL VOLUME (CY):",{"$f":"VLOOKUP(XS!A66,'end area'!$B$2:$I$17,4)","v":2}]
["SEED WIDTH (FT):",{"$f":"VLOOKUP(XS!A66,'end area'!$B$2:$I$17,7)","v":7.7},"SEED AREA (SY):",{"$f":"VLOOKUP(XS!A66,'end area'!$B$2:$I$17,8)","v":34}]

{"sheet":"0811 Bridge","index":16,"n_rows":22,"n_cols":4,"rows_kept":22,"cut":false,"hidden":false,"merged":[[0,0,0,3],[21,0,21,3]]}
["ESTIMATED QUANTITIES"]
["ITEM","QUANTITY","UNIT","DESCRIPTION"]
["201E11000","LS",null,"CLEARING AND GRUBBING"]
["202E11000","LS",null,"STRUCTURE REMOVED"]
["503E11100","LS",null,"COFFERDAMS AND EXCAVATION BRACING"]
["503E21300","LS",null,"UNCLASSIFIED EXCAVATION"]
["509E10000",4235,"LB","EPOXY COATED STEEL REINFORCEMENT"]
[]
["511E46510",55,"CY","CLASS QC1 CONCRETE, FOOTING"]
["511E46610",1,"CY","CLASS QC1 CONCRETE, HEADWALL"]
["512E10050",94,"SY","SEALING OF CONCRETE SURFACES (NON-EPOXY)"]
["512E33000",112,"SY","TYPE 2 WATERPROOFING"]
["512E33010",115,"SY","TYPE 3 WATERPROOFING"]
[]
["516E13601",42,"SF","1\" PREFORMED EXPANSION JOINT FILLER, AS PER PLAN"]
["518E21200",29,"CY","POROUS BACKFILL WITH GEOTEXTILE FABRIC"]
["601E11000",23,"SY","RIPRAP, TYPE D"]
["601E32100",100,"CY","ROCK CHANNEL PROTECTION, TYPE B WITH FILTER"]
["611E96470",48,"FT","18' X 7' CONDUIT, TYPE A, 706.05"]
[]
["851E10000",564,"SF","PRECAST GRAVITY AND SEMIGRAVITY RETAINING WALL"]
[{"$f":"\"QUANTITIES HAVE BEEN CARRIED TO THE PLAN GENERAL SUMMARY ON SHEETS \"&'sht mgr'!I11&\"-\"&'sht mgr'!I12","v":"QUANTITIES HAVE BEEN CARRIED TO THE PLAN GENERAL SUMMARY ON SHEETS P.10-P.11"}]

{"sheet":"2062 Bridge","index":17,"n_rows":24,"n_cols":4,"rows_kept":24,"cut":false,"hidden":false,"merged":[[0,0,0,3],[23,0,23,3]]}
["ESTIMATED QUANTITIES"]
["ITEM","QUANTITY","UNIT","DESCRIPTION"]
["201E11000","LS",null,"CLEARING AND GRUBBING"]
["202E11000","LS",null,"STRUCTURE REMOVED"]
["503E11100","LS",null,"COFFERDAMS AND EXCAVATION BRACING"]
["503E21300","LS",null,"UNCLASSIFIED EXCAVATION"]
["503E21101",{"$f":"ROUNDUP((8-1.5+1)*2*53.9/27,0)*2","v":60},"CY","UNCLASSIFIED EXCAVATION, AS PER PLAN"]
[]
["509E10000",{"$f":"ROUND('[5]FINAL FORMAT'!$E$63,0)","v":5176},"LB","EPOXY COATED STEEL REINFORCEMENT"]
["511E46510",{"$f":"ROUND((54.17*2*1.5*2+54.17*8*2*2+16*4*1*2+16*0.5*2)/27,0)","v":82},"CY","CLASS QC1 CONCRETE, FOOTING"]
["511E46610",1,"CY","CLASS QC1 CONCRETE, HEADWALL"]
["512E10050",{"$f":"ROUNDUP((44*2*2+3.25*16*2+90.25*4+21.24*0.5*4+1.25*16*4+0.5*16*4)/9,0)","v":89},"SY","SEALING OF CONCRETE SURFACES (NON-EPOXY)"]
["512E33000",{"$f":"ROUND(10*39.5*2/9,0)+ROUND(3*10*4/9,0)","v":101},"SY","TYPE 2 WATERPROOFING"]
[]
["512E33010",{"$f":"ROUND(16*39.5/9+1*39.5*2/9+0.5*16*2/9,0)","v":81},"SY","TYPE 3 WATERPROOFING"]
["516E13601",{"$f":"ROUND(10.5*1.25*4,0)","v":53},"SF","1\" PREFORMED EXPANSION JOINT FILLER, AS PER PLAN"]
["518E21200",{"$f":"ROUND(19*2*9.5*4/27,0)","v":53},"CY","POROUS BACKFILL WITH GEOTEXTILE FABRIC"]
["601E11000",{"$f":"ROUNDUP(16*5.75/9,0)","v":11},"SY","RIPRAP, TYPE D"]
["601E32100",{"$f":"9+10+71","v":90},"CY","ROCK CHANNEL PROTECTION, TYPE B WITH FILTER"]
[]
["605E11000",120,"FT","6\" CONSTRUCTION UNDERDRAINS"]
["611E96330",42,"FT","14' X 8' CONDUIT, TYPE A, 706.05"]
["851E10000",{"$f":"ROUNDUP(19.08*10.5*4,0)","v":802},"SF","PRECAST GRAVITY AND SEMIGRAVITY RETAINING WALL"]
[{"$f":"\"QUANTITIES HAVE BEEN CARRIED TO THE PLAN GENERAL SUMMARY ON SHEETS \"&'sht mgr'!I11&\"-\"&'sht mgr'!I12","v":"QUANTITIES HAVE BEEN CARRIED TO THE PLAN GENERAL SUMMARY ON SHEETS P.10-P.11"}]

{"sheet":"HW RT","index":18,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[]
["invert","top of wall grading (3:1 from invert)",null,"northern RT wall","length"]
[1238.4000000000001,{"$f":"A4+E4*0.33333","v":1244.0666100000001},null,{"$f":"1248.89-0.016*12-0.04*3-7*0.08-12.351*0.3333","v":1243.9014117000002},17]
[]
["invert","top of wall grading (3:1 from invert)",null,"southern RT wall"]
[1238.4000000000001,{"$f":"A7+E7*0.33333","v":1243.39995},null,{"$f":"1249.45-0.016*12-0.04*3-7*0.08-16.837*0.3333","v":1242.9662279000001},15]
[]
[]
["invert","top of wall grading (3:1 from invert)",null,"northern LT wall","length"]
[1238.4000000000001,{"$f":"A11+E11*0.33333","v":1238.4000000000001}]
[]
["invert","top of wall grading (3:1 from invert)",null,"southern LT wall"]
[1238.4000000000001,{"$f":"A14+E14*0.33333","v":1244.0666100000001},null,{"$f":"1249.58-0.016*12-0.04*3-7*0.08-16.837*0.3333","v":1243.0962279},17]