Find Jobs
Hire Freelancers

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

$170-250 USD

Avslutat
Publicerad över fyra år sedan

$170-250 USD

Betalning vid leverans
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

Om projektet

41 anbud
Distansprojekt
Senaste aktivitet fem år sedan

Ute efter att tjäna lite pengar?

Fördelar med att lägga anbud hos Freelancer

Ange budget och tidsram
Få betalt för ditt arbete
Beskriv ditt förslag
Det är gratis att registrera sig och att lägga anbud på uppdrag
41 frilansar lägger i genomsnitt anbud på $202 USD för detta uppdrag
Använd 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 Om 3 dagar
5,0 (745 omdömen)
8,1
8,1
Använd 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 Om 2 dagar
4,9 (100 omdömen)
7,5
7,5
Använd 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 Om 2 dagar
5,0 (180 omdömen)
6,9
6,9
Använd 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 Om 5 dagar
4,9 (70 omdömen)
6,9
6,9
Använd 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 Om 1 dag
5,0 (385 omdömen)
6,8
6,8
Använd 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 Om 3 dagar
4,9 (66 omdömen)
6,6
6,6
Använd 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 Om 7 dagar
5,0 (29 omdömen)
6,3
6,3
Använd 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 Om 2 dagar
4,9 (51 omdömen)
5,9
5,9
Använd 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 Om 3 dagar
5,0 (38 omdömen)
5,5
5,5
Använd 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 Om 3 dagar
5,0 (25 omdömen)
5,1
5,1
Använd 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 Om 2 dagar
5,0 (7 omdömen)
5,1
5,1
Använd 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 Om 3 dagar
4,7 (78 omdömen)
5,4
5,4
Använd 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 Om 4 dagar
4,8 (36 omdömen)
5,0
5,0
Använd 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 Om 7 dagar
4,9 (27 omdömen)
4,8
4,8
Använd 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 Om 2 dagar
5,0 (62 omdömen)
4,6
4,6
Använd 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 Om 8 dagar
5,0 (23 omdömen)
4,6
4,6
Använd 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 Om 7 dagar
4,9 (15 omdömen)
4,1
4,1
Använd 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 Om 2 dagar
5,0 (11 omdömen)
3,8
3,8
Använd 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 Om 1 dag
5,0 (7 omdömen)
3,3
3,3
Använd 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 Om 2 dagar
5,0 (4 omdömen)
1,6
1,6

Om kunden

Flagga för CANADA
Toronto, Canada
0,0
0
Medlem sedan aug. 20, 2019

Kundverifikation

Tack! Vi har skickat en länk för aktivering av gratis kredit.
Något gick fel med ditt e-postmeddelande. Vänligen försök igen.
Registrerade Användare Totalt antal jobb publicerade
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Laddar förhandsgranskning
Tillstånd beviljat för geolokalisering.
Din inloggningssession har löpt ut och du har blivit utloggad. Logga in igen.