{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Project Timeline","calcs"],"not_rendered":{"charts":1,"defined_names":6},"read":"whole","date_system":"1900"}

{"sheet":"Project Timeline","index":0,"n_rows":34,"n_cols":6,"rows_kept":34}
[null,null,"PROJECT TIMELINE"]
{"$rows_empty":18}
[null,null,"ENTER START DATE: ",{"$f":"TODAY()-3","v":"2012-06-24"}]
[]
[null,"Id","ACTIVITY","START","END","NOTES"]
[null,{"$f":"N(B22)+1","v":1},"Project Start",{"$f":"D20+3","v":"2012-06-27"}]
[null,2,"Milestone 1",{"$f":"D23+10","v":"2012-07-07"},{"$f":"Activities[[#This Row],[START]]+3","v":"2012-07-10"}]
[null,3,"Milestone 2",{"$f":"D24+1","v":"2012-07-08"},{"$f":"Activities[[#This Row],[START]]+3","v":"2012-07-11"}]
[null,4,"Milestone 3",{"$f":"D25+5","v":"2012-07-13"}]
[null,5,"Milestone 4","2012-07-23",{"$f":"Activities[[#This Row],[START]]+2","v":"2012-07-25"}]
[null,6,"Milestone 5","2012-08-02",{"$f":"Activities[[#This Row],[START]]+2","v":"2012-08-04"}]
[null,{"$f":"N(B28)+1","v":7},"Milestone 6","2012-08-12",{"$f":"Activities[[#This Row],[START]]+2","v":"2012-08-14"}]
[null,8,"Milestone 7","2012-08-22"]
[null,9,"Milestone 8","2012-09-01",{"$f":"Activities[[#This Row],[START]]+2","v":"2012-09-03"}]
[null,10,"Milestone 9","2012-09-11",{"$f":"Activities[[#This Row],[START]]+2","v":"2012-09-13"}]
[null,11,"Milestone 10","2012-09-21",{"$f":"Activities[[#This Row],[START]]+2","v":"2012-09-23"}]
[null,12,"Project End","2012-10-01"]

{"sheet":"calcs","index":1,"n_rows":72,"n_cols":35,"rows_kept":72,"hidden":true}
["*** This sheet should remain hidden ***"]
[]
[null,null,"Today:",{"$f":"TODAY()","v":"2012-06-27"}]
[{"$nulls":3},5]
[]
[{"$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,"Window Activities:",{"$f":"SUMPRODUCT( ((Activities[START]>=StartDateWindow)+(Activities[END]>=StartDateWindow)>0)*(Activities[START]<=(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(Activities[Id],MATCH(1, ((Activities[START]>=StartDateWindow)+(Activities[END]>=StartDateWindow)>0)*(Activities[START]<=(StartDateWindow+WindowDays-1)), 0))","v":1},{"$f":"OFFSET(E15,-$D$11,)","v":{"$error":"#N/A"}}]
[{"$nulls":4},{"$f":"INDEX(Activities[Id],MATCH(1, (Activities[Id]>E15)*((Activities[START]>=StartDateWindow)+(Activities[END]>=StartDateWindow)>0)*(Activities[START]<=(StartDateWindow+WindowDays-1)), 0))","v":2},{"$error":"#N/A"}]
[{"$nulls":4},{"$f":"INDEX(Activities[Id],MATCH(1, (Activities[Id]>E16)*((Activities[START]>=StartDateWindow)+(Activities[END]>=StartDateWindow)>0)*(Activities[START]<=(StartDateWindow+WindowDays-1)), 0))","v":3},{"$error":"#N/A"}]
[{"$nulls":4},{"$f":"INDEX(Activities[Id],MATCH(1, (Activities[Id]>E17)*((Activities[START]>=StartDateWindow)+(Activities[END]>=StartDateWindow)>0)*(Activities[START]<=(StartDateWindow+WindowDays-1)), 0))","v":4},{"$error":"#N/A"}]
[{"$nulls":4},{"$f":"INDEX(Activities[Id],MATCH(1, (Activities[Id]>E18)*((Activities[START]>=StartDateWindow)+(Activities[END]>=StartDateWindow)>0)*(Activities[START]<=(StartDateWindow+WindowDays-1)), 0))","v":5},1]
[{"$nulls":4},{"$f":"INDEX(Activities[Id],MATCH(1, (Activities[Id]>E19)*((Activities[START]>=StartDateWindow)+(Activities[END]>=StartDateWindow)>0)*(Activities[START]<=(StartDateWindow+WindowDays-1)), 0))","v":{"$error":"#N/A"}},2]
[{"$nulls":4},{"$f":"INDEX(Activities[Id],MATCH(1, (Activities[Id]>E20)*((Activities[START]>=StartDateWindow)+(Activities[END]>=StartDateWindow)>0)*(Activities[START]<=(StartDateWindow+WindowDays-1)), 0))","v":{"$error":"#N/A"}},3]
[{"$nulls":4},{"$f":"INDEX(Activities[Id],MATCH(1, (Activities[Id]>E21)*((Activities[START]>=StartDateWindow)+(Activities[END]>=StartDateWindow)>0)*(Activities[START]<=(StartDateWindow+WindowDays-1)), 0))","v":{"$error":"#N/A"}},4]
[{"$nulls":4},{"$f":"INDEX(Activities[Id],MATCH(1, (Activities[Id]>E22)*((Activities[START]>=StartDateWindow)+(Activities[END]>=StartDateWindow)>0)*(Activities[START]<=(StartDateWindow+WindowDays-1)), 0))","v":{"$error":"#N/A"}},5]
[]
[null,null,"Calc Window Start",{"$f":"StartDate+WindowOffset","v":"2012-06-24"}]
[null,null,"Offset",0]
[]
[null,null,"Start",{"$f":"'Project Timeline'!D20","v":"2012-06-24"}]
[null,null,"Window",30]
[]
["Position","Series","Activity Id","Activity",{"$f":"StartDateWindow","v":"2012-06-24"},{"$f":"E31+1","v":"2012-06-25"},"2012-06-26","2012-06-27","2012-06-28","2012-06-29","2012-06-30","2012-07-01","2012-07-02","2012-07-03","2012-07-04","2012-07-05","2012-07-06","2012-07-07","2012-07-08","2012-07-09","2012-07-10","2012-07-11","2012-07-12","2012-07-13","2012-07-14","2012-07-15","2012-07-16","2012-07-17","2012-07-18","2012-07-19","2012-07-20","2012-07-21","2012-07-22","2012-07-23","2012-07-24"]
[11.3,1,{"$f":"F15","v":{"$error":"#N/A"}},{"$f":"INDEX(Activities[ACTIVITY],MATCH($C32,Activities[Id],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(Activities[ACTIVITY],MATCH($C33,Activities[Id],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(Activities[ACTIVITY],MATCH($C34,Activities[Id],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(Activities[ACTIVITY],MATCH($C35,Activities[Id],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,1,{"$f":"INDEX(Activities[ACTIVITY],MATCH($C36,Activities[Id],0))","v":"Project Start"},{"$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,2,{"$f":"INDEX(Activities[ACTIVITY],MATCH($C37,Activities[Id],0))","v":"Milestone 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,3,{"$f":"INDEX(Activities[ACTIVITY],MATCH($C38,Activities[Id],0))","v":"Milestone 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(Activities[ACTIVITY],MATCH($C39,Activities[Id],0))","v":"Milestone 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,5,{"$f":"INDEX(Activities[ACTIVITY],MATCH($C40,Activities[Id],0))","v":"Milestone 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":"2012-06-24"},{"$f":"F31","v":"2012-06-25"},"2012-06-26","2012-06-27","2012-06-28","2012-06-29","2012-06-30","2012-07-01","2012-07-02","2012-07-03","2012-07-04","2012-07-05","2012-07-06","2012-07-07","2012-07-08","2012-07-09","2012-07-10","2012-07-11","2012-07-12","2012-07-13","2012-07-14","2012-07-15","2012-07-16","2012-07-17","2012-07-18","2012-07-19","2012-07-20","2012-07-21","2012-07-22","2012-07-23"]
[null,null,{"$f":"C32","v":{"$error":"#N/A"}},{"$f":"UPPER(INDEX(Activities[ACTIVITY],MATCH($C44,Activities[Id],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(Activities[ACTIVITY],MATCH($C45,Activities[Id],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(Activities[ACTIVITY],MATCH($C46,Activities[Id],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(Activities[ACTIVITY],MATCH($C47,Activities[Id],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,1,{"$f":"UPPER(INDEX(Activities[ACTIVITY],MATCH($C48,Activities[Id],0)))","v":"PROJECT START"},{"$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,2,{"$f":"UPPER(INDEX(Activities[ACTIVITY],MATCH($C49,Activities[Id],0)))","v":"MILESTONE 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,3,{"$f":"UPPER(INDEX(Activities[ACTIVITY],MATCH($C50,Activities[Id],0)))","v":"MILESTONE 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(Activities[ACTIVITY],MATCH($C51,Activities[Id],0)))","v":"MILESTONE 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,5,{"$f":"UPPER(INDEX(Activities[ACTIVITY],MATCH($C52,Activities[Id],0)))","v":"MILESTONE 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":"2012-06-24"},{"$f":"F31","v":"2012-06-25"},"2012-06-26","2012-06-27","2012-06-28","2012-06-29","2012-06-30","2012-07-01","2012-07-02","2012-07-03","2012-07-04","2012-07-05","2012-07-06","2012-07-07","2012-07-08","2012-07-09","2012-07-10","2012-07-11","2012-07-12","2012-07-13","2012-07-14","2012-07-15","2012-07-16","2012-07-17","2012-07-18","2012-07-19","2012-07-20","2012-07-21","2012-07-22","2012-07-23"]
[{"$nulls":3},"Current Day",{"$f":"IF(E55=$D$3,5,NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},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"}]
[]
[{"$nulls":3},{"$f":"DATE(YEAR(MIN(E55:AH55)),MONTH(MIN(E55:AH55)),1)","v":"2012-06-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,{"$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":"TEXT(D58,\"mmm yyyy\") & \" - Top Band\"","v":"Jun 2012 - Top Band"},{"$f":"E58+12.5","v":13},{"$f":"F58+12.5","v":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"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[]
[{"$nulls":3},{"$f":"EOMONTH(D58,0)+1","v":"2012-07-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"},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,0.5,0.5,0.5,0.5,0.5]
[{"$nulls":3},{"$f":"TEXT(D61,\"mmm yyyy\") & \" - Top Band\"","v":"Jul 2012 - 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"},13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13]
[]
[]
[{"$nulls":3},{"$f":"D58+1","v":"2012-06-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":"2012-07-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"},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"},{"$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":"SUN"},{"$f":"LEFT(UPPER(TEXT(F55,\"ddd\")),$D70)","v":"MON"},"TUE","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"]
[{"$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":"24"},{"$f":"TEXT(F55,\"dd\")","v":"25"},"26","27","28","29","30","01","02","03","04","05","06","07","08","09","10","11","12","13","14","15","16","17","18","19","20","21","22","23"]