{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["General conditions","Design","Resistance values_HIDDEN"],"not_rendered":{"images":18,"macros":1,"defined_names":21},"read":"whole","date_system":"1900"}

{"sheet":"General conditions","index":0,"n_rows":63,"n_cols":5,"rows_kept":63,"merged":[[1,3,3,3],[2,4,3,4],[6,2,8,4],[11,1,11,4],[15,2,15,4],[19,2,19,4],[23,2,23,4],[27,2,27,4],[31,2,31,4],[35,2,35,4],[39,2,39,4],[43,2,43,4],[47,2,47,4],[51,2,51,4],[55,2,55,4],[59,2,59,4],[60,2,60,4],[62,0,64,5]]}
[]
[{"$nulls":3},"GIRAFFE_CALCULATOR\nv1.0","Language"]
[{"$nulls":4},"EN"]
[]
[]
[{"$nulls":3},"GIRAFFE CALCULATOR"]
[null,null,"GENERAL TERMS AND CONDITIONS OF THE LICENSE AGREEMENT FOR THE USE OF THE SPREADSHEET \"GIRAFFE_CALCULATOR\""]
[]
[]
[]
[]
[null,{"$error":"#VALUE!"}]
[]
[null,"1. SUBJECT"]
[]
[null,null,"With these General Terms and Conditions (or \"Agreement\"), ROTHO BLAAS SRL, with registered office at I-39040 Cortaccia (BZ), Via dell'Adige 2/1 (hereinafter \"RB\") grants the user the non-exclusive and revocable right to use the spreadsheet (hereinafter \"XLS\") free of charge under the following conditions and during the term of this Agreement.\n\nIn any case, RB does not guarantee the legal and design conformity of the calculations, as RB intends to provide only an indicative calculation tool to be considered as a technical-commercial service within the sales activity.\n\nXLS allows the user to perform static calculations only for the products and materials indicated in each of its sections. This Agreement expressly prohibits to use XLS to manufacture products that are not indicated.\n\nThis Agreement therefore governs the relationship between the User and RB with respect to the use of this spreadsheet. By downloading and using XLS, the user accepts this Agreement and the conditions set out herein."]
[]
[null,"2. TECHNICAL-STANDARDS REFERENCES"]
[]
[null,null,"RB carried out the checks according to the Limit State method in accordance with with EN 1995:2014, EN 1993:2005 and in accordance with the ETA-11/0030 certificate and the tests carried out; they refer exclusively to the assembly support, type of fastening and angle of inclination indicated."]
[]
[null,"3. RB RIGHTS AND OBLIGATIONS"]
[]
[null,null,"RB:\n\na) makes available XLS to the User free of charge, as it is;\n\nb) does not provide the user with any technical support for using XLS;\n\nc) does not guarantee that XLS complies with the regulations in force or with the calculations design made using it. In particular, as a result of changes to the relevant provisions, such as standards, approvals, etc., the spreadsheet may become invalid in part or in full.\n\nd) while reserving the right to update, revise and develop XLS, RB does not assume any obligation towards the user to verify, correct, complete or update the spreadsheet and/or make the updates available to the user."]
[]
[null,"4. USER RIGHTS AND OBLIGATIONS"]
[]
[null,null,"The User declares to use the spreadsheet as a professional excluding any use as a consumer, and to always comply with the following obligations and prohibitions:\n\na) obligation and responsibility to verify that XLS meets the specific needs and that it is compatible with the hardware-software-systems;\n\nb) obligation to verify, for each use, the compliance of the calculations made through XLS to the regulations in force and to the project;\n\nc) obligation to verify the legal compliance of the calculations made through the Software;\n\nd) obligation to use the latest version of XLS made available by the RB contact person, checking at each use for any updates that have occurred;\n\ne) prohibition to use XLS for products not indicated in each calculation section;\n\nf) obligation to use updated antivirus software that complies with the industry standard in force;\n\ng) obligation not to assign the licence to use XLS to third parties and/or in any other way transfer, pledge or lease, rent or share with others or sublicense the rights to use the spreadsheet;\n\nh) prohibition to modify or vary XLS in any way, including through third parties.\n\nThe user commits himself to ask the RB contact person for the last version of the XLS."]
[]
[null,"5. COPYRIGHTS"]
[]
[null,null,"The copyrights on the formulations referred to in the spreadsheet and all the intellectual and industrial property rights underlying them (such as, but not limited to: trademarks, patents, trade secrets, know-how, confidential information) are and remain the exclusive property of RB. \n\nThis agreement does not transfer any of the above rights to the user."]
[]
[null,"6. DURATION, WITHDRAWAL AND TERMINATION"]
[]
[null,null,"These general conditions and, consequently, the licence to use the spreadsheet, are valid from the moment of downloading it until the termination of its use.\n\nThe user may withdraw from this Agreement at any time by deleting the XLS and all copies from its systems.\n\nRB may withdraw from this Agreement and deactivate the service in the event of a breach of any of the provisions governing the license of use. In the event that RB notifies its termination, the user shall remove the spreadsheet and any copies thereof from its systems."]
[]
[null,"7. RESPONSIBILITY"]
[]
[null,null,"The user is solely responsible for the use of XLS, including, but not limited to, all calculations, printouts, export data made with it and/or for entry errors, protection of data files and maintenance and in general for any use of the spreadsheet.\n\nRB does not guarantee and in no case can be held responsible for damages, losses and costs or other consequences, for any reason (warranty for defects, warranty for malfunction, product or legal responsibility, etc.) deriving from:\n\n•   use of XLS, calculations made, compliance with current legislation, with the design or other User needs;\n\n•   hardware and software compatibility, viruses, malfunctions, defects, errors or gaps;\n\n•   failure to update the spreadsheet and/or interruption of the availability of the spreadsheet and/or termination of the agreement for any reason;\n\n•   infringement of intellectual property rights of third parties.\n\nThe user confirms to have understood and accepted the disclaimers and limitations of liability and claim of this Agreement. The user also confirms that the spreadsheet is available for free, that the exclusions and limitations are fundamental elements of this Agreement and that RB does not make its spreadsheet available to the user if the exclusions or limitations are deleted or modified in favour of the user."]
[]
[null,"8. REFUND"]
[]
[null,null,"The user agrees to indemnify and hold harmless RB, its subsidiaries and its or its officers, directors, employees, successors and appointees (each individually, \"\"Beneficiary\"\", collectively, the \"\"Beneficiaries\"\") for the costs incurred in relation to claims made by third parties for damages or losses deriving from the use of the spreadsheet by the user (including, but not limited to, fees and management costs incurred by RB)."]
[]
[null,"9. MISCELLANEOUS"]
[]
[null,null,"As indicated on the German version of ALUMEGA technical data sheet, VGU is not available on the German market, where ALUMEGA can be sold only in combination with VGU DE.\nThese general conditions constitute the entire agreement between RB and the user regarding the subject matter and replace all previous, oral or written agreements, as well as any agreements between RB and the user."]
[]
[null,"10. LANGUAGE"]
[]
[null,null,"In the event of differences between versions of these conditions in the various languages, the English text is binding and takes precedence with respect to the translations."]
[]
[null,"11. APPLICABLE LAW AND COURT OF JURISDICTION"]
[]
[null,null,"This agreement and any relationship between the parties is governed exclusively by the Italian law. \nAny dispute that may arise between the parties in relation to this agreement, that cannot be resolved amicably, shall be brought before the court of Bolzano."]
[]
[null,"12. PRIVACY"]
[]
[null,null,"Refer to the privacy policy available at the link:"]
[null,null,"https://www.rothoblaas.com/privacy-policy"]
[]
["ACCEPT"]

{"sheet":"Design","index":1,"n_rows":143,"n_cols":10,"rows_kept":143,"merged":[[3,1,3,2],[3,3,3,7],[4,1,4,2],[4,3,4,7],[5,3,5,7],[11,1,11,9],[12,1,12,9],[56,4,56,5],[58,4,58,5],[59,4,59,5],[60,4,60,5],[60,7,60,8],[61,4,61,5],[61,7,61,8],[72,4,72,5],[100,2,100,3],[103,6,104,8],[107,3,107,5],[109,6,109,9],[115,1,117,9],[138,1,139,9],[140,1,141,9],[142,1,143,9]]}
[]
[null,"Project Informations"]
[]
[null,"Data",null,"abcde"]
[null,"Project",null,"abcde",{"$nulls":4}," "]
[null,"Wall number/code",null,"abcde"]
[]
[null,"Design loads",{"$nulls":4},"(reverse wind direction)"]
[]
[null,"Ultimate wind load",null," pult",0.5,"kPa",{"$f":"-1*E10","v":{"v":-0.5,"d":"-0.50"}},"kPa","kN/m2"]
[]
[null,"The wind load must be calculated according to the local standard used for the project ."]
[null,"It is required to include the load with the right safety factores according to local standard."]
[]
[null,"Wall geometry"]
[]
[null,"Wall height",null,"wh",3,"m",{"$f":"E17","v":3},"m"]
[null,"Wall length",null,"wL",12,"m",{"$f":"E18","v":12},"m"]
[null,"Wall Area",null,"wA",{"$f":"E18*E17","v":36},"m2",{"$f":"E19","v":36},"m"]
[]
[null,"GIRAFFE geometry"]
[]
[null,"Height",null,"a",1.8,"m",{"$f":"E23","v":1.8},"m"]
[null,"Angle",null,"Φ",60,"deg",60,"deg"]
[null,"Horizontal",null,"b",{"$f":"E23/TAN(RADIANS(E24))","v":{"v":1.0392304845413267,"d":"1.04"}},"m",{"v":1.0392304845413267,"d":"1.04"},"m"]
[null,"Length",null,"L",{"$f":"SQRT(E25^2+E23^2)","v":{"v":2.078460969082653,"d":"2.08"}},"m",{"v":2.078460969082653,"d":"2.08"},"m"]
[null,"Spacing",null,"s",3,"m",{"$f":"E27","v":3},"m"]
[]
[null,"Reactions"]
[]
[null,"A (horizontal)",null,null,{"$f":"(E10*E27*E17)-((E10*E27*E17^2)/(2*E23))","v":0.75},"kN",{"$f":"(G10*G27*G17)-((G10*G27*G17^2)/(2*G23))","v":-0.75},"kN"]
[null,"A (vertical)",null,null,{"$f":"E34","v":{"v":6.495190528383288,"d":"6.50"}},"kN",{"$f":"G34","v":{"v":-6.495190528383288,"d":"-6.50"}},"kN"]
[null,"B (horizontal)",null,null,{"$f":"(E10*E27*E17^2)/(2*E23)","v":3.75},"kN",{"$f":"(G10*G27*G17^2)/(2*G23)","v":-3.75},"kN"]
[null,"B (vertical)",null,null,{"$f":"E33*TAN(RADIANS(E24))","v":{"v":6.495190528383288,"d":"6.50"}},"kN",{"$f":"G33*TAN(RADIANS(G24))","v":{"v":-6.495190528383288,"d":"-6.50"}},"kN"]
[null,"C (horizontal)",null,null,{"$f":"E33","v":3.75},"kN",{"$f":"G33","v":-3.75},"kN"]
[null,"C (vertical)",null,null,{"$f":"E34","v":{"v":6.495190528383288,"d":"6.50"}},"kN",{"$f":"G34","v":{"v":-6.495190528383288,"d":"-6.50"}},"kN"]
[]
[]
[]
[]
[]
[{"$nulls":8},"DATASHEET"]
[{"$nulls":8},"GIRAFFE"]
{"$rows_empty":11}
[null,"GIRAFFE Design "]
[]
[null,"Load",null,null,{"$f":"SQRT(E33^2+E34^2)","v":{"v":7.499999999999998,"d":"7.50"}},null,"kN"]
[]
[null,"Type",null,null,"GIR4000"]
[null,"Deflection",null,null,1750]
[null,"Capacity",null,null,{"$f":"VLOOKUP(E59&\"_\"&E60,'Resistance values_HIDDEN'!F3:G13,2,0)","v":29.48},null,"kN",{"$f":"E57/E61","v":{"v":0.2544097693351424,"d":"25%"}}]
[null,"Bottom and top plate",null,null,{"$f":"IF(E59=\"GIR6000\",\"GIRPLATEL\",\"GIRPLATE\")","v":"GIRPLATE"},null,null,{"$f":"IF(E61>E57,\"Pass\",\"Fail\")","v":"Pass"}]
[]
[null,"CONNECTIONS CHECK"]
[]
[null,"Head to timber"]
[]
[null,"Design loads"]
[null,"Shear",null,"Fv",{"$f":"E34","v":{"v":6.495190528383288,"d":"6.50"}},"kN"]
[null,"Tension",null,"Fax",{"$f":"E33","v":3.75},"kN"]
[]
[null,"Connection geometry"]
[null,"Screws",null,null,"HBS PLATE"]
[null,"Diameter",null,"d1",10,"mm"]
[null,"Length",null,"L",100,"mm"]
[null,"Quantity",null,null,2,"un"]
[null,"Steel plate thickness",null,null,{"$f":"IF(E62=\"GIRPLATE\",4,6)","v":4},"mm"]
[]
[null,"Connector characteristic resistance"]
[null,"Shear",null,"Rv,90,k",{"$f":"_xlfn.XLOOKUP($E$75,'Resistance values_HIDDEN'!$J$4:$J$8,'Resistance values_HIDDEN'!$K$4:$K$8)","v":5.52},"kN"]
[null,"Axial",null,"Rax,90,k",{"$f":"_xlfn.XLOOKUP($E$75,'Resistance values_HIDDEN'!$J$4:$J$8,'Resistance values_HIDDEN'!L4:L8)","v":8.78},"kN"]
[null,"Tensile capacity",null,"Rtens,k",{"$f":"_xlfn.XLOOKUP($E$75,'Resistance values_HIDDEN'!$J$4:$J$8,'Resistance values_HIDDEN'!M4:M8)","v":{"v":40,"d":"40.00"}},"kN"]
[]
[null,"Safety factors"]
[null,"γm:",null,null,{"v":1.3,"d":"1.30"},"(Connections)",{"$nulls":3},"EN1995-1"]
[null,"kmod:",null,null,0.9,"(SC3/instantaneous, recommended)",{"$nulls":3},"EN1995-1"]
[]
[null,"Connection design resistance"]
[null,"Shear capacity",null,"Rv,90,d",{"$f":"E86*E80/E85","v":{"v":3.8215384615384616,"d":"3.82"}},"kN"]
[null,"Axial capacity",null,"Rax,d",{"$f":"E86*E81/E85","v":{"v":6.0784615384615375,"d":"6.08"}},"kN"]
[]
[null,"Screw verification"]
[]
[{"$nulls":4},"Shear","Axial","Combined"]
[{"$nulls":3},"Load",{"$f":"E69/2","v":{"v":3.247595264191644,"d":"3.25"}},{"$f":"ABS(E70/2)","v":{"v":1.875,"d":"1.88"}}]
[{"$nulls":3},"Capacity",{"$f":"E89*E76","v":{"v":7.643076923076923,"d":"7.64"}},{"$f":"E90*(E76^0.9)","v":{"v":11.342810306344386,"d":"11.34"}}]
[{"$nulls":3},"Utilisation",{"$f":"E95/E96","v":{"v":0.42490678778674895,"d":"42%"}},{"$f":"F95/F96","v":{"v":0.1653029495654401,"d":"17%"}},{"$f":"E97^2+F97^2","v":{"v":0.20787084344228773,"d":"21%"}}]
[{"$nulls":4},{"$f":"IF(E97<1,\"Pass\",\"Fail\")","v":"Pass"},{"$f":"IF(F97<1,\"Pass\",\"Fail\")","v":"Pass"},{"$f":"IF(G97<1,\"Pass\",\"Fail\")","v":"Pass"}]
[]
[]
[null,"Base to ","CONCRETE"]
[]
[null,"Design loads"]
[null,"Shear",null,"Fv",{"$f":"E35","v":3.75},"kN"]
[null,"Tension",null,"Fax",{"$f":"E36","v":{"v":6.495190528383288,"d":"6.50"}},"kN"]
[]
[null,"Connection geometry"]
[null,"Screws",null,{"$f":"IF(C101=\"CONCRETE\",\"SKR\",\"HBS PLATE\")","v":"SKR"}]
[null,"Diameter",null,"d1",{"$f":"IF(C101=\"CONCRETE\",12,10)","v":12},"mm"]
[null,"Length",null,"L",100,"mm"]
[null,"Quantity",null,null,2,"un"]
[]
[null,"Connector characteristic resistance "]
[null,"Shear",null,{"$f":"IF(C101=\"CONCRETE\",\"NRk,s/Rk,cp\",\"Rv,90,d\")","v":"NRk,s/Rk,cp"},{"$f":"IF(C101=\"CONCRETE\",32.4,(_xlfn.XLOOKUP($E$110,'Resistance values_HIDDEN'!$J$4:$J$8,'Resistance values_HIDDEN'!$K$4:$K$8)))","v":{"v":32.4,"d":"32.40"}},"kN"]
[null,"Axial",null,{"$f":"IF(C101=\"CONCRETE\",\"NRk,p\",\"Rax,d\")","v":"NRk,p"},{"$f":"IF(C101=\"CONCRETE\",IF(E113=\"CRACKED CONCRETE\",9.25,8.91),_xlfn.XLOOKUP($E$110,'Resistance values_HIDDEN'!$J$4:$J$8,'Resistance values_HIDDEN'!L4:L8))","v":8.91},"kN"]
[null,"Due to the various failure modes on the concrete side, a more comprehensive analysis is required. To achieve this, we recommend downloading the MYPROJECT CONCRETE ANCHOR DESIGN software and input the dimensions of the GIRPLATE or GIRPLATEL plate. Subsequently, proceed with the analysis considering the design forces."]
[]
[]
[null,"Safety factors"]
[null,"kmod",null,null,0.9,"(Service class 3 and instantaneous)"]
[null,{"$f":"IF(C101=\"CONCRETE\",\"γMp\",\"Ym\")","v":"γMp"},null,null,{"$f":"IF(C101=\"CONCRETE\",2.1,1.3)","v":{"v":2.1,"d":"2.10"}},"(tension failure, cracked concrete)"]
[null,"γMs,Mc",null,null,{"v":1.5,"d":"1.50"},"(shear failure, cracked concrete)"]
[]
[null,"Connector design resistance"]
[null,"Axial",null,{"$f":"IF(C101=\"CONCRETE\",\"NRd,p\",\"Rv,90,d\")","v":"NRd,p"},{"$f":"E120*E115/E121","v":{"v":3.8185714285714285,"d":"3.82"}},"kN"]
[null,"Shear",null,{"$f":"IF(C101=\"CONCRETE\",\"NRd,s/Rk,cp\",\"Rax,d\")","v":"NRd,s/Rk,cp"},{"$f":"IF(C101=\"CONCRETE\",E121*E114/E121,E114*E120/E121)","v":{"v":32.4,"d":"32.40"}},"kN"]
[null,null,"SOFTWARE",null,"DATASHEET SKR"]
[null,"Screw verification"]
[]
[{"$nulls":4},"Shear","Axial","Combined"]
[{"$nulls":3},"Load",{"$f":"E104","v":3.75},{"$f":"ABS(E105)","v":{"v":6.495190528383288,"d":"6.50"}}]
[{"$nulls":3},"Capacity",{"$f":"E125*E111","v":{"v":7.637142857142857,"d":"7.64"}},{"$f":"E126*IF(C101=\"CONCRETE\",E111,(E111^0.9))","v":{"v":64.8,"d":"64.80"}}]
[{"$nulls":3},"Utilisation",{"$f":"E131/E132","v":{"v":0.4910213243546577,"d":"49%"}},{"$f":"F131/F132","v":{"v":0.10023442173431,"d":"10%"}},{"$f":"E133^2+F133^2","v":{"v":0.25114888027141347,"d":"25%"}}]
[{"$nulls":4},{"$f":"IF(E133<1,\"Pass\",\"Fail\")","v":"Pass"},{"$f":"IF(F133<1,\"Pass\",\"Fail\")","v":"Pass"},{"$f":"IF(G133<1,\"Pass\",\"Fail\")","v":"Pass"}]
[]
[]
[null,"NOTES"]
[]
[null,"The load capacities refer exclusively to the assembly support, type of fastening and angle of inclination indicated."]
[]
[null,"When fastening the bottom or top plate, the maximum permissible screwing torque of the fastenings elements must be observed."]
[]
[null,"Prerequisites for the load-bearing capacity assumption are the complete screwing of the screws and compliance with the minimum distances from the edge."]

{"sheet":"Resistance values_HIDDEN","index":2,"n_rows":28,"n_cols":14,"rows_kept":28,"hidden":true,"merged":[[9,8,9,13],[10,8,11,8],[10,9,11,9],[10,10,10,11],[10,12,10,13],[12,10,20,10],[12,11,20,11],[12,12,20,12],[12,13,20,13],[22,2,22,9],[23,2,24,3],[23,4,24,4],[23,5,23,9],[25,2,25,3],[26,2,26,3],[27,2,27,3]]}
[]
[null,"GIRAFFE",null,"GIRAFFE","Length","GIR&Length","Column1",null,"Number screws ","HBSPLATE 10mm","Column1","Column2","Column3"]
[null,"GIR2200",null,"GIR2200",2200,{"$f":"D3&\"_\"&E3","v":"GIR2200_2200"},5.04,null,1,"Length","Rv,90,k","Rax,90,k","Rtens,k"]
[null,"GIR3000",null,"GIR3000",1750,"GIR3000_1750",20.86,null,2,100,5.52,8.78,40]
[null,"GIR4000",null,"GIR3000",2400,"GIR3000_2400",14.6,null,3,120,6.67,11.12,40]
[null,"GIR6000",null,"GIR3000",3000,"GIR3000_3000",6.11,null,4,140,7.36,12.87,40]
[{"$nulls":3},"GIR4000",1750,"GIR4000_1750",29.48,null,5,160,7.94,15.21,40]
[{"$nulls":3},"GIR4000",2850,"GIR4000_2850",14.16,null,6,180,8.28,17.55,40]
[{"$nulls":3},"GIR4000",4000,"GIR4000_4000",4.45]
[{"$nulls":3},"GIR6000",3000,"GIR6000_3000",59.43,null,"SKR 10mm"]
[{"$nulls":3},"GIR6000",4000,"GIR6000_4000",29.7,null,"Number screws ","Length","Uncracked concrete",null,"Cracked concrete"]
[{"$nulls":3},"GIR6000",5000,"GIR6000_5000",16.07,{"$nulls":3},"NRk,p","NRk,s/Rk,cp","NRk,p","NRk,s/Rk,cp"]
[{"$nulls":3},"GIR6000",6000,"GIR6000_6000",7.01,null,1,100,25,32.4,9,32.4]
[{"$nulls":8},2,120]
[{"$nulls":8},3,140]
[null,"UNCRACKED CONCRETE",null,null,"CONCRETE",{"$nulls":3},4,160]
[null,"CRACKED CONCRETE",null,null,"TIMBER",{"$nulls":3},5,200]
[{"$nulls":8},6,240]
[{"$nulls":9},280]
[{"$nulls":9},320]
[{"$nulls":9},400]
[]
[null,null,"Tabla 2.4.- Valores del Factor Kmod"]
[null,null,"Material",null,"Clase Servicio","Duración de la carga"]
[{"$nulls":5},"Perm.","Larga","Media","Corta","Inst."]
[null,null,"Madera maciza",null,1,{"v":0.6,"d":"0.60"},{"v":0.7,"d":"0.70"},{"v":0.8,"d":"0.80"},{"v":0.9,"d":"0.90"},{"v":1.1,"d":"1.10"}]
[null,null,"Madera laminada encolada",null,2,{"v":0.6,"d":"0.60"},{"v":0.7,"d":"0.70"},{"v":0.8,"d":"0.80"},{"v":0.9,"d":"0.90"},{"v":1.1,"d":"1.10"}]
[null,null,"Madera microlaminada",null,3,{"v":0.5,"d":"0.50"},0.55,0.65,{"v":0.7,"d":"0.70"},{"v":0.9,"d":"0.90"}]