Spreadsheet: 2b6dc2fb-257b-496d-a1a2-820527298b15
Sheet: Sheet1

Nur numerische Referenzen | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | [NAME]'s nicht funktioniert: Die Makros müssen aktiviert sein!  [NAME] es immer noch nicht funktioniert: Alt+F11 -> Visual Basic Fenster öffnet sich Im Visual Basic Fenster: Extras - Verweise wählen In der Liste "Microsoft VBScript Regular Expressions 5.5" auswählen OK Visual Basic Fenster schließen [NAME] | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20 | Unnamed: 21 | Unnamed: 22 | Unnamed: 23 | Unnamed: 24 | Unnamed: 25 | Unnamed: 26 | Unnamed: 27 | Unnamed: 28 | Unnamed: 29
 |  |  |  |  | Für mehr [NAME] nach unten kopieren
Daten für den [NAME] |  |  | Schlüssel |  | Beleg |  |  | [NAME] |  |  |  | Auszublendende Zellen
Referenz | Betrag |  | 1 nur [NAME] 2 mit Betrag |  | PZ-Feld | [NAME] |  | Referenz | Betrag | Schlüssel |  | Vorbereitung | Teil 1 | Teil 2 | Teil 3 | Teil 4 | Teil 5 | Teil 6 | Teil 7 | Rest 1 | Rest 2 | Rest 3 | Rest 4 | Rest 5 | Rest 6 | Rest 7 | Prüfziffer | [NAME] | Gültigkeit
[PHONE] | 345333,69 |  | 2 |  | 1712 | [PHONE]< |  | OK | OK | OK |  | 4734682342483453336900 | 4734682 | 3424834 | 5333690 | 0 |  |  |  | 15 | 31 | 76 | 81 | 81 | 81 | 81 | 17 | 17 | Gültig
[PHONE] | 345334,69 |  | 1 |  | 0411 |  |  | OK | OK | OK |  | 47346823424800 | 4734682 | 3424800 |  |  |  |  |  | 15 | 94 | 94 | 94 | 94 | 94 | 94 | 4 | 04 | Gültig
[PHONE] 2322 | 34533,569 |  | 2 |  | [NAME] | [NAME] |  | [NAME], [NAME] | [NAME], [NAME] | OK |  | ERROR | ERROR |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Fehlerhaft
473468234248ABD | 345336,69 |  | 2 |  | [NAME] | [NAME] |  | [NAME], [NAME] | OK | OK |  | ERROR | ERROR |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Fehlerhaft
 | 345336,69 |  | 2 |  | [NAME] | [NAME] |  | Fehler, Länge | OK | OK |  | ERROR | ERROR |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Fehlerhaft
123456 | 345336,69 |  | 2 |  | 0212 | [PHONE]< |  | OK | OK | OK |  | 1234563453366900 | 1234563 | 4533669 | 00 |  |  |  |  | 44 | 32 | 96 | 96 | 96 | 96 | 96 | 2 | 02 | Gültig
12345678901234567890123 | 345336,69 |  | 2 |  | 7712 | [PHONE]< |  | OK | OK | OK |  | 123456789012345678901233453366900 | 1234567 | 8901234 | 5678901 | 2334533 | 66900 |  |  | 48 | 88 | 31 | 62 | 21 | 21 | 21 | 77 | 77 | Gültig
12345678901234567890123456789012345 | 345336,69 |  | 3 |  | [NAME] | [NAME] |  | OK | OK | [NAME], Wert |  | ERROR | ERROR |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Fehlerhaft
123456789012345678901234567890123456 | 345336,69 |  | 2 |  | [NAME] | [NAME] |  | Fehler, Länge | OK | OK |  | ERROR | ERROR |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Fehlerhaft
[PHONE] | 345337 |  | 2 |  | 9112 | [PHONE]< |  | OK | OK | OK |  | 4734682342483453370000 | 4734682 | 3424834 | 5337000 | 0 |  |  |  | 15 | 31 | 88 | 7 | 7 | 7 | 7 | 91 | 91 | Gültig
[PHONE] | 345337, |  | 0 |  | [NAME] | [NAME] |  | OK | [NAME], [NAME] | [NAME], Wert |  | ERROR | ERROR |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Fehlerhaft
[PHONE] | 345337,0 |  | 2 |  | 9112 | [PHONE]< |  | OK | OK | OK |  | 4734682342483453370000 | 4734682 | 3424834 | 5337000 | 0 |  |  |  | 15 | 31 | 88 | 7 | 7 | 7 | 7 | 91 | 91 | Gültig
[PHONE] | 345337,00 |  | 2 |  | 9112 | [PHONE]< |  | OK | OK | OK |  | 4734682342483453370000 | 4734682 | 3424834 | 5337000 | 0 |  |  |  | 15 | 31 | 88 | 7 | 7 | 7 | 7 | 91 | 91 | Gültig
[PHONE] | 345337,000 |  | 2 |  | [NAME] | [NAME] |  | OK | [NAME], [NAME] | OK |  | ERROR | ERROR |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Fehlerhaft
[PHONE] | 345337.00 |  | 2 |  | [NAME] | [NAME] |  | OK | [NAME], [NAME] | OK |  | ERROR | ERROR |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Fehlerhaft
[PHONE] | 0,00 |  | 1 |  | 0411 |  |  | OK | OK | OK |  | 47346823424800 | 4734682 | 3424800 |  |  |  |  |  | 15 | 94 | 94 | 94 | 94 | 94 | 94 | 4 | 04 | Gültig
[PHONE] | 0,00 |  | 2 |  | [NAME] | [NAME] |  | OK | [NAME], [NAME] | OK |  | ERROR | ERROR |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Fehlerhaft
[PHONE] | 999999999,99 |  | 1 |  | 0411 |  |  | OK | OK | OK |  | 47346823424800 | 4734682 | 3424800 |  |  |  |  |  | 15 | 94 | 94 | 94 | 94 | 94 | 94 | 4 | 04 | Gültig
[PHONE] | [PHONE] |  | 1 |  | [NAME] | [NAME] |  | OK | [NAME], [NAME] | OK |  | ERROR | ERROR |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Fehlerhaft
[PHONE] | 345341,69 |  | 3 |  | [NAME] | [NAME] |  | OK | OK | [NAME], Wert |  | ERROR | ERROR |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Fehlerhaft
[PHONE] | 345341,69 |  | 2 |  | 4212 | [PHONE]< |  | OK | OK | OK |  | 4734682342483453416900 | 4734682 | 3424834 | 5341690 | 0 |  |  |  | 15 | 31 | 25 | 56 | 56 | 56 | 56 | 42 | 42 | Gültig
[PHONE] | 345341,69 |  | 0 |  | [NAME] | [NAME] |  | OK | OK | [NAME], Wert |  | ERROR | ERROR |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Fehlerhaft