Scorecard Templates

Notice:  Starting with GLS v7.0, the scorecard template has been changed slightly.  One new input has been added to accommodate the new "TeeTimes" feature.  This input was placed in an unused location of the template and does not affect your current templates.  If you plan on placing tee times on the scorecards, you will have to insert the location on the template.

A GLS Custom Scorecard Template is actually two files. A Layout File (See Figure 1) (how you want the card to look), and a Template File (See Figure 2)(where everything is placed on the card). Basically, the layout file is a GLS Spreadsheet that contains all the formatting such as borders, colors, font bold, font italic, row height, column width, etc. The template file tells GLS where to place the outputs for the card such as Player Names, Handicaps, Hole Numbers, Week Number, Date, Tick Marks for strokes, etc. The result is an Actual Scorecard (See Figure 3).   Please open and view these files to get an idea of what they are…

Templates have been created for the sample leagues included with GLS. Actually all the scorecards created in GLS use a template and layout, even the standard type. The Template files are located in the "Scorecards\ Template" Folder. The Layout Files are located in the "Scorecards\ Layout" Folder.  GLS custom templates end with the extension .GST or .ST and Layouts end in the extension .GLS (a standard spreadsheet extension).  Templates from previous versions of GLS used the extension ".st."  For backward compatibility, the ".st" extension still works, however, it may be a good idea to re-save, "save as" all the ".st" files with the ".gst" extension.  

The following table shows the standard templates and layouts that are available and 2 custom templates and layouts.

Template Files Layout Files Applies To:
181MNSTD.ST 181MNSTD.GLS 18-hole, Individual Foursomes Std.
181MATCH.ST 181MATCH.GLS 18-hole, Individual Single Matches Std.
18HOLSTD.ST 18HOLSTD.GLS 18-hole, 2 or 4 Person Teams Standard
91MANSTD.ST 91MANSTD.GLS 9-hole, Individual Foursomes Std.
91MATCH.ST 91MATCH.GLS 9-hole, Individual Single Matches Std.
9HOLSTD.ST 9HOLSTD.GLS 9-hole, 2 or 4 Person Teams Standard
LEAG10.ST LEAG10.GLS League # 10 Custom
LEAG9.ST LEAG9.GLS League # 9 Custom

Notice the template name is the same as the layout name, except for the two character extension. It is not required to name both the same, however, it will be easier to select the template and layout you want if both have the same name.

Figure 1 - The Card Layout File

Figure 2 - The Template Form

Figure 3 - The Actual Scorecard created from the Layout and Template Files

Take note from the 3 figures above...  The template tells GLS to put "Player 1 Name" in Row 10, Column 3.  Thus, on the scorecard you'll see the Name "Kent McBride" in that location.  The blue font, font size, font color, and align left was already formatted on the layout.  When the text "Kent McBride was placed in that cell it takes on the formatting of that cell.  Look these figures over carefully to understand how the template and layout file work.

The best way to build a Template is to start with one that is already built. Open a template and a layout and rename them for your league, such as LEAGONE.GST and LEAGONE.GLS. Note: You will have to remember that template files end with .GST so click on File Types and Click on "GLS TEMPLATES," in order to SEE the Template Files in the SAVE AS Dialog Box! Once you have renamed the files and there is no danger of changing the original files, you can begin editing and manipulating the files.

Start with the Layout File. Make the scorecard look the way you want using the formatting capabilities of the GLS spreadsheets. If desired, you could even enter one or more formulas in the scorecard, if for instance, you wanted to do a math calculation on each card. GLS will open a new instance of this layout file for each scorecard it creates and give each a name (Match1.gls, Match2.gls, etc.).

The scorecards are saved to the "Scorecards\ Cards"  Folder. This folder is further divided by League and Week Number. For example, the full path to the League # 1, Week # 1, Match # 1 Scorecard would be "Scorecards\ Cards\ Lg1Wk1\ Match1.gls."  All the scorecards for week 1 would be located in this folder.  This folder can fill up with past scorecard files.  You may want to periodically delete the old folders and scorecard files from this folder from time to time.

Once your layout is complete, print a copy of it including the column and row headers. Make sure the column header labels are numbers instead of letters. You can now create the template file by opening ,renaming and saving a current template file or by clicking on the Template Menu…Create Scorecard Template.

The template file is a list, or form, which contains all the possible items that can be included on a scorecard. Your task is to insert the corresponding Row Number and Column Number of the cell where you want the item to appear on the scorecard layout.  GLS opens this Template file before creating scorecards. Then for each card item it reads the row and column and places the item in that cell. You can experiment and adjust your template and layout files until the scorecards are created the way you want…