Excel Data Types
- Tsizis, Mark (TC TC)
The Date Locomotive was Placed Into Service must be greater than the original manufacture date.
Report Columns
https://tcmarin.atlassian.net/wiki/download/attachments/2791047169/ExcelColumns.xlsx?api=v2
Num columns : 30
|
|
|
|
|
| |
|---|---|---|---|---|---|---|
| 1 | A | Section 1: Status of locomotive | General | Active Existing |
| InUse A |
| 2 | B | Locomotive Identification Number | General | FBB-101 |
| Initial A, InUse B |
| 3 | C | Category of | General | Switch |
| Initial B |
| 4 | D | Type of Rail | General | Tourist and Excursion |
| Initial C |
| 5 | E | Date of Original | yyyy-MM-dd | 2020-07-23 |
| Initial D |
| 6 | F | Tier of Standards | General | CDN/40 CFR 1033 - Tier 3 |
| Initial E |
| 7 | G | Line-haul NOx FEL | "0.00" | 7.07 | 0-99.99 | Initial F |
| 8 | H | Switch NOx FEL | "0.00" | 8.00 | 0-99.99 | Initial G |
| 9 | I | Line-haul PM FEL | "0.000" | 9.999 | 0-9.999 | Initial H |
| 10 | J | Switch PM FEL | "0.000" | 0.001 | 0-9.999 | Initial I |
| 11 | K | Line-haul NOx+HC FEL | "0.00" | 11.11 | 0-99.99 | Initial J |
| 12 | L | Switch NOx+HC FEL | "0.00" | 12.00 | 0-99.99 | Initial K |
| 13 | M | Line-haul CO | "0.00" | 0.13 | 0-99.99 | Initial L |
| 14 | N | Switch CO | "0.00" | 1.40 | 0-99.99 | Initial M |
| 15 | O | Line-haul PM | "0.000" | 15.150 | 0-99.999 | Initial N |
| 16 | P | Switch PM | "0.000" | 0.016 | 0-99.999 | Initial O |
| 17 | Q | Locomotive Manufacturer or Remanufacturer | General | FBB |
| Initial P |
| 18 | R | Locomotive Model | General | FBB-14 |
| Initial Q |
| 19 | S | Engine1 Manufacturer or Remanufacturer | General | FBB-ENG-1 |
| Initial R |
| 20 | T | Engine1 Model | General | FBB-ENG-181 |
| Initial S |
| 21 | U | Engine2 Manufacturer | General | FBB |
| Initial T |
| 22 | V | Engine2 Model | General | FBB-14 |
| Initial U |
| 23 | W | Engine3 | General | FBB-ENG-1 |
| Initial V |
| 24 | X | Engine3 Model | General | FBB-ENG-181 |
| Initial W |
| 25 | Y | Total Rated Power (hp) | "#,##0" | 2,525 | 0-9999 |
|
| 26 | Z | Number of Cylinders | "0" | 26 | 0-99 |
|
| 27 | AA | Type of Fuel1 | General | Low-sulphur diesel (LSD) |
|
|
| 28 | AB | Type of Fuel2 | General | Low-sulphur diesel (LSD) |
|
|
| 29 | AC | Type of Fuel3 | General | Low-sulphur diesel (LSD) |
|
|
| 30 | AD | Locomotive Annual Fuel Consumption | "#,##0" | 3000 | 0-9,999,999,999 |
|
| 31 | AE | Locomotive Annual Fuel Consumption | "#,##0" | 300,100 | 0-9,999,999,999 |
|
| 32 | AF | Locomotive Annual Fuel Consumption | "#,##0" | 32 | 0-9,999,999,999 |
|
| 33 | AG | Useful Life in MW hrs | "#,##0" | 333,333 | 100-1,000,000 |
|
| 34 | AH | Useful Life in Years | "0" | 3 | 0-30 |
|
| 35 | AI | Useful Life in Distance (KM) | "#,##0" | 350,000 | 100-1,000,000 |
|
| 36 | AJ | Type of New Locomotive | General |
|
|
|
| 37 | AK | Is this new locomotive a refurbished locomotive (yes/no)? | General |
|
|
|
| 38 | AL | Is this new locomotive, a repowered locomotive (yes/no)? | General |
|
|
|
| 39 | AM | Date Locomotive was placed into service (YYYY-MM-DD) | yyyy-MM-dd | 2020-07-23 |
|
|
| 40 | AN | EPA Engine Family Number | General | MUSTBE_12CHR |
|
|
| 41 | AO | Type of New Locomotive | General |
|
|
|
| 42 | AP | Is this new locomotive a refurbished locomotive (yes/no)? | General |
|
|
|
| 43 | AQ | Is this new locomotive, a repowered locomotive (yes/no)? | General |
|
|
|
| 44 | AR | Date Locomotive was placed into service (YYYY-MM-DD) | yyyy-MM-dd | 2020-07-23 |
|
|
| 45 | AS | Description of the locomotive’s anti-idling technology | General |
|
|
|
| 46 | AT | Description of the locomotive’s crankcase emissions handling | General |
|
|
|
| 47 | AU | Description of the basic engine design | General |
|
|
|
| 48 | AV | Aftertreatment (yes/No) | General |
|
|
|
| 49 | AW | Aftertreatment Type | General |
|
|
|
| 50 | AX | If Aftertreatment Type is Other, provide explanation | General |
|
|
|
| 51 | AY | Smoke Puff Limiter (Yes/No) | General |
|
|
|
| 52 | AZ | Exhaust Gas Recirculation (Yes/No) | General |
|
|
|
| 53 | BA | Fuel Injection Control (mechanical/electronic/other) | General |
|
|
|
| 54 | BB | If Fuel Injection Control is Other, provide explanation | General |
|
|
|
| 55 | BC | Injection Timing Control (mechanical/electronic/other) | General |
|
|
|
| 56 | BD | If Injection Timing Control is Other, provide explanation | General |
|
|
|
| 57 | BE | Feedback System (Yes/No) | General |
|
|
|
| 58 | BF | Line-haul NOx (g/bhp-hr) | "0.00" | 0.58 | 0-99.99 | InUse C |
| 59 | BG | Line-haul PM (g/bhp-hr) | "0.000" | 5.009 | 0-9.999 | InUse D |
| 60 | BH | Line-haul HC (g/bhp-hr) | "0.00" | 0.60 | 0-99.99 | InUse E |
| 61 | BI | Line-haul CO (g/bhp-hr) | "0.00" | 0.61 | 0-99.99 | InUse F |
| 62 | BJ | Switch NOx (g/bhp-hr) | "0.00" | 0.62 | 0-99.99 | InUse G |
| 63 | BK | Switch PM (g/bhp-hr) | "0.000" | 0.063 | 0-9.999 | InUse H |
| 64 | BL | Switch HC (g/bhp-hr) | "0.00" | 6.04 | 0-99.99 | InUse I |
| 65 | BM | Switch CO (g/bhp-hr) | "0.00" | 0.58 | 0-99.99 | InUse J |
| 66 | BN | Smoke: Steady-State (% Opacity) | "0" | 66 | 0-100 | InUse K |
| 67 | BO | Smoke: 30-Second Peak (% Opacity) | "0" | 67 | 0-100 | InUse L |
| 68 | BP | Smoke: 3-Second Peak (% Opacity) | "0" | 68 | 0-100 | InUse M |
| 69 | BQ | Date of emissions test (YYYY-MM-DD) | yyyy-MM-dd | 2020-07-23 |
| InUse N |
| 70 | BR | Time of emissions test (HH:MM) | Text |
|
| InUse O |
| 71 | BS | Locomotive’s hours of operation at the time of emissions test (MW-hrs) | "#,##0" | 71,000,000 | 0-100,000,000 | InUse P |
| 72 | BT | Date of removal (YYYY-MM-DD) | yyyy-MM-dd | 2020-07-23 |
|
|
| 73 | BU | Reason for removal | General |
|
|
|
| 74 | BV | If Reason for removal is Other, provide explanation | General |
|
|
|