{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["שיקוף"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":27,"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":"שיקוף","index":0,"n_rows":61,"n_cols":65,"rows_kept":61,"cut":false,"hidden":false,"merged":[[26,8,26,10],[26,14,26,26],[36,3,36,4],[46,3,46,4],[47,3,47,4],[48,3,48,4],[46,14,46,15],[44,14,44,15],[44,19,44,21],[27,25,27,26],[37,18,37,22],[38,29,38,31],[69,29,69,30],[51,3,51,5],[52,3,52,5],[51,6,52,6],[64,29,64,30],[66,29,66,30],[49,2,49,3],[50,29,50,31],[43,29,43,31],[65,29,65,30],[49,29,49,31],[44,29,44,31],[49,39,49,41],[49,14,49,16],[47,39,47,41],[47,14,47,15],[48,29,48,31],[48,39,48,41],[47,29,47,31],[67,29,67,30],[68,29,68,30],[40,34,40,36],[40,39,40,41],[45,39,45,41],[45,14,45,15],[46,29,46,31],[46,39,46,41],[48,14,48,15],[44,34,44,36],[44,39,44,41],[45,29,45,31],[41,29,41,31],[39,39,39,41],[35,39,35,41],[49,45,49,46],[36,8,36,11],[36,14,36,15],[36,18,36,22],[37,29,37,32],[37,34,37,37],[37,39,37,42],[37,8,37,11],[39,8,39,11],[40,8,41,8],[40,9,41,9],[40,10,41,10],[40,11,41,11],[40,14,40,15],[40,19,40,20],[43,34,43,36],[43,39,43,41],[43,14,43,15],[43,19,43,20],[39,14,39,17],[39,19,39,22],[40,29,40,31],[30,39,30,40],[33,39,33,40],[47,45,47,46],[33,8,34,8],[33,9,34,9],[33,10,34,10],[33,11,34,11],[34,39,34,40],[40,45,40,46],[41,34,41,36],[31,39,31,40],[46,45,46,46],[32,8,32,11],[32,39,32,40],[41,19,41,20],[42,29,42,31],[42,34,42,36],[41,39,41,41],[41,14,41,15],[42,39,42,41],[38,34,38,36],[38,39,38,41],[39,29,39,31],[39,34,39,36],[20,31,21,31],[20,32,21,32],[27,39,27,40],[28,39,28,40],[20,34,20,35],[20,39,20,40],[23,18,23,19],[21,34,21,35],[21,39,21,40],[20,18,20,19],[21,18,21,19],[22,18,22,19],[27,21,27,22],[27,23,27,24],[15,8,15,9],[19,14,19,15],[19,18,19,19],[17,34,17,35],[17,39,17,40],[14,34,14,37],[17,14,17,15],[17,18,17,19],[29,39,29,40],[25,39,25,40],[22,29,22,30],[22,34,22,35],[22,39,22,40],[23,29,23,30],[23,34,23,35],[23,39,23,40],[24,29,25,30],[24,31,25,31],[24,32,25,32],[24,34,24,36],[24,39,24,40],[26,29,26,31],[26,39,26,40],[20,29,21,30],[18,34,18,35],[18,39,18,40],[19,8,19,10],[19,29,19,30],[19,34,19,35],[19,39,19,40],[18,29,18,30],[18,14,18,15],[18,18,18,19],[13,18,13,19],[14,14,14,15],[14,18,14,19],[16,14,16,15],[16,18,16,19],[15,14,15,15],[15,18,15,19],[14,39,14,42],[15,29,15,30],[15,34,15,35],[15,39,15,40],[16,29,17,30],[16,31,17,31],[16,32,17,32],[14,29,14,32],[16,34,16,35],[16,39,16,40],[9,39,9,40],[12,14,12,16],[12,18,12,20],[10,34,10,36],[10,39,11,40],[10,14,10,15],[2,55,2,64],[10,42,11,42],[4,29,4,30],[4,34,4,35],[4,39,4,40],[5,29,5,30],[5,34,5,35],[5,39,5,40],[6,29,6,30],[9,34,9,35],[8,29,8,31],[8,34,8,35],[8,39,8,40],[10,41,11,41],[12,39,12,41],[1,55,1,56],[7,29,7,30],[7,34,7,35],[7,39,7,40],[6,34,6,35],[6,39,6,40],[2,29,2,32],[2,34,2,37],[2,39,2,42],[3,29,3,30],[3,34,3,35],[3,39,3,40],[37,1,48,1],[15,1,36,1],[4,1,14,1],[2,1,3,1],[2,2,3,3],[2,5,2,6],[13,14,13,15],[1,3,1,6],[1,8,1,11],[2,8,2,9],[2,10,2,11],[2,14,2,20],[27,10,28,10],[27,14,28,14],[27,15,27,16],[27,17,27,18],[27,19,27,20],[42,14,42,15],[42,19,42,20],[20,14,20,15],[12,3,12,4],[13,3,13,4],[14,3,14,4],[35,3,35,4]]}
[null,null,null,null,null,null,null,null,null,"www.paamonim.org",null,null,null,null,null,null,null,"מחשבוני עזר",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"מחשבוני עזר (המשך)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"שיקוף חובות"]
[null,null,null,"הוצאות חודשיות",null,null,null,null,"הכנסות חודשיות"]
[null,null,"הוצאות",null,null,"סיכום חודשי",null,null,"הכנסות",null,"סיכום חודשי",null,null,null,{"$f":"D5","v":"משכנתא"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D24","v":"תיקוני רכב"},null,null,null,null,{"$f":"D25","v":"ביגוד והנעלה"},null,null,null,null,{"$f":"D26","v":"בריאות"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"חישובי עזר"]
[null,null,null,null,null,"שיקוף","תקציב",null,"סוג ההכנסה","מקור ההכנסה","שיקוף","תקציב",null,null,null,"סוג","תשלום חודשי","חודשים שנשארו","אחוזי ריבית","יתרת החוב","נכון לתאריך",null,null,null,null,null,null,null,null,null,null,"עלות שנתית","עלות חודשית",null,null,null,"עלות שנתית","עלות חודשית",null,null,null,"עלות שנתית","עלות חודשית",null,null,null,"שם הנושה","סכום החוב","נכון ליום","אחוז ריבית","מס' תשלומים נותרים","סכום החזר החודש","נותר לתשלום","הערות",null,"חובות בהסדר","חובות שאינם בהסדר",null,null,"שם הנושה","סכום החוב","מס' תשלומים נותרים","סכום החזר החודש","נותר לתשלום","הערות"]
[null,"קבועות חודשיות",6,"משכנתא",null,null,{"$f":"F5","v":0},null,"בעל עבודה 1",null,0,{"$f":"K5","v":0},null,null,"משכנתא 1","זכאות /משלימה",null,null,null,null,null,null,null,null,null,null,null,null,null,"מוסך / תאונות / צביעה / מיזוג",null,null,{"$f":"AF5/12","v":0},null,"קיץ הורים",null,null,{"$f":"AK5/12","v":0},null,"התייעצות עם מומחה",null,null,{"$f":"AP5/12","v":0},null,null,1,"כ",30000,null,null,null,null,{"$f":"IF(AY5=\"\",AV5,AY5*AZ5)","v":30000},null,null,{"$f":"IF(AY5=\"\",0,BA5)","v":0},{"$f":"IF(AY5=\"\",BA5,0)","v":30000},null,{"$f":"INDEX($AT$5:$AT$40,MATCH(TRUE,INDEX(($AY$5:$AY$40<>0),0),0))","v":2},{"$f":"IF(ISERROR(VLOOKUP($BG5,$AT$4:$BB$41,MATCH(BH$4,$AT$4:$BB$4,0),0)),\"\",VLOOKUP($BG5,$AT$4:$BB$41,MATCH(BH$4,$AT$4:$BB$4,0),0))","v":"ג"},200000,10,2000,20000,0]
[null,null,null,"ביטוח משכנתא",null,null,{"$f":"F6","v":0},null,"בעל עבודה 2",null,null,{"$f":"K6","v":0},null,null,"משכנתא 2","זכאות /משלימה",null,null,null,null,null,null,null,null,null,null,null,null,null,"עבודות חוץ / תיקון פרונט",null,null,{"$f":"AF6/12","v":0},null,"חורף הורים",null,null,0,null,"מכשור רפואי",null,null,{"$f":"AP6/12","v":0},null,null,{"$f":"IF(AU6=\"\",\"\",AT5+1)","v":2},"ג",200000,null,null,10,2000,{"$f":"IF(AY6=\"\",AV6,AY6*AZ6)","v":20000},null,null,{"$f":"IF(AY6=\"\",0,BA6)","v":20000},{"$f":"IF(AY6=\"\",BA6,0)","v":0},null,{"$f":"INDEX(INDIRECT(\"AT\"&BG5+5 &\":AT40\"),MATCH(TRUE,INDEX((INDIRECT(\"AY\"&BG5+5 &\":AY40\")<>0),0),0))","v":{"$error":"#N/A"}},{"$f":"IF(ISERROR(VLOOKUP($BG6,$AT$4:$BB$41,MATCH(BH$4,$AT$4:$BB$4,0),0)),\"\",VLOOKUP($BG6,$AT$4:$BB$41,MATCH(BH$4,$AT$4:$BB$4,0),0))","v":""},"","","","",""]
[null,null,null,"שכר דירה",null,null,0,null,"אישה עבודה 1",null,null,0,null,null,"משכנתא 3","זכאות /משלימה",null,null,null,null,null,null,null,null,null,null,null,null,null,"אביזרים / צמיגים / תקרים",null,null,{"$f":"AF7/12","v":0},null,"קיץ ילדים",null,null,0,null,"אמבולנס / בי\"ח",null,null,0,null,null,{"$f":"IF(AU7=\"\",\"\",AT6+1)","v":""},null,null,null,null,null,null,0,null,null,0,0,null,{"$error":"#N/A"},"","","","","",""]
[null,null,null,"מיסי ישוב / ועד בית",null,null,0,null,"אישה עבודה 2",null,null,0,null,null,"משכנתא 4","זכאות /משלימה",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AF8/12","v":0},null,"חורף ילדים",null,null,0,null,"רפואה אלטרנטיבית",null,null,0,null,null,"",null,null,null,null,null,null,0,null,null,0,0,null,{"$error":"#N/A"},"","","","","",""]
[null,null,6,"ביטוחים (למעט רכב)",null,{"$f":"IF(Q21<>\"\",Q21,\"\")","v":0},0,null,"קצבת ילדים",null,null,0,null,null,"משכנתא 5","זכאות /משלימה",null,null,null,null,null,null,null,null,null,null,null,null,null,"סה\"כ לחודש",null,null,{"$f":"SUM(AG5:AG8)","v":0},null,"נעליים",null,null,0,null,"תשלום לטיפת חלב",null,null,0,null,null,"",null,null,null,null,null,null,0,null,null,0,0,null,{"$error":"#N/A"},"","","","","",""]
[null,null,null,"הוראות קבע לחיסכון",null,null,0,null,"קצבאות נוספות",null,null,0,null,null,"משכנתא 6","זכאות /משלימה",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"פריטים קטנים",null,null,0,null,"תרופות",null,null,0,null,null,"",null,null,null,null,null,null,0,null,null,0,0,null,{"$error":"#N/A"},"","","","","",""]
[null,null,6,"מנויים",null,{"$f":"IF(U24<>\"\",U24,\"\")","v":0},0,null,"סיוע בשכר דירה",null,null,0,null,null,"סה\"כ לחודש",null,{"$f":"SUM(Q5:Q10)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"סה\"כ לחודש",null,null,{"$f":"SUM(AL5:AL10)","v":0},null,"מרפאה / צילום / רופא מקצועי / תשלום רבעוני",null,null,0,null,null,"",null,null,null,null,null,null,0,null,null,0,0,null,{"$error":"#N/A"},"","","","","",""]
[null,null,null,"תרומות בהוראת קבע",null,null,0,null,"מזונות",null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"",null,null,null,null,null,null,0,null,null,0,0,null,{"$error":"#N/A"},"","","","","",""]
[null,null,null,null,null,null,0,null,"הכנסה מנכס",null,null,0,null,null,{"$f":"D9","v":"ביטוחים (למעט רכב)"},null,null,null,{"$f":"D11","v":"מנויים"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"סה\"כ לחודש",null,null,{"$f":"SUM(AQ5:AQ12)","v":0},null,null,"",null,null,null,null,null,null,0,null,null,0,0,null,{"$error":"#N/A"},"","","","","",""]
[null,null,null,null,null,null,{"$f":"F14","v":0},null,"סיוע מההורים",null,null,0,null,null,null,null,"עלות חודשית",null,null,null,"עלות חודשית",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,0,null,null,0,0,null,{"$error":"#N/A"},"","","","","",""]
[null,null,null,null,null,null,0,null,null,null,null,0,null,null,"ביטוח חיים",null,null,null,"עיתון",null,null,null,null,null,null,null,null,null,null,{"$f":"D31","v":"יהדות / חגים"},null,null,null,null,{"$f":"D32","v":"מתנות לאירועים ושמחות"},null,null,null,null,{"$f":"D33","v":"רכישות ושרותים"},null,null,null,null,null,"",null,null,null,null,null,null,0,null,null,0,0,null,{"$error":"#N/A"},"","","","","",""]
[null,"תקופתיות",null,"ארנונה / שמירה",null,null,0,null,"סה\"כ הכנסות",null,{"$f":"SUM(K5:K15)","v":0},{"$f":"SUM(L5:L15)","v":0},null,null,"ביטוח רכוש  (נכס / תכולה)",null,null,null,"כבלים/Hot/Yes",null,null,null,null,null,null,null,null,null,null,null,null,"עלות שנתית","עלות חודשית",null,null,null,"עלות שנתית","עלות חודשית",null,null,null,"עלות שנתית","עלות חודשית",null,null,"",null,null,null,null,null,null,0,null,null,0,0,null,{"$error":"#N/A"},"","","","","",""]
[null,null,null,"מים וביוב",null,null,0,null,null,null,null,null,null,null,"ביטוח משלים",null,null,null,"ספריה",null,null,null,null,null,null,null,null,null,null,"חגי תשרי - ר\"ה, סוכות, הוצאות לסוכה, 4 מינים וכו'",null,null,{"$f":"AF17/12","v":0},null,"בר / בת מצווה",null,null,{"$f":"AK17/12","v":0},null,"ריהוט, צרכי מטבח",null,null,{"$f":"AP17/12","v":0},null,null,"",null,null,null,null,null,null,0,null,null,0,0,null,{"$error":"#N/A"},"","","","","",""]
[null,null,null,"חשמל",null,null,0,null,null,null,null,null,null,null,"ביטוח בריאות וסיעוד",null,null,null,"ספק אינטרנט",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ברית",null,null,{"$f":"AK18/12","v":0},null,"מכשירי חשמל ואלקטרוניקה",null,null,{"$f":"AP18/12","v":0},null,null,"",null,null,null,null,null,null,0,null,null,0,0,null,{"$error":"#N/A"},"","","","","",""]
[null,null,null,"גז",null,null,0,null,null,null,null,null,null,null,null,null,null,null,"הגרלות",null,null,null,null,null,null,null,null,null,null,"חנוכה - נרות, דמי חנוכה",null,null,{"$f":"AF19/12","v":0},null,"חתונה",null,null,0,null,"אינסטלציה",null,null,0,null,null,"",null,null,null,null,null,null,0,null,null,0,0,null,{"$error":"#N/A"},"","","","","",""]
[null,null,null,"חימום - סולר / נפט",null,null,0,null,"סיכום הוצאות",null,null,null,null,null,null,null,null,null,"ספורט/חדר כושר",null,null,null,null,null,null,null,null,null,null,"ט\"ו בשבט - פירות לט\"ו בשבט",null,null,{"$f":"AF20/12","v":0},null,"יום הולדת",null,null,0,null,"תפירה",null,null,0,null,null,"",null,null,null,null,null,null,0,null,null,0,0,null,{"$error":"#N/A"},"","","","","",""]
[null,null,6,"חינוך",null,{"$f":"IF(Q37<>\"\",Q37,\"\")","v":0},0,null,"קטגוריה","שיקוף","תקציב",null,null,null,"סה\"כ לחודש",null,{"$f":"SUM(Q15:Q20)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"פורים - משלוח מנות, מתנות לאביונים, תחפושות",null,null,0,null,"לבן הזוג / לילדים",null,null,0,null,"משחקים, צעצועים",null,null,0,null,null,"",null,null,null,null,null,null,0,null,null,0,0,null,{"$error":"#N/A"},"","","","","",""]
[null,null,6,"חוגים, קייטנות ובריכה",null,{"$f":"IF(R50<>\"\",R50,\"\")","v":0},0,null,"חודשיות קבועות",{"$f":"SUM(F5:F15)","v":0},{"$f":"SUM(G5:G15)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,"אירוע בעבודה",null,null,0,null,"כלי עבודה, נעילה",null,null,0,null,null,"",null,null,null,null,null,null,0,null,null,0,0,null,{"$error":"#N/A"},"","","","","",""]
[null,null,6,"ביטוחי רכב + טסט",null,{"$f":"IF(W45<>\"\",W45,\"\")","v":0},0,null,"תקופתיות",{"$f":"SUM(F16:F37)","v":0},{"$f":"SUM(G16:G37)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"פסח, מימונה, סיגד",null,null,0,null,"למורה / לגננת",null,null,0,null,"מגבות, מצעים, מזרנים, ריפוד",null,null,0,null,null,"",null,null,null,null,null,null,0,null,null,0,0,null,{"$error":"#N/A"},"","","","","",""]
[null,null,6,"תיקוני רכב",null,{"$f":"IF(AG9<>\"\",AG9,\"\")","v":0},0,null,"שוטפות",{"$f":"SUM(F38:F49)","v":0},{"$f":"SUM(G38:G49)","v":0},null,null,null,null,null,null,null,"סה\"כ לחודש",null,{"$f":"SUM(U15:U23)","v":0},null,null,null,null,null,null,null,null,"תפילין, ציצית, מזוזות, ספרי קודש",null,null,0,null,"שונות",null,null,0,null,"אופניים, עגלה",null,null,0,null,null,"",null,null,null,null,null,null,0,null,null,0,0,null,{"$error":"#N/A"},"","","","","",""]
[null,null,6,"ביגוד והנעלה",null,{"$f":"IF(AL11<>\"\",AL11,\"\")","v":0},0,null,"סה\"כ הוצאות",{"$f":"SUM(J22:J24)","v":0},{"$f":"SUM(K22:K24)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"צדקה, בית כנסת, מקווה, יזכור, עליה לתורה",null,null,0,null,"סה\"כ לחודש",null,null,{"$f":"SUM(AL17:AL24)","v":0},null,"רשיון נהיגה לילדים",null,null,0,null,null,"",null,null,null,null,null,null,0,null,null,0,0,null,{"$error":"#N/A"},"","","","","",""]
[null,null,6,"בריאות",null,{"$f":"IF(AQ13<>\"\",AQ13,\"\")","v":0},0,null,null,null,null,null,null,null,"שימו לב! בהעברת נתוני המחשבונים לתוכנה, יש לקחת את הנתונים מעמודות \"עלות חודשית\"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,"מכשירי כתיבה",null,null,0,null,null,"",null,null,null,null,null,null,0,null,null,0,0,null,{"$error":"#N/A"},"","","","","",""]
[null,null,null,"עמלות וריביות בנקים",null,null,0,null,"סיכום חובות",null,null,null,null,null,{"$f":"D21","v":"חינוך"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"סה\"כ לחודש",null,null,{"$f":"SUM(AG17:AG26)","v":0},null,null,null,null,null,null,"עיצוב הבית",null,null,0,null,null,"",null,null,null,null,null,null,0,null,null,0,0,null,{"$error":"#N/A"},"","","","","",""]
[null,null,null,"טיפולי שיניים",null,null,0,null,"סוג החוב","סכום","סה\"כ החזרי חובות חודשיים",null,null,null,"שם / גיל","הסעות, נסיעות, אוכל",null,"תשלום למוסד",null,"צהרון / מטפלת",null,"שיעורים פרטיים",null,"תשלומי הורים / טיולים",null,"ספרי לימוד / מכשירי כתיבה",null,null,null,null,null,null,null,null,null,null,null,null,null,"ניקוי יבש, כביסה",null,null,0,null,null,"",null,null,null,null,null,null,0,null,null,0,0,null,{"$error":"#N/A"},"","","","","",""]
[null,null,null,"אופטיקה",null,null,0,null,"חובות שאינם בהסדר",{"$f":"AV50","v":30000},null,null,null,null,null,"עלות שנתית *","עלות חודשית","עלות שנתית *","עלות חודשית","עלות שנתית *","עלות חודשית","עלות שנתית *","עלות חודשית","עלות שנתית *","עלות חודשית","עלות שנתית *","עלות חודשית",null,null,null,null,null,null,null,null,null,null,null,null,"ספרים",null,null,0,null,null,"",null,null,null,null,null,null,0,null,null,0,0,null,{"$error":"#N/A"},"","","","","",""]
[null,null,null,"חופשה / טיול",null,null,0,null,"חובות בהסדר",{"$f":"AV47","v":20000},{"$f":"AV48","v":2000},null,null,null,null,null,{"$f":"P30/12","v":0},null,{"$f":"R30/12","v":0},null,{"$f":"T30/12","v":0},null,{"$f":"V30/12","v":0},null,{"$f":"X30/12","v":0},null,{"$f":"Z30/12","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"מחשב - תיקונים, נייר, דיו, דיסקים",null,null,0,null,null,"",null,null,null,null,null,null,0,null,null,0,0,null,{"$error":"#N/A"},"","","","","",""]
[null,null,6,"יהדות / חגים",null,{"$f":"IF(AG27<>\"\",AG27,\"\")","v":0},0,null,"סה\"כ חובות",{"$f":"SUM(J29:J30)","v":50000},null,null,null,null,null,null,0,null,0,null,0,null,0,null,0,null,0,null,null,null,null,null,null,null,null,null,null,null,null,"צילום- פיתוח, בטריות, קלטות",null,null,0,null,null,"",null,null,null,null,null,null,0,null,null,0,0,null,{"$error":"#N/A"},"","","","","",""]
[null,null,6,"מתנות לאירועים ושמחות",null,{"$f":"IF(AL25<>\"\",AL25,\"\")","v":0},0,null,null,null,null,null,null,null,null,null,0,null,0,null,0,null,0,null,0,null,0,null,null,null,null,null,null,null,null,null,null,null,null,"ייעוץ מס, הנה\"ח, עו\"ד",null,null,0,null,null,"",null,null,null,null,null,null,0,null,null,0,0,null,{"$error":"#N/A"},"","","","","",""]
[null,null,6,"רכישות ושרותים",null,{"$f":"IF(AQ36<>\"\",AQ36,\"\")","v":0},0,null,"סיכום חודשי",null,null,null,null,null,null,null,0,null,0,null,0,null,0,null,0,null,0,null,null,null,null,null,null,null,null,null,null,null,null,"טיפול בגינה, גנן",null,null,0,null,null,"",null,null,null,null,null,null,0,null,null,0,0,null,{"$error":"#N/A"},"","","","","",""]
[null,null,null,"תספורת וקוסמטיקה",null,null,0,null,"הכנסות","הוצאות","הפרש","הפרש כולל החזרי חובות",null,null,null,null,0,null,0,null,0,null,0,null,0,null,0,null,null,null,null,null,null,null,null,null,null,null,null,"אגרת רשות השידור",null,null,{"$f":"AP34/12","v":0},null,null,"",null,null,null,null,null,null,0,null,null,0,0,null,{"$error":"#N/A"},"","","","","",""]
[null,null,null,"ביטוח לאומי (מי שלא עובד)",null,null,0,null,null,null,null,null,null,null,null,null,0,null,0,null,0,null,0,null,0,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"",null,null,null,null,null,null,0,null,null,0,0,null,{"$error":"#N/A"},"","","","","",""]
[null,null,null,null,null,null,{"$f":"F36","v":0},null,{"$f":"K16","v":0},{"$f":"J25","v":0},{"$f":"I36-J36","v":0},{"$f":"K36-K30","v":-2000},null,null,"סה\"כ",{"$f":"SUM(P30:P35)","v":0},{"$f":"SUM(Q30:Q35)","v":0},0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,"סה\"כ לחודש",null,null,{"$f":"SUM(AQ17:AQ35)","v":0},null,null,"",null,null,null,null,null,null,0,null,null,0,0,null,{"$error":"#N/A"},"","","","","",""]
[null,null,null,null,null,null,0,null,"הפרש שנתי בין הוצאות להכנסות כולל החזר חובות",null,null,null,null,null,"סה\"כ הוצאות חינוך לחודש",null,{"$f":"Q36+S36+U36+W36+Y36+AA36","v":0},null," *עלות שנתית = תשלום בחודש בפועל X מספר חודשי התשלום בשנה   ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,0,null,null,0,0,null,{"$error":"#N/A"},"","","","","",""]
[null,"שוטפות",6,"מזון",null,{"$f":"IF(AG51<>\"\",AG51,\"\")","v":0},0,null,{"$f":"L36*12","v":-24000},null,null,null,null,null,null,null,null,null,"עלות חודשית = תשלום ממוצע לכל חודש בשנה = תשלום שנתי / 12",null,null,null,null,null,null,null,null,null,null,{"$f":"D38","v":"מזון"},null,null,null,null,{"$f":"D40","v":"דלק וחניה"},null,null,null,null,{"$f":"D46","v":"דברים נוספים"},null,null,null,null,null,"",null,null,null,null,null,null,0,null,null,0,0,null,{"$error":"#N/A"},"","","","","",""]
[null,null,null,"תחבורה ציבורית",null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"עלות חודשית",null,null,null,null,"עלות חודשית",null,null,null,null,"עלות חודשית",null,null,"",null,null,null,null,null,null,0,null,null,0,0,null,{"$error":"#N/A"},"","","","","",""]
[null,null,6,"דלק וחניה",null,{"$f":"IF(AL45<>\"\",AL45,\"\")","v":0},0,null,"חסכונות",null,null,null,null,null,{"$f":"D22","v":"חוגים, קייטנות ובריכה"},null,null,null,null,{"$f":"D23","v":"ביטוחי רכב + טסט"},null,null,null,null,null,null,null,null,null,"מכולת",null,null,null,null,"דלק",null,null,null,null,"בילויים ומופעים",null,null,null,null,null,{"$f":"IF(AU40=\"\",\"\",AT39+1)","v":""},null,null,null,null,null,null,{"$f":"IF(AY40=\"\",AV40,AY40*AZ40)","v":0},null,null,{"$f":"SUM(BD5:BD39)","v":20000},{"$f":"SUM(BE5:BE39)","v":30000},null,{"$error":"#N/A"},"","","","","",""]
[null,null,null,"טלפון נייח ",null,null,0,null,"חסכונות","הפרשה חודשית","סכום מצטבר","זמן פירעון",null,null,null,null,"עלות שנתית","עלות חודשית",null,null,null,"עלות שנתית","עלות חודשית",null,null,null,null,null,null,"רשת מזון / צרכניה",null,null,null,null,"תשלומי חניה",null,null,null,null,"דמי כיס",null,null,null,null,null,"סה\"כ",null,{"$f":"SUM(AV5:AV39)","v":230000},null,null,null,{"$f":"SUM(AZ5:AZ39)","v":2000},{"$f":"SUM(BA5:BA39)","v":50000}]
[null,null,null,"טלפון נייד ","מס' מכשירים __",null,0,null,null,null,null,null,null,null,"חוגי ילדים",null,null,{"$f":"Q42/12","v":0},null,"חידוש רשיון רכב + טסט",null,null,{"$f":"V42/12","v":0},null,null,null,null,null,null,"חנות בשר",null,null,null,null,"דוחות תנועה וחניה",null,null,null,null,"מסעדה ואוכל בחוץ"]
[null,null,null,"אחזקת בית",null,null,0,null,"פק\"ם / מק\"ם",null,null,null,null,null,"חוגי הורים",null,null,{"$f":"Q43/12","v":0},null,"ביטוח חובה",null,null,{"$f":"V43/12","v":0},null,null,null,null,null,null,"ירקן",null,null,null,null,"מינוי לאיתורן / ברק",null,null,null,null,"חיות מחמד",null,null,null,null,null,null,"לא לשכוח: חובות בנקים, אוברדראפט, הלוואות, כרטיסי אשראי, הלוואות דרך המשכורת,  מכולת, "]
[null,null,null,"עוזרת / שמרטף",null,null,0,null,"דרך הביטוח",null,null,null,null,null,"קייטנות",null,null,0,null,"ביטוח צד ג' / מקיף ",null,null,{"$f":"V44/12","v":0},null,null,null,null,null,null,"מזון טבעי ואורגני",null,null,null,null,"כבישי אגרה",null,null,null,null,"תחביבים",null,null,null,null,null,null,"גמ\"חים, רופא שיניים, הלוואות מהעבודה, חברים, אנשים פרטיים, שוק אפור, "]
[null,null,null,"סיגריות",null,null,0,null,"קרנות השתלמות",null,null,null,null,null,"תנועות נוער",null,null,0,null,"סה\"כ לחודש",null,null,{"$f":"SUM(W42:W44)","v":0},null,null,null,null,null,null,"מים מינראליים",null,null,null,null,"סה\"כ לחודש",null,null,{"$f":"SUM(AL40:AL44)","v":0},null,"השכרת סרטים",null,null,null,null,null,null,"שיקים בחוץ,  ","פיגורים בתשלום: מס הכנסה, משכנתא, שכ\"ד, ארנונה, חשמל, טלפון, פלאפון, שכר לימוד, ביטוח לאומי, הוצאה לפועל, מע\"מ."]
[null,null,6,"דברים נוספים",null,{"$f":"IF(AQ50<>\"\",AQ50,\"\")","v":0},0,null,"חסכונות סגורים",null,null,null,null,null,"הרצאות",null,null,0,null,null,null,null,null,null,null,null,null,null,null,"מזון בעבודה",null,null,null,null,null,null,null,null,null,"תרומות בדלת"]
[null,null,null,null,null,null,{"$f":"F47","v":0},null,"חסכונות ילדים",null,null,null,null,null,"השתלמויות ולימודים",null,null,0,null,null,null,null,null,null,null,null,null,null,null,"קייטרינג / אוכל מוכן",null,null,null,null,null,null,null,null,null,"תיקון אופניים",null,null,null,null,null,"סה\"כ חובות מוסדרים: ",null,{"$f":"BD40","v":20000}]
[null,null,null,null,null,null,{"$f":"F48","v":0},null,"קופות גמל",null,null,null,null,null,"בריכה",null,null,0,null,null,null,null,null,null,null,null,null,null,null,"חיתולים ותחליף חלב-אם",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"בהחזר חודשי: ",null,{"$f":"AZ41","v":2000}]
[null,null,null,null,null,null,0,null,"הוצאות עתידיות",null,null,null,null,null,"אחר",null,null,0]
[null,null,"סה\"כ",null,null,{"$f":"SUM(F5:F49)","v":0},{"$f":"SUM(G5:G49)","v":0},null,"סה\"כ",{"$f":"SUM(J43:J49)","v":0},{"$f":"SUM(K43:K49)","v":0},null,null,null,"סה\"כ לחודש",null,null,{"$f":"SUM(R42:R49)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"סה\"כ לחודש",null,null,{"$f":"SUM(AQ40:AQ49)","v":0},null,null,"סה\"כ חובות לא מוסדרים: ",null,{"$f":"BE40","v":30000}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"סה\"כ לחודש",null,null,{"$f":"SUM(AG40:AG50)","v":0}]
[null,null,null,"להפוך טור תקציב לתקציב חודש א'?",null,null,"לא"]
[null,null,null,"( כולל תקציב לחובות שבהסדר)"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"לא",null,null,null,null,null,null,null,null,"זכאות"]
[null,null,null,null,null,null,"כן",null,null,null,null,null,null,null,null,"משלימה"]