{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["OPL","OPL example","meeting participants","Compl - by overdue","By Resp - Status","Category - Tasks","By Category - Status","How to Use"],"not_rendered":{"charts":4,"images":2,"macros":1,"external_links":0,"defined_names":70,"comments":3,"pivot_tables":2},"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":21,"n_cols":20,"rows_kept":21,"cut":false,"hidden":false,"merged":[[1,0,1,1]]}
[" Open Points List (OPL)"]
["  Title: ",null,"My OPL, My Project",null,"http://www.excelmadeeasy.com/",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Task Count"]
[null,"Owner:","Your Name",null,"Date:",{"$f":"TODAY()","v":"2015-04-01"},null,null,null,null,null,null,null,"Data for statistics - automatically updated",null,null,null,null,null,{"$f":"COUNTA(B:B)-3","v":2}]
["No.","Task Creation Date","product","Subject","Action Item","Resp","Priority","Planned finish date","Status","Actual finish date","Estimated Completion Time (days)","Result","Information, Escalation, Feedback","Completion month","Completed on time","Completed overdue","Days overdue","Telecon"]
[{"$f":"ROW()-4","v":1},null,null,null,null,null,null,null,{"$f":"IF(H5<>\"\",IF(J5<>\"\",\"completed\",IF(H5<TODAY(),\"_overdue\",IF(H5<TODAY()+K5*1.4,\"_LATE\",IF(H5<TODAY()+7+K5*1.4,\"warning\",IF(B5<TODAY()-7,\"reminder\",\"new\"))))),IF(B5=\"\",\"\",IF(J5<>\"\",\"completed\",\"no deadline\")))","v":""},null,null,null,null,{"$f":"IF(J5<>\"\",DATE(YEAR(J5),MONTH(J5),1),\"\")","v":""},{"$f":"IF(Q5=0,1,0)","v":0},{"$f":"IF(AND(Q5<>\"\",Q5>0),1,0)","v":0},{"$f":"IF(I5=\"completed\",IF(J5<=H5,0,DAYS360(H5,J5)),\"\")","v":""}]
[2,null,null,null,null,null,null,null,{"$f":"IF(H6<>\"\",IF(J6<>\"\",\"completed\",IF(H6<TODAY(),\"_overdue\",IF(H6<TODAY()+K6*1.4,\"_LATE\",IF(H6<TODAY()+7+K6*1.4,\"warning\",IF(B6<TODAY()-7,\"reminder\",\"new\"))))),IF(B6=\"\",\"\",IF(J6<>\"\",\"completed\",\"no deadline\")))","v":""},null,null,null,null,{"$f":"IF(J6<>\"\",DATE(YEAR(J6),MONTH(J6),1),\"\")","v":""},0,0,{"$f":"IF(I6=\"completed\",IF(J6<=H6,0,DAYS360(H6,J6)),\"\")","v":""}]
[3,null,null,null,null,null,null,null,"",null,null,null,null,{"$f":"IF(J7<>\"\",DATE(YEAR(J7),MONTH(J7),1),\"\")","v":""},0,0,{"$f":"IF(I7=\"completed\",IF(J7<=H7,0,DAYS360(H7,J7)),\"\")","v":""}]
[4,null,null,null,null,null,null,null,"",null,null,null,null,{"$f":"IF(J8<>\"\",DATE(YEAR(J8),MONTH(J8),1),\"\")","v":""},0,0,{"$f":"IF(I8=\"completed\",IF(J8<=H8,0,DAYS360(H8,J8)),\"\")","v":""}]
[{"$f":"ROW()-4","v":5},null,null,null,null,null,null,null,"",null,null,null,null,{"$f":"IF(J9<>\"\",DATE(YEAR(J9),MONTH(J9),1),\"\")","v":""},0,0,{"$f":"IF(I9=\"completed\",IF(J9<=H9,0,DAYS360(H9,J9)),\"\")","v":""}]
[{"$f":"ROW()-4","v":6},null,null,null,null,null,null,null,"",null,null,null,null,{"$f":"IF(J10<>\"\",DATE(YEAR(J10),MONTH(J10),1),\"\")","v":""},{"$f":"IF(Q10=0,1,0)","v":0},{"$f":"IF(AND(Q10<>\"\",Q10>0),1,0)","v":0},{"$f":"IF(I10=\"completed\",IF(J10<=H10,0,DAYS360(H10,J10)),\"\")","v":""}]
[{"$f":"ROW()-4","v":7},null,null,null,null,null,null,null,"",null,null,null,null,{"$f":"IF(J11<>\"\",DATE(YEAR(J11),MONTH(J11),1),\"\")","v":""},0,0,{"$f":"IF(I11=\"completed\",IF(J11<=H11,0,DAYS360(H11,J11)),\"\")","v":""}]
[{"$f":"ROW()-4","v":8},null,null,null,null,null,null,null,"",null,null,null,null,{"$f":"IF(J12<>\"\",DATE(YEAR(J12),MONTH(J12),1),\"\")","v":""},0,0,{"$f":"IF(I12=\"completed\",IF(J12<=H12,0,DAYS360(H12,J12)),\"\")","v":""}]
[{"$f":"ROW()-4","v":9},null,null,null,null,null,null,null,"",null,null,null,null,{"$f":"IF(J13<>\"\",DATE(YEAR(J13),MONTH(J13),1),\"\")","v":""},{"$f":"IF(Q13=0,1,0)","v":0},{"$f":"IF(AND(Q13<>\"\",Q13>0),1,0)","v":0},{"$f":"IF(I13=\"completed\",IF(J13<=H13,0,DAYS360(H13,J13)),\"\")","v":""}]
[10,null,null,null,null,null,null,null,"",null,null,null,null,{"$f":"IF(J14<>\"\",DATE(YEAR(J14),MONTH(J14),1),\"\")","v":""},0,0,{"$f":"IF(I14=\"completed\",IF(J14<=H14,0,DAYS360(H14,J14)),\"\")","v":""}]
[11,null,null,null,null,null,null,null,"",null,null,null,null,{"$f":"IF(J15<>\"\",DATE(YEAR(J15),MONTH(J15),1),\"\")","v":""},0,0,{"$f":"IF(I15=\"completed\",IF(J15<=H15,0,DAYS360(H15,J15)),\"\")","v":""}]
[12,null,null,null,null,null,null,null,"",null,null,null,null,{"$f":"IF(J16<>\"\",DATE(YEAR(J16),MONTH(J16),1),\"\")","v":""},{"$f":"IF(Q16=0,1,0)","v":0},{"$f":"IF(AND(Q16<>\"\",Q16>0),1,0)","v":0},{"$f":"IF(I16=\"completed\",IF(J16<=H16,0,DAYS360(H16,J16)),\"\")","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"]

{"sheet":"OPL example","index":1,"n_rows":23,"n_cols":20,"rows_kept":23,"cut":false,"hidden":false,"merged":[[1,0,1,1]]}
[" Open Points List (OPL)"]
["  Title: ",null,"My OPL, My Project",null,"http://www.excelmadeeasy.com/",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Task Count"]
[null,"Owner:","Your Name",null,"Date:",{"$f":"TODAY()","v":"2015-04-01"},null,null,null,null,null,null,null,"Data for statistics - automatically updated",null,null,null,null,null,{"$f":"COUNTA(B:B)-3","v":12}]
["No.","Task Creation Date","product","Subject","Action Item","Resp","Priority","Planned finish date","Status","Actual finish date","Estimated Completion Time (days)","Result","Information, Escalation, Feedback","Completion month","Completed on time","Completed overdue","Days overdue","Telecon"]
[{"$f":"ROW()-4","v":1},"2014-02-01","no1","create OPL","Use this OPL every day of my life. Yes you should use it everyday of your life","myself",null,"2014-04-01",{"$f":"IF(H5<>\"\",IF(J5<>\"\",\"completed\",IF(H5<TODAY(),\"_overdue\",IF(H5<TODAY()+K5*1.4,\"_LATE\",IF(H5<TODAY()+7+K5*1.4,\"warning\",IF(B5<TODAY()-7,\"reminder\",\"new\"))))),IF(B5=\"\",\"\",IF(J5<>\"\",\"completed\",\"no deadline\")))","v":"completed"},"2014-03-31",5,"none yet, but we are waiting for more news from the customer",null,{"$f":"IF(J5<>\"\",DATE(YEAR(J5),MONTH(J5),1),\"\")","v":"2014-03-01"},{"$f":"IF(Q5=0,1,0)","v":1},{"$f":"IF(AND(Q5<>\"\",Q5>0),1,0)","v":0},{"$f":"IF(I5=\"completed\",IF(J5<=H5,0,DAYS360(H5,J5)),\"\")","v":0}]
[2,"2014-04-13","no2","create OPL","Use this OPL every day of my life","myself",1,"1/102014",{"$f":"IF(H6<>\"\",IF(J6<>\"\",\"completed\",IF(H6<TODAY(),\"_overdue\",IF(H6<TODAY()+K6*1.4,\"_LATE\",IF(H6<TODAY()+7+K6*1.4,\"warning\",IF(B6<TODAY()-7,\"reminder\",\"new\"))))),IF(B6=\"\",\"\",IF(J6<>\"\",\"completed\",\"no deadline\")))","v":"reminder"},null,null,null,null,{"$f":"IF(J6<>\"\",DATE(YEAR(J6),MONTH(J6),1),\"\")","v":""},0,0,{"$f":"IF(I6=\"completed\",IF(J6<=H6,0,DAYS360(H6,J6)),\"\")","v":""}]
[3,"2008-04-13","no3","create OPL","Use this OPL every day of my life","myself",2,"2014-04-19","_overdue",null,null,null,null,{"$f":"IF(J7<>\"\",DATE(YEAR(J7),MONTH(J7),1),\"\")","v":""},0,0,{"$f":"IF(I7=\"completed\",IF(J7<=H7,0,DAYS360(H7,J7)),\"\")","v":""}]
[4,"2014-01-01","no4","create OPL","Use this OPL every day of my life","myself",null,"2014-02-01","completed",{"$f":"IF(L8=0,1,0)","v":"1900-01-01"},null,null,null,{"$f":"IF(J8<>\"\",DATE(YEAR(J8),MONTH(J8),1),\"\")","v":"1900-01-01"},1,0,{"$f":"IF(I8=\"completed\",IF(J8<=H8,0,DAYS360(H8,J8)),\"\")","v":0}]
[{"$f":"ROW()-4","v":5},null,null,null,null,null,null,null,"",null,null,null,null,{"$f":"IF(J9<>\"\",DATE(YEAR(J9),MONTH(J9),1),\"\")","v":""},0,0,{"$f":"IF(I9=\"completed\",IF(J9<=H9,0,DAYS360(H9,J9)),\"\")","v":""}]
[{"$f":"ROW()-4","v":6},"2015-04-01",null,null,null,null,null,null,"no deadline",null,null,null,null,{"$f":"IF(J10<>\"\",DATE(YEAR(J10),MONTH(J10),1),\"\")","v":""},0,0,{"$f":"IF(I10=\"completed\",IF(J10<=H10,0,DAYS360(H10,J10)),\"\")","v":""}]
[{"$f":"ROW()-4","v":7},null,null,null,null,null,null,null,{"$f":"IF(H11<>\"\",IF(J11<>\"\",\"completed\",IF(H11<TODAY(),\"_overdue\",IF(H11<TODAY()+K11*1.4,\"_LATE\",IF(H11<TODAY()+7+K11*1.4,\"warning\",IF(B11<TODAY()-7,\"reminder\",\"new\"))))),IF(B11=\"\",\"\",IF(J11<>\"\",\"completed\",\"no deadline\")))","v":""},"2014-01-05",null,null,null,{"$f":"IF(J11<>\"\",DATE(YEAR(J11),MONTH(J11),1),\"\")","v":"2014-01-01"},{"$f":"IF(Q11=0,1,0)","v":0},{"$f":"IF(AND(Q11<>\"\",Q11>0),1,0)","v":0},{"$f":"IF(I11=\"completed\",IF(J11<=H11,0,DAYS360(H11,J11)),\"\")","v":""}]
[{"$f":"ROW()-4","v":8},"2014-04-13","no6","create OPL","Use this OPL every day of my life","you",1,{"$f":"TODAY()-5","v":"2015-03-27"},"completed","2014-01-05",null,null,null,{"$f":"IF(J12<>\"\",DATE(YEAR(J12),MONTH(J12),1),\"\")","v":"2014-01-01"},1,0,{"$f":"IF(I12=\"completed\",IF(J12<=H12,0,DAYS360(H12,J12)),\"\")","v":0}]
[{"$f":"ROW()-4","v":9},{"$f":"TODAY()","v":"2015-04-01"},null,"this is a sample row ","Select the row and insert it whereever you want in the OTL.","you",null,{"$f":"TODAY()+5","v":"2015-04-06"},"warning",null,null,null,null,{"$f":"IF(J13<>\"\",DATE(YEAR(J13),MONTH(J13),1),\"\")","v":""},0,0,{"$f":"IF(I13=\"completed\",IF(J13<=H13,0,DAYS360(H13,J13)),\"\")","v":""}]
[10,"2014-11-01","test","test","test","john",1,{"$f":"TODAY()+10","v":"2015-04-11"},"_LATE",null,50,null,null,{"$f":"IF(J14<>\"\",DATE(YEAR(J14),MONTH(J14),1),\"\")","v":""},0,0,{"$f":"IF(I14=\"completed\",IF(J14<=H14,0,DAYS360(H14,J14)),\"\")","v":""}]
[11,{"$f":"TODAY()","v":"2015-04-01"},"test2","test2","test2","Laura",2,{"$f":"TODAY()+40","v":"2015-05-11"},"new",null,null,null,null,{"$f":"IF(J15<>\"\",DATE(YEAR(J15),MONTH(J15),1),\"\")","v":""},0,0,{"$f":"IF(I15=\"completed\",IF(J15<=H15,0,DAYS360(H15,J15)),\"\")","v":""}]
[12,{"$f":"TODAY()","v":"2015-04-01"},"test3","test3","test3","Lana",null,{"$f":"TODAY()+5","v":"2015-04-06"},"warning",null,null,null,null,{"$f":"IF(J16<>\"\",DATE(YEAR(J16),MONTH(J16),1),\"\")","v":""},0,0,{"$f":"IF(I16=\"completed\",IF(J16<=H16,0,DAYS360(H16,J16)),\"\")","v":""}]
[13,null,null,null,null,null,null,null,"",null,null,null,null,{"$f":"IF(J17<>\"\",DATE(YEAR(J17),MONTH(J17),1),\"\")","v":""},0,0,{"$f":"IF(I17=\"completed\",IF(J17<=H17,0,DAYS360(H17,J17)),\"\")","v":""}]
[null,null,null,null,null,null,null,null,""]
[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"]

{"sheet":"meeting participants","index":2,"n_rows":22,"n_cols":22,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[null,null,"http://www.excelmadeeasy.com/"]
[null,null,null,"Enter the date of the meeting so you can track who came"]
[null,"shortname","PRESENCE","2014-11-01","2014-11-08","2014-11-15","2014-11-22","2014-11-29","2014-12-06","2014-12-13","2014-12-20","2014-12-27","2015-01-03","2015-01-10"]
[null,"for tasks"]
[null,null,"Name 1","x",null,"x"]
[null,null,"Name 2","x","x","x"]
[null,null,"Name 3","x",null,"x"]
[null,null,"Name 4","x",null,"x"]
[null,null,"Name 5","x",null,"x"]
[null,null,"Name 6","x",null,"x"]
[null,null,"Name 7","x",null,"x"]
[null,null,"Name 8",null,null,"x"]
[null,null,"Name 9",null,"x","x"]
[null,null,"Name 10",null,"x","x"]
[null,null,"Name 11",null,null,"x"]
[null,null,"Name 12",null,"x","x"]
[null,null,"Name 13",null,"x","x"]
[null,null,"Name 14",null,"x","x"]
[null,null,"insert before this line (select this cell, press right click and select insert entire row)"]
[]
[]
[null,null,"attendancy",{"$f":"COUNTIF(D5:D18,\"x\")/(COUNTBLANK(D5:D18)+COUNTIF(D5:D18,\"x\"))","v":0.5},{"$f":"COUNTIF(E5:E18,\"x\")/(COUNTBLANK(E5:E18)+COUNTIF(E5:E18,\"x\"))","v":0.42857142857142855},1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"Compl - by overdue","index":3,"n_rows":19,"n_cols":10,"rows_kept":19,"cut":false,"hidden":false,"merged":[[2,4,2,7]]}
[null,null,null,null,null,"Closed tasks, by overdue status"]
[null,null,null,null,null,"  Title: ",{"$f":"OPL!B2","v":0}]
[null,null,null,null,"http://www.excelmadeeasy.com/"]
[null,{"$f":"F1","v":"Closed tasks, by overdue status"}]
[]
["Status",null,null,null,"Number of tasks",null,null,"Month","Tasks completed"]
["on time",null,null,null,{"$f":"COUNTIF(OPL!Q:Q,\"=0\")","v":0},null,null,null,"On-time","Overdue"]
[0,"to",{"$f":"A9","v":1},"weeks",{"$f":"COUNTIF(OPL!Q:Q,\"<\"& TEXT('Compl - by overdue'!C8*5,\"0\"))-SUM(E$7:E7)","v":0},null,null,"2014-01-01",{"$f":"SUMIF(OPL!N:$N,\"=\" & 'Compl - by overdue'!$H8,OPL!O:O)","v":0},{"$f":"SUMIF(OPL!$N:O,\"=\" & 'Compl - by overdue'!$H8,OPL!P:P)","v":0}]
[1,"to",{"$f":"A10","v":2},"weeks",{"$f":"COUNTIF(OPL!Q:Q,\"<\"& TEXT('Compl - by overdue'!C9*5,\"0\"))-SUM(E$7:E8)","v":0},null,null,"2014-02-01",{"$f":"SUMIF(OPL!N:N,\"=\" & 'Compl - by overdue'!H9,OPL!O:O)","v":0},{"$f":"SUMIF(OPL!$N:O,\"=\" & 'Compl - by overdue'!$H9,OPL!P:P)","v":0}]
[2,"to",3,"weeks",{"$f":"COUNTIF(OPL!Q:Q,\"<\"& TEXT('Compl - by overdue'!C10*5,\"0\"))-SUM(E$7:E9)","v":0},null,null,"2014-03-01",{"$f":"SUMIF(OPL!N:N,\"=\" & 'Compl - by overdue'!H10,OPL!O:O)","v":0},{"$f":"SUMIF(OPL!$N:O,\"=\" & 'Compl - by overdue'!$H10,OPL!P:P)","v":0}]
[3,"to",4,"weeks",{"$f":"COUNTIF(OPL!Q:Q,\"<\"& TEXT('Compl - by overdue'!C11*5,\"0\"))-SUM(E$7:E10)","v":0},null,null,"2014-04-01",{"$f":"SUMIF(OPL!N:N,\"=\" & 'Compl - by overdue'!H11,OPL!O:O)","v":0},{"$f":"SUMIF(OPL!$N:O,\"=\" & 'Compl - by overdue'!$H11,OPL!P:P)","v":0}]
[4,"to",5,"weeks",{"$f":"COUNTIF(OPL!Q:Q,\"<\"& TEXT('Compl - by overdue'!C12*5,\"0\"))-SUM(E$7:E11)","v":0},null,null,"2014-05-01",{"$f":"SUMIF(OPL!N:N,\"=\" & 'Compl - by overdue'!H12,OPL!O:O)","v":0},{"$f":"SUMIF(OPL!$N:O,\"=\" & 'Compl - by overdue'!$H12,OPL!P:P)","v":0}]
[5,"to",6,"weeks",{"$f":"COUNTIF(OPL!Q:Q,\"<\"& TEXT('Compl - by overdue'!C13*5,\"0\"))-SUM(E$7:E12)","v":0},null,null,"2014-06-01",{"$f":"SUMIF(OPL!N:N,\"=\" & 'Compl - by overdue'!H13,OPL!O:O)","v":0},{"$f":"SUMIF(OPL!$N:O,\"=\" & 'Compl - by overdue'!$H13,OPL!P:P)","v":0}]
[6,"to",7,"weeks",{"$f":"COUNTIF(OPL!Q:Q,\"<\"& TEXT('Compl - by overdue'!C14*5,\"0\"))-SUM(E$7:E13)","v":0},null,null,"2014-07-01",{"$f":"SUMIF(OPL!N:N,\"=\" & 'Compl - by overdue'!H14,OPL!O:O)","v":0},{"$f":"SUMIF(OPL!$N:O,\"=\" & 'Compl - by overdue'!$H14,OPL!P:P)","v":0}]
[7,"to",8,"weeks",{"$f":"COUNTIF(OPL!Q:Q,\"<\"& TEXT('Compl - by overdue'!C15*5,\"0\"))-SUM(E$7:E14)","v":0},null,null,"2014-08-01",{"$f":"SUMIF(OPL!N:N,\"=\" & 'Compl - by overdue'!H15,OPL!O:O)","v":0},{"$f":"SUMIF(OPL!$N:O,\"=\" & 'Compl - by overdue'!$H15,OPL!P:P)","v":0}]
[8,"to",9,"weeks",{"$f":"COUNTIF(OPL!Q:Q,\"<\"& TEXT('Compl - by overdue'!C16*5,\"0\"))-SUM(E$7:E15)","v":0},null,null,"2014-09-01",{"$f":"SUMIF(OPL!N:N,\"=\" & 'Compl - by overdue'!H16,OPL!O:O)","v":0},{"$f":"SUMIF(OPL!$N:O,\"=\" & 'Compl - by overdue'!$H16,OPL!P:P)","v":0}]
[9,"or more",null,"weeks",{"$f":"COUNTIF(OPL!Q:Q,\">=\"& TEXT('Compl - by overdue'!A17*5,\"0\"))","v":0},null,null,"2014-10-01",{"$f":"SUMIF(OPL!N:N,\"=\" & 'Compl - by overdue'!H17,OPL!O:O)","v":0},{"$f":"SUMIF(OPL!$N:O,\"=\" & 'Compl - by overdue'!$H17,OPL!P:P)","v":0}]
[null,null,null,null,null,null,null,"2014-11-01",{"$f":"SUMIF(OPL!N:N,\"=\" & 'Compl - by overdue'!H18,OPL!O:O)","v":0},{"$f":"SUMIF(OPL!O:O,\"=\" & 'Compl - by overdue'!I18,OPL!P:P)","v":0}]
[null,null,null,null,null,null,null,"2014-12-01",{"$f":"SUMIF(OPL!N:N,\"=\" & 'Compl - by overdue'!H19,OPL!O:O)","v":0},{"$f":"SUMIF(OPL!$N:O,\"=\" & 'Compl - by overdue'!$H19,OPL!P:P)","v":0}]

{"sheet":"By Resp - Status","index":4,"n_rows":13,"n_cols":16,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,15,0,19]]}
[null,null,null,null,null,"[Insert project/purpose name here]",null,null,null,null,null,null,null,null,null,"http://www.excelmadeeasy.com/"]
[null,null,null,null,null,"Task Status by Responsibility"]
[]
[null,"Overview of task status by responsibility"]
[]
[null,"Planned Deadlines","Status"]
[null,"Resp","completed","_overdue","warning","reminder","_LATE","new","Grand Total"]
[null,"you",1,0,1,0,0,0,2]
[null,"myself",2,1,0,1,0,0,4]
[null,"john",0,0,0,0,1,0,1]
[null,"Laura",0,0,0,0,0,1,1]
[null,"Lana",0,0,1,0,0,0,1]
[null,"Grand Total",3,1,2,1,1,1,9]

{"sheet":"Category - Tasks","index":5,"n_rows":56,"n_cols":4,"rows_kept":56,"cut":false,"hidden":false,"merged":[]}
["List of tasks categories/working departments and their unique ID number"]
[{"$f":"MAX(A4:A72)","v":50}]
[null,"Ref No","Abbreviations","Designation/ Description"]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[30]
[31]
[32]
[33]
[34]
[35]
[36]
[37]
[38]
[39]
[40]
[41]
[42]
[43]
[44]
[45]
[46]
[47]
[48]
[49]
[50]
["Achtung! Für weitere Arbeitspakete muss Makro geändert werden:"]
["=> Formulare > \"Auswahl_HAP\""]
["=> Private Sub UserForm_Initialize => Range ändern (Default D53, 1. Zeile in Subrutine)"]

{"sheet":"By Category - Status","index":6,"n_rows":8,"n_cols":10,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,"Closed tasks, by overdue status"]
[null,null,null,null,null,"  Title: ",{"$f":"OPL!B2","v":0}]
[]
[]
[]
["Count of Planned finish date","Status"]
[null,"completed","(blank)",null,"_overdue","reminder","warning","_LATE","new","Grand Total"]
["Total",3,0,0,2,1,1,1,1,9]

{"sheet":"How to Use","index":7,"n_rows":29,"n_cols":9,"rows_kept":29,"cut":false,"hidden":false,"merged":[[1,8,1,12],[3,1,3,5],[5,1,5,5],[28,1,28,9],[6,1,6,5],[8,1,8,4],[25,1,25,9]]}
[]
[null,"How to use the Open Points List",null,null,null,null,null,null,"http://www.excelmadeeasy.com/"]
[]
[null,"Purpose: It is envisaged that an open points list can be used to track tasks common to a Department, Section, Project, Topic."]
[]
[null,"Usage: "]
[null,"1. Fill out the fields on the sheet \"OPL\" according to the comments on each column heading. To do this hold the mouse over the coloumn heading."]
[]
[null,"2. To use Pivot Tables and Graphs right click on field and select refresh data. The graphs will be empty until your open points list contains data."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"3. Task Categories"]
[null,"If you define task catergories in the worksheet \"Category - Tasks\" you can refer to them by their Ref. No. in the main OPL list. This data is used to create the graph of tasks by category too in the worksheet \"By Category - Status\""]
[]
[null,"How Status field works."]
[null,"If you wish to know what criteria are used for the status field, the following flowchart details the decisions the spreadsheet makes."]