Cameron Rentch (cameron@internetthings.com)
2025-01-18 11:29:51

@deleted-U04HFGHL4RW @deleted-U04R23BEW3V please see report created by Brittany. I need this investigated asap:

https://docs.google.com/spreadsheets/d/1N2gX9K2DBf6DCz95AXhLq6SXHwg4bCjSpSR7JERG93g/edit?gid=1445846191#gid=1445846191

Report is showing 138 signed claimants with NO injury and NO property ownership. Criteria requires at least one to be a qualified claimant. I need this back today to have a coversation wtih Jarret and ELG. Super important.

Michigan Pollution Report Property Owners and Diagnosis Data
deleted-U04HFGHL4RW
2025-01-18 12:13:09

Jackson is looking at it now

deleted-U04R23BEW3V
2025-01-18 12:38:55

@Cameron Rentch I am updating the report data sheet now. It will reflect in the counts of the first two tabs. The report was generated using the Form Field question 5 “Do you own residential or commercial property within 3 miles of either facility?” The question on the intake form is phrased as “Did the injured party reside within a 3 mile radius of DTE River Rogue and EES Coke Facility?” I’m going back to check the validity of this question in each file to make the appropriate adjustments

deleted-U04R23BEW3V
2025-01-18 13:25:00

@Cameron Rentch the charts and counts to reflect the relationship between property ownership and diagnosis have been updated. There are no instances of no diagnosis + no property ownership. If you’d like any additional breakdowns of the information, please do not hesitate to ask!

Cameron Rentch (cameron@internetthings.com)
2025-01-18 13:25:18

Thank you @deleted-U04R23BEW3V I will review

🙏:skin_tone_3: deleted-U04R23BEW3V
Cameron Rentch (cameron@internetthings.com)
2025-01-18 13:28:07

@deleted-U04R23BEW3V not sure I am totally understanding the updated numbers I see:

807 total signed claimants 371 total claimants with injury What makes up the remaining 436 claimants?

deleted-U04R23BEW3V
2025-01-18 13:28:46

I was just looking at that. Let me recheck

Cameron Rentch (cameron@internetthings.com)
2025-01-18 13:29:31

I need a breakdown of all of the 807 claimants, how many have an injury, and how many are ONLY property owners (no injury), then the breakdown of the total injured with counts of each diagnosis. Thanks

deleted-U04R23BEW3V
2025-01-18 13:30:23

I had a miscount of Property Owners Only (no injury). It now totals 807

Cameron Rentch (cameron@internetthings.com)
2025-01-18 13:39:08

great thanks @deleted-U04R23BEW3V

deleted-U04R23BEW3V
2025-01-18 13:40:58

@Cameron Rentch no problem! Happy to help!