This site under reconstruction.
This week I got a new interesting challenge. My HR VP needs to have an easier way of updating HR legal information that comes in about two times a year. She either receives or downloads the information, of which there are maybe about 12 separate pieced of information. I received 4 as examples. Since the company has…
Yea! I read a Wired article over the weekend about how some schools are teaching young kids how to evaluate information they find on the Internet. Along with that article, there were some other suggested readings I haven’t read yet such as how Macedonian teens used/mastered fake news, how fake news work and how it…
There were five solutions to add to my boss’ machine and the first set of macros for the first solution (automation of filtering proper GL accounts when a site is chosen) did not work. Oops.These macros weren’t just any ol’ macros – they were macros to go into the PERSONAL.xlsb file and they were event handler…
The invite to connect in LinkedIn read: “I read your fine post/synthesis ‘Skills you will need for the future’. Thank you for sharing your reflections. I’m a friend of Marty and I’ve followed Ito’s work for a long time.” Kenneth MikkelsenThis personal message led me to buying and reading his book. And I’m glad I…
In my last post I mentioned that I was testing a revamped spreadsheet and was having a difficult time of it because the testing required detailed testing of each cell. The revamp was extensive and the testing is massive (large number of cells and probably at least 15 tabs to go through). I’m not really…
The past week I’ve been reviewing a revamped budget file. The budget file is totally revamped which means extensive testing is required. I was able to design an automated checking of whether cells are appropriately locked (or unlocked) using the CELL(“protect”, ref) function. I also have a user defined function CellFormula (a macro) that shows…