2 sided PLL Recognition. A Play-tool

Discussion in 'Software Area' started by rishidoshi, Sep 3, 2012.

Welcome to the Speedsolving.com. You are currently viewing our boards as a guest which gives you limited access to join discussions and access our other features. By joining our free community of over 30,000 people, you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today!

If you have any problems with the registration process or your account login, please contact us and we'll help you get started. We look forward to seeing you on the forums!

Already a member? Login to stop seeing this message.
  1. rishidoshi

    rishidoshi Member

    123
    2
    Sep 6, 2010
    WCA:
    2011DOSH01
    YouTube:
    rishidoshi
    2 sided PLL Recognition. A Play-tool (Excel)

    Hello,
    First of all the original work belongs to JL58
    I found that his work, although spectacular, lacks a bit of "user-friendliness". So I've added a graphical cube onto which the PLL Colors are mapped.
    Hit the Random Drill button and guess the PLL.
    Caution: Different versions for MS office Excel 2003 and Office 2007/2010. (Please Enable macros)
    Please play around and let me know what you think.
    (The preamble, usefulness etc is already covered by JL58 in his post so I'm not gonna repeat that)

    Download link - For MS office 2003
    Download link - For MS office 2007/10
    Download link - For Mac '11 and possibly all non-Microsoft Office. Please use the Blue buttons for AUF.

    [HR][/HR]
    Screenshot:
    [​IMG]
     

    Attached Files:

    Last edited: Sep 17, 2012
  2. StachuK1992

    StachuK1992 statue

    3,809
    25
    Jul 24, 2008
    West Chester, PA
    WCA:
    2008KORI02
    YouTube:
    StachuK1992
    Very neat!
    Not sure how much use it is, and I certainly would have rather had it /not/ in a spreadsheet, but good job.

    One problem - LibreOffice does not like your macros :( But I understand if you're appealing to people with Microsoft Office a lot more.

    Well done,
    Stachu
     
  3. stoic

    stoic Premium Member

    971
    59
    Feb 17, 2011
    Co. Tyrone, N. Ireland
    WCA:
    2013DEAR01
    Yes I use OpenOffice and I'm struggling too
     
  4. Godmil

    Godmil Premium Member

    2,196
    1
    Aug 12, 2010
    Aberdeen, Scotland
    YouTube:
    Godmil
    I've got Excel 2007 and it's not liking this :(
     
  5. rishidoshi

    rishidoshi Member

    123
    2
    Sep 6, 2010
    WCA:
    2011DOSH01
    YouTube:
    rishidoshi
    yea.. sad that it works only on MS office 2003. I can make a VB program... but i don't think it's worth the effort.
     
  6. Godmil

    Godmil Premium Member

    2,196
    1
    Aug 12, 2010
    Aberdeen, Scotland
    YouTube:
    Godmil
    Shame, I'd love to use something like this.
     
  7. rishidoshi

    rishidoshi Member

    123
    2
    Sep 6, 2010
    WCA:
    2011DOSH01
    YouTube:
    rishidoshi
    Yippie! After much effort I made a version for Office 2007/10. I hope it works (fingers crossed). Please report back if it works in non-MS office too.
    Download here. (Also added in main post)
     
    Last edited: Sep 8, 2012
  8. Godmil

    Godmil Premium Member

    2,196
    1
    Aug 12, 2010
    Aberdeen, Scotland
    YouTube:
    Godmil
    Excellent, thanks rishidoshi, works beautifully :)
     
  9. rishidoshi

    rishidoshi Member

    123
    2
    Sep 6, 2010
    WCA:
    2011DOSH01
    YouTube:
    rishidoshi
    New version made...
    - AUF Capability
    - User selected PLL can be displayed.
    - Colors are now consistent.
    (Download link in Main post-2007/10 only)
     
  10. sa11297

    sa11297 Member

    995
    1
    Oct 24, 2010
    Texas
    WCA:
    2011AGAR05
    YouTube:
    sa11297
    Thanks, this is very nice.
     
  11. advincubing

    advincubing Member

    93
    0
    Jun 12, 2012
    YouTube:
    adventuresincubing
    I'm using this on Excel 2011 for Mac. It loads fine and the Random Drill button works. But Ctrl-Q (or Open-Apple-Q) don't. And I can't figure out how to AUF. I assume these issues are because I'm on a Mac and using a newer version of Excel. But just wanted to flag it.
     
  12. rishidoshi

    rishidoshi Member

    123
    2
    Sep 6, 2010
    WCA:
    2011DOSH01
    YouTube:
    rishidoshi
    You can assign any shortcut key that you want. Jst go to Tools>Macro>Macros, Select "DRILL" and Options. (In Windows atleast)
    For AUF, do you see 2 arrow buttons below the 'Previous' button? They are U and U'.
     
  13. advincubing

    advincubing Member

    93
    0
    Jun 12, 2012
    YouTube:
    adventuresincubing
    Yep -- that worked. Thanks.

    The arrows are there, yes. But clicking on them doesn't perform any function. Excel treats them like a graphic that can moved or edited....
     
  14. rishidoshi

    rishidoshi Member

    123
    2
    Sep 6, 2010
    WCA:
    2011DOSH01
    YouTube:
    rishidoshi
    ok, within "sheet1" there are 2 macros. (May not be visible in the tools>macro list). There will be "SpinButton1_SpinDown" - For U and "SpinButton1_SpinUp" for U'.
    Run them somehow and it will work. (I think you don't have the 'Control Toolbox' in your excel. Else the buttons would work.)
     
  15. rishidoshi

    rishidoshi Member

    123
    2
    Sep 6, 2010
    WCA:
    2011DOSH01
    YouTube:
    rishidoshi

    Thanks avidcubing for the feedback in the PM. I've now added the Mac'11 (and possibly all non-MS) version link in the main post.
     
  16. Egide

    Egide Premium Member

    189
    12
    Dec 27, 2009
    Belgium
    WCA:
    2011HIRW01
    YouTube:
    ZZmethod
    Hi guys, l just shared a deck in Anki that has all PLL (88 cases) in a way that you can see 2 sides and be able to train recognition, so if you're interested here's the link to the download: https://ankiweb.net/shared/info/3882311803
     
  17. bananaoftheworld

    bananaoftheworld Member

    1
    0
    Jul 11, 2016
    Hi ! Sorry for Re-Up this post, but i would like try this excel macro but when i launch DRILL the line Test = Evaluate(.Formula1) return error 13

    I think the .Formula1 return other value than boolean (Test variable is boolean)
     

Share This Page