{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Sheet1","Sheet2","Sheet3"],"not_rendered":{"charts":0,"images":0,"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":68,"n_cols":43,"rows_kept":68,"cut":false,"hidden":false,"merged":[[1,2,1,43],[67,19,67,20],[67,22,67,23],[67,25,67,26],[67,30,67,31],[60,25,60,26],[65,25,65,26],[59,16,59,17],[59,19,59,20],[64,17,64,18],[61,39,61,40],[60,22,60,23],[60,28,60,29],[60,31,60,32],[61,34,61,35],[64,20,64,21],[66,40,66,41],[62,22,62,23],[62,25,62,26],[62,30,62,31],[64,28,64,29],[66,24,66,25],[66,27,66,28],[66,30,66,31],[66,35,66,36],[65,22,65,23],[65,28,65,29],[65,31,65,32],[65,36,65,37],[61,29,61,30],[64,23,64,24],[54,5,54,6],[56,5,56,6],[56,8,56,9],[56,11,56,12],[57,5,57,6],[62,19,62,20],[53,11,53,12],[61,23,61,24],[61,26,61,27],[45,14,45,15],[32,12,32,13],[34,17,36,17],[51,19,51,20],[35,21,37,21],[40,21,42,21],[40,7,42,7],[20,7,22,7],[21,9,23,9],[50,13,50,14],[30,12,30,13],[20,6,22,6],[34,10,34,11],[33,9,33,10],[16,9,16,10],[60,36,60,37],[59,22,59,23],[59,27,59,28],[56,14,56,15],[53,28,53,29],[53,14,53,15],[53,17,53,18],[53,20,53,21],[53,23,53,24],[53,5,53,6],[53,8,53,9],[40,6,42,6],[18,13,18,14],[16,17,16,18],[12,16,12,17],[12,6,12,7],[14,6,14,7],[21,49,21,51],[24,49,24,51],[35,20,37,20],[40,20,42,20],[4,5,4,6],[4,13,4,14],[5,17,5,18],[9,16,9,17],[10,16,10,17],[25,14,25,15],[27,14,27,15],[8,34,8,35],[4,22,4,23],[12,21,12,22],[11,16,11,17],[14,21,14,22]]}
[]
[null,null,"SAPLAMALI KİRİŞ HESAP KESME KUVVETİ VE MOMENT HESABI\n(inş.müh. 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,"dikkat sadece sarı hücrelere rakam giriniz."]
[]
[null,null,null,"Ma =",null,125,null,"KNm",null,null,null,null,"P=",35,null,"KN",null,null,null,null,"Mb =",null,135,null,"KNm"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"q=",15,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,null,null,null,null,"d =",0.65,null,"m"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"G13-J17*R6","v":52.5}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"G13-J17*R6-N5","v":17.5}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(V29=1,J17+Q11*R17/(Q11-V36),IF(V29=2,J17,0))","v":5.166666666666667}]
[null,null,null,null,null,"A =",{"$f":"+F58","v":112.5},null,"KN",null,null,null,null,null,null,null,{"$f":"G21*J17/(G21-Q10)","v":7.5},null,null,null,"B =",{"$f":"+F55","v":102.5},null,"KN"]
[]
[null,null,null,null,null,"a1=",0.35,null,"m",null,null,null,null,null,null,null,null,null,null,null,"a2=",0.5,null,"m","(mesnet genişliği)"]
[]
[null,null,null,null,null,null,null,null,"a=",4,null,"m",null,null,null,null,"b=",8,null,"m"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"L=",{"$f":"+J17+R17","v":12},null,"m"]
[]
[null,null,null,null,null,null,{"$f":"+F58","v":112.5},{"$f":"+AB60","v":109.875}]
[null,null,null,null,null,null,null,null,null,{"$f":"+AK61","v":100.125}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(V29=1,V29=2),F58-J17*R6,\"\")","v":52.5},null,null,null,null,null,null,null,null,null,null,"kesme kuvveti diyagramı (KN)"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(V29=1,F58-J17*R6-N5,\"\")","v":17.5},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"kolon eksen"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND((F58-J17*R6)>0,(F58-J17*R6-N5)>0),1,IF(AND((F58-J17*R6)>0,(F58-J17*R6-N5)<0),2,IF(AND((F58-J17*R6)<0,(F58-J17*R6-N5)<0),3,\"hatalı\")))","v":1},null,null,null,null,null,null,null,"kolon yüzü"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"kolon yüzünden d mesafede"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(V29=3,F58-J17*R6,\"\")","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(V29=2,V29=3),F58-J17*R6-N5,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(V29=3,G21*J17/(G21-M31),\"\")","v":""},null,{"$f":"IF(V29=3,\"m\",\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(V29=1,J17+Q11*R17/(Q11-V36),IF(V29=2,J17,\"\"))","v":5.166666666666667},null,{"$f":"IF(OR(V29=1,V29=2),\"m\",\"\")","v":"m"},null,null,null,null,{"$f":"-AK66","v":-89}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"-AC65","v":-98.75},{"$f":"-F55","v":-102.5}]
[]
[]
[]
[]
[null,null,null,null,null,null,{"$f":"+F5","v":125},{"$f":"+AN62","v":105.5421875},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+AO67","v":109.84375},{"$f":"+W5","v":135}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"moment diyagramı (KNm)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(V29=1,(F5-(G21+Q10)/2*J17-Q11*(Q12-J17)/2)>0),(F5-(G21+Q10)/2*J17-Q11*(Q12-J17)/2),IF(AND(V29=2,(F5-(G21+Q10)/2*Q12)>0),(F5-(G21+Q10)/2*Q12),IF(AND(V29=3,(F5-F58*Q13/2)>0),(F5-F58*Q13/2),\"\")))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(V29=1,(F5-(G21+Q10)/2*J17-Q11*(Q12-J17)/2)<0),1,IF(AND(V29=1,(F5-(G21+Q10)/2*J17-Q11*(Q12-J17)/2)>0),2,IF(AND(V29=2,(F5-(G21+Q10)/2*Q12)<0),3,IF(AND(V29=2,(F5-(G21+Q10)/2*Q12)>0),4,IF(AND(V29=3,(F5-F58*Q13/2)<0),5,IF(AND(V29=3,(F5-F58*Q13/2)>0),6,\"hatalı\"))))))","v":1},null,null,null,null,null,null,null,"kolon eksen"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"kolon yüzü"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(V29=1,(F5-(G21+Q10)/2*J17-Q11*(Q12-J17)/2)<0),(F5-(G21+Q10)/2*J17-Q11*(Q12-J17)/2),IF(AND(V29=2,(F5-(G21+Q10)/2*Q12)<0),(F5-(G21+Q10)/2*Q12),IF(AND(V29=3,(F5-F58*Q13/2)<0),(F5-F58*Q13/2),\"\")))","v":-215.20833333333334}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(V29=3,(F5*J17/(F5+W5))<0),(F5*J17/(F5+W5)),\"\")","v":""}]
[null,null,null,null,"B = ( Mb - Ma + P * a + q * L * L / 2 ) / L"]
[null,null,null,null,"B=(",{"$f":"+W5","v":135},null,"-",{"$f":"+F5","v":125},null,"+",{"$f":"+N5","v":35},null,"*",{"$f":"+J17","v":4},null,"+",{"$f":"+R6","v":15},null,"*",{"$f":"+N19","v":12},null,"*",{"$f":"+N19","v":12},null," /",2,") /",{"$f":"+N19","v":12}]
[null,null,null,null,"B =",{"$f":"(F54-I54+L54*O54+R54*U54*X54/AA54)/AC54","v":102.5},null,"KN"]
[null,null,null,null,"A= P + q * L - B"]
[null,null,null,null,"A=",{"$f":"+N5","v":35},null,"+",{"$f":"+R6","v":15},null,"*",{"$f":"+N19","v":12},null,"-",{"$f":"+F55","v":102.5}]
[null,null,null,null,"A=",{"$f":"+F57+I57*L57-O57","v":112.5},null,"KN"]
[]
[null,null,null,null,"sol mesnet yüzü kesme kuvveti = A - q * a1 / 2 =",null,null,null,null,null,null,null,null,null,null,null,{"$f":"+F58","v":112.5},null,"-",{"$f":"+R6","v":15},null,"*",{"$f":"+G15","v":0.35},null," /",2,"=",{"$f":"+Q60-T60*W60/Z60","v":109.875},null,"KN"]
[null,null,null,null,"sol mesnet yüzünden d mesafede kesme kuvveti = A - q * ( d + a1 / 2 ) =",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+F58","v":112.5},null," - ",{"$f":"+R6","v":15},null,"* (",{"$f":"+AI9","v":0.65},null,"+",{"$f":"+G15","v":0.35},null," /",2,") =",{"$f":"+W61-Z61*(AC61+AF61/AI61)","v":100.125},null,"KN"]
[null,null,null,null,"sol mesnet yüzü moment = Ma - ( A + mesnet yüzü kesme kuv.) / 2 * a1 / 2 =",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+F5","v":125},null," - (",{"$f":"+F58","v":112.5},null,"+",{"$f":"+AB60","v":109.875},null,") /",2,"*",{"$f":"+G15","v":0.35},null," /",2,"=",{"$f":"X62-(AA62+AD62)/AG62*AI62/AL62","v":105.5421875},null,"KNm"]
[null,null,null,null,"TS 500 'e göre sol mesnet yüzü moment =  Ma - A * a1 / 3 =",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+F5","v":125},null,"-",{"$f":"+F58","v":112.5},null,"*",{"$f":"+G15","v":0.35},null," /",3,"=",{"$f":"T63-W63*Z63/AC63","v":111.875},null,"KNm"]
[]
[null,null,null,null,"sağ mesnet yüzü kesme kuvveti = B - q * a2 / 2 =",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+F55","v":102.5},null,"-",{"$f":"+R6","v":15},null,"*",{"$f":"+V15","v":0.5},null," /",2,"=",{"$f":"+R65-U65*X65/AA65","v":98.75},null,"KN"]
[null,null,null,null,"sağ mesnet yüzünden d mesafede kesme kuvveti = B - q * ( d + a2 / 2 ) =",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+F55","v":102.5},null," - ",{"$f":"+R6","v":15},null,"* (",{"$f":"+AI9","v":0.65},null,"+",{"$f":"+V15","v":0.5},null," /",2,") =",{"$f":"+W66-Z66*(AC66+AF66/AI66)","v":89},null,"KN"]
[null,null,null,null,"sağ mesnet yüzü moment = Mb - ( B + mesnet yüzü kesme kuv.) / 2 * a2 / 2 =",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+W5","v":135},null," - (",{"$f":"+F55","v":102.5},null,"+",{"$f":"+AC65","v":98.75},null,") /",2,"*",{"$f":"+V15","v":0.5},null," /",2,"=",{"$f":"Y67-(AB67+AE67)/AH67*AJ67/AM67","v":109.84375},null,"KNm"]
[null,null,null,null,"TS 500 'e göre sağ mesnet yüzü moment =  Mb - B * a2 / 3 =",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+W5","v":135},null,"-",{"$f":"+F55","v":102.5},null,"*",{"$f":"+V15","v":0.5},null," /",3,"=",{"$f":"T68-W68*Z68/AC68","v":117.91666666666667},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":[]}