BetSelection.cc

Please login or register.

Topic: Crossword...Forum Test Only.-Reset Button.  (Read 4969 times)

0 Members and 1 Guest are viewing this topic.

Offline Chrisbis

  • Hero Member
  • *****
  • Posts: 801
    • View Profile
Crossword...Forum Test Only.-Reset Button.
« on: May 17, 2013, 10:30:22 pm »
  • ReplyReply
  • Test of my new "Crossword" Excel sheet for EC bet selection.
    (Paying homage to "6thsense"....Tetris.)


    Crossword is designed to "take-on" one half of random! lol
    Test only.
    Locked for now.


    Once perfected, I will include instructions, the bet selection and how to use.
    Cheers

    * Crossword Forum Test Version.xlsm (46.22 kB - downloaded 243 times.)


    (unlocked now....first test complete....the Excel sheet (with Macros) has attached and can be accessed/used.)


    I would like to test out the Reset Button
    "Click Here to Reset Spins" first to see if it works for other fellows.
    Using the left hand yellow cells (beginning at Column A7, enter random spin numbers (or any U may have to hand), and watch the number being put in a scattered pattern into the first grid.
    Then Click/Press the Rest button, to see if it works.
    Shortcut also available ...Ctrl+s also clears the data spins in the A7 to A90 cells.

    Your feedback on the Excel sheet download and whether the Reset button works, would be appreciated.


    Screen shot of what U should see on the Crossword Excel sheet.

    Method explanation to follow.


    Offline Nickmsi

    • Sr. Member
    • ****
    • Posts: 283
      • View Profile
    Re: Crossword...Forum Test Only.-Reset Button.
    « Reply #1 on: May 18, 2013, 12:11:20 am »
  • ReplyReply
  • Hi Chris . . .

    The Reset button works great . .  .

    Good Job . . .

    Cheers

    Nick

    Offline nOrMy2o0o

    • Full Member
    • ***
    • Posts: 142
    • Gender: Male
    • www.norcosoft.com
      • View Profile
    Re: Crossword...Forum Test Only.-Reset Button.
    « Reply #2 on: May 18, 2013, 09:32:07 am »
  • ReplyReply
  • Windows XP and old Office 2002,
     
    I confirm it does RESET from A7 to A90.
     
    Keep going Chris! If you need help, Nickmsi is EXCELent in VBA.
     
    Cheers

    Offline Chrisbis

    • Hero Member
    • *****
    • Posts: 801
      • View Profile
    Re: Crossword...Forum Test Only.-Reset Button.
    « Reply #3 on: May 18, 2013, 09:50:36 am »
  • ReplyReply
  • Ah ! that's good news....thanks Nick, and thank you for the help U gave in getting me there.


    This is my first time in using Excel 2010, or any Excel/Spreadsheet for that matter.
    Two weeks ago, I knew nothing..............now I know nothing plus! lol



    Crossword.

    This is my Crossword Excel.
    Quite simple idea.....


    U use the first 36 spins out of your chosen casino, to input into the spins column,Column A,
    and those numbers are placed into the first 6 x 6 grid (36 slots) in a sort of random scattered pattern.  :nod:


    The placement is not made in a clever order, just a way of setting up your Crossword template, to then play against the EC colour, in the second 6 x 6 grid, The Betting Pallet.
    Though, each time U play this game, U template Crossword in Grid One will be completely different that the last one.  :o


    The number & colour of each inputted spin is remembered, and as U input the spins in grid One, the Opposite colour for the EC is indicated in the Second 6 x 6 grid, which is then our bet, which we use in a Linear format, taking each suggestion, from top left to right, working our way down to bottom right.


    As soon as U have inputted the 36 spins (which are placed in cells A7 to A42 inclusive, betting can commence.)


    Please Note, at the moment, Zero has not been programmed for, I'm still working on it.


    Each inputted spin, results in the opposite colour in Grid Two, and on Spin 37, U bet the colour now showing at the top left.
    Its grouped into 6 plays to give a Line score.


    This is how the grids will look after 36 spins are inputted......


    The first bet is showing top left in the Grid two, and we bet Black (the square is coloured Black, with a Delicate "B" imbedded), so next number is inputted into Cell A43, and the result will show in the Second Grid.



    Please Note....
    at the moment, Zero has not been programmed for, I'm still working on it.It will show as aWin in the Second Betting Pallet.
    This is a Test only posting.


    Flat Betting Only for now!

    Offline Chrisbis

    • Hero Member
    • *****
    • Posts: 801
      • View Profile
    Re: Crossword...Forum Test Only.-Reset Button.
    « Reply #4 on: May 18, 2013, 10:05:28 am »
  • ReplyReply
  • After betting against the colours shown at the top of Grid Two, (working Top left to Top Right)
    we have completed the first 6 spins, and our first Row.


    Here's how it should look.....
    (and the score shows accordingly)



    U will also notice, the spin numbers inputted, scroll upwards so U never lose the view of the Base & Betting Pallets
    (grids One & Two)

    Flat Betting Only for now!

    Offline Rob22

    • Member
    • **
    • Posts: 1
      • View Profile
    Re: Crossword...Forum Test Only.-Reset Button.
    « Reply #5 on: May 18, 2013, 10:09:46 am »
  • ReplyReply
  • Hi Chris

    looks like an interesting concept
    What happens when the 0 shows up.Do we ignore it.
    Because in the excel it shows as a win every time



    Offline Chrisbis

    • Hero Member
    • *****
    • Posts: 801
      • View Profile
    Re: Crossword...Forum Test Only.-Reset Button.
    « Reply #6 on: May 18, 2013, 10:09:53 am »
  • ReplyReply
  • Here is the second Grid (the Betting Pallet) after the second Row of bets has been completed.
    (and our score is shown at the side, and as a session Total so far)


    Flat Betting Only for now!

    Offline Chrisbis

    • Hero Member
    • *****
    • Posts: 801
      • View Profile
    Re: Crossword...Forum Test Only.-Reset Button.
    « Reply #7 on: May 18, 2013, 10:14:47 am »
  • ReplyReply
  • Hi Rob.....Thanx for asking.... good Q.


    I know Zero is a problem for me, and this is a TEST only concept.
    I'm still trying to figure out how to stop my Excel sheet to place Zero as a Win, since is falls as a "0"
    and is counted as Not equal to the colour in Grid One, and hence is a "Win".
    I'm for now suggesting we ignore it, and reduce the session total by the number of Zeros shown in Grid Two.
    I will work out a solution, I'm just not quite clever enough to find one yet!


    Test only Folks.........No real dosh !

    Offline Chrisbis

    • Hero Member
    • *****
    • Posts: 801
      • View Profile
    Re: Crossword...Forum Test Only.-Reset Button.
    « Reply #8 on: May 18, 2013, 10:29:19 am »
  • ReplyReply
  • ...And here is a completed session for the Betting Pallet.
    (I just threw numbers in at random, without looking at the screen, so the result is just as it is!)


    Just so U know what to expect.
    U will have now completed 72 spins in total, and if U like, U carry on by hitting the Reset Button, and begin again ti input your new 36 base spins into Grid One, and set up a completely new Betting Pallet in Grid Two.




    Flat Betting Only for now!

    Offline Chrisbis

    • Hero Member
    • *****
    • Posts: 801
      • View Profile
    Re: Crossword...Forum Test Only.-Reset Button.
    « Reply #9 on: May 18, 2013, 10:33:28 am »
  • ReplyReply
  • When I have cured the Zero problem, I will post up a New version.


    I also intended to make an Excel sheet of the same design for High/Low, and Odd/Even.


    Its just a variation on the game!

    Also, I want to make smaller versions of the same game, say 3 x 3, 4 x 4 & 5  x 5 matrix grids.
    Plus, options to vary where the scattered inputted numbers go on the first grid.

    Its just an idea, and obviously still a very mechanical bet selection.
    With Flat betting, the 6 x 6 grid, the worst case scenario is -36 units
    The best outcome is +36 units.

    cheers all. :D