{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["SurveyLog","Instr1","Instr2","Instr3","Breach","Info","Headers","All_Stats","Checks","CTDAQC_","METADATA_"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":105,"comments":4,"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":"SurveyLog","index":0,"n_rows":41,"n_cols":34,"rows_kept":41,"cut":false,"hidden":false,"merged":[[3,12,3,13],[5,1,5,2],[5,17,5,18],[3,17,3,18],[3,1,3,2],[3,6,3,8],[3,9,3,11],[8,6,8,7],[4,1,4,2],[4,9,4,11],[5,9,5,11],[4,6,4,7],[5,6,5,7],[6,9,6,11],[7,9,7,11],[8,9,8,11],[6,6,6,7],[7,6,7,7],[8,12,8,13],[4,12,4,13],[5,12,5,13],[4,17,4,18],[6,12,6,13],[7,12,7,13],[6,17,6,18],[7,23,7,24],[8,23,8,24],[4,33,4,34],[4,26,4,32],[4,23,4,24],[5,23,5,24],[6,23,6,24]]}
[null,"Survey Log version 21.10.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,"Columns to add ",5]
[]
[null,"Date (d/m/y)",null,null,"Vessel name",null,"Completed by",null,null,"Survey title(s)",null,null,"Survey activity",null,null,"Instr. ID(s)","Config.","AQC batch number",null,null,"Tide","Time UTC","Date (if diff.)","Port name",null,null,"Path to master survey data folder",null,null,null,null,null,null,"Log filename"]
[null,"2022-01-19",null,null,"Humber Guardian",{"$f":"IF(ISBLANK(E5),0,IF(ISNA(VLOOKUP(E5,vessel_table,2,FALSE)),\"ZX\",VLOOKUP(E5,vessel_table,2,FALSE)))","v":"HG"},"Nick Meaton",null,{"$f":"IF(ISBLANK(G5),\"\",IF(ISNA(VLOOKUP(G5,sampler_table,2,FALSE)),\"ZX\",VLOOKUP(G5,sampler_table,2,FALSE)))","v":"NM_"},"Teeside Crustcacean Death Investigation",null,null,"Fish trawling",null,1,null,null,{"$f":"IF(ISBLANK($P5),\"\",Instr1!$T$2)","v":""},null,{"$f":"IF(AND($U5=\"High water\",ISNUMBER($V5)),IF(ISBLANK($W5),$B$5+$V5,$W5+$V5))","v":"2022-01-19T04:34:00"},"High water","04:34:00",null,"Tees Entrance",null,{"$f":"IF(AND(BST_start<T5,BST_end>T5),T5+0.041667,T5)","v":"2022-01-19T04:34:00"},"C:\\Users\\nmeaton\\OneDrive - Defra\\Survey Data",null,null,null,null,null,null,{"$f":"VLOOKUP($E$7,region_table,2,FALSE)&\" \"&YEAR($B$5)&\"-\"&TEXT(MONTH($B$5),\"00\")&TEXT(DAY($B$5),\"00\")&\" \"&VLOOKUP($E$5,vessel_table,2,FALSE)","v":"EA 2022-0119 HG"}]
[null,{"$f":"IF(ISBLANK(B5),\"\",B5)","v":"2022-01-19"},null,null,"Area of operation",null,"Other survey personnel",null,null,null,null,null,null,null,2,null,null,{"$f":"IF(ISBLANK($P6),\"\",Instr2!$T$2)","v":""},null,{"$f":"IF(AND($U6=\"High water\",ISNUMBER($V6)),IF(ISBLANK($W6),$B$5+$V6,$W6+$V6))","v":"2022-01-19T16:46:00"},"High water","16:46:00",null,null,null,{"$f":"IF(AND(BST_start<T6,BST_end>T6),T6+0.041667,T6)","v":"2022-01-19T16:46:00"}]
[null,null,null,null,"East Coast",{"$f":"IF(ISBLANK(E7),0,VLOOKUP(E7,region_table,2))","v":"EA"},"Richard Castelino",null,null,null,null,null,null,null,3,null,null,{"$f":"IF(ISBLANK($P7),\"\",Instr3!$T$2)","v":""},null,{"$f":"IF(AND($U7=\"High water\",ISNUMBER($V7)),IF(ISBLANK($W7),$B$5+$V7,$W7+$V7))","v":false},null,null,null,null,null,{"$f":"IF(AND(BST_start<T7,BST_end>T7),T7+0.041667,T7)","v":false}]
[null,null,null,null,"Survey folder",null,"Gareth King",null,null,null,null,null,null,null,null,{"$f":"IF(Raw_cast_count>0,\"Number of CTD casts logged = \"&Raw_cast_count,\"\")","v":""},null,null,null,{"$f":"IF(AND($U8=\"High water\",ISNUMBER($V8)),IF(ISBLANK($W8),$B$5+$V8,$W8+$V8))","v":false},null,null,null,null,null,{"$f":"IF(AND(BST_start<T8,BST_end>T8),T8+0.041667,T8)","v":false}]
[null,null,null,null,"Teeside Crustcacean Death Investigation",null,"",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND($U9=\"High water\",ISNUMBER($V9)),IF(ISBLANK($W9),$B$5+$V9,$W9+$V9))","v":false},null,null,null,null,null,{"$f":"IF(AND(BST_start<T9,BST_end>T9),T9+0.041667,T9)","v":false}]
[null,null,null,null,null,null,null,null,null,null,"Log narrative and / or data (use first row for column headers)"]
[null,null,"Time\nBST","Time\nUTC","Site name and / or\nsample point code","WGS84\nLatitude","WGS84\nLongitude","OSGB36\nEasting","OSGB36\nNorthing","Water Depth (m)","Speed over ground (kts)","Course over ground (°)","Time BST of nearest HW","Time h:mm relative to prev. HW","Remarks"]
[null,{"$f":"ROW()-11","v":1},{"$f":"IF(OR(ISBLANK(B$5),ISBLANK(D12)),\"\",IF(AND(BST_start<$B$5+D12,BST_end>$B$5+D12),$B$5+D12+0.041667,$B$5+D12))","v":44580.28564814815},"06:51:20",null,null,null,null,null,null,"Visiting staff on board and leave berth in Hartlepool Marina"]
[null,2,44580.34952546296,"08:23:19","05 (Skinningrove Wick) SHOOT","54°34.9074'N","0°51.5042'W",473881,521329,16.61,4.1399999999999997,275.5,44580.19027777778,"03:49:26"]
[null,3,44580.363935185182,"08:44:04","05 (Skinningrove Wick) HAUL","54°35.2222'N","0°52.9498'W",472314,521888,16.13,2.69,294.5,44580.19027777778,"04:10:04","74 x L. holsatus (90% F, several with eggs) and 1 x C. cassivelaunus, all alive and active and showing apparently normal behaviour. Also numerous whiting and dab."]
[null,4,""]
[null,5,44580.391400462962,"09:23:37","06 (Sea off Saltburn 5) SHOOT","54°36.2076'N","0°56.7146'W",468232,523653,15.78,3.77,289.5,44580.19027777778,"04:49:00"]
[null,6,44580.404293981483,"09:42:11","06 (Sea off Saltburn 5) HAUL","54°36.5413'N","0°58.0200'W",466818,524251,17.940000000000001,3.38,291.5,44580.19027777778,"05:08:15","16 x L. holsatus (14 x F, 1 with eggs) and 1 x C. pagarus (M, 120 mm carapace width and showing good claw strength) all alive and active and showing apparently normal behaviour. Also numerous whiting, dab and plaice and E. esculentus and A. digitatum."]
[null,7,""]
[null,8,44580.430138888885,"10:19:24","07 (Sea off Redcar 4) SHOOT","54°37.9690'N","1°05.2482'W",459003,526791,8.57,2.89,289.39999999999998,44580.19027777778,"05:45:30"]
[null,9,44580.446469907409,"10:42:55","07 (Sea off Redcar 4) HAUL","54°38.4983'N","1°06.5800'W",457557,527754,10.52,2.9,309.2,44580.698611111111,"06:09:03","No crustacean species caught, but several whiting, saithe, dab and plaice present"]
[null,10,""]
[null,11,44580.457037037035,"10:58:08","09 (Dredged channel) SHOOT","54°39.3539'N","1°07.5008'W",456547,529328,14.1,3.38,43.6,44580.698611111111,"06:24:00"]
[null,12,44580.47179398148,"11:19:23","09 (Dredged channel) HAUL","54°39.9101'N","1°06.5183'W",457590,530373,19.48,3.59,123.3,44580.698611111111,"06:45:31","Gear completely empty"]
[null,13,""]
[null,14,44580.479317129626,"11:30:13","13 (Tees Bay) SHOOT","54°39.5096'N","1°04.7786'W",459470,529654,22.66,4.3,102.3,44580.698611111111,"06:56:19"]
[null,15,44580.493287037039,"11:50:20","13 (Tees Bay) HAUL","54°39.0559'N","1°03.3135'W",461057,528834,24.53,2.9,126.1,44580.698611111111,"07:16:17","Gear completely empty"]
[null,16,""]
[null,17,44580.516828703701,"12:24:14","10 (Seaton Carew) SHOOT","54°39.1186'N","1°09.0769'W",454858,528871,9.91,2.5,333.5,44580.698611111111,"07:50:00"]
[null,18,44580.538298611114,"12:55:09","10 (Seaton Carew) HAUL","54°40.2555'N","1°09.9776'W",453864,530968,10.43,3.37,45.6,44580.698611111111,"08:21:00","13 x L. holsatus (12 x F) all alive and fairly active and showing apparently normal behaviour, although aggressive response perhaps slightly subdued. Also numerous whiting, dab, plaice, etc."]
[null,19,""]
[null,20,44580.548460648148,"13:09:47","12 (Hartlepool Bay) SHOOT","54°40.9382'N","1°08.8981'W",455009,532248,16.03,3.04,123.1,44580.698611111111,"08:35:00"]
[null,21,44580.569548611114,"13:40:09","12 (Hartlepool Bay) HAUL","54°40.6282'N","1°09.0235'W",454881,531671,14.78,2.0499999999999998,300.5,44580.698611111111,"09:06:00","2 x L. holsatus (both F) both alive and fairly active and showing apparently normal behaviour. Also a few whiting and dab."]
[null,22,""]
[null,23,44580.61041666667,"14:39:00",null,null,null,null,null,null,"Back alongside berth in Hartlepool Marina"]
[null,24,""]
[null,25,""]
[null,26,""]
[null,27,""]
[null,28,""]
[]
[null,"Rows to add",null,5]

{"sheet":"Instr1","index":1,"n_rows":26,"n_cols":21,"rows_kept":26,"cut":false,"hidden":false,"merged":[[16,11,17,11],[12,9,13,9],[16,12,17,12],[13,5,13,6],[16,8,17,8],[16,9,17,9],[16,10,17,10],[12,7,13,7],[12,8,13,8],[16,7,17,7],[12,10,13,10],[18,19,19,19],[18,16,19,16],[4,18,5,18],[4,15,5,15],[4,16,5,16],[18,15,19,15],[12,15,13,15],[16,15,17,15],[14,18,15,18],[14,15,15,15],[16,18,17,18],[6,19,11,19],[9,15,11,15],[9,16,11,16],[12,16,13,16],[6,18,11,18],[4,19,5,19],[16,14,17,14],[4,13,5,13],[12,13,13,13],[1,1,1,2],[1,4,1,6],[4,6,5,6],[4,8,5,8],[4,7,5,7],[4,1,5,1],[4,2,5,2],[4,3,5,3],[4,4,5,4],[4,5,5,5],[16,13,17,13],[12,14,13,14],[4,9,5,9],[4,10,5,10],[4,11,5,11],[4,12,5,12],[12,12,13,12],[12,11,13,11],[22,18,25,18],[22,19,25,19],[12,17,13,17],[20,15,21,15],[14,16,15,16],[12,19,13,19],[18,18,19,18],[16,19,17,19],[16,16,17,16],[12,18,13,18],[20,19,21,19],[20,18,21,18],[20,17,21,17],[20,16,21,16],[16,17,17,17],[14,19,15,19]]}
[null,"Instrument 1 ID",null,null,"Completed by",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Batch number"]
[null,{"$f":"IF(ISBLANK(SurveyLog!P5),\"\",SurveyLog!P5)","v":""},null,{"$f":"HLOOKUP($B$2,turg_range1,25,FALSE)","v":{"$error":"#NAME?"}},null,null,null,{"$f":"IF(ISBLANK(E2),0,IF(ISNA(VLOOKUP(E2,Info!$F$2:$G$53,2,FALSE)),\"ZXY\",VLOOKUP(E2,Info!$F$2:$G$53,2,FALSE)))","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($U$2=0,\"NOT AVAILABLE\",BATCH($U$2,$U$2))","v":"NOT AVAILABLE"},{"$f":"DMIN(U6:U22,1,U$4:U$5)","v":"00:00:00"}]
[null,{"$f":"IF(ISBLANK(SurveyLog!P5),\"Please enter instrument ID on 'SurveyLog' sheet.\",VLOOKUP($B$2,instr_table,2,FALSE)&\" (\"&VLOOKUP($B$2,instr_table,4,FALSE)&\") manufacturer's serial number: \"&VLOOKUP($B$2,instr_table,3,FALSE))","v":"Please enter instrument ID on 'SurveyLog' sheet."}]
[null,"Pre-survey checks / calibration",null,null,null,null,null,null,"During / post-survey checks",null,null,null,null,null,null,"Alerts",null,null,null,null,"DateTime"]
[null,"Date","Time UTC","Temp (°C)","Instr reading","Value","Error",null,"Date","Time UTC","Temp (°C)","Instr reading","Value","Error",null,"Range\n(drift)","Message",null,"Include in AQC file?","Remarks\n(reason for breach or to exclude results)",">0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DateTime"]
["DO 0% ",null,null,null,null,0,{"$f":"IF(OR($B$2=\"\",ISBLANK(E7)),\"\",E7-F7)","v":""},{"$f":"Checks!N2","v":""},null,null,null,null,0,{"$f":"IF(OR($B$2=\"\",ISBLANK(L7)),\"\",L7-M7)","v":""},{"$f":"Checks!O2","v":""},{"$f":"IF(OR($B$2=\"\",ISBLANK(E7),ISBLANK(L7)),\"\",MAX(G7,N7)-MIN(G7,N7))","v":""},{"$f":"CHKDRF(P7,Checks!F2,Checks!G2,Checks!E2)","v":""},null,"Y",null,{"$f":"IF(OR(ISBLANK(B7),ISBLANK(C7)),0,B7+C7)","v":"00:00:00"}]
[]
[null,null,null,"DO membrane / optical cap ID =",null,{"$f":"IF(OR(VLOOKUP($B$2,instr_table,6,FALSE)=\"#N/A\",VLOOKUP($B$2,instr_table,6,FALSE)=0),IF(E9=\"Optical DO\",\"Enter cap # on 'Info'\",\"\"),VLOOKUP($B$2,instr_table,6,FALSE))","v":{"$error":"#N/A"}}]
["DO 100% ",null,null,null,null,100,{"$f":"IF(OR($B$2=\"\",ISBLANK(E10)),\"\",E10-F10)","v":""},{"$f":"CHKRES(E10,Checks!$F$3,Checks!$C$3,CTDAQC_!$I$3,Checks!$B$3,Checks!$D$3,Checks!$G$3,Checks!$E$3)","v":{"$error":"#VALUE!"}},null,null,null,null,100,{"$f":"IF(OR($B$2=\"\",ISBLANK(L10)),\"\",L10-M10)","v":""},{"$f":"CHKRES(L10,Checks!$F$3,Checks!$C$3,CTDAQC_!$I$3,Checks!$B$3,Checks!$D$3,Checks!$G$3,Checks!$E$3)","v":{"$error":"#VALUE!"}},{"$f":"IF(OR($B$2=\"\",ISBLANK(E10),COUNT(L10:L12)=0),\"\",MAX(G10,N10:N12)-MIN(G10,N10:N12))","v":""},{"$f":"CHKDRF(P10,Checks!F3,Checks!G3,Checks!E3)","v":""},null,null,null,{"$f":"IF(OR(ISBLANK(B10),ISBLANK(C10)),0,B10+C10)","v":"00:00:00"}]
[null,null,null,{"$f":"IF($E$9=\"Optical DO\",\"Signal intensity (if cal'd) =\",\"DO calibration slope (if cal'd) =\")","v":"DO calibration slope (if cal'd) ="},null,{"$f":"IF($E$9=\"Optical DO\",CTDAQC_!I4,Checks!$B$4)","v":{"$error":"#N/A"}},{"$f":"IF(OR($B$2=\"\",ISBLANK(E11)),\"\",E11-F11)","v":""},{"$f":"Checks!N4","v":""},null,null,null,null,100,{"$f":"IF(OR($B$2=\"\",ISBLANK(L11)),\"\",L11-M11)","v":""},{"$f":"CHKRES(L11,Checks!$F$3,Checks!$C$3,CTDAQC_!$I$3,Checks!$B$3,Checks!$D$3,Checks!$G$3,Checks!$E$3)","v":{"$error":"#VALUE!"}}]
[null,null,null,{"$f":"IF($E$9=\"Optical DO\",\"Ambient light intensity (if cal'd) =\",\"DO calibration current (if cal'd) =\")","v":"DO calibration current (if cal'd) ="},null,{"$f":"IF(E9=\"Optical DO\",CTDAQC_!I5,\"\")","v":""},{"$f":"IF(OR($B$2=\"\",ISBLANK(E12),F12=\"\"),\"\",E12-F12)","v":""},{"$f":"Checks!N5","v":""},null,null,null,null,100,{"$f":"IF(OR($B$2=\"\",ISBLANK(L12)),\"\",L12-M12)","v":""},{"$f":"CHKRES(L12,Checks!$F$3,Checks!$C$3,CTDAQC_!$I$3,Checks!$B$3,Checks!$D$3,Checks!$G$3,Checks!$E$3)","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,"Salinity standard batch ID ="]
["Salinity ",null,null,null,null,{"$f":"IF(ISNUMBER(VLOOKUP($F$14,sal_std_vals,2,FALSE)),ROUND(VLOOKUP($F$14,sal_std_vals,2,FALSE),3),IF(AND(ISNUMBER(F16),ISTEXT(F14)),F16,#N/A))","v":{"$error":"#N/A"}},{"$f":"IF(OR($B$2=\"\",ISBLANK(E15),ISBLANK($F$14)),\"\",E15-F15)","v":""},{"$f":"Checks!N6","v":""},null,null,null,null,{"$f":"F15","v":{"$error":"#N/A"}},{"$f":"IF(OR($B$2=\"\",ISBLANK(L15),ISBLANK($F$14)),\"\",L15-M15)","v":""},{"$f":"Checks!O6","v":""},{"$f":"IF(OR($B$2=\"\",ISBLANK(E15),COUNT(L15:L16)=0,ISBLANK($F$14)),\"\",MAX(G15,N15:N16)-MIN(G15,N15:N16))","v":""},{"$f":"CHKDRF(P15,Checks!F6,Checks!G6,Checks!E6)","v":""},null,"Y",null,{"$f":"IF(OR(ISBLANK(B15),ISBLANK(C15)),0,B15+C15)","v":"00:00:00"}]
[null,null,null,null,{"$f":"IF(AND(OR(ISNUMBER(VLOOKUP($F$14,sal_std_vals,2,FALSE)),NOT(ISTEXT(F14))),ISBLANK(F16)),\"\",\"Salinity standard certified value = \")","v":""},null,null,null,null,null,null,null,{"$f":"F15","v":{"$error":"#N/A"}},{"$f":"IF(OR($B$2=\"\",ISBLANK(L16),ISBLANK($F$14)),\"\",L16-M16)","v":""},{"$f":"Checks!P6","v":""}]
[]
[null,null,null,null,"pH buffer ="]
[{"$f":"IF(ISBLANK(F18),\"pH _ ? \",F18)","v":"pH _ ? "},null,null,null,null,{"$f":"IF(OR(ISBLANK(D19),ISBLANK($F$18)),#N/A,ROUND(VLOOKUP($A$19,pH_table,2,FALSE)*(D19)^2-VLOOKUP($A$19,pH_table,3,FALSE)*(D19)+VLOOKUP($A$19,pH_table,4,FALSE),3))","v":{"$error":"#N/A"}},{"$f":"IF(OR($B$2=\"\",ISBLANK($F$18),ISBLANK(D19),ISBLANK(E19)),\"\",ROUND(E19-F19,3))","v":""},{"$f":"Checks!N7","v":""},null,null,null,null,{"$f":"IF(OR(ISBLANK(K19),ISBLANK($F$18)),#N/A,ROUND(VLOOKUP($A$19,pH_table,2,FALSE)*(K19)^2-VLOOKUP($A$19,pH_table,3,FALSE)*(K19)+VLOOKUP($A$19,pH_table,4,FALSE),3))","v":{"$error":"#N/A"}},{"$f":"IF(OR($B$2=\"\",ISBLANK($F$18),ISBLANK(K19),ISBLANK(L19)),\"\",ROUND(L19-M19,3))","v":""},{"$f":"Checks!O7","v":""},{"$f":"IF(OR($B$2=\"\",ISBLANK(D19),ISBLANK(E19),COUNT(K19:K20)=0,COUNT(L19:L20)=0),\"\",MAX(G19,N19:N20)-MIN(G19,N19:N20))","v":""},{"$f":"CHKDRF(P19,Checks!F7,Checks!G7,Checks!E7)","v":""},null,"Y",null,{"$f":"IF(OR(ISBLANK(B19),ISBLANK(C19)),0,B19+C19)","v":"00:00:00"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISBLANK(K20),ISBLANK($F$18)),#N/A,ROUND(VLOOKUP($A$19,pH_table,2,FALSE)*(K20)^2-VLOOKUP($A$19,pH_table,3,FALSE)*(K20)+VLOOKUP($A$19,pH_table,4,FALSE),3))","v":{"$error":"#N/A"}},{"$f":"IF(OR($B$2=\"\",ISBLANK($F$18),ISBLANK(K20),ISBLANK(L20)),\"\",ROUND(L20-M20,3))","v":""},{"$f":"Checks!P7","v":""}]
[null,null,null,"Turgetto ID =",{"$f":"VLOOKUP($B$2,instr_table,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP(CTDAQC_!B8,CTD_stats,8,FALSE)<(B22-183),\" WARNING! Turgetto stats are > 6 month old: please use Ctrl + T to update stats.\",\"\")","v":""}]
["Turbidity ",null,null,null,null,{"$f":"IF(ISERR($E$21),#N/A,VLOOKUP(CTDAQC_!B8,CTD_stats,9))","v":{"$error":"#N/A"}}," = FTU",null,null,null,null,null,{"$f":"F22","v":{"$error":"#N/A"}}," = FTU",null,null,null,null,null,null,{"$f":"IF(OR(ISBLANK(B22),ISBLANK(C22)),0,B22+C22)","v":"00:00:00"}]
[null,null,null,"Optical scale 0 (raw counts) =",null,{"$f":"IF(ISERR($E$21),#N/A,VLOOKUP(CTDAQC_!B8,CTD_stats,4))","v":{"$error":"#N/A"}},{"$f":"IF(OR($B$2=\"\",ISBLANK(E23)),\"\",E23-F23)","v":""},{"$f":"Checks!N8","v":""},null,null,"Optical scale 0 (raw counts) =",null,{"$f":"F23","v":{"$error":"#N/A"}},{"$f":"IF(OR($B$2=\"\",ISBLANK(L23)),\"\",L23-M23)","v":""},{"$f":"Checks!O8","v":""},{"$f":"IF(OR($B$2=\"\",ISBLANK(E23),ISBLANK(L23)),\"\",MAX(G23,N23)-MIN(G23,N23))","v":""},{"$f":"CHKDRF(P23,Checks!F8,Checks!G8,Checks!E8)","v":""},null,"Y"]
[null,null,null,"Optical scale 1 (raw counts) =",null,{"$f":"IF(ISERR($E$21),#N/A,VLOOKUP(CTDAQC_!B9,CTD_stats,4))","v":{"$error":"#N/A"}},{"$f":"IF(OR($B$2=\"\",ISBLANK(E24)),\"\",E24-F24)","v":""},{"$f":"Checks!N9","v":""},null,null,"Optical scale 1 (raw counts) =",null,{"$f":"F24","v":{"$error":"#N/A"}},{"$f":"IF(OR($B$2=\"\",ISBLANK(L24)),\"\",L24-M24)","v":""},{"$f":"Checks!O9","v":""},{"$f":"IF(OR($B$2=\"\",ISBLANK(E24),ISBLANK(L24)),\"\",MAX(G24,N24)-MIN(G24,N24))","v":""},{"$f":"CHKDRF(P24,Checks!F9,Checks!G9,Checks!E9)","v":""}]
[]
[null,null,null,"FTU in air (turbidity blank) =",null,0,{"$f":"IF(OR($B$2=\"\",ISBLANK(E26)),\"\",E26-F26)","v":""},{"$f":"Checks!N10","v":""},null,null,"FTU in air (turbidity blank) =",null,0,{"$f":"IF(OR($B$2=\"\",ISBLANK(L26)),\"\",L26-M26)","v":""},{"$f":"Checks!O10","v":""},{"$f":"IF(OR($B$2=\"\",ISBLANK(E26),ISBLANK(L26)),\"\",MAX(G26,N26)-MIN(G26,N26))","v":""},{"$f":"CHKDRF(P26,Checks!F10,Checks!G10,Checks!E10)","v":""}]

{"sheet":"Instr2","index":2,"n_rows":26,"n_cols":21,"rows_kept":26,"cut":false,"hidden":false,"merged":[[13,5,13,6],[16,19,17,19],[16,7,17,7],[16,10,17,10],[16,8,17,8],[16,9,17,9],[16,15,17,15],[16,17,17,17],[16,18,17,18],[16,16,17,16],[16,11,17,11],[16,12,17,12],[1,1,1,2],[1,4,1,6],[4,6,5,6],[4,8,5,8],[4,7,5,7],[4,1,5,1],[4,2,5,2],[4,5,5,5],[4,3,5,3],[4,4,5,4],[6,19,11,19],[4,19,5,19],[4,15,5,15],[4,16,5,16],[9,15,11,15],[6,18,11,18],[9,16,11,16],[4,18,5,18],[4,9,5,9],[12,7,13,7],[12,12,13,12],[12,11,13,11],[4,10,5,10],[4,11,5,11],[4,12,5,12],[12,8,13,8],[12,9,13,9],[12,10,13,10],[4,13,5,13],[20,15,21,15],[20,16,21,16],[12,16,13,16],[12,14,13,14],[12,15,13,15],[18,16,19,16],[18,15,19,15],[14,15,15,15],[12,13,13,13],[14,16,15,16],[16,13,17,13],[16,14,17,14],[22,18,25,18],[12,17,13,17],[12,19,13,19],[12,18,13,18],[14,18,15,18],[14,19,15,19],[22,19,25,19],[20,17,21,17],[20,18,21,18],[20,19,21,19],[18,18,19,18],[18,19,19,19]]}
[null,"Instrument 2 ID",null,null,"Completed by",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Batch number"]
[null,{"$f":"IF(ISBLANK(SurveyLog!P6),\"\",SurveyLog!P6)","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK(E2),0,IF(ISNA(VLOOKUP(E2,Info!$F$2:$G$53,2,FALSE)),\"ZXY\",VLOOKUP(E2,Info!$F$2:$G$53,2,FALSE)))","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($U$2=0,\"NOT AVAILABLE\",BATCH($U$2,$U$2))","v":"NOT AVAILABLE"},{"$f":"DMIN(U6:U22,1,U$4:U$5)","v":"00:00:00"}]
[null,{"$f":"IF(ISBLANK(SurveyLog!P6),\"Please enter instrument ID on 'SurveyLog' sheet.\",VLOOKUP($B$2,instr_table,2,FALSE)&\" (\"&VLOOKUP($B$2,instr_table,4,FALSE)&\") manufacturer's serial number: \"&VLOOKUP($B$2,instr_table,3,FALSE))","v":"Please enter instrument ID on 'SurveyLog' sheet."}]
[null,"Pre-survey checks / calibration",null,null,null,null,null,null,"During / post-survey checks",null,null,null,null,null,null,"Alerts",null,null,null,null,"DateTime"]
[null,"Date","Time UTC","Temp (°C)","Instr reading","Value","Error",null,"Date","Time UTC","Temp (°C)","Instr reading","Value","Error",null,"Range\n(drift)","Message",null,"Include in AQC file?","Remarks\n(reason for breach or to exclude results)",">0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DateTime"]
["DO 0% ",null,null,null,null,0,{"$f":"IF(OR($B$2=\"\",ISBLANK(E7)),\"\",E7-F7)","v":""},{"$f":"Checks!N11","v":""},null,null,null,null,0,{"$f":"IF(OR($B$2=\"\",ISBLANK(L7)),\"\",L7-M7)","v":""},{"$f":"Checks!O11","v":""},{"$f":"IF(OR($B$2=\"\",ISBLANK(E7),ISBLANK(L7)),\"\",MAX(G7,N7)-MIN(G7,N7))","v":""},{"$f":"CHKDRF(P7,Checks!F11,Checks!G11,Checks!E11)","v":""},null,"Y",null,{"$f":"IF(OR(ISBLANK(B7),ISBLANK(C7)),0,B7+C7)","v":"00:00:00"}]
[]
[null,null,null,"DO membrane / optical cap ID =",null,{"$f":"IF(OR(VLOOKUP($B$2,instr_table,6,FALSE)=\"#N/A\",VLOOKUP($B$2,instr_table,6,FALSE)=0),IF(E9=\"Optical DO\",\"Enter cap # on 'Info'\",\"\"),VLOOKUP($B$2,instr_table,6,FALSE))","v":{"$error":"#N/A"}}]
["DO 100% ",null,null,null,null,100,{"$f":"IF(OR($B$2=\"\",ISBLANK(E10)),\"\",E10-F10)","v":""},{"$f":"CHKRES(E10,Checks!$F$12,Checks!$C$12,CTDAQC_!$I$12,Checks!$B$12,Checks!$D$12,Checks!$G$12,Checks!$E$12)","v":{"$error":"#VALUE!"}},null,null,null,null,100,{"$f":"IF(OR($B$2=\"\",ISBLANK(L10)),\"\",L10-M10)","v":""},{"$f":"CHKRES(L10,Checks!$F$12,Checks!$C$12,CTDAQC_!$I$12,Checks!$B$12,Checks!$D$12,Checks!$G$12,Checks!$E$12)","v":{"$error":"#VALUE!"}},{"$f":"IF(OR($B$2=\"\",ISBLANK(E10),COUNT(L10:L12)=0),\"\",MAX(G10,N10:N12)-MIN(G10,N10:N12))","v":""},{"$f":"CHKDRF(P10,Checks!F12,Checks!G12,Checks!E12)","v":""},null,null,null,{"$f":"IF(OR(ISBLANK(B10),ISBLANK(C10)),0,B10+C10)","v":"00:00:00"}]
[null,null,null,{"$f":"IF($E$9=\"Optical DO\",\"Signal intensity (if cal'd) =\",\"DO calibration slope (if cal'd) =\")","v":"DO calibration slope (if cal'd) ="},null,{"$f":"IF($E$9=\"Optical DO\",CTDAQC_!I13,Checks!$B$13)","v":{"$error":"#N/A"}},{"$f":"IF(OR($B$2=\"\",ISBLANK(E11)),\"\",E11-F11)","v":""},{"$f":"Checks!N13","v":""},null,null,null,null,100,{"$f":"IF(OR($B$2=\"\",ISBLANK(L11)),\"\",L11-M11)","v":""},{"$f":"CHKRES(L11,Checks!$F$12,Checks!$C$12,CTDAQC_!$I$12,Checks!$B$12,Checks!$D$12,Checks!$G$12,Checks!$E$12)","v":{"$error":"#VALUE!"}}]
[null,null,null,{"$f":"IF($E$9=\"Optical DO\",\"Ambient light intensity (if cal'd) =\",\"DO calibration current (if cal'd) =\")","v":"DO calibration current (if cal'd) ="},null,{"$f":"IF(E9=\"Optical DO\",CTDAQC_!I14,\"\")","v":""},{"$f":"IF(OR($B$2=\"\",ISBLANK(E12),F12=\"\"),\"\",E12-F12)","v":""},{"$f":"Checks!N14","v":""},null,null,null,null,100,{"$f":"IF(OR($B$2=\"\",ISBLANK(L12)),\"\",L12-M12)","v":""},{"$f":"CHKRES(L12,Checks!$F$12,Checks!$C$12,CTDAQC_!$I$12,Checks!$B$12,Checks!$D$12,Checks!$G$12,Checks!$E$12)","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,"Salinity standard batch ID ="]
["Salinity ",null,null,null,null,{"$f":"IF(ISNUMBER(VLOOKUP($F$14,sal_std_vals,2,FALSE)),ROUND(VLOOKUP($F$14,sal_std_vals,2,FALSE),3),IF(AND(ISNUMBER(F16),ISTEXT(F14)),F16,#N/A))","v":{"$error":"#N/A"}},{"$f":"IF(OR($B$2=\"\",ISBLANK(E15),ISBLANK($F$14)),\"\",E15-F15)","v":""},{"$f":"Checks!N15","v":""},null,null,null,null,{"$f":"IF(ISBLANK($F$14),#N/A,ROUND(VLOOKUP($F$14,sal_std_vals,2,FALSE),3))","v":{"$error":"#N/A"}},{"$f":"IF(OR($B$2=\"\",ISBLANK(L15),ISBLANK($F$14)),\"\",L15-M15)","v":""},{"$f":"Checks!O15","v":""},{"$f":"IF(OR($B$2=\"\",ISBLANK(E15),COUNT(L15:L16)=0,ISBLANK($F$14)),\"\",MAX(G15,N15:N16)-MIN(G15,N15:N16))","v":""},{"$f":"CHKDRF(P15,Checks!F15,Checks!G15,Checks!E15)","v":""},null,"Y",null,{"$f":"IF(OR(ISBLANK(B15),ISBLANK(C15)),0,B15+C15)","v":"00:00:00"}]
[null,null,null,null,{"$f":"IF(AND(OR(ISNUMBER(VLOOKUP($F$14,sal_std_vals,2,FALSE)),NOT(ISTEXT(F14))),ISBLANK(F16)),\"\",\"Salinity standard certified value = \")","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK($F$14),#N/A,ROUND(VLOOKUP($F$14,sal_std_vals,2,FALSE),3))","v":{"$error":"#N/A"}},{"$f":"IF(OR($B$2=\"\",ISBLANK(L16),ISBLANK($F$14)),\"\",L16-M16)","v":""},{"$f":"Checks!P15","v":""}]
[]
[null,null,null,null,"pH buffer ="]
[{"$f":"IF(ISBLANK(F18),\"pH _ ? \",F18)","v":"pH _ ? "},null,null,null,null,{"$f":"IF(OR(ISBLANK(D19),ISBLANK($F$18)),#N/A,ROUND(VLOOKUP($A$19,pH_table,2,FALSE)*(D19)^2-VLOOKUP($A$19,pH_table,3,FALSE)*(D19)+VLOOKUP($A$19,pH_table,4,FALSE),3))","v":{"$error":"#N/A"}},{"$f":"IF(OR($B$2=\"\",ISBLANK($F$18),ISBLANK(D19),ISBLANK(E19)),\"\",ROUND(E19-F19,3))","v":""},{"$f":"Checks!N16","v":""},null,null,null,null,{"$f":"IF(OR(ISBLANK(K19),ISBLANK($F$18)),#N/A,ROUND(VLOOKUP($A$19,pH_table,2,FALSE)*(K19)^2-VLOOKUP($A$19,pH_table,3,FALSE)*(K19)+VLOOKUP($A$19,pH_table,4,FALSE),3))","v":{"$error":"#N/A"}},{"$f":"IF(OR($B$2=\"\",ISBLANK($F$18),ISBLANK(K19),ISBLANK(L19)),\"\",ROUND(L19-M19,3))","v":""},{"$f":"Checks!O16","v":""},{"$f":"IF(OR($B$2=\"\",ISBLANK(D19),ISBLANK(E19),COUNT(K19:K20)=0,COUNT(L19:L20)=0),\"\",MAX(G19,N19:N20)-MIN(G19,N19:N20))","v":""},{"$f":"CHKDRF(P19,Checks!F16,Checks!G16,Checks!E16)","v":""},null,"Y",null,{"$f":"IF(OR(ISBLANK(B19),ISBLANK(C19)),0,B19+C19)","v":"00:00:00"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISBLANK(K20),ISBLANK($F$18)),#N/A,ROUND(VLOOKUP($A$19,pH_table,2,FALSE)*(K20)^2-VLOOKUP($A$19,pH_table,3,FALSE)*(K20)+VLOOKUP($A$19,pH_table,4,FALSE),3))","v":{"$error":"#N/A"}},{"$f":"IF(OR($B$2=\"\",ISBLANK($F$18),ISBLANK(K20),ISBLANK(L20)),\"\",ROUND(L20-M20,3))","v":""},{"$f":"Checks!P16","v":""}]
[null,null,null,"Turgetto ID =",{"$f":"VLOOKUP($B$2,instr_table,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP(CTDAQC_!B17,CTD_stats,8,FALSE)<(B22-183),\" WARNING! Turgetto stats are > 6 month old: please use Ctrl + T to update stats.\",\"\")","v":""}]
["Turbidity ",null,null,null,null,{"$f":"IF(ISERR($E$21),#N/A,VLOOKUP(CTDAQC_!B17,CTD_stats,9))","v":{"$error":"#N/A"}}," = FTU",null,null,null,null,null,{"$f":"F22","v":{"$error":"#N/A"}}," = FTU",null,null,null,null,null,null,{"$f":"IF(OR(ISBLANK(B22),ISBLANK(C22)),0,B22+C22)","v":"00:00:00"}]
[null,null,null,"Optical scale 0 (raw counts) =",null,{"$f":"IF(ISERR($E$21),#N/A,VLOOKUP(CTDAQC_!B17,CTD_stats,4))","v":{"$error":"#N/A"}},{"$f":"IF(OR($B$2=\"\",ISBLANK(E23)),\"\",E23-F23)","v":""},{"$f":"Checks!N17","v":""},null,null,"Optical scale 0 (raw counts) =",null,{"$f":"F23","v":{"$error":"#N/A"}},{"$f":"IF(OR($B$2=\"\",ISBLANK(L23)),\"\",L23-M23)","v":""},{"$f":"Checks!O17","v":""},{"$f":"IF(OR($B$2=\"\",ISBLANK(E23),ISBLANK(L23)),\"\",MAX(G23,N23)-MIN(G23,N23))","v":""},{"$f":"CHKDRF(P23,Checks!F17,Checks!G17,Checks!E17)","v":""},null,"Y"]
[null,null,null,"Optical scale 1 (raw counts) =",null,{"$f":"IF(ISERR($E$21),#N/A,VLOOKUP(CTDAQC_!B18,CTD_stats,4))","v":{"$error":"#N/A"}},{"$f":"IF(OR($B$2=\"\",ISBLANK(E24)),\"\",E24-F24)","v":""},{"$f":"Checks!N18","v":""},null,null,"Optical scale 1 (raw counts) =",null,{"$f":"F24","v":{"$error":"#N/A"}},{"$f":"IF(OR($B$2=\"\",ISBLANK(L24)),\"\",L24-M24)","v":""},{"$f":"Checks!O18","v":""},{"$f":"IF(OR($B$2=\"\",ISBLANK(E24),ISBLANK(L24)),\"\",MAX(G24,N24)-MIN(G24,N24))","v":""},{"$f":"CHKDRF(P24,Checks!F18,Checks!G18,Checks!E18)","v":""}]
[]
[null,null,null,"FTU in air (turbidity blank) =",null,0,{"$f":"IF(OR($B$2=\"\",ISBLANK(E26)),\"\",E26-F26)","v":""},{"$f":"Checks!N19","v":""},null,null,"FTU in air (turbidity blank) =",null,0,{"$f":"IF(OR($B$2=\"\",ISBLANK(L26)),\"\",L26-M26)","v":""},{"$f":"Checks!O19","v":""},{"$f":"IF(OR($B$2=\"\",ISBLANK(E26),ISBLANK(L26)),\"\",MAX(G26,N26)-MIN(G26,N26))","v":""},{"$f":"CHKDRF(P26,Checks!F19,Checks!G19,Checks!E19)","v":""}]

{"sheet":"Instr3","index":3,"n_rows":20,"n_cols":21,"rows_kept":20,"cut":false,"hidden":false,"merged":[[4,19,5,19],[6,18,11,18],[4,18,5,18],[16,13,17,13],[16,14,17,14],[6,19,11,19],[9,16,11,16],[14,19,15,19],[12,16,13,16],[14,18,15,18],[16,8,17,8],[16,9,17,9],[16,10,17,10],[16,11,17,11],[16,12,17,12],[18,15,19,15],[9,15,11,15],[4,10,5,10],[4,16,5,16],[4,9,5,9],[4,11,5,11],[4,12,5,12],[4,15,5,15],[4,13,5,13],[12,12,13,12],[12,10,13,10],[13,5,13,6],[12,8,13,8],[12,9,13,9],[12,11,13,11],[12,7,13,7],[18,19,19,19],[12,17,13,17],[12,13,13,13],[12,14,13,14],[18,18,19,18],[18,16,19,16],[14,16,15,16],[12,15,13,15],[16,18,17,18],[16,17,17,17],[12,19,13,19],[12,18,13,18],[16,19,17,19],[14,15,15,15],[16,15,17,15],[16,16,17,16],[1,1,1,2],[1,4,1,6],[4,6,5,6],[4,8,5,8],[4,7,5,7],[4,1,5,1],[4,2,5,2],[4,3,5,3],[4,4,5,4],[4,5,5,5]]}
[null,"Instrument 3 ID",null,null,"Completed by",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Batch number"]
[null,{"$f":"IF(ISBLANK(SurveyLog!P7),\"\",SurveyLog!P7)","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK(E2),0,IF(ISNA(VLOOKUP(E2,Info!$F$2:$G$53,2,FALSE)),\"ZXY\",VLOOKUP(E2,Info!$F$2:$G$53,2,FALSE)))","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($U$2=0,\"NOT AVAILABLE\",BATCH($U$2,$U$2))","v":"NOT AVAILABLE"},{"$f":"DMIN(U6:U20,1,U$4:U$5)","v":"00:00:00"}]
[null,{"$f":"IF(ISBLANK(SurveyLog!P7),\"Please enter instrument ID on 'SurveyLog' sheet.\",VLOOKUP($B$2,instr_table,2,FALSE)&\" (\"&VLOOKUP($B$2,instr_table,4,FALSE)&\") manufacturer's serial number: \"&VLOOKUP($B$2,instr_table,3,FALSE))","v":"Please enter instrument ID on 'SurveyLog' sheet."}]
[null,"Pre-survey checks / calibration",null,null,null,null,null,null,"During / post-survey checks",null,null,null,null,null,null,"Alerts",null,null,null,null,"DateTime"]
[null,"Date","Time UTC","Temp (°C)","Instr reading","Value","Error",null,"Date","Time UTC","Temp (°C)","Instr reading","Value","Error",null,"Range\n(drift)","Message",null,"Include in AQC file?","Remarks\n(reason for breach or to exclude results)",">0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DateTime"]
["DO 0% ",null,null,null,null,0,{"$f":"IF(OR($B$2=\"\",ISBLANK(E7)),\"\",E7-F7)","v":""},{"$f":"Checks!N20","v":""},null,null,null,null,0,{"$f":"IF(OR($B$2=\"\",ISBLANK(L7)),\"\",L7-M7)","v":""},{"$f":"Checks!O20","v":""},{"$f":"IF(OR($B$2=\"\",ISBLANK(E7),ISBLANK(L7)),\"\",MAX(G7,N7)-MIN(G7,N7))","v":""},{"$f":"CHKDRF(P7,Checks!F20,Checks!G20,Checks!E20)","v":""},null,"Y",null,{"$f":"IF(OR(ISBLANK(B7),ISBLANK(C7)),0,B7+C7)","v":"00:00:00"}]
[]
[null,null,null,"DO membrane / optical cap ID =",null,{"$f":"IF(OR(VLOOKUP($B$2,instr_table,6,FALSE)=\"#N/A\",VLOOKUP($B$2,instr_table,6,FALSE)=0),IF(E9=\"Optical DO\",\"Enter cap # on 'Info'\",\"\"),VLOOKUP($B$2,instr_table,6,FALSE))","v":{"$error":"#N/A"}}]
["DO 100% ",null,null,null,null,100,{"$f":"IF(OR($B$2=\"\",ISBLANK(E10)),\"\",E10-F10)","v":""},{"$f":"CHKRES(E10,Checks!$F$21,Checks!$C$21,CTDAQC_!$I$21,Checks!$B$21,Checks!$D$21,Checks!$G$21,Checks!$E$21)","v":{"$error":"#VALUE!"}},null,null,null,null,100,{"$f":"IF(OR($B$2=\"\",ISBLANK(L10)),\"\",L10-M10)","v":""},{"$f":"CHKRES(L10,Checks!$F$21,Checks!$C$21,CTDAQC_!$I$21,Checks!$B$21,Checks!$D$21,Checks!$G$21,Checks!$E$21)","v":{"$error":"#VALUE!"}},{"$f":"IF(OR($B$2=\"\",ISBLANK(E10),COUNT(L10:L12)=0),\"\",MAX(G10,N10:N12)-MIN(G10,N10:N12))","v":""},{"$f":"CHKDRF(P10,Checks!F21,Checks!G21,Checks!E21)","v":""},null,null,null,{"$f":"IF(OR(ISBLANK(B10),ISBLANK(C10)),0,B10+C10)","v":"00:00:00"}]
[null,null,null,{"$f":"IF($E$9=\"Optical DO\",\"Signal intensity (if cal'd) =\",\"DO calibration slope (if cal'd) =\")","v":"DO calibration slope (if cal'd) ="},null,{"$f":"IF($E$9=\"Optical DO\",CTDAQC_!I22,Checks!$B$22)","v":{"$error":"#N/A"}},{"$f":"IF(OR($B$2=\"\",ISBLANK(E11)),\"\",E11-F11)","v":""},{"$f":"Checks!N22","v":""},null,null,null,null,100,{"$f":"IF(OR($B$2=\"\",ISBLANK(L11)),\"\",L11-M11)","v":""},{"$f":"CHKRES(L11,Checks!$F$21,Checks!$C$21,CTDAQC_!$I$21,Checks!$B$21,Checks!$D$21,Checks!$G$21,Checks!$E$21)","v":{"$error":"#VALUE!"}}]
[null,null,null,{"$f":"IF($E$9=\"Optical DO\",\"Ambient light intensity (if cal'd) =\",\"DO calibration current (if cal'd) =\")","v":"DO calibration current (if cal'd) ="},null,{"$f":"IF(E9=\"Optical DO\",CTDAQC_!I23,\"\")","v":""},{"$f":"IF(OR($B$2=\"\",ISBLANK(E12),F12=\"\"),\"\",E12-F12)","v":""},{"$f":"Checks!N23","v":""},null,null,null,null,100,{"$f":"IF(OR($B$2=\"\",ISBLANK(L12)),\"\",L12-M12)","v":""},{"$f":"CHKRES(L12,Checks!$F$21,Checks!$C$21,CTDAQC_!$I$21,Checks!$B$21,Checks!$D$21,Checks!$G$21,Checks!$E$21)","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,"Salinity standard batch ID ="]
["Salinity ",null,null,null,null,{"$f":"IF(ISNUMBER(VLOOKUP($F$14,sal_std_vals,2,FALSE)),ROUND(VLOOKUP($F$14,sal_std_vals,2,FALSE),3),IF(AND(ISNUMBER(F16),ISTEXT(F14)),F16,#N/A))","v":{"$error":"#N/A"}},{"$f":"IF(OR($B$2=\"\",ISBLANK(E15),ISBLANK($F$14)),\"\",E15-F15)","v":""},{"$f":"Checks!N24","v":""},null,null,null,null,{"$f":"IF(ISBLANK($F$14),#N/A,ROUND(VLOOKUP($F$14,sal_std_vals,2,FALSE),3))","v":{"$error":"#N/A"}},{"$f":"IF(OR($B$2=\"\",ISBLANK(L15),ISBLANK($F$14)),\"\",L15-M15)","v":""},{"$f":"Checks!O24","v":""},{"$f":"IF(OR($B$2=\"\",ISBLANK(E15),COUNT(L15:L16)=0,ISBLANK($F$14)),\"\",MAX(G15,N15:N16)-MIN(G15,N15:N16))","v":""},{"$f":"CHKDRF(P15,Checks!F24,Checks!G24,Checks!E24)","v":""},null,"Y",null,{"$f":"IF(OR(ISBLANK(B15),ISBLANK(C15)),0,B15+C15)","v":"00:00:00"}]
[null,null,null,null,{"$f":"IF(AND(OR(ISNUMBER(VLOOKUP($F$14,sal_std_vals,2,FALSE)),NOT(ISTEXT(F14))),ISBLANK(F16)),\"\",\"Salinity standard certified value = \")","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK($F$14),#N/A,ROUND(VLOOKUP($F$14,sal_std_vals,2,FALSE),3))","v":{"$error":"#N/A"}},{"$f":"IF(OR($B$2=\"\",ISBLANK(L16),ISBLANK($F$14)),\"\",L16-M16)","v":""},{"$f":"Checks!P24","v":""}]
[]
[null,null,null,null,"pH buffer ="]
[{"$f":"IF(ISBLANK(F18),\"pH _ ? \",F18)","v":"pH _ ? "},null,null,null,null,{"$f":"IF(OR(ISBLANK(D19),ISBLANK($F$18)),#N/A,ROUND(VLOOKUP($A$19,pH_table,2,FALSE)*(D19)^2-VLOOKUP($A$19,pH_table,3,FALSE)*(D19)+VLOOKUP($A$19,pH_table,4,FALSE),3))","v":{"$error":"#N/A"}},{"$f":"IF(OR($B$2=\"\",ISBLANK($F$18),ISBLANK(D19),ISBLANK(E19)),\"\",ROUND(E19-F19,3))","v":""},{"$f":"Checks!N25","v":""},null,null,null,null,{"$f":"IF(OR(ISBLANK(K19),ISBLANK($F$18)),#N/A,ROUND(VLOOKUP($A$19,pH_table,2,FALSE)*(K19)^2-VLOOKUP($A$19,pH_table,3,FALSE)*(K19)+VLOOKUP($A$19,pH_table,4,FALSE),3))","v":{"$error":"#N/A"}},{"$f":"IF(OR($B$2=\"\",ISBLANK($F$18),ISBLANK(K19),ISBLANK(L19)),\"\",ROUND(L19-M19,3))","v":""},{"$f":"Checks!O25","v":""},{"$f":"IF(OR($B$2=\"\",ISBLANK(D19),ISBLANK(E19),COUNT(K19:K20)=0,COUNT(L19:L20)=0),\"\",MAX(G19,N19:N20)-MIN(G19,N19:N20))","v":""},{"$f":"CHKDRF(P19,Checks!F25,Checks!G25,Checks!E25)","v":""},null,"Y",null,{"$f":"IF(OR(ISBLANK(B19),ISBLANK(C19)),0,B19+C19)","v":"00:00:00"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISBLANK(K20),ISBLANK($F$18)),#N/A,ROUND(VLOOKUP($A$19,pH_table,2,FALSE)*(K20)^2-VLOOKUP($A$19,pH_table,3,FALSE)*(K20)+VLOOKUP($A$19,pH_table,4,FALSE),3))","v":{"$error":"#N/A"}},{"$f":"IF(OR($B$2=\"\",ISBLANK($F$18),ISBLANK(K20),ISBLANK(L20)),\"\",ROUND(L20-M20,3))","v":""},{"$f":"Checks!P25","v":""}]

{"sheet":"Breach","index":4,"n_rows":51,"n_cols":20,"rows_kept":51,"cut":false,"hidden":true,"merged":[[23,1,23,3],[49,7,49,10],[20,1,20,13],[26,1,26,13],[32,1,32,13],[41,1,41,13],[44,7,44,9],[1,1,1,13],[4,3,4,4],[17,1,17,13],[18,1,18,4],[18,6,18,10],[18,12,18,13]]}
[null,"CTD AQC Breach Form",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(B5)&\",\"&D5&\",\"&B7&\",\"&B24&\",\"&B36&\",\"&B39&\",\"&R3","v":",,,*,,*,U"}]
[]
[1,"Event Data",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(LEN(H50)=0,LEN(H51)=0)=TRUE,\"U\",\"A\")","v":"U"}]
[null,"Batch ID",null,"Probe ID & sensor",null,null,"Lab","Analyst"]
[]
[null,"AQC type",null,"Result 1","Outcome",null,"Result 2","Outcome",null,"Result 3","Outcome",null,"Result 4","Outcome"]
[null,null,null,null,null,null,null,"",null,null,"",null,null,"",null,null,null,{"$f":"D7&E7&G7&H7&J7&K7&M7&N7","v":""},null,{"$f":"EXACT(R7,S7)","v":true}]
[null,"*",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D8&E8&G8&H8&J8&K8&M8&N8","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"EXACT(R9,S9)","v":true}]
[null,"*",null,null,null,null,null,null,null,null,null,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":"EXACT(R11,S11)","v":true}]
[null,"*",null,null,null,null,null,null,null,null,null,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":"EXACT(R13,S13)","v":true}]
[]
[2,"Observations"]
[]
[2.1,"What can you observe"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"What can you see e.g. dehydrated ref sensor, hole in oxygen membrane, trapped air,unstable calibration, spurious data?"]
[]
[2.2000000000000002,"What are the specific symptoms"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Is there a specific set of circumstances where the problem occurs e.g.  Extreeme cold, bright sunlight, the first time the instrument is used, a particular orentation?"]
[]
[3,"What caused it (Root Cause)"]
[null,"*",null,null,null,null,null,null,null,null,null,null,null,null,null,"Ask your self why at least 5 times"]
[]
[4,"What did you do to fix it (Correction)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"What did you do to fix the immediate problem at the time, was it sucessful?"]
[]
[5,"Likelyhood of it happening again"]
[null,"*"]
[]
[6,"What is being done to prevent it happening again (Corrective action)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"If it is likely to happen again, what action has been taken to reduce the likelyhood of a re-occurance, e.g. for organisational issues has the procedure been updated or training reinforced, if it was a bad batch of reagents or other critical item have they been quaranteened or removed from use?"]
[]
[7,"Impact on QC data",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Include"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"if no root cause found data must be included",null,{"$f":"IF(B24=\"Non Identified\",\"Include\",\"Exclude\")","v":"Exclude"}]
[]
[8,"Impact on Customer Data"]
[null,"*"]
[]
[8.1,"Justification for accepting data"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"What is the justification for accepting or rejecting the customer data?"]
[]
[null,null,null,null,null,null,"Confirm that the affected data has been deleted"]
[null,null,null,null,null,null,"completed by"]
[null,null,null,null,null,null,"Date"]
[]
[]
[9,"Who approved the Actions"]
[null,null,null,null,null,null,"Approved by"]
[null,null,null,null,null,null,"Date"]

{"sheet":"Info","index":5,"n_rows":62,"n_cols":37,"rows_kept":62,"cut":false,"hidden":false,"merged":[[45,8,45,9],[60,8,60,9],[61,8,61,9],[35,8,35,9],[36,8,36,9],[37,8,37,9],[39,8,39,9],[44,8,44,9],[42,8,42,9],[43,8,43,9],[38,8,38,9],[40,8,40,9],[41,8,41,9],[56,8,56,9],[57,8,57,9],[58,8,58,9],[59,8,59,9],[46,8,46,9],[55,8,55,9],[47,8,47,9],[48,8,48,9],[49,8,49,9],[50,8,50,9],[51,8,51,9],[52,8,52,9],[53,8,53,9],[54,8,54,9]]}
[null,"Vessel","Code","Callsign",null,"Surveyor","Code",null,"Sal std batch ID","Certified value",null,"Survey title",null,null,null,null,null,null,"Instr. AQC ID","Instrument Name","Serial No.","Description","Turgetto","Membr. cap #",null,"Ordnance Survey NRGs ",null,null,null,null,null,null,null,"pH buffer","Polynomial constants"]
[null,"Humber Guardian","HG","2ENC3",null,"Charly Alexander","CA_",null,"CH2021-0810",34.793100000000003,null,"NW","EA","TH","CH","SO","SW",null,"IDR02232","Idronaut Ocean Seven 316","0202232","CG Minibat White Acetal","TG50","#N/A",null,"SV","SW","SX","SY","SZ","TV",null,null,"pH 4 ",2.4000000000000001E-5,1.1900000000000001E-4,3.9971429999999999]
[null,"Mersey Guardian","MG","2FGL4",null,"Ed Stevens","ES_",null,"CH2021-0811",33.757899999999999,null,"Caernarfon Bay North","N Northd Coast","Blackwater & Colne","Bridgwater Bay","Chichester Harbour","Camel",null,"IDR03298","Idronaut Ocean Seven 316","0203298","Standard White Acetal + Tb","TG37","#N/A",null,"SQ","SR","SS","ST","SU","TQ","TR",null,"pH 7 ",5.7000000000000003E-5,5.8570000000000002E-3,7.0935709999999998]
[null,"Severn Guardian","SG","2FGL5",null,"Gabrielle Garland","GG_",null,"CH2021-1009A",30.241700000000002,null,"Cefni","Tweed","Lower Medway","Caernarfon Bay North","Cornwall Coast","Dart",null,"IDR04345","Idronaut Ocean Seven 316","0204345","SPARE Minibat + Tb","TG45","#N/A",null,null,"SM","SN","SO","SP","TL","TM",null,"pH 8 ",3.8000000000000002E-5,6.1900000000000002E-3,8.1071430000000007]
[null,"Solent Guardian","SL","2GDK7",null,"Gareth King","GK_",null,"CH2021-1011",33.3005,null,"Conwy Bay & Est","Holy Island","North Kent","Caernarfon Bay South","Eurohabs Devon - Dorset","Exe",null,"IDR05373","Idronaut Ocean Seven 316","0205373","Standard White Acetal + Tb","TG41","#N/A",null,null,"SG","SH","SJ","SK","TF","TG",null,"pH 10 ",1.1900000000000001E-4,1.8166999999999999E-2,10.317857]
[null,"Thames Guardian","TG","2EYX7",null,"Graham Sloane","GCS",null,"CH2021-1018",31.052299999999999,null,"Cumbria Coast","Farne Islands","Outer Thames","Cardiff East","Eurohabs Needles - Poole","Fal",null,"IDR05376","Idronaut Ocean Seven 316","0205376","Minibat White Acetal + Tb","TG38","#N/A",null,null,"SB","SC","SD","SE","TA","TB",null,"Membrane",null,"I"]
[null,"Bittern","BN",null,null,"Harry Dundas","HD_",null,"HG2021-0708A",33.243600000000001,null,"Dee","Durham Coast","Pegwell Bay","Cardigan Bay Central","EuroHabs Needles - Portland","Fal Helford",null,"IDR06111","Idronaut Ocean Seven 305/89","0206111","89mm White Acetal + Tb","TG42","#N/A",null,null,"NW","NX","NY","NZ","OV","OW",null,"Optical DO"]
[null,"Celtic Wildcat","CW",null,null,"Jenna Ashford","JA_",null,"HG2021-0708B",33.846899999999998,null,"Dolgarrog","Blyth","South Kent","Cardigan Bay North","Eurohabs Poole - Portland","Falmouth Bay",null,"IDR06113","Idronaut Ocean Seven 305/89","0206113","89mm White Acetal + Tb","TG46","#N/A",null,"NQ","NR","NS","NT","NU","OQ",null,null,"Idr green",null,"40-70"]
[null,"Chichester Zodiac","CZ",null,null,"Megan Wilde","MW_",null,"HG2021-0811",34.042999999999999,null,"Ferodo","Tyne","Stour & Orwell","Carmarthen Bay","Eurohabs Poole - Torquay","Looe Bay",null,"IDR14303","Idronaut Ocean Seven 305/89","0914303","89mm White Acetal + Tb: IDR07125 refit","TG35","#N/A",null,"NL","NM","NN","NO","NP","OL",null,null,"Idr blue",null,"80-120"]
[null,"Endeavour","EN",null,null,"Mike Fraser","MJF",null,"HG2021-0904",33.942500000000003,null,"Foryd","Wear","Thames AWQMS","Cefni","Eurohabs Portland - Torquay","Lyme Bay",null,"IDR14311","Idronaut Ocean Seven 305/89","0914311","89mm White Acetal + Tb: IDR07124 refit","TG40","#N/A",null,"NF","NG","NH","NJ","NK","OF",null,null,"Idr green+red",null,"40-70"]
[null,"Jack Russel","JR",null,null,"Nick Meaton","NM_",null,"HG2021-1011",32.973799999999997,null,"Ganol","Tees","Thames Lower","Inner Bristol Channel North","Eurohabs South Devon","Mounts Bay",null,"IDR15319","Idronaut Ocean Seven 305/89","0215319","89mm White Acetal + Tb: IDR06100 refit","TG30","#N/A",null,"NA","NB","NC","ND","NE","OA",null,null,"Idr blue+red",null,"80-120"]
[null,"Kingfisher House","KH",null,null,"Nina Godsell","NG_",null,"MG2021-0708",32.508600000000001,null,"Gas Storage Caverns","Esk","Thames Middle","Inner Bristol Channel South","Eurohabs St Austell Bay","North Cornwall",null,"IDR16339","Idronaut Ocean Seven 305/89","0116339","89mm White Acetal + Tb: IDR13264 refit","TG51","#N/A",null,null,null,null,null,null,null,null,null,"Start/end of BST for log year"]
[null,"Linnet","LT",null,null,"Pascal Dubois","PD_",null,"MG2021-0901",34.446899999999999,null,"Holyhead","Yorks Coast","Thames Upper","Loughor","Eurohabs Torquay - Plymouth","Plym",null,"IDR17353","Idronaut Ocean Seven 305/89","0517353","89mm White Acetal + Tb: IDR08146 refit","TG31","#N/A",null,"Show/edit full info",null,null,null,null,null,null,null,{"$f":"(DATE(YEAR(SurveyLog!$B5),3,31)-MOD(WEEKDAY(DATE(YEAR(SurveyLog!$B5),3,31),2),7))+TIME(1,0,0)","v":"2022-03-27T01:00:00"}]
[null,"Micki Dee Bee","MD",null,null,"Richard Castelino","RJC",null,"SO2021-0711B",33.443899999999999,null,"Inshore Coast","Humber","Upper Medway","Maltraeth","Isle of Wight","South Cornwall",null,"IDR17354","Idronaut Ocean Seven 305/89","0517354","89mm White Acetal + Tb: IDR06112 refit","TG43","#N/A",null,"Hide full info",null,null,null,null,null,null,null,{"$f":"(DATE(YEAR(SurveyLog!$B5),10,31)-MOD(WEEKDAY(DATE(YEAR(SurveyLog!$B5),10,31),2),7))+TIME(1,0,0)","v":"2022-10-30T01:00:00"}]
[null,"Mor Teg","MT",null,null,"Richard Pritchard","RRP",null,"SO2021-0809A",33.941000000000003,null,"Kent","Lincs Coast","Whitstable Bay","Milford Outer","Langstone Harbour","South Devon Eurohabs",null,"IDR17355","Idronaut Ocean Seven 310","0517355","89mm White Acetal + Tb + Opt DO: IDR06103 refit","TG36","181600717",null,null,null,null,null,null,null,null,null,"Instr config.","Fix Descriptons","Sediment Descriptions","Survey Reasons"]
[null,"Nimrod","NR",null,null,"Samantha Camp","SJC",null,"SO2021-0809B",33.181600000000003,null,"Leven","Outer Wash",null,"Milford Upper & Jetties","Pagham Harbour","St Austell Bay",null,"IDR17356","Idronaut Ocean Seven 305/89","0517356","89mm White Acetal + Tb: IDR08144 refit","TG39","#N/A",null,null,null,null,null,null,null,null,null,"Data cable","SoL","Mixed","Surveillance"]
[null,"Oceanic","OC",null,null,"Tom Holland","TJH",null,"SO2021-0910B",33.869500000000002,null,"Lune","Inner Wash",null,"Neath","Poole Harbour","Taw Torridge",null,"IDR17357","Idronaut Ocean Seven 305/89","0517357","89mm White Acetal + Tb: IDR08145 refit","TG47","#N/A",null,null,null,null,null,null,null,null,null,"Memory","EoL","Sand","Operational"]
[null,"Pisces II","PI",null,null,"Tom Lord","TL_",null,"SO2021-1009A",33.9452,null,"Manchester Ship Canal","Great Ouse",null,"North Cornwall","Portsmouth Harbour","Torbay",null,"IDR19063","Idronaut Ocean Seven 305/89","0719063","89mm White Acetal + Tb + Opt DO","TG61",192001540,null,null,null,null,null,null,null,null,null,"Moonpool","Extra Photo","Mud","Investigation"]
[null,"Poole \"C\"","PC",null,null,null,null,null,"SO2021-1009B",34.140799999999999,null,"Mersey","Witham",null,"Outer Bristol Channel North","Solent East","Yealm",null,"IDR19064","Idronaut Ocean Seven 305/89","0719064","89mm White Acetal + Tb + Opt DO","TG52",192701976,null,null,null,null,null,null,null,null,null,"Flowcell","Extra Fix","Coarse"]
[null,"Proteus","PT",null,null,null,null,null,"SW2021-0715",34.899099999999997,null,"Mersey Mouth","Norfolk Coast",null,"Severn & Usk","Solent West",null,null,"IDR19065","Idronaut Ocean Seven 305/89","0719065","89mm White Acetal + Tb + Opt DO","TG63",192001540,null,null,null,null,null,null,null,null,null,"Subsample"]
[null,"Razorbill","RZ",null,null,null,null,null,"SW2021-0831",34.436,null,"Morecambe Bay Investigations",null,null,"Swansea Bay","South Kent",null,null,"IDR19110","Idronaut Ocean Seven 305/89","1019110","89mm White Acetal + Tb + Opt DO: IDR09165 refit","TG49",192001539,null,null,null,null,null,null,null,null,null,"Turgetto abs. err.","Grab Gear","Sediment Use"]
[null,"Rother IV","R4",null,null,null,null,null,"SW2021-1020A",33.094900000000003,null,"Morecambe Bay Zig Zag",null,null,"Teifi & Nyfer","Southampton Water",null,null,"IDR19111","Idronaut Ocean Seven 305/89","1019111","89mm White Acetal + Tb + Opt DO: IDR09166 refit","TG44",192001539,null,null,null,null,null,null,null,null,null,0.05,"DG","Biota",1]
[null,"Saila Vie","SE",null,null,null,null,null,"SW2021-1020B",34.506599999999999,null,"North Wales Coast",null,null,"Three rivers",null,null,null,"IDR19358","Idronaut Ocean Seven 305/89","0119358","89mm White Acetal + Tb: EA89Plus","TG32","#N/A",null,null,null,null,null,null,null,null,null,"Deg. freedom","MHM","PSA",1]
[null,"Sentry III","S3",null,null,null,null,null,"SW2021-1020C",34.057000000000002,null,"Ribble",null,null,null,null,null,null,"IDR21166","Idronaut Ocean Seven 310","0521166","89mm White Acetal + Tb: IDR13257 refit","TG48","#N/A",null,null,null,null,null,null,null,null,null,30,"Van Veen","Biota & PSA",1]
[null,"Shearwater","SH",null,null,null,null,null,"TG2021-0712",31.842600000000001,null,"Upper Mersey",null,null,null,null,null,null,"IDR99077","Idronaut Ocean Seven 316","0299077","Standard White Acetal",null,"#N/A",null,null,null,null,null,null,null,null,null,null,"Camera Gear","Sed Chem",1]
[null,"Solway Shepherd","SS",null,null,null,null,null,"TG2021-0808",32.769100000000002,null,"Wyre",null,null,null,null,null,null,"IDR99084","Idronaut Ocean Seven 316","0299084","Standard White Acetal",null,"#N/A",null,null,null,null,null,null,null,null,null,null,"DC","Discard",0]
[null,"Three Rivers","TR",null,null,null,null,null,"TG2021-0915",33.488500000000002,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CS","Empty",0]
[null,"Zawn","ZN",null,null,null,null,null,"TG2021-1011",33.8508,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Misfire",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Survey type"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MCZ","MZ"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SAC","HB"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WFD","WD"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Root causes"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"*"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Operator Error",null,"OE"]
[null,null,null,null,null,null,null,null,"Custom headers",null,null,"Port name",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Instrument Malfunction",null,"IM"]
[null,null,null,null,null,null,null,null,"Oil & grease (0/1)",null,null,"Caernarfon","Berwick-upon-Tweed","Allington Lock","Aberystwyth","Chichester","Appledore",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Damage to sensor",null,"DS"]
[null,null,null,null,null,null,null,null,"Secchi depth (m)",null,null,"Connah's Quay","Seahouses","Dover","Burry Port","Langstone","Exmouth",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non Identified",null,"NI"]
[null,null,null,null,null,null,null,null,"Cond µS/cm at 25°C",null,null,"Conwy","Amble","Grovehurst Jetty","Caernarfon","Pagham","Falmouth",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Organisational",null,"O"]
[null,null,null,null,null,null,null,null,"Weather (descrip.)",null,null,"Eastham","River Tyne","Harwich","Cardigan","Poole","Fowey",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Likelyhood","QC Impact","Cust Impact"]
[null,null,null,null,null,null,null,null,"PRN",null,null,"Fleetwood","River Tees","Ramsgate","Ferryside","Portland","Hayle",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"*","*","*"]
[null,null,null,null,null,null,null,null,"Barcode label",null,null,"Glasson","Whitby","Richmond","Llanelli","Portsmouth","Padstow",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Low","Include","Accept"]
[null,null,null,null,null,null,null,null,"Flourescence",null,null,"Holyhead","Bridlington","Sheerness","Milford Haven","Southampton","Penzance",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Medium","Exclude","Delete"]
[null,null,null,null,null,null,null,null,"Nitrate",null,null,"Liverpool","Grimsby","Walton on the Naze","Neath","Torquay","Plymouth",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"High"]
[null,null,null,null,null,null,null,null,"Distance to target (m)",null,null,"Morcambe","Immingham","West Mersea","Newport",null,"Salcombe"]
[null,null,null,null,null,null,null,null,null,null,null,"Moston","Hull",null,"Neyland",null,"Torquay"]
[null,null,null,null,null,null,null,null,"Survey activity",null,null,"Ulverston","Skegness",null,"Padstow"]
[null,null,null,null,null,null,null,null,"Water sampling",null,null,"Widnes","Tabs Head",null,"Porthcawl"]
[null,null,null,null,null,null,null,null,"Benthic (grab)",null,null,null,"West Stones",null,"Pwllheli"]
[null,null,null,null,null,null,null,null,"Fish trawling",null,null,null,"King's Lynn",null,"Steep Holm"]
[null,null,null,null,null,null,null,null,"MCZ benthic (grab)",null,null,null,"Wells-next-the-Sea",null,"Swansea"]
[null,null,null,null,null,null,null,null,"MCZ (camera)",null,null,null,"Blakeney",null,"Tenby"]
[null,null,null,null,null,null,null,null,"Hydrographic",null,null,null,"Lowestoft"]
[null,null,null,null,null,{"$f":"SurveyLog!G5","v":"Nick Meaton"},"ZXY",null,null,null,null,null,"Felixstowe"]
[null,null,null,null,null,"Region","Code"]
[null,null,null,null,null,"East Coast","EA"]
[null,null,null,null,null,"Thames & South East","TH"]
[null,null,null,null,null,"South Coast","SO"]
[null,null,null,null,null,"South West","SW"]
[null,null,null,null,null,"Cymru & Môr Hafren","CH"]
[null,null,null,null,null,"North West & N Wales","NW"]
[null,{"$f":"SurveyLog!E5","v":"Humber Guardian"},"ZX",null,null,{"$f":"SurveyLog!E7","v":"East Coast"},"??"]

{"sheet":"Headers","index":6,"n_rows":49,"n_cols":34,"rows_kept":49,"cut":false,"hidden":true,"merged":[[2,1,2,4],[3,1,3,4],[9,1,9,4],[11,1,11,4],[0,1,0,4],[1,1,1,4],[4,1,4,4],[5,1,5,4],[8,1,8,4],[6,1,6,4],[10,1,10,4]]}
[null,"[ Clear all column headers ]"]
[null,"Water sampling",null,null,null,null,1]
[null,"Fish trawling survey",null,null,null,null,2]
[null,"Grab survey",null,null,null,null,3]
[null,"Grab survey with biota",null,null,null,null,4]
[null,"EA WFD benthic (grab) survey",null,null,null,null,5]
[null,"MCZ benthic (grab) survey",null,null,null,null,6]
[null,"MCZ camera survey",null,null,null,null,7]
[null,null,null,null,null,null,8]
[null,null,null,null,null,null,9]
[null,null,null,null,null,null,10]
[]
[null,"Water sampling",null,null,"Fish trawling survey",null,null,"Grab survey",null,null,"Grab survey with biota",null,null,"EA WFD benthic (grab) survey",null,null,"MCZ benthic (grab) survey",null,null,"MCZ camera survey"]
[2,"Header","Equation",null,"Header","Equation",null,"Header","Equation",null,"Header","Equation",null,"Header","Equation",null,"Header","Equation",null,"Header","Equation",null,"Header","Equation",null,"Header","Equation",null,"DataVal","UserForm Options"]
[1,"Sample depth (m)",null,null,"Speed over ground (kts)",null,null,"Folk sediment class.",null,null,"Folk sediment class.",null,null,"Folk sediment class.",null,null,"Cefas STN number",null,null,"Cefas STN number",null,null,null,null,null,null,null,null,"CTD depth (m)",{"$f":"AC15","v":"CTD depth (m)"},null,"Time BST of nearest HW","Time h:mm relative to prev. HW","Public Register Comments"]
[2,"Chlorophyll vol filt (ml)",null,null,"Course over ground (°)",null,null,"Sediment use",null,null,"Sed depth in grab or tub (cm)",null,null,"Sed depth in grab or tub (cm)",null,null,"Replicate attempt",null,null,"Replicate attempt",null,null,null,null,null,null,null,null,"Temp °C",{"$f":"AC16","v":"Temp °C"},null,{"$f":"IF(HW_times=FALSE,#N/A,INDEX(HW_times,MATCH(MIN(ABS(HW_times-$C16)),ABS(HW_times-$C16),0),1))","v":false},{"$f":"IF(HW_times=FALSE,#N/A,$C16-INDEX(HW_times,MATCH(MAX(IF(HW_times-$C16<=0,HW_times,FALSE)),IF(HW_times-$C16<=0,HW_times,FALSE),0)))","v":{"$error":"#N/A"}}]
[3,"OSGB36 NGR",{"$f":"INDEX(NGR,ROUNDUP($I12/100000,0),ROUNDUP($H12/100000,0))&TEXT($H12-ROUNDDOWN($H12/100000,0)*100000,\"00000\")&TEXT($I12-ROUNDDOWN($I12/100000,0)*100000,\"00000\")","v":{"$error":"#VALUE!"}},null,"EQSD replicate no.",null,null,"Sample notes",null,null,"Sediment use",null,null,"Sediment use",null,null,"Sediment description",null,null,"Fix description",null,null,null,null,null,null,null,null,"Cond mS/cm",{"$f":"AC17","v":"Cond mS/cm"}]
[4,null,null,null,"Click barcode",null,null,"Redox layer depth (cm)",null,null,"Sample notes",null,null,"Sample notes",null,null,"Sed depth in grab or tub (cm)",null,null,"Video obser- vations",null,null,null,null,null,null,null,null,"Salinity",{"$f":"AC18","v":"Salinity"},null,"CTD depth (m)",1]
[5,null,null,null,"Fish species",null,null,"Grab image label",{"$f":"IF(OR(Sedimentuse=\"\",Sedimentuse=\"Discard\",Sedimentuse=\"Misfire\",Sedimentuse=\"Empty\"),#N/A,$E12&\"_\"&TEXT($D12,\"hhmm\"))","v":{"$error":"#NAME?"}},null,"Redox layer depth (cm)",null,null,"Redox layer depth (cm)",null,null,"Sediment use",null,null,"Station notes",null,null,null,null,null,null,null,null,"DO%",{"$f":"AC19","v":"DO%"},null,"Temp °C",1]
[6,null,null,null,"Fish length (mm)",null,null,"HYDROpro fix no.",null,null,"Sieve mesh size (mm)",null,null,"Sieve mesh size (mm)",null,null,"Sample notes",null,null,"Broad scale habitat obs.",null,null,null,null,null,null,null,null,"DOmg/l",{"$f":"AC21","v":"pH"},null,"Cond mS/cm",1]
[7,null,null,null,"Fish wet weight (g)",null,null,"Sampling gear type (DG/MHM)",null,null,"Sample container size (kg)",null,null,"Sample container size (kg)",null,null,"Redox layer depth (cm)",null,null,"FOV (e.g lasers) scale",null,null,null,null,null,null,null,null,"pH",{"$f":"AC22","v":"Turbidity FTU"},null,"Salinity",1]
[8,null,null,null,null,null,null,"Vessel offset in HYDROpro",null,null,"Sediment vol. in tub (litres)",{"$f":"IF(SamplinggeartypeDGMHM=\"MHM\",1.6*Seddepthingrabortubcm,\"-\")","v":{"$error":"#NAME?"}},null,"Sediment vol. in tub (litres)",{"$f":"IF(SamplinggeartypeDGMHM=\"MHM\",1.6*Seddepthingrabortubcm,\"-\")","v":{"$error":"#NAME?"}},null,"Sieve mesh size (mm)",null,null,"SOG (knots)",null,null,null,null,null,null,null,null,"Turbidity FTU",null,null,"DO%",1]
[9,null,null,null,null,null,null,"Depth to Chart Datum (m)",null,null,"Grab image label",{"$f":"IF(OR(Sedimentuse=\"\",Sedimentuse=\"Discard\",Sedimentuse=\"Misfire\",Sedimentuse=\"Empty\"),#N/A,$E12&\"_\"&TEXT($D12,\"hhmm\")&\"_grab\")","v":{"$error":"#NAME?"}},null,"Reason for Survey",null,null,"Fauna container vol. (litres) ",null,null,"COG\n(CS Only)",null,null,null,null,null,null,null,null,null,null,null,"DOmg/l",{"$f":"AG22","v":1}]
[10,null,null,null,null,null,null,"Latitude (decimal degrees)",{"$f":"_xlfn.NUMBERVALUE(LEFT($F12,2))+_xlfn.NUMBERVALUE(MID($F12,4,7))/60","v":0},null,"Sieve image label",{"$f":"IF(AND(ISNUMBER(SEARCH(\"Biota\",Sedimentuse)),ISNUMBER(Sievemeshsizemm)),$E12&\"_\"&TEXT($D12,\"hhmm\")&\"_sieve_\"&Sievemeshsizemm&\"mm\",#N/A)","v":{"$error":"#N/A"}},null,"Replicate code",{"$f":"IF(Numericsitecode=\"-\",#N/A,LEFT($E12,5)&LEFT(Reasonforsurvey,1)&TEXT(Numericsitecode,\"000\")&IF(Sedimentuse=\"Biota\",\"B\",IF(Sedimentuse=\"PSA\",\"E\",\"\")))","v":{"$error":"#NAME?"}},null,"PSA sample vol. (ml)",null,null,"Cable out (CS Only)",null,null,null,null,null,null,null,null,null,null,null,"pH",1]
[11,null,null,null,null,null,null,"Longitude (decimal degrees)",{"$f":"_xlfn.NUMBERVALUE(IF(RIGHT($G12,1)=\"W\",\"-\",\"\")&_xlfn.NUMBERVALUE(LEFT($G12,1))+_xlfn.NUMBERVALUE(MID($G12,3,7))/60)","v":0},null,"HYDROpro fix no.",null,null,"Survey code",{"$f":"IF(Numericsitecode=\"-\",#N/A,LEFT($E12,3)&\"WD\"&IF(MONTH($B$5)<10,\"0\")&MONTH($B$5)&RIGHT(YEAR($B$5),2)&IF(ISNA(MATCH(\"Biota\",Sedimentuse,0)),\"E\",\"B\"))","v":{"$error":"#NAME?"}},null,"Sediment vol. in tub (litres)",{"$f":"IF(SamplinggeartypeDGMHM=\"MHM\",1.6*Seddepthingrabortubcm,\"-\")","v":{"$error":"#NAME?"}},null,"No. of stills taken",{"$f":"IF(OR(ISNA(Videofilenameharddrive),CefasSTNnumber=\"\",AND(WhichLast(\"SoL\",\"EoL\",Fixdescription,12,ROW())=\"EoL\",NOT(Fixdescription=\"EoL\")))=TRUE,#N/A,IF(Fixdescription=\"SoL\",1,IF(Fixdescription=\"Extra Fix\",INDIRECT(ADDRESS(ROW()-1,COLUMN())),IF(Fixdescription=\"Extra Photo\",INDIRECT(ADDRESS(ROW()-1,COLUMN()))+2,INDIRECT(ADDRESS(ROW()-1,COLUMN()))+1))))","v":{"$error":"#NAME?"}},null,null,null,null,null,null,null,null,null,null,"Turbidity FTU",1]
[12,null,null,null,null,null,null,"PRN",null,null,"Sampling gear type (DG/MHM)",null,null,"Grab image label",{"$f":"IF(OR(RIGHT(Replicatecode,1)=\"B\",RIGHT(Replicatecode,1)=\"E\")=FALSE,#N/A,Replicatecode&\"_Grab\")","v":{"$error":"#NAME?"}},null,"Grab image label",{"$f":"IF(OR(Sedimentuse=\"\",Sedimentuse=\"Discard\",Sedimentuse=\"Misfire\",Sedimentuse=\"Empty\"),#N/A,UPPER(LEFT($E12,4))&\"_\"&VLOOKUP($E$5,Info!$B$2:$D$62,3,FALSE)&IF(MONTH($B$5<10),\"0\",\"\")&MONTH($B$5)&RIGHT(YEAR($B$5),2)&\"_GT\"&TEXT(extract_number($E12),\"000\")&\"_STN_\"&CefasSTNnumber&\"_REP_\"&Replicateattempt&\"_Grab\")","v":{"$error":"#NAME?"}},null,"Still label",{"$f":"IF(OR(Fixdescription=\"Extra Fix\",ISNA(No.ofstillstaken))=TRUE,#N/A,lastitemlookup(\"SoL\",Fixdescription,12,ROW(),Videofilenameharddrive)&\"_\"&No.ofstillstaken)","v":{"$error":"#NAME?"}},null,null,null,null,null,null,null,null,null,null,"IDR cast number"]
[13,null,null,null,null,null,null,null,null,null,"Vessel offset in HYDROpro",null,null,"Sieve image label",{"$f":"IF(ISNUMBER(Sievemeshsizemm)=FALSE,#N/A,Replicatecode&\"_\"&Sievemeshsizemm&\"mm\")","v":{"$error":"#N/A"}},null,"Sieve image label",{"$f":"IF(AND(ISNUMBER(SEARCH(\"Biota\",Sedimentuse)),ISNUMBER(Sievemeshsizemm)),UPPER(LEFT($E12,4))&\"_\"&VLOOKUP($E$5,Info!$B$2:$D$62,3,FALSE)&IF(MONTH($B$5<10),\"0\",\"\")&MONTH($B$5)&RIGHT(YEAR($B$5),2)&\"_GT\"&TEXT(extract_number($E12),\"000\")&\"_STN_\"&CefasSTNnumber&\"_REP_\"&Replicateattempt&\"_\"&Sievemeshsizemm&\"mm\",#N/A)","v":{"$error":"#N/A"}},null,"Video file name (hard drive)",{"$f":"IF(Fixdescription=\"SOL\",IF(OR(CefasSTNnumber=\"\",Replicateattempt=\"\")=TRUE,#N/A,UPPER(LEFT($E12,4))&\"_\"&VLOOKUP($E$5,Info!$B$2:$D$62,3,FALSE)&IF(MONTH($B$5<10),\"0\",\"\")&MONTH($B$5)&RIGHT(YEAR($B$5),2)&\"_GT\"&TEXT(extract_number($E12),\"000\")&\"_STN_\"&CefasSTNnumber&\"_\"&Replicateattempt),\"-\")","v":{"$error":"#NAME?"}}]
[14,null,null,null,null,null,null,null,null,null,"Depth to Chart Datum (m)",null,null,"HYDROpro fix no.",null,null,"HYDROpro fix no.",null,null,"HYDROpro fix no."]
[15,null,null,null,null,null,null,null,null,null,"Latitude (decimal degrees)",{"$f":"_xlfn.NUMBERVALUE(LEFT($F12,2))+_xlfn.NUMBERVALUE(MID($F12,4,7))/60","v":0},null,"Sampling gear type (DG/MHM)",null,null,"Sampling gear type (DG/MHM)",null,null,"Survey gear type (DC/CS)"]
[16,null,null,null,null,null,null,null,null,null,"Longitude (decimal degrees)",{"$f":"_xlfn.NUMBERVALUE(IF(RIGHT($G12,1)=\"W\",\"-\",\"\")&_xlfn.NUMBERVALUE(LEFT($G12,1))+_xlfn.NUMBERVALUE(MID($G12,3,7))/60)","v":0},null,"Vessel offset in HYDROpro",null,null,"Vessel offset in HYDROpro",null,null,"Vessel offset in HYDROpro"]
[17,null,null,null,null,null,null,null,null,null,"PRN",null,null,"Depth to Chart Datum (m)",null,null,"Depth to Chart Datum (m)",null,null,"Depth to Chart Datum (m)"]
[18,null,null,null,null,null,null,null,null,null,null,null,null,"OSGB36 NGR",{"$f":"INDEX(NGR,ROUNDUP($I12/100000,0),ROUNDUP($H12/100000,0))&TEXT($H12-ROUNDDOWN($H12/100000,0)*100000,\"00000\")&TEXT($I12-ROUNDDOWN($I12/100000,0)*100000,\"00000\")","v":{"$error":"#VALUE!"}},null,"OSGB36 NGR",{"$f":"INDEX(NGR,ROUNDUP($I12/100000,0),ROUNDUP($H12/100000,0))&TEXT($H12-ROUNDDOWN($H12/100000,0)*100000,\"00000\")&TEXT($I12-ROUNDDOWN($I12/100000,0)*100000,\"00000\")","v":{"$error":"#VALUE!"}},null,"Latitude (decimal degrees)",{"$f":"_xlfn.NUMBERVALUE(LEFT($F12,2))+_xlfn.NUMBERVALUE(MID($F12,4,7))/60","v":0}]
[19,null,null,null,null,null,null,null,null,null,null,null,null,"Indicative site code",{"$f":"IF($E12=\"\",\"-\",LEFT(SUBSTITUTE($E12,\"_\",\"\"),6))","v":"-"},null,"Numeric site code",{"$f":"extract_number($E12)","v":{"$error":"#VALUE!"}},null,"Longitude (decimal degrees)",{"$f":"_xlfn.NUMBERVALUE(IF(RIGHT($G12,1)=\"W\",\"-\",\"\")&_xlfn.NUMBERVALUE(LEFT($G12,1))+_xlfn.NUMBERVALUE(MID($G12,3,7))/60)","v":0}]
[20,null,null,null,null,null,null,null,null,null,null,null,null,"Numeric site code",{"$f":"IF(ISNA(WFDsamplerowoffset),\"-\",IF(WFDsamplerowoffset=0,last_sample_number(12,ROW(),Indicativesitecode,Numericsitecode)+1,INDIRECT(ADDRESS(ROW()+WFDsamplerowoffset,COLUMN()))))","v":{"$error":"#NAME?"}},null,"Latitude (decimal degrees)",{"$f":"_xlfn.NUMBERVALUE(LEFT($F12,2))+_xlfn.NUMBERVALUE(MID($F12,4,7))/60","v":0}]
[21,null,null,null,null,null,null,null,null,null,null,null,null,"Biota sample (1/0)\nbrates",{"$f":"IF(ISNUMBER(SEARCH(\"Biota\",Sedimentuse)),1,0)","v":0},null,"Longitude (decimal degrees)",{"$f":"_xlfn.NUMBERVALUE(IF(RIGHT($G12,1)=\"W\",\"-\",\"\")&_xlfn.NUMBERVALUE(LEFT($G12,1))+_xlfn.NUMBERVALUE(MID($G12,3,7))/60)","v":0}]
[22,null,null,null,null,null,null,null,null,null,null,null,null,"Sample method",{"$f":"IF(SamplinggeartypeDGMHM=\"DG\",\"Marine Day Grab (0.1m2)\",IF(SamplinggeartypeDGMHM=\"MHM\",\"Marine Mini Hamon Grab (0.1m2)\",#N/A))","v":{"$error":"#NAME?"}},null,"Waterbody code"]
[23,null,null,null,null,null,null,null,null,null,null,null,null,"WFD sample row offset",{"$f":"WFD_number_offset(ROW(),10,Indicativesitecode,Sedimentuse,Sed_Use)","v":{"$error":"#VALUE!"}},null,"Reason for survey"]
[24,null,null,null,null,null,null,null,null,null,null,null,null,"Latitude (decimal degrees)",{"$f":"_xlfn.NUMBERVALUE(LEFT($F12,2))+_xlfn.NUMBERVALUE(MID($F12,4,7))/60","v":0},null,"MCZ/SAC/WFD"]
[25,null,null,null,null,null,null,null,null,null,null,null,null,"Longitude (decimal degrees)",{"$f":"_xlfn.NUMBERVALUE(IF(RIGHT($G12,1)=\"W\",\"-\",\"\")&_xlfn.NUMBERVALUE(LEFT($G12,1))+_xlfn.NUMBERVALUE(MID($G12,3,7))/60)","v":0},null,"WFD site number",{"$f":"IF(ISNA(WFDsamplerowoffset),\"-\",IF(WFDsamplerowoffset=0,last_sample_number(12,ROW(),CefasSTNnumber,WFDsitenumber)+1,INDIRECT(ADDRESS(ROW()+WFDsamplerowoffset,COLUMN()))))","v":{"$error":"#NAME?"}}]
[26,null,null,null,null,null,null,null,null,null,null,null,null,"PRN",null,null,"WFD replicate code",{"$f":"IF(WFDsitenumber=\"-\",#N/A,Waterbodycode&RIGHT(YEAR($B$5),2)&LEFT(Reasonforsurvey,1)&TEXT(WFDsitenumber,\"000\")&IF(ISNUMBER(SEARCH(\"Biota\",Sedimentuse)),\"B\",IF(ISNUMBER(SEARCH(\"PSA\",Sedimentuse)),\"E\",\"\")))","v":{"$error":"#NAME?"}}]
[27,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WFD survey code",{"$f":"IF(Numericsitecode=\"-\",#N/A,Waterbodycode&VLOOKUP(MCZSACWFD,BenthicTypeCode,2,FALSE)&IF(MONTH($B$5)<10,\"0\")&MONTH($B$5)&RIGHT(YEAR($B$5),2)&IF(ISNA(MATCH(\"Biota\",Sedimentuse,0)),\"E\",\"B\"))","v":{"$error":"#NAME?"}}]
[28,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WFD sample row offset",{"$f":"WFD_number_offset(ROW(),10,CefasSTNnumber,Sedimentuse,Sed_Use)","v":{"$error":"#VALUE!"}}]
[29,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PRN"]
[30]
[31]
[32]
[33]
[34]
[34]

{"sheet":"All_Stats","index":7,"n_rows":398,"n_cols":10,"rows_kept":398,"cut":false,"hidden":true,"merged":[]}
["AQC_ID","Value","CalcErr","Mean","STDev","d.f","AbsErr","Review Date","Turbidity","Turgetto Stats Updated"]
["IDR02232DOXAQC-Blan",0,null,null,null,null,2]
["IDR02232DOXAQC-DIFF",2.0756428571428568E-2,null,2.0756428571428568E-2,3.1823710020683006E-3,57,2E-3,"2019-12-10"]
["IDR02232DOXAQC-High",100,null,99.575400000000002,1.5062,546,5]
["IDR02232SALAQC-High",8.1765999999999991E-3,"Y",8.1765999999999991E-3,1.5528999999999999E-2,544,0.1,"2020-12-30"]
["IDR02232SALAQC-Low",0,"Y",null,null,null,0.1]
["IDR02232TB_AQC-Blan",null,null,null,null,1,2,"2013-01-04"]
["IDR02232TB_AQC-T050",null,null,null,76.38,65,126.03450000000001,"2016-12-31",null,"2016-12-31"]
["IDR02232TB_AQC-T150",null,null,null,390.4,70,639.80400000000009,"2016-12-31",null,"2016-12-31"]
["IDR02232TEMAQC-High",0,null,null,null,null,0.1]
["IDR03298DOXAQC-Blan",0,null,null,null,null,2]
["IDR03298DOXAQC-DIFF",2.0756428571428568E-2,null,2.0756428571428568E-2,3.1823710020683006E-3,57,2E-3,"2019-12-10"]
["IDR03298DOXAQC-High",100,null,99.575400000000002,1.5062,546,5]
["IDR03298SALAQC-High",8.1765999999999991E-3,"Y",8.1765999999999991E-3,1.5528999999999999E-2,544,0.1,"2020-12-30"]
["IDR03298SALAQC-Low",0,"Y",null,null,null,0.1]
["IDR03298TB_AQC-Blan",null,null,null,null,1,2,"2013-01-04"]
["IDR03298TB_AQC-T037",2501,null,2501,76.379000000000005,65,125.05000000000001,"2021-10-29",179.14,"2021-11-02"]
["IDR03298TB_AQC-T137",12851.6,null,12851.6,390.94,70,642.58000000000004,"2021-10-29",179.14,"2021-11-02"]
["IDR03298TEMAQC-High",0,null,null,null,null,0.1]
["IDR04345DOXAQC-Blan",0,null,null,null,null,2]
["IDR04345DOXAQC-DIFF",2.0756428571428568E-2,null,2.0756428571428568E-2,3.1823710020683006E-3,57,2E-3,"2019-12-10"]
["IDR04345DOXAQC-High",100,null,100,1.5780000000000001,761,5,"2011-01-04"]
["IDR04345PH_AQC-PH10",0,null,-3.1E-2,6.0999999999999999E-2,315,0.15]
["IDR04345PH_AQC-PH4",0,null,6.7000000000000004E-2,5.3999999999999999E-2,315,0.15]
["IDR04345PH_AQC-PH7",0,null,2.7E-2,4.3700000000000003E-2,315,0.15]
["IDR04345PH_AQC-PH8",0,null,0,3.3300000000000003E-2,589,null,"2011-01-04"]
["IDR04345SALAQC-High",8.1765999999999991E-3,"Y",8.1765999999999991E-3,1.5528999999999999E-2,544,0.1,"2020-12-30"]
["IDR04345SALAQC-Low",0,"Y",null,null,null,0.1]
["IDR04345TB_AQC-Blan",null,null,null,null,1,2]
["IDR04345TB_AQC-Blan",null,null,null,null,1,2,"2013-01-04"]
["IDR04345TB_AQC-T045",1853.2,null,1853.2,76.379000000000005,65,92.660000000000011,"2021-06-30",139.41999999999999,"2021-07-29"]
["IDR04345TB_AQC-T145",9121.6,null,9121.6,390.4,70,456.08000000000004,"2021-06-30",139.41999999999999,"2021-07-29"]
["IDR04345TEMAQC-High",0,null,null,null,null,0.1]
["IDR05373DOXAQC-Blan",0,null,null,null,null,2]
["IDR05373DOXAQC-DIFF",2.0756428571428568E-2,null,2.0756428571428568E-2,3.1823710020683006E-3,57,2E-3,"2019-12-10"]
["IDR05373DOXAQC-High",100,null,100,1.5780000000000001,761,5,"2011-01-04"]
["IDR05373PH_AQC-PH10",0,null,-3.1E-2,6.0999999999999999E-2,315,0.15]
["IDR05373PH_AQC-PH4",0,null,6.7000000000000004E-2,5.3999999999999999E-2,315,0.15]
["IDR05373PH_AQC-PH7",0,null,2.7E-2,4.3700000000000003E-2,315,0.15]
["IDR05373PH_AQC-PH8",0,null,0,3.3300000000000003E-2,589,null,"2011-01-04"]
["IDR05373SALAQC-High",8.1765999999999991E-3,"Y",8.1765999999999991E-3,1.5528999999999999E-2,544,0.1,"2020-12-30"]
["IDR05373SALAQC-Low",0,"Y",null,null,null,0.1]
["IDR05373TB_AQC-Blan",null,null,null,null,1,2,"2013-01-04"]
["IDR05373TB_AQC-T041",2574.1999999999998,null,2574.1999999999998,76.379000000000005,65,128.71,"2021-07-01",183.1,"2021-07-29"]
["IDR05373TB_AQC-T141",13111.6,null,13111.6,390.4,70,655.58,"2021-07-01",183.1,"2021-07-29"]
["IDR05373TEMAQC-High",0,null,null,null,null,0.1]
["IDR05374DOXAQC-Blan",0,null,null,null,null,2,"Out of service: flooded"]
["IDR05374DOXAQC-DIFF",0.02,null,0.02,4.0000000000000001E-3,15,2E-3,"Out of service: flooded"]
["IDR05374DOXAQC-High",100,null,100,1.5780000000000001,761,5,"Out of service: flooded"]
["IDR05374PH_AQC-PH10",0,null,-3.1E-2,6.0999999999999999E-2,315,0.15,"Out of service: flooded"]
["IDR05374PH_AQC-PH4",0,null,6.7000000000000004E-2,5.3999999999999999E-2,315,0.15,"Out of service: flooded"]
["IDR05374PH_AQC-PH7",0,null,2.7E-2,4.3700000000000003E-2,315,0.15,"Out of service: flooded"]
["IDR05374PH_AQC-PH8",0,null,0,3.3300000000000003E-2,589,null,"Out of service: flooded"]
["IDR05374SALAQC-High",0,"Y",0,2.5499999999999998E-2,901,0.1,"Out of service: flooded"]
["IDR05374SALAQC-Low",0,"Y",null,null,null,0.1,"Out of service: flooded"]
["IDR05374TB_AQC-Blan",null,null,null,null,1,2,"Out of service: flooded"]
["IDR05374TB_AQC-T054",null,null,null,26.812000000000001,10,100.3905,"Out of service: flooded"]
["IDR05374TB_AQC-T154",null,null,null,120.913,10,504.70000000000005,"Out of service: flooded"]
["IDR05374TEMAQC-High",0,null,null,null,null,0.1,"Out of service: flooded"]
["IDR05375DOXAQC-Blan",0,null,null,null,null,2,"Out of service: flooded"]
["IDR05375DOXAQC-DIFF",0.02,null,0.02,4.0000000000000001E-3,15,2E-3,"Out of service: flooded"]
["IDR05375DOXAQC-High",100,null,100,1.5780000000000001,761,5,"Out of service: flooded"]
["IDR05375PH_AQC-PH10",0,null,-3.1E-2,6.0999999999999999E-2,315,0.15,"Out of service: flooded"]
["IDR05375PH_AQC-PH4",0,null,6.7000000000000004E-2,5.3999999999999999E-2,315,0.15,"Out of service: flooded"]
["IDR05375PH_AQC-PH7",0,null,2.7E-2,4.3700000000000003E-2,315,0.15,"Out of service: flooded"]
["IDR05375PH_AQC-PH8",0,null,0,3.3300000000000003E-2,589,null,"Out of service: flooded"]
["IDR05375SALAQC-High",0,"Y",0,2.5499999999999998E-2,901,0.1,"Out of service: flooded"]
["IDR05375SALAQC-Low",0,"Y",null,null,null,0.1,"Out of service: flooded"]
["IDR05375TEMAQC-High",0,null,null,null,null,0.1,"Out of service: flooded"]
["IDR05376DOXAQC-Blan",0,null,null,null,null,2]
["IDR05376DOXAQC-DIFF",2.0756428571428568E-2,null,2.0756428571428568E-2,3.1823710020683006E-3,57,2E-3,"2019-12-10"]
["IDR05376DOXAQC-High",100,null,100,1.5780000000000001,761,5,"2011-01-04"]
["IDR05376PH_AQC-PH10",0,null,-3.1E-2,6.0999999999999999E-2,315,0.15]
["IDR05376PH_AQC-PH4",0,null,6.7000000000000004E-2,5.3999999999999999E-2,315,0.15]
["IDR05376PH_AQC-PH7",0,null,2.7E-2,4.3700000000000003E-2,315,0.15]
["IDR05376PH_AQC-PH8",0,null,0,3.3300000000000003E-2,589,null,"2011-01-04"]
["IDR05376SALAQC-High",8.1765999999999991E-3,"Y",8.1765999999999991E-3,1.5528999999999999E-2,544,0.1,"2020-12-30"]
["IDR05376SALAQC-Low",0,"Y",null,null,null,0.1]
["IDR05376TB_AQC-Blan",null,null,null,null,1,2,"2013-01-04"]
["IDR05376TB_AQC-T038",null,null,null,76.38,65,114.99300000000001,"2016-12-31",null,"2016-12-31"]
["IDR05376TB_AQC-T138",null,null,null,390.4,70,573.94200000000001,"2016-12-31",null,"2016-12-31"]
["IDR05376TEMAQC-High",0,null,null,null,null,0.1]
["IDR06110DOXAQC-Blan",0,null,null,null,null,2,"Out of service: replaced"]
["IDR06110DOXAQC-DIFF",1.0999999999999999E-2,null,1.0999999999999999E-2,1.6299999999999999E-3,341,2E-3,"Out of service: replaced"]
["IDR06110DOXAQC-High",100,null,99.575400000000002,1.5062,546,5,"Out of service: replaced"]
["IDR06110PH_AQC-PH10",0,null,-3.1E-2,6.0999999999999999E-2,315,0.15,"Out of service: replaced"]
["IDR06110PH_AQC-PH4",0,null,6.7000000000000004E-2,5.3999999999999999E-2,315,0.15,"Out of service: replaced"]
["IDR06110PH_AQC-PH7",0,null,2.7E-2,4.3700000000000003E-2,315,0.15,"Out of service: replaced"]
["IDR06110PH_AQC-PH8",0,null,0,3.4000000000000002E-2,337,0.1,"Out of service: replaced"]
["IDR06110SALAQC-High",8.1765999999999991E-3,"Y",8.1765999999999991E-3,1.5528999999999999E-2,544,0.1,"Out of service: replaced"]
["IDR06110SALAQC-Low",0,"Y",null,null,null,0.1,"Out of service: replaced"]
["IDR06110TB_AQC-Blan",0,null,null,null,1,2,"Out of service: replaced"]
["IDR06110TB_AQC-T032",3919.81,null,3919.81,62.598999999999997,927,196.57300000000001,"Out of service: replaced"]
["IDR06110TB_AQC-T132",19681.3,null,19681.3,310.03100000000001,929,989.57099999999991,"Out of service: replaced"]
["IDR06110TEMAQC-High",0,null,null,null,null,0.1,"Out of service: replaced"]
["IDR06111DOXAQC-Blan",0,null,null,null,null,2]
["IDR06111DOXAQC-DIFF",1.0213136052968811E-2,null,1.0213136052968811E-2,1.7126866372907598E-3,2340,2E-3,"2019-12-10"]
["IDR06111DOXAQC-High",100,null,99.575400000000002,1.5062,546,5,"2010-02-22"]
["IDR06111PH_AQC-PH10",0,null,-3.1E-2,6.0999999999999999E-2,315,0.15]
["IDR06111PH_AQC-PH4",0,null,6.7000000000000004E-2,5.3999999999999999E-2,315,0.15]
["IDR06111PH_AQC-PH7",0,null,2.7E-2,4.3700000000000003E-2,315,0.15]
["IDR06111PH_AQC-PH8",0,null,0,3.4000000000000002E-2,337,0.1,"2009-12-30"]
["IDR06111SALAQC-High",8.1765999999999991E-3,"Y",8.1765999999999991E-3,1.5528999999999999E-2,544,0.1,"2018-01-22"]
["IDR06111SALAQC-Low",0,"Y",null,null,null,0.1]
["IDR06111TB_AQC-Blan",0,null,null,null,1,2,"2013-01-04"]
["IDR06111TB_AQC-T042",3808.8,null,3808.8,62.598999999999997,927,190.44000000000003,"2021-04-26",135.29,"2021-07-29"]
["IDR06111TB_AQC-T142",19245.599999999999,null,19245.599999999999,310.03100000000001,929,962.28,"2021-04-26",135.29,"2021-07-29"]
["IDR06111TEMAQC-High",0,null,null,null,null,0.1]
["IDR06111TR%AQC-ND75",0,"Y",null,null,null,2]
["IDR06113DOXAQC-Blan",0,null,null,null,null,2]
["IDR06113DOXAQC-DIFF",1.0213136052968811E-2,null,1.0213136052968811E-2,1.7126866372907598E-3,2340,2E-3,"2019-12-10"]
["IDR06113DOXAQC-High",100,null,99.575400000000002,1.5062,546,5,"2010-02-22"]
["IDR06113PH_AQC-PH10",0,null,-3.1E-2,6.0999999999999999E-2,315,0.15]
["IDR06113PH_AQC-PH4",0,null,6.7000000000000004E-2,5.3999999999999999E-2,315,0.15]
["IDR06113PH_AQC-PH7",0,null,2.7E-2,4.3700000000000003E-2,315,0.15]
["IDR06113PH_AQC-PH8",0,null,0,3.4000000000000002E-2,337,0.1,"2009-12-30"]
["IDR06113SALAQC-High",8.1765999999999991E-3,"Y",8.1765999999999991E-3,1.5528999999999999E-2,544,0.1,"2020-12-30"]
["IDR06113SALAQC-Low",0,"Y",null,null,null,0.1]
["IDR06113TB_AQC-Blan",0,null,null,null,1,2,"2013-01-04"]
["IDR06113TB_AQC-T046",3983.6,null,3983.6,62.598999999999997,927,199.18,"2021-06-24",181.08,"2021-07-29"]
["IDR06113TB_AQC-T146",20010.599999999999,null,20010.599999999999,310.02999999999997,929,1000.53,"2021-06-24",181.08,"2021-07-29"]
["IDR06113TEMAQC-High",0,null,null,null,null,0.1]
["IDR07126DOXAQC-Blan",0,null,null,null,null,2,"Out of service: lost"]
["IDR07126DOXAQC-DIFF",1.0999999999999999E-2,null,1.0999999999999999E-2,1.6299999999999999E-3,341,2E-3,"Out of service: lost"]
["IDR07126DOXAQC-High",100,null,99.575400000000002,1.5062,546,5,"Out of service: lost"]
["IDR07126PH_AQC-PH10",0,null,-3.1E-2,6.0999999999999999E-2,315,0.15,"Out of service: lost"]
["IDR07126PH_AQC-PH4",0,null,6.7000000000000004E-2,5.3999999999999999E-2,315,0.15,"Out of service: lost"]
["IDR07126PH_AQC-PH7",0,null,2.7E-2,4.3700000000000003E-2,315,0.15,"Out of service: lost"]
["IDR07126PH_AQC-PH8",0,null,0,3.4000000000000002E-2,337,0.1,"Out of service: lost"]
["IDR07126SALAQC-High",1.6E-2,"Y",1.6E-2,2.0500000000000001E-2,452,0.1,"Out of service: lost"]
["IDR07126SALAQC-Low",0,"Y",null,null,null,0.1,"Out of service: lost"]
["IDR07126TEMAQC-High",0,null,null,null,null,0.1,"Out of service: lost"]
["IDR12224DOXAQC-Blan",0,null,null,null,null,2,"Out of service: lost"]
["IDR12224DOXAQC-DIFF",1.0999999999999999E-2,null,1.0999999999999999E-2,1.6299999999999999E-3,341,2E-3,"Out of service: lost"]
["IDR12224DOXAQC-High",100,null,99.575400000000002,1.5062,546,5,"Out of service: lost"]
["IDR12224PH_AQC-PH10",0,null,-3.1E-2,6.0999999999999999E-2,315,0.15,"Out of service: lost"]
["IDR12224PH_AQC-PH4",0,null,6.7000000000000004E-2,5.3999999999999999E-2,315,0.15,"Out of service: lost"]
["IDR12224PH_AQC-PH7",0,null,2.7E-2,4.3700000000000003E-2,315,0.15,"Out of service: lost"]
["IDR12224PH_AQC-PH8",0,null,0,3.4000000000000002E-2,337,0.1,"Out of service: lost"]
["IDR12224SALAQC-High",1.6E-2,"Y",1.6E-2,2.0500000000000001E-2,452,0.1,"Out of service: lost"]
["IDR12224SALAQC-Low",0,"Y",null,null,null,0.1,"Out of service: lost"]
["IDR12224TB_AQC-Blan",null,null,null,null,1,2,"Out of service: lost"]
["IDR12224TB_AQC-T031",4204.6000000000004,null,4204.6000000000004,4.8099999999999996,5,210.23,"Out of service: lost"]
["IDR12224TB_AQC-T131",21241,null,21241,22,5,1062.07,"Out of service: lost"]
["IDR12224TEMAQC-High",0,null,null,null,null,0.1,"Out of service: lost"]
["IDR13257DOXAQC-Blan",0,null,null,null,null,2]
["IDR13257DOXAQC-DIFF",1.0213136052968811E-2,null,1.0213136052968811E-2,1.7126866372907598E-3,2340,2E-3,"2019-12-10"]
["IDR13257DOXAQC-High",100,null,99.575400000000002,1.5062,546,5,"2010-02-22"]
["IDR13257PH_AQC-PH10",0,null,-3.1E-2,6.0999999999999999E-2,315,0.15]
["IDR13257PH_AQC-PH4",0,null,6.7000000000000004E-2,5.3999999999999999E-2,315,0.15]
["IDR13257PH_AQC-PH7",0,null,2.7E-2,4.3700000000000003E-2,315,0.15]
["IDR13257PH_AQC-PH8",0,null,0,3.4000000000000002E-2,337,0.1,"2009-12-30"]
["IDR13257SALAQC-High",8.1765999999999991E-3,"Y",8.1765999999999991E-3,1.5528999999999999E-2,544,0.1,"2020-12-30"]
["IDR13257SALAQC-Low",0,"Y",null,null,null,0.1]
["IDR13257TB_AQC-Blan",0,null,null,null,1,2,"2013-02-19"]
["IDR13257TB_AQC-T048",3828.4,null,3828.4,62.598999999999997,927,216.435,"2016-12-31",null,"2016-12-31"]
["IDR13257TB_AQC-T148",19161.599999999999,null,19161.599999999999,310.03100000000001,929,1120.2560000000001,"2016-12-31",null,"2016-12-31"]
["IDR13257TEMAQC-High",0,null,null,null,null,0.1]
["IDR14303DOXAQC-Blan",0,null,null,null,null,2]
["IDR14303DOXAQC-DIFF",1.0213136052968811E-2,null,1.0213136052968811E-2,1.7126866372907598E-3,2340,2E-3,"2019-12-10"]
["IDR14303DOXAQC-High",100,null,99.575400000000002,1.5062,546,5,"2010-02-22"]
["IDR14303PH_AQC-PH10",0,null,-3.1E-2,6.0999999999999999E-2,315,0.15]
["IDR14303PH_AQC-PH4",0,null,6.7000000000000004E-2,5.3999999999999999E-2,315,0.15]
["IDR14303PH_AQC-PH7",0,null,2.7E-2,4.3700000000000003E-2,315,0.15]
["IDR14303PH_AQC-PH8",0,null,0,3.4000000000000002E-2,337,0.1,"2009-12-30"]
["IDR14303SALAQC-High",8.1765999999999991E-3,"Y",8.1765999999999991E-3,1.5528999999999999E-2,544,0.1,"2020-12-30"]
["IDR14303SALAQC-Low",0,"Y",null,null,null,0.1]
["IDR14303TB_AQC-Blan",0,null,null,null,1,2,"2013-01-04"]
["IDR14303TB_AQC-T035",4408.6000000000004,null,4408.6000000000004,67.659000000000006,451,220.43000000000004,"2021-10-18",184.22,"2021-11-02"]
["IDR14303TB_AQC-T135",22278,null,22278,327.61500000000001,450,1113.9000000000001,"2021-10-18",184.22,"2021-11-02"]
["IDR14303TEMAQC-High",0,null,null,null,null,0.1]
["IDR14311DOXAQC-Blan",0,null,null,null,null,2]
["IDR14311DOXAQC-DIFF",1.0213136052968811E-2,null,1.0213136052968811E-2,1.7126866372907598E-3,2340,2E-3,"2019-12-10"]
["IDR14311DOXAQC-High",100,null,99.575400000000002,1.5062,546,5,"2010-02-22"]
["IDR14311PH_AQC-PH10",0,null,-3.1E-2,6.0999999999999999E-2,315,0.15]
["IDR14311PH_AQC-PH4",0,null,6.7000000000000004E-2,5.3999999999999999E-2,315,0.15]
["IDR14311PH_AQC-PH7",0,null,2.7E-2,4.3700000000000003E-2,315,0.15]
["IDR14311PH_AQC-PH8",0,null,0,3.4000000000000002E-2,337,0.1,"2009-12-30"]
["IDR14311SALAQC-High",8.1765999999999991E-3,"Y",8.1765999999999991E-3,1.5528999999999999E-2,544,0.1,"2020-12-30"]
["IDR14311SALAQC-Low",0,"Y",null,null,null,0.1]
["IDR14311TB_AQC-Blan",0,null,null,null,1,2,"2013-01-04"]
["IDR14311TB_AQC-T040",4336.3999999999996,null,4336.3999999999996,67.659000000000006,451,216.82,"2021-05-25",188.72,"2021-07-29"]
["IDR14311TB_AQC-T140",21898.799999999999,null,21898.799999999999,327.61500000000001,450,1094.94,"2021-05-25",188.72,"2021-07-29"]
["IDR14311TEMAQC-High",0,null,null,null,null,0.1]
["IDR15319DOXAQC-Blan",0,null,null,null,null,2]
["IDR15319DOXAQC-DIFF",1.0213136052968811E-2,null,1.0213136052968811E-2,1.7126866372907598E-3,2340,2E-3,"2019-12-10"]
["IDR15319DOXAQC-High",100,null,99.575400000000002,1.5062,546,5,"2010-02-22"]
["IDR15319PH_AQC-PH10",0,null,-3.1E-2,6.0999999999999999E-2,315,0.15]
["IDR15319PH_AQC-PH4",0,null,6.7000000000000004E-2,5.3999999999999999E-2,315,0.15]
["IDR15319PH_AQC-PH7",0,null,2.7E-2,4.3700000000000003E-2,315,0.15]
["IDR15319PH_AQC-PH8",0,null,0,3.4000000000000002E-2,337,0.1,"2009-12-30"]
["IDR15319SALAQC-High",8.1765999999999991E-3,"Y",8.1765999999999991E-3,1.5528999999999999E-2,544,0.1,"2020-12-30"]
["IDR15319SALAQC-Low",0,"Y",null,null,null,0.1]
["IDR15319TB_AQC-Blan",0,null,null,null,1,2,"2013-02-19"]
["IDR15319TB_AQC-T030",3737.2,null,3737.2,67.659000000000006,451,186.86,"2021-06-07",151.1,"2021-07-29"]
["IDR15319TB_AQC-T130",18797,null,18797,327.61500000000001,450,939.85,"2021-06-07",151.1,"2021-07-29"]
["IDR15319TEMAQC-High",0,null,null,null,null,0.1]
["IDR16339DOXAQC-Blan",0,null,null,null,null,2]
["IDR16339DOXAQC-DIFF",1.0213136052968811E-2,null,1.0213136052968811E-2,1.7126866372907598E-3,2340,2E-3,"2019-12-10"]
["IDR16339DOXAQC-High",100,null,99.575400000000002,1.5062,546,5,"2010-02-22"]
["IDR16339PH_AQC-PH10",0,null,-3.1E-2,6.0999999999999999E-2,315,0.15]
["IDR16339PH_AQC-PH4",0,null,6.7000000000000004E-2,5.3999999999999999E-2,315,0.15]
["IDR16339PH_AQC-PH7",0,null,2.7E-2,4.3700000000000003E-2,315,0.15]
["IDR16339PH_AQC-PH8",0,null,0,3.4000000000000002E-2,337,0.1,"2009-12-30"]
["IDR16339SALAQC-High",8.1765999999999991E-3,"Y",8.1765999999999991E-3,1.5528999999999999E-2,544,0.1,"2020-12-30"]
["IDR16339SALAQC-Low",0,"Y",null,null,null,0.1]
["IDR16339TB_AQC-Blan",0,null,null,null,1,2,"2013-02-19"]
["IDR16339TB_AQC-T051",4014.6,null,4014.6,67.659000000000006,451,200.73000000000002,"2021-10-18",157.02000000000001,"2021-11-02"]
["IDR16339TB_AQC-T151",20280.400000000001,null,20280.400000000001,327.61500000000001,450,1014.0200000000001,"2021-10-18",157.02000000000001,"2021-11-02"]
["IDR16339TEMAQC-High",0,null,null,null,null,0.1]
["IDR17353DOXAQC-Blan",0,null,null,null,null,2]
["IDR17353DOXAQC-DIFF",1.0213136052968811E-2,null,1.0213136052968811E-2,1.7126866372907598E-3,2340,2E-3,"2019-12-10"]
["IDR17353DOXAQC-High",100,null,99.575400000000002,1.5062,546,5,"2010-02-22"]
["IDR17353PH_AQC-PH10",0,null,-3.1E-2,6.0999999999999999E-2,315,0.15]
["IDR17353PH_AQC-PH4",0,null,6.7000000000000004E-2,5.3999999999999999E-2,315,0.15]
["IDR17353PH_AQC-PH7",0,null,2.7E-2,4.3700000000000003E-2,315,0.15]
["IDR17353PH_AQC-PH8",0,null,0,3.4000000000000002E-2,337,0.1,"2009-12-30"]
["IDR17353SALAQC-High",8.1765999999999991E-3,"Y",8.1765999999999991E-3,1.5528999999999999E-2,544,0.1,"2020-12-30"]
["IDR17353SALAQC-Low",0,"Y",null,null,null,0.1]
["IDR17353TB_AQC-Blan",0,null,null,null,1,2,"2013-01-04"]
["IDR17353TB_AQC-T031",3250.4,null,3250.4,67.659000000000006,451,162.52000000000001,"2021-04-26",149.96,"2021-07-29"]
["IDR17353TB_AQC-T131",16401.2,null,16401.2,327.61500000000001,450,820.06000000000006,"2021-04-26",149.96,"2021-07-29"]
["IDR17353TEMAQC-High",0,null,null,null,null,0.1]
["IDR17354DOXAQC-Blan",0,null,null,null,null,2]
["IDR17354DOXAQC-DIFF",1.0213136052968811E-2,null,1.0213136052968811E-2,1.7126866372907598E-3,2340,2E-3,"2019-12-10"]
["IDR17354DOXAQC-High",100,null,99.575400000000002,1.5062,546,5,"2010-02-22"]
["IDR17354PH_AQC-PH10",0,null,-3.1E-2,6.0999999999999999E-2,315,0.15]
["IDR17354PH_AQC-PH4",0,null,6.7000000000000004E-2,5.3999999999999999E-2,315,0.15]
["IDR17354PH_AQC-PH7",0,null,2.7E-2,4.3700000000000003E-2,315,0.15]
["IDR17354PH_AQC-PH8",0,null,0,3.4000000000000002E-2,337,0.1,"2009-12-30"]
["IDR17354SALAQC-High",8.1765999999999991E-3,"Y",8.1765999999999991E-3,1.5528999999999999E-2,544,0.1,"2020-12-30"]
["IDR17354SALAQC-Low",0,"Y",null,null,null,0.1]
["IDR17354TB_AQC-Blan",0,null,null,null,1,2,"2013-01-04"]
["IDR17354TB_AQC-T043",3704.4,null,3704.4,67.659000000000006,451,185.22000000000003,"2021-04-13",156.84,"2021-07-29"]
["IDR17354TB_AQC-T143",18713,null,18713,327.61500000000001,450,935.65000000000009,"2021-04-13",156.84,"2021-07-29"]
["IDR17354TEMAQC-High",0,null,null,null,null,0.1]
["IDR17355DOXAQC-Blan",0,null,null,null,null,2]
["IDR17355DOXAQC-DIFF",8.9399999999999964E-5,null,8.9399999999999964E-5,3.9191835884530863E-6,17,2E-3,"2019-12-10"]
["IDR17355DOXAQC-High",100,null,99.520799999999994,1.2403999999999999,234,5,"2020-12-30"]
["IDR17355DOXAQC-OOSi",400,null,400,50,20,200,"2019-10-08"]
["IDR17355DOXAQC-OOAm",1,null,0,2,20,10,"2019-10-08"]
["IDR17355PH_AQC-PH10",0,null,-3.1E-2,6.0999999999999999E-2,315,0.15]
["IDR17355PH_AQC-PH4",0,null,6.7000000000000004E-2,5.3999999999999999E-2,315,0.15]
["IDR17355PH_AQC-PH7",0,null,2.7E-2,4.3700000000000003E-2,315,0.15]
["IDR17355PH_AQC-PH8",0,null,0,3.4000000000000002E-2,337,0.1,"2009-12-30"]
["IDR17355SALAQC-High",8.1765999999999991E-3,"Y",8.1765999999999991E-3,1.5528999999999999E-2,544,0.1,"2020-12-30"]
["IDR17355SALAQC-Low",0,"Y",null,null,null,0.1]
["IDR17355TB_AQC-Blan",0,null,null,null,1,2,"2013-01-04"]
["IDR17355TB_AQC-T036",3753,null,3753,67.659000000000006,451,187.65,"2022-12-20",160.52000000000001,"2022-01-10"]
["IDR17355TB_AQC-T136",18957.8,null,18957.8,327.61500000000001,450,947.89,"2022-12-20",160.52000000000001,"2022-01-10"]
["IDR17355TEMAQC-High",0,null,null,null,null,0.1]
["IDR17356DOXAQC-Blan",0,null,null,null,null,2]
["IDR17356DOXAQC-DIFF",1.0213136052968811E-2,null,1.0213136052968811E-2,1.7126866372907598E-3,2340,2E-3,"2019-12-10"]
["IDR17356DOXAQC-High",100,null,99.575400000000002,1.5062,546,5,"2010-02-22"]
["IDR17356PH_AQC-PH10",0,null,-3.1E-2,6.0999999999999999E-2,315,0.15]
["IDR17356PH_AQC-PH4",0,null,6.7000000000000004E-2,5.3999999999999999E-2,315,0.15]
["IDR17356PH_AQC-PH7",0,null,2.7E-2,4.3700000000000003E-2,315,0.15]
["IDR17356PH_AQC-PH8",0,null,0,3.4000000000000002E-2,337,0.1,"2009-12-30"]
["IDR17356SALAQC-High",8.1765999999999991E-3,"Y",8.1765999999999991E-3,1.5528999999999999E-2,544,0.1,"2020-12-30"]
["IDR17356SALAQC-Low",0,"Y",null,null,null,0.1]
["IDR17356TB_AQC-Blan",0,null,null,null,1,2,"2013-01-04"]
["IDR17356TB_AQC-T039",3198.2,null,3198.2,67.659000000000006,451,159.91,"2021-04-02",138.66,"2021-07-29"]
["IDR17356TB_AQC-T139",15847.4,null,15847.4,327.61500000000001,450,792.37,"2021-04-02",138.66,"2021-07-29"]
["IDR17356TEMAQC-High",0,null,null,null,null,0.1]
["IDR17357DOXAQC-Blan",0,null,null,null,null,2]
["IDR17357DOXAQC-DIFF",1.0213136052968811E-2,null,1.0213136052968811E-2,1.7126866372907598E-3,2340,2E-3,"2019-12-10"]
["IDR17357DOXAQC-High",100,null,99.575400000000002,1.5062,546,5,"2010-02-22"]
["IDR17357PH_AQC-PH10",0,null,-3.1E-2,6.0999999999999999E-2,315,0.15]
["IDR17357PH_AQC-PH4",0,null,6.7000000000000004E-2,5.3999999999999999E-2,315,0.15]
["IDR17357PH_AQC-PH7",0,null,2.7E-2,4.3700000000000003E-2,315,0.15]
["IDR17357PH_AQC-PH8",0,null,0,3.4000000000000002E-2,337,0.1,"2009-12-30"]
["IDR17357SALAQC-High",8.1765999999999991E-3,"Y",8.1765999999999991E-3,1.5528999999999999E-2,544,0.1,"2020-12-30"]
["IDR17357SALAQC-Low",0,"Y",null,null,null,0.1]
["IDR17357TB_AQC-Blan",0,null,null,null,1,2,"2013-01-04"]
["IDR17357TB_AQC-T047",3775.6,null,3775.6,67.659000000000006,451,188.78,"2021-06-07",164.4,"2021-07-29"]
["IDR17357TB_AQC-T147",19135.599999999999,null,19135.599999999999,327.61500000000001,450,956.78,"2021-06-07",164.4,"2021-07-29"]
["IDR17357TEMAQC-High",0,null,null,null,null,0.1]
["IDR19063DOXAQC-Blan",0,null,null,null,null,2]
["IDR19063DOXAQC-DIFF",1.0213136052968811E-2,null,1.0213136052968811E-2,1.7126866372907598E-3,2340,2E-3,"2019-12-10"]
["IDR19063DOXAQC-High",100,null,99.520799999999994,1.2403999999999999,234,5,"2020-12-30"]
["IDR19063DOXAQC-OOSi",400,null,400,50,20,200,"2019-10-08"]
["IDR19063DOXAQC-OOAm",1,null,0,2,20,10,"2019-10-08"]
["IDR19063PH_AQC-PH10",0,null,-3.1E-2,6.0999999999999999E-2,315,0.15]
["IDR19063PH_AQC-PH4",0,null,6.7000000000000004E-2,5.3999999999999999E-2,315,0.15]
["IDR19063PH_AQC-PH7",0,null,2.7E-2,4.3700000000000003E-2,315,0.15]
["IDR19063PH_AQC-PH8",0,null,0,3.4000000000000002E-2,337,0.1,"2009-12-30"]
["IDR19063SALAQC-High",8.1765999999999991E-3,"Y",8.1765999999999991E-3,1.5528999999999999E-2,544,0.1,"2020-12-30"]
["IDR19063SALAQC-Low",0,"Y",null,null,null,0.1]
["IDR19063TB_AQC-Blan",0,null,null,null,1,2,"2013-01-04"]
["IDR19063TB_AQC-T061",2913,null,2913,67.659000000000006,451,145.65,"2021-07-01",113.32,"2021-07-29"]
["IDR19063TB_AQC-T161",14663.4,null,14663.4,327.61500000000001,450,733.17000000000007,"2021-07-01",113.32,"2021-07-29"]
["IDR19063TEMAQC-High",0,null,null,null,null,0.1]
["IDR19064DOXAQC-Blan",0,null,null,null,null,2]
["IDR19064DOXAQC-DIFF",1.0213136052968811E-2,null,1.0213136052968811E-2,1.7126866372907598E-3,2340,2E-3,"2019-12-10"]
["IDR19064DOXAQC-High",100,null,99.520799999999994,1.2403999999999999,234,5,"2020-12-30"]
["IDR19064DOXAQC-OOSi",400,null,400,50,20,200,"2019-10-08"]
["IDR19064DOXAQC-OOAm",1,null,0,2,20,10,"2019-10-08"]
["IDR19064PH_AQC-PH10",0,null,-3.1E-2,6.0999999999999999E-2,315,0.15]
["IDR19064PH_AQC-PH4",0,null,6.7000000000000004E-2,5.3999999999999999E-2,315,0.15]
["IDR19064PH_AQC-PH7",0,null,2.7E-2,4.3700000000000003E-2,315,0.15]
["IDR19064PH_AQC-PH8",0,null,0,3.4000000000000002E-2,337,0.1,"2009-12-30"]
["IDR19064SALAQC-High",8.1765999999999991E-3,"Y",8.1765999999999991E-3,1.5528999999999999E-2,544,0.1,"2020-12-30"]
["IDR19064SALAQC-Low",0,"Y",null,null,null,0.1]
["IDR19064TB_AQC-Blan",0,null,null,null,1,2,"2013-01-04"]
["IDR19064TB_AQC-T052",2574.6,null,2574.6,67.659000000000006,451,128.72999999999999,"2021-10-11",107,"2021-11-02"]
["IDR19064TB_AQC-T152",12919.8,null,12919.8,327.62,450,645.99,"2021-10-11",107,"2021-11-02"]
["IDR19064TEMAQC-High",0,null,null,null,null,0.1]
["IDR19065DOXAQC-Blan",0,null,null,null,null,2]
["IDR19065DOXAQC-DIFF",1.0213136052968811E-2,null,1.0213136052968811E-2,1.7126866372907598E-3,2340,2E-3,"2019-12-10"]
["IDR19065DOXAQC-High",100,null,99.520799999999994,1.2403999999999999,234,5,"2020-12-30"]
["IDR19065DOXAQC-OOSi",400,null,400,50,20,200,"2019-10-08"]
["IDR19065DOXAQC-OOAm",1,null,0,2,20,10,"2019-10-08"]
["IDR19065PH_AQC-PH10",0,null,-3.1E-2,6.0999999999999999E-2,315,0.15]
["IDR19065PH_AQC-PH4",0,null,6.7000000000000004E-2,5.3999999999999999E-2,315,0.15]
["IDR19065PH_AQC-PH7",0,null,2.7E-2,4.3700000000000003E-2,315,0.15]
["IDR19065PH_AQC-PH8",0,null,0,3.4000000000000002E-2,337,0.1,"2009-12-30"]
["IDR19065SALAQC-High",8.1765999999999991E-3,"Y",8.1765999999999991E-3,1.5528999999999999E-2,544,0.1,"2020-12-30"]
["IDR19065SALAQC-Low",0,"Y",null,null,null,0.1]
["IDR19065TB_AQC-Blan",0,null,null,null,1,2,"2013-01-04"]
["IDR19065TB_AQC-T063",2584.1999999999998,null,2584.1999999999998,67.659000000000006,451,129.21,"2021-05-27",98.7,"2021-07-29"]
["IDR19065TB_AQC-T163",13011.2,null,13011.2,327.61500000000001,450,650.56000000000006,"2021-05-27",98.7,"2021-07-29"]
["IDR19065TEMAQC-High",0,null,null,null,null,0.1]
["IDR19110DOXAQC-Blan",0,null,null,null,null,2]
["IDR19110DOXAQC-DIFF",1.0213136052968811E-2,null,1.0213136052968811E-2,1.7126866372907598E-3,2340,2E-3,"2019-12-10"]
["IDR19110DOXAQC-High",100,null,99.520799999999994,1.2403999999999999,234,5,"2020-12-30"]
["IDR19110DOXAQC-OOSi",400,null,400,50,20,200,"2019-10-08"]
["IDR19110DOXAQC-OOAm",1,null,0,2,20,10,"2019-10-08"]
["IDR19110PH_AQC-PH10",0,null,-3.1E-2,6.0999999999999999E-2,315,0.15]
["IDR19110PH_AQC-PH4",0,null,6.7000000000000004E-2,5.3999999999999999E-2,315,0.15]
["IDR19110PH_AQC-PH7",0,null,2.7E-2,4.3700000000000003E-2,315,0.15]
["IDR19110PH_AQC-PH8",0,null,0,3.4000000000000002E-2,337,0.1,"2009-12-30"]
["IDR19110SALAQC-High",8.1765999999999991E-3,"Y",8.1765999999999991E-3,1.5528999999999999E-2,544,0.1,"2020-12-30"]
["IDR19110SALAQC-Low",0,"Y",null,null,null,0.1]
["IDR19110TB_AQC-Blan",0,null,null,null,1,2,"2013-01-04"]
["IDR19110TB_AQC-T049",2581.4,null,2581.4,67.659000000000006,451,129.07000000000002,"2021-06-25",119.02,"2021-07-29"]
["IDR19110TB_AQC-T149",12912.2,null,12912.2,327.61500000000001,450,645.61000000000013,"2021-06-25",119.02,"2021-07-29"]
["IDR19110TEMAQC-High",0,null,null,null,null,0.1]
["IDR19111DOXAQC-Blan",0,null,null,null,null,2]
["IDR19111DOXAQC-DIFF",1.0213136052968811E-2,null,1.0213136052968811E-2,1.7126866372907598E-3,2340,2E-3,"2019-12-10"]
["IDR19111DOXAQC-High",100,null,99.520799999999994,1.2403999999999999,234,5,"2020-12-30"]
["IDR19111DOXAQC-OOSi",400,null,400,50,20,200,"2019-10-08"]
["IDR19111DOXAQC-OOAm",1,null,0,2,20,10,"2019-10-08"]
["IDR19111PH_AQC-PH10",0,null,-3.1E-2,6.0999999999999999E-2,315,0.15]
["IDR19111PH_AQC-PH4",0,null,6.7000000000000004E-2,5.3999999999999999E-2,315,0.15]
["IDR19111PH_AQC-PH7",0,null,2.7E-2,4.3700000000000003E-2,315,0.15]
["IDR19111PH_AQC-PH8",0,null,0,3.4000000000000002E-2,337,0.1,"2009-12-30"]
["IDR19111SALAQC-High",8.1765999999999991E-3,"Y",8.1765999999999991E-3,1.5528999999999999E-2,544,0.1,"2020-12-30"]
["IDR19111SALAQC-Low",0,"Y",null,null,null,0.1]
["IDR19111TB_AQC-Blan",0,null,null,null,1,2,"2013-01-04"]
["IDR19111TB_AQC-T044",3771.6,null,3771.6,67.659000000000006,451,188.58,"2021-04-02",149.22,"2021-07-29"]
["IDR19111TB_AQC-T144",18863,null,18863,327.61500000000001,450,943.15000000000009,"2021-04-02",149.22,"2021-07-29"]
["IDR19111TEMAQC-High",0,null,null,null,null,0.1]
["IDR19358DOXAQC-Blan",0,null,null,null,null,2]
["IDR19358DOXAQC-DIFF",1.0213136052968811E-2,null,1.0213136052968811E-2,1.7126866372907598E-3,2340,2E-3,"2019-12-10"]
["IDR19358DOXAQC-High",100,null,99.575400000000002,1.5062,546,5,"2010-02-22"]
["IDR19358PH_AQC-PH10",0,null,-3.1E-2,6.0999999999999999E-2,315,0.15]
["IDR19358PH_AQC-PH4",0,null,6.7000000000000004E-2,5.3999999999999999E-2,315,0.15]
["IDR19358PH_AQC-PH7",0,null,2.7E-2,4.3700000000000003E-2,315,0.15]
["IDR19358PH_AQC-PH8",0,null,0,3.4000000000000002E-2,337,0.1,"2009-12-30"]
["IDR19358SALAQC-High",8.1765999999999991E-3,"Y",8.1765999999999991E-3,1.5528999999999999E-2,544,0.1,"2020-12-30"]
["IDR19358SALAQC-Low",0,"Y",null,null,null,0.1]
["IDR19358TB_AQC-Blan",0,null,null,null,1,2,"2013-01-04"]
["IDR19358TB_AQC-T032",3570.8,null,3570.8,67.659000000000006,451,178.54000000000002,"2021-04-13",171.42,"2021-07-29"]
["IDR19358TB_AQC-T132",18002.2,null,18002.2,327.61500000000001,450,900.11000000000013,"2021-04-13",171.42,"2021-07-29"]
["IDR19358DOXAQC-High",0,null,null,null,null,0.1]
["IDR21166DOXAQC-Blan",0,null,null,null,null,2]
["IDR21166DOXAQC-DIFF",8.9399999999999964E-5,null,8.9399999999999964E-5,3.9191835884530863E-6,17,2E-3,"2019-12-10"]
["IDR21166DOXAQC-High",100,null,99.520799999999994,1.2403999999999999,234,5,"2020-12-30"]
["IDR21166PH_AQC-PH10",0,null,-3.1E-2,6.0999999999999999E-2,315,0.15]
["IDR21166PH_AQC-PH4",0,null,6.7000000000000004E-2,5.3999999999999999E-2,315,0.15]
["IDR21166PH_AQC-PH7",0,null,2.7E-2,4.3700000000000003E-2,315,0.15]
["IDR21166PH_AQC-PH8",0,null,0,3.4000000000000002E-2,337,0.1,"2009-12-30"]
["IDR21166SALAQC-High",8.1765999999999991E-3,"Y",8.1765999999999991E-3,1.5528999999999999E-2,544,0.1,"2020-12-30"]
["IDR21166SALAQC-Low",0,"Y",null,null,null,0.1]
["IDR21166TB_AQC-Blan",0,null,null,null,1,2,"2013-01-04"]
["IDR21166TB_AQC-T048",3979.6,null,3979.6,67.659000000000006,451,198.98000000000002,"2021-10-15",154.58000000000001,"2021-11-02"]
["IDR21166TB_AQC-T148",19930.599999999999,null,19930.599999999999,327.61500000000001,450,996.53,"2021-10-15",154.58000000000001,"2021-11-02"]
["IDR21166TEMAQC-High",0,null,null,null,null,0.1]
["IDR99077DOXAQC-Blan",0,null,null,null,null,2]
["IDR99077DOXAQC-DIFF",2.0756428571428568E-2,null,2.0756428571428568E-2,3.1823710020683006E-3,57,2E-3,"2019-12-10"]
["IDR99077DOXAQC-High",100,null,99.575400000000002,1.5062,546,5]
["IDR99077PH_AQC-PH10",0,null,-3.1E-2,6.0999999999999999E-2,315,0.15]
["IDR99077PH_AQC-PH4",0,null,6.7000000000000004E-2,5.3999999999999999E-2,315,0.15]
["IDR99077PH_AQC-PH7",0,null,2.7E-2,4.3700000000000003E-2,315,0.15]
["IDR99077PH_AQC-PH8",0,null,0,3.3300000000000003E-2,589]
["IDR99077SALAQC-High",8.1765999999999991E-3,"Y",8.1765999999999991E-3,1.5528999999999999E-2,544,0.1,"2020-12-30"]
["IDR99077SALAQC-Low",0,"Y",null,null,null,0.1]
["IDR99077TEMAQC-High",0,null,null,null,null,0.1]
["IDR99084DOXAQC-Blan",0,null,null,null,null,2]
["IDR99084DOXAQC-DIFF",2.0756428571428568E-2,null,2.0756428571428568E-2,3.1823710020683006E-3,57,2E-3,"2019-12-10"]
["IDR99084DOXAQC-High",100,null,99.575400000000002,1.5062,546,5]
["IDR99084PH_AQC-PH10",0,null,-3.1E-2,6.0999999999999999E-2,315,0.15]
["IDR99084PH_AQC-PH4",0,null,6.7000000000000004E-2,5.3999999999999999E-2,315,0.15]
["IDR99084PH_AQC-PH7",0,null,2.7E-2,4.3700000000000003E-2,315,0.15]
["IDR99084PH_AQC-PH8",0,null,0,3.4000000000000002E-2,337,0.1]
["IDR99084SALAQC-High",8.1765999999999991E-3,"Y",8.1765999999999991E-3,1.5528999999999999E-2,544,0.1,"2020-12-30"]
["IDR99084SALAQC-Low",0,"Y",null,null,null,0.1]
["IDR99084TEMAQC-High",0,null,null,null,null,0.1]

{"sheet":"Checks","index":8,"n_rows":25,"n_cols":19,"rows_kept":25,"cut":false,"hidden":true,"merged":[]}
["AQC_ID","Value","Calc Error","Mean","STDev","d.f.","Abs Error","[USL]","[+3S]","[+2S]","[-2S]","[-3S]","[LSL]","Message1","Message2","Message3","Message4","2x 2S","DP"]
[{"$f":"IF(CTDAQC_!E2=\"*\",\"\",CTDAQC_!B2)","v":""},{"$f":"VLOOKUP($A2,CTD_stats,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($A2,CTD_stats,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($A2,CTD_stats,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($A2,CTD_stats,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($A2,CTD_stats,6,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($A2,CTD_stats,7,FALSE)","v":{"$error":"#N/A"}},{"$f":"$B2+$G2","v":{"$error":"#N/A"}},{"$f":"$D2+(3*$E2)","v":{"$error":"#N/A"}},{"$f":"$D2+(2*$E2)","v":{"$error":"#N/A"}},{"$f":"$D2-(2*$E2)","v":{"$error":"#N/A"}},{"$f":"$D2-(3*$E2)","v":{"$error":"#N/A"}},{"$f":"$B2-$G2","v":{"$error":"#N/A"}},{"$f":"CHKRES(CTDAQC_!J2,$F2,$C2,CTDAQC_!$I2,$B2,$D2,$G2,$E2)","v":""},{"$f":"CHKRES(CTDAQC_!K2,$F2,$C2,CTDAQC_!$I2,$B2,$D2,$G2,$E2)","v":""},{"$f":"CHKRES(CTDAQC_!L2,$F2,$C2,CTDAQC_!$I2,$B2,$D2,$G2,$E2)","v":""},{"$f":"CHKRES(CTDAQC_!M2,$F2,$C2,CTDAQC_!$I2,$B2,$D2,$G2,$E2)","v":""},{"$f":"IF(ISNUMBER(FIND(22,MID(N2,4,1)&MID(O2,4,1)&MID(P2,4,1)&MID(Q2,4,1))),\"2 x 2S\",\"\")","v":""},{"$f":"IF(Instr1!$E$9=\"Optical DO\",2,1)","v":1}]
[{"$f":"IF(CTDAQC_!E3=\"*\",\"\",CTDAQC_!B3)","v":""},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"CHKRES(CTDAQC_!J3,$F3,$C3,CTDAQC_!$I3,$B3,$D3,$G3,$E3)","v":""},{"$f":"CHKRES(CTDAQC_!K3,$F3,$C3,CTDAQC_!$I3,$B3,$D3,$G3,$E3)","v":""},{"$f":"CHKRES(CTDAQC_!L3,$F3,$C3,CTDAQC_!$I3,$B3,$D3,$G3,$E3)","v":""},{"$f":"CHKRES(CTDAQC_!M3,$F3,$C3,CTDAQC_!$I3,$B3,$D3,$G3,$E3)","v":""},"",{"$f":"IF(Instr1!$E$9=\"Optical DO\",2,1)","v":1}]
[{"$f":"IF(CTDAQC_!E4=\"*\",\"\",CTDAQC_!B4)","v":""},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"CHKRES(CTDAQC_!J4,$F4,$C4,CTDAQC_!$I4,$B4,$D4,$G4,$E4)","v":""},{"$f":"CHKRES(CTDAQC_!K4,$F4,$C4,CTDAQC_!$I4,$B4,$D4,$G4,$E4)","v":""},{"$f":"CHKRES(CTDAQC_!L4,$F4,$C4,CTDAQC_!$I4,$B4,$D4,$G4,$E4)","v":""},{"$f":"CHKRES(CTDAQC_!M4,$F4,$C4,CTDAQC_!$I4,$B4,$D4,$G4,$E4)","v":""},"",{"$f":"IF(Instr1!$E$9=\"Optical DO\",2,4)","v":4}]
[{"$f":"IF(CTDAQC_!E5=\"*\",\"\",CTDAQC_!B5)","v":""},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"CHKRES(CTDAQC_!J5,$F5,$C5,CTDAQC_!$I5,$B5,$D5,$G5,$E5)","v":""},{"$f":"CHKRES(CTDAQC_!K5,$F5,$C5,CTDAQC_!$I5,$B5,$D5,$G5,$E5)","v":""},{"$f":"CHKRES(CTDAQC_!L5,$F5,$C5,CTDAQC_!$I5,$B5,$D5,$G5,$E5)","v":""},{"$f":"CHKRES(CTDAQC_!M5,$F5,$C5,CTDAQC_!$I5,$B5,$D5,$G5,$E5)","v":""},{"$f":"IF(ISNUMBER(FIND(22,MID(N5,4,1)&MID(O5,4,1)&MID(P5,4,1)&MID(Q5,4,1))),\"2 x 2S\",\"\")","v":""},2]
[{"$f":"IF(CTDAQC_!E6=\"*\",\"\",CTDAQC_!B6)","v":""},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"CHKRES(CTDAQC_!J6,$F6,$C6,CTDAQC_!$I6,$B6,$D6,$G6,$E6)","v":""},{"$f":"CHKRES(CTDAQC_!K6,$F6,$C6,CTDAQC_!$I6,$B6,$D6,$G6,$E6)","v":""},{"$f":"CHKRES(CTDAQC_!L6,$F6,$C6,CTDAQC_!$I6,$B6,$D6,$G6,$E6)","v":""},{"$f":"CHKRES(CTDAQC_!M6,$F6,$C6,CTDAQC_!$I6,$B6,$D6,$G6,$E6)","v":""},"",3]
[{"$f":"IF(CTDAQC_!E7=\"*\",\"\",CTDAQC_!B7)","v":""},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"CHKRES(CTDAQC_!J7,$F7,$C7,CTDAQC_!$I7,$B7,$D7,$G7,$E7)","v":""},{"$f":"CHKRES(CTDAQC_!K7,$F7,$C7,CTDAQC_!$I7,$B7,$D7,$G7,$E7)","v":""},{"$f":"CHKRES(CTDAQC_!L7,$F7,$C7,CTDAQC_!$I7,$B7,$D7,$G7,$E7)","v":""},{"$f":"CHKRES(CTDAQC_!M7,$F7,$C7,CTDAQC_!$I7,$B7,$D7,$G7,$E7)","v":""},"",3]
[{"$f":"IF(CTDAQC_!E8=\"*\",\"\",CTDAQC_!B8)","v":""},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"CHKRES(CTDAQC_!J8,$F8,$C8,CTDAQC_!$I8,$B8,$D8,$G8,$E8)","v":""},{"$f":"CHKRES(CTDAQC_!K8,$F8,$C8,CTDAQC_!$I8,$B8,$D8,$G8,$E8)","v":""},{"$f":"CHKRES(CTDAQC_!L8,$F8,$C8,CTDAQC_!$I8,$B8,$D8,$G8,$E8)","v":""},{"$f":"CHKRES(CTDAQC_!M8,$F8,$C8,CTDAQC_!$I8,$B8,$D8,$G8,$E8)","v":""},{"$f":"IF(ISNUMBER(FIND(22,MID(N8,4,1)&MID(O8,4,1)&MID(P8,4,1)&MID(Q8,4,1))),\"2 x 2S\",\"\")","v":""},0]
[{"$f":"IF(CTDAQC_!E9=\"*\",\"\",CTDAQC_!B9)","v":""},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"CHKRES(CTDAQC_!J9,$F9,$C9,CTDAQC_!$I9,$B9,$D9,$G9,$E9)","v":""},{"$f":"CHKRES(CTDAQC_!K9,$F9,$C9,CTDAQC_!$I9,$B9,$D9,$G9,$E9)","v":""},{"$f":"CHKRES(CTDAQC_!L9,$F9,$C9,CTDAQC_!$I9,$B9,$D9,$G9,$E9)","v":""},{"$f":"CHKRES(CTDAQC_!M9,$F9,$C9,CTDAQC_!$I9,$B9,$D9,$G9,$E9)","v":""},{"$f":"IF(ISNUMBER(FIND(22,MID(N9,4,1)&MID(O9,4,1)&MID(P9,4,1)&MID(Q9,4,1))),\"2 x 2S\",\"\")","v":""},0]
[{"$f":"IF(CTDAQC_!E10=\"*\",\"\",CTDAQC_!B10)","v":""},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"CHKRES(CTDAQC_!J10,$F10,$C10,CTDAQC_!$I10,$B10,$D10,$G10,$E10)","v":""},{"$f":"CHKRES(CTDAQC_!K10,$F10,$C10,CTDAQC_!$I10,$B10,$D10,$G10,$E10)","v":""},{"$f":"CHKRES(CTDAQC_!L10,$F10,$C10,CTDAQC_!$I10,$B10,$D10,$G10,$E10)","v":""},{"$f":"CHKRES(CTDAQC_!M10,$F10,$C10,CTDAQC_!$I10,$B10,$D10,$G10,$E10)","v":""},{"$f":"IF(ISNUMBER(FIND(22,MID(N10,4,1)&MID(O10,4,1)&MID(P10,4,1)&MID(Q10,4,1))),\"2 x 2S\",\"\")","v":""},1]
[{"$f":"IF(CTDAQC_!E11=\"*\",\"\",CTDAQC_!B11)","v":""},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"CHKRES(CTDAQC_!J11,$F11,$C11,CTDAQC_!$I11,$B11,$D11,$G11,$E11)","v":""},{"$f":"CHKRES(CTDAQC_!K11,$F11,$C11,CTDAQC_!$I11,$B11,$D11,$G11,$E11)","v":""},{"$f":"CHKRES(CTDAQC_!L11,$F11,$C11,CTDAQC_!$I11,$B11,$D11,$G11,$E11)","v":""},{"$f":"CHKRES(CTDAQC_!M11,$F11,$C11,CTDAQC_!$I11,$B11,$D11,$G11,$E11)","v":""},"",{"$f":"IF(Instr2!$E$9=\"Optical DO\",2,1)","v":1}]
[{"$f":"IF(CTDAQC_!E12=\"*\",\"\",CTDAQC_!B12)","v":""},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"CHKRES(CTDAQC_!J12,$F12,$C12,CTDAQC_!$I12,$B12,$D12,$G12,$E12)","v":""},{"$f":"CHKRES(CTDAQC_!K12,$F12,$C12,CTDAQC_!$I12,$B12,$D12,$G12,$E12)","v":""},{"$f":"CHKRES(CTDAQC_!L12,$F12,$C12,CTDAQC_!$I12,$B12,$D12,$G12,$E12)","v":""},{"$f":"CHKRES(CTDAQC_!M12,$F12,$C12,CTDAQC_!$I12,$B12,$D12,$G12,$E12)","v":""},"",{"$f":"IF(Instr2!$E$9=\"Optical DO\",2,1)","v":1}]
[{"$f":"IF(CTDAQC_!E13=\"*\",\"\",CTDAQC_!B13)","v":""},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"CHKRES(CTDAQC_!J13,$F13,$C13,CTDAQC_!$I13,$B13,$D13,$G13,$E13)","v":""},{"$f":"CHKRES(CTDAQC_!K13,$F13,$C13,CTDAQC_!$I13,$B13,$D13,$G13,$E13)","v":""},{"$f":"CHKRES(CTDAQC_!L13,$F13,$C13,CTDAQC_!$I13,$B13,$D13,$G13,$E13)","v":""},{"$f":"CHKRES(CTDAQC_!M13,$F13,$C13,CTDAQC_!$I13,$B13,$D13,$G13,$E13)","v":""},"",{"$f":"IF(Instr2!$E$9=\"Optical DO\",2,4)","v":4}]
[{"$f":"IF(CTDAQC_!E14=\"*\",\"\",CTDAQC_!B14)","v":""},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"CHKRES(CTDAQC_!J14,$F14,$C14,CTDAQC_!$I14,$B14,$D14,$G14,$E14)","v":""},{"$f":"CHKRES(CTDAQC_!K14,$F14,$C14,CTDAQC_!$I14,$B14,$D14,$G14,$E14)","v":""},{"$f":"CHKRES(CTDAQC_!L14,$F14,$C14,CTDAQC_!$I14,$B14,$D14,$G14,$E14)","v":""},{"$f":"CHKRES(CTDAQC_!M14,$F14,$C14,CTDAQC_!$I14,$B14,$D14,$G14,$E14)","v":""},{"$f":"IF(ISNUMBER(FIND(22,MID(N14,4,1)&MID(O14,4,1)&MID(P14,4,1)&MID(Q14,4,1))),\"2 x 2S\",\"\")","v":""},2]
[{"$f":"IF(CTDAQC_!E15=\"*\",\"\",CTDAQC_!B15)","v":""},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"CHKRES(CTDAQC_!J15,$F15,$C15,CTDAQC_!$I15,$B15,$D15,$G15,$E15)","v":""},{"$f":"CHKRES(CTDAQC_!K15,$F15,$C15,CTDAQC_!$I15,$B15,$D15,$G15,$E15)","v":""},{"$f":"CHKRES(CTDAQC_!L15,$F15,$C15,CTDAQC_!$I15,$B15,$D15,$G15,$E15)","v":""},{"$f":"CHKRES(CTDAQC_!M15,$F15,$C15,CTDAQC_!$I15,$B15,$D15,$G15,$E15)","v":""},"",3]
[{"$f":"IF(CTDAQC_!E16=\"*\",\"\",CTDAQC_!B16)","v":""},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"CHKRES(CTDAQC_!J16,$F16,$C16,CTDAQC_!$I16,$B16,$D16,$G16,$E16)","v":""},{"$f":"CHKRES(CTDAQC_!K16,$F16,$C16,CTDAQC_!$I16,$B16,$D16,$G16,$E16)","v":""},{"$f":"CHKRES(CTDAQC_!L16,$F16,$C16,CTDAQC_!$I16,$B16,$D16,$G16,$E16)","v":""},{"$f":"CHKRES(CTDAQC_!M16,$F16,$C16,CTDAQC_!$I16,$B16,$D16,$G16,$E16)","v":""},"",3]
[{"$f":"IF(CTDAQC_!E17=\"*\",\"\",CTDAQC_!B17)","v":""},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"CHKRES(CTDAQC_!J17,$F17,$C17,CTDAQC_!$I17,$B17,$D17,$G17,$E17)","v":""},{"$f":"CHKRES(CTDAQC_!K17,$F17,$C17,CTDAQC_!$I17,$B17,$D17,$G17,$E17)","v":""},{"$f":"CHKRES(CTDAQC_!L17,$F17,$C17,CTDAQC_!$I17,$B17,$D17,$G17,$E17)","v":""},{"$f":"CHKRES(CTDAQC_!M17,$F17,$C17,CTDAQC_!$I17,$B17,$D17,$G17,$E17)","v":""},{"$f":"IF(ISNUMBER(FIND(22,MID(N17,4,1)&MID(O17,4,1)&MID(P17,4,1)&MID(Q17,4,1))),\"2 x 2S\",\"\")","v":""},0]
[{"$f":"IF(CTDAQC_!E18=\"*\",\"\",CTDAQC_!B18)","v":""},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"CHKRES(CTDAQC_!J18,$F18,$C18,CTDAQC_!$I18,$B18,$D18,$G18,$E18)","v":""},{"$f":"CHKRES(CTDAQC_!K18,$F18,$C18,CTDAQC_!$I18,$B18,$D18,$G18,$E18)","v":""},{"$f":"CHKRES(CTDAQC_!L18,$F18,$C18,CTDAQC_!$I18,$B18,$D18,$G18,$E18)","v":""},{"$f":"CHKRES(CTDAQC_!M18,$F18,$C18,CTDAQC_!$I18,$B18,$D18,$G18,$E18)","v":""},{"$f":"IF(ISNUMBER(FIND(22,MID(N18,4,1)&MID(O18,4,1)&MID(P18,4,1)&MID(Q18,4,1))),\"2 x 2S\",\"\")","v":""},0]
[{"$f":"IF(CTDAQC_!E19=\"*\",\"\",CTDAQC_!B19)","v":""},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"CHKRES(CTDAQC_!J19,$F19,$C19,CTDAQC_!$I19,$B19,$D19,$G19,$E19)","v":""},{"$f":"CHKRES(CTDAQC_!K19,$F19,$C19,CTDAQC_!$I19,$B19,$D19,$G19,$E19)","v":""},{"$f":"CHKRES(CTDAQC_!L19,$F19,$C19,CTDAQC_!$I19,$B19,$D19,$G19,$E19)","v":""},{"$f":"CHKRES(CTDAQC_!M19,$F19,$C19,CTDAQC_!$I19,$B19,$D19,$G19,$E19)","v":""},{"$f":"IF(ISNUMBER(FIND(22,MID(N19,4,1)&MID(O19,4,1)&MID(P19,4,1)&MID(Q19,4,1))),\"2 x 2S\",\"\")","v":""},1]
[{"$f":"IF(CTDAQC_!E20=\"*\",\"\",CTDAQC_!B20)","v":""},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"CHKRES(CTDAQC_!J20,$F20,$C20,CTDAQC_!$I20,$B20,$D20,$G20,$E20)","v":""},{"$f":"CHKRES(CTDAQC_!K20,$F20,$C20,CTDAQC_!$I20,$B20,$D20,$G20,$E20)","v":""},{"$f":"CHKRES(CTDAQC_!L20,$F20,$C20,CTDAQC_!$I20,$B20,$D20,$G20,$E20)","v":""},{"$f":"CHKRES(CTDAQC_!M20,$F20,$C20,CTDAQC_!$I20,$B20,$D20,$G20,$E20)","v":""},"",{"$f":"IF(Instr3!$E$9=\"Optical DO\",2,1)","v":1}]
[{"$f":"IF(CTDAQC_!E21=\"*\",\"\",CTDAQC_!B21)","v":""},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"CHKRES(CTDAQC_!J21,$F21,$C21,CTDAQC_!$I21,$B21,$D21,$G21,$E21)","v":""},{"$f":"CHKRES(CTDAQC_!K21,$F21,$C21,CTDAQC_!$I21,$B21,$D21,$G21,$E21)","v":""},{"$f":"CHKRES(CTDAQC_!L21,$F21,$C21,CTDAQC_!$I21,$B21,$D21,$G21,$E21)","v":""},{"$f":"CHKRES(CTDAQC_!M21,$F21,$C21,CTDAQC_!$I21,$B21,$D21,$G21,$E21)","v":""},"",{"$f":"IF(Instr3!$E$9=\"Optical DO\",2,1)","v":1}]
[{"$f":"IF(CTDAQC_!E22=\"*\",\"\",CTDAQC_!B22)","v":""},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"CHKRES(CTDAQC_!J22,$F22,$C22,CTDAQC_!$I22,$B22,$D22,$G22,$E22)","v":""},{"$f":"CHKRES(CTDAQC_!K22,$F22,$C22,CTDAQC_!$I22,$B22,$D22,$G22,$E22)","v":""},{"$f":"CHKRES(CTDAQC_!L22,$F22,$C22,CTDAQC_!$I22,$B22,$D22,$G22,$E22)","v":""},{"$f":"CHKRES(CTDAQC_!M22,$F22,$C22,CTDAQC_!$I22,$B22,$D22,$G22,$E22)","v":""},"",{"$f":"IF(Instr3!$E$9=\"Optical DO\",2,4)","v":4}]
[{"$f":"IF(CTDAQC_!E23=\"*\",\"\",CTDAQC_!B23)","v":""},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"CHKRES(CTDAQC_!J23,$F23,$C23,CTDAQC_!$I23,$B23,$D23,$G23,$E23)","v":""},{"$f":"CHKRES(CTDAQC_!K23,$F23,$C23,CTDAQC_!$I23,$B23,$D23,$G23,$E23)","v":""},{"$f":"CHKRES(CTDAQC_!L23,$F23,$C23,CTDAQC_!$I23,$B23,$D23,$G23,$E23)","v":""},{"$f":"CHKRES(CTDAQC_!M23,$F23,$C23,CTDAQC_!$I23,$B23,$D23,$G23,$E23)","v":""},{"$f":"IF(ISNUMBER(FIND(22,MID(N23,4,1)&MID(O23,4,1)&MID(P23,4,1)&MID(Q23,4,1))),\"2 x 2S\",\"\")","v":""},2]
[{"$f":"IF(CTDAQC_!E24=\"*\",\"\",CTDAQC_!B24)","v":""},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"CHKRES(CTDAQC_!J24,$F24,$C24,CTDAQC_!$I24,$B24,$D24,$G24,$E24)","v":""},{"$f":"CHKRES(CTDAQC_!K24,$F24,$C24,CTDAQC_!$I24,$B24,$D24,$G24,$E24)","v":""},{"$f":"CHKRES(CTDAQC_!L24,$F24,$C24,CTDAQC_!$I24,$B24,$D24,$G24,$E24)","v":""},{"$f":"CHKRES(CTDAQC_!M24,$F24,$C24,CTDAQC_!$I24,$B24,$D24,$G24,$E24)","v":""},"",3]
[{"$f":"IF(CTDAQC_!E25=\"*\",\"\",CTDAQC_!B25)","v":""},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"CHKRES(CTDAQC_!J25,$F25,$C25,CTDAQC_!$I25,$B25,$D25,$G25,$E25)","v":""},{"$f":"CHKRES(CTDAQC_!K25,$F25,$C25,CTDAQC_!$I25,$B25,$D25,$G25,$E25)","v":""},{"$f":"CHKRES(CTDAQC_!L25,$F25,$C25,CTDAQC_!$I25,$B25,$D25,$G25,$E25)","v":""},{"$f":"CHKRES(CTDAQC_!M25,$F25,$C25,CTDAQC_!$I25,$B25,$D25,$G25,$E25)","v":""},"",3]

{"sheet":"CTDAQC_","index":9,"n_rows":25,"n_cols":17,"rows_kept":25,"cut":false,"hidden":true,"merged":[]}
["Batch","AQC_ID","Date","UTC","Probe","Add_Sensor","Det","AQC_Type","Nom_Value","Result 1","Result 2","Result 3","Result 4","Lab","Analyst","Include","Excuse"]
[{"$f":"Instr1!T$2","v":"NOT AVAILABLE"},{"$f":"E2&G2&H2","v":"*DOXAQC-Blan"},{"$f":"IF(ISBLANK(Instr1!B$7),\"*\",Instr1!B$7)","v":"*"},{"$f":"IF(ISBLANK(Instr1!C$7),\"*\",Instr1!C$7)","v":"*"},{"$f":"IF(Instr1!B$2=\"\",\"*\",IF(H2=\"\",\"*\",Instr1!B$2))","v":"*"},{"$f":"IF(ISTEXT(Instr1!$E$9),IF(Instr1!$E$9=\"Optical DO\",IF(Instr1!$F$9=\"Enter cap # on 'Info'\",\"*\",Instr1!$F$9),Instr1!$E$9),\"*\")","v":"*"},"DOX","AQC-Blan",0,{"$f":"IF(ISNUMBER(Instr1!E$7),Instr1!E$7,\"*\")","v":"*"},{"$f":"IF(ISNUMBER(Instr1!L$7),Instr1!L$7,\"*\")","v":"*"},"*","*",{"$f":"IF(ISTEXT(SurveyLog!$F$5),SurveyLog!$F$5,\"*\")","v":"HG"},{"$f":"IF(ISTEXT(Instr1!$H$2),Instr1!$H$2,\"*\")","v":"*"},{"$f":"IF(COUNT(J2:M2)=0,\"*\",IF(Instr1!$S$7=\"Y\",\"!\",IF(Instr1!$S$7=\"N\",\"Z\",0)))","v":"*"},{"$f":"IF(ISTEXT(Instr1!T$7),Instr1!T$7,\"*\")","v":"*"}]
[{"$f":"Instr1!T$2","v":"NOT AVAILABLE"},"*DOXAQC-High",{"$f":"IF($J4=\"*\",IF(ISBLANK(Instr1!B$10),\"*\",Instr1!B$10),IF(ISBLANK(Instr1!I$10),\"*\",Instr1!I$10))","v":"*"},{"$f":"IF($J4=\"*\",IF(ISBLANK(Instr1!C$10),\"*\",Instr1!C$10),IF(ISBLANK(Instr1!J$10),\"*\",Instr1!J$10))","v":"*"},{"$f":"IF(Instr1!B$2=\"\",\"*\",IF(H3=\"\",\"*\",Instr1!B$2))","v":"*"},{"$f":"IF(ISTEXT(Instr1!$E$9),IF(Instr1!$E$9=\"Optical DO\",IF(Instr1!$F$9=\"Enter cap # on 'Info'\",\"*\",Instr1!$F$9),Instr1!$E$9),\"*\")","v":"*"},"DOX","AQC-High",100,{"$f":"IF($J4=\"*\",IF(ISNUMBER(Instr1!E$10),Instr1!E$10,\"*\"),IF(ISNUMBER(Instr1!$L$10),Instr1!$L$10,\"*\"))","v":"*"},{"$f":"IF($J4=\"*\",IF(ISNUMBER(Instr1!$L$10),Instr1!$L$10,\"*\"),IF(ISNUMBER(Instr1!$L$11),Instr1!$L$11,\"*\"))","v":"*"},{"$f":"IF($J4=\"*\",IF(ISNUMBER(Instr1!$L$11),Instr1!$L$11,\"*\"),IF(ISNUMBER(Instr1!$L$12),Instr1!$L$12,\"*\"))","v":"*"},{"$f":"IF($J4=\"*\",IF(ISNUMBER(Instr1!$L$12),Instr1!$L$12,\"*\"),\"*\")","v":"*"},{"$f":"IF(ISTEXT(SurveyLog!$F$5),SurveyLog!$F$5,\"*\")","v":"HG"},{"$f":"IF(ISTEXT(Instr1!$H$2),Instr1!$H$2,\"*\")","v":"*"},{"$f":"IF(COUNT(J3:M3)=0,\"*\",IF(Instr1!$S$7=\"Y\",\"!\",IF(Instr1!$S$7=\"N\",\"Z\",0)))","v":"*"},{"$f":"IF(ISTEXT(Instr1!T$7),Instr1!T$7,\"*\")","v":"*"}]
[{"$f":"Instr1!T$2","v":"NOT AVAILABLE"},"*DOXAQC-Diff",{"$f":"IF(ISBLANK(Instr1!B$10),\"*\",Instr1!B$10)","v":"*"},{"$f":"IF(ISBLANK(Instr1!C$10),\"*\",Instr1!C$10)","v":"*"},{"$f":"IF(Instr1!B$2=\"\",\"*\",IF(H4=\"\",\"*\",Instr1!B$2))","v":"*"},{"$f":"IF(ISTEXT(Instr1!$E$9),IF(Instr1!$E$9=\"Optical DO\",IF(Instr1!$F$9=\"Enter cap # on 'Info'\",\"*\",Instr1!$F$9),Instr1!$E$9),\"*\")","v":"*"},"DOX",{"$f":"IF(Instr1!$E$9=\"Optical DO\",\"AQC-OOSi\",\"AQC-Diff\")","v":"AQC-Diff"},{"$f":"IF(Instr1!$E$9=\"Optical DO\",450,\"*\")","v":"*"},{"$f":"IF(ISNUMBER(Instr1!E$11),Instr1!E$11,\"*\")","v":"*"},"*","*","*",{"$f":"IF(ISTEXT(SurveyLog!$F$5),SurveyLog!$F$5,\"*\")","v":"HG"},{"$f":"IF(ISTEXT(Instr1!$H$2),Instr1!$H$2,\"*\")","v":"*"},{"$f":"IF(COUNT(J4:M4)=0,\"*\",IF(Instr1!$S$7=\"Y\",\"!\",IF(Instr1!$S$7=\"N\",\"Z\",0)))","v":"*"},{"$f":"IF(ISTEXT(Instr1!T$7),Instr1!T$7,\"*\")","v":"*"}]
[{"$f":"Instr1!T$2","v":"NOT AVAILABLE"},{"$f":"E5&G5&H5","v":"*DOXAQC-OOAm"},{"$f":"IF(ISBLANK(Instr1!B$10),\"*\",Instr1!B$10)","v":"*"},{"$f":"IF(ISBLANK(Instr1!C$10),\"*\",Instr1!C$10)","v":"*"},{"$f":"IF(Instr1!B$2=\"\",\"*\",IF(H5=\"\",\"*\",Instr1!B$2))","v":"*"},{"$f":"IF(ISTEXT(Instr1!$E$9),IF(Instr1!$E$9=\"Optical DO\",IF(Instr1!$F$9=\"Enter cap # on 'Info'\",\"*\",Instr1!$F$9),Instr1!$E$9),\"*\")","v":"*"},"DOX","AQC-OOAm",0,{"$f":"IF(Instr1!$E$9=\"Optical DO\",IF(ISNUMBER(Instr1!E$12),Instr1!E$12,\"*\"),\"*\")","v":"*"},"*","*","*",{"$f":"IF(ISTEXT(SurveyLog!$F$5),SurveyLog!$F$5,\"*\")","v":"HG"},{"$f":"IF(ISTEXT(Instr1!$H$2),Instr1!$H$2,\"*\")","v":"*"},{"$f":"IF(COUNT(J5:M5)=0,\"*\",IF(Instr1!$S$7=\"Y\",\"!\",IF(Instr1!$S$7=\"N\",\"Z\",0)))","v":"*"},{"$f":"IF(ISTEXT(Instr1!T$7),Instr1!T$7,\"*\")","v":"*"}]
[{"$f":"Instr1!T$2","v":"NOT AVAILABLE"},"*SALAQC-High",{"$f":"IF(ISBLANK(Instr1!B$15),\"*\",Instr1!B$15)","v":"*"},{"$f":"IF(ISBLANK(Instr1!C$15),\"*\",Instr1!C$15)","v":"*"},{"$f":"IF(Instr1!B$2=\"\",\"*\",IF(H6=\"\",\"*\",Instr1!B$2))","v":"*"},"*","SAL","AQC-High",{"$f":"IF(ISNUMBER(Instr1!F$15),Instr1!F$15,\"*\")","v":"*"},{"$f":"IF(ISNUMBER(Instr1!E$15),Instr1!E$15,\"*\")","v":"*"},{"$f":"IF(ISNUMBER(Instr1!L$15),Instr1!L$15,\"*\")","v":"*"},{"$f":"IF(ISNUMBER(Instr1!L$16),Instr1!L$16,\"*\")","v":"*"},"*",{"$f":"IF(ISTEXT(SurveyLog!$F$5),SurveyLog!$F$5,\"*\")","v":"HG"},{"$f":"IF(ISTEXT(Instr1!$H$2),Instr1!$H$2,\"*\")","v":"*"},{"$f":"IF(COUNT(J6:M6)=0,\"*\",IF(Instr1!$S$15=\"Y\",\"!\",IF(Instr1!$S$15=\"N\",\"Z\",0)))","v":"*"},{"$f":"IF(ISTEXT(Instr1!T$15),Instr1!T$15,\"*\")","v":"*"}]
[{"$f":"Instr1!T$2","v":"NOT AVAILABLE"},"*PH_AQC-",{"$f":"IF(ISBLANK(Instr1!B$19),\"*\",Instr1!B$19)","v":"*"},{"$f":"IF(ISBLANK(Instr1!C$19),\"*\",Instr1!C$19)","v":"*"},{"$f":"IF(Instr1!B$2=\"\",\"*\",IF(H7=\"\",\"*\",Instr1!B$2))","v":"*"},"*","PH_",{"$f":"SUBSTITUTE(\"AQC-\"&Instr1!$F$18,\" \",\"\")","v":"AQC-"},{"$f":"IF(ISNUMBER(Instr1!F$19),0,\"*\")","v":"*"},{"$f":"IF(ISNUMBER(Instr1!G$19),Instr1!G$19,\"*\")","v":"*"},{"$f":"IF(ISNUMBER(Instr1!N$19),Instr1!N$19,\"*\")","v":"*"},{"$f":"IF(ISNUMBER(Instr1!N$20),Instr1!N$20,\"*\")","v":"*"},"*",{"$f":"IF(ISTEXT(SurveyLog!$F$5),SurveyLog!$F$5,\"*\")","v":"HG"},{"$f":"IF(ISTEXT(Instr1!$H$2),Instr1!$H$2,\"*\")","v":"*"},{"$f":"IF(COUNT(J7:M7)=0,\"*\",IF(Instr1!$S$19=\"Y\",\"!\",IF(Instr1!$S$19=\"N\",\"Z\",0)))","v":"*"},{"$f":"IF(ISTEXT(Instr1!T$19),Instr1!T$19,\"*\")","v":"*"}]
[{"$f":"Instr1!T$2","v":"NOT AVAILABLE"},{"$f":"E8&G8&H8","v":"*TB_AQC-T0*"},{"$f":"IF(ISBLANK(Instr1!B$22),\"*\",Instr1!B$22)","v":"*"},{"$f":"IF(ISBLANK(Instr1!C$22),\"*\",Instr1!C$22)","v":"*"},{"$f":"IF(Instr1!B$2=\"\",\"*\",IF(H8=\"\",\"*\",Instr1!B$2))","v":"*"},{"$f":"IF(ISTEXT(Instr1!$E$21),Instr1!$E$21,\"*\")","v":"*"},"TB_",{"$f":"\"AQC-T0\"&RIGHT(F8,2)","v":"AQC-T0*"},{"$f":"IF(ISNUMBER(Instr1!F$23),Instr1!F23,\"*\")","v":"*"},{"$f":"IF(ISNUMBER(Instr1!E$23),Instr1!E$23,\"*\")","v":"*"},{"$f":"IF(ISNUMBER(Instr1!L$23),Instr1!L$23,\"*\")","v":"*"},"*","*",{"$f":"IF(ISTEXT(SurveyLog!$F$5),SurveyLog!$F$5,\"*\")","v":"HG"},{"$f":"IF(ISTEXT(Instr1!$H$2),Instr1!$H$2,\"*\")","v":"*"},{"$f":"IF(COUNT(J8:M8)=0,\"*\",IF(Instr1!$S$23=\"Y\",\"!\",IF(Instr1!$S$23=\"N\",\"Z\",0)))","v":"*"},{"$f":"IF(ISTEXT(Instr1!T$23),Instr1!T$23,\"*\")","v":"*"}]
[{"$f":"Instr1!T$2","v":"NOT AVAILABLE"},{"$f":"E9&G9&H9","v":"*TB_AQC-T1*"},{"$f":"IF(ISBLANK(Instr1!B$22),\"*\",Instr1!B$22)","v":"*"},{"$f":"IF(ISBLANK(Instr1!C$22),\"*\",Instr1!C$22)","v":"*"},{"$f":"IF(Instr1!B$2=\"\",\"*\",IF(H9=\"\",\"*\",Instr1!B$2))","v":"*"},{"$f":"IF(ISTEXT(Instr1!$E$21),Instr1!$E$21,\"*\")","v":"*"},"TB_",{"$f":"\"AQC-T1\"&RIGHT(F9,2)","v":"AQC-T1*"},{"$f":"IF(ISNUMBER(Instr1!F$24),Instr1!F24,\"*\")","v":"*"},{"$f":"IF(ISNUMBER(Instr1!E$24),Instr1!E$24,\"*\")","v":"*"},{"$f":"IF(ISNUMBER(Instr1!L$24),Instr1!L$24,\"*\")","v":"*"},"*","*",{"$f":"IF(ISTEXT(SurveyLog!$F$5),SurveyLog!$F$5,\"*\")","v":"HG"},{"$f":"IF(ISTEXT(Instr1!$H$2),Instr1!$H$2,\"*\")","v":"*"},{"$f":"IF(COUNT(J9:M9)=0,\"*\",IF(Instr1!$S$23=\"Y\",\"!\",IF(Instr1!$S$23=\"N\",\"Z\",0)))","v":"*"},{"$f":"IF(ISTEXT(Instr1!T$23),Instr1!T$23,\"*\")","v":"*"}]
[{"$f":"Instr1!T$2","v":"NOT AVAILABLE"},{"$f":"E10&G10&H10","v":"*TB_AQC-Blan"},{"$f":"IF(ISBLANK(Instr1!B$22),\"*\",Instr1!B$22)","v":"*"},{"$f":"IF(ISBLANK(Instr1!C$22),\"*\",Instr1!C$22)","v":"*"},{"$f":"IF(Instr1!B$2=\"\",\"*\",IF(H10=\"\",\"*\",Instr1!B$2))","v":"*"},"*","TB_","AQC-Blan",0,{"$f":"IF(ISNUMBER(Instr1!E$26),Instr1!E$26,\"*\")","v":"*"},{"$f":"IF(ISNUMBER(Instr1!L$26),Instr1!L$26,\"*\")","v":"*"},"*","*",{"$f":"IF(ISTEXT(SurveyLog!$F$5),SurveyLog!$F$5,\"*\")","v":"HG"},{"$f":"IF(ISTEXT(Instr1!$H$2),Instr1!$H$2,\"*\")","v":"*"},{"$f":"IF(COUNT(J10:M10)=0,\"*\",IF(Instr1!$S$23=\"Y\",\"!\",IF(Instr1!$S$23=\"N\",\"Z\",0)))","v":"*"},{"$f":"IF(ISTEXT(Instr1!T$23),Instr1!T$23,\"*\")","v":"*"}]
[{"$f":"Instr2!T$2","v":"NOT AVAILABLE"},"*DOXAQC-Blan",{"$f":"IF(ISBLANK(Instr2!B$7),\"*\",Instr2!B$7)","v":"*"},{"$f":"IF(ISBLANK(Instr2!C$7),\"*\",Instr2!C$7)","v":"*"},{"$f":"IF(Instr2!B$2=\"\",\"*\",IF(H11=\"\",\"*\",Instr2!B$2))","v":"*"},{"$f":"IF(ISTEXT(Instr2!$E$9),IF(Instr2!$E$9=\"Optical DO\",IF(Instr2!$F$9=\"Enter cap # on 'Info'\",\"*\",Instr2!$F$9),Instr2!$E$9),\"*\")","v":"*"},"DOX","AQC-Blan",0,{"$f":"IF(ISNUMBER(Instr2!E$7),Instr2!E$7,\"*\")","v":"*"},{"$f":"IF(ISNUMBER(Instr2!L$7),Instr2!L$7,\"*\")","v":"*"},"*","*",{"$f":"IF(ISTEXT(SurveyLog!$F$5),SurveyLog!$F$5,\"*\")","v":"HG"},{"$f":"IF(ISTEXT(Instr2!$H$2),Instr2!$H$2,\"*\")","v":"*"},{"$f":"IF(COUNT(J11:M11)=0,\"*\",IF(Instr2!$S$7=\"Y\",\"!\",IF(Instr2!$S$7=\"N\",\"Z\",0)))","v":"*"},{"$f":"IF(ISTEXT(Instr2!T$7),Instr2!T$7,\"*\")","v":"*"}]
[{"$f":"Instr2!T$2","v":"NOT AVAILABLE"},"*DOXAQC-High",{"$f":"IF($J13=\"*\",IF(ISBLANK(Instr2!B$10),\"*\",Instr2!B$10),IF(ISBLANK(Instr2!I$10),\"*\",Instr2!I$10))","v":"*"},{"$f":"IF($J13=\"*\",IF(ISBLANK(Instr2!C$10),\"*\",Instr2!C$10),IF(ISBLANK(Instr2!J$10),\"*\",Instr2!J$10))","v":"*"},{"$f":"IF(Instr2!B$2=\"\",\"*\",IF(H12=\"\",\"*\",Instr2!B$2))","v":"*"},{"$f":"IF(ISTEXT(Instr2!$E$9),IF(Instr2!$E$9=\"Optical DO\",IF(Instr2!$F$9=\"Enter cap # on 'Info'\",\"*\",Instr2!$F$9),Instr2!$E$9),\"*\")","v":"*"},"DOX","AQC-High",100,{"$f":"IF($J13=\"*\",IF(ISNUMBER(Instr2!E$10),Instr2!E$10,\"*\"),IF(ISNUMBER(Instr2!$L$10),Instr2!$L$10,\"*\"))","v":"*"},{"$f":"IF($J13=\"*\",IF(ISNUMBER(Instr2!$L$10),Instr2!$L$10,\"*\"),IF(ISNUMBER(Instr2!$L$11),Instr2!$L$11,\"*\"))","v":"*"},{"$f":"IF($J13=\"*\",IF(ISNUMBER(Instr2!$L$11),Instr2!$L$11,\"*\"),IF(ISNUMBER(Instr2!$L$12),Instr2!$L$12,\"*\"))","v":"*"},{"$f":"IF($J13=\"*\",IF(ISNUMBER(Instr2!$L$12),Instr2!$L$12,\"*\"),\"*\")","v":"*"},{"$f":"IF(ISTEXT(SurveyLog!$F$5),SurveyLog!$F$5,\"*\")","v":"HG"},{"$f":"IF(ISTEXT(Instr2!$H$2),Instr2!$H$2,\"*\")","v":"*"},{"$f":"IF(COUNT(J12:M12)=0,\"*\",IF(Instr2!$S$7=\"Y\",\"!\",IF(Instr2!$S$7=\"N\",\"Z\",0)))","v":"*"},{"$f":"IF(ISTEXT(Instr2!T$7),Instr2!T$7,\"*\")","v":"*"}]
[{"$f":"Instr2!T$2","v":"NOT AVAILABLE"},"*DOXAQC-Diff",{"$f":"IF(ISBLANK(Instr2!B$10),\"*\",Instr2!B$10)","v":"*"},{"$f":"IF(ISBLANK(Instr2!C$10),\"*\",Instr2!C$10)","v":"*"},{"$f":"IF(Instr2!B$2=\"\",\"*\",IF(H13=\"\",\"*\",Instr2!B$2))","v":"*"},{"$f":"IF(ISTEXT(Instr2!$E$9),IF(Instr2!$E$9=\"Optical DO\",IF(Instr2!$F$9=\"Enter cap # on 'Info'\",\"*\",Instr2!$F$9),Instr2!$E$9),\"*\")","v":"*"},"DOX",{"$f":"IF(Instr2!$E$9=\"Optical DO\",\"AQC-OOSi\",\"AQC-Diff\")","v":"AQC-Diff"},{"$f":"IF(Instr2!$E$9=\"Optical DO\",450,\"*\")","v":"*"},{"$f":"IF(ISNUMBER(Instr2!E$11),Instr2!E$11,\"*\")","v":"*"},"*","*","*",{"$f":"IF(ISTEXT(SurveyLog!$F$5),SurveyLog!$F$5,\"*\")","v":"HG"},{"$f":"IF(ISTEXT(Instr2!$H$2),Instr2!$H$2,\"*\")","v":"*"},{"$f":"IF(COUNT(J13:M13)=0,\"*\",IF(Instr2!$S$7=\"Y\",\"!\",IF(Instr2!$S$7=\"N\",\"Z\",0)))","v":"*"},{"$f":"IF(ISTEXT(Instr2!T$7),Instr2!T$7,\"*\")","v":"*"}]
[{"$f":"Instr2!T$2","v":"NOT AVAILABLE"},{"$f":"E14&G14&H14","v":"*DOXAQC-OOAm"},{"$f":"IF(ISBLANK(Instr2!B$10),\"*\",Instr2!B$10)","v":"*"},{"$f":"IF(ISBLANK(Instr2!C$10),\"*\",Instr2!C$10)","v":"*"},{"$f":"IF(Instr2!B$2=\"\",\"*\",IF(H14=\"\",\"*\",Instr2!B$2))","v":"*"},{"$f":"IF(ISTEXT(Instr2!$E$9),IF(Instr2!$E$9=\"Optical DO\",IF(Instr2!$F$9=\"Enter cap # on 'Info'\",\"*\",Instr2!$F$9),Instr2!$E$9),\"*\")","v":"*"},"DOX","AQC-OOAm",0,{"$f":"IF(Instr2!$E$9=\"Optical DO\",IF(ISNUMBER(Instr2!E$12),Instr2!E$12,\"*\"),\"*\")","v":"*"},"*","*","*",{"$f":"IF(ISTEXT(SurveyLog!$F$5),SurveyLog!$F$5,\"*\")","v":"HG"},{"$f":"IF(ISTEXT(Instr2!$H$2),Instr2!$H$2,\"*\")","v":"*"},{"$f":"IF(COUNT(J14:M14)=0,\"*\",IF(Instr2!$S$7=\"Y\",\"!\",IF(Instr2!$S$7=\"N\",\"Z\",0)))","v":"*"},{"$f":"IF(ISTEXT(Instr2!T$7),Instr2!T$7,\"*\")","v":"*"}]
[{"$f":"Instr2!T$2","v":"NOT AVAILABLE"},"*SALAQC-High",{"$f":"IF(ISBLANK(Instr2!B$15),\"*\",Instr2!B$15)","v":"*"},{"$f":"IF(ISBLANK(Instr2!C$15),\"*\",Instr2!C$15)","v":"*"},{"$f":"IF(Instr2!B$2=\"\",\"*\",IF(H15=\"\",\"*\",Instr2!B$2))","v":"*"},"*","SAL","AQC-High",{"$f":"IF(ISNUMBER(Instr2!F$15),Instr2!F$15,\"*\")","v":"*"},{"$f":"IF(ISNUMBER(Instr2!E$15),Instr2!E$15,\"*\")","v":"*"},{"$f":"IF(ISNUMBER(Instr2!L$15),Instr2!L$15,\"*\")","v":"*"},{"$f":"IF(ISNUMBER(Instr2!L$16),Instr2!L$16,\"*\")","v":"*"},"*",{"$f":"IF(ISTEXT(SurveyLog!$F$5),SurveyLog!$F$5,\"*\")","v":"HG"},{"$f":"IF(ISTEXT(Instr2!$H$2),Instr2!$H$2,\"*\")","v":"*"},{"$f":"IF(COUNT(J15:M15)=0,\"*\",IF(Instr2!$S$15=\"Y\",\"!\",IF(Instr2!$S$15=\"N\",\"Z\",0)))","v":"*"},{"$f":"IF(ISTEXT(Instr2!T$15),Instr2!T$15,\"*\")","v":"*"}]
[{"$f":"Instr2!T$2","v":"NOT AVAILABLE"},"*PH_AQC-",{"$f":"IF(ISBLANK(Instr2!B$19),\"*\",Instr2!B$19)","v":"*"},{"$f":"IF(ISBLANK(Instr2!C$19),\"*\",Instr2!C$19)","v":"*"},{"$f":"IF(Instr2!B$2=\"\",\"*\",IF(H16=\"\",\"*\",Instr2!B$2))","v":"*"},"*","PH_",{"$f":"SUBSTITUTE(\"AQC-\"&Instr2!$F$18,\" \",\"\")","v":"AQC-"},{"$f":"IF(ISNUMBER(Instr2!F$19),0,\"*\")","v":"*"},{"$f":"IF(ISNUMBER(Instr2!G$19),Instr2!G$19,\"*\")","v":"*"},{"$f":"IF(ISNUMBER(Instr2!N$19),Instr2!N$19,\"*\")","v":"*"},{"$f":"IF(ISNUMBER(Instr2!N$20),Instr2!N$20,\"*\")","v":"*"},"*",{"$f":"IF(ISTEXT(SurveyLog!$F$5),SurveyLog!$F$5,\"*\")","v":"HG"},{"$f":"IF(ISTEXT(Instr2!$H$2),Instr2!$H$2,\"*\")","v":"*"},{"$f":"IF(COUNT(J16:M16)=0,\"*\",IF(Instr2!$S$19=\"Y\",\"!\",IF(Instr2!$S$19=\"N\",\"Z\",0)))","v":"*"},{"$f":"IF(ISTEXT(Instr2!T$19),Instr2!T$19,\"*\")","v":"*"}]
[{"$f":"Instr2!T$2","v":"NOT AVAILABLE"},{"$f":"E17&G17&H17","v":"*TB_AQC-T0*"},{"$f":"IF(ISBLANK(Instr2!B$22),\"*\",Instr2!B$22)","v":"*"},{"$f":"IF(ISBLANK(Instr2!C$22),\"*\",Instr2!C$22)","v":"*"},{"$f":"IF(Instr2!B$2=\"\",\"*\",IF(H17=\"\",\"*\",Instr2!B$2))","v":"*"},{"$f":"IF(ISTEXT(Instr2!$E$21),Instr2!$E$21,\"*\")","v":"*"},"TB_",{"$f":"\"AQC-T0\"&RIGHT(F17,2)","v":"AQC-T0*"},{"$f":"IF(ISNUMBER(Instr2!F$23),Instr2!F23,\"*\")","v":"*"},{"$f":"IF(ISNUMBER(Instr2!E$23),Instr2!E$23,\"*\")","v":"*"},{"$f":"IF(ISNUMBER(Instr2!L$23),Instr2!L$23,\"*\")","v":"*"},"*","*",{"$f":"IF(ISTEXT(SurveyLog!$F$5),SurveyLog!$F$5,\"*\")","v":"HG"},{"$f":"IF(ISTEXT(Instr2!$H$2),Instr2!$H$2,\"*\")","v":"*"},{"$f":"IF(COUNT(J17:M17)=0,\"*\",IF(Instr2!$S$23=\"Y\",\"!\",IF(Instr2!$S$23=\"N\",\"Z\",0)))","v":"*"},{"$f":"IF(ISTEXT(Instr2!T$23),Instr2!T$23,\"*\")","v":"*"}]
[{"$f":"Instr2!T$2","v":"NOT AVAILABLE"},{"$f":"E18&G18&H18","v":"*TB_AQC-T1*"},{"$f":"IF(ISBLANK(Instr2!B$22),\"*\",Instr2!B$22)","v":"*"},{"$f":"IF(ISBLANK(Instr2!C$22),\"*\",Instr2!C$22)","v":"*"},{"$f":"IF(Instr2!B$2=\"\",\"*\",IF(H18=\"\",\"*\",Instr2!B$2))","v":"*"},{"$f":"IF(ISTEXT(Instr2!$E$21),Instr2!$E$21,\"*\")","v":"*"},"TB_",{"$f":"\"AQC-T1\"&RIGHT(F18,2)","v":"AQC-T1*"},{"$f":"IF(ISNUMBER(Instr2!F$24),Instr2!F24,\"*\")","v":"*"},{"$f":"IF(ISNUMBER(Instr2!E$24),Instr2!E$24,\"*\")","v":"*"},{"$f":"IF(ISNUMBER(Instr2!L$24),Instr2!L$24,\"*\")","v":"*"},"*","*",{"$f":"IF(ISTEXT(SurveyLog!$F$5),SurveyLog!$F$5,\"*\")","v":"HG"},{"$f":"IF(ISTEXT(Instr2!$H$2),Instr2!$H$2,\"*\")","v":"*"},{"$f":"IF(COUNT(J18:M18)=0,\"*\",IF(Instr2!$S$23=\"Y\",\"!\",IF(Instr2!$S$23=\"N\",\"Z\",0)))","v":"*"},{"$f":"IF(ISTEXT(Instr2!T$23),Instr2!T$23,\"*\")","v":"*"}]
[{"$f":"Instr2!T$2","v":"NOT AVAILABLE"},{"$f":"E19&G19&H19","v":"*TB_AQC-Blan"},{"$f":"IF(ISBLANK(Instr2!B$22),\"*\",Instr2!B$22)","v":"*"},{"$f":"IF(ISBLANK(Instr2!C$22),\"*\",Instr2!C$22)","v":"*"},{"$f":"IF(Instr2!B$2=\"\",\"*\",IF(H19=\"\",\"*\",Instr2!B$2))","v":"*"},"*","TB_","AQC-Blan",0,{"$f":"IF(ISNUMBER(Instr2!E$26),Instr2!E$26,\"*\")","v":"*"},{"$f":"IF(ISNUMBER(Instr2!L$26),Instr2!L$26,\"*\")","v":"*"},"*","*",{"$f":"IF(ISTEXT(SurveyLog!$F$5),SurveyLog!$F$5,\"*\")","v":"HG"},{"$f":"IF(ISTEXT(Instr2!$H$2),Instr2!$H$2,\"*\")","v":"*"},{"$f":"IF(COUNT(J19:M19)=0,\"*\",IF(Instr2!$S$23=\"Y\",\"!\",IF(Instr2!$S$23=\"N\",\"Z\",0)))","v":"*"},{"$f":"IF(ISTEXT(Instr2!T$23),Instr2!T$23,\"*\")","v":"*"}]
[{"$f":"Instr3!T$2","v":"NOT AVAILABLE"},"*DOXAQC-Blan",{"$f":"IF(ISBLANK(Instr3!B$7),\"*\",Instr3!B$7)","v":"*"},{"$f":"IF(ISBLANK(Instr3!C$7),\"*\",Instr3!C$7)","v":"*"},{"$f":"IF(Instr3!B$2=\"\",\"*\",IF(H20=\"\",\"*\",Instr3!B$2))","v":"*"},{"$f":"IF(ISTEXT(Instr3!$E$9),IF(Instr3!$E$9=\"Optical DO\",IF(Instr3!$F$9=\"Enter cap # on 'Info'\",\"*\",Instr3!$F$9),Instr3!$E$9),\"*\")","v":"*"},"DOX","AQC-Blan",0,{"$f":"IF(ISNUMBER(Instr3!E$7),Instr3!E$7,\"*\")","v":"*"},{"$f":"IF(ISNUMBER(Instr3!L$7),Instr3!L$7,\"*\")","v":"*"},"*","*",{"$f":"IF(ISTEXT(SurveyLog!$F$5),SurveyLog!$F$5,\"*\")","v":"HG"},{"$f":"IF(ISTEXT(Instr3!$H$2),Instr3!$H$2,\"*\")","v":"*"},{"$f":"IF(COUNT(J20:M20)=0,\"*\",IF(Instr3!$S$7=\"Y\",\"!\",IF(Instr3!$S$7=\"N\",\"Z\",0)))","v":"*"},{"$f":"IF(ISTEXT(Instr3!T$7),Instr3!T$7,\"*\")","v":"*"}]
[{"$f":"Instr3!T$2","v":"NOT AVAILABLE"},"*DOXAQC-High",{"$f":"IF($J22=\"*\",IF(ISBLANK(Instr3!B$10),\"*\",Instr3!B$10),IF(ISBLANK(Instr3!I$10),\"*\",Instr3!I$10))","v":"*"},{"$f":"IF($J22=\"*\",IF(ISBLANK(Instr3!C$10),\"*\",Instr3!C$10),IF(ISBLANK(Instr3!J$10),\"*\",Instr3!J$10))","v":"*"},{"$f":"IF(Instr3!B$2=\"\",\"*\",IF(H21=\"\",\"*\",Instr3!B$2))","v":"*"},{"$f":"IF(ISTEXT(Instr3!$E$9),IF(Instr3!$E$9=\"Optical DO\",IF(Instr3!$F$9=\"Enter cap # on 'Info'\",\"*\",Instr3!$F$9),Instr3!$E$9),\"*\")","v":"*"},"DOX","AQC-High",100,{"$f":"IF($J22=\"*\",IF(ISNUMBER(Instr3!E$10),Instr3!E$10,\"*\"),IF(ISNUMBER(Instr3!$L$10),Instr3!$L$10,\"*\"))","v":"*"},{"$f":"IF($J22=\"*\",IF(ISNUMBER(Instr3!$L$10),Instr3!$L$10,\"*\"),IF(ISNUMBER(Instr3!$L$11),Instr3!$L$11,\"*\"))","v":"*"},{"$f":"IF($J22=\"*\",IF(ISNUMBER(Instr3!$L$11),Instr3!$L$11,\"*\"),IF(ISNUMBER(Instr3!$L$12),Instr3!$L$12,\"*\"))","v":"*"},{"$f":"IF($J22=\"*\",IF(ISNUMBER(Instr3!$L$12),Instr3!$L$12,\"*\"),\"*\")","v":"*"},{"$f":"IF(ISTEXT(SurveyLog!$F$5),SurveyLog!$F$5,\"*\")","v":"HG"},{"$f":"IF(ISTEXT(Instr3!$H$2),Instr3!$H$2,\"*\")","v":"*"},{"$f":"IF(COUNT(J21:M21)=0,\"*\",IF(Instr3!$S$7=\"Y\",\"!\",IF(Instr3!$S$7=\"N\",\"Z\",0)))","v":"*"},{"$f":"IF(ISTEXT(Instr3!T$7),Instr3!T$7,\"*\")","v":"*"}]
[{"$f":"Instr3!T$2","v":"NOT AVAILABLE"},"*DOXAQC-Diff",{"$f":"IF(ISBLANK(Instr3!B$10),\"*\",Instr3!B$10)","v":"*"},{"$f":"IF(ISBLANK(Instr3!C$10),\"*\",Instr3!C$10)","v":"*"},{"$f":"IF(Instr3!B$2=\"\",\"*\",IF(H22=\"\",\"*\",Instr3!B$2))","v":"*"},{"$f":"IF(ISTEXT(Instr3!$E$9),IF(Instr3!$E$9=\"Optical DO\",IF(Instr3!$F$9=\"Enter cap # on 'Info'\",\"*\",Instr3!$F$9),Instr3!$E$9),\"*\")","v":"*"},"DOX",{"$f":"IF(Instr3!$E$9=\"Optical DO\",\"AQC-OOSi\",\"AQC-Diff\")","v":"AQC-Diff"},{"$f":"(IF(Instr3!$E$9=\"Optical DO\",450,\"*\"))","v":"*"},{"$f":"IF(ISNUMBER(Instr3!E$11),Instr3!E$11,\"*\")","v":"*"},"*","*","*",{"$f":"IF(ISTEXT(SurveyLog!$F$5),SurveyLog!$F$5,\"*\")","v":"HG"},{"$f":"IF(ISTEXT(Instr3!$H$2),Instr3!$H$2,\"*\")","v":"*"},{"$f":"IF(COUNT(J22:M22)=0,\"*\",IF(Instr3!$S$7=\"Y\",\"!\",IF(Instr3!$S$7=\"N\",\"Z\",0)))","v":"*"},{"$f":"IF(ISTEXT(Instr3!T$7),Instr3!T$7,\"*\")","v":"*"}]
[{"$f":"Instr3!T$2","v":"NOT AVAILABLE"},{"$f":"E23&G23&H23","v":"*DOXAQC-OOAm"},{"$f":"IF(ISBLANK(Instr3!B$10),\"*\",Instr3!B$10)","v":"*"},{"$f":"IF(ISBLANK(Instr3!C$10),\"*\",Instr3!C$10)","v":"*"},{"$f":"IF(Instr3!B$2=\"\",\"*\",IF(H23=\"\",\"*\",Instr3!B$2))","v":"*"},{"$f":"IF(ISTEXT(Instr3!$E$9),IF(Instr3!$E$9=\"Optical DO\",IF(Instr3!$F$9=\"Enter cap # on 'Info'\",\"*\",Instr3!$F$9),Instr3!$E$9),\"*\")","v":"*"},"DOX","AQC-OOAm",0,{"$f":"IF(Instr3!$E$9=\"Optical DO\",IF(ISNUMBER(Instr3!E$12),Instr3!E$12,\"*\"),\"*\")","v":"*"},"*","*","*",{"$f":"IF(ISTEXT(SurveyLog!$F$5),SurveyLog!$F$5,\"*\")","v":"HG"},{"$f":"IF(ISTEXT(Instr3!$H$2),Instr3!$H$2,\"*\")","v":"*"},{"$f":"IF(COUNT(J23:M23)=0,\"*\",IF(Instr3!$S$7=\"Y\",\"!\",IF(Instr3!$S$7=\"N\",\"Z\",0)))","v":"*"},{"$f":"IF(ISTEXT(Instr3!T$7),Instr3!T$7,\"*\")","v":"*"}]
[{"$f":"Instr3!T$2","v":"NOT AVAILABLE"},"*SALAQC-High",{"$f":"IF(ISBLANK(Instr3!B$15),\"*\",Instr3!B$15)","v":"*"},{"$f":"IF(ISBLANK(Instr3!C$15),\"*\",Instr3!C$15)","v":"*"},{"$f":"IF(Instr3!B$2=\"\",\"*\",IF(H24=\"\",\"*\",Instr3!B$2))","v":"*"},"*","SAL","AQC-High",{"$f":"IF(ISNUMBER(Instr3!F$15),Instr3!F$15,\"*\")","v":"*"},{"$f":"IF(ISNUMBER(Instr3!E$15),Instr3!E$15,\"*\")","v":"*"},{"$f":"IF(ISNUMBER(Instr3!L$15),Instr3!L$15,\"*\")","v":"*"},{"$f":"IF(ISNUMBER(Instr3!L$16),Instr3!L$16,\"*\")","v":"*"},"*",{"$f":"IF(ISTEXT(SurveyLog!$F$5),SurveyLog!$F$5,\"*\")","v":"HG"},{"$f":"IF(ISTEXT(Instr3!$H$2),Instr3!$H$2,\"*\")","v":"*"},{"$f":"IF(COUNT(J24:M24)=0,\"*\",IF(Instr3!$S$15=\"Y\",\"!\",IF(Instr3!$S$15=\"N\",\"Z\",0)))","v":"*"},{"$f":"IF(ISTEXT(Instr3!T$15),Instr3!T$15,\"*\")","v":"*"}]
[{"$f":"Instr3!T$2","v":"NOT AVAILABLE"},"*PH_AQC-",{"$f":"IF(ISBLANK(Instr3!B$19),\"*\",Instr3!B$19)","v":"*"},{"$f":"IF(ISBLANK(Instr3!C$19),\"*\",Instr3!C$19)","v":"*"},{"$f":"IF(Instr3!B$2=\"\",\"*\",IF(H25=\"\",\"*\",Instr3!B$2))","v":"*"},"*","PH_",{"$f":"SUBSTITUTE(\"AQC-\"&Instr3!$F$18,\" \",\"\")","v":"AQC-"},{"$f":"IF(ISNUMBER(Instr3!F$19),0,\"*\")","v":"*"},{"$f":"IF(ISNUMBER(Instr3!G$19),Instr3!G$19,\"*\")","v":"*"},{"$f":"IF(ISNUMBER(Instr3!N$19),Instr3!N$19,\"*\")","v":"*"},{"$f":"IF(ISNUMBER(Instr3!N$20),Instr3!N$20,\"*\")","v":"*"},"*",{"$f":"IF(ISTEXT(SurveyLog!$F$5),SurveyLog!$F$5,\"*\")","v":"HG"},{"$f":"IF(ISTEXT(Instr3!$H$2),Instr3!$H$2,\"*\")","v":"*"},{"$f":"IF(COUNT(J25:M25)=0,\"*\",IF(Instr3!$S$19=\"Y\",\"!\",IF(Instr3!$S$19=\"N\",\"Z\",0)))","v":"*"},{"$f":"IF(ISTEXT(Instr3!T$19),Instr3!T$19,\"*\")","v":"*"}]

{"sheet":"METADATA_","index":10,"n_rows":2,"n_cols":34,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["Date","Region","Vessel name","Sampler name","Sampler ID","SurveyLog ID","Survey Log received","Survey log posit data check","Survey log in-situ data check","Comments / action","Hpro posit files logged","Raw posit files received","H/held gps posits logged","HW dets selected","Tidal data recorded","Survey title(s)","Survey activity","Instrument data required","Instr1 ID","Instr1 config","Instr1 batch","Instr2 ID","Instr2 config","Instr2 batch","Raw CTD cast count","Raw casts received","CTDAQC data received","Breach ID","Breach ID","Breach ID","Breach ID","Breach form(s) signed off","Benthic/trawl supporting data received","Notes"]
[{"$f":"IF(ISNUMBER(SurveyLog!B5),SurveyLog!B5,FALSE)","v":"2022-01-19"},{"$f":"IF(ISTEXT(SurveyLog!E7),SurveyLog!E7,FALSE)","v":"East Coast"},{"$f":"IF(ISTEXT(SurveyLog!E5),SurveyLog!E5,FALSE)","v":"Humber Guardian"},{"$f":"IF(ISTEXT(SurveyLog!G5),SurveyLog!G5,FALSE)","v":"Nick Meaton"},{"$f":"IF(ISTEXT(SurveyLog!G5),SurveyLog!I5,FALSE)","v":"NM_"},{"$f":"IF(ISTEXT(SurveyLog!AH5),SurveyLog!AH5&\"_log\",FALSE)","v":"EA 2022-0119 HG_log"},"EVALUATE","EVALUATE","EVALUATE","NULL",true,{"$f":"IF(Hpro_used=FALSE,\"N/A\",\"EVALUATE\")","v":"EVALUATE"},false,true,{"$f":"IF(HW_dets_selected=FALSE,\"N/A\",\"EVALUATE\")","v":"EVALUATE"},{"$f":"CONCATENATE(IF(ISTEXT(SurveyLog!J5),SurveyLog!J5,FALSE),IF(ISTEXT(SurveyLog!J6),\"; \"&SurveyLog!J6,\"\"),IF(ISTEXT(SurveyLog!J7),\"; \"&SurveyLog!J7,\"\"),IF(ISTEXT(SurveyLog!J8),\"; \"&SurveyLog!J8,\"\"),IF(ISTEXT(SurveyLog!J9),\"; \"&SurveyLog!J9,\"\"))","v":"Teeside Crustcacean Death Investigation"},{"$f":"CONCATENATE(IF(ISTEXT(SurveyLog!M5),SurveyLog!M5,FALSE),IF(ISTEXT(SurveyLog!M6),\"; \"&SurveyLog!M6,\"\"),IF(ISTEXT(SurveyLog!M7),\"; \"&SurveyLog!M7,\"\"),IF(ISTEXT(SurveyLog!M8),\"; \"&SurveyLog!M8,\"\"),IF(ISTEXT(SurveyLog!M9),\"; \"&SurveyLog!M9,\"\"))","v":"Fish trawling"},false,{"$f":"IF(ISTEXT(SurveyLog!P5),SurveyLog!P5,FALSE)","v":false},{"$f":"IF(ISTEXT(SurveyLog!Q5),SurveyLog!Q5,FALSE)","v":false},{"$f":"IF(ISTEXT(SurveyLog!P5),SurveyLog!R5,FALSE)","v":false},{"$f":"IF(ISTEXT(SurveyLog!P6),SurveyLog!P6,FALSE)","v":false},{"$f":"IF(ISTEXT(SurveyLog!Q6),SurveyLog!Q6,FALSE)","v":false},{"$f":"IF(ISTEXT(SurveyLog!P6),SurveyLog!R6,FALSE)","v":false},{"$f":"COUNT(IF(FREQUENCY(INDEX(SurveyLog!J12:AI4962,,MATCH(\"*cast*\",SurveyLog!J11:AI11,0)),INDEX(SurveyLog!J12:AI4962,,MATCH(\"*cast*\",SurveyLog!J11:AI11,0))),1))","v":0},{"$f":"IF(Raw_cast_count<1,\"N/A\",\"EVALUATE\")","v":"N/A"},{"$f":"IF(instr_data_reqd=TRUE,\"EVALUATE\",\"N/A\")","v":"N/A"},null,null,null,null,{"$f":"IF(COUNTA(breach_list)=0,\"N/A\",\"EVALUATE\")","v":"N/A"},"EVALUATE","NULL"]