Thanks Josh
Impressive!!!.
Do I understand this as I can set the bracket sheets automatically?. Will it generate a 9 bracket sheet for instance?. I don’t see what the ‘Hyperlinks’ are actually doing maybe it generated the 15 Team_1190 sheet once only, not sure. Don’t get the Early, Late, Full menu choices as nothing changes.
Adding names to playerslist, they are not stored when new names entered and can’t be sorted on the sheet with 2 columns (Data-Sort). They are sorted in the DropDown list thou.
The 15 Team sheets first bracket top left and right has a 4 row gap to next bracket, why?. Is this a problem with the up/down thingy . Better the gap is 1 row as per all other brackets by dropping down 3 rows?.
Also in 15 Team sheet you only have 14 names in brackets, there is no No1 (Alan) who has a bye so should be in first bracket in L column
Could the table number be cleared when W or L entered, either clear number or change font color to green
In playerslist ‘Players per Team’ I get 2 variant results ie; enter 1 = 15 team, enter 1 (1+space) = 1 ???
On yr Bracket sheet it looks nice, perfect spacing but what is ‘PlayerCountPerTeam’ and ‘TeamCount’ for, they don’t seem to have any function or entry point.
After a quick look.
Once again 'IMPRESSIVE"
Garry
Quick responses:
- No. The brackets are not automatic, but they can be simply drawing by copying the match units as described above. Each match unit (the screen snippet above) can be freely copied and placed, then set to pull a name from the list or winner, etc.
- Use Ctrl+click or just click the hyperlinks depending on your settings in LO. See Ctrl or Not.
- There is a macro for sorting the full playerlist. It also does column balancing. I’ll see about getting that up and running if you are not in a hurry. Otherwise, it’s easy enough to just use one column, but then you’ll be scrolling. Had also considered doing a mark-and-load option, where you select the players you want then load them into the clipboard list??
- The gap for 15 player bracket reflects the logic of byes. But just select the entire match unit (as noted above) and slide it anywhere you want. Again, the layout is completely flexible.
- I double checked, and everyone shows up in the brackets. You can put player 1 in a 16th match unit and we can set up a B for Bye or something, if that is what you are looking for. But that wouldn’t reflect your bye-bracket graphics. Or, if I misunderstand those graphics, then just move the bye round out and the match round in?? Explain to me what you are wanting.
- I can look at hiding table numbers after a match is complete. I think that should just be a conditional formatting, but it might have to be assigned per table, unlike the other CF. That would make it more of a question for how much detail you want to do when setting up the bracket sheets. I’ll think about it.
- I don’t understand 1 = 15, enter 1 … I can say that the top number is whether or not you are playing singles or pairs per team. The bottom number is the number of teams. Either one is really meant to be set-and-left for a given bracket sheet, but you can move between them for some testing until we protect the sheets.
- The _Bracket sheet is programmatic. That defines locations for those quantities on the actual sheet. I think I use direct links as it is, but, for example, the _PlayList sheet is also programmatic, and the location of the Assign1, Name1, etc., are vital to the function of the system. Well, they are compiled into a table, but that table is vital. These are text labels. There is no ‘=’. The get read by the PatternMapToTable macro during development cycles.
Hi J
Replies;
- Automatic was just a hopeful thought!. I do know I can move the brackets.
- Yes I was using CTRL but I wasn’t seeing any reaction, but on a closer look it is changing but I’ve yet to determine why??.
- No stick with your 2 columns that’s nicely visible and if you have a sort macro, cool.
- Yip as above
- The 15 Team sheet is attached, so you see what I’m looking at, with 7 full brackets on Left =14 players and NO name in 2nd tier top which has to show No1 Alan who has the Bye (15th Player) and the winner of 1st tier Robert/Lee game then plays Alan. That must be done as per my graphical brackets.
- In playerslist ‘Players per Team’ I get 2 variant results ie; enter 1 = 15 team, enter 1 (1+space) = 1 ??? Try entering 1 there and ‘15 Team’ shows in box (should that be an option?) then enter 1 space that gives a 1 (expected result).
In your ‘Menu’ I don’t like Load Randomly as this comes back to ‘banging the button to suit the person using it’ possibly. Why is it there as an option?.
Garry
Brackets for Pool Auto Jo16.ods (68.8 KB)
- The Show Full Tournament, etc. buttons crop the outer or inner parts of the contest, so the page can be enlarged to show text larger on a big screen TV/monitor for that part of the tournament.
- On 15Team somehow the 3 for Lee got changed to %. So Lee didn’t show up as the lucky bye player.
- Random list generation or ordered list generation is just as dependent on one-shot as ever. Still just disabled for testing. The option is there for being able to do random teams or have pre-matched players for the King tournament.
- I still don’t understand at all what you are talking about. Sorry. Any player or team count information is entered on the bracket page itself.
Some things are calling…I hope a slowed turnaround is okay. Let me know if you get nervous.
Hi Josh
Yes this has become a very stretched out project. I initially thought it would take a week to get it done, its now been 4 weeks. I need to try and see if I can get some versions working from my limited understanding of your complex coding. I’ll try a sheet to see how I go but obviously I’ll need some help from you but I’ll try to limit it as much as possible.
Garry
Everything works on this end. I’ll post the latest version tomorrow if I can. I might want to add some auto renaming of the playlists, etc. But with the version I’ll post you can build any bracket from 4 single players to 32 pairs, and sheets you build would survive versioning. If you want 2nd life for the 32 pair tournament, that will take adding columns…but there’s plenty of time if that’s MLK Day…
For what I understand you need, you’ll just copy the 15Team using the hyperlink menu at the right…duplicate, not archive. Then you’ll add the one missing match on the left and right to get a 16Team sheet. Once that is done, it’s just a matter of duplicating 15Team and deleting unneeded matches for 14Team, etc. On each new sheet, set the win links just with =D11 or whatever, like on 15Team, but as needed. Then when the win links are done, just number down the original (far left/far right) 1,2,3,… That’s it. Save, copy that sheet, then keep moving down by deleting and rewiring as necessary. There really should be no need to touch the code at all, other than at some point to comment out the Goto that allows unlimited player loading. You may need to delete some extra player lists at some point, which you would do by deleting the entire columns for those player lists.
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)