{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Instructions","Summary","Survey Entry","Dropdown Details","ECD Band Calculation","Lab Env. Band Calculation"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":4,"comments":2,"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":"Instructions","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Summary","index":1,"n_rows":19,"n_cols":20,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,14,1,19],[5,3,7,3],[18,3,18,11]]}
[]
[null,"Lab Summary",null,null,null,null,null,null,null,null,null,null,null,null,"ECD Risk Control Band Summary"]
[null,"Lab ID#",null,"Lab Description ",null,"Lab Area (ft2)",null,"Lab Height (ft)",null,"Lab Volume (ft3)",null,"Risk Control Band ",null,null,"RCB Value",0,1,2,3,4]
[null,{"$f":"IF('Survey Entry'!B6 = \"[Enter Lab ID or room number here.]\",\"Enter in Survey Tab\",'Survey Entry'!B6)","v":"Enter in Survey Tab"},null,{"$f":"IF('Survey Entry'!D6 = \"[Enter a brief description of the lab being surveyed here.]\",\"Enter in Survey Tab\",'Survey Entry'!D6)","v":"Enter in Survey Tab"},null,{"$f":"IF('Survey Entry'!H6 = \"[Enter Lab Area Here]\",\"Enter in Survey Tab\",'Survey Entry'!H6)","v":"[Enter Lab Floor Area Here]"},null,{"$f":"IF('Survey Entry'!J6 = \"[Enter lab height here]\",\"Enter in Survey Tab\",'Survey Entry'!J6)","v":"Enter in Survey Tab"},null,{"$f":"IF(B4=\"Enter in Survey Tab\",\"-\",F4*H4)","v":"-"},null,{"$f":"'Survey Entry'!AN7","v":"-"},null,null,"Totals",{"$f":"COUNTIF('Survey Entry'!$AH$9:AH1048576,0)","v":0},{"$f":"COUNTIF('Survey Entry'!$AH$9:$AH$1048576,1)","v":0},{"$f":"COUNTIF('Survey Entry'!$AH$9:$AH$1048576,2)","v":0},{"$f":"COUNTIF('Survey Entry'!$AH$9:$AH$1048576,3)","v":0},{"$f":"COUNTIF('Survey Entry'!$AH$9:$AH$1048576,4)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"% of Sum",{"$f":"IF(L4=\"-\",\"-\",P4/SUM(P4:T4))","v":"-"},{"$f":"IF(L4=\"-\",\"-\",Q4/SUM(P4:T4))","v":"-"},{"$f":"IF(L4=\"-\",\"-\",R4/SUM(P4:T4))","v":"-"},{"$f":"IF(L4=\"-\",\"-\",S4/SUM(P4:T4))","v":"-"},{"$f":"IF(L4=\"-\",\"-\",T4/SUM(P4:T4))","v":"-"}]
[null,null,null,"Room Flows determined by lab ventilation risk assessment",null,"Minimum room flow  (cfm)",null,{"$f":"IF(B4=\"Enter in Survey Tab\",\"-\",'Survey Entry'!AZ10)","v":"-"},null,"Maximum room flow (cfm)",null,{"$f":"IF(B4=\"Enter in Survey Tab\",\"-\",'Survey Entry'!BB10)","v":"-"}]
[]
[null,null,null,null,null,"Minimum (ACH)",null,{"$f":"IF(B4=\"Enter in Survey Tab\",\"-\",(H6*60)/J4)","v":"-"},null,"Maximum (ACH)",null,{"$f":"IF(B4=\"Enter in Survey Tab\",\"-\",(L6*60)/J4)","v":"-"}]
[]
[null,null,null,"Fume Hood Driven? ",null,{"$f":"IF(H4=\"Enter in Survey Tab\",\"-\",'Survey Entry'!BB7)","v":"-"}]
[]
[null,null,null,"System Design Specifications ",null,"Minimum room flow  (cfm)",null,"[Enter here]",null,"Maximum room flow (cfm)",null,"[Enter here]"]
[]
[null,null,null,"Operational flows for unoccupied and occupied modes",null,"Unoccupied  (cfm)",null,"[Enter here]",null,"Occupied  (cfm)",null,"[Enter here]"]
[]
[]
[]
[null,null,null,"Notes"]
[null,null,null,{"$f":"'Survey Entry'!$F$6","v":"[Document notable characteristics and hazards here.] "}]

{"sheet":"Survey Entry","index":2,"n_rows":11,"n_cols":54,"rows_kept":11,"cut":false,"hidden":false,"merged":[[2,41,2,42]]}
[]
[]
[null,null,null,"Tolerance of Risk",null,"Click here to select tolerance to risk from drop down."]
[null,"Lab Environment Survey"]
[null,"Lab ID#",null,"Lab Description ",null,"Additional Notes/Comments",null,"Lab Area (ft2)",null,"Lab Height (ft)",null,null,null,"Lab Volume (ft3)",null,null,null,"Hazard                         Exposure limit for the peak hazard not contained by ECD ",null,"Quantity          Aggregrate volume of all hazards",null,"Generation Rate Peak generation rate for any hazard not contained by an ECD ",null,"Generation \nMethod               Peak generation method for any hazard not contained by an ECD ",null,"Generation \nLocation               Peak generation location for any hazard not contained by an ECD ",null,"Change \nDynamics           Frequency of changes in the lab environment ",null,"Housekeeping  General order and cleanliness of the lab",null,"\nAvailability of Exposure Control Devices ",null,"\nAppropriateness of Exposure Control Devices",null,"Ventilation \nEffectiveness",null,"Maximum Risk Control Band from ECD survey",null,"Lab Environment \nRisk Control Rating",null,"Recommended ACH (Unoccupied)","Recommended ACH  (Occupied)",null,null,null,null,null,"Recommended Unoccupied Room Flows (cfm)","Recommended Occupied Room Flows  (cfm)"]
[null,"[Enter Lab ID or room number here.]",null,"[Enter a brief description of the lab being surveyed here.]",null,"[Document notable characteristics and hazards here.] ",null,"[Enter Lab Floor Area Here]",null,"[Enter lab height here]",null,null,null,{"$f":"IF(J6=\"[Enter lab height here]\",\"Volume will be calculated here\",H6*J6)","v":"Volume will be calculated here"},null,null,null,"[Click here to select exposure limit of peak hazard.]",null,"[Click here to select aggregate quantity of all hazards.]",null,"[Click here to select peak rate of generation.]",null,"[Click here to select method of generation.]",null,"[Click here to select location where peak hazard is generated.]",null,"[Click here to select frequency of change.]",null,"[Click here to select presence of obstructions.]",null,"[Click here to select if an ECD is available for each hazard.]",null,"[Click here to to select if the appropriate ECDs are used to contain each hazard.]",null,"[Click here to rate the effectiveness of ventilation in the space.]",null,{"$f":"MAX($AH$9:AH1397)","v":0},null,{"$f":"IF($AF$10= \"Please enter values for all characteristics\",$AF$10, R7*14+T7*2+V7*12+X7*1+Z7*2+AB7*2+AD7*1+AF7*1+AH7*1+AJ7*3+AL7*1)","v":"Please enter values for all characteristics"},null,{"$f":"IF(AN7=\"-\",\"-\",HLOOKUP($AN$7,'Dropdown Details'!$D$18:$H$20,3))","v":"-"},{"$f":"IF(AN7=\"-\",\"-\",HLOOKUP($AN$7,'Dropdown Details'!$D$18:$H$20,2))","v":"-"},null,null,null,null,null,{"$f":"IF(AN7=\"-\",\"-\",AP6*N6/60)","v":"-"},{"$f":"IF(AN7=\"-\",\"-\",AQ6*N6/60)","v":"-"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"HLOOKUP(R6,'Dropdown Details'!$C$7:$H$18,12,FALSE)","v":"-"},null,{"$f":"HLOOKUP(T6,'Dropdown Details'!$C$8:$H$18,11,FALSE)","v":"-"},null,{"$f":"HLOOKUP(V6,'Dropdown Details'!$C$9:$H$18,10,FALSE)","v":"-"},null,{"$f":"HLOOKUP(X6,'Dropdown Details'!$C$10:$H$18,9,FALSE)","v":"-"},null,{"$f":"HLOOKUP(Z6,'Dropdown Details'!$C$11:$H$18,8,FALSE)","v":"-"},null,{"$f":"HLOOKUP(AB6,'Dropdown Details'!$C$12:$H$18,7,FALSE)","v":"-"},null,{"$f":"HLOOKUP(AD6,'Dropdown Details'!$C$13:$H$18,6,FALSE)","v":"-"},null,{"$f":"HLOOKUP(AF6,'Dropdown Details'!$C$14:$H$18,5,FALSE)","v":"-"},null,{"$f":"HLOOKUP(AH6,'Dropdown Details'!$C$15:$H$18,4,FALSE)","v":"-"},null,{"$f":"HLOOKUP(AJ6,'Dropdown Details'!$C$16:$H$18,3,FALSE)","v":"-"},null,{"$f":"HLOOKUP(AL6,'Dropdown Details'!$C$17:$H$18,2,FALSE)","v":0},null,{"$f":"IF(AN6= \"Please enter values for all characteristics\", \"-\", _xlfn.IFS($F$3=\"Low\",IF(AN6=\"\",\"\",(IF(AN6<='Lab Env. Band Calculation'!$I$5,0,IF(AND(AN6>='Lab Env. Band Calculation'!$I$5,AN6<'Lab Env. Band Calculation'!$I$6),1,IF(AND(AN6>='Lab Env. Band Calculation'!$I$6,AN6<='Lab Env. Band Calculation'!$I$7),2,IF(AND(AN6>='Lab Env. Band Calculation'!$I$7,AN6<='Lab Env. Band Calculation'!$I$8),3,4)))))),$F$3=\"Medium\",IF(AN6=\"\",\"\",(IF(AN6<='Lab Env. Band Calculation'!$K$5,0,IF(AND(AN6>='Lab Env. Band Calculation'!$K$5,AN6<='Lab Env. Band Calculation'!$K$6),1,IF(AND(AN6>='Lab Env. Band Calculation'!$K$6,AN6<='Lab Env. Band Calculation'!$K$7),2,IF(AND(AN6>='Lab Env. Band Calculation'!$K$7,AN6<='Lab Env. Band Calculation'!$K$8),3,4)))))),$F$3=\"High\",IF(AN6=\"\",\"\",(IF(AN6<='Lab Env. Band Calculation'!$M$5,0,IF(AND(AN6>='Lab Env. Band Calculation'!$M$5,AN6<='Lab Env. Band Calculation'!$M$6),1,IF(AND(AN6>='Lab Env. Band Calculation'!$M$6,AN6<='Lab Env. Band Calculation'!$M$7),2,IF(AND(AN6>='Lab Env. Band Calculation'!$M$7,AN6<='Lab Env. Band Calculation'!$M$8),3,4))))))))","v":"-"},null,null,null,null,null,null,null,null,null,null,null,"Fume Hood Driven?",null,{"$f":"IF(AN7=\"-\",\"-\",IF(AW10>AX6,\"Yes\",\"No\"))","v":"-"}]
[null,"ECD Survey"]
[null,"ECD ID#\n(Unique ID tied into organizational system)",null,"ECD Type \n",null,"Additional Details",null,"Hood opening height (in)   ",null,"Hood width (in)",null,"Hood depth (in)",null,"Hood face area (ft2)","Hood volume (ft3)   ","Hood face velocity  (fpm) ",null," Hazard -                                      Enter the exposure limit for the peak hazard contained by ECD ",null,"Quantity -                 Enter the total volume of all hazards",null,"Generation Rate - Enter the peak generation rate for any hazard contained by ECD",null,"Generation \nMethod                 Peak generation method for any hazard contained by ECD ",null,"Generation \nLocation                 Peak generation location for any hazard contained by  ECD ",null,"Change \nDynamics            Frequency of change in the ECD ",null,"Housekeeping  General order and cleanliness of the lab",null,"ECD \nRisk Rating",null,"ECD Risk Control Band",null," Minimum Fume Hood ACH Requirement based on ANSI Z9.5",null," Minimum Fume Hood Flow (cfm) Requirement based on ANSI Z9.5",null," Maximum Fume Hood Flow Rate (cfm) permitted to avoid turbulence",null,"Minimum Room ACH required by  fume hoods  based on ANSI Z9.5","Maximum Room ACH      based on fume hood opening designated",null,null,null,null,null,"Sum of Minimum Fume Hood Flow Requirements (cfm) for adequate containment ","Sum of Maximum Fume Hood Flows (cfm) based on face velocity to avoid turbulence ",null,"Minimum Room flows (cfm)",null,"Maximum Room flows (cfm)"]
[null,"[Enter a unique ID for each device]",null,"Exposure Control Device Type",null,"[Enter here]",null,"[Select one from dropdown menu or enter specific value here. ]",null,"[Select one from dropdown menu or enter specific value here. ]",null,"[Select one from dropdown menu or enter specific value here. ]",null,{"$f":" IF(D10 = \"fume hood\", (H10*J10)/144, \"NA\")","v":"NA"},{"$f":"  IF(D10 = \"fume hood\",(H10*J10*L10)/1728, \"NA\")","v":"NA"},"[Select one from dropdown menu or enter specific value here. ]",null,"[Click here to select exposure limit of peak hazard.]",null,"[Click here to select aggregate quantity of all hazards.]",null,"[Click here to select peak rate of generation.]",null,"[Click here to select method of generation.]",null,"[Click here to select location where peak hazard is generated.]",null,"[Click here to select frequency of change.]",null,"[Click here to select presence of obstructions.]",null,{"$f":"IF(AD11=\"-\",\"Please enter values for all characteristics\",R11*10+T11*3+V11*5+X11*1+Z11*1+AB11*2+AD11*1)","v":"Please enter values for all characteristics"},null,{"$f":"IF(AF10=\"Please enter values for all characteristics\", \"-\", _xlfn.IFS($F$3=\"Low\",IF(AF10=\"\",\"\",(IF(AF10<='ECD Band Calculation'!$I$5,0,IF(AND(AF10>='ECD Band Calculation'!$I$5,AF10<='ECD Band Calculation'!$I$6),1,IF(AND(AF10>='ECD Band Calculation'!$I$6,AF10<='ECD Band Calculation'!$I$7),2,IF(AND(AF10>='ECD Band Calculation'!$I$7,AF10<='ECD Band Calculation'!$I$8),3,4)))))),$F$3=\"Medium\",IF(AF10=\"\",\"\",(IF(AF10<='ECD Band Calculation'!$K$5,0,IF(AND(AF10>='ECD Band Calculation'!$K$5,AF10<='ECD Band Calculation'!$K$6),1,IF(AND(AF10>='ECD Band Calculation'!$K$6,AF10<='ECD Band Calculation'!$K$7),2,IF(AND(AF10>='ECD Band Calculation'!$K$7,AF10<='ECD Band Calculation'!$K$8),3,4)))))),$F$3=\"High\",IF(AF10=\"\",\"\",(IF(AF10<='ECD Band Calculation'!$M$5,0,IF(AND(AF10>='ECD Band Calculation'!$M$5,AF10<='ECD Band Calculation'!$M$6),1,IF(AND(AF10>='ECD Band Calculation'!$M$6,AF10<='ECD Band Calculation'!$M$7),2,IF(AND(AF10>='ECD Band Calculation'!$M$7,AF10<='ECD Band Calculation'!$M$8),3,4))))))))","v":"-"},null,{"$f":"IF($D10=\"fume hood\",HLOOKUP($AH10,'Dropdown Details'!$A$29:$H$30,2,FALSE),\"NA\")","v":"NA"},null,{"$f":"IF(D10= \"fume hood\",(AJ10*O10)/60, \"NA\")","v":"NA"},null,{"$f":"IF(D10=\"Fume hood\",N10*P10,\"NA\")","v":"NA"},null,{"$f":"IF(AN7=\"-\",\"-\",AW10*60/N6)","v":"-"},{"$f":"IF(AN7=\"-\",\"-\",(AX10*60)/N6)","v":"-"},null,null,null,null,null,{"$f":"IF(AN7=\"-\",\"-\",SUM(AL9:AL1048576))","v":"-"},{"$f":"IF(AN7=\"-\",\"-\",SUM(AN9:AN1048576))","v":"-"},null,{"$f":"IF(AN7=\"-\",\"-\",MAX(AX6,AW10))","v":"-"},null,{"$f":"IF(AN7=\"-\",\"-\",MAX(AX6,AX10))","v":"-"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"HLOOKUP(R10,'Dropdown Details'!$C$22:$H$29,8,FALSE)","v":"-"},null,{"$f":"HLOOKUP(T10,'Dropdown Details'!$C$23:$H$29,7,FALSE)","v":"-"},null,{"$f":"HLOOKUP(V10,'Dropdown Details'!$C$24:$H$29,6,FALSE)","v":"-"},null,{"$f":"HLOOKUP(X10,'Dropdown Details'!$C$25:$H$29,5,FALSE)","v":"-"},null,{"$f":"HLOOKUP(Z10,'Dropdown Details'!$C$26:$H$29,4,FALSE)","v":"-"},null,{"$f":"HLOOKUP(AB10,'Dropdown Details'!$C$27:$H$29,3,FALSE)","v":"-"},null,{"$f":"HLOOKUP(AD10,'Dropdown Details'!$C$28:$H$29,2,FALSE)","v":"-"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"\\"]

{"sheet":"Dropdown Details","index":3,"n_rows":38,"n_cols":11,"rows_kept":38,"cut":false,"hidden":false,"merged":[[18,0,18,1],[19,0,19,1],[29,0,29,1]]}
["Risk Tolerance","Click here to select tolerance to risk from drop down.","Low","Medium","High"]
[]
["Exposure Control Device Type","fume hood","snorkel","biosafety cabinet","Ventilated balance enclosures","Slot hood","Canopy hood and dedicated equipment exhaust","Snorkels and spot exhausts","Laminar flow clean air station","Glove box","Ventilated enclosure"]
[]
[]
["Lab Evaluation","Weight Factor","Description"]
["Hazard",14,"[Click here to select exposure limit of peak hazard.]","> 500 ppm  or  >2000 mg/m3","300-500 ppm  or  1000-2000 mg/m3","150-300 ppm  or  500-1000 mg/m3","50-150 ppm  or  300-500 mg/m3","<50 ppm  or  <300 mg/m3"]
["Quantity",2,"[Click here to select aggregate quantity of all hazards.]","None","<1 L or <10 g","1-10 L or 10-100 g","10-20 L or 0.1-1 kg","> 20 L or >1 kg"]
["Generation Rate",12,"[Click here to select peak rate of generation.]","None","<0.1 lpm | small # of small containers | Low VP","<0.3 lpm [Large # of small containers | Small # of large containers, Low Vapor Pressure](e.g., High VP/Stirring)","< 0.5 lpm (Large number of small containers, small numer of large containers, high vapor pressure)","> 0.5 lpm (large number of small containers, large number of large containers, high vapor pressure, active generation)"]
["Generation Method",1,"[Click here to select method of generation.]","None","Manual","Intermittent (Manual or equipment) ","Equipment, Constant |\nManual, Equipment Intermittent |\nManual, Equipment, Constant","Manual, Equipment, Intermittent, Constant"]
["Generation Location",2,"[Click here to select location where peak hazard is generated.]","None","Low (very close to capture device)","Middle (close to capture device)","Low-Middle or High-Middle (not very close)","Low, Middle, High (not close)"]
["Change Dynamics",2,"[Click here to select frequency of change.]","1 change/decade","1 change/year","1 change/month","1 change/week","1 change/day"]
["Housekeeping",1,"[Click here to select presence of obstructions.]","No clutter","Some Clutter","Cluttered","Very Cluttered","Exceedingly Cluttered"]
["ECD Availability",1,"[Click here to select if an ECD is available for each hazard.]","Yes","-","-","-","No"]
["ECD Appropriateness",1,"[Click here to to select if the appropriate ECDs are used to contain each hazard.]","Yes","-","-","-","No"]
["Ventilation Effectiveness",3,"[Click here to rate the effectiveness of ventilation in the space.]","Very effective","Effective","Moderately effective","Ineffective","Very inffective"]
["Maximum ECD",1,"[Maximum Risk Control Band entered from ECDs below.]",0,1,2,3,4]
["Risk Control Band",null,"-",0,1,2,3,4]
[" Occupied ACH Recommended per ASHRAE Classification of Laboratory Design Levels (based on Risk Control Band)",null,"-",1.7,4,6,8,10]
[" Unoccupied ACH Recommended per ASHRAE Classification of Laboratory Design Levels (based on Risk Control Band)",null,"-",1.7,2,3,4,10]
["Exposure Control Devices","Weight Factor","Description"]
["Hazard",10,"[Click here to select exposure limit of peak hazard.]","> 500 ppm  or  >2000 mg/m3","50-500 ppm  or  250-2000 mg/m3","5-50 ppm  or  20-250 mg/m3","0.5-5 ppm  or  1-20 mg/m3","<0.5 ppm  or  <1 mg/m3"]
["Quantity",3,"[Click here to select aggregate quantity of all hazards.]","None","<1 mL or <1 g","1-500 ml or 1-100 g","0.5-5L or 0.1-1 kg","> 5 L or < 1 kg"]
["Generation Rate",4,"[Click here to select peak rate of generation.]","None","<0.1 lpm (e.g., evaporation)","<0.5 lpm (e.g., High VP/Stirring)","< 4 lpm (e.g., Heating/Mixing)",">4 lpm (e.g., Boiling)"]
["Generation Method",1,"[Click here to select method of generation.]","None","Manual","Manual Intermittent | \nEquipment Intermittent","Equipment, Constant |\nManual, Equipment Intermittent |\nManual, Equipment, Constant","Manual, Equipment, Intermittent, Constant"]
["Generation Location",1,"[Click here to select location where peak hazard is generated.]","None","Well contained by ECD/Very close to capture device","Contained by ECD/Close to the capture device","Poorly contained by ECD/ not close to capture device","Very poorly contained by ECD/ Location not clearly defined"]
["Change Dynamics",1,"[Click here to select frequency of change.]","1 change/decade","1 change/year","1 change/month","1 change/wk","1 change/day"]
["Housekeeping",1,"[Click here to select presence of obstructions.]","No clutter","Some Clutter","Cluttered","Very Cluttered","Exceedingly Cluttered"]
["Risk Control Band",null,"-",0,1,2,3,4]
["Fume Hood ACH Requirement per ANSI Z9.5 based on Risk Control Band",null,"-",150,150,150,250,250]
[]
["Fume Hood Dimensions",null,null,null,null,null,"Other"]
["Hood Width (ft)","[Select one from dropdown menu or enter specific value here. ]",48,60,72,84,96]
["Hood Depth (in)","[Select one from dropdown menu or enter specific value here. ]",34,"-","-","-","-","-"]
["Hood Height (in)","[Select one from dropdown menu or enter specific value here. ]",18,24,30,"-","-","-"]
["Hood Face Area (ft2)","[Select one from dropdown menu or enter specific value here. ]","-","-","-","-","-","-"]
["Hood Volume (ft3)","[Select one from dropdown menu or enter specific value here. ]","-","-","-","-","-","-"]
["Face Velocity (fpm)","[Select one from dropdown menu or enter specific value here. ]",100,90,80,70,60,"-"]

{"sheet":"ECD Band Calculation","index":4,"n_rows":43,"n_cols":79,"rows_kept":43,"cut":false,"hidden":false,"merged":[[1,1,1,5],[2,7,2,13],[3,7,3,8],[3,9,3,10],[3,11,3,12]]}
["How it Works"]
[null,"ECD Parameter Rating and Weighting Table"]
[null,"Evaluation Criteria","Rating","Weight Multiple","Weighted Risk Score","Sensitivity or Importance",null,"Risk Score Range for each Risk Control Band                                             (Based on Tolerance of Risk)"]
[null,"Hazard",4,10,{"$f":"C4*D4","v":40},{"$f":"E4/ECD_Score","v":0.43478260869565216},null,"Low Tolerance ",null,"Medium Tolerance ",null,"High Tolerance ",null,"Risk Level"]
[null,"Quantity",4,3,{"$f":"C5*D5","v":12},0.13043478260869565,null,"0 -  ",4.5999999999999996,"0 - ",9.1999999999999993,"0 -",18.399999999999999,0]
[null,"Potential or Rate of Generation",4,5,20,0.21739130434782608,null,"4.7 - ",9.1999999999999993,"9.3 - ",23,"18.5 - ",46,1]
[null,"Method of Generation",4,1,4,4.3478260869565216E-2,null,"9.3 - ",18.399999999999999,"24 -",36.799999999999997,"46 - ",64.400000000000006,2]
[null,"Generation Location",4,1,4,{"$f":"E8/ECD_Score","v":4.3478260869565216E-2},null,"18.5 - ",50.6,"36.9 - ",69,"64.5 - ",82.8,3]
[null,"Dynamic or Potential for Change",4,2,8,8.6956521739130432E-2,null,"50.7 - ",92,"70 -",92,"82.9 - ",92,4]
[null,"Housekeeping",4,1,4,{"$f":"E10/ECD_Score","v":4.3478260869565216E-2}]
[null,"Totals",{"$f":"SUM(C4:C10)","v":28},"Total Weighted Risk Score",{"$f":"SUM(E4:E10)","v":92},{"$f":"SUM(F4:F10)","v":0.99999999999999978}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"> 69"]

{"sheet":"Lab Env. Band Calculation","index":5,"n_rows":37,"n_cols":76,"rows_kept":37,"cut":false,"hidden":false,"merged":[[1,1,1,5],[2,7,2,13],[3,7,3,8],[3,9,3,10],[3,11,3,12]]}
["How it Works"]
[null,"Lab Environment Rating and Weighting Table"]
[null,"Evaluation Criteria","Rating","Weight Multiple","Weighted Risk Score","Sensitivity or Importance",null,"Risk Score Range for each Risk Control Band                                                         (based on Tolerance level)"]
[null,"Hazard",4,14,{"$f":"C4*D4","v":56},{"$f":"E4/LE_Score","v":0.35},null,"Low Tolerance ",null,"Medium Tolerance ",null,"High Tolerance ",null,"Risk Level"]
[null,"Quantity",4,2,{"$f":"C5*D5","v":8},{"$f":"E5/LE_Score","v":0.05},null,"0 -  ",8,"0 - ",24,"0 -",40,0]
[null,"Potential or Rate of Generation",4,12,{"$f":"C6*D6","v":48},{"$f":"E6/LE_Score","v":0.3},null,"8 -",16,"25 - ",52,"41 -",80,1]
[null,"Method of Generation",4,1,{"$f":"C7*D7","v":4},{"$f":"E7/LE_Score","v":2.5000000000000001E-2},null,"17 - ",32,"53 -",80,"81 - ",112,2]
[null,"Generation Locations",4,2,{"$f":"C8*D8","v":8},{"$f":"E8/LE_Score","v":0.05},null,"33 - ",88,"81 - ",108,"113 - ",144,3]
[null,"ECD Availability",4,1,4,2.5000000000000001E-2,null,"89 -",160,"109 - ",160,"145 - ",160,4]
[null,"Appropriate ECDs",4,1,4,2.5000000000000001E-2]
[null,"Ventilation Effectiveness (Veff)",4,3,12,7.4999999999999997E-2]
[null,"Dynamic or Potential for Change",4,2,8,0.05]
[null,"Housekeeping",4,1,4,2.5000000000000001E-2]
[null,"Maximum ECD ECD",4,1,4,2.5000000000000001E-2]
[null,"Totals",{"$f":"SUM(C4:C14)","v":44},"Total Weighted Risk Score",{"$f":"SUM(E4:E14)","v":160},{"$f":"SUM(F4:F14)","v":1}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"> 69"]