Construction Template Excel 40193

Partial file snippet.

Sheet 1: Instructions

Instructions for DT1923 - Contract Time for Completion Spreadsheet

See FDM 19-10-30 for general information on the Contract Time for Completion analysis.

1. The form is locked. Information can only be entered in the yellow shaded cells.

2. Enter project information at the top of the form.

3. Enter the construction year at the bottom of the page to automatically fill out all the Begin and End dates for each month. Then, delete Begin and End dates for months before the anticipated start date, and after the anticipated completion date. Change the Begin date for the applicable month to the actual probable date of beginning and change the end date for the applicable month to the anticipated completion date. Under the Month column, delete names for unused months to remove the labels from the Gantt Chart.

4. Check the box for the Contract Work Type to be used.

5. Enter number of holiday days for each month. See FDM 19-15-23 for how to enter for Independence Day.

6. If work is expected to take place on weekends or holidays during a month, fill in the number of these days under Adjusted Work Days Modifier. This will adjust the total possible work days before applying the probable work day percentage.

7. Enter probable working day percentage based on the work type (see FDM 19-10 Attachment 30.2).

8. Totals for Calendar Days Contract and Working Day Contract are autofilled based on the calculated totals from the bottom left table. These can be overwritten if necessary. Round to 5 day increments. Fill in the anticipated completion date if the contract will be a Completion Date Contract.

9. Enter controlling items on left side of page under Item Analysis.

10. Enter item quantities for each stage (all stages do not need to be used).

11. Enter item units and production rates (also see FDM 19-10-30.3).

12. Enter begin day for each item and stage (the end date will be calculated automatically). Tip: You can use a formula here, for instance to start Item 2 when Item 1 is done, you would enter =W30 in cell V31. That way if you add 2 days to Item 1, the start date for Item 2 will automatically adjust by 2 days.

13. If the default "Stage 1", "Stage 2", etc., doesn't work for your project, you can edit them in the yellow shaded cells. The legend and other column headings will update automatically.

14. Enter remarks as necessary to provide work restrictions, interim completions, etc.

15. To get rid of extra days (blank space) on the right side of the Gantt Chart, right click on the top axis and select "Format Axis". Under "Axis Options", Change "Maximum" from "Auto" to "Fixed" and set the value to the total number of working days for the contract.

16. Create a separate Time Chart sheet for each calendar year of construction if there are multiple years. Put the overall working days, calendar days, or completion date on each sheet.

Contact Rielly O'Donnell (rielly.odonnell@dot.wi.gov) with any suggested revisions to this form.

Sheet 2: Blank Time Chart

CONTRACT TIME FOR COMPLETION

Wisconsin Department of Transportation DT1923 04/2021

Project ID
5215-00-67

Highway
STH 35

Project Title
Lancaster - Bloomington

Date of Letting
March 8, 2022

Work Type
Resurfacing

County
Grant

Project Limits
McKinley St to Grant River Bridge

Probable Date of Beginning
June 1, 2022

ITEM ANALYSIS

Item
Contract Quantity per Stage
Total Quantity
Unit
Production Rate
Working Days
(per Stage)
Milling
Overlay
Finishing

Milling
Overlay
Finishing
-
-
Begin
End
Begin
End
Begin
End
Begin
End
Begin
End

1. Traffic Control
40

40
Days
1
40
/

0
40

2. Pipe Underdrain
63

63
LF
60
2
/

1
2

3. Milling
125,655

120,000
SY
10000
13
/

3
16

4. HMA Pavement Overlay

14,800

14,800
Tons
1,000

/
15
/

6
21

5. Base Aggregate Dense 3/4 Inch

2,200

2,200
Tons
300

/
8
/

21
29

6. Rumble Strip Centerline

25,204

25,204
LF
8,450

/
3
/

29
32

7. Pavement Marking

110,000

110,000
LF
36,000

/
4
/

32
36

8. Finishing Roadway

4
Days
1

/
4
/

36
40

Date
Days

Possible Work Days
Additional Work Days Modifier
Adjusted Possible Work Days
Probable Work Days

Note: Chart is based on the assumption of work not occuring on weekends or holidays. If work is expected to occur on these days, adjust Possible Work Days by adding days to the Additional Work Days Modifier column. See FDM 19-10-30.

Month
Begin
End
Month
Total
Holiday
%
Month
Total

0
0

REMARKS

0
0

Rates determined using WisDOT production rate table. Lower rates used based on flagging operations. STH 35 will be open to two-way traffic at all times except through the work zone that utilizes traffic control for lane closures with flagging operations.

0
0

June
6/1/2022
6/30/2022
30
30
0
23

23
80
18
18

July
7/1/2022
7/31/2022
31
61
1
21

21
85
18
36

August
8/1/2022
8/5/2022
5
66
0
5

5
85
4
40

0
66

0
40

Contract Work Type

0
66

0
40

0
66

0
40

Working Day

Prepared By

0
66

0
40

Completion Date

August 5, 2022

Erin Clements

Page 1 of 1
CONSTRUCTION YEAR:
2022

The words contained in this file might help you see if this file matches what you are looking for:

...Sheet instructions for dt contract time completion spreadsheet see fdm general information on the analysis form is locked can only be entered in yellow shaded cells enter project at top of construction year bottom page to automatically fill out all begin and end dates each month then delete months before anticipated start date after change applicable actual probable beginning under column names unused remove labels from gantt chart check box work type used number holiday days how independence day if expected take place weekends or holidays during a these adjusted modifier this will adjust total possible applying percentage working based attachment totals calendar are autofilled calculated left table overwritten necessary round increments controlling items side item quantities stage stages do not need units production rates also tip you use formula here instance when done would w cell v that way add by default quot etc doesn t your edit them legend other headings update remarks as provi...

Related files

Share

Help

CONTRACT TIME FOR COMPLETION
Wisconsin Department of Transportation DT1923 04/2021

Project ID	5215-00-67			Highway	STH 35				Project Title	Lancaster - Bloomington															Date of Letting	March 8, 2022
Work Type	Resurfacing			County	Grant				Project Limits	McKinley St to Grant River Bridge															Probable Date of Beginning	June 1, 2022























ITEM ANALYSIS
Item		Contract Quantity per Stage					Total Quantity	Unit	Production Rate		Working Days (per Stage)								Milling		Overlay		Finishing
Item		Milling	Overlay	Finishing	-	-	Total Quantity	Unit	Production Rate		Working Days (per Stage)								Begin	End	Begin	End	Begin	End	Begin	End	Begin	End
1. Traffic Control		40					40	Days	1		40	/		/		/	/		0	40
2. Pipe Underdrain		63					63	LF	60		2	/		/		/	/		1	2
3. Milling		125,655					120,000	SY	10000		13	/		/		/	/		3	16
4. HMA Pavement Overlay			14,800				14,800	Tons	1,000			/	15	/		/	/				6	21
5. Base Aggregate Dense 3/4 Inch			2,200				2,200	Tons	300			/	8	/		/	/				21	29
6. Rumble Strip Centerline				25,204			25,204	LF	8,450			/		/	3	/	/						29	32
7. Pavement Marking				110,000			110,000	LF	36,000			/		/	4	/	/						32	36
8. Finishing Roadway				4			4	Days	1			/		/	4	/	/						36	40
												/		/		/	/
												/		/		/	/
												/		/		/	/
												/		/		/	/
												/		/		/	/
												/		/		/	/
												/		/		/	/
												/		/		/	/
												/		/		/	/
												/		/		/	/
												/		/		/	/
												/		/		/	/

	Date		Days			Possible Work Days	Additional Work Days Modifier	Adjusted Possible Work Days		Probable Work Days								Note: Chart is based on the assumption of work not occuring on weekends or holidays. If work is expected to occur on these days, adjust Possible Work Days by adding days to the Additional Work Days Modifier column. See FDM 19-10-30.
Month	Begin	End	Month	Total	Holiday	Possible Work Days	Additional Work Days Modifier	Adjusted Possible Work Days		%	Month			Total
			0	0		0		0			0			0				REMARKS
			0	0		0		0			0			0				Rates determined using WisDOT production rate table. Lower rates used based on flagging operations. STH 35 will be open to two-way traffic at all times except through the work zone that utilizes traffic control for lane closures with flagging operations.
			0	0		0		0			0			0
			0	0		0		0			0			0
			0	0		0		0			0			0
June	6/1/2022	6/30/2022	30	30	0	23		23		80	18			18
July	7/1/2022	7/31/2022	31	61	1	21		21		85	18			36
August	8/1/2022	8/5/2022	5	66	0	5		5		85	4			40
			0	66		0		0			0			40				Contract Work Type
			0	66		0		0			0			40								66
			0	66		0		0			0			40					Working Day			40				Prepared By
			0	66		0		0			0			40					Completion Date			August 5, 2022				Erin Clements

								Page 1 of 1		CONSTRUCTION YEAR:									2022

Related files

Share

Share to social media

Help

Login Area