(This is the last day's data. The highest in this year is 7996.248. Ask me if you need more informations from chart.)

Objective: The goal of this homework is to calculate the required size of a Battery Energy Storage System (BESS) in MW and MWh for the purpose of equipment upgrade deferral on a sample distribution circuit. Instructions: Use Microsoft Excel to calculate the requested information 1) Use the sample 8760 load profile as the base year load profile (2018). Calculate the load profile in 2019, 2020, 2021, and 2022 using 2% load growth factor. 2) Assume that the loading limit of the circuit is 7. 5 Mw. a. For each year, using the 8760 load profile and loading limit identify the hours in which thee circuit load exceeds the loading limit. Draw a graph and identify the load profile, loading limit, and violating hours on the graph For each year, calculate the total number of hours for which the circuit load exceeds the loading limit For each year, calculate the total amount of annual energy (in kWh) for the hours that circuit load is above the circuit loading limit. b. c. 8760 (Load(h) - Loading Limit) if Load(h) > Loading Limit d. For each year, identify the maximum amount of circuit load above the circuit limit (in kw) (Maximum Load Loading Limit) For each year, identify the maximum amount of cumulative violating energy (in kWh) e. Cumulative violating energy = SUM ((Load(h)-Limit) + (Load(h-1) _ Limit)-... + (Load(h - N) - Limit) if (Load(h + 1) Loading Limit d. For each year, identify the maximum amount of circuit load above the circuit limit (in kw) (Maximum Load Loading Limit) For each year, identify the maximum amount of cumulative violating energy (in kWh) e. Cumulative violating energy = SUM ((Load(h)-Limit) + (Load(h-1) _ Limit)-... + (Load(h - N) - Limit) if (Load(h + 1)