.. _nonstd_output_xlsx: Non Std XLSX output =================== .. warning:: THIS SECTION (``source/nonstd_output.rst``) is to be deleted once its data will be rewritten to ``source/checkers_and_analysis.rst`` .. _bar_spreadsheet: Bar analysis output ------------------- This is a seven sheets spreadsheet generated to summarize key analysis data regarding bar **bending moment** or **shear force** comparative analysis: * :ref:`beam_properties `: sheet summarizing mechanical properties of all FE BAR elements of relevant structural item (ie: seat track, cross beam or Overwing beam) * :ref:`all_allowable `: sheet used to present allowable from each reference loading for all different mechanical properties * **allowable**: sheet summarizing the highest allowable for each different mechanical property * **MS**: main sheet presenting Margin of Safety calculation for all BAR elements of relevant structural item * **_crits_pre**: pre-selection of the most critical margin of safety per structural element * **critical_beams_envelope**: sheet used to present the lowest margin of safety * **MS_reduced**: sheet used to present a summary of the lowest margins of safety .. note:: Units are not specified in this spreadsheet. Values presented are in the unit system of the analysis. .. _beam_properties_sheet: "beam_properties" Sheet """"""""""""""""""""""""""" Before going into the output details presented in this sheet it is important to understand its overall structure. .. _all_allowable_sheet: "all_allowable" Sheet """"""""""""""""""""" Before going into the output details presented in this sheet it is important to understand its overall structure. As shown on :numref:`fig_xls_result_01` this sheet presents allowable for cross beams and seat tracks. For each Reference loading previously selected by the end user (see Running a new analysis :ref:`step2-3`), key data are presented. .. _fig_xls_result_01: .. figure:: ./_static/xls_result_01.png :align: center :width: 500pt :alt: all allowable sheet overview :figclass: align-center "all allowable" sheet overview *beam properties and identifcation* * **type**: crossbeam or rail * **area, I2, I3, J, E, nu**: mechanical properties of the beam. Respectively its cross sectional area, section inertia around its axis, torsional constant, Material Young modulus and Poisson's ratio. * **vbeam, vbeamid**: virtual beam label and its instance. For cross beam, each instance is a cross beam itself. Whereas for rail, a virtual beam is made of several instances. For more information on virtual beams see :ref:`vbeam_explained` *finite element results with reference loading selected* .. _fig_xls_result_04: .. figure:: ./_static/xls_result_04.png :align: center :alt: reference loading output :figclass: align-center reference loading allowable output (sheet "all allowable") * **pid**: property ID associated to the beam * **subcaseid**: subcase ID of the load case providing the highest bending moment on the beam .. warning:: The list of subcases is specific to each Reference loading and it doesn't correspond to the list of subcases defined by the en user for the installation being checked. * **value**: maximum bending moment reached on the beam at node A or B * **vbeamid**: ID of the virtual beam * **xrange**: range in X of the finite element belonging to the virtual beam on which the maximum bending moment has been reached. * **yrange**: range in Y of the finite element belonging to the virtual beam on which the maximum bending moment has been reached. .. note:: for cross beam the xrange indicates its location. For instance a range (1140, 1140] indicates that the cross beam is located at X=1140.0 inch in the aircraft coordinate system (see :numref:`fig_ac_coord_sys`). .. warning:: Cross beam location is defined in aircraft coordinate system. It shouldn't be mixed with Boeing station (for instance X=1140in is equivalent to STA930) .. _allowable_sheet: "allowable" sheet """"""""""""""""" The overall structure of this sheet is presented on the :numref:`fig_xls_result_02` .. _fig_xls_result_02: .. figure:: ./_static/xls_result_02.png :align: center :width: 500pt :alt: reduced_allowable_bending sheet overview :figclass: align-center "reduced_allowable_bending" sheet overview *beam properties and identifcation* * **type**: crossbeam or rail * **area, I2, I3, J, E, nu**: mechanical properties of the beam. Respectively its cross sectional area, section inertia around its axis, torsional constant, Material Young modulus and Poisson's ratio. * **vbeam, vbeamid**: virtual beam label and its instance. For cross beam, each instance is a cross beam itself. Whereas for rail, a virtual beam is made of several instances. For more information on virtual beams see :ref:`vbeam_explained` *finite element results on most critical beam with Reference loading* .. _fig_xls_result_05: .. figure:: ./_static/xls_result_05.png :align: center :alt: reference allowable :figclass: align-center enveloppe of reference loading allowable * **Beam Alw_reference**: identification of the standard seating configuration used for reference loading providing the highest bending moment on the beam * **Beam Alw_pid**: property ID of the corresponding beam * **Beam Alw_subcaseid** subcase ID of the load case providing the highest bending moment on the corresponding reference loading * **Beam Alw_value**: value of the highest bending moment reached on the beam of the corresponding reference loading * **Beam Alw_xrange**: range in X direction of the finite element belonging to the virtual beam on which the maximum bending moment has been reached with the corresponding reference loading * **Beam Alw_yrange**: range in Y direction of the finite element belonging to the virtual beam on which the maximum bending moment has been reached with the corresponding reference loading .. _bending_spreadsheet: "MS_bending" sheet """""""""""""""""" The overall structure of this sheet is presented on the :numref:`fig_xls_result_03` .. _fig_xls_result_03: .. figure:: ./_static/xls_result_03.png :align: center :width: 450pt :alt: MS_bending sheet overview :figclass: align-center "MS_bending" sheet overview *beam properties and identifcation* * **type**: crossbeam or rail * **area, I2, I3, J, E, nu**: mechanical properties of the beam. Respectively its cross sectional area, section inertia around its axis, torsional constant, Material Young modulus and Poisson's ratio. * **vbeam, vbeamid**: virtual beam label and its instance. For cross beam, each instance is a cross beam itself. Whereas for rail, a virtual beam is made of several instances. For more information on virtual beams see :ref:`vbeam_explained` *finite element results on checked model* The checked model is the finite element model of the selected floor structure configuration (see Running a new analysis :ref:`step1-3`) loaded with interface load of the installation to be checked (see Running a new analysis :ref:`step2-3`). .. _fig_xls_result_06: .. figure:: ./_static/xls_result_06.png :align: center :alt: reference allowable :figclass: align-center results on beam of checked model * **pid**: property ID of the corresponding beam * **value**: value of the maximum bending moment reached on the beam at node A or B * **xrange**: range in X direction of the finite element belonging to the virtual beam on which the maximum bending moment has been reached with the user defined loading * **yrange**: range in Y direction of the finite element belonging to the virtual beam on which the maximum bending moment has been reached with the user defined loading * **subcaseid**: load case ID corresponding to the list of load cases provided in the Loading file (see :ref:`sheet-lcids`) *beam allowable from Reference loading* The 6 columns underneath "Beam Alw" correspond exactly to the results columns of the "reduced_allowable_bending" sheet. They present the maximum bending moment reached on the beam with one of the Reference loading. This value is considered as the allowable for the beam itself. .. _fig_xls_result_07: .. figure:: ./_static/xls_result_07.png :align: center :alt: reference allowable :figclass: align-center beam allowable from reference loading *allowable from a beam of the same property ID* The 6 columns underneath "Mech Alw" summarize the maximum bending moment reached on one beam among all beams sharing the same mechanical properties (same pid). .. _fig_xls_result_08: .. figure:: ./_static/xls_result_08.png :align: center :alt: reference allowable :figclass: align-center mechanical allowable from reference loading * **vbeam**: virtual beam * **vbeamid**: virtual beam ID * **reference**: identification of the standard seating configuration used for reference loading providing the highest bending moment on a beam among all beams sharing the same mechanical properties (same pid) * **pid**: beam property ID * **subcaseid**: load case ID of the corresponding Reference loading * **value**: bending moment reached on one beam among all beams sharing the same mechanical properties (same pid) *Margin of Safety* Two different Margin of Safety are calculated and their maximum of is presented .. _fig_xls_result_09: .. figure:: ./_static/xls_result_09.png :align: center :alt: Margin of safety :figclass: align-center Margin of Safety * **beam**: the MS calculated in this column is based on a "beam to beam" comparison. The maximum bending moment reached on this beam is compared to the maximum allowable from a Reference loading reached on the same beam. :math:`MS_{beam}=\frac{value~of~col~R}{value~of~col~K}-1` * **mech**: the MS calculated in this column is based on a comparison between all beams of same mechanical properties. The maximum bending moment reached on this beam is compared to the maximum allowable reached on a beam of same mechanical properties. :math:`MS_{mech}=\frac{value~of~col~Z}{value~of~col~K}-1` * **max**: the maximum Margin of Safety of the two MS calculated is presented here. .. note:: Margin of Safety calculated here are relative MS as they compare two values, one from a reference loading (valid PAX seating configuration) and one from the installation to be checked. .. _shear_spreadsheet: Seat tracks and Cross beams Shear --------------------------------- This spreadsheet is a three sheets generated to summarize keys analysis data regarding cross beam and seat tracks **shear force**. See :ref:`bending_spreadsheet` for a detailed presentation of this spreadsheet as they share the exact same structure. Only the output value "bending moment" is replaced by "shear force"