{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["HEERF Macro"],"not_rendered":{"charts":0,"images":0,"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":"HEERF Macro","index":0,"n_rows":21,"n_cols":3,"rows_kept":21,"cut":false,"hidden":false,"merged":[[15,2,15,12],[10,2,10,12],[11,2,11,12],[12,2,12,12],[13,2,13,12],[14,2,14,12],[16,2,16,12],[17,2,17,12],[18,2,18,12],[19,2,19,12],[20,2,20,12]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Step 1:","Run the Reports > Report Type: Standard > Annual > HEERF > HEERF Annual Performance Report Form"]
[null,"Step 2:","For reporting in 2022 (2021 data), run with parameters of: 1/1/2021 - 12/31/2021 and as of date of 12/31/2021"]
[null,"Step 3:","Export report to Excel"]
[null,"Step 4:","Click on \"View\" in Excel"]
[null,"Step 5:","Click on \"Macros\" (the upper half of the button)"]
[null,"Step 6:","Select HEERFMacro8ato10a"]
[null,"Step 7:","Click on \"Run\""]
[null,"Step 8:","In order to get info for 10b and 10c, repeat this process but run with the necessary parameters"]
[null,"Step 9:","10b parameters: 1/1/2020-12/31/2020 as of date 12/31/2020"]
[null,"Step 10:","10c parameters: 1/1/2020-12/31/2019 as of date 12/31/2019"]
[null,"Step 11:","For 10b and 10c, data is only required from the final sheet."]