• 4 Posts
  • 120 Comments
Joined 2 years ago
cake
Cake day: June 12th, 2023

help-circle

  • What I do specifically is called wastewater based epidemiology. While the term has been around for a few decades, it really took off in concordance with COVID. Previous PCR techniques like qPCR are heavily inhibited by co-elutors from wastewater extract. We use digital PCR which is way more resistant to inhibition due to the partitioning. We are using cutting edge technology and our R&D dept is constantly looking into additional targets we can test for. As a company we also do some non-pcr-based wastewater testing (drugs of abuse by LC/MS is a big one).

    Additionally we also do next gen sequencing to track the COVID variants in communities.














  • I legitimately use this line in one of my scripts because range.find returns an error of the value is not found. The use case is taking a 2d matrix saved as an array, with data collected from multiple excel tabs and rearranging it for a CSV upload into Salesforce. The initial array contains values that the rest of the data does not have, so when I search for a non existent value, I can skip the error.

    Of course vba COULD just implement try/catch statements and that’d be so much cleaner, but alas.