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

{"sheet":"Tabelle1","index":0,"n_rows":51,"n_cols":10,"rows_kept":51,"merged":[[0,0,2,2],[6,0,6,3],[9,10,9,11],[24,2,24,3],[25,2,25,3]]}
["Tageszentren Linz"]
[]
[]
[]
[]
[]
["Berechnung Tagesbeitrag 2025"]
[]
["Einkommen","Besucher Betrag","Ehegatte Betrag","Erklärung:"]
["Pension(en) abzüglich Pflegegeld",0,0,"Bitte alle ",{"$nulls":5},{"$f":"#REF!&#REF!","v":{"$error":"#REF!"}}]
["Witwenpension",0,null,"Einkünfte pro Monat"]
[{"$nulls":3},"in den Spalten"]
["Sozialhilfe (falls vornanden)",null,null,"angeben"]
["Ausgleichzulage (falls vornanden)"]
["Unterhaltsleistung (falls vornanden)"]
["Mietziens- bzw- Wohnbeihilfe (falls vornanden)"]
["Vermietung/Verpachtung (falls vornanden)"]
["Sonstige"]
[]
["Gesamteinnahmen",{"$f":"SUM(B10:B19)","v":0},{"$f":"SUM(C10:C19)","v":0}]
[null,null,{"$f":"SUM(B20:C20)","v":0}]
[]
["Pflegegeld-Stufe (fals vorhanden)",0]
[]
["Ausgaben pro Monat","Betrag","Erklärung:"]
["Miete inkl. Betriebskosten ",0,"> Falls Eigentum, den Wert \"234,29\" mit"]
["Heizung",0,"den Betriebskosten addieren und eintragen"]
["Unterhaltszahlungen (falls vornanden)",0]
["Heimkosten f. Gatte (falls vornanden)",0]
["Einkommenssteuer (falls vornanden)",0]
[]
[]
["Gesamtausgaben",{"$f":"SUM((IF(B26+B27>550,550,IF(B26+B27=550,550,IF(B26+B27<550,B26+B27)))),B28+B29+B30)","v":{"v":0,"d":"0.00"}}]
[]
["Bemessungsgrundlage",{"$f":"C21-B33","v":0}]
[]
["Essen im Tageszentrum","ja/nein","Kosten","Erklärung"]
["Frühstück","ja",{"$f":"IF(B38=\"ja\",4.74,0)","v":4.74},"Mittagessen ist "]
["Mittagessen (verpflichtend)","ja",7.94,"verpflichtend"]
["Kaffeejause","ja",{"$f":"IF(B40=\"ja\",3.17,0)","v":3.17},"Bei Frühstück &"]
[{"$nulls":3},"Kaffeejause und"]
["Transport","ja/nein","Kosten","auch bei Transport"]
["Von zuhause in das Tageszentrum","ja",{"$f":"IF(B43=\"ja\",7.78,0)","v":7.78},"\"ja\" oder \"nein\""]
["Vom Tageszentrum nach Hause","ja",{"$f":"IF(B44=\"ja\",7.78,0)","v":7.78},"eintragen"]
[]
[null,"Kostenbeitrag","Betrag"]
[null,"Grundbeitrag",{"$f":"IF(C20=0,IF(B35<1273.99,2.04,IF(B35<1373.99,4.13,IF(B35<1473.99,6.17,IF(B35<1573.99,10.3,IF(B35<1673.99,15.45,IF(B35<1773.99,20.59,IF(B35<1873.99,25.74,IF(B35<1973.99,30.92,IF(B35<2073.99,36.01,IF(B35<2173.99,41.14,IF(B35<2273.99,44.22,IF(B35<2373.99,49.15,IF(B35<2473.99,55.83,IF(B35<2573.99,65.15,IF(B35>2573.99,74.08))))))))))))))),IF(C20>0,IF(B35<2009.85,2.04,IF(B35<2109.85,4.13,IF(B35<2209.85,6.17,IF(B35<2309.85,10.3,IF(B35<2409.85,15.45,IF(B35<2509.85,20.59,IF(B35<2609.85,25.74,IF(B35<2709.85,30.92,IF(B35<2809.85,36.01,IF(B35<2909.85,41.14,IF(B35<3009.85,44.22,IF(B35<3109.85,49.15,IF(B35<3209.85,55.83,IF(B35<3309.85,65.15,IF(B35>3309.85,74.08)))))))))))))))))","v":2.04}]
[null,"Beitrag des PG",{"$f":"IF(B23=0,Tabelle2!E19,IF(B23=1,Tabelle2!E20,IF(B23=2,Tabelle2!E21,IF(B23=3,Tabelle2!E22,IF(B23=4,Tabelle2!E23,IF(B23=5,Tabelle2!E24,IF(B23=6,Tabelle2!E25,IF(B23=7,Tabelle2!E26))))))))","v":0}]
[null,"Essen",{"$f":"SUM(C38+C39+C40)","v":15.85}]
[null,"Fahrt",{"$f":"SUM(C43+C44)","v":15.56}]
[null,"Tagesbeitrag",{"$f":"SUM(C47+C48+C49+C50)","v":33.45}]

{"sheet":"Tabelle2","index":1,"n_rows":33,"n_cols":11,"rows_kept":33,"hidden":true,"merged":[[0,0,0,2],[1,0,1,1],[1,4,1,5],[2,4,2,5],[17,0,17,1]]}
["Bemessungsgrundlage Werte 2022"]
["Alleinstehende",null,"Grundbeitrag",null,"Eigentümerpauschale ",null,189.51,null,null,"Alleinstehende","Ehepaare"]
["unter","unter 1030,49 -> 1,54",1.54,null,"Heizkostenpauschale",null,75.31,null,null,"unter 1030,49 -> 1,54","unter 1625,71 -> 1,54"]
["bis","bis 1130,49 -> 3,12",3.12,null,"Unterhaltsberechtigte Kinder","bis zum 24. LJ",379.02,null,null,"bis 1130,49 -> 3,12","bis 1725,71 -> 3,12"]
["bis","bis 1230,49 -> 4,67",4.67,null,null,"ab dem 25. LJ",673.53,null,null,"bis 1230,49 -> 4,67","bis 1825,71 -> 4,67"]
["bis","bis 1330,49 -> 7,79",7.79,{"$nulls":6},"bis 1330,49 -> 7,79","bis 1925,71 -> 7,79"]
["bis","bis 1430,49 -> 11,70",{"v":11.7,"d":"11.70"},null,"Essen","gesamt",{"v":12,"d":"12.00"},null,null,"bis 1430,49 -> 11,70","bis 2025,71 -> 11,70"]
["bis","bis 1530,49 -> 15,58",15.58,null,null,"Frühstück",3.59,null,null,"bis 1530,49 -> 15,58","bis 2125,71 -> 15,58"]
["bis","bis 1630,49 -> 19,48",19.48,null,null,"Mittag",6.01,null,null,"bis 1630,49 -> 19,48","bis 2225,71 -> 19,48"]
["bis","bis 1730,49 -> 24,40",{"v":23.4,"d":"23.40"},null,null,"Jause",{"v":2.4,"d":"2.40"},null,null,"bis 1730,49 -> 24,40","bis 2325,71 -> 23,40"]
["bis","bis 1830,49 -> 27,25",27.25,{"$nulls":3},{"$f":"G8+G9","v":{"v":9.6,"d":"9.60"}},null,null,"bis 1830,49 -> 27,25","bis 2425,71 -> 27,25"]
["bis","bis 1930,49 -> 31,13",31.13,{"$nulls":3},{"$f":"G9+G10","v":8.41},null,null,"bis 1930,49 -> 31,13","bis 2525,71 -> 31,13"]
["bis","bis 2030,49 -> 33,47",33.47,{"$nulls":6},"bis 2030,49 -> 33,47","bis 2625,71 -> 33,47"]
["bis","bis 2130,49 -> 37,20",{"v":37.2,"d":"37.20"},{"$nulls":6},"bis 2130,49 -> 37,20","bis 2725,71 -> 37,20"]
["bis","bis 2230,49 -> 42,26",42.26,null,"Fahrt","gesamt",11.78,null,null,"bis 2230,49 -> 42,26","bis 2825,71 -> 42,26"]
["bis","bis 2330,49 -> 48,76",48.76,null,null,"Einzel",5.89,null,null,"bis 2330,49 -> 48,76","bis 2925,71 -> 48,76"]
["über","über 2330,49 -> 56,06",56.06,{"$nulls":6},"über 2330,49 -> 56,06","über 2925,71 -> 56,06"]
["Ehepaare",null,"Grundbeitrag",null,"Pflegegeld"]
["unter","unter 1625,71 -> 1,54",1.54,null,{"v":0,"d":"0.00"}]
["bis","bis 1725,71 -> 3,12",3.12,null,4.02]
["bis","bis 1825,71 -> 4,67",4.67,null,7.41]
["bis","bis 1925,71 -> 7,79",7.79,null,11.54]
["bis","bis 2025,71 -> 11,70",{"v":11.7,"d":"11.70"},null,{"v":17.3,"d":"17.30"}]
["bis","bis 2125,71 -> 15,58",15.58,null,{"v":23.5,"d":"23.50"}]
["bis","bis 2225,71 -> 19,48",19.48,null,32.82]
["bis","bis 2325,71 -> 23,40",{"v":23.4,"d":"23.40"},null,43.13]
["bis","bis 2425,71 -> 27,25",27.25]
["bis","bis 2525,71 -> 31,13",31.13]
["bis","bis 2625,71 -> 33,47",33.47]
["bis","bis 2725,71 -> 37,20",{"v":37.2,"d":"37.20"}]
["bis","bis 2825,71 -> 42,26",42.26]
["bis","bis 2925,71 -> 48,76",48.76]
["über","über 2925,71 -> 56,06",56.06]