{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Tabelle3","Tabelle4","Tabelle2","Tabelle1"],"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":"Tabelle3","index":0,"n_rows":35,"n_cols":7,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
["Sendungsnummer",null,null,"Barcode",null,null,"Leitgebiet"]
["00035005588",null,null,{"$f":"Code128(A2)","v":"Ò #R%ZÍ8 Ó"},null,null,"SOS-001"]
["00035005590",null,null,{"$f":"Code128(A3)","v":"Ò #R%[Í0TÓ"},null,null,"POZ-001"]
["00035005592",null,null,{"$f":"Code128(A4)","v":"Ò #R%[Í2bÓ"},null,null,"ZPM-001"]
["00035005593",null,null,{"$f":"Code128(A5)","v":"Ò #R%[Í3iÓ"},null,null,"ERF-001"]
["00035005594",null,null,{"$f":"Code128(A6)","v":"Ò #R%[Í4pÓ"},null,null,"WLQ-001"]
["00035005595",null,null,{"$f":"Code128(A7)","v":"Ò #R%[Í5wÓ"},null,null,"MUC-001"]
["00035005596",null,null,{"$f":"Code128(A8)","v":"Ò #R%[Í6~Ó"},null,null,"PAR-001"]
["00035005599",null,null,{"$f":"Code128(A9)","v":"Ò #R%[Í9,Ó"},null,null,"KHX-999"]
["00035005604",null,null,{"$f":"Code128(A10)","v":"Ò #R%\\Í4uÓ"},null,null,"ERF-001"]
["00035005606",null,null,{"$f":"Code128(A11)","v":"Ò #R%\\Í6ÌÓ"},null,null,"POZ-001"]
["00035005607",null,null,{"$f":"Code128(A12)","v":"Ò #R%\\Í7#Ó"},null,null,"IRU-001"]
["00035005608",null,null,{"$f":"Code128(A13)","v":"Ò #R%\\Í8*Ó"},null,null,"ZPM-001"]
["00035048243",null,null,{"$f":"Code128(A14)","v":"Ò #RP8Í3fÓ"},null,null,"WAW-001"]
[null,null,null,{"$f":"Code128(A15)","v":""}]
[null,null,null,{"$f":"Code128(A16)","v":""}]
[null,null,null,{"$f":"Code128(A17)","v":""}]
[null,null,null,{"$f":"Code128(A18)","v":""}]
[null,null,null,{"$f":"Code128(A19)","v":""}]
[null,null,null,{"$f":"Code128(A20)","v":""}]
[null,null,null,{"$f":"Code128(A21)","v":""}]
[null,null,null,{"$f":"Code128(A22)","v":""}]
[null,null,null,{"$f":"Code128(A23)","v":""}]
[null,null,null,{"$f":"Code128(A24)","v":""}]
[null,null,null,{"$f":"Code128(A25)","v":""}]
[null,null,null,{"$f":"Code128(A26)","v":""}]
[null,null,null,{"$f":"Code128(A27)","v":""}]
[null,null,null,{"$f":"Code128(A28)","v":""}]
[null,null,null,{"$f":"Code128(A29)","v":""}]
[null,null,null,{"$f":"Code128(A30)","v":""}]
[null,null,null,{"$f":"Code128(A31)","v":""}]
[null,null,null,{"$f":"Code128(A32)","v":""}]
[null,null,null,{"$f":"Code128(A33)","v":""}]
[null,null,null,{"$f":"Code128(A34)","v":""}]
[null,null,null,{"$f":"Code128(A35)","v":""}]

{"sheet":"Tabelle4","index":1,"n_rows":349,"n_cols":7,"rows_kept":349,"cut":false,"hidden":false,"merged":[]}
["00035005588",null,null,{"$f":"Code128(A1)","v":"Ò #R%ZÍ8 Ó"},null,null,"SOS-001"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["00035005590",null,null,{"$f":"Code128(A30)","v":"Ò #R%[Í0TÓ"},null,null,"POZ-001"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["00035005592",null,null,{"$f":"Code128(A59)","v":"Ò #R%[Í2bÓ"},null,null,"ZPM-001"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["00035005593",null,null,{"$f":"Code128(A88)","v":"Ò #R%[Í3iÓ"},null,null,"ERF-001"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["00035005594",null,null,{"$f":"Code128(A117)","v":"Ò #R%[Í4pÓ"},null,null,"WLQ-001"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["00035005595",null,null,{"$f":"Code128(A146)","v":"Ò #R%[Í5wÓ"},null,null,"MUC-001"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["00035005596",null,null,{"$f":"Code128(A175)","v":"Ò #R%[Í6~Ó"},null,null,"PAR-001"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["00035005599",null,null,{"$f":"Code128(A204)","v":"Ò #R%[Í9,Ó"},null,null,"KHX-999"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["00035005604",null,null,{"$f":"Code128(A233)","v":"Ò #R%\\Í4uÓ"},null,null,"ERF-001"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["00035005606",null,null,{"$f":"Code128(A262)","v":"Ò #R%\\Í6ÌÓ"},null,null,"POZ-001"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["00035005607",null,null,{"$f":"Code128(A291)","v":"Ò #R%\\Í7#Ó"},null,null,"IRU-001"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["00035005608",null,null,{"$f":"Code128(A320)","v":"Ò #R%\\Í8*Ó"},null,null,"ZPM-001"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["00035048243",null,null,{"$f":"Code128(A349)","v":"Ò #RP8Í3fÓ"},null,null,"WAW-001"]

{"sheet":"Tabelle2","index":2,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["Public Function Code128$(chaine$)\n  'V 2.0.0\n  'Paramètres : une chaine\n  'Parameters : a string\n  'Retour : * une chaine qui, affichée avec la police CODE128.TTF, donne le code barre\n  '         * une chaine vide si paramètre fourni incorrect\n  'Return : * a string which give the bar code when it is dispayed with CODE128.TTF font\n  '         * an empty string if the supplied parameter is no good\n  Dim i%, checksum&, mini%, dummy%, tableB As Boolean\n  Code128$ = \"\"\n  If Len(chaine$) > 0 Then\n  'Vérifier si caractères valides\n  'Check for valid characters\n    For i% = 1 To Len(chaine$)\n      Select Case Asc(Mid$(chaine$, i%, 1))\n      Case 32 To 126, 203\n      Case Else\n        i% = 0\n        Exit For\n      End Select\n    Next\n    'Calculer la chaine de code en optimisant l'usage des tables B et C\n    'Calculation of the code string with optimized use of tables B and C\n    Code128$ = \"\"\n    tableB = True\n    If i% > 0 Then\n      i% = 1 'i% devient l'index sur la chaine / i% become the string index\n      Do While i% <= Len(chaine$)\n        If tableB Then\n          'Voir si intéressant de passer en table C / See if interesting to switch to table C\n          'Oui pour 4 chiffres au début ou à la fin, sinon pour 6 chiffres / yes for 4 digits at start or end, else if 6 digits\n          mini% = IIf(i% = 1 Or i% + 3 = Len(chaine$), 4, 6)\n          GoSub testnum\n          If mini% < 0 Then 'Choix table C / Choice of table C\n            If i% = 1 Then 'Débuter sur table C / Starting with table C\n              Code128$ = Chr$(210)\n            Else 'Commuter sur table C / Switch to table C\n              Code128$ = Code128$ & Chr$(204)\n            End If\n            tableB = False\n          Else\n            If i% = 1 Then Code128$ = Chr$(209) 'Débuter sur table B / Starting with table B\n          End If\n        End If\n        If Not tableB Then\n          'On est sur la table C, essayer de traiter 2 chiffres / We are on table C, try to process 2 digits\n          mini% = 2\n          GoSub testnum\n          If mini% < 0 Then 'OK pour 2 chiffres, les traiter / OK for 2 digits, process it\n            dummy% = Val(Mid$(chaine$, i%, 2))\n            dummy% = IIf(dummy% < 95, dummy% + 32, dummy% + 105)\n            Code128$ = Code128$ & Chr$(dummy%)\n            i% = i% + 2\n          Else 'On n'a pas 2 chiffres, repasser en table B / We haven't 2 digits, switch to table B\n            Code128$ = Code128$ & Chr$(205)\n            tableB = True\n          End If\n        End If\n        If tableB Then\n          'Traiter 1 caractère en table B / Process 1 digit with table B\n          Code128$ = Code128$ & Mid$(chaine$, i%, 1)\n          i% = i% + 1\n        End If\n      Loop\n      'Calcul de la clé de contrôle / Calculation of the checksum\n      For i% = 1 To Len(Code128$)\n        dummy% = Asc(Mid$(Code128$, i%, 1))\n        dummy% = IIf(dummy% < 127, dummy% - 32, dummy% - 105)\n        If i% = 1 Then checksum& = dummy%\n        checksum& = (checksum& + (i% - 1) * dummy%) Mod 103\n      Next\n      'Calcul du code ASCII de la clé / Calculation of the checksum ASCII code\n      checksum& = IIf(checksum& < 95, checksum& + 32, checksum& + 105)\n      'Ajout de la clé et du STOP / Add the checksum and the STOP\n      Code128$ = Code128$ & Chr$(checksum&) & Chr$(211)\n    End If\n  End If\n  Exit Function\ntestnum:\n  'si les mini% caractères à partir de i% sont numériques, alors mini%=0\n  'if the mini% characters from i% are numeric, then mini%=0\n  mini% = mini% - 1\n  If i% + mini% <= Len(chaine$) Then\n    Do While mini% >= 0\n      If Asc(Mid$(chaine$, i% + mini%, 1)) < 48 Or Asc(Mid$(chaine$, i% + mini%, 1)) > 57 Then Exit Do\n      mini% = mini% - 1\n    Loop\n  End If\nReturn\nEnd Function "]

{"sheet":"Tabelle1","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}