home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Archive Magazine 1996
/
ARCHIVE_96.iso
/
discs
/
gerald
/
6_10
/
Football
/
GF_01
/
ReadMe
< prev
next >
Wrap
Text File
|
1992-11-02
|
3KB
|
80 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%WC1026,2262,188,1748,0,0,0,0
%CO:A,72,72%
%C%Football
%C%by Gerald L Fitton
Keywords:
Football Fitton
I have had a quick look at your problem and, although I don't think I
have yet the optimum solution, particularly with regard to the data
entry, I believe that the enclosed files improve the calculation speed
considerably.
I have ideas for improving the data entry, both convenience and speed,
by using a separate sheet for data entry. This would have the layout
of the table containing the results which appears in the newspapers.
For the present here is the way that this set of sheets is used.
Double click on [Table]. It and four other files, [ForH], [AgainstA],
[ForA] and [AgainstH] will load. I have entered the result for one
match only, namely the Arsenal (home) V Norwich City (away) match.
The data is entered as follows. In the [ForH] sheet I have entered the
goals scored by the home team, Arsenal against Norwich (2). In the
[AgainstH] sheet I have entered the goals scored against the home team,
Arsenal by Norwich (4).
I believe that using these two two-dimensional tables is better than
the one long single dimensional display used in your method because it
reduces the number of dcounta(,) calculations per entry and hence
speeds up calculation.
The two files [ForA] and [AgainstA] are the transposes of [AgainstH]
and [ForH] respectively. You do not enter data into them and they
could be hidden. Look at slot [ForA]A2 to see how the transpose is
executed. I have created them in order to simplify replication of the
formulae in [Table] columns D, E and F. The application would
calculate much more quickly if the formulae in [Table] did not refer to
the transposed tables but only to the original two into which the data
is entered but I can't think of a quick method of filling the
3á*á22á=á66 slots without entering long formulas into each of them!
maybe with a bit more thought I'll hit on an idea using search and
replace (eg replace all the column X with row 25) or a custom function
which will change all the relevant formulae to their transpose! If you
feel up to it you might have a go at changing the formulae in those
three columns of [Table] (66 slots) to avoid all references to the
transposed sheets.
I hope that this helps get you started. I will have a think about
improving data entry but it may be a little while before I get round to
it. Your 'complaint' about the whole sheet recalculating slowly after
one entry has been ameliorated but not to my total satisfaction.
The [Table] can be sorted very quickly without recalculation.
I am not sure why date gives an error but it may not have a 'countable'
value. By the way I have included a separate [Date] document but you
can't do much with it yet until we get the 'data entry' transaction
file sorted out. I am hoping to find a way of using set_value(,) from
the transaction file (ie the data entry file) to push data into the
[ForH] and [AgainstH] files which will not set off a long
recalculation. As I said (or implied), I'm going to have to wait for
some inspiration and time before I tackle that part of the problem.
Bye for now.
Gerald