AB
1
PLEASE NOTE: This will NOT work for modules using CANBUS This is written for modules using single wire serial data J1850 VPW. Enter starting PID as hex in cell A2, ending PID as hex in A3,copy A5 to serial terminal macro. NOTES: There is a maximum of 0x15AA PIDs. If a larger value is entered then the maximum will be used. You won't see the whole list in cell A5 because of cell height limits but they are all there and will be copied. ALSO: Your device might have limits on how much you can copy to clipboard.
2
1940
3
19aa
4
A6465:A6570=ARRAYFORMULA("A"&hex2dec(A2)+1&":"&"A"&if(or(hex2dec(A3)>hex2dec(A2)+5546,hex2dec(A3)<hex2dec(A2)),hex2dec(A2)+5546,hex2dec(A3)))
5
AT D
AT AL
AT H1
AT S1
AT TP 2
AT SH 68 6A F1
09 02
09 04
09 06
AT SH 6C 10 F1
20
22194101
22194201
22194301
22194401
22194501
22194601
22194701
22194801
22194901
22194A01
22194B01
22194C01
22194D01
22194E01
22194F01
22195001
22195101
22195201
22195301
22195401
22195501
22195601
22195701
22195801
22195901
22195A01
22195B01
22195C01
22195D01
22195E01
22195F01
22196001
22196101
22196201
22196301
22196401
22196501
22196601
22196701
22196801
22196901
22196A01
22196B01
22196C01
22196D01
22196E01
22196F01
22197001
22197101
22197201
22197301
22197401
22197501
22197601
22197701
22197801
22197901
22197A01
22197B01
22197C01
22197D01
22197E01
22197F01
22198001
22198101
22198201
22198301
22198401
22198501
22198601
22198701
22198801
22198901
22198A01
22198B01
22198C01
22198D01
22198E01
22198F01
22199001
22199101
22199201
22199301
22199401
22199501
22199601
22199701
22199801
22199901
22199A01
22199B01
22199C01
22199D01
22199E01
22199F01
2219A001
2219A101
2219A201
2219A301
2219A401
2219A501
2219A601
2219A701
2219A801
2219A901
2219AA01		=textjoin(char(10),0,"AT D","AT AL","AT H1","AT S1","AT TP 2","AT SH 68 6A F1","09 02","09 04","09 06","AT SH 6C 10 F1","20",ARRAYFORMULA("22"&dec2hex(row(indirect(A4)),4)&"01"))
6
7
8
9