First of all always send replies to users@openoffice.apache.org
The benefit is you reach hundreds of volunteers each with their own
level / area of expertise.
I learned most by reading answers on this mailing list or the OpenOffice
forum https://forum.openoffice.org/
But understand that no one is an expert on everything, hence you learn
different things from each volunteer.
Now a general advice for each project you start to analyse the
requirements first. Second step is to analyse
the input data and how to calculate the result, don't worry about the
presentation jet.
When the calculated results are done you can start thinking about the
report layout. It's all like building a house
start with the foundation and the walls before you start on anything else.
On 18/03/18 5:03 AM, WA.TWORSX via AOL wrote:
Martin:
I'm trying to learn from your suggested solution, and have some
difficulties:
1. I do not find any references to Sheet 2 from within your Trial #1
sheet. For example, the formula in cell E9 uses local data (in
$E$33;$T$44); however, the formula in cell D9 seems to obtain data
results from your Sheet 2, but I do not see any reference to
'Sheet 2, cell ref. I'm confused by this, even tho it appears to
be working! I must be missing something.
The reason you don't see a reference to Sheet 2 is that I used a Name
(Ranking) in the formula.
In the Formula Bar you see the selected Cell D9 when you select the Pull
down arrow you see the Names I used Ranking and Score
select Ranking this opens $'Sheet 2'.$C$3:$E$38 I use Names as this
makes the formulas more readable.
1. Your Sheet 2 does not include a formula within column A (Score)
nor within column D (Player), which leads me to believe that you
typed-entered the contents there; a lot of work!
Yes I entered the Scores and Players in Sheet 2 because it's easier to
calculate the ranking.
1. Can you tell me why there are extra spaces in some cells when the
display formulas option is enabled on Sheet 2?
The extra spaces aren't in the displayed in the Formula Bar I have know
idea why they are there.
1. While in normal display mode (not showing formulae) on your Trial
#1 sheet, some cells show the formula (within the formula bar)
enclosed within braces { } ; why is that? Any significance to
those braces or those extra spaces, or may I simply ignore them ?
I ask, because I want to understand better and am willing to learn
from others.
The braces don't have any effect here I occidentally ticked the array
field in the formula window and you know what happens
when you copy the formula into other cells.
1. NOTE: There are to be 3 more tournament matches yet to take place
over the next several weeks. So, until all bowling game scores are
available for all bowlers the "score" data is a variable. I do
not see how your Sheet 2 calculations can handle that.
Because I don't know the requirements of how you want calculate the
score over more tournaments you should use the
calculation method on Sheet 2 as an example only.
As mentioned in my recent post to the tread on the AOO Mail List (15
Mar, 11:21 AM), duplicate/triplicate scores and ranking are not
anticipated to be a problem, since different criterion shall be used
to achieve tie breaking. I believe that I have the 'ranking' part
solved on My BVL Summary Trial Sheets.ods'#$*Sheet4* on file at Drop
Box, see:
https://www.dropbox.com/s/2n1r864msxfdlf1/BVL%20Summary%20Trial%20Sheets.ods?dl=0
.
If you choose not to reply to this, I will understand. However, be
assured that I do appreciate all of your efforts to help. Thank you.
Best Regards,
VinceB.
