Girder Defect Sheet Automation.xlsm

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI	AJ	AK	AL	AM	AN	AO	AP	AQ	AR	AS	AT	AU	AV	AW	AX	AY	AZ	BA	BB	BC	BD	BE	BF	BG	BH	BI	BJ	BK	BL	BM	BN
1	Girder Defect Sheet
2	Structure ID:				Bridge ID, Facility Carried over Feature Intersected, Location																											Number of Spans					1
3																																Span Length (ft)
4	Defect Legend:		Severed Strand (10)													Concrete Cracking (50)																Span 1					32
5			Concrete Spall w/Reinforcement (20)													Efflorescence Staining w/Cracking (60)																Span 2
6			Concrete Spall w/o Reinforcement (30)													Built-Up Efflorescence w/Cracking (70)																Span 3
7			Concrete Delamination(40)													Efflorescence (80)																Number of Girders					15
8
9
10				Span 1																					Span 2																					Span 3
11				1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20		1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20		1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20
12			Abutment 1 (West)																					Pier 2																					Pier 3																					Abutment 4 (East)
13	Girder 1
14
15	Girder 2
16
17	Girder 3
18
19	Girder 4
20
21	Girder 5
22
23	Girder 6
24
25	Girder 7											3
26
27	Girder 8
28
29	Girder 9
30
31	Girder 10
32
33	Girder 11
34
35	Girder 12
36
37	Girder 13
38
39	Girder 14
40
41	Girder 15
42
43
44
45	Notes:	1. Each square represents 1 linear foot of girder.																										Girder Condition State Quantities
46		2. The drawing is not to scale.																														Total (FT)
47		3. The space on the exterior sides and between the girders represent the underside of the deck.																												CS2		0
48		4. Numbers within each cell represent the Condition State of the defect type.																												CS3		1
49																														CS4		0
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100