Lukket

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)

Evner: Excel, Dataindførsel, Databehandling

Se mere: 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

Om arbejdsgiveren:
( 0 bedømmelser ) Toronto, Canada

Projekt ID: #20885052

45 freelancere byder i gennemsnit $201 på dette job

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 Flere

$250 USD in 2 dage
(712 bedømmelser)
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 Flere

$250 USD in 2 dage
(86 bedømmelser)
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 in 3 dage
(150 bedømmelser)
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 Flere

$210 USD in 7 dage
(94 bedømmelser)
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 in 2 dage
(105 bedømmelser)
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 in 7 dage
(17 bedømmelser)
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 Flere

$200 USD in 5 dage
(50 bedømmelser)
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 in 3 dage
(39 bedømmelser)
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 på 1 dag
(136 bedømmelser)
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 Flere

$250 USD in 2 dage
(29 bedømmelser)
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 Flere

$225 USD in 7 dage
(25 bedømmelser)
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 in 3 dage
(19 bedømmelser)
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/ Flere

$170 USD in 2 dage
(37 bedømmelser)
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 Flere

$200 USD in 3 dage
(31 bedømmelser)
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 in 3 dage
(8 bedømmelser)
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 Flere

$175 USD in 2 dage
(10 bedømmelser)
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 in 8 dage
(7 bedømmelser)
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 Flere

$210 USD in 4 dage
(15 bedømmelser)
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 Flere

$170 USD på 1 dag
(18 bedømmelser)
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 Flere

$170 USD in 3 dage
(5 bedømmelser)
3.0