{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Input","Output","Calculator","Help"],"not_rendered":{"charts":0,"images":7,"macros":1,"external_links":0,"defined_names":2,"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":"Input","index":0,"n_rows":15,"n_cols":13,"rows_kept":15,"cut":false,"hidden":false,"merged":[[16,0,17,0],[3,1,4,1],[3,4,4,4],[14,0,15,8],[16,8,17,8],[16,7,17,7],[16,5,16,6],[16,4,17,4],[16,3,17,3],[16,2,17,2],[16,1,17,1],[3,5,3,6],[0,0,1,8],[1,12,1,13],[3,7,4,7],[3,8,4,8],[3,2,4,2],[3,3,4,3],[3,0,4,0]]}
["Punching Shear Check & Design (ACI 318-08 ) (By Nima Salary)"]
[null,null,null,null,null,null,null,null,null,null,null,"Units","kg-cm"]
[]
["Col. ID","Vu","Mux(2)","Muy(3)","Type","Col. Dim. (cm)",null,"Ratio","check"]
[null,null,null,null,null,"C1","C2"]
[1,29792.13,30719.57,597936,3,35,35,{"$f":"IF(E6=1,Calculator!L3,IF(E6=2,Calculator!L4,Calculator!L5))","v":1.4487946532232761},{"$f":"IF(H6<=1,\"Ok\",\"Not Ok\")","v":"Not Ok"}]
[]
["f'c",210,"Kgf.cm2",null,"Type","Location"]
["H",50,"cm",null,1,"Interior"]
["cover",8.8000000000000007,"cm",null,2,"Edge"]
[null,null,null,null,3,"Corner"]
[]
[]
[]
["* Fill Blue Text Cells and Select type of Column for Calculate Punching…"]

{"sheet":"Output","index":1,"n_rows":12,"n_cols":10,"rows_kept":12,"cut":false,"hidden":false,"merged":[[3,9,6,11],[2,0,3,8],[4,0,5,8],[6,0,7,0],[6,1,7,1],[6,2,7,2],[6,3,7,3],[6,4,7,4],[6,5,6,6],[6,7,7,7],[6,8,7,8]]}
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Do not Remove This Sheet"]
["Punching Shear Check & Design (ACI 318-08 )"]
[]
["Col. ID","Vu","Mux","Muy","Type","Col. Dim. (cm)",null,"Ratio","check"]
[null,null,null,null,null,"C1","C2"]
[1,29792.13,30719.57,597936,3,35,35,1.4487946532232761,"Not Ok"]
[1,29792.13,30719.57,597936,2,35,35,0.45502070768757447,"Ok"]
[1,29792.13,30719.57,597936,2,35,35,0.45502070768757447,"Ok"]
[1,29792.13,30719.57,597936,2,35,35,0.45502070768757447,"Ok"]

{"sheet":"Calculator","index":2,"n_rows":30,"n_cols":13,"rows_kept":30,"cut":false,"hidden":false,"merged":[[7,0,7,2],[7,5,7,7],[7,10,7,12],[26,7,27,7],[28,7,29,7],[26,12,27,12],[28,12,29,12]]}
[]
["Vu",{"$f":"Input!B6","v":29792.13},"Kgf",null,null,"f'c",{"$f":"Input!B8","v":210},"Kgf.cm",null,"Type","Location","Ratio"]
["Mux",{"$f":"Input!C6","v":30719.57},"Kgf.cm",null,null,"H",{"$f":"Input!B9","v":50},"cm",null,1,"Interior",{"$f":"B23","v":0.26969664238718194}]
["Muy",{"$f":"Input!D6","v":597936},"Kgf.cm",null,null,"cover",{"$f":"Input!B10","v":8.8000000000000007},"cm",null,2,"Edge",{"$f":"L23","v":0.45502070768757447}]
["C1",{"$f":"Input!F6","v":35},"cm",null,null,null,null,null,null,3,"Corner",{"$f":"G23","v":1.4487946532232761}]
["C2",{"$f":"Input!G6","v":35},"cm"]
[]
["Interior",null,null,null,null,"Corner",null,null,null,null,"Edge"]
["C1",{"$f":"$B$5","v":35},"cm",null,null,"C1",{"$f":"$B$5","v":35},"cm",null,null,"C1",{"$f":"$B$5","v":35},"cm"]
["C2",{"$f":"$B$6","v":35},"cm",null,null,"C2",{"$f":"$B$6","v":35},"cm",null,null,"C2",{"$f":"$B$6","v":35},"cm"]
["d",{"$f":"$G$3-$G$4","v":41.2},"cm",null,null,"d",{"$f":"$G$3-$G$4","v":41.2},"cm",null,null,"d",{"$f":"$G$3-$G$4","v":41.2},"cm"]
["b1",{"$f":"B9+B11","v":76.2},"cm",null,null,"b1",{"$f":"G9+G11/2","v":55.6},"cm",null,null,"b1",{"$f":"L9+L11","v":76.2},"cm"]
["b2",{"$f":"B10+B11","v":76.2},"cm",null,null,"b2",{"$f":"G10+G11/2","v":55.6},"cm",null,null,"b2",{"$f":"L10+L11/2","v":55.6},"cm"]
["d",{"$f":"B11","v":41.2},"cm",null,null,"d",{"$f":"G11","v":41.2},"cm",null,null,"d",{"$f":"L11","v":41.2},"cm"]
["b0",{"$f":"B12*4","v":304.8},"cm",null,null,"b0",{"$f":"G12+G13","v":111.2},"cm",null,null,"b0",{"$f":"L12+2*L13","v":187.4},"cm"]
["Ac",{"$f":"B15*B14","v":12557.760000000002},null,null,null,"Ac",{"$f":"G15*G14","v":4581.4400000000005},null,null,null,"Ac",{"$f":"L15*L14","v":7720.880000000001}]
["ᵞ v",{"$f":"1-(1/(1+(SQRT(B12/B13)*(2/3))))","v":0.39999999999999991},null,null,null,"ᵞ",{"$f":"1-(1/(1+(SQRT(G12/G13)*(2/3))))","v":0.39999999999999991},null,null,null,"ᵞ",{"$f":"1-(1/(1+(SQRT(L12/L13)*(2/3))))","v":0.43834636232598279}]
["β",{"$f":"MAX((B9/B10),(B10/B9))","v":1},null,null,null,"β",{"$f":"MAX((G9/G10),(G10/G9))","v":1},null,null,null,"β",{"$f":"MAX((L9/L10),(L10/L9))","v":1}]
["α s",40,null,null,null,"α s",20,null,null,null,"α s",30]
["k",{"$f":"MIN(2,(1+2/B18),(1+(B19*B14/2*B15)))","v":2},null,null,null,"k",{"$f":"MIN(2,(1+(2/G18)),(1+(G19*G14/2*G15)))","v":2},null,null,null,"k",{"$f":"MIN(2,(1+2/L18),(1+(L19*L14/2*L15)))","v":2}]
["vc",{"$f":"B20*0.53*SQRT(G2)*0.75","v":11.520644513220603},null,null,null,"vc",{"$f":"G20*0.53*SQRT(G2)*0.75","v":11.520644513220603},null,null,null,"vc",{"$f":"L20*0.53*SQRT(G2)*0.75","v":11.520644513220603}]
["vu",{"$f":"($B$2/B16)+($B$3*B17/B27)+($B$4*B17/B27)","v":3.1070791433519065},null,null,null,"vu",{"$f":"($B$2/G16)+($B$3*G17/H27)+($B$4*G17/H29)","v":16.69104817244008},null,null,null,"vu",{"$f":"($B$2/L16)+($B$3*L17/M27)+($B$4*L17/M29)","v":5.2421318194226103}]
["Ratio",{"$f":"B22/B21","v":0.26969664238718194},null,null,null,"Ratio",{"$f":"G22/G21","v":1.4487946532232761},null,null,null,"Ratio",{"$f":"L22/L21","v":0.45502070768757447}]
[]
[]
[]
["J\\C",{"$f":"(B12*B14*(B12+3*B13)+B14^3)/3","v":342278.6133333334},null,null,null,"Jx\\Cy",{"$f":"(G11*(G12+4*G13)+G11^3*(G12+G13))/(6*G12)","v":23345.842666666671},{"$f":"MIN(G27:G28)","v":12943.821333333335},null,null,"Jx\\Cy",{"$f":"(2*L13^2*L14*(L13+2*L12)+L14^3*(2*L13+L12))/(6*L13)","v":198109.0163645084},{"$f":"MIN(L27:L28)","v":83572.544080930704}]
[null,null,null,null,null,"Jx\\Cy",{"$f":"(G12^2*(G12+4*G13)+G14^3*(G12+G13))/(6*(G12+G13))","v":12943.821333333335},null,null,null,"Jx\\Cy",{"$f":"(2*L13^2*L14*(L13+2*L12)+L14^3*(2*L13+L12))/(6*(L12+L13))","v":83572.544080930704}]
[null,null,null,null,null,"Jy\\Cx",{"$f":"(G12^2*(G12+4*G13)+G14^3*(G12+G13))/(6*G13)","v":25887.64266666667},{"$f":"MIN(G29:G30)","v":25887.64266666667},null,null,"Jy\\Cx",{"$f":"(L12*L14*(L12+L13*6))/6","v":214423.75200000007},{"$f":"MIN(L29:L30)","v":214423.75200000007}]
[null,null,null,null,null,"Jy\\Cc",{"$f":"(G13^2*G14*(G13+4*G12)+G14^3*(G12+G13))/(6*(G13+2*G12))","v":43149.400888888893},null,null,null,"Jy\\Cc",{"$f":"(L12*L14*(L12+L13*6)+L14^3)/6","v":226079.50666666671}]

{"sheet":"Help","index":3,"n_rows":5,"n_cols":15,"rows_kept":5,"cut":false,"hidden":false,"merged":[[1,12,1,19],[2,12,2,19],[0,12,0,19],[4,14,4,19],[3,13,3,19]]}
[null,null,null,null,null,null,null,null,null,null,null,null,"به نام یکتا مهندس هستی"]
[null,null,null,null,null,null,null,null,null,null,null,null,"تهیه کننده:     "]
[null,null,null,null,null,null,null,null,null,null,null,null,"نیما سالاری"]
[null,null,null,null,null,null,null,null,null,null,null,null,null," By: Nima.Salary@Gmail.com"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"www.farscivil.ir"]