|
|
Post by Chris_Sav on Nov 25, 2019 12:13:30 GMT
Have set it up, Once you are happy then we can use this as a template and start the conversion across the board.
I will also tidy up this thread once this phase is considered completed.
|
|
|
|
Post by Lewis on Nov 25, 2019 12:42:18 GMT
|
|
|
|
Post by Deleted on Nov 25, 2019 12:42:40 GMT
Yes, and have added Joe's recent changes. All systems go !
|
|
|
|
Post by Chris_Sav on Nov 25, 2019 12:55:20 GMT
Thanks for the info, mind you our securities are wrong as this is not an area where non members should be able to post, will take a look  In the meantime applications to join are always welcome Lewis Oscars did not appear to be on the map |
|
|
|
Post by Chris_Sav on Nov 25, 2019 13:27:27 GMT
Joe's three updated on the map.
Welcome acknowledgement sent to Lewis
|
|
|
|
Post by joefoxon on Nov 25, 2019 16:22:40 GMT
your case (Notts) there is no reason why you couldn't be the one to maintain it, especially as you have come up with a design which I will probably follow ! Feel free to use the format, although it's fairly time consuming unless you use Excel and tablify it. |
|
|
|
Post by Deleted on Nov 25, 2019 17:53:53 GMT
Feel free to use the format, although it's fairly time consuming unless you use Excel and tablify it. Yeah, much as I like Excel and its presentation, I will probably stick to the same format I've been doing since 2010 now that it's going to be made easier. Thanks anyway.
Converting Word files to Excel would take an eternity, and if anything I seem to have less free time available since I've retired !!!
|
|
|
|
Post by joefoxon on Nov 25, 2019 19:46:27 GMT
If you have the file, I can probably convert it for you. Excel is far easier to work with for this sort of thing.
|
|
|
|
Post by Deleted on Nov 25, 2019 21:53:18 GMT
If you have the file, I can probably convert it for you. Excel is far easier to work with for this sort of thing. I don't keep separate files - what you see here is what you get. But you can have a go at converting this one if you like : barbilliards.proboards.com/thread/22136/list-tables-east-midlandsSav can then make a judgement on whether it justifies inserting you in the loop. |
|
|
|
Post by joefoxon on Nov 25, 2019 22:06:32 GMT
If you have the file, I can probably convert it for you. Excel is far easier to work with for this sort of thing. I don't keep separate files - what you see here is what you get. But you can have a go at converting this one if you like : barbilliards.proboards.com/thread/22136/list-tables-east-midlandsSav can then make a judgement on whether it justifies inserting you in the loop. I can manually put all the details into an excel file, although the list itself doesn't have consistent formatting throughout. But once I've done one list, it will be fairly elementary to add the others. |
|
|
|
Post by Deleted on Nov 26, 2019 9:08:04 GMT
I can manually put all the details into an excel file, although the list itself doesn't have consistent formatting throughout. But once I've done one list, it will be fairly elementary to add the others. There are a number of applications available on the net which enable one to convert a Word file to Excel without having to enter in line-by-line manually. For example:
It's just that I had yet to find the most reliable, efficient one and was banking on your recommendation.
|
|
|
|
Post by joefoxon on Nov 26, 2019 9:54:36 GMT
I can manually put all the details into an excel file, although the list itself doesn't have consistent formatting throughout. But once I've done one list, it will be fairly elementary to add the others. There are a number of applications available on the net which enable one to convert a Word file to Excel without having to enter in line-by-line manually. For example:
It's just that I had yet to find the most reliable, efficient one and was banking on your recommendation.
There is a fairly simple way to do it, although it won't work perfectly as not all the entries in the list are in the same format. It will work for the vast majority though, and will only require a few manual corrections. |
|
|
|
Post by Deleted on Nov 26, 2019 10:27:56 GMT
Right then, let's see how quickly you do it on East Midlands, and then we can try it out for London.
|
|
|
|
Post by Chris_Sav on Nov 26, 2019 10:59:49 GMT
Joe is correct in that the text can be converted into an excel table fairly easily, which can then be posted with 'tablify' that I added to the forum.
It's just a question of adding or using a suitable delimeter between the potential columns and editing the odd one that was in a strange format. Formatting is the main problem.
If Lewis from Notts is reading this I have had no reply from you.
|
|
|
|
Post by joefoxon on Nov 26, 2019 22:35:18 GMT
This didn't take too long to put together once I'd sorted out the delimiters. I think when I go to import the next set, I'll change the hyphens to semi-colons to avoid the issues that cropped up with Kirkby-in-Ashfield and other hyphenated names. | Pub name | League | Address | Date visited |
|---|
| Nottinghamshire | | The Newshouse | League | 123 Canal St, Nottingham, NG1 7HB 0115 950 2419 | Regular | | The White Lion | Non-league | 352 Tamworth Rd, Sawley, Long Eaton, Nottingham, NG10 3AT | 2019/02 | | Duke of Wellington | Non-league | Church Street, Kirkby-in-Ashfield, NG17 8QG | 2019/11 | | Hop In Micro Bar | Non-league | 21A Wilson Street, Pinxton, NG16 6LS | 2020/01 | | Rum Runner | Removed | Wharf Road, Retford, Notts DN22 6EN |
| | Navigation Inn | Removed | 6 Wilford St, Nottingham, NG2 1AA |
| | The Vat & Fiddle | Removed | Queen's Bridge Road Nottingham, NG2 1NB |
| | Plough | Removed | 17 St Peter’s Street, Radford, Nottingham NG7 3EN |
| | The White Lion | Removed | Town Street, Bramcote, Nottingham NG9 3HH 0115 925 7841 |
| | The Steam Boat Inn | Removed | Trent Lock, Long Lane, Long Eaton Nottingham NG10 2FY 0115 972 6300 |
| | The Plough | Removed | Selby Lane, Keyworth, Nottingham NG12 5AH |
| | Horse & Plough | Removed | 25 Long Acre, Bingham, Nottingham NG13 8AF |
| | The Grove | Closed | 273 Castle Boulevard, Lenton, Nottingham NG7 1HA |
| | Oscar's Lounge & Rest | Closed | Main Street, Calverton, Nottingham NG14 6FE |
| | Derbyshire | | Talbot Taphouse | Non-league | 1 Butterfly Hill, Ripley, Derbys DE5 3LT |
| The Black Horse Inn | Non-league | Hulland Ward, Ashbourne, Derbyshire, DE6 3EE May 2021
|
| | Black Horse | Non-league | 17 Burton Road, Coton-in-the-Elms, Swadlincote, Derbyshire DE12 8HJ |
| | The Lathkil | Non-league | Over Haddon, Nr Bakewell, Derbys DE45 1JE |
| | The Clock Inn | Non-league | 107 Market Street South Normanton, Alfreton, Derbyshire DE55 2AA |
| | The Corner Pin | Non-league | Station Road Morton, Derbyshire DE55 6HN 01773 872 308 |
| | The Cross Keys | Non-league | 35 Market Place, Belper, Derbyshire DE56 1FZ |
| | The Loft | Non-league | Fox Lane Farm, Fox Ln Holmesfield, Dronfield, Derbyshire S18 7WG (Holiday cottage) |
| | The Old Nags Head | Non-league | Grindsbrook Booth Edale, Hope Valley, Derbyshire S33 7ZD |
| | Lennons Snooker Club | Non-league | 16A Stephenson Place, Chesterfield, Derbys S40 1XL |
| | The Cheshire Cheese | Non-league | 37-39 High Street, Buxton, Derbyshire SK17 6HA |
| | The Star | Non-league | Main St, Taddington, Buxton, Derbyshire SK17 9TU (Holiday accom) |
| | Thorntree Inn | Removed | 161 Church Street, Waingroves, Ripley, Derbyshire DE5 9TE |
| | Leicestershire | | Anchor Inn | Non-league | 63 Church St Burbage, Hinckley, Leicestershire LE10 2DA |
| | Grainstore Brewery Tap | Non-league | Station Approach, Oakham, Rutland & Leics LE15 6RE |
| | The Olive Branch | Non-league | Main St, Clipsham, Rutland LE15 7SH (table in Barn) |
| | The Old Pheasant Hotel | Non-league | 15 Main Road Glaston, Oakham, Rutland LE15 9BP |
| | Chandlers Arms | Non-league | Fenny Lane, Shearsby, Leics LE17 6PL |
| | The Swan and Rushes | Removed | 19 Infirmary Square Leicester LE1 5WR 0116 233 9167 |
| | Cow & Plough | Removed | Stoughton Grange Farm, Gartree Rd, Oadby, Leicestershire LE2 2FB |
| | The Belvoir Brewery | Removed | Station Rd Crown Park, Old Dalby, Melton Mowbray, Leicestershire LE14 3NQ 01664 823 455 |
| | The Falcon | Removed | 7 High Street East, Oakham, Rutland LE15 9PY |
|
|
|
|
|
Post by Deleted on Nov 27, 2019 11:44:27 GMT
Well, that's gone really well, it gets the thumbs up from me and I see you've done the London one as well. Pretty confident that I'll be able to do my own conversions (Word to Excel) as nothing has beaten me so far !
One thing I would like to keep on is an archive of the deleted venues, as this provides a quick reference check opportunity for possible new findings.
I expect Sav will organise a routine for how we can move all the information over, and suggest that if you are willing, we divide the country up between us thus:- North of the Thames - Joe Foxon South of the Thames - Tommo Control room plus East Anglia - Sav !!!
What do you guys reckon ?
|
|
|
|
Post by Chris_Sav on Nov 27, 2019 12:52:08 GMT
Obviously I will need to do the moderation work in copying the tables to a post belonging to whomever is going to be the data controller.
I think you may be approaching things back to front, using tablify to post excel tables will not carry the formatting. Copying the forum tables to Excel will. You can add rows to a tablify table by highlighting and right clicking
It may be better to do the conversion to nice neat tables and then maintain the master list on the forum. Take a backup copy to your PC.
Alternative is to add rows to the tablify table and copy in the data.
Up to you guys, just suggestions.
The other link is spotting changes for the map to be kept up to date, which at present comes to me though the process is simple.
|
|
|
|
Post by joefoxon on Nov 27, 2019 13:57:08 GMT
I think you may be approaching things back to front, using tablify to post excel tables will not carry the formatting. Copying the forum tables to Excel will. You can add rows to a tablify table by highlighting and right clicking The reason I've started doing it this way, is because the text lists already exist, and I'm just converting them to the easier to read format. There's nothing stopping anyone from collating all the different regional tables into a master database though, should they wish. Well, that's gone really well, it gets the thumbs up from me and I see you've done the London one as well. Pretty confident that I'll be able to do my own conversions (Word to Excel) as nothing has beaten me so far !
One thing I would like to keep on is an archive of the deleted venues, as this provides a quick reference check opportunity for possible new findings.
The conversions are simple enough to do, once you manage to get each list to be formatted consistently. Even if any do get missed it's simple to correct, it may even be easier to do it after tablifying, as moving part of a cell's text into another cell in Excel is fiddly. I did leave out the deleted venues to keep the data relevant, but I don't see why we couldn't have another table beneath with removed venues, so that they're not mixed in with the still existing ones. |
|
|
|
Post by Chris_Sav on Nov 27, 2019 14:11:09 GMT
Agree on deleted venues, it's all part of the history, but should be separated
|
|
|
|
Post by Deleted on Nov 27, 2019 14:40:08 GMT
A quick check on all the files involved (responsibilities are subject to negotiation !) I suggest they are tackled in this order and make it 55 in toto.
| NORTH OF THAMES (Joe) |
| SOUTH OF THAMES (Tommo) |
| EAST OF ENGLAND (Sav) |
|---|
| 1 | E.Midlands (incl. Nottingham) | 1 | Sussex (incl. 10 leagues) | 1 | Suffolk | | 2 | London | 2 | Surrey | 2 | Norfolk | | 3 | Yorkshire (N,W and E) | 3 | Hampshire | 3 | Lincolnshire | | 4 | South Yorks (Incl. Sheffield) | 4 | Berkshire | 4 | Cambs (incl Newmarket/Ely) | | 5 | Oxfordshire (incl. 4 leagues) | 5 | Kent (incl. 4 leagues)
|
|
| | 6 | Nthants (incl.Wellingborough) | 6 | Channel Islands |
|
| | 7 | Buckinghamshire |
|
|
|
|
| plus MINOR COUNTIES: |
| plus MINOR COUNTIES: |
| plus MINOR COUNTIES: | | 1 | Herts/Beds | 1 | Cornwall | 1 | Essex | | 2 | Gloucs | 2 | Devon |
|
| | 3 | Wales | 3 | Dorset |
|
| | 4 | W.Midlands (incl.Birmingham) | 4 | Somerset/Avon |
|
| | 5 | Cheshire and Merseyside | 5 | Wiltshire |
|
| | 6 | Lancashire (incl.Manchester) | 6 | Isle of Wight |
|
| | 7 | North-East (incl.Newcastle) |
|
|
|
| | 8 | Cumbria |
|
|
|
| | 9 | Scotland |
|
|
|
| | 10 | Northern Ireland |
|
|
|
|
|
|
|
|
Post by joefoxon on Nov 27, 2019 14:55:55 GMT
Wow, that's a lot of ground to cover!
I don't know if anything can be done about this, but the BB code for the tables defaults to a very messy way of writing it. It will make this much easier to do if it can remain in the format it's written, otherwise I'll have to keep the BB code saved elsewhere and edit it externally.
Sav, is it ok to start off the process of tidying this all up then, and we can begin getting the lists up to date. Maybe we could also be able to edit the tables map as well, so we can keep that up to date with our findings?
|
|
|
|
Post by Chris_Sav on Nov 28, 2019 12:50:21 GMT
Any of the tables you want access to just let me know and I'll copy the bbcode into it. I'm not sure you realise you can manipulate the tables within a post edit by right clicking and selecting row or column, no need to manually edit bbcode ('orrible task)
|
|
|
|
Post by Deleted on Nov 28, 2019 13:13:22 GMT
So, I'm a bit pushed for available time on the Forum (until the election is over - preparing massive spreadsheets that I can stay up with all night on the 12th  ) but I don't mind making a start with, say, Surrey. Do you want to prepare the thread for me or shall I do it ? |
|
|
|
Post by Chris_Sav on Nov 28, 2019 13:19:47 GMT
Just add a post where you want the table to be, it will need to be under your name for you to edit it.
I'll then copy the bbcode from the old table into that post.
If I do not spot it then PM me
|
|
|
|
Post by joefoxon on Nov 28, 2019 13:38:12 GMT
Any of the tables you want access to just let me know and I'll copy the bbcode into it. I'm not sure you realise you can manipulate the tables within a post edit by right clicking and selecting row or column, no need to manually edit bbcode ('orrible task) You can do that, although the new row is in the default colours, not the custom colours of the table. BB code isn't that much of a pain if it's in a tidy format, but I can keep copies on my laptop, and just edit them when needed, no worries  |
|
|
|
Post by Deleted on Nov 28, 2019 18:17:02 GMT
Any of the tables you want access to just let me know and I'll copy the bbcode into it. I'm not sure you realise you can manipulate the tables within a post edit by right clicking and selecting row or column, no need to manually edit bbcode ('orrible task) It does actually make it a lot easier than before: on the control list I had to add the words "4 leagues" in the Kent cell, and it took the edit straight away (within the box) without me having to wade through the http.
Have added a file for "tables in Surrey" btw.
|
|
|
|
Post by joefoxon on Jan 12, 2020 12:04:11 GMT
Added a new venue to this list. Hop In Micro Bar in Pinxton now have a table. |
|
|
|
Post by Deleted on Nov 2, 2020 21:47:51 GMT
It seems that Leicestershire had a ten-year presence (1983 - 1993) as a participating county at National level, as these AEBBA minutes from the early 1980's suggest: Further evidence of the existence of the Hinckley League........ Barwell Sports Club B were Cup winners, beating their A team according to this press clipping: |
|
|
|
Post by Deleted on Nov 20, 2020 16:30:56 GMT
More recent stuff, from when the Swan & Rushes had a table: |
|
|
|
Post by Chris_Sav on Apr 5, 2021 18:54:29 GMT
It seems that Leicestershire had a ten-year presence (1983 - 1993) as a participating county at National level, as these AEBBA minutes from the early 1980's suggest: Further evidence of the existence of the Hinckley League........ Barwell Sports Club B were Cup winners, beating their A team according to this press clipping: Back on Fleabay at the moment |
|
) but I don't mind making a start with, say, Surrey. Do you want to prepare the thread for me or shall I do it ?
