{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Captor Face Velocity","Captor Distance","DataTable"],"not_rendered":{"charts":0,"images":9,"macros":1,"external_links":0,"defined_names":9,"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":"Captor Face Velocity","index":0,"n_rows":59,"n_cols":10,"rows_kept":59,"cut":false,"hidden":false,"merged":[[0,1,2,7],[3,3,3,5],[9,2,9,4],[10,2,10,4],[12,2,12,4],[4,1,5,7],[7,1,7,4],[54,1,56,7],[41,2,41,4],[30,1,30,4],[31,1,31,4],[13,2,13,4],[21,2,21,4],[24,2,24,4],[27,2,27,4],[40,2,40,4]]}
[null,"Face Velocity Calculator"]
[]
[]
[]
[null,"USE This version to calculate HOOD ENTRY VELOCITY Requirements"]
[]
[]
[null,"Captor Distance Required",null,null,null,131,"mm","<-- Enter Value"]
[]
[null,null,null,null,null,"Rectangle",null,"<-- Select Hood Shape"]
[null,null,null,null,null,350,{"$f":"IF(F10=\"Circle\",\"mm\",\"\")","v":""},{"$f":"IF(F10=\"\",\"\",IF(F10=\"Circle\",\"<-- Enter Diameter\",\"\"))","v":""}]
[]
[null,null,{"$f":"IF(F10=\"Circle\",\"\",IF(F10=\"Oval\",\"Enter Largest Dimension\",IF(F10=\"Square\",\"Enter Dimension of Side\",IF(F10=\"Rectangle\",\"Enter Longest Side\"))))","v":"Enter Longest Side"},null,null,185,{"$f":"IF(F10=\"\",\"\",IF(F10=\"Circle\",\"\",\"mm\"))","v":"mm"},{"$f":"IF(F10=\"\",\"\",IF(F10=\"Circle\",\"\",\"<-- Enter Value\"))","v":"<-- Enter Value"},null,"Fletcher's Original Equations"]
[null,null,{"$f":"IF(F10=\"Circle\",\"\",IF(F10=\"Oval\",\"Enter Small Dimension\",IF(F10=\"Square\",\"\",IF(F10=\"Rectangle\",\"Enter Short Dimension\"))))","v":"Enter Short Dimension"},null,null,165,{"$f":"IF(F10=\"\",\"\",IF(F10=\"Circle\",\"\",\"mm\"))","v":"mm"},{"$f":"IF(F10=\"\",\"\",IF(F10=\"Circle\",\"\",\"<-- Enter Value\"))","v":"<-- Enter Value"}]
[]
[null,null,"Circle Area",null,null,{"$f":"((PI()*((F11/1000)^2))/4)","v":9.6211275016187398E-2},"m2"]
[null,null,"Oval Area",null,null,{"$f":"(PI()*(F13/1000)*(F14/1000))/4","v":2.3974278937707112E-2},"m2"]
[null,null,"Square Area",null,null,{"$f":"(F13/1000)^2","v":3.4224999999999998E-2},"m2"]
[null,null,"Rectangle Area",null,null,{"$f":"(F13/1000)*(F14/1000)","v":3.0525E-2},"m2",null,null,"Rectangle"]
[]
[null,null,null,null,null,null,null,null,null,"Where:-"]
[null,null,"Hood Area",null,null,{"$f":"IF(F10=\"Circle\",F16,IF(F10=\"Oval\",F17,IF(F10=\"Square\",F18,IF(F10=\"Rectangle\",F19,))))","v":3.0525E-2},"m2",null,null,"VH = Required Captor Hood Entry Velocity"]
[null,null,null,null,null,null,null,null,null,"VC - Selected Captor Velocity for contaminant"]
[null,null,"Fletcher Value for β",null,null,{"$f":"IFERROR((0.2*(((F8/1000)/(SQRT(F22)))^(-1/3))),\"\")","v":0.2201483877246925}]
[null,null,"Aspect Ratio",null,null,{"$f":"IFERROR(IF(OR(F10=\"Circle\",F10=\"Square\"),\"1\",F14/F13),\"\")","v":0.89189189189189189},null,null,null,"NOTE: A (free) phone App version can be downloaded from"]
[null,null,"Fletcher Value for α",null,null,{"$f":"IFERROR(((F8/1000)/(SQRT(F22)))*(F25^-F24),\"\")","v":0.76892174864907448},null,null,null,"your APP Store - search for \"OXYL8\""]
[]
[null,null,"Captor Velocity Required",null,null,0.5,"m/s","<-- Enter a Value"]
[null,null,null,null,null,null,null,"see table below:"]
[]
[null,"Min Hood Entry Velocity Required",null,null,null,{"$f":"IFERROR((F28)*(0.93+((8.58)*(F26^2))),\"\")","v":3.0014224122904114},"m/s","INVALID!"]
[null,"Hood Flowrate Required",null,null,null,{"$f":"IFERROR(F22*F31,\"\")","v":9.1618419135164803E-2},"m3/s"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Use Upper End of the above ranges where ANY of the following apply:-"]
[]
[]
[]
[]
[]
[]
[]
[null,"Disclaimer"]
[null,"This is a teaching aid.  We do believe it to be reasonably accurate and faithful to Fletcher's Equations - but DO BEWARE if being used in 'live' situations that there could be anomalies we have not yet detected :-)"]
[]
[]
[]
[null,"https://oxyl8.com",null,null,null,null,"© OXYL8 2022 v22.1"]

{"sheet":"Captor Distance","index":1,"n_rows":45,"n_cols":16,"rows_kept":45,"cut":false,"hidden":false,"merged":[[35,3,35,9],[40,3,42,9],[28,3,28,8],[0,3,0,9],[9,3,9,5],[11,3,11,5],[2,3,4,9],[19,3,19,8],[32,3,33,8],[32,9,33,9]]}
[null,null,null,"Captor Distance Calculator"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,null,"USE This version to calculate:-                                                   Effective Captor Distance from a Face Velocity"]
[]
[]
[]
[null,null,null,"To Use:  If any box in table below is shaded WHITE"]
[null,null,null,"then you need to select an option or add in a value"]
[]
[null,null,null,"Select Process/Operation:    ",null,null,1]
[]
[null,null,null,"Select Conditions:",null,null,"toxic materials/substances?",null,null,null,null,null,null,1]
[null,null,null,null,null,null,"high or continuous usage?",null,null,null,null,null,null,1]
[null,null,null,null,null,null,"a small captor hood?",null,null,null,null,null,null,1]
[null,null,null,null,null,null,"airflows away from the hood?",null,null,null,null,null,null,1]
[null,null,null,null,null,null,"draughts or air disturbances?",null,null,null,null,"Fletcher's original Equations (below)",2,2,2,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,"Capture Velocity required:",{"$f":"VLOOKUP(N16,VcLookup,IF(N24>1,5,4))","v":0.5},"m/s",null,1,1,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,1,1,1,1]
[null,null,null,"Select Captor Hood Shape:",null,null,null,null,null,null,null,null,1,1,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,1,1,1,1]
[null,null,null,null,null,null,null,null,{"$f":"IF(N26=1,\"Captor Hood Diameter:\",\"Captor Hood Length:\")","v":"Captor Hood Length:"},0.185,null,null,1,1,1,1]
[null,null,null,null,null,null,null,null,{"$f":"IF(MOD(N26,2)>=1,\"\",\"Captor Hood Width:\")","v":"Captor Hood Width:"},0.16500000000000001,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(N18:N22)","v":1}]
[null,null,null,null,null,null,null,null,"Captor Hood Area:",{"$f":"VLOOKUP(N26,HoodLookup,3,FALSE)","v":2.3974278937707112E-2},null,"Note: A (free) phone App version of this spreadsheet can be",null,4]
[null,null,null,null,null,null,null,null,"Aspect Ratio:",{"$f":"IF(MOD(N26,2)=0,MIN(J22:J23)/MAX(J22:J23),1)","v":0.891891891891892},null,"downloaded from your App Store.  Search for \"OXYL8\"",1,2,2,2]
[]
[]
[null,null,null,"ENTER Hood Entry Velocity Measured:",null,null,null,null,null,7.4,"m/s"]
[null,null,null,null,null,null,null,null,"Hood Entry Flowrate:",{"$f":"C_FaceVelocity*C_HoodArea","v":0.17740966413903264},"m3/s"]
[]
[]
[null,null,null,"Max Effective Capture Distance:",null,null,null,null,null,{"$f":"C_MaxEffectiveCapture","v":193}]
[]
[]
[null,null,null,"At Commissioning or TExT use the above distance to put on label attached to hood "]
[null,null,null,"AND - DO CHECK by smoke release that hood controls to AT LEAST that distance"]
[null,null,null,"Labels available from https://levshop.co.uk"]
[]
[null,null,null,"Disclaimer"]
[null,null,null,"This is a teaching aid.  We do believe it to be accurate and faithful to Fletcher's Equations - but DO BEWARE if being used in 'live' situations that there could be anomalies we have not yet detected :-)"]
[]
[]
[]
[null,null,null,"https://oxyl8.com",null,null,null,null,"© OXYL8 2022 v22.1"]

{"sheet":"DataTable","index":2,"n_rows":5,"n_cols":12,"rows_kept":5,"cut":false,"hidden":true,"merged":[[0,3,0,4]]}
["ID","Contaminant release","Process Example","Capture Velocity",null,null,"ID","Captor Hood Shape","Captor Hood Area",null,"Haz Substance?"]
[1,"Into still air with little or no energy","Evaporation, mist from electroplating tanks",0.25,0.5,null,1,"Circle",{"$f":"PI()*C_HD1/2*C_HD1/2","v":2.6880252142277669E-2},null,"No"]
[2,"Into fairly still air with low energy","Welding, soldering, liquid transfer",0.5,1,null,2,"Oval",{"$f":"PI()*C_HD1/2*C_HD2/2","v":2.3974278937707112E-2},null,"Yes"]
[3,"Into moving air with moderate energy","Crushing, spraying",1,2.5,null,3,"Square",{"$f":"C_HD1*C_HD1","v":3.4224999999999998E-2}]
[4,"Into turbulent air with high energy","Cutting, abrasive blasting, grinding",2.5,10,null,4,"Rectangle",{"$f":"C_HD1*C_HD2","v":3.0525E-2},null,"MECD",193]