This site under reconstruction.
(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…
Most of the time, when I do a download of data, the numbers all fall in nice orderly columns, and if I have to do multiple downloads, the data consistently fall into the same columns, from download to download. However, when I do a download from a software called OneSite, the numbers can shift from download…
Ahhh, I’m working with another one of those downloads where the data do not lie in nice columns. I want to be able to compare data between two different downloads to make sure that the data is migrated correctly from one software to another. I would like to make Excel do most of the comparison…
This picture is actually a zoomed out snapshot of an Excel file that shows our tracking of the rollout of software to the various sites. We have so many tasks to be applied to each site and there are only 4 or 5 of us that using Basecamp wasn’t working for us. It just ended…
Generally, you should use software tools that have been well tested and provide robust results, but there are times when you just need to do your own thing. Maybe the software doesn’t give you the information you need and you need to dig into the details deeper. Or you need to do some ad hoc…
You must be logged in to post a comment.