Have you tried comparing the names (thus the Alpha, Bravo, etc. for easy reference) to what you are expecting when you enter the numbers 1,2,3,4,… from top to bottom? How do the names come out, if you do that, compared to what you are wanting? That 1 is beside Hotel on the left but, say, 2 is beside Hotel on the right is not really the point…those numbers are not the seats, they are 1,2,3,4,… from top to bottom. The seats get looked up by the program. To see the player’s seat (before randomization), temporarily replace the =Entry where a player entry is with =PlayerListSeat. Then just press Ctrl+z to undo that once you’ve see the seat number. You can even check the whole page. Just press Ctrl+h for Lookup/Replace. Then adjust according to the following:
being careful about all the details, and press Replace All. Look at the seats as needed, then press Ctrl+z to get back the names. Those seats are what should match the seating you gave on the _ByeBrackets page. If they don’t, it’s a matter of quick adjustment on the _SeatLookup page. A real issue would be like getting a number repeating, an error, a blank space, etc. That would be more of a head-scratcher.
In other news:
- I noticed that the page duplication is leaving some junk behind in part of the system, which I have code to clean up, but it must not be activating. So, I’ll check that out when a get a chance (pretty soon I hope).
- Yes, the red flag on the player list was too much of a house of cards with conditional formatting. I’ll rework that some other way, because I like the feature, too. But again, it is just a feature that has no actual effect…it’s the dialog box warning about improper player counts that is the real thing that needs to work seamlessly, so let me know if it does/doesn’t show up contrary to expectations.