Unfired Pressure Vessel Macro July 2005 Instructions

Unfired Pressure Vessel Assessor
(Updated for July 2005)
A Microsoft Excel macro to assist with the assessment of unfired pressure vessels in relation to licences to operate them under Part 4 (Plant) of the Occupational Health and Safety (Commonwealth Employment) (National Standards) Regulations 1994.
Comcare Australia 2005
Comcare Unfired Pressure Vessel Assessor, 1 July 2005 Version
Unfired Pressure Vessel Assessor

(Updated for July 2005) A licence to operate certain unfired pressure vessels is required under Part 4 (Plant) of the Occupational Health and Safety (Commonwealth Employment) (National Standards) Regulations 1994 (the Regulations). These pressure vessels are detailed under Item 1, of Part 2, of Schedule 6 of the Regulations. From 1 July 2005, the Regulations require Australian Standard 4343-1999 to be followed when determining whether a licence is required. This assessor (using a Microsoft Excel macro) has been developed to assist in determining whether or not a pressure vessel should be licensed. The assessor can be downloaded from Comcares website at www.comcare.gov.au. This assessor should NOT be used to assess Boilers. Double click on the file "Unfired Pressure Vessel Assessor (July 2005)" or open the file from Microsoft Excel. The assessor should run automatically. If not, you may need to alter the security settings for Excel. The opening screen.
You can assess "Cylindrical Vessels" or "Rectilinear Vessels". Click on the relevant button.
1
Input Pressure Vessel details screens. There is one input screen for cylindrical vessels and one for rectilinear vessels.
1. Select the unit of length measurement (Measurement Base) defaults to Centimetres. 2. Input the length of the vessel *. 3. Input the other dimension(s). For cylindrical vessels you must specify whether this is Radius, Diameter or Circumference (whichever is easiest to measure) *. 4. Input the DESIGN PRESSURE and select the unit of measurement *. NOTE: Design Pressure and Working Pressure can be assumed to be the same for most applications. 5. Select the DESIGN TEMPERATURE (or operating) range. 6. Input a serial number or letters to identify the pressure vessel on the printed results. Note: Items 4, 5, and 6 should be found stamped on the hard shell of the vessel, or on a metal plate attached to the vessel. If not, seek advice from the manufacturer or supplier.
The assessor will convert dimensions to Metric units of measurement when determining the hazard level. The results are expressed in Metric units.
Click on "Exit" to stop the assessor and close Microsoft Excel, or When you are satisfied that your input data is correct, click on "Next" * to continue with the assessment.
(* If details are not entered for dimensions and Design Pressure you will be prompted to enter them before proceeding.)
Input Service Factors screen
The multiplication factors are listed in Australian Standard 4343-1999, Note 4(a) to Table 1. Notes 4(a)(i) to (iii): If a single item applies, the multiplication factor is 3. For two or more items, the multiplication factor is 10. OR Notes 4(a)(iv) Selecting this item overrides items (i) to (iii). The multiplication factor is 3.
This screen allows you to select those factors (or none, which is the default condition). Note There is also a multiplication factor of 30 listed in Note 4(b). This is automatically applied if the Design Pressure exceeds 50 Mega Pascals (MPa). It overrides any factor selected on this screen.
Click on "Exit" to stop the assessor and close Microsoft Excel. Click on "Clear" to remove all selected items. Click on "Back" to return to the Input Pressure Vessel details screen. Click on "Next" to continue.
Input Content details screen
This screen allows you to select the type and state of the contents of the pressure vessel. 1. Select the Hazard Type. Some examples of fluids (gases or liquids) in the various hazard types are given for your guidance. You may also need to refer to Table 2 of AS 4343-1999 and the Hazardous Substances Information System found at http://www.nohsc.gov.au/applications/hsis for further information. 2. Select the Content Type, either gas or liquid. Note: If the Design Temperature of the vessel is over 90o Centigrade, Non-Harmful gasses or liquids are rated as Harmful in accordance with the Standard. The Hazard Type will be automatically selected as Harmful in the above screen and shown as Harmful on the results screen and printout.
Click on "Back" if you need to return to the Input Service factors screen, or Click on "Next" to complete the assessment and view the results.
Pressure Vessel Assessment Result screen.
This area is used to display messages about the multiplication and other factors used in determining the hazard level
The result of the assessment is presented as shown above. All linear measurements are converted into Centimetres (cms), volumes to Litres, and pressures to Mega Pascals (MPa). Note that the calculated Mega Pascal/ Litre (MPaL) values are rounded up to the number of decimal places shown on the screen. This may result in slight inconsistencies between the displayed values. The unrounded values are used in determining whether or not a vessel should be licensed. Click on "Print" to print this result on the default printer. You may want to keep the 'hard copy' for your records. Click on "Rerun Cylindrical or Rerun Rectilinear" to return to the relevant "Input Pressure Vessel Details" screen if you need to perform an assessment for another pressure vessel. (Note: the details that you have previously entered are preserved so that if you want to create a printed record for a range of similar vessels, you only have to make minimal changes to obtain a result for each vessel). Click on "Exit" to stop the assessor and close Microsoft Excel.
5

Unfired Pressure Vessel Macro July 2005 Instructions

Uploaded by

Copyright:

Available Formats

Unfired Pressure Vessel Macro July 2005 Instructions

Uploaded by

Document Information

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Unfired Pressure Vessel Macro July 2005 Instructions

Uploaded by

Copyright:

Available Formats

Unfired Pressure Vessel Assessor

(Updated for July 2005)

Comcare Australia 2005

Comcare Unfired Pressure Vessel Assessor, 1 July 2005 Version

Unfired Pressure Vessel Assessor

Comcare Unfired Pressure Vessel Assessor, 1 July 2005 Version

Comcare Unfired Pressure Vessel Assessor, 1 July 2005 Version

Input Service Factors screen

Comcare Unfired Pressure Vessel Assessor, 1 July 2005 Version

Input Content details screen

Comcare Unfired Pressure Vessel Assessor, 1 July 2005 Version

Pressure Vessel Assessment Result screen.

You might also like