70
you are viewing a single comment's thread
view the rest of the comments
[-] EmmaGoldman@hexbear.net 31 points 6 months ago

Clearly the actual problem is insufficient excel mastery.

[-] hglman@lemmy.ml 9 points 6 months ago

It's called building real tools that can export excel.

[-] invalidusernamelol@hexbear.net 6 points 6 months ago

Excel is fine for warehousing, but it's not super easy to navigate without tons of way too complex macros and you can't have multiple edit sessions on one file.

I'd just use like a Postgres instance with something like Metabase for active tracking of part status with some basic CRUD scripts set up to buttons on dashboards for each car section or something.

Maybe a Wekan or something for active tracking of part production and general activity stuff.

[-] EmmaGoldman@hexbear.net 21 points 6 months ago* (last edited 6 months ago)

I'm of the mind that if the thing you're doing is too large or complicated to use Excel, then it doesn't need doing.

Too many parts and systems in your car for excel to be navigable? Car needs fewer parts and systems.

Too many guys in your military to fit on an excel sheet? Your military needs to be smaller.

[-] NewAcctWhoDis@hexbear.net 21 points 6 months ago

Excel has a limit of 1,048,576 rows while the army has "1,073,200 total uniformed personnel" according to Wikipedia, time to start decimating.

[-] fanbois@hexbear.net 11 points 6 months ago

I'm sure you can just consolidate all the people called Mike into a single guy with the "Duplicate Entry" function.

[-] JohnBrownNote@hexbear.net 8 points 6 months ago

this is why there were centurions

[-] hglman@lemmy.ml 5 points 6 months ago
[-] EmmaGoldman@hexbear.net 21 points 6 months ago

Do you mean to tell me there's a way to post here other than using an excel script?

[-] nohaybanda@hexbear.net 4 points 6 months ago

Nvim is always an option

this post was submitted on 20 Mar 2024
70 points (100.0% liked)

chapotraphouse

13469 readers
735 users here now

Banned? DM Wmill to appeal.

No anti-nautilism posts. See: Eco-fascism Primer

Vaush posts go in the_dunk_tank

Dunk posts in general go in the_dunk_tank, not here

Don't post low-hanging fruit here after it gets removed from the_dunk_tank

founded 3 years ago
MODERATORS