{"text_format":"1","workbook":"xlsx","n_sheets":24,"sheets":["Lists","CreateSummary","FilteredEvents","Summary1","Summary2","Summary3","Summary4","Summary5","Summary6","Summary7","Summary8","Summary9","Summary10","Summary11","Summary12","Summary13","Summary14","Summary15","Summary16","Summary17","Summary18","Summary19","Summary20","Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":1,"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":"Lists","index":0,"n_rows":112,"n_cols":1,"rows_kept":112,"cut":false,"hidden":true,"merged":[]}
["Mortality reason"]
["AGD"]
["Algal bloom"]
["BKD"]
["Bonamiasis"]
["CMS"]
["Complex gill issues"]
["ERM"]
["Failed smolts"]
["Fungus"]
["Furunculosis"]
["Gaffkaemia"]
["Gastroenteritis"]
["Gill issues"]
["GS"]
["HSMI"]
["HSS"]
["IHN"]
["IPN"]
["ISA"]
["Jellyfish"]
["KHV"]
["Marteiliosis"]
["Maturation"]
["O2 problems"]
["Osmoregulatory failure"]
["Paranucleospora theridion"]
["Parvicapsula pseudobranchicola"]
["PD"]
["PGD"]
["Physical damage"]
["PKD"]
["Post-Transfer"]
["Power cut"]
["Predation"]
["RMS"]
["RTFS"]
["RVS"]
["Salmon gill pox"]
["Sea lice"]
["Seal damage"]
["SVC"]
["Transport"]
["Treatment"]
["VHS"]
["Vibriosis"]
["Water supply failure"]
["Water quality"]
["White spot"]
["Winter ulcers"]
[]
[]
[]
["Mortality observations"]
["Anorexic"]
["Base of fins Haemorrhaging"]
["Bloody ascites"]
["Body wall - Haemorrhaging"]
["Clear ascites"]
["Dark body"]
["Distended abdomen"]
["Enophthalmic"]
["Exophthalmic"]
["Eyes - Cataract"]
["Eyes - haemorrhagic"]
["Flared opercula"]
["Flashing"]
["General Anaemia"]
["Gills - necrotic"]
["Gills - pale"]
["Gills - zoned "]
["Gut - External haem"]
["Gut - Internal haem"]
["Gut - No food present"]
["Gut - Yellow pseudo-faeces"]
["Haemorrhaging elsewhere"]
["Hanging vertical"]
["Heart - deformed "]
["Heart - Granulomas"]
["Heart - Pale/anaemic"]
["Inflamed vent"]
["Kidney - Granular"]
["Kidney - Grey"]
["Kidney - Liquefied"]
["Kidney - Swollen"]
["Lesion elsewhere"]
["Lesion on flank"]
["Lethargic"]
["Liver - Enlarged"]
["Liver - Granulomas"]
["Liver - Gross haem"]
["Liver - Lesions "]
["Liver - Petechial haem"]
["Liver - Tissue breakdown"]
["Loss of equilibrium"]
["Moribund"]
["Parasites present"]
["Physical damage"]
["Pyloric caeca - Lack of fat"]
["Pyloric caeca - Petechial haem"]
["Pyloric caeca - Tubules mauve"]
["Scale Oedema"]
["Shortened opercula"]
["Spiralling"]
["Spleen - Enlarged"]
["Spleen - Granulomas"]
["Swim bladder - Fluid filled"]
["Swim bladder - Haemorrhaging"]
["Throat Haemorrhaging"]
["Tissue oedema"]
["Trailing faeces"]
["Ventrum Haemorrhaging"]

{"sheet":"CreateSummary","index":1,"n_rows":20,"n_cols":8,"rows_kept":20,"cut":false,"hidden":true,"merged":[]}
["Summary 1",null,"MRT ID",null,null,"First ID",{"$f":"IF(ISBLANK(D1),\"\",D1)","v":""}]
["Summary 2",null,"MRT ID",null,null,"Last ID",{"$f":"LOOKUP(2,1/(D:D<>\"\"),D:D)","v":{"$error":"#N/A"}},{"$f":"IF(ISBLANK(G2),\"\",\"-\"&LOOKUP(2,1/(D:D<>\"\"),D:D))","v":{"$error":"#N/A"}}]
["Summary 3",null,"MRT ID",null,null,"MRT ID for File name",{"$f":"IF(ISBLANK(D1),\"\",(IF(G2>G1,CONCATENATE(G1,H2),G1)))","v":""}]
["Summary 4",null,"MRT ID",null,null,"Save as filename",{"$f":"\"\\\\scotland.gov.uk\\dc2\\DCGroup_AN1\\FHI\\Mortality Events\\Reports sent to Edinburgh\\Mortality Event Report \"&G3","v":"\\\\scotland.gov.uk\\dc2\\DCGroup_AN1\\FHI\\Mortality Events\\Reports sent to Edinburgh\\Mortality Event Report "}]
["Summary 5",null,"MRT ID",null,null,"Attachment Filename",{"$f":"\"\\\\scotland.gov.uk\\dc2\\DCGroup_AN1\\FHI\\Mortality Events\\Reports sent to Edinburgh\\Mortality Event Report \"&G3&\".pdf\"","v":"\\\\scotland.gov.uk\\dc2\\DCGroup_AN1\\FHI\\Mortality Events\\Reports sent to Edinburgh\\Mortality Event Report .pdf"}]
["Summary 6",null,"MRT ID"]
["Summary 7",null,"MRT ID"]
["Summary 8",null,"MRT ID"]
["Summary 9",null,"MRT ID"]
["Summary 10",null,"MRT ID"]
["Summary 11",null,"MRT ID"]
["Summary 12",null,"MRT ID"]
["Summary 13",null,"MRT ID"]
["Summary 14",null,"MRT ID"]
["Summary 15",null,"MRT ID"]
["Summary 16",null,"MRT ID"]
["Summary 17",null,"MRT ID"]
["Summary 18",null,"MRT ID"]
["Summary 19",null,"MRT ID"]
["Summary 20",null,"MRT ID"]

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

{"sheet":"Summary1","index":3,"n_rows":36,"n_cols":2,"rows_kept":36,"cut":false,"hidden":true,"merged":[]}
["Mortality Event Report"]
["Mortality Event ID",{"$f":" IF(ISBLANK(CreateSummary!D1),\"\",CreateSummary!D1)","v":""}]
[]
["Site Name:",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,4,FALSE)),\"\", (VLOOKUP(B2, Events,4,FALSE))),\"\")","v":""}]
[]
["Site No:",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,5,FALSE)),\"\", (VLOOKUP(B2, Events,5,FALSE))),\"\")","v":""}]
[]
["Start date of mortality: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,9,FALSE)),\"\", (VLOOKUP(B2, Events,9,FALSE))),\"\")","v":""}]
[" "]
["Period of mortality: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,15,FALSE)),\"\", (VLOOKUP(B2, Events,15,FALSE))),\"\")","v":""}]
[]
["Percentage mortality: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,16,FALSE)),\"\", (VLOOKUP(B2, Events,16,FALSE))),\"\")","v":""}]
[]
["Explained/unexplained:",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,17,FALSE)),\"\", (VLOOKUP(B2, Events,17,FALSE))),\"\")","v":""}]
[]
["Reason (if explained): ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,18,FALSE)),\"\", (VLOOKUP(B2, Events,18,FALSE))),\"\")","v":""}]
[]
["Business Name: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,2,FALSE)),\"\", (VLOOKUP(B2, Events,2,FALSE))),\"\")","v":""}]
[]
["Business Number: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,3,FALSE)),\"\", (VLOOKUP(B2, Events,3,FALSE))),\"\")","v":""}]
[]
["Species: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,13,FALSE)),\"\", (VLOOKUP(B2, Events,13,FALSE))),\"\")","v":""}]
[]
["Water Type: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,8,FALSE)),\"\", (VLOOKUP(B2, Events,8,FALSE))),\"\")","v":""}]
[]
["Weight (site average): ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,11,FALSE)),\"\", (VLOOKUP(B2, Events,11,FALSE))),\"\")","v":""}]
[]
["Weight (affected population average):",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,12,FALSE)),\"\", (VLOOKUP(B2, Events,12,FALSE))),\"\")","v":""}]
[]
["Age: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,14,FALSE)),\"\", (VLOOKUP(B2, Events,14,FALSE))),\"\")","v":""}]
[]
["Estimated number of fish lost: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,20,FALSE)),\"\", (VLOOKUP(B2, Events,20,FALSE))),\"\")","v":""}]
[]
["Additional information: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,21,FALSE)),\"\", (VLOOKUP(B2, Events,21,FALSE))),\"\")","v":""}]
[]
["MS action: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,22,FALSE)),\"\", (VLOOKUP(B2, Events,22,FALSE))),\"\")","v":""}]

{"sheet":"Summary2","index":4,"n_rows":36,"n_cols":2,"rows_kept":36,"cut":false,"hidden":true,"merged":[]}
["Mortality Event Report"]
["Mortality Event ID",{"$f":" IF(ISBLANK(CreateSummary!D2),\"\",CreateSummary!D2)","v":""}]
[]
["Site Name:",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,4,FALSE)),\"\", (VLOOKUP(B2, Events,4,FALSE))),\"\")","v":""}]
[]
["Site No:",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,5,FALSE)),\"\", (VLOOKUP(B2, Events,5,FALSE))),\"\")","v":""}]
[]
["Start date of mortality: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,9,FALSE)),\"\", (VLOOKUP(B2, Events,9,FALSE))),\"\")","v":""}]
[" "]
["Period of mortality: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,15,FALSE)),\"\", (VLOOKUP(B2, Events,15,FALSE))),\"\")","v":""}]
[]
["Percentage mortality: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,16,FALSE)),\"\", (VLOOKUP(B2, Events,16,FALSE))),\"\")","v":""}]
[]
["Explained/unexplained:",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,17,FALSE)),\"\", (VLOOKUP(B2, Events,17,FALSE))),\"\")","v":""}]
[]
["Reason (if explained): ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,18,FALSE)),\"\", (VLOOKUP(B2, Events,18,FALSE))),\"\")","v":""}]
[]
["Business Name: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,2,FALSE)),\"\", (VLOOKUP(B2, Events,2,FALSE))),\"\")","v":""}]
[]
["Business Number: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,3,FALSE)),\"\", (VLOOKUP(B2, Events,3,FALSE))),\"\")","v":""}]
[]
["Species: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,13,FALSE)),\"\", (VLOOKUP(B2, Events,13,FALSE))),\"\")","v":""}]
[]
["Water Type: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,8,FALSE)),\"\", (VLOOKUP(B2, Events,8,FALSE))),\"\")","v":""}]
[]
["Weight (site average): ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,11,FALSE)),\"\", (VLOOKUP(B2, Events,11,FALSE))),\"\")","v":""}]
[]
["Weight (affected population average):",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,12,FALSE)),\"\", (VLOOKUP(B2, Events,12,FALSE))),\"\")","v":""}]
[]
["Age: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,14,FALSE)),\"\", (VLOOKUP(B2, Events,14,FALSE))),\"\")","v":""}]
[]
["Estimated number of fish lost: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,20,FALSE)),\"\", (VLOOKUP(B2, Events,20,FALSE))),\"\")","v":""}]
[]
["Additional information: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,21,FALSE)),\"\", (VLOOKUP(B2, Events,21,FALSE))),\"\")","v":""}]
[]
["MS action: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,22,FALSE)),\"\", (VLOOKUP(B2, Events,22,FALSE))),\"\")","v":""}]

{"sheet":"Summary3","index":5,"n_rows":36,"n_cols":2,"rows_kept":36,"cut":false,"hidden":true,"merged":[]}
["Mortality Event Report"]
["Mortality Event ID",{"$f":" IF(ISBLANK(CreateSummary!D3),\"\",CreateSummary!D3)","v":""}]
[]
["Site Name:",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,4,FALSE)),\"\", (VLOOKUP(B2, Events,4,FALSE))),\"\")","v":""}]
[]
["Site No:",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,5,FALSE)),\"\", (VLOOKUP(B2, Events,5,FALSE))),\"\")","v":""}]
[]
["Start date of mortality: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,9,FALSE)),\"\", (VLOOKUP(B2, Events,9,FALSE))),\"\")","v":""}]
[" "]
["Period of mortality: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,15,FALSE)),\"\", (VLOOKUP(B2, Events,15,FALSE))),\"\")","v":""}]
[]
["Percentage mortality: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,16,FALSE)),\"\", (VLOOKUP(B2, Events,16,FALSE))),\"\")","v":""}]
[]
["Explained/unexplained:",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,17,FALSE)),\"\", (VLOOKUP(B2, Events,17,FALSE))),\"\")","v":""}]
[]
["Reason (if explained): ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,18,FALSE)),\"\", (VLOOKUP(B2, Events,18,FALSE))),\"\")","v":""}]
[]
["Business Name: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,2,FALSE)),\"\", (VLOOKUP(B2, Events,2,FALSE))),\"\")","v":""}]
[]
["Business Number: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,3,FALSE)),\"\", (VLOOKUP(B2, Events,3,FALSE))),\"\")","v":""}]
[]
["Species: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,13,FALSE)),\"\", (VLOOKUP(B2, Events,13,FALSE))),\"\")","v":""}]
[]
["Water Type: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,8,FALSE)),\"\", (VLOOKUP(B2, Events,8,FALSE))),\"\")","v":""}]
[]
["Weight (site average): ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,11,FALSE)),\"\", (VLOOKUP(B2, Events,11,FALSE))),\"\")","v":""}]
[]
["Weight (affected population average):",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,12,FALSE)),\"\", (VLOOKUP(B2, Events,12,FALSE))),\"\")","v":""}]
[]
["Age: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,14,FALSE)),\"\", (VLOOKUP(B2, Events,14,FALSE))),\"\")","v":""}]
[]
["Estimated number of fish lost: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,20,FALSE)),\"\", (VLOOKUP(B2, Events,20,FALSE))),\"\")","v":""}]
[]
["Additional information: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,21,FALSE)),\"\", (VLOOKUP(B2, Events,21,FALSE))),\"\")","v":""}]
[]
["MS action: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,22,FALSE)),\"\", (VLOOKUP(B2, Events,22,FALSE))),\"\")","v":""}]

{"sheet":"Summary4","index":6,"n_rows":36,"n_cols":2,"rows_kept":36,"cut":false,"hidden":true,"merged":[]}
["Mortality Event Report"]
["Mortality Event ID",{"$f":" IF(ISBLANK(CreateSummary!D4),\"\",CreateSummary!D4)","v":""}]
[]
["Site Name:",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,4,FALSE)),\"\", (VLOOKUP(B2, Events,4,FALSE))),\"\")","v":""}]
[]
["Site No:",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,5,FALSE)),\"\", (VLOOKUP(B2, Events,5,FALSE))),\"\")","v":""}]
[]
["Start date of mortality: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,9,FALSE)),\"\", (VLOOKUP(B2, Events,9,FALSE))),\"\")","v":""}]
[" "]
["Period of mortality: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,15,FALSE)),\"\", (VLOOKUP(B2, Events,15,FALSE))),\"\")","v":""}]
[]
["Percentage mortality: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,16,FALSE)),\"\", (VLOOKUP(B2, Events,16,FALSE))),\"\")","v":""}]
[]
["Explained/unexplained:",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,17,FALSE)),\"\", (VLOOKUP(B2, Events,17,FALSE))),\"\")","v":""}]
[]
["Reason (if explained): ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,18,FALSE)),\"\", (VLOOKUP(B2, Events,18,FALSE))),\"\")","v":""}]
[]
["Business Name: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,2,FALSE)),\"\", (VLOOKUP(B2, Events,2,FALSE))),\"\")","v":""}]
[]
["Business Number: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,3,FALSE)),\"\", (VLOOKUP(B2, Events,3,FALSE))),\"\")","v":""}]
[]
["Species: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,13,FALSE)),\"\", (VLOOKUP(B2, Events,13,FALSE))),\"\")","v":""}]
[]
["Water Type: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,8,FALSE)),\"\", (VLOOKUP(B2, Events,8,FALSE))),\"\")","v":""}]
[]
["Weight (site average): ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,11,FALSE)),\"\", (VLOOKUP(B2, Events,11,FALSE))),\"\")","v":""}]
[]
["Weight (affected population average):",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,12,FALSE)),\"\", (VLOOKUP(B2, Events,12,FALSE))),\"\")","v":""}]
[]
["Age: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,14,FALSE)),\"\", (VLOOKUP(B2, Events,14,FALSE))),\"\")","v":""}]
[]
["Estimated number of fish lost: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,20,FALSE)),\"\", (VLOOKUP(B2, Events,20,FALSE))),\"\")","v":""}]
[]
["Additional information: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,21,FALSE)),\"\", (VLOOKUP(B2, Events,21,FALSE))),\"\")","v":""}]
[]
["MS action: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,22,FALSE)),\"\", (VLOOKUP(B2, Events,22,FALSE))),\"\")","v":""}]

{"sheet":"Summary5","index":7,"n_rows":36,"n_cols":2,"rows_kept":36,"cut":false,"hidden":true,"merged":[]}
["Mortality Event Report"]
["Mortality Event ID",{"$f":" IF(ISBLANK(CreateSummary!D5),\"\",CreateSummary!D5)","v":""}]
[]
["Site Name:",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,4,FALSE)),\"\", (VLOOKUP(B2, Events,4,FALSE))),\"\")","v":""}]
[]
["Site No:",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,5,FALSE)),\"\", (VLOOKUP(B2, Events,5,FALSE))),\"\")","v":""}]
[]
["Start date of mortality: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,9,FALSE)),\"\", (VLOOKUP(B2, Events,9,FALSE))),\"\")","v":""}]
[" "]
["Period of mortality: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,15,FALSE)),\"\", (VLOOKUP(B2, Events,15,FALSE))),\"\")","v":""}]
[]
["Percentage mortality: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,16,FALSE)),\"\", (VLOOKUP(B2, Events,16,FALSE))),\"\")","v":""}]
[]
["Explained/unexplained:",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,17,FALSE)),\"\", (VLOOKUP(B2, Events,17,FALSE))),\"\")","v":""}]
[]
["Reason (if explained): ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,18,FALSE)),\"\", (VLOOKUP(B2, Events,18,FALSE))),\"\")","v":""}]
[]
["Business Name: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,2,FALSE)),\"\", (VLOOKUP(B2, Events,2,FALSE))),\"\")","v":""}]
[]
["Business Number: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,3,FALSE)),\"\", (VLOOKUP(B2, Events,3,FALSE))),\"\")","v":""}]
[]
["Species: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,13,FALSE)),\"\", (VLOOKUP(B2, Events,13,FALSE))),\"\")","v":""}]
[]
["Water Type: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,8,FALSE)),\"\", (VLOOKUP(B2, Events,8,FALSE))),\"\")","v":""}]
[]
["Weight (site average): ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,11,FALSE)),\"\", (VLOOKUP(B2, Events,11,FALSE))),\"\")","v":""}]
[]
["Weight (affected population average):",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,12,FALSE)),\"\", (VLOOKUP(B2, Events,12,FALSE))),\"\")","v":""}]
[]
["Age: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,14,FALSE)),\"\", (VLOOKUP(B2, Events,14,FALSE))),\"\")","v":""}]
[]
["Estimated number of fish lost: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,20,FALSE)),\"\", (VLOOKUP(B2, Events,20,FALSE))),\"\")","v":""}]
[]
["Additional information: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,21,FALSE)),\"\", (VLOOKUP(B2, Events,21,FALSE))),\"\")","v":""}]
[]
["MS action: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,22,FALSE)),\"\", (VLOOKUP(B2, Events,22,FALSE))),\"\")","v":""}]

{"sheet":"Summary6","index":8,"n_rows":36,"n_cols":2,"rows_kept":36,"cut":false,"hidden":true,"merged":[]}
["Mortality Event Report"]
["Mortality Event ID",{"$f":" IF(ISBLANK(CreateSummary!D6),\"\",CreateSummary!D6)","v":""}]
[]
["Site Name:",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,4,FALSE)),\"\", (VLOOKUP(B2, Events,4,FALSE))),\"\")","v":""}]
[]
["Site No:",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,5,FALSE)),\"\", (VLOOKUP(B2, Events,5,FALSE))),\"\")","v":""}]
[]
["Start date of mortality: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,9,FALSE)),\"\", (VLOOKUP(B2, Events,9,FALSE))),\"\")","v":""}]
[" "]
["Period of mortality: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,15,FALSE)),\"\", (VLOOKUP(B2, Events,15,FALSE))),\"\")","v":""}]
[]
["Percentage mortality: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,16,FALSE)),\"\", (VLOOKUP(B2, Events,16,FALSE))),\"\")","v":""}]
[]
["Explained/unexplained:",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,17,FALSE)),\"\", (VLOOKUP(B2, Events,17,FALSE))),\"\")","v":""}]
[]
["Reason (if explained): ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,18,FALSE)),\"\", (VLOOKUP(B2, Events,18,FALSE))),\"\")","v":""}]
[]
["Business Name: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,2,FALSE)),\"\", (VLOOKUP(B2, Events,2,FALSE))),\"\")","v":""}]
[]
["Business Number: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,3,FALSE)),\"\", (VLOOKUP(B2, Events,3,FALSE))),\"\")","v":""}]
[]
["Species: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,13,FALSE)),\"\", (VLOOKUP(B2, Events,13,FALSE))),\"\")","v":""}]
[]
["Water Type: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,8,FALSE)),\"\", (VLOOKUP(B2, Events,8,FALSE))),\"\")","v":""}]
[]
["Weight (site average): ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,11,FALSE)),\"\", (VLOOKUP(B2, Events,11,FALSE))),\"\")","v":""}]
[]
["Weight (affected population average):",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,12,FALSE)),\"\", (VLOOKUP(B2, Events,12,FALSE))),\"\")","v":""}]
[]
["Age: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,14,FALSE)),\"\", (VLOOKUP(B2, Events,14,FALSE))),\"\")","v":""}]
[]
["Estimated number of fish lost: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,20,FALSE)),\"\", (VLOOKUP(B2, Events,20,FALSE))),\"\")","v":""}]
[]
["Additional information: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,21,FALSE)),\"\", (VLOOKUP(B2, Events,21,FALSE))),\"\")","v":""}]
[]
["MS action: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,22,FALSE)),\"\", (VLOOKUP(B2, Events,22,FALSE))),\"\")","v":""}]

{"sheet":"Summary7","index":9,"n_rows":36,"n_cols":2,"rows_kept":36,"cut":false,"hidden":true,"merged":[]}
["Mortality Event Report"]
["Mortality Event ID",{"$f":" IF(ISBLANK(CreateSummary!D7),\"\",CreateSummary!D7)","v":""}]
[]
["Site Name:",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,4,FALSE)),\"\", (VLOOKUP(B2, Events,4,FALSE))),\"\")","v":""}]
[]
["Site No:",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,5,FALSE)),\"\", (VLOOKUP(B2, Events,5,FALSE))),\"\")","v":""}]
[]
["Start date of mortality: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,9,FALSE)),\"\", (VLOOKUP(B2, Events,9,FALSE))),\"\")","v":""}]
[" "]
["Period of mortality: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,15,FALSE)),\"\", (VLOOKUP(B2, Events,15,FALSE))),\"\")","v":""}]
[]
["Percentage mortality: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,16,FALSE)),\"\", (VLOOKUP(B2, Events,16,FALSE))),\"\")","v":""}]
[]
["Explained/unexplained:",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,17,FALSE)),\"\", (VLOOKUP(B2, Events,17,FALSE))),\"\")","v":""}]
[]
["Reason (if explained): ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,18,FALSE)),\"\", (VLOOKUP(B2, Events,18,FALSE))),\"\")","v":""}]
[]
["Business Name: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,2,FALSE)),\"\", (VLOOKUP(B2, Events,2,FALSE))),\"\")","v":""}]
[]
["Business Number: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,3,FALSE)),\"\", (VLOOKUP(B2, Events,3,FALSE))),\"\")","v":""}]
[]
["Species: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,13,FALSE)),\"\", (VLOOKUP(B2, Events,13,FALSE))),\"\")","v":""}]
[]
["Water Type: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,8,FALSE)),\"\", (VLOOKUP(B2, Events,8,FALSE))),\"\")","v":""}]
[]
["Weight (site average): ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,11,FALSE)),\"\", (VLOOKUP(B2, Events,11,FALSE))),\"\")","v":""}]
[]
["Weight (affected population average):",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,12,FALSE)),\"\", (VLOOKUP(B2, Events,12,FALSE))),\"\")","v":""}]
[]
["Age: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,14,FALSE)),\"\", (VLOOKUP(B2, Events,14,FALSE))),\"\")","v":""}]
[]
["Estimated number of fish lost: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,20,FALSE)),\"\", (VLOOKUP(B2, Events,20,FALSE))),\"\")","v":""}]
[]
["Additional information: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,21,FALSE)),\"\", (VLOOKUP(B2, Events,21,FALSE))),\"\")","v":""}]
[]
["MS action: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,22,FALSE)),\"\", (VLOOKUP(B2, Events,22,FALSE))),\"\")","v":""}]

{"sheet":"Summary8","index":10,"n_rows":36,"n_cols":2,"rows_kept":36,"cut":false,"hidden":true,"merged":[]}
["Mortality Event Report"]
["Mortality Event ID",{"$f":" IF(ISBLANK(CreateSummary!D8),\"\",CreateSummary!D8)","v":""}]
[]
["Site Name:",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,4,FALSE)),\"\", (VLOOKUP(B2, Events,4,FALSE))),\"\")","v":""}]
[]
["Site No:",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,5,FALSE)),\"\", (VLOOKUP(B2, Events,5,FALSE))),\"\")","v":""}]
[]
["Start date of mortality: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,9,FALSE)),\"\", (VLOOKUP(B2, Events,9,FALSE))),\"\")","v":""}]
[" "]
["Period of mortality: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,15,FALSE)),\"\", (VLOOKUP(B2, Events,15,FALSE))),\"\")","v":""}]
[]
["Percentage mortality: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,16,FALSE)),\"\", (VLOOKUP(B2, Events,16,FALSE))),\"\")","v":""}]
[]
["Explained/unexplained:",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,17,FALSE)),\"\", (VLOOKUP(B2, Events,17,FALSE))),\"\")","v":""}]
[]
["Reason (if explained): ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,18,FALSE)),\"\", (VLOOKUP(B2, Events,18,FALSE))),\"\")","v":""}]
[]
["Business Name: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,2,FALSE)),\"\", (VLOOKUP(B2, Events,2,FALSE))),\"\")","v":""}]
[]
["Business Number: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,3,FALSE)),\"\", (VLOOKUP(B2, Events,3,FALSE))),\"\")","v":""}]
[]
["Species: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,13,FALSE)),\"\", (VLOOKUP(B2, Events,13,FALSE))),\"\")","v":""}]
[]
["Water Type: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,8,FALSE)),\"\", (VLOOKUP(B2, Events,8,FALSE))),\"\")","v":""}]
[]
["Weight (site average): ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,11,FALSE)),\"\", (VLOOKUP(B2, Events,11,FALSE))),\"\")","v":""}]
[]
["Weight (affected population average):",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,12,FALSE)),\"\", (VLOOKUP(B2, Events,12,FALSE))),\"\")","v":""}]
[]
["Age: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,14,FALSE)),\"\", (VLOOKUP(B2, Events,14,FALSE))),\"\")","v":""}]
[]
["Estimated number of fish lost: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,20,FALSE)),\"\", (VLOOKUP(B2, Events,20,FALSE))),\"\")","v":""}]
[]
["Additional information: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,21,FALSE)),\"\", (VLOOKUP(B2, Events,21,FALSE))),\"\")","v":""}]
[]
["MS action: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,22,FALSE)),\"\", (VLOOKUP(B2, Events,22,FALSE))),\"\")","v":""}]

{"sheet":"Summary9","index":11,"n_rows":36,"n_cols":2,"rows_kept":36,"cut":false,"hidden":true,"merged":[]}
["Mortality Event Report"]
["Mortality Event ID",{"$f":" IF(ISBLANK(CreateSummary!D9),\"\",CreateSummary!D9)","v":""}]
[]
["Site Name:",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,4,FALSE)),\"\", (VLOOKUP(B2, Events,4,FALSE))),\"\")","v":""}]
[]
["Site No:",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,5,FALSE)),\"\", (VLOOKUP(B2, Events,5,FALSE))),\"\")","v":""}]
[]
["Start date of mortality: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,9,FALSE)),\"\", (VLOOKUP(B2, Events,9,FALSE))),\"\")","v":""}]
[" "]
["Period of mortality: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,15,FALSE)),\"\", (VLOOKUP(B2, Events,15,FALSE))),\"\")","v":""}]
[]
["Percentage mortality: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,16,FALSE)),\"\", (VLOOKUP(B2, Events,16,FALSE))),\"\")","v":""}]
[]
["Explained/unexplained:",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,17,FALSE)),\"\", (VLOOKUP(B2, Events,17,FALSE))),\"\")","v":""}]
[]
["Reason (if explained): ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,18,FALSE)),\"\", (VLOOKUP(B2, Events,18,FALSE))),\"\")","v":""}]
[]
["Business Name: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,2,FALSE)),\"\", (VLOOKUP(B2, Events,2,FALSE))),\"\")","v":""}]
[]
["Business Number: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,3,FALSE)),\"\", (VLOOKUP(B2, Events,3,FALSE))),\"\")","v":""}]
[]
["Species: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,13,FALSE)),\"\", (VLOOKUP(B2, Events,13,FALSE))),\"\")","v":""}]
[]
["Water Type: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,8,FALSE)),\"\", (VLOOKUP(B2, Events,8,FALSE))),\"\")","v":""}]
[]
["Weight (site average): ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,11,FALSE)),\"\", (VLOOKUP(B2, Events,11,FALSE))),\"\")","v":""}]
[]
["Weight (affected population average):",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,12,FALSE)),\"\", (VLOOKUP(B2, Events,12,FALSE))),\"\")","v":""}]
[]
["Age: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,14,FALSE)),\"\", (VLOOKUP(B2, Events,14,FALSE))),\"\")","v":""}]
[]
["Estimated number of fish lost: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,20,FALSE)),\"\", (VLOOKUP(B2, Events,20,FALSE))),\"\")","v":""}]
[]
["Additional information: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,21,FALSE)),\"\", (VLOOKUP(B2, Events,21,FALSE))),\"\")","v":""}]
[]
["MS action: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,22,FALSE)),\"\", (VLOOKUP(B2, Events,22,FALSE))),\"\")","v":""}]

{"sheet":"Summary10","index":12,"n_rows":36,"n_cols":2,"rows_kept":36,"cut":false,"hidden":true,"merged":[]}
["Mortality Event Report"]
["Mortality Event ID",{"$f":" IF(ISBLANK(CreateSummary!D10),\"\",CreateSummary!D10)","v":""}]
[]
["Site Name:",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,4,FALSE)),\"\", (VLOOKUP(B2, Events,4,FALSE))),\"\")","v":""}]
[]
["Site No:",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,5,FALSE)),\"\", (VLOOKUP(B2, Events,5,FALSE))),\"\")","v":""}]
[]
["Start date of mortality: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,9,FALSE)),\"\", (VLOOKUP(B2, Events,9,FALSE))),\"\")","v":""}]
[" "]
["Period of mortality: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,15,FALSE)),\"\", (VLOOKUP(B2, Events,15,FALSE))),\"\")","v":""}]
[]
["Percentage mortality: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,16,FALSE)),\"\", (VLOOKUP(B2, Events,16,FALSE))),\"\")","v":""}]
[]
["Explained/unexplained:",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,17,FALSE)),\"\", (VLOOKUP(B2, Events,17,FALSE))),\"\")","v":""}]
[]
["Reason (if explained): ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,18,FALSE)),\"\", (VLOOKUP(B2, Events,18,FALSE))),\"\")","v":""}]
[]
["Business Name: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,2,FALSE)),\"\", (VLOOKUP(B2, Events,2,FALSE))),\"\")","v":""}]
[]
["Business Number: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,3,FALSE)),\"\", (VLOOKUP(B2, Events,3,FALSE))),\"\")","v":""}]
[]
["Species: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,13,FALSE)),\"\", (VLOOKUP(B2, Events,13,FALSE))),\"\")","v":""}]
[]
["Water Type: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,8,FALSE)),\"\", (VLOOKUP(B2, Events,8,FALSE))),\"\")","v":""}]
[]
["Weight (site average): ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,11,FALSE)),\"\", (VLOOKUP(B2, Events,11,FALSE))),\"\")","v":""}]
[]
["Weight (affected population average):",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,12,FALSE)),\"\", (VLOOKUP(B2, Events,12,FALSE))),\"\")","v":""}]
[]
["Age: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,14,FALSE)),\"\", (VLOOKUP(B2, Events,14,FALSE))),\"\")","v":""}]
[]
["Estimated number of fish lost: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,20,FALSE)),\"\", (VLOOKUP(B2, Events,20,FALSE))),\"\")","v":""}]
[]
["Additional information: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,21,FALSE)),\"\", (VLOOKUP(B2, Events,21,FALSE))),\"\")","v":""}]
[]
["MS action: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,22,FALSE)),\"\", (VLOOKUP(B2, Events,22,FALSE))),\"\")","v":""}]

{"sheet":"Summary11","index":13,"n_rows":36,"n_cols":2,"rows_kept":36,"cut":false,"hidden":true,"merged":[]}
["Mortality Event Report"]
["Mortality Event ID",{"$f":" IF(ISBLANK(CreateSummary!D11),\"\",CreateSummary!D11)","v":""}]
[]
["Site Name:",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,4,FALSE)),\"\", (VLOOKUP(B2, Events,4,FALSE))),\"\")","v":""}]
[]
["Site No:",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,5,FALSE)),\"\", (VLOOKUP(B2, Events,5,FALSE))),\"\")","v":""}]
[]
["Start date of mortality: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,9,FALSE)),\"\", (VLOOKUP(B2, Events,9,FALSE))),\"\")","v":""}]
[" "]
["Period of mortality: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,15,FALSE)),\"\", (VLOOKUP(B2, Events,15,FALSE))),\"\")","v":""}]
[]
["Percentage mortality: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,16,FALSE)),\"\", (VLOOKUP(B2, Events,16,FALSE))),\"\")","v":""}]
[]
["Explained/unexplained:",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,17,FALSE)),\"\", (VLOOKUP(B2, Events,17,FALSE))),\"\")","v":""}]
[]
["Reason (if explained): ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,18,FALSE)),\"\", (VLOOKUP(B2, Events,18,FALSE))),\"\")","v":""}]
[]
["Business Name: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,2,FALSE)),\"\", (VLOOKUP(B2, Events,2,FALSE))),\"\")","v":""}]
[]
["Business Number: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,3,FALSE)),\"\", (VLOOKUP(B2, Events,3,FALSE))),\"\")","v":""}]
[]
["Species: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,13,FALSE)),\"\", (VLOOKUP(B2, Events,13,FALSE))),\"\")","v":""}]
[]
["Water Type: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,8,FALSE)),\"\", (VLOOKUP(B2, Events,8,FALSE))),\"\")","v":""}]
[]
["Weight (site average): ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,11,FALSE)),\"\", (VLOOKUP(B2, Events,11,FALSE))),\"\")","v":""}]
[]
["Weight (affected population average):",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,12,FALSE)),\"\", (VLOOKUP(B2, Events,12,FALSE))),\"\")","v":""}]
[]
["Age: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,14,FALSE)),\"\", (VLOOKUP(B2, Events,14,FALSE))),\"\")","v":""}]
[]
["Estimated number of fish lost: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,20,FALSE)),\"\", (VLOOKUP(B2, Events,20,FALSE))),\"\")","v":""}]
[]
["Additional information: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,21,FALSE)),\"\", (VLOOKUP(B2, Events,21,FALSE))),\"\")","v":""}]
[]
["MS action: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,22,FALSE)),\"\", (VLOOKUP(B2, Events,22,FALSE))),\"\")","v":""}]

{"sheet":"Summary12","index":14,"n_rows":36,"n_cols":2,"rows_kept":36,"cut":false,"hidden":true,"merged":[]}
["Mortality Event Report"]
["Mortality Event ID",{"$f":" IF(ISBLANK(CreateSummary!D12),\"\",CreateSummary!D12)","v":""}]
[]
["Site Name:",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,4,FALSE)),\"\", (VLOOKUP(B2, Events,4,FALSE))),\"\")","v":""}]
[]
["Site No:",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,5,FALSE)),\"\", (VLOOKUP(B2, Events,5,FALSE))),\"\")","v":""}]
[]
["Start date of mortality: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,9,FALSE)),\"\", (VLOOKUP(B2, Events,9,FALSE))),\"\")","v":""}]
[" "]
["Period of mortality: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,15,FALSE)),\"\", (VLOOKUP(B2, Events,15,FALSE))),\"\")","v":""}]
[]
["Percentage mortality: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,16,FALSE)),\"\", (VLOOKUP(B2, Events,16,FALSE))),\"\")","v":""}]
[]
["Explained/unexplained:",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,17,FALSE)),\"\", (VLOOKUP(B2, Events,17,FALSE))),\"\")","v":""}]
[]
["Reason (if explained): ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,18,FALSE)),\"\", (VLOOKUP(B2, Events,18,FALSE))),\"\")","v":""}]
[]
["Business Name: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,2,FALSE)),\"\", (VLOOKUP(B2, Events,2,FALSE))),\"\")","v":""}]
[]
["Business Number: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,3,FALSE)),\"\", (VLOOKUP(B2, Events,3,FALSE))),\"\")","v":""}]
[]
["Species: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,13,FALSE)),\"\", (VLOOKUP(B2, Events,13,FALSE))),\"\")","v":""}]
[]
["Water Type: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,8,FALSE)),\"\", (VLOOKUP(B2, Events,8,FALSE))),\"\")","v":""}]
[]
["Weight (site average): ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,11,FALSE)),\"\", (VLOOKUP(B2, Events,11,FALSE))),\"\")","v":""}]
[]
["Weight (affected population average):",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,12,FALSE)),\"\", (VLOOKUP(B2, Events,12,FALSE))),\"\")","v":""}]
[]
["Age: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,14,FALSE)),\"\", (VLOOKUP(B2, Events,14,FALSE))),\"\")","v":""}]
[]
["Estimated number of fish lost: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,20,FALSE)),\"\", (VLOOKUP(B2, Events,20,FALSE))),\"\")","v":""}]
[]
["Additional information: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,21,FALSE)),\"\", (VLOOKUP(B2, Events,21,FALSE))),\"\")","v":""}]
[]
["MS action: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,22,FALSE)),\"\", (VLOOKUP(B2, Events,22,FALSE))),\"\")","v":""}]

{"sheet":"Summary13","index":15,"n_rows":36,"n_cols":2,"rows_kept":36,"cut":false,"hidden":true,"merged":[]}
["Mortality Event Report"]
["Mortality Event ID",{"$f":" IF(ISBLANK(CreateSummary!D13),\"\",CreateSummary!D13)","v":""}]
[]
["Site Name:",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,4,FALSE)),\"\", (VLOOKUP(B2, Events,4,FALSE))),\"\")","v":""}]
[]
["Site No:",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,5,FALSE)),\"\", (VLOOKUP(B2, Events,5,FALSE))),\"\")","v":""}]
[]
["Start date of mortality: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,9,FALSE)),\"\", (VLOOKUP(B2, Events,9,FALSE))),\"\")","v":""}]
[" "]
["Period of mortality: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,15,FALSE)),\"\", (VLOOKUP(B2, Events,15,FALSE))),\"\")","v":""}]
[]
["Percentage mortality: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,16,FALSE)),\"\", (VLOOKUP(B2, Events,16,FALSE))),\"\")","v":""}]
[]
["Explained/unexplained:",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,17,FALSE)),\"\", (VLOOKUP(B2, Events,17,FALSE))),\"\")","v":""}]
[]
["Reason (if explained): ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,18,FALSE)),\"\", (VLOOKUP(B2, Events,18,FALSE))),\"\")","v":""}]
[]
["Business Name: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,2,FALSE)),\"\", (VLOOKUP(B2, Events,2,FALSE))),\"\")","v":""}]
[]
["Business Number: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,3,FALSE)),\"\", (VLOOKUP(B2, Events,3,FALSE))),\"\")","v":""}]
[]
["Species: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,13,FALSE)),\"\", (VLOOKUP(B2, Events,13,FALSE))),\"\")","v":""}]
[]
["Water Type: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,8,FALSE)),\"\", (VLOOKUP(B2, Events,8,FALSE))),\"\")","v":""}]
[]
["Weight (site average): ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,11,FALSE)),\"\", (VLOOKUP(B2, Events,11,FALSE))),\"\")","v":""}]
[]
["Weight (affected population average):",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,12,FALSE)),\"\", (VLOOKUP(B2, Events,12,FALSE))),\"\")","v":""}]
[]
["Age: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,14,FALSE)),\"\", (VLOOKUP(B2, Events,14,FALSE))),\"\")","v":""}]
[]
["Estimated number of fish lost: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,20,FALSE)),\"\", (VLOOKUP(B2, Events,20,FALSE))),\"\")","v":""}]
[]
["Additional information: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,21,FALSE)),\"\", (VLOOKUP(B2, Events,21,FALSE))),\"\")","v":""}]
[]
["MS action: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,22,FALSE)),\"\", (VLOOKUP(B2, Events,22,FALSE))),\"\")","v":""}]

{"sheet":"Summary14","index":16,"n_rows":36,"n_cols":2,"rows_kept":36,"cut":false,"hidden":true,"merged":[]}
["Mortality Event Report"]
["Mortality Event ID",{"$f":" IF(ISBLANK(CreateSummary!D14),\"\",CreateSummary!D14)","v":""}]
[]
["Site Name:",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,4,FALSE)),\"\", (VLOOKUP(B2, Events,4,FALSE))),\"\")","v":""}]
[]
["Site No:",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,5,FALSE)),\"\", (VLOOKUP(B2, Events,5,FALSE))),\"\")","v":""}]
[]
["Start date of mortality: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,9,FALSE)),\"\", (VLOOKUP(B2, Events,9,FALSE))),\"\")","v":""}]
[" "]
["Period of mortality: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,15,FALSE)),\"\", (VLOOKUP(B2, Events,15,FALSE))),\"\")","v":""}]
[]
["Percentage mortality: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,16,FALSE)),\"\", (VLOOKUP(B2, Events,16,FALSE))),\"\")","v":""}]
[]
["Explained/unexplained:",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,17,FALSE)),\"\", (VLOOKUP(B2, Events,17,FALSE))),\"\")","v":""}]
[]
["Reason (if explained): ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,18,FALSE)),\"\", (VLOOKUP(B2, Events,18,FALSE))),\"\")","v":""}]
[]
["Business Name: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,2,FALSE)),\"\", (VLOOKUP(B2, Events,2,FALSE))),\"\")","v":""}]
[]
["Business Number: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,3,FALSE)),\"\", (VLOOKUP(B2, Events,3,FALSE))),\"\")","v":""}]
[]
["Species: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,13,FALSE)),\"\", (VLOOKUP(B2, Events,13,FALSE))),\"\")","v":""}]
[]
["Water Type: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,8,FALSE)),\"\", (VLOOKUP(B2, Events,8,FALSE))),\"\")","v":""}]
[]
["Weight (site average): ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,11,FALSE)),\"\", (VLOOKUP(B2, Events,11,FALSE))),\"\")","v":""}]
[]
["Weight (affected population average):",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,12,FALSE)),\"\", (VLOOKUP(B2, Events,12,FALSE))),\"\")","v":""}]
[]
["Age: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,14,FALSE)),\"\", (VLOOKUP(B2, Events,14,FALSE))),\"\")","v":""}]
[]
["Estimated number of fish lost: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,20,FALSE)),\"\", (VLOOKUP(B2, Events,20,FALSE))),\"\")","v":""}]
[]
["Additional information: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,21,FALSE)),\"\", (VLOOKUP(B2, Events,21,FALSE))),\"\")","v":""}]
[]
["MS action: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,22,FALSE)),\"\", (VLOOKUP(B2, Events,22,FALSE))),\"\")","v":""}]

{"sheet":"Summary15","index":17,"n_rows":36,"n_cols":2,"rows_kept":36,"cut":false,"hidden":true,"merged":[]}
["Mortality Event Report"]
["Mortality Event ID",{"$f":" IF(ISBLANK(CreateSummary!D15),\"\",CreateSummary!D15)","v":""}]
[]
["Site Name:",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,4,FALSE)),\"\", (VLOOKUP(B2, Events,4,FALSE))),\"\")","v":""}]
[]
["Site No:",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,5,FALSE)),\"\", (VLOOKUP(B2, Events,5,FALSE))),\"\")","v":""}]
[]
["Start date of mortality: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,9,FALSE)),\"\", (VLOOKUP(B2, Events,9,FALSE))),\"\")","v":""}]
[" "]
["Period of mortality: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,15,FALSE)),\"\", (VLOOKUP(B2, Events,15,FALSE))),\"\")","v":""}]
[]
["Percentage mortality: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,16,FALSE)),\"\", (VLOOKUP(B2, Events,16,FALSE))),\"\")","v":""}]
[]
["Explained/unexplained:",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,17,FALSE)),\"\", (VLOOKUP(B2, Events,17,FALSE))),\"\")","v":""}]
[]
["Reason (if explained): ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,18,FALSE)),\"\", (VLOOKUP(B2, Events,18,FALSE))),\"\")","v":""}]
[]
["Business Name: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,2,FALSE)),\"\", (VLOOKUP(B2, Events,2,FALSE))),\"\")","v":""}]
[]
["Business Number: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,3,FALSE)),\"\", (VLOOKUP(B2, Events,3,FALSE))),\"\")","v":""}]
[]
["Species: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,13,FALSE)),\"\", (VLOOKUP(B2, Events,13,FALSE))),\"\")","v":""}]
[]
["Water Type: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,8,FALSE)),\"\", (VLOOKUP(B2, Events,8,FALSE))),\"\")","v":""}]
[]
["Weight (site average): ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,11,FALSE)),\"\", (VLOOKUP(B2, Events,11,FALSE))),\"\")","v":""}]
[]
["Weight (affected population average):",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,12,FALSE)),\"\", (VLOOKUP(B2, Events,12,FALSE))),\"\")","v":""}]
[]
["Age: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,14,FALSE)),\"\", (VLOOKUP(B2, Events,14,FALSE))),\"\")","v":""}]
[]
["Estimated number of fish lost: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,20,FALSE)),\"\", (VLOOKUP(B2, Events,20,FALSE))),\"\")","v":""}]
[]
["Additional information: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,21,FALSE)),\"\", (VLOOKUP(B2, Events,21,FALSE))),\"\")","v":""}]
[]
["MS action: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,22,FALSE)),\"\", (VLOOKUP(B2, Events,22,FALSE))),\"\")","v":""}]

{"sheet":"Summary16","index":18,"n_rows":36,"n_cols":2,"rows_kept":36,"cut":false,"hidden":true,"merged":[]}
["Mortality Event Report"]
["Mortality Event ID",{"$f":" IF(ISBLANK(CreateSummary!D16),\"\",CreateSummary!D16)","v":""}]
[]
["Site Name:",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,4,FALSE)),\"\", (VLOOKUP(B2, Events,4,FALSE))),\"\")","v":""}]
[]
["Site No:",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,5,FALSE)),\"\", (VLOOKUP(B2, Events,5,FALSE))),\"\")","v":""}]
[]
["Start date of mortality: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,9,FALSE)),\"\", (VLOOKUP(B2, Events,9,FALSE))),\"\")","v":""}]
[" "]
["Period of mortality: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,15,FALSE)),\"\", (VLOOKUP(B2, Events,15,FALSE))),\"\")","v":""}]
[]
["Percentage mortality: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,16,FALSE)),\"\", (VLOOKUP(B2, Events,16,FALSE))),\"\")","v":""}]
[]
["Explained/unexplained:",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,17,FALSE)),\"\", (VLOOKUP(B2, Events,17,FALSE))),\"\")","v":""}]
[]
["Reason (if explained): ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,18,FALSE)),\"\", (VLOOKUP(B2, Events,18,FALSE))),\"\")","v":""}]
[]
["Business Name: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,2,FALSE)),\"\", (VLOOKUP(B2, Events,2,FALSE))),\"\")","v":""}]
[]
["Business Number: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,3,FALSE)),\"\", (VLOOKUP(B2, Events,3,FALSE))),\"\")","v":""}]
[]
["Species: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,13,FALSE)),\"\", (VLOOKUP(B2, Events,13,FALSE))),\"\")","v":""}]
[]
["Water Type: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,8,FALSE)),\"\", (VLOOKUP(B2, Events,8,FALSE))),\"\")","v":""}]
[]
["Weight (site average): ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,11,FALSE)),\"\", (VLOOKUP(B2, Events,11,FALSE))),\"\")","v":""}]
[]
["Weight (affected population average):",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,12,FALSE)),\"\", (VLOOKUP(B2, Events,12,FALSE))),\"\")","v":""}]
[]
["Age: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,14,FALSE)),\"\", (VLOOKUP(B2, Events,14,FALSE))),\"\")","v":""}]
[]
["Estimated number of fish lost: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,20,FALSE)),\"\", (VLOOKUP(B2, Events,20,FALSE))),\"\")","v":""}]
[]
["Additional information: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,21,FALSE)),\"\", (VLOOKUP(B2, Events,21,FALSE))),\"\")","v":""}]
[]
["MS action: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,22,FALSE)),\"\", (VLOOKUP(B2, Events,22,FALSE))),\"\")","v":""}]

{"sheet":"Summary17","index":19,"n_rows":36,"n_cols":2,"rows_kept":36,"cut":false,"hidden":true,"merged":[]}
["Mortality Event Report"]
["Mortality Event ID",{"$f":" IF(ISBLANK(CreateSummary!D17),\"\",CreateSummary!D17)","v":""}]
[]
["Site Name:",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,4,FALSE)),\"\", (VLOOKUP(B2, Events,4,FALSE))),\"\")","v":""}]
[]
["Site No:",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,5,FALSE)),\"\", (VLOOKUP(B2, Events,5,FALSE))),\"\")","v":""}]
[]
["Start date of mortality: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,9,FALSE)),\"\", (VLOOKUP(B2, Events,9,FALSE))),\"\")","v":""}]
[" "]
["Period of mortality: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,15,FALSE)),\"\", (VLOOKUP(B2, Events,15,FALSE))),\"\")","v":""}]
[]
["Percentage mortality: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,16,FALSE)),\"\", (VLOOKUP(B2, Events,16,FALSE))),\"\")","v":""}]
[]
["Explained/unexplained:",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,17,FALSE)),\"\", (VLOOKUP(B2, Events,17,FALSE))),\"\")","v":""}]
[]
["Reason (if explained): ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,18,FALSE)),\"\", (VLOOKUP(B2, Events,18,FALSE))),\"\")","v":""}]
[]
["Business Name: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,2,FALSE)),\"\", (VLOOKUP(B2, Events,2,FALSE))),\"\")","v":""}]
[]
["Business Number: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,3,FALSE)),\"\", (VLOOKUP(B2, Events,3,FALSE))),\"\")","v":""}]
[]
["Species: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,13,FALSE)),\"\", (VLOOKUP(B2, Events,13,FALSE))),\"\")","v":""}]
[]
["Water Type: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,8,FALSE)),\"\", (VLOOKUP(B2, Events,8,FALSE))),\"\")","v":""}]
[]
["Weight (site average): ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,11,FALSE)),\"\", (VLOOKUP(B2, Events,11,FALSE))),\"\")","v":""}]
[]
["Weight (affected population average):",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,12,FALSE)),\"\", (VLOOKUP(B2, Events,12,FALSE))),\"\")","v":""}]
[]
["Age: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,14,FALSE)),\"\", (VLOOKUP(B2, Events,14,FALSE))),\"\")","v":""}]
[]
["Estimated number of fish lost: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,20,FALSE)),\"\", (VLOOKUP(B2, Events,20,FALSE))),\"\")","v":""}]
[]
["Additional information: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,21,FALSE)),\"\", (VLOOKUP(B2, Events,21,FALSE))),\"\")","v":""}]
[]
["MS action: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,22,FALSE)),\"\", (VLOOKUP(B2, Events,22,FALSE))),\"\")","v":""}]

{"sheet":"Summary18","index":20,"n_rows":36,"n_cols":2,"rows_kept":36,"cut":false,"hidden":true,"merged":[]}
["Mortality Event Report"]
["Mortality Event ID",{"$f":" IF(ISBLANK(CreateSummary!D18),\"\",CreateSummary!D18)","v":""}]
[]
["Site Name:",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,4,FALSE)),\"\", (VLOOKUP(B2, Events,4,FALSE))),\"\")","v":""}]
[]
["Site No:",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,5,FALSE)),\"\", (VLOOKUP(B2, Events,5,FALSE))),\"\")","v":""}]
[]
["Start date of mortality: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,9,FALSE)),\"\", (VLOOKUP(B2, Events,9,FALSE))),\"\")","v":""}]
[" "]
["Period of mortality: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,15,FALSE)),\"\", (VLOOKUP(B2, Events,15,FALSE))),\"\")","v":""}]
[]
["Percentage mortality: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,16,FALSE)),\"\", (VLOOKUP(B2, Events,16,FALSE))),\"\")","v":""}]
[]
["Explained/unexplained:",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,17,FALSE)),\"\", (VLOOKUP(B2, Events,17,FALSE))),\"\")","v":""}]
[]
["Reason (if explained): ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,18,FALSE)),\"\", (VLOOKUP(B2, Events,18,FALSE))),\"\")","v":""}]
[]
["Business Name: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,2,FALSE)),\"\", (VLOOKUP(B2, Events,2,FALSE))),\"\")","v":""}]
[]
["Business Number: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,3,FALSE)),\"\", (VLOOKUP(B2, Events,3,FALSE))),\"\")","v":""}]
[]
["Species: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,13,FALSE)),\"\", (VLOOKUP(B2, Events,13,FALSE))),\"\")","v":""}]
[]
["Water Type: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,8,FALSE)),\"\", (VLOOKUP(B2, Events,8,FALSE))),\"\")","v":""}]
[]
["Weight (site average): ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,11,FALSE)),\"\", (VLOOKUP(B2, Events,11,FALSE))),\"\")","v":""}]
[]
["Weight (affected population average):",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,12,FALSE)),\"\", (VLOOKUP(B2, Events,12,FALSE))),\"\")","v":""}]
[]
["Age: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,14,FALSE)),\"\", (VLOOKUP(B2, Events,14,FALSE))),\"\")","v":""}]
[]
["Estimated number of fish lost: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,20,FALSE)),\"\", (VLOOKUP(B2, Events,20,FALSE))),\"\")","v":""}]
[]
["Additional information: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,21,FALSE)),\"\", (VLOOKUP(B2, Events,21,FALSE))),\"\")","v":""}]
[]
["MS action: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,22,FALSE)),\"\", (VLOOKUP(B2, Events,22,FALSE))),\"\")","v":""}]

{"sheet":"Summary19","index":21,"n_rows":36,"n_cols":2,"rows_kept":36,"cut":false,"hidden":true,"merged":[]}
["Mortality Event Report"]
["Mortality Event ID",{"$f":" IF(ISBLANK(CreateSummary!D19),\"\",CreateSummary!D19)","v":""}]
[]
["Site Name:",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,4,FALSE)),\"\", (VLOOKUP(B2, Events,4,FALSE))),\"\")","v":""}]
[]
["Site No:",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,5,FALSE)),\"\", (VLOOKUP(B2, Events,5,FALSE))),\"\")","v":""}]
[]
["Start date of mortality: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,9,FALSE)),\"\", (VLOOKUP(B2, Events,9,FALSE))),\"\")","v":""}]
[" "]
["Period of mortality: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,15,FALSE)),\"\", (VLOOKUP(B2, Events,15,FALSE))),\"\")","v":""}]
[]
["Percentage mortality: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,16,FALSE)),\"\", (VLOOKUP(B2, Events,16,FALSE))),\"\")","v":""}]
[]
["Explained/unexplained:",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,17,FALSE)),\"\", (VLOOKUP(B2, Events,17,FALSE))),\"\")","v":""}]
[]
["Reason (if explained): ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,18,FALSE)),\"\", (VLOOKUP(B2, Events,18,FALSE))),\"\")","v":""}]
[]
["Business Name: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,2,FALSE)),\"\", (VLOOKUP(B2, Events,2,FALSE))),\"\")","v":""}]
[]
["Business Number: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,3,FALSE)),\"\", (VLOOKUP(B2, Events,3,FALSE))),\"\")","v":""}]
[]
["Species: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,13,FALSE)),\"\", (VLOOKUP(B2, Events,13,FALSE))),\"\")","v":""}]
[]
["Water Type: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,8,FALSE)),\"\", (VLOOKUP(B2, Events,8,FALSE))),\"\")","v":""}]
[]
["Weight (site average): ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,11,FALSE)),\"\", (VLOOKUP(B2, Events,11,FALSE))),\"\")","v":""}]
[]
["Weight (affected population average):",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,12,FALSE)),\"\", (VLOOKUP(B2, Events,12,FALSE))),\"\")","v":""}]
[]
["Age: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,14,FALSE)),\"\", (VLOOKUP(B2, Events,14,FALSE))),\"\")","v":""}]
[]
["Estimated number of fish lost: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,20,FALSE)),\"\", (VLOOKUP(B2, Events,20,FALSE))),\"\")","v":""}]
[]
["Additional information: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,21,FALSE)),\"\", (VLOOKUP(B2, Events,21,FALSE))),\"\")","v":""}]
[]
["MS action: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,22,FALSE)),\"\", (VLOOKUP(B2, Events,22,FALSE))),\"\")","v":""}]

{"sheet":"Summary20","index":22,"n_rows":36,"n_cols":2,"rows_kept":36,"cut":false,"hidden":true,"merged":[]}
["Mortality Event Report"]
["Mortality Event ID",{"$f":" IF(ISBLANK(CreateSummary!D20),\"\",CreateSummary!D20)","v":""}]
[]
["Site Name:",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,4,FALSE)),\"\", (VLOOKUP(B2, Events,4,FALSE))),\"\")","v":""}]
[]
["Site No:",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,5,FALSE)),\"\", (VLOOKUP(B2, Events,5,FALSE))),\"\")","v":""}]
[]
["Start date of mortality: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,9,FALSE)),\"\", (VLOOKUP(B2, Events,9,FALSE))),\"\")","v":""}]
[" "]
["Period of mortality: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,15,FALSE)),\"\", (VLOOKUP(B2, Events,15,FALSE))),\"\")","v":""}]
[]
["Percentage mortality: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,16,FALSE)),\"\", (VLOOKUP(B2, Events,16,FALSE))),\"\")","v":""}]
[]
["Explained/unexplained:",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,17,FALSE)),\"\", (VLOOKUP(B2, Events,17,FALSE))),\"\")","v":""}]
[]
["Reason (if explained): ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,18,FALSE)),\"\", (VLOOKUP(B2, Events,18,FALSE))),\"\")","v":""}]
[]
["Business Name: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,2,FALSE)),\"\", (VLOOKUP(B2, Events,2,FALSE))),\"\")","v":""}]
[]
["Business Number: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,3,FALSE)),\"\", (VLOOKUP(B2, Events,3,FALSE))),\"\")","v":""}]
[]
["Species: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,13,FALSE)),\"\", (VLOOKUP(B2, Events,13,FALSE))),\"\")","v":""}]
[]
["Water Type: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,8,FALSE)),\"\", (VLOOKUP(B2, Events,8,FALSE))),\"\")","v":""}]
[]
["Weight (site average): ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,11,FALSE)),\"\", (VLOOKUP(B2, Events,11,FALSE))),\"\")","v":""}]
[]
["Weight (affected population average):",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,12,FALSE)),\"\", (VLOOKUP(B2, Events,12,FALSE))),\"\")","v":""}]
[]
["Age: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,14,FALSE)),\"\", (VLOOKUP(B2, Events,14,FALSE))),\"\")","v":""}]
[]
["Estimated number of fish lost: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,20,FALSE)),\"\", (VLOOKUP(B2, Events,20,FALSE))),\"\")","v":""}]
[]
["Additional information: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,21,FALSE)),\"\", (VLOOKUP(B2, Events,21,FALSE))),\"\")","v":""}]
[]
["MS action: ",{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B2, Events,22,FALSE)),\"\", (VLOOKUP(B2, Events,22,FALSE))),\"\")","v":""}]

{"sheet":"Sheet1","index":23,"n_rows":8,"n_cols":9,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
["Site Name","Site No","Average weight of affected population","Species:","Mortality rate recorded(%):","Explained /unexplained:","If explained, select reason(s):","Total mortality during event (if available):","Additional information (e.g. action taken):"]
["Vuia Mor","FS1103","1.19kg","SAL","2.29","Explained","Gill health, treatment",13246,"Gill health issues with some post treatment losses but treatment (Hydrogenperoxide) still ongoing so are expecting further losses."]
["Vuia Mor","FS1103","1.2kg","SAL","11.91","Explained","AGD, Post H202 treatment",null,"Treated with H202, expecting some post treatment loss then reduction in morts"]
["Kirk Noust","FS0645","920g","SAL","11.56","Explained","AGD, post treatment",25760,"Confirmed AGD by Histo and PCR, Treated with H202 last week, expect to have some treatment losses then for numbers to fall"]
["Tabhaigh","FS1297","4.3kg","SAL","3.7","Explained","H2O2 and thermolicer treatment",null,"Vet visited."]
["Tabhaigh","FS1297","4.3kg","SAL","6.57","Explained","H2O2 and thermolicer treatment",null,"Vet visited."]
["Tabhaigh","FS1297","4.3kg","SAL","2.54","Explained","H2O2 and thermolicer treatment",null,"Vet visited."]