Building chart from data- on excel or another user friendly application

Đã hoàn thành Đã đăng vào 6 năm trước Thanh toán khi bàn giao
Đã hoàn thành Thanh toán khi bàn giao

Hello! We are providing analytic services to worldwide exhibition centers. They have yearly 4 campaigns. It takes around 20 days. Our task is to measure how these dates affect the number of visitors. We have historical 5-10 years data. Let me describe you how we creating chart manually right now.

Assuming that we have 6 years daily numbers and 24 (4x6years) campaign dates ( date-last date of campaign/offer)

1. Manually finding and marking 24 campaign dates on historical data file ( excel).

2. Selecting last 20 days of the campaign on every season ( 4 column data per year ) & copy to a new tab.

[login to view URL] the average number of visitors on last 20 days.

4. Finding the number of deflection-lapse from average on every last 20 day.

5. Applying these to whole last 6 years and finding the average deflection-total 24 column.

6. According to the data creating excel chart.

Please see the attached sample step by step.

We will need data by season, and last 20 days also may change. Please make is variable.

Our final goal to see the visual excel chart.

What I need is macros or basic application, when I give raw data and dates on 1st step to get final chart on step 6

Dear All, It seems attachment is not visible, I had attached again.
Additionally, I had uploaded one sample raw date for you to work on it provide me the final chart to award the winner.
Thank You.

Dear all, thank you for time. I had very little correct feedback. tomorrow morning ( GMT + 4 ) I will award the winner. Thank you your patientce

Charts Data Analytics Xử lí dữ liệu Excel Excel Macros

ID dự án: #15981704

Về dự án

19 đề xuất Dự án từ xa 6 năm trước đang mở

Được trao cho:

DataHome

Hello there Excel experts here with 10 years track records. I didnt see any attachment on the project Can you re-send here ? By the look of your requirement, I hope i can do it for low cost Waiting.. Amaan

$120 USD trong 1 ngày
(43 Đánh Giá)
8.1

19 freelancer chào giá trung bình$137 cho công việc này

jaylancer43

Hello Sir, My name is Jay and I am an Expert Techno-Functional Analyst having vast experience in lots of arenas of IT industry including Excel Macros and Formulas. I am an Engineering Graduate with an MBA degree. If Thêm

$210 USD trong 3 ngày
(606 Nhận xét)
8.3
TonmoyRoy111

Dear client, I have sound knowledge in Excel and I have previously carried out a number of projects in excel using macros and formulas. I ensure you will be happy after hiring me. Roy

$150 USD trong 3 ngày
(255 Nhận xét)
6.4
caabdul

Hi there, consider the job done with perfection. Thanks

$40 USD trong 10 ngày
(54 Nhận xét)
5.9
sonarkaushik

I am very able to create this chart and ready to start

$156 USD trong 3 ngày
(52 Nhận xét)
5.8
zu02

Hello, sir I saw your project and analyze your requirements. I like such kind of tasks and I know how to code this as I already dealt with similar problems in my career before. I am senior Access/SQL/VB /Excel de Thêm

$250 USD trong 5 ngày
(18 Nhận xét)
5.3
khudammunir

Hi I would like to bid for this project. I posses Data Analytics, Research, Accountancy, Administration, Banking, Financial/Business Analysis & Reporting and Content Writing experience with Advance MS Excel Dashboards, Thêm

$120 USD trong 2 ngày
(22 Nhận xét)
5.0
lamyae88sid

A proposal has not yet been provided

$166 USD trong 3 ngày
(24 Nhận xét)
5.1
rajafaizan

Hi, I read project detail very carefully and i have good command on MS Office like (Excel, Word, VBA, Macro, visual Chat, pivot table). I will create data analysis report and chart as per your requirement. Let's cha Thêm

$183 USD trong 4 ngày
(30 Nhận xét)
4.5
Ashisjena2015

Hi, I am an expert in advanced excel. So, I will help you on this project. Please discuss in detail now. Price= $100 Time=Immediate

$100 USD trong 0 ngày
(24 Nhận xét)
4.5
adgotmare

I would like to do your project, expert in multivariate modelling of data, expert in SPSS , Stata and excel

$155 USD trong 3 ngày
(14 Nhận xét)
4.0
infotechjpm

Hello, We have put a glance to your job details and we are quite interested to do this job. Let us tell about our experience. Since last 6 years we are in graphics design profession. I have more than 6 years ex Thêm

$250 USD trong 5 ngày
(0 Nhận xét)
0.0