Question: For row value names shown in column A , the formulas and functions for columns B , C and D are as follows. a .
For row value names shown in column the formulas and functions for columns and are as follows.
a Date is first day of month in MDY format eg Remember to format the date to match the
image. Calculate C and D from B using Excel functions. In the image, the date is in the MMMYY format, and
the day of the month should be
wh
b Total Minutes is a formula that shows the total minutes in the month. Consider using DAY and EOMONTH. Hint:
Formatting as generalnumber will be important.
c Maintenance Minutes is hours each Saturday. Calculate number of Saturdays in a month using this formula
WEEKDAYB Hint: Formatting as generalnumber will be important.
d Code Release Minutes is a fixed value. Enter in the cell what is shown in the uptime image.
e Total Planned Availability in MInutes is a formula that represents the total minutes minus any maintenance and
code release minutes.
f Unplanned Downtime in Minutes is a fixed value. Enter in the cell what is shown in the image.
g Total Availability. is a formula that subtracts the total planned availability from the downtime minutes.
h Uptime is a formula that compares the total availability to the total planned availabilty. Represent as a
percentage with digits to the right of the decimal.
what is the formulas that i input for question h uptime
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
