{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Analysis","Settings"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":22,"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":"Analysis","index":0,"n_rows":7,"n_cols":54,"rows_kept":7,"cut":false,"hidden":false,"merged":[[4,3,4,16],[4,44,4,53],[4,22,4,29],[4,31,4,37],[4,39,4,42]]}
[null,"Linlog Analysis"]
[null,"TLE8880 B11"]
[null,{"$f":"CONCATENATE(\"LIN Config: \",LIN_config,\", RX: 0x\",DEC2HEX(LIN_RX_Id),\", TX1: 0x\",DEC2HEX(LIN_TX1_Id),\", TX2: 0x\",DEC2HEX(LIN_TX2_Id),\", TX3: 0x\",DEC2HEX(LIN_TX3_Id))","v":"LIN Config: B, RX: 0xE9, TX1: 0x11, TX2: 0x92, TX3: 0x55"}]
[]
[null,null,null,"Logfile data (Dec Format)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LIN RX Frame",null,null,null,null,null,null,null,null,"LIN TX1 Frame",null,null,null,null,null,null,null,"LIN TX2 Frame",null,null,null,null,"LIN TX3 Frame"]
[{"$f":"CONCATENATE(\"Absolute time (UTC+\",Timezone,\")\")","v":"Absolute time (UTC+2)"},"LIN Frame",null,"Type","Timestamp","Baudrate","Synch","ID","Data1","Data2","Data3","Data4","Data5","Data6","Data7","Data8","CS",null,"Synch","Checksum","Consistency",null,"VSET [V]","LRCRT [s]","LRCDIS [rpm]","CLIM [A]","RDI","LRCBZ [%]","HT [°C]","F-PARA",null,"F-HT","F-ROT","F-EL","DC [%]","RMC6 [A]","F-CEF","F-CTO",null,"SUPP","CLASS","MANUID","ASICID",null,"F-HT","F-ROT","F-EL","DC [%]","RMC8 [A]","RDI","F-CEF","F-CTO","RMV/RMT/RVSET","RDI unit"]
[{"$f":"((($E7/1000/60)/60)/24)+DATE(1970,1,1)+(Timezone/24)","v":"1970-01-01T02:00:00"},{"$f":"IF(AND($D7=\"RX\",$H7=LIN_RX_Id),CONCATENATE($D7,\" (ID: 0x\",DEC2HEX($H7),\")\"),IF(AND($D7=\"TX\",$H7=LIN_TX1_Id),CONCATENATE($D7,\"1 (ID: 0x\",DEC2HEX($H7),\")\"),IF(AND($D7=\"TX\",$H7=LIN_TX2_Id),CONCATENATE($D7,\"2 (ID: 0x\",DEC2HEX($H7),\")\"),IF(AND($D7=\"TX\",$H7=LIN_TX3_Id),CONCATENATE($D7,\"3 (ID: 0x\",DEC2HEX($H7),\")\"),\"Unknown\"))))","v":"Unknown"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($G7=85,\"OK\",\"NOK\")","v":"NOK"},{"$f":"IF(Checksum($I7:$P7)=$Q7,\"OK\",\"NOK\")","v":"NOK"},{"$f":"ConsistencyChk(IF(AND($D7=\"RX\",$H7=LIN_RX_Id),\"RX\",IF(AND($D7=\"TX\",$H7=LIN_TX1_Id),\"TX1\",IF(AND($D7=\"TX\",$H7=LIN_TX2_Id),\"TX2\",IF(AND($D7=\"TX\",$H7=LIN_TX3_Id),\"TX3\",\"NA\")))),$I7:$P7,$Q7)","v":"IGNORED"},null,{"$f":"IF(AND($D7=\"RX\",$H7=LIN_RX_Id),10.6+IF(LIN_config=\"A\",0.1,0.025)*$I7,NA())","v":{"$error":"#N/A"}},{"$f":"IF(AND($D7=\"RX\",$H7=LIN_RX_Id),INDEX(IF(LIN_config=\"A\",LOOKUP_LRCRT_A,LOOKUP_LRCRT_B),BITand(15,$J7)+1),NA())","v":{"$error":"#N/A"}},{"$f":"IF(AND($D7=\"RX\",$H7=LIN_RX_Id),INDEX(LOOKUP_LRCDIS,BITshr($J7,4)+1),NA())","v":{"$error":"#N/A"}},{"$f":"IF(AND($D7=\"RX\",$H7=LIN_RX_Id),IF(LIN_config=\"A\",IF($K7=0,\"Disabled\",IF($K7<8,2,$K7*0.25)),IF(OR($K7=0,$K7>110),\"Disabled\",$K7*0.1)),NA())","v":{"$error":"#N/A"}},{"$f":"IF(AND($D7=\"RX\",$H7=LIN_RX_Id),INDEX(LOOKUP_RDI,BITand(7,$L7)+1),NA())","v":{"$error":"#N/A"}},{"$f":"IF(AND($D7=\"RX\",$H7=LIN_RX_Id),IF(BITshr(BITand(8,$L7),3),12,3),NA())","v":{"$error":"#N/A"}},{"$f":"IF(AND($D7=\"RX\",$H7=LIN_RX_Id),INDEX(LOOKUP_RHT,BITshr(BITand(112,$L7),4)+1),NA())","v":{"$error":"#N/A"}},{"$f":"IF(AND($D7=\"RX\",$H7=LIN_RX_Id),BITshr(BITand(128,$L7),7),NA())","v":{"$error":"#N/A"}},null,{"$f":"IF(AND($D7=\"TX\",$H7=LIN_TX1_Id),0+BITand(1,$I7),NA())","v":{"$error":"#N/A"}},{"$f":"IF(AND($D7=\"TX\",$H7=LIN_TX1_Id),0+BITshr(BITand(2,$I7),1),NA())","v":{"$error":"#N/A"}},{"$f":"IF(AND($D7=\"TX\",$H7=LIN_TX1_Id),0+BITshr(BITand(4,$I7),2),NA())","v":{"$error":"#N/A"}},{"$f":"IF(AND($D7=\"TX\",$H7=LIN_TX1_Id),INDEX(LOOKUP_DC,BITshr(BITand(248,$I7),3)+1),NA())","v":{"$error":"#N/A"}},{"$f":"IF(AND($D7=\"TX\",$H7=LIN_TX1_Id),ROUND(BITand(63,$J7)*8/63,3),NA())","v":{"$error":"#N/A"}},{"$f":"IF(AND($D7=\"TX\",$H7=LIN_TX1_Id),0+BITshr(BITand(64,$J7),6),NA())","v":{"$error":"#N/A"}},{"$f":"IF(AND($D7=\"TX\",$H7=LIN_TX1_Id),0+BITshr(BITand(128,$J7),7),NA())","v":{"$error":"#N/A"}},null,{"$f":"IF(AND($D7=\"TX\",$H7=LIN_TX2_Id),INDEX(LOOKUP_SUPP,BITand(7,$I7)+1),NA())","v":{"$error":"#N/A"}},{"$f":"IF(AND($D7=\"TX\",$H7=LIN_TX2_Id),BITshr(BITand(248,$I7),3),NA())","v":{"$error":"#N/A"}},{"$f":"IF(AND($D7=\"TX\",$H7=LIN_TX2_Id),INDEX(LOOKUP_MANUID,BITand(7,$J7)+1),NA())","v":{"$error":"#N/A"}},{"$f":"IF(AND($D7=\"TX\",$H7=LIN_TX2_Id),INDEX(LOOKUP_ASICID,BITshr(BITand(248,$J7),3)+1),NA())","v":{"$error":"#N/A"}},null,{"$f":"IF(AND($D7=\"TX\",$H7=LIN_TX3_Id),0+BITand(1,$I7),NA())","v":{"$error":"#N/A"}},{"$f":"IF(AND($D7=\"TX\",$H7=LIN_TX3_Id),0+BITshr(BITand(2,$I7),1),NA())","v":{"$error":"#N/A"}},{"$f":"IF(AND($D7=\"TX\",$H7=LIN_TX3_Id),0+BITshr(BITand(4,$I7),2),NA())","v":{"$error":"#N/A"}},{"$f":"IF(AND($D7=\"TX\",$H7=LIN_TX3_Id),INDEX(LOOKUP_DC,BITshr(BITand(248,$I7),3)+1),NA())","v":{"$error":"#N/A"}},{"$f":"IF(AND($D7=\"TX\",$H7=LIN_TX3_Id),IF(LIN_config=\"A\",IF($J7>252,12.6,ROUND($J7*8/63,3)),IF($J7>252,12.6,ROUND($J7*12.8/256,3))),NA())","v":{"$error":"#N/A"}},{"$f":"IF(AND($D7=\"TX\",$H7=LIN_TX3_Id),INDEX(LOOKUP_RDI,BITand(7,$K7)+1),NA())","v":{"$error":"#N/A"}},{"$f":"IF(AND($D7=\"TX\",$H7=LIN_TX3_Id),0+BITshr(BITand(64,$K7),6),NA())","v":{"$error":"#N/A"}},{"$f":"IF(AND($D7=\"TX\",$H7=LIN_TX3_Id),0+BITshr(BITand(128,$K7),7),NA())","v":{"$error":"#N/A"}},{"$f":"IF(BITand(7,$K7)=1,10.6+IF(LIN_config=\"A\",0.1,0.025)*$L7,IF(BITand(7,$K7)=2,IF($L7<10,9,IF($L7>100,18,8+$L7*0.1)),IF(BITand(7,$K7)=3,INDEX(LOOKUP_MT,$L7+1),NA())))","v":{"$error":"#N/A"}},{"$f":"IF(BITand(7,$K7)=1,\"[V]\",IF(BITand(7,$K7)=2,\"[V]\",IF(BITand(7,$K7)=3,\"[°C]\",NA())))","v":{"$error":"#N/A"}}]

{"sheet":"Settings","index":1,"n_rows":72,"n_cols":16,"rows_kept":72,"cut":false,"hidden":false,"merged":[[8,2,11,2],[14,2,19,2]]}
["Linlog Analysis"]
["Info","(do not change)"]
["Version:",{"$f":"LastSaved()","v":"2013-09-12T15:44:56"}]
["Chip device:",{"$f":"Analysis!B2","v":"TLE8880 B11"}]
["Compatibility:","Interface Software for Alternator Control ICs - Version 1.4"]
[]
["Settings",null,null,null,null,null,"Mappings"]
["Time zone: UTC+",2,"Necessary for correct timestamp calculation",null,"#","# (Bin)","LRCRT_A","LRCRT_B","LRCDIS","RDI","RHT","DC","SUPP","ManuID","ASICID","MT"]
["LIN RX Id:",233,"Change these values, if Regulator #2 is set via NVM-ALT",null,0,{"$f":"DEC2BIN(E9,8)","v":"00000000"},"Disabled","Disabled",2400,"Ignore",0,0,"Bosch","Bosch","A11",-40]
["LIN TX1 Id:",17,null,null,1,{"$f":"DEC2BIN(E10,8)","v":"00000001"},1,0.25,2530,"RVSET",-16,3.125,"Valeo","Infineon","A12",-38]
["LIN TX2 Id:",146,null,null,2,"00000010",2,0.5,2670,"RMV",-12,6.25,"Denso","Freescale","A21",-34]
["LIN TX3 Id:",85,null,null,3,"00000011",3,0.75,2820,"RMT",-8,9.375,"Hitachi","ST","B11",-30]
["LIN configuration:","B","Choose between \"A\" and \"B\", depending on NVM-CFG setting in NVM",null,4,"00000100",4,1,3000,"Reserved",-4,12.5,"Denso","Elmos","B12",-26]
[null,null,null,null,5,"00000101",5,2,3200,0,4,15.625,"Melco","Sanken",null,-22]
["Logfile space - First column:","D7","Location settings for loading macro. Refer to VBA code for more details",null,6,"00000110",6,3,3430,"Reserved",8,18.75,"Visteon","Denso",null,-18]
["Logfile space - Last column:","Q7",null,null,7,"00000111",7,4,3690,"Ignore",12,21.875,"Other","Other",null,-14]
["LogAnalysis space 1 - First column:","A7",null,null,8,"00001000",8,5,4000,null,null,25,null,null,null,-10]
["LogAnalysis space 1 - Last column:","B7",null,null,9,"00001001",9,6,4360,null,null,28.125,null,null,null,-6]
["LogAnalysis space 2 - First column:","S7",null,null,10,"00001010",10,7,4800,null,null,31.25,null,null,null,-2]
["LogAnalysis space 2 - Last column:","BB7",null,null,11,"00001011",11,8,5330,null,null,34.375,null,null,null,2]
[null,null,null,null,12,"00001100",12,9,6000,null,null,37.5,null,null,null,6]
[null,null,null,null,13,"00001101",13,10,6860,null,null,40.625,null,null,null,10]
[null,null,null,null,14,"00001110",14,12,8000,null,null,43.75,null,null,null,14]
[null,null,null,null,15,"00001111",15,15,"unlimited",null,null,46.875,null,null,null,18]
[null,null,null,null,16,"00010000",null,null,null,null,null,50,null,null,null,22]
[null,null,null,null,17,"00010001",null,null,null,null,null,53.125,null,null,null,26]
[null,null,null,null,18,"00010010",null,null,null,null,null,56.25,null,null,null,30]
[null,null,null,null,19,"00010011",null,null,null,null,null,59.375,null,null,null,34]
[null,null,null,null,20,"00010100",null,null,null,null,null,62.5,null,null,null,38]
[null,null,null,null,21,"00010101",null,null,null,null,null,65.625,null,null,null,42]
[null,null,null,null,22,"00010110",null,null,null,null,null,68.75,null,null,null,46]
[null,null,null,null,23,"00010111",null,null,null,null,null,71.875,null,null,null,50]
[null,null,null,null,24,"00011000",null,null,null,null,null,75,null,null,null,54]
[null,null,null,null,25,"00011001",null,null,null,null,null,78.125,null,null,null,58]
[null,null,null,null,26,"00011010",null,null,null,null,null,81.25,null,null,null,62]
[null,null,null,null,27,"00011011",null,null,null,null,null,84.375,null,null,null,66]
[null,null,null,null,28,"00011100",null,null,null,null,null,87.5,null,null,null,70]
[null,null,null,null,29,"00011101",null,null,null,null,null,90.625,null,null,null,74]
[null,null,null,null,30,"00011110",null,null,null,null,null,93.75,null,null,null,78]
[null,null,null,null,31,"00011111",null,null,null,null,null,96.875,null,null,null,82]
[null,null,null,null,32,"00100000",null,null,null,null,null,null,null,null,null,86]
[null,null,null,null,33,"00100001",null,null,null,null,null,null,null,null,null,90]
[null,null,null,null,34,"00100010",null,null,null,null,null,null,null,null,null,94]
[null,null,null,null,35,"00100011",null,null,null,null,null,null,null,null,null,98]
[null,null,null,null,36,"00100100",null,null,null,null,null,null,null,null,null,102]
[null,null,null,null,37,"00100101",null,null,null,null,null,null,null,null,null,106]
[null,null,null,null,38,"00100110",null,null,null,null,null,null,null,null,null,110]
[null,null,null,null,39,"00100111",null,null,null,null,null,null,null,null,null,114]
[null,null,null,null,40,"00101000",null,null,null,null,null,null,null,null,null,118]
[null,null,null,null,41,"00101001",null,null,null,null,null,null,null,null,null,122]
[null,null,null,null,42,"00101010",null,null,null,null,null,null,null,null,null,126]
[null,null,null,null,43,"00101011",null,null,null,null,null,null,null,null,null,130]
[null,null,null,null,44,"00101100",null,null,null,null,null,null,null,null,null,134]
[null,null,null,null,45,"00101101",null,null,null,null,null,null,null,null,null,138]
[null,null,null,null,46,"00101110",null,null,null,null,null,null,null,null,null,142]
[null,null,null,null,47,"00101111",null,null,null,null,null,null,null,null,null,146]
[null,null,null,null,48,"00110000",null,null,null,null,null,null,null,null,null,150]
[null,null,null,null,49,"00110001",null,null,null,null,null,null,null,null,null,154]
[null,null,null,null,50,"00110010",null,null,null,null,null,null,null,null,null,158]
[null,null,null,null,51,"00110011",null,null,null,null,null,null,null,null,null,162]
[null,null,null,null,52,"00110100",null,null,null,null,null,null,null,null,null,166]
[null,null,null,null,53,"00110101",null,null,null,null,null,null,null,null,null,170]
[null,null,null,null,54,"00110110",null,null,null,null,null,null,null,null,null,174]
[null,null,null,null,55,"00110111",null,null,null,null,null,null,null,null,null,178]
[null,null,null,null,56,"00111000",null,null,null,null,null,null,null,null,null,182]
[null,null,null,null,57,"00111001",null,null,null,null,null,null,null,null,null,186]
[null,null,null,null,58,"00111010",null,null,null,null,null,null,null,null,null,190]
[null,null,null,null,59,"00111011",null,null,null,null,null,null,null,null,null,194]
[null,null,null,null,60,"00111100",null,null,null,null,null,null,null,null,null,198]
[null,null,null,null,61,"00111101",null,null,null,null,null,null,null,null,null,202]
[null,null,null,null,62,"00111110",null,null,null,null,null,null,null,null,null,206]
[null,null,null,null,63,"00111111",null,null,null,null,null,null,null,null,null,210]