{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"charts":0,"images":10,"macros":1,"external_links":0,"defined_names":25,"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":214,"n_cols":21,"rows_kept":214,"cut":false,"hidden":false,"merged":[[182,8,182,9],[182,10,182,11],[193,1,195,1],[154,4,154,5],[155,4,155,5],[156,4,156,5],[157,4,157,5],[158,4,158,5],[159,4,159,5],[152,20,153,20],[152,9,153,9],[152,10,153,10],[152,11,153,11],[152,12,153,12],[152,13,153,13],[152,14,153,14],[152,15,153,15],[152,16,153,16],[152,17,153,17],[152,18,153,18],[152,19,153,19],[31,0,31,2],[31,5,31,6],[116,8,116,9],[142,12,142,13],[152,1,153,2],[152,3,153,3],[152,4,153,5],[152,6,153,6],[152,7,153,7],[152,8,153,8]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,{"$f":"Lintel_Safe_Load","v":5.3231649971564137}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,{"$f":"C213","v":3.6037572574431582}]
[null,null,null,null,null,null,{"$f":"C214","v":1248.6967568933098}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"TODAY()","v":"2025-09-05"},null,null,null,null,"ULTRAlintel Designer"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Render",null,"None"]
[null,null,null,"One Face"]
[null,null,null,"Both Faces"]
[]
[null,"Limiting total deflection (Span / ??)",null,{"$f":"IF(D127=1,750,1000)","v":1000}]
[null,"Lintel description",null,1]
[null,"Environment",null,2]
[null,"Lintel width",null,110," mm"]
[null,"Lintel depth",null,{"$f":"IF(Lintel_choice=1,170,80)","v":170}," mm"]
[null,"Concrete strength",null,60," MPa"]
[null,"Concrete Modulus",null,{"$f":"2400^1.5*0.043*$D$112^0.5*0.8","v":31329.317234820206}," MPa"]
[null,"Gross Lintel Section",null,{"$f":"$D$110*$D$111^3/12","v":45035833.333333336}," mm4"]
[null,"Gross Lintel Area",null,{"$f":"$D$110*$D$111","v":18700}," mm2"]
[null,"Lintel Self Weight",null,{"$f":"IF(Lintel_choice=1,0.4488,0.2212)","v":0.44879999999999998}," kN/m"]
[null,null,null,"Top","Middle","Bottom",null,null,"Prestress Force"]
[null,"Depth to strand from top fibre",null,{"$f":"IF(Lintel_choice=1,40,0)","v":40},null,{"$f":"IF(Lintel_choice=1,130,40)","v":130},null,null,170,80]
[null,"Number of strands",null,{"$f":"IF(Lintel_choice=1,1,0)","v":1},null,{"$f":"IF(Lintel_choice=1,1,2)","v":1},null,"Arid",104004.541864332,59952.598794500002]
[null,"Initial strand force",null,{"$f":"IF(Lintel_choice=1,70,0)","v":70},null,{"$f":"IF(Lintel_choice=1,70,50)","v":70},null,"Interior",106397.764011028,62628.188502450597]
[null,"Prestress modulas of elasticity",null,200000," MPa",null,null,"Temperate",108795.55139129701,65315.789413367303]
[null,"Prestress Eccentricity in Lintel only",null,{"$f":"IF(Lintel_choice=1,1.4210854715202E-14,0)","v":1.4210854715202001E-14}," mm",null,null,"Tropical",114569.39248378,71817.987844434494]
[null,"Prestress Force",null,{"$f":"IF(Lintel_environment=1,IF(Lintel_choice=1,I119,J119),IF(Lintel_environment=2,IF(Lintel_choice=1,I120,J120),IF(Lintel_environment=3,IF(Lintel_choice=1,I121,J121),IF(Lintel_choice=1,I122,J122))))","v":106397.764011028}," N"]
[]
[null,"Brick Wall Input"]
[null,"Number of courses over",null,{"$f":"IF(Number_Courses_Prime=\"\",0,VALUE(Number_Courses_Prime))","v":6},"6"]
[null,"Render to Wall",null,2]
[null,"Brick width",null,110," mm"]
[null,"Brick height",null,"76"," mm"]
[null,"Mortar thickness",null,"10"," mm"]
[null,"Characteristic compressive strength (f'mb)",null,"6.3"," MPa"]
[null,"Height Ratio",null,{"$f":"D129/D130","v":7.6}]
[null,"Compressive strength factor (Kh)",null,{"$f":"IF(OR(D132<3,D132=3),((D132-0)/(3-0)*(0.6-0)+0),IF(OR(D132<7.6,D132=7.6),((D132-3)/(7.6-3)*(1-0.6)+0.6),IF(OR(D132<12,D132=12),((D132-7.6)/(12-7.6)*(1.15-1)+1),IF(OR(D132<19,D132=19),((D132-12)/(19-12)*(1.3-1.15)+1.15),1.3))))","v":1}]
[null,"Characteristic compressive strength (f'm)",null,{"$f":"D133*D131","v":6.3}," MPa"]
[null,"Characteristic shear strength (f'ms)",null,0.25," MPa"]
[null,"Beam Density",null,{"$f":"IF(Lintel_choice=1,2406,2386)","v":2406},"kg/m3"]
[null,"Fcmi",null,63,"Mpa"]
[null,"Lintel modulas",null,{"$f":"Beam_Density^1.5*(IF(fcmi<=40,0.043,0.024)*fcmi^0.5+IF(fcmi<=40,0,0.12))","v":36643.485676517827}," MPa"]
[null,"Brick modulas (750 x f'm normally)",null,{"$f":"750*D134","v":4725}," MPa"]
[null,"Effective Nett modulas (0.8 x calculated)",null,{"$f":"J166*0.8","v":11005.540180351052}," MPa"]
[null,"Depth of Brick Section",null,{"$f":"(D129+D130)*D126","v":516}," mm"]
[null,"Depth of total section",null,{"$f":"$D$111+$D$141","v":686}," mm"]
[null,"Based on Wb,Section I",null,{"$f":"E165","v":933759095.34480214}," mm4",null,null,null,null,null,null,null,"Effective Prestress"]
[null,"Unit weight of unrendered wall",null,{"$f":"IF(D108<3,0.18*D128/10,0.19*D128/10)","v":1.98},"kN/m2",null,null,null,null,null,null,null,170,80]
[null,"Unit weight of render",null,{"$f":"IF(D127=1,0,IF(D127=2,0.012*23,0.012*2*23))","v":0.27600000000000002},"kN/m2",null,null,null,null,null,null,"Arid",945.49583513028995,545.02362540454499]
[null,"Wall weight",null,{"$f":"(D145+D144)*D141/1000","v":1.164096},"kN/m",null,null,null,null,null,null,"Interior",967.25240010025504,569.34716820409596]
[null,null,null,null,null,null,null,null,null,null,null,"Temperate",989.05046719360996,593.77990375788499,null,null,null,"fpy",1517]
[null,"Transformed Section Properties",null,null,null,null,null,null,null,null,null,"Tropical",1041.5399316707301,652.89079858576804]
[null,"Modular Ratio",null,"Bricks ",{"$f":"$D$139/$D$113","v":0.15081720308760874}]
[null,null,null,"Stressing ",{"$f":"$D$121/$D$113","v":6.3837969560892596}]
[]
[null,"Transformed Section based on Concrete properties"]
[null,"Element",null,"Area (mm2)","Section Centroid from bottom (mm)",null,"A*Y","Ixx","A*ycon2","I'xx*E (exc Steel)","A*y² (exc Steel)","A*y²*E (exc Steel)","Effective prestress (Mpa)","Steel Strain due to effective prestress","Concrete Strain due to effective prestress","Strain due to bending","Total Steel Strain","Total Steel Stress","Allowable Steel Stress","Force in Steel","Force x Lever arm about btm of section"]
[]
[null,"Bricks",null,{"$f":"$E$149*$D$128*$D$141","v":8560.3844472526725},{"$f":"$D$111+$D$141/2","v":428},null,{"$f":"D155*E155","v":3663844.5434241439},{"$f":"$E$149*$D$128*$D$141^3/12","v":189937810.11564228},{"$f":"D155*(E155-$E$163)^2","v":483185914.58354962},{"$f":"H155*D139","v":897456152796.40979},{"$f":"D155*(E155-$J$163)^2","v":473915343.71127415},{"$f":"K155*D139","v":2239249999035.7705}]
[null,"Concrete",null,{"$f":"$D$110*$D$111","v":18700},{"$f":"$D$111/2","v":85},null,{"$f":"D156*E156","v":1589500},{"$f":"$D$110*$D$111^3/12","v":45035833.333333336},{"$f":"D156*(E156-$E$163)^2","v":207818801.07760385},{"$f":"H156*D138","v":1650269913680.0442},{"$f":"D156*(E156-$J$163)^2","v":216946392.38611752},{"$f":"K156*D138","v":7949672021972.9131}]
[null,"Top Strands",null,{"$f":"$D$119*55*($E$150-1)","v":296.10883258490929},{"$f":"$D$111-$D$118","v":130},null,{"$f":"D157*E157","v":38494.148236038207},0,{"$f":"D157*(E157-$E$163)^2","v":1080955.7767565763},0,0,0,{"$f":"IF(Lintel_choice=1,Lintels_BTMSTRpieff,0)","v":967.25240010025504},{"$f":"Lintels_TOPSTRpieff/$D$121","v":4.8362620005012753E-3},{"$f":"((Lintels_TOPSTRpieff*Lintels_NTOP+Lintels_MIDSTRpieff*Lintels_NMID+Lintels_BTMSTRpieff*Lintels_NBOT)*55/$D$113*($E$164*($D$142-($D$142-E157)-$E$163)/$E$165+1/$D$160))","v":1.4509722981045494E-4},{"$f":"$P$164*($D$142-E157-Lintels_NeutralAxis)/Lintels_NeutralAxis","v":2.5633950001929963E-5},{"$f":"N157+O157+P157","v":5.0069931803136602E-3},{"$f":"Q157*200000","v":1001.3986360627321},{"$f":"IF(ABS(R157)<fpy,R157,fpy*R157/ABS(R157))","v":1001.3986360627321},{"$f":"S157*Lintels_NTOP*55","v":55076.924983450263},{"$f":"T157*E157","v":7160000.247848534}]
[null,"Middle Strands",null,{"$f":"$E$119*55*($E$150-1)","v":0},{"$f":"$D$111-$E$118","v":170},null,{"$f":"D158*E158","v":0},0,{"$f":"D158*(E158-$E$163)^2","v":0},0,0,0,0,{"$f":"Lintels_MIDSTRpieff/$D$121","v":0},{"$f":"((Lintels_TOPSTRpieff*Lintels_NTOP+Lintels_MIDSTRpieff*Lintels_NMID+Lintels_BTMSTRpieff*Lintels_NBOT)*55/$D$113*($E$164*($D$142-($D$142-E158)-$E$163)/$E$165+1/$D$160))","v":1.2976065662788792E-4},{"$f":"$P$164*($D$142-E158-Lintels_NeutralAxis)/Lintels_NeutralAxis","v":-3.3764175897489449E-5},{"$f":"N158+O158+P158","v":9.5996480730398462E-5},{"$f":"Q158*200000","v":19.199296146079693},{"$f":"IF(ABS(R158)<fpy,R158,fpy*R158/ABS(R158))","v":19.199296146079693},{"$f":"S158*Lintels_NMID*55","v":0},{"$f":"T158*E158","v":0}]
[null,"Bottom Strands",null,{"$f":"$F$119*55*($E$150-1)","v":296.10883258490929},{"$f":"$D$111-$F$118","v":40},null,{"$f":"D159*E159","v":11844.353303396372},0,{"$f":"D159*(E159-$E$163)^2","v":6699780.4579165597},0,0,0,{"$f":"IF(Lintel_environment=1,IF(Lintel_choice=1,M145,N145),IF(Lintel_environment=2,IF(Lintel_choice=1,M146,N146),IF(Lintel_environment=3,IF(Lintel_choice=1,M147,N147),IF(Lintel_choice=1,M148,N148))))","v":967.25240010025504},{"$f":"Lintels_BTMSTRpieff/$D$121","v":4.8362620005012753E-3},{"$f":"((Lintels_TOPSTRpieff*Lintels_NTOP+Lintels_MIDSTRpieff*Lintels_NMID+Lintels_BTMSTRpieff*Lintels_NBOT)*55/$D$113*($E$164*($D$142-($D$142-E159)-$E$163)/$E$165+1/$D$160))","v":1.7960451947123074E-4},{"$f":"$P$164*($D$142-E159-Lintels_NeutralAxis)/Lintels_NeutralAxis","v":1.5927973327562367E-4},{"$f":"N159+O159+P159","v":5.1751462532481293E-3},{"$f":"Q159*200000","v":1035.029250649626},{"$f":"IF(ABS(R159)<fpy,R159,fpy*R159/ABS(R159))","v":1035.029250649626},{"$f":"S159*Lintels_NBOT*55","v":56926.608785729426},{"$f":"T159*E159","v":2277064.351429177}]
[null,"Total",null,{"$f":"SUM(D155:D159)","v":27852.60211242249},"n.a.",null,{"$f":"SUM(G155:G159)","v":5303683.0449635787},234973643.44897562,698785451.89582658,2547726066476.4541,690861736.09739161,10188922021008.684,null,null,null,null,null,null,null,{"$f":"T157+T158+T159","v":112003.53376917969},{"$f":"U157+U158+U159","v":9437064.5992777105}]
[]
[null,"Nett:",null,null,null,null,"Excluding Steel:"]
[null,"Neutral Axis location from bottom fibre (ycon)",null,null,{"$f":"G160/D160","v":190.4196607396367}," mm","Neutral Axis location from bottom fibre (ycon)",null,null,{"$f":"(G155+G156)/(D155+D156)","v":192.70984800632851}," mm",null,null,null,null,"Maximum strain in bricks",null,null,"Summ forces"]
[null,"Eccentricity of prestress in section",null,null,{"$f":"D111/2+Lintels_eccentricity-E163","v":-105.41966073963668},"mm","Transformed Section (Igt)",null,null,{"$f":"H160+K160","v":925835379.54636717}," mm4",null,null,null,null,{"$f":"0.6*Brick_fmb/D139","v":7.9999999999999993E-4},null,null,{"$f":"P166+T160","v":2.7110218070447445E-8}]
[null,"Transformed Section (Igt)",null,null,{"$f":"H160+I160","v":933759095.34480214}," mm4","Igtconc*E",null,null,{"$f":"J160+L160","v":12736648087485.137}," mm4",null,null,null,null,"Compression"]
[null,"First Moment of Area of bricks about centroid (Q)",null,null,{"$f":"D155*ABS(E155-$E$163)","v":2033779.0411774276}," mm3","Effective E",null,null,{"$f":"J165/J164","v":13756.925225438814},"MPa",null,null,null,null,{"$f":"-0.6*Brick_fmb*Lintels_NeutralAxis*D110/2","v":-112003.53376915258}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Neutral axis depth",null,"Moment capacity",{"$f":"-((Lintels_TotalDepth-Lintels_NeutralAxis*1/3)*P166+U160)/1000000*0.6","v":28.370314174854858}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,538.7375361671601]
[null,"Moment Capacity due to Brick & Mortar compressive strength"]
[null,"M1=Cr*F'm*Igt/y/MOD1",null,null,null,{"$f":"0.6*$D$134*$E$165/($D$141+$D$111-$E$163)/1000000/$E$149","v":47.223882953253039}," kNm"]
[]
[null,"Moment Capacity due to decompression of the prestressed lintel"]
[null,"M3=Ø(Pi/Ag+Pi*e*ylintel/Ig)*Igt/y",null,null,null,{"$f":"0.9*(Lintels_prestress/$D$115+Lintels_prestress*Lintels_eccentricity*($D$111/2)/$D$114)*$E$165/$E$163/1000000","v":25.110563698578257}," kNm"]
[]
[null,"Moment Capacity due to stress in steel with compatible stress in bricks",null,null,null,{"$f":"S167","v":28.370314174854858}," kNm"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Min moment",null,"Min shear"]
[null,null,null,null,null,null,null,null,170,80,170,80]
[null,null,null,null,null,null,null,"Arid",9.8566414045410795,1.99246169663487,17.869621623643098,8.6430504169746794]
[null,null,null,null,null,null,null,"Interior",9.81491495978538,2.0102764964317799,17.869621623643098,8.6430504169746794]
[null,"Minimum ultimate moment capacity based upon bearer",null,null,null,{"$f":"IF(Lintel_environment=1,IF(Lintel_choice=1,I185,J185),IF(Lintel_environment=2,IF(Lintel_choice=1,I186,J186),IF(Lintel_environment=3,IF(Lintel_choice=1,I187,J187),IF(Lintel_choice=1,I188,J188))))","v":9.81491495978538},null,"Temperate",9.7726122985641606,2.0281487065827899,17.869621623643098,8.6430504169746794]
[null,"Minimum ultimate shear capacity based upon bearer",null,null,null,{"$f":"IF(Lintel_choice=1,K185,L185)","v":17.869621623643098},null,"Tropical",9.6687179107841192,2.0712254458718999,17.869621623643098,8.6430504169746794]
[]
[null,"Ultimate Moment Capacity",null,{"$f":"IF(MIN(F170,F173,F175)<F187,F187,MIN(F170,F173,F175))","v":25.110563698578257}," kNm"]
[null,"Ultimate Horizontal Shear Capacity",null,{"$f":"IF(Number_Courses=0,Lintel_shear,0.6*$D$135*$E$165*$D$110/$E$149/$E$166/1000)","v":50.230111171218795}," kN"]
[null,"Ultimate Vertical Shear Capacity",null,{"$f":"(0.6*$D$135*$D$141*$D$110/1000)+Lintel_shear","v":26.383621623643094}," kN"]
[]
[null,"Span (mm)",null,"         Safe Loads for various conditions (kN/m)"]
[null,null,null,"(with self weight of lintel and specified wall deducted)"]
[null,null,"Moment Capacity",{"$f":"\"L/\" & D107 & \" Deflection\"","v":"L/1000 Deflection"},"Shear","Governing condition"]
[null,"4500",{"$f":"IF(($D$190-1.2*($D$116+$D$146)*(B197/1000)^2/8)/1.5*8/(B197/1000)^2<0,0,($D$190-1.2*($D$116+$D$146)*(B197/1000)^2/8)/1.5*8/(B197/1000)^2)","v":5.3231649971564137},{"$f":"IF((384*$D$140*$D$143/5/$D$107/B197^3-$D$116-$D$146)<0,0,(384*$D$140*$D$143/5/$D$107/B197^3-$D$116-$D$146))","v":7.0481408727633896},{"$f":"2*MIN($D$191,$D$192)/B197*1000/1.5-$D$116-$D$146","v":6.2044733699683245},{"$f":"MIN(C197,D197,E197)","v":5.3231649971564137}]
[null,900,164.04672812891033,1081.0167130954239,37.473950849841621,{"$f":"MIN(C198,D198,E198)","v":37.473950849841621}]
[null,{"$f":"B198+300","v":1200},91.71177097251207,455.12147033713194,27.702239137381216,{"$f":"MIN(C199,D199,E199)","v":27.702239137381216}]
[null,1500,58.231019374407715,232.23509956461155,21.839212109904974,21.839212109904974]
[null,1800,40.043944432227576,133.71580513692797,17.930527424920811,17.930527424920811]
[null,2100,29.077711860412101,83.608676727628108,15.138609792789268,15.138609792789268]
[null,2400,21.960205143128015,55.47889979214149,13.044671568690607,13.044671568690607]
[null,2700,17.080465969878922,38.484496929460143,11.416052949947206,11.416052949947206]
[null,3000,13.590017243601929,27.618103445576445,10.113158054952486,10.113158054952486]
[null,3300,11.007479930249531,20.348786528607395,9.0471531408658965,9.0471531408658965]
[null,3600,9.0432485080568945,15.303191642115998,8.1588157124604042,8.1588157124604042]
[null,3900,7.5146145867467053,11.692065058523642,7.4071455807326823,7.4071455807326823]
[]
[]
[]
[null,"Applied","Deflection"]
[null,{"$f":"Lintel_Safe_Load+D116+D146","v":6.9360609971564138},{"$f":"B213*5/384*B197^4/D140/D143","v":3.6037572574431582}]
[null,null,{"$f":"Lintel_Span/C213","v":1248.6967568933098}]