{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Read ME","Register","Configuration"],"not_rendered":{"images":1,"defined_names":3,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"Read ME","index":0,"n_rows":19,"n_cols":2,"rows_kept":19,"merged":[[0,0,4,12],[6,1,6,12],[8,1,8,12],[10,1,10,12],[12,1,12,12],[14,1,14,12],[16,1,16,12],[17,1,17,12],[18,1,18,12],[28,1,28,12],[32,1,32,12]]}
["Please READ before using this register"]
[]
[]
[]
[]
[]
[null,"Dear User, thank you for using my template.\nPlease overwrite the existing sample entries in the register"]
[]
["1)","Before using this template go to the sheet \"Configuration\" and make adjustments in accordance with your project."]
[]
["2)","Only cells in BLUE FONT COLOR on the sheet \"Register\" require data-entry. Do not overwrite cells in BLACK FONT, they contain formulas or functions."]
[]
["3)","To add a new line (dataset) to the register either start typing in the first empty cell immediately under the last entry, or select any cell in the last row and press the TAB-key until a  new line is added automatically. Formulas/functions and formatting will be copied down automatically."]
[]
["4)","To add a new line (dataset) to the register either start typing in the first empty cell immediately under the last entry, or select any cell in the last row and press the TAB-key until a  new line is added automatically."]
[]
["5)","You downloaded this sheet free of charge from "]
[null,"http: project-management.magt.biz"]
[null,"You may use this sheet for your personal use and projects. However, selling the sheet is strictly prohibited."]

{"sheet":"Register","index":1,"n_rows":14,"n_cols":15,"rows_kept":14,"merged":[[0,1,0,7],[0,8,1,14],[1,1,1,7],[2,1,2,7],[2,9,2,12],[3,1,3,7],[3,9,3,12],[4,1,4,7],[4,9,4,14],[5,1,5,7],[5,9,5,14],[6,0,6,4],[6,5,6,7],[6,8,6,10],[6,11,6,13]]}
["Project","[Project Name]",{"$nulls":6},"Duration Tracker"]
["Phase","[Sub-Project or Phase]"]
["Client","[Client]",{"$nulls":6},"Project Mngr.:","[Project Manager]",{"$nulls":3},"Last Updated:","2018-07-06"]
["Client's Repr.","[Client's Representative]"]
["Contractor","[Contractor]"]
["Sub-Contr.","[Sub Contractor]"]
["Task Description",{"$nulls":4},"Initial Planned Duration",null,null,"Revised Planned Duration ",null,null,"Actual Duration",null,null,"Notes"]
[]
["Task ID","Deadline","Task/Work Package","Description/Activities","Task Owner","Planned Start","Planned Finish","Planned Duration (workdays)","Revised Start","Revised Finish","Revised Duration (workdays)","Actual Start","Actual Finish","Actual Duration (workdays)","Remarks"]
["A0815","2018-08-20","Foundations Bldg. A","Excavate, blind, install rebar, install formwork, pour concrete, remove formworks, cure concrete, waterproof, backfill",null,"2018-07-01","2018-08-15",{"$f":"IF(OR(Register[Planned Start]=0,Register[Planned Finish]=0),\"\",NETWORKDAYS.INTL(Register[[#This Row],[Planned Start]],Register[[#This Row],[Planned Finish]],Workweek[Workweek],Holidays[Date]))","v":39},"2018-07-03","2018-08-14",{"$f":"IF(OR(Register[Revised Start]=0,Register[Revised Finish]=0),\"\",NETWORKDAYS.INTL(Register[[#This Row],[Revised Start]],Register[[#This Row],[Revised Finish]],Workweek[Workweek],Holidays[Date]))","v":37},"2018-07-02","2018-08-19",{"$f":"IF(AND(Register[[#This Row],[Actual Start]]=0,Register[[#This Row],[Actual Finish]]=0),\"\",IF(AND(Register[Actual Start]>0,Register[Actual Finish]=\"\"),NETWORKDAYS.INTL(Register[[#This Row],[Actual Start]],TODAY(),Workweek[Workweek],Holidays[Date]),NETWORKDAYS.INTL(Register[[#This Row],[Actual Start]],Register[[#This Row],[Actual Finish]],Workweek[Workweek],Holidays[Date])))","v":42}]
["A0816","2018-08-21","Foundations Bldg. B","Excavate, blind, install rebar, install formwork, pour concrete, remove formworks, cure concrete, waterproof, backfill",null,"2018-07-01","2018-08-15",{"$f":"IF(OR(Register[Planned Start]=0,Register[Planned Finish]=0),\"\",NETWORKDAYS.INTL(Register[[#This Row],[Planned Start]],Register[[#This Row],[Planned Finish]],Workweek[Workweek],Holidays[Date]))","v":39},"2018-07-03","2018-08-14",{"$f":"IF(OR(Register[Revised Start]=0,Register[Revised Finish]=0),\"\",NETWORKDAYS.INTL(Register[[#This Row],[Revised Start]],Register[[#This Row],[Revised Finish]],Workweek[Workweek],Holidays[Date]))","v":37},"2018-07-03","2018-08-13",{"$f":"IF(AND(Register[[#This Row],[Actual Start]]=0,Register[[#This Row],[Actual Finish]]=0),\"\",IF(AND(Register[Actual Start]>0,Register[Actual Finish]=\"\"),NETWORKDAYS.INTL(Register[[#This Row],[Actual Start]],TODAY(),Workweek[Workweek],Holidays[Date]),NETWORKDAYS.INTL(Register[[#This Row],[Actual Start]],Register[[#This Row],[Actual Finish]],Workweek[Workweek],Holidays[Date])))","v":36}]
["A0817","2018-08-22","Foundations Bldg. C","Excavate, blind, install rebar, install formwork, pour concrete, remove formworks, cure concrete, waterproof, backfill",null,"2018-07-01","2018-08-15",{"$f":"IF(OR(Register[Planned Start]=0,Register[Planned Finish]=0),\"\",NETWORKDAYS.INTL(Register[[#This Row],[Planned Start]],Register[[#This Row],[Planned Finish]],Workweek[Workweek],Holidays[Date]))","v":39},"2018-07-03","2018-08-14",{"$f":"IF(OR(Register[Revised Start]=0,Register[Revised Finish]=0),\"\",NETWORKDAYS.INTL(Register[[#This Row],[Revised Start]],Register[[#This Row],[Revised Finish]],Workweek[Workweek],Holidays[Date]))","v":37},"2018-07-04","2018-08-15",{"$f":"IF(AND(Register[[#This Row],[Actual Start]]=0,Register[[#This Row],[Actual Finish]]=0),\"\",IF(AND(Register[Actual Start]>0,Register[Actual Finish]=\"\"),NETWORKDAYS.INTL(Register[[#This Row],[Actual Start]],TODAY(),Workweek[Workweek],Holidays[Date]),NETWORKDAYS.INTL(Register[[#This Row],[Actual Start]],Register[[#This Row],[Actual Finish]],Workweek[Workweek],Holidays[Date])))","v":37}]
["A0818","2018-08-23","Foundations Bldg. D","Excavate, blind, install rebar, install formwork, pour concrete, remove formworks, cure concrete, waterproof, backfill",null,"2018-07-01","2018-08-15",{"$f":"IF(OR(Register[Planned Start]=0,Register[Planned Finish]=0),\"\",NETWORKDAYS.INTL(Register[[#This Row],[Planned Start]],Register[[#This Row],[Planned Finish]],Workweek[Workweek],Holidays[Date]))","v":39},"2018-07-03","2018-08-14",{"$f":"IF(OR(Register[Revised Start]=0,Register[Revised Finish]=0),\"\",NETWORKDAYS.INTL(Register[[#This Row],[Revised Start]],Register[[#This Row],[Revised Finish]],Workweek[Workweek],Holidays[Date]))","v":37},"2018-07-05",null,{"$f":"IF(AND(Register[[#This Row],[Actual Start]]=0,Register[[#This Row],[Actual Finish]]=0),\"\",IF(AND(Register[Actual Start]>0,Register[Actual Finish]=\"\"),NETWORKDAYS.INTL(Register[[#This Row],[Actual Start]],TODAY(),Workweek[Workweek],Holidays[Date]),NETWORKDAYS.INTL(Register[[#This Row],[Actual Start]],Register[[#This Row],[Actual Finish]],Workweek[Workweek],Holidays[Date])))","v":69}]
["A0819","2018-08-24","Foundations Bldg. E","Excavate, blind, install rebar, install formwork, pour concrete, remove formworks, cure concrete, waterproof, backfill",null,"2018-07-01","2018-08-15",{"$f":"IF(OR(Register[Planned Start]=0,Register[Planned Finish]=0),\"\",NETWORKDAYS.INTL(Register[[#This Row],[Planned Start]],Register[[#This Row],[Planned Finish]],Workweek[Workweek],Holidays[Date]))","v":39},"2018-07-03","2018-08-14",{"$f":"IF(OR(Register[Revised Start]=0,Register[Revised Finish]=0),\"\",NETWORKDAYS.INTL(Register[[#This Row],[Revised Start]],Register[[#This Row],[Revised Finish]],Workweek[Workweek],Holidays[Date]))","v":37},"2018-07-06",null,{"$f":"IF(AND(Register[[#This Row],[Actual Start]]=0,Register[[#This Row],[Actual Finish]]=0),\"\",IF(AND(Register[Actual Start]>0,Register[Actual Finish]=\"\"),NETWORKDAYS.INTL(Register[[#This Row],[Actual Start]],TODAY(),Workweek[Workweek],Holidays[Date]),NETWORKDAYS.INTL(Register[[#This Row],[Actual Start]],Register[[#This Row],[Actual Finish]],Workweek[Workweek],Holidays[Date])))","v":68}]

{"sheet":"Configuration","index":2,"n_rows":12,"n_cols":4,"rows_kept":12}
["Date","Holiday",null,"Workweek"]
["2018-01-01","New Year",null,11]
["2018-03-30","Good Friday"]
["2018-04-02","Easter Monday"]
["2018-05-01","Labour Day"]
["2018-06-01","Madaraka Day"]
["2018-06-15","Eid Al Fitr"]
["2018-10-10","Moi Day"]
["2018-10-20","Mashujaa Day"]
["2018-12-12","Jamhuri Day"]
["2018-12-25","Christmas Day"]
["2018-12-26","Boxing Day"]