This site under reconstruction.
For my automation project, I think we are at the end stages where the focus will be on 1) how to reconcile imbalances and 2) sussing out any calculation errors we want to change. On the second item, this is going to be an outcome of situations that I hadn’t thought of due to being…
I’ve been fortunate enough that I can add some play into my work and still be accomplishing things. For instance, the early part of the week was discouraging as we got pressure to go manual in our reporting process. It was said that somebody in the field actually said, “Well, it worked the last week…
And they are not lizards. Okay, I got a little surprise earlier in the week. I was giving the supervisors training on the automated report and one supervisor said one of her folks asked about doing the report manually. That person felt she loses the knowledge if the computer was doing it all for her….
Last week I found out that somebody was backfilling for two other people and therefore, was running three reports. If I hadn’t automated the report, she wouldn’t have been able to do that. It’s pretty exciting to be able to cut down the time drastically, but it is also scary. Fewer people will be required…
I’m back on that project where we are asset manager of a bunch of failing properties that were under bankruptcy. I think we were brought in as part of the deal between one of the investors and the owner of the properties. The first go round, which was back in November, was to review some…
After all of these years, I learned a new trick that you can use with the SUBTOTAL function. I’ve been using SUBTOTAL as a form of SUM, but you can also use it for counting or averaging as well as other statistical type actions. SUBTOTAL(9, “range”) gives you the sum whereas SUBTOTAL(1, “range”) gives you…
You must be logged in to post a comment.