This site under reconstruction.
Let the games begin! It’s time to do the ACA Reporting. Last year, when we were at the stage of developing the paper report, reviewing the data was so onerous that the HR VP said that we were going to do it differently the next year (meaning 2017). So I kind of took it to…
The week before I wrote a post about somebody fudging the numbers instead of fixing the errors. I saw at least 3 instances of fudging but there is no telling how many people have figured out how to manipulate the numbers. So last by the end of last week, I rolled out a password and…
Today we found somebody fudging the numbers.Normally it’s hard to catch on to tricks but today my boss wanted to look at some trends for 2016 and she saw some stuff that looked weird. She asked me to investigate. She was wondering why a certain metric kept coming up as the same number for a…
Creating macros to move or copy files from one folder to another should be easy but it turned out to be problematic.I’m working on a new project called the Paperless Office project (I named it that). I’ve been doing a lot of research and some of that research is trying to see if I could…
Sometimes, people just want to do things manually.There is a weekly report that I created almost 2 years ago that pulled in data via macro. It basically does the job for you in 5 minutes and all you have to do is review the numbers. Now. sometimes you have to fix some errors but those errors are…
This post will be short because I spent the weekend on developing some artwork (and one failed) and it is now getting late. I do want to post a macro that I found in Stack Overview (I thought I copied the link) and fixed to work on my PC, altering it a little to fix…