# 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.

Về Bên Thuê:
( 3 nhận xét ) Cape Coral, United States

ID dự án: #18797453

## Được trao cho:

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] Thêm

\$35 USD trong 1 ngày
(79 Đánh Giá)
5.4

## 13 freelancer đang chào giá trung bình \$25 cho công việc này

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 Thêm

\$35 USD trong 1 ngày
(159 Nhận xét)
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 trong 1 ngày
(9 Nhận xét)
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 Thêm

\$75 USD trong 3 ngày
(24 Nhận xét)
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 trong 1 ngày
(1 Nhận xét)
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 Thêm

\$30 USD trong 2 ngày
(1 Nhận xét)
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 Thêm

\$10 USD trong 1 ngày
(0 Nhận xét)
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 trong 1 ngày
(0 Nhận xét)
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 Thêm

\$18 USD trong 3 ngày
(0 Nhận xét)
0.0
Poorvi17

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

\$25 USD trong 1 ngày
(0 Nhận xét)
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 trong 1 ngày
(0 Nhận xét)
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 trong 1 ngày
(0 Nhận xét)
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 trong 1 ngày
(0 Nhận xét)
0.0