{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["ANN","Standardization Parameters","Weights and Biases","About"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1,"comments":1,"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":"ANN","index":0,"n_rows":55,"n_cols":26,"rows_kept":55,"cut":false,"hidden":false,"merged":[[7,24,7,28],[10,25,10,28],[7,22,7,23],[23,22,25,22],[1,1,1,20],[5,12,5,17],[23,19,25,19],[0,1,0,20],[28,1,28,4],[29,1,29,4],[30,1,30,4],[21,1,21,6],[22,1,22,4],[23,1,23,4],[24,1,24,4],[25,1,25,4],[7,15,7,17],[12,12,12,14],[3,11,3,18],[20,8,20,9],[26,1,26,4],[27,1,27,4],[4,12,4,17],[31,1,31,4],[32,1,32,4],[35,2,35,3],[35,5,36,5],[35,1,36,1],[34,1,34,5],[45,25,45,27],[53,2,53,5],[35,4,36,4],[52,2,52,5],[51,2,51,5],[48,1,49,5],[38,10,43,19],[21,29,21,36],[22,30,22,36],[23,30,23,36],[20,25,20,28],[8,25,8,28],[19,32,19,39],[20,33,20,39],[11,23,11,30],[13,24,13,30],[14,32,14,38],[15,32,15,38],[13,31,13,38]]}
[null,"ANN-ConDeep"]
[null,"ANN-ConDeep calculates the shear strength of two-span continuous deep beams."]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Instructions"]
[null,null,null,null,null,null,null,null,null,null,null,"Step 1: ","Input parameters in the orange cells and click \"Calculate\" button."]
[null,null,null,null,null,null,null,null,null,null,null,"Step 2: ","Obtain calculated shear strength in the green cell. "]
[]
[null,null,"P = ",{"$f":"TEXT(T23*16/11,\"0.0\")&\" kN\"","v":"906.3 kN"},null,"P = ",{"$f":"TEXT(T23*16/11,\"0.0\")&\" kN\"","v":"906.3 kN"},null,null,null,null,null,null,null,null,"Hidden Layer"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8.9260598414764303]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7.3706800502074685]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.3891148123219299]
[null,null,null,null,null,null,null,null,null,null,null,"Input","Scaled Input",null,null,null,17.434145754118965]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7.0092603154572588]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"F23","v":180},null,0.3733933306555009,null,null,9.4785201266673091]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8.1947422409623059]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"F24","v":700},null,-4.8123156221134764E-2,null,null,3.9747486704735717]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"F25/F24","v":0.6428571428571429},null,-1.2235661552070221,null,null,9.0894257275947083,null,null,"Output "]
[null,{"$f":"TEXT(T23*5/11,\"0.0\")&\" kN\"","v":"283.2 kN"},null,null,{"$f":"TEXT(T23*2,\"0.0\")&\" kN\"","v":"1246.2 kN"},null,null,{"$f":"TEXT(T23*5/11,\"0.0\")&\" kN\"","v":"283.2 kN"},null,null,null,null,null,null,null,null,3.5826799824752245]
[null,null,null,null,null,null,null,null,"Section A-A",null,null,{"$f":"F26","v":55},null,1.6673309389404805,null,null,16.390854511007632]
[null,"Input Information ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,10.424522345806665]
[null,"Width of the beam  (bw)",null,null,null,180,"mm",null,null,null,null,{"$f":"F27","v":562},null,1.1697979542208243,null,null,11.08572473297923,null,null,623.0856328369839,"kN",null,null,null,null," "]
[null,"Effective depth of the beam (d)",null,null,null,700,"mm",null,null,null,null,null,null,null,null,null,4.9082743818578596,null,null,"Nominal shear strength"]
[null,"Shear span (a)",null,null,null,450,"mm",null,null,null,null,{"$f":"F28","v":0},null,-0.63529322314053227,null,null,0]
[null,"Cylinder compressive strength of concrete (fc')",null,null,null,55,"MPa",null,null,null,null,null,null,null,null,null,0.57885788761561008]
[null,"Yield strength of longitudinal reinforcement (fyh)",null,null,null,562,"MPa",null,null,null,null,{"$f":"F29","v":0.97},null,-0.59264213994827664,null,null,7.422859558527092]
[null,"Yield strength of transverse reinforcement (fyv )",null,null,null,0,"MPa",null,null,null,null,null,null,null,null,null,9.1266150435748159]
[null,"Longitudinal bottom reinforcement ratio (ρh)",null,null,null,0.97,"%",null,null,null,null,{"$f":"F30","v":0.97},null,-0.62929254491015663,null,null,0]
[null,"Longitudinal top reinforcement ratio (ρh')",null,null,null,0.97,"%",null,null,null,null,null,null,null,null,null,4.7497253836723718]
[null,"Transverse reinforcement ratio (ρv)",null,null,null,0,"%",null,null,null,null,{"$f":"F31","v":0},null,-0.58021397536658148,null,null,14.531343616308748]
[null,"Width of loading plate (ll)",null,null,null,150,"mm",null,null,null,null,null,null,null,null,null,7.5455377635593273]
[null,"Width of support plate (ls)",null,null,null,200,"mm",null,null,null,null,{"$f":"F32","v":150},null,-1.1937422332811096,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.8321917264616507]
[null,"Valid range of input parameters",null,null,null,null,null,null,null,null,null,{"$f":"F33","v":200},null,-0.5751957863536532,null,null,0]
[null,"Input parameter","Valid range",null,"Input value","Range check",null,null,null,null,null,null,null,null,null,null,3.8791729874333614]
[null,null,"Min","Max",null,null,null,null,null,null,null,null,null,null,null,null,9.344115458912885]
[null,"bw",120,200,{"$f":"F23","v":180},{"$f":"IF(AND(E38>=C38, E38<=D38), \"OK\", \"Not OK\")","v":"OK"}]
[null,"d",305,975,{"$f":"F24","v":700},{"$f":"IF(AND(E39>=C39, E39<=D39), \"OK\", \"Not OK\")","v":"OK"},null,null,null,null,"The calculated value represents the nominal (unfactored) shear strength of this beam subjected to point load, P at the center of each span. This value should be multiplied by the strength reduction factor according to design codes such as ACI 318-25, AASHTO LRFD (2024), or CSA A23.3-2024 to obtain the factored shear strength. The strength reduction factor (φ) required by ACI 318-25, AASHTO LRFD (2024), and CSA A23.3-2024 are 0.75, 0.75, and 0.65,  respectively. The calculated point load value, P should be compared with the factored loads when performing design or safety assessment.  "]
[null,"a/d",0.54,2.67,{"$f":"F25/F24","v":0.6428571428571429},"OK"]
[null,"fc'",14.5,68.2,{"$f":"F26","v":55},"OK"]
[null,"fyh",285,586,562,"OK"]
[null,"fyv",0,580,0,"OK"]
[null,"ρh",0.32,4.76,0.97,"OK"]
[null,"ρh'",0.32,4.8600000000000003,0.97,"OK"]
[null,"ρv",0,0.6,0,"OK"]
[null,"ll",150,300,150,"OK"]
[null,"ls",160,400,200,"OK"]
[null,"Note : The input must be within the valid range of input parameters. The ANN cannot be used for extrapolation."]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"   "]

{"sheet":"Standardization Parameters","index":1,"n_rows":14,"n_cols":7,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,2,1],[1,2,2,2],[1,3,2,3],[2,6,3,15]]}
[]
[null,"Input Parameters","Mean","Standard Deviation"]
[null,null,null,null,null,null,"  These mean and standard deviation values are calculated from the training dataset and used for scaling (i.e., normalizing) the input features. The user should not make any changes to these values."]
[null,"bw",172.25,20.755593049998421]
[null,"d",509.33928571428572,194.07052076000929]
[null,"a/d",1.799107142857143,0.73482450962728496]
[null,"fc'",33.674107142857153,12.790438292052629]
[null,"fyh",432.03571428571428,111.09977245150191]
[null,"fyv",149.96428571428569,236.05522691324001]
[null,"ρh",1.7324107142857139,1.286460569002988]
[null,"ρh'",1.7852678571428571,1.295531440748096]
[null,"ρv",0.1083005357142857,0.18665739197811099]
[null,"ll",210.10714285714289,50.351861425170704]
[null,"ls",251.89285714285711,90.217728415252012]

{"sheet":"Weights and Biases","index":2,"n_rows":47,"n_cols":31,"rows_kept":47,"cut":false,"hidden":false,"merged":[[3,1,3,2],[15,1,15,2],[4,1,14,1],[0,1,1,30],[17,7,17,20]]}
[null,"Weights and Biases"]
[]
[]
[null,"Hidden Layer Neurons (N)",null,"N1","N2","N3","N4","N5","N6","N7","N8","N9","N10","N11","N12","N13","N14","N15","N16","N17","N18","N19","N20","N21","N22","N23","N24","N25","N26","N27","N28"]
[null,"Hidden Layer Weights ","bw",-2.4777572154998699,-1.7164931297302199,-2.2471404075622501,6.4781632423400799,2.8811085224151598,6.5983533859252903,8.4507083892822195,3.0448815822601301,3.6571033000946001,8.4275283813476491,1.8981131315231301,-1.08391857147216,10.1131086349487,-0.41222918033599798,2.4665758609771702,3.6805727481842001,5.9431967735290501,4.6104421615600497,3.8952202796936,2.2776863574981601,4.3340139389037997,-2.0421895980834899,1.45579969882965,1.7242808341979901,2.1002748012542698,2.8867552280425999,5.0860118865966699,7.2830328941345197]
[null,null,"d",1.4835079908370901,1.1364945173263501,1.37895190715789,0.69330614805221502,0.83529043197631803,3.3641993999481201,-4.0808243751525799,2.45257091522216,-0.115096032619476,-1.6568468809127801,0.38145214319229098,0.99576234817504805,-1.42676949501037,1.1412774324417101,1.26267206668853,2.5592617988586399,0.34869492053985501,3.0227670669555602,-0.47058492898941001,1.2230095863342201,1.80727279186248,-0.63002878427505404,-0.502064108848571,0.43105408549308699,0.65385049581527699,0.53906559944152799,-0.52391511201858498,-3.2359366416931099]
[null,null,"a/d",-4.8562464714050204,-4.6286411285400302,-3.9733211994171098,-5.1567893028259197,-4.8101992607116602,-8.3241672515869105,-5.7602233886718697,-3.54981517791748,5.9206228256225497,-4.6463894844055096,-5.1714415550231898,-5.5318822860717702,-5.2103123664855904,-5.0596342086791903,-6.0240812301635698,0.25453773140907199,10.2960205078125,-9.8436470031738192,-2.5959205627441402,0.22376641631126401,-7.8767809867858798,-4.0414252281188903,-6.6251568794250399,2.4459340572357098,-4.4583964347839302,2.5088870525360099,-7.7199945449829102,-4.11512899398803]
[null,null,"fc'",3.2933158874511701,1.6939400434494001,3.1569070816039999,0.62698984146118097,-3.0515205860137899,1.0053303241729701,3.5954163074493399,-1.06503129005432,2.28427863121032,1.35576725006103,-0.67114210128784102,3.2762422561645499,1.4744069576263401,2.4528646469116202,-1.5760474205017001,-5.5618224143981898,-0.98069268465042103,-1.2976820468902499,0.47480148077011097,-2.4288311004638601,0.164999589323997,-0.73021692037582298,5.6741991043090803,-0.589105784893035,1.77791512012481,-0.22001142799854201,2.1222150325775102,1.1473034620285001]
[null,null,"fyh",2.8650193214416499,3.15712165832519,3.1764268875121999,-0.54343056678771895,1.3101487159728999,-0.47401598095893799,-4.0547161102294904,2.2165036201477002,-1.1660735607147199,-1.5573968887329099,0.865567207336425,2.9586336612701398,-2.3700997829437198,2.3996546268463099,2.4175784587860099,2.0759346485137899,2.4495968818664502,0.72577500343322698,1.36193670332431E-2,-0.30654489994049,-0.83012467622756902,4.0035481452941797,-1.6749237775802599,-0.243272349238395,0.90395903587341297,0.765993893146514,-4.3254861831665004,-1.4943470954895]
[null,null,"fyv",2.1015865802764799,1.90127325057983,1.96431720256805,-4.69500637054443,-3.7324435710906898,0.50152397155761697,1.05070257186889,0.58338427543640103,-1.22659707069396,-1.1331542730331401,1.13659000396728,0.84653663635253895,-1.3243534564971899,1.01418733596801,1.2412753105163501,2.14796662330627,1.1496005058288501,0.42775180935859602,-3.2355561256408598,1.61506307125091,0.127328410744667,-4.7387757301330504,2.72171902656555,3.0926647186279199,1.8447248935699401,1.5071876049041699,-2.0070512294769198,-0.98586684465408303]
[null,null,"ρh",0.92148637771606401,0.20350345969200101,0.64530712366104104,-0.37500753998756398,-1.09522581100463,2.1872470378875701,1.2168002128601001,0.50119608640670699,0.42305350303649902,0.36408445239067,0.15412580966949399,5.2009318023919997E-2,0.81587010622024503,0.121209576725959,-9.17611457407474E-3,0.37909144163131703,0.32898849248886097,0.59318184852599998,-0.45970731973647999,0.375356465578079,1.56529629230499,-0.551835477352142,0.74584430456161399,0.62966752052307096,0.72167783975601096,0.89771097898483199,2.0855658054351802,-0.53693938255310003]
[null,null,"ρh'",1.11484122276306,0.23571726679801899,1.09687411785125,-0.92037868499755804,-0.53646188974380404,2.2634105682372998,0.166976913809776,0.21908248960971799,-0.45606967806816101,0.182963922619819,6.5869905054569203E-2,1.57010209560394,-0.29560822248458801,1.55448353290557,3.1316701322793898E-2,-0.92637676000595004,-0.247765228152275,3.6737029440700999E-3,-0.61666899919509799,-0.62538152933120705,2.1723227500915501,0.82058924436569203,1.78900635242462,0.114292964339256,0.72890156507491999,-0.213729798793792,1.6580440998077299,-0.70473635196685702]
[null,null,"ρv",3.7812473773956201,3.1455929279327299,3.7707593441009499,-2.4445054531097399,-3.1165146827697701,0.47205021977424599,0.55818301439285201,1.1583454608917201,2.8029966354370099,-0.392894446849822,2.39265656471252,0.58572572469711304,0.94422459602355902,0.52228116989135698,2.3322682380676198,2.1844596862792902,0.90984451770782404,-1.6606914997100799,-1.56879866123199,2.19838213920593,0.20422890782356201,-2.6806278228759699,1.9739570617675699,4.0718975067138601,3.0875709056854199,2.4357912540435702,-0.22340990602970101,-0.89633136987686102]
[null,null,"ll",2.1843335628509499,1.8492856025695801,1.57889628410339,1.43907703459262E-2,0.23572766780853199,0.23194281756877799,0.81807100772857599,1.38419902324676,-0.41118216514587402,1.30103576183319,1.0681118965148899,-0.47313144803047102,-0.41122001409530601,0.74189102649688698,1.67080473899841,2.1784074306488002,-3.7520081996917698,0.45068743824958801,1.04743993282318,1.01699459552764,1.4051817655563299,1.9407056570053101,1.84917199611663,1.4822696447372401,2.3635375499725302,1.0002589225769001,1.6601128578186,0.37334853410720797]
[null,null,"ls",-0.73409777879714899,1.2648411989212001,-0.59626209735870295,-1.6140558719635001,-0.16115532815456299,-1.6256057024002,-3.15237259864807,1.67433321475982,-0.68641185760498002,-3.4285204410552899,0.82348155975341697,-4.0353717803954998,-2.6798517704010001,-3.0657587051391602,2.4251301288604701,2.1906001567840501,-5.0447196960449201,-2.95892333984375,-2.0775439739227202,1.2959794998168901,-1.3701428174972501,-3.29283571243286,-1.81579649448394,2.1548361778259202,2.1755988597869802,1.36054122447967,-2.8994901180267298,-2.1602828502654998]
[null,"Hidden layer Bias ",null,2.1001594066619802,2.1223216056823699,2.5038170814514098,2.2155444622039702,-1.3340488672256401,-1.4753043651580799,-2.4757339954376198,1.8883515596389699,1.6597259044647199,-1.29683542251586,0.662997245788574,0.16188994050025901,-1.5095895528793299,-0.67346000671386697,2.0223801136016801,1.05342698097229,3.6606175899505602,-6.3847894668579102,9.4761908054351807E-2,0.227316319942474,-2.3399894237518302,2.8989613056182799,-3.0247416496276802,0.23993282020091999,1.5250951051712001,-0.71149384975433305,-4.7808666229248002,-1.43600726127624]
[]
[null,null,null,null,null,null,null,"These values of weights and biases are established during the training of the artificial neural network (ANN). The user should not make any changes to these values."]
[null,"Output Layer Weights ","Output Layer Bias "]
[null,2.8072803020477202,2.6197977066039999]
[null,2.4597783088684002]
[null,2.7199320793151802]
[null,3.3074424266815101]
[null,2.8606569766998202]
[null,4.63277244567871]
[null,7.1545486450195304]
[null,1.73555099964141]
[null,2.3235518932342498]
[null,2.5974102020263601]
[null,1.4524333477020199]
[null,2.7609701156616202]
[null,3.5646739006042401]
[null,2.13221859931945]
[null,2.53515195846557]
[null,2.89286184310913]
[null,5.6781291961669904]
[null,7.2974042892456001]
[null,0.93148374557495095]
[null,0.82598996162414495]
[null,3.98654007911682]
[null,3.2391111850738499]
[null,4.4684023857116602]
[null,1.8233070373535101]
[null,2.2627589702606201]
[null,1.1684927940368599]
[null,5.9686322212219203]
[null,2.1166582107543901]

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