If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#21
|
|||
|
|||
league table without macros
it's not actually hidden (although it can be) - its just a few columns over to the right on the table worksheet, just scroll across until you find it... Sorry about that (v. embarassing!) As for the hidden table, I'm impressed by how consise it is (so much less convoluted than the world cup spreadsheets I've seen. There's a number of functions I'll need to look up to help me understand it (!) but for now could I ask what the adg score represents ? Thanks again. -- gdh82 ------------------------------------------------------------------------ gdh82's Profile: http://www.excelforum.com/member.php...o&userid=35902 View this thread: http://www.excelforum.com/showthread...hreadid=557213 |
#22
|
|||
|
|||
league table without macros
I still haven't got it, but I have just posted a first-cut at http://www.xldynamic.com/example code/xld.league_table_sans_vba.xls Fantastic - its works a dream on the pcs at work (that is soo good to see!) I've got a couple of thoughts of possible tweaks, if I may. The main one is to ask if its possible to includea separate worksheet containing the teamlist (akin to daddylonglegs' table) so the user can easily add/delete/rename teams? Many thanks again. Garry -- gdh82 ------------------------------------------------------------------------ gdh82's Profile: http://www.excelforum.com/member.php...o&userid=35902 View this thread: http://www.excelforum.com/showthread...hreadid=557213 |
#23
|
|||
|
|||
league table without macros
I'll take a look at that. It's a good idea to manage the teams, better than
my suggestion. What are the others? -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "gdh82" wrote in message ... I still haven't got it, but I have just posted a first-cut at http://www.xldynamic.com/example code/xld.league_table_sans_vba.xls Fantastic - its works a dream on the pcs at work (that is soo good to see!) I've got a couple of thoughts of possible tweaks, if I may. The main one is to ask if its possible to includea separate worksheet containing the teamlist (akin to daddylonglegs' table) so the user can easily add/delete/rename teams? Many thanks again. Garry -- gdh82 ------------------------------------------------------------------------ gdh82's Profile: http://www.excelforum.com/member.php...o&userid=35902 View this thread: http://www.excelforum.com/showthread...hreadid=557213 |
#24
|
|||
|
|||
league table without macros
gdh82 Wrote: Sorry about that (v. embarassing!) As for the hidden table, I'm impressed by how consise it is (so much less convoluted than the world cup spreadsheets I've seen). There's a number of functions that I haven't used before so I'll need to look them up to help me understand it (!) but for now could I ask what the adg score represents ? Thanks again. Hi gdh, I'm sure Bob can produce something rather superior to mine but to answer your question.... "Adg score" should really be "adj score" meaning "adjusted score". Basically the number of points is adjusted by a very small amount based on goal difference or goals scored which ensures that when there is a tie on points the team with the best goal difference has a slightly higher "adj score" and is therefore ranked higher. Similarly if both points and goal difference are equal then the team with the most goals scored will have a slightly higher "adj score" ensuring, again, that the correct team is ranked higher. -- daddylonglegs ------------------------------------------------------------------------ daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486 View this thread: http://www.excelforum.com/showthread...hreadid=557213 |
#25
|
|||
|
|||
league table without macros
I use a points, goal difference, goals scored, row algorithm to ensure
unique ranking in mine. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "daddylonglegs" wrote in message news:daddylonglegs.2ah72n_1152108607.7943@excelfor um-nospam.com... gdh82 Wrote: Sorry about that (v. embarassing!) As for the hidden table, I'm impressed by how consise it is (so much less convoluted than the world cup spreadsheets I've seen). There's a number of functions that I haven't used before so I'll need to look them up to help me understand it (!) but for now could I ask what the adg score represents ? Thanks again. Hi gdh, I'm sure Bob can produce something rather superior to mine but to answer your question.... "Adg score" should really be "adj score" meaning "adjusted score". Basically the number of points is adjusted by a very small amount based on goal difference or goals scored which ensures that when there is a tie on points the team with the best goal difference has a slightly higher "adj score" and is therefore ranked higher. Similarly if both points and goal difference are equal then the team with the most goals scored will have a slightly higher "adj score" ensuring, again, that the correct team is ranked higher. -- daddylonglegs ------------------------------------------------------------------------ daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486 View this thread: http://www.excelforum.com/showthread...hreadid=557213 |
#26
|
|||
|
|||
league table without macros
"Adg score" should really be "adj score" meaning "adjusted score". Basically the number of points is adjusted by a very small amount based on goal difference or goals scored which ensures that when there is a tie on points the team with the best goal difference has a slightly higher "adj score" and is therefore ranked higher. Thanks for explaining that, daddylonglegs. IMO that's a really original way around the problem - I would never have thought of approaching it like that in a million years! My eyes are being opened... -- gdh82 ------------------------------------------------------------------------ gdh82's Profile: http://www.excelforum.com/member.php...o&userid=35902 View this thread: http://www.excelforum.com/showthread...hreadid=557213 |
#27
|
|||
|
|||
league table without macros
Bob Phillips Wrote: I'll take a look at that. It's a good idea to manage the teams, better than my suggestion. What are the others? My only other suggestions concern the layout of the table so I guess this is only my particular preferences and others may disagree. For my purposes I've been using your league table for about 6-10 players which reduces the size of the fixture grid considerably so I'd like to have the table on the same page as the fixtures. Ideally this need only be the 'overall & pts' columns of the table. This is simply a practical issue when printing off a hardcopy for the office noticeboard. I also think the table would look better if it could have alternating shaded backgrounds for each of rows - just to guide the eye. The table worksheet has the default orientation as portrait rather than landscape, by the way. Finally I did tend to find that with the macro version of the spreadsheet I'd get run-time errors occasionally after added/deleting teams and once the errors had started I generally would have to resort to an earlier version of the spreadsheet. I guess, though, this won't be an issue with the non-macro version? Hope I'm not sounding too picky - just take this as constructive feedback - as I'm already very impressed with your excellent spreadsheet and am grateful of your willingness to help. Garry -- gdh82 ------------------------------------------------------------------------ gdh82's Profile: http://www.excelforum.com/member.php...o&userid=35902 View this thread: http://www.excelforum.com/showthread...hreadid=557213 |
#28
|
|||
|
|||
league table without macros
Garry,
What I could do is to put the table and the results on the same page, in separate windows, and the user could then close the second window if they didn't want it, or it is a small table. The teams table would be separate though still. The line shading should be easy with CF, and I will set to landscape. As for the VBA version, you don't know the sequence of events that caused by any chance, I would like to fix it. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "gdh82" wrote in message ... Bob Phillips Wrote: I'll take a look at that. It's a good idea to manage the teams, better than my suggestion. What are the others? My only other suggestions concern the layout of the table so I guess this is only my particular preferences and others may disagree. For my purposes I've been using your league table for about 6-10 players which reduces the size of the fixture grid considerably so I'd like to have the table on the same page as the fixtures. Ideally this need only be the 'overall & pts' columns of the table. This is simply a practical issue when printing off a hardcopy for the office noticeboard. I also think the table would look better if it could have alternating shaded backgrounds for each of rows - just to guide the eye. The table worksheet has the default orientation as portrait rather than landscape, by the way. Finally I did tend to find that with the macro version of the spreadsheet I'd get run-time errors occasionally after added/deleting teams and once the errors had started I generally would have to resort to an earlier version of the spreadsheet. I guess, though, this won't be an issue with the non-macro version? Hope I'm not sounding too picky - just take this as constructive feedback - as I'm already very impressed with your excellent spreadsheet and am grateful of your willingness to help. Garry -- gdh82 ------------------------------------------------------------------------ gdh82's Profile: http://www.excelforum.com/member.php...o&userid=35902 View this thread: http://www.excelforum.com/showthread...hreadid=557213 |
#29
|
|||
|
|||
league table without macros
Bob Phillips Wrote: What I could do is to put the table and the results on the same page, in separate windows, and the user could then close the second window if they didn't want it, or it is a small table. The teams table would be separate though still. As for the VBA version, you don't know the sequence of events that caused by any chance, I would like to fix it. Thanks again or the further post, Bob. Sounds good to me- would it possible to print the two separate windows as one page of hardcopy ? As a very basic workaround on the VBA version I'd simply added a few '=' operators to the right of the fixture grid that linked to the relevant cells in the table worksheet. This then gave me the table on the same worksheet as the fixture grid. I'm afraid I don't know the exact sequence but I think it was a combination of adding the table to the fixture worksheet and adding/deleting teams that caused the run-time errors. Perhaps I was putting the table in a place where the fixtures overlapped ? Sorry I can't be more sure than that. Cheers Garry -- gdh82 ------------------------------------------------------------------------ gdh82's Profile: http://www.excelforum.com/member.php...o&userid=35902 View this thread: http://www.excelforum.com/showthread...hreadid=557213 |
#30
|
|||
|
|||
league table without macros
Hi Bob, I know its only been a week since the last post and its really brilliant that you're looking into this at all, but I just wanted to follow this up and ask how the spreadsheet was going? Hope I didn't sound too pedantic about the layout issues as really they are secondary. The only key thing (I think) that needs to be added to the non-macro version is a tab that can used to add/delete teams. Look forward to your next post on the subject. Thanks again Garry -- gdh82 ------------------------------------------------------------------------ gdh82's Profile: http://www.excelforum.com/member.php...o&userid=35902 View this thread: http://www.excelforum.com/showthread...hreadid=557213 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
three table database | ricardozelaya | Database Design | 3 | April 25th, 2006 12:15 AM |
Table Design | A. Williams | Database Design | 3 | April 29th, 2005 07:02 PM |
Seeking some expert advice. | HD87glide | Using Forms | 14 | March 23rd, 2005 11:11 PM |
Here's a shocker | Mike Labosh | General Discussion | 2 | October 26th, 2004 05:04 PM |
Table Wizard Does Not Set Relationship if Foreign Key and Primary Key Name Do Not Match Exactly in Case. | HDW | Database Design | 3 | October 16th, 2004 03:42 AM |