Create formulas for Excel
$250-750 USD
Paid on delivery
Hello,
Please look at attached file. This is a regular excel file where we keep statistics on our business.
So we have a house that have "X" number of people and we need to know:
1. The percentage of occupancy for any given month . For example, lets say we have total available beds 15. If all of them are occupied for the month of January, it will be 15 people X 31 days = 465 nights total available for the month of January. However, lets assume that only 75 nights were occupied, so we need the formula to figure out the percentage of occupancy.
The start date of rental and the end date of rental are in the columns "F" and "G". Also, the column "J" should calculate the number of days each person was in the room.
2. We need a table where we can put in the variables to generate that report:
1. Total number of beds available:
2. Month
So by inputting this data, the excel must produce the result - % of occupied beds that month.
Project ID: #16740223
About the project
Awarded to:
Hello, I’m an Excel expert and I would like to help you with your project. I'm fully available and I can start right away. Please check my profile and contact me to discuss. Regards.
12 freelancers are bidding on average $354 for this job
Hi there..... Warm Greetings We came along with your request for Create formulas for Excel and we reviewed your project description. We'd like to help you with confidence and satisfying results... We have pro More
Hi, Your work is very matched with me, I will complete your job with lowest of cost and higest responsibility. Pls message me to discuss more, Thanks Emamul H.
Hi, I'm an advanced excel expert. Please discuss in detail over chat now. Thank you!........................................................
Hi Dear. I read your proposal and understood your idea. I am a Data Entry expert. So I can create your formulas (VBA) perfectly. I hope to work with you. Thanks for your attention.
Hello We are a team of professionals, we can provide you with the best solution to your needs. Looking forward to hear from you.