Sunday, November 18, 2012

improved the ECR

Dealt with some ECR "issues."

It started with Paul saying he could not attach a scanned image of his signature. He correctly assumed this was due to cell protection. I shared that the cell protection could be easily disabled as there was no password. Then he asked me how. I didn't know the version of Excel he was using so I sent the instructions for version 2003 and 2007.

Meanwhile Scott told him not to send it electronically. Paul did anyway.

Then Scott asked me to fix the spreadsheet. At first I didn't know what he was talking about, partly given how the thread started. Turned out that when Paul scanned his completed, printed form, the blue font colour did not reproduce well. Scott request black. I switched from blue to grey.

During the revision, I thought I'd touch base with Phil to gauge his thoughts on the usability of the form. And got an ear-full. Not with my spreadsheet design work; with how he was treated the last time he submitted cheque requisition.

He also sent over the "instructions" document. I had never seen this. And it was jaw-dropping.

I can understand if treasury gets frustrated with missing or incomplete information, but there are tactful and encouraging ways to resolve these matters. I'm getting discouraged because I'm doing what I can and I still get yelled at.

No comments: