How to Antibiograms

From the main WHONET screen after you have opened your Laboratory:

1) Go to Data analysis – Data analysis
Main Screen.jpg
You will then see the following screen:

2) Click on “Analysis type”

You will then see the following screen:

In the middle of the screen, you will see two options:  1. %RIS and test measurements, and 2. Summary. 

Select “Summary”

For the columns, the default selection is %Susceptible (which is often preferred by clinicians and pharmacists).  You can change this to %Resistant or %Non-susceptible (which is often preferred by microbiologists and epidemiologists).  For the rows, the default selection is “Organism”.  In other words, the results from each species will be summarized in a separate row row in the output. 

Click on “OK” in the bottom right to select the options.

You will now be at the main Data Analysis screen again:

Click on “Organisms”. 

You will then see the following screen:

Click on “Organism groups” and double-click on “All Enterobacteriaeceae”.  Click “OK” to accept the modifications. 

You will again be at the main Data Analysis screen.

Next click on “Data Files”

You will see the following screen:

Navigate to your data file and select “OK”

You will then be back at the Data Analysis Screen

If you would like to remove repeat isolates, you can do this by clicking on “One Per Patient” in the upper right hand side of the screen.

You will then see this screen:

Choose “By patient” and then select “OK”

You will now be at the main Data analysis screen again.

If you would like to choose isolates such as specimen, location, etc. Click on “Isolates”
You will then see the following screen.

Double Click on the isolate you would like and put in the information required, then click on “OK”

You will now be on the main Data analysis screen.

You should next choose where you would like the output.  In the bottom right corner you will see a drop down for “Output to”.  Choose “Screen”. 

Click on “Begin analysis”. If you wish, you can then copy and paste these results to Excel for further editing of the results for distribution to clinical staff.  When you finish reviewing the results, click on “OK” to return to the main analysis screen.

Transferring WHONET results to Excel and other softwares

The WHONET results that you see on the screen can easily be transferred to other softwares such as Microsoft Excel, Word, or PowerPoint.  You can do this either by using “Copy” and “Paste” or by saving the results as a file.


Copy and Paste:  Click on “Copy table”.  Now open Microsoft Excel, for example by clicking on your Windows “Start”, “All Programs” menus and looking for Microsoft Excel.  (Alternatively, if you want to immediately go to your Windows Desktop, click on the “Windows” key on your keyboard and hit the letter D, in other words “Windows”-D.)


      After you have Excel open, go to “Edit”, “Paste”.  The WHONET results are now in Excel.  You can now use Excel to edit, correct, format, or graph your results.


      Now return to WHONET (for example, by clicking on the WHONET icon on the bottom of your screen).  Click on “Copy graph”.  Go back to Excel, find an empty part of the spreadsheet, and again choose “Edit”, “Paste”.



Figure 10.  Copying and pasting results to Excel using “Copy table” and “Copy graph” from WHONET.


Save the file:  WHONET also has an option for saving the results directly to a file.  Because “Copy” and “Paste” works well and is usually very fast, there is often no need to do this, but there are a few situations where saving the results as a table can be useful.  1. For “isolate listings” or “resistance profile listings” with thousands of rows, the “Copy” and “Paste” approach can be very slow.  In this case, saving the results as an Excel or as a text file would be much faster.  2. When you save the table as an Excel file, WHONET does some automatic formatting of the results and automatically makes a number of Excel graphs.  So by using the “Save table” option, this may save you some time formatting the data in Excel.


      To save the tables and graphs as an Excel file, click on “File”.  Give a name to the file, for example “S. aureus RIS results.xls”.  For type of file, select “Excel”.  Notice that the default location for this file is c:\whonet5\output.  Then click ‘OK’. 


Figure 11.  Saving results from WHONET to an Excel file.



Now go back to Excel and select “File”, “Open”.  Look in the folder c:\whonet5\output for the file that you just created, and open it up.  You will see something the following.



Figure 12.  A formatted Excel file created from WHONET.


      Then return to WHONET and click “Continue” to return to the main analysis screen.