VSLINEUP function

This function call will give you the current match rotation for the home team. This rotation will automatically change when you code a match live.

• =VSLINEUP("*") 

This formula shows the efficiency of the home team in this rotation:

• =VSEFF(VSCELL("*A;(1)", VSLINEUP("*"))) 

This function takes away team attack efficiency and shows it for their next rotation. You can do it by adding the letter N to our filter like this:  

• =VSEFF(VSCELL("aA;(1)", VSLINEUP("aN")))

Here is a formula that shows the lineup after the team rotates three times:

• =VSLINEUP("*N3") 

This formula gets a player's shirt number currently at a given position.  

• =VSLINEUP("*Z3") 

This formula shows the player's position in the next rotation: 

• =VSLINEUP("*Z3N") 

You can also use match and set indexes to get set starting lineup data: 

• =VSLINEUP("*Z2;M1;S2")