Find Jobs
Hire Freelancers

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

$170-250 USD

Imefungwa
Imechapishwa over 4 years ago

$170-250 USD

Kulipwa wakati wa kufikishwa
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)
Kitambulisho cha mradi: 20885052

Kuhusu mradi

41 mapendekezo
Mradi wa mbali
Inatumika 5 yrs ago

Unatafuta kupata pesa?

Faida za kutoa zabuni kwenye Freelancer

Weka bajeti yako na muda uliopangwa
Pata malipo kwa kazi yako
Eleza pendekezo lako
Ni bure kujiandikisha na kutoa zabuni kwa kazi
41 wafanyakazi huru wana zabuni kwa wastani $202 USD kwa kazi hii
Picha ya Mtumiaji
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 ndani ya siku 3
5.0 (745 hakiki)
8.1
8.1
Picha ya Mtumiaji
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 you my expertise for this project. Waiting for your response!
$250 USD ndani ya siku 2
4.9 (100 hakiki)
7.5
7.5
Picha ya Mtumiaji
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 ndani ya siku 2
5.0 (180 hakiki)
6.9
6.9
Picha ya Mtumiaji
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 you have me in mind when creating the project. I have all it takes to deliver. I have vast experience working on similar projects and I am confident I can exceed your expectations. I am passionate about flawless results and I can assure you of a job well done. I’d love to discuss more on what would make this project a success for you. Can we have a quick chat? Thanks for your time.
$200 USD ndani ya siku 5
4.9 (70 hakiki)
6.9
6.9
Picha ya Mtumiaji
$ 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 LEAST time and for LOWEST price. You can see my profile to get overview of what my past employers think about me. I will be very much grateful if I get opportunity to work for you. Thanks, Anowar
$170 USD ndani ya siku 1
5.0 (385 hakiki)
6.8
6.8
Picha ya Mtumiaji
Hello, I can help to merge your Excel files according your guideline. Let’s discuss if you’re interested. Best regards, Duong
$170 USD ndani ya siku 3
4.9 (66 hakiki)
6.6
6.6
Picha ya Mtumiaji
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 ndani ya siku 7
5.0 (29 hakiki)
6.3
6.3
Picha ya Mtumiaji
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 portfolio for details. I have developed excel based automation tools for Ernst and Young also. You can get your work done here with highest quality at lowest price. Looking forward to work with you
$250 USD ndani ya siku 2
4.9 (51 hakiki)
5.9
5.9
Picha ya Mtumiaji
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 ndani ya siku 3
5.0 (38 hakiki)
5.5
5.5
Picha ya Mtumiaji
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 ndani ya siku 3
5.0 (25 hakiki)
5.1
5.1
Picha ya Mtumiaji
Hello Sir, I have gone through your requirement, We can write a script using java programming to produce all your required output from the two files. Please ping me we can start right now. Thanks
$170 USD ndani ya siku 2
5.0 (7 hakiki)
5.1
5.1
Picha ya Mtumiaji
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 Reports and Templates using MS Excel. I can use my expertise in VBA Macro do it quickly and accurately. Message me anytime to discuss. With my experience as a VBA Macro developer for 8 years I can give you the high quality tool that can generate accurate result that you wanted using MS Excel. I am also a Project Management Analyst for 8 years in Accenture which given me the knowledge of creating quality dashboards and financial reports for our Clients. Please message me anytime to discuss more about this project. I am willing to help you out and show you my expertise. Thank you!
$200 USD ndani ya siku 3
4.7 (78 hakiki)
5.4
5.4
Picha ya Mtumiaji
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 work. I can turn an ordinary document in a way that represents the work and appeals to target with knowledge and principles. Whether you need a formal, serious or playful, I can make the work with an excellent outcome. For 5 years I’ve worked in Excel, industrial document and accustomed to working with all sort of presentation and social media, and in a variety of projects. I have a deep passion for creative knowledge and guarantee that all of my outcomes are 100% original. Here is a sampling of my previous work portfolio: https://www.freelancer.com/u/ragulnishanth?w=f I highly value professionalism and hold myself strictly accountable to represent my client’s project. I aim to form a long-term working relationship with the employee. I charge the only reliable amount on projects, but if you are interested in a larger volume of work each time, I can offer a lower rate. Please, let me know what is needed to secure this bid! Thank you for your consideration. Ragul Nishanth
$210 USD ndani ya siku 4
4.8 (36 hakiki)
5.0
5.0
Picha ya Mtumiaji
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 perform a filter and save then this has be dealt with in a different manner. If the above goes through fine with acceptable time we can build a macro with decent performance. Please do not expect it to run in 2 secs... this is easily going to take 30-60 secs based on my experience. Would be glad to discuss further given an opportunity. Regards, Gana
$225 USD ndani ya siku 7
4.9 (27 hakiki)
4.8
4.8
Picha ya Mtumiaji
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/ https://www.freelancer.com/projects/visual-basic/Retrieving-data-from-other-different/ https://www.freelancer.com/projects/Excel/Multiple-Entry-Excel-Macro/ https://www.freelancer.com/projects/Excel/VBA-loop-code-sum/ https://www.freelancer.com/projects/Excel/Complete-Some-Advanced-VBA-Microsoft/ https://www.freelancer.com/projects/Data-Entry/Capture-data-from-website-website-12641885/ https://www.freelancer.com/projects/php/Write-some-Software-12250366/ waiting your answer Regards
$170 USD ndani ya siku 2
5.0 (62 hakiki)
4.6
4.6
Picha ya Mtumiaji
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 ndani ya siku 8
5.0 (23 hakiki)
4.6
4.6
Picha ya Mtumiaji
Hi there! I've been working with MS Excel for years and I'm proficient in most of the built-in formats and functions. I'm sure I can complete your project accurately. Karen
$180 USD ndani ya siku 7
4.9 (15 hakiki)
4.1
4.1
Picha ya Mtumiaji
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 interval. average handle time for each interval Number of abandoned calls for each interval. Please message to discuss further on this Thanks Note-please check my profile for past projects and reviews.
$175 USD ndani ya siku 2
5.0 (11 hakiki)
3.8
3.8
Picha ya Mtumiaji
****** ma shaa Allah ****** I'm are professionals in ✔️MATHEMATICS, ✔️MATLAB, ✔️SOLIDWORKS, ✔️ANSYS FLUENT, ✔️PHYSICS, ✔️COMSOL ✔️PDF to Doc or all format and versa I am a boss. ⭐⭐⭐ Major skills and Qualifications ⭐⭐⭐ ✅DSP and Image Processing ✅Face Detection / Recognition / Classification & Object Tracking ✅ STATISTICS, R, Probability ✅Mathematics: GA, NN, CNN, Machine & Deep Learning ✅Physics: Mechanics, Nuclear physcis, electronics, Optics. ✅Signal processing: FFT/DSP, Computer Vision ✅Mechanics: FEA/CAD/CAM, Robotics, CFD ★★★ Software tools I am using: ★★★ ✅OpenCV, OpenGL ✅Matlab & SIMULINK /Simulation ✅Solidworks, Ansys Fluent, Solidworks ✅Androied,JacaFx,Larval @ If you keep in touch with me, you will be satisfied with my best result! ❤Thanks❤
$210 USD ndani ya siku 1
5.0 (7 hakiki)
3.3
3.3
Picha ya Mtumiaji
Hi, I have got a vast experience in excel working for 12 years with one of the top 5 MNCs worldwide. I have worked in filtering, sorting, pivoting, graphs, lookups references and other advanced formula excel. I can do this job real quickly with 100% accuracy. Please allow me a chance to work for you in this requirement. Thanks. Regards, Keshav
$170 USD ndani ya siku 2
5.0 (4 hakiki)
1.6
1.6

Kuhusu mteja

Bedera ya CANADA
Toronto, Canada
0.0
0
Mwanachama tangu Ago 20, 2019

Uthibitishaji wa Mteja

Asante! Tumekutumia kiungo cha kudai mkopo wako bila malipo kwa barua pepe.
Hitilafu fulani imetokea wakati wa kutuma barua pepe yako. Tafadhali jaribu tena.
Watumiaji Waliosajiliwa Jumla ya Kazi Zilizochapishwa
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Onyesho la kukagua linapakia
Ruhusa imetolewa kwa Uwekaji wa Kijiografia.
Muda wako wa kuingia umeisha na umetoka nje. Tafadhali ingia tena.