{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["GANTT VIEW_new"],"not_rendered":{"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"GANTT VIEW_new","index":0,"n_rows":91,"n_cols":248,"rows_kept":91,"merged":[[0,8,0,12],[4,0,6,0],[4,1,6,1],[4,2,6,2],[4,3,6,3],[4,4,6,4],[4,5,6,5],[4,6,6,6],[4,7,6,7],[8,0,10,0],[8,1,10,1],[8,2,10,2],[8,3,10,3],[8,4,10,4],[8,5,10,5],[8,6,10,6],[8,7,10,7],[12,0,14,0],[12,1,14,1],[12,2,14,2],[12,3,14,3],[12,4,14,4],[12,5,14,5],[12,6,14,6],[12,7,14,7],[16,0,18,0],[16,1,18,1],[16,2,18,2],[16,3,18,3],[16,4,18,4],[16,5,18,5],[16,6,18,6],[16,7,18,7],[20,0,22,0],[20,1,22,1],[20,2,22,2],[20,3,22,3],[20,4,22,4],[20,5,22,5],[20,6,22,6],[20,7,22,7],[24,0,26,0],[24,1,26,1],[24,2,26,2],[24,3,26,3],[24,4,26,4],[24,5,26,5],[24,6,26,6],[24,7,26,7],[28,0,30,0],[28,1,30,1],[28,2,30,2],[28,3,30,3],[28,4,30,4],[28,5,30,5],[28,6,30,6],[28,7,30,7],[32,0,34,0],[32,1,34,1],[32,2,34,2],[32,3,34,3],[32,4,34,4],[32,5,34,5],[32,6,34,6],[32,7,34,7],[36,0,38,0],[36,1,38,1],[36,2,38,2],[36,3,38,3],[36,4,38,4],[36,5,38,5],[36,6,38,6],[36,7,38,7],[40,0,42,0],[40,1,42,1],[40,2,42,2],[40,3,42,3],[40,4,42,4],[40,5,42,5],[40,6,42,6],[40,7,42,7],[44,0,46,0],[44,1,46,1],[44,2,46,2],[44,3,46,3],[44,4,46,4],[44,5,46,5],[44,6,46,6],[44,7,46,7],[48,0,50,0],[48,1,50,1],[48,2,50,2],[48,3,50,3],[48,4,50,4],[48,5,50,5],[48,6,50,6],[48,7,50,7],[52,0,54,0],[52,1,54,1],[52,2,54,2],[52,3,54,3],[52,4,54,4],[52,5,54,5],[52,6,54,6],[52,7,54,7],[56,0,58,0],[56,1,58,1],[56,2,58,2],[56,3,58,3],[56,4,58,4],[56,5,58,5],[56,6,58,6],[56,7,58,7],[60,0,62,0],[60,1,62,1],[60,2,62,2],[60,3,62,3],[60,4,62,4],[60,5,62,5],[60,6,62,6],[60,7,62,7],[64,0,66,0],[64,1,66,1],[64,2,66,2],[64,3,66,3],[64,4,66,4],[64,5,66,5],[64,6,66,6],[64,7,66,7],[68,0,70,0],[68,1,70,1],[68,2,70,2],[68,3,70,3],[68,4,70,4],[68,5,70,5],[68,6,70,6],[68,7,70,7],[72,0,74,0],[72,1,74,1],[72,2,74,2],[72,3,74,3],[72,4,74,4],[72,5,74,5],[72,6,74,6],[72,7,74,7],[76,0,78,0],[76,1,78,1],[76,2,78,2],[76,3,78,3],[76,4,78,4],[76,5,78,5],[76,6,78,6],[76,7,78,7],[80,0,82,0],[80,1,82,1],[80,2,82,2],[80,3,82,3],[80,4,82,4],[80,5,82,5],[80,6,82,6],[80,7,82,7],[84,0,86,0],[84,1,86,1],[84,2,86,2],[84,3,86,3],[84,4,86,4],[84,5,86,5],[84,6,86,6],[84,7,86,7],[88,0,90,0],[88,1,90,1],[88,2,90,2],[88,3,90,3],[88,4,90,4],[88,5,90,5],[88,6,90,6],[88,7,90,7]]}
["PROJECT NAME:",{"$nulls":6},"Gantt Start Date:","2011-11-03"]
["PROJECT MANAGER:"]
["WBS","TASKS","PLANNED START DATE","PLANNED FINISH DATE","ACTUAL START  DATE","ACTUAL FINISH DATE","STATUS",{"$f":"(SUMPRODUCT(H9:H47,D9:D47-C9:C47)+SUMPRODUCT(H53:H91,D53:D91-C53:C91))/((SUM(D9:D47)-SUM(C9:C47))+(SUM(D53:D91)-SUM(C53:C91)))","v":{"v":0.9174311926605505,"d":"91.7%"}},{"$f":"I1","v":"2011-11-03"},{"$f":"I3+1","v":"2011-11-04"},{"$f":"J3+1","v":"2011-11-05"},"2011-11-06","2011-11-07","2011-11-08","2011-11-09","2011-11-10","2011-11-11","2011-11-12","2011-11-13","2011-11-14","2011-11-15","2011-11-16","2011-11-17","2011-11-18","2011-11-19","2011-11-20","2011-11-21","2011-11-22","2011-11-23","2011-11-24","2011-11-25","2011-11-26","2011-11-27","2011-11-28","2011-11-29","2011-11-30","2011-12-01","2011-12-02","2011-12-03","2011-12-04","2011-12-05","2011-12-06","2011-12-07","2011-12-08","2011-12-09","2011-12-10","2011-12-11","2011-12-12","2011-12-13","2011-12-14","2011-12-15","2011-12-16","2011-12-17","2011-12-18","2011-12-19","2011-12-20","2011-12-21","2011-12-22","2011-12-23","2011-12-24","2011-12-25","2011-12-26","2011-12-27","2011-12-28","2011-12-29","2011-12-30","2011-12-31","2012-01-01","2012-01-02","2012-01-03","2012-01-04","2012-01-05","2012-01-06","2012-01-07",{"$f":"BV3+1","v":"2012-01-08"},"2012-01-09","2012-01-10","2012-01-11","2012-01-12","2012-01-13","2012-01-14","2012-01-15","2012-01-16","2012-01-17","2012-01-18","2012-01-19","2012-01-20","2012-01-21","2012-01-22","2012-01-23","2012-01-24","2012-01-25","2012-01-26","2012-01-27","2012-01-28","2012-01-29","2012-01-30","2012-01-31","2012-02-01","2012-02-02","2012-02-03","2012-02-04","2012-02-05","2012-02-06","2012-02-07","2012-02-08","2012-02-09","2012-02-10","2012-02-11","2012-02-12","2012-02-13","2012-02-14","2012-02-15","2012-02-16","2012-02-17","2012-02-18","2012-02-19","2012-02-20","2012-02-21","2012-02-22","2012-02-23","2012-02-24","2012-02-25","2012-02-26","2012-02-27","2012-02-28","2012-02-29","2012-03-01","2012-03-02","2012-03-03","2012-03-04","2012-03-05","2012-03-06","2012-03-07","2012-03-08","2012-03-09","2012-03-10","2012-03-11",{"$f":"EH3+1","v":"2012-03-12"},"2012-03-13","2012-03-14","2012-03-15","2012-03-16","2012-03-17","2012-03-18","2012-03-19","2012-03-20","2012-03-21","2012-03-22","2012-03-23","2012-03-24","2012-03-25","2012-03-26","2012-03-27","2012-03-28","2012-03-29","2012-03-30","2012-03-31","2012-04-01","2012-04-02","2012-04-03","2012-04-04","2012-04-05","2012-04-06","2012-04-07","2012-04-08","2012-04-09","2012-04-10","2012-04-11","2012-04-12","2012-04-13","2012-04-14","2012-04-15","2012-04-16","2012-04-17","2012-04-18","2012-04-19","2012-04-20","2012-04-21","2012-04-22","2012-04-23","2012-04-24","2012-04-25","2012-04-26","2012-04-27","2012-04-28","2012-04-29","2012-04-30","2012-05-01","2012-05-02","2012-05-03","2012-05-04","2012-05-05","2012-05-06","2012-05-07","2012-05-08","2012-05-09","2012-05-10","2012-05-11","2012-05-12","2012-05-13","2012-05-14",{"$f":"GT3+1","v":"2012-05-15"},"2012-05-16","2012-05-17","2012-05-18","2012-05-19","2012-05-20","2012-05-21","2012-05-22","2012-05-23","2012-05-24","2012-05-25","2012-05-26","2012-05-27","2012-05-28","2012-05-29","2012-05-30","2012-05-31","2012-06-01","2012-06-02","2012-06-03","2012-06-04","2012-06-05","2012-06-06","2012-06-07","2012-06-08","2012-06-09","2012-06-10","2012-06-11","2012-06-12","2012-06-13","2012-06-14","2012-06-15","2012-06-16","2012-06-17","2012-06-18","2012-06-19","2012-06-20","2012-06-21","2012-06-22","2012-06-23","2012-06-24","2012-06-25","2012-06-26","2012-06-27","2012-06-28","2012-06-29"]
[]
[1,"WBS Element 1",{"$f":"MIN(C9:C47)","v":"2011-11-04"},{"$f":"MAX(D9:D47)","v":"2011-12-11"},{"$f":"MIN(E9:E47)","v":"2011-11-05"},{"$f":"MAX(F9:F47)","v":"2011-11-23"},"In Progress",{"$f":"SUMPRODUCT(H9:H47,D9:D47-C9:C47)/(SUM(D9:D47)-SUM(C9:C47))","v":{"v":1,"d":"100.0%"}},{"$f":"IF(AND(I$3>=$C5,I$3<=$D5),1,\"\")","v":""},{"$f":"IF(AND(J$3>=$C5,J$3<=$D5),1,\"\")","v":1},1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,"","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AND(BV$3>=$C5,BV$3<=$D5),1,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AND(EH$3>=$C5,EH$3<=$D5),1,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AND(GT$3>=$C5,GT$3<=$D5),1,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[]
[{"$nulls":8},{"$f":"IF(OR(I$3=$E5,I$3=$F5,AND(LEN($F5) > 0,LEN($E5) > 0,I$3>$E5,I$3<$F5)),1,IF(LEN($F5)>0,\"\",IF(OR(I$3=$E5,I$3=$F5,AND((($D5-$C5)*$H5)+$E5>=I$3,$E5<=I$3))=TRUE,1,\"\")))","v":""},{"$f":"IF(OR(J$3=$E5,J$3=$F5,AND(LEN($F5) > 0,LEN($E5) > 0,J$3>$E5,J$3<$F5)),1,IF(LEN($F5)>0,\"\",IF(OR(J$3=$E5,J$3=$F5,AND((($D5-$C5)*$H5)+$E5>=J$3,$E5<=J$3))=TRUE,1,\"\")))","v":""},1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(BV$3=$E5,BV$3=$F5,AND(LEN($F5) > 0,LEN($E5) > 0,BV$3>$E5,BV$3<$F5)),1,IF(LEN($F5)>0,\"\",IF(OR(BV$3=$E5,BV$3=$F5,AND((($D5-$C5)*$H5)+$E5>=BV$3,$E5<=BV$3))=TRUE,1,\"\")))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(EH$3=$E5,EH$3=$F5,AND(LEN($F5) > 0,LEN($E5) > 0,EH$3>$E5,EH$3<$F5)),1,IF(LEN($F5)>0,\"\",IF(OR(EH$3=$E5,EH$3=$F5,AND((($D5-$C5)*$H5)+$E5>=EH$3,$E5<=EH$3))=TRUE,1,\"\")))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(GT$3=$E5,GT$3=$F5,AND(LEN($F5) > 0,LEN($E5) > 0,GT$3>$E5,GT$3<$F5)),1,IF(LEN($F5)>0,\"\",IF(OR(GT$3=$E5,GT$3=$F5,AND((($D5-$C5)*$H5)+$E5>=GT$3,$E5<=GT$3))=TRUE,1,\"\")))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[]
[1.1,"Activity-1","2011-11-05","2011-12-11","2011-11-09","2011-11-15","Completed",{"v":1,"d":"100%"},{"$f":"IF(AND(I$3>=$C9,I$3<=$D9),1,\"\")","v":""},{"$f":"IF(AND(J$3>=$C9,J$3<=$D9),1,\"\")","v":""},1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,"","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AND(BV$3>=$C9,BV$3<=$D9),1,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AND(EH$3>=$C9,EH$3<=$D9),1,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AND(GT$3>=$C9,GT$3<=$D9),1,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[]
[{"$nulls":8},{"$f":"IF(OR(I$3=$E9,I$3=$F9,AND(LEN($F9) > 0,LEN($E9) > 0,I$3>$E9,I$3<$F9)),1,IF(LEN($F9)>0,\"\",IF(OR(I$3=$E9,I$3=$F9,AND((($D9-$C9)*$H9)+$E9>=I$3,$E9<=I$3))=TRUE,1,\"\")))","v":""},{"$f":"IF(OR(J$3=$E9,J$3=$F9,AND(LEN($F9) > 0,LEN($E9) > 0,J$3>$E9,J$3<$F9)),1,IF(LEN($F9)>0,\"\",IF(OR(J$3=$E9,J$3=$F9,AND((($D9-$C9)*$H9)+$E9>=J$3,$E9<=J$3))=TRUE,1,\"\")))","v":""},{"$f":"IF(OR(K$3=$E9,K$3=$F9,AND(LEN($F9) > 0,LEN($E9) > 0,K$3>$E9,K$3<$F9)),1,IF(LEN($F9)>0,\"\",IF(OR(K$3=$E9,K$3=$F9,AND((($D9-$C9)*$H9)+$E9>=K$3,$E9<=K$3))=TRUE,1,\"\")))","v":""},"","","",{"$f":"IF(OR(O$3=$E9,O$3=$F9,AND(LEN($F9) > 0,LEN($E9) > 0,O$3>$E9,O$3<$F9)),1,IF(LEN($F9)>0,\"\",IF(OR(O$3=$E9,O$3=$F9,AND((($D9-$C9)*$H9)+$E9>=O$3,$E9<=O$3))=TRUE,1,\"\")))","v":1},1,1,1,1,1,1,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(BW$3=$E9,BW$3=$F9,AND(LEN($F9) > 0,LEN($E9) > 0,BW$3>$E9,BW$3<$F9)),1,IF(LEN($F9)>0,\"\",IF(OR(BW$3=$E9,BW$3=$F9,AND((($D9-$C9)*$H9)+$E9>=BW$3,$E9<=BW$3))=TRUE,1,\"\")))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(EI$3=$E9,EI$3=$F9,AND(LEN($F9) > 0,LEN($E9) > 0,EI$3>$E9,EI$3<$F9)),1,IF(LEN($F9)>0,\"\",IF(OR(EI$3=$E9,EI$3=$F9,AND((($D9-$C9)*$H9)+$E9>=EI$3,$E9<=EI$3))=TRUE,1,\"\")))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(GU$3=$E9,GU$3=$F9,AND(LEN($F9) > 0,LEN($E9) > 0,GU$3>$E9,GU$3<$F9)),1,IF(LEN($F9)>0,\"\",IF(OR(GU$3=$E9,GU$3=$F9,AND((($D9-$C9)*$H9)+$E9>=GU$3,$E9<=GU$3))=TRUE,1,\"\")))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[]
[1.2,"Activity-2","2011-11-04","2011-11-17","2011-11-11","2011-11-23","In Progress",{"v":1,"d":"100%"},{"$f":"IF(AND(I$3>=$C13,I$3<=$D13),1,\"\")","v":""},{"$f":"IF(AND(J$3>=$C13,J$3<=$D13),1,\"\")","v":1},1,1,1,1,1,1,1,1,1,1,1,1,1,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AND(BV$3>=$C13,BV$3<=$D13),1,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AND(EH$3>=$C13,EH$3<=$D13),1,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AND(GT$3>=$C13,GT$3<=$D13),1,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[]
[{"$nulls":8},{"$f":"IF(OR(I$3=$E13,I$3=$F13,AND(LEN($F13) > 0,LEN($E13) > 0,I$3>$E13,I$3<$F13)),1,IF(LEN($F13)>0,\"\",IF(OR(I$3=$E13,I$3=$F13,AND((($D13-$C13)*$H13)+$E13>=I$3,$E13<=I$3))=TRUE,1,\"\")))","v":""},{"$f":"IF(OR(J$3=$E13,J$3=$F13,AND(LEN($F13) > 0,LEN($E13) > 0,J$3>$E13,J$3<$F13)),1,IF(LEN($F13)>0,\"\",IF(OR(J$3=$E13,J$3=$F13,AND((($D13-$C13)*$H13)+$E13>=J$3,$E13<=J$3))=TRUE,1,\"\")))","v":""},{"$f":"IF(OR(K$3=$E13,K$3=$F13,AND(LEN($F13) > 0,LEN($E13) > 0,K$3>$E13,K$3<$F13)),1,IF(LEN($F13)>0,\"\",IF(OR(K$3=$E13,K$3=$F13,AND((($D13-$C13)*$H13)+$E13>=K$3,$E13<=K$3))=TRUE,1,\"\")))","v":""},"","","","","",1,1,1,1,1,1,1,1,1,1,1,1,1,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(BW$3=$E13,BW$3=$F13,AND(LEN($F13) > 0,LEN($E13) > 0,BW$3>$E13,BW$3<$F13)),1,IF(LEN($F13)>0,\"\",IF(OR(BW$3=$E13,BW$3=$F13,AND((($D13-$C13)*$H13)+$E13>=BW$3,$E13<=BW$3))=TRUE,1,\"\")))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(EI$3=$E13,EI$3=$F13,AND(LEN($F13) > 0,LEN($E13) > 0,EI$3>$E13,EI$3<$F13)),1,IF(LEN($F13)>0,\"\",IF(OR(EI$3=$E13,EI$3=$F13,AND((($D13-$C13)*$H13)+$E13>=EI$3,$E13<=EI$3))=TRUE,1,\"\")))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(GU$3=$E13,GU$3=$F13,AND(LEN($F13) > 0,LEN($E13) > 0,GU$3>$E13,GU$3<$F13)),1,IF(LEN($F13)>0,\"\",IF(OR(GU$3=$E13,GU$3=$F13,AND((($D13-$C13)*$H13)+$E13>=GU$3,$E13<=GU$3))=TRUE,1,\"\")))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[]
[1.3,"Activity-3","2011-11-06","2011-11-12","2011-11-05","2011-11-21","In Progress",{"v":1,"d":"100%"},{"$f":"IF(AND(I$3>=$C17,I$3<=$D17),1,\"\")","v":""},{"$f":"IF(AND(J$3>=$C17,J$3<=$D17),1,\"\")","v":""},"",1,1,1,1,1,1,1,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AND(BV$3>=$C17,BV$3<=$D17),1,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AND(EH$3>=$C17,EH$3<=$D17),1,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AND(GT$3>=$C17,GT$3<=$D17),1,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[]
[{"$nulls":8},{"$f":"IF(OR(I$3=$E17,I$3=$F17,AND(LEN($F17) > 0,LEN($E17) > 0,I$3>$E17,I$3<$F17)),1,IF(LEN($F17)>0,\"\",IF(OR(I$3=$E17,I$3=$F17,AND((($D17-$C17)*$H17)+$E17>=I$3,$E17<=I$3))=TRUE,1,\"\")))","v":""},{"$f":"IF(OR(J$3=$E17,J$3=$F17,AND(LEN($F17) > 0,LEN($E17) > 0,J$3>$E17,J$3<$F17)),1,IF(LEN($F17)>0,\"\",IF(OR(J$3=$E17,J$3=$F17,AND((($D17-$C17)*$H17)+$E17>=J$3,$E17<=J$3))=TRUE,1,\"\")))","v":""},{"$f":"IF(OR(K$3=$E17,K$3=$F17,AND(LEN($F17) > 0,LEN($E17) > 0,K$3>$E17,K$3<$F17)),1,IF(LEN($F17)>0,\"\",IF(OR(K$3=$E17,K$3=$F17,AND((($D17-$C17)*$H17)+$E17>=K$3,$E17<=K$3))=TRUE,1,\"\")))","v":1},1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(BW$3=$E17,BW$3=$F17,AND(LEN($F17) > 0,LEN($E17) > 0,BW$3>$E17,BW$3<$F17)),1,IF(LEN($F17)>0,\"\",IF(OR(BW$3=$E17,BW$3=$F17,AND((($D17-$C17)*$H17)+$E17>=BW$3,$E17<=BW$3))=TRUE,1,\"\")))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(EI$3=$E17,EI$3=$F17,AND(LEN($F17) > 0,LEN($E17) > 0,EI$3>$E17,EI$3<$F17)),1,IF(LEN($F17)>0,\"\",IF(OR(EI$3=$E17,EI$3=$F17,AND((($D17-$C17)*$H17)+$E17>=EI$3,$E17<=EI$3))=TRUE,1,\"\")))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(GU$3=$E17,GU$3=$F17,AND(LEN($F17) > 0,LEN($E17) > 0,GU$3>$E17,GU$3<$F17)),1,IF(LEN($F17)>0,\"\",IF(OR(GU$3=$E17,GU$3=$F17,AND((($D17-$C17)*$H17)+$E17>=GU$3,$E17<=GU$3))=TRUE,1,\"\")))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[]
[1.4,"Activity-4","2011-11-13","2011-11-21","2011-11-07","2011-11-21","Completed",{"v":1,"d":"100%"},{"$f":"IF(AND(I$3>=$C21,I$3<=$D21),1,\"\")","v":""},{"$f":"IF(AND(J$3>=$C21,J$3<=$D21),1,\"\")","v":""},"","","","","","","","",1,1,1,1,1,1,1,1,1,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AND(BV$3>=$C21,BV$3<=$D21),1,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AND(EH$3>=$C21,EH$3<=$D21),1,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AND(GT$3>=$C21,GT$3<=$D21),1,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[]
[{"$nulls":8},{"$f":"IF(OR(I$3=$E21,I$3=$F21,AND(LEN($F21) > 0,LEN($E21) > 0,I$3>$E21,I$3<$F21)),1,IF(LEN($F21)>0,\"\",IF(OR(I$3=$E21,I$3=$F21,AND((($D21-$C21)*$H21)+$E21>=I$3,$E21<=I$3))=TRUE,1,\"\")))","v":""},{"$f":"IF(OR(J$3=$E21,J$3=$F21,AND(LEN($F21) > 0,LEN($E21) > 0,J$3>$E21,J$3<$F21)),1,IF(LEN($F21)>0,\"\",IF(OR(J$3=$E21,J$3=$F21,AND((($D21-$C21)*$H21)+$E21>=J$3,$E21<=J$3))=TRUE,1,\"\")))","v":""},{"$f":"IF(OR(K$3=$E21,K$3=$F21,AND(LEN($F21) > 0,LEN($E21) > 0,K$3>$E21,K$3<$F21)),1,IF(LEN($F21)>0,\"\",IF(OR(K$3=$E21,K$3=$F21,AND((($D21-$C21)*$H21)+$E21>=K$3,$E21<=K$3))=TRUE,1,\"\")))","v":""},"",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(BW$3=$E21,BW$3=$F21,AND(LEN($F21) > 0,LEN($E21) > 0,BW$3>$E21,BW$3<$F21)),1,IF(LEN($F21)>0,\"\",IF(OR(BW$3=$E21,BW$3=$F21,AND((($D21-$C21)*$H21)+$E21>=BW$3,$E21<=BW$3))=TRUE,1,\"\")))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(EI$3=$E21,EI$3=$F21,AND(LEN($F21) > 0,LEN($E21) > 0,EI$3>$E21,EI$3<$F21)),1,IF(LEN($F21)>0,\"\",IF(OR(EI$3=$E21,EI$3=$F21,AND((($D21-$C21)*$H21)+$E21>=EI$3,$E21<=EI$3))=TRUE,1,\"\")))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(GU$3=$E21,GU$3=$F21,AND(LEN($F21) > 0,LEN($E21) > 0,GU$3>$E21,GU$3<$F21)),1,IF(LEN($F21)>0,\"\",IF(OR(GU$3=$E21,GU$3=$F21,AND((($D21-$C21)*$H21)+$E21>=GU$3,$E21<=GU$3))=TRUE,1,\"\")))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[]
[1.5,"Activity-5","2011-11-06","2011-11-12","2011-11-07","2011-11-21","Completed",{"v":1,"d":"100%"},{"$f":"IF(AND(I$3>=$C25,I$3<=$D25),1,\"\")","v":""},{"$f":"IF(AND(J$3>=$C25,J$3<=$D25),1,\"\")","v":""},"",1,1,1,1,1,1,1,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AND(BV$3>=$C25,BV$3<=$D25),1,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AND(EH$3>=$C25,EH$3<=$D25),1,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AND(GT$3>=$C25,GT$3<=$D25),1,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[]
[{"$nulls":8},{"$f":"IF(OR(I$3=$E25,I$3=$F25,AND(LEN($F25) > 0,LEN($E25) > 0,I$3>$E25,I$3<$F25)),1,IF(LEN($F25)>0,\"\",IF(OR(I$3=$E25,I$3=$F25,AND((($D25-$C25)*$H25)+$E25>=I$3,$E25<=I$3))=TRUE,1,\"\")))","v":""},{"$f":"IF(OR(J$3=$E25,J$3=$F25,AND(LEN($F25) > 0,LEN($E25) > 0,J$3>$E25,J$3<$F25)),1,IF(LEN($F25)>0,\"\",IF(OR(J$3=$E25,J$3=$F25,AND((($D25-$C25)*$H25)+$E25>=J$3,$E25<=J$3))=TRUE,1,\"\")))","v":""},{"$f":"IF(OR(K$3=$E25,K$3=$F25,AND(LEN($F25) > 0,LEN($E25) > 0,K$3>$E25,K$3<$F25)),1,IF(LEN($F25)>0,\"\",IF(OR(K$3=$E25,K$3=$F25,AND((($D25-$C25)*$H25)+$E25>=K$3,$E25<=K$3))=TRUE,1,\"\")))","v":""},"",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(BW$3=$E25,BW$3=$F25,AND(LEN($F25) > 0,LEN($E25) > 0,BW$3>$E25,BW$3<$F25)),1,IF(LEN($F25)>0,\"\",IF(OR(BW$3=$E25,BW$3=$F25,AND((($D25-$C25)*$H25)+$E25>=BW$3,$E25<=BW$3))=TRUE,1,\"\")))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(EI$3=$E25,EI$3=$F25,AND(LEN($F25) > 0,LEN($E25) > 0,EI$3>$E25,EI$3<$F25)),1,IF(LEN($F25)>0,\"\",IF(OR(EI$3=$E25,EI$3=$F25,AND((($D25-$C25)*$H25)+$E25>=EI$3,$E25<=EI$3))=TRUE,1,\"\")))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(GU$3=$E25,GU$3=$F25,AND(LEN($F25) > 0,LEN($E25) > 0,GU$3>$E25,GU$3<$F25)),1,IF(LEN($F25)>0,\"\",IF(OR(GU$3=$E25,GU$3=$F25,AND((($D25-$C25)*$H25)+$E25>=GU$3,$E25<=GU$3))=TRUE,1,\"\")))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[]
[1.6,"Activity-6","2011-11-06","2011-11-12","2011-11-07","2011-11-21","Completed",{"v":1,"d":"100%"},{"$f":"IF(AND(I$3>=$C29,I$3<=$D29),1,\"\")","v":""},{"$f":"IF(AND(J$3>=$C29,J$3<=$D29),1,\"\")","v":""},"",1,1,1,1,1,1,1,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AND(BV$3>=$C29,BV$3<=$D29),1,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AND(EH$3>=$C29,EH$3<=$D29),1,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AND(GT$3>=$C29,GT$3<=$D29),1,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[]
[{"$nulls":8},{"$f":"IF(OR(I$3=$E29,I$3=$F29,AND(LEN($F29) > 0,LEN($E29) > 0,I$3>$E29,I$3<$F29)),1,IF(LEN($F29)>0,\"\",IF(OR(I$3=$E29,I$3=$F29,AND((($D29-$C29)*$H29)+$E29>=I$3,$E29<=I$3))=TRUE,1,\"\")))","v":""},{"$f":"IF(OR(J$3=$E29,J$3=$F29,AND(LEN($F29) > 0,LEN($E29) > 0,J$3>$E29,J$3<$F29)),1,IF(LEN($F29)>0,\"\",IF(OR(J$3=$E29,J$3=$F29,AND((($D29-$C29)*$H29)+$E29>=J$3,$E29<=J$3))=TRUE,1,\"\")))","v":""},{"$f":"IF(OR(K$3=$E29,K$3=$F29,AND(LEN($F29) > 0,LEN($E29) > 0,K$3>$E29,K$3<$F29)),1,IF(LEN($F29)>0,\"\",IF(OR(K$3=$E29,K$3=$F29,AND((($D29-$C29)*$H29)+$E29>=K$3,$E29<=K$3))=TRUE,1,\"\")))","v":""},"",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(BW$3=$E29,BW$3=$F29,AND(LEN($F29) > 0,LEN($E29) > 0,BW$3>$E29,BW$3<$F29)),1,IF(LEN($F29)>0,\"\",IF(OR(BW$3=$E29,BW$3=$F29,AND((($D29-$C29)*$H29)+$E29>=BW$3,$E29<=BW$3))=TRUE,1,\"\")))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(EI$3=$E29,EI$3=$F29,AND(LEN($F29) > 0,LEN($E29) > 0,EI$3>$E29,EI$3<$F29)),1,IF(LEN($F29)>0,\"\",IF(OR(EI$3=$E29,EI$3=$F29,AND((($D29-$C29)*$H29)+$E29>=EI$3,$E29<=EI$3))=TRUE,1,\"\")))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(GU$3=$E29,GU$3=$F29,AND(LEN($F29) > 0,LEN($E29) > 0,GU$3>$E29,GU$3<$F29)),1,IF(LEN($F29)>0,\"\",IF(OR(GU$3=$E29,GU$3=$F29,AND((($D29-$C29)*$H29)+$E29>=GU$3,$E29<=GU$3))=TRUE,1,\"\")))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[]
[1.7,"Activity-7","2011-11-06","2011-11-12","2011-11-07","2011-11-21","Completed",{"v":1,"d":"100%"},{"$f":"IF(AND(I$3>=$C33,I$3<=$D33),1,\"\")","v":""},{"$f":"IF(AND(J$3>=$C33,J$3<=$D33),1,\"\")","v":""},"",1,1,1,1,1,1,1,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AND(BV$3>=$C33,BV$3<=$D33),1,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AND(EH$3>=$C33,EH$3<=$D33),1,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AND(GT$3>=$C33,GT$3<=$D33),1,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[]
[{"$nulls":8},{"$f":"IF(OR(I$3=$E33,I$3=$F33,AND(LEN($F33) > 0,LEN($E33) > 0,I$3>$E33,I$3<$F33)),1,IF(LEN($F33)>0,\"\",IF(OR(I$3=$E33,I$3=$F33,AND((($D33-$C33)*$H33)+$E33>=I$3,$E33<=I$3))=TRUE,1,\"\")))","v":""},{"$f":"IF(OR(J$3=$E33,J$3=$F33,AND(LEN($F33) > 0,LEN($E33) > 0,J$3>$E33,J$3<$F33)),1,IF(LEN($F33)>0,\"\",IF(OR(J$3=$E33,J$3=$F33,AND((($D33-$C33)*$H33)+$E33>=J$3,$E33<=J$3))=TRUE,1,\"\")))","v":""},{"$f":"IF(OR(K$3=$E33,K$3=$F33,AND(LEN($F33) > 0,LEN($E33) > 0,K$3>$E33,K$3<$F33)),1,IF(LEN($F33)>0,\"\",IF(OR(K$3=$E33,K$3=$F33,AND((($D33-$C33)*$H33)+$E33>=K$3,$E33<=K$3))=TRUE,1,\"\")))","v":""},"",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(BW$3=$E33,BW$3=$F33,AND(LEN($F33) > 0,LEN($E33) > 0,BW$3>$E33,BW$3<$F33)),1,IF(LEN($F33)>0,\"\",IF(OR(BW$3=$E33,BW$3=$F33,AND((($D33-$C33)*$H33)+$E33>=BW$3,$E33<=BW$3))=TRUE,1,\"\")))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(EI$3=$E33,EI$3=$F33,AND(LEN($F33) > 0,LEN($E33) > 0,EI$3>$E33,EI$3<$F33)),1,IF(LEN($F33)>0,\"\",IF(OR(EI$3=$E33,EI$3=$F33,AND((($D33-$C33)*$H33)+$E33>=EI$3,$E33<=EI$3))=TRUE,1,\"\")))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(GU$3=$E33,GU$3=$F33,AND(LEN($F33) > 0,LEN($E33) > 0,GU$3>$E33,GU$3<$F33)),1,IF(LEN($F33)>0,\"\",IF(OR(GU$3=$E33,GU$3=$F33,AND((($D33-$C33)*$H33)+$E33>=GU$3,$E33<=GU$3))=TRUE,1,\"\")))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[]
[1.8,"Activity-8","2011-11-06","2011-11-12","2011-11-07","2011-11-21","Completed",{"v":1,"d":"100%"},{"$f":"IF(AND(I$3>=$C37,I$3<=$D37),1,\"\")","v":""},{"$f":"IF(AND(J$3>=$C37,J$3<=$D37),1,\"\")","v":""},"",1,1,1,1,1,1,1,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AND(BV$3>=$C37,BV$3<=$D37),1,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AND(EH$3>=$C37,EH$3<=$D37),1,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AND(GT$3>=$C37,GT$3<=$D37),1,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[]
[{"$nulls":8},{"$f":"IF(OR(I$3=$E37,I$3=$F37,AND(LEN($F37) > 0,LEN($E37) > 0,I$3>$E37,I$3<$F37)),1,IF(LEN($F37)>0,\"\",IF(OR(I$3=$E37,I$3=$F37,AND((($D37-$C37)*$H37)+$E37>=I$3,$E37<=I$3))=TRUE,1,\"\")))","v":""},{"$f":"IF(OR(J$3=$E37,J$3=$F37,AND(LEN($F37) > 0,LEN($E37) > 0,J$3>$E37,J$3<$F37)),1,IF(LEN($F37)>0,\"\",IF(OR(J$3=$E37,J$3=$F37,AND((($D37-$C37)*$H37)+$E37>=J$3,$E37<=J$3))=TRUE,1,\"\")))","v":""},{"$f":"IF(OR(K$3=$E37,K$3=$F37,AND(LEN($F37) > 0,LEN($E37) > 0,K$3>$E37,K$3<$F37)),1,IF(LEN($F37)>0,\"\",IF(OR(K$3=$E37,K$3=$F37,AND((($D37-$C37)*$H37)+$E37>=K$3,$E37<=K$3))=TRUE,1,\"\")))","v":""},"",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(BW$3=$E37,BW$3=$F37,AND(LEN($F37) > 0,LEN($E37) > 0,BW$3>$E37,BW$3<$F37)),1,IF(LEN($F37)>0,\"\",IF(OR(BW$3=$E37,BW$3=$F37,AND((($D37-$C37)*$H37)+$E37>=BW$3,$E37<=BW$3))=TRUE,1,\"\")))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(EI$3=$E37,EI$3=$F37,AND(LEN($F37) > 0,LEN($E37) > 0,EI$3>$E37,EI$3<$F37)),1,IF(LEN($F37)>0,\"\",IF(OR(EI$3=$E37,EI$3=$F37,AND((($D37-$C37)*$H37)+$E37>=EI$3,$E37<=EI$3))=TRUE,1,\"\")))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(GU$3=$E37,GU$3=$F37,AND(LEN($F37) > 0,LEN($E37) > 0,GU$3>$E37,GU$3<$F37)),1,IF(LEN($F37)>0,\"\",IF(OR(GU$3=$E37,GU$3=$F37,AND((($D37-$C37)*$H37)+$E37>=GU$3,$E37<=GU$3))=TRUE,1,\"\")))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[]
[1.9,"Activity-9","2011-11-06","2011-11-12","2011-11-07","2011-11-21","Completed",{"v":1,"d":"100%"},{"$f":"IF(AND(I$3>=$C41,I$3<=$D41),1,\"\")","v":""},{"$f":"IF(AND(J$3>=$C41,J$3<=$D41),1,\"\")","v":""},"",1,1,1,1,1,1,1,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AND(BV$3>=$C41,BV$3<=$D41),1,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AND(EH$3>=$C41,EH$3<=$D41),1,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AND(GT$3>=$C41,GT$3<=$D41),1,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[]
[{"$nulls":8},{"$f":"IF(OR(I$3=$E41,I$3=$F41,AND(LEN($F41) > 0,LEN($E41) > 0,I$3>$E41,I$3<$F41)),1,IF(LEN($F41)>0,\"\",IF(OR(I$3=$E41,I$3=$F41,AND((($D41-$C41)*$H41)+$E41>=I$3,$E41<=I$3))=TRUE,1,\"\")))","v":""},{"$f":"IF(OR(J$3=$E41,J$3=$F41,AND(LEN($F41) > 0,LEN($E41) > 0,J$3>$E41,J$3<$F41)),1,IF(LEN($F41)>0,\"\",IF(OR(J$3=$E41,J$3=$F41,AND((($D41-$C41)*$H41)+$E41>=J$3,$E41<=J$3))=TRUE,1,\"\")))","v":""},{"$f":"IF(OR(K$3=$E41,K$3=$F41,AND(LEN($F41) > 0,LEN($E41) > 0,K$3>$E41,K$3<$F41)),1,IF(LEN($F41)>0,\"\",IF(OR(K$3=$E41,K$3=$F41,AND((($D41-$C41)*$H41)+$E41>=K$3,$E41<=K$3))=TRUE,1,\"\")))","v":""},"",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(BW$3=$E41,BW$3=$F41,AND(LEN($F41) > 0,LEN($E41) > 0,BW$3>$E41,BW$3<$F41)),1,IF(LEN($F41)>0,\"\",IF(OR(BW$3=$E41,BW$3=$F41,AND((($D41-$C41)*$H41)+$E41>=BW$3,$E41<=BW$3))=TRUE,1,\"\")))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(EI$3=$E41,EI$3=$F41,AND(LEN($F41) > 0,LEN($E41) > 0,EI$3>$E41,EI$3<$F41)),1,IF(LEN($F41)>0,\"\",IF(OR(EI$3=$E41,EI$3=$F41,AND((($D41-$C41)*$H41)+$E41>=EI$3,$E41<=EI$3))=TRUE,1,\"\")))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(GU$3=$E41,GU$3=$F41,AND(LEN($F41) > 0,LEN($E41) > 0,GU$3>$E41,GU$3<$F41)),1,IF(LEN($F41)>0,\"\",IF(OR(GU$3=$E41,GU$3=$F41,AND((($D41-$C41)*$H41)+$E41>=GU$3,$E41<=GU$3))=TRUE,1,\"\")))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[]
[{"v":1.1,"d":"1.10"},"Activity-9","2011-11-06","2011-11-22","2011-11-07","2011-11-21","Completed",{"v":1,"d":"100%"},{"$f":"IF(AND(I$3>=$C45,I$3<=$D45),1,\"\")","v":""},{"$f":"IF(AND(J$3>=$C45,J$3<=$D45),1,\"\")","v":""},"",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AND(BV$3>=$C45,BV$3<=$D45),1,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AND(EH$3>=$C45,EH$3<=$D45),1,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AND(GT$3>=$C45,GT$3<=$D45),1,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[]
[{"$nulls":8},{"$f":"IF(OR(I$3=$E45,I$3=$F45,AND(LEN($F45) > 0,LEN($E45) > 0,I$3>$E45,I$3<$F45)),1,IF(LEN($F45)>0,\"\",IF(OR(I$3=$E45,I$3=$F45,AND((($D45-$C45)*$H45)+$E45>=I$3,$E45<=I$3))=TRUE,1,\"\")))","v":""},{"$f":"IF(OR(J$3=$E45,J$3=$F45,AND(LEN($F45) > 0,LEN($E45) > 0,J$3>$E45,J$3<$F45)),1,IF(LEN($F45)>0,\"\",IF(OR(J$3=$E45,J$3=$F45,AND((($D45-$C45)*$H45)+$E45>=J$3,$E45<=J$3))=TRUE,1,\"\")))","v":""},{"$f":"IF(OR(K$3=$E45,K$3=$F45,AND(LEN($F45) > 0,LEN($E45) > 0,K$3>$E45,K$3<$F45)),1,IF(LEN($F45)>0,\"\",IF(OR(K$3=$E45,K$3=$F45,AND((($D45-$C45)*$H45)+$E45>=K$3,$E45<=K$3))=TRUE,1,\"\")))","v":""},"",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(BW$3=$E45,BW$3=$F45,AND(LEN($F45) > 0,LEN($E45) > 0,BW$3>$E45,BW$3<$F45)),1,IF(LEN($F45)>0,\"\",IF(OR(BW$3=$E45,BW$3=$F45,AND((($D45-$C45)*$H45)+$E45>=BW$3,$E45<=BW$3))=TRUE,1,\"\")))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(EI$3=$E45,EI$3=$F45,AND(LEN($F45) > 0,LEN($E45) > 0,EI$3>$E45,EI$3<$F45)),1,IF(LEN($F45)>0,\"\",IF(OR(EI$3=$E45,EI$3=$F45,AND((($D45-$C45)*$H45)+$E45>=EI$3,$E45<=EI$3))=TRUE,1,\"\")))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(GU$3=$E45,GU$3=$F45,AND(LEN($F45) > 0,LEN($E45) > 0,GU$3>$E45,GU$3<$F45)),1,IF(LEN($F45)>0,\"\",IF(OR(GU$3=$E45,GU$3=$F45,AND((($D45-$C45)*$H45)+$E45>=GU$3,$E45<=GU$3))=TRUE,1,\"\")))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[]
[2,"WBS Element 2",{"$f":"MIN(C53:C91)","v":"2011-11-04"},{"$f":"MAX(D53:D91)","v":"2011-12-11"},{"$f":"MIN(E53:E91)","v":"2011-11-03"},{"$f":"MAX(F53:F91)","v":"2011-11-23"},"In Progress",{"$f":"SUMPRODUCT(H53:H91,D53:D91-C53:C91)/(SUM(D53:D91)-SUM(C53:C91))","v":{"v":0.8348623853211009,"d":"83.5%"}},{"$f":"IF(AND(I$3>=$C49,I$3<=$D49),1,\"\")","v":""},{"$f":"IF(AND(J$3>=$C49,J$3<=$D49),1,\"\")","v":1},1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,"","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AND(BV$3>=$C49,BV$3<=$D49),1,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AND(EH$3>=$C49,EH$3<=$D49),1,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AND(GT$3>=$C49,GT$3<=$D49),1,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[]
[{"$nulls":8},{"$f":"IF(OR(I$3=$E49,I$3=$F49,AND(LEN($F49) > 0,LEN($E49) > 0,I$3>$E49,I$3<$F49)),1,IF(LEN($F49)>0,\"\",IF(OR(I$3=$E49,I$3=$F49,AND((($D49-$C49)*$H49)+$E49>=I$3,$E49<=I$3))=TRUE,1,\"\")))","v":1},{"$f":"IF(OR(J$3=$E49,J$3=$F49,AND(LEN($F49) > 0,LEN($E49) > 0,J$3>$E49,J$3<$F49)),1,IF(LEN($F49)>0,\"\",IF(OR(J$3=$E49,J$3=$F49,AND((($D49-$C49)*$H49)+$E49>=J$3,$E49<=J$3))=TRUE,1,\"\")))","v":1},1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(BV$3=$E49,BV$3=$F49,AND(LEN($F49) > 0,LEN($E49) > 0,BV$3>$E49,BV$3<$F49)),1,IF(LEN($F49)>0,\"\",IF(OR(BV$3=$E49,BV$3=$F49,AND((($D49-$C49)*$H49)+$E49>=BV$3,$E49<=BV$3))=TRUE,1,\"\")))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(EH$3=$E49,EH$3=$F49,AND(LEN($F49) > 0,LEN($E49) > 0,EH$3>$E49,EH$3<$F49)),1,IF(LEN($F49)>0,\"\",IF(OR(EH$3=$E49,EH$3=$F49,AND((($D49-$C49)*$H49)+$E49>=EH$3,$E49<=EH$3))=TRUE,1,\"\")))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(GT$3=$E49,GT$3=$F49,AND(LEN($F49) > 0,LEN($E49) > 0,GT$3>$E49,GT$3<$F49)),1,IF(LEN($F49)>0,\"\",IF(OR(GT$3=$E49,GT$3=$F49,AND((($D49-$C49)*$H49)+$E49>=GT$3,$E49<=GT$3))=TRUE,1,\"\")))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[]
[{"$f":"A49+0.1","v":2.1},"Activity-1","2011-11-05","2011-12-11","2011-11-09",null,"In Progress",{"v":0.5,"d":"50%"},{"$f":"IF(AND(I$3>=$C53,I$3<=$D53),1,\"\")","v":""},{"$f":"IF(AND(J$3>=$C53,J$3<=$D53),1,\"\")","v":""},1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,"","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AND(BV$3>=$C53,BV$3<=$D53),1,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AND(EH$3>=$C53,EH$3<=$D53),1,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AND(GT$3>=$C53,GT$3<=$D53),1,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[]
[{"$nulls":8},{"$f":"IF(OR(I$3=$E53,I$3=$F53,AND(LEN($F53) > 0,LEN($E53) > 0,I$3>$E53,I$3<$F53)),1,IF(LEN($F53)>0,\"\",IF(OR(I$3=$E53,I$3=$F53,AND((($D53-$C53)*$H53)+$E53>=I$3,$E53<=I$3))=TRUE,1,\"\")))","v":""},{"$f":"IF(OR(J$3=$E53,J$3=$F53,AND(LEN($F53) > 0,LEN($E53) > 0,J$3>$E53,J$3<$F53)),1,IF(LEN($F53)>0,\"\",IF(OR(J$3=$E53,J$3=$F53,AND((($D53-$C53)*$H53)+$E53>=J$3,$E53<=J$3))=TRUE,1,\"\")))","v":""},{"$f":"IF(OR(K$3=$E53,K$3=$F53,AND(LEN($F53) > 0,LEN($E53) > 0,K$3>$E53,K$3<$F53)),1,IF(LEN($F53)>0,\"\",IF(OR(K$3=$E53,K$3=$F53,AND((($D53-$C53)*$H53)+$E53>=K$3,$E53<=K$3))=TRUE,1,\"\")))","v":""},"","","",{"$f":"IF(OR(O$3=$E53,O$3=$F53,AND(LEN($F53) > 0,LEN($E53) > 0,O$3>$E53,O$3<$F53)),1,IF(LEN($F53)>0,\"\",IF(OR(O$3=$E53,O$3=$F53,AND((($D53-$C53)*$H53)+$E53>=O$3,$E53<=O$3))=TRUE,1,\"\")))","v":1},{"$f":"IF(OR(P$3=$E53,P$3=$F53,AND(LEN($F53) > 0,LEN($E53) > 0,P$3>$E53,P$3<$F53)),1,IF(LEN($F53)>0,\"\",IF(OR(P$3=$E53,P$3=$F53,AND((($D53-$C53)*$H53)+$E53>=P$3,$E53<=P$3))=TRUE,1,\"\")))","v":1},1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(CB$3=$E53,CB$3=$F53,AND(LEN($F53) > 0,LEN($E53) > 0,CB$3>$E53,CB$3<$F53)),1,IF(LEN($F53)>0,\"\",IF(OR(CB$3=$E53,CB$3=$F53,AND((($D53-$C53)*$H53)+$E53>=CB$3,$E53<=CB$3))=TRUE,1,\"\")))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(EN$3=$E53,EN$3=$F53,AND(LEN($F53) > 0,LEN($E53) > 0,EN$3>$E53,EN$3<$F53)),1,IF(LEN($F53)>0,\"\",IF(OR(EN$3=$E53,EN$3=$F53,AND((($D53-$C53)*$H53)+$E53>=EN$3,$E53<=EN$3))=TRUE,1,\"\")))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(GZ$3=$E53,GZ$3=$F53,AND(LEN($F53) > 0,LEN($E53) > 0,GZ$3>$E53,GZ$3<$F53)),1,IF(LEN($F53)>0,\"\",IF(OR(GZ$3=$E53,GZ$3=$F53,AND((($D53-$C53)*$H53)+$E53>=GZ$3,$E53<=GZ$3))=TRUE,1,\"\")))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[]
[{"$f":"A53+0.1","v":2.2},"Activity-2","2011-11-04","2011-11-17","2011-11-11","2011-11-23","Completed",{"v":1,"d":"100%"},{"$f":"IF(AND(I$3>=$C57,I$3<=$D57),1,\"\")","v":""},{"$f":"IF(AND(J$3>=$C57,J$3<=$D57),1,\"\")","v":1},1,1,1,1,1,1,1,1,1,1,1,1,1,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AND(BV$3>=$C57,BV$3<=$D57),1,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AND(EH$3>=$C57,EH$3<=$D57),1,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AND(GT$3>=$C57,GT$3<=$D57),1,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[]
[{"$nulls":8},{"$f":"IF(OR(I$3=$E57,I$3=$F57,AND(LEN($F57) > 0,LEN($E57) > 0,I$3>$E57,I$3<$F57)),1,IF(LEN($F57)>0,\"\",IF(OR(I$3=$E57,I$3=$F57,AND((($D57-$C57)*$H57)+$E57>=I$3,$E57<=I$3))=TRUE,1,\"\")))","v":""},{"$f":"IF(OR(J$3=$E57,J$3=$F57,AND(LEN($F57) > 0,LEN($E57) > 0,J$3>$E57,J$3<$F57)),1,IF(LEN($F57)>0,\"\",IF(OR(J$3=$E57,J$3=$F57,AND((($D57-$C57)*$H57)+$E57>=J$3,$E57<=J$3))=TRUE,1,\"\")))","v":""},{"$f":"IF(OR(K$3=$E57,K$3=$F57,AND(LEN($F57) > 0,LEN($E57) > 0,K$3>$E57,K$3<$F57)),1,IF(LEN($F57)>0,\"\",IF(OR(K$3=$E57,K$3=$F57,AND((($D57-$C57)*$H57)+$E57>=K$3,$E57<=K$3))=TRUE,1,\"\")))","v":""},"","","","","",1,1,1,1,1,1,1,1,1,1,1,1,1,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(BW$3=$E57,BW$3=$F57,AND(LEN($F57) > 0,LEN($E57) > 0,BW$3>$E57,BW$3<$F57)),1,IF(LEN($F57)>0,\"\",IF(OR(BW$3=$E57,BW$3=$F57,AND((($D57-$C57)*$H57)+$E57>=BW$3,$E57<=BW$3))=TRUE,1,\"\")))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(EI$3=$E57,EI$3=$F57,AND(LEN($F57) > 0,LEN($E57) > 0,EI$3>$E57,EI$3<$F57)),1,IF(LEN($F57)>0,\"\",IF(OR(EI$3=$E57,EI$3=$F57,AND((($D57-$C57)*$H57)+$E57>=EI$3,$E57<=EI$3))=TRUE,1,\"\")))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(GU$3=$E57,GU$3=$F57,AND(LEN($F57) > 0,LEN($E57) > 0,GU$3>$E57,GU$3<$F57)),1,IF(LEN($F57)>0,\"\",IF(OR(GU$3=$E57,GU$3=$F57,AND((($D57-$C57)*$H57)+$E57>=GU$3,$E57<=GU$3))=TRUE,1,\"\")))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[]
[{"$f":"A57+0.1","v":{"v":2.3000000000000003,"d":"2.3"}},"Activity-3","2011-11-06","2011-11-12","2011-11-03","2011-11-21","Completed",{"v":1,"d":"100%"},{"$f":"IF(AND(I$3>=$C61,I$3<=$D61),1,\"\")","v":""},{"$f":"IF(AND(J$3>=$C61,J$3<=$D61),1,\"\")","v":""},"",1,1,1,1,1,1,1,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AND(BV$3>=$C61,BV$3<=$D61),1,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AND(EH$3>=$C61,EH$3<=$D61),1,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AND(GT$3>=$C61,GT$3<=$D61),1,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[]
[{"$nulls":8},{"$f":"IF(OR(I$3=$E61,I$3=$F61,AND(LEN($F61) > 0,LEN($E61) > 0,I$3>$E61,I$3<$F61)),1,IF(LEN($F61)>0,\"\",IF(OR(I$3=$E61,I$3=$F61,AND((($D61-$C61)*$H61)+$E61>=I$3,$E61<=I$3))=TRUE,1,\"\")))","v":1},{"$f":"IF(OR(J$3=$E61,J$3=$F61,AND(LEN($F61) > 0,LEN($E61) > 0,J$3>$E61,J$3<$F61)),1,IF(LEN($F61)>0,\"\",IF(OR(J$3=$E61,J$3=$F61,AND((($D61-$C61)*$H61)+$E61>=J$3,$E61<=J$3))=TRUE,1,\"\")))","v":1},{"$f":"IF(OR(K$3=$E61,K$3=$F61,AND(LEN($F61) > 0,LEN($E61) > 0,K$3>$E61,K$3<$F61)),1,IF(LEN($F61)>0,\"\",IF(OR(K$3=$E61,K$3=$F61,AND((($D61-$C61)*$H61)+$E61>=K$3,$E61<=K$3))=TRUE,1,\"\")))","v":1},1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(BW$3=$E61,BW$3=$F61,AND(LEN($F61) > 0,LEN($E61) > 0,BW$3>$E61,BW$3<$F61)),1,IF(LEN($F61)>0,\"\",IF(OR(BW$3=$E61,BW$3=$F61,AND((($D61-$C61)*$H61)+$E61>=BW$3,$E61<=BW$3))=TRUE,1,\"\")))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(EI$3=$E61,EI$3=$F61,AND(LEN($F61) > 0,LEN($E61) > 0,EI$3>$E61,EI$3<$F61)),1,IF(LEN($F61)>0,\"\",IF(OR(EI$3=$E61,EI$3=$F61,AND((($D61-$C61)*$H61)+$E61>=EI$3,$E61<=EI$3))=TRUE,1,\"\")))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(GU$3=$E61,GU$3=$F61,AND(LEN($F61) > 0,LEN($E61) > 0,GU$3>$E61,GU$3<$F61)),1,IF(LEN($F61)>0,\"\",IF(OR(GU$3=$E61,GU$3=$F61,AND((($D61-$C61)*$H61)+$E61>=GU$3,$E61<=GU$3))=TRUE,1,\"\")))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[]
[{"$f":"A61+0.1","v":{"v":2.4000000000000004,"d":"2.4"}},"Activity-4","2011-11-13","2011-11-21","2011-11-07","2011-11-21","Completed",{"v":1,"d":"100%"},{"$f":"IF(AND(I$3>=$C65,I$3<=$D65),1,\"\")","v":""},{"$f":"IF(AND(J$3>=$C65,J$3<=$D65),1,\"\")","v":""},"","","","","","","","",1,1,1,1,1,1,1,1,1,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AND(BV$3>=$C65,BV$3<=$D65),1,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AND(EH$3>=$C65,EH$3<=$D65),1,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AND(GT$3>=$C65,GT$3<=$D65),1,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[]
[{"$nulls":8},{"$f":"IF(OR(I$3=$E65,I$3=$F65,AND(LEN($F65) > 0,LEN($E65) > 0,I$3>$E65,I$3<$F65)),1,IF(LEN($F65)>0,\"\",IF(OR(I$3=$E65,I$3=$F65,AND((($D65-$C65)*$H65)+$E65>=I$3,$E65<=I$3))=TRUE,1,\"\")))","v":""},{"$f":"IF(OR(J$3=$E65,J$3=$F65,AND(LEN($F65) > 0,LEN($E65) > 0,J$3>$E65,J$3<$F65)),1,IF(LEN($F65)>0,\"\",IF(OR(J$3=$E65,J$3=$F65,AND((($D65-$C65)*$H65)+$E65>=J$3,$E65<=J$3))=TRUE,1,\"\")))","v":""},{"$f":"IF(OR(K$3=$E65,K$3=$F65,AND(LEN($F65) > 0,LEN($E65) > 0,K$3>$E65,K$3<$F65)),1,IF(LEN($F65)>0,\"\",IF(OR(K$3=$E65,K$3=$F65,AND((($D65-$C65)*$H65)+$E65>=K$3,$E65<=K$3))=TRUE,1,\"\")))","v":""},"",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(BW$3=$E65,BW$3=$F65,AND(LEN($F65) > 0,LEN($E65) > 0,BW$3>$E65,BW$3<$F65)),1,IF(LEN($F65)>0,\"\",IF(OR(BW$3=$E65,BW$3=$F65,AND((($D65-$C65)*$H65)+$E65>=BW$3,$E65<=BW$3))=TRUE,1,\"\")))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(EI$3=$E65,EI$3=$F65,AND(LEN($F65) > 0,LEN($E65) > 0,EI$3>$E65,EI$3<$F65)),1,IF(LEN($F65)>0,\"\",IF(OR(EI$3=$E65,EI$3=$F65,AND((($D65-$C65)*$H65)+$E65>=EI$3,$E65<=EI$3))=TRUE,1,\"\")))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(GU$3=$E65,GU$3=$F65,AND(LEN($F65) > 0,LEN($E65) > 0,GU$3>$E65,GU$3<$F65)),1,IF(LEN($F65)>0,\"\",IF(OR(GU$3=$E65,GU$3=$F65,AND((($D65-$C65)*$H65)+$E65>=GU$3,$E65<=GU$3))=TRUE,1,\"\")))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[]
[{"$f":"A65+0.1","v":{"v":2.5000000000000004,"d":"2.5"}},"Activity-5","2011-11-06","2011-11-12","2011-11-07","2011-11-21","Completed",{"v":1,"d":"100%"},{"$f":"IF(AND(I$3>=$C69,I$3<=$D69),1,\"\")","v":""},{"$f":"IF(AND(J$3>=$C69,J$3<=$D69),1,\"\")","v":""},"",1,1,1,1,1,1,1,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AND(BV$3>=$C69,BV$3<=$D69),1,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AND(EH$3>=$C69,EH$3<=$D69),1,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AND(GT$3>=$C69,GT$3<=$D69),1,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[]
[{"$nulls":8},{"$f":"IF(OR(I$3=$E69,I$3=$F69,AND(LEN($F69) > 0,LEN($E69) > 0,I$3>$E69,I$3<$F69)),1,IF(LEN($F69)>0,\"\",IF(OR(I$3=$E69,I$3=$F69,AND((($D69-$C69)*$H69)+$E69>=I$3,$E69<=I$3))=TRUE,1,\"\")))","v":""},{"$f":"IF(OR(J$3=$E69,J$3=$F69,AND(LEN($F69) > 0,LEN($E69) > 0,J$3>$E69,J$3<$F69)),1,IF(LEN($F69)>0,\"\",IF(OR(J$3=$E69,J$3=$F69,AND((($D69-$C69)*$H69)+$E69>=J$3,$E69<=J$3))=TRUE,1,\"\")))","v":""},{"$f":"IF(OR(K$3=$E69,K$3=$F69,AND(LEN($F69) > 0,LEN($E69) > 0,K$3>$E69,K$3<$F69)),1,IF(LEN($F69)>0,\"\",IF(OR(K$3=$E69,K$3=$F69,AND((($D69-$C69)*$H69)+$E69>=K$3,$E69<=K$3))=TRUE,1,\"\")))","v":""},"",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(BW$3=$E69,BW$3=$F69,AND(LEN($F69) > 0,LEN($E69) > 0,BW$3>$E69,BW$3<$F69)),1,IF(LEN($F69)>0,\"\",IF(OR(BW$3=$E69,BW$3=$F69,AND((($D69-$C69)*$H69)+$E69>=BW$3,$E69<=BW$3))=TRUE,1,\"\")))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(EI$3=$E69,EI$3=$F69,AND(LEN($F69) > 0,LEN($E69) > 0,EI$3>$E69,EI$3<$F69)),1,IF(LEN($F69)>0,\"\",IF(OR(EI$3=$E69,EI$3=$F69,AND((($D69-$C69)*$H69)+$E69>=EI$3,$E69<=EI$3))=TRUE,1,\"\")))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(GU$3=$E69,GU$3=$F69,AND(LEN($F69) > 0,LEN($E69) > 0,GU$3>$E69,GU$3<$F69)),1,IF(LEN($F69)>0,\"\",IF(OR(GU$3=$E69,GU$3=$F69,AND((($D69-$C69)*$H69)+$E69>=GU$3,$E69<=GU$3))=TRUE,1,\"\")))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[]
[{"$f":"A69+0.1","v":{"v":2.6000000000000005,"d":"2.6"}},"Activity-6","2011-11-06","2011-11-12","2011-11-07","2011-11-21","Completed",{"v":1,"d":"100%"},{"$f":"IF(AND(I$3>=$C73,I$3<=$D73),1,\"\")","v":""},{"$f":"IF(AND(J$3>=$C73,J$3<=$D73),1,\"\")","v":""},"",1,1,1,1,1,1,1,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AND(BV$3>=$C73,BV$3<=$D73),1,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AND(EH$3>=$C73,EH$3<=$D73),1,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AND(GT$3>=$C73,GT$3<=$D73),1,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[]
[{"$nulls":8},{"$f":"IF(OR(I$3=$E73,I$3=$F73,AND(LEN($F73) > 0,LEN($E73) > 0,I$3>$E73,I$3<$F73)),1,IF(LEN($F73)>0,\"\",IF(OR(I$3=$E73,I$3=$F73,AND((($D73-$C73)*$H73)+$E73>=I$3,$E73<=I$3))=TRUE,1,\"\")))","v":""},{"$f":"IF(OR(J$3=$E73,J$3=$F73,AND(LEN($F73) > 0,LEN($E73) > 0,J$3>$E73,J$3<$F73)),1,IF(LEN($F73)>0,\"\",IF(OR(J$3=$E73,J$3=$F73,AND((($D73-$C73)*$H73)+$E73>=J$3,$E73<=J$3))=TRUE,1,\"\")))","v":""},{"$f":"IF(OR(K$3=$E73,K$3=$F73,AND(LEN($F73) > 0,LEN($E73) > 0,K$3>$E73,K$3<$F73)),1,IF(LEN($F73)>0,\"\",IF(OR(K$3=$E73,K$3=$F73,AND((($D73-$C73)*$H73)+$E73>=K$3,$E73<=K$3))=TRUE,1,\"\")))","v":""},"",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(BW$3=$E73,BW$3=$F73,AND(LEN($F73) > 0,LEN($E73) > 0,BW$3>$E73,BW$3<$F73)),1,IF(LEN($F73)>0,\"\",IF(OR(BW$3=$E73,BW$3=$F73,AND((($D73-$C73)*$H73)+$E73>=BW$3,$E73<=BW$3))=TRUE,1,\"\")))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(EI$3=$E73,EI$3=$F73,AND(LEN($F73) > 0,LEN($E73) > 0,EI$3>$E73,EI$3<$F73)),1,IF(LEN($F73)>0,\"\",IF(OR(EI$3=$E73,EI$3=$F73,AND((($D73-$C73)*$H73)+$E73>=EI$3,$E73<=EI$3))=TRUE,1,\"\")))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(GU$3=$E73,GU$3=$F73,AND(LEN($F73) > 0,LEN($E73) > 0,GU$3>$E73,GU$3<$F73)),1,IF(LEN($F73)>0,\"\",IF(OR(GU$3=$E73,GU$3=$F73,AND((($D73-$C73)*$H73)+$E73>=GU$3,$E73<=GU$3))=TRUE,1,\"\")))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[]
[{"$f":"A73+0.1","v":{"v":2.7000000000000006,"d":"2.7"}},"Activity-7","2011-11-06","2011-11-12","2011-11-07","2011-11-21","Completed",{"v":1,"d":"100%"},{"$f":"IF(AND(I$3>=$C77,I$3<=$D77),1,\"\")","v":""},{"$f":"IF(AND(J$3>=$C77,J$3<=$D77),1,\"\")","v":""},"",1,1,1,1,1,1,1,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AND(BV$3>=$C77,BV$3<=$D77),1,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AND(EH$3>=$C77,EH$3<=$D77),1,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AND(GT$3>=$C77,GT$3<=$D77),1,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[]
[{"$nulls":8},{"$f":"IF(OR(I$3=$E77,I$3=$F77,AND(LEN($F77) > 0,LEN($E77) > 0,I$3>$E77,I$3<$F77)),1,IF(LEN($F77)>0,\"\",IF(OR(I$3=$E77,I$3=$F77,AND((($D77-$C77)*$H77)+$E77>=I$3,$E77<=I$3))=TRUE,1,\"\")))","v":""},{"$f":"IF(OR(J$3=$E77,J$3=$F77,AND(LEN($F77) > 0,LEN($E77) > 0,J$3>$E77,J$3<$F77)),1,IF(LEN($F77)>0,\"\",IF(OR(J$3=$E77,J$3=$F77,AND((($D77-$C77)*$H77)+$E77>=J$3,$E77<=J$3))=TRUE,1,\"\")))","v":""},{"$f":"IF(OR(K$3=$E77,K$3=$F77,AND(LEN($F77) > 0,LEN($E77) > 0,K$3>$E77,K$3<$F77)),1,IF(LEN($F77)>0,\"\",IF(OR(K$3=$E77,K$3=$F77,AND((($D77-$C77)*$H77)+$E77>=K$3,$E77<=K$3))=TRUE,1,\"\")))","v":""},"",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(BW$3=$E77,BW$3=$F77,AND(LEN($F77) > 0,LEN($E77) > 0,BW$3>$E77,BW$3<$F77)),1,IF(LEN($F77)>0,\"\",IF(OR(BW$3=$E77,BW$3=$F77,AND((($D77-$C77)*$H77)+$E77>=BW$3,$E77<=BW$3))=TRUE,1,\"\")))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(EI$3=$E77,EI$3=$F77,AND(LEN($F77) > 0,LEN($E77) > 0,EI$3>$E77,EI$3<$F77)),1,IF(LEN($F77)>0,\"\",IF(OR(EI$3=$E77,EI$3=$F77,AND((($D77-$C77)*$H77)+$E77>=EI$3,$E77<=EI$3))=TRUE,1,\"\")))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(GU$3=$E77,GU$3=$F77,AND(LEN($F77) > 0,LEN($E77) > 0,GU$3>$E77,GU$3<$F77)),1,IF(LEN($F77)>0,\"\",IF(OR(GU$3=$E77,GU$3=$F77,AND((($D77-$C77)*$H77)+$E77>=GU$3,$E77<=GU$3))=TRUE,1,\"\")))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[]
[{"$f":"A77+0.1","v":{"v":2.8000000000000007,"d":"2.8"}},"Activity-8","2011-11-06","2011-11-12","2011-11-07","2011-11-21","Completed",{"v":1,"d":"100%"},{"$f":"IF(AND(I$3>=$C81,I$3<=$D81),1,\"\")","v":""},{"$f":"IF(AND(J$3>=$C81,J$3<=$D81),1,\"\")","v":""},"",1,1,1,1,1,1,1,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AND(BV$3>=$C81,BV$3<=$D81),1,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AND(EH$3>=$C81,EH$3<=$D81),1,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AND(GT$3>=$C81,GT$3<=$D81),1,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[]
[{"$nulls":8},{"$f":"IF(OR(I$3=$E81,I$3=$F81,AND(LEN($F81) > 0,LEN($E81) > 0,I$3>$E81,I$3<$F81)),1,IF(LEN($F81)>0,\"\",IF(OR(I$3=$E81,I$3=$F81,AND((($D81-$C81)*$H81)+$E81>=I$3,$E81<=I$3))=TRUE,1,\"\")))","v":""},{"$f":"IF(OR(J$3=$E81,J$3=$F81,AND(LEN($F81) > 0,LEN($E81) > 0,J$3>$E81,J$3<$F81)),1,IF(LEN($F81)>0,\"\",IF(OR(J$3=$E81,J$3=$F81,AND((($D81-$C81)*$H81)+$E81>=J$3,$E81<=J$3))=TRUE,1,\"\")))","v":""},{"$f":"IF(OR(K$3=$E81,K$3=$F81,AND(LEN($F81) > 0,LEN($E81) > 0,K$3>$E81,K$3<$F81)),1,IF(LEN($F81)>0,\"\",IF(OR(K$3=$E81,K$3=$F81,AND((($D81-$C81)*$H81)+$E81>=K$3,$E81<=K$3))=TRUE,1,\"\")))","v":""},"",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(BW$3=$E81,BW$3=$F81,AND(LEN($F81) > 0,LEN($E81) > 0,BW$3>$E81,BW$3<$F81)),1,IF(LEN($F81)>0,\"\",IF(OR(BW$3=$E81,BW$3=$F81,AND((($D81-$C81)*$H81)+$E81>=BW$3,$E81<=BW$3))=TRUE,1,\"\")))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(EI$3=$E81,EI$3=$F81,AND(LEN($F81) > 0,LEN($E81) > 0,EI$3>$E81,EI$3<$F81)),1,IF(LEN($F81)>0,\"\",IF(OR(EI$3=$E81,EI$3=$F81,AND((($D81-$C81)*$H81)+$E81>=EI$3,$E81<=EI$3))=TRUE,1,\"\")))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(GU$3=$E81,GU$3=$F81,AND(LEN($F81) > 0,LEN($E81) > 0,GU$3>$E81,GU$3<$F81)),1,IF(LEN($F81)>0,\"\",IF(OR(GU$3=$E81,GU$3=$F81,AND((($D81-$C81)*$H81)+$E81>=GU$3,$E81<=GU$3))=TRUE,1,\"\")))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[]
[{"$f":"A81+0.1","v":{"v":2.900000000000001,"d":"2.9"}},"Activity-9","2011-11-06","2011-11-12","2011-11-07","2011-11-21","Completed",{"v":1,"d":"100%"},{"$f":"IF(AND(I$3>=$C85,I$3<=$D85),1,\"\")","v":""},{"$f":"IF(AND(J$3>=$C85,J$3<=$D85),1,\"\")","v":""},"",1,1,1,1,1,1,1,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AND(BV$3>=$C85,BV$3<=$D85),1,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AND(EH$3>=$C85,EH$3<=$D85),1,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AND(GT$3>=$C85,GT$3<=$D85),1,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[]
[{"$nulls":8},{"$f":"IF(OR(I$3=$E85,I$3=$F85,AND(LEN($F85) > 0,LEN($E85) > 0,I$3>$E85,I$3<$F85)),1,IF(LEN($F85)>0,\"\",IF(OR(I$3=$E85,I$3=$F85,AND((($D85-$C85)*$H85)+$E85>=I$3,$E85<=I$3))=TRUE,1,\"\")))","v":""},{"$f":"IF(OR(J$3=$E85,J$3=$F85,AND(LEN($F85) > 0,LEN($E85) > 0,J$3>$E85,J$3<$F85)),1,IF(LEN($F85)>0,\"\",IF(OR(J$3=$E85,J$3=$F85,AND((($D85-$C85)*$H85)+$E85>=J$3,$E85<=J$3))=TRUE,1,\"\")))","v":""},{"$f":"IF(OR(K$3=$E85,K$3=$F85,AND(LEN($F85) > 0,LEN($E85) > 0,K$3>$E85,K$3<$F85)),1,IF(LEN($F85)>0,\"\",IF(OR(K$3=$E85,K$3=$F85,AND((($D85-$C85)*$H85)+$E85>=K$3,$E85<=K$3))=TRUE,1,\"\")))","v":""},"",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(BW$3=$E85,BW$3=$F85,AND(LEN($F85) > 0,LEN($E85) > 0,BW$3>$E85,BW$3<$F85)),1,IF(LEN($F85)>0,\"\",IF(OR(BW$3=$E85,BW$3=$F85,AND((($D85-$C85)*$H85)+$E85>=BW$3,$E85<=BW$3))=TRUE,1,\"\")))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(EI$3=$E85,EI$3=$F85,AND(LEN($F85) > 0,LEN($E85) > 0,EI$3>$E85,EI$3<$F85)),1,IF(LEN($F85)>0,\"\",IF(OR(EI$3=$E85,EI$3=$F85,AND((($D85-$C85)*$H85)+$E85>=EI$3,$E85<=EI$3))=TRUE,1,\"\")))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(GU$3=$E85,GU$3=$F85,AND(LEN($F85) > 0,LEN($E85) > 0,GU$3>$E85,GU$3<$F85)),1,IF(LEN($F85)>0,\"\",IF(OR(GU$3=$E85,GU$3=$F85,AND((($D85-$C85)*$H85)+$E85>=GU$3,$E85<=GU$3))=TRUE,1,\"\")))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[]
[{"$f":"A85+0.1","v":{"v":3.000000000000001,"d":"3.0"}},"Activity-9","2011-11-06","2011-11-22","2011-11-07","2011-11-21","Completed",{"v":1,"d":"100%"},{"$f":"IF(AND(I$3>=$C89,I$3<=$D89),1,\"\")","v":""},{"$f":"IF(AND(J$3>=$C89,J$3<=$D89),1,\"\")","v":""},"",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AND(BV$3>=$C89,BV$3<=$D89),1,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AND(EH$3>=$C89,EH$3<=$D89),1,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AND(GT$3>=$C89,GT$3<=$D89),1,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[]
[{"$nulls":8},{"$f":"IF(OR(I$3=$E89,I$3=$F89,AND(LEN($F89) > 0,LEN($E89) > 0,I$3>$E89,I$3<$F89)),1,IF(LEN($F89)>0,\"\",IF(OR(I$3=$E89,I$3=$F89,AND((($D89-$C89)*$H89)+$E89>=I$3,$E89<=I$3))=TRUE,1,\"\")))","v":""},{"$f":"IF(OR(J$3=$E89,J$3=$F89,AND(LEN($F89) > 0,LEN($E89) > 0,J$3>$E89,J$3<$F89)),1,IF(LEN($F89)>0,\"\",IF(OR(J$3=$E89,J$3=$F89,AND((($D89-$C89)*$H89)+$E89>=J$3,$E89<=J$3))=TRUE,1,\"\")))","v":""},{"$f":"IF(OR(K$3=$E89,K$3=$F89,AND(LEN($F89) > 0,LEN($E89) > 0,K$3>$E89,K$3<$F89)),1,IF(LEN($F89)>0,\"\",IF(OR(K$3=$E89,K$3=$F89,AND((($D89-$C89)*$H89)+$E89>=K$3,$E89<=K$3))=TRUE,1,\"\")))","v":""},"",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(BW$3=$E89,BW$3=$F89,AND(LEN($F89) > 0,LEN($E89) > 0,BW$3>$E89,BW$3<$F89)),1,IF(LEN($F89)>0,\"\",IF(OR(BW$3=$E89,BW$3=$F89,AND((($D89-$C89)*$H89)+$E89>=BW$3,$E89<=BW$3))=TRUE,1,\"\")))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(EI$3=$E89,EI$3=$F89,AND(LEN($F89) > 0,LEN($E89) > 0,EI$3>$E89,EI$3<$F89)),1,IF(LEN($F89)>0,\"\",IF(OR(EI$3=$E89,EI$3=$F89,AND((($D89-$C89)*$H89)+$E89>=EI$3,$E89<=EI$3))=TRUE,1,\"\")))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(GU$3=$E89,GU$3=$F89,AND(LEN($F89) > 0,LEN($E89) > 0,GU$3>$E89,GU$3<$F89)),1,IF(LEN($F89)>0,\"\",IF(OR(GU$3=$E89,GU$3=$F89,AND((($D89-$C89)*$H89)+$E89>=GU$3,$E89<=GU$3))=TRUE,1,\"\")))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]