• Rosalind Martin
    29
    Does anyone have any code for transforming place notation into a list of bells, ie:

    1 5
    turns into
    12345
    21435
    24153
    42513
    45231
    54321 etc etc

    I'm writing in Excel VBA but I would be happy to translate from something else!
    Thanks.
  • Graham John
    283
    If you just want to get the sequence of rows for any method or composition, you can get them by clicking on the rows icon on Complib's view page for the method or composition. You can then copy the rows and paste them into Excel. e.g. rows of Plain Bob Doubles
  • Stuart Palin
    19
    Depending on what your objectives are ...

    At one time when playing around with doing things in Excel I used cell functions to do an indexed LookUp that returned the Transposition string for a given Place Notation (there are a fairly limited number that are used for most methods, so you can build the tables on an as needed/as time allows basis), then some even more horrendous cell functions to apply that Transposition string to the preceding row in the spreadhseet. I even used the built-in Graphing to draw basic blue lines for methods. Not that I would advocate doing this for anything 'serious' (but then I also did a handwritten Postscript blue-line generator).

    Perhaps on a more useful note, I did write an Excel VBA function that draws a line through a column of cells to trace out the path of a selected bell. The line became a graphic object laid over the grid.
  • John Harrison
    459
    I used cell functions to do an indexed LookUp that returned the Transposition string for a given Place NotationStuart Palin

    A bit of an aside, but I do that in a spreadsheet to help with composing. I enter calls in the appropriate place in the WBMH columns and it calculates all the coursing orders for me. I still need to inspect them but it saves all the rubbing out and recalculating when I make a change early in the composition.
  • Rosalind Martin
    29
    Thanks everyone, plenty here to help me complete my programming.
bold
italic
underline
strike
code
quote
ulist
image
url
mention
reveal
youtube
tweet
Add a Comment

Welcome to your Ringing Forums!

If you would like to join in the conversation, please register for an account.

You will only be able to post and/or comment once you have confirmed your email address and been approved by an Admin.