Did someone say PSYCHIC pathology?

Chuck Shumer Chose to postpone book tour… be a shitweasel. FTFY².

Lemmy algorithm so hot right now:

And all this time, I thought it was the cake that was a lie…

while sly PI stole my mind into infinite cries

of WHY CAN’T IT JUST BE 3.1415???!?!!

You’re correct - the standard tabs can only hold roughly 1.2 million rows.

The way to get around that limitation is to use the Data Model within Power Pivot:

It can accept all of the data connections a standard Power Query can (ODBC, Sharepoint, Access, etc):

You build the connection in Power Pivot to your big tables and it will pull in a preview. If needed, you can build relationship between tables with the Relationship Manager. You can also use DAX to build formulas just like in a regular Excel tab (very similar to Visual Basic). You can then run Pivot Tables and charts against the Data Model to pull out the subsets of data you want to look at.

The load times are pretty decent - usually it takes 2-3 minutes to pull a table of 4 million rows from an SQL database over ODBC, but your results may vary depending on datasource. It can get memory intensive, so I recommend a machine with a decent amount of RAM if you’re going to build anything for professional use.

The nice thing about building it out this way (as opposed to using independent Power Queries to bring out your data subsets) is that it’s a one-button refresh, with most of the logic and formulas hidden back within the Data Model, so it’s a nice way to build reports for end-users that’s harder for them to fuck up by deleting a formula or hiding a column.

Seriously - I can parse multiple tables of 5+ million row each… in EXCEL… on a 10 year old desktop and not have the fan even speed up. Even the legacy Access database I work with handles multiple million+ row tables better than that.

Sounds like the kid was running his AI hamsters too hard and they died of exhaustion.

Paternity leave saved my life when I was a young father with an ill wife. Take as much time as you can.

Also, side note, the year I took off of work to care for them when my sons were small (3 and 5) I look back on as one of the best decisions I ever made. Despite the fact we were flirting with homelessness, the bonding and memories made a huge impact on them, and now that they’re adults, we have an amazing relationship that far surpasses the distant bond I have with my own father.

Picard’s Mom has entered the chat…

THAT was why the bus ride felt like a rodeo. TIL.

Kinda thankful now I took the train on the way out.

I have no defense against the Picard Maneuver. Done.

JFC, grow a sense of humor already.

First off, it’s not his work. It’s a parody. Political satire has been in use for thousands of years. Do we ban the Producers because it has “Springtime for Hitler”? No, because every person with half a brain cell knows that it’s a joke.

Secondly, following your logic, we shouldn’t discuss what these Nazi fucks do or say, because that would be platforming them. That’s exactly what they want you to do - censorship is kinda the highlight of a fascist regime.

Take a breath, pull your head out of your moral panic, and laugh a little. This /c/memes, not /c/politics.

Yes. The shit-weasel caved in less than 24 hours.

Grey filter to slightly more grey filter… or at least that’s how it was when I visited in November.

Done.

It’s from /r/stonetossingjuice - it’s a rewrite of a fascist comic ala bonehurtingjuice style.

Not gonna post the original because fuck that guy, but I do love a good subversion of fascist propaganda.

Brazenly stolen from /r/stonetossingjuice because fuck reddit and it tickled my lemming.

TIL Schumer means Shitweasel in Yiddish.

LPT:

“What are you expecting to make?”

Correct answer: Your real target (based on your own market research for the position) +15%.

Why? Because they’re going to target your acceptable range at -10%, and make the offer right around there.

Then, you can come back and say “I might be able to make that work, as long as X, Y and / or Z are part of the package” where XYZ is anything from remote work to reimbursement for commute mileage.

If they say no to the added XYZ and you’re desperate, well go ahead and accept, because you’ve just earned yourself +5% of what you were targeting. If they say yes, well, even better.

Don’t go higher than 15% - this could kill the offer entirely if you misjudge the interview. 15% seems to be the sweet spot in my experience, based on a 30 year career.