Kind of unrelated, but a coworker shared a spreadsheet with me the other day, and instead of dragging down to autocomplete the row number or using ctrl+d, he wrote a “1” then “A1+1” and dragged that down. It kept breaking because the rows had to be rearranged, and if you initially highlighted a modified row before dragging it would propagate the error down.
It's a valid method that avoids some edge cases where Excel's autocomplete gets confused. He just forgot the last step of copy and then paste back into the same cells as text to remove the formula.
My pet peeve is my coworker who finds it easier to write macros to analyze the data instead of setting up formulas, and then I am completely unable to follow his analysis logic because it's all just columns of numbers with no way to tell what was used to calculate what.
Excel is legitimately incredibly impressive though. That’s like saying imagine how impressed they would be that we’ve been to space and eradicated diseases.
I’m not a computer person though, so maybe I’m just the easily impressed Sumerian farmer, proving your point.
An uncomfortable amount of my ability to sell myself as an employee is how good I am with excel, and yeah it's an impressive piece of software. Hand written spreadsheets are a useful accounting tool that can be bastardized for purposes that can be framed in accounting language (stuff like unit conversions and keeping track of inputs and outputs).
But excel does stuff like allowing you to make values change as dependent values change. It goes from the Sumerians tracking how much wheat each person has and the taxes they owe being calculated by hand to, in the size of a few clay tablets being able to automatically calculate it, factor in debts, and then look at every prior year. And it takes no more space for the tax collector to fit all the people they collect from. And they can share it with the Temple easily. And that's without considering all the ways it'll help merchants and be useful for distributing resources to the wards of the temple. And depending on the math abilities of the craftspeople they may also find it useful
It is funny seeing an increase in young men trying to retcon their choice to not pursue higher education by claiming "real men do blue collar work".
My field used to be like 95% men when I started around 20 years ago. I work in medicine, but our specialty uses a lot of heavy machinery and tools to fabricate custom braces and prosthetics. I work at a university hospital and we haven't had a male resident in like 5 years.
It’s funny because if you dip your toes into a lot of blue collar work, you’ll find it still requires (or at least significantly benefits from) college education. I’ve met a few people majoring in landscaping or recreation, there’s a lot of advanced shit to learn. I know I sure as hell couldn’t figure out how to use plants to draw water uphill, but that’s what one of the places I volunteer at is doing with their planting. It’s not just men standing around grunting at each other and doing whatever until it looks decent.
Was sitting in a capstone senior class at my liberal arts university. Happened to be taking it with a bunch of business majors. Some dipshit derails the entire class by saying "why do we need to learn any of this stuff, like history? I just want to make money."
"Haven't you ever heard the phrase about history repeating itself?"
"Well, if it's going to repeat itself, then I'll just learn about it when it happens again."
There was a literal business school like five miles down the road. And this guy chose to enroll in a liberal arts university and stay for four years. I get that the industrialization of higher education gave us that bullshit "go to college in order to get a higher paying job" and so this dude clearly just bought into that. But... again, no one was forcing him to go to a liberal arts school.
Also... Business has a history. Money has a history. If you want to make money and keep it, learning what happens before a crash or what sort of business practices tend to get you dragged out and hanged from a tree might be kinda helpful.
"I'll learn about it when it happens again" heading into the AI bubble is absolutely wild. People have jumped from buildings over the shit that is about to go down.
In engineering school we made fun of how the people only in it for the money all wind up changing to a business major in year 2 or 3. The money is a big thing for certain, but you have to actually be passionate about it in order to get through the education. It's baffling someone could care that little in a major famous for not being great financially
Taxes are the price we pay for a civilized and functional society. And spreadsheets are just plain cool. I really don't get people who hate spreadsheets. It is literally the best way to organize information.
Spreadsheets are cool. Where they fall apart they fall apart spectacularly from people insisting on using them as an alternative to a database solution, in my experience. It doesn’t generally matter for normal user centric use cases but I’ve also had to perform a post bankruptcy audit on more than one company that trying to over leverage spreadsheets of duplicate, inconsistent, over saturated, and unreliable data was at the very least a significant contributing factor for the doors being shut.
Over ten contract managers all with their own version of a spreadsheet that tracks reportable items for their contracts and gets rolled up to a master spreadsheet via formulas that financial business decisions gets made from is the first immediate example that comes to mind.
The disdain for spreadsheets comes from people who don't understand data organization, or people who do.
Tabular data? Good. Schemaless? Unstructured? Probably maintained by eleventy-four random sales people and an account? Being given to me like it's a gift and expecting me to just magic it into some reporting system? On a recurring basis? No. Please God no.
I can be trusted to use a spreadsheet for my things that I don't share. Other people need to use something that will yell at them when they give it malformed gibberish.
Oh, and executable logic doesn't belong in the same context as data. That shit needs to be able to be told apart from the data.
Where do you think the infrastructure for society comes from dude? Organization and proper funding enables all the things you like and keeps you from being left in the middle of the wilderness to fend for yourself.
Glistening with sweat, displaying their power with every movement - the biceps, the pectorals, the glutes. Appearing through the dust they worked up while performing their task, unphased by the swirl of nature around them, unbound by the chaotic entropy of the multidimensional Coriolis vortex that they themselves stand at the point of, defiant, inevitable. Adorned with bronze, forged from the same Earth they demand fealty of.
Little rills of sweat making temporary clean streaks in the dust, tracing down across the belt of Adonis, pointing to what is hidden but implied... Sorry, where was I? Plowing. Right, plowing, like manly, definitely straight guys.
I'm having a hard time understanding this. Is feminity considered a bad thing? Is the use of spreadsheets being looked down on here? Is the trade of grain in ancient Samaria look being looked down on?
They find strong sweaty guys sexy and are confused by it (because they are obviously not gay), so they refuse it and project it as feminime man = gay = bad, and by extension, man doing feminime thing = weak = bad. People who never really learned to reason and question.
Sumerians built and invented a lot of stuff. You see, nobody had done anything yet, so there was a lot of catching up to do. So really it was more important than writing stuff is for us in a way. Plus selling stuff, history (aka yesterday), instructions, etc.
Carlos Solís
in reply to The Picard Maneuver • •People Twitter reshared this.
TropicalDingdong
in reply to The Picard Maneuver • • •like this
SolacefromSilence likes this.
Zombiepirate
in reply to TropicalDingdong • • •like this
Carlos Solís likes this.
StillAlive
in reply to TropicalDingdong • • •"So you do vlookup like this and then drag it down to autofill."
"𒀝𒋗 𒈠 𒀭𒉈 𒁀𒀭𒌅𒈬"
binarytobis
in reply to StillAlive • • •Kind of unrelated, but a coworker shared a spreadsheet with me the other day, and instead of dragging down to autocomplete the row number or using ctrl+d, he wrote a “1” then “A1+1” and dragged that down. It kept breaking because the rows had to be rearranged, and if you initially highlighted a modified row before dragging it would propagate the error down.
You’re an engineer, damnit.
Lyrl
in reply to binarytobis • • •It's a valid method that avoids some edge cases where Excel's autocomplete gets confused. He just forgot the last step of copy and then paste back into the same cells as text to remove the formula.
My pet peeve is my coworker who finds it easier to write macros to analyze the data instead of setting up formulas, and then I am completely unable to follow his analysis logic because it's all just columns of numbers with no way to tell what was used to calculate what.
egrets
in reply to StillAlive • • •rockerface🇺🇦
in reply to egrets • • •idiomaddict
in reply to TropicalDingdong • • •Excel is legitimately incredibly impressive though. That’s like saying imagine how impressed they would be that we’ve been to space and eradicated diseases.
I’m not a computer person though, so maybe I’m just the easily impressed Sumerian farmer, proving your point.
TropicalDingdong
in reply to idiomaddict • • •ftfy
captainlezbian
in reply to idiomaddict • • •An uncomfortable amount of my ability to sell myself as an employee is how good I am with excel, and yeah it's an impressive piece of software. Hand written spreadsheets are a useful accounting tool that can be bastardized for purposes that can be framed in accounting language (stuff like unit conversions and keeping track of inputs and outputs).
But excel does stuff like allowing you to make values change as dependent values change. It goes from the Sumerians tracking how much wheat each person has and the taxes they owe being calculated by hand to, in the size of a few clay tablets being able to automatically calculate it, factor in debts, and then look at every prior year. And it takes no more space for the tax collector to fit all the people they collect from. And they can share it with the Temple easily. And that's without considering all the ways it'll help merchants and be useful for distributing resources to the wards of the temple. And depending on the math abilities of the craftspeople they may also find it useful
TranscendentalEmpire
in reply to The Picard Maneuver • • •It is funny seeing an increase in young men trying to retcon their choice to not pursue higher education by claiming "real men do blue collar work".
My field used to be like 95% men when I started around 20 years ago. I work in medicine, but our specialty uses a lot of heavy machinery and tools to fabricate custom braces and prosthetics. I work at a university hospital and we haven't had a male resident in like 5 years.
Catoblepas
in reply to TranscendentalEmpire • • •Zirconium
in reply to Catoblepas • • •joostjakob
in reply to Zirconium • • •CancerMancer
in reply to joostjakob • • •Whats_your_reasoning
in reply to Zirconium • • •FrChazzz
in reply to TranscendentalEmpire • • •Was sitting in a capstone senior class at my liberal arts university. Happened to be taking it with a bunch of business majors. Some dipshit derails the entire class by saying "why do we need to learn any of this stuff, like history? I just want to make money."
"Haven't you ever heard the phrase about history repeating itself?"
"Well, if it's going to repeat itself, then I'll just learn about it when it happens again."
There was a literal business school like five miles down the road. And this guy chose to enroll in a liberal arts university and stay for four years. I get that the industrialization of higher education gave us that bullshit "go to college in order to get a higher paying job" and so this dude clearly just bought into that. But... again, no one was forcing him to go to a liberal arts school.
teslekova
in reply to FrChazzz • • •CancerMancer
in reply to teslekova • • •captainlezbian
in reply to FrChazzz • • •4am
in reply to TranscendentalEmpire • • •Dumb and reactionary is cool because it's easy, leaving you more time to bro.
I wonder if lead poisoning can be passed down hereditarily?
MutantTailThing
in reply to The Picard Maneuver • • •Only planet known to support life in the entire universe and all of existence.
Let’s have spreadsheets and taxes and shit.
like this
zout y OfCourseNot like this.
Ech
in reply to MutantTailThing • • •MutantTailThing
in reply to Ech • • •buddascrayon
in reply to MutantTailThing • • •Waraugh
in reply to buddascrayon • • •Spreadsheets are cool. Where they fall apart they fall apart spectacularly from people insisting on using them as an alternative to a database solution, in my experience. It doesn’t generally matter for normal user centric use cases but I’ve also had to perform a post bankruptcy audit on more than one company that trying to over leverage spreadsheets of duplicate, inconsistent, over saturated, and unreliable data was at the very least a significant contributing factor for the doors being shut.
Over ten contract managers all with their own version of a spreadsheet that tracks reportable items for their contracts and gets rolled up to a master spreadsheet via formulas that financial business decisions gets made from is the first immediate example that comes to mind.
captainlezbian
in reply to Waraugh • • •FrChazzz
in reply to buddascrayon • • •ricecake
in reply to buddascrayon • • •The disdain for spreadsheets comes from people who don't understand data organization, or people who do.
Tabular data? Good.
Schemaless? Unstructured? Probably maintained by eleventy-four random sales people and an account? Being given to me like it's a gift and expecting me to just magic it into some reporting system? On a recurring basis? No. Please God no.
I can be trusted to use a spreadsheet for my things that I don't share. Other people need to use something that will yell at them when they give it malformed gibberish.
Oh, and executable logic doesn't belong in the same context as data. That shit needs to be able to be told apart from the data.
Ech
in reply to MutantTailThing • • •rockerface🇺🇦
in reply to MutantTailThing • • •WanderingThoughts
in reply to MutantTailThing • • •Spreadsheets were needed for distribution of stored grain to start.
Taxes were used to make it easier to manage soldiers. It was easier to give them coin instead of managing food and stuff for an army.
If we'd stay away from agriculture, all this could've been prevented.
NickwithaC
in reply to The Picard Maneuver • • •"something feminine about"
You got a problem with that?
FreddiesLantern
in reply to The Picard Maneuver • • •like this
TVA y felixthecat like this.
BeigeAgenda
in reply to FreddiesLantern • • •like this
felixthecat likes this.
4am
in reply to BeigeAgenda • • •Glistening with sweat, displaying their power with every movement - the biceps, the pectorals, the glutes. Appearing through the dust they worked up while performing their task, unphased by the swirl of nature around them, unbound by the chaotic entropy of the multidimensional Coriolis vortex that they themselves stand at the point of, defiant, inevitable. Adorned with bronze, forged from the same Earth they demand fealty of.
What's not to love?
like this
felixthecat likes this.
halfapage
in reply to 4am • • •like this
felixthecat likes this.
tquid
in reply to 4am • • •Little rills of sweat making temporary clean streaks in the dust, tracing down across the belt of Adonis, pointing to what is hidden but implied... Sorry, where was I? Plowing. Right, plowing, like manly, definitely straight guys.
Plowing.
fartographer
in reply to BeigeAgenda • • •Yes... The "fields"...
Certainly not each other while begging the manosphere guy to explain how this is the most alpha straightest thing ever.
And then they wake up and realize that they're still in jail. Worse than that, they realize that they still have a Tate for a brother.
captainlezbian
in reply to fartographer • • •CancerMancer
in reply to BeigeAgenda • • •BeigeAgenda
in reply to CancerMancer • • •reksas
in reply to FreddiesLantern • • •like this
felixthecat likes this.
fartographer
in reply to reksas • • •Bongles
in reply to fartographer • • •Hmmm.. I guess that's one of those "patriarchy" types of language most people don't think about?
We really only use Manly, because we're big strong MEN, and girly, because that's for those weak little girls?
Womanly I guess technically exists but uh, not really used in the same way.
khánh
in reply to fartographer • • •Tja
in reply to khánh • • •buddascrayon
in reply to The Picard Maneuver • • •I'm having a hard time understanding this. Is feminity considered a bad thing? Is the use of spreadsheets being looked down on here? Is the trade of grain in ancient Samaria look being looked down on?
What exactly was the point of this post?
like this
TVA likes this.
adhocfungus
in reply to buddascrayon • • •like this
TVA likes this.
ayyy
in reply to adhocfungus • • •like this
TVA likes this.
MonkderVierte
in reply to buddascrayon • • •schmorp
in reply to The Picard Maneuver • • •buddascrayon
in reply to schmorp • • •Tattorack
in reply to The Picard Maneuver • • •like this
TVA likes this.
chuckleslord
in reply to Tattorack • • •On Roshar, sure. Men are allowed war, farming, and uncovered hands. Women do the thinking, art, and have to cover their left hands.
In the real world, though, no idea what this person is talking about.
like this
TVA likes this.
captainlezbian
in reply to chuckleslord • • •CancerMancer
in reply to Tattorack • • •BeerStainedBunny
in reply to The Picard Maneuver • • •cockmushroom
in reply to BeerStainedBunny • • •like this
TVA likes this.
BladeFederation
in reply to BeerStainedBunny • • •like this
TVA likes this.
MonkderVierte
in reply to BeerStainedBunny • • •Jankatarch
in reply to The Picard Maneuver • • •like this
TVA likes this.
ThePyroPython
in reply to Jankatarch • • •like this
TVA likes this.
Don't forget to stay hydrated.🍉🍉🍉🍉🍉
in reply to ThePyroPython • • •MIDItheKID
in reply to The Picard Maneuver • • •like this
TVA likes this.
Jumi
in reply to MIDItheKID • • •ChickenLadyLovesLife
in reply to The Picard Maneuver • • •schmorp
in reply to ChickenLadyLovesLife • • •When your pee hits the loo
next your willy is goo
that's a moray
Sorry, couldn't help myself. I'll see myself out
MidsizedSedan
in reply to ChickenLadyLovesLife • • •::: spoiler Gator
Am ashamed I only know that and the Aim for the Bushes lines, but great movie
:::
daniskarma
in reply to The Picard Maneuver • • •