{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["OPL","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":36,"comments":2,"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":20,"n_cols":20,"rows_kept":20,"cut":false,"hidden":false,"merged":[[1,0,1,1]]}
[null,null,null,null,"Employee Evaluation System"]
["  Title: ",null,"Departement",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":"2014-11-13"},null,null,null,null,null,null,null,"Data for statistics - automatically updated",null,null,null,null,null,{"$f":"COUNTA(B:B)-3","v":13}]
["No.","Creation Date","Employee Name","Comment","Assigned tasks","Other","Due date","Status","Completion date","Estimated Completion Time (days)","Result","Information, Escalation, Feedback","Priority","Completion month","Completed on time","Completed overdue","Days overdue","Telecon"]
[1,"2014-02-01","no1","create OPL","task",null,"2014-04-01",{"$f":"IF(A5<>\"\",IF(I5<>\"\",\"completed\",IF(G5<TODAY(),\"_overdue\",IF(G5<TODAY()+J5*1.4, \"_LATE\",IF(G5<TODAY()+7+J5*1.4,\"warning\",IF(B5<TODAY()-7,\"reminder\",\"new\"))))),\"\")","v":"completed"},"2014-03-31",5,"none yet, but we are waiting for more news from the customer",null,null,{"$f":"IF(I5<>\"\",DATE(YEAR(I5),MONTH(I5),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(H5=\"completed\",IF(I5<=G5,0,DAYS360(G5,I5)),\"\")","v":0}]
[2,"2014-04-13","no2","create OPL","task",null,"1/102014","reminder",null,null,null,null,1,"",0,0,""]
[3,"2008-04-13","no3","create OPL","task",null,"2014-04-19","_overdue",null,null,null,null,2,"",0,0,""]
[4,"2014-01-01","no4","create OPL","task",null,"2014-02-01","completed","2014-03-15",null,null,null,1,"2014-03-01",0,1,44]
[5,"2014-01-02","no5","create OPL","task",null,"2014-12-01","_LATE",null,40,null,null,2,"",0,0,""]
[6,"2014-04-13","no6","create OPL","task",null,"2014-05-15","completed","2014-01-05",null,null,null,1,"2014-01-01",1,0,0]
[7,"2014-11-01","test","test","task",null,"2014-11-03",{"$f":"IF(A11<>\"\",IF(I11<>\"\",\"completed\",IF(G11<TODAY(),\"_overdue\",IF(G11<TODAY()+J11*1.4, \"_LATE\",IF(G11<TODAY()+7+J11*1.4,\"warning\",IF(B11<TODAY()-7,\"reminder\",\"new\"))))),\"\")","v":"_overdue"},null,null,null,null,1,{"$f":"IF(I11<>\"\",DATE(YEAR(I11),MONTH(I11),1),\"\")","v":""},{"$f":"IF(Q11=0,1,0)","v":0},{"$f":"IF(AND(Q11<>\"\",Q11>0),1,0)","v":0},{"$f":"IF(H11=\"completed\",IF(I11<=G11,0,DAYS360(G11,I11)),\"\")","v":""}]
[8,"2014-11-01","test2","test2","task",null,"2014-09-05","_overdue",null,null,null,null,2,"",0,0,""]
[9,"2014-11-01","test3","test3","task",null,"2014-11-15","warning",null,null,null,null,null,"",0,0,""]
[10,"2014-11-01",null,null,null,null,"2014-11-01","_overdue",null,null,null,null,null,{"$f":"IF(I14<>\"\",DATE(YEAR(I14),MONTH(I14),1),\"\")","v":""},{"$f":"IF(Q14=0,1,0)","v":0},{"$f":"IF(AND(Q14<>\"\",Q14>0),1,0)","v":0},{"$f":"IF(H14=\"completed\",IF(I14<=G14,0,DAYS360(G14,I14)),\"\")","v":""}]
[11,"2014-11-01",null,null,null,null,"2014-11-01","_overdue",null,null,null,null,null,"",0,0,""]
[12,"2014-11-01",null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[13,"2014-11-01",null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,"",0,0,""]
[null,"Do not add any thing under this line. Use the insert row function before reaching this line.",null,null,null,null,null,null,null,null,null,null,"last"]

{"sheet":"meeting participants","index":1,"n_rows":18,"n_cols":14,"rows_kept":18,"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,null,"Name 2",null,"x"]
[null,null,"Name 3","x"]
[null,null,"Name 4","x"]
[null,null,"Name 5","x"]
[null,null,"Name 6","x"]
[null,null,"Name 7","x"]
[null,null,"Name 8","x"]
[null,null,"Name 9","x","x"]
[null,null,"Name 10",null,"x"]
[null,null,"Name 11","x"]
[null,null,"Name 12","x","x"]
[null,null,"Name 13","x","x"]
[null,null,"Name 14","x","x"]

{"sheet":"Compl - by overdue","index":2,"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":2},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":1},{"$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":1},{"$f":"SUMIF(OPL!$N:O,\"=\" & 'Compl - by overdue'!$H10,OPL!P:P)","v":1}]
[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":1},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":1}]
[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":3,"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,0,0,0,0,1]
[null,"myself",2,1,0,1,0,0,4]
[null,"john",0,0,1,0,0,0,1]
[null,"Laura",0,1,0,0,1,0,2]
[null,"Lana",0,0,0,0,0,1,1]
[null,"Grand Total",3,2,1,1,1,1,9]

{"sheet":"Category - Tasks","index":4,"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":5,"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":6,"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."]