I'm working on an audit that will randomly select pieces of equipment and have engineers verify the electronic reading vs the local reading.
I've put together a sample table in the tab "Source List" that will randomly choose which pieces of equipment have to be examined, as well as the points to verify. Like cooling units have to have Supply and Return air temperatures, as well as underfloor pressure. While power panels are phase voltage/current, and power.
My struggle is in the "Report Page." Experience has shown that I have to let the randomization go on in the background, with the engineers just getting a list of what to fill out or verify. I'd like the Report Page to find every piece of equipment which fits the randomizer criteria (currently it's just a 10% chance), but not have empty gaps in it. At that point, they can print out the sheet which just has a list of what to examine, and start their inspections. There's a potential list of like 5000 pieces of equipment, so it's not feasible to have this print out with 4900 blank lines on it.
I should honestly probably be doing this with a macro, but they're currently beyond my skill level.
Bookmarks