Spreadsheet: 52490d1252275715-help-needed-in-creating-a-drop-down-list-involved-set-of-data-in-tables-alisalm
Sheet: Loading

 |  | Distance (ft) | Select Equip. | Select Loaded OR Empty | Select Total Resistence | Travel Time
 |  |  | Distance (ft) | Equipment Model | Travel Time Loaded (min) | Travel Time Empty (min)
 |  |  |  | 908
 |  |  |  | 924 G
 |  |  |  | 972G Loaded | Travel Time Loaded (min)
 |  |  |  |  | Total Resistence (%)
 |  |  |  |  | 2 | 4 | 6 | 8 | 10 | 15 | 20
 |  |  | Up to 100 |  | 0.12 | 0.12 | 0.12 | 0.12 | 0.12 | 0.2 | 0.25
 |  |  | 100-200 |  | 0.15 | 0.15 | 0.17 | 0.18 | 0.2 | 0.3 | 0.5
 |  |  | 200-300 |  | 0.2 | 0.22 | 0.25 | 0.3 | 0.35 | 0.5 | 0.6
 |  |  | 300-400 |  | 0.25 | 0.3 | 0.35 | 0.4 | 0.45 | 0.7 | 0.8
 |  |  | 400-500 |  | 0.3 | 0.35 | 0.45 | 0.5 | 0.55 | 0.8 | 1.15
 |  |  | 500-600 |  | 0.35 | 0.45 | 0.5 | 0.65 | 0.7 | 1.1 | 1.3
 |  |  |  | 972G Empty | Travel Time Empty (min)
 |  |  |  |  | Total Resistence (%)
 |  |  |  |  | 2 | 4 | 6 | 8 | 10 | 15 | 20
 |  |  | Up to 100 |  | 0.12 | 0.12 | 0.12 | 0.12 | 0.12 | 0.12 | 0.12
 |  |  | 100-200 |  | 0.15 | 0.15 | 0.17 | 0.18 | 0.2 | 0.3 | 0.5
 |  |  | 200-300 |  | 0.2 | 0.2 | 0.23 | 0.28 | 0.3 | 0.45 | 0.55
 |  |  | 300-400 |  | 0.25 | 0.25 | 0.3 | 0.35 | 0.4 | 0.6 | 0.7
 |  |  | 400-500 |  | 0.3 | 0.3 | 0.4 | 0.4 | 0.5 | 0.7 | 0.9
 |  |  | 500-600 |  | 0.35 | 0.4 | 0.45 | 0.55 | 0.6 | 0.9 | 1.1
 |  |  |  | 988G Loaded | Travel Time Loaded (min)
 |  |  |  |  | Total Resistence (%)
 |  |  |  |  | 2 | 4 | 6 | 8 | 10 | 15 | 20
 |  |  | Up to 100 |  | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.2 | 0.2
 |  |  | 100-200 |  | 0.15 | 0.15 | 0.2 | 0.22 | 0.25 | 0.3 | 0.4
 |  |  | 200-300 |  | 0.2 | 0.2 | 0.3 | 0.3 | 0.35 | 0.6 | 0.7
 |  |  | 300-400 |  | 0.3 | 0.3 | 0.35 | 0.4 | 0.5 | 0.8 | 0.9
 |  |  | 400-500 |  | 0.35 | 0.4 | 0.45 | 0.5 | 0.65 | 0.9 | 1.1
 |  |  | 500-600 |  | 0.45 | 0.5 | 0.55 | 0.65 | 0.8 | 1 | 1.3
 |  |  |  | 988G Empty | Travel Time Empty (min)
 |  |  |  |  | Total Resistence (%)
 |  |  |  |  | 2 | 4 | 6 | 8 | 10 | 15 | 20
 |  |  | Up to 100 |  | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.2 | 0.2
 |  |  | 100-200 |  | 0.15 | 0.15 | 0.2 | 0.2 | 0.2 | 0.25 | 0.3
 |  |  | 200-300 |  | 0.2 | 0.2 | 0.25 | 0.25 | 0.3 | 0.5 | 0.6
 |  |  | 300-400 |  | 0.3 | 0.3 | 0.35 | 0.35 | 0.4 | 0.7 | 0.8
 |  |  | 400-500 |  | 0.35 | 0.35 | 0.4 | 0.4 | 0.6 | 0.8 | 1
 |  |  | 500-600 |  | 0.4 | 0.45 | 0.5 | 0.5 | 0.7 | 1 | 1.1
 |  |  |  | 990  Loaded | Travel Time Loaded (min)
 |  |  |  |  | Total Resistence (%)
 |  |  |  |  | 2 | 4 | 6 | 8 | 10 | 15 | 20
 |  |  | Up to 100 |  | 0.15 | 0.15 | 0.2 | 0.22 | 0.25 | 0.35 | 0.45
 |  |  | 100-200 |  | 0.25 | 0.25 | 0.3 | 0.35 | 0.4 | 0.5 | 0.7
 |  |  | 200-300 |  | 0.35 | 0.35 | 0.4 | 0.45 | 0.5 | 0.8 | 0.9
 |  |  | 300-400 |  | 0.45 | 0.45 | 0.5 | 0.6 | 0.7 | 1 | 1.1
 |  |  | 400-500 |  | 0.55 | 0.55 | 0.6 | 0.7 | 0.85 | 1.2 | 1.3
 |  |  | 500-600 |  | 0.65 | 0.65 | 0.7 | 0.8 | 1 | 1.3 | 1.3
 |  |  |  | 990  Empty | Travel Time Empty (min)
 |  |  |  |  | Total Resistence (%)
 |  |  |  |  | 2 | 4 | 6 | 8 | 10 | 15 | 20
 |  |  | Up to 100 |  | 0.15 | 0.15 | 0.2 | 0.22 | 0.25 | 0.35 | 0.45
 |  |  | 100-200 |  | 0.25 | 0.25 | 0.3 | 0.35 | 0.4 | 0.5 | 0.7
 |  |  | 200-300 |  | 0.35 | 0.35 | 0.35 | 0.4 | 0.5 | 0.65 | 0.75
 |  |  | 300-400 |  | 0.45 | 0.45 | 0.45 | 0.5 | 0.6 | 0.8 | 0.9
 |  |  | 400-500 |  | 0.55 | 0.55 | 0.55 | 0.6 | 0.7 | 1 | 1
 |  |  | 500-600 |  | 0.65 | 0.65 | 0.65 | 0.7 | 0.8 | 1.1 | 1.2