Meeting Title: ABC zipcode planning Date: 2026-02-02 Meeting participants: Casie Aviles, Samuel Roberts, Mustafa Raja, Amber Lin
WEBVTT
1 00:00:10.310 ⇒ 00:00:11.340 Samuel Roberts: Hey…
2 00:00:14.080 ⇒ 00:00:15.570 Casie Aviles: Hey, Sean, good morning.
3 00:00:16.540 ⇒ 00:00:17.360 Samuel Roberts: Good morning.
4 00:00:20.560 ⇒ 00:00:22.800 Samuel Roberts: Did you have a good weekend? We didn’t really catch up during the…
5 00:00:23.570 ⇒ 00:00:28.880 Casie Aviles: Oh… My weekends are usually boring, just…
6 00:00:29.020 ⇒ 00:00:32.670 Casie Aviles: Stay in and watch movies with my mom.
7 00:00:32.840 ⇒ 00:00:40.070 Samuel Roberts: That is not a problem. I love a good, boring weekend. Don’t… don’t… you know, boring is the wrong word. Relaxing, maybe, is a better word.
8 00:00:40.290 ⇒ 00:00:41.799 Casie Aviles: Yes, yes.
9 00:00:42.610 ⇒ 00:00:46.550 Samuel Roberts: No, those are the best. I mean, especially as I’ve gotten older, the more I’m like, you know.
10 00:00:46.920 ⇒ 00:00:50.370 Samuel Roberts: I was home all day with my son on Saturday, and we just hung out, and…
11 00:00:50.940 ⇒ 00:00:52.880 Samuel Roberts: Played, like, on the floor, and…
12 00:00:53.110 ⇒ 00:00:53.690 Casie Aviles: Oh, yeah.
13 00:00:53.690 ⇒ 00:00:58.119 Samuel Roberts: Played around. When he was napping, I played with Claudebot a little bit, trying to get that set up, and…
14 00:00:59.240 ⇒ 00:00:59.950 Samuel Roberts: fun day.
15 00:01:00.410 ⇒ 00:01:01.530 Samuel Roberts: Hey, Mustafa.
16 00:01:01.530 ⇒ 00:01:04.979 Casie Aviles: Yeah, I don’t know, on weekends, I just try to, like.
17 00:01:05.319 ⇒ 00:01:09.869 Casie Aviles: decompress and relax as much as I can, and not think about any other thing.
18 00:01:10.340 ⇒ 00:01:15.939 Samuel Roberts: Yeah, I… I get that, believe me, I… that’s, like, yesterday was a much different, like…
19 00:01:16.930 ⇒ 00:01:19.990 Samuel Roberts: waxing. I got some stuff done around the house, but nothing…
20 00:01:20.300 ⇒ 00:01:21.060 Casie Aviles: Yeah.
21 00:01:24.360 ⇒ 00:01:25.990 Mustafa Raja: How was the CloudBot?
22 00:01:27.160 ⇒ 00:01:29.010 Mustafa Raja: Oh, what’s it named now, actually?
23 00:01:29.010 ⇒ 00:01:30.750 Samuel Roberts: It was interesting, Hwa.
24 00:01:31.540 ⇒ 00:01:33.790 Mustafa Raja: So it’s named Claw only.
25 00:01:34.410 ⇒ 00:01:35.930 Samuel Roberts: Open Claw.
26 00:01:35.930 ⇒ 00:01:37.670 Mustafa Raja: Open car, okay, okay.
27 00:01:37.670 ⇒ 00:01:39.349 Samuel Roberts: Yeah, like, like Open Code, or, you know.
28 00:01:39.350 ⇒ 00:01:40.299 Mustafa Raja: Yeah, yeah.
29 00:01:40.790 ⇒ 00:01:46.779 Samuel Roberts: Yeah, it was interesting. I can tell you guys more about it later, but I was very careful with it, because I didn’t want to give it access to anything crazy.
30 00:01:46.780 ⇒ 00:01:51.200 Mustafa Raja: Yeah, yeah, I heard you… or actually, I saw a person.
31 00:01:51.340 ⇒ 00:01:57.420 Mustafa Raja: on Twitter that, it bought some $2,000 of, subscriptions for a person.
32 00:01:57.420 ⇒ 00:01:57.970 Samuel Roberts: Yeah.
33 00:01:59.650 ⇒ 00:02:01.699 Mustafa Raja: Not this much. It does some crazy stuff.
34 00:02:01.700 ⇒ 00:02:05.909 Samuel Roberts: Yeah, no, I set it up on a virtual machine on another server.
35 00:02:06.080 ⇒ 00:02:13.530 Samuel Roberts: And then gave it just access to, like, use a model, just so I could chat with it and get it running. I didn’t give it access to anything else yet, so we’ll see if I actually trust it.
36 00:02:14.510 ⇒ 00:02:18.200 Mustafa Raja: What’s the intended use case for you, though?
37 00:02:19.610 ⇒ 00:02:28.160 Samuel Roberts: I don’t know, I just wanted to kind of see what everyone was talking about. I have no real, like, need for it, necessarily. I don’t really… I just wanted to kind of familiarize myself so I knew what everyone was talking about.
38 00:02:28.440 ⇒ 00:02:34.899 Mustafa Raja: From what I see, and sort of what appeals to me, too, is
39 00:02:35.030 ⇒ 00:02:44.350 Mustafa Raja: we can hook it up with our Cloud code or something, and maybe have our machine running, and then we could, you know, text back and forth.
40 00:02:44.800 ⇒ 00:02:50.479 Mustafa Raja: So that was somewhat interesting, but yeah.
41 00:02:52.120 ⇒ 00:02:54.610 Mustafa Raja: Yeah, that’s pretty much it for me.
42 00:02:55.390 ⇒ 00:03:00.989 Samuel Roberts: Yeah, I had looked at some other stuff that was, like, servers online that you can run cloud code on, so you could have, like, a.
43 00:03:00.990 ⇒ 00:03:01.430 Mustafa Raja: Oh, yeah.
44 00:03:01.430 ⇒ 00:03:06.169 Samuel Roberts: server you access, and things like that. So I was thinking about that a little bit, but I haven’t done much with it yet.
45 00:03:07.740 ⇒ 00:03:13.619 Samuel Roberts: Anyway… Let’s talk Which one? This one zips.
46 00:03:13.620 ⇒ 00:03:15.069 Amber Lin: Hello. Okay, cool.
47 00:03:15.070 ⇒ 00:03:15.710 Samuel Roberts: Hello.
48 00:03:15.990 ⇒ 00:03:21.369 Amber Lin: Let me share screen. So, I went through the whole list with them, so…
49 00:03:21.790 ⇒ 00:03:25.379 Samuel Roberts: Okay. This is everything apart from.
50 00:03:25.380 ⇒ 00:03:34.280 Amber Lin: the stuff they never gave us, and they don’t have yet, so we’re gonna work off of this. The only thing we’re missing is, I think, home improvement.
51 00:03:34.590 ⇒ 00:03:41.340 Amber Lin: Needs to improve this… Improve the…
52 00:03:41.530 ⇒ 00:03:45.020 Amber Lin: improve the… I think the zip codes for…
53 00:03:45.240 ⇒ 00:03:55.710 Amber Lin: inspectors, and the mechanical is missing inspectors. And, in terms, I think, for techs…
54 00:03:56.190 ⇒ 00:04:11.699 Amber Lin: we have this sheet, which I think we… we’re missing some fields, but we’ll just add them regardless. So essentially, the only thing missing will be, like, mechanical instructors, but they already know that, so that’s okay.
55 00:04:12.580 ⇒ 00:04:21.240 Amber Lin: So… we… I think, for us, we have to make sure that, one, all these sheets are in there.
56 00:04:21.430 ⇒ 00:04:34.900 Amber Lin: And then… to, on, Sam, what you were doing of checking Specific people of who’s missing?
57 00:04:35.140 ⇒ 00:04:49.650 Amber Lin: And then there’s additional fields that we’ll add, I think, at the end, because there’s universal inspector fields, and then there’s the tag size, and if Spanish-speaking.
58 00:04:49.840 ⇒ 00:04:52.640 Samuel Roberts: So, these are additional fields.
59 00:04:52.640 ⇒ 00:05:00.119 Amber Lin: But Sam, I’ll pass it to you, and you can talk about what you found, and what’s missing, and how we think we should address that.
60 00:05:00.910 ⇒ 00:05:05.399 Samuel Roberts: Yeah, let me get that open, because I don’t think I have it open anymore.
61 00:05:08.370 ⇒ 00:05:15.259 Samuel Roberts: But, yeah, basically, I took… so, those… all those sheets, I didn’t have access to everything, so Casey gave me an export of all of them.
62 00:05:15.420 ⇒ 00:05:17.569 Samuel Roberts: I believe, right? That was all those sheets, Casey?
63 00:05:18.270 ⇒ 00:05:20.769 Casie Aviles: Yes, that should be all of them.
64 00:05:21.920 ⇒ 00:05:25.809 Samuel Roberts: Cool. Okay, so then I went through, yeah, I basically took them all.
65 00:05:26.070 ⇒ 00:05:27.659 Samuel Roberts: Let me get it up, sorry.
66 00:05:31.500 ⇒ 00:05:33.689 Samuel Roberts: Oops, names is what I got here.
67 00:05:34.290 ⇒ 00:05:37.340 Samuel Roberts: Alright, let me just share this real quick, but,
68 00:05:41.150 ⇒ 00:05:43.639 Samuel Roberts: So, yeah, I was able to,
69 00:05:45.570 ⇒ 00:05:51.679 Samuel Roberts: basically pull out the names from each of those sheets, and I included the names of the sheets down here.
70 00:05:52.230 ⇒ 00:05:58.320 Samuel Roberts: But they’re also here, so, like, you know, this is the sheet and the tab, and then whether or not
71 00:05:59.160 ⇒ 00:06:03.729 Samuel Roberts: this name is just found in the database. I didn’t do any other confirmation of anything else.
72 00:06:04.800 ⇒ 00:06:13.260 Samuel Roberts: And so, a lot… most of them are. There’s a bunch that aren’t, and that is basically this list here.
73 00:06:13.580 ⇒ 00:06:19.069 Samuel Roberts: the thing about it, and I think I might have mentioned this in the Zoom, is that there’s definitely, like, typos…
74 00:06:19.920 ⇒ 00:06:22.730 Samuel Roberts: Like, Jim Barnes and Jim Barnes.
75 00:06:23.870 ⇒ 00:06:28.670 Samuel Roberts: are… probably the same person? I don’t know.
76 00:06:29.030 ⇒ 00:06:30.859 Samuel Roberts: But just, like, little things like that.
77 00:06:31.760 ⇒ 00:06:33.739 Samuel Roberts: No last names, things like that.
78 00:06:35.360 ⇒ 00:06:40.999 Samuel Roberts: that might be… and this is where I wanted to go through, I didn’t know the plan of attack exactly, basically to, like.
79 00:06:41.330 ⇒ 00:06:42.980 Samuel Roberts: Sort through these names.
80 00:06:43.530 ⇒ 00:06:58.359 Samuel Roberts: And I can, you know, I wasn’t trying to just, like, pass it off necessarily, I just wasn’t sure the best path forward, but basically figure out if these names are important names, and then adding them, or finding any patterns if we missed something dramatic.
81 00:06:58.650 ⇒ 00:07:00.170 Samuel Roberts: In terms of, like, chunks.
82 00:07:03.370 ⇒ 00:07:09.189 Samuel Roberts: So, I mean, I wasn’t sure… again, I got this done, and I just wasn’t sure of the next best plan of attack from here.
83 00:07:11.580 ⇒ 00:07:13.300 Samuel Roberts: That’s kind of where I was at with it.
84 00:07:13.530 ⇒ 00:07:23.249 Amber Lin: Okay, I was thinking that we first look at if there’s any sheets that’s missing, and then we can go ahead and look at what… if there’s specific people.
85 00:07:23.250 ⇒ 00:07:27.880 Samuel Roberts: That’s a really good point. Let me… let me do that real quick. What I can do is…
86 00:07:30.520 ⇒ 00:07:33.720 Samuel Roberts: We’ll pull all the unique… Files…
87 00:07:35.310 ⇒ 00:07:55.900 Samuel Roberts: And then we can just do a… Pound if… if… this… Match That… And… Matches… Where’s, like, not…
88 00:08:02.230 ⇒ 00:08:04.410 Samuel Roberts: Okay, hold on, wait a minute, something’s not right here.
89 00:08:04.860 ⇒ 00:08:09.240 Samuel Roberts: Maybe this is… maybe this is more of a problem. I didn’t get through all. So how many sheets are there supposed to be?
90 00:08:11.770 ⇒ 00:08:15.089 Samuel Roberts: Did I not include everyone? Oh, no, there’s not enough rows, is that what’s happening here?
91 00:08:16.650 ⇒ 00:08:22.930 Amber Lin: I see. I can just look at what sheets you have, and I have a rough idea of what’s…
92 00:08:23.410 ⇒ 00:08:24.650 Samuel Roberts: That’s needed.
93 00:08:26.420 ⇒ 00:08:28.789 Amber Lin: Did you look at 4 sheets total?
94 00:08:29.850 ⇒ 00:08:34.170 Samuel Roberts: No, that’s what I’m saying. All of these are all the sheets. I thought I merged them all together, but I might have.
95 00:08:34.179 ⇒ 00:08:39.139 Amber Lin: I see. Can I just look at the… all the tabs available?
96 00:08:40.179 ⇒ 00:08:40.980 Samuel Roberts: Yeah.
97 00:08:42.659 ⇒ 00:08:47.870 Samuel Roberts: But I might not have imported them all into the combined, that might have been my mistake there. Yeah, makes sense.
98 00:08:47.910 ⇒ 00:08:52.769 Amber Lin: So… For pests, we have them both.
99 00:08:52.940 ⇒ 00:09:02.479 Amber Lin: We have home improvement… Which should include both inspectors and technicians. For mechanical, we only have
100 00:09:02.630 ⇒ 00:09:11.319 Amber Lin: That guide, which makes sense, we don’t have their inspectors yet. For lawn, there’s one for residential, one for commercial.
101 00:09:11.510 ⇒ 00:09:20.230 Amber Lin: That’s good. And then… for pest…
102 00:09:20.520 ⇒ 00:09:24.780 Amber Lin: For Pest Commercial, there’s a Commercial Skills and Zips.
103 00:09:25.140 ⇒ 00:09:31.130 Amber Lin: And then there’s a commercial in… actors, I believe.
104 00:09:33.010 ⇒ 00:09:38.829 Amber Lin: Oh, okay, never mind. Okay, that’s… that’s fine.
105 00:09:38.940 ⇒ 00:09:39.680 Amber Lin: So.
106 00:09:39.680 ⇒ 00:09:41.569 Samuel Roberts: Oh, let me… oh, go ahead, sorry.
107 00:09:42.060 ⇒ 00:09:43.030 Amber Lin: Yeah, all good.
108 00:09:43.750 ⇒ 00:09:45.710 Samuel Roberts: I was just gonna say, I might try to,
109 00:09:46.980 ⇒ 00:09:49.910 Samuel Roberts: double-check my combined sheet, because I don’t…
110 00:09:52.020 ⇒ 00:09:55.119 Samuel Roberts: Because it looks like there’s only 4 sheets that are unique here.
111 00:09:55.430 ⇒ 00:10:02.059 Samuel Roberts: Which seems wrong, but it looks like it capped it. I forgot that it does this, so I gotta add rows, and then re-import everything, right?
112 00:10:04.180 ⇒ 00:10:07.910 Samuel Roberts: Because it’s only one of two, home improvement…
113 00:10:08.990 ⇒ 00:10:14.780 Samuel Roberts: Apartment scheduling… well, that came from here, which meant that I limited… yeah, that’s what happened, okay.
114 00:10:15.610 ⇒ 00:10:18.010 Samuel Roberts: Let me… let me take a stab at this real quick.
115 00:10:18.980 ⇒ 00:10:19.730 Amber Lin: Okay.
116 00:10:19.730 ⇒ 00:10:22.010 Samuel Roberts: Wait, no, why did I jump to $50,000? What the hell?
117 00:10:22.740 ⇒ 00:10:23.850 Amber Lin: Is there…
118 00:10:24.260 ⇒ 00:10:32.569 Amber Lin: Sorry, question of, like, for the different tabs, like, right now, I think I just want to know which one is completely blank.
119 00:10:34.370 ⇒ 00:10:39.090 Amber Lin: I think it just… is it just a mechanical that’s completely blank, or…
120 00:10:39.950 ⇒ 00:10:44.119 Samuel Roberts: That’s what I was trying to count up just now and see. It looks like there’s a lot of mechanical missing, yes.
121 00:10:44.520 ⇒ 00:10:45.260 Amber Lin: Okay.
122 00:10:45.400 ⇒ 00:10:46.170 Amber Lin: Okay.
123 00:10:46.420 ⇒ 00:10:47.220 Amber Lin: Cool, so…
124 00:10:47.220 ⇒ 00:10:51.759 Samuel Roberts: Some of these, like, like I said, this is just, like, a first name, so, like, that one is not a problem, it’s just found that, you know?
125 00:10:52.420 ⇒ 00:10:52.760 Amber Lin: I see.
126 00:10:52.760 ⇒ 00:10:57.750 Samuel Roberts: So that’s what I have to start parsing through a little bit more and see what are actually, like… like this.
127 00:10:57.970 ⇒ 00:11:00.459 Samuel Roberts: This is different spellings, you know?
128 00:11:00.820 ⇒ 00:11:01.840 Amber Lin: Mmm.
129 00:11:02.370 ⇒ 00:11:07.060 Samuel Roberts: So I was… that’s what I thought I had done combined, but I guess I hadn’t combined everything.
130 00:11:07.240 ⇒ 00:11:12.339 Samuel Roberts: I don’t know why that happened here, though. Like, that’s very odd. They were all here, definitely.
131 00:11:14.400 ⇒ 00:11:21.090 Amber Lin: Cool. So, I think if we were to make tickets, how would we…
132 00:11:21.600 ⇒ 00:11:25.159 Samuel Roberts: Yeah, A1268. Yeah, hold on, something’s wrong here.
133 00:11:26.070 ⇒ 00:11:29.329 Mustafa Raja: Are the rows hidden because we are filtering on Superbase?
134 00:11:31.800 ⇒ 00:11:34.770 Samuel Roberts: Was I filtering? Oh, this is filtering. Thank you.
135 00:11:37.160 ⇒ 00:11:44.169 Samuel Roberts: Yep, that’s it. Okay, thank you, that’s better. Okay, phew. Okay, so they are all there.
136 00:11:44.760 ⇒ 00:11:48.880 Samuel Roberts: That filter’s fine. Okay, so this is still the right number, then.
137 00:11:48.910 ⇒ 00:11:51.100 Casie Aviles: But what I want to do is this.
138 00:11:51.860 ⇒ 00:11:52.600 Samuel Roberts: Right.
139 00:11:55.140 ⇒ 00:11:56.500 Samuel Roberts: Time’s over.
140 00:11:58.250 ⇒ 00:11:59.260 Casie Aviles: There we go.
141 00:12:12.770 ⇒ 00:12:13.500 Samuel Roberts: Okay.
142 00:12:14.530 ⇒ 00:12:16.649 Samuel Roberts: Does it seem right? This doesn’t seem right.
143 00:12:16.650 ⇒ 00:12:17.170 Amber Lin: Oh, sure.
144 00:12:18.220 ⇒ 00:12:20.980 Samuel Roberts: Did I not go all the way down? I didn’t go all the way down for…
145 00:12:21.160 ⇒ 00:12:22.670 Samuel Roberts: Yeah, so I can help.
146 00:12:26.230 ⇒ 00:12:28.549 Samuel Roberts: This has to go all the way down too, right?
147 00:12:29.620 ⇒ 00:12:31.350 Samuel Roberts: 1, 2, 6, 8…
148 00:12:35.200 ⇒ 00:12:36.080 Samuel Roberts: Oops.
149 00:12:44.680 ⇒ 00:12:46.099 Samuel Roberts: And this makes more sense.
150 00:12:46.720 ⇒ 00:12:47.760 Amber Lin: Okay.
151 00:12:52.650 ⇒ 00:12:58.860 Samuel Roberts: Okay, and that’s… The same number up here, cool, that’s a good sign. So this is missing.
152 00:13:00.150 ⇒ 00:13:01.380 Amber Lin: A little.
153 00:13:01.720 ⇒ 00:13:04.710 Samuel Roberts: I’m just gonna do a quick one that does the total count of…
154 00:13:04.710 ⇒ 00:13:05.140 Amber Lin: Okay.
155 00:13:05.830 ⇒ 00:13:08.310 Samuel Roberts: So we’ll see, like, what percentage is missing from each sheet.
156 00:13:10.370 ⇒ 00:13:12.819 Samuel Roberts: If my computer will respond, -oh.
157 00:13:16.690 ⇒ 00:13:18.300 Samuel Roberts: Oh, no, the tab just froze.
158 00:13:19.290 ⇒ 00:13:20.659 Amber Lin: Okay.
159 00:13:20.660 ⇒ 00:13:21.060 Samuel Roberts: Hold on.
160 00:13:21.060 ⇒ 00:13:25.729 Amber Lin: Working from that… Seems like the…
161 00:13:26.370 ⇒ 00:13:33.160 Amber Lin: The long commercial guide missing? Oh, I think we’re missing a lot from lawn.
162 00:13:33.600 ⇒ 00:13:36.330 Amber Lin: Okay. Based on what it’s saying.
163 00:13:38.290 ⇒ 00:13:40.630 Amber Lin: Alright, so…
164 00:14:00.690 ⇒ 00:14:02.349 Amber Lin: Cool. Yeah. Okay.
165 00:14:02.800 ⇒ 00:14:09.400 Amber Lin: Alright, so I think… we… .
166 00:14:10.690 ⇒ 00:14:12.419 Samuel Roberts: So let’s first…
167 00:14:12.470 ⇒ 00:14:14.600 Amber Lin: Add the mechanical?
168 00:14:14.710 ⇒ 00:14:16.960 Amber Lin: Dispatch, like, our copy?
169 00:14:18.430 ⇒ 00:14:28.419 Amber Lin: Let’s add our mechanical copy, because I think the only thing we have is from the market areas, and they have some overlap, so let’s add the dispatch file.
170 00:14:29.100 ⇒ 00:14:38.220 Amber Lin: And then, let’s go look at lawn. It seems like our lawn commercial and residential zips are having some issues, so those are
171 00:14:38.730 ⇒ 00:14:40.690 Amber Lin: technicians. So let’s go…
172 00:14:40.690 ⇒ 00:14:41.080 Samuel Roberts: system.
173 00:14:41.080 ⇒ 00:14:42.560 Amber Lin: Yeah.
174 00:14:43.260 ⇒ 00:14:44.400 Samuel Roberts: Which one do you want to look at?
175 00:14:44.950 ⇒ 00:14:48.400 Amber Lin: I don’t necessarily need to look at them now, I think…
176 00:14:48.740 ⇒ 00:14:49.219 Samuel Roberts: Oh my god.
177 00:14:49.220 ⇒ 00:14:54.730 Amber Lin: It’s to create tickets so that we know what to do and when to work through them.
178 00:14:56.870 ⇒ 00:15:06.020 Amber Lin: Yeah. So… Great. I’ll take a screenshot. Can you expand column F so I can…
179 00:15:07.970 ⇒ 00:15:12.000 Amber Lin: I’ll screenshot all the missing values. Cool.
180 00:15:12.220 ⇒ 00:15:14.619 Samuel Roberts: And again, these are not necessarily unique, though.
181 00:15:14.880 ⇒ 00:15:15.950 Amber Lin: Yeah.
182 00:15:16.200 ⇒ 00:15:17.190 Amber Lin: Understand.
183 00:15:18.210 ⇒ 00:15:19.190 Samuel Roberts: Maybe some overlap.
184 00:15:21.620 ⇒ 00:15:24.509 Amber Lin: So let’s say, first, if we add…
185 00:15:25.250 ⇒ 00:15:30.020 Amber Lin: Let’s add the mechanical dispatch brain force copy.
186 00:15:41.370 ⇒ 00:15:43.269 Amber Lin: We have a ticket for that.
187 00:15:45.510 ⇒ 00:15:48.119 Casie Aviles: And then, next, I think we need to check…
188 00:15:48.620 ⇒ 00:15:52.590 Amber Lin: For the long commercial And…
189 00:15:54.180 ⇒ 00:15:58.519 Amber Lin: Let’s see, can we check the one that’s at 74% missing?
190 00:15:59.290 ⇒ 00:16:01.850 Samuel Roberts: Yeah, that’s Lawn Service Guidelines.
191 00:16:02.950 ⇒ 00:16:06.880 Samuel Roberts: Alright, let’s see, so Adam… T…
192 00:16:08.900 ⇒ 00:16:16.710 Samuel Roberts: So there’s, like, a lot here that look, like, not necessarily duplicates, or, like, you know, typos or anything.
193 00:16:17.170 ⇒ 00:16:19.219 Samuel Roberts: So that’s probably a good idea, then. I see.
194 00:16:19.550 ⇒ 00:16:27.400 Amber Lin: I see. I’m suspicious that we never added them, and it’s only, like, duplicate names that we’re seeing.
195 00:16:28.750 ⇒ 00:16:29.900 Samuel Roberts: Let’s find out, you know.
196 00:16:35.700 ⇒ 00:16:37.799 Samuel Roberts: I mean, I can pull up Subabase, too, if we want.
197 00:16:39.090 ⇒ 00:16:44.229 Amber Lin: Sure, I think we can also, just Casey and Mustafa, do you remember adding that sheet?
198 00:16:47.290 ⇒ 00:16:52.750 Casie Aviles: I know that I’ve added some low index… But, yeah.
199 00:16:53.070 ⇒ 00:16:57.830 Casie Aviles: Like I mentioned, they, they update that, so…
200 00:16:58.570 ⇒ 00:17:02.629 Casie Aviles: It may… it may be out of sync, though. Yeah.
201 00:17:07.160 ⇒ 00:17:11.099 Samuel Roberts: Okay, so this thing’s found. Let me just check if he’s found anywhere else, maybe, too.
202 00:17:14.290 ⇒ 00:17:14.869 Casie Aviles: Right.
203 00:17:15.640 ⇒ 00:17:17.960 Samuel Roberts: That’s maybe it. He’s in both one.
204 00:17:18.490 ⇒ 00:17:19.670 Samuel Roberts: Commercial?
205 00:17:22.359 ⇒ 00:17:27.949 Samuel Roberts: and lawn service. So maybe that’s the issue here. Lawn Service never got put in, and lawn commercial did?
206 00:17:28.850 ⇒ 00:17:35.380 Casie Aviles: Yeah, maybe one of… I think it’s just one of those lawn sheets that we added, not both. Yeah.
207 00:17:35.380 ⇒ 00:17:36.710 Amber Lin: I see.
208 00:17:36.710 ⇒ 00:17:37.310 Samuel Roberts: Okay.
209 00:17:37.460 ⇒ 00:17:40.259 Amber Lin: Let me check which one we’re missing.
210 00:17:40.260 ⇒ 00:17:44.600 Samuel Roberts: And this is also different tabs and stuff, too. Oop. So, like… I don’t know.
211 00:17:45.720 ⇒ 00:17:49.770 Samuel Roberts: if it’s… more tabs are more common, too, I don’t know, we can… we can keep digging.
212 00:17:49.770 ⇒ 00:17:57.290 Amber Lin: Are we missing the commercial tabs, or are we missing more on the regular, like, lawn tasks?
213 00:18:01.850 ⇒ 00:18:02.719 Amber Lin: It’s pretty cool.
214 00:18:03.440 ⇒ 00:18:04.860 Amber Lin: Oh, dear, okay.
215 00:18:05.140 ⇒ 00:18:09.730 Amber Lin: Let me just… I’ll just add both of these. I think that’s what we’ll tackle next.
216 00:18:10.060 ⇒ 00:18:11.240 Amber Lin: Okay.
217 00:18:13.720 ⇒ 00:18:19.370 Amber Lin: Lawn technicians… Hmm…
218 00:18:29.540 ⇒ 00:18:33.230 Amber Lin: After that… Let’s see…
219 00:18:37.210 ⇒ 00:18:44.669 Amber Lin: Seems like we’re missing some on the mechanical… the home improvement side as well.
220 00:18:45.640 ⇒ 00:18:48.010 Amber Lin: And then a few on the pest.
221 00:18:52.300 ⇒ 00:18:57.270 Samuel Roberts: 17 out of 389 is not crazy, though, so I’m wondering if that’s, like, an issue.
222 00:18:57.270 ⇒ 00:19:14.210 Amber Lin: The PES directory, they don’t use it for, like, all the assignments. We’re gonna use it for the Spanish-speaking and the Slim, or, the text size. So, that’s what we’ll be using the PES directory for.
223 00:19:16.360 ⇒ 00:19:20.950 Amber Lin: Alright, let’s see…
224 00:19:29.070 ⇒ 00:19:30.860 Amber Lin: Home improvement…
225 00:19:48.050 ⇒ 00:19:49.220 Amber Lin: Bang.
226 00:19:50.380 ⇒ 00:19:53.170 Amber Lin: Probably the past technicians.
227 00:20:41.890 ⇒ 00:20:45.840 Casie Aviles: Oh, and I also have, like, a question.
228 00:20:46.730 ⇒ 00:20:47.600 Casie Aviles: So…
229 00:20:48.420 ⇒ 00:20:55.820 Casie Aviles: I guess this is for sound. Did we… did we look at all, just the… everyone in the people table?
230 00:20:56.540 ⇒ 00:20:59.639 Casie Aviles: Is that how we… Check if there’s.
231 00:20:59.640 ⇒ 00:21:03.400 Samuel Roberts: Yeah, I was just checking against the people table. Yeah, is that a problem?
232 00:21:05.410 ⇒ 00:21:15.900 Casie Aviles: It may be, because for… well, I mean, it’s just that there are also other records in… what do you call this, in the cruise table, which I got.
233 00:21:15.900 ⇒ 00:21:16.589 Samuel Roberts: Oh, good.
234 00:21:16.590 ⇒ 00:21:17.240 Casie Aviles: on.
235 00:21:17.850 ⇒ 00:21:18.760 Samuel Roberts: Catch.
236 00:21:18.760 ⇒ 00:21:23.689 Casie Aviles: So there are crews there, but they’re, like, named… as one person.
237 00:21:24.210 ⇒ 00:21:27.729 Samuel Roberts: Okay, good. See, this is something I didn’t realize. Let’s see if this name is in here somewhere.
238 00:21:28.600 ⇒ 00:21:32.969 Casie Aviles: So that might explain why there are… there are some things missing, because…
239 00:21:33.620 ⇒ 00:21:39.070 Casie Aviles: Yeah, the fact that there are crews there, that means we did add lawn.
240 00:21:41.550 ⇒ 00:21:44.110 Casie Aviles: But, yeah, yeah, I’m sorry.
241 00:21:48.580 ⇒ 00:21:51.460 Samuel Roberts: Alright, pull up some names real quick and just spot check a little bit.
242 00:21:53.770 ⇒ 00:21:55.039 Samuel Roberts: There you go, there’s one.
243 00:21:56.880 ⇒ 00:21:58.210 Samuel Roberts: Okay, that’s good to know.
244 00:21:58.900 ⇒ 00:22:01.140 Samuel Roberts: I can… add that.
245 00:22:07.260 ⇒ 00:22:10.559 Samuel Roberts: How many are here? We got 68. Let me just copy this, maybe.
246 00:22:11.710 ⇒ 00:22:13.680 Samuel Roberts: Can you do that easily?
247 00:22:14.780 ⇒ 00:22:15.799 Samuel Roberts: I guess not.
248 00:22:16.650 ⇒ 00:22:18.850 Casie Aviles: You want to copy, like, all their names?
249 00:22:19.170 ⇒ 00:22:22.200 Samuel Roberts: I just wanted, yeah, if there’s just a way to, like, copy the current view.
250 00:22:22.950 ⇒ 00:22:24.749 Samuel Roberts: But I can probably do an SQL.
251 00:22:24.750 ⇒ 00:22:28.000 Casie Aviles: Yeah, I think you might need to do a query.
252 00:22:28.610 ⇒ 00:22:40.120 Samuel Roberts: Yeah… Okay, the other option I could do is I could actually go into… Script…
253 00:22:41.400 ⇒ 00:22:48.010 Samuel Roberts: And add it here… That seems like a lot of extra work for only 68 rows right now.
254 00:22:51.560 ⇒ 00:22:54.449 Samuel Roberts: So I’ll probably just do that. So I just want to…
255 00:22:55.040 ⇒ 00:22:58.980 Samuel Roberts: So I want to select from crews the crew names.
256 00:23:13.920 ⇒ 00:23:15.819 Samuel Roberts: Crews? Did I write my daughter? No.
257 00:23:16.130 ⇒ 00:23:16.800 Samuel Roberts: rooting in.
258 00:23:17.200 ⇒ 00:23:18.219 Samuel Roberts: Did I miss that on?
259 00:23:19.130 ⇒ 00:23:19.650 Casie Aviles: Oh, it’s.
260 00:23:21.210 ⇒ 00:23:23.840 Samuel Roberts: Who name, always. Always something.
261 00:23:24.690 ⇒ 00:23:25.730 Samuel Roberts: We’re gonna be here.
262 00:23:27.010 ⇒ 00:23:31.670 Samuel Roberts: Let’s just do… Copy is blocked, and maybe I can just paste that right into the spreadsheet.
263 00:23:32.350 ⇒ 00:23:34.070 Samuel Roberts: So I’ll add a new…
264 00:23:38.130 ⇒ 00:23:41.630 Samuel Roberts: That’s not how I wanted it. Okay, we’re not gonna do it that way. I guess I can clean that up.
265 00:23:43.540 ⇒ 00:23:48.040 Samuel Roberts: Somebody’s gonna do… CSV… CSV…
266 00:23:51.500 ⇒ 00:23:52.380 Samuel Roberts: Whatever.
267 00:23:54.490 ⇒ 00:24:06.900 Samuel Roberts: And with… Mission… It’s gonna open here, I’m gonna copy this name… I’m gonna jump back here…
268 00:24:09.630 ⇒ 00:24:13.310 Samuel Roberts: Good catch on the cruise, I hadn’t even thought, ugh, this tab is eating so much hungry.
269 00:24:14.100 ⇒ 00:24:21.520 Casie Aviles: Yeah, no problem. I mean… I wasn’t sure, like, what the best way was to represent Cruise…
270 00:24:22.180 ⇒ 00:24:24.090 Samuel Roberts: Yeah, that’s a good…
271 00:24:26.350 ⇒ 00:24:29.280 Casie Aviles: So I created, like, a separate table for them.
272 00:24:30.090 ⇒ 00:24:30.690 Samuel Roberts: Okay.
273 00:24:33.130 ⇒ 00:24:35.510 Samuel Roberts: Yeah, there’s a few of these, too, in Craig.
274 00:24:36.100 ⇒ 00:24:36.790 Casie Aviles: Yeah.
275 00:24:38.600 ⇒ 00:24:43.890 Casie Aviles: Because I think the names there are, I guess, the leaders of those crews.
276 00:24:47.130 ⇒ 00:24:49.029 Samuel Roberts: So let’s see if they’re in this master list.
277 00:24:52.960 ⇒ 00:24:54.319 Samuel Roberts: Oops, I did that wrong.
278 00:25:10.840 ⇒ 00:25:14.120 Samuel Roberts: Functioning on the Premier 3? Oh, just one, I guess, is the next.
279 00:25:14.510 ⇒ 00:25:16.530 Samuel Roberts: That’s not it either. Okay.
280 00:25:19.870 ⇒ 00:25:21.089 Samuel Roberts: Alright, we’ll listen to yours.
281 00:25:23.400 ⇒ 00:25:26.629 Samuel Roberts: Yeah, no, he’s not in there. Okay. Maybe it’s a find?
282 00:25:28.280 ⇒ 00:25:29.729 Samuel Roberts: No, it’s… that’s fine.
283 00:25:35.400 ⇒ 00:25:37.720 Samuel Roberts: Alright, go ahead, give me a second, this one.
284 00:25:39.780 ⇒ 00:25:44.180 Samuel Roberts: You know what, let’s… let’s try this. Let’s, let’s do… I was playing with this before.
285 00:25:46.940 ⇒ 00:25:50.070 Samuel Roberts: We’ll talk about the names in… alone.
286 00:25:50.410 ⇒ 00:25:55.389 Samuel Roberts: A in the list… I’m inviting.
287 00:25:57.200 ⇒ 00:25:57.940 Samuel Roberts: Follow.
288 00:25:58.120 ⇒ 00:25:58.870 Samuel Roberts: A.
289 00:26:07.150 ⇒ 00:26:09.720 Samuel Roberts: Honestly, Gemini was really nice at pulling out those names.
290 00:26:11.940 ⇒ 00:26:13.310 Samuel Roberts: Because I was, like.
291 00:26:13.600 ⇒ 00:26:17.170 Samuel Roberts: As I was looking at the sheets, I’m like, I don’t even know where to begin here.
292 00:26:17.490 ⇒ 00:26:18.959 Samuel Roberts: They did a pretty good job.
293 00:26:18.960 ⇒ 00:26:19.640 Mustafa Raja: Yeah.
294 00:26:19.930 ⇒ 00:26:23.019 Samuel Roberts: I think. I think. Now that I say that, who knows, but…
295 00:26:23.430 ⇒ 00:26:27.899 Mustafa Raja: It pulled out a lot of names, so… Yeah, I saw the other day Utham was,
296 00:26:28.050 ⇒ 00:26:32.330 Mustafa Raja: I was able to hook up Claude with… Within Excel.
297 00:26:32.560 ⇒ 00:26:35.060 Mustafa Raja: So that was pretty cool to see.
298 00:26:35.630 ⇒ 00:26:37.219 Mustafa Raja: I haven’t tested it out, though.
299 00:26:45.430 ⇒ 00:26:46.580 Samuel Roberts: Commands.
300 00:26:57.110 ⇒ 00:26:58.110 Samuel Roberts: Yeah.
301 00:26:58.710 ⇒ 00:27:01.510 Mustafa Raja: Is it able to look into multiple tabs at the same time?
302 00:27:02.700 ⇒ 00:27:03.850 Samuel Roberts: Yeast.
303 00:27:04.850 ⇒ 00:27:05.890 Samuel Roberts: Maybe?
304 00:27:06.000 ⇒ 00:27:11.080 Samuel Roberts: it was on certain documents, and then it wasn’t on other documents. But I think if you tag them.
305 00:27:11.610 ⇒ 00:27:12.090 Mustafa Raja: Oh.
306 00:27:12.090 ⇒ 00:27:18.620 Samuel Roberts: Cruise… No. There was some way where I was able to get it to work, and it was…
307 00:27:20.850 ⇒ 00:27:24.360 Samuel Roberts: Because it wasn’t for certain files, and I had to rerun them.
308 00:27:25.110 ⇒ 00:27:26.560 Mustafa Raja: I don’t remember.
309 00:27:27.030 ⇒ 00:27:27.580 Mustafa Raja: Yeah.
310 00:27:30.400 ⇒ 00:27:33.159 Samuel Roberts: So that’s how I was able to pull out all the… oh, okay, there you go.
311 00:27:50.840 ⇒ 00:27:58.830 Amber Lin: Sorry, guys, I will have to jump after, like, in 2 minutes. Can I show you the tickets I created so we can talk about
312 00:27:59.630 ⇒ 00:28:02.989 Amber Lin: How long they would take, and which one we should prioritize.
313 00:28:05.060 ⇒ 00:28:06.310 Casie Aviles: Sure, sure.
314 00:28:06.460 ⇒ 00:28:06.950 Amber Lin: Okay.
315 00:28:07.010 ⇒ 00:28:08.260 Samuel Roberts: Yeah, let me stop sharing.
316 00:28:08.260 ⇒ 00:28:10.239 Amber Lin: I’ll share screen, so…
317 00:28:10.360 ⇒ 00:28:19.380 Amber Lin: I made a view for this, so it’ll be easier to track, you can access it in views right here. So it’s essentially just everything
318 00:28:19.810 ⇒ 00:28:25.880 Amber Lin: in-cycle that’s in the, like, the zip code project. So, I think first.
319 00:28:26.500 ⇒ 00:28:32.639 Amber Lin: we have… I think we need to add this. I think that that should be the last thing that we are…
320 00:28:33.710 ⇒ 00:28:46.479 Amber Lin: ad thing? But… so if… I think we need to finish this first, because it’s… the data’s decently organized, we should have everything. And then I think we should do…
321 00:28:46.610 ⇒ 00:28:47.750 Amber Lin: this one.
322 00:28:47.880 ⇒ 00:28:51.029 Amber Lin: The missing zip codes.
323 00:28:51.460 ⇒ 00:29:02.639 Amber Lin: have… let’s start with the lawn technicians, because we have two sheets, and I think we’re missing 60%, 70% of them. And then we can take a look at…
324 00:29:03.120 ⇒ 00:29:06.020 Amber Lin: Say, maybe the home improvement tax.
325 00:29:06.400 ⇒ 00:29:25.120 Amber Lin: And then, like, residential pest technicians, I think we’re missing about 22%. Commercial, we have it pretty good, only about 8%. And then, I think lastly, I do think we need to make some adjustments to the service areas of people, because I don’t think we…
326 00:29:25.780 ⇒ 00:29:27.360 Amber Lin: When we did, like.
327 00:29:27.510 ⇒ 00:29:42.950 Amber Lin: for example, market areas of, okay, this person services Austin. I don’t think we applied service areas to them, because then, like, HVAC only is serviced in some zip codes in Austin, but I think we just… I don’t think we…
328 00:29:43.000 ⇒ 00:29:50.359 Amber Lin: did… we don’t have that in the query, we just gave them zips, so we may need to adjust, like, only give zips
329 00:29:50.790 ⇒ 00:29:51.810 Amber Lin: in…
330 00:29:52.600 ⇒ 00:29:56.079 Samuel Roberts: Austin areas, which… where HVAC is serviced.
331 00:29:56.160 ⇒ 00:30:01.839 Amber Lin: So I think that’s… Last of what we’ll do after we go through this.
332 00:30:04.730 ⇒ 00:30:20.939 Amber Lin: And then, like, this is the additional fields that they were asking. So, one on the tech size, and then two on the universal inspectors. I all… I linked the sheets that they’re from in there, so when we start on these tickets, we’ll know where to look.
333 00:30:21.080 ⇒ 00:30:23.880 Amber Lin: I think that should cover everything.
334 00:30:24.050 ⇒ 00:30:28.610 Amber Lin: So, like, with the time that we have, look…
335 00:30:29.140 ⇒ 00:30:36.619 Amber Lin: Could you guys help me add time estimates to these, and then we can think about what we can do this week?
336 00:30:40.570 ⇒ 00:30:41.720 Casie Aviles: Sure, sure.
337 00:30:43.690 ⇒ 00:30:45.480 Amber Lin: Okay,
338 00:30:48.380 ⇒ 00:30:55.079 Amber Lin: Should we do this one? I think this one we’ll do this week. We have… I don’t think we’re blocked anymore.
339 00:30:55.830 ⇒ 00:31:00.210 Amber Lin: I’ll just, like, whatever fields they have, we’ll just add it.
340 00:31:00.350 ⇒ 00:31:05.610 Amber Lin: So let’s say… We’ll do this this week.
341 00:31:06.050 ⇒ 00:31:11.230 Amber Lin: And then maybe we can do the long one this week? That’s the one that we have the most missing.
342 00:31:14.270 ⇒ 00:31:19.260 Amber Lin: Cool, okay. Who’s taking on the checking of the lawn?
343 00:31:19.400 ⇒ 00:31:21.280 Amber Lin: So is it these two?
344 00:31:23.000 ⇒ 00:31:24.590 Amber Lin: Who should I assign to?
345 00:31:24.910 ⇒ 00:31:38.959 Casie Aviles: You mean adding them, right? Yeah, adding them, checking if anything’s missing. Yeah, I mean, I can… I can do, like, adding, but if you, if we, if you want someone to also, like, do another check, make sure that…
346 00:31:39.710 ⇒ 00:31:44.590 Casie Aviles: Everything is there, and I think we’ll.
347 00:31:44.590 ⇒ 00:31:45.320 Amber Lin: Gotcha.
348 00:31:45.320 ⇒ 00:31:48.509 Casie Aviles: Do you think we should create another ticket for them?
349 00:31:49.440 ⇒ 00:31:59.320 Amber Lin: Sure, yeah. When you start doing it, I can… I can create another one for sure. What’s the estimate for this on your side?
350 00:32:00.490 ⇒ 00:32:06.170 Casie Aviles: I think I… I would set, like, 2 points, at least for, like, each…
351 00:32:06.170 ⇒ 00:32:07.130 Amber Lin: Okay.
352 00:32:07.280 ⇒ 00:32:08.050 Amber Lin: Each sheet?
353 00:32:09.260 ⇒ 00:32:10.000 Casie Aviles: Okay.
354 00:32:10.000 ⇒ 00:32:11.180 Amber Lin: So I’ll do 4.
355 00:32:12.510 ⇒ 00:32:17.700 Amber Lin: Mmm… Alright, and then…
356 00:32:18.600 ⇒ 00:32:35.670 Amber Lin: I will go ask… I think we’re having a meeting later today, I’ll ask Utam, like, if you’re… if you guys have additional time assignments on this client, or if I should ask for additional resources to help with this. If not, it’s just gonna take a bit longer, but hopefully if we get
357 00:32:35.840 ⇒ 00:32:40.560 Amber Lin: If we can get… This one, and this one…
358 00:32:40.660 ⇒ 00:32:45.070 Amber Lin: done or closed this week, I think we’ll be in a much better place.
359 00:32:45.430 ⇒ 00:32:51.590 Casie Aviles: So I guess for the stuff in Argyle, I think that might… We pushed back then.
360 00:32:52.600 ⇒ 00:32:55.789 Casie Aviles: If we focus on these, or at least in my case.
361 00:32:56.570 ⇒ 00:32:59.530 Amber Lin: Yeah, that makes sense.
362 00:32:59.530 ⇒ 00:33:01.580 Samuel Roberts: What’s getting pushed back? I just didn’t… I didn’t catch that.
363 00:33:03.090 ⇒ 00:33:06.950 Casie Aviles: I mean, I, stuff to do in the gantle, so I think I’d love, like.
364 00:33:06.950 ⇒ 00:33:12.249 Samuel Roberts: Oh, yeah, yeah, sorry, sorry, I can’t. I just didn’t hear the word, that’s all. Yeah, I think, I think this is probably more…
365 00:33:12.550 ⇒ 00:33:13.300 Samuel Roberts: More pressing.
366 00:33:13.300 ⇒ 00:33:23.319 Amber Lin: Yeah, the client has been asking about this. So, I think for the GANS programs, we have a working session Wednesday. Can we talk about it there?
367 00:33:25.300 ⇒ 00:33:26.370 Amber Lin: And…
368 00:33:26.600 ⇒ 00:33:36.629 Amber Lin: I guess, Casey, maybe you can discuss with Sam which one of your tasks we could push back, but I need to hop right now, so… Okay. Okay.
369 00:33:36.630 ⇒ 00:33:36.979 Samuel Roberts: Yeah, we can…
370 00:33:36.980 ⇒ 00:33:38.980 Amber Lin: Thanks, guys. Alright. Okay.
371 00:33:39.750 ⇒ 00:33:40.570 Amber Lin: Right?
372 00:33:40.970 ⇒ 00:33:41.650 Samuel Roberts: Bye.