This isn’t perfect, but it should be within range of the request.
Brackets for Pool Auto Jo17.ods (61.4 KB)
Hi J
A quick thought and is probably yr plan anyway?.
Is yr ‘Sheet Name’ list on Program sheet a method of loading any sheet required for a nights game rather than having, my initial way, of 10 or so sheets displayed in sheet list at bottom (Go_8, Go_9, Go_10) and picking the one required. So create a G0_9 sheet (covers 9_Singles & 9_Pairs) save it and it loads on choosing it in ‘Sheet Name’ List.
Is that the way you see it?.
Garry
On a better look the ‘Sheet Name’ list on Program sheet is just a reference as clicking on them does nothing.
Hi Josh
You did say your last send was a working version?.
I’ve set up the 15 Team sheet as I want it (moving brackets into place) but nothing is working.
- It appears there’s no random number allocation
- No populating of brackets, they are all blank
- no1 player must have the bye but no 3 is in second tier bracket, do I just swap 1 & 3 with 1st tier top bracket? (can’t check as no names there)
- Which PlayerList sheet are we working with _PlayerList or PlayerLists. The latter has the namelist so what’s _PlayerList there for?.
Are you in the military with all your NATO names in list?.
Garry
Can you post your version?
You don’t have 15Team selected for the player list on the player list page. Just go to PlayerLists and use the drop list to select 15Team.
Hi J
I did originally have 15 selected on PlayerLists but that made no difference so I thought I’d make a 9 player sheet, that’s why the 9 was there.
Have you made it work?
I put 15 back there and 15 back on 15Team sheet but nothing changes. Brackets are still blank.
What am I supposed to do here?.
G
I took your file, went to the PlayerLists sheet, selected 15Team, and everything worked as expected. I’m happy to help, but I don’t know what else to say.
Ok I didn’t have 15Team in there and now they’re all populated. I like it how the only populated sheet is the sheet listed there, that’s cool!!.
So are the players all given a random number?, can I see what number is allocated to each player so I can see the bye is operating correctly. As I see it the numbers relate to the List numbering and are not randomly generated. They need to be. Do we need SetNames box back?.
The 1st life numbers for players are coming up differently ie Foxtrot is 6 in 1st life (as per list and NOT random) but then pops up as 3 and has the bye in 2nd life. How is that happening? It would suggest different numbering systems for each life?.
Are you using the SeatLookup sheet as a positioning tool for the brackets. If yes, No1 always has 1st bye in 1st life and no3 in 2nd life, I don’t see that happening there?. Can u demonstrate how SeatLookup works from your point of view please
With adding new sheets I name them 9Team and 10Team but the SheetName on Program sheet has it as Sheet9 and sheet10 (System Names) and can’t be renamed there. This could be confusing to a user. I now see on reload that the names are correst in Program!, it just doesn’t happen instantly.
How should I go adding a new 9 player sheet;
- Do I duplicate 15Team sheet and delete Brackets until correct setup achieved and Rename sheet to 9Team (as I did in upload)
- Or copy brackets and paste into new sheet. This method has no formatting and requires a lot of work
- Are there other methods
In PlayerLists sheet adding a name more than the number of players in ‘Entries Listed’ used to go RED but it doesn’t now, you can have 15 there and it’s green
Garry
Brackets for Pool Auto Jo17.ods (69.9 KB)
- Yes, the PlayerLists sheet will add a player list for each sheet you add using the Duplicate Sheet menu item on a bracket sheet. Remember, if you copy a sheet by hand (using Calc’s right-click-tab) then you won’t get a new matching player list, and you won’t get arrows. Also, if you change a name on a Calc tab, you’ll have to Refresh (see below) and reselect the new name on the appropriate player list.
- Random or not is seen to the left of a player in a player list–or the numbers there scrambled. If you request Load Random from the bracket sheet menu, these numbers will be random. If you request Load Ordered, they will be ordered, 1,2,3,… The “SetNames” control button did exactly what the Load Random menu item does now. Zero difference there.
- The number you see for a player on the bracket page is the ‘seat,’ not the player number. The seat will always just count down 1,2,3,… from top to bottom. The seat is converted to the player number by the _SeatLookup sheet, as you have noticed. Then the player number is referenced in the player list, random or not. Don’t think of the player list as ‘in order’ from top to bottom. It’s order is the order of the aforementioned numbers left of the player names, in order only if you chose Load Ordered.
- As for “Number 1 always has the first bye…” you can edit the order of ‘seat’ however you please on the _SeatLookup sheet, but what are there reflect many cycles of your approval for the 8 player version, and your graphical representations as best as I understood them for other team counts. To check seating, using the Load Ordered and check that Alpha, Beta, Charlie, etc., load as you want per any byes. If they do, then they will load right (I should think) for Load Random.
- Yes, new sheets may be a little sluggish to show up. I think I even added ThisComponent.calculateAll to accelerate the process. But I think there is a menu item Refresh. Clicking (Ctrl+clicking) it should update everything, as should pressing Ctrl+Shift+F9…Data>Calculate>Hard in the Calc menu. Let me know if I forgot to put in Refresh. I might try redoing the SheetList using a helper column and a different way to get sheet names, but Refresh is your friend.
- Add ALL sheets by using the steps I’ve provided in previous posts. 1) Duplicate the 16Team sheet once you have built it 2) Delete unneeded matches 3) wire the references for win/loss using like =D5. Press Shift+F9 on the receiving cell of a wiring to get the arrow (which I might add to Refresh, anyway, if I haven’t already) then 4) number the seats down each side from 1 to n in order going down.
- Finally, I’ll check the red error flag on the player lists when I get a chance. Using conditional formatting for that task is convoluted at best. But if you have just a single player bracket selected for that player list, I wouldn’t be surprised if you can put any number of names under Mate 2, since it will have no effect on the bracket sheet, there is no code to flag such a condition as an error. The more critical thing is that you get an error dialog if counts are not right when you select the Load … menu item from a bracket sheet.
Hi Josh
Ok I’ve got the Load Randomly in the menu (sic)
But we still have this problem
On my 9Team sheet with Random done
The 1st life numbers for players are coming up differently in 2nd life, ie Foxtrot is No.6 in 1st life but then pops up as No.3 and has the bye in 2nd life. How is that happening? It would suggest different numbering systems for each life?. If Foxtrot is allocated No.6 then he should be be in L14 Bracket in 1st life and for the 2nd life BB11. That is not happening as I see it.
Can you check this one out please.
Garry
Sure, but you’ll need to edit your question above and add your file with 9Team.
Able is now in Foxtrots positions. Hotel is now No.1 in 1st life (has a bye) and No2 in 2nd life As No1 he should be in BB10.
Bravo is No3 in 1st life and should have the bye in 2nd life.
Hope that helps!
Brackets for Pool Auto Jo17.ods (72.8 KB)
I get the feeling you are glossing over the instructions a little too quickly. Look at
The numbers are not 1,2,3,4,… from top to bottom.
We are on 2 different tracks here.
It’s imperative the number/player positions match in both lives.
Hotel is 1 in 1st life (has bye) and 2 in 2nd. Wrong
Able is 6 in 1st and 3 in 2nd (has bye). Wrong
3 is Bravo in 1st and should have bye in 2nd. Wrong
It appears numbers are changing between lives or your ‘Seat’ system is altering things??. I did chang the 9 player Seats to suit as I see it. Maybe that is the problem as I may see the seat system differently to you
I see it as numbers are allocated randomly once and this determines the position/bracket they play in ie Able is 6 = L14 1st life and BB11 in 2nd (no6 there)
Its a conundrum😂
Garry
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