{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["summary","Final.formatted","Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":3,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"summary","index":0,"n_rows":32,"n_cols":4,"rows_kept":32,"cut":false,"hidden":false,"merged":[[22,0,22,1],[30,0,30,1],[31,2,31,4],[26,2,26,4],[24,2,24,4],[25,2,25,4],[4,0,4,4],[8,0,8,1],[3,2,3,4],[0,0,0,1],[0,2,0,4],[1,2,1,4],[1,0,1,1],[2,0,2,1],[3,0,3,1]]}
["Summary",null,"This worksheet contains tritium sampling results for the first six months of 2016. 13 data files from two labs are compiled into a table \"Final. formatted\".  Pilgrim results are in one excel file,  the sheet \"PNPS\",  MERL results are in the remaining 12 sheets. "]
["Instructions",null,"Complete worksheet QC verifying the data in Final.formatted is accurate using the data files in the attached sheets. When complete, rename file with your initials QC and date. "]
["Sheet to be QC'd",null,"Final.formatted"]
["Raw data location",null,"..\\2016"]
["Sheets in this file"]
[1,{"$f":"IFERROR(INDEX(MID(Sheets,FIND(\"]\",Sheets)+1,255),ROW(A1),1),\"\")","v":"summary"}]
[2,{"$f":"IFERROR(INDEX(MID(Sheets,FIND(\"]\",Sheets)+1,255),ROW(A2),1),\"\")","v":"Final.formatted"}]
[3,{"$f":"IFERROR(INDEX(MID(Sheets,FIND(\"]\",Sheets)+1,255),ROW(A3),1),\"\")","v":"Sheet1"}]
["Data",null,"File suffix","Individual file links"]
[4,{"$f":"IFERROR(INDEX(MID(Sheets,FIND(\"]\",Sheets)+1,255),ROW(A4),1),\"\")","v":""},{"$f":"RIGHT(D10,19)","v":"Tritium_Results.xls"},"PNPS_Groundwater_Tritium_Results.xls"]
[5,{"$f":"IFERROR(INDEX(MID(Sheets,FIND(\"]\",Sheets)+1,255),ROW(A5),1),\"\")","v":""},{"$f":"RIGHT(D11,13)","v":"02162016.xlsx"},"H3 Batch Id 02162016.xlsx"]
[6,{"$f":"IFERROR(INDEX(MID(Sheets,FIND(\"]\",Sheets)+1,255),ROW(A6),1),\"\")","v":""},{"$f":"RIGHT(D12,13)","v":"05032016.xlsx"},"H3 Batch Id 05032016.xlsx"]
[7,{"$f":"IFERROR(INDEX(MID(Sheets,FIND(\"]\",Sheets)+1,255),ROW(A7),1),\"\")","v":""},{"$f":"RIGHT(D13,13)","v":"05122016.xlsx"},"revised H3 Batch Id 05122016.xlsx"]
[8,{"$f":"IFERROR(INDEX(MID(Sheets,FIND(\"]\",Sheets)+1,255),ROW(A8),1),\"\")","v":""},"05192016.xlsx","H3 Batch Id 05192016.xlsx"]
[9,{"$f":"IFERROR(INDEX(MID(Sheets,FIND(\"]\",Sheets)+1,255),ROW(A9),1),\"\")","v":""},"05252016.xlsx","H3 Batch Id 05252016.xlsx"]
[10,{"$f":"IFERROR(INDEX(MID(Sheets,FIND(\"]\",Sheets)+1,255),ROW(A10),1),\"\")","v":""},"06032016.xlsx","H3 Batch Id 06032016.xlsx"]
[11,{"$f":"IFERROR(INDEX(MID(Sheets,FIND(\"]\",Sheets)+1,255),ROW(A11),1),\"\")","v":""},{"$f":"RIGHT(D17,13)","v":"06102016.xlsx"},"H3 Batch Id 06102016.xlsx"]
[12,{"$f":"IFERROR(INDEX(MID(Sheets,FIND(\"]\",Sheets)+1,255),ROW(A12),1),\"\")","v":""},"06152016.xlsx","H3 Batch Id 06152016.xlsx"]
[13,{"$f":"IFERROR(INDEX(MID(Sheets,FIND(\"]\",Sheets)+1,255),ROW(A13),1),\"\")","v":""},"07282016.xlsx","H3 Batch Id 07282016.xlsx"]
[14,{"$f":"IFERROR(INDEX(MID(Sheets,FIND(\"]\",Sheets)+1,255),ROW(A14),1),\"\")","v":""},"08042016.xlsx","H3 Batch Id 08042016.xlsx"]
[15,{"$f":"IFERROR(INDEX(MID(Sheets,FIND(\"]\",Sheets)+1,255),ROW(A15),1),\"\")","v":""},"08112016.xlsx","H3 Batch Id 08112016.xlsx"]
[16,{"$f":"IFERROR(INDEX(MID(Sheets,FIND(\"]\",Sheets)+1,255),ROW(A16),1),\"\")","v":""},"08192016.xlsx","H3 Batch Id 08192016.xlsx"]
["Review notes",null,"1. Where two results are given for a well on the same date (Dup.) the higher value is used"]
[null,null,"2. Values in the sheets highlighted in yellow are samples from other power plants (here in error) and not used in the charts"]
[null,null,"3. The sample description lists the sample date in parentheses. They are organized in the table by week, so the sample should correspond to the closest week START date. there is a lag between labs, but should be compiled by week."]
[null,null,"4. Look for rounding discrepancies when the one sig figure lab results are converted in the table.0.5 does not automatically go to 1 (between 0.45-0.49 will round down). If debate, click cell in Final.format for full display of sig digits"]
[null,null,"5. Some samples have \"spike tests\" noted by MS and MSD beside the sample number (column A) on the same date. Use the value for that sample that is NOT spiked, it's usually the lowest of the three."]
[null,null,"6. PNPS column headings are not in the correct order (came that way)"]
[null,null,"7.In the MERL tables Result data is from the tritium activity column, and the well number and sample date is in the Description column.  "]
[null,null,"8. MERL lab results under 300 are displayed as <300. All PNPS are displayed as provided."]
[" Suggestions",null,"Print the Final. formatted sheet and review the worksheet data on the screen. "]
[null,null,"Verify that the correct sheets were copied into this worksheet, the filename is in A1, check that correct # of rows copied over "]

{"sheet":"Final.formatted","index":1,"n_rows":40,"n_cols":25,"rows_kept":40,"cut":false,"hidden":false,"merged":[[36,0,37,0],[38,0,39,0],[32,0,33,0],[34,0,35,0],[24,0,25,0],[26,0,27,0],[28,0,29,0],[30,0,31,0],[0,2,0,24],[0,0,1,0],[0,1,1,1],[2,0,3,0],[4,0,5,0],[6,0,7,0],[8,0,9,0],[18,0,19,0],[20,0,21,0],[22,0,23,0],[10,0,11,0],[12,0,13,0],[14,0,15,0],[16,0,17,0]]}
["Sample collected      week of","Reported by1","Tritium concentration p(Ci/L)"]
[null,null,"MW-201","MW-202S","MW-202I","MW-204 ","MW-205","MW-206","MW-207","MW-208S","MW-208I","MW-209","MW-210","MW-211","MW-212","MW-213","MW-214","MW-215","MW-216","MW-217","MW-218","MW-219","MW-220","MW-3","MW-4R"]
["2016-07-05","ENTERGY/GEL",362,510,null,null,641,"<265","<265",null,null,742,null,1340,null,null,null,1020,2800,317,3940,762,499,null,"<269"]
[null,"MDPH/MERL",384.1164877570256,"<300","","",374.14665074239525,"<300","<300","","",608.11552415108542,"",1391.0753030517426,"","","",817.70366858086152,2917.740749599157,326.761187416925,3821.1131196449292,822.68119042525393,432.84085662535068,"","<300"]
["2016-07-11","ENTERGY/GEL",null,null,null,null,null,"<345",null,null,null,null,null,1300,null,null,null,921,3300,null,3780]
[null,"MDPH/MERL","","","","","","<300","","","","","",1410.859998770301,"","","",955.03165247762456,3391.6355858801894,"",3890.9219170230585,"","","",""]
["2016-07-19","ENTERGY/GEL",null,null,null,null,null,"<310",null,null,null,null,null,1340,null,null,null,700,2200,null,3600]
[null,"MDPH/MERL","","","","","","<300","","","","","",1335.269104676245,"","","",905.25201036006501,2633.6228666737134,"",3928.3469516027658,"","","",""]
["2016-07-26","ENTERGY/GEL",null,null,null,null,null,"<309",null,null,null,null,null,1160,null,null,null,765,4120,null,3620]
[null,"MDPH/MERL","","","","","","<300","","","","","",1428.9437366360442,"","","",1029.1356445202598,4674.2405334093983,"",3983.954280690185,"","","",""]
["2016-08-03","ENTERGY/GEL",null,null,"<340","<340",null,"<334",null,"<336","<335",null,690,1060,815,"<330","<340",940,2410,null,3560,null,null,"<336"]
[null,"MDPH/MERL","","","<300",541.19293750630106,"","<300","","<300","<300","",596.51235393809668,1450.9058116590327,759.54087332715289,"<300","<300",1030.5398236432718,2833.972143117272,"",4030.9349084183518,"","","<300",""]
["2016-08-09","ENTERGY/GEL",null,null,null,null,null,"<332",null,null,null,null,null,1160,null,null,null,827,2910,null,3390]
[null,"MDPH/MERL","","","","","","<300","","","","","",1111.3832866098724,"","","",815.45759469146594,3014.1317199944783,"",3671.5820297909845,"","","",""]
["2016-08-15","ENTERGY/GEL",null,null,null,null,null,"<335",null,null,null,null,null,1200,null,null,null,860,3720,null,3030]
[null,"MDPH/MERL","","","","","","<300","","","","","",1210.4632214963208,"","","",801.46043902221811,4404.1566318794039,"",3710.9706336663717,"","","",""]
["2016-08-22","ENTERGY/GEL",null,null,null,null,null,"<340",null,null,null,null,null,1050,null,null,null,950,3960,null,3190]
[null,"MDPH/MERL","","","","","","<300","","","","","",995.38852837005834,"","","",779.51183672985735,4345.4999850348686,"",3736.9291602359322,"","","",""]
["2016-08-29","ENTERGY/GEL",null,null,null,null,null,"<332",null,null,null,null,null,1480,null,null,null,861,3620,null,3050]
[null,"MDPH/MERL","","","","","","<300","","","","","",1405.7782749371534,"","","",1061.9583262035778,4358.6508194941935,"",3741.1951931858248,"","","",""]
["2016-09-06","ENTERGY/GEL",null,null,null,null,null,"<270",null,null,null,1010,null,1350,null,null,null,1060,5430,null,2970,1180]
[null,"MDPH/MERL","","","","","","<300","","","",846.18940833535942,"",1311.3714314915514,"","","",1096.5109583618241,5755.9636048008142,"",3605.7764351177525,1279.1772451998966,"","",""]
["2016-09-12","ENTERGY/GEL",null,null,null,null,null,"<305",null,null,null,null,null,1360,null,null,null,927,4170,null,3700]
[null,"MDPH/MERL","","","","","","<300","","","","","",1396.8041121913056,"","","",1147.2953315853617,4711.8404546121392,"",4086.4756792780786,"","","",""]
["2016-09-20","ENTERGY/GEL",null,null,null,null,null,"<339",null,null,null,null,null,1500,null,null,null,900,4510,null,3630]
[null,"MDPH/MERL","","","","","","<300","","","","","",873.0554324816618,"","","",529.55657435821593,3974.2225101814142,"",3321.3202932477143,"","","",""]
["2016-09-29","ENTERGY/GEL",null,null,null,null,null,"<350",null,null,null,null,null,1190,null,null,null,657,5080,null,2580]
[null,"MDPH/MERL","","","","","","<300","","","","","",732.268771318007,"","","",584.92586592041641,5819.6038504257676,"",2453.1392455920759,"","","",""]
["2016-10-04","ENTERGY/GEL",null,null,null,null,null,"<349",null,null,null,999,null,1080,null,null,null,848,4180,null,3020,1080]
[null,"MDPH/MERL","","","","","","<300","","","",936.51540885147449,"",705.26228876534333,"","","",521.81653544515541,4156.352470959212,"",3286.7704327881324,1302.6228954678697,"","",""]
["2016-10-10","ENTERGY/GEL",null,null,null,null,null,"<348",null,null,null,null,null,1130,null,null,null,1100,4510,null,2510]
[null,"MDPH/MERL","","","","","","<300","","","","","",1250.8262338425379,"","","",1065.7706553228936,5559.6240412191337,"",3184.6156207314639,"","","",""]
["2016-11-03","ENTERGY/GEL",null,null,null,null,null,"<350",null,null,null,null,null,null,null,null,null,967,2730,null,2230]
[null,"MDPH/MERL","","","","","","<300","","","","","","","","","",827.5,3309.8848083557559,"",2641.5,"","","",""]
["2016-11-14","ENTERGY/GEL","<317",873,345,"<333",877,499,"<331","<336","<337",1060,1180,1210,631,"<269","<333",842,3480,"<330",2430,859,450,"<337","<311"]
[null,"MDPH/MERL","<300",818.7,"<300","<300",819.5,327.7,"<300","<300","<300",856.79333376365071,1008.4,1116.9000000000001,525.11667555915335,"<300","<300",1191.8712840529161,3886,626.26401912116216,2709,983.6413754324202,424.73666326877338,"<300","<300"]
["2016-12-07","ENTERGY/GEL",null,null,null,null,null,547,null,null,null,null,null,null,null,null,null,988,3340,null,2660]
[null,"MDPH/MERL","","","","","",324.69715305536221,"","","","","","","","","",1031.9619961258184,3701.4410739767636,"",2939.9716473967151,"","","",""]
["2016-12-27","ENTERGY/GEL",null,null,null,null,null,605,null,null,null,null,null,null,null,null,null,800,2240,null,3020]
[null,"MDPH/MERL","","","","","",519.04072047465672,"","","","","","","","","",827.80690217290601,2692.4093261064609,"",3608.2000367714659,"","","",""]

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