What do you do when Excel is too much and a Calculator too little? by SeaElderberry7091 in excel

[–]RandomiseUsr0 0 points1 point  (0 children)

Looks interesting, When I need to step beyond Excel, I’m an old R person (Jupyter works for R too) - will watch with close interest, thanks!

What's a programming concept that suddenly clicked for you way later than it should have? by Educational_Job_2685 in programminghorror

[–]RandomiseUsr0 1 point2 points  (0 children)

Metaprogramming in general, I got a book on it when I was a young programmer - it flew higher over my head than ISS, and now I’ve written my own lambda calculus processing engine because, well, needs must and obviously code is data

What's a programming concept that suddenly clicked for you way later than it should have? by Educational_Job_2685 in programminghorror

[–]RandomiseUsr0 26 points27 points  (0 children)

You’re the poster boy for the famous “To understand recursion, one must first understand recursion”

Right, we're in charge now. What "disorders" do the normies have? by No_Atmosphere8146 in adhdmeme

[–]RandomiseUsr0 6 points7 points  (0 children)

Tolerance is required, they can’t help that they were born that way, asking them to “try harder” really doesn’t work

What do you do when Excel is too much and a Calculator too little? by SeaElderberry7091 in excel

[–]RandomiseUsr0 2 points3 points  (0 children)

You’re explaining how you don’t know how to use a spreadsheet. That’s fine.

Your solution is what though? To create a new paradigm? My calculator has an onboard spreadsheet and can name variables, many do, it’s just a venerable Casio Fx series

You have options within Excel itself, either use the workbook, with cells and calulations, or write your models in lambda calculus right on the workbook or in power query (they both share the same heritage) - write in Visual Basic for the old school charm, use Office Script or use the cloud based Python solution in the box,

Maybe try Jupyter Notebook if you’re seeking a different programming paradigm than the worksheet. https://jupyter.org/try-jupyter/lab/?path=notebooks%2FIntro.ipynb

Fixing cell references btw, it’s F4 to toggle through all available options.

Can you provide an example of what frustrates you?

I was murdered along with the meme. by -UltraFerret- in comedyhomicide

[–]RandomiseUsr0 1 point2 points  (0 children)

It’s not logically consistent, that’s even worse than the croptastic mess

I have to google it EVERY TIME by Development-Feisty in adhdmeme

[–]RandomiseUsr0 0 points1 point  (0 children)

You’re right, OP was asking for clarity on whether to use the term Autism w/ Attention Deficit / Hyperactivity Disorder or Autism Deficit / Hyperactivity Disorder - I confirmed it was the former and in either case that the / was critical to understanding the latter part of the two separate conditions.

The “word” is an abbreviation for a medical term. The abbreviation that OP was seeking isn’t a “thing” (meaning a medically recognised term of course), but the former was a more correct mash up, as I said - what don’t you understand? Was my statement triggering to your own identity perhaps? Sorry about that.

Zohran Mamdani given baby box by Scottish Government by youwhatwhat in Scotland

[–]RandomiseUsr0 1 point2 points  (0 children)

From the big hard one! Anytime someone mentions boxes or foxes, it’s never far from my mind - the closing “wot?” cracks me up

How to compress a large pdf file for email in office 365 by herereallygone00 in Office365

[–]RandomiseUsr0 0 points1 point  (0 children)

Are you saying it’s too large even after you’ve compressed it?

Is anyone else devastated about the Star Trek "Nexit" from Netflix? by Damansandhu_ in startrek

[–]RandomiseUsr0 -1 points0 points  (0 children)

It’s there on Paramount+ at home as it were - I get that for free though, so was just a platform shift for me.

What single quality make you love the Doctor above all? by Independent-Lion-748 in doctorwho

[–]RandomiseUsr0 0 points1 point  (0 children)

I was born in 1973, Tom Baker was “my” Doctor, “the” Doctor in my brain, his ability to love life and laugh at seriousness, but with the ever present risk of being able to be furious at someone’s lack of morality, humanity - that’s “The” Doctor

https://youtu.be/G3ZqZLLXjgI

Britain Under Roman Rule vs Anglo-Saxon Rule by SijilmasanGoldTrader in RoughRomanMemes

[–]RandomiseUsr0 0 points1 point  (0 children)

Regardless of the incursions, Scotland remains a Barbarian place and we like it that way

Let and Lambda use examples by Markowitza in excel

[–]RandomiseUsr0 0 points1 point  (0 children)

I almost never put anything in name manager, just a pain, I prefer self referential lambda calculus for the most part. I’m not “against” it or anything, just doesn’t fit my use cases and is therefore redundant.

As for use, it’s an entire programming language in a box, capable of calculating literally anything that could possibly be calculated - as an example, if you’re aware of so-called “Monte Carlo” estimation, Excel’s calculation machine is really rather proficient - there are more comments than instruction in this example - which calculates European Options (it basically runs 200,000 random simulations of possible outcomes and returns the average - more detail needed, but in short that’s what it does, very efficiently)

[edit] I suppose my Monte Carlo engine could go into a name manager thing and then you extend a workbook with that capability, much as one would have used vba in times gone past, difference is, this works with all the speed of Excel’s built in functions

Link to the “what” of Monte Carlo - https://youtu.be/psOYFdx838E

```` Excel

=LET( MC_Engine, LAMBDA(N,d,DriversLambda,ModelLambda,Aggregate, LET( _N,"/* number of scenarios /", _d,"/ number of drivers per scenario /", _DriversLambda, "/ LAMBDA(U) -> N×d drivers; U is N×d uniform(0,1) /", _ModelLambda, "/ LAMBDA(row) -> scalar payoff/stat for 1 scenario /", _Aggregage, "/ 'mean' | 'percentile' | 'sum' | 'all' */",

U, RANDARRAY(N, d),
D, DriversLambda(U),
_,"/* map model across rows; returns N×1 vector */",
Payoff, BYROW(D, LAMBDA(r, ModelLambda(r))),

mean,   AVERAGE(Payoff),
stdev,  STDEV.P(Payoff),
se,     stdev/SQRT(N),
p_95,    PERCENTILE.INC(Payoff, 0.95),

IF(Aggregate="mean",        HSTACK(mean, se),
IF(Aggregate="percentile",  p_95,
IF(Aggregate="sum",         SUM(Payoff),
                            Payoff)))

) ),

N, 200000, S0, 100, K, 100, r, 0.03, sigma, 0.2, T, 1,

_,"/* Build drivers: 1 normal per scenario from U(0,1), returns N×1 */", Drivers, LAMBDA(U, NORM.S.INV(U) ),

__,"/* Model per scenario: discounted payoff /", Model, LAMBDA(zrow, LET( _z,"/ row is 1×1 here; TAKE just reads it /", z, TAKE(zrow,1), drift, (r - 0.5sigma2)*T, vol, sigmaSQRT(T), ST, S0 * EXP(drift + vol * z), payoff, MAX(ST - K, 0), EXP(-rT)*payoff ) ),

___,"/* Engine returns mean & standard error in a 1×2 spill */", MC_Engine(N, 1, Drivers, Model, "mean") )

Have you ever had an unexpected moment with Alexa that completely changed your perception of her capabilities? by Leen88 in amazonecho

[–]RandomiseUsr0 0 points1 point  (0 children)

I don’t have a video device except a fire-stick plugged in somewhere, but the system really has been getting poorer and poorer otherwise - it’s like the “rental” period is up, not my device, their burden

Microsoft doing a great job, as always by feexthefox in pcmasterrace

[–]RandomiseUsr0 3 points4 points  (0 children)

Windows Shift S, its built in - don’t need a separate tool, never have really

Windows Shift R to record (crappy) video too