This site under reconstruction.
This week was another one of those discouraging week – I couldn’t really solve anything useful and everything takes me so long.I keep encountering the need to create a list of the most common phrases – not words, phrases – such as unit names or vendor names, etc. Every time I do a data download,…
At work, I’ve been working on sifting through data to see if there is anything we should be aware of or could use. I’ve encountered some new kinds of problems on arranging the data, so I’ve been Googling a lot lately. These Googles have led me to an interesting page at Exceljet that shows some unusual…
The last post discussed the high level mechanics of setting up formulas to check for hard coded numbers. I ended with a comment about doing this check for 64 files and mentioned that a macro would needed to be done to do this kind of check.Today, this post will show the macro. The last post…
Aaarrrggghhh!!! She overwrote the formulas with hard coded numbers and now the math is not working. She has left for a position that has better growth potential and I am happy for her. So I took back the automated reporting that she was handling. She was actually doing it very well, but I must remember…
Some people get ideas while taking a walk or while in the shower. I get ideas when I’m driving. After driving a while, I start to kind of daydream, going over in my head the events of the day or describing what I’m doing and why I’m doing it. The daydreams are typically little conversations…
We’re in budget season and I’m assisting my boss in training sessions with the site managers when an idea popped up. My boss was talking about a flaw in a formula that counted up employees. It was a COUNT formula that did not quite work due to the nature of the other formulas in the payroll tab….