Meeting Title: Inspector Sheet - Skills and Zips Date: 2025-08-13 Meeting participants: Casie Aviles, Mustafa Raja, Amber Lin
WEBVTT
1 00:00:06.930 ⇒ 00:00:08.220 Amber Lin: Hello.
2 00:00:08.400 ⇒ 00:00:09.020 Mustafa Raja: Hey.
3 00:00:10.850 ⇒ 00:00:20.639 Amber Lin: … Okay, I… first question is, are the ticketing system working as expected?
4 00:00:22.400 ⇒ 00:00:26.239 Casie Aviles: Yeah, I can see the triage tickets coming in now.
5 00:00:26.730 ⇒ 00:00:27.550 Amber Lin: Okay.
6 00:00:27.670 ⇒ 00:00:32.420 Amber Lin: Yeah, I think that we had one…
7 00:00:33.340 ⇒ 00:00:36.430 Amber Lin: Oh, awesome, we also have the Slack link. Alright.
8 00:00:36.910 ⇒ 00:00:38.129 Amber Lin: That works.
9 00:00:39.200 ⇒ 00:00:45.029 Amber Lin: Mostly want to talk about the two spreadsheets, so for the skills and zips.
10 00:00:45.820 ⇒ 00:00:52.830 Amber Lin: How we can improve that, and then we can talk about the inspector sheet of …
11 00:00:54.290 ⇒ 00:00:56.719 Amber Lin: I guess, how we can…
12 00:00:57.600 ⇒ 00:01:06.290 Amber Lin: led the ABC folks do the updates instead of us, and not having to manually fix it each time.
13 00:01:06.450 ⇒ 00:01:07.640 Amber Lin: And…
14 00:01:08.030 ⇒ 00:01:17.109 Amber Lin: I can… we can find a place to write down, but I just want to see how… initially, what do you guys think? What should we do for the skills and such?
15 00:01:19.270 ⇒ 00:01:24.769 Mustafa Raja: I guess, we just need to normalize one of them?
16 00:01:27.320 ⇒ 00:01:29.730 Mustafa Raja: And that… that’ll be good enough.
17 00:01:30.330 ⇒ 00:01:32.490 Mustafa Raja: the SCATS guide.
18 00:01:32.640 ⇒ 00:01:33.380 Mustafa Raja: 1.
19 00:01:35.120 ⇒ 00:01:36.019 Amber Lin: Which one?
20 00:01:36.020 ⇒ 00:01:38.240 Mustafa Raja: The schedule guide sheet.
21 00:01:39.980 ⇒ 00:01:42.259 Amber Lin: Oh, the Skills and Zip Sched scheduling guide.
22 00:01:42.260 ⇒ 00:01:43.180 Mustafa Raja: Yeah.
23 00:01:44.360 ⇒ 00:01:48.060 Amber Lin: What’s the problem we have with it right now?
24 00:01:48.510 ⇒ 00:01:50.420 Mustafa Raja: It has multiple tables.
25 00:01:50.940 ⇒ 00:01:51.890 Amber Lin: Okay.
26 00:01:52.430 ⇒ 00:01:53.120 Mustafa Raja: Yo.
27 00:01:54.530 ⇒ 00:01:57.760 Mustafa Raja: Yeah, just normalizing would be the goal.
28 00:01:59.760 ⇒ 00:02:04.030 Amber Lin: … So, if we normalize it…
29 00:02:04.480 ⇒ 00:02:08.940 Amber Lin: Do you mean just copy and pasting everything into one big.
30 00:02:08.949 ⇒ 00:02:11.229 Mustafa Raja: Yeah, one, one table only.
31 00:02:11.830 ⇒ 00:02:12.900 Amber Lin: …
32 00:02:16.580 ⇒ 00:02:20.429 Amber Lin: Ashley, can you share… oh, great. Let’s look at it together.
33 00:02:23.160 ⇒ 00:02:26.310 Amber Lin: Okay, the first one we probably need to…
34 00:02:26.790 ⇒ 00:02:38.080 Amber Lin: do a bit more of an edit, and then… I think the main thing is from the other sheets that we can probably combine together.
35 00:02:39.510 ⇒ 00:02:42.399 Mustafa Raja: Yeah, these, these ones are… these ones are pretty good.
36 00:02:43.390 ⇒ 00:02:45.009 Mustafa Raja: Except the SA1.
37 00:02:47.670 ⇒ 00:02:51.270 Amber Lin: Oh, when you say hard-coded, what does that mean?
38 00:02:51.850 ⇒ 00:02:56.369 Mustafa Raja: So, these sheets were converted to JSON.
39 00:02:56.540 ⇒ 00:03:00.519 Mustafa Raja: And that JSON data was put into a node.
40 00:03:03.430 ⇒ 00:03:08.069 Amber Lin: Oh, so the JSON file doesn’t update when.
41 00:03:08.070 ⇒ 00:03:08.740 Mustafa Raja: Yeah.
42 00:03:08.740 ⇒ 00:03:09.570 Amber Lin: Nathan.
43 00:03:09.570 ⇒ 00:03:10.150 Mustafa Raja: Yeah.
44 00:03:10.710 ⇒ 00:03:18.759 Amber Lin: Oh… … But we don’t do that for the inspector sheet. For the inspector sheet, we, …
45 00:03:19.160 ⇒ 00:03:21.689 Amber Lin: We link it to….
46 00:03:22.170 ⇒ 00:03:22.940 Casie Aviles: Yeah.
47 00:03:23.400 ⇒ 00:03:24.789 Casie Aviles: For the inspector, she created.
48 00:03:25.390 ⇒ 00:03:30.569 Casie Aviles: Yes, we’re linking directly to the master inspector sheet.
49 00:03:31.770 ⇒ 00:03:32.500 Amber Lin: ….
50 00:03:32.860 ⇒ 00:03:36.190 Casie Aviles: So, that’s why we were… I mean, I guess if…
51 00:03:36.600 ⇒ 00:03:42.450 Casie Aviles: one thing has to be updated, it has to be the master inspector sheet, then the AI won’t have
52 00:03:42.660 ⇒ 00:03:46.719 Casie Aviles: Like, a problem with syncing anymore, because it’s getting it in real time.
53 00:03:49.480 ⇒ 00:03:52.829 Casie Aviles: If that makes sense. Like, yeah, here.
54 00:03:53.080 ⇒ 00:03:53.820 Mustafa Raja: Yeah.
55 00:03:56.600 ⇒ 00:03:58.230 Casie Aviles: It’s a workflow, so…
56 00:04:04.190 ⇒ 00:04:11.100 Casie Aviles: I think… It’s kind of the same case with the inspector sheet, where
57 00:04:11.230 ⇒ 00:04:19.899 Casie Aviles: It’s… yeah, we have, like, the master inspector sheet here, so it’s literally just a node here that gets it. So whenever…
58 00:04:20.339 ⇒ 00:04:29.439 Casie Aviles: whenever the AI agent needs to reference data from the inspector sheet, It just has this node.
59 00:04:30.470 ⇒ 00:04:32.709 Casie Aviles: And then it would check that in real time.
60 00:04:33.450 ⇒ 00:04:34.680 Casie Aviles: So, I guess…
61 00:04:35.390 ⇒ 00:04:49.319 Casie Aviles: For this one, we hard-coded it before. That’s why it’s not… we have to manually, like, go to get all of this again, and then paste it somewhere on NATEN, and then it will be processed by the AI. That’s how it works.
62 00:04:49.610 ⇒ 00:04:52.599 Mustafa Raja: Yeah, I did… did the manual update.
63 00:04:53.080 ⇒ 00:04:59.670 Mustafa Raja: Yesterday. So… Okay. The hard-coded version is now the updated one.
64 00:05:00.700 ⇒ 00:05:01.700 Amber Lin: I see.
65 00:05:02.190 ⇒ 00:05:06.509 Amber Lin: Do you think it will make it a lot slower if we…
66 00:05:06.880 ⇒ 00:05:22.430 Amber Lin: combine these and add it, like, connect directly to the spreadsheet, because I know right now, we filter it by zip code so that the inspector sheet doesn’t take forever. How are we gonna filter
67 00:05:23.020 ⇒ 00:05:24.130 Amber Lin: this.
68 00:05:24.580 ⇒ 00:05:40.639 Mustafa Raja: Yeah, for this, I would want to know what type of questions are being asked. If they are looking for zip codes, the same way they are doing with the inspector sheet, or is this some other case?
69 00:05:40.640 ⇒ 00:05:42.970 Amber Lin: seems so… I think so, yeah.
70 00:05:43.560 ⇒ 00:05:50.549 Amber Lin: Yeah, they’re just gonna search who does what in what place.
71 00:05:50.550 ⇒ 00:06:01.100 Casie Aviles: Yeah, similar to how they query the inspector sheet, like, they add the zip, and then they ask for technicians, like rodent technicians. I’m trying to look for an example.
72 00:06:02.030 ⇒ 00:06:06.520 Amber Lin: I think we answered most of the road, like, the technician’s one pretty well.
73 00:06:17.510 ⇒ 00:06:20.100 Casie Aviles: Yeah, but just to give, …
74 00:06:20.960 ⇒ 00:06:25.979 Casie Aviles: Mustafa, an idea that’s, yeah, pretty much similar kinds of questions.
75 00:06:26.710 ⇒ 00:06:32.689 Casie Aviles: With the inspectors. It’s just, they say… explicitly say tech instead of inspector.
76 00:06:33.110 ⇒ 00:06:33.890 Mustafa Raja: Okay.
77 00:06:35.520 ⇒ 00:06:40.290 Mustafa Raja: Okay, so I guess filtering based on the, …
78 00:06:40.890 ⇒ 00:06:45.949 Mustafa Raja: Oh, okay, this one. Yeah, filtering based on the zip code would be good enough, and then I….
79 00:06:48.340 ⇒ 00:06:51.070 Casie Aviles: I think, yeah, we could also implement that, …
80 00:06:51.500 ⇒ 00:06:52.790 Casie Aviles: It can do something like that.
81 00:06:52.790 ⇒ 00:07:01.450 Mustafa Raja: We can also do… I guess we can do area too, but they will have to be pretty specific with their spells for area to work.
82 00:07:01.980 ⇒ 00:07:05.859 Mustafa Raja: Because it’s going to exactly match the area, if we do filters on that.
83 00:07:05.860 ⇒ 00:07:18.889 Amber Lin: I think it’s fine if they just do zip code, because they… because when the customer calls in, they know… the customer knows what zip code they’re living in, so, like, we should be able to find that.
84 00:07:19.860 ⇒ 00:07:29.380 Mustafa Raja: Yeah, I guess we can be, we can do… we can do… based on filters, we can, sorry, based on zip codes, we can do a pretty similar strategy that we did with the inspector sheet.
85 00:07:29.580 ⇒ 00:07:30.050 Amber Lin: Okay.
86 00:07:30.330 ⇒ 00:07:33.239 Mustafa Raja: And we can work with that. It’s the…
87 00:07:33.910 ⇒ 00:07:37.410 Mustafa Raja: Can we go to bed bug also? I have….
88 00:07:37.410 ⇒ 00:07:38.230 Casie Aviles: Red bug.
89 00:07:38.230 ⇒ 00:07:38.900 Mustafa Raja: Yeah.
90 00:07:39.030 ⇒ 00:07:40.630 Mustafa Raja: What’s the… mmm….
91 00:07:42.160 ⇒ 00:07:43.680 Amber Lin: Oh, that’s a mess.
92 00:07:47.780 ⇒ 00:07:48.490 Casie Aviles: opening.
93 00:07:49.490 ⇒ 00:07:55.199 Mustafa Raja: Yeah, I guess, … There’s no… there’s no zip codes.
94 00:07:55.810 ⇒ 00:08:00.650 Casie Aviles: Yeah, what… What are you asking for?
95 00:08:00.650 ⇒ 00:08:05.509 Amber Lin: add, if it makes sense, we can… I think we can…
96 00:08:05.770 ⇒ 00:08:19.710 Amber Lin: combine all the other ones first, and then for bed bugs, we’ll… we’ll do the same strategy. We’ll select, say, if it’s just for Austin, we’ll select all Austin and add their names, under Bed Bug.
97 00:08:21.770 ⇒ 00:08:28.070 Amber Lin: I think that could work, because I don’t think they have a bed bug section… a bed bug column, I would say.
98 00:08:28.070 ⇒ 00:08:33.720 Casie Aviles: Yes, yes, that’s correct. So, we can just, … Isolated.
99 00:08:34.460 ⇒ 00:08:36.199 Amber Lin: Yeah, so we can….
100 00:08:36.200 ⇒ 00:08:38.249 Casie Aviles: I don’t know if they’re already here.
101 00:08:38.600 ⇒ 00:08:39.260 Amber Lin: Okay.
102 00:08:39.650 ⇒ 00:08:42.739 Amber Lin: So, let me note that down.
103 00:08:43.270 ⇒ 00:08:52.090 Amber Lin: So, combine tabs… And filter by zip code.
104 00:08:52.460 ⇒ 00:08:56.169 Amber Lin: Add bed bug aspect column.
105 00:08:56.700 ⇒ 00:09:03.489 Amber Lin: … So, I’m looking at the Master Inspector Sheet.
106 00:09:03.620 ⇒ 00:09:09.050 Amber Lin: Should we take it out of our spreadsheet hub? Because it’s…
107 00:09:09.500 ⇒ 00:09:19.530 Amber Lin: if we want the CSRs to be also able to search that spreadsheet, It’s buried in our…
108 00:09:19.990 ⇒ 00:09:27.670 Amber Lin: sea of tabs. So I was thinking, should we separate it out into a… its own, like.
109 00:09:28.270 ⇒ 00:09:35.049 Amber Lin: its own spreadsheet, so we’ll have different tabs, or one tab for inspectors, one tab for techs.
110 00:09:35.400 ⇒ 00:09:39.550 Amber Lin: And then one tap service information, so we can…
111 00:09:40.000 ⇒ 00:09:44.099 Amber Lin: separated out to something that the CSRs can access.
112 00:09:44.820 ⇒ 00:09:49.310 Amber Lin: Because right now, they can’t search this, because they don’t have access to this spreadsheet.
113 00:09:50.250 ⇒ 00:09:53.540 Casie Aviles: Oh, they’re not using, this spreadsheet hub?
114 00:09:54.210 ⇒ 00:09:58.770 Amber Lin: I don’t think so. I’m most… because there’s just a lot of…
115 00:09:59.160 ⇒ 00:10:05.849 Amber Lin: If, I mean, if we clean this up, I think we’ll be fine. It’s just there’s a lot of, other tabs.
116 00:10:06.560 ⇒ 00:10:09.230 Casie Aviles: I, yeah, yeah, that makes sense. ….
117 00:10:09.800 ⇒ 00:10:12.979 Mustafa Raja: Yeah, we can move it to their thing, and we can connect.
118 00:10:13.080 ⇒ 00:10:16.920 Mustafa Raja: With their spreadsheet and find this sheet.
119 00:10:17.330 ⇒ 00:10:19.109 Mustafa Raja: We have the credentials.
120 00:10:19.600 ⇒ 00:10:20.400 Casie Aviles: Yeah, I….
121 00:10:20.400 ⇒ 00:10:26.100 Mustafa Raja: but I don’t think, … Yeah, yeah, we can do that. We can do this, yeah.
122 00:10:26.750 ⇒ 00:10:33.459 Casie Aviles: Yeah, I guess the only… the only reason why we have it here is because we wanted to have it consolidated, right? Like…
123 00:10:33.910 ⇒ 00:10:39.889 Casie Aviles: But yeah, I understand that right now there’s just so many sheets, so many tabs down here.
124 00:10:40.440 ⇒ 00:10:41.850 Amber Lin: Yeah, I think…
125 00:10:41.850 ⇒ 00:11:00.739 Amber Lin: We can just clean it up, because, say, abbreviations, they can also access, the emails, they can access OPA, the way offers and templates they can also access. So I guess we can just clean it up. We have a lot of intermediate tabs that we were using internally.
126 00:11:00.740 ⇒ 00:11:08.360 Amber Lin: I think if we clean this up, and then we can also add the master skills and zip sheet… text sheet here as well.
127 00:11:08.840 ⇒ 00:11:12.199 Amber Lin: Okay, I’ll just make a ticket to clean this spreadsheet up.
128 00:11:12.770 ⇒ 00:11:23.699 Casie Aviles: Okay, I think, yeah, I can… maybe… we’re getting, like, the inspector sheet contents from here, but I think we can hide this. These were hidden… these were hidden before.
129 00:11:24.450 ⇒ 00:11:25.349 Casie Aviles: I think, yeah.
130 00:11:26.990 ⇒ 00:11:35.440 Amber Lin: Clean, … Oh, spread… sheet, … Okay.
131 00:11:37.990 ⇒ 00:11:46.369 Amber Lin: … Yeah, for the… for the inspector sheet, right now, I know it’s still linked
132 00:11:46.710 ⇒ 00:11:53.150 Amber Lin: Because it’s still a VLOOKUP from the other tabs that we have in the spreadsheet hub.
133 00:11:53.640 ⇒ 00:12:03.229 Amber Lin: Do we want to cancel those links, or do we want to keep them? Because the tabs are not going to get updated anymore, because those are copies.
134 00:12:04.510 ⇒ 00:12:05.600 Casie Aviles: Yeah, exactly.
135 00:12:05.600 ⇒ 00:12:11.219 Amber Lin: get a… Because if we have the links, I feel like sometimes the…
136 00:12:12.280 ⇒ 00:12:21.280 Amber Lin: I don’t know, sometimes the, formulas might go wrong. Should we keep the formulas there, or should we just…
137 00:12:21.950 ⇒ 00:12:29.420 Amber Lin: make it so that it’s just text, and then we can delete the other tabs. I don’t know, what should we do?
138 00:12:30.130 ⇒ 00:12:37.339 Casie Aviles: Yeah, I mean… if… if we can… if there… if the CSRs will be updating this.
139 00:12:37.440 ⇒ 00:12:42.600 Casie Aviles: And we’ll be handing it off to them, similar to how they… constantly update.
140 00:12:42.740 ⇒ 00:12:52.380 Casie Aviles: the central dock. Then, yeah, we could definitely just get this as text, and… not as formulas anymore.
141 00:12:52.410 ⇒ 00:13:04.230 Amber Lin: Yeah, because I think it’s hard for them to make updates when it’s formulas, because they’ll try to type in it, and they can’t, because it’s a formula, so they can’t type a new name in there.
142 00:13:04.600 ⇒ 00:13:08.649 Casie Aviles: Yeah, yeah, for… like, just for example, we could just…
143 00:13:08.810 ⇒ 00:13:12.709 Casie Aviles: Paste it as text, you know, kind of like this.
144 00:13:13.040 ⇒ 00:13:17.579 Casie Aviles: And then it’ll be up to them to update this. I think that’s….
145 00:13:17.580 ⇒ 00:13:19.380 Amber Lin: I see. Okay.
146 00:13:19.590 ⇒ 00:13:22.740 Amber Lin: Yeah, I think we can… we can do that.
147 00:13:22.940 ⇒ 00:13:29.619 Amber Lin: Another question of how can they easily update the inspector sheet?
148 00:13:30.310 ⇒ 00:13:36.230 Amber Lin: Last time, I had to do a formula… Excel formula to update them.
149 00:13:36.770 ⇒ 00:13:49.689 Amber Lin: essentially, I did a formula in the filter by zip code, because they send… they’ll send a inspector’s name, and this inspector does these zip codes, and they send a list of zip codes.
150 00:13:50.160 ⇒ 00:13:59.330 Amber Lin: And… like, last time I had to do a formula of values match these… And then…
151 00:13:59.520 ⇒ 00:14:03.560 Amber Lin: And then I updated those cells, so I don’t know if they…
152 00:14:03.780 ⇒ 00:14:08.490 Amber Lin: they can use Excel that way, I think. I don’t think they can’t.
153 00:14:08.600 ⇒ 00:14:12.890 Amber Lin: Do you know how they can… Easily update this.
154 00:14:14.510 ⇒ 00:14:18.100 Casie Aviles: Yeah, I guess that’s when… Possible friction.
155 00:14:18.330 ⇒ 00:14:21.499 Casie Aviles: When it comes to using the inspector sheet, …
156 00:14:22.200 ⇒ 00:14:31.790 Casie Aviles: I mean, for me, like, how I just update this is I just honestly just look for the zip. It’s pretty manual, too.
157 00:14:32.500 ⇒ 00:14:39.150 Casie Aviles: I don’t know if there’s, like, a best way to do it. Like, I would just, you know, go into each cell and just edit it.
158 00:14:41.250 ⇒ 00:14:44.110 Amber Lin: I see, I see. Okay, …
159 00:14:44.780 ⇒ 00:14:54.080 Amber Lin: I’ll try… after we… after we turn the formulas into just text, let me try it.
160 00:14:54.800 ⇒ 00:14:58.740 Amber Lin: see if they can use the formula I used.
161 00:14:59.270 ⇒ 00:15:05.510 Amber Lin: Last time, let me go find… Oh, here.
162 00:15:06.600 ⇒ 00:15:07.780 Amber Lin: …
163 00:15:12.050 ⇒ 00:15:15.119 Amber Lin: So, let me send it in the chat.
164 00:15:15.570 ⇒ 00:15:21.270 Amber Lin: So, last time I clicked on zip code, the filter button next to zip code.
165 00:15:21.510 ⇒ 00:15:24.519 Amber Lin: And then I put in…
166 00:15:27.890 ⇒ 00:15:45.540 Amber Lin: I think the formula… is number, and then quote match… … A… 5… Yeah.
167 00:15:46.840 ⇒ 00:15:51.590 Amber Lin: So… If you click on the filter button on the zip code.
168 00:15:53.130 ⇒ 00:15:54.680 Casie Aviles: Oh, filter button?
169 00:15:54.680 ⇒ 00:15:55.280 Amber Lin: Right.
170 00:15:55.640 ⇒ 00:15:59.580 Amber Lin: Yeah, right here, and then… Filtered by condition.
171 00:16:00.660 ⇒ 00:16:04.330 Amber Lin: And then click here, and then find the formula.
172 00:16:05.110 ⇒ 00:16:07.539 Amber Lin: Maybe scroll down?
173 00:16:09.410 ⇒ 00:16:11.890 Casie Aviles: Awesome formula. Yeah.
174 00:16:12.280 ⇒ 00:16:21.370 Amber Lin: Yeah, and then you can copy and paste the formula I sent in the I sent in the chat…
175 00:16:22.430 ⇒ 00:16:24.190 Amber Lin: Summer match….
176 00:16:28.930 ⇒ 00:16:31.620 Casie Aviles: Oh, it just has to be text.
177 00:16:36.550 ⇒ 00:16:37.980 Casie Aviles: Maybe, okay, I’ll just copy.
178 00:16:37.980 ⇒ 00:16:42.349 Amber Lin: Oh, I sent a… I sent the… I sent the text in the chat.
179 00:16:42.710 ⇒ 00:16:43.949 Casie Aviles: Oh, okay, okay.
180 00:16:45.940 ⇒ 00:16:47.430 Amber Lin: I think that will make…
181 00:16:47.570 ⇒ 00:16:52.909 Amber Lin: Because you guys probably still need to update these, I think that will make your lives easier, too.
182 00:16:56.130 ⇒ 00:16:57.890 Amber Lin: Okay, let’s try.
183 00:17:03.640 ⇒ 00:17:05.120 Amber Lin: Let’s see if it works.
184 00:17:05.500 ⇒ 00:17:06.539 Amber Lin: Did it work?
185 00:17:08.770 ⇒ 00:17:10.940 Amber Lin: I think so….
186 00:17:11.260 ⇒ 00:17:12.760 Casie Aviles: Yeah, it got filtered.
187 00:17:12.990 ⇒ 00:17:15.140 Amber Lin: Yay, okay, so that works.
188 00:17:15.359 ⇒ 00:17:17.839 Amber Lin: And then I just update those cells.
189 00:17:19.349 ⇒ 00:17:23.489 Amber Lin: So that’s… that saves people some manual updating.
190 00:17:26.819 ⇒ 00:17:34.999 Mustafa Raja: These table… aren’t we fetching, the whole data in the spread… in this inspector sheet from some sub-tables?
191 00:17:36.219 ⇒ 00:17:36.979 Mustafa Raja: Zoom, ….
192 00:17:36.980 ⇒ 00:17:37.500 Casie Aviles: We are.
193 00:17:37.500 ⇒ 00:17:49.620 Mustafa Raja: CSR should be, or the people who want to update this sheet, wouldn’t they be able to update those tables to whatever they want?
194 00:17:49.620 ⇒ 00:17:53.210 Amber Lin: our subtles, you’ll see how messy they are.
195 00:17:55.510 ⇒ 00:18:04.219 Amber Lin: Do you want to… actually, let’s… let’s show Mustafa what the… the original inspector sheet is…
196 00:18:04.460 ⇒ 00:18:09.319 Amber Lin: very, very messy. They’re by per… they’re… so they’re by…
197 00:18:09.530 ⇒ 00:18:12.720 Amber Lin: area, so they’re Austin, and then…
198 00:18:13.160 ⇒ 00:18:18.720 Amber Lin: Different places, and they’re a massive bunch of zip codes, and a person, and they get…
199 00:18:19.270 ⇒ 00:18:25.169 Amber Lin: They’re… they become duplicative a lot of times, so the zip codes overlap between the different people.
200 00:18:25.560 ⇒ 00:18:25.950 Casie Aviles: Mute.
201 00:18:25.950 ⇒ 00:18:36.680 Amber Lin: turned that… we tried to flatten that, but it’s, like, barely manageable. I’m always scared that something’s gonna go wrong, and then we took that…
202 00:18:37.000 ⇒ 00:18:42.959 Amber Lin: matched the titles, and then plugged it into the… into the master instructor sheet, so it…
203 00:18:43.640 ⇒ 00:18:50.960 Amber Lin: Like, it’s a miracle that nothing went wrong, but something could have really went wrong in that process.
204 00:18:51.120 ⇒ 00:18:52.040 Mustafa Raja: Yes.
205 00:18:52.750 ⇒ 00:18:53.359 Casie Aviles: I can see that.
206 00:18:55.430 ⇒ 00:18:57.659 Amber Lin: So I don’t know if we can let them up.
207 00:18:58.000 ⇒ 00:18:58.819 Mustafa Raja: Yeah, yeah.
208 00:19:01.600 ⇒ 00:19:07.889 Casie Aviles: Yeah, it took a lot of also manual corrections for it to actually…
209 00:19:08.020 ⇒ 00:19:16.929 Casie Aviles: I don’t think they’re reporting much errors on the inspector now, just that there are some things that are actually missing from the original source.
210 00:19:17.010 ⇒ 00:19:28.489 Amber Lin: Yeah, I think so. So, I think what we can do is teach them how to update that sheet. So we need to clear the form. We probably can make a copy.
211 00:19:29.060 ⇒ 00:19:29.500 Casie Aviles: Yes.
212 00:19:29.500 ⇒ 00:19:42.090 Amber Lin: So we can have the original formulas, and then, I’ll try to teach them how to update as soon as possible, so that we can hand off these inspector updates
213 00:19:42.580 ⇒ 00:19:45.220 Amber Lin: tickets also to Janiece.
214 00:19:45.560 ⇒ 00:19:51.019 Amber Lin: I don’t want us to do it forever. It’s a… takes so much time, and it’s their job.
215 00:19:54.440 ⇒ 00:19:57.090 Amber Lin: Okay, I’ll tick that out.
216 00:19:57.680 ⇒ 00:20:01.640 Mustafa Raja: I won’t be in the ABC stand-up, I need to be in the default.
217 00:20:01.640 ⇒ 00:20:05.549 Amber Lin: Oh, yeah, it’s okay, I think this is all that we needed to talk about.
218 00:20:05.550 ⇒ 00:20:08.629 Mustafa Raja: Yeah, and for the, ….
219 00:20:08.850 ⇒ 00:20:11.760 Amber Lin: Sheets that we need to normalize.
220 00:20:11.760 ⇒ 00:20:19.579 Mustafa Raja: are we going to do it in this, in this… in our spreadsheet hub?
221 00:20:20.310 ⇒ 00:20:24.600 Mustafa Raja: Yeah, let’s do it in the spreadsheet hub. Let’s make a new tab for that.
222 00:20:24.770 ⇒ 00:20:25.590 Amber Lin: Okay.
223 00:20:25.590 ⇒ 00:20:28.139 Mustafa Raja: And, and I’ll be doing that, right?
224 00:20:29.440 ⇒ 00:20:35.659 Amber Lin: Sure, let me make a ticket… Let me make a ticket.
225 00:20:36.810 ⇒ 00:20:38.950 Amber Lin: So, a spreadsheet….
226 00:20:38.950 ⇒ 00:20:43.729 Mustafa Raja: The idea behind that is very similar to the inspector sheet that we have right now.
227 00:20:43.950 ⇒ 00:20:45.780 Mustafa Raja: I’m just making sure.
228 00:20:46.860 ⇒ 00:20:48.989 Amber Lin: I believe so, right, Casey?
229 00:20:49.160 ⇒ 00:20:51.410 Casie Aviles: Yeah, we’re just going to, …
230 00:20:51.670 ⇒ 00:20:57.020 Casie Aviles: Route, and then we’re going to read directly from They’re shit.
231 00:20:57.750 ⇒ 00:21:13.880 Mustafa Raja: Okay, so, meaning, we are going to, I’m supposed to, make a, inspector sheet, or sorry, not the inspector sheet, a combined sheet for all of these, ATI, for all of these zips.
232 00:21:13.880 ⇒ 00:21:19.900 Mustafa Raja: And I’m going to refer… refer to these sheets via a formula, right?
233 00:21:22.360 ⇒ 00:21:25.009 Casie Aviles: Actually, that’s… that’s a good question.
234 00:21:26.450 ⇒ 00:21:30.879 Casie Aviles: I think… what… I mean, what we could do is…
235 00:21:31.130 ⇒ 00:21:36.379 Casie Aviles: We could directly read from here, I believe, right? I think I tried it before.
236 00:21:37.700 ⇒ 00:21:39.629 Casie Aviles: … Then that would be….
237 00:21:39.630 ⇒ 00:21:44.939 Mustafa Raja: Yeah, yeah, we can… we can do it. I, the manual update, I did it from, N10.
238 00:21:46.110 ⇒ 00:21:47.020 Casie Aviles: Yeah, yeah.
239 00:21:47.020 ⇒ 00:21:51.870 Mustafa Raja: Yeah, I was able to, normalize almost all of the data.
240 00:21:52.240 ⇒ 00:21:54.000 Mustafa Raja: In an attempt.
241 00:21:54.560 ⇒ 00:21:58.940 Amber Lin: So I guess the question is, are we combining these tabs into one?
242 00:21:58.940 ⇒ 00:22:07.790 Mustafa Raja: Yeah, what we can do is we can skip all of that and do all of this in any. It’s only one code node.
243 00:22:09.700 ⇒ 00:22:10.080 Amber Lin: Okay.
244 00:22:10.360 ⇒ 00:22:11.450 Amber Lin: Yes.
245 00:22:11.630 ⇒ 00:22:15.519 Amber Lin: Does it make it… how long… It’s going to take….
246 00:22:15.520 ⇒ 00:22:19.409 Mustafa Raja: Let’s, let’s say a sheet is going to take 2 to 3 seconds.
247 00:22:19.950 ⇒ 00:22:21.440 Amber Lin: Okay, okay.
248 00:22:21.750 ⇒ 00:22:22.790 Amber Lin: Oh….
249 00:22:24.280 ⇒ 00:22:30.440 Mustafa Raja: Sure. I mean, they, I don’t know, because then we have to look for zip codes.
250 00:22:30.820 ⇒ 00:22:33.840 Mustafa Raja: And filter on that, also.
251 00:22:33.840 ⇒ 00:22:43.369 Amber Lin: Yeah, because my only concern is we… if we keep it as separate tabs, if it doesn’t find it in one tab, it’ll have to query another tab.
252 00:22:43.370 ⇒ 00:22:45.080 Mustafa Raja: Yeah, yeah, yeah, yeah, yeah, yeah.
253 00:22:45.080 ⇒ 00:22:47.359 Amber Lin: Until they finally find the zip code.
254 00:22:47.360 ⇒ 00:22:50.639 Mustafa Raja: Yeah, it’s going to be… it’s going to become a long process.
255 00:22:51.540 ⇒ 00:22:52.730 Amber Lin: Yeah.
256 00:22:53.090 ⇒ 00:22:59.559 Amber Lin: We can still… I still think it’s the best if we can…
257 00:22:59.660 ⇒ 00:23:03.799 Amber Lin: Combine them into one sheet, because they will have to search
258 00:23:03.920 ⇒ 00:23:10.320 Amber Lin: for zip codes anyways, so if they do CTRL-F zip code, it’s easier if it’s in…
259 00:23:10.880 ⇒ 00:23:13.959 Amber Lin: I don’t know, maybe it’s easier if it’s in one tab.
260 00:23:14.300 ⇒ 00:23:15.040 Mustafa Raja: Yep.
261 00:23:16.970 ⇒ 00:23:18.300 Amber Lin: Not sure.
262 00:23:20.150 ⇒ 00:23:26.380 Mustafa Raja: This ATX and CFSA, are these some cities or something?
263 00:23:27.080 ⇒ 00:23:29.210 Amber Lin: Yeah, they’re, like, cities.
264 00:23:29.380 ⇒ 00:23:30.070 Mustafa Raja: Okay.
265 00:23:30.400 ⇒ 00:23:33.259 Amber Lin: Honestly, maybe we can just…
266 00:23:35.260 ⇒ 00:23:52.389 Amber Lin: create… just copy over the values, and just… and then just tell them, hey, this is what we updated, use this now. Like, maybe that’s something we do, instead of linking it into… to these. Like, we could do import range. Do we want to do import range?
267 00:23:52.750 ⇒ 00:23:54.050 Amber Lin: For these.
268 00:23:56.260 ⇒ 00:23:57.419 Mustafa Raja: I’m not familiar with it.
269 00:23:57.420 ⇒ 00:24:00.450 Amber Lin: Copy everything over into one master tab, and then link it to.
270 00:24:00.450 ⇒ 00:24:04.409 Casie Aviles: Yeah. Import range will just get, like, everything.
271 00:24:04.410 ⇒ 00:24:09.060 Mustafa Raja: Oh, okay, so for the, whatever the range, in table, right?
272 00:24:09.300 ⇒ 00:24:10.830 Mustafa Raja: Yes, yes. Okay.
273 00:24:12.880 ⇒ 00:24:14.159 Amber Lin: Alright, so….
274 00:24:14.160 ⇒ 00:24:14.550 Mustafa Raja: Yes.
275 00:24:14.550 ⇒ 00:24:15.569 Amber Lin: that to you.
276 00:24:16.220 ⇒ 00:24:19.499 Mustafa Raja: So the goal is to make another sheet. I’m just confirming.
277 00:24:20.360 ⇒ 00:24:21.030 Amber Lin: Yeah.
278 00:24:24.040 ⇒ 00:24:25.090 Amber Lin: True.
279 00:24:27.620 ⇒ 00:24:37.320 Amber Lin: Import range… And then… I have… Cleaning up the…
280 00:24:38.220 ⇒ 00:24:43.639 Amber Lin: the spreadsheet hub. Casey, I’ll assign that to you. Not as urgent.
281 00:24:43.990 ⇒ 00:24:49.499 Amber Lin: Just something we do before we hand it off to them, and then clear formulas from inspector sheet.
282 00:24:50.210 ⇒ 00:24:57.050 Amber Lin: I will also assign that to you. I think we should make… Make a copy.
283 00:24:58.270 ⇒ 00:25:00.570 Amber Lin: New version.
284 00:25:07.230 ⇒ 00:25:07.980 Amber Lin: Okay.
285 00:25:08.090 ⇒ 00:25:09.240 Amber Lin: Yeah, that’s all.
286 00:25:09.430 ⇒ 00:25:10.230 Amber Lin: Yeah.
287 00:25:11.760 ⇒ 00:25:12.790 Amber Lin: Alrighty.
288 00:25:13.150 ⇒ 00:25:14.030 Mustafa Raja: Okay, thank you.
289 00:25:14.600 ⇒ 00:25:15.130 Amber Lin: Thanks, folks.
290 00:25:15.130 ⇒ 00:25:15.830 Casie Aviles: Thank you.
291 00:25:15.830 ⇒ 00:25:16.720 Mustafa Raja: Thank you.
292 00:25:17.520 ⇒ 00:25:18.310 Mustafa Raja: Bye.
293 00:25:18.660 ⇒ 00:25:19.410 Amber Lin: Bye!