{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Sheet1","Index","DropDown","Settings","Analyzers","Report"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":6,"comments":1,"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":"Sheet1","index":0,"n_rows":38,"n_cols":16,"rows_kept":38,"cut":false,"hidden":true,"merged":[]}
[]
[null,"ANALYZER DIFFICULTY INDEX"]
[]
["ITEM","ANAYZER TYPE","DETECTOR TYPE","MANUFACTURER","NUMBER OF ANALYZERS","CYCLE TIME IN MINUTES.  FOR CONTINUOUS ANALYZER = 1","NONE = 1                                 PACKED COLUMNS = 1.5 CAPILLARY COLUMNS = 2","APPLICATION 1=CONTINUOUS                            2= BACKFLUSH                               3=HEARTCUT/BACKFLUSH                                4=REVERSE COLUMN STEP","# OF COMPONENTS MEASURED","# OF STREAMS","VAPOR SAMPLE PHASE = 1              LIQUID SAMPLE PHASE = 2","IN SHELTER =1      OR  OUT OF SHELTER = 2","DIFFICULTY FACTOR","MANHOURS PER YEAR TO MAINTAIN","TOTAL MANHOURS"]
[]
[1,"CALORIMETER","THERMAL","COSA, THERMO, UNION",0,1,1,1,1,1,1,1,{"$f":"(10*F6*G6*H6*I6*J6*K6*L6)/10","v":1},{"$f":"(M6*52)*0.5","v":26},{"$f":"E6*N6","v":0}]
[{"$f":"A6+1","v":2},"CEMS","I/R-UV-CHEM","ABB, CALIFORNIA ANALYTICAL, EMERSON, SIEMENS, SERVOMEX, THERMO",0,1,1,1,1,1,1,1,{"$f":"(10*F7*G7*H7*I7*J7*K7*L7)/10","v":1},{"$f":"(M7*52)*1.6","v":83.2},{"$f":"E7*N7","v":0}]
[{"$f":"A7+1","v":3},"COLORIMETER","OPTICAL",null,0,1,1,1,1,1,1,1,{"$f":"(10*F8*G8*H8*I8*J8*K8*L8)/10","v":1},{"$f":"(M8*52)*0.4","v":20.8},0]
[4,"CONDUCTIVITY","ELECTROCHEMICAL","EMERSON, METTLER-TOLEDO, YOKOGAWA",0,1,1,1,1,1,1,1,{"$f":"(10*F9*G9*H9*I9*J9*K9*L9)/10","v":1},{"$f":"(M9*52)*0.4","v":20.8},0]
[5,"DENSITY","VARIOUS",null,0,1,1,1,1,1,1,1,1,{"$f":"(M10*52)*0.5","v":26},0]
[6,"DISSOLVED OXYGEN","ELECTROCHEMICAL","EMERSON, ENDRESS-HAUSER, YOKOGAWA",0,1,1,1,1,1,1,1,1,{"$f":"(M11*52)*0.8","v":41.6},0]
[7,"GAS CHROMATOGRAPH","TCD","ABB, EMERSON, SIEMENS, YOKOGAWA, OTHER",1,5,1.5,2,1,1,1,1,15,{"$f":"(M12*52)*0.35","v":273},273]
[8,"GAS CHROMATOGRAPH","FID","ABB, EMERSON, SIEMENS, YOKOGAWA, OTHER",0,5,1.5,2,1,1,1,1,15,{"$f":"(M13*52)*0.3","v":234},0]
[9,"GAS CHROMATOGRAPH","FPD","ABB, EMERSON, SIEMENS, YOKOGAWA, OTHER",0,5,1.5,2,1,1,1,1,15,{"$f":"(M14*52)*0.3","v":234},0]
[10,"GAS CHROMATOGRAPH","OTHER","ABB, EMERSON, SIEMENS, YOKOGAWA, OTHER",0,5,1.5,2,1,1,1,1,15,{"$f":"(M15*52)*0.3","v":234},0]
[11,"GAS DETECTION","BEAD","DETRONICS, GENERAL MONITOR, MSA",0,1,1,1,1,1,1,1,1,{"$f":"(M16*52)*0.35","v":18.2},0]
[12,"HARDNESS","VARIOUS",null,0,1,1,1,1,1,1,1,1,{"$f":"(M17*52)*0.5","v":26},0]
[13,"MOISTURE IN VAPOR","VARIOUS","COSA, PANAMETRICS, SHAW, OTHER",0,1,1,1,1,1,1,1,1,{"$f":"(M18*52)*0.55","v":28.6},0]
[14,"MOISTURE IN LIQUID","VARIOUS","COSA, PANAMETRICS, SHAW, OTHER",0,1,1,1,1,1,1,1,1,{"$f":"(M19*52)*0.55","v":28.6},0]
[15,"OIL IN WATER","VARIOUS",null,0,1,1,1,1,1,1,1,1,{"$f":"(M20*52)*0.8","v":41.6},0]
[16,"ORP","ION","ABB, EMERSON, SIEMENS, YOKOGAWA, OTHER",0,1,1,1,1,1,1,1,1,{"$f":"(M21*52)*0.5","v":26},0]
[{"$f":"A21+1","v":17},"OXYGEN","PARAMAGNETIC","ABB, EMERSON, HORIBA, SERVOMEX, SIEMENS, THERMO, OTHER",0,1,1,1,1,1,1,1,1,{"$f":"(M22*52)*0.8","v":41.6},0]
[{"$f":"A22+1","v":18},{"$f":"B22","v":"OXYGEN"},"ZIRCONIA","ABB, EMERSON, HORIBA, SERVOMEX, SIEMENS, THERMO, OTHER",0,1,1,1,1,1,1,1,1,{"$f":"(M23*52)*0.4","v":20.8},0]
[19,{"$f":"B23","v":"OXYGEN"},"QUINKE","ABB, EMERSON, HORIBA, SERVOMEX, SIEMENS, THERMO, OTHER",0,1,1,1,1,1,1,1,1,{"$f":"(M24*52)*0.5","v":26},0]
[20,{"$f":"B24","v":"OXYGEN"},"ELECTROCHEMICAL","ABB, EMERSON, HORIBA, SERVOMEX, SIEMENS, TELEDYNE,THERMO, OTHER",0,1,1,1,1,1,1,1,1,{"$f":"(M25*52)*0.8","v":41.6},0]
[21,"PH","ION","ABB, EMERSON, SIEMENS, YOKOGAWA, OTHER",0,1,1,1,1,1,1,1,1,{"$f":"(M26*52)*0.5","v":26},0]
[22,"PHYSICAL PROPERTY ","VARIOUS","BENKE",0,1,1,1,1,1,1,1,1,{"$f":"(M27*52)*0.85","v":44.199999999999996},0," "]
[23,"SILICA","ION","HACH",0,1,1,1,1,1,1,1,1,{"$f":"(M28*52)*0.85","v":44.199999999999996},0," "]
[24,"SPECTROMETER -FTIR","LIGHT","YOKOGAWA, OTHER",0,1,1,1,4,1,1,1,4,{"$f":"(M29*52)*0.85","v":176.79999999999998},0," "]
[25,"SPECTROMETER -INFRARED","LIGHT","ABB, EMERSON, HORIBA, SERVOMEX, SIEMENS, THERMO, OTHER",0,1,1,1,3,1,1,1,3,{"$f":"(M30*52)*0.55","v":85.800000000000011},0," "]
[26,"SPECTROMETER -MASS SPECTROMETER","QUADRAPOLE","ABB",0,1,1,1,1,1,1,1,1,{"$f":"(M31*52)*5","v":260},0," "]
[27,"SPECTROMETER -RAMAN","LIGHT",null,0,1,1,1,1,1,1,1,1,{"$f":"(M32*52)*2","v":104},0," "]
[28,"SPECTROMETER -TUNABLE DIODE LASSER","LIGHT","SERVOMEX, SPECTRA SENSORS, THERMO, OTHER",0,1,1,1,1,1,1,1,1,{"$f":"(M33*52)*0.75","v":39},0," "]
[29,"SPECTROMETER -ULTAVIOLET","LIGHT","ABB, EMERSON, HORIBA, SERVOMEX, SIEMENS, THERMO, OTHER",0,1,1,1,1,1,1,1,1,{"$f":"(M34*52)*1.25","v":65},0]
[30,"TOTAL ORGANIC ","LIGHT","BIODETECTOR,HACH,OTHER",0,1,1,1,1,1,1,1,1,{"$f":"(M35*52)*2","v":104},0]
[31,"TURBIDITY","LIGHT","HACH",0,1,1,1,1,1,1,1,1,{"$f":"(M36*52)*0.5","v":26},0]
[]
[null,"TOTAL MANPOWER REQUIRED",null,null,null,null,null,null,null,null,null,null,null," ",{"$f":"SUM(O6:O36)/1564","v":0.17455242966751919}]

{"sheet":"Index","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"DropDown","index":2,"n_rows":36,"n_cols":120,"rows_kept":36,"cut":false,"hidden":true,"merged":[]}
["CALORIMETER","Select","ComboBox08","ComboBox09","ComboBox14","ComboBox13",{"$f":"G2&G3","v":"ANAYZER TYPEDETECTOR TYPE"},{"$f":"H2&H3","v":"CALORIMETERTHERMAL"},{"$f":"I2&I3","v":"CEMSI/R-UV-CHEM"},{"$f":"J2&J3","v":"CEMSO2"},"CHLORINEVARIOUS","COLORIMETEROPTICAL","CONDUCTIVITYELECTROCHEMICAL","DENSITYVARIOUS","DISSOLVED OXYGENELECTROCHEMICAL",{"$f":"P2&P3","v":"FIXED POINT GAS DETECTIONVARIOUS"},"GAS CHROMATOGRAPHFID","GAS CHROMATOGRAPHFPD",{"$f":"S2&S3","v":"GAS CHROMATOGRAPHTCD"},"GAS CHROMATOGRAPHOTHER","HARDNESSVARIOUS","MELT INDEXVARIOUS","MFR POLYMER ANALYZERVARIOUS",{"$f":"X2&X3","v":"MOISTURE IN LIQUIDVARIOUS"},"MOISTURE IN VAPORVARIOUS","NH3VARIOUS","OIL IN WATERVARIOUS","OPACITYLIGHT","ORPION",{"$f":"AD2&AD3","v":"OXYGENELECTROCHEMICAL"},"OXYGENPARAMAGNETIC","OXYGENQUINKE",{"$f":"AG2&AG3","v":"OXYGENZIRCONIA"},"PHION","PHYSICAL PROPERTY VARIOUS","PORTABLE GAS DETECTIONELECTROCHEMICAL","SILICAION","SPECIFIC GRAIVITY ANALYZERVARIOUS","SPECTROMETER -FTIRLIGHT","SPECTROMETER -INFRAREDLIGHT","SPECTROMETER -MASS SPECTROMETERQUADRAPOLE","SPECTROMETER -RAMANLIGHT","SPECTROMETER -TUNABLE DIODE LASSERLIGHT","SPECTROMETER -ULTAVIOLETLIGHT","TAIL GAS ANALYZERCHEMILUMINESENCE","THERMO CONDUCTIVITY ANALYZERTCD",{"$f":"AU2&AU3","v":"TITRATORION"},"TOTAL HYDROCARBON ANALYZERFID","TOTAL ORGANIC LIGHT","TURBIDITYLIGHT",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,{"$f":"BA1","v":0}]
["CEMS","I/R-UV-CHEM","Select","Select","Select","Select","ANAYZER TYPE","CALORIMETER","CEMS","CEMS","CHLORINE","COLORIMETER","CONDUCTIVITY","DENSITY","DISSOLVED OXYGEN","FIXED POINT GAS DETECTION","GAS CHROMATOGRAPH","GAS CHROMATOGRAPH","GAS CHROMATOGRAPH","GAS CHROMATOGRAPH","HARDNESS","MELT INDEX","MFR POLYMER ANALYZER","MOISTURE IN LIQUID","MOISTURE IN VAPOR","NH3","OIL IN WATER","OPACITY","ORP",{"$f":"AF2","v":"OXYGEN"},"OXYGEN",{"$f":"AG2","v":"OXYGEN"},{"$f":"AE2","v":"OXYGEN"},"PH","PHYSICAL PROPERTY ","PORTABLE GAS DETECTION","SILICA","SPECIFIC GRAIVITY ANALYZER","SPECTROMETER -FTIR","SPECTROMETER -INFRARED","SPECTROMETER -MASS SPECTROMETER","SPECTROMETER -RAMAN","SPECTROMETER -TUNABLE DIODE LASSER","SPECTROMETER -ULTAVIOLET","TAIL GAS ANALYZER","THERMO CONDUCTIVITY ANALYZER","TITRATOR","TOTAL HYDROCARBON ANALYZER","TOTAL ORGANIC ","TURBIDITY"]
["CHLORINE","O2","None","Continuous","Daily","In","DETECTOR TYPE","THERMAL","I/R-UV-CHEM","O2","VARIOUS","OPTICAL","ELECTROCHEMICAL","VARIOUS","ELECTROCHEMICAL","VARIOUS","FID","FPD","TCD","OTHER","VARIOUS","VARIOUS","VARIOUS","VARIOUS","VARIOUS","VARIOUS","VARIOUS","LIGHT","ION","ELECTROCHEMICAL","PARAMAGNETIC","QUINKE","ZIRCONIA","ION","VARIOUS","ELECTROCHEMICAL","ION","VARIOUS","LIGHT","LIGHT","QUADRAPOLE","LIGHT","LIGHT","LIGHT","CHEMILUMINESENCE","TCD","ION","FID","LIGHT","LIGHT"]
["COLORIMETER",null,"Packed","Backflush","Weekly","Out","Variable",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
["CONDUCTIVITY",null,"Capillary","Heartcut/ BackFlush","Monthly",null,"Base Manhours",40,100,100,24,20,12,10,14,12,130,140,130,200,12.5,360,360,22.5,12,36,24,14,12,30,20,20,14,12,50,2,36,12,100,60,120,75,12,40,120,24,80,36,60,12,null,""]
["DENSITY",null,"Packed & Capillary","Reverse","User Defined",null,"MHrs-Per-Year",7,7,7,7,5,2,2,3,2.5,7,7.5,5,9,2.2000000000000002,9,9,3.4,2,7,3.5,2.5,2.2000000000000002,7,6,5,4,2.2000000000000002,7,2,5,5,7,5,9,7,7,7,9,5,9,5,9,2.2999999999999998,null,""]
["DISSOLVED OXYGEN",null,null,null,null,null,"Blank Cycle","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","No","No","No","No","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","yes","Yes","Yes","Yes",null,""]
["FIXED POINT GAS DETECTION",null,null,null,null,null,null,"COSA","ABB","ABB","EMERSON","APPLIED ANALYTICS","ABB","EMERSON","ABB","DETRONICS","ABB","ABB","ABB","ABB","ABB","DYNISCO","BRUKER","COSA","COSA","ABB","ADVANCED SENSORS","AMETEK","ABB","ABB","ABB","ABB","ABB","ABB","BENKE","DRAGER","ABB","AMETEK","ABB","ABB","ABB","AIT","SERVOMEX","ABB","AMETEK","ABB","APPLIKON","ABB","BIODETECTOR","HACH",null,""]
["GAS CHROMATOGRAPH",null,null,null,null,null,null,"THERMO","CALIFORNIA ANALYTICAL","CALIFORNIA ANALYTICAL","HACH","METROHM-APPLIKON","EMERSON","THERMO SCIENTIFIC","EMERSON","GENERAL MONITOR","EMERSON","EMERSON","EMERSON","EMERSON","HACH","POLYMER SOLUTIONS","OTHER","PANAMETRICS","PANAMETRICS","ECOTECH","APPLIED ANALYTICS","DURAG","EMERSON","EMERSON","EMERSON","EMERSON","EMERSON","EMERSON","OTHER","HORIBA","HACH","THERMO SCIENTIFIC","APPLITEK","CAI","AMETEK","EMERSON","SPECTRA","EMERSON","GALVANIC","EMERSON","OTHER","HORIBA","HACH","OTHER",null,""]
["HARDNESS",null,null,null,null,null,null,"UNION","EMERSON","EMERSON","SEVERN TRENT","OTHER","METTLER-TOLEDO","TOSHIBA","ENDRESS-HAUSER","MSA","SIEMENS","SIEMENS","SIEMENS","SIEMENS","THERMO SCIENTIFIC","SENSORS INCORPORATED",null,"SHAW","SHAW","NOVA","FMC","EMERSON","SIEMENS","HORIBA","HORIBA","HORIBA","HORIBA","SIEMENS","","LAND","THERMO","YOKOGAWA","BRUKER","EMERSON","EXTREL","HORIBA","THERMO","HORIBA","OTHER","HORIBA"," ","TELEDYNE","OTHER","",null,""]
["MELT INDEX",null,null,null,null,null,null,"OTHER","SERVOMEX","SERVOMEX","YOKOGAWA",null,"SIEMENS","YOKOGAWA","HACH","OTHER","OTHER","YOKOGAWA","YOKOGAWA","YOKOGAWA","WALTRON","OTHER",null,"OTHER","OTHER","TELEDYNE","GE","HORIBA","YOKOGAWA","LAND","LAND","LAND","LAND","YOKOGAWA",null,"MSA","WALTRON","OTHER","CAI","HORIBA","MKS INSTRUMENTS","KOSI","OTHER","YOKOGAWA",null,"SICK"," ","OTHER"]
["MFR POLYMER ANALYZER",null,null,null,null,null,null,"","SICK","SICK","OTHER","","YOKOGAWA","OTHER","THERMO SCIENTIFIC","","","OTHER","OTHER","OTHER","OTHER",null,null,"","","THERMO SCIENTIFIC","HORIBA","SICK","OTHER","SIEMENS","SIEMENS","SIEMENS","SIEMENS","OTHER","","NOVA","OTHER",null,"HORIBA","SERVOMEX","THERMO SCIENTIFIC","OTHER","","OTHER",null,"SIEMENS"," ",null,"",""]
["MOISTURE IN LIQUID",null,null,null,null,null,null,"","SIEMENS","SIEMENS",null,"","OTHER","","YOKOGAWA","","","","","","",null,null,"","","OTHER","OTHER","TELEDYNE","","TELEDYNE","TELEDYNE","TELEDYNE","TELEDYNE","","","OTHER","",null,"YOKOGAWA","SIEMENS","OTHER","","",null,null,"YOKOGAWA",null,null,"",""]
["MOISTURE IN VAPOR",null,null,null,null,null,null,"","OTHER","OTHER",null,"","","","OTHER","","","","","","",null,null,"","",null,"","OTHER","","THERMO","THERMO","THERMO","THERMO","","",null,"",null,"OTHER","YOKOGAWA","","","","",null,"OTHER",null,null,"",""]
["NH3",null,null,null,null,null,null,"","","","","","","","","","","","","",null,null,"",null,"","",null,"","","YOKOGAWA","YOKOGAWA","YOKOGAWA","YOKOGAWA","",null,"",null,"","","OTHER","","","",null,null,null,"",null,""]
["OIL IN WATER",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,"OTHER","OTHER","OTHER","OTHER"]
["OPACITY"]
["ORP"]
["OXYGEN"]
["PH"]
["PHYSICAL PROPERTY "]
["PORTABLE GAS DETECTION"]
["SILICA",null,null,null,null,null,null,"","","","","","","","","","","","","",null,null,"",null,"","",null,"","","","","","","","","","","","","","","","","","",null,"",null,"",""]
["SPECIFIC GRAIVITY ANALYZER",null,null,null,null,null,null,"","","","","","","","","","","","","",null,null,"",null,"","",null,"","","","","","","","","","","","","","","","","","",null,"",null,"",""]
["SPECTROMETER -FTIR"]
["SPECTROMETER -INFRARED",null,null,null,null,null,null,"","","","","","","","","","","","","",null,null,"",null,"","",null,"","","","","","","","","","","","","","","","","","",null,"",null,"",""]
["SPECTROMETER -MASS SPECTROMETER",null,null,null,null,null,null,"","","","","","","","","","","","","",null,null,"",null,"","",null,"","","","","","","","","","","","","","","","","","",null,"",null,"",""]
["SPECTROMETER -RAMAN",null,null,null,null,null,null,"","","","","","","","","","","","","",null,null,"",null,"","",null,"","","","","","","","","","","","","","","","","","",null,"",null,"",""]
["SPECTROMETER -TUNABLE DIODE LASSER"]
["SPECTROMETER -ULTAVIOLET"]
["TAIL GAS ANALYZER"]
["THERMO CONDUCTIVITY ANALYZER"]
["TITRATOR"]
["TOTAL HYDROCARBON ANALYZER"]
["TOTAL ORGANIC "]
["TURBIDITY"]

{"sheet":"Settings","index":3,"n_rows":40,"n_cols":4,"rows_kept":40,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Specialist",15000,{"$f":"\"=(Total Manhours)/\"&C2&\")\"","v":"=(Total Manhours)/15000)"}]
[null,"Sr. Analyer Tech",7500,{"$f":"\"=(Total Manhours)/\"& C3 & \")\"","v":"=(Total Manhours)/7500)"}]
[null,"AX Tech",5000,{"$f":"\"=(Total Manhours)/\" &C4 &\")\"","v":"=(Total Manhours)/5000)"}]
[null,"Jr. Techs Hrs",1768,{"$f":"\"=(Total Manhours)-((Specialist + Sr. Analyer Tech + AX Tech)*\" &C5& \")\"","v":"=(Total Manhours)-((Specialist + Sr. Analyer Tech + AX Tech)*1768)"}]
[null,"Jr Techs",1768,{"$f":"\"=(Jr Techs Hrs)/\" & C6 &\")\"","v":"=(Jr Techs Hrs)/1768)"}]
[null,"Engineering Staff",30000,"=(Total Manhours / 30000)"]
[null,"Flush Values"]
[null,"Continuous",0]
[null,"Backflush",10]
[null,"Heartcut/Backflush",40]
[null,"Reverse",40]
[]
[null,"Column Values"]
[null,"None",0]
[null,"Packed",10]
[null,"Capillary",30]
[null,"Packed & Capillary",60]
[]
[null,"Cycle Time"]
[null,"=0",0]
[null,"> 0 and  <=5 mins",30]
[null,"> 5 mins",10]
[]
[null,"Shelter"]
[null,"In",0]
[null,"Out",30]
[]
[null,"Age of Analyzers"]
[null,"Less then 2 Yrs",1.25,"Less then 2 Yrs"]
[null,"2 to 8 Yrs",1,"2 to 8 Yrs"]
[null,"Greater then 9yrs",1.35,"Greater then 9yrs"]
[]
[]
[]
[]
[null,"Frequency"]
[null,"Daily",80]
[null,"Weekly",60]
[null,"Monthly",20]

{"sheet":"Analyzers","index":4,"n_rows":4,"n_cols":120,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
["Facility Name","Location","Date","Compiled by","Report Comments","Project Comments",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,{"$f":"IFERROR(60/AL1,0)","v":0},{"$f":"HLOOKUP(D1&F1,DropDown!$H$1:$BE$4,4,FALSE)","v":{"$error":"#N/A"}},null,{"$f":"(Azer($E1,$D1,$F1)+CycleTime($M1)+Cols($N1)+flush($O1)+($P1*10)+(($Q1+$R1+$S1+$T1+$U1+$V1+$W1+$X1+$Y1+$Z1)*10)+(($AB1+$AC1+$AD1)*10)+($AF1*20)+($AG1*50)+($AH1*80)+($AH1*80)+($AI1*80)+shelter($AJ1)+AM1)/10*$AN1*AA1","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($D1&$F1,DropDown!$H$1:$BE$6,6,FALSE)","v":{"$error":"#N/A"}},{"$f":"$AQ1*$AP1*L1","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($D1&$F1,DropDown!$H$1:$BE$6,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"$L1*$AR1","v":{"$error":"#N/A"}},null,{"$f":"$AT1/15000","v":{"$error":"#N/A"}},{"$f":"$AT1/7000","v":{"$error":"#N/A"}},{"$f":"$AT1/5000","v":{"$error":"#N/A"}},{"$f":"$AT1-(($AV1+$AW1+$AX1)*1768)","v":{"$error":"#N/A"}},{"$f":"$AY1/1768","v":{"$error":"#N/A"}},{"$f":"$AT1/30000","v":{"$error":"#N/A"}},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,{"$f":"B1","v":"Location"},{"$f":"L1","v":0},{"$f":"C1","v":"Date"},{"$f":"D1","v":"Compiled by"},{"$f":"F1","v":"Project Comments"},{"$f":"H1","v":0},{"$f":"J1","v":0},{"$f":"AP1","v":{"$error":"#VALUE!"}},{"$f":"AR1","v":{"$error":"#N/A"}},{"$f":"AT1","v":{"$error":"#N/A"}},null,{"$f":"AV1","v":{"$error":"#N/A"}},{"$f":"AW1","v":{"$error":"#N/A"}},{"$f":"AX1","v":{"$error":"#N/A"}},{"$f":"BA1","v":{"$error":"#N/A"}},{"$f":"AZ1","v":{"$error":"#N/A"}}]
[]
[null,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,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,{"$f":"SUM(DI5:DI5000)","v":0},{"$f":"SUM(DJ5:DJ4963)","v":0},null,{"$f":"IFERROR(#REF!/15000,\"\")","v":""},{"$f":"IFERROR(#REF!/7000,\"\")","v":""},{"$f":"IFERROR(#REF!/5000,\"\")","v":""},{"$f":"IFERROR(#REF!-((#REF!+#REF!+#REF!)*1768),\"\")","v":""},{"$f":"IFERROR(#REF!/1768,\"\")","v":""}]
[{"$f":"B4&\" - \" &C4& \" - \" & D4","v":"Analyzer # - Analyzer Location - Analyzer Type"},"Analyzer #","Analyzer Location","Analyzer Type","# Detectors","Detector 1","Manufacture 1","Detector 2","Manufacture 2","Detector 3","Manufacture 3","Qty","Cycle Time","Columns","Application","# Stream","Components 1","Components 2","Components 3","Components 4","Components 5","Components 6","Components 7","Components 8","Components 9","Components 10","Age of Analyzers","Primary Gas","Primary Liquid","Primary Solid","# Sample","Sample Gas","Sample Liquid","Sample Both","Sample Solid","Shelter","Freq","Freq#","Freq Factor","Factor for Difficulty",null,"Difficulty Factor","MHr Factor","Man hrs to Maintain","Base Man hrs","Total Man hrs",null,"Specialist","Sr. Analyer Tech","AX Tech","Jr. Techs Hrs","Jr Techs","Eng. Staff",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,{"$f":"B4","v":"Analyzer #"},{"$f":"L4","v":"Qty"},{"$f":"C4","v":"Analyzer Location"},{"$f":"D4","v":"Analyzer Type"},{"$f":"F4","v":"Detector 1"},{"$f":"H4","v":"Detector 2"},{"$f":"J4","v":"Detector 3"},{"$f":"AP4","v":"Difficulty Factor"},{"$f":"AR4","v":"Man hrs to Maintain"},{"$f":"AT4","v":"Total Man hrs"},null,{"$f":"AV4","v":"Specialist"},{"$f":"AW4","v":"Sr. Analyer Tech"},{"$f":"AX4","v":"AX Tech"},{"$f":"BA4","v":"Eng. Staff"},{"$f":"AZ4","v":"Jr Techs"}]

{"sheet":"Report","index":5,"n_rows":13,"n_cols":11,"rows_kept":13,"cut":false,"hidden":false,"merged":[[5,2,5,10]]}
[]
[null,"Facility Name"]
[null,"Location"]
[null,"Date"]
[null,"Compiled By"]
[null,"Comments"]
[]
[]
[null,null,null,null,"Engineering Staff","Specialist","Sr. Analyzer Technicians","AX Technicians","Jr Techs",null,"Total Manhours"]
[null,null,null,null,".",".",".",".","."]
[]
[null,"Analyzer Details"]
[null,"Analyzer No.","Analyzer Location","Analyzer Type","Detector Type 1","Detector Type 2","Detector Type 3",null,"Difficulty Factor","Manhours per Year to Maintain","Manhours"]