{"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":33,"n_cols":3,"rows_kept":33,"cut":false,"hidden":false,"merged":[[2,0,9,2],[14,0,14,2],[0,0,0,2],[10,0,11,2],[12,0,12,2],[13,0,13,2]]}
["T&TA Template Introduction"]
[]
["This template was developed to help the Weatherization Assistance Program (WAP) efficiently organize their annual training plan in compliance with Weatherization Program Notice (WPN) 22-4. The Texas Department of Housing and Community Affairs (TDHCA) adopted this form as a tool to track current, historical, and upcoming trainings. It is important to update the template regularly as training sessions are initiated and completed, ensuring that key Training and Technical Assistance (T&TA) metrics are recorded throughout the program year.\n\nIn line with WPN 22-4, field workers must receive comprehensive, occupation-specific training on a regular basis, with curriculum aligned to the topics identified in Job Task Analyses (JTAs). TDHCA staff will monitor training compliance throughout the contract terms, while subgrantees should proactively identify training needs during the approval period. TDHCA reserves the right to mandate specific trainings if/when repetitive issues are identified during monitoring visits."]
[]
[]
[]
[]
[]
[]
[]
["Upload Initial & Completed Forms No Later than August 15th of Each Program Year (See Link Below) "]
[]
["https://tdhca.wufoo.com/forms/wap-doe-annual-tta-tracking-form-initial-final/"]
["Final Submssion Notes: The total expenditures for DOE and DOE-BIL should be equial to (or less) than what is listed on June's MER Expenditure Report. Please do your best to capture all expenses related to the training as they occur. "]
["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: (Be as descriptive as possible) \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)/(days)"},"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":"Participation Method? "},"Select \"How\" the staff member participated in the training. "]
["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:\nSubcontractor Staff (4)\nSubrecipient Staff (2)\nAdministrative Staff (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. This can potentially include travel costs, salaries, along with the registration of completed training. "]
["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."]
["P","Funding Source","Select the appropriate funding source that covered the T&TA (Training and Technical Assistance) topic or training. Your options are: DOE-Annual or DOE-BIL. Note: When cost allocation methods are applied, it's possible for the same training to appear listed more than once. "]

{"sheet":"TRAINING EVENT LOG","index":1,"n_rows":6,"n_cols":16,"rows_kept":6,"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)/(days)","Continuing Education Unit(s) Offered?","Training Center/Provider","Participation Method? ","Estimated Costs","Grantee/Subgrantee/Contractor Participating in Training ","Total Number of Participants","Actual Costs","Remarks/Comments","Funding Source "]
["QCI Training","Program Requirement","Technical","Comprehensive ","QCI","7/1/2024-7/2/2024",80,"Yes","Weatherization Academy (IREC accredited)","In-Person",8000,"Subrecipient Staff (4)",5,{"$f":"K2*0.35","v":2800},"All QCI get opportunity for this comprehensive course every 5 years. Since 2020 we have sent (4) Wx Staff members to renew/receive QCI training. Avg. Cost was about $1,500 per person. ","DOE-Annual"]
["QCI Training","Program Requirement","Technical","Comprehensive ","QCI","7/1/2024-7/2/2024",80,"Yes","Weatherization Academy (IREC accredited)","In-Person",8000,"Subrecipient Staff (5)",5,{"$f":"K3*0.65","v":5200},"All QCI get opportunity for this comprehensive course every 5 years. Since 2020 we have sent (4) Wx Staff members to renew/receive QCI training. Avg. Cost was about $1,500 per person. ","DOE-BIL "]
["Weatherization Boot Camp","Contractor Request","Technical","Comprehensive ","QCI","10/1/2024-10/06/2024","4-Day","Yes","Southwest Building Science Training Center (IREC accredited)","In-Person",8500,"Subcontractor Staff Members (4)\nSubrecipient Staff (3)",7,8250.5,"Course covered Energy Basics, General Thermal Performance, Pressure Diagnostics 101, Health & Safety 101. Class was at the suggestion of Wx Staff members to help Contractor identify A.I. opportunities. ","DOE-BIL "]
["Cost Allocation and Indirect Cost Rates","Monitoring Results","Financial","Specific ","N/A","2024-12-01","1-Day","No","Feldsman Leifer LLP","Virtual",{"$f":"175*5","v":875},"WAP/Administrative Staff (5)",5,875,"Cost Allocation Refresher to meet CFR 200 requirements due to monitoring results. ","DOE-Annual"]
["Vent to Daylight Skill Training","Staff Request","Technical","Comprehensive ","RIT","03/02/24-03/05/24","2-day","Yes","Louisiana Housing Corporation (IREC accredited)","In-Person",{"$f":"400*4","v":1600},"Subcontractor Staff Members (2)\nSubrecipient Staff (2)",4,2250.75,"Weatherization field staff and subcontractors participated in training focused on meeting ventilation requirements and deepening their understanding of how ventilation impacts residential homes. Training was successful, would recommend doing again.  ","DOE-BIL "]

{"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"]