{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Project Executive Plan","Help"],"not_rendered":{"charts":0,"images":2,"macros":0,"external_links":0,"defined_names":0,"comments":2,"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":"Project Executive Plan","index":0,"n_rows":81,"n_cols":66,"rows_kept":81,"cut":false,"hidden":false,"merged":[[80,0,80,4],[80,5,80,6],[69,7,69,8],[70,7,70,8],[71,7,71,8],[72,7,72,8],[73,7,73,8],[74,7,74,8],[77,5,77,6],[78,5,78,6],[79,5,79,6],[75,3,75,4],[76,3,76,4],[77,3,77,4],[78,3,78,4],[79,3,79,4],[75,7,75,8],[76,7,76,8],[77,7,77,8],[78,7,78,8],[79,7,79,8],[77,0,77,1],[78,0,78,1],[79,0,79,1],[68,3,68,4],[69,3,69,4],[70,3,70,4],[71,3,71,4],[72,3,72,4],[73,3,73,4],[74,3,74,4],[71,0,71,1],[72,0,72,1],[73,0,73,1],[74,0,74,1],[75,0,75,1],[76,0,76,1],[13,58,13,64],[46,0,46,1],[69,0,69,1],[67,0,67,8],[68,0,68,1],[70,0,70,1],[68,5,68,6],[69,5,69,6],[70,5,70,6],[68,7,68,8],[15,2,15,3],[16,2,16,3],[17,2,17,3],[18,2,18,3],[19,2,19,3],[76,5,76,6],[71,5,71,6],[72,5,72,6],[73,5,73,6],[74,5,74,6],[75,5,75,6],[20,2,20,3],[12,30,12,36],[12,44,12,50],[12,51,12,57],[12,58,12,64],[13,9,13,15],[13,16,13,22],[13,23,13,29],[13,30,13,36],[13,37,13,43],[13,44,13,50],[13,51,13,57],[12,37,12,43],[9,4,9,5],[9,9,9,25],[10,1,10,3],[10,4,10,5],[11,1,11,3],[11,4,11,5],[12,1,12,3],[12,9,12,15],[12,16,12,22],[12,23,12,29],[62,0,62,1],[59,0,59,1],[59,2,59,3],[62,2,62,3],[45,0,45,8],[29,2,29,3],[30,2,30,3],[31,2,31,3],[21,2,21,3],[22,2,22,3],[24,2,24,3],[26,2,26,3],[25,2,25,3],[23,2,23,3],[34,2,34,3],[35,2,35,3],[36,2,36,3],[37,2,37,3],[38,2,38,3],[40,2,40,3],[41,2,41,3],[42,2,42,3],[43,2,43,3],[5,0,5,1],[2,1,2,50],[3,1,3,50],[4,1,4,50],[65,2,65,3],[65,5,65,8],[63,0,63,1],[63,2,63,3],[63,5,63,8],[64,0,64,1],[64,2,64,3],[64,5,64,8],[65,0,65,1],[62,5,62,8],[59,5,59,8],[61,0,61,1],[61,2,61,3],[61,5,61,8],[60,0,60,1],[60,2,60,3],[60,5,60,8],[27,2,27,3],[28,2,28,3],[32,2,32,3]]}
["John Courie Narrtive Review"]
["SMART Goals:   List at least 3 SMART Goals you hope to achieve through this project"]
[1,"Using computer automation, generate a list of MeSH compliant and nonMeSH boolean search terms comprised of an exhaustive iterative combination of the following elements by June 1, 2018. \n -A control vocabulary of terms related to plant based interventions ie: (phytotherapy, herbalism) \n -A  list of botanical names of plants used medicinally including variants  (ie: Berberis vs. Mahonia) from sources such as BHP83 or Skinderi.  \n -A comprehensive list of sexually transmitted diseases.  \n"]
[2,"Using communication and team-working competencies developed at MUIH recruit 1 peer interested in collaborating on research and coauthoring narrative review by June 2018.  \n"]
[3,"Conduct search of each search string generated in Google Scholar, PubMed, Register of Controlled Trials, MEDLINE, EMBASE, LILACS, Science Citation Index, the Chinese Biomedical Database, TCMLARS, CISCOM, AMED, and NAPRALERT.  Compile results that pass acceptance criteria into a citation database such as zotero by September 1, 2018 \n"]
[]
[]
[]
[]
["John Courie"]
[null,"Project Lead:",null,null,"John Courie"]
[null,"Project Start Date:",null,null,"2018-04-01",null,null,null,null,{"$f":"E12-WEEKDAY(E12,1)+2+7*(E13-1)","v":"2018-04-02"},{"$f":"J12+1","v":"2018-04-03"},{"$f":"K12+1","v":"2018-04-04"},"2018-04-05","2018-04-06","2018-04-07","2018-04-08","2018-04-09","2018-04-10","2018-04-11","2018-04-12","2018-04-13","2018-04-14","2018-04-15","2018-04-16","2018-04-17","2018-04-18","2018-04-19","2018-04-20","2018-04-21","2018-04-22","2018-04-23","2018-04-24","2018-04-25","2018-04-26","2018-04-27","2018-04-28","2018-04-29","2018-04-30","2018-05-01","2018-05-02","2018-05-03","2018-05-04","2018-05-05","2018-05-06","2018-05-07","2018-05-08","2018-05-09","2018-05-10","2018-05-11","2018-05-12","2018-05-13","2018-05-14","2018-05-15","2018-05-16","2018-05-17","2018-05-18","2018-05-19","2018-05-20","2018-05-21","2018-05-22","2018-05-23","2018-05-24","2018-05-25","2018-05-26","2018-05-27","2018-05-28"]
[null,"Display Week:",null,null,1,null,null,null,null,{"$f":"\"Week \"&(J12-($E$12-WEEKDAY($E$12,1)+2))/7+1","v":"Week 1"},null,null,null,null,null,null,{"$f":"\"Week \"&(Q12-($E$12-WEEKDAY($E$12,1)+2))/7+1","v":"Week 2"},null,null,null,null,null,null,{"$f":"\"Week \"&(X12-($E$12-WEEKDAY($E$12,1)+2))/7+1","v":"Week 3"},null,null,null,null,null,null,{"$f":"\"Week \"&(AE12-($E$12-WEEKDAY($E$12,1)+2))/7+1","v":"Week 4"},null,null,null,null,null,null,{"$f":"\"Week \"&(AL12-($E$12-WEEKDAY($E$12,1)+2))/7+1","v":"Week 5"},null,null,null,null,null,null,{"$f":"\"Week \"&(AS12-($E$12-WEEKDAY($E$12,1)+2))/7+1","v":"Week 6"},null,null,null,null,null,null,{"$f":"\"Week \"&(AZ12-($E$12-WEEKDAY($E$12,1)+2))/7+1","v":"Week 7"},null,null,null,null,null,null,{"$f":"\"Week \"&(BG12-($E$12-WEEKDAY($E$12,1)+2))/7+1","v":"Week 8"}]
[null,null,null,null,null,null,null,null,null,{"$f":"F6","v":"00:00:00"},null,null,null,null,null,null,{"$f":"Q12","v":"2018-04-09"},null,null,null,null,null,null,{"$f":"X12","v":"2018-04-16"},null,null,null,null,null,null,{"$f":"AE12","v":"2018-04-23"},null,null,null,null,null,null,{"$f":"AL12","v":"2018-04-30"},null,null,null,null,null,null,{"$f":"AS12","v":"2018-05-07"},null,null,null,null,null,null,{"$f":"AZ12","v":"2018-05-14"},null,null,null,null,null,null,{"$f":"BG12","v":"2018-05-21"}]
["WBS","Task","Lead",null,"Start","End","Cal. Days","%\nDone","Work Days",{"$f":"CHOOSE(WEEKDAY(J12,1),\"S\",\"M\",\"T\",\"W\",\"T\",\"F\",\"S\")","v":"M"},{"$f":"CHOOSE(WEEKDAY(K12,1),\"S\",\"M\",\"T\",\"W\",\"T\",\"F\",\"S\")","v":"T"},"W","T","F","S","S",{"$f":"CHOOSE(WEEKDAY(Q12,1),\"S\",\"M\",\"T\",\"W\",\"T\",\"F\",\"S\")","v":"M"},{"$f":"CHOOSE(WEEKDAY(R12,1),\"S\",\"M\",\"T\",\"W\",\"T\",\"F\",\"S\")","v":"T"},"W","T","F","S","S",{"$f":"CHOOSE(WEEKDAY(X12,1),\"S\",\"M\",\"T\",\"W\",\"T\",\"F\",\"S\")","v":"M"},{"$f":"CHOOSE(WEEKDAY(Y12,1),\"S\",\"M\",\"T\",\"W\",\"T\",\"F\",\"S\")","v":"T"},"W","T","F","S","S",{"$f":"CHOOSE(WEEKDAY(AE12,1),\"S\",\"M\",\"T\",\"W\",\"T\",\"F\",\"S\")","v":"M"},{"$f":"CHOOSE(WEEKDAY(AF12,1),\"S\",\"M\",\"T\",\"W\",\"T\",\"F\",\"S\")","v":"T"},"W","T","F","S","S",{"$f":"CHOOSE(WEEKDAY(AL12,1),\"S\",\"M\",\"T\",\"W\",\"T\",\"F\",\"S\")","v":"M"},{"$f":"CHOOSE(WEEKDAY(AM12,1),\"S\",\"M\",\"T\",\"W\",\"T\",\"F\",\"S\")","v":"T"},"W","T","F","S","S",{"$f":"CHOOSE(WEEKDAY(AS12,1),\"S\",\"M\",\"T\",\"W\",\"T\",\"F\",\"S\")","v":"M"},{"$f":"CHOOSE(WEEKDAY(AT12,1),\"S\",\"M\",\"T\",\"W\",\"T\",\"F\",\"S\")","v":"T"},"W","T","F","S","S",{"$f":"CHOOSE(WEEKDAY(AZ12,1),\"S\",\"M\",\"T\",\"W\",\"T\",\"F\",\"S\")","v":"M"},{"$f":"CHOOSE(WEEKDAY(BA12,1),\"S\",\"M\",\"T\",\"W\",\"T\",\"F\",\"S\")","v":"T"},"W","T","F","S","S",{"$f":"CHOOSE(WEEKDAY(BG12,1),\"S\",\"M\",\"T\",\"W\",\"T\",\"F\",\"S\")","v":"M"},{"$f":"CHOOSE(WEEKDAY(BH12,1),\"S\",\"M\",\"T\",\"W\",\"T\",\"F\",\"S\")","v":"T"},"W","T","F","S","S"]
[{"$f":"IF(ISERROR(VALUE(SUBSTITUTE(OFFSET(A16,-1,0,1,1),\".\",\"\"))),\"1\",IF(ISERROR(FIND(\"`\",SUBSTITUTE(OFFSET(A16,-1,0,1,1),\".\",\"`\",1))),TEXT(VALUE(OFFSET(A16,-1,0,1,1))+1,\"#\"),TEXT(VALUE(LEFT(OFFSET(A16,-1,0,1,1),FIND(\"`\",SUBSTITUTE(OFFSET(A16,-1,0,1,1),\".\",\"`\",1))-1))+1,\"#\")))","v":"1"},"Planning / Programming","[Name]"]
[{"$f":"IF(ISERROR(VALUE(SUBSTITUTE(OFFSET(A17,-1,0,1,1),\".\",\"\"))),\"0.1\",IF(ISERROR(FIND(\"`\",SUBSTITUTE(OFFSET(A17,-1,0,1,1),\".\",\"`\",1))),OFFSET(A17,-1,0,1,1)&\".1\",LEFT(OFFSET(A17,-1,0,1,1),FIND(\"`\",SUBSTITUTE(OFFSET(A17,-1,0,1,1),\".\",\"`\",1)))&IF(ISERROR(FIND(\"`\",SUBSTITUTE(OFFSET(A17,-1,0,1,1),\".\",\"`\",2))),VALUE(RIGHT(OFFSET(A17,-1,0,1,1),LEN(OFFSET(A17,-1,0,1,1))-FIND(\"`\",SUBSTITUTE(OFFSET(A17,-1,0,1,1),\".\",\"`\",1))))+1,VALUE(MID(OFFSET(A17,-1,0,1,1),FIND(\"`\",SUBSTITUTE(OFFSET(A17,-1,0,1,1),\".\",\"`\",1))+1,(FIND(\"`\",SUBSTITUTE(OFFSET(A17,-1,0,1,1),\".\",\"`\",2))-FIND(\"`\",SUBSTITUTE(OFFSET(A17,-1,0,1,1),\".\",\"`\",1))-1)))+1)))","v":"1.1"},"Develop Control Vocab Herbs (FORK task 2.1) ","John",null,"2018-04-01","2018-04-15",5,0,4]
["1.2","Develop list of botanical names ","John",null,"2018-04-16","2018-05-15",5,0,{"$f":"IF(OR(F18=0,E18=0),0,NETWORKDAYS(E18,F18))","v":22}]
["1.3","Develop list of diseases","John",null,"2018-05-16","2018-05-20",4,0,3]
["1.4","Setup Zotero database","John",null,"2018-04-01","2018-04-03",4,0,2]
["1.5","Generate combinations of terms into .csv (GOTO Task 3.1)","John",null,"2018-05-20","2018-06-01",2,0,10]
["1.6","Synthesis / Deduplication of results organized by narrative) (GOTO Task 4.1)","Collab",null,"2018-10-05","2018-10-10",3,0,4]
["1.7","Submit Poster for symposium ","Designer",null,"2018-11-01","2018-11-15",5,0,{"$f":"IF(OR(F23=0,E23=0),0,NETWORKDAYS(E23,F23))","v":11}]
["1.8","Upload open access version of article after published in journal ","Collab",null,null,"2019-06-01",7,0,{"$f":"IF(OR(F24=0,E24=0),0,NETWORKDAYS(E24,F24))","v":0}]
["1.9","Dicuss with stakeholders next steps or build consensus on successful conslusion","Collab",null,"2018-12-01","2019-01-01",7,0,{"$f":"IF(OR(F25=0,E25=0),0,NETWORKDAYS(E25,F25))","v":22}]
[{"$f":"IF(ISERROR(VALUE(SUBSTITUTE(OFFSET(A26,-1,0,1,1),\".\",\"\"))),\"1\",IF(ISERROR(FIND(\"`\",SUBSTITUTE(OFFSET(A26,-1,0,1,1),\".\",\"`\",1))),TEXT(VALUE(OFFSET(A26,-1,0,1,1))+1,\"#\"),TEXT(VALUE(LEFT(OFFSET(A26,-1,0,1,1),FIND(\"`\",SUBSTITUTE(OFFSET(A26,-1,0,1,1),\".\",\"`\",1))-1))+1,\"#\")))","v":"2"},"Communication"]
[{"$f":"IF(ISERROR(VALUE(SUBSTITUTE(OFFSET(A27,-1,0,1,1),\".\",\"\"))),\"0.1\",IF(ISERROR(FIND(\"`\",SUBSTITUTE(OFFSET(A27,-1,0,1,1),\".\",\"`\",1))),OFFSET(A27,-1,0,1,1)&\".1\",LEFT(OFFSET(A27,-1,0,1,1),FIND(\"`\",SUBSTITUTE(OFFSET(A27,-1,0,1,1),\".\",\"`\",1)))&IF(ISERROR(FIND(\"`\",SUBSTITUTE(OFFSET(A27,-1,0,1,1),\".\",\"`\",2))),VALUE(RIGHT(OFFSET(A27,-1,0,1,1),LEN(OFFSET(A27,-1,0,1,1))-FIND(\"`\",SUBSTITUTE(OFFSET(A27,-1,0,1,1),\".\",\"`\",1))))+1,VALUE(MID(OFFSET(A27,-1,0,1,1),FIND(\"`\",SUBSTITUTE(OFFSET(A27,-1,0,1,1),\".\",\"`\",1))+1,(FIND(\"`\",SUBSTITUTE(OFFSET(A27,-1,0,1,1),\".\",\"`\",2))-FIND(\"`\",SUBSTITUTE(OFFSET(A27,-1,0,1,1),\".\",\"`\",1))-1)))+1)))","v":"2.1"},"Generate list of potential colborators  ","John",null,{"$f":"E12","v":"2018-04-01"},"2018-04-15",1,0,{"$f":"IF(OR(F27=0,E27=0),0,NETWORKDAYS(E27,F27))","v":10}]
["2.2","reach out to collaborators via email","John",null,"2018-04-16","2018-05-01",1,0,12]
["2.3","If no response reach out to wider social network","John",null,"2018-05-02","2018-06-01",1,0,23]
["2.4","Bring new stakeholders up to speed on project and divide tasks","John",null,"2018-06-01","2018-06-30",1,0,{"$f":"IF(OR(F30=0,E30=0),0,NETWORKDAYS(E30,F30))","v":21}]
["2.5","Submit annotated bib for internal editing and comment","Collab",null,"2018-10-15","2018-11-01",7,0,{"$f":"IF(OR(F31=0,E31=0),0,NETWORKDAYS(E31,F31))","v":14}]
["2.6","Submit narrative review for internal editing and comment (GOTO TASK 4.4)","Collab",null,"2018-10-15","2018-11-01",7,0,{"$f":"IF(OR(F32=0,E32=0),0,NETWORKDAYS(E32,F32))","v":14}]
["2.7","Submit poster for internal editing and comment (GOTO TASK 1.7)","Collab",null,"2018-11-01","2018-11-15",1,0,11]
[{"$f":"IF(ISERROR(VALUE(SUBSTITUTE(OFFSET(A34,-1,0,1,1),\".\",\"\"))),\"1\",IF(ISERROR(FIND(\"`\",SUBSTITUTE(OFFSET(A34,-1,0,1,1),\".\",\"`\",1))),TEXT(VALUE(OFFSET(A34,-1,0,1,1))+1,\"#\"),TEXT(VALUE(LEFT(OFFSET(A34,-1,0,1,1),FIND(\"`\",SUBSTITUTE(OFFSET(A34,-1,0,1,1),\".\",\"`\",1))-1))+1,\"#\")))","v":"3"},"Research"]
[{"$f":"IF(ISERROR(VALUE(SUBSTITUTE(OFFSET(A35,-1,0,1,1),\".\",\"\"))),\"0.1\",IF(ISERROR(FIND(\"`\",SUBSTITUTE(OFFSET(A35,-1,0,1,1),\".\",\"`\",1))),OFFSET(A35,-1,0,1,1)&\".1\",LEFT(OFFSET(A35,-1,0,1,1),FIND(\"`\",SUBSTITUTE(OFFSET(A35,-1,0,1,1),\".\",\"`\",1)))&IF(ISERROR(FIND(\"`\",SUBSTITUTE(OFFSET(A35,-1,0,1,1),\".\",\"`\",2))),VALUE(RIGHT(OFFSET(A35,-1,0,1,1),LEN(OFFSET(A35,-1,0,1,1))-FIND(\"`\",SUBSTITUTE(OFFSET(A35,-1,0,1,1),\".\",\"`\",1))))+1,VALUE(MID(OFFSET(A35,-1,0,1,1),FIND(\"`\",SUBSTITUTE(OFFSET(A35,-1,0,1,1),\".\",\"`\",1))+1,(FIND(\"`\",SUBSTITUTE(OFFSET(A35,-1,0,1,1),\".\",\"`\",2))-FIND(\"`\",SUBSTITUTE(OFFSET(A35,-1,0,1,1),\".\",\"`\",1))-1)))+1)))","v":"3.1"},"Conduct Abstract search, enter results in zotero","Collab",null,"2018-06-01","2018-08-01",1,0,{"$f":"IF(OR(F35=0,E35=0),0,NETWORKDAYS(E35,F35))","v":44}]
["3.2","Pull fulltext results for open access articles. ","Collab",null,"2018-08-01","2018-09-01",1,0,23]
["3.3","Identify potential journals for publishing ","Collab and Mentors",null,"2018-09-03","2018-10-05",1,0,{"$f":"IF(OR(F37=0,E37=0),0,NETWORKDAYS(E37,F37))","v":25}]
["3.4","Identify closed access articles meeting inclusion criteria","Collab",null,"2018-08-01","2018-09-01",1,0,23]
["3.5","review selected articles (GOTO Tack 1.6)","Collab",null,"2018-09-01","2018-10-05",1,0,25]
[{"$f":"IF(ISERROR(VALUE(SUBSTITUTE(OFFSET(A40,-1,0,1,1),\".\",\"\"))),\"1\",IF(ISERROR(FIND(\"`\",SUBSTITUTE(OFFSET(A40,-1,0,1,1),\".\",\"`\",1))),TEXT(VALUE(OFFSET(A40,-1,0,1,1))+1,\"#\"),TEXT(VALUE(LEFT(OFFSET(A40,-1,0,1,1),FIND(\"`\",SUBSTITUTE(OFFSET(A40,-1,0,1,1),\".\",\"`\",1))-1))+1,\"#\")))","v":"4"},"Interpretation "]
[{"$f":"IF(ISERROR(VALUE(SUBSTITUTE(OFFSET(A41,-1,0,1,1),\".\",\"\"))),\"0.1\",IF(ISERROR(FIND(\"`\",SUBSTITUTE(OFFSET(A41,-1,0,1,1),\".\",\"`\",1))),OFFSET(A41,-1,0,1,1)&\".1\",LEFT(OFFSET(A41,-1,0,1,1),FIND(\"`\",SUBSTITUTE(OFFSET(A41,-1,0,1,1),\".\",\"`\",1)))&IF(ISERROR(FIND(\"`\",SUBSTITUTE(OFFSET(A41,-1,0,1,1),\".\",\"`\",2))),VALUE(RIGHT(OFFSET(A41,-1,0,1,1),LEN(OFFSET(A41,-1,0,1,1))-FIND(\"`\",SUBSTITUTE(OFFSET(A41,-1,0,1,1),\".\",\"`\",1))))+1,VALUE(MID(OFFSET(A41,-1,0,1,1),FIND(\"`\",SUBSTITUTE(OFFSET(A41,-1,0,1,1),\".\",\"`\",1))+1,(FIND(\"`\",SUBSTITUTE(OFFSET(A41,-1,0,1,1),\".\",\"`\",2))-FIND(\"`\",SUBSTITUTE(OFFSET(A41,-1,0,1,1),\".\",\"`\",1))-1)))+1)))","v":"4.1"},"Compose annotated bibliography (FORK Tasks 4.2/4.3) (GOTO Task 2.5)","Collab",null,"2018-10-10","2018-10-15",1,0,{"$f":"IF(OR(F41=0,E41=0),0,NETWORKDAYS(E41,F41))","v":4}]
["4.2","Compose narrative review (GOTO Task 2.6)","Collab",null,"2018-10-10","2018-11-01",1,0,17]
["4.3","Compose poster presentation (GOTO Task 2.7)","Collab",null,"2018-10-10","2018-11-01",1,0,17]
["4.4","Submit article for peer review in selected journal (GOTO Task 1.9)","Authors",null,"2018-12-01","2018-12-01",1,0,0]
[]
["RESOURCE PEOPLE (add rows if needed)"]
["TEMPLATE ROWS"]
["See the Help worksheet to learn how to use these rows. You can hide these rows before printing."]
["CATEGORY ROWS and WBS NUMBERING"]
[{"$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":"1"},"[ Task Category (label only) ]"]
[{"$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":"1.1"},"[ Level 2 Task ]"]
[{"$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":"1.1.1"}," . [ Level 3 Task ]"]
[{"$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":"1.1.1.1"}," . . [ Level 4 Task ]"]
["Examples of ways to define tasks"]
[{"$f":"IF(ISERROR(VALUE(SUBSTITUTE(OFFSET(A55,-1,0,1,1),\".\",\"\"))),\"1\",IF(ISERROR(FIND(\"`\",SUBSTITUTE(OFFSET(A55,-1,0,1,1),\".\",\"`\",1))),TEXT(VALUE(OFFSET(A55,-1,0,1,1))+1,\"#\"),TEXT(VALUE(LEFT(OFFSET(A55,-1,0,1,1),FIND(\"`\",SUBSTITUTE(OFFSET(A55,-1,0,1,1),\".\",\"`\",1))-1))+1,\"#\")))","v":"1"},"[ Task Category (summary) ]",null,null,{"$f":"MIN(E56:E59)","v":"2015-04-01"},{"$f":"MAX(F56:F59)","v":"2015-04-17"},{"$f":"IF(OR(F55=0,E55=0),0,F55-E55+1)","v":17},null,{"$f":"IF(OR(F55=0,E55=0),0,NETWORKDAYS(E55,F55))","v":13}]
["2","Milestone",null,null,"2015-04-01",{"$f":"IF(G56=0,E56,E56+G56-1)","v":"2015-04-01"},1,null,{"$f":"IF(OR(F56=0,E56=0),0,NETWORKDAYS(E56,F56))","v":1}]
[{"$f":"IF(ISERROR(VALUE(SUBSTITUTE(OFFSET(A57,-1,0,1,1),\".\",\"\"))),\"0.1\",IF(ISERROR(FIND(\"`\",SUBSTITUTE(OFFSET(A57,-1,0,1,1),\".\",\"`\",1))),OFFSET(A57,-1,0,1,1)&\".1\",LEFT(OFFSET(A57,-1,0,1,1),FIND(\"`\",SUBSTITUTE(OFFSET(A57,-1,0,1,1),\".\",\"`\",1)))&IF(ISERROR(FIND(\"`\",SUBSTITUTE(OFFSET(A57,-1,0,1,1),\".\",\"`\",2))),VALUE(RIGHT(OFFSET(A57,-1,0,1,1),LEN(OFFSET(A57,-1,0,1,1))-FIND(\"`\",SUBSTITUTE(OFFSET(A57,-1,0,1,1),\".\",\"`\",1))))+1,VALUE(MID(OFFSET(A57,-1,0,1,1),FIND(\"`\",SUBSTITUTE(OFFSET(A57,-1,0,1,1),\".\",\"`\",1))+1,(FIND(\"`\",SUBSTITUTE(OFFSET(A57,-1,0,1,1),\".\",\"`\",2))-FIND(\"`\",SUBSTITUTE(OFFSET(A57,-1,0,1,1),\".\",\"`\",1))-1)))+1)))","v":"2.1"},"[ Start Date and Calendar Days ]",null,null,"2015-04-01",{"$f":"IF(G57=0,E57,E57+G57-1)","v":"2015-04-03"},3,null,{"$f":"IF(OR(F57=0,E57=0),0,NETWORKDAYS(E57,F57))","v":3}]
[{"$f":"IF(ISERROR(VALUE(SUBSTITUTE(OFFSET(A58,-1,0,1,1),\".\",\"\"))),\"0.1\",IF(ISERROR(FIND(\"`\",SUBSTITUTE(OFFSET(A58,-1,0,1,1),\".\",\"`\",1))),OFFSET(A58,-1,0,1,1)&\".1\",LEFT(OFFSET(A58,-1,0,1,1),FIND(\"`\",SUBSTITUTE(OFFSET(A58,-1,0,1,1),\".\",\"`\",1)))&IF(ISERROR(FIND(\"`\",SUBSTITUTE(OFFSET(A58,-1,0,1,1),\".\",\"`\",2))),VALUE(RIGHT(OFFSET(A58,-1,0,1,1),LEN(OFFSET(A58,-1,0,1,1))-FIND(\"`\",SUBSTITUTE(OFFSET(A58,-1,0,1,1),\".\",\"`\",1))))+1,VALUE(MID(OFFSET(A58,-1,0,1,1),FIND(\"`\",SUBSTITUTE(OFFSET(A58,-1,0,1,1),\".\",\"`\",1))+1,(FIND(\"`\",SUBSTITUTE(OFFSET(A58,-1,0,1,1),\".\",\"`\",2))-FIND(\"`\",SUBSTITUTE(OFFSET(A58,-1,0,1,1),\".\",\"`\",1))-1)))+1)))","v":"2.2"},"[ Start the next day after another Task ]",null,null,{"$f":"F57+1","v":"2015-04-04"},{"$f":"IF(G58=0,E58,E58+G58-1)","v":"2015-04-10"},7,null,{"$f":"IF(OR(F58=0,E58=0),0,NETWORKDAYS(E58,F58))","v":5}]
[{"$f":"IF(ISERROR(VALUE(SUBSTITUTE(OFFSET(A59,-1,0,1,1),\".\",\"\"))),\"0.1\",IF(ISERROR(FIND(\"`\",SUBSTITUTE(OFFSET(A59,-1,0,1,1),\".\",\"`\",1))),OFFSET(A59,-1,0,1,1)&\".1\",LEFT(OFFSET(A59,-1,0,1,1),FIND(\"`\",SUBSTITUTE(OFFSET(A59,-1,0,1,1),\".\",\"`\",1)))&IF(ISERROR(FIND(\"`\",SUBSTITUTE(OFFSET(A59,-1,0,1,1),\".\",\"`\",2))),VALUE(RIGHT(OFFSET(A59,-1,0,1,1),LEN(OFFSET(A59,-1,0,1,1))-FIND(\"`\",SUBSTITUTE(OFFSET(A59,-1,0,1,1),\".\",\"`\",1))))+1,VALUE(MID(OFFSET(A59,-1,0,1,1),FIND(\"`\",SUBSTITUTE(OFFSET(A59,-1,0,1,1),\".\",\"`\",1))+1,(FIND(\"`\",SUBSTITUTE(OFFSET(A59,-1,0,1,1),\".\",\"`\",2))-FIND(\"`\",SUBSTITUTE(OFFSET(A59,-1,0,1,1),\".\",\"`\",1))-1)))+1)))","v":"2.3"},"[ Start next work day after another Task]",null,null,{"$f":"WORKDAY(F58,1)","v":"2015-04-13"},"2015-04-17",5,null,5]
["Full Name",null,"Organization/ Position",null,"Contact Number","Comments"]
["John Courie II",null,"Project Manager",null,"<Unlisted> "]
["Co Authors TBD"]
["Editors TBD"]
["Graphic designers for poster TBD"]
[]
[]
[]
["BUDGET (add rows if needed)"]
["Resources and Expenses",null,"# units","Price per unit",null,"Total Project Cost",null,"Comment"]
["Collaboration software and statistical software",null,1,0,null,{"$f":"C70*D70","v":0}]
["Cloud Backup and collboration software (annual) ",null,1,300,null,{"$f":"C71*D71","v":300},null,"Free optns?  "]
["Access to articles (estimate) ",null,60,25,null,1500]
["Journal review fee",null,1,500,null,500]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
["Total Project Expenses",null,null,null,null,{"$f":"SUM(F70:G80)","v":2300}]

{"sheet":"Help","index":1,"n_rows":101,"n_cols":3,"rows_kept":101,"cut":false,"hidden":false,"merged":[[68,0,68,1],[3,0,3,1],[15,0,15,1],[26,0,26,1],[46,0,46,1],[62,0,62,1],[65,0,65,1]]}
["HELP"]
["Version: Gantt Chart Template for Office 365 - FREE Version"]
[]
["Intro"]
[null,"This Gantt Chart spreadsheet is designed to to help you create a simple project schedule. You"]
[null,"only need to know some basic spreadsheet operations, such as how to insert, delete, copy and"]
[null,"and paste rows and cells. For more advanced uses, such as defining task dependencies, you"]
[null,"will need to know how to enter formulas."]
[]
[null,"Be sure to read the Getting Started Tips below. Watching the video demos for Gantt Chart Template Pro may also help you see how to use the spreadsheet."]
[]
[null,"Watch Demo Videos on Vertex42.com"]
[]
[null,"Before sharing this spreadsheet, please read the license agreement in the TermsOfUse worksheet."]
[]
["Getting Started Tips"]
[null," - Input cells for defining the task dates and durations have a light green background.","Input Cell"]
[null," - [ Bracketed Text ] is meant to be edited, like the project title and task descriptions."]
[null," - Some of the labels include cell comments to provide extra help information.","Label"]
[null," - The Project Start Date determines the first week shown in the gantt chart."]
[null," - To adjust the range of dates shown in the gantt chart, change the Display Week."]
[null," - To insert a new task, insert a new row, then copy/paste a row from the selection of template"]
[null,"rows at the bottom of the worksheet, depending on how you want to define the task."]
[null," - If you see \"#####\" in a cell, widen the column to display the cell contents."]
[null," - Backup your file regularly to avoid losing data! Excel files get corrupted occasionally."]
[]
["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 new row you just inserted."]
[null,"4. Copy and paste the WBS cell separately, based on the level (1, 1.2, 1.2.3, 1.2.3.4)"]
[]
[null,"Important: 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 leading spaces or using the Indent feature in Excel."]
[]
[null,"Category Tasks"]
[null," - You can use tasks that are just labels, but it may be 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)."]
[]
["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)"]
["E.","Use the Predecessor column to start the day after another task"]
[null,"[ Template rows that use this feature are only in the PRO version ]"]
[]
["Changing the End Date Font to Red when Behind Schedule"]
[null,"[ This feature is only in the PRO version, but if you are familiar with conditional formatting, you could try doing this yourself. ]"]
[]
["Changing the Color of the Bars in the Gantt Chart"]
[null,"[ This feature is only in the PRO version. ]"]
[]
["FAQs"]
["Q:","How do I enter the Work Days instead of Calendar Days?"]
[null,"Entering work days instead of calendar days is one of the main features of the Pro version. If you want to figure it out on your own, use the WORKDAY() function to define the End Date and calculate the Calendar Days based on the Start and End dates."]
[]
["Q:","How do I calculate the %Complete for an entire category of tasks?"]
[null,"The %Complete for a category task can be calculated from its sub tasks using the formula below, where \"workdays\" is a reference to the range of work day values and \"complete\" is a reference to the %complete for each of the subtasks."]
[null,"=SUMPRODUCT(workdays,complete)/SUM(workdays)"]
[null,"Example: =SUMPRODUCT(H9:H15,J9:J15)/SUM(H9:H15)"]
[null,"Let's say you have 3 sub tasks that are 10 days, 12 days, and 14 days long, respectively. If the first subtask is 50% complete and the others are 25% complete, you could calculate the overall percent complete for the group as: =(10*50%+12*25%+14*25%)/(10+12+14)."]
[]
["Q:","How do I change the Print Settings? (Excel 2010, 2013)"]
[null,"Select the entire range of cells you want to print and go to File > Print Area > Set Print Area."]
[null,"Then go to File > Page Setup or File > Print Preview and adjust the Scaling, Marings, and"]
[null,"Page Orientation as desired."]
[]
["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."]
[null,"Example: The image below shows that the MIN() function is not referencing all of the sub tasks."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["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 row that is messed up."]
[]
["© 2015 Vertex42 LLC"]