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

English
,
#38

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)

#39
  • 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.

#40

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

#41

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.

#42

This isn’t perfect, but it should be within range of the request.

Brackets for Pool Auto Jo17.ods (61.4 KB)

#43

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

#44

On a better look the ‘Sheet Name’ list on Program sheet is just a reference as clicking on them does nothing.

#45

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
#46

Can you post your version?

#47

Hi
Here it is
G

Brackets for Pool Auto Jo17.ods (64.5 KB)

#48

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.

#49

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

#50

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.

#51

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)

#52
  • 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.
#53

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

#54

Sure, but you’ll need to edit your question above and add your file with 9Team.

#55

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)

#56

I get the feeling you are glossing over the instructions a little too quickly. Look at

image
image698×376 11.3 KB

The numbers are not 1,2,3,4,… from top to bottom.

#57

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

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.