More Automation

More Automation

I’ve been working on a set of new projects – some of it pertains to gathering data and performing analysis and some of it requires a bit of automation. The analytical piece is not done and probably will be ongoing. The analysis is only at the beginning stage so there is not much to relay…

Techniques #2

New Techniques – Post #2

In the last post, I mentioned that there was a problem with the random technique that I was doing. There are two problems: I figured out one problem – more or less – but haven’t figured out the second problem. The first problem is the fact that every time you enter something, the spreadsheet will…

New Ideas

New Ideas This Week

Earlier this week, my boss and I were reviewing on the status of our automation project. We were really pleased at how everybody was coming along on the report, even figuring out what to do when errors popped up. It’s such a good feeling to see it come along so well. There were just a…

Playing with Access

Playing with Access

I’m working on a new project that entails a lot of data which unfortunately Excel does not handle well – not on top of all of the formulas I need to use to generate categories and analyses, plus the pivot tables. Eventually, I scrunched the data down to just what my boss needed but then…