Data Analysis of Large Spreadsheet
$250-750 USD
Pago na entrega
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!
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?
ID do Projeto: #4503109
Sobre o projeto
Concedido a:
33 freelancers estão ofertando em média $439 nesse trabalho
Such jobs are my daily practice. In my approach you'll have opportunity to consult details with me, to test pilot solutions if necessary in order to achieve an optimal final solution. Further use of macros (if any), fi Mais
I can help in your project, please check PMB and our ratings/reviews to get idea of our experience. Please let me know if you have any queries.
An experienced Statistician with sound experience in STATA, SPSS, EVIEWS, R, Excel and have worked on many similar projects and have the expertise to complete the project.
Hello, I have had a detailed look into your document and your analysis requirements. I work as a Data Analyst and can definitely do the work for you. I am detailing the work to be done in a message to you. -- Thank you Mais
Hi, as management accountant at a german IT company (see my resume), it is my core business to analyze data and extract valuable business information from it. Therefore, I´m the perfect match for your project. Furtherm Mais
Dear Stray angel, I am a professional statistician with 8 years + of data analysis experience. I provide bussiness solutions with evidence based decision.
I am a US based consultant with immediate availability to work on your project. I look forward to working with you on this project. Please see PM for Details regards, Paranos.
I have commendable skills data in analysis. I have the best abilities to do they work in good time.