{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["RotinaCRC","Aceitação_CRC","Explanação - Gerador","Explanação - Receptor","Dados"],"not_rendered":{"images":3,"macros":1},"read":"whole","date_system":"1900"}

{"sheet":"RotinaCRC","index":0,"n_rows":90,"n_cols":54,"rows_kept":90,"merged":[[1,15,1,21]]}
["CRC CAN"]
[null,"Inicio relativo",{"$nulls":12},"CRC:","0111100000100110"]
[{"$nulls":15},"Confirmado!"]
[]
[null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17]
[null,"Data",1,0,0,0,0,0,1,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,1,1,0,1,1,0,1,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"FIM"]
[null,"Divisor",1,1,0,0,0,0,0,0,0,0,0,0,0,0,1,0,1,"FIM"]
[null,"Data XOR Divisor",0,1,0,0,0,0,1,0,0,0,1,0,0,0,1,0,1,1,0,0,0,0,0,1,1,0,1,1,0,1,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"FIM"]
[]
[null,"Data",0,1,0,0,0,0,1,0,0,0,1,0,0,0,1,0,1,1,0,0,0,0,0,1,1,0,1,1,0,1,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"FIM"]
[null,"Divisor",null,1,1,0,0,0,0,0,0,0,0,0,0,0,0,1,0,1,"FIM"]
[null,"Data XOR Divisor",0,0,1,0,0,0,1,0,0,0,1,0,0,0,1,1,1,0,0,0,0,0,0,1,1,0,1,1,0,1,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"FIM"]
[]
[null,"Data",0,0,1,0,0,0,1,0,0,0,1,0,0,0,1,1,1,0,0,0,0,0,0,1,1,0,1,1,0,1,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"FIM"]
[null,"Divisor",null,null,1,1,0,0,0,0,0,0,0,0,0,0,0,0,1,0,1,"FIM"]
[null,"Data XOR Divisor",0,0,0,1,0,0,1,0,0,0,1,0,0,0,1,1,0,0,1,0,0,0,0,1,1,0,1,1,0,1,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"FIM"]
[]
[null,"Data",0,0,0,1,0,0,1,0,0,0,1,0,0,0,1,1,0,0,1,0,0,0,0,1,1,0,1,1,0,1,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"FIM"]
[null,"Divisor",{"$nulls":3},1,1,0,0,0,0,0,0,0,0,0,0,0,0,1,0,1,"FIM"]
[null,"Data XOR Divisor",0,0,0,0,1,0,1,0,0,0,1,0,0,0,1,1,0,1,1,1,0,0,0,1,1,0,1,1,0,1,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"FIM"]
[]
[null,"Data",0,0,0,0,1,0,1,0,0,0,1,0,0,0,1,1,0,1,1,1,0,0,0,1,1,0,1,1,0,1,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"FIM"]
[null,"Divisor",{"$nulls":4},1,1,0,0,0,0,0,0,0,0,0,0,0,0,1,0,1,"FIM"]
[null,"Data XOR Divisor",0,0,0,0,0,1,1,0,0,0,1,0,0,0,1,1,0,1,0,1,1,0,0,1,1,0,1,1,0,1,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"FIM"]
[]
[null,"Data",0,0,0,0,0,1,1,0,0,0,1,0,0,0,1,1,0,1,0,1,1,0,0,1,1,0,1,1,0,1,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"FIM"]
[null,"Divisor",{"$nulls":5},1,1,0,0,0,0,0,0,0,0,0,0,0,0,1,0,1,"FIM"]
[null,"Data XOR Divisor",0,0,0,0,0,0,0,0,0,0,1,0,0,0,1,1,0,1,0,0,1,1,0,1,1,0,1,1,0,1,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"FIM"]
[]
[null,"Data",0,0,0,0,0,0,0,0,0,0,1,0,0,0,1,1,0,1,0,0,1,1,0,1,1,0,1,1,0,1,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"FIM"]
[null,"Divisor",{"$nulls":10},1,1,0,0,0,0,0,0,0,0,0,0,0,0,1,0,1,"FIM"]
[null,"Data XOR Divisor",0,0,0,0,0,0,0,0,0,0,0,1,0,0,1,1,0,1,0,0,1,1,0,1,0,0,0,1,0,1,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"FIM"]
[]
[null,"Data",0,0,0,0,0,0,0,0,0,0,0,1,0,0,1,1,0,1,0,0,1,1,0,1,0,0,0,1,0,1,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"FIM"]
[null,"Divisor",{"$nulls":11},1,1,0,0,0,0,0,0,0,0,0,0,0,0,1,0,1,"FIM"]
[null,"Data XOR Divisor",0,0,0,0,0,0,0,0,0,0,0,0,1,0,1,1,0,1,0,0,1,1,0,1,0,1,0,0,0,1,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"FIM"]
[]
[null,"Data",0,0,0,0,0,0,0,0,0,0,0,0,1,0,1,1,0,1,0,0,1,1,0,1,0,1,0,0,0,1,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"FIM"]
[null,"Divisor",{"$nulls":12},1,1,0,0,0,0,0,0,0,0,0,0,0,0,1,0,1,"FIM"]
[null,"Data XOR Divisor",0,0,0,0,0,0,0,0,0,0,0,0,0,1,1,1,0,1,0,0,1,1,0,1,0,1,1,0,1,1,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"FIM"]
[]
[null,"Data",0,0,0,0,0,0,0,0,0,0,0,0,0,1,1,1,0,1,0,0,1,1,0,1,0,1,1,0,1,1,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"FIM"]
[null,"Divisor",{"$nulls":13},1,1,0,0,0,0,0,0,0,0,0,0,0,0,1,0,1,"FIM"]
[null,"Data XOR Divisor",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,1,0,0,1,1,0,1,0,1,1,1,1,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"FIM"]
[]
[null,"Data",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,1,0,0,1,1,0,1,0,1,1,1,1,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"FIM"]
[null,"Divisor",{"$nulls":15},1,1,0,0,0,0,0,0,0,0,0,0,0,0,1,0,1,"FIM"]
[null,"Data XOR Divisor",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,1,0,0,1,1,0,1,0,1,1,1,1,1,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"FIM"]
[]
[null,"Data",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,1,0,0,1,1,0,1,0,1,1,1,1,1,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"FIM"]
[null,"Divisor",{"$nulls":16},1,1,0,0,0,0,0,0,0,0,0,0,0,0,1,0,1,"FIM"]
[null,"Data XOR Divisor",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,1,0,1,0,1,1,1,1,1,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"FIM"]
[]
[null,"Data",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,1,0,1,0,1,1,1,1,1,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"FIM"]
[null,"Divisor",{"$nulls":20},1,1,0,0,0,0,0,0,0,0,0,0,0,0,1,0,1,"FIM"]
[null,"Data XOR Divisor",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,1,1,1,1,1,1,0,0,0,1,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"FIM"]
[]
[null,"Data",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,1,1,1,1,1,1,0,0,0,1,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"FIM"]
[null,"Divisor",{"$nulls":23},1,1,0,0,0,0,0,0,0,0,0,0,0,0,1,0,1,"FIM"]
[null,"Data XOR Divisor",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,1,1,1,1,1,1,0,0,0,1,0,1,1,0,1,0,0,0,0,0,0,0,0,0,0,0,"FIM"]
[]
[null,"Data",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,1,1,1,1,1,1,0,0,0,1,0,1,1,0,1,0,0,0,0,0,0,0,0,0,0,0,"FIM"]
[null,"Divisor",{"$nulls":24},1,1,0,0,0,0,0,0,0,0,0,0,0,0,1,0,1,"FIM"]
[null,"Data XOR Divisor",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,1,1,1,1,0,0,0,1,0,1,1,1,1,1,0,0,0,0,0,0,0,0,0,0,"FIM"]
[]
[null,"Data",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,1,1,1,1,0,0,0,1,0,1,1,1,1,1,0,0,0,0,0,0,0,0,0,0,"FIM"]
[null,"Divisor",{"$nulls":26},1,1,0,0,0,0,0,0,0,0,0,0,0,0,1,0,1,"FIM"]
[null,"Data XOR Divisor",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,1,1,0,0,0,1,0,1,1,1,1,0,0,1,0,0,0,0,0,0,0,0,"FIM"]
[]
[null,"Data",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,1,1,0,0,0,1,0,1,1,1,1,0,0,1,0,0,0,0,0,0,0,0,"FIM"]
[null,"Divisor",{"$nulls":28},1,1,0,0,0,0,0,0,0,0,0,0,0,0,1,0,1,"FIM"]
[null,"Data XOR Divisor",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,1,0,1,1,1,1,0,0,0,0,1,0,0,0,0,0,0,"FIM"]
[]
[null,"Data",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,1,0,1,1,1,1,0,0,0,0,1,0,0,0,0,0,0,"FIM"]
[null,"Divisor",{"$nulls":30},1,1,0,0,0,0,0,0,0,0,0,0,0,0,1,0,1,"FIM"]
[null,"Data XOR Divisor",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,1,0,1,1,1,1,0,0,0,0,0,0,1,0,0,0,0,"FIM"]
[]
[null,"Data",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,1,0,1,1,1,1,0,0,0,0,0,0,1,0,0,0,0,"FIM"]
[null,"Divisor",{"$nulls":31},1,1,0,0,0,0,0,0,0,0,0,0,0,0,1,0,1,"FIM"]
[null,"Data XOR Divisor",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,1,0,1,1,1,1,0,0,0,0,0,1,1,1,0,0,0,"FIM"]
[]
[null,"Data",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,1,0,1,1,1,1,0,0,0,0,0,1,1,1,0,0,0,"FIM"]
[null,"Divisor",{"$nulls":32},1,1,0,0,0,0,0,0,0,0,0,0,0,0,1,0,1,"FIM"]
[null,"Data XOR Divisor",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,1,0,1,1,1,1,0,0,0,0,0,1,0,1,1,0,0,"FIM"]
[]
[null,"Data",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,1,0,1,1,1,1,0,0,0,0,0,1,0,1,1,0,0,"FIM"]
[null,"Divisor",{"$nulls":33},1,1,0,0,0,0,0,0,0,0,0,0,0,0,1,0,1,"FIM"]
[null,"Data XOR Divisor",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,1,1,1,0,0,0,0,0,1,0,0,1,1,0,"FIM"]
[]
[null,"Data",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,1,1,1,0,0,0,0,0,1,0,0,1,1,0,"FIM"]

{"sheet":"Aceitação_CRC","index":1,"n_rows":90,"n_cols":54,"rows_kept":90}
[]
[{"$nulls":15},"CRC: 0000000000000000"]
[{"$nulls":15},"Confirmado!"]
[]
[null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17]
[null,"Data",1,0,0,0,0,0,1,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,1,1,0,1,1,0,1,0,1,1,0,0,0,1,1,1,1,0,0,0,0,0,1,0,0,1,1,0,"FIM"]
[null,"Divisor",1,1,0,0,0,0,0,0,0,0,0,0,0,0,1,0,1,"FIM"]
[null,"Data XOR Divisor",0,1,0,0,0,0,1,0,0,0,1,0,0,0,1,0,1,1,0,0,0,0,0,1,1,0,1,1,0,1,0,1,1,0,0,0,1,1,1,1,0,0,0,0,0,1,0,0,1,1,0,"FIM"]
[]
[null,"Data",0,1,0,0,0,0,1,0,0,0,1,0,0,0,1,0,1,1,0,0,0,0,0,1,1,0,1,1,0,1,0,1,1,0,0,0,1,1,1,1,0,0,0,0,0,1,0,0,1,1,0,"FIM"]
[null,"Divisor",null,1,1,0,0,0,0,0,0,0,0,0,0,0,0,1,0,1,"FIM"]
[null,"Data XOR Divisor",0,0,1,0,0,0,1,0,0,0,1,0,0,0,1,1,1,0,0,0,0,0,0,1,1,0,1,1,0,1,0,1,1,0,0,0,1,1,1,1,0,0,0,0,0,1,0,0,1,1,0,"FIM"]
[]
[null,"Data",0,0,1,0,0,0,1,0,0,0,1,0,0,0,1,1,1,0,0,0,0,0,0,1,1,0,1,1,0,1,0,1,1,0,0,0,1,1,1,1,0,0,0,0,0,1,0,0,1,1,0,"FIM"]
[null,"Divisor",null,null,1,1,0,0,0,0,0,0,0,0,0,0,0,0,1,0,1,"FIM"]
[null,"Data XOR Divisor",0,0,0,1,0,0,1,0,0,0,1,0,0,0,1,1,0,0,1,0,0,0,0,1,1,0,1,1,0,1,0,1,1,0,0,0,1,1,1,1,0,0,0,0,0,1,0,0,1,1,0,"FIM"]
[]
[null,"Data",0,0,0,1,0,0,1,0,0,0,1,0,0,0,1,1,0,0,1,0,0,0,0,1,1,0,1,1,0,1,0,1,1,0,0,0,1,1,1,1,0,0,0,0,0,1,0,0,1,1,0,"FIM"]
[null,"Divisor",{"$nulls":3},1,1,0,0,0,0,0,0,0,0,0,0,0,0,1,0,1,"FIM"]
[null,"Data XOR Divisor",0,0,0,0,1,0,1,0,0,0,1,0,0,0,1,1,0,1,1,1,0,0,0,1,1,0,1,1,0,1,0,1,1,0,0,0,1,1,1,1,0,0,0,0,0,1,0,0,1,1,0,"FIM"]
[]
[null,"Data",0,0,0,0,1,0,1,0,0,0,1,0,0,0,1,1,0,1,1,1,0,0,0,1,1,0,1,1,0,1,0,1,1,0,0,0,1,1,1,1,0,0,0,0,0,1,0,0,1,1,0,"FIM"]
[null,"Divisor",{"$nulls":4},1,1,0,0,0,0,0,0,0,0,0,0,0,0,1,0,1,"FIM"]
[null,"Data XOR Divisor",0,0,0,0,0,1,1,0,0,0,1,0,0,0,1,1,0,1,0,1,1,0,0,1,1,0,1,1,0,1,0,1,1,0,0,0,1,1,1,1,0,0,0,0,0,1,0,0,1,1,0,"FIM"]
[]
[null,"Data",0,0,0,0,0,1,1,0,0,0,1,0,0,0,1,1,0,1,0,1,1,0,0,1,1,0,1,1,0,1,0,1,1,0,0,0,1,1,1,1,0,0,0,0,0,1,0,0,1,1,0,"FIM"]
[null,"Divisor",{"$nulls":5},1,1,0,0,0,0,0,0,0,0,0,0,0,0,1,0,1,"FIM"]
[null,"Data XOR Divisor",0,0,0,0,0,0,0,0,0,0,1,0,0,0,1,1,0,1,0,0,1,1,0,1,1,0,1,1,0,1,0,1,1,0,0,0,1,1,1,1,0,0,0,0,0,1,0,0,1,1,0,"FIM"]
[]
[null,"Data",0,0,0,0,0,0,0,0,0,0,1,0,0,0,1,1,0,1,0,0,1,1,0,1,1,0,1,1,0,1,0,1,1,0,0,0,1,1,1,1,0,0,0,0,0,1,0,0,1,1,0,"FIM"]
[null,"Divisor",{"$nulls":10},1,1,0,0,0,0,0,0,0,0,0,0,0,0,1,0,1,"FIM"]
[null,"Data XOR Divisor",0,0,0,0,0,0,0,0,0,0,0,1,0,0,1,1,0,1,0,0,1,1,0,1,0,0,0,1,0,1,0,1,1,0,0,0,1,1,1,1,0,0,0,0,0,1,0,0,1,1,0,"FIM"]
[]
[null,"Data",0,0,0,0,0,0,0,0,0,0,0,1,0,0,1,1,0,1,0,0,1,1,0,1,0,0,0,1,0,1,0,1,1,0,0,0,1,1,1,1,0,0,0,0,0,1,0,0,1,1,0,"FIM"]
[null,"Divisor",{"$nulls":11},1,1,0,0,0,0,0,0,0,0,0,0,0,0,1,0,1,"FIM"]
[null,"Data XOR Divisor",0,0,0,0,0,0,0,0,0,0,0,0,1,0,1,1,0,1,0,0,1,1,0,1,0,1,0,0,0,1,0,1,1,0,0,0,1,1,1,1,0,0,0,0,0,1,0,0,1,1,0,"FIM"]
[]
[null,"Data",0,0,0,0,0,0,0,0,0,0,0,0,1,0,1,1,0,1,0,0,1,1,0,1,0,1,0,0,0,1,0,1,1,0,0,0,1,1,1,1,0,0,0,0,0,1,0,0,1,1,0,"FIM"]
[null,"Divisor",{"$nulls":12},1,1,0,0,0,0,0,0,0,0,0,0,0,0,1,0,1,"FIM"]
[null,"Data XOR Divisor",0,0,0,0,0,0,0,0,0,0,0,0,0,1,1,1,0,1,0,0,1,1,0,1,0,1,1,0,1,1,0,1,1,0,0,0,1,1,1,1,0,0,0,0,0,1,0,0,1,1,0,"FIM"]
[]
[null,"Data",0,0,0,0,0,0,0,0,0,0,0,0,0,1,1,1,0,1,0,0,1,1,0,1,0,1,1,0,1,1,0,1,1,0,0,0,1,1,1,1,0,0,0,0,0,1,0,0,1,1,0,"FIM"]
[null,"Divisor",{"$nulls":13},1,1,0,0,0,0,0,0,0,0,0,0,0,0,1,0,1,"FIM"]
[null,"Data XOR Divisor",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,1,0,0,1,1,0,1,0,1,1,1,1,0,0,1,1,0,0,0,1,1,1,1,0,0,0,0,0,1,0,0,1,1,0,"FIM"]
[]
[null,"Data",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,1,0,0,1,1,0,1,0,1,1,1,1,0,0,1,1,0,0,0,1,1,1,1,0,0,0,0,0,1,0,0,1,1,0,"FIM"]
[null,"Divisor",{"$nulls":15},1,1,0,0,0,0,0,0,0,0,0,0,0,0,1,0,1,"FIM"]
[null,"Data XOR Divisor",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,1,0,0,1,1,0,1,0,1,1,1,1,1,0,0,1,0,0,0,1,1,1,1,0,0,0,0,0,1,0,0,1,1,0,"FIM"]
[]
[null,"Data",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,1,0,0,1,1,0,1,0,1,1,1,1,1,0,0,1,0,0,0,1,1,1,1,0,0,0,0,0,1,0,0,1,1,0,"FIM"]
[null,"Divisor",{"$nulls":16},1,1,0,0,0,0,0,0,0,0,0,0,0,0,1,0,1,"FIM"]
[null,"Data XOR Divisor",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,1,0,1,0,1,1,1,1,1,1,0,0,0,0,0,1,1,1,1,0,0,0,0,0,1,0,0,1,1,0,"FIM"]
[]
[null,"Data",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,1,0,1,0,1,1,1,1,1,1,0,0,0,0,0,1,1,1,1,0,0,0,0,0,1,0,0,1,1,0,"FIM"]
[null,"Divisor",{"$nulls":20},1,1,0,0,0,0,0,0,0,0,0,0,0,0,1,0,1,"FIM"]
[null,"Data XOR Divisor",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,1,1,1,1,1,1,0,0,0,1,0,0,1,1,1,0,0,0,0,0,1,0,0,1,1,0,"FIM"]
[]
[null,"Data",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,1,1,1,1,1,1,0,0,0,1,0,0,1,1,1,0,0,0,0,0,1,0,0,1,1,0,"FIM"]
[null,"Divisor",{"$nulls":23},1,1,0,0,0,0,0,0,0,0,0,0,0,0,1,0,1,"FIM"]
[null,"Data XOR Divisor",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,1,1,1,1,1,1,0,0,0,1,0,0,0,1,0,0,0,0,0,0,1,0,0,1,1,0,"FIM"]
[]
[null,"Data",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,1,1,1,1,1,1,0,0,0,1,0,0,0,1,0,0,0,0,0,0,1,0,0,1,1,0,"FIM"]
[null,"Divisor",{"$nulls":24},1,1,0,0,0,0,0,0,0,0,0,0,0,0,1,0,1,"FIM"]
[null,"Data XOR Divisor",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,1,1,1,1,0,0,0,1,0,0,0,0,0,1,0,0,0,0,1,0,0,1,1,0,"FIM"]
[]
[null,"Data",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,1,1,1,1,0,0,0,1,0,0,0,0,0,1,0,0,0,0,1,0,0,1,1,0,"FIM"]
[null,"Divisor",{"$nulls":26},1,1,0,0,0,0,0,0,0,0,0,0,0,0,1,0,1,"FIM"]
[null,"Data XOR Divisor",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,1,1,0,0,0,1,0,0,0,0,0,0,0,1,0,0,1,0,0,1,1,0,"FIM"]
[]
[null,"Data",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,1,1,0,0,0,1,0,0,0,0,0,0,0,1,0,0,1,0,0,1,1,0,"FIM"]
[null,"Divisor",{"$nulls":28},1,1,0,0,0,0,0,0,0,0,0,0,0,0,1,0,1,"FIM"]
[null,"Data XOR Divisor",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,1,0,0,0,0,0,0,0,0,0,1,1,0,0,1,1,0,"FIM"]
[]
[null,"Data",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,1,0,0,0,0,0,0,0,0,0,1,1,0,0,1,1,0,"FIM"]
[null,"Divisor",{"$nulls":30},1,1,0,0,0,0,0,0,0,0,0,0,0,0,1,0,1,"FIM"]
[null,"Data XOR Divisor",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,1,0,0,0,0,0,0,0,0,0,0,1,1,0,1,1,0,"FIM"]
[]
[null,"Data",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,1,0,0,0,0,0,0,0,0,0,0,1,1,0,1,1,0,"FIM"]
[null,"Divisor",{"$nulls":31},1,1,0,0,0,0,0,0,0,0,0,0,0,0,1,0,1,"FIM"]
[null,"Data XOR Divisor",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,1,0,0,0,0,0,0,0,0,0,0,0,1,1,1,1,0,"FIM"]
[]
[null,"Data",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,1,0,0,0,0,0,0,0,0,0,0,0,1,1,1,1,0,"FIM"]
[null,"Divisor",{"$nulls":32},1,1,0,0,0,0,0,0,0,0,0,0,0,0,1,0,1,"FIM"]
[null,"Data XOR Divisor",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,1,0,1,0,"FIM"]
[]
[null,"Data",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,1,0,1,0,"FIM"]
[null,"Divisor",{"$nulls":33},1,1,0,0,0,0,0,0,0,0,0,0,0,0,1,0,1,"FIM"]
[null,"Data XOR Divisor",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"FIM"]
[]
[null,"Data",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"FIM"]

{"sheet":"Explanação - Gerador","index":2,"n_rows":31,"n_cols":38,"rows_kept":31,"merged":[[1,2,1,32]]}
[null,"A","B","C","D","E","F","G","H","I","J","K","L","M","N","O","P","Q","R","S","T","U","V","W","X","Y","Z ","AA","AB","AC","AD","AE","AF","AG","AH","AF","AG","AH"]
[1,null,"CRC CAN - Geração"]
[2,null,"Inicio relativo"]
[3,{"$nulls":4},"polinômio",{"$nulls":10},"no de zeros no final = maior expoente do polinômio"]
[4]
[5,null,null,1,2,3,4,5,6,7,8,9,10,11,12]
[6,null,"Data",1,1,0,1,1,0,1,0,0,0,0,"FIM",{"$nulls":7},"bits:","=>",4,3,2,1,0]
[7,null,"Divisor",1,0,0,1,1,"FIM",{"$nulls":8},"Polinômio:",null,null,"X^4 + X + 1",null,null,"=>",1,0,0,1,1]
[8,null,"Data XOR Divisor",0,1,0,0,0,0,1,0,0,0,0,"FIM"]
[9]
[10,null,"Data",0,1,0,0,0,0,1,0,0,0,0,"FIM",{"$nulls":5},"Resultado de Data XOR Divisor"]
[11,null,"Divisor",null,1,0,0,1,1,"FIM",{"$nulls":10},"Desloca-se para direita à cada passo, sempre alinhando com o \"1\" na linha de cima."]
[12,null,"Data XOR Divisor",0,0,0,0,1,1,1,0,0,0,0,"FIM"]
[13]
[14,null,"Data",0,0,0,0,1,1,1,0,0,0,0,"FIM"]
[15,null,"Divisor",{"$nulls":4},1,0,0,1,1,"FIM"]
[16,null,"Data XOR Divisor",0,0,0,0,0,1,1,1,1,0,0,"FIM"]
[17]
[18,null,"Data",0,0,0,0,0,1,1,1,1,0,0,"FIM"]
[19,null,"Divisor",{"$nulls":5},1,0,0,1,1,"FIM"]
[20,null,"Data XOR Divisor",0,0,0,0,0,0,1,1,0,1,0,"FIM"]
[21]
[22,null,"Data",0,0,0,0,0,0,1,1,0,1,0,"FIM"]
[23,null,"Divisor",{"$nulls":6},1,0,0,1,1,"FIM",{"$nulls":5},"Finaliza quando coincidir com o final da linha superior ou não for possível"]
[24,null,"Data XOR Divisor",0,0,0,0,0,0,0,1,0,0,1,"FIM",{"$nulls":5},"fazer o deslocamento sem ultrapassar a linha superior."]
[25]
[26,null,"Data",0,0,0,0,0,0,0,1,0,0,1,"FIM",{"$nulls":5},"CRC procurado ! No de dígitos da esquerda para direita igual ao maior expoente do Polinômio"]
[27]
[28]
[29]
[30]

{"sheet":"Explanação - Receptor","index":3,"n_rows":31,"n_cols":38,"rows_kept":31,"merged":[[1,2,1,32]]}
[null,"A","B","C","D","E","F","G","H","I","J","K","L","M","N","O","P","Q","R","S","T","U","V","W","X","Y","Z ","AA","AB","AC","AD","AE","AF","AG","AH","AF","AG","AH"]
[1,null,"CRC CAN - Verificação"]
[2,null,"Inicio relativo"]
[3,{"$nulls":4},"polinômio",{"$nulls":10},"substituir os zeros iniciais pelo resultado obtido na geração (CRC)"]
[4]
[5,null,null,1,2,3,4,5,6,7,8,9,10,11,12,{"$nulls":7},"bits:","=>",4,3,2,1,0]
[6,null,"Data",1,1,0,1,1,0,1,1,0,0,1,"FIM",null,null,"Polinômio:",null,null,"X^4 + X + 1",null,null,"=>",1,0,0,1,1]
[7,null,"Divisor",1,0,0,1,1,"FIM"]
[8,null,"Data XOR Divisor",0,1,0,0,0,0,1,1,0,0,1,"FIM"]
[9]
[10,null,"Data",0,1,0,0,0,0,1,1,0,0,1,"FIM",{"$nulls":5},"Resultado de Data XOR Divisor"]
[11,null,"Divisor",null,1,0,0,1,1,"FIM",{"$nulls":10},"Desloca-se para direita à cada passo, sempre alinhando com o \"1\" na linha de cima."]
[12,null,"Data XOR Divisor",0,0,0,0,1,1,1,1,0,0,1,"FIM"]
[13]
[14,null,"Data",0,0,0,0,1,1,1,1,0,0,1,"FIM"]
[15,null,"Divisor",{"$nulls":4},1,0,0,1,1,"FIM"]
[16,null,"Data XOR Divisor",0,0,0,0,0,1,1,0,1,0,1,"FIM"]
[17]
[18,null,"Data",0,0,0,0,0,1,1,0,1,0,1,"FIM"]
[19,null,"Divisor",{"$nulls":5},1,0,0,1,1,"FIM"]
[20,null,"Data XOR Divisor",0,0,0,0,0,0,1,0,0,1,1,"FIM"]
[21]
[22,null,"Data",0,0,0,0,0,0,1,0,0,1,1,"FIM"]
[23,null,"Divisor",{"$nulls":6},1,0,0,1,1,"FIM",{"$nulls":5},"Finaliza quando coincidir com o final da linha superior ou não for possível"]
[24,null,"Data XOR Divisor",0,0,0,0,0,0,0,0,0,0,0,"FIM",{"$nulls":5},"fazer o deslocamento sem ultrapassar a linha superior."]
[25]
[26,null,"Data",0,0,0,0,0,0,0,0,0,0,0,"FIM",{"$nulls":5},"Se os dados estiverem corretos, o resultado dessa operação tem que ser ZERO!"]
[27]
[28]
[29]
[30]

{"sheet":"Dados","index":4,"n_rows":41,"n_cols":60,"rows_kept":41,"merged":[[4,1,5,1],[8,1,9,1],[14,1,15,1],[18,1,19,1],[24,1,25,1],[28,1,29,1],[34,1,35,1],[38,1,39,1]]}
[]
[null,"Divisor",98309,32773]
[]
[null,"Exemplo de CRC-16 IBM"]
[null,"Data",{"$f":"I6&J6&K6&L6&M6&N6&O6&P6&Q6&R6&S6&T6&U6&V6&W6&X6&Y6&Z6&AA6&AB6&AC6&AD6&AE6&AF6&AG6&AH6&AI6&AJ6&AK6&AL6&AM6&AN6&AO6&AP6&AQ6","v":"10000010001000000100000110110101100"},{"$nulls":5},34,33,32,31,30,29,28,27,26,25,24,23,22,21,20,19,18,17,16,15,14,14,12,11,10,9,8,7,6,5,4,3,2,1,0]
[null,null,"Decimal",{"$f":"SUM(I7:AQ7)","v":17465216428},{"$nulls":3},"0X 411020DAC",1,0,0,0,0,0,1,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,1,1,0,1,1,0,1,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"FIM"]
[{"$nulls":8},{"$f":"I6*(2^I5)","v":17179869184},{"$f":"J6*(2^J5)","v":0},{"$f":"K6*(2^K5)","v":0},{"$f":"L6*(2^L5)","v":0},{"$f":"M6*(2^M5)","v":0},{"$f":"N6*(2^N5)","v":0},{"$f":"O6*(2^O5)","v":268435456},{"$f":"P6*(2^P5)","v":0},{"$f":"Q6*(2^Q5)","v":0},{"$f":"R6*(2^R5)","v":0},{"$f":"S6*(2^S5)","v":16777216},{"$f":"T6*(2^T5)","v":0},{"$f":"U6*(2^U5)","v":0},{"$f":"V6*(2^V5)","v":0},{"$f":"W6*(2^W5)","v":0},{"$f":"X6*(2^X5)","v":0},{"$f":"Y6*(2^Y5)","v":0},{"$f":"Z6*(2^Z5)","v":131072},{"$f":"AA6*(2^AA5)","v":0},{"$f":"AB6*(2^AB5)","v":0},{"$f":"AC6*(2^AC5)","v":0},{"$f":"AD6*(2^AD5)","v":0},{"$f":"AE6*(2^AE5)","v":0},{"$f":"AF6*(2^AF5)","v":2048},{"$f":"AG6*(2^AG5)","v":1024},{"$f":"AH6*(2^AH5)","v":0},{"$f":"AI6*(2^AI5)","v":256},{"$f":"AJ6*(2^AJ5)","v":128},{"$f":"AK6*(2^AK5)","v":0},{"$f":"AL6*(2^AL5)","v":32},{"$f":"AM6*(2^AM5)","v":0},{"$f":"AN6*(2^AN5)","v":8},{"$f":"AO6*(2^AO5)","v":4},{"$f":"AP6*(2^AP5)","v":0},{"$f":"AQ6*(2^AQ5)","v":0}]
[]
[null,"Divisor",{"$f":"AA10&AB10&AC10&AD10&AE10&AF10&AG10&AH10&AI10&AJ10&AK10&AL10&AM10&AN10&AO10&AP10&AQ10","v":"11000000000000101"},"X^16+X^15+X^2+1",{"$nulls":3},"0x 1 8005",{"$nulls":18},16,15,14,13,12,11,10,9,8,7,6,5,4,3,2,1,0]
[null,null,"Decimal",{"$f":"SUM(AA11:AQ11)","v":98309},{"$nulls":22},1,1,0,0,0,0,0,0,0,0,0,0,0,0,1,0,1,"FIM"]
[{"$nulls":26},{"$f":"AA10*(2^AA9)","v":65536},{"$f":"AB10*(2^AB9)","v":32768},0,0,0,0,0,0,0,0,0,0,0,0,4,0,1]
[]
[null,"Exemplo utilizado no artigo Como Funciona a CAN"]
[null,"CRC de 15 bits conforme CAN 2.0A"]
[null,"Data",{"$f":"I16&J16&K16&L16&M16&N16&O16&P16&Q16&R16&S16&T16&U16&V16&W16&X16&Y16&Z16&AA16&AB16&AC16&AD16&AE16&AF16&AG16&AH16&AI16&AJ16&AK16&AL16&AM16&AN16&AO16&AP16&AQ16","v":"10000010001000000100000110110101100"},{"$nulls":5},34,33,32,31,30,29,28,27,26,25,24,23,22,21,20,19,18,17,16,15,14,14,12,11,10,9,8,7,6,5,4,3,2,1,0]
[null,null,"Decimal",{"$f":"SUM(I17:AQ17)","v":17465216428},{"$nulls":4},1,0,0,0,0,0,1,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,1,1,0,1,1,0,1,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"FIM"]
[{"$nulls":8},{"$f":"I16*(2^I15)","v":17179869184},0,0,0,0,0,268435456,0,0,0,16777216,0,0,0,0,0,0,131072,0,0,0,0,0,2048,1024,0,256,128,0,32,0,8,4,0,0]
[]
[null,"Divisor",{"$f":"AA20&AB20&AC20&AD20&AE20&AF20&AG20&AH20&AI20&AJ20&AK20&AL20&AM20&AN20&AO20&AP20&AQ20","v":"1100010110011001"},"X^15+X^14+X^10+X^8+X^7+X^4+X^3+1",{"$nulls":3},"0x C599",{"$nulls":19},15,14,13,12,11,10,9,8,7,6,5,4,3,2,1,0]
[null,null,"Decimal",{"$f":"SUM(AB21:AQ21)","v":50585},{"$nulls":23},1,1,0,0,0,1,0,1,1,0,0,1,1,0,0,1,"FIM"]
[{"$nulls":27},{"$f":"AB20*(2^AB19)","v":32768},16384,0,0,0,1024,0,256,128,0,0,16,8,0,0,1]
[]
[null,"Exemplo retirado da Wikepedia: https://pt.wikipedia.org/wiki/CRC"]
[null,"CRC de 4 bits: X3 + X + 1"]
[null,"Data",{"$f":"I26&J26&K26&L26&M26&N26&O26&P26&Q26&R26&S26&T26&U26&V26","v":"11010011101100"},{"$nulls":5},14,12,11,10,9,8,7,6,5,4,3,2,1,0]
[null,null,"Decimal",{"$f":"SUM(I27:V27)","v":21740},{"$nulls":4},1,1,0,1,0,0,1,1,1,0,1,1,0,0,0,0,0,"FIM"]
[{"$nulls":8},{"$f":"I26*(2^I25)","v":16384},4096,0,1024,0,0,128,64,32,0,8,4,0,0]
[]
[null,"Divisor",{"$f":"AA30&AB30&AC30&AD30&AE30&AF30&AG30&AH30&AI30&AJ30&AK30&AL30&AM30&S30&T30&U30&V30","v":"1011"},"X^3 + X + 1",{"$nulls":3},"0x 0B",{"$nulls":10},3,2,1,0]
[null,null,"Decimal",{"$f":"SUM(S31:V31)","v":11},{"$nulls":14},1,0,1,1,"FIM"]
[{"$nulls":18},{"$f":"S30*(2^S29)","v":8},{"$f":"T30*(2^T29)","v":0},{"$f":"U30*(2^U29)","v":2},{"$f":"V30*(2^V29)","v":1}]
[]
[null,"Exemplo retirado de https://www.lammertbies.nl/comm/info/crc-calculation.html"]
[null,"CRC de 3 bits: X^2 + 1"]
[null,"Data",{"$f":"I36&J36&K36&L36&M36&N36&O36&T36&Q36&R36&S36&#REF!&U36&V36&W36&X36&Y36&Z36&AA36&AB36&AC36&AD36&AE36&AF36&AG36&AH36&AI36&AJ36&AK36&AL36&AM36&AN36&AO36&AP36&AQ36","v":{"$error":"#REF!"}},{"$nulls":5},6,5,4,3,2,1,0]
[null,null,"Decimal",{"$f":"SUM(I37:AQ37)","v":109},{"$nulls":4},1,1,0,1,1,0,1,0,0,0,0,"FIM"]
[{"$nulls":8},{"$f":"I36*(2^I35)","v":64},32,0,8,4,0,1]
[]
[null,"Divisor",{"$f":"AA40&I40&J40&K40&L40&M40&N40&O40&P40&Q40&R40&S40&T40&U40&V40&W40&X40","v":"10011FIM"},"X^2+X+1",{"$nulls":3},"0x 05",4,3,2,1,0]
[null,null,"Decimal",{"$f":"SUM(I41:X41)","v":6},{"$nulls":4},1,0,0,1,1,"FIM"]
[{"$nulls":8},{"$f":"I40*(2^K39)","v":4},{"$f":"J40*(2^L39)","v":0},{"$f":"K40*(2^M39)","v":0},{"$f":"L40*(2^N39)","v":1},{"$f":"M40*(2^O39)","v":1}]