Excel

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…

We had another go at it and I thought there was some improvements, but my boss didn’t think so. It wasn’t my program or the formulas, at least not at the moment; it was mainly their behaviors: * Some just didn’t do it; * Some didn’t read the email about the changes; * Some didn’t…

They had trouble opening up the download files. I re-did the macro after finding that they had problems copying and pasting, especially pasting to the yellow cell. There were some merged cells issues caused by the OneSite download. So I had spent about a week re-working the program and ending up writing a macro to…

Okay, it has started. The week before this week, we had training. On Monday of this week, we had our trial run. After the Monday meeting, my boss asked if it would be easier to do the report manually. She was already giving up? I told her that they just needed to try it out…

It’s been busy the last week and a half so I haven’t done much posting. Really, haven’t done much of anything but work. We did our training for the new report file and next Monday we start our trial run. The whole month of December will be testing, debugging, getting familiar, and finalizing process. Oh,…