Why does weekly spreadsheet suck for them? Are you interested in tracking time or the specific activities SE did with an account?
Any software replacement for spreadsheet for SE will be swapping time spent on filling spreadsheet to filling online form unless software pulls information automatically from what SE already doing in other repositories.
If spreadsheet has standard format, it may be of help to have a file upload tool that imports the data from uploaded spreadsheet to a database. And, if you have database expertise, you can manipulate the data in database whichever way you prefer for reporting purposes or have a few standard reports developed for you.
The spreadsheet has a standard format, but using it means that they need to sit down at their computer rather than being able to do it on their phone (i.e. right after a meeting), and that they overwrite a previous instance of the spreadsheet, which leads to mismatches between accounts and activities, which requires me to go back to them and reconcile things wasting time for both of us.
It's possible to use the spreadsheet as basis for upload, but if I'm going to do that, I'll build my own front end too. I'm hoping to find something that will work rather than roll my own.
Comments
Why does weekly spreadsheet suck for them? Are you interested in tracking time or the specific activities SE did with an account?
Any software replacement for spreadsheet for SE will be swapping time spent on filling spreadsheet to filling online form unless software pulls information automatically from what SE already doing in other repositories.
If spreadsheet has standard format, it may be of help to have a file upload tool that imports the data from uploaded spreadsheet to a database. And, if you have database expertise, you can manipulate the data in database whichever way you prefer for reporting purposes or have a few standard reports developed for you.
The spreadsheet has a standard format, but using it means that they need to sit down at their computer rather than being able to do it on their phone (i.e. right after a meeting), and that they overwrite a previous instance of the spreadsheet, which leads to mismatches between accounts and activities, which requires me to go back to them and reconcile things wasting time for both of us.
It's possible to use the spreadsheet as basis for upload, but if I'm going to do that, I'll build my own front end too. I'm hoping to find something that will work rather than roll my own.