5A.01b Tree Replacement Worksheet - 230404.xlsx

	A	B	C	D	E	F	G	I	J	K	L	M	N	O	P	Q	R	S	T	AR	BG	BX	CM
1	UMD 5A.01b Tree Preservation, Protection, and Planting																Last Updated: 04/04/2023
2
3	Tree Replacement Work Sheet
4
5	Investigator:									Inspection Date:										Inspection Date:	Inspector:	Inspection Date:	Inspector:
6	University Project Manager:									Project #:										Project #:	Company:	Project #:	Company:
7										Project Name:										Project Name:	Prime Contractor:	Project Name:	Prime Contractor:
8																				University Project Manager:		University Project Manager:
9	Determining the Caliper Inches of a Deciduous Tree									Determining Height of a Coniferous Tree
10	Measure the circumference of tree at 4.5' above ground									Holding a ruler vertically with an out stretched arm, move away from the tree until tree and ruler are the same size.
11	Use table below to convert to caliper inch
12	Circumference of a Circle = PI*d									Turn your wrist so that the ruler is in the horizontal position.
13	Example: Circumference of 27" = 8" Replacement									Align one end of the ruler with the base of the tree, then measure the distance from the base of the tree to the spot you see at the other end of the ruler.
14
15	Replacement Tree Charts									Example: Height of 11' = 5' Replacement
16	Deciduous				Coniferous
17	Circumference (inch)	Caliper Inches	Replacement Caliper Inches	Replacement (Specimen Tree)	Height (FT)	Replacement Feet	Replacement (Specimen Tree)	Tree Number (from drawings)	Tree Type	Notes	Good Health	Poor Health	Moveable (Y/N)	Specimen Tree (Y/N)	% Of Unobstructed Canopy	Measured Circumference or Height (inch / foot)	Calculated Caliper (Inches)	Deciduous Replacement (Inches)	Coniferous Replacement (Feet)
18	13	4	2	2	10	5	5
19	16	5	2	2	11	5	5
20	19	6	3	3	12	6	6
21	22	7	3	3	13	6	6
22	25	8	8	8	14	7	7
23	28	9	9	9	15	15	15
24	31	10	10	10	16	16	16
25	35	11	11	11	17	17	17
26	38	12	12	24	18	18	18
27	41	13	13	26	19	19	19
28	44	14	14	28	20	20	40
29	47	15	15	30	21	21	42
30														Total Page 1				0	0
31														Total Page 2				0	0
32														Total Page 3				0	0
33														Total Page 4				0	0
34														Total Replacement Required				0	0
35																		, 609.08
36	Replacement Tree Charts
37	Deciduous				Coniferous
38	Circumference (inch)	Caliper Inches	Replacement Caliper Inches	Replacement (Specimen Tree)	Height (FT)	Replacement Feet	Replacement (Specimen Tree)	Tree Number (from drawings)	Tree Type	Notes	Good Health	Poor Health	Moveable (Y/N)	Specimen Tree (Y/N)	% Of Unobstructed Canopy	Measured Circumference or Height (inch / foot)	Calculated Caliper (Inches)	Deciduous Replacement (Inches)	Coniferous Replacement (Feet)
39	50	16	16	32	22	22	44
40	53	17	17	34	23	23	46
41	57	18	18	36	24	24	48
42	60	19	19	38	25	25	50
43	63	20	20	40	26	26	52
44	66	21	21	42	27	27	54
45	69	22	22	44	28	28	56
46	72	23	23	46	29	29	58
47	75	24	24	48	30	30	60
48	79	25	25	50	31	31	62
49	82	26	26	52	32	32	64
50	85	27	27	54	33	33	66
51	88	28	28	56	34	34	68
52	91	29	29	58	35	35	70
53	94	30	30	60	36	36	72
54	97	31	31	62	37	37	74
55	101	32	32	64	38	38	76
56	104	33	33	66	39	39	78
57	107	34	34	68	40	40	80
58	110	35	35	70	41	41	82
59	113	36	36	72	42	42	84
60	116	37	37	74	43	43	86
61	119	38	38	76	44	44	88
62	123	39	39	78	45	45	90
63	126	40	40	80	46	46	92
64														Total Page 2				0	0
65
66	Replacement Tree Charts
67	Deciduous				Coniferous
68	Circumference (inch)	Caliper Inches	Replacement Caliper Inches	Replacement (Specimen Tree)	Height (FT)	Replacement Feet	Replacement (Specimen Tree)	Tree Number (from drawings)	Tree Type	Notes	Good Health	Poor Health	Moveable (Y/N)	Specimen Tree (Y/N)	% Of Unobstructed Canopy	Measured Circumference or Height (inch / foot)	Calculated Caliper (Inches)	Deciduous Replacement (Inches)	Coniferous Replacement (Feet)
69					47	47	94
70					48	48	96
71					49	49	98
72					50	50	100
73					51	51	102
74					52	52	104
75					53	53	106
76					54	54	108
77					55	55	110
78					56	56	112
79					57	57	114
80					58	58	116
81					59	59	118
82					60	60	120
83					61	61	122
84					62	62	124
85					63	63	126
86					64	64	128
87					65	65	130
88					66	66	132
89					67	67	134
90					68	68	136
91					69	69	138
92					70	70	140
93					71	71	142
94														Total Page 3				0	0
95
96	Replacement Tree Charts
97	Deciduous				Coniferous
98	Circumference (inch)	Caliper Inches	Replacement Caliper Inches	Replacement (Specimen Tree)	Height (FT)	Replacement Feet	Replacement (Specimen Tree)	Tree Number (from drawings)	Tree Type	Notes	Good Health	Poor Health	Moveable (Y/N)	Specimen Tree (Y/N)	% Of Unobstructed Canopy	Measured Circumference or Height (inch / foot)	Calculated Caliper (Inches)	Deciduous Replacement (Inches)	Coniferous Replacement (Feet)
99					72	72	144
100					73	73	146