Getting straight to work
-
@krisleslie said in Getting straight to work:
So think of it like this, Google Drive auto-saves the work, solution provided and issue solved.
Auto-saving is part of the problem. She doesn't want auto-saving, she has that now.
-
Then it's a personal problem, not the individual working the systems. It's a shame public humiliation isn't an option haha joking guys.
-
@scottalanmiller said in Getting straight to work:
@krisleslie said in Getting straight to work:
So think of it like this, Google Drive auto-saves the work, solution provided and issue solved.
Auto-saving is part of the problem. She doesn't want auto-saving, she has that now.
Well - auto saving in Excel is not the same as live saving in Google Docs. With Excel - the auto save in this case is a crash recovery option that pops up asking the user - do you want to recover what you didn't purposefully save before the system shutdown? and there is now way to view the differences between what's saved on the disk, vs what's being recovered from the temp file before making the decision.
Yes - the answer to all of these problems is - shut everything down before you leave. PERIOD.
-
@krisleslie said in Getting straight to work:
Then it's a personal problem, not the individual working the systems. It's a shame public humiliation isn't an option haha joking guys.
I've worked places where it wasn't just an option, but a requirement. I'm dead serious.
-
@dashrender said in Getting straight to work:
@scottalanmiller said in Getting straight to work:
@krisleslie said in Getting straight to work:
So think of it like this, Google Drive auto-saves the work, solution provided and issue solved.
Auto-saving is part of the problem. She doesn't want auto-saving, she has that now.
Well - auto saving in Excel is not the same as live saving in Google Docs. With Excel - the auto save in this case is a crash recovery option that pops up asking the user - do you want to recover what you didn't purposefully save before the system shutdown? and there is now way to view the differences between what's saved on the disk, vs what's being recovered from the temp file before making the decision.
Would that difference make the difference? There are ways to get behaviour like that in Excel with Excel Online.
-
Well a better question is what is she doing in a spreadsheet that she shouldn't already be doing in a database? Makes little to no sense, she becomes a "SILO".
-
@krisleslie said in Getting straight to work:
Well a better question is what is she doing in a spreadsheet that she shouldn't already be doing in a database? Makes little to no sense, she becomes a "SILO".
Running reports is extremely time consuming in our EHR. Then once the report is run, it's saved to a CSV. Then she uses the CSV to get the data she wants - and saves them for future lookups. I'm pretty sure this is extremely common.
Now - can the DB be made to give the exact thing she wants? possibly, for $1000's for custom reports - and they will still take ages to run compared to just doing it herself with the CSV.
-
The problem isn't Excel - it's that she's not closing her stuff, then the system goes offline.
We are hashing a dead horse here obviously - If you don't have anything to say other than - She just needs to close everything - then please just don't bother responding.
I already know that! -
@dashrender said in Getting straight to work:
The problem isn't Excel - it's that she's not closing her stuff, then the system goes offline.
The PROBLEM isn't Excel, but that doesn't mean that Excel is the right solution. What about Excel via Remote App?
-
EHR = BIG
I'm glad I'm not in that boat again haha. I create the reports and it doesn't cost 1000.00. Thank God. SaaS web service I use is Quickbase.com. -
Git
-
@scottalanmiller said in Getting straight to work:
@dashrender said in Getting straight to work:
The problem isn't Excel - it's that she's not closing her stuff, then the system goes offline.
The PROBLEM isn't Excel, but that doesn't mean that Excel is the right solution. What about Excel via Remote App?
The problem is always Excel, or Access.
-
@scottalanmiller said in Getting straight to work:
@dashrender said in Getting straight to work:
The problem isn't Excel - it's that she's not closing her stuff, then the system goes offline.
The PROBLEM isn't Excel, but that doesn't mean that Excel is the right solution. What about Excel via Remote App?
The server will be needed to be reboot as well
But at least keeps the session open. -
@dashrender said in Getting straight to work:
@krisleslie said in Getting straight to work:
Well a better question is what is she doing in a spreadsheet that she shouldn't already be doing in a database? Makes little to no sense, she becomes a "SILO".
Now - can the DB be made to give the exact thing she wants? possibly, for $1000's for custom reports
This is why I FU%*&#^ EHR/EMR companies. Plus they cannot even get on board with Stage 2 and Stage 3 requirements. Don't get me started on the price of interfaces. Apologize for the off-topic comment but just had to get it off my chest.
-
@krisleslie said in Getting straight to work:
EHR = BIG
I'm glad I'm not in that boat again haha. I create the reports and it doesn't cost 1000.00. Thank God. SaaS web service I use is Quickbase.com.Totally depends on the EHR. All the big boys charge out the whazoo for pretty much everything if they even decide its worth their time to do it.
-
@dashrender So what task management software has she used? Evernote and Todoist are pretty darn good and have different styles.
