{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["רשימת פעולות לביצוע לפרוייקט 1","הגדרות וחישובים"],"not_rendered":{"defined_names":6},"read":"whole","date_system":"1900"}

{"sheet":"רשימת פעולות לביצוע לפרוייקט 1","index":0,"n_rows":18,"n_cols":8,"rows_kept":18,"merged":[[7,1,7,2]]}
[{"$nulls":7}," "]
[{"$nulls":7}," "]
[null,"רשימת פעולות לביצוע לפרוייקט"]
[]
[null,"תושלם על-ידי:",null,null,"תאריך יעד:",null,"פעילויות מרכזיות"]
[null,"טלי רוט",null,null,{"$f":"TODAY()+95","v":"2013-01-01"},null,"ללא פריט מרכזי"]
[]
[null,"פרוייקט 1"]
[null,"פעילות","להגשה עד","תקציב","אחוז ביצוע","התקדמות","הערות"," "]
[null,"תכנון",{"$f":"TODAY()-90","v":"2012-06-30"},{"v":476,"d":"₪476.00"},{"v":0.25,"d":"25%"},{"$f":"tblToDoList[[#This Row],[אחוז ביצוע]]","v":{"v":0.25,"d":"25%"}}]
[null,"הכנות",{"$f":"TODAY()-2","v":"2012-09-26"},{"v":301,"d":"₪301.00"},{"v":0.1,"d":"10%"},{"$f":"tblToDoList[[#This Row],[אחוז ביצוע]]","v":{"v":0.1,"d":"10%"}}]
[null,"משימה א'",{"$f":"TODAY()-7","v":"2012-09-21"},{"v":429,"d":"₪429.00"},{"v":0,"d":"0%"},{"$f":"tblToDoList[[#This Row],[אחוז ביצוע]]","v":{"v":0,"d":"0%"}}]
[null,"משימה ב'",{"$f":"TODAY()+20","v":"2012-10-18"},{"v":332,"d":"₪332.00"},{"v":0.7,"d":"70%"},{"$f":"tblToDoList[[#This Row],[אחוז ביצוע]]","v":{"v":0.7,"d":"70%"}}]
[null,"משימה ג'",{"$f":"TODAY()+40","v":"2012-11-07"},{"v":471,"d":"₪471.00"},{"v":0.1,"d":"10%"},{"$f":"tblToDoList[[#This Row],[אחוז ביצוע]]","v":{"v":0.1,"d":"10%"}}]
[null,"משימה ד'",{"$f":"TODAY()+45","v":"2012-11-12"},{"v":418,"d":"₪418.00"},{"v":1,"d":"100%"},{"$f":"tblToDoList[[#This Row],[אחוז ביצוע]]","v":{"v":1,"d":"100%"}}]
[null,"ניירת",{"$f":"TODAY()+55","v":"2012-11-22"},{"v":150,"d":"₪150.00"},{"v":0,"d":"0%"},{"$f":"tblToDoList[[#This Row],[אחוז ביצוע]]","v":{"v":0,"d":"0%"}},"התחלה לאחר סיום משימה ב'"]
[null,"מסירה",{"$f":"TODAY()+70","v":"2012-12-07"},{"v":330,"d":"₪330.00"},{"v":0.25,"d":"25%"},{"$f":"tblToDoList[[#This Row],[אחוז ביצוע]]","v":{"v":0.25,"d":"25%"}}]
[null,"מעקב",{"$f":"TODAY()+90","v":"2012-12-27"},{"v":353,"d":"₪353.00"},{"v":0.5,"d":"50%"},{"$f":"tblToDoList[[#This Row],[אחוז ביצוע]]","v":{"v":0.5,"d":"50%"}}]

{"sheet":"הגדרות וחישובים","index":1,"n_rows":19,"n_cols":6,"rows_kept":19,"merged":[[3,1,3,4]]}
[]
[{"$nulls":5}," "]
[null,"הגדרות פריטים מרכזיים"]
[null,"הטבלאות שלהלן מאחסנות הגדרות וחישובים עבור הרשימה הנפתחת 'פעילויות מרכזיות'.\n כל שינוי עלול להוביל לשגיאה או אבדן פונקציונליות."]
[null,"ללא פריט מרכזי",null,null,{"$f":"B5","v":"ללא פריט מרכזי"}]
[null,"מרווח זמן:","התחלה:","סיום:","תאריך הגשה:"]
[null,"     השבוע",{"$f":"TODAY()-WEEKDAY(TODAY(),2)+1","v":"2012-09-24"},{"$f":"C7+6","v":"2012-09-30"},{"$f":"B7&\" [\"&TEXT(C7,\"d mmm\")&\" - \"&TEXT(D7,\"d mmm\")&\"]\"","v":"     השבוע [24 ספט - 30 ספט]"}]
[null,"     החודש",{"$f":"EOMONTH(TODAY(),-1)+1","v":"2012-09-01"},{"$f":"EDATE(C8,1)-1","v":"2012-09-30"},{"$f":"B8&\" [\"&TEXT(C8,\"d\")&\" - \"&TEXT(D8,\"d, mmm\")&\"]\"","v":"     החודש [1 - 30, ספט]"}]
[null,"     ברבעון זה",{"$f":"DATE(YEAR(TODAY()),INT(MONTH(TODAY())/3)+1,1)","v":"2012-04-01"},{"$f":"EDATE(C9,4)-1","v":"2012-07-31"},{"$f":"B9&\" [\"&TEXT(C9,\"d mmm\")&\" - \"&TEXT(D9,\"d mmm\")&\"]\"","v":"     ברבעון זה [1 אפר - 31 יול]"}]
[null,"     השנה",{"$f":"DATE(YEAR(TODAY()),1,1)","v":"2012-01-01"},{"$f":"EDATE(C10,12)-1","v":"2012-12-31"},{"$f":"B10&\" [\"&TEXT(C10,\"yyyy\")&\"]\"","v":"     השנה [2012]"}]
[null,"מרווח זמן:",null,null,{"$f":"B11","v":"מרווח זמן:"}]
[null,"     בשבוע שעבר",{"$f":"C7-7","v":"2012-09-17"},{"$f":"C12+6","v":"2012-09-23"},{"$f":"B12&\" [\"&TEXT(C12,\"d mmm\")&\" - \"&TEXT(D12,\"d mmm\")&\"]\"","v":"     בשבוע שעבר [17 ספט - 23 ספט]"}]
[null,"     בחודש שעבר",{"$f":"EDATE(C8,-1)","v":"2012-08-01"},{"$f":"EDATE(C13,1)-1","v":"2012-08-31"},{"$f":"B13&\" [\"&TEXT(C13,\"d\")&\" - \"&TEXT(D13,\"d, mmm\")&\"]\"","v":"     בחודש שעבר [1 - 31, אוג]"}]
[null,"     ברבעון שעבר",{"$f":"EDATE(C9,-3)","v":"2012-01-01"},{"$f":"EDATE(C14,3)-1","v":"2012-03-31"},{"$f":"B14&\" [\"&TEXT(C14,\"d mmm\")&\" - \"&TEXT(D14,\"d mmm\")&\"]\"","v":"     ברבעון שעבר [1 ינו - 31 מרץ]"}]
[null,"     בשנה שעברה",{"$f":"EDATE(C10,-12)","v":"2011-01-01"},{"$f":"EDATE(C15,12)-1","v":"2011-12-31"},{"$f":"B15","v":"     בשנה שעברה"}]
[]
[null,"פריט מרכזי נבחר:",{"$f":"IFERROR(MATCH(HighlightActivities,lstToDoHighlights,0),\"\")-1","v":0},{"$f":"HighlightActivities","v":"ללא פריט מרכזי"},{"$f":"ISNUMBER(INDEX($C$6:$C$15,C17))","v":false}]
[null,"התחלת פריטים מרכזיים",{"$f":"IFERROR(IF(C17=1,\"\",IF(E17,INDEX($C$6:$C$15,$C$17),\"\")),\"\")","v":""}]
[null,"סיום פריטים מרכזיים",{"$f":"IFERROR(IF(C17=1,\"\",IF(E17,INDEX($D$6:$D$15,$C$17),\"\")),\"\")","v":""}]