Could someone please help - functions to analyse results

I'm having difficulty developing a spreadsheet to analyse specific data that I'm interested in and would appreciate if someone could help me out.

I have 24 hourly data for 365 days, thus giving me a total of 8760 results. However, I'm only interested in processing data that are between the hours of 08:00 and 18:00 Monday to Friday for the year.

I don't want to account for data outwith these hours and for those occurring during the weekend.

The purpose of my analysis is to determine the number of hours during air handling plant operation whereby the air heating load falls below 87kW. I have used conditional formatting to highlight cells red where this occurs and then IF function to identify Heating Load < 87kW? (0=No, 1=Yes).

The idea here is that I can then sum up the total number of hours of plant operation (08:00 to 18:00 Monday to Friday for the year) and compare this total operation hours with the number of hours where the air heating load falls below 87kW. I can then determine the percentage of hours where this occurs.

I would also like to develop an annual graph that then allows the data to be shown for the year that identifies space heating periods and summer months.

I've tried to work this out myself and I'm struggling to progress further. I'm not looking for anyone to do the work for me, but would very much appreciate if someone can help out with some suggestions.

Attach a sample workbook (not image).

Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate.

Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Hi John,

Thank you for your reply. I attach the workbook I have developed and also included a desired output sheet. Any ideas how I can achieve what Im looking to do?

Thanks for your response shg.

I've made the corrections to the calculations. Thanks for finding these.

However, how can I add the date on each row when I have 365 days. Apologies if this is a stupid question but I can only see me being able to do this by dragging down the date to cover the hours for that day, but I will have to do individually for all 365 days. Is there an easy way to do this?

Thanks

Ok I'm trying to figure it out now. Thanks

Why is column C blank for date but is used in the formula?

Ignore the last post. It's now working. Thanks

thanks got it working. thanks for all your help

Hi shg

I've added 10% of the total heating load on top to take account of the system losses. Why do you think this is incorrect?