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)
45 freelance font une offre moyenne de $201 pour ce travail
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 Plus
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 Plus
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
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 Plus
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.
can you show an example of information ?. I can make a script to sort the information and add the required number of seconds
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 Plus
Hello, I can help to merge your Excel files according your guideline. Let’s discuss if you’re interested. Best regards, Duong
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!
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 Plus
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 Plus
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~
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/ Plus
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 Plus
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.
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 Plus
Hi, presume your call data is in EXCEL or CSV format. If so, my experience in EXCEL will be useful to do this aggregation.
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 Plus
$ 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 Plus
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 Plus