This site under reconstruction.
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 locking fix - lock selected cells and then password protect the report.
It will be interesting to see if a few folks now come to me with errors and say they don't know how to fix them.
Can you use ChatGPT to do your Excel work? Well, ChatGPT can’t actually go out and open up Excel itself and build whatever spreadsheet you want it to build. You still have to do the work. BUT, it can show you how to set up formulas, especially for simple situations. The problem is most of…
I spent some time working on how to use data tables with some question at work and I now know why I never used them before: the type of work I did before (and now) just don’t lend themselves well to the formulation of data tables. Also, the people I’m working with don’t necessarily ask…
My usual macro that I use to collect Excel files into a summary report failed me on Monday. But someone else could use the macro which told me that the problem was with my machine, not the macro.This post will be short since it is late but I do want to point out some steps…
I’ve noticed that states have stopped reporting coronavirus status every single day, including the weekends, especially in the South. I get it…we’re getting tired of keeping track of how we’re doing (or how we’re not faring). Florida, though, is a state that is on another level so that now my graphs are starting to be…
When you develop programs, you have to test, test, test. After this past month, I see at least 2 areas where you have to do some serious testing: 1) Test different sites/units/businesses that will be using your program. Each site or unit may have different ways of entering data or have different terminology. Even the…
I once had to do a program presentation using a file that had columns of numbers going out to column AY or something like that – see image below. Somebody didn’t show up due to an emergency, so I had to fill in, even though I had just arrived at the company and knew nothing…
You must be logged in to post a comment.