User’s Manual



User’s Manual

HOSPITAL ASSESSMENT TOOL (HAT 1.0) SPREADSHEET

[pic]

Nagaveena Raman

Ashok Kumar

Abhilash Vijayan

University of Toledo

Chapter 1

How to Begin

1. System Requirements:

To run Hospital Assessment Tool Spreadsheet, you need the following:

• A PC with an Intel Pentium Processor (or 100 % compatible)

[pic] 32 MB RAM or higher recommended

[pic] Hard disk (minimum 10MB space to start with)

[pic] Windows 95, 98, 2000 or NT (Windows 2000 recommended)

[pic] A mouse or compatible pointing device

[pic] A VGA monitor (15 inch VGA or higher recommended)

[pic] An Internet connection

[pic] A suitable browser (Internet Explorer 5.0 recommended)\

[pic] MS Excel 2000

2. Installing Energy Assessment tool:

[pic] Connect to the Internet and open the browser window

[pic] Type in the URL:

[pic] Click on the icon: Hospital Assessment Tool version 1.0

[pic] Download the Excel file (.xls) named Hospital Assessment Tool

[pic] Soon, an Excel spreadsheet will open

[pic] Click on the save icon of the Excel file

[pic] The following window appears:

[pic]

Figure 1

Save the tool onto your desktop. The circled area in the figure above should show “Desktop” before the “save” button on the bottom right-hand corner is clicked.

Chapter 2

Working with the Tool

This chapter gives you the instructions on using the tool. We hope this helps to clear any lingering doubts that you might have.

The tool is an Excel document, which means there are two ways to open the tool:

First, Open MS Excel and select the Open option from the File option as shown below:

[pic]

Figure 2

This will open a window, wherein you must browse to the folder where you have saved the tool.

[pic]

Figure 3

The second method is to open the tool using Windows Explorer. Navigate through the Explorer to the folder where you have saved the tool.

The Spreadsheet

The HAT 1.0 is basically a questionnaire which consists of 208 questions divided into different sections depending on the category under which a question falls. There are 8 different sections in the tool namely

1. Storage

2. Waste

3. Training

4. Acts

5. Equipment

6. Mercury

7. Treatment

8. Red Bag Waste

There is another section named “Suggestions” that helps the hospitals in understanding different avenues for improvement by giving cleaner alternatives.

Various inputs required for these sections are discussed below:

1. Storage

a) Waste storage areas

b) Waste carrying containers

c) Labeling

d) Inspection of waste

e) MSDS

[pic]

Screenshot of the worksheet showing storage

2. Waste

a) Types of wastes

b) Non-toxic alternatives

[pic]

Screenshot of the worksheet showing waste

3. Training

a) Departments where training is required

b) Waste Management Systems

c) Employee training

[pic]

Screenshot of the worksheet showing training

4. Acts

a) Purchasing policies

b) Accreditation of hospital

[pic]

Screenshot of the worksheet showing Acts

5. Equipment

a) Type of equipment

b) Maintenance

c) Functions

[pic]

Screenshot of the worksheet showing equipment

6. Mercury

a) Mercury audit

b) Replacement of instruments

c) Disposal

[pic]

Screenshot of the worksheet showing Mercury

7. Treatment

a) Various treatment technologies

b) Recycling techniques

[pic]

Screenshot of the worksheet showing treatment

8. Red Bag Waste

a) Disposal methods

b) Amount of waste

c) Packaging techniques

[pic]

Screenshot of the worksheet showing Red bag waste

HAT 1.0 gives sectional score and each section has a range of scores that indicates the category under which the section falls. The scoring method is explained below:

|Category |Sectional Percentage Required |Overall Score (Tool) Required |

|Excellent |80% |175-208 |

|Good |70-80% |150-175 |

|Poor |60-70% |125-150 |

|Very Poor |< 60% |< 125 |

The sectional score helps in zeroing into the section which needs more attention to improve the overall quality of the hospital. The results and the graphs are attached for easy understanding of the score. On answering the questions the tool automatically gives the category under which each section falls and also graphically shows which section of the hospital needs to follow best management practices to reduce the problem due to wastes.

[pic]

Screenshot of the worksheet showing results

[pic]

Screenshot of the worksheet showing results

The last sheet of the tool is allotted for suggestions. This sheet gives best management practices for each of the above mentioned sections that reduce the pollution and the harmful effects due to wastes.

[pic]

Screenshot of the worksheet showing suggestions

[pic]

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download