Skip to main content

Microsoft Excel Sample Program

Microsoft Excel Simulation Program

Screen layout (Setting sheet)

Excel Setting sheet
#ItemDescription
1Connect buttonRecognizes the MicroPeckerX units connected to the PC when clicked.
2CAN / CAN FD SettingConfigures the baud rate, sample point, and whether to enable termination resistors.
3Slot SettingConfigures the periodic transmission preset frame (No. 1) and the event transmission preset frame (No. 2).
4Direct Send SettingConfigures the direct transmission preset frame.

Screen layout (Monitoring sheet)

Excel Monitoring sheet
#ItemDescription
1Start buttonStarts monitoring when clicked and sends the periodic transmission preset frame based on the Setting sheet configuration.
2Stop buttonStops monitoring and stops sending the periodic transmission preset frame when clicked.
3Send Slot buttonSends the event transmission preset frame when clicked.
4Change Slot buttonChanges the data (only D1) of the periodic transmission preset frame to 00H when clicked.
5Direct Send buttonSends the direct transmission preset frame when clicked.
6Monitor Log (Note 1)Displays the log information for transmitted and received frames. The log updates every second, clearing all previous entries at that time.
If no log information exists, the display is not updated and the previous entries remain.

Log viewer details

#ItemDescription
1Time StampDisplays timestamps in the format sssss.mmmuuu.
2DirDisplays the log direction.
Rx: Receive log / Tx: Transmit log
3IDDisplays the CAN ID and ID format. The CAN ID is shown in hexadecimal, and the format is displayed as follows.
Std: Standard ID / Ext: Extended ID
4DLCDisplays the data length (1 to 64).
5DataDisplays data (D1–D64) in hexadecimal.

Preset frames

The contents of each preset frame are shown below. You can modify the frame contents on the Setting sheet.

Frame typeSlotProtocolIDDLData (hexadecimal)
FormatCAN IDD1D2D8D64
Periodic transmission preset frame (Note 1)1CAN FDStandard ID100H640001073F
Event transmission preset frame2CANStandard ID200H8212228
Direct transmission preset frame-CAN FDStandard ID300H8313238

Note 1: Only D1 increments by +1 each time it is transmitted.