{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Project 1 To Do List","Settings & Calculations"],"not_rendered":{"defined_names":6},"read":"whole","date_system":"1900"}

{"sheet":"Project 1 To Do List","index":0,"n_rows":18,"n_cols":8,"rows_kept":18,"merged":[[7,1,7,2]]}
[{"$nulls":7}," "]
[{"$nulls":7}," "]
[null,"Project To Do List"]
[]
[null,"To be completed by:",null,null,"Deadline:",null,"Highlight Activities"]
[null,"Kim Abercrombie",null,null,{"$f":"TODAY()+95","v":"2012-09-30"},null,"     This Week [18 Jun - 24 Jun]"]
[]
[null,"Project 1"]
[null,"Activity","Due By","Budget","% Done","Progress","Notes"," "]
[null,"Planning",{"$f":"TODAY()-90","v":"2012-03-29"},{"v":476,"d":"$476.00"},{"v":0.25,"d":"25%"},{"$f":"tblToDoList[[#This Row],[% Done]]","v":{"v":0.25,"d":"25%"}}]
[null,"Preparation",{"$f":"TODAY()-2","v":"2012-06-25"},{"v":301,"d":"$301.00"},{"v":0.1,"d":"10%"},{"$f":"tblToDoList[[#This Row],[% Done]]","v":{"v":0.1,"d":"10%"}}]
[null,"Task A",{"$f":"TODAY()-7","v":"2012-06-20"},{"v":429,"d":"$429.00"},{"v":0,"d":"0%"},{"$f":"tblToDoList[[#This Row],[% Done]]","v":{"v":0,"d":"0%"}}]
[null,"Task B",{"$f":"TODAY()+20","v":"2012-07-17"},{"v":332,"d":"$332.00"},{"v":0.7,"d":"70%"},{"$f":"tblToDoList[[#This Row],[% Done]]","v":{"v":0.7,"d":"70%"}}]
[null,"Task C",{"$f":"TODAY()+40","v":"2012-08-06"},{"v":471,"d":"$471.00"},{"v":0.1,"d":"10%"},{"$f":"tblToDoList[[#This Row],[% Done]]","v":{"v":0.1,"d":"10%"}}]
[null,"Task D",{"$f":"TODAY()+45","v":"2012-08-11"},{"v":418,"d":"$418.00"},{"v":1,"d":"100%"},{"$f":"tblToDoList[[#This Row],[% Done]]","v":{"v":1,"d":"100%"}}]
[null,"Paperwork",{"$f":"TODAY()+55","v":"2012-08-21"},{"v":150,"d":"$150.00"},{"v":0,"d":"0%"},{"$f":"tblToDoList[[#This Row],[% Done]]","v":{"v":0,"d":"0%"}},"Start After Task B is Complete"]
[null,"Hand-off",{"$f":"TODAY()+70","v":"2012-09-05"},{"v":330,"d":"$330.00"},{"v":0.25,"d":"25%"},{"$f":"tblToDoList[[#This Row],[% Done]]","v":{"v":0.25,"d":"25%"}}]
[null,"Follow-up",{"$f":"TODAY()+90","v":"2012-09-25"},{"v":353,"d":"$353.00"},{"v":0.5,"d":"50%"},{"$f":"tblToDoList[[#This Row],[% Done]]","v":{"v":0.5,"d":"50%"}}]

{"sheet":"Settings & Calculations","index":1,"n_rows":19,"n_cols":6,"rows_kept":19,"merged":[[3,1,3,4]]}
[]
[{"$nulls":5}," "]
[null,"Highlight Settings"]
[null,"The tables below store settings and calculations for the Highlight Activities drop down list.\nAny changes could result in errors or loss of functionality."]
[null,"No Highlight",null,null,{"$f":"B5","v":"No Highlight"}]
[null,"Interval:","Start:","End:","Due:"]
[null,"     This Week",{"$f":"TODAY()-WEEKDAY(TODAY(),2)+1","v":"2012-06-25"},{"$f":"C7+6","v":"2012-07-01"},{"$f":"B7&\" [\"&TEXT(C7,\"d mmm\")&\" - \"&TEXT(D7,\"d mmm\")&\"]\"","v":"     This Week [25 Jun - 1 Jul]"}]
[null,"     This Month",{"$f":"EOMONTH(TODAY(),-1)+1","v":"2012-06-01"},{"$f":"EDATE(C8,1)-1","v":"2012-06-30"},{"$f":"B8&\" [\"&TEXT(C8,\"d\")&\" - \"&TEXT(D8,\"d, mmm\")&\"]\"","v":"     This Month [1 - 30, Jun]"}]
[null,"     This Quarter",{"$f":"DATE(YEAR(TODAY()),INT(MONTH(TODAY())/3)+1,1)","v":"2012-03-01"},{"$f":"EDATE(C9,4)-1","v":"2012-06-30"},{"$f":"B9&\" [\"&TEXT(C9,\"d mmm\")&\" - \"&TEXT(D9,\"d mmm\")&\"]\"","v":"     This Quarter [1 Mar - 30 Jun]"}]
[null,"     This Year",{"$f":"DATE(YEAR(TODAY()),1,1)","v":"2012-01-01"},{"$f":"EDATE(C10,12)-1","v":"2012-12-31"},{"$f":"B10&\" [\"&TEXT(C10,\"yyyy\")&\"]\"","v":"     This Year [2012]"}]
[null,"Interval:",null,null,{"$f":"B11","v":"Interval:"}]
[null,"     Last Week",{"$f":"C7-7","v":"2012-06-18"},{"$f":"C12+6","v":"2012-06-24"},{"$f":"B12&\" [\"&TEXT(C12,\"d mmm\")&\" - \"&TEXT(D12,\"d mmm\")&\"]\"","v":"     Last Week [18 Jun - 24 Jun]"}]
[null,"     Last Month",{"$f":"EDATE(C8,-1)","v":"2012-05-01"},{"$f":"EDATE(C13,1)-1","v":"2012-05-31"},{"$f":"B13&\" [\"&TEXT(C13,\"d\")&\" - \"&TEXT(D13,\"d, mmm\")&\"]\"","v":"     Last Month [1 - 31, May]"}]
[null,"     Last Quarter",{"$f":"EDATE(C9,-3)","v":"2011-12-01"},{"$f":"EDATE(C14,3)-1","v":"2012-02-29"},{"$f":"B14&\" [\"&TEXT(C14,\"d mmm\")&\" - \"&TEXT(D14,\"d mmm\")&\"]\"","v":"     Last Quarter [1 Dec - 29 Feb]"}]
[null,"     Last Year",{"$f":"EDATE(C10,-12)","v":"2011-01-01"},{"$f":"EDATE(C15,12)-1","v":"2011-12-31"},{"$f":"B15","v":"     Last Year"}]
[]
[null,"Selected Highlight:",{"$f":"IFERROR(MATCH(HighlightActivities,lstToDoHighlights,0),\"\")","v":""},{"$f":"HighlightActivities","v":"     This Week [18 Jun - 24 Jun]"},{"$f":"ISNUMBER(INDEX($C$6:$C$15,C17))","v":false}]
[null,"Highlight Start",{"$f":"IFERROR(IF(C17=1,\"\",IF(E17,INDEX($C$6:$C$15,$C$17),\"\")),\"\")","v":""}]
[null,"Highlight End",{"$f":"IFERROR(IF(C17=1,\"\",IF(E17,INDEX($D$6:$D$15,$C$17),\"\")),\"\")","v":""}]