35 Days: Greater than, less than, balance, range: SDS constituent cleanup, part 2
For constituent percentages, who knows what they add up to? The goal is not to have missing ones
I already mentioned maintaining a field for Numeric Percent for each SDS constituent (whether it has a valid CAS Number or not at this stage).
There are 4 special cases where you will calculate (assume) a value to put in that NumPct field
With SDS constituent percentages, who knows what the real sum is?
Constituent Cleanup Special Cases:
Greater Than or > symbol: In this case, you don’t know the value, you only know that it’s greater than a certain number. The easiest option is to default 100 for the NumPct for these. If that constituent doesn’t exceed threshold determinations at 100%, you can wait and clean it up after March 2nd. If you want to be a little more precise, and if some/any other constituents have exact percentages, you can take the difference between 100 and the sum of those exact pecentages and use that value.
For example,, if a constituent percentage is Greater than 30 which might be represented >30 on the SDS, and there are 2 other constituents with exact percentages, one at 10% and one at 30%, you could default 60 for the NumPct of the Greater than > constituent (100-10-30=60). You can see that depending on the other constituent percentages this can lead to some fancy math in a hurry, why I suggest defaulting 100 on this first pass.
LessThan or < symbol: This one is easiest, take the less than symbol off and use that value for the NumPct., You don’t know what the actual constituent percent is, but you know it’s not any more than that less than value.
Range, between a lower and an upper value: This one is also easy on your first pass through threshold determinations, we would put the higher value in the NumPct field. Again, if it doesn’t trip thresholds you can review it in more depth later. For example, if the constituent range was 30-60 percent, we would enter 60 in the NumPct field.
While it is valid to take the average of these values in some situations, we wait to do that until we see that it would affect what we are reporting in some way.
Balance: You can either just default 100 for this, or you can add up what the known constituent percentages are and subtract those from 100 (if it’s easy and obvious you might do it, if complicated default 100 and come back to it if it would be meaningful.
For example, if you have a >60 constituent percentage, for the Balance you could use 40. It might be less than that if the greater than constituent is actually 99, but you don’t know that.
Another example, if you have a Less than 10 percent constituent, you would default 100 in the NumPct field associated with the Balance constituent.
For a Range, you could subtract from the lower value, so for example if you have a constituent with a range of 30-60 percent, you could use 70 percent for the balance.
(All of these examples assume only 1 other constituent besides the Balance one.
You can see that you could get into some interesting math if there are multiple constituents with more than one of these special cases.
More tomorrow, here’s to March 2nd!
Community outreach: How do you manage these kinds of consituent percentages?
#SARA312 #SARATierII #SARATier2 #EPCRA #EGLE #March1EPAReportDeadline #ThresholdDeterminations
Michigan EGLE links from all 3 webinars of 2022 SARA 312 virtual training courses:
I’m keeping these links for awhile because they are so useful.I’ll post the session 3 recording info when it becomes available. You can sign on and listen even if you didn’t sign up for the webinar series.
RECORDING LINK FOR SESSION 2: Wed Jan 19, 2022.
Really good example on batteries. This is the “in the weeds” how to conduct your threshold determinations episode: https://attendee.gotowebinar.com/recording/4027906237723673347
I talked to Mike Young, one of the presenters, right after the first webinar. He said that it’s not unusual for them to take phone calls from people from other states (with the warning to confirm that your state doesn’t have differences in their requirements compared to Michigan).
RECORDING LINK FOR SESSION 1:
https://attendee.gotowebinar.com/recording/7957790593170499843
The 3rd and last of the Michigan Environment, Great Lakes and Energy EGLE EPCRA SARA Tier2 webinars has posted, this one was around the details for filling out the Tier2 Manager Software (which is specific to Michigan).
RECORDING LINK FOR SESSION 3: https://attendee.gotowebinar.com/recording/2763075340284995085
If your state uses a different software program there may be some differences, but this webinar will probably also cover how to determine the Hazard Ratings, how to enter Locations, and other details associated with report submission. I’ll post the replay when it becomes available.
PRESENTATION: (I wasn’t able to attach a copy of the presentations, email the link below and they will send them to you)
SARA TITLE III – TIER II REPORTING WEBSITE: http://www.michigan.gov/sara
MICHIGAN FACILITIES’ GUIDE TO SARA TITLE III: https://www.michigan.gov/documents/deq/deq-oea-saraguidebook_509720_7.pdf
CONTACT INFORMATION:
Mike Young and Adam Pohl
517-284-7272
