{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["תזרים מזומנים","הכנסות חודשיות","הוצאות חודשיות","נתוני תרשים"],"not_rendered":{"charts":1,"defined_names":10},"read":"whole","date_system":"1900"}

{"sheet":"תזרים מזומנים","index":0,"n_rows":9,"n_cols":5,"rows_kept":9}
[null,"שם"]
[null,"תקציב משפחתי"]
[null,{"$f":"TEXT(TODAY(),\"mmmm\")","v":"ינואר"}]
[null,{"$f":"YEAR(TODAY())","v":2017}]
[null,"הערה: טבלת תזרים המזומנים מחושבת באופן אוטומטי בהתבסס על הערכים מגליונות העבודה 'הכנסות חודשיות' ו'הוצאות חודשיות'"]
[null,"תזרים מזומנים","צפוי","בפועל","שונות"]
[null,"סה\"כ הכנסות",{"$f":"הכנסה[[#Totals],[צפוי]]","v":{"v":5700,"d":"5,700"}},{"$f":"הכנסה[[#Totals],[בפועל]]","v":{"v":5500,"d":"5,500"}},{"$f":"הכנסה[[#Totals],[שונות]]","v":-200}]
[null,"סה\"כ הוצאות",{"$f":"הוצאה[[#Totals],[צפוי]]","v":{"v":3603,"d":"3,603"}},{"$f":"הוצאה[[#Totals],[בפועל]]","v":{"v":3655,"d":"3,655"}},{"$f":"הוצאה[[#Totals],[שונות]]","v":-52}]
[null,"סה\"כ מזומנים",{"$f":"C7-C8","v":{"v":2097,"d":"2,097"}},{"$f":"D7-D8","v":{"v":1845,"d":"1,845"}},{"$f":"SUBTOTAL(109,תזרים_מזומנים[שונות])","v":-252}]

{"sheet":"הכנסות חודשיות","index":1,"n_rows":9,"n_cols":5,"rows_kept":9}
[null,{"$f":"שם","v":"שם"}]
[null,{"$f":"BudgetTitle","v":"תקציב משפחתי"}]
[null,{"$f":"חודש","v":"ינואר"}]
[null,{"$f":"שנה","v":2017}]
[null,"הכנסות חודשיות","צפוי","בפועל","שונות"]
[null,"הכנסה 1",{"v":4000,"d":"4,000"},{"v":4000,"d":"4,000"},{"$f":"הכנסה[[#This Row],[בפועל]]-הכנסה[[#This Row],[צפוי]]","v":0}]
[null,"הכנסה 2",{"v":1400,"d":"1,400"},{"v":1500,"d":"1,500"},{"$f":"הכנסה[[#This Row],[בפועל]]-הכנסה[[#This Row],[צפוי]]","v":100}]
[null,"הכנסות אחרות",300,0,{"$f":"הכנסה[[#This Row],[בפועל]]-הכנסה[[#This Row],[צפוי]]","v":-300}]
[null,"סה\"כ הכנסות",{"$f":"SUBTOTAL(109,הכנסה[צפוי])","v":{"v":5700,"d":"5,700"}},{"$f":"SUBTOTAL(109,הכנסה[בפועל])","v":{"v":5500,"d":"5,500"}},{"$f":"SUBTOTAL(109,הכנסה[שונות])","v":-200}]

{"sheet":"הוצאות חודשיות","index":2,"n_rows":26,"n_cols":5,"rows_kept":26}
[null,{"$f":"שם","v":"שם"}]
[null,{"$f":"BudgetTitle","v":"תקציב משפחתי"}]
[null,{"$f":"חודש","v":"ינואר"}]
[null,{"$f":"שנה","v":2017}]
[null,"הוצאות חודשיות","צפוי","בפועל","שונות"]
[null,"דיור",{"v":1500,"d":"1,500"},{"v":1500,"d":"1,500"},{"$f":"הוצאה[[#This Row],[צפוי]]-הוצאה[[#This Row],[בפועל]]","v":0}]
[null,"מצרכים",250,280,{"$f":"הוצאה[[#This Row],[צפוי]]-הוצאה[[#This Row],[בפועל]]","v":-30}]
[null,"טלפון",38,38,{"$f":"הוצאה[[#This Row],[צפוי]]-הוצאה[[#This Row],[בפועל]]","v":0}]
[null,"חשמל / גז",65,78,{"$f":"הוצאה[[#This Row],[צפוי]]-הוצאה[[#This Row],[בפועל]]","v":-13}]
[null,"מים / ביוב / אשפה",25,21,{"$f":"הוצאה[[#This Row],[צפוי]]-הוצאה[[#This Row],[בפועל]]","v":4}]
[null,"טלוויזיה בכבלים",75,83,{"$f":"הוצאה[[#This Row],[צפוי]]-הוצאה[[#This Row],[בפועל]]","v":-8}]
[null,"אינטרנט",60,60,{"$f":"הוצאה[[#This Row],[צפוי]]-הוצאה[[#This Row],[בפועל]]","v":0}]
[null,"תחזוקה / תיקונים",0,60,{"$f":"הוצאה[[#This Row],[צפוי]]-הוצאה[[#This Row],[בפועל]]","v":-60}]
[null,"טיפול בילדים",180,150,{"$f":"הוצאה[[#This Row],[צפוי]]-הוצאה[[#This Row],[בפועל]]","v":30}]
[null,"שכר לימוד",250,250,{"$f":"הוצאה[[#This Row],[צפוי]]-הוצאה[[#This Row],[בפועל]]","v":0}]
[null,"חיות מחמד",75,80,{"$f":"הוצאה[[#This Row],[צפוי]]-הוצאה[[#This Row],[בפועל]]","v":-5}]
[null,"תחבורה",280,260,{"$f":"הוצאה[[#This Row],[צפוי]]-הוצאה[[#This Row],[בפועל]]","v":20}]
[null,"טיפוח אישי",75,65,{"$f":"הוצאה[[#This Row],[צפוי]]-הוצאה[[#This Row],[בפועל]]","v":10}]
[null,"ביטוח",255,255,{"$f":"הוצאה[[#This Row],[צפוי]]-הוצאה[[#This Row],[בפועל]]","v":0}]
[null,"כרטיסי אשראי",100,100,{"$f":"הוצאה[[#This Row],[צפוי]]-הוצאה[[#This Row],[בפועל]]","v":0}]
[null,"הלוואות",0,0,{"$f":"הוצאה[[#This Row],[צפוי]]-הוצאה[[#This Row],[בפועל]]","v":0}]
[null,"מסים",0,0,{"$f":"הוצאה[[#This Row],[צפוי]]-הוצאה[[#This Row],[בפועל]]","v":0}]
[null,"מתנות / צדקה",150,150,{"$f":"הוצאה[[#This Row],[צפוי]]-הוצאה[[#This Row],[בפועל]]","v":0}]
[null,"חסכונות",225,225,{"$f":"הוצאה[[#This Row],[צפוי]]-הוצאה[[#This Row],[בפועל]]","v":0}]
[null,"אחר",0,0,{"$f":"הוצאה[[#This Row],[צפוי]]-הוצאה[[#This Row],[בפועל]]","v":0}]
[null,"סה\"כ",{"$f":"SUBTOTAL(109,הוצאה[צפוי])","v":{"v":3603,"d":"3,603"}},{"$f":"SUBTOTAL(109,הוצאה[בפועל])","v":{"v":3655,"d":"3,655"}},{"$f":"SUBTOTAL(109,הוצאה[שונות])","v":-52}]

{"sheet":"נתוני תרשים","index":3,"n_rows":6,"n_cols":4,"rows_kept":6,"hidden":true}
[null,"נתוני תרשים"]
[]
[null,null,"צפוי","בפועל"]
[null,"תזרים מזומנים",{"$f":"תזרים_מזומנים[[#Totals],[צפוי]]","v":2097},{"$f":"תזרים_מזומנים[[#Totals],[בפועל]]","v":1845}]
[null,"הכנסות חודשיות",{"$f":"הכנסה[[#Totals],[צפוי]]","v":5700},{"$f":"הכנסה[[#Totals],[בפועל]]","v":5500}]
[null,"הוצאות חודשיות",{"$f":"הוצאה[[#Totals],[צפוי]]","v":3603},{"$f":"הוצאה[[#Totals],[בפועל]]","v":3655}]