{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Projects Overview","Task Details"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":4,"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":"Projects Overview","index":0,"n_rows":7,"n_cols":7,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[null,"Projects Overview"]
[]
[null,"Project","  ","Progress"," Start"," End","Notes"]
[null,"Plan Vacation",{"$f":"IFERROR((SUMIFS(Tasks[Done],Tasks[Project],Projects[[#This Row],[Project]])/COUNTIFS(Tasks[Project],Projects[[#This Row],[Project]]))+0.0001,0.0001)","v":0.50009999999999999},{"$f":"REPT(\"|\",Projects[[  ]]*175)","v":"|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||"},{"$f":"MIN(IF((Tasks[Project]=Projects[[#This Row],[Project]])*(Tasks[Start]>0),Tasks[Start]))","v":"2011-10-01"},{"$f":"MAX(IF((Tasks[Project]=Projects[[#This Row],[Project]])*(Tasks[Start]>0),Tasks[[Start]:[End]]))","v":"2011-12-31"},"We're going to Belize!"]
[null,"Plan Sara's Surprise Party",{"$f":"IFERROR((SUMIFS(Tasks[Done],Tasks[Project],Projects[[#This Row],[Project]])/COUNTIFS(Tasks[Project],Projects[[#This Row],[Project]]))+0.0001,0.0001)","v":1.0001},{"$f":"REPT(\"|\",Projects[[  ]]*175)","v":"|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||"},{"$f":"MIN(IF((Tasks[Project]=Projects[[#This Row],[Project]])*(Tasks[Start]>0),Tasks[Start]))","v":"2011-09-10"},{"$f":"MAX(IF((Tasks[Project]=Projects[[#This Row],[Project]])*(Tasks[Start]>0),Tasks[[Start]:[End]]))","v":"2011-10-03"}]
[null,"Train for Marathon",{"$f":"IFERROR((SUMIFS(Tasks[Done],Tasks[Project],Projects[[#This Row],[Project]])/COUNTIFS(Tasks[Project],Projects[[#This Row],[Project]]))+0.0001,0.0001)","v":0.28581428571428569},{"$f":"REPT(\"|\",Projects[[  ]]*175)","v":"||||||||||||||||||||||||||||||||||||||||||||||||||"},{"$f":"MIN(IF((Tasks[Project]=Projects[[#This Row],[Project]])*(Tasks[Start]>0),Tasks[Start]))","v":"2011-09-01"},{"$f":"MAX(IF((Tasks[Project]=Projects[[#This Row],[Project]])*(Tasks[Start]>0),Tasks[[Start]:[End]]))","v":"2012-04-18"},"Break my record on April 18"]
[null,"Enroll Sara in Swimming Lessons",{"$f":"IFERROR((SUMIFS(Tasks[Done],Tasks[Project],Projects[[#This Row],[Project]])/COUNTIFS(Tasks[Project],Projects[[#This Row],[Project]]))+0.0001,0.0001)","v":1E-4},{"$f":"REPT(\"|\",Projects[[  ]]*175)","v":""},{"$f":"MIN(IF((Tasks[Project]=Projects[[#This Row],[Project]])*(Tasks[Start]>0),Tasks[Start]))","v":"2011-10-01"},{"$f":"MAX(IF((Tasks[Project]=Projects[[#This Row],[Project]])*(Tasks[Start]>0),Tasks[[Start]:[End]]))","v":"2011-10-15"}]

{"sheet":"Task Details","index":1,"n_rows":21,"n_cols":7,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[null,"Task Details"]
[]
[null,"Start","End","Project","Task","Done","Notes"]
[null,"2011-10-01","2011-10-15","Plan Vacation","Choose between tropical & temperate",1,"Chose tropical.  Belize here we come!"]
[null,"2011-10-15","2011-12-31","Plan Vacation","Monitor spring air fare rates online"]
[null,"2011-10-15",null,"Plan Vacation","Study the history and culture of Belize"]
[null,"2011-10-15","2011-10-20","Plan Vacation","Study resort reviews",1]
[null,"2011-10-20",null,"Plan Vacation","Make reservations at resort",1,"April 19 through April 30"]
[null,"2011-10-20","2011-11-15","Plan Vacation","Get passports for the entire family",null,"Consider the rush option…"]
[null,"2011-09-01","2011-09-30","Train for Marathon","10 miles a day",1,"Race is on April 18"]
[null,"2011-10-01","2011-10-31","Train for Marathon","12 miles a day",1]
[null,"2011-11-01","2011-11-30","Train for Marathon","14 miles a day"]
[null,"2011-12-01","2012-04-15","Train for Marathon","15 miles a day"]
[null,"2012-04-16",null,"Train for Marathon","Travel to marathon"]
[null,"2012-04-16","2012-04-17","Train for Marathon","Inspect course",null,"10 mile jogs each day"]
[null,"2012-04-18",null,"Train for Marathon","Cross the finish line under 3 hours!",null,"Now go to Belize!"]
[null,"2011-09-10",null,"Plan Sara's Surprise Party","Send party invitations",1,"Surprise birthday party on October 3"]
[null,"2011-09-20",null,"Plan Sara's Surprise Party","Order catering",1]
[null,"2011-09-22",null,"Plan Sara's Surprise Party","Secure the entertainment",1]
[null,"2011-10-03",null,"Plan Sara's Surprise Party","Party day!",1,"It was awesome.  She had no idea!"]
[null,"2011-10-01","2011-10-15","Enroll Sara in Swimming Lessons","Compare local area community center prices"]