{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Instructions","Subrecipient","1 Contractor","2 Contractor","3 Contractor","4 Contractor","5 Contractor","6 Contractor"],"not_rendered":{"charts":0,"images":37,"macros":1,"external_links":0,"defined_names":0,"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":"Instructions","index":0,"n_rows":21,"n_cols":1,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["Instructions:"]
[]
["The Department is required to track and report certified WAP staff to our federal partners.  Subrecipients will need to complete, maintain, and upload this workbook by June 30th annually. This Excel Workbook is to be uploaded through this Form: https://tdhca.wufoo.com/forms/weatherization-professional-certification-form "]
[]
["Only complete fields highlighted in yellow. "]
[]
["Subrecipient Tab:"]
["1. Enter your Subrecipient Name and date. These fields will then pre-populate to all other tabs"]
["2. Indicate if your agency has a clear separation of duties between QCI staff and assessment/audit duties, by selecting \"yes\" or \"no\""]
["3. Indicate if your agency is a Lead Safe Certified Firm, by selecting \"yes\" or \"no\" and provide the expiration date"]
["4. List ALL WAP staff on this tab by completing columns A-D; which consists of their name, phone number, email address, and responsibilities. For staff who hold certification(s), indicate the certification type(s) with the certification(s) expiration date. Use the drop-down boxes provided"]
[]
["Contractor Tab: Complete a workbook page for each Contractor used for WAP"]
["1.  Provide contractor name"]
["2. Indicate if this contractor is a Lead Safe Certified Firm? Check either \"Yes\" or \"No\" and provide the expiration date"]
["3. Use the dropdown box to select the type of contractor"]
["4. List ONLY Certified contractor staff. Provide their name, phone, email address, responsibilities, certification type(s) with the certification(s) expiration date"]
[]
[]
[]
["2022-04-25"]

{"sheet":"Subrecipient","index":1,"n_rows":120,"n_cols":32,"rows_kept":120,"cut":false,"hidden":false,"merged":[[0,0,0,9],[1,1,1,7],[6,0,8,0],[6,1,8,1],[6,2,8,2],[6,3,8,3],[2,1,2,7],[3,5,3,7],[3,1,3,2],[10,0,12,0],[10,1,12,1],[10,2,12,2],[10,3,12,3],[14,0,16,0],[14,1,16,1],[14,2,16,2],[14,3,16,3],[18,0,20,0],[18,1,20,1],[18,2,20,2],[18,3,20,3],[22,0,24,0],[22,1,24,1],[22,2,24,2],[22,3,24,3],[26,0,28,0],[26,1,28,1],[26,2,28,2],[26,3,28,3],[30,0,32,0],[30,1,32,1],[30,2,32,2],[30,3,32,3],[34,0,36,0],[34,1,36,1],[34,2,36,2],[34,3,36,3],[38,0,40,0],[38,1,40,1],[38,2,40,2],[38,3,40,3],[42,0,44,0],[42,1,44,1],[42,2,44,2],[42,3,44,3],[46,0,48,0],[46,1,48,1],[46,2,48,2],[46,3,48,3],[58,0,60,0],[58,1,60,1],[58,2,60,2],[58,3,60,3],[50,0,52,0],[50,1,52,1],[50,2,52,2],[50,3,52,3],[54,0,56,0],[54,1,56,1],[54,2,56,2],[54,3,56,3]]}
["Subreciepient Information"]
["Subrecipient Name:",null,null,null,null,null,null,null,"Date:","2022-03-07"]
[null,"Does your agency have a clear separation of duties in which QCI staff does not perform assessment/Audit related activities?"]
[null,"Is your agency a Lead Safe Certified Firm?",null,"Expiration Date:"]
[]
["Subrecipient Staff Name","Direct Phone OR Phone w/extension","Email","Staff Responsibilities","Certification Type","Expiration Date","Certification Type","Expiration Date","Certification Type","Expiration Date"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Manager","","BPI EA Certified","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Office","","BPI QCI Certified","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Field","","Multi-Family QCI Certified","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Combination","","Lead Safe Renovator Certified"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","OSHA 10"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","OSHA 30"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","BPI Crew Leader Certified"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","Retrofit Installer Certified"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","BPI Building Analyst (BA)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Owner","",null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Manager",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Office","",null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Field",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Combination"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"1 Contractor","index":2,"n_rows":12,"n_cols":32,"rows_kept":12,"cut":false,"hidden":false,"merged":[[19,0,21,0],[19,1,21,1],[19,2,21,2],[19,3,21,3],[3,5,3,6],[11,0,13,0],[11,1,13,1],[11,2,13,2],[11,3,13,3],[15,0,17,0],[15,1,17,1],[15,2,17,2],[15,3,17,3],[0,0,0,9],[1,1,1,7],[2,1,2,7],[7,0,9,0],[7,1,9,1],[7,2,9,2],[7,3,9,3]]}
["Subrecipient Contractor Information",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[{"$f":"Subrecipient!A2","v":"Subrecipient Name:"},{"$f":"Subrecipient!B2:H2","v":0},null,null,null,null,null,null,"Date:",{"$f":"Subrecipient!J2","v":"2022-03-07"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"General (completes all work)","General (completes all work)","Owner","","BPI EA Certified"]
["Contractor Company Name",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HVAC (Mechanical)",null,"Manager","","BPI QCI Certified",null,null,""]
["LEAD Certified Firm",null,"Expiration Date:",null,"TYPE of Contractor:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Electrical",null,"Office","","Multi-Family QCI Certified"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Plumbing",null,"Field","","Lead Safe Renovator Certified"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Combination",null,"OSHA 10"]
["Contractor Staff Name (only if certified)","Direct Phone OR Phone w/extension","Email","Responsibilities","Certification Type","Expiration Date","Certification Type","Expiration Date","Certification Type","Expiration Date",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OSHA 30"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BPI Crew Leader Certified"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Retrofit Installer Certified"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BPI Building Analyst (BA)",""]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"2 Contractor","index":3,"n_rows":12,"n_cols":32,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,0,0,9],[1,1,1,7],[2,1,2,7],[3,5,3,6],[7,0,9,0],[7,1,9,1],[7,2,9,2],[7,3,9,3],[19,0,21,0],[19,1,21,1],[19,2,21,2],[19,3,21,3],[11,0,13,0],[11,1,13,1],[11,2,13,2],[11,3,13,3],[15,0,17,0],[15,1,17,1],[15,2,17,2],[15,3,17,3]]}
["Subrecipient Contractor Information",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,""]
[{"$f":"Subrecipient!A2","v":"Subrecipient Name:"},{"$f":"Subrecipient!B2:H2","v":0},null,null,null,null,null,null,"Date:",{"$f":"Subrecipient!J2","v":"2022-03-07"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"General (completes all work)","General (completes all work)","Owner","","BPI EA Certified","",null,""]
["Contractor Company Name",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HVAC (Mechanical)",null,"Manager","","BPI QCI Certified","",null,""]
["LEAD Certified Firm",null,"Expiration Date:",null,"TYPE of Contractor:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Electrical",null,"Office","","Multi-Family QCI Certified"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Plumbing",null,"Field","","Lead Safe Renovator Certified"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Combination",null,"OSHA 10"]
["Contractor Staff Name (only if certified)","Direct Phone OR Phone w/extension","Email","Responsibilities","Certification Type","Expiration Date","Certification Type","Expiration Date","Certification Type","Expiration Date",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OSHA 30"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BPI Crew Leader Certified"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Retrofit Installer Certified"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BPI Building Analyst (BA)","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"3 Contractor","index":4,"n_rows":12,"n_cols":32,"rows_kept":12,"cut":false,"hidden":false,"merged":[[19,0,21,0],[19,1,21,1],[19,2,21,2],[19,3,21,3],[3,5,3,6],[11,0,13,0],[11,1,13,1],[11,2,13,2],[11,3,13,3],[15,0,17,0],[15,1,17,1],[15,2,17,2],[15,3,17,3],[0,0,0,9],[1,1,1,7],[2,1,2,7],[7,0,9,0],[7,1,9,1],[7,2,9,2],[7,3,9,3]]}
["Subrecipient Contractor Information",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,""]
[{"$f":"Subrecipient!A2","v":"Subrecipient Name:"},{"$f":"Subrecipient!B2:H2","v":0},null,null,null,null,null,null,"Date:",{"$f":"Subrecipient!J2","v":"2022-03-07"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"General (completes all work)","General (completes all work)","Owner","","BPI EA Certified","",null,""]
["Contractor Company Name",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HVAC (Mechanical)",null,"Manager","","BPI QCI Certified","",null,""]
["LEAD Certified Firm",null,"Expiration Date:",null,"TYPE of Contractor:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Electrical",null,"Office","","Multi-Family QCI Certified"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Plumbing",null,"Field","","Lead Safe Renovator Certified"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Combination",null,"OSHA 10"]
["Contractor Staff Name (only if certified)","Direct Phone OR Phone w/extension","Email","Responsibilities","Certification Type","Expiration Date","Certification Type","Expiration Date","Certification Type","Expiration Date",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OSHA 30"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BPI Crew Leader Certified"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Retrofit Installer Certified"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BPI Building Analyst (BA)","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"4 Contractor","index":5,"n_rows":12,"n_cols":32,"rows_kept":12,"cut":false,"hidden":false,"merged":[[19,0,21,0],[19,1,21,1],[19,2,21,2],[19,3,21,3],[3,5,3,6],[11,0,13,0],[11,1,13,1],[11,2,13,2],[11,3,13,3],[15,0,17,0],[15,1,17,1],[15,2,17,2],[15,3,17,3],[0,0,0,9],[1,1,1,7],[2,1,2,7],[7,0,9,0],[7,1,9,1],[7,2,9,2],[7,3,9,3]]}
["Subrecipient Contractor Information",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,""]
[{"$f":"Subrecipient!A2","v":"Subrecipient Name:"},{"$f":"Subrecipient!B2:H2","v":0},null,null,null,null,null,null,"Date:",{"$f":"Subrecipient!J2","v":"2022-03-07"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"General (completes all work)","","Owner","","BPI EA Certified","",null,""]
["Contractor Company Name",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HVAC (Mechanical)",null,"Manager","","BPI QCI Certified","",null,""]
["LEAD Certified Firm",null,"Expiration Date:",null,"TYPE of Contractor:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Electrical",null,"Office","","Multi-Family QCI Certified"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Plumbing",null,"Field","","Lead Safe Renovator Certified"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Combination",null,"OSHA 10"]
["Contractor Staff Name (only if certified)","Direct Phone OR Phone w/extension","Email","Responsibilities","Certification Type","Expiration Date","Certification Type","Expiration Date","Certification Type","Expiration Date",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OSHA 30"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BPI Crew Leader Certified"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Retrofit Installer Certified"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BPI Building Analyst (BA)","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"5 Contractor","index":6,"n_rows":12,"n_cols":32,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,0,0,9],[1,1,1,7],[2,1,2,7],[3,5,3,6],[7,0,9,0],[7,1,9,1],[7,2,9,2],[7,3,9,3],[19,0,21,0],[19,1,21,1],[19,2,21,2],[19,3,21,3],[11,0,13,0],[11,1,13,1],[11,2,13,2],[11,3,13,3],[15,0,17,0],[15,1,17,1],[15,2,17,2],[15,3,17,3]]}
["Subrecipient Contractor Information",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,""]
[{"$f":"Subrecipient!A2","v":"Subrecipient Name:"},{"$f":"Subrecipient!B2:H2","v":0},null,null,null,null,null,null,"Date:",{"$f":"Subrecipient!J2","v":"2022-03-07"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"General (completes all work)","","Owner","","BPI EA Certified","",null,""]
["Contractor Company Name",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HVAC (Mechanical)",null,"Manager","","BPI QCI Certified","",null,""]
["LEAD Certified Firm",null,"Expiration Date:",null,"TYPE of Contractor:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Electrical",null,"Office","","Multi-Family QCI Certified"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Plumbing",null,"Field","","Lead Safe Renovator Certified"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Combination",null,"OSHA 10"]
["Contractor Staff Name (only if certified)","Direct Phone OR Phone w/extension","Email","Responsibilities","Certification Type","Expiration Date","Certification Type","Expiration Date","Certification Type","Expiration Date",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OSHA 30"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BPI Crew Leader Certified"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Retrofit Installer Certified"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BPI Building Analyst (BA)","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"6 Contractor","index":7,"n_rows":12,"n_cols":32,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,0,0,9],[1,1,1,7],[2,1,2,7],[3,5,3,6],[7,0,9,0],[7,1,9,1],[7,2,9,2],[7,3,9,3],[19,0,21,0],[19,1,21,1],[19,2,21,2],[19,3,21,3],[11,0,13,0],[11,1,13,1],[11,2,13,2],[11,3,13,3],[15,0,17,0],[15,1,17,1],[15,2,17,2],[15,3,17,3]]}
["Subrecipient Contractor Information",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,""]
[{"$f":"Subrecipient!A2","v":"Subrecipient Name:"},{"$f":"Subrecipient!B2:H2","v":0},null,null,null,null,null,null,"Date:",{"$f":"Subrecipient!J2","v":"2022-03-07"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"General (completes all work)","","Owner","","BPI EA Certified","",null,""]
["Contractor Company Name",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HVAC (Mechanical)",null,"Manager","","BPI QCI Certified","",null,""]
["LEAD Certified Firm",null,"Expiration Date:",null,"TYPE of Contractor:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Electrical",null,"Office","","Multi-Family QCI Certified"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Plumbing",null,"Field","","Lead Safe Renovator Certified"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Combination",null,"OSHA 10"]
["Contractor Staff Name (only if certified)","Direct Phone OR Phone w/extension","Email","Responsibilities","Certification Type","Expiration Date","Certification Type","Expiration Date","Certification Type","Expiration Date",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OSHA 30"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BPI Crew Leader Certified"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Retrofit Installer Certified"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BPI Building Analyst (BA)","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]