{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Release_Notes","Calculate_Bit_Timing","Sheet2","Sheet3","Sheet4"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":27,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"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":"Release_Notes","index":0,"n_rows":38,"n_cols":2,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
["*******************************************************************************"]
["NXP Semiconductor Inc."]
["(c) Copyright 2012 NXP Semiconductor, Inc."]
["ALL RIGHTS RESERVED."]
["********************************************************************************"]
["Services performed by NXP in this matter are performed AS IS and without"]
["any warranty. CUSTOMER retains the final decision relative to the total design"]
["and functionality of the end product. NXP neither guarantees nor will be"]
["held liable by CUSTOMER for the success of this project."]
["NXP DISCLAIMS ALL WARRANTIES, EXPRESSED, IMPLIED OR STATUTORY INCLUDING,"]
["BUT NOT LIMITED TO, IMPLIED WARRANTY OF MERCHANTABILITY OR FITNESS FOR"]
["A PARTICULAR PURPOSE ON ANY HARDWARE, SOFTWARE ORE ADVISE SUPPLIED "]
["TO THE PROJECT BY NXP, AND OR NAY PRODUCT RESULTING FROM NXP "]
["SERVICES. IN NO EVENT SHALL NXP BE LIABLE FOR INCIDENTAL OR CONSEQUENTIAL "]
["DAMAGES ARISING OUT OF THIS AGREEMENT."]
["CUSTOMER agrees to hold NXP harmless against any and all claims demands "]
["or actions by anyone on account of any damage, or injury, whether commercial,"]
["contractual, or tortuous, rising directly or indirectly as a result "]
["of the advise or assistance supplied CUSTOMER in connection with product, "]
["services or goods supplied under this Agreement."]
["********************************************************************************"]
["File:                 S32R274 DCF Configurator.xls","CAN Bit Timing calculation v1.0.xlsx"]
["Owner:           Petr Stancik"]
["Classification:   General Business Information"]
["********************************************************************************"]
["Detailed Description: "]
[]
["This tool simplifies CAN bit timing calculation for CAN modules (FlexCAN, MCAN) "]
["on automotive 32-bit MCUs available on MPC5xxx and S32K1xx families."]
["Use Calculate_Bit_Timing sheet"]
[]
["Note: Macros have to be enabled!"]
[]
["********************************************************************************"]
[]
["Revision History:"]
[]
["Version 1.0     Feb-10-2019     Petr Stancik"]

{"sheet":"Calculate_Bit_Timing","index":1,"n_rows":125,"n_cols":34,"rows_kept":125,"cut":false,"hidden":false,"merged":[[18,18,18,21],[18,22,18,25],[18,27,18,29],[18,30,18,31],[18,32,18,33],[13,18,13,20],[13,21,13,25],[14,18,14,20],[14,21,14,25],[17,18,17,21],[17,22,17,25],[17,27,17,29],[17,30,17,31],[17,32,17,33],[13,7,13,16],[14,1,14,6],[14,7,14,16],[17,1,17,2],[17,3,17,8],[17,9,17,12],[17,13,17,16],[18,1,18,2],[18,3,18,8],[18,9,18,12],[18,13,18,16],[21,32,21,33],[22,29,22,30],[22,32,22,33],[23,32,23,33],[24,32,24,33],[21,29,21,30],[25,15,25,16],[26,12,26,13],[26,15,26,16],[24,15,24,16],[25,12,25,13],[11,18,11,33],[13,27,13,28],[13,29,13,33],[14,27,14,28],[14,29,14,33],[13,1,13,6],[63,15,63,16],[64,15,64,16],[53,15,53,16],[54,15,54,16],[55,15,55,16],[56,15,56,16],[58,15,58,16],[59,15,59,16],[60,15,60,16],[61,15,61,16],[62,15,62,16],[57,15,57,16],[58,12,58,13],[59,12,59,13],[60,12,60,13],[61,12,61,13],[66,12,66,13],[62,12,62,13],[63,12,63,13],[64,12,64,13],[56,12,56,13],[57,12,57,13],[88,12,88,13],[82,12,82,13],[83,12,83,13],[84,12,84,13],[85,12,85,13],[86,12,86,13],[89,12,89,13],[90,12,90,13],[65,12,65,13],[77,12,77,13],[67,12,67,13],[68,12,68,13],[69,12,69,13],[70,12,70,13],[78,12,78,13],[72,12,72,13],[73,12,73,13],[74,12,74,13],[75,12,75,13],[76,12,76,13],[71,12,71,13],[80,12,80,13],[81,12,81,13],[87,12,87,13],[91,12,91,13],[111,12,111,13],[102,12,102,13],[103,12,103,13],[104,12,104,13],[105,12,105,13],[106,12,106,13],[100,12,100,13],[101,12,101,13],[97,12,97,13],[98,12,98,13],[99,12,99,13],[107,12,107,13],[109,12,109,13],[110,12,110,13],[108,12,108,13],[96,12,96,13],[92,12,92,13],[93,12,93,13],[94,12,94,13],[95,12,95,13],[123,12,123,13],[124,12,124,13],[117,12,117,13],[118,12,118,13],[119,12,119,13],[120,12,120,13],[121,12,121,13],[112,12,112,13],[113,12,113,13],[114,12,114,13],[115,12,115,13],[116,12,116,13],[122,12,122,13],[123,15,123,16],[124,15,124,16],[118,15,118,16],[119,15,119,16],[120,15,120,16],[121,15,121,16],[122,15,122,16],[113,15,113,16],[94,15,94,16],[95,15,95,16],[96,15,96,16],[97,15,97,16],[114,15,114,16],[115,15,115,16],[116,15,116,16],[117,15,117,16],[108,15,108,16],[109,15,109,16],[110,15,110,16],[111,15,111,16],[112,15,112,16],[103,15,103,16],[104,15,104,16],[105,15,105,16],[106,15,106,16],[107,15,107,16],[98,15,98,16],[99,15,99,16],[100,15,100,16],[101,15,101,16],[102,15,102,16],[93,15,93,16],[78,15,78,16],[79,15,79,16],[80,15,80,16],[81,15,81,16],[82,15,82,16],[88,15,88,16],[89,15,89,16],[90,15,90,16],[91,15,91,16],[92,15,92,16],[83,15,83,16],[84,15,84,16],[85,15,85,16],[86,15,86,16],[87,15,87,16],[73,15,73,16],[74,15,74,16],[75,15,75,16],[76,15,76,16],[77,15,77,16],[79,12,79,13],[65,15,65,16],[66,15,66,16],[67,15,67,16],[68,15,68,16],[69,15,69,16],[70,15,70,16],[71,15,71,16],[72,15,72,16],[3,9,3,11],[5,9,5,11],[4,9,4,11],[5,6,5,8],[3,3,3,5],[4,6,4,8],[3,6,3,8],[4,3,4,5],[5,3,5,5],[52,12,52,13],[53,12,53,13],[54,12,54,13],[55,12,55,13],[11,1,11,16],[1,1,1,2],[4,1,4,2],[5,1,5,2],[1,6,1,8],[1,9,1,11],[1,3,1,5],[50,15,50,16],[51,15,51,16],[52,15,52,16],[3,1,3,2],[50,12,50,13],[51,12,51,13],[21,12,21,13],[21,15,21,16],[22,12,22,13],[22,15,22,16],[23,12,23,13],[23,15,23,16],[24,12,24,13]]}
[]
[null,"Device",null,"MPC5777M",null,null,"fcpi [MHz]",null,null,40]
[]
[null,"Transceiver",null,"TJA1051",null,null,"baudrate [kbps]",null,null,1000]
[null,"propTXRX [ns]",null,250,null,null,"baudrate FD [kbps]",null,null,5000]
[null,"bus length [m]",null,1,null,null,"samp. point [%]",null,null,75]
[]
[]
[null,null,null,""]
[]
[]
[null,{"$f":"\"CANx_BTP = 0x\"&DEC2HEX(2^16*H15+2^8*D19+2^4*J19+N19,8)","v":"CANx_BTP = 0x00001C99"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"CANx_FBTP = 0x\"&DEC2HEX(2^24*V15+2^23*AA15+2^16*AD15+2^8*W19+2^4*AB19+AG19,8)","v":"CANx_FBTP = 0x04800411"}]
[null,0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,null,0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15]
[null,null,null,null,null,null,null,"BPR",null,null,null,null,null,null,null,null,null,null,null,null,null,"TDCO",null,null,null,null,"TDC",null,null,"FBRP"]
[null,0,null,null,null,null,null,{"$f":"presc-1","v":0},null,null,null,null,null,null,null,null,null,null,0,null,null,{"$f":"tdc_off","v":4},null,null,null,null,{"$f":"tdc_en","v":1},0,null,{"$f":"prescFD-1","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"1+L15","v":1},null,null,{"$f":"1+O15","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"1+AC15","v":1},null,null,{"$f":"1+AF15","v":1}]
[null,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,null,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31]
[null,null,null,"TSEG1",null,null,null,null,null,"TSEG2",null,null,null,"SJW",null,null,null,null,null,null,null,null,"FTSEG1",null,null,null,null,"FTSEG2",null,null,null,null,"FSJW"]
[null,0,null,{"$f":"prop+pseg1-1","v":28},null,null,null,null,null,{"$f":"pseg2-1","v":9},null,null,null,{"$f":"rjw-1","v":9},null,null,null,null,0,null,null,null,{"$f":"pseg1FD+propFD-1","v":4},null,null,null,0,{"$f":"pseg2FD-1","v":1},null,null,0,null,{"$f":"rjwFD-1","v":1}]
[]
[null,{"$f":"Calculate_Bit_Timing!$B$12&\";  // bitrate=\"&bitrate&\"kbps, CPI clk=\"&cpiclock&\" MHz; Prescaler= \"&presc&\", PROPSEG=\"&prop&\", PSEG1=\"&pseg1&\", PSEG2=\"&pseg2&\", RJW=\"&rjw&\", smp=\"&100-pseg2/(1+prop+pseg1+pseg2)*100&\"%\"","v":"CANx_BTP = 0x00001C99;  // bitrate=1000kbps, CPI clk=40 MHz; Prescaler= 1, PROPSEG=21, PSEG1=8, PSEG2=10, RJW=10, smp=75%"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Calculate_Bit_Timing!$S$12&\";  // bitrateFD=\"&bitrate_fd&\"kbps, CPI clk=\"&cpiclock&\" MHz; fPrescaler= \"&prescFD&\", fPROPSEG=\"&propFD&\", fPSEG1=\"&pseg1FD&\", fPSEG2=\"&pseg2FD&\", fRJW=\"&rjwFD&\", smp=\"&100-pseg2FD/(1+propFD+pseg1FD+pseg2FD)*100&\"%\"","v":"CANx_FBTP = 0x04800411;  // bitrateFD=5000kbps, CPI clk=40 MHz; fPrescaler= 1, fPROPSEG=2, fPSEG1=3, fPSEG2=2, fRJW=2, smp=75%"}]
[null,"Prescaler","Sclock","Tq","NBT","PROPSEG","PSEG1","PSEG2","RJW",null,"Df",null,"sample point",null,null,{"$f":"LEFT(Calculate_Bit_Timing!$B$12,LEN(Calculate_Bit_Timing!$B$12)-13)","v":"CANx_BTP"},null,null,"fPrescaler","fSclock","fTq","fNBT","fPROPSEG","fPSEG1","fPSEG2","fRJW",null,"TDCEN","TDCOFF","sample point",null,null,{"$f":"LEFT(Calculate_Bit_Timing!$S$12,LEN(Calculate_Bit_Timing!$S$12)-13)","v":"CANx_FBTP"}]
[null,"[-]","[MHz]","[ns]","[#Tq]","[#Tq]","[#Tq]","[#Tq]","[#Tq]",null,"[%]",null,"[%]",null,null,"[hex]",null,null,"[-]","[MHz]","[ns]","[#Tq]","[#Tq]","[#Tq]","[#Tq]","[#Tq]",null,"[-]","[-]","[%]",null,null,"[hex]"]
[1,1,{"$f":"IF(ISNUMBER(B24),cpiclock/B24,\"\")","v":40},{"$f":"IF(ISNUMBER(B24),1000/C24,\"\")","v":25},40,21,8,10,10,null,{"$f":"IF(ISNUMBER(B24),MIN(I24/20/E24*100,MIN(G24,H24)/2/(13*E24-H24)*100),\"\")","v":0.78431372549019607},null,{"$f":"IF(ISNUMBER(B24),100-H24/E24*100,\"\")","v":75},null,null,{"$f":"INDEX(Sheet2!$R$20:$U$20,1,selected_reg)","v":"0x00001B99"},null,1,1,{"$f":"IF(ISNUMBER(R24),cpiclock/S24,\"\")","v":40},{"$f":"IF(ISNUMBER(R24),1000/T24,\"\")","v":25},8,2,3,2,2,null,1,{"$f":"IF(ISNUMBER(R24),IF(AB24=0,0,cpiclock/(2*bitrate_fd/1000)),\"\")","v":4},null,{"$f":"IF(ISNUMBER(S24),100-Y24/V24*100,\"\")","v":75},null,{"$f":"INDEX(Sheet2!$AM$20:$AP$20,1,selected_regFD-4)","v":"0x04800411"}]
[2,2,20,{"$f":"IF(ISNUMBER(B25),1000/C25,\"\")","v":50},20,11,3,5,5,null,{"$f":"IF(ISNUMBER(B25),MIN(I25/20/E25*100,MIN(G25,H25)/2/(13*E25-H25)*100),\"\")","v":0.58823529411764708},null,{"$f":"IF(ISNUMBER(B25),100-H25/E25*100,\"\")","v":75},null,null,{"$f":"INDEX(Sheet2!$R$21:$U$21,1,selected_reg)","v":"0x00010C44"},null,2,2,20,{"$f":"IF(ISNUMBER(R25),1000/T25,\"\")","v":50},4,0,2,1,1,null,1,4,null,75,null,{"$f":"INDEX(Sheet2!$AM$21:$AP$21,1,selected_regFD-4)","v":"0x04810100"}]
[3,4,10,100,10,6,1,2,2,null,0.390625,null,80,null,null,{"$f":"INDEX(Sheet2!$R$22:$U$22,1,selected_reg)","v":"0x00030511"}]
[4,5,8,125,8,5,1,1,1,null,0.48543689320388345,null,87.5,null,null,{"$f":"INDEX(Sheet2!$R$23:$U$23,1,selected_reg)","v":"0x00040400"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(B101),MIN(I101/20/E101*100,MIN(G101,H101)/2/(13*E101-H101)*100),\"\")","v":""},null,{"$f":"IF(ISNUMBER(B101),100-H101/E101*100,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,"",null,""]

{"sheet":"Sheet2","index":2,"n_rows":73,"n_cols":42,"rows_kept":73,"cut":false,"hidden":true,"merged":[[38,15,38,16],[39,15,39,16],[28,15,28,16],[29,15,29,16],[30,15,30,16],[31,15,31,16],[32,15,32,16],[33,15,33,16],[34,15,34,16],[35,15,35,16],[36,15,36,16],[37,15,37,16],[39,12,39,13],[19,15,19,16],[20,15,20,16],[21,15,21,16],[22,15,22,16],[23,15,23,16],[24,15,24,16],[25,15,25,16],[26,15,26,16],[27,15,27,16],[33,12,33,13],[34,12,34,13],[35,12,35,13],[36,12,36,13],[37,12,37,13],[38,12,38,13],[32,12,32,13],[21,12,21,13],[22,12,22,13],[23,12,23,13],[24,12,24,13],[25,12,25,13],[26,12,26,13],[27,12,27,13],[28,12,28,13],[29,12,29,13],[30,12,30,13],[31,12,31,13],[20,12,20,13],[17,12,17,13],[17,15,17,16],[18,12,18,13],[18,15,18,16],[19,12,19,13],[17,33,17,34],[17,36,17,37],[18,33,18,34],[18,36,18,37],[19,36,19,37],[20,36,20,37],[21,36,21,37],[22,36,22,37],[23,36,23,37],[24,36,24,37],[25,36,25,37],[26,36,26,37],[27,36,27,37],[28,36,28,37],[29,36,29,37],[30,36,30,37],[31,36,31,37],[32,36,32,37],[33,36,33,37],[34,36,34,37],[35,36,35,37],[36,36,36,37],[37,36,37,37],[38,36,38,37],[39,36,39,37]]}
[]
[null,"CPI clock",{"$f":"cpiclock","v":40}]
[null,"baudrate",{"$f":"bitrate","v":1000},null,"baud fd",{"$f":"bitrate_fd","v":5000}]
[null,"prop-delay",{"$f":"2*($F$4+bus_length*5)","v":510},null,"PHY prop",{"$f":"Calculate_Bit_Timing!D5","v":250},null,"req_smp",{"$f":"req_smp","v":75},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTA(A20:A40)","v":4}]
[]
[null,"IPT",{"$f":"INDIRECT(\"Sheet3!AC\"&( 10*Sheet3!$C$3+ROW(C6)-5))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IPT",{"$f":"IF(Sheet3!$C$4>0,INDIRECT(\"Sheet3!AC\"&( 10*Sheet3!$C$4+ROW(C6)-5)),0)","v":0}]
[null,"NBT min",{"$f":"INDIRECT(\"Sheet3!AC\"&( 10*Sheet3!$C$3+ROW(C7)-5))","v":4},null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NBT min",{"$f":"IF(Sheet3!$C$4>0,INDIRECT(\"Sheet3!AC\"&( 10*Sheet3!$C$4+ROW(C7)-5)),0)","v":4},null,null,null,1]
[null,"NBT max",{"$f":"INDIRECT(\"Sheet3!AC\"&( 10*Sheet3!$C$3+ROW(C8)-5))","v":81},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NBT max",{"$f":"IF(Sheet3!$C$4>0,INDIRECT(\"Sheet3!AC\"&( 10*Sheet3!$C$4+ROW(C8)-5)),0)","v":81}]
[null,"Prescaler min",{"$f":"INDIRECT(\"Sheet3!AC\"&( 10*Sheet3!$C$3+ROW(C9)-5))","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Prescaler min",{"$f":"IF(Sheet3!$C$4>0,INDIRECT(\"Sheet3!AC\"&( 10*Sheet3!$C$4+ROW(C9)-5)),0)","v":1}]
[null,"Prescaler max",{"$f":"INDIRECT(\"Sheet3!AC\"&( 10*Sheet3!$C$3+ROW(C10)-5))","v":1024},null,null,null,{"$f":"INDIRECT(\"B\"&(19+selrow))","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Prescaler max",{"$f":"IF(Sheet3!$C$4>0,INDIRECT(\"Sheet3!AC\"&( 10*Sheet3!$C$4+ROW(C10)-5)),0)","v":1024},null,null,null,{"$f":"INDIRECT(\"w\"&(19+selrowFD))","v":1}]
[null,"PropSeg",{"$f":"INDIRECT(\"Sheet3!AC\"&( 10*Sheet3!$C$3+ROW(C11)-5))","v":48},null,null,null,{"$f":"INDIRECT(\"F\"&(19+selrow))","v":21},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PropSeg",{"$f":"IF(Sheet3!$C$4>0,INDIRECT(\"Sheet3!AC\"&( 10*Sheet3!$C$4+ROW(C11)-5)),0)","v":48},null,null,null,{"$f":"INDIRECT(\"aa\"&(19+selrowFD))","v":2}]
[null,"Pseg1",{"$f":"INDIRECT(\"Sheet3!AC\"&( 10*Sheet3!$C$3+ROW(C12)-5))","v":16},null,null,null,{"$f":"INDIRECT(\"G\"&(19+selrow))","v":8},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pseg1",{"$f":"IF(Sheet3!$C$4>0,INDIRECT(\"Sheet3!AC\"&( 10*Sheet3!$C$4+ROW(C12)-5)),0)","v":16},null,null,null,{"$f":"INDIRECT(\"ab\"&(19+selrowFD))","v":3}]
[null,"Pseg2",{"$f":"INDIRECT(\"Sheet3!AC\"&( 10*Sheet3!$C$3+ROW(C13)-5))","v":16},null,null,null,{"$f":"INDIRECT(\"H\"&(19+selrow))","v":10},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pseg2",{"$f":"IF(Sheet3!$C$4>0,INDIRECT(\"Sheet3!AC\"&( 10*Sheet3!$C$4+ROW(C13)-5)),0)","v":16},null,null,null,{"$f":"INDIRECT(\"ac\"&(19+selrowFD))","v":2}]
[null,"RJW",{"$f":"INDIRECT(\"Sheet3!AC\"&( 10*Sheet3!$C$3+ROW(C14)-5))","v":16},null,null,null,{"$f":"INDIRECT(\"I\"&(19+selrow))","v":10},null,null,null,"recommended setting",null,{"$f":"INDEX(A20:A40,MATCH(MAX(IF(M20:M40=$N$15,K20:K40)),K20:K40,0))","v":1},{"$f":"IF(ISNUMBER(M47), M47,M14)","v":1},null,null,null,null,null,null,null,null,"RJW",{"$f":"IF(Sheet3!$C$4>0,INDIRECT(\"Sheet3!AC\"&( 10*Sheet3!$C$4+ROW(C14)-5)),0)","v":16},null,null,null,{"$f":"INDIRECT(\"ad\"&(19+selrowFD))","v":2}]
[null,null,null,null,null,null,{"$f":"INDIRECT(\"D\"&(19+selrow))","v":25},null,null,null,null,null,{"$f":"INDEX(INDIRECT(\"M20:M\"&(19+COUNT(M20:M40))),MATCH(MIN(ABS(INDIRECT(\"M20:M\"&(19+COUNT(M20:M40)))-I4)),ABS(INDIRECT(\"M20:M\"&(19+COUNT(M20:M40)))-I4),0))","v":75},{"$f":"IF(COUNT(A20:A40)=1,M20,M15)","v":75},{"$f":"IF((N41:N51=$I$4),K20:K40,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDIRECT(\"af\"&(19+selrowFD))","v":1},null,{"$f":"INDIRECT(\"Y\"&(19+selrowFD))","v":25}]
[null,null,null,null,null,null,{"$f":"INDIRECT(\"E\"&(19+selrow))","v":40},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(N16),MIN(U16/20/Q16*100,MIN(S16,T16)/2/(13*Q16-T16)*100),\"\")","v":""},null,null,null,null,{"$f":"INDIRECT(\"ag\"&(19+selrowFD))","v":4},null,{"$f":"INDIRECT(\"z\"&(19+selrowFD))","v":8}]
[null,{"$f":"Calculate_Bit_Timing!$B$12&\";  // bitrate=\"&bitrate&\"kbps, CPI clk=\"&cpiclock&\" MHz; Prescaler= \"&presc&\", PROPSEG=\"&prop&\", PSEG1=\"&pseg1&\", PSEG2=\"&pseg2&\", RJW=\"&rjw&\", smp=\"&100-pseg2/(1+prop+pseg1+pseg2)*100&\"%\"","v":"CANx_BTP = 0x00001C99;  // bitrate=1000kbps, CPI clk=40 MHz; Prescaler= 1, PROPSEG=21, PSEG1=8, PSEG2=10, RJW=10, smp=75%"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Calculate_Bit_Timing!$S$12&\";  // bitrateFD=\"&bitrate_fd&\"kbps, CPI clk=\"&cpiclock&\" MHz; fPrescaler= \"&prescFD&\", fPROPSEG=\"&propFD&\", fPSEG1=\"&pseg1FD&\", fPSEG2=\"&pseg2FD&\", fRJW=\"&rjwFD&\", smp=\"&100-pseg2FD/(1+propFD+pseg1FD+pseg2FD)*100&\"%\"","v":"CANx_FBTP = 0x04800411;  // bitrateFD=5000kbps, CPI clk=40 MHz; fPrescaler= 1, fPROPSEG=2, fPSEG1=3, fPSEG2=2, fRJW=2, smp=75%"}]
[null,"Prescaler","Sclock","Tq","NBT","PROPSEG","PSEG1","PSEG2","RJW",null,"Df",null,"sample point",null,null,{"$f":"LEFT(Calculate_Bit_Timing!$B$12,LEN(Calculate_Bit_Timing!$B$12)-13)","v":"CANx_BTP"},null,"CANx_CTRL1","CANx_BTP","CANx_CBT","CANx_NBTP",null,"fPrescaler","fSclock","fTq","fNBT","fPROPSEG","fPSEG1","fPSEG2","fRJW",null,"TDCEN","TDCOFF","sample point",null,null,{"$f":"LEFT(Calculate_Bit_Timing!$S$12,LEN(Calculate_Bit_Timing!$S$12)-13)","v":"CANx_FBTP"},null,"CANx_FBTP","CANx_FDCBT","CANx_FDCBT","CANx_DBTP"]
[null,"[-]","[MHz]","[ns]","[#Tq]","[#Tq]","[#Tq]","[#Tq]","[#Tq]",null,"[%]",null,"[%]",null,null,"[hex]",null,null,{"$f":"IF(ISNUMBER(H19),100-N19/K19*100,\"\")","v":""},null,null,null,"[-]","[MHz]","[ns]","[#Tq]","[#Tq]","[#Tq]","[#Tq]","[#Tq]",null,"[-]","[-]","[%]",null,null,"[hex]"]
[1,1,{"$f":"IF(ISNUMBER(B20),cpiclock/B20,\"\")","v":40},{"$f":"IF(ISNUMBER(B20),1000/C20,\"\")","v":25},40,21,8,10,10,null,{"$f":"IF(ISNUMBER(B20),MIN(I20/20/E20*100,MIN(G20,H20)/2/(13*E20-H20)*100),\"\")","v":0.78431372549019607},null,{"$f":"IF(ISNUMBER(B20),100-H20/E20*100,\"\")","v":75},null,null,{"$f":"INDEX(Sheet2!$R$20:$U$20,1,selected_reg)","v":"0x00001B99"},null,{"$f":"IF(ISNUMBER(B20),\"0x\"&DEC2HEX((POWER(2,24)*(B20-1))+((I20-1)*POWER(2,22))+((G20-1)*POWER(2,19))+((H20-1)*POWER(2,16))+(F20-1)+0,8),\"\")","v":"0x02810014"},{"$f":"IF(ISNUMBER(B20),\"0x\"&DEC2HEX((POWER(2,16)*(B20-1))+((F20+G20-2)*POWER(2,8))+((H20-1)*POWER(2,4))+(I20-1)+0,8),\"\")","v":"0x00001B99"},{"$f":"IF(ISNUMBER(B20),\"0x\"&DEC2HEX(POWER(2,31)+(POWER(2,21)*(B20-1))+((I20-1)*POWER(2,16))+((G20-1)*POWER(2,5))+((H20-1))+(F20-1)*POWER(2,10)+0,8),\"\")","v":"0x800950E9"},{"$f":"IF(ISNUMBER(B20),\"0x\"&DEC2HEX(((I20-1)*POWER(2,25))+(POWER(2,16)*(B20-1))+((F20+G20-1)*POWER(2,8))+((H20-1))+0,8),\"\")","v":"0x12001C09"},1,1,{"$f":"IF(ISNUMBER(V20),cpiclock/W20,\"\")","v":40},{"$f":"IF(ISNUMBER(V20),1000/X20,\"\")","v":25},8,2,3,2,2,null,1,{"$f":"IF(ISNUMBER(V20),IF(AF20=0,0,cpiclock/(2*bitrate_fd/1000)),\"\")","v":4},null,{"$f":"IF(ISNUMBER(W20),100-AC20/Z20*100,\"\")","v":75},null,{"$f":"INDEX(Sheet2!$AM$20:$AP$20,1,selected_regFD-4)","v":"0x04800411"},null,{"$f":"IF(ISNUMBER(V20),\"0x\"&DEC2HEX(2^24*AG20+2^23*AF20+2^16*(W20-1)+2^8*(AA20+AB20-1)+2^4*(AC20-1)+(AD20-1),8),\"\")","v":"0x04800411"},{"$f":"IF(ISNUMBER(V20),\"0x\"&DEC2HEX(2^20*(W20-1)+2^10*(AA20)+2^5*(AB20-1)+(AC20-1)+2^16*(AD20-1),8),\"\")","v":"0x00010841"},{"$f":"IF(ISNUMBER(V20),\"0x\"&DEC2HEX(2^20*(W20-1)+2^10*(AA20)+2^5*(AB20-1)+(AC20-1)+2^16*(AD20-1),8),\"\")","v":"0x00010841"},{"$f":"IF(ISNUMBER(V20),\"0x\"&DEC2HEX(2^23*AF20+2^16*(W20-1)+2^8*(AA20+AB20-1)+2^4*(AC20-1)+(AD20-1),8),\"\")","v":"0x00800411"}]
[2,2,20,{"$f":"IF(ISNUMBER(B21),1000/C21,\"\")","v":50},20,11,3,5,5,null,{"$f":"IF(ISNUMBER(B21),MIN(I21/20/E21*100,MIN(G21,H21)/2/(13*E21-H21)*100),\"\")","v":0.58823529411764708},null,{"$f":"IF(ISNUMBER(B21),100-H21/E21*100,\"\")","v":75},null,null,{"$f":"INDEX(Sheet2!$R$21:$U$21,1,selected_reg)","v":"0x00010C44"},null,{"$f":"IF(ISNUMBER(B21),\"0x\"&DEC2HEX((POWER(2,24)*(B21-1))+((I21-1)*POWER(2,22))+((G21-1)*POWER(2,19))+((H21-1)*POWER(2,16))+(F21-1)+0,8),\"\")","v":"0x0214000A"},{"$f":"IF(ISNUMBER(B21),\"0x\"&DEC2HEX((POWER(2,16)*(B21-1))+((F21+G21-2)*POWER(2,8))+((H21-1)*POWER(2,4))+(I21-1)+0,8),\"\")","v":"0x00010C44"},{"$f":"IF(ISNUMBER(B21),\"0x\"&DEC2HEX(POWER(2,31)+(POWER(2,21)*(B21-1))+((I21-1)*POWER(2,16))+((G21-1)*POWER(2,5))+((H21-1))+(F21-1)*POWER(2,10)+0,8),\"\")","v":"0x80242844"},{"$f":"IF(ISNUMBER(B21),\"0x\"&DEC2HEX(((I21-1)*POWER(2,25))+(POWER(2,16)*(B21-1))+((F21+G21-1)*POWER(2,8))+((H21-1))+0,8),\"\")","v":"0x08010D04"},2,2,20,{"$f":"IF(ISNUMBER(V21),1000/X21,\"\")","v":50},4,0,2,1,1,null,1,4,null,75,null,{"$f":"INDEX(Sheet2!$AM$21:$AP$21,1,selected_regFD-4)","v":"0x04810100"},null,{"$f":"IF(ISNUMBER(V21),\"0x\"&DEC2HEX(2^24*AG21+2^23*AF21+2^16*(W21-1)+2^8*(AA21+AB21-1)+2^4*(AC21-1)+(AD21-1),8),\"\")","v":"0x04810100"},{"$f":"IF(ISNUMBER(V21),\"0x\"&DEC2HEX(2^20*(W21-1)+2^10*(AA21)+2^5*(AB21-1)+(AC21-1)+2^16*(AD21-1),8),\"\")","v":"0x00100020"},{"$f":"IF(ISNUMBER(V21),\"0x\"&DEC2HEX(2^20*(W21-1)+2^10*(AA21)+2^5*(AB21-1)+(AC21-1)+2^16*(AD21-1),8),\"\")","v":"0x00100020"},{"$f":"IF(ISNUMBER(V21),\"0x\"&DEC2HEX(2^23*AF21+2^16*(W21-1)+2^8*(AA21+AB21-1)+2^4*(AC21-1)+(AD21-1),8),\"\")","v":"0x00810100"}]
[3,4,10,100,10,6,1,2,2,null,0.390625,null,80,null,null,{"$f":"INDEX(Sheet2!$R$22:$U$22,1,selected_reg)","v":"0x00030511"},null,"0x03410005","0x00030511","0x80611401","0x02030601",null,null,{"$f":"IF(ISNUMBER(V22),cpiclock/W22,\"\")","v":""},{"$f":"IF(ISNUMBER(V22),1000/X22,\"\")","v":""},null,null,null,null,null,null,null,"",null,"",null,{"$f":"INDEX(Sheet2!$AM$22:$AP$22,1,selected_regFD-4)","v":""},null,"",{"$f":"IF(ISNUMBER(V22),\"0x\"&DEC2HEX(2^20*(W22-1)+2^10*(AA22)+2^5*(AB22-1)+(AC22-1)+2^16*(AD22-1),8),\"\")","v":""},{"$f":"IF(ISNUMBER(V22),\"0x\"&DEC2HEX(2^20*(W22-1)+2^10*(AA22)+2^5*(AB22-1)+(AC22-1)+2^16*(AD22-1),8),\"\")","v":""},""]
[4,5,8,125,8,5,1,1,1,null,0.48543689320388345,null,87.5,null,null,{"$f":"INDEX(Sheet2!$R$23:$U$23,1,selected_reg)","v":"0x00040400"},null,"0x04000004","0x00040400","0x80801000","0x00040500",null,null,"","",null,null,null,null,null,null,null,"",null,"",null,{"$f":"INDEX(Sheet2!$AM$23:$AP$23,1,selected_regFD-4)","v":""},null,"","","",""]
[null,null,"","",null,null,null,null,null,null,"",null,"",null,null,{"$f":"INDEX(Sheet2!$R$24:$U$24,1,selected_reg)","v":""},null,"","","","",null,null,"","",null,null,null,null,null,null,null,"",null,"",null,{"$f":"INDEX(Sheet2!$AM$24:$AP$24,1,selected_regFD-4)","v":""},null,"","","",""]
[null,null,"","",null,null,null,null,null,null,"",null,"",null,null,{"$f":"INDEX(Sheet2!$R$25:$U$25,1,selected_reg)","v":""},null,"","","","",null,null,"","",null,null,null,null,null,null,null,"",null,"",null,{"$f":"INDEX(Sheet2!$AM$25:$AP$25,1,selected_regFD-4)","v":""},null,"","","",""]
[null,null,"","",null,null,null,null,null,null,"",null,"",null,null,{"$f":"INDEX(Sheet2!$R$26:$U$26,1,selected_reg)","v":""},null,"","","","",null,null,"","",null,null,null,null,null,null,null,"",null,"",null,{"$f":"INDEX(Sheet2!$AM$26:$AP$26,1,selected_regFD-4)","v":""},null,"","","",""]
[null,null,"","",null,null,null,null,null,null,"",null,"",null,null,{"$f":"INDEX(Sheet2!$R$27:$U$27,1,selected_reg)","v":""},null,"","","","",null,null,"","",null,null,null,null,null,null,null,"",null,"",null,{"$f":"INDEX(Sheet2!$AM$27:$AP$27,1,selected_regFD-4)","v":""},null,"","","",""]
[null,null,"","",null,null,null,null,null,null,"",null,"",null,null,{"$f":"INDEX(Sheet2!$R$28:$U$28,1,selected_reg)","v":""},null,"","","","",null,null,"","",null,null,null,null,null,null,null,"",null,"",null,{"$f":"INDEX(Sheet2!$AM$28:$AP$28,1,selected_regFD-4)","v":""},null,"","","",""]
[null,null,"","",null,null,null,null,null,null,"",null,"",null,null,{"$f":"INDEX(Sheet2!$R$29:$U$29,1,selected_reg)","v":""},null,"","","","",null,null,"","",null,null,null,null,null,null,null,"",null,"",null,{"$f":"INDEX(Sheet2!$AM$29:$AP$29,1,selected_regFD-4)","v":""},null,"","","",""]
[null,null,"","",null,null,null,null,null,null,"",null,"",null,null,{"$f":"INDEX(Sheet2!$R$30:$U$30,1,selected_reg)","v":""},null,"","","","",null,null,"","",null,null,null,null,null,null,null,"",null,"",null,{"$f":"INDEX(Sheet2!$AM$30:$AP$30,1,selected_regFD-4)","v":""},null,"","","",""]
[null,null,"","",null,null,null,null,null,null,"",null,"",null,null,{"$f":"INDEX(Sheet2!$R$31:$U$31,1,selected_reg)","v":""},null,"","","","",null,null,"","",null,null,null,null,null,null,null,"",null,"",null,{"$f":"INDEX(Sheet2!$AM$31:$AP$31,1,selected_regFD-4)","v":""},null,"","","",""]
[null,null,"","",null,null,null,null,null,null,"",null,"",null,null,{"$f":"INDEX(Sheet2!$R$32:$U$32,1,selected_reg)","v":""},null,"","","","",null,null,"","",null,null,null,null,null,null,null,"",null,"",null,{"$f":"INDEX(Sheet2!$AM$32:$AP$32,1,selected_regFD-4)","v":""},null,"","","",""]
[null,null,"","",null,null,null,null,null,null,"",null,"",null,null,{"$f":"INDEX(Sheet2!$R$33:$U$33,1,selected_reg)","v":""},null,"","","","",null,null,"","",null,null,null,null,null,null,null,"",null,"",null,{"$f":"INDEX(Sheet2!$AM$33:$AP$33,1,selected_regFD-4)","v":""},null,"","","",""]
[null,null,"","",null,null,null,null,null,null,"",null,"",null,null,{"$f":"INDEX(Sheet2!$R$34:$U$34,1,selected_reg)","v":""},null,"","","","",null,null,"","",null,null,null,null,null,null,null,"",null,"",null,{"$f":"INDEX(Sheet2!$AM$34:$AP$34,1,selected_regFD-4)","v":""},null,"","","",""]
[null,null,"","",null,null,null,null,null,null,"",null,"",null,null,{"$f":"INDEX(Sheet2!$R$35:$U$35,1,selected_reg)","v":""},null,"","","","",null,null,"","",null,null,null,null,null,null,null,"",null,"",null,{"$f":"INDEX(Sheet2!$AM$35:$AP$35,1,selected_regFD-4)","v":""},null,"","","",""]
[null,null,"","",null,null,null,null,null,null,"",null,"",null,null,{"$f":"INDEX(Sheet2!$R$36:$U$36,1,selected_reg)","v":""},null,"","","","",null,null,"","",null,null,null,null,null,null,null,"",null,"",null,{"$f":"INDEX(Sheet2!$AM$36:$AP$36,1,selected_regFD-4)","v":""},null,"","","",""]
[null,null,"","",null,null,null,null,null,null,"",null,"",null,null,{"$f":"INDEX(Sheet2!$R$37:$U$37,1,selected_reg)","v":""},null,"","","","",null,null,"","",null,null,null,null,null,null,null,"",null,"",null,{"$f":"INDEX(Sheet2!$AM$37:$AP$37,1,selected_regFD-4)","v":""},null,"","","",""]
[null,null,"","",null,null,null,null,null,null,"",null,"",null,null,{"$f":"INDEX(Sheet2!$R$38:$U$38,1,selected_reg)","v":""},null,"","","","",null,null,"","",null,null,null,null,null,null,null,"",null,"",null,{"$f":"INDEX(Sheet2!$AM$38:$AP$38,1,selected_regFD-4)","v":""},null,"","","",""]
[null,null,"","",null,null,null,null,null,null,"",null,"",null,null,{"$f":"INDEX(Sheet2!$R$39:$U$39,1,selected_reg)","v":""},null,"","","","",null,null,"","",null,null,null,null,null,null,null,"",null,"",null,{"$f":"INDEX(Sheet2!$AM$39:$AP$39,1,selected_regFD-4)","v":""},null,"","","",""]
[null,null,"","",null,null,null,null,null,null,"",null,"",null,null,{"$f":"INDEX(Sheet2!$R$40:$U$40,1,selected_reg)","v":""},null,"","","","",null,null,"","",null,null,null,null,null,null,null,"",null,"",null,{"$f":"INDEX(Sheet2!$AM$40:$AP$40,1,selected_regFD-4)","v":""},null,"","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(B41),\"0x\"&DEC2HEX(POWER(2,31)+(POWER(2,21)*(B41-1))+((I41-1)*POWER(2,16))+((G41-1)*POWER(2,5))+((H41-1))+(F41-1)*POWER(2,10)+0,8),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(B41),$C$2*1000/$F$3/W41,\"\")","v":""},null,null,null,null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(B42),\"0x\"&DEC2HEX((POWER(2,16)*(B42-1))+((F42+G42-2)*POWER(2,8))+((H42-1)*POWER(2,4))+(I42-1)+0,8),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(B45),\"0x\"&DEC2HEX((POWER(2,16)*(B45-1))+((F45+G45-2)*POWER(2,8))+((H45-1)*POWER(2,4))+(I45-1)+0,8),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,"",""]
[{"$f":"MATCH(B47,transceiver_list,0)","v":12},{"$f":"Calculate_Bit_Timing!D4","v":"TJA1051"},{"$f":"INDEX(C50:C74,A47,1)","v":5000},{"$f":"INDEX(D50:D74,A47,1)","v":250},null,null,null,null,null,null,null,"",{"$f":"MATCH(MAX(M49:M69),M49:M69,0)","v":1},null,{"$f":"MIN(IF(M49:M69=TRUE,IF(N49:N69=TRUE,IF(ISNUMBER(O49:O69),O49:O69))))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(I48),\"0x\"&DEC2HEX((POWER(2,16)*(I48-1))+((M48+N48-2)*POWER(2,8))+((O48-1)*POWER(2,4))+(P48-1)+0,8),\"\")","v":""},"SYNC","PROPSEG","PSEG1","PSEG2"]
[null,"transceiver","max bitrate","max prop delay",null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(O49:O69),IF(M20:M40=$N$15,K20:K40,FALSE),FALSE)","v":0.78431372549019607},{"$f":"M20:M40=$N$15","v":true},{"$f":"IF(MATCH(B20,$W$20:$W$40,0),ROW(B20)-19)","v":1},{"$f":"MATCH(B20,$W$20:$W$40,0)","v":1},null,null,{"$f":"IF(Sheet3!C4=0,\"\",\"data phase bit time = \"&AD15*AD16/1000&\"us (\"&AD16&\"Tq, Tq=\"&AD15&\"ns)\")","v":"data phase bit time = 0.2us (8Tq, Tq=25ns)"},{"$f":"AD15","v":25},{"$f":"propFD*AD15","v":50},{"$f":"pseg1FD*AD15","v":75},{"$f":"pseg2FD*AD15","v":50}]
[null,"PCA82C250/251","1000",150,null,null,null,null,null,null,null,null,0.58823529411764708,true,{"$f":"IF(MATCH(B21,$W$20:$W$40,0),ROW(B21)-19)","v":2},2,null,null,{"$f":"IF(Sheet3!C4=0,\"nominal bit time = \"&G15*G16/1000&\"us (\"&G16&\"Tq, Tq=\"&G15&\"ns)\",\"arbitration phase bit time = \"&G15*G16/1000&\"us (\"&G16&\"Tq, Tq=\"&G15&\"ns)\")","v":"arbitration phase bit time = 1us (40Tq, Tq=25ns)"},{"$f":"G15","v":25},{"$f":"prop*G15","v":525},{"$f":"pseg1*G15","v":200},{"$f":"pseg2*G15","v":250}]
[null,"TJA1040T","1000",255,null,null,null,null,null,null,null,"",false,false,{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,{"$f":"IF(Sheet3!C4=0,\"\",1)","v":1},{"$f":"IF(Sheet3!C4=0,\"\",propFD)","v":2},{"$f":"IF(Sheet3!C4=0,\"\",pseg1FD)","v":3},{"$f":"IF(Sheet3!C4=0,\"\",pseg2FD)","v":2}]
[null,"TJA1041","1000",255,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(B52),\"0x\"&DEC2HEX((POWER(2,24)*(B52-1))+((I52-1)*POWER(2,22))+((G52-1)*POWER(2,19))+((H52-1)*POWER(2,16))+(F52-1)+0,8),\"\")","v":""},"",false,false,{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,1,{"$f":"prop","v":21},{"$f":"pseg1","v":8},{"$f":"pseg2","v":10}]
[null,"TJA1042",5000,250,null,null,null,null,null,null,"","",false,false,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"TJA1043",5000,240,null,null,null,null,null,null,"","",false,false,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"TJA1044GT","5000",210,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(B55),\"0x\"&DEC2HEX((POWER(2,24)*(B55-1))+((I55-1)*POWER(2,22))+((G55-1)*POWER(2,19))+((H55-1)*POWER(2,16))+(F55-1)+0,8),\"\")","v":""},{"$f":"IF(ISNUMBER(B55),\"0x\"&DEC2HEX((POWER(2,16)*(B55-1))+((F55+G55-2)*POWER(2,8))+((H55-1)*POWER(2,4))+(I55-1)+0,8),\"\")","v":""},false,false,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"TJA1044","1000",230,null,null,null,null,null,null,"","",false,false,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"TJA1046","5000",210,null,null,null,null,null,null,"","",false,false,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"TJA1048","2000",250,null,null,null,null,null,null,"","",false,false,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"TJA1049","2000",250,null,null,null,null,null,null,"","",false,false,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"TJA1050","1000",250,null,null,null,null,null,null,"","",false,false,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"TJA1051",5000,250,null,null,null,null,null,null,"","",false,false,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"TJA1052",5000,220,null,null,null,null,null,null,"","",false,false,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"TJA1055","125",1900,null,null,null,null,null,null,null,null,false,false,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"TJA1057G","5000",210,null,null,null,null,null,null,null,null,false,false,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"TJA1057","1000",230,null,null,null,null,null,null,null,null,false,false,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"TJA1059","2000",250,null,null,null,null,null,null,null,null,false,false,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"TJA1145","2000",255,null,null,null,null,null,null,null,null,false,false,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"TJF1051","2000",250,null,null,null,null,null,null,null,null,false,false,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"TJF1052","2000",220,null,null,null,null,null,null,null,null,false,false,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"UJA1131","2000",255]
[null,"UJA1136","2000",255]
[null,"UJA1161","2000",255]
[null,"UJA1162","2000",255]

{"sheet":"Sheet3","index":3,"n_rows":89,"n_cols":29,"rows_kept":89,"cut":false,"hidden":true,"merged":[[78,11,78,15],[78,16,78,17],[78,18,78,20],[78,21,78,22],[78,23,78,25],[47,10,47,17],[48,10,48,17],[47,19,47,25],[48,19,48,25],[77,23,77,25],[74,23,74,25],[71,10,71,25],[73,10,73,11],[73,12,73,21],[73,23,73,25],[74,10,74,11],[74,12,74,21],[77,11,77,15],[77,16,77,17],[77,18,77,20],[77,21,77,22],[61,10,61,25],[58,22,58,23],[67,11,67,15],[68,11,68,15],[67,16,67,17],[68,16,68,17],[67,18,67,20],[68,18,68,20],[67,21,67,22],[68,21,68,22],[67,23,67,25],[68,23,68,25],[53,19,53,20],[33,21,33,25],[34,21,34,25],[53,21,53,25],[64,12,64,21],[63,24,63,25],[64,24,64,25],[63,22,63,23],[54,10,54,12],[54,13,54,17],[58,10,58,13],[58,14,58,17],[58,19,58,21],[54,19,54,20],[54,21,54,25],[57,19,57,21],[57,22,57,23],[57,24,57,25],[57,10,57,13],[57,14,57,17],[41,10,41,25],[64,22,64,23],[44,10,44,16],[8,1,9,1],[11,10,11,25],[13,10,13,17],[13,18,13,19],[13,20,13,22],[13,23,13,25],[21,10,21,25],[14,10,14,17],[14,18,14,19],[14,20,14,22],[14,23,14,25],[17,23,17,25],[18,23,18,25],[17,16,17,17],[18,16,18,17],[23,10,23,15],[24,10,24,15],[23,16,23,25],[24,16,24,25],[27,10,27,11],[27,12,27,17],[27,18,27,21],[31,10,31,25],[27,22,27,25],[28,12,28,17],[28,10,28,11],[88,10,88,12],[88,13,88,17],[88,18,88,21],[88,22,88,25],[84,19,84,20],[84,21,84,25],[84,10,84,17],[87,10,87,12],[87,13,87,17],[87,18,87,21],[87,22,87,25],[81,10,81,25],[83,19,83,20],[83,21,83,25],[83,10,83,17],[28,18,28,21],[28,22,28,25],[58,24,58,25],[51,10,51,25],[53,10,53,12],[53,13,53,17],[33,11,33,20],[34,11,34,20],[43,17,43,25],[44,17,44,25],[43,10,43,16],[37,10,37,15],[38,10,38,15],[37,16,37,20],[38,16,38,20],[37,21,37,25],[38,21,38,25],[63,10,63,11],[64,10,64,11],[63,12,63,21]]}
[null,"Device index",{"$f":"MATCH(C2,Device_list,0)","v":30}]
[null,"selected MCU",{"$f":"Calculate_Bit_Timing!D2","v":"MPC5777M"}]
[null,"can_reg",{"$f":"INDEX($E$14:$E$63,$C$1,1)","v":2}]
[null,"can FD",{"$f":"INDEX($F$14:$F$63,$C$1,1)","v":5}]
[null,"Legacy/enhance PLL",{"$f":"INDEX(D14:D63,C1,1)","v":0}]
[]
[null,"fsyst_max",{"$f":"INDEX($J$14:$J$73,$C$1,1)","v":0}]
[]
[null,"code variant","col"]
[null,null,{"$f":"INDIRECT(\"PLL_\"&C4&\"!L4\")","v":{"$error":"#REF!"}},null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IPT",2]
[null,null,null,null,null,null,null,null,null,null,{"$f":"\"CANx_CTRL1 = 0x\"&DEC2HEX((POWER(2,24)*(K15))+((S15)*POWER(2,22))+((U15)*POWER(2,19))+((X15)*POWER(2,16))+(X19),8)","v":"CANx_CTRL1 = 0x02810014"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NBT min",8]
[null,"index","Device list:",null,"can reg","can FD",null,null,null,null,0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,null,"NBT max",25]
[null,1,"MPC551x",null,1,0,null,null,null,null,"PRESDIV",null,null,null,null,null,null,null,"RJW",null,"PSEG1",null,null,"PSEG2",null,null,null,"Prescaler min",1]
[null,2,"MPC553x",null,1,0,null,null,null,null,{"$f":"presc-1","v":0},null,null,null,null,null,null,null,{"$f":"rjw-1","v":9},null,{"$f":"pseg1-1","v":7},null,null,{"$f":"pseg2-1","v":9},null,null,null,"Prescaler max",256]
[null,3,"MPC5553",null,1,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"1+U15","v":8},null,null,{"$f":"1+X15","v":10},null,null,"PropSeg",8]
[null,4,"MPC5554",null,1,0,null,null,null,null,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,null,"Pseg1",8]
[null,5,"MPC5561",null,1,0,null,null,null,null,"BOFF_MSK","ERR_MSK","CLK_SRC","LPB","TWRN_MSK","RWRN_MSK",null,null,"SMP","BOFF_REC","TSYN","LBUF","LOM","PROPSEG",null,null,null,"Pseg2",8]
[null,6,"MPC5565",null,1,0,null,null,null,null,0,0,0,0,0,0,0,null,0,0,0,0,0,{"$f":"prop-1","v":20},null,null,null,"RJW",4]
[null,7,"MPC5566",null,1,0,null,null,null,2]
[null,8,"MPC5567",null,1,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IPT",0]
[null,9,"MPC5634M",null,1,0,null,null,null,null,{"$f":"\"CANx_BTP = 0x\"&DEC2HEX(2^16*Q25+2^8*M29+2^4*S29+W29,8)","v":"CANx_BTP = 0x00001C99"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NBT min",4]
[null,10,"MPC5644A",null,1,0,null,null,null,null,0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,null,"NBT max",81]
[null,11,"MPC5674F",null,1,0,null,null,null,null,null,null,null,null,null,null,"BPR",null,null,null,null,null,null,null,null,null,null,"Prescaler min",1]
[null,12,"MPC5676R",null,1,0,null,null,null,null,0,null,null,null,null,null,{"$f":"presc-1","v":0},null,null,null,null,null,null,null,null,null,null,"Prescaler max",1024]
[null,13,"MPC5604B/C",null,1,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"1+U25","v":1},null,null,{"$f":"1+X25","v":1},null,null,"PropSeg",48]
[null,14,"MPC5607B",null,1,0,null,null,null,null,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,null,"Pseg1",16]
[null,15,"MPC5602D",null,1,0,null,null,null,null,null,null,"TSEG1",null,null,null,null,null,"TSEG2",null,null,null,"SJW",null,null,null,null,"Pseg2",16]
[null,16,"MPC5646BC",null,1,0,null,null,null,null,0,null,{"$f":"prop+pseg1-1","v":28},null,null,null,null,null,{"$f":"pseg2-1","v":9},null,null,null,{"$f":"rjw-1","v":9},null,null,null,null,"RJW",16]
[null,17,"MPC5604P",null,1,0,null,null,null,3]
[null,18,"MPC5606P/T",null,1,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IPT",2]
[null,19,"MPC5602P",null,1,0,null,null,null,null,{"$f":"\"CANx_CBT = 0x\"&DEC2HEX(2^31+2^21*L35+2^16*V35+2^10*K39+2^5*Q39+V39,8)","v":"CANx_CBT = 0x800950E9"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NBT min",8]
[null,20,"MPC5604E",null,1,0,null,null,null,null,0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,null,"NBT max",129]
[null,21,"MPC5643L",null,1,0,null,null,null,null,"BTF","EPRESDIV",null,null,null,null,null,null,null,null,null,"ERJW",null,null,null,null,null,"Prescaler min",1]
[null,22,"MPC5675K",null,1,0,null,null,null,null,1,{"$f":"presc-1","v":0},null,null,null,null,null,null,null,null,null,{"$f":"rjw-1","v":9},null,null,null,null,null,"Prescaler max",1024]
[null,23,"MPC5606S",null,1,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"1+U35","v":1},null,null,{"$f":"1+X35","v":1},null,null,"PropSeg",64]
[null,24,"MPC5645S",null,1,0,null,null,null,null,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,null,"Pseg1",32]
[null,25,"MPC5668G/E",null,1,0,null,null,null,null,"EPROPSEG",null,null,null,null,null,"EPSEG1",null,null,null,null,"EPSEG2",null,null,null,null,null,"Pseg2",32]
[null,26,"MPC5744P",null,1,0,null,null,null,null,{"$f":"prop-1","v":20},null,null,null,null,null,{"$f":"pseg1-1","v":7},null,null,null,null,{"$f":"pseg2-1","v":9},null,null,null,null,null,"RJW",16]
[null,27,"MPC5746R",null,1,0,null,null,null,4]
[null,28,"MPC5775K - FlexCAN",null,1,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IPT",0]
[null,29,"MPC5775K - MCAN",null,2,5,null,null,null,null,{"$f":"\"CANx_NBTP = 0x\"&DEC2HEX(2^25*K45+2^8*K49+2^16*R45+T49,8)","v":"CANx_NBTP = 0x12001C09"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NBT min",4]
[null,30,"MPC5777M",null,2,5,null,null,null,null,0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,null,"NBT max",385]
[null,31,"MPC5777C - FlexCAN",null,1,0,null,null,null,null,"NSJW",null,null,null,null,null,null,"NBRP",null,null,null,null,null,null,null,null,null,"Prescaler min",1]
[null,32,"MPC5777C 2N45H MCAN",null,2,5,null,null,null,null,{"$f":"rjw-1","v":9},null,null,null,null,null,null,{"$f":"presc-1","v":0},null,null,null,null,null,null,null,null,null,"Prescaler max",512]
[null,33,"MPC5777C 3N45H MCAN",null,4,8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"1+U45","v":1},null,null,{"$f":"1+X45","v":1},null,null,"PropSeg",128]
[null,34,"MPC5748G",null,1,0,null,null,null,null,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,null,"Pseg1",128]
[null,35,"MPC5748G - CAN FD",null,3,7,null,null,null,null,"NTSEG1",null,null,null,null,null,null,null,null,"NTSEG2",null,null,null,null,null,null,null,"Pseg2",128]
[null,36,"S32K1xx",null,1,0,null,null,null,null,{"$f":"prop+pseg1-1","v":28},null,null,null,null,null,null,null,0,{"$f":"pseg2-1","v":9},null,null,null,null,null,null,null,"RJW",128]
[null,37,"S32K1xx - CAN FD",null,3,7,null,null,null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IPT",0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"\"CANx_FBTP = 0x\"&DEC2HEX(2^24*N55+2^23*S55+2^16*V55+2^8*O59+2^4*T59+Y59,8)","v":"CANx_FBTP = 0x04800411"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NBT min",4]
[null,null,null,null,null,null,null,null,null,null,0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,null,"NBT max",81]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"TDCO",null,null,null,null,"TDC",null,null,"FBRP",null,null,null,null,null,"Prescaler min",1]
[null,null,null,null,null,null,null,null,null,null,0,null,null,{"$f":"tdc_off","v":4},null,null,null,null,{"$f":"tdc_en","v":1},0,null,{"$f":"prescFD-1","v":0},null,null,null,null,null,"Prescaler max",1024]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"1+U55","v":1},null,null,{"$f":"1+X55","v":1},null,null,"PropSeg",48]
[null,null,null,null,null,null,null,null,null,null,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,null,"Pseg1",16]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FTSEG1",null,null,null,null,"FTSEG2",null,null,null,null,"FSJW",null,null,"Pseg2",16]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,{"$f":"pseg1FD+propFD-1","v":4},null,null,null,0,{"$f":"pseg2FD-1","v":1},null,null,0,null,{"$f":"rjwFD-1","v":1},null,null,"RJW",16]
[null,null,null,null,null,null,null,null,null,6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IPT",2]
[null,null,null,null,null,null,null,null,null,null,{"$f":"\"CANx_FDCBT = 0x\"&DEC2HEX(2^20*M65+2^16*Y65+2^10*L69+2^5*S69+X69,8)","v":"CANx_FDCBT = 0x00010841"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NBT min",8]
[null,null,null,null,null,null,null,null,null,null,0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,null,"NBT max",129]
[null,null,null,null,null,null,null,null,null,null,null,null,"FPRESDIV",null,null,null,null,null,null,null,null,null,null,null,"FRJW",null,null,"Prescaler min",1]
[null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"prescFD-1","v":0},null,null,null,null,null,null,null,null,null,0,null,{"$f":"rjwFD-1","v":1},null,null,"Prescaler max",1024]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"1+U65","v":1},null,null,{"$f":"1+X65","v":1},null,null,"PropSeg",64]
[null,null,null,null,null,null,null,null,null,null,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,null,"Pseg1",32]
[null,null,null,null,null,null,null,null,null,null,null,"FPROPSEG",null,null,null,null,null,null,"FPSEG1",null,null,null,null,"FPSEG2",null,null,null,"Pseg2",32]
[null,null,null,null,null,null,null,null,null,null,0,{"$f":"propFD","v":2},null,null,null,null,0,null,{"$f":"pseg1FD-1","v":2},null,null,0,null,{"$f":"pseg2FD-1","v":1},null,null,null,"RJW",16]
[null,null,null,null,null,null,null,null,null,7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IPT",2]
[null,null,null,null,null,null,null,null,null,null,{"$f":"\"CANx_FDCBT = 0x\"&DEC2HEX(2^20*M75+2^16*X75+2^10*L79+2^5*S79+X79,8)","v":"CANx_FDCBT = 0x00010841"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NBT min",5]
[null,null,null,null,null,null,null,null,null,null,0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,null,"NBT max",48]
[null,null,null,null,null,null,null,null,null,null,null,null,"FPRESDIV",null,null,null,null,null,null,null,null,null,null,"FRJW",null,null,null,"Prescaler min",1]
[null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"prescFD-1","v":0},null,null,null,null,null,null,null,null,null,0,{"$f":"rjwFD-1","v":1},null,null,null,"Prescaler max",1024]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"1+U75","v":1},null,null,{"$f":"1+#REF!","v":{"$error":"#REF!"}},null,null,"PropSeg",32]
[null,null,null,null,null,null,null,null,null,null,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,null,"Pseg1",8]
[null,null,null,null,null,null,null,null,null,null,null,"FPROPSEG",null,null,null,null,null,null,"FPSEG1",null,null,null,null,"FPSEG2",null,null,null,"Pseg2",8]
[null,null,null,null,null,null,null,null,null,null,0,{"$f":"propFD","v":2},null,null,null,null,0,null,{"$f":"pseg1FD-1","v":2},null,null,0,null,{"$f":"pseg2FD-1","v":1},null,null,null,"RJW",8]
[null,null,null,null,null,null,null,null,null,8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IPT",0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"\"CANx_DBTP = 0x\"&DEC2HEX(2^23*S85+2^16*V85+2^8*N89+2^4*S89+W89,8)","v":"CANx_DBTP = 0x00800411"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NBT min",4]
[null,null,null,null,null,null,null,null,null,null,0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,null,"NBT max",49]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TDC",null,null,"DBRP",null,null,null,null,null,"Prescaler min",1]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,{"$f":"tdc_en","v":1},0,null,{"$f":"prescFD-1","v":0},null,null,null,null,null,"Prescaler max",32]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"1+U85","v":1},null,null,{"$f":"1+X85","v":1},null,null,"PropSeg",16]
[null,null,null,null,null,null,null,null,null,null,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,null,"Pseg1",16]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"DTSEG1",null,null,null,null,"DTSEG2",null,null,null,"DSJW",null,null,null,null,"Pseg2",16]
[null,null,null,null,null,null,null,null,null,null,0,null,null,{"$f":"pseg1FD+propFD-1","v":4},null,null,null,null,{"$f":"pseg2FD-1","v":1},null,null,null,{"$f":"rjwFD-1","v":1},null,null,null,null,"RJW",16]

{"sheet":"Sheet4","index":4,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":true,"merged":[]}
[]
[null,"fsys",80]
[null,"fcanclk",80]
[null,"nominal bitrate",1000]
[null,"data bitrate",8000]
[null,"payload",8]
[null,"MaxNumOfMB",96]
[]
[null,"NumClkNomBit",{"$f":"C2/C4*1000","v":80}]
[null,"MinNumClkFastBit_b",{"$f":"((8.5*C7)+64-(9*C9))/(26+8*C6)","v":1.7777777777777777}]
[null,"MinNumClkFastBit_b",{"$f":"3*(1+C2/C3)","v":6}]
[null,"MinNumClkFastBit",{"$f":"MAX(C10,C11)","v":6}]
[]
[null,"DataBitRate_max",{"$f":"C3/ROUNDUP(C12*C3/C2,0)","v":13.333333333333334}]