|
|
Post by Deleted on Nov 2, 2016 22:10:12 GMT
Keeping a spreadsheet is not geeky. Putting the information in a text file and writing a 1017-line Perl program to process it and produce summaries of various aspects of the data: that's geeky.
|
|
13 posts
|
Post by mattw on Nov 3, 2016 0:20:07 GMT
I have a spreadsheet too, I don't keep price on it though, that would be too scary!  The theatres I have been to most are the Birmingham Hippodrome, then the Birmingham Rep and then the Birmingham Alex. In London it's the Savoy, the Adelphi, the Union, the Garrick and the Geilgud |
|
219 posts
|
Post by PalelyLaura on Nov 3, 2016 16:30:41 GMT
I have lists of all the shows I've seen in London since I moved here, but not a spreadsheet: feeling rather inspired to make one now!
|
|
117 posts
|
Post by ldm2016 on Nov 3, 2016 16:56:08 GMT
I have lists of all the shows I've seen in London since I moved here, but not a spreadsheet: feeling rather inspired to make one now! Yep, me too and going to start one at the weekend! |
|
4,029 posts
|
Post by Dawnstar on Nov 3, 2016 19:05:20 GMT
How could I forget the Garrick? 22 visits just to Zorro!
Does anyone better at spreadsheets than me know if you can import space delimated data where only some of the spaces are used as column breaks? Trying to work out if there's a way to import my word doc more quickly than copying & pasting a line at a time.
|
|
|
|
Post by Deleted on Nov 3, 2016 21:41:42 GMT
Does anyone better at spreadsheets than me know if you can import space delimated data where only some of the spaces are used as column breaks? Tricky. You could try replacing each run of two or more spaces with a tab, but you need something that can do a search and replace for two or more spaces. |
|
|
|
Post by Deleted on Nov 4, 2016 8:29:26 GMT
I realised I'd neglected my spread sheet for several months, and dutifully updated last night. I just put date, show, venue I used to put who with but neglected it for too long!
|
|
4,029 posts
|
Post by Dawnstar on Nov 4, 2016 8:29:36 GMT
Does anyone better at spreadsheets than me know if you can import space delimated data where only some of the spaces are used as column breaks? Tricky. You could try replacing each run of two or more spaces with a tab, but you need something that can do a search and replace for two or more spaces. Sounds like it'll be copying 1 line at a time then! |
|
679 posts
|
Post by westendcub on Nov 4, 2016 12:05:26 GMT
Over my theater lifetime then this goes to The Phoenix theater due to the vast amount of times I was there for 'Blood Brothers' even since that departed I have seen 'Once' (twice), 'Bend it like Beckham' (twice) and 'Guys and Dolls', whilst I am yet to book a ticket I plan on seeing 'The Girls' so it is for sure the place I can say I have spent many hours in!
|
|
352 posts
|
Post by Raven on Nov 6, 2016 11:34:54 GMT
As I don't live very close to London my theatre visits are not nearly as impressive as some of you on here. Having seen Les Mis the most (four times) I have to say that I have spent the most time in the Queens Theatre.
Also, I love how quite a few members keep a spreadsheet record of their shows. I keep mine listed in a Word ducument with the dates of each performance.
|
|
1,319 posts
|
Post by londonmzfitz on Nov 6, 2016 12:23:25 GMT
That is such a geeky think to do and that is to keep a spreadsheet right? I must be one of these geeks too, I even shade the boxes in if the show is coming up. Eek I shade show I've attended so the upcoming shows stand out. |
|
|
|
Post by Deleted on Nov 7, 2016 23:00:01 GMT
As I am significantly bored, I decided to actually work out what my Top 10 most-visited theatres are in London. Actually quite nice to look over the shows and venues I have been too... all other venues are 2 shows or less but there is a lot of them so couldn't put them all in. But I also realise how much my theatre going has expanded over the last year. I have visited a lot more out of the way/fringe venues this year or smaller venues and seen some stellar shows as well as amazing West End shows too! I definitely hope I catch more before the year is out, and make next year an amazing one! • Apollo Victoria (15) - Wicked • Adelphi (14) - The Bodyguard, Made in Dagenham & Kinky Boots • Savoy (6) - Guys & Dolls, Gypsy & Funny Girl • Kings Cross (5) - In the Heights • Theatre Royal, Drury Lane (5) - Shrek & Charlie and the Chocolate Factory • The London Palladium (5) - The Wizard of Oz, I Can't Sing! & Cats • Apollo (4) - The Curious Incident of The Dog in The Night-time, Let The Right One In, My Night With Reg & The Go-Between • Piccadilly (4) - Ghost, Viva Forever! & Dirty Dancing • Aldwych (3) - Stephen Ward & Beautiful • Dominion (3) - Elf & The Bodyguard |
|
|
|
Post by Deleted on Nov 8, 2016 0:43:11 GMT
The Palace Theatre because i've seen Les Miz way too many times since 1986. Drury Lane because I was seeing the Theatre Manager there.... but thats a whole different story  Regionally, it would be the Swan Theatre in Worcester, where ive done many shows back in the day, when I used to live there. |
|
