{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["שווי נקי אישי","נכסים","חובות"],"not_rendered":{"charts":2,"images":2,"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"שווי נקי אישי","index":0,"n_rows":21,"n_cols":25,"rows_kept":21,"merged":[[3,2,4,7]]}
[{"$nulls":14}," "]
[{"$nulls":16},"מזומן ושווה ערך למזומן",{"$f":"SUMIF(TBL_Assets[קטגוריה],'שווי נקי אישי'!Q2,TBL_Assets[ערך])+ROW(Q2)/10000","v":42500.0002},{"$f":"_xlfn.RANK.EQ(R2,$R$2:$R$6,0)","v":5},null,{"$f":"INDEX($Q$2:$R$6,MATCH(5,$S$2:$S$6,0),1)","v":"מזומן ושווה ערך למזומן"},{"$f":"ROUND(INDEX($Q$2:$R$6,MATCH(5,$S$2:$S$6,0),2),2)","v":42500},null,"סה\"כ נכסים",{"$f":"SUM(TBL_Assets[ערך])","v":1923500}]
[null,null," שווי נקי אישי",{"$nulls":13},"מאפיינים",{"$f":"SUMIF(TBL_Assets[קטגוריה],'שווי נקי אישי'!Q3,TBL_Assets[ערך])+ROW(Q3)/10000","v":1205000.0003},{"$f":"_xlfn.RANK.EQ(R3,$R$2:$R$6,0)","v":1},null,{"$f":"INDEX($Q$2:$R$6,MATCH(4,$S$2:$S$6,0),1)","v":"חיסכון לפרישה"},{"$f":"ROUND(INDEX($Q$2:$R$6,MATCH(4,$S$2:$S$6,0),2),2)","v":98000},null,"סה”כ חובות",{"$f":"SUM(TBL_Debts[ערך])","v":652500}]
[null,null,{"$f":"F6-F8","v":{"v":1271000,"d":"₪ 1,271,000"}},{"$nulls":6},"נכסים לעומת חובות",{"$nulls":6},"השקעות",{"$f":"SUMIF(TBL_Assets[קטגוריה],'שווי נקי אישי'!Q4,TBL_Assets[ערך])+ROW(Q4)/10000","v":475000.0004},{"$f":"_xlfn.RANK.EQ(R4,$R$2:$R$6,0)","v":2},null,{"$f":"INDEX($Q$2:$R$6,MATCH(3,$S$2:$S$6,0),1)","v":"ביטוח חיים"},{"$f":"ROUND(INDEX($Q$2:$R$6,MATCH(3,$S$2:$S$6,0),2),2)","v":103000}]
[{"$nulls":16},"חיסכון לפרישה",{"$f":"SUMIF(TBL_Assets[קטגוריה],'שווי נקי אישי'!Q5,TBL_Assets[ערך])+ROW(Q5)/10000","v":98000.0005},{"$f":"_xlfn.RANK.EQ(R5,$R$2:$R$6,0)","v":4},null,{"$f":"INDEX($Q$2:$R$6,MATCH(2,$S$2:$S$6,0),1)","v":"השקעות"},{"$f":"ROUND(INDEX($Q$2:$R$6,MATCH(2,$S$2:$S$6,0),2),2)","v":475000}]
[{"$nulls":4},"סה\"כ נכסים",{"$f":"SUM(TBL_Assets[ערך])","v":{"v":1923500,"d":"₪ 1,923,500"}},{"$nulls":10},"ביטוח חיים",{"$f":"SUMIF(TBL_Assets[קטגוריה],'שווי נקי אישי'!Q6,TBL_Assets[ערך])+ROW(Q6)/10000","v":103000.0006},{"$f":"_xlfn.RANK.EQ(R6,$R$2:$R$6,0)","v":3},null,{"$f":"INDEX($Q$2:$R$6,MATCH(1,$S$2:$S$6,0),1)","v":"מאפיינים"},{"$f":"ROUND(INDEX($Q$2:$R$6,MATCH(1,$S$2:$S$6,0),2),2)","v":1205000}]
[]
[{"$nulls":4},"סה”כ חובות",{"$f":"SUM(TBL_Debts[ערך])","v":{"v":652500,"d":"₪ 652,500"}}]
[]
[]
[]
[{"$nulls":3},"סיכום נכסים"]
[{"$nulls":10},{"$f":"U6","v":"מאפיינים"},{"$f":"V6","v":{"v":1205000,"d":"₪ 1,205,000"}}]
[]
[{"$nulls":10},{"$f":"U5","v":"השקעות"},{"$f":"V5","v":{"v":475000,"d":"₪ 475,000"}}]
[]
[{"$nulls":10},{"$f":"U4","v":"ביטוח חיים"},{"$f":"V4","v":{"v":103000,"d":"₪ 103,000"}}]
[]
[{"$nulls":10},{"$f":"U3","v":"חיסכון לפרישה"},{"$f":"V3","v":{"v":98000,"d":"₪ 98,000"}}]
[]
[{"$nulls":10},{"$f":"U2","v":"מזומן ושווה ערך למזומן"},{"$f":"V2","v":{"v":42500,"d":"₪ 42,500"}}]

{"sheet":"נכסים","index":1,"n_rows":25,"n_cols":5,"rows_kept":25}
[{"$nulls":4}," "]
[null,"נכסים"]
[]
[null,"קטגוריה","פריט","ערך"]
[null,"מאפיינים","בית",{"v":560000,"d":"₪ 560,000.00"}]
[null,"מאפיינים","אחר",{"v":255000,"d":"₪ 255,000.00"}]
[null,"חיסכון לפרישה","חשבונות לפרישה",{"v":98000,"d":"₪ 98,000.00"}]
[null,"השקעות","מניות",{"v":53000,"d":"₪ 53,000.00"}]
[null,"השקעות","אגרות חוב",{"v":25000,"d":"₪ 25,000.00"}]
[null,"השקעות","קרנות נאמנות",{"v":33000,"d":"₪ 33,000.00"}]
[null,"השקעות","תעודות פיקדון",{"v":74000,"d":"₪ 74,000.00"}]
[null,"השקעות","מטילי זהב",{"v":20000,"d":"₪ 20,000.00"}]
[null,"השקעות","קרנות השתלמות",{"v":250000,"d":"₪ 250,000.00"}]
[null,"ביטוח חיים","חשבון חיסכון בריאותי",{"v":18000,"d":"₪ 18,000.00"}]
[null,"ביטוח חיים","ערך נקוב של פוליסת ביטוח חיים",{"v":85000,"d":"₪ 85,000.00"}]
[null,"השקעות","אחר",{"v":20000,"d":"₪ 20,000.00"}]
[null,"מזומן ושווה ערך למזומן","חשבונות עו\"ש",{"v":35500,"d":"₪ 35,500.00"}]
[null,"מזומן ושווה ערך למזומן","חשבונות חיסכון",{"v":5000,"d":"₪ 5,000.00"}]
[null,"מזומן ושווה ערך למזומן","אחר",{"v":2000,"d":"₪ 2,000.00"}]
[null,"מאפיינים","מכוניות",{"v":55000,"d":"₪ 55,000.00"}]
[null,"מאפיינים","כלי רכב אחרים",{"v":85000,"d":"₪ 85,000.00"}]
[null,"מאפיינים","ריהוט",{"v":100000,"d":"₪ 100,000.00"}]
[null,"מאפיינים","פריטי אספנות",{"v":50000,"d":"₪ 50,000.00"}]
[null,"מאפיינים","תכשיטים",{"v":60000,"d":"₪ 60,000.00"}]
[null,"מאפיינים","מוצרי מותרות אחרים",{"v":40000,"d":"₪ 40,000.00"}]

{"sheet":"חובות","index":2,"n_rows":14,"n_cols":4,"rows_kept":14}
[{"$nulls":3}," "]
[null,"חובות"]
[]
[null,"קטגוריה","ערך"]
[null,"משכנתאות",{"v":400000,"d":"₪ 400,000.00"}]
[null,"הלוואות המבוססות על שווי הבית",{"v":50000,"d":"₪ 50,000.00"}]
[null,"הלוואות רכב",{"v":30000,"d":"₪ 30,000.00"}]
[null,"הלוואות אישיות",{"v":12500,"d":"₪ 12,500.00"}]
[null,"כרטיסי אשראי",{"v":65000,"d":"₪ 65,000.00"}]
[null,"הלוואות סטודנט",{"v":10000,"d":"₪ 10,000.00"}]
[null,"הלוואות כנגד השקעות",{"v":20000,"d":"₪ 20,000.00"}]
[null,"הלוואות ביטוח חיים",{"v":5000,"d":"₪ 5,000.00"}]
[null,"הלוואות אחרות בתשלומים",{"v":10000,"d":"₪ 10,000.00"}]
[null,"חובות אחרים",{"v":50000,"d":"₪ 50,000.00"}]