BBO Discussion Forums: EXCEL TOOL FOR LIN FILE POSTING - BBO Discussion Forums

Jump to content

Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

EXCEL TOOL FOR LIN FILE POSTING

#1 User is offline   inquiry 

  • PipPipPipPipPipPipPipPipPipPip
  • Group: Admin
  • Posts: 14,563
  • Joined: 2003-February-13
  • Gender:Male
  • Location:Amelia Island, FL
  • Interests:Bridge, what else?

Posted 2011-April-11, 10:23

Excel google document download at www.tinyurl.com/forumlin the xlsx sheet to use (or click the link below to forumlin)

forumlin


This link should allow you to download a one page excel spreadsheet that will allow you to post lin files into the forums. This allows you to use the HV format rather than the http format. The HV format can be resized, and will be permanent (that is, after myhands disappears if you use a link to the hand there rather than show the full hand).

You cut the very busy hand information from the movie view of the hand (that is, something like this...

http://www.bridgebase.com/tools/handviewer.html?lin=pn|VIV1970,inquiry,iacopo1994,dydzio|st%7C%7Cmd%7C3S8TJAH3JAD29TC38Q%2CS69KH69TQD4QC456T%2CS5HD5678JKAC27JKA%2C%7Crh
%7C%7Cah%7CBoard%201%7Csv%7Co%7Cmb%7C1D%7Cmb%7C2H%7Cmb%7Cp%7Cmb%7Cp%7Cmb%7C5D%7Cmb%7Cp%7Cmb%7C6D%7Cmb%7Cp%7Cmb%7Cp%7Cmb%7Cp%7Cpc%7CC9%7Cpc
%7CCQ%7Cpc%7CC6%7Cpc%7CC2%7Cpc%7CD2%7Cpc%7CD4%7Cpc%7CDA%7Cpc%7CD3%7Cpc%7CDK%7Cpc%7CH2%7Cpc%7CD9%7Cpc%7CDQ%7Cpc%7CCA%7Cpc%7CS2%7Cmc%7C13%7C 


and paste it into the yellow field in B2 (or B7 or B11). If you want to have comments appear when you post the hand, you can type them in the green fields at B3 (for hand pasted to B2), or B8 or B12 for hands two and three.

Then you just copy the content from B4 (or B9 or B12) and paste that in your post. This should work, here is a slam bid against me in the birthday celebration as an example.

I only got 11% for defending against this one. :(

I have set the DEFAULT size to 400 x 300, you can edit the concatenate command (cells B4, B9, B12) to make the display larger or smaller if you like



Note: don't just copy the link from myhands... such a link looks something like this:
htp://www.bridgebase.com/tools/handviewer.html?myhand=M-4349548-1302364856

You need to click on the link and open the hand to get the actual link you want to paste. For the record, here is what the above hand will look like if you paste it just as the http (and in two to three months, the hand below will be gone, come back then and check).


orignal hand in http://www.bridgebase.com/tools/handviewer.html?myhand=M-4349548-1302364856 format
--Ben--

#2 User is offline   jillybean 

  • hooked
  • PipPipPipPipPipPipPipPipPip
  • Group: Advanced Members
  • Posts: 7,691
  • Joined: 2003-November-15
  • Gender:Female
  • Location:Vancouver #1 city in the world :)
  • Interests:Bridge, skiing

Posted 2011-April-11, 17:24



test - cool! thanks Ben :)
Searching for your own mistakes is the only way to learn this game. - Fluffy

And no matter what methods you play, it is essential, for anyone aspiring to learn to be a good player, to learn the importance of bidding shape properly. - MikeH

SLOW DOWN! This is not a speedball :)
0

#3 User is offline   Lelos80te 

  • PipPip
  • Group: Members
  • Posts: 38
  • Joined: 2010-October-09
  • Gender:Male
  • Location:Poland

Posted 2011-April-24, 11:09

What a pity. I have excel 2003 :(
0

#4 User is offline   shintaro 

  • PipPipPipPip
  • Group: Full Members
  • Posts: 344
  • Joined: 2007-November-20

Posted 2011-April-25, 13:23

View PostLelos80te, on 2011-April-24, 11:09, said:

What a pity. I have excel 2003 :(




lol

try this link


http://www.microsoft...&displaylang=en

free download for EXCEL converter DOWNWARDS From 2007 even down to 1997

B-)
0

#5 User is offline   BunnyGo 

  • Lamentable Bunny
  • PipPipPipPipPipPip
  • Group: Advanced Members
  • Posts: 1,503
  • Joined: 2008-March-01
  • Gender:Male
  • Location:Portland, ME

Posted 2011-September-01, 02:26

Can we pin this thread in a good forum (like software support or Discussion)? I never know how to search for it (with words longer than .lin) and it seems based on the posts every month or so which have complaints about posting hands that I'm not unique.

Edit: There's also another thread I can never find (I think it's mostly a conversation between inquiry and bbradley) that does this same thing in long form for those of us for whom cannot use EXCEL. I wouldn't mind if that were pinned somewhere.
Bridge Personality: 44 44 43 34

Never tell the same lie twice. - Elim Garek on the real moral of "The boy who cried wolf"
0

#6 User is offline   xx1943 

  • PipPipPipPip
  • Group: Full Members
  • Posts: 492
  • Joined: 2004-March-11

Posted 2013-January-10, 10:21

Double automatic squeeze for an overtrick in 3NT.


This hand occurred in a robot-tourney it is only to test the forumlin EXEL-tool.



Great job, Ben,
many many thanks.
And this is permanent (as long anything can be permanent in this world)?

Al
Play Bridge for fun and entertainment and to meet nice people.
BAD bidding may be succesful due to excellent play, but not vice versa.
Teaching in the BIL TUE 8:00am CET.

Lessons available. For INFO look here: Play bridge with Al
0

#7 User is offline   SimonFa 

  • PipPipPipPip
  • Group: Full Members
  • Posts: 408
  • Joined: 2011-April-11
  • Gender:Male
  • Location:North Dorset, England
  • Interests:Bridge, golf, sailing (yachts and dinghies),

Posted 2013-August-05, 02:36

View Postinquiry, on 2011-April-11, 10:23, said:

Excel google document download at www.tinyurl.com/forumlin the xlsx sheet to use (or click the link below to forumlin)

forumlin



You cut the very busy hand information from the movie view of the hand (that is, something like this...

http://www.bridgebase.com/tools/handviewer.html?lin=pn|VIV1970,inquiry,iacopo1994,dydzio|st%7C%7Cmd%7C3S8TJAH3JAD29TC38Q%2CS69KH69TQD4QC456T%2CS5HD5678JKAC27JKA%2C%7Crh
%7C%7Cah%7CBoard%201%7Csv%7Co%7Cmb%7C1D%7Cmb%7C2H%7Cmb%7Cp%7Cmb%7Cp%7Cmb%7C5D%7Cmb%7Cp%7Cmb%7C6D%7Cmb%7Cp%7Cmb%7Cp%7Cmb%7Cp%7Cpc%7CC9%7Cpc
%7CCQ%7Cpc%7CC6%7Cpc%7CC2%7Cpc%7CD2%7Cpc%7CD4%7Cpc%7CDA%7Cpc%7CD3%7Cpc%7CDK%7Cpc%7CH2%7Cpc%7CD9%7Cpc%7CDQ%7Cpc%7CCA%7Cpc%7CS2%7Cmc%7C13%7C 





OK I give in. How do I get this info, I've faffed about with myhands and got the tinyurl but I cant find a way to generate this sort of data.


Thanks,

Simon
0

#8 User is offline   barmar 

  • PipPipPipPipPipPipPipPipPipPipPip
  • Group: Admin
  • Posts: 16,575
  • Joined: 2004-August-21
  • Gender:Male

Posted 2013-August-05, 19:59

View PostSimonFa, on 2013-August-05, 02:36, said:

OK I give in. How do I get this info, I've faffed about with myhands and got the tinyurl but I cant find a way to generate this sort of data.

When you click on "Movie" in myhands and it opens a new window, the LIN string will be in the URL in the address bar.

#9 User is offline   SimonFa 

  • PipPipPipPip
  • Group: Full Members
  • Posts: 408
  • Joined: 2011-April-11
  • Gender:Male
  • Location:North Dorset, England
  • Interests:Bridge, golf, sailing (yachts and dinghies),

Posted 2013-August-06, 00:27

View Postbarmar, on 2013-August-05, 19:59, said:

When you click on "Movie" in myhands and it opens a new window, the LIN string will be in the URL in the address bar.


Haha, I get it now. You can only use for tournament results.

Thanks,

Simon
0

#10 User is offline   imaquila 

  • PipPip
  • Group: Members
  • Posts: 18
  • Joined: 2008-February-25

Posted 2014-October-31, 16:03

I'm looking for way of saving my hands to actually play so that I can send them to my partner. Is that the result of this tool? To be able to play the hand or just to study it like a screen capture. If this IS the tool I've been searching for, how do I go about finding that HV code for the hand to copy it into the spread sheet?

Thanks!
0

#11 User is offline   inquiry 

  • PipPipPipPipPipPipPipPipPipPip
  • Group: Admin
  • Posts: 14,563
  • Joined: 2003-February-13
  • Gender:Male
  • Location:Amelia Island, FL
  • Interests:Bridge, what else?

Posted 2014-November-01, 21:12

View Postimaquila, on 2014-October-31, 16:03, said:

I'm looking for way of saving my hands to actually play so that I can send them to my partner. Is that the result of this tool? To be able to play the hand or just to study it like a screen capture. If this IS the tool I've been searching for, how do I go about finding that HV code for the hand to copy it into the spread sheet?

Thanks!


This was made for posting hnnds here in these forums. The good news is it easy as dirt to send hands to your partner for play, and thanks for a new feature added to bbo's handviewer software, you partner can play them as played at the table of be able to change the cards played,...

go to http://www.bridgebas...hands/index.php use that to find the hand(s) click on the "movie" link to the hand you are interested in. Copy the hyperlink from the address bar, and email that to your partner. (don't copy the link by right clicking on it, because if there is a delay in looking at the hand, the data might be deleted from the myhands web page before it is watched.

A better option is probably to grab the hands you want using double dummy solver (http://www.bridge-ca...downloadDD.html ) and letting your partner get his own copy of that free program and send him the file with the hand(s) you want him to look at along with a description of which ones you want him to review.
--Ben--

#12 User is offline   myfish 

  • PipPip
  • Group: Members
  • Posts: 46
  • Joined: 2004-March-26

Posted 2016-January-28, 02:32

Testing

"
I LOVE BBO
"


0

#13 User is offline   myfish 

  • PipPip
  • Group: Members
  • Posts: 46
  • Joined: 2004-March-26

Posted 2016-January-28, 02:38

Another test


Thanks Ben
0

#14 User is offline   inquiry 

  • PipPipPipPipPipPipPipPipPipPip
  • Group: Admin
  • Posts: 14,563
  • Joined: 2003-February-13
  • Gender:Male
  • Location:Amelia Island, FL
  • Interests:Bridge, what else?

Posted 2016-January-28, 20:58

View Postmyfish, on 2016-January-28, 02:38, said:

Another test


Thanks Ben


your welcome
--Ben--

#15 User is offline   nulacier 

  • Pip
  • Group: Members
  • Posts: 7
  • Joined: 2010-November-02

Posted 2017-February-05, 03:37

Hi, I'm looking to get this working with "Calc" from the free and opensource "Libreoffice" : https://www.libreoffice.org/
I'm sure it could be done with your help :) Thanks
0

#16 User is offline   BillHiggin 

  • PipPipPipPip
  • Group: Full Members
  • Posts: 469
  • Joined: 2007-February-03

Posted 2017-February-05, 08:33

View Postnulacier, on 2017-February-05, 03:37, said:

Hi, I'm looking to get this working with "Calc" from the free and opensource "Libreoffice" : https://www.libreoffice.org/
I'm sure it could be done with your help :) Thanks


Real help not needed. Just download the file and then open it from calc! The formulas will work in any reasonable excel work-alike and calc is happy to open .xlsx files. A formula fails to properly allow for empty input, and the error message is not the exact same on excel, calc or google sheets, but once you have valid input, all will do the same thing.
You must know the rules well - so that you may break them wisely!
0

Share this topic:


Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

1 User(s) are reading this topic
0 members, 1 guests, 0 anonymous users