Docstoc

Asbestos Migration Spreadsheet

Document Sample
Asbestos Migration Spreadsheet Powered By Docstoc
					v1.3 16/05/2011

Key                              PLANON ASBESTOS SURVEY DATA TEMPLATE

PART OF ID, MANDATORY            (WHITE ON RED) These columns hold the unique ID code and survey date for each asbestos r
                                 When re-surveying the same occurrence of asbestos, the same ID needs to be used.
                                 For historic records, the survey date will be automatically appended. Therefore, do not use m
                                 The value used MUST NOT conflict with an existing maintenance asset ID, which a numeric. I

MANDATORY FIELD                  (WHITE ON BLUE) This manadatory field is not necessarily unique

CALCULATED FIELD                 (BLACK ON GREY) This column will be calculated automatically when the survey data is uploa

OPTIONAL FIELD                   (WHITE ON GREEN) This column is optional.

string(30)                       Indicates the data type and maximum length for the field - anything beyond the limit will be

File paths                       Sub folders are permitted if necessary, but file and folder names should not contain any spac
Images:                          \\fm07\Asbestos\images\
Bulk sample certificate(s):      \\fm07\Asbestos\bsc\
Survey Information               \\fm07\Asbestos\si\
POW/ASB5/RA's                    \\fm07\Asbestos\pow-asb5-ra\
Smoke test certificate(s):       \\fm07\Asbestos\stc\
Waste Consignment Note           \\fm07\Asbestos\wcn\
Drawing / Plans:                 \\fm07\Asbestos\cad\
Reassurance test certificate:    \\fm07\Asbestos\rtc\
Other Information                \\fm07\Asbestos\oi\
Air Monitoring Certification     \\fm07\Asbestos\amc\
Analytical handover report:      \\fm07\Asbestos\ahr\

Surveying Company
This field needs to contain the Agresso supplier number.
The Agresso supplier number for White Young Green is: 36370

Image formula
=IF(ISBLANK(H8),"","<img src="""&SUBSTITUTE(SUBSTITUTE(lower(H8),"\\fm07\asbestos\images","http://fm07/asbestos/imag

Migration spreadsheet filename
Asset survey upload.xlsx       This spreadsheet must reside in the "Inbound" asbestos interface folder and its filename mus
 D code and survey date for each asbestos record and are mandatory
 tos, the same ID needs to be used.
matically appended. Therefore, do not use more than 8 characters.
 g maintenance asset ID, which a numeric. It is therefore recommended that all asbestos IDs begin with an "A".




 utomatically when the survey data is uploaded. There is no need to populate this column as part of the survey




 he field - anything beyond the limit will be truncated.

d folder names should not contain any spaces, e.g., \\fm07\Asbestos\images\folder1\170209PRJ10.JPG




estos\images","http://fm07/asbestos/images"),"\","/") & """>")


bestos interface folder and its filename must match the contents of cell B39.
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               PRIORITY ASSESSMENT
                                                                                                                            ASBESTOS MATERIAL SAMPLE LOCATION AND DESCRIPTION                                                                                                                                                                                                          MATERIAL CONDITION ASSESSMENT                                                                                            Likelihood of Disturbance
Asbestos ID        Property Code       Floor Code          Space Code          Material Description                                     Sample Photo                                  Sample Photo (2)                                                 Inspection Type            Inspection Result       Product Type                        Extent of damage                                         Surface Treatment                 Asbestos Type          Surveyor Recommendation   Extent              Extent Range                                     Notifiable             Surveying Company         Surveyor            Survey Date   Survey Type                      Laboratory Name     Analysis Date   Sample No.          Certification No.   Asbestos Abatement W orks   Date of completion of abatement works   Name of contractor   Bulk sample certificate(s)      Survey Information              POW /ASB5/RA's                  Smoke test certificate(s)       W aste Consignment Note         Drawing / Plans                   KPI Documentation               Other Information               Air Monitoring Certification    Analytical handover report
String (8 Chars)   String (15 Chars)   String (50 Chars)   String (15 Chars)   String (50 Chars)                                        Complete UNC path to image (100 chars)        Calculate in spreadsheet (100 chars)                             (Use drop-down list)       (Use drop-down list)    (Use drop-down list)                (Use drop-down list)                                     (Use drop-down list)              (Use drop-down list)   (Use drop-down list)      String (30 Chars)   (Use drop-down list)                             (Use drop-down list)   Agresso supplier number   String (30 Chars)   dd/mm/yyyy    (Use drop-down list)             String (30 Chars)   dd/mm/yyyy      String (20 Chars)   String (30 Chars)   String (100 Chars)          dd/mm/yyyy                              String (50 Chars)    Complete UNC path to document   Complete UNC path to document   Complete UNC path to document   Complete UNC path to document   Complete UNC path to document   Complete UNC path to document     Complete UNC path to document   Complete UNC path to document   Complete UNC path to document   Complete UNC path to document

A6141              930                 00                  G/001               Redundant Bakelite light switch and socket                \\fm07\Asbestos\images\930\Leahurst Yard A                                                                    Re-inspection/Update [2]   Presumed Asbestos [2]   Reinforced Composite - resins [2]   Good Condition - No visible damage [1]                   Composite Material - resins [2]   Chrysotile [1]         Remove [11]               2 No.               Small amounts or items i.e. gaskets / rope [1]   Non-notifiable [1]     36370                     Tom Sendall         11/24/2010    Type 2 - Standard Sampling [2]
                                                                                                                                         (2).jpg                                      <img src="//fm07/asbestos/images/930/leahurst yard a (2).jpg">                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    \\fm07\Asbestos\cad\930_cad\930-00.pdf
ASBESTOS TYPE
Chrysotile [1]
Amosite [2]
Amosite/Chrysotile [3]
Crocidolite [4]
Crocidolite/Chrysotile [5]
Unknown (Presumed) [6]
Chrysotile, Amosite & Crocidolite [7]
Other Amphiboles (Anthophylite, Tremolite, Actinolite) [8]
N/A [0]




OK
ASSET GROUP                             MGT RECOMMENDED ACTION
Loose insulation [ASB.01]               Review in 12 months [1]
Sprayed coatings [ASB.02]               Re-Assess in 6 months [2]
Thermal insulation [ASB.03]             Re-Assess in 3 months [3]
Asbestos boards [ASB.04]                Action within 3 months [4]
Paper, felt & cardboard [ASB.05]        Immediate Action Required [5]
Ropes, yarns & cloths [ASB.06]          No further action required [6]
Friction products [ASB.07]
Asbestos cement products [ASB.08]
Other encapsulated materials [ASB.09]
Floor coverings [ASB.10]
Unknown (licensable) [ASB.11]




                                        OK
SURVEYOR RECOMMENDATION
Immediate Removal [1]
Control space access but then Remove [2]
Encapsulate the material then/or Remove [3]
Repair/Re-encapsulate & Label (Remove if redundant [4]
Repair/Re-encapsulate & Label [5]
Label & Monitor (Remove if redundant) [6]
Label & Monitor [7]
No Action Required [8]
Manage [9]
Remedial work required [10]
Remove [11]
Survey [12]




OK
PRODUCT TYPE                                   EXTENT OF DAMAGE
Reinforced Composite - plastics [1]            Good Condition - No visible damage [1]
Reinforced Composite - resins [2]              Low Damage - few surface scratches [2]
Reinforced Composite - mastics [3]             Low Damage - broken board edges [3]
Reinforced Composite - roofing felts [4]       Medium Damage - significant breakage of material [4]
Reinforced Composite - vinyl floor tiles [5]   Medium Damage - several small damaged areas [5]
Reinforced Composite - cements [6]             High Damage or breakup of asbestos material [6]
Asbestos insulated Board [7]                   Visible asbestos debris [7]
Asbestos Textiles [8]                          Unknown (Presumed) [8]
Asbestos Gaskets [9]                           N/A [0]
Asbestos Ropes [10]
Asbestos Paper [11]
Thermal Asbestos Insulation [12]
Sprayed Asbestos [13]
Loose Asbestos [14]
Asbestos packing [15]
Textured Coatings [16]
Bitumen [17]
Millboard [18]
Dust/Debris [19]
Unknown [20]
N/A [0]




OK                                             OK
SURFACE TREATMENT                                             INSPECTION TYPE
Composite Material - reinforced plastics [1]                  Initial Survey [1]
Composite Material - resins [2]                               Re-inspection/Update [2]
Composite material - vinyl floor tiles [3]
Enclosed asbestos sprays and insulation [4]
Enclosed asbestos gaskets, ropes, flash guards [5]
Asbestos Board with exposed face painted/encapsulated [6]
Unsealed Asbestos Board [8]
Encapsulated Asbestos insulation and sprays but exp [9]
Unsealed Asbestos Insulation [10]
Unknown (Presumed) [11]
Asbestos cement with exposed face painted/encapsulated [12]
Exposed asbestos cement [13]
Enclosed asbestos paper, cloth, textiles [14]
Exposed asbestos paper, cloth, textiles [15]
Exposed asbestos ropes, flash guards [16]
N/A [0]




OK                                                            OK
INSPECTION RESULT                DISTURBANCE POTENTIAL
No Asbestos Detected [1]         Minor Disturbance - possible contact gaining access [1]
Presumed Asbestos [2]            Low Disturbance - possible disturbance during main [2]
Strongly Presumed Asbestos [3]   Medium Disturbance - maintenance activity requires [3]
ASBESTOS FOUND [4]               High Disturbance - major maintenance activity [4]
                                 N/A [0]




OK                               OK
LOCATION SPACE                    ACCESSIBILITY
Outdoors [1]                      Asbestos material usually inaccessible [1]
Well ventilated large space [2]   Asbestos material unlikely to be disturbed [2]
Internal space up to 100m2 [3]    Asbestos material may occasionally be disturbed [3]
Confined spaces [4]               Asbestos material will be easily disturbed [4]
N/A [0]                           Asbestos material is routinely disturbed [5]
                                  Asbestos disturbance unknown [6]
                                  N/A [0]




OK                                OK
EXTENT RANGE                                     OCCUPANT RANGE
Small amounts or items i.e. gaskets / rope [1]   None [1]
Less than 10 sq m [2]                            1 to 3 persons [2]
Less than 10 m run [3]                           4 to 10 persons [3]
10 to 50 sq m [4]                                more than 10 persons [4]
10 to 50 m run [5]                               N/A [0]
More than 50 sq m [6]
More than 50 m run [7]
Unknown Quantity [8]
N/A [0]




OK                                               OK
USAGE FREQUENCY                                 AVERAGE TIME OF USE                   NORMAL ACTIVITY
                  1   Infrequent use of space          1 Occupied Less than 1 hour          1
                  2   Monthly use of space             2 Occupied 1 to 3 hours              2
                  3   Weekly use of space              3 Occupied 3 to 6 hours              3
                  4   Daily use of space               4 Occupied more than 6 hours         4
NORMAL ACTIVITY                         FREQUENCY
        Rare disturbance activity       Asbestos Material unlikely to be disturbed for main [1]
        Low disturbance activity        Access is required for Annual maintenance activity [2]
        Periodic disturbance activity   Access is required for Monthly maintenance activity [3]
        High disturbance activity       Access is required for Weekly maintenance activity [4]
                                        N/A [0]




                                        OK
AVERAGE TIME OF USE              NORMAL ACTIVITY
Occupied Less than 1 hour [1]    Rare disturbance activity [1]
Occupied 1 to 3 hours [2]        Low disturbance activity [2]
Occupied 3 to 6 hours [3]        Periodic disturbance activity [3]
Occupied more than 6 hours [4]   High disturbance activity [4]
N/A [0]                          N/A [0]




OK                               OK
USAGE FREQUENCY               MANAGEMENT PRIORTIY RANKING   NOTIFIABLE
Infrequent use of space [1]   Very Low [1]                  Non-notifiable [1]
Monthly use of space [2]      Low [2]                       Notifiable [2]
Weekly use of space [3]       Medium [3]                    Unknown [3]
Daily use of space [4]        High [4]                      N/A [0]
N/A [0]                       Urgent [5]




OK                            OK                            OK
SURVEY TYPE                         INSPECTION TYPE            FLOOR CODE
Type 1 - Locate & Assess [1]        Initial Survey [1]         00
Type 2 - Standard Sampling [2]      Re-inspection/Update [2]   01
Type 3 - Full Access Sampling [3]                              01M
No Access (Presume Asbestos) [4]                               02
                                                               02M
                                                               03
                                                               03M
                                                               04
                                                               04M
                                                               05
                                                               06
                                                               07
                                                               08
                                                               09
                                                               10
                                                               B
                                                               BM
                                                               GM
                                                               LB
                                                               LG
                                                               LGM
                                                               R
                                                               UG
                                                               X




OK                                  OK
FLOOR TYPE NAME
Ground Floor
First Floor
First Floor Mezzanine
Second Floor
Second Floor Mezzanine
Third Floor
Third Floor Mezzanine
Fourth Floor
Fourth Floor Mezzanine
Fifth Floor
Sixth Floor
Seventh Floor
Eight Floor
Ninth Floor
Tenth Floor
Basement
Basement Mezzanine
Ground Floor Mezzanine
Lower Basement
Lower Ground Floor
Lower Ground Mezzanine
Roof
Upper Ground Floor
TBC
V1.0
V1.1
V1.2
v1.2
v1.2
v1.2
v1.3




v1.3

       Background test certificates -> Air monitoring certification
       Certificate of reoccupation -> Waste consignment note
       Leak air tests -> Other information
       Plans of work -> POW / ASB 5 / RA's
       Reassurance test certification -> KPI documentation
First official release
Additional information added to the "Read me first" sheet to detail the folder locations needed for file storage.
Updated the photo URL formula (on the "Read me first" tab) to ensure it is not tripped up by capital letters.
Added "Change History" tab.
Added the required filename to the "Read me first" sheet.
Specified 100 character limit on photo fields - added validation
File paths changed as per instructions from Mike Eastwood (see "Read me first" sheet for latest paths):
ASB5 -> SI
BTS -> AMC
COR -> WCN
LTC -> OI
POW -> POW-ASB5-RA
RTC -> KPI
Field display names changed as per instructions from Mike Eastwood (see "ASBESTOS MASTERDATA" for latest field display n
ASB 5 -> Survey information
Background test certificates -> Air monitoring certification
Certificate of reoccupation -> Waste consignment note
Leak air tests -> Other information
Plans of work -> POW / ASB 5 / RA's
Reassurance test certification -> KPI documentation
or latest field display names)

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:5
posted:12/29/2011
language:
pages:20