{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["PROJECT INFO","MAST ARM HEIGHT","MAST ARM DESIGN NO.","2 ARM DESIGN NO."],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":129,"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":"PROJECT INFO","index":0,"n_rows":5,"n_cols":2,"rows_kept":5,"cut":false,"hidden":false,"merged":[[5,0,6,2],[0,0,1,2],[2,2,4,2]]}
["PROJECT INFORMATION"]
[]
["PROJECT/PID:","08326 - SUM-8-0175"]
["INTERSECTION NAME:","Perkins St at Ramp I/Goodkirk St"]
["STUDY DATE:","2020-08-18"]

{"sheet":"MAST ARM HEIGHT","index":1,"n_rows":27,"n_cols":32,"rows_kept":27,"cut":false,"hidden":false,"merged":[[15,3,19,3],[0,8,1,8],[0,9,1,9],[0,19,1,19],[2,16,9,16],[2,17,9,17],[2,18,9,18],[2,19,9,19],[10,8,14,8],[2,3,9,3],[2,8,9,8],[2,4,9,4],[2,5,9,5],[2,6,9,6],[2,7,9,7],[0,10,1,10],[2,20,9,20],[2,21,9,21],[2,22,9,22],[0,0,1,0],[10,2,14,2],[10,3,14,3],[0,1,1,1],[2,1,9,1],[10,1,14,1],[20,2,24,2],[2,0,9,0],[2,2,9,2],[10,0,14,0],[15,0,19,0],[20,0,24,0],[15,2,19,2],[15,1,19,1],[20,1,24,1],[20,3,24,3],[10,22,14,22],[15,16,19,16],[15,17,19,17],[15,18,19,18],[15,19,19,19],[15,20,19,20],[15,21,19,21],[15,22,19,22],[10,16,14,16],[10,17,14,17],[10,18,14,18],[10,20,14,20],[10,21,14,21],[10,19,14,19],[20,21,24,21],[20,22,24,22],[20,16,24,16],[20,17,24,17],[20,18,24,18],[20,19,24,19],[20,20,24,20],[20,7,24,7],[10,4,14,4],[20,8,24,8],[20,4,24,4],[20,5,24,5],[20,6,24,6],[10,5,14,5],[10,6,14,6],[10,7,14,7],[15,4,19,4],[15,5,19,5],[15,6,19,6],[15,7,19,7],[15,8,19,8]]}
["SUPPORT NO.","ARM ","MIN CLEARANCE FROM PAVEMENT TO BOTTOM OF SIGNAL HEAD","MAX CLEARANCE FROM PAVEMENT TO BOTTOM OF SIGNAL HEAD","FOUNDATION ELEVATION AT GROUND LEVEL","DISTANCE FROM GROUND TO FOUNDATION","ELEVATION B\nTOP OF FOUNDATION","RISE ANGLE WITH HORIZONTAL ARM TIP ","SIGNAL HEADS CENTERED ON WHICH COLOR?","SIGNAL NO. ","SIGNAL HEAD TYPE\n\n(12 IN. SECTIONS WITH BACKPLATES)","DISTANCE FROM BOTTOM OF SIGNAL HEAD TO CENTER OF MAST ARM (TEM 497-6) ","SIGNAL HEAD DISTANCE FROM SUPPORT POLE ","ELEVATION A PAVEMENT ELEVATION UNDER SIGNAL HEAD OR SIGN","MINIMUM HEIGHT (FOUNDATION TO MAST ARM) ","MAXIMUM HEIGHT (FOUNDATION TO MAST ARM) ","MINIMUM ALLOWABLE HEIGHT (FOUNDATION TO MAST ARM)","MAXIMUM ALLOWABLE HEIGHT (FOUNDATION TO MAST ARM)","FINAL ATTACHMENT ARM HEIGHT (FOUNDATION TO MAST ARM)","DOES MAST ARM HAVE POLE EXTENSION? ^","HEIGHT FROM MAST ARM TO TOP OF POLE ","SUGGESTED POLE HEIGHT","POLE HEIGHT WITH\n10' EXTENSION"]
[null,null,"FT","FT","FT","IN","FT","DEGREE",null,null,null,"FT","FT","FT","FT","FT","FT","FT","FT",null,"FT","FT","FT",null,null,null,null,"-"]
["SP-1","A",17,19,1049.49,0,{"$f":"IF(E3=\"-\",\"-\",$E3+($F3/12))","v":1049.49},0.5,"YELLOW","6A","3 SECTIONS",{"$f":"IF($I$3=\"-\",\"-\",VLOOKUP(K3,$AD$5:$AF$15,MATCH($I$3,$AE$4:$AF$4)+1))","v":2.2999999999999998},32,1049.5,{"$f":"IF(M3=\"-\",\"-\",($C$3+$L3+$N3-(SIN(RADIANS($H$3))*$M3))-$G$3)","v":19.030750864051925},{"$f":"IF(M3=\"-\",\"-\",($D$3+$L3+$N3-(SIN(RADIANS($H$3))*$M3))-$G$3)","v":21.030750864051925},{"$f":"IF(O3=\"-\",\"-\",(MAX(O3:O10)))","v":19.147493618586168},{"$f":"IF(P3=\"-\",\"-\",MIN(P3:P10))","v":20.952212044566522},20,"YES",{"$f":"IF($T3=\"YES\",5,IF($T3=\"NO\",1.5,\"-\"))","v":5},{"$f":"IF(T3=\"-\",\"-\",$S3+$U3)","v":25},{"$f":"IF($T3=\"YES\",V3+10,IF($T3=\"NO\",\"N/A\",\"-\"))","v":35},null,null,null,"-","SP-1"]
[null,null,null,null,null,null,null,null,null,"6B","3 SECTIONS",2.2999999999999998,41,1049.5,18.952212044566522,20.952212044566522,null,null,null,null,null,null,null,null,null,null,"YELLOW","SP-2",null,null,"RED","YELLOW"]
[null,null,null,null,null,null,null,null,null,1,"5 SECTIONS - CLUSTER",2.6,53,1049.5,19.147493618586168,21.147493618586168,null,null,null,null,null,null,null,null,null,null,"RED","SP-3",null,"-","-","-"]
[null,null,null,null,null,null,null,null,null,"-","-","-","-","-","-","-",null,null,null,null,null,null,null,null,null,null,null,"SP-4",null,"1 SECTION",0,0]
[null,null,null,null,null,null,null,null,null,"-","-","-","-","-","-","-",null,null,null,null,null,null,null,null,null,null,"-","SP-5",null,"2 SECTIONS",2.625,1.625]
[null,null,null,null,null,null,null,null,null,"-","-","-","-","-","-","-",null,null,null,null,null,null,null,null,null,null,"YES","SP-6",null,"3 SECTIONS",3.4,2.2999999999999998]
[null,null,null,null,null,null,null,null,null,"-","-","-","-","-","-","-",null,null,null,null,null,null,null,null,null,null,"NO","SP-7",null,"4 SECTIONS",4.5999999999999996,3.4]
[null,null,null,null,null,null,null,null,null,"-","-","-","-","-","-","-",null,null,null,null,null,null,null,null,null,null,null,"SP-8",null,"5 SECTIONS - CLUSTER",3.7,2.6]
["SP-2","A",17,19,1053.3,0,{"$f":"IF(E11=\"-\",\"-\",$E11+($F11/12))","v":1053.3},0.5,"YELLOW","2A","3 SECTIONS",{"$f":"IF($I$11=\"-\",\"-\",VLOOKUP(K11,$AD$5:$AF$15,MATCH($I$11,$AE$4:$AF$4)+1))","v":2.2999999999999998},24,1052.8,{"$f":"IF(M11=\"-\",\"-\",($C$11+$L11+$N11-(SIN(RADIANS($H$11))*$M11))-$G$11)","v":18.590563148038882},{"$f":"IF(M11=\"-\",\"-\",($D$11+$L11+$N11-(SIN(RADIANS($H$11))*$M11))-$G$11)","v":20.590563148038882},{"$f":"IF(O11=\"-\",\"-\",(MAX(O11:O15)))","v":18.590563148038882},{"$f":"IF(P11=\"-\",\"-\",MIN(P11:P15))","v":20.485844722058573},20,"YES",{"$f":"IF($T11=\"YES\",5,IF($T11=\"NO\",1.5,\"-\"))","v":5},{"$f":"IF(T11=\"-\",\"-\",$S11+$U11)","v":25},{"$f":"IF($T11=\"YES\",V11+10,IF($T11=\"NO\",\"N/A\",\"-\"))","v":35},null,null,null,"-","SP-9",null,"5 SECTIONS - MIXED",3.7,2.6]
[null,null,null,null,null,null,null,null,null,"2B","3 SECTIONS",{"$f":"IF($I$11=\"-\",\"-\",VLOOKUP(K12,$AD$5:$AF$15,MATCH($I$11,$AE$4:$AF$4)+1))","v":2.2999999999999998},36,1052.8,{"$f":"IF(M12=\"-\",\"-\",($C$11+$L12+$N12-(SIN(RADIANS($H$11))*$M12))-$G$11)","v":18.485844722058573},{"$f":"IF(M12=\"-\",\"-\",($D$11+$L12+$N12-(SIN(RADIANS($H$11))*$M12))-$G$11)","v":20.485844722058573},null,null,null,null,null,null,null,null,null,null,0,"SP-10",null,"5 SECTIONS - VERTICAL",5.8,4.5999999999999996]
[null,null,null,null,null,null,null,null,null,"-","-",{"$f":"IF($I$11=\"-\",\"-\",VLOOKUP(K13,$AD$5:$AF$15,MATCH($I$11,$AE$4:$AF$4)+1))","v":"-"},"-","-",{"$f":"IF(M13=\"-\",\"-\",($C$11+$L13+$N13-(SIN(RADIANS($H$11))*$M13))-$G$11)","v":"-"},{"$f":"IF(M13=\"-\",\"-\",($D$11+$L13+$N13-(SIN(RADIANS($H$11))*$M13))-$G$11)","v":"-"},null,null,null,null,null,null,null,null,null,null,0.5,"SP-11"]
[null,null,null,null,null,null,null,null,null,"-","-",{"$f":"IF($I$11=\"-\",\"-\",VLOOKUP(K14,$AD$5:$AF$15,MATCH($I$11,$AE$4:$AF$4)+1))","v":"-"},"-","-",{"$f":"IF(M14=\"-\",\"-\",($C$11+$L14+$N14-(SIN(RADIANS($H$11))*$M14))-$G$11)","v":"-"},{"$f":"IF(M14=\"-\",\"-\",($D$11+$L14+$N14-(SIN(RADIANS($H$11))*$M14))-$G$11)","v":"-"},null,null,null,null,null,null,null,null,null,null,1,"SP-12"]
[null,null,null,null,null,null,null,null,null,"-","-",{"$f":"IF($I$11=\"-\",\"-\",VLOOKUP(K15,$AD$5:$AF$15,MATCH($I$11,$AE$4:$AF$4)+1))","v":"-"},"-","-",{"$f":"IF(M15=\"-\",\"-\",($C$11+$L15+$N15-(SIN(RADIANS($H$11))*$M15))-$G$11)","v":"-"},{"$f":"IF(M15=\"-\",\"-\",($D$11+$L15+$N15-(SIN(RADIANS($H$11))*$M15))-$G$11)","v":"-"},null,null,null,null,null,null,null,null,null,null,1.5,"SP-13"]
["SP-2","B",17,19,1053.3,0,{"$f":"IF(E16=\"-\",\"-\",$E16+($F16/12))","v":1053.3},0.5,"YELLOW","4A","3 SECTIONS",{"$f":"IF($I$16=\"-\",\"-\",VLOOKUP(K16,$AD$5:$AF$15,MATCH($I$16,$AE$4:$AF$4)+1))","v":2.2999999999999998},25,1051.7,{"$f":"IF(M16=\"-\",\"-\",($C$16+$L16+$N16-(SIN(RADIANS($H$16))*$M16))-$G$16)","v":17.481836612540747},{"$f":"IF(M16=\"-\",\"-\",($D$16+$L16+$N16-(SIN(RADIANS($H$16))*$M16))-$G$16)","v":19.481836612540747},{"$f":"IF(O16=\"-\",\"-\",(MAX(O16:O20)))","v":17.481836612540747},{"$f":"IF(P16=\"-\",\"-\",MIN(P16:P20))","v":19.324758973569942},20,"YES",{"$f":"IF($T16=\"YES\",5,IF($T16=\"NO\",1.5,\"-\"))","v":5},{"$f":"IF(T16=\"-\",\"-\",$S16+$U16)","v":25},{"$f":"IF($T16=\"YES\",V16+10,IF($T16=\"NO\",\"N/A\",\"-\"))","v":35},null,null,null,2,"SP-14"]
[null,null,null,null,null,null,null,null,null,"4B","3 SECTIONS",{"$f":"IF($I$16=\"-\",\"-\",VLOOKUP(K17,$AD$5:$AF$15,MATCH($I$16,$AE$4:$AF$4)+1))","v":2.2999999999999998},33,1051.7,{"$f":"IF(M17=\"-\",\"-\",($C$16+$L17+$N17-(SIN(RADIANS($H$16))*$M17))-$G$16)","v":17.412024328553798},{"$f":"IF(M17=\"-\",\"-\",($D$16+$L17+$N17-(SIN(RADIANS($H$16))*$M17))-$G$16)","v":19.412024328553798},null,null,null,null,null,null,null,null,null,null,2.5,"SP-15"]
[null,null,null,null,null,null,null,null,null,"4C","3 SECTIONS",{"$f":"IF($I$16=\"-\",\"-\",VLOOKUP(K18,$AD$5:$AF$15,MATCH($I$16,$AE$4:$AF$4)+1))","v":2.2999999999999998},43,1051.7,{"$f":"IF(M18=\"-\",\"-\",($C$16+$L18+$N18-(SIN(RADIANS($H$16))*$M18))-$G$16)","v":17.324758973569942},{"$f":"IF(M18=\"-\",\"-\",($D$16+$L18+$N18-(SIN(RADIANS($H$16))*$M18))-$G$16)","v":19.324758973569942},null,null,null,null,null,null,null,null,null,null,3,"-"]
[null,null,null,null,null,null,null,null,null,"-","-",{"$f":"IF($I$16=\"-\",\"-\",VLOOKUP(K19,$AD$5:$AF$15,MATCH($I$16,$AE$4:$AF$4)+1))","v":"-"},"-","-",{"$f":"IF(M19=\"-\",\"-\",($C$16+$L19+$N19-(SIN(RADIANS($H$16))*$M19))-$G$16)","v":"-"},{"$f":"IF(M19=\"-\",\"-\",($D$16+$L19+$N19-(SIN(RADIANS($H$16))*$M19))-$G$16)","v":"-"},null,null,null,null,null,null,null,null,null,null,null,"A"]
[null,null,null,null,null,null,null,null,null,"-","-",{"$f":"IF($I$16=\"-\",\"-\",VLOOKUP(K20,$AD$5:$AF$15,MATCH($I$16,$AE$4:$AF$4)+1))","v":"-"},"-","-",{"$f":"IF(M20=\"-\",\"-\",($C$16+$L20+$N20-(SIN(RADIANS($H$16))*$M20))-$G$16)","v":"-"},{"$f":"IF(M20=\"-\",\"-\",($D$16+$L20+$N20-(SIN(RADIANS($H$16))*$M20))-$G$16)","v":"-"},null,null,null,null,null,null,null,null,null,null,null,"B"]
["-","-",17,19,"-","-",{"$f":"IF(E21=\"-\",\"-\",$E21+($F21/12))","v":"-"},"-","-","-","-",{"$f":"IF($I$21=\"-\",\"-\",VLOOKUP(K21,$AD$5:$AF$15,MATCH($I$21,$AE$4:$AF$4)+1))","v":"-"},"-","-",{"$f":"IF(M21=\"-\",\"-\",($C$21+$L21+$N21-(SIN(RADIANS($H$21))*$M21))-$G$21)","v":"-"},{"$f":"IF(M21=\"-\",\"-\",($D$21+$L21+$N21-(SIN(RADIANS($H$21))*$M21))-$G$21)","v":"-"},{"$f":"IF(O21=\"-\",\"-\",(MAX(O21:O25)))","v":"-"},{"$f":"IF(P21=\"-\",\"-\",MIN(P21:P25))","v":"-"},"-","-",{"$f":"IF($T21=\"YES\",5,IF($T21=\"NO\",1.5,\"-\"))","v":"-"},{"$f":"IF(T21=\"-\",\"-\",$S21+$U21)","v":"-"},{"$f":"IF($T21=\"YES\",V21+10,IF($T21=\"NO\",\"N/A\",\"-\"))","v":"-"},null,null,null,null,"C"]
[null,null,null,null,null,null,null,null,null,"-","-",{"$f":"IF($I$21=\"-\",\"-\",VLOOKUP(K22,$AD$5:$AF$15,MATCH($I$21,$AE$4:$AF$4)+1))","v":"-"},"-","-",{"$f":"IF(M22=\"-\",\"-\",($C$21+$L22+$N22-(SIN(RADIANS($H$21))*$M22))-$G$21)","v":"-"},{"$f":"IF(M22=\"-\",\"-\",($D$21+$L22+$N22-(SIN(RADIANS($H$21))*$M22))-$G$21)","v":"-"},null,null,null,null,null,null,null,null,null,null,null,"D"]
[null,null,null,null,null,null,null,null,null,"-","-",{"$f":"IF($I$21=\"-\",\"-\",VLOOKUP(K23,$AD$5:$AF$15,MATCH($I$21,$AE$4:$AF$4)+1))","v":"-"},"-","-",{"$f":"IF(M23=\"-\",\"-\",($C$21+$L23+$N23-(SIN(RADIANS($H$21))*$M23))-$G$21)","v":"-"},{"$f":"IF(M23=\"-\",\"-\",($D$21+$L23+$N23-(SIN(RADIANS($H$21))*$M23))-$G$21)","v":"-"}]
[null,null,null,null,null,null,null,null,null,"-","-",{"$f":"IF($I$21=\"-\",\"-\",VLOOKUP(K24,$AD$5:$AF$15,MATCH($I$21,$AE$4:$AF$4)+1))","v":"-"},"-","-",{"$f":"IF(M24=\"-\",\"-\",($C$21+$L24+$N24-(SIN(RADIANS($H$21))*$M24))-$G$21)","v":"-"},{"$f":"IF(M24=\"-\",\"-\",($D$21+$L24+$N24-(SIN(RADIANS($H$21))*$M24))-$G$21)","v":"-"}]
[null,null,null,null,null,null,null,null,null,"-","-",{"$f":"IF($I$21=\"-\",\"-\",VLOOKUP(K25,$AD$5:$AF$15,MATCH($I$21,$AE$4:$AF$4)+1))","v":"-"},"-","-",{"$f":"IF(M25=\"-\",\"-\",($C$21+$L25+$N25-(SIN(RADIANS($H$21))*$M25))-$G$21)","v":"-"},{"$f":"IF(M25=\"-\",\"-\",($D$21+$L25+$N25-(SIN(RADIANS($H$21))*$M25))-$G$21)","v":"-"}]
["^ With typical extension, 5' is calculated, as per SCD TC-85.22."]
["Note: Final Pole Height will be noted in the plans on Mast Arm Design Table"]

{"sheet":"MAST ARM DESIGN NO.","index":2,"n_rows":1048576,"n_cols":34,"rows_kept":4500,"cut":true,"hidden":false,"merged":[[27,14,34,14],[27,15,34,15],[27,16,34,16],[7,3,10,3],[3,13,10,13],[19,13,26,13],[31,3,34,3],[3,14,10,14],[3,15,10,15],[3,16,10,16],[11,14,18,14],[11,15,18,15],[11,16,18,16],[19,14,26,14],[19,15,26,15],[19,16,26,16],[27,2,34,2],[27,13,34,13],[3,0,10,0],[3,1,10,1],[3,2,10,2],[11,0,18,0],[19,0,26,0],[27,1,34,1],[27,0,34,0],[3,3,6,3],[27,3,30,3],[11,3,14,3],[11,13,18,13],[11,1,18,1],[11,2,18,2],[19,1,26,1],[0,0,2,0],[0,1,2,1],[0,4,2,4],[0,5,2,5],[0,8,2,8],[0,6,1,7],[0,2,2,2],[0,3,1,3],[0,12,2,12],[0,16,2,16],[2,9,2,10],[1,15,2,15],[0,14,2,14],[0,9,1,10],[19,2,26,2],[15,3,18,3],[23,3,26,3],[19,3,22,3],[0,11,1,11]],"bounds":{"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0}}
["SUPPORT NO.","ARM","NUMBER OF LUMINAIRES OR BRACKET ARMS","LUMINAIRE/ BRACKET ARM LENGTH","SIGNAL OR SIGN?","SIGNAL/ SIGN NO.","ATTACHMENT DISTANCE FROM SUPPORT POLE",null,"SIGNAL HEAD TYPE (12 IN. LENS)","SIGN SIZE",null,"AREA","ATTACHMENT LENGTH * AREA","L","DAMPER REQUIRED?\n\n (Incidental to Support item; CM&S 632 and SCD TC-81.22)","K","DESIGN NO."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL MAST ARM LENGTH",null,"AREA MOMENT DESIGN FACTOR",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Number of Luminaires or Bracket Arms: Must select value (0-2)"]
[null,null,null,"FT",null,null,"NO.","FT",null,"IN",null,"SQ. FT.",null,"FT"]
[{"$f":"'MAST ARM HEIGHT'!A3","v":"SP-1"},{"$f":"'MAST ARM HEIGHT'!B3","v":"A"},1,20,"SIGNAL",{"$f":"IF($E4=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!J3:J10,COUNTIF($E4,\"SIGNAL\")),\"-\")","v":"6A"},"L1",{"$f":"IF(E4=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!M3:M10,COUNTIF(E4,\"SIGNAL\")),\"-\")","v":32},{"$f":"IF(E4=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!K3:K10,COUNTIF(E4,\"SIGNAL\")),\"-\")","v":"3 SECTIONS"},"-","-",{"$f":"IF(E4=\"SIGNAL\",VLOOKUP(I4,$T$5:$U$12,2),IF(E4=\"SIGN\",(J4*K4)/144,\"-\"))","v":8.6999999999999993},{"$f":"IF(E4=\"-\",\"-\",H4*L4)","v":278.39999999999998},56,{"$f":"IF(N4=\"-\",\"-\",IF(N4>59,\"YES\",\"NO\"))","v":"NO"},{"$f":"IF($C4=2,(D4+D8)*3+(SUMIF($M4:$M11,\"<>-\")),IF($C4=1,$D4*3+(SUMIF($M4:$M11,\"<>-\")),IF($C4=0,SUMIF($M4:$M11,\"<>-\"),\"-\")))","v":1664.175},{"$f":"IF($P4=\"-\",\"-\",IF($P4<=$Z$23,VLOOKUP($Z$23,$AA$4:$AB$11,2),$AA$23))","v":13},null,"-",null,12,null,null,null,null,null,null,null,null,"K","DESIGN NO.","MAX ARM LENGTH (FT)"]
[null,null,null,null,"SIGNAL",{"$f":"IF($E5=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!J3:J10,COUNTIF($E4:$E5,\"SIGNAL\")),\"-\")","v":"6B"},"L2",{"$f":"IF($E5=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!M3:M10,COUNTIF($E4:$E5,\"SIGNAL\")),\"-\")","v":41},{"$f":"IF($E5=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!K3:K10,COUNTIF($E4:$E5,\"SIGNAL\")),\"-\")","v":"3 SECTIONS"},"-","-",8.6999999999999993,356.7,null,null,null,null,null,8,"-","-",null,null,null,null,null,787.5,2,null,2641,14,70]
[null,null,null,null,"SIGNAL",{"$f":"IF($E6=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!J3:J10,COUNTIF($E4:$E6,\"SIGNAL\")),\"-\")","v":1},"L3",{"$f":"IF($E6=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!M3:M10,COUNTIF($E4:$E6,\"SIGNAL\")),\"-\")","v":53},{"$f":"IF($E6=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!K3:K10,COUNTIF($E4:$E6,\"SIGNAL\")),\"-\")","v":"5 SECTIONS - CLUSTER"},"-","-",12.4,657.2,null,null,null,null,null,12,"1 SECTION",4,null,null,null,null,null,null,null,null,2380,13,60]
[null,null,null,null,"SIGN","S1","L4",11,{"$f":"IF($E7=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!K3:K10,COUNTIF($E4:$E7,\"SIGNAL\")),\"-\")","v":"-"},102,24,17,187,null,null,null,null,null,null,"2 SECTIONS",6.5,null,null,null,null,null,1575,4,null,1995,12,48]
[null,null,null,"-","SIGN","S5","L5",18.5,{"$f":"IF($E8=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!K3:K10,COUNTIF($E4:$E8,\"SIGNAL\")),\"-\")","v":"-"},54,18,6.75,124.875,null,null,null,null,null,null,"3 SECTIONS",8.6999999999999993]
[null,null,null,null,"-",{"$f":"IF($E9=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!J3:J10,COUNTIF($E4:$E9,\"SIGNAL\")),\"-\")","v":"-"},"L6",{"$f":"IF($E9=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!M3:M10,COUNTIF($E4:$E9,\"SIGNAL\")),\"-\")","v":"-"},{"$f":"IF($E9=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!K3:K10,COUNTIF($E4:$E9,\"SIGNAL\")),\"-\")","v":"-"},"-","-","-","-",null,null,null,null,null,null,"4 SECTIONS",11,null,null,null,null,null,1995,12,null,1575,4,38]
[null,null,null,null,"-",{"$f":"IF($E10=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!J3:J10,COUNTIF($E4:$E10,\"SIGNAL\")),\"-\")","v":"-"},"L7",{"$f":"IF($E10=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!M3:M10,COUNTIF($E4:$E10,\"SIGNAL\")),\"-\")","v":"-"},{"$f":"IF($E10=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!K3:K10,COUNTIF($E4:$E10,\"SIGNAL\")),\"-\")","v":"-"},"-","-","-","-",null,null,null,null,null,null,"5 SECTIONS - CLUSTER",12.4,null,null,null,null,null,2380,13]
[null,null,null,null,"-",{"$f":"IF($E11=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!J3:J10,COUNTIF($E4:$E11,\"SIGNAL\")),\"-\")","v":"-"},"L8",{"$f":"IF($E11=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!M3:M10,COUNTIF($E4:$E11,\"SIGNAL\")),\"-\")","v":"-"},{"$f":"IF($E11=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!K3:K10,COUNTIF($E4:$E11,\"SIGNAL\")),\"-\")","v":"-"},"-","-","-","-",null,null,null,null,null,null,"5 SECTIONS - MIXED",11.4,null,null,null,null,null,2641,14,null,787.5,2,32]
[{"$f":"'MAST ARM HEIGHT'!A11","v":"SP-2"},{"$f":"'MAST ARM HEIGHT'!B11","v":"A"},1,15,"SIGNAL",{"$f":"IF($E12=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!J11:J15,COUNTIF($E12,\"SIGNAL\")),\"-\")","v":"2A"},"L1",{"$f":"IF($E12=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!M11:M15,COUNTIF($E12,\"SIGNAL\")),\"-\")","v":24},{"$f":"IF($E12=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!K11:K15,COUNTIF($E12,\"SIGNAL\")),\"-\")","v":"3 SECTIONS"},"-","-",8.6999999999999993,208.79999999999998,39,{"$f":"IF(N12=\"-\",\"-\",IF(N12>59,\"YES\",\"NO\"))","v":"NO"},{"$f":"IF($C12=2,(D12+D16)*3+(SUMIF($M12:$M19,\"<>-\")),IF($C12=1,$D12*3+(SUMIF($M12:$M19,\"<>-\")),IF($C12=0,SUMIF($M12:$M19,\"<>-\"),\"-\")))","v":777.625},{"$f":"IF($P12=\"-\",\"-\",IF($P12<=$Z$24,VLOOKUP($Z$24,$AA$4:$AB$11,2),$AA$24))","v":12},null,"-","5 SECTIONS - VERTICAL",13.3]
[null,null,null,null,"SIGNAL",{"$f":"IF($E13=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!J11:J15,COUNTIF($E12:$E13,\"SIGNAL\")),\"-\")","v":"2B"},"L2",{"$f":"IF($E13=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!M11:M15,COUNTIF($E12:$E13,\"SIGNAL\")),\"-\")","v":36},{"$f":"IF($E13=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!K11:K15,COUNTIF($E12:$E13,\"SIGNAL\")),\"-\")","v":"3 SECTIONS"},"-","-",8.6999999999999993,313.2,null,null,null,null,null,"SIGNAL"]
[null,null,null,null,"SIGN","S4","L3",3.5,{"$f":"IF($E14=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!K11:K15,COUNTIF($E12:$E14,\"SIGNAL\")),\"-\")","v":"-"},54,18,6.75,23.625,null,null,null,null,null,"SIGN"]
[null,null,null,null,"SIGN","S1","L4",11,{"$f":"IF($E15=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!K11:K15,COUNTIF($E12:$E15,\"SIGNAL\")),\"-\")","v":"-"},102,24,17,187]
[null,null,null,"-","-",{"$f":"IF($E16=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!J10:J14,COUNTIF($E11:$E16,\"SIGNAL\")),\"-\")","v":"-"},"L5",{"$f":"IF($E16=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!M12:M16,COUNTIF($E13:$E16,\"SIGNAL\")),\"-\")","v":"-"},{"$f":"IF($E16=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!K11:K15,COUNTIF($E12:$E16,\"SIGNAL\")),\"-\")","v":"-"},"-","-","-","-",null,null,null,null,null,"-"]
[null,null,null,null,"-",{"$f":"IF($E17=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!J11:J15,COUNTIF($E12:$E17,\"SIGNAL\")),\"-\")","v":"-"},"L6",{"$f":"IF($E17=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!M11:M15,COUNTIF($E12:$E17,\"SIGNAL\")),\"-\")","v":"-"},{"$f":"IF($E17=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!K11:K15,COUNTIF($E12:$E17,\"SIGNAL\")),\"-\")","v":"-"},"-","-","-","-",null,null,null,null,null,0]
[null,null,null,null,"-",{"$f":"IF($E18=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!J11:J15,COUNTIF($E12:$E18,\"SIGNAL\")),\"-\")","v":"-"},"L7",{"$f":"IF($E18=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!M11:M15,COUNTIF($E12:$E18,\"SIGNAL\")),\"-\")","v":"-"},{"$f":"IF($E18=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!K11:K15,COUNTIF($E12:$E18,\"SIGNAL\")),\"-\")","v":"-"},"-","-","-","-",null,null,null,null,null,1]
[null,null,null,null,"-",{"$f":"IF($E19=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!J11:J15,COUNTIF($E12:$E19,\"SIGNAL\")),\"-\")","v":"-"},"L8",{"$f":"IF($E19=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!M11:M15,COUNTIF($E12:$E19,\"SIGNAL\")),\"-\")","v":"-"},{"$f":"IF($E19=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!K11:K15,COUNTIF($E12:$E19,\"SIGNAL\")),\"-\")","v":"-"},"-","-","-","-",null,null,null,null,null,2]
[{"$f":"'MAST ARM HEIGHT'!A16","v":"SP-2"},{"$f":"'MAST ARM HEIGHT'!B16","v":"B"},1,15,"SIGNAL",{"$f":"IF($E20=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!J16:J20,COUNTIF($E20,\"SIGNAL\")),\"-\")","v":"4A"},"L1",{"$f":"IF($E20=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!M16:M20,COUNTIF($E20,\"SIGNAL\")),\"-\")","v":25},{"$f":"IF($E20=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!K16:K20,COUNTIF($E20,\"SIGNAL\")),\"-\")","v":"3 SECTIONS"},"-","-",8.6999999999999993,217.49999999999997,46,{"$f":"IF(N20=\"-\",\"-\",IF(N20>59,\"YES\",\"NO\"))","v":"NO"},{"$f":"IF($C20=2,(D20+D24)*3+(SUMIF($M20:$M27,\"<>-\")),IF($C20=1,$D20*3+(SUMIF($M20:$M27,\"<>-\")),IF($C20=0,SUMIF($M20:$M27,\"<>-\"),\"-\")))","v":1068.3666666666666},{"$f":"IF($P20=\"-\",\"-\",IF($P20<=$Z$25,VLOOKUP($Z$25,$AA$4:$AB$11,2),$AA$25))","v":12}]
[null,null,null,null,"SIGNAL",{"$f":"IF($E21=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!J16:J20,COUNTIF($E20:$E21,\"SIGNAL\")),\"-\")","v":"4B"},"L2",{"$f":"IF($E21=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!M16:M20,COUNTIF($E20:$E21,\"SIGNAL\")),\"-\")","v":33},{"$f":"IF($E21=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!K16:K20,COUNTIF($E20:$E21,\"SIGNAL\")),\"-\")","v":"3 SECTIONS"},"-","-",8.6999999999999993,287.09999999999997]
[null,null,null,null,"SIGNAL","4C","L3",{"$f":"IF($E22=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!M16:M20,COUNTIF($E20:$E22,\"SIGNAL\")),\"-\")","v":43},{"$f":"IF($E22=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!K16:K20,COUNTIF($E20:$E22,\"SIGNAL\")),\"-\")","v":"3 SECTIONS"},"-","-",8.6999999999999993,374.09999999999997,null,null,null,null,null,"-",null,null,null,null,null,"Pole","Ref 1 (length)","Ref 2 (design no)"]
[null,null,null,null,"SIGN","S2","L4",7,{"$f":"IF($E23=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!K16:K20,COUNTIF($E20:$E23,\"SIGNAL\")),\"-\")","v":"-"},124,24,20.666666666666668,144.66666666666669,null,null,null,null,null,1,null,null,null,null,null,1,{"$f":"INDEX(AD5:AD12,MATCH(N4,$AF$5:$AF$12,-1))","v":2380},{"$f":"INDEX($AE$5:$AE$12,MATCH($P4,$AD$5:$AD$12,-1))","v":12}]
[null,null,null,"-","-",{"$f":"IF($E24=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!J17:J21,COUNTIF($E21:$E24,\"SIGNAL\")),\"-\")","v":"-"},"L5",{"$f":"IF($E24=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!M17:M21,COUNTIF($E21:$E24,\"SIGNAL\")),\"-\")","v":"-"},{"$f":"IF($E24=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!K16:K20,COUNTIF($E20:$E24,\"SIGNAL\")),\"-\")","v":"-"},"-","-","-","-",null,null,null,null,null,2,null,null,null,null,null,2,{"$f":"INDEX(AD5:AD12,MATCH(N12,$AF$5:$AF$12,-1))","v":1995},{"$f":"INDEX($AE$5:$AE$12,MATCH($P12,$AD$5:$AD$12,-1))","v":2}]
[null,null,null,null,"-",{"$f":"IF($E25=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!J16:J20,COUNTIF($E20:$E25,\"SIGNAL\")),\"-\")","v":"-"},"L6",{"$f":"IF($E25=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!M16:M20,COUNTIF($E20:$E25,\"SIGNAL\")),\"-\")","v":"-"},{"$f":"IF($E25=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!K16:K20,COUNTIF($E20:$E25,\"SIGNAL\")),\"-\")","v":"-"},"-","-","-","-",null,null,null,null,null,3,null,null,null,null,null,3,{"$f":"INDEX(AD5:AD12,MATCH(N20,$AF$5:$AF$12,-1))","v":1995},{"$f":"INDEX($AE$5:$AE$12,MATCH($P20,$AD$5:$AD$12,-1))","v":4}]
[null,null,null,null,"-",{"$f":"IF($E26=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!J16:J20,COUNTIF($E20:$E26,\"SIGNAL\")),\"-\")","v":"-"},"L7",{"$f":"IF($E26=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!M16:M20,COUNTIF($E20:$E26,\"SIGNAL\")),\"-\")","v":"-"},{"$f":"IF($E26=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!K16:K20,COUNTIF($E20:$E26,\"SIGNAL\")),\"-\")","v":"-"},"-","-","-","-",null,null,null,null,null,4,null,null,null,null,null,4,{"$f":"INDEX(AD5:AD12,MATCH(N28,$AF$5:$AF$12,-1))","v":{"$error":"#N/A"}},{"$f":"INDEX($AE$5:$AE$12,MATCH($P28,$AD$5:$AD$12,-1))","v":{"$error":"#N/A"}}]
[null,null,null,null,"-",{"$f":"IF($E27=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!J16:J20,COUNTIF($E20:$E27,\"SIGNAL\")),\"-\")","v":"-"},"L8",{"$f":"IF($E27=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!M16:M20,COUNTIF($E20:$E27,\"SIGNAL\")),\"-\")","v":"-"},{"$f":"IF($E27=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!K16:K20,COUNTIF($E20:$E27,\"SIGNAL\")),\"-\")","v":"-"},"-","-","-","-"]
[{"$f":"'MAST ARM HEIGHT'!A21","v":"-"},{"$f":"'MAST ARM HEIGHT'!B21","v":"-"},"-","-","-",{"$f":"IF($E28=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!J21:J25,COUNTIF($E28,\"SIGNAL\")),\"-\")","v":"-"},"L1",{"$f":"IF($E28=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!M21:M25,COUNTIF($E28,\"SIGNAL\")),\"-\")","v":"-"},{"$f":"IF($E28=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!K21:K25,COUNTIF($E28,\"SIGNAL\")),\"-\")","v":"-"},"-","-","-","-","-",{"$f":"IF(N28=\"-\",\"-\",IF(N28>59,\"YES\",\"NO\"))","v":"-"},{"$f":"IF($C28=2,(D28+D32)*3+(SUMIF($M28:$M35,\"<>-\")),IF($C28=1,$D28*3+(SUMIF($M28:$M35,\"<>-\")),IF($C28=0,SUMIF($M28:$M35,\"<>-\"),\"-\")))","v":"-"},{"$f":"IF($P28=\"-\",\"-\",IF($P28<=$Z$26,VLOOKUP($Z$26,$AA$4:$AB$11,2),$AA$26))","v":"-"},null,"-"]
[null,null,null,null,"-",{"$f":"IF($E29=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!J21:J25,COUNTIF($E28:$E29,\"SIGNAL\")),\"-\")","v":"-"},"L2",{"$f":"IF($E29=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!M21:M25,COUNTIF($E28:$E29,\"SIGNAL\")),\"-\")","v":"-"},{"$f":"IF($E29=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!K21:K25,COUNTIF($E28:$E29,\"SIGNAL\")),\"-\")","v":"-"},"-","-","-","-",null,null,null,null,null,"A"]
[null,null,null,null,"-",{"$f":"IF($E30=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!J21:J25,COUNTIF($E28:$E30,\"SIGNAL\")),\"-\")","v":"-"},"L3",{"$f":"IF($E30=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!M21:M25,COUNTIF($E28:$E30,\"SIGNAL\")),\"-\")","v":"-"},{"$f":"IF($E30=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!K21:K25,COUNTIF($E28:$E30,\"SIGNAL\")),\"-\")","v":"-"},"-","-","-","-",null,null,null,null,null,"B"]
[null,null,null,null,"-",{"$f":"IF($E31=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!J21:J25,COUNTIF($E28:$E31,\"SIGNAL\")),\"-\")","v":"-"},"L4",{"$f":"IF($E31=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!M21:M25,COUNTIF($E28:$E31,\"SIGNAL\")),\"-\")","v":"-"},{"$f":"IF($E31=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!K21:K25,COUNTIF($E28:$E31,\"SIGNAL\")),\"-\")","v":"-"},"-","-","-","-"]
[null,null,null,"-","-",{"$f":"IF($E32=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!J21:J25,COUNTIF($E28:$E32,\"SIGNAL\")),\"-\")","v":"-"},"L5",{"$f":"IF($E32=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!M21:M25,COUNTIF($E28:$E32,\"SIGNAL\")),\"-\")","v":"-"},{"$f":"IF($E32=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!K21:K25,COUNTIF($E28:$E32,\"SIGNAL\")),\"-\")","v":"-"},"-","-","-","-"]
[null,null,null,null,"-",{"$f":"IF($E33=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!J21:J25,COUNTIF($E28:$E33,\"SIGNAL\")),\"-\")","v":"-"},"L6",{"$f":"IF($E33=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!M21:M25,COUNTIF($E28:$E33,\"SIGNAL\")),\"-\")","v":"-"},{"$f":"IF($E33=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!K21:K25,COUNTIF($E28:$E33,\"SIGNAL\")),\"-\")","v":"-"},"-","-","-","-"]
[null,null,null,null,"-",{"$f":"IF($E34=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!J21:J25,COUNTIF($E28:$E34,\"SIGNAL\")),\"-\")","v":"-"},"L7",{"$f":"IF($E34=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!M21:M25,COUNTIF($E28:$E34,\"SIGNAL\")),\"-\")","v":"-"},{"$f":"IF($E34=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!K21:K25,COUNTIF($E28:$E34,\"SIGNAL\")),\"-\")","v":"-"},"-","-","-","-"]
[null,null,null,null,"-",{"$f":"IF($E35=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!J21:J25,COUNTIF($E28:$E35,\"SIGNAL\")),\"-\")","v":"-"},"L8",{"$f":"IF($E35=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!M21:M25,COUNTIF($E28:$E35,\"SIGNAL\")),\"-\")","v":"-"},{"$f":"IF($E35=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!K21:K25,COUNTIF($E28:$E35,\"SIGNAL\")),\"-\")","v":"-"},"-","-","-","-"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["# Must select value (0-2); ^ Damper incidental to Support per CM&S 632 and SCD TC-81.22"]

{"sheet":"2 ARM DESIGN NO.","index":3,"n_rows":19,"n_cols":17,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,4,2,4],[3,4,4,4],[5,4,6,4],[7,4,8,4],[1,0,2,0],[3,0,4,0],[5,0,6,0],[7,0,8,0],[1,3,2,3],[3,3,4,3],[5,3,6,3],[7,3,8,3]]}
["SUPPORT NO.","ARM","DESIGN NO.","POLE SIZE REQ.","POLE DESIGNATION"]
["SP-2","A",12,{"$f":"VLOOKUP(SUMIFS($N$3:$N$67,$K$3:$K$67,C2,$L$3:$L$67,C3),$G$14:$H$26,2)","v":"D"},{"$f":"IF(D2=\"-\",\"-\",VLOOKUP(D2,$P$3:$Q$14,2,FALSE))","v":"TC-12.31 DES 10"},null,"-","-","-",null,"A","B","SIZE","FOR VLOOKUP"]
[null,"B",12,null,null,null,"SP-1","A",null,null,"-","-","-",100,null,"A","TC-81.22 DES 4"]
["-","-","-",{"$f":"VLOOKUP(SUMIFS($N$3:$N$67,$K$3:$K$67,C4,$L$3:$L$67,C5),$G$14:$H$26,2)","v":"-"},{"$f":"IF(D4=\"-\",\"-\",VLOOKUP(D4,$P$3:$Q$14,2,FALSE))","v":"-"},null,"SP-2","B",2,null,2,2,"A",101,null,"B","TC-81.22 DES 12"]
[null,"-","-",null,null,null,"SP-3","C",null,null,4,2,"B",102,null,"C","TC-12.31 DES 6"]
["-","-","-",{"$f":"VLOOKUP(SUMIFS($N$3:$N$67,$K$3:$K$67,C6,$L$3:$L$67,C7),$G$14:$H$26,2)","v":"-"},{"$f":"IF(D6=\"-\",\"-\",VLOOKUP(D6,$P$3:$Q$14,2,FALSE))","v":"-"},null,"SP-4","D",4,null,12,2,"C",103,null,"D","TC-12.31 DES 10"]
[null,"-","-",null,null,null,"SP-5",null,null,null,13,2,"D",104,null,"E","TC-12.31 DES 12"]
["-","-","-",{"$f":"VLOOKUP(SUMIFS($N$3:$N$67,$K$3:$K$67,C8,$L$3:$L$67,C9),$G$14:$H$26,2)","v":"-"},{"$f":"IF(D8=\"-\",\"-\",VLOOKUP(D8,$P$3:$Q$14,2,FALSE))","v":"-"},null,"SP-6",null,12,null,14,2,"D",104]
[null,"-","-",null,null,null,"SP-7",null,13,null,4,4,"C",103]
[null,null,null,null,null,null,"SP-8",null,14,null,12,4,"C",103]
[null,null,null,null,null,null,"SP-9",null,null,null,13,4,"D",104]
[null,null,null,null,null,null,"SP-10",null,null,null,14,4,"D",104]
[null,null,null,null,null,null,null,null,null,null,12,12,"D",104]
[null,null,null,null,null,null,100,"-",null,null,13,12,"D",104]
[null,null,null,null,null,null,101,"A",null,null,14,12,"D",104]
[null,null,null,null,null,null,102,"B",null,null,13,13,"D",104]
[null,null,null,null,null,null,103,"C",null,null,14,13,"E",105]
[null,null,null,null,null,null,104,"D",null,null,14,14,"E",105]
[null,null,null,null,null,null,105,"E"]