EXCEL TOOL FOR LIN FILE POSTING

[inquiry]

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.

 

[hv=lin=pn|inquiry,awgus,flolly,Rojbihn|st%7C%7Cmd%7C2S5QKH789TJD28TC2J%2CS23JAH456QKD49C9K%2CS478H23D356KC378T%2C%7Crh%7C%7Cah%7CBoard%208%7Csv%7Co%7Cmb%7C1H%7Cmb%7Cp%7Cmb%7C2N%7Cmb%7Cp%7Cmb%7C3D%7Cmb%7Cp%7Cmb%7C6N%7Cmb%7Cp%7Cmb%7Cp%7Cmb%7Cp%7Cpc%7CHJ%7Cpc%7CH4%7Cpc%7CH2%7Cpc%7CHA%7Cpc%7CS9%7Cpc%7CSK%7Cpc%7CSA%7Cpc%7CS4%7Cpc%7CS2%7Cpc%7CS7%7Cpc%7CST%7Cpc%7CSQ%7Cpc%7CHT%7Cpc%7CHQ%7Cpc%7CH3%7Cpc%7CC4%7Cpc%7CD9%7Cpc%7CD3%7Cpc%7CDJ%7Cpc%7CD2%7Cpc%7CS6%7Cpc%7CS5%7Cpc%7CSJ%7Cpc%7CS8%7Cpc%7CS3%7Cpc%7CC3%7Cpc%7CC5%7Cpc%7CH8%7Cpc%7CD4%7Cpc%7CD5%7Cpc%7CDQ%7Cpc%7CD8%7Cpc%7CC6%7Cpc%7CC2%7Cpc%7CCK%7Cpc%7CC7%7Cpc%7CHK%7Cpc%7CC8%7Cpc%7CD7%7Cpc%7CH9%7Cpc%7CC9%7Cpc%7CCT%7Cmc%7C12%7C]400|300|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 [/hv]

 

 

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

[jillybean]

[hv=lin=pn|jillybean,santosjuli,kristen33,zielonygil|st%7C%7Cmd%7C2S59H469JQD39QKCJQ%2CS4TJQH38D256TC239%2CS26KH25TKAD4JC47K%2C%7Crh%7C%7Cah%7CBoard%2012%7Csv%7Cn%7Cmb%7Cp%7Cmb%7C1H%7Cmb%7C2C%7Cmb%7C3C%7Cmb%7C3S%7Cmb%7C4H%7Cmb%7C4S%7Cmb%7Cp%7Cmb%7Cp%7Cmb%7Cp%7Cpc%7CHA%7Cpc%7CH7%7Cpc%7CHQ%7Cpc%7CH3%7Cpc%7CDJ%7Cpc%7CDA%7Cpc%7CD3%7Cpc%7CD2%7Cpc%7CD7%7Cpc%7CDQ%7Cpc%7CD5%7Cpc%7CD4%7Cpc%7CDK%7Cpc%7CD6%7Cpc%7CH2%7Cpc%7CD8%7Cpc%7CCQ%7Cpc%7CC2%7Cpc%7CC4%7Cpc%7CCA%7Cpc%7CS3%7Cpc%7CS5%7Cpc%7CSQ%7Cpc%7CSK%7Cpc%7CC7%7Cpc%7CC5%7Cpc%7CCJ%7Cpc%7CC3%7Cpc%7CS9%7Cpc%7CSJ%7Cpc%7CS2%7Cpc%7CS7%7Cpc%7CDT%7Cpc%7CH5%7Cpc%7CS8%7Cpc%7CD9%7Cpc%7CC6%7Cpc%7CH4%7Cpc%7CC9%7Cpc%7CCK%7Cpc%7CHK%7Cpc%7CSA%7Cpc%7CH6%7Cpc%7CH8%7Cpc%7CC8%7Cpc%7CH9%7Cpc%7CS4%7Cpc%7CS6%7Cpc%7CHT%7Cpc%7CCT%7Cpc%7CHJ%7Cpc%7CST%7C]400|300|[/hv]

 

test - cool! thanks Ben :)

[Lelos80te]

What a pity. I have excel 2003 :(

[shintaro]

What a pity. I have excel 2003 :(

 

 

 

lol

 

try this link

 

 

http://www.microsoft.com/downloads/en/details.aspx?FamilyId=941B3470-3AE9-4AEE-8F43-C6BB74CD1466&displaylang=en

 

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

 

B-)

[BunnyGo]

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.

[xx1943]

[hv=lin=pn|xx1943,~~M49892,~~M49890,~~M49891|st||md|3S2AH78QKDQKAC56JQ%2CS69QKH269JD29C28K%2CS478JH5AD37JC347T%2C|rh||ah|Board%205|sv|n|mb|p|mb|p|mb|2N|an|Two%20NT%20opener.%20Could%20have%205M.%20--%202-5%20C%3B%202-5%20D%3B%202-5%20H%3B%202-5%20S%3B%2020-21%20HCP|mb|p|mb|3C|an|Stayman%20--%2011-%20HCP%3B%205-12%20total%20points%20|mb|p|mb|3H|an|2-5%20C%3B%202-5%20D%3B%204-5%20H%3B%202-4%20S%3B%2020-21%20HCP|mb|p|mb|3N|an|3-%20H%3B%204%20S%3B%205-11%20HCP%3B%2012-%20total%20points%20|mb|p|mb|p|mb|p|pc|C2|pc|C3|pc|CA|pc|C5|pc|H4|pc|H7|pc|H9|pc|HA|pc|C4|pc|C9|pc|CJ|pc|CK|pc|C8|pc|C7|pc|D4|pc|CQ|pc|S2|pc|SQ|pc|S4|pc|S5|pc|D9|pc|D3|pc|DT|pc|DQ|pc|DK|pc|D2|pc|D7|pc|D8|pc|DA|pc|S6|pc|DJ|pc|D5|pc|SA|pc|S9|pc|S7|pc|ST|pc|C6|pc|H2|pc|CT|pc|HT|pc|H5|pc|H3|pc|HQ|pc|H6|pc|HK|pc|HJ|pc|S8|pc|S3|pc|H8|pc|SK|pc|SJ|pc|D6|]400|300|Double automatic squeeze for an overtrick in 3NT.

 

 

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

 

 

Great job, Ben,

many many thanks.

And this is permanent (as long anything can be permanent in this world)?

 

Al

[SimonFa]

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

[barmar]

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.

[SimonFa]

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

[imaquila]

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!

[inquiry]

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.bridgebase.com/myhands/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-captain.com/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.

[myfish]

Testing

 

"[hv=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]400|300|I LOVE BBO[/hv]"

 

[hv=lin=y&lin=pn|myfish,~~M7832ydh,sophiacc,~~M5991w8o|st%7C%7Cmd%7C3S3H59TAD3KAC458QK%2CS569JKH48JKD9QC3J%2CS2478QAH267D5TC6A%2C%7Crh%7C%7Cah%7CBoard%201%7Csv%7Co%7Cmb%7C2S%7Cmb%7Cp%7Cmb%7Cp%7Cmb%7Cp%7Cpc%7CHQ%7Cpc%7CHA%7Cpc%7CH4%7Cpc%7CH2%7Cpc%7CS3%7Cpc%7CS5%7Cpc%7CSA%7Cpc%7CST%7Cpc%7CD5%7Cpc%7CD4%7Cpc%7CDA%7Cpc%7CD9%7Cpc%7CC4%7Cpc%7CCJ%7Cpc%7CCA%7Cpc%7CC7%7Cpc%7CDT%7Cpc%7CD7%7Cpc%7CDK%7Cpc%7CDQ%7Cpc%7CD3%7Cpc%7CS6%7Cpc%7CS8%7Cpc%7CDJ%7Cpc%7CC6%7Cpc%7CCT%7Cpc%7CCK%7Cpc%7CC3%7Cpc%7CC5%7Cpc%7CH8%7Cpc%7CS2%7Cpc%7CC2%7Cpc%7CH6%7Cpc%7CH3%7Cpc%7CHT%7Cpc%7CHK%7Cpc%7CHJ%7Cpc%7CH7%7Cpc%7CD8%7Cpc%7CH5%7Cpc%7CSJ%7Cpc%7CSQ%7Cpc%7CD6%7Cpc%7CH9%7Cpc%7CS7%7Cpc%7CC9%7Cpc%7CC8%7Cpc%7CSK%7Cpc%7CS9%7Cpc%7CS4%7Cpc%7CD2%7Cpc%7CCQ%7C]400|300|[/hv]

[myfish]

Another test

[hv=lin=pn|hak123,~~M46127hs,~~M545597b,~~M5488owu|st%7C%7Cmd%7C3S3H59TAD3KAC458QK%2CS569JKH48JKD9QC3J%2CS2478QAH267D5TC6A%2C%7Crh%7C%7Cah%7CBoard%201%7Csv%7Co%7Cmb%7C2S%7Can%7CWeak%20two%20bid%20--%206%2B%20%21S%3B%2010-%20HCP%3B%209%2B%20total%20points%20%7Cmb%7Cp%7Cmb%7C2N%7Can%7CArtificial%20force%20--%2015%2B%20HCP%7Cmb%7Cp%7Cmb%7C3C%7Can%7CFeature%20--%206%2B%20%21S%3B%208-10%20HCP%3B%20%21CQ%3B%209%2B%20total%20points%20%7Cmb%7Cp%7Cmb%7C4S%7Can%7C2%2B%20%21S%3B%2015%2B%20HCP%3B%2016-20%20total%20points%7Cmb%7Cp%7Cmb%7Cp%7Cmb%7Cp%7Cpc%7CD6%7Cpc%7CDA%7Cpc%7CD9%7Cpc%7CD5%7Cpc%7CCK%7Cpc%7CC3%7Cpc%7CC6%7Cpc%7CCT%7Cpc%7CS3%7Cpc%7CS5%7Cpc%7CSA%7Cpc%7CST%7Cpc%7CCA%7Cpc%7CC7%7Cpc%7CC8%7Cpc%7CCJ%7Cpc%7CS8%7Cpc%7CD2%7Cpc%7CH9%7Cpc%7CSJ%7Cpc%7CH4%7Cpc%7CH7%7Cpc%7CHQ%7Cpc%7CHA%7Cpc%7CCQ%7Cpc%7CS6%7Cpc%7CS7%7Cpc%7CC2%7Cpc%7CDT%7Cpc%7CD7%7Cpc%7CDK%7Cpc%7CDQ%7Cpc%7CC5%7Cpc%7CH8%7Cpc%7CS4%7Cpc%7CC9%7Cpc%7CH2%7Cpc%7CH3%7Cpc%7CHT%7Cpc%7CHK%7Cpc%7CS9%7Cpc%7CSQ%7Cpc%7CDJ%7Cpc%7CH5%7Cpc%7CS2%7Cpc%7CD8%7Cpc%7CD3%7Cpc%7CSK%7Cpc%7CHJ%7Cpc%7CH6%7Cpc%7CD4%7Cpc%7CC4%7C]400|300|[/hv]

 

Thanks Ben

[inquiry]

Another test

[hv=lin=pn|hak123,~~M46127hs,~~M545597b,~~M5488owu|st%7C%7Cmd%7C3S3H59TAD3KAC458QK%2CS569JKH48JKD9QC3J%2CS2478QAH267D5TC6A%2C%7Crh%7C%7Cah%7CBoard%201%7Csv%7Co%7Cmb%7C2S%7Can%7CWeak%20two%20bid%20--%206%2B%20%21S%3B%2010-%20HCP%3B%209%2B%20total%20points%20%7Cmb%7Cp%7Cmb%7C2N%7Can%7CArtificial%20force%20--%2015%2B%20HCP%7Cmb%7Cp%7Cmb%7C3C%7Can%7CFeature%20--%206%2B%20%21S%3B%208-10%20HCP%3B%20%21CQ%3B%209%2B%20total%20points%20%7Cmb%7Cp%7Cmb%7C4S%7Can%7C2%2B%20%21S%3B%2015%2B%20HCP%3B%2016-20%20total%20points%7Cmb%7Cp%7Cmb%7Cp%7Cmb%7Cp%7Cpc%7CD6%7Cpc%7CDA%7Cpc%7CD9%7Cpc%7CD5%7Cpc%7CCK%7Cpc%7CC3%7Cpc%7CC6%7Cpc%7CCT%7Cpc%7CS3%7Cpc%7CS5%7Cpc%7CSA%7Cpc%7CST%7Cpc%7CCA%7Cpc%7CC7%7Cpc%7CC8%7Cpc%7CCJ%7Cpc%7CS8%7Cpc%7CD2%7Cpc%7CH9%7Cpc%7CSJ%7Cpc%7CH4%7Cpc%7CH7%7Cpc%7CHQ%7Cpc%7CHA%7Cpc%7CCQ%7Cpc%7CS6%7Cpc%7CS7%7Cpc%7CC2%7Cpc%7CDT%7Cpc%7CD7%7Cpc%7CDK%7Cpc%7CDQ%7Cpc%7CC5%7Cpc%7CH8%7Cpc%7CS4%7Cpc%7CC9%7Cpc%7CH2%7Cpc%7CH3%7Cpc%7CHT%7Cpc%7CHK%7Cpc%7CS9%7Cpc%7CSQ%7Cpc%7CDJ%7Cpc%7CH5%7Cpc%7CS2%7Cpc%7CD8%7Cpc%7CD3%7Cpc%7CSK%7Cpc%7CHJ%7Cpc%7CH6%7Cpc%7CD4%7Cpc%7CC4%7C]400|300|[/hv]

 

Thanks Ben

 

your welcome

[nulacier]

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

[BillHiggin]

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.

[rakgoyal]

I am looking for a tool to be able to use on BBO to work as score board for entering the score when playing rubber contract bridge

 

Need is noticed because the Total Points scoring logic is not clear to me as we find different scores for similar deals

[dfobrien]

Does anyone know how to import a Handviewer-style hand record into a Powerpoint or Word file, for use in teaching? It is useful with some problems to show the progress of the first couple of tricks and then ask students what they plan to do next. So we would need (1) the deal record; (2) with some hands concealed; and (3) to be able to play the cards via "Next" until we reach the desired decision point.

 

I see material on how to do this for a post on these forums, and on Bridgewinners, but nothing for Word or Powerpoint. I know you could simply play the hand on a browser, but in these Zoom times, I find it a pain to keep having to move from your slides to a browser and back again. Embedding the demonstration hand into the slide deck would be much easier.

 

Any suggestions gratefully received. Thanks in advance.

[hawkwind]

Testing from LibreOffice calc.

 

[hv=lin==st%7C%7Cmd%7C2S63HAQJ72DA2CAQT9%2CS54HT96DKT643C863%2CSAQT97HKDQJ95CK52%2CSKJ82H8543D87CJ74%7Csv%7CB%7Cah%7CBoard%204%7Cmb%7CP%7Cmb%7C1S%7Can%7CMajor%20suit%20opening%20--%205%2B%20%21S%3B%2011-21%20HCP%3B%2012-22%20total%20points%7Cmb%7CP%7Cmb%7C2H%7Can%7CForcing%20two%20over%20one%20--%205%2B%20%21H%3B%2012%2B%20HCP%3B%2013%2B%20total%20points%3B%20forcing%20to%203N%7Cmb%7CP%7Cmb%7C3D%7Can%7CNew%20suit%20--%204%2B%20%21D%3B%205%2B%20%21S%3B%2021-%20HCP%3B%2016-22%20total%20points%3B%20forcing%20to%203N%7Cmb%7CP%7Cmb%7C6N%7Can%7C5%2B%20%21H%3B%2019-21%20HCP%7Cmb%7CP%7Cmb%7CP%7Cmb%7CP%7Cpc%7CC3%7Cpc%7CC2%7Cpc%7CCJ%7Cpc%7CCQ%7Cpc%7CH2%7Cpc%7CH6%7Cpc%7CHK%7Cpc%7CH5%7Cpc%7CCK%7Cpc%7CC7%7Cpc%7CC9%7Cpc%7CC8%7Cpc%7CC5%7Cpc%7CC4%7Cpc%7CCA%7Cpc%7CC6%7Cpc%7CCT%7Cpc%7CD3%7Cpc%7CS7%7Cpc%7CS8%7Cpc%7CHA%7Cpc%7CHT%7Cpc%7CS9%7Cpc%7CH8%7Cpc%7CHQ%7Cpc%7CH9%7Cpc%7CD5%7Cpc%7CH4%7Cpc%7CHJ%7Cpc%7CD6%7Cpc%7CST%7Cpc%7CH3%7Cpc%7CH7%7Cpc%7CD4%7Cpc%7CSQ%7Cpc%7CS2%7Cpc%7CDA%7Cpc%7CDT%7Cpc%7CD9%7Cpc%7CD8%7Cpc%7CD2%7Cpc%7CDK%7Cpc%7CDJ%7Cpc%7CD7%7Cpc%7CS5%7Cpc%7CSA%7Cpc%7CSK%7Cpc%7CS3%7Cpc%7CDQ%7Cpc%7CSJ%7Cpc%7CS6%7Cpc%7CS4%7C]400|300|This is cool.[/hv]

[plaur]

[hv=pc=n&s=shkqjt864dkt872c8&w=skj973h72dqj64ckj&n=sa652h9d5caqt7542&e=sqt84ha53da93c963&d=s&v=b&b=7&a=4h4sdppp&p=h9hahkh2s4hqs7sad5d3dkd4hjh7c2h5]399|300[/hv] testing...