Thanks again Greg! Your assumptions are correct -- vertical/angled for Closed/Open, and angled/horizontal for Open/Grounded. This scheme gets even more complicated when I pull in the interlocks with the HV side... not sure if this is the best software for the application, but without having a budget to develop anything else, I figured I'd give it a go. Though I'm sure you can guess by now that my expertise in VBa does not extend to this depth of operation!
I'll attach another copy of the same sheet we've been discussing to show the overall layout including the HV system. The switches may be a bit difficult to see on the black lines, but there are essentially a 3-way on each side of each breaker in the ring bus, a 3-way from the ring bus to each feeder (3 transformers and 2 lines), and a 2-way high-speed ground switch just above those 3-ways to ground the high-side of the transformers or ends of line. That should make it about as clear as mud, but I think you'll get the picture :-)
I'm for whatever works best, using the least amount of coding. So if one button transitioning through the 3 states Closed - Open - Grounded - Open - Closed works best, then let's try that avenue. If integrating permissive logic is easier into separate buttons, then let's try that. I truly have no preference either way without understanding what's involved to develop each.
My wife and I just sold the farm, so to speak, so we're travelling nomads at the moment! We're originally from the South (SC to be exact) but have lived in Georgia and Southern California. We recently purchased an incredibly nice 5th wheel along with a new 1 ton truck to pull it with! So I'm a happy camper (pun intended) -- it's not as easy to keep the wife onboard with the notion, but she's being a really good sport so far (however, full disclosure: we've been hiding in the Caymans for work since 2 months after we got the rig LOL).
My in-laws used to visit Ballymena quite regularly -- my father-in-law retired from Michelin. The photos from their trips along with all the ancestry research my wife's found of our lineages there makes me want to visit badly. Eventually, we'll get there -- maybe for a project! That would be fun, and I'd definitely reach out to have a pint (or 2) with you, if you're up for it.
Thanks again for all your help! I've been wanting to learn more about this part of Excel for a while.
Best Regards,
Shannon
Bookmarks