Software that makes placemats
Re: Software that makes placemats
As the 1975 horizontal was ending, Tom was calculating the damage. Some people had brought Port, most hadn’t, and there was the cost of the food. Tom looked up from his scribbling and asked that, to help do this, there be an accounting page.
Sure. But what should it be?
Sure. But what should it be?
Re: Software that makes placemats
Something like this perhaps.jdaw1 wrote:As the 1975 horizontal was ending, Tom was calculating the damage. Some people had brought Port, most hadn’t, and there was the cost of the food. Tom looked up from his scribbling and asked that, to help do this, there be an accounting page.
Sure. But what should it be?
The bottles contribution line is completed at the start of the evening, a per person average computed (in this case 41.50), and this is also completed in the bottle cost line. Once the bill arrives, the meal cost per person is completed. Finally the calculation is made column by column for who owes/is owed.
- uncle tom
- Quinta do Vesuvio 1994
- Posts: 3495
- Joined: 23:43 Wed 20 Jun 2007
- Location: Near Saffron Walden, England
Re: Software that makes placemats
Something like that would be very helpful - thankyou..
I may be drunk, Miss, but in the morning I shall be sober and you will still be ugly - W.S. Churchill
Re: Software that makes placemats

But the Accounting page has only a few fields per name, so it seems more natural to have one name per row rather than one name per column, which is the transpose of Mike’s spreadsheet. Objections?
Draft parameters:
Code: Select all
/AccountingNumCopies 1 def
/AccountingTopText (Accounting) def
/AccountingColumnTitles [ % Array of even length, alternately header for group of columns, and array of those columns' headers
[
(Bestowals) [ (Wine) ]
(Costs) [ (Food &c) (Wines) ]
(Settlement) [ (Owes) (Is owed) [(P) /quoteright {-0.08 Kern} (d?)] ]
] def
/AccountingColumnRelativeWidths [ 4 4 4 4 4 1 ] def
/AccountingExtraRows [ () (Total) () ] def
AccountingNumCopies: Inserted following Flash’s suggestion three posts below.
AccountingTopText: must be a parameter to allow non-English possibilities.
AccountingColumnTitles: In the instance in which a group of columns has only one column, the group’s column title should be short: hence “Bestowals” rather than “Contributions”. Do suggest better. Also, should there be a few columns with blank titles? If so, within the groups already present, or in a new blank group?
AccountingColumnRelativeWidths: allows “P’d?” column to ne narrow, holding no more than a tick.
AccountingExtraRows: extra rows under those of the names, to cope with extra people, sub-calculations, changes of mind, &c.
Is this wanted? Is this what is wanted?
Re: Software that makes placemats
I would suggest it should not be. Several reasons:jdaw1 wrote:As the 1975 horizontal was ending, Tom was calculating the damage. Some people had brought Port, most hadn’t, and there was the cost of the food. Tom looked up from his scribbling and asked that, to help do this, there be an accounting page.
Sure. But what should it be?
- During a tasting is not the best time to do the calculation (note the accuracy of voting summations).
- This is only really relevant for larger tastings where either a large amount of wine comes from a subset of the individuals, or there is significant disparity due to some bringing much older wines. In previous tastings (at least some of those I have organised) some people have been very generous in providing their (significant) contribution either as "if this covers me, I don't want anything more for it" or at very low cost. Such gentlemanly behaviour is appreciated and should not be discouraged (and yes I think group analysis might do so).
- Given such variations, a spreadsheet is more reliable.
- During a tasting is not the best time to do the calculation (I know, I said it already, but it's the most important reason).
Re: Software that makes placemats
Translated into post-tasting speak:PhilW wrote:- During a tasting is not the best time to do the calculation (I know, I said it already, but it's the most important reason).
- doing the calcing-thing not now right. Hey is that bottle empty?
I have no objections, but likely wouldn't use the function. If there are remunerations to be made, I calculate and distribute them prior to the event (and bring a copy with me).
Glenn Elliott
Re: Software that makes placemats
I'm not sure it's such a bad thing. I agree this is only really relevant for the bigger tastings with an imbalance in bottle provision - the sheet can be an optional, like many others in the software. It is true that attempting the calculations during, or at the end of the tasting could lead to error, however that is not caused by having a sheet available. It happens because 13 or 14 people are standing around with cash/cards in their hand trying to be helpful and make a fair contribution. Sheet or no sheet, Tom found himself needing to undertake difficult maths at a less that ideal time - the sheet could only have helped I believe! And there is nothing to stop gentlemanly contribution continuing, which is always appreciatedPhilW wrote:I would suggest it should not be. Several reasons:jdaw1 wrote:As the 1975 horizontal was ending, Tom was calculating the damage. Some people had brought Port, most hadn’t, and there was the cost of the food. Tom looked up from his scribbling and asked that, to help do this, there be an accounting page.
Sure. But what should it be?
- During a tasting is not the best time to do the calculation (note the accuracy of voting summations).
- This is only really relevant for larger tastings where either a large amount of wine comes from a subset of the individuals, or there is significant disparity due to some bringing much older wines. In previous tastings (at least some of those I have organised) some people have been very generous in providing their (significant) contribution either as "if this covers me, I don't want anything more for it" or at very low cost. Such gentlemanly behaviour is appreciated and should not be discouraged (and yes I think group analysis might do so).
- Given such variations, a spreadsheet is more reliable.
- During a tasting is not the best time to do the calculation (I know, I said it already, but it's the most important reason).

Re: Software that makes placemats
flash_uk wrote:the sheet can be an optional, like many others in the software.
There would also have to be administrative parameters such as PageOrderingAccounting, and perhaps others.jdaw1, in editing his post four above, wrote:……Code: Select all
/AccountingNumCopies 1 def
AccountingNumCopies: Inserted following Flash’s suggestion three posts below.
- uncle tom
- Quinta do Vesuvio 1994
- Posts: 3495
- Joined: 23:43 Wed 20 Jun 2007
- Location: Near Saffron Walden, England
Re: Software that makes placemats
If one has all the numbers to hand in advance, then a computation at a sober moment is preferable, but that's only possible at a minority of events - the food bill is usually variable, and late additions and deletions to the wine list are not uncommon.
A simple computation sheet would therefore assist..
A simple computation sheet would therefore assist..
I may be drunk, Miss, but in the morning I shall be sober and you will still be ugly - W.S. Churchill
Re: Software that makes placemats
Experience tells me that shared costs should be calculated, notified and settled in advance of large structured tastings. If people then decide to bring extras or not show up that is their choice. Ideally the bottles should also be collected in advance to eliminate the problem of late withdrawals or no shows on the day.
"The first duty of Port is to be red"
Ernest H. Cockburn
Ernest H. Cockburn
Re: Software that makes placemats
PhilW wrote:… not the best time to do the calculation …
… a spreadsheet is more reliable…
I agree with both of you.DRT wrote:… should …
flash_uk wrote:… optional…
… Sheet or no sheet, Tom found himself needing to undertake difficult maths at a less that ideal time - the sheet could only have helped …
I agree that this is alien to Planet Should, and really belongs on Asteroid Helpful. Which is a yes, partly grudging. Would it be sensible for the default to be that it appears if the length of Names is ≥7?uncle tom wrote:If one has all the numbers to hand in advance, then a computation at a sober moment is preferable, but that's only possible at a minority of events - the food bill is usually variable, and late additions and deletions to the wine list are not uncommon.
A simple computation sheet would therefore assist..
Re: Software that makes placemats
I don't think what appears to have happened to Tom this time should be encouraged.
"The first duty of Port is to be red"
Ernest H. Cockburn
Ernest H. Cockburn
Re: Software that makes placemats
Do you believe that the existence of an Accounting sheet on the placemats would materially discourage or disincentivise early administration?
Re: Software that makes placemats
Yes. "I'll sort it out on the night" could become the normal behaviour.
"The first duty of Port is to be red"
Ernest H. Cockburn
Ernest H. Cockburn
Re: Software that makes placemats
Why the conditional mood? With very few exceptions†, we do attempt to “sort it out on the night”. It has been suggested that if the Accounting page exists, we would attempt it neither more nor less often — i.e., it would remain “the normal behaviour” — but might be done more accurately.DRT wrote:"I'll sort it out on the night" could become the normal behaviour.
Do you agree with these assertions?
† So far this year, I recall only the 1985 horizontal in which finances were computed in advance. And even those were altered on the night.
Re: Software that makes placemats
Admittedly, I have not been to many tastings recently. Normal behaviour for this part of the organisation appears to have changed. As I am unlikely to organise a major tasting in the foreseeable future my view on the matter is of little or no significance.
"The first duty of Port is to be red"
Ernest H. Cockburn
Ernest H. Cockburn
Re: Software that makes placemats
For the verticals, in which a minority of bottles were the majority of the cost, accounting needs more attention. We seem to have been doing horizontals recently.DRT wrote:Admittedly, I have not been to many tastings recently. Normal behaviour for this part of the organisation appears to have changed.
The matter is settled democratically, by a weighted vote, in which my vote is the only one with non-zero weight. Good reasoning is what matters; not whether you will organise a tasting.DRT wrote:As I am unlikely to organise a major tasting in the foreseeable future my view on the matter is of little or no significance.
Re: Software that makes placemats
Please comment:

(Edited to update image.)

(Edited to update image.)
Re: Software that makes placemats
The accounts page looks good to me. Presumably with 4 people at the test tasting, it was not put to use?
Re: Software that makes placemats
Correct. My home printer isn’t happy, and I wanted to see a page — which has resulted in some minor improvements to the aesthetic.flash_uk wrote:Presumably with 4 people at the test tasting, it was not put to use?
Re: Software that makes placemats
How many glasses can sensibly go on one sheet of /USL2 = US Ledger = 17″×11″? This has been discussed on
. As a test Eric Menchen printed this test PDF (which has pages of 13, 14, 15, 16, 18, 20, and 21 glasses), and has posted photographs of glasses on these 17″×11″ pages. Answer: sixteen.

Re: Software that makes placemats
Surely this depends on which style of glasses are used?jdaw1 wrote:How many glasses can sensibly go on one sheet of /USL2 = US Ledger = 17″×11″? This has been discussed on. As a test Eric Menchen printed this test PDF (which has pages of 13, 14, 15, 16, 18, 20, and 21 glasses), and has posted photographs of glasses on these 17″×11″ pages. Answer: sixteen.
"The first duty of Port is to be red"
Ernest H. Cockburn
Ernest H. Cockburn
Re: Software that makes placemats
Yes.DRT wrote:Surely this depends on which style of glasses are used?
[url=http://fortheloveofport.com/ftlopforum/viewtopic.php?p=127383#p127383]On :ftlop2014:[/url] Eric Menchen wrote:I used a Schott Zwiesel SIZA Port Wine Glass. I think this the same as an IVDP glass. It has a squared stem with a notch in it. The base diamter is 2¾", whereas the bowl appears to have a maximum diameter of 2½".
Re: Software that makes placemats
The SZ has a larger base than the INAO tasting glass. I have held tastings with both 18 and 20 INAO glasses on /USL2 and it works fine. Examples, in fact, can be seen in Roy's most recent newsletter.
Glenn Elliott
Re: Software that makes placemats
For the sake of completeness, there is now a /A3 test PDF, with circle sizes as follows.
Code: Select all
On /A3 = 420mm×297mm:
13 glasses ⇒ radius ≈ 128.918 pt ⇒ diameter ≈ 3.58″ ≈ 91.0mm
14 glasses ⇒ radius ≈ 122.466 pt ⇒ diameter ≈ 3.40″ ≈ 86.4mm
15 glasses ⇒ radius ≈ 118.978 pt ⇒ diameter ≈ 3.30″ ≈ 83.9mm
16 glasses ⇒ radius ≈ 113.932 pt ⇒ diameter ≈ 3.16″ ≈ 80.4mm
18 glasses ⇒ radius ≈ 110.614 pt ⇒ diameter ≈ 3.07″ ≈ 78.0mm
19 glasses ⇒ radius ≈ 107.034 pt ⇒ diameter ≈ 2.97″ ≈ 75.5mm
20 glasses ⇒ radius ≈ 103.868 pt ⇒ diameter ≈ 2.89″ ≈ 73.3mm
21 glasses ⇒ radius ≈ 98.4921pt ⇒ diameter ≈ 2.74″ ≈ 69.5mm