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)

Beceriler: Excel, Veri Girişi, Veri İşleme

Daha fazlasını gör: 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

İşveren Hakkında:
( 0 değerlendirme ) Toronto, Canada

Proje NO: #20885052

Bu iş için 45 freelancer ortalamada $201 teklif veriyor


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 Daha Fazla

$250 USD in 2 gün içinde
(712 Değerlendirme)

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 Daha Fazla

$250 USD in 2 gün içinde
(86 Değerlendirme)

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 gün içinde
(150 Değerlendirme)

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 Daha Fazla

$210 USD in 7 gün içinde
(94 Değerlendirme)

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 gün içinde
(105 Değerlendirme)

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 gün içinde
(17 Değerlendirme)

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 Daha Fazla

$200 USD in 5 gün içinde
(50 Değerlendirme)

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 gün içinde
(39 Değerlendirme)

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!

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(136 Değerlendirme)

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 Daha Fazla

$250 USD in 2 gün içinde
(29 Değerlendirme)

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 Daha Fazla

$225 USD in 7 gün içinde
(25 Değerlendirme)

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 gün içinde
(19 Değerlendirme)

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/ Daha Fazla

$170 USD in 2 gün içinde
(37 Değerlendirme)

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 Daha Fazla

$200 USD in 3 gün içinde
(31 Değerlendirme)

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 gün içinde
(8 Değerlendirme)

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 Daha Fazla

$175 USD in 2 gün içinde
(10 Değerlendirme)

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 gün içinde
(7 Değerlendirme)

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 Daha Fazla

$210 USD in 4 gün içinde
(15 Değerlendirme)

$ 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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(18 Değerlendirme)

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 Daha Fazla

$170 USD in 3 gün içinde
(5 Değerlendirme)