{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Standards","MoDOT-template","D-29","D-30","QuanTab8"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":7,"comments":1,"pivot_tables":0},"unopened":[{"sheet":"QuanTab8","index":4,"reason":"part_missing"}],"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":"Standards","index":0,"n_rows":39,"n_cols":10,"rows_kept":39,"cut":false,"hidden":false,"merged":[[4,1,5,8],[21,2,22,6]]}
["DRAFTING STANDARDS"]
[]
["TEXT MAPPING"]
[]
["Excel","OpenRoads Designer Attributes"]
["Font"]
["Color","Font Style","Text Height","Text Width","Level","Color","Line Style","Line Weight","Comment"]
["Black","Engineering Vert Mono Bold",0.12,0.12,"Common-Notes",5,0,2,"Small Text"]
["Red","Engineering Vert Mono Bold",0.18,0.18,"Common-Notes",1,0,5,"Large Text"]
["Green","Engineering Vert Mono Bold",0.15,0.15,"Common-Notes",4,0,4,"Medium Text"]
["Blue","Engineering Vert Mono Bold",0.1,0.1,"Common-Notes",7,0,1,"Extra Small Text"]
["Violet","Engineering Vert Mono Bold",0.21,0.21,"Common-Notes",2,0,7,"Extra Large Text"]
[]
[]
[]
[]
[]
[]
[]
["BORDER MAPPING",null,null,null,null,null,null,null,"SPECIAL CHARACTERS"]
[]
["Excel","Name","OpenRoads Designer Attributes"]
["Border",null,null,null,null,null,null,null,"Centerline","\\161"]
["Style",null,"Level","Color","Line Style","Line Weight","Comment"]
[null,"Continuous","Grid_Line-Main",1,0,5,null,null,"Baseline","\\163"]
[]
[null,"Dot","Grid_Line-Main",5,0,2,null,null,"Propertry Line","\\162"]
[]
[null,"Dash","Grid_Line-Main",5,0,2,null,null,"Flow Line","\\165"]
[]
[null,"DashDot","Grid_Line-Main",5,0,2,null,null,"Plus/Minus","\\177"]
[]
[null,"DashDotDot","Grid_Line-Main",5,0,2,null,null,"Less than/Equal to ","\\245"]
[]
[null,"Double","Grid_Line-Main",5,0,2,null,null,"Greater than/Equal to","\\246"]
[]
[null,"SlantDashDot","Grid_Line-Main",5,0,2,null,null,"Degree","\\176"]
[]
[null,null,null,null,null,null,null,null,"Diameter","\\216"]

{"sheet":"MoDOT-template","index":1,"n_rows":70,"n_cols":79,"rows_kept":70,"cut":false,"hidden":false,"merged":[]}
[null,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[]
[]
[0.4]
[0.3]
[0.3]
[0.25,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,100]
[0.25,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,100.1]
[0.25,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,100.12]
[0.25]
[0.25]
[0.25]
[0.25]
[0.25]
[0.25]
[0.25]
[0.25]
[0.25]
[0.25]
[0.25]
[0.25]
[0.25]
[0.25]
[0.25]
[0.25]
[0.25]
[0.25]
[0.25]
[0.25]
[0.25]
[0.25]
[0.25]
[0.25]
[0.25]
[0.25]
[0.25]
[0.25]
[0.25]
[0.25]
[0.25]
[0.25]
[0.25]
[0.25]
[0.25]
[0.25]
[0.25]
[0.25]
[0.25]
[0.25]
[0.25]
[0.25]
[0.25]
[0.25]
[0.25]
[0.25]
[0.25]
[0.25]
[0.25]
[0.25]
[0.25]
[0.25]
[0.25]
[0.25]
[0.25]
[0.25]
[0.25]
[0.25]
[0.25]
[0.25]
[0.25]

{"sheet":"D-29","index":2,"n_rows":87,"n_cols":37,"rows_kept":87,"cut":false,"hidden":false,"merged":[[7,33,9,33],[7,32,9,32]]}
[null,0.5,1,1,1,0.5,1.4,0.51,0.51,0.51,0.51,0.5,0.8,0.51,0.51,0.51,0.5,0.8,0.8,0.8,0.51,0.51,0.85,0.89,0.99,0.51,0.51,0.85,0.89,0.99,0.99,1.25,0.5,0.5,0.8,1.4,3.1320999999999999]
[null,null,null,null,null,"SUBTOTAL",{"$f":"G72","v":0},null,null,null,null,null,{"$f":"M72","v":0},null,null,null,null,{"$f":"R72","v":0},0,0,null,null,{"$f":"W72","v":0},0,0,null,null,{"$f":"AB72","v":0},0,0,{"$f":"AE72","v":0},{"$f":"AF72","v":0},null,null,{"$f":"AI72","v":0},{"$f":"AJ72","v":0}]
[null,null,null,null,null,"TOTAL",{"$f":"G73","v":0},null,null,null,null,null,{"$f":"M73","v":0},null,null,null,null,0,0,0,null,null,0,0,0,null,null,0,0,0,{"$f":"AE73","v":0},{"$f":"AF73","v":0},null,null,{"$f":"AI73","v":0},{"$f":"AJ73","v":0}]
[0.05]
[0.25,null,null,"SIGNS",null,null,"CONCRETE",null,"I-BEAM POSTS*",null,null,null,null,null,null," PIPE POSTS*",null,null,"4\"SQUARE",null,null,null,null,null,null," PERFORATED SQUARE STEEL TUBE**",null,null,null,null,null,"U-",null,"  ALUMINUM",null,"COLUMN","EFFECTIVE: 07-01-2026"]
[0.25,null,null,null,null,null,"FOOTINGS",null,null,null,null,null,null,null,null,null,null,null,"  STEEL",null,null,null,null,"2\" POST  ",null,null,null,null,"2.5\" POST  ",null,"BREAK-","CHANNEL",null,"  BACKING",null,"MOUNTING"]
[0.25,"  902 SIGNAL SIGNS TABULATED ON D-37A",null,null,null,null,"EMBEDDED",null,null,null,null,null,null,null,null,null,null,null,"  POST*",null,null," POST",null,"    ANCHORS",null,null," POST",null,"    ANCHORS",null,"AWAY","POST",null,"  BARS",null,"C-CHANNEL"]
[0.25,null,null,null,null,"SIGN","(I-BEAM/PIPE)",null,null,null,null,null,"TOTAL",null,null,null,null,"TOTAL","BASE","POST",null,null,"TOTAL","DRIVEN","CONCRETE",null,null,"TOTAL","DRIVEN","CONCRETE","ASSEMBLY",null,"COUNT  ","LENGTH","TOTAL",null,"REMARKS AND"]
[0.25,"SIGN","SIGN","STATION/","LOCATION","DTL","ITEM NO.",null,"    POST + STUB",null,null,"LBS","ITEM NO.",null,"POST + STUB",null,"LBS","ITEM NO.","ITEM NO.","ITEM NO.","NO.1","NO.2","ITEM NO.","ITEM NO.","ITEM NO.","NO.1","NO.2","ITEM NO.","ITEM NO.","ITEM NO.","ITEM NO.","ITEM NO.",null,null,"ITEM NO.","ITEM NO.","OTHER REQUIRED ITEMS"]
[0.25,"NO.","SIZE","LOG MILE",null,"SHT",9031010,"DES","NO.1","NO.2","NO.3","PER",9031210,"SIZE","NO.1","NO.2","PER",9031220,9031005,9031230,null,null,"9031270A","9031273A",9031274,null,null,9031280,"9031281A",9031285,9031241,"9031250A",null,null,9035030,9035031]
[0.25,null,null,null,null,"NO.","CY","NO.","LF","LF","LF","FT","LBS","IN.","LF","LF","FT","LBS","EACH","LF","LF","LF","LF","EACH","EACH","LF","LF","LF","EACH","EACH","EACH","LF","EACH","IN.","LF","LF"]
[0.25,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(I12+J12+K12)*L12","v":0},null,null,null,null,{"$f":"(O12+P12)*Q12","v":0},null,null,null,null,{"$f":"U12+V12","v":0},null,null,null,null,{"$f":"Z12+AA12","v":0},null,null,{"$f":"IF(AA12>0,COUNT(Z12:AA12),\"\")","v":""},null,null,null,{"$f":"(AG12*AH12)/12","v":0}]
[0.25,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,{"$f":"IF(AA13>0,COUNT(Z13:AA13),\"\")","v":""},null,null,null,{"$f":"(AG13*AH13)/12","v":0}]
[0.25,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,{"$f":"IF(AA14>0,COUNT(Z14:AA14),\"\")","v":""},null,null,null,0]
[0.25,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,{"$f":"IF(AA15>0,COUNT(Z15:AA15),\"\")","v":""},null,null,null,0]
[0.25,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,{"$f":"IF(AA16>0,COUNT(Z16:AA16),\"\")","v":""},null,null,null,0]
[0.25,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,{"$f":"IF(AA17>0,COUNT(Z17:AA17),\"\")","v":""},null,null,null,0]
[0.25,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,{"$f":"IF(AA18>0,COUNT(Z18:AA18),\"\")","v":""},null,null,null,0]
[0.25,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,{"$f":"IF(AA19>0,COUNT(Z19:AA19),\"\")","v":""},null,null,null,0]
[0.25,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,{"$f":"IF(AA20>0,COUNT(Z20:AA20),\"\")","v":""},null,null,null,0]
[0.25,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,{"$f":"IF(AA21>0,COUNT(Z21:AA21),\"\")","v":""},null,null,null,0]
[0.25,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,{"$f":"IF(AA22>0,COUNT(Z22:AA22),\"\")","v":""},null,null,null,0]
[0.25,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,{"$f":"IF(AA23>0,COUNT(Z23:AA23),\"\")","v":""},null,null,null,0]
[0.25,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,{"$f":"IF(AA24>0,COUNT(Z24:AA24),\"\")","v":""},null,null,null,0]
[0.25,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,{"$f":"IF(AA25>0,COUNT(Z25:AA25),\"\")","v":""},null,null,null,0]
[0.25,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,{"$f":"IF(AA26>0,COUNT(Z26:AA26),\"\")","v":""},null,null,null,0]
[0.25,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,{"$f":"IF(AA27>0,COUNT(Z27:AA27),\"\")","v":""},null,null,null,0]
[0.25,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,{"$f":"IF(AA28>0,COUNT(Z28:AA28),\"\")","v":""},null,null,null,0]
[0.25,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,{"$f":"IF(AA29>0,COUNT(Z29:AA29),\"\")","v":""},null,null,null,0]
[0.25,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,{"$f":"IF(AA30>0,COUNT(Z30:AA30),\"\")","v":""},null,null,null,0]
[0.25,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,{"$f":"IF(AA31>0,COUNT(Z31:AA31),\"\")","v":""},null,null,null,0]
[0.25,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,{"$f":"IF(AA32>0,COUNT(Z32:AA32),\"\")","v":""},null,null,null,0]
[0.25,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,{"$f":"IF(AA33>0,COUNT(Z33:AA33),\"\")","v":""},null,null,null,0]
[0.25,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,{"$f":"IF(AA34>0,COUNT(Z34:AA34),\"\")","v":""},null,null,null,0]
[0.25,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,{"$f":"IF(AA35>0,COUNT(Z35:AA35),\"\")","v":""},null,null,null,0]
[0.25,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,{"$f":"IF(AA36>0,COUNT(Z36:AA36),\"\")","v":""},null,null,null,0]
[0.25,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,{"$f":"IF(AA37>0,COUNT(Z37:AA37),\"\")","v":""},null,null,null,0]
[0.25,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,{"$f":"IF(AA38>0,COUNT(Z38:AA38),\"\")","v":""},null,null,null,0]
[0.25,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,{"$f":"IF(AA39>0,COUNT(Z39:AA39),\"\")","v":""},null,null,null,0]
[0.25,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,{"$f":"IF(AA40>0,COUNT(Z40:AA40),\"\")","v":""},null,null,null,0]
[0.25,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,{"$f":"IF(AA41>0,COUNT(Z41:AA41),\"\")","v":""},null,null,null,0]
[0.25,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,{"$f":"IF(AA42>0,COUNT(Z42:AA42),\"\")","v":""},null,null,null,0]
[0.25,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,{"$f":"IF(AA43>0,COUNT(Z43:AA43),\"\")","v":""},null,null,null,0]
[0.25,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(I44+J44+K44)*L44","v":0},null,null,null,null,{"$f":"(O44+P44)*Q44","v":0},null,null,null,null,{"$f":"U44+V44","v":0},null,null,null,null,{"$f":"Z44+AA44","v":0},null,null,{"$f":"IF(AA44>0,COUNT(Z44:AA44),\"\")","v":""},null,null,null,0]
[0.25,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,{"$f":"IF(AA45>0,COUNT(Z45:AA45),\"\")","v":""},null,null,null,0]
[0.25,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,{"$f":"IF(AA46>0,COUNT(Z46:AA46),\"\")","v":""},null,null,null,0]
[0.25,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,{"$f":"IF(AA47>0,COUNT(Z47:AA47),\"\")","v":""},null,null,null,0]
[0.25,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,{"$f":"IF(AA48>0,COUNT(Z48:AA48),\"\")","v":""},null,null,null,0]
[0.25,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,{"$f":"IF(AA49>0,COUNT(Z49:AA49),\"\")","v":""},null,null,null,0]
[0.25,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,{"$f":"IF(AA50>0,COUNT(Z50:AA50),\"\")","v":""},null,null,null,0]
[0.25,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,{"$f":"IF(AA51>0,COUNT(Z51:AA51),\"\")","v":""},null,null,null,0]
[0.25,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,{"$f":"IF(AA52>0,COUNT(Z52:AA52),\"\")","v":""},null,null,null,0]
[0.25,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,{"$f":"IF(AA53>0,COUNT(Z53:AA53),\"\")","v":""},null,null,null,0]
[0.25,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,{"$f":"IF(AA54>0,COUNT(Z54:AA54),\"\")","v":""},null,null,null,0]
[0.25,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,{"$f":"IF(AA55>0,COUNT(Z55:AA55),\"\")","v":""},null,null,null,0]
[0.25,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,{"$f":"IF(AA56>0,COUNT(Z56:AA56),\"\")","v":""},null,null,null,0]
[0.25,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,{"$f":"IF(AA57>0,COUNT(Z57:AA57),\"\")","v":""},null,null,null,0]
[0.25,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,{"$f":"IF(AA58>0,COUNT(Z58:AA58),\"\")","v":""},null,null,null,0]
[0.25,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,{"$f":"IF(AA59>0,COUNT(Z59:AA59),\"\")","v":""},null,null,null,0]
[0.25,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,{"$f":"IF(AA60>0,COUNT(Z60:AA60),\"\")","v":""},null,null,null,0]
[0.25,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,{"$f":"IF(AA61>0,COUNT(Z61:AA61),\"\")","v":""},null,null,null,0]
[0.25,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,{"$f":"IF(AA62>0,COUNT(Z62:AA62),\"\")","v":""},null,null,null,0]
[0.25,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,{"$f":"IF(AA63>0,COUNT(Z63:AA63),\"\")","v":""},null,null,null,0]
[0.25,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,{"$f":"IF(AA64>0,COUNT(Z64:AA64),\"\")","v":""},null,null,null,0]
[0.25,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,{"$f":"IF(AA65>0,COUNT(Z65:AA65),\"\")","v":""},null,null,null,0]
[0.25,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,{"$f":"IF(AA66>0,COUNT(Z66:AA66),\"\")","v":""},null,null,null,0]
[0.25,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,{"$f":"IF(AA67>0,COUNT(Z67:AA67),\"\")","v":""},null,null,null,0]
[0.25,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,{"$f":"IF(AA68>0,COUNT(Z68:AA68),\"\")","v":""},null,null,null,0]
[0.25,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,{"$f":"IF(AA69>0,COUNT(Z69:AA69),\"\")","v":""},null,null,null,0]
[0.25,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,{"$f":"IF(AA70>0,COUNT(Z70:AA70),\"\")","v":""},null,null,null,0]
[0.25,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,{"$f":"IF(AA71>0,COUNT(Z71:AA71),\"\")","v":""},null,null,null,0]
[0.3,null,null,null,null,"SUBTOTAL",{"$f":"ROUNDUP(SUM(G12:G71),2)","v":0},null,null,null,null,null,{"$f":"ROUNDUP(SUM(M12:M71),0)","v":0},null,null,null,null,{"$f":"ROUNDUP(SUM(R12:R71),0)","v":0},{"$f":"SUM(S12:S71)","v":0},{"$f":"SUM(T12:T71)","v":0},null,null,{"$f":"SUM(W12:W71)","v":0},{"$f":"SUM(X12:X71)","v":0},{"$f":"SUM(Y12:Y71)","v":0},null,null,{"$f":"SUM(AB12:AB71)","v":0},{"$f":"SUM(AC12:AC71)","v":0},{"$f":"SUM(AD12:AD71)","v":0},{"$f":"SUM(AE12:AE71)","v":0},{"$f":"ROUNDUP(SUM(AF12:AF71),1)","v":0},null,null,{"$f":"ROUNDUP(SUM(AI12:AI71),1)","v":0},{"$f":"ROUNDUP(SUM(AJ12:AJ71),1)","v":0}]
[0.3,null,null,null,null,"TOTAL",{"$f":"ROUNDUP(G72,1)","v":0},null,null,null,null,null,{"$f":"ROUNDUP(M72,-1)","v":0},null,null,null,null,{"$f":"ROUNDUP(R72,-1)","v":0},{"$f":"S72","v":0},{"$f":"T72","v":0},null,null,{"$f":"W72","v":0},{"$f":"X72","v":0},0,null,null,{"$f":"AB72","v":0},{"$f":"AC72","v":0},0,{"$f":"AE72","v":0},{"$f":"ROUNDUP(AF72,0)","v":0},null,null,{"$f":"ROUNDUP(AI72,0)","v":0},{"$f":"ROUNDUP(AJ72,0)","v":0}]
[0.4,null,null,null,null,null,null," *BREAKAWAY ASSEMBLY IS INCIDENTAL FOR I-BEAM, PIPE AND 4\" SQUARE STEEL POSTS."]
[0.3,null,null,null,null,null,null,"**FOR PSST WITHOUT BREAKAWAY DEVICES, POST LENGTH SHALL INCLUDE AN ADDITIONAL 6\" FOR INSERTION INTO ANCHOR;"]
[0.25,null,null,null,null,null,null,"  FOR SURFACED MOUNTED PSST ON ISLANDS, NO ANCHOR IS USED, JUST A SURFACE MOUNT BREAKAWAY ASSEMBLY."]
[]
[]
["CONCRETE FOOTINGS",null,null,"STD 903.03 SHEET 1","I-BEAM POSTS"]
[null,null,null,"STD 903.03 SHEET 5","PIPE POSTS"]
[]
["LBS PER FOOT",null,null,"STD 903.03 SHEET 2","I-BEAM POSTS"]
[null,null,null,"STD 903.03 SHEET 5","PIPE POSTS"]
[]
["BACKING BARS",null,null,"STD 903.02 SHEET 4"]
[]
["PSST BREAKAWAYS",null,null,"EPG  903.16.4.4"]

{"sheet":"D-30","index":3,"n_rows":93,"n_cols":76,"rows_kept":93,"cut":false,"hidden":false,"merged":[[6,7,8,9],[6,10,8,12],[6,13,8,15],[6,16,8,18],[6,4,8,6],[6,34,8,36],[6,37,8,39],[6,40,8,42],[6,43,8,45],[6,46,8,48],[6,19,8,21],[6,22,8,24],[6,25,8,27],[6,28,8,30],[6,31,8,33],[6,49,8,51],[6,52,8,54],[6,55,8,57],[6,58,8,60],[6,61,8,63]]}
[null,0.5,1,1,0.3,0.2,0.3,0.3,0.2,0.3,0.3,0.2,0.3,0.3,0.2,0.3,0.3,0.2,0.3,0.3,0.2,0.3,0.3,0.2,0.3,0.3,0.2,0.3,0.3,0.2,0.3,0.3,0.2,0.3,0.3,0.2,0.3,0.3,0.2,0.3,0.3,0.2,0.3,0.3,0.2,0.3,0.3,0.2,0.3,0.3,0.2,0.3,0.3,0.2,0.3,0.3,0.2,0.3,0.3,0.2,0.3,0.3,0.2,0.3,0.54210000000000003,1,2,0.5,0.5,1,1.3,1.3,1.3,1.3,0]
[null,null,null,"TOTALS",null,{"$f":"F75","v":1},null,null,{"$f":"I75","v":0},null,null,{"$f":"L75","v":0},null,null,{"$f":"O75","v":0},null,null,{"$f":"R75","v":0},null,null,{"$f":"U75","v":0},null,null,{"$f":"X75","v":0},null,null,{"$f":"AA75","v":0},null,null,{"$f":"AD75","v":0},null,null,{"$f":"AG75","v":0},null,null,{"$f":"AJ75","v":0},null,null,{"$f":"AM75","v":0},null,null,{"$f":"AP75","v":0},null,null,{"$f":"AS75","v":0},null,null,{"$f":"AV75","v":0},null,null,{"$f":"AY75","v":0},null,null,{"$f":"BB75","v":0},null,null,{"$f":"BE75","v":0},null,null,{"$f":"BH75","v":0},null,null,{"$f":"BK75","v":0},null,null,null,null,null,null,"TOTALS",{"$f":"BS75","v":0},{"$f":"BT75","v":16},0,0]
[]
[0.05]
[0.3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STANDARD SIGN ASSEMBLIES",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SIGN SUMMARY",null,null,null,"EFFECTIVE: 10-01-2016"]
[0.25,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SIGN, TYPE, DESIGNATION, SIZE & NUMBER OF EACH",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TYPE & SQUARE FEET",null,null,null,"SH"]
[0.25,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SIGN",null,null,null,"FLAT SHEET",null,"STRUCTURAL",null,"SHF"]
[0.25,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STANDARD OR SPECIAL",null,"DTL","NO.","SIGN","FLAT SHEET","FLUORESCENT","STRUCTURAL","FLUORESCENT",null,"ST"]
[0.25,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," SIGN DESIGNATION",null,"SHT","EACH","SIZE","SH","SHF*","ST","STF*",null,"STF"]
[0.25,"SIGN","STATION/","LOCATION",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NO.",null,null,"ITEM NO.","ITEM NO.","ITEM NO.","ITEM NO.",null,{"$f":"_xlfn.TEXTBEFORE(BS12,\"\"\"\")*_xlfn.TEXTBEFORE(_xlfn.TEXTAFTER(BS12,\"x\",1,1),\"\"\"\")/144","v":{"$error":"#N/A"}}]
[0.25,"NO.","LOG MILE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"9035004A","9035069A","9035011A","9035071A",null,"SF"]
[0.25,null,null,null,"SHF","W1-1","48 x 48",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"OFFSET(C$12,0,3*(ROW()-ROW(BN$11)))","v":"W1-1"},null,null,{"$f":"OFFSET(C$75,0,3*(ROW()-ROW(BQ$11)))","v":1},{"$f":"OFFSET(D$12,0,3*(ROW()-ROW(BR$11)))","v":"48 x 48"},{"$f":"IF(OFFSET($B$12,0,3*(ROW()-ROW(BS$11)))=\"SH\",$BQ12*$BX12,)","v":0},{"$f":"IF(OFFSET($B$12,0,3*(ROW()-ROW(BT$11)))=\"SHF\",$BQ12*$BX12,)","v":16},{"$f":"IF(OFFSET($B$12,0,3*(ROW()-ROW(BU$11)))=\"ST\",$BQ12*$BX12,)","v":0},{"$f":"IF(OFFSET($B$12,0,3*(ROW()-ROW(BV$11)))=\"STF\",$BQ12*$BX12,)","v":0},null,{"$f":"_xlfn.TEXTBEFORE(BR12,\"x\",1,1)*_xlfn.TEXTAFTER(BR12,\"x\",1,1)/144","v":16}]
[0.25,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,0,0,0,0,null,{"$f":"_xlfn.TEXTBEFORE(BR13,\"x\",1,1)*_xlfn.TEXTAFTER(BR13,\"x\",1,1)/144","v":{"$error":"#N/A"}}]
[0.25,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,0,0,0,0,null,{"$error":"#N/A"}]
[0.25,null,null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,0,0,0,0,null,{"$error":"#N/A"}]
[0.25,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,0,0,0,0,null,{"$error":"#N/A"}]
[0.25,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,0,0,0,0,null,{"$error":"#N/A"}]
[0.25,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,0,0,0,0,null,{"$error":"#N/A"}]
[0.25,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,0,0,0,0,null,{"$error":"#N/A"}]
[0.25,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,0,0,0,0,null,{"$error":"#N/A"}]
[0.25,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,0,0,0,0,null,{"$error":"#N/A"}]
[0.25,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,0,0,0,0,null,{"$error":"#N/A"}]
[0.25,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,0,0,0,0,null,{"$error":"#N/A"}]
[0.25,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,0,0,0,0,null,{"$error":"#N/A"}]
[0.25,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,0,0,0,0,null,{"$error":"#N/A"}]
[0.25,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,0,0,0,0,null,{"$error":"#N/A"}]
[0.25,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,0,0,0,0,null,{"$error":"#N/A"}]
[0.25,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,0,0,0,0,null,{"$error":"#N/A"}]
[0.25,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,0,0,0,0,null,{"$error":"#N/A"}]
[0.25,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,0,0,0,0,null,{"$error":"#N/A"}]
[0.25,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,0,0,0,0,null,{"$error":"#N/A"}]
[0.25]
[0.25]
[0.25]
[0.25]
[0.25]
[0.25]
[0.25]
[0.25]
[0.25]
[0.25]
[0.25]
[0.25]
[0.25]
[0.25]
[0.25]
[0.25]
[0.25]
[0.25]
[0.25]
[0.25]
[0.25]
[0.25]
[0.25]
[0.25]
[0.25]
[0.25]
[0.25]
[0.25]
[0.25]
[0.25]
[0.25]
[0.25]
[0.25]
[0.25]
[0.25]
[0.25]
[0.25]
[0.25]
[0.25]
[0.25]
[0.25]
[0.25]
[0.25]
[0.25,null,null,"TOTALS",null,{"$f":"SUM(F15:F74)","v":1},null,null,{"$f":"SUM(I15:I74)","v":0},null,null,{"$f":"SUM(L15:L74)","v":0},null,null,{"$f":"SUM(O15:O74)","v":0},null,null,{"$f":"SUM(R15:R74)","v":0},null,null,{"$f":"SUM(U15:U74)","v":0},null,null,{"$f":"SUM(X15:X74)","v":0},null,null,{"$f":"SUM(AA15:AA74)","v":0},null,null,{"$f":"SUM(AD15:AD74)","v":0},null,null,{"$f":"SUM(AG15:AG74)","v":0},null,null,{"$f":"SUM(AJ15:AJ74)","v":0},null,null,{"$f":"SUM(AM15:AM74)","v":0},null,null,{"$f":"SUM(AP15:AP74)","v":0},null,null,{"$f":"SUM(AS15:AS74)","v":0},null,null,{"$f":"SUM(AV15:AV74)","v":0},null,null,{"$f":"SUM(AY15:AY74)","v":0},null,null,{"$f":"SUM(BB15:BB74)","v":0},null,null,{"$f":"SUM(BE15:BE74)","v":0},null,null,{"$f":"SUM(BH15:BH74)","v":0},null,null,{"$f":"SUM(BK15:BK74)","v":0},null,null,null,null,null,null,"TOTALS",{"$f":"ROUNDUP(SUM(BS12:BS74),0)","v":0},{"$f":"ROUNDUP(SUM(BT12:BT74),0)","v":16},0,0]
[0.25,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"*ORANGE, YELLOW AND YELLOW-GREEN"]
[0.25]
[0.25]
[0.25]
[0.25]
[0.25]
[0.25]
[0.25]
[0.25]
[0.25]
[0.25]
[0.25]
[0.25]
[0.25]
[0.25]
[0.25]
[0.25]
[0.25]