Build Excel or Access data tool - repost

Closed Posted Jan 23, 2014 Paid on delivery
Closed 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.

Business Analysis Data Processing Excel Microsoft Access

Project ID: #5352235

About the project

4 proposals Remote project Active Mar 1, 2014

4 freelancers are bidding on average $236 for this job

gregorybair

Greetings! I am an excel guru and I work with quality, not speed as my goal. I hold a Bachelor of Business Administration degree and a Master of Business Administration degree. Please contact me to discuss specifics. More

$257 USD in 10 days
(117 Reviews)
7.8
abhinovpankaj

Hi, I am working as a Software Engineer from last 3 years. Currently I working on projects solely based on Windows platform and MS office applications specially Excel and VBScripting So,I am good option to go with. More

$188 USD in 4 days
(0 Reviews)
0.0
mihailosundic

A proposal has not yet been provided

$347 USD in 36 days
(0 Reviews)
0.0
vlagrome

I already have a template built out to organize and pivot data for reporting purposes. I have built reporting packages in Excel and Access and can tailor a package to suite your needs. Just let me know what you would l More

$150 USD in 3 days
(0 Reviews)
0.0