Excel

Earlier this past week, I was trying to write up a macro program to delete a specific picture that had been copied over from a download. With the intent of keeping the process simple for the users of this file,  part of the process involved copying the entire download, including a picture of a graph. This is fine…

This past week I have been working on this new analytical project and I tried some new stuff. Mostly it was new programming; I’m trying to get to the point where I can just whip up a program to do what I need, but I’m not there yet. It still takes me a couple of…

Now, I’m guilty of making extremely large files that can run pretty slowly because I will work with large datasets. I will download everything in the universe, if I can. I also work on how to present information in a useful, clear and pretty fashion. Making things pretty can create large files. Here are a…

When you develop programs, you have to test, test, test. After this past month, I see at least 2 areas where you have to do some serious testing: 1) Test different sites/units/businesses that will be using your program. Each site or unit may have different ways of entering data or have different terminology. Even the…

“One, two, three, four, five, …, eleven, twelve. Twelve characters.” “So why does Excel len() function gives me 13?” “Maybe there’s a blank character at the front. Let’s try =left(cell, 1)…Hmmm, R.” “Maybe it’s at the end. Try =right(cell, 1)…An e, nope.” Normally, if you are working with a download from SAP, you will be dealing…