{"text_format":"3","workbook":"xlsx","n_sheets":6,"sheets":["Start","Persönliche Details","Reisedetails","Hotel und Aktivitäten","Mietwagen","Notfalldetails"],"not_rendered":{"images":19,"defined_names":10},"read":"whole","date_system":"1900"}

{"sheet":"Start","index":0,"n_rows":34,"n_cols":22,"rows_kept":34,"merged":[[32,1,32,3],[32,6,32,8],[32,11,32,13],[32,16,32,18],[32,21,32,23],[33,1,33,3],[33,6,33,8],[33,11,33,13],[33,16,33,18],[33,21,33,23]]}
{"$rows_empty":32}
[null,{"$f":"PersönlichEintrag/PersönlichAnzahl","v":{"v":1,"d":"100%"}},{"$nulls":4},{"$f":"ReiseEintrag/ReiseAnzahl","v":{"v":0.65,"d":"65%"}},{"$nulls":4},{"$f":"HotelEintrag/HotelAnzahl","v":{"v":0.5384615384615384,"d":"54%"}},{"$nulls":4},{"$f":"IF(Mietwagen!D4=\"Ja\",MietwagenEintrag/MietwagenAnzahl,1)","v":{"v":0.2857142857142857,"d":"29%"}},{"$nulls":4},{"$f":"NotfallEintrag/NotfallAnzahl","v":{"v":0.625,"d":"63%"}}]
[null,{"$f":"TEXT(B33,\"0% \"\"Abschluss\"\"\")","v":"100% Abschluss"},{"$nulls":4},{"$f":"TEXT(G33,\"0% \"\"Abschluss\"\"\")","v":"65% Abschluss"},{"$nulls":4},{"$f":"TEXT(L33,\"0% \"\"Abschluss\"\"\")","v":"54% Abschluss"},{"$nulls":4},{"$f":"TEXT(Q33,\"0% \"\"Abschluss\"\"\")","v":"29% Abschluss"},{"$nulls":4},{"$f":"TEXT(V33,\"0% \"\"Abschluss\"\"\")","v":"63% Abschluss"}]

{"sheet":"Persönliche Details","index":1,"n_rows":11,"n_cols":5,"rows_kept":11,"merged":[[4,2,5,2],[4,3,5,3],[4,4,5,4],[7,2,8,2],[7,3,8,3],[7,4,8,4],[17,1,17,4]]}
[]
[]
[{"$f":"IF(COUNTA(B4:B8)<1,\"*\",\"\")","v":""},"Vollständige Namen und Spitznamen",{"$f":"IF(E3=\"\",1,\"\")","v":""},"Privatadresse","Bahnhofstr. 15, 44567 Münchfeld"]
[null,"Michael Alexander"]
[null,"Katrin Alexander",{"$f":"IF(E5=\"\",1,\"\")","v":""},"Telefon privat",3455550123]
[null,"Sebastian Alexander"]
[]
[null,null,{"$f":"IF((E8=0)+(E8=\"\"),1,\"\")","v":""},"Handys",3455550124]
[]
[]
[{"$f":"PersönlichEintrag","v":3},{"$f":"IF(A11<>PersönlichAnzahl,\"Fehlende wichtige Details\",\"Wichtige Details vollständig\")","v":"Wichtige Details vollständig"}]

{"sheet":"Reisedetails","index":2,"n_rows":18,"n_cols":6,"rows_kept":18,"merged":[[23,1,23,5]]}
[]
[]
[null,"Abflug Details",null,null,"Rückflug Details"]
[{"$f":"IF(C4=\"\",1,\"\")","v":""},"Datum",{"$f":"TODAY()+45","v":"2013-02-23"},{"$f":"IF(F4=\"\",1,\"\")","v":""},"Datum",{"$f":"TODAY()+51","v":"2013-03-01"}]
[{"$f":"IF(C5=\"\",1,\"\")","v":""},"Fluglinie","Blue Yonder Airlines","","Fluglinie","Blue Yonder Airlines"]
[{"$f":"IF(C6=\"\",1,\"\")","v":""},"Flugnummer","WS192",1,"Flugnummer"]
[{"$f":"IF(C7=\"\",1,\"\")","v":""},"Von","Seattle","","Von","Frankfurt"]
[{"$f":"IF(C8=\"\",1,\"\")","v":""},"Abflugzeit","12:30:00",1,"Abflugzeit"]
[null,"Abflugterminal/Flugsteig",null,1,"Abflugterminal/Flugsteig"]
[{"$f":"IF(C10=\"\",1,\"\")","v":""},"Nach","Frankfurt",1,"Nach"]
[{"$f":"IF(C11=\"\",1,\"\")","v":""},"Ankunftszeit","12:32:00",1,"Ankunftszeit"]
[null,"Flugdauer","15 Stunden",null,"Flugdauer"]
[{"$f":"IF(C13=\"\",1,\"\")","v":""},"Sitzplatznummern","A1, A2, A3",{"$f":"IF(F13=\"\",1,\"\")","v":1},"Sitzplatznummern"]
[{"$f":"IF(C14=\"\",1,\"\")","v":""},"Bestätigungsnummern","Dieselbe",{"$f":"IF(F14=\"\",1,\"\")","v":1},"Bestätigungsnummern"]
[{"$f":"IF(C15=\"\",1,\"\")","v":""},"Mahlzeit","Keine Einschränkungen",null,"Mahlzeit"]
[null,"Fluglinie Telefonnummer",1235550234,null,"Fluglinie Telefonnummer",1235550234]
[]
[{"$f":"ReiseEintrag","v":13},{"$f":"IF(A18<>ReiseAnzahl,\"Fehlende wichtige Details\",\"Wichtige Details vollständig\")","v":"Fehlende wichtige Details"}]

{"sheet":"Hotel und Aktivitäten","index":3,"n_rows":15,"n_cols":7,"rows_kept":15,"merged":[[21,1,21,6]]}
[]
[]
[null,"Hotelaufenthalt/Unterkunft Details",{"$nulls":3},"Urlaubsaktivitäten Details"]
[{"$f":"IF(C4=\"\",1,\"\")","v":""},"Reservierungsdatum",{"$f":"TODAY()+45","v":"2013-02-23"},null,null,"Aktivität 1","Skilaufen"]
["","Hotelname","Alpine Ski House",null,{"$f":"IF(AND($G$4<>\"\",G5=\"\"),1,\"\")","v":1},"Daten/Uhrzeiten"]
["","Hoteladresse","789 Main Street",null,{"$f":"IF(AND($G$4<>\"\",G6=\"\"),1,\"\")","v":1},"Reservierungsdatum"]
["","Hoteltelefonnummer","Seattle",null,{"$f":"IF(AND($G$4<>\"\",G7=\"\"),1,\"\")","v":1},"Bestätigungsnummer"]
["","Datum/Uhrzeit Einchecken",{"$f":"TODAY()+45.5","v":"2013-02-23T12:00:00"},null,null,"Aktivität 2","Weingut und Weinkellerei Coho"]
["","Datum/Uhrzeit Auschecken",{"$f":"TODAY()+50.5","v":"2013-02-28T12:00:00"},null,{"$f":"IF(AND($G$8<>\"\",G9=\"\"),1,\"\")","v":1},"Daten/Uhrzeiten"]
["","Bestätigungsnummer","CJ1234567",null,{"$f":"IF(AND($G$8<>\"\",G10=\"\"),1,\"\")","v":1},"Reservierungsdatum"]
[{"$nulls":4},{"$f":"IF(AND($G$8<>\"\",G11=\"\"),1,\"\")","v":1},"Bestätigungsnummer"]
[{"$f":"HotelEintrag","v":7},{"$f":"IF(A12<>HotelAnzahl,\"Fehlende wichtige Details\",\"Wichtige Details vollständig\")","v":"Fehlende wichtige Details"},{"$nulls":3},"Aktivität 3"]
[{"$nulls":4},{"$f":"IF(AND($G$12<>\"\",G13=\"\"),1,\"\")","v":""},"Daten/Uhrzeiten"]
[{"$nulls":4},{"$f":"IF(AND($G$12<>\"\",G14=\"\"),1,\"\")","v":""},"Reservierungsdatum"]
[{"$nulls":4},{"$f":"IF(AND($G$12<>\"\",G15=\"\"),1,\"\")","v":""},"Bestätigungsnummer"]

{"sheet":"Mietwagen","index":4,"n_rows":13,"n_cols":4,"rows_kept":13,"merged":[[18,0,18,4]]}
[]
[]
[null,null,"Mietwagen Infos"]
[null,null,"Wagen mieten?","Ja"]
[null,{"$f":"IF(AND($D$4=\"Ja\",D5=\"\"),1,\"\")","v":""},"Reservierungsdatum",{"$f":"TODAY()+45","v":"2013-02-23"}]
[null,1,"Verleihfirma"]
[null,1,"Abholung Datum/Uhrzeit"]
[null,1,"Rückgabe Datum/Uhrzeit"]
[null,1,"Bestätigungsnummer"]
[null,"","Fahrzeugtyp","Mittelklasse"]
[null,1,"Telefonnummer"]
[]
[null,{"$f":"MietwagenEintrag","v":2},{"$f":"IF(B13<>MietwagenAnzahl,\"Fehlende wichtige Details\",\"Wichtige Details vollständig\")","v":"Fehlende wichtige Details"}]

{"sheet":"Notfalldetails","index":5,"n_rows":11,"n_cols":6,"rows_kept":11,"merged":[[3,4,4,4],[3,5,4,5],[3,6,4,6],[5,4,6,4],[5,5,6,5],[5,6,6,6],[7,5,8,5],[7,6,8,6],[16,1,16,6]]}
[]
[]
[null,"Versicherung Details",{"$nulls":3},"Notfallkontakt Details"]
[{"$f":"IF(C4=\"\",1,\"\")","v":""},"Versicherungsgesellschaft","Humongous Insurance",null,{"$f":"IF(G4=\"\",1,\"\")","v":1},"Name/Beziehung/Telefon"]
["","Telefonnummer",1235550567]
["","Versicherungsbeginn","1900-01-05",null,{"$f":"IF(G6=\"\",1,\"\")","v":1},"Name/Beziehung/Telefon"]
["","Bestätigungsnummer","1900-01-05"]
["","Kaufdatum",{"$f":"TODAY()","v":"2013-01-09"},null,null,"Name/Beziehung/Telefon"]
[1,"Versicherungsdaten"]
[]
[{"$f":"NotfallEintrag","v":5},{"$f":"IF(A11<>NotfallAnzahl,\"Fehlende wichtige Details\",\"Wichtige Details vollständig\")","v":"Fehlende wichtige Details"}]