CSV Files
Overview
All the input data in GRAPE can be imported and exported via .csv files. The following applies to all .csv files:
- import: the order of the columns must be respected.
- import: the delimiter will be detected based on the first 100 rows (
,, ; and tab supported).
- import: leading and trailing spaces, tabs and new lines will be stripped from names.
- import: the variable unit (if applicable) will be detected from the column name (e.g.
Weight (KG), Weight_kg and Weight##kG__ will all be interpreted as kg). If no unit is detected, the unit selected in the settings will be used. Check the conversion tables for the supported short name of each unit (case insensitive).
- import: the decimal separator must be a
..
- export: the first row will be set to the variables names including the variable unit if applicable (e.g.
Weight (kg))
Each of the following sections provides a description of the column order of each .csv known to GRAPE. If the column is mandatory, any row with an empty cell on that column will generate an error on import. The tables in the Datasets and Input Data sections can be imported/exported via the respective menus in the Edit section of the menu bar. Go through the menu to import/export any of the supported files. Clicking on the root nodes (Datasets or Input Data) will prompt the user to select a folder for which all of the respective files will be imported/exported. The root node All Files will import/export all files of both sections. The exported files will have the default names of each supported .csv, and when importing from a folder only this names will be recognized.
Info
The default names correspond to the names of the sections below (case sensitive).
The outputs section below describes tables containing output, which can only be exported. While all the input data can be imported and exported via the Edit menu, the output data can only be exported in the Scenarios panel, under the respective run. The columns Mandatory and Constraint do not apply to output tables.
Datasets
| Variable |
Mandatory |
Constraint |
Unit |
| ID |
✓ |
|
|
| Type |
✓ |
Jet, Turboprop, Piston |
|
Doc29 Aerodynamic Coefficients
| Variable |
Mandatory |
Constraint |
Unit |
| Doc29 Performance ID |
✓ |
|
|
| ID |
✓ |
|
|
| Type |
✓ |
Takeoff, Land, Cruise |
|
| R |
✓ |
> 0 |
|
| B |
|
> 0 |
Doc29 B Coefficient |
| C |
|
> 0 |
Doc29 C/D Coefficients |
| D |
|
> 0 |
Doc29 C/D Coefficients |
Doc29 Thrust Ratings
| Variable |
Mandatory |
Constraint |
Unit |
| Doc29 Performance ID |
✓ |
|
|
| Thrust Rating |
✓ |
Maximum Takeoff, Maximum Climb, Idle, Maximum Takeoff High Temperature, Maximum Climb High Temperature, Idle High Temperature |
|
| E |
✓ |
|
Thrust |
| F |
✓ |
|
Doc29 F Coefficient |
| Ga |
✓ |
|
Doc29 Ga Coefficient |
| Gb |
✓ |
|
Doc29 Gb Coefficient |
| H |
✓ |
|
Doc29 H Coefficient |
Doc29 Thrust Ratings Propeller
| Variable |
Mandatory |
Constraint |
Unit |
| Doc29 Performance ID |
✓ |
|
|
| Thrust Rating |
✓ |
Maximum Takeoff, Maximum Climb |
|
| Propeller Efficiency |
✓ |
0 < x ≤ 1 |
|
| Propeller Power |
✓ |
> 0 |
Power |
Doc29 Profiles Points
| Variable |
Mandatory |
Constraint |
Unit |
| Doc29 Performance ID |
✓ |
|
|
| Operation |
✓ |
|
|
| Profile ID |
✓ |
|
|
| Cumulative Ground Distance |
✓ |
|
Distance |
| Altitude ATE |
✓ |
|
Altitude |
| True Airspeed |
✓ |
≥ 0 |
Speed |
| Corrected Net Thrust per Engine |
✓ |
> 0 |
Thrust |
Doc29 Profiles Procedural Arrival
| Variable |
Mandatory |
Constraint |
Unit |
| Doc29 Performance ID |
✓ |
|
|
| Profile ID |
✓ |
|
|
| Step Type |
✓ |
Descend Decelerate, Descend Idle, Level, Level Decelerate, Level Idle, Descend Land, Ground Decelerate |
|
| Aerodynamic Coefficient ID |
|
|
|
| Start Altitude ATE |
|
|
Altitude |
| Descent Angle |
|
< 0 |
|
| Start Calibrated Airspeed |
|
≥ 0 |
Speed |
| Ground Distance |
|
> 0 |
Distance |
| Descend Land - Descent Angle |
|
< 0 |
|
| Descend Land - Threshold Crossing Altitude |
|
|
Altitude |
| Descend Land - Touchdown Roll |
|
> 0 |
Distance |
| Ground Decelerate - Ground Distance |
|
≥ 0 |
Distance |
| Ground Decelerate - Start Calibrated Airspeed |
|
≥ 0 |
Speed |
| Ground Decelerate - Start Thrust Percentage |
|
0 ≤ x ≤ 1 |
|
Doc29 Profiles Procedural Departure
| Variable |
Mandatory |
Constraint |
Unit |
| Doc29 Performance ID |
✓ |
|
|
| Profile ID |
✓ |
|
|
| Step Type |
✓ |
Takeoff, Climb, Climb Accelerate, Climb Accelerate Percentage |
|
| Thrust Cutback |
|
> 0 |
|
| Aerodynamic Coefficient ID |
✓ |
|
|
| End Altitude ATE |
|
|
Altitude |
| End Calibrated Airspeed |
|
≥ 0 |
Speed |
| Climb Rate |
|
≥ 0 |
|
| Acceleration Percentage |
|
0 < x ≤ 1 |
|
| Takeoff - Initial Calibrated Airspeed |
|
≥ 0 |
Speed |
Info
The thrust cutback variable should be empty, except at the thrust cutback step. GRAPE will interpret any non empty cell as the thrust cutback step.
Doc29 Noise
| Variable |
Mandatory |
Constraint |
Unit |
| ID |
✓ |
|
|
| Lateral Directivity |
✓ |
Wing, Fuselage, Propeller |
|
| Start of Roll Correction |
✓ |
None, Jet, Turboprop |
|
Doc29 NPD Data
| Variable |
Mandatory |
Constraint |
Unit |
| Doc29 Performance ID |
✓ |
|
|
| Operation |
✓ |
Arrival, Departure |
|
| Noise Metric |
✓ |
LAMAX, SEL |
|
| Thrust |
✓ |
|
Thrust |
| Level 200 ft |
✓ |
|
|
| Level 400 ft |
✓ |
|
|
| Level 600 ft |
✓ |
|
|
| Level 1000 ft |
✓ |
|
|
| Level 2000 ft |
✓ |
|
|
| Level 4000 ft |
✓ |
|
|
| Level 6300 ft |
✓ |
|
|
| Level 10000 ft |
✓ |
|
|
| Level 16000 ft |
✓ |
|
|
| Level 25000 ft |
✓ |
|
|
Doc29 Spectrum
| Variable |
Mandatory |
Constraint |
Unit |
| Doc29 Performance ID |
✓ |
|
|
| Operation |
✓ |
Arrival, Departure |
|
| Level 50 Hz |
✓ |
|
|
| Level 63 Hz |
✓ |
|
|
| Level 80 Hz |
✓ |
|
|
| Level 100 Hz |
✓ |
|
|
| Level 125 Hz |
✓ |
|
|
| Level 160 Hz |
✓ |
|
|
| Level 200 Hz |
✓ |
|
|
| Level 250 Hz |
✓ |
|
|
| Level 315 Hz |
✓ |
|
|
| Level 400 Hz |
✓ |
|
|
| Level 500 Hz |
✓ |
|
|
| Level 630 Hz |
✓ |
|
|
| Level 800 Hz |
✓ |
|
|
| Level 1000 Hz |
✓ |
|
|
| Level 1250 Hz |
✓ |
|
|
| Level 1600 Hz |
✓ |
|
|
| Level 2000 Hz |
✓ |
|
|
| Level 2500 Hz |
✓ |
|
|
| Level 3150 Hz |
✓ |
|
|
| Level 4000 Hz |
✓ |
|
|
| Level 5000 Hz |
✓ |
|
|
| Level 6300 Hz |
✓ |
|
|
| Level 8000 Hz |
✓ |
|
|
| Level 10000 Hz |
✓ |
|
|
LTO Engines
| Variable |
Mandatory |
Constraint |
Unit |
| ID |
✓ |
|
|
| Fuel Flow Idle |
✓ |
≥ 0 |
Fuel Flow |
| Fuel Flow Approach |
✓ |
≥ 0 |
Fuel Flow |
| Fuel Flow Climb Out |
✓ |
≥ 0 |
Fuel Flow |
| Fuel Flow Takeoff |
✓ |
≥ 0 |
Fuel Flow |
| Fuel Flow Correction Factor Idle |
|
≥ 0 |
|
| Fuel Flow Correction Factor Approach |
|
≥ 0 |
|
| Fuel Flow Correction Factor Climb Out |
|
≥ 0 |
|
| Fuel Flow Correction Factor Takeoff |
|
≥ 0 |
|
| Emission Index HC Idle |
✓ |
≥ 0 |
Emission Index |
| Emission Index HC Approach |
✓ |
≥ 0 |
Emission Index |
| Emission Index HC Climb Out |
✓ |
≥ 0 |
Emission Index |
| Emission Index HC Takeoff |
✓ |
≥ 0 |
Emission Index |
| Emission Index CO Idle |
✓ |
≥ 0 |
Emission Index |
| Emission Index CO Approach |
✓ |
≥ 0 |
Emission Index |
| Emission Index CO Climb Out |
✓ |
≥ 0 |
Emission Index |
| Emission Index CO Takeoff |
✓ |
≥ 0 |
Emission Index |
| Emission Index NOx Idle |
✓ |
≥ 0 |
Emission Index |
| Emission Index NOx Approach |
✓ |
≥ 0 |
Emission Index |
| Emission Index NOx Climb Out |
✓ |
≥ 0 |
Emission Index |
| Emission Index NOx Takeoff |
✓ |
≥ 0 |
Emission Index |
SFI Coefficients
| Variable |
Mandatory |
Constraint |
Unit |
| ID |
✓ |
|
|
| A |
✓ |
|
|
| B1 |
✓ |
|
|
| B2 |
✓ |
|
|
| B3 |
✓ |
|
|
| K1 |
✓ |
|
|
| K2 |
✓ |
|
|
| K3 |
✓ |
|
|
| K4 |
✓ |
|
|
Fleet
| Variable |
Mandatory |
Constraint |
Unit |
| ID |
✓ |
|
|
| Engine Count |
✓ |
1, 2, 3, 4 |
|
| Maximum Sea Level Static Thrust |
✓ |
≥ 0 |
Thrust |
| Engine Breakpoint Temperature |
✓ |
≥ 0 |
Temperature |
| Doc29 Performance ID |
|
|
|
| SFI Coefficients ID |
|
|
|
| LTO Engine ID |
|
|
|
| Doc29 Noise ID |
|
|
|
| Doc29 Noise Arrival Δ (dB) |
|
|
|
| Doc29 Noise Departure Δ (dB) |
|
|
|
Airports
| Variable |
Mandatory |
Constraint |
Unit |
| ID |
✓ |
|
|
| Longitude |
✓ |
-180 ≤ x ≤ 180 |
|
| Latitude |
✓ |
-90 ≤ x ≤ 90 |
|
| Elevation |
✓ |
|
Altitude |
| Reference Temperature |
|
≥ 0 |
Temperature |
| Reference Pressure |
|
≥ 0 |
Pressure |
Runways
| Variable |
Mandatory |
Constraint |
Unit |
| Airport ID |
✓ |
|
|
| ID |
✓ |
|
|
| Longitude |
✓ |
-180 ≤ x ≤ 180 |
|
| Latitude |
✓ |
-90 ≤ x ≤ 90 |
|
| Elevation |
✓ |
|
Altitude |
| Length |
✓ |
> 0 |
Distance |
| Heading |
✓ |
0 ≤ x ≤ 360 |
|
| Gradient |
|
|
|
Routes Simple
| Variable |
Mandatory |
Constraint |
Unit |
| Airport ID |
✓ |
|
|
| Runway ID |
✓ |
|
|
| Operation |
✓ |
Arrival, Departure |
|
| Route ID |
✓ |
|
|
| Longitude |
✓ |
-180 ≤ x ≤ 180 |
|
| Latitude |
✓ |
-90 ≤ x ≤ 90 |
|
Routes Vectors
| Variable |
Mandatory |
Constraint |
Unit |
| Airport ID |
✓ |
|
|
| Runway ID |
✓ |
|
|
| Operation |
✓ |
Arrival, Departure |
|
| Route ID |
✓ |
|
|
| Vector Type |
✓ |
Straight, Turn |
|
| Distance |
|
> 0 |
Distance |
| Turn Radius |
|
> 0 |
Distance |
| Heading |
|
0 ≤ x ≤ 360 |
|
| Turn Direction |
|
Right, Left |
|
Routes RNP
| Variable |
Mandatory |
Constraint |
Unit |
| Airport ID |
✓ |
|
|
| Runway ID |
✓ |
|
|
| Operation |
✓ |
Arrival, Departure |
|
| Route ID |
✓ |
|
|
| Step Type |
✓ |
Track to Fix, Radius to Fix |
|
| Longitude |
✓ |
-180 ≤ x ≤ 180 |
|
| Latitude |
✓ |
-90 ≤ x ≤ 90 |
|
| Center Longitude |
|
-180 ≤ x ≤ 180 |
|
| Center Latitude |
|
-90 ≤ x ≤ 90 |
|
Flights
| Variable |
Mandatory |
Constraint |
Unit |
| ID |
✓ |
|
|
| Airport ID |
✓ |
|
|
| Runway ID |
✓ |
|
|
| Operation |
✓ |
Arrival, Departure |
|
| Route ID |
✓ |
|
|
| Time |
✓ |
yyyy-mm-dd HH:MM:SS |
|
| Count |
✓ |
≥ 0 |
|
| Fleet ID |
✓ |
|
|
| Weight |
✓ |
> 0 |
Weight |
| Doc29 Profile |
|
|
|
| Takeoff Thrust |
|
0.5 ≤ x ≤ 1 |
|
| Climb Thrust |
|
0.5 ≤ x ≤ 1 |
|
Tracks 4D
| Variable |
Mandatory |
Constraint |
Unit |
| ID |
✓ |
|
|
| Operation |
✓ |
Arrival, Departure |
|
| Time |
✓ |
yyyy-mm-dd HH:MM:SS |
|
| Count |
✓ |
≥ 0 |
|
| Fleet ID |
✓ |
|
|
Tracks 4D Points
| Variable |
Mandatory |
Constraint |
Unit |
| ID |
✓ |
|
|
| Operation |
✓ |
Arrival, Departure |
|
| Flight Phase |
✓ |
Approach, Landing Roll, Takeoff Roll, Initial Climb Climb |
|
| Cumulative Ground Distance |
✓ |
|
|
| Longitude |
✓ |
-180 ≤ x ≤ 180 |
|
| Latitude |
✓ |
-90 ≤ x ≤ 90 |
|
| Altitude MSL |
✓ |
|
Altitude |
| True Airspeed |
✓ |
≥ 0 |
Speed |
| Groundspeed |
✓ |
≥ 0 |
Speed |
| Corrected Net Thrust per Engine |
✓ |
|
Thrust |
| Bank Angle |
✓ |
-90 ≤ x ≤ 90 |
|
| Fuel Flow per Engine |
✓ |
≥ 0 |
Fuel Flow |
Warning
The track 4D operation must already exist in the study.
Scenarios
| Variable |
Mandatory |
Constraint |
Unit |
| ID |
✓ |
|
|
Scenarios Operations
| Variable |
Mandatory |
Constraint |
Unit |
| Scenario ID |
✓ |
|
|
| Operation ID |
✓ |
|
|
| Operation |
✓ |
Arrival, Departure |
|
| Type |
✓ |
Flight, Track 4D |
|
Info
If Scenario ID is not found in the study, it will be added.
| Variable |
Mandatory |
Constraint |
Unit |
| Scenario ID |
✓ |
|
|
| ID |
✓ |
|
|
| Coordinate System Type |
✓ |
Geodesic WGS84, Local Cartesian |
|
| Longitude 0 |
|
-180 ≤ x ≤ 180 |
|
| Latitude 0 |
|
-90 ≤ x ≤ 90 |
|
| Filter Minimum Altitude MSL |
|
> Filter Maximum Altitude MSL |
Altitude |
| Filter Maximum Altitude MSL |
|
< Filter Minimum Altitude MSL |
Altitude |
| Filter Minimum Cumulative Ground Distance |
|
< Filter Maximum Cumulative Ground Distance |
Distance |
| Filter Maximum Cumulative Ground Distance |
|
> Filter Minimum Cumulative Ground Distance |
Distance |
| Filter Ground Distance Threshold |
|
|
Distance |
| Segmentation Speed Delta Threshold |
|
> 0 |
Speed |
| Flights Performance Model |
✓ |
Doc29 |
|
| Flights Enable Doc29 Segmentation |
|
0, 1 |
|
| Tracks 4D Minimum Points |
|
≥ 0 |
|
| Tracks Recalculate Cumulative Ground Distance |
|
0, 1 |
|
| Tracks Recalculate Groundspeed |
|
0, 1 |
|
| Tracks Recalculate Fuel Flow |
|
0, 1 |
|
| Fuel Flow Model |
✓ |
None, LTO, LTO Doc9889, SFI |
|
| Variable |
Mandatory |
Constraint |
Unit |
| Scenario ID |
✓ |
|
|
| Performance Run ID |
✓ |
|
|
| Time |
✓ |
yyyy-mm-dd HH:MM:SS |
|
| Temperature Delta |
✓ |
-100 K ≤ x ≤ 100 K |
Temperature |
| Pressure Delta |
✓ |
-150 hPa ≤ x ≤ 150.0 hPa |
Pressure |
| Wind Speed |
✓ |
|
Speed |
| Wind Direction |
|
0 ≤ x ≤ 360 |
|
| Relative Humidity |
✓ |
0 ≤ x ≤ 1 |
|
Noise Runs
| Variable |
Mandatory |
Constraint |
Unit |
| Scenario ID |
✓ |
|
|
| Performance Run ID |
✓ |
|
|
| ID |
✓ |
|
|
| Noise Model |
✓ |
Doc29 |
|
| Atmospheric Absorption |
✓ |
None, SAE ARP 866, SAE ARP 5534 |
|
| Receptor Set Type |
✓ |
Grid, Points |
|
| Save Single Event Metrics |
✓ |
0, 1 |
|
Noise Runs Grid Receptors
| Variable |
Mandatory |
Constraint |
Unit |
| Scenario ID |
✓ |
|
|
| Performance Run ID |
✓ |
|
|
| Noise Run ID |
✓ |
|
|
| ID |
✓ |
|
|
| Reference Location |
✓ |
Center, Bottom Left, Bottom Right, Top Left, Top Right |
|
| Reference Longitude |
✓ |
-180 ≤ x ≤ 180 |
|
| Reference Latitude |
✓ |
-90 ≤ x ≤ 90 |
|
| Reference Altitude MSL |
✓ |
|
Altitude |
| Horizontal Spacing |
✓ |
> 0 |
Distance |
| Vertical Spacing |
✓ |
> 0 |
Distance |
| Horizontal Count |
✓ |
≥ 1 |
|
| Vertical Count |
✓ |
≥ 1 |
|
| Grid Rotation |
✓ |
-180 ≤ x ≤ 180 |
|
Noise Runs Point Receptors
| Variable |
Mandatory |
Constraint |
Unit |
| Scenario ID |
✓ |
|
|
| Performance Run ID |
✓ |
|
|
| Noise Run ID |
✓ |
|
|
| ID |
✓ |
|
|
| Longitude |
✓ |
-180 ≤ x ≤ 180 |
|
| Latitude |
✓ |
-90 ≤ x ≤ 90 |
|
| Altitude MSL |
✓ |
|
Altitude |
Noise Runs Cumulative Metrics
| Variable |
Mandatory |
Constraint |
Unit |
| Scenario ID |
✓ |
|
|
| Performance Run ID |
✓ |
|
|
| Noise Run ID |
✓ |
|
|
| ID |
✓ |
|
|
| Threshold (dB) |
✓ |
|
|
| Averaging Time Constant (dB) |
✓ |
|
|
| Start Time Point |
✓ |
yyyy-mm-dd HH:MM:SS |
|
| End Time Point |
✓ |
yyyy-mm-dd HH:MM:SS |
|
| Number Above Thresholds |
|
# # ... |
|
Noise Runs Cumulative Metrics Weights
| Variable |
Mandatory |
Constraint |
Unit |
| Scenario ID |
✓ |
|
|
| Performance Run ID |
✓ |
|
|
| Noise Run ID |
✓ |
|
|
| Cumulative Metric ID |
✓ |
|
|
| Time |
✓ |
HH:MM:SS |
|
| Weight |
✓ |
|
|
Emissions Runs
| Variable |
Mandatory |
Constraint |
Unit |
| Scenario ID |
✓ |
|
|
| Performance Run ID |
✓ |
|
|
| ID |
✓ |
|
|
| Emissions Model |
✓ |
None, Boeing Fuel Flow Method 2 |
|
| Filter Minimum Altitude MSL |
|
> Filter Maximum Altitude MSL |
Altitude |
| Filter Maximum Altitude MSL |
|
< Filter Minimum Altitude MSL |
Altitude |
| Filter Minimum Cumulative Ground Distance |
|
< Filter Maximum Cumulative Ground Distance |
Distance |
| Filter Maximum Cumulative Ground Distance |
|
> Filter Minimum Cumulative Ground Distance |
Distance |
| Save Segment Results |
✓ |
0, 1 |
|
Outputs
| Variable |
Mandatory |
Constraint |
Unit |
| Name |
|
|
|
| Operation |
|
|
|
| Type |
|
|
|
| Point Number |
|
|
|
| Point Origin |
|
|
|
| Flight Phase |
|
|
|
| Cumulative Ground Distance |
|
|
Distance |
| Longitude |
|
|
|
| Latitude |
|
|
|
| Altitude MSL |
|
|
Altitude |
| True Airspeed |
|
|
Speed |
| Groundspeed |
|
|
Speed |
| Corrected Net Thrust per Engine |
|
|
Thrust |
| Bank Angle |
|
|
|
| Fuel Flow per Engine |
|
|
Fuel Flow |
| Variable |
Mandatory |
Constraint |
Unit |
| Point Number |
|
|
|
| Point Origin |
|
|
|
| Flight Phase |
|
|
|
| Cumulative Ground Distance |
|
|
Distance |
| Longitude |
|
|
|
| Latitude |
|
|
|
| Altitude MSL |
|
|
Altitude |
| True Airspeed |
|
|
Speed |
| Groundspeed |
|
|
Speed |
| Corrected Net Thrust per Engine |
|
|
Thrust |
| Bank Angle |
|
|
|
| Fuel Flow per Engine |
|
|
Fuel Flow |
Noise Run Output Cumulative Metric
| Variable |
Mandatory |
Constraint |
Unit |
| Receptor ID |
|
|
|
| Longitude |
|
|
|
| Latitude |
|
|
|
| Elevation |
|
|
Altitude |
| Weighted Operation Count |
|
|
|
| Maximum Absolute |
|
|
|
| Maximum Average |
|
|
|
| Exposure |
|
|
|
| # Above X |
|
|
|
Info
The last column (# Above X) can occur 0 or more times, depending on the number of thresholds defined for the metric. The value of X is replaced in each column ba the respective threshold.
Noise Run Output Single Event
| Variable |
Mandatory |
Constraint |
Unit |
| Receptor ID |
|
|
|
| Longitude |
|
|
|
| Latitude |
|
|
|
| Elevation |
|
|
Altitude |
| Maximum |
|
|
|
| Exposure |
|
|
|
Emissions Run Output
| Variable |
Mandatory |
Constraint |
Unit |
| Name |
|
|
|
| Operation |
|
|
|
| Type |
|
|
|
| Fuel |
|
|
Emissions Weight |
| HC |
|
|
Emissions Weight |
| CO |
|
|
Emissions Weight |
| NOx |
|
|
Emissions Weight |
Info
The first row of this output file contains the total emissions of the emissions run. The Name column is set to Total and both Operation and Type are left empty.
Emissions Run Output Segments
| Variable |
Mandatory |
Constraint |
Unit |
| Segment Index |
|
|
|
| Fuel |
|
|
Emissions Weight |
| HC |
|
|
Emissions Weight |
| CO |
|
|
Emissions Weight |
| NOx |
|
|
Emissions Weight |
Info
The first row of this output file contains the total emissions of the operation. The Segment Index column is set to Total.