The George Washington University (GW) Cancer Institute's Patient Navigation Barriers and Outcomes Tool (PN-BOTTM) is a free, Excel-based data entry, data management and reporting product designed for oncology patient navigation programs. Navigation programs can use the PN-BOTTM to document, track and generate simple reports on information such as:
- Patient volume
- Patient demographic profiles
- Cancer treatment profiles
- Timeliness of cancer care
- Barriers to care
- Navigator caseload and time
- Navigation services provided
- Patient outcomes
Download the Barriers Tool here after taking a brief survey:
Download the PN-BOTTM Quick Start Guide for more information about getting started with PN-BOTTM
PN-BOTTM Version 1.4 is currently only available for PC operating systems running Microsoft Excel (Note: you may encounter compatibility issues if you are running older versions of Excel). PN-BOTTM has undergone extensive development but has not been tested in real world settings in its current form. To avoid data loss, please take precautions and continue to use your regular database systems in conjunction with PN-BOTTM until you have established its compatibility with your setting. We strongly recommend backing up data collected in PN-BOTTM on a regular basis. We encourage you to email us at firstname.lastname@example.org with questions and issues.
Last updated: 4/23/19
- Brief Orientation Video
- Transferring Data from Version 1.0 to Version 1.1
- Don't Lose Your Data! 3 Important Types of "Saves" to Know About
- How to Add a New Patient to PN-BOTTM
- How to Enter and Track Information About Encounters, Barriers and Navigator Actions
- How to Document a Patient Testimonial
- How to Use the Patient Selection Interface and Look Up Previously Entered Information
- How to Remind Yourself of Patient Follow Up
- How to Document Information for Patients with Recurrences or More than One Case
- How to Create Your Own Custom Variables
- How to Use PN-BOTTM's Automatic Reports
- Understanding and Using ID Numbers in PN-BOTTM
- Data Entry Color Meanings in PN-BOTTM
- Archived Webinar: Maximizing PN-BOTTM for Current Users
How much does the PN-BOTTM cost? Is there a regular fee?
PN-BOTTM is provided to all patient navigation programs for free. There is no subscription fee or any other form of charge. PN-BOTTM is copyrighted, so if you intend to use any part of PN-BOTTM for commercial or profit purposes, you must first contact the GW Technology Commercialization Office (email@example.com) and Mandi Pratt-Chapman (firstname.lastname@example.org) to obtain permission.
Is the PN-BOTTM available for Macs, mobile devices, and other platforms?
Currently (as of September 2016), the PN-BOTTM is only available in Microsoft Excel format for use on a PC that runs Windows. PN-BOTTM functionality has been tested and confirmed for Excel versions 2010 through 2016. PN-BOTTM may work for Excel 2007 (untested) but will likely not be compatible with versions older than this. PN-BOTTM will not work properly for Mac versions of Excel nor for online platforms (for example, Excel online or Google sheets) because the macros required for functionality are not supported on these platforms. There are no plans at present to develop additional versions of PN-BOTTM, but the possibility is open with additional resources and support.
Can PN-BOTTM integrate with my organization’s electronic health record system?
Not at present. PN-BOTTM is a Microsoft Excel file, with the same capabilities and limitations as other Excel documents that you may be familiar with. If your hospital or organization’s electronic health record system can interface with Microsoft Excel, it might be possible with a little work to align the raw data in PN-BOTTM’s List sheets to import or export data. However, we have not tested any form of PN-BOTTM integration. If you have success in this area, please let us know (email@example.com).
How can I share PN-BOTTM with multiple navigators?
Currently (as of September 2016) PN-BOTTM does not support simultaneous data entry or report running. PN-BOTTM is essentially a macro-enabled Microsoft Excel document, and has all of the same sharing limitations inherent in the platform. It cannot be edited by multiple people at the same time, and it will take a few extra steps to share among navigators. In order to use PN-BOTTM to aggregate data across navigators, there are a couple of workaround options. The appropriateness of each option will depend on your organization’s infrastructure and your program’s needs. Consider the following factors:
Which sharing options are possible in my setting?
Option 1: Single copy of PN-BOTTM
Option 2: Multiple copies of PN-BOTTM
How do I get aggregate program-wide reports across navigators if they are each using a separate copy of PN-BOTTM (sharing option 2)?
If aggregate reports are desired, make sure that the same set of variables are selected in the Set Up sheet of all copies of PN-BOTTM in use so that all navigators collect the same set of desired data. You have two options for aggregating reports across copies of PN-BOTTM:
Can I use the patient’s medical record number as the Client ID?
Yes. You may use any unique string of letters and/or numbers for a client’s ID number. You may choose to use sequential numbers, the patient’s medical record number or anything else that makes sense to you. It is most important to make sure each patient only has one ID number and each ID number only belongs to one patient.
Note: If you manually assign a numeric Client ID number with a value of 9999999999 or greater, future attempts to use the “Get New Client ID” button will result in an error message, disabling the auto-numbering feature.
What do I do if I accidentally delete a patient’s record?
When you select “Delete Patient Record (Permanent),” you will receive a message confirming whether you really do want to delete the record. Once you select “yes” in response to the message, the patient record will be permanently deleted and there is no way to retrieve it. Therefore, we recommend regularly backing up your data and exercising caution when deleting.
Can I enter back-enter data for things that happened in the past?
Yes. In some Data Entry forms, date fields might default to today’s date to help make data entry go faster when you are entering data on the same day. However, if you are back-entering data on a different date, you can easily change these fields to reflect the actual dates that events occurred. Just click in the date field and type or select the date that you want.
What if my patient has a recurrence or multiple cases? How do I document that?
If the patient does not have any records documented in PN-BOTTM, enroll the patient as you would any other patient. You may choose to use the “Recurrence?” data field in the Case Data Entry sheet to capture whether or not the patient’s case involves a first-time primary cancer diagnosis or recurrence.
If the patient already has a previously documented case in PN-BOTTM from a previous bout with cancer, a second case can be created to document the recurrence as a separate navigated episode without overwriting information from the first case. Select the patient in question from the dropdown in the Case Data Entry sheet. Then click on the “Add New Case” button to start a new blank form to use for the patient’s second case.
I got a Microsoft Visual Basic error message. Buttons that I should be seeing have disappeared and PN-BOTTM is having issues. What do I do?
Microsoft Visual Basic errors have buttons that say things like “End,” “Debug,” and “Help” and look something like this (individual error message may vary):
This section is NOT referring to other error messages that PN-BOTTM may give you to try to prevent data entry mistakes.
PN-BOTTM contains a lot of programming on the back end, and Microsoft Visual Basic error messages tell you that something went wrong in the middle of running the code. In some (but not all) instances, buttons may disappear following an error message because the program got interrupted by the error before it could reach the command telling PN-BOTTM to display the appropriate buttons.
We hope you do not come across error messages, but if you do, just SAVE, CLOSE, and RESTART PN-BOTTM:
Please report the issue you encountered using the PN-BOTTM feedback form on our website so that we can try to address it in the event of future PN-BOTTM development. It would be very helpful if you could send us:
Can I assign my own Case ID or Encounter ID numbers?
Case ID numbers uniquely identify each case and Encounter ID numbers uniquely identify each encounter. Although it is no problem to assign your own patient-level Client ID numbers, you generally cannot assign your own Case or Encounter ID numbers. PN-BOTTM generates Case ID numbers automatically in sequential order when each case is first created. PN-BOTTM generates Encounter ID numbers automatically in sequential order when each encounter is created. Attempting to edit Case or Encounter ID numbers from the respective Data Entry sheets will result in an error message because those data entry fields are protected.
There is one important caveat to this discussion. If your program plans to pool data from multiple PN-BOTTM files to generate aggregate reports, you will end up with a big data set with overlapping Case and Encounter ID numbers that refer to different cases and encounters and therefore no longer serve as unique identifiers. If you know that you want to pool data, it will be important to plan ahead and set up each navigator’s copy of PN-BOTTM to use a different set of ID numbers that will never overlap. PN-BOTTM will always simply add one to the largest ID number in each List sheet when automatically assigning ID numbers of any type. This overlapping ID number issue can be avoided with a simple tweak in the respective List sheets.
For example, imagine that a program has three navigators using three separate copies of PN-BOTTM, and each will be documenting her own encounters that will be combined later for reporting purposes. If you don’t do anything, PN-BOTTM will start Encounter ID numbering at 1 in each copy of PN-BOTTM which will result in three different encounters with an ID of “1”. To avoid this, the first navigator should change the value of the “Encounter ID” in the “Encounters List” sheet for “First Example Patient” from “1” to “20000”. Now her encounters will get assigned ID numbers in the range of “20001”, “20002”, “20003” etc. The second navigator can change the value of the “Encounter ID” in the “Encounters List” sheet for “First Example Patient” in her copy of PN-BOTTM from “1” to “40000”. Now her encounters will get assigned ID numbers in the range of “40001”, “40002”, “40003” etc. The third navigator can leave her copy of PN-BOTTM alone and use the default “1”, “2”, “3” numbering. Unless the navigators conduct more than 20,000 encounters, their Encounter ID numbers will not overlap when their encounters data is combined.
I know I entered data for _____. Why don't I see it in the report?
Data cleaning is an essential part of creating reports. If you entered data into PN-BOTTM and you are not seeing the numbers that you expect in the automatic reports, there can be a few reasons why. Go through the list below sequentially to troubleshoot.
What if I want a report of summary statistics for a time period other than a calendar year?
To see summary statistics for your own custom date ranges, you have the option to explore PN-BOTTM List sheets. Filter the data table in the List sheet by your date criteria of interest. Then, highlight the data in the column containing your variable of interest. The bottom right corner of Excel will automatically display an average, count and sum of that variable. Always remember to clear all filters before leaving the sheet once you are done.
I just entered my first patient in the Patient Data Entry sheet and saved the record, but that patient is not showing up in Case Data Entry or any patient selection drop down menus. What's wrong?
Make sure that your Excel options are set to automatically add new rows to tables. To do this in Excel 2010, go to the "File" tab, then "Options", then "Proofing," then "AutoCorrect Options", then "AutoFormat As You Type". Make sure that the option "Include new rows and columns in table" is checked.
Why do I see a previously entered patient's information when I want to enter information for another patient in the Encounters Data Entry sheet?
The Encounters Data Entry sheet has a quirk that was necessary to incorporate for the technical functioning of the sheet. Normally, all form fields remain hidden until you click one of the 2 radio buttons at the top of the sheet: "Add a new Encounter" or "Update an Existing Encounter." However, if you save the PN-BOT file at any point while entering data, this will unhide all form fields in the Encounters Data Entry sheet. When this happens, you will see all Encounters Data Entry form fields with previously entered information in them. However, you will also be missing the grey "Save" button for this page, so you are not in any danger of saving a previously entered patient's information to the wrong patient.
To clear the Encounters Data Entry form and proceed with data entry, just select a patient and click either of the 2 radio buttons at the top of the sheet. Doing so will clear out any old information from the form fields and will make the grey "Save" button appear. Never attempt to enter data into the Encounters Data Entry sheet without first selecting a patient and clicking one of the 2 radio buttons.
Why do dates in my _____ List sheet look like a strange number instead of a date?
You may see a strange five digit number like 35236 somewhere in a List sheet data table where you expect to see a date. If so, that means that the variable type is incorrectly set to something other than a date type. To fix this, unprotect the sheet. Then, select all data for the column in question. From the Excel menus at the top of your screen, select the “Home” ribbon tab, look in the “Number” group of functions, and click on the dropdown of variable type options to select “Short Date.”
Note: If you are seeing strange numbers only for some entries at the bottom of the sheet, it may indicate that those specific entries have not been included in the data table. If this is the case, you'll also notice that those bottom entries are also missing other formatting such as background shading. To fix this make sure that your Excel options are set to automatically add new rows to tables by following instructions in the previous section.
What could be the long-term implications of PN-BOTTM utilization?
PN-BOTTM was designed with the diversity of oncology patient navigation programs in mind. Each program has its own unique set of priorities and circumstances, and the best way to utilize PN-BOTTM will depend largely on those program-specific factors.
Some keys to successful PN-BOTTM use include:
With successful long-term PN-BOTTM use, the navigation program will have a strong longitudinal data set of navigated patients and services provided. Such data can provide powerful evidence that can be used for evaluation, research, program coordination, resource allocation or quality improvement purposes.
How can patients benefit from the PN-BOTTM?
PN-BOTTM is designed to help navigators stay on top of patient barriers to care and follow up needed. Patients may benefit from potential improvements in navigation services. PN-BOTTM reports provide synthesized evidence to help navigation programs identify potential issues with timeliness to care, common barriers to care and gaps in services, program reach, and navigator effort. This information can be used to guide decisions about care improvements, new services needed, outreach efforts and navigation staffing.
The George Washington University (GW) owns copyrights to the Patient Navigation Barriers and Outcomes ToolTM (PN-BOTTM) and associated materials, created by GW Cancer Center and available at www.gwcancerinstitute.org.
All users agree to hold GW harmless and to indemnify GW for all liabilities, demands, damages, expenses and losses arising out of use of GW Cancer Center materials for any purpose. All users agree that use of PN-BOTTM is voluntary and users are solely responsible for all data entered therein. GW is not responsible for any loss or diminution of data that arises from the use of PN-BOTTM.
All users agree not to claim, infer, or imply GW endorsement of the user’s activities.
PN-BOTTM and associated materials are provided AS IS, WITH NO WARRANTIES, EXPRESS OR IMPLIED, INCLUDING ANY WARRANTY OF MERCHANTABILITY OR FITNESS FOR A PARTICULAR PURPOSE, and with no representations that the use of GW Cancer Center materials will not infringe any patent or proprietary rights of third parties. There is no agreement between GW and users regarding the use or modification of PN-BOTTM.
For internal use of the PN-BOTTMby non-profits to track patient navigation services, please utilize the acknowledgement: “The Patient Navigation Barriers and Outcomes ToolTM is utilized courtesy of the George Washington University.”
Distribution and modification of PN-BOTTM is permissible in alignment with the posted user guide. Sales, incorporation into existing commercial applications or creation of derivative works from PN-BOTTM require a commercial license from GW: Please contact the GW Technology Commercialization Office at firstname.lastname@example.org and copy email@example.com.
©2016 by the George Washington University
The development of the PN-BOTTM was funded by a grant from Genentech.