This site under reconstruction.
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…
I appear to be going through a stretch where whatever I do, I’m not happy with: either it looks or works awful or just doesn’t plain work or it just takes too long. Any idea I have just doesn’t come like the way I imagine it. Anyway I still have to push on. I’m currently…