{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Worksheet Instructions","TRAINING EVENT LOG","Menus"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Worksheet Instructions","index":0,"n_rows":30,"n_cols":3,"rows_kept":30,"cut":false,"hidden":false,"merged":[[2,0,9,2],[12,0,12,2],[0,0,0,2],[11,0,11,2]]}
["T&TA Template Introduction"]
[]
["This template was created to assist Weatherization Grantees to easily organize their annual training plan to meet the requirements of Weatherization Program Notice (WPN) 15-4. Once the plan has been approved by your Weatherization Project Officer, the Grantee can continue to use this template throughout the program year to capture key metrics for each completed training course or session. At the end of the program year, the Training & Technical Assistance (T&TA) planning and reporting template can be used to complete the training section (or as an attachment) of the Annual Training, Technical Assistance, Monitoring and Leveraging Report. "]
[]
[]
[]
[]
[]
[]
[]
[]
["Upload completed forms at: https://tdhca.wufoo.com/forms/wap-tta-tracking-form  "]
["Description of Information Fields"]
[]
["Column","Title","Description"]
["A",{"$f":"'TRAINING EVENT LOG'!A1","v":"Training Topic(s)"},"Record the specific topics you plan to offer the attendees, such as:\nASHRAE 62.2\nPolicies and Procedures Updates\nEnergy Auditor comprehensive "]
["B",{"$f":"'TRAINING EVENT LOG'!B1","v":"Training Requested or Initiated by?"},"Choose from the drop down menu. \n\nTo add more options, select box. "]
["C",{"$f":"'TRAINING EVENT LOG'!C1","v":"Training Category"},"Select from the drop down list. \n\nTo add more options, select box."]
["C",{"$f":"'TRAINING EVENT LOG'!D1","v":"Comprehensive or Specific Training?"},"Identify if the training is Comprehensive or Specific based on these definitions:\n\nComprehensive Training: Comprehensive, occupation-specific training which follows a curriculum aligned with the Job Task Analysis (JTA) for that occupation. \n\nSpecific Training: Single-issue, short-term, training to address identified deficiencies in the field or office. Conference training are included in this category\n\nTo add more options, select box."]
["E",{"$f":"'TRAINING EVENT LOG'!E1","v":"Job Task Analysis (JTA)"},"Select from the drop down list. "]
["F",{"$f":"'TRAINING EVENT LOG'!F1","v":"Scheduled Date(s) of Training?"},"Record the planned date or dates for each of the identified trainings."]
["G",{"$f":"'TRAINING EVENT LOG'!G1","v":"Duration of Training (hours)?"},"Record the total numbers of hours that the training session is scheduled for. It is important to include the hours so the total hours can be easily calculated at the end of the grant year.\nIn addition, the Weatherization Assistance Program hopes to compile each Grantee’s total training hours to help demonstrate the program’s workforce development efforts.\n"]
["H",{"$f":"'TRAINING EVENT LOG'!H$1","v":"Continuing Education Unit(s) Offered?"},"When a planned training course offers CEUs, record the number of CEUs that will be offered."]
["I",{"$f":"'TRAINING EVENT LOG'!I$1","v":"Training Center/Provider"},"Identify the training center or trainer that is scheduled to lead the training. \nPlease remember that all Tier 1 trainings much be administered by or in cooperation with a training program that is accredited by a DOE-approved accreditation organization for the JTA being taught."]
["J",{"$f":"'TRAINING EVENT LOG'!J$1","v":"Attendance Mandatory?"},"Indicate if attendance is mandatory or not for the identified workers."]
["K",{"$f":"'TRAINING EVENT LOG'!K$1","v":"Estimated Costs"},"Record the planned budget or costs for the specific training session."]
["L",{"$f":"'TRAINING EVENT LOG'!L$1","v":"Grantee/Subgrantee/Contractor Participating in Training "},"Please identify the Grantee, Subgrantees and/or contractors that participate in the specific training session. We suggest entering the organization’s name and then the total number of employees from that organization in parentheses. \nFor example:\nABLE Agency (4)\nO’Malley and Sons (2)\n(State) Dept. of Energy (2)"]
["M",{"$f":"'TRAINING EVENT LOG'!M$1","v":"Total Number of Participants"},"From the “Grantee/Subgrantee/Contractors Participating in Training” field, add up all of the participants and enter into this field."]
["N",{"$f":"'TRAINING EVENT LOG'!N$1","v":"Actual Costs"},"Enter in the final actual costs for the training once it has concluded."]
["O",{"$f":"'TRAINING EVENT LOG'!O$1","v":"Remarks/Comments"},"This is an open-ended field to provide Grantees the ability to include any details about the training or things to remember for future planning."]

{"sheet":"TRAINING EVENT LOG","index":1,"n_rows":2,"n_cols":15,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Training Topic(s)","Training Requested or Initiated by?","Training Category","Comprehensive or Specific Training?","Job Task Analysis (JTA)","Scheduled Date(s) of Training?","Duration of Training (hours)?","Continuing Education Unit(s) Offered?","Training Center/Provider","Attendance Mandatory?","Estimated Costs","Grantee/Subgrantee/Contractor Participating in Training ","Total Number of Participants","Actual Costs","Remarks/Comments"]
["\"Example\" QCI Training","Onsite Monitoring","Technical","Comprehensive ","QCI","10/9/19 - 10/20/19",80,32,"Weatherization Academy (IREC accredited)","Yes",8000,"ABLE Agency (4)\nCan Do CAA (3)",7,5427,"Contract with trainer approved 7/9/17. All QCI get opportunity for this comprehensive course every 5 years."]

{"sheet":"Menus","index":2,"n_rows":15,"n_cols":3,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,0,3,2],[14,0,17,2]]}
["To add additional drop down choices in the categories, simply enter the additional choice in the blank spaces below in the applicable category"]
[]
[]
[]
["Training Requested or \nInitiated by","Comprehensive or Specific \nTraining ","Training\nCategory"]
["Monitoring Results","Comprehensive ","Technical"]
["Staff Request","Specific","Fiscal"]
["Contractor Request","Other","Programmatic "]
["Customer Complaint",null,"Programmatic/Technical"]
["Program Requirement"]
["TDHCA Mandate"]
[]
[]
[]
["To return to the Worksheet instructions tab. Select box.\n\n"]