Spreadsheet Templates

Custom GLS Templates can be created for Scorecards and Weekly Reports. You can create a layout of the scorecard or report tailored to your specific reporting requirements.

Other Template Ideas…

You also can copy any GLS  worksheet, a scorecard for instance, and paste into any commercial Windows spreadsheet application, such as Microsoft® Excel®, Lotus® 1-2-3®, and WordPerfect® OuatroPro®. The principles are the same.

How it works? When you copy cells in a GLS worksheet, only the data, or values, are copied. The formatting such as borders, colors, font bold, font italic, row height, column width, etc., are not pasted to the commercial spreadsheet program. Any formatting you create in a GLS spreadsheet or MS Excel worksheet, for example, will act as a Template. The numbers, values, and data will paste directly into this formatted worksheet without changing any formats. As long as the data is pasted into the correct cells, it will take on the format of that cell.

GLS produces standard scorecards and reports that can be used with little or no further formatting. However, if you want to get real fancy, the data will paste nicely into the other applications. Please experiment with this and you will learn to produce some very nice outputs…