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

{"sheet":"SJBZ","index":0,"n_rows":90,"n_cols":40,"rows_kept":90,"merged":[[0,1,0,3],[3,2,3,5],[4,2,4,5],[5,2,5,5],[6,2,6,5],[9,3,9,5],[11,3,11,5],[24,3,24,5],[25,3,25,5],[38,3,38,5],[89,1,91,7]]}
[null,"Richtofferte  \nG R U P P E N H Ä U S E R"]
[null,{"$f":"$C$4&\" mit Anreise vom \"&TEXT($C$9,\"TT.MM.JJJJ\")","v":"Gruppennamen mit Anreise vom 01.01.2020"},{"$nulls":32},"Liste -> ",null,"Anreise","Abreise","Pension"]
[]
[null,"  Gruppenname:","Gruppennamen"]
[null,"  Organisator/in:","Frau Muster Hanna",{"$nulls":31},1,null,"16:00h","10:00h","Selbstversorgung"]
[null,"  Telefon:","055 000 00 00",{"$nulls":31},2,null," - - - - - -"," - - - - - -"," - - - - - -"]
[null,"  E-Mail:","muster.hanna@email.ch",{"$nulls":31},3,null,"vor 14:00h","07:00-10:00h","inkl. Frühstück"]
[{"$nulls":34},4,null,"14:00-16:00h","10:00-12:00h","inkl. Halbpension"]
[null,"  Anreisetag:","2020-01-01",{"$f":"C9","v":"2020-01-01"},{"$nulls":22},{"$f":"+C11-C9","v":{"v":1,"d":"01"}},null,"Nächte / Aufenthalt",{"$nulls":5},5,null,"nach 16:00h","nach 12:00h","inkl. Vollpension"]
[null,"      Zeit der Anreise:","16:00h",{"$f":"IF(C10=AK6,\" bitte korrekte Zeit eingeben <!>\",IF(Z10=3,\"zusätzlicher Tag <!>\",IF(Z10=4,\"Zuschlag frühe Anreise\",\" \")))","v":" "},{"$nulls":3},{"$f":"AA10","v":{"v":0,"d":"0.00"}},{"$nulls":17},{"$f":"IF(C10=AK5,1,IF(C10=AK6,2,IF(C10=AK7,3,IF(C10=AK8,4,IF(C10=AK9,5,IF(C10=AK10,6,0))))))","v":1},{"$f":"IF(Z10=1,0,IF(Z10=2,150,IF(Z10=3,25*AJ20,IF(Z10=4,150,IF(AK10=5,0,0)))))","v":0},null,"Zuschlag frühe Anreise",{"$nulls":5},6]
[null,"  Abreisetag:","2020-01-02",{"$f":"C11","v":"2020-01-02"}]
[null,"      Zeit der Abreise:","10:00h",{"$f":"IF(Z12=2,\"bitte korrekte Zeit eingeben <!>\",IF(Z12=4,\"Zuschlag späte Abreise\",IF(Z12=5,\"zusätzliche Übernachtung <!>\",\" \")))","v":" "},{"$nulls":3},{"$f":"+AA12","v":{"v":0,"d":"0.00"}},{"$nulls":17},{"$f":"IF(C12=AL5,1,IF(C12=AL6,2,IF(C12=AL7,3,IF(C12=AL8,4,IF(C12=AL9,5,IF(C12=AL10,6,0))))))","v":1},{"$f":"IF(Z12=1,0,IF(Z12=2,150,IF(Z12=3,0,IF(Z12=4,150,IF(Z12=5,25*AJ20,0)))))","v":0},null,"Zuschlag späte Abreise"]
[{"$nulls":24},"Saisonermittlung"]
[null,null,"Saisonzeit:",null,null,{"$f":"IF(Y15=\"Hochtarif\",\"Normaltarif\",\"Normaltarif\")","v":"Normaltarif"},{"$nulls":18},{"$f":"MONTH(C9)","v":{"v":1,"d":"Monat: #1"}},{"$f":"IF(Y15=\"Niedertarif\",2,1)","v":2}," 1 = Hoch",{"$nulls":9},"Hoch (Apr.-Sept.)","Niedrig (Okt.-Mrz.)"]
[null,null,"Gesamtaufenthalt:",null,null,{"$f":"IF(AA9=1,AA9&\" Nacht\",IF(AA9=0,\" Tagesaufenthalt\",AA9&\" Nächte\"))","v":"1 Nacht"},{"$nulls":18},{"$f":"IF(AND(Y14>=4,Y14<=9),\"Hochtarif\",\"Niedertarif\")","v":"Niedertarif"},null," 2 = Tief",{"$nulls":7},"Self Hoch","Self Niedr.","Frühstück","Mittag","Abendessen"]
[{"$nulls":26},{"$f":"IF($Z$14=1,C18*AI16,C18*AJ16)","v":220},null,"Kosten pro Nacht",{"$nulls":5},27,22,10,15,17," -> Erwachsene"]
[{"$nulls":4},"pro Nacht","Total Aufenthalt",{"$nulls":20},{"$f":"IF($Z$14=1,C19*AI17,C19*AJ17)","v":0},null,"Kosten pro Nacht",{"$nulls":5},22,17,8,13,15," -> Jugendliche"]
[null,"Ü B E R N A C H T U N G",10,"ab 15 Jahre",{"$f":"IF($Z$14=1,25,25)","v":{"v":25,"d":"à CHF 25.00"}},{"$f":"+$AA$9*C18*E18","v":{"v":250,"d":"250.00"}},{"$nulls":20},{"$f":"IF($Z$14=1,C20*AI18,C20*AJ18)","v":0},null,"Kosten pro Nacht",{"$nulls":5},20,15,6,10,12," -> Kinder"]
[{"$f":"SUM(F18:F21)/AA9","v":{"v":250,"d":"250.00"}},null,null,"12-14 Jahre",{"$f":"IF($Z$14=1,22,22)","v":{"v":22,"d":"à CHF 22.00"}},{"$f":"+$AA$9*C19*E19","v":{"v":0,"d":"0.00"}},{"$nulls":11},"Basis pro Vermietung",{"$nulls":7},{"$f":"SUM(C18:C20)","v":10},{"$f":"IF($Z$14=1,C22*AI19,C22*AJ19)","v":0},null,"Brgn-Min.",{"$nulls":5},24,19]
[{"$f":"IF(A22>=20,700,550)","v":{"v":700,"d":"700.00"}},null,null,"06-11 Jahre",{"$f":"IF($Z$14=1,20,20)","v":{"v":20,"d":"à CHF 20.00"}},{"$f":"+$AA$9*C20*E20","v":{"v":0,"d":"0.00"}},{"$nulls":11},"Reinigung:",null,{"$f":"9*48","v":432},{"$nulls":6},{"$f":"SUM(AA16:AA19)/2","v":110},null,"Total Kosten pro Nacht durch 2",{"$nulls":6},{"$f":"IF(Z14=2,AJ16,AI16)","v":22}," = saisonaler Nachtpreis"]
[{"$f":"IF(C21>0,100/SUM(C18:C20)*C21,0)","v":{"v":0,"d":"0.00"}},null,null,"00-05 Jahre",{"$f":"IF(A21<=18,5,5)","v":{"v":5,"d":"à CHF 5.00"}},{"$f":"+$AA$9*C21*E21","v":{"v":0,"d":"0.00"}},{"$nulls":11},"Reinigung:",null,{"$f":"9*48","v":432},{"$nulls":6},{"$f":"SUM(AA17:AA20)/2","v":55},null,"Total Kosten pro Nacht durch 2",{"$nulls":6},{"$f":"IF(Z15=2,AJ17,AI17)","v":22}," = saisonaler Nachtpreis"]
[{"$f":"IF(C23>=1,100/SUM(C18:C20)*C18,0)","v":{"v":100,"d":"100%"}},null,{"$f":"IF(A22>=20,0,\"für Schulen ->\")","v":0},"Berechnungsmin.",{"$f":"IF(A22>=20,700,550)","v":{"v":700,"d":"CHF 700.-/Nacht"}},{"$f":"IF(A19<A20,(A20-A19)*AA9,0)","v":{"v":450,"d":"450.00"}},null,{"$f":"IF(C11-C9=0,1015,0)","v":{"v":0,"d":"0.00"}},{"$nulls":9},"Strom / Wasser:",null,80,{"$nulls":6},{"$f":"AA9+1","v":2},null,"Tage"]
[null,null,{"$f":"SUM(C18:C21)","v":10},{"$f":"IF($C$23<=48,\"Übernachtungsgäste insgesamt\",\"ein einzelnes Gruppenhaus hat Platz für max. 48 Gäste\")","v":"Übernachtungsgäste insgesamt"},{"$nulls":3},{"$f":"SUM(F18:F23)","v":{"v":700,"d":"700.00"}},{"$nulls":9},"Amortisation:",null,315]
[{"$nulls":3},{"$f":"IF(AND(C23>48,C23<=65),\"warum nicht Pilgerzimmer, anstatt ein zweites Gruppenhaus?\",\"\")","v":""},{"$nulls":13},"Administration",null,90]
[{"$nulls":3},{"$f":"IF(AND(AA9>=5,AA9<10),8,0)+IF(AND(AA9>=10,AA9<50),12,0)","v":{"v":0,"d":"0% Rabatt Langzeitaufenthalt"}},{"$nulls":3},{"$f":"IF(AND(AA9>=5,AA9<10),-H23*0.08,0)+IF(AND(AA9>=10,AA9<50),-H23*0.12,0)","v":{"v":0,"d":"0.00"}},{"$nulls":14},"Kue-Miete","HP pro Tag","pro Tag","An-ab","Total"]
[{"$nulls":3},{"$f":"IF(AA9<=2,\"Zuschlag Kurzaufenthalte von 1-2 Nächten\",0)","v":"Zuschlag Kurzaufenthalte von 1-2 Nächten"},{"$nulls":3},{"$f":"IF(AA9<=2,100,0)","v":{"v":100,"d":"100.00"}},{"$nulls":11},{"$f":"SUM(T20:T25)","v":1349},{"$nulls":3},0,95,-60,{"$f":"IF(C31=AM8,(AA22*X26),(AA22*Y26+Z26))","v":130},null,"Total Küchenmiete"]
[]
[null,null,"Total Übernachtung",{"$nulls":4},{"$f":"SUM(H4:H27)","v":{"v":800,"d":"800.00"}}]
[]
[]
[null,"V E R P F L E G U N G","Selbstversorgung",{"$f":"IF(C31=\"Selbstversorgung\",\"inkl. Küchenmiete während \"&AA22&\" Tagen\",\"ohne Küchenmiete\")","v":"inkl. Küchenmiete während 2 Tagen"},null,null,{"$f":"IF(C31=\"Selbstversorgung\",0,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(C31=\"Selbstversorgung\",((AA9+1)*G31),0)","v":{"v":0,"d":"0.00"}},{"$nulls":17},{"$f":"IF(C31=AM9,C18*AL16+C19*AL17+C20*AL18,0)","v":0},null,null,"Preis pro ME pro Tag"]
[]
[null,null,"  Pensionsleistung:","nur Frühstück","inkl. HP","inkl. VP"]
[null,null,{"$f":"+C18","v":{"v":10,"d":"10x  |  ab 15 Jahre"}},{"$f":"IF($C$23>35,10,10)","v":{"v":10,"d":"à CHF 10.00"}},{"$f":"IF($C$23>35,27,27)","v":{"v":27,"d":"à CHF 27.00"}},{"$f":"+E34+13","v":{"v":40,"d":"à CHF 40.00"}},null,{"$f":"IF(C31=AM7,(D34*$AA$9*C34),IF(C31=AM8,(E34*$AA$9*C34),IF(C31=AM9,(F34*$AA$9*C34),0)))","v":{"v":0,"d":"0.00"}}]
[null,null,{"$f":"IF(C19<=0,1E-25,C19)","v":{"v":1E-25,"d":"00x  |  12-14 Jahre"}},{"$f":"IF($C$38>25,7,7)","v":{"v":7,"d":"à CHF 07.00"}},{"$f":"IF($C$23>35,21,21)","v":{"v":21,"d":"à CHF 21.00"}},{"$f":"+E35+11","v":{"v":32,"d":"à CHF 32.00"}},null,{"$f":"IF(C31=AM7,(D35*$AA$9*C35),IF(C31=AM8,(E35*$AA$9*C35),IF(C31=AM9,(F35*$AA$9*C35),0)))","v":{"v":0,"d":"0.00"}}]
[null,null,{"$f":"IF(C20<=0,1E-25,C20)","v":{"v":1E-25,"d":"00x  |  06-11 Jahre"}},{"$f":"IF($C$38>25,6,6)","v":{"v":6,"d":"à CHF 06.00"}},{"$f":"IF($C$23>35,18,18)","v":{"v":18,"d":"à CHF 18.00"}},{"$f":"+E36+10","v":{"v":28,"d":"à CHF 28.00"}},null,{"$f":"IF(C31=AM7,(D36*$AA$9*C20),IF(C31=AM8,(E36*$AA$9*C20),IF(C31=AM9,(F36*$AA$9*C20),0)))","v":{"v":0,"d":"0.00"}}]
[null,null,{"$f":"IF(C21<=0,1E-25,C21)","v":{"v":1E-25,"d":"00x  |  00-05 Jahre"}},{"$f":"IF($C$38>25,5,5)","v":{"v":5,"d":"à CHF 05.00"}},{"$f":"IF($C$23>35,10,10)","v":{"v":10,"d":"à CHF 10.00"}},{"$f":"+E37+5","v":{"v":15,"d":"à CHF 15.00"}},null,{"$f":"IF(C32=AM8,(D37*$AA$9*C21),IF(C32=AM9,(E37*$AA$9*C21),IF(C32=AM10,(F37*$AA$9*C21),0)))","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":3},{"$f":"IF(C23>=30,\"5% Ermässigung auf Pension, ab 30 GeniesserInnen\",0)","v":{"v":0,"d":"0% Rabatt Langzeitaufenthalt"}},{"$nulls":3},{"$f":"IF(C23>=30,-SUM(H33:H38)/100*5,0)","v":{"v":0,"d":"0.00"}},{"$nulls":17},{"$f":"IF(C31=AM8,C18*AM16+C19*AM17+C20*AM18,IF(C31=AM9,C18*AM16+C19*AM17+C20*AM18,0))","v":0},null,null,"Preis pro AE pro Tag"]
[]
[null,null,"Total Verpflegung",{"$nulls":4},{"$f":"SUM(H31:H39)","v":{"v":0,"d":"0.00"}}]
[]
[null,null,"Zwischentotal Aufenthalt",{"$nulls":4},{"$f":"+H28+H41","v":{"v":800,"d":"800.00"}}]
[]
[]
[]
[]
[]
[null,"Ü B E R T R A G","Total Übernachtung",null,null,{"$f":"+H28","v":{"v":800,"d":"800.00"}}]
[null,null,"Total Verpflegung",null,null,{"$f":"+H41","v":{"v":0,"d":"0.00"}},null,{"$f":"SUM(F49:F50)","v":{"v":800,"d":"800.00"}}]
[]
[]
[null," Z U S Ä T Z E "," S C H L A F E N"]
[]
[null,null," -> Kissen, Kissenbezug, Fixleintuch",null,{"$f":"+C23","v":{"v":10,"d":"10stk."}},null,null,"inklusiv",{"$nulls":18},{"$f":"IF(#REF!=AK55,250,\"0.00\")","v":{"$error":"#REF!"}},{"$nulls":9},"durch Hotel-MA",null,null,250]
["besenrein",null," -> Abgabe (besenrein oder gereinigt)",null,"besenrein",{"v":290,"d":"CHF   290.00"},null,{"$f":"IF(E56=\"besenrein\",F56,0)","v":{"v":290,"d":"290.00"}},{"$nulls":18},{"$f":"IF(#REF!=AK56,250,\"0.00\")","v":{"$error":"#REF!"}},{"$nulls":9},"durch Hotel-MA",null,null,250]
["gereinigt",null,{"$f":"IF(E56=\"gereinigt\",\"      Hausabgabe anstatt bis 10h bis 12h | Nachreinigung SJBZ CHF 65.-/h\",\"\")","v":""}]
[]
[null,null," -> Miete Duvets",null,null,{"v":15,"d":"CHF   15.00"},null,{"$f":"+E59*F59","v":{"v":0,"d":"0.00"}},{"$nulls":18},{"$f":"IF(#REF!=AK59,250,\"0.00\")","v":{"$error":"#REF!"}},{"$nulls":9},"durch Hotel-MA",null,null,250]
[null,null," -> Miete Wolldecken",null,null,{"v":8,"d":"CHF   08.00"},{"$nulls":30},"durch Lager-TN"]
[null,null," -> Bettenbezug durch Allegro-Team",null,"NEIN",{"v":6,"d":"CHF   06.00"},null,{"$f":"IF(E61=\"JA\",F61*C23,0)","v":{"v":0,"d":"0.00"}},{"$nulls":18},{"$f":"IF(#REF!=AK61,250,\"0.00\")","v":{"$error":"#REF!"}},{"$nulls":9},"durch Hotel-MA",null,null,250]
[null,null," -> Hunde (Anzahl Tiere & Nächte)",null,null,{"v":10,"d":"CHF   10.00"},null,{"$f":"E62*F62*AA9","v":{"v":0,"d":"0.00"}}]
[]
["NEIN",null," -> Tägliche Kurz-Reinigung Duschen/WC",null,"NEIN",{"v":35,"d":"CHF   35.00/d"},null,{"$f":"IF(AND(E64=\"JA\",AA9>2),(AA9-2)*F64,0)","v":{"v":0,"d":"0.00"}}]
["JA",null," -> WC- & Handtuchpapier, Handseife",null,"NEIN",{"v":0.5,"d":"CHF   00.50"},null,{"$f":"IF(E65=\"JA\",F65*C23*(AA9-1),IF(E64=\"JA\",F65*C23*(AA9-1),0))","v":{"v":0,"d":"0.00"}}]
[]
[null,null," G E N I E S S E N"]
[]
[null,null," -> 20 Trocknungstücher / 20 Lappen",null,"NEIN",{"v":20,"d":"CHF   20.00"},null,{"$f":"IF(E69=\"JA\",F69,0)","v":{"v":0,"d":"0.00"}}]
[null,null," -> Feuerholz für Feuerstelle",null,null,{"v":15,"d":"CHF   15.00"},null,{"$f":"+E70*F70","v":{"v":0,"d":"0.00"}}]
[null,null," -> Holzkohlegrill \"Tonne\" samt 10kg Kohle",null,null,{"v":25,"d":"CHF   25.00"},null,{"$f":"+E71*F71","v":{"v":0,"d":"0.00"}}]
[]
[null,null," -> Zusätzliches Frühstück am…",null,null,"14.-  | 10.-  | 5.-",null,{"$f":"IF(E73>10000,($C$34*14)+(SUM($C$35:$C$36)*10)+($C$37*5),0)","v":{"v":0,"d":"0.00"}}]
[null,null," -> Zusätzliches Mittagessen am…",null,null,"20.-  | 16.-  | 5.-",null,{"$f":"IF(E74>10000,($C$34*20)+(SUM($C$35:$C$36)*16)+($C$37*5),0)","v":{"v":0,"d":"0.00"}}]
[null,null," -> Zusätzliches Abendessen am…",null,null,"22.-  | 17.-  | 5.-",null,{"$f":"IF(E75>10000,($C$34*22)+(SUM($C$35:$C$36)*17)+($C$37*5),0)","v":{"v":0,"d":"0.00"}}]
[]
[null,null," -> Externe Gäste für Party am…",null,null,{"v":400,"d":"CHF   400.00/d"},null,{"$f":"IF(E77>0,F77,0)","v":{"v":0,"d":"0.00"}}]
[]
[null,null," R E C H N E N"]
[]
["Gesamtgruppe",null," -> Reservation über…",null,"Gesamtgruppe",{"$f":"IF(E81=\"Gesamtgruppe\",\"inkl.\",5*C18)","v":"inkl."},null,{"$f":"IF(E81=\"Einzelpersonen\",F81,0)","v":{"v":0,"d":"0.00"}}]
["Einzelpersonen",null," -> Rechnungsstellung über…",null,"Gesamtgruppe",{"$f":"IF(E82=\"Gesamtgruppe\",\"inkl.\",5*C18)","v":"inkl."},null,{"$f":"IF(E82=\"Einzelpersonen\",F82,0)","v":{"v":0,"d":"0.00"}}]
[]
[null,null," Total Leistungen / Richtofferte  (in CHF, inkl. Kurtaxen & MwSt.)",{"$nulls":4},{"$f":"SUM(H49:H82)","v":{"v":1090,"d":"1,090.00"}}]
[]
[null,null," Achtung, es handelt sich hierbei um eine unverbindliche Richtofferte. "]
[null,null," Bei Interesse stellt Ihnen das SJBZ-Team gerne eine konkrete Offerte zusammen. "]
[]
[]
[null,"\nB E M E R K U N G E N\nNeue Zeile mit \"alt\"-Taste und \"Enter\"-Taste"]