Đã Đóng

Need data from 2 Excel files merged and then the results scrubbed

I have two excel files with data (2018 & 2019). The file format is a single line for every incoming call received in 2018 and 2019. Each line indicated the amount of time the call lasted (handle time) and whether the call was "connected" or "abandoned". I need the data converted to show the total # of calls (line items) which arrived and for every 15 minute interval and then the average handle time for each interval (this will require averaging the "handle time" column for each of the rows within the 15 minute interval. Also would need the total number of "abandoned" calls for each interval.

In addition I would need to have an additional 15 seconds added to the "handle time" for each line item. AFTER the 15 seconds are added, then you would average the resulting "handle time" for the interval.

As mentioned, I have one file for 2018 (57,398 lines of data) and another file for 2019 (52,537 lines of data)

Kĩ năng: Excel, Nhập liệu, Xử lí dữ liệu

Xem nhiều hơn: fetch data excel files, combine data excel files, search data several excel files, merge excel files remove data, excel data completing pdf files, merge excel files common data, import data excel multiple excel files worksheet, grab data multiple excel files, data filling excel files, excel need data internet, comparing excel files share data, import data closed excel files vba, compare data excel files, compare excel files data generate sheet, comparing excel files data report code vb, data entry jobs excel files, find common data excel files, find data difference excel files, need data scraped pdf files

Về Bên Thuê:
( 0 nhận xét ) Toronto, Canada

ID dự án: #20885052

45 freelancer đang chào giá trung bình $201 cho công việc này

jaylancer43

Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I'm an Expert Excel and VBA programmer on freelancer.com and have been featured by the freelancer community (g Thêm

$250 USD trong 2 ngày
(712 Nhận xét)
8.5
ujjwalmalik

Hi There, I am an advanced excel specialist. I have understood the requirements. Can you please send me both the spreadsheet via chat and I will do the process for the first 10 Lines FREE OF COST as a sample to ensure Thêm

$250 USD trong 2 ngày
(86 Nhận xét)
7.2
asadkhan3533

Please review my profile as i have relevant skills and experience required for this project. Kindly send me a message to discuss further. Thanks, Asad Khan

$210 USD trong 3 ngày
(150 Nhận xét)
6.5
polarjin2017

Hello? Nice to meet you. I am excited to work with you on this project. I am ready to start work immediately. This is what i have done in Excel/Word/PPT/Access/VBA/MACRO. Just Creating forms, query, Macro, custom formu Thêm

$210 USD trong 7 ngày
(94 Nhận xét)
6.7
periyannas

Hi, Nice to know your requirement. I am an excel vba, vb6 professional and have delivered over hundred excel vba projects in the last one year. Willing to take up your project. Thank you, Regards.

$210 USD trong 2 ngày
(105 Nhận xét)
6.2
ftp2012

can you show an example of information ?. I can make a script to sort the information and add the required number of seconds

$210 USD trong 7 ngày
(17 Nhận xét)
6.1
dvcontact

Hi, Reading your project description about merging data of two Excel files and performing some calculations on it to find the total number of abandoned calls for each interval and other parameters makes me feel like yo Thêm

$200 USD trong 5 ngày
(50 Nhận xét)
6.3
hdlan

Hello, I can help to merge your Excel files according your guideline. Let’s discuss if you’re interested. Best regards, Duong

$170 USD trong 3 ngày
(39 Nhận xét)
6.3
mtdevil369

I'm very much interested to help you working on this task you having right now. I'm capable to start work it today and complete in any time your required it. Message me now here. thanks!

$170 USD trong 1 ngày
(136 Nhận xét)
6.0
bhupendrayadav

I am postgraduate with more than 5 years of experience in advanced excel based tools, VBA automation, google scripting and data processing. I have successfully completed similar projects, please have a look at my port Thêm

$250 USD trong 2 ngày
(29 Nhận xét)
4.9
supergana

Hi - The challenge is the size of the file which novice developers will mostly oversee. What is the size of file you have and does it open without issues under normal circumstances. If you are not able to open and perf Thêm

$225 USD trong 7 ngày
(25 Nhận xét)
4.8
usmnwaraich

Hello there, I have read your project descriptions and can do the work. Please come to chat and have discussion in details about your work. Looking forward, Thanks~

$250 USD trong 3 ngày
(19 Nhận xét)
4.7
Ahmed818

Hello, i am expert in this kind of jobs samples of my excel VBA jobs https://www.freelancer.com/projects/excel/Create-Excel-Spreadsheet-Macro-that/ https://www.freelancer.com/projects/excel/Make-VBA-code-run-itself/ Thêm

$170 USD trong 2 ngày
(37 Nhận xét)
4.1
paulodayto08

Hi Good Day! A serious freelancer here. I want to help you with this. Can you share to me your file? I will check if I can create a formula or codes to do it quickly. Please consider my bid. I've done a lot of Repor Thêm

$200 USD trong 3 ngày
(31 Nhận xét)
4.3
umairabdillah12

Hi There, I can help you to merged excel file and make the results, i have read your description, i have many experience using excel formulas over 10 years, please kindly check my profile. thanks. regards.

$170 USD trong 3 ngày
(8 Nhận xét)
4.4
sambestsolutions

Hi I am a devops engineer experenced with java,php,python and vba excel macro for more than 5 years. I can create you script or excel vba macro to merge 2 excel files show total number of calls for every 15 minutes in Thêm

$175 USD trong 2 ngày
(10 Nhận xét)
3.6
Prompty

Hi, presume your call data is in EXCEL or CSV format. If so, my experience in EXCEL will be useful to do this aggregation.

$220 USD trong 8 ngày
(7 Nhận xét)
3.7
ragulnishanth

i there, I like to be considered for your hire position. I’m a strategic freelancer with strong background expert in Office 365, including data entry, social media post, photoshop, animations, and digital marketing wo Thêm

$210 USD trong 4 ngày
(15 Nhận xét)
3.6
AnowarRatul

$ 170 ONLY!!! In just 12 HOURS!! [EXCEL VBA MACRO & FORMULA EXPERT] <<<100% SATISFACTION first, then PAYMENT>>> Sir, please CONTACT with me, I can complete your PROJECT absolutely as per your requirements within LEAS Thêm

$170 USD trong 1 ngày
(18 Nhận xét)
3.4
dungforever

hello how are you? i have read your project description carefully and i am so interested in your project . i hope to work for you with this data entryproject as a good data entry expert I am a good excel macro and py Thêm

$170 USD trong 3 ngày
(5 Nhận xét)
3.0