redshoes.co.nz

Kiwi living in Bermuda. Homemade charcuterie, foraging, wine, cats and island life.

Author: Kelly (page 1 of 7)

Drinks of Frasier: Part 2 – “Sherry, Niles?” – All about the Crane brothers’ favourite tipple.

I am currently away from home and don’t have the equipment, glassware or ingredients to make cocktails, so I thought this would be a good opportunity to write an article on one of the most important tipples in the Frasier series – Sherry!

Where it all began

The first mention of sherry is in Season 1, episode 3, “Dinner at Eight” – Niles meets Daphne for the second time, and Frasier offers him a sherry from the decanter. This is the first instance of the phrase “Sherry, Niles?”

“Sherry, Niles?”

Although the actual genesis of the sherry meme is revealed to us in Season 11 Episode 22 “Crock Tales” when, with their comedy 1993 wigs on, there is a re-enactment of the second time Niles meets Daphne – Frasier asks Niles if he’d like a Scotch and Niles says “Actually no, I’m in a sherry mood tonight”

“Sherry, Niles?” (In a slightly darker tone)

During this visit Daphne forgets his name and calls him “Miles”.

This is interesting since he meets Daphne officially for the first time ever at the start of S1 E3, then when he comes around the second time in the episode, she shakes Niles’ hand when leaving and says “It was nice seeing you again Dr Crane” which suggests that it is indeed the second time they have met, also why would she switch from calling him Dr. Crane to calling him by his first name and then back again?. Seems spurious to me, but maybe I am being a little pedantic.

(On second thoughts given that scene in Crock Tales is the also supposed to be the first time Roz gets invited to Frasier’s apartment, but in S1E06 The Crucible, Marty talks about meeting Roz for the first time at the infamous Paxton Painting Party… well, perhaps we shouldn’t think too much about Crock Tales…)

Don’t even get me started on the hair…

Sherry as portrayed on the show

Despite the countless times the brothers are shown with a glass of sherry in their hands, there are very few references to the specific language of sherry on the show. In fact, there are only two:

S10 ep22 – Fathers and Sons – Leland Barton (Hester Cranes research partner and close friend) is in Seattle and visiting the brothers in Frasier’s apartment where he reveals he is also a lover of sherry, and Frasier offers him a glass.

Like Father like Son

Leland: This sherry is exquisite.

Frasier: Oh, thank you. It’s an Andalusian amontillado I’m rather fond of.

Leland: A connoisseur. I’m very surprised. Most Americans think that sherry is just for cooking.

S11 Ep21 – Detour – Frasier has made an appointment to meet a stripper at his apartment, for Martin’s bachelor party, however he is unable to make it and sends Niles in his place. Martin comes home early and runs into an already nervous Niles in the kitchen.

Martin: Hey, Niles!

Niles: [nervous] Oh!

Martin: What’s up?

Niles: Frasier is going to split a case of oloroso with me because we both like oloroso, but he’s not here, so I’ll stop bothering you. Nice chatting.

Interestingly the references don’t come till much later in the series, I guess one of the writers finally decided it was a good idea to finally pick up a book about it 😊

So as you can see the brothers have mentioned they are keen on oloroso and amontillado, which are browner in colour… however you may have noticed that the wine in the glasses served on the show is always yellow [picture]. This is the colour of a fino or manzanilla, not an oxidised sherry. Since the writers of Frasier didn’t expect an audience educated in sherry, they likely chose whatever was around that looked the most aesthetically pleasing, which is basically white wine.

“Andalusian Amontillado” may also seem redundant since is a protected term in Spain (and recognised by the EU) and all sherry is by definition Andalusian. However, it is only recently that winemakers in Australia and Canada started using the term ‘Apera’ when referring to local wines made in the sherry style, and wines made in the USA are still called ‘sherry’ so we can assume he was differentiating between these and authentic Spanish sherry.

We also have the misconception that sherry can be left out in a decanter. To start with, if the crane brothers were actually drinking fino or manzanilla, it should be refrigerated after opening and even then, only for a few days, like a bottle of white wine. Oxidised or sweet sherries can last longer, but even still only for up to 2-4 weeks. I once found a faux crystal decanter in a charity shop, along with some fancy glasses and decided to set up a ‘sherry station’ only to be disappointed at the state of the wine a few weeks later. Then again, I don’t imagine a bottle lasts too long in the Crane household.

Finally, this wouldn’t be a proper geek post without discussing glassware. In the first season we see the brothers drinking from long stemmed cordial glasses

“Sherry, Niles?” From a long stemmed glass…

However at the beginning of the 3rd season they switch to the more short stem fluted sherry /port glasses.

By Season four short stemmed glasses were all the rage.

I would much prefer the cordial glasses for tasting purposes but I can see why they switched. It’s hard to get a good shot of the sherry decanter, but here is one from the 3rd season showing a rounded decanter with a narrow neck and a blue stopper.

That bottle we don’t like to talk about

So, despite there being very few references to the specifics of the sherry on the show, there is one time that a bottle is actually shown. In S6 Ep9 – Roz a Loan.

Harvey’s Bristol Cream? Surely not!

It’s a bottle of Harvey’s Bristol Cream sherry. Now you can buy a litre of Bristol cream for around $13 in 2018… that might give you an idea of it’s quality. It is very unlikely that the crane brothers would go anywhere near the stuff (Niles even more so than Frasier), especially when you take into consideration their attitude towards wine. I suspect it was the only bottle the props department had lying around, and they assumed no-one would know, or care, what it was anyway.

Why sherry?

There were a few benefits to using sherry on the show as opposed to wine – it eliminated the need to have a wine bottle hanging around – Instead we have an off screen decanter. The smaller glasses, especially the fluted ones in the later season are less intrusive – all of these things cut down on continuity issues, since it is less noticeable when the liquid levels change (Ever wonder why Martin’s beer is always in a can?), and they are small glasses designed to be sipped from slowly.

Since it had a reputation of being enjoyed by older ladies it also helped to reinforce the stereotype of the Crane brothers being pompous and stuffy, as well as being less interested in Martin’s traditional ‘manly’ pursuits – as Niles said in S4 Ep1 when Martin was talking about his friend “Jim” who drinks Jim Beam. “We’re sherry drinkers, Dad. Think about it!”. It is a drink that few people have knowledge about, and it is difficult to get in bars, which adds to the exclusivity. Not to mention that the show wouldn’t be the same without the occasional “Sherry, Niles?”.

Want to take your sherry game to Frasierian heights, but don’t know where to start?

Like vermouth before the craft cocktail revolution, sherry’s popularity has really suffered since the 1970’s. As I mentioned previously when most people think of sherry they think of cream sherry… that dusty bottle of sweet, mass produced, low quality strong wine that has been sat open at the back of the cocktail cabinet for years. Don’t get me wrong, not all sweet sherries are bad – but the proliferation of cheap cream sherry has certainly damaged it’s reputation.

Despite Frasier’s best efforts it didn’t manage to trigger a sherry revival. Maybe the brothers were ahead of their time as, here in 2018, a revival is coming, sherry cocktails are already becoming more popular in fashionable cocktail bars for example, and any restaurant that you might find the Brothers Crane dining at – with an extensive wine list – will have some sherry by the glass options for you to mull with after dinner (they are generally good value too).

If you are lucky enough to have one in your city, try seeking out a tapas bar with a substantial sherry by the glass list and try a few for yourself alongside some traditional small plates, I promise you will be converted! If you have a good independent wine shop in your city, you local wine expert will likely wax lyrical about sherry, lamenting that it is not more popular than it is, and will be happy to suggest the perfect bottle to get you started.

References/Further reading

  1. Sherry Notes Blog: https://www.sherrynotes.com/
  2. “What sherry does Frasier drink” https://andalusiantraveller.com/2017/05/09/what-sherry-does-frasier-drink/
  3. “What kind of sherry did Frasier drink” https://worldofbooze.wordpress.com/2010/11/03/what-kind-of-sherry-did-frazier-drink/

Drinks of Frasier: Part 1 – Stoli Gibson on the rocks with not two, not four, but three pearl onions.

Season 1, episode 3 – Dinner at Eight.

Martin, Frasier and Niles are having dinner at The Timber Mill:

Waitress: Hi, can I get you guys something from the bar?
Frasier: [weary] Oh dear God, yes.
Niles: I’ll have a Stoli Gibson on the rocks, with three pearl
onions.
Frasier: [firmly] If you bring him two, if you bring him four – he’ll
send it back.
Waitress: And for you?
Frasier: The same.

You can see the cocktail when Frasier gets his drink in this scene:

The Crane boys receiving their drinks

The Crane boys receiving their drinks

Recipe: Stoli Gibson with Three Pearl Onions

2 1/2 oz Stolichnaya vodka

1/2 oz dry vermouth

Three pearl onions to garnish

Shake or stir the vodka and vermouth with ice, and strain into an ice filled rocks glass. Garnish with three pearl
onions on a skewer.

Verdict
It’s kind of terrible. I have no problem with strong cocktails, and Stoli is actually my go-to for vodka based drinks. But it doesn’t work here – there is a bitterness that the vermouth and pearl onion juice doesn’t go anywhere near covering. We’ve had evidence that Niles is a martini man, but I can’t imagine him enjoying this. Even less when you consider the way it was probably mixed at The Timber Mill…

"Drinks of Frasier" part 1 - Stoli Gibson on the rocks with three pearl onions

“Drinks of Frasier” part 1 – Stoli Gibson on the rocks with three pearl onions.  Sorry Niles, this one isn’t for me.

Leaf macro

Taken largely blind with some cheap eBay macro tubes in Mum’s garden. Turned out interesting, certainly $12 worth of interesting anyway.6730165373_60788071f7_o

Exporting Access tables to Excel

There are pre-built Access functions to export data to Excel, such as the DoCmd.TransferSpreadsheet or DoCmd.OutputTo method, but anything but the most basic reports will require you to customise the Excel output more than these functions will allow. This code shows you how to create an instance of Excel and export the contents of the table into a new Excel workbook.  You can then format and manipulate the contents within Excel.

Public Sub ExportTableToExcel(strTableName As String)
     Dim oApp     As Object
     Dim xlSH     As Object
     Dim xlWB     As Object
     Dim rs       As Recordset
     Dim i        As Long

     'Check to see if Excel is open and get a handle to the Application
     On Error Resume Next
     Set oApp = GetObject(, "Excel.Application")
     On Error GoTo errorHandler
     'If oApp has not been set then there is no instance of Excel open.
     'Late binding the Excel application prevents issues with
     'compatibility as users may have different versions of Excel installed.
     If oApp Is Nothing Then Set oApp = CreateObject("Excel.Application")

     Set xlWB = oApp.Workbooks.Add
     Set xlSH = xlWB.Sheets(1)
 
     Set rs = CurrentDb.TableDefs(strTableName).OpenRecordset
 
    'Add in the header field names, the CopyFromRecordset command only
    'copies the data.
     For i = 0 To rs.Fields.Count - 1
          xlSH.Cells(1, i + 1).Value = rs.Fields(i).Name
     Next i

    'Paste in the data.
    xlSH.Range("A2").CopyFromRecordset rs

    'Format the worksheet
    With xlSH
        .Rows(1).Cells.Font.Bold = True
        .Columns.ColumnWidth = 100
        .Columns.AutoFit
        .Rows.AutoFit
    End With

exitRoutine:
    On Error Resume Next
    '-----------------------------------------------------------------------
    'When the Excel.Application object is created it is hidden by default.
    'You need to make sure it is set to visible as if there are errors or the
    'User runs the macro a number of times, they can end up with multiple hidden
    'Instances of Excel running in the background, which will only show up when
    'They are force quit.
    '------------------------------------------------------------------------
    oApp.Visible = True

    'Clear object variables and make sure recordset is closed
    rs.Close
    Set rs = Nothing
    Set xlSH = Nothing
    Set xlWB = Nothing
    Set oApp = Nothing
Exit Sub
errorHandler:
    MsgBox ("An error occured: " & Err.Number & " " + Err.Description), vbCritical, "Error"
    Err.Clear
    Resume exitRoutine
    Resume
End Sub

Download Sample Access database with code to export tables to Excel

Excel VBA Snake Game

Another quick one…

Excel snake game

Excel snake game

 Download Excel Snake

The Moon

Gibbous Moon picture, Sydney, 19-06-2011

A car alarm started going off at 5am this morning, forcing me out of bed… on the upside I had a chance to take pictures of the nearly full moon.  Click for full size.

Excel VBA Popup Calendar

Example of the popup calendar when used in a spreadsheet.
Example of the popup calendar when used inline on a spreadsheet.

The VBA editor does not have a calendar control available to it by default – however it is possible to use the MS Access calendar control.  This tutorial is on how to set up a calendar control that can be accessed via a UserForm, or inline from a spreadsheet.

Download the following for an example of how to use the control either to populate a cell on a worksheet, or a control on a form.

 

1. Setting up a reference to the MSCAL.ocx calendar control.

You will need to set up a reference to the MSCAL.ocx file.  Open the “References” dialog (Tools > References in the VBA editor).

Click “Browse” and select the MSCAL.OCX file (this should be located in the root directory of your Microsoft Office installation.

Click “Open”.  This will now appear in the “Available References” window as Microsoft Calendar Control xx.x.  Make sure the checkbox to the left is enabled.

 

2. Copy the Userform and Class modules to the workbook.

Copy the “PopupCalendar” class module and the “frmPopupCalendar” module into the target workbook (you can do this by dragging them to the target book in the VBA editor).

 

3. Add subroutines

Add the following function into a module – this is a will display the form, and return a date object.

Function showCalendar() As Date
Dim pcPopup As PopupCalendar
Dim dtDate As Date

‘create a new PopupCalendar object
Set pcPopup = New PopupCalendar
‘sets the date as today
pcPopup.setDateToday

‘This will show the PopupCalendar as a modal form, meaning that
‘execution of the function will not continue until the form is closed.
pcPopup.Show

‘As the form will now be closed, we can access the date that was selected
dtDate = pcPopup.calDate
Set pcPopup = Nothing

‘return the date
showCalendar = dtDate
End Function

4. Add Controls and Event Handlers

Add a Command Button control to the spreadsheet (use the Control Toolbox, accessed via the ‘View > Toolbars > Control Toolbox’ menu item.

Right-click on the control and select the “View Code” popup menu item.


Example of a worksheet with a Command Button control added

This will take you to the code for the Click event of the command button object.  Enter the following code:

Private Sub CommandButton1_Click()
‘Make sure the text before the underscore is the same as the name of your Command Button otherwise the event will not fire.

Dim dtDate As Date
‘Calls the showCalendar function we added before
dtDate = showCalendar()

If dtDate <> 0 Then
‘Note this will be the range that is populated with the date
‘The format statement is used to format the date returned (default is mm/dd/yyyy)
Me.Range(“B6”).Text = Format(dtDate, “dd/mm/yyyy”)
Else:
‘As will this
Me.Range(“B6”).Text = vbNullString
End If
End Sub

 

That’s it.  You can download the example Excel file here: PopupCalendar.xls

Excel Game of Life

Made this over lunchtime yesterday… it’s not pretty, but just seemed to be an obvious idea.  Only tested in Excel 2003.

Download Life.xls

« Older posts

© 2019 redshoes.co.nz

Theme by Anders NorenUp ↑