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

Jump to content

  • 2 Pages +
  • 1
  • 2
  • You cannot start a new topic
  • You cannot reply to this topic

EXCEL TOOL FOR LIN FILE POSTING

#21 User is offline   svengolly 

  • PipPipPip
  • Group: Full Members
  • Posts: 61
  • Joined: 2012-April-01
  • Gender:Male

Posted 2024-April-12, 12:45

I cannot get this to work in 2024. When I preview the post, it just shows an empty hand. The following is what I am pasting into the spreadsheet data.

https://www.bridgebase.com/tools/handviewer.html?bbo=y&lin=pn%7CSvenGolly,~~M22700,~~M22698,~~M22699%7Cst%7C%7Cmd%7C4S2JAH25D568AC59QK%2CS4TQH46TQAD79C37J%2CS359KH789D34JKC26%2C%7Crh%7C%7Cah%7CBoard%202%7Csv%7Cn%7Cmb%7Cp%7Cmb%7C1D%7Can%7CMinor%20suit%20opening%20--%203%2B%20%21D%3B%2011-21%20HCP%3B%2012-22%20total%20points%7Cmb%7C1H%7Can%7COne-level%20overcall%20--%205%2B%20%21H%3B%208-17%20HCP%3B%209-19%20total%20points%20%7Cmb%7Cd%7Can%7CNegative%20double%20--%204%20%21S%3B%205%2B%20HCP%3B%206%2B%20total%20points%20%7Cmb%7C2D%7Can%7CGood%20support%20in%20H%20--%203%2B%20%21H%3B%2011-%20HCP%3B%2010-12%20total%20points%20%7Cmb%7Cp%7Cmb%7C2H%7Can%7C5%2B%20%21H%3B%208%2B%20HCP%3B%209-13%20total%20points%20%7Cmb%7Cp%7Cmb%7Cp%7Cmb%7C2S%7Can%7C3%2B%20%21D%3B%203%2B%20%21S%3B%2011%2B%20HCP%3B%2012-17%20total%20points%7Cmb%7Cp%7Cmb%7C3H%7Can%7C4-%20%21S%3B%208%2B%20HCP%3B%20biddable%20%21S%3B%208-%20total%20points%20%7Cmb%7Cp%7Cmb%7C3S%7Can%7C3%2B%20%21D%3B%203%2B%20%21S%3B%2011%2B%20HCP%3B%2012-16%20total%20points%7Cmb%7Cp%7Cmb%7Cp%7Cmb%7Cp%7Cpc%7CD9%7Cpc%7CDJ%7Cpc%7CDQ%7Cpc%7CDA%7Cpc%7CCK%7Cpc%7CC3%7Cpc%7CC6%7Cpc%7CCA%7Cpc%7CS8%7Cpc%7CSJ%7Cpc%7CSQ%7Cpc%7CSK%7Cpc%7CC2%7Cpc%7CC4%7Cpc%7CCQ%7Cpc%7CC7%7Cpc%7CC9%7Cpc%7CCJ%7Cpc%7CS3%7Cpc%7CCT%7Cpc%7CS5%7Cpc%7CS6%7Cpc%7CSA%7Cpc%7CS4%7Cpc%7CD5%7Cpc%7CD7%7Cpc%7CDK%7Cpc%7CD2%7Cpc%7CD4%7Cpc%7CDT%7Cpc%7CD6%7Cpc%7CH4%7Cpc%7CS7%7Cpc%7CS2%7Cpc%7CST%7Cpc%7CS9%7Cpc%7CHA%7Cpc%7CH7%7Cpc%7CH3%7Cpc%7CH2%7Cpc%7CH6%7Cpc%7CH8%7Cpc%7CHK%7Cpc%7CH5%7Cpc%7CC8%7Cpc%7CC5%7Cpc%7CHT%7Cpc%7CD3%7Cpc%7CHJ%7Cpc%7CD8%7Cpc%7CHQ%7Cpc%7CH9%7C


Here's what's generated:

[hv=lin==y&lin=pn%7CSvenGolly,~~M22700,~~M22698,~~M22699%7Cst%7C%7Cmd%7C4S2JAH25D568AC59QK%2CS4TQH46TQAD79C37J%2CS359KH789D34JKC26%2C%7Crh%7C%7Cah%7CBoard%202%7Csv%7Cn%7Cmb%7Cp%7Cmb%7C1D%7Can%7CMinor%20suit%20opening%20--%203%2B%20%21D%3B%2011-21%20HCP%3B%2012-22%20total%20points%7Cmb%7C1H%7Can%7COne-level%20overcall%20--%205%2B%20%21H%3B%208-17%20HCP%3B%209-19%20total%20points%20%7Cmb%7Cd%7Can%7CNegative%20double%20--%204%20%21S%3B%205%2B%20HCP%3B%206%2B%20total%20points%20%7Cmb%7C2D%7Can%7CGood%20support%20in%20H%20--%203%2B%20%21H%3B%2011-%20HCP%3B%2010-12%20total%20points%20%7Cmb%7Cp%7Cmb%7C2H%7Can%7C5%2B%20%21H%3B%208%2B%20HCP%3B%209-13%20total%20points%20%7Cmb%7Cp%7Cmb%7Cp%7Cmb%7C2S%7Can%7C3%2B%20%21D%3B%203%2B%20%21S%3B%2011%2B%20HCP%3B%2012-17%20total%20points%7Cmb%7Cp%7Cmb%7C3H%7Can%7C4-%20%21S%3B%208%2B%20HCP%3B%20biddable%20%21S%3B%208-%20total%20points%20%7Cmb%7Cp%7Cmb%7C3S%7Can%7C3%2B%20%21D%3B%203%2B%20%21S%3B%2011%2B%20HCP%3B%2012-16%20total%20points%7Cmb%7Cp%7Cmb%7Cp%7Cmb%7Cp%7Cpc%7CD9%7Cpc%7CDJ%7Cpc%7CDQ%7Cpc%7CDA%7Cpc%7CCK%7Cpc%7CC3%7Cpc%7CC6%7Cpc%7CCA%7Cpc%7CS8%7Cpc%7CSJ%7Cpc%7CSQ%7Cpc%7CSK%7Cpc%7CC2%7Cpc%7CC4%7Cpc%7CCQ%7Cpc%7CC7%7Cpc%7CC9%7Cpc%7CCJ%7Cpc%7CS3%7Cpc%7CCT%7Cpc%7CS5%7Cpc%7CS6%7Cpc%7CSA%7Cpc%7CS4%7Cpc%7CD5%7Cpc%7CD7%7Cpc%7CDK%7Cpc%7CD2%7Cpc%7CD4%7Cpc%7CDT%7Cpc%7CD6%7Cpc%7CH4%7Cpc%7CS7%7Cpc%7CS2%7Cpc%7CST%7Cpc%7CS9%7Cpc%7CHA%7Cpc%7CH7%7Cpc%7CH3%7Cpc%7CH2%7Cpc%7CH6%7Cpc%7CH8%7Cpc%7CHK%7Cpc%7CH5%7Cpc%7CC8%7Cpc%7CC5%7Cpc%7CHT%7Cpc%7CD3%7Cpc%7CHJ%7Cpc%7CD8%7Cpc%7CHQ%7Cpc%7CH9%7C]400|300|[/hv]


And here's what it looks like when not in <code> brackets:



Am I doing something wrong?
0

#22 User is offline   ASC87 

  • PipPip
  • Group: Members
  • Posts: 41
  • Joined: 2023-August-23
  • Gender:Female
  • Location:Pakistan

Posted 2024-December-19, 20:21

=CONCATENATE("
",B3,"
")
0

  • 2 Pages +
  • 1
  • 2
  • You cannot start a new topic
  • You cannot reply to this topic

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