this post was submitted on 27 Jan 2024
1225 points (96.9% liked)
Science Memes
11253 readers
3543 users here now
Welcome to c/science_memes @ Mander.xyz!
A place for majestic STEMLORD peacocking, as well as memes about the realities of working in a lab.
Rules
- Don't throw mud. Behave like an intellectual and remember the human.
- Keep it rooted (on topic).
- No spam.
- Infographics welcome, get schooled.
This is a science community. We use the Dawkins definition of meme.
Research Committee
Other Mander Communities
Science and Research
Biology and Life Sciences
- !abiogenesis@mander.xyz
- !animal-behavior@mander.xyz
- !anthropology@mander.xyz
- !arachnology@mander.xyz
- !balconygardening@slrpnk.net
- !biodiversity@mander.xyz
- !biology@mander.xyz
- !biophysics@mander.xyz
- !botany@mander.xyz
- !ecology@mander.xyz
- !entomology@mander.xyz
- !fermentation@mander.xyz
- !herpetology@mander.xyz
- !houseplants@mander.xyz
- !medicine@mander.xyz
- !microscopy@mander.xyz
- !mycology@mander.xyz
- !nudibranchs@mander.xyz
- !nutrition@mander.xyz
- !palaeoecology@mander.xyz
- !palaeontology@mander.xyz
- !photosynthesis@mander.xyz
- !plantid@mander.xyz
- !plants@mander.xyz
- !reptiles and amphibians@mander.xyz
Physical Sciences
- !astronomy@mander.xyz
- !chemistry@mander.xyz
- !earthscience@mander.xyz
- !geography@mander.xyz
- !geospatial@mander.xyz
- !nuclear@mander.xyz
- !physics@mander.xyz
- !quantum-computing@mander.xyz
- !spectroscopy@mander.xyz
Humanities and Social Sciences
Practical and Applied Sciences
- !exercise-and sports-science@mander.xyz
- !gardening@mander.xyz
- !self sufficiency@mander.xyz
- !soilscience@slrpnk.net
- !terrariums@mander.xyz
- !timelapse@mander.xyz
Memes
Miscellaneous
founded 2 years ago
MODERATORS
you are viewing a single comment's thread
view the rest of the comments
view the rest of the comments
There are numerous reports and databases we work with from other platforms, and for nearly all of them, I just end up feeding it to Excel so I can manage it the way I like. So many of those platforms just have absolute dog shit UIs or refuse to present data in a configurable way, or straight up hide certain things for no reason.
Part of my Monday morning routine is actually exporting a CSV for a couple things that can't be connected directly to excel, hitting Get Data, and letting my custom workbooks do their thing. Watching it all update and present itself in exactly the way I want to see it is so god damn satisfying.
there are definitely reasons to use excel but in my case there is a defined and expected workflow and using excel just makes it unnecessarily slow and error-prone. at this point, the worksheet breaks at least once every 3 months and i'm the one who gets to fix it because i read myself into the worksheet's script and the guy who originally created it doesn't work for us anymore.
the code is (thankfully) well enough commented that additional documentation is not necessary to understand it, so reading yourself into it is thankfully easy enough as long as you know VBA.