6.0345 Rs: Pounds, Sillings, Pence; S/W (5/125)
Elaine Brennan & Allen Renear (EDITORS@BROWNVM.BITNET)
Thu, 5 Nov 1992 07:35:59 EST
Humanist Discussion Group, Vol. 6, No. 0345. Thursday, 5 Nov 1992.
(1) Date: Sun, 01 Nov 92 13:38:03 IST (38 lines)
From: "David M. Schaps" <F21004@BARILVM>
Subject: Re: 6.0336 Qs: Pounds, shillings & pence
(2) Date: Sun, 01 Nov 92 14:06 CST (11 lines)
From: TB0WPW1@NIU.BITNET
(3) Date: Mon, 2 Nov 1992 03:48:30 +0000 (47 lines)
From: Patrick John Coppock <patCoppock@avh.unit.no>
Subject: 6.0336 Qs: Exchanges; Pen-Pals; S/W; Address; Quote (6/89)
(4) Date: Mon, 02 Nov 92 11:03:09 GMT (15 lines)
From: Donald A Spaeth <GKHA13@CMS.GLASGOW.AC.UK>
Subject: Re: 6.0336 Pounds, shillings, pence
(5) Date: Mon, 2 Nov 1992 07:31:28 -0500 (14 lines)
From: warkent@epas.utoronto.ca (Germaine Warkentin)
Subject: Pounds, shillings and pence
(1) --------------------------------------------------------------------
Date: Sun, 01 Nov 92 13:38:03 IST
From: "David M. Schaps" <F21004@BARILVM>
Subject: Re: 6.0336 Qs: Pounds, shillings & pence
Any spreadsheet program can add pounds, shillings, and pence, or any
similarly mystifying set (yards, feet and inches; pounds and ounces).
Just make a column for pounds, another for shillings, and another for
pence. Near the bottom -- if you don't want to get complicated -- put a
row that totals each column. This should look like this:
Pounds Shillings Pence
(Individual . . .
entries) . . .
. . .
TOTAL SUM (..) SUM (..) SUM (..)
Call the three cells including the totals A, B, and C (of course you
will really call them whatever your program calls them). For the next
row -- to keep things transparent -- reduce the pence to lowest terms
by defining three more cells (I will call them D, E, and F) where
D=A, E=B+INT(C/12), and F=MOD(C/12), where "INT" means "the largest
integer smaller than what is in parentheses (i.e., the quotient
without the remainder) and "MOD" means "the remainder of what is
in parentheses". Now for the next and last row, define your three
cells (G, H, and I, of course) as follows: G=D+INT(E/20), H=MOD(E/20),
I=F. Now enter whatever entries you want in the "individual entries"
rows, and the bottom row will always show you the total in pounds,
shillings and pence. The same program can balance your checkbook,
too.
You could, of course, do without the two rows before the
last one by making the formulae more complicated.
I have had to add up large number of drachmae, oboloi, and
chalkoi, and it used to be much trickier before spreadsheets.
David M. Schaps
Department of Classical Studies
Bar Ilan University
Ramat Gan, Israel
FAX: 972-3-347-601
(2) --------------------------------------------------------------14----
Date: Sun, 01 Nov 92 14:06 CST
From: TB0WPW1@NIU.BITNET
It shouldn't be too hard:
12 pence (abbrev. d.) to the shilling
20 shillings to the pound
If you add in Crowns (5 s.), half-crowns (2/6),
tuppence (2 d.), and thrupence (3 d.) you should be on
your way without any more than a pocket calculator.
WPW TB0wpw1@NIU
(3) --------------------------------------------------------------64----
Date: Mon, 2 Nov 1992 03:48:30 +0000
From: Patrick John Coppock <patCoppock@avh.unit.no>
Subject: 6.0336 Qs: Exchanges; Pen-Pals; S/W; Address; Quote (6/89)
Achim Wagenknecht <DBPHILOS@ze8.rz.uni-duesseldorf.de>
writes:
>Hi Ellen,
>please can you post this message on Mail-list:
>Does anyone know the Adress of
>BROWN BAG Comp. USA
>or does anyone know how to obtain a new version of the
>Computer-Software MINDREADER
As far as I know, Brown Bag (the originaters of PC Outline) are at:
Brown Bag Software
File #41719
Box 60000
San Fransisco CA 94160-1719
USA
This at least is the address they provided some years ago with copies of
the shareware version of PCO. They might well have moved though, the
last couple of years. Try anyway and good luck!
Their phone number is:
(408) 559-4545
And they provide a BBS service at:
(408) 371-7654 (Campbell)
(408) 424-3452 (New York)
best wishes
pat coppock
dept. of applied linguistics
university of trondheim avh
n-7055 dragvoll
norway
patCoppock@avh.unit.no
(4) --------------------------------------------------------------23----
Date: Mon, 02 Nov 92 11:03:09 GMT
From: Donald A Spaeth <GKHA13@CMS.GLASGOW.AC.UK>
Subject: Re: 6.0336 Pounds, shillings, pence
A special program isn't needed to calculate pounds, shillings, and
pence. Any spreadsheet will do the job. The trick is to
convert pounds and shillings to pence, perform the arithmetic, and
then reconvert (if you wish). If you put pounds, shillings and
pence in columns B, C, and D, then your formula in E will be
(B1*240)+(C1*12)+D1. But I expect you knew that!
Donald Spaeth
Computers in Teaching Initiative Centre for History
University of Glasgow
Scotland
(5) --------------------------------------------------------------26----
Date: Mon, 2 Nov 1992 07:31:28 -0500
From: warkent@epas.utoronto.ca (Germaine Warkentin)
Subject: Pounds, shillings and pence
Public thanks to those (including Eric Johnson who replied on the
list) who sent me information; I now have a program, a hypercard
stack, and some suggestions about spreadsheets, and my needy colleagues
are very pleased indeed.
*******************************************************************************
Germaine Warkentin warkent@epas.utoronto.ca
English, Victoria College, University of Toronto
*******************************************************************************