Given a facility’s hourly chilled water (CHW) cooling load demand shown in the following spreadsheet, a combined chiller and stratified CHW thermal storage system is proposed to meet the demand while saving the cost (due to the time-of-use rate schedule). A full storage operating strategy (load shift) is employed in which the chiller is completely turned off for the 5-hour ON-PEAK rate period from 12pm to 4 pm (why 5 hours? It starts from 12pm to 5pm, i.e., from 12-1pm, 1-2pm, 2-3pm, 3-4pm, and 4-5pm.) with the cooling load solely provided by the CHW storage system. During the NON ON-PEAK period (5pm to 11am), the chiller will meet the instantaneous cooling load demand in addition to store thermal capacity.

Construct an Excel spreadsheet based on the one in the next page which illustrates the load shifting operating strategy and answer questions 1-10 on Blackboard.