Closed

Build Excel or Access data tool - repost

This project received 4 bids from talented freelancers with an average bid price of $236 USD.

Get free quotes for a project like this
Employer working
Project Budget
$30 - $250 USD
Total Bids
4
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.

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online