This site under reconstruction.
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…
I read the other day a self-published article from LinkedIn/Pulse about spreadsheet error. The author talks about the different sources of error and how they can greatly impact your financials, mostly in an adverse manner. One, there is the common manual input or copy/paste error. He faults many organizations for not automating their spreadsheets, thus opening…
This past week we saw lots of improvement. So the implication of the past week is you have to give it time for people to learn how to use new things, especially technology. We spend 12 years in schools plus 4 more years in college before we are deemed qualified to work. So why do…
You must be logged in to post a comment.