Skip to main content

Microsoft Excel Sample Program

Microsoft Excel Simulation Program

Screen Layout (Setting Sheet)

Excel Setting Sheet

| Item | Description

---|---|--- 1 | Connect button | Recognizes MicroPeckerX connected to the PC when clicked. 2 | CAN / CAN FD Setting | Sets baud rate, sample point, and termination resistor enable/disable. 3 | Slot Setting | Sets periodic preset frame (No.1) and event-transmission preset frame (No.2). 4 | Direct Send Setting | Sets direct-transmission preset frame.

Screen Layout (Monitoring Sheet)

Excel Monitoring Sheet

| Item | Description

:---:|---|--- 1 | Start button | Starts monitoring and transmits periodic preset frames based on settings on the Setting sheet. 2 | Stop button | Stops monitoring and periodic preset frame transmission. 3 | Send Slot button | Sends the event-transmission preset frame. 4 | Change Slot button | Changes data of the periodic preset frame (D1 only) to 00H. 5 | Direct Send button | Sends the direct-transmission preset frame. 6 | Monitor Log (*1) | Displays transmitted/received log information. Log information is updated every 1 second, and previous logs are fully cleared on update.
If there is no log information, it is not updated and the previous log remains displayed.

Log Display Details

| Item | Description

:---:|---|--- 1 | Time Stamp | Displays timestamp in sssss.mmmuuu format. 2 | Dir | Displays log direction.
Rx: received log, Tx: transmitted log 3 | ID | Displays CAN ID and ID format. CAN ID is shown in hexadecimal, and ID format is shown as below.
Std: standard ID, Ext: extended ID 4 | DLC | Displays data length (1 to 64). 5 | Data | Displays data (D1 to D64) in hexadecimal.

Preset Frames

The contents of each preset frame are as follows. Frame contents can be changed on the Setting sheet.

Frame TypeSlotProtocolIDDLData (Hex)
FormatCAN IDD1D2...D8...D64
Periodic preset frame (*1)1CAN FDStandard ID100H640001...07...3F
Event-transmission preset frame2CANStandard ID200H82122...28
Direct-transmission preset frame-CAN FDStandard ID300H83132...38

*1: Only D1 is incremented (+1) on each transmission.