AIR - Section 11 - Is there an Excel template for the tables import?
There is no template available for the import of the data into the different tables in Section 11. The easiest is to:
- Use the Export button to Export the table as Excel
- Fill or modify the values in the 4 columns and save the file
- Import the modified Excel file in SFC2014
Note that:
IR - Table 2C - Achievement ratio calculation rules
In case the measurement unit of both the indicator and its target is numerical, SFC2014 automatically calculates the achievement ratio by dividing the cumulative value with the target.
In case the indicator or the target is expressed in percentages,
IR - Tables 8, 9, 10 & 11 - Zero values
For tables 8, 9 & 10 the tables need to be filled out with ‘0’ even if this value is due to the fact that the corresponding provisions wasn't used in the regulatory framework. The Commission cannot check whether these provisions were applied or not, as this information is not part of the Operational Programme. However, if there are 0 values in the financial tables on the number of selected operations, it can be concluded that the blanks in tables 8-10 can only mean a 0 value.
IR - Table 2C - Achievement ratio calculation rules
In case the measurement unit of both the indicator and its target is numerical, SFC2014 automatically calculates the achievement ratio by dividing the cumulative value with the target.
In case the indicator or the target is expressed in percentages,
AIR - Financial data tables - How can I generate the Financial data tables?
Normally when creating the EAFRD AIR the system will automatically attach a Financial Annex, but for 2018 AIR (to be submitted in 2019) created before the 24.04.2019 the Annex was not automatically attached. You can attach the Financial Annex manually via section 1a: