Southern California
  Kendo Federation    



Home


SCKF 2017 Federation Dues

Pleae read all information below on how to pay federation dues, in particular:

  • instructions for yearly membership submitted in March
  • instructions for membership dues submitted after 3/24/17 ("supplemental")

  • AUSKF dues have increased; see SCKF membership fees page and AUSKF notes
    (note that a new rate for full-time students has been added, as well as an initiation fee for new members)

  • notes on payment
    • payment for your dojo should be submitted in one check written to Southern California Kendo Federation
    • hand your check to Kevin Abe, or mail it to:
      Kevin Abe, 117 E Victoria Ave, Montebello CA 90640
    • the deadline for March dues is 3/24/17

  • dues spreadsheet files (xls) will be handled in google drive (not by email). Each dojo has its own private area in SCKF's google account.
    • files handed out by SCKF to the dojo will be in the "from_sckf" folder
    • files submitted by the dojo to SCKF will be in the "to_sckf" folder

  • instructions for yearly membership submitted in March
    note: below "doj" is used for example purposes; your file will have your own dojo's abbreviation, eg "nor" for Norwalk Dojo
    • copy the file "doj_170225.xls" from the "from_sckf" folder to the "to_sckf" folder
      • update 3/15/17: "doj_170315.xlsx" is also available, and is simpler to use
    • rename it to "doj_170324.xls"
      (for example "nor_170324.xls")
    • edit it as follows
      • for non-returning members, leave row as is (do not delete or move)
      • add members who were not registered at your dojo in 2016 at the bottom.
      • for all returning members and new members
        • please make sure the last name and first name are as the kenshi would wish to see on their menjo
        • if using "doj_170225.xls" as the starting point:
          • enter "4/1/2017" in the "registration day" column
          • use one lowercase "x" to check the appropriate age column: "17 and under", "18 and over" (not full-time student), or "18 and over full-time student"
          • add a 2nd lowercase "x" for initiation fee (required for a new member who does not yet have an AUSKF ID number)
          • enter the "AUSKF fee" amount in column K (see calculation cells in column X at the right side of the spreadsheet). Column K is used to count the number of fill in AUSKF fee amount
        • if using "doj_170315.xls" as the starting point:
          • enter "4/1/2017" to register a member, adding "Y" if full-time student, and the appropriate columns and dollar amounts will autofill
          • see cell highlighting notes (first five bullets under "special notes" on the AUSKF collective registration page)
        • if you make any corrections (eg name spelling or birthdate), please highlight it in green and add a note in the "Comment" column
      • do not add your own formulas, columns, formatting, font, etc
      • for any question-marked fields, please provide more information (eg birthdate or menjo)
    • for each kenshi new to SCKF or who has not yet signed an AUSKF release of liability form
      • collect a signed form and keep it as part of your dojo's records
    • upload any new member menjo files to the "to_sckf" folder with file name "doj_170324_lastname_firstname.ext"
      (for example "nor_170324_doe_john.pdf" or "nor_170324_doe_john.jpg" for Norwalk Dojo new member John Doe's menjo)
    • after saving the file(s) to the "to_sckf" folder
      • send an email to the treasurer (Kevin Abe) and database chair (Jean Kodama) including any relevant notes, such as corrections, menjo files that have been uploaded, menjo translation if not in English, etc.
      • send a dues check payable to "Southern California Kendo Federation" to the treasurer (see top of this page)

  • instructions for membership dues submitted after 3/24/17
    • download a copy of the "supplemental_2017.xlsx" file
    • rename it to "doj_yymmdd.xls", where yymmdd is the year, month, and date of submission, ie the date you will send notification email to the treasurer and database chair
      (for example "nor_170615.xlsx" for Norwalk Dojo update email sent on June 15, 2017)
    • follow the March dues notes for "doj_170315.xlsx" above to:
      • add members to the xls file (enter mm/dd/yy in the "registration day" column)
      • collect release of liability forms
      • upload menjo files
      • upload the doj_yymmdd.xlsx file
      • email the treasurer and database chair
      • send dues payment to the treasurer
    • be sure to submit membership fees within one month of receiving them from your new members

[ SCKF home page     disclaimer ]