SLA calculation / how to work out the % of uptime v actual target

[countdownkev]

Hi there,

I'm trying to set up a calculation to look at performance v targets.
I am sure this should be a simple enough formula to complete but its still making my head hurt so if anyone can help it would really be a bonus

I m looking at a calculation to work out if uptime of a data link circuit meets a SLA of 99.95%. I'm not a rocket scientist ( much nearer the other end of the spectrum ) but the outage time in this case was 18.43 hours (and even with my maths I know that sucks ) So what I need to then calculate is the actual availability percentage so that the penalty can be applied.

If anybody can help it would be really appreciated
thank you, kev

 

[Gerald Higgins]

Hi, welcome to the board.

This looks like a maths problem more than an excel problem, but hey ho . . .

Let's say your outage time is in cell A1
Let's say your service time is in cell A2.

By service time, I mean the total number of hours that the service SHOULD have been available.

The actual service achieved is then
=(A2-A1)/A2, and format as %.

If your service time is 10 years, or about 88,000 hours, then your SLA is 99.98% - you've done it !
On the other hand, if your service time is 24 hours, your SLA is 23.2 % - not so hot.
Calculated as (24-18.43)/24.