{"text_format":"3","workbook":"xlsx","n_sheets":11,"sheets":["CONDITIONS","Len_DB","Input","RefText_DB","Output","Calculation Report","Relazione di Calcolo AT SUPPORT","EJeff","sharp metal","CLT panel","Dati"],"not_rendered":{"images":76,"macros":1,"defined_names":21,"comments":4},"read":"whole","date_system":"1900"}

{"sheet":"CONDITIONS","index":0,"n_rows":66,"n_cols":5,"rows_kept":66,"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],[28,2,28,4],[32,2,32,4],[36,2,36,4],[40,2,40,4],[44,2,44,4],[48,2,48,4],[53,2,53,4],[58,2,58,4],[62,2,62,4],[63,2,63,4],[65,0,67,5]]}
[]
[{"$nulls":3},"SHARP_METAL_CALCULATOR\nv1.1",{"$f":"INDEX(LEN_CON[],1,MATCH($E$3,LEN_CON[#Headers],0))","v":"Language"}]
[{"$nulls":4},"EN"]
[]
[]
[{"$nulls":3},{"$f":"INDEX(LEN_CON[],2,MATCH($E$3,LEN_CON[#Headers],0))","v":"SHARP METAL CALCULATOR"}]
[null,null,{"$f":"INDEX(LEN_CON[],3,MATCH($E$3,LEN_CON[#Headers],0))","v":"GENERAL TERMS AND CONDITIONS OF THE LICENSE AGREEMENT FOR THE USE OF THE SPREADSHEET \"SHARP_METAL_CALCULATOR\""}]
[]
[]
[]
[]
[null,{"$error":"#VALUE!"}]
[]
[null,{"$f":"INDEX(LEN_CON[],4,MATCH($E$3,LEN_CON[#Headers],0))","v":"1. SUBJECT"}]
[]
[null,null,{"$f":"INDEX(LEN_CON[],5,MATCH($E$3,LEN_CON[#Headers],0))","v":"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,{"$f":"INDEX(LEN_CON[],6,MATCH($E$3,LEN_CON[#Headers],0))","v":"2. TECHNICAL-STANDARDS REFERENCES"}]
[]
[null,null,{"$f":"INDEX(LEN_CON[],7,MATCH($E$3,LEN_CON[#Headers],0))","v":"RB carried out the checks according to the Limit State method in accordance with EN 1995-1-1 Eurocode 5 - Design of timber structures and EN 1999-1-1 Eurocode 9 - Design of aluminium structures. For the mechanical resistance values and the geometry of the connectors, reference was made to ETA-23/0824."}]
[]
[null,{"$f":"INDEX(LEN_CON[],8,MATCH($E$3,LEN_CON[#Headers],0))","v":"3. RB RIGHTS AND OBLIGATIONS"}]
[]
[null,null,{"$f":"INDEX(LEN_CON[],9,MATCH($E$3,LEN_CON[#Headers],0))","v":"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,{"$f":"INDEX(LEN_CON[],10,MATCH($E$3,LEN_CON[#Headers],0))","v":"4. USER RIGHTS AND OBLIGATIONS"}]
[]
[null,null,{"$f":"INDEX(LEN_CON[],11,MATCH($E$3,LEN_CON[#Headers],0))","v":"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,{"$f":"INDEX(LEN_CON[],12,MATCH($E$3,LEN_CON[#Headers],0))","v":"5. COPYRIGHTS"}]
[]
[null,null,{"$f":"INDEX(LEN_CON[],13,MATCH($E$3,LEN_CON[#Headers],0))","v":"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,{"$f":"INDEX(LEN_CON[],14,MATCH($E$3,LEN_CON[#Headers],0))","v":"6. DURATION, WITHDRAWAL AND TERMINATION"}]
[]
[null,null,{"$f":"INDEX(LEN_CON[],15,MATCH($E$3,LEN_CON[#Headers],0))","v":"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,{"$f":"INDEX(LEN_CON[],16,MATCH($E$3,LEN_CON[#Headers],0))","v":"7. RESPONSIBILITY"}]
[]
[null,null,{"$f":"INDEX(LEN_CON[],17,MATCH($E$3,LEN_CON[#Headers],0))","v":"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,{"$f":"INDEX(LEN_CON[],18,MATCH($E$3,LEN_CON[#Headers],0))","v":"8. REFUND"}]
[]
[null,null,{"$f":"INDEX(LEN_CON[],19,MATCH($E$3,LEN_CON[#Headers],0))","v":"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,{"$f":"INDEX(LEN_CON[],20,MATCH($E$3,LEN_CON[#Headers],0))","v":"9. MISCELLANEOUS"}]
[]
[null,null,{"$f":"INDEX(LEN_CON[],21,MATCH($E$3,LEN_CON[#Headers],0))","v":"These 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,{"$f":"INDEX(LEN_CON[],22,MATCH($E$3,LEN_CON[#Headers],0))","v":"10. LANGUAGE"}]
[]
[null,null,{"$f":"INDEX(LEN_CON[],23,MATCH($E$3,LEN_CON[#Headers],0))","v":"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,{"$f":"INDEX(LEN_CON[],24,MATCH($E$3,LEN_CON[#Headers],0))","v":"11. APPLICABLE LAW AND COURT OF JURISDICTION"}]
[]
[null,null,{"$f":"INDEX(LEN_CON[],25,MATCH($E$3,LEN_CON[#Headers],0))","v":"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,{"$f":"INDEX(LEN_CON[],26,MATCH($E$3,LEN_CON[#Headers],0))","v":"12. PRIVACY"}]
[]
[null,null,{"$f":"INDEX(LEN_CON[],27,MATCH($E$3,LEN_CON[#Headers],0))","v":"Refer to the privacy policy available at the link:"}]
[null,null,"https://www.rothoblaas.com/privacy-policy"]
[]
[{"$f":"INDEX(LEN_CON[],28,MATCH($E$3,LEN_CON[#Headers],0))","v":"ACCEPT"}]

{"sheet":"Len_DB","index":1,"n_rows":257,"n_cols":8,"rows_kept":257,"hidden":true,"merged":[[1,2,1,6],[5,2,5,6],[37,2,37,6],[88,2,88,6],[129,2,129,6]]}
[]
[null,null,"LENGUAGES"]
[]
[null,null,"IT","EN","DE","FR","ES"]
[]
[null,null,"CONDITIONS"]
[]
[null,"Column1","IT","EN","DE","FR","ES","Column2"]
[null,1,"Lingua","Language","Sprache","Langue","Idioma"]
[null,2,"SHARP METAL CALCULATOR","SHARP METAL CALCULATOR","SHARP METAL CALCULATOR","SHARP METAL CALCULATOR","SHARP METAL CALCULATOR"]
[null,3,"CONDIZIONI GENERALI DEL CONTRATTO DI LICENZA PER L'USO DEL FOGLIO DI CALCOLO \"SHARP_METAL_CALCULATOR\"","GENERAL TERMS AND CONDITIONS OF THE LICENSE AGREEMENT FOR THE USE OF THE SPREADSHEET \"SHARP_METAL_CALCULATOR\"","ALLGEMEINE GESCHÄFTSBEDINGUNGEN DER LIZENZVEREINBARUNG FÜR DIE NUTZUNG DER TABELLENKALKULATION \"SHARP_METAL_CALCULATOR\"","CONDITIONS GÉNÉRALES DU CONTRAT DE LICENCE POUR L'UTILISATION DE LA FEUILLE DE CALCUL \"SHARP_METAL_CALCULATOR\"","CONDICIONES GENERALES DEL CONTRATO DE LICENCIA PARA EL USO DE LA HOJA DE CÁLCULO \"SHARP_METAL_CALCULATOR\""]
[null,4,"1. OGGETTO","1. SUBJECT","1. GEGENSTAND","1. OBJET","1. OBJETO"]
[null,5,"Con le presenti Condizioni Generali (o \"Accordo\"), ROTHO BLAAS SRL, con sede legale in I-39040 Cortaccia (BZ), Via dell'Adige 2/1 (di seguito \"RB\"), concede all'utente il diritto non esclusivo e revocabile di utilizzare gratuitamente il foglio di calcolo (di seguito \"XLS\") alle seguenti condizioni e per la durata del presente Accordo.\n\nIn ogni caso, RB non garantisce la conformità legale e progettuale dei calcoli, poiché RB intende fornire esclusivamente uno strumento di calcolo indicativo da considerarsi un servizio tecnico-commerciale nell'ambito dell'attività di vendita.\n\nXLS consente all'utente di eseguire calcoli statici soltanto per i prodotti e i materiali indicati in ciascuna delle sue sezioni. Il presente Accordo vieta espressamente l'utilizzo di XLS per fabbricare prodotti non indicati.\n\nIl presente Accordo disciplina pertanto il rapporto tra l'Utente e RB in relazione all'utilizzo di questo foglio di calcolo. Scaricando e utilizzando XLS, l'utente accetta il presente Accordo e le condizioni qui stabilite.","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.","Mit diesen Allgemeinen Geschäftsbedingungen (oder \"Vereinbarung\") räumt ROTHO BLAAS SRL, mit Sitz in I-39040 Kurtatsch (BZ), Via dell'Adige 2/1 (nachfolgend \"RB\"), dem Nutzer das nicht ausschließliche und widerrufliche Recht ein, die Tabellenkalkulation (nachfolgend \"XLS\") unter den folgenden Bedingungen und während der Laufzeit dieser Vereinbarung kostenlos zu nutzen.\n\nIn jedem Fall garantiert RB nicht die rechtliche und planerische Konformität der Berechnungen, da RB lediglich ein indikatives Berechnungstool bereitstellen möchte, das als technisch-kommerzieller Service im Rahmen der Verkaufstätigkeit zu betrachten ist.\n\nXLS ermöglicht dem Nutzer, statische Berechnungen ausschließlich für die in den jeweiligen Abschnitten angegebenen Produkte und Materialien durchzuführen. Diese Vereinbarung untersagt ausdrücklich die Verwendung von XLS zur Herstellung nicht angegebener Produkte.\n\nDiese Vereinbarung regelt daher das Verhältnis zwischen dem Nutzer und RB in Bezug auf die Nutzung dieser Tabellenkalkulation. Durch das Herunterladen und die Nutzung von XLS akzeptiert der Nutzer diese Vereinbarung und die hierin festgelegten Bedingungen.","Par les présentes Conditions Générales (ou \"Accord\"), ROTHO BLAAS SRL, dont le siège social est situé à I-39040 Cortaccia (BZ), Via dell'Adige 2/1 (ci-après \"RB\"), accorde à l'utilisateur le droit non exclusif et révocable d'utiliser gratuitement la feuille de calcul (ci-après \"XLS\") selon les conditions suivantes et pendant la durée du présent Accord.\n\nEn tout état de cause, RB ne garantit pas la conformité juridique et de conception des calculs, car RB entend uniquement fournir un outil de calcul indicatif à considérer comme un service technico-commercial dans le cadre de l'activité de vente.\n\nXLS permet à l'utilisateur d'effectuer des calculs statiques uniquement pour les produits et matériaux indiqués dans chacune de ses sections. Le présent Accord interdit expressément l'utilisation de XLS pour fabriquer des produits non indiqués.\n\nLe présent Accord régit donc la relation entre l'Utilisateur et RB concernant l'utilisation de cette feuille de calcul. En téléchargeant et en utilisant XLS, l'utilisateur accepte le présent Accord et les conditions qui y sont énoncées.","Mediante las presentes Condiciones Generales (o \"Acuerdo\"), ROTHO BLAAS SRL, con domicilio social en I-39040 Cortaccia (BZ), Via dell'Adige 2/1 (en adelante, \"RB\"), concede al usuario el derecho no exclusivo y revocable de utilizar gratuitamente la hoja de cálculo (en adelante, \"XLS\") bajo las siguientes condiciones y durante la vigencia del presente Acuerdo.\n\nEn cualquier caso, RB no garantiza la conformidad legal ni de diseño de los cálculos, ya que RB pretende proporcionar únicamente una herramienta de cálculo indicativa que debe considerarse un servicio técnico-comercial dentro de la actividad de venta.\n\nXLS permite al usuario realizar cálculos estáticos únicamente para los productos y materiales indicados en cada una de sus secciones. El presente Acuerdo prohíbe expresamente utilizar XLS para fabricar productos no indicados.\n\nPor tanto, el presente Acuerdo regula la relación entre el Usuario y RB con respecto al uso de esta hoja de cálculo. Al descargar y utilizar XLS, el usuario acepta el presente Acuerdo y las condiciones aquí establecidas."]
[null,6,"2. RIFERIMENTI TECNICO-NORMATIVI","2. TECHNICAL-STANDARDS REFERENCES","2. TECHNISCH-NORMATIVE VERWEISE","2. RÉFÉRENCES TECHNIQUES ET NORMATIVES","2. REFERENCIAS TÉCNICO-NORMATIVAS"]
[null,7,"RB ha effettuato le verifiche secondo il metodo degli Stati Limite in conformità alla EN 1995-1-1 Eurocodice 5 - Progettazione delle strutture in legno e alla EN 1999-1-1 Eurocodice 9 - Progettazione delle strutture in alluminio. Per i valori di resistenza meccanica e la geometria dei connettori si è fatto riferimento all'ETA-23/0824.","RB carried out the checks according to the Limit State method in accordance with EN 1995-1-1 Eurocode 5 - Design of timber structures and EN 1999-1-1 Eurocode 9 - Design of aluminium structures. For the mechanical resistance values and the geometry of the connectors, reference was made to ETA-23/0824.","RB hat die Nachweise nach dem Grenzzustandsverfahren gemäß EN 1995-1-1 Eurocode 5 - Bemessung und Konstruktion von Holzbauten und EN 1999-1-1 Eurocode 9 - Bemessung und Konstruktion von Aluminiumtragwerken durchgeführt. Für die mechanischen Widerstandswerte und die Geometrie der Verbinder wurde auf ETA-23/0824 Bezug genommen.","RB a effectué les vérifications selon la méthode des États Limites conformément à la norme EN 1995-1-1 Eurocode 5 - Conception et calcul des structures en bois et à la norme EN 1999-1-1 Eurocode 9 - Conception et calcul des structures en aluminium. Pour les valeurs de résistance mécanique et la géométrie des connecteurs, il a été fait référence à l'ETA-23/0824.","RB realizó las comprobaciones según el método de los Estados Límite de conformidad con la norma EN 1995-1-1 Eurocódigo 5 - Proyecto de estructuras de madera y la norma EN 1999-1-1 Eurocódigo 9 - Proyecto de estructuras de aluminio. Para los valores de resistencia mecánica y la geometría de los conectores, se tomó como referencia la ETA-23/0824."]
[null,8,"3. DIRITTI E OBBLIGHI DI RB","3. RB RIGHTS AND OBLIGATIONS","3. RECHTE UND PFLICHTEN VON RB","3. DROITS ET OBLIGATIONS DE RB","3. DERECHOS Y OBLIGACIONES DE RB"]
[null,9,"RB:\n\na) mette a disposizione XLS all'Utente gratuitamente, così com'è;\n\nb) non fornisce all'utente alcun supporto tecnico per l'utilizzo di XLS;\n\nc) non garantisce che XLS sia conforme alle normative vigenti o al progetto dei calcoli effettuati mediante esso. In particolare, a seguito di modifiche alle disposizioni rilevanti, quali norme, approvazioni, ecc., il foglio di calcolo può diventare invalido in parte o integralmente.\n\nd) pur riservandosi il diritto di aggiornare, revisionare e sviluppare XLS, RB non assume alcun obbligo nei confronti dell'utente di verificare, correggere, completare o aggiornare il foglio di calcolo e/o rendere disponibili gli aggiornamenti all'utente.","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.","RB:\n\na) stellt XLS dem Nutzer kostenlos in der vorliegenden Form zur Verfügung;\n\nb) leistet dem Nutzer keinerlei technische Unterstützung bei der Verwendung von XLS;\n\nc) garantiert nicht, dass XLS den geltenden Vorschriften oder der mit ihm erstellten Berechnungsplanung entspricht. Insbesondere kann die Tabellenkalkulation infolge von Änderungen der einschlägigen Bestimmungen, wie Normen, Zulassungen usw., teilweise oder vollständig ungültig werden.\n\nd) RB behält sich zwar das Recht vor, XLS zu aktualisieren, zu überarbeiten und weiterzuentwickeln, übernimmt jedoch gegenüber dem Nutzer keine Verpflichtung, die Tabellenkalkulation zu prüfen, zu korrigieren, zu vervollständigen oder zu aktualisieren und/oder dem Nutzer Aktualisierungen bereitzustellen.","RB :\n\na) met XLS à la disposition de l'Utilisateur gratuitement, en l'état ;\n\nb) ne fournit à l'utilisateur aucun support technique pour l'utilisation de XLS ;\n\nc) ne garantit pas que XLS est conforme aux réglementations en vigueur ni à la conception des calculs réalisés à l'aide de celui-ci. En particulier, à la suite de modifications des dispositions pertinentes, telles que normes, agréments, etc., la feuille de calcul peut devenir invalide en partie ou en totalité.\n\nd) tout en se réservant le droit de mettre à jour, réviser et développer XLS, RB n'assume aucune obligation envers l'utilisateur de vérifier, corriger, compléter ou mettre à jour la feuille de calcul et/ou de mettre les mises à jour à la disposition de l'utilisateur.","RB:\n\na) pone XLS a disposición del Usuario gratuitamente, tal como está;\n\nb) no proporciona al usuario ningún soporte técnico para el uso de XLS;\n\nc) no garantiza que XLS cumpla con la normativa vigente ni con el diseño de los cálculos realizados mediante el mismo. En particular, como consecuencia de cambios en las disposiciones pertinentes, tales como normas, aprobaciones, etc., la hoja de cálculo puede quedar inválida parcial o totalmente.\n\nd) aunque se reserva el derecho de actualizar, revisar y desarrollar XLS, RB no asume ninguna obligación frente al usuario de verificar, corregir, completar o actualizar la hoja de cálculo y/o poner las actualizaciones a disposición del usuario."]
[null,10,"4. DIRITTI E OBBLIGHI DELL'UTENTE","4. USER RIGHTS AND OBLIGATIONS","4. RECHTE UND PFLICHTEN DES NUTZERS","4. DROITS ET OBLIGATIONS DE L'UTILISATEUR","4. DERECHOS Y OBLIGACIONES DEL USUARIO"]
[null,11,"L'Utente dichiara di utilizzare il foglio di calcolo in qualità di professionista, escludendo qualsiasi utilizzo come consumatore, e di rispettare sempre i seguenti obblighi e divieti:\n\na) obbligo e responsabilità di verificare che XLS soddisfi le esigenze specifiche e sia compatibile con i sistemi hardware-software;\n\nb) obbligo di verificare, per ogni utilizzo, la conformità dei calcoli effettuati tramite XLS alle normative vigenti e al progetto;\n\nc) obbligo di verificare la conformità legale dei calcoli effettuati tramite il Software;\n\nd) obbligo di utilizzare l'ultima versione di XLS messa a disposizione dal referente RB, verificando a ogni utilizzo eventuali aggiornamenti intervenuti;\n\ne) divieto di utilizzare XLS per prodotti non indicati in ciascuna sezione di calcolo;\n\nf) obbligo di utilizzare un software antivirus aggiornato e conforme allo standard di settore vigente;\n\ng) obbligo di non cedere a terzi la licenza d'uso di XLS e/o di non trasferire, costituire in pegno, concedere in leasing, noleggiare, condividere con altri o sublicenziare in qualsiasi altro modo i diritti di utilizzo del foglio di calcolo;\n\nh) divieto di modificare o alterare XLS in qualsiasi modo, anche tramite terzi.\n\nL'utente si impegna a richiedere al referente RB l'ultima versione di XLS.","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.","Der Nutzer erklärt, die Tabellenkalkulation als Fachperson zu verwenden und jegliche Nutzung als Verbraucher auszuschließen, sowie stets die folgenden Pflichten und Verbote einzuhalten:\n\na) Pflicht und Verantwortung zu prüfen, ob XLS den spezifischen Anforderungen entspricht und mit den Hardware-Software-Systemen kompatibel ist;\n\nb) Pflicht, bei jeder Verwendung die Übereinstimmung der durch XLS erstellten Berechnungen mit den geltenden Vorschriften und dem Projekt zu überprüfen;\n\nc) Pflicht, die rechtliche Konformität der durch die Software erstellten Berechnungen zu überprüfen;\n\nd) Pflicht, die neueste vom RB-Ansprechpartner bereitgestellte Version von XLS zu verwenden und bei jeder Nutzung zu prüfen, ob Aktualisierungen erfolgt sind;\n\ne) Verbot, XLS für Produkte zu verwenden, die nicht in jedem Berechnungsabschnitt angegeben sind;\n\nf) Pflicht, eine aktualisierte Antivirensoftware zu verwenden, die dem geltenden Branchenstandard entspricht;\n\ng) Pflicht, die Lizenz zur Nutzung von XLS nicht an Dritte abzutreten und/oder die Nutzungsrechte an der Tabellenkalkulation in keiner anderen Weise zu übertragen, zu verpfänden, zu verleasen, zu vermieten, mit anderen zu teilen oder unterzulizenzieren;\n\nh) Verbot, XLS in irgendeiner Weise zu ändern oder abzuändern, auch nicht durch Dritte.\n\nDer Nutzer verpflichtet sich, beim RB-Ansprechpartner die neueste Version von XLS anzufordern.","L'Utilisateur déclare utiliser la feuille de calcul en tant que professionnel, à l'exclusion de toute utilisation en tant que consommateur, et s'engage à toujours respecter les obligations et interdictions suivantes :\n\na) obligation et responsabilité de vérifier que XLS répond aux besoins spécifiques et qu'il est compatible avec les systèmes matériels et logiciels ;\n\nb) obligation de vérifier, pour chaque utilisation, la conformité des calculs effectués au moyen de XLS avec les réglementations en vigueur et avec le projet ;\n\nc) obligation de vérifier la conformité juridique des calculs effectués au moyen du Logiciel ;\n\nd) obligation d'utiliser la dernière version de XLS mise à disposition par le référent RB, en vérifiant à chaque utilisation les éventuelles mises à jour intervenues ;\n\ne) interdiction d'utiliser XLS pour des produits non indiqués dans chaque section de calcul ;\n\nf) obligation d'utiliser un logiciel antivirus à jour conforme à la norme industrielle en vigueur ;\n\ng) obligation de ne pas céder à des tiers la licence d'utilisation de XLS et/ou de ne pas transférer, nantir, donner en crédit-bail, louer, partager avec d'autres ou sous-licencier de quelque autre manière les droits d'utilisation de la feuille de calcul ;\n\nh) interdiction de modifier ou d'altérer XLS de quelque manière que ce soit, y compris par l'intermédiaire de tiers.\n\nL'utilisateur s'engage à demander au référent RB la dernière version de XLS.","El Usuario declara utilizar la hoja de cálculo como profesional, excluyendo cualquier uso como consumidor, y cumplir siempre con las siguientes obligaciones y prohibiciones:\n\na) obligación y responsabilidad de verificar que XLS satisface las necesidades específicas y que es compatible con los sistemas de hardware y software;\n\nb) obligación de verificar, en cada uso, la conformidad de los cálculos realizados mediante XLS con la normativa vigente y con el proyecto;\n\nc) obligación de verificar la conformidad legal de los cálculos realizados mediante el Software;\n\nd) obligación de utilizar la última versión de XLS puesta a disposición por la persona de contacto de RB, comprobando en cada uso si se han producido actualizaciones;\n\ne) prohibición de utilizar XLS para productos no indicados en cada sección de cálculo;\n\nf) obligación de utilizar un software antivirus actualizado que cumpla con la norma sectorial vigente;\n\ng) obligación de no ceder a terceros la licencia de uso de XLS y/o de no transferir, pignorar, arrendar, alquilar, compartir con otros o sublicenciar de cualquier otro modo los derechos de uso de la hoja de cálculo;\n\nh) prohibición de modificar o alterar XLS de cualquier forma, incluso a través de terceros.\n\nEl usuario se compromete a solicitar a la persona de contacto de RB la última versión de XLS."]
[null,12,"5. COPYRIGHT","5. COPYRIGHTS","5. URHEBERRECHTE","5. DROITS D'AUTEUR","5. DERECHOS DE AUTOR"]
[null,13,"I diritti d'autore sulle formulazioni riportate nel foglio di calcolo e tutti i diritti di proprietà intellettuale e industriale ad esse sottostanti (quali, a titolo esemplificativo e non esaustivo: marchi, brevetti, segreti commerciali, know-how, informazioni riservate) sono e rimangono di esclusiva proprietà di RB.\n\nIl presente accordo non trasferisce all'utente alcuno dei diritti sopra indicati.","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.","Die Urheberrechte an den in der Tabellenkalkulation enthaltenen Formulierungen sowie alle ihnen zugrunde liegenden geistigen und gewerblichen Eigentumsrechte (wie insbesondere, jedoch nicht ausschließlich: Marken, Patente, Geschäftsgeheimnisse, Know-how, vertrauliche Informationen) sind und bleiben ausschließliches Eigentum von RB.\n\nDiese Vereinbarung überträgt dem Nutzer keine der vorgenannten Rechte.","Les droits d'auteur sur les formulations mentionnées dans la feuille de calcul ainsi que tous les droits de propriété intellectuelle et industrielle qui les sous-tendent (tels que, sans s'y limiter : marques, brevets, secrets commerciaux, savoir-faire, informations confidentielles) sont et restent la propriété exclusive de RB.\n\nLe présent accord ne transfère aucun des droits susmentionnés à l'utilisateur.","Los derechos de autor sobre las formulaciones indicadas en la hoja de cálculo y todos los derechos de propiedad intelectual e industrial subyacentes a las mismas (tales como, entre otros: marcas, patentes, secretos comerciales, know-how, información confidencial) son y seguirán siendo propiedad exclusiva de RB.\n\nEl presente acuerdo no transfiere al usuario ninguno de los derechos anteriores."]
[null,14,"6. DURATA, RECESSO E RISOLUZIONE","6. DURATION, WITHDRAWAL AND TERMINATION","6. DAUER, RÜCKTRITT UND BEENDIGUNG","6. DURÉE, RETRAIT ET RÉSILIATION","6. DURACIÓN, DESISTIMIENTO Y TERMINACIÓN"]
[null,15,"Le presenti condizioni generali e, di conseguenza, la licenza d'uso del foglio di calcolo sono valide dal momento del download fino alla cessazione del suo utilizzo.\n\nL'utente può recedere dal presente Accordo in qualsiasi momento eliminando XLS e tutte le copie dai propri sistemi.\n\nRB può recedere dal presente Accordo e disattivare il servizio in caso di violazione di una qualsiasi delle disposizioni che regolano la licenza d'uso. Nel caso in cui RB comunichi la risoluzione, l'utente dovrà rimuovere il foglio di calcolo e ogni sua copia dai propri sistemi.","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.","Diese allgemeinen Bedingungen und folglich die Lizenz zur Nutzung der Tabellenkalkulation gelten ab dem Zeitpunkt des Herunterladens bis zur Beendigung ihrer Nutzung.\n\nDer Nutzer kann jederzeit von dieser Vereinbarung zurücktreten, indem er XLS und alle Kopien von seinen Systemen löscht.\n\nRB kann von dieser Vereinbarung zurücktreten und den Dienst deaktivieren, wenn eine der Bestimmungen zur Nutzungslizenz verletzt wird. Falls RB die Beendigung mitteilt, muss der Nutzer die Tabellenkalkulation und alle Kopien davon von seinen Systemen entfernen.","Les présentes conditions générales et, par conséquent, la licence d'utilisation de la feuille de calcul, sont valables à compter du téléchargement jusqu'à la cessation de son utilisation.\n\nL'utilisateur peut se retirer du présent Accord à tout moment en supprimant XLS et toutes ses copies de ses systèmes.\n\nRB peut se retirer du présent Accord et désactiver le service en cas de violation de l'une quelconque des dispositions régissant la licence d'utilisation. Si RB notifie sa résiliation, l'utilisateur devra supprimer la feuille de calcul et toutes ses copies de ses systèmes.","Estas condiciones generales y, en consecuencia, la licencia de uso de la hoja de cálculo, son válidas desde el momento de su descarga hasta la finalización de su uso.\n\nEl usuario podrá desistir del presente Acuerdo en cualquier momento eliminando XLS y todas sus copias de sus sistemas.\n\nRB podrá desistir del presente Acuerdo y desactivar el servicio en caso de incumplimiento de cualquiera de las disposiciones que regulan la licencia de uso. En caso de que RB notifique su terminación, el usuario deberá eliminar la hoja de cálculo y cualquier copia de la misma de sus sistemas."]
[null,16,"7. RESPONSABILITÀ","7. RESPONSIBILITY","7. VERANTWORTUNG","7. RESPONSABILITÉ","7. RESPONSABILIDAD"]
[null,17,"L'utente è l'unico responsabile dell'utilizzo di XLS, inclusi, a titolo esemplificativo e non esaustivo, tutti i calcoli, le stampe, i dati esportati realizzati con esso e/o gli errori di inserimento, la protezione dei file di dati e la manutenzione e, in generale, qualsiasi utilizzo del foglio di calcolo.\n\nRB non garantisce e in nessun caso può essere ritenuta responsabile per danni, perdite e costi o altre conseguenze, per qualsiasi motivo (garanzia per vizi, garanzia per malfunzionamento, responsabilità da prodotto o legale, ecc.) derivanti da:\n\n•   utilizzo di XLS, calcoli effettuati, conformità alla normativa vigente, al progetto o ad altre esigenze dell'Utente;\n\n•   compatibilità hardware e software, virus, malfunzionamenti, difetti, errori o lacune;\n\n•   mancato aggiornamento del foglio di calcolo e/o interruzione della disponibilità del foglio di calcolo e/o risoluzione dell'accordo per qualsiasi motivo;\n\n•   violazione di diritti di proprietà intellettuale di terzi.\n\nL'utente conferma di aver compreso e accettato le esclusioni e limitazioni di responsabilità e di rivendicazione del presente Accordo. L'utente conferma inoltre che il foglio di calcolo è disponibile gratuitamente, che le esclusioni e limitazioni costituiscono elementi fondamentali del presente Accordo e che RB non mette a disposizione dell'utente il proprio foglio di calcolo qualora le esclusioni o limitazioni vengano eliminate o modificate a favore dell'utente.","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.","Der Nutzer ist allein für die Nutzung von XLS verantwortlich, einschließlich, jedoch nicht beschränkt auf alle damit erstellten Berechnungen, Ausdrucke, Exportdaten und/oder Eingabefehler, den Schutz von Datendateien und die Wartung sowie allgemein für jede Nutzung der Tabellenkalkulation.\n\nRB übernimmt keine Garantie und kann unter keinen Umständen für Schäden, Verluste und Kosten oder sonstige Folgen haftbar gemacht werden, gleich aus welchem Grund (Mängelgewährleistung, Gewährleistung bei Funktionsstörungen, Produkt- oder rechtliche Verantwortung usw.), die sich ergeben aus:\n\n•   Nutzung von XLS, durchgeführten Berechnungen, Einhaltung der geltenden Gesetzgebung, des Projekts oder sonstiger Bedürfnisse des Nutzers;\n\n•   Hardware- und Softwarekompatibilität, Viren, Funktionsstörungen, Mängeln, Fehlern oder Lücken;\n\n•   unterlassener Aktualisierung der Tabellenkalkulation und/oder Unterbrechung der Verfügbarkeit der Tabellenkalkulation und/oder Beendigung der Vereinbarung aus irgendeinem Grund;\n\n•   Verletzung von Rechten des geistigen Eigentums Dritter.\n\nDer Nutzer bestätigt, die Haftungsausschlüsse sowie die Haftungs- und Anspruchsbeschränkungen dieser Vereinbarung verstanden und akzeptiert zu haben. Der Nutzer bestätigt außerdem, dass die Tabellenkalkulation kostenlos verfügbar ist, dass die Ausschlüsse und Beschränkungen wesentliche Bestandteile dieser Vereinbarung sind und dass RB dem Nutzer die Tabellenkalkulation nicht zur Verfügung stellt, wenn die Ausschlüsse oder Beschränkungen zugunsten des Nutzers gestrichen oder geändert werden.","L'utilisateur est seul responsable de l'utilisation de XLS, y compris, sans s'y limiter, tous les calculs, impressions, données d'exportation réalisés avec celui-ci et/ou les erreurs de saisie, la protection des fichiers de données et la maintenance, et plus généralement toute utilisation de la feuille de calcul.\n\nRB ne garantit pas et ne peut en aucun cas être tenue responsable des dommages, pertes et coûts ou autres conséquences, pour quelque raison que ce soit (garantie des défauts, garantie de dysfonctionnement, responsabilité produit ou légale, etc.) découlant de :\n\n•   l'utilisation de XLS, des calculs effectués, de la conformité à la législation en vigueur, au projet ou à d'autres besoins de l'Utilisateur ;\n\n•   la compatibilité matérielle et logicielle, les virus, dysfonctionnements, défauts, erreurs ou lacunes ;\n\n•   le défaut de mise à jour de la feuille de calcul et/ou l'interruption de la disponibilité de la feuille de calcul et/ou la résiliation de l'accord pour quelque raison que ce soit ;\n\n•   la violation de droits de propriété intellectuelle de tiers.\n\nL'utilisateur confirme avoir compris et accepté les clauses de non-responsabilité ainsi que les limitations de responsabilité et de réclamation du présent Accord. L'utilisateur confirme également que la feuille de calcul est disponible gratuitement, que les exclusions et limitations constituent des éléments fondamentaux du présent Accord et que RB ne met pas sa feuille de calcul à la disposition de l'utilisateur si les exclusions ou limitations sont supprimées ou modifiées en faveur de l'utilisateur.","El usuario es el único responsable del uso de XLS, incluidos, entre otros, todos los cálculos, impresiones, datos de exportación realizados con él y/o los errores de introducción, la protección de los archivos de datos y el mantenimiento y, en general, cualquier uso de la hoja de cálculo.\n\nRB no garantiza y en ningún caso podrá ser considerada responsable de daños, pérdidas y costes u otras consecuencias, por cualquier motivo (garantía por defectos, garantía por mal funcionamiento, responsabilidad de producto o legal, etc.) derivados de:\n\n•   uso de XLS, cálculos realizados, cumplimiento de la legislación vigente, del proyecto u otras necesidades del Usuario;\n\n•   compatibilidad de hardware y software, virus, mal funcionamientos, defectos, errores o lagunas;\n\n•   falta de actualización de la hoja de cálculo y/o interrupción de la disponibilidad de la hoja de cálculo y/o terminación del acuerdo por cualquier motivo;\n\n•   infracción de derechos de propiedad intelectual de terceros.\n\nEl usuario confirma haber comprendido y aceptado las exenciones y limitaciones de responsabilidad y reclamación del presente Acuerdo. El usuario confirma además que la hoja de cálculo está disponible de forma gratuita, que las exclusiones y limitaciones son elementos fundamentales del presente Acuerdo y que RB no pone su hoja de cálculo a disposición del usuario si las exclusiones o limitaciones se eliminan o modifican a favor del usuario."]
[null,18,"8. INDENNIZZO","8. REFUND","8. FREISTELLUNG","8. INDEMNISATION","8. INDEMNIZACIÓN"]
[null,19,"L'utente accetta di indennizzare e manlevare RB, le sue controllate e i suoi o i rispettivi funzionari, amministratori, dipendenti, successori e incaricati (ciascuno individualmente, \"Beneficiario\", collettivamente, i \"Beneficiari\") dai costi sostenuti in relazione a richieste avanzate da terzi per danni o perdite derivanti dall'utilizzo del foglio di calcolo da parte dell'utente (inclusi, a titolo esemplificativo e non esaustivo, onorari e costi di gestione sostenuti da RB).","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).","Der Nutzer verpflichtet sich, RB, seine Tochtergesellschaften sowie seine bzw. deren leitenden Angestellten, Geschäftsführer, Mitarbeiter, Rechtsnachfolger und Beauftragten (jeweils einzeln \"Begünstigter\", zusammen die \"Begünstigten\") von Kosten freizustellen und schadlos zu halten, die im Zusammenhang mit Ansprüchen Dritter wegen Schäden oder Verlusten entstehen, die aus der Nutzung der Tabellenkalkulation durch den Nutzer herrühren (einschließlich, jedoch nicht beschränkt auf von RB getragene Gebühren und Verwaltungskosten).","L'utilisateur accepte d'indemniser et de dégager de toute responsabilité RB, ses filiales ainsi que ses ou leurs dirigeants, administrateurs, employés, successeurs et mandataires (chacun individuellement, \"Bénéficiaire\", collectivement, les \"Bénéficiaires\") pour les coûts encourus en relation avec des réclamations formulées par des tiers pour des dommages ou pertes découlant de l'utilisation de la feuille de calcul par l'utilisateur (y compris, sans s'y limiter, les honoraires et frais de gestion supportés par RB).","El usuario acepta indemnizar y mantener indemne a RB, sus filiales y sus respectivos directivos, administradores, empleados, sucesores y designados (cada uno individualmente, \"Beneficiario\", colectivamente, los \"Beneficiarios\") por los costes incurridos en relación con reclamaciones formuladas por terceros por daños o pérdidas derivados del uso de la hoja de cálculo por parte del usuario (incluidos, entre otros, honorarios y costes de gestión incurridos por RB)."]
[null,20,"9. VARIE","9. MISCELLANEOUS","9. SONSTIGES","9. DIVERS","9. VARIOS"]
[null,21,"Come indicato nella versione tedesca della scheda tecnica SHARP METAL, VGU non è disponibile sul mercato tedesco, dove SHARP METAL può essere venduto solo in combinazione con VGU DE.\nLe presenti condizioni generali costituiscono l'intero accordo tra RB e l'utente in merito all'oggetto e sostituiscono tutti i precedenti accordi, orali o scritti, nonché qualsiasi accordo tra RB e l'utente.","These 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.","Wie in der deutschen Version des technischen Datenblatts von SHARP METAL angegeben, ist VGU auf dem deutschen Markt nicht verfügbar; dort kann SHARP METAL nur in Kombination mit VGU DE verkauft werden.\nDiese allgemeinen Bedingungen stellen die gesamte Vereinbarung zwischen RB und dem Nutzer in Bezug auf den Vertragsgegenstand dar und ersetzen alle früheren mündlichen oder schriftlichen Vereinbarungen sowie sämtliche Absprachen zwischen RB und dem Nutzer.","Comme indiqué dans la version allemande de la fiche technique SHARP METAL, VGU n'est pas disponible sur le marché allemand, où SHARP METAL ne peut être vendu qu'en combinaison avec VGU DE.\nLes présentes conditions générales constituent l'intégralité de l'accord entre RB et l'utilisateur concernant l'objet du présent document et remplacent tous les accords antérieurs, oraux ou écrits, ainsi que tout accord entre RB et l'utilisateur.","Tal como se indica en la versión alemana de la ficha técnica de SHARP METAL, VGU no está disponible en el mercado alemán, donde SHARP METAL solo puede venderse en combinación con VGU DE.\nEstas condiciones generales constituyen el acuerdo íntegro entre RB y el usuario en relación con el objeto del mismo y sustituyen todos los acuerdos anteriores, orales o escritos, así como cualquier acuerdo entre RB y el usuario."]
[null,22,"10. LINGUA","10. LANGUAGE","10. SPRACHE","10. LANGUE","10. IDIOMA"]
[null,23,"In caso di differenze tra le versioni delle presenti condizioni nelle diverse lingue, il testo inglese è vincolante e prevale sulle traduzioni.","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.","Bei Abweichungen zwischen den Fassungen dieser Bedingungen in den verschiedenen Sprachen ist der englische Text verbindlich und hat Vorrang gegenüber den Übersetzungen.","En cas de divergences entre les versions des présentes conditions dans les différentes langues, le texte anglais fait foi et prévaut sur les traductions.","En caso de diferencias entre las versiones de estas condiciones en los distintos idiomas, el texto en inglés será vinculante y prevalecerá sobre las traducciones."]
[null,24,"11. LEGGE APPLICABILE E FORO COMPETENTE","11. APPLICABLE LAW AND COURT OF JURISDICTION","11. ANWENDBARES RECHT UND GERICHTSSTAND","11. DROIT APPLICABLE ET TRIBUNAL COMPÉTENT","11. LEY APLICABLE Y JURISDICCIÓN COMPETENTE"]
[null,25,"Il presente accordo e qualsiasi rapporto tra le parti sono regolati esclusivamente dalla legge italiana. \nQualsiasi controversia che dovesse insorgere tra le parti in relazione al presente accordo e che non possa essere risolta amichevolmente sarà deferita al tribunale di Bolzano.","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.","Diese Vereinbarung und jede Beziehung zwischen den Parteien unterliegen ausschließlich italienischem Recht. \nJede Streitigkeit, die zwischen den Parteien im Zusammenhang mit dieser Vereinbarung entstehen kann und nicht gütlich beigelegt werden kann, ist vor das Gericht Bozen zu bringen.","Le présent accord et toute relation entre les parties sont régis exclusivement par le droit italien. \nTout litige susceptible de survenir entre les parties en relation avec le présent accord et ne pouvant être résolu à l'amiable sera porté devant le tribunal de Bolzano.","El presente acuerdo y cualquier relación entre las partes se regirán exclusivamente por la ley italiana. \nCualquier controversia que pueda surgir entre las partes en relación con el presente acuerdo y que no pueda resolverse amistosamente será sometida al tribunal de Bolzano."]
[null,26,"12. PRIVACY","12. PRIVACY","12. DATENSCHUTZ","12. CONFIDENTIALITÉ","12. PRIVACIDAD"]
[null,27,"Fare riferimento all'informativa privacy disponibile al link:","Refer to the privacy policy available at the link:","Bitte beachten Sie die unter folgendem Link verfügbare Datenschutzerklärung:","Veuillez vous référer à la politique de confidentialité disponible au lien suivant :","Consulte la política de privacidad disponible en el enlace:"]
[null,28,"ACCETTA","ACCEPT","AKZEPTIEREN","ACCEPTER","ACEPTAR"]
[]
[null,null,"INPUT"]
[]
[null,"Column1","IT","EN","DE","FR","ES","Column2"]
[null,1,"Informazioni progetto","Project informations","Projektinformationen","Informations du projet","Información del proyecto"]
[null,2,"Data","Data","Datum","Date","Fecha"]
[null,3,"Comune","Municipality","Gemeinde","Commune","Municipio"]
[null,4,"Provincia","Province","Provinz","Province","Provincia"]
[null,5,"Progetto","Project","Projekt","Projet","Proyecto"]
[null,6,"Progettista","Designer","Planer","Concepteur","Diseñador"]
[null,7,"Committente","Client","Auftraggeber","Client","Cliente"]
[null,8,"Normativa","Standard","Norm","Norme","Norma"]
[null,9,"Note","Notes","Anmerkungen","Notes","Notas"]
[null,10,"Carichi di progetto","Design Loads","Bemessungslasten","Charges de calcul","Cargas de diseño"]
[null,11,"Carichi permanenti","Permanent loads","Ständige Lasten","Charges permanentes","Cargas permanentes"]
[null,12,"Carichi accidentali","Accidental loads","Veränderliche Lasten","Charges variables","Cargas variables"]
[null,13,"Coefficiente parziale","Partial factor","Teilsicherheitsbeiwert","Coefficient partiel","Coeficiente parcial"]
[null,14,"Durata del carico","Load duration","Lasteinwirkungsdauer","Durée de chargement","Duración de la carga"]
[null,15,"Permanente","Permanent","Ständig","Permanent","Permanente"]
[null,16,"Lungo termine","Long term","Langfristig","Long terme","Largo plazo"]
[null,17,"Medio termine","Medium term","Mittelfristig","Moyen terme","Medio plazo"]
[null,18,"Breve termine","Short term","Kurzfristig","Court terme","Corto plazo"]
[null,19,"Istantaneo","Istantaneous","Sehr kurz","Instantané","Instantáneo"]
[null,20,"Classe di servizio","Service Class","Nutzungsklasse","Classe de service","Clase de servicio"]
[null,21,"Caratteristiche del legno","Timber properties","Holzeigenschaften","Propriétés du bois","Propiedades de la madera"]
[null,22,"(1) Pannello","(1) Slab","Element 1","Élément 1","Elemento 1"]
[null,23,"Tipo di legno","Wood type","Holzart","Type de bois","Tipo de madera"]
[null,24,"(2) Nervatura","(2) Rib beam","Element 2","Élément 2","Elemento 2"]
[null,25,"Tipo di legno","Wood type","Holzart","Type de bois","Tipo de madera"]
[null,26,"Geometria","Geometry","Geometrie","Géométrie","Geometría"]
[null,27,"(1) Pannello","(1) Slab","(1) Platte","(1) Panneau","(1) Panel"]
[null,28,"Tipo CLT","CLT type","BSP-Typ","Type CLT","Tipo CLT"]
[null,29,"Altezza","Height","Höhe","Hauteur","Altura"]
[null,30,"Base","Base","Breite","Base","Base"]
[null,31,"Resistenza a taglio per rotolamento","Rolling shear resistance","Rollschubfestigkeit","Résistance au cisaillement roulant","Resistencia al cortante por rodadura"]
[null,32,"(2) Nervatura","(2) Rib beam","(2) Rippenbalken","(2) Nervure","(2) Nervio"]
[null,33,"Larghezza minima","Minimum width","Mindestbreite","Largeur minimale","Anchura mínima"]
[null,34,"Altezza","Height","Höhe","Hauteur","Altura"]
[null,35,"Base","Base","Breite","Base","Base"]
[null,36,"Luce della trave","Beam span","Spannweite des Balkens","Portée de la poutre","Luz de la viga"]
[null,37,"Configurazione sistema di connessione","Connection system configuration","Konfiguration des Verbindungssystems","Configuration du système de connexion","Configuración del sistema de conexión"]
[null,38,"All’appoggio","At Support","Am Auflager","À l’appui","En el apoyo"]
[null,39,"Tipo SHARP METAL","SHARP METAL type","SHARP METAL-Typ","Type SHARP METAL","Tipo SHARP METAL"]
[null,40,"Lunghezza di influenza","Influence lenght","Einflusslänge","Longueur d’influence","Longitud de influencia"]
[null,41,"Numero di SHARP METAL","Number of SHARP METAL","Anzahl SHARP METAL","Nombre de SHARP METAL","Número de SHARP METAL"]
[null,42,"Diametro TBS MAX","TBS MAX diameter","TBS MAX-Durchmesser","Diamètre TBS MAX","Diámetro TBS MAX"]
[null,43,"In mezzeria","At mid span","In Feldmitte","À mi-portée","En el centro del vano"]
[null,44,"Tipo SHARP METAL","SHARP METAL type","SHARP METAL-Typ","Type SHARP METAL","Tipo SHARP METAL"]
[null,45,"Lunghezza di influenza","Influence lenght","Einflusslänge","Longueur d’influence","Longitud de influencia"]
[null,46,"Numero di SHARP METAL","Number of SHARP METAL","Anzahl SHARP METAL","Nombre de SHARP METAL","Número de SHARP METAL"]
[null,47,"Diametro TBS MAX","TBS MAX diameter","TBS MAX-Durchmesser","Diamètre TBS MAX","Diámetro TBS MAX"]
[]
[null,null,"OUTPUT"]
[]
[null,"Column1","IT","EN","DE","FR","ES","Column2"]
[null,1,"Verifiche di resistenza - SLU (t = 0)","Resistance verification - ULS (t  = 0)","Tragfähigkeitsnachweis - GZT (t = 0)","Vérification de résistance - ELU (t = 0)","Verificación de resistencia - ELU (t = 0)"]
[null,2,"(1) Pannello","(1) Slab","(1) Platte","(1) Panneau","(1) Panel"]
[null,3,"Presso-flessione","Press-bending","Druck-Biegung","Flexion-compression","Compresión-flexión"]
[null,4,"Taglio","Shear","Schub","Cisaillement","Cortante"]
[null,5,"(2) Nervatura","(2) Rib beam","(2) Rippenbalken","(2) Nervure","(2) Nervio"]
[null,6,"Tenso-flessione","Tens-bending","Zug-Biegung","Traction-flexion","Tracción-flexión"]
[null,7,"Taglio","Shear","Schub","Cisaillement","Cortante"]
[null,8,"Connessione","Connection","Verbindung","Connexion","Conexión"]
[null,9,"Verifica della connessione","Connection verification","Verbindungsnachweis","Vérification de la connexion","Verificación de la conexión"]
[null,10,"Verifiche di resistenza - SLU (t = ∞)","Resistance verification - ULS (t  = ∞)","Tragfähigkeitsnachweis - GZT (t = ∞)","Vérification de résistance - ELU (t = ∞)","Verificación de resistencia - ELU (t = ∞)"]
[null,11,"(1) Pannello","(1) Slab","(1) Platte","(1) Panneau","(1) Panel"]
[null,12,"Presso-flessione","Press-bending","Druck-Biegung","Flexion-compression","Compresión-flexión"]
[null,13,"Taglio","Shear","Schub","Cisaillement","Cortante"]
[null,14,"(2) Nervatura","(2) Rib beam","(2) Rippenbalken","(2) Nervure","(2) Nervio"]
[null,15,"Tenso-flessione","Tens-bending","Zug-Biegung","Traction-flexion","Tracción-flexión"]
[null,16,"Taglio","Shear","Schub","Cisaillement","Cortante"]
[null,17,"Connessione","Connection","Verbindung","Connexion","Conexión"]
[null,18,"Verifica della connessione","Connection verification","Verbindungsnachweis","Vérification de la connexion","Verificación de la conexión"]
[null,19,"Verifica di freccia","Deflection verification - ELS (t = 0)","Durchbiegungsnachweis - GZG (t = 0)","Vérification de la flèche - ELS (t = 0)","Verificación de flecha - ELS (t = 0)"]
[null,20,"Freccia massima","Maximum deflection","Maximale Durchbiegung","Flèche maximale","Flecha máxima"]
[null,21,"Freccia istantanea","Istantaneous deflection","Sofortige Durchbiegung","Flèche instantanée","Flecha instantánea"]
[null,22,"Verifica di freccia - SLE (t = ∞)","Deflection verification - ELS (t = ∞)","Durchbiegungsnachweis - GZG (t = ∞)","Vérification de la flèche - ELS (t = ∞)","Verificación de flecha - ELS (t = ∞)"]
[null,23,"Freccia massima","Maximum deflection","Maximale Durchbiegung","Flèche maximale","Flecha máxima"]
[null,24,"Freccia finale","Final deflection","Enddurchbiegung","Flèche finale","Flecha final"]
[null,25,"Verifica delle vibrazioni","Vibration verification","Schwingungsnachweis","Vérification des vibrations","Verificación de vibraciones"]
[null,26,"Rigidezza laterale","Lateral stiffness","Seitliche Steifigkeit","Rigidité latérale","Rigidez lateral"]
[null,27,"Smorzamento","Damping","Dämpfung","Amortissement","Amortiguamiento"]
[null,28,"Larghezza collaborante","Collaborating width","Mitwirkende Breite","Largeur collaborante","Anchura colaborante"]
[null,29,"Frequenza fondamentale","Fundamental Frequency","Grundfrequenz","Fréquence fondamentale","Frecuencia fundamental"]
[null,30,"Limite di freccia","Deflection limit","Durchbiegungsgrenze","Limite de flèche","Límite de flecha"]
[null,31,"Freccia istantanea","Istantaneous deflection","Sofortige Durchbiegung","Flèche instantanée","Flecha instantánea"]
[null,32,"Velocità istantanea","Istantaneous velocity","Sofortige Geschwindigkeit","Vitesse instantanée","Velocidad instantánea"]
[null,33,"Velocità massima","Maximum velocity","Maximale Geschwindigkeit","Vitesse maximale","Velocidad máxima"]
[null,34,"Accelerazione massima","Maximum acceleration","Maximale Beschleunigung","Accélération maximale","Aceleración máxima"]
[null,35,"Vibrazioni non percepibili","Vibrations not perceptible","Nicht wahrnehmbare Schwingungen","Vibrations non perceptibles","Vibraciones no perceptibles"]
[null,36,"Vibrazioni percepibili non fastidiose","Perceptible vibrations not annoying","Wahrnehmbare, nicht störende Schwingungen","Vibrations perceptibles non gênantes","Vibraciones perceptibles no molestas"]
[null,37,"Vibrazioni non accettabili","Unacceptable vibrations","Nicht akzeptable Schwingungen","Vibrations non acceptables","Vibraciones no aceptables"]
[]
[null,null,"REPORT"]
[]
[null,"Column1","IT","EN","DE","FR","ES","Column2"]
[null,1,"Relazione tecnica di calcolo","Technical calculation report"]
[null,2,null,"Sharp metal calculation"]
[null,3,"Informazioni progetto","Project informations","Projektinformationen","Informations du projet","Información del proyecto"]
[null,4,"Progetto","Project","Projekt","Projet","Proyecto"]
[null,5,"Progettista","Designer","Planer","Concepteur","Diseñador"]
[null,6,"Committente","Client","Auftraggeber","Client","Cliente"]
[null,7,"Comune","Municipality","Gemeinde","Commune","Municipio"]
[null,8,"Provincia","Province","Provinz","Province","Provincia"]
[null,9,"Geometria","Geometry"]
[null,10,null,"At support"]
[null,11,null,"At mid span"]
[null,12,null,"Panel type"]
[null,13,null,"Panel height"]
[null,14,null,"Panel width"]
[null,15,null,"Number of layers"]
[null,16,null,"Effective inertia"]
[null,17,null,"Effective area"]
[null,18,null,"Design loads on slab surface"]
[null,19,null,"Permanent loads"]
[null,20,null,"Accidental loads"]
[null,21,null,"Partial factor"]
[null,22,null,"Load duration"]
[null,23,null,"Service class"]
[null,24,null,"Design loads on the beam"]
[null,25,null,"Load on the coupled beam"]
[null,26,null,"Influence span"]
[null,27,null,"(1) Slab"]
[null,28,null,"Wood type"]
[null,29,null,"Characteristics"]
[null,30,null,"(2) Rib beam"]
[null,31,null,"Geometry"]
[null,32,null,"CLT type"]
[null,33,null,"Height"]
[null,34,null,"Base"]
[null,35,null,"Beam span"]
[null,36,null,"Height"]
[null,37,null,"Base"]
[null,38,null,"Connection stiffness"]
[null,39,null,"Sharp metal type:"]
[null,40,null,"Influence lenght"]
[null,41,null,"Number of SHARP METAL"]
[null,42,null,"TBS MAX diameter"]
[null,43,null,"ELS Stiffness"]
[null,44,null,"ULS Stiffness"]
[null,45,null,"SHARP METAL lenght"]
[null,46,null,"Connection design resistance"]
[null,47,null,"Coefficients"]
[null,48,null,"Loads and internal actions"]
[null,49,null,"Permanent loads"]
[null,50,null,"Accidental loads"]
[null,51,null,"Design load (permanent)"]
[null,52,null,"Design load"]
[null,53,null,"ULS combinations"]
[null,54,null,"Bending moment"]
[null,55,null,"Shear force"]
[null,56,null,"Elements stiffness at support (t = 0)"]
[null,57,null,"Bending stiffness"]
[null,58,null,"Axial stiffness"]
[null,59,null,"Elements stiffness at support at ULS  [g] (t = ∞)"]
[null,60,"Rigidezza sistema composto","Composite system stiffness"]
[null,61,null,"Composite bending stiffness"]
[null,62,null,"Composite axial stiffness"]
[null,63,"Distanza fra baricentro elemento1  ed elemento 2","Distance between centres of mass of (1) and (2)"]
[null,64,null,"Composite system effective stiffness"]
[null,65,null,"Composite system efficency"]
[null,66,null,"Connection stiffness"]
[null,67,null,"Elements stiffness at support at ULS [g+q] (t = ∞)"]
[null,68]
[null,69]
[null,70]
[null,71]
[null,72]
[null,73]
[null,74]
[null,75]
[null,76]
[null,77]
[null,78]
[null,79]
[null,80]
[null,81]
[null,82]
[null,83]
[null,84]
[null,85]
[null,86]
[null,87]
[null,88]
[null,89]
[null,90]
[null,91]
[null,92]
[null,93]
[null,94]
[null,95]
[null,96]
[null,97]
[null,98]
[null,99]
[null,100]
[null,101]
[null,102]
[null,103]
[null,104]
[null,105]
[null,106]
[null,107]
[null,108]
[null,109]
[null,110]
[null,111]
[null,112]
[null,113]
[null,114]
[null,115]
[null,116]
[null,117]
[null,118]
[null,119]
[null,120]
[null,121]
[null,122]
[null,123]
[null,124]
[null,125]

{"sheet":"Input","index":2,"n_rows":46,"n_cols":12,"rows_kept":46,"hidden":true,"merged":[[0,3,0,8],[0,10,0,11],[2,1,2,11],[4,2,4,3],[4,8,4,11],[5,2,5,5],[5,8,6,11],[6,2,6,5],[7,2,7,5],[8,2,8,5],[9,2,9,5],[11,1,11,11],[13,2,13,3],[13,8,13,11],[14,2,14,3],[14,8,14,11],[15,2,15,3],[17,1,17,11],[19,1,19,5],[19,7,19,11],[21,2,21,5],[21,8,21,11],[23,1,23,11],[25,1,25,5],[25,7,25,11],[27,2,27,5],[27,8,27,9],[28,2,28,3],[28,8,28,9],[29,2,29,3],[29,8,29,9],[30,2,30,3],[32,2,32,3],[34,1,34,11],[36,1,36,11],[38,1,38,5],[38,7,38,11],[40,2,40,5],[40,8,40,11],[41,2,41,3],[41,8,41,9],[42,4,42,5],[42,10,42,11],[43,2,43,3],[43,8,43,9],[45,2,45,3],[45,8,45,9],[47,1,47,5],[47,7,47,11]]}
[{"$nulls":3},"SHARP_METAL_CALCULATOR_v1.1",{"$nulls":6},"SHARP METAL"]
[]
[null,{"$f":"INDEX(LEN_IN[],1,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Project informations"}]
[]
[null,{"$f":"INDEX(LEN_IN[],2,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Data"},{"$f":"TODAY()","v":"2026-07-20"},{"$nulls":4},{"$f":"INDEX(LEN_IN[],8,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Standard"},"UNI EN 1995:2014"]
[null,{"$f":"INDEX(LEN_IN[],3,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Municipality"},{"$nulls":5},{"$f":"INDEX(LEN_IN[],9,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Notes"}]
[null,{"$f":"INDEX(LEN_IN[],4,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Province"}]
[null,{"$f":"INDEX(LEN_IN[],5,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Project"}]
[null,{"$f":"INDEX(LEN_IN[],6,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Designer"}]
[null,{"$f":"INDEX(LEN_IN[],7,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Client"}]
[]
[null,{"$f":"INDEX(LEN_IN[],10,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Design Loads"}]
[]
[null,{"$f":"INDEX(LEN_IN[],11,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Permanent loads"},"g1,k + g2,k",null,2.5,"kN/m2",null,{"$f":"INDEX(LEN_IN[],14,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Load duration"},"Medium term"]
[null,{"$f":"INDEX(LEN_IN[],12,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Accidental loads"},"qk",null,2,"kN/m2",null,{"$f":"INDEX(LEN_IN[],20,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Service Class"},1]
[null,{"$f":"INDEX(LEN_IN[],13,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Partial factor"},"ψ2,1",null,0.3]
[]
[null,{"$f":"INDEX(LEN_IN[],21,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Timber properties"}]
[]
[null,{"$f":"INDEX(LEN_IN[],22,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"(1) Slab"},{"$nulls":5},{"$f":"INDEX(LEN_IN[],24,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"(2) Rib beam"}]
[]
[null,{"$f":"INDEX(LEN_IN[],23,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Wood type"},"C24 - EN338:2016",{"$nulls":4},{"$f":"INDEX(LEN_IN[],25,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Wood type"},"GL24h - UNI EN14080:2013"]
[]
[null,{"$f":"INDEX(LEN_IN[],26,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Geometry"}]
[]
[null,{"$f":"INDEX(LEN_IN[],27,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"(1) Slab"},{"$nulls":5},{"$f":"INDEX(LEN_IN[],32,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"(2) Rib beam"}]
[]
[null,{"$f":"INDEX(LEN_IN[],28,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"CLT type"},"80mm-3-   30 20 30   ",{"$nulls":4},{"$f":"INDEX(LEN_IN[],33,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Minimum width"},"b2,min",null,{"$f":"MAX(IF($K$30<50+MAX(E46-25,E45)*2,\"trave troppo stretta\",_xlfn.CEILING.MATH(E43*50+2*MAX(E46-25,E45))),IF($K$30<50+MAX(K46-25,K45)*2,\"trave troppo stretta\",_xlfn.CEILING.MATH(K43*50+2*MAX(K46-25,K45))))","v":150},"mm"]
[null,{"$f":"INDEX(LEN_IN[],29,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Height"},"h1",null,{"$f":"INDEX(CLT[],MATCH(Input!$C$28,CLT[Code],0),2)","v":80},"mm",null,{"$f":"INDEX(LEN_IN[],34,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Height"},"h2",null,260,"mm"]
[null,{"$f":"INDEX(LEN_IN[],30,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Base"},"b1",null,800,"mm",null,{"$f":"INDEX(LEN_IN[],35,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Base"},"b2",null,150,"mm"]
[null,{"$f":"INDEX(LEN_IN[],31,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Rolling shear resistance"},"fv,rs,k",null,1.2,"N/mm2"]
[]
[null,{"$f":"INDEX(LEN_IN[],36,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Beam span"},"ℓ",null,6000,"mm"]
[]
[]
[]
[null,{"$f":"INDEX(LEN_IN[],37,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Connection system configuration"}]
[]
[null,{"$f":"INDEX(LEN_IN[],38,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"At Support"},{"$nulls":5},{"$f":"INDEX(LEN_IN[],43,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"At mid span"}]
[]
[null,{"$f":"INDEX(LEN_IN[],39,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"SHARP METAL type"},"SHARP METAL + TBS MAX@a ≤ 100mm",{"$nulls":4},{"$f":"INDEX(LEN_IN[],44,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"SHARP METAL type"},"SHARP METAL + TBS MAX@a ≤ 100mm"]
[null,{"$f":"INDEX(LEN_IN[],40,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Influence lenght"},"ℓ/4",null,{"$f":"$E$33/4","v":1500},"mm",null,{"$f":"INDEX(LEN_IN[],45,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Influence lenght"},"ℓ/2",null,{"$f":"$E$33/2","v":3000},"mm"]
[null,{"$f":"INDEX(LEN_IN[],41,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Number of SHARP METAL"},null,null,2,null,null,{"$f":"INDEX(LEN_IN[],46,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Number of SHARP METAL"},null,null,1]
[null,{"$f":"INDEX(LEN_IN[],42,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"TBS MAX diameter"},"d",null,8,"mm",null,{"$f":"INDEX(LEN_IN[],47,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"TBS MAX diameter"},"d",null,8,"mm"]
[null,"emin",null,null,{"$f":"_xlfn.CEILING.MATH(IF($K$30<=150,25,$K$30/6),1)","v":25},"mm",null,"emin",null,null,{"$f":"_xlfn.CEILING.MATH(IF($K$30<=150,25,$K$30/6),1)","v":25},"mm"]
[null,"a4,c,min","5 ⋅ d",null,{"$f":"5*E44","v":40},"mm",null,"a4,c,min","5 ⋅ d",null,{"$f":"5*K44","v":40},"mm"]

{"sheet":"RefText_DB","index":3,"n_rows":17,"n_cols":2,"rows_kept":17,"hidden":true}
[]
[]
[]
[null,"UNI EN 1995:2014"]
[null,"NTC2018"]
[]
[]
[]
[null,"SHARP METAL (alone) + TBS MAX@a = 250mm"]
[null,"SHARP METAL + TBS MAX@a ≤ 100mm"]
[null,"SHARP METAL + TBS MAX@100mm < a ≤ 175mm"]
[]
[]
[]
[null,{"$f":"IF(K60<8,INDEX(LEN_OUT[],35,MATCH(CONDITIONS!$E$3,LEN_OUT[#Headers],0)),\"\")","v":"Vibrations not perceptible"}]
[null,{"$f":"IF(K61<8,INDEX(LEN_OUT[],36,MATCH(CONDITIONS!$E$3,LEN_OUT[#Headers],0)),\"\")","v":"Perceptible vibrations not annoying"}]
[null,{"$f":"IF(K62<8,INDEX(LEN_OUT[],37,MATCH(CONDITIONS!$E$3,LEN_OUT[#Headers],0)),\"\")","v":"Unacceptable vibrations"}]

{"sheet":"Output","index":4,"n_rows":81,"n_cols":12,"rows_kept":81,"hidden":true,"merged":[[0,3,0,8],[0,10,0,11],[2,1,2,11],[4,2,4,3],[4,8,4,11],[5,2,5,5],[5,8,6,11],[6,2,6,5],[7,2,7,5],[8,2,8,5],[9,2,9,5],[11,1,11,11],[15,1,15,5],[15,7,15,11],[17,3,17,4],[17,9,17,10],[18,3,18,4],[18,9,18,10],[19,3,19,4],[19,9,19,10],[21,1,21,5],[23,3,23,4],[24,3,24,4],[26,1,26,11],[30,1,30,5],[30,7,30,11],[32,3,32,4],[32,9,32,10],[33,3,33,4],[33,9,33,10],[34,3,34,4],[34,9,34,10],[36,3,36,4],[36,9,36,10],[37,3,37,4],[37,9,37,10],[38,3,38,4],[38,9,38,10],[40,1,40,5],[42,3,42,4],[43,3,43,4],[45,3,45,4],[46,3,46,4],[48,1,48,11],[56,1,56,11],[64,3,64,8],[64,10,64,11],[66,1,66,11],[70,3,70,4],[71,2,71,3],[72,2,72,3],[80,7,80,11]]}
[{"$nulls":3},"SHARP_METAL_CALCULATOR_v1.1",{"$nulls":6},"SHARP METAL"]
[]
[null,{"$f":"Input!B3","v":"Project informations"}]
[]
[null,{"$f":"Input!B5","v":"Data"},{"$f":"Input!C5","v":"2026-07-20"},{"$nulls":4},{"$f":"INDEX(LEN_IN[],8,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Standard"},{"$f":"IF(ISBLANK(Input!I5),\"\",Input!I5)","v":"UNI EN 1995:2014"}]
[null,{"$f":"Input!B6","v":"Municipality"},{"$f":"IF(ISBLANK(Input!C6),\"\",Input!C6)","v":""},{"$nulls":4},{"$f":"INDEX(LEN_IN[],9,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Notes"},{"$f":"IF(ISBLANK(Input!I6),\"\",Input!I6)","v":""}]
[null,{"$f":"Input!B7","v":"Province"},{"$f":"IF(ISBLANK(Input!C7),\"\",Input!C7)","v":""}]
[null,{"$f":"Input!B8","v":"Project"},{"$f":"IF(ISBLANK(Input!C8),\"\",Input!C8)","v":""}]
[null,{"$f":"Input!B9","v":"Designer"},{"$f":"IF(ISBLANK(Input!C9),\"\",Input!C9)","v":""}]
[null,{"$f":"Input!B10","v":"Client"},{"$f":"IF(ISBLANK(Input!C10),\"\",Input!C10)","v":""}]
[]
[null,{"$f":"INDEX(LEN_OUT[],1,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Resistance verification - ULS (t  = 0)"}]
[]
[]
[]
[null,{"$f":"INDEX(LEN_OUT[],2,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"(1) Slab"},{"$nulls":5},{"$f":"INDEX(LEN_OUT[],5,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"(2) Rib beam"}]
[]
[{"$nulls":3},"g + q",{"$nulls":5},"g + q"]
[null,{"$f":"INDEX(LEN_OUT[],3,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Press-bending"},null,{"$f":"'Calculation Report'!$E$363","v":{"v":0.25837067296397853,"d":"25.8%"}},null,{"$f":"IF(D19<=1,\"OK\",\"NO\")","v":"OK"},null,{"$f":"INDEX(LEN_OUT[],6,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Tens-bending"},null,{"$f":"'Calculation Report'!$E$420","v":{"v":0.4789142255757569,"d":"47.9%"}},null,{"$f":"IF(J19<=1,\"OK\",\"NO\")","v":"OK"}]
[null,{"$f":"INDEX(LEN_OUT[],4,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Shear"},null,{"$f":"'Calculation Report'!$G$371/'Calculation Report'!$E$377","v":{"v":0.1818044166093772,"d":"18.2%"}},null,{"$f":"IF(D20<=1,\"OK\",\"NO\")","v":"OK"},null,{"$f":"INDEX(LEN_OUT[],7,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Shear"},null,{"$f":"'Calculation Report'!$G$428/'Calculation Report'!$G$435","v":{"v":0.30228505789683885,"d":"30.2%"}},null,{"$f":"IF(J20<=1,\"OK\",\"NO\")","v":"OK"}]
[]
[null,{"$f":"INDEX(LEN_OUT[],8,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Connection"}]
[]
[{"$nulls":3},"g + q"]
[null,{"$f":"INDEX(LEN_OUT[],9,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Connection verification"},null,{"$f":"MAX('Calculation Report'!$E$459/'Calculation Report'!$G$459,'Calculation Report'!$E$482/'Calculation Report'!$G$482)","v":{"v":0.6102719766591411,"d":"61.0%"}},null,{"$f":"IF(D25<=1,\"OK\",\"NO\")","v":"OK"}]
[]
[null,{"$f":"INDEX(LEN_OUT[],10,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Resistance verification - ULS (t  = ∞)"}]
[]
[]
[]
[null,{"$f":"INDEX(LEN_OUT[],11,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"(1) Slab"},{"$nulls":5},{"$f":"INDEX(LEN_OUT[],14,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"(2) Rib beam"}]
[]
[{"$nulls":3},"g + q",{"$nulls":5},"g + q"]
[null,{"$f":"INDEX(LEN_OUT[],12,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Press-bending"},null,{"$f":"'Calculation Report'!$E$662","v":{"v":0.2583706729639786,"d":"25.8%"}},null,{"$f":"IF(D34<=1,\"OK\",\"NO\")","v":"OK"},null,{"$f":"INDEX(LEN_OUT[],15,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Tens-bending"},null,{"$f":"'Calculation Report'!$E$720","v":{"v":0.478914225575757,"d":"47.9%"}},null,{"$f":"IF(J34<=1,\"OK\",\"NO\")","v":"OK"}]
[null,{"$f":"INDEX(LEN_OUT[],13,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Shear"},null,{"$f":"'Calculation Report'!$G$670/'Calculation Report'!$E$678","v":{"v":0.10941350061885385,"d":"10.9%"}},null,{"$f":"IF(D35<=1,\"OK\",\"NO\")","v":"OK"},null,{"$f":"INDEX(LEN_OUT[],16,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Shear"},null,{"$f":"'Calculation Report'!$G$728/'Calculation Report'!$E$735","v":{"v":0.3022850578968388,"d":"30.2%"}},null,{"$f":"IF(J35<=1,\"OK\",\"NO\")","v":"OK"}]
[]
[{"$nulls":3},"g",{"$nulls":5},"g"]
[null,{"$f":"INDEX(LEN_OUT[],12,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Press-bending"},null,{"$f":"'Calculation Report'!$E$513","v":{"v":0.1823792985628084,"d":"18.2%"}},null,{"$f":"IF(D38<=1,\"OK\",\"NO\")","v":"OK"},null,{"$f":"INDEX(LEN_OUT[],15,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Tens-bending"},null,{"$f":"'Calculation Report'!$E$568","v":{"v":0.3380571004064168,"d":"33.8%"}},null,{"$f":"IF(J38<=1,\"OK\",\"NO\")","v":"OK"}]
[null,{"$f":"INDEX(LEN_OUT[],13,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Shear"},null,{"$f":"'Calculation Report'!$G$521","v":{"v":0.09935260743253665,"d":"9.9%"}},null,{"$f":"IF(D39<=1,\"OK\",\"NO\")","v":"OK"},null,{"$f":"INDEX(LEN_OUT[],16,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Shear"},null,{"$f":"'Calculation Report'!$G$577","v":{"v":0.24017792553083414,"d":"24.0%"}},null,{"$f":"IF(J39<=1,\"OK\",\"NO\")","v":"OK"}]
[]
[null,{"$f":"INDEX(LEN_OUT[],17,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Connection"}]
[]
[{"$nulls":3},"g + q"]
[null,{"$f":"INDEX(LEN_OUT[],18,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Connection verification"},null,{"$f":"MAX('Calculation Report'!$E$754/'Calculation Report'!$G$754,'Calculation Report'!$E$776/'Calculation Report'!$G$776)","v":{"v":0.6102719766591412,"d":"61.0%"}},null,{"$f":"IF(D44<=1,\"OK\",\"NO\")","v":"OK"}]
[]
[{"$nulls":3},"g"]
[null,{"$f":"INDEX(LEN_OUT[],18,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Connection verification"},null,{"$f":"MAX('Calculation Report'!E610/'Calculation Report'!G610,'Calculation Report'!E628/'Calculation Report'!G628)","v":{"v":0.43078021881821726,"d":"43.1%"}},null,{"$f":"IF(D47<=1,\"OK\",\"NO\")","v":"OK"}]
[]
[null,{"$f":"INDEX(LEN_OUT[],19,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Deflection verification - ELS (t = 0)"}]
[]
[]
[]
[null,{"$f":"INDEX(LEN_OUT[],20,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Maximum deflection"},null,"ℓ /",300]
[]
[null,{"$f":"INDEX(LEN_OUT[],21,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Istantaneous deflection"},null,"uq,inst",{"$f":"'Calculation Report'!$B$927","v":{"v":8.619210669573874,"d":"8.62"}},"mm",null,null,"ulim",{"$f":"Input!$E$33/$E$53","v":{"v":20,"d":"20.00"}},"mm",{"$f":"IF(E55<=J55,\"OK\",\"NO\")","v":"OK"}]
[]
[null,{"$f":"INDEX(LEN_OUT[],22,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Deflection verification - ELS (t = ∞)"}]
[]
[]
[]
[null,{"$f":"INDEX(LEN_OUT[],23,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Maximum deflection"},null,"ℓ /",200]
[]
[null,{"$f":"INDEX(LEN_OUT[],24,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Final deflection"},null,"uq,inst",{"$f":"'Calculation Report'!$G$942","v":{"v":10.034676599532784,"d":"10.03"}},"mm",null,null,"ulim",{"$f":"Input!$E$33/$E$61","v":{"v":30,"d":"30.00"}},"mm",{"$f":"IF(E63<=J63,\"OK\",\"NO\")","v":"OK"}]
[]
[{"$nulls":3},"SHARP_METAL_CALCULATOR_v1.1",{"$nulls":6},"SHARP METAL"]
[]
[null,{"$f":"INDEX(LEN_OUT[],25,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Vibration verification"}]
[]
[]
[]
[null,{"$f":"INDEX(LEN_OUT[],26,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Lateral stiffness"},"EJb",{"$f":"MIN(EJeff!J21:K21)*EJeff!$D$3/EJeff!$B$3","v":{"v":7333333.333333332,"d":"7.333E+06"}},null,"Nmm2/m",null,{"$f":"INDEX(LEN_OUT[],29,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Fundamental Frequency"},null,"f1",{"$f":"'Calculation Report'!$G$975","v":{"v":7.606719237126268,"d":"7.61"}},"Hz"]
[null,{"$f":"INDEX(LEN_OUT[],27,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Damping"},"ξ",null,{"v":0.04,"d":"4%"}]
[null,{"$f":"INDEX(LEN_OUT[],28,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Collaborating width"},"b",null,{"$f":"Input!$E$30/1000","v":{"v":0.8,"d":"0.80"}},"m"]
[]
[null,{"$f":"INDEX(LEN_OUT[],31,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Istantaneous deflection"},null,"w",{"$f":"'Calculation Report'!G982","v":{"v":0.5804182269073316,"d":"0.58"}},"mm",null,{"$f":"INDEX(LEN_OUT[],30,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Deflection limit"},"wlim",{"v":1,"d":"1.0"},"mm",{"$f":"IF(E75<=J75,\"OK\",\"NO\")","v":"OK"}]
[]
[]
[]
[null,{"$f":"INDEX(LEN_OUT[],32,MATCH(CONDITIONS!$E$3,LEN_OUT[#Headers],0))","v":"Istantaneous velocity"},null,"v",{"$f":"'Calculation Report'!$G$992*1000","v":{"v":2.41830367460134,"d":"2.42"}},"mm/s",null,{"$f":"INDEX(LEN_OUT[],33,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Maximum velocity"},"vlim",{"$f":"'Calculation Report'!$G$996*1000","v":{"v":8.455612130883088,"d":"8.46"}},"mm/s",{"$f":"IF(E79<=J79,\"OK\",\"NO\")","v":"OK"}]
[]
[null,{"$f":"IF(K71<8,INDEX(LEN_OUT[],34,MATCH(CONDITIONS!$E$3,LEN_OUT[#Headers],0)),\"\")","v":"Maximum acceleration"},null,{"$f":"IF(K71<8,\"a\",\"\")","v":"a"},{"$f":"IF(K71<8,'Calculation Report'!$G$992*1000,\"\")","v":{"v":2.41830367460134,"d":"2.42"}},{"$f":"IF(K71<8,\"mm/s2\",\"\")","v":"mm/s2"},null,{"$f":"IF(K71<8,IF(E81<=0.1,RefText_DB!$B$15,IF(E81<0.35,RefText_DB!$B$16,RefText_DB!$B$17)),\"\")","v":"Unacceptable vibrations"}]

{"sheet":"Calculation Report","index":5,"n_rows":1006,"n_cols":12,"rows_kept":1006,"hidden":true,"merged":[[6,2,11,7],[10,10,10,11],[12,9,12,11],[14,3,14,11],[16,3,16,10],[18,3,18,8],[23,3,23,6],[23,8,23,11],[27,3,27,6],[27,8,27,11],[34,1,34,11],[36,2,36,9],[38,1,38,5],[38,7,38,11],[40,2,40,5],[40,8,40,11],[44,2,44,3],[44,8,44,9],[45,2,45,3],[45,8,45,9],[47,1,47,11],[49,2,49,3],[49,8,49,11],[50,2,50,3],[51,2,51,3],[51,8,51,11],[53,1,53,11],[55,1,55,11],[57,2,57,3],[58,2,58,3],[59,2,59,3],[61,1,61,11],[64,1,64,11],[66,2,66,4],[70,1,70,3],[86,1,86,11],[88,2,88,4],[92,1,92,3],[111,1,111,11],[113,1,113,5],[113,7,113,11],[115,2,115,3],[115,8,115,9],[116,2,116,3],[116,8,116,9],[117,8,117,9],[118,2,118,3],[120,1,120,11],[122,1,122,11],[124,1,124,5],[124,7,124,11],[126,1,126,5],[126,7,126,11],[128,1,128,5],[128,7,128,11],[130,2,130,3],[130,8,130,9],[134,2,134,3],[134,8,134,9],[136,2,136,3],[136,8,136,9],[138,1,138,5],[138,7,138,11],[140,2,140,3],[140,8,140,9],[141,2,141,3],[141,8,141,9],[142,2,142,3],[142,8,142,9],[144,1,145,1],[144,2,144,3],[144,7,145,7],[144,8,144,9],[145,2,145,3],[145,8,145,9],[147,1,147,11],[149,2,149,3],[149,8,149,9],[150,2,150,3],[150,8,150,9],[151,2,151,3],[151,8,151,9],[154,1,154,11],[156,2,156,3],[157,2,157,3],[162,1,162,5],[162,7,162,11],[164,1,164,11],[169,1,169,11],[171,1,171,5],[171,7,171,11],[173,2,173,3],[173,8,173,9],[174,2,174,3],[174,8,174,9],[176,1,176,5],[184,2,184,3],[186,1,186,5],[188,7,194,11],[192,2,192,3],[196,7,196,11],[198,8,198,9],[202,1,202,11],[204,1,204,5],[204,7,204,11],[206,2,206,3],[206,8,206,9],[209,2,209,3],[209,8,209,9],[210,2,210,3],[210,8,210,9],[212,1,212,5],[220,2,220,3],[225,2,225,3],[233,1,233,5],[238,1,238,11],[240,1,240,5],[240,7,240,11],[242,2,242,3],[242,8,242,9],[245,2,245,3],[245,8,245,9],[246,2,246,3],[246,8,246,9],[248,1,248,5],[256,2,256,3],[261,2,261,3],[269,1,269,5]]}
[{"$nulls":7},{"$f":"IF(AND(Output!F19=\"OK\",Output!F20=\"OK\",Output!L19=\"OK\",Output!L20=\"OK\",Output!F25=\"OK\",Output!F34=\"OK\",Output!F35=\"OK\",Output!F38=\"OK\",Output!F39=\"OK\",Output!L34=\"OK\",Output!L35=\"OK\",Output!L38=\"OK\",Output!L39=\"OK\",Output!F44=\"OK\",Output!F47=\"OK\",Output!L55=\"OK\",Output!L63=\"OK\",Output!L75=\"OK\",Output!L79=\"OK\"),\"OK\",\"NO\")","v":"OK"}]
[]
[]
[]
[]
[]
[null,null,{"$f":"INDEX(LEN_REPORT[],1,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Technical calculation report"}]
[]
[]
[]
[{"$nulls":10},{"$f":"Input!$C$5","v":"2026-07-20"}]
[]
[null,null,"Sharp metal calculation",{"$nulls":3},"V1.1",null,null,{"$f":"IF(ISBLANK(Input!I5),\"\",Input!I5)","v":"UNI EN 1995:2014"}]
[]
[{"$nulls":3},{"$f":"IF(ISBLANK(Input!C8),\"\",Input!C8)","v":""}]
[]
[{"$nulls":3},{"$f":"IF(ISBLANK(Input!I6),\"\",Input!I6)","v":""}]
[]
[]
[]
[]
[{"$nulls":3},{"$f":"INDEX(LEN_REPORT[],5,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Designer"},{"$nulls":4},{"$f":"INDEX(LEN_REPORT[],8,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Province"}]
[]
[{"$nulls":3},{"$f":"IF(ISBLANK(Input!C9),\"\",Input!C9)","v":""},{"$nulls":4},{"$f":"IF(ISBLANK(Input!C7),\"\",Input!C7)","v":""}]
[]
[{"$nulls":3},{"$f":"INDEX(LEN_REPORT[],6,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Client"},{"$nulls":4},{"$f":"INDEX(LEN_REPORT[],7,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Municipality"}]
[]
[{"$nulls":3},{"$f":"IF(ISBLANK(Input!C10),\"\",Input!C10)","v":""},{"$nulls":4},{"$f":"IF(ISBLANK(Input!C6),\"\",Input!C6)","v":""}]
[]
[]
[]
[]
[]
[]
[null,{"$f":"INDEX(LEN_REPORT[],9,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Geometry"}]
[]
[]
[]
[null,{"$f":"INDEX(LEN_REPORT[],10,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"At support"},{"$nulls":5},{"$f":"INDEX(LEN_REPORT[],11,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"At mid span"}]
[]
[null,{"$f":"INDEX(LEN_REPORT[],12,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Panel type"},{"$f":"Input!C28","v":"80mm-3-   30 20 30   "},{"$nulls":4},{"$f":"INDEX(LEN_REPORT[],12,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Panel type"},{"$f":"Input!C28","v":"80mm-3-   30 20 30   "}]
[]
[null,{"$f":"INDEX(LEN_REPORT[],15,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Number of layers"},null,null,{"$f":"SUM(INDEX(CLT[],MATCH($C$41,CLT[Code],0),4))","v":3},null,null,{"$f":"INDEX(LEN_REPORT[],15,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Number of layers"},null,null,{"$f":"SUM(INDEX(CLT[],MATCH($C$41,CLT[Code],0),4))","v":3}]
[]
[null,{"$f":"INDEX(LEN_REPORT[],16,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Effective inertia"},"Jeff,s",null,{"$f":"MAX(J_MidSpan[#Totals])","v":{"v":25702879.429814834,"d":"2.6E+07"}},"mm4",null,{"$f":"INDEX(LEN_REPORT[],16,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Effective inertia"},"Jeff,ms",null,{"$f":"MAX(J_Support[#Totals])","v":{"v":8820000,"d":"8.8E+06"}},"mm4"]
[null,{"$f":"INDEX(LEN_REPORT[],17,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Effective area"},"Aeff,s",null,{"$f":"MAX(A_MidSpan[#Totals])","v":{"v":36718.39918544976,"d":"36718"}},"mm2",null,{"$f":"INDEX(LEN_REPORT[],17,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Effective area"},"Aeff,ms",null,{"$f":"MAX(A_Support[#Totals])","v":12600},"mm2"]
[]
[null,{"$f":"INDEX(LEN_REPORT[],18,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Design loads on slab surface"}]
[]
[null,{"$f":"INDEX(LEN_REPORT[],19,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Permanent loads"},"g1,k + g2,k",null,{"$f":"Input!$E$14","v":{"v":2.5,"d":"2.50"}},"kN/m2",null,{"$f":"INDEX(LEN_REPORT[],22,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Load duration"},{"$f":"Input!$I$14","v":"Medium term"}]
[null,{"$f":"INDEX(LEN_REPORT[],20,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Accidental loads"},"qk",null,{"$f":"Input!$E$15","v":{"v":2,"d":"2.00"}},"kN/m2"]
[null,{"$f":"INDEX(LEN_REPORT[],21,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Partial factor"},"ψ2,1",null,{"$f":"Input!$E$16","v":0.3},"kN/m2",null,{"$f":"INDEX(LEN_REPORT[],23,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Service class"},{"$f":"Input!$I$15","v":1}]
[]
[]
[]
[null,{"$f":"INDEX(LEN_REPORT[],24,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Design loads on the beam"}]
[]
[null,{"$f":"INDEX(LEN_REPORT[],26,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Influence span"},"i",null,{"$f":"Input!$E$30/1000","v":{"v":0.8,"d":"0.80"}},"m"]
[null,{"$f":"INDEX(LEN_REPORT[],19,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Permanent loads"},"gk = g1,k + g2,k",null,{"$f":"E50*E58","v":{"v":2,"d":"2.00"}},"kN/m2"]
[null,{"$f":"INDEX(LEN_REPORT[],20,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Accidental loads"},"qk",null,{"$f":"E51*E58","v":{"v":1.6,"d":"1.60"}},"kN/m2"]
[]
[]
[]
[]
[null,{"$f":"INDEX(LEN_REPORT[],27,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"(1) Slab"}]
[]
[null,{"$f":"INDEX(LEN_REPORT[],28,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Wood type"},{"$f":"Input!$C$22","v":"C24 - EN338:2016"},{"$nulls":4},"kmod,g+q",{"$f":"INDEX(kmod[],MATCH($I$52,kmod[CS],0),MATCH($I$50,kmod[#Headers],0))","v":0.8}]
[{"$nulls":7},"kmod,g",{"$f":"INDEX(kmod[],MATCH($I$52,kmod[CS],0),2)","v":0.6}]
[{"$nulls":7},"kcrack",{"v":0.67,"d":"0.7"}]
[]
[null,{"$f":"INDEX(LEN_REPORT[],29,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Characteristics"},{"$nulls":6},"g + q","g"]
[null,"fm,k",{"$f":"INDEX(TimberType[],MATCH(Input!$C$22,TimberType[Classe],0),MATCH(B72,TimberType[#Headers],0))","v":{"v":24,"d":"24.00"}},"MPa",{"$nulls":3},"fm,d",{"$f":"C72*(I67)/$K$151","v":{"v":15.360000000000003,"d":"15.36"}},{"$f":"C72*I68/$K$151","v":11.52},"MPa"]
[null,"ft,0,k",{"$f":"INDEX(TimberType[],MATCH(Input!$C$22,TimberType[Classe],0),MATCH(B73,TimberType[#Headers],0))","v":{"v":14.5,"d":"14.50"}},"MPa",{"$nulls":3},"ft,0,d",{"$f":"C73*I67/$K$151","v":{"v":9.280000000000001,"d":"9.28"}},{"$f":"C73*I68/$K$151","v":{"v":6.959999999999999,"d":"6.96"}},"MPa"]
[null,"ft,90,k",{"$f":"INDEX(TimberType[],MATCH(Input!$C$22,TimberType[Classe],0),MATCH(B74,TimberType[#Headers],0))","v":{"v":0.4,"d":"0.40"}},"MPa",{"$nulls":3},"ft,90,d",{"$f":"C74*I67/$K$151","v":{"v":0.25600000000000006,"d":"0.26"}},{"$f":"C74*I68/$K$151","v":{"v":0.192,"d":"0.19"}},"MPa"]
[null,"fc,0,k",{"$f":"INDEX(TimberType[],MATCH(Input!$C$22,TimberType[Classe],0),MATCH(B75,TimberType[#Headers],0))","v":{"v":21,"d":"21.00"}},"MPa",{"$nulls":3},"fc,0,d",{"$f":"C75*I67/$K$151","v":{"v":13.440000000000001,"d":"13.44"}},{"$f":"C75*I68/$K$151","v":10.08},"MPa"]
[null,"fc,90,k",{"$f":"INDEX(TimberType[],MATCH(Input!$C$22,TimberType[Classe],0),MATCH(B76,TimberType[#Headers],0))","v":{"v":2.5,"d":"2.50"}},"MPa",{"$nulls":3},"fc,90,d",{"$f":"C76*I67/$K$151","v":{"v":1.6,"d":"1.60"}},{"$f":"C76*I68/$K$151","v":{"v":1.2,"d":"1.20"}},"MPa"]
[null,"fv,k",{"$f":"INDEX(TimberType[],MATCH(Input!$C$22,TimberType[Classe],0),MATCH(B77,TimberType[#Headers],0))","v":{"v":4,"d":"4.00"}},"MPa",{"$nulls":3},"fv,d",{"$f":"C77*I67/$K$151*I69","v":{"v":1.7152,"d":"1.72"}},{"$f":"C77*I68/$K$151*I69","v":{"v":1.2864,"d":"1.29"}},"MPa"]
[null,"frs,k",{"$f":"Input!$E$31","v":{"v":1.2,"d":"1.20"}},"MPa",{"$nulls":3},"frs,d",{"$f":"C78*I67/$K$152","v":{"v":0.768,"d":"0.77"}},{"$f":"C78*I68/$K$152","v":{"v":0.576,"d":"0.58"}},"MPa"]
[]
[null,"E0,mean",{"$f":"INDEX(TimberType[],MATCH(Input!$C$22,TimberType[Classe],0),MATCH(B80,TimberType[#Headers],0))","v":11000},"MPa"]
[null,"E0,05",{"$f":"INDEX(TimberType[],MATCH(Input!$C$22,TimberType[Classe],0),MATCH(B81,TimberType[#Headers],0))","v":7400},"MPa"]
[null,"Gmean",{"$f":"INDEX(TimberType[],MATCH(Input!$C$22,TimberType[Classe],0),MATCH(B82,TimberType[#Headers],0))","v":690},"MPa"]
[null,"G05",{"$f":"INDEX(TimberType[],MATCH(Input!$C$22,TimberType[Classe],0),MATCH(B83,TimberType[#Headers],0))","v":0},"MPa"]
[]
[null,"ρk",{"$f":"INDEX(TimberType[],MATCH(Input!$C$22,TimberType[Classe],0),MATCH(B85,TimberType[#Headers],0))","v":350},"kg/m3"]
[]
[null,{"$f":"INDEX(LEN_REPORT[],30,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"(2) Rib beam"}]
[]
[null,{"$f":"INDEX(LEN_REPORT[],28,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Wood type"},{"$f":"Input!$I$22","v":"GL24h - UNI EN14080:2013"},{"$nulls":4},"kmod,g+q",{"$f":"INDEX(kmod[],MATCH($I$52,kmod[CS],0),MATCH($I$50,kmod[#Headers],0))","v":0.8}]
[{"$nulls":7},"kmod,g",{"$f":"INDEX(kmod[],MATCH($I$52,kmod[CS],0),2)","v":0.6}]
[{"$nulls":7},"kcrack",{"v":0.67,"d":"0.7"}]
[]
[null,{"$f":"INDEX(LEN_REPORT[],29,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Characteristics"},{"$nulls":6},"g + q","g"]
[null,"fm,k",{"$f":"INDEX(TimberType[],MATCH(Input!$I$22,TimberType[Classe],0),MATCH(B94,TimberType[#Headers],0))","v":{"v":24,"d":"24.00"}},"MPa",{"$nulls":3},"fm,d",{"$f":"C94*I89/$K$152","v":{"v":15.360000000000003,"d":"15.36"}},{"$f":"C94*I90/$K$151","v":11.52},"MPa"]
[null,"ft,0,k",{"$f":"INDEX(TimberType[],MATCH(Input!$I$22,TimberType[Classe],0),MATCH(B95,TimberType[#Headers],0))","v":{"v":19.2,"d":"19.20"}},"MPa",{"$nulls":3},"ft,0,d",{"$f":"C95*I89/$K$152","v":{"v":12.288,"d":"12.29"}},{"$f":"C95*I90/$K$151","v":{"v":9.216,"d":"9.22"}},"MPa"]
[null,"ft,90,k",{"$f":"INDEX(TimberType[],MATCH(Input!$I$22,TimberType[Classe],0),MATCH(B96,TimberType[#Headers],0))","v":{"v":0.5,"d":"0.50"}},"MPa",{"$nulls":3},"ft,90,d",{"$f":"C96*I89/$K$152","v":0.32},{"$f":"C96*I90/$K$151","v":0.24},"MPa"]
[null,"fc,0,k",{"$f":"INDEX(TimberType[],MATCH(Input!$I$22,TimberType[Classe],0),MATCH(B97,TimberType[#Headers],0))","v":{"v":24,"d":"24.00"}},"MPa",{"$nulls":3},"fc,0,d",{"$f":"C97*I89/$K$152","v":{"v":15.360000000000003,"d":"15.36"}},{"$f":"C97*I90/$K$151","v":11.52},"MPa"]
[null,"fc,90,k",{"$f":"INDEX(TimberType[],MATCH(Input!$I$22,TimberType[Classe],0),MATCH(B98,TimberType[#Headers],0))","v":{"v":2.5,"d":"2.50"}},"MPa",{"$nulls":3},"fc,90,d",{"$f":"C98*I89/$K$152","v":{"v":1.6,"d":"1.60"}},{"$f":"C98*I90/$K$151","v":{"v":1.2,"d":"1.20"}},"MPa"]
[null,"fv,k",{"$f":"INDEX(TimberType[],MATCH(Input!$I$22,TimberType[Classe],0),MATCH(B99,TimberType[#Headers],0))","v":{"v":3.5,"d":"3.50"}},"MPa",{"$nulls":3},"fv,d",{"$f":"C99*I89/$K$152*I91","v":{"v":1.5008000000000001,"d":"1.50"}},{"$f":"C99*I90/$K$151*I91","v":{"v":1.1256000000000002,"d":"1.13"}},"MPa"]
[null,"frs,k",{"$f":"Input!$E$31","v":{"v":1.2,"d":"1.20"}},"MPa",{"$nulls":3},"frs,d",{"$f":"C100*I89/$K$152","v":{"v":0.768,"d":"0.77"}},{"$f":"C100*I90/$K$152","v":{"v":0.576,"d":"0.58"}},"MPa"]
[]
[null,"E0,mean",{"$f":"INDEX(TimberType[],MATCH(Input!$I$22,TimberType[Classe],0),MATCH(B102,TimberType[#Headers],0))","v":11500},"MPa"]
[null,"E0,05",{"$f":"INDEX(TimberType[],MATCH(Input!$I$22,TimberType[Classe],0),MATCH(B103,TimberType[#Headers],0))","v":9600},"MPa"]
[null,"Gmean",{"$f":"INDEX(TimberType[],MATCH(Input!$I$22,TimberType[Classe],0),MATCH(B104,TimberType[#Headers],0))","v":650},"MPa"]
[null,"G05",{"$f":"INDEX(TimberType[],MATCH(Input!$I$22,TimberType[Classe],0),MATCH(B105,TimberType[#Headers],0))","v":540},"MPa"]
[]
[null,"ρk",{"$f":"INDEX(TimberType[],MATCH(Input!$I$22,TimberType[Classe],0),MATCH(B107,TimberType[#Headers],0))","v":385},"kg/m3"]
[]
[]
[]
[]
[null,{"$f":"INDEX(LEN_REPORT[],31,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Geometry"}]
[]
[null,{"$f":"INDEX(LEN_REPORT[],27,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"(1) Slab"},{"$nulls":5},{"$f":"INDEX(LEN_REPORT[],30,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"(2) Rib beam"}]
[]
[null,{"$f":"INDEX(LEN_REPORT[],33,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Height"},"h1",null,{"$f":"Input!$E$29","v":80},"mm",null,{"$f":"INDEX(LEN_REPORT[],36,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Height"},"h2",null,{"$f":"Input!$K$29","v":260},"mm"]
[null,{"$f":"INDEX(LEN_REPORT[],34,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Base"},"b1",null,{"$f":"Input!E30","v":800},"mm",null,{"$f":"INDEX(LEN_REPORT[],37,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Base"},"b2",null,{"$f":"Input!$K$30","v":150},"mm"]
[{"$nulls":8},"b2,min",null,{"$f":"Input!K28","v":150},"mm"]
[null,{"$f":"INDEX(LEN_REPORT[],35,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Beam span"},"ℓ",null,{"$f":"Input!$E$33","v":6000},"mm"]
[]
[]
[]
[null,{"$f":"INDEX(LEN_REPORT[],38,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Connection stiffness"}]
[]
[null,{"$f":"INDEX(LEN_REPORT[],10,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"At support"},{"$nulls":5},{"$f":"INDEX(LEN_REPORT[],11,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"At mid span"}]
[]
[null,{"$f":"INDEX(LEN_REPORT[],39,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Sharp metal type:"},{"$nulls":5},{"$f":"INDEX(LEN_REPORT[],39,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Sharp metal type:"}]
[]
[null,{"$f":"Input!$C$41","v":"SHARP METAL + TBS MAX@a ≤ 100mm"},{"$nulls":5},{"$f":"Input!$I$41","v":"SHARP METAL + TBS MAX@a ≤ 100mm"}]
[]
[null,{"$f":"INDEX(LEN_REPORT[],40,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Influence lenght"},"ℓ/4",null,{"$f":"Input!E42","v":1500},"mm",null,{"$f":"INDEX(LEN_REPORT[],40,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Influence lenght"},"ℓ/2",null,{"$f":"Input!K42","v":3000},"mm"]
[]
[null,{"$f":"INDEX(LEN_REPORT[],41,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Number of SHARP METAL"},null,null,{"$f":"Input!E43","v":2},null,null,{"$f":"INDEX(LEN_REPORT[],41,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Number of SHARP METAL"},null,null,{"$f":"Input!K43","v":1}]
[]
[null,{"$f":"INDEX(LEN_REPORT[],42,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"TBS MAX diameter"},"d",null,{"$f":"Input!E44","v":8},"mm",null,{"$f":"INDEX(LEN_REPORT[],42,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"TBS MAX diameter"},"d",null,{"$f":"Input!K44","v":8},"mm"]
[null,"emin",null,null,{"$f":"Input!E45","v":25},"mm",null,"emin",null,null,{"$f":"Input!K45","v":25},"mm"]
[null,"a4,c,min","5 ⋅ d",null,{"$f":"Input!E46","v":40},"mm",null,"a4,c,min","5 ⋅ d",null,{"$f":"Input!K46","v":40},"mm"]
[]
[]
[]
[null,{"$f":"INDEX(LEN_REPORT[],43,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"ELS Stiffness"},"Kser",null,{"$f":"'sharp metal'!C9*0.75+'sharp metal'!G9*0.25","v":{"v":240187.5,"d":"2.4E+05"}},"N/mm",null,{"$f":"INDEX(LEN_REPORT[],43,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"ELS Stiffness"},"Kser",null,{"$f":"E141","v":{"v":240187.5,"d":"2.4E+05"}},"N/mm"]
[null,{"$f":"INDEX(LEN_REPORT[],44,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"ULS Stiffness"},"Kser",null,{"$f":"2/3*E141","v":{"v":160125,"d":"1.6E+05"}},"N/mm",null,{"$f":"INDEX(LEN_REPORT[],44,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"ULS Stiffness"},"Kser",null,{"$f":"E142","v":{"v":160125,"d":"1.6E+05"}},"N/mm"]
[null,{"$f":"INDEX(LEN_REPORT[],45,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"SHARP METAL lenght"},"seq","=",1000,"mm",null,{"$f":"INDEX(LEN_REPORT[],45,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"SHARP METAL lenght"},"seq","=",1000,"mm"]
[]
[null,{"$f":"INDEX(LEN_REPORT[],46,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Connection design resistance"},"Rd,g",null,{"$f":"'sharp metal'!C14*I90/MAX($K$150)","v":{"v":68121.23483779278,"d":"68121"}},"N",null,{"$f":"INDEX(LEN_REPORT[],46,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Connection design resistance"},"Rd,g",null,{"$f":"'sharp metal'!G14*I90/K150","v":{"v":34060.61741889639,"d":"34061"}},"N"]
[null,null,"Rd,g+q",null,{"$f":"'sharp metal'!C14*I89/MAX($K$150)","v":{"v":90828.31311705706,"d":"90828"}},"N",null,null,"Rd,g+q",null,{"$f":"'sharp metal'!G14*I89/K150","v":{"v":45414.15655852853,"d":"45414"}},"N"]
[]
[null,{"$f":"INDEX(LEN_REPORT[],47,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Coefficients"}]
[]
[null,null,"kdef",null,{"$f":"INDEX(kdef[],MATCH($I$52,kdef[CS],0),2)","v":0.69},null,null,"Connections","γm SLU,con",null,{"$f":"INDEX(γ[],MATCH(LEFT(I150,2),γ[γ],0),MATCH(Input!$I$5,γ[#Headers],0))","v":{"v":1.3,"d":"1.30"}}]
[null,null,"kh, el 1",null,{"$f":"IF(F151=\"C\",IF(E116<=150,MIN((150/E116)^0.2,1.3),1),IF(E116<600,MIN((600/E116)^0.1,1.1),1))","v":{"v":1.1339665776330272,"d":"1.13"}},{"$f":"IF(LEFT(Input!$C$22,1)=\"C\",\"C\",IF(LEFT(Input!$C$22,2)=\"GL\",\"GL\",\"err\"))","v":"C"},null,"(1) Slab","γm,SLU,1",null,{"$f":"INDEX(γ[],MATCH(I151,γ[γ],0),MATCH(Input!$I$5,γ[#Headers],0))","v":1.25}]
[null,null,"kh, el 2",null,{"$f":"IF(F152=\"C\",IF(K116<=150,MIN((150/K116)^0.2,1.3),1),IF(K116<600,MIN((600/K116)^0.1,1.1),1))","v":{"v":1.0872208946249378,"d":"1.09"}},{"$f":"IF(LEFT(Input!$I$22,1)=\"C\",\"C\",IF(LEFT(Input!$I$22,2)=\"GL\",\"GL\",\"err\"))","v":"GL"},null,"(2) Rib beam","γm,SLU,2",null,{"$f":"INDEX(γ[],MATCH(I152,γ[γ],0),MATCH(Input!$I$5,γ[#Headers],0))","v":1.25}]
[]
[]
[null,{"$f":"INDEX(LEN_REPORT[],48,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Loads and internal actions"}]
[]
[null,{"$f":"INDEX(LEN_REPORT[],49,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Permanent loads"},"g1,k + g2,k",null,{"$f":"$E$59","v":2},"kN/m2"]
[null,{"$f":"INDEX(LEN_REPORT[],50,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Accidental loads"},"qk",null,{"$f":"$E$60","v":1.6},"kN/m2"]
[]
[null,{"$f":"INDEX(LEN_REPORT[],51,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Design load (permanent)"},{"$nulls":4},{"$f":"(Dati!$K$78*E157)","v":2.7},"kN/m"]
[null,{"$f":"INDEX(LEN_REPORT[],52,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Design load"},{"$nulls":4},{"$f":"(Dati!$K$78*E157+Dati!$K$79*E158)","v":5.1000000000000005},"kN/m"]
[]
[]
[]
[null,{"$f":"INDEX(LEN_REPORT[],53,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"ULS combinations"}]
[]
[null,{"$f":"INDEX(LEN_REPORT[],54,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Bending moment"},null,null,{"$f":"$G$160*$E$119^2/8/10^6","v":12.15},"kNm",null,{"$f":"INDEX(LEN_REPORT[],54,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Bending moment"},null,null,{"$f":"$G$161*$E$119^2/8/10^6","v":{"v":22.950000000000003,"d":"22.95"}},"kNm"]
[null,{"$f":"INDEX(LEN_REPORT[],55,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Shear force"},null,null,{"$f":"$G$160*$E$119/2/10^3","v":{"v":8.100000000000001,"d":"8.10"}},"kN",null,{"$f":"INDEX(LEN_REPORT[],55,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Shear force"},null,null,{"$f":"$G$161*$E$119/2/10^3","v":{"v":15.300000000000002,"d":"15.30"}},"kN"]
[]
[null,{"$f":"INDEX(LEN_REPORT[],56,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Elements stiffness at support (t = 0)"}]
[]
[null,{"$f":"INDEX(LEN_REPORT[],27,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"(1) Slab"},{"$nulls":5},{"$f":"INDEX(LEN_REPORT[],30,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"(2) Rib beam"}]
[]
[null,{"$f":"INDEX(LEN_REPORT[],57,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Bending stiffness"},"E0,meanJeff,s = E1J1",null,{"$f":"C80*E45","v":{"v":282731673727.9632,"d":"2.8E+11"}},"Nmm2",null,{"$f":"INDEX(LEN_REPORT[],57,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Bending stiffness"},"E0,meanJeff,s = E2J2",null,{"$f":"C102*K117*K116^3/12","v":{"v":2526550000000,"d":"2.5E+12"}},"Nmm2"]
[null,{"$f":"INDEX(LEN_REPORT[],58,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Axial stiffness"},"E0,meanAeff,s = E1A1",null,{"$f":"C80*E46","v":{"v":403902391.03994733,"d":"4.0E+08"}},"N",null,{"$f":"INDEX(LEN_REPORT[],58,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Axial stiffness"},"E0,meanAeff,s = E2A2",null,{"$f":"C102*K116*K117","v":{"v":448500000,"d":"4.5E+08"}},"N"]
[]
[null,{"$f":"INDEX(LEN_REPORT[],60,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Composite system stiffness"}]
[]
[null,{"$f":"INDEX(LEN_REPORT[],61,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Composite bending stiffness"},null,null,{"$f":"K174+E174","v":{"v":2809281673727.9634,"d":"2.8E+12"}},"Nmm2"]
[null,{"$f":"INDEX(LEN_REPORT[],62,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Composite axial stiffness"},null,null,{"$f":"(K175*E175)/(K175+E175)","v":{"v":212517262.13532746,"d":"2.1E+08"}},"N"]
[]
[null,{"$f":"INDEX(LEN_REPORT[],63,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Distance between centres of mass of (1) and (2)"},null,null,{"$f":"E116/2+K116/2","v":170},"mm"]
[]
[null,{"$f":"INDEX(LEN_REPORT[],57,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Bending stiffness"}]
[{"$nulls":4},{"$f":"E179+E180*E182^2","v":{"v":8951030549438.928,"d":"9.0E+12"}},"Nmm2"]
[]
[null,{"$f":"INDEX(LEN_REPORT[],64,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Composite system effective stiffness"}]
[]
[{"$nulls":4},{"$f":"(1+3.14^2*E175*E143/E142/E119^2)^-1","v":{"v":0.5914239061563866,"d":"0.59"}}]
[]
[{"$nulls":4},{"$f":"(E189*E175*E182)/(E189*E175+K175)","v":{"v":59.07842242013902,"d":"59.08"}},"mm"]
[]
[null,null,"a1 = a - a2",null,{"$f":"E182-E191","v":{"v":110.92157757986098,"d":"110.92"}},"mm"]
[]
[{"$nulls":4},{"$f":"E174+K174+K175*E191^2+E175*E193^2*E189","v":{"v":7313715991151.463,"d":"7.3E+12"}},"Nmm2"]
[]
[null,{"$f":"INDEX(LEN_REPORT[],65,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Composite system efficency"},{"$nulls":5},{"$f":"INDEX(LEN_REPORT[],66,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Connection stiffness"}]
[]
[{"$nulls":4},{"$f":"(E195-E179)/(E185-E179)","v":{"v":0.7334123241732299,"d":"73.3%"}},{"$nulls":3},"Ku",null,{"$f":"$E$142","v":{"v":160125,"d":"1.6E+05"}},"N/mm"]
[]
[]
[]
[null,{"$f":"INDEX(LEN_REPORT[],59,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Elements stiffness at support at ULS  [g] (t = ∞)"}]
[]
[null,{"$f":"INDEX(LEN_REPORT[],27,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"(1) Slab"},{"$nulls":5},{"$f":"INDEX(LEN_REPORT[],30,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"(2) Rib beam"}]
[]
[null,null,"ψ2,t=∞",null,1,{"$nulls":3},"ψ2,t=∞",null,1]
[{"$nulls":4},{"$f":"$C$80/(1+E207*$E$150)","v":6508.875739644971},"MPa",{"$nulls":4},{"$f":"$C$102/(1+$E$150*E207)","v":6804.7337278106515},"MPa"]
[]
[null,{"$f":"INDEX(LEN_REPORT[],57,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Bending stiffness"},"E0,meanJeff,s = E1J1",null,{"$f":"E208*E45","v":{"v":167296848359.74155,"d":"1.7E+11"}},"Nmm2",null,{"$f":"INDEX(LEN_REPORT[],57,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Bending stiffness"},"E0,meanJeff,s = E2J2",null,{"$f":"K208*$K$116^3*$K$117/12","v":{"v":1495000000000.0002,"d":"1.5E+12"}},"Nmm2"]
[null,{"$f":"INDEX(LEN_REPORT[],58,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Axial stiffness"},"E0,meanAeff,s = E1A1",null,{"$f":"E208*E46","v":{"v":238995497.6567736,"d":"2.4E+08"}},"N",null,{"$f":"INDEX(LEN_REPORT[],58,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Axial stiffness"},"E0,meanAeff,s = E2A2",null,{"$f":"K208*$K$116*$K$117","v":{"v":265384615.38461542,"d":"2.7E+08"}},"N"]
[]
[null,{"$f":"INDEX(LEN_REPORT[],64,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Composite system effective stiffness"}]
[]
[null,{"$f":"INDEX(LEN_REPORT[],61,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Composite bending stiffness"},null,null,{"$f":"K210+E210","v":{"v":1662296848359.7417,"d":"1.7E+12"}},"Nmm2"]
[null,{"$f":"INDEX(LEN_REPORT[],62,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Composite axial stiffness"},null,null,{"$f":"(K211*E211)/(K211+E211)","v":{"v":125749859.25167307,"d":"1.3E+08"}},"N"]
[]
[null,{"$f":"INDEX(LEN_REPORT[],63,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Distance between centres of mass of (1) and (2)"},null,null,{"$f":"E182","v":{"v":170,"d":"170.0"}},"mm"]
[]
[null,{"$f":"INDEX(LEN_REPORT[],57,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Bending stiffness"}]
[{"$nulls":4},{"$f":"E215+E216*E218^2","v":{"v":5296467780733.094,"d":"5.3E+12"}},"Nmm2"]
[{"$nulls":4},{"$f":"(1+3.14^2*E211*$E$143/E236/$E$119^2)^-1","v":{"v":0.5914239061563866,"d":"0.59"}}]
[]
[{"$nulls":4},{"$f":"(E222*E211*E218)/(E222*E211+K211)","v":{"v":59.07842242013901,"d":"59.1"}},"mm"]
[]
[null,null,"a1 = a - a2",null,{"$f":"E218-E224","v":{"v":110.92157757986098,"d":"110.9"}},"mm"]
[]
[{"$nulls":4},{"$f":"E210+K210+K211*E224^2+E211*E226^2*E222","v":{"v":4327642598314.475,"d":"4.3E+12"}},"Nmm2"]
[]
[null,{"$f":"INDEX(LEN_REPORT[],65,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Composite system efficency"}]
[]
[{"$nulls":4},{"$f":"(E228-E215)/(E221-E215)","v":{"v":0.7334123241732298,"d":"73.3%"}}]
[]
[null,{"$f":"INDEX(LEN_REPORT[],66,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Connection stiffness"}]
[]
[{"$nulls":4},{"$f":"$E$142/(1+$E$150*E207)","v":{"v":94748.52071005918,"d":"9.5E+04"}},"N/mm"]
[]
[]
[null,{"$f":"INDEX(LEN_REPORT[],67,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Elements stiffness at support at ULS [g+q] (t = ∞)"}]
[]
[null,{"$f":"INDEX(LEN_REPORT[],27,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"(1) Slab"},{"$nulls":5},{"$f":"INDEX(LEN_REPORT[],30,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"(2) Rib beam"}]
[]
[null,null,"ψ2,t=∞",null,{"$f":"E52","v":0.3},{"$nulls":3},"ψ2,t=∞",null,{"$f":"E243","v":0.3}]
[{"$nulls":4},{"$f":"$C$80/(1+E243*$E$150)","v":9113.504556752277},"MPa",{"$nulls":4},{"$f":"$C$102/(1+$E$150*K243)","v":9527.754763877381},"MPa"]
[]
[null,{"$f":"INDEX(LEN_REPORT[],57,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Bending stiffness"},"E0,meanJeff,s = E1J1",null,{"$f":"E244*E45","v":234243308805.27188},"Nmm2",null,{"$f":"INDEX(LEN_REPORT[],57,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Bending stiffness"},"E0,meanJeff,s = E2J2",null,{"$f":"K244*$K$116^3*$K$117/12","v":2093247721623.8606},"Nmm2"]
[null,{"$f":"INDEX(LEN_REPORT[],58,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Axial stiffness"},"E0,meanAeff,s = E1A1",null,{"$f":"E244*E46","v":334633298.2932455},"N",null,{"$f":"INDEX(LEN_REPORT[],58,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Axial stiffness"},"E0,meanAeff,s = E2A2",null,{"$f":"K244*$K$116*$K$117","v":371582435.79121786},"N"]
[]
[null,{"$f":"INDEX(LEN_REPORT[],64,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Composite system effective stiffness"}]
[]
[null,{"$f":"INDEX(LEN_REPORT[],61,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Composite bending stiffness"},null,null,{"$f":"K246+E246","v":2327491030429.1323},"Nmm2"]
[null,{"$f":"INDEX(LEN_REPORT[],62,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Composite axial stiffness"},null,null,{"$f":"(K247*E247)/(K247+E247)","v":176070639.71443862},"N"]
[]
[null,{"$f":"INDEX(LEN_REPORT[],63,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Distance between centres of mass of (1) and (2)"},null,null,{"$f":"E182","v":170},"mm"]
[]
[null,{"$f":"INDEX(LEN_REPORT[],57,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Bending stiffness"}]
[{"$nulls":4},{"$f":"#REF!+#REF!*#REF!^2","v":{"$error":"#REF!"}},"Nmm2"]
[{"$nulls":4},{"$f":"(1+3.14^2*#REF!*$E$143/#REF!/$E$119^2)^-1","v":{"$error":"#REF!"}}]
[]
[{"$nulls":4},{"$f":"(E258*#REF!*#REF!)/(E258*#REF!+#REF!)","v":{"$error":"#REF!"}},"mm"]
[]
[null,null,"a1 = a - a2",null,{"$f":"#REF!-E260","v":{"$error":"#REF!"}},"mm"]
[]
[{"$nulls":4},{"$f":"#REF!+#REF!+#REF!*E260^2+#REF!*E262^2*E258","v":{"$error":"#REF!"}},"Nmm2"]
[]
[null,{"$f":"INDEX(LEN_REPORT[],65,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Composite system efficency"}]
[]
[{"$nulls":4},{"$f":"(E264-#REF!)/(E257-#REF!)","v":{"$error":"#REF!"}}]
[]
[null,{"$f":"INDEX(LEN_REPORT[],66,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Connection stiffness"}]
[]
[{"$nulls":4},{"$f":"$E$142/(1+$E$150*E243)","v":{"v":132663.62883181442,"d":"1.3E+05"}},"N/mm"]
[]
[]
[]
[]
[null,"CALCOLO RIGIDEZZE SISTEMA"]
[]
[null,"Rigidezza elemento 1:"]
[]
[null,null,"flessionale",null,"E1J1","=",null,"Nmm2"]
[]
[null,null,"assiale",null,"E1A1","=",null,"N"]
[]
[null,"Rigidezza elemento 2:"]
[]
[null,null,"flessionale",null,"E2J2","=",null,"Nmm2"]
[]
[null,null,"assiale",null,"E2A2","=",null,"N"]
[]
[]
[null,"Rigidezze sistema composto a t =  ∞"]
[]
[null,null,"flessionale",null,"(EJ0)t=∞","=",null,"Nmm2"]
[]
[]
[null,null,"assiale",null,"(EA0)t=∞","=",null,"N"]
[]
[null,"Distanza fra baricentro trave e baricentro soletta:"]
[]
[{"$nulls":4},"a","=",null,"mm"]
[]
[null,"Rigidezze sistema composto t = ∞"]
[]
[]
[null,"flessionale",{"$nulls":3},"=",{"$f":"E251+E252*E254^2","v":7415932518176.408},"Nmm2"]
[]
[]
[null,"Rigidezze efficace sistema composto"]
[]
[null,"Parametri"]
[{"$nulls":4},"γ1","=",{"$f":"(1+3.14^2*E247*$E$143/E272/$E$119^2)^-1","v":0.5914239061563866}]
[]
[]
[{"$nulls":5},"=",{"$f":"(G312*E247*E254)/(G312*E247+K247)","v":59.07842242013901},"mm"]
[]
[]
[{"$nulls":5},"=",{"$f":"E254-G315","v":110.92157757986098},"mm"]
[]
[{"$nulls":4},"(EJeff)t=∞","=",{"$f":"E246+K246+K247*G315^2+E247*G318^2*G312","v":6059416728377.35},"Nmm2"]
[]
[]
[]
[null,"Efficienza sistema composto"]
[]
[{"$nulls":5},"=",{"$f":"(G320-E251)/(G306-E251)","v":0.73341232417323}]
[]
[]
[]
[]
[null,"VERIFICHE SLU  t = 0 (G+Q)"]
[]
[null,"ELEMENTO 1"]
[]
[null,"Sforzo normale agente sull'elemento 1"]
[]
[]
[{"$nulls":5},"=",{"$f":"E189*E175*E193/E195*K167*10^3","v":83.14496127384268},"kN"]
[]
[]
[null,"Momento agente sull'elemento 1"]
[]
[]
[{"$nulls":5},"=",{"$f":"E174/E195*K167","v":0.8871949525941579},"kNm"]
[]
[]
[]
[]
[null,"Tensioni massime da sforzo normale e momento"]
[]
[]
[{"$nulls":5},"=",{"$f":"G338*10^3/E46","v":2.2643950476683683},"MPa"]
[]
[]
[{"$nulls":5},"=",{"$f":"10^6*G344*E116/2/E45","v":1.3806934822485752},"MPa"]
[]
[]
[]
[null,"VERIFICA TENSIONALE"]
[]
[null,"Verifica presso flessione"]
[]
[{"$nulls":4},{"$f":"G352/I75+G355/I72","v":0.25837067296397853},{"$f":"IF(E363<=G363,\"≤\",\">\")","v":"≤"},1,{"$f":"IF(E363<G363,\"Verifica soddisfatta\",\"Verifica non soddisfatta\")","v":"Verifica soddisfatta"}]
[]
[]
[]
[null,"Verifica sforzi di taglio"]
[]
[]
[]
[{"$nulls":5},"=",{"$f":"'Relazione di Calcolo AT SUPPORT'!G512","v":0.3118309353684038},"MPa"]
[{"$nulls":10},"fvd"]
[]
[]
[]
[]
[null,null,{"$f":"G371","v":0.3118309353684038},{"$f":"IF(C377<=E377,\"≤\",\">\")","v":"≤"},{"$f":"I77","v":1.7152},{"$f":"IF(C377<E377,\"Verifica soddisfatta\",\"Verifica non soddisfatta\")","v":"Verifica soddisfatta"}]
[null,"Verifica rolling shear"]
[]
[]
[]
[{"$nulls":5},"=",{"$f":"'Relazione di Calcolo AT SUPPORT'!G524","v":0.15591546768420192},"MPa"]
[{"$nulls":10},"fvd"]
[]
[]
[]
[]
[]
[null,null,{"$f":"G382","v":0.15591546768420192},{"$f":"IF(C389<=E389,\"≤\",\">\")","v":"≤"},{"$f":"I78","v":0.768},{"$f":"IF(C389<E389,\"Verifica soddisfatta\",\"Verifica non soddisfatta\")","v":"Verifica soddisfatta"}]
[]
[]
[]
[]
["ELEMENTO 2"]
[]
["Sforzo normale agente sull'elemento 2"]
[]
[{"$nulls":5},"=",{"$f":"1*K175*E191/E195*K167*10^3","v":83.1449612738427},"kN"]
[]
[]
[null,"Momento agente sull'elemento 2"]
[]
[]
[{"$nulls":5},"=",{"$f":"K174/E195*K167","v":7.928161630852585},"kNm"]
[]
[]
[null,"Tensioni massime da sforzo normale e momento"]
[]
[]
[{"$nulls":5},"=",{"$f":"G398*1000/K116/K117","v":2.1319220839446844},"MPa"]
[]
[]
[{"$nulls":5},"=",{"$f":"G404*10^6*6/K117/K116^2","v":4.691219899912772},"MPa"]
[]
[]
[null,"VERIFICA TENSIONALE"]
[]
[null,"Verifica tensoflessione"]
[]
[{"$nulls":4},{"$f":"G410/I95+G413/I94","v":0.4789142255757569},{"$f":"IF(E420<=G420,\"≤\",\">\")","v":"≤"},1,{"$f":"IF(E420<G420,\"Verifica soddisfatta\",\"Verifica non soddisfatta\")","v":"Verifica soddisfatta"}]
[]
[]
[]
[null,"Verifica sforzi di taglio"]
[]
[]
[]
[{"$nulls":5},"=",{"$f":"'Relazione di Calcolo AT SUPPORT'!G570","v":0.45366941489157575},"MPa"]
[]
[]
[]
[]
[]
[]
[{"$nulls":4},{"$f":"G428","v":0.45366941489157575},{"$f":"IF(E435<=G435,\"≤\",\">\")","v":"≤"},{"$f":"I99","v":1.5008000000000001},{"$f":"IF(E435<G435,\"Verifica soddisfatta\",\"Verifica non soddisfatta\")","v":"Verifica soddisfatta"}]
[null,"CONNESSIONE ALL'APPOGGIO"]
[]
[null,"Forza agente sulla connessione all'appoggio"]
[]
[]
[{"$nulls":5},"=",{"$f":"E189*E175*E193*E143/E195*K168","v":55.4299741825618},"kN"]
[]
[]
[null,"Valore di progetto della connessione"]
[]
[{"$nulls":5},"=",{"$f":"E146/1000","v":90.82831311705705},"kN"]
[]
[]
[null,"Spostamento del connettore "]
[null,"s  ","=",{"$f":"G441*1000/E142","v":0.34616689575370363}]
[]
[]
[]
[null,"VERIFICA DELLA CONNESSIONE"]
[]
[]
[]
[]
[{"$nulls":4},{"$f":"G441","v":55.4299741825618},{"$f":"IF(E459<=G459,\"≤\",\">\")","v":"≤"},{"$f":"G446","v":90.82831311705705},{"$f":"IF(E459<G459,\"Verifica soddisfatta\",\"Verifica non soddisfatta\")","v":"Verifica soddisfatta"}]
[]
[null,"CONNESSIONE IN CAMPATA"]
[]
[null,"Forza agente sulla connessione all'appoggio"]
[]
[]
[{"$nulls":5},"=",{"$f":"G441/2","v":27.7149870912809},"kN"]
[]
[]
[null,"Valore di progetto della connessione"]
[]
[{"$nulls":5},"=",{"$f":"$K$146/1000","v":45.414156558528525},"kN"]
[]
[]
[]
[]
[]
[null,"VERIFICA DELLA CONNESSIONE"]
[]
[]
[]
[]
[{"$nulls":4},{"$f":"G466","v":27.7149870912809},{"$f":"IF(E482<=G482,\"≤\",\">\")","v":"≤"},{"$f":"G471","v":45.414156558528525},{"$f":"IF(E482<G482,\"Verifica soddisfatta\",\"Verifica non soddisfatta\")","v":"Verifica soddisfatta"}]
[]
[]
[]
[null,"VERIFICHE SLU t = ∞ [G]"]
[]
[null,"ELEMENTO 1"]
[]
[null,"Sforzo normale agente sull'elemento 1"]
[]
[]
[{"$nulls":5},"=",{"$f":"$E$222*$E$211*$E$226/$E$228*$E$167*10^6","v":44017.920674387315},"N"]
[]
[]
[null,"Momento agente sull'elemento 1"]
[]
[]
[{"$nulls":5},"=",{"$f":"$E$210/$E$228*$E$167*10^6","v":469691.4454910247},"Nmm"]
[]
[]
[null,"Tensioni massime da sforzo normale e momento"]
[]
[{"$nulls":5},"=",{"$f":"G493/E46","v":1.1987973781773718},"MPa"]
[]
[]
[{"$nulls":5},"=",{"$f":"G499*$E$116/2/E45","v":0.7309553729551279},"MPa"]
[]
[null,"VERIFICA TENSIONALE"]
[]
[null,"Verifica pressoflessione"]
[]
[{"$nulls":4},{"$f":"G504/$J$75+G507/$J$72","v":0.1823792985628084},{"$f":"IF(E513<=G513,\"≤\",\">\")","v":"≤"},1,{"$f":"IF(E513<G513,\"Verifica soddisfatta\",\"Verifica non soddisfatta\")","v":"Verifica soddisfatta"}]
[]
[]
[]
[null,"Verifica sforzi di taglio"]
[]
[]
[]
[{"$nulls":5},"=",{"$f":"IF(E43=3,E208/E228*((EJeff!C14*(E226+E116/2-EJeff!C14/2))+EJeff!C16*(E226+E116/2-EJeff!C16/2))*E168*1000,IF(E43=5,E208/E228*(EJeff!C13*(E226+E116/2-EJeff!C13/2)+EJeff!C15*(E226+E116/2-EJeff!C15/2)+EJeff!C17*(E226+E116/2-EJeff!C17/2))*E168*1000,IF(E43=7,E208/E228*(EJeff!C12*(E226+E116/2-EJeff!C12/2)+EJeff!C14*(E226+E116/2-EJeff!C14/2)+EJeff!C16*(E226+E116/2-EJeff!C16/2)+EJeff!C18*(E226+E116/2-EJeff!C18/2))*E168*1000,\"errore troppi strati\")))","v":0.09935260743253665},"MPa"]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"G521","v":0.09935260743253665},{"$f":"IF(C528<=E528,\"≤\",\">\")","v":"≤"},{"$f":"$J$77","v":1.2864},{"$f":"IF(C528<E528,\"Verifica soddisfatta\",\"Verifica non soddisfatta\")","v":"Verifica soddisfatta"}]
[]
[]
[null,"Verifica rolling shear"]
[]
[]
[]
[{"$nulls":5},"=",{"$f":"IF(E43=\"3 strati\",E208/E228*EJeff!C14*(E226+E116/2-EJeff!C14/2)*E168*1000,IF(E43=\"5 strati\",E208/E228*(EJeff!C13*(E226+E116/2-EJeff!C13/2)+EJeff!C15*(E226+E116/2-EJeff!C15/2))*E168*1000,IF(E43=\"7 strati\",E208/E228*(EJeff!C12*(E226+E116/2-EJeff!C12/2)+EJeff!C14*(E226+E116/2-EJeff!C14/2)+EJeff!C16*(E226+E116/2-EJeff!C16/2))*E168*1000,\"errore troppi strati\")))","v":"errore troppi strati"},"MPa"]
[{"$nulls":10},"fvd"]
[]
[]
[null,null,{"$f":"G535","v":"errore troppi strati"},{"$f":"IF(C539<=E539,\"≤\",\">\")","v":">"},{"$f":"J78","v":0.576},{"$f":"IF(C539<E539,\"Verifica soddisfatta\",\"Verifica non soddisfatta\")","v":"Verifica non soddisfatta"}]
[]
[]
[null,"ELEMENTO 2"]
[]
[null,"Sforzo normale agente sull'elemento 2"]
[]
[]
[{"$nulls":5},"=",{"$f":"1*$K$211*$E$224/$E$228*$E$167*10^3","v":44.01792067438731},"kN"]
[]
[null,"Momento agente sull'elemento 2"]
[]
[]
[{"$nulls":5},"=",{"$f":"$K$210/$E$228*$E$167","v":4.1972620398631335},"KNm"]
[]
[]
[null,"Tensioni massime da sforzo normale e momento"]
[]
[]
[{"$nulls":5},"=",{"$f":"G547*1000/($K$116*$K$117)","v":1.128664632676598},"MPa"]
[]
[]
[{"$nulls":5},"=",{"$f":"10^6*G552*$K$116/(2*$K$117*$K$116^3/12)","v":2.4835870058361738},"MPa"]
[]
[]
[null,"VERIFICA TENSIONALE"]
[]
[null,"Verifica pressoflessione"]
[]
[{"$nulls":4},{"$f":"G558/$J$95+G561/$J$94","v":0.3380571004064168},{"$f":"IF(E568<=G568,\"≤\",\">\")","v":"≤"},1,{"$f":"IF(E568<G568,\"Verifica soddisfatta\",\"Verifica non soddisfatta\")","v":"Verifica soddisfatta"}]
[]
[]
[]
[]
[null,"Verifica sforzi di taglio"]
[]
[]
[]
[{"$nulls":5},"=",{"$f":"'Relazione di Calcolo AT SUPPORT'!G706","v":0.24017792553083414},"MPa"]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"G577","v":0.24017792553083414},{"$f":"IF(C584<=E584,\"≤\",\">\")","v":"≤"},{"$f":"$J$99","v":1.1256000000000002},{"$f":"IF(C584<E584,\"Verifica soddisfatta\",\"Verifica non soddisfatta\")","v":"Verifica soddisfatta"}]
[]
[null,"CONNESSIONE"]
[]
[null,"Forza agente sulla connessione"]
[]
[]
[{"$nulls":5},"=",{"$f":"$E$211*$E$222*$E$226*$E$143*$E$168/$E$228","v":29.34528044959154},"kN"]
[]
[]
[]
[null,"Valore di progetto della connessione"]
[]
[{"$nulls":5},"=",{"$f":"$E$145/1000","v":68.12123483779278},"kN"]
[]
[]
[null,"Spostamento del connettore "]
[null,"s  ","=",{"$f":"G591*1000/E236","v":0.30971755790669603}]
[]
[]
[]
[null,"VERIFICA DELLA CONNESSIONE"]
[]
[]
[]
[]
[{"$nulls":4},{"$f":"G591","v":29.34528044959154},{"$f":"IF(E610<=G610,\"≤\",\">\")","v":"≤"},{"$f":"G597","v":68.12123483779278},{"$f":"IF(E610<=G610,\"Verifica soddisfatta\",\"Verifica non soddisfatta\")","v":"Verifica soddisfatta"}]
[null,"CONNESSIONE IN CAMPATA"]
[]
[null,"Forza agente sulla connessione all'appoggio"]
[]
[]
[{"$nulls":5},"=",{"$f":"G591/2","v":14.67264022479577},"kN"]
[]
[]
[null,"Valore di progetto della connessione"]
[]
[{"$nulls":5},"=",{"$f":"K145/1000","v":34.06061741889639},"kN"]
[]
[null,"VERIFICA DELLA CONNESSIONE"]
[]
[]
[]
[]
[{"$nulls":4},{"$f":"G616","v":14.67264022479577},{"$f":"IF(E628<=G628,\"≤\",\">\")","v":"≤"},{"$f":"G621","v":34.06061741889639},{"$f":"IF(E628<G628,\"Verifica soddisfatta\",\"Verifica non soddisfatta\")","v":"Verifica soddisfatta"}]
[]
[]
[]
[null,"VERIFICHE SLU t = ∞ [G + Q]"]
[]
[null,"ELEMENTO 1"]
[]
[null,"Sforzo normale agente sull'elemento 1"]
[]
[]
[{"$nulls":5},"=",{"$f":"$G$312*$E$247*$G$318/$G$320*$K$167*10^3","v":83.14496127384271},"kN"]
[]
[]
[null,"Momento agente sull'elemento 1"]
[]
[]
[{"$nulls":5},"=",{"$f":"$E$246/$G$320*$K$167","v":0.8871949525941579},"kNm"]
[]
[]
[null,"Tensioni massime da sforzo normale e momento"]
[]
[]
[{"$nulls":5},"=",{"$f":"G639*1000/E46","v":2.264395047668369},"MPa"]
[]
[]
[{"$nulls":5},"=",{"$f":"G645*E$116/2/E45*10^6","v":1.3806934822485752},"MPa"]
[]
[]
[]
[null,"VERIFICA TENSIONALE"]
[]
[null,"Verifica pressoflessione"]
[]
[{"$nulls":4},{"$f":"G651/$I$75+G654/$I$72","v":0.2583706729639786},{"$f":"IF(E662<=G662,\"≤\",\">\")","v":"≤"},1,{"$f":"IF(E662<G662,\"Verifica soddisfatta\",\"Verifica non soddisfatta\")","v":"Verifica soddisfatta"}]
[]
[]
[]
[null,"Verifica sforzi di taglio"]
[]
[]
[]
[{"$nulls":5},"=",{"$f":"IF(E43=3,E244/G320*(EJeff!C14*(G318+E116/2-EJeff!C14/2)+EJeff!C16*(G318+E116/2-EJeff!C16/2))*K168*1000,IF(E43=5,E244/G320*(EJeff!C13*(G318+E116/2-EJeff!C13/2)+EJeff!C15*(G318+E116/2-EJeff!C15/2)+EJeff!C17*(G318+E116/2-EJeff!C17/2))*K168*1000,IF(E43=7,E244/G320*(EJeff!C12*(G318+E116/2-EJeff!C12/2)+EJeff!C14*(G318+E116/2-EJeff!C14/2)+EJeff!C16*(G318+E116/2-EJeff!C16/2))*K168*1000,\"troppi strati errore\")))","v":0.18766603626145814},"MPa"]
{"$rows_empty":7}
[null,null,{"$f":"G670","v":0.18766603626145814},{"$f":"IF(C678<=E678,\"≤\",\">\")","v":"≤"},{"$f":"$I$77","v":1.7152},{"$f":"IF(C678<E678,\"Verifica soddisfatta\",\"Verifica non soddisfatta\")","v":"Verifica soddisfatta"}]
[]
[]
[null,"Verifica rolling shear"]
[]
[]
[]
[{"$nulls":5},"=",{"$f":"IF(E43=3,E244/G320*EJeff!C14*(G318+E116/2-EJeff!C14/2)*K168*1000,IF(E43=5,E244/G320*(EJeff!C13*(G318+E116/2-EJeff!C13/2)+EJeff!C15*(G318+E116/2-EJeff!C15/2))*K168*1000,IF(E43=7,E244/G320*(EJeff!C12*(G318+E116/2-EJeff!C12/2)+EJeff!C14*(G318+E116/2-EJeff!C14/2)+EJeff!C16*(G318+E116/2-EJeff!C16/2))*K168*1000,\"troppi strati errore\")))","v":0.09383301813072906},"MPa"]
[{"$nulls":10},"fvd"]
[null,null,{"$f":"G685","v":0.09383301813072906},{"$f":"IF(C687<=E687,\"≤\",\">\")","v":"≤"},{"$f":"I78","v":0.768},{"$f":"IF(C687<E687,\"Verifica soddisfatta\",\"Verifica non soddisfatta\")","v":"Verifica soddisfatta"}]
[]
[]
[null,"ELEMENTO 2"]
[]
[null,"Sforzo normale agente sull'elemento 2"]
[]
[]
[{"$nulls":5},"=",{"$f":"1*$K$247*$E$224/$G$320*$K$167*10^3","v":83.14496127384271},"kN"]
[]
[]
[]
[]
[]
[null,"Momento agente sull'elemento 2"]
[]
[]
[{"$nulls":5},"=",{"$f":"$K$246/$G$320*$K$167","v":7.928161630852586},"KNm"]
[]
[]
[null,"Tensioni massime da sforzo normale e momento"]
[]
[]
[{"$nulls":5},"=",{"$f":"G695*1000/($K$116*$K$117)","v":2.131922083944685},"MPa"]
[]
[]
[{"$nulls":5},"=",{"$f":"10^6*G704*$K$116/(2*$K$117*$K$116^3/12)","v":4.691219899912773},"MPa"]
[]
[]
[null,"VERIFICA TENSIONALE"]
[]
[null,"Verifica pressoflessione"]
[]
[{"$nulls":4},{"$f":"G710/$I$95+G713/$I$94","v":0.478914225575757},{"$f":"IF(E720<=G720,\"≤\",\">\")","v":"≤"},1,{"$f":"IF(E720<G720,\"Verifica soddisfatta\",\"Verifica non soddisfatta\")","v":"Verifica soddisfatta"}]
[]
[]
[]
[null,"Verifica sforzi di taglio"]
[]
[]
[]
[{"$nulls":5},"=",{"$f":"'Relazione di Calcolo AT SUPPORT'!G834","v":0.4536694148915757},"MPa"]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"G728","v":0.4536694148915757},{"$f":"IF(C735<=E735,\"≤\",\">\")","v":"≤"},{"$f":"$I$99","v":1.5008000000000001},{"$f":"IF(C735<E735,\"Verifica soddisfatta\",\"Verifica non soddisfatta\")","v":"Verifica soddisfatta"}]
[]
[null,"CONNESSIONE ALL'APPOGGIO"]
[]
[null,"Forza agente sulla connessione"]
[]
[]
[{"$nulls":5},"=",{"$f":"$E$247*$G$312*$G$318*$E$143*$K$168/$G$320","v":55.42997418256181},"kN"]
[]
[]
[null,"Valore di progetto della connessione"]
[]
[{"$nulls":5},"=",{"$f":"E146/1000","v":90.82831311705705},"kN"]
[]
[]
[null,"VERIFICA DELLA CONNESSIONE"]
[]
[]
[]
[{"$nulls":4},{"$f":"G742","v":55.42997418256181},{"$f":"IF(E754<=G754,\"≤\",\">\")","v":"≤"},{"$f":"G747","v":90.82831311705705},{"$f":"IF(E754<=G754,\"Verifica soddisfatta\",\"Verifica non soddisfatta\")","v":"Verifica soddisfatta"}]
[]
[null,"Spostamento del connettore "]
[null,"s  ","=",{"$f":"G742*1000/E272","v":0.41782344317472037}]
[]
[null,"CONNESSIONE IN CAMPATA"]
[]
[null,"Forza agente sulla connessione all'appoggio"]
[]
[]
[{"$nulls":5},"=",{"$f":"G742/2","v":27.714987091280904},"kN"]
[]
[]
[null,"Valore di progetto della connessione"]
[]
[{"$nulls":5},"=",{"$f":"$K$146/1000","v":45.414156558528525},"kN"]
[]
[null,"VERIFICA DELLA CONNESSIONE"]
[]
[]
[]
[]
[{"$nulls":4},{"$f":"G764","v":27.714987091280904},{"$f":"IF(E776<=G776,\"≤\",\">\")","v":"≤"},{"$f":"G769","v":45.414156558528525},{"$f":"IF(E776<G776,\"Verifica soddisfatta\",\"Verifica non soddisfatta\")","v":"Verifica soddisfatta"}]
[]
[null,"CALCOLO RIGIDEZZE SLE  t = 0"]
[]
[null,"Rigidezza elemento 1"]
[]
[]
[null,"flessionale:",null,null,"E1J1","=",{"$f":"E174","v":282731673727.9632},"Nmm2"]
[]
[null,"assiale:",null,null,"E1A1","=",{"$f":"E175","v":403902391.03994733},"N"]
[]
[null,"Rigidezza elemento 2"]
[]
[]
[null,"flessionale:",null,null,"E2J2","=",{"$f":"K174","v":2526550000000},"Nmm2"]
[]
[null,"assiale:",null,null,"E2A2","=",{"$f":"K175","v":448500000},"N"]
[]
[null,"Rigidezze sistema composto a t=0"]
[]
[null,"flessionale:",null,null,"(EJ0)t=0","=",{"$f":"G790+G783","v":2809281673727.9634},"Nmm2"]
[]
[]
[null,"assiale:",null,null,"(EA0)t=0","=",{"$f":"(G792*G785)/(G792+G785)","v":212517262.13532746},"N"]
[]
[null,"Distanza fra baricentro trave e baricentro soletta:"]
[]
[{"$nulls":4},"a","=",{"$f":"E182","v":170},"mm"]
[]
[null,"Rigidezze sistema composto t=0"]
[]
[null,"flessionale:",{"$nulls":3},"=",{"$f":"G796+G799*G803^2","v":8951030549438.928},"Nmm2"]
[]
[null,"Rigidezze efficace sistema composto"]
[]
[null,"Parametri"]
[]
[]
[{"$nulls":5},"=",{"$f":"1/(1+((3.14^2)*G785*'Calculation Report'!E143)/('Calculation Report'!E141*'Calculation Report'!E119^2))","v":0.684670583710393}]
[]
[]
[]
[{"$nulls":5},"=",{"$f":"(G814*G785*G803)/(G814*G785+G792)","v":64.84029712349566},"mm"]
[]
[]
[{"$nulls":5},"=",{"$f":"G803-G818","v":105.15970287650434},"mm"]
[]
[{"$nulls":4},"(EJeff)t=0","=",{"$f":"G783+G790+G792*G818^2+G785*G821^2*G814","v":7753030127908.89},"Nmm2"]
[null,"Efficienza sistema composto"]
[]
[]
[{"$nulls":5},"=",{"$f":"(G823-G796)/(G807-G796)","v":0.8049414839691961}]
[]
[]
[]
[null,"CALCOLO RIGIDEZZE SLE  t = ∞"]
[]
[null,"Modulo elastico t = ∞ dell'elemento 1"]
[]
[{"$nulls":5},"=",{"$f":"$C$80/(1+$E$150)","v":6508.875739644971},"MPa"]
[]
[]
[null,"Modulo elastico  t = ∞ dell'elemento  2"]
[]
[{"$nulls":5},"=",{"$f":"$C$102/(1+$E$150)","v":6804.7337278106515},"MPa"]
[]
[]
[null,"Rigidezza a t = ∞ della connessione"]
[]
[]
[{"$nulls":5},"=",{"$f":"'Calculation Report'!E141/(1+'Calculation Report'!E150)","v":142122.78106508875},"N/mm"]
[]
[]
[]
[null,"Rigidezza elemento 1"]
[]
[]
[null,"flessionale:",null,null,"E1J1","=",{"$f":"G835*E45","v":167296848359.74155},"Nmm2"]
[]
[]
[null,"assiale:",null,null,"E1A1","=",{"$f":"G835*E46","v":238995497.6567736},"N"]
[]
[]
[null,"Rigidezza elemento 2"]
[]
[]
[null,"flessionale:",null,null,"E2J2","=",{"$f":"G840*K117*K116^3/12","v":1495000000000},"Nmm2"]
[]
[]
[null,"assiale:",null,null,"E2A2","=",{"$f":"G840*K116*K117","v":265384615.38461542},"N"]
[]
[null,"Rigidezze globale a t=∞"]
[]
[null,"flessionale:",null,null,"(EJ0)t=∞","=",{"$f":"G862+G853","v":1662296848359.7415},"Nmm2"]
[]
[]
[null,"assiale:",null,null,"(EA0)t=∞","=",{"$f":"(G865*G856)/(G865+G856)","v":125749859.25167307},"N"]
[]
[]
[null,"Distanza fra baricentro trave e baricentro soletta:"]
[]
[{"$nulls":4},"a","=",{"$f":"G803","v":170},"mm"]
[]
[null,"Rigidezze sistema composto t=∞"]
[]
[null,"flessionale:",{"$nulls":3},"=",{"$f":"G869+G872*G877^2","v":5296467780733.093},"Nmm2"]
[]
[null,"Rigidezze efficace sistema composto"]
[]
[null,"Parametri"]
[]
[]
[{"$nulls":5},"=",{"$f":"1/(1+((3.14^2)*G856*E143)/(G846*E119^2))","v":0.684670583710393}]
[]
[]
[]
[{"$nulls":5},"=",{"$f":"(G888*G856*G877)/(G888*G856+G865)","v":64.84029712349566},"mm"]
[]
[]
[{"$nulls":5},"=",{"$f":"G877-G892","v":105.15970287650434},"mm"]
[]
[]
[{"$nulls":4},"(EJeff)t=∞","=",{"$f":"G853+G862+G865*G892^2+G856*G895^2*G888","v":4587591791662.065},"Nmm^2"]
[]
[null,"Efficienza sistema composto"]
[]
[]
[{"$nulls":5},"=",{"$f":"(G898-G869)/(G881-G869)","v":0.8049414839691965}]
[]
[]
[]
[]
[]
[null,"CALCOLO E VERIFICA FRECCIA"]
[]
[null,"Calcolo freccia a t = 0"]
[]
[]
[]
[]
[null,"freccia per carichi permanenti"]
[{"$nulls":4},"ug,ist","=",{"$f":"5/384*1.1*'Calculation Report'!E157*'Calculation Report'!$E$119^4/'Calculation Report'!G823","v":4.788450371985486},"mm"]
[]
[null,"freccia per carichi variabili"]
[{"$nulls":4},"uq,ist","=",{"$f":"5/384*1.1*'Calculation Report'!E158*'Calculation Report'!$E$119^4/'Calculation Report'!G823","v":3.830760297588389},"mm"]
[]
[null,"Verifica della freccia istantanea per carichi variabili"]
[]
[null,"ulim","=","L/",{"$f":"Output!E53","v":300}]
[]
[null,"uist",null,"ulim"]
[null,{"$f":"G920+G917","v":8.619210669573874},{"$f":"IF(B927<=D927,\"≤\",\">\")","v":"≤"},{"$f":"Output!J55","v":20},null,{"$f":"IF(B927<=D927,\"Verifica soddisfatta\",\"Verifica non soddisfatta\")","v":"Verifica soddisfatta"}]
[]
[null,"Calcolo freccia a t = ∞"]
[]
[null,"freccia per carichi permanenti"]
[]
[{"$nulls":4},"ug,fin","=",{"$f":"5/384*1.1*'Calculation Report'!E157*'Calculation Report'!$E$119^4/'Calculation Report'!G898","v":8.09248112865547},"mm"]
[]
[]
[]
[null,"freccia per carichi variabili"]
[]
[{"$nulls":4},"uq,fin","=",{"$f":"5/384*1.1*'Calculation Report'!E158*'Calculation Report'!$E$119^4/'Calculation Report'!G898","v":6.473984902924377},"mm"]
[null,"freccia totale"]
[]
[{"$nulls":5},"=",{"$f":"G933+G939*E52","v":10.034676599532784},"mm"]
[]
[null,"Verifica della freccia finale"]
[]
[null,"ulim","=","L/",{"$f":"Output!E61","v":200}]
[]
[null,"uifin",null,"ulim"]
[null,{"$f":"G942","v":10.034676599532784},{"$f":"IF(B949<=D949,\"≤\",\">\")","v":"≤"},{"$f":"Output!J63","v":30},null,{"$f":"IF(B949<=D949,\"Verifica soddisfatta\",\"Verifica non soddisfatta\")","v":"Verifica soddisfatta"}]
{"$rows_empty":8}
[null,"VERIFICA A VIBRAZIONE"]
[]
[]
[null,"Massa per unità di area"]
[{"$nulls":4},"m","=",{"$f":"Input!$E$14*1000/9.81","v":254.841997961264},"kg/m2"]
[]
[null,"Rigidezza trasversale a metro"]
[{"$nulls":4},"EJb","=",{"$f":"Output!D71","v":7333333.333333332},"Nmm2/m"]
[]
[null,"Smorzamento"]
[{"$nulls":4},"ξ","=",{"$f":"Output!E72","v":{"v":0.04,"d":"4%"}},"[%]"]
[]
[]
[null,"Larghezza collaborante",null,null,"bm","=",{"$f":"MAX(Input!$E$33/1000/1.1*('Calculation Report'!$G$965/(G978))^0.25,Input!$E$30/1000)","v":0.8},"m"]
[]
[]
[null,"Frequenza fondamentale"]
[{"$nulls":4},"f1","=",{"$f":"3.14/2/(Input!$E$33/1000)^2*SQRT('Calculation Report'!G823*10^-6/'Calculation Report'!$G$962)","v":7.606719237126268},"Hz"]
[]
[null,"Rigidezza longitudinale a metro"]
[{"$nulls":4},"EJl","=",{"$f":"G823/(Input!$E$30/1000)","v":9691287659886.111},"Nmm2/m"]
[]
[null,"Verifica di freccia (1 kN)"]
[]
[null,"freccia in mezzeria",null,null,"w","=",{"$f":"1/48*1000*Input!$E$33^3/'Calculation Report'!G978/'Calculation Report'!G971","v":0.5804182269073316},"mm"]
[]
[null,"freccia limite",null,null,"wlim","=",{"$f":"Output!J75","v":1},"mm"]
[]
[{"$nulls":4},{"$f":"IF(G982<=G984,\"Verifica soddisfatta\",\"Verifica non soddisfatta\")","v":"Verifica soddisfatta"}]
[]
[null,"Verifica risposta impulsiva"]
[]
[null,"numero di modi < 40 Hz",null,null,"n40","=",{"$f":"ROUNDDOWN(6.3*SQRT(1/G975),0)","v":2}]
[]
[null,"velocità a risposta impulsiva",null,null,"v","=",{"$f":"+(0.4+0.6*G990)/($G$962*G971*Input!$E$33/1000/2+50)","v":0.00241830367460134},"m/s"]
[]
[null,"smorzamento ",null,null,"ξ","=",{"$f":"G968","v":0.04},"%"]
[]
[null,"velocità limite",null,null,"vlim","=",{"$f":"120^(G975*G994/100-1)","v":0.008455612130883089},"m/s"]
[]
[{"$nulls":4},{"$f":"IF(G992<=G996,\"Verifica soddisfatta\",\"Verifica non soddisfatta\")","v":"Verifica soddisfatta"}]
[]
[null,"Verifica accelerazione"]
[]
[]
[null,"accelerazione massima",null,null,"a","=",{"$f":"16.8/($G$962*G971*Input!$E$33/1000)*1/($G$968/100)","v":34.335},"m/s2"]
[]
[]
[{"$nulls":4},{"$f":"IF(G1003<=0.1,\"Vibrazioni non percepibili\",IF(G1003<0.35,\"Vibrazioni percepibili non fastidiose\",\"Vibrazioni non accettabili\"))","v":"Vibrazioni non accettabili"}]

{"sheet":"Relazione di Calcolo AT SUPPORT","index":6,"n_rows":991,"n_cols":15,"rows_kept":991,"hidden":true,"merged":[[0,0,0,8],[4,3,4,6],[6,3,6,6],[8,3,8,6],[38,1,39,7],[46,2,46,6],[48,2,48,6],[49,2,49,6],[50,2,50,6],[52,2,52,6],[61,1,71,8],[72,1,77,8],[88,1,98,8],[103,1,103,7],[104,1,104,3],[105,3,105,4],[105,5,105,7],[106,3,106,4],[106,5,106,7],[120,1,120,7],[131,1,131,7],[140,1,140,7],[143,1,143,8],[144,1,144,8],[146,1,146,3],[146,5,146,7],[147,5,147,6],[147,7,147,8],[153,1,153,3],[158,1,158,3],[163,1,163,7],[167,1,167,8],[168,1,168,8],[170,1,170,3],[170,5,170,8],[171,5,171,6],[171,7,171,8],[177,1,177,3],[182,1,182,3],[185,1,185,7],[198,1,198,7],[205,1,205,3],[208,1,208,3],[214,1,214,7],[227,1,227,7],[228,1,228,6],[232,1,232,6],[234,1,234,6],[237,1,237,4],[241,1,241,4],[246,1,246,7],[312,1,312,7],[320,1,320,4],[339,1,339,5],[391,1,391,7],[399,1,399,4],[417,1,417,5],[471,1,471,7],[473,1,473,6],[499,1,499,6],[535,0,535,5],[557,1,557,6],[577,1,577,6],[595,1,595,6],[604,1,604,7],[606,1,606,6],[627,1,627,6],[670,1,670,6],[692,1,692,6],[714,1,714,6],[733,1,733,6],[740,1,740,7],[742,1,742,6],[766,1,766,6],[798,1,798,6],[821,1,821,6],[842,1,842,6],[855,1,855,6],[865,1,865,7],[918,1,918,7]]}
[]
[{"$nulls":7},"Rev27/18"]
[]
[]
[null,null,"Comune di:",{"$f":"IF(Input!#REF!=\"\",\"\",Input!#REF!)","v":{"$error":"#REF!"}}]
[]
[null,null,"Provincia di: ",{"$f":"IF(Input!#REF!=\"\",\"\",Input!#REF!)","v":{"$error":"#REF!"}}]
[]
[null,null,"Progettato da:",{"$f":"IF(Input!#REF!=\"\",\"\",Input!#REF!)","v":{"$error":"#REF!"}}]
{"$rows_empty":29}
[null,"STRUTTURA COMPOSTA LEGNO-LEGNO"]
{"$rows_empty":7}
[null,"Committente:",{"$f":"IF(Input!#REF!=\"\",\"\",Input!#REF!)","v":{"$error":"#REF!"}}]
[]
[null,"Data:",{"$f":"IF(Input!#REF!=\"\",\"\",Input!#REF!)","v":{"$error":"#REF!"}}]
[]
[null,"Progettista:",{"$f":"IF(Input!#REF!=\"\",\"\",Input!#REF!)","v":{"$error":"#REF!"}}]
[]
[null,"Normativa:",{"$f":"Input!#REF!","v":{"$error":"#REF!"}}]
{"$rows_empty":8}
[null,"Le verifiche sono effettuate in accordo con il D.M.  Infrastrutture  17/1/2008 e la C.M. 2/2/2009  n. 617 del C.S.LL.PP, integrate ove necessario con la UNI-EN 1995-1-1/2014. Le proprietà dei materiali fanno riferimento alle seguenti normative: UNI-EN 338:2016, UNI-EN 14080:2013."]
{"$rows_empty":10}
[null,"Per le caratteristiche dei connettori, si è fatto riferimento alle seguenti normative di prodotto:                                                                                                                             -  European Technical Approval ETA-11/0030                                                                      "]
{"$rows_empty":15}
[null,"E' compito del progettista verificare la correttezza dei risultati forniti dal presente foglio di calcolo. "]
{"$rows_empty":14}
[null,"DEFINIZIONE PANNELLO CLT VICINO AL SUPPORTO"]
[null,{"$f":"Input!C28","v":"80mm-3-   30 20 30   "},{"$nulls":3},{"$f":"COUNTIF(EJeff!C10:C20,\">0\")&\" strati\"","v":"3 strati"}]
[{"$nulls":3},"Jeff(mm4) =",null,{"$f":"MAX(J_Support[#Totals])","v":8820000}]
[{"$nulls":3},"Aeff(mm2) =",null,{"$f":"MAX(A_Support[#Totals])","v":12600}]
[]
[{"$nulls":3},"VALUTAZIONE CON EUROCODICE 5 en 1995 1-1/2025"]
{"$rows_empty":11}
[null,"CARICHI AGENTI SULLA SUPERFICIE SOLAIO (kN/m2)"]
[]
[null,"CARICHI PERMANENTI ",{"$nulls":3},"G1k+G2k","=",{"$f":"Input!$E$14","v":{"v":2.5,"d":"2.50"}},"kN/m2"]
[]
[null,"CARICHI ACCIDENTALI   ",{"$nulls":3},"Qk","=",{"$f":"Input!$E$15","v":{"v":2,"d":"2.00"}},"kN/m2"]
[{"$nulls":5},"Ψ2,i","=",{"$f":"Input!$E$16","v":0.3},"kN/m2"]
[]
[null,"Durata del carico",null,{"$f":"LOOKUP(M139,Dati!$B$78:$B$82,Dati!$A$78:$A$82)","v":"Long term"}]
[null,"Classe di servizio",null,{"$f":"Input!$I$15","v":1}]
[]
[]
[null,"CARICHI AGENTI SU TRAVE COMPOSTA (kN/m)"]
[]
[null,"Interasse travetti/larghezza d'influenza",{"$nulls":3},"i","=",{"$f":"Input!E30/1000","v":{"v":0.8,"d":"0.80"}},"m"]
[]
[null,"CARICHI PERMANENTI ",{"$nulls":3},"g1k+g2k","=",{"$f":"H123*H134","v":{"v":2,"d":"2.00"}}]
[{"$nulls":11},"tipo legno",18]
[null,"CARICHI ACCIDENTALI ",{"$nulls":3},"qk","=",{"$f":"H125*H134","v":{"v":1.6,"d":"1.60"}},{"$nulls":3},"Classe",1,null,"perm. durata"]
[{"$nulls":11},"Durata",3,null,1]
[]
[null,"MATERIALE LEGNO ELEMENTO 1"]
[]
[null,"Tipo Legno",null,{"$f":"Input!$C$22","v":"C24 - EN338:2016"}]
[]
[null,"Caratteristiche meccaniche"]
[]
[null,"Caratteristiche (MPa)",{"$nulls":3},"Progetto (MPa)"]
[null,"flessione","fm,k",{"$f":"INDEX(TimberType[],MATCH(Input!$C$22,TimberType[Classe],0),MATCH(C148,TimberType[#Headers],0))","v":{"v":24,"d":"24.0"}},null,"[G+Q]",null,"[G]"]
[null,"trazione parallela","ft,0,k",{"$f":"INDEX(TimberType[],MATCH(Input!$C$22,TimberType[Classe],0),MATCH(C149,TimberType[#Headers],0))","v":14.5},null,"fm,d",{"$f":"D148*(I156)/$G$224","v":{"v":13.439999999999998,"d":"13.4"}},"fm,d",{"$f":"D148*I157/$G$224","v":{"v":11.52,"d":"11.5"}}]
[null,"trazione perpendic","ft,90,k",{"$f":"INDEX(TimberType[],MATCH(Input!$C$22,TimberType[Classe],0),MATCH(C150,TimberType[#Headers],0))","v":0.4},null,"ft,0,,d",{"$f":"D149*I156/$G$224","v":{"v":8.12,"d":"8.1"}},"ft,0,,d",{"$f":"D149*I157/$G$224","v":{"v":6.959999999999999,"d":"7.0"}}]
[null,"compress parall","fc,0,k",{"$f":"INDEX(TimberType[],MATCH(Input!$C$22,TimberType[Classe],0),MATCH(C151,TimberType[#Headers],0))","v":{"v":21,"d":"21.0"}},null,"ft,90,d",{"$f":"D150*I156/$G$224","v":{"v":0.22399999999999998,"d":"0.2"}},"ft,90,d",{"$f":"D150*I157/$G$224","v":{"v":0.192,"d":"0.2"}}]
[null,"compres perpe","fc,90,k",{"$f":"INDEX(TimberType[],MATCH(Input!$C$22,TimberType[Classe],0),MATCH(C152,TimberType[#Headers],0))","v":2.5},null,"fc,0,d",{"$f":"D151*I156/$G$224","v":{"v":11.76,"d":"11.8"}},"fc,0,d",{"$f":"D151*I157/$G$224","v":{"v":10.08,"d":"10.1"}}]
[null,"taglio","fv,k",{"$f":"INDEX(TimberType[],MATCH(Input!$C$22,TimberType[Classe],0),MATCH(C153,TimberType[#Headers],0))","v":{"v":4,"d":"4.0"}},null,"fc,90,d",{"$f":"D152*I156/$G$224","v":1.4},"fc,90,d",{"$f":"D152*I157/$G$224","v":1.2}]
[null,"Modulo elastico (MPa)",{"$nulls":3},"fv,d",{"$f":"D153*I156/$G$224*I158","v":{"v":1.5008,"d":"1.5"}},"fv,d",{"$f":"D153*I157/$G$224*I158","v":{"v":1.2864,"d":"1.3"}}]
[null,"medio parallelo","E0,mean",{"$f":"INDEX(TimberType[],MATCH(Input!$C$22,TimberType[Classe],0),MATCH(C155,TimberType[#Headers],0))","v":11000},null,"frs,d",{"$f":"D161*I156/$G$224","v":{"v":0.6719999999999999,"d":"0.7"}},"frs,d",{"$f":"D161*I157/$G$224","v":{"v":0.576,"d":"0.6"}}]
[null,"caratt parallelo","E0,05",{"$f":"INDEX(TimberType[],MATCH(Input!$C$22,TimberType[Classe],0),MATCH(C156,TimberType[#Headers],0))","v":7400},{"$nulls":3},"kmod [G+Q]",{"$f":"INDEX(kmod[],MATCH(D129,kmod[CS],0),MATCH(D128,kmod[#Headers],0))","v":{"v":0.7,"d":"0.70"}}]
[null,"mod taglio medio","Gmean",{"$f":"INDEX(TimberType[],MATCH(Input!$C$22,TimberType[Classe],0),MATCH(C157,TimberType[#Headers],0))","v":690},{"$nulls":3}," kmod [G]",{"$f":"INDEX(kmod[],MATCH(D129,kmod[CS],0),2)","v":{"v":0.6,"d":"0.60"}}]
[null,"mod taglio caratt","G05",{"$f":"INDEX(TimberType[],MATCH(Input!$C$22,TimberType[Classe],0),MATCH(C158,TimberType[#Headers],0))","v":0},{"$nulls":3},"kcrack",0.67]
[null,"Massa volumica (kg/m3)"]
[null,"caratteristica","ρk",{"$f":"INDEX(TimberType[],MATCH(Input!$C$22,TimberType[Classe],0),MATCH(C160,TimberType[#Headers],0))","v":350}]
[null,"rolling shear","frs,k",{"$f":"Input!$E$31","v":1.2}]
[]
[]
[null,"MATERIALE LEGNO ELEMENTO 2"]
[]
[]
[null,"Tipo Legno",null,{"$f":"Input!$I$22","v":"GL24h - UNI EN14080:2013"}]
[]
[null,"Caratteristiche meccaniche"]
[]
[null,"Caratteristiche (MPa)",{"$nulls":3},"Progetto (MPa)"]
[null,"flessione","fm,k",{"$f":"INDEX(TimberType[],MATCH(Input!$I$22,TimberType[Classe],0),MATCH(C172,TimberType[#Headers],0))","v":{"v":24,"d":"24.0"}},null,"[G+Q]",null,"[G]"]
[null,"trazione parallela","ft,0,k",{"$f":"INDEX(TimberType[],MATCH(Input!$I$22,TimberType[Classe],0),MATCH(C173,TimberType[#Headers],0))","v":19.2},null,"fm,d",{"$f":"D172*I180/$G$225","v":{"v":13.439999999999998,"d":"13.4"}},"fm,d",{"$f":"D172*I181/$G$224","v":{"v":11.52,"d":"11.5"}}]
[null,"trazione perpendic","ft,90,k",{"$f":"INDEX(TimberType[],MATCH(Input!$I$22,TimberType[Classe],0),MATCH(C174,TimberType[#Headers],0))","v":0.5},null,"ft,0,,d",{"$f":"D173*I180/$G$225","v":{"v":10.751999999999999,"d":"10.8"}},"ft,0,,d",{"$f":"D173*I181/$G$224","v":{"v":9.216,"d":"9.2"}}]
[null,"compress parall","fc,0,k",{"$f":"INDEX(TimberType[],MATCH(Input!$I$22,TimberType[Classe],0),MATCH(C175,TimberType[#Headers],0))","v":{"v":24,"d":"24.0"}},null,"ft,90,d",{"$f":"D174*I180/$G$225","v":{"v":0.27999999999999997,"d":"0.3"}},"ft,90,d",{"$f":"D174*I181/$G$224","v":{"v":0.24,"d":"0.2"}},null,null,"tipo legno",3]
[null,"compres perpe","fc,90,k",{"$f":"INDEX(TimberType[],MATCH(Input!$I$22,TimberType[Classe],0),MATCH(C176,TimberType[#Headers],0))","v":2.5},null,"fc,0,d",{"$f":"D175*I180/$G$225","v":{"v":13.439999999999998,"d":"13.4"}},"fc,0,d",{"$f":"D175*I181/$G$224","v":{"v":11.52,"d":"11.5"}},null,null,"Classe",{"$f":"M138","v":1},null,"perm. durata"]
[null,"taglio","fv,k",{"$f":"INDEX(TimberType[],MATCH(Input!$I$22,TimberType[Classe],0),MATCH(C177,TimberType[#Headers],0))","v":3.5},null,"fc,90,d",{"$f":"D176*I180/$G$225","v":1.4},"fc,90,d",{"$f":"D176*I181/$G$224","v":1.2},null,null,"Durata",{"$f":"M139","v":3},null,1]
[null,"Modulo elastico (MPa)",{"$nulls":3},"fv,d",{"$f":"D177*I180/$G$225*I182","v":{"v":1.3132,"d":"1.3"}},"fv,d",{"$f":"D177*I181/$G$224*I182","v":{"v":1.1256000000000002,"d":"1.1"}}]
[null,"medio parallelo","E0,mean",{"$f":"INDEX(TimberType[],MATCH(Input!$I$22,TimberType[Classe],0),MATCH(C179,TimberType[#Headers],0))","v":11500}]
[null,"caratt parallelo","E0,05",{"$f":"INDEX(TimberType[],MATCH(Input!$I$22,TimberType[Classe],0),MATCH(C180,TimberType[#Headers],0))","v":9600},{"$nulls":3},"kmod [G+Q]",{"$f":"INDEX(kmod[],MATCH($D$129,kmod[CS],0),MATCH($D$128,kmod[#Headers],0))","v":{"v":0.7,"d":"0.70"}}]
[null,"mod taglio medio","Gmean",{"$f":"INDEX(TimberType[],MATCH(Input!$I$22,TimberType[Classe],0),MATCH(C181,TimberType[#Headers],0))","v":650},{"$nulls":3}," kmod [G]",{"$f":"INDEX(kmod[],MATCH($D$129,kmod[CS],0),2)","v":{"v":0.6,"d":"0.60"}}]
[null,"mod taglio caratt","G05",{"$f":"INDEX(TimberType[],MATCH(Input!$I$22,TimberType[Classe],0),MATCH(C182,TimberType[#Headers],0))","v":540},{"$nulls":3},"kcrack",0.67]
[null,"Massa volumica (kg/m3)"]
[null,"caratteristica","ρk",{"$f":"INDEX(TimberType[],MATCH(Input!$I$22,TimberType[Classe],0),MATCH(C184,TimberType[#Headers],0))","v":385}]
[null,"rolling shear","frs,k",{"$f":"Input!$E$31","v":1.2}]
[null,"GEOMETRIA "]
[]
[null,"Altezza elemento 1",null,"h1","=",null,{"$f":"Input!$E$29","v":80},"mm"]
[null,"Base elemento 1",null,"b1","=",null,{"$f":"Input!$E$30","v":800},"mm"]
[]
[null,"Altezza elemento 2",null,"h2","=",null,{"$f":"Input!$K$29","v":260},"mm"]
[null,"Base elemento 2",null,"b2","=",null,{"$f":"Input!$K$30","v":150},"mm"]
[]
[null,"Altezza tavolato esistente",null,"t","=",null,0,"mm"]
[]
[null,"Luce solaio",null,"L","=",null,{"$f":"Input!$E$33","v":6000},"mm"]
[]
[]
[null," SISTEMA DI CONNESSIONE"]
[null,"TIPOLOGIA SHARP",null,{"$f":"'sharp metal'!C4","v":"SHARP METAL + TBS MAX@a ≤ 100mm"}]
[null,"Lunghezza unitaria",null,"seq","=",null,1000,"mm"]
[null,"numero sharp affiancati",{"$nulls":4},{"$f":"Input!$E$43","v":2}]
[]
[null,"Rigidezza connessione"]
[]
[null,"Per lo stato limite di esercizio"]
[{"$nulls":3},"Kser","=",null,{"$f":"'sharp metal'!C9*0.75+'sharp metal'!G9*0.25","v":{"v":240187.5,"d":"240188"}},"N/mm"]
[]
[null,"Per lo stato limite ultimo"]
[{"$nulls":3},"Ku",null,null,{"$f":"2/3*G207","v":160125},"N/mm"]
[null,"Resistenza di progetto della connessione:"]
[{"$nulls":3},"Rd,G","=",null,{"$f":"'sharp metal'!C14*I181/MAX($G$223)","v":{"v":68121.23483779278,"d":"68121"}},"N"]
[]
[{"$nulls":3},"Rd,G+Q","=",null,{"$f":"'sharp metal'!C14*I180/MAX($G$223)","v":{"v":79474.7739774249,"d":"79475"}},"N"]
[null,"COEFFICIENTI "]
[]
[null,"kdef",null,null,"=",null,{"$f":"INDEX(kdef[],MATCH($D$129,kdef[CS],0),2)","v":0.69}]
[]
[null,"kh, el 1",{"$f":"IF(LEFT(Input!$C$22,1)=\"C\",\"C\",IF(LEFT(Input!$C$22,2)=\"GL\",\"GL\",\"err\"))","v":"C"},null,"=",null,{"$f":"IF(C219=\"C\",IF(G188<=150,MIN((150/G188)^0.2,1.3),1),IF(G188<600,MIN((600/G188)^0.1,1.1),1))","v":{"v":1.1339665776330272,"d":"1.13"}}]
[]
[null,"kh, el 2",{"$f":"IF(LEFT(Input!$I$22,1)=\"C\",\"C\",IF(LEFT(Input!$I$22,2)=\"GL\",\"GL\",\"err\"))","v":"GL"},null,"=",null,{"$f":"IF(C221=\"C\",IF(G191<=150,MIN((150/G191)^0.2,1.3),1),IF(G191<600,MIN((600/G191)^0.1,1.1),1))","v":{"v":1.0872208946249378,"d":"1.09"}}]
[]
[null,"γm SLU,con","unioni",null,"=",null,{"$f":"INDEX(γ[],MATCH(LEFT(B223,2),γ[γ],0),MATCH(Input!$I$5,γ[#Headers],0))","v":1.3}]
[null,"γm,SLU,1","elemento 1",null,"=",null,{"$f":"INDEX(γ[],MATCH(B224,γ[γ],0),MATCH(Input!$I$5,γ[#Headers],0))","v":1.25},"EN 1995-1-1-2025"]
[null,"γm,SLU,2","elemento 2",null,"=",null,{"$f":"INDEX(γ[],MATCH(B225,γ[γ],0),MATCH(Input!$I$5,γ[#Headers],0))","v":1.25}]
[]
[]
[null,"SOLLECITAZIONI"]
[]
[null,"Carico permanente",null,"Gk","=",null,{"$f":"'Relazione di Calcolo AT SUPPORT'!H136","v":{"v":2,"d":"2.00"}},"kN/m2"]
[null,"Sovraccarico",null,"Qk1","=",null,{"$f":"'Relazione di Calcolo AT SUPPORT'!H138","v":{"v":1.6,"d":"1.60"}},"kN/m2"]
[]
[null,"Carichi permanenti e accidentali [G+Q]"]
[null,null,"=",null,"=",null,{"$f":"(1.35*G230+1.5*G231)","v":{"v":5.1000000000000005,"d":"5.1"}},"kN/m"]
[null,"Carichi permanenti [G]"]
[{"$nulls":4},"=",null,{"$f":"(1.35*G230)","v":2.7},"kN/m"]
[]
[null,"Sollecitazioni SLU [G+Q]"]
[{"$nulls":4},"=",null,{"$f":"$G$234*$G$196^2/8/10^6","v":{"v":22.950000000000003,"d":"22.95"}},"kNm"]
[{"$nulls":4},"=",null,{"$f":"$G$234*$G$196/2/10^3","v":{"v":15.300000000000002,"d":"15.30"}},"kN"]
[]
[null,"Sollecitazioni SLU [G]"]
[{"$nulls":4},"=",null,{"$f":"$G$236*$G$196^2/8/10^6","v":12.15},"kNm"]
[{"$nulls":4},"=",null,{"$f":"$G$236*$G$196/2/10^3","v":{"v":8.100000000000001,"d":"8.10"}},"kN"]
[]
[]
[null,"CALCOLO RIGIDEZZE t = 0 "]
[]
[null,"Rigidezza el. 1"]
[]
[]
[null,null,"flessionale",null,"E1J1","=",{"$f":"D155*F106","v":{"v":97020000000,"d":"9.70E+10"}},"Nmm2"]
[]
[]
[null,null,"assiale",null,"E1A1","=",{"$f":"D155*F107","v":{"v":138600000,"d":"1.39E+08"}},"N"]
[]
[null,"Rigidezza el. 2"]
[]
[]
[null,null,"flessionale",null,"E2J2","=",{"$f":"D179*G192*G191^3/12","v":{"v":2526550000000,"d":"2.53E+12"}},"Nmm2"]
[]
[]
[null,null,"assiale",null,"E2A2","=",{"$f":"D179*G191*G192","v":448500000},"N"]
[]
[]
[null,"Rigidezze sistema composto a t=0"]
[]
[]
[null,null,"flessionale",null,"(EJ0)t=0","=",{"$f":"G260+G252","v":{"v":2623570000000,"d":"2.62E+12"}},"Nmm2"]
[]
[]
[null,null,"assiale",null,"(EA0)t=0","=",{"$f":"(G263*G255)/(G263+G255)","v":{"v":105879918.24220747,"d":"1.06E+08"}},"N"]
[]
[]
[null,"Distanza fra baricentro elemento1  ed elemento 2"]
[]
[]
[{"$nulls":5},"=",{"$f":"G188/2+G191/2+G194","v":170},"mm"]
[]
[null,"Rigidezze sistema composto t = ∞"]
[]
[null,"flessionale",{"$nulls":3},"=",{"$f":"G269+G272*G278^2","v":{"v":5683499637199.796,"d":"5.68E+12"}},"Nmm2"]
[]
[]
[null,"Rigidezze efficace sistema composto"]
[]
[null,"Parametri"]
[]
[]
[{"$nulls":5},"=",{"$f":"(1+3.14^2*G255*G201/G210/G196^2)^-1","v":{"v":0.8083672994842706,"d":"0.80836730"}}]
[]
[]
[]
[{"$nulls":5},"=",{"$f":"(G290*G255*G278)/(G290*G255+G263)","v":{"v":33.97930610181264,"d":"33.979306"}},"mm"]
[]
[]
[]
[]
[]
[{"$nulls":5},"=",{"$f":"G278-G294","v":{"v":136.02069389818735,"d":"136.02"}},"mm"]
[]
[]
[{"$nulls":5},"=",{"$f":"G252+G260+G263*G294^2+G255*G300^2*G290","v":{"v":5214322193732.703,"d":"5.21432E+12"}},"Nmm2"]
[]
[]
[null,"Efficienza sistema composto"]
[]
[]
[{"$nulls":5},"=",{"$f":"(G303-G269)/(G282-G269)","v":{"v":0.8466705123662757,"d":"0.85"}}]
[]
[]
[]
[null,"CALCOLO RIGIDEZZE  t = ∞ [G]"]
[]
[null,"Rigidezza a t = ∞ elemento 1"]
[]
[]
[{"$nulls":5},"=",{"$f":"$D$155/(1+G321*$G$217)","v":{"v":6508.875739644971,"d":"6509"}},"GPa"]
[]
[]
[null,"Ψ2,i (per la valutazione della rigidezza a t = ∞)",{"$nulls":3},"=",1]
[]
[]
[null,"Rigidezza a t = ∞ dell'elemento 2"]
[]
[]
[{"$nulls":5},"=",{"$f":"$D$179/(1+$G$217*G321)","v":{"v":6804.7337278106515,"d":"6805"}},"MPa"]
[]
[]
[]
[]
[]
[null,"Rigidezza a t = ∞ della connessione"]
[]
[]
[{"$nulls":5},"=",{"$f":"$G$210/(1+$G$217*G321)","v":{"v":94748.52071005918,"d":"94749"}},"N/mm"]
[]
[]
[]
[null,"CALCOLO RIGIDEZZE SISTEMA"]
[]
[null,"Rigidezza elemento 1:"]
[]
[null,null,"flessionale",null,"E1J1","=",{"$f":"G318*F106","v":{"v":57408284023.66864,"d":"5.74E+10"}},"Nmm2"]
[]
[null,null,"assiale",null,"E1A1","=",{"$f":"G318*F107","v":{"v":82011834.31952663,"d":"8.20E+07"}},"N"]
[]
[null,"Rigidezza elemento 2:"]
[]
[null,null,"flessionale",null,"E2J2","=",{"$f":"G327*$G$191^3*$G$192/12","v":{"v":1495000000000.0002,"d":"1.50E+12"}},"Nmm2"]
[]
[null,null,"assiale",null,"E2A2","=",{"$f":"G327*$G$191*$G$192","v":{"v":265384615.38461542,"d":"2.65E+08"}},"N"]
[]
[]
[]
[null,"Rigidezze sistema composto a t =  ∞"]
[]
[null,null,"flessionale",null,"(EJ0)t=∞","=",{"$f":"G350+G344","v":{"v":1552408284023.669,"d":"1.55E+12"}},"Nmm2"]
[]
[]
[null,null,"assiale",null,"(EA0)t=∞","=",{"$f":"(G352*G346)/(G352+G346)","v":{"v":62650839.19657246,"d":"6.27E+07"}},"N"]
[]
[null,"Distanza fra baricentro trave e baricentro soletta:"]
[]
[{"$nulls":4},"a","=",{"$f":"G278","v":170},"mm"]
[]
[null,"Rigidezze sistema composto t = ∞"]
[]
[]
[null,"flessionale",{"$nulls":3},"=",{"$f":"G358+G361*G365^2","v":{"v":3363017536804.6133,"d":"3.36E+12"}},"Nmm2"]
[]
[]
[null,"Rigidezze efficace sistema composto"]
[]
[null,"Parametri"]
[{"$nulls":4},"γ1","=",{"$f":"(1+3.14^2*G346*$G$201/G336/$G$196^2)^-1","v":{"v":0.8083672994842706,"d":"0.80837"}}]
[]
[]
[{"$nulls":5},"=",{"$f":"(G376*G346*G365)/(G376*G346+G352)","v":{"v":33.97930610181264,"d":"33.98"}},"mm"]
[]
[]
[{"$nulls":5},"=",{"$f":"G365-G379","v":{"v":136.02069389818735,"d":"136.02"}},"mm"]
[]
[{"$nulls":4},"(EJeff)t=∞","=",{"$f":"G344+G350+G352*G379^2+G346*G382^2*G376","v":{"v":3085397747770.831,"d":"3.0854E+12"}},"Nmm2"]
[]
[null,"Efficienza sistema composto"]
[]
[]
[{"$nulls":5},"=",{"$f":"(G384-G358)/(G370-G358)","v":{"v":0.8466705123662759,"d":"0.85"}}]
[]
[]
[null,"CALCOLO RIGIDEZZE  t = ∞ [G + Q]"]
[]
[null,"Rigidezza a t = ∞ elemento 1"]
[]
[]
[{"$nulls":5},"=",{"$f":"$D$155/(1+G400*$G$217)","v":{"v":9113.504556752277,"d":"9113.505"}},"GPa"]
[]
[]
[null,"Ψ2,i (per la valutazione della rigidezza a t = ∞)",{"$nulls":3},"=",{"$f":"H126","v":0.3}]
[]
[]
[null,"Rigidezza a t = ∞ dell'elemento 2"]
[]
[]
[{"$nulls":5},"=",{"$f":"$D$179/(1+$G$217*G400)","v":{"v":9527.754763877381,"d":"9527.755"}},"MPa"]
[]
[]
[]
[]
[null,"Rigidezza a t = ∞ della connessione"]
[]
[]
[{"$nulls":5},"=",{"$f":"$G$210/(1+$G$217*G400)","v":{"v":132663.62883181442,"d":"132664"}},"N/mm"]
[]
[]
[]
[null,"CALCOLO RIGIDEZZE SISTEMA"]
[]
[null,"Rigidezza elemento 1:"]
[]
[null,null,"flessionale",null,"E1J1","=",{"$f":"G397*F106","v":{"v":80381110190.55508,"d":"8.03811E+10"}},"Nmm2"]
[]
[null,null,"assiale",null,"E1A1","=",{"$f":"G397*F107","v":{"v":114830157.4150787,"d":"1.1483E+08"}},"N"]
[]
[null,"Rigidezza elemento 2:"]
[]
[null,null,"flessionale",null,"E2J2","=",{"$f":"G406*$G$191^3*$G$192/12","v":{"v":2093247721623.8606,"d":"2.09E+12"}},"Nmm2"]
[]
[null,null,"assiale",null,"E2A2","=",{"$f":"G406*$G$191*$G$192","v":{"v":371582435.79121786,"d":"3.72E+08"}},"N"]
[]
[]
[null,"Rigidezze sistema composto a t =  ∞"]
[]
[null,null,"flessionale",null,"(EJ0)t=∞","=",{"$f":"G428+G422","v":{"v":2173628831814.4158,"d":"2.17E+12"}},"Nmm2"]
[]
[]
[null,null,"assiale",null,"(EA0)t=∞","=",{"$f":"(G430*G424)/(G430+G424)","v":{"v":87721556.12444693,"d":"8.77E+07"}},"N"]
[]
[null,"Distanza fra baricentro trave e baricentro soletta:"]
[]
[{"$nulls":4},"a","=",{"$f":"G278","v":170},"mm"]
[]
[null,"Rigidezze sistema composto t = ∞"]
[]
[]
[null,"flessionale",{"$nulls":3},"=",{"$f":"G435+G438*G442^2","v":{"v":4708781803810.932,"d":"4.71E+12"}},"Nmm2"]
[]
[]
[null,"Rigidezze efficace sistema composto"]
[]
[null,"Parametri"]
[{"$nulls":4},"γ1","=",{"$f":"(1+3.14^2*G424*$G$201/G414/$G$196^2)^-1","v":{"v":0.8083672994842706,"d":"0.80837"}}]
[]
[]
[{"$nulls":5},"=",{"$f":"(G453*G424*G442)/(G453*G424+G430)","v":{"v":33.97930610181264,"d":"33.979"}},"mm"]
[]
[]
[{"$nulls":5},"=",{"$f":"G442-G456","v":{"v":136.02069389818735,"d":"136"}},"mm"]
[]
[{"$nulls":4},"(EJeff)t=∞","=",{"$f":"G422+G428+G430*G456^2+G424*G459^2*G453","v":{"v":4320068097541.5938,"d":"4.32E+12"}},"Nmm2"]
[]
[]
[null,"Efficienza sistema composto"]
[]
[]
[{"$nulls":5},"=",{"$f":"(G461-G435)/(G447-G435)","v":{"v":0.8466705123662763,"d":"0.85"}}]
[]
[]
[]
[]
[null,"VERIFICHE SLU  t = 0 (G+Q)"]
[]
[null,"ELEMENTO 1"]
[]
[null,"Sforzo normale agente sull'elemento 1"]
[]
[]
[{"$nulls":5},"=",{"$f":"G290*G255*G300/G303*G239*10^3","v":{"v":67.0751697266224,"d":"67.075"}},"kN"]
[]
[]
[null,"Momento agente sull'elemento 1"]
[]
[]
[{"$nulls":5},"=",{"$f":"G252/G303*G239","v":{"v":0.4270179166673376,"d":"0.427"}},"kNm"]
[]
[]
[]
[]
[null,"Tensioni massime da sforzo normale e momento"]
[]
[]
[{"$nulls":5},"=",{"$f":"G479*10^3/F107","v":{"v":5.323426168779556,"d":"5.323"}},"MPa"]
[]
[]
[{"$nulls":5},"=",{"$f":"10^6*G485*G188/2/F106","v":{"v":1.9365891912350912,"d":"1.9366"}},"MPa"]
[]
[]
[]
[null,"VERIFICA TENSIONALE"]
[]
[null,"Verifica presso flessione"]
[]
[{"$nulls":4},{"$f":"G493/G152+G496/G149","v":{"v":0.5967637509447501,"d":"0.5968"}},{"$f":"IF(E504<=G504,\"≤\",\">\")","v":"≤"},1,{"$f":"IF(E504<G504,\"Verifica soddisfatta\",\"Verifica non soddisfatta\")","v":"Verifica soddisfatta"}]
[]
[]
[]
[null,"Verifica sforzi di taglio"]
[]
[]
[]
[{"$nulls":5},"=",{"$f":"IF(F105=\"3 strati\",D155/G303*(EJeff!C14*(G300+G188/2-EJeff!C14/2)+EJeff!C16*(G300+G188/2-EJeff!C16/2))*G240*1000,IF(F105=\"5 strati\",D155/G303*(EJeff!C13*(G300+G188/2-EJeff!C13/2)+EJeff!C15*(G300+G188/2-EJeff!C15/2)+EJeff!C17*(G300+G188/2-EJeff!C17/2))*G240*1000,IF(F105=\"7 strati\",D155/G303*(EJeff!C12*(G300+G188/2-EJeff!C12/2)+EJeff!C14*(G300+G188/2-EJeff!C14/2)+EJeff!C15*(G300+G188/2-EJeff!C16/2)+EJeff!C18*(G300+G188/2-EJeff!C19/2))*G240*1000,\"errore\")))","v":{"v":0.3118309353684038,"d":"0.3118"}},"MPa",null,{"$f":"D155/G303*(EJeff!C14*(G300+G188/2-EJeff!C14/2)+EJeff!C16*(G300+G188/2-EJeff!C16/2))*G240*1000","v":{"v":0.3118309353684038,"d":"0.31183"}}]
[{"$nulls":10},"fvd"]
[]
[]
[]
[]
[]
[null,null,{"$f":"G512","v":{"v":0.3118309353684038,"d":"0.31"}},{"$f":"IF(C519<=E519,\"≤\",\">\")","v":"≤"},{"$f":"G154","v":{"v":1.5008,"d":"1.50"}},{"$f":"IF(C519<E519,\"Verifica soddisfatta\",\"Verifica non soddisfatta\")","v":"Verifica soddisfatta"},null,null,{"$f":"C519/E519","v":0.20777647612500252}]
[null,"Verifica rolling shear"]
[]
[]
[]
[{"$nulls":5},"=",{"$f":"IF(F105=\"3 strati\",D155/G303*EJeff!C14*(G300+G188/2-EJeff!C14/2)*G240*1000,IF(F105=\"5 strati\",D155/G303*(EJeff!C13*(G300+G188/2-EJeff!C13/2)+EJeff!C15*(G300+G188/2-EJeff!C15/2))*G240*1000,IF(F105=\"7 strati\",D155/G303*(EJeff!C12*(G300+G188/2-EJeff!C12/2)+EJeff!C14*(G300+G188/2-EJeff!C14/2)+EJeff!C16*(G300+G188/2-EJeff!C16/2))*G240*1000,\"contattare ufficio tecnico\")))","v":{"v":0.15591546768420192,"d":"0.15592"}},"MPa"]
[{"$nulls":10},"fvd"]
[]
[]
[]
[]
[]
[null,null,{"$f":"G524","v":{"v":0.15591546768420192,"d":"0.16"}},{"$f":"IF(C531<=E531,\"≤\",\">\")","v":"≤"},{"$f":"G155","v":{"v":0.6719999999999999,"d":"0.67"}},{"$f":"IF(C531<E531,\"Verifica soddisfatta\",\"Verifica non soddisfatta\")","v":"Verifica soddisfatta"},null,null,{"$f":"C531/E531","v":0.23201706500625288}]
[]
[]
[]
[]
["ELEMENTO 2"]
[]
["Sforzo normale agente sull'elemento 2"]
[]
[{"$nulls":5},"=",{"$f":"1*G263*G294/G303*G239*10^3","v":{"v":67.07516972662242,"d":"67.1"}},"kN"]
[]
[]
[null,"Momento agente sull'elemento 2"]
[]
[]
[{"$nulls":5},"=",{"$f":"G260/G303*G239","v":{"v":11.120203229806862,"d":"11.1"}},"kNm"]
[]
[]
[null,"Tensioni massime da sforzo normale e momento"]
[]
[]
[{"$nulls":5},"=",{"$f":"G540*1000/G191/G192","v":{"v":1.7198761468364725,"d":"1.72"}},"MPa"]
[]
[]
[{"$nulls":5},"=",{"$f":"G546*10^6*6/G192/G191^2","v":{"v":6.58000191112832,"d":"6.58"}},"MPa"]
[]
[]
[null,"VERIFICA TENSIONALE"]
[]
[null,"Verifica tensoflessione"]
[]
[{"$nulls":4},{"$f":"G552/G174+G555/G173","v":{"v":0.6495421945441898,"d":"0.65"}},{"$f":"IF(E562<=G562,\"≤\",\">\")","v":"≤"},1,{"$f":"IF(E562<G562,\"Verifica soddisfatta\",\"Verifica non soddisfatta\")","v":"Verifica soddisfatta"}]
[]
[]
[]
[null,"Verifica sforzi di taglio"]
[{"$nulls":6},{"$f":"$D$179*(0.5*$G$191+$G$294)^2*$G$240*1000/$G$303","v":{"v":0.9073388297831515,"d":"9.07339E-01"}}]
[]
[]
[{"$nulls":5},"=",{"$f":"IF($G$294>=0.5*$G$191,$G$191*$D$179*$G$294*1000*$G$240/$G$303,$D$179/2*(0.5*$G$191+$G$294)^2*$G$240*1000/$G$303)","v":{"v":0.45366941489157575,"d":"0.45"}},"MPa"]
[]
[]
[]
[]
[]
[]
[{"$nulls":4},{"$f":"G570","v":{"v":0.45366941489157575,"d":"0.45"}},{"$f":"IF(E577<=G577,\"≤\",\">\")","v":"≤"},{"$f":"G178","v":{"v":1.3132,"d":"1.31"}},{"$f":"IF(E577<G577,\"Verifica soddisfatta\",\"Verifica non soddisfatta\")","v":"Verifica soddisfatta"}]
[null,"CONNESSIONE"]
[]
[null,"Forza agente sulla connessione"]
[]
[]
[{"$nulls":5},"=",{"$f":"G290*G255*G300*G201/G303*G240","v":{"v":44.716779817748275,"d":"44.717"}},"kN"]
[]
[]
[null,"Valore di progetto della connessione"]
[]
[{"$nulls":5},"=",{"$f":"G214/1000","v":{"v":79.4747739774249,"d":"79.47"}},"kN"]
[]
[]
[null,"Spostamento del connettore "]
[null,"s  ","=",{"$f":"G583*1000/G210","v":0.2792617006572882}]
[]
[]
[]
[null,"VERIFICA DELLA CONNESSIONE"]
[]
[]
[]
[]
[{"$nulls":4},{"$f":"G583","v":{"v":44.716779817748275,"d":"44.7"}},{"$f":"IF(E601<=G601,\"≤\",\">\")","v":"≤"},{"$f":"G588","v":{"v":79.4747739774249,"d":"79.47"}},{"$f":"IF(E601<G601,\"Verifica soddisfatta\",\"Verifica non soddisfatta\")","v":"Verifica soddisfatta"}]
[]
[]
[]
[null,"VERIFICHE SLU t = ∞ [G]"]
[]
[null,"ELEMENTO 1"]
[]
[null,"Sforzo normale agente sull'elemento 1"]
[]
[]
[{"$nulls":5},"=",{"$f":"$G$376*$G$346*$G$382/$G$384*$G$243*10^6","v":{"v":35510.383972917734,"d":"35510"}},"N"]
[]
[]
[null,"Momento agente sull'elemento 1"]
[]
[]
[{"$nulls":5},"=",{"$f":"$G$344/$G$384*$G$243*10^6","v":{"v":226068.30882388452,"d":"226068"}},"Nmm"]
[]
[]
[null,"Tensioni massime da sforzo normale e momento"]
[]
[{"$nulls":5},"=",{"$f":"G612/F107","v":{"v":2.818284442295058,"d":"2.82"}},"MPa"]
[]
[]
[{"$nulls":5},"=",{"$f":"G618*$G$188/2/F106","v":{"v":1.0252531012421067,"d":"1.03"}},"MPa"]
[]
[null,"VERIFICA TENSIONALE"]
[]
[null,"Verifica pressoflessione"]
[]
[{"$nulls":4},{"$f":"G623/$I$152+G626/$I$149","v":{"v":0.36858937558352195,"d":"0.3686"}},{"$f":"IF(E632<=G632,\"≤\",\">\")","v":"≤"},1,{"$f":"IF(E632<G632,\"Verifica soddisfatta\",\"Verifica non soddisfatta\")","v":"Verifica soddisfatta"}]
[]
[]
[]
[null,"Verifica sforzi di taglio"]
[]
[]
[]
[{"$nulls":5},"=",{"$f":"IF(F105=\"3 strati\",G318/G384*((#REF!*(G382+G188/2-#REF!/2))+#REF!*(G382+G188/2-#REF!/2))*G244*1000,IF(F105=\"5 strati\",G318/G384*(#REF!*(G382+G188/2-#REF!/2)+#REF!*(G382+G188/2-#REF!/2)+#REF!*(G382+G188/2-#REF!/2))*G244*1000,IF(F105=\"7 strati\",G318/G384*(#REF!*(G382+G188/2-#REF!/2)+#REF!*(G382+G188/2-#REF!/2)+#REF!*(G382+G188/2-#REF!/2)+#REF!*(G382+G188/2-#REF!/2))*G244*1000,\"errore troppi strati\")))","v":{"$error":"#REF!"}},"MPa"]
{"$rows_empty":9}
[null,null,{"$f":"G640","v":{"$error":"#REF!"}},{"$f":"IF(C650<=E650,\"≤\",\">\")","v":{"$error":"#REF!"}},{"$f":"$I$154","v":{"v":1.2864,"d":"1.29"}},{"$f":"IF(C650<E650,\"Verifica soddisfatta\",\"Verifica non soddisfatta\")","v":{"$error":"#REF!"}}]
[]
[]
[null,"Verifica rolling shear"]
[]
[]
[]
[{"$nulls":5},"=",{"$f":"IF(F105=\"3 strati\",G318/G384*#REF!*(G382+G188/2-#REF!/2)*G244*1000,IF(F105=\"5 strati\",G318/G384*(#REF!*(G382+G188/2-#REF!/2)+#REF!*(G382+G188/2-#REF!/2))*G244*1000,IF(F105=\"7 strati\",G318/G384*(#REF!*(G382+G188/2-#REF!/2)+#REF!*(G382+G188/2-#REF!/2)+#REF!*(G382+G188/2-#REF!/2))*G244*1000,\"errore troppi strati\")))","v":{"$error":"#REF!"}},"MPa"]
[{"$nulls":10},"fvd"]
[]
[]
[]
[]
[]
[null,null,{"$f":"G657","v":{"$error":"#REF!"}},{"$f":"IF(C664<=E664,\"≤\",\">\")","v":{"$error":"#REF!"}},{"$f":"I155","v":{"v":0.576,"d":"0.58"}},{"$f":"IF(C664<E664,\"Verifica soddisfatta\",\"Verifica non soddisfatta\")","v":{"$error":"#REF!"}}]
[]
[]
[]
[]
[]
[]
[null,"ELEMENTO 2"]
[]
[null,"Sforzo normale agente sull'elemento 2"]
[]
[]
[{"$nulls":5},"=",{"$f":"1*$G$352*$G$379/$G$384*$G$243*10^3","v":{"v":35.51038397291774,"d":"36"}},"kN"]
[]
[null,"Momento agente sull'elemento 2"]
[]
[]
[{"$nulls":5},"=",{"$f":"$G$350/$G$384*$G$243","v":{"v":5.8871664157801025,"d":"5.9"}},"KNm"]
[]
[]
[null,"Tensioni massime da sforzo normale e momento"]
[]
[]
[{"$nulls":5},"=",{"$f":"G676*1000/($G$191*$G$192)","v":{"v":0.9105226659722496,"d":"0.91"}},"MPa"]
[]
[]
[{"$nulls":5},"=",{"$f":"10^6*G681*$G$191/(2*$G$192*$G$191^3/12)","v":{"v":3.4835304235385225,"d":"3.48"}},"MPa"]
[]
[]
[null,"VERIFICA TENSIONALE"]
[]
[null,"Verifica pressoflessione"]
[]
[{"$nulls":4},{"$f":"G687/$I$174+G690/$I$173","v":{"v":0.40118782604199954,"d":"0.40"}},{"$f":"IF(E697<=G697,\"≤\",\">\")","v":"≤"},1,{"$f":"IF(E697<G697,\"Verifica soddisfatta\",\"Verifica non soddisfatta\")","v":"Verifica soddisfatta"}]
[]
[]
[]
[]
[null,"Verifica sforzi di taglio"]
[]
[]
[]
[{"$nulls":5},"=",{"$f":"IF($G$379>=0.5*$G$191,$G$191*$G$327*$G$379*$G$244*1000/$G$384,0.5*$G$327*(0.5*$G$191+$G$379)^2*$G$244*1000/$G$384)","v":{"v":0.24017792553083414,"d":"0.24"}},"MPa"]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"G706","v":{"v":0.24017792553083414,"d":"0.24"}},{"$f":"IF(C713<=E713,\"≤\",\">\")","v":"≤"},{"$f":"$I$178","v":{"v":1.1256000000000002,"d":"1.13"}},{"$f":"IF(C713<E713,\"Verifica soddisfatta\",\"Verifica non soddisfatta\")","v":"Verifica soddisfatta"}]
[]
[null,"CONNESSIONE"]
[]
[null,"Forza agente sulla connessione"]
[]
[]
[{"$nulls":5},"=",{"$f":"$G$346*$G$376*$G$382*$G$201*$G$244/$G$384","v":{"v":23.673589315278495,"d":"23.6736"}},"kN"]
[]
[]
[]
[null,"Valore di progetto della connessione"]
[]
[{"$nulls":5},"=",{"$f":"$G$212/1000","v":{"v":68.12123483779278,"d":"68.12"}},"kN"]
[]
[]
[null,"Spostamento del connettore "]
[null,"s  ","=",{"$f":"G720*1000/G336","v":0.24985708629396194}]
[]
[]
[]
[null,"VERIFICA DELLA CONNESSIONE"]
[]
[]
[]
[]
[{"$nulls":4},{"$f":"G720","v":{"v":23.673589315278495,"d":"23.7"}},{"$f":"IF(E739<=G739,\"≤\",\">\")","v":"≤"},{"$f":"G726","v":{"v":68.12123483779278,"d":"68.1"}},{"$f":"IF(E739<=G739,\"Verifica soddisfatta\",\"Verifica non soddisfatta\")","v":"Verifica soddisfatta"}]
[]
[null,"VERIFICHE SLU t = ∞ [G + Q]"]
[]
[null,"ELEMENTO 1"]
[]
[null,"Sforzo normale agente sull'elemento 1"]
[]
[]
[{"$nulls":5},"=",{"$f":"$G$453*$G$424*$G$459/$G$461*$G$239*10^3","v":{"v":67.07516972662239,"d":"67.075"}},"kN"]
[]
[]
[null,"Momento agente sull'elemento 1"]
[]
[]
[{"$nulls":5},"=",{"$f":"$G$422/$G$461*$G$239","v":{"v":0.42701791666733746,"d":"0.427"}},"kNm"]
[]
[]
[null,"Tensioni massime da sforzo normale e momento"]
[]
[]
[{"$nulls":5},"=",{"$f":"G748*1000/F107","v":{"v":5.323426168779555,"d":"5.323"}},"MPa"]
[]
[]
[{"$nulls":5},"=",{"$f":"G754*G$188/2/F106*10^6","v":{"v":1.9365891912350903,"d":"1.94"}},"MPa"]
[]
[]
[]
[null,"VERIFICA TENSIONALE"]
[]
[null,"Verifica pressoflessione"]
[]
[{"$nulls":4},{"$f":"G760/$G$152+G763/$G$149","v":{"v":0.59676375094475,"d":"0.597"}},{"$f":"IF(E771<=G771,\"≤\",\">\")","v":"≤"},1,{"$f":"IF(E771<G771,\"Verifica soddisfatta\",\"Verifica non soddisfatta\")","v":"Verifica soddisfatta"}]
[]
[]
[]
[null,"Verifica sforzi di taglio"]
[]
[]
[]
[{"$nulls":5},"=",{"$f":"IF(F105=\"3 strati\",G397/G461*(#REF!*(G459+G188/2-#REF!/2)+#REF!*(G459+G188/2-#REF!/2))*G240*1000,IF(F105=\"5 strati\",G397/G461*(#REF!*(G459+G188/2-#REF!/2)+#REF!*(G459+G188/2-#REF!/2)+#REF!*(G459+G188/2-#REF!/2))*G240*1000,IF(F105=\"7 strati\",G397/G461*(#REF!*(G459+G188/2-#REF!/2)+#REF!*(G459+G188/2-#REF!/2)+#REF!*(G459+G188/2-#REF!/2))*G240*1000,\"troppi strati errore\")))","v":{"$error":"#REF!"}},"MPa"]
{"$rows_empty":7}
[null,null,{"$f":"G779","v":{"$error":"#REF!"}},{"$f":"IF(C787<=E787,\"≤\",\">\")","v":{"$error":"#REF!"}},{"$f":"$G$154","v":{"v":1.5008,"d":"1.50"}},{"$f":"IF(C787<E787,\"Verifica soddisfatta\",\"Verifica non soddisfatta\")","v":{"$error":"#REF!"}}]
[]
[]
[null,"Verifica rolling shear"]
[]
[]
[]
[{"$nulls":5},"=",{"$f":"IF(F105=\"3 strati\",G397/G461*#REF!*(G459+G188/2-#REF!/2)*G240*1000,IF(F105=\"5 strati\",G397/G461*(#REF!*(G459+G188/2-#REF!/2)+#REF!*(G459+G188/2-#REF!/2))*G240*1000,IF(F105=\"7 strati\",G397/G461*(#REF!*(G459+G188/2-#REF!/2)+#REF!*(G459+G188/2-#REF!/2)+#REF!*(G459+G188/2-#REF!/2))*G240*1000,\"troppi strati errore\")))","v":{"$error":"#REF!"}},"MPa"]
[{"$nulls":10},"fvd"]
[null,null,{"$f":"G794","v":{"$error":"#REF!"}},{"$f":"IF(C796<=E796,\"≤\",\">\")","v":{"$error":"#REF!"}},{"$f":"G155","v":{"v":0.6719999999999999,"d":"0.67"}},{"$f":"IF(C796<E796,\"Verifica soddisfatta\",\"Verifica non soddisfatta\")","v":{"$error":"#REF!"}}]
[]
[]
[null,"ELEMENTO 2"]
[]
[null,"Sforzo normale agente sull'elemento 2"]
[]
[]
[{"$nulls":5},"=",{"$f":"1*$G$430*$G$379/$G$461*$G$239*10^3","v":{"v":67.0751697266224,"d":"67"}},"kN"]
[]
[]
[null,"Momento agente sull'elemento 2"]
[]
[]
[{"$nulls":5},"=",{"$f":"$G$428/$G$461*$G$239","v":{"v":11.12020322980686,"d":"11.1"}},"KNm"]
[]
[]
[null,"Tensioni massime da sforzo normale e momento"]
[]
[]
[{"$nulls":5},"=",{"$f":"G804*1000/($G$191*$G$192)","v":{"v":1.719876146836472,"d":"1.72"}},"MPa"]
[]
[]
[{"$nulls":5},"=",{"$f":"10^6*G810*$G$191/(2*$G$192*$G$191^3/12)","v":{"v":6.58000191112832,"d":"6.58"}},"MPa"]
[]
[]
[null,"VERIFICA TENSIONALE"]
[]
[null,"Verifica pressoflessione"]
[]
[{"$nulls":4},{"$f":"G816/$G$174+G819/$G$173","v":{"v":0.6495421945441898,"d":"0.65"}},{"$f":"IF(E826<=G826,\"≤\",\">\")","v":"≤"},1,{"$f":"IF(E826<G826,\"Verifica soddisfatta\",\"Verifica non soddisfatta\")","v":"Verifica soddisfatta"}]
[]
[]
[]
[null,"Verifica sforzi di taglio"]
[]
[]
[]
[{"$nulls":5},"=",{"$f":"IF($G$456>=0.5*$G$191,$G$191*$G$406*$G$456*1000*$G$240/$G$461,$G$406/2*(0.5*$G$191+$G$456)^2*$G$240*1000/$G$461)","v":{"v":0.4536694148915757,"d":"0.45"}},"MPa"]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"G834","v":{"v":0.4536694148915757,"d":"0.45"}},{"$f":"IF(C841<=E841,\"≤\",\">\")","v":"≤"},{"$f":"$G$178","v":{"v":1.3132,"d":"1.31"}},{"$f":"IF(C841<E841,\"Verifica soddisfatta\",\"Verifica non soddisfatta\")","v":"Verifica soddisfatta"}]
[]
[null,"CONNESSIONE"]
[]
[null,"Forza agente sulla connessione"]
[]
[]
[{"$nulls":5},"=",{"$f":"$G$424*$G$453*$G$459*$G$201*$G$240/$G$461","v":{"v":44.71677981774826,"d":"44.717"}},"kN"]
[]
[]
[null,"Valore di progetto della connessione"]
[]
[{"$nulls":5},"=",{"$f":"G214/1000","v":{"v":79.4747739774249,"d":"79.5"}},"kN"]
[]
[]
[null,"VERIFICA DELLA CONNESSIONE"]
[]
[]
[]
[{"$nulls":4},{"$f":"G848","v":{"v":44.71677981774826,"d":"44.7"}},{"$f":"IF(E860<=G860,\"≤\",\">\")","v":"≤"},{"$f":"G853","v":{"v":79.4747739774249,"d":"79.5"}},{"$f":"IF(E860<=G860,\"Verifica soddisfatta\",\"Verifica non soddisfatta\")","v":"Verifica soddisfatta"}]
[]
[null,"Spostamento del connettore "]
[null,"s  ","=",{"$f":"G848*1000/G414","v":0.33706887269334673}]
[]
[]
[null,"CALCOLO RIGIDEZZE SLE  t = 0"]
[]
[null,"Rigidezza elemento 1"]
[]
[]
[null,"flessionale:",null,null,"E1J1","=",{"$f":"G252","v":{"v":97020000000,"d":"9.70E+10"}},"Nmm2"]
[]
[null,"assiale:",null,null,"E1A1","=",{"$f":"G255","v":{"v":138600000,"d":"1.39E+08"}},"N"]
[]
[null,"Rigidezza elemento 2"]
[]
[]
[null,"flessionale:",null,null,"E2J2","=",{"$f":"G260","v":{"v":2526550000000,"d":"2.53E+12"}},"Nmm2"]
[]
[null,"assiale:",null,null,"E2A2","=",{"$f":"G263","v":{"v":448500000,"d":"4.49E+08"}},"N"]
[]
[null,"Rigidezze sistema composto a t=0"]
[]
[null,"flessionale:",null,null,"(EJ0)t=0","=",{"$f":"G878+G871","v":{"v":2623570000000,"d":"2.62E+12"}},"Nmm2"]
[]
[]
[null,"assiale:",null,null,"(EA0)t=0","=",{"$f":"(G880*G873)/(G880+G873)","v":{"v":105879918.24220747,"d":"1.06E+08"}},"N"]
[]
[null,"Distanza fra baricentro trave e baricentro soletta:"]
[]
[{"$nulls":4},"a","=",{"$f":"G278","v":170},"mm"]
[]
[null,"Rigidezze sistema composto t=0"]
[]
[null,"flessionale:",{"$nulls":3},"=",{"$f":"G884+G887*G891^2","v":{"v":5683499637199.796,"d":"5.68E+12"}},"Nmm2"]
[]
[null,"Rigidezze efficace sistema composto"]
[]
[null,"Parametri"]
[]
[]
[{"$nulls":5},"=",{"$f":"1/(1+((3.14^2)*G873*'Relazione di Calcolo AT SUPPORT'!G201)/('Relazione di Calcolo AT SUPPORT'!G207*'Relazione di Calcolo AT SUPPORT'!G196^2))","v":{"v":0.863527323829101,"d":"0.864"}}]
[]
[]
[]
[{"$nulls":5},"=",{"$f":"(G902*G873*G891)/(G902*G873+G880)","v":{"v":35.80952479839428,"d":"36"}},"mm"]
[]
[]
[{"$nulls":5},"=",{"$f":"G891-G906","v":{"v":134.19047520160572,"d":"134"}},"mm"]
[]
[{"$nulls":4},"(EJeff)t=0","=",{"$f":"G871+G878+G880*G906^2+G873*G909^2*G902","v":{"v":5353867218253.572,"d":"5.35E+12"}},"Nmm2"]
[null,"Efficienza sistema composto"]
[]
[]
[{"$nulls":5},"=",{"$f":"(G911-G884)/(G895-G884)","v":{"v":0.892274510191719,"d":"0.89"}}]
[]
[]
[]
[null,"CALCOLO RIGIDEZZE SLE  t = ∞"]
[]
[null,"Modulo elastico t = ∞ dell'elemento 1"]
[]
[{"$nulls":5},"=",{"$f":"$D$155/(1+$G$217)","v":{"v":6508.875739644971,"d":"6509"}},"MPa"]
[]
[]
[null,"Modulo elastico  t = ∞ dell'elemento  2"]
[]
[{"$nulls":5},"=",{"$f":"$D$179/(1+$G$217)","v":{"v":6804.7337278106515,"d":"6805"}},"MPa"]
[]
[]
[null,"Rigidezza a t = ∞ della connessione"]
[]
[]
[{"$nulls":5},"=",{"$f":"'Relazione di Calcolo AT SUPPORT'!G207/(1+'Relazione di Calcolo AT SUPPORT'!G217)","v":{"v":142122.78106508875,"d":"142123"}},"N/mm"]
[]
[]
[]
[null,"Rigidezza elemento 1"]
[]
[]
[null,"flessionale:",null,null,"E1J1","=",{"$f":"G923*F106","v":{"v":57408284023.66864,"d":"5.74E+10"}},"Nmm2"]
[]
[]
[null,"assiale:",null,null,"E1A1","=",{"$f":"G923*F107","v":{"v":82011834.31952663,"d":"8.20E+07"}},"N"]
[]
[]
[null,"Rigidezza elemento 2"]
[]
[]
[null,"flessionale:",null,null,"E2J2","=",{"$f":"G928*G192*G191^3/12","v":{"v":1495000000000,"d":"1.50E+12"}},"Nmm2"]
[]
[]
[null,"assiale:",null,null,"E2A2","=",{"$f":"G928*G191*G192","v":{"v":265384615.38461542,"d":"2.65E+08"}},"N"]
[]
[null,"Rigidezze globale a t=∞"]
[]
[null,"flessionale:",null,null,"(EJ0)t=∞","=",{"$f":"G950+G941","v":{"v":1552408284023.6687,"d":"1.55E+12"}},"Nmm2"]
[]
[]
[null,"assiale:",null,null,"(EA0)t=∞","=",{"$f":"(G953*G944)/(G953+G944)","v":{"v":62650839.19657246,"d":"6.27E+07"}},"N"]
[]
[]
[null,"Distanza fra baricentro trave e baricentro soletta:"]
[]
[{"$nulls":4},"a","=",{"$f":"G891","v":170},"mm"]
[]
[null,"Rigidezze sistema composto t=∞"]
[]
[null,"flessionale:",{"$nulls":3},"=",{"$f":"G957+G960*G965^2","v":{"v":3363017536804.613,"d":"3.36E+12"}},"Nmm2"]
[]
[null,"Rigidezze efficace sistema composto"]
[]
[null,"Parametri"]
[]
[]
[{"$nulls":5},"=",{"$f":"1/(1+((3.14^2)*G944*G201)/(G934*G196^2))","v":{"v":0.863527323829101,"d":"0.864"}}]
[]
[]
[]
[{"$nulls":5},"=",{"$f":"(G976*G944*G965)/(G976*G944+G953)","v":{"v":35.80952479839428,"d":"36"}},"mm"]
[]
[]
[{"$nulls":5},"=",{"$f":"G965-G980","v":{"v":134.19047520160572,"d":"134"}},"mm"]
[]
[]
[{"$nulls":4},"(EJeff)t=∞","=",{"$f":"G941+G950+G953*G980^2+G944*G983^2*G976","v":{"v":3167968768197.38,"d":"3.17E+12"}},"Nmm^2"]
[]
[null,"Efficienza sistema composto"]
[]
[]
[{"$nulls":5},"=",{"$f":"(G986-G957)/(G969-G957)","v":{"v":0.892274510191719,"d":"0.89"}}]

{"sheet":"EJeff","index":7,"n_rows":43,"n_cols":35,"rows_kept":43,"hidden":true,"merged":[[4,26,4,29],[4,31,4,34],[6,1,6,8],[6,9,6,10],[6,11,6,12],[6,14,6,16],[6,17,6,19],[6,20,6,21],[6,23,6,24],[6,26,6,27],[6,28,6,29],[6,31,6,32],[6,33,6,34],[7,1,8,1],[7,9,7,10],[7,11,7,12],[7,14,7,16],[7,17,7,19],[7,20,7,21],[7,23,7,24],[7,26,7,27],[7,28,7,29],[7,31,7,32],[7,33,7,34]]}
[null,"DO NOT TOUCH THESE. Change in DATA or in CLT PANEL"]
[null,"b(mm)",null,"E0,mean","E90,mean","Gmean","Gr,mean",null,null,"bef,ij(mm)",{"$f":"(Input!$E$30-Input!$K$30)*(0.5-0.35*((Input!$E$30-Input!$K$30)/Input!$E$33)^0.9*($D$3*MAX($X$21:$Y$21)/($F$3*SUM($X$21:$Y$21)))^0.45)","v":{"v":230.98665987874804,"d":"230.99"}},{"$nulls":20},"bef,ij(mm)",{"$f":"MAX(C10:C20)","v":{"v":30,"d":"30.00"}},"[mm]"]
[null,{"$f":"Input!$E$30","v":800},null,{"$f":"INDEX(TimberType[],MATCH(Input!$C$22,TimberType[Classe],0),MATCH(D2,TimberType[#Headers],0))","v":11000},{"$f":"INDEX(TimberType[],MATCH(Input!$C$22,TimberType[Classe],0),MATCH(E2,TimberType[#Headers],0))","v":370},{"$f":"INDEX(TimberType[],MATCH(Input!$C$22,TimberType[Classe],0),MATCH(F2,TimberType[#Headers],0))","v":690},69,{"$f":"Input!$C$28","v":"80mm-3-   30 20 30   "},null,"bef",{"$f":"K2*2+Input!$K$30","v":{"v":611.973319757496,"d":"611.97"}},"scelto in INPUT",{"$f":"Input!C28","v":"80mm-3-   30 20 30   "},{"$nulls":10},"NUOVO EUROCODICE5 O STORANESO",{"$nulls":7},"bef",{"$f":"AG2*2+Input!$K$30","v":{"v":210,"d":"210.00"}},"[mm]"]
[]
[{"$nulls":26},"At mid span",{"$nulls":4},"At support"]
[null,"Berechnung von Brettsperrholzelementen"]
[null,"Se non c'è lamella, indicare d=0",{"$nulls":7},"INERZIA",null,"Biegesteifigkeiten",null,"Drillsteifigkeit1)","Plattenschubsteifigkeit ",null,null,"Plattenschubsteifigkeit ",null,null,"Dehnsteifigkeiten",null,"Scheibenschubsteifigkeit ","area",null,null,"INERZIA CON BASE EFFICACE",null,"area CON BASE EFFICACE",null,null,"INERZIA CON BASE EFFICACE",null,"area CON BASE EFFICACE"]
[null,"Lagen","di","Exx,i","Eyy,i","Gxz,i","Gyz,i","Gxy,i=Gyx,i","zi","mm^4",null,"[MNm²/m] ∙10-3",null,"[MN/m] ∙10-3","[MN/m] ∙10-3",null,null,"[MN/m] ∙10-3",null,null,"[MN/m]",null,"[MN/m]","mm^2",null,null,"[mm4]",null,"[mm2]",null,null,"[mm4]",null,"[mm2]"]
[null,null,"[mm]","[MN/m²]","[MN/m²]","[MN/m²]","[MN/m²]","[MN/m²]","[mm]","jxx,i ","Jy,i","Bx,i ","By,i","Bxy,i","EIx,B,i","cxz,i","1/Sxz,i","EIy,B,i","cxz,i","1/Sxz,i","Dx,i","Dx,i","Dxj,i","AX","AY",null,"jxx,i","Jy,i","AX","AY",null,"jxx,i","Jy,i","AX","AY"]
[null,11,0,{"$f":"D3","v":11000},{"$f":"E3","v":370},{"$f":"F3","v":690},{"$f":"G3","v":69},690,{"$f":"I11-C11/2-C10/2","v":-40},{"$f":"IF(D10>E10,(C10^3/12+C10*(I10^2))*$B$3,0)","v":0},{"$f":"IF(D10<E10,(C10^3/12+C10*(I10^2))*$B$3,0)","v":0},{"$f":"(D10*(C10/1000)^3/12+D10*C10/1000*(I10/1000)^2)*10^3","v":{"v":0,"d":"0.00"}},{"$f":"(E10*(C10/1000)^3/12+E10*C10/1000*(I10/1000)^2)*1000","v":{"v":0,"d":"0.00"}},{"$f":"(2*H10*C10/1000*(I10/1000)^2+H10*(C10/1000)^3/6)*1000","v":{"v":0,"d":"0.00"}},{"$f":"(D10*C10/1000*(I10/1000)^2)*1000","v":0},{"$f":"1/$O$21*D10*C10/1000*I10/1000*10^3","v":0},{"$f":"IF(C10=0,\"\",(C10/1000)/(3*F10)*(P10+P10^2)*1000)","v":""},{"$f":"(E10*C10/1000*(I10/1000)^2)*1000","v":0},{"$f":"1/$R$21*E10*C10/1000*I10/1000*10^3","v":0},{"$f":"IF(C10=0,\"\",(C10/1000)/(3*G10)*(S10+S10^2)*1000)","v":""},{"$f":"C10/1000*D10","v":0},{"$f":"C10/1000*E10","v":0},{"$f":"C10/1000*H10","v":0},{"$f":"IF(D10>E10,$B$3*C10,0)","v":0},{"$f":"IF(D10<E10,$B$3*C10,0)","v":0},null,{"$f":"IF(D10>E10,(C10^3/12+C10*(I10^2))*$K$3,0)","v":0},{"$f":"IF(D10<E10,(C10^3/12+C10*(I10^2))*$K$3,0)","v":0},{"$f":"IF(D10>E10,$K$3*C10,0)","v":0},{"$f":"IF(D10<E10,$K$3*C10,0)","v":0},null,{"$f":"IF(D10>E10,(C10^3/12+C10*(I10^2))*$AG$3,0)","v":0},{"$f":"IF(D10<E10,(C10^3/12+C10*(I10^2))*$AG$3,0)","v":0},{"$f":"IF(D10>E10,$AG$3*C10,0)","v":0},{"$f":"IF(D10<E10,$AG$3*C10,0)","v":0}]
[null,9,{"$f":"_xlfn.XLOOKUP(Input!$C$28,'CLT panel'!G4:G48,'CLT panel'!P4:P48,0)","v":0},{"$f":"E3","v":370},{"$f":"D3","v":11000},{"$f":"G3","v":69},{"$f":"F3","v":690},690,{"$f":"I12-C12/2-C11/2","v":-40},{"$f":"IF(D11>E11,(C11^3/12+C11*(I11^2))*$B$3,0)","v":0},{"$f":"IF(D11<E11,(C11^3/12+C11*(I11^2))*$B$3,0)","v":0},{"$f":"(D11*(C11/1000)^3/12+D11*C11/1000*(I11/1000)^2)*10^3","v":{"v":0,"d":"0.00"}},{"$f":"(E11*(C11/1000)^3/12+E11*C11/1000*(I11/1000)^2)*1000","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},0,{"$f":"(1/$O$21*D11*C11/1000*I11/1000)*10^3+P10","v":0},{"$f":"IF(C11=0,\"\",(C11/1000)/(3*F11)*(P10^2+P10*P11+P11^2)*1000)","v":""},0,{"$f":"(1/$R$21*E11*C11/1000*I11/1000)*10^3+S10","v":0},{"$f":"IF(C11=0,\"\",(C11/1000)/(3*G11)*(S10^2+S10*S11+S11^2)*1000)","v":""},0,0,0,{"$f":"IF(D11>E11,$B$3*C11,0)","v":0},{"$f":"IF(D11<E11,$B$3*C11,0)","v":0},null,{"$f":"IF(D11>E11,(C11^3/12+C11*(I11^2))*$K$3,0)","v":0},{"$f":"IF(D11<E11,(C11^3/12+C11*(I11^2))*$K$3,0)","v":0},{"$f":"IF(D11>E11,$K$3*C11,0)","v":0},{"$f":"IF(D11<E11,$K$3*C11,0)","v":0},null,{"$f":"IF(D11>E11,(C11^3/12+C11*(I11^2))*$AG$3,0)","v":0},{"$f":"IF(D11<E11,(C11^3/12+C11*(I11^2))*$AG$3,0)","v":0},{"$f":"IF(D11>E11,$AG$3*C11,0)","v":0},{"$f":"IF(D11<E11,$AG$3*C11,0)","v":0}]
[null,7,{"$f":"_xlfn.XLOOKUP(Input!$C$28,'CLT panel'!G4:G48,'CLT panel'!O4:O48,0)","v":0},{"$f":"D3","v":11000},{"$f":"E3","v":370},{"$f":"F3","v":690},{"$f":"G3","v":69},690,{"$f":"I13-C13/2-C12/2","v":-40},0,0,{"$f":"(D12*(C12/1000)^3/12+D12*C12/1000*(I12/1000)^2)*10^3","v":{"v":0,"d":"0.00"}},{"$f":"(E12*(C12/1000)^3/12+E12*C12/1000*(I12/1000)^2)*1000","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},0,0,"",0,0,"",0,0,0,0,0,null,0,0,0,0,null,0,0,0,0]
[null,5,{"$f":"_xlfn.XLOOKUP(Input!$C$28,'CLT panel'!G4:G48,'CLT panel'!N4:N48,0)","v":0},{"$f":"E3","v":370},{"$f":"D3","v":11000},{"$f":"G3","v":69},{"$f":"F3","v":690},690,{"$f":"I14-C14/2-C13/2","v":-40},0,0,{"$f":"(D13*(C13/1000)^3/12+D13*C13/1000*(I13/1000)^2)*1000","v":{"v":0,"d":"0.00"}},{"$f":"(E13*(C13/1000)^3/12+E13*C13/1000*(I13/1000)^2)*1000","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},0,0,"",0,0,"",0,0,0,0,0,null,0,0,0,0,null,0,0,0,0]
[null,3,{"$f":"_xlfn.XLOOKUP(Input!$C$28,'CLT panel'!G4:G48,'CLT panel'!M4:M48,0)","v":30},{"$f":"D3","v":11000},{"$f":"E3","v":370},{"$f":"F3","v":690},{"$f":"G3","v":69},690,{"$f":"-C15/2-C14/2","v":-25},16800000,0,{"$f":"(D14*(C14/1000)^3/12+D14*C14/1000*(I14/1000)^2)*1000","v":{"v":231.00000000000003,"d":"231.00"}},{"$f":"(E14*(C14/1000)^3/12+E14*C14/1000*(I14/1000)^2)*1000","v":{"v":7.7700000000000005,"d":"7.77"}},{"v":28.980000000000004,"d":"28.98"},206.25000000000006,-19.999999999999996,5.7971014492753605,6.937500000000001,-19.999999999999996,57.9710144927536,330,11.1,20.7,24000,0,null,{"v":12851439.714907417,"d":"12851440"},0,{"v":18359.19959272488,"d":"18359"},0,null,4410000,0,6300,0]
[null,0,{"$f":"_xlfn.XLOOKUP(Input!$C$28,'CLT panel'!G4:G48,'CLT panel'!L4:L48,0)","v":20},{"$f":"E3","v":370},{"$f":"D3","v":11000},{"$f":"G3","v":69},{"$f":"F3","v":690},690,0,0,533333.3333333333,{"$f":"(D15*(C15/1000)^3/12)*1000","v":{"v":0.24666666666666667,"d":"0.25"}},{"$f":"E15*(C15/1000)^3/12*1000","v":{"v":7.333333333333334,"d":"7.33"}},{"v":0.9200000000000002,"d":"0.92"},0,-19.999999999999996,115.9420289855072,0,-19.999999999999996,11.59420289855072,7.4,220,13.8,0,16000,null,0,{"v":407982.213171664,"d":"407982"},0,{"v":12239.46639514992,"d":"12239"},null,0,140000,0,4200]
[null,3,{"$f":"C14","v":30},{"$f":"D3","v":11000},{"$f":"E3","v":370},{"$f":"F3","v":690},{"$f":"G3","v":69},690,{"$f":"C15/2+C16/2","v":25},16800000,0,{"$f":"(D16*(C16/1000)^3/12+D16*C16/1000*(I16/1000)^2)*1000","v":{"v":231.00000000000003,"d":"231.00"}},{"$f":"(E16*(C16/1000)^3/12+E16*C16/1000*(I16/1000)^2)*1000","v":{"v":7.7700000000000005,"d":"7.77"}},{"v":28.980000000000004,"d":"28.98"},206.25000000000006,0,5.7971014492753605,6.937500000000001,0,57.9710144927536,330,11.1,20.7,24000,0,null,{"v":12851439.714907417,"d":"12851440"},0,{"v":18359.19959272488,"d":"18359"},0,null,4410000,0,6300,0]
[null,5,{"$f":"C13","v":0},{"$f":"E3","v":370},{"$f":"D3","v":11000},{"$f":"G3","v":69},{"$f":"F3","v":690},690,{"$f":"I16+C16/2+C17/2","v":40},0,0,{"$f":"(D17*(C17/1000)^3/12+D17*C17/1000*(I17/1000)^2)*1000","v":{"v":0,"d":"0.00"}},{"$f":"(E17*(C17/1000)^3/12+E17*C17/1000*(I17/1000)^2)*1000","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},0,0,"",0,0,"",0,0,0,0,0,null,0,0,0,0,null,0,0,0,0]
[null,7,{"$f":"C12","v":0},{"$f":"D3","v":11000},{"$f":"E3","v":370},{"$f":"F3","v":690},{"$f":"G3","v":69},690,{"$f":"I17+C17/2+C18/2","v":40},0,0,{"$f":"(D18*(C18/1000)^3/12+D18*C18/1000*(I18/1000)^2)*1000","v":{"v":0,"d":"0.00"}},{"$f":"(E18*(C18/1000)^3/12+E18*C18/1000*(I18/1000)^2)*1000","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},0,0,"",0,0,"",0,0,0,0,0,null,0,0,0,0,null,0,0,0,0]
[null,9,{"$f":"C11","v":0},{"$f":"E3","v":370},{"$f":"D3","v":11000},{"$f":"G3","v":69},{"$f":"F3","v":690},690,{"$f":"I18+C18/2+C19/2","v":40},0,0,{"$f":"(D19*(C19/1000)^3/12+D19*C19/1000*(I19/1000)^2)*1000","v":{"v":0,"d":"0.00"}},{"$f":"(E19*(C19/1000)^3/12+E19*C19/1000*(I19/1000)^2)*1000","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},0,0,"",0,0,"",0,0,0,0,0,null,0,0,0,0,null,0,0,0,0]
[null,11,{"$f":"C10","v":0},{"$f":"D3","v":11000},{"$f":"E3","v":370},{"$f":"F3","v":690},{"$f":"G3","v":69},690,{"$f":"I19+C19/2+C20/2","v":40},0,0,{"$f":"(D20*(C20/1000)^3/12+D20*C20/1000*(I20/1000)^2)*1000","v":{"v":0,"d":"0.00"}},{"$f":"(E20*(C20/1000)^3/12+E20*C20/1000*(I20/1000)^2)*1000","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},0,0,"",0,0,"",0,0,0,0,0,null,0,0,0,0,null,0,0,0,0]
[null,"d=",{"$f":"SUM(C10:C20)","v":80},{"$nulls":6},{"$f":"SUM(J10:J20)","v":{"v":33600000,"d":"33600000.0"}},{"v":533333.3333333333,"d":"533333.33"},{"v":462.2466666666667,"d":"462.2"},{"v":22.873333333333335,"d":"22.87"},{"v":58.88000000000001,"d":"58.88"},{"v":412.5000000000001,"d":"412.50"},null,{"$f":"SUM(Q10:Q20)","v":{"v":127.53623188405793,"d":"127.54"}},{"$f":"SUM(R10:R20)","v":{"v":13.875000000000002,"d":"13.88"}},null,{"$f":"SUM(T10:T20)","v":{"v":127.53623188405791,"d":"127.54"}},{"v":667.4,"d":"667.40"},{"v":242.2,"d":"242.20"},{"v":55.2,"d":"55.20"},48000,16000,null,{"$f":"SUBTOTAL(109,J_MidSpan[jxx,i])","v":{"v":25702879.429814834,"d":"25702879"}},{"$f":"SUBTOTAL(109,J_MidSpan[Jy,i])","v":{"v":407982.213171664,"d":"407982"}},{"$f":"SUBTOTAL(109,A_MidSpan[AX])","v":{"v":36718.39918544976,"d":"36718"}},{"$f":"SUBTOTAL(109,A_MidSpan[AY])","v":{"v":12239.46639514992,"d":"12239"}},null,{"$f":"SUBTOTAL(109,J_Support[jxx,i])","v":8820000},{"$f":"SUBTOTAL(109,J_Support[Jy,i])","v":140000},{"$f":"SUBTOTAL(109,A_Support[AX])","v":12600},{"$f":"SUBTOTAL(109,A_Support[AY])","v":4200}]
[null,"1) Wenn keine Seitenverklebung vorhanden ist dann ist für die Drillsteifigkeit Bxy,i=0 anzusetzen",{"$nulls":9},{"$f":"L21/M21","v":{"v":20.20897697464296,"d":"20.21"}},{"$f":"M21/L21","v":{"v":0.04948296003576733,"d":"0.05"}}]
[{"$nulls":14},{"$f":"O21/R21","v":29.729729729729733}]
[]
[]
[]
[]
[]
[null,"Verwendete Formeln"]
[null,"siehe Wordfile",{"$nulls":3},"JA"]
[null,"Schmalseitenverklebung",null,"JA",null,"NEIN"]
[null,null,"Platten- und Scheibenberechnung"]
[null,null,"Plattenberechnung (Reissner-Mindlin)"]
[null,"Bx",{"$f":"L21/1000","v":{"v":0.46224666666666675,"d":"0.4622"}},0,0,0,0,0,0,0]
[null,"By",0,{"$f":"M21/1000","v":{"v":0.022873333333333336,"d":"0.023"}},0,0,0,0,0,0]
[null,"Bxy",0,0,{"$f":"IF(D31=\"JA\",N21/1000,0)","v":{"v":0.05888000000000001,"d":"0.059"}},0,0,0,0,0]
[null,"Sx",0,0,0,{"$f":"1/Q21*1000","v":{"v":7.840909090909093,"d":"7.841"}},0,0,0,0]
[null,"Sy",0,0,0,0,{"$f":"1/T21*1000","v":{"v":7.840909090909094,"d":"7.841"}},0,0,0]
[null,"Sxy",0,0,0,0,0,{"$f":"U21","v":{"v":667.4,"d":"667.400"}},0,0]
[null,"Dx",0,0,0,0,0,0,{"$f":"V21","v":{"v":242.2,"d":"242.200"}},0]
[null,"Dy",0,0,0,0,0,0,0,{"$f":"IF(D31=\"JA\",W21,0.25*W21)","v":{"v":55.2,"d":"55.200"}}]
[]
[null,"Querdehnzahlen werden mit 0 angesetzt"]

{"sheet":"sharp metal","index":8,"n_rows":14,"n_cols":8,"rows_kept":14,"hidden":true,"merged":[[1,1,1,3],[1,5,1,7]]}
[]
[null,"At support",{"$nulls":3},"At mid span"]
[]
[null,"INPUT L/4",{"$f":"Input!C41","v":"SHARP METAL + TBS MAX@a ≤ 100mm"},null,null,"INPUT L/2",{"$f":"Input!I41","v":"SHARP METAL + TBS MAX@a ≤ 100mm"}]
[null,"b",50,"mm",null,"b",50,"mm"]
[null,"n°",{"$f":"Input!$E$43","v":2},null,null,"n°",{"$f":"Input!$K$43","v":1}]
[null,"lef",{"$f":"MIN(0.9*1000,1000-10)","v":900},"mm",null,"lef",{"$f":"MIN(0.9*1000,1000-10)","v":900},"mm"]
[null,"kv,0,0",{"$f":"IF(C4=RefText_DB!$B$9,1.76,IF(C4=RefText_DB!$B$10,3.05,IF(C4=RefText_DB!$B$11,2.47,\"errore\")))","v":3.05},"N/mm3",null,"kv,0,0",{"$f":"IF(G4=RefText_DB!$B$9,1.76,IF(G4=RefText_DB!$B$10,3.05,IF(G4=RefText_DB!$B$11,2.47,\"errore\")))","v":3.05},"N/mm3"]
[null,"Kv,ser",{"$f":"C8*C7*C6*C5","v":274500},"N/mm  ",null,"Kv,ser",{"$f":"G8*G7*G6*G5","v":137250},"N/mm  "]
[]
[null,"fv,ref,k",{"$f":"IF(C4=RefText_DB!$B$9,0.81,IF(C4=RefText_DB!$B$10,1.72,IF(C4=RefText_DB!$B$11,1.02,\"ERRORE\")))","v":1.72},"N/mm2",null,"fv,ref,k",{"$f":"IF(G4=RefText_DB!$B$9,0.81,IF(G4=RefText_DB!$B$10,1.72,IF(G4=RefText_DB!$B$11,1.02,\"ERRORE\")))","v":1.72},"N/mm2"]
[null,"ρref,k",385,"kg/m3",null,"ρref,k",385,"kg/m3"]
[null,"ρ,k",{"$f":"MIN('Calculation Report'!C85,'Calculation Report'!C107)","v":350},"kg/m3",null,"ρ,k",{"$f":"MIN('Calculation Report'!C85,'Calculation Report'!C107)","v":350},"kg/m3"]
[null,"Fv,Rk",{"$f":"C5*C6*C7*C11*(C13/C12)^0.5","v":{"v":147596.0088152177,"d":"147596"}},"N",null,"Fv,Rk",{"$f":"G5*G6*G7*G11*(G13/G12)^0.5","v":{"v":73798.00440760885,"d":"73798"}},"N"]

{"sheet":"CLT panel","index":9,"n_rows":48,"n_cols":18,"rows_kept":48,"hidden":true}
[]
[null,"CLT"]
[null,null,"Prod","h","Layers","Layers (code)","Code","9","7","5","3","0","3'","5'","7'","9'"]
[null,null,"HASSLACHER",{"$f":"SUM(CLT[[#This Row],[9]:[9'']])","v":60},{"$f":"LEFT(CLT[[#This Row],[Layers (code)]],1)","v":"3"},3,{"$f":"_xlfn.CONCAT(D4, \"mm-\",F4,\"s\", \"-\",H4,\" \",I4,\" \",J4,\" \",K4,\" \",L4,\" \",M4,\" \",N4,\" \",O4,\" \",P4)","v":"60mm-3s-   20 20 20   "},{"$nulls":3},20,20,20]
[null,null,"HASSLACHER",{"$f":"SUM(CLT[[#This Row],[9]:[9'']])","v":80},{"$f":"LEFT(CLT[[#This Row],[Layers (code)]],1)","v":"3"},3,{"$f":"_xlfn.CONCAT(D5, \"mm-\",F5, \"-\",H5,\" \",I5,\" \",J5,\" \",K5,\" \",L5,\" \",M5,\" \",N5,\" \",O5,\" \",P5)","v":"80mm-3-   20 40 20   "},{"$nulls":3},20,40,20]
[null,null,"STORA",{"$f":"SUM(CLT[[#This Row],[9]:[9'']])","v":80},{"$f":"LEFT(CLT[[#This Row],[Layers (code)]],1)","v":"3"},3,"80mm-3-   30 20 30   ",{"$nulls":3},30,20,30]
[null,null,"HASSLACHER",{"$f":"SUM(CLT[[#This Row],[9]:[9'']])","v":90},{"$f":"LEFT(CLT[[#This Row],[Layers (code)]],1)","v":"3"},3,"90mm-3-   30 30 30   ",{"$nulls":3},30,30,30]
[null,null,"HASSLACHER",{"$f":"SUM(CLT[[#This Row],[9]:[9'']])","v":100},{"$f":"LEFT(CLT[[#This Row],[Layers (code)]],1)","v":"3"},3,"100mm-3-   30 40 30   ",{"$nulls":3},30,40,30,{"$nulls":4},"80308030803080"]
[null,null,"HASSLACHER",{"$f":"SUM(CLT[[#This Row],[9]:[9'']])","v":120},{"$f":"LEFT(CLT[[#This Row],[Layers (code)]],1)","v":"3"},3,"120mm-3-   40 40 40   ",{"$nulls":3},40,40,40,{"$nulls":4},"80308030803080"]
[null,null,"HASSLACHER",{"$f":"SUM(CLT[[#This Row],[9]:[9'']])","v":100},{"$f":"LEFT(CLT[[#This Row],[Layers (code)]],1)","v":"5"},5,"100mm-5-  20 20 20 20 20  ",null,null,20,20,20,20,20]
[null,null,"HASSLACHER",{"$f":"SUM(CLT[[#This Row],[9]:[9'']])","v":120},{"$f":"LEFT(CLT[[#This Row],[Layers (code)]],1)","v":"5"},5,"120mm-5-  30 20 20 20 30  ",null,null,30,20,20,20,30]
[null,null,"HASSLACHER",{"$f":"SUM(CLT[[#This Row],[9]:[9'']])","v":140},{"$f":"LEFT(CLT[[#This Row],[Layers (code)]],1)","v":"5"},5,"140mm-5-  40 20 20 20 40  ",null,null,40,20,20,20,40]
[null,null,"BINDER",{"$f":"SUM(CLT[[#This Row],[9]:[9'']])","v":160},{"$f":"LEFT(CLT[[#This Row],[Layers (code)]],1)","v":"5"},5,"160mm-5-  40 20 40 20 40  ",null,null,40,20,40,20,40,{"$nulls":3},{"$f":"_xlfn.CONCAT(H13,,I13,J13,K13,L13,M13,N13,O13,P13,Q13)","v":"4020402040"}]
[null,null,"RUBNER",{"$f":"SUM(CLT[[#This Row],[9]:[9'']])","v":160},{"$f":"LEFT(CLT[[#This Row],[Layers (code)]],1)","v":"5"},5,"160mm-5-  30 30 40 30 30  ",null,null,30,30,40,30,30,{"$nulls":3},"3030403030"]
[null,null,"KLH",{"$f":"SUM(CLT[[#This Row],[9]:[9'']])","v":170},{"$f":"LEFT(CLT[[#This Row],[Layers (code)]],1)","v":"5"},5,"170mm-5-  40 30 30 30 40  ",null,null,40,30,30,30,40,{"$nulls":3},"4030303040"]
[null,null,"RUBNER",{"$f":"SUM(CLT[[#This Row],[9]:[9'']])","v":170},{"$f":"LEFT(CLT[[#This Row],[Layers (code)]],1)","v":"5"},5,"170mm-5-  30 40 30 40 30  ",null,null,30,40,30,40,30,{"$nulls":3},"3040304030"]
[null,null,"HASSLACHER",{"$f":"SUM(CLT[[#This Row],[9]:[9'']])","v":180},{"$f":"LEFT(CLT[[#This Row],[Layers (code)]],1)","v":"5"},5,"180mm-5-  40 30 40 30 40  ",null,null,40,30,40,30,40,{"$nulls":3},"4030403040"]
[null,null,"KLH",{"$f":"SUM(CLT[[#This Row],[9]:[9'']])","v":180},{"$f":"LEFT(CLT[[#This Row],[Layers (code)]],1)","v":"7"},7,"180mm-7- 20 40 20 20 20 40 20 ",null,20,40,20,20,20,40,20,null,null,"20402020204020"]
[null,null,"RUBNER",{"$f":"SUM(CLT[[#This Row],[9]:[9'']])","v":180},{"$f":"LEFT(CLT[[#This Row],[Layers (code)]],1)","v":"7"},7,"180mm-7- 30 20 30 20 30 20 30 ",null,30,20,30,20,30,20,30,null,null,"30203020302030"]
[null,null,"KLH",{"$f":"SUM(CLT[[#This Row],[9]:[9'']])","v":190},{"$f":"LEFT(CLT[[#This Row],[Layers (code)]],1)","v":"5"},5,"190mm-5-  40 40 30 40 40  ",null,null,40,40,30,40,40,{"$nulls":3},"4040304040"]
[null,null,"BINDER",{"$f":"SUM(CLT[[#This Row],[9]:[9'']])","v":200},{"$f":"LEFT(CLT[[#This Row],[Layers (code)]],1)","v":"5"},5,"200mm-5-  60 20 40 20 60  ",null,null,60,20,40,20,60,{"$nulls":3},"6020402060"]
[null,null,"HASSLACHER",{"$f":"SUM(CLT[[#This Row],[9]:[9'']])","v":200},{"$f":"LEFT(CLT[[#This Row],[Layers (code)]],1)","v":"5"},5,"200mm-5-  40 40 40 40 40  ",null,null,40,40,40,40,40,{"$nulls":3},"4040404040"]
[null,null,"HASSLACHER",{"$f":"SUM(CLT[[#This Row],[9]:[9'']])","v":200},{"$f":"LEFT(CLT[[#This Row],[Layers (code)]],1)","v":"7"},7,"200mm-7- 30 30 30 20 30 30 30 ",null,30,30,30,20,30,30,30,null,null,"30303020303030"]
[null,null,"STORA",{"$f":"SUM(CLT[[#This Row],[9]:[9'']])","v":200},{"$f":"LEFT(CLT[[#This Row],[Layers (code)]],1)","v":"7"},7,"200mm-7- 20 40 20 40 20 40 20 ",null,20,40,20,40,20,40,20,null,null,"20402040204020"]
[null,null,"HASSLACHER",{"$f":"SUM(CLT[[#This Row],[9]:[9'']])","v":210},{"$f":"LEFT(CLT[[#This Row],[Layers (code)]],1)","v":"7"},7,"210mm-7- 30 30 30 30 30 30 30 ",null,30,30,30,30,30,30,30,null,null,"30303030303030"]
[null,null,"HASSLACHER",{"$f":"SUM(CLT[[#This Row],[9]:[9'']])","v":210},{"$f":"LEFT(CLT[[#This Row],[Layers (code)]],1)","v":"7"},"7s","210mm-7s-  60 30 30 30 60  ",null,null,60,30,30,30,60,{"$nulls":3},"6030303060"]
[null,null,"BINDER",{"$f":"SUM(CLT[[#This Row],[9]:[9'']])","v":220},{"$f":"LEFT(CLT[[#This Row],[Layers (code)]],1)","v":"5"},5,"220mm-5-  60 30 40 30 60  ",null,null,60,30,40,30,60,{"$nulls":3},"6030403060"]
[null,null,"HASSLACHER",{"$f":"SUM(CLT[[#This Row],[9]:[9'']])","v":220},{"$f":"LEFT(CLT[[#This Row],[Layers (code)]],1)","v":"7"},7,"220mm-7- 40 40 20 20 20 40 40 ",null,40,40,20,20,20,40,40,null,null,"40402020204040"]
[null,null,"KLH",{"$f":"SUM(CLT[[#This Row],[9]:[9'']])","v":220},{"$f":"LEFT(CLT[[#This Row],[Layers (code)]],1)","v":"7"},7,"220mm-7- 30 40 30 20 30 40 30 ",null,30,40,30,20,30,40,30,null,null,"30403020304030"]
[null,null,"KLH",{"$f":"SUM(CLT[[#This Row],[9]:[9'']])","v":220},{"$f":"LEFT(CLT[[#This Row],[Layers (code)]],1)","v":"7"},"7s","220mm-7s-  80 20 20 20 80  ",null,null,80,20,20,20,80,{"$nulls":3},"8020202080"]
[null,null,"MM",{"$f":"SUM(CLT[[#This Row],[9]:[9'']])","v":220},{"$f":"LEFT(CLT[[#This Row],[Layers (code)]],1)","v":"7"},7,"220mm-7- 40 20 40 20 40 20 40 ",null,40,20,40,20,40,20,40,null,null,"40204020402040"]
[null,null,"HASSLACHER",{"$f":"SUM(CLT[[#This Row],[9]:[9'']])","v":240},{"$f":"LEFT(CLT[[#This Row],[Layers (code)]],1)","v":"7"},7,"240mm-7- 40 40 20 40 20 40 40 ",null,40,40,20,40,20,40,40,null,null,"40402040204040"]
[null,null,"KLH",{"$f":"SUM(CLT[[#This Row],[9]:[9'']])","v":240},{"$f":"LEFT(CLT[[#This Row],[Layers (code)]],1)","v":"7"},7,"240mm-7- 30 40 30 40 30 40 30 ",null,30,40,30,40,30,40,30,null,null,"30403040304030"]
[null,null,"MM",{"$f":"SUM(CLT[[#This Row],[9]:[9'']])","v":240},{"$f":"LEFT(CLT[[#This Row],[Layers (code)]],1)","v":"7"},7,"240mm-7- 40 20 40 40 40 20 40 ",null,40,20,40,40,40,20,40,null,null,"40204040402040"]
[null,null,"MM",{"$f":"SUM(CLT[[#This Row],[9]:[9'']])","v":240},{"$f":"LEFT(CLT[[#This Row],[Layers (code)]],1)","v":"7"},"7s","240mm-7s-  80 20 40 20 80  ",null,null,80,20,40,20,80,{"$nulls":3},"8020402080"]
[null,null,"XLAM DOLOMITI",{"$f":"SUM(CLT[[#This Row],[9]:[9'']])","v":252},{"$f":"LEFT(CLT[[#This Row],[Layers (code)]],1)","v":"7"},7,"252mm-7- 33 40 33 40 33 40 33 ",null,33,40,33,40,33,40,33,null,null,"33403340334033"]
[null,null,"BINDER",{"$f":"SUM(CLT[[#This Row],[9]:[9'']])","v":260},{"$f":"LEFT(CLT[[#This Row],[Layers (code)]],1)","v":"5"},5,"260mm-5-  80 30 40 30 80  ",null,null,80,30,40,30,80,{"$nulls":3},"8030403080"]
[null,null,"HASSLACHER",{"$f":"SUM(CLT[[#This Row],[9]:[9'']])","v":260},{"$f":"LEFT(CLT[[#This Row],[Layers (code)]],1)","v":"7"},7,"260mm-7- 40 40 30 40 30 40 40 ",null,40,40,30,40,30,40,40,null,null,"40403040304040"]
[null,null,"HASSLACHER",{"$f":"SUM(CLT[[#This Row],[9]:[9'']])","v":260},{"$f":"LEFT(CLT[[#This Row],[Layers (code)]],1)","v":"7"},"7s","260mm-7s-  80 30 40 30 80  ",null,null,80,30,40,30,80,{"$nulls":3},"8030403080"]
[null,null,"HASSLACHER",{"$f":"SUM(CLT[[#This Row],[9]:[9'']])","v":280},{"$f":"LEFT(CLT[[#This Row],[Layers (code)]],1)","v":"7"},7,"280mm-7- 40 40 40 40 40 40 40 ",null,40,40,40,40,40,40,40,null,null,"40404040404040"]
[null,null,"MM",{"$f":"SUM(CLT[[#This Row],[9]:[9'']])","v":280},{"$f":"LEFT(CLT[[#This Row],[Layers (code)]],1)","v":"7"},"7s","280mm-7s-  80 40 40 40 80  ",null,null,80,40,40,40,80,{"$nulls":3},"8040404080"]
[null,null,"XLAM DOLOMITI",{"$f":"SUM(CLT[[#This Row],[9]:[9'']])","v":297},{"$f":"LEFT(CLT[[#This Row],[Layers (code)]],1)","v":"9"},9,"297mm-9-33 33 33 33 33 33 33 33 33",33,33,33,33,33,33,33,33,33,null,"333333333333333333"]
[null,null,"HASSLACHER",{"$f":"SUM(CLT[[#This Row],[9]:[9'']])","v":410},{"$f":"LEFT(CLT[[#This Row],[Layers (code)]],1)","v":"8"},"8s","410mm-8s-80 30 80 30 80 30 80  ",80,30,{"$f":"N43","v":80},{"$f":"M43","v":30},80,30,80,{"$nulls":3},"80308030803080"]
[null,null,"MM",{"$f":"SUM(CLT[[#This Row],[9]:[9'']])","v":300},{"$f":"LEFT(CLT[[#This Row],[Layers (code)]],1)","v":"9"},"9s","300mm-9s- 80 20 40 20 40 20 80 ",null,80,20,40,20,40,20,80,null,null,"80204020402080"]
[null,null,"PIVETEAU",{"$f":"SUM(CLT[[#This Row],[9]:[9'']])","v":320},{"$f":"LEFT(CLT[[#This Row],[Layers (code)]],1)","v":"9"},9,"320mm-9-40 30 40 30 40 30 40 30 40",40,30,40,30,40,30,40,30,40,null,"403040304030403040"]
[null,null,"PIVETEAU",{"$f":"SUM(CLT[[#This Row],[9]:[9'']])","v":340},{"$f":"LEFT(CLT[[#This Row],[Layers (code)]],1)","v":"9"},9,"340mm-9-40 40 40 30 40 30 40 40 40",40,40,40,30,40,30,40,40,40,null,"404040304030404040"]
[null,null,"PIVETEAU",{"$f":"SUM(CLT[[#This Row],[9]:[9'']])","v":360},{"$f":"LEFT(CLT[[#This Row],[Layers (code)]],1)","v":"9"},9,"360mm-9-40 40 40 40 40 40 40 40 40",40,40,40,40,40,40,40,40,40,null,"404040404040404040"]
[{"$nulls":4},{"$f":"LEFT(CLT[[#This Row],[Layers (code)]],1)","v":""},null,"USER DEFINED",{"$nulls":3},30,20,30]

{"sheet":"Dati","index":10,"n_rows":117,"n_cols":19,"rows_kept":117,"hidden":true,"merged":[[104,2,104,3],[105,3,105,4]]}
[]
["Tipo legno secondo EN338:2016, UNIEN14080:2013"]
["Classe","fm,k","ft,0,k","ft,90,k","fc,0,k","fc,90,k","fv,k","fr,k","E0,mean","E0,05","E90,mean","E90,05","Gmean","G05","Gr,mean","Gr,05","ρk","ρmean","γM"]
["GL20h - UNI EN14080:2013",20,16,0.5,20,2.5,3.5,1.2,8400,7000,300,250,650,540,65,54,340,370,{"$f":"IF(LEFT(TimberType[[#This Row],[Classe]])=\"GL\",IF(Input!$I$5=RefText_DB!$B$4,1.25,1.45),IF(Input!$I$5=RefText_DB!$B$4,1.3,1.5))","v":1.3}]
["GL22h - UNI EN14080:2013",22,17.6,0.5,22,2.5,3.5,1.2,10500,8800,300,250,650,540,65,54,370,410,{"$f":"IF(LEFT(TimberType[[#This Row],[Classe]])=\"GL\",IF(Input!$I$5=RefText_DB!$B$4,1.25,1.45),IF(Input!$I$5=RefText_DB!$B$4,1.3,1.5))","v":1.3}]
["GL24h - UNI EN14080:2013",24,19.2,0.5,24,2.5,3.5,1.2,11500,9600,300,250,650,540,65,54,385,420,{"$f":"IF(LEFT(TimberType[[#This Row],[Classe]])=\"GL\",IF(Input!$I$5=RefText_DB!$B$4,1.25,1.45),IF(Input!$I$5=RefText_DB!$B$4,1.3,1.5))","v":1.3}]
["GL26h - UNI EN14080:2013",26,20.8,0.5,26,2.5,3.5,1.2,12100,10100,300,250,650,540,65,54,405,445,{"$f":"IF(LEFT(TimberType[[#This Row],[Classe]])=\"GL\",IF(Input!$I$5=RefText_DB!$B$4,1.25,1.45),IF(Input!$I$5=RefText_DB!$B$4,1.3,1.5))","v":1.3}]
["GL28h - UNI EN14080:2013",28,22.3,0.5,28,2.5,3.5,1.2,12600,10500,300,250,650,540,65,54,425,460,{"$f":"IF(LEFT(TimberType[[#This Row],[Classe]])=\"GL\",IF(Input!$I$5=RefText_DB!$B$4,1.25,1.45),IF(Input!$I$5=RefText_DB!$B$4,1.3,1.5))","v":1.3}]
["GL30h - UNI EN14080:2013",30,24,0.5,30,2.5,3.5,1.2,13600,11300,300,250,650,540,65,54,430,480,{"$f":"IF(LEFT(TimberType[[#This Row],[Classe]])=\"GL\",IF(Input!$I$5=RefText_DB!$B$4,1.25,1.45),IF(Input!$I$5=RefText_DB!$B$4,1.3,1.5))","v":1.3}]
["GL32h - UNI EN14080:2013",32,25.6,0.5,32,2.5,3.5,1.2,14200,11800,300,250,650,540,65,54,440,490,{"$f":"IF(LEFT(TimberType[[#This Row],[Classe]])=\"GL\",IF(Input!$I$5=RefText_DB!$B$4,1.25,1.45),IF(Input!$I$5=RefText_DB!$B$4,1.3,1.5))","v":1.3}]
["GL20c - UNI EN14080:2013",20,15,0.5,18.5,2.5,3.5,1.2,10400,8600,300,250,650,540,65,54,355,390,{"$f":"IF(LEFT(TimberType[[#This Row],[Classe]])=\"GL\",IF(Input!$I$5=RefText_DB!$B$4,1.25,1.45),IF(Input!$I$5=RefText_DB!$B$4,1.3,1.5))","v":1.3}]
["GL22c - UNI EN14080:2013",22,16,0.5,20,2.5,3.5,1.2,10400,8600,300,250,650,540,65,54,355,390,{"$f":"IF(LEFT(TimberType[[#This Row],[Classe]])=\"GL\",IF(Input!$I$5=RefText_DB!$B$4,1.25,1.45),IF(Input!$I$5=RefText_DB!$B$4,1.3,1.5))","v":1.3}]
["GL24c - UNI EN14080:2013",24,17,0.5,21.5,2.5,3.5,1.2,11000,9100,300,250,650,540,65,54,365,400,{"$f":"IF(LEFT(TimberType[[#This Row],[Classe]])=\"GL\",IF(Input!$I$5=RefText_DB!$B$4,1.25,1.45),IF(Input!$I$5=RefText_DB!$B$4,1.3,1.5))","v":1.3}]
["GL26c - UNI EN14080:2013",26,19,0.5,23.5,2.5,3.5,1.2,12000,10000,300,250,650,540,65,54,385,420,{"$f":"IF(LEFT(TimberType[[#This Row],[Classe]])=\"GL\",IF(Input!$I$5=RefText_DB!$B$4,1.25,1.45),IF(Input!$I$5=RefText_DB!$B$4,1.3,1.5))","v":1.3}]
["GL28c - UNI EN14080:2013",28,19.5,0.5,24,2.5,3.5,1.2,12500,10400,300,250,650,540,65,54,390,420,{"$f":"IF(LEFT(TimberType[[#This Row],[Classe]])=\"GL\",IF(Input!$I$5=RefText_DB!$B$4,1.25,1.45),IF(Input!$I$5=RefText_DB!$B$4,1.3,1.5))","v":1.3}]
["GL30c - UNI EN14080:2013",30,19.5,0.5,24.5,2.5,3.5,1.2,13000,10800,300,250,650,540,65,54,390,430,{"$f":"IF(LEFT(TimberType[[#This Row],[Classe]])=\"GL\",IF(Input!$I$5=RefText_DB!$B$4,1.25,1.45),IF(Input!$I$5=RefText_DB!$B$4,1.3,1.5))","v":1.3}]
["GL32c - UNI EN14080:2013",32,19.5,0.5,24.5,2.5,3.5,1.2,13500,11200,300,250,650,540,65,54,400,440,{"$f":"IF(LEFT(TimberType[[#This Row],[Classe]])=\"GL\",IF(Input!$I$5=RefText_DB!$B$4,1.25,1.45),IF(Input!$I$5=RefText_DB!$B$4,1.3,1.5))","v":1.3}]
["C18 - EN338:2016",18,10,0.4,18,2.2,3.4,1.2,9000,6000,null,null,560,{"$nulls":3},320,380,{"$f":"IF(LEFT(TimberType[[#This Row],[Classe]])=\"GL\",IF(Input!$I$5=RefText_DB!$B$4,1.25,1.45),IF(Input!$I$5=RefText_DB!$B$4,1.3,1.5))","v":1.3}]
["C20 - EN338:2016",20,11.5,0.4,19,2.3,3.6,1.2,9500,6400,null,null,590,{"$nulls":3},330,400,{"$f":"IF(LEFT(TimberType[[#This Row],[Classe]])=\"GL\",IF(Input!$I$5=RefText_DB!$B$4,1.25,1.45),IF(Input!$I$5=RefText_DB!$B$4,1.3,1.5))","v":1.3}]
["C22 - EN338:2016",22,13,0.4,20,2.4,3.8,1.2,10000,6700,null,null,630,{"$nulls":3},340,410,{"$f":"IF(LEFT(TimberType[[#This Row],[Classe]])=\"GL\",IF(Input!$I$5=RefText_DB!$B$4,1.25,1.45),IF(Input!$I$5=RefText_DB!$B$4,1.3,1.5))","v":1.3}]
["C24 - EN338:2016",24,14.5,0.4,21,2.5,4,1.2,11000,7400,370,null,690,{"$nulls":3},350,420,{"$f":"IF(LEFT(TimberType[[#This Row],[Classe]])=\"GL\",IF(Input!$I$5=RefText_DB!$B$4,1.25,1.45),IF(Input!$I$5=RefText_DB!$B$4,1.3,1.5))","v":1.3}]
["C27 - EN338:2016",27,16.5,0.4,22,2.5,4,1.2,11500,7700,null,null,720,{"$nulls":3},360,430,{"$f":"IF(LEFT(TimberType[[#This Row],[Classe]])=\"GL\",IF(Input!$I$5=RefText_DB!$B$4,1.25,1.45),IF(Input!$I$5=RefText_DB!$B$4,1.3,1.5))","v":1.3}]
["C30 - EN338:2016",30,19,0.4,24,2.7,4,1.2,12000,8000,400,null,750,{"$nulls":3},380,460,{"$f":"IF(LEFT(TimberType[[#This Row],[Classe]])=\"GL\",IF(Input!$I$5=RefText_DB!$B$4,1.25,1.45),IF(Input!$I$5=RefText_DB!$B$4,1.3,1.5))","v":1.3}]
["D24 - EN338:2016",24,14,0.6,21,4.9,3.7,1.2,10000,8400,null,null,630,{"$nulls":3},485,580,{"$f":"IF(LEFT(TimberType[[#This Row],[Classe]])=\"GL\",IF(Input!$I$5=RefText_DB!$B$4,1.25,1.45),IF(Input!$I$5=RefText_DB!$B$4,1.3,1.5))","v":1.3}]
["D30 - EN338:2016",30,18,0.6,24,5.3,3.9,1.2,11000,9200,null,null,690,{"$nulls":3},530,640,{"$f":"IF(LEFT(TimberType[[#This Row],[Classe]])=\"GL\",IF(Input!$I$5=RefText_DB!$B$4,1.25,1.45),IF(Input!$I$5=RefText_DB!$B$4,1.3,1.5))","v":1.3}]
["UNI - Castagno S",28,17,0.5,22,3.8,2,1.2,11000,8000,null,null,950,{"$nulls":3},465,550,{"$f":"IF(LEFT(TimberType[[#This Row],[Classe]])=\"GL\",IF(Input!$I$5=RefText_DB!$B$4,1.25,1.45),IF(Input!$I$5=RefText_DB!$B$4,1.3,1.5))","v":1.3}]
["UNI - Querce cad. S",42,25,0.8,27,5.7,4,1.2,12000,10100,null,null,750,{"$nulls":3},760,825,{"$f":"IF(LEFT(TimberType[[#This Row],[Classe]])=\"GL\",IF(Input!$I$5=RefText_DB!$B$4,1.25,1.45),IF(Input!$I$5=RefText_DB!$B$4,1.3,1.5))","v":1.3}]
["UNI - Pioppo Ontano S",26,16,0.4,22,3.2,2.7,1.2,8000,6700,null,null,500,{"$nulls":3},420,460,{"$f":"IF(LEFT(TimberType[[#This Row],[Classe]])=\"GL\",IF(Input!$I$5=RefText_DB!$B$4,1.25,1.45),IF(Input!$I$5=RefText_DB!$B$4,1.3,1.5))","v":1.3}]
["UNI - Altre latifoglie S",27,16,0.5,22,3.9,2,1.2,11500,8400,null,null,720,{"$nulls":3},515,560,{"$f":"IF(LEFT(TimberType[[#This Row],[Classe]])=\"GL\",IF(Input!$I$5=RefText_DB!$B$4,1.25,1.45),IF(Input!$I$5=RefText_DB!$B$4,1.3,1.5))","v":1.3}]
["UNI - Abete Nord S1",29,17,0.4,23,2.9,3,1.2,12000,8000,null,null,750,{"$nulls":3},380,415,{"$f":"IF(LEFT(TimberType[[#This Row],[Classe]])=\"GL\",IF(Input!$I$5=RefText_DB!$B$4,1.25,1.45),IF(Input!$I$5=RefText_DB!$B$4,1.3,1.5))","v":1.3}]
["UNI - Abete Nord S2",23,14,0.4,20,2.9,2.5,1.2,10500,7000,null,null,660,{"$nulls":3},380,415,{"$f":"IF(LEFT(TimberType[[#This Row],[Classe]])=\"GL\",IF(Input!$I$5=RefText_DB!$B$4,1.25,1.45),IF(Input!$I$5=RefText_DB!$B$4,1.3,1.5))","v":1.3}]
["UNI - Abete Nord S3",17,10,0.4,18,2.9,1.9,1.2,9500,6400,null,null,590,{"$nulls":3},380,415,{"$f":"IF(LEFT(TimberType[[#This Row],[Classe]])=\"GL\",IF(Input!$I$5=RefText_DB!$B$4,1.25,1.45),IF(Input!$I$5=RefText_DB!$B$4,1.3,1.5))","v":1.3}]
["UNI - Abete Centro-Sud S1",32,19,0.3,24,2.1,3.2,1.2,11000,7400,null,null,690,{"$nulls":3},280,305,{"$f":"IF(LEFT(TimberType[[#This Row],[Classe]])=\"GL\",IF(Input!$I$5=RefText_DB!$B$4,1.25,1.45),IF(Input!$I$5=RefText_DB!$B$4,1.3,1.5))","v":1.3}]
["UNI - Abete Centro-Sud S2",28,17,0.3,22,2.1,2.9,1.2,10000,6700,null,null,630,{"$nulls":3},280,305,{"$f":"IF(LEFT(TimberType[[#This Row],[Classe]])=\"GL\",IF(Input!$I$5=RefText_DB!$B$4,1.25,1.45),IF(Input!$I$5=RefText_DB!$B$4,1.3,1.5))","v":1.3}]
["UNI - Abete Centro-Sud S3",21,13,0.3,20,2.1,2.3,1.2,9500,6400,null,null,590,{"$nulls":3},280,305,{"$f":"IF(LEFT(TimberType[[#This Row],[Classe]])=\"GL\",IF(Input!$I$5=RefText_DB!$B$4,1.25,1.45),IF(Input!$I$5=RefText_DB!$B$4,1.3,1.5))","v":1.3}]
["UNI - Larice S1",42,25,0.6,27,4,4,1.2,13000,8700,null,null,810,{"$nulls":3},550,600,{"$f":"IF(LEFT(TimberType[[#This Row],[Classe]])=\"GL\",IF(Input!$I$5=RefText_DB!$B$4,1.25,1.45),IF(Input!$I$5=RefText_DB!$B$4,1.3,1.5))","v":1.3}]
["UNI - Larice S2",32,19,0.6,24,4,3.2,1.2,12000,8000,null,null,750,{"$nulls":3},550,600,{"$f":"IF(LEFT(TimberType[[#This Row],[Classe]])=\"GL\",IF(Input!$I$5=RefText_DB!$B$4,1.25,1.45),IF(Input!$I$5=RefText_DB!$B$4,1.3,1.5))","v":1.3}]
["UNI - Larice S3",26,16,0.6,22,4,2.7,1.2,11500,7700,null,null,720,{"$nulls":3},550,600,{"$f":"IF(LEFT(TimberType[[#This Row],[Classe]])=\"GL\",IF(Input!$I$5=RefText_DB!$B$4,1.25,1.45),IF(Input!$I$5=RefText_DB!$B$4,1.3,1.5))","v":1.3}]
["UNI - Douglasia S1",40,24,0.4,26,2.6,4,1.2,14000,9400,null,null,880,{"$nulls":3},400,435,{"$f":"IF(LEFT(TimberType[[#This Row],[Classe]])=\"GL\",IF(Input!$I$5=RefText_DB!$B$4,1.25,1.45),IF(Input!$I$5=RefText_DB!$B$4,1.3,1.5))","v":1.3}]
["UNI - Douglasia S2/3",23,14,0.4,20,2.6,3.4,1.2,12500,8400,null,null,780,{"$nulls":3},420,455,{"$f":"IF(LEFT(TimberType[[#This Row],[Classe]])=\"GL\",IF(Input!$I$5=RefText_DB!$B$4,1.25,1.45),IF(Input!$I$5=RefText_DB!$B$4,1.3,1.5))","v":1.3}]
["UNI - Altre conifere S1",33,20,0.5,24,4,3.3,1.2,12300,8200,null,null,770,{"$nulls":3},530,575,{"$f":"IF(LEFT(TimberType[[#This Row],[Classe]])=\"GL\",IF(Input!$I$5=RefText_DB!$B$4,1.25,1.45),IF(Input!$I$5=RefText_DB!$B$4,1.3,1.5))","v":1.3}]
["UNI - Altre conifere S2",26,16,0.5,22,4,2.7,1.2,11400,7600,null,null,710,{"$nulls":3},530,575,{"$f":"IF(LEFT(TimberType[[#This Row],[Classe]])=\"GL\",IF(Input!$I$5=RefText_DB!$B$4,1.25,1.45),IF(Input!$I$5=RefText_DB!$B$4,1.3,1.5))","v":1.3}]
["UNI - Altre conifere S3",22,13,0.5,20,4,2.4,1.2,10500,7000,null,null,660,{"$nulls":3},530,575,{"$f":"IF(LEFT(TimberType[[#This Row],[Classe]])=\"GL\",IF(Input!$I$5=RefText_DB!$B$4,1.25,1.45),IF(Input!$I$5=RefText_DB!$B$4,1.3,1.5))","v":1.3}]
[]
["sovraccarico variabile (a tendina)"]
[null,"valore kN/m2","y2 (compare nella finestra parametri)"]
["A: ambienti ad uso residenziale",2,0.3,1]
["B1: uffici non aperti al pubblico",2,0.3,2]
["B2: uffici aperti al pubblico",3,0.3,3]
["C1: ospedali, ristoranti, caffè, scuole",3,0.6,4]
["C2: balconi, ballatoi, scale, cinema, teatri",4,0.6,5]
["C3: musei, sale da ballo, stazioni",5,0.6,6]
["D1: negozi",4,0.6,7]
["D2: centri commerciali",5,0.6,8]
["E1: Biblioteche, archivi, magazzini",6,0.8,9]
["F: rimesse e parcheggi  (max 30 kN)",2.5,0.6,10]
["H1: Coperture e sottotetti non accessibili",0.5,0,11]
[]
["Valori di kmod"]
[]
[]
[{"$nulls":8},"CS","Permanent","Long term","Medium term","Short term","Istantaneous"]
[{"$nulls":8},1,{"$f":"IF(Input!$I$5=\"UNI EN 1995:2015\",0.6,0.6)","v":0.6},{"$f":"IF(Input!$I$5=\"UNI EN 1995:2015\",0.7,0.7)","v":0.7},{"$f":"IF(Input!$I$5=\"UNI EN 1995:2015\",0.8,0.8)","v":0.8},{"$f":"IF(Input!$I$5=\"UNI EN 1995:2015\",0.9,0.9)","v":0.9},{"$f":"IF(Input!$I$5=\"UNI EN 1995:2015\",1.1,1.1)","v":1.1}]
[{"$nulls":8},2,{"$f":"IF(Input!$I$5=\"UNI EN 1995:2015\",0.6,0.6)","v":0.6},{"$f":"IF(Input!$I$5=\"UNI EN 1995:2015\",0.7,0.7)","v":0.7},{"$f":"IF(Input!$I$5=\"UNI EN 1995:2015\",0.8,0.8)","v":0.8},{"$f":"IF(Input!$I$5=\"UNI EN 1995:2015\",0.9,0.9)","v":0.9},{"$f":"IF(Input!$I$5=\"UNI EN 1995:2015\",1.1,1.1)","v":1.1}]
[{"$nulls":8},3,{"$f":"IF(Input!$I$5=\"UNI EN 1995:2015\",0.5,0.5)","v":0.5},{"$f":"IF(Input!$I$5=\"UNI EN 1995:2015\",0.55,0.55)","v":0.55},{"$f":"IF(Input!$I$5=\"UNI EN 1995:2015\",0.65,0.65)","v":0.65},{"$f":"IF(Input!$I$5=\"UNI EN 1995:2015\",0.7,0.7)","v":0.7},{"$f":"IF(Input!$I$5=\"UNI EN 1995:2015\",0.9,0.9)","v":0.9}]
[]
["Valori di kdef",{"$nulls":7},"CS","Quasi Permanenti"]
[{"$nulls":8},1,0.69]
[{"$nulls":8},2,0.89]
[{"$nulls":8},3,2]
[]
[{"$nulls":8},"γ","Description","UNI EN 1995:2014","NTC2018"]
[{"$nulls":8},"γM","Connections",1.3,1.5]
[{"$nulls":8},"γM,SLU,1",null,1.25,1.25,"per CLT da EC5:2025"]
[{"$nulls":8},"γM,SLU,2",null,1.25,1.45]
["Classe di durata del carico accidentale",{"$nulls":7},"γM1",null,1,1.05,"Instabilità"]
["Classe di durata",{"$nulls":7},"γM,2",null,1.25,1.25,"Sezione tesa"]
[{"$f":"INDEX(LEN_IN[],14,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Load duration"},1,{"$nulls":6},"γg",null,1.35,1.35]
[{"$f":"INDEX(LEN_IN[],15,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Permanent"},2,{"$nulls":6},"γq",null,1.5,1.5]
[{"$f":"INDEX(LEN_IN[],16,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Long term"},3]
[{"$f":"INDEX(LEN_IN[],17,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Medium term"},4]
[{"$f":"INDEX(LEN_IN[],18,MATCH(CONDITIONS!$E$3,Len_DB!$C$8:$H$8,0)+1)","v":"Short term"},5,{"$nulls":6},"Tipo pannello","ρk"]
[{"$nulls":8},"Compensato finlandese",410,1]
[{"$nulls":8},"Compensato americano",410,2]
[{"$nulls":8},"Compensato canadese",420,3]
[{"$nulls":8},"Pannelli di particelle e OSB",550,4]
[]
[]
["Tipo sezione cambrette"]
["Tonda",1]
["Rettangolare",2]
[]
["Tipo vite"]
["Diametro gambo liscio uguale a diametro esterno parte filettata",1]
["Diametro esterno parte filettata > diametro gambo liscio",2]
[]
["Valori di kef (chiodi)"]
[null,"no preforo","si preforo"]
["a1 >=14d",1,1,1]
["a1 = 10d",0.85,0.85,2]
["a1 = 7d",0.7,0.7,3]
["a1 = 4d","-",0.5,4]
[]
[]
[null,null,"no preforo"]
["DISTANZE MINIME","modo 1 e 4"," modo 2 e 5","Modo 3"]
[{"$nulls":3},"ρ<420 kg/m3","ρ>420 kg/m3"]
["a1",{"$f":"5*#REF!/COS(#REF!)","v":{"$error":"#REF!"}},{"$f":"5*#REF!","v":{"$error":"#REF!"}},{"$f":"(5+7)*#REF!","v":{"$error":"#REF!"}},{"$f":"(7+8)*#REF!","v":{"$error":"#REF!"}}]
["a2",null,{"$f":"5*#REF!","v":{"$error":"#REF!"}},{"$f":"5*#REF!","v":{"$error":"#REF!"}},{"$f":"5*#REF!","v":{"$error":"#REF!"}}]
["a1cg",null,{"$f":"10*#REF!","v":{"$error":"#REF!"}}]
["a2cg",null,{"$f":"4*#REF!","v":{"$error":"#REF!"}}]
["a4c",null,null,{"$f":"5*#REF!","v":{"$error":"#REF!"}},{"$f":"7*#REF!","v":{"$error":"#REF!"}}]
["a cross",{"$f":"1.5*#REF!","v":{"$error":"#REF!"}}]
[]
[]
[null,"Modo 1 ","Modo 2","Modo 3","Modo 4","Modo 5"]
["Larghezza minima travetto",{"$f":"IF(AND(#REF!,#REF!<420),D112*2+B113,E112*2+B113)","v":{"$error":"#REF!"}},{"$f":"IF(AND(#REF!,#REF!<420),D112*2+IF(Input!#REF!=2,Dati!C109,0),E112*2+IF(Input!#REF!=2,Dati!C109,0))","v":{"$error":"#REF!"}},{"$f":"IF(AND(#REF!,#REF!<420),D112*2+IF(Input!#REF!=2,Dati!D109,0),E112*2+IF(Input!#REF!=2,Dati!D109,0))","v":{"$error":"#REF!"}},{"$f":"B117","v":{"$error":"#REF!"}},{"$f":"C117","v":{"$error":"#REF!"}}]