This site under reconstruction.
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…
You know how programming logic can get gnarly? That happens when you need to make adjustments or additions to the program. Or you have a decision tree that is based upon time. I’ currently trying to write a program to save “beginning of the month” data to use for comparison purposes throughout the month without blowing…
Lately, I have been working on this report/dashboard for 2 audiences: the operations manager and the field guys. In developing this tool, I’ve had to incorporate my own tricks. One, I just recently learned how to make Excel automatically start running a macro when you open up the file. To write the macro, it requires…
Which picture jumps out at you with clear definitions of what is in the picture: 1) the one on the left where I applied every little tricks that the iColorama and Haiku HD apps offer you or 2) the one on the right? If you say the one on the left, this post is not for…
You must be logged in to post a comment.