Environmental testing lab

Briarwick Landing Environmental Lab · Environmental testing lab · Duluth, MN

Bram Benvenuti is the lab manager at Briarwick Landing Environmental Lab, an environmental testing lab, and he uses this to run every sample from kickoff to handoff on time, with each project's samples and fees counted up from the bench.

AgricultureProjectsLinked tables4 tables · 6 views · 1 form · 1 digest · 1 document · 1 notification · 1 agent
Use this template

All samples

Samples
SampleSample IDProjectMatrixAnalysisBench statusCollected
Outfall 002 grabSMP-26-1002Ironwood Bay outfall monitoring, third quarterSurface waterBacteria (E. coli)ReportedJul 17, 2026
Outfall 001 grabSMP-26-1001Ironwood Bay outfall monitoring, third quarterSurface waterNutrientsReportedJul 17, 2026
Outfall 001 metalsSMP-26-1003Ironwood Bay outfall monitoring, third quarterSurface waterMetals panelReportedJul 28, 2026
Outfall 002 metalsSMP-26-1004Ironwood Bay outfall monitoring, third quarterSurface waterMetals panelReportedJul 28, 2026
MW-1 purge sampleSMP-26-1005Pelican Marsh well surveyGroundwaterPetroleum hydrocarbonsReportedAug 4, 2026
MW-2 purge sampleSMP-26-1006Pelican Marsh well surveyGroundwaterPetroleum hydrocarbonsReportedAug 4, 2026
MW-3 purge sampleSMP-26-1007Pelican Marsh well surveyGroundwaterMetals panelReportedAug 4, 2026
Boring B-1 at 4 ftSMP-26-1008Redcedar Phase II soil assessmentSoilPetroleum hydrocarbonsReportedAug 18, 2026
Boring B-2 at 4 ftSMP-26-1009Redcedar Phase II soil assessmentSoilPetroleum hydrocarbonsReportedAug 18, 2026
Boring B-3 at 6 ftSMP-26-1010Redcedar Phase II soil assessmentSoilMetals panelReportedAug 21, 2026
Lagoon cell 1 compositeSMP-26-1012Northfork lagoon nutrient studyWastewaterNutrientsReportedAug 24, 2026
Lagoon cell 2 compositeSMP-26-1013Northfork lagoon nutrient studyWastewaterNutrientsReportedAug 24, 2026

21 more rows

Tables

Samples

33 sample rows · 12 columns

Every sample from the day it is logged in to the day its results are reported.

SampleSample IDProjectMatrixAnalysisBench statusCollected
Outfall 002 grabSMP-26-1002Ironwood Bay outfall monitoring, third quarterSurface waterBacteria (E. coli)ReportedJul 17, 2026
Outfall 001 grabSMP-26-1001Ironwood Bay outfall monitoring, third quarterSurface waterNutrientsReportedJul 17, 2026
Outfall 001 metalsSMP-26-1003Ironwood Bay outfall monitoring, third quarterSurface waterMetals panelReportedJul 28, 2026
Outfall 002 metalsSMP-26-1004Ironwood Bay outfall monitoring, third quarterSurface waterMetals panelReportedJul 28, 2026
MW-1 purge sampleSMP-26-1005Pelican Marsh well surveyGroundwaterPetroleum hydrocarbonsReportedAug 4, 2026
MW-2 purge sampleSMP-26-1006Pelican Marsh well surveyGroundwaterPetroleum hydrocarbonsReportedAug 4, 2026
MW-3 purge sampleSMP-26-1007Pelican Marsh well surveyGroundwaterMetals panelReportedAug 4, 2026
Boring B-1 at 4 ftSMP-26-1008Redcedar Phase II soil assessmentSoilPetroleum hydrocarbonsReportedAug 18, 2026
Boring B-2 at 4 ftSMP-26-1009Redcedar Phase II soil assessmentSoilPetroleum hydrocarbonsReportedAug 18, 2026
Boring B-3 at 6 ftSMP-26-1010Redcedar Phase II soil assessmentSoilMetals panelReportedAug 21, 2026
Lagoon cell 1 compositeSMP-26-1012Northfork lagoon nutrient studyWastewaterNutrientsReportedAug 24, 2026
Lagoon cell 2 compositeSMP-26-1013Northfork lagoon nutrient studyWastewaterNutrientsReportedAug 24, 2026

21 more rows

Projects

11 sample rows · 13 columns

Each client job from kickoff to handoff, with the samples and fees rolled up from the bench.

ProjectProject numberClientProject stageKickoffHandoff dueProject lead
Ironwood Bay outfall monitoring, third quarterPRJ-26-201Ironwood Bay Sanitary DistrictHanded offJul 13, 2026Sep 17, 2026Ingrid Tallwater
Pelican Marsh well surveyPRJ-26-202Pelican Marsh Water AuthorityHanded offJul 29, 2026Sep 22, 2026Corwin Halvorsrud
Redcedar Phase II soil assessmentPRJ-26-203Redcedar Environmental ConsultingReportingAug 10, 2026Oct 8, 2026Ingrid Tallwater
Northfork lagoon nutrient studyPRJ-26-204Northfork Dairy CooperativeReportingAug 17, 2026Oct 12, 2026Ingrid Tallwater
Lakeshore drinking water compliance roundPRJ-26-205Lakeshore Township UtilitiesIn analysisSep 3, 2026Oct 15, 2026Corwin Halvorsrud
Wolf Run Creek bacteria watchPRJ-26-208Wolf Run Creek Watershed AssociationIn analysisSep 21, 2026Oct 19, 2026Dashiell Ferncliffe
Tamarack Ridge stormwater pond sedimentsPRJ-26-206Tamarack Ridge DevelopmentsIn analysisSep 7, 2026Oct 21, 2026Ingrid Tallwater
Birchline orchard runoff pesticide screenPRJ-26-207Birchline OrchardsIn analysisSep 15, 2026Oct 26, 2026Corwin Halvorsrud
Cedar Fork school well testingPRJ-26-211Cedar Fork School DistrictKickoffOct 2, 2026Nov 2, 2026Dashiell Ferncliffe
Ironwood Bay outfall monitoring, fourth quarterPRJ-26-209Ironwood Bay Sanitary DistrictSamplingSep 25, 2026Nov 16, 2026Ingrid Tallwater
Hollis Marsh restoration baselinePRJ-26-210Wolf Run Creek Watershed AssociationSamplingSep 29, 2026Nov 30, 2026Corwin Halvorsrud

Clients

9 sample rows · 9 columns

The utilities, farms, consultancies and townships that send samples to the lab.

ClientClient codeKind of clientContactContact phoneClient sinceBilling terms
Birchline OrchardsCL-107FarmOdette Lindqvist-Roy(218) 555-0167Oct 5, 2025Net 15
Cedar Fork School DistrictCL-109MunicipalityWinifred Achterlonie(218) 555-0169Oct 5, 2025Net 30
Ironwood Bay Sanitary DistrictCL-101Utility districtMarguerite Delacorte-Pyne(218) 555-0161Oct 5, 2020Net 30
Lakeshore Township UtilitiesCL-105MunicipalityPriyanka Fennimore(218) 555-0165Oct 5, 2019Net 30
Northfork Dairy CooperativeCL-104FarmLeopold Ashbourne(218) 555-0164Oct 5, 2023Net 30
Pelican Marsh Water AuthorityCL-102Utility districtEverett Thornquist(218) 555-0162Oct 5, 2021Net 30
Redcedar Environmental ConsultingCL-103ConsultancyAdaeze Vandermolen(218) 555-0163Oct 5, 2022Net 15
Tamarack Ridge DevelopmentsCL-106DeveloperCassius Ngata-Holm(218) 555-0166Oct 5, 2024Prepaid
Wolf Run Creek Watershed AssociationCL-108NonprofitTobias Ekwueme(218) 555-0168Oct 5, 2023Net 30

Forms and booking

Log in a sample

Form
Log in a sampleThe sheet the receiving technician fills in when a cooler arrives at the bench.
What is written on the bottle? *
What lab ID did you stick on it? *
Which project is it part of? *
What was sampled? *Surface waterGroundwaterDrinking waterWastewaterSoilSediment
What test does the client want? *Metals panelNutrientsBacteria (E. coli)Petroleum hydrocarbonsPesticide screen
Which day was it collected?
Which day did it reach the lab?
When must the results go out?
Log it in

Also included

  • Samples on the instrumentDigest
  • Sample due tomorrowNotificationNudges the assigned chemist a day before a sample is due out.
  • Results cover letterDocumentThe note that rides on top of the data package at handoff.