{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["PAVEMENT MARKINGS"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":1,"defined_names":2,"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":"PAVEMENT MARKINGS","index":0,"n_rows":321,"n_cols":32,"rows_kept":321,"cut":false,"hidden":false,"merged":[[7,3,8,5],[86,3,87,5],[165,3,166,5],[244,3,245,5],[184,1,185,1],[198,1,199,1],[215,1,218,1],[263,1,264,1],[277,1,278,1],[277,4,278,4],[195,3,195,14],[57,14,57,16],[58,14,59,14],[58,15,58,16],[57,4,60,6],[61,4,61,6],[57,10,59,10],[57,11,58,12],[57,3,60,3],[57,7,60,7],[57,8,59,8],[57,9,59,9],[53,6,53,9],[54,3,54,14],[26,1,27,1],[40,1,41,1],[57,1,60,1],[105,1,106,1],[119,1,120,1],[136,1,139,1],[255,6,255,9],[255,21,255,28],[256,21,256,28],[250,6,250,9],[250,11,250,14],[255,11,255,14],[250,21,250,28],[254,6,254,9],[202,18,202,28],[203,11,203,14],[203,16,203,17],[207,11,207,14],[208,6,208,9],[208,11,208,14],[208,16,208,17],[208,18,208,28],[180,21,180,28],[178,21,178,28],[267,6,267,9],[267,11,267,14],[267,18,267,28],[268,6,268,9],[268,11,268,14],[268,18,268,28],[269,6,269,9],[269,11,269,14],[294,1,297,1],[274,3,274,14],[274,18,274,28],[275,3,276,28],[277,3,278,3],[277,6,278,9],[277,11,278,14],[269,18,269,28],[270,6,270,9],[270,11,270,14],[270,18,270,28],[271,6,271,9],[271,11,271,14],[271,18,271,28],[272,6,272,9],[272,11,272,14],[259,11,259,14],[259,21,259,28],[260,3,260,14],[261,3,262,28],[263,3,264,3],[263,4,264,4],[263,6,264,9],[263,11,264,14],[263,15,264,15],[263,16,263,17],[263,18,264,28],[198,4,199,4],[198,6,199,9],[198,11,199,14],[200,6,200,9],[200,11,200,14],[177,6,177,9],[177,11,177,14],[178,6,178,9],[181,3,181,14],[182,3,183,28],[184,3,185,3],[184,4,185,4],[184,6,185,9],[184,11,185,14],[184,15,185,15],[184,16,184,17],[184,18,185,28],[181,21,181,28],[186,6,186,9],[200,16,200,17],[200,18,200,28],[186,11,186,14],[186,18,186,28],[175,11,175,14],[175,21,175,28],[169,6,169,9],[169,11,169,14],[198,15,199,15],[198,16,199,17],[198,18,199,28],[176,6,176,9],[176,21,176,28],[177,21,177,28],[171,6,171,9],[171,11,171,14],[176,11,176,14],[171,21,171,28],[175,6,175,9],[178,11,178,14],[179,6,179,9],[179,11,179,14],[179,21,179,28],[180,6,180,9],[180,11,180,14],[195,18,195,28],[196,3,197,28],[198,3,199,3],[129,18,129,28],[102,21,102,28],[136,10,138,10],[136,11,137,12],[136,13,138,13],[136,14,136,16],[137,14,138,14],[137,15,137,16],[102,3,102,14],[103,3,104,28],[105,3,106,3],[105,4,106,4],[105,6,106,9],[105,11,106,14],[105,15,106,15],[105,16,105,17],[105,18,106,28],[107,6,107,9],[107,11,107,14],[107,18,107,28],[108,6,108,9],[108,11,108,14],[108,18,108,28],[124,18,124,28],[128,18,128,28],[96,11,96,14],[96,21,96,28],[90,6,90,9],[90,11,90,14],[119,15,120,15],[119,16,120,17],[119,18,120,28],[97,6,97,9],[97,21,97,28],[98,21,98,28],[91,6,91,9],[91,11,91,14],[92,6,92,9],[92,11,92,14],[97,11,97,14],[90,21,90,28],[91,21,91,28],[92,21,92,28],[96,6,96,9],[99,11,99,14],[100,6,100,9],[100,11,100,14],[100,21,100,28],[37,18,37,28],[26,15,27,15],[33,18,33,28],[30,18,30,28],[31,11,31,14],[51,16,51,17],[51,18,51,28],[52,16,52,17],[52,18,52,28],[49,16,49,17],[49,18,49,28],[50,16,50,17],[50,18,50,28],[44,16,44,17],[44,18,44,28],[34,18,34,28],[48,16,48,17],[47,16,47,17],[46,16,46,17],[6,3,6,28],[78,24,78,28],[72,24,72,28],[73,24,73,28],[58,19,59,19],[57,24,60,28],[18,6,18,9],[79,24,79,28],[80,4,80,6],[11,11,11,14],[12,11,12,14],[13,11,13,14],[79,4,79,6],[61,24,61,28],[77,24,77,28],[62,24,62,28],[63,24,63,28],[80,24,80,28],[57,23,59,23],[57,17,57,20],[57,21,57,22],[58,20,59,20],[58,21,58,22],[57,13,59,13],[81,24,81,28],[64,24,64,28],[65,24,65,28],[69,24,69,28],[70,24,70,28],[71,24,71,28],[74,24,74,28],[75,24,75,28],[76,24,76,28],[53,11,53,14],[55,3,56,28],[53,16,53,17],[53,18,53,28],[54,18,54,28],[51,6,51,9],[52,6,52,9],[51,11,51,14],[52,11,52,14],[54,16,54,17],[35,6,35,9],[35,18,35,28],[34,11,34,14],[36,6,36,9],[37,3,37,14],[44,6,44,9],[50,6,50,9],[44,11,44,14],[50,11,50,14],[49,11,49,14],[42,6,42,9],[43,6,43,9],[42,11,42,14],[43,11,43,14],[45,11,45,14],[45,16,45,17],[45,18,45,28],[42,16,42,17],[42,18,42,28],[43,16,43,17],[43,18,43,28],[40,15,41,15],[40,16,41,17],[40,18,41,28],[28,6,28,9],[28,18,28,28],[29,6,29,9],[26,18,27,28],[26,16,26,17],[22,11,22,14],[29,11,29,14],[8,26,8,27],[7,26,7,27],[29,18,29,28],[28,11,28,14],[18,21,18,28],[19,21,19,28],[20,21,20,28],[11,21,11,28],[12,21,12,28],[13,21,13,28],[17,21,17,28],[9,15,9,17],[9,18,9,20],[9,21,10,28],[21,21,21,28],[22,21,22,28],[23,21,23,28],[26,3,27,3],[26,4,27,4],[26,6,27,9],[9,11,10,14],[23,3,23,14],[19,11,19,14],[20,11,20,14],[7,6,8,25],[26,11,27,14],[9,3,10,3],[9,4,10,4],[9,6,10,9],[20,6,20,9],[21,6,21,9],[22,6,22,9],[18,11,18,14],[17,6,17,9],[17,11,17,14],[11,6,11,9],[12,6,12,9],[13,6,13,9],[19,6,19,9],[24,3,25,28],[21,11,21,14],[76,4,76,6],[77,4,77,6],[78,4,78,6],[71,4,71,6],[72,4,72,6],[73,4,73,6],[74,4,74,6],[75,4,75,6],[81,3,81,7],[30,6,30,9],[30,11,30,14],[62,4,62,6],[63,4,63,6],[64,4,64,6],[65,4,65,6],[69,4,69,6],[70,4,70,6],[31,18,31,28],[32,18,32,28],[38,3,39,28],[32,6,32,9],[33,6,33,9],[32,11,32,14],[33,11,33,14],[31,6,31,9],[35,11,35,14],[36,11,36,14],[40,3,41,3],[40,4,41,4],[40,6,41,9],[40,11,41,14],[36,18,36,28],[34,6,34,9],[85,3,85,28],[86,26,86,27],[87,26,87,27],[86,6,87,25],[88,3,89,3],[88,4,89,4],[88,6,89,9],[88,11,89,14],[88,15,88,17],[88,18,88,20],[88,21,89,28],[101,6,101,9],[101,11,101,14],[101,21,101,28],[99,21,99,28],[98,6,98,9],[98,11,98,14],[99,6,99,9],[109,6,109,9],[109,11,109,14],[109,18,109,28],[110,6,110,9],[110,11,110,14],[110,18,110,28],[111,6,111,9],[111,11,111,14],[111,18,111,28],[112,6,112,9],[112,11,112,14],[112,18,112,28],[113,6,113,9],[113,11,113,14],[113,18,113,28],[114,6,114,9],[114,11,114,14],[114,18,114,28],[115,6,115,9],[115,11,115,14],[115,18,115,28],[116,3,116,14],[116,18,116,28],[117,3,118,28],[119,3,120,3],[119,4,120,4],[119,6,120,9],[119,11,120,14],[121,6,121,9],[121,11,121,14],[122,6,122,9],[122,11,122,14],[121,16,121,17],[121,18,121,28],[122,16,122,17],[122,18,122,28],[123,6,123,9],[123,11,123,14],[123,16,123,17],[123,18,123,28],[124,11,124,14],[124,16,124,17],[128,11,128,14],[129,6,129,9],[129,11,129,14],[130,6,130,9],[130,11,130,14],[131,6,131,9],[131,11,131,14],[130,16,130,17],[129,16,129,17],[128,16,128,17],[130,18,130,28],[131,16,131,17],[131,18,131,28],[132,6,132,9],[132,11,132,14],[133,3,133,14],[132,16,132,17],[132,18,132,28],[133,18,133,28],[134,3,135,28],[136,3,139,3],[136,4,139,6],[136,7,139,7],[136,8,138,8],[136,9,138,9],[136,23,138,23],[136,24,139,28],[136,17,136,20],[136,21,136,22],[137,20,138,20],[137,21,137,22],[137,19,138,19],[140,4,140,6],[140,24,140,28],[141,4,141,6],[141,24,141,28],[142,4,142,6],[142,24,142,28],[143,4,143,6],[143,24,143,28],[144,4,144,6],[144,24,144,28],[148,4,148,6],[148,24,148,28],[149,4,149,6],[149,24,149,28],[150,4,150,6],[150,24,150,28],[151,4,151,6],[151,24,151,28],[152,4,152,6],[152,24,152,28],[153,4,153,6],[153,24,153,28],[154,4,154,6],[154,24,154,28],[155,4,155,6],[155,24,155,28],[156,4,156,6],[156,24,156,28],[157,4,157,6],[157,24,157,28],[158,4,158,6],[158,24,158,28],[159,4,159,6],[159,24,159,28],[160,3,160,7],[160,24,160,28],[164,3,164,28],[165,26,165,27],[166,26,166,27],[165,6,166,25],[167,3,168,3],[167,4,168,4],[167,6,168,9],[167,11,168,14],[167,15,167,17],[167,18,167,20],[167,21,168,28],[170,6,170,9],[170,11,170,14],[169,21,169,28],[170,21,170,28],[187,6,187,9],[187,11,187,14],[187,18,187,28],[188,6,188,9],[188,11,188,14],[188,18,188,28],[189,6,189,9],[189,11,189,14],[189,18,189,28],[190,6,190,9],[190,11,190,14],[190,18,190,28],[191,6,191,9],[191,11,191,14],[191,18,191,28],[192,6,192,9],[192,11,192,14],[192,18,192,28],[193,6,193,9],[193,11,193,14],[193,18,193,28],[194,6,194,9],[194,11,194,14],[194,18,194,28],[209,6,209,9],[209,11,209,14],[210,6,210,9],[210,11,210,14],[209,16,209,17],[209,18,209,28],[210,16,210,17],[210,18,210,28],[203,18,203,28],[207,16,207,17],[207,18,207,28],[201,6,201,9],[201,11,201,14],[201,16,201,17],[201,18,201,28],[202,6,202,9],[202,11,202,14],[202,16,202,17],[211,6,211,9],[211,11,211,14],[212,3,212,14],[211,16,211,17],[211,18,211,28],[212,18,212,28],[213,3,214,28],[215,3,218,3],[215,4,218,6],[215,7,218,7],[215,8,217,8],[215,9,217,9],[215,23,217,23],[215,24,218,28],[215,17,215,20],[215,21,215,22],[216,20,217,20],[216,21,216,22],[216,19,217,19],[215,10,217,10],[215,11,216,12],[215,13,217,13],[215,14,215,16],[216,14,217,14],[216,15,216,16],[219,4,219,6],[219,24,219,28],[220,4,220,6],[220,24,220,28],[221,4,221,6],[221,24,221,28],[222,4,222,6],[222,24,222,28],[223,4,223,6],[223,24,223,28],[227,4,227,6],[227,24,227,28],[228,4,228,6],[228,24,228,28],[229,4,229,6],[229,24,229,28],[230,4,230,6],[230,24,230,28],[231,4,231,6],[231,24,231,28],[232,4,232,6],[232,24,232,28],[233,4,233,6],[233,24,233,28],[234,4,234,6],[234,24,234,28],[235,4,235,6],[235,24,235,28],[236,4,236,6],[236,24,236,28],[237,4,237,6],[237,24,237,28],[238,4,238,6],[238,24,238,28],[239,3,239,7],[239,24,239,28],[243,3,243,28],[244,26,244,27],[245,26,245,27],[244,6,245,25],[246,3,247,3],[246,4,247,4],[246,6,247,9],[246,11,247,14],[246,15,246,17],[246,18,246,20],[246,21,247,28],[249,6,249,9],[249,11,249,14],[248,21,248,28],[249,21,249,28],[265,11,265,14],[265,18,265,28],[266,6,266,9],[266,11,266,14],[266,18,266,28],[256,6,256,9],[256,11,256,14],[257,6,257,9],[254,11,254,14],[254,21,254,28],[248,6,248,9],[248,11,248,14],[257,11,257,14],[257,21,257,28],[258,6,258,9],[258,11,258,14],[260,21,260,28],[265,6,265,9],[258,21,258,28],[259,6,259,9],[272,18,272,28],[273,6,273,9],[273,11,273,14],[273,18,273,28],[281,6,281,9],[281,11,281,14],[281,16,281,17],[281,18,281,28],[279,6,279,9],[279,11,279,14],[280,6,280,9],[280,11,280,14],[279,16,279,17],[279,18,279,28],[280,16,280,17],[280,18,280,28],[277,15,278,15],[277,16,278,17],[277,18,278,28],[282,11,282,14],[282,16,282,17],[286,11,286,14],[287,6,287,9],[287,11,287,14],[282,18,282,28],[286,16,286,17],[286,18,286,28],[287,16,287,17],[287,18,287,28],[288,6,288,9],[288,11,288,14],[289,6,289,9],[289,11,289,14],[288,16,288,17],[288,18,288,28],[289,16,289,17],[289,18,289,28],[290,6,290,9],[290,11,290,14],[291,3,291,14],[290,16,290,17],[290,18,290,28],[291,18,291,28],[292,3,293,28],[294,3,297,3],[294,4,297,6],[294,7,297,7],[294,8,296,8],[294,9,296,9],[294,23,296,23],[294,24,297,28],[294,17,294,20],[294,21,294,22],[295,20,296,20],[295,21,295,22],[295,19,296,19],[294,10,296,10],[294,11,295,12],[294,13,296,13],[294,14,294,16],[295,14,296,14],[295,15,295,16],[298,4,298,6],[298,24,298,28],[299,4,299,6],[299,24,299,28],[300,4,300,6],[300,24,300,28],[301,4,301,6],[301,24,301,28],[302,4,302,6],[302,24,302,28],[306,4,306,6],[306,24,306,28],[307,4,307,6],[307,24,307,28],[308,4,308,6],[308,24,308,28],[309,4,309,6],[309,24,309,28],[310,4,310,6],[310,24,310,28],[316,4,316,6],[316,24,316,28],[317,4,317,6],[317,24,317,28],[318,3,318,7],[318,24,318,28],[311,4,311,6],[311,24,311,28],[312,4,312,6],[312,24,312,28],[313,4,313,6],[313,24,313,28],[314,4,314,6],[314,24,314,28],[315,4,315,6],[315,24,315,28]]}
[2,null,null,null,null,"SPREADSHEET","1)","SAVE THIS FILE TO THE PROPER FOLDER FOR YOUR PROJECT AS THE SAME NAME AS YOUR DGN (I.E. #####PM001.XLSX)"]
[null,null,null,null,null,"INSTRUCTIONS:","2)","ENTER ALL DATA REQUIRED"]
[null,null,null,null,null,null,"3)","DO NOT REMOVE THE PROTECTION FROM THIS SPREADSHEET, LEAVE THE PROTECTION ON SO THAT YOU DO NOT DELETE NEEDED FORMULAS OR RESIZE SHEET"]
[]
[]
[]
[null,"Page #",null,{"$f":"\"PAVEMENT MARKING SUBSUMMARY SHEET \" &B8","v":"PAVEMENT MARKING SUBSUMMARY SHEET "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"<--- ENTER STARTING SHEET NUMBER"]
[null,null,null,null,null,null,"EDGE LINE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GENERAL SPEC:",null,640]
[null,"Item_Code",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MATERIAL TYPE:",null,644]
[null,"644E00100",null,"CTY","ROUTE",null,"FROM",null,null,null,null,"TO",null,null,null,"WHITE EDGE LINE",null,null,"YELLOW EDGE LINE",null,null,"COMMENTS"]
[null,"Split #",null,null,null,"TRUE LOG",null,null,null,null,"TRUE LOG",null,null,null,null,"TOTAL","HIGHWAY","RAMP","TOTAL","HIGHWAY","RAMP"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Total",null,"TOTAL",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(P12:P23)>0,ROUND(SUM(P12:P23),2),\"0\")","v":"0"},{"$f":"IF(SUM(Q12:Q23)>0,ROUND(SUM(Q12:Q23),2),\"\")","v":""},"",{"$f":"IF(SUM(S12:S23)>0,ROUND(SUM(S12:S23),2),\"0\")","v":"0"},"",""]
[null,"Item_Code",null,"LANE LINE"]
[null,"644E00200"]
[null,"Split #",null,"CTY","ROUTE",null,"FROM",null,null,null,null,"TO",null,null,null,"TOTAL MILES","4\" LANE LINE",null,"COMMENTS"]
[null,null,null,null,null,"TRUE LOG",null,null,null,null,"TRUE LOG",null,null,null,null,null,"DASHED","SOLID"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Total",null,"TOTAL",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(P29:P37)>0,ROUND(SUM(P29:P37),2),\"\")","v":""},{"$f":"IF(SUM(Q29:Q37)>0,ROUND(SUM(Q29:Q37),2),\"\")","v":""},""]
[null,"Item_Code",null,"CENTER LINE"]
[null,"644E00300"]
[null,"Split #",null,"CTY","ROUTE",null,"FROM",null,null,null,null,"TO",null,null,null,"TOTAL MILES","EQUIVALENT                      SOLID LINE",null,"COMMENTS"]
[null,null,null,null,null,"TRUE LOG",null,null,null,null,"TRUE LOG"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Total",null,"TOTAL",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(P43:P54)>0,ROUND(SUM(P43:P54),2),\"\")","v":""},{"$f":"IF(SUM(Q43:R54)>0,ROUND(SUM(Q43:R54),2),\"\")","v":""}]
[null,null,null,"AUXILIARY"]
[]
[null,"Split #",null,"CTY","ROUTE LOCATION",null,null,"TRUE              LOG","CHANNEL                                LINE","STOP                                LINE","CROSS WALK LINES","TRANSVERSE DIAGONAL LINES",null,"ISLAND MARKING","SYMBOL MARKINGS",null,null,"LANE ARROWS",null,null,null,"WORD ON PVMT",null,"DOTTED LINES","COMMENTS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RxR","SCHOOL",null,"TURN","TURN","THRU","COMB.","ONLY"]
[null,null,null,null,null,null,null,null,null,null,null,"WHITE","YELLOW",null,null,"72\"","96\"","LEFT","RIGHT",null,null,"72\"","96\""]
[null,null,null,null,null,null,null,null,"FT","FT","FT","FT","FT","SQ FT","EACH","EACH","EACH","EACH","EACH","EACH","EACH","EACH","EACH","FT"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Total",null,"TOTAL",null,null,null,null,{"$f":"IF(SUM(I62:I81)>0,ROUND(SUM(I62:I81),2),\"\")","v":""},{"$f":"IF(SUM(J62:J81)>0,ROUND(SUM(J62:J81),2),\"\")","v":""},"","","","","","","","","","","","","",""]
[null,null,null,null,null,null,null,"ITEM_CODE","644E00400","644E00500","644E00600","644E00700","644E00700","644E00900","644E01000","644E01100","644E01110","644E01300","644E01300","644E01300","644E01300","644E01400","644E01410","644E01500"]
[null,null,null,null,null,null,null,"ADDITIONAL_DESCRIPTION","",null,"","","","","","","","","","","","","",""]
[]
[null,"Page #",null,{"$f":"\"PAVEMENT MARKING SUBSUMMARY SHEET \" &B87","v":"PAVEMENT MARKING SUBSUMMARY SHEET "}]
[null,null,null,null,null,null,"EDGE LINE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GENERAL SPEC:",null,640]
[null,"Item_Code",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MATERIAL TYPE:",null,644]
[null,"644E00100",null,"CTY","ROUTE",null,"FROM",null,null,null,null,"TO",null,null,null,"WHITE EDGE LINE",null,null,"YELLOW EDGE LINE",null,null,"COMMENTS"]
[null,"Split #",null,null,null,"TRUE LOG",null,null,null,null,"TRUE LOG",null,null,null,null,"TOTAL","HIGHWAY","RAMP","TOTAL","HIGHWAY","RAMP"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Total",null,"TOTAL",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(P91:P102)>0,ROUND(SUM(P91:P102),2),\"\")","v":""},{"$f":"IF(SUM(Q91:Q102)>0,ROUND(SUM(Q91:Q102),2),\"\")","v":""},{"$f":"IF(SUM(R91:R102)>0,ROUND(SUM(R91:R102),2),\"\")","v":""},{"$f":"IF(SUM(S91:S102)>0,ROUND(SUM(S91:S102),2),\"\")","v":""},{"$f":"IF(SUM(T91:T102)>0,ROUND(SUM(T91:T102),2),\"\")","v":""},{"$f":"IF(SUM(U91:U102)>0,ROUND(SUM(U91:U102),2),\"\")","v":""}]
[null,"Item_Code",null,"LANE LINE"]
[null,"644E00200"]
[null,"Split #",null,"CTY","ROUTE",null,"FROM",null,null,null,null,"TO",null,null,null,"TOTAL MILES","4\" LANE LINE",null,"COMMENTS"]
[null,null,null,null,null,"TRUE LOG",null,null,null,null,"TRUE LOG",null,null,null,null,null,"DASHED","SOLID"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Total",null,"TOTAL",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(P108:P116)>0,ROUND(SUM(P108:P116),2),\"\")","v":""},{"$f":"IF(SUM(Q108:Q116)>0,ROUND(SUM(Q108:Q116),2),\"\")","v":""},{"$f":"IF(SUM(R108:R116)>0,ROUND(SUM(R108:R116),2),\"\")","v":""}]
[null,"Item_Code",null,"CENTER LINE"]
[null,"644E00300"]
[null,"Split #",null,"CTY","ROUTE",null,"FROM",null,null,null,null,"TO",null,null,null,"TOTAL MILES","EQUIVALENT                      SOLID LINE",null,"COMMENTS"]
[null,null,null,null,null,"TRUE LOG",null,null,null,null,"TRUE LOG"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Total",null,"TOTAL",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(P122:P133)>0,ROUND(SUM(P122:P133),2),\"\")","v":""},{"$f":"IF(SUM(Q122:R133)>0,ROUND(SUM(Q122:R133),2),\"\")","v":""}]
[null,null,null,"AUXILIARY"]
[]
[null,"Split #",null,"CTY","ROUTE LOCATION",null,null,"TRUE              LOG","CHANNEL                                LINE","STOP                                LINE","CROSS WALK LINES","TRANSVERSE DIAGONAL LINES",null,"ISLAND MARKING","SYMBOL MARKINGS",null,null,"LANE ARROWS",null,null,null,"WORD ON PVMT",null,"DOTTED LINES","COMMENTS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RxR","SCHOOL",null,"TURN","TURN","THRU","COMB.","ONLY"]
[null,null,null,null,null,null,null,null,null,null,null,"WHITE","YELLOW",null,null,"72\"","96\"","LEFT","RIGHT",null,null,"72\"","96\""]
[null,null,null,null,null,null,null,null,"FT","FT","FT","FT","FT","SQ FT","EACH","EACH","EACH","EACH","EACH","EACH","EACH","EACH","EACH","FT"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Total",null,"TOTAL",null,null,null,null,{"$f":"IF(SUM(I141:I160)>0,ROUND(SUM(I141:I160),2),\"\")","v":""},{"$f":"IF(SUM(J141:J160)>0,ROUND(SUM(J141:J160),2),\"\")","v":""},{"$f":"IF(SUM(K141:K160)>0,ROUND(SUM(K141:K160),2),\"\")","v":""},{"$f":"IF(SUM(L141:L160)>0,ROUND(SUM(L141:L160),2),\"\")","v":""},{"$f":"IF(SUM(M141:M160)>0,ROUND(SUM(M141:M160),2),\"\")","v":""},{"$f":"IF(SUM(N141:N160)>0,ROUND(SUM(N141:N160),2),\"\")","v":""},{"$f":"IF(SUM(O141:O160)>0,ROUND(SUM(O141:O160),2),\"\")","v":""},{"$f":"IF(SUM(P141:P160)>0,ROUND(SUM(P141:P160),2),\"\")","v":""},{"$f":"IF(SUM(Q141:Q160)>0,ROUND(SUM(Q141:Q160),2),\"\")","v":""},{"$f":"IF(SUM(R141:R160)>0,ROUND(SUM(R141:R160),2),\"\")","v":""},{"$f":"IF(SUM(S141:S160)>0,ROUND(SUM(S141:S160),2),\"\")","v":""},{"$f":"IF(SUM(T141:T160)>0,ROUND(SUM(T141:T160),2),\"\")","v":""},{"$f":"IF(SUM(U141:U160)>0,ROUND(SUM(U141:U160),2),\"\")","v":""},{"$f":"IF(SUM(V141:V160)>0,ROUND(SUM(V141:V160),2),\"\")","v":""},{"$f":"IF(SUM(W141:W160)>0,ROUND(SUM(W141:W160),2),\"\")","v":""},{"$f":"IF(SUM(X141:X160)>0,ROUND(SUM(X141:X160),2),\"\")","v":""}]
[null,null,null,null,null,null,null,"ITEM_CODE","644E00400","644E00500","644E00600","644E00700","644E00700","644E00900","644E01000","644E01100","644E01110","644E01300","644E01300","644E01300","644E01300","644E01400","644E01410","644E01500"]
[null,null,null,null,null,null,null,"ADDITIONAL_DESCRIPTION","","","","","","","","","","","","","","","",""]
[]
[null,"Page #",null,{"$f":"\"PAVEMENT MARKING SUBSUMMARY SHEET \" &B166","v":"PAVEMENT MARKING SUBSUMMARY SHEET "}]
[null,null,null,null,null,null,"EDGE LINE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GENERAL SPEC:",null,640]
[null,"Item_Code",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MATERIAL TYPE:",null,644]
[null,"644E00100",null,"CTY","ROUTE",null,"FROM",null,null,null,null,"TO",null,null,null,"WHITE EDGE LINE",null,null,"YELLOW EDGE LINE",null,null,"COMMENTS"]
[null,"Split #",null,null,null,"TRUE LOG",null,null,null,null,"TRUE LOG",null,null,null,null,"TOTAL","HIGHWAY","RAMP","TOTAL","HIGHWAY","RAMP"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Total",null,"TOTAL",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(P170:P181)>0,ROUND(SUM(P170:P181),2),\"\")","v":""},{"$f":"IF(SUM(Q170:Q181)>0,ROUND(SUM(Q170:Q181),2),\"\")","v":""},{"$f":"IF(SUM(R170:R181)>0,ROUND(SUM(R170:R181),2),\"\")","v":""},{"$f":"IF(SUM(S170:S181)>0,ROUND(SUM(S170:S181),2),\"\")","v":""},{"$f":"IF(SUM(T170:T181)>0,ROUND(SUM(T170:T181),2),\"\")","v":""},{"$f":"IF(SUM(U170:U181)>0,ROUND(SUM(U170:U181),2),\"\")","v":""}]
[null,"Item_Code",null,"LANE LINE"]
[null,"644E00200"]
[null,"Split #",null,"CTY","ROUTE",null,"FROM",null,null,null,null,"TO",null,null,null,"TOTAL MILES","4\" LANE LINE",null,"COMMENTS"]
[null,null,null,null,null,"TRUE LOG",null,null,null,null,"TRUE LOG",null,null,null,null,null,"DASHED","SOLID"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Total",null,"TOTAL",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(P187:P195)>0,ROUND(SUM(P187:P195),2),\"\")","v":""},{"$f":"IF(SUM(Q187:Q195)>0,ROUND(SUM(Q187:Q195),2),\"\")","v":""},{"$f":"IF(SUM(R187:R195)>0,ROUND(SUM(R187:R195),2),\"\")","v":""}]
[null,"Item_Code",null,"CENTER LINE"]
[null,"644E00300"]
[null,"Split #",null,"CTY","ROUTE",null,"FROM",null,null,null,null,"TO",null,null,null,"TOTAL MILES","EQUIVALENT                      SOLID LINE",null,"COMMENTS"]
[null,null,null,null,null,"TRUE LOG",null,null,null,null,"TRUE LOG"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Total",null,"TOTAL",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(P201:P212)>0,ROUND(SUM(P201:P212),2),\"\")","v":""},{"$f":"IF(SUM(Q201:R212)>0,ROUND(SUM(Q201:R212),2),\"\")","v":""}]
[null,null,null,"AUXILIARY"]
[]
[null,"Split #",null,"CTY","ROUTE LOCATION",null,null,"TRUE              LOG","CHANNEL                                LINE","STOP                                LINE","CROSS WALK LINES","TRANSVERSE DIAGONAL LINES",null,"ISLAND MARKING","SYMBOL MARKINGS",null,null,"LANE ARROWS",null,null,null,"WORD ON PVMT",null,"DOTTED LINES","COMMENTS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RxR","SCHOOL",null,"TURN","TURN","THRU","COMB.","ONLY"]
[null,null,null,null,null,null,null,null,null,null,null,"WHITE","YELLOW",null,null,"72\"","96\"","LEFT","RIGHT",null,null,"72\"","96\""]
[null,null,null,null,null,null,null,null,"FT","FT","FT","FT","FT","SQ FT","EACH","EACH","EACH","EACH","EACH","EACH","EACH","EACH","EACH","FT"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Total",null,"TOTAL",null,null,null,null,{"$f":"IF(SUM(I220:I239)>0,ROUND(SUM(I220:I239),2),\"\")","v":""},{"$f":"IF(SUM(J220:J239)>0,ROUND(SUM(J220:J239),2),\"\")","v":""},{"$f":"IF(SUM(K220:K239)>0,ROUND(SUM(K220:K239),2),\"\")","v":""},{"$f":"IF(SUM(L220:L239)>0,ROUND(SUM(L220:L239),2),\"\")","v":""},{"$f":"IF(SUM(M220:M239)>0,ROUND(SUM(M220:M239),2),\"\")","v":""},{"$f":"IF(SUM(N220:N239)>0,ROUND(SUM(N220:N239),2),\"\")","v":""},{"$f":"IF(SUM(O220:O239)>0,ROUND(SUM(O220:O239),2),\"\")","v":""},{"$f":"IF(SUM(P220:P239)>0,ROUND(SUM(P220:P239),2),\"\")","v":""},{"$f":"IF(SUM(Q220:Q239)>0,ROUND(SUM(Q220:Q239),2),\"\")","v":""},{"$f":"IF(SUM(R220:R239)>0,ROUND(SUM(R220:R239),2),\"\")","v":""},{"$f":"IF(SUM(S220:S239)>0,ROUND(SUM(S220:S239),2),\"\")","v":""},{"$f":"IF(SUM(T220:T239)>0,ROUND(SUM(T220:T239),2),\"\")","v":""},{"$f":"IF(SUM(U220:U239)>0,ROUND(SUM(U220:U239),2),\"\")","v":""},{"$f":"IF(SUM(V220:V239)>0,ROUND(SUM(V220:V239),2),\"\")","v":""},{"$f":"IF(SUM(W220:W239)>0,ROUND(SUM(W220:W239),2),\"\")","v":""},{"$f":"IF(SUM(X220:X239)>0,ROUND(SUM(X220:X239),2),\"\")","v":""}]
[null,null,null,null,null,null,null,"ITEM_CODE","644E00400","644E00500","644E00600","644E00700","644E00700","644E00900","644E01000","644E01100","644E01110","644E01300","644E01300","644E01300","644E01300","644E01400","644E01410","644E01500"]
[null,null,null,null,null,null,null,"ADDITIONAL_DESCRIPTION","","","","","","","","","","","","","","","",""]
[]
[null,"Page #",null,{"$f":"\"PAVEMENT MARKING SUBSUMMARY SHEET \" &B245","v":"PAVEMENT MARKING SUBSUMMARY SHEET "}]
[null,null,null,null,null,null,"EDGE LINE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GENERAL SPEC:",null,640]
[null,"Item_Code",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MATERIAL TYPE:",null,644]
[null,"644E00100",null,"CTY","ROUTE",null,"FROM",null,null,null,null,"TO",null,null,null,"WHITE EDGE LINE",null,null,"YELLOW EDGE LINE",null,null,"COMMENTS"]
[null,"Split #",null,null,null,"TRUE LOG",null,null,null,null,"TRUE LOG",null,null,null,null,"TOTAL","HIGHWAY","RAMP","TOTAL","HIGHWAY","RAMP"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Total",null,"TOTAL",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(P249:P260)>0,ROUND(SUM(P249:P260),2),\"\")","v":""},{"$f":"IF(SUM(Q249:Q260)>0,ROUND(SUM(Q249:Q260),2),\"\")","v":""},{"$f":"IF(SUM(R249:R260)>0,ROUND(SUM(R249:R260),2),\"\")","v":""},{"$f":"IF(SUM(S249:S260)>0,ROUND(SUM(S249:S260),2),\"\")","v":""},{"$f":"IF(SUM(T249:T260)>0,ROUND(SUM(T249:T260),2),\"\")","v":""},{"$f":"IF(SUM(U249:U260)>0,ROUND(SUM(U249:U260),2),\"\")","v":""}]
[null,"Item_Code",null,"LANE LINE"]
[null,"644E00200"]
[null,"Split #",null,"CTY","ROUTE",null,"FROM",null,null,null,null,"TO",null,null,null,"TOTAL MILES","4\" LANE LINE",null,"COMMENTS"]
[null,null,null,null,null,"TRUE LOG",null,null,null,null,"TRUE LOG",null,null,null,null,null,"DASHED","SOLID"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Total",null,"TOTAL",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(P266:P274)>0,ROUND(SUM(P266:P274),2),\"\")","v":""},{"$f":"IF(SUM(Q266:Q274)>0,ROUND(SUM(Q266:Q274),2),\"\")","v":""},{"$f":"IF(SUM(R266:R274)>0,ROUND(SUM(R266:R274),2),\"\")","v":""}]
[null,"Item_Code",null,"CENTER LINE"]
[null,"644E00300"]
[null,"Split #",null,"CTY","ROUTE",null,"FROM",null,null,null,null,"TO",null,null,null,"TOTAL MILES","EQUIVALENT                      SOLID LINE",null,"COMMENTS"]
[null,null,null,null,null,"TRUE LOG",null,null,null,null,"TRUE LOG"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Total",null,"TOTAL",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(P280:P291)>0,ROUND(SUM(P280:P291),2),\"\")","v":""},{"$f":"IF(SUM(Q280:R291)>0,ROUND(SUM(Q280:R291),2),\"\")","v":""}]
[null,null,null,"AUXILIARY"]
[]
[null,"Split #",null,"CTY","ROUTE LOCATION",null,null,"TRUE              LOG","CHANNEL                                LINE","STOP                                LINE","CROSS WALK LINES","TRANSVERSE DIAGONAL LINES",null,"ISLAND MARKING","SYMBOL MARKINGS",null,null,"LANE ARROWS",null,null,null,"WORD ON PVMT",null,"DOTTED LINES","COMMENTS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RxR","SCHOOL",null,"TURN","TURN","THRU","COMB.","ONLY"]
[null,null,null,null,null,null,null,null,null,null,null,"WHITE","YELLOW",null,null,"72\"","96\"","LEFT","RIGHT",null,null,"72\"","96\""]
[null,null,null,null,null,null,null,null,"FT","FT","FT","FT","FT","SQ FT","EACH","EACH","EACH","EACH","EACH","EACH","EACH","EACH","EACH","FT"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Total",null,"TOTAL",null,null,null,null,{"$f":"IF(SUM(I299:I318)>0,ROUND(SUM(I299:I318),2),\"\")","v":""},{"$f":"IF(SUM(J299:J318)>0,ROUND(SUM(J299:J318),2),\"\")","v":""},{"$f":"IF(SUM(K299:K318)>0,ROUND(SUM(K299:K318),2),\"\")","v":""},{"$f":"IF(SUM(L299:L318)>0,ROUND(SUM(L299:L318),2),\"\")","v":""},{"$f":"IF(SUM(M299:M318)>0,ROUND(SUM(M299:M318),2),\"\")","v":""},{"$f":"IF(SUM(N299:N318)>0,ROUND(SUM(N299:N318),2),\"\")","v":""},{"$f":"IF(SUM(O299:O318)>0,ROUND(SUM(O299:O318),2),\"\")","v":""},{"$f":"IF(SUM(P299:P318)>0,ROUND(SUM(P299:P318),2),\"\")","v":""},{"$f":"IF(SUM(Q299:Q318)>0,ROUND(SUM(Q299:Q318),2),\"\")","v":""},{"$f":"IF(SUM(R299:R318)>0,ROUND(SUM(R299:R318),2),\"\")","v":""},{"$f":"IF(SUM(S299:S318)>0,ROUND(SUM(S299:S318),2),\"\")","v":""},{"$f":"IF(SUM(T299:T318)>0,ROUND(SUM(T299:T318),2),\"\")","v":""},{"$f":"IF(SUM(U299:U318)>0,ROUND(SUM(U299:U318),2),\"\")","v":""},{"$f":"IF(SUM(V299:V318)>0,ROUND(SUM(V299:V318),2),\"\")","v":""},{"$f":"IF(SUM(W299:W318)>0,ROUND(SUM(W299:W318),2),\"\")","v":""},{"$f":"IF(SUM(X299:X318)>0,ROUND(SUM(X299:X318),2),\"\")","v":""}]
[null,null,null,null,null,null,null,"ITEM_CODE","644E00400","644E00500","644E00600","644E00700","644E00700","644E00900","644E01000","644E01100","644E01110","644E01300","644E01300","644E01300","644E01300","644E01400","644E01410","644E01500"]
[null,null,null,null,null,null,null,"ADDITIONAL_DESCRIPTION","","","","","","","","","","","","","","","",""]