Fermé

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)

Compétences : Excel, Saisie de Données, Traitement de Données

en voir plus : 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

Concernant l'employeur :
( 0 commentaires ) Toronto, Canada

Nº du projet : #20885052

45 freelance font une offre moyenne de $201 pour ce travail

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(712 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(86 Commentaires)
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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(150 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(94 Commentaires)
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.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(105 Commentaires)
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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(17 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(50 Commentaires)
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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(39 Commentaires)
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!

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(136 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(29 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(25 Commentaires)
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~

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(19 Commentaires)
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/ Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(37 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(31 Commentaires)
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.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(8 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(10 Commentaires)
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.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 8 jours
(7 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 4 jours
(15 Commentaires)
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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(18 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(5 Commentaires)
3.0