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

{"sheet":"Tagesbeitrag","index":0,"n_rows":45,"n_cols":10,"rows_kept":45,"merged":[[0,0,2,2],[6,0,6,2],[9,10,9,11]]}
["Tageszentren Linz"]
[]
[]
[]
[]
[]
["Berechnung Tagesbeitrag"]
[]
["Einkommen","Besucher Betrag","Ehegatte Betrag"]
["Pension(en) abzüglich Pflegegeld",0,{"$nulls":7},{"$f":"#REF!&D38","v":{"$error":"#REF!"}}]
["Witwenpension",0]
[]
["Sozialhilfe"]
["Ausgleichzulage",{"$nulls":3},"Kostenbeitrag","Betrag"]
["Unterhaltsleistung",{"$nulls":3},"Grundbeitrag",{"$f":"IF(C20=0,IF(B36<1217.96,1.84,IF(B36<1317.96,3.73,IF(B36<1417.96,5.57,IF(B36<1517.96,9.3,IF(B36<1617.96,13.96,IF(B36<1717.96,18.6,IF(B36<1817.96,23.25,IF(B36<1917.96,27.96,IF(B36<2017.96,32.53,IF(B36<2117.96,37.16,IF(B36<2217.96,39.95,IF(B36<2317.96,44.4,IF(B36<2417.96,50.43,IF(B36<2517.96,58.85,IF(B36>2517.96,66.92))))))))))))))),IF(C20>0,IF(B36<1921.46,1.84,IF(B36<2021.46,3.73,IF(B36<2121.46,5.57,IF(B36<2221.46,9.3,IF(B36<2321.46,13.96,IF(B36<2421.46,18.6,IF(B36<2521.46,23.25,IF(B36<2621.46,27.93,IF(B36<2721.46,32.53,IF(B36<2821.46,37.16,IF(B36<2921.46,39.95,IF(B36<3021.46,44.4,IF(B36<3121.46,50.43,IF(B36<3212.46,58.85,IF(B36>3212.46,66.92)))))))))))))))))","v":1.84}]
["Mietziens- bzw- Wohnbeihilfe",{"$nulls":3},"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}]
["Vermietung/Verpachtung",{"$nulls":3},"Essen",{"$f":"SUM(C39+C40+C41)","v":{"v":0,"d":"0.00"}}]
["Sonstige",{"$nulls":3},"Fahrt",{"$f":"SUM(C44+C45)","v":0}]
[{"$nulls":4},"Tagesbeitrag",{"$f":"SUM(F15+F16+F17+F18)","v":1.84}]
["Gesamteinnahmen",{"$f":"SUM(B10:B19)","v":0},{"$f":"SUM(C10:C19)","v":0}]
[null,null,{"$f":"SUM(B20:C20)","v":0}]
[]
["Pflegegeld-Stufe",0]
["Auszahlende Stelle"]
[]
["Ausgaben","Betrag"]
["Miete inkl. Betriebskosten oder Pauschale & BK",0]
["Heizung (Beleg oder Pauschale)",0]
["Unterhaltszahlungen",0]
["Heimkosten f. Gatte",0]
["Einkommenssteuer",0]
[]
[]
["Gesamtausgaben",{"$f":"SUM((IF(B27+B28>550,550,IF(B27+B28<550,B27+B28))),B29+B30+B31)","v":{"v":0,"d":"0.00"}}]
[]
["Bemessungsgrundlage",{"$f":"C21-B34","v":0}]
[]
["Essen im Tageszentrum","ja/nein","Kosten"]
["Frühstück","nein",{"$f":"IF(B39=\"ja\",4.28,0)","v":{"v":0,"d":"0.00"}}]
["Mittagessen","nein",{"$f":"IF(B40=\"ja\",7.17,0)","v":0}]
["Kaffeejause","nein",{"$f":"IF(B41=\"ja\",2.87,0)","v":0}]
[]
["Transport","ja/nein","Kosten"]
["Von zuhause in das Tageszentrum","nein",{"$f":"IF(B44=\"ja\",7.03,0)","v":0}]
["Vom Tageszentrum nach Hause","nein",{"$f":"IF(B45=\"ja\",7.03,0)","v":0}]

{"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,3.84]
["bis","bis 1825,71 -> 4,67",4.67,null,7.08]
["bis","bis 1925,71 -> 7,79",7.79,null,11.03]
["bis","bis 2025,71 -> 11,70",{"v":11.7,"d":"11.70"},null,16.54]
["bis","bis 2125,71 -> 15,58",15.58,null,22.47]
["bis","bis 2225,71 -> 19,48",19.48,null,31.38]
["bis","bis 2325,71 -> 23,40",{"v":23.4,"d":"23.40"},null,41.23]
["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]