{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["1.  Intro, Def's, Change Log","2. Hazard List","3. Risk Assessment Tables","Items_Issues Tracking"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":12,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"1.  Intro, Def's, Change Log","index":0,"n_rows":27,"n_cols":6,"rows_kept":27,"cut":false,"hidden":false,"merged":[[31,3,31,5],[30,3,30,5],[28,3,28,5],[29,3,29,5],[2,5,5,5],[17,3,17,5],[27,3,27,5],[25,3,25,5],[26,3,26,5],[6,1,7,3],[12,3,12,5],[13,3,13,5],[22,3,22,5],[23,3,23,5],[24,3,24,5],[18,3,18,5],[20,3,20,5]]}
[]
[null,null,null,null,"Document #","Status"]
[null,null,null,null,"TBD","Revision A"]
[null,null,null,null,"Author(s)"]
[null,null,null,null,"Norm Picker"]
[]
[]
[]
[null,"Document Title"]
[null,"LDMX Hazard List"]
[]
[null,"Purpose"]
[null,null,null,"It is imperative to identify and mitigate hazards associated with experiments. Various Hazard Analysis methods are available. Often there is an overall project hazard analysis supported by hazard analyses of certain subsystems or certain safety aspects (e.g., fire hazard). This \"Hazard List\" is one such method to capture the overall project hazard analysis for LDMX.  The yet to be written, Preliminary Hazard Analysis Report, will describe the hazard analysis methodology in detail.  This approach is an important aspect of System Safety Engineering which seeks to ensure that experiments are designed with integral safety features considering installation, operation, and maintenance. Lastly, the system safety engineering process examines risk to personnel safety, the environment (air, water, soil), equipment and the facility."]
[null,"Definitions"]
[]
[]
[]
[null,"References"]
[]
[]
[]
[null,"Change Log"]
[]
[]
[]
[null,"Date","Revision","Description"]
[null,"2021-05-17","A","DRAFT Preliminary Hazard List."]

{"sheet":"2. Hazard List","index":1,"n_rows":69,"n_cols":21,"rows_kept":69,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,null,null,null,null,{"$f":"'1.  Intro, Def''s, Change Log'!B10","v":"LDMX Hazard List"}]
[]
[null,null,null,null,null,null,null,null,null,"Revision Date:  May 17, 2021",null,null,null,null,null,null,null,null,null,null,{"$f":"NOW()","v":"2021-05-17T21:53:36.120"}]
[]
[null,null,"Hazard Identification",null,null,"Un-Mitigated Hazard and Risk Level",null,null,null,null,null,null,"Mitigation Method / Updated Hazard and Risk Level",null,null,null,null,null,null,null,"Verification"]
[null,"Subsystem","Type","Project Phase","Aspect/Activity","Hazard Description","Hazard Type","Severity","Probability","Risk Category","Column1","Mitigation Strategy","Mitigation Description","Mit. Severity","Mit. Probability","Mit. Risk","Risk Cat12","Verif Method","Verification Plan","Revision Date","Status / Contact Person"]
[null,"Magnet","Matl Handling",null,"Lifting magnet and calorimeter parts.","Magnet weighs 35,000 lbs. Calorimeter consists of multiple parts weight about 4,000 lbs each. Could be improperly lifted resulting in crane or rigging failure and the magnet dropping. Result may be injury, damage to the magnet, other equipment and the facility.","Injury, Damage",null,null,null,null,null,"Written lift plan with proper review and approval. Correct hardware. Operator/rigger training. Attentiveness. Careful planning. Coordination at time of lift."]
[null,"Magnet","Rad",null,"Magnetic field when power applied.","Magnetic field of 1.5 Tesla inside bore. Can cause ___________ (metallic objects to be pulled toward the magnet?). Can cause implantable cardioverter-defibrillators (ICD) to misfire resulting in heart rhythm problems and possible death?","Injury",null,null,null,null,null,"Control system will de-gauss the magnet when power is shut off.\nSafe zone will be marked by ropes when energized."]
[null,"Magnet","Fall",null,"Working on top or accessing top of magnet","Magnet is approx 2 meters high presenting a fall hazard if the top is accessed.","Injury",null,null,{"$f":"VLOOKUP(Hazards3[[#This Row],[Severity]]&Hazards3[[#This Row],[Probability]],CategoryLookup,3,FALSE)","v":{"$error":"#N/A"}},null,null,"TBD",null,null,{"$f":"VLOOKUP(Hazards3[[#This Row],[Mit. Severity]]&Hazards3[[#This Row],[Mit. Probability]],CategoryLookup,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Hazards3[[#This Row],[Mit. Severity]]&Hazards3[[#This Row],[Mit. Probability]],CategoryLookup,3,FALSE)","v":{"$error":"#N/A"}}]
[null,"Beam","Rad",null,"Experiment operation: LCLS II 4 GeV beam","During operation, the 4 GeV LCLS II beam will be sent to the LDMX in End Station A.  This is an ionizing radiation hazard; no one can be inside of End Station A during operation.","Injury",null,null,{"$f":"VLOOKUP(Hazards3[[#This Row],[Severity]]&Hazards3[[#This Row],[Probability]],CategoryLookup,3,FALSE)","v":{"$error":"#N/A"}},null,null,"PPS system. Procedures.",null,null,{"$f":"VLOOKUP(Hazards3[[#This Row],[Mit. Severity]]&Hazards3[[#This Row],[Mit. Probability]],CategoryLookup,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Hazards3[[#This Row],[Mit. Severity]]&Hazards3[[#This Row],[Mit. Probability]],CategoryLookup,3,FALSE)","v":{"$error":"#N/A"}}]
[null,"Beam","Rad",null,"Experiment operation: LCLS II 4 GeV beam.","Higher energy, full pulse, LCLS II beam could be sent to End Station A by mistake.","Damage",null,null,{"$f":"VLOOKUP(Hazards3[[#This Row],[Severity]]&Hazards3[[#This Row],[Probability]],CategoryLookup,3,FALSE)","v":{"$error":"#N/A"}},null,null,"LCLSII mitigations related to the S30XL transfer line: _______\nDetection system at LDMX and shut beam supply.",null,null,{"$f":"VLOOKUP(Hazards3[[#This Row],[Mit. Severity]]&Hazards3[[#This Row],[Mit. Probability]],CategoryLookup,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Hazards3[[#This Row],[Mit. Severity]]&Hazards3[[#This Row],[Mit. Probability]],CategoryLookup,3,FALSE)","v":{"$error":"#N/A"}}]
[null,"Beam","Rad",null,"Experiment operation: LCLS II 4 GeV beam.","Radiation exposure beyond End Station A","Injury",null,null,{"$f":"VLOOKUP(Hazards3[[#This Row],[Severity]]&Hazards3[[#This Row],[Probability]],CategoryLookup,3,FALSE)","v":{"$error":"#N/A"}},null,null,"Shielding design",null,null,{"$f":"VLOOKUP(Hazards3[[#This Row],[Mit. Severity]]&Hazards3[[#This Row],[Mit. Probability]],CategoryLookup,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Hazards3[[#This Row],[Mit. Severity]]&Hazards3[[#This Row],[Mit. Probability]],CategoryLookup,3,FALSE)","v":{"$error":"#N/A"}}]
[null,"Cooling","Rad",null,"Experiment operation: LCLS II 4 GeV beam.","Low Conductivity Water (LCW) Cooling water may become activated? \nWater is closed loop….......(need more info)","Environment/Injury",null,null,{"$f":"VLOOKUP(Hazards3[[#This Row],[Severity]]&Hazards3[[#This Row],[Probability]],CategoryLookup,3,FALSE)","v":{"$error":"#N/A"}},null,null,null,null,null,{"$f":"VLOOKUP(Hazards3[[#This Row],[Mit. Severity]]&Hazards3[[#This Row],[Mit. Probability]],CategoryLookup,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Hazards3[[#This Row],[Mit. Severity]]&Hazards3[[#This Row],[Mit. Probability]],CategoryLookup,3,FALSE)","v":{"$error":"#N/A"}}]
[null,"Cooling","Fluid Leak",null,"Experiment operation.","Cooling water could leak resulting in a continuous flow of ___ gpm at the LDMX magnet.  Could water impact electronics or electrical power supply / AC cabinet? Cause flood in ESA? Where would water go?","Injury, Enviroment, Damage",null,null,{"$f":"VLOOKUP(Hazards3[[#This Row],[Severity]]&Hazards3[[#This Row],[Probability]],CategoryLookup,3,FALSE)","v":{"$error":"#N/A"}},null,null,null,null,null,{"$f":"VLOOKUP(Hazards3[[#This Row],[Mit. Severity]]&Hazards3[[#This Row],[Mit. Probability]],CategoryLookup,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Hazards3[[#This Row],[Mit. Severity]]&Hazards3[[#This Row],[Mit. Probability]],CategoryLookup,3,FALSE)","v":{"$error":"#N/A"}}]
[null,"All","Varies",null,"Experiment operation.","TBD. Hazards, not yet identifed, to personnel, environment, equipment and facility.","Injury, Enviroment, Damage",null,null,{"$f":"VLOOKUP(Hazards3[[#This Row],[Severity]]&Hazards3[[#This Row],[Probability]],CategoryLookup,3,FALSE)","v":{"$error":"#N/A"}},null,null,"FPD's experimental review process will be described in the Integrated Safety Management plan. The output will be documented in the Hazard Analysis Report. Robust project review in accordance with ISM will ensure the experiment is designed for safety. Operations Manual will be developed to ensure requisite procedures. ",null,null,{"$f":"VLOOKUP(Hazards3[[#This Row],[Mit. Severity]]&Hazards3[[#This Row],[Mit. Probability]],CategoryLookup,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Hazards3[[#This Row],[Mit. Severity]]&Hazards3[[#This Row],[Mit. Probability]],CategoryLookup,3,FALSE)","v":{"$error":"#N/A"}}]
[]
[]
[]
[null,"Tables for Data Validation"]
[null,"Magnet","Rad",null,null,null,null,1,"A","High",null,"Eliminate hazard","Remove the hazard altogether",null,null,"High","High","Test","Functional test of installed system verifies mitigation functions correctly"]
[null,"Magnet","Elec",null,null,null,null,2,"B","Medium",null,"Control hazard","Change design/manufacturing plans to reduce risk of mishap",null,null,"Medium","Serious","Inspection","Visual inspection or measurement verifies mitigation is applied as-req'd"]
[null,"Magnet","Matl Handling",null,null,null,null,3,"C","Low",null,"Safety feature","Incorporate passive or static interveners to prevent a mishap",null,null,"Low","Medium","Process control","Control parts/mat'l selection; qual/proof test; fab/ass'y process controls"]
[null,"Magnet","Fall"]
[null,"Shielding","Rad",null,null,null,null,4,"D","Slight",null,"Safety device","Add active device or monitor to interrupt mishap sequence",null,null,"Slight","Low","Audit","Check of in situ mitigations verifies that they are being used"]
[null,"Power","Elec",null,null,null,null,null,"E",null,null,"Warning device","Incorporate monitors and warning of incipient mishap",null,null,null,null,"Review","Review or analysis of mitigation plans indicates that they will reduce hazard level"]
[null,"Data","Ergo",null,null,null,null,null,null,null,null,"Procedure, training","Invoke special procedures, PPE, dedicated equipment",null,null,null,null,"Various","Use of two or more of the verification methods"]
[null,"Cooling","Fluid Leak"]
[null,"Cooling","Rad"]
[null,"Beam","Rad",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"T21","v":0}]
[null,"Other","Misc OH",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"T22","v":0}]
[null,"All","Varies",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"T23","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"T25","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"T26","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Various"]
[null,"Statistics on Hazards",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total"]
[null,null,"Hazard Type",null,null,null,null,null,"Risk Category",null,null,"Mitigation Strategy",null,null,null,null,null,"Verification Method"]
[null,null,{"$f":"COUNTIF(Hazards3[Type],E38)","v":0},null,"Cryo/ODH",null,null,null,{"$f":"COUNTIF(Hazards3[Risk Category],J38)","v":0},"High",null,{"$f":"COUNTIF(Hazards3[Mitigation Strategy],M38)","v":0},{"$f":"L21","v":"Eliminate hazard"},null,null,null,null,{"$f":"COUNTIF(Hazards3[Verif Method],S38)","v":0},{"$f":"R21","v":"Test"}]
[null,null,{"$f":"COUNTIF(Hazards3[Type],E39)","v":0},null,"Press/Vac",null,null,null,{"$f":"COUNTIF(Hazards3[Risk Category],J39)","v":0},"Medium",null,{"$f":"COUNTIF(Hazards3[Mitigation Strategy],M39)","v":0},{"$f":"L22","v":"Control hazard"},null,null,null,null,{"$f":"COUNTIF(Hazards3[Verif Method],S39)","v":0},{"$f":"R22","v":"Inspection"},null,"Cross-check"]
[null,null,{"$f":"COUNTIF(Hazards3[Type],E40)","v":0},null,"Mech",null,null,null,{"$f":"COUNTIF(Hazards3[Risk Category],J40)","v":0},"Low",null,{"$f":"COUNTIF(Hazards3[Mitigation Strategy],M40)","v":0},{"$f":"L23","v":"Safety feature"},null,null,null,null,{"$f":"COUNTIF(Hazards3[Verif Method],S40)","v":0},{"$f":"R23","v":"Process control"}]
[null,null,{"$f":"COUNTIF(Hazards3[Type],E41)","v":0},null,"Struc",null,null,null,{"$f":"COUNTIF(Hazards3[Risk Category],J41)","v":0},"Slight",null,{"$f":"COUNTIF(Hazards3[Mitigation Strategy],M41)","v":0},{"$f":"L25","v":"Safety device"},null,null,null,null,{"$f":"COUNTIF(Hazards3[Verif Method],S41)","v":0},{"$f":"R25","v":"Audit"}]
[null,null,{"$f":"COUNTIF(Hazards3[Type],E42)","v":0},null,"Elec",null,null,null,null,null,null,{"$f":"COUNTIF(Hazards3[Mitigation Strategy],M42)","v":0},"Warning device",null,null,null,null,{"$f":"COUNTIF(Hazards3[Verif Method],S42)","v":0},{"$f":"R26","v":"Review"}]
[null,null,{"$f":"COUNTIF(Hazards3[Type],E43)","v":0},null,"Control",null,null,null,null,null,null,{"$f":"COUNTIF(Hazards3[Mitigation Strategy],M43)","v":0},"Procedure, training",null,null,null,null,{"$f":"COUNTIF(Hazards3[Verif Method],S43)","v":0},"Various"]
[null,null,{"$f":"COUNTIF(Hazards3[Type],E44)","v":0},null,"Env",null,null,null,{"$f":"SUM(I38:I41)","v":0},"Total",null,{"$f":"SUM(L38:L43)","v":0},"Total",null,null,null,null,{"$f":"SUM(R38:R43)","v":0},"Total"]
[null,null,{"$f":"COUNTIF(Hazards3[Type],E45)","v":0},null,"Fire"]
[null,null,{"$f":"COUNTIF(Hazards3[Type],E46)","v":1},null,"Fall"]
[null,null,{"$f":"COUNTIF(Hazards3[Type],E47)","v":0},null,"HazMat",null,null,null,{"$f":"IF(I44-#REF!=0,\"OK\",\"Not OK\")","v":{"$error":"#REF!"}},"Cross-check",null,{"$f":"IF(L44-#REF!=0,\"OK\",\"Not OK\")","v":{"$error":"#REF!"}},"Cross-check",null,null,null,null,{"$f":"IF(R44-#REF!=0,\"OK\",\"Not OK\")","v":{"$error":"#REF!"}},"Cross-check"]
[null,null,{"$f":"COUNTIF(Hazards3[Type],E48)","v":5},null,"Rad"]
[null,null,{"$f":"COUNTIF(Hazards3[Type],E49)","v":0},null,"Misc.OH",null,null,null,"1A","High"]
[null,null,{"$f":"COUNTIF(Hazards3[Type],E50)","v":1},null,"Matl Handling",null,null,null,"2A","High"]
[null,null,{"$f":"SUM(C38:C50)","v":7},null,"Total",null,null,null,"3A","Medium"]
[null,null,null,null,null,null,null,null,"4A","Low","High"]
[null,"Total",{"$f":"IF(C51-#REF!=0,\"OK\",\"Not OK\")","v":{"$error":"#REF!"}},null,"Cross-check",null,null,null,"1B","High","High"]
[null,null,null,null,null,null,null,null,"2B","High","Medium"]
[null,null,null,null,null,null,null,null,"3B","Medium","Low"]
[null,null,null,null,null,null,null,null,"4B","Low","High"]
[null,null,null,null,null,null,null,null,"1C","High","High"]
[null,null,null,null,null,null,null,null,"2C","Medium","Medium"]
[null,null,null,null,null,null,null,null,"3C","Low","Low"]
[null,null,null,null,null,null,null,null,"4C","Slight","High"]
[null,null,null,null,null,null,null,null,"1D","Medium","Medium"]
[null,null,null,null,null,null,null,null,"2D","Low","Low"]
[null,null,null,null,null,null,null,null,"3D","Low","Slight"]
[null,null,null,null,null,null,null,null,"4D","Slight","Medium"]
[null,null,null,null,null,null,null,null,"1E","Low","Low"]
[null,null,null,null,null,null,null,null,"2E","Slight","Low"]
[null,null,null,null,null,null,null,null,"3E","Slight","Slight"]
[null,null,null,null,null,null,null,null,"4E","Slight","Low"]
[null,null,null,null,null,null,null,null,null,null,"Slight"]

{"sheet":"3. Risk Assessment Tables","index":2,"n_rows":28,"n_cols":13,"rows_kept":28,"cut":false,"hidden":false,"merged":[[8,2,10,2],[8,3,10,3],[12,10,14,10],[12,11,14,11],[12,12,14,12],[11,9,11,12],[12,9,14,9],[17,2,19,2],[17,3,19,3],[15,7,19,7],[11,2,13,2],[11,3,13,3],[14,2,16,2],[14,3,16,3]]}
[]
[null,null,null,null,{"$f":"'1.  Intro, Def''s, Change Log'!B10","v":"LDMX Hazard List"},null,null,null,"2021-05-17"]
[null,null,"Risk Assessment Tables"]
[]
[]
[]
[null,null,null,null,"Hazard Severity Classification"]
[null,null,"Class","Description","Potential Consequences"]
[null,null,1,"Catastrophic","Injury:  may cause death or permanently-disabling injury"]
[null,null,null,null,"Property damage:  near-complete loss of experiment"]
[null,null,null,null,"Environment:  irreversible severe environmental damage"]
[null,null,2,"Critical","Injury:   severe injury, occupational illness, or permanent partial disability",null,null,null,null,"Severity"]
[null,null,null,null,"Property damage:  major damage to system; loss of major subsystem(s)",null,null,null,null,"1—Catastrophic","2—Critical","3—Moderate","4—Minor"]
[null,null,null,null,"Environment:  significant reversible environmental damage",null,null,null,"Risk Assessment Value"]
[null,null,3,"Moderate","Injury:  minor injury or occupational illness"]
[null,null,null,null,"Property damage:  minor damage to subsystem, recoverable with minimal impact on program",null,null,"Prboability","A—Frequent"]
[null,null,null,null,"Environment:  mitigatible environmental damage, where restoration activities can be accomplished",null,null,null,"B—Probable"]
[null,null,4,"Minor","Injury:  minor first aid treatment; personal health not affected",null,null,null,"C—Possible"]
[null,null,null,null,"Property damage:  more than normal wear and tear; easily recoverable within scope of standard maintenance",null,null,null,"D—Remote"]
[null,null,null,null,"Environment:  minimal environmental damage",null,null,null,"E—Improbable"]
[]
[null,null,null,null,"Hazard Probability Level"]
[null,null,"Level","Frequency of Occurrence","Definition",null,null,null,"Mishap Risk Categories"]
[null,null,"A","Frequent","Likely to occur often in the life of the experiment (X > 10-1)",null,null,null,"Cell Color",null,"Description"]
[null,null,"B","Probable","Will occur several times in the life of the experiment  (10-1 > X > 10-2)",null,null,null,null,null,"High"]
[null,null,"C","Possible","Likely to occur sometime in the life of the experiment (10-2 > X > 10-3)",null,null,null,null,null,"Medium"]
[null,null,"D","Remote","Unlikely but possible to occur in the life of the experiment  (10-3 > X > 10-6)",null,null,null,null,null,"Low"]
[null,null,"E","Improbable","So unlikely, it can be assumed occurrence may not be experienced",null,null,null,null,null,"Slight"]

{"sheet":"Items_Issues Tracking","index":3,"n_rows":1,"n_cols":5,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Item/Isssue","Notes","Status (open/closed)","Closure Date","Closure Documentation"]