Automate a process in Excel (calculations) and display on a screen

Closed Posted Apr 29, 2014 Paid on delivery
Closed 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.

Excel Visual Basic

Project ID: #5874803

About the project

38 proposals Remote project Active Jun 5, 2014

38 freelancers are bidding on average €129 for this job

Teloquence

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

€250 EUR in 0 days
(330 Reviews)
7.6
seaanddream

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

€157 EUR in 5 days
(228 Reviews)
7.3
sy3d

i am advanced user of excel and my reviews are proof of it the attached file has only one tab Report no other tabs while there are three filled columns would u like to show me complete file ? let me review More

€66 EUR in 0 days
(270 Reviews)
7.2
priyal1997

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

€200 EUR in 3 days
(162 Reviews)
6.6
avinav606lx

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

€147 EUR in 0 days
(140 Reviews)
6.4
dpune

Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 200 projects. Please look at the feedback left by my employer to know more about my work. Waiting for your positive More

€200 EUR in 10 days
(117 Reviews)
6.3
SiroosJafary

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

€88 EUR in 2 days
(68 Reviews)
5.8
vikas0903

Hi, To solve this problem, we can develop an analysis Tool (Management Information system) which takes reports as input and creates reports for business decision making. Tool description: Organization: It has t More

€147 EUR in 3 days
(38 Reviews)
5.6
sawangupta

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

€247 EUR in 3 days
(25 Reviews)
5.3
tomislav1975

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

€150 EUR in 5 days
(34 Reviews)
5.3
BDtW

Hello, Thank you for describing the project so nicely. I think I can write up some macro that'll do the automated calculation process. I must admit I have no idea on how you can show them on a television screen, More

€61 EUR in 3 days
(33 Reviews)
5.1
JonNxt

Hi there, I have more than 2 years vba excel coding experience - this is what i do at my workplace. Such code/macro it can easily be done. And it will only take few seconds to compute required calculations. Post More

€55 EUR in 1 day
(35 Reviews)
5.0
dank111

Hi, My name is Dan. I am an expert in excel and all advanced functionalites. I have an experience of managing a contact center in a Multi national firm, so I can relate to your job description as I have done a simil More

€55 EUR in 0 days
(10 Reviews)
4.3
himanshuhc

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

€34 EUR in 2 days
(14 Reviews)
4.4
Aan12

I can do this type of job. All I need is the file with sheets and some time to analize and automate it. I have Excel and VBA knowledge to automate almost everything into an Excel file. Relative to your question, I th More

€100 EUR in 5 days
(17 Reviews)
4.1
viktormihalkov

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

€250 EUR in 10 days
(5 Reviews)
3.8
mcanyas

Hello, I have to ask two questions to bid correctly: will you have a pc connected to the tv? And, how many agents will you show on listing? Ten first ordered by some criteria? Anyway, I have two proposals: if you h More

€150 EUR in 3 days
(5 Reviews)
3.2
GuruExcel

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.

€50 EUR in 2 days
(7 Reviews)
3.0
TypingMachine

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

€53 EUR in 3 days
(3 Reviews)
2.4
goswamiarpit475

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

€155 EUR in 3 days
(6 Reviews)
3.2