Build Excel or Access data tool
$30-250 USD
Paid on delivery
I need an Excel spreadsheet or Access DB tool developed to do the following:
See the attached example spreadsheet.
This is a survey that is updated approximately every 6 months. The new sheet needs to track and maintain data collected from every survey. (ie. each spreadsheet will contain the data from Jan-14, July-13, Jan-13, July-12, Jan-12, etc.)
• The spreadsheet will produce a summary of compiled data including:
• Total # of units for each time period.
• Average # of units compared to number of properties.
• Total # of units by type.
• Average # of units by type.
• Average square feet by unit type.
• Average rent per month by type.
• Mean rent per month by type.
• Range of rent per month by type.
• Change in rent per month by property over time. (ie. the tool will track the difference from each time period to the next)
• Rent per month by identified property. (ie. the tool will track rent per month for individual properties)
• Change in average rent per month by type over time. (ie. the tool will track the difference from each time period to the next)
• Total rent per month by type over time. (ie. the tool will track the average rent per month and mean rent per month over time)
• Change in garage rent over time. (ie. the tool will track the same information above for garage rentals)
• Change in current occupancy. (ie. the tool will track the property and average occupancy rates over time)
The tool should be appropriate dimensions to print out on 8.5” x 11” paper.
Project ID: #5352031
About the project
25 freelancers are bidding on average $197 for this job
PMP, MBA and professional business analyst here. Proficient at building Excel templates and data analysis.
Hi Edulaunchpad. I have looked at the sample sheet and I can calculate all the required data that you have mentioned. Prior to offering me the project, kindly discuss via message. Regards. Usman.
Hi, Let me introduce myself as an expert in MS Access programming. I have worked extensively on MS Access 97,2000, 2003, 2007,2010 projects both big and small using MS Access as a front end as well as back end. I More
I am ready to do the job for you and hopefully I can do it nicely with very good quality of output in time.
Salam! Consider your work done with perfection. I am chartered accountant as well as big Excel VBA expert. Thank you
Hi, I have been developing applications in both Access and Excel for 20 years with extensive use of VBA. I have developed several applications for Freelance clients, please see Feedback and examples in Portfolio More
Dear Sir, I'm Expert at access i've done survey db before, and i'm interested on doing your project with the best offer and the best support after complete the project. Kind Regards, NourElDeen
Hi, I have lots of experience in Excel and macros and can help you quickly in this task. Can you write me a private message to confirm details. Thanks.
Hi Sir, I am ready to work for you.I have 4 years of experience in C#. please see some of my works also check my reviews you will get better idea about my skill.I deliver quality work within time frame. Please visit More