{"text_format":"3","workbook":"xls","n_sheets":1,"sheets":["Protokolldefinition"],"not_rendered":{"external_links":1},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Protokolldefinition","index":0,"n_rows":45,"n_cols":5,"rows_kept":45,"merged":[[0,0,0,9],[1,0,1,9],[2,0,2,9],[3,0,3,9],[4,0,4,9],[5,0,5,9],[6,2,6,3],[6,4,6,9],[7,2,7,3],[7,4,7,9],[8,2,8,3],[8,4,8,9],[9,2,9,3],[9,4,9,9],[10,2,10,3],[10,4,10,9],[11,2,11,3],[11,4,11,9],[12,2,12,3],[12,4,12,9],[13,2,13,9],[14,2,14,9],[15,2,15,9],[16,2,16,9],[17,2,17,9],[18,2,18,9],[19,2,19,9],[20,2,20,9],[21,2,21,9],[22,2,22,9],[23,2,23,9],[24,2,24,9],[25,2,25,9],[26,2,26,9],[27,2,27,9],[28,2,28,9],[29,2,29,9],[30,2,30,9],[31,2,31,9],[32,2,32,9],[33,2,33,9],[34,2,34,9],[35,2,35,9],[36,2,36,9],[37,2,37,9],[38,2,38,9],[39,2,39,9],[40,2,40,9],[41,2,41,9],[42,2,42,9],[43,2,43,9],[44,2,44,9],[45,2,45,9]],"flags":["formulas_cached_only"]}
["GC-Protokoll"]
[]
["Erstellt von: MHe"]
["Erstellt am: 09.09.2013"]
[]
["Telegrammaufbau:"]
[null,"STX","{ Startzeichen",null,"01 Byte"]
[null,"Adr","{ Geräteadresse",null,"01 Byte"]
[null,"Typ","{ Telegrammtyp",null,"01 Byte"]
[null,"Data","{ Telegrammdaten",null,"04 Byte | 6 Byte | 42 Byte | 12 Byte | 7 Byte"]
[null,"ETX","{ Endezeichen",null,"01 Byte"]
[null,"CRC","{ Prüfsumme",null,"02 Byte"]
[{"$nulls":4},"Gesamt: 10 Byte | 12 Byte | 48 Byte | 18 Byte | 13 Byte"]
[]
["- STX:","0x02","{ -"]
[]
["- Adr:\n","0x00\n'NUL'","{ Alle GC9300-Gateways\n"]
[null,"0x41 - 0x5A\n'A' - 'Z'","{ Einzelnes GC9300-Gateway\n"]
[null,"0x5F\n'_'","{ GC9300-Controller\n"]
[]
["- Typ:\n","0x00\nPollingRequest","{ Erfassen aller vorhandenen GC9300-Gateways\n"]
[null,"0x01\nMtxData","{ Senden der aktuellen Matrixdaten an die einzelnen GC9300-Gateways\n"]
[null,"0x02\nErrorInfo","{ Senden der eigenen Fehlerstati (Alarm, Warnung, Hinweis) ann alle einzelnen GC9300-Gateways\n{ Senden der eigenen Fehlerstati (Alarm, Warnung, Hinweis) an den GC9300-Controller"]
[null,"0x03\nPollingAnswer","{ Reaktion auf Polling\n"]
[]
["- Data:"]
["  - PollingRequest:","-","{ Keine Daten "]
[]
["- Data:"]
["  - MtxData:","0x00 - 0x27","{ Index der GC-Protokoll-Daten-Liste [40] 1 Byte"]
[null,"0x00 - 0x02","{ Typ des Datenelements (0x01 == short, 0x02 == float, 0x03 == unicodestring[20]) 1 Byte"]
[null,"...","{ Wert des Datenelements 2 Byte | 4 Byte | 40 Byte"]
[]
["- Data:"]
["  - ErrorInfo:","0x0000 - 0xFFFF","{ Fehlernummer 2 Byte"]
[null,"0x00 - 0x01","{ Fehler kommt / geht (0x00 == geht, 0x01 == kommt) 1 Byte"]
[null,"0x00 - 0x05","{ Stream (0x00 == S1, 0x01 == S2, 0x02 == S3, 0x03 == S4, 0x04 == Ref, 0x05 == Kal) 1 Byte"]
[null,"...","{ Zeitstempel 8 Byte"]
[]
["- Data:"]
["  - PollingAnswer:\n","0x41 - 0x5A\n'A' - 'Z'","{ Eigene GC9300-Gateway-Adresse 1 Byte\n"]
[]
["- ETX:","0x03","{ -"]
[]
["- CRC:","CRC","{ CRC16, wie bei Modbusprotokoll"]