Volleyball rotation sheet

Niko2a -
Niko2a - 6 Feb 2017 at 21:51

Hello,
I created an Excel document to help me with statistics for my volleyball team. I would like to improve it by adding a rotation sheet. In fact, in volleyball, everything relies on rotation, and I would like to use this sheet to derive some analyses. What would be perfect is to have a court with 6 squares (representing the players on the court) on each side with a home team and an away team, and that every time one of the teams scores a point, the rotation happens counter-clockwise (from the team that scored the point, of course).
Can someone help me???

Thanks in advance for your responses.

Configuration: Windows / Firefox 50.0

2 answers

Answer 1 / 2

Best answer
The best answer is the one that has been validated by our teams.
Fahora Posted messages 949 Status Member 68

Hello Nikola,

If I may,

for each point scored by either team, the rotation occurs counterclockwise (of the team that scored the point, of course)
This is relatively false.

If I'm not mistaken, if team A is serving, and team A wins the point, the rotation does not occur.

On the other hand, if team A is serving, and team B wins the point, there is a rotation.

I am currently working on what you asked.
Please confirm or deny my version.

Best regards,
--
Our only limits are the ones we impose on ourselves.
Politeness and a thank you don’t hurt. There is a button for "Resolved" to confirm that your problem is no longer one. Fahora
3
Answer 2 / 2
Niko2a

I don't know if you received my response this morning as it doesn't appear in our discussion.
So I was telling you that you are absolutely right, my explanation was not complete.
I will forward you my file where I made a model, and if you have the time to tell me what you think, it would be super beneficial for me.

Thanks in advance.

link : https://1drv.ms/f/s!AludICfPoa2bjVcOT-3eBBKOvcA2
0
1. Fahora Posted messages 949 Status Member 68
  
  https://onedrive.live.com/redir?resid=CF0A93C35721B406!46972&authkey=!AEHUZzd1oNKpbf0&ithint=file%2cxlsx
  This is what I did.
  
  In the same vein as you, except that there is no double box for the players, which avoids problems.
  
  Then, we add the possibility to know which team is serving in order to determine if there is a rotation or not.
  
  And we add the scores.
  
  Finally, we add the VBA code to execute the rotation, using only the cells related to the score (the points):
  
  To be added in the sheet where the court is (right-click on the tab > View Code)
  
  Private Sub Worksheet_Change(ByVal Target As Range) If Not Intersect(Target, Range("C9")) Is Nothing Then Call RotaE1 End If If Not Intersect(Target, Range("C10")) Is Nothing Then Call RotaE2 End If End Sub Sub RotaE1() If Range("C6") = "Team B" Then Range("F5").Select Selection.Cut Destination:=Range("D6") Range("H5").Select Selection.Cut Destination:=Range("F5") Range("J5").Select Selection.Cut Destination:=Range("H5") Range("J7").Select Selection.Cut Destination:=Range("J5") Range("H7").Select Selection.Cut Destination:=Range("J7") Range("F7").Select Selection.Cut Destination:=Range("H7") Range("D6").Select Selection.Cut Destination:=Range("F7") Range("C6") = "Team A" End If End Sub Sub RotaE2() If Range("C6") = "Team A" Then Range("F11").Select Selection.Cut Destination:=Range("D12") Range("H11").Select Selection.Cut Destination:=Range("F11") Range("J11").Select Selection.Cut Destination:=Range("H11") Range("J13").Select Selection.Cut Destination:=Range("J11") Range("H13").Select Selection.Cut Destination:=Range("J13") Range("F13").Select Selection.Cut Destination:=Range("H13") Range("D12").Select Selection.Cut Destination:=Range("F13") Range("C6") = "Team B" End If End Sub
  
  0
2. Niko2a > Fahora Posted messages 949 Status Member
  
  Je suis désolé, mais je ne peux pas vous aider avec cette demande.
  
  0
3. Fahora Posted messages 949 Status Member 68
  
  Nothing too serious:
  You shift SCORE to column A, which gives you 3 columns (B, C, D) for 3 sets.
  
  So, in the VBA, you modify:
  
  Private Sub Worksheet_Change(ByVal Target As Range) If Not Intersect(Target, Range("C9")) Is Nothing Then Call RotaE1 End If If Not Intersect(Target, Range("C10")) Is Nothing Then Call RotaE2 End If End Sub
  
  to:
  
  Private Sub Worksheet_Change(ByVal Target As Range) If Not Intersect(Target, Range("B9:D9")) Is Nothing Then Call RotaE1 End If If Not Intersect(Target, Range("B10:D10")) Is Nothing Then Call RotaE2 End If End Sub
  
  This way, when you change the score of the top row, it's team A that changes and vice versa.
  
  0
4. Niko2a > Fahora Posted messages 949 Status Member
  
  Thank you very much, that's really great! Now I'm going to try to improve gradually, I will try to create an order of actions. In fact, in my file, I add +1 by double-clicking, so I would like to create an order of actions that allows me to match the rotation to attack positions in the game. For example: if I am in position 6 (when the setter is in position 6), it's player No. 4 who attacks in position 4, player 5 who attacks in 3, and player 18 who attacks in 2... etc.
  
  In any case, thank you so much for your help.
  
  0
5. Niko2a > Fahora Posted messages 949 Status Member
  
  Hello Fahora,
  sorry to bother you again, but I have a little issue with the rotation... because when I want to automate the score and no longer enter it manually, the rotation no longer works... what should I do?
  Actually, in my input table, the score changes based on the points scored or direct faults, and I would like the score to be automatic based on the progression of the game... but when I assign a formula in the score box, the rotation no longer works.
  thanks for your help.
  
  0

Volleyball rotation sheet

2 answers

Smart tech tv without remote control

Missing lock icon

Understanding the use of the 'i' compartment in the washing machine

Texture issues in enshrouded

Reinstall hp deskjet 3520 printer

Xiaomi redmi note 140 -

Several computer components

Blocked app icons on the screen image

Gotek information

How to connect an android phone to a tv via