{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Jugendhaus 4"],"not_rendered":{"defined_names":1,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"Jugendhaus 4","index":0,"n_rows":91,"n_cols":17,"rows_kept":91,"merged":[[0,1,3,1],[0,2,3,2],[0,3,0,4],[2,3,2,4],[3,3,3,4],[6,6,7,6],[9,6,14,6],[16,6,18,6],[20,6,22,6],[24,6,27,6],[31,6,32,6],[34,1,37,1],[34,2,37,2],[34,3,34,4],[36,3,36,4],[37,3,37,4],[40,6,41,6],[43,6,48,6],[50,6,52,6],[54,6,56,6],[58,6,61,6],[63,1,66,1],[63,2,66,2],[63,3,63,4],[65,3,65,4],[66,3,66,4],[69,6,74,6],[76,6,77,6],[88,5,88,6],[90,1,90,6]]}
[null,"B",1,"bitte Gruppenname eingeben",null," Gruppenname",null,null,"  Gruppenhaus -B-",{"$nulls":4},"Daten ausrechnen"]
[]
[{"$nulls":3},"2015-01-01",null," Datum Anreise",null,null,"  erster Stock",{"$nulls":4},"0-9 Jahre =",{"$f":"9*365-1","v":3284},"Tage","Datumskontrolle:"]
[{"$nulls":3},"2014-12-01",null," Datum Abreise",{"$nulls":7},"10-15 Jahre =",{"$f":"15*365-1","v":5474},"Tage",{"$f":"+D4-D3","v":-31}]
[null,"Gruppenhaus","Stock","Name, Vorname","Geb-Data","Tarif","Auslast."]
[{"$nulls":13},"zählenwenn","Summe",null,"Anzahl Gäste"]
[null,"Zimmer 11","Bett 1",null,null,{"$f":"IF($D$4-E7<$O$3,\"Kinder\",IF(AND($D$4-E7>$O$3,$D$4-E7<=$O$4),\"Jugend\",\" \"))","v":" "},{"$f":"O8","v":{"v":0,"d":"0%"}},null,"  Bitte füllen Sie die blau markierten Felder aus - Danke",{"$nulls":3},{"$f":"+B7","v":"Zimmer 11"},{"$f":"IF(D7>1,50,0)","v":0},null,null,{"$f":"IF(D7>0,1,0)","v":0}]
[null," -> Leiterzimmer\n       mit Lavabo","Bett 2",null,null,{"$f":"IF($D$4-E8<$O$3,\"Kinder\",IF(AND($D$4-E8>$O$3,$D$4-E8<=$O$4),\"Jugend\",\" \"))","v":" "},{"$nulls":7},{"$f":"IF(D8>1,50,0)","v":0},{"$f":"SUM(N7:N8)","v":0},null,{"$f":"IF(D8>0,1,0)","v":0}]
[{"$nulls":16},0]
[null,"Zimmer 12","Bett 1",null,null,{"$f":"IF($D$4-E10<$O$3,\"Kinder\",IF(AND($D$4-E10>$O$3,$D$4-E10<=$O$4),\"Jugend\",\" \"))","v":" "},{"$f":"O15","v":{"v":0,"d":"0%"}},{"$nulls":5},{"$f":"+B10","v":"Zimmer 12"},{"$f":"IF(D10>1,17,0)","v":0},null,null,0]
[null," -> 6er Zi.","Bett 2",null,null," ",{"$nulls":7},{"$f":"IF(D11>1,17,0)","v":0},null,null,0]
[null,null,"Bett 3",null,null," ",{"$nulls":7},0,null,null,0]
[null,null,"Bett 4",null,null," ",{"$nulls":7},0,null,null,0]
[null,null,"Bett 5",null,null," ",{"$nulls":7},0,null,null,0]
[null,null,"Bett 6",null,null," ",{"$nulls":7},{"$f":"IF(D15>1,15,0)","v":0},{"$f":"SUM(N10:N15)","v":0},null,0]
[{"$nulls":16},0]
[null,"Zimmer 13","Pflegebett",null,null,{"$f":"IF($D$4-E17<$O$3,\"Kinder\",IF(AND($D$4-E17>$O$3,$D$4-E17<=$O$4),\"Jugend\",\" \"))","v":" "},{"$f":"+O19","v":{"v":0,"d":"0%"}},{"$nulls":5},{"$f":"+B17","v":"Zimmer 13"},{"$f":"IF(D17>1,33,0)","v":0},null,null,0]
[null," -> 3er Zi.","Bett 2",null,null,{"$f":"IF($D$4-E18<$O$3,\"Kinder\",IF(AND($D$4-E18>$O$3,$D$4-E18<=$O$4),\"Jugend\",\" \"))","v":" "},{"$nulls":7},{"$f":"IF(D18>1,33,0)","v":0},null,null,0]
[null,null,"Bett 3",null,null,{"$f":"IF($D$4-E19<$O$3,\"Kinder\",IF(AND($D$4-E19>$O$3,$D$4-E19<=$O$4),\"Jugend\",\" \"))","v":" "},{"$nulls":7},{"$f":"IF(D19>1,34,0)","v":0},{"$f":"SUM(N17:N19)","v":0},null,0]
[{"$nulls":16},0]
[null,"Zimmer 14","Pflegebett",null,null,{"$f":"IF($D$4-E21<$O$3,\"Kinder\",IF(AND($D$4-E21>$O$3,$D$4-E21<=$O$4),\"Jugend\",\" \"))","v":" "},{"$f":"+O23","v":{"v":0,"d":"0%"}},{"$nulls":5},{"$f":"+B21","v":"Zimmer 14"},{"$f":"IF(D21>1,33,0)","v":0},null,null,0]
[null," -> 3er Zi.","Bett 2",null,null,{"$f":"IF($D$4-E22<$O$3,\"Kinder\",IF(AND($D$4-E22>$O$3,$D$4-E22<=$O$4),\"Jugend\",\" \"))","v":" "},{"$nulls":7},{"$f":"IF(D22>1,33,0)","v":0},null,null,0]
[null,null,"Bett 3",null,null,{"$f":"IF($D$4-E23<$O$3,\"Kinder\",IF(AND($D$4-E23>$O$3,$D$4-E23<=$O$4),\"Jugend\",\" \"))","v":" "},{"$nulls":7},{"$f":"IF(D23>1,34,0)","v":0},{"$f":"SUM(N21:N23)","v":0},null,0]
[{"$nulls":16},0]
[null,"Zimmer 15","Bett 1",null,null,{"$f":"IF($D$4-E25<$O$3,\"Kinder\",IF(AND($D$4-E25>$O$3,$D$4-E25<=$O$4),\"Jugend\",\" \"))","v":" "},{"$f":"+O28","v":{"v":0,"d":"0%"}},{"$nulls":5},{"$f":"+B25","v":"Zimmer 15"},{"$f":"IF(D25>1,25,0)","v":0},null,null,0]
[null," -> 4er Zi.","Bett 2",null,null,{"$f":"IF($D$4-E26<$O$3,\"Kinder\",IF(AND($D$4-E26>$O$3,$D$4-E26<=$O$4),\"Jugend\",\" \"))","v":" "},{"$nulls":7},{"$f":"IF(D26>1,25,0)","v":0},null,null,0]
[null,null,"Bett 3",{"$nulls":10},0,null,null,0]
[null,null,"Bett 4",null,null,{"$f":"IF($D$4-E28<$O$3,\"Kinder\",IF(AND($D$4-E28>$O$3,$D$4-E28<=$O$4),\"Jugend\",\" \"))","v":" "},{"$nulls":7},0,{"$f":"SUM(N25:N28)","v":0},null,0]
[{"$nulls":16},0]
[null,"Zimmer 16"," = Besprechungsraum",{"$nulls":13},0]
[{"$nulls":16},0]
[null,"Zimmer 17","Bett 1",null,null,{"$f":"IF($D$4-E32<$O$3,\"Kinder\",IF(AND($D$4-E32>$O$3,$D$4-E32<=$O$4),\"Jugend\",\" \"))","v":" "},{"$f":"O33","v":{"v":0,"d":"0%"}},{"$nulls":5},{"$f":"+B32","v":"Zimmer 17"},{"$f":"IF(D32>1,50,0)","v":0},null,null,0]
[null," -> Leiterzimmer\n       mit Du/WC","Bett 2",null,null,{"$f":"IF($D$4-E33<$O$3,\"Kinder\",IF(AND($D$4-E33>$O$3,$D$4-E33<=$O$4),\"Jugend\",\" \"))","v":" "},{"$nulls":7},{"$f":"IF(D33>1,50,0)","v":0},{"$f":"SUM(N32:N33)","v":0},null,0]
[{"$nulls":16},0]
[null,"B",2,{"$f":"D1","v":"bitte Gruppenname eingeben"},null," Gruppenname",null,null,"  Gruppenhaus -B-",{"$nulls":4},"Daten ausrechnen"]
[]
[{"$nulls":3},{"$f":"D3","v":"2015-01-01"},null," Datum Anreise",null,null,"  zweiter Stock",{"$nulls":4},"0-9 Jahre =",{"$f":"9*365-1","v":3284},"Tage"]
[{"$nulls":3},{"$f":"+D4","v":"2014-12-01"},null," Datum Abreise",{"$nulls":7},"10-15 Jahre =",{"$f":"15*365-1","v":5474},"Tage"]
[null,"Gruppenhaus","Stock","Name, Vorname","Geb-Data","Tarif","Auslast."]
[{"$nulls":13},"zählenwenn","Summe",null,0]
[null,"Zimmer 21","Bett 1",null,null,{"$f":"IF($D$4-E41<$O$3,\"Kinder\",IF(AND($D$4-E41>$O$3,$D$4-E41<=$O$4),\"Jugend\",\" \"))","v":" "},{"$f":"O42","v":{"v":0,"d":"0%"}},{"$nulls":5},{"$f":"+B41","v":"Zimmer 21"},{"$f":"IF(D41>1,50,0)","v":0},null,null,0]
[null," -> Leiterzimmer\n       mit Lavabo","Bett 2",null,null,{"$f":"IF($D$4-E42<$O$3,\"Kinder\",IF(AND($D$4-E42>$O$3,$D$4-E42<=$O$4),\"Jugend\",\" \"))","v":" "},{"$nulls":7},{"$f":"IF(D42>1,50,0)","v":0},{"$f":"SUM(N41:N42)","v":0},null,0]
[{"$nulls":16},0]
[null,"Zimmer 22","Bett 1",null,null,{"$f":"IF($D$4-E44<$O$3,\"Kinder\",IF(AND($D$4-E44>$O$3,$D$4-E44<=$O$4),\"Jugend\",\" \"))","v":" "},{"$f":"O49","v":{"v":0,"d":"0%"}},{"$nulls":5},{"$f":"+B44","v":"Zimmer 22"},{"$f":"IF(D44>1,17,0)","v":0},null,null,0]
[null," -> 6er Zi.","Bett 2",null,null," ",{"$nulls":7},{"$f":"IF(D45>1,17,0)","v":0},null,null,0]
[null,null,"Bett 3",null,null," ",{"$nulls":7},0,null,null,0]
[null,null,"Bett 4",null,null," ",{"$nulls":7},0,null,null,0]
[null,null,"Bett 5",null,null," ",{"$nulls":7},0,null,null,0]
[null,null,"Bett 6",null,null," ",{"$nulls":7},{"$f":"IF(D49>1,15,0)","v":0},{"$f":"SUM(N44:N49)","v":0},null,0]
[{"$nulls":16},{"$f":"IF(D50>0,1,0)","v":0}]
[null,"Zimmer 23","Pflegebett",null,null,{"$f":"IF($D$4-E51<$O$3,\"Kinder\",IF(AND($D$4-E51>$O$3,$D$4-E51<=$O$4),\"Jugend\",\" \"))","v":" "},{"$f":"+O53","v":{"v":0,"d":"0%"}},{"$nulls":5},{"$f":"+B51","v":"Zimmer 23"},{"$f":"IF(D51>1,33,0)","v":0},null,null,0]
[null," -> 3er Zi.","Bett 2",null,null,{"$f":"IF($D$4-E52<$O$3,\"Kinder\",IF(AND($D$4-E52>$O$3,$D$4-E52<=$O$4),\"Jugend\",\" \"))","v":" "},{"$nulls":7},{"$f":"IF(D52>1,33,0)","v":0},null,null,0]
[null,null,"Bett 3",null,null,{"$f":"IF($D$4-E53<$O$3,\"Kinder\",IF(AND($D$4-E53>$O$3,$D$4-E53<=$O$4),\"Jugend\",\" \"))","v":" "},{"$nulls":7},{"$f":"IF(D53>1,34,0)","v":0},{"$f":"SUM(N51:N53)","v":0},null,0]
[{"$nulls":16},0]
[null,"Zimmer 24","Pflegebett",null,null,{"$f":"IF($D$4-E55<$O$3,\"Kinder\",IF(AND($D$4-E55>$O$3,$D$4-E55<=$O$4),\"Jugend\",\" \"))","v":" "},{"$f":"+O57","v":{"v":0,"d":"0%"}},{"$nulls":5},{"$f":"+B55","v":"Zimmer 24"},{"$f":"IF(D55>1,33,0)","v":0},null,null,0]
[null," -> 3er Zi.","Bett 2",null,null,{"$f":"IF($D$4-E56<$O$3,\"Kinder\",IF(AND($D$4-E56>$O$3,$D$4-E56<=$O$4),\"Jugend\",\" \"))","v":" "},{"$nulls":7},{"$f":"IF(D56>1,33,0)","v":0},null,null,0]
[null,null,"Bett 3",null,null,{"$f":"IF($D$4-E57<$O$3,\"Kinder\",IF(AND($D$4-E57>$O$3,$D$4-E57<=$O$4),\"Jugend\",\" \"))","v":" "},{"$nulls":7},{"$f":"IF(D57>1,34,0)","v":0},{"$f":"SUM(N55:N57)","v":0},null,0]
[{"$nulls":16},0]
[null,"Zimmer 25","Bett 1",null,null,{"$f":"IF($D$4-E59<$O$3,\"Kinder\",IF(AND($D$4-E59>$O$3,$D$4-E59<=$O$4),\"Jugend\",\" \"))","v":" "},{"$f":"+O62","v":{"v":0,"d":"0%"}},{"$nulls":5},{"$f":"+B59","v":"Zimmer 25"},{"$f":"IF(D59>1,25,0)","v":0},null,null,0]
[null," -> 4er Zi.","Bett 2",null,null,{"$f":"IF($D$4-E60<$O$3,\"Kinder\",IF(AND($D$4-E60>$O$3,$D$4-E60<=$O$4),\"Jugend\",\" \"))","v":" "},{"$nulls":7},{"$f":"IF(D60>1,25,0)","v":0},null,null,0]
[null,null,"Bett 3",{"$nulls":10},0,null,null,0]
[null,null,"Bett 4",null,null,{"$f":"IF($D$4-E62<$O$3,\"Kinder\",IF(AND($D$4-E62>$O$3,$D$4-E62<=$O$4),\"Jugend\",\" \"))","v":" "},{"$nulls":7},0,{"$f":"SUM(N59:N62)","v":0},null,0]
[{"$nulls":16},0]
[null,"B",2,{"$f":"+$D$1","v":"bitte Gruppenname eingeben"},null," Gruppenname",null,null,"  Gruppenhaus -B-",{"$nulls":4},"Daten ausrechnen"]
[]
[{"$nulls":3},{"$f":"+$D$3","v":"2015-01-01"},null," Datum Anreise",null,null,"  zweiter Stock fortfolgend…",{"$nulls":4},"0-9 Jahre =",{"$f":"9*365-1","v":3284},"Tage"]
[{"$nulls":3},{"$f":"+$D$4","v":"2014-12-01"},null," Datum Abreise",{"$nulls":7},"10-15 Jahre =",{"$f":"15*365-1","v":5474},"Tage"]
[null,"Gruppenhaus","Stock","Name, Vorname","Geb-Data","Tarif","Auslast."]
[]
[null,"Zimmer 26","Bett 1",null,null,{"$f":"IF($D$4-E70<$O$3,\"Kinder\",IF(AND($D$4-E70>$O$3,$D$4-E70<=$O$4),\"Jugend\",\" \"))","v":" "},{"$f":"O75","v":{"v":0,"d":"0%"}},{"$nulls":5},{"$f":"+B70","v":"Zimmer 26"},{"$f":"IF(D70>1,17,0)","v":0},null,null,{"$f":"IF(D70>0,1,0)","v":0}]
[null," -> 6er Zi.","Bett 2",null,null," ",{"$nulls":7},{"$f":"IF(D71>1,17,0)","v":0},null,null,0]
[null,null,"Bett 3",null,null," ",{"$nulls":7},0,null,null,0]
[null,null,"Bett 4",null,null," ",{"$nulls":7},0,null,null,0]
[null,null,"Bett 5",null,null," ",{"$nulls":7},0,null,null,0]
[null,null,"Bett 6",null,null," ",{"$nulls":7},{"$f":"IF(D75>1,15,0)","v":0},{"$f":"SUM(N70:N75)","v":0},null,0]
[]
[null,"Zimmer 27","Bett 1",null,null,{"$f":"IF($D$4-E77<$O$3,\"Kinder\",IF(AND($D$4-E77>$O$3,$D$4-E77<=$O$4),\"Jugend\",\" \"))","v":" "},{"$f":"O78","v":{"v":0,"d":"0%"}},{"$nulls":5},{"$f":"+B77","v":"Zimmer 27"},{"$f":"IF(D77>1,50,0)","v":0},null,null,0]
[null," -> Leiterzimmer\n       mit Du/WC","Bett 2",null,null,{"$f":"IF($D$4-E78<$O$3,\"Kinder\",IF(AND($D$4-E78>$O$3,$D$4-E78<=$O$4),\"Jugend\",\" \"))","v":" "},{"$nulls":7},{"$f":"IF(D78>1,50,0)","v":0},{"$f":"SUM(N77:N78)","v":0},null,0]
[{"$nulls":13},"zählenwenn","Summe"]
[null," Zusätzliche Betten (zusätzliche Matratzen in Zimmer…)"]
[null,"Zimmer-Nr.",null,"Name, Vorname","Geb-Data"]
[null,null,"Matratze 1",null,null,{"$f":"IF($D$4-E82<$O$3,\"Kinder\",IF(AND($D$4-E82>$O$3,$D$4-E82<=$O$4),\"Jugend\",\" \"))","v":" "},{"$nulls":6},{"$f":"+B82","v":0},{"$f":"IF(D82>1,17,0)","v":0},null,null,0]
[null,null,"Matratze 2",null,null," ",{"$nulls":7},{"$f":"IF(D83>1,17,0)","v":0},null,null,0]
[null,null,"Matratze 3",null,null," ",{"$nulls":7},0,null,null,0]
[null,null,"Matratze 4",null,null," ",{"$nulls":7},0,null,null,0]
[null,null,"Matratze 5",null,null," ",{"$nulls":7},0,null,null,0]
[null,null,"Matratze 6",null,null," ",{"$nulls":7},{"$f":"IF(D87>1,15,0)","v":0},{"$f":"SUM(N82:N87)","v":0},null,0]
[]
[null,"Total Gäste:",{"$nulls":3},{"$f":"Q91","v":{"v":0,"d":"0 Gäste"}}]
[]
[null,"\nFreies Feld für Kommentare / Bemerkungen:\nZeilenumbruch mit \"alt\" und \"Enter\"",{"$nulls":14},{"$f":"SUM(Q7:Q90)","v":0}]