{"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":1,"rows_kept":5,"cut":false,"hidden":false,"merged":[[5,0,6,2],[0,0,1,2],[2,2,4,2]]}
["PROJECT INFORMATION"]
[]
["PROJECT/PID:"]
["INTERSECTION NAME:"]
["REV. DATE:"]

{"sheet":"MAST ARM HEIGHT","index":1,"n_rows":22,"n_cols":32,"rows_kept":22,"cut":false,"hidden":false,"merged":[[12,3,16,3],[0,8,1,8],[0,9,1,9],[0,19,1,19],[2,16,6,16],[2,17,6,17],[2,18,6,18],[2,19,6,19],[7,8,11,8],[2,3,6,3],[2,8,6,8],[2,4,6,4],[2,5,6,5],[2,6,6,6],[2,7,6,7],[0,10,1,10],[2,20,6,20],[2,21,6,21],[2,22,6,22],[0,0,1,0],[7,2,11,2],[7,3,11,3],[0,1,1,1],[2,1,6,1],[7,1,11,1],[17,2,21,2],[2,0,6,0],[2,2,6,2],[7,0,11,0],[12,0,16,0],[17,0,21,0],[12,2,16,2],[12,1,16,1],[17,1,21,1],[17,3,21,3],[7,22,11,22],[12,16,16,16],[12,17,16,17],[12,18,16,18],[12,19,16,19],[12,20,16,20],[12,21,16,21],[12,22,16,22],[7,16,11,16],[7,17,11,17],[7,18,11,18],[7,20,11,20],[7,21,11,21],[7,19,11,19],[17,21,21,21],[17,22,21,22],[17,16,21,16],[17,17,21,17],[17,18,21,18],[17,19,21,19],[17,20,21,20],[17,7,21,7],[7,4,11,4],[17,8,21,8],[17,4,21,4],[17,5,21,5],[17,6,21,6],[7,5,11,5],[7,6,11,6],[7,7,11,7],[12,4,16,4],[12,5,16,5],[12,6,16,6],[12,7,16,7],[12,8,16,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                TOP OF FOUNDATION","RISE ANGLE WITH HORIZONTAL ARM TIP ","SIGNAL HEADS CENTERED ON WHICH COLOR?","SIGNAL NO. ","SIGNAL HEAD TYPE                                                             (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 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,652.32000000000005,2,{"$f":"IF(E3=\"-\",\"-\",$E3+($F3/12))","v":652.48666666666668},0.5,"YELLOW","1A","3 SECTIONS",{"$f":"IF($I$3=\"-\",\"-\",VLOOKUP(K3,$AD$5:$AF$12,MATCH($I$3,$AE$4:$AF$4)+1))","v":2.2999999999999998},63.5,651.07000000000005,{"$f":"IF(M3=\"-\",\"-\",($C$3+$L3+$N3-(SIN(RADIANS($H$3))*$M3))-$G$3)","v":17.329198329186625},{"$f":"IF(M3=\"-\",\"-\",($D$3+$L3+$N3-(SIN(RADIANS($H$3))*$M3))-$G$3)","v":19.329198329186625},{"$f":"IF(O3=\"-\",\"-\",(MAX(O3:O7)))","v":18.441349552369047},{"$f":"IF(P3=\"-\",\"-\",MIN(P3:P7))","v":19.329198329186625},19,"YES",{"$f":"IF($T3=\"YES\",3.5,IF($T3=\"NO\",1.5,\"-\"))","v":3.5},{"$f":"IF(T3=\"-\",\"-\",$S3+$U3)","v":22.5},{"$f":"IF($T3=\"YES\",V3+10,IF($T3=\"NO\",\"N/A\",\"-\"))","v":32.5},null,null,null,"-","SP-1"]
[null,null,null,null,null,null,null,null,null,"1B","3 SECTIONS",{"$f":"IF($I$3=\"-\",\"-\",VLOOKUP(K4,$AD$5:$AF$12,MATCH($I$3,$AE$4:$AF$4)+1))","v":2.2999999999999998},52.5,651.29,{"$f":"IF(M4=\"-\",\"-\",($C$3+$L4+$N4-(SIN(RADIANS($H$3))*$M4))-$G$3)","v":17.645190219668621},{"$f":"IF(M4=\"-\",\"-\",($D$3+$L4+$N4-(SIN(RADIANS($H$3))*$M4))-$G$3)","v":19.645190219668621},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,"6A","3 SECTIONS",{"$f":"IF($I$3=\"-\",\"-\",VLOOKUP(K5,$AD$5:$AF$12,MATCH($I$3,$AE$4:$AF$4)+1))","v":2.2999999999999998},38.5,651.38,{"$f":"IF(M5=\"-\",\"-\",($C$3+$L5+$N5-(SIN(RADIANS($H$3))*$M5))-$G$3)","v":17.857361716645869},{"$f":"IF(M5=\"-\",\"-\",($D$3+$L5+$N5-(SIN(RADIANS($H$3))*$M5))-$G$3)","v":19.857361716645869},null,null,null,null,null,null,null,null,null,null,"RED","SP-3",null,"-","-","-"]
[null,null,null,null,null,null,null,null,null,"6B","5 SECTIONS - CLUSTER",{"$f":"IF($I$3=\"-\",\"-\",VLOOKUP(K6,$AD$5:$AF$12,MATCH($I$3,$AE$4:$AF$4)+1))","v":2.6},22,651.52,{"$f":"IF(M6=\"-\",\"-\",($C$3+$L6+$N6-(SIN(RADIANS($H$3))*$M6))-$G$3)","v":18.441349552369047},{"$f":"IF(M6=\"-\",\"-\",($D$3+$L6+$N6-(SIN(RADIANS($H$3))*$M6))-$G$3)","v":20.441349552369047},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,"-","-",{"$f":"IF($I$3=\"-\",\"-\",VLOOKUP(K7,$AD$5:$AF$12,MATCH($I$3,$AE$4:$AF$4)+1))","v":"-"},"-","-",{"$f":"IF(M7=\"-\",\"-\",($C$3+$L7+$N7-(SIN(RADIANS($H$3))*$M7))-$G$3)","v":"-"},{"$f":"IF(M7=\"-\",\"-\",($D$3+$L7+$N7-(SIN(RADIANS($H$3))*$M7))-$G$3)","v":"-"},null,null,null,null,null,null,null,null,null,null,"-","SP-5",null,"2 SECTIONS",2.625,1.625]
["SP-2","A",17,19,649.41,2,{"$f":"IF(E8=\"-\",\"-\",$E8+($F8/12))","v":649.5766666666666},0.5,"YELLOW","7A","3 SECTIONS",{"$f":"IF($I$8=\"-\",\"-\",VLOOKUP(K8,$AD$5:$AF$12,MATCH($I$8,$AE$4:$AF$4)+1))","v":2.2999999999999998},68,649.99,{"$f":"IF(M8=\"-\",\"-\",($C$8+$L8+$N8-(SIN(RADIANS($H$8))*$M8))-$G$8)","v":19.119928919443964},{"$f":"IF(M8=\"-\",\"-\",($D$8+$L8+$N8-(SIN(RADIANS($H$8))*$M8))-$G$8)","v":21.119928919443964},{"$f":"IF(O8=\"-\",\"-\",(MAX(O8:O12)))","v":19.119928919443964},{"$f":"IF(P8=\"-\",\"-\",MIN(P8:P12))","v":20.921912700408143},20,"YES",{"$f":"IF($T8=\"YES\",3.5,IF($T8=\"NO\",1.5,\"-\"))","v":3.5},{"$f":"IF(T8=\"-\",\"-\",$S8+$U8)","v":23.5},{"$f":"IF($T8=\"YES\",V8+10,IF($T8=\"NO\",\"N/A\",\"-\"))","v":33.5},null,null,null,"YES","SP-6",null,"3 SECTIONS",3.4,2.2999999999999998]
[null,null,null,null,null,null,null,null,null,"4A","3 SECTIONS",{"$f":"IF($I$8=\"-\",\"-\",VLOOKUP(K9,$AD$5:$AF$12,MATCH($I$8,$AE$4:$AF$4)+1))","v":2.2999999999999998},57,649.88,{"$f":"IF(M9=\"-\",\"-\",($C$8+$L9+$N9-(SIN(RADIANS($H$8))*$M9))-$G$8)","v":19.105920809926033},{"$f":"IF(M9=\"-\",\"-\",($D$8+$L9+$N9-(SIN(RADIANS($H$8))*$M9))-$G$8)","v":21.105920809926033},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,"4B","3 SECTIONS",{"$f":"IF($I$8=\"-\",\"-\",VLOOKUP(K10,$AD$5:$AF$12,MATCH($I$8,$AE$4:$AF$4)+1))","v":2.2999999999999998},46,649.6,{"$f":"IF(M10=\"-\",\"-\",($C$8+$L10+$N10-(SIN(RADIANS($H$8))*$M10))-$G$8)","v":18.921912700408143},{"$f":"IF(M10=\"-\",\"-\",($D$8+$L10+$N10-(SIN(RADIANS($H$8))*$M10))-$G$8)","v":20.921912700408143},null,null,null,null,null,null,null,null,null,null,null,"SP-8",null,"5 SECTIONS - CLUSTER",3.7,2.6]
[null,null,null,null,null,null,null,null,null,"-","-",{"$f":"IF($I$8=\"-\",\"-\",VLOOKUP(K11,$AD$5:$AF$12,MATCH($I$8,$AE$4:$AF$4)+1))","v":"-"},"-","-",{"$f":"IF(M11=\"-\",\"-\",($C$8+$L11+$N11-(SIN(RADIANS($H$8))*$M11))-$G$8)","v":"-"},{"$f":"IF(M11=\"-\",\"-\",($D$8+$L11+$N11-(SIN(RADIANS($H$8))*$M11))-$G$8)","v":"-"},null,null,null,null,null,null,null,null,null,null,"-","SP-9",null,"5 SECTIONS - MIXED",3.7,2.6]
[null,null,null,null,null,null,null,null,null,"-","-",{"$f":"IF($I$8=\"-\",\"-\",VLOOKUP(K12,$AD$5:$AF$12,MATCH($I$8,$AE$4:$AF$4)+1))","v":"-"},"-","-",{"$f":"IF(M12=\"-\",\"-\",($C$8+$L12+$N12-(SIN(RADIANS($H$8))*$M12))-$G$8)","v":"-"},{"$f":"IF(M12=\"-\",\"-\",($D$8+$L12+$N12-(SIN(RADIANS($H$8))*$M12))-$G$8)","v":"-"},null,null,null,null,null,null,null,null,null,null,0,"SP-10",null,"5 SECTIONS - VERTICAL",5.8,4.5999999999999996]
["SP-3","A",17,19,651.91,2,{"$f":"IF(E13=\"-\",\"-\",$E13+($F13/12))","v":652.0766666666666},0.5,"YELLOW","3A","3 SECTIONS",{"$f":"IF($I$13=\"-\",\"-\",VLOOKUP(K13,$AD$5:$AF$12,MATCH($I$13,$AE$4:$AF$4)+1))","v":2.2999999999999998},41.5,652.51,{"$f":"IF(M13=\"-\",\"-\",($C$13+$L13+$N13-(SIN(RADIANS($H$13))*$M13))-$G$13)","v":19.371182110150812},{"$f":"IF(M13=\"-\",\"-\",($D$13+$L13+$N13-(SIN(RADIANS($H$13))*$M13))-$G$13)","v":21.371182110150812},{"$f":"IF(O13=\"-\",\"-\",(MAX(O13:O17)))","v":19.371182110150812},{"$f":"IF(P13=\"-\",\"-\",MIN(P13:P17))","v":21.210994394137856},20,"YES",{"$f":"IF($T13=\"YES\",3.5,IF($T13=\"NO\",1.5,\"-\"))","v":3.5},{"$f":"IF(T13=\"-\",\"-\",$S13+$U13)","v":23.5},{"$f":"IF($T13=\"YES\",V13+10,IF($T13=\"NO\",\"N/A\",\"-\"))","v":33.5},null,null,null,0.5,"SP-11"]
[null,null,null,null,null,null,null,null,null,"8A","3 SECTIONS",{"$f":"IF($I$13=\"-\",\"-\",VLOOKUP(K14,$AD$5:$AF$12,MATCH($I$13,$AE$4:$AF$4)+1))","v":2.2999999999999998},33.5,652.28,{"$f":"IF(M14=\"-\",\"-\",($C$13+$L14+$N14-(SIN(RADIANS($H$13))*$M14))-$G$13)","v":19.210994394137856},{"$f":"IF(M14=\"-\",\"-\",($D$13+$L14+$N14-(SIN(RADIANS($H$13))*$M14))-$G$13)","v":21.210994394137856},null,null,null,null,null,null,null,null,null,null,1,"SP-12"]
[null,null,null,null,null,null,null,null,null,"8B","5 SECTIONS - CLUSTER",{"$f":"IF($I$13=\"-\",\"-\",VLOOKUP(K15,$AD$5:$AF$12,MATCH($I$13,$AE$4:$AF$4)+1))","v":2.6},24,651.9,{"$f":"IF(M15=\"-\",\"-\",($C$13+$L15+$N15-(SIN(RADIANS($H$13))*$M15))-$G$13)","v":19.213896481372444},{"$f":"IF(M15=\"-\",\"-\",($D$13+$L15+$N15-(SIN(RADIANS($H$13))*$M15))-$G$13)","v":21.213896481372444},null,null,null,null,null,null,null,null,null,null,1.5,"SP-13"]
[null,null,null,null,null,null,null,null,null,"-","-",{"$f":"IF($I$13=\"-\",\"-\",VLOOKUP(K16,$AD$5:$AF$12,MATCH($I$13,$AE$4:$AF$4)+1))","v":"-"},"-","-",{"$f":"IF(M16=\"-\",\"-\",($C$13+$L16+$N16-(SIN(RADIANS($H$13))*$M16))-$G$13)","v":"-"},{"$f":"IF(M16=\"-\",\"-\",($D$13+$L16+$N16-(SIN(RADIANS($H$13))*$M16))-$G$13)","v":"-"},null,null,null,null,null,null,null,null,null,null,2,"SP-14"]
[null,null,null,null,null,null,null,null,null,"-","-",{"$f":"IF($I$13=\"-\",\"-\",VLOOKUP(K17,$AD$5:$AF$12,MATCH($I$13,$AE$4:$AF$4)+1))","v":"-"},"-","-",{"$f":"IF(M17=\"-\",\"-\",($C$13+$L17+$N17-(SIN(RADIANS($H$13))*$M17))-$G$13)","v":"-"},{"$f":"IF(M17=\"-\",\"-\",($D$13+$L17+$N17-(SIN(RADIANS($H$13))*$M17))-$G$13)","v":"-"},null,null,null,null,null,null,null,null,null,null,2.5,"SP-15"]
["SP-4","A",17,19,650.35,2,{"$f":"IF(E18=\"-\",\"-\",$E18+($F18/12))","v":650.51666666666665},0.5,"YELLOW","5A","3 SECTIONS",{"$f":"IF($I$18=\"-\",\"-\",VLOOKUP(K18,$AD$5:$AF$12,MATCH($I$18,$AE$4:$AF$4)+1))","v":2.2999999999999998},68.5,651.57000000000005,{"$f":"IF(M18=\"-\",\"-\",($C$18+$L18+$N18-(SIN(RADIANS($H$18))*$M18))-$G$18)","v":19.755565651694724},{"$f":"IF(M18=\"-\",\"-\",($D$18+$L18+$N18-(SIN(RADIANS($H$18))*$M18))-$G$18)","v":21.755565651694724},{"$f":"IF(O18=\"-\",\"-\",(MAX(O18:O22)))","v":19.755565651694724},{"$f":"IF(P18=\"-\",\"-\",MIN(P18:P22))","v":21.000806678124832},20,"YES",{"$f":"IF($T18=\"YES\",3.5,IF($T18=\"NO\",1.5,\"-\"))","v":3.5},{"$f":"IF(T18=\"-\",\"-\",$S18+$U18)","v":23.5},{"$f":"IF($T18=\"YES\",V18+10,IF($T18=\"NO\",\"N/A\",\"-\"))","v":33.5},null,null,null,3,"-"]
[null,null,null,null,null,null,null,null,null,"2A","3 SECTIONS",{"$f":"IF($I$18=\"-\",\"-\",VLOOKUP(K19,$AD$5:$AF$12,MATCH($I$18,$AE$4:$AF$4)+1))","v":2.2999999999999998},47.5,651.02,{"$f":"IF(M19=\"-\",\"-\",($C$18+$L19+$N19-(SIN(RADIANS($H$18))*$M19))-$G$18)","v":19.38882289716048},{"$f":"IF(M19=\"-\",\"-\",($D$18+$L19+$N19-(SIN(RADIANS($H$18))*$M19))-$G$18)","v":21.38882289716048},null,null,null,null,null,null,null,null,null,null,null,"A"]
[null,null,null,null,null,null,null,null,null,"2B","3 SECTIONS",{"$f":"IF($I$18=\"-\",\"-\",VLOOKUP(K20,$AD$5:$AF$12,MATCH($I$18,$AE$4:$AF$4)+1))","v":2.2999999999999998},35.5,650.71,{"$f":"IF(M20=\"-\",\"-\",($C$18+$L20+$N20-(SIN(RADIANS($H$18))*$M20))-$G$18)","v":19.183541323141071},{"$f":"IF(M20=\"-\",\"-\",($D$18+$L20+$N20-(SIN(RADIANS($H$18))*$M20))-$G$18)","v":21.183541323141071},null,null,null,null,null,null,null,null,null,null,null,"B"]
[null,null,null,null,null,null,null,null,null,"2C","3 SECTIONS",{"$f":"IF($I$18=\"-\",\"-\",VLOOKUP(K21,$AD$5:$AF$12,MATCH($I$18,$AE$4:$AF$4)+1))","v":2.2999999999999998},25.5,650.44000000000005,{"$f":"IF(M21=\"-\",\"-\",($C$18+$L21+$N21-(SIN(RADIANS($H$18))*$M21))-$G$18)","v":19.000806678124832},{"$f":"IF(M21=\"-\",\"-\",($D$18+$L21+$N21-(SIN(RADIANS($H$18))*$M21))-$G$18)","v":21.000806678124832},null,null,null,null,null,null,null,null,null,null,null,"C"]
[null,null,null,null,null,null,null,null,null,"-","-",{"$f":"IF($I$18=\"-\",\"-\",VLOOKUP(K22,$AD$5:$AF$12,MATCH($I$18,$AE$4:$AF$4)+1))","v":"-"},"-","-",{"$f":"IF(M22=\"-\",\"-\",($C$18+$L22+$N22-(SIN(RADIANS($H$18))*$M22))-$G$18)","v":"-"},{"$f":"IF(M22=\"-\",\"-\",($D$18+$L22+$N22-(SIN(RADIANS($H$18))*$M22))-$G$18)","v":"-"},null,null,null,null,null,null,null,null,null,null,null,"D"]

{"sheet":"MAST ARM DESIGN NO.","index":2,"n_rows":35,"n_cols":32,"rows_kept":35,"cut":false,"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]]}
["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?","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,"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,25,"SIGNAL",{"$f":"IF($E4=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!J3:J7,COUNTIF($E4,\"SIGNAL\")),\"-\")","v":"1A"},"L1",{"$f":"IF(E4=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!M3:M7,COUNTIF(E4,\"SIGNAL\")),\"-\")","v":63.5},{"$f":"IF(E4=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!K3:K7,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":552.44999999999993},66,{"$f":"IF(N4=\"-\",\"-\",IF(N4>39,\"YES\",\"NO\"))","v":"YES"},{"$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":2350.0749999999998},{"$f":"IF($P4=\"-\",\"-\",IF($P4<=$Z$23,VLOOKUP($Z$23,$AA$4:$AB$11,2),$AA$23))","v":14},null,"-",null,12,null,null,null,null,null,637,1,null,"K","DESIGN NO.","MAX ARM LENGTH (FT)"]
[null,null,null,null,"SIGNAL",{"$f":"IF($E5=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!J3:J7,COUNTIF($E4:$E5,\"SIGNAL\")),\"-\")","v":"1B"},"L2",{"$f":"IF($E5=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!M3:M7,COUNTIF($E4:$E5,\"SIGNAL\")),\"-\")","v":52.5},{"$f":"IF($E5=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!K3:K7,COUNTIF($E4:$E5,\"SIGNAL\")),\"-\")","v":"3 SECTIONS"},"-","-",8.6999999999999993,456.74999999999994,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:J7,COUNTIF($E4:$E6,\"SIGNAL\")),\"-\")","v":"6A"},"L3",{"$f":"IF($E6=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!M3:M7,COUNTIF($E4:$E6,\"SIGNAL\")),\"-\")","v":38.5},{"$f":"IF($E6=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!K3:K7,COUNTIF($E4:$E6,\"SIGNAL\")),\"-\")","v":"3 SECTIONS"},"-","-",8.6999999999999993,334.95,null,null,null,null,null,12,"1 SECTION",4,null,null,null,null,null,937.5,3,null,2380,13,60]
[null,null,null,null,"SIGNAL",{"$f":"IF($E7=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!J3:J7,COUNTIF($E4:$E7,\"SIGNAL\")),\"-\")","v":"6B"},"L4",{"$f":"IF($E7=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!M3:M7,COUNTIF($E4:$E7,\"SIGNAL\")),\"-\")","v":22},{"$f":"IF($E7=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!K3:K7,COUNTIF($E4:$E7,\"SIGNAL\")),\"-\")","v":"5 SECTIONS - CLUSTER"},"-","-",12.4,272.8,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","S3","L5",58.5,{"$f":"IF($E8=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!K3:K7,COUNTIF($E4:$E8,\"SIGNAL\")),\"-\")","v":"-"},54,30,11.25,658.125,null,null,null,null,null,null,"3 SECTIONS",8.6999999999999993,null,null,null,null,null,1780,11,null,1780,11,45]
[null,null,null,null,"-",{"$f":"IF($E9=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!J3:J7,COUNTIF($E4:$E9,\"SIGNAL\")),\"-\")","v":"-"},"L6",{"$f":"IF($E9=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!M3:M7,COUNTIF($E4:$E9,\"SIGNAL\")),\"-\")","v":"-"},{"$f":"IF($E9=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!K3:K7,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:J7,COUNTIF($E4:$E10,\"SIGNAL\")),\"-\")","v":"-"},"L7",{"$f":"IF($E10=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!M3:M7,COUNTIF($E4:$E10,\"SIGNAL\")),\"-\")","v":"-"},{"$f":"IF($E10=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!K3:K7,COUNTIF($E4:$E10,\"SIGNAL\")),\"-\")","v":"-"},"-","-","-","-",null,null,null,null,null,null,"5 SECTIONS - CLUSTER",12.4,null,null,null,null,null,2380,13,null,937.5,3,38]
[null,null,null,null,"-",{"$f":"IF($E11=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!J3:J7,COUNTIF($E4:$E11,\"SIGNAL\")),\"-\")","v":"-"},"L8",{"$f":"IF($E11=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!M3:M7,COUNTIF($E4:$E11,\"SIGNAL\")),\"-\")","v":"-"},{"$f":"IF($E11=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!K3:K7,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'!A8","v":"SP-2"},{"$f":"'MAST ARM HEIGHT'!B8","v":"A"},1,25,"SIGNAL",{"$f":"IF($E12=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!J8:J12,COUNTIF($E12,\"SIGNAL\")),\"-\")","v":"7A"},"L1",{"$f":"IF($E12=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!M8:M12,COUNTIF($E12,\"SIGNAL\")),\"-\")","v":68},{"$f":"IF($E12=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!K8:K12,COUNTIF($E12,\"SIGNAL\")),\"-\")","v":"3 SECTIONS"},"-","-",8.6999999999999993,591.59999999999991,70,{"$f":"IF(N12=\"-\",\"-\",IF(N12>39,\"YES\",\"NO\"))","v":"YES"},{"$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":1726.7},{"$f":"IF($P12=\"-\",\"-\",IF($P12<=$Z$24,VLOOKUP($Z$24,$AA$4:$AB$11,2),$AA$24))","v":14},null,"-","5 SECTIONS - VERTICAL",13.3,null,null,null,null,null,null,null,null,637,1,25]
[null,null,null,null,"SIGNAL",{"$f":"IF($E13=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!J8:J12,COUNTIF($E12:$E13,\"SIGNAL\")),\"-\")","v":"4A"},"L2",{"$f":"IF($E13=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!M8:M12,COUNTIF($E12:$E13,\"SIGNAL\")),\"-\")","v":57},{"$f":"IF($E13=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!K8:K12,COUNTIF($E12:$E13,\"SIGNAL\")),\"-\")","v":"3 SECTIONS"},"-","-",8.6999999999999993,495.9,null,null,null,null,null,"SIGNAL"]
[null,null,null,null,"SIGNAL",{"$f":"IF($E14=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!J8:J12,COUNTIF($E12:$E14,\"SIGNAL\")),\"-\")","v":"4B"},"L3",{"$f":"IF($E14=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!M8:M12,COUNTIF($E12:$E14,\"SIGNAL\")),\"-\")","v":46},{"$f":"IF($E14=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!K8:K12,COUNTIF($E12:$E14,\"SIGNAL\")),\"-\")","v":"3 SECTIONS"},"-","-",8.6999999999999993,400.2,null,null,null,null,null,"SIGN"]
[null,null,null,null,"SIGN","S1","L4",41,{"$f":"IF($E15=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!K8:K12,COUNTIF($E12:$E15,\"SIGNAL\")),\"-\")","v":"-"},24,24,4,164]
[null,null,null,"-","-",{"$f":"IF($E16=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!J8:J12,COUNTIF($E12:$E16,\"SIGNAL\")),\"-\")","v":"-"},"L5",{"$f":"IF($E16=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!M8:M12,COUNTIF($E12:$E16,\"SIGNAL\")),\"-\")","v":"-"},{"$f":"IF($E16=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!K8:K12,COUNTIF($E12:$E16,\"SIGNAL\")),\"-\")","v":"-"},"-","-","-","-",null,null,null,null,null,"-"]
[null,null,null,null,"-",{"$f":"IF($E17=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!J8:J12,COUNTIF($E12:$E17,\"SIGNAL\")),\"-\")","v":"-"},"L6",{"$f":"IF($E17=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!M8:M12,COUNTIF($E12:$E17,\"SIGNAL\")),\"-\")","v":"-"},{"$f":"IF($E17=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!K8:K12,COUNTIF($E12:$E17,\"SIGNAL\")),\"-\")","v":"-"},"-","-","-","-",null,null,null,null,null,0]
[null,null,null,null,"-",{"$f":"IF($E18=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!J8:J12,COUNTIF($E12:$E18,\"SIGNAL\")),\"-\")","v":"-"},"L7",{"$f":"IF($E18=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!M8:M12,COUNTIF($E12:$E18,\"SIGNAL\")),\"-\")","v":"-"},{"$f":"IF($E18=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!K8:K12,COUNTIF($E12:$E18,\"SIGNAL\")),\"-\")","v":"-"},"-","-","-","-",null,null,null,null,null,1]
[null,null,null,null,"-",{"$f":"IF($E19=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!J8:J12,COUNTIF($E12:$E19,\"SIGNAL\")),\"-\")","v":"-"},"L8",{"$f":"IF($E19=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!M8:M12,COUNTIF($E12:$E19,\"SIGNAL\")),\"-\")","v":"-"},{"$f":"IF($E19=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!K8:K12,COUNTIF($E12:$E19,\"SIGNAL\")),\"-\")","v":"-"},"-","-","-","-",null,null,null,null,null,2]
[{"$f":"'MAST ARM HEIGHT'!A13","v":"SP-3"},{"$f":"'MAST ARM HEIGHT'!B13","v":"A"},1,25,"SIGNAL",{"$f":"IF($E20=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!J13:J17,COUNTIF($E20,\"SIGNAL\")),\"-\")","v":"3A"},"L1",{"$f":"IF($E20=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!M13:M17,COUNTIF($E20,\"SIGNAL\")),\"-\")","v":41.5},{"$f":"IF($E20=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!K13:K17,COUNTIF($E20,\"SIGNAL\")),\"-\")","v":"3 SECTIONS"},"-","-",8.6999999999999993,361.04999999999995,44,{"$f":"IF(N20=\"-\",\"-\",IF(N20>39,\"YES\",\"NO\"))","v":"YES"},{"$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":1099.0999999999999},{"$f":"IF($P20=\"-\",\"-\",IF($P20<=$Z$25,VLOOKUP($Z$25,$AA$4:$AB$11,2),$AA$25))","v":11}]
[null,null,null,null,"SIGNAL",{"$f":"IF($E21=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!J13:J17,COUNTIF($E20:$E21,\"SIGNAL\")),\"-\")","v":"8A"},"L2",{"$f":"IF($E21=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!M13:M17,COUNTIF($E20:$E21,\"SIGNAL\")),\"-\")","v":33.5},{"$f":"IF($E21=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!K13:K17,COUNTIF($E20:$E21,\"SIGNAL\")),\"-\")","v":"3 SECTIONS"},"-","-",8.6999999999999993,291.45]
[null,null,null,null,"SIGNAL",{"$f":"IF($E22=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!J13:J17,COUNTIF($E20:$E22,\"SIGNAL\")),\"-\")","v":"8B"},"L3",{"$f":"IF($E22=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!M13:M17,COUNTIF($E20:$E22,\"SIGNAL\")),\"-\")","v":24},{"$f":"IF($E22=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!K13:K17,COUNTIF($E20:$E22,\"SIGNAL\")),\"-\")","v":"5 SECTIONS - CLUSTER"},"-","-",12.4,297.60000000000002,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",18.5,{"$f":"IF($E23=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!K13:K17,COUNTIF($E20:$E23,\"SIGNAL\")),\"-\")","v":"-"},24,24,4,74,null,null,null,null,null,1,null,null,null,null,null,1,{"$f":"INDEX(AD5:AD12,MATCH(N4,$AF$5:$AF$12,-1))","v":2641},{"$f":"INDEX($AE$5:$AE$12,MATCH($P4,$AD$5:$AD$12,-1))","v":13}]
[null,null,null,"-","-",{"$f":"IF($E24=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!J13:J17,COUNTIF($E20:$E24,\"SIGNAL\")),\"-\")","v":"-"},"L5",{"$f":"IF($E24=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!M13:M17,COUNTIF($E20:$E24,\"SIGNAL\")),\"-\")","v":"-"},{"$f":"IF($E24=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!K13:K17,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":2641},{"$f":"INDEX($AE$5:$AE$12,MATCH($P12,$AD$5:$AD$12,-1))","v":11}]
[null,null,null,null,"-",{"$f":"IF($E25=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!J13:J17,COUNTIF($E20:$E25,\"SIGNAL\")),\"-\")","v":"-"},"L6",{"$f":"IF($E25=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!M13:M17,COUNTIF($E20:$E25,\"SIGNAL\")),\"-\")","v":"-"},{"$f":"IF($E25=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!K13:K17,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":1780},{"$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'!J13:J17,COUNTIF($E20:$E26,\"SIGNAL\")),\"-\")","v":"-"},"L7",{"$f":"IF($E26=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!M13:M17,COUNTIF($E20:$E26,\"SIGNAL\")),\"-\")","v":"-"},{"$f":"IF($E26=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!K13:K17,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":2641},{"$f":"INDEX($AE$5:$AE$12,MATCH($P28,$AD$5:$AD$12,-1))","v":13}]
[null,null,null,null,"-",{"$f":"IF($E27=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!J13:J17,COUNTIF($E20:$E27,\"SIGNAL\")),\"-\")","v":"-"},"L8",{"$f":"IF($E27=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!M13:M17,COUNTIF($E20:$E27,\"SIGNAL\")),\"-\")","v":"-"},{"$f":"IF($E27=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!K13:K17,COUNTIF($E20:$E27,\"SIGNAL\")),\"-\")","v":"-"},"-","-","-","-"]
[{"$f":"'MAST ARM HEIGHT'!A18","v":"SP-4"},{"$f":"'MAST ARM HEIGHT'!B18","v":"A"},1,25,"SIGNAL",{"$f":"IF($E28=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!J18:J22,COUNTIF($E28,\"SIGNAL\")),\"-\")","v":"5A"},"L1",{"$f":"IF($E28=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!M18:M22,COUNTIF($E28,\"SIGNAL\")),\"-\")","v":68.5},{"$f":"IF($E28=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!K18:K22,COUNTIF($E28,\"SIGNAL\")),\"-\")","v":"3 SECTIONS"},"-","-",8.6999999999999993,595.94999999999993,70,{"$f":"IF(N28=\"-\",\"-\",IF(N28>39,\"YES\",\"NO\"))","v":"YES"},{"$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":2312.3999999999996},{"$f":"IF($P28=\"-\",\"-\",IF($P28<=$Z$26,VLOOKUP($Z$26,$AA$4:$AB$11,2),$AA$26))","v":14},null,"-"]
[null,null,null,null,"SIGNAL",{"$f":"IF($E29=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!J18:J22,COUNTIF($E28:$E29,\"SIGNAL\")),\"-\")","v":"2A"},"L2",{"$f":"IF($E29=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!M18:M22,COUNTIF($E28:$E29,\"SIGNAL\")),\"-\")","v":47.5},{"$f":"IF($E29=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!K18:K22,COUNTIF($E28:$E29,\"SIGNAL\")),\"-\")","v":"3 SECTIONS"},"-","-",8.6999999999999993,413.24999999999994,null,null,null,null,null,"A"]
[null,null,null,null,"SIGNAL",{"$f":"IF($E30=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!J18:J22,COUNTIF($E28:$E30,\"SIGNAL\")),\"-\")","v":"2B"},"L3",{"$f":"IF($E30=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!M18:M22,COUNTIF($E28:$E30,\"SIGNAL\")),\"-\")","v":35.5},{"$f":"IF($E30=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!K18:K22,COUNTIF($E28:$E30,\"SIGNAL\")),\"-\")","v":"3 SECTIONS"},"-","-",8.6999999999999993,308.84999999999997,null,null,null,null,null,"B"]
[null,null,null,null,"SIGNAL",{"$f":"IF($E31=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!J18:J22,COUNTIF($E28:$E31,\"SIGNAL\")),\"-\")","v":"2C"},"L4",{"$f":"IF($E31=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!M18:M22,COUNTIF($E28:$E31,\"SIGNAL\")),\"-\")","v":25.5},{"$f":"IF($E31=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!K18:K22,COUNTIF($E28:$E31,\"SIGNAL\")),\"-\")","v":"3 SECTIONS"},"-","-",8.6999999999999993,221.85]
[null,null,null,"-","SIGN","S4","L5",62,{"$f":"IF($E32=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!K18:K22,COUNTIF($E28:$E32,\"SIGNAL\")),\"-\")","v":"-"},54,30,11.25,697.5]
[null,null,null,null,"-",{"$f":"IF($E33=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!J18:J22,COUNTIF($E28:$E33,\"SIGNAL\")),\"-\")","v":"-"},"L6",{"$f":"IF($E33=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!M18:M22,COUNTIF($E28:$E33,\"SIGNAL\")),\"-\")","v":"-"},{"$f":"IF($E33=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!K18:K22,COUNTIF($E28:$E33,\"SIGNAL\")),\"-\")","v":"-"},"-","-","-","-"]
[null,null,null,null,"-",{"$f":"IF($E34=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!J18:J22,COUNTIF($E28:$E34,\"SIGNAL\")),\"-\")","v":"-"},"L7",{"$f":"IF($E34=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!M18:M22,COUNTIF($E28:$E34,\"SIGNAL\")),\"-\")","v":"-"},{"$f":"IF($E34=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!K18:K22,COUNTIF($E28:$E34,\"SIGNAL\")),\"-\")","v":"-"},"-","-","-","-"]
[null,null,null,null,"-",{"$f":"IF($E35=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!J18:J22,COUNTIF($E28:$E35,\"SIGNAL\")),\"-\")","v":"-"},"L8",{"$f":"IF($E35=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!M18:M22,COUNTIF($E28:$E35,\"SIGNAL\")),\"-\")","v":"-"},{"$f":"IF($E35=\"SIGNAL\",INDEX('MAST ARM HEIGHT'!K18:K22,COUNTIF($E28:$E35,\"SIGNAL\")),\"-\")","v":"-"},"-","-","-","-"]

{"sheet":"2 ARM DESIGN NO.","index":3,"n_rows":67,"n_cols":17,"rows_kept":67,"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"]
["-","-","-",{"$f":"VLOOKUP(SUMIFS($N$3:$N$67,$K$3:$K$67,C2,$L$3:$L$67,C3),$G$14:$H$26,2)","v":"-"},{"$f":"IF(D2=\"-\",\"-\",VLOOKUP(D2,$P$3:$Q$14,2,FALSE))","v":"-"},null,"-","-","-",null,"A","B","SIZE","FOR VLOOKUP"]
[null,"-","-",null,null,null,"SP-1","A",1,null,"-","-","-",100,null,"A","TC-81.21 DES 3"]
["-","-","-",{"$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,1,1,"A",101,null,"B","TC-81.21 DES 4"]
[null,"-","-",null,null,null,"SP-3","C",3,null,2,1,"A",101,null,"C","TC-81.21 DES 11"]
["-","-","-",{"$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,3,1,"B",102,null,"D","TC-81.21 DES 12"]
[null,"-","-",null,null,null,"SP-5",null,11,null,4,1,"C",103,null,"E","TC-12.30 DES 5"]
["-","-","-",{"$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,11,1,"D",104,null,"F","TC-12.30 DES 6"]
[null,"-","-",null,null,null,"SP-7",null,13,null,12,1,"E",105,null,"G","TC-12.30 DES 7"]
[null,null,null,null,null,null,"SP-8",null,14,null,13,1,"G",107,null,"H","TC-12.30 DES 8"]
[null,null,null,null,null,null,"SP-9",null,null,null,14,1,"I",109,null,"I","TC-12.30 DES 9"]
[null,null,null,null,null,null,"SP-10",null,null,null,1,2,"A",101,null,"J","TC-12.30 DES 10"]
[null,null,null,null,null,null,null,null,null,null,2,2,"B",102,null,"K","TC-12.30 DES 11"]
[null,null,null,null,null,null,100,"-",null,null,3,2,"B",102,null,"L","TC-12.30 DES 12"]
[null,null,null,null,null,null,101,"A",null,null,4,2,"C",103]
[null,null,null,null,null,null,102,"B",null,null,11,2,"D",104]
[null,null,null,null,null,null,103,"C",null,null,12,2,"E",105]
[null,null,null,null,null,null,104,"D",null,null,13,2,"G",107]
[null,null,null,null,null,null,105,"E",null,null,14,2,"I",109]
[null,null,null,null,null,null,106,"F",null,null,1,3,"B",102]
[null,null,null,null,null,null,107,"G",null,null,2,3,"B",102]
[null,null,null,null,null,null,108,"H",null,null,3,3,"B",102]
[null,null,null,null,null,null,109,"I",null,null,4,3,"D",104]
[null,null,null,null,null,null,110,"J",null,null,11,3,"D",104]
[null,null,null,null,null,null,111,"K",null,null,12,3,"E",105]
[null,null,null,null,null,null,112,"L",null,null,13,3,"G",107]
[null,null,null,null,null,null,null,null,null,null,14,3,"I",109]
[null,null,null,null,null,null,null,null,null,null,1,4,"C",103]
[null,null,null,null,null,null,null,null,null,null,2,4,"C",103]
[null,null,null,null,null,null,null,null,null,null,3,4,"D",104]
[null,null,null,null,null,null,null,null,null,null,4,4,"E",105]
[null,null,null,null,null,null,null,null,null,null,11,4,"E",105]
[null,null,null,null,null,null,null,null,null,null,12,4,"F",106]
[null,null,null,null,null,null,null,null,null,null,13,4,"H",108]
[null,null,null,null,null,null,null,null,null,null,14,4,"I",109]
[null,null,null,null,null,null,null,null,null,null,1,11,"D",104]
[null,null,null,null,null,null,null,null,null,null,2,11,"D",104]
[null,null,null,null,null,null,null,null,null,null,3,11,"D",104]
[null,null,null,null,null,null,null,null,null,null,4,11,"E",105]
[null,null,null,null,null,null,null,null,null,null,11,11,"F",106]
[null,null,null,null,null,null,null,null,null,null,12,11,"F",106]
[null,null,null,null,null,null,null,null,null,null,13,11,"H",108]
[null,null,null,null,null,null,null,null,null,null,14,11,"J",110]
[null,null,null,null,null,null,null,null,null,null,1,12,"E",105]
[null,null,null,null,null,null,null,null,null,null,2,12,"E",105]
[null,null,null,null,null,null,null,null,null,null,3,12,"E",105]
[null,null,null,null,null,null,null,null,null,null,4,12,"F",106]
[null,null,null,null,null,null,null,null,null,null,11,12,"F",106]
[null,null,null,null,null,null,null,null,null,null,12,12,"G",107]
[null,null,null,null,null,null,null,null,null,null,13,12,"I",109]
[null,null,null,null,null,null,null,null,null,null,14,12,"J",110]
[null,null,null,null,null,null,null,null,null,null,1,13,"G",107]
[null,null,null,null,null,null,null,null,null,null,2,13,"G",107]
[null,null,null,null,null,null,null,null,null,null,3,13,"G",107]
[null,null,null,null,null,null,null,null,null,null,4,13,"H",108]
[null,null,null,null,null,null,null,null,null,null,11,13,"H",108]
[null,null,null,null,null,null,null,null,null,null,12,13,"I",109]
[null,null,null,null,null,null,null,null,null,null,13,13,"I",109]
[null,null,null,null,null,null,null,null,null,null,14,13,"K",111]
[null,null,null,null,null,null,null,null,null,null,1,14,"I",109]
[null,null,null,null,null,null,null,null,null,null,2,14,"I",109]
[null,null,null,null,null,null,null,null,null,null,3,14,"I",109]
[null,null,null,null,null,null,null,null,null,null,4,14,"I",109]
[null,null,null,null,null,null,null,null,null,null,11,14,"J",110]
[null,null,null,null,null,null,null,null,null,null,12,14,"J",110]
[null,null,null,null,null,null,null,null,null,null,13,14,"K",111]
[null,null,null,null,null,null,null,null,null,null,14,14,"L",112]