{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["DuraLator","Duration Plot","HelpSheet","Dates"],"not_rendered":{"charts":2,"images":3,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"Duration Plot","index":1,"reason":"not_a_worksheet"}],"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":"DuraLator","index":0,"n_rows":19,"n_cols":12,"rows_kept":19,"cut":false,"hidden":false,"merged":[[13,9,14,9],[13,10,14,10],[13,11,14,11],[13,8,14,8],[0,0,0,12],[1,0,1,12],[2,0,2,12],[6,8,6,10],[7,8,7,10],[3,8,5,11]]}
["DuraLator (v20.8)"]
["The Project Duration Calculator"]
["Virginia Department of Transportation"]
[]
[]
[null,"Month","Calendar Days","Workdays (Week)","Non-Workdays (Month)","Available Workdays (Month)"]
[null,"Jan",31,5,10,{"$f":"ROUNDDOWN((C7*(D7/7))-(E7*(D7/7)),0)","v":15},null,null,"Planned Start Date",null,null,"2021-01-01"]
[null,"Feb",28,5,10,{"$f":"ROUNDDOWN((C8*(D8/7))-(E8*(D8/7)),0)","v":12},null,null,"Total Number of Working Days",null,null,100]
[null,"Mar",31,5,8,16,null,null,null,null,null,{"$f":"IFERROR(IF(L7=\"\",\"\",YEAR(L7)),\"\")","v":2021}]
[null,"Apr",30,5,8,15]
[null,"May",31,5,7,17]
[null,"Jun",30,5,6,17]
[null,"Jul",31,5,5,18]
[null,"Aug",31,5,5,18,null,null,null,"Start Date","Completion Date","Calendar Days"]
[null,"Sep",30,5,6,17]
[null,"Oct",31,5,7,17,null,null,"Projected","2021-01-01","2021-07-16",{"$f":"IF(OR(J16=\"\",K16=\"\"),\"\",K16-J16+1)","v":197}]
[null,"Nov",30,5,8,15,null,null,"Shortest","2021-04-26","2021-10-19",177]
[null,"Dec",31,5,10,15,null,null,"Longest","2021-10-11","2022-05-04",206]
[null,"Total",null,null,{"$f":"SUM(E7:E18)","v":90},{"$f":"SUM(F7:F18)","v":192}]

{"sheet":"HelpSheet","index":2,"n_rows":8,"n_cols":2,"rows_kept":8,"cut":false,"hidden":true,"merged":[]}
["About the Dura-Lator","The Dura-Lator can be used to convert the project overall number of expected working days to calendar days and the projected completion date.\n\nThe date on which the project is expected to begin is used to determine the projected completion date for the project.  The expected number of working days is applied to the project calendar to calculate the completion date.\n\nProject completion dates are plotted against start dates, along with the corresponding number of calendar days.  The projected, shortest and longest project durations and corresponding project dates are reported."]
["Data Input Requirements","Input data is signified by the yellow background and includes:\n\n     1) Workdays (Week)\n     2) Non-Workdays (Month)\n     3) Planned Start Date\n     4) Total Number of Working Days\n\nThe workdays and non-workdays are used to calculate the number of working days available each month.  The working days consitute the project calendar to which the expected number of working days is applied."]
["Workdays (Week)","The number of workdays in the standard work week.  It may vary by month and is used to calculate the number of available workdays each month."]
["Non-Workdays (Month)","The number of calendar days on which it is expected that work can not be performed due to conditions beyond the control of the contractor.  Non-workdays may include holidays, anticipated adverse weather conditions, environmental restrictions, traffic constraints, or other project contraints."]
["Planned Start Date","The planned start date is the date on which work is scheduled to begin.  The planned start date is used to calculate the projected completion date and number of calendar days. For the \"Shortest\" and \"Longest\" durations, the project is assumed to begin on each Monday of the year and the corresponding completion date and required number of calendar days is calculated."]
["Total Number of Working Days","The total number of expected workdays required to complete the project as derived from the VDOT CTD Barchart tool or other means."]
["Calculating Completion Dates","For the \"Shortest\" and \"Longest\" durations, the project is assumed to start on each Monday of the start year and the corresponding completion date is calculated by applying the required number of working days to the project schedule.  \n\nIf the calculated completion date falls on a weekend (Sat. or Sun.), the the date of the following Monday is returned."]
["Duration Plot","The duration plot shows for any start date (x-axis) the corresponding:\n\n     1) Number of Projected Calendar Days (left y-axis)\n     2) Completion Date (right y-axis)"]

{"sheet":"Dates","index":3,"n_rows":52,"n_cols":6,"rows_kept":52,"cut":false,"hidden":true,"merged":[]}
["2021-01-04","2021-07-19",{"$f":"B1-A1+1","v":197},null,{"$f":"EDATE(A1,0)","v":"2021-01-04"},"First Start"]
["2021-01-11","2021-07-23",194,null,{"$f":"EDATE($A$52,0)","v":"2021-12-27"},"Last Start"]
["2021-01-18","2021-07-28",192,null,{"$f":"ROUNDDOWN(MIN(C1:C52),-1)","v":170},"Cal days min"]
["2021-01-25","2021-08-05",193,null,{"$f":"ROUNDUP(MAX(C1:C52),-1)","v":210},"Cal days max"]
["2021-02-01","2021-08-09",190,null,{"$f":"EDATE(B1,0)","v":"2021-07-19"},"First Completion"]
["2021-02-08","2021-08-16",190,null,{"$f":"EDATE(B52,0)","v":"2022-07-12"},"Last Completion"]
["2021-02-15","2021-08-18",185,null,{"$f":"IF(DuraLator!L7=\"\",\"\",DuraLator!L7)","v":"2021-01-01"},"Planned Start Date"]
["2021-02-22","2021-08-23",183,null,{"$f":"IF(WEEKDAY(E7)=2,E7,\nIF(WEEKDAY(E7)=3,E7+6,\nIF(WEEKDAY(E7)=4,E7+5,\nIF(WEEKDAY(E7)=5,E7+4,\nIF(WEEKDAY(E7)=6,E7+3,\nIF(WEEKDAY(E7)=7,E7+2,\nIF(WEEKDAY(E7)=1,E7+1)))))))","v":"2021-01-04"},"Start Date (Monday)"]
["2021-03-01","2021-08-30",183,null,{"$f":"INDEX(B:B,MATCH(E8,A:A,0))-(E8-E7)","v":"2021-07-16"},"Projected Completion Date"]
["2021-03-08","2021-09-07",184]
["2021-03-15","2021-09-13",183]
["2021-03-22","2021-09-20",183]
["2021-03-29","2021-09-27",183]
["2021-04-05","2021-10-04",183]
["2021-04-12","2021-10-07",179]
["2021-04-19","2021-10-14",179]
["2021-04-26","2021-10-19",177]
["2021-05-03","2021-10-26",177]
["2021-05-10","2021-11-04",179]
["2021-05-17","2021-11-12",180]
["2021-05-24","2021-11-22",183]
["2021-05-31","2021-11-26",180]
["2021-06-07","2021-12-06",183]
["2021-06-14","2021-12-13",183]
["2021-06-21","2021-12-20",183]
["2021-06-28","2021-12-28",184]
["2021-07-05","2022-01-06",186]
["2021-07-12","2022-01-17",190]
["2021-07-19","2022-01-24",190]
["2021-07-26","2022-02-02",192]
["2021-08-02","2022-02-14",197]
["2021-08-09","2022-02-22",198]
["2021-08-16","2022-03-02",{"$f":"B33-A33+1","v":199}]
["2021-08-23","2022-03-09",199]
["2021-08-30","2022-03-17",200]
["2021-09-06","2022-03-24",200]
["2021-09-13","2022-04-04",204]
["2021-09-20","2022-04-11",204]
["2021-09-27","2022-04-18",204]
["2021-10-04","2022-04-26",205]
["2021-10-11","2022-05-04",206]
["2021-10-18","2022-05-11",206]
["2021-10-25","2022-05-18",206]
["2021-11-01","2022-05-23",204]
["2021-11-08","2022-05-30",204]
["2021-11-15","2022-06-06",204]
["2021-11-22","2022-06-13",204]
["2021-11-29","2022-06-20",204]
["2021-12-06","2022-06-23",200]
["2021-12-13","2022-07-01",201]
["2021-12-20","2022-07-05",198]
["2021-12-27","2022-07-12",198]