Post #377

🔊 Hiring Now: Excel Macro & VBA ⤵️ Issues with Current Form: 1. Dates and times frequently get misformatted. 2. Some data points are not being captured correctly. Requirements: 1. Master Raw Data Sheet: o Instead of creating multiple Excel sheets with raw data for each patient, I would like to consolidate all data into a single master raw data sheet. o The master raw data sheet should ideally be organized by month so that I can visually differentiate between different months in the raw data. 2. Visual Data Representation: o I need a tab/sheet that captures this data in the form of visual aids such as graphs. o From this data, I want to track the following metrics:  Location  Response time (from the time the code was called to the time of arrival)  Average length of code (start to end times)  Patient orientation  Patient insight  Use of PRN medications  Use of restraints (including therapeutic containment and physical restraint)  Injuries to staff o These metrics should be tracked on a monthly basis and continuously updated to show year-to-date data. Objective: • Automate the data entry and visualization process to save time and improve accuracy. • Resolve issues with date and time formatting as well as data capture errors. • If possible, improve user functionality, make it easier to manually type this data in, or extract the data from a PDF file, I will pay extra if you can solve this major problem for me as manually entering the data every month is tedious. Contact me @honelegn19