I have database in Excel that I need to analyze to generate three report list. The data is a list of Vehicles sold in a given market and it captures the Year Make, Model and Trim Level(MMT) for each sale. From this data I need to generate three list. First one is a volume list calculating how many units were sold for each make, model and trim. This list would be sorted by Volume with the largest volume in the TOP ROW (after headers obviously) and the lowest one at the bottom. The second report would be a list of the average time it takes to sell each vehicle on thst list. This would be done by adding up they days it took to sell each unit and dividing by the number of units sold from the first list. This list would be sorted from Lowest Average days sold to highest. The only caveat is this, when calculating average days sold the Formula should include an IF/THEN rule. IF Volume Sold# < 3 THEN AVERAGE AGE = ((Total days on market for all vehicles sold in that MMT divided by Volume SOld for tht MMT)+15days))
Once both list are generated, a value will be assign to each MMT based on its' ROW position on each list. The over all rankings will be determined by adding the ROW position for volume to the ROW position of Average days to sell. For example, a vehicle that sold 10 units and placed 20th on the Volume List and sold in an average of 37.24 days and placed 29th on the Average Turn List would get 49 Points for overall ranking, and a vehicle that sold 6 units and placed 40 th on Volume but sold in 18 days on average placing 7th on the list would get a 47 rating and be ahead of the one that did more volume.
To adjust for lack of data any vehicles showing less than 3 sales get an automatic 20 day add to there Average Days to sell. The goal is to create a Sheet that I can drop raw data into and have it automativcally create the Pivot table or databases to generate said output instantly/ The attached Excell SHeet has Two Datasets label RAW data. 1 is for Honda Dealers only (this will change depending on brand we are analysing) Second Data set in the entire market. Though this data set is small the formulas should be set up to allow me to drop in Raw data up to 50,000 records deep or as large as possible. Once you've set up the spreadsheet tool todo the calculations for the Direct competitor it is basically just a copy paste exercise to replicate the analysis for the Entire Market data set. Time is of the essence on the and I am hoping it is something that can be completed in a few hours by an experience database programer.
I am an Excel and VBA specialist with a lot of experience in creating complex automation tools, formulas, databases, queries and macros.
You may check some of my projects here: [login to view URL]
$35 USD en 1 día
4,8 (79 comentarios)
5,4
5,4
13 freelancers están ofertando un promedio de $25 USD por este trabajo
MS Excel advanced expert. 30 years experience in MS Excel. VBA programming. Data mining and analysis, stochastic simulation, discrete event simulation, Excel Solver, genetic algorithms, neural networks and other advanced models. I have a high performance desktop computer with which I can deal with extremely large and complex worksheets.
HI, MYSELF Sondhan. I AM AN EXCEL EXPERT. I AM EFFICIENT IN MICROSOFT OFFICE TOOLS AND ALSO EXPERIENCE IN RESEARCH, CATEGORIZING ITEMS, PROOFREADING ETC. I CAN WORK ON ANY KIND OF EXCEL WORK.
I am student of MSc. Mechatronics and Control engineering. My typing speed is very good. I will give you best service just give me a chance, I will prove my talent.
I will provide you a quality work at very low price because I need review for starting work.
I am working in PEPSI Cola international and have three years of experience in Google spreadsheets, Microsoft excel and other Microsoft office tools like Powerpoint, word and publisher as well.
What I can do for you:
Excel Formulas from simple to complex
Excel Data entry
Custom Formulas
Fixing your data
Crush Duplicates
Excel Dashboards
VLOOKUP & HLOOKUP
Pivot tables and charts
Macros
Conditional formatting
PDF to Excel
Regression
Excel Modelling
Scenario Manager
Goal seek
Anything else that you need in excel
I have enormous skills in excel. I can give this data analysis for free. But this website won't allow it. This is just kid's play. I can help you. Just Give me good review instead.