Excel Data converted to a either Excel Report or Web Report

I have a service where I process data from hotel rooms in USA. This includes the run-time data of HVAC and other communications from a hotel guest room. I have access to a software that outputs a monthly report of the different data into columns on an Excel sheet.

My project is to hire someone to design and prepared either a Excel sheet that can take the data and output a report that can quickly link to this data and provide a quality report that I can send to customers as a PDF. Other option is to have a web page that links to the data and provides the reports from the Excel data.

There is a lot of data in monthly columns, so the key is to convert this to relevant and visual information for a select number of the columns. Attached is a sample of the input data, and a crude example of output.