{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["ציר זמן של פרוייקט","calcs"],"not_rendered":{"charts":1,"defined_names":9},"read":"whole","date_system":"1900"}

{"sheet":"ציר זמן של פרוייקט","index":0,"n_rows":16,"n_cols":6,"rows_kept":16,"merged":[[0,2,0,6],[1,2,1,6]]}
[null,null,"ציר זמן של פרוייקט"]
[null,null,"תרשים המציג פעילויות פרוייקט עם ציר זמן הניתן לגלילה מופיע בתא זה."]
[null,null,"הזן תאריך התחלה: ",{"$f":"TODAY()","v":"2019-08-20"}]
[null,"מזהה","פעילות","התחלה","סיום","הערות"]
[null,{"$f":"ROW(B5)-calcs!$D$5","v":-7},"תחילת הפרוייקט",{"$f":"$D$3+3","v":"2019-08-23"}]
[null,{"$f":"ROW(B6)-calcs!$D$5","v":-6},"אבן דרך 1",{"$f":"D5+10","v":"2019-09-02"},{"$f":"פעילויות[[#This Row],[התחלה]]+3","v":"2019-09-05"}]
[null,{"$f":"ROW(B7)-calcs!$D$5","v":-5},"אבן דרך 2",{"$f":"D6+1","v":"2019-09-03"},{"$f":"פעילויות[[#This Row],[התחלה]]+3","v":"2019-09-06"}]
[null,{"$f":"ROW(B8)-calcs!$D$5","v":-4},"אבן דרך 3",{"$f":"D7+5","v":"2019-09-08"}]
[null,{"$f":"ROW(B9)-calcs!$D$5","v":-3},"אבן דרך 4",{"$f":"D8+10","v":"2019-09-18"},{"$f":"פעילויות[[#This Row],[התחלה]]+2","v":"2019-09-20"}]
[null,{"$f":"ROW(B10)-calcs!$D$5","v":-2},"אבן דרך 5","2019-09-28",{"$f":"פעילויות[[#This Row],[התחלה]]+2","v":"2019-09-30"}]
[null,{"$f":"ROW(B11)-calcs!$D$5","v":-1},"אבן דרך 6",{"$f":"D10+10","v":"2019-10-08"},{"$f":"פעילויות[[#This Row],[התחלה]]+2","v":"2019-10-10"}]
[null,{"$f":"ROW(B12)-calcs!$D$5","v":0},"אבן דרך 7","2019-10-18"]
[null,{"$f":"ROW(B13)-calcs!$D$5","v":1},"אבן דרך 8",{"$f":"D12+10","v":"2019-10-28"},{"$f":"פעילויות[[#This Row],[התחלה]]+2","v":"2019-10-30"}]
[null,{"$f":"ROW(B14)-calcs!$D$5","v":2},"אבן דרך 9","2019-11-07",{"$f":"פעילויות[[#This Row],[התחלה]]+2","v":"2019-11-09"}]
[null,{"$f":"ROW(B15)-calcs!$D$5","v":3},"אבן דרך 10","2019-11-17",{"$f":"פעילויות[[#This Row],[התחלה]]+2","v":"2019-11-19"}]
[null,{"$f":"ROW(B16)-calcs!$D$5","v":4},"סיום הפרוייקט",{"$f":"D15+10","v":"2019-11-27"}]

{"sheet":"calcs","index":1,"n_rows":72,"n_cols":35,"rows_kept":72,"hidden":true}
["*** גיליון זה צריך להישאר מוסתר ***"]
[]
[null,null,"היום:",{"$f":"TODAY()","v":"2019-08-20"}]
[{"$nulls":3},5]
[null,null,"מספר שורות",{"$f":"ROWS(פעילויות[])","v":12}]
[{"$nulls":4},{"$f":"NA()","v":{"$error":"#N/A"}}]
[{"$nulls":4},{"$f":"NA()","v":{"$error":"#N/A"}}]
[{"$nulls":4},{"$f":"NA()","v":{"$error":"#N/A"}}]
[null,null,"פעילויות חלון:",{"$f":"SUMPRODUCT( ((פעילויות[התחלה]>=StartDateWindow)+(פעילויות[סיום]>=StartDateWindow)>0)*(פעילויות[התחלה]<=(StartDateWindow+WindowDays-1)) )","v":5},{"$f":"NA()","v":{"$error":"#N/A"}}]
[{"$nulls":3},9,{"$f":"NA()","v":{"$error":"#N/A"}}]
[{"$nulls":3},{"$f":"D10-MIN(D10,D9)","v":4},{"$f":"NA()","v":{"$error":"#N/A"}}]
[{"$nulls":4},{"$f":"NA()","v":{"$error":"#N/A"}}]
[{"$nulls":4},{"$f":"NA()","v":{"$error":"#N/A"}}]
[{"$nulls":4},{"$f":"NA()","v":{"$error":"#N/A"}}]
[{"$nulls":4},{"$f":"INDEX(פעילויות[מזהה],MATCH(1, ((פעילויות[התחלה]>=StartDateWindow)+(פעילויות[סיום]>=StartDateWindow)>0)*(פעילויות[התחלה]<=(StartDateWindow+WindowDays-1)), 0))","v":-7},{"$f":"OFFSET(E15,-$D$11,)","v":{"$error":"#N/A"}}]
[{"$nulls":4},{"$f":"INDEX(פעילויות[מזהה],MATCH(1, (פעילויות[מזהה]>E15)*((פעילויות[התחלה]>=StartDateWindow)+(פעילויות[סיום]>=StartDateWindow)>0)*(פעילויות[התחלה]<=(StartDateWindow+WindowDays-1)), 0))","v":-6},{"$error":"#N/A"}]
[{"$nulls":4},{"$f":"INDEX(פעילויות[מזהה],MATCH(1, (פעילויות[מזהה]>E16)*((פעילויות[התחלה]>=StartDateWindow)+(פעילויות[סיום]>=StartDateWindow)>0)*(פעילויות[התחלה]<=(StartDateWindow+WindowDays-1)), 0))","v":-5},{"$error":"#N/A"}]
[{"$nulls":4},{"$f":"INDEX(פעילויות[מזהה],MATCH(1, (פעילויות[מזהה]>E17)*((פעילויות[התחלה]>=StartDateWindow)+(פעילויות[סיום]>=StartDateWindow)>0)*(פעילויות[התחלה]<=(StartDateWindow+WindowDays-1)), 0))","v":-4},{"$error":"#N/A"}]
[{"$nulls":4},{"$f":"INDEX(פעילויות[מזהה],MATCH(1, (פעילויות[מזהה]>E18)*((פעילויות[התחלה]>=StartDateWindow)+(פעילויות[סיום]>=StartDateWindow)>0)*(פעילויות[התחלה]<=(StartDateWindow+WindowDays-1)), 0))","v":-3},-7]
[{"$nulls":4},{"$f":"INDEX(פעילויות[מזהה],MATCH(1, (פעילויות[מזהה]>E19)*((פעילויות[התחלה]>=StartDateWindow)+(פעילויות[סיום]>=StartDateWindow)>0)*(פעילויות[התחלה]<=(StartDateWindow+WindowDays-1)), 0))","v":{"$error":"#N/A"}},-6]
[{"$nulls":4},{"$f":"INDEX(פעילויות[מזהה],MATCH(1, (פעילויות[מזהה]>E20)*((פעילויות[התחלה]>=StartDateWindow)+(פעילויות[סיום]>=StartDateWindow)>0)*(פעילויות[התחלה]<=(StartDateWindow+WindowDays-1)), 0))","v":{"$error":"#N/A"}},-5]
[{"$nulls":4},{"$f":"INDEX(פעילויות[מזהה],MATCH(1, (פעילויות[מזהה]>E21)*((פעילויות[התחלה]>=StartDateWindow)+(פעילויות[סיום]>=StartDateWindow)>0)*(פעילויות[התחלה]<=(StartDateWindow+WindowDays-1)), 0))","v":{"$error":"#N/A"}},-4]
[{"$nulls":4},{"$f":"INDEX(פעילויות[מזהה],MATCH(1, (פעילויות[מזהה]>E22)*((פעילויות[התחלה]>=StartDateWindow)+(פעילויות[סיום]>=StartDateWindow)>0)*(פעילויות[התחלה]<=(StartDateWindow+WindowDays-1)), 0))","v":{"$error":"#N/A"}},-3]
[]
[null,null,"התחלת חלון חישוב",{"$f":"StartDate+WindowOffset","v":"2019-08-20"}]
[null,null,"היסט",0]
[]
[null,null,"התחלה",{"$f":"'ציר זמן של פרוייקט'!D3","v":"2019-08-20"}]
[null,null,"חלון",30]
[]
["מיקום","סידרה","מזהה פעילות","פעילות",{"$f":"StartDateWindow","v":"2019-08-20"},{"$f":"E31+1","v":"2019-08-21"},"2019-08-22","2019-08-23","2019-08-24","2019-08-25","2019-08-26","2019-08-27","2019-08-28","2019-08-29","2019-08-30","2019-08-31","2019-09-01","2019-09-02","2019-09-03","2019-09-04","2019-09-05","2019-09-06","2019-09-07","2019-09-08","2019-09-09","2019-09-10","2019-09-11","2019-09-12","2019-09-13","2019-09-14","2019-09-15","2019-09-16","2019-09-17","2019-09-18","2019-09-19"]
[11.3,1,{"$f":"F15","v":{"$error":"#N/A"}},{"$f":"INDEX(פעילויות[פעילות],MATCH($C32,פעילויות[מזהה],0))","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}}]
[{"$f":"A32-1","v":10.3},2,{"$error":"#N/A"},{"$f":"INDEX(פעילויות[פעילות],MATCH($C33,פעילויות[מזהה],0))","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}}]
[{"$f":"A33-1","v":9.3},3,{"$error":"#N/A"},{"$f":"INDEX(פעילויות[פעילות],MATCH($C34,פעילויות[מזהה],0))","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}}]
[8.3,4,{"$error":"#N/A"},{"$f":"INDEX(פעילויות[פעילות],MATCH($C35,פעילויות[מזהה],0))","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}}]
[7.300000000000001,5,-7,{"$f":"INDEX(פעילויות[פעילות],MATCH($C36,פעילויות[מזהה],0))","v":"תחילת הפרוייקט"},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":7.300000000000001},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}}]
[6.300000000000001,6,-6,{"$f":"INDEX(פעילויות[פעילות],MATCH($C37,פעילויות[מזהה],0))","v":"אבן דרך 1"},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":6.300000000000001},{"$f":"GridCalc","v":6.300000000000001},{"$f":"GridCalc","v":6.300000000000001},{"$f":"GridCalc","v":6.300000000000001},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}}]
[5.300000000000001,7,-5,{"$f":"INDEX(פעילויות[פעילות],MATCH($C38,פעילויות[מזהה],0))","v":"אבן דרך 2"},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":5.300000000000001},{"$f":"GridCalc","v":5.300000000000001},{"$f":"GridCalc","v":5.300000000000001},{"$f":"GridCalc","v":5.300000000000001},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}}]
[4.300000000000001,8,-4,{"$f":"INDEX(פעילויות[פעילות],MATCH($C39,פעילויות[מזהה],0))","v":"אבן דרך 3"},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":4.300000000000001},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}}]
[3.3000000000000007,9,-3,{"$f":"INDEX(פעילויות[פעילות],MATCH($C40,פעילויות[מזהה],0))","v":"אבן דרך 4"},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":3.3000000000000007},{"$f":"GridCalc","v":3.3000000000000007}]
[]
[]
[{"$nulls":4},{"$f":"E31","v":"2019-08-20"},{"$f":"F31","v":"2019-08-21"},"2019-08-22","2019-08-23","2019-08-24","2019-08-25","2019-08-26","2019-08-27","2019-08-28","2019-08-29","2019-08-30","2019-08-31","2019-09-01","2019-09-02","2019-09-03","2019-09-04","2019-09-05","2019-09-06","2019-09-07","2019-09-08","2019-09-09","2019-09-10","2019-09-11","2019-09-12","2019-09-13","2019-09-14","2019-09-15","2019-09-16","2019-09-17","2019-09-18"]
[null,null,{"$f":"C32","v":{"$error":"#N/A"}},{"$f":"UPPER(INDEX(פעילויות[פעילות],MATCH($C44,פעילויות[מזהה],0)))","v":{"$error":"#N/A"}},{"$f":"IF(ISERROR(F32),E32,NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,{"$f":"C33","v":{"$error":"#N/A"}},{"$f":"UPPER(INDEX(פעילויות[פעילות],MATCH($C45,פעילויות[מזהה],0)))","v":{"$error":"#N/A"}},{"$f":"IF(ISERROR(F33),E33,NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,{"$error":"#N/A"},{"$f":"UPPER(INDEX(פעילויות[פעילות],MATCH($C46,פעילויות[מזהה],0)))","v":{"$error":"#N/A"}},{"$f":"IF(ISERROR(F34),E34,NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,{"$error":"#N/A"},{"$f":"UPPER(INDEX(פעילויות[פעילות],MATCH($C47,פעילויות[מזהה],0)))","v":{"$error":"#N/A"}},{"$f":"IF(ISERROR(F35),E35,NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,-7,{"$f":"UPPER(INDEX(פעילויות[פעילות],MATCH($C48,פעילויות[מזהה],0)))","v":"תחילת הפרוייקט"},{"$f":"IF(ISERROR(F36),E36,NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},7.300000000000001,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,-6,{"$f":"UPPER(INDEX(פעילויות[פעילות],MATCH($C49,פעילויות[מזהה],0)))","v":"אבן דרך 1"},{"$f":"IF(ISERROR(F37),E37,NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},6.300000000000001,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,-5,{"$f":"UPPER(INDEX(פעילויות[פעילות],MATCH($C50,פעילויות[מזהה],0)))","v":"אבן דרך 2"},{"$f":"IF(ISERROR(F38),E38,NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},5.300000000000001,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,-4,{"$f":"UPPER(INDEX(פעילויות[פעילות],MATCH($C51,פעילויות[מזהה],0)))","v":"אבן דרך 3"},{"$f":"IF(ISERROR(F39),E39,NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},4.300000000000001,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,-3,{"$f":"UPPER(INDEX(פעילויות[פעילות],MATCH($C52,פעילויות[מזהה],0)))","v":"אבן דרך 4"},{"$f":"IF(ISERROR(F40),E40,NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[]
[]
[{"$nulls":4},{"$f":"E31","v":"2019-08-20"},{"$f":"F31","v":"2019-08-21"},"2019-08-22","2019-08-23","2019-08-24","2019-08-25","2019-08-26","2019-08-27","2019-08-28","2019-08-29","2019-08-30","2019-08-31","2019-09-01","2019-09-02","2019-09-03","2019-09-04","2019-09-05","2019-09-06","2019-09-07","2019-09-08","2019-09-09","2019-09-10","2019-09-11","2019-09-12","2019-09-13","2019-09-14","2019-09-15","2019-09-16","2019-09-17","2019-09-18"]
[{"$nulls":3},"היום הנוכחי",{"$f":"IF(E55=$D$3,5,NA())","v":5},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[]
[{"$nulls":3},{"$f":"DATE(YEAR(MIN(E55:AH55)),MONTH(MIN(E55:AH55)),1)","v":"2019-08-01"},{"$f":"IF(MEDIAN($D58,E$55,EOMONTH($D58,0))=E$55,0.5,NA())","v":0.5},{"$f":"IF(MEDIAN($D58,F$55,EOMONTH($D58,0))=F$55,0.5,NA())","v":0.5},0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$nulls":3},{"$f":"TEXT(D58,\"mmm yyyy\") & \" - Top Band\"","v":"Aug 2019 - Top Band"},{"$f":"E58+12.5","v":13},{"$f":"F58+12.5","v":13},13,13,13,13,13,13,13,13,13,13,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[]
[{"$nulls":3},{"$f":"EOMONTH(D58,0)+1","v":"2019-09-01"},{"$f":"IF(MEDIAN($D61,E$55,EOMONTH($D61,0))=E$55,0.5,NA())","v":{"$error":"#N/A"}},{"$f":"IF(MEDIAN($D61,F$55,EOMONTH($D61,0))=F$55,0.5,NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5]
[{"$nulls":3},{"$f":"TEXT(D61,\"mmm yyyy\") & \" - Top Band\"","v":"Sep 2019 - Top Band"},{"$f":"E61+12.5","v":{"$error":"#N/A"}},{"$f":"F61+12.5","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13]
[]
[]
[{"$nulls":3},{"$f":"D58+1","v":"2019-08-02"},{"$f":"IF(MEDIAN($D65,E$55)=E$55,0.5,NA())","v":{"$error":"#N/A"}},{"$f":"IF(MEDIAN($D65,F$55)=F$55,0.5,NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$nulls":3},{"$f":"D61+1","v":"2019-09-02"},{"$f":"IF(MEDIAN($D66,E$55)=E$55,0.5,NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},0.5,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[]
[]
[{"$nulls":4},2.3,{"$f":"E69","v":2.3},{"$f":"F69","v":2.3},2.3,2.3,2.3,2.3,2.3,2.3,2.3,2.3,2.3,2.3,2.3,2.3,2.3,2.3,2.3,2.3,2.3,2.3,2.3,2.3,2.3,2.3,2.3,2.3,2.3,2.3,2.3]
[{"$nulls":3},3,{"$f":"LEFT(UPPER(TEXT(E55,\"ddd\")),$D70)","v":"TUE"},{"$f":"LEFT(UPPER(TEXT(F55,\"ddd\")),$D70)","v":"WED"},"THU","FRI","SAT","SUN","MON","TUE","WED","THU","FRI","SAT","SUN","MON","TUE","WED","THU","FRI","SAT","SUN","MON","TUE","WED","THU","FRI","SAT","SUN","MON","TUE","WED"]
[{"$nulls":4},1.3,{"$f":"E71","v":1.3},1.3,1.3,1.3,1.3,1.3,1.3,1.3,1.3,1.3,1.3,1.3,1.3,1.3,1.3,1.3,1.3,1.3,1.3,1.3,1.3,1.3,1.3,1.3,1.3,1.3,1.3,1.3,1.3]
[{"$nulls":4},{"$f":"TEXT(E55,\"dd\")","v":"20"},{"$f":"TEXT(F55,\"dd\")","v":"21"},"22","23","24","25","26","27","28","29","30","31","01","02","03","04","05","06","07","08","09","10","11","12","13","14","15","16","17","18"]