How do you customize calendar view
2 answers:
You might be interested in
Answer:
Explanation:
Known Variables A = max Daily Rentals
X = Damaged helmets %
lets find the formula to calculate Helmets per location :taking 1st row as an example.
412 = B - (B*13/100)
412 = (100B-13B)/100
412*100 = 87B
B= 412*100/87
Hence, the generic formula becomes : B= A*100/(100-X)
Applying the same formula for each row and then using ROUND function of excel to round off the digits
=ROUND(number,digits) where number is the number you would like to round off and the digits is the number of decimal digits for it to round off. Since we want natural numbers in our example, we will be using digits as 0.
Explanation:
See attached pictures also.
