![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png){kind=small}
Tuesday is Almost as Bad as Monday
Mar. 23rd, 2010 02:37 pmI never thought I'd be one of those people who spend all day hiding out in the bathroom at work.
Mar. 23rd, 2010
Shit-headedness
Mar. 23rd, 2010 07:09 pmExcel has the ability to have multiple pages in one report. You get little tabs at the bottom of the sheets. You can even label the tabs. Color-code them. You can also put numbers on one tab and refer to those numbers in formulas on another tab. You can also hyperlink other Office documents.
My boss at work is not familiar with Excel. It's understandable - she's a database manager, and not a numbers-cruncher. In fact, being as I'm in a justice system, most people there are not familiar w/Excel. They use it for keeping lists of stuff. I am overly-familiar with Excel. I can tell people how to use a spreadsheet over the phone, complete with pointing out menu items and functions.
When you save an Excel workbook, whatever tab you were on when you save it is the one on which it will open. I submit supply orders in Excel. In my supply order workbook is my actual order tab, which refers to figures on the inventory and price list tabs, and hyperlinks that will eventually point to saved pdf files of the orders. Another tab shows recent disbursals of toner & links to the webpages of printers that will need toner soon. Another tab is our current toner inventory. Another is just lists & locations of printers. Another tab has past orders. I intentionally save it on a page not directly showing the order I'm trying to get approved. I get called into the office & asked, "What is this?" "It's my toner order". "No, this has got other stuff on it. It looks like printers, and links to ... somethings". So I show the boss the tabs at the bottom, and encourage her to click on the hyperlinks.
Knowing my boss' proficiency in Excel, one would think I'd try to simplify things a bit.
Instead, I am encouraged to make it all so much more complicated.
No one says shit to me when they walk by my desk & see me working feverishly on some spreadsheet, with a million webpages & other documents and charts and things laid out on my desktop. In an hour or two, I e-mail my boss yet another demonic portal to Excel Hell.
Then I go out into the hallway or hide in the bathroom and laugh and laugh and laugh.
My boss at work is not familiar with Excel. It's understandable - she's a database manager, and not a numbers-cruncher. In fact, being as I'm in a justice system, most people there are not familiar w/Excel. They use it for keeping lists of stuff. I am overly-familiar with Excel. I can tell people how to use a spreadsheet over the phone, complete with pointing out menu items and functions.
When you save an Excel workbook, whatever tab you were on when you save it is the one on which it will open. I submit supply orders in Excel. In my supply order workbook is my actual order tab, which refers to figures on the inventory and price list tabs, and hyperlinks that will eventually point to saved pdf files of the orders. Another tab shows recent disbursals of toner & links to the webpages of printers that will need toner soon. Another tab is our current toner inventory. Another is just lists & locations of printers. Another tab has past orders. I intentionally save it on a page not directly showing the order I'm trying to get approved. I get called into the office & asked, "What is this?" "It's my toner order". "No, this has got other stuff on it. It looks like printers, and links to ... somethings". So I show the boss the tabs at the bottom, and encourage her to click on the hyperlinks.
Knowing my boss' proficiency in Excel, one would think I'd try to simplify things a bit.
Instead, I am encouraged to make it all so much more complicated.
No one says shit to me when they walk by my desk & see me working feverishly on some spreadsheet, with a million webpages & other documents and charts and things laid out on my desktop. In an hour or two, I e-mail my boss yet another demonic portal to Excel Hell.
Then I go out into the hallway or hide in the bathroom and laugh and laugh and laugh.
