3
points
harperlee
Joined 5,250 karma
To contact me write to atienzar256 at the mail of Google dot com.
- Named ranges! Also newer Excel versions provide you the LET function, which is neat for documentation (naming) of intermediate steps:
It also avoids recomputing intermediate stuff. You can also encapsulate things in a LAMBDA anonymous function:=LET(data; F4:F34; dummy1; "This is a made up average function; this string is ignored"; dummy2; "one limitation is that you cant really overwrite variable names"; tally; COUNTA(data); total; SUM(data); total/tally)
You could also move the LAMBDA to the name registry and use that function similarly to how you would use a named range or a built-in formula!=LET(data; F4:F34; mymeanfunction; LAMBDA(data; LET(tally; COUNTA(data); total; SUM(data); total/tally)); mean1; mymeanfunction(data); mean2; mymeanfunction(OFFSET(data;0;1));doc;"FIXME, this should have its own variable name to refer explicitly to G4:G34"; AVERAGE(mean1;mean2))Coming from a lisp background, I was ecstatic to see this, but they have heavy technical limitations. I did play a little bit though with these concepts and the dynamic array functions. Fun functions to explore:
There's more!- DROP, TAKE, CHOOSECOLS, CHOOSEROWS to cut arrays - INDEX, OFFSET, COLUMN, ROW to navigate - WRAPCOLS, WRAPROWS, TOROW, TOCOL, VSTACK, HSTACK, TRANSPOSE to shape arrays - MAP, SCAN, REDUCE to compute on top of arrays - I was just speaking generally, I also don't have a side there. But for clarity, what I meant is that templates to the tune of "[subset of people with X characteristic] are more / less prone to [Y characteristic]" can construct blatantly false sentences, and also sentences that, irrespective of whether they are true (or that they are falsifiable at all, as you add), have a heavy political penalty.
I also don't think that's bad - you can say blatantly racist things with that template, and I'm ok with those things not allowed to be said in lots of contexts.
- Whether one is allowed to pose some particular questions is a political topic though!
- 100% agree! I find quite concerning that this point is not immediate in any conversation about AI or robots impacting the number of jobs, and the subsequent conversation about innovating new taxes. AI and robots are capital as any other automation on a factory, and capital gains should be taxed appropriately. This is not a new thing completely separate from the untouchable status quo wrt existing taxes. If it tickles your political kneejerk, explore that, but playing tax sci-fi is distracting and thus dangerous.
- 137 points
- It is a government who says that…
- That is not surprising. Regulations are a way to ensure things that are not easily reached by market forces. Doesn’t mean that we should not care for that.
- GDPR is not about the cookie banner, it has massive implications around the whole lifecycle of data. For example you need to be able to gather all data of a particular client for them to access, and they have the right for all their data to be erased.
- XOR is a simple operation that shows that behavior.
- 1 point
- It's related to nostalgia. If you have lived at the time where dithering was used, you will have an emotional response to it. For example, if you played games as a child with dithering, then playing The Return of the Obra Dinn, which was mentioned in other thread, will take you back to a happy place.
And even if you did not live at that time, exposure to that distinct visual style will also start having meaning to you. Like how an exposed brick interior wall has a distinct aesthetic, and carries connotations of an industrial space.
- 2 points
- 3 points
- 2 points
- That only works if the mean stay in the hospital (or at least the critical care period) is several hours but also way below 24h…
- Game for kids, where you dedicate a third of the screen to a locked hint list and a very prominent "Buy Hint Tokens" button? Hard pass.
https://www.hacktivate.app/img/framed-ipad-3.png
The game industry needs to move away from milking vulnerable people with pay-to-win schemes.
- Not sure about a movie but that reminded me of the "Driver" short story in the "Valuable Humans In Transit and Other Stories" tome by QNTM (https://qntm.org/vhitaos).
I'd recommend to buy the book, but here's an early draft of that particular story:
I played with them and even tried to build a minikanren, but on my day to day job I just use them tactically, so I avoid their limitations and I'm quite happy with them for that.
From memory: