AUSKF 2021 Spreadsheet-Based Membership Registration
For AUSKF membership registration, member federations have the choice of using the spreadsheet-based system or having their individual members use the online registration system (https://www.unitedstateskendo.com/). For both methods, the annual membership drive deadline is 3/31/2021.
This page provides instructions for spreadsheet-based registration.
For the annual membership drive (for 2021 membership that runs from 4/1/2021 through 3/31/2022): see detailed Membership Drive Spreadsheet Registration notes below. Brief summary:
Create your federation's initial spreadsheet using 2020 membership
Add "4/1/2021" under "registration day" to register a member;
enter "Y" under "college student" to indicate full time student
Submit the completed password-protected spreadsheet by the annual membership drive deadline
To register members after the annual membership drive deadline, see supplemental registration notes below
If you have any questions, please email email@example.com.
2021 Membership Drive Spreadsheet Registration
Step 1: Download the 2021-AUSKF-Annual-Membership-Form.xlsx
Save the file with the name "FED-2021-AUSKF-Annual-Membership-Form.xlsx" where "FED" is the abbreviation for your federation.
Step 2: Add 2020 membership information to the "2020" tab
Populating the "2020" tab with data from the AUSKF database will promote consistency of data going into 2021. It could also simplify the process at all levels of your federation.
Using federation admin privileges on www.unitedstateskendo.com, download the membership export file for your federation
Transfer data using Microsoft Excel (or compatible spreadsheet application)
Open the export file
Filter on "Registration Date" between 4/1/2020 and 3/31/2021 and sort by "Dojo". Additional sorting within a dojo could include by ID Number or name.
Open the annual form
Cut and paste data for members from the export file to the annual form. Since the column order is different in the two files, this will need to be done in several pieces.
If you would like AUSKF to create a spreadsheet with your federation's 2020 data, please email firstname.lastname@example.org.
Step 3: Add 2021 membership data to the "2021" tab
Here are the instructions for entering your federation's registration for 2021.
Step 4: Submit the completed spreadsheet on or before the annual membership drive deadline
Password-protect your spreadsheet using the same password as in 2020
Upload the file to your federation's DropBox folder
Email email@example.com that the spreadsheet is ready
Mail your membership check to Keiko Umemura, the AUSKF treasurer (who is automatically copied on emails sent to firstname.lastname@example.org)
2020 Supplemental Registration
For 2020 membership registration after the deadline of 4/1/2020:
Alternatively, you can let individuals register online at www.unitedstateskendo.com after completing your federation as explained in at https://www.auskf.org/forms/auskf-membership/auskf-2020-membership-registration-procedure-by-keiko-umemura.
Downloading Membership Information
The instructions below assume familiarity with using admin privileges in the online membership database at www.unitedstateskendo.com.
Using federation admin privileges, download the membership export file for your federation
Open the Admin menu
Choose "Federation List" from the "Federation admin" drop-down
Click on your federation name
Click on "Membership Export File" at the top of the page
Save the export file
The export file may then be used to populate your "2020" annual spreadsheet tab (https://www.auskf.org/forms/auskf-membership/auskf-2020-spreadsheet-based-membership-registration), to look up AUSKF ID numbers assigned to your members, to check your menjo printing request before submitting it to AUSKF, or other usage.
Note: The export file includes data for past and present members of your federation. To view only those who are registered in 2021, sort according to the "Registration Date" column, which reflects the date each person registered for 2021 membership.
You may also use admin privileges to spot check information for individual members (users), edit or check dojo information (dojos), etc. See the https://www.unitedstateskendo.com/Admin/Help pop down pages for more information.