{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["OPL"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":34,"comments":1,"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":"OPL","index":0,"n_rows":18,"n_cols":9,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,0,1,1],[0,0,0,2]]}
["Life List",null,null,null,null,null,null,null,"http://www.excelmadeeasy.com/"]
["  Title: ",null,"MY LIST"]
[null,"Owner:","Date:",{"$f":"TODAY()","v":"2015-04-16"}]
["No.","Date","Action Item","Priority","Planned finish date","Status","Actual finish date","Estimated Completion Time (days)","COMMENT"]
[{"$f":"ROW()-4","v":1},"2015-04-01","Buy the new TV","urgent","2015-04-05",{"$f":"IF(E5<>\"\",IF(G5<>\"\",\"completed\",IF(E5<TODAY(),\"_overdue\",IF(E5<TODAY()+H5*1.4,\"_LATE\",IF(E5<TODAY()+7+H5*1.4,\"warning\",IF(B5<TODAY()-7,\"reminder\",\"new\"))))),IF(B5=\"\",\"\",IF(G5<>\"\",\"completed\",\"no deadline\")))","v":"completed"},"2015-04-05"]
[2,"2015-03-05","Start Tax return","can wait","2015-03-03",{"$f":"IF(E6<>\"\",IF(G6<>\"\",\"completed\",IF(E6<TODAY(),\"_overdue\",IF(E6<TODAY()+H6*1.4,\"_LATE\",IF(E6<TODAY()+7+H6*1.4,\"warning\",IF(B6<TODAY()-7,\"reminder\",\"new\"))))),IF(B6=\"\",\"\",IF(G6<>\"\",\"completed\",\"no deadline\")))","v":"_overdue"}]
[3,"2015-04-05","Restart Fitness","eventually","2015-04-16",{"$f":"IF(E7<>\"\",IF(G7<>\"\",\"completed\",IF(E7<TODAY(),\"_overdue\",IF(E7<TODAY()+H7*1.4,\"_LATE\",IF(E7<TODAY()+7+H7*1.4,\"warning\",IF(B7<TODAY()-7,\"reminder\",\"new\"))))),IF(B7=\"\",\"\",IF(G7<>\"\",\"completed\",\"no deadline\")))","v":"warning"}]
[4,"2015-03-01","read Men come from Mars, Women come from Venus","urgent","2015-04-20",{"$f":"IF(E8<>\"\",IF(G8<>\"\",\"completed\",IF(E8<TODAY(),\"_overdue\",IF(E8<TODAY()+H8*1.4,\"_LATE\",IF(E8<TODAY()+7+H8*1.4,\"warning\",IF(B8<TODAY()-7,\"reminder\",\"new\"))))),IF(B8=\"\",\"\",IF(G8<>\"\",\"completed\",\"no deadline\")))","v":"warning"},null,1]
[5,"2015-02-02",null,null,null,{"$f":"IF(E9<>\"\",IF(G9<>\"\",\"completed\",IF(E9<TODAY(),\"_overdue\",IF(E9<TODAY()+H9*1.4,\"_LATE\",IF(E9<TODAY()+7+H9*1.4,\"warning\",IF(B9<TODAY()-7,\"reminder\",\"new\"))))),IF(B9=\"\",\"\",IF(G9<>\"\",\"completed\",\"no deadline\")))","v":"no deadline"}]
[6,null,null,null,null,{"$f":"IF(E10<>\"\",IF(G10<>\"\",\"completed\",IF(E10<TODAY(),\"_overdue\",IF(E10<TODAY()+H10*1.4,\"_LATE\",IF(E10<TODAY()+7+H10*1.4,\"warning\",IF(B10<TODAY()-7,\"reminder\",\"new\"))))),IF(B10=\"\",\"\",IF(G10<>\"\",\"completed\",\"no deadline\")))","v":""}]
[7,null,null,null,null,{"$f":"IF(E11<>\"\",IF(G11<>\"\",\"completed\",IF(E11<TODAY(),\"_overdue\",IF(E11<TODAY()+H11*1.4,\"_LATE\",IF(E11<TODAY()+7+H11*1.4,\"warning\",IF(B11<TODAY()-7,\"reminder\",\"new\"))))),IF(B11=\"\",\"\",IF(G11<>\"\",\"completed\",\"no deadline\")))","v":""}]
[{"$f":"ROW()-4","v":8},null,null,null,null,{"$f":"IF(E12<>\"\",IF(G12<>\"\",\"completed\",IF(E12<TODAY(),\"_overdue\",IF(E12<TODAY()+H12*1.4,\"_LATE\",IF(E12<TODAY()+7+H12*1.4,\"warning\",IF(B12<TODAY()-7,\"reminder\",\"new\"))))),IF(B12=\"\",\"\",IF(G12<>\"\",\"completed\",\"no deadline\")))","v":""}]
[9,null,null,null,null,{"$f":"IF(E13<>\"\",IF(G13<>\"\",\"completed\",IF(E13<TODAY(),\"_overdue\",IF(E13<TODAY()+H13*1.4,\"_LATE\",IF(E13<TODAY()+7+H13*1.4,\"warning\",IF(B13<TODAY()-7,\"reminder\",\"new\"))))),IF(B13=\"\",\"\",IF(G13<>\"\",\"completed\",\"no deadline\")))","v":""}]
[null,"Do not add any thing under this line. Use the insert row function before reaching this line."]
[]
[]
[null,"press shif ctrl ; to enter the date"]
[null,"save: use ctrl s as often as possible"]