Freight and Fuel Transportation Optimization Tool Quick ...
Freight and Fuel Transportation Optimization Tool
Quick Start Scenarios Documentation
FTOT 2019.3 Public Release Version
DOT-VNTSC-FAA-19-07 DOT/FAA/AEE/2020-02
October 31, 2019
Prepared for: Federal Aviation Administration Office of Environment and Energy Washington, DC
Notice
This document is disseminated under the sponsorship of the Department of Transportation in the interest of information exchange. The United States Government assumes no liability for the contents or use thereof.
The United States Government does not endorse products or manufacturers. Trade or manufacturers' names appear herein solely because they are considered essential to the objective of this report.
Overview
2
REPORT DOCUMENTATION PAGE
Form Approved OMB No. 0704-0188
Public reporting burden for this collection of information is estimated to average 1 hour per response, including the time for reviewing instructions, searching existing data sources, gathering and maintaining the data needed, and completing and reviewing the collection of information. Send comments regarding this burden estimate or any other aspect of this collection of information, including suggestions for reducing this burden, to Washington Headquarters Services, Directorate for Information Operations and Reports, 1215 Jefferson Davis Highway, Suite 1204, Arlington, VA 22202-4302, and to the Office of Management and Budget, Paperwork Reduction Project (0704-0188), Washington, DC 20503.
1. AGENCY USE ONLY (Leave blank)
2. REPORT DATE October 31, 2019
3. REPORT TYPE AND DATES COVERED Document, 9/2018-9/2019
4. TITLE AND SUBTITLE
5a. FUNDING NUMBERS
Freight and Fuel Transportation Optimization Tool Quick Start Documentation: FTOT 2019.3 Public Release Version
FB48CS/SG287 and SG291
6. AUTHOR(S) Matthew Pearlson, Alexander Oberg, Olivia Gillham, Amy Vogel, Kristin C. Lewis, Scott Smith, Gary Baker
7. PERFORMING ORGANIZATION NAME(S) AND ADDRESS(ES) Volpe National Transportation Systems Center, 55 Broadway, Cambridge, MA 02142
9. SPONSORING/MONITORING AGENCY NAME(S) AND ADDRESS(ES) Federal Aviation Administration, 800 Independence Ave, SW, Washington, DC 20591
11. SUPPLEMENTARY NOTES
5b. CONTRACT NUMBER 693KA9-18-N-00022
8. PERFORMING ORGANIZATION REPORT NUMBER DOT-VNTSC-FAA-19-07
10. SPONSORING/MONITORING AGENCY REPORT NUMBER
DOT/FAA/AEE/2020-02
12a. DISTRIBUTION/AVAILABILITY STATEMENT
12b. DISTRIBUTION CODE
13. ABSTRACT (Maximum 200 words)
Volpe created the Freight and Fuel Transportation Optimization Tool (FTOT) to support the FAA, DOE, and the U.S. Navy's Office of Naval Research to assess optimal transport options for freight and fuel supply chains. FTOT is a flexible scenario-testing tool that optimizes the transportation of materials for future energy and freight scenarios. FTOT models and tracks commodity-specific information and can take into account conversion of raw materials to products (e.g., crude oil to jet fuel/diesel) and fulfillment of downstream demand. This report documents the Quick Start Scenarios developed to help the user explore the functionality of the FTOT public release 2019.3.
14. SUBJECT TERMS Freight, fuel, geospatial information systems, GIS, network analysis, transportation optimization.
15. NUMBER OF PAGES 49
16. PRICE CODE
17. SECURITY CLASSIFICATION OF REPORT
18. SECURITY CLASSIFICATION OF THIS PAGE
19. SECURITY CLASSIFICATION OF ABSTRACT
20. LIMITATION OF ABSTRACT
NSN 7540-01-280-5500
Standard Form 298 (Rev. 2-89) Prescribed by ANSI Std. 239-18
298-102
Overview
3
Quick Start Documentation
Overview
Assuming you've got FTOT installed (installation wiki is here: ), this is the place to learn how to run FTOT scenarios and view the results. After downloading the Quick Start scenarios, the directory and file path should look like this:
Figure 1: FTOT Quick Start Folder Structure
The Quick Start series is a set of simple scenarios designed to introduce supply chain modeling in FTOT. The first scenario (Quick Start 1) is the simplest. Each subsequent scenario demonstrates a different aspect of FTOT functionality. The seven Quick Start (QS) scenarios are summarized in the table below.
# Summary 1 Simple supply chain with no intermediate processing 2 Simple supply chain with intermediate processing 3 Candidate processing facilities are generated for the supply chain by FTOT 4 Supply chain with two intermediate processing steps; storage followed by conversion 5 Road network is excluded from the optimization, forcing FTOT To find alternative solutions 6 National supply chain with no road network 7 Processor takes two input commodities
Table 1: Quick Start scenarios summaries and complexity rating.
Complexity Low Low Med Med Low Med Low
Getting Started
? FTOT scenarios are stored C:\FTOT\scenarios\quick_start folder. Within this directory, each default scenario and exercise includes its own dedicated subfolder for storing the scenario configuration and outputs.
? FTOT is a command line tool that runs in a sequence of steps. ? Each scenario (e.g. qs1_rmp_to_dest\Default) contains a batch script file called run_v5_1.bat.* ? The batch script files are included in each of the Quick Start scenario folders to automate each step
required. ? You can run the batch script by double clicking it or manually executing it in the Command Prompt.
Overview
4
*If you were unable to install the ArcGIS 64-bit background geoprocessing, you should run FTOT in 32-bit by using the batch script files called run_v5_ 1_32bit.bat. This 32-bit option is not available for Quick Start 6.
During the Run
? Informational logging is available in the command shell during the run. Detailed logging is available in the .\logs folder.
? The logs are prefixed with a letter and timestamp indicating the FTOT step and time the log was generated.
? The user is encouraged to read the logs to familiarize themselves with the FTOT operations occurring during each step.
Results
? FTOT generates results in the .\Reports and .\Maps folders of the scenario. The reports and maps are also timestamped.
? The report is found in the .\Reports directory of the scenario. It is generated in the D step of the FTOT sequence. The FTOT report shows a summary of the results for each step in the analysis. The report is broken into the following sections: run time summary of each step, intermediate calculations and optimal results, configurations, warnings, and errors.
? A Tableau Dashboard (tableau_dashboard.twbx) can also be found in a timestamped tableau_dashboard folder within the .\Reports directory of the scenario. This can be opened in Tableau Reader.
? The map files can be found in the .\Maps directory of the scenario. The maps for the scenario are generated in the M step at the end of the FTOT scenario sequence. FTOT generates a series of maps for each FTOT step to help the user see what happens during the scenario.
For more information on interpreting results, see the complete FTOT Documentation, which can be found in the documentation folder you downloaded from (FTOT_Documentation_2019_3.pdf).
More information
The complete Quick Start documentation details the nuances of each run and provides brief overviews of the main results. Additional exercises are suggested at the end of some chapters. The user is encouraged to complete these exercises to become familiar with modifying a scenario before creating their own. It is highly recommended that the user read through the documentation for Quick Start 1, as that contains the most detail. The documentation for subsequent scenarios is more focused on highlighting the differences among scenarios and demonstrating various FTOT features.
Trouble Shooting
See the troubleshooting guide at the end of FTOT_Documentation_2019_3.pdf for tips on how to resolve common issues like runtime dependency errors (missing software), missing input data, and missing base maps.
Overview
5
Contents
Overview .....................................................................................................................................................................4 Table of Figures and Tables ....................................................................................................................................8
Executive Summary ................................................................................................................................................. 10 Quick Start 1 (QS1) - RMP to Destination................................................................................................................ 11
Purpose................................................................................................................................................................ 11 Input Data............................................................................................................................................................ 11
Geospatial Data ............................................................................................................................................... 11 Facility-Commodity Data ................................................................................................................................. 12 Running a Scenario .............................................................................................................................................. 12 Scenario XML File ............................................................................................................................................ 12 Run.bat Script .................................................................................................................................................. 13 Viewing Results.................................................................................................................................................... 14 FTOT Report..................................................................................................................................................... 14 Tableau Dashboard.......................................................................................................................................... 15 Maps ................................................................................................................................................................ 16 Exercises .............................................................................................................................................................. 17 Quick Start 2 (QS2) - RMP to Processor to Destination........................................................................................... 18 Purpose................................................................................................................................................................ 18 Input Data............................................................................................................................................................ 18 Geospatial Data ............................................................................................................................................... 18 Facility-Commodity Data ................................................................................................................................. 18 Running a Scenario .............................................................................................................................................. 20 Scenario XML File ............................................................................................................................................ 20 Run.bat Script .................................................................................................................................................. 20 QS2 Results .......................................................................................................................................................... 20 FTOT Report..................................................................................................................................................... 20 Tableau Dashboard.......................................................................................................................................... 21 Maps ................................................................................................................................................................ 22 Exercises .............................................................................................................................................................. 23 Quick Start 3 (QS3) - RMP to Candidate Processor to Destination ......................................................................... 24 Purpose................................................................................................................................................................ 24 Input Data............................................................................................................................................................ 24 Geospatial Data ............................................................................................................................................... 24
Overview
6
Facility-Commodity Data ................................................................................................................................. 24 Running a Scenario .............................................................................................................................................. 25
Run.bat Script .................................................................................................................................................. 25 Scenario XML File ............................................................................................................................................ 26 QS3 Results .......................................................................................................................................................... 27 FTOT Report..................................................................................................................................................... 27 Tableau Dashboard.......................................................................................................................................... 27 Maps ................................................................................................................................................................ 28 Quick Start 4 (QS4) - RMP to Processor 1 to Processor 2 to Destination................................................................ 30 Purpose................................................................................................................................................................ 30 Input Data............................................................................................................................................................ 30 Geospatial Data ............................................................................................................................................... 30 Facility-Commodity Data ................................................................................................................................. 30 Running a Scenario .............................................................................................................................................. 31 Run.bat Script .................................................................................................................................................. 31 Scenario XML File ............................................................................................................................................ 31 QS4 Results .......................................................................................................................................................... 32 FTOT Report..................................................................................................................................................... 32 Tableau Dashboard.......................................................................................................................................... 32 Maps ................................................................................................................................................................ 33 Quick Start 5 (QS5) - RMP to Destination, No Road ................................................................................................ 34 Purpose................................................................................................................................................................ 34 Input Data............................................................................................................................................................ 34 Running a Scenario .............................................................................................................................................. 34 Run.bat Script .................................................................................................................................................. 34 Scenario XML File ............................................................................................................................................ 35 QS5 Results .......................................................................................................................................................... 35 FTOT Report..................................................................................................................................................... 35 Tableau Dashboard.......................................................................................................................................... 36 Maps ................................................................................................................................................................ 37 Comparison of QS5 and QS1 ........................................................................................................................... 38 Quick Start 6 (QS6) - RMP to Processor to Destination, National Level, No Road .................................................. 39 Purpose................................................................................................................................................................ 39 Input Data............................................................................................................................................................ 39
Overview
7
Running a Scenario .............................................................................................................................................. 39 Run.bat Script .................................................................................................................................................. 39 Scenario XML File ............................................................................................................................................ 40
QS6 Results .......................................................................................................................................................... 40 FTOT Report..................................................................................................................................................... 40 Tableau Dashboard.......................................................................................................................................... 41 Maps ................................................................................................................................................................ 42
Exercises .............................................................................................................................................................. 44 Quick Start 7 (QS7) - RMP to Processor (multiple inputs) to Destination............................................................... 45
Purpose................................................................................................................................................................ 45 Input Data............................................................................................................................................................ 45 Running a Scenario .............................................................................................................................................. 45
Run.bat Script .................................................................................................................................................. 45 Scenario XML File ............................................................................................................................................ 46 QS7 Results .......................................................................................................................................................... 46 FTOT Report..................................................................................................................................................... 46 Tableau Dashboard.......................................................................................................................................... 46 Maps ................................................................................................................................................................ 48 Exercises .............................................................................................................................................................. 49 Acknowledgements ................................................................................................................................................. 50
Table of Figures and Tables
Table 1: Quick Start scenarios summaries and complexity rating.
4
Figure 1: FTOT Quick Start Folder Structure
4
Figure 2: Example Geodatabase (GDB). The structure of the GDB (left) and an example of the records in the rmp attribute
table (right) are shown.
11
Figure 3: QS1 raw material supplier input commodity file (rmp.csv) example entry
12
Figure 4: QS1 destination input commodity file (dest.csv) example entry
12
Figure 5: QS1 Tableau Dashboard
15
Figure 6: QS1 Optimal Solution
16
Figure 7: QS2 raw material supplier input commodity file (rmp.csv)
18
Figure 8: QS2 processor input commodity file (proc.csv)
18
Figure 9: QS2 destination input commodity file (dest.csv)
19
Figure 10: QS2 Tableau Dashboard
21
Figure 11: QS2 Optimal Solution
22
Figure 12: QS3 raw material supplier input commodity file (rmp.csv)
24
Figure 13: QS3 Candidate processor commodity file (cand_proc.csv)
25
Figure 14: QS3 destination input commodity file (dest.csv)
25
Overview
8
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related download
- software catalog
- william searle wrs77 1 9
- tableau reader directions cincinnati state
- tableau reader update version 2019 1 cincinnati state
- download tableau for healthcare third edition pdf ebook by
- quick reference for using institutional tableau workbooks
- freight and fuel transportation optimization tool quick
- pdf editor windows 7 only
- discovering natural language commands tableau research
- learn tableau in 1 day guru99
Related searches
- quick and easy cleaning tips
- quick crossword puzzle and solution
- freight broker responsibilities and duties
- diesel fuel classification and storage
- diesel fuel types and description
- optimization examples and solutions
- compression ratio and fuel octane
- diesel fuel grades and specs
- transportation arts and crafts
- starbucks distribution and transportation methods
- vmware desktop optimization tool download
- vmware optimization tool vdi