Fullført

Excel Code needed to analyse and report on Call Bell Wait Times

We are a nursing home for the elderly and have a call bell system with which residents can push a button to call for attention to their room.

I can export the data from my device giving a specific time and date from and to. Data entry can be:

Reset

Call

Present

Assistance

Accept

Emergency

We have 40 bedrooms (1-41 with no13 omitted) + some extra rooms. A list of rooms is attached.

Floor structure:

Bodiam 1st floor

Arundel & Bramber G floor

Pevensey & Lewes LG Floor

Types of call that can be made are also attached.

A "call" is made from a call point.

A staff member can "accept" this call from the corridor to snooze the call, after 2 minutes it will "call" again.

Once at the call point the staff press the button once to signify "present" and assists the resident.

The staff member can press call again to ring for "assistance" so a second staff member comes to help once the second staff arrives this call goes back to "present".

Once finished the staff will press the button again to "reset" the call.

An "emergency" call can also been made from a call point, the same procedure is followed as above except it can not be "accept"ed.

When in room a staff can press the button to signify "present" and "reset" without making a call to log their presence on the system.

I am looking for the ability to use this export once a week and for a report to be produced (with graphs where possible) for daily & weekly monitoring split by shift

0730-1430 AM shift

1430-2130 PM shift

2130-0730 Night shift

Number of calls made per address per day / total for the week

Longest wait time for a call to be present (split by floors and for the whole building) per day / for the week

Average wait time for a call to be present (split by floors and for the whole building) per day / for the week

Longest wait time for a call to reset (split by floors and for the whole building) per day / for the week

Average wait time for a call to reset (split by floors and for the whole building) per day / for the week

Longest time present in the room (split by floors and for the whole building) per day / for the week

Monitoring of how long it has taken to answer the front door.

etc. Useful information to allow management to monitor wait times and assess what happened with who is working on the floor.

Note sometimes staff do not use the system properly and will leave a call in "present" especially for the front door.

I will be grateful to anyone who can help me with this project and can discuss the specifics further.

Ferdigheter: Excel

Se mer: crystal report call web services, excel code bid, excel code paste cut cell csv, excel statistical formulas, using excel for statistical analysis, excel lambda function, discuss and compare the the specialized and statistical functions in excel., specialized functions in excel definition, under what circumstances would you use logical and lookup functions?, excel statistical functions with examples pdf, excel statistical functions cheat sheet, excel, copy browser spreadsheet excel code, free project report call centre management, refresh web service excel code, price excel code, excel code html, excel macro needed, excel work needed, copy paste excel code

Om arbeidsgiveren:
( 0 omtaler ) Brighton, United Kingdom

Prosjekt-ID: #15914662

Tildelt til:

ksriniravi

I can set up a workbook with macro which will have a button to import the csv log file and then process data and generate all the required graphs and metrics. Relevant Skills and Experience 18 years experience in usin Mer

£180 GBP på 5 dager
(154 omtaler)
6.6

12 frilansere byr i snitt £164 for denne jobben

PigtailXL

Hello Sr./Madam Hope you read my proposal and take a look into my Portfolio to see my reputation and capabilities. I am an experienced VBA Excel Developer & Automator and I'd like to help you. Stay tuned, I'm still w Mer

£250 GBP på 7 dager
(156 Omtaler)
6.9
asin1987

Dear Employer, I will do this code for you. Please check my reviews once. I am an expert. Thanks, Ash Relevant Skills and Experience EXCEL VBA Proposed Milestones £150 GBP - Project

£150 GBP på 3 dager
(104 Omtaler)
7.0
MohsanEijaz

I have experience in Excel, VB, VB.net, VBA Programming, XML, MS Work, Google Docs, SQL, Google Spreadsheet, Data Entry in Odoo, Google Document and other related applications. Relevant Skills and Experience I have e Mer

£250 GBP på 3 dager
(66 Omtaler)
6.0
osmemon

I ll design a complete wait time monitoring code on Excel. I have 7 years of experience in this field. See my profile for client reviews about me. Relevant Skills and Experience Excel VBA Proposed Milestones £120 GBP Mer

£120 GBP på 2 dager
(33 Omtaler)
5.6
£150 GBP på 3 dager
(16 Omtaler)
4.0
abdulkarim97

Hi.. I saw your project and want to help with it if you will accept my proposal. Of course I cannot convince you to but I can give you an assurance of a good job. Thanks. Relevant Skills and Experience Excel Proposed Mer

£100 GBP på 3 dager
(6 Omtaler)
2.8
qubicbytes

Stay tuned, I'm still working on this proposal.

£135 GBP på 2 dager
(0 Omtaler)
0.0
zainabnawfer

A proposal has not yet been provided

£222 GBP på 3 dager
(0 Omtaler)
0.0
AfzalSoron

I have read your job post carefully and understood clearly about your need. I am really interested to work for you. Relevant Skills and Experience I am also fully expert in Internet Research, File Management, Email Ma Mer

£20 GBP på 3 dager
(1 anmeldelse)
0.0
anamollo

It sounds very interesting! Please contact me. Relevant Skills and Experience VBA and software engineer Proposed Milestones £244 GBP - preparing, doing

£244 GBP på 2 dager
(0 Omtaler)
0.0
ak2807

A proposal has not yet been provided

£150 GBP på 3 dager
(0 Omtaler)
0.0