{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Výpočet","Materiály","Mapping","Nápověda"],"not_rendered":{"charts":0,"images":21,"macros":1,"external_links":0,"defined_names":6,"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":"Výpočet","index":0,"n_rows":240,"n_cols":14,"rows_kept":240,"cut":false,"hidden":false,"merged":[[1,1,1,10],[2,1,2,10],[4,1,4,10],[59,6,59,9],[28,7,28,9],[30,7,30,9],[32,7,32,9],[34,7,34,9],[32,6,34,6],[239,4,239,9],[219,4,219,9],[111,6,111,9],[116,6,116,9],[123,6,123,9],[124,6,124,9],[60,6,60,9],[77,6,77,9],[84,6,84,9],[85,6,85,9],[72,6,72,9]]}
[]
[null,"Eccentricity EC6 v1.0",null,null,null,null,null,null,null,null,null,null,null,"Lists"]
[null,"Utility for determination of masonry walls load eccentricity according to Appendix C of Eurocode 6",null,null,null,null,null,null,null,null,null,null,null,"HIDE!!!"]
[]
[]
[]
[null,"0.","Loading scheme of the structure, sign convention for wall moments",null,null,null,null,null,null,null,null,null,null,"Fixed"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Hinge"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"--select--"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Fixed"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Hinge"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Member does not exist"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"--select--"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Category I, designed mortar"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Category I, prescribed mortar"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Category II"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"--select--"]
[]
[null,null,"▪","Support types will be specified in further calculation steps",null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(VLOOKUP(J72,Materiály!C23:D28,2,FALSE),\" %\")","v":"≤ 25 %"}]
[null,null,"▪","For slab moments, positive moment causes tension in lower part of the slab",null,null,null,null,null,null,null,null,null,{"$f":"IF(VLOOKUP(J72,Materiály!C23:H28,3,FALSE)=\"not used\",\"\",CONCATENATE(VLOOKUP(J72,Materiály!C23:H28,3,FALSE),\" %, vertical holes\"))","v":"25 - 60 %, vertical holes"}]
[null,null,"▪","Width of the model is considered as b = 1 m",null,null,null,null,null,null,null,null,null,{"$f":"IF(VLOOKUP(J72,Materiály!C23:H28,4,FALSE)=\"not used\",\"\",CONCATENATE(VLOOKUP(J72,Materiály!C23:H28,4,FALSE),\" %, vetical holes\"))","v":"60 - 70 %, vetical holes"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(VLOOKUP(J72,Materiály!C23:I28,6,FALSE)=\"not used\",\"\",CONCATENATE(VLOOKUP(J72,Materiály!C23:I28,6,FALSE),\" %, horizontal holes\"))","v":"25 - 70 %, horizontal holes"}]
[]
[null,"1.","Geometry",null,null,null,null,null,null,null,null,null,null,{"$f":"Materiály!C32","v":"in the air (by reaching 6% moisture content)"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Materiály!C33","v":"by saturation (under the water)"}]
[null,null,"1.1.","Members, support type in the end opposite to the joint",null,null,null,null,null,null,null,null,null,{"$f":"Materiály!C34","v":"by drying (by reaching dried state)"}]
[null,null,null,"▪","Lower wall (member 1)",null,{"$f":"IF(J30=0,\"Select lower wall support!!!\",\"\")","v":""},"Fixed",null,null,null,null,null,"--select--"]
[null,null,null,null,"=> Stiffness factor of the member",null,null,"n1","=",{"$f":"IF(H29=\"Fixed\",4,IF(H29=\"Hinge\",3,0))","v":4}]
[null,null,null,"▪","Upper wall (member 2)",null,null,"Fixed",null,null,null,null,null,{"$f":"Materiály!C54","v":"clay"}]
[null,null,null,null,"=> Stiffness factor of the member",null,null,"n2","=",{"$f":"IF(H31=\"Fixed\",4,IF(H31=\"Hinge\",3,0))","v":4},null,null,null,{"$f":"Materiály!C58","v":"calcium silicate"}]
[null,null,null,"▪","Left span of the slab (member 3)",null,{"$f":"IF(AND(J34=0,J36=0),\"At least one horizontal member must be connected to the joint!!!\",\"\")","v":""},"Member does not exist",null,null,null,null,null,{"$f":"Materiály!C60","v":"concrete"}]
[null,null,null,null,"=> Stiffness factor of the member",null,null,"n3","=",{"$f":"IF(H33=\"Fixed\",4,IF(H33=\"Hinge\",3,0))","v":0},null,null,null,{"$f":"Materiály!C64","v":"autoclaved aerated concrete"}]
[null,null,null,"▪","Right span of the slab (member 4)",null,null,"Fixed",null,null,null,null,null,{"$f":"Materiály!C65","v":"manufactured stone"}]
[null,null,null,null,"=> Stiffness factor of the member",null,null,"n4","=",{"$f":"IF(H35=\"Fixed\",4,IF(H35=\"Hinge\",3,0))","v":4},null,null,null,{"$f":"Materiály!C66","v":"dimensioned natural stone"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"--select--"]
[null,null,"1.2.","Member lengths"]
[null,null,null,"▪","Clear height of wall 1",null,null,"h1","=",2750,"mm",null,null,{"$f":"Materiály!E53","v":"general purpose"}]
[null,null,null,"▪","Clear height of wall 2",null,null,"h2","=",2750,"mm",null,null,{"$f":"Materiály!F53","v":"thin layer (0,5-3 mm)"}]
[null,null,null,"▪","Clear span of slab 3 ",null,null,"l3","=",0,"mm",null,null,{"$f":"Materiály!H53","v":"lightweight (600 - 800 kg.m-3)"}]
[null,null,null,"▪","Clear span of slab 4",null,null,"l4","=",5000,"mm",null,null,{"$f":"Materiály!J53","v":"lightweight (800-1300 kg.m-3)"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"--select--"]
[null,null,"1.3.","Thickness of the cross-section"]
[null,null,null,"▪","Wall 1",null,null,"t1","=",440,"mm",null,null,"Yes"]
[null,null,null,"▪","Wall 2",null,null,"t2","=",440,"mm",null,null,"No"]
[null,null,null,"▪","Slab 3",null,null,"t3","=",0,"mm",null,null,"--select--"]
[null,null,null,"▪","Slab 4",null,null,"t4","=",200,"mm"]
[]
[null,null,"1.4.","Moments of inertia"]
[null,null,null,"▪","Wall 1",null,null,"I1","=",{"$f":"1/12*1000*POWER(J45,3)","v":7098666666.666666},"mm4"]
[null,null,null,"▪","Wall 2",null,null,"I2","=",{"$f":"1/12*1000*POWER(J46,3)","v":7098666666.666666},"mm4"]
[null,null,null,"▪","Slab 3",null,null,"I3","=",{"$f":"1/12*1000*POWER(J47,3)","v":0},"mm4"]
[null,null,null,"▪","Slab 4",null,null,"I4","=",{"$f":"1/12*1000*POWER(J48,3)","v":666666666.66666663},"mm4"]
[]
[]
[null,"2.","Material properties"]
[]
[null,null,"2.1.","Partial factor for masonry gM"]
[null,null,null,"▪","Masonry made with units of",null,"Category I, designed mortar"]
[null,null,null,"▪","Material of masonry units",null,"concrete"]
[null,null,null,"=>","Partial factor for masonry",null,null,"gM","=",{"$f":"VLOOKUP(G60,Materiály!C7:H9,IF(G61=\"porobetonové tvárnice\",3,5),FALSE)","v":2}]
[]
[null,null,"2.2.","Compressive strength of the masonry - lower wall",null,null,null,null,null,1]
[null,null,null,"Direct input of the value",null,null,null,"fk1","=",5.4,"MPa"]
[null,null,null,"Determination of the value by calculation"]
[null,null,null,"▪","Length of one masonry unit",null,null,"dp1","=",290,"mm"]
[null,null,null,"▪","Width of one masonry unit",null,null,"bp1","=",140,"mm"]
[null,null,null,"▪","Height of one masonry unit",null,null,"hp1","=",65,"mm"]
[]
[null,null,null,"▪","Group of masonry units"]
[null,null,null,null,"▪","Material of masonry units",null,null,null,{"$f":"G61","v":"concrete"}]
[null,null,null,null,"▪","Volume of holes in %","≤ 25 %"]
[null,null,null,null,"=>","Group of masonry units",null,null,null,{"$f":"IF(OR(J72=\"--select--\",G73=\"--select--\",G73=\"\"),\"Select material (J61) and % of holes (J73)\",IF(G73=N21,1,IF(G73=N22,2,IF(G73=N23,3,IF(G73=N24,4)))))","v":1}]
[]
[null,null,null,"▪","Normalised mean compressive strength of the units fb"]
[null,null,null,null,"▪","Strength of the material of masonry units (label)",null,"fu1","=",10,"MPa"]
[null,null,null,null,"▪","Conditioning method (usually: in the air)","in the air (by reaching 6% moisture content)"]
[null,null,null,null,"▪","Factor expressing the effect of conditioning method",null,"h1","=",{"$f":"VLOOKUP(G78,Materiály!C32:G34,5,FALSE)","v":1}]
[null,null,null,null,"▪","Factor expressing the effect of dimensions of the unit",null,"d1","=",{"$f":"Materiály!L45","v":0.77}]
[null,null,null,null,"=>","Normalised mean compressive strength of the units",null,"fb1","=",{"$f":"J77*J79*J80","v":7.7},"MPa"]
[]
[null,null,null,"▪","Compressive strength of the mortar (label)",null,null,"fm1","=",10,"MPa"]
[null,null,null,"▪","Coefficient K"]
[null,null,null,null,"▪","Material of masonry units",{"$f":"J72","v":"concrete"}]
[null,null,null,null,"▪","Mortar","general purpose"]
[null,null,null,null,"▪","Group of masonry units",null,null,null,{"$f":"J74","v":1}]
[null,null,null,null,"▪","Is there a longitudinal perpend joint in the masonry? (=> multiply table value of K by 0.8?)",null,null,null,"No"]
[null,null,null,null,"=>","Coefficient K",null,"K1","=",{"$f":"IF(J88=\"Yes\",0.8*Mapping!M26,Mapping!M26)","v":0.45}]
[]
[null,null,null,"▪","Characteristic compressive strength of the masonry",null,null,null,null,{"$f":"IF(J90=\"X\",\"The combination of mortar and masonry unit is not used, values are not defined\",\" \")","v":" "}]
[null,null,null,null,"▪","Value of fb considered (fb ≤ 50 MPa if thin layer mortar is used, fb ≤ 75 Mpa otherwise)",null,"fb1","=",{"$f":"MIN(J81,IF(G86=\"thin layer (0,5-3 mm)\",50,75))","v":7.7},"MPa"]
[null,null,null,null,"▪","Value of fm (fm ≤ 10 MPa if thin layer mortar is considered, fm ≤ min(20 MPa, 2fb) otherwise)",null,"fm1","=",{"$f":"MIN(J83,IF(G86=\"thin layer (0,5-3 mm)\",10,MIN(20,2*J92)))","v":10},"MPa"]
[]
[null,null,null,null,"=>","Characteristic compressive strength of the masonry",null,"fk1","=",{"$f":"IF(G86=\"thin layer (0,5-3 mm)\",IF(AND(G61=\"clay\",OR(J74=2,J74=3)),J89*POWER(J92,0.7),J89*POWER(J92,0.85)),J89*POWER(J92,0.7)*POWER(J93,0.3))","v":3.7476240851054521},"MPa"]
[null,null,null,null,null,"Formula used for calculation of characteristic compressive strength of the masonry:"]
[null,null,null,null,null,"▪     Masonry made with general purpose or lightweight mortar"]
[null,null,null,null,null,"▪     Masonry made with thin layer mortar, clay masonry units of groups 2 or 3"]
[null,null,null,null,null,"▪     Masonry made with thin layer mortar, masonry units other than clay units of groups 2 or 3"]
[null,null,null,"=>","Characteristic compressive strength of the masonry - lower wall",null,null,"fk1","=",{"$f":"IF(J64=1,J65,IF(J64=2,J95,\"Select option\"))","v":5.4},"MPa"]
[]
[null,null,"2.3.","Compressive strength of the masonry - upper wall",null,null,null,null,null,1]
[null,null,null,"Adopt the value from lower wall"]
[null,null,null,"Insert another value than for lower wall",null,null,null,"fk2","=",null,"MPa"]
[null,null,null,"Determination of the value by calculation"]
[null,null,null,"▪","Length of one masonry unit",null,null,"dp2","=",290,"mm"]
[null,null,null,"▪","Width of one masonry unit",null,null,"bp2","=",140,"mm"]
[null,null,null,"▪","Height of one masonry unit",null,null,"hp2","=",65,"mm"]
[]
[null,null,null,"▪","Group of masonry units"]
[null,null,null,null,"▪","Material of masonry units",null,null,null,{"$f":"G61","v":"concrete"}]
[null,null,null,null,"▪","Volume of holes in %","≤ 25 %"]
[null,null,null,null,"=>","Group of masonry units",null,null,null,{"$f":"IF(OR(J111=\"--select--\",G112=\"--select--\",G112=\"\"),\"Select material (J61) and % of holes (J112)\",IF(G112=N21,1,IF(G112=N22,2,IF(G112=N23,3,IF(G112=N24,4)))))","v":1}]
[]
[null,null,null,"▪","Normalised mean compressive strength of the units fb"]
[null,null,null,null,"▪","Strength of the material of masonry units (label)",null,"fu2","=",10,"MPa"]
[null,null,null,null,"▪","Conditioning method (usually: in the air)","in the air (by reaching 6% moisture content)"]
[null,null,null,null,"▪","Factor expressing the effect of conditioning method",null,"h2","=",{"$f":"VLOOKUP(G117,Materiály!C32:G34,5,FALSE)","v":1}]
[null,null,null,null,"▪","Factor expressing the effect of dimensions of the unit",null,"d2","=",{"$f":"Materiály!Q45","v":0.77}]
[null,null,null,null,"=>","Normalised mean compressive strength of the units",null,"fb2","=",{"$f":"J116*J118*J119","v":7.7},"MPa"]
[]
[null,null,null,"▪","Compressive strength of the mortar (label)",null,null,"fm2","=",10,"MPa"]
[null,null,null,"▪","Coefficient K"]
[null,null,null,null,"▪","Material of masonry units",{"$f":"J111","v":"concrete"}]
[null,null,null,null,"▪","Mortar","general purpose"]
[null,null,null,null,"▪","Group of masonry units",null,null,null,{"$f":"J113","v":1}]
[null,null,null,null,"▪","Is there a longitudinal perpend joint in the masonry? (=> multiply table value of K by 0.8?)",null,null,null,"Yes"]
[null,null,null,null,"=>","Coefficient K",null,"K2","=",{"$f":"IF(J127=\"Yes\",0.8*Mapping!M53,Mapping!M53)","v":0.36000000000000004}]
[]
[null,null,null,"▪","Characteristic compressive strength of the masonry",null,null,null,null,{"$f":"IF(J129=\"X\",\"The combination of mortar and masonry unit is not used, values are not defined\",\" \")","v":" "}]
[null,null,null,null,"▪","Value of fb considered (fb ≤ 50 MPa if thin layer mortar is used, fb ≤ 75 Mpa otherwise)",null,"fb2","=",{"$f":"MIN(J120,IF(G125=\"thin layer (0,5-3 mm)\",50,75))","v":7.7},"MPa"]
[null,null,null,null,"▪","Value of fm (fm ≤ 10 MPa if thin layer mortar is considered, fm ≤ min(20 MPa, 2fb) otherwise)",null,"fm2","=",{"$f":"MIN(J122,IF(G125=\"thin layer (0,5-3 mm)\",10,MIN(20,2*J131)))","v":10},"MPa"]
[]
[null,null,null,null,"=>","Characteristic compressive strength of the masonry",null,"fk2","=",{"$f":"IF(G125=\"thin layer (0,5-3 mm)\",IF(AND(G88=\"clay\",OR(J113=2,J113=3)),J128*POWER(J131,0.7),J128*POWER(J131,0.85)),J128*POWER(J131,0.7)*POWER(J132,0.3))","v":2.9980992680843621},"MPa"]
[null,null,null,null,null,"Formula used for calculation of characteristic compressive strength of the masonry:"]
[null,null,null,null,null,"▪     Masonry made with general purpose or lightweight mortar"]
[null,null,null,null,null,"▪     Masonry made with thin layer mortar, clay masonry units of groups 2 or 3"]
[null,null,null,null,null,"▪     Masonry made with thin layer mortar, masonry units other than clay units of groups 2 or 3"]
[null,null,null,"=>","Characteristic compressive strength of the masonry - upper wall",null,null,"fk2","=",{"$f":"IF(J102=1,J100,IF(J102=2,J104,IF(J102=3,J134,\"Select option\")))","v":5.4},"MPa"]
[]
[null,null,"2.4.","Elastic modulus of the masonry - lower wall",null,null,null,null,null,1]
[null,null,null,"Direct input of the value",null,null,null,"E1","=",6800,"MPa"]
[null,null,null,"Determine the value from the equation E1 = 1000fk1"]
[null,null,null,"=>","Elastic modulus of the masonry - lower wall",null,null,"E1","=",{"$f":"IF(J141=1,J142,IF(J141=2,J100*1000,\"Select option\"))","v":6800},"MPa"]
[]
[null,null,"2.5.","Elastic modulus of the masonry - upper wall",null,null,null,null,null,1]
[null,null,null,"Adopt the value from lower wall"]
[null,null,null,"Insert another value than for lower wall",null,null,null,"E2","=",null,"MPa"]
[null,null,null,"Determine the value from the equation E2 = 1000fk2"]
[null,null,null,"=>","Elastic modulus of the masonry - upper wall",null,null,"E2","=",{"$f":"IF(J146=1,J144,IF(J146=2,J148,IF(J146=3,J139*1000,\"Select option\")))","v":6800},"MPa"]
[]
[null,null,"2.6.","Elastic modulus of slab 3",null,null,null,"E3","=",0,"MPa"]
[]
[null,null,"2.7.","Elastic modulus of slab 4",null,null,null,"E4","=",30500,"MPa"]
[]
[]
[null,"3.","Loads"]
[]
[null,null,"▪","Design value of uniform continuous load of slab 3",null,null,null,"f3","=",0,"kN.m-2"]
[null,null,"▪","Design value of uniform continuous load of slab 4",null,null,null,"f4","=",12.48,"kN.m-2"]
[null,null,"▪","Design value of normal force in the bottom of upper wall 2",null,null,null,"NEd,2","=",134,"kN"]
[null,null,"▪","Design value of normal force in the top of lower wall 1",null,null,null,"NEd,1","=",164,"kN"]
[]
[]
[null,"4.","Calculation of bending moments according to eqations C.1 a C.2 from the Eurocode 6 (basic approach)"]
[]
[null,null,"4.1.","Reduction factor h"]
[null,null,null,"▪","Coefficient km",null,null,"km","=",{"$f":"MIN((IF(ISERROR(J34*J152*J53/J41),0,J34*J152*J53/J41)+IF(ISERROR(J36*J154*J54/J42),0,J36*J154*J54/J42))/(IF(ISERROR(J30*J144*J51/J39),0,J30*J144*J51/J39)+IF(ISERROR(J32*J150*J52/J40),0,J32*J150*J52/J40)),2)","v":0.11583920758386}]
[null,null,null,"▪","Coefficient h",null,null,"h","=",{"$f":"1-J168/4","v":0.97104019810403497}]
[]
[null,null,"4.2.","Bending moments (adjusted by reduction factor)"]
[null,null,null,"▪","Design value of bending moment in the top of wall 1"]
[null,null,null,null,null,null,null,"M1","=",{"$f":"-(IF(ISERROR(J30*J144*J51/J39),0,J30*J144*J51/J39)/(IF(ISERROR(J30*J144*J51/J39),0,J30*J144*J51/J39)+IF(ISERROR(J32*J150*J52/J40),0,J32*J150*J52/J40)+IF(ISERROR(J34*J152*J53/J41),0,J34*J152*J53/J41)+IF(ISERROR(J36*J154*J54/J42),0,J36*J154*J54/J42))*(IF(J34=0,0,J159)*POWER(J41,2)/(4*(J34-1))-IF(J36=0,0,J160)*POWER(J42,2)/(4*(J36-1))))*J169/1000000","v":11.313030129749896},"kNm"]
[null,null,null,"▪","Design value of bending moment in the bottom of wall 2"]
[null,null,null,null,null,null,null,"M2","=",{"$f":"-(IF(ISERROR(J32*J150*J52/J40),0,J32*J150*J52/J40)/(IF(ISERROR(J30*J144*J51/J39),0,J30*J144*J51/J39)+IF(ISERROR(J32*J150*J52/J40),0,J32*J150*J52/J40)+IF(ISERROR(J34*J152*J53/J41),0,J34*J152*J53/J41)+IF(ISERROR(J36*J154*J54/J42),0,J36*J154*J54/J42))*(IF(J34=0,0,J159)*POWER(J41,2)/(4*(J34-1))-IF(J36=0,0,J160)*POWER(J42,2)/(4*(J36-1))))*J169/1000000","v":11.313030129749896},"kNm"]
[null,null,null,"▪","Design value of bending moment in slab 3 immediately next to the joint"]
[null,null,null,null,null,null,null,"M3","=",{"$f":"(-IF(J34=0,0,J159)*POWER(J41,2)/(4*(J34-1))+(IF(ISERROR(J34*J152*J53/J41),0,J34*J152*J53/J41)/(IF(ISERROR(J30*J144*J51/J39),0,J30*J144*J51/J39)+IF(ISERROR(J32*J150*J52/J40),0,J32*J150*J52/J40)+IF(ISERROR(J34*J152*J53/J41),0,J34*J152*J53/J41)+IF(ISERROR(J36*J154*J54/J42),0,J36*J154*J54/J42))*(IF(J34=0,0,J159)*POWER(J41,2)/(4*(J34-1))-IF(J36=0,0,J160)*POWER(J42,2)/(4*(J36-1)))))*J169/1000000","v":0},"kNm"]
[null,null,null,"▪","Design value of bending moment in slab 4 immediately next to the joint"]
[null,null,null,null,null,null,null,"M4","=",{"$f":"(-IF(J36=0,0,J160)*POWER(J42,2)/(4*(J36-1))-(IF(ISERROR(J36*J154*J54/J42),0,J36*J154*J54/J42)/(IF(ISERROR(J30*J144*J51/J39),0,J30*J144*J51/J39)+IF(ISERROR(J32*J150*J52/J40),0,J32*J150*J52/J40)+IF(ISERROR(J34*J152*J53/J41),0,J34*J152*J53/J41)+IF(ISERROR(J36*J154*J54/J42),0,J36*J154*J54/J42))*(IF(J34=0,0,J159)*POWER(J41,2)/(4*(J34-1))-IF(J36=0,0,J160)*POWER(J42,2)/(4*(J36-1)))))*J169/1000000","v":-22.626060259499788},"kNm"]
[]
[]
[null,"5.","Calculation of bending moments in the parapet joint"]
[]
[null,null,"5.1.","Scheme and presumptions of the calculation"]
[null,null,null,null,null,"                         Presumption",null,null,null,"Met?"]
[null,null,null,null,null,"                         ▪     Upper wall and one of the slabs is missing",null,null,null,{"$f":"IF(AND(J32=0,OR(J34=0,J36=0)),\"Yes\",\"No\")","v":"No"}]
[null,null,null,null,null,"                         ▪     Eccentricity in the top of wall 1 is e1 = M1/NEd,1 ≥ 0,45t1",null,null,null,{"$f":"IF(J162=0,\"Yes\",IF(ABS(J173/J162)>=0.45*J45/1000,\"Yes\",\"No\"))","v":"No"}]
[]
[null,null,null,null,null,{"$f":"IF(AND(J186=\"Yes\",J187=\"Yes\"),(\"                         =>  Presumtions are met, bending moment in the top of wall 1 will be calculated as in the parapet joint\"),(\"                         =>  Presumtions are not met, this part of calculation will be ignored\"))","v":"                         =>  Presumtions are not met, this part of calculation will be ignored"}]
[]
[]
[]
[]
[null,null,"5.2.","Calculation in the top of wall 1"]
[null,null,null,"▪","Design compressive strength of the masonry of wall 1",null,null,"fd1","=",{"$f":"J100/J62","v":2.7},"MPa"]
[null,null,null,"▪","Minimum required bedding length",null,null,"x1","=",{"$f":"MIN(J162/J195,0.1*J45)","v":44},"mm"]
[null,null,null,"▪","Design value of bending moment in the top of wall 1",null,null,"M1","=",{"$f":"J162*(J45/2-J196)/1000","v":28.864000000000001},"kNm"]
[]
[]
[null,"6.","Calculation of bending moments according to eqations C.3 a C.4 from the Eurocode 6"]
[null,null,"(alternative approach for external joints where a slab is supported over part of the thickness of the wall)"]
[]
[null,null,"6.1.","Scheme and presumptions of the calculation"]
[null,null,null,null,null,"                                        Presumption",null,null,null,"Met?"]
[null,null,null,null,null,"                                        ▪     External joint",null,null,null,{"$f":"IF(OR(J34=0,J36=0),\"Yes\",\"No\")","v":"Yes"}]
[null,null,null,null,null,"                                        ▪     Not a parapet joint",null,null,null,{"$f":"IF(AND(J32=0,OR(J34=0,J36=0)),\"No\",\"Yes\")","v":"Yes"}]
[null,null,null,null,null,"                                        ▪     Slab is supported just over a part of the thickness of the wall,",null,null,null,{"$f":"IF(J208<>0,\"Yes\",\"No\")","v":"Yes"}]
[null,null,null,null,null,"                                               offset from the inner face of the wall is:",null,"a","=",180,"mm"]
[]
[null,null,null,null,null,{"$f":"IF(AND(J205=\"Yes\",J206=\"Yes\",J207=\"Yes\",J208<>0),(\"                                        =>  Presumptions are met, bending moments in the walls can be calculated\"),(\"                                        =>  Presumtions are not met, this part of calculation will be ignored\"))","v":"                                        =>  Presumptions are met, bending moments in the walls can be calculated"}]
[null,null,null,null,null,{"$f":"IF(AND(J205=\"Yes\",J206=\"Yes\",J207=\"Yes\",J208<>0),(\"                                              according to alternative approach. Nevertheless, the research results show that \"),(\"\"))","v":"                                              according to alternative approach. Nevertheless, the research results show that "}]
[null,null,null,null,null,{"$f":"IF(AND(J205=\"Yes\",J206=\"Yes\",J207=\"Yes\",J208<>0),(\"                                              the moments obtained by this method can be unsafe. Therefore, this approach\"),(\"\"))","v":"                                              the moments obtained by this method can be unsafe. Therefore, this approach"}]
[null,null,null,null,null,{"$f":"IF(AND(J205=\"Yes\",J206=\"Yes\",J207=\"Yes\",J208<>0),(\"                                              is not recommended. Do you want to use it anyway?\"),(\"\"))","v":"                                              is not recommended. Do you want to use it anyway?"},null,null,null,"No"]
[]
[]
[null,null,"6.2.","Calculation of bending moments in walls"]
[null,null,null,"▪","Design value of bending moment in the top of wall 1 1)",null,null,"M1","=",{"$f":"(J162-J161)*J208/2000+J161*(J45+J208)/4000","v":23.47},"kNm"]
[null,null,null,"▪","Design value of bending moment in the bottom of wall 2 1)",null,null,"M2","=",{"$f":"IF(J32=0,0,J161*(J45-3*J208)/4000)","v":-3.35},"kNm"]
[]
[null,null,null,"1)","Bending moments calculated in this part will be considered for the design of the wall only in case that they will be lower than the moments calculated according to the basic approach in part 4."]
[]
[]
[null,"7.","Final design bending moments and eccentricities"]
[]
[null,null,"7.1.","Bending moments",null,null,null,null,null,1]
[null,null,null,"▪",{"$f":"CONCATENATE(\"Design value of moment in the top of wall 1 (the value acc. to part \",IF(AND(J186=\"Yes\",J187=\"Yes\"),\"5\",IF(AND(J205=\"Yes\",J206=\"Yes\",J207=\"Yes\",J213=\"Yes\",ABS(J217)<ABS(J173)),\"6\",\"4\")),\" is considered)\")","v":"Design value of moment in the top of wall 1 (the value acc. to part 4 is considered)"},null,null,"M1","=",{"$f":"IF(AND(J186=\"Yes\",J187=\"Yes\"),J197,IF(AND(J205=\"Yes\",J206=\"Yes\",J207=\"Yes\",J213=\"Yes\",ABS(J217)<ABS(J173)),J217,J173))","v":11.313030129749896},"kNm"]
[null,null,null,"▪",{"$f":"CONCATENATE(\"Design value of moment in the bottom of wall 2 (the value acc. to part \",IF(AND(J205=\"Yes\",J206=\"Yes\",J207=\"Yes\",J213=\"Yes\",ABS(J218)<ABS(J175)),\"6\",\"4\"),\" is considered)\")","v":"Design value of moment in the bottom of wall 2 (the value acc. to part 4 is considered)"},null,null,"M2","=",{"$f":"IF(AND(J205=\"Yes\",J206=\"Yes\",J207=\"Yes\",J213=\"Yes\",ABS(J218)<ABS(J175)),J218,J175)","v":11.313030129749896},"kNm"]
[null,null,null,"▪","Design value of moment in slab 3 immediately next to the joint",null,null,"M3","=",{"$f":"IF(AND(J186=\"Yes\",J187=\"Yes\"),0,J177)","v":0},"kNm"]
[null,null,null,"▪","Design value of moment in slab 4 immediately next to the joint",null,null,"M4","=",{"$f":"IF(AND(J186=\"Yes\",J187=\"Yes\"),0,J179)","v":-22.626060259499788},"kNm"]
[]
[null,null,"7.2.","Eccentricities due to loads (signs are in line with the sign convention for wall moments)",null,null,null,null,null,2]
[null,null,null,"▪","Eccentricity in the top of wall 1"]
[null,null,null,null,"Calculate according to the Eurocode 6 using formula e1 = M1/NEd,1 ≤ 0,5t1"]
[null,null,null,null,"Calculate conservatively from characteristic value of normal force in the top of wall 1 2) using formula e1 = M1/NEk,1 ≤ 0,5t1"]
[null,null,null,null,"▪",{"$f":"IF(J32=0,\"DO NOT USE - parapet joint\",\"Characteristic value of normal force in the top of the wall 1\")","v":"Characteristic value of normal force in the top of the wall 1"},null,"NEk,1","=",125,"kN"]
[null,null,null,null,"=>","Eccentricity in the top of wall 1",null,"e1","=",{"$f":"IF(OR(J231=1,J32=0),IF(J162=0,J45/2,MIN(J45/2,J226/J162*1000)),IF(J231=2,IF(J235=0,J45/2,MIN(J45/2,J226/J235*1000)),\"Select option\"))","v":90.504241037999165},"mm"]
[]
[null,null,null,"▪","Eccentricity in the bottom of wall 2 according to formula e2 = M2d/N2d ≤ 0,5t2",null,null,"e2","=",{"$f":"IF(J161=0,J46/2,MIN(J46/2,J227/J161*1000))","v":84.425597983208178},"mm"]
[]
[null,null,null,"2)","Comparison of results calculated according to Eurocode 6 with numerical model have shown that the bending moments calculated in the top of lower wall for external joints may be underestimated by up to 30 % when the basic approach is used. By using characteristic value of normal force, the eccentricity will be increased by 35 - 50 %, which should eliminate the problem."]

{"sheet":"Materiály","index":1,"n_rows":82,"n_cols":18,"rows_kept":82,"cut":false,"hidden":false,"merged":[[81,3,81,4],[71,2,71,4],[72,3,72,4],[73,3,73,4],[74,3,74,4],[75,3,75,4],[76,3,76,4],[77,3,77,4],[78,3,78,4],[79,3,79,4],[37,14,37,17],[65,5,65,6],[61,5,61,6],[62,5,62,6],[63,5,63,6],[64,5,64,6],[59,9,59,10],[60,9,60,10],[57,5,57,6],[58,5,58,6],[55,9,55,10],[56,9,56,10],[54,7,54,8],[60,7,60,8],[63,9,63,10],[62,7,62,8],[63,7,63,8],[64,9,64,10],[65,9,65,10],[61,9,61,10],[62,9,62,10],[64,7,64,8],[65,7,65,8],[59,5,59,6],[60,5,60,6],[51,3,52,3],[50,2,50,10],[56,7,56,8],[51,4,51,10],[53,5,53,6],[54,5,54,6],[55,5,55,6],[53,7,53,8],[57,9,57,10],[58,9,58,10],[56,5,56,6],[55,7,55,8],[57,2,58,2],[59,2,62,2],[57,7,57,8],[58,7,58,8],[59,7,59,8],[61,7,61,8],[52,7,52,8],[52,9,52,10],[53,9,53,10],[54,9,54,10],[52,5,52,6],[37,9,37,12],[37,2,37,7],[24,5,24,6],[24,7,24,8],[27,7,27,8],[27,5,27,6],[30,2,30,5],[31,2,31,5],[32,2,32,5],[21,7,21,8],[19,5,19,6],[19,7,19,8],[20,3,20,8],[33,2,33,5],[6,6,6,7],[7,6,7,7],[8,6,8,7],[22,7,22,8],[17,2,17,8],[8,2,8,3],[6,4,6,5],[7,4,7,5],[18,3,18,8],[4,10,5,10],[4,11,5,11],[3,10,3,11],[5,4,5,5],[5,6,5,7],[4,4,4,7],[3,2,3,7],[4,2,5,3],[80,3,80,4],[25,5,25,6],[26,5,26,6],[25,7,25,8],[26,7,26,8],[29,2,29,6],[53,2,56,2],[38,3,38,7],[38,2,39,2],[51,2,52,2],[22,5,22,6],[8,4,8,5],[18,2,21,2],[23,5,23,6],[23,7,23,8],[21,4,21,6]]}
[]
[]
[]
[null,null,"Partial factor for masonry gM (according to Czech NA.2.1)"]
[null,null,"Masonry made with units of:",null,"Material of the units"]
[null,null,null,null,"Aerated concrete",null,"Other"]
[null,null,"Category I, designed mortar",null,2.5,null,2]
[null,null,"Category I, prescribed mortar",null,2.7,null,2.2000000000000002]
[null,null,"Category II",null,3,null,2.5]
[]
[null,null,"Category I = the producer guarantees that the compressive strength will be below the stated value for 5 % of the units at the most. Applicable for most units produced in EU countries."]
[null,null,"Category II = compressive strength does not meet the requirements for more than 5 % of the units. Natural stone units belong to this category."]
[null,null,"Designed mortar = produced in factory"]
[null,null,"Prescribed mortar = prepared on the construction site"]
[]
[]
[]
[null,null,"Groups of masonry units"]
[null,null,"Type of masonry units","Group"]
[null,null,null,1,2,3,null,4]
[null,null,null,"Volume of all holes (% of the gross volume)"]
[null,null,null,"-","Vertical holes",null,null,"Horizontal holes"]
[null,null,"concrete","≤ 25","25 - 60","60 - 70",null,"25 - 70"]
[null,null,"dimensioned natural stone","≤ 25","not used","not used",null,"not used"]
[null,null,"clay","≤ 25","25 - 55","55 - 70",null,"25 - 70"]
[null,null,"autoclaved aerated concrete","≤ 25","not used","not used",null,"not used"]
[null,null,"manufactured stone","≤ 25","not used","not used",null,"not used"]
[null,null,"calcium silicate","≤ 25","25 - 55","not used",null,"not used"]
[]
[null,null,"Factor expressing the effect of conditioning method h"]
[null,null,"Masonry units conditioned:",null,null,null,"h"]
[null,null,"in the air (by reaching 6% moisture content)",null,null,null,1]
[null,null,"by saturation (under the water)",null,null,null,1.2]
[null,null,"by drying (by reaching dried state)",null,null,null,0.8]
[]
[null,null,"Conditioning = reaching of equilibrium moisture content"]
[]
[null,null,"The d coefficient expressing effect of width and height of the brick",null,null,null,null,null,null,"Interpolation d1",null,null,null,null,"Interpolation d2"]
[null,null,"hp [mm]","bp [mm]"]
[null,null,null,50,100,150,200,250,null,"bp,limited",{"$f":"IF(Výpočet!J68<50,50,IF(Výpočet!J68>250,250,Výpočet!J68))","v":140},"pos. bp",{"$f":"MATCH(K40,D40:H40)","v":2},null,"bp,limited",{"$f":"IF(Výpočet!J107<50,50,IF(Výpočet!J107>250,250,Výpočet!J107))","v":140},"pos. bp",{"$f":"MATCH(P40,D40:H40)","v":2}]
[null,null,50,0.85,0.75,0.7,0.7,0.65,null,"hp,limited",{"$f":"IF(Výpočet!J69<50,50,IF(Výpočet!J69>250,250,Výpočet!J69))","v":65},"pos. hp",{"$f":"IF(K41<=250,MATCH(K41,C41:C46),250)","v":2},null,"hp,limited",{"$f":"IF(Výpočet!J108<50,50,IF(Výpočet!J108>250,250,Výpočet!J108))","v":65},"pos. hp",{"$f":"IF(P41<=250,MATCH(P41,C41:C46),250)","v":2}]
[null,null,65,0.95,0.85,0.75,0.7,0.65]
[null,null,100,1.1499999999999999,1,0.9,0.8,0.75,null,null,{"$f":"IF(K40=50,50,IF(K40=250,250,INDEX(D40:H40,M40)))","v":100},{"$f":"K40","v":140},{"$f":"IF(K40=50,50,IF(K40=250,250,INDEX(D40:H40,M40+1)))","v":150},null,null,{"$f":"IF(P40=50,50,IF(P40=250,250,INDEX(D40:H40,R40)))","v":100},{"$f":"P40","v":140},{"$f":"IF(P40=50,50,IF(P40=250,250,INDEX(D40:H40,R40+1)))","v":150}]
[null,null,150,1.3,1.2,1.1000000000000001,1,0.95,null,{"$f":"IF(K41=50,50,IF(K41=250,250,INDEX(C41:C46,M41)))","v":65},{"$f":"INDEX(D41:H46,M41,M40)","v":0.85},{"$f":"IF(K44=M44,K44,(L43-K43)/(M43-K43)*(M44-K44)+K44)","v":0.77},{"$f":"INDEX(D41:H46,M41,IF(M40=5,5,IF(K40=50,1,M40+1)))","v":0.75},null,{"$f":"IF(P41=50,50,IF(P41=250,250,INDEX(C41:C46,R41)))","v":65},{"$f":"INDEX(D41:H46,R41,R40)","v":0.85},{"$f":"IF(P44=R44,P44,(Q43-P43)/(R43-P43)*(R44-P44)+P44)","v":0.77},{"$f":"INDEX(D41:H46,R41,IF(R40=5,5,IF(P40=50,1,R40+1)))","v":0.75}]
[null,null,200,1.45,1.35,1.25,1.1499999999999999,1.1000000000000001,null,{"$f":"K41","v":65},{"$f":"IF(K44=K46,K44,K44-(J45-J44)/(J46-J44)*(K44-K46))","v":0.85},{"$f":"IF(L44=L46,L44,L44-(K45-K44)/(K46-K44)*(L44-L46))","v":0.77},{"$f":"IF(M44=M46,M44,M44-(J45-J44)/(J46-J44)*(M44-M46))","v":0.75},null,{"$f":"P41","v":65},{"$f":"IF(P44=P46,P44,P44-(O45-O44)/(O46-O44)*(P44-P46))","v":0.85},{"$f":"IF(Q44=Q46,Q44,Q44-(P45-P44)/(P46-P44)*(Q44-Q46))","v":0.77},{"$f":"IF(R44=R46,R44,R44-(O45-O44)/(O46-O44)*(R44-R46))","v":0.75}]
[null,null,250,1.55,1.45,1.35,1.25,1.1499999999999999,null,{"$f":"IF(K41=50,50,IF(K41=250,250,INDEX(C41:C46,M41+1)))","v":100},{"$f":"INDEX(D41:H46,IF(M41=6,6,IF(K41=50,1,M41+1)),M40)","v":1},{"$f":"IF(K46=M46,K46,(L43-K43)/(M43-K43)*(M46-K46)+K46)","v":0.92},{"$f":"INDEX(D41:H46,IF(M41=6,6,IF(K41=50,1,M41+1)),IF(M40=5,5,IF(K40=50,1,M40+1)))","v":0.9},null,{"$f":"IF(P41=50,50,IF(P41=250,250,INDEX(C41:C46,R41+1)))","v":100},{"$f":"INDEX(D41:H46,IF(R41=6,6,IF(P41=50,1,R41+1)),R40)","v":1},{"$f":"IF(P46=R46,P46,(Q43-P43)/(R43-P43)*(R46-P46)+P46)","v":0.92},{"$f":"INDEX(D41:H46,IF(R41=6,6,IF(P41=50,1,R41+1)),IF(R40=5,5,IF(P40=50,1,R40+1)))","v":0.9}]
[]
[null,null,"If a dimension is less than 50 mm, take the value for 50 mm"]
[null,null,"If a dimension is more than 250 mm, take the value for 250 mm"]
[]
[null,null,"K coefficient"]
[null,null,"Type of masonry units","Group","Mortar"]
[null,null,null,null,"general purpose","thin layer (0,5-3 mm)",null,"lightweight (600 - 800 kg.m-3)",null,"lightweight (800-1300 kg.m-3)"]
[null,null,"clay",1,0.55000000000000004,0.75,null,0.3,null,0.4]
[null,null,null,2,0.45,0.7,null,0.25,null,0.3]
[null,null,null,3,0.35,0.5,null,0.2,null,0.25]
[null,null,null,4,0.35,0.35,null,0.2,null,0.25]
[null,null,"calcium silicate",1,0.55000000000000004,0.8,null,"X",null,"X"]
[null,null,null,2,0.45,0.65,null,"X",null,"X"]
[null,null,"concrete",1,0.55000000000000004,0.8,null,0.45,null,0.45]
[null,null,null,2,0.45,0.65,null,0.45,null,0.45]
[null,null,null,3,0.4,0.5,null,"X",null,"X"]
[null,null,null,4,0.35,"X",null,"X",null,"X"]
[null,null,"autoclaved aerated concrete",1,0.55000000000000004,0.8,null,0.45,null,0.45]
[null,null,"manufactured stone",1,0.45,0.75,null,"X",null,"X"]
[null,null,"dimensioned natural stone",1,0.45,"X",null,"X",null,"X"]
[]
[null,null,"X = the combination of mortar and masonry unit is not used, values are not defined"]
[]
[]
[]
[null,null,"Elastic modulus of concrete"]
[null,null,"Concrete class","Elastic modulus [MPa]"]
[null,null,"C 12/15",26000]
[null,null,"C 16/20",27500]
[null,null,"C 20/25",29000]
[null,null,"C 25/30",30500]
[null,null,"C 30/37",32000]
[null,null,"C 35/45",33500]
[null,null,"C 40/50",35000]
[null,null,"C 45/55",36000]
[null,null,"C 50/60",37000]

{"sheet":"Mapping","index":2,"n_rows":53,"n_cols":16,"rows_kept":53,"cut":false,"hidden":false,"merged":[[50,9,50,11],[52,9,52,11],[37,2,42,2],[43,2,46,2],[47,2,49,2],[48,9,48,11],[49,9,49,11],[31,2,31,4],[31,6,31,12],[32,6,33,6],[32,7,33,7],[32,8,33,8],[32,9,32,12],[33,2,36,2],[20,2,22,2],[10,2,15,2],[16,2,19,2],[4,15,6,17],[21,9,21,11],[4,2,4,4],[4,6,4,12],[5,9,5,12],[5,8,6,8],[6,2,9,2],[25,9,25,11],[22,9,22,11],[23,9,23,11],[5,6,6,6],[5,7,6,7]]}
[]
[]
[null,null,"Coefficient K1"]
[]
[null,null,"MappingTable",null,null,null,"LookUpTable for K",null,null,null,null,null,null,null,null,"This sheet serves as an aid for automatic lookup of certain values"]
[null,null,"A","Item","Code",null,"Element","Group","Element +Group","Mortar"]
[null,null,"Group",1,1,null,null,null,null,100,200,300,400]
[null,null,null,2,2,null,10,1,{"$f":"G8+H8","v":11},0.55000000000000004,0.75,0.3,0.4]
[null,null,null,3,3,null,10,2,{"$f":"G9+H9","v":12},0.45,0.7,0.25,0.3]
[null,null,null,4,4,null,10,3,13,0.35,0.5,0.2,0.25]
[null,null,"Element","concrete",30,null,10,4,14,0.35,0.35,0.2,0.25]
[null,null,null,"dimensioned natural stone",60,null,20,1,21,0.55000000000000004,0.8,"X","X"]
[null,null,null,"clay",10,null,20,2,22,0.45,0.65,"X","X"]
[null,null,null,"autoclaved aerated concrete",40,null,30,1,31,0.55000000000000004,0.8,0.45,0.45]
[null,null,null,"manufactured stone",50,null,30,2,32,0.45,0.65,0.45,0.45]
[null,null,null,"calcium silicate",20,null,30,3,33,0.4,0.5,"X","X"]
[null,null,"Mortar","general purpose",300,null,30,4,34,0.35,"X","X","X"]
[null,null,null,"thin layer (0,5-3 mm)",400,null,40,1,41,0.55000000000000004,0.8,0.45,0.45]
[null,null,null,"lightweight (600 - 800 kg.m-3)",100,null,50,1,51,0.45,0.75,"X","X"]
[null,null,null,"lightweight (800-1300 kg.m-3)",200,null,60,1,61,0.45,"X","X","X"]
[null,null,"Codes","GroupCode",{"$f":"VLOOKUP(Výpočet!J87,Mapping!D7:E10,2,FALSE)","v":1}]
[null,null,null,"ElementCode",{"$f":"VLOOKUP(Výpočet!G85,Mapping!D11:E16,2,FALSE)","v":30},null,null,null,null,"Element+GroupCode Row",null,null,{"$f":"MATCH(E22+E21,I8:I20,FALSE)","v":7}]
[null,null,null,"MortarCode",{"$f":"VLOOKUP(Výpočet!G86,Mapping!D17:E20,2,FALSE)","v":300},null,null,null,null,"MortarCode Column",null,null,{"$f":"MATCH(E23,J7:M7,FALSE)","v":3}]
[null,null,null,null,null,null,null,null,null,"Coefficient K",null,null,{"$f":"INDEX(J8:M20,M22,M23)","v":0.45}]
[]
[null,null,null,null,null,null,null,null,null,"TransferValue",null,null,{"$f":"IF(ISERROR(Mapping!M24)=TRUE,\"X\",IF(Mapping!M24=\"X\",\"X\",Mapping!M24))","v":0.45}]
[]
[]
[]
[null,null,"Coefficient K2"]
[]
[null,null,"MappingTable",null,null,null,"LookUpTable for K"]
[null,null,"A","Item","Code",null,"Element","Group","Element +Group","Mortar"]
[null,null,"Group",1,1,null,null,null,null,100,200,300,400]
[null,null,null,2,2,null,10,1,{"$f":"G35+H35","v":11},0.55000000000000004,0.75,0.3,0.4]
[null,null,null,3,3,null,10,2,{"$f":"G36+H36","v":12},0.45,0.7,0.25,0.3]
[null,null,null,4,4,null,10,3,13,0.35,0.5,0.2,0.25]
[null,null,"Element","concrete",30,null,10,4,14,0.35,0.35,0.2,0.25]
[null,null,null,"dimensioned natural stone",60,null,20,1,21,0.55000000000000004,0.8,"X","X"]
[null,null,null,"clay",10,null,20,2,22,0.45,0.65,"X","X"]
[null,null,null,"autoclaved aerated concrete",40,null,30,1,31,0.55000000000000004,0.8,0.45,0.45]
[null,null,null,"manufactured stone",50,null,30,2,32,0.45,0.65,0.45,0.45]
[null,null,null,"calcium silicate",20,null,30,3,33,0.4,0.5,"X","X"]
[null,null,"Mortar","general purpose",300,null,30,4,34,0.35,"X","X","X"]
[null,null,null,"thin layer (0,5-3 mm)",400,null,40,1,41,0.55000000000000004,0.8,0.45,0.45]
[null,null,null,"lightweight (600 - 800 kg.m-3)",100,null,50,1,51,0.45,0.75,"X","X"]
[null,null,null,"lightweight (800-1300 kg.m-3)",200,null,60,1,61,0.45,"X","X","X"]
[null,null,"Codes","GroupCode",{"$f":"VLOOKUP(Výpočet!J113,Mapping!D34:E37,2,FALSE)","v":1}]
[null,null,null,"ElementCode",{"$f":"VLOOKUP(Výpočet!G124,Mapping!D38:E43,2,FALSE)","v":30},null,null,null,null,"Element+GroupCode Row",null,null,{"$f":"MATCH(E49+E48,I35:I47,FALSE)","v":7}]
[null,null,null,"MortarCode",{"$f":"VLOOKUP(Výpočet!G125,Mapping!D44:E47,2,FALSE)","v":300},null,null,null,null,"MortarCode Column",null,null,{"$f":"MATCH(E50,J34:M34,FALSE)","v":3}]
[null,null,null,null,null,null,null,null,null,"Coefficient K",null,null,{"$f":"INDEX(J35:M47,M49,M50)","v":0.45}]
[]
[null,null,null,null,null,null,null,null,null,"TransferValue",null,null,{"$f":"IF(ISERROR(Mapping!M51)=TRUE,\"X\",IF(Mapping!M51=\"X\",\"X\",Mapping!M51))","v":0.45}]

{"sheet":"Nápověda","index":3,"n_rows":19,"n_cols":4,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"1.","General"]
[null,null,"▪","The calculation is in accordance with valid standards, mainly Eurocode 1 and Eurocode 6."]
[null,null,"▪","Program was created as a tool for determination of load eccentricity of masonry walls in any type of joint. The fact that some members might not exist in external or parapet joints is taken into account in the beginning of the calculation."]
[null,null,"▪","Excel spreadsheet for determination of eccentricity worked out by Ing. Pavel Košatka, CSc. in 2004 was consulted during preparation of this program. This program updates Košatka's spreadsheet, expands its applicability and improves user interface."]
[null,null,"▪","Automatic cells are calculated based on the formulas presented in the program or adpoted from the tables. "]
[null,null,"▪","For full functionality of the program, it is necessary to enable macros, otherwise the buttons will not work (remaining functions will be preserved)."]
[]
[null,"2.","Data input"]
[null,null,"▪","Only white cells are meant for user input. All white cells must be filled in for correct calculation. The rest of the cells is locked by default to prevent unwanted changes in formulas. If needed, the sheets can be unlocked anytime as no password is set."]
[null,null,"▪","Grey cells behave like white ones, changes are allowed. Nevertheless, they are inactive - they do not influence the calculation. They are taken into account only after proper radio button is selected and the cell becomes white."]
[null,null,"▪","After activation of some white cells, list of possible entry values appears. In that case, program will not allow the user to insert the value that is not in the list. If the user is not sure about the selection of the value, the information required might be in some cases obtained by clicking on the button in the beginning of respective section of the calculation. After reading the information, the user can return back to initial position by clicking \"Back\" button. In any case, a value must be filled in, otherwise successful calculation will not be possible."]
[null,null,"▪","In several places in the program one must select one of the proposed calculation scenarios. After selecting the options, further parameters must be specified to finish the calculation. "]
[null,null,"▪","Entering some evidently uncorrect values like negative dimension of bricks etc. is prohibited by the program. In some other cases, when the value seems to be incorrect, red warning informing the user about inappropriate entry appears before the value (e.g. when no horizontal member is entered)."]
[null,null,"▪","To delete all the manually entered values, use \"Delete input values\" button from the menu"]
[]
[null,"3.","Print"]
[null,null,"▪","All the sheets are set up for printing to A4 papers"]