First of all always send replies to [hidden email]
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. > > > > > > > |
Free forum by Nabble | Edit this page |