This sample calculator is provided as a guide only and is not to be used or taken as professional advice, including legal advice. It should not be assumed 
         that the calculator is comprehensive or that it provides a definitive answer in every case. In the event of any discrepancy in calculated figures the 
        official calculation as provided for in the operational phase is the authoritative one. The CSV calculator allows for multiple employments based on 
                                Revenue provided CSV file. 
           >
           >
           >
       To use the CSV - Sample Calculator:
         1
         2
         3
         4
         5
         6
         7
      CSV - Sample Subsidy Calculator V1.0
 This sample calculator is provided as a guide only and is not to be used or taken as professional advice, including legal advice. It should not be assumed 
  that the calculator is comprehensive or that it provides a definitive answer in every case. In the event of any discrepancy in calculated figures the 
  official calculation as provided for in the operational phase is the authoritative one. The CSV calculator allows for multiple employments based on 
                            Revenue provided CSV file. 
      This spreadsheet - The "CSV file based Sample Subsidy Calculator" demonstrates how multiple employees' 
      subsidies can be calculated during the Operational Phase of the Temporary Wage Subsidy Scheme using a CSV file 
      download from Revenue.
      See "CSV - Calculator Examples" for usage examples using the sample CSV and examples in the Appendix of the Guidance FAQ
      Detailed guidance on the scheme is available at www.revenue.ie/en/news/articles/guidance-on-the-temporary-
      covid-19-wage-subsidy-scheme.aspx
 To use the CSV - Sample Calculator:
      Determine if the Employer is eligible to operate the scheme.  See FAQ 2.4
      Determine if the Employee is eligible for the subsidy.  See FAQ 3.1
      Ensure that all the orange cells in the "CSV Subsidy Calculator" sheet are blank.
      Download the CSV from ROS (See Appendix A2 in the FAQ guidance)
      Double click on the downloaded CSV file to open it. You will see data for all your active employees.
      Select the contents of the file ( you cannot use the Excel shortcut of selecting the whole worksheet) making
      sure to bring in all the content e.g. Select A1:T50.  There can be content in columns A to T.
      DO NOT EDIT the contents of the CSV file.  Revenue will calculate the refunds to the employer based on the information
      on Revenue's systems, if the employer makes a subsidy payment based on edited CSV figures then they may receive a reduced, or no, refund.
      Paste (paste values works best) the CSV file contents so that cell A1, from the downloaded CSV file, pastes into cell L5 of the "CSV subsidy calculator" sheet
      If you get an error starting with "The cell or chart you are trying to change" or other protection related error then you may
      be pasting into the wrong location or have selected more too many columns from the CSV
      Review each employee and enter the optional Employer's Additional Gross Payment amount in column E, in the orange cells.
      If the employee has a "N" in the eligibleEmployee column of the CSV then this employee does not have the eligible Employee Submissions required.
      If an employee has multiple employment IDs then there will be separate rows for each employment ID.
      Based on the values provided in the Revenue CSV file and the Employer's Additional Gross Payment amount figure entered
      the calculator will display the subsidy amount payable o the employee in the Excel Column G ( Labelled E in row 7)
      Row 7 has notation for the calculation that are consistent with the A- F notation in the FAQ examples.
This sample calculator is provided as a guide only and is not to be used or taken as professional advice, including legal advice. It should not be assumed 
that the calculator is comprehensive or that it provides a definitive answer in every case. In the event of any discrepancy in calculated figures the 
official calculation as provided for in the operational phase is the authoritative one. The CSV calculator allows for multiple employments based on 
See "CSV - Calculator Examples" for usage examples using the sample CSV and examples in the Appendix of the Guidance FAQ
DO NOT EDIT the contents of the CSV file.  Revenue will calculate the refunds to the employer based on the information
on Revenue's systems, if the employer makes a subsidy payment based on edited CSV figures then they may receive a reduced, or no, refund.
Paste (paste values works best) the CSV file contents so that cell A1, from the downloaded CSV file, pastes into cell L5 of the "CSV subsidy calculator" sheet
If you get an error starting with "The cell or chart you are trying to change" or other protection related error then you may
Review each employee and enter the optional Employer's Additional Gross Payment amount in column E, in the orange cells.
If the employee has a "N" in the eligibleEmployee column of the CSV then this employee does not have the eligible Employee Submissions required.
Based on the values provided in the Revenue CSV file and the Employer's Additional Gross Payment amount figure entered
the calculator will display the subsidy amount payable o the employee in the Excel Column G ( Labelled E in row 7)
                                                             CSV - Sample Subsidy Calculator V1.0
                         This sample calculator is provided as a guide only and is not to be used or taken as professional advice, including legal advice. It should not be assumed that the calculator 
                           is comprehensive or that it provides a definitive answer in every case. In the event of any discrepancy in calculated figures the official calculation as provided for in the 
                                         operational phase is the authoritative one. The CSV calculator allows for multiple employments based on Revenue provided CSV file. 
           Employer      Employee's      Maximum Weekly      Maximum Weekly       Taxable Pay - 
           payment       Average Revenue Wage Subsidy for    Employer Payment     Employer 
           percentage - as Net Weekly Pay  employee (MWWS)  Before Tapering       Additional Gross 
           % of ARNWP    (ARNWP)         (see below)         (MWEPBT) to receive  Payment 
                                                             full subsidy         (optional)
           ERPP          A               B                   C                    D
                   0.00%             0.00                0.00                 0.00
                   0.00%             0.00                0.00                 0.00
                   0.00%             0.00                0.00                 0.00
                   0.00%             0.00                0.00                 0.00
                   0.00%             0.00                0.00                 0.00
                   0.00%             0.00                0.00                 0.00
                   0.00%             0.00                0.00                 0.00
                   0.00%             0.00                0.00                 0.00
                   0.00%             0.00                0.00                 0.00
                   0.00%             0.00                0.00                 0.00
                   0.00%             0.00                0.00                 0.00
                   0.00%             0.00                0.00                 0.00
                   0.00%             0.00                0.00                 0.00
                   0.00%             0.00                0.00                 0.00
                   0.00%             0.00                0.00                 0.00
                   0.00%             0.00                0.00                 0.00
                   0.00%             0.00                0.00                 0.00
                   0.00%             0.00                0.00                 0.00
                   0.00%             0.00                0.00                 0.00
                   0.00%             0.00                0.00                 0.00
                   0.00%             0.00                0.00                 0.00
                   0.00%             0.00                0.00                 0.00
                   0.00%             0.00                0.00                 0.00
                   0.00%             0.00                0.00                 0.00
                   0.00%             0.00                0.00                 0.00
                   0.00%             0.00                0.00                 0.00
                   0.00%             0.00                0.00                 0.00
                   0.00%             0.00                0.00                 0.00
                   0.00%             0.00                0.00                 0.00
                   0.00%             0.00                0.00                 0.00
                   0.00%             0.00                0.00                 0.00
                   0.00%             0.00                0.00                 0.00