this post was submitted on 20 Mar 2024
62 points (100.0% liked)
chapotraphouse
13198 readers
375 users here now
Banned? DM Wmill to appeal.
No anti-nautilism posts. See: Eco-fascism Primer
Vaush posts go in the_dunk_tank
founded 3 years ago
MODERATORS
you are viewing a single comment's thread
view the rest of the comments
view the rest of the comments
Clearly the actual problem is insufficient excel mastery.
It's called building real tools that can export excel.
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.
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.
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.
I'm sure you can just consolidate all the people called Mike into a single guy with the "Duplicate Entry" function.
this is why there were centurions
Yet you comment here.
Do you mean to tell me there's a way to post here other than using an excel script?
Nvim is always an option