{"text_format":"2","workbook":"xlsx","n_sheets":5,"sheets":["GanttChart","Help","GanttChartPro","TermsOfUse","©"],"not_rendered":{"charts":0,"images":3,"macros":0,"external_links":0,"defined_names":0,"comments":2,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"GanttChart","index":0,"n_rows":53,"n_cols":66,"rows_kept":53,"cut":false,"hidden":false,"merged":[[6,10,6,16],[6,17,6,23],[4,3,4,4],[5,17,5,23],[5,10,5,16],[46,0,46,1],[47,0,47,4],[4,1,4,2],[5,1,5,2],[2,1,2,2],[2,3,2,4],[3,1,3,2],[3,3,3,4],[5,24,5,30],[5,59,5,65],[6,59,6,65],[6,45,6,51],[6,38,6,44],[5,38,5,44],[5,31,5,37],[6,31,6,37],[6,24,6,30],[5,45,5,51],[5,52,5,58],[6,52,6,58]]}
["[Project Name]"]
["[Company Name]"]
[null,"Project Leads:"]
[null,"Project Start Date:"]
[null,"Today's Date:",null,{"$f":"TODAY()","v":"2019-01-27"},{"$nulls":6},{"$f":"D4-WEEKDAY(D4,1)+2+7*(D6-1)","v":-5},{"$f":"K5+1","v":-4},-3,-2,-1,"00:00:00","1900-01-01","1900-01-02","1900-01-03","1900-01-04","1900-01-05","1900-01-06","1900-01-07","1900-01-08","1900-01-09","1900-01-10","1900-01-11","1900-01-12","1900-01-13","1900-01-14","1900-01-15","1900-01-16","1900-01-17","1900-01-18","1900-01-19","1900-01-20","1900-01-21","1900-01-22","1900-01-23","1900-01-24","1900-01-25","1900-01-26","1900-01-27","1900-01-28","1900-01-29","1900-01-30","1900-01-31","1900-02-01","1900-02-02","1900-02-03","1900-02-04","1900-02-05","1900-02-06","1900-02-07","1900-02-08","1900-02-09","1900-02-10","1900-02-11","1900-02-12","1900-02-13","1900-02-14","1900-02-15","1900-02-16","1900-02-17","1900-02-18","1900-02-19"]
[null,"Display Week:",null,1.0,{"$nulls":6},{"$f":"\"Week \"&(K5-($D$4-WEEKDAY($D$4,1)+2))/7+1","v":"Week 1"},{"$nulls":6},{"$f":"\"Week \"&(R5-($D$4-WEEKDAY($D$4,1)+2))/7+1","v":"Week 2"},{"$nulls":6},{"$f":"\"Week \"&(Y5-($D$4-WEEKDAY($D$4,1)+2))/7+1","v":"Week 3"},{"$nulls":6},{"$f":"\"Week \"&(AF5-($D$4-WEEKDAY($D$4,1)+2))/7+1","v":"Week 4"},{"$nulls":6},{"$f":"\"Week \"&(AM5-($D$4-WEEKDAY($D$4,1)+2))/7+1","v":"Week 5"},{"$nulls":6},{"$f":"\"Week \"&(AT5-($D$4-WEEKDAY($D$4,1)+2))/7+1","v":"Week 6"},{"$nulls":6},{"$f":"\"Week \"&(BA5-($D$4-WEEKDAY($D$4,1)+2))/7+1","v":"Week 7"},{"$nulls":6},{"$f":"\"Week \"&(BH5-($D$4-WEEKDAY($D$4,1)+2))/7+1","v":"Week 8"}]
[{"$nulls":10},{"$f":"K5","v":-5},{"$nulls":6},{"$f":"R5","v":"1900-01-02"},{"$nulls":6},{"$f":"Y5","v":"1900-01-09"},{"$nulls":6},{"$f":"AF5","v":"1900-01-16"},{"$nulls":6},{"$f":"AM5","v":"1900-01-23"},{"$nulls":6},{"$f":"AT5","v":"1900-01-30"},{"$nulls":6},{"$f":"BA5","v":"1900-02-06"},{"$nulls":6},{"$f":"BH5","v":"1900-02-13"}]
["WBS","Task","Lead","Start","End","Cal\nDays","%\nDone","Work\nDays","Days\nDone","Days\nLeft",{"$f":"INDEX({\"Su\";\"M\";\"T\";\"W\";\"Th\";\"F\";\"Sa\"},WEEKDAY(K5,1))","v":"#NUM!"},"#NUM!","#NUM!","#NUM!","#NUM!","Sa","Su","M","T","W","Th","F","Sa","Su","M","T","W","Th","F","Sa","Su","M","T","W","Th","F","Sa","Su","M","T","W","Th","F","Sa","Su","M","T","W","Th","F","Sa","Su","M","T","W","Th","F","Sa","Su","M","T","W","Th","F","Sa","Su"]
[{"$f":"IF(ISERROR(VALUE(SUBSTITUTE(OFFSET(A9,-1,0,1,1),\".\",\"\"))),\"1\",IF(ISERROR(FIND(\"`\",SUBSTITUTE(OFFSET(A9,-1,0,1,1),\".\",\"`\",1))),TEXT(VALUE(OFFSET(A9,-1,0,1,1))+1,\"#\"),TEXT(VALUE(LEFT(OFFSET(A9,-1,0,1,1),FIND(\"`\",SUBSTITUTE(OFFSET(A9,-1,0,1,1),\".\",\"`\",1))-1))+1,\"#\")))","v":"1"},"[ Task Category ]","[Name]","2000-01-01","2000-01-04",4.0,null,4.0,null,null,{"$f":"IF(K$5=$D$5,\"t\",IF(AND(K$5>=$D9,K$5<$D9+$I9),\"c\",IF(AND(K$5>=$D9,K$5<=$D9+$F9-1),\"x\",\"\")))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[{"$f":"IF(ISERROR(VALUE(SUBSTITUTE(OFFSET(A10,-1,0,1,1),\".\",\"\"))),\"0.1\",IF(ISERROR(FIND(\"`\",SUBSTITUTE(OFFSET(A10,-1,0,1,1),\".\",\"`\",1))),OFFSET(A10,-1,0,1,1)&\".1\",LEFT(OFFSET(A10,-1,0,1,1),FIND(\"`\",SUBSTITUTE(OFFSET(A10,-1,0,1,1),\".\",\"`\",1)))&IF(ISERROR(FIND(\"`\",SUBSTITUTE(OFFSET(A10,-1,0,1,1),\".\",\"`\",2))),VALUE(RIGHT(OFFSET(A10,-1,0,1,1),LEN(OFFSET(A10,-1,0,1,1))-FIND(\"`\",SUBSTITUTE(OFFSET(A10,-1,0,1,1),\".\",\"`\",1))))+1,VALUE(MID(OFFSET(A10,-1,0,1,1),FIND(\"`\",SUBSTITUTE(OFFSET(A10,-1,0,1,1),\".\",\"`\",1))+1,(FIND(\"`\",SUBSTITUTE(OFFSET(A10,-1,0,1,1),\".\",\"`\",2))-FIND(\"`\",SUBSTITUTE(OFFSET(A10,-1,0,1,1),\".\",\"`\",1))-1)))+1)))","v":"1.1"},"[Task]",null,{"$f":"$D$4","v":""},{"$f":"D10+F10-1","v":"00:00:00"},1.0,null,{"$f":"NETWORKDAYS(D10,E10)","v":0},{"$f":"ROUNDDOWN(G10*F10,0)","v":0},{"$f":"F10-I10","v":1},{"$f":"IF(K$5=$D$5,\"t\",IF(AND(K$5>=$D10,K$5<$D10+$I10),\"c\",IF(AND(K$5>=$D10,K$5<=$D10+$F10-1),\"x\",\"\")))","v":""},"","","","","x","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["1.2","[Task]",null,null,"00:00:00",1.0,null,0,0,1,{"$f":"IF(K$5=$D$5,\"t\",IF(AND(K$5>=$D11,K$5<$D11+$I11),\"c\",IF(AND(K$5>=$D11,K$5<=$D11+$F11-1),\"x\",\"\")))","v":""},"","","","","x","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["1.3","[Task]",null,null,"00:00:00",1.0,null,0,0,1,{"$f":"IF(K$5=$D$5,\"t\",IF(AND(K$5>=$D12,K$5<$D12+$I12),\"c\",IF(AND(K$5>=$D12,K$5<=$D12+$F12-1),\"x\",\"\")))","v":""},"","","","","x","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["1.4","[Task]",null,null,"00:00:00",1.0,null,0,0,1,{"$f":"IF(K$5=$D$5,\"t\",IF(AND(K$5>=$D13,K$5<$D13+$I13),\"c\",IF(AND(K$5>=$D13,K$5<=$D13+$F13-1),\"x\",\"\")))","v":""},"","","","","x","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["1.5","[Task]",null,null,"00:00:00",1.0,null,0,0,1,{"$f":"IF(K$5=$D$5,\"t\",IF(AND(K$5>=$D14,K$5<$D14+$I14),\"c\",IF(AND(K$5>=$D14,K$5<=$D14+$F14-1),\"x\",\"\")))","v":""},"","","","","x","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[1.6,"[Task]"]
[{"$f":"IF(ISERROR(VALUE(SUBSTITUTE(OFFSET(A16,-1,0,1,1),\".\",\"\"))),\"0.1\",IF(ISERROR(FIND(\"`\",SUBSTITUTE(OFFSET(A16,-1,0,1,1),\".\",\"`\",1))),OFFSET(A16,-1,0,1,1)&\".1\",LEFT(OFFSET(A16,-1,0,1,1),FIND(\"`\",SUBSTITUTE(OFFSET(A16,-1,0,1,1),\".\",\"`\",1)))&IF(ISERROR(FIND(\"`\",SUBSTITUTE(OFFSET(A16,-1,0,1,1),\".\",\"`\",2))),VALUE(RIGHT(OFFSET(A16,-1,0,1,1),LEN(OFFSET(A16,-1,0,1,1))-FIND(\"`\",SUBSTITUTE(OFFSET(A16,-1,0,1,1),\".\",\"`\",1))))+1,VALUE(MID(OFFSET(A16,-1,0,1,1),FIND(\"`\",SUBSTITUTE(OFFSET(A16,-1,0,1,1),\".\",\"`\",1))+1,(FIND(\"`\",SUBSTITUTE(OFFSET(A16,-1,0,1,1),\".\",\"`\",2))-FIND(\"`\",SUBSTITUTE(OFFSET(A16,-1,0,1,1),\".\",\"`\",1))-1)))+1)))","v":"1.7"},"[Insert new rows above this one, then hide or delete this row]",{"$nulls":8},{"$f":"IF(K$5=$D$5,\"t\",IF(AND(K$5>=$D16,K$5<$D16+$I16),\"c\",IF(AND(K$5>=$D16,K$5<=$D16+$F16-1),\"x\",\"\")))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[{"$f":"IF(ISERROR(VALUE(SUBSTITUTE(OFFSET(A17,-1,0,1,1),\".\",\"\"))),\"1\",IF(ISERROR(FIND(\"`\",SUBSTITUTE(OFFSET(A17,-1,0,1,1),\".\",\"`\",1))),TEXT(VALUE(OFFSET(A17,-1,0,1,1))+1,\"#\"),TEXT(VALUE(LEFT(OFFSET(A17,-1,0,1,1),FIND(\"`\",SUBSTITUTE(OFFSET(A17,-1,0,1,1),\".\",\"`\",1))-1))+1,\"#\")))","v":"2"},"[ Task Category ]",null,{"$f":"min(D19:D21)","v":"1900-01-02"},{"$f":"max(E18:E23)","v":"1900-01-05"},{"$f":"E17-D17+1","v":4},null,{"$f":"NETWORKDAYS(D17,E17)","v":4},null,null,{"$f":"IF(K$5=$D$5,\"t\",IF(AND(K$5>=$D17,K$5<$D17+$I17),\"c\",IF(AND(K$5>=$D17,K$5<=$D17+$F17-1),\"x\",\"\")))","v":""},"","","","","","","x","x","x","x","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[{"$f":"IF(ISERROR(VALUE(SUBSTITUTE(OFFSET(A18,-1,0,1,1),\".\",\"\"))),\"0.1\",IF(ISERROR(FIND(\"`\",SUBSTITUTE(OFFSET(A18,-1,0,1,1),\".\",\"`\",1))),OFFSET(A18,-1,0,1,1)&\".1\",LEFT(OFFSET(A18,-1,0,1,1),FIND(\"`\",SUBSTITUTE(OFFSET(A18,-1,0,1,1),\".\",\"`\",1)))&IF(ISERROR(FIND(\"`\",SUBSTITUTE(OFFSET(A18,-1,0,1,1),\".\",\"`\",2))),VALUE(RIGHT(OFFSET(A18,-1,0,1,1),LEN(OFFSET(A18,-1,0,1,1))-FIND(\"`\",SUBSTITUTE(OFFSET(A18,-1,0,1,1),\".\",\"`\",1))))+1,VALUE(MID(OFFSET(A18,-1,0,1,1),FIND(\"`\",SUBSTITUTE(OFFSET(A18,-1,0,1,1),\".\",\"`\",1))+1,(FIND(\"`\",SUBSTITUTE(OFFSET(A18,-1,0,1,1),\".\",\"`\",2))-FIND(\"`\",SUBSTITUTE(OFFSET(A18,-1,0,1,1),\".\",\"`\",1))-1)))+1)))","v":"2.1"},"[Task]",null,{"$f":"$D$4","v":""},{"$f":"D18+F18-1","v":"00:00:00"},1.0,0.0,0,{"$f":"ROUNDDOWN(G18*F18,0)","v":0},{"$f":"F18-I18","v":1},{"$f":"IF(K$5=$D$5,\"t\",IF(AND(K$5>=$D18,K$5<$D18+$I18),\"c\",IF(AND(K$5>=$D18,K$5<=$D18+$F18-1),\"x\",\"\")))","v":""},"","","","","x","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["2.2","[Task]",null,{"$f":"WORKDAY(E18,1)","v":"1900-01-02"},"1900-01-02",1.0,0.0,1,0,1,{"$f":"IF(K$5=$D$5,\"t\",IF(AND(K$5>=$D19,K$5<$D19+$I19),\"c\",IF(AND(K$5>=$D19,K$5<=$D19+$F19-1),\"x\",\"\")))","v":""},"","","","","","","x","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["2.3","[Task]",null,"1900-01-03","1900-01-03",1.0,0.0,1,0,1,{"$f":"IF(K$5=$D$5,\"t\",IF(AND(K$5>=$D20,K$5<$D20+$I20),\"c\",IF(AND(K$5>=$D20,K$5<=$D20+$F20-1),\"x\",\"\")))","v":""},"","","","","","","","x","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["2.4","[Task]",null,"1900-01-04","1900-01-04",1.0,0.0,1,0,1,{"$f":"IF(K$5=$D$5,\"t\",IF(AND(K$5>=$D21,K$5<$D21+$I21),\"c\",IF(AND(K$5>=$D21,K$5<=$D21+$F21-1),\"x\",\"\")))","v":""},"","","","","","","","","x","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["2.5","[Task]",null,"1900-01-05","1900-01-05",1.0,0.0,1,0,1,{"$f":"IF(K$5=$D$5,\"t\",IF(AND(K$5>=$D22,K$5<$D22+$I22),\"c\",IF(AND(K$5>=$D22,K$5<=$D22+$F22-1),\"x\",\"\")))","v":""},"","","","","","","","","","x","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["2.6","[Insert new rows above this one, then hide or delete this row]",{"$nulls":8},{"$f":"IF(K$5=$D$5,\"t\",IF(AND(K$5>=$D23,K$5<$D23+$I23),\"c\",IF(AND(K$5>=$D23,K$5<=$D23+$F23-1),\"x\",\"\")))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[{"$f":"IF(ISERROR(VALUE(SUBSTITUTE(OFFSET(A24,-1,0,1,1),\".\",\"\"))),\"1\",IF(ISERROR(FIND(\"`\",SUBSTITUTE(OFFSET(A24,-1,0,1,1),\".\",\"`\",1))),TEXT(VALUE(OFFSET(A24,-1,0,1,1))+1,\"#\"),TEXT(VALUE(LEFT(OFFSET(A24,-1,0,1,1),FIND(\"`\",SUBSTITUTE(OFFSET(A24,-1,0,1,1),\".\",\"`\",1))-1))+1,\"#\")))","v":"3"},"[ Color Code by Lead ]",null,{"$f":"min(D25:D30)","v":"1900-01-02"},{"$f":"max(E25:E30)","v":"1900-01-05"},{"$f":"E24-D24+1","v":4},null,{"$f":"NETWORKDAYS(D24,E24)","v":4},null,null,{"$f":"IF(K$5=$D$5,\"t\",IF(AND(K$5>=$D24,K$5<$D24+$I24),\"c\",IF(AND(K$5>=$D24,K$5<=$D24+$F24-1),\"x\",\"\")))","v":""},"","","","","","","x","x","x","x","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[{"$f":"IF(ISERROR(VALUE(SUBSTITUTE(OFFSET(A25,-1,0,1,1),\".\",\"\"))),\"0.1\",IF(ISERROR(FIND(\"`\",SUBSTITUTE(OFFSET(A25,-1,0,1,1),\".\",\"`\",1))),OFFSET(A25,-1,0,1,1)&\".1\",LEFT(OFFSET(A25,-1,0,1,1),FIND(\"`\",SUBSTITUTE(OFFSET(A25,-1,0,1,1),\".\",\"`\",1)))&IF(ISERROR(FIND(\"`\",SUBSTITUTE(OFFSET(A25,-1,0,1,1),\".\",\"`\",2))),VALUE(RIGHT(OFFSET(A25,-1,0,1,1),LEN(OFFSET(A25,-1,0,1,1))-FIND(\"`\",SUBSTITUTE(OFFSET(A25,-1,0,1,1),\".\",\"`\",1))))+1,VALUE(MID(OFFSET(A25,-1,0,1,1),FIND(\"`\",SUBSTITUTE(OFFSET(A25,-1,0,1,1),\".\",\"`\",1))+1,(FIND(\"`\",SUBSTITUTE(OFFSET(A25,-1,0,1,1),\".\",\"`\",2))-FIND(\"`\",SUBSTITUTE(OFFSET(A25,-1,0,1,1),\".\",\"`\",1))-1)))+1)))","v":"3.1"},"[Task]",null,{"$f":"$D$4","v":""},{"$f":"D25+F25-1","v":"00:00:00"},1.0,0.0,0,{"$f":"ROUNDDOWN(G25*F25,0)","v":0},{"$f":"F25-I25","v":1},{"$f":"IF(K$5=$D$5,\"t\",IF(AND(K$5>=$D25,K$5<$D25+$I25),\"c\",IF(AND(K$5>=$D25,K$5<=$D25+$F25-1),\"x\",\"\")))","v":""},"","","","","x","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["3.2","[Task]",null,{"$f":"WORKDAY.INTL(E25,1,\"0000001\")","v":"1900-01-02"},"1900-01-02",1.0,0.0,1,0,1,{"$f":"IF(K$5=$D$5,\"t\",IF(AND(K$5>=$D26,K$5<$D26+$I26),\"c\",IF(AND(K$5>=$D26,K$5<=$D26+$F26-1),\"x\",\"\")))","v":""},"","","","","","","x","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["3.3","[Task]",null,"1900-01-03","1900-01-03",1.0,0.0,1,0,1,{"$f":"IF(K$5=$D$5,\"t\",IF(AND(K$5>=$D27,K$5<$D27+$I27),\"c\",IF(AND(K$5>=$D27,K$5<=$D27+$F27-1),\"x\",\"\")))","v":""},"","","","","","","","x","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["3.4","[Task]",null,"1900-01-04","1900-01-04",1.0,0.0,1,0,1,{"$f":"IF(K$5=$D$5,\"t\",IF(AND(K$5>=$D28,K$5<$D28+$I28),\"c\",IF(AND(K$5>=$D28,K$5<=$D28+$F28-1),\"x\",\"\")))","v":""},"","","","","","","","","x","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["3.5","[Task]",null,"1900-01-05","1900-01-05",1.0,0.0,1,0,1,{"$f":"IF(K$5=$D$5,\"t\",IF(AND(K$5>=$D29,K$5<$D29+$I29),\"c\",IF(AND(K$5>=$D29,K$5<=$D29+$F29-1),\"x\",\"\")))","v":""},"","","","","","","","","","x","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["3.6","[Insert new rows above this one, then hide or delete this row]",{"$nulls":8},{"$f":"IF(K$5=$D$5,\"t\",IF(AND(K$5>=$D30,K$5<$D30+$I30),\"c\",IF(AND(K$5>=$D30,K$5<=$D30+$F30-1),\"x\",\"\")))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[{"$f":"IF(ISERROR(VALUE(SUBSTITUTE(OFFSET(A31,-1,0,1,1),\".\",\"\"))),\"1\",IF(ISERROR(FIND(\"`\",SUBSTITUTE(OFFSET(A31,-1,0,1,1),\".\",\"`\",1))),TEXT(VALUE(OFFSET(A31,-1,0,1,1))+1,\"#\"),TEXT(VALUE(LEFT(OFFSET(A31,-1,0,1,1),FIND(\"`\",SUBSTITUTE(OFFSET(A31,-1,0,1,1),\".\",\"`\",1))-1))+1,\"#\")))","v":"4"},"[ Color Code by Lead ]",null,{"$f":"min(D32:D37)","v":"1900-01-01"},{"$f":"max(E32:E37)","v":"1900-01-04"},{"$f":"E31-D31+1","v":4},null,{"$f":"NETWORKDAYS(D31,E31)","v":3},null,null,{"$f":"IF(K$5=$D$5,\"t\",IF(AND(K$5>=$D31,K$5<$D31+$I31),\"c\",IF(AND(K$5>=$D31,K$5<=$D31+$F31-1),\"x\",\"\")))","v":""},"","","","","","x","x","x","x","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[{"$f":"IF(ISERROR(VALUE(SUBSTITUTE(OFFSET(A32,-1,0,1,1),\".\",\"\"))),\"0.1\",IF(ISERROR(FIND(\"`\",SUBSTITUTE(OFFSET(A32,-1,0,1,1),\".\",\"`\",1))),OFFSET(A32,-1,0,1,1)&\".1\",LEFT(OFFSET(A32,-1,0,1,1),FIND(\"`\",SUBSTITUTE(OFFSET(A32,-1,0,1,1),\".\",\"`\",1)))&IF(ISERROR(FIND(\"`\",SUBSTITUTE(OFFSET(A32,-1,0,1,1),\".\",\"`\",2))),VALUE(RIGHT(OFFSET(A32,-1,0,1,1),LEN(OFFSET(A32,-1,0,1,1))-FIND(\"`\",SUBSTITUTE(OFFSET(A32,-1,0,1,1),\".\",\"`\",1))))+1,VALUE(MID(OFFSET(A32,-1,0,1,1),FIND(\"`\",SUBSTITUTE(OFFSET(A32,-1,0,1,1),\".\",\"`\",1))+1,(FIND(\"`\",SUBSTITUTE(OFFSET(A32,-1,0,1,1),\".\",\"`\",2))-FIND(\"`\",SUBSTITUTE(OFFSET(A32,-1,0,1,1),\".\",\"`\",1))-1)))+1)))","v":"4.1"},"[Task]",null,{"$f":"$D$4","v":""},{"$f":"D32+F32-1","v":"00:00:00"},1.0,0.0,0,{"$f":"ROUNDDOWN(G32*F32,0)","v":0},{"$f":"F32-I32","v":1},{"$f":"IF(K$5=$D$5,\"t\",IF(AND(K$5>=$D32,K$5<$D32+$I32),\"c\",IF(AND(K$5>=$D32,K$5<=$D32+$F32-1),\"x\",\"\")))","v":""},"","","","","x","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["4.2","[Task]",null,{"$f":"E32+1","v":"1900-01-01"},"1900-01-01",1.0,0.0,0,0,1,{"$f":"IF(K$5=$D$5,\"t\",IF(AND(K$5>=$D33,K$5<$D33+$I33),\"c\",IF(AND(K$5>=$D33,K$5<=$D33+$F33-1),\"x\",\"\")))","v":""},"","","","","","x","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["4.3","[Task]",null,"1900-01-02","1900-01-02",1.0,0.0,1,0,1,{"$f":"IF(K$5=$D$5,\"t\",IF(AND(K$5>=$D34,K$5<$D34+$I34),\"c\",IF(AND(K$5>=$D34,K$5<=$D34+$F34-1),\"x\",\"\")))","v":""},"","","","","","","x","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["4.4","[Task]",null,"1900-01-03","1900-01-03",1.0,0.0,1,0,1,{"$f":"IF(K$5=$D$5,\"t\",IF(AND(K$5>=$D35,K$5<$D35+$I35),\"c\",IF(AND(K$5>=$D35,K$5<=$D35+$F35-1),\"x\",\"\")))","v":""},"","","","","","","","x","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["4.5","[Task]",null,"1900-01-04","1900-01-04",1.0,0.0,1,0,1,{"$f":"IF(K$5=$D$5,\"t\",IF(AND(K$5>=$D36,K$5<$D36+$I36),\"c\",IF(AND(K$5>=$D36,K$5<=$D36+$F36-1),\"x\",\"\")))","v":""},"","","","","","","","","x","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["4.6","[Insert new rows above this one, then hide or delete this row]",{"$nulls":8},{"$f":"IF(K$5=$D$5,\"t\",IF(AND(K$5>=$D37,K$5<$D37+$I37),\"c\",IF(AND(K$5>=$D37,K$5<=$D37+$F37-1),\"x\",\"\")))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[{"$f":"IF(ISERROR(VALUE(SUBSTITUTE(OFFSET(A38,-1,0,1,1),\".\",\"\"))),\"1\",IF(ISERROR(FIND(\"`\",SUBSTITUTE(OFFSET(A38,-1,0,1,1),\".\",\"`\",1))),TEXT(VALUE(OFFSET(A38,-1,0,1,1))+1,\"#\"),TEXT(VALUE(LEFT(OFFSET(A38,-1,0,1,1),FIND(\"`\",SUBSTITUTE(OFFSET(A38,-1,0,1,1),\".\",\"`\",1))-1))+1,\"#\")))","v":"5"},"[ Color Code by Lead ]",null,{"$f":"min(D39:D44)","v":"1900-01-01"},{"$f":"max(E39:E44)","v":"1900-01-04"},{"$f":"E38-D38+1","v":4},null,{"$f":"NETWORKDAYS(D38,E38)","v":3},null,null,{"$f":"IF(K$5=$D$5,\"t\",IF(AND(K$5>=$D38,K$5<$D38+$I38),\"c\",IF(AND(K$5>=$D38,K$5<=$D38+$F38-1),\"x\",\"\")))","v":""},"","","","","","x","x","x","x","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[{"$f":"IF(ISERROR(VALUE(SUBSTITUTE(OFFSET(A39,-1,0,1,1),\".\",\"\"))),\"0.1\",IF(ISERROR(FIND(\"`\",SUBSTITUTE(OFFSET(A39,-1,0,1,1),\".\",\"`\",1))),OFFSET(A39,-1,0,1,1)&\".1\",LEFT(OFFSET(A39,-1,0,1,1),FIND(\"`\",SUBSTITUTE(OFFSET(A39,-1,0,1,1),\".\",\"`\",1)))&IF(ISERROR(FIND(\"`\",SUBSTITUTE(OFFSET(A39,-1,0,1,1),\".\",\"`\",2))),VALUE(RIGHT(OFFSET(A39,-1,0,1,1),LEN(OFFSET(A39,-1,0,1,1))-FIND(\"`\",SUBSTITUTE(OFFSET(A39,-1,0,1,1),\".\",\"`\",1))))+1,VALUE(MID(OFFSET(A39,-1,0,1,1),FIND(\"`\",SUBSTITUTE(OFFSET(A39,-1,0,1,1),\".\",\"`\",1))+1,(FIND(\"`\",SUBSTITUTE(OFFSET(A39,-1,0,1,1),\".\",\"`\",2))-FIND(\"`\",SUBSTITUTE(OFFSET(A39,-1,0,1,1),\".\",\"`\",1))-1)))+1)))","v":"5.1"},"[Task]",null,{"$f":"$D$4","v":""},{"$f":"D39+F39-1","v":"00:00:00"},1.0,0.0,0,{"$f":"ROUNDDOWN(G39*F39,0)","v":0},{"$f":"F39-I39","v":1},{"$f":"IF(K$5=$D$5,\"t\",IF(AND(K$5>=$D39,K$5<$D39+$I39),\"c\",IF(AND(K$5>=$D39,K$5<=$D39+$F39-1),\"x\",\"\")))","v":""},"","","","","x","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["5.2","[Task]",null,{"$f":"E39+1","v":"1900-01-01"},"1900-01-01",1.0,0.0,0,0,1,{"$f":"IF(K$5=$D$5,\"t\",IF(AND(K$5>=$D40,K$5<$D40+$I40),\"c\",IF(AND(K$5>=$D40,K$5<=$D40+$F40-1),\"x\",\"\")))","v":""},"","","","","","x","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["5.3","[Task]",null,"1900-01-02","1900-01-02",1.0,0.0,1,0,1,{"$f":"IF(K$5=$D$5,\"t\",IF(AND(K$5>=$D41,K$5<$D41+$I41),\"c\",IF(AND(K$5>=$D41,K$5<=$D41+$F41-1),\"x\",\"\")))","v":""},"","","","","","","x","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["5.4","[Task]",null,"1900-01-03","1900-01-03",1.0,0.0,1,0,1,{"$f":"IF(K$5=$D$5,\"t\",IF(AND(K$5>=$D42,K$5<$D42+$I42),\"c\",IF(AND(K$5>=$D42,K$5<=$D42+$F42-1),\"x\",\"\")))","v":""},"","","","","","","","x","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["5.5","[Task]",null,"1900-01-04","1900-01-04",1.0,0.0,1,0,1,{"$f":"IF(K$5=$D$5,\"t\",IF(AND(K$5>=$D43,K$5<$D43+$I43),\"c\",IF(AND(K$5>=$D43,K$5<=$D43+$F43-1),\"x\",\"\")))","v":""},"","","","","","","","","x","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["5.6","[Insert new rows above this one, then hide or delete this row]",{"$nulls":8},{"$f":"IF(K$5=$D$5,\"t\",IF(AND(K$5>=$D44,K$5<$D44+$I44),\"c\",IF(AND(K$5>=$D44,K$5<=$D44+$F44-1),\"x\",\"\")))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[{"$nulls":10},{"$f":"IF(K$5=$D$5,\"t\",IF(AND(K$5>=$D45,K$5<$D45+$I45),\"c\",IF(AND(K$5>=$D45,K$5<=$D45+$F45-1),\"x\",\"\")))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[{"$nulls":10},{"$f":"IF(K$5=$D$5,\"t\",IF(AND(K$5>=$D46,K$5<$D46+$I46),\"c\",IF(AND(K$5>=$D46,K$5<=$D46+$F46-1),\"x\",\"\")))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["TEMPLATE ROWS",{"$nulls":9},{"$f":"IF(K$5=$D$5,\"t\",IF(AND(K$5>=$D47,K$5<$D47+$I47),\"c\",IF(AND(K$5>=$D47,K$5<=$D47+$F47-1),\"x\",\"\")))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["See the Help worksheet for information about using template rows.",{"$nulls":9},{"$f":"IF(K$5=$D$5,\"t\",IF(AND(K$5>=$D48,K$5<$D48+$I48),\"c\",IF(AND(K$5>=$D48,K$5<=$D48+$F48-1),\"x\",\"\")))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[{"$f":"IF(ISERROR(VALUE(SUBSTITUTE(OFFSET(A49,-1,0,1,1),\".\",\"\"))),\"1\",IF(ISERROR(FIND(\"`\",SUBSTITUTE(OFFSET(A49,-1,0,1,1),\".\",\"`\",1))),TEXT(VALUE(OFFSET(A49,-1,0,1,1))+1,\"#\"),TEXT(VALUE(LEFT(OFFSET(A49,-1,0,1,1),FIND(\"`\",SUBSTITUTE(OFFSET(A49,-1,0,1,1),\".\",\"`\",1))-1))+1,\"#\")))","v":"1"},"[ Task Category (label only) ]",{"$nulls":8},{"$f":"IF(K$5=$D$5,\"t\",IF(AND(K$5>=$D49,K$5<$D49+$I49),\"c\",IF(AND(K$5>=$D49,K$5<=$D49+$F49-1),\"x\",\"\")))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[{"$f":"IF(ISERROR(VALUE(SUBSTITUTE(OFFSET(A50,-1,0,1,1),\".\",\"\"))),\"1\",IF(ISERROR(FIND(\"`\",SUBSTITUTE(OFFSET(A50,-1,0,1,1),\".\",\"`\",1))),TEXT(VALUE(OFFSET(A50,-1,0,1,1))+1,\"#\"),TEXT(VALUE(LEFT(OFFSET(A50,-1,0,1,1),FIND(\"`\",SUBSTITUTE(OFFSET(A50,-1,0,1,1),\".\",\"`\",1))-1))+1,\"#\")))","v":"2"},"[ Task Category (summary) ]",null,{"$f":"MIN(D51:D53)","v":"00:00:00"},{"$f":"MAX(E51:E53)","v":"00:00:00"},{"$f":"E50-D50+1","v":1},null,{"$f":"NETWORKDAYS(D50,E50)","v":0},null,null,{"$f":"IF(K$5=$D$5,\"t\",IF(AND(K$5>=$D50,K$5<$D50+$I50),\"c\",IF(AND(K$5>=$D50,K$5<=$D50+$F50-1),\"x\",\"\")))","v":""},"","","","","x","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[{"$f":"IF(ISERROR(VALUE(SUBSTITUTE(OFFSET(A51,-1,0,1,1),\".\",\"\"))),\"0.1\",IF(ISERROR(FIND(\"`\",SUBSTITUTE(OFFSET(A51,-1,0,1,1),\".\",\"`\",1))),OFFSET(A51,-1,0,1,1)&\".1\",LEFT(OFFSET(A51,-1,0,1,1),FIND(\"`\",SUBSTITUTE(OFFSET(A51,-1,0,1,1),\".\",\"`\",1)))&IF(ISERROR(FIND(\"`\",SUBSTITUTE(OFFSET(A51,-1,0,1,1),\".\",\"`\",2))),VALUE(RIGHT(OFFSET(A51,-1,0,1,1),LEN(OFFSET(A51,-1,0,1,1))-FIND(\"`\",SUBSTITUTE(OFFSET(A51,-1,0,1,1),\".\",\"`\",1))))+1,VALUE(MID(OFFSET(A51,-1,0,1,1),FIND(\"`\",SUBSTITUTE(OFFSET(A51,-1,0,1,1),\".\",\"`\",1))+1,(FIND(\"`\",SUBSTITUTE(OFFSET(A51,-1,0,1,1),\".\",\"`\",2))-FIND(\"`\",SUBSTITUTE(OFFSET(A51,-1,0,1,1),\".\",\"`\",1))-1)))+1)))","v":"2.1"},"[ Level 2 Task ]",null,{"$f":"$D$4","v":""},{"$f":"D51+F51-1","v":"00:00:00"},1.0,0.0,0,{"$f":"ROUNDDOWN(G51*F51,0)","v":0},{"$f":"F51-I51","v":1},{"$f":"IF(K$5=$D$5,\"t\",IF(AND(K$5>=$D51,K$5<$D51+$I51),\"c\",IF(AND(K$5>=$D51,K$5<=$D51+$F51-1),\"x\",\"\")))","v":""},"","","","","x","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[{"$f":"IF(ISERROR(VALUE(SUBSTITUTE(OFFSET(A52,-1,0,1,1),\".\",\"\"))),\"0.0.1\",IF(ISERROR(FIND(\"`\",SUBSTITUTE(OFFSET(A52,-1,0,1,1),\".\",\"`\",2))),OFFSET(A52,-1,0,1,1)&\".1\",LEFT(OFFSET(A52,-1,0,1,1),FIND(\"`\",SUBSTITUTE(OFFSET(A52,-1,0,1,1),\".\",\"`\",2)))&IF(ISERROR(FIND(\"`\",SUBSTITUTE(OFFSET(A52,-1,0,1,1),\".\",\"`\",3))),VALUE(RIGHT(OFFSET(A52,-1,0,1,1),LEN(OFFSET(A52,-1,0,1,1))-FIND(\"`\",SUBSTITUTE(OFFSET(A52,-1,0,1,1),\".\",\"`\",2))))+1,VALUE(MID(OFFSET(A52,-1,0,1,1),FIND(\"`\",SUBSTITUTE(OFFSET(A52,-1,0,1,1),\".\",\"`\",2))+1,(FIND(\"`\",SUBSTITUTE(OFFSET(A52,-1,0,1,1),\".\",\"`\",3))-FIND(\"`\",SUBSTITUTE(OFFSET(A52,-1,0,1,1),\".\",\"`\",2))-1)))+1)))","v":"2.1.1"}," . [ Level 3 Task ]",null,"","00:00:00",1.0,0.0,0,0,1,{"$f":"IF(K$5=$D$5,\"t\",IF(AND(K$5>=$D52,K$5<$D52+$I52),\"c\",IF(AND(K$5>=$D52,K$5<=$D52+$F52-1),\"x\",\"\")))","v":""},"","","","","x","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[{"$f":"IF(ISERROR(VALUE(SUBSTITUTE(OFFSET(A53,-1,0,1,1),\".\",\"\"))),\"0.0.0.1\",IF(ISERROR(FIND(\"`\",SUBSTITUTE(OFFSET(A53,-1,0,1,1),\".\",\"`\",3))),OFFSET(A53,-1,0,1,1)&\".1\",LEFT(OFFSET(A53,-1,0,1,1),FIND(\"`\",SUBSTITUTE(OFFSET(A53,-1,0,1,1),\".\",\"`\",3)))&IF(ISERROR(FIND(\"`\",SUBSTITUTE(OFFSET(A53,-1,0,1,1),\".\",\"`\",4))),VALUE(RIGHT(OFFSET(A53,-1,0,1,1),LEN(OFFSET(A53,-1,0,1,1))-FIND(\"`\",SUBSTITUTE(OFFSET(A53,-1,0,1,1),\".\",\"`\",3))))+1,VALUE(MID(OFFSET(A53,-1,0,1,1),FIND(\"`\",SUBSTITUTE(OFFSET(A53,-1,0,1,1),\".\",\"`\",3))+1,(FIND(\"`\",SUBSTITUTE(OFFSET(A53,-1,0,1,1),\".\",\"`\",4))-FIND(\"`\",SUBSTITUTE(OFFSET(A53,-1,0,1,1),\".\",\"`\",3))-1)))+1)))","v":"2.1.1.1"}," . . [ Level 4 Task ]",null,"","00:00:00",1.0,0.0,0,0,1,{"$f":"IF(K$5=$D$5,\"t\",IF(AND(K$5>=$D53,K$5<$D53+$I53),\"c\",IF(AND(K$5>=$D53,K$5<=$D53+$F53-1),\"x\",\"\")))","v":""},"","","","","x","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]

{"sheet":"Help","index":1,"n_rows":95,"n_cols":3,"rows_kept":95,"cut":false,"hidden":false,"merged":[]}
["Help",null,"© 2012-2018 Vertex42 LLC"]
[null,null,{"$f":"HYPERLINK(\"https://www.vertex42.com/about.html\",\"Contact Vertex42\")","v":"Contact Vertex42"}]
["Introduction"]
[null,"This Gantt Chart spreadsheet makes creating a project schedule very easy. You only need to know some basic spreadsheet operations to make this gantt chart work for you, such as how to insert, delete, copy and paste entire rows."]
[]
[null,"Be sure to read the Getting Started Tips below."]
[]
[null,"The Share settings for this spreadsheet must always be set to \"Private\""]
[null,"See the TermsOfUse worksheet for more information about how you may or may not share this template."]
[]
["Getting Started Tips"]
[" - ","Input cells for defining the task dates and durations have a light green background.","Input Cell"]
[" - ","[ Bracketed Text ] is also meant to be edited, like the project title and task descriptions."]
[" - ","Some of the labels include cell notes to provide extra help information.","Label"]
[" - ","The Project Start Date determines the first week shown in the gantt chart."]
[" - ","To adjust the range of dates shown in the gantt chart, change the Display Week."]
[" - ","The red line in the gantt chart represents the date in the Today's Date cell. You can enter Today's Date manually or use the formula =TODAY()"]
[" - ","To insert a new task, insert a new row, then copy/paste an existing row from the selection of Template Rows at the bottom of the worksheet."]
[" - ","Edit the Holidays worksheet to choose which dates you want to exclude from Work Days."]
[]
["Cell Color Key"]
[]
["Input Cell"," :: Indicates which set of inputs to use"]
["Completed Task"," :: In the Gantt chart, indicates the completed portion of the task"]
["Incomplete Task"," :: In the Gantt chart, indicates the incomplete portion of the task"]
[]
["Using the Template Rows and Choosing a WBS Level"]
[]
[null,"Inserting New Tasks"]
[null,"1. Insert a new blank row where you want the new task to be"]
[null,"2. Copy the entire row you want to use from the set of template rows"]
[null,"3. Paste the row you copied on top of the blank row you just inserted"]
[null,"4. Copy and paste the WBS cell separately, based on the level (1,  2.1,  3.2.1,  4.3.2.1)"]
[]
[null," - When inserting new rows, you must copy and paste an entire row, because the cells of the Gantt chart area are formulas."]
[]
[null,"Changing the WBS Level in the WBS Column"]
[null," - The WBS numbering uses a different formula for each level, but the formula does not reference any other cell in the row. So, you can copy and paste just the WBS cell that you want to use."]
[]
[null," - If you leave a blank cell above a WBS number, the numbering will reset to 1.x.x. The formulas are meant for convenience, but you can manually enter them if you need to."]
[]
[null," - You can indent the task description for sub-tasks by entering spaces (until Google decides to add an indent option)."]
[]
[null,"Category Tasks"]
[null," - You can use tasks that are just labels, but it can be even more useful for a category task to display the minimum Start date and maximum End date of its sub tasks. This can be done using =MIN(range_of_startdates) and =MAX(range_of_enddates). An example template row is provided, but you will need to update the MIN() and MAX() formulas."]
[]
["Creating Task Dependencies"]
[]
[null," - You can enter the Start date manually, or define task dependecies using a formula. Below are the most common options for defining the Start date:"]
[]
["A.","Enter the date manually (e.g. 1/3/2015)"]
["B.","Reference the Project Start Date (e.g. =$E$4 )"]
["C.","Set the Start date to the next Work Day after another task's End date."]
[null," - Use the formula =WORKDAY(enddate,1) where enddate is the reference to the End date of a predecessor task."]
[null," - For multiple predecessors, the formula would be =MAX(WORKDAY(enddate1,1),WORKDAY(enddate2,1))"]
[]
["D.","Set the Start date to the next Calendar Day after another task's End date."]
[null," - This formula is very simple: =enddate+1"]
[null," - For multiple predecessors, the formula would be =MAX(enddate1,enddate2,enddate3 )+1"]
[]
["E.","Set the Start date to a number of days before or after another date."]
[null," - This formula is just like the one in C or D, except that in place of the \"1\" you enter the number of days, such as =WORKDAY(enddate,5) or =WORKDAY(startdate,-5)"]
[]
["FAQs"]
["Q:","What is the best way to Print?"]
[null,"First, select all of the rows you want to print. Then, in the Print Settings, choose \"Selection\" and check \"No Gridlines\". Fit to width and print in landscape."]
[null,"You also may want to hide the Days Done, Days Left, and Color columns prior to printing."]
[]
["Q:","How do I only show Monday-Friday in the chart area?"]
[null,"You can hide the columns that show the weekends."]
[]
["Q:","How do I print the entire range of dates for my project?"]
[null,"You would first need to add more columns to the displayed chart area. You can insert more columns to the right of the chart area and then copy and paste columns (7 at a time) to extend the display."]
[]
[null,"Note: The more columns you add to the right of the Gantt chart, the slower the recalculation speed will be, because of the number of additional formulas."]
[]
["Q:","How do I calculate the %Complete for a Summary task?"]
[null,"The %Complete for a summary task can be calculated from its sub tasks using the formula below, where \"workdays\" is a reference to the range of work days and \"complete\" is a reference to the %complete for each of the subtasks."]
[null," =ARRAYFORMULA( SUMPRODUCT( workdays, complete ) / SUM ( workdays ) )"]
[]
["Q:","The Start date, End date, or %Complete for a Level 1 task is wrong. How do I fix it?"]
[null,"When using =MIN(), =MAX(), and =SUMPRODUCT(), it is easy for the references to get messed up if you move rows around or insert new rows. You should verify and fix these formulas if they are not referencing the correct ranges."]
{"$rows_empty":11}
["Q:","I've messed up the chart area somehow. How do I fix it?"]
[null,"Find a row that works, then copy the cells that make up the gantt chart area from that row into the cells that are messed up."]

{"sheet":"GanttChartPro","index":2,"n_rows":39,"n_cols":2,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
["Gantt Chart Template Pro for Google Sheets"]
[]
[null,"Gantt Chart Template Pro, by Vertex42.com, is a spreadsheet template designed originally for Microsoft Excel that offers more features than the free version. When you purchase it, you will also get a link to download the Pro version for Google Sheets!!"]
[]
[null,{"$f":"HYPERLINK(\"https://www.vertex42.com/ExcelTemplates/gantt-chart-template-pro.html\",\"Learn More About Gantt Chart Template Pro\")","v":"Learn More About Gantt Chart Template Pro"}]
[]
[null," - Visit the web page above to view screenshots and watch demo videos"]
[]
["Features in the Pro version for Google Sheets"]
[]
[null,"Define task durations by specifying the number of Work Days"]
[null," - In this free version, the inputs to define a task are the Start Date and the Calendar Day duration. In the Pro version, the default option is to enter the Start Date and the number of Work Days."]
[]
[null,"Choose whether to define task durations using Calendar Days or Work Days or End Dates"]
[null," - The Pro version includes a larger set of template rows that provide more options for defining the Start date, End date, duration, and dependency of tasks."]
[]
[null,"Exclude holidays from work days"]
[null," - List holidays and other non-working days in a separate sheet. When defining task durations using Work Days, these dates will be excluded."]
[]
[null,"Define what you mean by \"Weekend\" when using Work Days"]
[null," - The Pro version allows you to define exactly which day(s) of the week you want to use as your weekend. The default is Saturday and Sunday."]
[]
[null,"Color-Code bars in the Gantt chart"]
[null," - The Pro version includes a column for entering a color code like \"k\", \"r\", or \"y\" to change the color of the bars in the Gantt chart. The Help worksheet explains some advanced formulas that you could use in the Color column to automatically color a bar based on the name in the Lead column."]
{"$rows_empty":13}
[null,"Define tasks dependences by specifying the predecessor WBS"]
[null," - The template rows include an option for entering a Predecessor WBS. The Start date will be calculated as the day following the End date of the predecessor."]

{"sheet":"TermsOfUse","index":3,"n_rows":20,"n_cols":2,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["Terms of Use"]
[]
[null,{"$f":"HYPERLINK(\"https://www.vertex42.com/ExcelTemplates/excel-gantt-chart.html\",\"Gantt Chart Template for Google Sheets\")","v":"Gantt Chart Template for Google Sheets"}]
[null,"© 2012-2018 Vertex42 LLC. All rights reserved."]
[]
[null,"This template is a copyrighted work under the Unites States and other copyright laws and is the property of Vertex42 LLC. The items listed below are additional points to help clarify how you may use this template."]
[]
[null,"You may make archival copies and customize this template only for your personal use or use within your company or organization and not for resale or public sharing."]
[]
[null,"You may not remove or alter any logo, trademark, copyright, disclaimer, brand, terms of use, attribution, or other proprietary notices or marks within this template."]
[]
[null,"This template and any customized or modified version of this template may NOT be sold, distributed, published to an online gallery, hosted on a website, or placed on a public server."]
[]
[null,"The Share Settings for this spreadsheet must always be set to \"Private\""]
[]
[null,"Limited Private Sharing and Other Allowed Uses"]
[null,"See the complete license agreement to learn more about how you may or may not use this template."]
[]
[null,"View the Complete License Agreement"]
[null,{"$f":"HYPERLINK(\"https://www.vertex42.com/licensing/EULA_privateuse.html\",\"https://www.vertex42.com/licensing/EULA_privateuse.html\")","v":"https://www.vertex42.com/licensing/EULA_privateuse.html"}]

{"sheet":"©","index":4,"n_rows":4,"n_cols":1,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
["Gantt Chart Template"]
["© 2012-2014 Vertex42 LLC"]
["Please note the Terms Of Use"]
["http://www.vertex42.com/licensing/EULA_privateuse.html"]