Find Jobs
Hire Freelancers

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

£20-250 GBP

Completed
Posted over 6 years ago

£20-250 GBP

Paid on delivery
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.
Project ID: 15914662

About the project

11 proposals
Remote project
Active 6 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
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 using Excel as part of daily work life. In the process, implemented lot of automation. Over the last 18 MONTHS , spent at least 250 HOURS on automation in Excel every month. Proposed Milestones £60 GBP - On Delivery of Initial version with half of the features £60 GBP - On Delivery of Final version with all the features £60 GBP - After final testing and acceptance Being a full time freelancer working almost exclusively on Excel based projects, I work on developing macros every single day. If awarded, I can get your work completed to your fullest satisfaction. Looking forward to hearing a positive response from you. Thanks in advance! Have a Great Day! Srinivasan Krishnamoorthi
£180 GBP in 5 days
5.0 (175 reviews)
6.7
6.7
11 freelancers are bidding on average £166 GBP for this job
User Avatar
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 in 3 days
5.0 (161 reviews)
7.4
7.4
User Avatar
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 working on this proposal.
£250 GBP in 7 days
5.0 (168 reviews)
7.1
7.1
User Avatar
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 experience in Excel, VB, VB.net, VBA Programming, XML, MS Work, Google Docs, SQL, Google Spreadsheet, Data Entry in Odoo, Google Docu Proposed Milestones £250 GBP - Milestone
£250 GBP in 3 days
5.0 (79 reviews)
6.3
6.3
User Avatar
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 - only Looking for your response.
£120 GBP in 2 days
4.8 (33 reviews)
5.6
5.6
User Avatar
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 Milestones £100 GBP - default milestone
£100 GBP in 3 days
5.0 (8 reviews)
3.4
3.4
User Avatar
Stay tuned, I'm still working on this proposal.
£135 GBP in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
£222 GBP in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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 Management, Social Media Accounts Management, Data Analysis, Data Scraping, Database Building, Data Processing, Data Entry etc Proposed Milestones £20 GBP - full task
£20 GBP in 3 days
5.0 (1 review)
0.0
0.0
User Avatar
It sounds very interesting! Please contact me. Relevant Skills and Experience VBA and software engineer Proposed Milestones £244 GBP - preparing, doing
£244 GBP in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
£150 GBP in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED KINGDOM
Brighton, United Kingdom
0.0
0
Payment method verified
Member since Dec 20, 2017

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.