home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Archive Magazine 1996
/
ARCHIVE_96.iso
/
discs
/
gerald
/
6_10
/
Football
/
PremierLea
/
ReadMe
< prev
next >
Wrap
Text File
|
1992-10-30
|
2KB
|
68 lines
%OP%VS4.13 (28-Apr-92), Gerald L Fitton, R4000 5966 9904 9938
%OP%DP0
%OP%IRY
%OP%PL0
%OP%HM0
%OP%FM0
%OP%BM0
%OP%LM4
%OP%PT1
%OP%PDPipeLine
%OP%WC314,1558,44,1364,0,0,0,0
%CO:A,72,72%
%C%Premier League
%C%by Philip Tolhurst
Keywords:
Dear Gerald,
I wonder whether you could help me to improve the enclosed
spreadsheet which I have designed in response to my daughter who is a
keen football fan and Spurs supporter!
As you will see, it is a record of matches played in the Premier
League this season. The range B2F465 records the date, home and
away teams and the goals scored. I have given names to each column
of the database and these are used in the league table in the
range G1P26.
My questions/problems about this spreadsheet are threefold.
1. To derive the league table, I have used database functions,
incorporating names where possible -although if I use, for
example, Date instead of HomeScore in I2, I get an error message
which I don't understand! Anyway, I wonder if Database functions
are the best approach.
2. This leads to my second question -because every time I enter a
SINGLE new result (involving only two teams!) the spreadsheet has to
recalculate the whole league table and even with an A5000 this does
take some time. I would ideally like to find a way of entering a single
result, and only the two effected teams in the league table being
recalculated.
3. My third and final question is how do I get the league
table ranked in points order to find out the leader etc? At the moment,
after entering a series of results I wait for recalculation to cease
and then do a Block Sort -this does rank the teams correctly but also
sets off another round of recalculation. Help!
I would be most grateful for any advice you could give.
If you think it would be of any interest I am willing to provide
an updated version of the database for PipeLine4 readers.
Finally may I take the opportunity of thanking you for
PipeLine4. Thanks to this I am just beginning to understand
Arrays, Custom Functions and the like. PipeDream 4 is an
excellent programme but it does take some effort to dig out its
treasures!
Philip Tolhurst
Raleigh's Holt
29 High Street
Lode
Cambridge
CB5 9EW
30 October 1992