{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Таблица CRC","команды управления"],"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":"Таблица CRC","index":0,"n_rows":298,"n_cols":256,"rows_kept":298,"cut":false,"hidden":true,"merged":[]}
["CRCfrom_nekto:"]
["Data.c $00,$5E,$0BC,$0E2,$61,$3F,$0DD,$83,$0C2,$9C,$7E,$20,$0A3,$0FD,$1F,$41"]
["Data.c $9D,$0C3,$21,$7F,$0FC,$0A2,$40,$1E,$5F,$01,$0E3,$0BD,$3E,$60,$82,$0DC"]
["Data.c $23,$7D,$9F,$0C1,$42,$1C,$0FE,$0A0,$0E1,$0BF,$5D,$03,$80,$0DE,$3C,$62",null,null,null,null,null,null,null,null,null,{"$f":"MyXor(L3,'Таблица CRC'!A390)","v":0}]
["Data.c $0BE,$0E0,$02,$5C,$0DF,$81,$63,$3D,$7C,$22,$0C0,$9E,$1D,$43,$0A1,$0FF"]
["Data.c $46,$18,$0FA,$0A4,$27,$79,$9B,$0C5,$84,$0DA,$38,$66,$0E5,$0BB,$59,$07"]
["Data.c $0DB,$85,$67,$39,$0BA,$0E4,$06,$58,$19,$47,$0A5,$0FB,$78,$26,$0C4,$9A"]
["Data.c $65,$3B,$0D9,$87,$04,$5A,$0B8,$0E6,$0A7,$0F9,$1B,$45,$0C6,$98,$7A,$24"]
["Data.c $0F8,$0A6,$44,$1A,$99,$0C7,$25,$7B,$3A,$64,$86,$0D8,$5B,$05,$0E7,$0B9"]
["Data.c $8C,$0D2,$30,$6E,$0ED,$0B3,$51,$0F,$4E,$10,$0F2,$0AC,$2F,$71,$93,$0CD"]
["Data.c $11,$4F,$0AD,$0F3,$70,$2E,$0CC,$92,$0D3,$8D,$6F,$31,$0B2,$0EC,$0E,$50"]
["Data.c $0AF,$0F1,$13,$4D,$0CE,$90,$72,$2C,$6D,$33,$0D1,$8F,$0C,$52,$0B0,$0EE"]
["Data.c $32,$6C,$8E,$0D0,$53,$0D,$0EF,$0B1,$0F0,$0AE,$4C,$12,$91,$0CF,$2D,$73"]
["Data.c $0CA,$94,$76,$28,$0AB,$0F5,$17,$49,$08,$56,$0B4,$0EA,$69,$37,$0D5,$8B"]
["Data.c $57,$09,$0EB,$0B5,$36,$68,$8A,$0D4,$95,$0CB,$29,$77,$0F4,$0AA,$48,$16"]
["Data.c $0E9,$0B7,$55,$0B,$88,$0D6,$34,$6A,$2B,$75,$97,$0C9,$4A,$14,$0F6,$0A8"]
["Data.c $74,$2A,$0C8,$96,$15,$4B,$0A9,$0F7,$0B6,$0FC,$0A,$54,$0D7,$89,$6B,$35"]
[]
["CRCTable : array [0..255] of byte = ("]
["0,94,188,226,97,63,221,131,194,156,126,32,163,253,31,65,"]
["157,195,33,127,252,162,64,30,95,1,227,189,62,96,130,220,"]
["35,125,159,193,66,28,254,160,225,191,93,3,128,222,60,98,"]
["190,224,2,92,223,129,99,61,124,34,192,158,29,67,161,255,"]
["70,24,250,164,39,121,155,197,132,218,56,102,229,187,89,7,"]
["219,133,103,57,186,228,6,88,25,71,165,251,120,38,196,154,"]
["101,59,217,135,4,90,184,230,167,249,27,69,198,152,122,36,"]
["248,166,68,26,153,199,37,123,58,100,134,216,91,5,231,185,"]
["140,210,48,110,237,179,81,15,78,16,242,172,47,113,147,205,"]
["17,79,173,243,112,46,204,146,211,141,111,49,178,236,14,80,"]
["175,241,19,77,206,144,114,44,109,51,209,143,12,82,176,238,"]
["50,108,142,208,83,13,239,177,240,174,76,18,145,207,45,115,"]
["202,148,118,40,171,245,23,73,8,86,180,234,105,55,213,139,"]
["87,9,235,181,54,104,138,212,149,203,41,119,244,170,72,22,"]
["233,183,85,11,136,214,52,106,43,117,151,201,74,20,246,168,"]
["116,42,200,150,21,75,169,247,182,232,10,84,215,137,107,53);"]
["Таблица CRC8 от nekto "]
["00h,5Eh,0BCh,0E2h,61h,3Fh,0DDh,83h,0C2h,9Ch,7Eh,20h,0A3h,0FDh,1Fh,41h,9Dh,0C3h,21h,7Fh,0FCh,0A2h,40h,1Eh,5Fh,01h,0E3h,0BDh,3Eh,60h,82h,0DCh,23h,7Dh,9Fh,0C1h,42h,1Ch,0FEh,0A0h,0E1h,0BFh,5Dh,03h,80h,0DEh,3Ch,62h,0BEh,0E0h,02h,5Ch,0DFh,81h,63h,3Dh,7Ch,22h,0C0h,9Eh,1Dh,43h,0A1h,0FFh,46h,18h,0FAh,0A4h,27h,79h,9Bh,0C5h,84h,0DAh,38h,66h,0E5h,0BBh,59h,07h,0DBh,85h,67h,39h,0BAh,0E4h,06h,58h,19h,47h,0A5h,0FBh,78h,26h,0C4h,9Ah,65h,3Bh,0D9h,87h,04h,5Ah,0B8h,0E6h,0A7h,0F9h,1Bh,45h,0C6h,98h,7Ah,24h,0F8h,0A6h,44h,1Ah,99h,0C7h,25h,7Bh,3Ah,64h,86h,0D8h,5Bh,05h,0E7h,0B9h,8Ch,0D2h,30h,6Eh,0EDh,0B3h,51h,0Fh,4Eh,10h,0F2h,0ACh,2Fh,71h,93h,0CDh,11h,4Fh,0ADh,0F3h,70h,2Eh,0CCh,92h,0D3h,8Dh,6Fh,31h,0B2h,0ECh,0Eh,50h,0AFh,0F1h,13h,4Dh,0CEh,90h,72h,2Ch,6Dh,33h,0D1h,8Fh,0Ch,52h,0B0h,0EEh,32h,6Ch,8Eh,0D0h,53h,0Dh,0EFh,0B1h,0F0h,0AEh,4Ch,12h,91h,0CFh,2Dh,73h,0CAh,94h,76h,28h,0ABh,0F5h,17h,49h,08h,56h,0B4h,0EAh,69h,37h,0D5h,8Bh,57h,09h,0EBh,0B5h,36h,68h,8Ah,0D4h,95h,0CBh,29h,77h,0F4h,0AAh,48h,16h,0E9h,0B7h,55h,0Bh,88h,0D6h,34h,6Ah,2Bh,75h,97h,0C9h,4Ah,14h,0F6h,0A8h,74h,2Ah,0C8h,96h,15h,4Bh,0A9h,0F7h,0B6h,0FCh,0Ah,54h,0D7h,89h,6Bh,35h,00h"]
["00 5E BC E2 61 3F DD 83 C2 9C 7E 20 A3 FD 1F 41 9D C3 21 7F FC A2 40 1E 5F 1 E3 BD 3E 60 82 DC 23 7D 9F C1 42 1C FE A0 E1 BF 5D 3 80 DE 3C 62 BE E0 2 5C DF 81 63 3D 7C 22 C0 9E 1D 43 A1 FF 46 18 FA A4 27 79 9B C5 84 DA 38 66 E5 BB 59 7 DB 85 67 39 BA E4 6 58 19 47 A5 FB 78 26 C4 9A 65 3B D9 87 4 5A B8 E6 A7 F9 1B 45 C6 98 7A 24 F8 A6 44 1A 99 C7 25 7B 3A 64 86 D8 5B 5 E7 B9 8C D2 30 6E ED B3 51 F 4E 10 F2 AC 2F 71 93 CD 11 4F AD F3 70 2E CC 92 D3 8D 6F 31 B2 EC E 50 AF F1 13 4D CE 90 72 2C 6D 33 D1 8F C 52 B0 EE 32 6C 8E D0 53 D EF B1 F0 AE 4C 12 91 CF 2D 73 CA 94 76 28 AB F5 17 49 8 56 B4 EA 69 37 D5 8B 57 9 EB B5 36 68 8A D4 95 CB 29 77 F4 AA 48 16 E9 B7 55 B 88 D6 34 6A 2B 75 97 C9 4A 14 F6 A8 74 2A C8 96 15 4B A9 F7 B6 FC A 54 D7 89 6B 35 0h"]
[0,{"$f":"A39+1","v":1},{"$f":"B39+1","v":2},3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,{"$f":"BN39+1","v":66},67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,{"$f":"DZ39+1","v":130},131,132,133,134,135,136,137,138,139,140,141,142,143,144,145,146,147,148,149,150,151,152,153,154,155,156,157,158,159,160,161,162,163,164,165,166,167,168,169,170,171,172,173,174,175,176,177,178,179,180,181,182,183,184,185,186,187,188,189,190,191,192,193,{"$f":"GL39+1","v":194},195,196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,214,215,216,217,218,219,220,221,222,223,224,225,226,227,228,229,230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255]
[0,"5E","BC","E2",61,"3F","DD",83,"C2","9C","7E",20,"A3","FD","1F",41,"9D","C3",21,"7F","FC","A2",40,"1E","5F",1,"E3","BD","3E",60,82,"DC",23,"7D","9F","C1",42,"1C","FE","A0","E1","BF","5D",3,80,"DE","3C",62,"BE","E0",2,"5C","DF",81,63,"3D","7C",22,"C0","9E","1D",43,"A1","FF",46,18,"FA","A4",27,79,"9B","C5",84,"DA",38,66,"E5","BB",59,7,"DB",85,67,39,"BA","E4",6,58,19,47,"A5","FB",78,26,"C4","9A",65,"3B","D9",87,4,"5A","B8","E6","A7","F9","1B",45,"C6",98,"7A",24,"F8","A6",44,"1A",99,"C7",25,"7B","3A",64,86,"D8","5B",5,"E7","B9","8C","D2",30,"6E","ED","B3",51,"F","4E",10,"F2","AC","2F",71,93,"CD",11,"4F","AD","F3",70,"2E","CC",92,"D3","8D","6F",31,"B2","EC","E",50,"AF","F1",13,"4D","CE",90,72,"2C","6D",33,"D1","8F","C",52,"B0","EE",32,"6C","8E","D0",53,"D","EF","B1","F0","AE","4C",12,91,"CF","2D",73,"CA",94,76,28,"AB","F5",17,49,8,56,"B4","EA",69,37,"D5","8B",57,9,"EB","B5",36,68,"8A","D4",95,"CB",29,77,"F4","AA",48,16,"E9","B7",55,"B",88,"D6",34,"6A","2B",75,97,"C9","4A",14,"F6","A8",74,"2A","C8",96,15,"4B","A9","F7","B6","FC","A",54,"D7",89,"6B",35]
[{"$f":"HEX2DEC(A40)","v":0},{"$f":"HEX2DEC(B40)","v":94},188,226,97,63,221,131,194,156,126,32,163,253,31,65,157,195,33,127,252,162,64,30,95,1,227,189,62,96,130,220,35,125,159,193,66,28,254,160,225,191,93,3,128,222,60,98,190,224,2,92,223,129,99,61,124,34,192,158,29,67,161,255,70,{"$f":"HEX2DEC(BN40)","v":24},250,164,39,121,155,197,132,218,56,102,229,187,89,7,219,133,103,57,186,228,6,88,25,71,165,251,120,38,196,154,101,59,217,135,4,90,184,230,167,249,27,69,198,152,122,36,248,166,68,26,153,199,37,123,58,100,134,216,91,5,231,185,140,{"$f":"HEX2DEC(DZ40)","v":210},48,110,237,179,81,15,78,16,242,172,47,113,147,205,17,79,173,243,112,46,204,146,211,141,111,49,178,236,14,80,175,241,19,77,206,144,114,44,109,51,209,143,12,82,176,238,50,108,142,208,83,13,239,177,240,174,76,18,145,207,45,115,202,{"$f":"HEX2DEC(GL40)","v":148},118,40,171,245,23,73,8,86,180,234,105,55,213,139,87,9,235,181,54,104,138,212,149,203,41,119,244,170,72,22,233,183,85,11,136,214,52,106,43,117,151,201,74,20,246,168,116,42,200,150,21,75,169,247,182,252,10,84,215,137,107,53]
[]
[0,0,{"$f":"HEX2DEC(B43)","v":0}]
[{"$f":"A43+1","v":1},"5E",94]
[2,"BC",188]
[3,"E2",226]
[4,61,97]
[5,"3F",63]
[6,"DD",221]
[7,83,131]
[8,"C2",194]
[9,"9C",156]
[10,"7E",126]
[11,20,32]
[12,"A3",163]
[13,"FD",253]
[14,"1F",31]
[15,41,65]
[16,"9D",157]
[17,"C3",195]
[18,21,33]
[19,"7F",127]
[20,"FC",252]
[21,"A2",162]
[22,40,64]
[23,"1E",30]
[24,"5F",95]
[25,1,1]
[26,"E3",227]
[27,"BD",189]
[28,"3E",62]
[29,60,96]
[30,82,130]
[31,"DC",220]
[32,23,35]
[33,"7D",125]
[34,"9F",159]
[35,"C1",193]
[36,42,66]
[37,"1C",28]
[38,"FE",254]
[39,"A0",160]
[40,"E1",225]
[41,"BF",191]
[42,"5D",93]
[43,3,3]
[44,80,128]
[45,"DE",222]
[46,"3C",60]
[47,62,98]
[48,"BE",190]
[49,"E0",224]
[50,2,2]
[51,"5C",92]
[52,"DF",223]
[53,81,129]
[54,63,99]
[55,"3D",61]
[56,"7C",124]
[57,22,34]
[58,"C0",192]
[59,"9E",158]
[60,"1D",29]
[61,43,67]
[62,"A1",161]
[63,"FF",255]
[64,46,{"$f":"HEX2DEC(B107)","v":70}]
[{"$f":"A107+1","v":65},18,24]
[66,"FA",250]
[67,"A4",164]
[68,27,39]
[69,79,121]
[70,"9B",155]
[71,"C5",197]
[72,84,132]
[73,"DA",218]
[74,38,56]
[75,66,102]
[76,"E5",229]
[77,"BB",187]
[78,59,89]
[79,7,7]
[80,"DB",219]
[81,85,133]
[82,67,103]
[83,39,57]
[84,"BA",186]
[85,"E4",228]
[86,6,6]
[87,58,88]
[88,19,25]
[89,47,71]
[90,"A5",165]
[91,"FB",251]
[92,78,120]
[93,26,38]
[94,"C4",196]
[95,"9A",154]
[96,65,101]
[97,"3B",59]
[98,"D9",217]
[99,87,135]
[100,4,4]
[101,"5A",90]
[102,"B8",184]
[103,"E6",230]
[104,"A7",167]
[105,"F9",249]
[106,"1B",27]
[107,45,69]
[108,"C6",198]
[109,98,152]
[110,"7A",122]
[111,24,36]
[112,"F8",248]
[113,"A6",166]
[114,44,68]
[115,"1A",26]
[116,99,153]
[117,"C7",199]
[118,25,37]
[119,"7B",123]
[120,"3A",58]
[121,64,100]
[122,86,134]
[123,"D8",216]
[124,"5B",91]
[125,5,5]
[126,"E7",231]
[127,"B9",185]
[128,"8C",{"$f":"HEX2DEC(B171)","v":140}]
[{"$f":"A171+1","v":129},"D2",210]
[130,30,48]
[131,"6E",110]
[132,"ED",237]
[133,"B3",179]
[134,51,81]
[135,"F",15]
[136,"4E",78]
[137,10,16]
[138,"F2",242]
[139,"AC",172]
[140,"2F",47]
[141,71,113]
[142,93,147]
[143,"CD",205]
[144,11,17]
[145,"4F",79]
[146,"AD",173]
[147,"F3",243]
[148,70,112]
[149,"2E",46]
[150,"CC",204]
[151,92,146]
[152,"D3",211]
[153,"8D",141]
[154,"6F",111]
[155,31,49]
[156,"B2",178]
[157,"EC",236]
[158,"E",14]
[159,50,80]
[160,"AF",175]
[161,"F1",241]
[162,13,19]
[163,"4D",77]
[164,"CE",206]
[165,90,144]
[166,72,114]
[167,"2C",44]
[168,"6D",109]
[169,33,51]
[170,"D1",209]
[171,"8F",143]
[172,"C",12]
[173,52,82]
[174,"B0",176]
[175,"EE",238]
[176,32,50]
[177,"6C",108]
[178,"8E",142]
[179,"D0",208]
[180,53,83]
[181,"D",13]
[182,"EF",239]
[183,"B1",177]
[184,"F0",240]
[185,"AE",174]
[186,"4C",76]
[187,12,18]
[188,91,145]
[189,"CF",207]
[190,"2D",45]
[191,73,115]
[192,"CA",{"$f":"HEX2DEC(B235)","v":202}]
[{"$f":"A235+1","v":193},94,148]
[194,76,118]
[195,28,40]
[196,"AB",171]
[197,"F5",245]
[198,17,23]
[199,49,73]
[200,8,8]
[201,56,86]
[202,"B4",180]
[203,"EA",234]
[204,69,105]
[205,37,55]
[206,"D5",213]
[207,"8B",139]
[208,57,87]
[209,9,9]
[210,"EB",235]
[211,"B5",181]
[212,36,54]
[213,68,104]
[214,"8A",138]
[215,"D4",212]
[216,95,149]
[217,"CB",203]
[218,29,41]
[219,77,119]
[220,"F4",244]
[221,"AA",170]
[222,48,72]
[223,16,22]
[224,"E9",233]
[225,"B7",183]
[226,55,85]
[227,"B",11]
[228,88,136]
[229,"D6",214]
[230,34,52]
[231,"6A",106]
[232,"2B",43]
[233,75,117]
[234,97,151]
[235,"C9",201]
[236,"4A",74]
[237,14,20]
[238,"F6",246]
[239,"A8",168]
[240,74,116]
[241,"2A",42]
[242,"C8",200]
[243,96,150]
[244,15,21]
[245,"4B",75]
[246,"A9",169]
[247,"F7",247]
[248,"B6",182]
[249,"FC",252]
[250,"A",10]
[251,54,84]
[252,"D7",215]
[253,89,137]
[254,"6B",107]
[255,35,53]

{"sheet":"команды управления","index":1,"n_rows":48,"n_cols":31,"rows_kept":48,"cut":false,"hidden":false,"merged":[[35,0,37,0],[39,0,41,0],[20,0,20,21],[15,0,15,11],[10,0,10,13],[45,0,55,0],[6,0,8,0],[2,0,4,0],[11,0,13,0],[16,0,18,0],[21,0,23,0],[25,0,25,21],[27,0,29,0],[31,0,33,0],[31,10,33,27],[27,9,29,12]]}
[]
[null,null,null,null,null,null,null,null,null,null,109]
["Широковещательная команда управление разделами включить\n(номер раздела 6 байт, вкл откл 9 байт)",null,0,9,0,43,16,5,0,0,110]
[null,"Расчет CRC8",{"$f":"MyXor(C3,0)","v":0},{"$f":"MyXor(D3,VLOOKUP(C4,'Таблица CRC'!$A$43:$C$298,3,FALSE))","v":9},{"$f":"MyXor(E3,VLOOKUP(D4,'Таблица CRC'!$A$43:$C$298,3,FALSE))","v":156},{"$f":"MyXor(F3,VLOOKUP(E4,'Таблица CRC'!$A$43:$C$298,3,FALSE))","v":153},{"$f":"MyXor(G3,VLOOKUP(F4,'Таблица CRC'!$A$43:$C$298,3,FALSE))","v":157},{"$f":"MyXor(H3,VLOOKUP(G4,'Таблица CRC'!$A$43:$C$298,3,FALSE))","v":233},{"$f":"MyXor(I3,VLOOKUP(H4,'Таблица CRC'!$A$43:$C$298,3,FALSE))","v":117},{"$f":"MyXor(J3,VLOOKUP(I4,'Таблица CRC'!$A$43:$C$298,3,FALSE))","v":199},{"$f":"MyXor(K3,VLOOKUP(J4,'Таблица CRC'!$A$43:$C$298,3,FALSE))","v":39},{"$f":"MyXor(L3,VLOOKUP(K4,'Таблица CRC'!$A$43:$C$298,3,FALSE))","v":160}]
[null,{"$f":"CONCATENATE(C5,\" \",D5,\" \",E5,\" \",F5,\" \",G5,\" \",H5,\" \",I5,\" \",J5,\" \",K5,\" \",L5,\" \",M5,\" \",N5)","v":"00 09 00 2B 10 05 00 00 6E A0  "},{"$f":"DEC2HEX(C3,2)","v":"00"},{"$f":"DEC2HEX(D3,2)","v":"09"},"00","2B","10","05","00","00","6E",{"$f":"DEC2HEX(L4,2)","v":"A0"}]
[]
["Широковещательная команда управление разделами индикации\n(номер раздела 6 байт, 9 байт доп.индикация )",null,0,9,1,43,16,44,0,16,23]
[null,"Расчет CRC8",{"$f":"MyXor(C7,0)","v":0},{"$f":"MyXor(D7,VLOOKUP(C8,'Таблица CRC'!$A$43:$C$298,3,FALSE))","v":9},{"$f":"MyXor(E7,VLOOKUP(D8,'Таблица CRC'!$A$43:$C$298,3,FALSE))","v":157},{"$f":"MyXor(F7,VLOOKUP(E8,'Таблица CRC'!$A$43:$C$298,3,FALSE))","v":199},{"$f":"MyXor(G7,VLOOKUP(F8,'Таблица CRC'!$A$43:$C$298,3,FALSE))","v":89},{"$f":"MyXor(H7,VLOOKUP(G8,'Таблица CRC'!$A$43:$C$298,3,FALSE))","v":107},{"$f":"MyXor(I7,VLOOKUP(H8,'Таблица CRC'!$A$43:$C$298,3,FALSE))","v":69},{"$f":"MyXor(J7,VLOOKUP(I8,'Таблица CRC'!$A$43:$C$298,3,FALSE))","v":105},{"$f":"MyXor(K7,VLOOKUP(J8,'Таблица CRC'!$A$43:$C$298,3,FALSE))","v":238},{"$f":"MyXor(L7,VLOOKUP(K8,'Таблица CRC'!$A$43:$C$298,3,FALSE))","v":246}]
[null,{"$f":"CONCATENATE(C9,\" \",D9,\" \",E9,\" \",F9,\" \",G9,\" \",H9,\" \",I9,\" \",J9,\" \",K9,\" \",L9,\" \",M9,\" \",N9)","v":"00 09 01 2B 10 2C 00 10 17 F6  "},{"$f":"DEC2HEX(C7,2)","v":"00"},{"$f":"DEC2HEX(D7,2)","v":"09"},"01","2B","10","2C","00","10","17",{"$f":"DEC2HEX(L8,2)","v":"F6"}]
[]
["ВКЛЮЧИТЬ ИНДИКАТОР  ( ЗАВИСИТ ОТ ПРОГРАМИРОВАНИЯ БКИ или БИ)"]
["включить выключить  диод на БИ БКИ\n(номер диода указывается в 6 байте,  8 байт=0 вкл, (8байт дополнит индикация)",null,100,11,83,43,13,54,0,0,0,0,0]
[null,"Расчет CRC8",{"$f":"MyXor(C12,0)","v":100},{"$f":"MyXor(D12,VLOOKUP(C13,'Таблица CRC'!$A$43:$C$298,3,FALSE))","v":15},{"$f":"MyXor(E12,VLOOKUP(D13,'Таблица CRC'!$A$43:$C$298,3,FALSE))","v":18},{"$f":"MyXor(F12,VLOOKUP(E13,'Таблица CRC'!$A$43:$C$298,3,FALSE))","v":10},{"$f":"MyXor(G12,VLOOKUP(F13,'Таблица CRC'!$A$43:$C$298,3,FALSE))","v":115},{"$f":"MyXor(H12,VLOOKUP(G13,'Таблица CRC'!$A$43:$C$298,3,FALSE))","v":44},{"$f":"MyXor(I12,VLOOKUP(H13,'Таблица CRC'!$A$43:$C$298,3,FALSE))","v":128},{"$f":"MyXor(J12,VLOOKUP(I13,'Таблица CRC'!$A$43:$C$298,3,FALSE))","v":140},{"$f":"MyXor(K12,VLOOKUP(J13,'Таблица CRC'!$A$43:$C$298,3,FALSE))","v":47},{"$f":"MyXor(L12,VLOOKUP(K13,'Таблица CRC'!$A$43:$C$298,3,FALSE))","v":98},{"$f":"MyXor(M12,VLOOKUP(L13,'Таблица CRC'!$A$43:$C$298,3,FALSE))","v":217},{"$f":"MyXor(N12,VLOOKUP(M13,'Таблица CRC'!$A$43:$C$298,3,FALSE))","v":203}]
[null,{"$f":"CONCATENATE(C14,\" \",D14,\" \",E14,\" \",F14,\" \",G14,\" \",H14,\" \",I14,\" \",J14,\" \",K14,\" \",L14,\" \",M14,\" \",N14)","v":"64 0B 53 2B 0D 36 00 00 00 00 00 CB"},{"$f":"DEC2HEX(C12,2)","v":"64"},{"$f":"DEC2HEX(D12,2)","v":"0B"},"53","2B","0D","36","00","00","00","00","00",{"$f":"DEC2HEX(N13,2)","v":"CB"}]
[]
["ВКЛЮЧИТЬ ИНДИКАТОР ОБЫЧНЫЙ РЕЖИМ ( ЗАВИСИТ ОТ ПРОГРАМИРОВАНИЯ БКИ или БИ)"]
["Вкл выкл диод 9 байт 109 вкл, любое другое выкл\n номер диода 6 байт ",null,100,9,0,43,16,60,0,0,109]
[null,"Расчет CRC8",{"$f":"MyXor(C17,0)","v":100},{"$f":"MyXor(D17,VLOOKUP(C18,'Таблица CRC'!$A$43:$C$298,3,FALSE))","v":13},{"$f":"MyXor(E17,VLOOKUP(D18,'Таблица CRC'!$A$43:$C$298,3,FALSE))","v":253},{"$f":"MyXor(F17,VLOOKUP(E18,'Таблица CRC'!$A$43:$C$298,3,FALSE))","v":162},{"$f":"MyXor(G17,VLOOKUP(F18,'Таблица CRC'!$A$43:$C$298,3,FALSE))","v":3},{"$f":"MyXor(H17,VLOOKUP(G18,'Таблица CRC'!$A$43:$C$298,3,FALSE))","v":222},{"$f":"MyXor(I17,VLOOKUP(H18,'Таблица CRC'!$A$43:$C$298,3,FALSE))","v":72},{"$f":"MyXor(J17,VLOOKUP(I18,'Таблица CRC'!$A$43:$C$298,3,FALSE))","v":132},{"$f":"MyXor(K17,VLOOKUP(J18,'Таблица CRC'!$A$43:$C$298,3,FALSE))","v":128},{"$f":"MyXor(L17,VLOOKUP(K18,'Таблица CRC'!$A$43:$C$298,3,FALSE))","v":140}]
[null,{"$f":"CONCATENATE(C19,\" \",D19,\" \",E19,\" \",F19,\" \",G19,\" \",H19,\" \",I19,\" \",J19,\" \",K19,\" \",L19,\" \",M19,\" \",N19)","v":"64 09 00 2B 10 3C 00 00 6D 8C  "},{"$f":"DEC2HEX(C17,2)","v":"64"},{"$f":"DEC2HEX(D17,2)","v":"09"},"00","2B","10","3C","00","00",{"$f":"DEC2HEX(K17,2)","v":"6D"},{"$f":"DEC2HEX(L18,2)","v":"8C"}]
[]
["ВКЛЮЧИТЬ ИНДИКАТОР РАСШИРЕННЫЙ РЕЖИМ  ( ЗАВИСИТ ОТ ПРОГРАМИРОВАНИЯ БКИ или БИ)"]
[" диод  (шестой байт № диода)18 байт, (зависит от программирования БКИ) 2,3,4,5, 23 моргает зел, 24 горит красн,",null,100,19,0,43,17,1,1,0,17,5,239,16,16,254,254,254,254,20,24]
[null,"Расчет CRC8",{"$f":"MyXor(C22,0)","v":100},{"$f":"MyXor(D22,VLOOKUP(C23,'Таблица CRC'!$A$43:$C$298,3,FALSE))","v":23},{"$f":"MyXor(E22,VLOOKUP(D23,'Таблица CRC'!$A$43:$C$298,3,FALSE))","v":30},{"$f":"MyXor(F22,VLOOKUP(E23,'Таблица CRC'!$A$43:$C$298,3,FALSE))","v":169},{"$f":"MyXor(G22,VLOOKUP(F23,'Таблица CRC'!$A$43:$C$298,3,FALSE))","v":34},{"$f":"MyXor(H22,VLOOKUP(G23,'Таблица CRC'!$A$43:$C$298,3,FALSE))","v":158},{"$f":"MyXor(I22,VLOOKUP(H23,'Таблица CRC'!$A$43:$C$298,3,FALSE))","v":15},{"$f":"MyXor(J22,VLOOKUP(I23,'Таблица CRC'!$A$43:$C$298,3,FALSE))","v":65},{"$f":"MyXor(K22,VLOOKUP(J23,'Таблица CRC'!$A$43:$C$298,3,FALSE))","v":9},{"$f":"MyXor(L22,VLOOKUP(K23,'Таблица CRC'!$A$43:$C$298,3,FALSE))","v":153},{"$f":"MyXor(M22,VLOOKUP(L23,'Таблица CRC'!$A$43:$C$298,3,FALSE))","v":98},{"$f":"MyXor(N22,VLOOKUP(M23,'Таблица CRC'!$A$43:$C$298,3,FALSE))","v":201},{"$f":"MyXor(O22,VLOOKUP(N23,'Таблица CRC'!$A$43:$C$298,3,FALSE))","v":70},{"$f":"MyXor(P22,VLOOKUP(O23,'Таблица CRC'!$A$43:$C$298,3,FALSE))","v":101},{"$f":"MyXor(Q22,VLOOKUP(P23,'Таблица CRC'!$A$43:$C$298,3,FALSE))","v":164},{"$f":"MyXor(R22,VLOOKUP(Q23,'Таблица CRC'!$A$43:$C$298,3,FALSE))","v":48},{"$f":"MyXor(S22,VLOOKUP(R23,'Таблица CRC'!$A$43:$C$298,3,FALSE))","v":64},{"$f":"MyXor(T22,VLOOKUP(S23,'Таблица CRC'!$A$43:$C$298,3,FALSE))","v":82},{"$f":"MyXor(U22,VLOOKUP(T23,'Таблица CRC'!$A$43:$C$298,3,FALSE))","v":127},{"$f":"MyXor(V22,VLOOKUP(U23,'Таблица CRC'!$A$43:$C$298,3,FALSE))","v":185}]
[null,{"$f":"CONCATENATE(C24,\" \",D24,\" \",E24,\" \",F24,\" \",G24,\" \",H24,\" \",I24,\" \",J24,\" \",K24,\" \",L24,\" \",M24,\" \",N24,\" \",O24,\" \",P24,\" \",Q24,\" \",R24,\" \",S24,\" \",T24,\" \",U24,\" \",V24)","v":"64 13 00 2B 11 01 01 00 11 05 EF 10 10 FE FE FE FE 14 18 B9"},{"$f":"DEC2HEX(C22,2)","v":"64"},{"$f":"DEC2HEX(D22,2)","v":"13"},"00","2B","11","01","01","00",{"$f":"DEC2HEX(K22,2)","v":"11"},{"$f":"DEC2HEX(L22,2)","v":"05"},"EF","10","10","FE","FE","FE","FE","14","18",{"$f":"DEC2HEX(V23,2)","v":"B9"}]
[]
["ПОРЯДОК  чтения состояния С БКИ"]
["команда сброс"]
["команда опрос состояния",null,100,6,0,1,0,248,null,"нажата 3 кнопка",null,null,null,"ОТВЕТ ПРИБОРА"]
[null,"Расчет CRC8",{"$f":"MyXor(C28,0)","v":100},{"$f":"MyXor(D28,VLOOKUP(C29,'Таблица CRC'!$A$43:$C$298,3,FALSE))","v":2},{"$f":"MyXor(E28,VLOOKUP(D29,'Таблица CRC'!$A$43:$C$298,3,FALSE))","v":188},{"$f":"MyXor(F28,VLOOKUP(E29,'Таблица CRC'!$A$43:$C$298,3,FALSE))","v":144},{"$f":"MyXor(G28,VLOOKUP(F29,'Таблица CRC'!$A$43:$C$298,3,FALSE))","v":17},{"$f":"MyXor(H28,VLOOKUP(G29,'Таблица CRC'!$A$43:$C$298,3,FALSE))","v":59},{"$f":"MyXor(I28,VLOOKUP(H29,'Таблица CRC'!$A$43:$C$298,3,FALSE))","v":158},null,null,null,null,100,17,14,15,1,3,0,0,240,17,17,255,255,255,255,20,3,137]
[null,{"$f":"CONCATENATE(C30,\" \",D30,\" \",E30,\" \",F30,\" \",G30,\" \",H30,\" \",I30,\" \",J30,\" \",K30,\" \",L30,\" \",M30,\" \",N30)","v":"64 06 00 01 00 F8 9E     "},{"$f":"DEC2HEX(C28,2)","v":"64"},{"$f":"DEC2HEX(D28,2)","v":"06"},"00","01","00","F8",{"$f":"DEC2HEX(I29,2)","v":"9E"},null,null,null,null,null,"номер нажатой кнопки в 6 и 17 байтах команды от БКИ"]
[]
["команда данные считаны",null,100,6,0,3,0,0,null,null,"На эту команду нет ответа прибора"]
[null,"Расчет CRC8",{"$f":"MyXor(C32,0)","v":100},{"$f":"MyXor(D32,VLOOKUP(C33,'Таблица CRC'!$A$43:$C$298,3,FALSE))","v":2},{"$f":"MyXor(E32,VLOOKUP(D33,'Таблица CRC'!$A$43:$C$298,3,FALSE))","v":188},{"$f":"MyXor(F32,VLOOKUP(E33,'Таблица CRC'!$A$43:$C$298,3,FALSE))","v":146},{"$f":"MyXor(G32,VLOOKUP(F33,'Таблица CRC'!$A$43:$C$298,3,FALSE))","v":173},{"$f":"MyXor(H32,VLOOKUP(G33,'Таблица CRC'!$A$43:$C$298,3,FALSE))","v":82},{"$f":"MyXor(I32,VLOOKUP(H33,'Таблица CRC'!$A$43:$C$298,3,FALSE))","v":103}]
[null,{"$f":"CONCATENATE(C34,\" \",D34,\" \",E34,\" \",F34,\" \",G34,\" \",H34,\" \",I34,\" \",J34,\" \",K34,\" \",L34,\" \",M34,\" \",N34)","v":"64 06 00 03 00 00 67     "},{"$f":"DEC2HEX(C32,2)","v":"64"},{"$f":"DEC2HEX(D32,2)","v":"06"},"00","03","00","00",{"$f":"DEC2HEX(I33,2)","v":"67"}]
[]
["команда опрос состояния",null,100,6,0,1,0,248,null,null,"ОТВЕТ ПРИБОРА"]
[null,"Расчет CRC8",{"$f":"MyXor(C36,0)","v":100},{"$f":"MyXor(D36,VLOOKUP(C37,'Таблица CRC'!$A$43:$C$298,3,FALSE))","v":2},{"$f":"MyXor(E36,VLOOKUP(D37,'Таблица CRC'!$A$43:$C$298,3,FALSE))","v":188},{"$f":"MyXor(F36,VLOOKUP(E37,'Таблица CRC'!$A$43:$C$298,3,FALSE))","v":144},{"$f":"MyXor(G36,VLOOKUP(F37,'Таблица CRC'!$A$43:$C$298,3,FALSE))","v":17},{"$f":"MyXor(H36,VLOOKUP(G37,'Таблица CRC'!$A$43:$C$298,3,FALSE))","v":59},{"$f":"MyXor(I36,VLOOKUP(H37,'Таблица CRC'!$A$43:$C$298,3,FALSE))","v":158},null,"64 09 0E 07 06 00 00 00 00 1A"]
[null,{"$f":"CONCATENATE(C38,\" \",D38,\" \",E38,\" \",F38,\" \",G38,\" \",H38,\" \",I38,\" \",J38,\" \",N50,\" \",O50,\" \",P50,\" \",Q50)","v":"64 06 00 01 00 F8 9E     "},{"$f":"DEC2HEX(C36,2)","v":"64"},{"$f":"DEC2HEX(D36,2)","v":"06"},"00","01","00","F8",{"$f":"DEC2HEX(I37,2)","v":"9E"}]
[]
["команда опрос состояния",null,100,6,0,1,0,248,null,null,"ОТВЕТ ПРИБОРА",null,null,null,"При каждом последующем опросе  прибавляется 1 к 4 байту"]
[null,"Расчет CRC8",{"$f":"MyXor(C40,0)","v":100},{"$f":"MyXor(D40,VLOOKUP(C41,'Таблица CRC'!$A$43:$C$298,3,FALSE))","v":2},{"$f":"MyXor(E40,VLOOKUP(D41,'Таблица CRC'!$A$43:$C$298,3,FALSE))","v":188},{"$f":"MyXor(F40,VLOOKUP(E41,'Таблица CRC'!$A$43:$C$298,3,FALSE))","v":144},{"$f":"MyXor(G40,VLOOKUP(F41,'Таблица CRC'!$A$43:$C$298,3,FALSE))","v":17},{"$f":"MyXor(H40,VLOOKUP(G41,'Таблица CRC'!$A$43:$C$298,3,FALSE))","v":59},{"$f":"MyXor(I40,VLOOKUP(H41,'Таблица CRC'!$A$43:$C$298,3,FALSE))","v":158},null,"64 05 02 17 00 42"]
[null,{"$f":"CONCATENATE(C42,\" \",D42,\" \",E42,\" \",F42,\" \",G42,\" \",H42,\" \",I42,\" \",J42,\" \",N54,\" \",O54,\" \",P54,\" \",Q54)","v":"64 06 00 01 00 F8 9E     "},{"$f":"DEC2HEX(C40,2)","v":"64"},{"$f":"DEC2HEX(D40,2)","v":"06"},"00","01","00","F8",{"$f":"DEC2HEX(I41,2)","v":"9E"}]
[]
[]
[]
["Дополнитнльные широковещательные команды  9-й байт ",0,"норма"]
[null,2,"неисправность"]
[null,3,"тревога"]