{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["OTP_PRELOAD_NOM","Iterative Routine"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"OTP_PRELOAD_NOM","index":0,"n_rows":12,"n_cols":35,"rows_kept":12,"cut":false,"hidden":false,"merged":[[7,6,7,12],[9,1,9,2]]}
[]
[null,null,null,null,null,"newcrc[0",30,26,25,24,23,21,19,18,15,11,10,9,8,6,4,3,0,null,null,"c[2"]
[null,null,null,null,null,"newcrc[1",31,30,27,23,22,21,20,18,16,15,12,8,7,6,5,3,1,0,null,"c[2","c[3"]
[null,null,null,null,null,"newcrc[2",31,28,24,23,22,21,19,17,16,13,9,8,7,6,4,2,1,null,null,"c[0","c[3"]
[null,"Hex","Hex","Hex",null,"newcrc[3",29,25,24,23,22,20,18,17,14,10,9,8,7,5,3,2,null,null,null,"c[1"]
[null,"Addr","Data","Command",null,"Data Bits",32]
[null,"x40","x7d83","x1",null,"CRC INIT",1111]
[null,null,null,null,null,"Concatinated Data",{"$f":"HEX2BIN(RIGHT(B7,2),8)&HEX2BIN(MID(C7,2,2),8)&HEX2BIN(RIGHT(C7,2),8)&HEX2BIN(RIGHT(D7,1),4)&\"0000\"","v":"01000000011111011000001100010000"}]
[null,null,null,"Hex",null,"CRC0",{"$f":"IF(G2=\"\",\"\",VALUE(MID($G$8,$G$6-G2,1)))","v":1},{"$f":"IF(H2=\"\",\"\",VALUE(MID($G$8,$G$6-H2,1)))","v":0},0,0,0,1,1,1,1,0,0,1,1,0,1,0,0,"",{"$f":"SUM(G9:X9)","v":8},{"$f":"IF(Z2=\"\",\"\",VALUE(MID($G$7,(4-RIGHT(Z2,1)),1)))","v":1},{"$f":"IF(AA2=\"\",\"\",VALUE(MID($G$7,(4-RIGHT(AA2,1)),1)))","v":""},"","","","","","",{"$f":"SUM(Z9:AG9)","v":1},{"$f":"MOD((Y9+AH9),2)","v":1}]
[null,"CRC Calculated",null,{"$f":"\"x\"&BIN2HEX((AI12&AI11&AI10&AI9),1)","v":"x5"},null,"CRC1",{"$f":"IF(G3=\"\",\"\",VALUE(MID($G$8,$G$6-G3,1)))","v":0},1,0,0,1,1,1,1,1,1,0,1,0,0,0,0,0,0,{"$f":"SUM(G10:X10)","v":8},{"$f":"IF(Z3=\"\",\"\",VALUE(MID($G$7,(4-RIGHT(Z3,1)),1)))","v":1},1,"","","","","","",{"$f":"SUM(Z10:AG10)","v":2},{"$f":"MOD((Y10+AH10),2)","v":0}]
[null,null,null,null,null,"CRC2",{"$f":"IF(G4=\"\",\"\",VALUE(MID($G$8,$G$6-G4,1)))","v":0},0,0,0,1,1,1,0,1,0,1,1,0,0,1,0,0,"",7,{"$f":"IF(Z4=\"\",\"\",VALUE(MID($G$7,(4-RIGHT(Z4,1)),1)))","v":1},1,"","","","","","",2,1]
[null,null,null,null,null,"CRC3",{"$f":"IF(G5=\"\",\"\",VALUE(MID($G$8,$G$6-G5,1)))","v":0},0,0,0,1,1,1,0,0,0,1,1,0,0,0,0,"","",5,{"$f":"IF(Z5=\"\",\"\",VALUE(MID($G$7,(4-RIGHT(Z5,1)),1)))","v":1},"","","","","","","",1,0]

{"sheet":"Iterative Routine","index":1,"n_rows":34,"n_cols":6,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
["Bit","INPUT Code","CRC3","CRC2","CRC1","CRC0"]
[1,1,1,1,1,0]
[2,1,1,1,0,0]
[3,1,1,0,0,0]
[4,0,0,0,1,1]
[5,0,0,1,1,0]
[6,0,1,1,0,0]
[7,0,1,0,1,1]
[8,0,0,1,0,1]
[9,0,1,0,1,0]
[10,0,0,1,1,1]
[11,0,1,1,1,0]
[12,0,1,1,1,1]
[13,0,1,1,0,1]
[14,0,1,0,0,1]
[15,0,0,0,0,1]
[16,0,0,0,1,0]
[17,0,0,1,0,0]
[18,0,1,0,0,0]
[19,0,0,0,1,1]
[20,0,0,1,1,0]
[21,0,1,1,0,0]
[22,0,1,0,1,1]
[23,0,0,1,0,1]
[24,0,1,0,1,0]
[25,1,0,1,0,0]
[26,0,1,0,0,0]
[27,0,0,0,1,1]
[28,0,0,1,1,0]
[29,0,1,1,0,0]
[30,0,1,0,1,1]
[31,0,0,1,0,1]
[32,0,1,0,1,0]
[null,{"$f":"\"x\"&BIN2HEX((B2&B3&B4&B5&B6&B7&B8&B9),2)&BIN2HEX((B10&B11&B12&B13&B14&B15&B16&B17),2)&\" \"&BIN2HEX((B18&B19&B20&B21&B22&B23&B24&B25),2)&BIN2HEX((B26&B27&B28&B29&C33&D33&E33&F33),2)","v":"xE000 008A"}]