{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["מעקב כספים אישי","סיכום חודשי","נתוני תרשים"],"not_rendered":{"charts":2,"defined_names":7,"pivot_tables":2},"read":"whole","date_system":"1900"}

{"sheet":"מעקב כספים אישי","index":0,"n_rows":22,"n_cols":7,"rows_kept":22,"merged":[[8,3,8,6],[19,1,20,1],[21,1,23,1]]}
[null,"מעקב כספים אישי"]
[]
[{"$nulls":3},"סיכום מזומנים"]
[{"$nulls":3},"חשבון","סכום מזומנים התחלתי","סה\"כ הוצאות","מזומנים נותרים"]
[{"$nulls":3},"עו\"ש",{"v":3000,"d":"3000.00"},{"$f":"SUMIF(CashSpent[חשבון],\"=\" &CashSummaryTable[[#This Row],[חשבון]],CashSpent[סכום])","v":{"v":428,"d":"428.00"}},{"$f":"CashSummaryTable[[#This Row],[סכום מזומנים התחלתי]]-CashSummaryTable[[#This Row],[סה\"כ הוצאות]]","v":{"v":2572,"d":"2572.00"}}]
[{"$nulls":3},"חיסכון",{"v":500,"d":"500.00"},{"$f":"SUMIF(CashSpent[חשבון],\"=\" &CashSummaryTable[[#This Row],[חשבון]],CashSpent[סכום])","v":{"v":450,"d":"450.00"}},{"$f":"CashSummaryTable[[#This Row],[סכום מזומנים התחלתי]]-CashSummaryTable[[#This Row],[סה\"כ הוצאות]]","v":{"v":50,"d":"50.00"}}]
[{"$nulls":3},"אחר",{"v":200,"d":"200.00"},{"$f":"SUMIF(CashSpent[חשבון],\"=\" &CashSummaryTable[[#This Row],[חשבון]],CashSpent[סכום])","v":{"v":30,"d":"30.00"}},{"$f":"CashSummaryTable[[#This Row],[סכום מזומנים התחלתי]]-CashSummaryTable[[#This Row],[סה\"כ הוצאות]]","v":{"v":170,"d":"170.00"}}]
[{"$nulls":3}," סך הכל ",{"$f":"SUBTOTAL(109,CashSummaryTable[סכום מזומנים התחלתי])","v":{"v":3700,"d":"3700.00"}},{"$f":"SUBTOTAL(109,CashSummaryTable[סה\"כ הוצאות])","v":{"v":908,"d":"908.00"}},{"$f":"SUBTOTAL(109,CashSummaryTable[מזומנים נותרים])","v":{"v":2792,"d":"2792.00"}}]
[]
[{"$nulls":3},"מזומנים שהוצאתי"]
[{"$nulls":3},"תאריך","תיאור","סכום","חשבון"]
[{"$nulls":3},"2012-01-04"," משיכה מכספומט ",{"v":40,"d":"40.00"},"עו\"ש"]
[{"$nulls":3},"2012-01-05"," ארוחת צהריים ",{"v":5,"d":"5.00"},"עו\"ש"]
[{"$nulls":3},"2012-01-06"," הוצאות רכב ",{"v":230,"d":"230.00"},"חיסכון"]
[{"$nulls":3},"2012-02-03"," חשבון חשמל ",{"v":70,"d":"70.00"},"עו\"ש"]
[{"$nulls":3},"2012-02-07"," ארוחת ערב ",{"v":53,"d":"53.00"},"עו\"ש"]
[{"$nulls":3},"2012-03-01"," משיכת מזומנים ",{"v":100,"d":"100.00"},"חיסכון"]
[{"$nulls":3},"2012-03-06"," הוצאות רכב ",{"v":230,"d":"230.00"},"עו\"ש"]
[{"$nulls":3},"2012-04-06"," חשבון חשמל ",{"v":70,"d":"70.00"},"חיסכון"]
[null,"מזומנים נותרים:",null,"2012-04-20"," משיכה מכספומט ",{"v":30,"d":"30.00"},"עו\"ש"]
[{"$nulls":3},"2012-05-03"," משיכה מכספומט ",{"v":50,"d":"50.00"},"חיסכון"]
[null,{"$f":"CashSummaryTable[[#Totals],[מזומנים נותרים]]/CashSummaryTable[[#Totals],[סכום מזומנים התחלתי]]","v":{"v":0.7545945945945945,"d":"75%"}},null,"2012-05-10"," משיכה מכספומט ",{"v":30,"d":"30.00"},"אחר"]

{"sheet":"סיכום חודשי","index":1,"n_rows":26,"n_cols":9,"rows_kept":26}
[null,"סיכום חודשי"]
[null,"סיכום חשבון"]
{"$rows_empty":13}
[null,"סיכום הוצאות"]
[null,"סכום של סכום"]
[null,null," ארוחת ערב "," ארוחת צהריים "," הוצאות רכב "," חשבון חשמל "," משיכה מכספומט "," משיכת מזומנים ","סכום כולל"]
[null,"ינו",null,5,230,null,40,null,275]
[null,"פבר",53,null,null,70,null,null,123]
[null,"מרץ"]
[null,"חיסכון",{"$nulls":5},100,100]
[null,"עו\"ש",null,null,230,{"$nulls":3},230]
[null,"אפר",{"$nulls":3},70,30,null,100]
[null,"מאי",{"$nulls":4},80,null,80]
[null,"סכום כולל",53,5,460,140,150,100,908]

{"sheet":"נתוני תרשים","index":2,"n_rows":10,"n_cols":6,"rows_kept":10}
[null,"נתוני PivotChart"]
[null,"PivotTable זה הוא מקור הנתונים עבור ה- PivotChart 'סיכום חשבון' בגיליון 'סיכום חודשי'"]
[null,"סכום של סכום","תוויות עמודה"]
[null,"תוויות שורה","אחר","חיסכון","עו\"ש","סכום כולל"]
[null,"ינו",null,{"v":230,"d":"230.00"},{"v":45,"d":"45.00"},{"v":275,"d":"275.00"}]
[null,"פבר",null,null,{"v":123,"d":"123.00"},{"v":123,"d":"123.00"}]
[null,"מרץ",null,{"v":100,"d":"100.00"},{"v":230,"d":"230.00"},{"v":330,"d":"330.00"}]
[null,"אפר",null,{"v":70,"d":"70.00"},{"v":30,"d":"30.00"},{"v":100,"d":"100.00"}]
[null,"מאי",{"v":30,"d":"30.00"},{"v":50,"d":"50.00"},null,{"v":80,"d":"80.00"}]
[null,"סכום כולל",{"v":30,"d":"30.00"},{"v":450,"d":"450.00"},{"v":428,"d":"428.00"},{"v":908,"d":"908.00"}]