{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["POLE CAPACITY PROGRAM","USER GUIDE","PROGRAM ASSUMPTIONS","POLES DATA","DEFLECTION","MACRO1"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":85,"comments":5,"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":"POLE CAPACITY PROGRAM","index":0,"n_rows":176,"n_cols":81,"rows_kept":176,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,"POLE CAPACITY PROGRAM",null,null,null,null,"by W. Szto   Release - version Jul 2012",null,null,null,null,null,null,null,null,null,null,null,"POLE SHAFT PULL DOWN MENU, Added by Carl Wong",null,null,null,null,null,"TABLE, ADDED BY CARL WONG"]
["GENERAL",null,null,null,null,null,null,null,null,null,null,null,null,"[UPDATED BY CARL WONG, NOVEMBER 2010, TIAN WANG, JUNE 2012]",null,null,null,null,null,null,null,null,"T1","2A",null,null,null,null,"TOTAL POLE HEIGHT"]
[null,null,null,"PROJECT DESIGNER:",null,null,null,null,"COMPANY NAME:",null,null,null,null,null,null,null,null,null,null,null,null,null,"T3","2C"]
[null,null,null,"PROJECT LOCATION:",null,null,null,null,"PROJECT CITY:",null,null,null,null,null,null,null,null,null,null,null,null,null,"T6",null,null,null,null,null,"POLE SHAFT",null,{"$f":"VLOOKUP($A$10,'POLES DATA'!$A$81:$J$89,4,FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,"PROJECT NO.:",null,null,null,null,"DRAWING NO.:",null,null,null,null,null,null,null,null,null,null,null,null,null,"T7",null,null,null,null,null,"LUMINAIRE EXTENSION",null,{"$f":"IF($A$12<>0,VLOOKUP($A$12,'POLES DATA'!$A$17:$J$77,4,FALSE),)","v":0}]
[null,null,null,"DATE:",{"$f":"NOW()","v":"2023-09-20T14:35:06.820"},null,null,null,"POLE NO.:",null,null,null,null,null,null,null,null,null,null,null,null,null,"L",null,null,null,null,null,"LUMINAIRE",null,2500]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"M",null,null,null,null,null,"TOTAL HEIGHT",null,{"$f":"SUM(AE4:AE6)","v":{"$error":"#N/A"}}]
["WIND PRESSURE =",null,null,null,100,"PASCALS",null,null,null,null,"COMBINED FORCE RATIOS",null,null,null,null,null,null,null,null,null,null,null,"S"]
["POLES",null,null,null,null,null,null,null,null,null,"  BOTTOM OF POLE",null,{"$f":"IF(ISERROR($G$87),\" \",G87)","v":" "},null,null,null,null,null,null,null,null,null,"H"]
[null,"POLE SHAFT                 -",null,null,null,"T1, T3, T6, T7, S, L, M, H",null,null,null,null,"    ANCHOR BOLTS ",null,{"$f":"IF(ISERROR(R85),\"\",R85)","v":""}]
[null,"LUMINAIRE ARM              -",null,null,null,{"$f":"IF(LEN($A$10)=0,\" \",VLOOKUP($A$10,'POLES DATA'!$A$4:$J$12,2,FALSE))","v":" "},null,null,null,null,null,"  ARM  ",{"$f":"IF(ISERROR(G98),\"\",G98)","v":""}]
[null,"LUMINAIRE ARM EXTENSION    - ",null,null,null,{"$f":"IF(LEN($A$10)=0,\" \",VLOOKUP($A$10,'POLES DATA'!$A$4:$J$12,3,FALSE))","v":" "},null,null,null,null,"    FLANGE BOLTS",null,{"$f":"IF($A$10=\"S\",IF(ISERROR($P$109),\"\",$P$109),IF(ISERROR($P$98),\"\",$P$98))","v":""}]
["SIGNAL ARMS",null,null,null,null,null,null,null,null,null,"     TOP OF POLE",null,{"$f":"IF(OR(OR(OR(A10=\"T1\",A10=\"T3\"),A10=\"T6\"),A10=\"T7\"),\"N/A\",IF(ISERROR(I85),\"\",I85))","v":""},null,null,null,null,null,null,null,null,null,"TABLE, ADDED BY CARL WONG"]
[null,"FOR T1,T3,T6,T7,L, M & S",null,null,null,null,null,null,null,null,"Highlighted cells:RATIO>1.00 NO GOOD",null,null,null,null,"SUPERCEDED",null,null,null,null,null,null,"ARM LENGTH CALC.",null,"SIGNAL ARM","SIGN ARM","LARGE RADIUS CHECK","SMALL. RADIUS","THK CHECK"]
[null,"SIGNAL ARM ADAPTOR         -",null,null,null,{"$f":"IF(LEN($A$10)=0,\" \",VLOOKUP($A$10,'POLES DATA'!$A$4:$J$12,6,FALSE))","v":" "},null,null,null,null,null,null,null,null,null,{"$f":"IF(A15=0,0,0.3)","v":0},"(FOR ",null,null,null,null,null,"SIGNAL ARM ADAPTOR",null,{"$f":"IF($A$15<>0,VLOOKUP($A$15,'POLES DATA'!$A$17:$J$77,3,FALSE),0)","v":0},null,{"$f":"IF($A$15=\"\",\"\",VLOOKUP($A$15,'POLES DATA'!$A$17:$J$77,9,FALSE)/2)","v":""},{"$f":"IF($A$15=\"\",\"\",VLOOKUP($A$15,'POLES DATA'!$A$17:$J$77,10,FALSE)/2)","v":""},{"$f":"IF(AND($E$18<>0,$A$15<>0),VLOOKUP($A$15,'POLES DATA'!$A$17:$J$77,8,FALSE),\"\")","v":""}]
[null,"SIGNAL ARM EXTENSION       -",null,null,null,{"$f":"IF(LEN($A$10)=0,\" \",VLOOKUP($A$10,'POLES DATA'!$A$4:$J$12,5,FALSE))","v":" "},null,null,"APPROXIMATE DEAD LOAD DEFLECTIONS",null,null,null,null,null,null,{"$f":"IF(A16=\"3LE\",3,IF(A16=0,0,IF(A16=\"6M\",6,IF(A16=\"7A\",0.24,IF(A16=\"7B\",1.8,IF(A16=\"7C\",2.5,4.8))))))","v":0},"(SIGNAL",null,null,null,null,null,"SIGNAL ARM EXTENSION",null,{"$f":"IF($A$16<>0,VLOOKUP($A$16,'POLES DATA'!$A$17:$J$77,3,FALSE),0)","v":0},null,{"$f":"IF($A$16=\"\",\"\",VLOOKUP($A$16,'POLES DATA'!$A$17:$J$77,9,FALSE)/2)","v":""},{"$f":"IF($A$16=\"\",\"\",VLOOKUP($A$16,'POLES DATA'!$A$17:$J$77,10,FALSE)/2)","v":""},{"$f":"IF(AND($E$18<>0,$A$15=0,$A$16<>0),VLOOKUP($A$16,'POLES DATA'!$A$17:$J$77,8,FALSE),\"\")","v":""},{"$f":"IF(OR($A$16=\"6M\",$A$16=\"3LE\"),\"**\",)","v":0}]
[null,"SIGNAL ARM                 -",null,null,null,{"$f":"IF(LEN($A$10)=0,\" \",IF(OR($A$16=\"3LE\",$A$16=\"6M\"),VLOOKUP($A$10,'POLES DATA'!$A$4:$J$12,9,FALSE),VLOOKUP($A$10,'POLES DATA'!$A$4:$J$12,4,FALSE)))","v":" "},null,null,null,null,"OWN WT.","WITH SIGNALS/SIGNS",null,null,null,{"$f":"IF(A17=\"3L\",3,IF(A17=\"4L\",4,IF(A17=\"5L\",5,IF(A17=\"6L\",6,IF(A17=\"7L\",7,IF(A17=\"8L\",8,IF(A17=\"9L\",9,IF(A17=\"10L\",10,0))))))))","v":0},"(ARM",null,null,null,null,null,"SIGNAL ARM",null,{"$f":"IF($A$17<>0,VLOOKUP($A$17,'POLES DATA'!$A$17:$J$77,3,FALSE),0)","v":0},null,{"$f":"IF($A$17=\"\",\"\",VLOOKUP($A$17,'POLES DATA'!$A$17:$J$77,9,FALSE)/2)","v":""},{"$f":"IF($A$17=\"\",\"\",VLOOKUP($A$17,'POLES DATA'!$A$17:$J$77,10,FALSE)/2)","v":""},{"$f":"IF(AND($E$18<>0,$A$15=0,$A$16=0,$A$17<>0),VLOOKUP($A$17,'POLES DATA'!$A$17:$J$77,8,FALSE),\"\")","v":""}]
[null,"TOTAL ARM REACH =",null,null,{"$f":"$Y$24","v":0},{"$f":"IF(AND($E$18<>0,$E$23<>0),\"ARM CONFLICT\",\"\")","v":""},null,null,"TOP OF POLE(HORI.)",null,{"$f":"IF(ISERROR(DEFLECTION!$C$49),\"\",DEFLECTION!$C$49)","v":""},{"$f":"IF(ISERROR(DEFLECTION!$C$69),\"\",DEFLECTION!$C$69)","v":""},null,null,null,{"$f":"IF(A17=\"11L\",11,IF(A17=\"12L\",12,IF(A17=\"13L\",13,IF(A17=\"14L\",14,0))))","v":0},"(CALCULATION"]
["SIGN ARMS",null,null,null,null,null,null,null,"END OF ARM (VERT.)",null,{"$f":"IF(ISERROR(DEFLECTION!$C$50),\"\",DEFLECTION!$C$50)","v":""},{"$f":"IF(ISERROR(DEFLECTION!$C$71),\"\",DEFLECTION!$C$71)","v":""},null,null,null,{"$f":"IF(A17=0,0,IF(A17=\"3A\",3,IF(A17=\"3C\",1.8,IF(A17=\"3D\",4.3,5.5))))+2.5","v":2.5},null,null,null,null,null,null,"POLE SHAFT ARM",null,{"$f":"IF($A$17=0,0,VLOOKUP($A$10,'POLES DATA'!$A$81:$J$89,3,FALSE))","v":0},{"$f":"IF($A$22=0,0,VLOOKUP($A$10,'POLES DATA'!$A$81:$J$89,3,FALSE))","v":0},null,null,null,"(FOR T1, T3, T6, T7 ONLY)"]
[null,"FOR T1,T3,T6,T7,L,M, H & S",null,null,null,null,null,null,null,null,"DEFLECTION > 600 IS NOT ACCEPTABLE",null,null,null,null,null,null,null,null,null,null,null,"SIGN ARM EXTENSION - INPUT",null,null,{"$f":"IF(OR($A$21=\"LS\", $A$21=\"SS\"),$I$21*10^3,0)","v":0},null,null,null,"(FOR LS & SS ONLY, OTHERWISE ZERO)"]
[null,"SIGN ARM EXTENSION         -",null,null,null,{"$f":"IF(LEN($A$10)=0,\" \",VLOOKUP($A$10,'POLES DATA'!$A$4:$J$12,8,FALSE))","v":" "},null,"LENGTH =",null,"(FOR LS & SS ONLY - USE 3SS, 4SS, 5SS FOR NOW)",null,null,null,null,null,{"$f":"IF(A22=0,0,IF(A21=\"7A\",I22+0.25+2.5,IF(A21=\"7B\",I22+1.8+2.5,IF(A21=\"7C\",I22+2.5+2.5,IF(A21=\"7D\",I22+4.8+2.5,I21+I22)))))","v":0},"(FOR SIGN ARM",null,null,null,null,null,"SIGN ARM EXTENSION - LOOKUP",null,null,{"$f":"IF($A$21<>0,VLOOKUP($A$21,'POLES DATA'!$A$17:$J$77,3,FALSE),0)","v":0},{"$f":"IF($A$21=\"\",\"\",VLOOKUP($A$21,'POLES DATA'!$A$17:$J$77,9,FALSE)/2)","v":""},{"$f":"IF($A$21=\"\",\"\",VLOOKUP($A$21,'POLES DATA'!$A$17:$J$77,10,FALSE)/2)","v":""},{"$f":"IF(AND($E$23<>0,$A$21<>0),VLOOKUP($A$21,'POLES DATA'!$A$17:$J$77,8,FALSE),\"\")","v":""}]
[null,"SIGN ARM                   - ",null,null,null,{"$f":"IF(LEN($A$10)=0,\" \",VLOOKUP($A$10,'POLES DATA'!$A$4:$J$12,7,FALSE))","v":" "},null,"LENGTH =",null,"(FOR L, L1, L2,M1, M2, H1 & H2 ONLY)",null,null,null,null,null,{"$f":"IF(A22=0,0,IF(A21=\"7A\",1.2+0.25+2.5,IF(A21=\"7B\",1.2+1.8+2.5,IF(A21=\"7C\",1.2+2.5+2.5,IF(A22=\"LB\",1.2+I21,I22+I21)))))","v":0},"(CALCULATION",null,null,null,null,null,"SIGN ARM - LOOKUP",null,null,{"$f":"IF($A$22<>0,VLOOKUP($A$22,'POLES DATA'!$A$17:$J$77,3,FALSE),0)","v":0},{"$f":"IF($A$22=\"\",\"\",VLOOKUP($A$22,'POLES DATA'!$A$17:$J$77,9,FALSE)/2)","v":""},{"$f":"IF($A$22=\"\",\"\",VLOOKUP($A$22,'POLES DATA'!$A$17:$J$77,10,FALSE)/2)","v":""},{"$f":"IF(AND($E$23<>0,$A$21=0,$A$22<>0),VLOOKUP($A$22,'POLES DATA'!$A$17:$J$77,8,FALSE),\"\")","v":""}]
[null,"TOTAL ARM REACH = ",null,null,{"$f":"$Z$24","v":0},{"$f":"IF(AND($E$18<>0,$E$23<>0),\"ARM CONFLICT\",\"\")","v":""},null,null,null,"(FOR L,MAX.LENGTH=1.20)",null,null,null,null,null,null,null,null,null,null,null,null,"SIGN ARM - INPUT",null,null,{"$f":"IF(OR($A$22=\"L\", $A$22=\"L1\",$A$22=\"L2\",$A$22=\"M1\", $A$22=\"M2\",$A$22=\"H1\",$A$22=\"H2\"), $I$22*10^3, 0)","v":0},null,null,null,"(FOR L, L1, L2, M1, M2, H1 & H2 ONLY)"]
["SIGNAL HEADS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL ARM REACH = ",null,{"$f":"SUM(Y15:Y23)/10^3","v":0},{"$f":"SUM(Z15:Z23)/10^3","v":0}]
[null,"SIGNAL HEAD(S) WITH BACKBOARD (200-200-200)",null,null,null,null,null,null,"SPAN =",null,"SPAN =",null,"SPAN ="]
[null,"SIGNAL HEAD(S) WITH BACKBOARD (300-200-200)",null,null,null,null,null,null,"SPAN =",null,"SPAN =",null,"SPAN ="]
[null,"SIGNAL HEAD(S) WITH BACKBOARD (300-200-200-300)",null,null,null,null,null,null,"SPAN =",null,"SPAN =",null,"SPAN ="]
[null,"SIGNAL HEAD(S) WITH BACKBOARD (300-300-300)",null,null,null,null,null,null,"SPAN =",null,"SPAN =",null,"SPAN ="]
[null,"SIGNAL HEAD(S) WITH BACKBOARD (300-300-300-300)",null,null,null,null,null,null,"SPAN =",null,"SPAN =",null,"SPAN ="]
["SIGNS"]
[null,null,"WIDTH =",null,"HEIGHT =",null,"SPAN =",null,"NO. OF LUMINAIRES PER SIGN ="]
[null,null,"WIDTH =",null,"HEIGHT =",null,"SPAN =",null,"NO. OF LUMINAIRES PER SIGN ="]
[null,null,"WIDTH =",null,"HEIGHT =",null,"SPAN =",null,"NO. OF LUMINAIRES PER SIGN ="]
[]
[]
[null,"POLE DESIGN USING ONTARIO BRIDGE DESIGN CODE (1991)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TABLE VALUES FROM THIS TABLE WERE NOT CALLED-UP IN FINAL CALCULATION"]
[null,"===================================================",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"THIS TABLE WAS INTENDED FOR POLE TYPES T1, T3, T6, T7 (SIGNAL/SIGN ARMS START AT 2.5M AWAY FROM CENTRE OF POLE)"]
[null,"POLE :",null,{"$f":"$A$10","v":0},null,"(H,M or L)",null,"    LOCATION :",null,"STANDARD",null,null,null,null,null,null,null,null,{"$f":"NOW()","v":"2023-09-20T14:35:06.820"},null,null,null,null,null,null,null,null,null,null,null,null,null,"POLE :",null,{"$f":"$A$10","v":0},null,"(H,M or L)",null,"    LOCATION :",null,"STANDARD",null,null,null,null,null,null,null,null,{"$f":"NOW()","v":"2023-09-20T14:35:06.820"}]
[]
[null,"WIND PRESSURE =",null,null,null,{"$f":"$E$8/1000","v":0.1},"KPa(1/50)","Fy =",300,"MPa","18000/Fy=",{"$f":"18000/I40","v":60},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WIND PRESSURE =",null,null,null,{"$f":"$E$8/1000","v":0.1},"KPa(1/50)","Fy =",300,"MPa","18000/Fy=",{"$f":"18000/AN40","v":60}]
[null,"ICE THICKNESS =",null,null,null,31,"mm","DLF =",1.1000000000000001,null,"Es=",200000,"MPa",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ICE THICKNESS =",null,null,null,32,"mm","DLF =",1.1000000000000001]
[null,"GUST FACTOR   =",null,null,null,2.5,null,"WLF =",1.3,0.7,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GUST FACTOR   =",null,null,null,2.5,null,"WLF =",1.3,0.7]
[null,"HEIGHT FACTOR =",null,null,null,1,null,"ILF =",1.3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HEIGHT FACTOR =",null,null,null,1,null,"ILF =",1.3]
[]
[null,"POLE SECTION",null,null,null,{"$f":"IF(OR(D38=\"H\",D38=\"M\"),12,8)","v":8},"  (R,16,12 or 8 SIDED)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"POLE SECTION",null,null,null,{"$f":"IF(OR(AI38=\"H\",AI38=\"M\"),12,8)","v":8},"  (R,16,12 or 8 SIDED)"]
[null,"ARM  SECTION",null,null,null,{"$f":"IF(D38=\"H\",12,8)","v":8},"  (R,16,12 or 8 SIDED)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Moment/Rotation about Axis:",null,null,null,null,null,null,"ARM  SECTION",null,null,null,{"$f":"IF(AI38=\"H\",12,8)","v":8},"  (R,16,12 or 8 SIDED)"]
[null,"EXTENSION",null,null,null,{"$f":"F45","v":8},"  (R,16,12 or 8 SIDED)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"My","My","Mx","My","Mz",null,null,"EXTENSION",null,null,null,{"$f":"AK45","v":8},"  (R,16,12 or 8 SIDED)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LOADS AND MOMENTS THAT GET ACTIVATED BASED ON COMPONENTS INPUT"]
[null,"if you have any questions or suggestions, please contact Alireza Ahmadnia, Ministry of Transportation,",null,null,"LENGTH","   RADIUS (mm)",null,"THICKNESS","AREA","DRAG","       LOAD (KN)","(UNFACTORED)",null,null,"MOMENT ARM (m)",null,null,null,"FACTORED MOMENT",null,"(kN)",null,"       LOAD (KN)","(UNFACTORED)",null,null,null,"FACTORED MOMENT (kNm)",null,"(kNm)",null,null,"MEMBER",null,"LENGTH",null,"   RADIUS (mm)",null,"THICKNESS","AREA","DRAG","       LOAD (KN)",null,null,null,"MOMENT ARM (m)",null,null,null,"FACTORED MOMENT",null,"(kN)"]
[null,"TYPE",null,null,"(m)","LARGE","SMALL","(mm)","(M^2)","FACTOR","DEAD","WIND","ICE","DL,ICE","WIND","TORQUE","DL","ICE","WIND(L)","WIND(T)","TORQUE",null,"DEAD","WIND","ICE","DL","ICE","WIND(L)","WIND(T)","TORQUE",null,null,"TYPE",null,"(m)",null,"LARGE","SMALL","(mm)","(M^2)","FACTOR","DEAD","WIND","ICE","DL,ICE","WIND","TORQUE","DL","ICE","WIND(L)","WIND(T)","TORQUE"]
[null,"--------------------------","--------------------------","--------------------------","--------------------------","--------------------------","--------------------------","--------------------------","--------------------------","--------------------------","--------------------------","--------------------------","--------------------------","--------------------------","--------------------------","--------------------------","--------------------------","--------------------------","--------------------------","--------------------------","--------------------------",null,null,null,null,null,null,null,null,null,null,null,"--------------------------","--------------------------","--------------------------","--------------------------","--------------------------","--------------------------","--------------------------","--------------------------","--------------------------","--------------------------","--------------------------","--------------------------","--------------------------","--------------------------","--------------------------","--------------------------","--------------------------","--------------------------","--------------------------","--------------------------"]
[{"$f":"IF($A$11<>0,1,0)","v":0},"LUMINAIRE",null,null,null,null,null,null,0.25,0.7,{"$f":"IF(A54=1,0.42,0.21)","v":0.21},{"$f":"IF(A54=1,(+F$40*F$42*I52*J52*1.1)*2,+F$40*F$42*I52*J52*1.1)","v":4.8125000000000001E-2},{"$f":"$F$41*9.8/1000*I52","v":7.5950000000000004E-2},{"$f":"IF(A54=1,0,3.5)","v":3.5},{"$f":"IF(AND(A10=\"T1\",A12=\"2B\"),11,IF(AND(A10=\"T1\",A12=0),9,E74+E55+2.5))","v":{"$error":"#N/A"}},3.5,{"$f":"K52*N52*I$41","v":0.8085},{"$f":"M52*N52*$I$43","v":0.34557250000000006},{"$f":"L52*O52*I$42","v":{"$error":"#N/A"}},{"$f":"0.2*S52","v":{"$error":"#N/A"}},{"$f":"IF(A54=1,+L52*P52*I$42/2,+L52*P52*I$42)","v":0.21896875000000002},null,{"$f":"IF($A52=0,0,+K52)","v":0},0,{"$f":"IF(A52=0,0,M52)","v":0},{"$f":"IF($A52=0,0,+Q52)","v":0},{"$f":"IF(A52=0,0,R52)","v":0},{"$f":"IF($A52=0,0,+S52)","v":0},0,0,null,{"$f":"IF($A$11<>0,1,0)","v":0},"LUMINAIRE",null,null,null,null,null,null,0.25,0.7,{"$f":"IF(AF54=1,0.42,0.21)","v":0.21},{"$f":"IF(AF54=1,(+AK$40*AK$42*AN52*AO52*1.1)*2,+AK$40*AK$42*AN52*AO52*1.1)","v":4.8125000000000001E-2},{"$f":"$F$41*9.8/1000*AN52","v":7.5950000000000004E-2},{"$f":"IF(AF54=1,0,3.5)","v":3.5},{"$f":"IF(AC10=\"T1\",10.5,AJ74+AJ55+2.5)","v":{"$error":"#N/A"}},3.5,{"$f":"AP52*AS52*AN$41","v":0.8085},{"$f":"AR52*AS52*$I$43","v":0.34557250000000006},{"$f":"AQ52*AT52*AN$42","v":{"$error":"#N/A"}},{"$f":"0.2*AX52","v":{"$error":"#N/A"}},{"$f":"IF(AF54=1,+AQ52*AU52*AN$42/2,+AQ52*AU52*AN$42)","v":0.21896875000000002},null,{"$f":"IF($A52=0,0,+AP52)","v":0},0,{"$f":"IF(AF52=0,0,AR52)","v":0},{"$f":"IF($A52=0,0,+AV52)","v":0},{"$f":"IF(AF52=0,0,AW52)","v":0},{"$f":"IF($A52=0,0,+AX52)","v":0},0,0]
[{"$f":"IF($A$11=\"2A\",1,0)","v":0},"DAVIT - 2A (S)",null,null,4.57,60,34,3,{"$f":"E53*(F53+G53)/1000","v":0.42958000000000002},1.4,{"$f":"IF(F$45=8,6.63,IF(F$45=12,6.43,IF(F$45=16,6.37,6.28)))*E53*(F53+G53)/2*H53*77/1000000*1.3","v":0.42764452731000002},{"$f":"F$40*F$42*I53*J53*1.1","v":0.16538829999999999},0.13050640400000002,1,{"$f":"O52-0.8","v":{"$error":"#N/A"}},1,0.47040898004100007,0.16965832520000004,{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"L53*P53*I$42","v":0.21500479},null,0,0,0,0,0,0,0,0,null,{"$f":"IF($A$11=\"2A\",1,0)","v":0},"DAVIT","(S)",null,4.57,60,34,3,{"$f":"AJ53*(AK53+AL53)/1000","v":0.42958000000000002},1.4,{"$f":"IF(AK$45=8,6.63,IF(AK$45=12,6.43,IF(AK$45=16,6.37,6.28)))*AJ53*(AK53+AL53)/2*AM53*77/1000000","v":0.3289573287},{"$f":"AK$40*AK$42*AN53*AO53*1.1","v":0.16538829999999999},0.13050640400000002,1,{"$f":"AT52-0.8","v":{"$error":"#N/A"}},1,0.36185306157000002,0.16965832520000004,{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"AQ53*AU53*AN$42","v":0.21500479},null,0,0,0,0,0,0,0,0]
[{"$f":"IF($A$11=\"2C\",1,0)","v":0},"DAVIT - 2C (D)",null,null,9.14,60,34,3,{"$f":"E54*(F54+G54)/1000","v":0.85916000000000003},1.4,{"$f":"IF(F$45=8,6.63,IF(F$45=12,6.43,IF(F$45=16,6.37,6.28)))*E54*(F54+G54)/2*H54*77/1000000*1.3","v":0.85528905462000004},{"$f":"F$40*F$42*I54*J54*1.1","v":0.33077659999999998},0.26101280800000004,0,{"$f":"O52-0.8","v":{"$error":"#N/A"}},1,0,0,{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"L54*P54*I$42/2","v":0.21500479},null,0,0,0,0,0,0,0,0,null,{"$f":"IF($A$11=\"2C\",1,0)","v":0},"DAVIT","(D)",null,9.14,60,34,3,{"$f":"AJ54*(AK54+AL54)/1000","v":0.85916000000000003},1.4,{"$f":"IF(AK$45=8,6.63,IF(AK$45=12,6.43,IF(AK$45=16,6.37,6.28)))*AJ54*(AK54+AL54)/2*AM54*77/1000000","v":0.65791465739999999},{"$f":"AK$40*AK$42*AN54*AO54*1.1","v":0.33077659999999998},0.26101280800000004,0,{"$f":"AT52-0.8","v":{"$error":"#N/A"}},1,0,0,{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"AQ54*AU54*AN$42/2","v":0.21500479},null,0,0,0,0,0,0,0,0]
[{"$f":"IF($A$12<>0,1,0)","v":0},"LUM. ARM EXTENSION",null,null,{"$f":"IF($A$12<>0,VLOOKUP($A$12,'POLES DATA'!$A$17:$J$77,4,FALSE)/10^3,0)","v":0},{"$f":"IF($A$12<>0,VLOOKUP($A$12,'POLES DATA'!$A$17:$J$77,9,FALSE),0)/2","v":0},{"$f":"IF($A$12<>0,VLOOKUP($A$12,'POLES DATA'!$A$17:$J$77,10,FALSE),0)/2","v":0},{"$f":"IF($A$12<>0,VLOOKUP($A$12,'POLES DATA'!$A$17:$J$77,8,FALSE),0)","v":0},{"$f":"E55*(F55+G55)/1000","v":0},{"$f":"IF(F$47=8,$BU$151,IF(F$47=12,$BU$152,IF(F$47=16,$BU$153,$BU$154)))","v":1.4},{"$f":"IF(F$45=8,6.63,IF(F$45=12,6.43,IF(F$45=16,6.37,6.28)))*E55*(F55+G55)/2*H55*77/1000000*1.3","v":0},{"$f":"F$40*F$42*F$43*I55*J55","v":0},0,0,{"$f":"IF(E55=3.63,8.89,IF(E55=1.13,7.84,IF(E55=4.25,8.67,IF(AND(OR(A12=\"0.25M\",A12=\"0.25L\"),E55=0.25),6.86,IF(E55=4.8,8.46,IF(E55=1.8,7.05,IF(AND(A12=\"7A\",E55=0.25),6.32,7.5)))))))","v":7.5},0,0,0,0,0,{"$f":"L55*P55*I$42","v":0},null,0,0,0,0,0,0,0,0,null,{"$f":"IF($A$12<>0,1,0)","v":0},"EXTENSION",null,null,{"$f":"IF(OR($A$12=\"0.25L\",$A$12=\"0.25M\"),0.25,IF(OR($A$12=\"1.75L\",$A$12=\"1.75M\"),1.75,IF(OR($A$12=\"4.25L\",$A$12=\"4.25M\"),4.25,IF($A$12=\"1.13H\",1.13,IF($A$12=\"3.63H\",3.63,IF($A$12=\"7A\",0.24,IF($A$12=\"7C\",2.5,4.8)))))))","v":4.8},{"$f":"IF($D$38=\"L\",110,IF($D$38=\"M\",137.5,IF($D$38=\"H\",175,85)))","v":85},60,{"$f":"IF($D$38=\"T7\",8,IF(OR(OR($A$12=\"4.25L\",$A$12=\"4.25M\"),$A$12=\"3.63H\"),4.5,3))","v":3},{"$f":"AJ55*(AK55+AL55)/1000","v":0.69599999999999995},{"$f":"IF(AK$47=8,$BU$151,IF(AK$47=12,$BU$152,IF(AK$47=16,$BU$153,$BU$154)))","v":1.4},{"$f":"IF(AK$45=8,6.63,IF(AK$45=12,6.43,IF(AK$45=16,6.37,6.28)))*AJ55*(AK55+AL55)/2*AM55*77/1000000","v":0.53297243999999999},{"$f":"AK$40*AK$42*AK$43*AN55*AO55","v":0.24359999999999996},0.21144479999999999,0,6.85,0,0,0,2.1692579999999997,0.43385159999999995,{"$f":"AQ55*AU55*AN$42","v":0},null,0,0,0,0,0,0,0,0]
[0,"EXTENSION",null,null,0,{"$f":"IF($D$38=\"L\",110,IF($D$38=\"M\",137.5,IF($D$38=\"H\",175,85)))","v":85},60,{"$f":"IF($D$38=\"T7\",8,3)","v":3},{"$f":"E56*(F56+G56)/1000","v":0},{"$f":"IF(F$47=8,$BU$151,IF(F$47=12,$BU$152,IF(F$47=16,$BU$153,$BU$154)))","v":1.4},{"$f":"IF(F$45=8,6.63,IF(F$45=12,6.43,IF(F$45=16,6.37,6.28)))*E56*(F56+G56)/2*H56*77/1000000","v":0},0,0,0,7.43,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,null,0,"EXTENSION",null,null,0,{"$f":"IF($D$38=\"L\",110,IF($D$38=\"M\",137.5,IF($D$38=\"H\",175,85)))","v":85},60,{"$f":"IF($D$38=\"T7\",8,3)","v":3},{"$f":"AJ56*(AK56+AL56)/1000","v":0},{"$f":"IF(AK$47=8,$BU$151,IF(AK$47=12,$BU$152,IF(AK$47=16,$BU$153,$BU$154)))","v":1.4},{"$f":"IF(AK$45=8,6.63,IF(AK$45=12,6.43,IF(AK$45=16,6.37,6.28)))*AJ56*(AK56+AL56)/2*AM56*77/1000000","v":0},0,0,0,7.43,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0]
[0,"EXTENSION",null,null,0,{"$f":"IF($D$38=\"L\",110,IF($D$38=\"M\",137.5,IF($D$38=\"H\",175,85)))","v":85},60,{"$f":"IF($D$38=\"T7\",8,4.5)","v":4.5},{"$f":"E57*(F57+G57)/1000","v":0},{"$f":"IF(F$47=8,$BV$151,IF(F$47=12,$BV$152,IF(F$47=16,$BV$153,$BV$154)))","v":1.4},{"$f":"IF(F$45=8,6.63,IF(F$45=12,6.43,IF(F$45=16,6.37,6.28)))*E57*(F57+G57)/2*H57*77/1000000","v":0},0,0,0,8.6,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,null,0,"EXTENSION",null,null,0,{"$f":"IF($D$38=\"L\",110,IF($D$38=\"M\",137.5,IF($D$38=\"H\",175,85)))","v":85},60,{"$f":"IF($D$38=\"T7\",8,4.5)","v":4.5},{"$f":"AJ57*(AK57+AL57)/1000","v":0},{"$f":"IF(AK$47=8,$BV$151,IF(AK$47=12,$BV$152,IF(AK$47=16,$BV$153,$BV$154)))","v":1.4},{"$f":"IF(AK$45=8,6.63,IF(AK$45=12,6.43,IF(AK$45=16,6.37,6.28)))*AJ57*(AK57+AL57)/2*AM57*77/1000000","v":0},0,0,0,8.6,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0]
[{"$f":"$A$25","v":0},"SIGNAL HEAD ( 200-200-200)",null,null,null,{"$f":"$J$25","v":0},{"$f":"$L$25","v":0},{"$f":"$N$25","v":0},{"$f":"0.55*A58","v":0},1.2,{"$f":"0.12*A58","v":0},0,0,{"$f":"IF(A58=0,0,(F58+G58+H58)/A58)","v":0},{"$f":"MAX($D$74,$E$74)","v":{"$error":"#N/A"}},{"$f":"N58","v":0},0,0,{"$error":"#N/A"},{"$error":"#N/A"},0,null,0,0,0,0,0,0,0,0,null,{"$f":"$A$25","v":0},"SIGNAL HEAD ( 200-200-200)",null,null,null,{"$f":"IF($J$25=0,0,$J$25-2.5)","v":0},{"$f":"IF($L$25=0,0,$L$25-2.5)","v":0},{"$f":"IF($N$25=0,0,$N$25-2.5)","v":0},{"$f":"0.55*AF58","v":0},1.2,{"$f":"0.12*AF58","v":0},0,0,{"$f":"IF(AF58=0,0,(AK58+AL58+AM58)/AF58)","v":0},{"$f":"AJ$74","v":{"$error":"#N/A"}},{"$f":"AS58","v":0},0,0,{"$error":"#N/A"},{"$error":"#N/A"},0,null,0,0,0,0,0,0,0,0]
[{"$f":"$A$26","v":0},"SIGNAL HEAD (300-200-200)",null,null,null,{"$f":"$J$26","v":0},{"$f":"$L$26","v":0},{"$f":"$N$26","v":0},{"$f":"0.78*A59","v":0},1.2,{"$f":"0.14*A59","v":0},0,0,{"$f":"IF(A59=0,0,(F59+G59+H59)/A59)","v":0},{"$error":"#N/A"},0,0,0,{"$error":"#N/A"},{"$error":"#N/A"},0,null,0,0,0,0,0,0,0,0,null,{"$f":"$A$26","v":0},"SIGNAL HEAD (300-200-200)",null,null,null,{"$f":"IF($J$26=0,0,$J$26-2.5)","v":0},{"$f":"IF($L$26=0,0,$L$26-2.5)","v":0},{"$f":"IF($N$26=0,0,$N$26-2.5)","v":0},{"$f":"0.7*AF59","v":0},1.2,{"$f":"0.14*AF59","v":0},0,0,{"$f":"IF(AF59=0,0,(AK59+AL59+AM59)/AF59)","v":0},{"$error":"#N/A"},0,0,0,{"$error":"#N/A"},{"$error":"#N/A"},0,null,0,0,0,0,0,0,0,0]
[{"$f":"$A$27","v":0},"SIGNAL HEAD (200-200-200-300)",null,null,null,{"$f":"$J$27","v":0},{"$f":"$L$27","v":0},{"$f":"$N$27","v":0},{"$f":" 1.01*A60","v":0},1.2,{"$f":"0.2*A60","v":0},0,0,{"$f":"IF(A60=0,0,(F60+G60+H60)/A60)","v":0},{"$error":"#N/A"},0,0,0,{"$error":"#N/A"},{"$error":"#N/A"},0,null,0,0,0,0,0,0,0,0,null,{"$f":"$A$27","v":0},"SIGNAL HEAD (200-200-200-300)",null,null,null,{"$f":"IF($J$27=0,0,$J$27-2.5)","v":0},{"$f":"IF($L$27=0,0,$L$27-2.5)","v":0},{"$f":"IF($N$27=0,0,$N$27-2.5)","v":0},{"$f":" 0.92*AF60","v":0},1.2,{"$f":"0.2*AF60","v":0},0,0,{"$f":"IF(AF60=0,0,(AK60+AL60+AM60)/AF60)","v":0},{"$error":"#N/A"},0,0,0,{"$error":"#N/A"},{"$error":"#N/A"},0,null,0,0,0,0,0,0,0,0]
[{"$f":"$A$28","v":0},"SIGNAL HEAD (300-300-300)",null,null,null,{"$f":"$J$28","v":0},{"$f":"$L$28","v":0},{"$f":"$N$28","v":0},{"$f":"0.9*A61","v":0},1.2,{"$f":"0.18*A61","v":0},0,0,{"$f":"IF(A61=0,0,(F61+G61+H61)/A61)","v":0},{"$error":"#N/A"},0,0,0,{"$error":"#N/A"},{"$error":"#N/A"},0,null,0,0,0,0,0,0,0,0,null,{"$f":"$A$28","v":0},"SIGNAL HEAD (300-300-300)",null,null,null,{"$f":"IF($J$28=0,0,$J$28-2.5)","v":0},{"$f":"IF($L$28=0,0,$L$28-2.5)","v":0},{"$f":"IF($N$28=0,0,$N$28-2.5)","v":0},{"$f":"0.8*AF61","v":0},1.2,{"$f":"0.18*AF61","v":0},0,0,{"$f":"IF(AF61=0,0,(AK61+AL61+AM61)/AF61)","v":0},{"$error":"#N/A"},0,0,0,{"$error":"#N/A"},{"$error":"#N/A"},0,null,0,0,0,0,0,0,0,0]
[{"$f":"$A$29","v":0},"SIGNAL HEAD (300-300-300-300)",null,null,null,{"$f":"$J$29","v":0},{"$f":"$L$29","v":0},{"$f":"$N$29","v":0},{"$f":"1.14*A62","v":0},1.2,{"$f":"0.24*A62","v":0},0,0,{"$f":"IF(A62=0,0,(F62+G62+H62)/A62)","v":0},{"$error":"#N/A"},0,0,0,{"$error":"#N/A"},{"$error":"#N/A"},0,null,0,0,0,0,0,0,0,0,null,{"$f":"$A$29","v":0},"SIGNAL HEAD (300-300-300-300)",null,null,null,{"$f":"IF($J$29=0,0,$J$29-2.5)","v":0},{"$f":"IF($L$29=0,0,$L$29-2.5)","v":0},{"$f":"IF($N$29=0,0,$N$29-2.5)","v":0},{"$f":"1*AF62","v":0},1.2,{"$f":"0.24*AF62","v":0},0,0,{"$f":"IF(AF62=0,0,(AK62+AL62+AM62)/AF62)","v":0},{"$error":"#N/A"},0,0,0,{"$error":"#N/A"},{"$error":"#N/A"},0,null,0,0,0,0,0,0,0,0]
[0,"REG. SIGN",null,null,null,null,null,null,0.36,1.2,0.13,0.108,0.10936800000000001,{"$f":"N58-1","v":-1},{"$f":"MAX($D$74,$E$74)","v":{"$error":"#N/A"}},-1,-0.14300000000000002,-0.14217840000000001,{"$error":"#N/A"},{"$error":"#N/A"},-0.1404,null,0,0,0,0,0,0,0,0,null,0,"REG. SIGN",null,null,null,null,null,null,0.36,1.2,0.13,0.108,0.10936800000000001,{"$f":"AS58-1","v":-1},{"$error":"#N/A"},-1,-0.14300000000000002,-0.14217840000000001,{"$error":"#N/A"},{"$error":"#N/A"},-0.1404,null,0,0,0,0,0,0,0,0]
[0,"ALUM. SIGN",null,null,null,null,null,null,0.36,1.2,0.2,0.108,0.10936800000000001,{"$f":"N58-2","v":-2},{"$error":"#N/A"},-2,-0.44000000000000006,-0.28435680000000002,{"$error":"#N/A"},{"$error":"#N/A"},-0.28079999999999999,null,0,0,0,0,0,0,0,0,null,0,"ALUM. SIGN",null,null,null,null,null,null,0.36,1.2,0.2,0.108,0.10936800000000001,{"$f":"AS58-2","v":-2},{"$error":"#N/A"},-2,-0.44000000000000006,-0.28435680000000002,{"$error":"#N/A"},{"$error":"#N/A"},-0.28079999999999999,null,0,0,0,0,0,0,0,0]
[{"$f":"$A$31","v":0},"SIGN",{"$f":"$D$31","v":0},"x",{"$f":"$F$31","v":0},null,null,null,{"$f":"C65*E65","v":0},1.2,{"$f":"I65*0.45","v":0},0,0,{"$f":"$H$31","v":0},{"$error":"#N/A"},0,0,0,{"$error":"#N/A"},{"$error":"#N/A"},0,null,0,0,0,0,0,0,0,0,null,{"$f":"$A$31","v":0},"SIGN",{"$f":"$D$31","v":0},"x",{"$f":"$F$31","v":0},null,null,null,{"$f":"AH65*AJ65","v":0},1.2,{"$f":"AN65*0.45","v":0},0,0,{"$f":"$H$31-2.5","v":-2.5},{"$error":"#N/A"},-2.5,0,0,{"$error":"#N/A"},{"$error":"#N/A"},0,null,0,0,0,0,0,0,0,0]
[{"$f":"$A$32","v":0},"SIGN",{"$f":"$D$32","v":0},"x",{"$f":"$F$32","v":0},null,null,null,{"$f":"C66*E66","v":0},1.2,{"$f":"I66*0.45","v":0},0,0,{"$f":"$H$32","v":0},{"$error":"#N/A"},0,0,0,{"$error":"#N/A"},{"$error":"#N/A"},0,null,0,0,0,0,0,0,0,0,null,{"$f":"$A$32","v":0},"SIGN",{"$f":"$D$32","v":0},"x",{"$f":"$F$32","v":0},null,null,null,{"$f":"AH66*AJ66","v":0},1.2,{"$f":"AN66*0.45","v":0},0,0,{"$f":"$H$32-2.5","v":-2.5},{"$error":"#N/A"},-2.5,0,0,{"$error":"#N/A"},{"$error":"#N/A"},0,null,0,0,0,0,0,0,0,0]
[{"$f":"$A$33","v":0},"SIGN",{"$f":"$D$33","v":0},"x",{"$f":"$F$33","v":0},null,null,null,{"$f":"C67*E67","v":0},1.2,{"$f":"I67*0.45","v":0},0,0,{"$f":"$H$33","v":0},{"$error":"#N/A"},0,0,0,{"$error":"#N/A"},{"$error":"#N/A"},0,null,0,0,0,0,0,0,0,0,null,{"$f":"$A$33","v":0},"SIGN",{"$f":"$D$33","v":0},"x",{"$f":"$F$33","v":0},null,null,null,{"$f":"AH67*AJ67","v":0},1.2,{"$f":"AN67*0.45","v":0},0,0,{"$f":"$H$33-2.5","v":-2.5},{"$error":"#N/A"},-2.5,0,0,{"$error":"#N/A"},{"$error":"#N/A"},0,null,0,0,0,0,0,0,0,0]
[{"$f":"$L$31","v":0},"SIGN LUMINAIRE",null,null,null,null,null,null,{"$f":"0.14*A68","v":0},1.2,{"$f":"0.35*A68","v":0},0,0,{"$f":"N65","v":0},{"$error":"#N/A"},0,0,0,{"$error":"#N/A"},{"$error":"#N/A"},0,null,0,0,0,0,0,0,0,0,null,{"$f":"$L$31","v":0},"SIGN LUMINAIRE",null,null,null,null,null,null,{"$f":"0.36*AF68","v":0},1.2,{"$f":"0.35*AF68","v":0},0,0,{"$f":"AS65","v":-2.5},{"$error":"#N/A"},-2.5,0,0,{"$error":"#N/A"},{"$error":"#N/A"},0,null,0,0,0,0,0,0,0,0]
[{"$f":"$L$32","v":0},"SIGN LUMINAIRE",null,null,null,null,null,null,{"$f":"0.14*A69","v":0},1.2,{"$f":"0.35*A69","v":0},0,0,{"$f":"N66","v":0},{"$error":"#N/A"},0,0,0,{"$error":"#N/A"},{"$error":"#N/A"},0,null,0,0,0,0,0,0,0,0,null,{"$f":"$L$32","v":0},"SIGN LUMINAIRE",null,null,null,null,null,null,{"$f":"0.36*AF69","v":0},1.2,{"$f":"0.35*AF69","v":0},0,0,{"$f":"AS66","v":-2.5},{"$error":"#N/A"},-2.5,0,0,{"$error":"#N/A"},{"$error":"#N/A"},0,null,0,0,0,0,0,0,0,0]
[{"$f":"$L$33","v":0},"SIGN LUMINAIRE",null,null,null,null,null,null,{"$f":"0.14*A70","v":0},1.2,{"$f":"0.35*A70","v":0},0,0,{"$f":"N67","v":0},{"$error":"#N/A"},0,0,0,{"$error":"#N/A"},{"$error":"#N/A"},0,null,0,0,0,0,0,0,0,0,null,{"$f":"$L$33","v":0},"SIGN LUMINAIRE",null,null,null,null,null,null,{"$f":"0.36*AF70","v":0},1.2,{"$f":"0.35*AF70","v":0},0,0,{"$f":"AS67","v":-2.5},{"$error":"#N/A"},-2.5,0,0,{"$error":"#N/A"},{"$error":"#N/A"},0,null,0,0,0,0,0,0,0,0]
[1,"ARM",null,{"$f":"IF(OR(OR(AND(OR(OR(OR(OR($A$17=\"5L\",$A$17=\"6L\"),$A$17=\"7L\"),$A$17=\"8L\"),$A$17=\"9L\"),$A$10=\"L\"),$A$22=\"H1\"),$A$22=\"M1\"),6.4,IF(OR(OR(OR(AND(OR($A$17=\"3L\",$A$17=\"4L\"),$A$10=\"L\"),$A$22=\"3D\"),$A$16=\"7A\"),$A$21=\"7A\"),4.8,IF(OR(OR(AND(OR($A$17=\"3A\",$A$17=\"3C\"),$A$16=0),$A$22=\"3A\"),$A$22=\"3C\"),3,IF(AND(OR($A$17=\"3E\",$A$17=\"3D\"),$A$16=0),4.8,IF(AND(OR($A$10=\"T1\",$A$10=\"T3\"),$A$22<>0),4.8,IF($A$22=\"L1\",6.4,8))))))","v":8},{"$f":"IF($A$22=0,$E$18,$E$23)","v":0},{"$f":"VLOOKUP($A$10,'POLES DATA'!$A$81:$J$89,10,FALSE)/2","v":{"$error":"#N/A"}},{"$f":"IF($A$22=0,VLOOKUP($A$17,'POLES DATA'!$A$17:$J$77,10,FALSE),VLOOKUP($A$22,'POLES DATA'!$A$17:$J$77,10,FALSE))/2","v":{"$error":"#N/A"}},{"$f":"MAX($AC$15:$AC$17,$AC$21:$AC$22)","v":0},{"$f":"E71*(F71+G71)/1000","v":{"$error":"#N/A"}},{"$f":"IF(F$46=8,$BS$151,IF(F$46=12,$BS$152,IF(F$46=16,$BS$153,$BS$154)))","v":1.4},{"$f":"IF(F$45=8,6.63,IF(F$45=12,6.43,IF(F$45=16,6.37,6.28)))*E71*(F71+G71)/2*H71*77/1000000*1.3","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"E$71/3*(2*G71+F71)/(G71+F71)","v":{"$error":"#N/A"}},{"$f":"MAX($D$74,$E$74)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,1,"ARM",null,null,{"$f":"IF($A$22=0,$E$18,$E$23)-2.5","v":-2.5},{"$f":"VLOOKUP($A$10,'POLES DATA'!$A$81:$J$89,10,FALSE)/2","v":{"$error":"#N/A"}},{"$f":"IF($A$22=0,VLOOKUP($A$17,'POLES DATA'!$A$17:$J$77,10,FALSE),VLOOKUP($A$22,'POLES DATA'!$A$17:$J$77,10,FALSE))/2","v":{"$error":"#N/A"}},{"$f":"MAX($AC$15:$AC$17,$AC$21:$AC$22)","v":0},{"$f":"AJ71*(AK71+AL71)/1000","v":{"$error":"#N/A"}},{"$f":"IF(AK$46=8,$BS$151,IF(AK$46=12,$BS$152,IF(AK$46=16,$BS$153,$BS$154)))","v":1.4},{"$f":"IF(AK$45=8,6.63,IF(AK$45=12,6.43,IF(AK$45=16,6.37,6.28)))*AJ71*(AK71+AL71)/2*AM71*77/1000000","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"AJ$71/3*(2*AL71+AK71)/(AL71+AK71)","v":{"$error":"#N/A"}},{"$f":"AJ74","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[0,"SIGNAL HEAD (5)",null,null,null,null,null,null,0.25,1.2,0.22,7.4999999999999997E-2,7.5950000000000004E-2,1,3,1,0.24200000000000002,9.8735000000000003E-2,0.29249999999999998,5.8499999999999996E-2,9.7500000000000003E-2,null,0,0,0,0,0,0,0,0,null,0,"SIGNAL HEAD (5)",null,null,null,null,null,null,0.25,1.2,0.22,7.4999999999999997E-2,7.5950000000000004E-2,1,3,1,0.24200000000000002,9.8735000000000003E-2,0.29249999999999998,5.8499999999999996E-2,9.7500000000000003E-2,null,0,0,0,0,0,0,0,0]
[0,"PED. HEAD (1) ",null,null,null,null,null,null,0.2,1.2,0.14000000000000001,0.06,6.0760000000000008E-2,1,2.5,1,0.15400000000000003,7.8988000000000017E-2,0.19500000000000001,3.9000000000000007E-2,7.8E-2,null,0,0,0,0,0,0,0,0,null,0,"PED. HEAD (1) ",null,null,null,null,null,null,0.2,1.2,0.14000000000000001,0.06,6.0760000000000008E-2,1,2.5,1,0.15400000000000003,7.8988000000000017E-2,0.19500000000000001,3.9000000000000007E-2,7.8E-2,null,0,0,0,0,0,0,0,0]
[{"$f":"IF(D38=0,0,1)","v":0},"POLE",null,{"$f":"CEILING(VLOOKUP($D$38,'POLES DATA'!$A$81:$J$89,5,FALSE),100)/10^3","v":{"$error":"#N/A"}},{"$f":"CEILING(VLOOKUP($A$10,'POLES DATA'!$A$81:$J$89,4,FALSE),10)/10^3","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($A$10,'POLES DATA'!$A$81:$J$89,9,FALSE)/2","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($A$10,'POLES DATA'!$A$81:$J$89,10,FALSE)/2","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($A$10,'POLES DATA'!$A$81:$J$89,8,FALSE)","v":{"$error":"#N/A"}},{"$f":"E74*(F74+G74)/1000","v":{"$error":"#N/A"}},{"$f":"IF(F$45=8,$BR$151,IF(F$45=12,$BR$152,IF(F$45=16,$BR$153,$BR$154)))","v":1.4},{"$f":"IF(F$45=8,6.63,IF(F$45=12,6.43,IF(F$45=16,6.37,6.28)))*E74*(F74+G74)/2*H74*77/1000000*1.3","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},0,{"$f":"E74/3*(2*G74+F74)/(G74+F74)","v":{"$error":"#N/A"}},0,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,0,0,0,0,0,0,0,0,null,1,"POLE",null,null,{"$f":"CEILING(VLOOKUP($D$38,'POLES DATA'!$A$81:$J$89,5,FALSE),100)/10^3","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($A$10,'POLES DATA'!$A$81:$J$89,9,FALSE)/2","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($A$10,'POLES DATA'!$A$81:$J$89,10,FALSE)/2","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($A$10,'POLES DATA'!$A$81:$J$89,8,FALSE)","v":{"$error":"#N/A"}},{"$f":"AJ74*(AK74+AL74)/1000","v":{"$error":"#N/A"}},{"$f":"IF(AK$45=8,$BR$151,IF(AK$45=12,$BR$152,IF(AK$45=16,$BR$153,$BR$154)))","v":1.4},{"$f":"IF(AK$45=8,6.63,IF(AK$45=12,6.43,IF(AK$45=16,6.37,6.28)))*AJ74*(AK74+AL74)/2*AM74*77/1000000","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},0,{"$f":"AJ74/3*(2*AL74+AK74)/(AL74+AK74)","v":{"$error":"#N/A"}},0,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,0,0,{"$error":"#N/A"},0,{"$error":"#N/A"},0,0,0]
[null,"---------------------------------------------","---------------------------------------------","---------------------------------------------","---------------------------------------------","---------------------------------------------","---------------------------------------------","---------------------------------------------","---------------------------------------------","---------------------------------------------","---------------------------------------------","---------------------------------------------","---------------------------------------------","---------------------------------------------","---------------------------------------------","---------------------------------------------","---------------------------------------------","---------------------------------------------","---------------------------------------------","---------------------------------------------","---------------------------------------------",null,null,null,null,null,null,null,null,null,null,null,"---------------------------------------------","---------------------------------------------","---------------------------------------------","---------------------------------------------","---------------------------------------------","---------------------------------------------","---------------------------------------------","---------------------------------------------","---------------------------------------------","---------------------------------------------","---------------------------------------------","---------------------------------------------","---------------------------------------------","---------------------------------------------","---------------------------------------------","---------------------------------------------","---------------------------------------------","---------------------------------------------","---------------------------------------------","---------------------------------------------"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"W76","v":{"$error":"#N/A"}},{"$f":"X76","v":{"$error":"#N/A"}},{"$f":"Y76","v":{"$error":"#N/A"}},null,null,null,{"$f":"Z76","v":{"$error":"#N/A"}},{"$f":"AA76","v":{"$error":"#N/A"}},{"$f":"AB76","v":{"$error":"#N/A"}},{"$f":"AC76","v":{"$error":"#N/A"}},{"$f":"AD76","v":{"$error":"#N/A"}},null,{"$f":"SUM(W52:W74)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"BB76","v":{"$error":"#N/A"}},{"$f":"BC76","v":{"$error":"#N/A"}},{"$f":"BD76","v":{"$error":"#N/A"}},null,null,null,{"$f":"BE76","v":{"$error":"#N/A"}},{"$f":"BF76","v":{"$error":"#N/A"}},{"$f":"BG76","v":{"$error":"#N/A"}},{"$f":"BH76","v":{"$error":"#N/A"}},{"$f":"BI76","v":{"$error":"#N/A"}},null,{"$f":"SUM(BB52:BB74)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[]
[null,"POLE",null,null,null,null,null,null,null,null,null,"ANCHOR BOLTS"]
[null,"====",null,null,null,null,null,null,null,null,null,"============"]
[null,"D/t =",{"$f":"2*F74/H74","v":{"$error":"#N/A"}},null,{"$f":"IF(C80<L40,\"COMPACT SECTION\",\"NON-COMPACT SECTION\")","v":{"$error":"#N/A"}},null,null,null,null,null,null,"NO. OF BOLTS=",null,{"$f":"IF($D$38=\"M\",6,IF($D$38=\"H\",8,4))","v":4},"(4,6 or 8)"]
[null,null,null,null,null,null,null,null,null,null,null,"BOLT CIRCLE =",null,{"$f":"IF($D$38=\"L\",390,IF($D$38=\"M\",450,IF($D$38=\"H\",575,IF(OR(OR(OR($D$38=\"T1\",$D$38=\"M1\"),$D$38=\"T3\"),$D$38=\"M3\"),280,343))))","v":343},"mm"]
[null,"Mrn =",{"$f":"IF($F$45=8,$BQ$135,IF($F$45=12,$BP$135,IF($F$45=16,$BO$135,$BN$135)))*(0.95*$F$74^2*$H$74*$I$40/1000000)","v":{"$error":"#N/A"}},null,"Cf =",{"$f":"I$41*K76","v":{"$error":"#N/A"}},null,"Cr/Tr",null,null,null,"BOLT DIA.   =",null,{"$f":"IF(OR(OR($D$38=\"L\",$D$38=\"M\"),$D$38=\"H\"),1.5,IF(OR(OR(OR($D$38=\"T1\",$D$38=\"M1\"),$D$38=\"T3\"),$D$38=\"M3\"),1,\"D\"))","v":"D"},"inches","(MIN. 1.125)"]
[null,"Mrc =",{"$f":"IF($F$45=8,$BQ$138,IF($F$45=12,$BP$138,IF($F$45=16,$BO$138,$BN$138)))*(0.95*$F$74^2*$H$74*$I$40/1000000)","v":{"$error":"#N/A"}},null,"Mf =",{"$f":"IF($F$45=8,BM151,IF($F$45=12,BM152,IF($F$45=16,BM153,BM154)))","v":{"$error":"#N/A"}},{"$f":"IF($F$45=8,BN151,IF($F$45=12,BN152,IF($F$45=16,BN153,BN154)))","v":{"$error":"#N/A"}},"Mf/Mr =",{"$f":"IF(C80<L40,F83/$C83,F83/$C82)","v":{"$error":"#N/A"}},{"$f":"IF(C80<L40,G83/$C83,G83/$C82)","v":{"$error":"#N/A"}},null,"Tf =",{"$f":"IF($N$80=4,BQ172,IF($N$80=6,BQ173,IF($N$80=8,MAX(BQ174:BQ175),BQ176)))","v":{"$error":"#N/A"}},{"$f":"IF($N$80=4,BZ172,IF($N$80=6,BZ173,IF($N$80=8,MAX(BZ174:BZ175),BZ176)))","v":{"$error":"#N/A"}},"Tr =",{"$f":"IF(N82=1,220,IF(N82=1.125,243,IF(N82=1.25,300,IF(N82=2.25,750,IF(N82=1.5,431,313)))))","v":313},"Tf/Tr =",{"$f":"M83/P83","v":{"$error":"#N/A"}},{"$f":"N83/P83","v":{"$error":"#N/A"}},null,null,"(anchor bolt to be 20% stronger "]
[null,"Qrb =",{"$f":"1.15*0.9*$I$40*$F$74^2*3.1416*$H$74/1000000","v":{"$error":"#N/A"}},null,"Qfb =",{"$f":"U76","v":{"$error":"#N/A"}},{"$f":"J42/I42*U76","v":{"$error":"#N/A"}},"(Qf/Qr)^2 =",{"$f":"IF($C$80<$L$40,(F84/$C84)^2,(F84/$C84*1.26)^2)","v":{"$error":"#N/A"}},{"$f":"IF($C$80<$L$40,(G84/$C84)^2,(G84/$C84*1.26)^2)","v":{"$error":"#N/A"}},null,"Vf =",{"$f":"IF($N$80=4,BR172,IF($N$80=6,BR173,IF($N$80=8,BR174,BR176)))","v":{"$error":"#N/A"}},{"$f":"IF($N$80=4,CA172,IF($N$80=6,CA173,IF($N$80=8,CA174,CA176)))","v":{"$error":"#N/A"}},"Vr =",{"$f":"IF(N82=1,123,IF(N82=\"D\",175,IF(N82=1.125,136,IF(N82=1.25,168,IF(N82=2.25,420,242)))))","v":175},"Vf/Vr =",{"$f":"M84/P84","v":{"$error":"#N/A"}},{"$f":"N84/P84","v":{"$error":"#N/A"}},null,null,"(than the base metal"]
[null,"Qrt =",{"$f":"1.15*0.9*$I$40*$G$74^2*3.1416*$H$74/1000000","v":{"$error":"#N/A"}},null,"Qft =",{"$f":"SUM($AD$58:$AD$71)","v":{"$error":"#N/A"}},{"$f":"$J42/I42*SUM($AD$58:$AD$71)","v":{"$error":"#N/A"}},"Qf/Qr =",{"$f":"IF($C$80<$L$40,(F85/$C85),(F85/$C85*1.26))","v":{"$error":"#N/A"}},{"$f":"IF($C$80<$L$40,(G85/$C85),(G85/$C85*1.26))","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,{"$f":"MAX((R83^2+R84^2)*1.2,R83*1.2)","v":{"$error":"#N/A"}},{"$f":"MAX((S83^2+S84^2)*1.2,S83*1.2)","v":{"$error":"#N/A"}}]
[]
[null,null,"COMBINED FORCE RATIO    =",null,null,null,{"$f":"MAX(I83+I84,J83+J84)","v":{"$error":"#N/A"}},null,null,null,null,null,"COMBINED FORCE RATIO    =",null,null,{"$f":"MAX(R85,S85)","v":{"$error":"#N/A"}}]
[]
[null,"ARM",null,null,null,null,null,null,null,null,null,"FLANGE CONNECTION"]
[null,"===",null,null,null,null,null,null,null,null,null,"================="]
[null,"D/t =",{"$f":"2*F71/H71","v":{"$error":"#N/A"}},null,{"$f":"IF(C91<L40,\"COMPACT SECTION\",\"NON-COMPACT SECTION\")","v":{"$error":"#N/A"}},null,null,null,null,null,null,"NO. OF BOLTS=",null,{"$f":"IF($D$38=\"H\",8,IF(OR($D$38=\"M\",D38=\"S\"),6,4))","v":4},"(4,6 or 8)"]
[null,null,null,null,null,null,null,null,null,null,null,"BOLT CIRCLE =",null,{"$f":"IF($D$38=\"L\",345,IF($D$38=\"M\",400,IF($D$38=\"H\",460,IF(OR(OR(OR($D$38=\"T1\",$D$38=\"M1\"),$D$38=\"T3\"),$D$38=\"M3\"),170,242))))","v":242},"mm"]
[null,"Mrn =",{"$f":"IF($F$46=8,$BQ$135,IF($F$46=12,$BP$135,IF($F$46=16,$BO$135,$BN$135)))*(0.95*$F$71^2*$H$71*$I$40/1000000)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,"BOLT DIA.   =",null,{"$f":"IF(OR(OR($D$38=\"L\",$D$38=\"M\"),$D$38=\"H\"),1.5,IF(OR(OR(OR($D$38=\"T1\",$D$38=\"M1\"),$D$38=\"T3\"),$D$38=\"M3\"),0.625,1))","v":1},"inches","(MAX 1.5\")"]
[null,"Mrc =",{"$f":"IF($F$46=8,$BQ$138,IF($F$46=12,$BP$138,IF($F$46=16,$BO$138,$BN$138)))*(0.95*$F$71^2*$H$71*$I$40/1000000)","v":{"$error":"#N/A"}},null,"Mf =",{"$f":"IF($F$45=8,BO151,IF($F$45=12,BO152,IF($F$45=16,BO153,BO154)))","v":{"$error":"#N/A"}},{"$f":"IF($F$45=8,BP151,IF($F$45=12,BP152,IF($F$45=16,BP153,BP154)))","v":{"$error":"#N/A"}},null,null,null,null,"Tf =",{"$f":"IF($N$91=4,BQ162,IF($N$91=6,BQ163,MAX(BQ164:BQ165)))","v":{"$error":"#N/A"}},{"$f":"IF($N$91=4,BZ162,IF($N$91=6,BZ163,MAX(BZ164:BZ165)))","v":{"$error":"#N/A"}},"Tr =",{"$f":"IF($N$93=0.625,98,IF($N$93=0.75,141,IF($N$93=0.875,192,IF($N$93=1,251,IF($N$93=1.125,279,IF($N$93=1.25,345,496))))))","v":251},"Tf/Tr =",{"$f":"M94/P94","v":{"$error":"#N/A"}},{"$f":"N94/P94","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,"T  =",{"$f":"IF(N91=4,BS162,IF(N91=6,BS163,BS164))","v":{"$error":"#N/A"}},null,"T  =",{"$f":"P94","v":251}]
[" ",null,null,null,null,null,null,null,null,null,null,"Vf =",{"$f":"IF($N$91=4,BR162,IF($N$91=6,BR163,BR164))","v":{"$error":"#N/A"}},{"$f":"IF($N$91=4,CA162,IF($N$91=6,CA163,CA164))","v":{"$error":"#N/A"}},"Vr =",{"$f":"IF($N$93=0.625,54.9,IF($N$93=0.75,79,IF($N$93=0.875,108,IF($N$93=1,141,IF($N$93=1.125,156,IF($N$93=1.25,193,278))))))","v":141},"Vf/Vr =",{"$f":"M96/P96","v":{"$error":"#N/A"}},{"$f":"N96/P96","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(+(R94^2)+R96^2,R94)","v":{"$error":"#N/A"}},{"$f":"MAX(+(S94^2)+S96^2,S94)","v":{"$error":"#N/A"}}]
[null,null,"COMBINED FORCE RATIO    =",null,null,null,{"$f":"IF(C91<L40,MAX(+F94/C94,G94/C94),MAX(F94/C93,G94/C93))","v":{"$error":"#N/A"}},null,null,null,null,null,"COMBINED FORCE RATIO     =",null,null,{"$f":"MAX(R97,S97)","v":{"$error":"#N/A"}}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"NEW FLANGE CONNECTION CHECK FOR TYPE S"]
[null,null,null,null,null,null,null,null,null,null,null,"================="]
[null,null,null,null,null,null,null,null,null,null,null,"NO. OF BOLTS=",null,6,"(4,6 or 8)"]
[null,null,null,null,null,null,null,null,null,null,null,"BOLT DIA.   =",null,1,"inches","(MAX 1.5\")"]
[null,null,null,null,null,null,null,null,null,null,null,"Tf =",{"$f":"$BQ$166","v":{"$error":"#N/A"}},{"$f":"$BZ$166","v":{"$error":"#N/A"}},"Tr =",{"$f":"IF($N$104=0.625,98,IF($N$104=0.75,141,IF($N$104=0.875,192,IF($N$104=1,251,IF($N$104=1.125,279,IF($N$104=1.25,345,496))))))","v":251},"Tf/Tr =",{"$f":"M105/P105","v":{"$error":"#N/A"}},{"$f":"N105/P105","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,"T  =",{"$f":"$BS$166","v":{"$error":"#N/A"}},null,"T  =",{"$f":"$P$105","v":251}]
[null,null,null,null,null,null,null,null,null,null,null,"Vf =",{"$f":"$BR$163","v":{"$error":"#N/A"}},{"$f":"$CA$166","v":{"$error":"#N/A"}},"Vr =",{"$f":"IF($N$104=0.625,54.9,IF($N$104=0.75,79,IF($N$104=0.875,108,IF($N$104=1,141,IF($N$104=1.125,156,IF($N$104=1.25,193,278))))))","v":141},"Vf/Vr =",{"$f":"M107/P107","v":{"$error":"#N/A"}},{"$f":"N107/P107","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(+(R105^2)+R107^2,R105)","v":{"$error":"#N/A"}},{"$f":"MAX(+(S105^2)+S107^2,S105)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,"COMBINED FORCE RATIO     =",null,null,{"$f":"MAX($R$108,$S$108)","v":{"$error":"#N/A"}},{"$f":"IF($A$10=\"S\",\"**FLANGE BOLT RATIO FOR TYPE S\",\"\")","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null," "]
[]
[null,"ASSUMPTIONS"]
["1)","DEAD LOAD OF SIGN = 0.45 kN/m^2"]
["2)","WIND LOAD IN THE TRANSVERSE DIRECTION = 20% IN THE OTHER DIRECTION"]
["3)","ANCHOR BOLTS ARE 20% STRONGER THAN THE APPLIED LOADS"]
["4)","Cd for 8 sided member = 1.4"]
[]
[]
["*****  FOR 'USER GUIDE' AND 'PROGRAM ASSUMPTIONS' REFER TO OTHER WORKSHEETS OF THIS WORKBOOK"]
["Disclaimer: This spreadsheet does not check for fatigue and fatigue loading as per CAN/CSA-S6-19. This spreadsheet is recommended for preliminary design purposes only."]
["For using this program, the user accepts and understands that no warranty is expressed on the accuracy or the reliability of the program. "]
["BASE LOADS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"REFERENCE:  AASHTO SPECS GUIDE, TABLE B-1"]
["Mx =",{"$f":"S76/I42","v":{"$error":"#N/A"}},"Mtotal =",{"$f":"(B133^2+B134^2)^0.5","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CONVERSION OF S to Z USING SHAPE FACTOR Kp"]
["My =",{"$f":"T76/I42+Q76/I41","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"R",16,12,8]
["Mz =",{"$f":"U76/I42","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"S",3.14,3.22,3.29,3.5]
["DL =",{"$f":"K76","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A",6.28,6.37,6.43,6.63]
["Vy =",{"$f":"L76","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kp",1.27,1.27,1.26,1.24]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Z",{"$f":"BN135*BN137","v":3.9878},{"$f":"BO135*BO137","v":4.0894000000000004},{"$f":"BP135*BP137","v":4.1454000000000004},{"$f":"BQ135*BQ137","v":4.34}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"r",0.70699999999999996,0.71099999999999997,0.71499999999999997,0.72699999999999998]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"REFERENCE:  AASHTO TABLE B.2 STRESSES FOR TUBULAR SECTIONS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BASE MOMENTS CALCULATIONS FOR POLES AND ARMS",null,null,null,null,"CAN/CSA-S6-06 TABLE A3.2.2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"        ARM",null,"CALCULATION FOR Ch = HORIZONTAL DRAG COEFFICIENT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WIND","ICE",null,"D*(q*Ce)^.5"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fx =",{"$f":"IF(OR(OR(OR($D$38=\"T1\",$D$38=\"T7\"),$D$38=\"T3\"),$D$38=\"T6\"),SUM($BE$58:$BE$71)+0.2*SUM($BI$58:$BI$71),SUM($Z$58:$Z$71)+0.2*SUM($AD$58:$AD$71))","v":{"$error":"#N/A"}},{"$f":"IF(OR(OR(OR($D$38=\"T1\",$D$38=\"T7\"),$D$38=\"T3\"),$D$38=\"T6\"),SUM($BE$58:$BE$71)+SUM($BF$58:$BF$71)+0.2*$J$42/$I$42*SUM($BI$58:$BI$71),SUM($Z$58:$Z$71)+SUM($AA$58:$AA$71)+0.2*$J$42/$I$42*SUM($AD$58:$AD$71))","v":{"$error":"#N/A"}},null,{"$f":"F74*2/1000*(F40*1000*F43)^0.5","v":{"$error":"#N/A"}},{"$f":"F71*2/1000*(F40*1000*F43)^0.5","v":{"$error":"#N/A"}},{"$f":"F53*2/1000*(F40*1000*F43)^0.5","v":1.2},{"$f":"F56*2/1000*(F40*1000*F43)^0.5","v":1.7000000000000002},{"$f":"F57*2/1000*(F40*1000*F43)^0.5","v":1.7000000000000002}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fy =",{"$f":"IF(OR(OR(OR($D$38=\"T1\",$D$38=\"T7\"),$D$38=\"T3\"),$D$38=\"T6\"),SUM($BI$58:$BI$71),SUM(AD58:AD71))","v":{"$error":"#N/A"}},{"$f":"$J$42/$I$42*BO147","v":{"$error":"#N/A"}},null,"(POLE)","(ARM)","(DAVIT)","    (EXTENSIONS)"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SIDED","      Mf (POLE)",null,"     Mf (ARM)",null,"SIDED","Cd"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WIND","ICE","WIND","ICE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,{"$f":"($Q$76+$T$76)*0.414+$S$76","v":{"$error":"#N/A"}},{"$f":"($Q$76+$R$76+0.7/1.3*$T$76)*0.414+$J$42/1.3*$S$76","v":{"$error":"#N/A"}},{"$f":"0.414*BO146+BO147","v":{"$error":"#N/A"}},{"$f":"0.414*BP146+BP147","v":{"$error":"#N/A"}},8,1.4,1.4,1.4,1.4,1.4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,{"$f":"MAX(($Q$76+$T$76)*0.268+$S$76,0.732*($Q$76+$T$76+$S$76))","v":{"$error":"#N/A"}},{"$f":"MAX(($Q$76+$R$76+$J$42/$I$42*$T$76)*0.268+$J$42/$I$42*$S$76,0.732*($Q$76+$R$76+$J$42/$I$42*$T$76+$J$42/$I$42*$S$76))","v":{"$error":"#N/A"}},{"$f":"MAX(0.268*BO146+BO147,0.732*(BO146+BO147))","v":{"$error":"#N/A"}},{"$f":"MAX(0.268*BP146+BP147,0.732*(BP146+BP147))","v":{"$error":"#N/A"}},12,{"$f":"IF(BR146<=3.6,1.2,IF(BR146>=7.2,0.8,2.6/(BR146^0.6)))","v":{"$error":"#N/A"}},{"$f":"IF(BS146<=3.6,1.2,IF(BS146>=7.2,0.8,2.6/(BS146^0.6)))","v":{"$error":"#N/A"}},{"$f":"IF(BT146<=3.6,1.2,IF(BT146>=7.2,0.8,2.6/(BT146^0.6)))","v":1.2},{"$f":"IF(BU146<=3.6,1.2,IF(BU146>=7.2,0.8,2.6/(BU146^0.6)))","v":1.2},{"$f":"IF(BV146<=3.6,1.2,IF(BV146>=7.2,0.8,2.6/(BV146^0.6)))","v":1.2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16,{"$f":"MAX(($Q$76+$T$76)*0.199+$S$76,0.567*($Q$76+$T$76)+0.848*$S$76)","v":{"$error":"#N/A"}},{"$f":"MAX(($Q$76+$R$76+$J$42/$I$42*$T$76)*0.199+$J$42/$I$42*$S$76,0.567*($Q$76+$R$76+$J$42/$I$42*$T$76)+0.848*$J$42/$I$42*$S$76)","v":{"$error":"#N/A"}},{"$f":"MAX(0.199*BO146+BO147,0.567*BO146+0.848*BO147)","v":{"$error":"#N/A"}},{"$f":"MAX(0.199*BP146+BP147,0.567*BP146+0.848*BP147)","v":{"$error":"#N/A"}},16,{"$f":"IF(BR146<=3.6,1.1,IF(BR146>=7.2,0.55,0.55+(7.2-BR146)/6.5))","v":{"$error":"#N/A"}},{"$f":"IF(BS146<=3.6,1.1,IF(BS146>=7.2,0.55,0.55+(7.2-BS146)/6.5))","v":{"$error":"#N/A"}},{"$f":"IF(BT146<=3.6,1.1,IF(BT146>=7.2,0.55,0.55+(7.2-BT146)/6.5))","v":1.1000000000000001},{"$f":"IF(BU146<=3.6,1.1,IF(BU146>=7.2,0.55,0.55+(7.2-BU146)/6.5))","v":1.1000000000000001},{"$f":"IF(BV146<=3.6,1.1,IF(BV146>=7.2,0.55,0.55+(7.2-BV146)/6.5))","v":1.1000000000000001}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ROUND",{"$f":"(($Q$76+$T$76)^2+$S$76^2)^0.5","v":{"$error":"#N/A"}},{"$f":"(($Q$76+$R$76+$J$42/$I$42*$T$76)^2+($J$42/$I$42*$S$76)^2)^0.5","v":{"$error":"#N/A"}},{"$f":"(BO146^2+BO147^2)^0.5","v":{"$error":"#N/A"}},{"$f":"(BP146^2+BP147^2)^0.5","v":{"$error":"#N/A"}},"ROUND",{"$f":"IF(BR146<=3.6,1.2,IF(BR146>=7.2,0.5,6.42/(BR146^1.3)))","v":{"$error":"#N/A"}},{"$f":"IF(BS146<=3.6,1.2,IF(BS146>=7.2,0.5,6.42/(BS146^1.3)))","v":{"$error":"#N/A"}},{"$f":"IF(BT146<=3.6,1.2,IF(BT146>=7.2,0.5,6.42/(BT146^1.3)))","v":1.2},{"$f":"IF(BU146<=3.6,1.2,IF(BU146>=7.2,0.5,6.42/(BU146^1.3)))","v":1.2},{"$f":"IF(BV146<=3.6,1.2,IF(BV146>=7.2,0.5,6.42/(BV146^1.3)))","v":1.2}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FLANGE CONNECTION"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"================="]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WIND","Mx","My","V","Tf","Vf","T","V",null,"ICE","Mx","My","V","Tf","Vf","T","V"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FACTORED",{"$f":"BO147","v":{"$error":"#N/A"}},{"$f":"BO146","v":{"$error":"#N/A"}},{"$f":"$I$41*SUM($W$58:$W$71)+$I$42*0.2*SUM($X$58:$X$71)","v":{"$error":"#N/A"}},null,null,null,null,null,"FACTORED",{"$f":"BP147","v":{"$error":"#N/A"}},{"$f":"BP146","v":{"$error":"#N/A"}},{"$f":"$I$41*SUM($W$58:$W$71)+$I$43*SUM($Y$58:$Y$71)+$J$42*0.2*SUM($X$58:$X$71)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SERVICE",{"$f":"BN160/$I$42","v":{"$error":"#N/A"}},{"$f":"SUM($Z58:$Z71)/$I41+0.2*$BN160/$I$42","v":{"$error":"#N/A"}},{"$f":"SUM($W$58:$W$71)+0.2*SUM($X$58:$X$71)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4",{"$f":"1/(4*0.707*$N92/2)","v":2.9223701590938315E-3},{"$f":"1/(4*0.707*$N92/2)","v":2.9223701590938315E-3},4,{"$f":"(BN160*BN162+BO160*BO162)*1000","v":{"$error":"#N/A"}},{"$f":"BY160/BP162","v":{"$error":"#N/A"}},{"$f":"(BN161*BN162+BO161*BO162)*1000","v":{"$error":"#N/A"}},{"$f":"BP161/BP162","v":{"$error":"#N/A"}},null,"4",{"$f":"1/(4*0.707*$N92/2)","v":2.9223701590938315E-3},{"$f":"1/(4*0.707*$N92/2)","v":2.9223701590938315E-3},4,{"$f":"(BW160*BW162+BX160*BX162)*1000","v":{"$error":"#N/A"}},{"$f":"BP160/BY162","v":{"$error":"#N/A"}},{"$f":"(BW161*BW162+BX161*BX162)*1000","v":0},{"$f":"BY161/BY162","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"6",{"$f":"1/(4*0.866*$N92/2)","v":2.3858148989368807E-3},{"$f":"0.5/(4*(0.5)^2*($N92/2)+2*($N92/2))","v":1.3774104683195593E-3},6,{"$f":"(BN160*BN163+BO160*BO163)*1000","v":{"$error":"#N/A"}},{"$f":"BY160/BP163","v":{"$error":"#N/A"}},{"$f":"(BN161*BN163+BO161*BO163)*1000","v":{"$error":"#N/A"}},{"$f":"BP161/BP163","v":{"$error":"#N/A"}},null,"6",{"$f":"1/(4*0.866*$N92/2)","v":2.3858148989368807E-3},{"$f":"0.5/(4*(0.5)^2*($N92/2)+2*($N92/2))","v":1.3774104683195593E-3},6,{"$f":"(BW160*BW163+BX160*BX163)*1000","v":{"$error":"#N/A"}},{"$f":"BP160/BY163","v":{"$error":"#N/A"}},{"$f":"(BW161*BW163+BX161*BX163)*1000","v":0},{"$f":"BY161/BY163","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"8",{"$f":"0.707/(4*(0.707)^2*$N92/2+2*($N92/2))","v":1.4609644072783915E-3},{"$f":"0.707/(4*(0.707)^2*$N92/2+2*($N92/2))","v":1.4609644072783915E-3},8,{"$f":"(BN160*BN164+BO160*BO164)*1000","v":{"$error":"#N/A"}},{"$f":"BY160/BP164","v":{"$error":"#N/A"}},{"$f":"(BN161*BN164+BO$161*BO164)*1000","v":{"$error":"#N/A"}},{"$f":"BP161/BP164","v":{"$error":"#N/A"}},null,"8",{"$f":"0.707/(4*(0.707)^2*$N92/2+2*($N92/2))","v":1.4609644072783915E-3},{"$f":"0.707/(4*(0.707)^2*$N92/2+2*($N92/2))","v":1.4609644072783915E-3},8,{"$f":"(BW160*BW164+BX160*BX164)*1000","v":{"$error":"#N/A"}},{"$f":"BP160/BY164","v":{"$error":"#N/A"}},{"$f":"(BW161*BW164+BX$161*BX164)*1000","v":0},{"$f":"BY161/BY164","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"1/(4*(0.707)^2*$N92/2+2*($N92/2))","v":2.066427733067032E-3},0,8,{"$f":"(BN160*BN165+BO$160*BO165)*1000","v":{"$error":"#N/A"}},{"$f":"BY160/BP165","v":{"$error":"#N/A"}},{"$f":"(BN161*BN165+BO161*BO165)*1000","v":{"$error":"#N/A"}},{"$f":"BP161/BP165","v":{"$error":"#N/A"}},null,null,{"$f":"1/(4*(0.707)^2*$N92/2+2*($N92/2))","v":2.066427733067032E-3},0,8,{"$f":"(BW160*BW165+BX$160*BX165)*1000","v":{"$error":"#N/A"}},{"$f":"BP160/BY165","v":{"$error":"#N/A"}},{"$f":"(BW161*BW165+BX161*BX165)*1000","v":0},{"$f":"BY161/BY165","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"6-TYPE S",{"$f":"1/(6*(325/2))","v":1.0256410256410256E-3},{"$f":"0.25/(250/2)","v":2E-3},6,{"$f":"(BN160*BN166+BO160*BO166)*1000","v":{"$error":"#N/A"}},{"$f":"BR163","v":{"$error":"#N/A"}},{"$f":"(BN161*BN166+BO161*BO166)*1000","v":{"$error":"#N/A"}},{"$f":"BT163","v":{"$error":"#N/A"}},null,"6-TYPE S",{"$f":"1/(6*(325/2))","v":1.0256410256410256E-3},{"$f":"0.25/(250/2)","v":2E-3},6,{"$f":"(BW160*BW166+BX160*BX166)*1000","v":{"$error":"#N/A"}},{"$f":"CA163","v":{"$error":"#N/A"}},{"$f":"(BW161*BW166+BX161*BX166)*1000","v":0},{"$f":"CC163","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ANCHOR BOLT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"==========="]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WIND","Mx","My","V","Tf","Vf",null,null,null,"ICE","Mx","My","V","Tf","Vf"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FACTORED",{"$f":"AB76","v":{"$error":"#N/A"}},{"$f":"Z76+AC76","v":{"$error":"#N/A"}},{"$f":"AD76*2/$N$81*1000+$L$76","v":{"$error":"#N/A"}},null,null,null,null,null,"FACTORED",{"$f":"$J$42/$I$42*AB76","v":{"$error":"#N/A"}},{"$f":"Z76+AA76+$J$42/$I$42*AC76","v":{"$error":"#N/A"}},{"$f":"$J$42/$I$42*AD76*2/$N$81*1000+$L$76","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SERVICE",{"$f":"BN170/I42","v":{"$error":"#N/A"}},{"$f":"AC76/I42+Z76/I41","v":{"$error":"#N/A"}},{"$f":"BP170/I42","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4",{"$f":"1/(4*0.707*$N81/2)","v":2.0618471676405459E-3},{"$f":"1/(4*0.707*$N81/2)","v":2.0618471676405459E-3},4,{"$f":"(BN170*BN172+BO170*BO172)*1000","v":{"$error":"#N/A"}},{"$f":"BP170/BP172","v":{"$error":"#N/A"}},null,null,null,"4",{"$f":"1/(4*0.707*$N81/2)","v":2.0618471676405459E-3},{"$f":"1/(4*0.707*$N81/2)","v":2.0618471676405459E-3},4,{"$f":"(BW170*BW172+BX170*BX172)*1000","v":{"$error":"#N/A"}},{"$f":"BY170/BY172","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"6",{"$f":"1/(4*0.866*$N81/2)","v":1.6832863135356419E-3},{"$f":"0.5*($N81/2)/(4*(0.5*($N81/2))^2+2*($N81/2)^2)","v":9.7181729834791054E-4},6,{"$f":"(BN170*BN173+BO170*BO173)*1000","v":{"$error":"#N/A"}},{"$f":"BP170/BP173","v":{"$error":"#N/A"}},null,null,null,"6",{"$f":"1/(4*0.866*$N81/2)","v":1.6832863135356419E-3},{"$f":"0.5*($N81/2)/(4*(0.5*($N81/2))^2+2*($N81/2)^2)","v":9.7181729834791054E-4},6,{"$f":"(BW170*BW173+BX170*BX173)*1000","v":{"$error":"#N/A"}},{"$f":"BY170/BY173","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"8",{"$f":"0.707/(4*(0.707)^2*$N81/2+2*($N81/2))","v":1.0307678908494774E-3},{"$f":"0.707/(4*(0.707)^2*$N81/2+2*($N81/2))","v":1.0307678908494774E-3},8,{"$f":"($BN$170*BN174+$BO$170*BO174)*1000","v":{"$error":"#N/A"}},{"$f":"BP170/BP174","v":{"$error":"#N/A"}},null,null,null,"8",{"$f":"0.707/(4*(0.707)^2*$N81/2+2*($N81/2))","v":1.0307678908494774E-3},{"$f":"0.707/(4*(0.707)^2*$N81/2+2*($N81/2))","v":1.0307678908494774E-3},8,{"$f":"($BN$170*BW174+$BO$170*BX174)*1000","v":{"$error":"#N/A"}},{"$f":"BY170/BY174","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"1/(4*(0.707)^2*$N81/2+2*($N81/2))","v":1.4579460973825709E-3},0,8,{"$f":"($BN$170*BN175+$BO$170*BO175)*1000","v":{"$error":"#N/A"}},{"$f":"BP170/BP175","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"1/(4*(0.707)^2*$N81/2+2*($N81/2))","v":1.4579460973825709E-3},0,8,{"$f":"($BN$170*BW175+$BO$170*BX175)*1000","v":{"$error":"#N/A"}},{"$f":"BY170/BY175","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"12",{"$f":"(0.866*$N81/2)/(2*($N81/2)^2+4*(0.866*$N81/2)^2+4*(0.5*$N81/2)^2)","v":8.4161846784434728E-4},{"$f":"(0.5*$N81/2)/(2*($N81/2)^2+4*(0.866*$N81/2)^2+4*(0.5*$N81/2)^2)","v":4.8592290291244068E-4},12,{"$f":"(BN170*BN176+BO170*BO176)*1000","v":{"$error":"#N/A"}},{"$f":"BP170/BP176","v":{"$error":"#N/A"}},null,null,null,"12",{"$f":"(0.866*$N81/2)/(2*($N81/2)^2+4*(0.866*$N81/2)^2+4*(0.5*$N81/2)^2)","v":8.4161846784434728E-4},{"$f":"(0.5*$N81/2)/(2*($N81/2)^2+4*(0.866*$N81/2)^2+4*(0.5*$N81/2)^2)","v":4.8592290291244068E-4},12,{"$f":"(BW170*BW176+BX170*BX176)*1000","v":{"$error":"#N/A"}},{"$f":"BY170/BY176","v":{"$error":"#N/A"}}]

{"sheet":"USER GUIDE","index":1,"n_rows":50,"n_cols":11,"rows_kept":50,"cut":false,"hidden":false,"merged":[]}
["POLE CAPACITY PROGRAM USER GUIDE",null,null,null,null,null,null,null,null,null,"[EDITED]"]
[]
["REFERENCES"]
["-","Standard Specifications for Highway Construction, BCMoT"]
["-","Electrical and Signing Material Standards, BCMoT"]
[]
["GENERAL"]
["-","Press \"Control A\" to clear all input cells "]
["-","Use UPPERCASE only (lowercase will induce wrong results)"]
["-","Enter general information (optional)"]
[]
["WIND PRESSURE"]
["-","Enter wind pressure"]
["-","Wind pressure tables for various areas of the Province may be found in"]
[null,"the Moth Electrical and Traffic Engineering Manual or the Canadian Highway Bridge Design Code."]
[null,"CAN/CSA-S6-06"]
["-","If the location is not listed on the tables then use the nearest location listed"]
["-","Use 25 year return period for signal poles and 50 year return period for sign poles"]
[]
["POLES"]
["-","Enter the pole part in column to the left"]
["-","Pole parts are detailed in the current Standard Specifications for Highway Construction"]
[]
["SIGNAL ARMS & SIGN ARMS"]
["- ","Enter the arm parts in column to the left"]
["-","Arm parts are detailed in the current Standard Specifications for Highway Construction"]
[]
["SIGNAL HEADS"]
["-","Enter the number of each type of signal head in the column to the left"]
["-","Enter the span of each signal head (from center of pole to center of signal head in meters) in the"]
[null,"column to the right"]
[]
["SIGNS"]
["-","Enter \"1\" on left column for each sign selected (including street name sign)"]
["-","Enter the sign width, height, span and number of sign luminaires for each sign.  \"Sign spans\" are"]
[null,"measured from the center of the sign to the center of the pole shaft in meters"]
[]
["POLE CAPACITY"]
["-","The program will calculate the combination force ratio for each part of pole.  All parts must be less"]
[null,"than 1.0 or the pole is not acceptable"]
[]
["DEFLECTIONS"]
["-","The program will calculate the deflections at the top of the pole and also the end of the arm with"]
[null,"and without any signals or signs for checking purposes. Deflection greater than 600 is not acceptable"]
[]
["NOTES"]
["-","Print out a hard copy backup for each pole used for the project file"]
["-","If a pole configuration or special circumstances not covered under this program, or"]
[null,"if you have any questions or suggestions, please contact Alireza Ahmadnia, Ministry of Transportation,"]
[null,"South Coast Region, Tel: (604) 323-3486, or Email: Alireza.Ahmadnia@gov.bc.ca"]

{"sheet":"PROGRAM ASSUMPTIONS","index":2,"n_rows":71,"n_cols":6,"rows_kept":71,"cut":false,"hidden":false,"merged":[]}
["PROGRAM ASSUMPTIONS"]
[]
["DESIGN CODE"]
["-","Canadian Highway Bridge Design Code, CAN/CSA-S6-06"]
["-","Ontario Highway Bridge Design Code, 3rd edition (1991)"]
["-","Standard Specifications for Structural Supports for Highway Signs, Luminaires and Traffic Signals,"]
[null,"AASHTO (1994)"]
[]
["DESIGN PARAMETERS / ASSUMPTIONS"]
["- ","Wind pressure data used are summarized from page 81 and 82 of CHBDC"]
[null,"    25 years return periods for traffic signal structures"]
[null,"    50 years return periods for sign structures "]
["-","Exposure coefficients as per cl. 3.10.1.3 of CHBDC"]
["-","Gust effect coefficient = 2.5 as per cl. 3.10.1.2 of CHBDC"]
["-","Drag coefficients as per table A3.2.2 of CHBDC"]
[null,"    1.4 for octagonal sections with sharp corners"]
[null,"    1.2 for signs and signals"]
["-","Load cases for wind are 100% normal with 20% transverse or 60% normal with 30% transverse as"]
[null,"per table A3.2.3 of CHBDC"]
["- ","Load combinations for ultimate limit state are 1.0 for dead load with 1.3 for wind load as per "]
[null,"table A3.2.1 of CHBDC"]
["- ","Combined axial compression, flexure and torsion interaction as per cl. 10-24.3 OHBDC "]
["- ","Plastic moment coefficients, Kp are taken from table 1.3.1B(2) AASHTO"]
["- ","Maximum stresses in tubular shapes are taken from table 1.3.1B(3) AASHTO"]
["-","No deduction on wind load area on the arm regardless of area covered by signals or signs "]
["-","Anchor bolts are designed to withstand 120% of the applied loads"]
[]
["DESIGN DATA"]
[]
["SIGNALS"]
["TYPE",null,null,"AREA (m^2)",null,"WEIGHT (kn)"]
["(200-200-200)",null,null,0.55000000000000004,null,0.12]
["(300-200-200)",null,null,0.78,null,0.14000000000000001]
["(300-200-200-300)",null,null,1.01,null,0.2]
["(300-300-300)",null,null,0.9,null,0.18]
["(300-300-300-300)",null,null,1.1399999999999999,null,0.24]
[]
["SIGNS"]
["- ","All signs are assumed to have a unit weight of  0.45 kN/m^2 including mounting hardware "]
[]
["LUMINAIRES"]
["-","All pole mounted luminaires to have area = 0.25m^2, weight = 0.21kn, drag coefficient = 0.70"]
["-","All sign mounted luminaires to have area = 0.14m^2, weight = 0.35kn, drag coefficient = 1.20"]
[]
["ANCHOR BOLTS"]
[null,null,null,"Factored Tensile ",null,"Factored Shear"]
["TYPE",null,null,"Resistance, Tr (kn)",null,"Resistance, Vr (kn)"]
["1\" - 4140",null,null,220,null,123]
["1\" Dywidag","if you have any questions or suggestions, please contact Alireza Ahmadnia, Ministry of Transportation,",null,313,null,175]
["1 1/2\" - 4140",null,null,495,null,277]
[]
[]
["JULY 2012 PROGRAM REVIEW"]
["The following changes have been made during the July 2012 Prgram Review by Tian Wang."]
[]
["Deflection"]
["-","Radius of each section has been modified to meaure to the center of member wall. "]
[null,"This change is made to conform to the formulae outlined in the 2001 edition of AASHTO "]
[null,"Std. Spec for Structural Supports for Hwy Signs, Luminaires, and Traffic Signals"]
["-","If-statements are added to reflect the difference in structural properties (I, A, S, Z) between members "]
[null,"of different cross sectional shapes (8, 12, or 16 sdies)"]
["-","Comments and explanation are added to the DEFLECTION tab to guide the next program review"]
["-","Deflection calculations, especically for S-type pole, have been confirmed by a model using S-Frame"]
[]
["Pole Capacity"]
["-","Phi factors for bolts are updated to conform to S6-06 and S16-09"]
["-","Bolt capacities in shear and tension are increased due to higher ultimate strength and higher phi "]
[null,"factor as specified in S16-09"]
["-","The rectangular bolt pattern of the S-type pole has been reviewed and corrected to output the correct"]
[null,"capcity in shear and tension."]
["-","Confirmed that compact and non-compact sectional properties are accounted for. "]

{"sheet":"POLES DATA","index":3,"n_rows":101,"n_cols":13,"rows_kept":101,"cut":false,"hidden":true,"merged":[]}
[1,2,3,4,5,6,7,8,9,10,11,12,13]
["TABLE 1:  COMPONENTS SELECTION - UPDATED NOVEMBER 9, 2009",null,null,null,null,null,null,null,null,null,"Reference Drawings - SP635"]
["TYPES","Luminaire Arm","Luminaire Arm Extension","Signal Arm","Signal Arm Extension","Signal Arm Adapter","Sign Arm","Sign Arm Extension","Special Signal Arm","Notes","Signal Pole","Sign Pole","Condition"]
["T1","2A, 2C","2B","3C, 3A, 3D, 3E","(N/A)","(N/A)","L, LB","(N/A)","(INVALID EXTENSION)","6.5 POLE or 8.5 POLE; 2B for 6.5 POLE only; Signal Arm:  3F-300 to 3000mm max; L max 1200mm","2.1.1","3.1.1"]
["T2","2A, 2C","(N/A)","(N/A)","(N/A)","(N/A)","(N/A)","(N/A)","(INVALID EXTENSION)","(N/A)","2.1.3 / 2.1.5","N/A"]
["T3","(N/A)","(N/A)","3C, 3A, 3D, 3E","(N/A)","(N/A)","L, LB","(N/A)","(INVALID EXTENSION)","L max 1200mm","2.1.7","3.1.3"]
["T6","(N/A)","(N/A)","3C, 3A, 3D, 3E","7A, 7B, 7C, 7D","(N/A)","L, LB","7A, 7B, 7C","(INVALID EXTENSION)","L max 1200mm","2.1.11","3.1.6"]
["T7","2A, 2C","7A, 7B, 7D","3C, 3A, 3D, 3E","7A, 7B, 7C, 7D","(N/A)","L, LB","7A, 7B, 7C","(INVALID EXTENSION)","L max 1200mm","2.1.13","3.1.8"]
["L","2A, 2C","0.25L, 1.75L, 4.25L","3L - 11L","3LE","(N/A)","L, LB / L1, L2","LS, 3LS, 4LS, 5LS","9L - 11L","Input sign arm & arm extension length; L max 1200mm","2.2.1","3.1.10","L, LB"]
["M","2A, 2C","0.25M, 1.75M, 4.25M","3L - 11L","6M","FA","M1, M2","(N/A)","6L - 11L","Sign Arm:  3000 to 11000mm max","2.2.4","3.1.13"]
["H","2A, 2C","1.13H, 3.63H","(N/A)","(N/A)","(N/A)","H1, H2","(N/A)","(INVALID EXTENSION)","Sign Arm: H1-3000 to 8000mm max; H2-3000 to 11000mm max","N/A","3.1.16"]
["S","2A, 2C","0.25L, 1.75L","5S - 11S","(N/A)","(N/A)","L, LB","SS, 3SS, 4SS, 5SS","(INVALID EXTENSION)","Input sign arm & arm extension length; L max 1200mm","2.2.7","3.1.19"]
[]
[]
["TABLE 2:  COMPONENTS PROPERTIES (POLE ARMS)"]
["Sections","Type","Lengths (mm) - horizontal","Height (mm) - vertical","Height of Arm (mm)","Mass (kg)","# of sides","Plate Thk. (mm)","Dia, Max (mm)","Dia, Min (mm)"]
["3C","T1",1800,null,null,18,8,3,120,67]
["3A","T1",3000,null,null,27,8,3,120,67]
["3D","T1",4300,null,null,54,8,4.8,120,67]
["3E","T1",5500,null,null,68,8,4.8,120,67]
["2A","T1",2500,2500,null,35,8,3,120,67]
["2B","T1",null,2000,null,35,8,4.8,120,120]
["2C","T1",5000,2500,null,65,8,3,120,67]
["7A","T6",250,250,null,20,8,4.8,170,120]
["7B","T6",1800,1800,null,69,8,8,170,120]
["7C","T6",2500,null,null,86,8,8,170,120]
["7D","T6",4800,4800,null,154,8,8,170,120]
["H1","H","(INPUT)",null,null,"(INPUT)",12,6.4,340,340]
["H2","H","(INPUT)",null,null,"(INPUT)",12,8,340,340]
["1.13H","H",null,1130,null,36,12,3,350,120]
["3.63H","H",null,3630,null,118,12,4.8,350,120]
["3L","L",3000,null,null,97,8,4.8,220,120]
["4L","L",4000,null,null,118,8,4.8,220,120]
["5L","L",5000,null,null,173,8,6.4,220,120]
["6L","L",6000,null,null,201,8,6.4,220,120]
["7L","L",7000,null,null,229,8,6.4,220,120]
["8L","L",8000,null,null,259,8,6.4,220,120]
["9L","L",9000,null,null,284,8,6.4,220,120]
["10L","L",10000,null,null,377,8,8,220,120]
["11L","L",11000,null,null,410,8,8,220,120]
["3LE","L",3000,null,null,114,8,8,220,220]
["L","L SIGN ARM","(INPUT)",null,null,"(INPUT)",8,4.8,120,120]
["1.2L","L",1200,null,null,24,8,4.8,120,120]
["L1","L","(INPUT)",null,null,"(INPUT)",8,6.4,220,220]
["L2","L","(INPUT)",null,null,"(INPUT)",8,8,220,220]
["LB","L",1200,null,null,100,8]
["LS","L","(INPUT)",null,null,"(INPUT)",8,8,220,120]
["3LS","L",3000,null,null,135,8,8,220,120]
["4LS","L",4000,null,null,180,8,8,220,120]
["5LS","L",5000,null,null,225,8,8,220,120]
["0.25L","L",null,250,null,10,8,3,220,120]
["1.75L","L",null,1750,null,29,8,3,220,120]
["4.25L","L",null,4250,null,82,8,4.8,220,120]
["6M","M",6000,null,null,360,8,8,275,220]
["M1","M","(INPUT)",null,null,"(INPUT)",8,6.4,275,275]
["M2","M","(INPUT)",null,null,"(INPUT)",8,8,275,275]
["0.25M","M",null,250,null,14,12,3,275,120]
["1.75M","M",null,1750,null,38,12,3,275,120]
["4.25M","M",null,4250,null,115,12,4.8,275,120]
["FA","M",300,null,null,75,8,8,275,220]
["SS","S","(INPUT)",null,null,"(INPUT)",8,8,220,120]
["3SS","S",3000,null,null,135,8,8,220,120]
["4SS","S",4000,null,null,180,8,8,220,120]
["5SS","S",5000,null,null,225,8,8,220,120]
["5S","S",5000,null,null,104,8,3,220,120]
["5.5S","S",5500,null,null,111,8,3,220,120]
["6S","S",6000,null,null,118,8,3,220,120]
["6.5S","S",6500,null,null,125,8,3,220,120]
["7S","S",7000,null,null,132,8,3,220,120]
["7.5S","S",7500,null,null,192,8,4.76,220,120]
["8S","S",8000,null,null,204,8,4.76,220,120]
["8.5S","S",8500,null,null,214,8,4.76,220,120]
["9S","S",9000,null,null,224,8,4.76,220,120]
["9.5S","S",9500,null,null,292,8,6.35,220,120]
["10S","S",10000,null,null,306,8,6.35,220,120]
["10.5S","S",10500,null,null,320,8,6.35,220,120]
["11S","S",11000,null,null,340,8,6.35,220,120]
[]
[]
["TABLE 3. Pole Shaft Properties Table",null,null,"Height of Shaft","Height of Arm"]
["T1","T1 POLE 8.5M",2500,6500,6900,209,8,4.8,200,120]
["T1","T1 POLE 6.5M",2500,6500,6900,195,8,4.8,200,120]
["T3","T3 POLE",2500,6900,6900,186,8,4.8,200,120]
["T6","T6 POLE",2500,6900,6900,412,8,8,254,170]
["T7","T7 POLE",2500,6200,6900,465,8,8,254,170]
["H","H POLE",null,7370,7080,870,12,8,440,350]
["L","L POLE",null,6750,6538,442,8,8,270,220]
["M","M POLE",null,6750,6480,565,12,8,325,275]
["S","S POLE",null,6750,6541,385,8,8,250,220]
[]
[]
["TABLE 4. POLE BASE PLATE AND FLANGE PLATE - BOLT CIRCLE DIMENSIONS"]
["Sections","Base Plate Type","Bolt Circle Diameter (mm)","# of Base Plate Bolts","Bolts Size (in.)","Flange Plate Type","Flange Bolt Circle Diameter","Flange Bolts Size (in.)"]
["T1",null,280,4,1,"Type 1",170,"5/8"]
["T3",null,280,4,1,"Type 1",170,"5/8"]
["T6",null,343,4,"1\" Dywidag","Type 8",242,1]
["T7",null,343,4,"1\" Dywidag","Type 8",242,1]
["H",null,575,8,1.5,"Type 6",460,1.5]
["L",null,390,4,1.5,"Type 2",345,1.5]
["M",null,450,6,1.5,"Type 4",400,1.5]
["S",null,343,4,"1\" Dywidag","Type S","bolts in rows, not bolt circle",1]

{"sheet":"DEFLECTION","index":4,"n_rows":113,"n_cols":135,"rows_kept":113,"cut":false,"hidden":true,"merged":[]}
["APRIL 1995",null,"DEFLECT1.XLW","By P. Wong"]
[]
["This spreadsheet approximates the tip vertical deflection and",null,null,null,null,null,"Calculation Assumptions:"]
["joint horizontal deflection of an inverted-L-shaped sign pole"]
["with an octagonal tube cross section.",null,null,null,null,null,"Each member is divided into equal pieces with uniform sectional properties approximate a tapered post. Note that the largest cross-section is taken for each piece. "]
[]
[null,null,null,null,null,null,"Table 1: Horizontal Deflections at joint. "]
[]
["Material",null,null,null,null,null,"Table 2: Vertical Deflections at tip of cantilever"]
["E","modulus of elasticity",200000,"MPa"]
["G","shear modulus",77000,"MPa",null,null,"Each table is organized into two parts."]
["u","unit weight",7.7000000000000001E-5,"N/mm^3",null,null,"First part calculates deflection caused by each of the 8 types of external weights (5 types of signal heads + 3 types of signage)"]
[null,null,null,null,null,null,"Second Part calculates deflection cuased by the self weight of the post and cantilever"]
["========= GEOMETRY AND LOADING ========="]
["CANTILEVERED POLE",null,null,null,null,null,"Total deflections presented in \"POLE CAPACITY PROGRAM\" sums the deflections from self weight and external loads."]
["RCG","greater radius",{"$f":"'POLE CAPACITY PROGRAM'!$F$71","v":{"$error":"#N/A"}},"mm"]
["RCS","smaller radius",{"$f":"'POLE CAPACITY PROGRAM'!$G$71","v":{"$error":"#N/A"}},"mm",null,null,"Area and Moment of Intertia formulae taken from the design aid sections of AASHTO Standard Specifications for Structural Supports for Highway Signs, Luminaires, and Traffic Signals."]
["t","thickness",{"$f":"'POLE CAPACITY PROGRAM'!$H$71","v":0},"mm"]
["Lc","total length of pole",{"$f":"'POLE CAPACITY PROGRAM'!$E$71*1000","v":0},"mm",null,null,"Spread sheet takes into account of the cross-sectional differences between S and L type (8 sides), to M and H type. (12 sides)."]
["ShpC","Number of sides in cross-section",{"$f":"'POLE CAPACITY PROGRAM'!$F$46","v":8},"sides"]
[null,null,null,null,null,null,"Analysis uses moment area method summing the deflections of each piece"]
["POST"]
["RPG","greater radius",{"$f":"'POLE CAPACITY PROGRAM'!$F$74","v":{"$error":"#N/A"}},"mm",null,null,"Linkage in formulae established to include S type poles."]
["RPS","smaller radius",{"$f":"'POLE CAPACITY PROGRAM'!$G$74","v":{"$error":"#N/A"}},"mm"]
["tp","thickness",{"$f":"'POLE CAPACITY PROGRAM'!$H$74","v":{"$error":"#N/A"}},"mm",null,null,"Bolt capacities updated to comform with S16-01"]
["Lp","height of post (to center of joint)",{"$f":"'POLE CAPACITY PROGRAM'!$E$74*1000","v":{"$error":"#N/A"}},"mm"]
["ShpP","Number of sides in cross-section",{"$f":"'POLE CAPACITY PROGRAM'!$F$45","v":8},"sides",null,null,"Factored shear and tension loads adjusted for flange bolts on S-Type pole to reflect its rectangular bolt pattern"]
[]
["LOADS  (Dead load is automatically calculated)"]
["WW1","point load 1",{"$f":"'POLE CAPACITY PROGRAM'!$K$58*1000","v":0},"N"]
["Ls1","length from joint to load 1",{"$f":"'POLE CAPACITY PROGRAM'!$N$58*1000","v":0},"mm"]
["WW2","point load 2",{"$f":"'POLE CAPACITY PROGRAM'!$K$59*1000","v":0},"N"]
["Ls2","length from joint to load 2",{"$f":"'POLE CAPACITY PROGRAM'!$N$59*1000","v":0},"mm"]
["WW3","point load 3",{"$f":"'POLE CAPACITY PROGRAM'!$K$60*1000","v":0},"N"]
["Ls3","length from joint to load 3",{"$f":"'POLE CAPACITY PROGRAM'!$N$60*1000","v":0},"mm"]
["WW4","point load 4",{"$f":"'POLE CAPACITY PROGRAM'!$K$61*1000","v":0},"N"]
["Ls4","length from joint to load 4",{"$f":"'POLE CAPACITY PROGRAM'!$N$61*1000","v":0},"mm"]
["WW5","point load 5",{"$f":"'POLE CAPACITY PROGRAM'!$K$62*1000","v":0},"N"]
["Ls5","length from joint to load 5",{"$f":"'POLE CAPACITY PROGRAM'!$N$62*1000","v":0},"mm"]
["WW6","point load 6",{"$f":"'POLE CAPACITY PROGRAM'!$K$65*1000+'POLE CAPACITY PROGRAM'!$K$68*1000","v":0},"N"]
["Ls6","length from joint to load 6",{"$f":"'POLE CAPACITY PROGRAM'!$N$65*1000","v":0},"mm"]
["WW7","point load 7",{"$f":"'POLE CAPACITY PROGRAM'!$K$66*1000+'POLE CAPACITY PROGRAM'!$K$69*1000","v":0},"N"]
["Ls7","length from joint to load 7",{"$f":"'POLE CAPACITY PROGRAM'!$N$66*1000","v":0},"mm"]
["WW8","point load 8",{"$f":"'POLE CAPACITY PROGRAM'!$K$67*1000+'POLE CAPACITY PROGRAM'!$K$70*1000","v":0},"N"]
["Ls8","length from joint to load 8",{"$f":"'POLE CAPACITY PROGRAM'!$N$67*1000","v":0},"mm"]
[]
["========= DEFLECTIONS ========="]
[]
["HDL","joint horiz. due to Dead Load",{"$f":"$BB$87+$BG$82","v":{"$error":"#N/A"}},"mm"]
["VDL","tip vert. deflect due to Dead Load",{"$f":"$EE$109+$AY$87+$C$19*TAN($BA$90)","v":{"$error":"#N/A"}},"mm"]
["H1H","joint horiz. due to load 1",{"$f":"Q89","v":{"$error":"#N/A"}},"mm"]
["VV1","tip vertical due to load 1",{"$f":"P90+$C$19*TAN(R90)+BS107","v":{"$error":"#N/A"}},"mm"]
["H2H","joint horiz. due to load 2",{"$f":"U89","v":{"$error":"#N/A"}},"mm"]
["VV2","tip vertical due to load 2",{"$f":"T90+$C$19*TAN(V90)+BZ107","v":{"$error":"#N/A"}},"mm"]
["H3H","joint horiz. due to load 3",{"$f":"Y89","v":{"$error":"#N/A"}},"mm"]
["VV3","tip vertical due to load 3",{"$f":"X90+$C$19*TAN(Z90)+CG107","v":{"$error":"#N/A"}},"mm"]
["H4H","joint horiz. due to load 4",{"$f":"AC89","v":{"$error":"#N/A"}},"mm"]
["VV4","tip vertical due to load 4",{"$f":"AB90+$C$19*TAN(AD90)+CN107","v":{"$error":"#N/A"}},"mm"]
["H5H","joint horiz. due to load 5",{"$f":"AG89","v":{"$error":"#N/A"}},"mm"]
["VV5","tip vertical due to load 5",{"$f":"AF90+$C$19*TAN(AH90)+CU107","v":{"$error":"#N/A"}},"mm"]
["H6H","joint horiz. due to load 6",{"$f":"AK89","v":{"$error":"#N/A"}},"mm"]
["VV6","tip vertical due to load 6",{"$f":"AJ90+$C$19*TAN(AL90)+DB107","v":{"$error":"#N/A"}},"mm"]
["H7H","joint horiz. due to load 7",{"$f":"AO89","v":{"$error":"#N/A"}},"mm"]
["VV7","tip vertical due to load 7",{"$f":"AN90+$C$19*TAN(AP90)+DI107","v":{"$error":"#N/A"}},"mm"]
["H8H","joint horiz. due to load 8",{"$f":"AS89","v":{"$error":"#N/A"}},"mm"]
["VV8","tip vertical due to load 8",{"$f":"AR90+$C$19*TAN(AT90)+DP107","v":{"$error":"#N/A"}},"mm"]
[]
[]
["TOT_H","TOTAL JOINT HORIZ. DEFLECTION",{"$f":"SUM(C49,C51,C53,C55,C57,C59,C61,C63,C65)","v":{"$error":"#N/A"}},"mm"]
[]
["TOT_V","TOTAL TIP VERTICAL DEFLECTION",{"$f":"SUM(C50,C52,C54,C56,C58,C60,C62,VV7_,VV8_)","v":{"$error":"#N/A"}},"mm"]
[]
[]
["TABLE1_1 >>>>>>>>",null,null,null,null,null,null,null,null,null,"TABLE1",null,null,null,null,null,">>>>>>>",null,null,null,null,null,null,null,">>>>>>>",null,null,null,null,null,null,">>>>>>>>",null,null,null,null,null,">>>>>>>",null,null,null,null,null,">>>>>>>>",null,null,null,null,null,null,">>>>>>>",null,">>>>>>>"]
[]
[null,null,null,null,null,null,null,null,null,null,"TAPERING POST"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"|","LOAD 1",null,null,"|","LOAD 2",null,null,"|","LOAD 3",null,null,"|","LOAD 4",null,null,"|","LOAD 5",null,null,"|","LOAD 6",null,null,"|","LOAD 7",null,null,"|","LOAD 8",null,null,"|","DEAD LOAD"]
[null,null,null,null,null,null,null,null,null,null,"X","ro","A","I","|","d_down","d_M","angle_M","|","d_down","d_M","angle_M","|","d_down","d_M","angle_M","|","d_down","d_M","angle_M","|","d_down","d_M","angle_M","|","d_down","d_M","angle_M","|","d_down","d_M","angle_M","|","d_down","d_M","angle_M","|","wip","d_w","d_P","jt down","d_M","angle_M","delta",null,"P-delta","d_P-delta","angle"]
[null,null,null,null,null,null,null,null,null,null,"mm","mm","mm^2","mm^4","|","mm","mm","rad","|","mm","mm","rad","|","mm","mm","rad","|","mm","mm","rad","|","mm","mm","rad","|","mm","mm","rad","|","mm","mm","rad","|","mm","mm","rad","|","N","mm","mm","mm","mm","rad","mm",null,"Nmm","mm","rad",null,null,"Table2"]
[null,null,null,null,null,null,null,null,null,null,0,{"$f":"($C$23-($C$23-$C$24)/$C$26*K80)-($C$25/2)","v":{"$error":"#N/A"}},{"$f":"IF($C$27=8,6.63*$L80*$C$25,6.43*$L80*$C$25)","v":{"$error":"#N/A"}},{"$f":"IF($C$27=8,3.5*$L80^3*$C$25,3.29*$L80^3*$C$25)","v":{"$error":"#N/A"}},"|",null,null,null,"|",null,null,null,"|",null,null,null,"|",null,null,null,"|",null,null,null,"|",null,null,null,"|",null,null,null,"|",null,null,null,"|",null,null,null,null,null,null,null,null,null,null,null,null,null,"Below!!"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"LP/14","v":{"$error":"#N/A"}},{"$f":"($C$23-($C$23-$C$24)/$C$26*K81)-($C$25/2)","v":{"$error":"#N/A"}},{"$f":"IF($C$27=8,6.63*$L81*$C$25,6.43*$L81*$C$25)","v":{"$error":"#N/A"}},{"$f":"IF($C$27=8,3.5*$L81^3*$C$25,3.29*$L81^3*$C$25)","v":{"$error":"#N/A"}},"|",{"$f":"$C$30*$C$26/7/($M81*$C$10)","v":{"$error":"#N/A"}},{"$f":"$C$30*$C$31*($C$26/7)^2/(2*$C$10*$N81)","v":{"$error":"#N/A"}},{"$f":"$C$30*$C$31*$C$26/7/($C$10*$N81)","v":{"$error":"#N/A"}},"|",{"$f":"$C$32*$C$26/7/($M81*$C$10)","v":{"$error":"#N/A"}},{"$f":"$C$32*$C$33*($C$26/7)^2/(2*$C$10*$N81)","v":{"$error":"#N/A"}},{"$f":"$C$32*$C$33*$C$26/7/($C$10*$N81)","v":{"$error":"#N/A"}},"|",{"$f":"$C$34*$C$26/7/($M81*$C$10)","v":{"$error":"#N/A"}},{"$f":"$C$34*$C$35*($C$26/7)^2/(2*$C$10*$N81)","v":{"$error":"#N/A"}},{"$f":"$C$34*$C$35*$C$26/7/($C$10*$N81)","v":{"$error":"#N/A"}},"|",{"$f":"$C$36*$C$26/7/($M81*$C$10)","v":{"$error":"#N/A"}},{"$f":"$C$36*$C$37*($C$26/7)^2/(2*$C$10*$N81)","v":{"$error":"#N/A"}},{"$f":"$C$36*$C$37*$C$26/7/($C$10*$N81)","v":{"$error":"#N/A"}},"|",{"$f":"$C$38*$C$26/7/($M81*$C$10)","v":{"$error":"#N/A"}},{"$f":"$C$38*$C$39*($C$26/7)^2/(2*$C$10*$N81)","v":{"$error":"#N/A"}},{"$f":"$C$38*$C$39*$C$26/7/($C$10*$N81)","v":{"$error":"#N/A"}},"|",{"$f":"$C$40*$C$26/7/($M81*$C$10)","v":{"$error":"#N/A"}},{"$f":"$C$40*$C$41*($C$26/7)^2/(2*$C$10*$N81)","v":{"$error":"#N/A"}},{"$f":"$C$40*$C$41*$C$26/7/($C$10*$N81)","v":{"$error":"#N/A"}},"|",{"$f":"$C$42*$C$26/7/($M81*$C$10)","v":{"$error":"#N/A"}},{"$f":"$C$42*$C$43*($C$26/7)^2/(2*$C$10*$N81)","v":{"$error":"#N/A"}},{"$f":"$C$42*$C$43*$C$26/7/($C$10*$N81)","v":{"$error":"#N/A"}},"|",{"$f":"$C$44*$C$26/7/($M81*$C$10)","v":{"$error":"#N/A"}},{"$f":"$C$44*$C$45*($C$26/7)^2/(2*$C$10*$N81)","v":{"$error":"#N/A"}},{"$f":"$C$44*$C$45*$C$26/7/($C$10*$N81)","v":{"$error":"#N/A"}},"|",{"$f":"LP/7*M81*U","v":{"$error":"#N/A"}},{"$f":"SUM(AV81:AV$87)*$C$26/7/(M81*$C$10)","v":{"$error":"#N/A"}},{"$f":"$DR$112*$C$26/7/(M81*$C$10)","v":{"$error":"#N/A"}},{"$f":"SUM(AX81)+SUM(AW81)","v":{"$error":"#N/A"}},{"$f":"$DZ$99*($C$26/7)^2/(2*$C$10*N81)","v":{"$error":"#N/A"}},{"$f":"$DZ$99*$C$26/7/($C$10*N81)","v":{"$error":"#N/A"}},{"$f":"SUM(AZ81)","v":{"$error":"#N/A"}},"P",{"$f":"(SUM(AV81:AV$87)+$BC$82)*BB87","v":{"$error":"#N/A"}},{"$f":"(SUM(AV81:AV$87)+$BC$82)*BB87*($C$26/7)^2/(2*$C$10*N81)","v":{"$error":"#N/A"}},{"$f":"BD81*$C$26/7/($C$10*N81)","v":{"$error":"#N/A"}},"delta"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"3*LP/14","v":{"$error":"#N/A"}},{"$f":"($C$23-($C$23-$C$24)/$C$26*K82)-($C$25/2)","v":{"$error":"#N/A"}},{"$f":"IF($C$27=8,6.63*$L82*$C$25,6.43*$L82*$C$25)","v":{"$error":"#N/A"}},{"$f":"IF($C$27=8,3.5*$L82^3*$C$25,3.29*$L82^3*$C$25)","v":{"$error":"#N/A"}},"|",{"$f":"$C$30*$C$26/7/(M82*$C$10)","v":{"$error":"#N/A"}},{"$f":"$C$30*$C$31*($C$26/7)^2/(2*$C$10*N82)","v":{"$error":"#N/A"}},{"$f":"$C$30*$C$31*$C$26/7/($C$10*N82)","v":{"$error":"#N/A"}},"|",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"|",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"|",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"|",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"|",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"|",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"|",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"|",{"$error":"#N/A"},{"$f":"SUM(AV82:AV$87)*$C$26/7/(M82*$C$10)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"SUM(AX$81:AX82)+SUM(AW$81:AW82)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"SUM(AZ$81:AZ82)+$C$26/7*(BA81)","v":{"$error":"#N/A"}},{"$f":"DR112","v":{"$error":"#N/A"}},{"$f":"(SUM(AV82:AV$87)+$BC$82)*(BB$87-BB81)","v":{"$error":"#N/A"}},{"$f":"(SUM(AV82:AV$87)+$BC$82)*(BB87-BB81)*($C$26/7)^2/(2*$C$10*N82)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"SUM(BE81:BE87)+$C$26/7*(6*BF81+5*BF82+4*BF83+3*BF84+2*BF85+BF86)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"5*LP/14","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"IF($C$27=8,6.63*$L83*$C$25,6.43*$L83*$C$25)","v":{"$error":"#N/A"}},{"$error":"#N/A"},"|",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"|",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"|",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"|",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"|",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"|",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"|",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"|",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"|",{"$error":"#N/A"},{"$f":"SUM(AV83:AV$87)*$C$26/7/(M83*$C$10)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"SUM(AX$81:AX83)+SUM(AW$81:AW83)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"SUM(AZ$81:AZ83)+$C$26/7*(2*BA81+BA82)","v":{"$error":"#N/A"}},null,{"$f":"(SUM(AV83:AV$87)+$BC$82)*(BB$87-BB82)","v":{"$error":"#N/A"}},{"$f":"(SUM(AV83:AV$87)+$BC$82)*(BB87-BB82)*($C$26/7)^2/(2*$C$10*N83)","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"7*LP/14","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"|",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"|",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"|",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"|",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"|",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"|",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"|",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"|",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"|",{"$error":"#N/A"},{"$f":"SUM(AV84:AV$87)*$C$26/7/(M84*$C$10)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"SUM(AX$81:AX84)+SUM(AW$81:AW84)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"SUM(AZ$81:AZ84)+$C$26/7*(3*BA81+2*BA82+BA83)","v":{"$error":"#N/A"}},null,{"$f":"(SUM(AV84:AV$87)+$BC$82)*(BB$87-BB83)","v":{"$error":"#N/A"}},{"$f":"(SUM(AV84:AV$87)+$BC$82)*(BB87-BB83)*($C$26/7)^2/(2*$C$10*N84)","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"9*LP/14","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"|",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"|",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"|",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"|",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"|",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"|",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"|",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"|",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"|",{"$error":"#N/A"},{"$f":"SUM(AV85:AV$87)*$C$26/7/(M85*$C$10)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"SUM(AX$81:AX85)+SUM(AW$81:AW85)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"SUM(AZ$81:AZ85)+$C$26/7*(4*BA81+3*BA82+2*BA83+BA84)","v":{"$error":"#N/A"}},null,{"$f":"(SUM(AV85:AV$87)+$BC$82)*(BB$87-BB84)","v":{"$error":"#N/A"}},{"$f":"(SUM(AV85:AV$87)+$BC$82)*(BB87-BB84)*($C$26/7)^2/(2*$C$10*N85)","v":{"$error":"#N/A"}},{"$error":"#N/A"},"angle"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"11*LP/14","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"IF($C$27=8,6.63*$L86*$C$25,6.43*$L86*$C$25)","v":{"$error":"#N/A"}},{"$error":"#N/A"},"|",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"|",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"|",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"|",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"|",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"|",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"|",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"|",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"|",{"$error":"#N/A"},{"$f":"SUM(AV86:AV$87)*$C$26/7/(M86*$C$10)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"SUM(AX$81:AX86)+SUM(AW$81:AW86)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"SUM(AZ$81:AZ86)+$C$26/7*(5*BA81+4*BA82+3*BA83+2*BA84+BA85)","v":{"$error":"#N/A"}},null,{"$f":"(SUM(AV86:AV$87)+$BC$82)*(BB$87-BB85)","v":{"$error":"#N/A"}},{"$f":"(SUM(AV86:AV$87)+$BC$82)*(BB87-BB85)*($C$26/7)^2/(2*$C$10*N86)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"BA90+BF90","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"13*LP/14","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"|",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"|",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"|",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"|",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"|",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"|",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"|",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"|",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"|",{"$error":"#N/A"},{"$f":"SUM(AV$87)*$C$26/7/(M87*$C$10)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"SUM(AX$81:AX87)+SUM(AW$81:AW87)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"SUM(AZ81:AZ87)+$C$26/7*(6*BA81+5*BA82+4*BA83+3*BA84+2*BA85+BA86)","v":{"$error":"#N/A"}},null,{"$f":"(SUM(AV$87)+$BC$82)*(BB$87-BB86)","v":{"$error":"#N/A"}},{"$f":"(SUM(AV$87)+$BC$82)*(BB87-BB86)*($C$26/7)^2/(2*$C$10*N87)","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"LP","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"IF($C$27=8,6.63*$L88*$C$25,6.43*$L88*$C$25)","v":{"$error":"#N/A"}},{"$error":"#N/A"},"|",null,null,null,"|",null,null,null,"|",null,null,null,"|",null,null,null,"|",null,null,null,"|",null,null,null,"|",null,null,null,"|",null,null,null,"|"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"|",null,{"$f":"SUM(Q81:Q87)+$C$26/7*(6*R81+5*R82+4*R83+3*R84+2*R85+R86)","v":{"$error":"#N/A"}},null,"|",null,{"$f":"SUM(U81:U87)+$C$26/7*(6*V81+5*V82+4*V83+3*V84+2*V85+V86)","v":{"$error":"#N/A"}},null,"|",null,{"$f":"SUM(Y81:Y87)+$C$26/7*(6*Z81+5*Z82+4*Z83+3*Z84+2*Z85+Z86)","v":{"$error":"#N/A"}},null,"|",null,{"$f":"SUM(AC81:AC87)+$C$26/7*(6*AD81+5*AD82+4*AD83+3*AD84+2*AD85+AD86)","v":{"$error":"#N/A"}},null,"|",null,{"$f":"SUM(AG81:AG87)+$C$26/7*(6*AH81+5*AH82+4*AH83+3*AH84+2*AH85+AH86)","v":{"$error":"#N/A"}},null,"|",null,{"$f":"SUM(AK81:AK87)+$C$26/7*(6*AL81+5*AL82+4*AL83+3*AL84+2*AL85+AL86)","v":{"$error":"#N/A"}},null,"|",null,{"$f":"SUM(AO81:AO87)+$C$26/7*(6*AP81+5*AP82+4*AP83+3*AP84+2*AP85+AP86)","v":{"$error":"#N/A"}},null,"|",null,{"$f":"SUM(AS81:AS87)+$C$26/7*(6*AT81+5*AT82+4*AT83+3*AT84+2*AT85+AT86)","v":{"$error":"#N/A"}},null,"|"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"|",{"$f":"SUM(P81:P87)","v":{"$error":"#N/A"}},null,{"$f":"SUM(R81:R87)","v":{"$error":"#N/A"}},"|",{"$f":"SUM(T81:T87)","v":{"$error":"#N/A"}},null,{"$f":"SUM(V81:V87)","v":{"$error":"#N/A"}},"|",{"$f":"SUM(X81:X87)","v":{"$error":"#N/A"}},null,{"$f":"SUM(Z81:Z87)","v":{"$error":"#N/A"}},"|",{"$f":"SUM(AB81:AB87)","v":{"$error":"#N/A"}},null,{"$f":"SUM(AD81:AD87)","v":{"$error":"#N/A"}},"|",{"$f":"SUM(AF81:AF87)","v":{"$error":"#N/A"}},null,{"$f":"SUM(AH81:AH87)","v":{"$error":"#N/A"}},"|",{"$f":"SUM(AJ81:AJ87)","v":{"$error":"#N/A"}},null,{"$f":"SUM(AL81:AL87)","v":{"$error":"#N/A"}},"|",{"$f":"SUM(AN81:AN87)","v":{"$error":"#N/A"}},null,{"$f":"SUM(AP81:AP87)","v":{"$error":"#N/A"}},"|",{"$f":"SUM(AR81:AR87)","v":{"$error":"#N/A"}},null,{"$f":"SUM(AT81:AT87)","v":{"$error":"#N/A"}},"|",{"$f":"SUM(AV81:AV87)","v":{"$error":"#N/A"}},{"$f":"SUM(AW81:AW87)","v":{"$error":"#N/A"}},{"$f":"SUM(AX81:AX87)","v":{"$error":"#N/A"}},null,null,{"$f":"SUM(BA81:BA87)","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"SUM(BF81:BF87)","v":{"$error":"#N/A"}}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"TABLE2 >>>>>>",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TABLE2",null,null,null,null,null,">>>>>>",null,null,null,null,null,null,">>>>>>>>",null,null,null,null,null,null,">>>>>>>",null,null,null,null,null,null,">>>>>>>>",null,null,null,null,null,null,">>>>>>>",null,null,null,null,null,null,">>>>>>>>",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,">>>>>>>>",null,null,null,null,null,">>>>>>>"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,">>>>>>>",null,null,null,null,null,null,null,">>>>>>>"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TAPERING POLE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"|","LOAD 1",null,null,null,null,null,"|","LOAD 2",null,null,null,null,null,"|","LOAD 3",null,null,null,null,null,"|","LOAD 4",null,null,null,null,null,"|","LOAD 5",null,null,null,null,null,"|","LOAD 6",null,null,null,null,null,"|","LOAD 7",null,null,null,null,null,"|","LOAD 8",null,null,null,null,null,"|","DEAD LOAD"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X","ro","A","I","|","moment arm","d_P","angle_P","d_M","angle_M",null,"|","moment arm","d_P","angle_P","d_M","angle_M",null,"|","moment arm","d_P","angle_P","d_M","angle_M",null,"|","moment arm","d_P","angle_P","d_M","angle_M",null,"|","moment arm","d_P","angle_P","d_M","angle_M",null,"|","moment arm","d_P","angle_P","d_M","angle_M",null,"|","moment arm","d_P","angle_P","d_M","angle_M",null,"|","moment arm","d_P","angle_P","d_M","angle_M",null,"|","wic","di","theta","A*wic*y","A*wic","P","angle_P","deflect_P","Mi","angle_M","d_M","sum angles","sum deflect","jt deflect"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"mm","mm","mm^2","mm^4","|","mm","mm","rad","mm","rad",null,"|","mm","mm","rad","mm","rad",null,"|","mm","mm","rad","mm","rad",null,"|","mm","mm","rad","mm","rad",null,"|","mm","mm","rad","mm","rad",null,"|","mm","mm","rad","mm","rad",null,"|","mm","mm","rad","mm","rad",null,"|","mm","mm","rad","mm","rad",null,"|","N","mm","rad*mm",null,null,"N","rad","mm","Nmm","rad","mm","rad","mm","mm"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"|",null,null,null,null,null,null,"|",null,null,null,null,null,null,"|",null,null,null,null,null,null,"|",null,null,null,null,null,null,"|",null,null,null,null,null,null,"|",null,null,null,null,null,null,"|",null,null,null,null,null,null,"|",null,null,null,null,null,null,"|",null,null,null,null,null,null,null,null,{"$f":"$C$19/20*(DR100+3*DR101+5*DR102+7*DR103+9*DR104+11*DR105+13*DR106+15*DR107+17*DR108+19*DR109)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C19/20","v":0},{"$f":"($C$16-($C$16-$C$17)/$C$19*BI100)-($C$18/2)","v":{"$error":"#N/A"}},{"$f":"IF($C$20=8,6.63*$BJ100*$C$18,6.43*$BJ100*$C$18)","v":{"$error":"#N/A"}},{"$f":"IF($C$20=8,3.5*$BJ100^3*$C$18,3.29*$BJ100^3*$C$18)","v":{"$error":"#N/A"}},"|",{"$f":"$C$31-$C$19/10","v":0},{"$f":"IF(BN100>=0,$C$30*($C$19/10)^3/(3*$C$10*BL100),IF(BN100>(-$C$19/10),$C$30*($C$31-$C$19/10)^3/(3*$C$10*BL100)+$C$30*($C$31-$C$19/10)^2/(2*$C$10*BL100)*ABS($C$31-$C$19/10),0))","v":{"$error":"#N/A"}},{"$f":"IF(BN100>=0,$C$30*($C$19/10)^2/(2*$C$10*BL100),IF(BN100>(-$C$19/10),$C$30*($C$31-$C$19/10)^2/(2*$C$10*BL100),0))","v":{"$error":"#N/A"}},{"$f":"IF(BN100<=0,0,$C$30*($C$31-$C$19/10)*($C$19/10)^2/(2*$C$10*BL100))","v":0},{"$f":"IF(BN100<=0,0,$C$30*($C$31-$C$19/10)*$C$19/10/($C$10*BL100))","v":0},"D_P","|",{"$f":"$C$33-$C$19/10","v":0},{"$f":"IF(BU100>=0,$C$32*($C$19/10)^3/(3*$C$10*BL100),IF(BU100>(-$C$19/10),$C$32*($C$33-$C$19/10)^3/(3*$C$10*BL100)+$C$32*($C$33-$C$19/10)^2/(2*$C$10*BL100)*ABS($C$33-$C$19/10),0))","v":{"$error":"#N/A"}},{"$f":"IF(BU100>=0,$C$32*($C$19/10)^2/(2*$C$10*BL100),IF(BU100>(-$C$19/10),$C$32*($C$33-$C$19/10)^2/(2*$C$10*BL100),0))","v":{"$error":"#N/A"}},{"$f":"IF(BU100<=0,0,$C$32*($C$33-$C$19/10)*($C$19/10)^2/(2*$C$10*BL100))","v":0},{"$f":"IF(BU100<=0,0,$C$32*($C$33-$C$19/10)*$C$19/10/($C$10*BL100))","v":0},"D_P","|",{"$f":"$C$35-$C$19/10","v":0},{"$f":"IF(CB100>=0,$C$34*($C$19/10)^3/(3*$C$10*BL100),IF(CB100>(-$C$19/10),$C$34*($C$35-$C$19/10)^3/(3*$C$10*BL100)+$C$34*($C$35-$C$19/10)^2/(2*$C$10*BL100)*ABS($C$35-$C$19/10),0))","v":{"$error":"#N/A"}},{"$f":"IF(CB100>=0,$C$34*($C$19/10)^2/(2*$C$10*BL100),IF(CB100>(-$C$19/10),$C$34*($C$35-$C$19/10)^2/(2*$C$10*BL100),0))","v":{"$error":"#N/A"}},{"$f":"IF(CB100<=0,0,$C$34*($C$35-$C$19/10)*($C$19/10)^2/(2*$C$10*BL100))","v":0},{"$f":"IF(CB100<=0,0,$C$34*($C$35-$C$19/10)*$C$19/10/($C$10*BL100))","v":0},"D_P","|",{"$f":"$C$37-$C$19/10","v":0},{"$f":"IF(CI100>=0,$C$36*($C$19/10)^3/(3*$C$10*BL100),IF(CI100>(-$C$19/10),$C$36*($C$37-$C$19/10)^3/(3*$C$10*BL100)+$C$36*($C$37-$C$19/10)^2/(2*$C$10*BL100)*ABS($C$37-$C$19/10),0))","v":{"$error":"#N/A"}},{"$f":"IF(CI100>=0,$C$36*($C$19/10)^2/(2*$C$10*BL100),IF(CI100>(-$C$19/10),$C$36*($C$37-$C$19/10)^2/(2*$C$10*BL100),0))","v":{"$error":"#N/A"}},{"$f":"IF(CI100<=0,0,$C$36*($C$37-$C$19/10)*($C$19/10)^2/(2*$C$10*BL100))","v":0},{"$f":"IF(CI100<=0,0,$C$36*($C$37-$C$19/10)*$C$19/10/($C$10*BL100))","v":0},"D_P","|",{"$f":"$C$39-$C$19/10","v":0},{"$f":"IF(CP100>=0,$C$38*($C$19/10)^3/(3*$C$10*BL100),IF(CP100>(-$C$19/10),$C$38*($C$39-$C$19/10)^3/(3*$C$10*BL100)+$C$38*($C$39-$C$19/10)^2/(2*$C$10*BL100)*ABS($C$39-$C$19/10),0))","v":{"$error":"#N/A"}},{"$f":"IF(CP100>=0,$C$38*($C$19/10)^2/(2*$C$10*BL100),IF(CP100>(-$C$19/10),$C$38*($C$39-$C$19/10)^2/(2*$C$10*BL100),0))","v":{"$error":"#N/A"}},{"$f":"IF(CP100<=0,0,$C$38*($C$39-$C$19/10)*($C$19/10)^2/(2*$C$10*BL100))","v":0},{"$f":"IF(CP100<=0,0,$C$38*($C$39-$C$19/10)*$C$19/10/($C$10*BL100))","v":0},"D_P","|",{"$f":"$C$41-$C$19/10","v":0},{"$f":"IF(CW100>=0,$C$40*($C$19/10)^3/(3*$C$10*$BL100),IF(CW100>(-$C$19/10),$C$40*($C$41-$C$19/10)^3/(3*$C$10*$BL100)+$C$40*($C$41-$C$19/10)^2/(2*$C$10*$BL100)*ABS($C$41-$C$19/10),0))","v":{"$error":"#N/A"}},{"$f":"IF(CW100>=0,$C$40*($C$19/10)^2/(2*$C$10*$BL100),IF(CW100>(-$C$19/10),$C$40*($C$41-$C$19/10)^2/(2*$C$10*$BL100),0))","v":{"$error":"#N/A"}},{"$f":"IF(CW100<=0,0,$C$40*($C$41-$C$19/10)*($C$19/10)^2/(2*$C$10*$BL100))","v":0},{"$f":"IF(CW100<=0,0,$C$40*($C$41-$C$19/10)*$C$19/10/($C$10*$BL100))","v":0},"D_P","|",{"$f":"$C$43-$C$19/10","v":0},{"$f":"IF(DD100>=0,$C$42*($C$19/10)^3/(3*$C$10*$BL100),IF(DD100>(-$C$19/10),$C$42*($C$43-$C$19/10)^3/(3*$C$10*$BL100)+$C$42*($C$43-$C$19/10)^2/(2*$C$10*$BL100)*ABS($C$43-$C$19/10),0))","v":{"$error":"#N/A"}},{"$f":"IF(DD100>=0,$C$42*($C$19/10)^2/(2*$C$10*$BL100),IF(DD100>(-$C$19/10),$C$42*($C$43-$C$19/10)^2/(2*$C$10*$BL100),0))","v":{"$error":"#N/A"}},{"$f":"IF(DD100<=0,0,$C$42*($C$43-$C$19/10)*($C$19/10)^2/(2*$C$10*$BL100))","v":0},{"$f":"IF(DD100<=0,0,$C$42*($C$43-$C$19/10)*$C$19/10/($C$10*$BL100))","v":0},"D_P","|",{"$f":"$C$45-$C$19/10","v":0},{"$f":"IF(DK100>=0,$C$44*($C$19/10)^3/(3*$C$10*$BL100),IF(DK100>(-$C$19/10),$C$44*($C$45-$C$19/10)^3/(3*$C$10*$BL100)+$C$44*($C$45-$C$19/10)^2/(2*$C$10*$BL100)*ABS($C$45-$C$19/10),0))","v":{"$error":"#N/A"}},{"$f":"IF(DK100>=0,$C$44*($C$19/10)^2/(2*$C$10*$BL100),IF(DK100>(-$C$19/10),$C$44*($C$45-$C$19/10)^2/(2*$C$10*$BL100),0))","v":{"$error":"#N/A"}},{"$f":"IF(DK100<=0,0,$C$44*($C$45-$C$19/10)*($C$19/10)^2/(2*$C$10*$BL100))","v":0},{"$f":"IF(DK100<=0,0,$C$44*($C$45-$C$19/10)*$C$19/10/($C$10*$BL100))","v":0},"D_P","|",{"$f":"LC/10*BK100*U","v":{"$error":"#N/A"}},{"$f":"DR100*(LC/10)^3/(8*E*$BL100)","v":{"$error":"#N/A"}},{"$f":"DR100*($C$19/10)^2/(6*$C$10*BL100)","v":{"$error":"#N/A"}},{"$f":"BK100*DR100*C19/20","v":{"$error":"#N/A"}},{"$f":"BK100*DR100","v":{"$error":"#N/A"}},{"$f":"SUM(DR101:DR109)","v":{"$error":"#N/A"}},{"$f":"DW100*(LC/10)^2/(2*E*BL100)","v":{"$error":"#N/A"}},{"$f":"DW100*(LC/10)^3/(3*E*BL100)","v":{"$error":"#N/A"}},{"$f":"$C$19/20*(DR101+3*DR102+5*DR103+7*DR104+9*DR105+11*DR106+13*DR107+15*DR108+17*DR109)","v":{"$error":"#N/A"}},{"$f":"$DZ100*(LC/10)/(E*$BL100)","v":{"$error":"#N/A"}},{"$f":"$DZ100*(LC/10)^2/(2*E*$BL100)","v":{"$error":"#N/A"}},{"$f":"$DT100+$DX100+$EA100","v":{"$error":"#N/A"}},{"$f":"DS100+DY100+EB100","v":{"$error":"#N/A"}},{"$f":"SUM(ED100)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"3*C19/20","v":0},{"$f":"($C$16-($C$16-$C$17)/$C$19*BI101)-($C$18/2)","v":{"$error":"#N/A"}},{"$f":"IF($C$20=8,6.63*$BJ101*$C$18,6.43*$BJ101*$C$18)","v":{"$error":"#N/A"}},{"$f":"IF($C$20=8,3.5*$BJ101^3*$C$18,3.29*$BJ101^3*$C$18)","v":{"$error":"#N/A"}},"|",{"$f":"$C$31-2*$C$19/10","v":0},{"$f":"IF(BN101>=0,$C$30*($C$19/10)^3/(3*$C$10*BL101),IF(BN101>(-$C$19/10),$C$30*($C$31-2*$C$19/10)^3/(3*$C$10*BL101)+$C$30*($C$31-2*$C$19/10)^2/(2*$C$10*BL101)*ABS($C$31-2*$C$19/10),0))","v":{"$error":"#N/A"}},{"$f":"IF(BN101>=0,$C$30*($C$19/10)^2/(2*$C$10*BL101),IF(BN101>(-$C$19/10),$C$30*($C$31-2*$C$19/10)^2/(2*$C$10*BL101),0))","v":{"$error":"#N/A"}},{"$f":"IF(BN101<=0,0,$C$30*($C$31-2*$C$19/10)*($C$19/10)^2/(2*$C$10*BL101))","v":0},{"$f":"IF(BN101<=0,0,$C$30*($C$31-2*$C$19/10)*$C$19/10/($C$10*BL101))","v":0},{"$f":"SUM(BO100:BO109)+$C$19/10*(9*BP100+8*BP101+7*BP102+6*BP103+5*BP104+4*BP105+3*BP106+2*BP107+BP108)","v":{"$error":"#N/A"}},"|",{"$f":"$C$33-2*$C$19/10","v":0},{"$f":"IF(BU101>=0,$C$32*($C$19/10)^3/(3*$C$10*BL101),IF(BU101>(-$C$19/10),$C$32*($C$33-2*$C$19/10)^3/(3*$C$10*BL101)+$C$32*($C$33-2*$C$19/10)^2/(2*$C$10*BL101)*ABS($C$33-2*$C$19/10),0))","v":{"$error":"#N/A"}},{"$f":"IF(BU101>=0,$C$32*($C$19/10)^2/(2*$C$10*BL101),IF(BU101>(-$C$19/10),$C$32*($C$33-2*$C$19/10)^2/(2*$C$10*BL101),0))","v":{"$error":"#N/A"}},{"$f":"IF(BU101<=0,0,$C$32*($C$33-2*$C$19/10)*($C$19/10)^2/(2*$C$10*BL101))","v":0},{"$f":"IF(BU101<=0,0,$C$32*($C$33-2*$C$19/10)*$C$19/10/($C$10*BL101))","v":0},{"$f":"SUM(BV100:BV109)+$C$19/10*(9*BW100+8*BW101+7*BW102+6*BW103+5*BW104+4*BW105+3*BW106+2*BW107+BW108)","v":{"$error":"#N/A"}},"|",{"$f":"$C$35-2*$C$19/10","v":0},{"$f":"IF(CB101>=0,$C$34*($C$19/10)^3/(3*$C$10*BL101),IF(CB101>(-$C$19/10),$C$34*($C$35-2*$C$19/10)^3/(3*$C$10*BL101)+$C$34*($C$35-2*$C$19/10)^2/(2*$C$10*BL101)*ABS($C$35-2*$C$19/10),0))","v":{"$error":"#N/A"}},{"$f":"IF(CB101>=0,$C$34*($C$19/10)^2/(2*$C$10*BL101),IF(CB101>(-$C$19/10),$C$34*($C$35-2*$C$19/10)^2/(2*$C$10*BL101),0))","v":{"$error":"#N/A"}},{"$f":"IF(CB101<=0,0,$C$34*($C$35-2*$C$19/10)*($C$19/10)^2/(2*$C$10*BL101))","v":0},{"$f":"IF(CB101<=0,0,$C$34*($C$35-2*$C$19/10)*$C$19/10/($C$10*BL101))","v":0},{"$f":"SUM(CC100:CC109)+$C$19/10*(9*CD100+8*CD101+7*CD102+6*CD103+5*CD104+4*CD105+3*CD106+2*CD107+CD108)","v":{"$error":"#N/A"}},"|",{"$f":"$C$37-2*$C$19/10","v":0},{"$f":"IF(CI101>=0,$C$36*($C$19/10)^3/(3*$C$10*BL101),IF(CI101>(-$C$19/10),$C$36*($C$37-2*$C$19/10)^3/(3*$C$10*BL101)+$C$36*($C$37-2*$C$19/10)^2/(2*$C$10*BL101)*ABS($C$37-2*$C$19/10),0))","v":{"$error":"#N/A"}},{"$f":"IF(CI101>=0,$C$36*($C$19/10)^2/(2*$C$10*BL101),IF(CI101>(-$C$19/10),$C$36*($C$37-2*$C$19/10)^2/(2*$C$10*BL101),0))","v":{"$error":"#N/A"}},{"$f":"IF(CI101<=0,0,$C$36*($C$37-2*$C$19/10)*($C$19/10)^2/(2*$C$10*BL101))","v":0},{"$f":"IF(CI101<=0,0,$C$36*($C$37-2*$C$19/10)*$C$19/10/($C$10*BL101))","v":0},{"$f":"SUM(CJ100:CJ109)+$C$19/10*(9*CK100+8*CK101+7*CK102+6*CK103+5*CK104+4*CK105+3*CK106+2*CK107+CK108)","v":{"$error":"#N/A"}},"|",{"$f":"$C$39-2*$C$19/10","v":0},{"$f":"IF(CP101>=0,$C$38*($C$19/10)^3/(3*$C$10*BL101),IF(CP101>(-$C$19/10),$C$38*($C$39-2*$C$19/10)^3/(3*$C$10*BL101)+$C$38*($C$39-2*$C$19/10)^2/(2*$C$10*BL101)*ABS($C$39-2*$C$19/10),0))","v":{"$error":"#N/A"}},{"$f":"IF(CP101>=0,$C$38*($C$19/10)^2/(2*$C$10*BL101),IF(CP101>(-$C$19/10),$C$38*($C$39-2*$C$19/10)^2/(2*$C$10*BL101),0))","v":{"$error":"#N/A"}},{"$f":"IF(CP101<=0,0,$C$38*($C$39-2*$C$19/10)*($C$19/10)^2/(2*$C$10*BL101))","v":0},{"$f":"IF(CP101<=0,0,$C$38*($C$39-2*$C$19/10)*$C$19/10/($C$10*BL101))","v":0},{"$f":"SUM(CQ100:CQ109)+$C$19/10*(9*CR100+8*CR101+7*CR102+6*CR103+5*CR104+4*CR105+3*CR106+2*CR107+CR108)","v":{"$error":"#N/A"}},"|",{"$f":"$C$41-2*$C$19/10","v":0},{"$f":"IF(CW101>=0,$C$40*($C$19/10)^3/(3*$C$10*$BL101),IF(CW101>(-$C$19/10),$C$40*($C$41-2*$C$19/10)^3/(3*$C$10*$BL101)+$C$40*($C$41-2*$C$19/10)^2/(2*$C$10*$BL101)*ABS($C$41-2*$C$19/10),0))","v":{"$error":"#N/A"}},{"$f":"IF(CW101>=0,$C$40*($C$19/10)^2/(2*$C$10*$BL101),IF(CW101>(-$C$19/10),$C$40*($C$41-2*$C$19/10)^2/(2*$C$10*$BL101),0))","v":{"$error":"#N/A"}},{"$f":"IF(CW101<=0,0,$C$40*($C$41-2*$C$19/10)*($C$19/10)^2/(2*$C$10*$BL101))","v":0},{"$f":"IF(CW101<=0,0,$C$40*($C$41-2*$C$19/10)*$C$19/10/($C$10*$BL101))","v":0},{"$f":"SUM(CX100:CX109)+$C$19/10*(9*CY100+8*CY101+7*CY102+6*CY103+5*CY104+4*CY105+3*CY106+2*CY107+CY108)","v":{"$error":"#N/A"}},"|",{"$f":"$C$43-2*$C$19/10","v":0},{"$f":"IF(DD101>=0,$C$42*($C$19/10)^3/(3*$C$10*$BL101),IF(DD101>(-$C$19/10),$C$42*($C$43-2*$C$19/10)^3/(3*$C$10*$BL101)+$C$42*($C$43-2*$C$19/10)^2/(2*$C$10*$BL101)*ABS($C$43-2*$C$19/10),0))","v":{"$error":"#N/A"}},{"$f":"IF(DD101>=0,$C$42*($C$19/10)^2/(2*$C$10*$BL101),IF(DD101>(-$C$19/10),$C$42*($C$43-2*$C$19/10)^2/(2*$C$10*$BL101),0))","v":{"$error":"#N/A"}},{"$f":"IF(DD101<=0,0,$C$42*($C$43-2*$C$19/10)*($C$19/10)^2/(2*$C$10*$BL101))","v":0},{"$f":"IF(DD101<=0,0,$C$42*($C$43-2*$C$19/10)*$C$19/10/($C$10*$BL101))","v":0},{"$f":"SUM(DE100:DE109)+$C$19/10*(9*DF100+8*DF101+7*DF102+6*DF103+5*DF104+4*DF105+3*DF106+2*DF107+DF108)","v":{"$error":"#N/A"}},"|",{"$f":"$C$45-2*$C$19/10","v":0},{"$f":"IF(DK101>=0,$C$44*($C$19/10)^3/(3*$C$10*$BL101),IF(DK101>(-$C$19/10),$C$44*($C$45-2*$C$19/10)^3/(3*$C$10*$BL101)+$C$44*($C$45-2*$C$19/10)^2/(2*$C$10*$BL101)*ABS($C$45-2*$C$19/10),0))","v":{"$error":"#N/A"}},{"$f":"IF(DK101>=0,$C$44*($C$19/10)^2/(2*$C$10*$BL101),IF(DK101>(-$C$19/10),$C$44*($C$45-2*$C$19/10)^2/(2*$C$10*$BL101),0))","v":{"$error":"#N/A"}},{"$f":"IF(DK101<=0,0,$C$44*($C$45-2*$C$19/10)*($C$19/10)^2/(2*$C$10*$BL101))","v":0},{"$f":"IF(DK101<=0,0,$C$44*($C$45-2*$C$19/10)*$C$19/10/($C$10*$BL101))","v":0},{"$f":"SUM(DL100:DL109)+$C$19/10*(9*DM100+8*DM101+7*DM102+6*DM103+5*DM104+4*DM105+3*DM106+2*DM107+DM108)","v":{"$error":"#N/A"}},"|",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"BK101*DR101*3*LC/20","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"SUM(DR102:DR$109)","v":{"$error":"#N/A"}},{"$f":"DW101*(LC/10)^2/(2*E*BL101)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"$C$19/20*(DR102+3*DR103+5*DR104+7*DR105+9*DR106+11*DR107+13*DR108+15*DR109)","v":{"$error":"#N/A"}},{"$f":"DZ101*(LC/10)/(E*BL101)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"SUM(ED$100:ED101)+$C$19/10*(EC100)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"5*C19/20","v":0},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"|",{"$f":"$C$31-3*$C$19/10","v":0},{"$f":"IF(BN102>=0,$C$30*($C$19/10)^3/(3*$C$10*BL102),IF(BN102>(-$C$19/10),$C$30*($C$31-3*$C$19/10)^3/(3*$C$10*BL102)+$C$30*($C$31-3*$C$19/10)^2/(2*$C$10*BL102)*ABS($C$31-3*$C$19/10),0))","v":{"$error":"#N/A"}},{"$f":"IF(BN102>=0,$C$30*($C$19/10)^2/(2*$C$10*BL102),IF(BN102>(-$C$19/10),$C$30*($C$31-3*$C$19/10)^2/(2*$C$10*BL102),0))","v":{"$error":"#N/A"}},{"$f":"IF(BN102<=0,0,$C$30*($C$31-3*$C$19/10)*($C$19/10)^2/(2*$C$10*BL102))","v":0},{"$f":"IF(BN102<=0,0,$C$30*($C$31-3*$C$19/10)*$C$19/10/($C$10*BL102))","v":0},null,"|",{"$f":"$C$33-3*$C$19/10","v":0},{"$f":"IF(BU102>=0,$C$32*($C$19/10)^3/(3*$C$10*BL102),IF(BU102>(-$C$19/10),$C$32*($C$33-3*$C$19/10)^3/(3*$C$10*BL102)+$C$32*($C$33-3*$C$19/10)^2/(2*$C$10*BL102)*ABS($C$33-3*$C$19/10),0))","v":{"$error":"#N/A"}},{"$f":"IF(BU102>=0,$C$32*($C$19/10)^2/(2*$C$10*BL102),IF(BU102>(-$C$19/10),$C$32*($C$33-3*$C$19/10)^2/(2*$C$10*BL102),0))","v":{"$error":"#N/A"}},{"$f":"IF(BU102<=0,0,$C$32*($C$33-3*$C$19/10)*($C$19/10)^2/(2*$C$10*BL102))","v":0},{"$f":"IF(BU102<=0,0,$C$32*($C$33-3*$C$19/10)*$C$19/10/($C$10*BL102))","v":0},null,"|",{"$f":"$C$35-3*$C$19/10","v":0},{"$f":"IF(CB102>=0,$C$34*($C$19/10)^3/(3*$C$10*BL102),IF(CB102>(-$C$19/10),$C$34*($C$35-3*$C$19/10)^3/(3*$C$10*BL102)+$C$34*($C$35-3*$C$19/10)^2/(2*$C$10*BL102)*ABS($C$35-3*$C$19/10),0))","v":{"$error":"#N/A"}},{"$f":"IF(CB102>=0,$C$34*($C$19/10)^2/(2*$C$10*BL102),IF(CB102>(-$C$19/10),$C$34*($C$35-3*$C$19/10)^2/(2*$C$10*BL102),0))","v":{"$error":"#N/A"}},{"$f":"IF(CB102<=0,0,$C$34*($C$35-3*$C$19/10)*($C$19/10)^2/(2*$C$10*BL102))","v":0},{"$f":"IF(CB102<=0,0,$C$34*($C$35-3*$C$19/10)*$C$19/10/($C$10*BL102))","v":0},null,"|",{"$f":"$C$37-3*$C$19/10","v":0},{"$f":"IF(CI102>=0,$C$36*($C$19/10)^3/(3*$C$10*BL102),IF(CI102>(-$C$19/10),$C$36*($C$37-3*$C$19/10)^3/(3*$C$10*BL102)+$C$36*($C$37-3*$C$19/10)^2/(2*$C$10*BL102)*ABS($C$37-3*$C$19/10),0))","v":{"$error":"#N/A"}},{"$f":"IF(CI102>=0,$C$36*($C$19/10)^2/(2*$C$10*BL102),IF(CI102>(-$C$19/10),$C$36*($C$37-3*$C$19/10)^2/(2*$C$10*BL102),0))","v":{"$error":"#N/A"}},{"$f":"IF(CI102<=0,0,$C$36*($C$37-3*$C$19/10)*($C$19/10)^2/(2*$C$10*BL102))","v":0},{"$f":"IF(CI102<=0,0,$C$36*($C$37-3*$C$19/10)*$C$19/10/($C$10*BL102))","v":0},null,"|",{"$f":"$C$39-3*$C$19/10","v":0},{"$f":"IF(CP102>=0,$C$38*($C$19/10)^3/(3*$C$10*BL102),IF(CP102>(-$C$19/10),$C$38*($C$39-3*$C$19/10)^3/(3*$C$10*BL102)+$C$38*($C$39-3*$C$19/10)^2/(2*$C$10*BL102)*ABS($C$39-3*$C$19/10),0))","v":{"$error":"#N/A"}},{"$f":"IF(CP102>=0,$C$38*($C$19/10)^2/(2*$C$10*BL102),IF(CP102>(-$C$19/10),$C$38*($C$39-3*$C$19/10)^2/(2*$C$10*BL102),0))","v":{"$error":"#N/A"}},{"$f":"IF(CP102<=0,0,$C$38*($C$39-3*$C$19/10)*($C$19/10)^2/(2*$C$10*BL102))","v":0},{"$f":"IF(CP102<=0,0,$C$38*($C$39-3*$C$19/10)*$C$19/10/($C$10*BL102))","v":0},null,"|",{"$f":"$C$41-3*$C$19/10","v":0},{"$f":"IF(CW102>=0,$C$40*($C$19/10)^3/(3*$C$10*$BL102),IF(CW102>(-$C$19/10),$C$40*($C$41-3*$C$19/10)^3/(3*$C$10*$BL102)+$C$40*($C$41-3*$C$19/10)^2/(2*$C$10*$BL102)*ABS($C$41-3*$C$19/10),0))","v":{"$error":"#N/A"}},{"$f":"IF(CW102>=0,$C$40*($C$19/10)^2/(2*$C$10*$BL102),IF(CW102>(-$C$19/10),$C$40*($C$41-3*$C$19/10)^2/(2*$C$10*$BL102),0))","v":{"$error":"#N/A"}},{"$f":"IF(CW102<=0,0,$C$40*($C$41-3*$C$19/10)*($C$19/10)^2/(2*$C$10*$BL102))","v":0},{"$f":"IF(CW102<=0,0,$C$40*($C$41-3*$C$19/10)*$C$19/10/($C$10*$BL102))","v":0},null,"|",{"$f":"$C$43-3*$C$19/10","v":0},{"$f":"IF(DD102>=0,$C$42*($C$19/10)^3/(3*$C$10*$BL102),IF(DD102>(-$C$19/10),$C$42*($C$43-3*$C$19/10)^3/(3*$C$10*$BL102)+$C$42*($C$43-3*$C$19/10)^2/(2*$C$10*$BL102)*ABS($C$43-3*$C$19/10),0))","v":{"$error":"#N/A"}},{"$f":"IF(DD102>=0,$C$42*($C$19/10)^2/(2*$C$10*$BL102),IF(DD102>(-$C$19/10),$C$42*($C$43-3*$C$19/10)^2/(2*$C$10*$BL102),0))","v":{"$error":"#N/A"}},{"$f":"IF(DD102<=0,0,$C$42*($C$43-3*$C$19/10)*($C$19/10)^2/(2*$C$10*$BL102))","v":0},{"$f":"IF(DD102<=0,0,$C$42*($C$43-3*$C$19/10)*$C$19/10/($C$10*$BL102))","v":0},null,"|",{"$f":"$C$45-3*$C$19/10","v":0},{"$f":"IF(DK102>=0,$C$44*($C$19/10)^3/(3*$C$10*$BL102),IF(DK102>(-$C$19/10),$C$44*($C$45-3*$C$19/10)^3/(3*$C$10*$BL102)+$C$44*($C$45-3*$C$19/10)^2/(2*$C$10*$BL102)*ABS($C$45-3*$C$19/10),0))","v":{"$error":"#N/A"}},{"$f":"IF(DK102>=0,$C$44*($C$19/10)^2/(2*$C$10*$BL102),IF(DK102>(-$C$19/10),$C$44*($C$45-3*$C$19/10)^2/(2*$C$10*$BL102),0))","v":{"$error":"#N/A"}},{"$f":"IF(DK102<=0,0,$C$44*($C$45-3*$C$19/10)*($C$19/10)^2/(2*$C$10*$BL102))","v":0},{"$f":"IF(DK102<=0,0,$C$44*($C$45-3*$C$19/10)*$C$19/10/($C$10*$BL102))","v":0},null,"|",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"BK102*DR102*5*LC/20","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"SUM(DR103:DR$109)","v":{"$error":"#N/A"}},{"$f":"DW102*(LC/10)^2/(2*E*BL102)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"$C$19/20*(DR103+3*DR104+5*DR105+7*DR106+9*DR107+11*DR108+13*DR109)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"SUM(ED$100:ED102)+$C$19/10*(EC100*2+EC101)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"7*C19/20","v":0},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"|",{"$f":"$C$31-4*$C$19/10","v":0},{"$f":"IF(BN103>=0,$C$30*($C$19/10)^3/(3*$C$10*BL103),IF(BN103>(-$C$19/10),$C$30*($C$31-4*$C$19/10)^3/(3*$C$10*BL103)+$C$30*($C$31-4*$C$19/10)^2/(2*$C$10*BL103)*ABS($C$31-4*$C$19/10),0))","v":{"$error":"#N/A"}},{"$f":"IF(BN103>=0,$C$30*($C$19/10)^2/(2*$C$10*BL103),IF(BN103>(-$C$19/10),$C$30*($C$31-4*$C$19/10)^2/(2*$C$10*BL103),0))","v":{"$error":"#N/A"}},{"$f":"IF(BN103<=0,0,$C$30*($C$31-4*$C$19/10)*($C$19/10)^2/(2*$C$10*BL103))","v":0},{"$f":"IF(BN103<=0,0,$C$30*($C$31-4*$C$19/10)*$C$19/10/($C$10*BL103))","v":0},"D_M","|",{"$f":"$C$33-4*$C$19/10","v":0},{"$f":"IF(BU103>=0,$C$32*($C$19/10)^3/(3*$C$10*BL103),IF(BU103>(-$C$19/10),$C$32*($C$33-4*$C$19/10)^3/(3*$C$10*BL103)+$C$32*($C$33-4*$C$19/10)^2/(2*$C$10*BL103)*ABS($C$33-4*$C$19/10),0))","v":{"$error":"#N/A"}},{"$f":"IF(BU103>=0,$C$32*($C$19/10)^2/(2*$C$10*BL103),IF(BU103>(-$C$19/10),$C$32*($C$33-4*$C$19/10)^2/(2*$C$10*BL103),0))","v":{"$error":"#N/A"}},{"$f":"IF(BU103<=0,0,$C$32*($C$33-4*$C$19/10)*($C$19/10)^2/(2*$C$10*BL103))","v":0},{"$f":"IF(BU103<=0,0,$C$32*($C$33-4*$C$19/10)*$C$19/10/($C$10*BL103))","v":0},"D_M","|",{"$f":"$C$35-4*$C$19/10","v":0},{"$f":"IF(CB103>=0,$C$34*($C$19/10)^3/(3*$C$10*BL103),IF(CB103>(-$C$19/10),$C$34*($C$35-4*$C$19/10)^3/(3*$C$10*BL103)+$C$34*($C$35-4*$C$19/10)^2/(2*$C$10*BL103)*ABS($C$35-4*$C$19/10),0))","v":{"$error":"#N/A"}},{"$f":"IF(CB103>=0,$C$34*($C$19/10)^2/(2*$C$10*BL103),IF(CB103>(-$C$19/10),$C$34*($C$35-4*$C$19/10)^2/(2*$C$10*BL103),0))","v":{"$error":"#N/A"}},{"$f":"IF(CB103<=0,0,$C$34*($C$35-4*$C$19/10)*($C$19/10)^2/(2*$C$10*BL103))","v":0},{"$f":"IF(CB103<=0,0,$C$34*($C$35-4*$C$19/10)*$C$19/10/($C$10*BL103))","v":0},"D_M","|",{"$f":"$C$37-4*$C$19/10","v":0},{"$f":"IF(CI103>=0,$C$36*($C$19/10)^3/(3*$C$10*BL103),IF(CI103>(-$C$19/10),$C$36*($C$37-4*$C$19/10)^3/(3*$C$10*BL103)+$C$36*($C$37-4*$C$19/10)^2/(2*$C$10*BL103)*ABS($C$37-4*$C$19/10),0))","v":{"$error":"#N/A"}},{"$f":"IF(CI103>=0,$C$36*($C$19/10)^2/(2*$C$10*BL103),IF(CI103>(-$C$19/10),$C$36*($C$37-4*$C$19/10)^2/(2*$C$10*BL103),0))","v":{"$error":"#N/A"}},{"$f":"IF(CI103<=0,0,$C$36*($C$37-4*$C$19/10)*($C$19/10)^2/(2*$C$10*BL103))","v":0},{"$f":"IF(CI103<=0,0,$C$36*($C$37-4*$C$19/10)*$C$19/10/($C$10*BL103))","v":0},"D_M","|",{"$f":"$C$39-4*$C$19/10","v":0},{"$f":"IF(CP103>=0,$C$38*($C$19/10)^3/(3*$C$10*BL103),IF(CP103>(-$C$19/10),$C$38*($C$39-4*$C$19/10)^3/(3*$C$10*BL103)+$C$38*($C$39-4*$C$19/10)^2/(2*$C$10*BL103)*ABS($C$39-4*$C$19/10),0))","v":{"$error":"#N/A"}},{"$f":"IF(CP103>=0,$C$38*($C$19/10)^2/(2*$C$10*BL103),IF(CP103>(-$C$19/10),$C$38*($C$39-4*$C$19/10)^2/(2*$C$10*BL103),0))","v":{"$error":"#N/A"}},{"$f":"IF(CP103<=0,0,$C$38*($C$39-4*$C$19/10)*($C$19/10)^2/(2*$C$10*BL103))","v":0},{"$f":"IF(CP103<=0,0,$C$38*($C$39-4*$C$19/10)*$C$19/10/($C$10*BL103))","v":0},"D_M","|",{"$f":"$C$41-4*$C$19/10","v":0},{"$f":"IF(CW103>=0,$C$40*($C$19/10)^3/(3*$C$10*$BL103),IF(CW103>(-$C$19/10),$C$40*($C$41-4*$C$19/10)^3/(3*$C$10*$BL103)+$C$40*($C$41-4*$C$19/10)^2/(2*$C$10*$BL103)*ABS($C$41-4*$C$19/10),0))","v":{"$error":"#N/A"}},{"$f":"IF(CW103>=0,$C$40*($C$19/10)^2/(2*$C$10*$BL103),IF(CW103>(-$C$19/10),$C$40*($C$41-4*$C$19/10)^2/(2*$C$10*$BL103),0))","v":{"$error":"#N/A"}},{"$f":"IF(CW103<=0,0,$C$40*($C$41-4*$C$19/10)*($C$19/10)^2/(2*$C$10*$BL103))","v":0},{"$f":"IF(CW103<=0,0,$C$40*($C$41-4*$C$19/10)*$C$19/10/($C$10*$BL103))","v":0},"D_M","|",{"$f":"$C$43-4*$C$19/10","v":0},{"$f":"IF(DD103>=0,$C$42*($C$19/10)^3/(3*$C$10*$BL103),IF(DD103>(-$C$19/10),$C$42*($C$43-4*$C$19/10)^3/(3*$C$10*$BL103)+$C$42*($C$43-4*$C$19/10)^2/(2*$C$10*$BL103)*ABS($C$43-4*$C$19/10),0))","v":{"$error":"#N/A"}},{"$f":"IF(DD103>=0,$C$42*($C$19/10)^2/(2*$C$10*$BL103),IF(DD103>(-$C$19/10),$C$42*($C$43-4*$C$19/10)^2/(2*$C$10*$BL103),0))","v":{"$error":"#N/A"}},{"$f":"IF(DD103<=0,0,$C$42*($C$43-4*$C$19/10)*($C$19/10)^2/(2*$C$10*$BL103))","v":0},{"$f":"IF(DD103<=0,0,$C$42*($C$43-4*$C$19/10)*$C$19/10/($C$10*$BL103))","v":0},"D_M","|",{"$f":"C45-4*$C$19/10","v":0},{"$f":"IF(DK103>=0,$C$44*($C$19/10)^3/(3*$C$10*$BL103),IF(DK103>(-$C$19/10),$C$44*($C$45-4*$C$19/10)^3/(3*$C$10*$BL103)+$C$44*($C$45-4*$C$19/10)^2/(2*$C$10*$BL103)*ABS($C$45-4*$C$19/10),0))","v":{"$error":"#N/A"}},{"$f":"IF(DK103>=0,$C$44*($C$19/10)^2/(2*$C$10*$BL103),IF(DK103>(-$C$19/10),$C$44*($C$45-4*$C$19/10)^2/(2*$C$10*$BL103),0))","v":{"$error":"#N/A"}},{"$f":"IF(DK103<=0,0,$C$44*($C$45-4*$C$19/10)*($C$19/10)^2/(2*$C$10*$BL103))","v":0},{"$f":"IF(DK103<=0,0,$C$44*($C$45-4*$C$19/10)*$C$19/10/($C$10*$BL103))","v":0},"D_M","|",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"BK103*DR103*7*LC/20","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"SUM(DR104:DR$109)","v":{"$error":"#N/A"}},{"$f":"DW103*(LC/10)^2/(2*E*BL103)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"$C$19/20*(DR104+3*DR105+5*DR106+7*DR107+9*DR108+11*DR109)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"SUM(ED$100:ED103)+$C$19/10*(EC100*3+EC101*2+EC102)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"9*C19/20","v":0},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"|",{"$f":"$C$31-5*$C$19/10","v":0},{"$f":"IF(BN104>=0,$C$30*($C$19/10)^3/(3*$C$10*BL104),IF(BN104>(-$C$19/10),$C$30*($C$31-5*$C$19/10)^3/(3*$C$10*BL104)+$C$30*($C$31-5*$C$19/10)^2/(2*$C$10*BL104)*ABS($C$31-5*$C$19/10),0))","v":{"$error":"#N/A"}},{"$f":"IF(BN104>=0,$C$30*($C$19/10)^2/(2*$C$10*BL104),IF(BN104>(-$C$19/10),$C$30*($C$31-5*$C$19/10)^2/(2*$C$10*BL104),0))","v":{"$error":"#N/A"}},{"$f":"IF(BN104<=0,0,$C$30*($C$31-5*$C$19/10)*($C$19/10)^2/(2*$C$10*BL104))","v":0},{"$f":"IF(BN104<=0,0,$C$30*($C$31-5*$C$19/10)*$C$19/10/($C$10*BL104))","v":0},{"$f":"SUM(BQ100:BQ109)+$C$19/10*(9*BR100+8*BR101+7*BR102+6*BR103+5*BR104+4*BR105+3*BR106+2*BR107+BR108)","v":0},"|",{"$f":"$C$33-5*$C$19/10","v":0},{"$f":"IF(BU104>=0,$C$32*($C$19/10)^3/(3*$C$10*BL104),IF(BU104>(-$C$19/10),$C$32*($C$33-5*$C$19/10)^3/(3*$C$10*BL104)+$C$32*($C$33-5*$C$19/10)^2/(2*$C$10*BL104)*ABS($C$33-5*$C$19/10),0))","v":{"$error":"#N/A"}},{"$f":"IF(BU104>=0,$C$32*($C$19/10)^2/(2*$C$10*BL104),IF(BU104>(-$C$19/10),$C$32*($C$33-5*$C$19/10)^2/(2*$C$10*BL104),0))","v":{"$error":"#N/A"}},{"$f":"IF(BU104<=0,0,$C$32*($C$33-5*$C$19/10)*($C$19/10)^2/(2*$C$10*BL104))","v":0},{"$f":"IF(BU104<=0,0,$C$32*($C$33-5*$C$19/10)*$C$19/10/($C$10*BL104))","v":0},{"$f":"SUM(BX100:BX109)+$C$19/10*(9*BY100+8*BY101+7*BY102+6*BY103+5*BY104+4*BY105+3*BY106+2*BY107+BY108)","v":0},"|",{"$f":"$C$35-5*$C$19/10","v":0},{"$f":"IF(CB104>=0,$C$34*($C$19/10)^3/(3*$C$10*BL104),IF(CB104>(-$C$19/10),$C$34*($C$35-5*$C$19/10)^3/(3*$C$10*BL104)+$C$34*($C$35-5*$C$19/10)^2/(2*$C$10*BL104)*ABS($C$35-5*$C$19/10),0))","v":{"$error":"#N/A"}},{"$f":"IF(CB104>=0,$C$34*($C$19/10)^2/(2*$C$10*BL104),IF(CB104>(-$C$19/10),$C$34*($C$35-5*$C$19/10)^2/(2*$C$10*BL104),0))","v":{"$error":"#N/A"}},{"$f":"IF(CB104<=0,0,$C$34*($C$35-5*$C$19/10)*($C$19/10)^2/(2*$C$10*BL104))","v":0},{"$f":"IF(CB104<=0,0,$C$34*($C$35-5*$C$19/10)*$C$19/10/($C$10*BL104))","v":0},{"$f":"SUM(CE100:CE109)+$C$19/10*(9*CF100+8*CF101+7*CF102+6*CF103+5*CF104+4*CF105+3*CF106+2*CF107+CF108)","v":0},"|",{"$f":"$C$37-5*$C$19/10","v":0},{"$f":"IF(CI104>=0,$C$36*($C$19/10)^3/(3*$C$10*BL104),IF(CI104>(-$C$19/10),$C$36*($C$37-5*$C$19/10)^3/(3*$C$10*BL104)+$C$36*($C$37-5*$C$19/10)^2/(2*$C$10*BL104)*ABS($C$37-5*$C$19/10),0))","v":{"$error":"#N/A"}},{"$f":"IF(CI104>=0,$C$36*($C$19/10)^2/(2*$C$10*BL104),IF(CI104>(-$C$19/10),$C$36*($C$37-5*$C$19/10)^2/(2*$C$10*BL104),0))","v":{"$error":"#N/A"}},{"$f":"IF(CI104<=0,0,$C$36*($C$37-5*$C$19/10)*($C$19/10)^2/(2*$C$10*BL104))","v":0},{"$f":"IF(CI104<=0,0,$C$36*($C$37-5*$C$19/10)*$C$19/10/($C$10*BL104))","v":0},{"$f":"SUM(CL100:CL109)+$C$19/10*(9*CM100+8*CM101+7*CM102+6*CM103+5*CM104+4*CM105+3*CM106+2*CM107+CM108)","v":0},"|",{"$f":"$C$39-5*$C$19/10","v":0},{"$f":"IF(CP104>=0,$C$38*($C$19/10)^3/(3*$C$10*BL104),IF(CP104>(-$C$19/10),$C$38*($C$39-5*$C$19/10)^3/(3*$C$10*BL104)+$C$38*($C$39-5*$C$19/10)^2/(2*$C$10*BL104)*ABS($C$39-5*$C$19/10),0))","v":{"$error":"#N/A"}},{"$f":"IF(CP104>=0,$C$38*($C$19/10)^2/(2*$C$10*BL104),IF(CP104>(-$C$19/10),$C$38*($C$39-5*$C$19/10)^2/(2*$C$10*BL104),0))","v":{"$error":"#N/A"}},{"$f":"IF(CP104<=0,0,$C$38*($C$39-5*$C$19/10)*($C$19/10)^2/(2*$C$10*BL104))","v":0},{"$f":"IF(CP104<=0,0,$C$38*($C$39-5*$C$19/10)*$C$19/10/($C$10*BL104))","v":0},{"$f":"SUM(CS100:CS109)+$C$19/10*(9*CT100+8*CT101+7*CT102+6*CT103+5*CT104+4*CT105+3*CT106+2*CT107+CT108)","v":0},"|",{"$f":"$C$41-5*$C$19/10","v":0},{"$f":"IF(CW104>=0,$C$40*($C$19/10)^3/(3*$C$10*$BL104),IF(CW104>(-$C$19/10),$C$40*($C$41-5*$C$19/10)^3/(3*$C$10*$BL104)+$C$40*($C$41-5*$C$19/10)^2/(2*$C$10*$BL104)*ABS($C$41-5*$C$19/10),0))","v":{"$error":"#N/A"}},{"$f":"IF(CW104>=0,$C$40*($C$19/10)^2/(2*$C$10*$BL104),IF(CW104>(-$C$19/10),$C$40*($C$41-5*$C$19/10)^2/(2*$C$10*$BL104),0))","v":{"$error":"#N/A"}},{"$f":"IF(CW104<=0,0,$C$40*($C$41-5*$C$19/10)*($C$19/10)^2/(2*$C$10*$BL104))","v":0},{"$f":"IF(CW104<=0,0,$C$40*($C$41-5*$C$19/10)*$C$19/10/($C$10*$BL104))","v":0},{"$f":"SUM(CZ100:CZ109)+$C$19/10*(9*DA100+8*DA101+7*DA102+6*DA103+5*DA104+4*DA105+3*DA106+2*DA107+DA108)","v":0},"|",{"$f":"$C$43-5*$C$19/10","v":0},{"$f":"IF(DD104>=0,$C$42*($C$19/10)^3/(3*$C$10*$BL104),IF(DD104>(-$C$19/10),$C$42*($C$43-5*$C$19/10)^3/(3*$C$10*$BL104)+$C$42*($C$43-5*$C$19/10)^2/(2*$C$10*$BL104)*ABS($C$43-5*$C$19/10),0))","v":{"$error":"#N/A"}},{"$f":"IF(DD104>=0,$C$42*($C$19/10)^2/(2*$C$10*$BL104),IF(DD104>(-$C$19/10),$C$42*($C$43-5*$C$19/10)^2/(2*$C$10*$BL104),0))","v":{"$error":"#N/A"}},{"$f":"IF(DD104<=0,0,$C$42*($C$43-5*$C$19/10)*($C$19/10)^2/(2*$C$10*$BL104))","v":0},{"$f":"IF(DD104<=0,0,$C$42*($C$43-5*$C$19/10)*$C$19/10/($C$10*$BL104))","v":0},{"$f":"SUM(DG100:DG109)+$C$19/10*(9*DH100+8*DH101+7*DH102+6*DH103+5*DH104+4*DH105+3*DH106+2*DH107+DH108)","v":0},"|",{"$f":"$C$45-5*$C$19/10","v":0},{"$f":"IF(DK104>=0,$C$44*($C$19/10)^3/(3*$C$10*$BL104),IF(DK104>(-$C$19/10),$C$44*($C$45-5*$C$19/10)^3/(3*$C$10*$BL104)+$C$44*($C$45-5*$C$19/10)^2/(2*$C$10*$BL104)*ABS($C$45-5*$C$19/10),0))","v":{"$error":"#N/A"}},{"$f":"IF(DK104>=0,$C$44*($C$19/10)^2/(2*$C$10*$BL104),IF(DK104>(-$C$19/10),$C$44*($C$45-5*$C$19/10)^2/(2*$C$10*$BL104),0))","v":{"$error":"#N/A"}},{"$f":"IF(DK104<=0,0,$C$44*($C$45-5*$C$19/10)*($C$19/10)^2/(2*$C$10*$BL104))","v":0},{"$f":"IF(DK104<=0,0,$C$44*($C$45-5*$C$19/10)*$C$19/10/($C$10*$BL104))","v":0},{"$f":"SUM(DN100:DN109)+$C$19/10*(9*DO100+8*DO101+7*DO102+6*DO103+5*DO104+4*DO105+3*DO106+2*DO107+DO108)","v":0},"|",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"BK104*DR104*9*LC/20","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"SUM(DR105:DR$109)","v":{"$error":"#N/A"}},{"$f":"(DW104*(C19/10)^2)/(2*C10*BL104)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"$C$19/20*(DR105+3*DR106+5*DR107+7*DR108+9*DR109)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"SUM(ED$100:ED104)+$C$19/10*(EC100*4+EC101*3+EC102*2+EC103)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"11*C19/20","v":0},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"|",{"$f":"$C$31-6*$C$19/10","v":0},{"$f":"IF(BN105>=0,$C$30*($C$19/10)^3/(3*$C$10*BL105),IF(BN105>(-$C$19/10),$C$30*($C$31-6*$C$19/10)^3/(3*$C$10*BL105)+$C$30*($C$31-6*$C$19/10)^2/(2*$C$10*BL105)*ABS($C$31-6*$C$19/10),0))","v":{"$error":"#N/A"}},{"$f":"IF(BN105>=0,$C$30*($C$19/10)^2/(2*$C$10*BL105),IF(BN105>(-$C$19/10),$C$30*($C$31-6*$C$19/10)^2/(2*$C$10*BL105),0))","v":{"$error":"#N/A"}},{"$f":"IF(BN105<=0,0,$C$30*($C$31-6*$C$19/10)*($C$19/10)^2/(2*$C$10*BL105))","v":0},{"$f":"IF(BN105<=0,0,$C$30*($C$31-6*$C$19/10)*$C$19/10/($C$10*BL105))","v":0},null,"|",{"$f":"$C$33-6*$C$19/10","v":0},{"$f":"IF(BU105>=0,$C$32*($C$19/10)^3/(3*$C$10*BL105),IF(BU105>(-$C$19/10),$C$32*($C$33-6*$C$19/10)^3/(3*$C$10*BL105)+$C$32*($C$33-6*$C$19/10)^2/(2*$C$10*BL105)*ABS($C$33-6*$C$19/10),0))","v":{"$error":"#N/A"}},{"$f":"IF(BU105>=0,$C$32*($C$19/10)^2/(2*$C$10*BL105),IF(BU105>(-$C$19/10),$C$32*($C$33-6*$C$19/10)^2/(2*$C$10*BL105),0))","v":{"$error":"#N/A"}},{"$f":"IF(BU105<=0,0,$C$32*($C$33-6*$C$19/10)*($C$19/10)^2/(2*$C$10*BL105))","v":0},{"$f":"IF(BU105<=0,0,$C$32*($C$33-6*$C$19/10)*$C$19/10/($C$10*BL105))","v":0},null,"|",{"$f":"$C$35-6*$C$19/10","v":0},{"$f":"IF(CB105>=0,$C$34*($C$19/10)^3/(3*$C$10*BL105),IF(CB105>(-$C$19/10),$C$34*($C$35-6*$C$19/10)^3/(3*$C$10*BL105)+$C$34*($C$35-6*$C$19/10)^2/(2*$C$10*BL105)*ABS($C$35-6*$C$19/10),0))","v":{"$error":"#N/A"}},{"$f":"IF(CB105>=0,$C$34*($C$19/10)^2/(2*$C$10*BL105),IF(CB105>(-$C$19/10),$C$34*($C$35-6*$C$19/10)^2/(2*$C$10*BL105),0))","v":{"$error":"#N/A"}},{"$f":"IF(CB105<=0,0,$C$34*($C$35-6*$C$19/10)*($C$19/10)^2/(2*$C$10*BL105))","v":0},{"$f":"IF(CB105<=0,0,$C$34*($C$35-6*$C$19/10)*$C$19/10/($C$10*BL105))","v":0},null,"|",{"$f":"$C$37-6*$C$19/10","v":0},{"$f":"IF(CI105>=0,$C$36*($C$19/10)^3/(3*$C$10*BL105),IF(CI105>(-$C$19/10),$C$36*($C$37-6*$C$19/10)^3/(3*$C$10*BL105)+$C$36*($C$37-6*$C$19/10)^2/(2*$C$10*BL105)*ABS($C$37-6*$C$19/10),0))","v":{"$error":"#N/A"}},{"$f":"IF(CI105>=0,$C$36*($C$19/10)^2/(2*$C$10*BL105),IF(CI105>(-$C$19/10),$C$36*($C$37-6*$C$19/10)^2/(2*$C$10*BL105),0))","v":{"$error":"#N/A"}},{"$f":"IF(CI105<=0,0,$C$36*($C$37-6*$C$19/10)*($C$19/10)^2/(2*$C$10*BL105))","v":0},{"$f":"IF(CI105<=0,0,$C$36*($C$37-6*$C$19/10)*$C$19/10/($C$10*BL105))","v":0},null,"|",{"$f":"$C$39-6*$C$19/10","v":0},{"$f":"IF(CP105>=0,$C$38*($C$19/10)^3/(3*$C$10*BL105),IF(CP105>(-$C$19/10),$C$38*($C$39-6*$C$19/10)^3/(3*$C$10*BL105)+$C$38*($C$39-6*$C$19/10)^2/(2*$C$10*BL105)*ABS($C$39-6*$C$19/10),0))","v":{"$error":"#N/A"}},{"$f":"IF(CP105>=0,$C$38*($C$19/10)^2/(2*$C$10*BL105),IF(CP105>(-$C$19/10),$C$38*($C$39-6*$C$19/10)^2/(2*$C$10*BL105),0))","v":{"$error":"#N/A"}},{"$f":"IF(CP105<=0,0,$C$38*($C$39-6*$C$19/10)*($C$19/10)^2/(2*$C$10*BL105))","v":0},{"$f":"IF(CP105<=0,0,$C$38*($C$39-6*$C$19/10)*$C$19/10/($C$10*BL105))","v":0},null,"|",{"$f":"$C$41-6*$C$19/10","v":0},{"$f":"IF(CW105>=0,$C$40*($C$19/10)^3/(3*$C$10*$BL105),IF(CW105>(-$C$19/10),$C$40*($C$41-6*$C$19/10)^3/(3*$C$10*$BL105)+$C$40*($C$41-6*$C$19/10)^2/(2*$C$10*$BL105)*ABS($C$41-6*$C$19/10),0))","v":{"$error":"#N/A"}},{"$f":"IF(CW105>=0,$C$40*($C$19/10)^2/(2*$C$10*$BL105),IF(CW105>(-$C$19/10),$C$40*($C$41-6*$C$19/10)^2/(2*$C$10*$BL105),0))","v":{"$error":"#N/A"}},{"$f":"IF(CW105<=0,0,$C$40*($C$41-6*$C$19/10)*($C$19/10)^2/(2*$C$10*$BL105))","v":0},{"$f":"IF(CW105<=0,0,$C$40*($C$41-6*$C$19/10)*$C$19/10/($C$10*$BL105))","v":0},null,"|",{"$f":"$C$43-6*$C$19/10","v":0},{"$f":"IF(DD105>=0,$C$42*($C$19/10)^3/(3*$C$10*$BL105),IF(DD105>(-$C$19/10),$C$42*($C$43-6*$C$19/10)^3/(3*$C$10*$BL105)+$C$42*($C$43-6*$C$19/10)^2/(2*$C$10*$BL105)*ABS($C$43-6*$C$19/10),0))","v":{"$error":"#N/A"}},{"$f":"IF(DD105>=0,$C$42*($C$19/10)^2/(2*$C$10*$BL105),IF(DD105>(-$C$19/10),$C$42*($C$43-6*$C$19/10)^2/(2*$C$10*$BL105),0))","v":{"$error":"#N/A"}},{"$f":"IF(DD105<=0,0,$C$42*($C$43-6*$C$19/10)*($C$19/10)^2/(2*$C$10*$BL105))","v":0},{"$f":"IF(DD105<=0,0,$C$42*($C$43-6*$C$19/10)*$C$19/10/($C$10*$BL105))","v":0},null,"|",{"$f":"$C$45-6*$C$19/10","v":0},{"$f":"IF(DK105>=0,$C$44*($C$19/10)^3/(3*$C$10*$BL105),IF(DK105>(-$C$19/10),$C$44*($C$45-6*$C$19/10)^3/(3*$C$10*$BL105)+$C$44*($C$45-6*$C$19/10)^2/(2*$C$10*$BL105)*ABS($C$45-6*$C$19/10),0))","v":{"$error":"#N/A"}},{"$f":"IF(DK105>=0,$C$44*($C$19/10)^2/(2*$C$10*$BL105),IF(DK105>(-$C$19/10),$C$44*($C$45-6*$C$19/10)^2/(2*$C$10*$BL105),0))","v":{"$error":"#N/A"}},{"$f":"IF(DK105<=0,0,$C$44*($C$45-6*$C$19/10)*($C$19/10)^2/(2*$C$10*$BL105))","v":0},{"$f":"IF(DK105<=0,0,$C$44*($C$45-6*$C$19/10)*$C$19/10/($C$10*$BL105))","v":0},null,"|",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"BK105*DR105*11*LC/20","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"SUM(DR106:DR$109)","v":{"$error":"#N/A"}},{"$f":"DW105*(LC/10)^2/(2*E*BL105)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"$C$19/20*(DR106+3*DR107+5*DR108+7*DR109)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"SUM(ED$100:ED105)+$C$19/10*(EC100*5+EC101*4+EC102*3+EC103*2+EC104)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"13*C19/20","v":0},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"|",{"$f":"$C$31-7*$C$19/10","v":0},{"$f":"IF(BN106>=0,$C$30*($C$19/10)^3/(3*$C$10*BL106),IF(BN106>(-$C$19/10),$C$30*($C$31-7*$C$19/10)^3/(3*$C$10*BL106)+$C$30*($C$31-7*$C$19/10)^2/(2*$C$10*BL106)*ABS($C$31-7*$C$19/10),0))","v":{"$error":"#N/A"}},{"$f":"IF(BN106>=0,$C$30*($C$19/10)^2/(2*$C$10*BL106),IF(BN106>(-$C$19/10),$C$30*($C$31-7*$C$19/10)^2/(2*$C$10*BL106),0))","v":{"$error":"#N/A"}},{"$f":"IF(BN106<=0,0,$C$30*($C$31-7*$C$19/10)*($C$19/10)^2/(2*$C$10*BL106))","v":0},{"$f":"IF(BN106<=0,0,$C$30*($C$31-7*$C$19/10)*$C$19/10/($C$10*BL106))","v":0},"D1","|",{"$f":"$C$33-7*$C$19/10","v":0},{"$f":"IF(BU106>=0,$C$32*($C$19/10)^3/(3*$C$10*BL106),IF(BU106>(-$C$19/10),$C$32*($C$33-7*$C$19/10)^3/(3*$C$10*BL106)+$C$32*($C$33-7*$C$19/10)^2/(2*$C$10*BL106)*ABS($C$33-7*$C$19/10),0))","v":{"$error":"#N/A"}},{"$f":"IF(BU106>=0,$C$32*($C$19/10)^2/(2*$C$10*BL106),IF(BU106>(-$C$19/10),$C$32*($C$33-7*$C$19/10)^2/(2*$C$10*BL106),0))","v":{"$error":"#N/A"}},{"$f":"IF(BU106<=0,0,$C$32*($C$33-7*$C$19/10)*($C$19/10)^2/(2*$C$10*BL106))","v":0},{"$f":"IF(BU106<=0,0,$C$32*($C$33-7*$C$19/10)*$C$19/10/($C$10*BL106))","v":0},"D2","|",{"$f":"$C$35-7*$C$19/10","v":0},{"$f":"IF(CB106>=0,$C$34*($C$19/10)^3/(3*$C$10*BL106),IF(CB106>(-$C$19/10),$C$34*($C$35-7*$C$19/10)^3/(3*$C$10*BL106)+$C$34*($C$35-7*$C$19/10)^2/(2*$C$10*BL106)*ABS($C$35-7*$C$19/10),0))","v":{"$error":"#N/A"}},{"$f":"IF(CB106>=0,$C$34*($C$19/10)^2/(2*$C$10*BL106),IF(CB106>(-$C$19/10),$C$34*($C$35-7*$C$19/10)^2/(2*$C$10*BL106),0))","v":{"$error":"#N/A"}},{"$f":"IF(CB106<=0,0,$C$34*($C$35-7*$C$19/10)*($C$19/10)^2/(2*$C$10*BL106))","v":0},{"$f":"IF(CB106<=0,0,$C$34*($C$35-7*$C$19/10)*$C$19/10/($C$10*BL106))","v":0},"D3","|",{"$f":"$C$37-7*$C$19/10","v":0},{"$f":"IF(CI106>=0,$C$36*($C$19/10)^3/(3*$C$10*BL106),IF(CI106>(-$C$19/10),$C$36*($C$37-7*$C$19/10)^3/(3*$C$10*BL106)+$C$36*($C$37-7*$C$19/10)^2/(2*$C$10*BL106)*ABS($C$37-7*$C$19/10),0))","v":{"$error":"#N/A"}},{"$f":"IF(CI106>=0,$C$36*($C$19/10)^2/(2*$C$10*BL106),IF(CI106>(-$C$19/10),$C$36*($C$37-7*$C$19/10)^2/(2*$C$10*BL106),0))","v":{"$error":"#N/A"}},{"$f":"IF(CI106<=0,0,$C$36*($C$37-7*$C$19/10)*($C$19/10)^2/(2*$C$10*BL106))","v":0},{"$f":"IF(CI106<=0,0,$C$36*($C$37-7*$C$19/10)*$C$19/10/($C$10*BL106))","v":0},"D4","|",{"$f":"$C$39-7*$C$19/10","v":0},{"$f":"IF(CP106>=0,$C$38*($C$19/10)^3/(3*$C$10*BL106),IF(CP106>(-$C$19/10),$C$38*($C$39-7*$C$19/10)^3/(3*$C$10*BL106)+$C$38*($C$39-7*$C$19/10)^2/(2*$C$10*BL106)*ABS($C$39-7*$C$19/10),0))","v":{"$error":"#N/A"}},{"$f":"IF(CP106>=0,$C$38*($C$19/10)^2/(2*$C$10*BL106),IF(CP106>(-$C$19/10),$C$38*($C$39-7*$C$19/10)^2/(2*$C$10*BL106),0))","v":{"$error":"#N/A"}},{"$f":"IF(CP106<=0,0,$C$38*($C$39-7*$C$19/10)*($C$19/10)^2/(2*$C$10*BL106))","v":0},{"$f":"IF(CP106<=0,0,$C$38*($C$39-7*$C$19/10)*$C$19/10/($C$10*BL106))","v":0},"D5","|",{"$f":"$C$41-7*$C$19/10","v":0},{"$f":"IF(CW106>=0,$C$40*($C$19/10)^3/(3*$C$10*$BL106),IF(CW106>(-$C$19/10),$C$40*($C$41-7*$C$19/10)^3/(3*$C$10*$BL106)+$C$40*($C$41-7*$C$19/10)^2/(2*$C$10*$BL106)*ABS($C$41-7*$C$19/10),0))","v":{"$error":"#N/A"}},{"$f":"IF(CW106>=0,$C$40*($C$19/10)^2/(2*$C$10*$BL106),IF(CW106>(-$C$19/10),$C$40*($C$41-7*$C$19/10)^2/(2*$C$10*$BL106),0))","v":{"$error":"#N/A"}},{"$f":"IF(CW106<=0,0,$C$40*($C$41-7*$C$19/10)*($C$19/10)^2/(2*$C$10*$BL106))","v":0},{"$f":"IF(CW106<=0,0,$C$40*($C$41-7*$C$19/10)*$C$19/10/($C$10*$BL106))","v":0},"D6","|",{"$f":"$C$43-7*$C$19/10","v":0},{"$f":"IF(DD106>=0,$C$42*($C$19/10)^3/(3*$C$10*$BL106),IF(DD106>(-$C$19/10),$C$42*($C$43-7*$C$19/10)^3/(3*$C$10*$BL106)+$C$42*($C$43-7*$C$19/10)^2/(2*$C$10*$BL106)*ABS($C$43-7*$C$19/10),0))","v":{"$error":"#N/A"}},{"$f":"IF(DD106>=0,$C$42*($C$19/10)^2/(2*$C$10*$BL106),IF(DD106>(-$C$19/10),$C$42*($C$43-7*$C$19/10)^2/(2*$C$10*$BL106),0))","v":{"$error":"#N/A"}},{"$f":"IF(DD106<=0,0,$C$42*($C$43-7*$C$19/10)*($C$19/10)^2/(2*$C$10*$BL106))","v":0},{"$f":"IF(DD106<=0,0,$C$42*($C$43-7*$C$19/10)*$C$19/10/($C$10*$BL106))","v":0},"D7","|",{"$f":"$C$45-7*$C$19/10","v":0},{"$f":"IF(DK106>=0,$C$44*($C$19/10)^3/(3*$C$10*$BL106),IF(DK106>(-$C$19/10),$C$44*($C$45-7*$C$19/10)^3/(3*$C$10*$BL106)+$C$44*($C$45-7*$C$19/10)^2/(2*$C$10*$BL106)*ABS($C$45-7*$C$19/10),0))","v":{"$error":"#N/A"}},{"$f":"IF(DK106>=0,$C$44*($C$19/10)^2/(2*$C$10*$BL106),IF(DK106>(-$C$19/10),$C$44*($C$45-7*$C$19/10)^2/(2*$C$10*$BL106),0))","v":{"$error":"#N/A"}},{"$f":"IF(DK106<=0,0,$C$44*($C$45-7*$C$19/10)*($C$19/10)^2/(2*$C$10*$BL106))","v":0},{"$f":"IF(DK106<=0,0,$C$44*($C$45-7*$C$19/10)*$C$19/10/($C$10*$BL106))","v":0},"D8","|",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"BK106*DR106*13*LC/20","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"SUM(DR107:DR$109)","v":{"$error":"#N/A"}},{"$f":"DW106*(LC/10)^2/(2*E*BL106)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"$C$19/20*(DR107+3*DR108+5*DR109)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"SUM(ED$100:ED106)+$C$19/10*(EC100*6+EC101*5+EC102*4+EC103*3+EC104*2+EC105)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"15*C19/20","v":0},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"|",{"$f":"$C$31-8*$C$19/10","v":0},{"$f":"IF(BN107>=0,$C$30*($C$19/10)^3/(3*$C$10*BL107),IF(BN107>(-$C$19/10),$C$30*($C$31-8*$C$19/10)^3/(3*$C$10*BL107)+$C$30*($C$31-8*$C$19/10)^2/(2*$C$10*BL107)*ABS($C$31-8*$C$19/10),0))","v":{"$error":"#N/A"}},{"$f":"IF(BN107>=0,$C$30*($C$19/10)^2/(2*$C$10*BL107),IF(BN107>(-$C$19/10),$C$30*($C$31-8*$C$19/10)^2/(2*$C$10*BL107),0))","v":{"$error":"#N/A"}},{"$f":"IF(BN107<=0,0,$C$30*($C$31-8*$C$19/10)*($C$19/10)^2/(2*$C$10*BL107))","v":0},{"$f":"IF(BN107<=0,0,$C$30*($C$31-8*$C$19/10)*$C$19/10/($C$10*BL107))","v":0},{"$f":"BS101+BS104","v":{"$error":"#N/A"}},"|",{"$f":"$C$33-8*$C$19/10","v":0},{"$f":"IF(BU107>=0,$C$32*($C$19/10)^3/(3*$C$10*BL107),IF(BU107>(-$C$19/10),$C$32*($C$33-8*$C$19/10)^3/(3*$C$10*BL107)+$C$32*($C$33-8*$C$19/10)^2/(2*$C$10*BL107)*ABS($C$33-8*$C$19/10),0))","v":{"$error":"#N/A"}},{"$f":"IF(BU107>=0,$C$32*($C$19/10)^2/(2*$C$10*BL107),IF(BU107>(-$C$19/10),$C$32*($C$33-8*$C$19/10)^2/(2*$C$10*BL107),0))","v":{"$error":"#N/A"}},{"$f":"IF(BU107<=0,0,$C$32*($C$33-8*$C$19/10)*($C$19/10)^2/(2*$C$10*BL107))","v":0},{"$f":"IF(BU107<=0,0,$C$32*($C$33-8*$C$19/10)*$C$19/10/($C$10*BL107))","v":0},{"$f":"BZ101+BZ104","v":{"$error":"#N/A"}},"|",{"$f":"$C$35-8*$C$19/10","v":0},{"$f":"IF(CB107>=0,$C$34*($C$19/10)^3/(3*$C$10*BL107),IF(CB107>(-$C$19/10),$C$34*($C$35-8*$C$19/10)^3/(3*$C$10*BL107)+$C$34*($C$35-8*$C$19/10)^2/(2*$C$10*BL107)*ABS($C$35-8*$C$19/10),0))","v":{"$error":"#N/A"}},{"$f":"IF(CB107>=0,$C$34*($C$19/10)^2/(2*$C$10*BL107),IF(CB107>(-$C$19/10),$C$34*($C$35-8*$C$19/10)^2/(2*$C$10*BL107),0))","v":{"$error":"#N/A"}},{"$f":"IF(CB107<=0,0,$C$34*($C$35-8*$C$19/10)*($C$19/10)^2/(2*$C$10*BL107))","v":0},{"$f":"IF(CB107<=0,0,$C$34*($C$35-8*$C$19/10)*$C$19/10/($C$10*BL107))","v":0},{"$f":"CG101+CG104","v":{"$error":"#N/A"}},"|",{"$f":"$C$37-8*$C$19/10","v":0},{"$f":"IF(CI107>=0,$C$36*($C$19/10)^3/(3*$C$10*BL107),IF(CI107>(-$C$19/10),$C$36*($C$37-8*$C$19/10)^3/(3*$C$10*BL107)+$C$36*($C$37-8*$C$19/10)^2/(2*$C$10*BL107)*ABS($C$37-8*$C$19/10),0))","v":{"$error":"#N/A"}},{"$f":"IF(CI107>=0,$C$36*($C$19/10)^2/(2*$C$10*BL107),IF(CI107>(-$C$19/10),$C$36*($C$37-8*$C$19/10)^2/(2*$C$10*BL107),0))","v":{"$error":"#N/A"}},{"$f":"IF(CI107<=0,0,$C$36*($C$37-8*$C$19/10)*($C$19/10)^2/(2*$C$10*BL107))","v":0},{"$f":"IF(CI107<=0,0,$C$36*($C$37-8*$C$19/10)*$C$19/10/($C$10*BL107))","v":0},{"$f":"CN101+CN104","v":{"$error":"#N/A"}},"|",{"$f":"$C$39-8*$C$19/10","v":0},{"$f":"IF(CP107>=0,$C$38*($C$19/10)^3/(3*$C$10*BL107),IF(CP107>(-$C$19/10),$C$38*($C$39-8*$C$19/10)^3/(3*$C$10*BL107)+$C$38*($C$39-8*$C$19/10)^2/(2*$C$10*BL107)*ABS($C$39-8*$C$19/10),0))","v":{"$error":"#N/A"}},{"$f":"IF(CP107>=0,$C$38*($C$19/10)^2/(2*$C$10*BL107),IF(CP107>(-$C$19/10),$C$38*($C$39-8*$C$19/10)^2/(2*$C$10*BL107),0))","v":{"$error":"#N/A"}},{"$f":"IF(CP107<=0,0,$C$38*($C$39-8*$C$19/10)*($C$19/10)^2/(2*$C$10*BL107))","v":0},{"$f":"IF(CP107<=0,0,$C$38*($C$39-8*$C$19/10)*$C$19/10/($C$10*BL107))","v":0},{"$f":"CU101+CU104","v":{"$error":"#N/A"}},"|",{"$f":"$C$41-8*$C$19/10","v":0},{"$f":"IF(CW107>=0,$C$40*($C$19/10)^3/(3*$C$10*$BL107),IF(CW107>(-$C$19/10),$C$40*($C$41-8*$C$19/10)^3/(3*$C$10*$BL107)+$C$40*($C$41-8*$C$19/10)^2/(2*$C$10*$BL107)*ABS($C$41-8*$C$19/10),0))","v":{"$error":"#N/A"}},{"$f":"IF(CW107>=0,$C$40*($C$19/10)^2/(2*$C$10*$BL107),IF(CW107>(-$C$19/10),$C$40*($C$41-8*$C$19/10)^2/(2*$C$10*$BL107),0))","v":{"$error":"#N/A"}},{"$f":"IF(CW107<=0,0,$C$40*($C$41-8*$C$19/10)*($C$19/10)^2/(2*$C$10*$BL107))","v":0},{"$f":"IF(CW107<=0,0,$C$40*($C$41-8*$C$19/10)*$C$19/10/($C$10*$BL107))","v":0},{"$f":"DB101+DB104","v":{"$error":"#N/A"}},"|",{"$f":"$C$43-8*$C$19/10","v":0},{"$f":"IF(DD107>=0,$C$42*($C$19/10)^3/(3*$C$10*$BL107),IF(DD107>(-$C$19/10),$C$42*($C$43-8*$C$19/10)^3/(3*$C$10*$BL107)+$C$42*($C$43-8*$C$19/10)^2/(2*$C$10*$BL107)*ABS($C$43-8*$C$19/10),0))","v":{"$error":"#N/A"}},{"$f":"IF(DD107>=0,$C$42*($C$19/10)^2/(2*$C$10*$BL107),IF(DD107>(-$C$19/10),$C$42*($C$43-8*$C$19/10)^2/(2*$C$10*$BL107),0))","v":{"$error":"#N/A"}},{"$f":"IF(DD107<=0,0,$C$42*($C$43-8*$C$19/10)*($C$19/10)^2/(2*$C$10*$BL107))","v":0},{"$f":"IF(DD107<=0,0,$C$42*($C$43-8*$C$19/10)*$C$19/10/($C$10*$BL107))","v":0},{"$f":"DI101+DI104","v":{"$error":"#N/A"}},"|",{"$f":"$C$45-8*$C$19/10","v":0},{"$f":"IF(DK107>=0,$C$44*($C$19/10)^3/(3*$C$10*$BL107),IF(DK107>(-$C$19/10),$C$44*($C$45-8*$C$19/10)^3/(3*$C$10*$BL107)+$C$44*($C$45-8*$C$19/10)^2/(2*$C$10*$BL107)*ABS($C$45-8*$C$19/10),0))","v":{"$error":"#N/A"}},{"$f":"IF(DK107>=0,$C$44*($C$19/10)^2/(2*$C$10*$BL107),IF(DK107>(-$C$19/10),$C$44*($C$45-8*$C$19/10)^2/(2*$C$10*$BL107),0))","v":{"$error":"#N/A"}},{"$f":"IF(DK107<=0,0,$C$44*($C$45-8*$C$19/10)*($C$19/10)^2/(2*$C$10*$BL107))","v":0},{"$f":"IF(DK107<=0,0,$C$44*($C$45-8*$C$19/10)*$C$19/10/($C$10*$BL107))","v":0},{"$f":"DP101+DP104","v":{"$error":"#N/A"}},"|",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"BK107*DR107*15*LC/20","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"SUM(DR108:DR$109)","v":{"$error":"#N/A"}},{"$f":"DW107*(LC/10)^2/(2*E*BL107)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"$C$19/20*(DR108+3*DR109)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"SUM(ED$100:ED107)+$C$19/10*(EC100*7+EC101*6+EC102*5+EC103*4+EC104*3+EC105*2+EC106)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"17*C19/20","v":0},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"|",{"$f":"$C$31-9*$C$19/10","v":0},{"$f":"IF(BN108>=0,$C$30*($C$19/10)^3/(3*$C$10*BL108),IF(BN108>(-$C$19/10),$C$30*($C$31-9*$C$19/10)^3/(3*$C$10*BL108)+$C$30*($C$31-9*$C$19/10)^2/(2*$C$10*BL108)*ABS($C$31-9*$C$19/10),0))","v":{"$error":"#N/A"}},{"$f":"IF(BN108>=0,$C$30*($C$19/10)^2/(2*$C$10*BL108),IF(BN108>(-$C$19/10),$C$30*($C$31-9*$C$19/10)^2/(2*$C$10*BL108),0))","v":{"$error":"#N/A"}},{"$f":"IF(BN108<=0,0,$C$30*($C$31-9*$C$19/10)*($C$19/10)^2/(2*$C$10*BL108))","v":0},{"$f":"IF(BN108<=0,0,$C$30*($C$31-9*$C$19/10)*$C$19/10/($C$10*BL108))","v":0},null,"|",{"$f":"$C$33-9*$C$19/10","v":0},{"$f":"IF(BU108>=0,$C$32*($C$19/10)^3/(3*$C$10*BL108),IF(BU108>(-$C$19/10),$C$32*($C$33-9*$C$19/10)^3/(3*$C$10*BL108)+$C$32*($C$33-9*$C$19/10)^2/(2*$C$10*BL108)*ABS($C$33-9*$C$19/10),0))","v":{"$error":"#N/A"}},{"$f":"IF(BU108>=0,$C$32*($C$19/10)^2/(2*$C$10*BL108),IF(BU108>(-$C$19/10),$C$32*($C$33-9*$C$19/10)^2/(2*$C$10*BL108),0))","v":{"$error":"#N/A"}},{"$f":"IF(BU108<=0,0,$C$32*($C$33-9*$C$19/10)*($C$19/10)^2/(2*$C$10*BL108))","v":0},{"$f":"IF(BU108<=0,0,$C$32*($C$33-9*$C$19/10)*$C$19/10/($C$10*BL108))","v":0},null,"|",{"$f":"$C$35-9*$C$19/10","v":0},{"$f":"IF(CB108>=0,$C$34*($C$19/10)^3/(3*$C$10*BL108),IF(CB108>(-$C$19/10),$C$34*($C$35-9*$C$19/10)^3/(3*$C$10*BL108)+$C$34*($C$35-9*$C$19/10)^2/(2*$C$10*BL108)*ABS($C$35-9*$C$19/10),0))","v":{"$error":"#N/A"}},{"$f":"IF(CB108>=0,$C$34*($C$19/10)^2/(2*$C$10*BL108),IF(CB108>(-$C$19/10),$C$34*($C$35-9*$C$19/10)^2/(2*$C$10*BL108),0))","v":{"$error":"#N/A"}},{"$f":"IF(CB108<=0,0,$C$34*($C$35-9*$C$19/10)*($C$19/10)^2/(2*$C$10*BL108))","v":0},{"$f":"IF(CB108<=0,0,$C$34*($C$35-9*$C$19/10)*$C$19/10/($C$10*BL108))","v":0},null,"|",{"$f":"$C$37-9*$C$19/10","v":0},{"$f":"IF(CI108>=0,$C$36*($C$19/10)^3/(3*$C$10*BL108),IF(CI108>(-$C$19/10),$C$36*($C$37-9*$C$19/10)^3/(3*$C$10*BL108)+$C$36*($C$37-9*$C$19/10)^2/(2*$C$10*BL108)*ABS($C$37-9*$C$19/10),0))","v":{"$error":"#N/A"}},{"$f":"IF(CI108>=0,$C$36*($C$19/10)^2/(2*$C$10*BL108),IF(CI108>(-$C$19/10),$C$36*($C$37-9*$C$19/10)^2/(2*$C$10*BL108),0))","v":{"$error":"#N/A"}},{"$f":"IF(CI108<=0,0,$C$36*($C$37-9*$C$19/10)*($C$19/10)^2/(2*$C$10*BL108))","v":0},{"$f":"IF(CI108<=0,0,$C$36*($C$37-9*$C$19/10)*$C$19/10/($C$10*BL108))","v":0},null,"|",{"$f":"$C$39-9*$C$19/10","v":0},{"$f":"IF(CP108>=0,$C$38*($C$19/10)^3/(3*$C$10*BL108),IF(CP108>(-$C$19/10),$C$38*($C$39-9*$C$19/10)^3/(3*$C$10*BL108)+$C$38*($C$39-9*$C$19/10)^2/(2*$C$10*BL108)*ABS($C$39-9*$C$19/10),0))","v":{"$error":"#N/A"}},{"$f":"IF(CP108>=0,$C$38*($C$19/10)^2/(2*$C$10*BL108),IF(CP108>(-$C$19/10),$C$38*($C$39-9*$C$19/10)^2/(2*$C$10*BL108),0))","v":{"$error":"#N/A"}},{"$f":"IF(CP108<=0,0,$C$38*($C$39-9*$C$19/10)*($C$19/10)^2/(2*$C$10*BL108))","v":0},{"$f":"IF(CP108<=0,0,$C$38*($C$39-9*$C$19/10)*$C$19/10/($C$10*BL108))","v":0},null,"|",{"$f":"$C$41-9*$C$19/10","v":0},{"$f":"IF(CW108>=0,$C$40*($C$19/10)^3/(3*$C$10*$BL108),IF(CW108>(-$C$19/10),$C$40*($C$41-9*$C$19/10)^3/(3*$C$10*$BL108)+$C$40*($C$41-9*$C$19/10)^2/(2*$C$10*$BL108)*ABS($C$41-9*$C$19/10),0))","v":{"$error":"#N/A"}},{"$f":"IF(CW108>=0,$C$40*($C$19/10)^2/(2*$C$10*$BL108),IF(CW108>(-$C$19/10),$C$40*($C$41-9*$C$19/10)^2/(2*$C$10*$BL108),0))","v":{"$error":"#N/A"}},{"$f":"IF(CW108<=0,0,$C$40*($C$41-9*$C$19/10)*($C$19/10)^2/(2*$C$10*$BL108))","v":0},{"$f":"IF(CW108<=0,0,$C$40*($C$41-9*$C$19/10)*$C$19/10/($C$10*$BL108))","v":0},null,"|",{"$f":"$C$43-9*$C$19/10","v":0},{"$f":"IF(DD108>=0,$C$42*($C$19/10)^3/(3*$C$10*$BL108),IF(DD108>(-$C$19/10),$C$42*($C$43-9*$C$19/10)^3/(3*$C$10*$BL108)+$C$42*($C$41-9*$C$19/10)^2/(2*$C$10*$BL108)*ABS($C$43-9*$C$19/10),0))","v":{"$error":"#N/A"}},{"$f":"IF(DD108>=0,$C$42*($C$19/10)^2/(2*$C$10*$BL108),IF(DD108>(-$C$19/10),$C$42*($C$43-9*$C$19/10)^2/(2*$C$10*$BL108),0))","v":{"$error":"#N/A"}},{"$f":"IF(DD108<=0,0,$C$42*($C$43-9*$C$19/10)*($C$19/10)^2/(2*$C$10*$BL108))","v":0},{"$f":"IF(DD108<=0,0,$C$42*($C$43-9*$C$19/10)*$C$19/10/($C$10*$BL108))","v":0},null,"|",{"$f":"$C$45-9*$C$19/10","v":0},{"$f":"IF(DK108>=0,$C$44*($C$19/10)^3/(3*$C$10*$BL108),IF(DK108>(-$C$19/10),$C$44*($C$45-9*$C$19/10)^3/(3*$C$10*$BL108)+$C$44*($C$45-9*$C$19/10)^2/(2*$C$10*$BL108)*ABS($C$45-9*$C$19/10),0))","v":{"$error":"#N/A"}},{"$f":"IF(DK108>=0,$C$44*($C$19/10)^2/(2*$C$10*$BL108),IF(DK108>(-$C$19/10),$C$44*($C$45-9*$C$19/10)^2/(2*$C$10*$BL108),0))","v":{"$error":"#N/A"}},{"$f":"IF(DK108<=0,0,$C$44*($C$45-9*$C$19/10)*($C$19/10)^2/(2*$C$10*$BL108))","v":0},{"$f":"IF(DK108<=0,0,$C$44*($C$45-9*$C$19/10)*$C$19/10/($C$10*$BL108))","v":0},null,"|",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"BK108*DR108*17*LC/20","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"SUM(DR$109)","v":{"$error":"#N/A"}},{"$f":"DW108*(LC/10)^2/(2*E*BL108)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"$C$19/20*(DR109)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"SUM(ED$100:ED108)+$C$19/10*(EC100*8+EC101*7+EC102*6+EC103*5+EC104*4+EC105*3+EC106*2+EC107)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"19*C19/20","v":0},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"|",{"$f":"$C$31-10*$C$19/10","v":0},{"$f":"IF(BN109>=0,$C$30*($C$19/10)^3/(3*$C$10*BL109),IF(BN109>(-$C$19/10),$C$30*($C$31-10*$C$19/10)^3/(3*$C$10*BL109)+$C$30*($C$31-10*$C$19/10)^2/(2*$C$10*BL109)*ABS($C$31-10*$C$19/10),0))","v":{"$error":"#N/A"}},{"$f":"IF(BN109>=0,$C$30*($C$19/10)^2/(2*$C$10*BL109),IF(BN109>(-$C$19/10),$C$30*($C$31-10*$C$19/10)^2/(2*$C$10*BL109),0))","v":{"$error":"#N/A"}},{"$f":"IF(BN109<=0,0,$C$30*($C$31-10*$C$19/10)*($C$19/10)^2/(2*$C$10*BL109))","v":0},{"$f":"IF(BN109<=0,0,$C$30*($C$31-10*$C$19/10)*$C$19/10/($C$10*BL109))","v":0},null,"|",{"$f":"$C$33-10*$C$19/10","v":0},{"$f":"IF(BU109>=0,$C$32*($C$19/10)^3/(3*$C$10*BL109),IF(BU109>(-$C$19/10),$C$32*($C$33-10*$C$19/10)^3/(3*$C$10*BL109)+$C$32*($C$33-10*$C$19/10)^2/(2*$C$10*BL109)*ABS($C$33-10*$C$19/10),0))","v":{"$error":"#N/A"}},{"$f":"IF(BU109>=0,$C$32*($C$19/10)^2/(2*$C$10*BL109),IF(BU109>(-$C$19/10),$C$32*($C$33-10*$C$19/10)^2/(2*$C$10*BL109),0))","v":{"$error":"#N/A"}},{"$f":"IF(BU109<=0,0,$C$32*($C$33-10*$C$19/10)*($C$19/10)^2/(2*$C$10*BL109))","v":0},{"$f":"IF(BU109<=0,0,$C$32*($C$33-10*$C$19/10)*$C$19/10/($C$10*BL109))","v":0},null,"|",{"$f":"$C$35-10*$C$19/10","v":0},{"$f":"IF(CB109>=0,$C$34*($C$19/10)^3/(3*$C$10*BL109),IF(CB109>(-$C$19/10),$C$34*($C$35-10*$C$19/10)^3/(3*$C$10*BL109)+$C$34*($C$35-10*$C$19/10)^2/(2*$C$10*BL109)*ABS($C$35-10*$C$19/10),0))","v":{"$error":"#N/A"}},{"$f":"IF(CB109>=0,$C$34*($C$19/10)^2/(2*$C$10*BL109),IF(CB109>(-$C$19/10),$C$34*($C$35-10*$C$19/10)^2/(2*$C$10*BL109),0))","v":{"$error":"#N/A"}},{"$f":"IF(CB109<=0,0,$C$34*($C$35-10*$C$19/10)*($C$19/10)^2/(2*$C$10*BL109))","v":0},{"$f":"IF(CB109<=0,0,$C$34*($C$35-10*$C$19/10)*$C$19/10/($C$10*BL109))","v":0},null,"|",{"$f":"$C$37-10*$C$19/10","v":0},{"$f":"IF(CI109>=0,$C$36*($C$19/10)^3/(3*$C$10*BL109),IF(CI109>(-$C$19/10),$C$36*($C$37-10*$C$19/10)^3/(3*$C$10*BL109)+$C$36*($C$37-10*$C$19/10)^2/(2*$C$10*BL109)*ABS($C$37-10*$C$19/10),0))","v":{"$error":"#N/A"}},{"$f":"IF(CI109>=0,$C$36*($C$19/10)^2/(2*$C$10*BL109),IF(CI109>(-$C$19/10),$C$36*($C$37-10*$C$19/10)^2/(2*$C$10*BL109),0))","v":{"$error":"#N/A"}},{"$f":"IF(CI109<=0,0,$C$36*($C$37-10*$C$19/10)*($C$19/10)^2/(2*$C$10*BL109))","v":0},{"$f":"IF(CI109<=0,0,$C$36*($C$37-10*$C$19/10)*$C$19/10/($C$10*BL109))","v":0},null,"|",{"$f":"$C$39-10*$C$19/10","v":0},{"$f":"IF(CP109>=0,$C$38*($C$19/10)^3/(3*$C$10*BL109),IF(CP109>(-$C$19/10),$C$38*($C$39-10*$C$19/10)^3/(3*$C$10*BL109)+$C$38*($C$39-10*$C$19/10)^2/(2*$C$10*BL109)*ABS($C$39-10*$C$19/10),0))","v":{"$error":"#N/A"}},{"$f":"IF(CP109>=0,$C$38*($C$19/10)^2/(2*$C$10*BL109),IF(CP109>(-$C$19/10),$C$38*($C$39-10*$C$19/10)^2/(2*$C$10*BL109),0))","v":{"$error":"#N/A"}},{"$f":"IF(CP109<=0,0,$C$38*($C$39-10*$C$19/10)*($C$19/10)^2/(2*$C$10*BL109))","v":0},{"$f":"IF(CP109<=0,0,$C$38*($C$39-10*$C$19/10)*$C$19/10/($C$10*BL109))","v":0},null,"|",{"$f":"$C$41-10*$C$19/10","v":0},{"$f":"IF(CW109>=0,$C$40*($C$19/10)^3/(3*$C$10*$BL109),IF(CW109>(-$C$19/10),$C$40*($C$41-10*$C$19/10)^3/(3*$C$10*$BL109)+$C$40*($C$41-10*$C$19/10)^2/(2*$C$10*$BL109)*ABS($C$41-10*$C$19/10),0))","v":{"$error":"#N/A"}},{"$f":"IF(CW109>=0,$C$40*($C$19/10)^2/(2*$C$10*$BL109),IF(CW109>(-$C$19/10),$C$40*($C$41-10*$C$19/10)^2/(2*$C$10*$BL109),0))","v":{"$error":"#N/A"}},{"$f":"IF(CW109<=0,0,$C$40*($C$41-10*$C$19/10)*($C$19/10)^2/(2*$C$10*$BL109))","v":0},{"$f":"IF(CW109<=0,0,$C$40*($C$41-10*$C$19/10)*$C$19/10/($C$10*$BL109))","v":0},null,"|",{"$f":"$C$43-10*$C$19/10","v":0},{"$f":"IF(DD109>=0,$C$42*($C$19/10)^3/(3*$C$10*$BL109),IF(DD109>(-$C$19/10),$C$42*($C$43-10*$C$19/10)^3/(3*$C$10*$BL109)+$C$42*($C$43-10*$C$19/10)^2/(2*$C$10*$BL109)*ABS($C$43-10*$C$19/10),0))","v":{"$error":"#N/A"}},{"$f":"IF(DD109>=0,$C$42*($C$19/10)^2/(2*$C$10*$BL109),IF(DD109>(-$C$19/10),$C$42*($C$43-10*$C$19/10)^2/(2*$C$10*$BL109),0))","v":{"$error":"#N/A"}},{"$f":"IF(DD109<=0,0,$C$42*($C$43-10*$C$19/10)*($C$19/10)^2/(2*$C$10*$BL109))","v":0},{"$f":"IF(DD109<=0,0,$C$42*($C$43-10*$C$19/10)*$C$19/10/($C$10*$BL109))","v":0},null,"|",{"$f":"$C$45-10*$C$19/10","v":0},{"$f":"IF(DK109>=0,$C$44*($C$19/10)^3/(3*$C$10*$BL109),IF(DK109>(-$C$19/10),$C$44*($C$45-10*$C$19/10)^3/(3*$C$10*$BL109)+$C$44*($C$45-10*$C$19/10)^2/(2*$C$10*$BL109)*ABS($C$45-10*$C$19/10),0))","v":{"$error":"#N/A"}},{"$f":"IF(DK109>=0,$C$44*($C$19/10)^2/(2*$C$10*$BL109),IF(DK109>(-$C$19/10),$C$44*($C$45-10*$C$19/10)^2/(2*$C$10*$BL109),0))","v":{"$error":"#N/A"}},{"$f":"IF(DK109<=0,0,$C$44*($C$45-10*$C$19/10)*($C$19/10)^2/(2*$C$10*$BL109))","v":0},{"$f":"IF(DK109<=0,0,$C$44*($C$45-10*$C$19/10)*$C$19/10/($C$10*$BL109))","v":0},null,"|",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"BK109*DR109*19*LC/20","v":{"$error":"#N/A"}},{"$error":"#N/A"},null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"SUM(ED$100:ED109)+$C$19/10*(EC100*9+EC101*8+EC102*7+EC103*6+EC104*5+EC105*4+EC106*3+EC107*2+EC108)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C19","v":0},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"|",null,null,null,null,null,null,"|",null,null,null,null,null,null,"|",null,null,null,null,null,null,"|",null,null,null,null,null,null,"|",null,null,null,null,null,null,"|",null,null,null,null,null,null,"|",null,null,null,null,null,null,"|",null,null,null,null,null,null,"|"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"|",null,null,null,null,null,null,"|",null,null,null,null,null,null,"|",null,null,null,null,null,null,"|",null,null,null,null,null,null,"|",null,null,null,null,null,null,"|",null,null,null,null,null,null,"|",null,null,null,null,null,null,"|",null,null,null,null,null,null,"|"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"|",null,null,null,null,null,null,"|",null,null,null,null,null,null,"|",null,null,null,null,null,null,"|",null,null,null,null,null,null,"|",null,null,null,null,null,null,"|",null,null,null,null,null,null,"|",null,null,null,null,null,null,"|",null,null,null,null,null,null,"|",{"$f":"SUM(DR100:DR109)","v":{"$error":"#N/A"}},{"$f":"SUM(DS100:DS109)","v":{"$error":"#N/A"}},{"$f":"SUM(DT100:DT109)","v":{"$error":"#N/A"}},{"$f":"SUM(DU100:DU109)","v":{"$error":"#N/A"}},{"$f":"SUM(DV100:DV109)","v":{"$error":"#N/A"}},null,{"$f":"SUM(DX100:DX109)","v":{"$error":"#N/A"}},{"$f":"SUM(DY100:DY109)","v":{"$error":"#N/A"}},null,{"$f":"SUM(EA100:EA109)","v":{"$error":"#N/A"}},{"$f":"SUM(EB100:EB109)","v":{"$error":"#N/A"}},{"$f":"SUM(EC100:EC109)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"|",null,null,null,null,null,null,"|",null,null,null,null,null,null,"|",null,null,null,null,null,null,"|",null,null,null,null,null,null,"|",null,null,null,null,null,null,"|",null,null,null,null,null,null,"|",null,null,null,null,null,null,"|",null,null,null,null,null,null,"|",null,null,null,null,{"$f":"DU112/DV112","v":{"$error":"#N/A"}}]

{"sheet":"MACRO1","index":5,"n_rows":38,"n_cols":1,"rows_kept":38,"cut":false,"hidden":true,"merged":[]}
["clean (a)"]
[{"$f":"SELECT(\"R3C5:R5C5\")","v":true}]
[{"$f":"CLEAR(3)","v":true}]
[{"$f":"SELECT(\"R8C5\")","v":true}]
[{"$f":"CLEAR(3)","v":true}]
[{"$f":"SELECT(\"R10C1:R12C1\")","v":true}]
[{"$f":"CLEAR(3)","v":true}]
[{"$f":"SELECT(\"R15C1:R17C1\")","v":true}]
[{"$f":"CLEAR(3)","v":true}]
[{"$f":"VLINE(18)","v":true}]
[{"$f":"SELECT(\"R21C1:R22C1\")","v":true}]
[{"$f":"CLEAR(3)","v":true}]
[{"$f":"SELECT(\"R25C1:R29C1\")","v":true}]
[{"$f":"CLEAR(3)","v":true}]
[{"$f":"SELECT(\"R31C1:R33C1\")","v":true}]
[{"$f":"CLEAR(3)","v":true}]
[{"$f":"SELECT(\"R31C4:R33C4\")","v":true}]
[{"$f":"CLEAR(3)","v":true}]
[{"$f":"SELECT(\"R31C6:R33C6\")","v":true}]
[{"$f":"CLEAR(3)","v":true}]
[{"$f":"SELECT(\"R31C8:R33C8\")","v":true}]
[{"$f":"CLEAR(3)","v":true}]
[{"$f":"HLINE(8)","v":true}]
[{"$f":"SELECT(\"R31C12:R33C12\")","v":true}]
[{"$f":"CLEAR(3)","v":true}]
[{"$f":"SELECT(\"R25C14:R29C14\")","v":true}]
[{"$f":"CLEAR(3)","v":true}]
[{"$f":"SELECT(\"R25C12:R29C12\")","v":true}]
[{"$f":"CLEAR(3)","v":true}]
[{"$f":"SELECT(\"R25C10:R29C10\")","v":true}]
[{"$f":"CLEAR(3)","v":true}]
[{"$f":"SELECT(\"R21C9:R22C9\")","v":true}]
[{"$f":"CLEAR(3)","v":true}]
[{"$f":"VLINE(-18)","v":true}]
[{"$f":"SELECT(\"R3C10:R6C10\")","v":true}]
[{"$f":"CLEAR(3)","v":true}]
[{"$f":"SELECT(\"R1C1\")","v":true}]
[{"$f":"RETURN()","v":true}]