Đã hoàn thành

excel-big data matching-consolidation-reporting

Dear all,

I am Christos from Greece.

I get the attached excel (spreadsheet: data) every week.

Its flights data (flight permissions and sales).

I need a <<software>> to do the following :

1)First match all same flights data sources.

This means:

• same OERATION DATE (column B)

• same OPIATACODE (column K)

• same FLIGHT NB (column S)

Note that there can only be one flight with same date/code/NB.

2)When this is done you will see that most flights have two possible SOURCE SYSTEM in column M (INNOVATA and EUACA).

3)Ignore flights that have only INNOVATA in SOURCE SYSTEM ( column M).

4)Flights with EUACA in column M should be filled in a spreadsheet named POSSIBLE NOSHOWS (AS IN THE ATTACHED FILE).

• Column A (airport) should be filled with the 4 letter code in ADEP (column E) if AD (column L) is D and with the four letter code in ADES (column F) if AD (column D) is A.

• Column B (date ) is filled by column B (operation date)

• Column C (airline) is filled by column K (OPIATACODE)

• Column D is filled by column S (FLIGHTNB)

• Column E is filled by column L (AD)

• Column F is filled by column F when column L is D and by column E when column L is A

• Column G is filled by column I (ACTYPE iD)

• Column H is filled from column G when column L is D and column H when column L is A

5)Flights that have both INNOVATA and EUACA in column M should consolidate.

Here we are looking for differences for times and aircraft type between data sources for the same flight.

So we need two different spreadsheets for each type of differences (Aircraft and Times)

6) For Aircraft Differences we fill AC Discrepancies spreadsheet:

• For columns A-F we repeat the previous steps

• Column G is filled from column I but from EUACA row

• Column H is filled from column I but from INNOVATA row

7)For Time differences we fill Time discrepancies spreadsheet:

• For columns A-F we repeat the previous steps

• Column G is filled from column G if column L is D but from EUACA row

• Column G is filled from column H if column L is A but from EUACA row

• Column H is filled from Column G if column L is D but from INNOVATA row

• Column H is filled from column H if column L is A but from INNOVATA row

Note that for aircraft and time differences we ignore all flights with no differencies.

8)Finally (probably you will use it earlier) we replace all 4 letter codes from columns E and F with the Matching 3 letter codes from airports spreadsheet.

9)Note that files are quite big (more than 100.000 rows) and the system should not crash

Kĩ năng: Excel VBA, Excel Macros, Xử lí dữ liệu

Xem nhiều hơn: excel macro data cell, excel large data files, free microsoft excel customer data entry, consolidate duplicates in excel, excel consolidate rows, how to automate consolidation in excel, how to consolidate data in excel from multiple worksheets, how to consolidate data in excel from multiple workbooks, no data was consolidated, what is data consolidation in excel, excel consolidate text, excel 2003 data import mysql, excel macro data consolidation, excel macro data matching, data matching excel sheet, data matching excel, excel align columns matching data, advanced data matching excel skills, excel performance data reporting, analysis vs reporting in big data

Về Bên Thuê:
( 2 nhận xét ) athens, Greece

ID dự án: #23634816

Được trao cho:

trustworthy0

Hello. Christos I have gone through your posting. As a Excellent Data Scientist, I am so interested in you job posting and I wanna recommend you to use Python for big Data. With confidence, I can do it in a day with be Thêm

€30 EUR trong 1 ngày
(3 Đánh Giá)
3.0

16 freelancer đang chào giá trung bình €113 cho công việc này

prameswara

Hello Sir Im excel VBA macro and formula Expert :) i can help you to build VBA macro for matching-consolidation-reporting in your big excel file please ping me now and im free now Thank you Galih

€100 EUR trong 7 ngày
(206 Nhận xét)
6.8
datakillers

"I have good Microsoft Excel skills with years of experience as well as I have complete number of projects for Excel to manage data and sorting.I am Alison certified for Microsoft Office and Microsoft Excel. Therefore Thêm

€250 EUR trong 7 ngày
(117 Nhận xét)
6.2
rashedkhanrubel

Hi, I have understand the project requirement & interested to work for this project. I will start right now. Please send a message so we can discuss more & start the project. Thanks.

€100 EUR trong 1 ngày
(79 Nhận xét)
5.4
mateenbhatti94

Hi christos I have read the requirements and completely understand the project. I have been in this industry for 1 year and such jobs are my daily practice. I can assure you that if you work with me once, you will alw Thêm

€150 EUR trong 1 ngày
(34 Nhận xét)
5.6
sunshine7677

Dear Client, I can do this Project and ready to start the work right away. I have 5+ Years of Experience in EXCEL (VBA and MACROS), Web Scrapping (Python, Octoparse, Parsehub,Selenium and Beautifulsoup), Data Entry, P Thêm

€30 EUR trong 1 ngày
(30 Nhận xét)
4.8
finecodervw

Hi, Keen to work on this project. Please suggest suitable time to discuss further. Let me introduce myself as an expert VBA programmer. I have used VBA extensively for Excel, MS Word, MS PowerPoint, MS Outlook automa Thêm

€90 EUR trong 5 ngày
(12 Nhận xét)
4.6
seoguru17

I am good at Excel formula and VBA/Macro, I need to see the data so I can understand your requirement, I have a few question to discuss so I need you to send a message on chat.

€140 EUR trong 7 ngày
(16 Nhận xét)
4.3
ravinderkumar248

Hi Good Day, I can do this immediate after you accept my bid I am an Excel and VBA specialist with a lot of experience in creating complex automation tools, formulas, databases, queries and [login to view URL] give me this o Thêm

€90 EUR trong 3 ngày
(11 Nhận xét)
3.9
solarqw

Hi, I am a programmer good at software building. I can help to handle the flights data quickly and professionally. The system will run smoothly even if there are more than 100.000 rows. I am ready to work now.

€140 EUR trong 7 ngày
(3 Nhận xét)
2.5
MykolaDudych

Hello :) I am interested in your offer and I am ready to cooperate. I have experience in writing macros VBA for Excel and creating programs for processing information from Excel files. I'm ready to start doing your ass Thêm

€30 EUR trong 3 ngày
(2 Nhận xét)
2.3
kozachenkodr

Dear client. I have read your job very carefully, then I am really interested in your job. I am very well experienced in big excel processing with python fast algorithm. Please ping me to discuss more, I will give you Thêm

€140 EUR trong 7 ngày
(1 Nhận xét)
1.3
ginushaji3

i can give you software using [login to view URL] me for further discussions please............................... regards Ginu

€200 EUR trong 7 ngày
(1 Nhận xét)
0.0
adminasaanise

Dear Sir, i Have strong skills in MS Excel Advance along with Macros and VBA , Power BI and SQL Databases i can do your task in reasonable price and in given time line kindly award me the bid so that i can complete yo Thêm

€88 EUR trong 5 ngày
(0 Nhận xét)
0.0
mustitech

greetings for the day, this is mustakim.i have gone through your project and requirement. i can understand the project and complete it. i can remove the duplicate entries from the [login to view URL] i am Expert in Excel. i Thêm

€88 EUR trong 5 ngày
(0 Nhận xét)
0.0
€144 EUR trong 3 ngày
(0 Nhận xét)
0.0