Welcome Guest
Log In | Register )
You last visited January 22, 2017, 9:22 pm
All times shown are
Eastern Time (GMT-5:00)

Need Help OpenOffice Calc 4.0.1

Topic closed. 4 replies. Last post 3 years ago by cheech.

Page 1 of 1
PrintE-mailLink
Avatar

United States
Member #141571
April 18, 2013
58 Posts
Offline
Posted: January 14, 2014, 8:51 pm - IP Logged

Need the correct statment or formula in order to complete my back testing sheet.

If someone can help with this, that would be great and very much appreciated.

I want to make a back testing spreadsheet TOOL .

I'll copy & paste 30 or more past P3 draws into the sheet.

I want to enter any 5 (0 to 9) single digits in a single cell or 5 seperate cells. example:  1,2,3,4,5

So what I need is the formula/statment to put in OpenOffice Calc 4.0.1 to have the digits 1,2,3,4,5

run down the past drawn data and check to see if any 3 of the 5 digits matched a str8 past draw.

If a str8 hit put the word Win along side the str8 number.

If no hit put the word Lost along side the no hit number.

The 5 digits will be wheeled which will be 125 sets, so if actually played and any 3 of the 5 digits get drawn it will be 1 straight win. 

Well thats it, if anyone can help. Thank you Type Cheers

California (CA) Daily 3 Midday Lottery Results

 Draw Date  Results 
Tue, Jan 14, 20149-2-1?Prize Payouts Lost
Mon, Jan 13, 20147-3-5?Prize Payouts Lost
Sun, Jan 12, 20147-5-3?Prize Payouts Lost
Sat, Jan 11, 20149-2-8?Prize Payouts Lost
Fri, Jan 10, 20149-9-1?Prize Payouts L
Thu, Jan 9, 20146-9-6?Prize Payouts L
Wed, Jan 8, 20145-0-9?Prize Payouts L
Tue, Jan 7, 20145-5-4?Prize Payouts Win
Mon, Jan 6, 20144-5-3?Prize Payouts Win
Sun, Jan 5, 20149-2-8?Prize Payouts Lost
Sat, Jan 4, 20145-5-5?Prize Payouts Win
Fri, Jan 3, 20149-0-1?Prize Payouts L
Thu, Jan 2, 20149-9-1?Prize Payouts L
Wed, Jan 1, 20146-2-1?Prize Payouts L
Tue, Dec 31, 20137-9-7?Prize Payouts L
Mon, Dec 30, 20135-9-7?Prize Payouts L
Sun, Dec 29, 20136-6-5?Prize Payouts L
Sat, Dec 28, 20133-0-2?Prize Payouts L
Fri, Dec 27, 20130-2-5?Prize Payouts L
Thu, Dec 26, 20136-5-2?Prize Payouts L
Wed, Dec 25, 20133-4-9?Prize Payouts L
Tue, Dec 24, 20130-5-4?Prize Payouts L
Mon, Dec 23, 20139-4-4?Prize Payouts L
Sun, Dec 22, 20130-7-4?Prize Payouts L
Sat, Dec 21, 20138-7-6?Prize Payouts L
Fri, Dec 20, 20130-2-4?Prize Payouts L
Thu, Dec 19, 20139-8-9?Prize Payouts L
Wed, Dec 18, 20136-7-3?Prize Payouts L
Tue, Dec 17, 20138-5-4?Prize Payouts L
Mon, Dec 16, 20136-8-0?Prize Payouts L
Sun, Dec 15, 20139-2-4?Prize Payouts L
Sat, Dec 14, 20135-4-3?Prize Payouts W
Fri, Dec 13, 20138-5-2?Prize Payouts L
Thu, Dec 12, 20130-3-7?Prize Payouts L
Wed, Dec 11, 20134-0-6?Prize Payouts L
Tue, Dec 10, 20138-6-8?Prize Payouts L
Mon, Dec 9, 20134-1-2?Prize Payouts W
Sun, Dec 8, 20139-3-8?Prize Payouts L
Sat, Dec 7, 20131-1-4?Prize Payouts W
Fri, Dec 6, 20135-5-3?Prize Payouts W
    Avatar

    United States
    Member #41846
    June 23, 2006
    460 Posts
    Offline
    Posted: January 15, 2014, 4:57 am - IP Logged

    This is very similar to a topic in the math forum.  I have no experience with open office, so no idea if the same commands are available in open office.  next best option would be a macro.

      winsumloosesum's avatar - Lottery-060.jpg
      Pennsylvania
      United States
      Member #2218
      September 1, 2003
      5396 Posts
      Offline
      Posted: January 15, 2014, 6:17 pm - IP Logged

      Need the correct statment or formula in order to complete my back testing sheet.

      If someone can help with this, that would be great and very much appreciated.

      I want to make a back testing spreadsheet TOOL .

      I'll copy & paste 30 or more past P3 draws into the sheet.

      I want to enter any 5 (0 to 9) single digits in a single cell or 5 seperate cells. example:  1,2,3,4,5

      So what I need is the formula/statment to put in OpenOffice Calc 4.0.1 to have the digits 1,2,3,4,5

      run down the past drawn data and check to see if any 3 of the 5 digits matched a str8 past draw.

      If a str8 hit put the word Win along side the str8 number.

      If no hit put the word Lost along side the no hit number.

      The 5 digits will be wheeled which will be 125 sets, so if actually played and any 3 of the 5 digits get drawn it will be 1 straight win. 

      Well thats it, if anyone can help. Thank you Type Cheers

      California (CA) Daily 3 Midday Lottery Results

       Draw Date  Results 
      Tue, Jan 14, 20149-2-1?Prize Payouts Lost
      Mon, Jan 13, 20147-3-5?Prize Payouts Lost
      Sun, Jan 12, 20147-5-3?Prize Payouts Lost
      Sat, Jan 11, 20149-2-8?Prize Payouts Lost
      Fri, Jan 10, 20149-9-1?Prize Payouts L
      Thu, Jan 9, 20146-9-6?Prize Payouts L
      Wed, Jan 8, 20145-0-9?Prize Payouts L
      Tue, Jan 7, 20145-5-4?Prize Payouts Win
      Mon, Jan 6, 20144-5-3?Prize Payouts Win
      Sun, Jan 5, 20149-2-8?Prize Payouts Lost
      Sat, Jan 4, 20145-5-5?Prize Payouts Win
      Fri, Jan 3, 20149-0-1?Prize Payouts L
      Thu, Jan 2, 20149-9-1?Prize Payouts L
      Wed, Jan 1, 20146-2-1?Prize Payouts L
      Tue, Dec 31, 20137-9-7?Prize Payouts L
      Mon, Dec 30, 20135-9-7?Prize Payouts L
      Sun, Dec 29, 20136-6-5?Prize Payouts L
      Sat, Dec 28, 20133-0-2?Prize Payouts L
      Fri, Dec 27, 20130-2-5?Prize Payouts L
      Thu, Dec 26, 20136-5-2?Prize Payouts L
      Wed, Dec 25, 20133-4-9?Prize Payouts L
      Tue, Dec 24, 20130-5-4?Prize Payouts L
      Mon, Dec 23, 20139-4-4?Prize Payouts L
      Sun, Dec 22, 20130-7-4?Prize Payouts L
      Sat, Dec 21, 20138-7-6?Prize Payouts L
      Fri, Dec 20, 20130-2-4?Prize Payouts L
      Thu, Dec 19, 20139-8-9?Prize Payouts L
      Wed, Dec 18, 20136-7-3?Prize Payouts L
      Tue, Dec 17, 20138-5-4?Prize Payouts L
      Mon, Dec 16, 20136-8-0?Prize Payouts L
      Sun, Dec 15, 20139-2-4?Prize Payouts L
      Sat, Dec 14, 20135-4-3?Prize Payouts W
      Fri, Dec 13, 20138-5-2?Prize Payouts L
      Thu, Dec 12, 20130-3-7?Prize Payouts L
      Wed, Dec 11, 20134-0-6?Prize Payouts L
      Tue, Dec 10, 20138-6-8?Prize Payouts L
      Mon, Dec 9, 20134-1-2?Prize Payouts W
      Sun, Dec 8, 20139-3-8?Prize Payouts L
      Sat, Dec 7, 20131-1-4?Prize Payouts W
      Fri, Dec 6, 20135-5-3?Prize Payouts W

      Not sure if this is what you needed:

      https://app.box.com/s/so9ojfcmwxfiauwz11yo

        Avatar

        United States
        Member #116344
        September 8, 2011
        3941 Posts
        Online
        Posted: January 15, 2014, 6:36 pm - IP Logged

        Not sure if this is what you needed:

        https://app.box.com/s/so9ojfcmwxfiauwz11yo

        Hi, Win

        I need feedback on my request while back, if you're busy,I'll understand.

        Thanks

        Adobea 78

        NB>Mail Box is full

          Avatar

          United States
          Member #141571
          April 18, 2013
          58 Posts
          Offline
          Posted: January 16, 2014, 9:16 am - IP Logged

          Not sure if this is what you needed:

          https://app.box.com/s/so9ojfcmwxfiauwz11yo

          WOW winsumloosesum,

          The calc sheet you made is exactly what I had in mind, and then some. 

          Indeed you have a very special talent. A big thank you, thank you, thank you.  Yes Nod

          Cheech