{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Sheet1","Sheet2","Sheet3"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":216,"n_cols":40,"rows_kept":216,"cut":false,"hidden":false,"merged":[[61,11,61,12],[63,11,63,12],[196,4,196,5],[196,7,196,8],[196,30,196,32],[197,7,197,9],[179,17,179,18],[106,17,106,18],[117,9,117,10],[117,12,117,13],[117,15,117,16],[184,4,184,5],[178,32,179,34],[162,25,162,26],[162,32,162,33],[165,25,165,26],[165,32,165,33],[168,25,168,26],[168,32,168,33],[170,25,170,26],[170,32,170,33],[150,25,150,26],[150,32,150,33],[154,25,154,26],[193,18,193,19],[194,18,194,19],[202,9,202,10],[202,12,202,13],[202,15,202,16],[198,14,198,15],[198,19,198,20],[142,23,142,24],[151,23,151,24],[148,49,148,50],[196,25,196,26],[196,10,196,11],[196,13,196,14],[197,11,197,12],[190,18,190,19],[197,14,197,15],[197,17,197,18],[197,20,197,21],[193,20,193,21],[194,20,194,21],[196,16,196,17],[196,19,196,20],[196,22,196,23],[182,30,182,31],[182,32,182,34],[182,35,182,37],[183,30,183,31],[183,32,183,34],[183,35,183,37],[184,16,184,17],[184,30,184,31],[184,32,184,34],[184,35,184,37],[211,31,211,32],[211,34,211,35],[211,37,211,38],[212,4,212,5],[212,7,212,8],[212,10,212,11],[212,13,212,14],[212,16,212,17],[215,7,215,8],[215,10,215,11],[215,13,215,14],[211,4,211,5],[211,7,211,8],[211,10,211,11],[211,13,211,14],[211,16,211,17],[211,19,211,20],[211,22,211,23],[211,25,211,26],[211,28,211,29],[207,20,207,21],[207,22,207,23],[207,24,207,25],[207,26,207,27],[208,2,208,3],[208,4,208,5],[208,6,208,7],[208,8,208,9],[208,10,208,11],[208,12,208,13],[208,14,208,15],[208,16,208,17],[208,18,208,19],[208,20,208,21],[208,22,208,23],[208,24,208,25],[208,26,208,27],[207,2,207,3],[207,4,207,5],[207,6,207,7],[207,8,207,9],[207,10,207,11],[207,12,207,13],[207,14,207,15],[207,16,207,17],[207,18,207,19],[205,20,205,21],[205,22,205,23],[205,24,205,25],[205,26,205,27],[206,2,206,3],[206,4,206,5],[206,6,206,7],[206,8,206,9],[206,10,206,11],[206,12,206,13],[206,14,206,15],[206,16,206,17],[206,18,206,19],[206,20,206,21],[206,22,206,23],[206,24,206,25],[206,26,206,27],[205,2,205,3],[205,4,205,5],[205,6,205,7],[205,8,205,9],[205,10,205,11],[205,12,205,13],[205,14,205,15],[205,16,205,17],[205,18,205,19],[200,26,200,27],[200,29,200,30],[200,32,200,33],[200,35,200,36],[204,4,204,5],[204,7,204,8],[204,10,204,11],[204,13,204,14],[204,16,204,17],[200,8,200,9],[200,11,200,12],[200,14,200,15],[200,17,200,18],[200,20,200,21],[200,23,200,24],[201,13,201,14],[178,35,179,37],[182,2,182,3],[182,4,182,5],[182,6,182,7],[180,28,180,31],[180,32,180,34],[180,35,180,37],[181,30,181,31],[181,32,181,34],[181,35,181,37],[178,28,179,31],[154,32,154,33],[158,25,158,26],[158,32,158,33],[159,17,161,17],[159,19,161,19],[159,25,159,26],[159,32,159,33],[138,1,138,39],[140,9,140,10],[145,17,147,17],[146,25,146,26],[146,32,146,33],[147,25,147,26],[147,32,147,33],[133,4,133,5],[133,7,133,8],[133,10,133,11],[133,13,133,14],[133,16,133,17],[132,4,132,5],[132,7,132,8],[132,10,132,11],[132,13,132,14],[132,16,132,17],[67,6,67,7],[73,19,73,20],[115,7,115,8],[92,19,92,20],[77,19,77,20],[95,19,95,20],[85,19,85,20],[74,19,74,20],[97,19,97,20],[89,19,89,20],[81,19,81,20],[86,19,86,20],[115,13,115,14],[115,19,115,20],[115,10,115,11],[113,6,113,7],[59,13,59,14],[59,28,59,29],[59,32,59,33],[57,2,57,3],[57,5,57,6],[57,13,57,14],[57,28,57,29],[57,11,57,12],[59,11,59,12],[110,36,110,38],[111,36,111,38],[63,32,63,33],[110,31,110,32],[110,33,110,35],[107,33,108,35],[65,1,65,39],[40,10,40,11],[17,3,17,4],[17,17,17,18],[61,2,61,3],[61,5,61,6],[61,13,61,14],[61,28,61,29],[61,32,61,33],[42,1,42,39],[53,4,53,5],[54,5,54,6],[55,4,55,5],[55,7,55,8],[55,10,55,11],[57,32,57,33],[59,2,59,3],[59,5,59,6],[11,36,11,38],[11,33,11,35],[34,21,36,21],[16,21,18,21],[25,21,27,21],[29,21,31,21],[21,21,23,21],[21,29,25,37],[26,23,28,23],[26,17,26,18],[33,17,33,18],[1,1,1,39],[19,32,19,35],[16,30,16,31],[26,3,26,4],[19,3,19,4],[9,14,9,15],[11,31,11,32],[12,31,12,32],[13,31,13,32],[12,33,12,35],[13,33,13,35],[8,29,9,32],[10,29,10,32],[8,33,9,35],[10,4,10,5],[14,36,14,38],[5,16,5,17],[10,23,12,23],[12,36,12,38],[13,36,13,38],[8,36,9,38],[10,36,10,38],[10,33,10,35],[111,6,111,7],[72,13,74,13],[86,13,88,13],[86,15,88,15],[72,3,75,10],[109,6,109,7],[109,8,109,9],[109,4,109,5],[63,2,63,3],[63,5,63,6],[63,13,63,14],[111,31,111,32],[111,33,111,35],[73,26,73,27],[81,26,81,27],[89,26,89,27],[74,26,74,27],[85,26,85,27],[77,26,77,27],[86,26,86,27],[63,28,63,29],[12,10,12,11],[23,3,23,4],[119,22,119,23],[119,25,119,26],[119,4,119,5],[121,10,121,11],[113,31,113,32],[113,33,113,35],[113,36,113,38],[14,31,14,32],[14,33,14,35],[107,36,108,38],[109,29,109,32],[109,33,109,35],[109,36,109,38],[112,31,112,32],[112,33,112,35],[112,36,112,38],[107,29,108,32],[23,17,23,18],[29,17,29,18],[35,17,35,18],[29,3,29,4],[35,3,35,4],[33,3,33,4],[19,17,19,18],[122,4,122,5],[122,6,122,7],[121,2,121,3],[121,6,121,7],[121,8,121,9],[97,26,97,27],[95,26,95,27],[92,26,92,27],[124,10,124,11],[123,2,123,3],[123,4,123,5],[123,6,123,7],[123,8,123,9],[123,10,123,11],[122,2,122,3],[115,16,115,17],[115,22,115,23],[124,2,124,3],[124,4,124,5],[124,6,124,7],[124,8,124,9],[122,8,122,9],[122,10,122,11],[119,19,119,20],[132,19,132,20],[132,22,132,23],[132,25,132,26],[132,28,132,29],[126,26,126,27],[127,26,127,27],[128,26,128,27],[129,26,129,27],[126,20,126,21],[127,20,127,21],[128,20,128,21],[129,20,129,21],[126,22,126,23],[127,22,127,23],[128,22,128,23],[129,22,129,23],[116,28,116,29],[116,31,116,32],[129,16,129,17],[128,8,128,9],[121,12,121,13],[122,12,122,13],[122,14,122,15],[123,12,123,13],[123,14,123,15],[124,12,124,13],[124,14,124,15],[128,14,128,15],[119,7,119,8],[119,10,119,11],[119,13,119,14],[119,16,119,17],[127,16,127,17],[128,16,128,17],[126,16,126,17],[119,28,119,29],[128,10,128,11],[128,12,128,13],[126,6,126,7],[127,6,127,7],[129,2,129,3],[126,14,126,15],[127,2,127,3],[127,4,127,5],[127,10,127,11],[129,4,129,5],[129,6,129,7],[129,10,129,11],[129,12,129,13],[127,8,127,9],[127,12,127,13],[127,14,127,15],[128,2,128,3],[128,4,128,5],[128,6,128,7],[126,8,126,9],[126,2,126,3],[126,4,126,5],[126,10,126,11],[126,12,126,13],[132,37,132,38],[116,34,116,35],[136,10,136,11],[136,7,136,8],[136,13,136,14],[126,24,126,25],[127,24,127,25],[128,24,128,25],[129,24,129,25],[126,18,126,19],[127,18,127,19],[128,18,128,19],[132,34,132,35],[129,8,129,9],[116,7,116,8],[116,10,116,11],[116,13,116,14],[116,16,116,17],[129,14,129,15],[129,18,129,19],[132,31,132,32],[116,19,116,20],[116,22,116,23],[116,25,116,26]]}
[]
[null,"YAPI RÜZGAR YÜKÜ HESABI\n(Gürcan BERBEROĞLU tel: 0532 366 02 04   www.betoncelik.com )"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"dikkat sadece sarı hücrelere rakam giriniz."]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SQRT(X11^2+(K41/2)^2)","v":3.5355339059327378},null,"m"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TS 498 Kasım 1997"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null," 0,4 * q =",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"zeminden yükseklik",null,null,null,"rüzgar hızı\nv",null,null,"emme\nq"]
[null,null,null,null,{"$f":"IF(AG20=\"kule tipi yapı\",\"( 1,6 * sin a - 0,4 ) * q =\",\"( 1,2 * sin a - 0,4 ) * q =\")","v":"( 1,6 * sin a - 0,4 ) * q ="},null,null,null,null,null,null,null,null,null,{"$f":"0.4*AE17","v":0.52},null,"KN/m²",null,null,null,null,null,null,"m"]
[null,null,null,null,{"$f":"ABS(IF(AG20=\"kule tipi yapı\",(1.6*SIN(K13*PI()/180)-0.4)*AE17,(1.2*SIN(K13*PI()/180)-0.4)*AE17))","v":0.95078210486801884},null,"KN/m²",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.5,null,null,null,null,null,"(m)",null,null,null,"(m/s)",null,null,"(KN/m²)"]
[null,null,null,null,{"$f":"IF(AG20=\"kule tipi yapı\",(1.6*SIN(K13*PI()/180)-0.4)*AE17,(1.2*SIN(K13*PI()/180)-0.4)*AE17)","v":0.95078210486801884},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"~",8,null,28,null,null,0.5]
[null,null,null,null,null,null,null,null,null,"a =",{"$f":"ATAN(X11/(K41/2))*180/PI()","v":45},null,"°",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,"~",20,null,36,null,null,0.8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,21,"~",100,null,42,null,null,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,">",100,null,46,null,null,1.3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(V17=\"\",\"\",\"m\")","v":"m"}]
[null,null,null,{"$f":"IF(AG20=\"kule tipi yapı\",IF(AE17=1.3,\"1,2 * q =\",\"\"),IF(AE17=1.3,\"0,8 * q =\",\"\"))","v":"1,2 * q ="},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AE17=1.3,\"0,4 * q =\",\"\")","v":"0,4 * q ="},null,null,null,{"$f":"IF(AE17=1.3,X27-100,IF(AE17=1.1,X27-20,IF(AE17=0.8,X27-8,\"\")))","v":25},null,null,null,null,null,null,null,null,{"$f":"IF(8>=X27,AK12,IF(AND(AD13<=X27,X27<=AF13),AK13,IF(AND(AD14<=X27,X27<=AF14),AK14,IF(X27>AF15,AK15,\"hatalı\"))))","v":1.3}]
[null,null,null,{"$f":"IF(AG20=\"kule tipi yapı\",IF(AE17=1.3,1.2*AK15,\"\"),IF(AE17=1.3,0.8*AK15,\"\"))","v":1.56},null,{"$f":"IF(AE17=1.3,\"KN/m²\",\"\")","v":"KN/m²"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AE17=1.3,0.4*AK15,\"\")","v":0.52},null,{"$f":"IF(AE17=1.3,\"KN/m²\",\"\")","v":"KN/m²"}]
[null,null,null,{"$f":"IF(AG20=\"kule tipi yapı\",IF(AE17=1.1,\"1,2 * q =\",\"\"),IF(AE17=1.1,\"0,8 * q =\",\"\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AE17=1.1,\"0,4 * q =\",\"\")","v":""}]
[null,null,null,{"$f":"IF(AG20=\"kule tipi yapı\",IF(AE17=1.1,1.2*AK14,\"\"),IF(AE17=1.1,0.8*AK14,\"\"))","v":""},null,{"$f":"IF(AE17=1.1,\"KN/m²\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AE17=1.1,0.4*AK14,\"\")","v":""},null,{"$f":"IF(AE17=1.1,\"KN/m²\",\"\")","v":""},null,null,null,null,null,null,null,null,null,"yapı tipi:",null,null,{"$f":"IF(K41*5<=(X27+X11),\"kule tipi yapı\",\"normal yapı\")","v":"kule tipi yapı"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(V22=\"\",\"\",\"m\")","v":"m"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AE17=1.3,80,\"\")","v":80},null,null,null,null,null,null,null,"Not: yüksekliği plandaki eninin 5 katı ve daha fazlası olduğunda yapı tipi kule tipidir.Değil ise Normal yapıdır."]
[null,null,null,{"$f":"IF(AG20=\"kule tipi yapı\",IF(OR(AE17=1.3,AE17=0.8),\"1,2 * q =\",\"\"),IF(OR(AE17=1.3,AE17=0.8),\"0,8 * q =\",\"\"))","v":"1,2 * q ="},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(AE17=1.3,AE17=0.8),\"0,4 * q =\",\"\")","v":"0,4 * q ="}]
[null,null,null,{"$f":"IF(AG20=\"kule tipi yapı\",IF(AE17=1.3,1.2*AK14,IF(AE17=0.8,1.2*AK13,\"\")),IF(AE17=1.3,0.8*AK14,IF(AE17=0.8,0.8*AK13,\"\")))","v":1.32},null,{"$f":"IF(OR(AE17=1.3,AE17=0.8),\"KN/m²\",\"\")","v":"KN/m²"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AE17=1.3,0.4*AK14,IF(AE17=0.8,0.4*AK13,\"\"))","v":0.44000000000000006},null,{"$f":"IF(OR(AE17=1.3,AE17=0.8),\"KN/m²\",\"\")","v":"KN/m²"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(V26=\"\",\"\",\"m\")","v":""}]
[null,null,null,{"$f":"IF(AG20=\"kule tipi yapı\",IF(AE17=0.5,\"1,2 * q =\",IF(AE17=1.1,\"1,2 * q =\",\"\")),IF(AE17=0.5,\"0,8 * q =\",IF(AE17=1.1,\"0,8 * q =\",\"\")))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AE17=0.5,\"0,4 *q =\",IF(AE17=1.1,\"0,4 * q =\",\"\"))","v":""},null,null,null,{"$f":"IF(AE17=1.1,12,\"\")","v":""},null,"m"]
[null,null,null,{"$f":"IF(AG20=\"kule tipi yapı\",IF(AE17=0.5,1.2*AK12,IF(AE17=1.1,1.2*AK13,\"\")),IF(AE17=0.5,0.8*AK12,IF(AE17=1.1,0.8*AK13,\"\")))","v":""},null,{"$f":"IF(AE17=0.5,\"KN/m²\",IF(AE17=1.1,\"KN/m²\",\"\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AE17=0.5,0.4*AK12,IF(AE17=1.1,0.4*AK13,\"\"))","v":""},null,{"$f":"IF(AE17=0.5,\"KN/m²\",IF(AE17=1.1,\"KN/m²\",\"\"))","v":""},null,null,null,125]
[]
[null,null,null,{"$f":"IF(AG20=\"kule tipi yapı\",IF(AE17=1.3,\"1,2 * q =\",\"\"),IF(AE17=1.3,\"0,8 * q =\",\"\"))","v":"1,2 * q ="},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AE17=1.3,\"0,4 * q =\",\"\")","v":"0,4 * q ="},null,null,null,{"$f":"IF(V30=\"\",\"\",\"m\")","v":"m"}]
[null,null,null,{"$f":"IF(AG20=\"kule tipi yapı\",IF(AE17=1.3,1.2*AK13,\"\"),IF(AE17=1.3,0.8*AK13,\"\"))","v":0.96},null,{"$f":"IF(AE17=1.3,\"KN/m²\",\"\")","v":"KN/m²"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AE17=1.3,0.4*AK13,\"\")","v":0.32000000000000006},null,{"$f":"IF(AE17=1.3,\"KN/m²\",\"\")","v":"KN/m²"},null,{"$f":"IF(AE17=1.3,12,\"\")","v":12}]
[]
[]
[null,null,null,{"$f":"IF(AG20=\"kule tipi yapı\",IF(AE17=0.8,\"1,2 * q\",IF(AE17=1.1,\"1,2 * q =\",\"\")),IF(AE17=0.8,\"0,8 * q\",IF(AE17=1.1,\"0,8 * q =\",\"\")))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AE17=0.8,\"0,4 * q =\",IF(AE17=1.1,\"0,4 * q =\",\"\"))","v":""}]
[null,null,null,{"$f":"IF(AG20=\"kule tipi yapı\",IF(AE17=0.8,1.2*AK12,IF(AE17=1.1,1.2*AK12,\"\")),IF(AE17=0.8,0.8*AK12,IF(AE17=1.1,0.8*AK12,\"\")))","v":""},null,{"$f":"IF(AE17=0.8,\"KN/m²\",IF(AE17=1.1,\"KN/m²\",\"\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AE17=0.8,0.4*AK12,IF(AE17=1.1,0.4*AK12,\"\"))","v":""},null,{"$f":"IF(AE17=0.8,\"KN/m²\",IF(AE17=1.1,\"KN/m²\",\"\"))","v":""},null,{"$f":"IF(V35=\"\",\"\",\"m\")","v":"m"}]
[null,null,null,{"$f":"IF(AG20=\"kule tipi yapı\",IF(AE17=1.3,\"1,2 * q =\",\"\"),IF(AE17=1.3,\"0,8 * q =\",\"\"))","v":"1,2 * q ="},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AE17=1.3,\"0,4 * q =\",\"\")","v":"0,4 * q ="},null,null,null,{"$f":"IF(OR(AE17=1.1,AE17=0.8,AE17=1.3),8,\"\")","v":8}]
[null,null,null,{"$f":"IF(AG20=\"kule tipi yapı\",IF(AE17=1.3,1.2*AK12,\"\"),IF(AE17=1.3,0.8*AK12,\"\"))","v":0.6},null,{"$f":"IF(AE17=1.3,\"KN/m²\",\"\")","v":"KN/m²"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AE17=1.3,0.4*AK12,\"\")","v":0.2},null,{"$f":"IF(AE17=1.3,\"KN/m²\",\"\")","v":"KN/m²"}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,5,null,"m"]
[]
[null,"YAPI A YÜZÜNDE OLUŞAN EMME RÜZGAR YÜKÜNE GÖRE m² 'de İZOLASYON PLASTİK DÜBEL SAYISI HESABI\n(Gürcan BERBEROĞLU tel: 0532 366 02 04   www.betoncelik.com )"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"dikkat sadece sarı hücrelere rakam giriniz."]
[null,null,"Nk=Dübelin çekme dayanımı , dübeli koparan veya sıyıran karakteristik kuvvet (KN)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yukarıdaki şekille beraber düşünülecek."]
[null,null,"Nd = Dübel tasarım çekme kuvveti , dübeli çekip çıkarmaya , koparmaya çalışan rüzgar tasarım kuvveti (KN)"]
[null,null,"Nr = Dübelin güvenle taşıyabileceği çekme kuvveti (KN)"]
[null,null,"g dübel = Dübel güvenlik katsayısı (2~3)"]
[null,null,"w =Rüzgar emme kuvveti (KN/m²)"]
[null,null,"n = 1m² ye çakılması gereken dübel sayısı"]
[]
[null,null,"( Nd = w * 1 / n )      = <    ( Nr = Nk / g dübel ) olmalı"]
[]
[null,null,"Nk=",null,0.1,null,"KN"]
[null,null,"g dübel =",null,null,2,null,null,{"$f":"IF(AND(2<=F55,F55<=3),\"uygun.\",\"uygun değil.2 ile 3 arasında bir değer olmalı.\")","v":"uygun."}]
[null,null,"Nr =",null,{"$f":"+E54","v":0.1},null," /",{"$f":"+F55","v":2},null,"=",{"$f":"+E56/H56","v":0.05},null,"KN",null,null,null,null,null,"not: bina köşelerinde dübel sayısının her m² de en az 2 adet arttırılması önerilir."]
[]
[null,null,0,null,"~",{"$f":"IF(AE17=0.5,X27,IF(AE17=0.8,V35,IF(AE17=1.1,V35,IF(AE17=1.3,V35,0))))","v":8},null,"kotlar arası",null,null,null,"w=",null,{"$f":"IF(AE17=0.5,R27,IF(AE17=0.8,R34,IF(AE17=1.1,R34,IF(AE17=1.3,R36,0))))","v":0.2},null,"KN/m²",null,null,"Nd =  w * 1 / n =  Nr ",null,null,null,null,null,"n = w * 1 / Nr = ",null,null,null,{"$f":"+N58","v":0.2},null," *  1   / ",null,{"$f":"+K56","v":0.05},null,"=",{"$f":"ROUNDDOWN(+AC58*1/AG58,0)","v":4},"dübel / m²"]
[]
[null,null,{"$f":"IF(F60=\"\",\"\",+AD13)","v":9},null,{"$f":"IF(F60=\"\",\"\",\"~\")","v":"~"},{"$f":"IF(AE17=0.5,\"\",IF(AE17=0.8,V17,IF(AE17=1.1,V26,IF(AE17=1.3,V30,0))))","v":12},null,{"$f":"IF(F60=\"\",\"\",\"kotlar arası\")","v":"kotlar arası"},null,null,null,{"$f":"IF(F60=\"\",\"\",\"w =\")","v":"w ="},null,{"$f":"IF(AE17=0.5,\"\",IF(AE17=0.8,R24,IF(AE17=1.1,R27,IF(AE17=1.3,R30,0))))","v":0.32000000000000006},null,{"$f":"IF(F60=\"\",\"\",\"KN/m²\")","v":"KN/m²"},null,null,{"$f":"IF(F60=\"\",\"\",\"Nd =  w * 1 / n =  Nr \")","v":"Nd =  w * 1 / n =  Nr "},null,null,null,null,null,{"$f":"IF(F60=\"\",\"\",\"n = w * 1 / Nr = \")","v":"n = w * 1 / Nr = "},null,null,null,{"$f":"IF(F60=\"\",\"\",+N60)","v":0.32000000000000006},null,{"$f":"IF(F60=\"\",\"\",\"*  1   / \")","v":"*  1   / "},null,{"$f":"IF(F60=\"\",\"\",+K56)","v":0.05},null,{"$f":"IF(F60=\"\",\"\",\"=\")","v":"="},{"$f":"IF(F60=\"\",\"\",ROUNDDOWN(+AC60*1/AG60,0))","v":6},{"$f":"IF(F60=\"\",\"\",\"dübel / m²\")","v":"dübel / m²"}]
[]
[null,null,{"$f":"IF(F62=\"\",\"\",+AD14)","v":21},null,{"$f":"IF(F62=\"\",\"\",\"~\")","v":"~"},{"$f":"IF(AE17=0.5,\"\",IF(AE17=0.8,\"\",IF(AE17=1.1,V17,IF(AE17=1.3,V17,0))))","v":25},null,{"$f":"IF(F62=\"\",\"\",\"kotlar arası\")","v":"kotlar arası"},null,null,null,{"$f":"IF(F62=\"\",\"\",\"w =\")","v":"w ="},null,{"$f":"IF(AE17=0.5,\"\",IF(AE17=0.8,\"\",IF(AE17=1.1,R20,IF(AE17=1.3,R24,0))))","v":0.44000000000000006},null,{"$f":"IF(F62=\"\",\"\",\"KN/m²\")","v":"KN/m²"},null,null,{"$f":"IF(F62=\"\",\"\",\"Nd =  w * 1 / n =  Nr \")","v":"Nd =  w * 1 / n =  Nr "},null,null,null,null,null,{"$f":"IF(F62=\"\",\"\",\"n = w * 1 / Nr = \")","v":"n = w * 1 / Nr = "},null,null,null,{"$f":"+N62","v":0.44000000000000006},null,{"$f":"IF(F62=\"\",\"\",\" *  1   / \")","v":" *  1   / "},null,{"$f":"IF(F62=\"\",\"\",+K56)","v":0.05},null,{"$f":"IF(F62=\"\",\"\",\"=\")","v":"="},{"$f":"IF(F62=\"\",\"\",ROUNDDOWN(+AC62*1/AG62,0))","v":8},{"$f":"IF(F62=\"\",\"\",\"dübel / m²\")","v":"dübel / m²"}]
[]
[null,null,null,null,{"$f":"IF(F64=\"\",\"\",\">\")","v":">"},{"$f":"IF(AE17=0.5,\"\",IF(AE17=0.8,\"\",IF(AE17=1.1,\"\",IF(AE17=1.3,V17,0))))","v":25},null,{"$f":"IF(F64=\"\",\"\",\"kotlar arası\")","v":"kotlar arası"},null,null,null,{"$f":"IF(F64=\"\",\"\",\"w =\")","v":"w ="},null,{"$f":"IF(AE17=0.5,\"\",IF(AE17=0.8,\"\",IF(AE17=1.1,\"\",IF(AE17=1.3,R18,0))))","v":0.52},null,{"$f":"IF(F64=\"\",\"\",\"KN/m²\")","v":"KN/m²"},null,null,{"$f":"IF(F64=\"\",\"\",\"Nd =  w * 1 / n =  Nr \")","v":"Nd =  w * 1 / n =  Nr "},null,null,null,null,null,{"$f":"IF(F64=\"\",\"\",\"n = w * 1 / Nr = \")","v":"n = w * 1 / Nr = "},null,null,null,{"$f":"+N64","v":0.52},null,{"$f":"IF(F64=\"\",\"\",\"*  1   / \")","v":"*  1   / "},null,{"$f":"IF(F64=\"\",\"\",+K56)","v":0.05},null,{"$f":"IF(F64=\"\",\"\",\"=\")","v":"="},{"$f":"IF(F64=\"\",\"\",ROUNDDOWN(+AC64*1/AG64,0))","v":10},{"$f":"IF(F64=\"\",\"\",\"dübel / m²\")","v":"dübel / m²"}]
[]
[null,"REKLAM PANOSU RÜZGAR YÜKÜ VE KONSOL MOMENTİ HESABI\n(Gürcan BERBEROĞLU tel: 0532 366 02 04   www.betoncelik.com )"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"dikkat sadece sarı hücrelere rakam giriniz."]
[null,null,null,null,null,null,5,null,"m"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"m"]
[null,null,null,"www.betoncelik.com",null,null,null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AA74=\"\",\"\",\"1,6 * q =\")","v":""},null,{"$f":"IF(AA74=\"\",\"\",1.6*AK114)","v":""},null,{"$f":"IF(AA74=\"\",\"\",\"KN/m²\")","v":""},null,null,null,null,{"$f":"IF(P87>100,P87-100,\"\")","v":""},null,{"$f":"IF(AA74=\"\",\"\",\"m\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AA75=\"\",\"\",\"1,6 * q =\")","v":"1,6 * q ="},null,{"$f":"IF(AA75=\"\",\"\",1.6*AK113)","v":1.7600000000000002},null,{"$f":"IF(AA75=\"\",\"\",\"KN/m²\")","v":"KN/m²"},null,null,null,null,{"$f":"IF(AND(100>=P87,P87>20),P87-20,\"\")","v":10},null,{"$f":"IF(AA75=\"\",\"\",\"m\")","v":"m"}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AA78=\"\",\"\",\"1,6 * q =\")","v":""},null,{"$f":"IF(AA78=\"\",\"\",1.6*AK112)","v":""},null,{"$f":"IF(AA78=\"\",\"\",\"KN/m²\")","v":""},null,null,null,null,{"$f":"IF(AND(20>=P87,P87>8),P87-8,\"\")","v":""},null,{"$f":"IF(AA78=\"\",\"\",\"m\")","v":""}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"pano"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AA82=\"\",\"\",\"1,6 * q =\")","v":""},null,{"$f":"IF(AA82=\"\",\"\",1.6*AK113)","v":""},null,{"$f":"IF(AA82=\"\",\"\",\"KN/m²\")","v":""},null,null,null,null,{"$f":"IF(P87>100,80,\"\")","v":""},null,{"$f":"IF(AA82=\"\",\"\",\"m\")","v":""}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"m",null,"m",null,{"$f":"IF(AA86=\"\",\"\",\"1,6 * q =\")","v":"1,6 * q ="},null,{"$f":"IF(AA86=\"\",\"\",1.6*AK112)","v":1.2800000000000002},null,{"$f":"IF(AA86=\"\",\"\",\"KN/m²\")","v":"KN/m²"},null,null,null,null,{"$f":"IF(AND(100>=P87,P87>20),12,\"\")","v":12},null,{"$f":"IF(AA86=\"\",\"\",\"m\")","v":"m"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+P87-N73","v":27},null,30,null,{"$f":"IF(AA87=\"\",\"\",\"1,6 * q =\")","v":""},null,{"$f":"IF(AA87=\"\",\"\",1.6*AK111)","v":""},null,{"$f":"IF(AA87=\"\",\"\",\"KN/m²\")","v":""},null,null,null,null,{"$f":"IF(P87<=8,P87,\"\")","v":""},null,{"$f":"IF(AA87=\"\",\"\",\"m\")","v":""}]
[]
[]
[null,null,null,null,null,null,null,null,null,"ayak",null,null,null,null,null,{"$f":"IF(P87<=8,1,IF(AND(9<=P87,P87<=20),2,IF(AND(21<=P87,P87<=100),3,IF(101<=P87,4,0))))","v":3},null,{"$f":"IF(AA90=\"\",\"\",\"1,6 * q =\")","v":""},null,{"$f":"IF(AA90=\"\",\"\",1.6*AK112)","v":""},null,{"$f":"IF(AA90=\"\",\"\",\"KN/m²\")","v":""},null,null,null,null,{"$f":"IF(P87>100,12,\"\")","v":""},null,{"$f":"IF(AA90=\"\",\"\",\"m\")","v":""}]
[null,null,"ÖN GÖRÜNÜŞ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"YAN GÖRÜNÜŞ"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AA93=\"\",\"\",\"1,6 * q =\")","v":""},null,{"$f":"IF(AA93=\"\",\"\",1.6*AK111)","v":""},null,{"$f":"IF(AA93=\"\",\"\",\"KN/m²\")","v":""},null,null,null,null,{"$f":"IF(AND(20>=P87,P87>8),8,\"\")","v":""},null,{"$f":"IF(AA93=\"\",\"\",\"m\")","v":""}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AA96=\"\",\"\",\"1,6 * q =\")","v":"1,6 * q ="},null,{"$f":"IF(AA96=\"\",\"\",1.6*AK111)","v":0.8},null,{"$f":"IF(AA96=\"\",\"\",\"KN/m²\")","v":"KN/m²"},null,null,null,null,{"$f":"IF(AND(100>=P87,P87>20),8,\"\")","v":8},null,{"$f":"IF(AA96=\"\",\"\",\"m\")","v":"m"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AA98=\"\",\"\",\"1,6 * q =\")","v":""},null,{"$f":"IF(AA98=\"\",\"\",1.6*AK111)","v":""},null,{"$f":"IF(AA98=\"\",\"\",\"KN/m²\")","v":""},null,null,null,null,{"$f":"IF(P87>100,8,\"\")","v":""},null,{"$f":"IF(AA98=\"\",\"\",\"m\")","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,"M"]
[null,null,null,null,null,null,null,null,null,null,"w= 1,2 * q (KN/m²)",null,null,null,null,null,"w= 0,4 * q (KN/m²)",null,null,null,null,null,"w= 1,6 * q (KN/m²)"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"=",null,null,null,null,null,null,null,null,null,null,null,"TS 498 Kasım 1997"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"zeminden yükseklik",null,null,null,"rüzgar hızı\nv",null,null,"emme\nq"]
[]
[null,null,null,null,{"$f":"+I110","v":1.2E-2},null,{"$f":"+G112-I110*2","v":0.77600000000000002},null,1.2E-2,null,"m",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(m)",null,null,null,"(m/s)",null,null,"(KN/m²)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"~",8,null,28,null,null,0.5]
[null,null,null,null,null,null,0.8,null,"m",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,"~",20,null,36,null,null,0.8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,21,"~",100,null,42,null,null,1.1000000000000001]
[null,null,"Ayak Çapı =",null,null,null,{"$f":"+G112","v":0.8},null,"m",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,">",100,null,46,null,null,1.3]
[]
[null,null,"Pano bileşke yük (",null,null,null,null,{"$f":"SUM(C122:D125)","v":1.7600000000000002},null,"*",{"$f":"SUM(I122:J125)","v":3},null,"+",{"$f":"SUM(E122:F125)","v":0},null,"*",{"$f":"SUM(K122:L125)","v":0},null,") *",{"$f":"SUM(G122:H125)","v":5},null,"=",{"$f":"(H116*K116+N116*Q116)*T116","v":26.400000000000006},null,"KN"]
[null,null,"Ayak Bileşke yük (",null,null,null,null,{"$f":"SUM(C127:D130)","v":1.7600000000000002},null,"*",{"$f":"SUM(M127:N130)","v":7},null,"+",{"$f":"SUM(E127:F130)","v":1.2800000000000002},null,"*",{"$f":"SUM(O127:P130)","v":12},null,"+",{"$f":"SUM(G127:H130)","v":0.8},null,"*",{"$f":"SUM(Q127:R130)","v":8},null,"+",{"$f":"SUM(I127:J130)","v":0},null,"*",{"$f":"SUM(S127:T130)","v":0},null,") *",{"$f":"SUM(K127:L130)","v":0.8},null,"=",{"$f":"(H117*K117+N117*Q117+T117*W117+Z117*AC117)*AF117","v":27.264000000000006},null,"KN"]
[null,null,"toplam bileşke yatay yük =",null,null,null,null,null,null,{"$f":"+W116","v":26.400000000000006},null,"+",{"$f":"+AI117","v":27.264000000000006},null,"=",{"$f":"+J118+M118","v":53.664000000000016},null,"KN"]
[null,null,"Panoya etkiyen rüzgar yükünden dolayı ayak dibinde oluşan  konsol momenti"]
[null,null,"M1 =",null,{"$f":"SUM(C122:D125)","v":1.7600000000000002},null,"*",{"$f":"SUM(I122:J125)","v":3},null,"*",{"$f":"SUM(G122:H125)","v":5},null,"*",{"$f":"SUM(M122:N125)","v":28.5},null,"+",{"$f":"SUM(E122:F125)","v":0},null,"*",{"$f":"SUM(K122:L125)","v":0},null,"*",{"$f":"SUM(G122:H125)","v":5},null,"*",{"$f":"SUM(O122:P125)","v":0},null,"=",{"$f":"+E120*H120*K120*N120+Q120*T120*W120*Z120","v":752.4000000000002},null,"KNm"]
[]
[null,null,{"$f":"IF(T87=\"\",0,T87)","v":0},null,null,null,{"$f":"IF(T87=\"\",0,G68)","v":0},null,{"$f":"IF(T87=\"\",0,N73)","v":0},null,null,null,{"$f":"IF(T87=\"\",0,P87-N73/2)","v":0}]
[null,null,{"$f":"IF(T78=\"\",0,T78)","v":0},null,{"$f":"IF(T78=\"\",0,IF(N73>AA78,T93,0))","v":0},null,{"$f":"IF(T78=\"\",0,G68)","v":0},null,{"$f":"IF(T78=\"\",0,IF(N73>AA78,AA78,N73))","v":0},null,{"$f":"IF(T78=\"\",0,IF(N73>AA78,N73-AA78,0))","v":0},null,{"$f":"IF(T78=\"\",0,P87-I123/2)","v":0},null,{"$f":"IF(K123=0,0,IF(T78=\"\",0,P87-(I123+K123/2)))","v":0}]
[null,null,{"$f":"IF(T75=\"\",0,T75)","v":1.7600000000000002},null,{"$f":"IF(T75=\"\",0,IF(N73>AA75,T86,0))","v":0},null,{"$f":"IF(T75=\"\",0,G68)","v":5},null,{"$f":"IF(T75=\"\",0,IF(N73>AA75,AA75,N73))","v":3},null,{"$f":"IF(T75=\"\",0,IF(N73>AA75,N73-AA75,0))","v":0},null,{"$f":"IF(T75=\"\",0,P87-I124/2)","v":28.5},null,{"$f":"IF(K124=0,0,IF(T75=\"\",0,P87-(I124+K124/2)))","v":0}]
[null,null,{"$f":"IF(T74=\"\",0,T74)","v":0},null,{"$f":"IF(T74=\"\",0,IF(N73>AA74,T82,0))","v":0},null,{"$f":"IF(T74=\"\",0,G68)","v":0},null,{"$f":"IF(T74=\"\",0,IF(N73>AA74,AA74,N73))","v":0},null,{"$f":"IF(T74=\"\",0,IF(N73>AA74,N73-AA74,0))","v":0},null,{"$f":"IF(T74=\"\",0,P87-I125/2)","v":0},null,{"$f":"IF(K125=0,0,IF(T74=\"\",0,P87-(I125+K125/2)))","v":0}]
[]
[null,null,{"$f":"IF(T87=\"\",0,T87)","v":0},null,null,null,null,null,null,null,{"$f":"IF(T87=\"\",0,G114)","v":0},null,{"$f":"IF(T87=\"\",0,N87)","v":0},null,null,null,null,null,null,null,{"$f":"IF(T87=\"\",0,N87/2)","v":0}]
[null,null,{"$f":"IF(T78=\"\",0,IF(N73>AA78,T93,T78))","v":0},null,{"$f":"IF(T78=\"\",0,IF(N87>=AA93,T93,0))","v":0},null,null,null,null,null,{"$f":"IF(T78=\"\",0,G114)","v":0},null,{"$f":"IF(T78=\"\",0,IF(N87>=AA93,N87-8,N87))","v":0},null,{"$f":"IF(T93=\"\",0,IF(N87>=AA93,AA93,0))","v":0},null,null,null,null,null,{"$f":"IF(T78=\"\",0,N87-M128/2)","v":0},null,{"$f":"IF(T78=\"\",0,N87-(M128+O128/2))","v":0}]
[null,null,{"$f":"IF(T75=\"\",0,IF(N73>AA75,0,T75))","v":1.7600000000000002},null,{"$f":"IF(T75=\"\",0,IF(N87>=AA86,T86,0))","v":1.2800000000000002},null,{"$f":"IF(T75=\"\",0,IF(N87>=AA96,T96,0))","v":0.8},null,null,null,{"$f":"IF(T75=\"\",0,G114)","v":0.8},null,{"$f":"IF(T75=\"\",0,IF(N73>AA75,0,IF(N87>=AA86,N87-20,N87)))","v":7},null,{"$f":"IF(T86=\"\",0,IF(N73>AA75,AA86+AA75-N73,IF(N87>=AA86,AA86,0)))","v":12},null,{"$f":"IF(T96=\"\",0,IF(N87>=AA96,AA96,0))","v":8},null,null,null,{"$f":"IF(T75=\"\",0,N87-M129/2)","v":23.5},null,{"$f":"IF(T75=\"\",0,N87-(M129+O129/2))","v":14},null,{"$f":"IF(T75=\"\",0,N87-(M129+O129+Q129/2))","v":4}]
[null,null,{"$f":"IF(T74=\"\",0,IF(N73>AA74,0,T74))","v":0},null,{"$f":"IF(T74=\"\",0,IF(N87>=AA82,T82,0))","v":0},null,{"$f":"IF(T74=\"\",0,IF(N87>=AA90,T90,0))","v":0},null,{"$f":"IF(T74=\"\",0,IF(N87>=AA98,T98,0))","v":0},null,{"$f":"IF(T74=\"\",0,G114)","v":0},null,{"$f":"IF(T74=\"\",0,IF(N73>AA74,0,IF(N87>=AA82,N87-100,N87)))","v":0},null,{"$f":"IF(T82=\"\",0,IF(N73>AA74,AA82+AA74-N73,IF(N87>=AA82,AA82,0)))","v":0},null,{"$f":"IF(T90=\"\",0,IF(N87>=AA90,AA90,0))","v":0},null,{"$f":"IF(T98=\"\",0,IF(N87>=AA98,AA98,0))","v":0},null,{"$f":"IF(T74=\"\",0,N87-M130/2)","v":0},null,{"$f":"IF(T74=\"\",0,N87-(M130+O130/2))","v":0},null,{"$f":"IF(T74=\"\",0,N87-(M130+O130+Q130/2))","v":0},null,{"$f":"IF(T74=\"\",0,N87-(M130+O130+Q130+S130/2))","v":0}]
[]
[null,null,"Ayak gövdesine etkiyen rüzgar yükünden dolayı ayak dibinde oluşan  konsol momenti"]
[null,null,"M2 =",null,{"$f":"SUM(C127:D130)","v":1.7600000000000002},null,"*",{"$f":"SUM(M127:N130)","v":7},null,"*",{"$f":"SUM(K127:L130)","v":0.8},null,"*",{"$f":"SUM(U127:V130)","v":23.5},null,"+",{"$f":"SUM(E127:F130)","v":1.2800000000000002},null,"*",{"$f":"SUM(O127:P130)","v":12},null,"*",{"$f":"SUM(K127:L130)","v":0.8},null,"*",{"$f":"SUM(W127:X130)","v":14},null,"+",{"$f":"SUM(G127:H130)","v":0.8},null,"*",{"$f":"SUM(Q127:R130)","v":8},null,"*",{"$f":"SUM(K127:L130)","v":0.8},null,"*",{"$f":"SUM(Y127:Z130)","v":4},null,"+"]
[null,null,null,null,{"$f":"SUM(I127:J130)","v":0},null,"*",{"$f":"SUM(S127:T130)","v":0},null,"*",{"$f":"SUM(K127:L130)","v":0.8},null,"*",{"$f":"SUM(AA127:AB130)","v":0},null,"=",{"$f":"E133*H133*K133*N133+Q133*T133*W133*Z133+AC133*AF133*AI133*AL133+E134*H134*K134*N134","v":424.1280000000001},null,"KNm"]
[]
[null,null,"Toplam ayak dibinde oluşan konsol momenti"]
[null,null,"M  =  M1  +  M2  =",null,null,null,null,{"$f":"+AC120","v":752.4000000000002},null,"+",{"$f":"+Q134","v":424.1280000000001},null,"=",{"$f":"+K137+H137","v":1176.5280000000002},null,"KNm"]
[]
[null,"BAYRAK DİREĞİ RÜZGAR YÜKÜ VE KONSOL MOMENTİ HESABI\n(Gürcan BERBEROĞLU tel: 0532 366 02 04   www.betoncelik.com )"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"dikkat sadece sarı hücrelere rakam giriniz."]
[null,null,null,null,null,null,null,null,null,15,null,"m"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+T199","v":2.2066188342236646},null,"KN"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"m"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AG147=\"\",\"\",\"1,6 * q =\")","v":""},null,null,{"$f":"IF(AG147=\"\",\"\",1.6*AJ185)","v":""},null,{"$f":"IF(AG147=\"\",\"\",\"KN/m²\")","v":""},null,null,null,null,{"$f":"IF(T160>100,T160-100,\"\")","v":""},null,{"$f":"IF(AG147=\"\",\"\",\"m\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AG148=\"\",\"\",\"1,6 * q =\")","v":"1,6 * q ="},null,null,{"$f":"IF(AG148=\"\",\"\",1.6*AJ184)","v":1.7600000000000002},null,{"$f":"IF(AG148=\"\",\"\",\"KN/m²\")","v":"KN/m²"},null,null,null,null,{"$f":"IF(AND(100>=T160,T160>20),T160-20,\"\")","v":10},null,{"$f":"IF(AG148=\"\",\"\",\"m\")","v":"m"}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AG151=\"\",\"\",\"1,6 * q =\")","v":""},null,null,{"$f":"IF(AG151=\"\",\"\",1.6*AJ183)","v":""},null,{"$f":"IF(AG151=\"\",\"\",\"KN/m²\")","v":""},null,null,null,null,{"$f":"IF(AND(20>=T160,T160>8),T160-8,\"\")","v":""},null,{"$f":"IF(AG151=\"\",\"\",\"m\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+T199","v":2.2066188342236646},null,"KN"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"bayrak"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AG155=\"\",\"\",\"1,6 * q =\")","v":""},null,null,{"$f":"IF(AG155=\"\",\"\",1.6*AJ184)","v":""},null,{"$f":"IF(AG155=\"\",\"\",\"KN/m²\")","v":""},null,null,null,null,{"$f":"IF(T160>100,80,\"\")","v":""},null,{"$f":"IF(AG155=\"\",\"\",\"m\")","v":""}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"m",null,"m",null,null,{"$f":"IF(AG159=\"\",\"\",\"1,6 * q =\")","v":"1,6 * q ="},null,null,{"$f":"IF(AG159=\"\",\"\",1.6*AJ183)","v":1.2800000000000002},null,{"$f":"IF(AG159=\"\",\"\",\"KN/m²\")","v":"KN/m²"},null,null,null,null,{"$f":"IF(AND(100>=T160,T160>20),12,\"\")","v":12},null,{"$f":"IF(AG159=\"\",\"\",\"m\")","v":"m"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+T160-R146","v":20},null,30,null,null,{"$f":"IF(AG160=\"\",\"\",\"1,6 * q =\")","v":""},null,null,{"$f":"IF(AG160=\"\",\"\",1.6*AJ182)","v":""},null,{"$f":"IF(AG160=\"\",\"\",\"KN/m²\")","v":""},null,null,null,null,{"$f":"IF(T160<=8,T160,\"\")","v":""},null,{"$f":"IF(AG160=\"\",\"\",\"m\")","v":""}]
[]
[]
[null,null,null,null,null,null,null,"ayak",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(T160<=8,1,IF(AND(9<=T160,T160<=20),2,IF(AND(21<=T160,T160<=100),3,IF(101<=T160,4,0))))","v":3},null,null,{"$f":"IF(AG163=\"\",\"\",\"1,6 * q =\")","v":""},null,null,{"$f":"IF(AG163=\"\",\"\",1.6*AJ183)","v":""},null,{"$f":"IF(AG163=\"\",\"\",\"KN/m²\")","v":""},null,null,null,null,{"$f":"IF(T160>100,12,\"\")","v":""},null,{"$f":"IF(AG163=\"\",\"\",\"m\")","v":""}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AG166=\"\",\"\",\"1,6 * q =\")","v":""},null,null,{"$f":"IF(AG166=\"\",\"\",1.6*AJ182)","v":""},null,{"$f":"IF(AG166=\"\",\"\",\"KN/m²\")","v":""},null,null,null,null,{"$f":"IF(AND(20>=T160,T160>8),8,\"\")","v":""},null,{"$f":"IF(AG166=\"\",\"\",\"m\")","v":""}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AG169=\"\",\"\",\"1,6 * q =\")","v":"1,6 * q ="},null,null,{"$f":"IF(AG169=\"\",\"\",1.6*AJ182)","v":0.8},null,{"$f":"IF(AG169=\"\",\"\",\"KN/m²\")","v":"KN/m²"},null,null,null,null,{"$f":"IF(AND(100>=T160,T160>20),8,\"\")","v":8},null,{"$f":"IF(AG169=\"\",\"\",\"m\")","v":"m"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AG171=\"\",\"\",\"1,6 * q =\")","v":""},null,null,{"$f":"IF(AG171=\"\",\"\",1.6*AJ182)","v":""},null,{"$f":"IF(AG171=\"\",\"\",\"KN/m²\")","v":""},null,null,null,null,{"$f":"IF(T160>100,8,\"\")","v":""},null,{"$f":"IF(AG171=\"\",\"\",\"m\")","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,"M"]
[null,null,null,null,null,null,null,null,null,null,"w= 1,2 * q (KN/m²)",null,null,null,null,null,"w= 0,4 * q (KN/m²)",null,null,null,null,null,"w= 1,6 * q (KN/m²)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TS 498 Kasım 1997"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"zeminden yükseklik",null,null,null,"rüzgar hızı\nv",null,null,"emme\nq"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"="]
[null,null,null,null,null,null,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,"(m/s)",null,null,"(KN/m²)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"~",8,null,28,null,null,0.5]
[null,null,{"$f":"+G183","v":0.02},null,{"$f":"+E185-G183*2","v":1.06},null,0.02,null,"m",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,"~",20,null,36,null,null,0.8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,21,"~",100,null,42,null,null,1.1000000000000001]
[null,null,null,null,1.1000000000000001,null,"m",null,null,null,null,null,"Ayak Çapı =",null,null,null,{"$f":"+E185","v":1.1000000000000001},null,"m",null,null,null,null,null,null,null,null,null,null,">",100,null,46,null,null,1.3]
[]
[null,null,"Bayrağın dalgalanmasıyla oluşan aerodinamik yük "]
[null,null,"W = Cf * q * A     (TS 498 madde 11.2.1)"]
[null,null,"W = bayrağın dalgalanmasıyla direğe etkiyen aerodinamik yük"]
[null,null,"A = bayrağın alanı"]
[null,null,"q = bayrak direğin üst noktasındaki rüzgar basıncıdır.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"q =",{"$f":"IF(8>=T160,AJ182,IF(AND(AC183<=T160,T160<=AE183),AJ183,IF(AND(AC184<=T160,T160<=AE184),AJ184,IF(T160>AE185,AJ185,\"hatalı\"))))","v":1.1000000000000001},null,"KN/m²"]
[null,null,"Cf = aerodinamik yük katsayısı Alman standartında DIN EN 1991-1-4:2010-12  de verilen bağıntı ile hesaplanacaktır.TS 498 'de verilmemiştir."]
[null,null,"Cf = 0,02 + 0,7 * m / ( p * e ) * ( A / e² )-1,25   ile hesaplanacaktır."]
[null,null,"m = bayrağın 1m² sinin kütlesi yaklaşık  0,15~0,20 kg/m²",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"m =",null,0.2,null,"kg/m²"]
[null,null,"p = 1 m3 havanın kütlesi yaklaşık 1,15~1,42 kg/m3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"p =",null,1.25,null,"kg/m3"]
[null,null,"e = bayrağın eni"]
[null,null,"Cf =",null,0.02,null,"+",0.7,null,"*",{"$f":"+U194","v":0.2},null," /(",{"$f":"+U195","v":1.25},null,"*",{"$f":"+R146","v":10},null,")*(",{"$f":"+J141","v":15},null,"*",{"$f":"+R146","v":10},null," /",{"$f":"+R146","v":10},null,"² )-1,25 =",null,null,{"$f":"E197+H197*K197/(N197*Q197)*(T197*W197/Z197^2)^-1.25","v":2.674689496028684E-2}]
[null,null,"W = Cf * q * A =",null,null,null,null,{"$f":"+AE197","v":2.674689496028684E-2},null,null,"*",{"$f":"+S191","v":1.1000000000000001},null,"*",{"$f":"+J141","v":15},null,"*",{"$f":"+R146","v":10},null,"=",{"$f":"H198*L198*O198*R198","v":4.4132376684473291},null,"KN"]
[null,null,"bayrağın takıldığı üst ve alt noktalarda W / 2 = ",null,null,null,null,null,null,null,null,null,null,null,{"$f":"+U198","v":4.4132376684473291},null," /",2,"=",{"$f":"+O199/R199","v":2.2066188342236646},null,"KN",null,"etki eder."]
[]
[null,null,"Ayak Bileşke yük  =  (",null,null,null,null,null,{"$f":"SUM(C206:D209)","v":1.7600000000000002},null,"*",{"$f":"SUM(M206:N209)","v":10},null,"+",{"$f":"SUM(E206:F209)","v":1.2800000000000002},null,"*",{"$f":"SUM(O206:P209)","v":12},null,"+",{"$f":"SUM(G206:H209)","v":0.8},null,"*",{"$f":"SUM(Q206:R209)","v":8},null,"+",{"$f":"SUM(I206:J209)","v":0},null,"*",{"$f":"SUM(S206:T209)","v":0},null,") *",{"$f":"SUM(K206:L209)","v":1.1000000000000001},null,"=",{"$f":"(I201*L201+O201*R201+U201*X201+AA201*AD201)*AG201","v":43.296000000000014},null,"KN"]
[null,null,"bayrak takıldığı üst ve alt ucu bileşke yük =",null,null,null,null,null,null,null,null,null,null,{"$f":"+U198","v":4.4132376684473291},null,"KN"]
[null,null,"toplam yatay bileşke yük =",null,null,null,null,null,null,{"$f":"+AJ201","v":43.296000000000014},null,"+",{"$f":"+N202","v":4.4132376684473291},null,"=",{"$f":"+J203+M203","v":47.709237668447344},null,"KN"]
[null,null,"Bayrağın takıldığı üst ve alt ucundaki aerodinamik yükten dolayı ayak dibinde oluşan  konsol momenti"]
[null,null,"M1 =",null,{"$f":"+T199","v":2.2066188342236646},null,"*",{"$f":"+T160","v":30},null,"+",{"$f":"+T199","v":2.2066188342236646},null,"*",{"$f":"+R160","v":20},null,"=",{"$f":"+E205*H205+K205*N205","v":110.33094171118324},null,"KNm"]
[null,null,{"$f":"IF(Z160=\"\",0,Z160)","v":0},null,null,null,null,null,null,null,{"$f":"IF(Z160=\"\",0,Q185)","v":0},null,{"$f":"IF(Z160=\"\",0,T160)","v":0},null,null,null,null,null,null,null,{"$f":"IF(Z160=\"\",0,T160/2)","v":0}]
[null,null,{"$f":"IF(Z151=\"\",0,IF(R146>AG151,Z166,Z151))","v":0},null,{"$f":"IF(Z151=\"\",0,IF(R160>=AG166,Z166,0))","v":0},null,null,null,null,null,{"$f":"IF(Z151=\"\",0,Q185)","v":0},null,{"$f":"IF(Z151=\"\",0,IF(T160>=AG166,T160-8,T160))","v":0},null,{"$f":"IF(Z166=\"\",0,IF(T160>=AG166,AG166,0))","v":0},null,null,null,null,null,{"$f":"IF(Z151=\"\",0,T160-M207/2)","v":0},null,{"$f":"IF(Z151=\"\",0,T160-(M207+O207/2))","v":0}]
[null,null,{"$f":"IF(Z148=\"\",0,IF(R146>AG148,0,Z148))","v":1.7600000000000002},null,{"$f":"IF(Z148=\"\",0,IF(R160>=AG159,Z159,0))","v":1.2800000000000002},null,{"$f":"IF(Z148=\"\",0,IF(R160>=AG169,Z169,0))","v":0.8},null,null,null,{"$f":"IF(Z148=\"\",0,Q185)","v":1.1000000000000001},null,{"$f":"IF(Z148=\"\",0,IF(T160>=AG159,T160-20,T160))","v":10},null,{"$f":"IF(Z159=\"\",0,IF(T147>AG148,AG159+AG148-T147,IF(T160>=AG159,AG159,0)))","v":12},null,{"$f":"IF(Z169=\"\",0,IF(T160>=AG169,AG169,0))","v":8},null,null,null,{"$f":"IF(Z148=\"\",0,T160-M208/2)","v":25},null,{"$f":"IF(Z148=\"\",0,T160-(M208+O208/2))","v":14},null,{"$f":"IF(Z148=\"\",0,T160-(M208+O208+Q208/2))","v":4}]
[null,null,{"$f":"IF(Z147=\"\",0,IF(R146>AG147,0,Z147))","v":0},null,{"$f":"IF(Z147=\"\",0,IF(R160>=AG155,Z155,0))","v":0},null,{"$f":"IF(Z147=\"\",0,IF(R160>=AG163,Z163,0))","v":0},null,{"$f":"IF(Z147=\"\",0,IF(R160>=AG171,Z171,0))","v":0},null,{"$f":"IF(Z147=\"\",0,Q185)","v":0},null,{"$f":"IF(Z147=\"\",0,IF(T160>=AG155,T160-100,T160))","v":0},null,{"$f":"IF(Z155=\"\",0,IF(T147>AG147,AG155+AG147-T147,IF(T160>=AG155,AG155,0)))","v":0},null,{"$f":"IF(Z163=\"\",0,IF(T160>=AG163,AG163,0))","v":0},null,{"$f":"IF(Z171=\"\",0,IF(T160>=AG171,AG171,0))","v":0},null,{"$f":"IF(Z147=\"\",0,T160-M209/2)","v":0},null,{"$f":"IF(Z147=\"\",0,T160-(M209+O209/2))","v":0},null,{"$f":"IF(Z147=\"\",0,T160-(M209+O209+Q209/2))","v":0},null,{"$f":"IF(Z147=\"\",0,T160-(M209+O209+Q209+S209/2))","v":0}]
[]
[null,null,"Ayak gövdesine etkiyen rüzgar yükünden dolayı ayak dibinde oluşan  konsol momenti"]
[null,null,"M2 =",null,{"$f":"SUM(C206:D209)","v":1.7600000000000002},null,"*",{"$f":"SUM(M206:N209)","v":10},null,"*",{"$f":"SUM(K206:L209)","v":1.1000000000000001},null,"*",{"$f":"SUM(U206:V209)","v":25},null,"+",{"$f":"SUM(E206:F209)","v":1.2800000000000002},null,"*",{"$f":"SUM(O206:P209)","v":12},null,"*",{"$f":"SUM(K206:L209)","v":1.1000000000000001},null,"*",{"$f":"SUM(W206:X209)","v":14},null,"+",{"$f":"SUM(G206:H209)","v":0.8},null,"*",{"$f":"SUM(Q206:R209)","v":8},null,"*",{"$f":"SUM(K206:L209)","v":1.1000000000000001},null,"*",{"$f":"SUM(Y206:Z209)","v":4},null,"+"]
[null,null,null,null,{"$f":"SUM(I206:J209)","v":0},null,"*",{"$f":"SUM(S206:T209)","v":0},null,"*",{"$f":"SUM(K206:L209)","v":1.1000000000000001},null,"*",{"$f":"SUM(AA206:AB209)","v":0},null,"=",{"$f":"E212*H212*K212*N212+Q212*T212*W212*Z212+AC212*AF212*AI212*AL212+E213*H213*K213*N213","v":748.70400000000006},null,"KNm"]
[]
[null,null,"Toplam ayak dibinde oluşan konsol momenti"]
[null,null,"M  =  M1  +  M2  =",null,null,null,null,{"$f":"+Q205","v":110.33094171118324},null,"+",{"$f":"+Q213","v":748.70400000000006},null,"=",{"$f":"+K216+H216","v":859.03494171118336},null,"KNm"]

{"sheet":"Sheet2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}