Automating a financial report

Client: Technical Billing
Platform: MS Excel
Delivery Date: August 2015
Project Description: Manager would like automation of monthly financial report preparation.
Features: On open, macro changes workbook to read only (so changes cannot be saved over template). Manager pastes data table of variable size into worksheet and runs macro. Macro creates monthly total row, current month comparison to average row, percent variance to previous month row, total by category column, average by category column, current month versus average column, current month versus previous month column. It formats header rows and total columns for readability. It then deletes the “Report Instructions” worksheet with the macro button so the report cannot be accidentally overwritten.
Users: 1

Report instructions with button to run macro (click to enlarge):







Automating and recording counting of files

Client: Medical Coding
Platform: MS Access
Delivery Date: July 2015
Project Description: Manager has been manually recording number of files in multiple folders two days per week to track workload and backlog. Manager would like this process automated along with reporting and charting capability.
Features: Files are counted for inpatient and outpatient reports by clicking the applicable button, including any newly created folders. On-screen crosstab shows counts by date with capability to select custom date range. Data export to Excel is available for charting and other analysis.
Users: 1

Main Navigation:
CodingFC Navigation

Data Dashboard:
CodingFC dashboard-1

Sample report:
CodingFC sample-rpt

Code samples:
CodingFC code

CodingFC code-2

Project management information system

Client: Facilities Management
Platform: MS Project and InfoPath integrated with SharePoint
Delivery Date: May 2015
Description: Department desires Project Management Information System to record and share project information with contractors and vendors.
Features: A fully-featured PMIS including contractor/vendor landing page, InfoPath forms for Requests for Information, Change Requests, and Risk Register submissions. Project home page displays project calendar, project tasks, and project announcements. All communications are linked from MS Outlook to discussion board on site. Gantt chart with project milestones and percent completion can be linked from MS Project and refreshed as needed.
Users: 4

Project home page (click to enlarge):

Change request form:
PMIS Change Req

Resources used for this project:
Building a multifunction InfoPath form
Auto-Generating Filenames for InfoPath Forms
Autonumbering InfoPath forms
Auto-Numbering InfoPath Forms
SharePoint for Project Management
How to build a PMIS with SharePoint

Information on list forms versus library forms:
List forms vs library forms

Productivity tracking

Client: Medical Coding
Platform: MS Access (split accdb)
Delivery Date: February 2015
Project Description: Manager would like to track and record number of reports and time spent per coder, and generate productivity and management reports.
Features: When users open the DB, what they nicknamed “the widget” appears — designed to be small, unobtrusive, and take up minimal screen real estate. Dropdowns make data entry faster and ensure uniform entries. Clicking “Start” records start time and opens a form where they can select a comment about the report if desired. Clicking “Note Completed” enters productivity info into table. Users can easily view the detail or summary of their work completed for the day. Managers can access various reports on employee productivity and workload for various types of inputs, and edit dropdown selections.
Users: 10

The “widget”:

“Working” dialog:

Manager navigation:

Sample report:

Code samples:


Producing temporary parking permits

Client: Patient Services
Platform: InfoPath list form and SharePoint list
Delivery Date: February 2015
Project Description: Administrative assistants throughout organization need to issue temporary parking permits (daily and monthly).
Features: Separate security groups control available dropdown options on form. Submission of InfoPath form creates list item. A repeating section allows submission of multiple permits (list items) from one form. A workflow creates a Word document in a separate library from a password-protected template, using the information submitted by the user. A workflow on that library sends an email to the user with a link to the parking permit document, for printing or forwarding.
Users: 20


Managing parking permits

Client: Patient Services
Platform: MS Access Web database integrated with SharePoint
Delivery Date: January 2015
Project Description: Department needs to accept online parking permit applications, process applications, assign and retract permits, and monitor expiration dates.
Features: Directors can access forms on SharePoint to request parking permits for their staff. Data macro notifies admin when a new application is entered. In back end, admin/manager can assign, retract, or inactivate permits; view unassigned permit numbers; track permit expiration dates; print report of new applications to present for approval; search for vehicles.
Users: 10

Web form page 1:

Web form page 2:

Back end user navigation:
back end user navigation

Manage permits:

Sample code, updates 3 tables when permit is assigned (click to enlarge):

Sample code, updates 3 tables when permit is inactivated(click to enlarge):

Phase 2: Add-on module to track parking violations, determine need for citation after multiple violations, track citation requests

Invoice tracking application

Client: Account Follow-Up
Platform: MS Access (split accdb)
Delivery Date: July 2014
Project Description: Manager wants to track staff activity, bring outstanding invoices to staff attention, and access productivity reports.
Features: Staff can enter a new invoice and its related information, or select from a list; application records time spent working invoice and allows staff to record notes and request a reminder at a specified future time. A subform shows previous notes made and actions taken on the selected invoice. Application creates reminder list, saves to desktop, and emails to staff member and manager upon staff login. Managers can view a list of invoices being worked, remove invoices from the active list, add data from staff timesheet to compare to time spent, edit lookup tables, and access reports on invoice aging and staff productivity.
Users: 6

User Navigation:

Add an invoice:

Select an invoice:

Working screen:

Manager navigation:

Code sample, button code for start work session:
Inv-start session code

Phase 2: An add-on application that will enable staff to submit invoices to manager for write-off, notify appropriate manager, record manager approval, and output reports.

Tracking patient referrals

Client: New Patient Scheduling
Platform: MS Access (split accdb)
Delivery Date: April 2014
Project Description: Manager wants to track and time process of scheduling new patients.
Features: Users can enter information about a new referral, and complete the referral when the appointment is scheduled. Managers can edit lookup table, view statistics and access reports on number of referrals scheduled, time to complete, and referring institutions.
Users: 6

User Interface Screenshots:

PR Navigation

PR New Referral

PR Complete Referral

PR Mgr Nav

Sample Manager Report:

PR Report Sample

Example code: Edit Referral (manager only)

PR Mgr Edit Code

A simple task tracking application

Client: Facilities Management
Platform: MS Access (split accdb)
Delivery Date: November 2013
Project Description: Manager desires user-friendly app to allow patient assistants to quickly record tasks as they go through their day.
Features: For untimed tasks, the application records name of task and date/time completed. For timed tasks, application records start time, awaits finish time, prompts for user initials, records time spent on task. Manager can run report of tasks completed by date, and track which users are completing timed tasks.
Users: 5

Main user interface:
GSA click form

Open-Close task dialog:
GSA open-close dialog

Example code: Open-Close
GSA open-close code
GSA open-close code2

Contact me if you’d like a copy of this database (cleaned) or for a quote for a custom application like this.

What is a Web host, and why do I need one?

A Web host provides you with the resources to make your site available over the Internet. Unless you have your own Web server in the back room (and hopefully a competent staff to manage it), you’ll need an account with an organization that provides this service.

To use a vastly oversimplified metaphor, think of the Internet as a giant network of file cabinets. When someone wants to view a Web site, they electronically request the folder that holds the Web pages that make up the site they want to view, and their browser displays it for them. A Web host, then, is sort of like a big electronic file cabinet that holds the folder that holds your Web pages, which make up your Web site.

There are various levels of Web hosting services. Some hosts, like Google Sites, WordPress, and Yahoo!, will host your site for free. However, the “cost” of this kind of hosting usually is that the hosting provider will display ads on your site. These ads provide the income that pays for your free hosting. You may or may not have any control over what ads are shown — you could end up displaying a direct competitor’s ad right next to your own content! Another drawback of “free” sites is that your URL or Web address will usually contain undesirable elements like the name of the host in some form, such as This is not acceptable for most business Web sites. You need a hosting account that will work with your own domain name,, and for this you will usually have to pay.

The next level is often called “shared hosting.” This means you purchase space from a Web host which physically stores your Web pages on a server that is shared with other sites. Sometimes there are concerns about security and resources with shared hosting, especially if you are handling sensitive data or have a large amount of traffic, but shared hosting can be a good solution for most small organizations.

Reseller hosting is a type of shared hosting. This means that someone has purchased an entire server from a larger Web hosting company and resells space on that server to defray the cost. For example, a web designer or IT consultant might want control of their own server to host their own site, write and test software applications, etc., but they might also sell some of that space to their clients who need hosting space.

You can purchase shared hosting through many national and local companies, some of whom provide extras like shopping carts, email addresses, advertising credits, or 24-hour phone support as part of their packages. See the links below for more information.

For larger organizations, it is possible to host your site on its own server, but this level of service is beyond the budget and needs of most small businesses and nonprofit organizations. However, you can read more about the different types of web hosting here.

A quick Internet search will help you find links to companies that provide hosting services. I don’t endorse any particular hosting company and will be happy to upload your pages to any host of your choosing.