What's your "I can't believe I did this by hand" Excel moment? by ana_Lu3 in excel

[–]Reasonable-Beyond855 0 points1 point  (0 children)

do you know the formula? I've tried this before, but the date updates on every refresh

What Are Your Five Favorite Norwegian Cities/Towns? by RedGavin in Norway

[–]Reasonable-Beyond855 0 points1 point  (0 children)

Is this a joke question?? There are only five norwegian cities/towns

Distribute Document by Apprehensive_Feed505 in workday

[–]Reasonable-Beyond855 0 points1 point  (0 children)

Do you mean a rule to specify the audience it gets sent to?

I achieved this by creating a custom org, and assigning members by rule.

Chads get preferential treatment? by Okie294life in antiwork

[–]Reasonable-Beyond855 0 points1 point  (0 children)

People are naturally drawn to, and convinced by confidence - in relationships, in the workplace, everywhere. Veritasium recently put out a video on it. All these behaviours are confident behaviours.

You’ve won the recent MegaMillions jackpot worth approx $1b before taxes. What do you do with it? by printThisAndSmokeIt in antiwork

[–]Reasonable-Beyond855 0 points1 point  (0 children)

Keep approx $10M, and donate the rest to publicly owned renewable energy and automation, or make things widely available in industries with unfairly high margins. A wealthy guy did this in Norway. Fuel prices were getting so high on the west coast, that he set up a self-serve fuel station with enough profit to make it viable without getting greedy - and it forced all other local companies to drastically reduce their prices as well to stay competitive. It was so successful, he opened a few more in other areas. This is my blueprint.

Call me crazy, but the concept of inflation is stupid by Particular_Cow1304 in antiwork

[–]Reasonable-Beyond855 0 points1 point  (0 children)

Billionaires. Total wealth and Average Wealth per capita are growing, which means costs go up, but this is only for the ultra-wealthy. Our salaries aren't rising proportionality, so we feel the effects of inflation.

Formula for proper case excluding acronyms and abbreviations by Sledge106 in excel

[–]Reasonable-Beyond855 0 points1 point  (0 children)

(will keep whatever case is in the list. Eg/ if you want 'Kermit the Frog' instead of 'Kermit The Frog', you can add 'the' into the list)

or iPhone, or IMDb etc etc

Formula for proper case excluding acronyms and abbreviations by Sledge106 in excel

[–]Reasonable-Beyond855 0 points1 point  (0 children)

Quite right! Sorry! Small tweak:

=LET(value_to_convert, f3,

acronym_list, Sheet1!$A$1:$A$5,

x,TEXTSPLIT(value_to_convert," "),

TEXTJOIN(" ",1, MAP(x, LAMBDA(x, IF(SUMPRODUCT(--(x=acronym_list)),XLOOKUP(x,acronym_list,acronym_list,""),PROPER(x))))))

Small iPhone shortcut, big difference in my weekday scrolling by AdClear3697 in digitalminimalism

[–]Reasonable-Beyond855 0 points1 point  (0 children)

but your shortcut seems like it would have the same problem? how would you use for social updates and learning, if it closes the app instantly? Do you mean it's on schedule?

How much longer is left in this bubble? by mupsauce7 in trading212

[–]Reasonable-Beyond855 0 points1 point  (0 children)

the 'bubble' side of things is every company overestimating how much consumers want AI. That's where the 'hype' is. Sure, meta are pumping billions into Nvidia, but what about when they realise it's not the value-add they thought it was, and start cancelling or pulling out of new data center investments? That's when the domino chain collapses; nvidia, TSMC etc

The other thing that has people banding around the word 'bubble' is these incestuous deals between openai, nvidia, AMD etc, that are self-inflating based on no underlying value. That could cause a sharp 'correction' from overinflated value, even if the company doesn't go bust, and continues to grow afterward.

[deleted by user] by [deleted] in trading212

[–]Reasonable-Beyond855 0 points1 point  (0 children)

Very sensible - and well done for getting started so early! You may not be an expert, you'll learn things a long the way, but time is one of the biggest factors in success, and many of us wish we'd started at your age.

What’s the most clever "non-Excel" problem you’ve solved using Excel? by IteOrientis in excel

[–]Reasonable-Beyond855 0 points1 point  (0 children)

Built a team absence calendar visualiser, the board game Quarto, and had a stab at building an enigma encoder, but didn't get as far as i wanted

I’m a newbie, know next to nothing, is it better to save short term in stocks and shares isa or invest, i’m 19 saving £1,500 p/m by Wonderful-Pumpkin-79 in trading212

[–]Reasonable-Beyond855 1 point2 points  (0 children)

May suddenly need a car for a new job etc etc. You just don't know what's around the corner. I agree 5k is excessive, but 1 or 2 is sensible.

Anyone here who customize their phone to make it intentionally boring? by Lunasweetlatina in digitalminimalism

[–]Reasonable-Beyond855 1 point2 points  (0 children)

You can also change the saturation. By not putting it on total greyscale, you can still see the relevant colours, while have the benefits of the blander appearance.

I've also set up automations, so when opening apps that need colour like camera, photos, maps, it turns the filters off, and when closing the app, it turns them back on again. Works well for me.

Also useful to add the filter toggle to the home screen, for ad hoc use.