Random draw Solved

Question

Bonjour, I would like to create a lottery for managing a belote contest without duplicates. I am using the OpenOffice spreadsheet. I copied a formula from a website, here is the text in quotes: "INDEX(A$1:A$216;ALEA.ENTRE.BORNES(1;213))". I would like to know how to manage this formula if there are no errors. I am open to any suggestions. Thank you for your response.

yclik · Answer

Hello A way for a draw without duplicates from 1 to 10 To force Calc to recalculate manually, press Shift+Ctrl+F9.

JCB40 · Answer

Hello  If you're interested   https://www.cjoint.com/c/IAxpPN6u0ik  Best regards

pitelec · Answer

What do the numbers in column B correspond to? Are they the result of a calculation, or were they entered manually? Thank you. Best regards.

pitelec · Answer

Hello Thank you for the response. I have perfectly understood. I would like to create a lottery from 16 players (for example) into teams of 2 for 4 games of belote. (a small seniors' club that plays belote every week), I did not provide enough explanation in my first question. Could you assist me with this issue? I have downloaded some small programs, but most do not work with OpenOffice. I have some basic knowledge of spreadsheets. Thank you for your help. Best regards

pitelec · Answer

Good evening I’m sorry, but I don’t see any connection to my question at all!!!

pitelec · Answer

I will try. Thank you.

yclik · Answer

Good evening a proposal here

pitelec · Answer

Thank you very much. I am very interested, and I think I will get something functional. I will test it, and I will keep you informed. Best regards

pitelec · Answer

Hello I checked the little software "belote", it's exactly what I was looking for. I got it to work, everything is fine. I added some color, optimized the boxes....... One small detail, we're used to functioning with 4 rounds, so if it were possible to add one, that would be great (my spreadsheet skills don't allow me to handle the macros). Thank you in advance. Best regards.

pitelec · Answer

Hello  https://www.cjoint.com/c/IAEiWisdqdi  Attached is the link regarding my last message for belote management  Best regards

yclik · Answer

Hello  To test with 4 rounds https://www.cjoint.com/c/IAEkzltdqvo

pitelec · Answer

Thank you. I will try.

pitelec · Answer

Good evening I tested the program. There seems to be a bug with the results or on the second round sheet. I looked for it, but couldn't find it right away. I posted on cjoint.

yclik · Answer

Good evening  indeed there were errors in the results sheet following the addition of a column https://www.cjoint.com/c/IAEq4kFipAo

pitelec · Answer

Thank you, OK "it works"!!!

pitelec · Answer

Hello, I am following up on the last spreadsheet (belote contest management). I tested the program more thoroughly and noted several different issues depending on the draws. On the "tour 1" and "tour 2" sheets, there is a row shift occurring when clicking the "draw" button; on the "tour 3" sheet, there is a printer issue; while on the "tour 4" sheet, everything seems to be working correctly. So, could you help me sort out these little problems? Thank you in advance. Best regards.

JCB40 · Answer

Good evening While waiting for yclik (whom I greet) to return Your modified file to test  https://www.cjoint.com/c/IBcrNmwIyPk Best regards

pitelec · Answer

Good evening, It's okay for the first issue regarding the line shift. The second issue (a window that opens with the message "clipboard" on print number 3 only). I'm not sending you the workbook that you already have. Thank you very much Best regards

yclik · Answer

Hello the workbook with the modifications for the tours and clipboard. Sorry for the small bugs before, I was too lazy to test.

pitelec · Answer

Hello Okay, that works. I tested with 12 players and even with 8, no problems Thank you very much

JCB40 · Answer

Good evening I apologize, I forgot the sheet for round 3 I am resending you your revised file  https://www.cjoint.com/c/IBdrfZ6kfbk Have a good evening and enjoy your belote Best regards

pitelec · Answer

Hello,I'm sorry but I have an issue with the last workbook sent (IBdisbRxFfM tournoi-Belote4-v2). The buttons (draw and clear points) do not work. Thank you very much for the excellent work done.Best regards.

JCB40 · Answer

Hello  The correct file, sorry  https://www.cjoint.com/c/IBeiHm7vhPk Best regards

pitelec · Answer

I downloaded the file, but I still have the same problem with the buttons. Maybe there's an issue with the OpenOffice settings!!! On cjoint, the file I just received.

JCB40 · Answer

Save the file, close it, and open it again, and don't forget to enable macros.

JCB40 · Answer

Badly awake, it's Monday this time the right file  https://www.cjoint.com/c/IBejfSfi5Ck  this is the correct computer problem

pitelec · Answer

Thank you. I will check this, Every time I open the file, I get a message to enable macros and I do it every time. Open-Office is set up that way. Best regards

JCB40 · Answer

Hello again I'm sorry, I can't find where the problem is It works fine at my place It's after having attached it that it no longer works Best regards

yclik · Answer

Good evening In the jcb40 workbook, the buttons are still in draft form mode to disable draft mode    click on the square to disable the draft form mode

JCB40 · Answer

Hello yclik

What I don't understand is why it works normally on my PC,
and it's only when I attach it that it stops working.
Yet the draft mode is disabled.
If you have an explanation, I'm all ears.
Best regards

JCB40 · Answer

I have version 4 1 6 OpenOffice.

pitelec · Answer

Good evening, This time the file is working normally. Tomorrow I will test it thoroughly, on the 4 parts, but I am confident. Great job, thank you very much for your help. Best regards

JCB40 · Answer

Hello Does your file work normally? If yes, please mark the subject as resolved (gear icon at the top right) Best regards

Random draw - Page 2

Save on excel

Disabled overlay features on my telep

Windows 10 bug

Helpsoft driver updater impossible to uninstall!!!

Strava app in english

My pc boots into bios with windows 11

Windows 10 to 11 + bios change

Many f a i offer a €2 subscription and the card €1"

Fraud related to the new european small parcel tax

The impôt.gouvn identifier is no longer offered on edge