This site under reconstruction.
I ran across a new variation on hidden characters. In the past, I have written about invisible characters such as an “insert line” in this post. I wrote about how to use the function “code” to get at the hidden character and how to use function “char” to create that hidden character. I also may have…
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…
You must be logged in to post a comment.