Find Jobs
Hire Freelancers

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

$170-250 USD

Closed
Posted over 4 years ago

$170-250 USD

Paid on delivery
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)
Project ID: 20885052

About the project

41 proposals
Remote project
Active 5 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
41 freelancers are bidding on average $202 USD for this job
User Avatar
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 days
5.0 (745 reviews)
8.1
8.1
User Avatar
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 in 2 days
4.9 (100 reviews)
7.5
7.5
User Avatar
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 days
5.0 (180 reviews)
6.9
6.9
User Avatar
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 in 5 days
4.9 (70 reviews)
6.9
6.9
User Avatar
$ 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 in 1 day
5.0 (385 reviews)
6.8
6.8
User Avatar
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 days
4.9 (66 reviews)
6.6
6.6
User Avatar
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 days
5.0 (29 reviews)
6.3
6.3
User Avatar
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 in 2 days
4.9 (51 reviews)
5.9
5.9
User Avatar
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 days
5.0 (38 reviews)
5.5
5.5
User Avatar
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 days
5.0 (25 reviews)
5.1
5.1
User Avatar
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 in 2 days
5.0 (7 reviews)
5.1
5.1
User Avatar
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 in 3 days
4.7 (78 reviews)
5.4
5.4
User Avatar
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 in 4 days
4.8 (36 reviews)
5.0
5.0
User Avatar
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 in 7 days
4.9 (27 reviews)
4.8
4.8
User Avatar
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 in 2 days
5.0 (62 reviews)
4.6
4.6
User Avatar
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 days
5.0 (23 reviews)
4.6
4.6
User Avatar
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 in 7 days
4.9 (15 reviews)
4.1
4.1
User Avatar
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 in 2 days
5.0 (11 reviews)
3.8
3.8
User Avatar
****** 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 in 1 day
5.0 (7 reviews)
3.3
3.3
User Avatar
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 in 2 days
5.0 (4 reviews)
1.6
1.6

About the client

Flag of CANADA
Toronto, Canada
0.0
0
Member since Aug 20, 2019

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.