Build Excel or Access data tool - repost

CLOSED
Bids
4
Avg Bid (USD)
$236
Project Budget (USD)
$30 - $250

Project Description:
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.

Skills required:
Business Analysis, Data Processing, Excel, Microsoft Access
Qualifications required:
uk_english1 UK English - Level 1
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


$ 257
in 10 days
Hire vlagrome
$ 150
in 3 days
$ 347
in 36 days
$ 188
in 4 days