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.
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.
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.
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.
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.
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.
You are not logged in. However you can subscribe from another Fediverse account, for example Lemmy or Mastodon. To do this, paste the following into the search field of your instance: !technology@beehaw.org
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.
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.
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
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.
Current 365 Excel let’s multiple people edit and auto save
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.
Great. That might be the best option since they are already somewhat familiar with excel. Thanks for the suggestion.
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.
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.
https://cryptpad.fr/
Will be the open source alternative.