.. _loading-input-data:

Loading Input Data
===================

The Loading file is an eleven sheets xlsx spreadsheet used to defined the seating installation and the floor Interface Loads. 


The standard Loading file template can be downloaded under the `Ressources <https://ftools.aero-sonix.com/support/index>`_ menu of the FTools software.
Two templates are available:

* `Loading_mmTs <https://ftools.aero-sonix.com/support/download_template/mmTs>`_ : loading template in metric units

* `Loading_ilbss <https://ftools.aero-sonix.com/support/download_template/ilbss>`_ : loading template in imperial units

Although data units in one spreadsheet can be mixed, a good practice is to use a consistent set of units.

Each template is made of 11 sheets: 


* :ref:`sheet-item_info`: definition of seats and monuments installed in the cabin

* :ref:`sheet-item_geom`: definition of seat / monument interface points location

* :ref:`sheet-item_asm`: location of seat / monument on cabin lopa

* :ref:`sheet-lcids`: definition of load cases

* :ref:`sheet-lcids_acc`: definition of load cases acceleration

* :ref:`sheet-lcids_comb`: definition of load case linear combination

* :ref:`sheet-item_loads`: specification of cabin seat / monument IFL

* :ref:`sheet-loading_references`: reference of IFL documents

* :ref:`sheet-lip_loading`: definition of seat track lip loading

* :ref:`sheet-std_alw`: specification of standard seat allowable 

* :ref:`sheet-meta`: specification of generic parameters

General guidance regarding user filled spreadsheet is presented at :ref:`filling-xlsx-spreadsheet`

Detailed description and filling instruction for each sheet can be found in the corresponding sheet section.

Once the Loading file is completely filled it can checked for basic mistakes with a `validator <https://ftools.aero-sonix.com/analysis/validator>`_

.. _fields-naming-conventions:

Fields Naming Conventions
--------------------------

Each sheet Columns (or Fields) will be presented as follows:

* :gray:`<SHEET>`-:orange:`<field>`: Mandatory field
* :gray:`<SHEET>`-:green:`<field>`: Padded field
* :gray:`<SHEET>`-<field>: Optional field

Where ``<SHEET>`` is the tab featuring the field, and ``<field>`` is the field name.
 

LOPA tabs relationships
-----------------------

XLSX tabs are linked together with *key* fields. A strong convention is that
such a key is labelled as ``<remote-tabname>::<remote-field>``. More details are provided in :ref:`Understanding sheets cross references <xls-cross_ref>`.

A summary of those relationships are shown Figure :numref:`fig_xls-relationships`.


.. _fig_xls-relationships:

.. figure:: ./_static/relationships.png
    :align: center
    :width: 100%
    :alt: LOPA tabs relationships
    :figclass: align-center

    LOPA tabs relationships (click to enlarge)


.. include:: .loading_input_data.inc