This site under reconstruction.
This week was one of those weeks were nothing worked. I couldn’t make anything work. Just before leaving for the conference, I was working on a project and I had managed to reach a good stopping point where I figured that when I came back I could get right to it and finish up the…
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…