Creating Tariff Sheets

Level 7 and 8 Tariff Sheets

First things First

The Tariff Sheets are Microsoft Excel Windows spreadsheets.

Click here to download the Tariff Sheet templates.

Level  7 and 8 Tariff Sheets

First download the tariff sheet templates and save them to a folder on your computer. Recommend a folder labeled tariff sheet templates.

  1. Open the tariff sheet template for the Level and event you would like to create.
  2. Fill out Information: Club Abbrev, Club Full Name, Competition, Pair/Group ID, Athlete Names, Age Group, Coach, Coach Phone #, Coach Email.

For Level 7 and 8 tariff sheets you will click on the skill to the right of the margin and drag the skill over to the appropriate box.

You are now ready to save the tariff sheet to your computer.  You need to use the following nomenclature.  Click File Save As and select the Excel 97-2003 compatible format if you are using Excel 2007, 2010 or 2013.  This is very important as not everyone has version 2007 or above.  Recommend creating a folder for each meet of the season and saving all tariff sheets for each meet into this folder.

File Name: Example

MAATT_145C_L6WP_Smith,Devonshire_AE_A.xls

Club Name
Pair/Group  ID and Routine Abbreviation
Level and Event
Last Name Top, Middle, Base
Abbreviation of club hosting meet
Revision of tariff sheet

Click here for Uploading and revising tariff sheets.

 

Level 9,10, Jr. Elite 12-18, Jr. Elite 13-19, and Senior Elite Optional Tariff Sheet

Click here to download the USA Optional tariff sheet template and save to a folder on your computer.

  1. Fill out Information: Club Abbrev, Club Full Name, Competition, Pair/Group ID, Athlete Name, Age Group, Coach, Coach Phone #, Coach Email.
  2. Note: The USA optional tariff sheet is designed to meet the FIG requirements as well as USA.
  3. Create Tariff Sheet using images from FIG Tables of Difficulty, World Age Group Competition Compulsory Elements Table, USAG Code of Points.  See Skill Image source Table and Computer Drawn Tariff Sheet Creation Tools along with the Training Videos.
  4. You are now ready to save the tariff sheet to your computer.  You need to use the following nomenclature.  Click File Save As and select the Excel 97-2003 compatible format if you are using Excel 2007, 2010 or 2013.  This is very important as not everyone has version 2007 or above.  Recommend creating a folder for each meet of the season and saving all tariff sheets for each meet into this folder.

File Name: Example

AE_245C_L8WP_Crowder,Jones_RSAC_A.xls

Club Name
Pair/Group  ID and Routine Abbreviation
Level and Event
Last Name Top, Middle, Base
Abbreviation of club hosting meet
Revision of tariff sheet

 The file name will automatically print on tariff sheet.