Cameron Rentch (cameron@internetthings.com)
2024-11-19 22:31:58

@Nicholas McFadden @Ryan @deleted-U04HFGHL4RW please reconcile and send me a full final count of all AWD Wagstaff Paraquat. I need tomorrow asap. Please ensure the counts match TIP Shield AWD received

I believe we are quite a bit off still here. Thank you

Nicholas McFadden (nickmcfadden@shield-legal.com)
2024-11-19 22:33:03

We will do a full audit tomorrow morning

Nicholas McFadden (nickmcfadden@shield-legal.com)
2024-11-19 22:37:52

@deleted-U04HFGHL4RW will you still be at the old office tomorrow morning or at the new one?

🙌 Cameron Rentch
Ryan (ryan@themedialab.agency)
2024-11-20 07:52:22

@deleted-U04HFGHL4RW @Nicholas McFadden, here is what we have in the dashboards:

image.png
👍 Nicholas McFadden
Nicholas McFadden (nickmcfadden@shield-legal.com)
2024-11-20 09:38:09

@Ryan thanks we will use this in the audit this morning

deleted-U04HFGHL4RW
2024-11-20 09:38:19

I will review this morning and work with to make sure it matches

Nicholas McFadden (nickmcfadden@shield-legal.com)
2024-11-20 11:44:41

@Ryan can you send me the lead IDs associated with your 79? Tony and I are getting close to finishing our alignment.

Ryan (ryan@themedialab.agency)
2024-11-20 11:49:01

@Nicholas McFadden https://lookerstudio.google.com/s/pVPl1R8vctg

👍 Nicholas McFadden
Nicholas McFadden (nickmcfadden@shield-legal.com)
2024-11-20 12:20:27

@here we are able to align to Ryan's 79.

Two were never sent to Wagstaff, somehow didn't get sent by MPA and only went to patsy and I's gmail inbox which is really strange so we are sending those today. Doesn't seem to have affected anything else and this wont occur again now that we are on GCP.

There are 2 left in "Signed e-Sign Final" but the process we had established was to have Luis tell us when he had reviewed the finals so we could put them to "Signed e-Sign Re-Triggered" as an extra audit step. However, he never notified us that they were ready to go.

The final 3 were the same situation but they were left in "Signed e-sign QA WIP" or are truly "in process" still.

🙏:skin_tone_4: Ryan
deleted-U04HFGHL4RW
2024-11-20 13:49:28

Nick has 76 on his sheet. We have 3 cases that are pending getting the affidavit signed before we can send in. That's a total of 79. That is the number that Ryan has as well.

Cameron Rentch (cameron@internetthings.com)
2024-11-20 14:20:39

@deleted-U04HFGHL4RW fyi Carter is showing 70 recd in total that “meet criteria”. So we are off by 9, which is a huge number.

Cameron Rentch (cameron@internetthings.com)
2024-11-20 14:34:20

@deleted-U04HFGHL4RW @Nicholas McFadden here are issues

https://docs.google.com/spreadsheets/d/1Ra329rih0P-xhvK0UABfyyC-oTH7MVhn/edit?usp=sharing&ouid=103192174532922309240&rtpof=true&sd=true|https://docs.google.com/spreadsheets/d/1Ra329rih0P-xhvK0UABfyyC-oTH7MVhn/edit?usp=sharing&ouid=103192174532922309240&rtpof=true&sd=true

Everything highlighted in yellow have been kicked back. Reasons are listed.

Tony - get these updated and fixed asap. Get any no contacts resolved asap.

Nick - pull the ones that show incomplete and get cured properly.

Get this all done today please.

Paraquat-AWD-Wagstaff-Shield_Legal-All Fields All Time Through 11.20.24.xlsx
👍 Nicholas McFadden
Ryan (ryan@themedialab.agency)
2024-11-20 15:08:21

@deleted-U04HFGHL4RW, if any of these 9 get DECLINED, let me know.

deleted-U04HFGHL4RW
2024-11-20 15:13:41

Steve Scoggan and David Warren were resent to them today. Douglas Langer, Shirley Ballentine and Larry German need to sign the affidavit before we can send in.

They are declining David Messner, Gerry Degree and Richard Vallery JR. I will be declining these 3 now. We are actively reaching out to the ones that they have not been able to reach.

Ryan (ryan@themedialab.agency)
2024-11-20 15:16:05

@deleted-U04HFGHL4RW, confirming DQ of 577202,535500,587106

deleted-U04HFGHL4RW
2024-11-20 15:16:50

Correct, I have marked them as signed and Declined in the system .

Ryan (ryan@themedialab.agency)
2024-11-20 15:17:00

What about Samuel Calvary?

Ryan (ryan@themedialab.agency)
2024-11-20 15:17:14

576109

Ryan (ryan@themedialab.agency)
2024-11-20 15:17:20

@deleted-U04HFGHL4RW ☝️:skintone4:

deleted-U04HFGHL4RW
2024-11-20 15:19:22

I just declined 576109 as well.

Ryan (ryan@themedialab.agency)
2024-11-20 15:19:39

ty

Nicholas McFadden (nickmcfadden@shield-legal.com)
2024-11-20 15:21:03

Reasoning on Calvary?

deleted-U04HFGHL4RW
2024-11-20 15:21:47

On the sheet, it just says closed DQ.

Ryan (ryan@themedialab.agency)
2024-11-20 15:23:44

@here, those 4 have been removed from TIP financial_log and SL financials.

Nicholas McFadden (nickmcfadden@shield-legal.com)
2024-11-20 17:10:28

@Cameron Rentch we sent two that they hadn't received but there is nothing to cure at the moment until we hear back from the leads. Jackson is trying to contact and/or collecting the remaining info and if/when he does we will send it to Wagstaff.

Cameron Rentch (cameron@internetthings.com)
2024-11-20 17:12:12

@deleted-U04HFGHL4RW so I dont have to do the work, please open the attached sheet, and make notes under column C (TIP/Shield Notes). Do this asap please. Make sure it is clear if it is one we are rejecting.

Cameron Rentch (cameron@internetthings.com)
2024-12-01 14:19:49

@deleted-U04HFGHL4RW @Ryan DL Flatirons Ethylene Oxide Dash shows 19 signed Report attached shows 23

Need this reconcield immediately. Thanks

Cameron Rentch (cameron@internetthings.com)
2024-12-01 14:21:19

I need to run analysis of costs based on facilities and cant do until I know it's accurate

Ryan (ryan@themedialab.agency)
2024-12-01 14:24:35

Shows 19 in both TIP and Shield Dashboards too @here

image.png
deleted-U04HFGHL4RW
2024-12-01 16:20:29

@Cameron Rentch 4 of these on the report are signed and declined. The report was pulled wrong. You can filter them out.

Cameron Rentch (cameron@internetthings.com)
2024-12-01 16:44:25

@deleted-U04HFGHL4RW Dennis from Brittany’s team pulled the report. I’ll ask him tmrw.

Cameron Rentch (cameron@internetthings.com)
2025-01-12 15:37:55

@Ryan @deleted-U04HFGHL4RW @Nicholas McFadden see attached sheet Column "L" and make adjustments to the dash accordingly.

Ryan (ryan@themedialab.agency)
2025-01-12 15:53:41

@Cameron Rentch , looking at it now.

Ryan (ryan@themedialab.agency)
2025-01-12 15:56:52

On AFFF tab I see 2 to check for decline 257196 Boniedot David 259654 Hough David

Ryan (ryan@themedialab.agency)
2025-01-12 15:57:29

and Paraquat I see 1: 256367 Ledet Peggy

Ryan (ryan@themedialab.agency)
2025-01-12 15:57:38

I will check dashes now

Cameron Rentch (cameron@internetthings.com)
2025-01-12 15:57:51

correct

Ryan (ryan@themedialab.agency)
2025-01-12 16:02:23

@Cameron Rentch, he is still signed in LawRuler, so @deleted-U04HFGHL4RW dq him, David Boniedot 469248

Ryan (ryan@themedialab.agency)
2025-01-12 16:04:17

@deleted-U04HFGHL4RW

Same for https://tortintakeprofessionals.lawruler.com/update-lead.aspx?lead=552806 David Hough but Peggy Ledet is declined already https://tortintakeprofessionals.lawruler.com/update-lead.aspx?lead=445105

Ryan (ryan@themedialab.agency)
2025-01-12 16:34:27

@here, from the email sheet, and Tony blurb, and the sheet above, here is who I have declined in the system before we usually do on Monday through Fridays by 10AM PT.

FYI @deleted-U06C7A8PVLJ, there might be a few more from the DECLINE report that does include "Signed & DECLINED" and "Signed & Billable Declined by Firm". And be sure to remove from tipfinanciallog their POST RETAINER files, that were declined in the process.

  1. 349478
  2. 354421
  3. 355441
  4. 364283
  5. 364733
  6. 380081
  7. 418216
  8. 456586
  9. 460069
  10. 469248
  11. 552806
  12. 555123
  13. 556359
  14. 556621
image.png