{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["Calc"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Calc","index":0,"n_rows":20,"n_cols":11,"rows_kept":20,"cut":false,"hidden":false,"merged":[[7,3,7,10],[1,7,1,10],[5,7,5,9],[4,7,4,9],[3,7,3,9],[2,7,2,9],[4,3,4,5],[5,3,5,5],[1,3,1,6],[0,0,0,10],[8,3,8,5],[9,3,9,5],[10,3,10,5],[15,3,15,4],[15,5,15,10],[14,0,15,0],[14,2,15,2],[14,1,15,1],[11,3,11,10],[9,6,9,10],[2,3,2,5],[3,3,3,5],[12,4,12,9],[8,6,8,10],[6,3,6,5],[17,5,17,7],[17,8,17,10],[19,5,19,7],[19,8,19,10],[18,0,19,0],[18,2,19,2],[16,2,17,2],[18,1,19,1],[16,1,17,1],[16,0,17,0]]}
["MCP2515 Configuration Register Calculator"]
["Crystal Frequency",16,"MHz","Baud Register Values",null,null,null,"Misc Register Values"]
["Baud Rate",250,"kbs","Baud Rate Prescaler (BRP)",null,null,1,"PS2 Bit Time Mode (BTLMODE)",null,null,1]
[null,null,null,"Propogation Segment",null,null,1,"Sample Mode (SAM)",null,null,1]
["Time Quantum",{"$f":"(2*(B8+1))/B2","v":0.25},"microseconds","Phase Segment 1 (PS1)",null,null,6,"Start-of Frame Signal (SOF)",null,null,1]
["Bit Time",{"$f":"(1/B3)*1000","v":4},"microseconds","Phase Segment 2 (PS2)",null,null,5,"Wake-Up Filter (WAKFIL)",null,null,0]
["Time Quantum Max",{"$f":"B6/B5","v":16},null,"Synchronization Jump Width (SJW)",null,null,1]
["Prescaler Setting",{"$f":"BIN2DEC(CONCATENATE(F15,G15,H15,I15,J15,K15))+0","v":1},null,"Adjust BRP To Get A Nice Whole Time Quantum Max Value"]
["SJW",{"$f":"BIN2DEC(CONCATENATE(D15,E15))+1","v":2},"x TQ","PropSeg + PS1 >= PS2",null,null,"Bit Sample Point Occurs Between PS1 and PS2"]
["SyncSeg",1,"x TQ","PropSeg + PS1 >= TDELAY",null,null,"Typically, the TDELAY is 1-2 TQ"]
["PropSeg",{"$f":"BIN2DEC(CONCATENATE(I17,J17,K17))+1","v":2},"x TQ","PS2 > SJW"]
["PS1",{"$f":"BIN2DEC(CONCATENATE(F17,G17,H17))+1","v":7},"x TQ","MCP2515 Baud Registers"]
["PS2",{"$f":"BIN2DEC(CONCATENATE(I19,J19,K19))+1","v":6},"x TQ","msb",{"$nulls":6},"lsb"]
[null,{"$f":"SUM(B10:B13)","v":16}," Total TQ",7,6,5,4,3,2,1,0]
["Register CNF1",{"$f":"BIN2HEX(C15)","v":"41"},{"$f":"CONCATENATE(D15,E15,F15,G15,H15,I15,J15,K15)","v":"01000001"},{"$f":"MID(DEC2BIN(G7,2),1,1)","v":"0"},{"$f":"MID(DEC2BIN(G7,2),2,1)","v":"1"},{"$f":"MID(DEC2BIN(G3,8),3,1)","v":"0"},{"$f":"MID(DEC2BIN(G3,8),4,1)","v":"0"},{"$f":"MID(DEC2BIN(G3,8),5,1)","v":"0"},{"$f":"MID(DEC2BIN(G3,8),6,1)","v":"0"},{"$f":"MID(DEC2BIN(G3,8),7,1)","v":"0"},{"$f":"MID(DEC2BIN(G3,8),8,1)","v":"1"}]
[null,null,null,"SJW",null,"BRP"]
["Register CNF2",{"$f":"BIN2HEX(C17)","v":"F1"},{"$f":"CONCATENATE(D17,E17,F17,G17,H17,I17,J17,K17)","v":"11110001"},{"$f":"MID(DEC2BIN(K3,1),1,1)","v":"1"},{"$f":"MID(DEC2BIN(K4,1),1,1)","v":"1"},{"$f":"MID(DEC2BIN(G5,3),1,1)","v":"1"},{"$f":"MID(DEC2BIN(G5,3),2,1)","v":"1"},{"$f":"MID(DEC2BIN(G5,3),3,1)","v":"0"},{"$f":"MID(DEC2BIN(G4,3),1,1)","v":"0"},{"$f":"MID(DEC2BIN(G4,3),2,1)","v":"0"},{"$f":"MID(DEC2BIN(G4,3),3,1)","v":"1"}]
[null,null,null,"BTLMODE","SAM","PS1",null,null,"Prop"]
["Register CNF3",{"$f":"BIN2HEX(C19)","v":"85"},{"$f":"CONCATENATE(D19,E19,F19,G19,H19,I19,J19,K19)","v":"10000101"},{"$f":"MID(DEC2BIN(K5,1),1,1)","v":"1"},{"$f":"MID(DEC2BIN(K6,1),1,1)","v":"0"},0,0,0,{"$f":"MID(DEC2BIN(G6,8),6,1)","v":"1"},{"$f":"MID(DEC2BIN(G6,8),7,1)","v":"0"},{"$f":"MID(DEC2BIN(G6,8),8,1)","v":"1"}]
[null,null,null,"SOF","WAKFIL","Reserved “000”",null,null,"PS2"]