|
<< Click to Display Table of Contents >> Flight Input from Excel |
  
|
|
<< Click to Display Table of Contents >> Flight Input from Excel |
|
Flight segment data can be input from an Microsoft Excel® spreadsheet.
The supplied spreadsheet "Profile.xls" can be used as a template for the data form (it is typically located in the "Spreadsheet" subdirectory of the program's directory). The actual spreadsheet used can have any name and be located in any directory.
1.The tab containing the data on this form must be labeled "Belt Analyst Profile".
2.The "D" and "E" columns are read by BA as "Length" and "Lift". Units can be feet, inches, meters, cm or mm. "C" column is an optional flight segment label. Each flight segment is one row. The row before the first segment must be labeled "start" in the "B" column; the row after the last segment must be labeled the "end" in the "B" column.
3.Pulley data should not be entered.
4.The input data can be entered in any manner as long as the previous criteria are satisfied. The default form allows either "length" and "lift" or "X" and "Y" to be entered, but not both.
5.Save the Excel spreadsheet (any name).
6.In Belt AnalystTM, right-click on the profile where the flight segments should be inserted; then follow the instructions for selecting Excel file.
7.Use theInput Profile Form to review the flight data.
8.Enter other flight segment data in BA -- idler spacing, percent loaded, skirtboard length, cleaners, etc…
This procedure will only import the carry side of the conveyor; to create the return side at the same time with the same profile, the flight input mode should be set at "Auto Return Segments".