1. Hi. We moved systems, and because it was impossible to achieve feature parity between the systems, we opted to archive the old B&S threads but allow users to read them so that they can put them into our new B&S system.

    There is a support thread if you have any issues.

    Cheers,

    Fok.

Spreadsheet for the new Borrelli stuff...

Discussion in 'B&S Archive' started by discostu004, Jan 18, 2005.



  1. arvi

    arvi Senior member

    Messages:
    235
    Likes Received:
    0
    Joined:
    Sep 28, 2004
    Location:
    New York City
    sorry but the links didn't work
     


  2. discostu004

    discostu004 Affiliate vendor

    Messages:
    1,805
    Likes Received:
    5
    Joined:
    Apr 5, 2004
    Location:
    7,908 Feet, Colorado
    try again, do they work? they work on my end. just let me know
    thx
    lance
     


  3. arvi

    arvi Senior member

    Messages:
    235
    Likes Received:
    0
    Joined:
    Sep 28, 2004
    Location:
    New York City
    link to spreadsheet works but not the one to images
     


  4. bryce330

    bryce330 Senior member

    Messages:
    804
    Likes Received:
    1
    Joined:
    Feb 18, 2003
    The images work for me - you have to capitalize JPG.
     


  5. discostu004

    discostu004 Affiliate vendor

    Messages:
    1,805
    Likes Received:
    5
    Joined:
    Apr 5, 2004
    Location:
    7,908 Feet, Colorado
    1. click on the link with the "xxx" in the end
    2. open the sheet and find column B
    3. those numbers are the image numbers
    4. in the URL where teh "xxx" is (this link will not open a valid page), put the number in there like 6146.JPG

    that will pull up the corresponding pix
     


  6. arvi

    arvi Senior member

    Messages:
    235
    Likes Received:
    0
    Joined:
    Sep 28, 2004
    Location:
    New York City
    ok..thanks..got it, albeit tedious
     


  7. discostu004

    discostu004 Affiliate vendor

    Messages:
    1,805
    Likes Received:
    5
    Joined:
    Apr 5, 2004
    Location:
    7,908 Feet, Colorado
    there's no other way that i can think of. just giving you guys first crack at it before it goes up for anyone/everyone
     


  8. jerseyguy

    jerseyguy Well-Known Member

    Messages:
    72
    Likes Received:
    0
    Joined:
    Jul 25, 2004
    Location:
    New York, NY, United States
    Lance,

    If you want to add links to the images to the spreadsheet you could try something like this:

    =HYPERLINK(CONCATENATE("http://www.virtualclotheshorse.com/images/",MID(B250,1,4),".JPG"))
    =HYPERLINK(CONCATENATE("http://www.virtualclotheshorse.com/images/",MID(B250,6,4),".JPG"))
    =HYPERLINK(CONCATENATE("http://www.virtualclotheshorse.com/images/",MID(B250,11,4),".JPG"))

    only one link per cell, obviously, but all you'd have to do is paste this in one cell and fill it down (just change the B250 to the corresponding image # cell)
     


  9. discostu004

    discostu004 Affiliate vendor

    Messages:
    1,805
    Likes Received:
    5
    Joined:
    Apr 5, 2004
    Location:
    7,908 Feet, Colorado
    thanks for the html, i might try that on the next round, this round is up on the site now
    thx
     


  10. taillfuzz

    taillfuzz Active Member

    Messages:
    33
    Likes Received:
    0
    Joined:
    Aug 18, 2004
    This is an exceptional shipment and there are so many great pieces.
     


  11. discostu004

    discostu004 Affiliate vendor

    Messages:
    1,805
    Likes Received:
    5
    Joined:
    Apr 5, 2004
    Location:
    7,908 Feet, Colorado


Share This Page

Styleforum is proudly sponsored by