Creation of an Excel file for a bowling championship

Hi there :-)

I'm not an Excel whiz, but I would be interested in helping you out :-)

If I understand correctly, you would like:
- 1 page with the current contest ranking
- 1 page for the recap of points week/me/year...
?

We would need to know the number of players, etc...
If you agree, I can do it and it will help me review my Excel functions :-)

Message me privately if you agree :-)

I can't manage to write in private.
There are about 30 players, but not all 30 are necessarily present each time.
The goal would be to say that on this day, a certain player scored 20 points, 19, 18, 17, etc.
And in another table, it shows the total points over the course of the days.

Hello

A table to record the results and rank them

https://www.cjoint.com/?3KnuwUZNs6w

--
Practice makes perfect. - It’s when you’re up against the wall that you see the bricklayer - one always learns from their mistakes.

Thank you for your responses, Philou I was inspired by your table but your macro does not work with Excel 2007

Here is my file, how can I sort automatically in the individual ranking?

http://cjoint.com/?CKpt3bgCUXV

Hello

Your file with a macro for sorting will require you to answer yes to the question to accept macros if you trust me

https://www.cjoint.com/?3Kpu0T1vTUG

--
Practice makes perfect. - It's when you're up against the wall that you see the mason - You always learn from your mistakes.

Hello tonyynot

Here is the file and the answer to your question

https://www.cjoint.com/?3Kqjfjwpd75

--
Practice makes perfect. - It's when you're up against the wall that you see the bricklayer - you always learn from your mistakes.

Thank you, however, it's impossible for me to follow your instructions because I have version 2007 and not 2003.

So now if you still want to help me, Philou, it's even more complex to further improve the file. I've created a sheet "Daily Results" where I enter the 3 parts that each person has done, from which it calculates the average, the total series (total of the 3 parts), and again I would like to be able to create the ranking based on the results and automatically assign points.

And the best would be for these points to be automatically entered in the table of the "Results" sheet.

I hope I'm clear enough ^^

Thank you for your help if it's possible. After that, I'll be almost at my goal ^^

Here is the link:

http://cjoint.com/?CKqpFcvfkbF

tonyynot

Your modified file

https://www.cjoint.com/?3KqpYJ9Ugdh

--
Practice makes perfect. - It's when you're up against the wall that you see the mason - you always learn from your mistakes.

perfect but what I also wanted was a sort button for the first name and the same for the ranking.

and also the other thing would be to store on another sheet, for example, the best line for each player. and every time they do better, it overwrites the previous data.

thanks again

the modified file

https://www.cjoint.com/?3KqqLYbXwyO

--
Practice makes perfect. - It's when you're up against the wall that you see the mason - one always learns from their mistakes

Thank you, and regarding the best line of each player, is it possible?

Hello

Here is your file with the answers to your questions

https://www.cjoint.com/?3KrmRNC62Ik

Happy using

Philou10120

--
Practice makes perfect. - It's when you hit the wall that you see the mason - you always learn from your mistakes

I looked at the file you sent me back, and I'm a bit lost. In the columns for Dominique, Frédéric, Jean-Pierre, and Manu, there are already values, respectively 20, 20, 17, 20. No matter what values I enter in F8:H23, when I click on 'archives' the points and 'save', these two buttons have the same function of entering the values 20, 20, 17, 20 even though I've input others. Another bug, the 'sort individual ranking' button in the results sheet deletes the entire table... strange.

So, the reasoning is that I enter the scores in F8:H23, then I sort the ranking using the ranking sort button, and then I click on the save button so that the points awarded to each player (20 points for 1st place, 19 for 2nd, 18 for 3rd, etc.) are automatically updated in the "results" sheet.

At the same time, I would like the spreadsheet to keep track of each player's best score from each game, as well as their best streak. If the player does better, it should overwrite the previous data; otherwise, it should not.

Let me know if I need to clarify anything further.

Hello tonyynot

The modified file

https://www.cjoint.com/?3KvkflO2ivE

If you have any problem or question, let me know.

--
Practice makes perfect. - It's when you hit the wall that you see the bricklayer - you always learn from your mistakes.

I looked at the file, and actually, we don't really understand; the thing to keep in archive is the best part (L1 or L2 or L3):

for example, on day 1, the person scores 200 in the best part, on day 2 they score 180, so this doesn’t erase the 200 previously archived. On day 3, the best score is 202, so that erases the 200 to replace it with 202

I would like the same principle for the series

otherwise, two small things on the side:

- is it possible to combine the "archive" button and the "save" button into one single button? Because when I click one, it erases all the data, so I have to re-enter them to click the second one

- on the "results" sheet, the average calculation is done even when a person hasn’t played. For example: Dominique's row, he has only played 2 days, and it divides his points by 4 instead of 2.

It is normal that you do not see 200, because that is what was entered in L1 and these boxes are overwritten after saving.

I will give you a concrete example of what I want, after that the formatting and the number of sheets don't matter.

Player A on 01/01/13 has the lines L1: 180 L2: 190 L3: 200. His series will be: 570 (the sum of the 3).
From then on, both his best line and his best series should be saved, so respectively 200 and 570.
Let's say this player finishes 3rd that night, that would give him 17 points (1st gets 20 points, 2nd gets 19, 3rd gets 18 and so on down to the 20th with 0 points, 21st with 0 points, etc.).

Now player A on 07/01/13 has the lines L1: 150 L2: 150 L3: 210. His series is 510. So for that day, the cell for the best part will be overwritten 200 replaced by 210 and the series is not overwritten because he scored less: 510, the best remains 570.
That night he finishes 5th, which gives him 15 points. So a total of 32 points.

There you go, that's the reasoning. There is not much left for the table to be good.

Hello tonyynot

Here's the beginning of the solution, you need to tell me what I should do with the information about best line, series, and total points?

https://www.cjoint.com/?3Kwkdt9jBKV

--
Practice makes perfect. - It's at the foot of the wall that you see the mason - you always learn from your mistakes.

For the best line and the best series, nothing. I will call on the cells to display them later in a separate table. For the total points, it just needs to be stored on the "result" sheet. And then I will also call on the cells to display them in a separate table.