This site under reconstruction.
Late yesterday’s afternoon, I started to play around with my Excel file to develop a tool that will help me figure out my Sudoku puzzles faster and I succeeded! I actually designed something that will help me solve the easy puzzles. Please note the stress on the word easy. This file only works for easy puzzles. I’m…
This is a very short post but I did learn something new about pivot tables. I don’t know if this feature has always been present or just got implemented in Excel 2013, but it is a very, very nifty feature. And in the words of my boss, “It is big.” I learned that you can…
(Re-posting because I had trouble accessing the post. Original entry was around May 9th.) Two weeks ago, I created a cool, nifty spreadsheet to do most of the heavy lifting. Previously, I used to download 2 sets of data, one from the prior week and one for the current week, and try to look at…
I’m going to try something new here. A couple of weeks ago, someone was questioning my calculations of averages and it got me thinking: why use weighted average rather than average? I think most people understand the use of averages but I am not so sure they understand weighted averages. The concept of weighted average…
For my automation project, I think we are at the end stages where the focus will be on 1) how to reconcile imbalances and 2) sussing out any calculation errors we want to change. On the second item, this is going to be an outcome of situations that I hadn’t thought of due to being…
I’ve been fortunate enough that I can add some play into my work and still be accomplishing things. For instance, the early part of the week was discouraging as we got pressure to go manual in our reporting process. It was said that somebody in the field actually said, “Well, it worked the last week…
You must be logged in to post a comment.