14

So I have two coworkers who I want to help out with a problem. They have to collaborate on upgrades in a old factory, and they both use the same excel spreadsheet to keep track of the to-do list.

However. This will routinely cause one of them to lose all their work for the day when the other person forgets to close the spreadsheet after doing something.

They are great people. But computers are not their strength. So just reminding them to never start working before checking if the other person is done will not really work. And I always gets asked to help out since I know the basics of excel at least.

So is there anything that can be used for project management, and that has real time collaboration. And can be learned to two people who dislike computers in general.

top 10 comments
sorted by: hot top controversial new old
[-] Baizey@feddit.dk 13 points 1 year ago

Maybe google sheets? Or if there is an excel online equivalent

That would at least mean their work is synced so it doesn't matter if they forget to log out or edit at the same time

[-] SanitationStation@kbin.social 5 points 1 year ago

There does indeed seem to be a excel equivalent. I forgot to check that before posting the question. I will check with IT if we have excel online available. Thanks.

[-] variants@possumpat.io 3 points 1 year ago

Current 365 Excel let's multiple people edit and auto save

[-] abhibeckert@beehaw.org 5 points 1 year ago* (last edited 1 year ago)

Yes there's software for this, but I think you can keep it simpler than that.

Just tell them to create a new spreadsheet every day (possibly by creating a copy of yesterday's spreadsheet). Obviously name the files by date. With a new directory for each month.

Also, it sounds like they don't have good backups. Help them with that.

[-] Chimaeratorian@beehaw.org 5 points 1 year ago

Office365 Excel documents offer realtime cloud syncing, but at a minimum I believe autosave is a standard feature in Excel now as well. Enabling one or both should rectify pretty quickly and seems like the lowest-tech solution for them.

[-] SanitationStation@kbin.social 2 points 1 year ago

Great. That might be the best option since they are already somewhat familiar with excel. Thanks for the suggestion.

[-] abhibeckert@beehaw.org 1 points 1 year ago

I wouldn't recommend it. If checking if someone else has finished work first is too much to ask, dealing with passwords/two factor auth/etc isn't gonna go down well.

[-] SanitationStation@kbin.social 1 points 1 year ago

I'm going to have to talk to IT to see if there is a foolproof way of doing it.

This has to be some of the most common issues with modern workplaces. Getting the old school people to get used to the modern tools. They're both great people. But they would rather work with purely mechanical stuff instead of computers, sadly for them, factories these days require both.

[-] giloronfoo@beehaw.org 4 points 1 year ago

Is it on a network share? Excel has sharing support built in. When turning on sharing, there is an option to auto save and reload at a specific interval. It will also keep a history of changes for a configurable number of days.

https://cryptpad.fr/

Will be the open source alternative.

this post was submitted on 18 Oct 2023
14 points (100.0% liked)

Technology

37708 readers
373 users here now

A nice place to discuss rumors, happenings, innovations, and challenges in the technology sphere. We also welcome discussions on the intersections of technology and society. If it’s technological news or discussion of technology, it probably belongs here.

Remember the overriding ethos on Beehaw: Be(e) Nice. Each user you encounter here is a person, and should be treated with kindness (even if they’re wrong, or use a Linux distro you don’t like). Personal attacks will not be tolerated.

Subcommunities on Beehaw:


This community's icon was made by Aaron Schneider, under the CC-BY-NC-SA 4.0 license.

founded 2 years ago
MODERATORS