8. Q&A - spreadsheets, formulas, bench, libero change

Every day, Volleystation users actively share their questions and problems with us. We deeply value this open communication, as it helps us better understand the needs of the volleyball community and continuously improve our software. In this article, we've gathered the most frequently asked questions and various issues raised by our users. Here, you'll find answers to many topics, from simple to more complex ones, which will help you use our solutions more effectively.

Q: I have flagged some clips to export, is there a way of just exporting those clips?

A: You can export just flagged clips. When you press Export, click on the color of the flag you want to export. You can select multiple flags and determine if you want plays to fit any of the flags or all of them at the same time. You can also select the order of the clips.

Q: How to put an image into the cell?

A:Select the Image from the taskbar to put the Image into the cell.

You have two possibilities - adding to cells or above. If you decide to Add to cell, you need to merge cells to make it look proper.

Q: How can I see attack directions in spreadsheets without drawing them?

A: For drawing directions without precise arrows, you can use zone arrows visualisation like this:

=VSCOURT("*A","zoneArrows")

or get both drawn and coded attacks by using both arrows and zone arrows:

=VSCOURT("*A","zoneArrows,arrows")

Q: How can I change libero during the game?

A: You should have the libero chosen and drag in the right place when you start the game or the set. If you want to correct it after the game you can do it by adding the new set, choosing the correct libero, approving the lineup, and then just removing this set.

Q: How would I write a formula for nonsetter attack attempts?

A: Here is the formula that counts the attacks that were performed when the ball was set by another player than the setter:

=VSCOUNT(VSAND(VSCELL("(1)A",$B2),"*5E;B-0;NOT"))

If you have multiple setters (let's assume another setter is #1), go for:

=VSCOUNT(VSAND(VSCELL("(1)A",$B2),"*5E;B-0;NOT","*1E;B-0;NOT"))

Q: Why does the bench mode not work?

1. Check if all devices are connected to the same network.

2. If you are using Windows, you need to allow VolleyStation through the firewall. Here you can find instructions on how to do it: https://volleystation.freshdesk.com/support/solutions/articles/103000030665-allowing-vs-through-windows-firewall

3. Don't use the university network - it might be blocking the stream or the bench mode. Use another router instead.