Excel

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…

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…

This past week I’ve been working on macros to create a flat file since formulas create such a large file and slow it down. Last week I showed in 2 posts the formulas to create a flat file. Today, in a very short post, I will lay out some of the macro functions that I…

(This is terribly long and technical. While I tried to proofread this, parts of it may come off garbled. Writing technical stuff is actually difficult.) Earlier in the week I wrote a post that described some of the formulas that were created in order to convert a downloaded information into a flat file suitable for…

This posting will be more technical than usual as it will be showing a lot of formulas. Right now I’m helping my boss prepare the budget file in preparation for budgeting season. One of the things we want to do is improve a particular section of the file which was giving her headaches: I’ll call…