{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Start","Angebot","Rechnung","KontakteDB","DokumenteDB","ProdukteDB","AngeboteDB","RechnungenDB","PositionenDB","Admin","Kommunikation","ExcelDok"],"not_rendered":{"charts":0,"images":29,"macros":1,"external_links":0,"defined_names":20,"comments":5,"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":"Start","index":0,"n_rows":8,"n_cols":18,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
["Akt. TabellenZeile"]
["DB-Blatt","KontakteDB"]
["DB-Tabelle","KontakteDB_tbl"]
["DB-Zeile"]
["AnzahlZeilen",{"$f":"SUBTOTAL(3,Start_tbl[KontaktID])","v":1}]
[null,null,null,"KontaktID","Anrede","Vorname","Name","Mobil","E-Mail","PLZ","Ort","Adresse","Firma","Notizen","Erstellt","Geändert","Gruppe","Kundenrabatt, %"]
[null,null,null,1,"Herr","Igor","Schmidt","+49 17643693668","info@exceldok.de","86500","Kutzenhausen","Gartenweg 5a","ExcelDok","Notiere hier alles wissenswertes über den Kunden\r\n\r\n","2025-07-14T19:17:00","2026-03-15T14:21:29","Lieferant",0.3]

{"sheet":"Angebot","index":1,"n_rows":26,"n_cols":18,"rows_kept":26,"cut":false,"hidden":true,"merged":[[20,11,20,17],[18,11,18,17],[22,14,22,17],[17,13,17,17],[23,14,23,17]]}
["Angebot Neu",null,null,null,null,null,null,null,null,null,null,"ANGEBOT"]
["Bedingte Format",null,null,null,null,null,null,null,null,"Betreff"]
["AngebotDBZeile",null,null,null,null,null,null,null,null,"Zahlungsbedingungen"]
["KontaktDBZeile",null,null,null,null,null,null,null,null,"UST-Regelung",null,"Empfänger"]
["Status",null,null,null,null,null,null,null,null,"Anrede"]
["Akt.Pos.Zeile",null,null,null,null,null,null,null,null,"Bemerkung"]
["AutoÄnderung",null,null,null,null,null,null,null,null,"Lieferadresse"]
["Dateipfad",null,null,null,null,null,null,null,null,"Fußzeile"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Bau-/Lieferadresse"]
[]
["Gesamt Netto:",null,{"$f":"ROUND(SUMIF(L27:L200,\"<>\"&0,R27:R200),2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"Angebotsnummer:"]
["inkl. UST.:",{"$f":"IF(MAX($Q$27:Q200)=0,0,MAX($Q$27:Q200))","v":0},{"$f":"IF(B14=\"\",0,SUMPRODUCT((L27:L200<>0)*1,(Q27:Q200=B14)*1,Q27:Q200,R27:R200))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"Angebotsdatum:"]
["inkl. UST.:",{"$f":"IF(MIN($Q$27:Q200)=B14,0,MIN($Q$27:Q127))","v":0},{"$f":"SUMPRODUCT((L27:L200<>0)*1,(Q27:Q200=B15)*1,Q27:Q200,R27:R200)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"Angebot gültig bis:"]
["Gesamt Brutto:",null,{"$f":"ROUND(SUM(C13:C15),2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"Kundennummer:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kunden-UID:"]
[null,null,null,null,null,null,null,null,null,null,null,"Betreff:"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Bezahlung:"]
[null,null,null,null,null,null,null,null,null,null,null,"UST-Regelung:"]
[]
[null,null,null,null,null,null,null,null,null,"Typ",null,"Pos.","Menge","ME","Bezeichnung","Einzelpreis","UST","Gesamtpreis"]

{"sheet":"Rechnung","index":2,"n_rows":26,"n_cols":18,"rows_kept":26,"cut":false,"hidden":true,"merged":[[17,13,17,17],[18,11,18,17],[20,11,20,17],[22,14,22,17],[23,14,23,17]]}
["Rechnung Neu",null,null,null,null,null,null,null,null,null,null,"RECHNUNG"]
["Bedingte Format",null,null,null,null,null,null,null,null,"Betreff"]
["RechnungDBZeile",null,null,null,null,null,null,null,null,"Zahlungsbedingungen"]
["KontaktDBZeile",null,null,null,null,null,null,null,null,"UST-Regelung",null,"Empfänger"]
["Status",null,null,null,null,null,null,null,null,"Anrede"]
["Akt.Pos.Zeile",null,null,null,null,null,null,null,null,"Bemerkung"]
["AutoÄnderung",null,null,null,null,null,null,null,null,"Lieferadresse"]
["Dateipfad",null,null,null,null,null,null,null,null,"Fußzeile"]
["AngebotID"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Bau-/Lieferadresse"]
[]
["Gesamt Netto:",null,{"$f":"ROUND(SUMIF(L27:L200,\"<>\"&0,R27:R200),2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"Rechnungsnummer:"]
["inkl. USt.:",{"$f":"IF(MAX($Q$27:Q200)=0,0,MAX($Q$27:Q200))","v":0},{"$f":"IF(B14=\"\",0,SUMPRODUCT((L27:L200<>0)*1,(Q27:Q200=B14)*1,Q27:Q200,R27:R200))","v":0},{"$f":"IF(B14=\"\",\"\",SUMIFS(R27:R200,Q27:Q200,B14,L27:L200,\">\"&0))","v":0},null,null,null,null,null,null,null,null,null,null,null,"Rechnungsdatum:"]
["inkl. USt.:",{"$f":"IF(MIN($Q$27:Q200)=B14,0,MIN($Q$27:Q127))","v":0},{"$f":"SUMPRODUCT((L27:L200<>0)*1,(Q27:Q200=B15)*1,Q27:Q200,R27:R200)","v":0},{"$f":"IF(B15=\"\",\"\",SUMIFS(R27:R200,Q27:Q200,B15,L27:L200,\">\"&0))","v":0},null,null,null,null,null,null,null,null,null,null,null,"Leistungsdatum:"]
["Gesamt Brutto:",null,{"$f":"ROUND(SUM(C13:C15),2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"Kundennummer:"]
["UST-ID",{"$f":"IFERROR(VLOOKUP(O24,Garantie_List[#All],2,0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"Kunden-UID:"]
["Invoci typ",{"$f":"VLOOKUP(L1,InvoiceType_tbl[],2,0)","v":380},null,null,null,null,null,null,null,null,null,"Betreff:"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Bezahlung:"]
[null,null,null,null,null,null,null,null,null,null,null,"UST-Regelung:"]
[]
[null,null,null,null,null,null,null,null,null,"Typ",null,"Pos.","Menge","ME","Bezeichnung","Einzelpreis","UST","Gesamtpreis"]

{"sheet":"KontakteDB","index":3,"n_rows":8,"n_cols":42,"rows_kept":8,"cut":false,"hidden":true,"merged":[]}
[null,null,null,"Datenbanktabelle für Kontakte"]
[]
[]
[]
[null,null,null,"long","text","text","text","text","text","text","text","text","text","text","text","text","text","text","text","text","text","text","text","text","text","text","text","date","text","long","text","percent","long","percent","text","text","text","text","text","text","datetime","datetime"]
[null,null,null,"txtKontaktID","cbxAnrede","txtVorname","txtName","txtFirma","txtPosition","txtTelefon","txtMobile","txtMail","txtNotizen","cbxKategorie","txtWebseite","cbxGruppe","txtPLZ","cbxOrt","txtAdresse","cbxLand","txtVorname2","txtName2","txtFirma2","txtPLZ2","cbxOrt2","txtAdresse2","cbxLand2","txtGeburtstag","txtUSTID","cbxEmpfehlung","cbxZahlungbedingung","txtSkontosatz","txtSkontofrist","txtKundenrabatt","txtBF1","txtBF2","txtBF3","txtBF4","txtBF5","txtBF6","txtErstellt","txtEdited"]
[null,null,null,"KontaktID","Anrede","Vorname","Name","Firma","Position","Telefon","Mobil","E-Mail","Notizen","Kategorie","Webseite","Gruppe","PLZ","Ort","Adresse","Land","Vorname2","Name2","Firma2","PLZ2","Ort2","Adresse2","Land2","Geburtsdatum","UST-ID","Empfohlen von","Zahlungsbedingung","Skonto, %","Skontofrist","Kundenrabatt, %","BF1","BF2","BF3","BF4","BF5","BF6","Erstellt","Geändert"]
[null,null,null,1,"Herr","Igor","Schmidt","ExcelDok","Autor dieses Tools","","+49 17643693668","info@exceldok.de","Notiere hier alles wissenswertes über den Kunden\r\n\r\n","VIP","https://exceldok.de","Lieferant","86500","Kutzenhausen","Gartenweg 5a","DE","","","","","","","",29500,"",0,"14 Tage ohne Abzug",0.05,0,0.3,"","","","","","","2025-07-14T19:17:00","2026-03-15T14:21:29"]

{"sheet":"DokumenteDB","index":4,"n_rows":7,"n_cols":18,"rows_kept":7,"cut":false,"hidden":true,"merged":[]}
[null,null,null,"Datenbanktabelle für Kontakte"]
[]
[]
[]
[null,null,null,"long","text","text","text","long","text","datetime",null,"text","datetime","datetime","text","long",null,"text"]
[null,null,null,"txtDokumentID","cbxArt","txtDokument","txtNotizen","txtKontaktID","txtDateityp","txtSpeicherdatum","txtDateisize","txtDokumentpfad","txtErstellt","txtEdited","cbxSpeicherort","cbxProduktID","cbxAngebotNr","cbxStatus"]
[null,null,null,"DokumentID","Art","Dokument","Notizen","KontaktID","Dateityp","Speicherdatum","Dateigröße","Pfad","Erstellt","Gespeichert","Speicherort","ProduktID","AngebotID","Status"]

{"sheet":"ProdukteDB","index":5,"n_rows":7,"n_cols":32,"rows_kept":7,"cut":false,"hidden":true,"merged":[]}
[null,null,null,"Datenbanktabelle für Produkte"]
[]
[]
[]
[null,null,null,"long","text","text","text","text","double","double","percent","text","text","text","text","text","text","text","double","text","text","datetime","datetime","text","text","text","text","text","text","text","text","text"]
[null,null,null,"txtProduktID","cbxTyp","cbxGruppe","cbxME","txtBezeichnung","txtVerkaufspreis","txtEinkaufspreis","cbxUMST","txtHerstellerNr","txtGroesse","txtLink","txtBarcode","txtBild","cbxStatus","txtLangtext","txtMenge","cbxKategorie","cbxSubkategorie","txtErstellt","txtEdited","txtBF1","txtBF2","txtBF3","txtBF4","txtBF5","txtBF6","txtBF7","txtBF8","txtBF9"]
[null,null,null,"ProduktID","Typ","Gruppe","Mengeneinheit","Bezeichnung","Verkaufspreis","Einkaufspreis","UMST-Satz","HerstellerNr","Größe","Link","Barcode","Bild","Status","Langtext","Menge","Kategorie","Subkategorie","Erstellt","Geändert","BF1","BF2","BF3","BF4","BF5","BF6","BF7","BF8","BF9"]

{"sheet":"AngeboteDB","index":6,"n_rows":7,"n_cols":28,"rows_kept":7,"cut":false,"hidden":true,"merged":[]}
[null,null,null,"Datenbanktabelle für Angebote",null,null,null,null,"Datenbanktabelle für Angebote"]
[]
[]
[]
[null,null,null,"long","long","date","date","double","double","text","text","text","text","text","text","text","text","text","text","text","text","text","text","text","text","text","text","datetime"]
[null,null,null,"R13","R16","R14","R15","C13","C16","O27","N18","L19","L21","O23","O24","B8","B5","L5","L6","L7","L8","L9","L12","L13","L14","L15","L16"]
[null,null,null,"AngebotID","KontaktID","Angebotsdatum","Gültig bis","Netto","Brutto","Erste Position","Betreff","Anrede","Bemerkung","Zahlungsbedingung","UST-Regelung","Pfad","Status","Firma","Kundenname","Adresse","Ort","Land","Firma2","Name2","Adresse2","Ort2","Land2","Letzte Speicherung"]

{"sheet":"RechnungenDB","index":7,"n_rows":7,"n_cols":29,"rows_kept":7,"cut":false,"hidden":true,"merged":[]}
[null,null,null,"Datenbanktabelle für Rechnungen",null,null,null,null,null,null,"Datenbanktabelle für Rechnungen"]
[]
[]
[]
[null,null,null,"long","long","date","date","double","double","text","text","text","text","text","text","text","text","text","text","text","text","text","text","text","text","text","text","long","datetime"]
[null,null,null,"R13","R16","R14","R15","C13","C16","O27","N18","L19","L21","O23","O24","B8","B5","L5","L6","L7","L8","L9","L12","L13","L14","L15","L16"]
[null,null,null,"RechnungID","KontaktID","Rechnungsdatum","Leistungsdatum","Netto","Brutto","Erste Position","Betreff","Anrede","Bemerkung","Zahlungsbedingung","UST-Regelung","Pfad","Status","Firma","Kundenname","Adresse","Ort","Land","Firma2","Name2","Adresse2","Ort2","Land2","AngebotID","Letzte Speicherung"]

{"sheet":"PositionenDB","index":8,"n_rows":7,"n_cols":18,"rows_kept":7,"cut":false,"hidden":true,"merged":[]}
[null,null,null,"Datenbanktabelle für Formularpositionen"]
[]
[]
[]
[null,null,null,"long","long","long","text","text","long","double","text","text","double","percent","long","long","text","datetime"]
[null,null,null,"A","B","C","D","J","L","M","N","O","P","Q"]
[null,null,null,"PositionID","DBZeile","ProduktID","HerstellerNr","Positionstyp","PositionNr","Menge","Einheit","Leistungsbezeichnung","Einzelpreis","UMST","FormularZeile","OriginalbelegID","Belegtyp","Speicherzeit"]

{"sheet":"Admin","index":9,"n_rows":20,"n_cols":137,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["EINSTELLUNGEN",null,"Formateinstellungen",null,null,"Mein Unternehmen",null,null,"Speicheradressen",null,null,"Toolversion",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kontakteinstellungen",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dokumenteneinstellungen",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Angebotseinstellungen",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Produkteinstellungen",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rechnungseinstellungen"]
[]
[null,null,"Format","Code",null,"Parameter","Wert",null,"Ordner","Pfad",null,"Dateiname","ChefZentrale",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kontakte_Anzeige",null,"Anrede",null,"Land",null,"Gruppe",null,"Kategorie",null,"Zahlungsbedingung","Skontosatz","Skontofrist",null,"Outlooksynchronisierung","Nein",null,null,null,null,null,null,null,null,null,null,"Dokumente_Anzeige",null,"Dokumentenart",null,"Dokumentenstatus",null,"Standardspeicherort",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Angebote_Anzeige",null,"Angebotsstatus",null,"Angebotsfrist",null,null,null,"UST-Regelung","UST-ID",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Produkte_Anzeige",null,"Typ",null,"Gruppe",null,"Kategorie",null,"Subkategorie",null,"Status",null,"Mengeneinheit",null,"UMST-Satz",null,null,null,null,null,null,null,null,null,null,null,"Rechnungen_Anzeige",null,"Rechnungsstatus",null,"Sofortversand"]
[null,null,"Sprache","Deutsch",null,"Unternehmensname",null,null,"Backupordner",null,null,"Version","Testversion",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KontaktID",null,"Herr",null,"DE",null,"Kunde",null,"Neukunde",null,"Sofort nach Erhalt der Rechnung",null,null,null,"Outlookkontaktordner",null,null,null,null,null,null,null,null,null,null,null,"DokumentID",null,"Eingangsrechnung",null,"Erledigt",null,"Lokale Datei",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AngebotID",null,"NEU",null,30,null,null,null,"Standard UST","S",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ProduktID",null,"Dienstleistung",null,"Beratung",null,"Kategorie 1",null,"Subkategorie A",null,"verfügbar",null,"C62",null,0.19,null,null,null,null,null,null,null,null,null,null,null,"RechnungID",null,"NEU",null,"Ja"]
[null,null,"Datum","dd.mm.yyyy",null,"Ansprechpartner",null,null,"Dokumente",null,null,"Versionsdatum",46096,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Anrede",null,"Frau",null,"AT",null,"Interessent",null,"A-Kunde",null,"10 Tage ohne Abzug",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Art",null,"Vertrag",null,"Prüfen",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Angebotsdatum",null,"OFFEN",null,null,null,null,null,"Keine Umsatzsteuer gemäß §19 Abs. 1 UStG","E",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bezeichnung",null,"Material",null,"Software",null,"Kategorie 2",null,"Subkategorie B",null,"bestellbar",null,"HUR",null,7.0000000000000007E-2,null,null,null,null,null,null,null,null,null,null,null,"Rechnungsdatum",null,"OFFEN"]
[null,null,"Zeit","hh:mm",null,"PLZ Ort",null,null,"Angebote",null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vorname",null,"Familie",null,"CH",null,"Lieferant",null,"B-Kunde",null,"14 Tage ohne Abzug",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dokument",null,"Rechnungsanhang",null,"Archiviert",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KontaktID",null,"BEAUFTRAGT",null,"Sofortversand",null,null,null,"Steuerschuldnerschaft des Leistungsempfängers (Reverse Charge)","AE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mengeneinheit",null,"Alternative",null,"Hardware",null,"Kategorie 3",null,"Subkategorie C",null,"inaktiv",null,"KGM",null,0,null,null,null,null,null,null,null,null,null,null,null,"KontaktID",null,"BEZAHLT",null,"ERechnung als Standard"]
[null,null,"DateTime","dd.MM.yyyy hh:mm",null,"Adresse",null,null,"Rechnungen",null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Name",null,null,null,null,null,"Partner",null,"C-Kunde",null,"innerhalb von 30 Tagen",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Notizen",null,"Anfrage",null,"Löschen?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Firma",null,"FAKTURIERT",null,"Nein",null,null,null,"Steuerpflichtig mit UST=0%","Z",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Verkaufspreis",null,"Überschrift",null,"usw. je nach Branche",null,null,null,"Subkategorie D",null,null,null,"MTR",null,null,null,null,null,null,null,null,null,null,null,null,null,"Firma",null,"IM VERZUG",null,"Nein"]
[null,null,"Geld","#,##0.00 [$€-x-euro2];[Red]-#,##0.00 [$€-x-euro2]",null,"Telefon",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mobil",null,null,null,null,null,"Mitarbeiter",null,"VIP",null,"2 % Skonto bei Zahlung innerhalb von 10 Tagen, sonst netto 30 Tage",0.02,10,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dateityp",null,"Protokoll",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kundenname",null,"KEIN INTERESSE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"UMST-Satz",null,"Zwischensumme",null,null,null,null,null,null,null,null,null,"LTR",null,null,null,null,null,null,null,null,null,null,null,null,null,"Kundenname",null,"ABGEMAHNT"]
[null,null,"Prozent","0.00%",null,"Mobil",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"E-Mail",null,null,null,null,null,"Andere",null,"Blacklist",null,"Bei Zahlung innerhalb von 14 Tagen 3 % Skonto, ansonsten 30 Tage netto",0.03,14,null,null,null,null,null,null,null,null,null,null,null,null,null,"Speicherdatum",null,"Bestellung",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Erste Position",null,"NACHFRAGEN",null,"Mailbetreff",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Typ",null,null,null,null,null,null,null,null,null,null,null,"DAY",null,null,null,null,null,null,null,null,null,null,null,null,null,"Erste Position",null,"NACHFRAGEN",null,"Mailbetreff"]
[null,null,null,null,null,"E-Mail",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PLZ",null,null,null,null,null,null,null,"Deaktiviert",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dateigröße",null,"sdfsdf",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Netto",null,"NACHARBEITEN",null,"Ihr Angebot",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gruppe",null,null,null,null,null,null,null,null,null,null,null,"MTK",null,null,null,null,null,null,null,null,null,null,null,null,null,"Netto",null,"NACHARBEITEN",null,"Ihre Rechnung"]
[null,null,null,null,null,"Webseite",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ort",null,null,null,null,null,null,null,"Sonstiges",null,null,null,null,null,"Suchordner im Outlook",null,null,null,null,null,null,null,null,null,null,null,"Pfad",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Betreff",null,"GELÖSCHT",null,"Dein Wunschtext",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kategorie",null,null,null,null,null,null,null,null,null,null,null,"MTQ",null,null,null,null,null,null,null,null,null,null,null,null,null,"Betreff",null,"GELÖSCHT",null,"Dein Wunschtext"]
[null,null,null,null,null,"Ust-IdNr",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Adresse",null,null,null,null,null,null,null,"abrechnen",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Erstellt",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gültig bis",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Subkategorie",null,null,null,null,null,null,null,null,null,null,null,"KWT",null,null,null,null,null,null,null,null,null,null,null,null,null,"Leistungsdatum"]
[null,null,null,null,null,"Bank",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Firma",null,null,null,null,null,null,null,"abgemahnt",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gespeichert",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Status",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Menge",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Status"]
[null,null,null,null,null,"IBAN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Notizen",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Speicherort",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Letzte Speicherung",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Größe",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Letzte Speicherung"]
[null,null,null,null,null,"BIC",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Erstellt",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KontaktID",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Barcode"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Geändert",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HerstellerNr"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gruppe",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Langtext"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kundenrabatt, %",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Status"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Erstellt"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Geändert"]

{"sheet":"Kommunikation","index":10,"n_rows":2,"n_cols":6,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Alle E-Mails an bzw. vom ausgewählten Kontakt aus Outlook"]
["Typ","Datum","Betreff","EntryID","StoreID","Outlookordner"]

{"sheet":"ExcelDok","index":11,"n_rows":31,"n_cols":28,"rows_kept":31,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Speicherort",null,"OutlookOrdnerID",null,"Blatt","Bereichname","Range",null,"Registrierung",null,"Angebotsteil","Flag","Zeile",null,"Boolean",null,"BlattSchutz",null,"Rechnungsteil","Flag","Zeile",null,"InvoiceType","InvoiceTypeID",null,"Version","Status"]
[null,"Lokale Datei",null,"00000000500B65E259C69E47B382AF11EAE5A3F10100D7C5F13E7939C941A87045C8A67C3C790002AD1EBF970000",null,"Admin","Allgemein","C:R",null,null,null,"Betreff",1,18,null,"Ja",null,"Angebot",null,"Betreff",1,18,null,"RECHNUNG",380,null,"Test",1]
[null,"Lokaler Ordner",null,null,null,"Admin","Kontakte","AC:AR",null,null,null,"Zahlungsbedingungen",1,23,null,"Nein",null,"Rechnung",null,"Zahlungsbedingungen",1,23,null,"GUTSCHRIFT",389,null,"Kundenverwaltung",1]
[null,"Onlinepfad",null,null,null,"Admin","Dokumente","BC:BR",null,null,null,"Gewaehrleistung",1,24,null,null,null,null,null,"Gewaehrleistung",1,24,null,"STORNO",384,null,"Angebot",1]
[null,null,null,null,null,"Admin","Angebote","CC:CR",null,null,null,"Anrede",1,19,null,null,null,null,null,"Anrede",1,19,null,null,null,null,"E-Rechnung",1]
[null,null,null,null,null,"Admin","Produkte","DC:DR",null,null,null,"Bemerkung",1,21,null,null,null,null,null,"Bemerkung",1,21]
[null,null,null,null,null,"Admin","Rechnungen","EC:ER",null,null,null,"Lieferadresse",1,0,null,null,null,null,null,"Lieferadresse",1,0]
[null,null,null,null,null,null,null,null,null,null,null,"Fusszeile",1,0,null,null,null,null,null,"Fusszeile",1,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["ANGEBOT","Autozeilenhöhe für Betreff",null,"für Anrede und Bemerkungen",null,"für zahlungsbedngungen und Gewährleistung"]
["Betreff",{"$f":"Angebot!N18","v":0}]
["Anrede",null,null,{"$f":"Angebot!L19","v":0}]
["Bemerkung",null,null,{"$f":"Angebot!L21","v":0}]
["Zahlungsbedingungen",null,null,null,null,{"$f":"Angebot!O23","v":0}]
["Gewährleistung",null,null,null,null,{"$f":"Angebot!O24","v":0}]
["RECHNUNG"]
["Betreff",{"$f":"Rechnung!N18","v":0}]
["Anrede",null,null,{"$f":"Rechnung!L19","v":0}]
["Bemerkung",null,null,{"$f":"Rechnung!L21","v":0}]
["Zahlungsbedingungen",null,null,null,null,{"$f":"Rechnung!O23","v":0}]
["Gewährleistung",null,null,null,null,{"$f":"Rechnung!O24","v":0}]