ISOBUS VT Message Mapping Excel Workbook
The ISOBUS VT Message Mapping Excel Workbook is a standardized, tabular reference tool that maps ISOBUS Virtual Terminal (VT) protocol messages—defined in ISO 11783-6—to human-readable telemetry data elements within a telematics data schema. It enables consistent interpretation of agricultural and construction machinery VT messages for fleet diagnostics, remote monitoring, and interoperable HMI development. The workbook serves as a bridge between low-level CAN-based VT commands and high-level application logic in telematics platforms.
📖 Overview
📑 Key Components
🎯 Applications
- ✓ Fleet diagnostic rule engine configuration
- ✓ Telematics platform data ingestion pipeline design
- ✓ ISOBUS VT HMI emulator development
📐 Key Formulas
Physical Value Conversion
physical_value = (raw_value × scale_factor) + offset
Converts raw CAN payload bytes into engineering units (e.g., degrees Celsius, kPa, RPM)
SPN Bit Position Extraction
bit_start = (SPN_bit_position // 8), bit_offset = SPN_bit_position % 8
Determines byte index and bit offset within a PGN payload for multi-bit SPN extraction
VT Object State Encoding
encoded_state = (object_id << 16) | (instance_id << 8) | state_flags
Constructs 24-bit VT object identifier used in VT-Client-to-VT-Server command messages