Science Memes

11081 readers

2609 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

[email protected]

Other Mander Communities

Science and Research

Biology and Life Sciences

Physical Sciences

Humanities and Social Sciences

Practical and Applied Sciences

Memes

Miscellaneous

founded 2 years ago

MODERATORS

[email protected]

1223

despite all my rage IT keeps me trapped like a rat in a cage. (mander.xyz)

submitted 9 months ago by [email protected] to c/[email protected]

211 comments fedilink hide all child comments

you are viewing a single comment's thread
view the rest of the comments

[–] [email protected] 234 points 9 months ago* (last edited 9 months ago) (21 children)

Excel is, almost certainly, the single most important and influential piece of software in almost every business.

Excel can do anything, including so many things it shouldn’t.

[–] [email protected] 108 points 9 months ago (15 children)

i heard you like a little database in your excel

[–] [email protected] 81 points 9 months ago (13 children)

we have an excel spreadsheet at my workplace that takes a solid 2 minutes to open and even longer to close and accesses a number of other spreadsheets with read/write access in the background. it's an absolute monster.

(it's essentially a database that keeps track of the calibration dates for our testing equipment)

[–] [email protected] 4 points 9 months ago (1 children)

Depending on what functions you have running to make it do all the things, could you have it live on Sharepoint and just access it through Excel online? That offloads a lot of the processing to MS’s servers but does have the disadvantage of being Excel Online, which has some but not all the functions of desktop Excel and the keyboard shortcuts may or may not work. Also, Excel Online doesn’t seem to love macros, which can break things.

[–] [email protected] 4 points 9 months ago (1 children)

the only reason that the spreadsheet exist is because of macros (pretty sure the table has over 10.000 lines of VBA, with more in the tables it accesses) but my bosses are thankfully investigating alternatives for a migration of the functions that that table provides.
I sadly am only a trainee at the company, so i don't get too much input beyond fixing whatever breaks with it every so often while it's still in use, but yeah.

[–] [email protected] 3 points 9 months ago (1 children)

“Only a trainee…”

Sounds like you’re the only one keeping that thing running. Don’t sell yourself short!

[–] [email protected] 3 points 9 months ago

my boss does appreciate what i'm doing but i just don't have a decision power that someone working in IT would have (i work in the physics/chemistry lab). thanks though, i appreciate the sentiment :)

load more comments (11 replies)

load more comments (12 replies)

load more comments (17 replies)