I need help calculating EXCEL SLA for Server Downtime

I need someone to assist me with the following excel document. This document has two tabs. The first tab is the raw data for the excel sheet. The second tab is information that requires interpretation to get numbers. For instance, the Incidents By BU Past 30 Days has incidents in the past 30 days by BU. The number needs to be the amount of incidents that are 30 days or older and that belong to that BU. The second time is the total down time. Total down time is the amount of minutes the server was down. The percentage Up time should be the number of minutes the server was down divided by the time the servers was up (minutes in 30 days). I have pre-populated the excel sheet with data to make the formulas work. To complete this task, you will need to create forumulas for the B, C, and D columns for the second worksheet and these columns should adjust themselves accordingly based on the data that is entered on the 1st sheet.  Any ideas or a better approach to this type of collection?
Server-Outage-Tracking-Draft.zip