What soap/cream did you use today?

Tobacco Tuesday

RazoRock Santa Maria del Fiore Firenze

C U all tomorrow

Sent from my SM-A536U using Tapatalk

Felce Aromatica (Saponificio Varesino) easy green

I’ve rigged my spreadsheet to choose a soap for me each day at random.

Very interesting and intriguing concept!  As a fellow wet shaving/Excel enthusiast, which function are you using and how did you set it up to do it daily?  Or are you just entering a new random function each day?

HoosierShave, I'm afraid I don't use Excel. Instead I use Apple Numbers. But I think the functions I call are also available in Excel. Let me see if I can explain how the randomizer works.

Before I start, I should note that I have a table named "Soaps" that lists the names of all my soaps. Each line of the table lists four items: A. a unique number, B. a location code, C. the artisan's name, and D. the soap's name. I have my hoard spread out over two places: some are here in the islands, some on the mainland. If you have your entire collection in one place, you can just use the COUNT function to count how many soaps you have. 

This is the code for the randomizer: VLOOKUP(RANDBETWEEN(1,COUNTIF(Soaps::B,"H")),Soaps::A: D,4). 

Comments

1. COUNTIF(Soaps::B,"H"): First I ask my spreadsheet to count how many soaps I have here in Hawaii (that's what the "H" stands for). "Soaps" is the table I just mentioned, the one listing all my soaps. The location code is listed in column B, so COUNTIF counts all the soaps in column B that have a location code "H".

2. (RANDBETWEEN(1,COUNTIF(Soaps::B,"H")): Then I ask RANDBETWEEN to select a random number between 1 and the number returned by COUNTIF.

3. VLOOKUP(RANDBETWEEN(1,COUNTIF(Soaps::B,"H")),Soaps::A: D,4): Then I send that number to the VLOOKUP function.

4. VLOOKUP searches column A of the "Soaps" table for the random number generated by RANDBETWEEN. Then, it returns the name of the soap found in column 4 within that search range. In other words, it looks for your random number in the Soaps table (A to D) and gives you the name of the Soap of the Day from the fourth column.

So, a really simple piece of code, but it works well enough for my needs. Every time I change something in the spreadsheet, the randomizer chooses a new soap. That's a little annoying. I wish it would only run once a day at a certain time, but I haven't figured that out yet. I hope you're having fun with your spreadsheeting, too.

Entropy Man (Wholly Kaw) plum tobacco
Shave 1 ・ 117 g left

Tobacco Tuesday: I think I would like this soap more if the fragrance didn’t remind me of the smell of the crystals the bus driver sprinkles on the seat after one of his riders has been sick. Great name, though, and as always with Wholly Kaw, an awesome lather.
____________
Brush Semogue 620 ・ Razor Edwin Jagger DES89RC Kelvin ・ Blade Derby Extra

Felce Aromatica (Saponificio Varesino) easy green

I’ve rigged my spreadsheet to choose a soap for me each day at random.

Very interesting and intriguing concept!  As a fellow wet shaving/Excel enthusiast, which function are you using and how did you set it up to do it daily?  Or are you just entering a new random function each day?

HoosierShave, I'm afraid I don't use Excel. Instead I use Apple Numbers. But I think the functions I call are also available in Excel. Let me see if I can explain how the randomizer works.

Before I start, I should note that I have a table named "Soaps" that lists the names of all my soaps. Each line of the table lists four items: A. a unique number, B. a location code, C. the artisan's name, and D. the soap's name. I have my hoard spread out over two places: some are here in the islands, some on the mainland. If you have your entire collection in one place, you can just use the COUNT function to count how many soaps you have. 

This is the code for the randomizer: VLOOKUP(RANDBETWEEN(1,COUNTIF(Soaps::B,"H")),Soaps::A: D,4). 

Comments

1. COUNTIF(Soaps::B,"H"): First I ask my spreadsheet to count how many soaps I have here in Hawaii (that's what the "H" stands for). "Soaps" is the table I just mentioned, the one listing all my soaps. The location code is listed in column B, so COUNTIF counts all the soaps in column B that have a location code "H".

2. (RANDBETWEEN(1,COUNTIF(Soaps::B,"H")): Then I ask RANDBETWEEN to select a random number between 1 and the number returned by COUNTIF.

3. VLOOKUP(RANDBETWEEN(1,COUNTIF(Soaps::B,"H")),Soaps::A: D,4): Then I send that number to the VLOOKUP function.

4. VLOOKUP searches column A of the "Soaps" table for the random number generated by RANDBETWEEN. Then, it returns the name of the soap found in column 4 within that search range. In other words, it looks for your random number in the Soaps table (A to D) and gives you the name of the Soap of the Day from the fourth column.

So, a really simple piece of code, but it works well enough for my needs. Every time I change something in the spreadsheet, the randomizer chooses a new soap. That's a little annoying. I wish it would only run once a day at a certain time, but I haven't figured that out yet. I hope you're having fun with your spreadsheeting, too.

Pretty much Excel equivalent formula construction. Little zaftig but effective

Rex 1966


Sent from my iPhone using Tapatalk

Wednesday October 4, 2023
Razor: Blackland ERA OC Plate 5
Blade: Wizamet
Brush: Trotter Burnt Butterscotch/Badger
Soap: Declaration Grooming Sweet Lemon
AS : CFG Santa Paula
Fragrance:
Consecutive Daily Shaves - # 1,793

Sweet lemon is a lemon cream pie scent that is present but not overdone. Don't eat it. It tastes like ......SOAP. But it shaves very good along with the enjoyable fragrance while whisker removing. Everyone have a great day !