Automate a process in Excel (calculations) and display on a screen
€30-250 EUR
Paid on delivery
Our project is to automate with excel some calculations whe are currently doing manually, and then display them on a screen in our office.
In our company we mesure the performance of our sales agents computing their "call time (total calls duration)" and "number of calls" made during a period of time.
We are presently doing these calculations manually and we send them via email to our sales agents. We wish to have a tool that cool automate the calculations everytime we upload the excel containing the calls data, and then display this information on a TV screen. We would upload new information 3 or 4 times a day.
Our telephone system enables us to upload a call log report. We enclose an excel sheet with three tabs:
Tab Report 1 is the report we get from our telephone system
Tab Report 2 is the modified report with the information we need for calculation (done manually)
Tab CALCULATIONS shows the calculation needed,
CALCULATION OF THE CALL TIME AND NUMBER OF CALLS:
Type:
Only "outbound" calls shall be considered for calculations
Disposition:
Only "ANSWERED" calls shall be considered for calculations. (BUSY, FAILED, NO ANSWER, UNKNOWN are not accounted)
billableSecs:
This is the column we use for calculation. It is written in second.
Our idea is to automate the calculations.
Once the calculations are done we would like the information to go on a screen.
DISPLAY ON A SCREEN:
The display should be as described below. It should include.
Date and time of last update
First Name of Agent
Number of calls
Call Duration
Its should be very visual and clear. Please suggest screenshots.
Please let us know you thoughs:
1 - How you could automate the process in excel
2 - How we could display the information on a screen
If you are only able to respond one of the two points we could be interested as well.
Please find enclosed excel sheet as it is delivered by our phone system.
Project ID: #5874803
About the project
38 freelancers are bidding on average €129 for this job
Hello, I am top excel developer on this forum with 200+ five star reviews and with a completion rate of 90%. I have understood your requirement and I am sure I can implement this. Check my past reviews for your refere More
Hi, your 5-star excel & vba coding expert is ready to help your project. pls check my profile and feedbacks first to have some idea about the quality of my work... I had many similar excel/vba tasks, all achieved with More
Dear Sir/Madam I can help you on this task perfectly. Basically you need a dash board which shows the summary of your calls with some KPI's. I have alrady created such dynamic dash boards for various clients. my solut More
Hey There, Thanks for posting the project. Its looks feasible and am Interested to do it. Next steps: Lets discuss/validate the complete requirement and I can start to get this done with required quality ou More
Good day, It can easily be done via VBA. I am Excel developer of spreadshetweb.com. I am expert. I teach excel. I can say there is no formula in excel that I cannot handle it. I've got lots of experiences in excel More
Hi, Here is how I intend to solve this problem. I'll write a VB application which will process the CSV files and refresh the output on screen. This machine is connected to a Bigger screen instead of a simple des More
I would make everything in excel and macro would loop screens of charts and tables. Data would be refreshed every houre or as you want. It can look very nice. Other option is to create Power Point Presentation and then More
Hi, I would love to get the additional info on this and get a sample done for you within a day. Please do provide the details. I am an experienced software programmer in India working for the last 6.5 years and hav More
Dear Sir, I am a former IBM manager within the BPO environment, and then Quality and Productivity Mgr for another Shared Service Centre, where I had full responsibility of the reporting. Now I consult companies, tha More
I am Excel Expert and have done numerous projects. I can do any task relating to excel. I have understood your requirement and can complete the task within a day. Message me if you want to discuss the project.
Dear Sir, I'm quite interested by your project. I am programmer with sincere and capable. I have developed many project. Particular, I have rich experience in Excel Automate project. I can provide you t More
Hi Sir, I am ready to work for you.I have 4 years of experience in C/C++/Php/C#/sql. please see some of my works also check my reviews you will get better idea about my skill.I deliver quality work within time frame More