View original (French)

Random draw

pitelec Posted messages 43 Status Member -  
JCB40 Posted messages 3060 Registration date   Status Member Last intervention   -
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.

33 answers

  • 1
  • 2
  1. yclik Posted messages 3875 Registration date   Status Member Last intervention   1 609
     
    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
    1
  2. yclik Posted messages 3875 Registration date   Status Member Last intervention   1 609
     
    Hello
    A way for a draw without duplicates from 1 to 10
    To force Calc to recalculate manually, press Shift+Ctrl+F9.
    0
  3. JCB40 Posted messages 3060 Registration date   Status Member Last intervention   479
     
    Hello

    If you're interested

    https://www.cjoint.com/c/IAxpPN6u0ik

    Best regards
    0
  4. pitelec Posted messages 43 Status Member
     
    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.
    0
    1. yclik Posted messages 3875 Registration date   Status Member Last intervention   1 609
       
      Good evening
      if it's column B of my image,
      it serves to add decimals if the random draw has the same number (for example 8)
      So in column B the value of column A + the value of the row number multiplied by 0.001 will give a different number and allow to assign a rank to the number in column A
      0
  6. pitelec Posted messages 43 Status Member
     
    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
    0
    1. yclik Posted messages 3875 Registration date   Status Member Last intervention   1 609
       
      Hello
      An example of a spreadsheet would need to be uploaded to Cjoint to see.
      How to upload to Cjoint.fr
      0
  7. pitelec Posted messages 43 Status Member
     
    Good evening
    I’m sorry, but I don’t see any connection to my question at all!!!
    0
    1. yclik Posted messages 3875 Registration date   Status Member Last intervention   1 609
       
      Good evening
      a attached spreadsheet would provide assistance with the real data.
      0
  8. pitelec Posted messages 43 Status Member
     
    I will try. Thank you.
    0
  9. yclik Posted messages 3875 Registration date   Status Member Last intervention   1 609
     
    Good evening
    a proposal here
    0
  10. pitelec Posted messages 43 Status Member
     
    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
    0
  11. pitelec Posted messages 43 Status Member
     
    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.
    0
    1. yclik Posted messages 3875 Registration date   Status Member Last intervention   1 609
       
      Good evening
      it is necessary to have the latest spreadsheet on cjoint
      0
  14. pitelec Posted messages 43 Status Member
     
    Thank you. I will try.
    0
  15. pitelec Posted messages 43 Status Member
     
    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.
    0
  17. pitelec Posted messages 43 Status Member
     
    Thank you, OK "it works"!!!
    0
  18. pitelec Posted messages 43 Status Member
     
    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.
    0
  19. JCB40 Posted messages 3060 Registration date   Status Member Last intervention   479
     
    Good evening
    While waiting for yclik (whom I greet) to return
    Your modified file to test

    https://www.cjoint.com/c/IBcrNmwIyPk
    Best regards
    0
  20. pitelec Posted messages 43 Status Member
     
    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
    0
  21. yclik Posted messages 3875 Registration date   Status Member Last intervention   1 609
     
    Hello
    the workbook with the modifications for the tours and clipboard.
    Sorry for the small bugs before, I was too lazy to test.
    0
  • 1
  • 2