Help
How can I import tournaments results to Excel?
Page 1 of 1
Tournaments results to Excel
#2
- Group: Admin
- Posts: 14,566
- Joined: 2003-February-13
- Gender:Male
- Location:Amelia Island, FL
- Interests:Bridge, what else?
Posted 2007-January-29, 16:06
Welcome to the BridgeBase Forums!
Do you want full results for each board or just yours?
Just yours is easy... Call up the your play in myhands (use MrKitsos or your real bbo nickname, and make the date range correct). Use your mouse and highlight the tourney data in question. Press control-C at the same time while the tourney is highlighted or go under EDIT and choose copy.
Open blank excel spreadsheet. Paste data into it.
If you want all the boards, well repeat the above process for each board. You will need to use the "traveller" link.
If you want the results, that is a little tricker. Save the Result lin file. Open with notepad or excel.. remove all the lin file control stuff like }PG}} nt} etc.
My hands can be found at.... http://online.bridge...hands/index.php
Ben
Do you want full results for each board or just yours?
Just yours is easy... Call up the your play in myhands (use MrKitsos or your real bbo nickname, and make the date range correct). Use your mouse and highlight the tourney data in question. Press control-C at the same time while the tourney is highlighted or go under EDIT and choose copy.
Open blank excel spreadsheet. Paste data into it.
If you want all the boards, well repeat the above process for each board. You will need to use the "traveller" link.
If you want the results, that is a little tricker. Save the Result lin file. Open with notepad or excel.. remove all the lin file control stuff like }PG}} nt} etc.
My hands can be found at.... http://online.bridge...hands/index.php
Ben
--Ben--
#3
- Group: Members
- Posts: 2
- Joined: 2007-January-29
Posted 2007-January-30, 07:50
inquiry, on Jan 29 2007, 05:06 PM, said:
Welcome to the BridgeBase Forums!
Do you want full results for each board or just yours?
Just yours is easy... Call up the your play in myhands (use MrKitsos or your real bbo nickname, and make the date range correct). Use your mouse and highlight the tourney data in question. Press control-C at the same time while the tourney is highlighted or go under EDIT and choose copy.
Open blank excel spreadsheet. Paste data into it.
If you want all the boards, well repeat the above process for each board. You will need to use the "traveller" link.
If you want the results, that is a little tricker. Save the Result lin file. Open with notepad or excel.. remove all the lin file control stuff like }PG}} nt} etc.
My hands can be found at.... http://online.bridge...hands/index.php
Ben
Do you want full results for each board or just yours?
Just yours is easy... Call up the your play in myhands (use MrKitsos or your real bbo nickname, and make the date range correct). Use your mouse and highlight the tourney data in question. Press control-C at the same time while the tourney is highlighted or go under EDIT and choose copy.
Open blank excel spreadsheet. Paste data into it.
If you want all the boards, well repeat the above process for each board. You will need to use the "traveller" link.
If you want the results, that is a little tricker. Save the Result lin file. Open with notepad or excel.. remove all the lin file control stuff like }PG}} nt} etc.
My hands can be found at.... http://online.bridge...hands/index.php
Ben
Thank you Ben
I actually want just the results. I already have gone through the procedure you describe. It would be much easier if a lin to text converter is available. I know that text to lin converter is available, but what about the reverse one?
MrKitsos
#4
- Group: Admin
- Posts: 14,566
- Joined: 2003-February-13
- Gender:Male
- Location:Amelia Island, FL
- Interests:Bridge, what else?
Posted 2007-January-30, 16:11
There is a lin to text converter (see http://www.ebridgenz.com/download.html) that does a lot of conversions, useful for posting things here for example... but I don't think it handles tourmanent results. Cascade or some programmer might be able to rip on off quickly as removing fixed code from a flat text file should be a piece of cake...sadly I am not a programmer....
--Ben--
Page 1 of 1