{"text_format":"3","workbook":"xlsx","n_sheets":6,"sheets":["Gantt","Dashboard","Calc","Settings","Help","Key Features"],"not_rendered":{"charts":6,"images":9,"macros":1,"defined_names":25,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"Gantt","index":0,"n_rows":23,"n_cols":47,"rows_kept":23,"merged":[[5,16,5,17],[7,7,7,9]]}
[{"$nulls":16},{"$f":"Show_from+Settings!$Q$5","v":45505},{"$f":"Q1+Days_per_cell","v":45506},45507,45508,45509,45510,45511,45512,45513,45514,45515,45516,45517,45518,45519,45520,45521,45522,45523,45524,45525,45526,45527,45528,45529,45530,45531,45532,45533,45534,45535]
[{"$nulls":17},{"$f":"IF(YEAR(Q1)<>YEAR(R1),R1,\"\")","v":""},{"$f":"IF(YEAR(R1)<>YEAR(S1),S1,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[]
[null,null,"Project Name","Olympic 2024"]
[null,null,"Project Lead","Template22"]
[null,null,"Project Start Date",{"$f":"MIN(M10:M23)","v":"2024-08-01"},{"$nulls":12},{"$f":"IF(YEAR(P1)<>YEAR(Q1),Q1,\"\")","v":"2024-08-01"}]
[null,null,"Project Completion Date",{"$f":"MAX(N10:N23)","v":"2024-09-01"},{"$nulls":12},{"$f":"IF(MONTH(P1)<>MONTH(Q1),Q1,\"\")","v":"2024-08-01"},{"$f":"IF(MONTH(Q1)<>MONTH(R1),R1,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[{"$nulls":4},"Duration",null,"Actual","Status",null,null,"Dependency",null,"Duration",{"$nulls":3},{"$f":"LEFT(TEXT(Q1,\"ddd\"),1)","v":"T"},{"$f":"LEFT(TEXT(R1,\"ddd\"),1)","v":"F"},"S","S","M","T","W","T","F","S","S","M","T","W","T","F","S","S","M","T","W","T","F","S","S","M","T","W","T","F","S"]
["Sr. #","Type","Task","Resource","Total","Remai-\nning","Cost","Done","% Prog","On Track","D-Type","Manual Date","Start","Finish","Done Until",null,{"$f":"Q1","v":"2024-08-01"},"2024-08-02","2024-08-03","2024-08-04","2024-08-05","2024-08-06","2024-08-07","2024-08-08","2024-08-09","2024-08-10","2024-08-11","2024-08-12","2024-08-13","2024-08-14","2024-08-15","2024-08-16","2024-08-17","2024-08-18","2024-08-19","2024-08-20","2024-08-21","2024-08-22","2024-08-23","2024-08-24","2024-08-25","2024-08-26","2024-08-27","2024-08-28","2024-08-29","2024-08-30","2024-08-31"]
[{"$f":"ROW()-ROW($A$9)","v":1},"T","Meet Client","Person 1",2,1,{"v":150,"d":" $150"},{"$f":"IF(E10=\"\",\"\",E10-F10)","v":1},{"$f":"IF(H10=\"\",\"\",H10/E10)","v":{"v":0.5,"d":"50%"}},{"$f":"IF(AND(GanttT[[#This Row],[Type]]=\"M\",N10<Today,GanttT[[#This Row],[Remai-\nning]]>0),Cross,IF(AND(O10<Today,GanttT[[#This Row],[Remai-\nning]]>0),Cross,IF(C10<>\"\",Tick,\"\")))","v":"û"},"Manual","2024-08-01",{"$f":"IF(GanttT[[#This Row],[Type]]=\"M\",GanttT[[#This Row],[Manual Date]],IF(K10=\"\",\"\",IF(K10=\"After\",N9+1,IF(K10=\"Same\",M9,L10))))","v":"2024-08-01"},{"$f":"IF(GanttT[[#This Row],[Type]]=\"M\",GanttT[[#This Row],[Manual Date]],IF(K10=\"\",\"\",IF(Weekend_work=\"No\",WORKDAY(M10,E10)-1,M10+E10-1)))","v":"2024-08-04"},{"$f":"IF(GanttT[[#This Row],[Type]]=\"M\",\"\",IF(K10=\"\",\"\",IF(Weekend_work=\"No\",WORKDAY(M10,H10)-1,M10+H10-1)))","v":"2024-08-01"},null,{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""}]
[{"$f":"ROW()-ROW($A$9)","v":2},"T","Requirements","Person 2",2,0,{"v":140,"d":" $140"},{"$f":"IF(E11=\"\",\"\",E11-F11)","v":2},{"$f":"IF(H11=\"\",\"\",H11/E11)","v":{"v":1,"d":"100%"}},{"$f":"IF(AND(GanttT[[#This Row],[Type]]=\"M\",N11<Today,GanttT[[#This Row],[Remai-\nning]]>0),Cross,IF(AND(O11<Today,GanttT[[#This Row],[Remai-\nning]]>0),Cross,IF(C11<>\"\",Tick,\"\")))","v":"ü"},"Same",null,{"$f":"IF(GanttT[[#This Row],[Type]]=\"M\",GanttT[[#This Row],[Manual Date]],IF(K11=\"\",\"\",IF(K11=\"After\",N10+1,IF(K11=\"Same\",M10,L11))))","v":"2024-08-01"},{"$f":"IF(GanttT[[#This Row],[Type]]=\"M\",GanttT[[#This Row],[Manual Date]],IF(K11=\"\",\"\",IF(Weekend_work=\"No\",WORKDAY(M11,E11)-1,M11+E11-1)))","v":"2024-08-04"},{"$f":"IF(GanttT[[#This Row],[Type]]=\"M\",\"\",IF(K11=\"\",\"\",IF(Weekend_work=\"No\",WORKDAY(M11,H11)-1,M11+H11-1)))","v":"2024-08-04"},null,{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""}]
[3,"T","Inputs","Person 3",1,1,{"v":200,"d":" $200"},{"$f":"IF(E12=\"\",\"\",E12-F12)","v":0},{"$f":"IF(H12=\"\",\"\",H12/E12)","v":{"v":0,"d":"0%"}},{"$f":"IF(AND(GanttT[[#This Row],[Type]]=\"M\",N12<Today,GanttT[[#This Row],[Remai-\nning]]>0),Cross,IF(AND(O12<Today,GanttT[[#This Row],[Remai-\nning]]>0),Cross,IF(C12<>\"\",Tick,\"\")))","v":"û"},"After",null,{"$f":"IF(GanttT[[#This Row],[Type]]=\"M\",GanttT[[#This Row],[Manual Date]],IF(K12=\"\",\"\",IF(K12=\"After\",N11+1,IF(K12=\"Same\",M11,L12))))","v":"2024-08-05"},{"$f":"IF(GanttT[[#This Row],[Type]]=\"M\",GanttT[[#This Row],[Manual Date]],IF(K12=\"\",\"\",IF(Weekend_work=\"No\",WORKDAY(M12,E12)-1,M12+E12-1)))","v":"2024-08-05"},{"$f":"IF(GanttT[[#This Row],[Type]]=\"M\",\"\",IF(K12=\"\",\"\",IF(Weekend_work=\"No\",WORKDAY(M12,H12)-1,M12+H12-1)))","v":"2024-08-04"},null,{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""}]
[4,"T","Design","Person 4",5,0,{"v":180,"d":" $180"},5,{"v":1,"d":"100%"},{"$f":"IF(AND(GanttT[[#This Row],[Type]]=\"M\",N13<Today,GanttT[[#This Row],[Remai-\nning]]>0),Cross,IF(AND(O13<Today,GanttT[[#This Row],[Remai-\nning]]>0),Cross,IF(C13<>\"\",Tick,\"\")))","v":"ü"},"After",null,{"$f":"IF(GanttT[[#This Row],[Type]]=\"M\",GanttT[[#This Row],[Manual Date]],IF(K13=\"\",\"\",IF(K13=\"After\",N12+1,IF(K13=\"Same\",M12,L13))))","v":"2024-08-06"},{"$f":"IF(GanttT[[#This Row],[Type]]=\"M\",GanttT[[#This Row],[Manual Date]],IF(K13=\"\",\"\",IF(Weekend_work=\"No\",WORKDAY(M13,E13)-1,M13+E13-1)))","v":"2024-08-12"},{"$f":"IF(GanttT[[#This Row],[Type]]=\"M\",\"\",IF(K13=\"\",\"\",IF(Weekend_work=\"No\",WORKDAY(M13,H13)-1,M13+H13-1)))","v":"2024-08-12"},null,{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""}]
[5,"M","Project Testing",null,{"$f":"SUM(E10:E13)","v":10},{"$f":"SUM(F10:F13)","v":2},{"$f":"SUM(G10:G13)","v":{"v":670,"d":" $670"}},8,{"v":0.8,"d":"80%"},{"$f":"IF(AND(GanttT[[#This Row],[Type]]=\"M\",N14<Today,GanttT[[#This Row],[Remai-\nning]]>0),Cross,IF(AND(O14<Today,GanttT[[#This Row],[Remai-\nning]]>0),Cross,IF(C14<>\"\",Tick,\"\")))","v":"û"},"Manual","2024-08-12",{"$f":"IF(GanttT[[#This Row],[Type]]=\"M\",GanttT[[#This Row],[Manual Date]],IF(K14=\"\",\"\",IF(K14=\"After\",N13+1,IF(K14=\"Same\",M13,L14))))","v":"2024-08-12"},{"$f":"IF(GanttT[[#This Row],[Type]]=\"M\",GanttT[[#This Row],[Manual Date]],IF(K14=\"\",\"\",IF(Weekend_work=\"No\",WORKDAY(M14,E14)-1,M14+E14-1)))","v":"2024-08-12"},{"$f":"IF(GanttT[[#This Row],[Type]]=\"M\",\"\",IF(K14=\"\",\"\",IF(Weekend_work=\"No\",WORKDAY(M14,H14)-1,M14+H14-1)))","v":""},null,{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":"♦"},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""}]
[6,"T","Process","Person 2",3,2,{"v":300,"d":" $300"},1,{"v":0.3333333333333333,"d":"33%"},{"$f":"IF(AND(GanttT[[#This Row],[Type]]=\"M\",N15<Today,GanttT[[#This Row],[Remai-\nning]]>0),Cross,IF(AND(O15<Today,GanttT[[#This Row],[Remai-\nning]]>0),Cross,IF(C15<>\"\",Tick,\"\")))","v":"û"},"After",null,{"$f":"IF(GanttT[[#This Row],[Type]]=\"M\",GanttT[[#This Row],[Manual Date]],IF(K15=\"\",\"\",IF(K15=\"After\",N14+1,IF(K15=\"Same\",M14,L15))))","v":"2024-08-13"},{"$f":"IF(GanttT[[#This Row],[Type]]=\"M\",GanttT[[#This Row],[Manual Date]],IF(K15=\"\",\"\",IF(Weekend_work=\"No\",WORKDAY(M15,E15)-1,M15+E15-1)))","v":"2024-08-15"},{"$f":"IF(GanttT[[#This Row],[Type]]=\"M\",\"\",IF(K15=\"\",\"\",IF(Weekend_work=\"No\",WORKDAY(M15,H15)-1,M15+H15-1)))","v":"2024-08-13"},null,{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""}]
[7,"T","Design","Person 4",2,1,{"v":190,"d":" $190"},1,{"v":0.5,"d":"50%"},{"$f":"IF(AND(GanttT[[#This Row],[Type]]=\"M\",N16<Today,GanttT[[#This Row],[Remai-\nning]]>0),Cross,IF(AND(O16<Today,GanttT[[#This Row],[Remai-\nning]]>0),Cross,IF(C16<>\"\",Tick,\"\")))","v":"û"},"Same",null,{"$f":"IF(GanttT[[#This Row],[Type]]=\"M\",GanttT[[#This Row],[Manual Date]],IF(K16=\"\",\"\",IF(K16=\"After\",N15+1,IF(K16=\"Same\",M15,L16))))","v":"2024-08-13"},{"$f":"IF(GanttT[[#This Row],[Type]]=\"M\",GanttT[[#This Row],[Manual Date]],IF(K16=\"\",\"\",IF(Weekend_work=\"No\",WORKDAY(M16,E16)-1,M16+E16-1)))","v":"2024-08-14"},{"$f":"IF(GanttT[[#This Row],[Type]]=\"M\",\"\",IF(K16=\"\",\"\",IF(Weekend_work=\"No\",WORKDAY(M16,H16)-1,M16+H16-1)))","v":"2024-08-13"},null,{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""}]
[8,"T","Data model","Person 3",8,3,{"v":200,"d":" $200"},5,{"v":0.625,"d":"63%"},{"$f":"IF(AND(GanttT[[#This Row],[Type]]=\"M\",N17<Today,GanttT[[#This Row],[Remai-\nning]]>0),Cross,IF(AND(O17<Today,GanttT[[#This Row],[Remai-\nning]]>0),Cross,IF(C17<>\"\",Tick,\"\")))","v":"û"},"Manual","2024-08-06",{"$f":"IF(GanttT[[#This Row],[Type]]=\"M\",GanttT[[#This Row],[Manual Date]],IF(K17=\"\",\"\",IF(K17=\"After\",N16+1,IF(K17=\"Same\",M16,L17))))","v":"2024-08-06"},{"$f":"IF(GanttT[[#This Row],[Type]]=\"M\",GanttT[[#This Row],[Manual Date]],IF(K17=\"\",\"\",IF(Weekend_work=\"No\",WORKDAY(M17,E17)-1,M17+E17-1)))","v":"2024-08-15"},{"$f":"IF(GanttT[[#This Row],[Type]]=\"M\",\"\",IF(K17=\"\",\"\",IF(Weekend_work=\"No\",WORKDAY(M17,H17)-1,M17+H17-1)))","v":"2024-08-12"},null,{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""}]
[9,"M","Project Deliver",null,{"$f":"SUM(E15:E17)","v":13},{"$f":"SUM(F15:F17)","v":6},{"$f":"SUM(G15:G17)","v":{"v":690,"d":" $690"}},7,{"v":0.5384615384615384,"d":"54%"},{"$f":"IF(AND(GanttT[[#This Row],[Type]]=\"M\",N18<Today,GanttT[[#This Row],[Remai-\nning]]>0),Cross,IF(AND(O18<Today,GanttT[[#This Row],[Remai-\nning]]>0),Cross,IF(C18<>\"\",Tick,\"\")))","v":"û"},"Manual","2024-08-15",{"$f":"IF(GanttT[[#This Row],[Type]]=\"M\",GanttT[[#This Row],[Manual Date]],IF(K18=\"\",\"\",IF(K18=\"After\",N17+1,IF(K18=\"Same\",M17,L18))))","v":"2024-08-15"},{"$f":"IF(GanttT[[#This Row],[Type]]=\"M\",GanttT[[#This Row],[Manual Date]],IF(K18=\"\",\"\",IF(Weekend_work=\"No\",WORKDAY(M18,E18)-1,M18+E18-1)))","v":"2024-08-15"},{"$f":"IF(GanttT[[#This Row],[Type]]=\"M\",\"\",IF(K18=\"\",\"\",IF(Weekend_work=\"No\",WORKDAY(M18,H18)-1,M18+H18-1)))","v":""},null,{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":"♦"},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""}]
[{"$f":"ROW()-ROW($A$9)","v":10},"T","Define server","Person 10",4,3,{"v":340,"d":" $340"},{"$f":"IF(E19=\"\",\"\",E19-F19)","v":1},{"$f":"IF(H19=\"\",\"\",H19/E19)","v":{"v":0.25,"d":"25%"}},{"$f":"IF(AND(GanttT[[#This Row],[Type]]=\"M\",N19<Today,GanttT[[#This Row],[Remai-\nning]]>0),Cross,IF(AND(O19<Today,GanttT[[#This Row],[Remai-\nning]]>0),Cross,IF(C19<>\"\",Tick,\"\")))","v":"û"},"After",null,{"$f":"IF(GanttT[[#This Row],[Type]]=\"M\",GanttT[[#This Row],[Manual Date]],IF(K19=\"\",\"\",IF(K19=\"After\",N18+1,IF(K19=\"Same\",M18,L19))))","v":"2024-08-16"},{"$f":"IF(GanttT[[#This Row],[Type]]=\"M\",GanttT[[#This Row],[Manual Date]],IF(K19=\"\",\"\",IF(Weekend_work=\"No\",WORKDAY(M19,E19)-1,M19+E19-1)))","v":"2024-08-21"},{"$f":"IF(GanttT[[#This Row],[Type]]=\"M\",\"\",IF(K19=\"\",\"\",IF(Weekend_work=\"No\",WORKDAY(M19,H19)-1,M19+H19-1)))","v":"2024-08-18"},null,{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""}]
[{"$f":"ROW()-ROW($A$9)","v":11},"T","Configure server","Person 8",1,1,{"v":200,"d":" $200"},{"$f":"IF(E20=\"\",\"\",E20-F20)","v":0},{"$f":"IF(H20=\"\",\"\",H20/E20)","v":{"v":0,"d":"0%"}},{"$f":"IF(AND(GanttT[[#This Row],[Type]]=\"M\",N20<Today,GanttT[[#This Row],[Remai-\nning]]>0),Cross,IF(AND(O20<Today,GanttT[[#This Row],[Remai-\nning]]>0),Cross,IF(C20<>\"\",Tick,\"\")))","v":"û"},"After",null,{"$f":"IF(GanttT[[#This Row],[Type]]=\"M\",GanttT[[#This Row],[Manual Date]],IF(K20=\"\",\"\",IF(K20=\"After\",N19+1,IF(K20=\"Same\",M19,L20))))","v":"2024-08-22"},{"$f":"IF(GanttT[[#This Row],[Type]]=\"M\",GanttT[[#This Row],[Manual Date]],IF(K20=\"\",\"\",IF(Weekend_work=\"No\",WORKDAY(M20,E20)-1,M20+E20-1)))","v":"2024-08-22"},{"$f":"IF(GanttT[[#This Row],[Type]]=\"M\",\"\",IF(K20=\"\",\"\",IF(Weekend_work=\"No\",WORKDAY(M20,H20)-1,M20+H20-1)))","v":"2024-08-21"},null,{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""}]
[{"$f":"ROW()-ROW($A$9)","v":12},"T","Task 7","Person 2",3,2,{"v":230,"d":" $230"},{"$f":"IF(E21=\"\",\"\",E21-F21)","v":1},{"$f":"IF(H21=\"\",\"\",H21/E21)","v":{"v":0.3333333333333333,"d":"33%"}},{"$f":"IF(AND(GanttT[[#This Row],[Type]]=\"M\",N21<Today,GanttT[[#This Row],[Remai-\nning]]>0),Cross,IF(AND(O21<Today,GanttT[[#This Row],[Remai-\nning]]>0),Cross,IF(C21<>\"\",Tick,\"\")))","v":"û"},"Same",null,{"$f":"IF(GanttT[[#This Row],[Type]]=\"M\",GanttT[[#This Row],[Manual Date]],IF(K21=\"\",\"\",IF(K21=\"After\",N20+1,IF(K21=\"Same\",M20,L21))))","v":"2024-08-22"},{"$f":"IF(GanttT[[#This Row],[Type]]=\"M\",GanttT[[#This Row],[Manual Date]],IF(K21=\"\",\"\",IF(Weekend_work=\"No\",WORKDAY(M21,E21)-1,M21+E21-1)))","v":"2024-08-26"},{"$f":"IF(GanttT[[#This Row],[Type]]=\"M\",\"\",IF(K21=\"\",\"\",IF(Weekend_work=\"No\",WORKDAY(M21,H21)-1,M21+H21-1)))","v":"2024-08-22"},null,{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""}]
[{"$f":"ROW()-ROW($A$9)","v":13},"M","Project Completion",null,{"$f":"SUM(E19:E21)","v":8},{"$f":"SUM(F19:F21)","v":6},{"$f":"SUM(G19:G21)","v":{"v":770,"d":" $770"}},{"$f":"IF(E22=\"\",\"\",E22-F22)","v":2},{"$f":"IF(H22=\"\",\"\",H22/E22)","v":{"v":0.25,"d":"25%"}},{"$f":"IF(AND(GanttT[[#This Row],[Type]]=\"M\",N22<Today,GanttT[[#This Row],[Remai-\nning]]>0),Cross,IF(AND(O22<Today,GanttT[[#This Row],[Remai-\nning]]>0),Cross,IF(C22<>\"\",Tick,\"\")))","v":"û"},"Manual","2024-08-26",{"$f":"IF(GanttT[[#This Row],[Type]]=\"M\",GanttT[[#This Row],[Manual Date]],IF(K22=\"\",\"\",IF(K22=\"After\",N21+1,IF(K22=\"Same\",M21,L22))))","v":"2024-08-26"},{"$f":"IF(GanttT[[#This Row],[Type]]=\"M\",GanttT[[#This Row],[Manual Date]],IF(K22=\"\",\"\",IF(Weekend_work=\"No\",WORKDAY(M22,E22)-1,M22+E22-1)))","v":"2024-08-26"},{"$f":"IF(GanttT[[#This Row],[Type]]=\"M\",\"\",IF(K22=\"\",\"\",IF(Weekend_work=\"No\",WORKDAY(M22,H22)-1,M22+H22-1)))","v":""},null,{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":"♦"},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""}]
[{"$f":"ROW()-ROW($A$9)","v":14},"T","Prepare PROD","Person 8",4,1,{"v":200,"d":" $200"},{"$f":"IF(E23=\"\",\"\",E23-F23)","v":3},{"$f":"IF(H23=\"\",\"\",H23/E23)","v":{"v":0.75,"d":"75%"}},{"$f":"IF(AND(GanttT[[#This Row],[Type]]=\"M\",N23<Today,GanttT[[#This Row],[Remai-\nning]]>0),Cross,IF(AND(O23<Today,GanttT[[#This Row],[Remai-\nning]]>0),Cross,IF(C23<>\"\",Tick,\"\")))","v":"û"},"Manual","2024-08-27",{"$f":"IF(GanttT[[#This Row],[Type]]=\"M\",GanttT[[#This Row],[Manual Date]],IF(K23=\"\",\"\",IF(K23=\"After\",N22+1,IF(K23=\"Same\",M22,L23))))","v":"2024-08-27"},{"$f":"IF(GanttT[[#This Row],[Type]]=\"M\",GanttT[[#This Row],[Manual Date]],IF(K23=\"\",\"\",IF(Weekend_work=\"No\",WORKDAY(M23,E23)-1,M23+E23-1)))","v":"2024-09-01"},{"$f":"IF(GanttT[[#This Row],[Type]]=\"M\",\"\",IF(K23=\"\",\"\",IF(Weekend_work=\"No\",WORKDAY(M23,H23)-1,M23+H23-1)))","v":"2024-08-29"},null,{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""},{"$f":"M_Stone","v":""}]

{"sheet":"Dashboard","index":1,"n_rows":13,"n_cols":18,"rows_kept":13,"merged":[[1,9,2,14],[2,17,2,18],[4,2,4,3],[6,2,6,3],[8,2,8,3],[8,4,8,5],[10,2,10,3],[10,4,10,5],[12,2,12,3],[12,4,14,5]]}
[]
[{"$nulls":9},"Project Dashboard"]
[{"$nulls":17},{"$f":"TODAY()","v":"2024-11-27"}]
[]
[null,null,"Project Name",null,{"$f":"+Gantt!D4","v":"Olympic 2024"}]
[]
[null,null,"Project Lead",null,{"$f":"+Gantt!D5","v":"Template22"}]
[]
[null,null,"Start Date",null,{"$f":"+Gantt!D6","v":"2024-08-01"}]
[]
[null,null,"End Date",null,{"$f":"+Gantt!D7","v":"2024-09-01"}]
[]
[null,null,"On Track",null,{"$f":"Calc!AL5","v":"12 items in Tasks and Milestones are overdue."}]

{"sheet":"Calc","index":2,"n_rows":15,"n_cols":45,"rows_kept":15,"merged":[[3,15,3,16]]}
[]
[]
[null,"Project Cost",{"$nulls":7},"Progress",{"$nulls":4},"Resources",{"$nulls":3},"Task Status",{"$nulls":3},"Overdue Tasks",{"$nulls":6},"Overdue Milestones",{"$nulls":7},"Total Overdue",{"$nulls":5},"Project Duration"]
[null,"Budget","Actual","% Spent",{"$nulls":6},"Completed","Remaining",{"$nulls":3},"Workload",{"$nulls":27},{"$f":"MIN(GanttT[Start])","v":"2024-08-01"},{"$f":"MAX(GanttT[Finish])","v":"2024-09-01"}]
[null,{"$f":"Settings!B12","v":{"v":5500,"d":" $5,500"}},{"$f":"SUMIF(GanttT[Type],\"T\",GanttT[Cost])","v":{"v":2330,"d":" $2,330"}},{"$f":"TEXT(C5/B5,\"0%\")&\" Consumed\"","v":"42% Consumed"},{"$f":"IF(B5<1000, B5, IF(AND(B5>=1000, B5<100000), TEXT(B5/1000, \"#,##.0\") & \" K\", IF(B5>=1000000, TEXT(B5/1000000, \"#,##.0\") & \" M\", \"\")))","v":"5.5 K"},{"$f":"\"Total Budget: \"&TEXT(E5,\"$ #,##\")","v":"Total Budget: 5.5 K"},{"$nulls":3},{"v":1,"d":"100%"},{"$f":"AVERAGEIF(GanttT[Type],\"T\",GanttT[% Prog])","v":{"v":0.4810606060606061,"d":"48%"}},{"$f":"J5-K5","v":{"v":0.5189393939393939,"d":"52%"}},null,null,0,{"$f":"IFERROR(VLOOKUP(Calc!O5,ResourceT[],2,0),\"\")","v":""},"Tasks",null,"Completed","In Progress","Not Started",null,"Total Tasks","Overdue Tasks",{"$nulls":5},"Total Milestones","Overdue Milestones",{"$nulls":6},{"$f":"IF(AND(X6>0,AE6>0),X6+AE6&\" items in Tasks and Milestones are overdue.\",IF(AND(X6>0,AE6=0),Y6,IF(AND(X6=0,AE6>0),AF6,\"All Tasks and Milestones are on track!\")))","v":"12 items in Tasks and Milestones are overdue."}]
[{"$nulls":14},{"$f":"O5+1","v":1},{"$f":"IFERROR(VLOOKUP(Calc!O6,ResourceT[],2,0),\"\")","v":"Person 1"},{"$f":"COUNTIFS(GanttT[Resource],Calc!P6,GanttT[Type],\"T\")","v":1},null,{"$f":"COUNTIFS(GanttT[% Prog],\"=\"&100%,GanttT[Type],\"T\")","v":2},{"$f":"COUNTIFS(GanttT[Type],\"T\",GanttT[% Prog],\">=\"&1%,GanttT[% Prog],\"<\"&100%)","v":7},{"$f":"COUNTIFS(GanttT[% Prog],\"=\"&0,GanttT[Type],\"T\")","v":2},null,{"$f":"COUNTIF(GanttT[Type],\"T\")","v":11},{"$f":"COUNTIFS(GanttT[Type],\"T\",GanttT[Done Until],\"<=\"&Today,GanttT[Remai-\nning],\">\"&0,GanttT[On Track],\"=\"&Cross)","v":9},{"$f":"X6&\" Out of \"&W6&\" Tasks are Overdue\"","v":"9 Out of 11 Tasks are Overdue"},{"$nulls":4},{"$f":"COUNTIFS(GanttT[Type],\"M\")","v":3},{"$f":"COUNTIFS(GanttT[Type],\"M\",GanttT[Finish],\"<=\"&TODAY())","v":3},{"$f":"AE6&\" Out of \"&AD6&\" Milestones are Overdue\"","v":"3 Out of 3 Milestones are Overdue"}]
[{"$nulls":14},{"$f":"O6+1","v":2},{"$f":"IFERROR(VLOOKUP(Calc!O7,ResourceT[],2,0),\"\")","v":"Person 2"},{"$f":"COUNTIFS(GanttT[Resource],Calc!P7,GanttT[Type],\"T\")","v":3}]
[{"$nulls":14},3,{"$f":"IFERROR(VLOOKUP(Calc!O8,ResourceT[],2,0),\"\")","v":"Person 3"},{"$f":"COUNTIFS(GanttT[Resource],Calc!P8,GanttT[Type],\"T\")","v":2}]
[{"$nulls":14},4,{"$f":"IFERROR(VLOOKUP(Calc!O9,ResourceT[],2,0),\"\")","v":"Person 4"},{"$f":"COUNTIFS(GanttT[Resource],Calc!P9,GanttT[Type],\"T\")","v":2}]
[{"$nulls":14},5,{"$f":"IFERROR(VLOOKUP(Calc!O10,ResourceT[],2,0),\"\")","v":"Person 5"},{"$f":"COUNTIFS(GanttT[Resource],Calc!P10,GanttT[Type],\"T\")","v":0}]
[{"$nulls":14},6,{"$f":"IFERROR(VLOOKUP(Calc!O11,ResourceT[],2,0),\"\")","v":"Person 6"},{"$f":"COUNTIFS(GanttT[Resource],Calc!P11,GanttT[Type],\"T\")","v":0}]
[{"$nulls":14},7,{"$f":"IFERROR(VLOOKUP(Calc!O12,ResourceT[],2,0),\"\")","v":"Person 7"},{"$f":"COUNTIFS(GanttT[Resource],Calc!P12,GanttT[Type],\"T\")","v":0}]
[{"$nulls":14},8,{"$f":"IFERROR(VLOOKUP(Calc!O13,ResourceT[],2,0),\"\")","v":"Person 8"},{"$f":"COUNTIFS(GanttT[Resource],Calc!P13,GanttT[Type],\"T\")","v":2}]
[{"$nulls":14},9,{"$f":"IFERROR(VLOOKUP(Calc!O14,ResourceT[],2,0),\"\")","v":"Person 9"},{"$f":"COUNTIFS(GanttT[Resource],Calc!P14,GanttT[Type],\"T\")","v":0}]
[{"$nulls":14},10,{"$f":"IFERROR(VLOOKUP(Calc!O15,ResourceT[],2,0),\"\")","v":"Person 10"},{"$f":"COUNTIFS(GanttT[Resource],Calc!P15,GanttT[Type],\"T\")","v":1}]

{"sheet":"Settings","index":3,"n_rows":30,"n_cols":41,"rows_kept":30}
[null,"DO NOT INSERT ROWS AND COLUMNS IN THIS SHEET, CALCULATION AND ADJUSTMENTS MAY BE DISTURBED.",{"$nulls":23},"Below are Excel Tables. So if you need to delete a ROW in the table, Select the required table and Right Click > Delete > Delete Row OR Delete Column"]
[null,"SCROL THROUGH RIGHT TO SEE MORE TABLES TO BE UPDATED AS PER REQUIREMENT",{"$nulls":23},"If you Delete in traditional way, it will DELETE OTHER INFORMATION ON THIS SHEET. Be careful!!"]
[null,"Update Company Name and Project Name below",null,"Do not change or delete below info",{"$nulls":6},"Do not change or delete below info",{"$nulls":4},"Do not change or delete below info",{"$nulls":9},"Update below tables as per requirement",{"$nulls":11},"Update Holidays accordingly"]
[{"$nulls":15},"You may change the values in Grey Cells only"]
[{"$nulls":10},"Named Cells",{"$nulls":5},0,{"$nulls":8},"Lists",{"$nulls":11},"Holidays"]
[{"$nulls":3},"Validations",{"$nulls":6},"Normal","Webding","Name",null,null,"Preferences","Value","Cell Name","Explanation",{"$nulls":6},"Milestones",null,"Task",null,null,"Sr #","Resource","Leave From","Leave To",{"$nulls":3},"Date","Holidays & [Observances]"]
[null,"Olympic International",null,"Dependency with task before","Task Table",{"$nulls":6},"ü","Tick",null,null,"Today's Date",{"$f":"TODAY()","v":"2024-11-27"},"Today","Can be hardcoded",{"$nulls":6},"Define Problem",null,"Meet Client",null,null,{"$f":"ROW(ResourceT[[#Headers],[Sr '#]])+ROW()-12","v":1},"Person 1","2024-04-10","15-04-2024",{"$nulls":3},"2024-01-01","New Year's Day"]
[null,"Project Planning Tool",null,"Manual","Independent task -  will b set manually",{"$nulls":6},"û","Cross",null,null,"Work on weekends","No","Weekend_work","Used to calculate task completion",{"$nulls":6},"Produce the Plan",null,"Requirements",null,null,{"$f":"ROW(ResourceT[[#Headers],[Sr '#]])+ROW()-12","v":2},"Person 2",{"$nulls":5},"2024-01-18","Martin Luther King Day"]
[null,{"$f":"B7&CHAR(10)&B8","v":"Olympic International\nProject Planning Tool"},null,"After","After previous task",{"$nulls":6},"♦","Open Milestone",null,null,"Show schedule from",{"$f":"MIN(GanttT[Manual Date])","v":"2024-08-01"},"Show_from","When the Gantt chart will start - will start week on that day",{"$nulls":6},"Resource Planning",null,"Process",null,null,{"$f":"ROW(ResourceT[[#Headers],[Sr '#]])+ROW()-12","v":3},"Person 3",{"$nulls":5},"2024-02-02","Groundhog Day"]
[{"$nulls":3},"Same","Same as previous task",{"$nulls":6},"⚑","Completed Milestone",null,null,"Days per cell",{"v":1,"d":"1 day(s)"},"Days_per_cell","How many days a cell represents (30 for monthly)",{"$nulls":6},"Project Development",null,"Inputs",null,null,{"$f":"ROW(ResourceT[[#Headers],[Sr '#]])+ROW()-12","v":4},"Person 4",{"$nulls":5},"2024-02-12","Lincoln's Birthday"]
[null,"Put Budget amount below",{"$nulls":13},"Show grid ?","No","Show_grid","Horizontal lines",{"$nulls":6},"Project Testing",null,"Design",null,null,{"$f":"ROW(ResourceT[[#Headers],[Sr '#]])+ROW()-12","v":5},"Person 5","2024-05-14","22-05-2024",{"$nulls":3},"2024-02-14","Valentine's Day"]
[null,{"v":5500,"d":"$5,500"},{"$nulls":13},"How today on tasks","Yes","Show_today","For day view only",{"$nulls":6},"Project Launch",null,"Define server",null,null,{"$f":"ROW(ResourceT[[#Headers],[Sr '#]])+ROW()-12","v":6},"Person 6",{"$nulls":5},"2024-02-15","Presidents' Day"]
[{"$nulls":25},"Project Deliver",null,"Configure server",null,null,{"$f":"ROW(ResourceT[[#Headers],[Sr '#]])+ROW()-12","v":7},"Person 7","2024-04-03","2024-04-06",{"$nulls":3},"2024-03-17","Saint Patrick's Day"]
[{"$nulls":3},"Yes / No",{"$nulls":21},"Project Management",null,"Data model",null,null,{"$f":"ROW(ResourceT[[#Headers],[Sr '#]])+ROW()-12","v":8},"Person 8",{"$nulls":5},"2024-03-27","Easter Day"]
[{"$nulls":3},"Yes",{"$nulls":21},"Project Completion",null,"Prepare UAT",null,null,{"$f":"ROW(ResourceT[[#Headers],[Sr '#]])+ROW()-12","v":9},"Person 9",{"$nulls":5},"2024-04-15","Tax Day"]
[{"$nulls":3},"No",{"$nulls":21},"Plan",null,"Prepare PROD",null,null,{"$f":"ROW(ResourceT[[#Headers],[Sr '#]])+ROW()-12","v":10},"Person 10",{"$nulls":5},"2024-04-27","Administrative Professionals Day"]
[{"$nulls":25},"Governance",null,"Prepare Plan",null,null,{"$f":"ROW(ResourceT[[#Headers],[Sr '#]])+ROW()-12","v":11},"Person 11",{"$nulls":5},"2024-05-08","Mother's Day"]
[{"$nulls":25},"Training",null,"Task 1",null,null,{"$f":"ROW(ResourceT[[#Headers],[Sr '#]])+ROW()-12","v":12},"Person 12",{"$nulls":5},"2024-05-30","Memorial Day"]
[{"$nulls":25},"Coding",null,"Task 2",null,null,{"$f":"ROW(ResourceT[[#Headers],[Sr '#]])+ROW()-12","v":13},"Person 13",{"$nulls":5},"2024-06-14","Flag Day"]
[{"$nulls":25},"Implement",null,"Task 3",{"$nulls":9},"2024-06-19","Father's Day"]
[{"$nulls":25},"Test",null,"Task 4",{"$nulls":9},"2024-07-04","Independence Day"]
[{"$nulls":25},"Live",null,"Task 5",{"$nulls":9},"2024-08-05","Labor Day",null,"Date Changed for validation purpose"]
[{"$nulls":25},"Manage",null,"Task 6",{"$nulls":9},"2024-10-10","Columbus Day"]
[{"$nulls":27},"Task 7",{"$nulls":9},"2024-10-31","Halloween"]
[{"$nulls":37},"2024-11-01","Election Day"]
[{"$nulls":37},"2024-11-11","Veteran's Day"]
[{"$nulls":37},"2024-11-24","Thanksgiving Day"]
[{"$nulls":37},"2024-12-24","Christmas Eve"]
[{"$nulls":37},"2024-12-25","Christmas Day"]
[{"$nulls":37},"2024-12-31","New Year's Eve"]

{"sheet":"Help","index":4,"n_rows":116,"n_cols":6,"rows_kept":116,"merged":[[38,1,38,4],[39,1,39,4],[40,1,40,4],[41,1,41,4],[42,1,42,4],[43,1,43,4],[44,1,44,4]]}
[null,"Important Notes:"]
[]
[null,"Good Practice: Always keep original template in a separate folder and use a copy for your working."]
[null,"Do not delete row 10 and 11 on Gantt Sheet as these rows will be used to copy formats to row 12 onwards. Erase only data instead."]
[]
[null,"Let's Get Started"]
[null,"Step 1                              4","Get familiar with the tool first."]
[null,null,"Click the \"Gantt\" button (pic 1) to see the available options."]
[]
[null,"Pic 1: Click on the \"Gantt\" tab in the Excel ribbon to access Gantt tools and navigate among sheets."]
{"$rows_empty":24}
[null,"Step 2                              4","Go to Settings sheet to put the Company's Name and other information required for the Gantt Chart (use the links given below)."]
[]
[null,"Settings:"]
[]
[null,"Update company's name"]
[null,"Change Preferences",{"$nulls":3},"(See key features)"]
[null,"Update Tasks"]
[null,"Update Milestones"]
[null,"Update Resources and Leave info"]
[null,"Update Holidays"]
[null,"Update Budget Amount"]
[]
[null,"Step 3                              4","Once you finished with the necessary information in the Settings sheet, go to \"Gantt\" sheet to record the Tasks and Milestones."]
[]
[null,"Gantt Sheet:"]
[]
[null,"Input only in Grey Columns for Project information. White Columns are calculated ones."]
[]
[]
[]
[]
[]
[null,"Fields Explanation:"]
[null,"Sr. #","Serial Number. Auto calculated field."]
[null,"Type","Select \"T\" for Task and \"M\" for Milestone from the dropdown list."]
[null,"Task","Dropdown list, you will find the Tasks and Milestones listed in the Setting sheet based on Type selected in \"Type\" column."]
[null,"Resource","Select resource from the dropdown list from the Resource Listing in the Settings sheet. Person on leave will be highlighted in red."]
[null,"Duration Total","Total days of the Task. For Milestone, it's a sum total days for that stage. "]
[null,"Duration Remai-\nning","Remaining days of the Task. For Milestone, it's a sum total remaining days for that stage."]
[null,"Cost","Actual Cost of the Task. For Milestone, it's a sum total cost of that stage."]
[null,"Done","Days completed. Auto calculated field."]
[null,"% Prog","Percentage Progress of the task. Auto calculated filed."]
[null,"On Track","Visual indicator, whether a Task or Milestone is On Track on Not. Green Tick for \"On Track\" and Red Cross for \"Issue\"."]
[null,"D-Type","Dependency Type. Three types are available."]
[null,null,"Manual: When you select Manual D-Type, Manual Date cell will get shaded and you need to put date. Use Date Picker"]
[null,null,"Same: Keep D-Type empty. Same Start date as for the previous Task will be appeared in Start Date."]
[null,null,"After: Keep D-Type empty. Date after the previous Task is finished will appear as Start Date."]
[null,"Manual Date","See D-Type. Date will turn red if it's a Holiday set in the Holidays Listing in Settings Sheet."]
[null,"Start","Start Date of the Task or Milestone. Auto calculated field."]
[null,"Finish","Finish Date of the Task or Milestone. Auto calculated filed."]
[null,"Done Until","Done Until Date of the Task or Milestone. Auto calculated field."]
[]
[]
[]
[]
[null,"Use Date Picker to select dates in \"Manual Date\" Column only."]
[null,"Rest are auto calculated field."]
{"$rows_empty":20}
[null,"Step 4                              4","Now you are ready to put data for the project."]
[null,null,"Before you start putting the data, remember to make a copy of the tool and keep the original template in a safe folder for future use."]
[null,null,"Do not delete row 10 and 11 as these rows will be used to copy formats to row 12 onwards. Erase data only."]
[]
[null,null,"Data Entry:"]
[null,null,"Erase data from columns B to H and columns K to L (leave calculated columns as is)."]
[null,null,"Start entering data for the project in Grey Shaded columns as per sample data."]
[null,null,"If you need a row for new task, always use \"Add New Row\" In \"Gantt Tab\" available in Excel Ribbon. >"]
[]
[null,"Step 5     6"]
[]
[null,"Gantt Chart:"]
[]
[null,"Use Left and Right Scroll button if timeline is beyond the span of a month."]
[null,"Reset button will set the timeline to start date of Project."]

{"sheet":"Key Features","index":5,"n_rows":31,"n_cols":3,"rows_kept":31}
[null,"KEY FEATURES"]
[]
[null,"PREFERRENCES"]
[null,"•","Unlock the hidden potential of your Gantt Chart! Dive into the Preferences menu, where you’ll find a treasure trove of controls. Imagine having the power to shape your project timeline—whether you’re a weekend warrior or prefer weekdays. Simply toggle between ‘Yes’ and ‘No,’ and watch as your Gantt chart transforms, aligning with your work rhythm."]
[null,"•","In the Preferences section, you'll find an adjustable Start Date of the Month. This feature currently operates on a formula that intelligently extracts data from the Gantt’s 'Manual Date' column. The first date selected becomes the project's starting point, guiding the timeline for your entire endeavor."]
[null,"•","Imagine having the power to adjust the granularity of your Gantt Chart with the ‘Days per Cell’ feature. Whether your project spans weeks or months, you’re in control. Set it to 7 for a weekly view or 30 for a monthly perspective. Watch as your Gantt Chart dynamically adapts, revealing the entire project span—all neatly displayed on a single screen."]
[null,"•"," With the ‘Show Grid’ feature, you have the power to selectively conceal those horizontal grid lines. Imagine a clean canvas where your project unfolds without distractions."]
[null,"•","Unlock the power of precision with the ‘Show Today’ toggle in your Gantt Chart. Within Preferences, you have the ability to reveal or conceal today’s date on your timeline. Imagine having a spotlight that illuminates the present moment amidst your project’s grand narrative. It’s like capturing a snapshot of progress in real time."]
[]
[null,"LISTINGS"]
[null,"•","Empower yourself with the ultimate project management toolkit! Within the Settings, you hold the reins for Tasks, Milestones, and other Listings. Imagine a canvas where you can effortlessly add or remove items from the List. It’s like curating your project’s essentials—tailored to your vision. When you step into the Gantt Chart, each selection becomes a deliberate move toward project success."]
[]
[null,"PERSON ON LEAVE"]
[null,"•","Within the Resource Table, you may set leave periods for specific team members. Imagine fine-tuning availability—like adjusting a finely tuned instrument. When someone is on leave, their name on the Gantt Chart transforms into a vibrant red beacon, signaling their absence."]
[]
[null,"HOLIDAYS TABLE"]
[null,"•","A standout feature of the Settings sheet is the ability to set holidays for the year. When a date on the Gantt Chart coincides with a holiday, it will automatically highlight in red, making it easier for you to choose dates that align with your schedule."]
[]
[null,"GANTT CHART"]
[null,"•","Milestones: After completing a group of tasks related to a specific stage, you can add a milestone. A green flag will appear on the Gantt Chart once it's achieved, while an unfinished milestone will be marked with a red diamond."]
[null,"•","You can enter the budgeted cost once in the Settings sheet, and then input the actual cost for each task individually in the Gantt Chart's data input area."]
[null,"•","The D-Type column offers three types of dependencies:\nManual: Allows you to select the date based on your specific needs.\nSame: Automatically picks the start date from the previous task.\nAfter: Calculates the date based on when the previous task is completed."]
[]
[null,"SCROLL BUTTONS"]
[null,"•","Elevate your experience with the Scroll Left, Reset, and Scroll Right buttons. These intuitive controls offer precise navigation, enabling you to explore timelines that extend beyond a single month. Watch the timeline dynamically update right before your eyes—all within the same screen."]
[]
[null,"DATE PICKER"]
[null,"•","The Date Picker is a handy feature that allows you to select dates effortlessly, ensuring that your chosen dates fall on weekdays."]
[]
[null,"DASHBOARD"]
[null,"•","The Dashboard is the standout feature of this project management tool. It provides project performance visuals that enhance your decision-making, helping you manage your project more effectively."]