[preggy]

Hi
I have created some spreadsheets to help me complete results & a self sorting league table in excel.
Unfortunately I am a complete novice & have no idea how to do this properly.
I have attached the spreadheet in its entirity.
I want to put the position the golfers finish on sheet one inputing the position they finished i.e 1,2,3,4 etc, then excel fills in the points & puts the golfers in the correct order at each event, also auto arranging the leader board including the points gained.
The winner gets 30 points, second 29 third 28 & so on.
I will have to fill in handicaps manually, so no problem there.
I would appreciate any help most gratfully.

thank you
David


<removed original spreadsheet and replaced with dummy names - moderator ETAF>

[etaf]

you may want a macro to do all you want - you may also want to consider the names as this is a public forum - i have changed to Player1 , 2 etc
and edited and updated your sheet

Edit -
I will populate with a Vlookup idea i have for the spreadsheet to work

[preggy]

Hi THank you.

sorry I am useless with this stuff.

[etaf]

i think it can be done with a vlookup and pivot table

just playing now

[etaf]

Ok that works - needed to setup a calc sheet

see attached

I'll edit and explain how it works - so watch this space

meanwhile have a look at the sheets
I will update with all players

few questions

1) I have assumed you will only have 30 players on each ground that get points
2) can you have more than 30 players in the tournament ?? - so will your golfers sheet be much larger number of players ?

[preggy]

there will be a maximum of thirty. However the scoring will always start at 30 & go down one at a time, so if there are only twenty players the player in last place would still get 10 points. players that do not turn up get zero. I suspect there will be fewer players this season maybe 24/5 but at least setting at thirty gives me a little lee way.
The leaderboard is basically a league table.

Thank you for your help so far, it is much appreciated!

[etaf]

your welcome - i have modified for 50 players - makes little difference
i'll finsih off and try a document

its should just need you to enter the names for each tornament (BUT NOT until they played it - ) and then in the correct order
the

Golfers sheet will automatically update

then on the leadership pvt table - you need to click inside the table - you should see a pivot table tool bar appear
click on the !
and it will update and sort descending

[etaf]

OK - hopefully this all now works for you

The following information is also included on the "Instruct" - Sheet in the spreadsheet

Sheet What it Does

Golfers Here you can enter as many Golfers as you like - I have setup 50 players
Golfers The sheet then uses a VLOOKUP function - the way it works is - it takes the Cell B7 and takes that name and then looks at the course and looks down the list of players
Golfers When the player is found it then moves across to Column J and picks up the score
Golfers If it cannot find the player - rather than return an Error message - I have setup to record zero

PVTCalc This sheet is used to provide details for the pivot table - the Golf Course and the score is hardcoded on the sheet in column B and C
PVTCalc Column A uses a simple copy of the cell from the sheet and uses the = cell command - so it simply takes the top 30 Players and copies them into Column A against each course

LeaderBoard pvt This uses a pivot table - and uses the PvtCalc sheet
LeaderBoard pvt So it looks down the list and groups the grounds and displays across the columns - I have set this up to be in the same order as you had them
LeaderBoard pvt Next it will look down and find all the Players and group those together
LeaderBoard pvt then in the data area it sums up all the scores
LeaderBoard pvt Under players - there will be a number of players called zero - this is because if the player field is empty on the course - ie there where only 26 players then the other 4 players are labeled 0
LeaderBoard pvt because of that - I have set the player list NOT to show a player named 0
LeaderBoard pvt Now I have set the sort order to be based on the Total Points scored and to sort descending


WHAT YOU NEED TO DO

All you need to do is to put in the names of the golfers onto the GOLFERS sheet
Then as each Course is played Enter the players 1-30 in descending order as they won the points - as you have setup - just need the names
Then you need to got to the LeaderBoard pvt sheet and click inside the table somehwhere - a pivot table tool bar will appear - NOW you need to click on the ! Icon and the list will be updated


I HAVE ONLY CHECKED the results for player 4 and it appears to work

If there are NO Players on the sheet - then the leadership pvt sheet - will not display that course until players are entered - in this initail setup - that’s TAPTON and BONDHAY

[etaf]

i'm going off line now - and may not be back on till sunday UK time - just depends on how tomorrow works out

so have a play and any questions post here and i will try and answer sunday

[preggy]

I will hopefully get time tomorrow to test it in a mock competition.

Thank you so much for your time & effort, I really do appreciate it.

Kindest regards & best wishes
David

[preggy]

hI
I did a quick mock up of a tournament using 16 players names for example. I inputted their finishing position on the golfers sheet alongside the Rutland event. I then checked the Rutland result sheet & the leaderbaord, unfortunately nothing seems to transfer?
It may be me being pretty useless with this thing?
Let me know if it is

Thank you
David

[etaf]

so the names go on to the golfers sheet and also have to be entered into the rutland sheet
then golfers should auto update
and the leadership you click on the !

let me try

[etaf]

seems to have worked

I cleared the names in golfers sheet
i cleared the names in all the courses sheets

then typed in 10 names into the golfers sheet
then typed in the names into the rutland sheet - (i pasted and sorted just to have a different order)

the golfers sheet - automatically updated the scores

i then clicked on the table in the leadership pvt and clicked on the ! and it updated

your leadership sheet - i'm not doing anything with - the leadership pvt - replaced the leadership sheet
as it showed the same info

i have attached the example with names

because noone is in the other courses - the leadership pvt does not show those courses - that may need to be changed

[etaf]

Had a play and also made some adjustments - so your leadership table now populates from the pivot table

only thing i needed to do was to add a player name is BLANK - and has 0 points - so i could make sure all the courses stayed on the pvt table when no players had been entered

i have not checked these results - have a play and see what you may want changing

i'm out now until sunday UK time

I have had to zip the file up as its not a little to big for the forum

[etaf]

had another play - this time it will update the leadership table before any golf is played - with all the players
not in any particular order and we can fix that too 0 if required

so if you just enter names for the golfers in the golfers sheet and then clear all the names in each of the courses sheet
then goto leadership pvt - click inside the table and then click - ! on the toolbar

you should get all the names in the leadership sheet