I dunno
I’m not trying to hit a flick shot on that vlookup
People that use vlookup over index/match are either geniuses or insane. Or both
Both. Both is good.
There’s something other than vlookup?
There’s XLOOKUP, which isn’t nearly as volatile as INDEX/MATCH. And also more versatile than vlookup.
Good God please use xlookup. We have some old school people that still use vlookup and refuse to convert their ranges to tables, it drives me crazy.
I still use index/match for multiple lookup returns (or is it sumifs I can’t remember?) But I do a lot of work in BI and it’s much more intuitive for me in DAX/M.
What? Why would you choose to use a combination of 2 formulas when there’s one designed to combine them?
Someone who points out excel has clearly never played Starcraft in any capacity. There is a caster, who has a shirt with an x-ray of a hand that’s bolted to some sort of frame, with “APM” written on top of it (actions per minute, a measure of how fast a player plays the game).
Mobas, RTS are hell on wrists. FPS too, with all the flicking. You can do excel in a shitty position for years and you’ll not end up with screws in your hand or nerve pinching.
Yeah I played RTS games, including both starcrafts, through my mid twenties (really hung on to the damn things) and was pretty good (got to diamond and stuck there in sc2, which is another animal entirely from pro tier. High school pitchers rarely need special shoulder surgery), and I never needed hand surgery or even serious carpal tunnel help.
Until I was in a position where I had to use office shit for ten hours a day. Then I needed physical therapy for about a year. I think with the games, theres time during matchmaking and loading where you just have to move, even in your seat. Its a whole thing.
Most people don’t need physical therapy after working in an office for a few years.
Wasnt exactly an office, and I was going at the excel about as hard as I did the StarCraft.
Let me air out two unrelated but similar things that annoyed the shit out of me back in the day.
Your parents then: “That floor mat thingy (referring to the Power Pad) doesn’t count as exercise because it’s still Nintendo. You need to go outside!!!”
Adults now: Middle school phys-ed classes consisting of playing Dance Dance Revolution apparently somehow now “counts” as real exercise.
And,
Your parents then: “The problem with you kids is you spend all day in front of that tube, watching those stupid movies and playing video games all day instead of reading books. It’s stunting your ability to differentiate fantasy from reality!!!”
Your parents now: Instantly believe every damn fool thing they see on Facebook, even and especially when it is clearly horseshit.
So yeah. I can totally believe that some moron would unironically believe that staring at a screen containing an office application is somehow automatically more “wholesome” than staring at a screen displaying any other content for the same amount of time.
To me it depends on how hard you work and game, and by that I just mean how you posture yourself over a keyboard and how actively/frantically you interface with a computer.
My posture is shit despite spending up to 14 hours a day in front of a computer. It’s still ways better than that of someone who hunches over their keyboard staring dead at their big ass monitor with their fingers locked in over the QE+WASD button group as they zone in to get that “flick” response time.
Meanwhile, my shitty posture is just lounging or reclining in my ergo chair as I swivel my neck to look at any of my three eye-level monitors. I shift around a lot and my hands aren’t near the keyboard unless I’m actively typing. I crack my neck and roll my shoulders often, sometimes stretch or go take a 15-minute walk. I only use dark themes and always have proper ambient lighting to prevent concentrated light exposure fucking up my eyesight.
I have been keeping this technophiliac routine going for about 5 years now. Depression, Severe General Anxiety/Paranoia, Alcoholism, Substance Abuse (weed), Over-eating, Serial Dating and unexplained bouts of mania were all problems I had to deal with during those five years. Some of them may have been amplified by this routine computer use but certainly not caused by it, I’ve identified the true causes for almost all of them and, aside from depression, they have nothing to do with sitting in front of screens all day.
There are much bigger issues associated with computer use and the media’s failure to report on them speaks volumes. Stop attacking the video games that aren’t predatory (keep going after the ones that are) and start really really taking a look at the effects of social media. Social media will destroy society long before video games get a chance to.
I stand by this statement, to the grave: Death to Social Media.
Lemmy IS social media. Right?
…Right?..
insert Padmeme
It depends… If you’ve got good posture (and I don’t mean sitting up straight, you have to shift around), a good chair, and you get up every hour or two to at least walk around? It’s still probably not healthy, but at least you don’t get too many aches and pains
On the other hand, it’s a lot harder with gaming. You’ve got your hands on the keyboard or clutching the controller constantly, you (or at least I) will tense up and put strength in my wrist at a weak angle, sometimes I’ll find myself leaning forward and tensing up
I feel it if I’m on a gaming kick, but day in and day out it’s usually not too bad. It helps that I need to walk to refocus anyways, so even gaming I usually take a lot of breaks
Both can be true
To be fair, lots of companies specifically point out ergonomics and give out onboarding materials with suggestions on exercises to do and office setup best practices.
Awareness is important, and most office jobs already raise awareness about it. I think the only time I’ve seen it in video games were those take a break reminders I’ve seen in some Nintendo games.
Bad posture and form will mess you up in either. If it hurts to sit in an ergo chair the way you’re meant to with your hands at the right position on the mouse and keyboard: you’ve already been doing it wrong for a while.
I will also argue that general workout will help a lot with pain. I used ti get sorre after some time and after getting a couple dumbells and working out the parts of my body that would hurt/get sore I rarelly ever have problems nowdays.
Are we all working the same job? Just spending 8 hours inputing data, filtering and moving columns in excel?
Sounds boring and easy to automate
no no, the learning curve on the business enviroement won’t cover the financial benefits ;) lol jk, of course it is but no one is going to say it
Just automate it yourself and “work” from home.
If I knew how, I would have a real job as a programer. at least I would create something
Million tutorials online or if you are lazy you could just post the contract on something like upwork. I answered a post like that and the guy tried to haggle with me. Automating his job and he wants a discount cause he claimed he could get someone in India for cheaper. Told him he should do that. Point is you could do it and as long as you are not him get quality code in short order.
You can learn how. VBA for Excel is pretty easy to learn on your own.
There’s probably a lot of material online for learning it, but that will most likely only scare anyone off from actually getting started, because it is too comprehensive.
I suggest you just start trying and then search for each problem at a time. You’ll soon learn how to make anything you need.
The first step is to get familar with macros. Enable the developer tab and record a macro. Start with something easy, like searching for a word and format it as bold or whatever. Then stop the recording. In the macros dialogue box you can set a keyboard shortcut so the macro will run everytime you press that key combination. Play around with it.
If you then open the visual basic editor or click edit on the macro, you can see what code was recorded.
You’ll soon realise that even if macros are powerful, they’re also very limited for larger tasks. There’s always something that doesn’t really work as intended when trying to use it on other cases. That’s when you need to start editing the code and this is when the online resources come in very handy. Simply search for “vba” and any function this causing issues and you’ll easily find solutions.
I’m not a programmer by trade but I learned some python and VBA to automate some of the things I do every day. Any time you’re doing some manual shit and think “there’s gotta be a better way” there probably is - just Google how to do that one thing and you’ll build up your knowledge over time.
It’s up to you to decide if you tell your boss or not. I chose to and took on some extra duties along with extra pay so it worked out for me but it’s a small business with a high value on productivity.
Love the huge programming capabilities built into Excel itself but for everything else it’s AutoHotKey FTW. I have a bunch of macros tied to the F keys along the top of the keyboard that can fill out any number of forms with a couple key presses.
I’m all seriousness everyone, take many breaks and there’s lots of wrist and hand stretches online.
Also, vertical mouse have helped my carpal tunnel. If you don’t know what that is, use the Magic Mouse for a little while and it’ll kick in.
Getting a split keyboard is the biggest ergonomic improvement I’ve made.
I’ve spent a small fortune on split keyboards now, it never came to mind for some reason. Definitely helped too.
I’m down with the sentiment of the comment, but I legit find I get way more arm/wrist pain from gaming than from spreadsheets. I think there’s much more prolonged button-pressing involved in the former. Some games are worse than others.
Right now my elbow is killing me from too much Project Zomboid over the last few weeks. A day of spreadsheets and QuickBooks today was almost a break from it (not that I didn’t go right back to PZ after work).
Elbow issues often means you’re using arm wrests.
If you are - don’t: it’s bad ergonomics. Chair without arm rests will help clear that up. Or drop your arm wrests to their lowest.
I have arm wrest just low enough to feel them when trying, but good enough to rest m6 hands when havimg a controller in my hands.
Just cause the article discusses one thing, doesn’t mean it discusses all things
I love spreadsheets (hey, we all have our weird interests) so at first thought this was an ASD meme.
How is liking spreadsheets connected to autistic spectrum disorder? (Im being genuine here)
B.3. Highly restricted, fixated interests that are abnormal in intensity or focus (e.g., strong attachment to or preoccupation with unusual objects, excessively circumscribed or perseverative interests).
Excel is a highly structured environment that follows strict rules and procedures to generate outcomes, often sorting and making sense of “messy” inputs. Prime candidate for an ASD hobby/obsession.
Good question. I have known many people on the spectrum in my life including several close family members and loving spreadsheets is not something I would attribute to any of them.
Loving spreadsheets isn’t something everyone with ASD loves, and I didn’t mean to imply that, just the hyper-fixated interest (8 hours) on a something which I personally happen to love.
Yes? But that’s already explicitly warned about.
At work I had to fill out a form which threats to my health could impact me. Next to chemicals or radiation, working at a desk for more than x hours a day was also listed as a potential source of bodily harm.
I do far less movement on a computer.
Look at it, think, type something, look at it, think, type something…
Just noticed it a long time ago. I have time to do it right vs making the time to do it twice.