{"text_format":"1","workbook":"xlsx","n_sheets":17,"sheets":["macro","הזנת נתונים","חישוב פטור בגיל פרישה","נתונים ותקרות","חוב וותק פיצויים","תקופות עבודה רצפים","חישוב פיצויים שנמשכו ב-32 ש\"ע","היוון קיצבה","מענקי פיצויים","חישובי קיצבה ","כדאיות כלכלית קיצבה מול פיצויים","פירוט הכדאיות","מדד המחירים לצרכן ומדד הביטוח","מס על הקיצבה","מס על הקיצבה 2","מס על הקיצבה+פיצויים","מס על הקיצבה+פיצויים+היוון"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":8,"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":"macro","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"הזנת נתונים","index":1,"n_rows":25,"n_cols":9,"rows_kept":25,"cut":false,"hidden":true,"merged":[[12,0,13,1],[2,5,5,6],[24,5,25,5],[24,6,25,6]]}
[]
["נא להזין תאריכים",null,null,null,null,"נא להזין סכומים להיוון"]
["תאריך תחילת עבודה","1985-01-01",null,null,null,"יש להזין חיסכון למטרת קצבה שהלקוח מעוניין להוון בפרישה, במידה וישנם בתוכנית תגמולים ופיצויים חובה לפחות יחס של 1.2 תגמולים ל-1 פיצויים."]
["תאריך סיום עבודה","2020-12-31"]
[]
[]
["נתוני הכנסות ותשלומי מס בשנת הפרישה",null,null,null,null,"סכומי חיסכון למטרת קצבה שהלקוח מעוניין להוון",45678]
["הכנסות מעבודה בשנת הפרישה",254000]
["מס ששולם בשנת הפרישה",60000]
["נקודות זיכוי",2.25]
[]
["נא להזין סכומי פיצויים פטורים שנפדו או קיבלו אישור פטור",null,null,null,null,"נא להזין סכומי פיצויים לפדיון בלבד"]
["יש להזין סכומי פיצויים שנפדו בפטור לאורך שנות העבודה. להזין סכום שנמשך בפועל, ובתאריך חודש ושנת הפדיון בלבד! פיצויים שנפדו בפטור גבר לפני גיל 52, אישה לפני גיל 47 ולפני 2012 אין להזין מכיוון שאינם מקזזים מהטבות המס",null,null,null,null,"מענק השלמת פיצויים",100]
[null,null,null,null,null,"מענק ימי מחלה",750000]
["סכום הפיצויים","תאריך משיכה - חודש ושנה בלבד",null,null,null,"מענק הסתגלות",0]
[10000,"1972-12-01",null,null,null,"מענק דמי שתיקה",176000]
[20000,"2010-11-01",null,null,null,"מענק אי תחרות",500]
[15789,"2020-12-01",null,null,null,"פיצויים למשיכה מתוכניות פנסיוניות",600,null," "]
[null,null,null,null,null,"סה\"כ פיצויים לפדיון במזומן",{"$f":"SUM(G13:G18)","v":927200}]
[]
[]
[null,null,null,null,null,"נא להזין סכומי קצבה"]
[null,null,null,null,null,"סך הקצבה המזכה החודשית הצפויה",10000]
[null,null,null,null,null,"סך הקצבה המוכרת החודשית הצפויה",2156]
[null,null,null,null,null,"מזכה - חייבת במס, מוכרת -פטורה ממס"]

{"sheet":"חישוב פטור בגיל פרישה","index":2,"n_rows":41,"n_cols":17,"rows_kept":41,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[null,null,null,null,null,null,null,null,"תאריך",{"$f":"NOW()","v":"2021-04-05T15:26:12.610"},null,"התפתחות הפטור","מקסימום","מינימום",null,null,1]
["תקופת עבודה לחישוב פטור",{"$f":"'תקופות עבודה רצפים'!E23","v":36.021917808219179},{"$f":"IF(B5>32,\"הגדלת פטור\",\"מצב קיים\")","v":"הגדלת פטור"},"חודש הפרישה",{"$f":"IF(DAY(J18)>10,MONTH(J18)+1,MONTH(J18))","v":13},null,null,null,"תקרה מזכה",{"$f":"'נתונים ותקרות'!B4","v":8460},null,2017,0.49,0.14000000000000001,null,null,2]
["פטור לכל שנת עבודה בהתאם לפקודת מס הכנסה",{"$f":"J8","v":12340},null,null,null,null,null,null,"פטור מינמילי",{"$f":"J5*J10","v":1438.2},null,2020,0.52,0.17,null,null,3]
["סה\"כ פיצויים פטורים בהתאם לפקודה",{"$f":"B5*B6","v":444510.46575342468},null,null,null,null,null,null,"אפס",0,null,2025,0.67,0.32,null,null,4]
[null,null,null,null,null,null,null,null,"פטור פיצויים לכל שנת עבודה",{"$f":"'נתונים ותקרות'!B5","v":12340},null,null,null,null,null,null,5]
["התחשבנות פיצויים",null,null,null,null,null,null,null,"אחוז פטור",{"$f":"IF(YEAR(J18)<L6,M5,IF(YEAR(J18)<L7,M6,M7))","v":0.52},null,null,null,null,null,null,6]
["משיכת פיצויים בעבר",{"$f":"'חישוב פיצויים שנמשכו ב-32 ש\"ע'!G20","v":37156.758554630505},null,"פריסת מס בגין פיצויים",null,null,null,null,"אחוז פטור מינימלי",{"$f":"IF(YEAR(J18)<L6,N5,IF(YEAR(J18)<L7,N6,N7))","v":0.17},null,null,null,null,null,null,7]
["מענקי פיצויים מעסיק נוכחי",{"$f":"'מענקי פיצויים'!C32","v":927200},null,"סכום לפריסה -פיצויים חייבים",{"$f":"B19","v":482689.53424657532},null,null,null,null,null,null,null,null,null,null,null,8]
["סה\"כ פיצויים להתחשבנות",{"$f":"SUM(B10:B11)","v":964356.75855463045},null,"שנות פריסה",{"$f":"J14","v":6},null,null,null,{"$f":"A5","v":"תקופת עבודה לחישוב פטור"},{"$f":"B5","v":36.021917808219179},null,null,null,null,null,null,9]
["סה\"כ פיצויים להפחתה מהפטור",{"$f":"IF(B12>B7,B7+B10,B12)","v":481667.22430805519},null,{"$f":"IF(MONTH(J18)>=10,YEAR(J18)+1,YEAR(J18))","v":2021},{"$f":"IF(E12>=1,E11/E12,0)","v":80448.255707762553},null,null,null,"עיגול תקופה",{"$f":"MROUND(J12,4)","v":36},null,null,null,null,null,null,10]
[null,null,null,{"$f":"D13+1","v":2022},{"$f":"IF(E12>=2,E11/E12,0)","v":80448.255707762553},null,null,null,"שנות פריסה",{"$f":"IF(J13>24,6,J13/4)","v":6},null,null,null,null,null,null,11]
["סה\"כ ההון הפטור בהתאם לפקודה",{"$f":"J5*J9*180","v":791856},null,{"$f":"D14+1","v":2023},{"$f":"IF(E12>=3,E11/E12,0)","v":80448.255707762553},null,null,null,null,null,null,null,null,null,null,null,12]
["שווי משיכות פיצויים להפחתה מהפטור",{"$f":"IF(C5=\"מצב קיים\",(B13)*1.35,(B13)*1.35*32/B5)","v":577648.98029277567},null,2024,{"$f":"IF(E12>=4,E11/E12,0)","v":80448.255707762553}]
["יתרת ההון הפטור לאחר הפחתת פיצויים",{"$f":"IF((B15-B16)>J6*180,B15-B16,J6*180)","v":258876},null,2025,{"$f":"IF(E12>=5,E11/E12,0)","v":80448.255707762553},null,null,null,"הכנסות  בשנת הפרישה"]
[null,null,null,2026,{"$f":"IF(E12=6,E11/E12,0)","v":80448.255707762553},null,null,null,"תאריך הפרישה",{"$f":"'חישוב פיצויים שנמשכו ב-32 ש\"ע'!D2","v":"2020-12-31"}]
["פיצויים חייבים במס",{"$f":"IF(B11>B7,B11-B7,0)","v":482689.53424657532},null,null,null,null,null,null,"הכנסות מעבודה",{"$f":"'הזנת נתונים'!B8","v":254000}]
[null,null,null,null,null,null,null,null,"מס ששולם",{"$f":"'הזנת נתונים'!B9","v":60000}]
["היוון קיצבה",null,null,null,null,null,null,null,"נקודות זיכוי ללקוח",{"$f":"'הזנת נתונים'!B10","v":2.25}]
["סה\"כ קיצבה להיוון",{"$f":"'היוון קיצבה'!E20","v":45678}]
["סה\"כ הייון פטור",{"$f":"IF(B22>B17,B17,B22)","v":45678}]
["סה\"כ היוון חייב",{"$f":"B22-B23","v":0},null,"פריסת מס בגין היוו קיצבה"]
["יתרת ההון הפטור לאחר הפחתת פיצויים והיוון קיצבה",{"$f":"IF((B17-B22)<0,0,B17-B22)","v":213198},null,"סכום לפריסה - היוון קיצבה",{"$f":"IF((B17-B22)<0,(B17-B22)*-1,0)","v":0}]
[null,null,null,"שנות פריסה",{"$f":"IF(E25=0,0,6)","v":0}]
["המרת הפטור על הקיצבה",{"$f":"IF((IF((B17/180)>J6,B17/180,J6)-B22/180)>0,(B17-B22)/180,0)","v":1184.4333333333334},null,{"$f":"IF(MONTH(J18)>=10,YEAR(J18)+1,YEAR(J18))","v":2021},{"$f":"($E$25/6)","v":0}]
[null,"בשנים לאחר שנת הפרישה","בשנת הפרישה",{"$f":"D27+1","v":2022},{"$f":"($E$25/6)","v":0}]
["סה\"כ קיצבה מזכה",{"$f":"'חישובי קיצבה '!H16","v":10000},{"$f":"B29","v":10000},{"$f":"D28+1","v":2023},0]
["מס על הקיצבה",{"$f":"'מס על הקיצבה'!E25","v":492.07933333333324},{"$f":"IF(C29=0,0,IF(('מס על הקיצבה 2'!E25*12-'חישוב פטור בגיל פרישה'!J20)/12>0,('מס על הקיצבה 2'!E25*12-'חישוב פטור בגיל פרישה'!J20)/(13-E5),0))","v":0},2024,0]
["קיצבה נטו",{"$f":"B29-B30","v":9507.9206666666669},{"$f":"C29-C30","v":10000},2025,0]
["סה\"כ קיצבה מוכרת",{"$f":"'חישובי קיצבה '!H33","v":2156},{"$f":"'חישובי קיצבה '!H33","v":2156},2026,0]
["קיצבה כוללת נטו",{"$f":"B31+B32","v":11663.920666666667},{"$f":"C31+C32","v":12156}]
[]
["סה\"כ מענק פיצויים",{"$f":"B12-B10","v":927200}]
["מס על מענק הפיצויים",{"$f":"IF(B11<=B7,0,('מס על הקיצבה'!E9-'מס על הקיצבה'!E8)*12*(('חישוב פטור בגיל פרישה'!E12-1))+('מס על הקיצבה 2'!E9-'מס על הקיצבה 2'!E8)*12)","v":120514.46584474883}]
["מענק פיצויים נטו",{"$f":"B35-B36","v":806685.53415525123}]
[]
["סה\"כ מענק בגין היוון",{"$f":"B22","v":45678}]
["מס על ההיוון",{"$f":"IF(B27>0,0,('מס על הקיצבה'!E10-'מס על הקיצבה'!E9)*12*(E26-1))+('מס על הקיצבה 2'!E10-'מס על הקיצבה 2'!E9)*12","v":0}]
["מענק בגין היוון נטו",{"$f":"B39-B40","v":45678}]

{"sheet":"נתונים ותקרות","index":3,"n_rows":24,"n_cols":2,"rows_kept":24,"cut":false,"hidden":true,"merged":[]}
[]
[]
["מדד התחשבנות",12389]
["תקרה מזכה",8460]
["פטור פיצויים לכל שנת עבודה",12340]
["שווי נקודת זיכוי",218]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["שיעור מס","הכנסה חודשית"]
[0.1,0]
[0.14000000000000001,6290]
[0.2,9030]
[0.31,14490]
[0.35,20140]
[0.47,41910]
[0.5,53970]
[null,1000000]

{"sheet":"חוב וותק פיצויים","index":4,"n_rows":30,"n_cols":4,"rows_kept":30,"cut":false,"hidden":true,"merged":[[25,0,26,0]]}
[]
[]
["מעסיק אחרון"]
["חישוב חוב וותק פיצויים"]
[]
[null,null,"תאריך סיום עבודה","תאריך תחילת עבודה"]
["תקופת עבודה",{"$f":"(C7-D7)/365","v":36.021917808219179},{"$f":"'הזנת נתונים'!B4","v":"2020-12-31"},{"$f":"'הזנת נתונים'!B3","v":"1985-01-01"}]
["שכר אחרון"]
["חוב וותק",{"$f":"B7*B8","v":0}]
[]
[]
[]
["פיצויים קיימים בתוכניות","חברה מנהלת","מספר פוליסה / קופה","סכום"]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
["סה\"כ",null,null,{"$f":"SUM(D14:D23)","v":0}]
[]
["חישוב יתרה להשלמה בהינתן ואין סעיף 14"]
[]
["חוב וותק",{"$f":"B9","v":0}]
["קיים בתוכניות",{"$f":"D24","v":0}]
["יתרה להשלמה",{"$f":"B28-B29","v":0}]

{"sheet":"תקופות עבודה רצפים","index":5,"n_rows":23,"n_cols":13,"rows_kept":23,"cut":false,"hidden":true,"merged":[[22,0,22,3]]}
[]
[]
[]
["מס\"ד","מעסיק","תחילת עבודה","סיום עבודה","סה\"כ תקופת עבודה","רצף פיצויים","רצף","תקופת עבודה לחישוב הפטור"]
[1,"א",{"$f":"'חוב וותק פיצויים'!D7","v":"1985-01-01"},{"$f":"'חוב וותק פיצויים'!C7","v":"2020-12-31"},{"$f":"(D5-C5)/365","v":36.021917808219179},"מעסיק אחרון",{"$f":"AND(OR(F5=\"כן\",F5=0,F5=\"מעסיק אחרון\"),OR(F6=\"כן\",F6=0,F6=\"מעסיק אחרון\"),OR(F7=\"כן\",F7=0,F7=\"מעסיק אחרון\"),OR(F8=\"כן\",F8=0,F8=\"מעסיק אחרון\"),OR(F9=\"כן\",F9=0,F9=\"מעסיק אחרון\"),OR(F10=\"כן\",F10=0,F10=\"מעסיק אחרון\"),OR(F11=\"כן\",F11=0,F11=\"מעסיק אחרון\"),OR(F12=\"כן\",F12=0,F12=\"מעסיק אחרון\"),OR(F13=\"כן\",F13=0,F13=\"מעסיק אחרון\"),OR(F14=\"כן\",F14=0,F14=\"מעסיק אחרון\"),OR(F15=\"כן\",F15=0,F15=\"מעסיק אחרון\"),OR(F16=\"כן\",F16=0,F16=\"מעסיק אחרון\"),OR(F17=\"כן\",F17=0,F17=\"מעסיק אחרון\"),OR(F18=\"כן\",F18=0,F18=\"מעסיק אחרון\"),OR(F19=\"כן\",F19=0,F19=\"מעסיק אחרון\"))","v":true},{"$f":"IF(G5=TRUE,TRUE,FALSE)","v":true}]
[2,"ב",null,null,{"$f":"(D6-C6)/365","v":0},0,{"$f":"AND(OR(F6=\"כן\",F6=0,F6=\"מעסיק אחרון\"),OR(F7=\"כן\",F7=0,F7=\"מעסיק אחרון\"),OR(F8=\"כן\",F8=0,F8=\"מעסיק אחרון\"),OR(F9=\"כן\",F9=0,F9=\"מעסיק אחרון\"),OR(F10=\"כן\",F10=0,F10=\"מעסיק אחרון\"),OR(F11=\"כן\",F11=0,F11=\"מעסיק אחרון\"),OR(F12=\"כן\",F12=0,F12=\"מעסיק אחרון\"),OR(F13=\"כן\",F13=0,F13=\"מעסיק אחרון\"),OR(F14=\"כן\",F14=0,F14=\"מעסיק אחרון\"),OR(F15=\"כן\",F15=0,F15=\"מעסיק אחרון\"),OR(F16=\"כן\",F16=0,F16=\"מעסיק אחרון\"),OR(F17=\"כן\",F17=0,F17=\"מעסיק אחרון\"),OR(F18=\"כן\",F18=0,F18=\"מעסיק אחרון\"),OR(F19=\"כן\",F19=0,F19=\"מעסיק אחרון\"),OR(F20=\"כן\",F20=0,F20=\"מעסיק אחרון\"))","v":true},{"$f":"IF(G6=TRUE,TRUE,FALSE)","v":true},null,null,null,null,"כן"]
[3,"ג",null,null,{"$f":"(D7-C7)/365","v":0},0,true,true,null,null,null,null,"לא"]
[4,"ד",null,null,0,0,true,true,null,null,null,null,"מעסיק אחרון"]
[5,"ה",null,null,0,0,true,true,null,null,null,null,0]
[6,"ו",null,null,null,0,true,true]
[7,"ז",null,null,null,0,true,true]
[8,"ח",null,null,null,0,true,true]
[9,"ט",null,null,null,0,true,true]
[10,"י",null,null,null,0,true,true]
[11,"יא",null,null,null,0,true,true]
[12,"יב",null,null,null,0,true,true]
[13,"יג",null,null,null,0,true,true]
[14,"יד",null,null,null,0,true,true]
[15,"טו",null,null,null,0,true,true]
[]
[]
[]
["סה\" תקופת עבודה לחישוב פטור",null,null,null,{"$f":"SUMIF(H5:H19,\"true\",$E$5:$E$19)","v":36.021917808219179}]

{"sheet":"חישוב פיצויים שנמשכו ב-32 ש\"ע","index":6,"n_rows":20,"n_cols":11,"rows_kept":20,"cut":false,"hidden":true,"merged":[[19,3,19,5]]}
[]
[null,null,"תאריך הפרישה",{"$f":"'חוב וותק פיצויים'!C7","v":"2020-12-31"},null,"מדד התחשבנות",{"$f":"'נתונים ותקרות'!B3","v":12389}]
[]
["מס\"ד","מעסיק","סכום הפיצויים","תאריך משיכה - חודש ושנה בלבד","מדד משיכה","מדד התחשבנות","שווי נכון ליום ההתחשבנות",null,null,"מבצע בדיקת 32 שנות עבודה"]
[1,{"$f":"'תקופות עבודה רצפים'!B5","v":"א"},{"$f":"'הזנת נתונים'!A16","v":10000},{"$f":"'הזנת נתונים'!B16","v":"1972-12-01"},{"$f":"IF(C5>0,VLOOKUP(D5,'מדד המחירים לצרכן ומדד הביטוח'!D5:E1000,2,FALSE),0)","v":230.61},{"$f":"$G$2","v":12389},{"$f":"IF((YEAR($D$2)-YEAR(D5))<=32,C5*$G$2/E5,0)","v":0}]
[2,{"$f":"'תקופות עבודה רצפים'!B6","v":"ב"},{"$f":"'הזנת נתונים'!A17","v":20000},{"$f":"'הזנת נתונים'!B17","v":"2010-11-01"},{"$f":"IF(C6>0,VLOOKUP(D6,'מדד המחירים לצרכן ומדד הביטוח'!D6:E1001,2,FALSE),0)","v":11621},{"$f":"$G$2","v":12389},{"$f":"IF((YEAR($D$2)-YEAR(D6))<=32,C6*$G$2/E6,0)","v":21321.745116599261}]
[3,{"$f":"'תקופות עבודה רצפים'!B7","v":"ג"},{"$f":"'הזנת נתונים'!A18","v":15789},{"$f":"'הזנת נתונים'!B18","v":"2020-12-01"},{"$f":"IF(C7>0,VLOOKUP(D7,'מדד המחירים לצרכן ומדד הביטוח'!D7:E1002,2,FALSE),0)","v":12353},12389,15835.013438031248]
[4,{"$f":"'תקופות עבודה רצפים'!B8","v":"ד"},{"$f":"'הזנת נתונים'!A19","v":0},{"$f":"'הזנת נתונים'!B19","v":"00:00:00"},{"$f":"IF(C8>0,VLOOKUP(D8,'מדד המחירים לצרכן ומדד הביטוח'!D8:E1003,2,FALSE),0)","v":0},12389,0]
[5,{"$f":"'תקופות עבודה רצפים'!B9","v":"ה"},{"$f":"'הזנת נתונים'!A20","v":0},{"$f":"'הזנת נתונים'!B20","v":"00:00:00"},{"$f":"IF(C9>0,VLOOKUP(D9,'מדד המחירים לצרכן ומדד הביטוח'!D9:E1004,2,FALSE),0)","v":0},12389,0]
[6,{"$f":"'תקופות עבודה רצפים'!B10","v":"ו"},{"$f":"'הזנת נתונים'!A21","v":0},{"$f":"'הזנת נתונים'!B21","v":"00:00:00"},{"$f":"IF(C10>0,VLOOKUP(D10,'מדד המחירים לצרכן ומדד הביטוח'!D10:E1005,2,FALSE),0)","v":0},12389,0]
[7,{"$f":"'תקופות עבודה רצפים'!B11","v":"ז"},{"$f":"'הזנת נתונים'!A22","v":0},{"$f":"'הזנת נתונים'!B22","v":"00:00:00"},{"$f":"IF(C11>0,VLOOKUP(D11,'מדד המחירים לצרכן ומדד הביטוח'!D11:E1006,2,FALSE),0)","v":0},12389,0]
[8,{"$f":"'תקופות עבודה רצפים'!B12","v":"ח"},{"$f":"'הזנת נתונים'!A23","v":0},{"$f":"'הזנת נתונים'!B23","v":"00:00:00"},{"$f":"IF(C12>0,VLOOKUP(D12,'מדד המחירים לצרכן ומדד הביטוח'!D12:E1007,2,FALSE),0)","v":0},12389,0,null,null,null,"חהעלים את הNULL"]
[9,{"$f":"'תקופות עבודה רצפים'!B13","v":"ט"},{"$f":"'הזנת נתונים'!A24","v":0},{"$f":"'הזנת נתונים'!B24","v":"00:00:00"},{"$f":"IF(C13>0,VLOOKUP(D13,'מדד המחירים לצרכן ומדד הביטוח'!D13:E1008,2,FALSE),0)","v":0},12389,0]
[10,{"$f":"'תקופות עבודה רצפים'!B14","v":"י"},{"$f":"'הזנת נתונים'!A25","v":0},{"$f":"'הזנת נתונים'!B25","v":"00:00:00"},{"$f":"IF(C14>0,VLOOKUP(D14,'מדד המחירים לצרכן ומדד הביטוח'!D14:E1009,2,FALSE),0)","v":0},12389,0]
[11,{"$f":"'תקופות עבודה רצפים'!B15","v":"יא"},null,null,{"$f":"IF(C15>0,VLOOKUP(D15,'מדד המחירים לצרכן ומדד הביטוח'!D15:E1010,2,FALSE),0)","v":0},12389,0]
[12,{"$f":"'תקופות עבודה רצפים'!B16","v":"יב"},null,null,{"$f":"IF(C16>0,VLOOKUP(D16,'מדד המחירים לצרכן ומדד הביטוח'!D16:E1011,2,FALSE),0)","v":0},12389,0]
[13,{"$f":"'תקופות עבודה רצפים'!B17","v":"יג"},null,null,{"$f":"IF(C17>0,VLOOKUP(D17,'מדד המחירים לצרכן ומדד הביטוח'!D17:E1012,2,FALSE),0)","v":0},12389,0]
[14,{"$f":"'תקופות עבודה רצפים'!B18","v":"יד"},null,null,{"$f":"IF(C18>0,VLOOKUP(D18,'מדד המחירים לצרכן ומדד הביטוח'!D18:E1013,2,FALSE),0)","v":0},12389,0]
[15,{"$f":"'תקופות עבודה רצפים'!B19","v":"טו"},null,null,{"$f":"IF(C19>0,VLOOKUP(D19,'מדד המחירים לצרכן ומדד הביטוח'!D19:E1014,2,FALSE),0)","v":0},12389,0]
[null,null,null,"פיצויים להתחשבנות",null,null,{"$f":"SUM(G5:G19)","v":37156.758554630505}]

{"sheet":"היוון קיצבה","index":7,"n_rows":20,"n_cols":8,"rows_kept":20,"cut":false,"hidden":true,"merged":[]}
[]
["היוון קיצבאות"]
[]
["מס\"ד","מספר עמית","חברה מנהלת","סוג קופה","סכום להיוון"]
[1,null,null,"קופת גמל",{"$f":"'הזנת נתונים'!G7","v":45678},null,null,"סוגי קופות"]
[2,null,null,null,null,null,null,"קופת גמל"]
[3,null,null,null,null,null,null,"ביטוח מנהלים"]
[4,null,null,null,null,null,null,"קרן פנסיה"]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[null,null,null,null,{"$f":"SUM(E5:E19)","v":45678}]

{"sheet":"מענקי פיצויים","index":8,"n_rows":33,"n_cols":13,"rows_kept":33,"cut":false,"hidden":true,"merged":[[31,0,31,1]]}
[]
[null,"תאריך הפרישה",{"$f":"'חישוב פיצויים שנמשכו ב-32 ש\"ע'!D2","v":"2020-12-31"}]
[]
["מס\"ד","שם המשלם","מספר תיק ניכויים","קוד סוג המשלם","קוד סוג התשלום","סכום המענק","האם נמשך במזומן","מספר פוליסה","רצף קיצבה","רצף פיצויים",null,{"$f":"D4","v":"קוד סוג המשלם"}]
[1,"מגדל ביטוח",9356000359,4,20,null,"כן",null,"לא","לא",null,"המעביד",1]
[2,"מנורה מבטחים פנסיה",9359689784,6,20,null,"לא",null,"כן","לא",null,"מינהל הגמלאות (פנסיה תקציבית של עובדי מדינה)",2]
[3,null,null,null,null,null,null,null,null,null,null,"קופה מרכזית לפיצויים, כולל ביטוח לאומי במקרה של פשיטת רגל",3]
[4,null,null,null,null,null,null,null,null,null,null,"קופה אישית לפיצויים כולל קופת ביטוח (הון)",4]
[5,null,null,null,null,null,null,null,null,null,null,"קופת פנסיה וותיקה",5]
[6,null,null,null,null,null,null,null,null,null,null,"קופת פנסיה חדשה כולל קופת ביטוח לקיצבה",6]
[7,null,null,null,null,null,null,null,null,null,null,"קופה לקיצבת יסוד / קופה לתגמולים של עמית שכיר",7]
[8]
[9]
[10,null,null,null,null,null,null,null,null,null,null,{"$f":"E4","v":"קוד סוג התשלום"}]
[null,null,null,null,null,{"$f":"SUMIFS(F5:F14,G5:G14,\"כן\")","v":0},null,null,null,null,null,"מענק רגיל",20]
[null,null,null,null,null,null,null,null,null,null,null,"מענק שנים עודפות",21]
[null,null,null,null,null,null,null,null,null,null,null,"מענק כוחות הביטחון",22]
[null,null,null,null,null,null,null,null,null,null,null,"מענק שארים",23]
[null,null,null,null,null,null,null,null,null,null,null,"קיצבה",30]
[null,null,null,null,null,null,null,null,null,null,null,"פנסיה תקציבית שתשולם בעתיד",31]
[null,null,null,null,null,null,null,null,null,null,null,"קיצבת שארים",32]
[null,null,null,null,null,null,null,null,null,null,null,"קיצבת יסוד / תגמולים של עמית שכיר",34]
[null,"חישוב פיצויים למשיכה במזומן"]
[]
[1,"מענק השלמת פיצויים",{"$f":"'הזנת נתונים'!G13","v":100},null,null,null,null,null,null,null,null,"מזומן"]
[2,"מענק ימי מחלה",{"$f":"'הזנת נתונים'!G14","v":750000},null,null,null,null,null,null,null,null,"כן"]
[3,null,null,null,null,null,null,null,null,null,null,"לא"]
[4,"מענק הסתגלות",{"$f":"'הזנת נתונים'!G15","v":0}]
[5,"מענק דמי שתיקה",{"$f":"'הזנת נתונים'!G16","v":176000}]
[6,"מענק אי תחרות",{"$f":"'הזנת נתונים'!G17","v":500}]
[7,"פיצויים למשיכה מתוכניות פנסיוניות",{"$f":"'הזנת נתונים'!G18","v":600}]
["סה\"כ מענקי פיצויים להתחשבנות",null,{"$f":"SUM(C25:C31)","v":927200}]
[null,"סה\"כ פיצויים",{"$f":"SUM(C25:C31)","v":927200}]

{"sheet":"חישובי קיצבה ","index":9,"n_rows":33,"n_cols":8,"rows_kept":33,"cut":false,"hidden":true,"merged":[[15,0,15,6],[32,0,32,6],[17,4,17,6]]}
[]
[]
[null,"מקורות קיצבה מזכה"]
[]
["מס\"ד","מספר פוליסה","חברת ביטוח","צבירת תגמולים לקיצבה","צבירת פיצויים לקיצבה","סה\"כ","מקדם","סה\"כ קיצבה"]
[1,123456,"מגדל",2000000,null,1500000,200]
[2,789005,"כלל",null,null,{"$f":"E7+D7","v":0},137.69999999999999]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
["סה\"כ קיצבה",null,null,null,null,null,null,{"$f":"'הזנת נתונים'!G23","v":10000}]
[]
[]
[]
[null,"מקורות קיצבה מוכרת"]
[]
["מס\"ד","מספר פוליסה","חברת ביטוח","צבירת תגמולים לקיצבה","צבירת פיצויים לקיצבה","סה\"כ","מקדם","סה\"כ קיצבה"]
[1,232323,"מגדל",null,null,{"$f":"E23+D23","v":0},157.63,{"$f":"F23/G23","v":0}]
[2,565656,"כלל",null,null,{"$f":"E24+D24","v":0},137.69999999999999,{"$f":"F24/G24","v":0}]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
["סה\"כ קיצבה",null,null,null,null,null,null,{"$f":"'הזנת נתונים'!G24","v":2156}]

{"sheet":"כדאיות כלכלית קיצבה מול פיצויים","index":10,"n_rows":49,"n_cols":17,"rows_kept":49,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[null,null,null,null,null,null,null,null,"תאריך",{"$f":"NOW()","v":"2021-04-05T15:26:12.610"},null,"התפתחות הפטור","מקסימום","מינימום",null,null,1]
["תקופת עבודה לחישוב פטור",{"$f":"'תקופות עבודה רצפים'!E23","v":36.021917808219179},{"$f":"IF(B5>32,\"הגדלת פטור\",\"מצב קיים\")","v":"הגדלת פטור"},"חודש הפרישה",{"$f":"IF(DAY(J18)>10,MONTH(J18)+1,MONTH(J18))","v":13},null,null,null,"תקרה מזכה",{"$f":"'נתונים ותקרות'!B4","v":8460},null,2017,0.49,0.14000000000000001,null,null,2]
["פטור לכל שנת עבודה בהתאם לפקודת מס הכנסה",{"$f":"J8","v":12340},null,null,null,null,null,null,"פטור מינמילי",{"$f":"J5*J10","v":1438.2},null,2020,0.52,0.17,null,null,3]
["סה\"כ פיצויים פטורים בהתאם לפקודה",{"$f":"B5*B6","v":444510.46575342468},null,null,null,null,null,null,"אפס",0,null,2025,0.67,0.32,null,null,4]
[null,null,null,null,null,null,null,null,"פטור פיצויים לכל שנת עבודה",{"$f":"'נתונים ותקרות'!B5","v":12340},null,null,null,null,null,null,5]
["התחשבנות פיצויים",null,null,null,null,null,null,null,"אחוז פטור",{"$f":"IF(YEAR(J18)<L6,M5,IF(YEAR(J18)<L7,M6,M7))","v":0.52},null,null,null,null,null,null,6]
["משיכת פיצויים בעבר",{"$f":"'חישוב פיצויים שנמשכו ב-32 ש\"ע'!G20","v":37156.758554630505},null,"פריסת מס בגין פיצויים",null,null,null,null,"אחוז פטור מינימלי",{"$f":"IF(YEAR(J18)<L6,N5,IF(YEAR(J18)<L7,N6,N7))","v":0.17},null,null,null,null,null,null,7]
["מענקי פיצויים מעסיק נוכחי",{"$f":"'מענקי פיצויים'!C33","v":927200},null,"סכום לפריסה -פיצויים חייבים",{"$f":"B22","v":482689.53424657532},null,null,null,null,null,null,null,null,null,null,null,8]
[null,null,null,"שנות פריסה",{"$f":"J14","v":6},null,null,null,{"$f":"A5","v":"תקופת עבודה לחישוב פטור"},{"$f":"B5","v":36.021917808219179},null,null,null,null,null,null,9]
[null,null,null,{"$f":"IF(MONTH(J18)>=10,YEAR(J18)+1,YEAR(J18))","v":2021},{"$f":"IF(E12>=1,E11/E12,0)","v":80448.255707762553},null,null,null,"עיגול תקופה",{"$f":"MROUND(J12,4)","v":36},null,null,null,null,null,null,10]
[null,null,null,{"$f":"D13+1","v":2022},{"$f":"IF(E12>=2,E11/E12,0)","v":80448.255707762553},null,null,null,"שנות פריסה",{"$f":"IF(J13>24,6,J13/4)","v":6},null,null,null,null,null,null,11]
["סה\"כ פיצויים להתחשבנות",{"$f":"SUM(B10:B14)","v":964356.75855463045},null,{"$f":"D14+1","v":2023},{"$f":"IF(E12>=3,E11/E12,0)","v":80448.255707762553},null,null,null,null,null,null,null,null,null,null,null,12]
["סה\"כ פיצויים להפחתה מהפטור",{"$f":"IF(B15>B7,B7+B10,B15)","v":481667.22430805519},null,2024,{"$f":"IF(E12>=4,E11/E12,0)","v":80448.255707762553}]
[null,null,null,2025,{"$f":"IF(E12>=5,E11/E12,0)","v":80448.255707762553},null,null,null,"הכנסות  בשנת הפרישה"]
["סה\"כ ההון הפטור בהתאם לפקודה",{"$f":"J5*J9*180","v":791856},null,2026,{"$f":"IF(E12=6,E11/E12,0)","v":80448.255707762553},null,null,null,"תאריך הפרישה",{"$f":"'חישוב פיצויים שנמשכו ב-32 ש\"ע'!D2","v":"2020-12-31"}]
["שווי משיכות פיצויים להפחתה מהפטור",{"$f":"IF(C5=\"מצב קיים\",(B16)*1.35,(B16)*1.35*32/B5)","v":577648.98029277567},null,null,null,null,null,null,"הכנסות מעבודה",250000]
["יתרת ההון הפטור לאחר הפחתת פיצויים",{"$f":"IF((B18-B19)>J6*180,B18-B19,J6*180)","v":258876},null,null,null,null,null,null,"מס ששולם",60000]
[null,null,null,null,null,null,null,null,"נקודות זיכוי ללקוח",2.25]
["פיצויים חייבים במס",{"$f":"IF(B11>B7,B11-B7,0)","v":482689.53424657532},null,null,null,null,null,null,{"$f":"'חישוב פטור בגיל פרישה'!I22","v":0},{"$f":"'חישוב פטור בגיל פרישה'!J22","v":"00:00:00"}]
[]
["היוון קיצבה",null,null,"פריסת מס בגין היוו קיצבה"]
["סה\"כ קיצבה להיוון",{"$f":"'היוון קיצבה'!E20","v":45678},null,"סכום לפריסה - היוון קיצבה",{"$f":"IF((B20-B25)<0,(B20-B25)*-1,0)","v":0}]
["סה\"כ הייון פטור",{"$f":"IF(B25>B20,B20,B25)","v":45678},null,"שנות פריסה",{"$f":"IF(E25=0,0,6)","v":0}]
["סה\"כ היוון חייב",{"$f":"B25-B26","v":0},null,{"$f":"IF(MONTH(J18)>=10,YEAR(J18)+1,YEAR(J18))","v":2021},{"$f":"($E$25/6)","v":0}]
["יתרת ההון הפטור לאחר הפחתת פיצויים והיוון קיצבה",{"$f":"IF((B20-B25)<0,0,B20-B25)","v":213198},null,{"$f":"D27+1","v":2022},{"$f":"($E$25/6)","v":0}]
[null,null,null,{"$f":"D28+1","v":2023},0]
["המרת הפטור על הקיצבה",{"$f":"IF((IF((B20/180)>J6,B20/180,J6)-B25/180)>0,(B20-B25)/180,0)","v":1184.4333333333334},null,2024,0]
[null,null,null,2025,0]
["פירוט מקורות קיצבה מזכה",null,null,2026,0]
[]
[]
[]
[null,"בשנים שלאחר שנת הפרישה","בשנת הפרישה"]
["סה\"כ קיצבה מזכה",{"$f":"'חישובי קיצבה '!H18","v":0},{"$f":"B37","v":0}]
["מס על הקיצבה",1427.4,5216.0666666666657]
["קיצבה נטו",{"$f":"B37-B38","v":-1427.4},{"$f":"C37-C38","v":-5216.0666666666657}]
["סה\"כ קיצבה מוכרת",{"$f":"'חישובי קיצבה '!H33","v":2156},{"$f":"'חישובי קיצבה '!H33","v":2156}]
["קיצבה כוללת נטו",{"$f":"B39+B40","v":728.59999999999991},{"$f":"C39+C40","v":-3060.0666666666657}]
[]
["סה\"כ מענק פיצויים",{"$f":"B15-B10","v":927200}]
["מס על מענק הפיצויים",943306.36566210049]
["מענק פיצויים נטו",{"$f":"B43-B44","v":-16106.365662100492}]
[]
["סה\"כ מענק בגין היוון",{"$f":"B25","v":45678}]
["מס על ההיוון",15633.140000000029]
["מענק בגין היוון נטו",{"$f":"B47-B48","v":30044.859999999971}]

{"sheet":"פירוט הכדאיות","index":11,"n_rows":35,"n_cols":6,"rows_kept":35,"cut":false,"hidden":true,"merged":[]}
[]
[]
["שנה","גיל","סה\"כ הכנסות נטו בהמרת פיצווים לקיצבה","סה\"כ הכנסות נטו במשיכת פיצויים כמענק","הפרש","יתרון"]
[{"$f":"'חישוב פטור בגיל פרישה'!D13","v":2021},{"$f":"A4-YEAR('חישוב פטור בגיל פרישה'!$J$22)","v":121},{"$f":"(12-'חישוב פטור בגיל פרישה'!$E$5)*'חישוב פטור בגיל פרישה'!$C$31+'חישוב פטור בגיל פרישה'!$B$37","v":796685.53415525123},{"$f":"(12-'כדאיות כלכלית קיצבה מול פיצויים'!$E$5)*'כדאיות כלכלית קיצבה מול פיצויים'!$C$39+'כדאיות כלכלית קיצבה מול פיצויים'!$B$45","v":-10890.298995433826},{"$f":"C4-D4","v":807575.83315068507},{"$f":"IF(E4<0,\"יתרון למשיכת פיצויים כמענק\",\"יתרון למשיכת פיצויים כקיצבה\")","v":"יתרון למשיכת פיצויים כקיצבה"}]
[{"$f":"A4+1","v":2022},{"$f":"A5-YEAR('חישוב פטור בגיל פרישה'!$J$22)","v":122},{"$f":"C4+'חישוב פטור בגיל פרישה'!$B$31*12","v":910780.58215525118},{"$f":"12*'כדאיות כלכלית קיצבה מול פיצויים'!$B$39+D4","v":-28019.098995433829},{"$f":"C5-D5","v":938799.68115068506},{"$f":"IF(E5<0,\"יתרון למשיכת פיצויים כמענק\",\"יתרון למשיכת פיצויים כקיצבה\")","v":"יתרון למשיכת פיצויים כקיצבה"}]
[{"$f":"A5+1","v":2023},{"$f":"A6-YEAR('חישוב פטור בגיל פרישה'!$J$22)","v":123},{"$f":"C5+'חישוב פטור בגיל פרישה'!$B$31*12","v":1024875.6301552511},{"$f":"12*'כדאיות כלכלית קיצבה מול פיצויים'!$B$39+D5","v":-45147.898995433832},1070023.5291506851,"יתרון למשיכת פיצויים כקיצבה"]
[2024,{"$f":"A7-YEAR('חישוב פטור בגיל פרישה'!$J$22)","v":124},{"$f":"C6+'חישוב פטור בגיל פרישה'!$B$31*12","v":1138970.6781552511},{"$f":"12*'כדאיות כלכלית קיצבה מול פיצויים'!$B$39+D6","v":-62276.698995433835},1201247.3771506848,"יתרון למשיכת פיצויים כקיצבה"]
[2025,{"$f":"A8-YEAR('חישוב פטור בגיל פרישה'!$J$22)","v":125},{"$f":"C7+'חישוב פטור בגיל פרישה'!$B$31*12","v":1253065.726155251},{"$f":"12*'כדאיות כלכלית קיצבה מול פיצויים'!$B$39+D7","v":-79405.498995433838},1332471.2251506848,"יתרון למשיכת פיצויים כקיצבה"]
[2026,{"$f":"A9-YEAR('חישוב פטור בגיל פרישה'!$J$22)","v":126},{"$f":"C8+'חישוב פטור בגיל פרישה'!$B$31*12","v":1367160.774155251},{"$f":"12*'כדאיות כלכלית קיצבה מול פיצויים'!$B$39+D8","v":-96534.298995433841},1463695.0731506848,"יתרון למשיכת פיצויים כקיצבה"]
[2027,{"$f":"A10-YEAR('חישוב פטור בגיל פרישה'!$J$22)","v":127},{"$f":"C9+'חישוב פטור בגיל פרישה'!$B$31*12","v":1481255.8221552509},{"$f":"12*'כדאיות כלכלית קיצבה מול פיצויים'!$B$39+D9","v":-113663.09899543384},1594918.9211506848,"יתרון למשיכת פיצויים כקיצבה"]
[2028,{"$f":"A11-YEAR('חישוב פטור בגיל פרישה'!$J$22)","v":128},{"$f":"C10+'חישוב פטור בגיל פרישה'!$B$31*12","v":1595350.8701552509},{"$f":"12*'כדאיות כלכלית קיצבה מול פיצויים'!$B$39+D10","v":-130791.89899543385},1726142.7691506848,"יתרון למשיכת פיצויים כקיצבה"]
[2029,{"$f":"A12-YEAR('חישוב פטור בגיל פרישה'!$J$22)","v":129},{"$f":"C11+'חישוב פטור בגיל פרישה'!$B$31*12","v":1709445.9181552508},{"$f":"12*'כדאיות כלכלית קיצבה מול פיצויים'!$B$39+D11","v":-147920.69899543386},1857366.6171506848,"יתרון למשיכת פיצויים כקיצבה"]
[2030,{"$f":"A13-YEAR('חישוב פטור בגיל פרישה'!$J$22)","v":130},{"$f":"C12+'חישוב פטור בגיל פרישה'!$B$31*12","v":1823540.9661552508},{"$f":"12*'כדאיות כלכלית קיצבה מול פיצויים'!$B$39+D12","v":-165049.49899543385},1988590.4651506846,"יתרון למשיכת פיצויים כקיצבה"]
[2031,{"$f":"A14-YEAR('חישוב פטור בגיל פרישה'!$J$22)","v":131},{"$f":"C13+'חישוב פטור בגיל פרישה'!$B$31*12","v":1937636.0141552507},{"$f":"12*'כדאיות כלכלית קיצבה מול פיצויים'!$B$39+D13","v":-182178.29899543384},2119814.3131506843,"יתרון למשיכת פיצויים כקיצבה"]
[2032,{"$f":"A15-YEAR('חישוב פטור בגיל פרישה'!$J$22)","v":132},{"$f":"C14+'חישוב פטור בגיל פרישה'!$B$31*12","v":2051731.0621552507},{"$f":"12*'כדאיות כלכלית קיצבה מול פיצויים'!$B$39+D14","v":-199307.09899543383},2251038.1611506846,"יתרון למשיכת פיצויים כקיצבה"]
[2033,{"$f":"A16-YEAR('חישוב פטור בגיל פרישה'!$J$22)","v":133},{"$f":"C15+'חישוב פטור בגיל פרישה'!$B$31*12","v":2165826.1101552509},{"$f":"12*'כדאיות כלכלית קיצבה מול פיצויים'!$B$39+D15","v":-216435.89899543382},2382262.0091506848,"יתרון למשיכת פיצויים כקיצבה"]
[2034,{"$f":"A17-YEAR('חישוב פטור בגיל פרישה'!$J$22)","v":134},{"$f":"C16+'חישוב פטור בגיל פרישה'!$B$31*12","v":2279921.1581552508},{"$f":"12*'כדאיות כלכלית קיצבה מול פיצויים'!$B$39+D16","v":-233564.69899543381},2513485.8571506846,"יתרון למשיכת פיצויים כקיצבה"]
[2035,{"$f":"A18-YEAR('חישוב פטור בגיל פרישה'!$J$22)","v":135},{"$f":"C17+'חישוב פטור בגיל פרישה'!$B$31*12","v":2394016.2061552508},{"$f":"12*'כדאיות כלכלית קיצבה מול פיצויים'!$B$39+D17","v":-250693.49899543379},2644709.7051506843,"יתרון למשיכת פיצויים כקיצבה"]
[2036,{"$f":"A19-YEAR('חישוב פטור בגיל פרישה'!$J$22)","v":136},{"$f":"C18+'חישוב פטור בגיל פרישה'!$B$31*12","v":2508111.2541552507},{"$f":"12*'כדאיות כלכלית קיצבה מול פיצויים'!$B$39+D18","v":-267822.29899543378},2775933.5531506846,"יתרון למשיכת פיצויים כקיצבה"]
[2037,{"$f":"A20-YEAR('חישוב פטור בגיל פרישה'!$J$22)","v":137},{"$f":"C19+'חישוב פטור בגיל פרישה'!$B$31*12","v":2622206.3021552507},{"$f":"12*'כדאיות כלכלית קיצבה מול פיצויים'!$B$39+D19","v":-284951.09899543377},2907157.4011506843,"יתרון למשיכת פיצויים כקיצבה"]
[2038,{"$f":"A21-YEAR('חישוב פטור בגיל פרישה'!$J$22)","v":138},{"$f":"C20+'חישוב פטור בגיל פרישה'!$B$31*12","v":2736301.3501552506},{"$f":"12*'כדאיות כלכלית קיצבה מול פיצויים'!$B$39+D20","v":-302079.89899543376},3038381.2491506846,"יתרון למשיכת פיצויים כקיצבה"]
[2039,{"$f":"A22-YEAR('חישוב פטור בגיל פרישה'!$J$22)","v":139},{"$f":"C21+'חישוב פטור בגיל פרישה'!$B$31*12","v":2850396.3981552506},{"$f":"12*'כדאיות כלכלית קיצבה מול פיצויים'!$B$39+D21","v":-319208.69899543375},3169605.0971506843,"יתרון למשיכת פיצויים כקיצבה"]
[2040,{"$f":"A23-YEAR('חישוב פטור בגיל פרישה'!$J$22)","v":140},{"$f":"C22+'חישוב פטור בגיל פרישה'!$B$31*12","v":2964491.4461552505},{"$f":"12*'כדאיות כלכלית קיצבה מול פיצויים'!$B$39+D22","v":-336337.49899543374},3300828.9451506841,"יתרון למשיכת פיצויים כקיצבה"]
[2041,{"$f":"A24-YEAR('חישוב פטור בגיל פרישה'!$J$22)","v":141},{"$f":"C23+'חישוב פטור בגיל פרישה'!$B$31*12","v":3078586.4941552505},{"$f":"12*'כדאיות כלכלית קיצבה מול פיצויים'!$B$39+D23","v":-353466.29899543372},3432052.7931506843,"יתרון למשיכת פיצויים כקיצבה"]
[2042,{"$f":"A25-YEAR('חישוב פטור בגיל פרישה'!$J$22)","v":142},{"$f":"C24+'חישוב פטור בגיל פרישה'!$B$31*12","v":3192681.5421552504},{"$f":"12*'כדאיות כלכלית קיצבה מול פיצויים'!$B$39+D24","v":-370595.09899543371},3563276.6411506841,"יתרון למשיכת פיצויים כקיצבה"]
[2043,{"$f":"A26-YEAR('חישוב פטור בגיל פרישה'!$J$22)","v":143},{"$f":"C25+'חישוב פטור בגיל פרישה'!$B$31*12","v":3306776.5901552504},{"$f":"12*'כדאיות כלכלית קיצבה מול פיצויים'!$B$39+D25","v":-387723.8989954337},3694500.4891506843,"יתרון למשיכת פיצויים כקיצבה"]
[2044,{"$f":"A27-YEAR('חישוב פטור בגיל פרישה'!$J$22)","v":144},{"$f":"C26+'חישוב פטור בגיל פרישה'!$B$31*12","v":3420871.6381552503},{"$f":"12*'כדאיות כלכלית קיצבה מול פיצויים'!$B$39+D26","v":-404852.69899543369},3825724.3371506841,"יתרון למשיכת פיצויים כקיצבה"]
[2045,{"$f":"A28-YEAR('חישוב פטור בגיל פרישה'!$J$22)","v":145},{"$f":"C27+'חישוב פטור בגיל פרישה'!$B$31*12","v":3534966.6861552503},{"$f":"12*'כדאיות כלכלית קיצבה מול פיצויים'!$B$39+D27","v":-421981.49899543368},3956948.1851506839,"יתרון למשיכת פיצויים כקיצבה"]
[2046,{"$f":"A29-YEAR('חישוב פטור בגיל פרישה'!$J$22)","v":146},{"$f":"C28+'חישוב פטור בגיל פרישה'!$B$31*12","v":3649061.7341552502},{"$f":"12*'כדאיות כלכלית קיצבה מול פיצויים'!$B$39+D28","v":-439110.29899543367},4088172.0331506841,"יתרון למשיכת פיצויים כקיצבה"]
[2047,{"$f":"A30-YEAR('חישוב פטור בגיל פרישה'!$J$22)","v":147},{"$f":"C29+'חישוב פטור בגיל פרישה'!$B$31*12","v":3763156.7821552502},{"$f":"12*'כדאיות כלכלית קיצבה מול פיצויים'!$B$39+D29","v":-456239.09899543365},4219395.8811506834,"יתרון למשיכת פיצויים כקיצבה"]
[2048,{"$f":"A31-YEAR('חישוב פטור בגיל פרישה'!$J$22)","v":148},{"$f":"C30+'חישוב פטור בגיל פרישה'!$B$31*12","v":3877251.8301552502},{"$f":"12*'כדאיות כלכלית קיצבה מול פיצויים'!$B$39+D30","v":-473367.89899543364},4350619.7291506836,"יתרון למשיכת פיצויים כקיצבה"]
[2049,{"$f":"A32-YEAR('חישוב פטור בגיל פרישה'!$J$22)","v":149},{"$f":"C31+'חישוב פטור בגיל פרישה'!$B$31*12","v":3991346.8781552501},{"$f":"12*'כדאיות כלכלית קיצבה מול פיצויים'!$B$39+D31","v":-490496.69899543363},4481843.5771506839,"יתרון למשיכת פיצויים כקיצבה"]
[2050,{"$f":"A33-YEAR('חישוב פטור בגיל פרישה'!$J$22)","v":150},{"$f":"C32+'חישוב פטור בגיל פרישה'!$B$31*12","v":4105441.9261552501},{"$f":"12*'כדאיות כלכלית קיצבה מול פיצויים'!$B$39+D32","v":-507625.49899543362},4613067.4251506841,"יתרון למשיכת פיצויים כקיצבה"]
[2051,{"$f":"A34-YEAR('חישוב פטור בגיל פרישה'!$J$22)","v":151},{"$f":"C33+'חישוב פטור בגיל פרישה'!$B$31*12","v":4219536.97415525},{"$f":"12*'כדאיות כלכלית קיצבה מול פיצויים'!$B$39+D33","v":-524754.29899543361},4744291.2731506834,"יתרון למשיכת פיצויים כקיצבה"]
[2052,{"$f":"A35-YEAR('חישוב פטור בגיל פרישה'!$J$22)","v":152},{"$f":"C34+'חישוב פטור בגיל פרישה'!$B$31*12","v":4333632.0221552504},{"$f":"12*'כדאיות כלכלית קיצבה מול פיצויים'!$B$39+D34","v":-541883.09899543365},4875515.1211506836,"יתרון למשיכת פיצויים כקיצבה"]

{"sheet":"מדד המחירים לצרכן ומדד הביטוח","index":12,"n_rows":837,"n_cols":6,"rows_kept":837,"cut":false,"hidden":true,"merged":[[0,0,0,5],[1,0,1,2],[1,3,1,5],[2,0,2,2],[2,3,2,5]]}
["מדד המחירים לצרכן ומדד ביטוח חיים"]
["מדד המחירים לצרכן",null,null,"מדד ביטוח חיים"]
["על בסיס ספטמבר 1951 = 100 נקודות",null,null,"המדד האחרון הידוע ב-1 לכל חודש. המדד הבסיסי מותאם למדד חודש ינואר 1959 (100 נקודות). המדד מתרגם את חילופי המטבעות (מל\"י לשקל ולש\"ח)"]
["מדד בגין חודש","המדד בנקודות","פורסם בתאריך","חודש","המדד בנקודות","מדד בסיס 1959 ללא עיגול וללא המרת מטבע"]
["1951-09-01",100,"1951-10-15","1951-11-01"]
["1951-10-01",103,"1951-11-15","1951-12-01"]
["1951-11-01",105,"1951-12-16","1952-01-01"]
["1951-12-01",107,"1952-01-15","1952-02-01"]
["1952-01-01",113,"1952-02-15","1952-03-01"]
["1952-02-01",120,"1952-03-16","1952-04-01"]
["1952-03-01",132,"1952-04-15","1952-05-01"]
["1952-04-01",144,"1952-05-15","1952-06-01"]
["1952-05-01",150,"1952-06-15","1952-07-01"]
["1952-06-01",157,"1952-07-15","1952-08-01"]
["1952-07-01",162,"1952-08-15","1952-09-01"]
["1952-08-01",165,"1952-09-15","1952-10-01"]
["1952-09-01",169,"1952-10-15","1952-11-01"]
["1952-10-01",173,"1952-11-16","1952-12-01"]
["1952-11-01",175,"1952-12-15","1953-01-01"]
["1952-12-01",178,"1953-01-15","1953-02-01"]
["1953-01-01",181,"1953-02-15","1953-03-01"]
["1953-02-01",182,"1953-03-15","1953-04-01"]
["1953-03-01",184,"1953-04-15","1953-05-01"]
["1953-04-01",187,"1953-05-15","1953-06-01"]
["1953-05-01",191,"1953-06-15","1953-07-01"]
["1953-06-01",197,"1953-07-15","1953-08-01"]
["1953-07-01",200,"1953-08-16","1953-09-01"]
["1953-08-01",201,"1953-09-15","1953-10-01"]
["1953-09-01",205,"1953-10-15","1953-11-01"]
["1953-10-01",207,"1953-11-15","1953-12-01"]
["1953-11-01",208,"1953-12-15","1954-01-01"]
["1953-12-01",212,"1954-01-15","1954-02-01"]
["1954-01-01",214,"1954-02-15","1954-03-01"]
["1954-02-01",216,"1954-03-15","1954-04-01"]
["1954-03-01",217,"1954-04-15","1954-05-01"]
["1954-04-01",217,"1954-05-16","1954-06-01"]
["1954-05-01",218,"1954-06-15","1954-07-01"]
["1954-06-01",214,"1954-07-15","1954-08-01"]
["1954-07-01",217,"1954-08-15","1954-09-01"]
["1954-08-01",222,"1954-09-15","1954-10-01"]
["1954-09-01",227,"1954-10-15","1954-11-01"]
["1954-10-01",227,"1954-11-15","1954-12-01"]
["1954-11-01",228,"1954-12-15","1955-01-01"]
["1954-12-01",228,"1955-01-16","1955-02-01"]
["1955-01-01",228,"1955-02-15","1955-03-01"]
["1955-02-01",228,"1955-03-15","1955-04-01"]
["1955-03-01",229,"1955-04-15","1955-05-01"]
["1955-04-01",230,"1955-05-15","1955-06-01"]
["1955-05-01",230,"1955-06-15","1955-07-01"]
["1955-06-01",232,"1955-07-15","1955-08-01"]
["1955-07-01",233,"1955-08-15","1955-09-01"]
["1955-08-01",231,"1955-09-15","1955-10-01"]
["1955-09-01",239,"1955-10-16","1955-11-01"]
["1955-10-01",238,"1955-11-15","1955-12-01"]
["1955-11-01",236,"1955-12-15","1956-01-01"]
["1955-12-01",239,"1956-01-15","1956-02-01"]
["1956-01-01",238,"1956-02-15","1956-03-01"]
["1956-02-01",239,"1956-03-15","1956-04-01"]
["1956-03-01",244,"1956-04-15","1956-05-01"]
["1956-04-01",246,"1956-05-15","1956-06-01"]
["1956-05-01",249,"1956-06-15","1956-07-01"]
["1956-06-01",249,"1956-07-15","1956-08-01"]
["1956-07-01",244,"1956-08-15","1956-09-01"]
["1956-08-01",247,"1956-09-16","1956-10-01"]
["1956-09-01",260,"1956-10-15","1956-11-01"]
["1956-10-01",259,"1956-11-15","1956-12-01"]
["1956-11-01",248,"1956-12-16","1957-01-01"]
["1956-12-01",250,"1957-01-15","1957-02-01"]
["1957-01-01",254,"1957-02-15","1957-03-01"]
["1957-02-01",259,"1957-03-15","1957-04-01"]
["1957-03-01",261,"1957-04-15","1957-05-01"]
["1957-04-01",265,"1957-05-15","1957-06-01"]
["1957-05-01",270,"1957-06-16","1957-07-01"]
["1957-06-01",258,"1957-07-15","1957-08-01"]
["1957-07-01",264,"1957-08-15","1957-09-01"]
["1957-08-01",269,"1957-09-15","1957-10-01"]
["1957-09-01",268,"1957-10-15","1957-11-01"]
["1957-10-01",268,"1957-11-15","1957-12-01"]
["1957-11-01",267,"1957-12-15","1958-01-01"]
["1957-12-01",263,"1958-01-15","1958-02-01"]
["1958-01-01",267,"1958-02-16","1958-03-01"]
["1958-02-01",269,"1958-03-16","1958-04-01"]
["1958-03-01",268,"1958-04-15","1958-05-01"]
["1958-04-01",272,"1958-05-15","1958-06-01"]
["1958-05-01",276,"1958-06-15","1958-07-01"]
["1958-06-01",267,"1958-07-15","1958-08-01"]
["1958-07-01",274,"1958-08-15","1958-09-01"]
["1958-08-01",274,"1958-09-15","1958-10-01"]
["1958-09-01",280,"1958-10-15","1958-11-01"]
["1958-10-01",280,"1958-11-16","1958-12-01"]
["1958-11-01",273,"1958-12-15","1959-01-01"]
["1958-12-01",274,"1959-01-15","1959-02-01"]
["1959-01-01",275.3,"1959-02-15","1959-03-01",{"$f":"ROUND(F93,2)","v":100},{"$f":"B93/2.753","v":100}]
["1959-02-01",277.50240000000002,"1959-03-15","1959-04-01",100.8,{"$f":"B94/2.753","v":100.8}]
["1959-03-01",277.77769999999998,"1959-04-15","1959-05-01",100.9,100.89999999999999]
["1959-04-01",276.40120000000002,"1959-05-15","1959-06-01",100.4,100.4]
["1959-05-01",287.1379,"1959-06-15","1959-07-01",104.3,104.3]
["1959-06-01",273.37290000000002,"1959-07-15","1959-08-01",99.3,99.3]
["1959-07-01",269.79399999999998,"1959-08-16","1959-09-01",98,97.999999999999986]
["1959-08-01",269.51870000000002,"1959-09-15","1959-10-01",97.9,97.9]
["1959-09-01",275.57530000000003,"1959-10-15","1959-11-01",100.1,100.10000000000001]
["1959-10-01",280.53070000000002,"1959-11-15","1959-12-01",101.9,101.9]
["1959-11-01",281.0813,"1959-12-15","1960-01-01",102.1,102.1]
["1959-12-01",279.70479999999998,"1960-01-15","1960-02-01",101.6,101.6]
["1960-01-01",278.60359999999997,"1960-02-15","1960-03-01",101.2,101.19999999999999]
["1960-02-01",279.1542,"1960-03-15","1960-04-01",101.4,101.39999999999999]
["1960-03-01",281.90719999999999,"1960-04-15","1960-05-01",102.4,102.39999999999999]
["1960-04-01",278.60359999999997,"1960-05-15","1960-06-01",101.2,101.19999999999999]
["1960-05-01",284.1096,"1960-06-15","1960-07-01",103.2,103.2]
["1960-06-01",277.50240000000002,"1960-07-15","1960-08-01",100.8,100.8]
["1960-07-01",278.87889999999999,"1960-08-15","1960-09-01",101.3,101.3]
["1960-08-01",279.42950000000002,"1960-09-15","1960-10-01",101.5,101.5]
["1960-09-01",286.58730000000003,"1960-10-16","1960-11-01",104.1,104.10000000000001]
["1960-10-01",292.36860000000001,"1960-11-15","1960-12-01",106.2,106.2]
["1960-11-01",291.26740000000001,"1960-12-15","1961-01-01",105.8,105.8]
["1960-12-01",289.34030000000001,"1961-01-15","1961-02-01",105.1,105.1]
["1961-01-01",295.94749999999999,"1961-02-15","1961-03-01",107.5,107.49999999999999]
["1961-02-01",293.46980000000002,"1961-03-15","1961-04-01",106.6,106.60000000000001]
["1961-03-01",294.0204,"1961-04-16","1961-05-01",106.8,106.8]
["1961-04-01",293.74509999999998,"1961-05-15","1961-06-01",106.7,106.69999999999999]
["1961-05-01",314.66789999999997,"1961-06-15","1961-07-01",114.3,114.29999999999998]
["1961-06-01",303.93119999999999,"1961-07-16","1961-08-01",110.4,110.39999999999999]
["1961-07-01",297.32400000000001,"1961-08-15","1961-09-01",108,108]
["1961-08-01",294.84629999999999,"1961-09-15","1961-10-01",107.1,107.1]
["1961-09-01",304.75709999999998,"1961-10-15","1961-11-01",110.7,110.69999999999999]
["1961-10-01",308.88659999999999,"1961-11-15","1961-12-01",112.2,112.19999999999999]
["1961-11-01",311.36430000000001,"1961-12-15","1962-01-01",113.1,113.1]
["1961-12-01",315.49380000000002,"1962-01-15","1962-02-01",114.6,114.60000000000001]
["1962-01-01",316.59500000000003,"1962-02-15","1962-03-01",115,115]
["1962-02-01",318.24680000000001,"1962-03-15","1962-04-01",115.6,115.6]
["1962-03-01",325.40460000000002,"1962-04-15","1962-05-01",118.2,118.2]
["1962-04-01",331.1859,"1962-05-15","1962-06-01",120.3,120.3]
["1962-05-01",327.88229999999999,"1962-06-15","1962-07-01",119.1,119.1]
["1962-06-01",323.47750000000002,"1962-07-15","1962-08-01",117.5,117.5]
["1962-07-01",326.23050000000001,"1962-08-15","1962-09-01",118.5,118.5]
["1962-08-01",330.0847,"1962-09-16","1962-10-01",119.9,119.89999999999999]
["1962-09-01",337.79309999999998,"1962-10-15","1962-11-01",122.7,122.69999999999999]
["1962-10-01",341.37200000000001,"1962-11-15","1962-12-01",124,124]
["1962-11-01",343.84969999999998,"1962-12-16","1963-01-01",124.9,124.89999999999999]
["1962-12-01",347.70389999999998,"1963-01-15","1963-02-01",126.3,126.29999999999998]
["1963-01-01",347.70389999999998,"1963-02-15","1963-03-01",126.3,126.29999999999998]
["1963-02-01",347.70389999999998,"1963-03-15","1963-04-01",126.3,126.29999999999998]
["1963-03-01",347.70389999999998,"1963-04-15","1963-05-01",126.3,126.29999999999998]
["1963-04-01",343.84969999999998,"1963-05-15","1963-06-01",124.9,124.89999999999999]
["1963-05-01",355.137,"1963-06-16","1963-07-01",129,129]
["1963-06-01",352.1087,"1963-07-15","1963-08-01",127.9,127.89999999999999]
["1963-07-01",352.38400000000001,"1963-08-15","1963-09-01",128,128]
["1963-08-01",346.60270000000003,"1963-09-15","1963-10-01",125.9,125.9]
["1963-09-01",353.48520000000002,"1963-10-15","1963-11-01",128.4,128.4]
["1963-10-01",356.23820000000001,"1963-11-15","1963-12-01",129.4,129.4]
["1963-11-01",363.1207,"1963-12-15","1964-01-01",131.9,131.9]
["1963-12-01",365.0478,"1964-01-15","1964-02-01",132.6,132.6]
["1964-01-01",367.80079999999998,"1964-02-16","1964-03-01",133.6,133.6]
["1964-02-01",367.80079999999998,"1964-03-15","1964-04-01",133.6,133.6]
["1964-03-01",367.25020000000001,"1964-04-15","1964-05-01",133.4,133.4]
["1964-04-01",363.94659999999999,"1964-05-15","1964-06-01",132.19999999999999,132.19999999999999]
["1964-05-01",376.33510000000001,"1964-06-15","1964-07-01",{"$f":"ROUND(F157,2)","v":136.69999999999999},136.69999999999999]
["1964-06-01",365.87369999999999,"1964-07-15","1964-08-01",132.9,{"$f":"B158/2.753","v":132.89999999999998}]
["1964-07-01",370.82909999999998,"1964-08-16","1964-09-01",134.69999999999999,134.69999999999999]
["1964-08-01",367.25020000000001,"1964-09-15","1964-10-01",133.4,133.4]
["1964-09-01",370.00319999999999,"1964-10-15","1964-11-01",134.4,134.4]
["1964-10-01",374.1327,"1964-11-15","1964-12-01",135.9,135.9]
["1964-11-01",377.43630000000002,"1964-12-15","1965-01-01",137.1,137.1]
["1964-12-01",381.29050000000001,"1965-01-15","1965-02-01",138.5,138.5]
["1965-01-01",384.54977700000001,"1965-02-15","1965-03-01",139.68,139.68390010897204]
["1965-02-01",386.40392200000002,"1965-03-15","1965-04-01",140.36000000000001,140.35739992735199]
["1965-03-01",394.19133299999999,"1965-04-15","1965-05-01",143.19,143.18609989102796]
["1965-04-01",397.528795,"1965-05-16","1965-06-01",144.4,144.39839992735199]
["1965-05-01",405.68703499999998,"1965-06-15","1965-07-01",147.36000000000001,147.36179985470395]
["1965-06-01",403.83289000000002,"1965-07-15","1965-08-01",146.69,146.68830003632402]
["1965-07-01",400.86625700000002,"1965-08-15","1965-09-01",145.61000000000001,145.61069996367598]
["1965-08-01",396.41630800000001,"1965-09-15","1965-10-01",143.99,143.99430003632401]
["1965-09-01",401.60791499999999,"1965-10-15","1965-11-01",145.88,145.88009989102795]
["1965-10-01",405.68703499999998,"1965-11-15","1965-12-01",147.36000000000001,147.36179985470395]
["1965-11-01",407.91201000000001,"1965-12-15","1966-01-01",148.16999999999999,148.16999999999999]
["1965-12-01",408.28283900000002,"1966-01-16","1966-02-01",148.30000000000001,148.304699963676]
["1966-01-01",413.474447,"1966-02-15","1966-03-01",150.19,150.19050018162005]
["1966-02-01",417.924396,"1966-03-15","1966-04-01",151.81,151.80690010897203]
["1966-03-01",424.97014899999999,"1966-04-15","1966-05-01",154.37,154.36620014529603]
["1966-04-01",432.75756000000001,"1966-05-15","1966-06-01",157.19,157.19490010897204]
["1966-05-01",434.61170499999997,"1966-06-15","1966-07-01",157.87,157.86839992735196]
["1966-06-01",433.12838900000003,"1966-07-15","1966-08-01",157.33000000000001,157.32960007264802]
["1966-07-01",434.24087600000001,"1966-08-15","1966-09-01",157.72999999999999,157.733699963676]
["1966-08-01",429.420098,"1966-09-15","1966-10-01",155.97999999999999,155.98260007264801]
["1966-09-01",435.72419300000001,"1966-10-16","1966-11-01",158.27000000000001,158.27250018162005]
["1966-10-01",439.43248299999999,"1966-11-15","1966-12-01",159.62,159.61949981837995]
["1966-11-01",437.20750900000002,"1966-12-15","1967-01-01",158.81,158.81130003632401]
["1966-12-01",440.17414200000002,"1967-01-15","1967-02-01",159.88999999999999,159.88890010897202]
["1967-01-01",439.803313,"1967-02-15","1967-03-01",159.75,159.75420014529604]
["1967-02-01",435.72419300000001,"1967-03-15","1967-04-01",158.27000000000001,158.27250018162005]
["1967-03-01",437.57833799999997,"1967-04-16","1967-05-01",158.94999999999999,158.946]
["1967-04-01",444.25326200000001,"1967-05-15","1967-06-01",161.37,161.37060007264802]
["1967-05-01",445.36574899999999,"1967-06-15","1967-07-01",161.77000000000001,161.77469996367597]
["1967-06-01",440.54497099999998,"1967-07-16","1967-08-01",160.02000000000001,160.02360007264801]
["1967-07-01",437.20750900000002,"1967-08-15","1967-09-01",158.81,158.81130003632401]
["1967-08-01",433.12838900000003,"1967-09-15","1967-10-01",157.33000000000001,157.32960007264802]
["1967-09-01",432.75755600000002,"1967-10-15","1967-11-01",157.19,157.19489865601162]
["1967-10-01",436.09502199999997,"1967-11-15","1967-12-01",158.41,158.40720014529603]
["1967-11-01",437.94916699999999,"1967-12-15","1968-01-01",159.08000000000001,159.08069996367598]
["1967-12-01",440.91579999999999,"1968-01-15","1968-02-01",160.16,160.15830003632399]
["1968-01-01",444.99491999999998,"1968-02-15","1968-03-01",161.63999999999999,161.63999999999999]
["1968-02-01",444.62409100000002,"1968-03-15","1968-04-01",161.51,161.505300036324]
["1968-03-01",447.96155299999998,"1968-04-15","1968-05-01",162.72,162.717600072648]
["1968-04-01",452.04067300000003,"1968-05-15","1968-06-01",164.2,164.19930003632402]
["1968-05-01",451.299015,"1968-06-16","1968-07-01",163.93,163.92990010897202]
["1968-06-01",446.47823599999998,"1968-07-15","1968-08-01",162.18,162.17879985470395]
["1968-07-01",447.96155299999998,"1968-08-15","1968-09-01",162.72,162.717600072648]
["1968-08-01",443.88243299999999,"1968-09-15","1968-10-01",161.24,161.23590010897203]
["1968-09-01",445.73657800000001,"1968-10-15","1968-11-01",161.91,161.90939992735198]
["1968-10-01",448.70321100000001,"1968-11-15","1968-12-01",162.99,162.98699999999999]
["1968-11-01",447.59072400000002,"1968-12-15","1969-01-01",162.58000000000001,162.58290010897204]
["1968-12-01",449.44486899999998,"1969-01-15","1969-02-01",163.26,163.25639992735196]
["1969-01-01",451.66984400000001,"1969-02-16","1969-03-01",164.06,164.06460007264801]
["1969-02-01",450.55735700000002,"1969-03-16","1969-04-01",163.66,163.66050018162005]
["1969-03-01",456.86145099999999,"1969-04-15","1969-05-01",165.95,165.95039992735198]
["1969-04-01",459.82808399999999,"1969-05-15","1969-06-01",167.03,167.02799999999999]
["1969-05-01",457.23228,"1969-06-15","1969-07-01",166.09,166.08509989102797]
["1969-06-01",461.68222900000001,"1969-07-15","1969-08-01",167.7,167.70149981837994]
["1969-07-01",462.05305900000002,"1969-08-15","1969-09-01",167.84,167.83620014529603]
["1969-08-01",453.15316000000001,"1969-09-15","1969-10-01",164.6,164.60339992735197]
["1969-09-01",456.11979300000002,"1969-10-15","1969-11-01",{"$f":"ROUND(F221,2)","v":165.68},165.68100000000001]
["1969-10-01",461.68222900000001,"1969-11-16","1969-12-01",167.7,{"$f":"B222/2.753","v":167.70149981837994}]
["1969-11-01",465.01969100000002,"1969-12-15","1970-01-01",168.91,168.91379985470397]
["1969-12-01",466.87383699999998,"1970-01-15","1970-02-01",169.59,169.587300036324]
["1970-01-01",465.59633100000002,"1970-02-15","1970-03-01",169.12,169.12325862695241]
["1970-02-01",467.43119300000001,"1970-03-15","1970-04-01",169.79,169.78975408645115]
["1970-03-01",472.018349,"1970-04-15","1970-05-01",171.46,171.45599309843806]
["1970-04-01",475.68807399999997,"1970-05-15","1970-06-01",172.79,172.7889843806756]
["1970-05-01",481.65137700000002,"1970-06-15","1970-07-01",174.96,174.95509516890664]
["1970-06-01",480.73394500000001,"1970-07-15","1970-08-01",174.62,174.62184707591717]
["1970-07-01",478.89908300000002,"1970-08-16","1970-09-01",173.96,173.95535161641845]
["1970-08-01",481.19266099999999,"1970-09-15","1970-10-01",174.79,174.78847112241189]
["1970-09-01",500.45871599999998,"1970-10-15","1970-11-01",181.79,181.78667490010895]
["1970-10-01",510.55045899999999,"1970-11-15","1970-12-01",185.45,185.45240065383217]
["1970-11-01",510.55045899999999,"1970-12-15","1971-01-01",185.45,185.45240065383217]
["1970-12-01",514.22018400000002,"1971-01-15","1971-02-01",186.79,186.78539193606974]
["1971-01-01",523.394496,"1971-02-15","1971-03-01",190.12,190.11786996004358]
["1971-02-01",522.93578000000002,"1971-03-15","1971-04-01",189.95,189.95124591354886]
["1971-03-01",529.81651399999998,"1971-04-15","1971-05-01",192.45,192.45060443152923]
["1971-04-01",533.94495500000005,"1971-05-16","1971-06-01",193.95,193.95021976026155]
["1971-05-01",536.69724799999995,"1971-06-15","1971-07-01",194.95,194.9499629495096]
["1971-06-01",537.61467900000002,"1971-07-15","1971-08-01",195.28,195.28321067925899]
["1971-07-01",534.86238600000001,"1971-08-15","1971-09-01",194.28,194.28346749001091]
["1971-08-01",537.61467900000002,"1971-09-15","1971-10-01",195.28,195.28321067925899]
["1971-09-01",555.04587200000003,"1971-10-15","1971-11-01",201.61,201.61491899745732]
["1971-10-01",566.97247800000002,"1971-11-15","1971-12-01",205.95,205.94714057391937]
["1971-11-01",576.14678900000001,"1971-12-15","1972-01-01",209.28,209.2796182346531]
["1971-12-01",583.02752299999997,"1972-01-16","1972-02-01",211.78,211.77897675263347]
["1972-01-01",591.28440399999999,"1972-02-15","1972-03-01",214.78,214.77820704685797]
["1972-02-01",588.073395,"1972-03-15","1972-04-01",213.61,213.61183981111515]
["1972-03-01",600,"1972-04-16","1972-05-01",217.94,217.94406102433709]
["1972-04-01",606.88073399999996,"1972-05-15","1972-06-01",220.44,220.44341954231746]
["1972-05-01",613.30275300000005,"1972-06-15","1972-07-01",222.78,222.77615437704324]
["1972-06-01",604.58715600000005,"1972-07-16","1972-08-01",219.61,219.61030003632402]
["1972-07-01",608.715597,"1972-08-15","1972-09-01",221.11,221.10991536505628]
["1972-08-01",611.46789000000001,"1972-09-15","1972-10-01",222.11,222.10965855430439]
["1972-09-01",620.18348700000001,"1972-10-15","1972-11-01",225.28,225.27551289502361]
["1972-10-01",634.86238600000001,"1972-11-15","1972-12-01",230.61,230.60747766073374]
["1972-11-01",645.87156000000004,"1972-12-15","1973-01-01",234.61,234.60645114420632]
["1972-12-01",655.04587200000003,"1973-01-15","1973-02-01",237.94,237.93892916818018]
["1973-01-01",667.43119300000001,"1973-02-15","1973-03-01",242.44,242.43777442789684]
["1973-02-01",673.85321199999998,"1973-03-15","1973-04-01",244.77,244.77050926262257]
["1973-03-01",690.36697300000003,"1973-04-15","1973-05-01",250.77,250.76896948783147]
["1973-04-01",716.97247800000002,"1973-05-15","1973-06-01",260.43,260.43315583000361]
["1973-05-01",727.06422099999997,"1973-06-15","1973-07-01",264.10000000000002,264.09888158372684]
["1973-06-01",729.357799,"1973-07-15","1973-08-01",264.93,264.9320010897203]
["1973-07-01",741.74311999999998,"1973-08-15","1973-09-01",269.43,269.43084634943693]
["1973-08-01",746.33027600000003,"1973-09-16","1973-10-01",271.10000000000002,271.09708536142392]
["1973-09-01",758.715597,"1973-10-15","1973-11-01",275.60000000000002,275.59593062114055]
["1973-10-01",772.47706500000004,"1973-11-15","1973-12-01",280.58999999999997,280.59464765710135]
["1973-11-01",806.42201899999998,"1973-12-16","1974-01-01",292.92,292.92481620050853]
["1973-12-01",827.98165200000005,"1974-01-15","1974-02-01",300.76,300.75613948419908]
["1974-01-01",857.33945000000006,"1974-02-15","1974-03-01",311.42,311.42006901561933]
["1974-02-01",926.60550499999999,"1974-03-15","1974-04-01",336.58,336.5802778786778]
["1974-03-01",951.37614799999994,"1974-04-15","1974-05-01",345.58,345.5779687613512]
["1974-04-01",977.06422099999997,"1974-05-15","1974-06-01",354.91,354.90890701053394]
["1974-05-01",1003.21101,"1974-06-16","1974-07-01",364.41,364.40646930621136]
["1974-06-01",1006.422019,"1974-07-15","1974-08-01",365.57,365.57283654195419]
["1974-07-01",1020.183487,"1974-08-15","1974-09-01",370.57,370.57155357791498]
["1974-08-01",1025.2293589999999,"1974-09-15","1974-10-01",372.4,372.4044166363966]
["1974-09-01",1045.4128450000001,"1974-10-15","1974-11-01",379.74,379.73586814384311]
["1974-10-01",1071.559634,"1974-11-15","1974-12-01",389.23,389.23343043952048]
["1974-11-01",1196.3302759999999,"1974-12-15","1975-01-01",434.56,434.55513112967668]
["1974-12-01",1293.119267,"1975-01-15","1975-02-01",469.71,469.71277406465674]
["1975-01-01",1318.3486250000001,"1975-02-16","1975-03-01",{"$f":"ROUND(F285,2)","v":478.88},478.87708863058481]
["1975-02-01",1338.0733949999999,"1975-03-16","1975-04-01",486.04,{"$f":"B286/2.753","v":486.04191609153645}]
["1975-03-01",1370.6422030000001,"1975-04-15","1975-05-01",497.87,497.87221322193972]
["1975-04-01",1394.0366979999999,"1975-05-15","1975-06-01",506.37,506.37003196512887]
["1975-05-01",1413.761469,"1975-06-15","1975-07-01",513.53,513.53485978932076]
["1975-06-01",1408.7155969999999,"1975-07-15","1975-08-01",511.7,511.70199673083903]
["1975-07-01",1415.137616,"1975-08-15","1975-09-01",514.03,514.03473156556481]
["1975-08-01",1415.596331,"1975-09-15","1975-10-01",514.20000000000005,514.20135524881948]
["1975-09-01",1444.9541300000001,"1975-10-15","1975-11-01",524.87,524.86528514347981]
["1975-10-01",1536.238533,"1975-11-16","1975-12-01",558.02,558.02344097348339]
["1975-11-01",1584.8623869999999,"1975-12-15","1976-01-01",575.69000000000005,575.6855746458408]
["1975-12-01",1597.2477080000001,"1976-01-15","1976-02-01",580.17999999999995,580.18441990555755]
["1976-01-01",1618.807341,"1976-02-15","1976-03-01",588.02,588.01574318924804]
["1976-02-01",1630.2752310000001,"1976-03-15","1976-04-01",592.17999999999995,592.18134071921543]
["1976-03-01",1688.9908270000001,"1976-04-15","1976-05-01",613.51,613.50919978205593]
["1976-04-01",1785.779818,"1976-05-16","1976-06-01",648.66999999999996,648.66684271703593]
["1976-05-01",1823.853212,"1976-06-15","1976-07-01",662.5,662.4966262259353]
["1976-06-01",1827.522937,"1976-07-15","1976-08-01",663.83,663.82961750817287]
["1976-07-01",1920.6422030000001,"1976-08-15","1976-09-01",697.65,697.65426916091542]
["1976-08-01",1944.036699,"1976-09-15","1976-10-01",706.15,706.15208826734465]
["1976-09-01",1988.532113,"1976-10-15","1976-11-01",722.31,722.31460697420994]
["1976-10-01",2055.045873,"1976-11-15","1976-12-01",746.48,746.47507192154012]
["1976-11-01",2146.7889890000001,"1976-12-15","1977-01-01",779.8,779.79985070831822]
["1976-12-01",2204.5871579999998,"1977-01-16","1977-02-01",800.79,800.79446349436967]
["1977-01-01",2199.3541300000002,"1977-02-15","1977-03-01",798.89,798.89361787141308]
["1977-02-01",2220.1027509999999,"1977-03-15","1977-04-01",806.43,806.43034907373772]
["1977-03-01",2263.4862370000001,"1977-04-15","1977-05-01",822.19,822.18897094079182]
["1977-04-01",2318.1871540000002,"1977-05-15","1977-06-01",842.06,842.05853759535057]
["1977-05-01",2372.8880720000002,"1977-06-15","1977-07-01",861.93,861.92810461314934]
["1977-06-01",2429.4752279999998,"1977-07-15","1977-08-01",882.48,882.48282891391193]
["1977-07-01",2465.31376,"1977-08-15","1977-09-01",895.5,895.50082092262983]
["1977-08-01",2561.5119249999998,"1977-09-15","1977-10-01",930.44,930.44385216127853]
["1977-09-01",2659.596329,"1977-10-16","1977-11-01",966.07,966.0720410461314]
["1977-10-01",2755.7944940000002,"1977-11-15","1977-12-01",1001.02,1001.0150722847803]
["1977-11-01",3082.1137589999998,"1977-12-15","1978-01-01",1119.55,1119.5473152924083]
["1977-12-01",3142.4733919999999,"1978-01-15","1978-02-01",1141.47,1141.4723545223392]
["1978-01-01",3214.1504570000002,"1978-02-15","1978-03-01",1167.51,1167.5083389030149]
["1978-02-01",3265.0788969999999,"1978-03-15","1978-04-01",1186.01,1186.0075906284053]
["1978-03-01",3385.7981629999999,"1978-04-16","1978-05-01",1229.8599999999999,1229.8576690882674]
["1978-04-01",3572.5357779999999,"1978-05-15","1978-06-01",1297.69,1297.6882593534326]
["1978-05-01",3638.554126,"1978-06-15","1978-07-01",{"$f":"ROUND(F325,0)","v":1322},1321.6687707954957]
["1978-06-01",3710.23119,"1978-07-16","1978-08-01",1348,1347.7047548129312]
["1978-07-01",3798.8844009999998,"1978-08-15","1978-09-01",1380,1379.9071561932435]
["1978-08-01",3889.423851,"1978-09-15","1978-10-01",1413,1412.7947152197603]
["1978-09-01",4006.3706400000001,"1978-10-15","1978-11-01",1455,1455.2744787504541]
["1978-10-01",4236.4917409999998,"1978-11-15","1978-12-01",1539,1538.8636908826734]
["1978-11-01",4500.5651349999998,"1978-12-15","1979-01-01",1635,1634.7857373774063]
["1978-12-01",4655.2366949999996,"1979-01-15","1979-02-01",1691,1690.968650563022]
["1979-01-01",4885.3577949999999,"1979-02-15","1979-03-01",1775,1774.5578623320014]
["1979-02-01",5004.1908229999999,"1979-03-15","1979-04-01",1818,1817.7227835088993]
["1979-03-01",5285.2403640000002,"1979-04-15","1979-05-01",1920,1919.8112473665092]
["1979-04-01",5743.5963270000002,"1979-05-15","1979-06-01",2086,2086.3045139847441]
["1979-05-01",6017.1009139999996,"1979-06-15","1979-07-01",2186,2185.6523479840171]
["1979-06-01",6230.245868,"1979-07-15","1979-08-01",2263,2263.0751427533601]
["1979-07-01",6573.5412809999998,"1979-08-15","1979-09-01",2388,2387.7738034871049]
["1979-08-01",7124.322932,"1979-09-16","1979-10-01",2588,2587.8397864148201]
["1979-09-01",7693.9669679999997,"1979-10-15","1979-11-01",2795,2794.7573439883763]
["1979-10-01",8295.6770589999996,"1979-11-15","1979-12-01",3013,3013.3225786414819]
["1979-11-01",9102.9871509999994,"1979-12-16","1980-01-01",3307,3306.5699785688334]
["1979-12-01",9840.5064160000002,"1980-01-15","1980-02-01",3574,3574.4665513984742]
["1980-01-01",10561.049535,"1980-02-15","1980-03-01",3836,3836.1967072284779]
["1980-02-01",11081.65137,"1980-03-16","1980-04-01",4025,4025.3001707228473]
["1980-03-01",11647.522929000001,"1980-04-15","1980-05-01",4231,4230.8474133672362]
["1980-04-01",12835.853203000001,"1980-05-15","1980-06-01",4662,4662.4966229567744]
["1980-05-01",14050.590817,"1980-06-15","1980-07-01",5104,5103.7380374137301]
["1980-06-01",14699.456872000001,"1980-07-15","1980-08-01",5339,{"$f":"B350/2.753","v":5339.4322092262983}]
["1980-07-01",15342.664210999999,"1980-08-15","1980-09-01",5573,5573.0709084634937]
["1980-08-01",16608.330265000001,"1980-09-15","1980-10-01",6033,6032.8115746458407]
["1980-09-01",17815.522925000001,"1980-10-15","1980-11-01",6471,6471.3123592444608]
["1980-10-01",19775.324758999999,"1980-11-16","1980-12-01",7183,7183.1909767526331]
["1980-11-01",21629.497234999999,"1980-12-15","1981-01-01",7857,7856.7007755176164]
["1980-12-01",22923.456867000001,"1981-01-15","1981-02-01",8327,8326.7188038503446]
["1981-01-01",24598.696983999998,"1981-02-15","1981-03-01",8935,8935.2331943334539]
["1981-02-01",25953.042656000001,"1981-03-15","1981-04-01",9427,9427.1858539774785]
["1981-03-01",27197.150890000001,"1981-04-15","1981-05-01",9879,9879.0958554304398]
["1981-04-01",30094.820701000001,"1981-05-15","1981-06-01",10932,10931.645732292045]
["1981-05-01",31102.705852999999,"1981-06-15","1981-07-01",11298,11297.750037413729]
["1981-06-01",31953.108949000001,"1981-07-15","1981-08-01",11607,11606.650544496912]
["1981-07-01",33890.138225000002,"1981-08-16","1981-09-01",12310,12310.257255721031]
["1981-08-01",35212.987486999999,"1981-09-15","1981-10-01",12791,12790.769156193242]
["1981-09-01",38079.160886999998,"1981-10-15","1981-11-01",13832,13831.878273519795]
["1981-10-01",41512.269684999999,"1981-11-15","1981-12-01",15079,15078.921062477297]
["1981-11-01",43921.745125000001,"1981-12-15","1982-01-01",15954,15954.139166363966]
["1981-12-01",46189.486717,"1982-01-15","1982-02-01",16778,16777.873852887758]
["1982-01-01",50032.048858000002,"1982-02-15","1982-03-01",{"$f":"ROUND(F369/10,0)*10","v":18170},18173.646515800945]
["1982-02-01",52882.474051999998,"1982-03-15","1982-04-01",19210,19209.03525317835]
["1982-03-01",55559.668985999997,"1982-04-15","1982-05-01",20180,20181.499813294588]
["1982-04-01",61480.994251999997,"1982-05-16","1982-06-01",22330,22332.362605158007]
["1982-05-01",65307.808188000003,"1982-06-15","1982-07-01",23720,23722.414888485288]
["1982-06-01",69244.859561000005,"1982-07-15","1982-08-01",25150,25152.509829640392]
["1982-07-01",75622.882786999995,"1982-08-15","1982-09-01",27470,27469.263634943694]
["1982-08-01",81575.704463999995,"1982-09-15","1982-10-01",29630,29631.56718634217]
["1982-09-01",87764.749223999999,"1982-10-15","1982-11-01",31880,31879.676434435161]
["1982-10-01",95134.909394999995,"1982-11-15","1982-12-01",34560,34556.814164547766]
["1982-11-01",101308.205949,"1982-12-15","1983-01-01",36800,36799.203032691606]
["1982-12-01",106930.315311,"1983-01-16","1983-02-01",38840,38841.378609153646]
["1983-01-01",116001.281676,"1983-02-15","1983-03-01",42140,42136.317354159095]
["1983-02-01",123040.729532,"1983-03-15","1983-04-01",44690,44693.327109335267]
["1983-03-01",129985.688155,"1983-04-15","1983-05-01",47220,47216.014585906283]
["1983-04-01",147229.973172,"1983-05-15","1983-06-01",53480,53479.8304293498]
["1983-05-01",155356.047208,"1983-06-15","1983-07-01",56430,56431.546388666909]
["1983-06-01",160946.66015800001,"1983-07-15","1983-08-01",58460,58462.281205230662]
["1983-07-01",171009.763469,"1983-08-15","1983-09-01",62120,62117.60387540864]
["1983-08-01",183261.86734500001,"1983-09-15","1983-10-01",66570,66568.05933345441]
["1983-09-01",199734.49029300001,"1983-10-16","1983-11-01",72550,72551.576568470759]
["1983-10-01",241813.69537500001,"1983-11-15","1983-12-01",87840,87836.431302215758]
["1983-11-01",278507.01417899999,"1983-12-15","1984-01-01",{"$f":"ROUND(F391/100,0)*100","v":101200},101164.91615655647]
["1983-12-01",310838.08006000001,"1984-01-15","1984-02-01",112900,112908.85581547403]
["1984-01-01",357216.54524299997,"1984-02-15","1984-03-01",129800,129755.37422557209]
["1984-02-01",399972.92316200002,"1984-03-15","1984-04-01",145300,145286.20528950237]
["1984-03-01",442634.81184699998,"1984-04-15","1984-05-01",160800,160782.71407446419]
["1984-04-01",533816.92166400002,"1984-05-15","1984-06-01",193900,193903.71291827099]
["1984-05-01",610132.725492,"1984-06-15","1984-07-01",221600,221624.67326262259]
["1984-06-01",691613.94072299998,"1984-07-15","1984-08-01",251200,251221.9181703596]
["1984-07-01",777032.20732799999,"1984-08-15","1984-09-01",282200,282249.25801961496]
["1984-08-01",905033.62159200001,"1984-09-16","1984-10-01",328700,328744.50475553941]
["1984-09-01",1098437.3332700001,"1984-10-15","1984-11-01",399000,398996.48865601164]
["1984-10-01",1365778.8697500001,"1984-11-15","1984-12-01",496100,496105.65555757354]
["1984-11-01",1632679.4564799999,"1984-12-16","1985-01-01",593100,593054.65182709764]
["1984-12-01",1693688.0045700001,"1985-01-15","1985-02-01",615200,615215.40304031968]
["1985-01-01",1782696.86,"1985-02-15","1985-03-01",647500,647546.98873955687]
["1985-02-01",2023644.41,"1985-03-15","1985-04-01",735100,735068.80130766425]
["1985-03-01",2267741.59,"1985-04-15","1985-05-01",823700,823734.68579731195]
["1985-04-01",2707116.52,"1985-05-15","1985-06-01",983300,983333.2800581184]
["1985-05-01",2891370.53,"1985-06-16","1985-07-01",{"$f":"ROUND(F409/1000,0)*1000","v":1050000},1050261.7253904829]
["1985-06-01",3322871.36,"1985-07-15","1985-08-01",1207000,1207000.1307664365]
["1985-07-01",4236267.28,"1985-08-15","1985-09-01",1539000,1538782.1576462041]
["1985-08-01",4401623.4400000004,"1985-09-15","1985-10-01",1599000,1598846.146022521]
["1985-09-01",4535483.18,"1985-10-15","1985-11-01",1647000,1647469.3715946239]
["1985-10-01",4746509.1399999997,"1985-11-15","1985-12-01",1724000,{"$f":"B414/2.753","v":1724122.4627678895}]
["1985-11-01",4768556.62,"1985-12-15","1986-01-01",{"$f":"ROUND(F415/1000,0)","v":1732},1732130.9916454777]
["1985-12-01",4829974.63,"1986-01-15","1986-02-01",1754,1754440.4758445332]
["1986-01-01",4765800.6900000004,"1986-02-16","1986-03-01",1731,1731129.9273519798]
["1986-02-01",4843754.3099999996,"1986-03-16","1986-04-01",1759,1759445.808209226]
["1986-03-01",4918164.58,"1986-04-15","1986-05-01",1786,1786474.6022520885]
["1986-04-01",5081158.5,"1986-05-15","1986-06-01",1846,1845680.5303305485]
["1986-05-01",5162655.47,"1986-06-15","1986-07-01",1875,1875283.4980021792]
["1986-06-01",5247695.78,"1986-07-15","1986-08-01",1906,1906173.5488557937]
["1986-07-01",5247695.78,"1986-08-15","1986-09-01",1906,1906173.5488557937]
["1986-08-01",5304389.32,"1986-09-15","1986-10-01",1927,1926766.9160915366]
["1986-09-01",5407146.3600000003,"1986-10-15","1986-11-01",1964,1964092.3937522704]
["1986-10-01",5534706.8200000003,"1986-11-16","1986-12-01",2010,2010427.4682164912]
["1986-11-01",5694157.4000000004,"1986-12-15","1987-01-01",2068,2068346.3131129676]
["1986-12-01",5779197.71,"1987-01-15","1987-02-01",2099,2099236.3639665819]
["1987-01-01",5903214.8300000001,"1987-02-15","1987-03-01",2144,2144284.3552488196]
["1987-02-01",5959908.3700000001,"1987-03-15","1987-04-01",2165,2164877.7224845621]
["1987-03-01",6037861.9900000002,"1987-04-15","1987-05-01",2193,2193193.603341809]
["1987-04-01",6172509.1399999997,"1987-05-15","1987-06-01",2242,2242102.8478023973]
["1987-05-01",6211485.9500000002,"1987-06-15","1987-07-01",2256,2256260.7882310208]
["1987-06-01",6271722.8399999999,"1987-07-15","1987-08-01",2278,2278141.2422811477]
["1987-07-01",6285896.2199999997,"1987-08-16","1987-09-01",2283,2283289.5822738828]
["1987-08-01",6363849.8399999999,"1987-09-15","1987-10-01",2312,2311605.4631311297]
["1987-09-01",6424086.7300000004,"1987-10-15","1987-11-01",2333,2333485.9171812567]
["1987-10-01",6523300.4199999999,"1987-11-15","1987-12-01",2370,2369524.308027606]
["1987-11-01",6626057.46,"1987-12-15","1988-01-01",2407,2406849.7856883397]
["1987-12-01",6711097.7699999996,"1988-01-15","1988-02-01",2438,2437739.836541954]
["1988-01-01",6817752.4900000002,"1988-02-15","1988-03-01",2476,2476481.1078823102]
["1988-02-01",6874357.4500000002,"1988-03-15","1988-04-01",2497,2497042.2993098437]
["1988-03-01",6987567.3700000001,"1988-04-15","1988-05-01",2538,2538164.6821649107]
["1988-04-01",7176250.5599999996,"1988-05-15","1988-06-01",2607,2606701.983290955]
["1988-05-01",7264302.71,"1988-06-15","1988-07-01",2639,2638686.0552124954]
["1988-06-01",7283171.0300000003,"1988-07-15","1988-08-01",2646,2645539.7856883402]
["1988-07-01",7289460.4699999997,"1988-08-15","1988-09-01",2648,2647824.3625136213]
["1988-08-01",7346065.4299999997,"1988-09-15","1988-10-01",2668,2668385.5539411549]
["1988-09-01",7471854.2199999997,"1988-10-16","1988-11-01",2714,2714077.086814384]
["1988-10-01",7647958.5300000003,"1988-11-15","1988-12-01",2778,2778045.2342898655]
["1988-11-01",7773747.3200000003,"1988-12-15","1989-01-01",2824,2823736.7671630946]
["1988-12-01",7811483.96,"1989-01-15","1989-02-01",2837,2837444.2281147838]
["1989-01-01",8176271.4500000002,"1989-02-15","1989-03-01",2970,2969949.6730839084]
["1989-02-01",8314639.1200000001,"1989-03-15","1989-04-01",3020,3020210.3596077007]
["1989-03-01",8352375.7599999998,"1989-04-16","1989-05-01",3034,3033917.8205593894]
["1989-04-01",8566216.7100000009,"1989-05-15","1989-06-01",3112,3111593.4289865601]
["1989-05-01",8641689.9800000004,"1989-06-15","1989-07-01",3139,3139008.3472575373]
["1989-06-01",8748610.4499999993,"1989-07-16","1989-08-01",3178,3177846.1496549216]
["1989-07-01",8798925.9700000007,"1989-08-15","1989-09-01",3196,3196122.764257174]
["1989-08-01",8905846.4399999995,"1989-09-15","1989-10-01",3235,3234960.5666545583]
["1989-09-01",9044214.1099999994,"1989-10-15","1989-11-01",3285,3285221.2531783506]
["1989-10-01",9207739.5399999991,"1989-11-15","1989-12-01",3345,3344620.2470032689]
["1989-11-01",9327238.8900000006,"1989-12-15","1990-01-01",3388,3388027.2030512169]
["1989-12-01",9427869.9299999997,"1990-01-15","1990-02-01",3425,3424580.4322557207]
["1990-01-01",9528500.9600000009,"1990-02-15","1990-03-01",3461,3461133.6578278244]
["1990-02-01",9578816.4800000004,"1990-03-15","1990-04-01",3479,3479410.2724300763]
["1990-03-01",9698315.8300000001,"1990-04-15","1990-05-01",3523,3522817.2284780238]
["1990-04-01",9943603.9700000007,"1990-05-15","1990-06-01",3612,3611915.7173992009]
["1990-05-01",10100839.960000001,"1990-06-15","1990-07-01",3669,3669030.1343988376]
["1990-06-01",10176313.24,"1990-07-15","1990-08-01",3696,3696445.0563022159]
["1990-07-01",10339838.67,"1990-08-15","1990-09-01",3756,3755844.0501271337]
["1990-08-01",10503364.1,"1990-09-16","1990-10-01",3815,3815243.043952052]
["1990-09-01",10723494.48,"1990-10-15","1990-11-01",3895,3895203.2255721032]
["1990-10-01",10905888.23,"1990-11-15","1990-12-01",3961,3961455.9498728658]
["1990-11-01",11044255.9,"1990-12-16","1991-01-01",4012,4011716.6363966581]
["1990-12-01",11088281.98,"1991-01-15","1991-02-01",4028,4027708.6741736289]
["1991-01-01",11232939.09,"1991-02-15","1991-03-01",4080,4080253.9375227024]
["1991-02-01",11302122.92,"1991-03-15","1991-04-01",4105,{"$f":"B478/2.753","v":4105384.278968398}]
["1991-03-01",11440490.59,"1991-04-15","1991-05-01",{"$f":"ROUND(F479/1000,0)","v":4156},4155644.9654921903]
["1991-04-01",11692068.18,"1991-05-15","1991-06-01",4247,4247028.0348710492]
["1991-05-01",11912198.560000001,"1991-06-16","1991-07-01",4327,4326988.2164911004]
["1991-06-01",12144907.83,"1991-07-15","1991-08-01",4412,4411517.5553941149]
["1991-07-01",12509695.32,"1991-08-15","1991-09-01",4544,4544023.00036324]
["1991-08-01",12767562.34,"1991-09-15","1991-10-01",4638,4637690.6429349799]
["1991-09-01",12968824.41,"1991-10-15","1991-11-01",4711,4710797.0977115873]
["1991-10-01",13025429.369999999,"1991-11-15","1991-12-01",4731,4731358.2891391208]
["1991-11-01",13044297.960000001,"1991-12-15","1992-01-01",4738,4738212.117689793]
["1991-12-01",13088323.76,"1992-01-15","1992-02-01",4754,4754204.0537595348]
["1992-01-01",13088323.76,"1992-02-16","1992-03-01",4754,4754204.0537595348]
["1992-02-01",13220401.99,"1992-03-15","1992-04-01",4802,4802180.1634580456]
["1992-03-01",13415374.619999999,"1992-04-15","1992-05-01",4873,4873002.0414093714]
["1992-04-01",13654373.32,"1992-05-15","1992-06-01",4960,4959815.9535052665]
["1992-05-01",13604057.810000001,"1992-06-15","1992-07-01",4942,4941539.3425354157]
["1992-06-01",13622926.130000001,"1992-07-15","1992-08-01",4948,4948393.0730112605]
["1992-07-01",13717267.720000001,"1992-08-16","1992-09-01",4983,4982661.7217580825]
["1992-08-01",13824188.189999999,"1992-09-15","1992-10-01",5021,5021499.5241554668]
["1992-09-01",14006581.939999999,"1992-10-15","1992-11-01",5088,5087752.2484562295]
["1992-10-01",14075765.779999999,"1992-11-15","1992-12-01",5113,5112882.5935343262]
["1992-11-01",14163817.93,"1992-12-15","1993-01-01",5145,5144866.6654558657]
["1992-12-01",14314764.48,"1993-01-15","1993-02-01",5200,5199696.5056302212]
["1993-01-01",14497158.23,"1993-02-15","1993-03-01",5266,5265949.2299309848]
["1993-02-01",14673262.539999999,"1993-03-15","1993-04-01",5330,5329917.3774064649]
["1993-03-01",14861945.720000001,"1993-04-15","1993-05-01",5398,5398454.6749001089]
["1993-04-01",15069497.23,"1993-05-16","1993-06-01",5474,5473845.706501998]
["1993-05-01",15113523.310000001,"1993-06-15","1993-07-01",5490,5489837.7442789683]
["1993-06-01",15151259.939999999,"1993-07-15","1993-08-01",5504,5503545.2015982559]
["1993-07-01",15170128.26,"1993-08-15","1993-09-01",5510,5510398.9320741007]
["1993-08-01",15314785.369999999,"1993-09-15","1993-10-01",5563,5562944.1954231746]
["1993-09-01",15465731.92,"1993-10-15","1993-11-01",5618,5617774.0355975293]
["1993-10-01",15685862.310000001,"1993-11-15","1993-12-01",5698,5697734.2208499815]
["1993-11-01",15805361.66,"1993-12-15","1994-01-01",5741,5741141.1768979291]
["1993-12-01",15924861.01,"1994-01-16","1994-02-01",5785,5784548.1329458766]
["1994-01-01",16033750.08,"1994-02-15","1994-03-01",5824,5824101.0098074824]
["1994-02-01",16125110.48,"1994-03-15","1994-04-01",5857,5857286.7707954962]
["1994-03-01",16292604.539999999,"1994-04-15","1994-05-01",5918,5918127.3301852522]
["1994-04-01",16612365.939999999,"1994-05-15","1994-06-01",6034,6034277.4936432978]
["1994-05-01",16810313.469999999,"1994-06-15","1994-07-01",6106,6106179.9745731922]
["1994-06-01",17038714.469999999,"1994-07-15","1994-08-01",6189,6189144.3770432249]
["1994-07-01",17221435.27,"1994-08-15","1994-09-01",6256,6255515.8990192516]
["1994-08-01",17404156.07,"1994-09-15","1994-10-01",6322,6321887.4209952774]
["1994-09-01",17602103.600000001,"1994-10-16","1994-11-01",6394,6393789.9019251727]
["1994-10-01",17845731.329999998,"1994-11-15","1994-12-01",6482,6482285.263349073]
["1994-11-01",18074132.329999998,"1994-12-15","1995-01-01",6565,6565249.6658191057]
["1994-12-01",18226399.66,"1995-01-15","1995-02-01",6621,6620559.2662549941]
["1995-01-01",18256853.129999999,"1995-02-15","1995-03-01",6632,6631621.1877951315]
["1995-02-01",18287306.600000001,"1995-03-15","1995-04-01",6643,6642683.1093352707]
["1995-03-01",18272079.859999999,"1995-04-16","1995-05-01",6637,6637152.146749001]
["1995-04-01",18439573.93,"1995-05-15","1995-06-01",6698,6697992.7097711582]
["1995-05-01",18622294.73,"1995-06-15","1995-07-01",6764,6764364.2317471849]
["1995-06-01",18683201.66,"1995-07-16","1995-08-01",6786,6786488.0711950595]
["1995-07-01",18728881.859999999,"1995-08-15","1995-09-01",6803,6803080.9516890664]
["1995-08-01",18957282.859999999,"1995-09-15","1995-10-01",6886,6886045.354159099]
["1995-09-01",19140003.66,"1995-10-15","1995-11-01",6952,6952416.8761351248]
["1995-10-01",19337951.190000001,"1995-11-15","1995-12-01",7024,7024319.3570650201]
["1995-11-01",19474991.789999999,"1995-12-15","1996-01-01",7074,7074097.998547039]
["1995-12-01",19703392.789999999,"1996-01-15","1996-02-01",7157,7157062.4010170717]
["1996-01-01",19870886.850000001,"1996-02-15","1996-03-01",7218,7217902.9604068296]
["1996-02-01",20053607.649999999,"1996-03-15","1996-04-01",7284,7284274.4823828544]
["1996-03-01",20251555.18,"1996-04-15","1996-05-01",7356,7356176.9633127498]
["1996-04-01",20586543.309999999,"1996-05-15","1996-06-01",7478,7477858.085724663]
["1996-05-01",20936758.18,"1996-06-16","1996-07-01",7605,7605070.1707228478]
["1996-06-01",21089025.510000002,"1996-07-15","1996-08-01",7660,{"$f":"B542/2.753","v":7660379.7711587362}]
["1996-07-01",21149932.440000001,"1996-08-15","1996-09-01",{"$f":"ROUND(F543/1000,0)","v":7683},7682503.6106066108]
["1996-08-01",21226066.109999999,"1996-09-15","1996-10-01",7710,7710158.4126407551]
["1996-09-01",21317426.510000002,"1996-10-15","1996-11-01",7743,7743344.1736287689]
["1996-10-01",21484920.57,"1996-11-15","1996-12-01",7804,7804184.7330185249]
["1996-11-01",21621961.170000002,"1996-12-15","1997-01-01",7854,7853963.3745005447]
["1996-12-01",21789455.239999998,"1997-01-15","1997-02-01",7915,7914803.9375227019]
["1997-01-01",21880815.640000001,"1997-02-16","1997-03-01",7948,7947989.6985107157]
["1997-02-01",22139670.100000001,"1997-03-16","1997-04-01",8042,8042016.0188884856]
["1997-03-01",22352844.370000001,"1997-04-15","1997-05-01",8119,8119449.4624046497]
["1997-04-01",22520338.43,"1997-05-15","1997-06-01",8180,8180290.0217944058]
["1997-05-01",22626925.559999999,"1997-06-15","1997-07-01",8219,8219006.7417362873]
["1997-06-01",22870553.300000001,"1997-07-15","1997-08-01",8308,8307502.1067925896]
["1997-07-01",23098954.289999999,"1997-08-15","1997-09-01",8390,8390466.5056302212]
["1997-08-01",23190314.690000001,"1997-09-15","1997-10-01",8424,8423652.266618235]
["1997-09-01",23175087.960000001,"1997-10-15","1997-11-01",8418,8418121.3076643664]
["1997-10-01",23449169.16,"1997-11-16","1997-12-01",8518,8517678.5906284042]
["1997-11-01",23388262.23,"1997-12-15","1998-01-01",8496,8495554.7511805296]
["1997-12-01",23312128.559999999,"1998-01-15","1998-02-01",8468,8467899.9491463844]
["1998-01-01",23388262.23,"1998-02-15","1998-03-01",8496,8495554.7511805296]
["1998-02-01",23373035.489999998,"1998-03-15","1998-04-01",8490,8490023.7885942589]
["1998-03-01",23327355.289999999,"1998-04-15","1998-05-01",8473,8473430.908100253]
["1998-04-01",23647116.690000001,"1998-05-15","1998-06-01",8590,8589581.0715583004]
["1998-05-01",23738477.09,"1998-06-15","1998-07-01",8623,8622766.8325463124]
["1998-06-01",23829837.489999998,"1998-07-15","1998-08-01",8656,8655952.5935343243]
["1998-07-01",23799384.02,"1998-08-16","1998-09-01",8645,8644890.6719941869]
["1998-08-01",23921197.890000001,"1998-09-15","1998-10-01",8689,8689138.35452234]
["1998-09-01",24256186.02,"1998-10-15","1998-11-01",8811,8810819.4769342523]
["1998-10-01",24987069.210000001,"1998-11-15","1998-12-01",9076,9076305.5612059571]
["1998-11-01",25306830.609999999,"1998-12-15","1999-01-01",9192,9192455.7246640027]
["1998-12-01",25322057.34,"1999-01-15","1999-02-01",9198,9197986.6836178713]
["1999-01-01",25204918.09,"1999-02-15","1999-03-01",9155,9155437.0105339624]
["1999-02-01",25012330.359999999,"1999-03-15","1999-04-01",9085,9085481.4239011984]
["1999-03-01",24964183.43,"1999-04-15","1999-05-01",9068,9067992.528151108]
["1999-04-01",25036403.829999998,"1999-05-16","1999-06-01",9094,9094225.8735924438]
["1999-05-01",25156771.149999999,"1999-06-15","1999-07-01",9138,9137948.1111514699]
["1999-06-01",25228991.550000001,"1999-07-15","1999-08-01",9164,9164181.4565928075]
["1999-07-01",25301211.949999999,"1999-08-15","1999-09-01",9190,9190414.8020341434]
["1999-08-01",25421579.27,"1999-09-15","1999-10-01",9234,9234137.0395931713]
["1999-09-01",25541946.600000001,"1999-10-15","1999-11-01",9278,9277859.2807845995]
["1999-10-01",25710460.850000001,"1999-11-15","1999-12-01",9339,9339070.4140937161]
["1999-11-01",25662313.920000002,"1999-12-15","2000-01-01",9322,9321581.5183436256]
["1999-12-01",25662313.920000002,"2000-01-16","2000-02-01",9322,9321581.5183436256]
["2000-01-01",25541946.600000001,"2000-02-15","2000-03-01",9278,9277859.2807845995]
["2000-02-01",25421579.27,"2000-03-15","2000-04-01",9234,9234137.0395931713]
["2000-03-01",25349358.879999999,"2000-04-16","2000-05-01",9208,9207903.6977842338]
["2000-04-01",25469726.199999999,"2000-05-15","2000-06-01",9252,9251625.9353432618]
["2000-05-01",25686387.390000001,"2000-06-15","2000-07-01",9330,9330325.9680348709]
["2000-06-01",25758607.789999999,"2000-07-16","2000-08-01",9357,9356559.3134762067]
["2000-07-01",25830828.18,"2000-08-15","2000-09-01",9383,9382792.6552851424]
["2000-08-01",25686387.390000001,"2000-09-15","2000-10-01",9330,9330325.9680348709]
["2000-09-01",25541946.600000001,"2000-10-15","2000-11-01",9278,9277859.2807845995]
["2000-10-01",25686387.390000001,"2000-11-15","2000-12-01",9330,9330325.9680348709]
["2000-11-01",25686387.390000001,"2000-12-15","2001-01-01",9330,9330325.9680348709]
["2000-12-01",25662313.920000002,"2001-01-15","2001-02-01",9322,9321581.5183436256]
["2001-01-01",25511710.329999998,"2001-02-15","2001-03-01",9267,9266876.2549945507]
["2001-02-01",25486096.16,"2001-03-15","2001-04-01",9258,9257572.1612786055]
["2001-03-01",25537324.489999998,"2001-04-15","2001-05-01",9276,9276180.3450780958]
["2001-04-01",25767852,"2001-05-15","2001-06-01",9360,9359917.1812568102]
["2001-05-01",25870308.66,"2001-06-15","2001-07-01",9397,9397133.5488557927]
["2001-06-01",25947151.16,"2001-07-15","2001-08-01",9425,9425045.8263712302]
["2001-07-01",26049607.829999998,"2001-08-15","2001-09-01",9462,9462262.1976026148]
["2001-08-01",26126450.329999998,"2001-09-16","2001-10-01",9490,9490174.4751180522]
["2001-09-01",26177678.670000002,"2001-10-15","2001-11-01",9509,9508782.6625499465]
["2001-10-01",26203292.829999998,"2001-11-15","2001-12-01",9518,{"$f":"B606/2.753","v":9518086.7526334897}]
["2001-11-01",26049607.829999998,"2001-12-16","2002-01-01",{"$f":"ROUND(F607/1000,0)","v":9462},9462262.1976026148]
["2001-12-01",26023993.670000002,"2002-01-15","2002-02-01",9453,9452958.1075190697]
["2002-01-01",26305749.5,"2002-02-15","2002-03-01",9555,9555303.1238648742]
["2002-02-01",26510662.84,"2002-03-15","2002-04-01",9630,9629735.8663276415]
["2002-03-01",26638733.670000002,"2002-04-15","2002-05-01",9676,9676256.3276425712]
["2002-04-01",27048560.350000001,"2002-05-15","2002-06-01",9825,9825121.8125681076]
["2002-05-01",27304702.02,"2002-06-16","2002-07-01",9918,9918162.7388303671]
["2002-06-01",27663300.350000001,"2002-07-15","2002-08-01",10048,10048420.032691609]
["2002-07-01",27842599.52,"2002-08-15","2002-09-01",10114,10113548.681438431]
["2002-08-01",27740142.850000001,"2002-09-15","2002-10-01",10076,10076332.310207047]
["2002-09-01",27842599.52,"2002-10-15","2002-11-01",10114,10113548.681438431]
["2002-10-01",28021898.690000001,"2002-11-15","2002-12-01",10179,10178677.330185253]
["2002-11-01",27791371.190000001,"2002-12-15","2003-01-01",10095,10094940.497638939]
["2002-12-01",27714528.690000001,"2003-01-15","2003-02-01",10067,10067028.220123501]
["2003-01-01",27766269.300000001,"2003-02-16","2003-03-01",10086,10085822.484562296]
["2003-02-01",27875693.030000001,"2003-03-16","2003-04-01",10126,10125569.571376679]
["2003-03-01",27930404.890000001,"2003-04-15","2003-05-01",10145,10145443.112967672]
["2003-04-01",27875693.030000001,"2003-05-15","2003-06-01",10126,10125569.571376679]
["2003-05-01",27738913.370000001,"2003-06-15","2003-07-01",10076,10075885.7137668]
["2003-06-01",27574777.789999999,"2003-07-15","2003-08-01",10016,10016265.088993825]
["2003-07-01",27383286.280000001,"2003-08-15","2003-09-01",9947,9946707.6934253536]
["2003-08-01",27437998.140000001,"2003-09-15","2003-10-01",9967,9966581.235016346]
["2003-09-01",27301218.489999998,"2003-10-15","2003-11-01",9917,9916897.3810388651]
["2003-10-01",27301218.489999998,"2003-11-16","2003-12-01",9917,9916897.3810388651]
["2003-11-01",27246506.629999999,"2003-12-15","2004-01-01",9897,9897023.8394478746]
["2003-12-01",27191794.77,"2004-01-15","2004-02-01",9877,9877150.2978568822]
["2004-01-01",27137082.91,"2004-02-15","2004-03-01",9857,9857276.7562658917]
["2004-02-01",27191794.77,"2004-03-15","2004-04-01",9877,9877150.2978568822]
["2004-03-01",27164438.84,"2004-04-15","2004-05-01",9867,9867213.5270613879]
["2004-04-01",27465354.07,"2004-05-16","2004-06-01",9977,9976518.0058118422]
["2004-05-01",27574777.789999999,"2004-06-15","2004-07-01",10016,10016265.088993825]
["2004-06-01",27574777.789999999,"2004-07-15","2004-08-01",10016,10016265.088993825]
["2004-07-01",27520065.93,"2004-08-15","2004-09-01",9996,9996391.5474028327]
["2004-08-01",27574777.789999999,"2004-08-16","2004-10-01",10016,10016265.088993825]
["2004-09-01",27520065.93,"2004-08-15","2004-11-01",9996,9996391.5474028327]
["2004-10-01",27520065.93,"2004-11-15","2004-12-01",9996,9996391.5474028327]
["2004-11-01",27492710,"2004-12-15","2005-01-01",9986,9986454.7766073365]
["2004-12-01",27520065.93,"2005-01-16","2005-02-01",9996,9996391.5474028327]
["2005-01-01",27355930.350000001,"2005-02-15","2005-03-01",9937,9936770.9226298593]
["2005-02-01",27410642.210000001,"2005-03-15","2005-04-01",9957,9956644.4642208498]
["2005-03-01",27355930.350000001,"2005-04-15","2005-05-01",9937,9936770.9226298593]
["2005-04-01",27547421.859999999,"2005-05-15","2005-06-01",10006,10006328.318198329]
["2005-05-01",27629489.649999999,"2005-06-15","2005-07-01",10036,10036138.630584816]
["2005-06-01",27656845.579999998,"2005-07-15","2005-08-01",10046,10046075.401380312]
["2005-07-01",27957760.82,"2005-08-15","2005-09-01",10155,10155379.883763168]
["2005-08-01",28012472.68,"2005-09-15","2005-10-01",10175,10175253.425354159]
["2005-09-01",28039828.609999999,"2005-10-14","2005-11-01",10185,10185190.196149655]
["2005-10-01",28258676.050000001,"2005-11-15","2005-12-01",10265,10264684.362513622]
["2005-11-01",28231320.120000001,"2005-12-15","2006-01-01",10255,10254747.591718126]
["2005-12-01",28176608.260000002,"2006-01-15","2006-02-01",10235,10234874.050127134]
["2006-01-01",28094540.469999999,"2006-02-15","2006-03-01",10205,10205063.737740645]
["2006-02-01",28258676.050000001,"2006-03-15","2006-04-01",10265,10264684.362513622]
["2006-03-01",28340743.84,"2006-04-14","2006-05-01",10294,10294494.674900109]
["2006-04-01",28586947.219999999,"2006-05-15","2006-06-01",10384,10383925.615691971]
["2006-05-01",28586947.219999999,"2006-06-15","2006-07-01",10384,10383925.615691971]
["2006-06-01",28614303.149999999,"2006-07-14","2006-08-01",10394,10393862.386487467]
["2006-07-01",28641659.079999998,"2006-08-15","2006-09-01",10404,10403799.157282963]
["2006-08-01",28641659.079999998,"2006-09-15","2006-10-01",10404,10403799.157282963]
["2006-09-01",28395455.699999999,"2006-10-15","2006-11-01",10314,10314368.216491099]
["2006-10-01",28203964.190000001,"2006-11-15","2006-12-01",10245,10244810.82092263]
["2006-11-01",28149252.329999998,"2006-12-15","2007-01-01",10225,10224937.279331638]
["2006-12-01",28149252.329999998,"2007-01-15","2007-02-01",10225,10224937.279331638]
["2007-01-01",28111501.149999999,"2007-02-15","2007-03-01",10211,10211224.53686887]
["2007-02-01",28026314.780000001,"2007-03-15","2007-04-01",10180,{"$f":"B670/2.753","v":10180281.431166001}]
["2007-03-01",28083105.690000001,"2007-04-15","2007-05-01",{"$f":"ROUND(F671/1000,0)","v":10201},10200910.167090448]
["2007-04-01",28225082.969999999,"2007-05-15","2007-06-01",10252,10252482.008717762]
["2007-05-01",28225082.969999999,"2007-06-15","2007-07-01",10252,10252482.008717762]
["2007-06-01",28423851.16,"2007-07-15","2007-08-01",10325,10324682.586269524]
["2007-07-01",28736201.170000002,"2007-08-15","2007-09-01",10438,10438140.635670178]
["2007-08-01",28934969.359999999,"2007-09-16","2007-10-01",10510,10510341.213221939]
["2007-09-01",28792992.079999998,"2007-10-15","2007-11-01",10459,10458769.371594623]
["2007-10-01",28821387.539999999,"2007-11-15","2007-12-01",10469,10469083.741373047]
["2007-11-01",28934969.359999999,"2007-12-16","2008-01-01",10510,10510341.213221939]
["2007-12-01",29105342.100000001,"2008-01-15","2008-02-01",10572,10572227.424627678]
["2008-01-01",29105342.100000001,"2008-02-15","2008-03-01",10572,10572227.424627678]
["2008-02-01",29048551.18,"2008-03-14","2008-04-01",10552,10551598.685070831]
["2008-03-01",29133737.550000001,"2008-04-15","2008-05-01",10583,10582541.790773701]
["2008-04-01",29559669.390000001,"2008-05-15","2008-06-01",10737,10737257.315655649]
["2008-05-01",29758437.579999998,"2008-06-15","2008-07-01",10809,10809457.893207408]
["2008-06-01",29786833.030000001,"2008-07-15","2008-08-01",10820,10819772.259353433]
["2008-07-01",30127578.5,"2008-08-15","2008-09-01",10944,10943544.678532509]
["2008-08-01",30383137.600000001,"2008-09-15","2008-10-01",11036,11036373.992008718]
["2008-09-01",30383137.600000001,"2008-10-15","2008-11-01",11036,11036373.992008718]
["2008-10-01",30411533.059999999,"2008-11-14","2008-12-01",11047,11046688.36178714]
["2008-11-01",30241160.32,"2008-12-15","2009-01-01",10985,10984802.150381401]
["2008-12-01",30212764.84,"2009-01-15","2009-02-01",10974,10974487.773338176]
["2009-01-01",30052529.309999999,"2009-02-15","2009-03-01",10916,10916283.803123863]
["2009-02-01",30022685.690000001,"2009-03-15","2009-04-01",10905,10905443.403559754]
["2009-03-01",30171903.809999999,"2009-04-15","2009-05-01",10960,10959645.408645114]
["2009-04-01",30470340.050000001,"2009-05-15","2009-06-01",11068,11068049.418815836]
["2009-05-01",30589714.539999999,"2009-06-15","2009-07-01",11111,11111411.020704685]
["2009-06-01",30858307.16,"2009-07-15","2009-08-01",11209,11208974.631311296]
["2009-07-01",31186587.02,"2009-08-15","2009-09-01",11328,11328219.041046131]
["2009-08-01",31335805.140000001,"2009-09-15","2009-10-01",11382,11382421.046131494]
["2009-09-01",31246274.27,"2009-10-15","2009-11-01",11350,11349899.843806755]
["2009-10-01",31305961.52,"2009-11-15","2009-12-01",11372,11371580.64656738]
["2009-11-01",31395492.390000001,"2009-12-15","2010-01-01",11404,11404101.848892117]
["2009-12-01",31395492.390000001,"2010-01-15","2010-02-01",11404,11404101.848892117]
["2010-01-01",31186587.02,"2010-02-15","2010-03-01",11328,11328219.041046131]
["2010-02-01",31097056.149999999,"2010-03-15","2010-04-01",11296,11295697.838721395]
["2010-03-01",31126899.77,"2010-04-15","2010-05-01",11307,11306538.238285506]
["2010-04-01",31395492.390000001,"2010-05-14","2010-06-01",11404,11404101.848892117]
["2010-05-01",31514866.879999999,"2010-06-15","2010-07-01",11447,11447463.450780965]
["2010-06-01",31604397.760000002,"2010-07-15","2010-08-01",11480,11479984.656738104]
["2010-07-01",31753615.879999999,"2010-08-15","2010-09-01",11534,11534186.661823465]
["2010-08-01",31902834,"2010-09-15","2010-10-01",11588,11588388.666908827]
["2010-09-01",31992364.870000001,"2010-10-15","2010-11-01",11621,11620909.869233564]
["2010-10-01",32081895.739999998,"2010-11-15","2010-12-01",11653,11653431.071558299]
["2010-11-01",32111739.359999999,"2010-12-15","2011-01-01",11664,11664271.471122412]
["2010-12-01",32231113.859999999,"2011-01-15","2011-02-01",11708,11707633.076643661]
["2011-01-01",32297366.704399999,"2011-02-15","2011-03-01",11732,11731698.76658191]
["2011-02-01",32392358.960000001,"2011-03-15","2011-04-01",11766,11766203.763167454]
["2011-03-01",32455687.129999999,"2011-04-15","2011-05-01",11789,11789207.094079185]
["2011-04-01",32645671.640000001,"2011-05-15","2011-06-01",11858,11858217.086814385]
["2011-05-01",32803992.059999999,"2011-06-15","2011-07-01",11916,11915725.412277514]
["2011-06-01",32930648.399999999,"2011-07-15","2011-08-01",11962,11961732.074100981]
["2011-07-01",32835656.149999999,"2011-08-15","2011-09-01",11927,11927227.079549581]
["2011-08-01",32993976.57,"2011-09-15","2011-10-01",11985,11984735.405012714]
["2011-09-01",32930648.399999999,"2011-10-15","2011-11-01",11962,11961732.074100981]
["2011-10-01",32962312.489999998,"2011-11-15","2011-12-01",11973,11973233.741373047]
["2011-11-01",32930648.399999999,"2011-12-15","2012-01-01",11962,11961732.074100981]
["2011-12-01",32930648.399999999,"2012-01-15","2012-02-01",11962,11961732.074100981]
["2012-01-01",32930648.399999999,"2012-02-15","2012-03-01",11962,11961732.074100981]
["2012-02-01",32930648.399999999,"2012-03-15","2012-04-01",11962,11961732.074100981]
["2012-03-01",33057304.739999998,"2012-04-15","2012-05-01",12008,12007738.735924445]
["2012-04-01",33342281.510000002,"2012-05-15","2012-06-01",12111,12111253.726843443]
["2012-05-01",33342281.510000002,"2012-06-15","2012-07-01",12111,12111253.726843443]
["2012-06-01",33247289.25,"2012-07-15","2012-08-01",12077,{"$f":"B734/2.753","v":12076748.728659643}]
["2012-07-01",33278953.34,"2012-08-15","2012-09-01",{"$f":"ROUND(F735/1000,0)","v":12088},12088250.39593171]
["2012-08-01",33627258.270000003,"2012-09-14","2012-10-01",12215,12214768.71413004]
["2012-09-01",33627258.270000003,"2012-10-15","2012-11-01",12215,12214768.71413004]
["2012-10-01",33563930.100000001,"2012-11-15","2012-12-01",12192,12191765.383218307]
["2012-11-01",33405609.68,"2012-12-15","2013-01-01",12134,12134257.057755176]
["2012-12-01",33468937.850000001,"2013-01-15","2013-02-01",12157,12157260.388666909]
["2013-01-01",33410549.280000001,"2013-02-15","2013-03-01",12136,12136051.318561569]
["2013-02-01",33410549.280000001,"2013-03-15","2013-04-01",12136,12136051.318561569]
["2013-03-01",33477170.510000002,"2013-04-15","2013-05-01",12160,12160250.82092263]
["2013-04-01",33610412.979999997,"2013-05-15","2013-06-01",12209,12208649.82927715]
["2013-05-01",33643723.600000001,"2013-06-14","2013-07-01",12221,12220749.582273884]
["2013-06-01",33910208.539999999,"2013-07-15","2013-08-01",12318,12317547.598982926]
["2013-07-01",34010140.390000001,"2013-08-15","2013-09-01",12354,12353846.854340719]
["2013-08-01",34076761.630000003,"2013-09-14","2013-10-01",12378,12378046.360334182]
["2013-09-01",34076761.630000003,"2013-10-14","2013-11-01",12378,12378046.360334182]
["2013-10-01",34176693.479999997,"2013-11-14","2013-12-01",12414,12414345.615691971]
["2013-11-01",34043451.009999998,"2013-12-15","2014-01-01",12366,12365946.607337449]
["2013-12-01",34076761.630000003,"2014-01-15","2014-02-01",12378,12378046.360334182]
["2014-01-01",33876897.920000002,"2014-02-14","2014-03-01",12305,12305447.845986197]
["2014-02-01",33810276.689999998,"2014-03-14","2014-04-01",12281,12281248.343625136]
["2014-03-01",33910208.539999999,"2014-04-15","2014-05-01",12318,12317547.598982926]
["2014-04-01",33943519.159999996,"2014-05-15","2014-06-01",12330,12329647.351979656]
["2014-05-01",33976829.770000003,"2014-06-15","2014-07-01",12342,12341747.101343989]
["2014-06-01",34076761.630000003,"2014-07-15","2014-08-01",12378,12378046.360334182]
["2014-07-01",34110072.240000002,"2014-08-15","2014-09-01",12390,12390146.109698512]
["2014-08-01",34076761.630000003,"2014-09-15","2014-10-01",12378,12378046.360334182]
["2014-09-01",33976829.770000003,"2014-10-15","2014-11-01",12342,12341747.101343989]
["2014-10-01",34076761.630000003,"2014-11-14","2014-12-01",12378,12378046.360334182]
["2014-11-01",34010140.390000001,"2014-12-15","2015-01-01",12354,12353846.854340719]
["2014-12-01",34010140.390000001,"2015-01-15","2015-02-01",12354,12353846.854340719]
["2015-01-01",33705015.130000003,"2015-02-15","2015-03-01",12243,12243013.123864874]
["2015-02-01",33467177.329999998,"2015-03-15","2015-04-01",12157,12156620.897203051]
["2015-03-01",33569107.82,"2015-04-15","2015-05-01",12194,12193646.138757719]
["2015-04-01",33772968.789999999,"2015-05-14","2015-06-01",12268,12267696.618234653]
["2015-05-01",33840922.450000003,"2015-06-15","2015-07-01",12292,12292380.112604432]
["2015-06-01",33942852.939999998,"2015-07-15","2015-08-01",12329,12329405.354159098]
["2015-07-01",34010806.600000001,"2015-08-14","2015-09-01",12354,12354088.848528877]
["2015-08-01",33942852.939999998,"2015-09-15","2015-10-01",12329,12329405.354159098]
["2015-09-01",33806945.619999997,"2015-10-15","2015-11-01",12280,12280038.365419541]
["2015-10-01",33840922.450000003,"2015-11-15","2015-12-01",12292,12292380.112604432]
["2015-11-01",33705015.130000003,"2015-12-15","2016-01-01",12243,12243013.123864874]
["2015-12-01",33671038.310000002,"2016-01-15","2016-02-01",12231,12230671.380312387]
["2016-01-01",33501154.16,"2016-02-15","2016-03-01",12169,12168962.64438794]
["2016-02-01",33399223.670000002,"2016-03-15","2016-04-01",12132,12131937.402833274]
["2016-03-01",33331270.010000002,"2016-04-15","2016-05-01",12107,12107253.908463495]
["2016-04-01",33467177.329999998,"2016-05-15","2016-06-01",12157,12156620.897203051]
["2016-05-01",33569107.82,"2016-06-15","2016-07-01",12194,12193646.138757719]
["2016-06-01",33671038.310000002,"2016-07-15","2016-08-01",{"$f":"ROUND(F782/1000,0)","v":12231},12230671.380312387]
["2016-07-01",33806945.619999997,"2016-08-15","2016-09-01",{"$f":"ROUND(F783/1000,0)","v":12280},12280038.365419541]
["2016-08-01",33705015.130000003,"2016-09-15","2016-10-01",{"$f":"ROUND(F784/1000,0)","v":12243},12243013.123864874]
["2016-09-01",33671038.310000002,"2016-10-14","2016-11-01",{"$f":"ROUND(F785/1000,0)","v":12231},12230671.380312387]
["2016-10-01",33738991.960000001,"2016-11-15","2016-12-01",{"$f":"ROUND(F786/1000,0)","v":12255},12255354.871049764]
["2016-11-01",33603084.649999999,"2016-12-15","2017-01-01",12206,12205987.885942606]
["2016-12-01",33603084.649999999,"2017-01-15","2017-02-01",12206,12205987.885942606]
["2017-01-01",33535878.48,"2017-02-15","2017-03-01",12182,12181575.909916455]
["2017-02-01",33535878.48,"2017-03-15","2017-04-01",12182,12181575.909916455]
["2017-03-01",33636687.729999997,"2017-04-14","2017-05-01",12218,12218193.872139482]
["2017-04-01",33703893.899999999,"2017-05-15","2017-06-01",12243,12242605.848165637]
["2017-05-01",33838306.240000002,"2017-06-15","2017-07-01",12291,12291429.800217945]
["2017-06-01",33603084.649999999,"2017-07-14","2017-08-01",12206,12205987.885942606]
["2017-07-01",33569481.560000002,"2017-08-15","2017-09-01",12194,12193781.89611333]
["2017-08-01",33670290.810000002,"2017-09-15","2017-10-01",12230,12230399.858336361]
["2017-09-01",33703893.899999999,"2017-10-15","2017-11-01",12243,12242605.848165637]
["2017-10-01",33804703.149999999,"2017-11-15","2017-12-01",12279,{"$f":"B798/2.753","v":12279223.810388666}]
["2017-11-01",33703893.899999999,"2017-12-15","2018-01-01",12243,12242605.848165637]
["2017-12-01",33737496.979999997,"2018-01-15","2018-02-01",12255,12254811.834362512]
["2018-01-01",33569481.560000002,"2018-02-15","2018-03-01",12194,12193781.89611333]
["2018-02-01",33603084.600000001,"2018-03-15","2018-04-01",12206,12205987.867780603]
["2018-03-01",33703893.899999999,"2018-04-15","2018-05-01",12243,12242605.848165637]
["2018-04-01",33838306.200000003,"2018-05-15","2018-06-01",12291,12291429.785688341]
["2018-05-01",34006321.700000003,"2018-06-15","2018-07-01",12352,12352459.752996732]
["2018-06-01",34039924.700000003,"2018-07-15","2018-08-01",12365,12364665.7101344]
["2018-07-01",34039924.700000003,"2018-08-15","2018-09-01",12365,{"$f":"B807/2.753","v":12364665.7101344}]
["2018-08-01",34073527.799999997,"2018-09-14","2018-10-01",12377,{"$f":"B808/2.753","v":12376871.703596076}]
["2018-09-01",34107130.899999999,"2018-10-15","2018-11-01",12389,{"$f":"B809/2.753","v":12389077.697057754}]
["2018-10-01",34207940.169180401,null,"2018-12-01",12426,{"$f":"B810/2.753","v":12425695.666247874}]
["2018-11-01",34107130.9152437,null,"2019-01-01",12389,12389077.702594878]
["2018-12-01",34006321.661307,null,"2019-02-01",12352,12352459.738941882]
["2019-01-01",33973054.607507899,null,"2019-03-01",12340,12340375.810936395]
["2019-02-01",34006993.722999901,null,"2019-04-01",12353,12352703.858699564]
["2019-03-01",34176689.300460003,null,"2019-05-01",12414,12414344.097515438]
["2019-04-01",34278506.646936104,null,"2019-06-01",12451,12451328.240804978]
["2019-05-01",34516080.455380201,null,"2019-07-01",12538,12537624.575147185]
["2019-06-01",34312445.762428097,null,"2019-08-01",12464,12463656.288568143]
["2019-07-01",34210628.415951997,null,"2019-09-01",12427,12426672.145278603]
["2019-08-01",34278506.646936104,null,"2019-10-01",12451,12451328.240804978]
["2019-09-01",34210628.415951997,null,"2019-11-01",12427,12426672.145278603]
["2019-10-01",34346384.877920099,null,"2019-12-01",12476,12475984.33633131]
["2019-11-01",34210628.415951997,null,"2020-01-01",12427,12426672.145278603]
["2019-12-01",34210628.415951997,null,"2020-02-01",12427,12426672.145278603]
["2020-01-01",34074871.953984,null,"2020-03-01",12377,12377359.954225935]
["2020-02-01",34040932.838491902,null,"2020-04-01",12365,12365031.906462731]
["2020-03-01",34176689.300460003,null,"2020-05-01",12414,12414344.097515438]
["2020-04-01",34074871.953984,null,"2020-06-01",12377,12377359.954225935]
["2020-05-01",33973054.607507899,null,"2020-07-01",12340,12340375.810936395]
["2020-06-01",33939115.492015898,null,"2020-08-01",12328,12328047.763173228]
["2020-07-01",34006993.722999901,null,"2020-09-01",12353,12352703.858699564]
["2020-08-01",34006993.722999901,null,"2020-10-01",12353,12352703.858699564]
["2020-09-01",34006993.722999901,null,"2020-11-01",12353,12352703.858699564]
["2020-10-01",34006993.722999901,null,"2020-12-01",12353,12352703.858699564]
["2020-11-01",34006993.722999901,null,"2021-01-01",12353,12352703.858699564]
["2020-12-01",34006993.722999901,null,"2021-02-01",12353,12352703.858699564]
["2021-01-01",34006993.722999901,null,"2021-03-01",12353,12352703.858699564]

{"sheet":"מס על הקיצבה","index":13,"n_rows":37,"n_cols":12,"rows_kept":37,"cut":false,"hidden":true,"merged":[[5,1,5,2],[5,3,5,4],[24,2,24,3],[30,2,30,3],[36,2,36,3]]}
[]
["חישוב מס בשנים שלאחר שנת הפרישה"]
[]
[]
["חישוב מס",null,null,null,null,null,null,null,null,null,"שווי נקודת זיכוי",{"$f":"'נתונים ותקרות'!$B$6","v":218}]
["קיצבה ברוטו","קיצבה+ שכר בפריסה",null,"מס"]
[null,"חודשי","שנתי","מס שנתי","מס חודשי",null,null,null,null,null,"רווק",2.25]
["קיצבה ברוטו בניכוי פטור",{"$f":"IF('חישוב פטור בגיל פרישה'!B27=0,'חישוב פטור בגיל פרישה'!B29,'חישוב פטור בגיל פרישה'!B29-'חישוב פטור בגיל פרישה'!B27)","v":8815.5666666666657},{"$f":"12*B8","v":105786.79999999999},{"$f":"E8*12","v":5904.9519999999993},{"$f":"E25","v":492.07933333333324},null,null,null,null,null,"נשוי ללא ילדים",{"$f":"L7","v":2.25}]
["קיצבה ברוטו + פריסת מס פיצויים",{"$f":"'חישוב פטור בגיל פרישה'!E13/12+'מס על הקיצבה'!B8","v":15519.587975646878},{"$f":"12*B9","v":186235.05570776254},{"$f":"E9*12","v":23199.267269406384},{"$f":"E31","v":1933.272272450532},null,null,null,null,null,"אלמן/גרוש ללא ילדים",{"$f":"L8","v":2.25}]
["קיצבה ברוטו + פריסת מס פיצויים ופריסת מס היוון",{"$f":"'חישוב פטור בגיל פרישה'!E27/12+B9","v":15519.587975646878},186235.05570776254,23199.267269406384,{"$f":"E37","v":1933.272272450532},null,null,null,null,null,"נשוי בן 70 ומעלה שבת זוגו אינה עובדת",3.25]
[null,null,null,null,null,null,null,null,null,null,"נשואה בת 70 ומעלה שבן זוגה אינו עובד",3.75]
[null,null,null,null,null,null,null,null,null,null,"רווקה",3.25]
[null,"שיעור מס","הכנסה חודשית","סכום במדרגה","סכום מצטבר",null,null,null,null,null,"נשואה ללא ילדים",3.25]
[1,0.1,{"$f":"'נתונים ותקרות'!B17","v":0},0,0,null,null,null,null,null,"אלמנה/גרושה ללא ילדים",3.25]
[2,0.14000000000000001,{"$f":"'נתונים ותקרות'!B18","v":6290},{"$f":"B14*C15","v":629},{"$f":"E14+D15","v":629},null,null,null,null,null,"גבר הורה יחיד ולו ילד בוגר בחזקתו",4.25]
[3,0.2,{"$f":"'נתונים ותקרות'!B19","v":9030},{"$f":"(C16-C15)*B15","v":383.6},{"$f":"E15+D16","v":1012.6},null,null,null,null,null,"אב החי הנפרד ולו יילוד או ילד בוגר בחזקתו",4.25]
[4,0.31,{"$f":"'נתונים ותקרות'!B20","v":14490},{"$f":"(C17-C16)*B16","v":1092},{"$f":"E16+D17","v":2104.6},null,null,null,null,null,"נערה בגיל 16-18",4.25]
[5,0.35,{"$f":"'נתונים ותקרות'!B21","v":20140},1751.5,3856.1,null,null,null,null,null,"אשה נשואה ולה ילד בגיל 6-17",4.25]
[6,0.47,{"$f":"'נתונים ותקרות'!B22","v":41910},7619.4999999999991,11475.599999999999,null,null,null,null,null,"אשה נשואה ולה ילד בשנה שלאחר לידתו ועד השנה בה מלאו לו 5",4.75]
[7,0.5,{"$f":"'נתונים ותקרות'!B23","v":53970},5668.2,17143.8,null,null,null,null,null,"גבר הורה יחיד ולו יילוד בחזקתו",4.75]
[null,null,null,null,null,null,null,null,null,null,"אשה הורה יחיד ולה יילוד בחזקתה",5.25]
["הכנסה",null,"מס מצטבר עד המדרגה הקודמת","מס במדרגה","מס מחושב לפני נקודות זיכוי",null,null,null,null,null,"גבר הורה יחיד ולו ילד אחד, בגיל 4 או 5, בחזקתו",5.25]
[{"$f":"IF(B8<0,0,B8)","v":8815.5666666666657},null,{"$f":"SUMIF(C14:C20,\"<\"&A23,D14:D20)","v":629},{"$f":"(A23-LOOKUP(A23,C14:C20))*LOOKUP(A23,C14:C20,B14:B20)","v":353.57933333333324},{"$f":"D23+C23","v":982.57933333333324},"קיצבה",null,null,null,null,"גבר החי בנפרד ומשלם מזונות בגין פעוט, בשנה שלאחר שנת הלידה ובשנה שבה מלאו לו שנתיים שאיננו בחזקתו",5.25]
["מספר נקודות זיכוי",{"$f":"'חישוב פטור בגיל פרישה'!J21","v":2.25},null,null,{"$f":"B24*$L$5*-1","v":-490.5},null,null,null,null,null,"אב החי בנפרד ולו ילד אחד בגיל שנה עד גיל 5 בחזקתו",5.25]
[null,null,"סה\"כ מס",null,{"$f":"IF((E23+E24)>0,E23+E24,0)","v":492.07933333333324},null,null,null,null,null,"אשה הורה יחיד ולה ילד אחד בגיל 4 או 5 בחזקתה",5.75]
[null,null,null,null,null,null,null,null,null,null,"אשה החיה בנפרד ולה ילד אחד בגיל שנה עד גיל 5 בחזקתה",5.75]
[null,null,null,null,null,null,null,null,null,null,"אשה החיה בנפרד ומשלמת מזונות בגין פעוט, בשנה שלאחר שנת הלידה ובשנה שבה מלאו לו שנתיים, שלא בחזקתה",5.75]
["הכנסה",null,"מס מצטבר עד המדרגה הקודמת","מס במדרגה","מס מחושב לפני נקודות זיכוי"]
[{"$f":"B9","v":15519.587975646878},null,{"$f":"SUMIF(C14:C20,\"<\"&A29,D14:D20)","v":2104.6},{"$f":"(A29-LOOKUP(A29,C14:C20))*LOOKUP(A29,C14:C20,B14:B20)","v":319.17227245053232},{"$f":"D29+C29","v":2423.772272450532},"קיצבה + פריסת מס פיצויים"]
["מספר נקודות זיכוי",{"$f":"B24","v":2.25},null,null,{"$f":"B30*$L$5*-1","v":-490.5}]
[null,null,"סה\"כ מס",null,{"$f":"IF((E29+E30)>0,E29+E30,0)","v":1933.272272450532}]
[]
[]
["הכנסה",null,"מס מצטבר עד המדרגה הקודמת","מס במדרגה","מס מחושב לפני נקודות זיכוי"]
[{"$f":"B10","v":15519.587975646878},null,{"$f":"SUMIF(C14:C20,\"<\"&A35,D14:D20)","v":2104.6},{"$f":"(A35-LOOKUP(A35,C14:C20))*LOOKUP(A35,C14:C20,B14:B20)","v":319.17227245053232},{"$f":"D35+C35","v":2423.772272450532},"קיצבה +פריסת מס פיצויים + פריסת מס היוון"]
["מספר נקודות זיכוי",{"$f":"B30","v":2.25},null,null,{"$f":"B36*$L$5*-1","v":-490.5}]
[null,null,"סה\"כ מס",null,{"$f":"IF((E35+E36)>0,E35+E36,0)","v":1933.272272450532}]

{"sheet":"מס על הקיצבה 2","index":14,"n_rows":27,"n_cols":12,"rows_kept":27,"cut":false,"hidden":true,"merged":[[5,1,5,2],[5,3,5,4],[24,2,24,3]]}
[]
[]
[]
[]
["חישוב מס בשנת הפרישה",null,null,null,null,null,null,null,null,null,"שווי נקודת זיכוי",{"$f":"'נתונים ותקרות'!$B$6","v":218}]
["קיצבה ברוטו","קיצבה+ שכר בפריסה",null,"מס"]
[null,"חודשי","שנתי","מס שנתי","מס חודשי",null,null,null,null,null,"רווק",2.25]
["קיצבה ברוטו בניכוי פטור + שכר בשנת הפרישה",{"$f":"A23","v":21166.666666666668},{"$f":"12*B8","v":254000},{"$f":"E8*12","v":44699.199999999997},{"$f":"E25","v":3724.9333333333334},null,null,null,null,null,"נשוי ללא ילדים",{"$f":"L7","v":2.25}]
["קיצבה ברוטו + פריסת מס פיצויים",{"$f":"B8+'חישוב פטור בגיל פרישה'!E13/12","v":27870.687975646881},{"$f":"12*B9","v":334448.25570776255},{"$f":"E9*12","v":78742.089497716894},{"$f":"IF(A23=0,'מס על הקיצבה+פיצויים'!E19,'מס על הקיצבה+פיצויים'!E19-'מס על הקיצבה 2'!E24)","v":6561.8407914764084},null,null,null,null,null,"אלמן/גרוש ללא ילדים",{"$f":"L8","v":2.25}]
["קיצבה ברוטו + פריסת מס פיצויים ופריסת מס היוון",{"$f":"B9+'חישוב פטור בגיל פרישה'!E27/12","v":27870.687975646881},{"$f":"12*B10","v":334448.25570776255},78742.089497716894,{"$f":"IF(AND(A23=0,'מס על הקיצבה+פיצויים'!A17=0),'מס על הקיצבה+פיצויים+היוון'!E19,'מס על הקיצבה+פיצויים+היוון'!E17)","v":6561.8407914764084},null,null,null,null,null,"נשוי בן 70 ומעלה שבת זוגו אינה עובדת",3.25]
[null,null,null,null,null,null,null,null,null,null,"נשואה בת 70 ומעלה שבן זוגה אינו עובד",3.75]
[null,null,null,null,null,null,null,null,null,null,"רווקה",3.25]
[null,"שיעור מס","הכנסה חודשית","סכום במדרגה","סכום מצטבר",null,null,null,null,null,"נשואה ללא ילדים",3.25]
[1,0.1,{"$f":"'נתונים ותקרות'!B17","v":0},0,0,null,null,null,null,null,"אלמנה/גרושה ללא ילדים",3.25]
[2,0.14000000000000001,{"$f":"'נתונים ותקרות'!B18","v":6290},{"$f":"B14*C15","v":629},{"$f":"E14+D15","v":629},null,null,null,null,null,"גבר הורה יחיד ולו ילד בוגר בחזקתו",4.25]
[3,0.2,{"$f":"'נתונים ותקרות'!B19","v":9030},{"$f":"(C16-C15)*B15","v":383.6},{"$f":"E15+D16","v":1012.6},null,null,null,null,null,"אב החי הנפרד ולו יילוד או ילד בוגר בחזקתו",4.25]
[4,0.31,{"$f":"'נתונים ותקרות'!B20","v":14490},{"$f":"(C17-C16)*B16","v":1092},{"$f":"E16+D17","v":2104.6},null,null,null,null,null,"נערה בגיל 16-18",4.25]
[5,0.35,{"$f":"'נתונים ותקרות'!B21","v":20140},1751.5,3856.1,null,null,null,null,null,"אשה נשואה ולה ילד בגיל 6-17",4.25]
[6,0.47,{"$f":"'נתונים ותקרות'!B22","v":41910},7619.4999999999991,11475.599999999999,null,null,null,null,null,"אשה נשואה ולה ילד בשנה שלאחר לידתו ועד השנה בה מלאו לו 5",4.75]
[7,0.5,{"$f":"'נתונים ותקרות'!B23","v":53970},5668.2,17143.8,null,null,null,null,null,"גבר הורה יחיד ולו יילוד בחזקתו",4.75]
[null,null,null,null,null,null,null,null,null,null,"אשה הורה יחיד ולה יילוד בחזקתה",5.25]
["הכנסה",null,"מס מצטבר עד המדרגה הקודמת","מס במדרגה","מס מחושב לפני נקודות זיכוי",null,null,null,null,null,"גבר הורה יחיד ולו ילד אחד, בגיל 4 או 5, בחזקתו",5.25]
[{"$f":"IF('חישוב פטור בגיל פרישה'!C29=0,'חישוב פטור בגיל פרישה'!J19/12,(('חישוב פטור בגיל פרישה'!C29-'חישוב פטור בגיל פרישה'!$B$27)*(13-'חישוב פטור בגיל פרישה'!E5)+'חישוב פטור בגיל פרישה'!J19)/12)","v":21166.666666666668},null,{"$f":"SUMIF(C14:C20,\"<\"&A23,D14:D20)","v":3856.1},{"$f":"(A23-LOOKUP(A23,C14:C20))*LOOKUP(A23,C14:C20,B14:B20)","v":359.33333333333371},{"$f":"D23+C23","v":4215.4333333333334},null,null,null,null,null,"גבר החי בנפרד ומשלם מזונות בגין פעוט, בשנה שלאחר שנת הלידה ובשנה שבה מלאו לו שנתיים שאיננו בחזקתו",5.25]
["מספר נקודות זיכוי",{"$f":"'חישוב פטור בגיל פרישה'!J21","v":2.25},null,null,{"$f":"B24*$L$5*-1","v":-490.5},null,null,null,null,null,"אב החי בנפרד ולו ילד אחד בגיל שנה עד גיל 5 בחזקתו",5.25]
[null,null,"סה\"כ מס",null,{"$f":"IF((E23+E24)>0,E23+E24,0)","v":3724.9333333333334},null,null,null,null,null,"אשה הורה יחיד ולה ילד אחד בגיל 4 או 5 בחזקתה",5.75]
[null,null,null,null,null,null,null,null,null,null,"אשה החיה בנפרד ולה ילד אחד בגיל שנה עד גיל 5 בחזקתה",5.75]
[null,null,null,null,null,null,null,null,null,null,"אשה החיה בנפרד ומשלמת מזונות בגין פעוט, בשנה שלאחר שנת הלידה ובשנה שבה מלאו לו שנתיים, שלא בחזקתה",5.75]

{"sheet":"מס על הקיצבה+פיצויים","index":15,"n_rows":27,"n_cols":12,"rows_kept":27,"cut":false,"hidden":true,"merged":[[18,2,18,3]]}
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"שווי נקודת זיכוי",{"$f":"'נתונים ותקרות'!$B$6","v":218}]
[]
[null,"שיעור מס","הכנסה חודשית","סכום במדרגה","סכום מצטבר",null,null,null,null,null,"רווק",2.25]
[1,0.1,{"$f":"'נתונים ותקרות'!B17","v":0},0,0,null,null,null,null,null,"נשוי ללא ילדים",{"$f":"L7","v":2.25}]
[2,0.14000000000000001,{"$f":"'נתונים ותקרות'!B18","v":6290},{"$f":"B8*C9","v":629},{"$f":"E8+D9","v":629},null,null,null,null,null,"אלמן/גרוש ללא ילדים",{"$f":"L8","v":2.25}]
[3,0.2,{"$f":"'נתונים ותקרות'!B19","v":9030},{"$f":"(C10-C9)*B9","v":383.6},{"$f":"E9+D10","v":1012.6},null,null,null,null,null,"נשוי בן 70 ומעלה שבת זוגו אינה עובדת",3.25]
[4,0.31,{"$f":"'נתונים ותקרות'!B20","v":14490},{"$f":"(C11-C10)*B10","v":1092},{"$f":"E10+D11","v":2104.6},null,null,null,null,null,"נשואה בת 70 ומעלה שבן זוגה אינו עובד",3.75]
[5,0.35,{"$f":"'נתונים ותקרות'!B21","v":20140},1751.5,3856.1,null,null,null,null,null,"רווקה",3.25]
[6,0.47,{"$f":"'נתונים ותקרות'!B22","v":41910},7619.4999999999991,11475.599999999999,null,null,null,null,null,"נשואה ללא ילדים",3.25]
[7,0.5,{"$f":"'נתונים ותקרות'!B23","v":53970},5668.2,17143.8,null,null,null,null,null,"אלמנה/גרושה ללא ילדים",3.25]
[null,null,null,null,null,null,null,null,null,null,"גבר הורה יחיד ולו ילד בוגר בחזקתו",4.25]
["הכנסה",null,"מס מצטבר עד המדרגה הקודמת","מס במדרגה","מס מחושב לפני נקודות זיכוי",null,null,null,null,null,"אב החי הנפרד ולו יילוד או ילד בוגר בחזקתו",4.25]
[{"$f":"'מס על הקיצבה 2'!B9","v":27870.687975646881},null,{"$f":"SUMIF(C8:C14,\"<\"&A17,D8:D14)","v":3856.1},{"$f":"(A17-LOOKUP(A17,C8:C14))*LOOKUP(A17,C8:C14,B8:B14)","v":2705.740791476408},{"$f":"D17+C17","v":6561.8407914764084},null,null,null,null,null,"נערה בגיל 16-18",4.25]
["מספר נקודות זיכוי",{"$f":"'חישוב פטור בגיל פרישה'!J21","v":2.25},null,null,{"$f":"B18*$L$5*-1","v":-490.5},null,null,null,null,null,"אשה נשואה ולה ילד בגיל 6-17",4.25]
[null,null,"סה\"כ מס",null,{"$f":"IF((E17+E18)>0,E17+E18,0)","v":6071.3407914764084},null,null,null,null,null,"אשה נשואה ולה ילד בשנה שלאחר לידתו ועד השנה בה מלאו לו 5",4.75]
[null,null,null,null,null,null,null,null,null,null,"גבר הורה יחיד ולו יילוד בחזקתו",4.75]
[null,null,null,null,null,null,null,null,null,null,"אשה הורה יחיד ולה יילוד בחזקתה",5.25]
[null,null,null,{"$f":"'מס על הקיצבה 2'!B9","v":27870.687975646881},null,null,null,null,null,null,"גבר הורה יחיד ולו ילד אחד, בגיל 4 או 5, בחזקתו",5.25]
[null,null,null,null,null,null,null,null,null,null,"גבר החי בנפרד ומשלם מזונות בגין פעוט, בשנה שלאחר שנת הלידה ובשנה שבה מלאו לו שנתיים שאיננו בחזקתו",5.25]
[null,null,null,null,null,null,null,null,null,null,"אב החי בנפרד ולו ילד אחד בגיל שנה עד גיל 5 בחזקתו",5.25]
[null,null,null,null,null,null,null,null,null,null,"אשה הורה יחיד ולה ילד אחד בגיל 4 או 5 בחזקתה",5.75]
[null,null,null,null,null,null,null,null,null,null,"אשה החיה בנפרד ולה ילד אחד בגיל שנה עד גיל 5 בחזקתה",5.75]
[null,null,null,null,null,null,null,null,null,null,"אשה החיה בנפרד ומשלמת מזונות בגין פעוט, בשנה שלאחר שנת הלידה ובשנה שבה מלאו לו שנתיים, שלא בחזקתה",5.75]

{"sheet":"מס על הקיצבה+פיצויים+היוון","index":16,"n_rows":27,"n_cols":12,"rows_kept":27,"cut":false,"hidden":true,"merged":[[18,2,18,3]]}
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"שווי נקודת זיכוי",{"$f":"'נתונים ותקרות'!$B$6","v":218}]
[]
[null,"שיעור מס","הכנסה חודשית","סכום במדרגה","סכום מצטבר",null,null,null,null,null,"רווק",2.25]
[1,0.1,{"$f":"'נתונים ותקרות'!B17","v":0},0,0,null,null,null,null,null,"נשוי ללא ילדים",{"$f":"L7","v":2.25}]
[2,0.14000000000000001,{"$f":"'נתונים ותקרות'!B18","v":6290},{"$f":"B8*C9","v":629},{"$f":"E8+D9","v":629},null,null,null,null,null,"אלמן/גרוש ללא ילדים",{"$f":"L8","v":2.25}]
[3,0.2,{"$f":"'נתונים ותקרות'!B19","v":9030},{"$f":"(C10-C9)*B9","v":383.6},{"$f":"E9+D10","v":1012.6},null,null,null,null,null,"נשוי בן 70 ומעלה שבת זוגו אינה עובדת",3.25]
[4,0.31,{"$f":"'נתונים ותקרות'!B20","v":14490},{"$f":"(C11-C10)*B10","v":1092},{"$f":"E10+D11","v":2104.6},null,null,null,null,null,"נשואה בת 70 ומעלה שבן זוגה אינו עובד",3.75]
[5,0.35,{"$f":"'נתונים ותקרות'!B21","v":20140},1751.5,3856.1,null,null,null,null,null,"רווקה",3.25]
[6,0.47,{"$f":"'נתונים ותקרות'!B22","v":41910},7619.4999999999991,11475.599999999999,null,null,null,null,null,"נשואה ללא ילדים",3.25]
[7,0.5,{"$f":"'נתונים ותקרות'!B23","v":53970},5668.2,17143.8,null,null,null,null,null,"אלמנה/גרושה ללא ילדים",3.25]
[null,null,null,null,null,null,null,null,null,null,"גבר הורה יחיד ולו ילד בוגר בחזקתו",4.25]
["הכנסה",null,"מס מצטבר עד המדרגה הקודמת","מס במדרגה","מס מחושב לפני נקודות זיכוי",null,null,null,null,null,"אב החי הנפרד ולו יילוד או ילד בוגר בחזקתו",4.25]
[{"$f":"'מס על הקיצבה 2'!B10","v":27870.687975646881},null,{"$f":"SUMIF(C8:C14,\"<\"&A17,D8:D14)","v":3856.1},{"$f":"(A17-LOOKUP(A17,C8:C14))*LOOKUP(A17,C8:C14,B8:B14)","v":2705.740791476408},{"$f":"D17+C17","v":6561.8407914764084},null,null,null,null,null,"נערה בגיל 16-18",4.25]
["מספר נקודות זיכוי",{"$f":"'חישוב פטור בגיל פרישה'!J21","v":2.25},null,null,{"$f":"B18*$L$5*-1","v":-490.5},null,null,null,null,null,"אשה נשואה ולה ילד בגיל 6-17",4.25]
[null,null,"סה\"כ מס",null,{"$f":"IF((E17+E18)>0,E17+E18,0)","v":6071.3407914764084},null,null,null,null,null,"אשה נשואה ולה ילד בשנה שלאחר לידתו ועד השנה בה מלאו לו 5",4.75]
[null,null,null,null,null,null,null,null,null,null,"גבר הורה יחיד ולו יילוד בחזקתו",4.75]
[null,null,null,null,null,null,null,null,null,null,"אשה הורה יחיד ולה יילוד בחזקתה",5.25]
[null,null,null,null,null,null,null,null,null,null,"גבר הורה יחיד ולו ילד אחד, בגיל 4 או 5, בחזקתו",5.25]
[null,null,null,null,null,null,null,null,null,null,"גבר החי בנפרד ומשלם מזונות בגין פעוט, בשנה שלאחר שנת הלידה ובשנה שבה מלאו לו שנתיים שאיננו בחזקתו",5.25]
[null,null,null,null,null,null,null,null,null,null,"אב החי בנפרד ולו ילד אחד בגיל שנה עד גיל 5 בחזקתו",5.25]
[null,null,null,null,null,null,null,null,null,null,"אשה הורה יחיד ולה ילד אחד בגיל 4 או 5 בחזקתה",5.75]
[null,null,null,null,null,null,null,null,null,null,"אשה החיה בנפרד ולה ילד אחד בגיל שנה עד גיל 5 בחזקתה",5.75]
[null,null,null,null,null,null,null,null,null,null,"אשה החיה בנפרד ומשלמת מזונות בגין פעוט, בשנה שלאחר שנת הלידה ובשנה שבה מלאו לו שנתיים, שלא בחזקתה",5.75]