Spreadsheet: 840407d1692714339-cant-get-xlookup-to-work-example
Sheet: J1939

 |  |  |  |  |  |  |  |  |  |  |  | pgn
pgn0 - Torque/Speed Control 1 - TSC1 ................................................................................................................. 290 |  | Yes
pgn256 - Transmission Control 1 - TC1 .................................................................................................................... 290 |  | Yes
pgn52992 - Continuous Torque & Speed Limit Request - CTL .................................................................................... 291 |  | Yes
pgn53248 - Cab Illumination Message - CL .................................................................................................................. 294 |  | Yes
pgn53504 - Air Suspension Control 6 - ASC6 .............................................................................................................. 295 |  | Yes
pgn53760 - Air Suspension Control 2 - ASC2 .............................................................................................................. 295 |  | Yes
pgn54528 - Time/Date Adjust - TDA ............................................................................................................................ 295 |  | Yes
pgn56320 - Anti-theft Status - ATS ............................................................................................................................... 296 |  | Yes
pgn56576 - Anti-theft Request - ATR ........................................................................................................................... 302 |  | Yes
[NAME] ............................................................................................................................................ 303 |  | Yes
pgn57344 - Cab Message 1 - CM1 ................................................................................................................................ 303 |  | Yes
pgn61440 - Electronic Retarder Controller 1 - ERC1 ................................................................................................... 304 |  | Yes
pgn61441 - Electronic Brake Controller 1 - EBC1 ........................................................................................................ 304 |  | Yes
pgn61442 - Electronic Transmission Controller 1 - ETC1 ............................................................................................ 305 |  | Yes
pgn61443 - Electronic Engine Controller 2 - EEC2 ...................................................................................................... 305 |  | Yes
pgn61444 - Electronic Engine Controller 1 - EEC1 ...................................................................................................... 306 |  | Yes
pgn61445 - Electronic Transmission Controller 2 - ETC2 ............................................................................................ 306 |  | Yes
pgn61446 - Electronic Axle Controller 1 - EAC1 ......................................................................................................... 307 |  | Yes
pgn61447 - Forward Lane Image urgent msg - FLI1 .................................................................................................... 307 |  | Yes
pgn61448 - Hydraulic Pressure Governor [NAME] .................................................................................................. 307 |  | Yes
pgn61449 - Vehicle Dynamic Stability Control 2 - VDC2 ............................................................................................ 308 |  | Yes
pgn61450 - Engine Gas Flow Rate - EGF1 ................................................................................................................... 308 |  | Yes
pgn64977 - FMS-standard Interface Identity/Capabilities - FMS ................................................................................. 308 |  | Yes
pgn64978 - ECU Performance - EP ............................................................................................................................... 309 |  | Yes
pgn64979 - Turbocharger Information 6 - TCI6 ............................................................................................................ 309 |  | Yes
pgn64980 - Cab Message 3 - CM3 ................................................................................................................................ 309 |  | Yes
pgn64981 - Electronic Engine Controller 5 - EEC5 ...................................................................................................... 309 |  | Yes
pgn64982 - Basic Joystick Message 1 - BJM1 .............................................................................................................. 310 |  | Yes
pgn64983 - Extended Joystick Message 1 - EJM1 ........................................................................................................ 311 |  | Yes
pgn64984 - Basic Joystick Message 2 - BJM2 .............................................................................................................. 312 |  | Yes
pgn64985 - Extended Joystick Message 2 - EJM2 ........................................................................................................ 313 |  | Yes
pgn64986 - Basic Joystick Message 3 - BJM3 .............................................................................................................. 313 |  | Yes
pgn64987 - Extended Joystick Message 3 - EJM3 ........................................................................................................ 314 |  | Yes
pgn64988 - Marine Control Information - MCI ............................................................................................................ 315 |  | Yes
pgn64991 - Front Wheel Drive Status - FWD ............................................................................................................... 315 |  | Yes
pgn64992 - Ambient Conditions 2 - AMB2 .................................................................................................................. 316 |  | Yes
pgn64993 - Cab A/C Climate System Information - CACI ........................................................................................... 316 |  | Yes
pgn64994 - Supply Pressure Demand - SPR ................................................................................................................. 316 |  | Yes
pgn64995 - Equipment Operation and Control - EOAC ............................................................................................... 317 |  | Yes
pgn64996 - Equipment Performance Data - EPD .......................................................................................................... 317 |  | Yes
pgn64997 - Maximum Vehicle Speed Limit Status - MVS ........................................................................................... 317 |  | Yes
pgn64998 - Hydraulic Braking System - HBS .............................................................................................................. 318 |  | Yes
pgn65031 - Exhaust Temperature - ET .......................................................................................................................... 318 |  | Yes
pgn65088 - Lighting Data - LD ..................................................................................................................................... 318 |  | Yes
pgn65089 - Lighting Command - LC ............................................................................................................................ 319 |  | Yes
pgn65099 - Transmission Configuration 2 - TCFG2 ..................................................................................................... 320 |  | Yes
pgn65100 - Military Lighting Command - ML ............................................................................................................. 321 |  | Yes
pgn65101 - Total Averaged Information - TAVG ......................................................................................................... 321 |  | Yes
pgn65102 - Door Control - DC ...................................................................................................................................... 321 |  | Yes
pgn65103 - Vehicle Dynamic Stability Control 1 - VDC1 ............................................................................................ 322 |  | Yes
pgn65104 - Battery Temperature - BT1 ......................................................................................................................... 322 |  | Yes
pgn65105 - Adaptive Cruise Control, Operator [NAME] ...................................................................................... 322 |  | Yes
pgn65106 - Vehicle Electrical Power 3 - VP3 ............................................................................................................... 323 |  | Yes
pgn65107 - Retarder Continuous Torque & Speed Limit - RTC1 ................................................................................. 323 |  | Yes
pgn65108 - Engine Continuous Torque & Speed Limit - ECT1 ................................................................................... 323 |  | Yes
pgn65109 - Gaseous Fuel Properties - GFD .................................................................................................................. 324 |  | Yes
pgn65110 - TANK Information 1 - TI1 ......................................................................................................................... 324 |  | Yes
pgn65111 - Air Suspension Control 5 - ASC5 .............................................................................................................. 324 |  | Yes
pgn65112 - Air Suspension Control 4 - ASC4 .............................................................................................................. 325 |  | Yes
pgn65113 - Air Suspension Control 3 - ASC3 .............................................................................................................. 325 |  | Yes
pgn65114 - Air Suspension Control 1 - ASC1 .............................................................................................................. 325 |  | Yes
pgn65115 - Forward Lane Image - FLI2 ....................................................................................................................... 326 |  | Yes
pgn65126 - Battery Main Switch Information - BM ..................................................................................................... 326 |  | Yes
pgn65127 - Climate Control Configuration - CCC ........................................................................................................ 327 |  | Yes
pgn65128 - Vehicle Fluids - VF .................................................................................................................................... 327 |  | Yes
pgn65129 - Engine Temperature 3 - ET3 ...................................................................................................................... 327 |  | Yes
pgn65130 - Engine Fuel/lube systems - EFS ................................................................................................................. 327 |  | Yes
pgn65131 - Driver's Identification - DI ......................................................................................................................... 328 |  | Yes
pgn65132 - Tachograph - TCO1 .................................................................................................................................... 328 |  | Yes
pgn65133 - Heater Information - HTR .......................................................................................................................... 329 |  | Yes
pgn65134 - High Resolution Wheel Speed - HRW ....................................................................................................... 329 |  | Yes
pgn65135 - Adaptive Cruise Control - ACC1 ............................................................................................................... 329 |  | Yes
pgn65136 - Combination Vehicle Weight - CVW ........................................................................................................ 331 |  | Yes
pgn65137 - Laser Tracer Position - LTP ....................................................................................................................... 331 |  | Yes
pgn65138 - Laser Leveling System Blade Control - LBC ............................................................................................. 332 |  | Yes
pgn65139 - Laser Receiver Mast Position - LMP ......................................................................................................... 332 |  | Yes
pgn65140 - Modify Leveling System Control Set Point - LSP ..................................................................................... 332 |  | Yes
pgn65141 - Laser Leveling System Vertical Deviation - LVD ..................................................................................... 333 |  | Yes
pgn65142 - Laser Leveling System Vertical Position Display Data - LVDD ............................................................... 333 |  | Yes
pgn65143 - Auxiliary Pressures - AP ............................................................................................................................ 333 |  | Yes
pgn65144 - Tire Pressure Control Unit Mode and Status - TP1 .................................................................................... 334 |  | Yes
pgn65145 - Tire Pressure Control Unit Target Pressures - TP2 .................................................................................... 334 |  | Yes
pgn65146 - Tire Pressure Control Unit Current Pressures - TP3 .................................................................................. 334 |  | Yes
pgn65147 - Combustion Time 1 - CT1 .......................................................................................................................... 335 |  | Yes
pgn65148 - Combustion Time 2 - CT2 .......................................................................................................................... 335 |  | Yes
pgn65149 - Combustion Time 3 - CT3 .......................................................................................................................... 335 |  | Yes
pgn65150 - Combustion Time 4 - CT4 .......................................................................................................................... 336 |  | Yes
pgn65151 - Combustion Time 5 - CT5 .......................................................................................................................... 336 |  | Yes
pgn65152 - Combustion Time 6 - CT6 .......................................................................................................................... 336 |  | Yes
pgn65153 - Fuel Information 2 (Gaseous) - GFI2 ......................................................................................................... 336 |  | Yes
pgn65154 - Ignition Timing 1 - IT1 ............................................................................................................................... 337 |  | Yes
pgn65155 - Ignition Timing 2 - IT2 ............................................................................................................................... 337 |  | Yes
pgn65156 - Ignition Timing 3 - IT3 ............................................................................................................................... 337 |  | Yes
pgn65157 - Ignition Timing 4 - IT4 ............................................................................................................................... 338 |  | Yes
pgn65158 - Ignition Timing 5 - IT5 ............................................................................................................................... 338 |  | Yes
pgn65159 - Ignition Timing 6 - IT6 ............................................................................................................................... 338 |  | Yes
pgn65160 - Ignition Transformer Secondary Output 1 - ISO1 ...................................................................................... 339 |  | Yes
pgn65161 - Ignition Transformer Secondary Output 2 - ISO2 ...................................................................................... 339 |  | Yes
pgn65162 - Ignition Transformer Secondary Output 3 - ISO3 ...................................................................................... 339 |  | Yes
[NAME] ..................................................................................................................... 340 |  | Yes
pgn65164 - Auxiliary Analog Information - AAI .......................................................................................................... 340 |  | Yes
pgn65165 - Vehicle Electrical Power 2 - VP2 ............................................................................................................... 340 |  | Yes
pgn65166 - Service 2 - S2 .............................................................................................................................................. 341 |  | Yes
pgn65167 - Supply Pressure 2 - SP2 .............................................................................................................................. 341 |  | Yes
pgn65168 - Engine Torque History - ETH .................................................................................................................... 341 |  | Yes
pgn65169 - Fuel Leakage - FL ....................................................................................................................................... 342 |  | Yes
pgn65170 - Engine Information - EI .............................................................................................................................. 342 |  | Yes
pgn65171 - Engine Electrical System/Module Information - EES ................................................................................ 343 |  | Yes
pgn65172 - Engine Auxiliary Coolant - EAC ................................................................................................................ 343 |  | Yes
pgn65173 - Rebuild Information - RBI ......................................................................................................................... 343 |  | Yes
pgn65174 - Turbocharger Wastegate - TCW ................................................................................................................. 343 |  | Yes
pgn65175 - Turbocharger Information 5 - TCI5 ............................................................................................................ 344 |  | Yes
pgn65176 - Turbocharger Information 4 - TCI4 ............................................................................................................ 344 |  | Yes
pgn65177 - Turbocharger Information 3 - TCI3 ............................................................................................................ 344 |  | Yes
pgn65178 - Turbocharger Information 2 - TCI2 ............................................................................................................ 345 |  | Yes
pgn65179 - Turbocharger Information 1 - TCI1 ............................................................................................................ 345 |  | Yes
pgn65180 - Main Bearing Temperature 3 - MBT3 ........................................................................................................ 345 |  | Yes
pgn65181 - Main Bearing Temperature 2 - MBT2 ........................................................................................................ 346 |  | Yes
pgn65182 - Main Bearing Temperature 1 - MBT1 ........................................................................................................ 346 |  | Yes
pgn65183 - Exhaust Port Temperature 5 - EPT5 ........................................................................................................... 346 |  | Yes
pgn65184 - Exhaust Port Temperature 4 - EPT4 ........................................................................................................... 347 |  | Yes
pgn65185 - Exhaust Port Temperature 3 - EPT3 ........................................................................................................... 347 |  | Yes
pgn65186 - Exhaust Port Temperature 2 - EPT2 ........................................................................................................... 347 |  | Yes
pgn65187 - Exhaust Port Temperature 1 - EPT1 ........................................................................................................... 348 |  | Yes
pgn65188 - Engine Temperature 2 - ET2 ...................................................................................................................... 348 |  | Yes
pgn65189 - Intake Manifold Information 2 - IMT2 ....................................................................................................... 348 |  | Yes
pgn65190 - Intake Manifold Information 1 - IMT1 ....................................................................................................... 348 |  | Yes
pgn65191 - Alternator Temperature - AT ...................................................................................................................... 349 |  | Yes
pgn65192 - Articulation Control - AC ........................................................................................................................... 349 |  | Yes
pgn65193 - Exhaust Oxygen 1 - EO1 ............................................................................................................................ 349 |  | Yes
pgn65194 - Alternate Fuel 2 - AF2 ................................................................................................................................ 350 |  | Yes
pgn65195 - Electronic Transmission Controller 6 - ETC6 ............................................................................................ 350 |  | Yes
pgn65196 - Wheel Brake Lining Remaining Information - EBC4 ................................................................................ 350 |  | Yes
pgn65197 - Wheel Application Pressure High Range Information - EBC3 .................................................................. 351 |  | Yes
pgn65198 - Air Supply Pressure - AIR1 ........................................................................................................................ 351 |  | Yes
pgn65199 - Fuel Consumption (Gaseous) - GFC .......................................................................................................... 351 |  | Yes
pgn65200 - Trip Time Information 2 - TTI2 ................................................................................................................. 352 |  | Yes
pgn65201 - ECU History - EH ....................................................................................................................................... 352 |  | Yes
pgn65202 - Fuel Information 1 (Gaseous) - GFI1 ......................................................................................................... 352 |  | Yes
pgn65203 - Fuel Information (Liquid) - LFI ................................................................................................................. 353 |  | Yes
pgn65204 - Trip Time Information 1 - TTI1 ................................................................................................................. 353 |  | Yes
pgn65205 - Trip Shutdown Information - TSI ............................................................................................................... 353 |  | Yes
pgn65206 - Trip Vehicle Speed/Cruise Distance Information - TVI ............................................................................ 354 |  | Yes
pgn65207 - Engine Speed/Load Factor Information - LF ............................................................................................. 354 |  | Yes
pgn65208 - Trip Fuel Information (Gaseous) - GTFI .................................................................................................... 354 |  | Yes
pgn65209 - Trip Fuel Information (Liquid) - LTFI ....................................................................................................... 354 |  | Yes
pgn65210 - Trip Distance Information - TDI ................................................................................................................ 355 |  | Yes
pgn65211 - Trip Fan Information - TFI ......................................................................................................................... 355 |  | Yes
pgn65212 - Compression/Service Brake Information - CBI ......................................................................................... 355 |  | Yes
pgn65213 - Fan Drive - FD ............................................................................................................................................ 356 |  | Yes
pgn65214 - Electronic Engine Controller 4 - EEC4 ...................................................................................................... 356 |  | Yes
pgn65215 - Wheel Speed Information - EBC2 .............................................................................................................. 356 |  | Yes
pgn65216 - Service Information - SERV ....................................................................................................................... 357 |  | Yes
pgn65217 - High Resolution Vehicle Distance - VDHR ............................................................................................... 357 |  | Yes
pgn65218 - Electronic Retarder Controller 2 - ERC2 ................................................................................................... 357 |  | Yes
pgn65219 - Electronic Transmission Controller 5 - ETC5 ............................................................................................ 358 |  | Yes
pgn65221 - Electronic Transmission Controller 4 - ETC4 ............................................................................................ 358 |  | Yes
pgn65223 - Electronic Transmission Controller 3 - ETC3 ............................................................................................ 358 |  | Yes
pgn65237 - Alternator Speed - AS ................................................................................................................................. 359 |  | Yes
pgn65241 - Auxiliary Input/Output Status - AUXIO .................................................................................................... 359 |  | Yes
pgn65242 - Software Identification - SOFT .................................................................................................................. 360 |  | Yes
pgn65243 - Engine Fluid Level/Pressure 2 - EFL/P2 .................................................................................................... 360 |  | Yes
pgn65244 - Idle Operation - IO ..................................................................................................................................... 360 |  | Yes
pgn65245 - Turbocharger - TC ...................................................................................................................................... 361 |  | Yes
pgn65246 - Air Start Pressure - AIR2 ............................................................................................................................ 361 |  | Yes
pgn65247 - Electronic Engine Controller 3 - EEC3 ...................................................................................................... 361 |  | Yes
pgn65248 - Vehicle Distance - VD ................................................................................................................................ 362 |  | Yes
pgn65249 - Retarder Configuration - RC ...................................................................................................................... 362 |  | Yes
pgn65250 - Transmission Configuration - TCFG .......................................................................................................... 363 |  | Yes
pgn65251 - Engine Configuration - EC ......................................................................................................................... 364 |  | Yes
pgn65252 - Shutdown - SHUTDOWN .......................................................................................................................... 367 |  | Yes
pgn65253 - Engine Hours, Revolutions - HOURS ........................................................................................................ 367 |  | Yes
pgn65254 - Time/Date - TD .......................................................................................................................................... 368 |  | Yes
pgn65255 - Vehicle Hours - VH .................................................................................................................................... 368 |  | Yes
pgn65256 - Vehicle Direction/Speed - VDS ................................................................................................................. 368 |  | Yes
pgn65257 - Fuel Consumption (Liquid) - LFC .............................................................................................................. 369 |  | Yes
pgn65258 - Vehicle Weight - VW ................................................................................................................................. 369 |  | Yes
pgn65259 - Component Identification - CI .................................................................................................................... 369 |  | Yes
pgn65260 - Vehicle Identification - VI .......................................................................................................................... 370 |  | Yes
pgn65261 - Cruise Control/Vehicle Speed Setup - CCSS ............................................................................................. 370 |  | Yes
pgn65262 - Engine Temperature 1 - ET1 ...................................................................................................................... 371 |  | Yes
pgn65263 - Engine Fluid Level/Pressure 1 - EFL/P1 .................................................................................................... 371 |  | Yes
pgn65264 - Power Takeoff Information - PTO ............................................................................................................. 371 |  | Yes
pgn65265 - Cruise Control/Vehicle Speed - CCVS ...................................................................................................... 372 |  | Yes
pgn65266 - Fuel Economy (Liquid) - LFE .................................................................................................................... 372 |  | Yes
pgn65267 - Vehicle Position - VP ................................................................................................................................. 373 |  | Yes
pgn65268 - Tire Condition - TIRE ................................................................................................................................ 373 |  | Yes
pgn65269 - Ambient Conditions - AMB ....................................................................................................................... 373 |  | Yes
pgn65270 - Inlet/Exhaust Conditions 1 - IC1 ................................................................................................................ 374 |  | Yes
pgn65271 - Vehicle Electrical Power - VEP ................................................................................................................. 374 |  | Yes
pgn65272 - Transmission Fluids - TF ............................................................................................................................ 374 |  | Yes
pgn65273 - Axle Information - AI ................................................................................................................................. 375 |  | Yes
pgn65274 - Brakes - B ................................................................................................................................................... 375 |  | Yes
pgn65275 - Retarder fluids - RF .................................................................................................................................... 376 |  | Yes
pgn65276 - Dash Display - DD ..................................................................................................................................... 376 |  | Yes
pgn65277 - Alternate Fuel 1 - A1 .................................................................................................................................. 376 |  | Yes
pgn65278 - Auxiliary Water Pump Pressure - AWPP ................................................................................................... 376 |  | Yes
pgn65279 - Water in Fuel Indicator - WFI .................................................................................................................... 377 |  | Yes