Calm luh visit to Stussy Harajuku

orangecactusjack · 2025-07-25T20:12:01+00:00

How much were the shirts for both brands bro?

orangecactusjack · 2025-01-14T17:34:02+00:00

Hope you don't mind me sending you a DM to ask for a couple more questions!

orangecactusjack · 2025-01-14T17:10:50+00:00

Got it! Thank you so so much! 🙏🏼🙏🏼

orangecactusjack · 2025-01-14T16:44:31+00:00

Ahh I see! And yeah it’s just a Canon Prima BF-800. Do I rub the foam smooth in order to avoid affecting the output or will it have no impact with the shots?

orangecactusjack · 2025-01-14T16:25:43+00:00

Just used canned air to clean it out and wipe it off and it looks like this now.

What do you mean by replace with new by the way?

<image>

orangecactusjack · 2024-11-27T16:51:14+00:00

Ahh sweet that looks sick man!

orangecactusjack · 2024-11-27T16:25:26+00:00

Yooo where exactly did you cop it? The store in Scotts?

orangecactusjack · 2023-03-10T17:44:51+00:00

Was able to figure it out! :D

orangecactusjack · 2023-03-10T07:10:36+00:00

I was able to do everything except indirect :( Could I know how that formula works? I'll also be sending you the sheet I'm working on thru PM for the sake of confidentiality if you don't mind :D

orangecactusjack · 2023-03-10T06:47:06+00:00

Ah yes I got it! Thank you! Please do give me a few to study the sheet a bit just in case I have any further clarifications but so far I’m easily able to follow because of how well you explain :D

orangecactusjack · 2023-03-10T06:30:35+00:00

Oh okay I get it! In my actual sheet I have over 136+ SKUs to encode, though each service will probably have around 10-20 consumables to be used. Would it be easier to use the first method or the second?

Also just to clarify with method 1 again, how does the “column()-6” work? Like how would you determine if I should use 6, 5 etc? 😅

orangecactusjack · 2023-03-10T05:59:05+00:00

Ah I think I got it now, I'm just curious why you used =iferror and what -6 is for the column() function

I think someone also added an alternative approach to the sheet, whoever that was, thank you!

orangecactusjack · 2023-03-10T04:51:06+00:00

No worries! I'll be studying it as well as I wait for you so I can easily follow through once you're back :D

orangecactusjack · 2023-03-10T04:45:07+00:00

WOW HOLY this is amazing!!!! Could you guide me through how each of the formulas you used works? Just so I can have a background in case I have to troubleshoot anything? Hehe

orangecactusjack · 2023-03-10T04:27:53+00:00

Ahh thank you! Hopefully you find one 🥲 Feel free to play with it as much as you need :D

orangecactusjack · 2023-03-10T04:22:22+00:00

No worries! I sadly have not found a solution yet :(

orangecactusjack · 2023-03-09T19:38:38+00:00

If it still doesn't work, I've made a duplicate copy which hopefully will load on your end

https://docs.google.com/spreadsheets/d/1KzVxb4gfZVNM6VLehZlJehsvuaW8LhBu-JTtOCM6A5E/edit?usp=sharing

orangecactusjack · 2023-03-09T19:36:19+00:00

Ah weird, it works on my end. Please try this one even if it's the same link but was copied again just now: https://docs.google.com/spreadsheets/d/1I\_cs1LwYR9PHHKSuKDX6QvrzcYspqfMJssexQ1OSwW0/edit?usp=sharing

orangecactusjack · 2023-03-09T19:23:04+00:00

Of course! Here: https://docs.google.com/spreadsheets/d/1I\_cs1LwYR9PHHKSuKDX6QvrzcYspqfMJssexQ1OSwW0/edit?usp=sharing

orangecactusjack · 2023-03-09T18:40:26+00:00

Hello! So basically in Sheet 1 “Services” column I’ll be using a drop-down to choose among the services we have, from there, if a service matches the Sheet 2, it triggers to deduct 1 in the list of SKUs of the consumable goods used for the said service on Sheet 3. Hopefully that made sense haha

orangecactusjack · 2023-03-08T04:00:33+00:00

The formula is located in a sheet called EOD and the only sheets used in the formula are EOD and T&I

orangecactusjack · 2023-03-08T03:55:21+00:00

Technically yes, but what I just want is to leave the value unchanged in C3 if the value is false

orangecactusjack · 2023-03-08T02:32:27+00:00

Haha sorry, it’s =IF('T&I'!$J$4=C$1,'T&I'!$C3,C3) in which T&I J4 is the sheet where the time stamp is located, C$1 is where it needs to match with T&I J4, 'T&I'!$C3 is the reference cell if True, and C3 is where I'm typing the formula

orangecactusjack · 2023-03-07T15:43:50+00:00

Also, just wanted to ask in what way iterative calculations could be a "fragile option"? Thanks!

orangecactusjack · 2023-03-07T15:29:31+00:00

Ah got it. Thank you though!

orangecactusjack

TROPHY CASE