📦 Resource excel

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

The ISOBUS VT Message Mapping Excel Workbook operationalizes the ISO 11783-6 standard by decomposing complex VT object pools, control functions, and message sequences into structured, cross-referenced worksheets. Each worksheet typically includes columns for VT Object ID, Object Type (e.g., Button, Slider, Graphic), Parameter Group Number (PGN), SPN (Suspect Parameter Number), data type (UINT8, INT16, etc.), scaling factors, offset values, units, and semantic descriptions—enabling engineers to translate raw CAN frames into meaningful diagnostic or operational metrics. The workbook supports bidirectional mapping: from machine-side VT messages to cloud telemetry fields (e.g., 'Engine RPM' → PGN 65280, SPN 512, scaled via linear equation y = m·x + b), and vice versa for command injection (e.g., sending a VT Set Point command to adjust implement height). It is maintained and extended by OEMs, Tier 1 suppliers, and telematics platform providers to ensure alignment across heterogeneous ISOBUS-compliant ECUs, enabling plug-and-play integration without proprietary decoding logic. Validation workflows often involve correlating workbook mappings against live VT session logs captured via CAN analyzers (e.g., Vector CANoe) and verifying consistency with the official ISO 11783-6 Annexes and AEF (Agricultural Industry Electronics Foundation) conformance guidelines.

📑 Key Components

1 VT Object ID Mapping Table
2 PGN/SPN-to-Telematics-Field Crosswalk
3 Scaling & Offset Lookup Sheet

🎯 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

🔗 Related Concepts

ISO 11783-6 (Virtual Terminal) AEF ISOBUS Conformance Testing Telematics Data Schema (TDS)

📚 References

#ISOBUS #Telematics #Excel Resource #Fleet Diagnostics #VT Protocol