Computer Science Question

this short assignment is an excel spread sheet of calculating MTTR. all details is in the attached docs .

COMPONENT:
Instructions:
Failure
Occurrence #
Enter the name of an IT infrastructure component here.
Think of 12 reasons why this component might fail.
Issue Description
(Write a Plausible Reason for the Failure)
1 Power Issue. Replaced missing part.
2
3
…
12
Submit your completed Excel file – INCLUDING – your
responses to the two questions (in Chapter 10 Slides’
Activity) which can be pasted below.
Your Name:
Enter your name here.
Use Excel formulas to
compute the amount of
time that each failure
lasted. Be precise.
Enter 12 dates and times below that this IT
component was down. (Enter one failure
per month.) To be realistic, each of the
times you enter should be unique.
DOWN
(yyyy-mmm-dd hh:mm:ss AM/PM)
2018-Jan-01 11:59:23 AM
2018-Feb-12 01:49:38 AM
Compute MTTR four ways (related to
the column headings above: in Days;
Hours; Minutes; and Seconds.)
Date:
UP
(yyyy-mmm-dd hh:mm:ss AM/PM)
2018-Jan-02 12:19:23 AM
2018-Feb-13 02:19:02 PM
MTTR:
Time Down in Days
(Be precise)
Enter current date here.
Note about Being Precise: If your
component was down for 30 minutes,
you can’t say it was down for 0 days,
or for 1 day, because that’s not
accurate.
Time Down in Hours
(=Time Down in Days*24)
Time Down Time Down in
in Minutes
Seconds
(=Hours*60) (=Minutes*60)