Add a Script

To add a script to a cell, press CTRL and click on a cell. Choose Edit script from the pop­up menu. This will open the script edi­tor window.

Fig 111O

Fig 111PAfter a script is added to a cell, the upper left cor­ner of the cell will have a green tri­an­gle in it.

The script­ing lan­guage and com­mands are quite dif­fi­cult to mas­ter, but extreme­ly pow­er­ful. Each com­mand is doc­u­ment­ed in the Help” menu where there is a full web­page devot­ed to it, or go to:

div class=”page” title=”Add a Script”>

Copy and Paste Rows and Columns with Scripts

Hold down OPTION and click and drag on the row num­ber. This will cre­ate a dupli­cate row or col­umn with all the scripts includ­ed. This is quite a time saver when cre­at­ing rows or columns that will have the same data in them like play­er statistics.

Use Cell References

Use a cell as a data place hold­er for script ref­er­enc­ing. Setup a col­umn where the play­er names are inputted, then ref­er­ence this col­umn by its name or coor­di­nates in a script. This makes chang­ing data very easy because it can be changed in the cell, not the script.

In the script, cre­ate a vari­able that reads the ref­er­ence cell’s data. $play­er­name = cell(“Player”,$row)
show count Handball” where row = $play­er

Screen Shot 2015-05-22 at 8.22.09 amThis vari­able will look to the play­er col­umn in the same row and use this data in the script. By typ­ing A.McGrath into the Player col­umn cell, the script finds how many Handballs there were in the A.McGrath time­line row.

Copy to Excel

Data being dis­played in the cells of a sta­tis­ti­cal win­dow can be copied into Excel or any oth­er spread­sheet pro­gram. Hold down COMMAND and click in the cell, then press COMMAND+C to copy the data to the clip­board. COMMAND+V will paste the data in the oth­er appli­ca­tion. A group of cells can be select­ed by hold­ing down COMMAND, click in top left cell, then click in the bot­tom right cell of the group of cells to be copied.