Annual Building Utility Performance Graphing

	C	D	E	F	G	H	I	K	M
1	Instructions:	1. To edit this, chose "Make a Copy" from the file menu. This will copy the spreadsheet to your personal Google Documents Account
2		2. Paste data in from your Annual Building Utility Performance Summary into the two colored blocks below
3
4
5	Baseline Model	Baseline Full Service Restaurant (post 1980), Boulder (5b)
6
7	Building Area (m2)	530.36	Get this value from "Building Area" table
8
9	End Uses
10
11		Electricity [GJ]	Natural Gas [GJ]	Other Fuel [GJ]	District Cooling [GJ]	District Heating [GJ]	Water [m3]
12	Heating	0	0	0	0	1146.32	0
13	Cooling	0	0	0	1070.31	0	0
14	Interior Lighting	294.38	0	0	0	0	0
15	Exterior Lighting	0	0	0	0	0	0
16	Interior Equipment	559.86	745.33	0	0	0	0
17	Exterior Equipment	0	0	0	0	0	0
18	Fans	0	0	0	0	0	0
19	Pumps	0	0	0	0	0	0
20	Heat Rejection	0	0	0	0	0	0
21	Humidification	0	0	0	0	0	0
22	Heat Recovery	0	0	0	0	0	0
23	Water Systems	0	0	0	0	0	0
24	Refrigeration	0	0	0	0	0	0
25	Generators	0	0	0	0	0	0
26
27	Total End Uses	854.24	745.33	0	1070.31	1146.32	0
28
29
30
31
32	Proposed Model	New Kitchen Equipment (2009 Low Energy Case)
33
34	Building Area (m2)	530.36	Get this value from "Building Area" table					Total EUI Savings (Kbtu/ft2):	72.9
35
36	End Uses
37
38		Electricity [GJ]	Natural Gas [GJ]	Other Fuel [GJ]	District Cooling [GJ]	District Heating [GJ]	Water [m3]
39	Heating	0	0	0	0	1148.6	0
40	Cooling	0	0	0	646.75	0	0
41	Interior Lighting	294.38	0	0	0	0	0
42	Exterior Lighting	0	0	0	0	0	0
43	Interior Equipment	460	544.56	0	0	0	0
44	Exterior Equipment	0	0	0	0	0	0
45	Fans	0	0	0	0	0	0
46	Pumps	0	0	0	0	0	0
47	Heat Rejection	0	0	0	0	0	0
48	Humidification	0	0	0	0	0	0
49	Heat Recovery	0	0	0	0	0	0
50	Water Systems	0	0	0	0	0	0
51	Refrigeration	0	0	0	0	0	0
52	Generators	0	0	0	0	0	0
53
54	Total End Uses	754.39	544.56	0	646.75	1148.6	0
55
56
57	Global Coefficient of Performance values applied to end use charts and tables (except for raw data above)
58
59		COP
60	Heating	0.80	*
61	Cooling	3.00	**
62
63	Energy Use Comparison (GJ)
64
65		Baseline (GJ)	Proposed (GJ)	Savings (GJ)	Proposed Savings
66	Heating *	1,432.90	1,435.75	-2.85	-0.20%
67	Cooling**	356.77	215.58	141.19	39.57%
68	Interior Lighting	294.38	294.38		0.00%
69	Exterior Lighting	0.00	0.00
70	Interior Equipment	1,305.19	1,004.56	300.63	23.03%
73	Exterior Equipment	0.00	0.00
74	Fans	0.00	0.00
75	Pumps	0.00	0.00
76	Heat Rejection	0.00	0.00
77	Humidification	0.00	0.00
78	Heat Recovery	0.00	0.00
79	Water Systems	0.00	0.00
80	Refrigeration	0.00	0.00
81	Generators	0.00	0.00
82					%savings
83	Total End Uses	3,389.24	2,950.27	438.97	12.95%
84
85	area (m2)	530.36	530.36
86
87
88	Energy Use Intensity (EUI)				Energy Use Intensity (EUI)
89
90		Baseline (MJ/m2)	Proposed (MJ/m2)			Baseline (Kbtu/ft2)	Proposed (Kbtu/ft2)	Proposed EUI Savings (Kbtu/ft2)
91	Heating*	2,701.7	2,707.1		Heating*	237.9	238.4	-0.5
92	Cooling**	672.7	406.5		Cooling**	59.2	35.8	23.4
93	Interior Lighting	555.1	555.1		Interior Lighting	48.9	48.9	0.0
94	Exterior Lighting	0.0	0.0		Exterior Lighting	0.0	0.0	0.0
95	Interior Equipment	2,461.0	1,894.1		Interior Equipment	216.7	166.8	49.9
96	Exterior Equipment	0.0	0.0		Exterior Equipment	0.0	0.0	0.0
97	Fans	0.0	0.0		Fans	0.0	0.0	0.0
98	Pumps	0.0	0.0		Pumps	0.0	0.0	0.0
99	Heat Rejection	0.0	0.0		Heat Rejection	0.0	0.0	0.0
100	Humidification	0.0	0.0		Humidification	0.0	0.0	0.0
101	Heat Recovery	0.0	0.0		Heat Recovery	0.0	0.0	0.0
102	Water Systems	0.0	0.0		Water Systems	0.0	0.0	0.0