In Progress

Create A Customer Wait Time Dashboard in Excel

Seeking someone who is experienced in Excel Dashboard Creation. More description can be provided through private chat upon request.

Project Description

I have attached a data sheet in excel which is rough sketch of what we are currently working on.

[url removed, login to view]

Basically, we are trying to capture total customer wait time for our service. I would like to calculate the waiting times (in days) of various customers, depending on certain changes in flow of the customer through our service process map.

As the service cycle time changes the total CWT customer wait time changes. As we enter the data into the cycle excel should automatically make the calculation that where I need someone to write the formulas and make the dashboard look good. A fancy dashboard is not need just something that makes sense the viewer

Any suggestions to make this better would or alternative ways I would love to hear them.

Ideal candidate:

Good in excel formula calculations- basically good in excel

Meet Deadlines

Have some creatively using dashboards in excel a plus but not necessary

VBA experience a plus but not necessary

Prompt in returning communique

Can you file sharing software such as Dropbox,

Adhere to confidentiality with consultations

Ability to use audio conference software such as Skype

Use Team-viewer for screen sharing

Can use Slack for IM

MUST have good broadband connection

Please note: This is NOT AN EXCEL DATA ENTRY entry job but rather technical job.

NOTE: Will consider bids above the max bid ceiling for those who have a proven track record..

Skills: Data Entry, Data Processing, Excel, Software Architecture, Visual Basic

See more: we need to create a bill format in MS Excel for the patrol pump, how to create a data entry form in excel, create a calendar in microsoft excel, how do i create a data entry form in excel, a customer signs up for the 3-at-a-time program, please create a dashboard mockup and icon of an app to be developed named homework suite homework suite tracks student assignmen, create a leader board to record weekly high scores for my word game, create a excel, create social media dashboard excel, create php dashboard excel data, create dashboard excel google analytics, create dashboard excel 2010, excel record entry dashboard, create employee time clock excel spreadsheet, create local train time table excel format, create project dashboard excel, create dashboard excel

About the Employer:
( 3 reviews ) dallas, United States

Project ID: #15681863

Awarded to:

insidenetsoft

Hello, I am aware of the importance of your project and I would like to participate with my ideas gathered in my past years working with dashboards in excel. Relevant Skills and Experience - data processing and More

$47 USD in 2 days
(20 Reviews)
3.9

29 freelancers are bidding on average $60 for this job

shoguna2m

Hello, my name is Andrés. First of all, thank you for considering my bid. I am an industrial engineer with more than four years of experience in the simulation, process improvement and data analysis fields. Within this More

$100 USD in 5 days
(53 Reviews)
6.1
SShtv

I have a large and successful practical experience in data visualization and building Dashboards. Your task is clear to me and I am ready to execute the project for 75 USD for 2 days. Relevant Skills and Experience A More

$75 USD in 2 days
(26 Reviews)
4.8
royalcalif

Hi Mr. Employer, Glad to contact with you. I can do this project through effective manner with 100% accuracy fulfilled your requirements. Thank you very much for your opportunity to bid. Relevant Skills and Experience More

$10 USD in 1 day
(47 Reviews)
4.9
nurnga1218

Hi, Waiting time basically is by calculating end time and start time. I have a question about those 2 items. Would be calculated manually or automatically or triggered by something or how? Relevant Skills and Experie More

$30 USD in 2 days
(33 Reviews)
4.3
javidj18

I have good experience in building dashboards in Excel. I have developed various dashboards with different functionalities in excel based on the user requirement. I can complete your task comfortably Relevant Skills More

$50 USD in 3 days
(15 Reviews)
3.8
$70 USD in 1 day
(14 Reviews)
3.7
chintuag

Dear Hiring Manager, I am an expert in excel ad would like to offer my expertise for your project. I have worked on several projects in excel. My expertise in excel includes, but not limited to: Macros, Complex Formu More

$83 USD in 4 days
(6 Reviews)
3.6
SHhadun

Hello, I'm working as CRM analyst MS Access and Excel files are my daily work. So I'm very familiar with process and design of a successful project like this. Creating dashboards is what I do + vba Relevant Skills and More

$50 USD in 3 days
(21 Reviews)
3.6
mikhailkozalski

I am a great excel expert. Relevant Skills and Experience Excel,Excel VBA Proposed Milestones $100 USD - all

$100 USD in 1 day
(4 Reviews)
2.7
nickret16

Hi there, you will need my expertise on making dashboards. I can deliver the job fast and accurate. Thank you. Relevant Skills and Experience Excel Dashboard Proposed Milestones $75 USD - Fast delivery of job.

$75 USD in 5 days
(6 Reviews)
2.1
haleem0786

I have good command over MS Excel especially povit table, charts, advance formulas etc. do let me know more detail in PM. thanks

$60 USD in 2 days
(5 Reviews)
2.2
Dre24

Very experienced with MS Excel, Visual Basic and data management & analysis. I have 3+ years on the job experience utilizing these skills and would be happy to complete this task for you. Relevant Skills and Experien More

$80 USD in 5 days
(1 Review)
1.3
$55 USD in 2 days
(1 Review)
1.1
vilas4all

m already working on similar projects.

$55 USD in 5 days
(0 Reviews)
0.0
voblacksmith

Hello, I will be glad to take your project, because I’m working with VBA and high-level formulas, and this task one of those which I accomplish in day-to-day activities. Sincerely yours, Viktor Kuznetsov.

$55 USD in 3 days
(0 Reviews)
0.0
Ashu1980

Will be working on this Dashboard to make it iterative and will cover all the aspects users wants, will accommodate the changes as suggested by user Relevant Skills and Experience In total 11 years of professional MIS More

$100 USD in 5 days
(0 Reviews)
0.0
awinqian

A proposal has not yet been provided

$83 USD in 3 days
(0 Reviews)
0.0
sheiksuzanbabu

$50 in 6 days Stay tuned, I'm still working on this proposal.

$55 USD in 6 days
(0 Reviews)
0.0
senthilm2506

I am very much interested to do u r job

$50 USD in 3 days
(0 Reviews)
0.0
$47 USD in 10 days
(0 Reviews)
0.0