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 |
#11
|
|||
|
|||
league table without macros
I have my own football league table which works without macros. It isn't that complicated. As Bob suggests, it basically has one "hidden" table and another table "sorted" in order to view It has a list of fixtures. As you enter results the table updates based on 3 points for a win and usual rules to split ties, i.e. goal difference followed by goals scored. Thanks very much for emailing me the spreadsheet - it runs fine on the work pcs (which don't allow macros). I especially like how easy it is to add/delete teams. I'd like to know more about how it works - where is the hidden table? The only downside in my opinion is that it doesn't create the fixtures - ideally a fixture grid (home teams-vertical, away teams-horizontal). I have a spreadsheet (with macros thought) that does that which I'd gladly share - I'd like to have a go at merging elements of both spreadsheets ? Alternatively, could Bob incorporate a fixture grid into the spreadsheet he's developing ? -- gdh82 ------------------------------------------------------------------------ gdh82's Profile: http://www.excelforum.com/member.php...o&userid=35902 View this thread: http://www.excelforum.com/showthread...hreadid=557213 |
#12
|
|||
|
|||
league table without macros
I am not sure what layout you mean. Take a look at my VBA version,
http://www.xldynamic.com/source/xld.LeagueTable.html, and see if the results format is what you mean. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "gdh82" wrote in message ... I have my own football league table which works without macros. It isn't that complicated. As Bob suggests, it basically has one "hidden" table and another table "sorted" in order to view It has a list of fixtures. As you enter results the table updates based on 3 points for a win and usual rules to split ties, i.e. goal difference followed by goals scored. Thanks very much for emailing me the spreadsheet - it runs fine on the work pcs (which don't allow macros). I especially like how easy it is to add/delete teams. I'd like to know more about how it works - where is the hidden table? The only downside in my opinion is that it doesn't create the fixtures - ideally a fixture grid (home teams-vertical, away teams-horizontal). I have a spreadsheet (with macros thought) that does that which I'd gladly share - I'd like to have a go at merging elements of both spreadsheets ? Alternatively, could Bob incorporate a fixture grid into the spreadsheet he's developing ? -- gdh82 ------------------------------------------------------------------------ gdh82's Profile: http://www.excelforum.com/member.php...o&userid=35902 View this thread: http://www.excelforum.com/showthread...hreadid=557213 |
#13
|
|||
|
|||
league table without macros
Bob Phillips Wrote: Daddy, I am in the middle of creating my own, but a couple of questions on how you address certain points. Do you allow for different points scoring systems? I do, by just having a data sheet with the points for home and away wins, and a draw. How about you? How do you manage the change of teams over year to year? How do manage the fact that say you have created the table for 20 teams and someone else wants to setup a 22 team table? I am thinking here specifically of ensuring the derived data automatically picks up the extra data. Thanks Bob Hi Bob, To answer your questions. I created the spreadsheet originally for my own use. It currently only caters for the standard points system, i.e. 3 points for a win and 1 for a draw but I believe that can be modified fairly easily. In my sheet you need to list the teams and also the fixtures although I think gdh82's suggestion of a fixture grid might be a good idea. The teamlist has to be modified if the teams change, e.g. due to promotion relegation but it accommodates any number of teams up to 30. I certainly can't claim it's a work of art (or if it is, it's more of a Dali that a da Vinci!) but I think it does a reasonable job, perhaps a good job with some modifications. I can send you a copy if you wish. If you don't mind, I'll have a look at your VBA version any see if I can nick any ideas -- daddylonglegs ------------------------------------------------------------------------ daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486 View this thread: http://www.excelforum.com/showthread...hreadid=557213 |
#14
|
|||
|
|||
league table without macros
Please send me a copy. At the very least it will give me ideas on adding
teams as the OP said he liked the way that works. I will post mine at my website when finished. If you wish I will post yours also, so that people can see different approaches, and hopefully learn from studying both. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "daddylonglegs" wrote in message news:daddylonglegs.2adlfz_1151940601.8475@excelfor um-nospam.com... Bob Phillips Wrote: Daddy, I am in the middle of creating my own, but a couple of questions on how you address certain points. Do you allow for different points scoring systems? I do, by just having a data sheet with the points for home and away wins, and a draw. How about you? How do you manage the change of teams over year to year? How do manage the fact that say you have created the table for 20 teams and someone else wants to setup a 22 team table? I am thinking here specifically of ensuring the derived data automatically picks up the extra data. Thanks Bob Hi Bob, To answer your questions. I created the spreadsheet originally for my own use. It currently only caters for the standard points system, i.e. 3 points for a win and 1 for a draw but I believe that can be modified fairly easily. In my sheet you need to list the teams and also the fixtures although I think gdh82's suggestion of a fixture grid might be a good idea. The teamlist has to be modified if the teams change, e.g. due to promotion relegation but it accommodates any number of teams up to 30. I certainly can't claim it's a work of art (or if it is, it's more of a Dali that a da Vinci!) but I think it does a reasonable job, perhaps a good job with some modifications. I can send you a copy if you wish. If you don't mind, I'll have a look at your VBA version any see if I can nick any ideas -- daddylonglegs ------------------------------------------------------------------------ daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486 View this thread: http://www.excelforum.com/showthread...hreadid=557213 |
#15
|
|||
|
|||
league table without macros
I am not sure what layout you mean. Take a look at my VBA version, http://www.xldynamic.com/source/xld.LeagueTable.html, and see if the results format is what you mean. That's the exactly the perfect layout, Bob !! In fact it turns out I have been using this spreadsheet of yours and didn't even know it. I really like it - its just that I can't use it on the work pcs because they won't allow macros to run Thanks again for the helpful responses - look forward to more news on the subject... -- gdh82 ------------------------------------------------------------------------ gdh82's Profile: http://www.excelforum.com/member.php...o&userid=35902 View this thread: http://www.excelforum.com/showthread...hreadid=557213 |
#16
|
|||
|
|||
league table without macros
You can at least rest assured that my no-macro version will input the scores
in the same way G -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "gdh82" wrote in message ... I am not sure what layout you mean. Take a look at my VBA version, http://www.xldynamic.com/source/xld.LeagueTable.html, and see if the results format is what you mean. That's the exactly the perfect layout, Bob !! In fact it turns out I have been using this spreadsheet of yours and didn't even know it. I really like it - its just that I can't use it on the work pcs because they won't allow macros to run Thanks again for the helpful responses - look forward to more news on the subject... -- gdh82 ------------------------------------------------------------------------ gdh82's Profile: http://www.excelforum.com/member.php...o&userid=35902 View this thread: http://www.excelforum.com/showthread...hreadid=557213 |
#17
|
|||
|
|||
league table without macros
BTW, I haven't received any email address for you yet.
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "gdh82" wrote in message ... I am not sure what layout you mean. Take a look at my VBA version, http://www.xldynamic.com/source/xld.LeagueTable.html, and see if the results format is what you mean. That's the exactly the perfect layout, Bob !! In fact it turns out I have been using this spreadsheet of yours and didn't even know it. I really like it - its just that I can't use it on the work pcs because they won't allow macros to run Thanks again for the helpful responses - look forward to more news on the subject... -- gdh82 ------------------------------------------------------------------------ gdh82's Profile: http://www.excelforum.com/member.php...o&userid=35902 View this thread: http://www.excelforum.com/showthread...hreadid=557213 |
#18
|
|||
|
|||
league table without macros
Thanks for pointing this out but I did pm my email details on 2 July and have re-forwarded them again just now (hope I'm doing it right?) You can at least rest assured that my no-macro version will input the scores in the same way G Great stuff ! Can't wait... -- gdh82 ------------------------------------------------------------------------ gdh82's Profile: http://www.excelforum.com/member.php...o&userid=35902 View this thread: http://www.excelforum.com/showthread...hreadid=557213 |
#19
|
|||
|
|||
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 Give it a try and let me know how it goes. When we are happy, I will add it to the main page, a VBA and a non-VBA version. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "gdh82" wrote in message ... Thanks for pointing this out but I did pm my email details on 2 July and have re-forwarded them again just now (hope I'm doing it right?) You can at least rest assured that my no-macro version will input the scores in the same way G Great stuff ! Can't wait... -- gdh82 ------------------------------------------------------------------------ gdh82's Profile: http://www.excelforum.com/member.php...o&userid=35902 View this thread: http://www.excelforum.com/showthread...hreadid=557213 |
#20
|
|||
|
|||
league table without macros
gdh82 Wrote: And could I ask, daddylonglegs - how do I look at the hidden table in your spreadsheet ? I'd like to try and understand it better but can't find it ??? Hi gdh, 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... -- daddylonglegs ------------------------------------------------------------------------ daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486 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 |