This site under reconstruction.
Suddenly, a macro that had previously been working stopped working. It was a special macro program that I had created for someone and I was going to re-use it for another person’s request. It was the same exact set of macro codes and yet it would not work. The program would freeze. I couldn’t see…
Lately, I’ve been trying to figure out how text analysis work. Last year, when I was looking at some comments, I created a dictionary of similar phrases so I could see trends in comments – what kind of comments are mentioned most frequently. In the business I’m in, certain phrases come up frequently so one…
Wouldn’t it be neat if we could do something different with Excel? Make it more visually interesting? I’m attaching a copy of an Excel file with some way out experiments with pictures, colors, graphs, data, etc. to see what I can push. The examples are nonsense and meaningless because I am not intending the materials…
Our vendor did it again: the data format changed – basically, the columns shifted – so that my formulas did not pull in the right numbers or any numbers at all. None of the 60+ files worked. Fortunately I quickly spotted the issue (and some of the managers are getting comfortable with numbers and excel…
Doesn’t it feel good when you come up with an ingenious solution to a problem? A couple of posts ago I mentioned that our data source changed which led to my macro breaking. I’ve been working on some fixes and thought I was very close to finishing when I found out some major changes were…
Revising a code is way different from creating a code from scratch. My company switched over to a new payroll vendor and the new vendor’s data file is almost – but not quite – the same as the old data layout, but it is that tiny little variance that broke the code. Most of the…