Here is the report for Connex/Vici for 8.5-8.11:
Lemme know if you have trouble accessing it, it's uploaded to my OneDrive so idk if it'll add restrictions or not
Also, I might have to send you the Connex/Vici call reports tomorrow if that's okay? I'm sick today and working a half day at home and I can't access connex/vici from here or else i'd send them, but I should be in tomorrow morning and can send them then
Hey Malissa, here is the Conyers 1-4 Report 1.13-1.19 π
Gracias!
@deleted-U072JS2NHRQ is there an updated CLJ Military Records report I can send as well? I'm reaching out to Abe today to review
I'm not 100% sure honestly, give me like 20-30 minutes until Brittany gets here so I can confirm with her, that sound ok?
Hey @Malissa brittany's talking to Alan and then will give you an update in a min π
So Alan will be sending you the report shortly she said π:skintone3:
Hey @deleted-U07AD5U5E6S sorry, me and edward are still working on the dash/report reconcile, these leads were all fucked up lol for now, we're almost done, it SHOULD match aside from 2 leads
Paraquat and Camp Lejeune EO now match, we're just waiting on 1 from the Camp Lejeune and 1 from the Firefighting Foam case to finish processing in the dash and then we'll be golden π
He mentioned there's one i should swap in the file?
oh, yeah ignore that sorry! I got it backwards, my brains fried from staring at these excel sheets lol
i swear its like staring at one of those hypnotist black and white circle pictures lol
oh for sure. Actually the hypnotist circle thing might be better
hey @Malissa I can help you out with the BLX reports for 1.20-1.26
are the reports wrong or is it the talk time that's not showing data?
The reports from 1/20-1/26 are wrong. They're missing the correct signup data
if you could just redo that week like you normally do, we're good. I think you were out
I was sick that week, so I think someone else got to them, but I'm in the process of re-doing them now π
do you want me to just send the reports in this chat or put them in the google drive and replace the other files?
no worries! Thank you so much. There are so many bugs going around right now.
okay, they're uploaded here: https://drive.google.com/drive/folders/15WzNtQxtNIdSKGjmLtSGTaVtj1q7lmio
SOME of them have a little bit of a different name, some start with "BLX:" just a heads up, most of them will be changing to that so that I can automate them, but these ones should be good to go! π lemme know if there's anything wrong with them π:skintone3:
Hey @Malissa here's the Conyers 1-4 report, just a heads up there's no new signups this past week, so the 2nd tab will be blank aside from the headers. Just a heads up π:skintone3:
*Thread Reply:* @deleted-U072JS2NHRQ I know you ran this yesterday but can you run this for all time up to today? I want to give Cam the current count. π
*Thread Reply:* omg @Malissa I'm so sorry I like JUST saw this, but yeah I can run it again
*Thread Reply:* @deleted-U072JS2NHRQ no worries!
*Thread Reply:* I've been dealing with some fires lol
Also, I will have to send the Vici/Connex reports tomorrow, I'm sorry! I'm unable to access them today to pull the reports
@Malissa here is the Conyers 1-4 report π:skintone3:
Iβm working on your Conyers 1-4 report now and Iβll have to get you the connex/vici reports when I get back into the office, Iβm sick rn but Iβll see if maybe Dennis can generate the reports for me and I can get em all done and send them over later today
Here is the Conyers 1-4 Report, no new signups the last week, so the 2nd tab will be blank aside from the header row π:skintone3:
@Malissa here is the Conyers 1-4 Report. The 2nd tab is going to be blank, no new signups for the past week.
Hey @Malissa do we still need to send you the Conyers Biolab report? I don't believe we do, but I wanted to double check with you π:skintone3:
have we gotten anything new since the last one?
I don't think we have, but I'd have to double check lol if there's anything new I'll send you another report, if not then we're golden. Thank you! π
Hey @Malissa! I know you sent me a message some time last week about checknig the numbers for a campaign, do you know what campaign that was? I can't find where the message was, but it had to do with one of the BLX reports. I was out sick for most of the week, I'm so sorry for the late response
Oh no! I hope you are feeling better. Iβll have to look when I get in. I canβt remember at the moment. :)
that's totally fine, no rush! Just lemme know whenever you get the chance and I'll look into it for you π
ok @deleted-U072JS2NHRQ it's Medical Malpractice LSA - Ben Crump - BCL - BLX. If there were actually 24 instead of 23, let me know who it was and i'll just tack it on to this week's invoice. π
I will look at that in like 2 minutes, finishing up this weeks reports then I'm on it π«‘
Okay, I updated the report from last week to reflect the person I was missing, it's actually 24, my bad!
You're lookin for Mary Roberts, she should be at the bottom of the middle tab π
ok cool. i'll put her in this week's invoice. π Thank you!
good morning @deleted-U072JS2NHRQ! I don't know if you saw my message in the tip_reporting channel. I lose stuff in slack ALL THE TIME! Anywho, Can you double check the ACTS files? I ask because i've already invoiced some of those weeks. I'd need the last 4 weeks. π
Sorry @Malissa i didn't see it π i hate slack lol but so I was supposed to do the acts reports 2 weeks ago and i completely forgot, the last one i had for acts was from March 17th to April 13th and the next one was supposed to be April 14th to May 11th (i do them every 4 weeks) - but i had to do it this week cuz i remembered that i forgot them.
so how do you do the acts reports? do you do like monthly or every 4 weeks?
i inherited the cadence, which is like every four weeks
so the next one I'd be doing would be May 12th to June 8th, would that work for you? this week I only did it because i forgot to do it 2 weeks ago, so that's my bad - or am I misunderstanding something lol
IT's stupid confusing. no worries. I have an idea
I need the week of April 28th. Let's do April 28th - May 26th. Then we can get them on a monthly cadence instead of whatever this is lol.
okay deal π«‘ i'll get those done today, gimme a couple hours and i'll send em over! for the weeks that you bill for, is it like a pay period sorta? like is it Monday-Sunday that you bill for? does that make sense? or do you bill for Sun-Saturday?
like if you had to bill for 1 week, which days would that have to include
Monday is fine to be honest. I usually Do Monday - Sunday.
gotcha gotcha, that works perfect then π:skintone3: I gotchu i'll send em on monday! thank you!
Hey @Malissa girl! I will send you the acts stuff tomorrow morning, I had to leave cuz of a stupid fire department inspection at my apt today BUT Iβll get the last 4 weeks to you tomorrow early morning π«‘
no worries @deleted-U072JS2NHRQ! Hope all is ok
@Malissa here are the ACTS Reports for 4.28.25-5.25.25 π:skintone3: We'll start the 4 week cycle over fresh from 5.26.25 onwards π
nice! Thank you so much @deleted-U072JS2NHRQ!
@Malissa just in case - i'm doing 5.12-6.8 this time for the ACTS reports, can you confirm if that's correct?
Hi @deleted-U072JS2NHRQ I think it should be 5/26 - 6/20 π
oh, cuz I sent you 4.28-5.25 last time smh that's my bad lol
okay we have a priority task from Cam to work on for today/tomorrow, i'll send the extra 2 weeks to you on like thursday, deal? π
@Malissa do you want me to do the ACTS reports today or next monday? I'm trying to get a feel for it, cuz I believe this is 4 weeks since the last time I got you one but it wouldn't include the next couple days. Idk if you wanna do every 4 weeks or every 1st monday of a new month
I hate the every 4 weeks thing lol
Hey @Malissa, these reports that we send you on mondays (the AWD reports) - what happens to those? Are those specifically internal or do you share them with the firm? We're thinking of transforming these into like a dashboard, but we want to know if anybody else is downstream of you.
For example, if you give the reports to the firm, what do they do with them, do they have automations in place that rely on these reports, etc. That's what we're trying to figure out currently
This would also affect the BLX and ACTS reports I send you as well, so I might be asking follow-up questions about this in the future if that's okay π
So what i do is i take the raw data and put that in a spreadsheet for them. I like having a pivot table so they can see the status. Then i create a financial page so the firm can see where they are with their spend. So i share it all with the firm. I really just need the raw data of e-signs and pivot table
i have something i created for AWD so it's just plug and play for me
AWD doesn't have to be anything special. What greg gets is fine.
as for BLX and ACTs, i send them the backup file you guys create and an invoice. that's pretty much it
hahaha spongebob. nice
thank you! I think the spongebob really like shows the essence and the vibe of this place as a whole lol
and gotcha gotcha, so like would it be easier or harder for YOU if we had a dashboard that's exactly like the reports we send you, you'd just have to export from the dash and then do your magic - I BELIEVE we'd be able to make a pivot table within the dashboard, but idk how that would export, so I'll have to experiment a little.
we're having a preliminary meeting within our own dept to talk about this a little and see who we'd have to meet with (you being one of them) so i'm just trying to get a feel for what your needs are so that we can fulfill them easier. So we'll probably be reaching out to you some time later, but thank you for the information! β€οΈ
We'd probably need more information on how the financial page is made, cuz if it's just copy pasting the numbers in your thingy then the dashboard should help I hope - we're just up to like 200+ reports every monday and we need to figure out how to NOT do them manually lol
I'm always about working smarter not harder. So if it's something that helps you guys work smarter and is just as accurate, i'm down. I also firmly believe that if we try it and it doesn't work, we can go back to the old way and try again.
are you saying we all work at the Krusty Krab? lol
okay @Malissa sorry to constantly bug you about these. I'm going to do the ACTS reports, would you like me to do them for just the whole month of July? July 1-July 31? or would just the last 4-5 weeks work? 5 weeks would be June 30th to August 3rd
let's do 6/30 - 8/3
Hey @Malissa for these two reports that you get for Cams monday reports:
Secondary Interview - Completed means that the interview is completed Secondary Interview - Sent means that the interview/all data has been sent to the firm