{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["~#temp","Centre Heave","Edge Heave"],"not_rendered":{"charts":4,"images":53,"macros":1,"external_links":0,"defined_names":62,"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":"~#temp","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Centre Heave","index":1,"n_rows":59,"n_cols":18,"rows_kept":59,"cut":false,"hidden":false,"merged":[]}
["Residential Footing Design - Mitchell Method (1984) (V20171106)",null,null,null,null,null,null,null,"JRB STRUCTURAL ENGINEERING PTY LTD","Notes:"]
[null,null,null,null,null,null,null,null,null,"click \"Re-Calculate\" after making any changed to inputs"]
["Centre Heave - Inputs"]
[]
[]
[null,"x =",3.5125000000000002,"m",null,null,null,null,"distance from centre of footing (0<x<L/2) - Nominal","Designer can input any valid value for x to calculate moment at any given point",null,null,null,null,null,null,4.2249999999999996,3]
[null,"L =",12,"m",null,null,null,null,"overall length of footing",null,null,null,null,null,null,null,14.05,12]
[null,"B =",1,"m",{"$f":"IF(rng_B<>1,\"usually take B equals 1m\",\"\")","v":""},null,null,null,"take unit width of footing",null,null,null,null,null,null,null,1,1]
[null,"W =",10,"kN/m",null,null,null,null,"edge line load applied to footing",null,null,null,null,null,null,null,30,10]
[null,"T =",0,"kN/m",null,null,null,null,"centre line load applied to footing",null,null,null,null,null,null,null,30,0]
[null,"w =",6.5,"kPa",null,null,null,null,"uniform load applied to footing",null,null,null,null,null,null,null,3,6.5]
[null,"Y =",7.4999999999999997E-2,"m",null,null,null,null,"free soil heave",null,null,null,null,null,null,null,0.02,7.4999999999999997E-2]
[null,"Δ =",1.2E-2,"m",null,null,null,null,"design deflection limit","A solution may not be possible with D approaches the value of Y ",{"$f":"(C19)/(C15*(C12*10^-3))","v":108.88888888888889},null,null,null,null,null,7.0000000000000001E-3,1.2E-2]
[null,"m =",5,null,null,null,null,null,"exponent (refer AS2870)",null,null,null,null,null,null,null,21,5]
[null,"k =",1000,"kPa/m",null,null,null,null,"modulus of subgrade reaction",null,null,null,null,null,null,null,2500,1000]
[]
["Centre Heave - Calculations"]
[]
[null,"ω =",{"$f":"rng_w_small+(2*rng_W_big+rng_Tload)/rng_L","v":8.1666666666666661},null,null,null,null,null,"uniform pressure"]
[null,"t =",1.7407173938981071,null,null,null,null,null,"solved numerically at x=L/4"]
[null,"C =",0.75573920186502153,{"$f":"IF(rng_C<0,\"Warning: negative value for C\",\"\")","v":""},null,null,null,null,"solved numerically at x=L/4"]
[null,"fC =",{"$f":"C21^(C14+1)*C14/(C14+1)-C21^(C20+1)*C20/(C20+1)*(C13/C12)-C19/(C15*C12)","v":-7.9889341989090867E-4},null,null,null,null,null,"equaction to solve for \"C\""]
[]
[null,"δο=",{"$f":"C21^C14*C12-C21^C20*C13","v":1.1119430260428852E-2}]
[null,"Mx  =",{"$f":"C9*C8*(C7/2-C6)+(C11*C8/2)*(C7/2-C6)^2","v":44.984882812499997},null,null,null,null,null,"CL/2<x<L/2"]
[null,"CL=",{"$f":"C21*C7","v":9.0688704223802574},null,null,null,null,null,"Total length of slab in contact with ground"]
[]
[null,"A4.1 =",{"$f":"C24*(C26^(2)/8)+(2/C7)^(C20)*(C26/2)^(C20+2)*(C13/(C20+2))-((2/C7)^(C14)*(C26/2)^(C14+2)*(C12/(C14+2)))","v":0.1005142859776704}]
[null,"A4.2 =",{"$f":"-C24*(C26/2)*C6-(2/C7)^rng_t*(C26/2)^(rng_t+1)*(C13*C6)/(rng_t+1)+(2/C7)^C14*(C26/2)^(C14+1)*(C12*C6/(C14+1))","v":-0.17084974908818495}]
[null,"A4.3 =",{"$f":"C24*C6^2/2 + (2/C7)^C20*C6^(C20+2)*C13/((C20+1)*(C20+2))-(2/C7)^C14*C6^(C14+2)*C12/((C14+1)*(C14+2))","v":7.2765137851764264E-2}]
[null,"Mx.neg =",{"$f":"C25-C15*C8*(C28+C29+C30)","v":42.555208071250291},null,null,null,null,null,"0<x<CL/2"]
[]
[null,"M#=",{"$f":"IF(C6>=0,IF(C6<rng_C*C7/2,C31,C25),NA())","v":42.555208071250291},null,null,null,null,null,"ULS moment @ x"]
[]
[null,"A5.1 =",{"$f":"C9*C8*C6^2/2*(C7/2-C6/3)+C11*C8*C6^2/4*(C7^2/4-C7*C6/3+C6^2/6)","v":779.19741170908617}]
[null,"A5.2 =",{"$f":"C24/4*(C26/2)^2*C6^2+(2/C7)^rng_t*(C26/2)^(rng_t+2)*C13*C6^2/(2*(rng_t+2))-(2/C7)^C14*(C26/2)^(C14+2)*C12*C6^2/(2*(C14+2))","v":0.62005535430334646}]
[null,"A5.3 =",{"$f":"-C24*(C26/2)*C6^3/6-(2/C7)^rng_t*(C26/2)^(rng_t+1)*C13*C6^3/(6*(rng_t+1))+(2/C7)^C14*(C26/2)^(C14+1)*C12*C6^3/(6*(C14+1))","v":-0.3513142457747962}]
[null,"A5.4 =",{"$f":"+C24*C6^4/24+(2/C7)^rng_t*C6^(rng_t+4)*C13/((rng_t+1)*(rng_t+2)*(rng_t+3)*(rng_t+4))","v":7.3101692399379428E-2}]
[null,"A5.5 =",{"$f":"-(2/C7)^C14*C6^(C14+4)*C12/((C14+1)*(C14+2)*(C14+3)*(C14+4))","v":-2.5957939797183747E-4}]
[null,"EIδ=",{"$f":"C35-C15*C8*(C36+C37+C38+C39)","v":437.61419017912834}]
[]
[null,"A6.1 =",{"$f":"C9*C8*C7^3/24+C11*C8*C7^4/128","v":1773}]
[null,"A6.2 =",{"$f":"C24/6*(C26/2)^3*(C7/2)","v":1.0366977079640778}]
[null,"A6.3 =",{"$f":"(2/C7)^rng_t*(C26/2)^(rng_t+3)*C13/(2*(rng_t+3))*(C7/2)-(2/C7)^C14*(C26/2)^(C14+3)*C12/(2*(C14+3))*(C7/2)-C24/24*(C26/2)^4","v":-0.40748038368402084}]
[null,"A6.4 =",{"$f":"-((2/C7)^rng_t)*(C26/2)^(rng_t+4)*C13/(6*(rng_t+4))+(2/C7)^C14*(C26/2)^(C14+4)*C12/(6*(C14+4))","v":5.4294664419383618E-2}]
[null,"EIΔ=",{"$f":"C42-C15*C8*(C43+C44+C45)","v":1089.4880113005595}]
[]
[null,"EIrequired=",{"$f":"rng_EIDELTA_big/rng_DELTA_big","v":90790.667608379954},null,null,null,null,null,"required stiffness"]
[]
[null,"tnext =",{"$f":"LOG(C40/C46,(2*C6/C7))","v":1.7035336622326795},null,null,null,null,null,"resolve for t"]
["Centre Heave - Summary"]
[]
[null,null,"Dist x from centreline\nm ","Moment M#\nkNm/m","Free soil heave \nmm","Footing Movement mm","Soil Pressure\nkPa"]
[null,null,{"$f":"0","v":0},76.485714022329603,0,11.119430260428851,{"$f":"rng_k*MAX(0,(F54-E54))/1000","v":11.119430260428851}]
[null,null,{"$f":"C54+rng_L/10","v":1.2},72.626811731806839,2.399999999999999E-2,11.720391372551877,{"$f":"rng_k*MAX(0,(F55-E55))/1000","v":11.696391372551878}]
[null,null,{"$f":"C55+rng_L/10","v":2.4},61.056283939170356,0.76799999999999968,13.463102396763107,12.695102396763108]
[null,null,{"$f":"C56+rng_L/10","v":3.5999999999999996},40.822838098780117,5.831999999999999,16.162442086460914,10.330442086460915]
[null,null,{"$f":"C57+rng_L/10","v":4.8},16.680000000000003,24.57599999999999,19.502967392093808,0]
[null,null,{"$f":"C58+rng_L/10","v":6},0,75,23.133393015804323,0]

{"sheet":"Edge Heave","index":2,"n_rows":65,"n_cols":18,"rows_kept":65,"cut":false,"hidden":false,"merged":[]}
["Residential Footing Design - Mitchell Method (1984)",null,null,null,null,null,null,null,"JRB STRUCTURAL ENGINEERING PTY LTD","Notes:"]
[null,null,null,null,null,null,null,null,null,"click \"Re-Calculate\" after making any changed to inputs"]
["Edge Heave - Inputs"]
[]
[]
[null,"x =",3,"m",null,null,null,null,"distance from centre of footing (0<x<L/2) - Nominal","Designer can input any valid value for x to calculate moment at any given point",null,null,null,null,null,null,4.2249999999999996,3]
[null,"L =",{"$f":"'Centre Heave'!C7:C15","v":12},"m",null,null,null,null,"overall length of footing",null,null,null,null,null,null,null,14.05,12]
[null,"B =",1,"m",{"$f":"IF(rng_B<>1,\"usually take B equals 1m\",\"\")","v":""},null,null,null,"take unit width of footing",null,null,null,null,null,null,null,1,1]
[null,"W =",10,"kN/m",null,null,null,null,"edge line load applied to footing",null,null,null,null,null,null,null,30,10]
[null,"T =",0,"kN/m",null,null,null,null,"centre line load applied to footing",null,null,null,null,null,null,null,30,0]
[null,"w =",6.5,"kPa",null,null,null,null,"uniform load applied to footing",null,null,null,null,null,null,null,3,6.5]
[null,"Y =",7.4999999999999997E-2,"m",null,null,null,null,"free soil heave",null,null,null,null,null,null,null,0.02,7.4999999999999997E-2]
[null,"Δ =",1.2E-2,"m",null,null,null,null,"design deflection limit","A solution may not be possible when D approaches the value of Y ",{"$f":"(C19)/(C15*(C12*10^-3))","v":108.88888888888889},null,null,null,null,null,7.0000000000000001E-3,1.2E-2]
[null,"m =",5,null,null,null,null,null,"exponent (refer AS2870)",null,null,null,null,null,null,null,21,5]
[null,"k =",1000,"kPa/m",null,null,null,null,"modulus of subgrade reaction",null,null,null,null,null,null,null,2500,1000]
[]
["Edge Heave - Calculations"]
[]
[null,"ω =",{"$f":"rng_w_small+(2*rng_W_big+rng_Tload)/rng_L","v":8.1666666666666661},null,null,null,null,null,"uniform pressure"]
[null,"t =",1.7231774032939615,null,null,null,null,null,"solved numerically at x=L/4"]
[null,"C =",0.39279602163465543,{"$f":"IF(rng_C<0,\"Warning: negative value for C\",\"\")","v":""},null,null,null,null,"solved numerically at x=L/4"]
[null,"(1-C)=",{"$f":"1-rng_C","v":0.60720397836534457}]
[null,"δο=",{"$f":"C22^rng_m*rng_Y-C22^rng_t*rng_DELTA_big","v":1.1110360112151713E-3}]
[null,"ω/(kY)1=",{"$f":"(1-C22^rng_m*(1+rng_m*rng_C))*(1/(rng_m+1))+(C22^rng_t*(1+rng_t*rng_C)-1)*(rng_DELTA_big/rng_Y)*(1/(rng_t+1))","v":0.10884139473923023},null,null,null,null,null,"δo>0"]
[null,"ω/(kY)2=",{"$f":"1-(rng_DELTA_big/rng_Y)^((1/(rng_m-rng_t)))","v":0.42836558313863304},null,null,null,null,null,"δo=0"]
[null,"ω/(kY)=",{"$f":"IF(rng_deltao<>0,C24,C25)","v":0.10884139473923023},null,null,null,null,null,"adopt correct value of ω/(kY) based on actual δo value"]
[null,"fC =",{"$f":"C26-rng_omega/(rng_k*rng_Y)","v":-4.7494149658655616E-5},null,null,null,null,null,"equation to solve for \"C\""]
[]
[null,"B4.1 =",{"$f":"rng_W_big*rng_B*(rng_L/2-rng_x)+rng_w_small*rng_B/2*(rng_L/2-rng_x)^2","v":59.25}]
[null,"B4.2 =",{"$f":"rng_Y*rng_L^2/(4*(rng_m+2))*(1-C22^(rng_m+2))-rng_DELTA_big*rng_L^2/(4*(rng_t+2))*(1-C22^(rng_t+2))","v":0.27605464474235203}]
[null,"B4.3 =",{"$f":"-rng_deltao*rng_L^2/8*(1-C22^2)-rng_Y*rng_x*rng_L/(2*(rng_m+1))*(1-C22^(rng_m+1))","v":-0.22634830177778908}]
[null,"B4.4 =",{"$f":"+rng_DELTA_big*rng_x*rng_L/(2*(rng_t+1))*(1-C22^(rng_t+1))+rng_deltao*rng_L*rng_x*rng_C/2","v":6.678720570133953E-2}]
[null,"Mx.4  =",{"$f":"C29-rng_k*rng_B*(C30+C31+C32)","v":-57.24354866590248},null,null,null,null,null,"0 < x < (1-C)L/2"]
[]
[null,"B6.1 =",{"$f":"rng_W_big*rng_B*(rng_L/2-rng_x)+rng_w_small*rng_B/2*(rng_L/2-rng_x)^2","v":59.25}]
[null,"B6.2 =",{"$f":"rng_L^2*rng_Y/(4*(rng_m+2))-rng_L^2*rng_DELTA_big/(4*(rng_t+2))-rng_deltao*rng_L^2/8","v":0.24968571113345417}]
[null,"B6.3 =",{"$f":"-rng_L*rng_x*rng_Y/(2*(rng_m+1))+rng_L*rng_x*rng_DELTA_big/(2*(rng_t+1))+rng_deltao*rng_x*rng_L/2","v":-0.12568224473638134}]
[null,"B6.4 =",{"$f":"+(2/rng_L)^rng_m*rng_x^(rng_m+2)*rng_Y/((rng_m+1)*(rng_m+2))-(2/rng_L)^rng_t*rng_x^(rng_t+2)*rng_DELTA_big/((rng_t+1)*(rng_t+2))-rng_deltao*rng_x^2/2","v":-7.7237392404384455E-3}]
[null,"Mx.6  =",{"$f":"C35-rng_k*rng_B*(C36+C37+C38)","v":-57.02972715663438},null,null,null,null,null,"(1-C)L/2 < x < L/2"]
[]
[null,"M#=",{"$f":"IF(C6>=0,IF(C6<(1-rng_C)*C7/2,C33,C39),NA())","v":-57.24354866590248},null,null,null,null,null,"ULS moment @ x"]
[]
[null,"B5.1 =",{"$f":"rng_W_big*rng_B*rng_L/4*rng_x^2-rng_W_big*rng_B/6*rng_x^3+rng_w_small*rng_B*rng_L^2/16*rng_x^2-rng_w_small*rng_B*rng_L/12*rng_x^3+rng_w_small*rng_B/24*rng_x^4","v":597.9375}]
[null,"B5.2 =",{"$f":"rng_Y*rng_L^2*rng_x^2/(8*(rng_m+2))*(1-C22^(rng_m+2))-rng_DELTA_big*rng_L^2*rng_x^2/(8*(rng_t+2))*(1-C22^(rng_t+2))","v":1.2422459013405842}]
[null,"B5.3 =",{"$f":"-rng_deltao*rng_L^2*rng_x^2/16*(1-C22^2)-rng_Y*rng_L*rng_x^3/(12*(rng_m+1))*(1-C22^(rng_m+1))","v":-0.37739809220214993}]
[null,"B5.4 =",{"$f":"+rng_DELTA_big*rng_L*rng_x^3/(12*(rng_t+1))*(1-C22^(rng_t+1))+rng_deltao*rng_L*rng_C*rng_x^3/12","v":0.1001808085520093}]
[null,"EIδ=",{"$f":"C43-C15*C8*(C44+C45+C46)","v":-367.09111769044353}]
[]
[null,"B7.1 =",{"$f":"rng_W_big*rng_B*rng_L^3/24+rng_w_small*rng_B*rng_L^4/128","v":1773}]
[null,"B7.2 =",{"$f":"(2*rng_m+9)*rng_Y*rng_L^4/(96*(rng_m+3)*(rng_m+4))-(2*rng_t+9)*rng_DELTA_big*rng_L^4/(96*(rng_t+3)*(rng_t+4))-rng_deltao*rng_L^4/128","v":2.9015581006253619}]
[null,"B7.3 =",{"$f":"-1*C22^(rng_m+3)*rng_Y*rng_L^4/(32*(rng_m+3))+C22^(rng_t+3)*rng_DELTA_big*rng_L^4/(32*(rng_t+3))+C22^3*rng_deltao*rng_L^4/96","v":9.748399255926965E-2}]
[null,"B7.4 =",{"$f":"C22^(rng_m+4)*rng_Y*rng_L^4/(96*(rng_m+4))-C22^(rng_t+4)*rng_DELTA_big*rng_L^4/(96*(rng_t+4))-C22^4*rng_deltao*rng_L^4/384","v":-1.4019351327792567E-2}]
[null,"EIΔ=",{"$f":"C49-C15*C8*(C50+C51+C52)","v":-1212.0227418568393}]
[]
[null,"EIrequired=",{"$f":"rng_EIDELTA_big/rng_DELTA_big","v":-101001.8951547366},null,null,null,null,null,"required stiffness"]
[null,"tnext =",{"$f":"LOG(C47/C53,(2*C6/C7))","v":1.7232066573105143},null,null,null,null,null,"resolve for t"]
["Edge Heave - Summary"]
[]
[null,null,"Dist x from centreline\nm ","Moment M#\nkNm/m","Free soil heave \nmm","Footing Movement mm","Soil Pressure\nkPa"]
[null,null,{"$f":"0","v":0},-86.429431563863261,0,1.1110360112151714,{"$f":"rng_k*MAX(0,-(F60-E60))/1000","v":0}]
[null,null,{"$f":"C60+rng_L/10","v":1.2},-81.775078404678936,2.399999999999999E-2,1.7216557017991168,0]
[null,null,{"$f":"C61+rng_L/10","v":2.4},-67.760725245494569,0.76799999999999968,3.4870350404476267,0]
[null,null,{"$f":"C62+rng_L/10","v":3.5999999999999996},-44.386372086310303,5.831999999999999,6.2073691767833035,0]
[null,null,{"$f":"C63+rng_L/10","v":4.8},-14.032276391250129,24.57599999999999,9.5494062594655578,15.026593740534432]
[null,null,{"$f":"C64+rng_L/10","v":6},-6.9388939039072284E-15,75,13.046447436190558,61.953552563809438]