Data Analysis of Large Spreadsheet

IN PROGRESS
Bids
36
Avg Bid (USD)
$433
Project Budget (USD)
$250 - $750

Project Description:
I run a small equipment rental company and I need to start making some smart decisions in regards to purchasing gear and allocating capital. I have a couple GIANT excel sheets that track every piece of gear I've sent out over the last couple years. They're a little messy but not in terrible shape. I'm going to attach one sample workbook so you can see what we're talking about. One sheet has a "sample vendor" which is another rental house we work with a lot. The other sheet is a "sample consigner" who is a someone who leaves gear with us to rent out for them at a fifty fifty split.

What I would need is someone to go through and tell me what rents the most, what the margins and turnaround time on purchasing the items would be and anything else that can be gleaned from my spreadsheets.

Please let me know what you think could be done with this data, what you would need from me to get the most out of the spreadsheets and what your bid would be. Thanks!

Additional Project Description:
05/08/2013 at 23:16 EDT
I have added another attachment with a third sheet called "data analysis"

There are two major things hat need to happen. The entire workbook needs to be cleaned up a little, a "canon 24-70" is the same as a "canon 24-70mm zoom lens" and the formulas need to recognize that. Please let me know what the best way to do that would be and if that would be included in your bid.

The real big task is the "data analysis" sheet. This should easily update as new data is added to the other sheets and should provide me with some powerful tools for evaluating the spreadsheets. I put the metrics that came to mind easily but I need your input in creating more data points to help me decide which gear to purchase and what to keep subrenting. Unfortunately, it's not going to be as simple as just writing some basic formulas, which I could do myself. One problem that come to mind is that if I only own one Canon 24-70, I can only send it out on one rental at any given time. Any time I have two rentals on the same day for the same product, the second rental shouldn't be factored into any revenue projection. Fun stuff right?

Skills required:
Data Processing, Excel
Additional Files: Sample+Sheet.xlsx Sample+Workbook+with+Data+Analysis+Sheet.xlsx
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.


$ 272
in 7 days
Hire nagybatonyi
$ 333
in 3 days
$ 722
in 7 days
$ 277
in 5 days
$ 333
in 10 days
$ 277
in 3 days
$ 444
in 7 days
$ 277
in 5 days
$ 277
in 5 days
$ 666
in 30 days