{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Instructions","Gantt Chart","Example"],"not_rendered":{"charts":2,"images":1,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":7,"n_cols":3,"rows_kept":7,"cut":false,"hidden":false,"merged":[[0,0,0,7]]}
[]
["Implementation Plan and Gantt Chart Instructions"]
["Using the template",null,"This template is a combination of an Implementation Plan and Gantt Chart. If your project only calls for an Implementation Plan you can leave the information under the Gantt Chart portion of the table blank"]
["Adding tasks to the Implementation Plan",null,"Add all individual tasks to the Implementation Plan portion of the table and assign each task to a specific person or group. As tasks are completed, you can check them off using the check boxes to the right of the task. "]
["Filling in start dates \nand durations",null,"To create a Gantt Chart, you will need to fill in an expected start date and estimated duration for each task. Once this information has been entered, the end date will be calculated automatically. "]
["Formatting the chart",null,"Clicking the 'Format Chart' button will resize and format the Gantt Chart for you. It will also delete unused rows, so only click this button once you have entered in all of your tasks. "]
["Color coding tasks",null,"The 'Format Chart' button will automatically color code the tasks in the Gantt Chart based on the 'Assigned To' column in the Implementation Plan so that each unique name is assigned its own color."]

{"sheet":"Gantt Chart","index":1,"n_rows":27,"n_cols":10,"rows_kept":27,"cut":false,"hidden":false,"merged":[[0,0,0,7],[0,9,0,10],[2,1,2,4],[2,5,2,7]]}
[]
[null,"[Insert title]",null,null,null,null,null,null,null,{"$f":"B2","v":"[Insert title]"}]
[null,"Implementation Plan",null,null,null,"Gantt Chart Information"]
[null,"Task","Assigned To","c","Complete?","Start Date","Duration (Days)","End Date"]
[null,"[Insert Task]",null,null,null,"2017-01-01",1,{"$f":"IF(ISBLANK(F5), \"\", DATE(YEAR(F5), MONTH(F5), DAY(F5)+G5))","v":"2017-01-02"}]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[]
[null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(F27), \"\", DATE(YEAR(F27), MONTH(F27), DAY(F27)+G27))","v":""}]

{"sheet":"Example","index":2,"n_rows":22,"n_cols":10,"rows_kept":22,"cut":false,"hidden":false,"merged":[[0,0,0,7],[0,9,0,10],[2,1,2,4],[2,5,2,7]]}
[]
[null,"[Insert title]",null,null,null,null,null,null,null,{"$f":"B2","v":"[Insert title]"}]
[null,"Implementation Plan",null,null,null,"Gantt Chart Information"]
[null,"Task","Assigned To","c","Complete?","Start Date","Duration (Days)","End Date"]
[null,"Determine date of wedding","Bride & Groom",null,null,"2017-01-01",1,{"$f":"IF(ISBLANK(F5), \"\", DATE(YEAR(F5), MONTH(F5), DAY(F5)+G5))","v":"2017-01-02"}]
[null,"Visit venues","Bride & Groom",null,null,"2017-01-05",12,"2017-01-17"]
[null,"Choose colors","Bride",null,null,"2017-01-15",16,"2017-01-31"]
[null,"Rent venue","Groom",null,null,"2017-01-17",1,"2017-01-18"]
[null,"Invite guests","Bride",null,null,"2017-02-10",16,"2017-02-26"]
[null,"Pick out a dress","Bride",null,null,"2017-02-16",7,"2017-02-23"]
[null,"Pick out a suit","Groom",null,null,"2017-03-01",1,"2017-03-02"]
[null,"Choose a photographer","Bride",null,null,"2017-03-02",7,"2017-03-09"]
[null,"Find a DJ","Groom",null,null,"2017-03-02",7,"2017-03-09"]
[null,"Choose a catering service","Groom",null,null,"2017-03-02",14,"2017-03-16"]
[null,"Decide on menu","Bride & Groom",null,null,"2017-03-18",4]
[null,"Arrange bachelor party","Best Man",null,null,"2017-04-01",7,{"$f":"IF(ISBLANK(F16), \"\", DATE(YEAR(F16), MONTH(F16), DAY(F16)+G16))","v":"2017-04-08"}]
[null,"Arrange bachelorette party","Maid of Honor",null,null,"2017-04-01",7,"2017-04-08"]
[null,"Go to bachelor part","Groom",null,null,"2017-04-10",1,"2017-04-11"]
[null,"Go to bachelorette party","Bride",null,null,"2017-04-17",1,"2017-04-18"]
[null,"Wedding rehearsal","Wedding party",null,null,"2017-05-01",1,"2017-05-02"]
[null,"Set up venue","Venue staff",null,null,"2017-05-02",1,"2017-05-03"]
[null,"Get married","Bride & Groom",null,null,"2017-05-02",1,"2017-05-03"]