Need a GOOGLE DOC / EXCEL Market Analysis Tool

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.

( 3 reviews ) Cape Coral, United States

Project ID: #18797453

Awarded to:

aubrey03

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] More

\$35 USD in 1 day
(79 Reviews)
5.4

13 freelancers are bidding on average \$25 for this job

ksriniravi

Greetings! I have reviewed the requirements and the attachment (USED CAR MARKET ANAYSIS [login to view URL]). I can update the tool to include the reports as described. Being a full time freelancer working exclusively on E More

\$35 USD in 1 day
(159 Reviews)
6.6
avennhossain

Hello dear, I have a [login to view URL] team member 10 person. My team is always active for work. If you give me a chance and give direction for the job, I will do this. Regard's Blood Freelancer Team

\$25 USD in 1 day
(9 Reviews)
4.3
Capitan0Trueno

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 advanc More

\$75 USD in 3 days
(24 Reviews)
4.4
Sondhan65

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.

\$14 USD in 1 day
(1 Review)
1.1
freelancer4100r

Hi there, Greetings for the day! I have gone through your requirement of "Creating Market Analysis Tool" I have more than 12+ yrs of experience in Reporting and Data analysis, Pivot tables, Pivot charts using More

\$30 USD in 2 days
(1 Review)
0.3

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 More

\$10 USD in 1 day
(0 Reviews)
0.9
alexaandr956

Hi my name isAlexa i can handle this project 8 Years Experience Work it will cost u 15\$ almost 1 Days Have A Nice Day Thanks

\$25 USD in 1 day
(0 Reviews)
0.0
IvanLWL

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 More

\$18 USD in 3 days
(0 Reviews)
0.0
Poorvi17

I have full knowledge of Ms. Excel and have understood the project clearly. Kindly consider the proposal.

\$25 USD in 1 day
(0 Reviews)
0.0
MohamedLotfy886

I can help you with this issue and make a trend of sales from largest to [login to view URL] highlight the most selled ones and other issues after the agreemnent is done.

\$11 USD in 1 day
(0 Reviews)
0.0
Ndiranguish

i have been doing this for over years i would love to change your life as you change mine am an experience am looking forward to work for you

\$15 USD in 1 day
(0 Reviews)
0.0
shafivlm

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.

\$10 USD in 1 day
(0 Reviews)
0.0