Build Excel or Access data tool - repost


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: Business Analysis, Data Processing, Excel, Microsoft Access

See more: excel spreadsheet rent, data dimensions, 12 month spreadsheet, property information sheet, survey paper, excel to access, build a survey, excel property, survey summary need, access summary, access rates, survey data spreadsheet, excel print sheet, jan 2014, paper survey, property excel, excel contain, access tool, print excel, access data, survey excel access, access excel data, survey excel, property rentals, garage rent

About the Employer:
( 0 reviews ) ganj basoda, India

Project ID: #5352235

4 freelancers are bidding on average $236 for this job


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)

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)

A proposal has not yet been provided

$347 USD in 36 days
(0 Reviews)

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)