VolleyStation Pro offers powerful tools for volleyball analysts, coaches, and enthusiasts to turn match data into meaningful insights. One of the most versatile features of the platform is its custom spreadsheet functionality, which allows users to build, analyze, and visualize performance data using specialized formulas tailored to volleyball-specific events. Whether you're tracking team trends, evaluating individual players, or preparing strategic reports, learning how to effectively use spreadsheets in VolleyStation Pro is essential. This guide walks you through the process of creating a new spreadsheet, using built-in formulas, applying filters, and customizing your data presentation—helping you make the most of your match analysis.
Creating a New Spreadsheet in VolleyStation Pro
To create a new spreadsheet in VolleyStation Pro, go to the Spreadsheets section from the menu on the left. Then, click the blue Add Spreadsheet button in the top-right corner of the screen.
A new spreadsheet will be generated and ready for use. Enter a title in the field above the spreadsheet to name it. From there, you can begin inputting formulas into the cells to calculate and display the data you need.
To analyze specific seasons, teams, and games within this spreadsheet, simply click on the grey area located below the title box. You can select multiple games at once for a broader analysis.
To export your spreadsheet, click the blue XLSX button in the top right corner. If you've made any changes and wish to save them, be sure to click the blue Save button—also located in the top right.
To add a spreadsheet to the bench, just tick the checkbox on the left side.
VolleyStation Pro supports a variety of special functions and filters, allowing you to build complex and useful formulas tailored to your requirements.
The formulas are created like this: = VSCOUNT("*1R")
Parentheses indicate where the VSCOUNT function starts and ends.
The quotation marks contain the play code from VolleyStation. The tutorial contains all functions and explanations of how to use them. You need to know all the essential functions when you start building the spreadsheet. There are also many examples of how and when to use them.
BASIC FORMULAS
VSCOUNT - returns the number of plays
= VSCOUNT("*A") - counts all the attacks of the home team
VSPER - returns the percentage of plays with this effect
=VSPER("*A#") - returns the percentage of kill attacks of the home team
VSEFF - that will return the efficiency of plays
= VSEFF("*2S") - shows the efficiency of the serve of player number two
LOGIC FUNCTIONS
VSAND - is the logic function where all given conditions must be fulfilled.
=VSCOUNT(VSAND("*A", “*R;B-0")) - counts all side-out attacks of the home team
VSOR- is the logic function where any of the given conditions must be fulfilled
=VSPER(VSOR("*R#", “*R+")) - returns the percentage of the positive reception of the home team
PLAYERS AND TEAM FUNCTION
VSPLAYER - returns the player's number and the team's prefix
= VSPLAYER(“*1i")
= VSPLAYER(“a1i”)
It is possible to add the role of the player like this:
=VSPLAYER("*1i","libero")
Setter, opposite, outside, middle, libero
VSPLAYERNAME - returns the player's name. You can use it with the VSPLAYER function.
VSTEAMNAME - returns the name of the team. You have to put the home or away team symbol in parenthesis.
= VSTEAMNAME("*")
VSSETCOUNT - returns the player's number of sets played
=VSSETCOUNT("*") - counts sets played by the team
=VSSETCOUNT("*12") - counts sets played by the player number 12
VSLINEUP - function will give you the current match rotation for the home team
=VSLINEUP("*") - gives the current match rotation for the home team. This rotation will automatically change when you code a match live.
=VSLINEUP("*N3") - shows the lineup after the team rotates three times.
=VSLINEUP("*Z3") - gets a player's shirt number currently at a given position.
VSCOURT - =VSCOURT("code", "visualization", "start","end", size,”print")
Visualization type: zonearrows, subzones, arrows, heatmap
= VSCOURT("*9S", 1.5) - displays all serves by player #9 from the home team and enlarges the court (scaled by 1.5).
= VSCOURT("*9S", “heatmap”, 1.5) - creates a heatmap of all serves by player #9 from the home team and scales the court to 1.5x its original size.
= VSCOURT("*9A", “heatmap”, “start”, “end”, 1.5) - generates a heatmap of all attacks by player #9 from the home team, shows both start and end points, and resizes the court
.
= VSCOURT("*9A", “heatmap,#”, 1.5) - displays a heatmap of all attacks by player #9 from the home team, highlights kill attacks, and scales the court to 1.5x.
=VSCOURT("*9A90","heatmap,arrows","flipped",1.5) - creates a court showing the heatmap and direction arrows for all back-row attacks by player #9 from the home team, flips the court view, and resizes it.
=VSCOURT("*9S","heatmap",1.5, “print”) - generates a court with a heatmap of all serves by player #9 from the home team, adjusts the court size, and creates a black-and-white print version.
How to go to the video from a spreadsheet?
Spreadsheets Filters
You can apply multiple filters in a single formula by separating them with a semicolon:
Surrounding play filters (they are used with VSAND function):
B - ball possession (B-0 means "in same ball possession")
= VSCOUNT(VSAND(“*A","*R;B-0")) - counts all home team attacks after reception (first ball).
P - play (P-2 means: two plays before)
=VSCOUNT(VSAND(“*A#","*R;P-2")) - counts all home team attacks after reception (first ball).
R - rally (R-1 means: one rally before)
=VSPER(VSAND("*A#", “*A=;R-1")) - counts all home team attacks when in the rally, before there were attack errors.
Rotation filters
*Z(number)- home team rotation
= VSPER(VSAND(“*A#;*Z1","*R;B-0")) - counts all kill home team attacks after reception in first rotation.
aZ(number)- away team rotation
Player filters
PZ(number)- player in the zone
=VSCOUNT(“*4A;PZ432") - gives all attacks of player #4 from the home team when that player was in the front row.
*PS(number)- setter on court
=VSPER(“*A#;*PS2") - counts all home team kill attacks when setter #2 was on court.
*PC(numbers)- players on court
=VSCOUNT(“*B#;*PC17") - counts all home team stuff blocks when player #17 was present on the court.
*PO(numbers)- players on court in particular order (first mentioned player is setter)
=VSCOUNT(“*A=;*PO2,9,23") - counts all home team attack errors when on court were setter #2 and players #9 and #23.
Match and set filters
PA*:*- point advantage (from: to)
=VSCOUNT("*A=;PA2:*") - counts all attacks when the home team leads by 2 points or more.
•PR*:* - point range (from: to)
=VSPER("*A#;PR20:*") - counts all home team kill attacks after the 20th point.
S(number)- set number (for the last set, we can use L)
=VSCOUNT("*B#;S1") - counts all stuff blocks in the first set.
M(number)- filters by the number of games from the list of analyzed games
=VSCOUNT("*4A#;M1") - counts all kill attacks of player #4 from the home team in the latest game from the list of analyzed games.
W i L – filters plays by won and lost rallies or sets (n.p. WR-0, LS-0)
=VSCOUNT("*R-;WR-0") - counts all negative receptions in won rallies.
=VSCOUNT("*9A#;LS-0") - counts all kill attacks of player #9 from the home team in lost sets.
MORE PROFOUND FORMULAS
=VSCOUNT(VSAND(“*AT40#,H1”,”*RQ60;B-0","*K1F3;P-1"))
This formula counts kill attacks, executed from zone 4, off a quick set, against a single block, during a rally following the reception of a jump serve in zone 6, when the ball was set from zone 3 to zone 4, while the setter call was K1.
=VSPER(VSAND(“*A20,T3”,"*K73C",VSOR("*4R-;B-0","*4R-;B-0"), VSOR("aSM65;B-1", "aSM67;B-1")))
This formula counts tips executed from zone 2, against a triple block, during a rally following a poor reception by player #4 of a float serve delivered from zone 6 to zones 5 or 7, when the ball was set from zone 3C, while the setter call was K7.
SPREADSHEET FORMATTING
CONDITIONAL FORMATTING
If you want to highlight certain data—like the best or worst results, or values higher or lower than a number — you can use Conditional Formatting. This tool changes the color of cells based on the rules you set. To use it, first select the cells you want to format, then go to the "Edit" section and choose "Conditional format". From there, you can pick the rule and style that fits your needs.
Then it would be best if you chose the style that you want to use, a condition that must be fulfilled.
We can choose values:
greater
less
greater or equal
less or equal
equal
not equal
between
not between
There are also text functions:
contains
not contains
begins with
not begins with
ends with
not ends with
Creating and using spreadsheets in VolleyStation Pro opens up a wide range of possibilities for in-depth match analysis. From basic play counts to complex logic-based formulas, the platform provides the flexibility to track and visualize nearly every aspect of a game. With powerful functions, customizable filters, and formatting tools, users can tailor their spreadsheets to suit any analytical need. To help you get started, VolleyStation Pro includes a default spreadsheet called "Tutorial", which contains practical examples and explanations of commonly used functions and formulas. By exploring this resource and mastering the available tools, you can transform raw data into actionable insights that support better performance and strategic decisions.
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article