Hi all,
I am trying to copy a spreadsheet created by a Excel genius who is no longer around to help me.
Basically it is a utilization spreadsheet that tracks services for a massage operation. In the Grand Total area he set up a "service" column, "rooms/day" column and a "staff" column.
I was able to figure out how we got rooms/day (for example =A$1*$A$1 where A$1 is the number of rooms available and $A$1 is the number of days in a given month) but the formula for the staff column is giving me a headache. Its format is ='1'!A1+'2'!A2+and so on until '31'!A1 for 31 days in the month. Is this a statistical function because clearly one does not enter in this formula. Thank you to anyone who can help or point me in the right direction!
I am trying to copy a spreadsheet created by a Excel genius who is no longer around to help me.
Basically it is a utilization spreadsheet that tracks services for a massage operation. In the Grand Total area he set up a "service" column, "rooms/day" column and a "staff" column.
I was able to figure out how we got rooms/day (for example =A$1*$A$1 where A$1 is the number of rooms available and $A$1 is the number of days in a given month) but the formula for the staff column is giving me a headache. Its format is ='1'!A1+'2'!A2+and so on until '31'!A1 for 31 days in the month. Is this a statistical function because clearly one does not enter in this formula. Thank you to anyone who can help or point me in the right direction!