{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["About","Light","Dark","Color"],"not_rendered":{"images":2,"defined_names":14},"read":"whole","date_system":"1900"}

{"sheet":"About","index":0,"n_rows":5,"n_cols":3,"rows_kept":5,"merged":[[1,2,1,4],[3,2,3,4],[4,2,4,4]]}
[]
[null,null,"ABOUT THIS GANTT CHART"]
[]
[null,null,"Visualize and track your projects using this Gantt chart template. To start, enter the tasks you're working on in the milestone description section and then enter details for each task. The data will automatically update and it’s easy to insert new tasks or use the scrollbar to scroll through the timeline. "]
[null,null,"•  Use the progress column to add how much of the project you finished by adding a percentage number\n•  Add the day you started your project in the start date column \n•  Finish your calculations by filling in the number of days you need to complete your project in the days column"]

{"sheet":"Light","index":1,"n_rows":36,"n_cols":64,"rows_kept":36,"merged":[[1,1,1,7],[1,8,1,13],[1,14,1,19],[3,8,3,11],[3,13,3,16],[3,18,3,21],[3,23,3,26],[3,28,3,31]]}
[]
[null,"PROJECT: Light"]
[]
[null,"Contoso, Ltd.",{"$nulls":4},"Legend:",null,"On track",{"$nulls":4},"Low risk",{"$nulls":4},"Med risk",{"$nulls":4},"High risk",{"$nulls":4},"Unassigned"]
[null,"Riku Nakano"]
[null,"Project start date:",{"$f":"IFERROR(IF(MIN(Milestones4352[Start])=0,TODAY(),B11(Milestones4352[Start])),TODAY())","v":"2023-01-31"},{"$nulls":5},{"$f":"TEXT(I7,\"mmmm\")","v":"February"},{"$nulls":6},{"$f":"IF(TEXT(P7,\"mmmm\")=I6,\"\",TEXT(P7,\"mmmm\"))","v":""},{"$nulls":6},{"$f":"IF(OR(TEXT(W7,\"mmmm\")=P6,TEXT(W7,\"mmmm\")=I6),\"\",TEXT(W7,\"mmmm\"))","v":""},{"$nulls":6},{"$f":"IF(OR(TEXT(AD7,\"mmmm\")=W6,TEXT(AD7,\"mmmm\")=P6,TEXT(AD7,\"mmmm\")=I6),\"\",TEXT(AD7,\"mmmm\"))","v":""},{"$nulls":6},{"$f":"IF(OR(TEXT(AK7,\"mmmm\")=AD6,TEXT(AK7,\"mmmm\")=W6,TEXT(AK7,\"mmmm\")=P6,TEXT(AK7,\"mmmm\")=I6),\"\",TEXT(AK7,\"mmmm\"))","v":"March"},{"$nulls":6},{"$f":"IF(OR(TEXT(AR7,\"mmmm\")=AK6,TEXT(AR7,\"mmmm\")=AD6,TEXT(AR7,\"mmmm\")=W6,TEXT(AR7,\"mmmm\")=P6),\"\",TEXT(AR7,\"mmmm\"))","v":""},{"$nulls":6},{"$f":"IF(OR(TEXT(AY7,\"mmmm\")=AR6,TEXT(AY7,\"mmmm\")=AK6,TEXT(AY7,\"mmmm\")=AD6,TEXT(AY7,\"mmmm\")=W6),\"\",TEXT(AY7,\"mmmm\"))","v":""},{"$nulls":6},{"$f":"IF(OR(TEXT(BF7,\"mmmm\")=AY6,TEXT(BF7,\"mmmm\")=AR6,TEXT(BF7,\"mmmm\")=AK6,TEXT(BF7,\"mmmm\")=AD6),\"\",TEXT(BF7,\"mmmm\"))","v":""}]
[null,"Scrolling increment:",5,{"$nulls":5},{"$f":"IFERROR(Project_Start+Scrolling_Increment,TODAY())","v":"2023-02-05"},{"$f":"I7+1","v":"2023-02-06"},{"$f":"J7+1","v":"2023-02-07"},"2023-02-08","2023-02-09","2023-02-10","2023-02-11",{"$f":"O7+1","v":"2023-02-12"},{"$f":"P7+1","v":"2023-02-13"},"2023-02-14","2023-02-15","2023-02-16","2023-02-17","2023-02-18",{"$f":"V7+1","v":"2023-02-19"},{"$f":"W7+1","v":"2023-02-20"},"2023-02-21","2023-02-22","2023-02-23","2023-02-24","2023-02-25",{"$f":"AC7+1","v":"2023-02-26"},{"$f":"AD7+1","v":"2023-02-27"},"2023-02-28","2023-03-01","2023-03-02","2023-03-03","2023-03-04",{"$f":"AJ7+1","v":"2023-03-05"},{"$f":"AK7+1","v":"2023-03-06"},"2023-03-07","2023-03-08","2023-03-09","2023-03-10","2023-03-11",{"$f":"AQ7+1","v":"2023-03-12"},{"$f":"AR7+1","v":"2023-03-13"},"2023-03-14","2023-03-15","2023-03-16","2023-03-17","2023-03-18",{"$f":"AX7+1","v":"2023-03-19"},{"$f":"AY7+1","v":"2023-03-20"},{"$f":"AZ7+1","v":"2023-03-21"},"2023-03-22","2023-03-23","2023-03-24","2023-03-25",{"$f":"BE7+1","v":"2023-03-26"},{"$f":"BF7+1","v":"2023-03-27"},{"$f":"BG7+1","v":"2023-03-28"},"2023-03-29","2023-03-30","2023-03-31","2023-04-01"]
[]
[null,"Milestone description","Category","Assigned to","Progress","Start","Days",null,{"$f":"LEFT(TEXT(I7,\"ddd\"),1)","v":"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","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"]
[]
[null,"Project development",{"$nulls":6},{"$f":"IF(AND($C11=\"Goal\",I$7>=$F11,I$7<=$F11+$G11-1),2,IF(AND($C11=\"Milestone\",I$7>=$F11,I$7<=$F11+$G11-1),1,\"\"))","v":""},"","","","","","","","","","","","","","","",{"$f":"IF(AND($C11=\"Goal\",Y$7>=$F11,Y$7<=$F11+$G11-1),2,IF(AND($C11=\"Milestone\",Y$7>=$F11,Y$7<=$F11+$G11-1),1,\"\"))","v":""},"","","","","","","","","","","","","","","",{"$f":"IF(AND($C11=\"Goal\",AO$7>=$F11,AO$7<=$F11+$G11-1),2,IF(AND($C11=\"Milestone\",AO$7>=$F11,AO$7<=$F11+$G11-1),1,\"\"))","v":""},"","","","","","","","","","","","","","","",{"$f":"IF(AND($C11=\"Goal\",BE$7>=$F11,BE$7<=$F11+$G11-1),2,IF(AND($C11=\"Milestone\",BE$7>=$F11,BE$7<=$F11+$G11-1),1,\"\"))","v":""},"","","","","","",""]
[null,"Project charter","Goal","Name",{"v":0.25,"d":"25%"},{"$f":"TODAY()","v":"2023-01-31"},{"v":3,"d":"3 "},null,{"$f":"IF(AND($C12=\"Goal\",I$7>=$F12,I$7<=$F12+$G12-1),2,IF(AND($C12=\"Milestone\",I$7>=$F12,I$7<=$F12+$G12-1),1,\"\"))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Research","Milestone",null,null,{"$f":"TODAY()+5","v":"2023-02-05"},{"v":1,"d":"1 "},null,{"$f":"IF(AND($C13=\"Goal\",I$7>=$F13,I$7<=$F13+$G13-1),2,IF(AND($C13=\"Milestone\",I$7>=$F13,I$7<=$F13+$G13-1),1,\"\"))","v":1},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Projections","Low Risk",null,{"v":0.5,"d":"50%"},{"$f":"F12-3","v":"2023-01-28"},{"v":10,"d":"10 "},null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Stakeholders","Milestone",null,null,{"$f":"F12+20","v":"2023-02-20"},{"v":1,"d":"1 "},null,"","","","","","","","","","","","","","","",1,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Review","Med Risk",null,{"v":0.1,"d":"10%"},{"$f":"F12+6","v":"2023-02-06"},{"v":6,"d":"6 "},null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Contracts",{"$nulls":6},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Proposals","High Risk",null,{"v":0.6,"d":"60%"},{"$f":"F12+6","v":"2023-02-06"},{"v":13,"d":"13 "},null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Document review","On Track",null,{"v":0.5,"d":"50%"},{"$f":"F18+2","v":"2023-02-08"},{"v":9,"d":"9 "},null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Bid date","Low Risk",null,{"v":0.33,"d":"33%"},{"$f":"F19+5","v":"2023-02-13"},{"v":11,"d":"11 "},null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Award date","Milestone",null,null,{"$f":"F20+2","v":"2023-02-15"},{"v":1,"d":"1 "},null,"","","","","","","","","","",1,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Finalize",{"$nulls":3},{"$f":"F21+1","v":"2023-02-16"},{"v":24,"d":"24 "},null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Design",{"$nulls":6},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Feasibility study","On Track",null,null,{"$f":"F12+15","v":"2023-02-15"},{"v":4,"d":"4 "},null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Submit permit applications","Med Risk",null,null,{"$f":"F24+3","v":"2023-02-18"},{"v":14,"d":"14 "},null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Design proposal","On Track",null,null,{"$f":"F25+15","v":"2023-03-05"},{"v":6,"d":"6 "},null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AND($C26=\"Goal\",AN$7>=$F26,AN$7<=$F26+$G26-1),2,IF(AND($C26=\"Milestone\",AN$7>=$F26,AN$7<=$F26+$G26-1),1,\"\"))","v":""},"","","","","","","","","","","","","","","",{"$f":"IF(AND($C26=\"Goal\",BD$7>=$F26,BD$7<=$F26+$G26-1),2,IF(AND($C26=\"Milestone\",BD$7>=$F26,BD$7<=$F26+$G26-1),1,\"\"))","v":""},"","","","","","","",""]
[null,"Materials","Goal",null,null,{"$f":"F21+22","v":"2023-03-09"},{"v":3,"d":"3 "},null,"","","","","","","","","","","","","","","","",{"$f":"IF(AND($C27=\"Goal\",Y$7>=$F27,Y$7<=$F27+$G27-1),2,IF(AND($C27=\"Milestone\",Y$7>=$F27,Y$7<=$F27+$G27-1),1,\"\"))","v":""},"","","","","","","","","","","","","","","",2,2,2,"","","","","","","","","","","","","","","","","","","","",""]
[null,"Equipment","Low Risk",null,null,{"$f":"F16","v":"2023-02-06"},{"v":19,"d":"19 "},null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Testing",{"$nulls":6},{"$f":"IF(AND($C29=\"Goal\",I$7>=$F29,I$7<=$F29+$G29-1),2,IF(AND($C29=\"Milestone\",I$7>=$F29,I$7<=$F29+$G29-1),1,\"\"))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Environment",{"$nulls":3},{"$f":"F27+3","v":"2023-03-12"},{"v":15,"d":"15 "},null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"System test",{"$nulls":3},{"$f":"F30+14","v":"2023-03-26"},{"v":5,"d":"5 "},null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Issues/bugs","Milestone",null,null,{"$f":"F31+42","v":"2023-05-07"},{"v":1,"d":"1 "},null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Task 4",{"$nulls":6},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Task 5",{"$nulls":6},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[{"$nulls":8},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"To add more data, Insert new rows ABOVE this one"]

{"sheet":"Dark","index":2,"n_rows":36,"n_cols":64,"rows_kept":36,"merged":[[1,1,1,7],[1,8,1,13],[1,14,1,19],[3,8,3,11],[3,13,3,16],[3,18,3,21],[3,23,3,26],[3,28,3,31]]}
[]
[null,"PROJECT: Dark"]
[]
[null,"Contoso, Ltd.",{"$nulls":4},"Legend:",null,"On track",{"$nulls":4},"Low risk",{"$nulls":4},"Med risk",{"$nulls":4},"High risk",{"$nulls":4},"Unassigned"]
[null,"Gupreet Bawa"]
[null,"Project start date:",{"$f":"IFERROR(IF(MIN(Milestones435[Start])=0,TODAY(),B11(Milestones435[Start])),TODAY())","v":"2023-01-31"},{"$nulls":5},{"$f":"TEXT(I7,\"mmmm\")","v":"February"},{"$nulls":6},{"$f":"IF(TEXT(P7,\"mmmm\")=I6,\"\",TEXT(P7,\"mmmm\"))","v":""},{"$nulls":6},{"$f":"IF(OR(TEXT(W7,\"mmmm\")=P6,TEXT(W7,\"mmmm\")=I6),\"\",TEXT(W7,\"mmmm\"))","v":""},{"$nulls":6},{"$f":"IF(OR(TEXT(AD7,\"mmmm\")=W6,TEXT(AD7,\"mmmm\")=P6,TEXT(AD7,\"mmmm\")=I6),\"\",TEXT(AD7,\"mmmm\"))","v":""},{"$nulls":6},{"$f":"IF(OR(TEXT(AK7,\"mmmm\")=AD6,TEXT(AK7,\"mmmm\")=W6,TEXT(AK7,\"mmmm\")=P6,TEXT(AK7,\"mmmm\")=I6),\"\",TEXT(AK7,\"mmmm\"))","v":"March"},{"$nulls":6},{"$f":"IF(OR(TEXT(AR7,\"mmmm\")=AK6,TEXT(AR7,\"mmmm\")=AD6,TEXT(AR7,\"mmmm\")=W6,TEXT(AR7,\"mmmm\")=P6),\"\",TEXT(AR7,\"mmmm\"))","v":""},{"$nulls":6},{"$f":"IF(OR(TEXT(AY7,\"mmmm\")=AR6,TEXT(AY7,\"mmmm\")=AK6,TEXT(AY7,\"mmmm\")=AD6,TEXT(AY7,\"mmmm\")=W6),\"\",TEXT(AY7,\"mmmm\"))","v":""},{"$nulls":6},{"$f":"IF(OR(TEXT(BF7,\"mmmm\")=AY6,TEXT(BF7,\"mmmm\")=AR6,TEXT(BF7,\"mmmm\")=AK6,TEXT(BF7,\"mmmm\")=AD6),\"\",TEXT(BF7,\"mmmm\"))","v":""}]
[null,"Scrolling increment:",5,{"$nulls":5},{"$f":"IFERROR(Project_Start+Scrolling_Increment,TODAY())","v":"2023-02-05"},{"$f":"I7+1","v":"2023-02-06"},{"$f":"J7+1","v":"2023-02-07"},"2023-02-08","2023-02-09","2023-02-10","2023-02-11",{"$f":"O7+1","v":"2023-02-12"},{"$f":"P7+1","v":"2023-02-13"},"2023-02-14","2023-02-15","2023-02-16","2023-02-17","2023-02-18",{"$f":"V7+1","v":"2023-02-19"},{"$f":"W7+1","v":"2023-02-20"},"2023-02-21","2023-02-22","2023-02-23","2023-02-24","2023-02-25",{"$f":"AC7+1","v":"2023-02-26"},{"$f":"AD7+1","v":"2023-02-27"},"2023-02-28","2023-03-01","2023-03-02","2023-03-03","2023-03-04",{"$f":"AJ7+1","v":"2023-03-05"},{"$f":"AK7+1","v":"2023-03-06"},"2023-03-07","2023-03-08","2023-03-09","2023-03-10","2023-03-11",{"$f":"AQ7+1","v":"2023-03-12"},{"$f":"AR7+1","v":"2023-03-13"},"2023-03-14","2023-03-15","2023-03-16","2023-03-17","2023-03-18",{"$f":"AX7+1","v":"2023-03-19"},{"$f":"AY7+1","v":"2023-03-20"},{"$f":"AZ7+1","v":"2023-03-21"},"2023-03-22","2023-03-23","2023-03-24","2023-03-25",{"$f":"BE7+1","v":"2023-03-26"},{"$f":"BF7+1","v":"2023-03-27"},{"$f":"BG7+1","v":"2023-03-28"},"2023-03-29","2023-03-30","2023-03-31","2023-04-01"]
[]
[null,"Milestone description","Category","Assigned to","Progress","Start","Days",null,{"$f":"LEFT(TEXT(I7,\"ddd\"),1)","v":"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","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"]
[]
[null,"TITLE 1",{"$nulls":6},{"$f":"IF(AND($C11=\"Goal\",I$7>=$F11,I$7<=$F11+$G11-1),2,IF(AND($C11=\"Milestone\",I$7>=$F11,I$7<=$F11+$G11-1),1,\"\"))","v":""},"","","","","","","","","","","","","","","",{"$f":"IF(AND($C11=\"Goal\",Y$7>=$F11,Y$7<=$F11+$G11-1),2,IF(AND($C11=\"Milestone\",Y$7>=$F11,Y$7<=$F11+$G11-1),1,\"\"))","v":""},"","","","","","","","","","","","","","","",{"$f":"IF(AND($C11=\"Goal\",AO$7>=$F11,AO$7<=$F11+$G11-1),2,IF(AND($C11=\"Milestone\",AO$7>=$F11,AO$7<=$F11+$G11-1),1,\"\"))","v":""},"","","","","","","","","","","","","","","",{"$f":"IF(AND($C11=\"Goal\",BE$7>=$F11,BE$7<=$F11+$G11-1),2,IF(AND($C11=\"Milestone\",BE$7>=$F11,BE$7<=$F11+$G11-1),1,\"\"))","v":""},"","","","","","",""]
[null,"Task 1","Goal","Name",{"v":0.25,"d":"25%"},{"$f":"TODAY()","v":"2023-01-31"},{"v":3,"d":"3 "},null,{"$f":"IF(AND($C12=\"Goal\",I$7>=$F12,I$7<=$F12+$G12-1),2,IF(AND($C12=\"Milestone\",I$7>=$F12,I$7<=$F12+$G12-1),1,\"\"))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Task 2","Milestone",null,null,{"$f":"TODAY()+5","v":"2023-02-05"},{"v":1,"d":"1 "},null,{"$f":"IF(AND($C13=\"Goal\",I$7>=$F13,I$7<=$F13+$G13-1),2,IF(AND($C13=\"Milestone\",I$7>=$F13,I$7<=$F13+$G13-1),1,\"\"))","v":1},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Task 3","Low Risk",null,{"v":0.5,"d":"50%"},{"$f":"F12-3","v":"2023-01-28"},{"v":10,"d":"10 "},null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Task 4","Milestone",null,null,{"$f":"F12+20","v":"2023-02-20"},{"v":1,"d":"1 "},null,"","","","","","","","","","","","","","","",1,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Task 5","Med Risk",null,{"v":0.1,"d":"10%"},{"$f":"F12+6","v":"2023-02-06"},{"v":6,"d":"6 "},null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"TITLE 2",{"$nulls":6},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Task 1","High Risk",null,{"v":0.6,"d":"60%"},{"$f":"F12+6","v":"2023-02-06"},{"v":13,"d":"13 "},null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Task 2","On Track",null,{"v":0.5,"d":"50%"},{"$f":"F18+2","v":"2023-02-08"},{"v":9,"d":"9 "},null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Task 3","Low Risk",null,{"v":0.33,"d":"33%"},{"$f":"F19+5","v":"2023-02-13"},{"v":11,"d":"11 "},null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Task 4","Milestone",null,null,{"$f":"F20+2","v":"2023-02-15"},{"v":1,"d":"1 "},null,"","","","","","","","","","",1,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Task 5",{"$nulls":3},{"$f":"F21+1","v":"2023-02-16"},{"v":24,"d":"24 "},null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"TITLE 3",{"$nulls":6},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Task 1","On Track",null,null,{"$f":"F12+15","v":"2023-02-15"},{"v":4,"d":"4 "},null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Task 2","Med Risk",null,null,{"$f":"F24+3","v":"2023-02-18"},{"v":14,"d":"14 "},null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Task 3","On Track",null,null,{"$f":"F25+15","v":"2023-03-05"},{"v":6,"d":"6 "},null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AND($C26=\"Goal\",AN$7>=$F26,AN$7<=$F26+$G26-1),2,IF(AND($C26=\"Milestone\",AN$7>=$F26,AN$7<=$F26+$G26-1),1,\"\"))","v":""},"","","","","","","","","","","","","","","",{"$f":"IF(AND($C26=\"Goal\",BD$7>=$F26,BD$7<=$F26+$G26-1),2,IF(AND($C26=\"Milestone\",BD$7>=$F26,BD$7<=$F26+$G26-1),1,\"\"))","v":""},"","","","","","","",""]
[null,"Task 4","Goal",null,null,{"$f":"F21+22","v":"2023-03-09"},{"v":3,"d":"3 "},null,"","","","","","","","","","","","","","","","",{"$f":"IF(AND($C27=\"Goal\",Y$7>=$F27,Y$7<=$F27+$G27-1),2,IF(AND($C27=\"Milestone\",Y$7>=$F27,Y$7<=$F27+$G27-1),1,\"\"))","v":""},"","","","","","","","","","","","","","","",2,2,2,"","","","","","","","","","","","","","","","","","","","",""]
[null,"Task 5","Low Risk",null,null,{"$f":"F16","v":"2023-02-06"},{"v":19,"d":"19 "},null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"TITLE 4",{"$nulls":6},{"$f":"IF(AND($C29=\"Goal\",I$7>=$F29,I$7<=$F29+$G29-1),2,IF(AND($C29=\"Milestone\",I$7>=$F29,I$7<=$F29+$G29-1),1,\"\"))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Task 1",{"$nulls":3},{"$f":"F27+3","v":"2023-03-12"},{"v":15,"d":"15 "},null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Task 2",{"$nulls":3},{"$f":"F30+14","v":"2023-03-26"},{"v":5,"d":"5 "},null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Task 3","Milestone",null,null,{"$f":"F31+42","v":"2023-05-07"},{"v":1,"d":"1 "},null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Task 4",{"$nulls":6},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Task 5",{"$nulls":6},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[{"$nulls":8},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"To add more data, Insert new rows ABOVE this one"]

{"sheet":"Color","index":3,"n_rows":36,"n_cols":64,"rows_kept":36,"merged":[[1,1,1,7],[1,8,1,13],[1,14,1,19],[3,8,3,11],[3,13,3,16],[3,18,3,21],[3,23,3,26],[3,28,3,31]]}
[]
[null,"PROJECT: Color"]
[]
[null,"Contoso, Ltd.",{"$nulls":4},"Legend:",null,"On track",{"$nulls":4},"Low risk",{"$nulls":4},"Med risk",{"$nulls":4},"High risk",{"$nulls":4},"Unassigned"]
[null,"Hayden Cook"]
[null,"Project start date:",{"$f":"IFERROR(IF(MIN(Milestones43524[Start])=0,TODAY(),B11(Milestones43524[Start])),TODAY())","v":"2023-01-31"},{"$nulls":5},{"$f":"TEXT(I7,\"mmmm\")","v":"February"},{"$nulls":6},{"$f":"IF(TEXT(P7,\"mmmm\")=I6,\"\",TEXT(P7,\"mmmm\"))","v":""},{"$nulls":6},{"$f":"IF(OR(TEXT(W7,\"mmmm\")=P6,TEXT(W7,\"mmmm\")=I6),\"\",TEXT(W7,\"mmmm\"))","v":""},{"$nulls":6},{"$f":"IF(OR(TEXT(AD7,\"mmmm\")=W6,TEXT(AD7,\"mmmm\")=P6,TEXT(AD7,\"mmmm\")=I6),\"\",TEXT(AD7,\"mmmm\"))","v":""},{"$nulls":6},{"$f":"IF(OR(TEXT(AK7,\"mmmm\")=AD6,TEXT(AK7,\"mmmm\")=W6,TEXT(AK7,\"mmmm\")=P6,TEXT(AK7,\"mmmm\")=I6),\"\",TEXT(AK7,\"mmmm\"))","v":"March"},{"$nulls":6},{"$f":"IF(OR(TEXT(AR7,\"mmmm\")=AK6,TEXT(AR7,\"mmmm\")=AD6,TEXT(AR7,\"mmmm\")=W6,TEXT(AR7,\"mmmm\")=P6),\"\",TEXT(AR7,\"mmmm\"))","v":""},{"$nulls":6},{"$f":"IF(OR(TEXT(AY7,\"mmmm\")=AR6,TEXT(AY7,\"mmmm\")=AK6,TEXT(AY7,\"mmmm\")=AD6,TEXT(AY7,\"mmmm\")=W6),\"\",TEXT(AY7,\"mmmm\"))","v":""},{"$nulls":6},{"$f":"IF(OR(TEXT(BF7,\"mmmm\")=AY6,TEXT(BF7,\"mmmm\")=AR6,TEXT(BF7,\"mmmm\")=AK6,TEXT(BF7,\"mmmm\")=AD6),\"\",TEXT(BF7,\"mmmm\"))","v":""}]
[null,"Scrolling increment:",5,{"$nulls":5},{"$f":"IFERROR(Project_Start+Scrolling_Increment,TODAY())","v":"2023-02-05"},{"$f":"I7+1","v":"2023-02-06"},{"$f":"J7+1","v":"2023-02-07"},"2023-02-08","2023-02-09","2023-02-10","2023-02-11",{"$f":"O7+1","v":"2023-02-12"},{"$f":"P7+1","v":"2023-02-13"},"2023-02-14","2023-02-15","2023-02-16","2023-02-17","2023-02-18",{"$f":"V7+1","v":"2023-02-19"},{"$f":"W7+1","v":"2023-02-20"},"2023-02-21","2023-02-22","2023-02-23","2023-02-24","2023-02-25",{"$f":"AC7+1","v":"2023-02-26"},{"$f":"AD7+1","v":"2023-02-27"},"2023-02-28","2023-03-01","2023-03-02","2023-03-03","2023-03-04",{"$f":"AJ7+1","v":"2023-03-05"},{"$f":"AK7+1","v":"2023-03-06"},"2023-03-07","2023-03-08","2023-03-09","2023-03-10","2023-03-11",{"$f":"AQ7+1","v":"2023-03-12"},{"$f":"AR7+1","v":"2023-03-13"},"2023-03-14","2023-03-15","2023-03-16","2023-03-17","2023-03-18",{"$f":"AX7+1","v":"2023-03-19"},{"$f":"AY7+1","v":"2023-03-20"},{"$f":"AZ7+1","v":"2023-03-21"},"2023-03-22","2023-03-23","2023-03-24","2023-03-25",{"$f":"BE7+1","v":"2023-03-26"},{"$f":"BF7+1","v":"2023-03-27"},{"$f":"BG7+1","v":"2023-03-28"},"2023-03-29","2023-03-30","2023-03-31","2023-04-01"]
[]
[null,"Milestone description","Category","Assigned to","Progress","Start","Days",null,{"$f":"LEFT(TEXT(I7,\"ddd\"),1)","v":"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","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"]
[]
[null,"TITLE 1",{"$nulls":6},{"$f":"IF(AND($C11=\"Goal\",I$7>=$F11,I$7<=$F11+$G11-1),2,IF(AND($C11=\"Milestone\",I$7>=$F11,I$7<=$F11+$G11-1),1,\"\"))","v":""},"","","","","","","","","","","","","","","",{"$f":"IF(AND($C11=\"Goal\",Y$7>=$F11,Y$7<=$F11+$G11-1),2,IF(AND($C11=\"Milestone\",Y$7>=$F11,Y$7<=$F11+$G11-1),1,\"\"))","v":""},"","","","","","","","","","","","","","","",{"$f":"IF(AND($C11=\"Goal\",AO$7>=$F11,AO$7<=$F11+$G11-1),2,IF(AND($C11=\"Milestone\",AO$7>=$F11,AO$7<=$F11+$G11-1),1,\"\"))","v":""},"","","","","","","","","","","","","","","",{"$f":"IF(AND($C11=\"Goal\",BE$7>=$F11,BE$7<=$F11+$G11-1),2,IF(AND($C11=\"Milestone\",BE$7>=$F11,BE$7<=$F11+$G11-1),1,\"\"))","v":""},"","","","","","",""]
[null,"Task 1","Goal","Name",{"v":0.25,"d":"25%"},{"$f":"TODAY()","v":"2023-01-31"},{"v":3,"d":"3 "},null,{"$f":"IF(AND($C12=\"Goal\",I$7>=$F12,I$7<=$F12+$G12-1),2,IF(AND($C12=\"Milestone\",I$7>=$F12,I$7<=$F12+$G12-1),1,\"\"))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Task 2","Milestone",null,null,{"$f":"TODAY()+5","v":"2023-02-05"},{"v":1,"d":"1 "},null,{"$f":"IF(AND($C13=\"Goal\",I$7>=$F13,I$7<=$F13+$G13-1),2,IF(AND($C13=\"Milestone\",I$7>=$F13,I$7<=$F13+$G13-1),1,\"\"))","v":1},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Task 3","Low Risk",null,{"v":0.5,"d":"50%"},{"$f":"F12-3","v":"2023-01-28"},{"v":10,"d":"10 "},null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Task 4","Milestone",null,null,{"$f":"F12+20","v":"2023-02-20"},{"v":1,"d":"1 "},null,"","","","","","","","","","","","","","","",1,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Task 5","Med Risk",null,{"v":0.1,"d":"10%"},{"$f":"F12+6","v":"2023-02-06"},{"v":6,"d":"6 "},null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"TITLE 2",{"$nulls":6},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Task 1","High Risk",null,{"v":0.6,"d":"60%"},{"$f":"F12+6","v":"2023-02-06"},{"v":13,"d":"13 "},null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Task 2","On Track",null,{"v":0.5,"d":"50%"},{"$f":"F18+2","v":"2023-02-08"},{"v":9,"d":"9 "},null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Task 3","Low Risk",null,{"v":0.33,"d":"33%"},{"$f":"F19+5","v":"2023-02-13"},{"v":11,"d":"11 "},null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Task 4","Milestone",null,null,{"$f":"F20+2","v":"2023-02-15"},{"v":1,"d":"1 "},null,"","","","","","","","","","",1,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Task 5",{"$nulls":3},{"$f":"F21+1","v":"2023-02-16"},{"v":24,"d":"24 "},null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"TITLE 3",{"$nulls":6},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Task 1","On Track",null,null,{"$f":"F12+15","v":"2023-02-15"},{"v":4,"d":"4 "},null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Task 2","Med Risk",null,null,{"$f":"F24+3","v":"2023-02-18"},{"v":14,"d":"14 "},null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Task 3","On Track",null,null,{"$f":"F25+15","v":"2023-03-05"},{"v":6,"d":"6 "},null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AND($C26=\"Goal\",AN$7>=$F26,AN$7<=$F26+$G26-1),2,IF(AND($C26=\"Milestone\",AN$7>=$F26,AN$7<=$F26+$G26-1),1,\"\"))","v":""},"","","","","","","","","","","","","","","",{"$f":"IF(AND($C26=\"Goal\",BD$7>=$F26,BD$7<=$F26+$G26-1),2,IF(AND($C26=\"Milestone\",BD$7>=$F26,BD$7<=$F26+$G26-1),1,\"\"))","v":""},"","","","","","","",""]
[null,"Task 4","Goal",null,null,{"$f":"F21+22","v":"2023-03-09"},{"v":3,"d":"3 "},null,"","","","","","","","","","","","","","","","",{"$f":"IF(AND($C27=\"Goal\",Y$7>=$F27,Y$7<=$F27+$G27-1),2,IF(AND($C27=\"Milestone\",Y$7>=$F27,Y$7<=$F27+$G27-1),1,\"\"))","v":""},"","","","","","","","","","","","","","","",2,2,2,"","","","","","","","","","","","","","","","","","","","",""]
[null,"Task 5","Low Risk",null,null,{"$f":"F16","v":"2023-02-06"},{"v":19,"d":"19 "},null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"TITLE 4",{"$nulls":6},{"$f":"IF(AND($C29=\"Goal\",I$7>=$F29,I$7<=$F29+$G29-1),2,IF(AND($C29=\"Milestone\",I$7>=$F29,I$7<=$F29+$G29-1),1,\"\"))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Task 1",{"$nulls":3},{"$f":"F27+3","v":"2023-03-12"},{"v":15,"d":"15 "},null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Task 2",{"$nulls":3},{"$f":"F30+14","v":"2023-03-26"},{"v":5,"d":"5 "},null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Task 3","Milestone",null,null,{"$f":"F31+42","v":"2023-05-07"},{"v":1,"d":"1 "},null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Task 4",{"$nulls":6},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Task 5",{"$nulls":6},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[{"$nulls":8},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"To add more data, Insert new rows ABOVE this one"]