Excuse me...you did WHAT?
Brace yourself for a long rant.
I work in collections, and one of the company presidents keeps a close eye on our A/R. So as a result, we have to keep a detailed Excel spreadsheet of our progress on accounts. Fine. It falls to me to update the spreadsheets once a week so the guy (along with 8 other managers and other interested parties) can read it.
It's a 2-part chore. First, I ask my 2 cohorts to close out for the week and get busy doing something else for a half hour or so. Then I "save as" for the following week, and take out any invoices that have been paid. We indicate paid invoices with a blue highlight. In some cases, if all the invoices are gone, I check ADP to see if there's anything unpaid that should be on the spreadsheet. The other two ladies can do that themselves, but I will sometimes do it as a courtesy if I'm not overwhelmed. Then I save the new sheet, put it back on the shared drive and e-mail them to let them know it's ready. The second half of the job is taking the "old" sheet and making sure the pages divide evenly, the borders are neat, and the figures on the bottom balance.
Each spreadsheet has 2 tabs, because each of us is in charge of 2 territories. However, we just started a new year and the aging for each year is separate. Meaning, we now have to have 4 tabs: 2 for 2007 and 2 for 2008. I wrote a detailed e-mail to the other two ladies, warning them that starting with the new spreadsheet for this coming week, there would be 2 new tabs, and that one year's aging would gradually diminish while the new year's aging would most likely increase over time.
I finished FG's sheet first and sent it over. She came to ask if she could change the colors on the new tabs and I said, sure, go for it. The different colors were just a way of making sure she could tell the '07s from the '08s without any trouble.
And then I finished MK's and send hers over with the same message: if you want to change the appearance of the tabs, feel free to redecorate.
But what did I get back? An e-mail from her, saying "Oh, 4 tabs are too much for me; I'll just rename them."
And she did!
She took out my 2008 tabs, intending to consolidate 2 years on the 2007 tabs!
She just took 'em slap out! And then blithely informed me after the fact.
I've dealt with a lot of weird ornery behavior, especially from FG -- she's famous for wanting to "mark just one more invoice paid" when I've already closed out the sheet for the week. It got so bad, I started taking the spreadsheets off the shared drive completely until I was done with them. Then she started bringing the invoices over to my desk while I was working, asking "Pretty please, put this one in?" I thought her antics were as bad as it could get, but MK's takes the prize.
I had to take the old spreadsheet, save it again and do all the deletions of the paid invoices -- again. This time I didn't put any new ones in. And, I rather pointedly sent out another e-mail, and cc'd the supervisor, about how "some people" persist in inserting non-numerical characters into a number cell, so that it throws off the SUM function. I know this has been addressed before, at least once.
Yes, she has the right to be clueless, we all do.
But why does she have to be clueless on a Tuesday afternoon when I'm TIRED???!!!
I work in collections, and one of the company presidents keeps a close eye on our A/R. So as a result, we have to keep a detailed Excel spreadsheet of our progress on accounts. Fine. It falls to me to update the spreadsheets once a week so the guy (along with 8 other managers and other interested parties) can read it.
It's a 2-part chore. First, I ask my 2 cohorts to close out for the week and get busy doing something else for a half hour or so. Then I "save as" for the following week, and take out any invoices that have been paid. We indicate paid invoices with a blue highlight. In some cases, if all the invoices are gone, I check ADP to see if there's anything unpaid that should be on the spreadsheet. The other two ladies can do that themselves, but I will sometimes do it as a courtesy if I'm not overwhelmed. Then I save the new sheet, put it back on the shared drive and e-mail them to let them know it's ready. The second half of the job is taking the "old" sheet and making sure the pages divide evenly, the borders are neat, and the figures on the bottom balance.
Each spreadsheet has 2 tabs, because each of us is in charge of 2 territories. However, we just started a new year and the aging for each year is separate. Meaning, we now have to have 4 tabs: 2 for 2007 and 2 for 2008. I wrote a detailed e-mail to the other two ladies, warning them that starting with the new spreadsheet for this coming week, there would be 2 new tabs, and that one year's aging would gradually diminish while the new year's aging would most likely increase over time.
I finished FG's sheet first and sent it over. She came to ask if she could change the colors on the new tabs and I said, sure, go for it. The different colors were just a way of making sure she could tell the '07s from the '08s without any trouble.
And then I finished MK's and send hers over with the same message: if you want to change the appearance of the tabs, feel free to redecorate.
But what did I get back? An e-mail from her, saying "Oh, 4 tabs are too much for me; I'll just rename them."
And she did!
She took out my 2008 tabs, intending to consolidate 2 years on the 2007 tabs!
She just took 'em slap out! And then blithely informed me after the fact.
I've dealt with a lot of weird ornery behavior, especially from FG -- she's famous for wanting to "mark just one more invoice paid" when I've already closed out the sheet for the week. It got so bad, I started taking the spreadsheets off the shared drive completely until I was done with them. Then she started bringing the invoices over to my desk while I was working, asking "Pretty please, put this one in?" I thought her antics were as bad as it could get, but MK's takes the prize.
I had to take the old spreadsheet, save it again and do all the deletions of the paid invoices -- again. This time I didn't put any new ones in. And, I rather pointedly sent out another e-mail, and cc'd the supervisor, about how "some people" persist in inserting non-numerical characters into a number cell, so that it throws off the SUM function. I know this has been addressed before, at least once.
Yes, she has the right to be clueless, we all do.
But why does she have to be clueless on a Tuesday afternoon when I'm TIRED???!!!