Tayo Solagbade’s
Performance Improvement IDEAS
(PI Squared) Newsletter

Monday 22nd August 2016

NB: This PI Squared newsletter will be published weekly, on Mondays, in place of the Speaking/Web Marketing IDEAS newsletter, starting from today – 15th February 2016. I’m reinventing my Monday newsletter content and theme, to accommodate my vision of serving the growing audience of serious minded individuals and organizations reaching out to me, with information, education. news and research findings designed to help them do what they do better.

**********

PII 028 [Case Study]: Using Excel-VB Automation for Smart Hospital Records Management (Featuring: A Custom app built for a Lagos based Medical Clinic)

This week’s Performance Improvement Ideas (PII) newsletter features an article from my archives.

It discusses one of several scenarios for potential application of custom Excel-VB programming as a low cost, user-friendly means to effective and efficient data handling and report generation in Patients Records Management for Hospitals/Clinics or Medical Centres.

At the end, I append a link to a PDF White Paper I published based on a research paper an old client engaged me to write in 2007, on development of a low cost networkable Hospital Management Information System (HMIS)™ for a South Western state in Nigeria.

The thinking advocated in this piece, can be successfully applied in a wide variety of situations. If you need help adapting them to suit your peculiar needs, get in touch with me using this form.

The Typical Situation:

A patient comes in complaining of a fever. Nurse asks for her “card number”. Patient replies that she can’t remember. Nurse takes patient’s name, and begins sifting through shelf on which patient’s cards are filed.

Shortly after, nurse asks: “when last did you come for treatment?”. Patient replies: “I’m not sure – I think it was May this year”, then she adds “Please nurse – hurry!”. The nurse replies: “Sorry, but I need to find your case file…etc” Eventually, the case note is found, the patient attended to/treated and leaves.

The Problem:

This is a common experience for many people in most – if – not all – medical centres/hospitals across Nigeria. Sometimes the time lapse between when a patient arrives and when their “records cards” are successfully retrieved for the Doctor’s attention can be quite long. Such avoidable delays can cause great frustration or even worsen the patient’s health problem.

The Viable Alternative:

A computer pre-installed with Microsoft Excel (and the rest of the MS Office Suite) is easily acquired today.

Using MS Excel, a simple, yet extremely functional Custom Automated Excel Spreadsheet application can be developed. The application will run in MS Excel, so you would not need to incur any additional costs via purchase of some prohibitively priced off-the-shelf app, which may not be easily modified to suit unique needs of some facilities.

The custom Excel-VB app would be easy for anyone (nurse, doctor, clerk etc) to use in posting patient records into a database – daily, weekly etc.

Nurses/Doctors/Clerks etc can then simply type in the surname (sometimes the first few letters) of a patient’s name into a special dialog box prompt to have the patient’s full name appear. Then s/he would click on it (or select the name from a drop down menu) to have the patient’s personal information and medical history displayed – within seconds!

Below: Screenshot of the data entry interface, with floating navigation menu for a custom MS Excel-VB driven app I built for an Lagos-Nigeria based client clinic in March 2009.

Click here to request details about the above shown app.

A lot more is possible with MS Excel-VB automation…

Templates for periodic reviews of (weekly etc) of cases treated, emergencies, patients referrals etc, could be auto-generated by such an app. Charts comparing different ailments treated weekly/monthly, numbers of patients and other trending could be generated on screen and/or ready-to-print on paper.

Even better, the application could be made accessible from ANY computer connected to the hospital/clinic/medical centre’s computer intranet – if one exists. That way, multiple users would be able to access it.

The above are real life examples of possible ways in which custom Excel-VB driven apps can be used, that I have successfully implemented in various organizations over the past 2 decades.

Final Words: Anyone Can Do It!

The best part is that a custom Excel-VB app can be developed by ANYONE in the team, if s/he has the needed time and training (e.g. you, as the owner or your employee).

However, if competent in-house expertise does not exist, you can hire an external developer to build the app, and/or train someone within the organization to develop custom apps in-house. The latter option is likely to result in savings of money and time especially, over the long term.

If you’d like an app built for your medical centre/hospital/clinic, and/or need training on custom Excel-VB automation to build or maintain such an app, I can help you.

Click here to tell me what you need help with.

Related Article/Publications:

1. SDAc’s Microsoft Excel Heaven™ Visual Basic Automation Club & COMPETITION [Watch the Full Video Narration of 9 Page Slideshow – by Tayo K. Solagbade]
2. White Paper (PDF), Blueprint for a Low Cost Automated Spreadsheet Hospital Management Information System (HMIS)™
   

   SDN Blog™

   New posts from last week*

   Monday:

   PII 027: Make Money Selling Spreadsheet Workbooks You Use

   [Tuesday]:

   Join my Cost-Saving Farm Business Ideas Club & Get Multiple Lifetime Benefits!

   [Wednesday]:

   How I Built a Bank Transactions Monitor (BTM) ™Excel-VB Driven App as a Gift for a Client in 2006 [Another Example of Real Life Problem Solving with Excel-VB]

   [Thursday]:

   N/A

   [Friday]:

   N/A

   [Saturday]:

   Protect Yourself from Macro Viruses [Potential Dangers of Enabling Macros in Excel-VB Workbooks From Unfamiliar Sources]

   [Sunday]:

   Protected: THE FARM CEO (Issue 58): Water Efficient Maize for Africa (WEMA), Investing in the future of African women farmers, How to keep African agriculture improving

Tayo K. Solagbade*

Self-Development/Performance Improvement Specialist

*Best Practice Farm Business Support Specialist & Founder of the MS Excel Heaven Visual Basic Automation Club and Competition

Mobile: +234-803-302-1263 (in Nigeria) or +229-66-122-136 (in Benin Republic)

http://www.tayosolagbade.com

Tayo K. Solagbade is a Location Independent Performance Improvement

Specialist and Multipreneur (i.e. a highly versatile/multi-skilled entrepreneur), with a bias for delivering Best Practice solutions to Farm Businesses and others.

Since 2002, he has earned multiple streams of income providing individuals and organizations with personal development training and coaching, custom MS Excel-VB solutions, web marketing systems/web hosting, freelance writing services, and best practice extension support services (for farm business owners).

Tayo is the author of the Self-Development (SD) Bible™ and the popular Livestock Feed Formulation Handbook. He is also the developer of its accompanying Excel-VB driven Ration Formulator™ and the Poultry Farm Manager™ software.

He has delivered talks/papers to audiences in various groups and organizations, including the Centre for Management Development, University of Lagos, Christ Baptist Church, Volunteer Corps, Tantalisers Fast Foods and others.

In May 2012 he was the Guest Speaker at the Centre for Entrepreneurship Development’s Annual Semester Entrepreneurial Lecture at Yaba College of Technology in Lagos.

On 1st April 2013, Tayo (who reads, write and speaks the French language) relocated to Cotonou, Benin Republic to begin slowly traveling across the West African region.

His key purpose is to deliver talks, seminars and workshops on his key areas of focus and interest to interested audiences (Email tayo at tksola dot com for details).

In a previous life, before leaving to become self-employed, Tayo served for seven years (October 1994 to December 2001) as a high performing manager in Guinness Nigeria. He rose from Shift Brewer to Training & Technical Development Manager, and later acted in senior roles as Production Manager and Technical Manager.

In addition to constantly challenging the status quo and influencing positive work changes, he built a reputation for using self-taught spreadsheet programming skills (starting with Lotus 1-2-3, and later moving to Excel Visual Basic) – in his spare time – to develop Automated Spreadsheet Applications to computerize manual report generation processes in the departments he worked. Over four(4) of his applications were adopted for brewery level reporting.

Tayo holds a B.Sc degree in Agricultural Extension Services from the University of Ibadan, Nigeria, having graduated top of his class – with Second Class Upper Division honors – in 1992. He is an Associate Member of the UK Institute & Guild of Brewing, a 1997 National Finalist of the Nigerian Institute of Management’s(NIM) Young Managers’ competition, a Certified Psychometric Test Administrator for Psytech UK, innovator of Spontaneous Coaching for Self-Development™ (SCfS-D™), and Founder of the Self-Development Academy (SDAc).

When he’s not amazing clients with his superhuman skills (wink), Tayo works as the creative force behind his Daily Self-Development Nuggets blog – on which he also publishes The Farm CEO Weekly Newspaper (sent via email to paid subscribers) and his Weekly Performance Improvement IDEAS newsletter.

You can connect with him on Twitter @tksola.com and Facebook.

Visit Tayo Solagbade Dot Com, to download over over 10 performance improvement resources to boost your personal and work related productivity.

====
[IMPORTANT NOTE:====

On 4th May 2014, Tayo’s 9 year old domain (Spontaneousdevelopment dot com), which hosted his website, was taken over by Aplus.net.

Within a few days however, Tayo used his advanced self-taught web development skills to build a SUPERIOR “reincarnation” of it the website http://www.tayosolagbade.com.

But updates are still ongoing to URLs bearing the old domain name in most of the over 1,000 web pages, and blog posts

he’s published.

If you experience any difficulties finding a page or document, email Tayo at tksola dot com.

Click “Tayo, What Happened to

SpontaneousDevelopmentDotCom ?” to read a detailed narrative about how the above event occurred :-))

Here’s an article Tayo wrote, to inspire others to defy adversity, and bounce back to even greater reckoning at what they do EVERY time:

And he wrote the one below, to explain why losing a domain name, no matter how old, NO LONGER determines your online success or otherwise:

A Proven Strategy to Find Profitable Buyers Regardless of Your Domain Name
==================

Home |About | Contact | SD Nuggets™ | Speaking/Web Marketing IDEAS | Web Marketing Systems | Freelance Writing | MS Excel® Heaven™ | Cost-Saving Farm Biz Ideas