This site under reconstruction.
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…
There’s a tool in Excel called Watch Window (in Formulas ribbon) that I don’t use. For some reason, that particular tool has never gelled with me. Maybe I have to remember which cell goes with what value or I have to name the cells. Whatever the reason may be, I have never really gravitated toward that tool. But…
Everybody talks about big data and analytics, (my understanding is that they are related but not the same thing) but we have probably been doing some form of analytics all along. Analytics is just a snazzy term for analysis which has always been around since man has a brain. Big data is a term that…
This week I’m testing the budgeting file since we made some changes to it. There is definitely some level of discipline and method to it. At SAIC, the type of files I created were rather simple and did not require multiple entry points, so testing the files were easier to crosscheck. You basically tested the…
You must be logged in to post a comment.