{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Kurzanleitung","Monatliches Haushaltsbudget","Haushaltsbudgets im Vergleich","Daten","Monatliches Haushaltsbudget_p","Haushaltsbudgets im Vergleich_p"],"not_rendered":{"charts":0,"images":13,"macros":1,"external_links":0,"defined_names":7,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Kurzanleitung","index":0,"n_rows":27,"n_cols":9,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,null,null,null,null,null,null,"AUSWERTUNG SPIELLEITUNG"]
[null,null,"KURZANLEITUNG"]
[]
[null,null,"ANMERKUNG: ",null,null,"Die Arbeit mit dem Computer und/oder den ausgedruckten Dokumenten «Monatliches Haushaltsbudget» und «Haushaltsbudget im"]
[null,null,null,null,null,"Vergleich» wird empfohlen, ist allerdings nicht zwingend. "]
[]
[null,null,"«Monatliches Haushaltsbudget»",null,null,null,null,"Mit diesem Register wird das monatliche Hashaltsbudget dargstellt und kann mit den durchschnittlichen "]
[null,null,null,null,null,null,null,"Ausgaben eines schweizerischen Haushalts verglichen werden. "]
[null,null,null,null,null,null,null,"1. Tragen Sie in den grünen Spalten ihre Vorschläge über die Ausgabenverteilung Ihres zugewiesenen Haushalts ein."]
[null,null,null,null,null,null,null,"2. In den grauen Spalten stehen als Vergleichswert die durchschnittlichen Ausgaben des jeweiligen schweizerischen "]
[null,null,null,null,null,null,null,"    Haushalts. Wählen Sie in der Dropdown-Liste das gewünschte Haushaltsprofil aus. "]
[null,null,null,null,null,null,null,"3. Der Prozentsatz unter «Übereinstimmung» zeigt auf, wie sehr Ihr Vorschlag mit dem schweizerischen"]
[null,null,null,null,null,null,null,"    Durchschnitt übereinstimmt."]
[]
[null,null,"«Haushaltsbudget im Vergleich»",null,null,null,null,"Dieses Register vergleicht die Verteilung der Ausgaben pro Budgetposten von zwei verschiedenen "]
[null,null,null,null,null,null,null,"Haushaltsprofilen. Konkret werden die Einnahmen, Ausgaben (Steuern, Gesundheit, etc.) sowie der Restbetrag "]
[null,null,null,null,null,null,null,"(Sparen/Schulden) miteinander verglichen. Um ein Haushaltsprofil auszuwählen, klicken Sie auf das "]
[null,null,null,null,null,null,null,"entsprechende Schaltfeld neben «Budget 1» bzw. «Budget 2» und suchen Sie das gewünschte Profil in der"]
[null,null,null,null,null,null,null,"Dropdown-Liste."]
[]
[null,null,"«Monatliches Haushaltsbudget_p»",null,null,null,null,"Dieses Register kommt als ausgedrucktes Dokument zum Einsatz. In den grünen Spalten können Sie Ihre "]
[null,null,null,null,null,null,null,"Vorschläge für die Budgetplanung Ihres zugewiesenen Haushalts machen."]
[]
[null,null,"«Haushaltsbudget im Vergleich_p»",null,null,null,null,"Dieses Register kommt als ausgedrucktes Dokument zum Einsatz. Es gewährt einen Überblick über die "]
[null,null,null,null,null,null,null,"Einkommensströme, Ausgabenstruktur sowie die Restbeträge der 10 Haushaltsprofile. "]

{"sheet":"Monatliches Haushaltsbudget","index":1,"n_rows":31,"n_cols":11,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,null,"Vorschlag",null,null,"Schweizer Durchschnitt",null,null,null,"Übereinstimmung"]
[null,null,null,"Lernende",null,null,"Bundesamt für Statistik",null,null,null,{"$f":"1-SUM(I10:I31)","v":1}]
[]
[]
["Einnahmen",null,{"$f":"Daten!$B$12","v":"Verfügbares Einkommen"},null,{"$f":"IF($D$7,SUM(D7)/$D$7,0)","v":0},null,{"$f":"INDEX(Daten!$D12:$N12,1,Daten!$A$56)","v":0},{"$f":"IF($G$7,SUM(G7:G7)/$G$7,0)","v":0}]
[null,{"$f":"Daten!$A13","v":0}]
[null,{"$f":"Daten!$A9","v":0}]
["Ausgaben",{"$f":"Daten!$A15","v":1},{"$f":"Daten!$B15","v":"Steuern "},null,{"$f":"IF($D$7,SUM(D10)/$D$7,0)","v":0},null,{"$f":"ABS(INDEX(Daten!$D15:$N15,1,Daten!$A$56))","v":0},{"$f":"IF($G$7,SUM(G10:G10)/$G$7,0)","v":0},{"$f":"ABS(H10-E10)","v":0},"Steuern für Bund, Kanton und Gemeinde, amtliche Gebühren"]
[null,{"$f":"Daten!$A16","v":0},{"$f":"Daten!$B16","v":0}]
[null,{"$f":"Daten!$A17","v":2},{"$f":"Daten!$B17","v":"Gesundheit"},null,{"$f":"IF($D$7,SUM(D12)/$D$7,0)","v":0},null,{"$f":"ABS(INDEX(Daten!$D17:$N17,1,Daten!$A$56))","v":0},{"$f":"IF($G$7,SUM(G12:G12)/$G$7,0)","v":0},{"$f":"ABS(H12-E12)","v":0},"Krankenkassenprämien, Arztbesuche, Medikamente"]
[null,{"$f":"Daten!$A18","v":0},{"$f":"Daten!$B18","v":0}]
[null,{"$f":"Daten!$A19","v":3},{"$f":"Daten!$B19","v":"Unterstützungen & Geschenke"},null,{"$f":"IF($D$7,SUM(D14)/$D$7,0)","v":0},null,{"$f":"ABS(INDEX(Daten!$D19:$N19,1,Daten!$A$56))","v":0},{"$f":"IF($G$7,SUM(G14:G14)/$G$7,0)","v":0},{"$f":"ABS(H14-E14)","v":0},"Einladungen, Spenden, Alimente, Unterstützungsbeiträge"]
[null,{"$f":"Daten!$A20","v":0},{"$f":"Daten!$B20","v":0}]
[null,{"$f":"Daten!$A21","v":4},{"$f":"Daten!$B21","v":"Wohnen"},null,{"$f":"IF($D$7,SUM(D16)/$D$7,0)","v":0},null,{"$f":"ABS(INDEX(Daten!$D21:$N21,1,Daten!$A$56))","v":0},{"$f":"IF($G$7,SUM(G16:G16)/$G$7,0)","v":0},{"$f":"ABS(H16-E16)","v":0},"Wohnung, Energie"]
[null,{"$f":"Daten!$A22","v":0},{"$f":"Daten!$B22","v":0}]
[null,{"$f":"Daten!$A23","v":5},{"$f":"Daten!$B23","v":"Ernährung"},null,{"$f":"IF($D$7,SUM(D18)/$D$7,0)","v":0},null,{"$f":"ABS(INDEX(Daten!$D23:$N23,1,Daten!$A$56))","v":0},{"$f":"IF($G$7,SUM(G18:G18)/$G$7,0)","v":0},{"$f":"ABS(H18-E18)","v":0},"Essen, Trinken"]
[null,{"$f":"Daten!$A24","v":0},{"$f":"Daten!$B24","v":0}]
[null,{"$f":"Daten!$A25","v":6},{"$f":"Daten!$B25","v":"Bekleidung & Körperpflege"},null,{"$f":"IF($D$7,SUM(D20)/$D$7,0)","v":0},null,{"$f":"ABS(INDEX(Daten!$D25:$N25,1,Daten!$A$56))","v":0},{"$f":"IF($G$7,SUM(G20:G20)/$G$7,0)","v":0},{"$f":"ABS(H20-E20)","v":0},"Kleidung, Schuhe, Hygieneprodukte, Coiffeur"]
[null,{"$f":"Daten!$A26","v":0},{"$f":"Daten!$B26","v":0}]
[null,{"$f":"Daten!$A27","v":7},{"$f":"Daten!$B27","v":"Haushalt & Lebensversicherung"},null,{"$f":"IF($D$7,SUM(D22)/$D$7,0)","v":0},null,{"$f":"ABS(INDEX(Daten!$D27:$N27,1,Daten!$A$56))","v":0},{"$f":"IF($G$7,SUM(G22:G22)/$G$7,0)","v":0},{"$f":"ABS(H22-E22)","v":0},"Einrichtung, Haushaltsführung, Versicherungen"]
[null,{"$f":"Daten!$A28","v":0},{"$f":"Daten!$B28","v":0}]
[null,{"$f":"Daten!$A29","v":8},{"$f":"Daten!$B29","v":"Mobilität"},null,{"$f":"IF($D$7,SUM(D24)/$D$7,0)","v":0},null,{"$f":"ABS(INDEX(Daten!$D29:$N29,1,Daten!$A$56))","v":0},{"$f":"IF($G$7,SUM(G24:G24)/$G$7,0)","v":0},{"$f":"ABS(H24-E24)","v":0},"Individueller und öffentlicher Verkehr"]
[null,{"$f":"Daten!$A30","v":0},{"$f":"Daten!$B30","v":0}]
[null,{"$f":"Daten!$A31","v":9},{"$f":"Daten!$B31","v":"Kommunikation & Elektronik"},null,{"$f":"IF($D$7,SUM(D26)/$D$7,0)","v":0},null,{"$f":"ABS(INDEX(Daten!$D31:$N31,1,Daten!$A$56))","v":0},{"$f":"IF($G$7,SUM(G26:G26)/$G$7,0)","v":0},{"$f":"ABS(H26-E26)","v":0},"Telefonie, Internet, TV, Computer"]
[null,{"$f":"Daten!$A32","v":0},{"$f":"Daten!$B32","v":0}]
[null,{"$f":"Daten!$A33","v":10},{"$f":"Daten!$B33","v":"Freizeit & Bildung"},null,{"$f":"IF($D$7,SUM(D28)/$D$7,0)","v":0},null,{"$f":"ABS(INDEX(Daten!$D33:$N33,1,Daten!$A$56))","v":0},{"$f":"IF($G$7,SUM(G28:G28)/$G$7,0)","v":0},{"$f":"ABS(H28-E28)","v":0},"Ausgang, Ferien, Hobbys, Bildung"]
[null,{"$f":"Daten!$A34","v":0}]
[null,{"$f":"Daten!$A35","v":0}]
["Restbetrag",null,"Sparen/Schulden",{"$f":"D7-SUM(D10:D28)","v":0},{"$f":"IF($D$7,SUM(D31)/$D$7,0)","v":0},null,{"$f":"INDEX(Daten!$D36:$N36,1,Daten!$A$56)","v":0},{"$f":"IF($G$7,SUM(G31:G31)/$G$7,0)","v":0},{"$f":"ABS(H31-E31)","v":0}]

{"sheet":"Haushaltsbudgets im Vergleich","index":2,"n_rows":27,"n_cols":19,"rows_kept":27,"cut":false,"hidden":false,"merged":[[6,12,6,13],[8,12,8,13]]}
[]
[]
[null,null,null,"Schweizer Durchschnitt"]
[null,null,null,"Bundesamt für Statistik"]
[]
[]
[null,"Budget 1",null,null,null,null,null,null,null,null,"Einnahmen",null,{"$f":"INDEX(Daten!$D12:$N12,1,Daten!$A$58)","v":2780},null,null,"Restbetrag",null,null,{"$f":"INDEX(Daten!$D36:$N36,1,Daten!$A$58)","v":-730}]
[]
[null,"Budget 2",null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(Daten!$D12:$N12,1,Daten!$A$59)","v":5820},null,null,null,null,null,{"$f":"INDEX(Daten!$D36:$N36,1,Daten!$A$59)","v":750}]
[]
[null,{"$f":"Daten!$A9","v":0}]
["Ausgaben"]
[]
[]
[null,null,"1 Steuern",null,null,null,"2 Gesundheit",null,null,null,"3 Unterstützungen & Geschenke",null,null,null,"4 Wohnen",null,null,null,"5 Ernährung"]
[null,null,"((Icon))",null,null,null,"((Icon))",null,null,null,"((Icon))",null,null,null,"((Icon))",null,null,null,"((Icon))"]
[null,null,{"$f":"INDEX(Daten!$D15:$N15,1,Daten!$A$58)","v":-290},null,null,null,{"$f":"INDEX(Daten!$D17:$N17,1,Daten!$A$58)","v":-520},null,null,null,{"$f":"INDEX(Daten!$D19:$N19,1,Daten!$A$58)","v":-130},null,null,null,{"$f":"INDEX(Daten!$D21:$N21,1,Daten!$A$58)","v":-1040},null,null,null,{"$f":"INDEX(Daten!$D23:$N23,1,Daten!$A$58)","v":-320}]
[]
[null,null,{"$f":"INDEX(Daten!$D15:$N15,1,Daten!$A$59)","v":-640},null,null,null,{"$f":"INDEX(Daten!$D17:$N17,1,Daten!$A$59)","v":-490},null,null,null,{"$f":"INDEX(Daten!$D19:$N19,1,Daten!$A$59)","v":-290},null,null,null,{"$f":"INDEX(Daten!$D21:$N21,1,Daten!$A$59)","v":-1240},null,null,null,{"$f":"INDEX(Daten!$D23:$N23,1,Daten!$A$59)","v":-340}]
[]
[]
[]
[null,null,"6 Bekleidung & Körperpflege",null,null,null,"7 Haushalt & Lebensversicherung",null,null,null,"8 Mobilität",null,null,null,"9 Kommunikation & Elektronik",null,null,null,"10 Freizeit & Bildung"]
[null,null,"((Icon))",null,null,null,"((Icon))",null,null,null,null,null,null,null,"((Icon))",null,null,null,"((Icon))"]
[null,null,{"$f":"INDEX(Daten!$D25:$N25,1,Daten!$A$58)","v":-130},null,null,null,{"$f":"INDEX(Daten!$D27:$N27,1,Daten!$A$58)","v":-190},null,null,null,{"$f":"INDEX(Daten!$D29:$N29,1,Daten!$A$58)","v":-300},null,null,null,{"$f":"INDEX(Daten!$D31:$N31,1,Daten!$A$58)","v":-150},null,null,null,{"$f":"INDEX(Daten!$D33:$N33,1,Daten!$A$58)","v":-440}]
[]
[null,null,{"$f":"INDEX(Daten!$D25:$N25,1,Daten!$A$59)","v":-200},null,null,null,{"$f":"INDEX(Daten!$D27:$N27,1,Daten!$A$59)","v":-350},null,null,null,{"$f":"INDEX(Daten!$D29:$N29,1,Daten!$A$59)","v":-570},null,null,null,{"$f":"INDEX(Daten!$D31:$N31,1,Daten!$A$59)","v":-190},null,null,null,{"$f":"INDEX(Daten!$D33:$N33,1,Daten!$A$59)","v":-760}]

{"sheet":"Daten","index":3,"n_rows":59,"n_cols":14,"rows_kept":59,"cut":false,"hidden":true,"merged":[]}
[9,null,null,null,1,2,3,4,5,6,7,8,9,10]
[null,"Bevölkerungsgruppe",null,null,"1 Alleinstehende Person, geringes Einkommen","2 Alleinstehende Person, mittleres Einkommen","3 Alleinstehende Person, hohes Einkommen","4 Paar ohne Kinder, geringes Einkommen","5 Paar ohne Kinder, mittleres Einkommen","6 Alleinerziehende Person mit Kindern","7 Rentnerpaar ohne Kinder, mittleres Renteneinkommen","8 Paar mit zwei Kindern, geringes Einkommen","9 Paar mit zwei Kindern, mittleres Einkommen","10 Paar mit zwei Kindern, hohes Einkommen"]
[]
["A","Primäreinkommen",null,null,1080,5960,12070,4550,11010,6020,950,5670,11070,23840]
[]
["B","Renten und Sozialleistungen",null,null,1450,420,380,1170,530,1220,6220,970,880,720]
[]
["C","Transfer- und sporadische Einkommen",null,null,380,200,470,310,370,1320,400,280,510,740]
[]
["D","Sozialversicherungsbeiträge",null,null,-130,-760,-1600,-550,-1360,-760,-40,-680,-1410,-2930]
[]
["E","Verfügbares Einkommen",null,null,{"$f":"SUM(E4:E10)","v":2780},{"$f":"SUM(F4:F10)","v":5820},11320,5480,10550,{"$f":"SUM(J4:J10)","v":7800},7530,6240,11050,22370]
[]
[]
[1,"Steuern ",null,null,-290,-640,-1770,-820,-1300,-590,-1070,-470,-1000,-3460]
[]
[2,"Gesundheit",null,null,-520,-490,-640,-920,-940,-950,-1490,-1090,-1260,-1540]
[]
[3,"Unterstützungen & Geschenke",null,null,-130,-290,-1120,-190,-250,-290,-400,-110,-240,-590]
[]
[4,"Wohnen",null,null,-1040,-1240,-1680,-1370,-1620,-1590,-1180,-1410,-1530,-2350]
[]
[5,"Ernährung",null,null,-320,-340,-390,-540,-620,-640,-750,-720,-910,-1110]
[]
[6,"Bekleidung & Körperpflege",null,null,-130,-200,-310,-260,-380,-380,-300,-320,-500,-860]
[]
[7,"Haushalt & Lebensversicherung",null,null,-190,-350,-790,-450,-810,-440,-350,-440,-890,-1610]
[]
[8,"Mobilität",null,null,-300,-570,-870,-740,-1160,-670,-760,-770,-1210,-1800]
[]
[9,"Kommunikation & Elektronik",null,null,-150,-190,-240,-230,-280,-290,-200,-260,-310,-400]
[]
[10,"Freizeit & Bildung",null,null,-440,-760,-1290,-880,-1360,-1080,-1220,-830,-1570,-3380]
[]
[]
["F","Restbetrag",null,null,{"$f":"SUM(E12:E33)","v":-730},{"$f":"SUM(F12:F33)","v":750},2220,-920,1830,880,-190,{"$f":"SUM(L12:L33)","v":-180},1630,5270]
[]
["X1","Einzel / Paar",null,null,"Einzel","Einzel","Einzel","Paar","Paar","Einzel","Paar","Paar","Paar","Paar"]
["X2","Kinder",null,null,"nein","nein","nein","nein","nein","ja","nein","ja","ja","ja"]
["X3","Alter",null,null,"unter 65 Jahren","unter 65 Jahren","unter 65 Jahren","unter 65 Jahren","unter 65 Jahren","-","ab 65 Jahren","-","-","-"]
["X4","Einkommen",null,null,"unterstes Quintil","mittleres Quintil","oberstes Quintil","unterstes Quintil","mittleres Quintil","Durchschnitt","mittleres Quintil","unterstes Quintil","mittleres Quintil","oberstes Quintil"]
[]
[]
[null,{"$f":"E2","v":"1 Alleinstehende Person, geringes Einkommen"}]
[null,{"$f":"F2","v":"2 Alleinstehende Person, mittleres Einkommen"}]
[null,{"$f":"G2","v":"3 Alleinstehende Person, hohes Einkommen"}]
[null,{"$f":"H2","v":"4 Paar ohne Kinder, geringes Einkommen"}]
[null,{"$f":"I2","v":"5 Paar ohne Kinder, mittleres Einkommen"}]
[null,{"$f":"J2","v":"6 Alleinerziehende Person mit Kindern"}]
[null,{"$f":"K2","v":"7 Rentnerpaar ohne Kinder, mittleres Renteneinkommen"}]
[null,{"$f":"L2","v":"8 Paar mit zwei Kindern, geringes Einkommen"}]
[null,{"$f":"M2","v":"9 Paar mit zwei Kindern, mittleres Einkommen"}]
[null,{"$f":"N2","v":"10 Paar mit zwei Kindern, hohes Einkommen"}]
[]
[]
[1,"Cell Link Monatliche Haushaltsbudgets"]
[]
[2,"Cell Link Haushaltstypen im Vergleich 1"]
[3,"Cell Link Haushaltstypen im Vergleich 1"]

{"sheet":"Monatliches Haushaltsbudget_p","index":4,"n_rows":31,"n_cols":7,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
["Monatliches Haushaltsbudget"]
[]
[null,null,null,"Vorschlag"]
[null,null,null,"Lernende"]
[]
[]
["Einnahmen",null,{"$f":"Daten!$B$12","v":"Verfügbares Einkommen"}]
[null,{"$f":"Daten!$A13","v":0}]
[null,{"$f":"Daten!$A9","v":0}]
["Ausgaben",{"$f":"Daten!$A15","v":1},{"$f":"Daten!$B15","v":"Steuern "},null,{"$f":"IF($D$7,SUM(D10)/$D$7,0)","v":0},{"$f":"ABS(#REF!-E10)","v":{"$error":"#REF!"}},"Steuern für Bund, Kanton und Gemeinde, amtliche Gebühren"]
[null,{"$f":"Daten!$A16","v":0},{"$f":"Daten!$B16","v":0}]
[null,{"$f":"Daten!$A17","v":2},{"$f":"Daten!$B17","v":"Gesundheit"},null,{"$f":"IF($D$7,SUM(D12)/$D$7,0)","v":0},{"$f":"ABS(#REF!-E12)","v":{"$error":"#REF!"}},"Krankenkassenprämien, Arztbesuche, Medikamente"]
[null,{"$f":"Daten!$A18","v":0},{"$f":"Daten!$B18","v":0}]
[null,{"$f":"Daten!$A19","v":3},{"$f":"Daten!$B19","v":"Unterstützungen & Geschenke"},null,{"$f":"IF($D$7,SUM(D14)/$D$7,0)","v":0},{"$f":"ABS(#REF!-E14)","v":{"$error":"#REF!"}},"Einladungen, Spenden, Alimente, Unterstützungsbeiträge"]
[null,{"$f":"Daten!$A20","v":0},{"$f":"Daten!$B20","v":0}]
[null,{"$f":"Daten!$A21","v":4},{"$f":"Daten!$B21","v":"Wohnen"},null,{"$f":"IF($D$7,SUM(D16)/$D$7,0)","v":0},{"$f":"ABS(#REF!-E16)","v":{"$error":"#REF!"}},"Wohnung, Energie"]
[null,{"$f":"Daten!$A22","v":0},{"$f":"Daten!$B22","v":0}]
[null,{"$f":"Daten!$A23","v":5},{"$f":"Daten!$B23","v":"Ernährung"},null,{"$f":"IF($D$7,SUM(D18)/$D$7,0)","v":0},{"$f":"ABS(#REF!-E18)","v":{"$error":"#REF!"}},"Essen, Trinken"]
[null,{"$f":"Daten!$A24","v":0},{"$f":"Daten!$B24","v":0}]
[null,{"$f":"Daten!$A25","v":6},{"$f":"Daten!$B25","v":"Bekleidung & Körperpflege"},null,{"$f":"IF($D$7,SUM(D20)/$D$7,0)","v":0},{"$f":"ABS(#REF!-E20)","v":{"$error":"#REF!"}},"Kleidung, Schuhe, Hygieneprodukte, Coiffeur"]
[null,{"$f":"Daten!$A26","v":0},{"$f":"Daten!$B26","v":0}]
[null,{"$f":"Daten!$A27","v":7},{"$f":"Daten!$B27","v":"Haushalt & Lebensversicherung"},null,{"$f":"IF($D$7,SUM(D22)/$D$7,0)","v":0},{"$f":"ABS(#REF!-E22)","v":{"$error":"#REF!"}},"Einrichtung, Haushaltsführung, Versicherungen"]
[null,{"$f":"Daten!$A28","v":0},{"$f":"Daten!$B28","v":0}]
[null,{"$f":"Daten!$A29","v":8},{"$f":"Daten!$B29","v":"Mobilität"},null,{"$f":"IF($D$7,SUM(D24)/$D$7,0)","v":0},{"$f":"ABS(#REF!-E24)","v":{"$error":"#REF!"}},"Individueller und öffentlicher Verkehr"]
[null,{"$f":"Daten!$A30","v":0},{"$f":"Daten!$B30","v":0}]
[null,{"$f":"Daten!$A31","v":9},{"$f":"Daten!$B31","v":"Kommunikation & Elektronik"},null,{"$f":"IF($D$7,SUM(D26)/$D$7,0)","v":0},{"$f":"ABS(#REF!-E26)","v":{"$error":"#REF!"}},"Telefonie, Internet, TV, Computer"]
[null,{"$f":"Daten!$A32","v":0},{"$f":"Daten!$B32","v":0}]
[null,{"$f":"Daten!$A33","v":10},{"$f":"Daten!$B33","v":"Freizeit & Bildung"},null,{"$f":"IF($D$7,SUM(D28)/$D$7,0)","v":0},{"$f":"ABS(#REF!-E28)","v":{"$error":"#REF!"}},"Ausgang, Ferien, Hobbys, Bildung"]
[null,{"$f":"Daten!$A34","v":0}]
[null,{"$f":"Daten!$A35","v":0}]
["Restbetrag",null,"Sparen/Schulden",{"$f":"D7-SUM(D10:D28)","v":0},{"$f":"IF($D$7,SUM(D31)/$D$7,0)","v":0},{"$f":"ABS(#REF!-E31)","v":{"$error":"#REF!"}}]

{"sheet":"Haushaltsbudgets im Vergleich_p","index":5,"n_rows":36,"n_cols":13,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
[null,null,null,1,2,3,4,5,6,7,8,9,10]
[null,null,null,"Alleinstehende Person, geringes Einkommen","Alleinstehende Person, mittleres Einkommen","Alleinstehende Person, hohes Einkommen","Paar ohne Kinder, geringes Einkommen","Paar ohne Kinder, mittleres Einkommen","Alleinerziehende Person mit Kindern","Rentenpaar ohne Kinder, mittleres Renten-einkommen","Paar mit zwei Kindern, geringes Einkommen","Paar mit zwei Kindern, mittleres Einkommen","Paar mit zwei Kindern, hohes Einkommen"]
[]
[null,"Primäreinkommen",null,{"$f":"Daten!E4","v":1080},{"$f":"Daten!F4","v":5960},{"$f":"Daten!G4","v":12070},{"$f":"Daten!H4","v":4550},{"$f":"Daten!I4","v":11010},{"$f":"Daten!J4","v":6020},{"$f":"Daten!K4","v":950},{"$f":"Daten!L4","v":5670},{"$f":"Daten!M4","v":11070},{"$f":"Daten!N4","v":23840}]
[null,null,null,{"$f":"Daten!E5","v":0}]
[null,"Renten und Sozialleistungen",null,{"$f":"Daten!E6","v":1450},{"$f":"Daten!F6","v":420},{"$f":"Daten!G6","v":380},{"$f":"Daten!H6","v":1170},{"$f":"Daten!I6","v":530},{"$f":"Daten!J6","v":1220},{"$f":"Daten!K6","v":6220},{"$f":"Daten!L6","v":970},{"$f":"Daten!M6","v":880},{"$f":"Daten!N6","v":720}]
[null,null,null,{"$f":"Daten!E7","v":0}]
[null,"Transfer- u. sporadische Einkommen",null,{"$f":"Daten!E8","v":380},{"$f":"Daten!F8","v":200},{"$f":"Daten!G8","v":470},{"$f":"Daten!H8","v":310},{"$f":"Daten!I8","v":370},{"$f":"Daten!J8","v":1320},{"$f":"Daten!K8","v":400},{"$f":"Daten!L8","v":280},{"$f":"Daten!M8","v":510},{"$f":"Daten!N8","v":740}]
[null,null,null,{"$f":"Daten!E9","v":0}]
[null,"Sozialversicherungsbeiträge",null,{"$f":"Daten!E10","v":-130},{"$f":"Daten!F10","v":-760},{"$f":"Daten!G10","v":-1600},{"$f":"Daten!H10","v":-550},{"$f":"Daten!I10","v":-1360},{"$f":"Daten!J10","v":-760},{"$f":"Daten!K10","v":-40},{"$f":"Daten!L10","v":-680},{"$f":"Daten!M10","v":-1410},{"$f":"Daten!N10","v":-2930}]
[]
[null,"Verfügbares Einkommen",null,{"$f":"Daten!E12","v":2780},{"$f":"Daten!F12","v":5820},{"$f":"Daten!G12","v":11320},{"$f":"Daten!H12","v":5480},{"$f":"Daten!I12","v":10550},{"$f":"Daten!J12","v":7800},{"$f":"Daten!K12","v":7530},{"$f":"Daten!L12","v":6240},{"$f":"Daten!M12","v":11050},{"$f":"Daten!N12","v":22370}]
[]
[]
[1,"Steuern ",null,{"$f":"Daten!E15","v":-290},{"$f":"Daten!F15","v":-640},{"$f":"Daten!G15","v":-1770},{"$f":"Daten!H15","v":-820},{"$f":"Daten!I15","v":-1300},{"$f":"Daten!J15","v":-590},{"$f":"Daten!K15","v":-1070},{"$f":"Daten!L15","v":-470},{"$f":"Daten!M15","v":-1000},{"$f":"Daten!N15","v":-3460}]
[null,null,null,{"$f":"Daten!E16","v":0},{"$f":"Daten!F16","v":0},{"$f":"Daten!G16","v":0},{"$f":"Daten!H16","v":0},{"$f":"Daten!I16","v":0},{"$f":"Daten!J16","v":0},{"$f":"Daten!K16","v":0},{"$f":"Daten!L16","v":0},{"$f":"Daten!M16","v":0},{"$f":"Daten!N16","v":0}]
[2,"Gesundheit",null,{"$f":"Daten!E17","v":-520},{"$f":"Daten!F17","v":-490},{"$f":"Daten!G17","v":-640},{"$f":"Daten!H17","v":-920},{"$f":"Daten!I17","v":-940},{"$f":"Daten!J17","v":-950},{"$f":"Daten!K17","v":-1490},{"$f":"Daten!L17","v":-1090},{"$f":"Daten!M17","v":-1260},{"$f":"Daten!N17","v":-1540}]
[null,null,null,{"$f":"Daten!E18","v":0},{"$f":"Daten!F18","v":0},{"$f":"Daten!G18","v":0},{"$f":"Daten!H18","v":0},{"$f":"Daten!I18","v":0},{"$f":"Daten!J18","v":0},{"$f":"Daten!K18","v":0},{"$f":"Daten!L18","v":0},{"$f":"Daten!M18","v":0},{"$f":"Daten!N18","v":0}]
[3,"Unterstützungen & Geschenke",null,{"$f":"Daten!E19","v":-130},{"$f":"Daten!F19","v":-290},{"$f":"Daten!G19","v":-1120},{"$f":"Daten!H19","v":-190},{"$f":"Daten!I19","v":-250},{"$f":"Daten!J19","v":-290},{"$f":"Daten!K19","v":-400},{"$f":"Daten!L19","v":-110},{"$f":"Daten!M19","v":-240},{"$f":"Daten!N19","v":-590}]
[null,null,null,{"$f":"Daten!E20","v":0},{"$f":"Daten!F20","v":0},{"$f":"Daten!G20","v":0},{"$f":"Daten!H20","v":0},{"$f":"Daten!I20","v":0},{"$f":"Daten!J20","v":0},{"$f":"Daten!K20","v":0},{"$f":"Daten!L20","v":0},{"$f":"Daten!M20","v":0},{"$f":"Daten!N20","v":0}]
[4,"Wohnen",null,{"$f":"Daten!E21","v":-1040},{"$f":"Daten!F21","v":-1240},{"$f":"Daten!G21","v":-1680},{"$f":"Daten!H21","v":-1370},{"$f":"Daten!I21","v":-1620},{"$f":"Daten!J21","v":-1590},{"$f":"Daten!K21","v":-1180},{"$f":"Daten!L21","v":-1410},{"$f":"Daten!M21","v":-1530},{"$f":"Daten!N21","v":-2350}]
[null,null,null,{"$f":"Daten!E22","v":0},{"$f":"Daten!F22","v":0},{"$f":"Daten!G22","v":0},{"$f":"Daten!H22","v":0},{"$f":"Daten!I22","v":0},{"$f":"Daten!J22","v":0},{"$f":"Daten!K22","v":0},{"$f":"Daten!L22","v":0},{"$f":"Daten!M22","v":0},{"$f":"Daten!N22","v":0}]
[5,"Ernährung",null,{"$f":"Daten!E23","v":-320},{"$f":"Daten!F23","v":-340},{"$f":"Daten!G23","v":-390},{"$f":"Daten!H23","v":-540},{"$f":"Daten!I23","v":-620},{"$f":"Daten!J23","v":-640},{"$f":"Daten!K23","v":-750},{"$f":"Daten!L23","v":-720},{"$f":"Daten!M23","v":-910},{"$f":"Daten!N23","v":-1110}]
[null,null,null,{"$f":"Daten!E24","v":0},{"$f":"Daten!F24","v":0},{"$f":"Daten!G24","v":0},{"$f":"Daten!H24","v":0},{"$f":"Daten!I24","v":0},{"$f":"Daten!J24","v":0},{"$f":"Daten!K24","v":0},{"$f":"Daten!L24","v":0},{"$f":"Daten!M24","v":0},{"$f":"Daten!N24","v":0}]
[6,"Bekleidung & Körperpflege",null,{"$f":"Daten!E25","v":-130},{"$f":"Daten!F25","v":-200},{"$f":"Daten!G25","v":-310},{"$f":"Daten!H25","v":-260},{"$f":"Daten!I25","v":-380},{"$f":"Daten!J25","v":-380},{"$f":"Daten!K25","v":-300},{"$f":"Daten!L25","v":-320},{"$f":"Daten!M25","v":-500},{"$f":"Daten!N25","v":-860}]
[null,null,null,{"$f":"Daten!E26","v":0},{"$f":"Daten!F26","v":0},{"$f":"Daten!G26","v":0},{"$f":"Daten!H26","v":0},{"$f":"Daten!I26","v":0},{"$f":"Daten!J26","v":0},{"$f":"Daten!K26","v":0},{"$f":"Daten!L26","v":0},{"$f":"Daten!M26","v":0},{"$f":"Daten!N26","v":0}]
[7,"Haushalt & Lebensversicherung",null,{"$f":"Daten!E27","v":-190},{"$f":"Daten!F27","v":-350},{"$f":"Daten!G27","v":-790},{"$f":"Daten!H27","v":-450},{"$f":"Daten!I27","v":-810},{"$f":"Daten!J27","v":-440},{"$f":"Daten!K27","v":-350},{"$f":"Daten!L27","v":-440},{"$f":"Daten!M27","v":-890},{"$f":"Daten!N27","v":-1610}]
[null,null,null,{"$f":"Daten!E28","v":0},{"$f":"Daten!F28","v":0},{"$f":"Daten!G28","v":0},{"$f":"Daten!H28","v":0},{"$f":"Daten!I28","v":0},{"$f":"Daten!J28","v":0},{"$f":"Daten!K28","v":0},{"$f":"Daten!L28","v":0},{"$f":"Daten!M28","v":0},{"$f":"Daten!N28","v":0}]
[8,"Mobilität",null,{"$f":"Daten!E29","v":-300},{"$f":"Daten!F29","v":-570},{"$f":"Daten!G29","v":-870},{"$f":"Daten!H29","v":-740},{"$f":"Daten!I29","v":-1160},{"$f":"Daten!J29","v":-670},{"$f":"Daten!K29","v":-760},{"$f":"Daten!L29","v":-770},{"$f":"Daten!M29","v":-1210},{"$f":"Daten!N29","v":-1800}]
[null,null,null,{"$f":"Daten!E30","v":0},{"$f":"Daten!F30","v":0},{"$f":"Daten!G30","v":0},{"$f":"Daten!H30","v":0},{"$f":"Daten!I30","v":0},{"$f":"Daten!J30","v":0},{"$f":"Daten!K30","v":0},{"$f":"Daten!L30","v":0},{"$f":"Daten!M30","v":0},{"$f":"Daten!N30","v":0}]
[9,"Kommunikation & Elektronik",null,{"$f":"Daten!E31","v":-150},{"$f":"Daten!F31","v":-190},{"$f":"Daten!G31","v":-240},{"$f":"Daten!H31","v":-230},{"$f":"Daten!I31","v":-280},{"$f":"Daten!J31","v":-290},{"$f":"Daten!K31","v":-200},{"$f":"Daten!L31","v":-260},{"$f":"Daten!M31","v":-310},{"$f":"Daten!N31","v":-400}]
[null,null,null,{"$f":"Daten!E32","v":0},{"$f":"Daten!F32","v":0},{"$f":"Daten!G32","v":0},{"$f":"Daten!H32","v":0},{"$f":"Daten!I32","v":0},{"$f":"Daten!J32","v":0},{"$f":"Daten!K32","v":0},{"$f":"Daten!L32","v":0},{"$f":"Daten!M32","v":0},{"$f":"Daten!N32","v":0}]
[10,"Freizeit & Bildung",null,{"$f":"Daten!E33","v":-440},{"$f":"Daten!F33","v":-760},{"$f":"Daten!G33","v":-1290},{"$f":"Daten!H33","v":-880},{"$f":"Daten!I33","v":-1360},{"$f":"Daten!J33","v":-1080},{"$f":"Daten!K33","v":-1220},{"$f":"Daten!L33","v":-830},{"$f":"Daten!M33","v":-1570},{"$f":"Daten!N33","v":-3380}]
[]
[]
[null,"Restbetrag",null,{"$f":"Daten!E36","v":-730},{"$f":"Daten!F36","v":750},{"$f":"Daten!G36","v":2220},{"$f":"Daten!H36","v":-920},{"$f":"Daten!I36","v":1830},{"$f":"Daten!J36","v":880},{"$f":"Daten!K36","v":-190},{"$f":"Daten!L36","v":-180},{"$f":"Daten!M36","v":1630},{"$f":"Daten!N36","v":5270}]