Meeting Title: Brainforge Revenue Model Working Session Date: 2025-10-29 Meeting participants: Emily Giant, Demilade Agboola
WEBVTT
1 00:01:55.140 ⇒ 00:01:56.180 Emily Giant: What?
2 00:02:48.000 ⇒ 00:02:48.610 Demilade Agboola: Hi, Amy.
3 00:02:49.340 ⇒ 00:02:50.689 Emily Giant: How’s it going?
4 00:02:51.080 ⇒ 00:02:52.439 Demilade Agboola: Pretty good, how are you?
5 00:02:52.780 ⇒ 00:02:57.759 Emily Giant: Good, I was just pulling up the new mart, the Unified Order of Line Items.
6 00:02:57.910 ⇒ 00:03:03.929 Demilade Agboola: Yeah, it’s basically the same format as the fact or the line items, so it’s, like,
7 00:03:04.440 ⇒ 00:03:05.710 Demilade Agboola: What’s it called?
8 00:03:08.840 ⇒ 00:03:16.289 Demilade Agboola: go through it with you, and then I’ll put it into fact orders, and once that’s done, it should be, like, one big-ass table where everything is there.
9 00:03:16.290 ⇒ 00:03:18.320 Emily Giant: It’s huge, yeah.
10 00:03:18.740 ⇒ 00:03:19.710 Emily Giant: Nice.
11 00:03:19.980 ⇒ 00:03:21.770 Emily Giant: It looks nice and clean.
12 00:03:24.070 ⇒ 00:03:27.770 Emily Giant: The whole lineage looks so clean. Wow.
13 00:03:28.230 ⇒ 00:03:32.149 Demilade Agboola: Yeah, but I… I will need to do some fixes.
14 00:03:32.150 ⇒ 00:03:32.880 Emily Giant: Yeah.
15 00:03:32.880 ⇒ 00:03:41.050 Demilade Agboola: Because I created an, an OMS Comp base new.
16 00:03:42.160 ⇒ 00:03:43.300 Demilade Agboola: But…
17 00:03:43.660 ⇒ 00:03:51.250 Demilade Agboola: it was giving me… it was running too many… too many issues, and I was just like, you know, it’s not this… this part isn’t the most important, so I kind of synced it to the old one.
18 00:03:51.420 ⇒ 00:03:52.080 Emily Giant: Yeah.
19 00:03:52.080 ⇒ 00:03:59.869 Demilade Agboola: We’ll sync it back to the new one. Like, that will still be a work in progress, but it’s not, because it was not the highest priority that it had to be the new stuff. Let’s just get the numbers in.
20 00:04:00.030 ⇒ 00:04:01.650 Emily Giant: Yeah, and I know that…
21 00:04:01.760 ⇒ 00:04:16.939 Emily Giant: fucking model, like, the back of my hand, because it’s had so many problems, so I can… we can do it together, fixing that. Like, I am just so used to fixing that model, so… just let me know. We can just do a whole working session on that, if you want.
22 00:04:19.390 ⇒ 00:04:24.339 Demilade Agboola: It’s fine. So, can we look at the numbers and just get an idea of, like.
23 00:04:25.290 ⇒ 00:04:25.900 Emily Giant: Yeah.
24 00:04:25.900 ⇒ 00:04:27.080 Demilade Agboola: You’re fire.
25 00:04:28.220 ⇒ 00:04:34.749 Emily Giant: So, let me pull up Perry’s historical spreadsheets that she shared, too, because I know, like.
26 00:04:35.130 ⇒ 00:04:40.630 Emily Giant: I like to go order by order, but sometimes it’s hard to get, like, the large-scale.
27 00:04:41.300 ⇒ 00:04:41.980 Demilade Agboola: Okay.
28 00:04:42.140 ⇒ 00:04:42.770 Demilade Agboola: you know.
29 00:04:42.770 ⇒ 00:04:52.929 Emily Giant: So, I’ll open that, like, let’s do a couple, where it gets really tricky with Legacy, or maybe it won’t anymore, actually, because it was tricky after the Shopify.
30 00:04:53.700 ⇒ 00:04:56.969 Emily Giant: migration, not… In the past.
31 00:04:57.160 ⇒ 00:05:03.899 Emily Giant: So… Do you… do you want to share and just, like, run through a few orders, or…
32 00:05:04.450 ⇒ 00:05:07.380 Emily Giant: How do you wanna… Go about this.
33 00:05:07.630 ⇒ 00:05:11.859 Demilade Agboola: Can we do… can we do, like, high-level revenue, summary?
34 00:05:12.440 ⇒ 00:05:13.320 Emily Giant: Yeah.
35 00:05:13.320 ⇒ 00:05:15.450 Demilade Agboola: Alright, let me pull up my Google Sheets.
36 00:05:19.270 ⇒ 00:05:27.199 Emily Giant: I’ve, like, forgotten how to use my computer this morning. I don’t know what’s going on with my brain. Is my internet out? There we go, okay. Jeez.
37 00:05:28.390 ⇒ 00:05:31.900 Emily Giant: All right, let me share this sheet with you also.
38 00:05:32.610 ⇒ 00:05:35.939 Emily Giant: Because I think it could be really helpful.
39 00:05:36.490 ⇒ 00:05:39.900 Emily Giant: With some of the, like, tests to set up, too, with revenue.
40 00:05:42.020 ⇒ 00:05:45.360 Emily Giant: I just have to find it. Alright, Perry…
41 00:05:49.680 ⇒ 00:05:52.640 Emily Giant: QA and notes. Alright.
42 00:05:56.920 ⇒ 00:05:58.640 Emily Giant: Adding you now…
43 00:06:04.120 ⇒ 00:06:08.060 Emily Giant: And if you can’t open them for any reason, I’ll just make a copy of it, and…
44 00:06:08.440 ⇒ 00:06:16.279 Emily Giant: because I don’t know if she has to, like, give permission, but in the historical hard-coded revenue, at the bottom of the sheet… here, let me send the link…
45 00:06:19.880 ⇒ 00:06:24.270 Emily Giant: Those are all the, like, week-by-week, I think, revenue numbers?
46 00:06:24.370 ⇒ 00:06:28.809 Emily Giant: So if we go back to, like, 2023 or something, that would be a good one to…
47 00:06:30.610 ⇒ 00:06:31.989 Emily Giant: Do some hype.
48 00:06:37.270 ⇒ 00:06:38.990 Emily Giant: What did I just click on?
49 00:06:40.220 ⇒ 00:06:42.630 Demilade Agboola: I can… yeah, I can… I can see it.
50 00:06:44.130 ⇒ 00:06:44.770 Emily Giant: Okay.
51 00:06:45.660 ⇒ 00:06:49.390 Emily Giant: Revenue reporting variance comparison’s another good one.
52 00:07:00.310 ⇒ 00:07:04.359 Emily Giant: Oh, pink, okay. So, starting at, like, line 135.
53 00:07:10.570 ⇒ 00:07:12.660 Demilade Agboola: In the reporting variant.
54 00:07:13.850 ⇒ 00:07:16.989 Emily Giant: In fiscal Plan 2023,
55 00:07:18.540 ⇒ 00:07:24.150 Emily Giant: Oh, no, I was looking at the spreadsheet. You can look at the reporting variance one, too. That was the…
56 00:07:24.520 ⇒ 00:07:28.189 Emily Giant: Evidence of how jacked revenue had become over time.
57 00:07:28.540 ⇒ 00:07:32.599 Demilade Agboola: Oh, so the spreadsheets are in, like, each year, so 2023, 2024.
58 00:07:32.890 ⇒ 00:07:38.100 Emily Giant: The account it opens to, if you scroll to 135, it’s the hard-coded actual.
59 00:07:38.100 ⇒ 00:07:39.910 Demilade Agboola: I don’t have access to that.
60 00:07:39.910 ⇒ 00:07:42.450 Emily Giant: Oh, let me make a copy…
61 00:07:43.330 ⇒ 00:07:46.609 Emily Giant: And instead of making a copy of this whole thing.
62 00:07:46.870 ⇒ 00:07:49.020 Emily Giant: I will just start our own spreadsheet.
63 00:07:50.350 ⇒ 00:07:53.280 Emily Giant: Because there are, like, 50 tabs in that.
64 00:07:56.450 ⇒ 00:07:58.149 Demilade Agboola: That’s a lot of data.
65 00:07:58.360 ⇒ 00:08:03.239 Emily Giant: Yeah, it’s too much. In the spreadsheet, that gives me the willies.
66 00:08:03.860 ⇒ 00:08:07.290 Emily Giant: Alright, one… here, I forgot to share it with you.
67 00:08:09.350 ⇒ 00:08:12.550 Emily Giant: Revenue hard-coded.
68 00:08:24.710 ⇒ 00:08:28.539 Emily Giant: Here’s the new sheet. We can use either, though,
69 00:08:28.790 ⇒ 00:08:31.690 Emily Giant: It’s gonna be the same numbers, it’s just not week by week.
70 00:08:36.669 ⇒ 00:08:38.299 Emily Giant: This one’s, like, month by month.
71 00:08:40.059 ⇒ 00:08:40.829 Demilade Agboola: Okay.
72 00:08:51.830 ⇒ 00:08:52.530 Emily Giant: Okay.
73 00:08:57.740 ⇒ 00:09:02.700 Emily Giant: So, it looks like… If you pulled the whole year revenue.
74 00:09:02.930 ⇒ 00:09:07.589 Emily Giant: It should be 75,000, or $1,137,976.
75 00:09:07.880 ⇒ 00:09:10.329 Emily Giant: And then there’s the month-by-month hard-coded.
76 00:09:15.460 ⇒ 00:09:19.960 Demilade Agboola: Sorry, I’m trying to get the… the numbers, but for some reason…
77 00:09:21.230 ⇒ 00:09:24.120 Demilade Agboola: I am getting an error, which makes no sense.
78 00:09:35.800 ⇒ 00:09:38.749 Emily Giant: Oh my god, my coffee this morning is so good.
79 00:09:40.900 ⇒ 00:09:43.130 Emily Giant: Coffee in fall is just…
80 00:09:47.850 ⇒ 00:09:53.419 Demilade Agboola: I mean, sometimes, like… I do think, yeah, coffee is really good in fall, so…
81 00:09:53.610 ⇒ 00:09:59.569 Emily Giant: I mean, it’s really good all the time, of course, but it’s just, like, extra when it’s a little bit chilly outside.
82 00:09:59.720 ⇒ 00:10:00.720 Demilade Agboola: Yeah…
83 00:10:05.390 ⇒ 00:10:06.180 Demilade Agboola: Okay.
84 00:10:10.670 ⇒ 00:10:14.500 Demilade Agboola: Should we go into the Dominican… Republic release.
85 00:10:31.960 ⇒ 00:10:35.790 Demilade Agboola: Okay, so this is this… And then this…
86 00:10:41.700 ⇒ 00:10:46.590 Demilade Agboola: Right, so this was 2023.
87 00:10:47.360 ⇒ 00:10:48.030 Emily Giant: Yep.
88 00:10:49.730 ⇒ 00:10:52.299 Emily Giant: I’ll add the other ones while you’re pulling it up.
89 00:10:52.820 ⇒ 00:10:54.670 Demilade Agboola: Okay, that’s fine.
90 00:12:12.080 ⇒ 00:12:13.489 Demilade Agboola: So I have the month by month.
91 00:12:15.020 ⇒ 00:12:16.300 Demilade Agboola: for 2023.
92 00:12:16.810 ⇒ 00:12:18.469 Emily Giant: Okay, I’ll see it.
93 00:12:24.980 ⇒ 00:12:25.900 Demilade Agboola: So…
94 00:12:27.600 ⇒ 00:12:28.580 Demilade Agboola: Thanks for asking?
95 00:12:28.860 ⇒ 00:12:29.480 Emily Giant: Yep.
96 00:12:33.070 ⇒ 00:12:33.820 Emily Giant: Okay.
97 00:12:40.650 ⇒ 00:12:43.220 Emily Giant: Okay, 2023.
98 00:12:53.920 ⇒ 00:12:55.330 Demilade Agboola: What is the month-to-month for?
99 00:12:58.090 ⇒ 00:13:01.550 Emily Giant: I don’t know why the one pasted with all the colors and the other didn’t?
100 00:13:03.820 ⇒ 00:13:06.060 Demilade Agboola: Did you paste it with…
101 00:13:06.800 ⇒ 00:13:07.530 Emily Giant: There we go.
102 00:13:07.700 ⇒ 00:13:08.480 Demilade Agboola: Yeah.
103 00:13:08.480 ⇒ 00:13:09.230 Emily Giant: Got it.
104 00:13:10.340 ⇒ 00:13:11.510 Demilade Agboola: And Command-V.
105 00:13:12.360 ⇒ 00:13:13.320 Emily Giant: Yep.
106 00:13:17.670 ⇒ 00:13:19.589 Demilade Agboola: He’s basically gone.
107 00:13:23.000 ⇒ 00:13:24.150 Demilade Agboola: Where’s the month by month?
108 00:13:25.190 ⇒ 00:13:27.490 Emily Giant: If you,
109 00:13:28.310 ⇒ 00:13:34.549 Emily Giant: go to the right. That should be… because the month is at the top. I think I need to freeze the top row, because it’s really confusing.
110 00:13:37.150 ⇒ 00:13:38.330 Demilade Agboola: Yeah, but it’s not.
111 00:13:39.430 ⇒ 00:13:44.739 Emily Giant: Free… okay. Oh, it’s July, July, July, August, August, August. What are… oh, these must be the weeks.
112 00:13:44.960 ⇒ 00:13:45.950 Demilade Agboola: Yeah…
113 00:13:46.190 ⇒ 00:13:47.590 Emily Giant: Sorry.
114 00:13:52.440 ⇒ 00:13:55.629 Emily Giant: You freeze the top several rows in that case.
115 00:14:17.120 ⇒ 00:14:17.790 Emily Giant: Okay.
116 00:14:29.510 ⇒ 00:14:35.250 Emily Giant: I mean, I can do… I can quickly add these months. The thing is, they’re fiscal, so that’s… they’re gonna be a little bit off.
117 00:14:36.110 ⇒ 00:14:42.890 Emily Giant: We can use the… oh, there’s the FY23… Date… oh, for cops, okay.
118 00:14:44.710 ⇒ 00:14:47.850 Emily Giant: So, it looks like the first… Week.
119 00:14:48.410 ⇒ 00:14:53.200 Emily Giant: It’s 627 through 7-3, if we just want to, like, do the weeks.
120 00:15:00.590 ⇒ 00:15:04.449 Emily Giant: Because the months are going to be off until we add it to Looker and it does the fiscal…
121 00:15:49.510 ⇒ 00:15:54.320 Emily Giant: So it would be… 0627.
122 00:15:56.690 ⇒ 00:15:59.099 Emily Giant: Through 7-3.
123 00:16:08.010 ⇒ 00:16:10.240 Demilade Agboola: Through being, like, like…
124 00:16:10.420 ⇒ 00:16:12.309 Emily Giant: To the end of that day, yeah.
125 00:16:12.310 ⇒ 00:16:12.970 Demilade Agboola: Okay.
126 00:16:17.900 ⇒ 00:16:22.599 Emily Giant: If you do between, does it include the final date, or does it exclude the final date?
127 00:16:23.970 ⇒ 00:16:25.520 Emily Giant: I need to look that up.
128 00:16:25.520 ⇒ 00:16:37.690 Demilade Agboola: I can’t remember, I think it excludes the final date, but it includes the lower date. But it’s one of the two. It includes one of the dates, and then it excludes the other. I think it includes the lower date, but not the upper date.
129 00:16:37.690 ⇒ 00:16:39.179 Emily Giant: Gotcha, okay.
130 00:16:41.660 ⇒ 00:16:45.690 Demilade Agboola: I might be wrong. It’s one of those syntax things that I just usually just check my.
131 00:16:45.690 ⇒ 00:16:46.100 Emily Giant: D.
132 00:16:49.030 ⇒ 00:16:50.889 Demilade Agboola: I check before I use it.
133 00:16:52.580 ⇒ 00:16:55.340 Demilade Agboola: You said the 3rd, or the 4th?
134 00:16:56.630 ⇒ 00:17:01.430 Emily Giant: The third is the last day of that week, and the fourth is the first day of the next week.
135 00:17:01.710 ⇒ 00:17:05.360 Demilade Agboola: Okay, so 27th, bird, though.
136 00:17:05.369 ⇒ 00:17:06.299 Emily Giant: Yeah.
137 00:17:08.819 ⇒ 00:17:14.649 Emily Giant: So, AI says, when you use between operator, both start and end date are included in the range.
138 00:17:14.910 ⇒ 00:17:15.849 Demilade Agboola: Oh, okay.
139 00:17:23.130 ⇒ 00:17:24.740 Demilade Agboola: I mean, it must be much smaller.
140 00:17:26.560 ⇒ 00:17:27.700 Demilade Agboola: Right.
141 00:17:29.900 ⇒ 00:17:34.479 Emily Giant: Okay, so crude… yeah, much, hmm, okay.
142 00:17:38.480 ⇒ 00:17:42.859 Emily Giant: So… what I’m gonna do…
143 00:17:43.680 ⇒ 00:17:45.150 Demilade Agboola: It’s a very stressful piece.
144 00:17:45.150 ⇒ 00:17:45.870 Emily Giant: Indeed.
145 00:17:46.960 ⇒ 00:17:48.470 Emily Giant: Excuse me.
146 00:17:51.060 ⇒ 00:17:54.940 Demilade Agboola: I don’t think it could be for… shipping.
147 00:18:00.470 ⇒ 00:18:02.549 Emily Giant: Oh, is shipping not added yet?
148 00:18:02.820 ⇒ 00:18:03.580 Demilade Agboola: No.
149 00:18:03.580 ⇒ 00:18:04.250 Emily Giant: Okay.
150 00:18:04.490 ⇒ 00:18:07.050 Demilade Agboola: So, but I don’t think it’s contract is shipping them.
151 00:18:08.410 ⇒ 00:18:09.769 Emily Giant: Say it again, sorry.
152 00:18:11.150 ⇒ 00:18:12.360 Emily Giant: Confirm?
153 00:18:12.850 ⇒ 00:18:15.909 Demilade Agboola: Breakfast, brunch, whatever this is.
154 00:18:16.650 ⇒ 00:18:19.060 Demilade Agboola: I don’t think 200K is shipping.
155 00:18:23.240 ⇒ 00:18:35.640 Demilade Agboola: Because right now, what’s happening here is, for revenue, We have, basically, the piece… Price adjusted.
156 00:18:37.650 ⇒ 00:18:39.689 Emily Giant: These prices adjusted as accrued, okay.
157 00:18:40.640 ⇒ 00:18:44.890 Demilade Agboola: So, potentially, That’s the only revenue that’s being counted.
158 00:18:45.410 ⇒ 00:18:53.650 Demilade Agboola: What ends up happening is, potentially, if there is a… like, the…
159 00:18:54.770 ⇒ 00:18:58.680 Demilade Agboola: Like, how we having… over here? Give me one second.
160 00:19:00.250 ⇒ 00:19:05.789 Demilade Agboola: water lines… How, like, we have, in fact orders where there’s all of this.
161 00:19:05.790 ⇒ 00:19:06.600 Emily Giant: Okay.
162 00:19:06.600 ⇒ 00:19:10.560 Demilade Agboola: We have fact orders, where we eventually put the…
163 00:19:11.880 ⇒ 00:19:16.190 Demilade Agboola: like, all the information there, so I was too fulfilled.
164 00:19:16.670 ⇒ 00:19:23.740 Demilade Agboola: As well as also add whatever shopping costs, like, shopping prices, as the entire fulfilled.
165 00:19:25.510 ⇒ 00:19:30.079 Emily Giant: In the old CompXF, it did add shipping to it.
166 00:19:30.960 ⇒ 00:19:33.260 Emily Giant: That was part of the accrued price.
167 00:19:33.610 ⇒ 00:19:39.400 Emily Giant: Or accrued revenue. Or the piece price adjusted, I should say. Let me pull up a little next compact settings.
168 00:19:54.340 ⇒ 00:19:58.750 Demilade Agboola: On a piece level? On the… Yeah.
169 00:19:58.750 ⇒ 00:20:07.530 Emily Giant: So, parent price… God, I hate this model so much. Peace Price of Ridge…
170 00:20:10.680 ⇒ 00:20:14.079 Emily Giant: A piece price adjusted does not include shipping.
171 00:20:15.480 ⇒ 00:20:16.130 Demilade Agboola: Yep.
172 00:20:16.300 ⇒ 00:20:23.049 Emily Giant: Piece revenue does not… So, it would be, where does this revenue calculation happen?
173 00:20:28.670 ⇒ 00:20:30.019 Demilade Agboola: I’m not finishing it, to be honest.
174 00:20:30.020 ⇒ 00:20:34.280 Emily Giant: If you pull it from production… oh, well, I guess this is in production.
175 00:20:34.460 ⇒ 00:20:38.060 Emily Giant: I was gonna say that something weird was happening.
176 00:20:38.600 ⇒ 00:20:52.129 Emily Giant: Remember in December, Perry had pulled that, like, the sales data had not processed a ton of the information for some reason? And I’m wondering if something happened in Hivo that
177 00:20:52.330 ⇒ 00:21:00.810 Emily Giant: Like, this is not actually… SQL… issue. It’s a…
178 00:21:01.810 ⇒ 00:21:07.649 Emily Giant: HIVO issue. Like, let me pull the raw amount of orders.
179 00:21:08.540 ⇒ 00:21:12.880 Emily Giant: That happened… okay, so where… what is this model based on?
180 00:21:13.770 ⇒ 00:21:14.360 Emily Giant: It’s…
181 00:21:14.360 ⇒ 00:21:14.910 Demilade Agboola: for.
182 00:21:15.060 ⇒ 00:21:15.840 Demilade Agboola: Why am I…
183 00:21:15.860 ⇒ 00:21:19.439 Emily Giant: So all the component data is what should be tallied
184 00:21:20.680 ⇒ 00:21:23.500 Emily Giant: Okay, so I know that
185 00:21:23.930 ⇒ 00:21:28.709 Emily Giant: In 2023, we moved from using components
186 00:21:29.430 ⇒ 00:21:36.449 Emily Giant: split line… from component only, like, LMS components to LMS split line item components?
187 00:21:36.970 ⇒ 00:21:38.599 Emily Giant: And you had mentioned that, like.
188 00:21:39.240 ⇒ 00:21:47.090 Emily Giant: Well, no, this looks roughly similar to how it was set up. I mean, it looks exactly the same as how it was set up before. So…
189 00:21:47.200 ⇒ 00:21:51.229 Emily Giant: It shouldn’t be really any different.
190 00:21:52.650 ⇒ 00:21:54.040 Demilade Agboola: It looks exactly the same.
191 00:21:54.190 ⇒ 00:21:54.920 Emily Giant: Yeah.
192 00:21:55.920 ⇒ 00:21:58.930 Demilade Agboola: I was asking, like, what looks exactly the same?
193 00:21:59.530 ⇒ 00:22:06.830 Emily Giant: the OMS CompEXF base, like, I’m saying it feels like it shouldn’t be any different than it was prior to.
194 00:22:07.020 ⇒ 00:22:07.510 Demilade Agboola: Okay.
195 00:22:07.510 ⇒ 00:22:09.540 Emily Giant: Adding it to this model, because.
196 00:22:09.540 ⇒ 00:22:09.970 Demilade Agboola: here.
197 00:22:09.970 ⇒ 00:22:14.840 Emily Giant: This code hasn’t… like, significantly changed.
198 00:22:14.910 ⇒ 00:22:33.930 Emily Giant: But shipping does come from OMS suborders. There’s, like, a different revenue calculation that I’m wondering if she was using that from… because we only need one revenue calculation, and before there were two different ones, and then there was a test in DBT to say, like, are these really different from one another? And they always were.
199 00:22:33.990 ⇒ 00:22:36.270 Emily Giant: And we had to turn that test off.
200 00:22:36.880 ⇒ 00:22:40.009 Emily Giant: So that the data refreshed.
201 00:22:40.940 ⇒ 00:22:42.940 Emily Giant: So, I think that’s in…
202 00:22:45.600 ⇒ 00:22:51.620 Emily Giant: my thought is to, like, pull up that number, the other revenue calculation that comes from OMS suborders.
203 00:22:51.930 ⇒ 00:22:58.990 Emily Giant: to see if that matches this in any way, and then I can isolate the cost of shipping from that model.
204 00:23:01.070 ⇒ 00:23:01.510 Demilade Agboola: Okay.
205 00:23:01.510 ⇒ 00:23:04.890 Emily Giant: We can see if that is the difference here.
206 00:23:05.570 ⇒ 00:23:07.840 Emily Giant: And that’s OMS suborders.
207 00:23:24.650 ⇒ 00:23:26.770 Emily Giant: Types joined.
208 00:23:33.370 ⇒ 00:23:40.199 Emily Giant: Okay, so suborders joined appears to be, like, the… where the shipping cost starts.
209 00:23:40.590 ⇒ 00:23:48.680 Emily Giant: But that’s not where… Well, and that’s a word of calculations… That sounds promising.
210 00:23:50.640 ⇒ 00:23:55.210 Emily Giant: Yeah, okay. So, in the model called… I’ll… Copy it.
211 00:23:55.590 ⇒ 00:23:57.340 Emily Giant: Send it to you.
212 00:24:00.630 ⇒ 00:24:02.140 Emily Giant: Where is chat?
213 00:24:03.860 ⇒ 00:24:06.640 Emily Giant: I swear, the chat button in Zoom changes.
214 00:24:07.220 ⇒ 00:24:11.109 Emily Giant: Every time I click it. Like, it’s in a different spot on the bottom.
215 00:24:12.250 ⇒ 00:24:13.560 Emily Giant: Show chat!
216 00:24:16.490 ⇒ 00:24:18.950 Emily Giant: It’s, like, not even popping up the chat, hold on.
217 00:24:23.780 ⇒ 00:24:24.689 Emily Giant: There we go.
218 00:24:26.850 ⇒ 00:24:34.239 Emily Giant: So, online… 45, you’ll see end as revenue.
219 00:24:36.620 ⇒ 00:24:41.640 Emily Giant: But, let me… Run a query…
220 00:24:46.990 ⇒ 00:24:47.970 Emily Giant: Hi, buddy.
221 00:25:33.270 ⇒ 00:25:36.820 Emily Giant: 2023 of 6… 26?
222 00:26:01.570 ⇒ 00:26:09.849 Emily Giant: Okay, so if I use that model, I get… this. As the total revenue.
223 00:26:12.170 ⇒ 00:26:13.929 Demilade Agboola: Oh, am I supposed to bother calculations?
224 00:26:14.770 ⇒ 00:26:22.809 Emily Giant: Yep. If I just do a sum of revenue for… well, I did deliver that. I don’t know if that’s the right thing for comp.
225 00:26:23.230 ⇒ 00:26:28.150 Emily Giant: maybe it’s… Let me see if there’s a date that makes more sense.
226 00:26:28.580 ⇒ 00:26:34.230 Demilade Agboola: Yes, my question is, why do we have OMS Comp XF and OMS supporters calculations?
227 00:26:35.710 ⇒ 00:26:44.420 Emily Giant: Oh, because, oh, I don’t know. It’s one of the mysteries of the universe, Devilate. It… it’s…
228 00:26:44.610 ⇒ 00:26:46.410 Emily Giant: I think one is for…
229 00:26:47.060 ⇒ 00:26:56.810 Emily Giant: calculating the revenue on each piece, and OMS suborders is for calculating the revenue on suborders, but the thing is, that’s the same damn thing.
230 00:26:57.280 ⇒ 00:27:02.790 Emily Giant: So, it sh… they… I don’t know. I think it was just, like… a symptom of…
231 00:27:02.940 ⇒ 00:27:08.350 Emily Giant: disorganization. I did not do this. This was not me.
232 00:27:08.570 ⇒ 00:27:11.299 Emily Giant: But let me get the shipping cost from this model.
233 00:27:12.250 ⇒ 00:27:20.059 Emily Giant: Let me see if that’s its own isolated… it has to be, because it’s used in that calculation, right? Shipping units, shipping cost.
234 00:27:20.770 ⇒ 00:27:23.030 Emily Giant: Some shipping cost.
235 00:27:23.320 ⇒ 00:27:26.649 Emily Giant: No, it should be shipping revenue, not cost.
236 00:27:27.230 ⇒ 00:27:34.360 Emily Giant: Oh, no, we just call shipping revenue shipping cost, which is… Not confusing at all.
237 00:27:51.580 ⇒ 00:27:52.480 Emily Giant: Okay
238 00:27:57.110 ⇒ 00:28:01.219 Emily Giant: Well, there’s still, like, some… this is the sum of the shipping cost.
239 00:28:01.550 ⇒ 00:28:04.849 Emily Giant: So 9… 98,734.
240 00:28:05.530 ⇒ 00:28:06.400 Demilade Agboola: Okay.
241 00:28:07.050 ⇒ 00:28:12.050 Demilade Agboola: So is that minus… so that 98… is that in the 830K?
242 00:28:12.050 ⇒ 00:28:13.749 Emily Giant: Is added in there, yeah.
243 00:28:23.120 ⇒ 00:28:28.949 Demilade Agboola: We want to do an investigation into YOMS Comp, and why OMS suborder?
244 00:28:28.950 ⇒ 00:28:37.219 Emily Giant: I need to pull, like, I’m gonna pick a day in that week, and pull everything from this, and everything from that, and compare them, because…
245 00:28:38.950 ⇒ 00:28:41.250 Emily Giant: Didn’t make sense to me.
246 00:28:43.290 ⇒ 00:28:46.409 Emily Giant: Alright, so if I do select…
247 00:28:50.520 ⇒ 00:28:52.430 Emily Giant: So I’m gonna do the suborder.
248 00:28:52.800 ⇒ 00:28:54.810 Emily Giant: The revenue and the shipping cost.
249 00:29:01.100 ⇒ 00:29:03.469 Emily Giant: So we do suborder ID.
250 00:29:03.770 ⇒ 00:29:05.050 Emily Giant: Revenue.
251 00:29:05.660 ⇒ 00:29:06.790 Emily Giant: Shipping.
252 00:29:06.900 ⇒ 00:29:08.240 Emily Giant: Cost.
253 00:29:13.070 ⇒ 00:29:15.010 Emily Giant: And I’ll add this to the… what?
254 00:29:17.190 ⇒ 00:29:17.960 Emily Giant: Oh.
255 00:29:36.030 ⇒ 00:29:38.400 Emily Giant: Right, and I’m gonna add it to our sheet and just…
256 00:29:38.980 ⇒ 00:29:42.000 Emily Giant: Call it, like, the comparison tab or something.
257 00:29:47.880 ⇒ 00:29:52.420 Demilade Agboola: Okay, Sam, I just plugged this with the OMS of order calculations instead.
258 00:30:01.030 ⇒ 00:30:05.480 Demilade Agboola: But to be fair, for each suborder, you can have multiple pieces, right? On each suborder.
259 00:30:05.480 ⇒ 00:30:06.160 Emily Giant: Yes.
260 00:30:06.520 ⇒ 00:30:11.369 Emily Giant: But they should be able to roll up into the suborder on that model, right? Like…
261 00:30:12.940 ⇒ 00:30:15.070 Emily Giant: It just depends on how… what?
262 00:30:19.270 ⇒ 00:30:25.109 Emily Giant: use a different date, because that must have been a Sunday, or nothing, because nothing was delivered on that day.
263 00:30:51.120 ⇒ 00:30:57.280 Emily Giant: So it might be a date issue, too, like, Is… what is processed at?
264 00:30:59.050 ⇒ 00:31:03.349 Demilade Agboola: That, I’m not sure, to be honest.
265 00:31:04.550 ⇒ 00:31:06.570 Demilade Agboola: So I was trying to create it at…
266 00:31:09.330 ⇒ 00:31:15.950 Emily Giant: Yeah, I’m gonna do it on created at, that way we are potentially using the same thing to compare.
267 00:31:16.870 ⇒ 00:31:20.449 Emily Giant: Why… okay, it’s saying there are no orders created.
268 00:31:20.600 ⇒ 00:31:22.189 Emily Giant: No, no nothing.
269 00:31:23.720 ⇒ 00:31:24.250 Demilade Agboola: Yeah.
270 00:31:27.880 ⇒ 00:31:33.410 Demilade Agboola: I think it’s moved us further away from the number, the 811 key.
271 00:31:45.030 ⇒ 00:31:47.200 Emily Giant: Maybe it’s the 27th, I guess.
272 00:31:51.190 ⇒ 00:31:59.230 Emily Giant: It’s literally pulling, like, no dates, or no orders for any of these date things that I’m using. It’s very…
273 00:31:59.230 ⇒ 00:32:00.280 Demilade Agboola: Can I say that correctly?
274 00:32:00.710 ⇒ 00:32:03.169 Emily Giant: Yeah, let me try this.
275 00:32:13.680 ⇒ 00:32:15.709 Emily Giant: Sharing my whole screen.
276 00:32:17.070 ⇒ 00:32:23.770 Emily Giant: Okay. Oh, here we go. Okay, so here are all the suborders for that one day. There are 25.
277 00:32:24.490 ⇒ 00:32:30.340 Emily Giant: 25 of 100, so if I do, let me try the 26, because it’ll be a lesser…
278 00:32:30.500 ⇒ 00:32:35.460 Emily Giant: Order date, because there’s nothing left at the beginning, or the… That date.
279 00:32:36.880 ⇒ 00:32:39.470 Demilade Agboola: But, can you see the items in this?
280 00:32:40.900 ⇒ 00:32:41.790 Demilade Agboola: Yeah.
281 00:32:42.000 ⇒ 00:32:42.730 Emily Giant: Yeah.
282 00:32:42.850 ⇒ 00:32:46.220 Emily Giant: I think so… mmm…
283 00:32:49.600 ⇒ 00:32:54.310 Emily Giant: Let me see… You definitely can, because I’ve done…
284 00:32:55.030 ⇒ 00:33:02.230 Emily Giant: So much comparisons between these two to try and get these right, in the past.
285 00:33:02.230 ⇒ 00:33:02.690 Demilade Agboola: So what?
286 00:33:02.690 ⇒ 00:33:06.479 Emily Giant: We hired Brainforge. I’m just looking for a SKU.
287 00:33:06.950 ⇒ 00:33:12.669 Demilade Agboola: Yeah, so I might look into this order today, just trying to get an idea of, like, where the disparities start to occur.
288 00:33:23.960 ⇒ 00:33:25.569 Emily Giant: Alright, I don’t see the…
289 00:33:26.020 ⇒ 00:33:30.310 Emily Giant: SKU, but this should still be useful in, like, looking at the revenue on an order.
290 00:33:30.850 ⇒ 00:33:35.210 Emily Giant: And… Seen where the differences are.
291 00:33:37.670 ⇒ 00:33:39.690 Emily Giant: Alright, where is our…
292 00:33:44.480 ⇒ 00:33:46.000 Emily Giant: Excuse me.
293 00:34:31.199 ⇒ 00:34:32.630 Emily Giant: She created that.
294 00:34:36.989 ⇒ 00:34:37.920 Emily Giant: Oh.
295 00:34:45.590 ⇒ 00:34:47.500 Emily Giant: Peace, price adjusted.
296 00:34:50.340 ⇒ 00:34:52.850 Emily Giant: I don’t think shipping cost is in here either, so…
297 00:34:58.110 ⇒ 00:34:59.710 Emily Giant: Let’s take this out.
298 00:35:11.780 ⇒ 00:35:14.330 Emily Giant: Oh, that makes perfect sense.
299 00:35:36.690 ⇒ 00:35:37.950 Emily Giant: Okay.
300 00:35:39.280 ⇒ 00:35:41.480 Emily Giant: Let me try ComponentsXF.
301 00:35:42.850 ⇒ 00:35:45.269 Emily Giant: Because that flows two components, XF.
302 00:35:53.630 ⇒ 00:36:00.130 Emily Giant: No, it won’t be any different. This is just simply not pulling any information.
303 00:36:00.980 ⇒ 00:36:02.939 Emily Giant: Let’s do this.
304 00:36:18.470 ⇒ 00:36:20.189 Emily Giant: Just do, like, a handful of these.
305 00:36:31.770 ⇒ 00:36:34.630 Emily Giant: Oh, shit, sorry, I need to do this too.
306 00:36:35.300 ⇒ 00:36:36.849 Emily Giant: Oh, yeah…
307 00:36:56.760 ⇒ 00:37:01.550 Demilade Agboola: So it’s something I do… to, like… Mmm.
308 00:37:03.010 ⇒ 00:37:06.219 Demilade Agboola: I’m gonna share my screen.
309 00:37:06.610 ⇒ 00:37:07.230 Emily Giant: Okay.
310 00:37:07.380 ⇒ 00:37:10.179 Demilade Agboola: I have a list of things I need to quickly quote.
311 00:37:11.230 ⇒ 00:37:14.090 Demilade Agboola: what I will do is…
312 00:37:21.210 ⇒ 00:37:27.499 Demilade Agboola: Because, for instance, now, I had a query today that I had to query, like, 4,000 things.
313 00:37:29.710 ⇒ 00:37:36.630 Demilade Agboola: Hmm, so… Consume… Share…
314 00:37:40.580 ⇒ 00:37:41.750 Emily Giant: Interactory?
315 00:37:42.300 ⇒ 00:37:45.890 Emily Giant: Woody? Yeah. No, I… yeah, I do not. Woohoo.
316 00:37:46.460 ⇒ 00:37:47.320 Demilade Agboola: I have, like.
317 00:37:47.910 ⇒ 00:37:54.830 Demilade Agboola: Actually, it was more than this, but let’s just use this. So, I have a text thing, it’s called, Sublime Text.
318 00:37:55.950 ⇒ 00:37:58.870 Demilade Agboola: It allows me to, like, go, like, text edits and stuff.
319 00:37:58.980 ⇒ 00:38:02.580 Demilade Agboola: So, once I do, like, Command-A, it selects everything.
320 00:38:03.380 ⇒ 00:38:12.079 Demilade Agboola: and I do Command-Shift-L… And now it kind of wraps the text, and now I can go to the…
321 00:38:12.750 ⇒ 00:38:16.610 Demilade Agboola: front, like, I can move… Around, basically.
322 00:38:16.610 ⇒ 00:38:18.470 Emily Giant: Oh my gosh!
323 00:38:18.470 ⇒ 00:38:20.780 Demilade Agboola: Okay, of everything, put the comma.
324 00:38:21.130 ⇒ 00:38:25.469 Demilade Agboola: Sorry, put the quote onto the comma, go to the front, do the quote.
325 00:38:25.730 ⇒ 00:38:27.070 Emily Giant: That’s awesome.
326 00:38:27.410 ⇒ 00:38:30.890 Demilade Agboola: F1, and boom. Everything has been wrapped.
327 00:38:31.490 ⇒ 00:38:34.649 Emily Giant: That’s flippin’ awesome.
328 00:38:35.190 ⇒ 00:38:37.370 Emily Giant: It’s called… what is it called again?
329 00:38:37.740 ⇒ 00:38:38.720 Demilade Agboola: So, blind text.
330 00:38:38.720 ⇒ 00:38:43.399 Emily Giant: sublime Tech. Can you, write that in either the chat, or…
331 00:38:43.840 ⇒ 00:38:45.799 Demilade Agboola: It’s actually on Slack.
332 00:38:45.800 ⇒ 00:38:47.779 Emily Giant: Yeah. Okay, so…
333 00:38:48.010 ⇒ 00:38:52.340 Demilade Agboola: I learned about it, like, in my very first job.
334 00:38:52.840 ⇒ 00:39:01.889 Demilade Agboola: one of my colleagues who used to use it, and it was, like, a lifesaver for him, and saved my life ever since. It’s one of the first things I install every single time.
335 00:39:02.650 ⇒ 00:39:06.399 Demilade Agboola: Just for, like, text manipulation and stuff, it’s really, really good for it.
336 00:39:08.010 ⇒ 00:39:09.940 Emily Giant: Yeah, that’s flippin’ amazing.
337 00:39:10.070 ⇒ 00:39:14.720 Emily Giant: I spend a lot of time just, like, pulling in…
338 00:39:14.980 ⇒ 00:39:18.980 Emily Giant: correctly formatted things from Sheets that would save a lot of time.
339 00:39:19.430 ⇒ 00:39:20.150 Demilade Agboola: Yeah.
340 00:39:33.700 ⇒ 00:39:42.200 Emily Giant: Okay, result range… This is the three… It would be on O.
341 00:39:43.290 ⇒ 00:39:44.020 Emily Giant: 4.
342 00:39:53.060 ⇒ 00:39:53.900 Emily Giant: Okay.
343 00:39:54.380 ⇒ 00:39:55.340 Emily Giant: Nope.
344 00:39:55.650 ⇒ 00:39:56.650 Emily Giant: Maybe wrong.
345 00:39:58.880 ⇒ 00:39:59.660 Emily Giant: Oh.
346 00:40:14.300 ⇒ 00:40:16.110 Demilade Agboola: So I have meetings in about 4 minutes.
347 00:40:16.920 ⇒ 00:40:19.270 Emily Giant: Okay, I’ll keep doing QA on this.
348 00:40:19.750 ⇒ 00:40:20.760 Demilade Agboola: Okay.
349 00:40:21.280 ⇒ 00:40:22.200 Demilade Agboola: So what…
350 00:40:22.200 ⇒ 00:40:27.229 Emily Giant: Like, already, if you… hold on, let me turn this into a… can you see my screen?
351 00:40:27.560 ⇒ 00:40:28.180 Demilade Agboola: No.
352 00:40:28.910 ⇒ 00:40:32.950 Emily Giant: One sec, let me turn this into a array.
353 00:40:33.480 ⇒ 00:40:42.299 Emily Giant: I’m trying to just, like, determine if the differences are… The difference of shipping revenue.
354 00:40:42.450 ⇒ 00:40:44.800 Emily Giant: Or if it’s something more sinister.
355 00:40:46.230 ⇒ 00:40:52.320 Demilade Agboola: Oh, it’s definitely more than shipping revenue. Shipping revenue is only 98K, so… Was it 200K disparity?
356 00:40:53.230 ⇒ 00:40:58.259 Emily Giant: So this one’s, like, not even… In that one… hold on.
357 00:40:59.570 ⇒ 00:41:01.049 Emily Giant: Let me get the…
358 00:41:11.310 ⇒ 00:41:13.310 Emily Giant: Sorry, let me better align these.
359 00:41:13.690 ⇒ 00:41:14.550 Emily Giant: Okay.
360 00:41:15.690 ⇒ 00:41:20.010 Emily Giant: So, 103, 139. That’s the difference of shipping. That is not.
361 00:41:20.720 ⇒ 00:41:24.160 Emily Giant: Like, these are… that one’s not even there, that’s not there.
362 00:41:24.820 ⇒ 00:41:25.530 Demilade Agboola: Yeah.
363 00:41:28.340 ⇒ 00:41:33.900 Emily Giant: So this will give me a… like, $29, huh?
364 00:41:34.410 ⇒ 00:41:42.510 Emily Giant: So, last time this happened, it was because…
365 00:41:42.920 ⇒ 00:41:47.039 Emily Giant: products were getting obscured from LMS Comp XF.
366 00:41:47.650 ⇒ 00:41:49.530 Emily Giant: Like, because of, like, a…
367 00:41:50.060 ⇒ 00:41:59.470 Emily Giant: window function that, like… I kind of know where to look with this, because it looks like what happened last time. This just looks like…
368 00:42:01.260 ⇒ 00:42:04.460 Emily Giant: An individual unit that looks like a vase.
369 00:42:04.690 ⇒ 00:42:09.950 Emily Giant: And then, obviously, they ordered a vase and something. So then if I go into…
370 00:42:10.550 ⇒ 00:42:16.939 Emily Giant: dash… I know you have a meeting in, like, 2 seconds, but… Last thing.
371 00:42:20.620 ⇒ 00:42:26.279 Emily Giant: Yeah, like, components is only pulling the glass vase, it’s not pulling the double Catalina for some reason.
372 00:42:28.460 ⇒ 00:42:31.680 Emily Giant: So it’s just a window function issue, I’m pretty sure.
373 00:42:32.060 ⇒ 00:42:33.400 Demilade Agboola: Yeah, I know.
374 00:42:33.760 ⇒ 00:42:37.009 Emily Giant: Yep, yep. Okay, I’ll go look for that this morning.
375 00:42:37.200 ⇒ 00:42:39.490 Demilade Agboola: It’s great that OMX compact surf is…
376 00:42:39.790 ⇒ 00:42:44.880 Demilade Agboola: It’s very well written, such that it’s easy to identify the person that dropped it.
377 00:42:45.080 ⇒ 00:42:51.520 Emily Giant: It’s… yeah. Ugh, girl.
378 00:42:51.540 ⇒ 00:43:05.310 Emily Giant: It’s why we hired you guys. This model right here is why I was like, I can’t do this. I can’t do this alone. Send in the big guns. Alright, I’ll see you in a little bit. We can meet again. My afternoon is also really open.
379 00:43:05.530 ⇒ 00:43:09.859 Emily Giant: After, like, 1 o’clock, I think I don’t have anything, so…
380 00:43:10.220 ⇒ 00:43:18.859 Emily Giant: I mean, except for more work, you know, but I can definitely help to diagnose this, since this model’s been the bane of my existence for, like, a year.
381 00:43:19.360 ⇒ 00:43:25.979 Emily Giant: Alright, I definitely think we should restructure it, like, totally. Oh, I do too. It’s such garbage. It’s just such shit.
382 00:43:26.930 ⇒ 00:43:27.750 Demilade Agboola: Okay.
383 00:43:27.750 ⇒ 00:43:29.579 Emily Giant: Alright, I’ll talk to you soon.
384 00:43:29.580 ⇒ 00:43:30.399 Demilade Agboola: Hi, Ben.
385 00:43:30.400 ⇒ 00:43:31.640 Emily Giant: Okay, bye.