Ryan (ryan@themedialab.agency)
2024-11-14 12:45:51

Can you guys update the new red rows right now, these are the october ones that are new since we created the sheet.

https://docs.google.com/spreadsheets/d/1LrGlUb3fCB9LknQSbUBPSNAwAKSqpMxOeW4LntqLDlA/edit?gid=631439208#gid=631439208&range=129:138

Malissa (malissa@shield-legal.com)
2024-11-14 12:51:08

@deleted-U06GD22CLDC i think the stuff in red is definitely for you. I don't have the points info and such

Ryan (ryan@themedialab.agency)
2024-11-14 12:51:33

Thanks, just making sure. @deleted-U06GD22CLDC, appreciate the quick turnaround. In middle of HEAVY sql

deleted-U06GD22CLDC
2024-11-14 12:53:57

Yeah it's all taken care of!

deleted-U06GD22CLDC
2024-11-14 12:57:28

I do need to ask Tony about one as I have not received communication about point values on Mortgage Race

deleted-U06GD22CLDC
2024-11-14 12:59:06

Ok should be up to date now

Ryan (ryan@themedialab.agency)
2024-11-14 13:16:03

@deleted-U06GD22CLDC, thank you. And one more round for all active Case Types in November, this will have us up to date on ESIGN prices "bulk update" into the TIP App for you and @Malissa.

https://docs.google.com/spreadsheets/d/1LrGlUb3fCB9LknQSbUBPSNAwAKSqpMxOeW4LntqLDlA/edit?gid=631439208#gid=631439208

deleted-U06GD22CLDC
2024-11-14 14:02:24

All up to date on my end

Ryan (ryan@themedialab.agency)
2024-11-14 14:02:56

Excellent. I'll grab you and Malissa once done and get you both into your routine process for December and forward.

Ryan (ryan@themedialab.agency)
2024-11-14 14:02:58

Thanks guys

deleted-U06GD22CLDC
2024-11-14 14:03:30

I did want to mention I tried to update this in your tool a little while back, and it gave me an error. I can't remember if I communicated that to you or not.

Ryan (ryan@themedialab.agency)
2024-11-14 14:03:40

Try now, it's fixed.

Ryan (ryan@themedialab.agency)
2024-11-14 14:03:46

Brian fixed it this AM.

Ryan (ryan@themedialab.agency)
2024-11-14 14:03:55

If anything goes funky, ping me and @Brian Hirst

deleted-U06GD22CLDC
2024-11-14 14:04:04

Ok sounds good

deleted-U06GD22CLDC
2024-11-14 14:04:27
image.png
Ryan (ryan@themedialab.agency)
2024-11-14 15:42:51

@deleted-U06GD22CLDC @Malissa, hop on the huddle, quick explainer

Ryan (ryan@themedialab.agency)
2024-11-14 15:44:05

@deleted-U06GD22CLDC, join real fast

deleted-U06GD22CLDC
2024-11-14 15:53:33

Just got out of the restroom

deleted-U06GD22CLDC
2024-11-14 15:53:39

I'm available now

Ryan (ryan@themedialab.agency)
2024-11-14 15:54:07

Malissa will show you, had to run off to next "show and tell"

deleted-U06GD22CLDC
2024-11-14 15:54:13

Ok.

Malissa (malissa@shield-legal.com)
2024-11-14 15:54:50

yeah i'll fill you in

Malissa (malissa@shield-legal.com)
2024-11-14 15:55:35

That google sheets link Ryan posted is your friend. @deleted-U06GD22CLDC

deleted-U06GD22CLDC
2024-11-14 15:56:14

Are you wanting me to update this sheet instead of the tool?

Malissa (malissa@shield-legal.com)
2024-11-14 15:56:27

we're going to use it to update the tool

Malissa (malissa@shield-legal.com)
2024-11-14 15:57:01

the sheet is going to give us a way scan and find what we need to edit. I'll send you some screenshots in a minute. 🙂

Malissa (malissa@shield-legal.com)
2024-11-14 16:54:29

hey @Ryan what's the deadline?

Ryan (ryan@themedialab.agency)
2024-11-14 16:55:36

End of month, have everything up-to-date and accurate, and then each month you make the updates to the ones that Cameron changes the prices.

Ryan (ryan@themedialab.agency)
2024-11-14 16:56:43

Flatirons the exception, those should be zeroed out for revenue when a POST / ASA right Malissa?

Malissa (malissa@shield-legal.com)
2024-11-14 16:57:42

yeah Flatirons is a different animla

Malissa (malissa@shield-legal.com)
2024-11-14 16:57:44

animal

Ryan (ryan@themedialab.agency)
2024-11-14 16:58:08

Great just update those too b

deleted-U06GD22CLDC
2024-11-19 16:25:25

I have reviewed all of the case types in the sheet you had shared to make sure that the inboundpayrollcostper, outboundscreeningpayrollcostper, outboundintakepayrollcostper, processingpayrollcostper, and asapayrollcost_per fields were the same as the spreadsheet, and they all match up. No adjustments were made. In addition, I noticed 2 case types in the spreadsheet that were not in the tool: ACTS Juv VSS Documents ACTS Adult VSS Documents

Malissa (malissa@shield-legal.com)
2024-11-19 16:26:31

those two got renamed

Malissa (malissa@shield-legal.com)
2024-11-19 16:26:42

let me see if i can find it

Malissa (malissa@shield-legal.com)
2024-11-19 16:27:23

CA Juvenile Hall Abuse DOCS - ACTS - ACTS - ACTS Chowchilla Womens Prison Abuse DOCS - ACTS - ACTS - ACTS

deleted-U06GD22CLDC
2024-11-19 16:37:12

Both are accurate according to the data in the sheet, other than the case type names.