1eyedjack Posted June 10, 2006 Report Share Posted June 10, 2006 There may already be a way of doing this. If not it may be too difficult. But I would like a bit more flexibity in manipulating reports of myhands. In particular, I would like to filter the displayed hands so that they are limited not just to the ones that I participated in but also the ones that I participated WITH A SPECIFIED PARTNER. I would also like to be able to select perhaps a group of continous hands from those displayed and view a summary of the total/average results for just that selection. I would also like the number of times the hand has been played (ie whether movement complete) to be displayed on the summary page for the hand without having to drill down to the traveller (can live without that feature). Much of what I want to achieve might be possible with only minimal tweaking if I could save the html page as an xls workbook, to which I could then add filtering based on Excel built in functionality, and other formulae, but I cannot see how to get the listing into Excel in the first place. Anyone got ideas on that? Quote Link to comment Share on other sites More sharing options...
uday Posted June 10, 2006 Report Share Posted June 10, 2006 You can open the myhands page in excel w/the following procedure 1. Get the URL from your browser and append a &offset=0 to the end It will look something likehttp://online.bridgebase.com/myhands/hands...998400&offset=0 2, Start Excel. Click File/OpenPaste this URL into the 'File Name' area. Excel will open the web page and convert the html table into row/cols. As far as upgrading myhands goes: maybe Gerardo is listening. Quote Link to comment Share on other sites More sharing options...
1eyedjack Posted June 10, 2006 Author Report Share Posted June 10, 2006 Great tip. Worked a treat. Thanks. Quote Link to comment Share on other sites More sharing options...
Gerardo Posted June 10, 2006 Report Share Posted June 10, 2006 Actually, offset=0 gives UTC times. So if you need local times, need to modify it.Offset is measured in seconds from UTC time, positive to the West, negative to the East. Quote Link to comment Share on other sites More sharing options...
pigpenz Posted June 11, 2006 Report Share Posted June 11, 2006 what you really need is to get Steve Pickets Bridgebrowser program it will do all this and more. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.