.. _general-presentation: General presentation ==================== .. _introduction: Introduction ------------- The FloorTools User Manual is written to provide guidance on how to perform a structural substantiation of seats and monuments installation on floor structure. A fully automated process has been encapsulated in the FloorTools software to enable a fast and efficient validation of various cabin seating configurations. Throughout this User Manual seating installations are classified in **"Standard"** (std) seat installation or **"Non-Standard"** (non-std) seat installation. .. _std_seat_instal: * **Standard seat installation** Standard seat installation refers to seating configuration covered by airplane OEM manuals. For instance, on a wide body aircraft, a 10 abreast (3-4-3) economy class seats installed with valid pitch can be classified as standard seat installation. .. _fig_PAX-ECO-view: .. figure:: ./_static/PAX_ECO_view.png :align: center :width: 500pt :alt: ECO Class seating :figclass: align-center Photo of typical standard seating installation (3-4-3 Economy Class) Standard seating installation is justified based on OEM requirements. Several criterion have to be fulfil to ensure a safe standard seat installation (seat interface load below OEM allowable, seat mass below floor structure running load allowable, etc...) . .. _non_std_seat_instal: * **Non-Standard seat installation** Non-Standard seat installation refers to seating configuration not covered by OEM specifications. Non-Standard seat installation is used generically to refer to seats and / or monuments installed on floor structure. Typically a non standard seating installation could be a business class configuration with seats and surrounding shells. In such an installation seats are often staggered (no straight row) and multiple interface loading from seats and surrounding monuments prevent the direct use of OEM requirements for passenger seat installation. .. _fig_AF-BC-view: .. figure:: ./_static/AF_BC_view.jpg :align: center :width: 500pt :alt: Business Class seating :figclass: align-center Photo of typical non standard seating installation (AF Business Class) The validation of non standard seating installation is mainly based on a comparative analysis with standard seating configuration. In the FloorTools several "critical" standard passenger seating configurations have been captured and used as Reference Loading. Those installations have been optimised to maximise the interface load applied on the floor structure whilst passing all the OEM requirements. .. warning:: In the current FTools version Non-Standard seat installation is restricted to Boeing B777-300 between STA382 (X=382in) and STA2033.50 (X=2432.5in). Only standard seat installation can be performed on Boeing B777-200. .. note:: Throughout this document the FloorTools software will be referred as FTools. FTools process overview ----------------------- Before starting an analysis, a review of the FTools general process could help to understand its mechanism. The FTools analysis is based on a three step process: 1. Validation of :ref:`loading-input-data` and its binding to a floor structure configuration (fsconf) 2. Definition of LOPA zone(s) to analyse and for :ref:`Non-Standard seat installation ` only, selection of loading reference(s) to use for comparative analysis 3. Launching the installation analysis Once the :ref:`loading-input-data` is validated the analysis can be launched and the FTools will run through its internal process shown in :numref:`fig_process-overview` .. _fig_process-overview: .. figure:: ./_static/process_overview.png :align: center :width: 500pt :alt: FTools process overview :figclass: align-center FTools process overview chart At the end of the internal process a result page appears with a Margin of Safety table summarising the most critical results and a list of downloadable output files. This list of available output files depends on the type of analysis performed (Standard / Non-Standard). Refer to :ref:`understand_output` for more information on FTools output files. .. note:: The granularity of the analysis type is a LOPA Zone. The type of analysis performed on a LOPA Zone is related to a user input :ref:`analysis field ` in the :ref:`loading-input-data`. .. warning:: The specification of one cabin item as `non-std` in a LOPA Zone triggers a Non-Standard analysis for the complete Zone. .. _filling-xlsx-spreadsheet: Filling an XLSX spreadsheet --------------------------- The input files of the FloorTools are in the format of XLSX spreadsheet. It offers a great flexibility and ease of inputting data although it requires some rules to follow. The FloorTools software is built to automatically read the XLS file provided. At a first stage a "validator" module will check that the expected data are found in the XLS file and that they have been input in the required format. This validator can also be used directly to check on input file independently (link to FTools `validator `_) **Some general rules about the XLS file filling** * column with header can't be deleted * default column header can't be renamed * data can't be entered in column with no header * calculation or comment can be added in a new column with a new header (the FloorTools reader will ignore it) * Line 1 and line 2 shouldn't be deleted * template sheets shouldn't be renamed * new sheet can be added (the FloorTools reader will ignore it) In each spreadsheet the first line is the line defining the field label. The second line is used to specify the data unit when relevant. In each cell of the column header a comment can be displayed to get information regarding the data type expected by the software. .. _fig_xls-info: .. figure:: ./_static/xls_info.png :align: center :width: 500pt :alt: spreadsheet information :figclass: align-center Input spreadsheet general information .. note:: When necessary, unit specified in line two of a data field can be modified to another consistent unit. For instance "in" can be modified to "mm" or "ft". .. _col_header_color: **Column header color code** Three different colors can be found in the cell of the column header: * orange for mandatory field * white for optional field * green for padded field .. _fig_xls-header_info: .. figure:: ./_static/xls_header_color.png :align: center :width: 300pt :alt: spreadsheet header color :figclass: align-center Input spreadsheet header color .. note:: Padded field means that the data doesn't have to be repeated on each line. The software reader automatically assumes that the entered data is repeated on the blank line below until a new entry is found. Here below is an example of padded entry: .. _fig_padding_example: .. figure:: ./_static/padding_example.png :align: center :width: 500pt :alt: padding example :figclass: align-center Example of padded entry .. warning:: If padded entry is used the first entry of the block can't be blank. For instance, on the example above, label in line 3 of the first padded entry can't be blank. .. _field_data_type: **Field data type** In each column header a comment is added to indicate the data type of the entry expected. For instance, in the example of :numref:`fig_field_type`, data entered in column B, "point_id" should be an integer number. This field data type information is also available in each field description information text. .. _fig_field_type: .. figure:: ./_static/field_type.png :align: center :width: 200pt :alt: field data type :figclass: align-center Example of field data type .. _xls-cross_ref: **Understanding sheets cross references** When filling the xlsx template one need to understand that some fields are linked between different sheets. Cross link fields are labelled with the combination of the "Sheet label" and "column label" separated by "::" .. figure:: ./_static/cross_ref_generic.png :align: center :width: 150pt :alt: xls cross reference :figclass: align-center For instance on :numref:`fig_xls_cross_references`, in sheet "item_asm" two cross reference fields are specified. In column C, "item_geom::point_id" refers to a 'point_id' of the sheet "item_geom". In column D, "item_info::label" is used to refer to a 'label' of the sheet "item_info". When a cross link field is specified, the data entered in the source sheet should perfectly match the label in the target sheet (it is case sensitive and there should not be any trailing space difference). For instance in "item_asm" sheet, 'S59' in cell D2 is exactly the label entered in sheet "item_info" cell B3. .. _fig_xls_cross_references: .. figure:: ./_static/xls_cross_references.png :align: center :width: 500pt :alt: xls cross references :figclass: align-center View of item_asm sheet cross references A general overview of relationships between tabs is shown Figure :numref:`fig_xls-relationships`.