{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["לוח המחוונים","נכסים","התחייבויות","חישובים"],"not_rendered":{"charts":4,"defined_names":4},"read":"whole","date_system":"1900"}

{"sheet":"לוח המחוונים","index":0,"n_rows":16,"n_cols":8,"rows_kept":16}
[]
[null,"לוח המחוונים",{"$nulls":4},"תקציר שווי נקי"," "]
{"$rows_empty":8}
[null,{"$f":"NetWorth","v":{"v":159600,"d":"₪ 159,600"}},null,{"$f":"TotalAssets","v":{"v":380800,"d":"₪ 380,800"}},null,null,{"$f":"TotalLiabilites","v":{"v":221200,"d":"₪ 221,200"}}]
[null,"שווי נקי",null,"סך כל הנכסים",null,null,"סך כל ההתחייבויות"]
[{"$nulls":3},"מזומן",null,null,"לא מובטחות"]
[{"$nulls":3},"השקעות",null,null,"מובטחות"]
[{"$nulls":3},"פרישה"]
[{"$nulls":3},"אישי"]

{"sheet":"נכסים","index":1,"n_rows":23,"n_cols":10,"rows_kept":23,"merged":[[11,1,12,1],[13,1,14,1],[13,2,13,4],[13,6,13,8],[23,2,23,4],[23,6,23,8]]}
[]
[null,"נכסים",{"$nulls":5},"תקציר שווי נקי",null," "]
[]
[null,null," ","מזומן","ערך",null," ","אישי","ערך"]
[{"$nulls":3},"מזומנים לשימוש מיידי",{"v":2000,"d":"2,000"},null,null,"מקום מגורים מרכזי",{"v":233000,"d":"233,000"}]
[{"$nulls":3},"חשבונות עובר ושב",{"v":2500,"d":"2,500"},null,null,"מקום מגורים משני"]
[{"$nulls":3},"חשבונות חיסכון",{"v":4000,"d":"4,000"},null,null,"פריטי אוספים"]
[{"$nulls":3},"חשבונות MONEY MARKET",{"v":3300,"d":"3,300"},null,null,"רכבים",{"v":32000,"d":"32,000"}]
[{"$nulls":3},"חשבונות MONEY MARKET FUND",{"v":7000,"d":"7,000"},null,null,"ריהוט לבית",{"v":10000,"d":"10,000"}]
[{"$nulls":3},"תעודות פיקדון (CD)",{"$nulls":3},"פרוות ותכשיטים"]
[{"$nulls":3},"U.S. TREASURY BILLS",{"$nulls":3},"נכסים אחרים",{"v":1500,"d":"1,500"}]
[null,{"$f":"TotalAssets","v":{"v":380800,"d":"₪ 380,800"}},null,"ערך המזומן של ביטוח חיים",{"v":24500,"d":"24,500"}]
[{"$nulls":3},"סיכום ביניים",{"$f":"SUBTOTAL(109,tblCash[ערך])","v":{"v":43300,"d":"43,300"}},null,null,"סיכום ביניים",{"$f":"SUBTOTAL(109,tblPersonal[ערך])","v":{"v":276500,"d":"276,500"}}]
[null,"סך כל הנכסים"]
[]
[null,null," ","השקעות","ערך",null," ","פרישה","ערך"]
[{"$nulls":3},"מניות",{"v":15000,"d":"15,000"},null,null,"פנסיה"]
[{"$nulls":3},"אגרות חוב",{"$nulls":3},"חשבונות IRA"]
[{"$nulls":3},"השקעות בקרנות נאמנות",{"$nulls":3},"חשבונות KEOGH"]
[{"$nulls":3},"זכויות בשותפויות",{"$nulls":3},"401K",{"v":46000,"d":"46,000"}]
[{"$nulls":3},"השקעות אחרות",{"$nulls":3},"SEP"]
[{"$nulls":7},"ESOP"]
[{"$nulls":3},"סיכום ביניים",{"$f":"SUBTOTAL(109,tblInvestments[ערך])","v":{"v":15000,"d":"15,000"}},null,null,"סיכום ביניים",{"$f":"SUBTOTAL(109,tblRetirement[ערך])","v":{"v":46000,"d":"46,000"}}]

{"sheet":"התחייבויות","index":2,"n_rows":14,"n_cols":10,"rows_kept":14,"merged":[[11,1,12,1],[13,1,14,1]]}
[]
[null,"התחייבויות",{"$nulls":5},"תקציר שווי נקי",null," "]
[]
[null,null," ","לא מובטחות","חבות",null," ","מובטחות","חבות"]
[{"$nulls":3},"כרטיסי אשראי",{"v":1200,"d":"1,200"},null,null,"הלוואות רכב",{"v":14500,"d":"14,500"}]
[{"$nulls":3},"חשבונות CHARGE",{"v":3000,"d":"3,000"},null,null,"הלוואות לרכב פנאי"]
[{"$nulls":3},"הלוואות סטודנטים",{"v":17500,"d":"17,500"},null,null,"הלוואות למוצרי חשמל"]
[{"$nulls":3},"דמי מזונות",{"$nulls":3},"משכנתאות",{"v":144000,"d":"144,000"}]
[{"$nulls":3},"מזונות ילדים",{"$nulls":3},"משכנתה נוספת (הלוואות Home Equity)",{"v":21000,"d":"21,000"}]
[{"$nulls":3},"התחייבויות מס",{"v":8000,"d":"8,000"},null,null,"הלוואות אחרות"]
[{"$nulls":3},"אחר",{"v":6000,"d":"6,000"},null,null,"התחייבויות מס",{"v":4000,"d":"4,000"}]
[null,{"$f":"TotalLiabilites","v":{"v":221200,"d":"₪ 221,200"}},{"$nulls":5},"אחר",{"v":2000,"d":"2,000"}]
[{"$nulls":3},"סיכום ביניים",{"$f":"SUBTOTAL(109,tblUnsecured[חבות])","v":{"v":35700,"d":"35,700"}},null,null,"סיכום ביניים",{"$f":"SUBTOTAL(109,tblSecured[חבות])","v":{"v":185500,"d":"185,500"}}]
[null,"סך כל הנכסים"]

{"sheet":"חישובים","index":3,"n_rows":23,"n_cols":3,"rows_kept":23,"hidden":true}
[]
[null,"*** על גליון זה להישאר מוסתר ***"]
{"$rows_empty":8}
[null,{"$f":"tblCash[[#Headers],[מזומן]]","v":"מזומן"},{"$f":"SUM(tblCash[ערך])","v":{"v":43300,"d":"₪ 43,300"}}]
[null,{"$f":"tblInvestments[[#Headers],[השקעות]]","v":"השקעות"},{"$f":"SUM(tblInvestments[ערך])","v":{"v":15000,"d":"₪ 15,000"}}]
[null,{"$f":"tblRetirement[[#Headers],[פרישה]]","v":"פרישה"},{"$f":"SUM(tblRetirement[ערך])","v":{"v":46000,"d":"₪ 46,000"}}]
[null,{"$f":"tblPersonal[[#Headers],[אישי]]","v":"אישי"},{"$f":"SUM(tblPersonal[ערך])","v":{"v":276500,"d":"₪ 276,500"}}]
[null,"סך כל הנכסים",{"$f":"SUM(tblCash[ערך],tblInvestments[ערך],tblRetirement[ערך],tblPersonal[ערך])","v":{"v":380800,"d":"₪ 380,800"}}]
[]
[]
[null,{"$f":"tblUnsecured[[#Headers],[לא מובטחות]]","v":"לא מובטחות"},{"$f":"SUM(tblUnsecured[חבות])","v":{"v":35700,"d":"₪ 35,700"}}]
[null,{"$f":"tblSecured[[#Headers],[מובטחות]]","v":"מובטחות"},{"$f":"SUM(tblSecured[חבות])","v":{"v":185500,"d":"₪ 185,500"}}]
[null,"סך כל הנכסים",{"$f":"SUM(tblUnsecured[חבות],tblSecured[חבות])","v":{"v":221200,"d":"₪ 221,200"}}]
[]
[]
[null,"סך כל הנכסים",{"$f":"C15-C20","v":{"v":159600,"d":"₪ 159,600"}}]