{"text_format":"2","workbook":"xlsx","n_sheets":3,"sheets":["Gantt Chart","Holidays","Calculations"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"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":"Gantt Chart","index":0,"n_rows":23,"n_cols":364,"rows_kept":23,"cut":false,"hidden":false,"merged":[[4,216,4,222],[4,223,4,229],[4,321,4,327],[4,328,4,334],[4,307,4,313],[4,300,4,306],[4,286,4,292],[4,293,4,299],[4,202,4,208],[4,195,4,201],[4,251,4,257],[4,237,4,243],[4,230,4,236],[4,209,4,215],[4,244,4,250],[4,118,4,124],[4,111,4,117],[4,349,4,355],[4,370,4,376],[4,363,4,369],[4,356,4,362],[4,258,4,264],[4,272,4,278],[4,279,4,285],[4,265,4,271],[4,342,4,348],[4,335,4,341],[4,314,4,320],[4,104,4,110],[4,125,4,131],[4,188,4,194],[4,97,4,103],[4,6,4,12],[4,69,4,75],[4,62,4,68],[4,76,4,82],[4,153,4,159],[4,13,4,19],[4,20,4,26],[4,48,4,54],[4,55,4,61],[4,90,4,96],[4,83,4,89],[4,27,4,33],[4,41,4,47],[4,34,4,40],[4,181,4,187],[4,174,4,180],[4,132,4,138],[4,146,4,152],[4,139,4,145],[4,160,4,166],[4,167,4,173]]}
["Gantt Chart",null,"Project Start Date",null,"2018-09-03"]
[null,null,"Current Date",null,{"$f":"TODAY()","v":"2018-09-26"}]
["Produced by: Sebastian, Eva, Matt, Kelsea "]
[]
[{"$nulls":6},"2018-09-03",{"$nulls":6},{"$f":"G5+7","v":"2018-09-10"},{"$nulls":6},{"$f":"N5+7","v":"2018-09-17"},{"$nulls":6},"2018-09-24",{"$nulls":6},"2018-10-01",{"$nulls":160},{"$f":"GG5+7","v":"1900-01-07"},{"$nulls":6},{"$f":"GN5+7","v":"1900-01-14"},{"$nulls":6},{"$f":"GU5+7","v":"1900-01-21"},{"$nulls":6},{"$f":"HB5+7","v":"1900-01-28"},{"$nulls":6},{"$f":"HI5+7","v":"1900-02-04"},{"$nulls":6},{"$f":"HP5+7","v":"1900-02-11"},{"$nulls":6},{"$f":"HW5+7","v":"1900-02-18"},{"$nulls":6},{"$f":"ID5+7","v":"1900-02-25"},{"$nulls":6},{"$f":"IK5+7","v":"1900-03-03"},{"$nulls":6},{"$f":"IR5+7","v":"1900-03-10"},{"$nulls":6},{"$f":"IY5+7","v":"1900-03-17"},{"$nulls":6},{"$f":"JF5+7","v":"1900-03-24"},{"$nulls":6},{"$f":"JM5+7","v":"1900-03-31"},{"$nulls":6},{"$f":"JT5+7","v":"1900-04-07"},{"$nulls":6},{"$f":"KA5+7","v":"1900-04-14"},{"$nulls":6},{"$f":"KH5+7","v":"1900-04-21"},{"$nulls":6},{"$f":"KO5+7","v":"1900-04-28"},{"$nulls":6},{"$f":"KV5+7","v":"1900-05-05"},{"$nulls":6},{"$f":"LC5+7","v":"1900-05-12"},{"$nulls":6},{"$f":"LJ5+7","v":"1900-05-19"},{"$nulls":6},{"$f":"LQ5+7","v":"1900-05-26"},{"$nulls":6},{"$f":"LX5+7","v":"1900-06-02"},{"$nulls":6},{"$f":"ME5+7","v":"1900-06-09"},{"$nulls":6},{"$f":"ML5+7","v":"1900-06-16"},{"$nulls":6},{"$f":"MS5+7","v":"1900-06-23"}]
["Task ID","Task Name","Duration","Start Date","Finish Date","%",{"$f":"E1","v":"2018-09-03"},{"$f":"G6+1","v":"2018-09-04"},"2018-09-05","2018-09-06","2018-09-07","2018-09-08","2018-09-09","2018-09-10","2018-09-11","2018-09-12","2018-09-13","2018-09-14","2018-09-15","2018-09-16","2018-09-17",{"$f":"U6+1","v":"2018-09-18"},"2018-09-19","2018-09-20","2018-09-21","2018-09-22","2018-09-23","2018-09-24","2018-09-25","2018-09-26","2018-09-27","2018-09-28","2018-09-29","2018-09-30","2018-10-01","2018-10-02","2018-10-03",4.0,5.0,6.0,7.0,8.0,9.0,10.0,11.0,12.0,13.0,14.0,15.0]
[1.0,"Indentitfy Object (Group)",1.0,{"$f":"E1","v":"2018-09-03"},{"$f":"WORKDAY(D7,C7,Holidays!$A$3:$B$11)","v":"2018-09-04"},1.0]
[2.0,"Take Photos of our object (Sebastian and Matt)",1.0,"2018-09-04",{"$f":"WORKDAY(D8,C8,Holidays!$A$3:$B$11)","v":"2018-09-05"},1.0]
[3.0,"Develop Hypothesis (Group)",1.0,"2018-09-04",{"$f":"WORKDAY(D9,C9,Holidays!$A$3:$B$11)","v":"2018-09-05"},1.0]
[4.0,"Create Sketches (Matt)",1.0,"2018-09-04",{"$f":"WORKDAY(D10,C10,Holidays!$A$3:$B$11)","v":"2018-09-05"},1.0]
[5.0,"Create Report on Google Docs (Eva)",10.0,"2018-09-04",{"$f":"WORKDAY(D11,C11,Holidays!$A$3:$B$11)","v":"2018-09-18"},0.5]
[6.0,"Create Project Timeline (Kelsea)",1.0,"2018-09-06",{"$f":"WORKDAY(D12,C12,Holidays!$A$3:$B$11)","v":"2018-09-07"}]
[7.0,"Create Presentation on Google slides (Group)",3.0,"2018-09-07",{"$f":"WORKDAY(D13,C13,Holidays!$A$3:$B$11)","v":"2018-09-12"},0.5]
[8.0,"Practice and Complete Presentation (Group)",1.0,"2018-09-11",{"$f":"WORKDAY(D14,C14,Holidays!$A$3:$B$11)","v":"2018-09-12"},0.0]
[9.0,"Create Gantt Chart (Group)",1.0,"2018-09-10",{"$f":"WORKDAY(D15,C15,Holidays!$A$3:$B$11)","v":"2018-09-11"},1.0]
[10.0,"Resume First Draft (Individual)",7.0,"2018-09-06",{"$f":"WORKDAY(D16,C16,Holidays!$A$3:$B$11)","v":"2018-09-17"},0.0]
[11.0,"Resume Final Draft  (Individual)",5.0,"2018-09-14",{"$f":"WORKDAY(D17,C17,Holidays!$A$3:$B$11)","v":"2018-09-21"},0.0]
[12.0,"Capstone Project Group  (Individual)",7.0,"2018-09-21",{"$f":"WORKDAY(D18,C18,Holidays!$A$3:$B$11)","v":"2018-10-02"},0.0]
[13.0,"Capstone Project Idea  (Individual)",7.0,"2018-09-21",{"$f":"WORKDAY(D19,C19,Holidays!$A$3:$B$11)","v":"2018-10-02"},0.0]
[14.0,"Website Update for reverse engineering project ",10.0,"2018-09-18",{"$f":"WORKDAY(D20,C20,Holidays!$A$3:$B$11)","v":"2018-10-02"}]
[15.0,"Possible mentors and names",10.0,"2018-09-18",{"$f":"WORKDAY(D21,C21,Holidays!$A$3:$B$11)","v":"2018-10-02"}]
[16.0,"Cover letter first draft",14.0,"2018-09-21",{"$f":"WORKDAY(D22,C22,Holidays!$A$3:$B$11)","v":"2018-10-11"}]
[17.0,"Cover letter final draft",20.0,"2018-09-21",{"$f":"WORKDAY(D23,C23,Holidays!$A$3:$B$11)","v":"2018-10-19"}]

{"sheet":"Holidays","index":1,"n_rows":11,"n_cols":2,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
["Holidays"]
["2013","2014"]
["2013-03-29","2014-01-01"]
["2013-04-01","2014-04-18"]
["2013-05-06","2014-04-21"]
["2013-05-27","2014-05-05"]
["2013-08-26","2011-05-30"]
["2013-12-25","2014-05-26"]
["2013-12-26","2014-08-25"]
[null,"2014-12-25"]
[null,"2014-12-26"]

{"sheet":"Calculations","index":2,"n_rows":18,"n_cols":2,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
["Duration complete"]
[{"$f":"'Gantt Chart'!$C7*'Gantt Chart'!$F7","v":1},{"$f":"WORKDAY('Gantt Chart'!$D7,Calculations!A7,holidays)","v":"#NAME?"}]
[{"$f":"'Gantt Chart'!$C8*'Gantt Chart'!$F8","v":1},{"$f":"WORKDAY('Gantt Chart'!$D8,Calculations!A8,holidays)","v":"#NAME?"}]
[{"$f":"'Gantt Chart'!$C9*'Gantt Chart'!$F9","v":1},{"$f":"WORKDAY('Gantt Chart'!$D9,Calculations!A9,holidays)","v":"#NAME?"}]
[{"$f":"'Gantt Chart'!$C10*'Gantt Chart'!$F10","v":1},{"$f":"WORKDAY('Gantt Chart'!$D10,Calculations!A10,holidays)","v":"#NAME?"}]
[{"$f":"'Gantt Chart'!$C11*'Gantt Chart'!$F11","v":5},{"$f":"WORKDAY('Gantt Chart'!$D11,Calculations!A11,holidays)","v":"#NAME?"}]
[{"$f":"'Gantt Chart'!$C13*'Gantt Chart'!$F13","v":1.5},{"$f":"WORKDAY('Gantt Chart'!$D13,Calculations!A12,holidays)","v":"#NAME?"}]
[{"$f":"'Gantt Chart'!$C14*'Gantt Chart'!$F14","v":0},{"$f":"WORKDAY('Gantt Chart'!$D14,Calculations!A13,holidays)","v":"#NAME?"}]
[{"$f":"'Gantt Chart'!$C15*'Gantt Chart'!$F15","v":1},{"$f":"WORKDAY('Gantt Chart'!$D15,Calculations!A14,holidays)","v":"#NAME?"}]
[{"$f":"'Gantt Chart'!$C16*'Gantt Chart'!$F16","v":0},{"$f":"WORKDAY('Gantt Chart'!$D16,Calculations!A15,holidays)","v":"#NAME?"}]
[{"$f":"'Gantt Chart'!$C17*'Gantt Chart'!$F17","v":0},{"$f":"WORKDAY('Gantt Chart'!$D17,Calculations!A16,holidays)","v":"#NAME?"}]
[{"$f":"'Gantt Chart'!$C18*'Gantt Chart'!$F18","v":0},{"$f":"WORKDAY('Gantt Chart'!$D18,Calculations!A17,holidays)","v":"#NAME?"}]
[{"$f":"'Gantt Chart'!$C20*'Gantt Chart'!$F20","v":0},{"$f":"WORKDAY('Gantt Chart'!$D20,Calculations!A18,holidays)","v":"#NAME?"}]