Static Random numbers [headache with conundrum -> 2000 lines of Basic]

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.

Hi Josh
Well we certainly need to change the number system drastically.
If we refer back to my ByeBrackets sheet 9 Players 1st life = 1 has bye in 1st Life so is in L8 bracket (1=Hotel, correct) and 2&3 (Echo, Bravo, correct in F10&11) all others are correct. That’s exactly to specs in ByeBrackets.
But below the 1st life brackets on the ByeBrackets sheet is the 2nd life bracket setup and none are in the correct slot as depicted there.
Hotel is 1 so should be in BB11 and No6 (Able) should be in BB12.
Bravo (No3) has 2nd life Bye so should be in AV8.
So the 1st life is as depicted but the 2nd life is totally different to ByeBrackets . It’s got to match, otherwise is not acceptable.
As I stated earlier once the number is randomly set for each player that determines their position in the second life as per ByeBrackets.
If we go back to just using the numbers that are set in the 2nd life just as they are in the 1st life then that should work. For singles and pairs. We don;t need ‘Seat’ allocation throwing a spanner in the works.
Garry

Perhaps you might consider taking this discussion to a private mode?

1 Like

@robleyd: There is a private mode? How?

Perhaps: Just go to _SeatLookup tab. There you will see the lists for lookup. If you want to hand enter the seat on the bracket pages, just go down the table with 1,2,3,4,5,… in each column. For example, the two columns for 9 players start 1,2,9,… and 3,1,6,… Just make them 1,2,3,…,9 and 1,2,3,…,9. Then enter the exact player number you want beside each of the far-left or far-right matches on the bracket tab, where I’ve been having you enter 1,2,3,… from top to bottom. After that, it’s just up to you to enter the seat for any position, 1st or 2nd life, on any bracket page where you have edited the _SeatLookup table for that number of teams.

Caution: The last version of 9Team I have from you has random placement. That’s why Hotel is 1, not 8. So if you go about directly entering the player seat numbers based on a random player list, then once a new random sequence is generated, you may find everything scrambled again. My advice remains to used Load Ordered and set up the brackets using Alpha is 1, Bravo is 2, etc., then try out the randomization, which will scramble the names, but it will still correctly assign a name at the left (1st life) to the correct location at the right (2nd life), per however you have directly entered the seat numbers.

But also note: Look at the _ByeBracket for 9 teams for 2nd life:
image

It looks for the world like it wants 3,1,6,2,7,4,8,5,9 as the player seat from top to bottom. That’s exactly what the un-edited _SeatLookup table would provide if, for a matching real bracket page, the numbers entered going top to bottom would be 1,2,3,4,5,6,7,8,9.

Click on a user’s name to the left of a post.


Use the Message button.