I quit apologizing for lack of posts a long time ago. But this comment
Appreciate this site.
Having probs w/ my computer.
Is Ddoe not D, or is it still me?
got me thinking that I should at least update you on what’s been happening.
First, I had a problem with a plugin called SuperCache (or something like that) and if you included www in the URL, you got one page, omitting it you got another. That plugin is gone now and we should all be seeing the same thing. Supposedly the site is slower without that cache, but obviously slow and accurate is better than the alternative. I don’t know if that comment was related to the caching issue or the general lack of posts. Either way, it prompted this post. And, by the way, thanks to my fellow contributors for continuing to post.
If you’re a regular reader, you are aware of the great data loss of 2011. Sadly, not all archived posts are back up. I thought they were, but as I pull away more layers, I see more layers. I think, finally, I have a handle on the scope of the problem. I believe it’s about 200 posts that are still missing. I have yet to find a nice, automated way to recover those posts and I’ve been too busy/lazy to do it manually. It’s an albatross around my neck. Maybe I should hire someone to do it manually.
OK, on to the good stuff. About eleven weeks ago I gave my notice. I was working for a small manufacturing company in the aerospace and defense market. I gave them four weeks notice, because I’m such a great guy, and they really appreciated the opportunity to have a smooth transition. And smooth it was. I really busted my ass those four weeks between doing my regular job, documenting my regular job, and teaching other people how to do my regular job. It was like three jobs in one. By I worked with some truly terrific people and they couldn’t have made my departure more comfortable and enjoyable.
Then I took two weeks off. Time off in between jobs is the best time off there is. There’s nothing nagging you from the old job. You don’t show up to an overflowing mailbox when you come back. It’s the best. Not every employer is willing to wait six weeks for you to start. Nuts to them, I say. If my success or failure is so tenuous that a few weeks will be a factor, I think we’re better off without each other. I didn’t do much in those two weeks, save a trip to Dallas to play some Winter golf.
Five short weeks ago I started at my new position: Divisional Controller at a mid-size company in the petroleum industry. It’s been challenging and fun so far. It has fueled some posting fodder for me – new industry, new data, new people making new mistakes. Now that things aren’t so hectic, I can start putting out some posts.
In the midst of all that hullabaloo, Mike Alexander and I wrote a book called Access 2013 Bible. I haven’t had great success in the book authoring area in the past. Publishers set unreasonably tight schedules and I have a day job. This one wasn’t too bad, though. Having deadlines in the Winter helps as I have fewer commitments that time of year. And the deadlines were at times that just worked well in my schedule. Overall, it was a good experience and I’m glad Mike talked me into it.
I’m using Excel 2010 at work and home. Previously I was using 2003 at work. I do a lot of work on Excel at home, so I’m no stranger to 2010. But most of what I do at home is VBA. Now that I’m using the UI more extensively, it has been somewhat of a transition. I’m retraining myself to use the Ribbon shortcuts instead of the old 2003 ones. Most notably Alt+d+p+n+n+f is replaced by Alt+n+v+t+enter (do you know what that does without looking?). I don’t have to give up on the 2003 shortcuts, but now that I don’t use it anymore, I may as well.
Another transition is the amount of data I’m dealing with. At a small company, I could download every transaction for the entire year into one workbook. Not so much anymore. For the first time in my life, I am reading Charles Williams’ website with more than just a passing curiosity. I’ve never had to be “efficient” with my formulas before. Now I see how half a million SUMPRODUCT formulas feels and it’s not good.
You might think with larger data sets that you’ll be seeing more PowerPivot posts from me. Nope. I’m not investing time into an add-in that may not be in my next version. I work at a company where I am not the IT department (that’s a new situation for me) and I don’t control what versions we buy. Maybe I could have some influence on IT and get what I need. Or maybe Microsoft can kiss off and I’ll use my IT chips elsewhere. I get it. They want to segment their customers and make more money. I have no problem with that. I’m just not biting.
Currently, the only way I can get data out of our accounting system is by printing a fixed-width report and importing into Excel. Expect to see some posts on that topic in the near future.
Finally, you can expect to hear me complaining about how IT is thwarting my productivity. I can’t even install Jimmy’s Amazon link generator because I don’t have admin rights. It’s just desserts though. I’ve been making a modest side-job living creating VBA solutions that end-around IT departments for over a decade.