{"text_format":"1","workbook":"xlsx","n_sheets":18,"sheets":["Configuration","Guidance BS","Guidance FFS","Information on Beneficiary","ADM COSTS","Subcontracting_Template","Subcontracting","Consumer","Construction","Industry","Retail Trade","Services","Total","Sheet1","Calculation Methodology BS","Calculation Methodology FFS","Calculation Overview","Calculation Balance"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":80,"comments":7,"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":"Configuration","index":0,"n_rows":7,"n_cols":3,"rows_kept":7,"cut":false,"hidden":true,"merged":[]}
["Heading line 1:","BUDGET AND FINAL FINANCIAL STATEMENT FOR GRANT AGREEMENT PERIOD MAY 2023 - APRIL 2024","BUDGET AND FINAL FINANCIAL STATEMENT FOR GRANT AGREEMENT PERIOD MAY 2023 - APRIL year 2023"]
["Heading line 2:","ANNEX V OF THE FRAMEWORK PARTNERSHIP AGREEMENT","ANNEX V OF THE FRAMEWORK PARTNERSHIP AGREEMENT"]
["Heading line 3:","ANNEX II OF THE SPECIFIC GRANT AGREEMENT","ANNEX II OF THE SPECIFIC GRANT AGREEMENT"]
["Heading line 4:","FINANCING PLAN AND COSTS OF THE SURVEYS","FINANCING PLAN AND COSTS OF THE SURVEYS"]
["Heading line 5:","(see Framework partnership agreement: Article II.19 on Eligible costs)","(see Framework partnership agreement: Article II.19 on Eligible costs)"]
["Status:","BUDGET","BUDGET"]
["Grant agreement:","ECFIN/XXX/2023/000000","ECFIN/XXX/2023/000000"]

{"sheet":"Guidance BS","index":1,"n_rows":58,"n_cols":2,"rows_kept":58,"cut":false,"hidden":false,"merged":[[34,0,34,1],[32,0,32,1],[0,0,0,1],[13,0,13,1],[15,0,15,1],[20,0,20,1],[30,0,30,1],[22,0,23,0],[27,0,28,0],[43,0,43,1],[56,0,56,1],[57,0,57,1],[44,0,44,1],[47,0,47,1],[45,0,45,1],[49,0,49,1],[54,0,54,1],[46,0,46,1],[48,0,48,1]]}
["MODEL BUDGET & FINANCIAL STATEMENT\nANNEX V TO THE FRAMEWORK PARTNERSHIP AGREEMENT"]
[null,"Some guidance on how to fill out the Budget Statement (BS)"]
["Dear Madam/Sir,"]
["This is a template that you must use to submit the budget statement for the grant agreement."]
["When you open this file, a warning message might appear informing you that macros have been disabled. Please click on 'Enable' in order to enable the macros. "]
["Here are the basic features of this model :"]
["(un)locked cells : ","only the white parts can be used freely by you "]
["Comments :","when you point the cursor on a cell with a red triangle, comments will appear with guidance"]
["ISO country code : ","please type the ISO country code of your institution here (ex: FR); it will appear automatically in all sheets :"]
[null,"Country"]
["Name of institution* : ","please type your institution's name here; it will appear automatically in all sheets :"]
[null,"Acronym institution"]
[null,"* if the name of your institution has been changed, please ask for an amendment of the specific and framework partnership agreement."]
["By opening this document, a new tool named 'Add-Ins' appeared in your Menu Bar. Once you click on the new 'Add-Ins' menu, a 'BCS Tools' menu option will appear on the left-hand side of your Menu Bar."]
["Please follow the guidance below when filling in all necessary sheets. This will help ensure eligibility for your grant."]
["For more background, please also have a look at the \"ECFIN's Guidelines for the financial management of grant agreements\" which deals with the most important rules on eligible costs for drawing up budget estimates."]
["Should you have any doubts or questions, please don't hesitate to contact us :"]
[null,"ECFIN-BCS-STATEMENTS@ec.europa.eu"]
["1. Guidance on how to fill out the 'Information on Beneficiary' sheet."]
["Please complete the: \"Information on beneficiary\" sheet so that we have up-to-date administrative details."]
["If there is a change to the signing or contact person, the address of your institution or the bank account number in comparison with the information in your application/framework partnership agreement, please inform the BCS team as soon as possible."]
["As regards the VAT: ","- recoverable VAT is not eligible"]
["You will find more info on VAT in the Guidelines","- not-deductible VAT may be included as eligible cost"]
[null,"- partially recoverable VAT: the eligible part corresponds to the pro-rata of the VAT which is not deductible,"]
["2. Guidance on how to fill out the 'Subcontracting' sheet."]
["When subcontracting is involved, please provide us with the requested information (see the: \"Subcontracting\" sheet)."]
["Subcontracting:","The data of the sub-contractor needs to be filled out in the \"Subcontracting (1)\" sheet. "]
["You will find more info on Costs for Subcontracting in the Guidelines","To add the details of more sub-contractors please insert a new blank sheet by selecting \"Add another subcontracting form\" from the '===> BCS Tools <===' menu option."]
[null,"Additional subcontracting forms that are not needed can be removed by selecting \"Delete this subcontracting form\" from the '===> BCS Tools <===' menu option."]
[null,"Created sheets can be removed, apart from the \"Subcontracting (1)\" sheet. "]
["Please provide us with a copy of your subcontract as soon as possible."]
["3. Guidance on how to fill out the individual survey sheets"]
["Please fill in the white cells of the individual survey sheets of the surveys for which you ask a grant. Help yourself with the guidelines. Note that you can only fill in the columns of the part BUDGET (euro). The columns related to 'FINAL (euro)' are frozen and will be filled in at the final financial statement stage."]
["a) Financing plan (see guidelines section 1):"]
["Please complete the financing plan by filling in the white cells in the columns part of the heading BUDGET (euro): direct revenues, contribution(s) by other organisation(s) and grant percentage."]
["Yellow cells","the cells highlighted in yellow (total income, own contribution, requested grant and pre-financing payment) are calculated automatically to balance the income and costs"]
["Grant percentage:","Please fill in the grant percentage which cannot be >50%, with 2 decimals."]
["b) Budget estimated eligible costs (see guidelines section 1 & 2):"]
["To insert a row","In the menu bar click on 'Add-Ins' and select '===> BCS Tools <===' and click on 'Add row in current section'"]
[null,"This only works in the survey sheets."]
["To delete a row","In the menu bar click 'Add-Ins' and select '===> BCS Tools <===' and click on 'Delete current row' (Note that this only works in the survey sheets)."]
["(sub)totals :","Will be calculated automatically"]
["If applicable, please clearly identify costs by affiliated entities and/or co-beneficiaries."]
["The Survey-related ratio represents the ratio calculated based on the costs for the survey programme in relation to the total costs for all activities managed by your department."]
["The EU-related ratio is the ratio that you apply to the survey-related costs if your survey programme contains additional questions, which are not part of the harmonised EU BCS questionnaire (e.g. based on the number of harmonised EU BCS questions in relation to the total questions in your questionnaire). This ratio can be 100% if your questionnaire only contains harmonised EU BCS questions."]
["For each category of staff, please follow the instructions mentioned in the 'green' zones and indicate the daily rate per pay grade (see guidelines, section 3), the number of staff working under that pay grade, the estimated number of working days the staff will allocate to the survey programme as well as the EU-related ratio that you apply, if applicable."]
["Staff paid based on deliverables must be declared under item I.5. Please indicate the price per unit of deliverable, the estimated number of units you intend to conduct and, if applicable, the EU-related ratio that you apply."]
["For each estimated administrative cost, please follow the instructions mentioned in the 'green' zone: give a short description of the cost related to the survey programme and estimate the costs per cost category based on a reference year and, if applicable, indicate the BCS ratios that have been applied (see guidelines section 4)."]
["If the total estimated costs for item II.3 - Administrative costs is lower than or equal to 50% of the total estimated staff costs, the (automatically) calculated flat rate will be applied to the total eligible final staff costs at the end of the action period. No further details or evidences on these administrative costs will be asked at the end of the action period."]
["Note that only the estimated costs indicated in your budget statement can be considered as eligible at the final financial stage. For more information on eligible costs, please read the guidelines for applicants as mentioned above."]
["Indirect costs","the percentage of the indirect costs is 7% of the total eligible direct costs excl. subcontracting. The amount is automatically calculated. "]
["4. Guidance on how to fill out the 'Total' sheet."]
["The 'Total' sheet is automatically filled in."]
["5. Guidance on how to fill out the 'Calculation Methodology BS' sheet."]
["Please give a clear description of the calculation methodology you applied to estimate your budget and to distribute costs among the BCS action and the other projects managed by your department by filling out the 'Calculation Methodology BS' sheet. "]
["Thank you in advance for your cooperation."]
["Economic situation, forecasts, business and consumer surveys"]
["Business and consumer surveys and short-term forecast"]

{"sheet":"Guidance FFS","index":2,"n_rows":62,"n_cols":2,"rows_kept":62,"cut":false,"hidden":true,"merged":[[0,0,0,1],[13,0,13,1],[16,0,16,1],[22,0,22,1],[25,0,25,1],[23,0,23,1],[24,0,24,1],[61,0,61,1],[40,0,40,1],[28,0,28,1],[29,0,29,1],[54,0,54,1],[57,0,57,1],[60,0,60,1],[41,0,41,1],[45,0,45,1],[47,0,47,1],[46,0,46,1],[43,0,43,1],[26,0,26,1],[48,0,48,1],[49,0,49,1],[42,0,42,1],[36,0,36,1],[34,0,34,1],[38,0,38,1],[39,0,39,1],[35,0,35,1],[37,0,37,1],[44,0,44,1]]}
["MODEL BUDGET & FINANCIAL STATEMENT \nANNEX V TO THE FRAMEWORK PARTNERSHIP AGREEMENT"]
[null,"Some guidance on how to fill out the final financial statement (FFS)"]
["Dear Madam/Sir,"]
["This is a template you can use to submit the final financial statement for the grant agreement."]
["Here are the basic features of this model :"]
["(un)locked cells : ","only the white parts can be used freely by you "]
["Budget statement:","the information mentioned in the budget statement must not be changed. These cells should be frozen."]
["Comments :","when you point the cursor on a cell with a red triangle, comments will appear with guidance"]
["ISO country code : ","please type the ISO country code of your institution here; it will appear automatically in all sheets :"]
[null,{"$f":"'Guidance BS'!B10","v":"Country"}]
[]
["Name of institution : ",{"$f":"'Guidance BS'!B12","v":"Acronym institution"}]
[null,"* if the name of your institution has been changed, please ask for an amendment of the specific and framework partnership agreement."]
["By opening this document, a new tool named 'Add-Ins' appeared in your Menu Bar. Once you click on the new 'Add-Ins' menu, a 'BCS Tools' menu option will appear on the left-hand side of your Menu Bar."]
["Please follow the guidance below when filling in all necessary sheets. This will help ensure eligibility for your grant."]
["For more background, please also have a look at the following document :"]
["The \"ECFIN's Guidelines for applicants for the financial management of grant agreements\" deals with the most important rules on eligible costs for drawing up final financial statements."]
["Should you have any doubts or questions, please don't hesitate to contact us :"]
[null,"ECFIN-BCS-STATEMENTS@ec.europa.eu"]
[]
["1. Guidance on how to fill in the 'Information on the Beneficiary's sheet."]
[" Please verify the \"Information on beneficiary\" sheet so that we have up-to-date administrative details."]
["If there has been a change to the signing or contact person, the address of your institution or the bank account number in comparison with your specific grant agreement or framework partnership agreement, please inform the BCS team as soon as possible in order to amend the agreements concerned."]
["2. Guidance on how to fill out the 'Subcontracting' sheet."]
[" Please refer to the Guidelines for the financial management of the grant agreements, section 4.3.4, How to report the final eligible costs for subcontracting at the end of the action period."]
["When subcontracting is involved, please update when necessary the information mentioned in the \"Subcontracting\" sheet. "]
["If you have not already done so, please provide us with a copy of the subcontract."]
["3. Guidance on how to fill out the individual survey sheets:"]
["At this stage you cannot change the information you provided at the budget statement phase."]
["Please fill in the columns 'FINAL (euro) in each individual survey sheet of the document as follows: "]
["- In the Financing Plan:","Fill in the white cells regarding the final direct revenues and final contributions from  other organisation."]
["- In the EXPENDITURES:","fill in the total eligible direct staff costs and direct administrative costs as described below:"]
["(sub)totals :","will be calculated automatically"]
["Total eligible direct STAFF COSTS"]
[" Please refer to the Guidelines for the financial management of the grant agreements, section 3.4.5, How to report the final eligible staff costs at the end of the action period?"]
["For each category of staff, please follow the instructions mentioned in the 'green' zones and indicate:"]
["- The daily rate per pay grade for each category of staff and the unit cost for deliverables have been agreed at budget statement and should comply with the salary grids attached to it. You therefore do not have to modify these figures in your survey sheets. Moreover, the column mentioning the daily rates per pay grade is frozen and must not be modified."]
["- The total number of people per staff category (needs to be filled in)"]
["- The total worked days represents the real number of days spent on the survey programme per pay grade and staff category calculated based on time records."]
["- The actual number of deliverables is the total number of interviews/records conducted during the action period"]
["The EU-related ratio is the ratio applied to separate the working time for the harmonised EU BCS questions from the other questions present in the questionnaire(s). This EU ratio could be an average in case the number of questions differs from month to month. "]
["Total eligible direct ADMINISTRATIVE COSTS and, if applicable, the sheet 'ADM COSTS' to detail the real administrative costs not under flat-rate financing."]
[" Please refer to the Guidelines for the financial management of the grant agreements, sections: 4.3.4 as regards Subcontracting, 4.4.4. as regards Update of Software/Process Redesigne - How to report the final eligible costs for up-date of software/process redesign, and section 4.5.5 as regards the administrative costs (Item II.3 of the budget statement)."]
["As regards II.3 ADMINISTRATIVE COSTS:\n\nIn case a percentage for flat-rate financing is mentioned in your SGA Art. 3.2, you do NOT have to fill in section II.3 of the sheet ADM COSTS to give details on your administrative costs. The percentage will be automatically applied in the different survey sheets next to the description \"Flat-rate financing for administrative costs'. "]
["In case you must declare, in one or more surveys, costs for subcontracting (section II.1), costs for update of software/process redesign (section II.2) or other real incurred administrative costs because the flat-rate calculated at budget phase was >50% (section II.2), please fill in column J with the eligible administrative costs related to these concerned surveys. To do so, please make use of  the sheet 'ADM COSTS' and, where necessary, fill in the table 'Model detailed list of costs' with the details for sections II.1 SUBCONTRACTING COSTS, II.2 UPDATE OF SOFTWARE / PROCESS REDESIGN and II.3 ADMINISTRATIVE COSTS : REAL INCURRED.\nThe exchange rate is indicated in cell D5 of table 'ADM COSTS'. Fill in the costs in local currency in column D so that the actual costs in euros will be automatically calculated in column E.\nYou may also submit another sheet as long as all the requested information as mentioned in the table 'Model detailed list of costs' appears in your sheet: invoice number, date of invoice, description and amount of invoice as well as the exchange rate applied (if applicable). Indicate in the table 'DISTRIBUTION RATIOS' the ratios to be applied per survey to distribute the costs among the surveys or create another table showing this distribution. \nPlease copy the totals to the individual survey sheets and refer to your attachment in the sheet ADM COSTS ."]
["Please then copy the total actual costs (in euro) of these categories of real incurred costs in the individual survey sheets by filling in the column 'Actual Costs (euro)' and indicate the EU BCS ratios to be applied for each individual survey."]
["The Survey-related ratio represents the ratio calculated based on the costs for the survey programme in relation to the total costs for all activities managed by your department."]
["The EU-related ratio is the ratio that you apply to the survey-related costs if your survey programme contains additional questions, which are not part of the harmonised EU BCS questionnaire (e.g. based on the number of harmonised EU BCS questions in relation to the total questions in your questionnaire). This ratio can be 100% if your questionnaire only contains harmonised EU BCS questions."]
["Please consult the guidelines section I.9 on how to deal with exchange rates."]
["Please consult the guidelines section 2.2 on how to calculate the EU BCS ratios."]
["To determine which costs are eligible, please read the guidelines, sections 1 to 5."]
["Indirect costs:","the percentage of the indirect costs is 7% of the total eligible direct costs excluding subcontracting. The amount is automatically calculated. "]
["(sub)totals :","will be calculated automatically"]
["4. Guidance on how to fill out the 'Total' sheet."]
["The 'Total' sheet is automatically filled in and informs you on the final grant to be requested."]
["The invoice:","The amount mentioned under 'FINAL PAYMENT REQUEST' is the balance of the grant to be requested from the Commission and therefore should appear in your request for payment (invoice)."]
["5. Guidance on how to fill out the 'Calculation Methodology FFS' sheet."]
["Please give a clear description of the calculation methodology you applied to determine the eligible costs and to distribute costs among the BCS action and the other projects managed by your department by filling out the 'Calculation Methodology FFS' sheet. If applicable, please also explain the calculation methodology used to distribute the costs among the different surveys."]
[]
["Thank you in advance for your cooperation."]
["Economic situation, forecasts, business and consumer surveys"]
["Business and consumer surveys and short-term forecast"]

{"sheet":"Information on Beneficiary","index":3,"n_rows":21,"n_cols":2,"rows_kept":21,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
["Information on the beneficiary of the grant"]
[{"$f":"IF(NOT(ISBLANK('Guidance BS'!B10)),'Guidance BS'!B10,\"\")","v":"Country"},{"$f":"IF(NOT(ISBLANK('Guidance BS'!B12)),'Guidance BS'!B12,\"\")","v":"Acronym institution"}]
[null,"Please fill in all the information as requested below."]
[null,"please indicate: the title (Ms/Mrs/Mr), the last name, the first name and the function (Director, President, etc.) of the legal representative of your institution."]
["signing person  :","title (Ms/Mrs/Mr), LAST NAME, first name and function"]
["(page 1 of the agreement)"]
[null,"please indicate: the title (Ms/Mrs/Mr), the last name, the first name and the function (Director, President, etc.)"]
["second signing person* :","title (Ms/Mrs/Mr), LAST NAME, first name and function of 2nd signing person"]
["(page 1 of the agreement)","* if two people need to sign documents in order for them to be legally binding on your institution."]
[null,"please indicate: the title (Ms/Mrs/Mr), the last name and the first name of the contact person."]
["contact person for the management of the grant:","title (Ms/Mrs/Mr), LAST NAME and the first name of the contact person"]
[]
[null,"please also include the IBAN code in front of the bank account number"]
["bank account (number) :"]
[null,"Is VAT included in the attached budget statement?"]
["Yes"]
["No"]
["Partially"]
["Comments :","Please explain how the VAT is applicable in your institution"]
[]
[null,"date and signature of legal representative(s)"]

{"sheet":"ADM COSTS","index":4,"n_rows":54,"n_cols":13,"rows_kept":54,"cut":false,"hidden":true,"merged":[[54,1,54,4],[50,0,50,3],[0,0,0,1],[0,2,0,4],[1,0,1,4],[2,0,2,4],[3,0,3,4],[18,0,18,4],[40,0,40,3],[7,0,7,3],[19,0,19,3],[4,0,4,1],[53,1,53,4],[29,0,29,3],[32,0,32,3],[52,1,52,4],[45,0,45,3],[35,0,35,3],[17,0,17,3],[51,1,51,4],[12,6,12,12],[7,6,7,12],[28,6,28,11],[23,0,23,3],[26,0,26,3],[12,0,12,3],[17,6,17,12]]}
[{"$f":"Configuration!B7","v":"ECFIN/XXX/2023/000000"}]
["MODEL OF DETAILED LIST OF THE ELIGIBLE ADMINISTRATIVE COSTS"]
["Model of detailed list of eligible administrative costs to be submitted together with the final financial statements                  "]
["If applicable, please clearly identify costs by affiliated entities and/or co-beneficiaries"]
[null,null,"Conversion rate:\nAverage rate over the action period",1,"ACTUAL COSTS"]
["Invoice number (2)","Date of invoice","Subject/description of  invoice","Total amount of invoice (local currency)\n_______ (3)","Eligible cost in EUR"]
[2013005,"15/05/YY","Database provision & maintenance",1500,{"$f":"D7*$D$5","v":1500}]
["II.1 SUBCONTRACTING COSTS",null,null,null,{"$f":"SUM(E9:E13)-E13","v":0},null,"SUBCONTRACTING COSTS - DISTRIBUTION AMONG SURVEYS"]
["Invoice no",null,"Please describe",0,{"$f":"ROUNDDOWN(D9*$D$5,2)","v":0},null,null,"Consumer","Construction","Industry","Retail Trade","Services","Totals"]
["Invoice no",null,"Please describe",0,{"$f":"ROUNDDOWN(D10*$D$5,2)","v":0},null,"Distribution ratio among the surveys",0,0,0,0,0,{"$f":"SUM(H10:L10)","v":0}]
["Invoice no",null,"Please describe",0,0,null,"Subcontracting costs",{"$f":"$E$8*H10","v":0},{"$f":"$E$8*I10","v":0},0,0,0,0]
["Invoice no",null,"Please describe",0,0]
["II.2 UPDATE OF SOFTWARE / PROCESS OF REDESIGN",null,null,null,{"$f":"SUM(E14:E18)-E18","v":0},null,"UPDATE OF SOFTWARE / PROCESS REDESIGN - DISTRIBUTION AMONG SURVEYS"]
["Invoice no",null,"Please describe",0,{"$f":"ROUNDDOWN(D14*$D$5,2)","v":0},null,null,"Consumer","Construction","Industry","Retail Trade","Services","Totals"]
["Invoice no",null,"Please describe",0,{"$f":"ROUNDDOWN(D15*$D$5,2)","v":0},null,"Distribution ratio among the surveys",0,0,0,0,0,{"$f":"SUM(H15:L15)","v":0}]
["Invoice no",null,"Please describe",0,0,null,"Update Software",{"$f":"$E$13*H15","v":0},{"$f":"$E$13*I15","v":0},0,0,0,{"$f":"SUM(H16:L16)","v":0}]
["Invoice no",null,"Please describe",0,0]
["II.3 ADMINISTRATIVE COSTS : REAL INCURRED",null,null,null,{"$f":"E20+E24+E27+E30+E33+E36+E41+E46","v":0},null,"REAL INCURRED ADM COSTS - DISTRIBUTION AMONG SURVEYS"]
["ONLY TO BE FILLED IN BY PARTNERS WHO MUST NOT APPLY A FLAT RATE FINANCING FOR ADMINISTRATIVE COSTS \n(see Art. 3.2 SGA)",null,null,null,null,null,null,"Consumer","Construction","Industry","Retail Trade","Services","Totals"]
["TRAVELLING COSTS AND SUBSISTENCE ALLOWANCES",null,null,null,{"$f":"SUM(E21:E24)-E24","v":0},null,"Distribution ratio among the surveys",0,0,0,0,0,{"$f":"SUM(H20:L20)","v":0}]
["Invoice no",null,"TRAVELLING",0,{"$f":"ROUNDDOWN(D21*$D$5,2)","v":0},null,"Travelling costs ",{"$f":"$E$20*H20","v":0},{"$f":"$E$20*I20","v":0},0,0,0,{"$f":"SUM(H21:L21)","v":0}]
[null,null,"SUBSISTENCE ALLOWANCES",0,{"$f":"ROUNDDOWN(D22*$D$5,2)","v":0},null,"Printing ",{"$f":"$E$24*H20","v":0},{"$f":"$E$24*I20","v":0},0,0,0,{"$f":"SUM(H22:L22)","v":0}]
[null,null,"Please describe",0,{"$f":"ROUNDDOWN(D23*$D$5,2)","v":0},null,"Mailing",{"$f":"$E$27*H20","v":0},{"$f":"$E$27*I20","v":0},0,0,0,0]
["PRINTING",null,null,null,{"$f":"SUM(E25:E27)-E27","v":0},null,"Communication",{"$f":"$E$30*H20","v":0},{"$f":"$E$30*I20","v":0},0,0,0,0]
["Invoice no",null,"Please describe",0,{"$f":"ROUNDDOWN(D25*$D$5,2)","v":0},null,"Translation",{"$f":"$E$33*H20","v":0},{"$f":"$E$33*I20","v":0},0,0,0,0]
["Invoice no",null,"Please describe",0,{"$f":"ROUNDDOWN(D26*$D$5,2)","v":0},null,"Material",{"$f":"$E$36*H20","v":0},{"$f":"$E$36*I20","v":0},0,0,0,0]
["MAILING",null,null,null,{"$f":"SUM(E28:E30)-E30","v":0},null,"Fees IT",{"$f":"$E$41*H20","v":0},{"$f":"$E$41*I20","v":0},0,0,0,0]
["Invoice no",null,"Please describe",0,{"$f":"ROUNDDOWN(D28*$D$5,2)","v":0},null,"Other costs",{"$f":"$E$46*H20","v":0},{"$f":"$E$46*I20","v":0},0,0,0,0]
["Invoice no",null,"Please describe",0,{"$f":"ROUNDDOWN(D29*$D$5,2)","v":0},null,"TOTAL REAL INCURRED ADMINISTRATIVE COSTS",null,null,null,null,null,{"$f":"SUM(M21:M28)","v":0}]
["COMMUNICATION (Telephone, fax, internet,…)",null,null,null,{"$f":"SUM(E31:E33)-E33","v":0}]
["Invoice no",null,"Please describe",0,{"$f":"ROUNDDOWN(D31*$D$5,2)","v":0}]
["Invoice no",null,"Please describe",0,{"$f":"ROUNDDOWN(D32*$D$5,2)","v":0}]
["TRANSLATING",null,null,null,{"$f":"SUM(E34:E36)-E36","v":0}]
["Invoice no",null,"Please describe",0,{"$f":"ROUNDDOWN(D34*$D$5,2)","v":0}]
["Invoice no",null,"Please describe",0,{"$f":"ROUNDDOWN(D35*$D$5,2)","v":0}]
["MATERIALS",null,null,null,{"$f":"SUM(E37:E41)-E41","v":0}]
["Invoice no",null,"PAPER",0,{"$f":"ROUNDDOWN(D37*$D$5,2)","v":0}]
["Invoice no",null,"ENVELOPES",0,{"$f":"ROUNDDOWN(D38*$D$5,2)","v":0}]
["Invoice no",null,"TONERS",0,0]
["Invoice no",null,"Please describe",0,0]
["FEES FOR IT SOFTWARE AND DATA",null,null,null,{"$f":"SUM(E42:E46)-E46","v":0}]
["Invoice no",null,"LICENCE FEES",0,{"$f":"ROUNDDOWN(D42*$D$5,2)","v":0}]
["Invoice no",null,"FEES FOR DATABASE",0,{"$f":"ROUNDDOWN(D43*$D$5,2)","v":0}]
["Invoice no",null,"STORAGE DATA",0,0]
["Invoice no",null,"Please describe",0,0]
["CERTAIN OTHER COSTS (necessary and specific to the project activities)",null,null,null,{"$f":"SUM(E47:E50)-E50","v":0}]
["Invoice no",null,"Please describe",0,{"$f":"ROUNDDOWN(D47*$D$5,2)","v":0}]
["Invoice no",null,"Please describe",0,{"$f":"ROUNDDOWN(D48*$D$5,2)","v":0}]
["Invoice no",null,"Please describe",0,0]
[]
["TOTAL ELIGIBLE ADMINISTRATIVE COSTS",null,null,null,{"$f":"E8+E13+E18","v":0}]
["(1)","Conversion rate into euro for final statement of EU countries outside the euro area : average daily rate over the action period as established by the European Central Bank and published on its website: https://www.ecb.europa.eu/stats/policy_and_exchange_rates/euro_reference_exchange_rates/html/index.en.html, determined over the corresponding reporting period.\nIf no daily euro exchange rate is established by the European Central Bank for the currency in question, conversion must be made at the average of the monthly accounting rates established by the Commission and published on its website: http://ec.europa.eu/budget/contracts_grants/info_contracts/inforeuro/inforeuro_en.cfm, determined over the corresponding reporting period . (see also Art. 4.5 Specific Grant Agreement). "]
["(2)","If it is not possible to provide an invoice number, put the reference number of the record used in your internal accountancy system to book the cost or (for public institutions) the reference of your internal budget line."]
["(3)","Please fill in the local currency"]

{"sheet":"Subcontracting_Template","index":5,"n_rows":22,"n_cols":1,"rows_kept":22,"cut":false,"hidden":true,"merged":[]}
["Information on subcontracting / contracts for implementing part of the action"]
[{"$f":"IF(NOT(ISBLANK('Guidance BS'!B12)),'Guidance BS'!B12,\"\")","v":"Acronym institution"}]
["Contracts must be awarded to the tender offering best value for money, that is to say, to the tender offering the best price-quality ratio, in compliance with the principles of transparency and equal treatment for potential contractors. Care must also be taken to avoid any conflict of interest. The eligibility of the costs for subcontracting is described in the Articles II.10 and II.11 of the Framework partnership agreement."]
["The information below must be given for each contract covering a heading or sub-heading of the costs of the action concerned:"]
["A copy of the signed contract should be enclosed. Please keep records and documentation of the selection process,"]
["Please fill in all sections."]
["·        Contractor’s official name :"]
[]
["·        Part of work to be subcontracted (in %)"]
[]
["·        Period of validity of the contract:"]
[]
["·        Tasks involved:"]
[]
["·        Reasons for contracting out implementation work:"]
[]
["·       Description of the selection procedure:"]
[]
[]
[]
["-------------------------------------------------------------------------------------"]
["date and signature of legal representative(s)"]

{"sheet":"Subcontracting","index":6,"n_rows":22,"n_cols":1,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["Information on subcontracting / contracts for implementing part of the action"]
[{"$f":"IF(NOT(ISBLANK('Guidance BS'!B12)),'Guidance BS'!B12,\"\")","v":"Acronym institution"}]
["Contracts must be awarded to the tender offering best value for money, that is to say, to the tender offering the best price-quality ratio, in compliance with the principles of transparency and equal treatment for potential contractors. Care must also be taken to avoid any conflict of interest. The eligibility of the costs for subcontracting is described in the Articles II.10 and II.11 of the Framework partnership agreement."]
["The information below must be given for each contract covering a heading or sub-heading of the costs of the action concerned:"]
["A copy of the signed contract should be enclosed. Please keep records and documentation of the selection process,"]
["Please fill in all sections."]
["·        Contractor’s official name :"]
[]
["·        Part of work to be subcontracted (in %)"]
[]
["·        Period of validity of the contract:"]
[]
["·        Tasks involved:"]
[]
["·        Reasons for contracting out implementation work:"]
[]
["·       Description of the selection procedure:"]
[]
[]
[]
["-------------------------------------------------------------------------------------"]
["date and signature of legal representative(s)"]

{"sheet":"Consumer","index":7,"n_rows":66,"n_cols":13,"rows_kept":66,"cut":false,"hidden":false,"merged":[[67,4,67,12],[62,9,62,11],[65,4,65,7],[65,9,65,11],[63,4,63,7],[15,9,15,11],[45,9,45,11],[45,4,45,7],[48,9,48,11],[23,9,23,11],[16,9,16,11],[36,9,36,11],[34,9,34,11],[32,9,32,11],[23,5,23,7],[24,5,24,7],[26,5,26,7],[28,5,28,7],[32,5,32,7],[30,5,30,7],[15,4,15,7],[59,3,59,4],[58,3,58,4],[49,3,49,4],[51,3,51,4],[53,3,53,4],[54,3,54,4],[56,3,56,4],[57,3,57,4],[55,3,55,4],[60,3,60,4],[63,9,63,11],[18,5,18,8],[16,4,16,7],[18,3,18,4],[18,9,18,12],[34,5,34,7],[42,4,42,7],[26,9,26,11],[24,9,24,11],[46,3,46,8],[19,9,19,11],[30,9,30,11],[28,9,28,11],[62,3,62,7],[46,9,46,11],[10,9,10,11],[11,9,11,11],[0,2,0,12],[1,2,1,12],[3,2,3,12],[4,2,4,12],[5,2,5,12],[10,4,10,7],[11,4,11,7],[8,5,8,8],[8,9,8,12],[9,9,9,11],[9,4,9,7],[2,2,2,12],[23,19,23,22],[19,3,20,3],[23,14,23,18],[20,9,20,11],[21,9,21,11],[19,4,19,7],[20,4,20,7],[21,4,21,7],[13,9,13,11],[14,9,14,11],[12,4,12,7],[13,4,13,7],[14,4,14,7],[12,9,12,11]]}
[null,null,{"$f":"Configuration!B1","v":"BUDGET AND FINAL FINANCIAL STATEMENT FOR GRANT AGREEMENT PERIOD MAY 2023 - APRIL 2024"}]
[false,null,{"$f":"Configuration!B2","v":"ANNEX V OF THE FRAMEWORK PARTNERSHIP AGREEMENT"}]
[null,null,{"$f":"Configuration!B3","v":"ANNEX II OF THE SPECIFIC GRANT AGREEMENT"}]
[null,null,{"$f":"Configuration!B4","v":"FINANCING PLAN AND COSTS OF THE SURVEYS"}]
[null,null,{"$f":"Configuration!B5","v":"(see Framework partnership agreement: Article II.19 on Eligible costs)"}]
[null,null,{"$f":"Configuration!B7","v":"ECFIN/XXX/2023/000000"}]
[null,null,null,"INSTITUTION:",{"$f":"'Guidance BS'!B10","v":"Country"},{"$f":"'Guidance BS'!B12","v":"Acronym institution"}]
[null,null,null,"SURVEYS:","Consumer"]
[null,null,null,null,"FINANCING PLAN ","BUDGET (euro)",null,null,null,"FINAL (euro)"]
[null,null,null,null,"TOTAL ESTIMATED INCOME",null,null,null,{"$f":"I20","v":0},"TOTAL INCOME",null,null,{"$f":"M20","v":0}]
[3,null,null,null,"Direct revenue expected from the action: please indicate here the source of the revenue",null,null,null,0,"Indicate here the source of revenue",null,null,0]
[3,null,null,null,"Contributions from other organisations: please indicate here the source of the funds",null,null,null,0,"Indicate here the source of funds",null,null,0]
[null,{"$f":"M20-IF(M20>I20,I14,M20*I17)-M12-M11","v":0},null,null,"Own contribution",null,null,null,{"$f":"IF(I20-I14-I12-I11<0,0,I20-I14-I12-I11)","v":0},"Own contribution",null,null,{"$f":"IF(M20-M14-M12-M11<0,0,M20-M14-M12-M11)","v":0}]
[null,{"$f":"I10-I11-I12-(I20)*$I$17","v":0},null,null,"Grant requested from the Commission",null,null,null,{"$f":"IF(B14<0,ROUNDDOWN(ROUND(I20,2)*$I$17,2)+B14,ROUNDDOWN(ROUND(I20,2)*$I$17,2))","v":0},"Grant requested from the Commission",null,null,{"$f":"IF(M20>I20,IF(B13<0,I14+B13,I14),IF(B13<0,ROUNDDOWN(ROUND(M20,2)*I17,2)+B13,ROUNDDOWN(ROUND(M20,2)*I17,2)))","v":0}]
[null,null,null,null,"Pre-financing payment (40% of the grant)",null,null,null,{"$f":"40*I14/100","v":0},"Pre-financing payment received",null,null,{"$f":"I15","v":0}]
[null,null,null,null,null,null,null,null,null,"FINAL PAYMENT REQUEST",null,null,{"$f":"M14-M15","v":0}]
[4,null,null,null,"Grant percentage",null,null,null,0,null,null,null,{"$f":"I17","v":0}]
[]
[null,null,null,"ESTIMATED ELIGIBLE COSTS / EXPENDITURES",null,"BUDGET (euro)",null,null,null,"FINAL (euro)"]
[null,null,null,"Budget item","TOTAL ESTIMATED COSTS",null,null,null,{"$f":"ROUNDDOWN((I21+I64),2)","v":0},"TOTAL FINAL COSTS",null,null,{"$f":"ROUNDDOWN((M21+M64),2)","v":0}]
[null,null,null,null,"Total estimated eligible direct costs",null,null,null,{"$f":"ROUNDDOWN((I22+I46),2)","v":0},"Total final eligible direct costs",null,null,{"$f":"ROUNDDOWN((M22+M46),2)","v":0}]
[null,null,null,"I","Total eligible direct staff costs",null,null,null,{"$f":"ROUNDDOWN((I24+I35+I37+I39+I43),2)","v":0},"Total eligible direct staff costs",null,null,{"$f":"ROUNDDOWN((M24+M35+M37+M39+M43),2)","v":0}]
[null,null,null,"I.1 - I.4","daily rate per pay grade (see ANNEX III SGA)","No. of people","Estimated working days","EU-related ratio (%)","TOTAL ESTIMATED COSTS (euro)","No. of people","Total worked days","EU-related ratio (%)","TOTAL\nFINAL COSTS (euro)"]
[null,null,null,"I.1","Permanent staff",null,null,null,{"$f":"ROUNDDOWN((I25+I27+I29+I31+I33),2)","v":0},"Permanent staff",null,null,{"$f":"ROUNDDOWN((M25+M27+M29+M31+M33),2)","v":0}]
[null,null,null,null,"- Managers",null,null,null,{"$f":"SUM(I26:I27)-I27","v":0},"- Managers",null,null,{"$f":"SUM(M26:M27)-M27","v":0}]
[1,null,null,null,0,0,0,0,{"$f":"ROUNDDOWN(E26*F26*G26*H26,2)","v":0},0,0,0,{"$f":"ROUNDDOWN(E26*J26*K26*L26,2)","v":0}]
[null,null,null,null,"- Researchers",null,null,null,{"$f":"SUM(I28:I29)-I29","v":0},"- Researchers",null,null,{"$f":"SUM(M28:M29)-M29","v":0}]
[1,null,null,null,0,0,0,0,{"$f":"ROUNDDOWN(E28*F28*G28*H28,2)","v":0},0,0,0,{"$f":"ROUNDDOWN(E28*J28*K28*L28,2)","v":0}]
[null,null,null,null,"- Interviewers",null,null,null,{"$f":"SUM(I30:I31)-I31","v":0},"- Interviewers",null,null,{"$f":"SUM(M30:M31)-M31","v":0}]
[1,null,null,null,0,0,0,0,{"$f":"ROUNDDOWN(E30*F30*G30*H30,2)","v":0},0,0,0,{"$f":"ROUNDDOWN(E30*J30*K30*L30,2)","v":0}]
[null,null,null,null,"- Technical staff",null,null,null,{"$f":"SUM(I32:I33)-I33","v":0},"- Technical staff",null,null,{"$f":"SUM(M32:M33)-M33","v":0}]
[1,null,null,null,0,0,0,0,{"$f":"ROUNDDOWN(E32*F32*G32*H32,2)","v":0},0,0,0,{"$f":"ROUNDDOWN(E32*J32*K32*L32,2)","v":0}]
[null,null,null,null,"- Administrative staff",null,null,null,{"$f":"SUM(I34:I35)-I35","v":0},"- Administrative staff",null,null,{"$f":"SUM(M34:M35)-M35","v":0}]
[1,null,null,null,0,0,0,0,{"$f":"ROUNDDOWN(E34*F34*G34*H34,2)","v":0},0,0,0,{"$f":"ROUNDDOWN(E34*J34*K34*L34,2)","v":0}]
[null,null,null,"I.2","Temporary staff:",null,null,null,{"$f":"SUM(I36:I37)-I37","v":0},"Temporary staff",null,null,{"$f":"SUM(M36:M37)-M37","v":0}]
[1,null,null,null,0,0,0,0,{"$f":"ROUNDDOWN(E36*F36*G36*H36,2)","v":0},0,0,0,{"$f":"ROUNDDOWN(E36*J36*K36*L36,2)","v":0}]
[null,null,null,"I.3","Staff under civil contracts specifically recruited for the project",null,null,null,{"$f":"SUM(I38:I39)-I39","v":0},"Staff under civil contracts",null,null,{"$f":"SUM(M38:M39)-M39","v":0}]
[1,null,null,null,0,0,0,0,{"$f":"ROUNDDOWN(E38*F38*G38*H38,2)","v":0},0,0,0,{"$f":"ROUNDDOWN(E38*J38*K38*L38,2)","v":0}]
[null,null,null,"I.4","Staff seconded by a third party against payment (no invoice)",null,null,null,{"$f":"SUM(I40:I41)-I41","v":0},"Staff seconded by a third party",null,null,{"$f":"ROUNDDOWN((SUM(M40:M41)-M41),2)","v":0}]
[1,null,null,null,0,0,0,0,{"$f":"ROUNDDOWN(E40*F40*G40*H40,2)","v":0},0,0,0,{"$f":"ROUNDDOWN(E40*J40*K40*L40,2)","v":0}]
[null,"DO NOT DELETE & MUST BE HIDDEN!"]
[null,null,null,"I.5","price per deliverable (see ANNEX III SGA)",null,"estimated number deliverables","EU-related ratio (%)","TOTAL ESTIMATED COSTS (euro)",null,"Actual number of deliverables","EU-related ratio (%)","TOTAL FINAL COSTS (euro)"]
[null,null,null,"I.5","Staff paid based on deliverables",null,null,null,{"$f":"SUM(I44:I45)-I45","v":0},"Staff paid based on deliverables",null,null,{"$f":"ROUNDDOWN((SUM(M44:M45)-M45),2)","v":0}]
[1,null,null,null,0,null,0,0,{"$f":"ROUNDDOWN(E44*G44*H44,2)","v":0},null,0,0,{"$f":"ROUNDDOWN(E44*K44*L44,2)","v":0}]
[null,"DO NOT DELETE & MUST BE HIDDEN!"]
[null,null,null,"II","Total eligible direct administrative costs",null,null,null,{"$f":"ROUNDDOWN((I49+I51+I53),2)","v":0},"Total eligible direct administrative costs",null,null,{"$f":"ROUNDDOWN((M49+M51+IF(M63=\"N/A\",M53,M63)),2)","v":0}]
[3,null,null,null,null,null,null,null,null,"Exchange rate (Art. 4.5 SGA)",null,null,{"$f":"'ADM COSTS'!D5","v":1}]
[null,null,null,"II.1 - II.3","Description","Estimated costs\n(euro)","Survey-related ratio (%)","EU-related ratio (%)","TOTAL ESTIMATED COSTS (euro)","Actual Costs (euro)","Survey-related ratio (%)","EU-related ratio (%)","TOTAL FINAL COSTS (euro)"]
[null,null,null,"II.1","Subcontracting costs (please supply full details on separate sheet)",null,null,null,{"$f":"ROUNDDOWN((SUM(I50:I51)-I51),2)","v":0},"Subcontracting costs",null,null,{"$f":"ROUNDDOWN((SUM(M50:M51)-M51),2)","v":0}]
[1,null,null,"Name of subcontractor ",null,0,0,0,{"$f":"ROUNDDOWN(F50*G50*H50,2)","v":0},0,0,0,{"$f":"ROUNDDOWN(J50*K50*L50,2)","v":0}]
[null,null,null,"II.2","Up-date of software/process redesign (please supply detailed budget plan) ",null,null,null,{"$f":"ROUNDDOWN((SUM(I52:I53)-I53),2)","v":0},"Up-date of software/process redesign",null,null,{"$f":"ROUNDDOWN((SUM(M52:M53)-M53),2)","v":0}]
[1,null,null,"Name of new software/process redesign",null,0,0,0,{"$f":"ROUNDDOWN(F52*G52*H52,2)","v":0},0,0,0,{"$f":"ROUNDDOWN(J52*K52*L52,2)","v":0}]
[null,null,null,"II.3","Administrative costs (under flat rate financing or real incurred)",null,null,null,{"$f":"ROUNDDOWN((SUM(I54:I62)-I62),2)","v":0},"Real incurred administrative costs ",null,null,{"$f":"IF(M63=\"N/A\",ROUNDDOWN((SUM(M54:M62)-M62),2),0)","v":0}]
[1,null,null,"Costs for travel and subsistence allowances",null,0,0,0,{"$f":"ROUNDDOWN(F54*G54*H54,2)","v":0},0,0,0,{"$f":"ROUNDDOWN(J54*K54*L54,2)","v":0}]
[1,null,null,"Costs for printing",null,0,0,0,0,0,0,0,{"$f":"ROUNDDOWN(J55*K55*L55,2)","v":0}]
[1,null,null,"Costs for mailing ",null,0,0,0,0,0,0,0,0]
[1,null,null,"Costs for communication",null,0,0,0,0,0,0,0,0]
[1,null,null,"Costs for translation",null,0,0,0,0,0,0,0,0]
[1,null,null,"Costs of materials (consumables and supplies assigned to the action)",null,0,0,0,0,0,0,0,0]
[1,null,null,"Costs for fees for IT Software and data - PLEASE CLEARLY DESCRIBE",null,0,0,0,0,0,0,0,0]
[1,null,null,"Certain other costs arising directly from requirements imposed by the agreement - PLEASE CLEARLY DESCRIBE",null,0,0,0,0,0,0,0,0]
[]
[null,null,null,"Flat-rate financing if administrative costs (excl. II.1 & II.2) ≤ 50% of total eligible staff costs (%)",null,null,null,null,{"$f":"IF(I22>0,I53/I22,0)","v":0},"Flat-rate financing for administrative costs (euro)",null,null,{"$f":"IF(I63>0.5,\"N/A\",ROUNDDOWN((M22*I63),2))","v":0}]
[null,null,null,null,"Eligible indirect costs (7% of total eligible direct costs excluding costs for subcontracting)",null,null,null,{"$f":"ROUNDDOWN(0.07*(Direct_Costs-Subcontracting_Costs),2)","v":0},"Eligible indirect costs (Art. 3.2 SGA)",null,null,{"$f":"ROUNDDOWN(0.07*(Direct_Costs_Final-Subcontracting_Costs_Final),2)","v":0}]
[]
[null,null,null,null,"Indirect costs percentage",null,null,null,7.0000000000000007E-2,"Indirect costs percentage",null,null,{"$f":"I66","v":7.0000000000000007E-2}]

{"sheet":"Construction","index":8,"n_rows":66,"n_cols":13,"rows_kept":66,"cut":false,"hidden":false,"merged":[[65,4,65,7],[65,9,65,11],[56,3,56,4],[57,3,57,4],[58,3,58,4],[59,3,59,4],[60,3,60,4],[62,3,62,7],[62,9,62,11],[63,4,63,7],[63,9,63,11],[55,3,55,4],[36,9,36,11],[42,4,42,7],[45,4,45,7],[45,9,45,11],[46,3,46,8],[48,9,48,11],[49,3,49,4],[51,3,51,4],[53,3,53,4],[54,3,54,4],[46,9,46,11],[30,5,30,7],[30,9,30,11],[32,5,32,7],[32,9,32,11],[34,5,34,7],[34,9,34,11],[24,5,24,7],[24,9,24,11],[26,5,26,7],[26,9,26,11],[28,5,28,7],[28,9,28,11],[23,20,23,23],[18,3,18,4],[18,5,18,8],[18,9,18,12],[19,3,20,3],[19,4,19,7],[19,9,19,11],[20,4,20,7],[20,9,20,11],[21,4,21,7],[21,9,21,11],[23,5,23,7],[23,9,23,11],[23,15,23,19],[14,4,14,7],[14,9,14,11],[15,4,15,7],[15,9,15,11],[16,4,16,7],[16,9,16,11],[11,4,11,7],[11,9,11,11],[12,4,12,7],[12,9,12,11],[13,4,13,7],[13,9,13,11],[8,5,8,8],[8,9,8,12],[9,4,9,7],[9,9,9,11],[10,4,10,7],[10,9,10,11],[5,2,5,12],[0,2,0,12],[1,2,1,12],[2,2,2,12],[3,2,3,12],[4,2,4,12]]}
[null,null,{"$f":"Configuration!B1","v":"BUDGET AND FINAL FINANCIAL STATEMENT FOR GRANT AGREEMENT PERIOD MAY 2023 - APRIL 2024"}]
[false,null,{"$f":"Configuration!B2","v":"ANNEX V OF THE FRAMEWORK PARTNERSHIP AGREEMENT"}]
[null,null,{"$f":"Configuration!B3","v":"ANNEX II OF THE SPECIFIC GRANT AGREEMENT"}]
[null,null,{"$f":"Configuration!B4","v":"FINANCING PLAN AND COSTS OF THE SURVEYS"}]
[null,null,{"$f":"Configuration!B5","v":"(see Framework partnership agreement: Article II.19 on Eligible costs)"}]
[null,null,{"$f":"Configuration!B7","v":"ECFIN/XXX/2023/000000"}]
[null,null,null,"INSTITUTION:",{"$f":"'Guidance BS'!B10","v":"Country"},{"$f":"'Guidance BS'!B12","v":"Acronym institution"}]
[null,null,null,"SURVEYS:","Construction"]
[null,null,null,null,"FINANCING PLAN ","BUDGET (euro)",null,null,null,"FINAL (euro)"]
[null,null,null,null,"TOTAL ESTIMATED INCOME",null,null,null,{"$f":"I20","v":0},"TOTAL INCOME",null,null,{"$f":"M20","v":0}]
[3,null,null,null,"Direct revenue expected from the action: please indicate here the source of the revenue",null,null,null,0,"Indicate here the source of revenue",null,null,0]
[3,null,null,null,"Contributions from other organisations: please indicate here the source of the funds",null,null,null,0,"Indicate here the source of funds",null,null,0]
[null,{"$f":"M20-IF(M20>I20,I14,M20*I17)-M12-M11","v":0},null,null,"Own contribution",null,null,null,{"$f":"IF(I20-I14-I12-I11<0,0,I20-I14-I12-I11)","v":0},"Own contribution",null,null,{"$f":"IF(M20-M14-M12-M11<0,0,M20-M14-M12-M11)","v":0}]
[null,{"$f":"I10-I11-I12-(I20)*$I$17","v":0},null,null,"Grant requested from the Commission",null,null,null,{"$f":"IF(B14<0,ROUNDDOWN(ROUND(I20,2)*$I$17,2)+B14,ROUNDDOWN(ROUND(I20,2)*$I$17,2))","v":0},"Grant requested from the Commission",null,null,{"$f":"IF(M20>I20,IF(B13<0,I14+B13,I14),IF(B13<0,ROUNDDOWN(ROUND(M20,2)*I17,2)+B13,ROUNDDOWN(ROUND(M20,2)*I17,2)))","v":0}]
[null,null,null,null,"Pre-financing payment (40% of the grant)",null,null,null,{"$f":"40*I14/100","v":0},"Pre-financing payment received",null,null,{"$f":"I15","v":0}]
[null,null,null,null,null,null,null,null,null,"FINAL PAYMENT REQUEST",null,null,{"$f":"M14-M15","v":0}]
[4,null,null,null,"Grant percentage",null,null,null,0,null,null,null,{"$f":"I17","v":0}]
[]
[null,null,null,"ESTIMATED ELIGIBLE COSTS / EXPENDITURES",null,"BUDGET (euro)",null,null,null,"FINAL (euro)"]
[null,null,null,"Budget item","TOTAL ESTIMATED COSTS",null,null,null,{"$f":"ROUNDDOWN((I21+I64),2)","v":0},"TOTAL FINAL COSTS",null,null,{"$f":"ROUNDDOWN((M21+M64),2)","v":0}]
[null,null,null,null,"Total estimated eligible direct costs",null,null,null,{"$f":"ROUNDDOWN((I22+I46),2)","v":0},"Total final eligible direct costs",null,null,{"$f":"ROUNDDOWN((M22+M46),2)","v":0}]
[null,null,null,"I","Total eligible direct staff costs",null,null,null,{"$f":"ROUNDDOWN((I24+I35+I37+I39+I43),2)","v":0},"Total eligible direct staff costs",null,null,{"$f":"ROUNDDOWN((M24+M35+M37+M39+M43),2)","v":0}]
[null,null,null,"I.1 - I.4","daily rate per pay grade (see ANNEX III SGA)","No. of people","Estimated working days","EU-related ratio (%)","TOTAL ESTIMATED COSTS (euro)","No. of people","Total worked days","EU-related ratio (%)","TOTAL\nFINAL COSTS (euro)"]
[null,null,null,"I.1","Permanent staff",null,null,null,{"$f":"ROUNDDOWN((I25+I27+I29+I31+I33),2)","v":0},"Permanent staff",null,null,{"$f":"ROUNDDOWN((M25+M27+M29+M31+M33),2)","v":0}]
[null,null,null,null,"- Managers",null,null,null,{"$f":"SUM(I26:I27)-I27","v":0},"- Managers",null,null,{"$f":"SUM(M26:M27)-M27","v":0}]
[1,null,null,null,0,0,0,0,{"$f":"ROUNDDOWN(E26*F26*G26*H26,2)","v":0},0,0,0,{"$f":"ROUNDDOWN(E26*J26*K26*L26,2)","v":0}]
[null,null,null,null,"- Researchers",null,null,null,{"$f":"SUM(I28:I29)-I29","v":0},"- Researchers",null,null,{"$f":"SUM(M28:M29)-M29","v":0}]
[1,null,null,null,0,0,0,0,{"$f":"ROUNDDOWN(E28*F28*G28*H28,2)","v":0},0,0,0,{"$f":"ROUNDDOWN(E28*J28*K28*L28,2)","v":0}]
[null,null,null,null,"- Interviewers",null,null,null,{"$f":"SUM(I30:I31)-I31","v":0},"- Interviewers",null,null,{"$f":"SUM(M30:M31)-M31","v":0}]
[1,null,null,null,0,0,0,0,{"$f":"ROUNDDOWN(E30*F30*G30*H30,2)","v":0},0,0,0,{"$f":"ROUNDDOWN(E30*J30*K30*L30,2)","v":0}]
[null,null,null,null,"- Technical staff",null,null,null,{"$f":"SUM(I32:I33)-I33","v":0},"- Technical staff",null,null,{"$f":"SUM(M32:M33)-M33","v":0}]
[1,null,null,null,0,0,0,0,{"$f":"ROUNDDOWN(E32*F32*G32*H32,2)","v":0},0,0,0,{"$f":"ROUNDDOWN(E32*J32*K32*L32,2)","v":0}]
[null,null,null,null,"- Administrative staff",null,null,null,{"$f":"SUM(I34:I35)-I35","v":0},"- Administrative staff",null,null,{"$f":"SUM(M34:M35)-M35","v":0}]
[1,null,null,null,0,0,0,0,{"$f":"ROUNDDOWN(E34*F34*G34*H34,2)","v":0},0,0,0,{"$f":"ROUNDDOWN(E34*J34*K34*L34,2)","v":0}]
[null,null,null,"I.2","Temporary staff:",null,null,null,{"$f":"SUM(I36:I37)-I37","v":0},"Temporary staff",null,null,{"$f":"SUM(M36:M37)-M37","v":0}]
[1,null,null,null,0,0,0,0,{"$f":"ROUNDDOWN(E36*F36*G36*H36,2)","v":0},0,0,0,{"$f":"ROUNDDOWN(E36*J36*K36*L36,2)","v":0}]
[null,null,null,"I.3","Staff under civil contracts specifically recruited for the project",null,null,null,{"$f":"SUM(I38:I39)-I39","v":0},"Staff under civil contracts",null,null,{"$f":"SUM(M38:M39)-M39","v":0}]
[1,null,null,null,0,0,0,0,{"$f":"ROUNDDOWN(E38*F38*G38*H38,2)","v":0},0,0,0,{"$f":"ROUNDDOWN(E38*J38*K38*L38,2)","v":0}]
[null,null,null,"I.4","Staff seconded by a third party against payment (no invoice)",null,null,null,{"$f":"SUM(I40:I41)-I41","v":0},"Staff seconded by a third party",null,null,{"$f":"ROUNDDOWN((SUM(M40:M41)-M41),2)","v":0}]
[1,null,null,null,0,0,0,0,{"$f":"ROUNDDOWN(E40*F40*G40*H40,2)","v":0},0,0,0,{"$f":"ROUNDDOWN(E40*J40*K40*L40,2)","v":0}]
[null,"DO NOT DELETE & MUST BE HIDDEN!"]
[null,null,null,"I.5","price per deliverable (see ANNEX III SGA)",null,"estimated number deliverables","EU-related ratio (%)","TOTAL ESTIMATED COSTS (euro)",null,"Actual number of deliverables","EU-related ratio (%)","TOTAL FINAL COSTS (euro)"]
[null,null,null,"I.5","Staff paid based on deliverables",null,null,null,{"$f":"SUM(I44:I45)-I45","v":0},"Staff paid based on deliverables",null,null,{"$f":"ROUNDDOWN((SUM(M44:M45)-M45),2)","v":0}]
[1,null,null,null,0,null,0,0,{"$f":"ROUNDDOWN(E44*G44*H44,2)","v":0},null,0,0,{"$f":"ROUNDDOWN(E44*K44*L44,2)","v":0}]
[null,"DO NOT DELETE & MUST BE HIDDEN!"]
[null,null,null,"II","Total eligible direct administrative costs",null,null,null,{"$f":"ROUNDDOWN((I49+I51+I53),2)","v":0},"Total eligible direct administrative costs",null,null,{"$f":"ROUNDDOWN((M49+M51+IF(M63=\"N/A\",M53,M63)),2)","v":0}]
[3,null,null,null,null,null,null,null,null,"Exchange rate (Art. 4.5 SGA)",null,null,{"$f":"'ADM COSTS'!D5","v":1}]
[null,null,null,"II.1 - II.3","Description","Estimated costs\n(euro)","Survey-related ratio (%)","EU-related ratio (%)","TOTAL ESTIMATED COSTS (euro)","Actual Costs (euro)","Survey-related ratio (%)","EU-related ratio (%)","TOTAL FINAL COSTS (euro)"]
[null,null,null,"II.1","Subcontracting costs (please supply full details on separate sheet)",null,null,null,{"$f":"ROUNDDOWN((SUM(I50:I51)-I51),2)","v":0},"Subcontracting costs",null,null,{"$f":"ROUNDDOWN((SUM(M50:M51)-M51),2)","v":0}]
[1,null,null,"Name of subcontractor ",null,0,0,0,{"$f":"ROUNDDOWN(F50*G50*H50,2)","v":0},0,0,0,{"$f":"ROUNDDOWN(J50*K50*L50,2)","v":0}]
[null,null,null,"II.2","Up-date of software/process redesign (please supply detailed budget plan) ",null,null,null,{"$f":"ROUNDDOWN((SUM(I52:I53)-I53),2)","v":0},"Up-date of software/process redesign",null,null,{"$f":"ROUNDDOWN((SUM(M52:M53)-M53),2)","v":0}]
[1,null,null,"Name of new software/process redesign",null,0,0,0,{"$f":"ROUNDDOWN(F52*G52*H52,2)","v":0},0,0,0,{"$f":"ROUNDDOWN(J52*K52*L52,2)","v":0}]
[null,null,null,"II.3","Administrative costs (under flat rate financing or real incurred)",null,null,null,{"$f":"ROUNDDOWN((SUM(I54:I62)-I62),2)","v":0},"Real incurred administrative costs ",null,null,{"$f":"IF(M63=\"N/A\",ROUNDDOWN((SUM(M54:M62)-M62),2),0)","v":0}]
[1,null,null,"Costs for travel and subsistence allowances",null,0,0,0,{"$f":"ROUNDDOWN(F54*G54*H54,2)","v":0},0,0,0,{"$f":"ROUNDDOWN(J54*K54*L54,2)","v":0}]
[1,null,null,"Costs for printing",null,0,0,0,0,0,0,0,{"$f":"ROUNDDOWN(J55*K55*L55,2)","v":0}]
[1,null,null,"Costs for mailing ",null,0,0,0,0,0,0,0,0]
[1,null,null,"Costs for communication",null,0,0,0,0,0,0,0,0]
[1,null,null,"Costs for translation",null,0,0,0,0,0,0,0,0]
[1,null,null,"Costs of materials (consumables and supplies assigned to the action)",null,0,0,0,0,0,0,0,0]
[1,null,null,"Costs for fees for IT Software and data - PLEASE CLEARLY DESCRIBE",null,0,0,0,0,0,0,0,0]
[1,null,null,"Certain other costs arising directly from requirements imposed by the agreement - PLEASE CLEARLY DESCRIBE",null,0,0,0,0,0,0,0,0]
[]
[null,null,null,"Flat-rate financing if administrative costs (excl. II.1 & II.2) ≤ 50% of total eligible staff costs (%)",null,null,null,null,{"$f":"IF(I22>0,I53/I22,0)","v":0},"Flat-rate financing for administrative costs (euro)",null,null,{"$f":"IF(I63>0.5,\"N/A\",ROUNDDOWN((M22*I63),2))","v":0}]
[null,null,null,null,"Eligible indirect costs (7% of total eligible direct costs excluding costs for subcontracting)",null,null,null,{"$f":"ROUNDDOWN(0.07*(Direct_Costs-Subcontracting_Costs),2)","v":0},"Eligible indirect costs (Art. 3.2 SGA)",null,null,{"$f":"ROUNDDOWN(0.07*(Direct_Costs_Final-Subcontracting_Costs_Final),2)","v":0}]
[]
[null,null,null,null,"Indirect costs percentage",null,null,null,7.0000000000000007E-2,"Indirect costs percentage",null,null,{"$f":"I66","v":7.0000000000000007E-2}]

{"sheet":"Industry","index":9,"n_rows":66,"n_cols":13,"rows_kept":66,"cut":false,"hidden":false,"merged":[[65,4,65,7],[65,9,65,11],[56,3,56,4],[57,3,57,4],[58,3,58,4],[59,3,59,4],[60,3,60,4],[62,3,62,7],[62,9,62,11],[63,4,63,7],[63,9,63,11],[55,3,55,4],[36,9,36,11],[42,4,42,7],[45,4,45,7],[45,9,45,11],[46,3,46,8],[48,9,48,11],[49,3,49,4],[51,3,51,4],[53,3,53,4],[54,3,54,4],[46,9,46,11],[30,5,30,7],[30,9,30,11],[32,5,32,7],[32,9,32,11],[34,5,34,7],[34,9,34,11],[24,5,24,7],[24,9,24,11],[26,5,26,7],[26,9,26,11],[28,5,28,7],[28,9,28,11],[23,20,23,23],[18,3,18,4],[18,5,18,8],[18,9,18,12],[19,3,20,3],[19,4,19,7],[19,9,19,11],[20,4,20,7],[20,9,20,11],[21,4,21,7],[21,9,21,11],[23,5,23,7],[23,9,23,11],[23,15,23,19],[14,4,14,7],[14,9,14,11],[15,4,15,7],[15,9,15,11],[16,4,16,7],[16,9,16,11],[11,4,11,7],[11,9,11,11],[12,4,12,7],[12,9,12,11],[13,4,13,7],[13,9,13,11],[8,5,8,8],[8,9,8,12],[9,4,9,7],[9,9,9,11],[10,4,10,7],[10,9,10,11],[5,2,5,12],[0,2,0,12],[1,2,1,12],[2,2,2,12],[3,2,3,12],[4,2,4,12]]}
[null,null,{"$f":"Configuration!B1","v":"BUDGET AND FINAL FINANCIAL STATEMENT FOR GRANT AGREEMENT PERIOD MAY 2023 - APRIL 2024"}]
[true,null,{"$f":"Configuration!B2","v":"ANNEX V OF THE FRAMEWORK PARTNERSHIP AGREEMENT"}]
[null,null,{"$f":"Configuration!B3","v":"ANNEX II OF THE SPECIFIC GRANT AGREEMENT"}]
[null,null,{"$f":"Configuration!B4","v":"FINANCING PLAN AND COSTS OF THE SURVEYS"}]
[null,null,{"$f":"Configuration!B5","v":"(see Framework partnership agreement: Article II.19 on Eligible costs)"}]
[null,null,{"$f":"Configuration!B7","v":"ECFIN/XXX/2023/000000"}]
[null,null,null,"INSTITUTION:",{"$f":"'Guidance BS'!B10","v":"Country"},{"$f":"'Guidance BS'!B12","v":"Acronym institution"}]
[null,null,null,"SURVEYS:","Industry"]
[null,null,null,null,"FINANCING PLAN ","BUDGET (euro)",null,null,null,"FINAL (euro)"]
[null,null,null,null,"TOTAL ESTIMATED INCOME",null,null,null,{"$f":"I20","v":0},"TOTAL INCOME",null,null,{"$f":"M20","v":0}]
[3,null,null,null,"Direct revenue expected from the action: please indicate here the source of the revenue",null,null,null,0,"Indicate here the source of revenue",null,null,0]
[3,null,null,null,"Contributions from other organisations: please indicate here the source of the funds",null,null,null,0,"Indicate here the source of funds",null,null,0]
[null,{"$f":"M20-IF(M20>I20,I14,M20*I17)-M12-M11","v":0},null,null,"Own contribution",null,null,null,{"$f":"IF(I20-I14-I12-I11<0,0,I20-I14-I12-I11)","v":0},"Own contribution",null,null,{"$f":"IF(M20-M14-M12-M11<0,0,M20-M14-M12-M11)","v":0}]
[null,{"$f":"I10-I11-I12-(I20)*$I$17","v":0},null,null,"Grant requested from the Commission",null,null,null,{"$f":"IF(B14<0,ROUNDDOWN(ROUND(I20,2)*$I$17,2)+B14,ROUNDDOWN(ROUND(I20,2)*$I$17,2))","v":0},"Grant requested from the Commission",null,null,{"$f":"IF(M20>I20,IF(B13<0,I14+B13,I14),IF(B13<0,ROUNDDOWN(ROUND(M20,2)*I17,2)+B13,ROUNDDOWN(ROUND(M20,2)*I17,2)))","v":0}]
[null,null,null,null,"Pre-financing payment (40% of the grant)",null,null,null,{"$f":"40*I14/100","v":0},"Pre-financing payment received",null,null,{"$f":"I15","v":0}]
[null,null,null,null,null,null,null,null,null,"FINAL PAYMENT REQUEST",null,null,{"$f":"M14-M15","v":0}]
[4,null,null,null,"Grant percentage",null,null,null,0,null,null,null,{"$f":"I17","v":0}]
[]
[null,null,null,"ESTIMATED ELIGIBLE COSTS / EXPENDITURES",null,"BUDGET (euro)",null,null,null,"FINAL (euro)"]
[null,null,null,"Budget item","TOTAL ESTIMATED COSTS",null,null,null,{"$f":"ROUNDDOWN((I21+I64),2)","v":0},"TOTAL FINAL COSTS",null,null,{"$f":"ROUNDDOWN((M21+M64),2)","v":0}]
[null,null,null,null,"Total estimated eligible direct costs",null,null,null,{"$f":"ROUNDDOWN((I22+I46),2)","v":0},"Total final eligible direct costs",null,null,{"$f":"ROUNDDOWN((M22+M46),2)","v":0}]
[null,null,null,"I","Total eligible direct staff costs",null,null,null,{"$f":"ROUNDDOWN((I24+I35+I37+I39+I43),2)","v":0},"Total eligible direct staff costs",null,null,{"$f":"ROUNDDOWN((M24+M35+M37+M39+M43),2)","v":0}]
[null,null,null,"I.1 - I.4","daily rate per pay grade (see ANNEX III SGA)","No. of people","Estimated working days","EU-related ratio (%)","TOTAL ESTIMATED COSTS (euro)","No. of people","Total worked days","EU-related ratio (%)","TOTAL\nFINAL COSTS (euro)"]
[null,null,null,"I.1","Permanent staff",null,null,null,{"$f":"ROUNDDOWN((I25+I27+I29+I31+I33),2)","v":0},"Permanent staff",null,null,{"$f":"ROUNDDOWN((M25+M27+M29+M31+M33),2)","v":0}]
[null,null,null,null,"- Managers",null,null,null,{"$f":"SUM(I26:I27)-I27","v":0},"- Managers",null,null,{"$f":"SUM(M26:M27)-M27","v":0}]
[1,null,null,null,0,0,0,0,{"$f":"ROUNDDOWN(E26*F26*G26*H26,2)","v":0},0,0,0,{"$f":"ROUNDDOWN(E26*J26*K26*L26,2)","v":0}]
[null,null,null,null,"- Researchers",null,null,null,{"$f":"SUM(I28:I29)-I29","v":0},"- Researchers",null,null,{"$f":"SUM(M28:M29)-M29","v":0}]
[1,null,null,null,0,0,0,0,{"$f":"ROUNDDOWN(E28*F28*G28*H28,2)","v":0},0,0,0,{"$f":"ROUNDDOWN(E28*J28*K28*L28,2)","v":0}]
[null,null,null,null,"- Interviewers",null,null,null,{"$f":"SUM(I30:I31)-I31","v":0},"- Interviewers",null,null,{"$f":"SUM(M30:M31)-M31","v":0}]
[1,null,null,null,0,0,0,0,{"$f":"ROUNDDOWN(E30*F30*G30*H30,2)","v":0},0,0,0,{"$f":"ROUNDDOWN(E30*J30*K30*L30,2)","v":0}]
[null,null,null,null,"- Technical staff",null,null,null,{"$f":"SUM(I32:I33)-I33","v":0},"- Technical staff",null,null,{"$f":"SUM(M32:M33)-M33","v":0}]
[1,null,null,null,0,0,0,0,{"$f":"ROUNDDOWN(E32*F32*G32*H32,2)","v":0},0,0,0,{"$f":"ROUNDDOWN(E32*J32*K32*L32,2)","v":0}]
[null,null,null,null,"- Administrative staff",null,null,null,{"$f":"SUM(I34:I35)-I35","v":0},"- Administrative staff",null,null,{"$f":"SUM(M34:M35)-M35","v":0}]
[1,null,null,null,0,0,0,0,{"$f":"ROUNDDOWN(E34*F34*G34*H34,2)","v":0},0,0,0,{"$f":"ROUNDDOWN(E34*J34*K34*L34,2)","v":0}]
[null,null,null,"I.2","Temporary staff:",null,null,null,{"$f":"SUM(I36:I37)-I37","v":0},"Temporary staff",null,null,{"$f":"SUM(M36:M37)-M37","v":0}]
[1,null,null,null,0,0,0,0,{"$f":"ROUNDDOWN(E36*F36*G36*H36,2)","v":0},0,0,0,{"$f":"ROUNDDOWN(E36*J36*K36*L36,2)","v":0}]
[null,null,null,"I.3","Staff under civil contracts specifically recruited for the project",null,null,null,{"$f":"SUM(I38:I39)-I39","v":0},"Staff under civil contracts",null,null,{"$f":"SUM(M38:M39)-M39","v":0}]
[1,null,null,null,0,0,0,0,{"$f":"ROUNDDOWN(E38*F38*G38*H38,2)","v":0},0,0,0,{"$f":"ROUNDDOWN(E38*J38*K38*L38,2)","v":0}]
[null,null,null,"I.4","Staff seconded by a third party against payment (no invoice)",null,null,null,{"$f":"SUM(I40:I41)-I41","v":0},"Staff seconded by a third party",null,null,{"$f":"ROUNDDOWN((SUM(M40:M41)-M41),2)","v":0}]
[1,null,null,null,0,0,0,0,{"$f":"ROUNDDOWN(E40*F40*G40*H40,2)","v":0},0,0,0,{"$f":"ROUNDDOWN(E40*J40*K40*L40,2)","v":0}]
[null,"DO NOT DELETE & MUST BE HIDDEN!"]
[null,null,null,"I.5","price per deliverable (see ANNEX III SGA)",null,"estimated number deliverables","EU-related ratio (%)","TOTAL ESTIMATED COSTS (euro)",null,"Actual number of deliverables","EU-related ratio (%)","TOTAL FINAL COSTS (euro)"]
[null,null,null,"I.5","Staff paid based on deliverables",null,null,null,{"$f":"SUM(I44:I45)-I45","v":0},"Staff paid based on deliverables",null,null,{"$f":"ROUNDDOWN((SUM(M44:M45)-M45),2)","v":0}]
[1,null,null,null,0,null,0,0,{"$f":"ROUNDDOWN(E44*G44*H44,2)","v":0},null,0,0,{"$f":"ROUNDDOWN(E44*K44*L44,2)","v":0}]
[null,"DO NOT DELETE & MUST BE HIDDEN!"]
[null,null,null,"II","Total eligible direct administrative costs",null,null,null,{"$f":"ROUNDDOWN((I49+I51+I53),2)","v":0},"Total eligible direct administrative costs",null,null,{"$f":"ROUNDDOWN((M49+M51+IF(M63=\"N/A\",M53,M63)),2)","v":0}]
[3,null,null,null,null,null,null,null,null,"Exchange rate (Art. 4.5 SGA)",null,null,{"$f":"'ADM COSTS'!D5","v":1}]
[null,null,null,"II.1 - II.3","Description","Estimated costs\n(euro)","Survey-related ratio (%)","EU-related ratio (%)","TOTAL ESTIMATED COSTS (euro)","Actual Costs (euro)","Survey-related ratio (%)","EU-related ratio (%)","TOTAL FINAL COSTS (euro)"]
[null,null,null,"II.1","Subcontracting costs (please supply full details on separate sheet)",null,null,null,{"$f":"ROUNDDOWN((SUM(I50:I51)-I51),2)","v":0},"Subcontracting costs",null,null,{"$f":"ROUNDDOWN((SUM(M50:M51)-M51),2)","v":0}]
[1,null,null,"Name of subcontractor ",null,0,0,0,{"$f":"ROUNDDOWN(F50*G50*H50,2)","v":0},0,0,0,{"$f":"ROUNDDOWN(J50*K50*L50,2)","v":0}]
[null,null,null,"II.2","Up-date of software/process redesign (please supply detailed budget plan) ",null,null,null,{"$f":"ROUNDDOWN((SUM(I52:I53)-I53),2)","v":0},"Up-date of software/process redesign",null,null,{"$f":"ROUNDDOWN((SUM(M52:M53)-M53),2)","v":0}]
[1,null,null,"Name of new software/process redesign",null,0,0,0,{"$f":"ROUNDDOWN(F52*G52*H52,2)","v":0},0,0,0,{"$f":"ROUNDDOWN(J52*K52*L52,2)","v":0}]
[null,null,null,"II.3","Administrative costs (under flat rate financing or real incurred)",null,null,null,{"$f":"ROUNDDOWN((SUM(I54:I62)-I62),2)","v":0},"Real incurred administrative costs ",null,null,{"$f":"IF(M63=\"N/A\",ROUNDDOWN((SUM(M54:M62)-M62),2),0)","v":0}]
[1,null,null,"Costs for travel and subsistence allowances",null,0,0,0,{"$f":"ROUNDDOWN(F54*G54*H54,2)","v":0},0,0,0,{"$f":"ROUNDDOWN(J54*K54*L54,2)","v":0}]
[1,null,null,"Costs for printing",null,0,0,0,0,0,0,0,{"$f":"ROUNDDOWN(J55*K55*L55,2)","v":0}]
[1,null,null,"Costs for mailing ",null,0,0,0,0,0,0,0,0]
[1,null,null,"Costs for communication",null,0,0,0,0,0,0,0,0]
[1,null,null,"Costs for translation",null,0,0,0,0,0,0,0,0]
[1,null,null,"Costs of materials (consumables and supplies assigned to the action)",null,0,0,0,0,0,0,0,0]
[1,null,null,"Costs for fees for IT Software and data - PLEASE CLEARLY DESCRIBE",null,0,0,0,0,0,0,0,0]
[1,null,null,"Certain other costs arising directly from requirements imposed by the agreement - PLEASE CLEARLY DESCRIBE",null,0,0,0,0,0,0,0,0]
[]
[null,null,null,"Flat-rate financing if administrative costs (excl. II.1 & II.2) ≤ 50% of total eligible staff costs (%)",null,null,null,null,{"$f":"IF(I22>0,I53/I22,0)","v":0},"Flat-rate financing for administrative costs (euro)",null,null,{"$f":"IF(I63>0.5,\"N/A\",ROUNDDOWN((M22*I63),2))","v":0}]
[null,null,null,null,"Eligible indirect costs (7% of total eligible direct costs excluding costs for subcontracting)",null,null,null,{"$f":"ROUNDDOWN(0.07*(Direct_Costs-Subcontracting_Costs),2)","v":0},"Eligible indirect costs (Art. 3.2 SGA)",null,null,{"$f":"ROUNDDOWN(0.07*(Direct_Costs_Final-Subcontracting_Costs_Final),2)","v":0}]
[]
[null,null,null,null,"Indirect costs percentage",null,null,null,7.0000000000000007E-2,"Indirect costs percentage",null,null,{"$f":"I66","v":7.0000000000000007E-2}]

{"sheet":"Retail Trade","index":10,"n_rows":66,"n_cols":13,"rows_kept":66,"cut":false,"hidden":false,"merged":[[65,4,65,7],[65,9,65,11],[56,3,56,4],[57,3,57,4],[58,3,58,4],[59,3,59,4],[60,3,60,4],[62,3,62,7],[62,9,62,11],[63,4,63,7],[63,9,63,11],[55,3,55,4],[36,9,36,11],[42,4,42,7],[45,4,45,7],[45,9,45,11],[46,3,46,8],[48,9,48,11],[49,3,49,4],[51,3,51,4],[53,3,53,4],[54,3,54,4],[46,9,46,11],[30,5,30,7],[30,9,30,11],[32,5,32,7],[32,9,32,11],[34,5,34,7],[34,9,34,11],[24,5,24,7],[24,9,24,11],[26,5,26,7],[26,9,26,11],[28,5,28,7],[28,9,28,11],[23,20,23,23],[18,3,18,4],[18,5,18,8],[18,9,18,12],[19,3,20,3],[19,4,19,7],[19,9,19,11],[20,4,20,7],[20,9,20,11],[21,4,21,7],[21,9,21,11],[23,5,23,7],[23,9,23,11],[23,15,23,19],[14,4,14,7],[14,9,14,11],[15,4,15,7],[15,9,15,11],[16,4,16,7],[16,9,16,11],[11,4,11,7],[11,9,11,11],[12,4,12,7],[12,9,12,11],[13,4,13,7],[13,9,13,11],[8,5,8,8],[8,9,8,12],[9,4,9,7],[9,9,9,11],[10,4,10,7],[10,9,10,11],[5,2,5,12],[0,2,0,12],[1,2,1,12],[2,2,2,12],[3,2,3,12],[4,2,4,12]]}
[null,null,{"$f":"Configuration!B1","v":"BUDGET AND FINAL FINANCIAL STATEMENT FOR GRANT AGREEMENT PERIOD MAY 2023 - APRIL 2024"}]
[true,null,{"$f":"Configuration!B2","v":"ANNEX V OF THE FRAMEWORK PARTNERSHIP AGREEMENT"}]
[null,null,{"$f":"Configuration!B3","v":"ANNEX II OF THE SPECIFIC GRANT AGREEMENT"}]
[null,null,{"$f":"Configuration!B4","v":"FINANCING PLAN AND COSTS OF THE SURVEYS"}]
[null,null,{"$f":"Configuration!B5","v":"(see Framework partnership agreement: Article II.19 on Eligible costs)"}]
[null,null,{"$f":"Configuration!B7","v":"ECFIN/XXX/2023/000000"}]
[null,null,null,"INSTITUTION:",{"$f":"'Guidance BS'!B10","v":"Country"},{"$f":"'Guidance BS'!B12","v":"Acronym institution"}]
[null,null,null,"SURVEYS:","Retail Trade"]
[null,null,null,null,"FINANCING PLAN ","BUDGET (euro)",null,null,null,"FINAL (euro)"]
[null,null,null,null,"TOTAL ESTIMATED INCOME",null,null,null,{"$f":"I20","v":0},"TOTAL INCOME",null,null,{"$f":"M20","v":0}]
[3,null,null,null,"Direct revenue expected from the action: please indicate here the source of the revenue",null,null,null,0,"Indicate here the source of revenue",null,null,0]
[3,null,null,null,"Contributions from other organisations: please indicate here the source of the funds",null,null,null,0,"Indicate here the source of funds",null,null,0]
[null,{"$f":"M20-IF(M20>I20,I14,M20*I17)-M12-M11","v":0},null,null,"Own contribution",null,null,null,{"$f":"IF(I20-I14-I12-I11<0,0,I20-I14-I12-I11)","v":0},"Own contribution",null,null,{"$f":"IF(M20-M14-M12-M11<0,0,M20-M14-M12-M11)","v":0}]
[null,{"$f":"I10-I11-I12-(I20)*$I$17","v":0},null,null,"Grant requested from the Commission",null,null,null,{"$f":"IF(B14<0,ROUNDDOWN(ROUND(I20,2)*$I$17,2)+B14,ROUNDDOWN(ROUND(I20,2)*$I$17,2))","v":0},"Grant requested from the Commission",null,null,{"$f":"IF(M20>I20,IF(B13<0,I14+B13,I14),IF(B13<0,ROUNDDOWN(ROUND(M20,2)*I17,2)+B13,ROUNDDOWN(ROUND(M20,2)*I17,2)))","v":0}]
[null,null,null,null,"Pre-financing payment (40% of the grant)",null,null,null,{"$f":"40*I14/100","v":0},"Pre-financing payment received",null,null,{"$f":"I15","v":0}]
[null,null,null,null,null,null,null,null,null,"FINAL PAYMENT REQUEST",null,null,{"$f":"M14-M15","v":0}]
[4,null,null,null,"Grant percentage",null,null,null,0,null,null,null,{"$f":"I17","v":0}]
[]
[null,null,null,"ESTIMATED ELIGIBLE COSTS / EXPENDITURES",null,"BUDGET (euro)",null,null,null,"FINAL (euro)"]
[null,null,null,"Budget item","TOTAL ESTIMATED COSTS",null,null,null,{"$f":"ROUNDDOWN((I21+I64),2)","v":0},"TOTAL FINAL COSTS",null,null,{"$f":"ROUNDDOWN((M21+M64),2)","v":0}]
[null,null,null,null,"Total estimated eligible direct costs",null,null,null,{"$f":"ROUNDDOWN((I22+I46),2)","v":0},"Total final eligible direct costs",null,null,{"$f":"ROUNDDOWN((M22+M46),2)","v":0}]
[null,null,null,"I","Total eligible direct staff costs",null,null,null,{"$f":"ROUNDDOWN((I24+I35+I37+I39+I43),2)","v":0},"Total eligible direct staff costs",null,null,{"$f":"ROUNDDOWN((M24+M35+M37+M39+M43),2)","v":0}]
[null,null,null,"I.1 - I.4","daily rate per pay grade (see ANNEX III SGA)","No. of people","Estimated working days","EU-related ratio (%)","TOTAL ESTIMATED COSTS (euro)","No. of people","Total worked days","EU-related ratio (%)","TOTAL\nFINAL COSTS (euro)"]
[null,null,null,"I.1","Permanent staff",null,null,null,{"$f":"ROUNDDOWN((I25+I27+I29+I31+I33),2)","v":0},"Permanent staff",null,null,{"$f":"ROUNDDOWN((M25+M27+M29+M31+M33),2)","v":0}]
[null,null,null,null,"- Managers",null,null,null,{"$f":"SUM(I26:I27)-I27","v":0},"- Managers",null,null,{"$f":"SUM(M26:M27)-M27","v":0}]
[1,null,null,null,0,0,0,0,{"$f":"ROUNDDOWN(E26*F26*G26*H26,2)","v":0},0,0,0,{"$f":"ROUNDDOWN(E26*J26*K26*L26,2)","v":0}]
[null,null,null,null,"- Researchers",null,null,null,{"$f":"SUM(I28:I29)-I29","v":0},"- Researchers",null,null,{"$f":"SUM(M28:M29)-M29","v":0}]
[1,null,null,null,0,0,0,0,{"$f":"ROUNDDOWN(E28*F28*G28*H28,2)","v":0},0,0,0,{"$f":"ROUNDDOWN(E28*J28*K28*L28,2)","v":0}]
[null,null,null,null,"- Interviewers",null,null,null,{"$f":"SUM(I30:I31)-I31","v":0},"- Interviewers",null,null,{"$f":"SUM(M30:M31)-M31","v":0}]
[1,null,null,null,0,0,0,0,{"$f":"ROUNDDOWN(E30*F30*G30*H30,2)","v":0},0,0,0,{"$f":"ROUNDDOWN(E30*J30*K30*L30,2)","v":0}]
[null,null,null,null,"- Technical staff",null,null,null,{"$f":"SUM(I32:I33)-I33","v":0},"- Technical staff",null,null,{"$f":"SUM(M32:M33)-M33","v":0}]
[1,null,null,null,0,0,0,0,{"$f":"ROUNDDOWN(E32*F32*G32*H32,2)","v":0},0,0,0,{"$f":"ROUNDDOWN(E32*J32*K32*L32,2)","v":0}]
[null,null,null,null,"- Administrative staff",null,null,null,{"$f":"SUM(I34:I35)-I35","v":0},"- Administrative staff",null,null,{"$f":"SUM(M34:M35)-M35","v":0}]
[1,null,null,null,0,0,0,0,{"$f":"ROUNDDOWN(E34*F34*G34*H34,2)","v":0},0,0,0,{"$f":"ROUNDDOWN(E34*J34*K34*L34,2)","v":0}]
[null,null,null,"I.2","Temporary staff:",null,null,null,{"$f":"SUM(I36:I37)-I37","v":0},"Temporary staff",null,null,{"$f":"SUM(M36:M37)-M37","v":0}]
[1,null,null,null,0,0,0,0,{"$f":"ROUNDDOWN(E36*F36*G36*H36,2)","v":0},0,0,0,{"$f":"ROUNDDOWN(E36*J36*K36*L36,2)","v":0}]
[null,null,null,"I.3","Staff under civil contracts specifically recruited for the project",null,null,null,{"$f":"SUM(I38:I39)-I39","v":0},"Staff under civil contracts",null,null,{"$f":"SUM(M38:M39)-M39","v":0}]
[1,null,null,null,0,0,0,0,{"$f":"ROUNDDOWN(E38*F38*G38*H38,2)","v":0},0,0,0,{"$f":"ROUNDDOWN(E38*J38*K38*L38,2)","v":0}]
[null,null,null,"I.4","Staff seconded by a third party against payment (no invoice)",null,null,null,{"$f":"SUM(I40:I41)-I41","v":0},"Staff seconded by a third party",null,null,{"$f":"ROUNDDOWN((SUM(M40:M41)-M41),2)","v":0}]
[1,null,null,null,0,0,0,0,{"$f":"ROUNDDOWN(E40*F40*G40*H40,2)","v":0},0,0,0,{"$f":"ROUNDDOWN(E40*J40*K40*L40,2)","v":0}]
[null,"DO NOT DELETE & MUST BE HIDDEN!"]
[null,null,null,"I.5","price per deliverable (see ANNEX III SGA)",null,"estimated number deliverables","EU-related ratio (%)","TOTAL ESTIMATED COSTS (euro)",null,"Actual number of deliverables","EU-related ratio (%)","TOTAL FINAL COSTS (euro)"]
[null,null,null,"I.5","Staff paid based on deliverables",null,null,null,{"$f":"SUM(I44:I45)-I45","v":0},"Staff paid based on deliverables",null,null,{"$f":"ROUNDDOWN((SUM(M44:M45)-M45),2)","v":0}]
[1,null,null,null,0,null,0,0,{"$f":"ROUNDDOWN(E44*G44*H44,2)","v":0},null,0,0,{"$f":"ROUNDDOWN(E44*K44*L44,2)","v":0}]
[null,"DO NOT DELETE & MUST BE HIDDEN!"]
[null,null,null,"II","Total eligible direct administrative costs",null,null,null,{"$f":"ROUNDDOWN((I49+I51+I53),2)","v":0},"Total eligible direct administrative costs",null,null,{"$f":"ROUNDDOWN((M49+M51+IF(M63=\"N/A\",M53,M63)),2)","v":0}]
[3,null,null,null,null,null,null,null,null,"Exchange rate (Art. 4.5 SGA)",null,null,{"$f":"'ADM COSTS'!D5","v":1}]
[null,null,null,"II.1 - II.3","Description","Estimated costs\n(euro)","Survey-related ratio (%)","EU-related ratio (%)","TOTAL ESTIMATED COSTS (euro)","Actual Costs (euro)","Survey-related ratio (%)","EU-related ratio (%)","TOTAL FINAL COSTS (euro)"]
[null,null,null,"II.1","Subcontracting costs (please supply full details on separate sheet)",null,null,null,{"$f":"ROUNDDOWN((SUM(I50:I51)-I51),2)","v":0},"Subcontracting costs",null,null,{"$f":"ROUNDDOWN((SUM(M50:M51)-M51),2)","v":0}]
[1,null,null,"Name of subcontractor ",null,0,0,0,{"$f":"ROUNDDOWN(F50*G50*H50,2)","v":0},0,0,0,{"$f":"ROUNDDOWN(J50*K50*L50,2)","v":0}]
[null,null,null,"II.2","Up-date of software/process redesign (please supply detailed budget plan) ",null,null,null,{"$f":"ROUNDDOWN((SUM(I52:I53)-I53),2)","v":0},"Up-date of software/process redesign",null,null,{"$f":"ROUNDDOWN((SUM(M52:M53)-M53),2)","v":0}]
[1,null,null,"Name of new software/process redesign",null,0,0,0,{"$f":"ROUNDDOWN(F52*G52*H52,2)","v":0},0,0,0,{"$f":"ROUNDDOWN(J52*K52*L52,2)","v":0}]
[null,null,null,"II.3","Administrative costs (under flat rate financing or real incurred)",null,null,null,{"$f":"ROUNDDOWN((SUM(I54:I62)-I62),2)","v":0},"Real incurred administrative costs ",null,null,{"$f":"IF(M63=\"N/A\",ROUNDDOWN((SUM(M54:M62)-M62),2),0)","v":0}]
[1,null,null,"Costs for travel and subsistence allowances",null,0,0,0,{"$f":"ROUNDDOWN(F54*G54*H54,2)","v":0},0,0,0,{"$f":"ROUNDDOWN(J54*K54*L54,2)","v":0}]
[1,null,null,"Costs for printing",null,0,0,0,0,0,0,0,{"$f":"ROUNDDOWN(J55*K55*L55,2)","v":0}]
[1,null,null,"Costs for mailing ",null,0,0,0,0,0,0,0,0]
[1,null,null,"Costs for communication",null,0,0,0,0,0,0,0,0]
[1,null,null,"Costs for translation",null,0,0,0,0,0,0,0,0]
[1,null,null,"Costs of materials (consumables and supplies assigned to the action)",null,0,0,0,0,0,0,0,0]
[1,null,null,"Costs for fees for IT Software and data - PLEASE CLEARLY DESCRIBE",null,0,0,0,0,0,0,0,0]
[1,null,null,"Certain other costs arising directly from requirements imposed by the agreement - PLEASE CLEARLY DESCRIBE",null,0,0,0,0,0,0,0,0]
[]
[null,null,null,"Flat-rate financing if administrative costs (excl. II.1 & II.2) ≤ 50% of total eligible staff costs (%)",null,null,null,null,{"$f":"IF(I22>0,I53/I22,0)","v":0},"Flat-rate financing for administrative costs (euro)",null,null,{"$f":"IF(I63>0.5,\"N/A\",ROUNDDOWN((M22*I63),2))","v":0}]
[null,null,null,null,"Eligible indirect costs (7% of total eligible direct costs excluding costs for subcontracting)",null,null,null,{"$f":"ROUNDDOWN(0.07*(Direct_Costs-Subcontracting_Costs),2)","v":0},"Eligible indirect costs (Art. 3.2 SGA)",null,null,{"$f":"ROUNDDOWN(0.07*(Direct_Costs_Final-Subcontracting_Costs_Final),2)","v":0}]
[]
[null,null,null,null,"Indirect costs percentage",null,null,null,7.0000000000000007E-2,"Indirect costs percentage",null,null,{"$f":"I66","v":7.0000000000000007E-2}]

{"sheet":"Services","index":11,"n_rows":66,"n_cols":13,"rows_kept":66,"cut":false,"hidden":false,"merged":[[65,4,65,7],[65,9,65,11],[56,3,56,4],[57,3,57,4],[58,3,58,4],[59,3,59,4],[60,3,60,4],[62,3,62,7],[62,9,62,11],[63,4,63,7],[63,9,63,11],[55,3,55,4],[36,9,36,11],[42,4,42,7],[45,4,45,7],[45,9,45,11],[46,3,46,8],[48,9,48,11],[49,3,49,4],[51,3,51,4],[53,3,53,4],[54,3,54,4],[46,9,46,11],[30,5,30,7],[30,9,30,11],[32,5,32,7],[32,9,32,11],[34,5,34,7],[34,9,34,11],[24,5,24,7],[24,9,24,11],[26,5,26,7],[26,9,26,11],[28,5,28,7],[28,9,28,11],[23,20,23,23],[18,3,18,4],[18,5,18,8],[18,9,18,12],[19,3,20,3],[19,4,19,7],[19,9,19,11],[20,4,20,7],[20,9,20,11],[21,4,21,7],[21,9,21,11],[23,5,23,7],[23,9,23,11],[23,15,23,19],[14,4,14,7],[14,9,14,11],[15,4,15,7],[15,9,15,11],[16,4,16,7],[16,9,16,11],[11,4,11,7],[11,9,11,11],[12,4,12,7],[12,9,12,11],[13,4,13,7],[13,9,13,11],[8,5,8,8],[8,9,8,12],[9,4,9,7],[9,9,9,11],[10,4,10,7],[10,9,10,11],[5,2,5,12],[0,2,0,12],[1,2,1,12],[2,2,2,12],[3,2,3,12],[4,2,4,12]]}
[null,null,{"$f":"Configuration!B1","v":"BUDGET AND FINAL FINANCIAL STATEMENT FOR GRANT AGREEMENT PERIOD MAY 2023 - APRIL 2024"}]
[false,null,{"$f":"Configuration!B2","v":"ANNEX V OF THE FRAMEWORK PARTNERSHIP AGREEMENT"}]
[null,null,{"$f":"Configuration!B3","v":"ANNEX II OF THE SPECIFIC GRANT AGREEMENT"}]
[null,null,{"$f":"Configuration!B4","v":"FINANCING PLAN AND COSTS OF THE SURVEYS"}]
[null,null,{"$f":"Configuration!B5","v":"(see Framework partnership agreement: Article II.19 on Eligible costs)"}]
[null,null,{"$f":"Configuration!B7","v":"ECFIN/XXX/2023/000000"}]
[null,null,null,"INSTITUTION:",{"$f":"'Guidance BS'!B10","v":"Country"},{"$f":"'Guidance BS'!B12","v":"Acronym institution"}]
[null,null,null,"SURVEYS:","Services"]
[null,null,null,null,"FINANCING PLAN ","BUDGET (euro)",null,null,null,"FINAL (euro)"]
[null,null,null,null,"TOTAL ESTIMATED INCOME",null,null,null,{"$f":"I20","v":0},"TOTAL INCOME",null,null,{"$f":"M20","v":0}]
[3,null,null,null,"Direct revenue expected from the action: please indicate here the source of the revenue",null,null,null,0,"Indicate here the source of revenue",null,null,0]
[3,null,null,null,"Contributions from other organisations: please indicate here the source of the funds",null,null,null,0,"Indicate here the source of funds",null,null,0]
[null,{"$f":"M20-IF(M20>I20,I14,M20*I17)-M12-M11","v":0},null,null,"Own contribution",null,null,null,{"$f":"IF(I20-I14-I12-I11<0,0,I20-I14-I12-I11)","v":0},"Own contribution",null,null,{"$f":"IF(M20-M14-M12-M11<0,0,M20-M14-M12-M11)","v":0}]
[null,{"$f":"I10-I11-I12-(I20)*$I$17","v":0},null,null,"Grant requested from the Commission",null,null,null,{"$f":"IF(B14<0,ROUNDDOWN(ROUND(I20,2)*$I$17,2)+B14,ROUNDDOWN(ROUND(I20,2)*$I$17,2))","v":0},"Grant requested from the Commission",null,null,{"$f":"IF(M20>I20,IF(B13<0,I14+B13,I14),IF(B13<0,ROUNDDOWN(ROUND(M20,2)*I17,2)+B13,ROUNDDOWN(ROUND(M20,2)*I17,2)))","v":0}]
[null,null,null,null,"Pre-financing payment (40% of the grant)",null,null,null,{"$f":"40*I14/100","v":0},"Pre-financing payment received",null,null,{"$f":"I15","v":0}]
[null,null,null,null,null,null,null,null,null,"FINAL PAYMENT REQUEST",null,null,{"$f":"M14-M15","v":0}]
[4,null,null,null,"Grant percentage",null,null,null,0,null,null,null,{"$f":"I17","v":0}]
[]
[null,null,null,"ESTIMATED ELIGIBLE COSTS / EXPENDITURES",null,"BUDGET (euro)",null,null,null,"FINAL (euro)"]
[null,null,null,"Budget item","TOTAL ESTIMATED COSTS",null,null,null,{"$f":"ROUNDDOWN((I21+I64),2)","v":0},"TOTAL FINAL COSTS",null,null,{"$f":"ROUNDDOWN((M21+M64),2)","v":0}]
[null,null,null,null,"Total estimated eligible direct costs",null,null,null,{"$f":"ROUNDDOWN((I22+I46),2)","v":0},"Total final eligible direct costs",null,null,{"$f":"ROUNDDOWN((M22+M46),2)","v":0}]
[null,null,null,"I","Total eligible direct staff costs",null,null,null,{"$f":"ROUNDDOWN((I24+I35+I37+I39+I43),2)","v":0},"Total eligible direct staff costs",null,null,{"$f":"ROUNDDOWN((M24+M35+M37+M39+M43),2)","v":0}]
[null,null,null,"I.1 - I.4","daily rate per pay grade (see ANNEX III SGA)","No. of people","Estimated working days","EU-related ratio (%)","TOTAL ESTIMATED COSTS (euro)","No. of people","Total worked days","EU-related ratio (%)","TOTAL\nFINAL COSTS (euro)"]
[null,null,null,"I.1","Permanent staff",null,null,null,{"$f":"ROUNDDOWN((I25+I27+I29+I31+I33),2)","v":0},"Permanent staff",null,null,{"$f":"ROUNDDOWN((M25+M27+M29+M31+M33),2)","v":0}]
[null,null,null,null,"- Managers",null,null,null,{"$f":"SUM(I26:I27)-I27","v":0},"- Managers",null,null,{"$f":"SUM(M26:M27)-M27","v":0}]
[1,null,null,null,0,0,0,0,{"$f":"ROUNDDOWN(E26*F26*G26*H26,2)","v":0},0,0,0,{"$f":"ROUNDDOWN(E26*J26*K26*L26,2)","v":0}]
[null,null,null,null,"- Researchers",null,null,null,{"$f":"SUM(I28:I29)-I29","v":0},"- Researchers",null,null,{"$f":"SUM(M28:M29)-M29","v":0}]
[1,null,null,null,0,0,0,0,{"$f":"ROUNDDOWN(E28*F28*G28*H28,2)","v":0},0,0,0,{"$f":"ROUNDDOWN(E28*J28*K28*L28,2)","v":0}]
[null,null,null,null,"- Interviewers",null,null,null,{"$f":"SUM(I30:I31)-I31","v":0},"- Interviewers",null,null,{"$f":"SUM(M30:M31)-M31","v":0}]
[1,null,null,null,0,0,0,0,{"$f":"ROUNDDOWN(E30*F30*G30*H30,2)","v":0},0,0,0,{"$f":"ROUNDDOWN(E30*J30*K30*L30,2)","v":0}]
[null,null,null,null,"- Technical staff",null,null,null,{"$f":"SUM(I32:I33)-I33","v":0},"- Technical staff",null,null,{"$f":"SUM(M32:M33)-M33","v":0}]
[1,null,null,null,0,0,0,0,{"$f":"ROUNDDOWN(E32*F32*G32*H32,2)","v":0},0,0,0,{"$f":"ROUNDDOWN(E32*J32*K32*L32,2)","v":0}]
[null,null,null,null,"- Administrative staff",null,null,null,{"$f":"SUM(I34:I35)-I35","v":0},"- Administrative staff",null,null,{"$f":"SUM(M34:M35)-M35","v":0}]
[1,null,null,null,0,0,0,0,{"$f":"ROUNDDOWN(E34*F34*G34*H34,2)","v":0},0,0,0,{"$f":"ROUNDDOWN(E34*J34*K34*L34,2)","v":0}]
[null,null,null,"I.2","Temporary staff:",null,null,null,{"$f":"SUM(I36:I37)-I37","v":0},"Temporary staff",null,null,{"$f":"SUM(M36:M37)-M37","v":0}]
[1,null,null,null,0,0,0,0,{"$f":"ROUNDDOWN(E36*F36*G36*H36,2)","v":0},0,0,0,{"$f":"ROUNDDOWN(E36*J36*K36*L36,2)","v":0}]
[null,null,null,"I.3","Staff under civil contracts specifically recruited for the project",null,null,null,{"$f":"SUM(I38:I39)-I39","v":0},"Staff under civil contracts",null,null,{"$f":"SUM(M38:M39)-M39","v":0}]
[1,null,null,null,0,0,0,0,{"$f":"ROUNDDOWN(E38*F38*G38*H38,2)","v":0},0,0,0,{"$f":"ROUNDDOWN(E38*J38*K38*L38,2)","v":0}]
[null,null,null,"I.4","Staff seconded by a third party against payment (no invoice)",null,null,null,{"$f":"SUM(I40:I41)-I41","v":0},"Staff seconded by a third party",null,null,{"$f":"ROUNDDOWN((SUM(M40:M41)-M41),2)","v":0}]
[1,null,null,null,0,0,0,0,{"$f":"ROUNDDOWN(E40*F40*G40*H40,2)","v":0},0,0,0,{"$f":"ROUNDDOWN(E40*J40*K40*L40,2)","v":0}]
[null,"DO NOT DELETE & MUST BE HIDDEN!"]
[null,null,null,"I.5","price per deliverable (see ANNEX III SGA)",null,"estimated number deliverables","EU-related ratio (%)","TOTAL ESTIMATED COSTS (euro)",null,"Actual number of deliverables","EU-related ratio (%)","TOTAL FINAL COSTS (euro)"]
[null,null,null,"I.5","Staff paid based on deliverables",null,null,null,{"$f":"SUM(I44:I45)-I45","v":0},"Staff paid based on deliverables",null,null,{"$f":"ROUNDDOWN((SUM(M44:M45)-M45),2)","v":0}]
[1,null,null,null,0,null,0,0,{"$f":"ROUNDDOWN(E44*G44*H44,2)","v":0},null,0,0,{"$f":"ROUNDDOWN(E44*K44*L44,2)","v":0}]
[null,"DO NOT DELETE & MUST BE HIDDEN!"]
[null,null,null,"II","Total eligible direct administrative costs",null,null,null,{"$f":"ROUNDDOWN((I49+I51+I53),2)","v":0},"Total eligible direct administrative costs",null,null,{"$f":"ROUNDDOWN((M49+M51+IF(M63=\"N/A\",M53,M63)),2)","v":0}]
[3,null,null,null,null,null,null,null,null,"Exchange rate (Art. 4.5 SGA)",null,null,{"$f":"'ADM COSTS'!D5","v":1}]
[null,null,null,"II.1 - II.3","Description","Estimated costs\n(euro)","Survey-related ratio (%)","EU-related ratio (%)","TOTAL ESTIMATED COSTS (euro)","Actual Costs (euro)","Survey-related ratio (%)","EU-related ratio (%)","TOTAL FINAL COSTS (euro)"]
[null,null,null,"II.1","Subcontracting costs (please supply full details on separate sheet)",null,null,null,{"$f":"ROUNDDOWN((SUM(I50:I51)-I51),2)","v":0},"Subcontracting costs",null,null,{"$f":"ROUNDDOWN((SUM(M50:M51)-M51),2)","v":0}]
[1,null,null,"Name of subcontractor ",null,0,0,0,{"$f":"ROUNDDOWN(F50*G50*H50,2)","v":0},0,0,0,{"$f":"ROUNDDOWN(J50*K50*L50,2)","v":0}]
[null,null,null,"II.2","Up-date of software/process redesign (please supply detailed budget plan) ",null,null,null,{"$f":"ROUNDDOWN((SUM(I52:I53)-I53),2)","v":0},"Up-date of software/process redesign",null,null,{"$f":"ROUNDDOWN((SUM(M52:M53)-M53),2)","v":0}]
[1,null,null,"Name of new software/process redesign",null,0,0,0,{"$f":"ROUNDDOWN(F52*G52*H52,2)","v":0},0,0,0,{"$f":"ROUNDDOWN(J52*K52*L52,2)","v":0}]
[null,null,null,"II.3","Administrative costs (under flat rate financing or real incurred)",null,null,null,{"$f":"ROUNDDOWN((SUM(I54:I62)-I62),2)","v":0},"Real incurred administrative costs ",null,null,{"$f":"IF(M63=\"N/A\",ROUNDDOWN((SUM(M54:M62)-M62),2),0)","v":0}]
[1,null,null,"Costs for travel and subsistence allowances",null,0,0,0,{"$f":"ROUNDDOWN(F54*G54*H54,2)","v":0},0,0,0,{"$f":"ROUNDDOWN(J54*K54*L54,2)","v":0}]
[1,null,null,"Costs for printing",null,0,0,0,0,0,0,0,{"$f":"ROUNDDOWN(J55*K55*L55,2)","v":0}]
[1,null,null,"Costs for mailing ",null,0,0,0,0,0,0,0,0]
[1,null,null,"Costs for communication",null,0,0,0,0,0,0,0,0]
[1,null,null,"Costs for translation",null,0,0,0,0,0,0,0,0]
[1,null,null,"Costs of materials (consumables and supplies assigned to the action)",null,0,0,0,0,0,0,0,0]
[1,null,null,"Costs for fees for IT Software and data - PLEASE CLEARLY DESCRIBE",null,0,0,0,0,0,0,0,0]
[1,null,null,"Certain other costs arising directly from requirements imposed by the agreement - PLEASE CLEARLY DESCRIBE",null,0,0,0,0,0,0,0,0]
[]
[null,null,null,"Flat-rate financing if administrative costs (excl. II.1 & II.2) ≤ 50% of total eligible staff costs (%)",null,null,null,null,{"$f":"IF(I22>0,I53/I22,0)","v":0},"Flat-rate financing for administrative costs (euro)",null,null,{"$f":"IF(I63>0.5,\"N/A\",ROUNDDOWN((M22*I63),2))","v":0}]
[null,null,null,null,"Eligible indirect costs (7% of total eligible direct costs excluding costs for subcontracting)",null,null,null,{"$f":"ROUNDDOWN(0.07*(Direct_Costs-Subcontracting_Costs),2)","v":0},"Eligible indirect costs (Art. 3.2 SGA)",null,null,{"$f":"ROUNDDOWN(0.07*(Direct_Costs_Final-Subcontracting_Costs_Final),2)","v":0}]
[]
[null,null,null,null,"Indirect costs percentage",null,null,null,7.0000000000000007E-2,"Indirect costs percentage",null,null,{"$f":"I66","v":7.0000000000000007E-2}]

{"sheet":"Total","index":12,"n_rows":39,"n_cols":8,"rows_kept":39,"cut":false,"hidden":false,"merged":[[37,3,37,6],[38,3,38,6],[32,7,35,10],[7,4,7,5],[18,3,19,3],[0,2,0,6],[1,2,1,6],[3,2,3,6],[4,2,4,6],[6,4,6,5],[5,2,5,6],[2,2,2,6]]}
[null,null,{"$f":"Configuration!B1","v":"BUDGET AND FINAL FINANCIAL STATEMENT FOR GRANT AGREEMENT PERIOD MAY 2023 - APRIL 2024"}]
[null,null,{"$f":"Configuration!B2","v":"ANNEX V OF THE FRAMEWORK PARTNERSHIP AGREEMENT"}]
[null,null,{"$f":"Configuration!B3","v":"ANNEX II OF THE SPECIFIC GRANT AGREEMENT"}]
[null,null,{"$f":"Configuration!B4","v":"FINANCING PLAN AND COSTS OF THE SURVEYS"}]
[null,null,{"$f":"Configuration!B5","v":"(see Framework partnership agreement: Article II.19 on Eligible costs)"}]
[null,null,{"$f":"Configuration!B7","v":"ECFIN/XXX/2023/000000"}]
[null,null,"INSTITUTION:",{"$f":"'Guidance BS'!B10","v":"Country"},{"$f":"'Guidance BS'!B12","v":"Acronym institution"}]
["",null,"SURVEY(S):",null,{"$f":"IF(Consumer!I10>0,Consumer!E8,\"\") & IF(Construction!I10>0,\"  \" & Construction!E8,\"\") & IF(Industry!I10>0,\"  \" & Industry!E8,\"\") & IF('Retail Trade'!I10>0, \"  \" & 'Retail Trade'!E8,\"\")& IF(Services!I10>0,\"  \" & Services!E8,\"\")","v":""}]
[null,null,null,null,"FINANCING PLAN ","BUDGET (euro)","FINAL (euro)"]
[null,null,null,null,"TOTAL INCOME",{"$f":"F19","v":0},{"$f":"G19","v":0}]
[null,null,null,null,"Direct revenue from the action",{"$f":"Consumer!I11+Construction!I11+Industry!I11+'Retail Trade'!I11+Services!I11","v":0},{"$f":"Consumer!M11+Construction!M11+Industry!M11+'Retail Trade'!M11+Services!M11","v":0}]
[null,null,null,null,"Contributions from other organisations",{"$f":"Consumer!I12+Construction!I12+Industry!I12+'Retail Trade'!I12+Services!I12","v":0},{"$f":"Consumer!M12+Construction!M12+Industry!M12+'Retail Trade'!M12+Services!M12","v":0}]
[{"$f":"G19-IF(G19>F19,F14,G19*#REF!)-G12-G11","v":{"$error":"#REF!"}},null,null,null,"Own contribution",{"$f":"Consumer!I13+Construction!I13+Industry!I13+'Retail Trade'!I13+Services!I13","v":0},{"$f":"Consumer!M13+Construction!M13+Industry!M13+'Retail Trade'!M13+Services!M13","v":0}]
[{"$f":"F10-F11-F12-(F19)*#REF!","v":{"$error":"#REF!"}},null,null,null,"Grant requested from the Commission",{"$f":"Consumer!I14+Construction!I14+Industry!I14+'Retail Trade'!I14+Services!I14","v":0},{"$f":"Consumer!M14+Construction!M14+Industry!M14+'Retail Trade'!M14+Services!M14","v":0}]
[null,null,null,null,"Pre-financing payment (40% of the grant)",{"$f":"Consumer!I15+Construction!I15+Industry!I15+'Retail Trade'!I15+Services!I15","v":0},{"$f":"Consumer!M15+Construction!M15+Industry!M15+'Retail Trade'!M15+Services!M15","v":0}]
[null,null,null,null,"FINAL PAYMENT REQUEST",null,{"$f":"G14-G15","v":0}]
[]
[null,null,null,null,"ESTIMATED / DECLARED FINAL ELIGIBLE COSTS","BUDGET (euro)","FINAL (euro)"]
[null,null,null,"Budget item","TOTAL COSTS",{"$f":"F20+F37","v":0},{"$f":"G20+G37","v":0}]
[null,null,null,null,"Direct costs",{"$f":"F21+F32","v":0},{"$f":"G21+G32","v":0}]
[null,null,null,"I","Staff costs",{"$f":"F22+F28+F29+F30+F31","v":0},{"$f":"G22+G28+G29+G30+G31","v":0}]
[null,null,null,"I.1","Permanent staff",{"$f":"SUM(F23:F27)","v":0},{"$f":"SUM(G23:G27)","v":0}]
[null,null,null,null,"Managers",{"$f":"Consumer!I25+Construction!I25+Industry!I25+'Retail Trade'!I25+Services!I25","v":0},{"$f":"Consumer!M25+Construction!M25+Industry!M25+'Retail Trade'!M25+Services!M25","v":0}]
[null,null,null,null,"Researchers",{"$f":"Consumer!I27+Construction!I27+Industry!I27+'Retail Trade'!I27+Services!I27","v":0},{"$f":"Consumer!M27+Construction!M27+Industry!M27+'Retail Trade'!M27+Services!M27","v":0}]
[null,null,null,null,"Interviewers",{"$f":"Consumer!I29+Construction!I29+Industry!I29+'Retail Trade'!I29+Services!I29","v":0},{"$f":"Consumer!M29+Construction!M29+Industry!M29+'Retail Trade'!M29+Services!M29","v":0}]
[null,null,null,null,"Technical staff",{"$f":"Consumer!I31+Construction!I31+Industry!I31+'Retail Trade'!I31+Services!I31","v":0},{"$f":"Consumer!M31+Construction!M31+Industry!M31+'Retail Trade'!M31+Services!M31","v":0}]
[null,null,null,null,"Administrative staff",{"$f":"Consumer!I33+Construction!I33+Industry!I33+'Retail Trade'!I33+Services!I33","v":0},{"$f":"Consumer!M33+Construction!M33+Industry!M33+'Retail Trade'!M33+Services!M33","v":0}]
[null,null,null,"I.2","Temporary staff",{"$f":"Consumer!I35+Construction!I35+Industry!I35+'Retail Trade'!I35+Services!I35","v":0},{"$f":"Consumer!M35+Construction!M35+Industry!M35+'Retail Trade'!M35+Services!M35","v":0}]
[null,null,null,"I.3","Staff under civil contracts",{"$f":"Consumer!I37+Construction!I37+Industry!I37+'Retail Trade'!I37+Services!I37","v":0},{"$f":"Consumer!M37+Construction!M37+Industry!M37+'Retail Trade'!M37+Services!M37","v":0}]
[null,null,null,"I.4","Seconded staff",{"$f":"Consumer!I39+Construction!I39+Industry!I39+'Retail Trade'!I39+Services!I39","v":0},{"$f":"Consumer!M39+Construction!M39+Industry!M39+'Retail Trade'!M39+Services!M39","v":0}]
[null,null,null,"I.5","Staff paid based on deliverables",{"$f":"Consumer!I43+Construction!I43+Industry!I43+'Retail Trade'!I43+Services!I43","v":0},{"$f":"Consumer!M43+Construction!M43+Industry!M43+'Retail Trade'!M43+Services!M43","v":0}]
[null,null,null,"II","Administrative costs",{"$f":"SUM(F33+F34+F35+F36)","v":0},{"$f":"SUM(G33+G34+G35+G36)","v":0}]
[null,null,null,"II.1","Subcontracting costs",{"$f":"Consumer!I49+Construction!I49+Industry!I49+'Retail Trade'!I49+Services!I49","v":0},{"$f":"Consumer!M49+Construction!M49+Industry!M49+'Retail Trade'!M49+Services!M49","v":0},"G35 should stay empty and the formula in G35 should be in G34! With IF condition: IF F35<=50% then G34=F35*G21; IF not then G34= Consumer!G45+Construction!G45+…= DONE"]
[null,null,null,"II.2","Up-date of software/process design",{"$f":"Consumer!I51+Construction!I51+Industry!I51+'Retail Trade'!I51+Services!I51","v":0},{"$f":"Consumer!M51+Construction!M51+Industry!M51+'Retail Trade'!M51+Services!M51","v":0}]
[null,null,null,"II.3","Administrative costs where flat-rate financing does not apply",{"$f":"IF(Consumer!I63>0.5,Consumer!I53,0)+IF(Construction!I63>0.5,Construction!I53,0)+IF(Industry!I63>0.5,Industry!I53,0)+IF('Retail Trade'!I63>0.5,'Retail Trade'!I53,0)+IF(Services!I63>0.5,Services!I53,0)","v":0},{"$f":"Consumer!M53+Construction!M53+Industry!M53+'Retail Trade'!M53+Services!M53","v":0}]
[null,null,null,"II.3","Administrative costs under flat rate financing",{"$f":"IF(Consumer!I63>0.5,0,Consumer!I53)+IF(Construction!I63>0.5,0,Construction!I53)+IF(Industry!I63>0.5,0,Industry!I53)+IF('Retail Trade'!I63>0.5,0,'Retail Trade'!I53)+IF(Services!I63>0.5,0,Services!I53)","v":0},{"$f":"(0+IF(Consumer!M63=\"N/A\",0,Consumer!M63)+IF(Construction!M63=\"N/A\",0,Construction!M63)+IF(Industry!M63=\"N/A\",0,Industry!M63)+IF('Retail Trade'!M63=\"N/A\",0,'Retail Trade'!M63)+IF(Services!M63=\"N/A\",0,Services!M63))","v":0}]
[null,null,null,null,"Indirect costs",{"$f":"Consumer!I64+Construction!I64+Industry!I64+'Retail Trade'!I64+Services!I64","v":0},{"$f":"Consumer!M64+Construction!M64+Industry!M64+'Retail Trade'!M64+Services!M64","v":0},"CONS + BUIL = 315 + 1260*4 = 5355"]
[]
[null,null,null,"date and signature of legal representative(s)"]

{"sheet":"Sheet1","index":13,"n_rows":27,"n_cols":4,"rows_kept":27,"cut":false,"hidden":true,"merged":[]}
["TESTS:",null,null,"Questions / comments"]
["BCS Tools","SUBCONTRACTING SHEET"]
[]
[null,"Add a subcontracting sheet","ok up to 7"]
[null,"delete a subcontracting sheet","ok"]
[null,"delete the unique subcontracting sheet not possible?","ok"]
[null,"delete a survey sheet not possible?","ok"]
[]
[null,"CONSUMER SURVEY"]
[null,"add a row","ok","how many rows can they add per category of costs?"]
[null,"add a row in section II.2","NOK","the adding and deleting of rows is not correctly implemented"]
[null,"delete a row","ok"]
[null,"delete a row out of the costs categories not possible","ok","message appears: deleting this row is not possible. … however you can delete the information or the amount if you would like so - very good"]
[null,"add a row where not necessary: messages:\nAdding a row is not possible. You cannot add a row in this section. Use the existing rows instead\nOr: You can only add a row in one of the survey sheets in the sections with white background sections.","ok","Why are they two different messages? I like the second one but I think that 'of' is missing."]
[null,"gridlines when adding a row are missing",null,"Can this be added?"]
["7% rule checkbox","works with both possibilities","ok"]
["Formulas","seem to work properly","ok","to be tested more deeply"]
["BCS Administration","The administrative model is editable","ok"]
[]
[null,"need to have the cells blocked to test the switch to final"]
[]
["Modifications to do","Guidance FFS: para cc deliverables to correct",null,"see version to R2"]
[null,"Calculation Methodology BS and FFS: question on deliverables to review"]
[null,"Overview sheet: to add I.5 Staff paid based on deliverables + transfer amounts from statements"]
[]
["Requests R2","corrections of BEATA"]
[null,"add columns in survey sheet to have automatic calculations of staff costs + EU BCS ratio in admin costs"]

{"sheet":"Calculation Methodology BS","index":14,"n_rows":34,"n_cols":3,"rows_kept":34,"cut":false,"hidden":false,"merged":[[0,0,0,2],[26,0,26,2],[28,0,28,2],[7,0,7,2],[11,0,11,2],[15,0,15,2],[23,0,23,2],[32,0,32,2],[6,1,6,2],[10,1,10,2],[14,1,14,2],[16,1,16,2],[13,0,13,2],[18,1,18,2],[19,0,19,2],[33,1,33,2],[20,1,20,2],[22,1,22,2],[34,0,34,2],[1,1,1,2],[3,1,3,2],[17,0,17,2],[21,0,21,2],[29,0,29,2],[25,1,25,2],[27,1,27,2],[30,1,30,2],[31,0,31,2],[8,1,8,2],[9,0,9,2],[12,1,12,2]]}
["INFORMATION ON THE METHODOLOGY APPLIED TO\nESTIMATE THE COSTS FOR THE SURVEY PROGRAMME "]
["CT",{"$f":"'Guidance BS'!B12","v":"Acronym institution"}]
["SURVEY METHODOLOGY:"]
["1.","Please indicate the survey methodology that you intend to apply to implement the action. Please precise which methodology will be applied for which survey."]
[null,"F2F/CAPI\nTel./CATI\nonline/CAWI\nPaper/Post \nPaper/FAX \nother (specify)","Please precise which methodology will be applied for which survey."]
["STAFF COSTS:"]
["2.","Average salary rates: \nPlease explain the methodology you used to calculate the average salary rates."]
[]
["3.","Average rate per deliverable: \nPlease explain the methodology you used to calculate the average rate per deliverable."]
[]
["4.","Salary costs:\nPlease explain what kind of costs are included in the salary rate (e.g. net/gross salary, social security, pension fees, holidays, other statutory costs)"]
[]
["5.","Costs of deliverables:\nPlease explain what kind of costs are included in the avarage rate of deliverables."]
[]
["6.","Number of working days allocated to the survey-related costs: \nHow do you estimate the number of working days allocated to the survey programme (do you use a time-recording system, timesheets, a sharing key, historical data…)? "]
[]
["7.","Time-recording system:\nPlease also let us know if the timesheets record separately the time spent on the specific survey programme and the other activities of your institution."]
[]
["8.","Number of deliverables:\nPlease explain how you estimate the number of deliverables."]
[]
["9.","EU-related ratio on staff costs:\nThis ratio needs to be applied to your estimates if your survey programme contains additional questions which are not part of the harmonised EU BCS questionnaire. Please explain for each harmonised survey (industry, services, building, etc.) which ratio you applied and how you calculated it (e.g. based on the number of harmonised EU BCS questions in relation to the total number of questions in your questionnaire, use of historical data,...). In case there are no other questions in the questionnaire than the harmonised EU BCS questions, please clearly state it here."]
[]
["10.","Please confirm that the staff costs are in line with the usual policy on remuneration of your institution."]
[]
["ADMINISTRATIVE COSTS:"]
["11.","Survey-related costs: \nPlease explain how you estimate the administrative costs related to the survey programme (e.g. real incurred costs from reference year, costs for the survey programme in relation to the total costs for all activities managed by your department related to a reference year). Please also indicate the reference year."]
[]
["12.","EU-related ratio on administrative costs:\nThis ratio needs to be applied to your estimates if your survey programme contains additional questions which are not part of the harmonised EU BCS questionnaire. Please explain for each harmonised survey (industry, services, building, etc.) which ratio you applied and how you calculated it (e.g. based on the number of harmonised EU BCS questions in relation to the total number of questions in your questionnaire, use of historical data,...). In case there are no other questions in the questionnaire than the harmonised EU BCS questions, please clearly state it here."]
[]
["DISTRIBUTION OF ALL COSTS AMONG THE SURVEYS"]
["13.","If applicable, please explain how you distribute the costs among the different harmonised surveys for which you receive a grant. "]
[]
["GENERAL QUESTION ON ACCOUNTING PRACTICES"]
["14.","Please give a short description of the accounting practices of your organisation"]

{"sheet":"Calculation Methodology FFS","index":15,"n_rows":26,"n_cols":3,"rows_kept":26,"cut":false,"hidden":true,"merged":[[24,0,24,2],[26,0,26,2],[9,0,9,2],[13,0,13,2],[15,0,15,2],[21,0,21,2],[23,0,23,2],[22,1,22,2],[25,1,25,2],[16,0,16,2],[0,0,0,2],[18,0,18,2],[20,0,20,2],[7,0,7,2],[3,1,3,2],[1,1,1,2],[6,1,6,2],[8,1,8,2],[12,1,12,2],[14,1,14,2],[17,1,17,2],[19,1,19,2],[10,1,10,2],[11,0,11,2]]}
["INFORMATION ON THE METHODOLOGY APPLIED TO CALCULATE \nTHE INCURRED COSTS RELATED TO THE SURVEY PROGRAMME "]
["CT",{"$f":"'Guidance BS'!B12","v":"Acronym institution"}]
["SURVEY METHODOLOGY:"]
["1.","Please indicate the survey methodologies that were applied during the implementation period. Please precise which methodology was applied for which survey."]
[null,"F2F/CAPI\nTel./CATI\nonline/CAWI\nPaper/Post \nPaper/FAX \nother (specify)","Please precise which methodology will be applied for which survey."]
["STAFF COSTS:"]
["2.","Number of working days allocated to the survey-related costs: \nHow do you calculate the number of days allocated to the survey programme (do you use a time-recording system, timesheets, a sharing key per survey,…)? "]
[]
["3.","Time-recording system:\nPlease also let us know if the timesheets record separately the time spent on the specific survey programme and the other activities of your institution."]
[]
[4,"Deliverables:\nPlease explain how the number of units of deliverables is calculated."]
[]
["5.","EU-related ratio on staff costs:\nThis ratio needs to be applied to your staff costs if your survey programme contains additional questions which are not part of the harmonised EU BCS questionnaire. \nPlease explain for each harmonised survey (Consumer, Constructions, Industry, Retail Trade and Services) which ratio you applied and how you calculated it (e.g. based on the number of harmonised EU BCS questions in relation to the total number of questions in your questionnaire, use of historical data,...). \nIn case there are no other questions in the questionnaire than the harmonised EU BCS questions, please clearly state it here."]
[]
["6.","Please confirm that all working days claimed were spent during the action period."]
[]
["COSTS for SUBCONTRACTING / COSTS FOR UPDATE OF SOFTWARE / PROCESS OF REDESIGN, ADMINISTRATIVE COSTS\nOnly to be filled in by institutes who subcontracted part of the tasks and/or who budgeted costs for update software/process redesign and/or whose total estimated administrative costs were higher than 50% of the total estimated staff costs."]
[7,"Survey-related costs: \nPlease explain how you calculated the real incurred administrative costs related to the survey programme (e.g. costs for the survey programme in relation to the total costs for all activities managed by your department)."]
[]
[8,"EU-related ratio: \nThis ratio needs to be applied to your administrative costs if your survey programme contains additional questions which are not part of the harmonised EU BCS questionnaire. Please explain for each harmonised survey (industry, services, building, etc.) which ratio you applied and how you calculated it (e.g. based on the number of harmonised EU BCS questions in relation to the total number of questions in your questionnaire, use of historical data,...). In case there are no other questions in the questionnaire than the harmonised EU BCS questions, please clearly state it here."]
[]
["DISTRIBUTION OF THE INCURRED COSTS AMONG THE SURVEYS"]
[9,"If applicable, please explain how you distribute the costs among the different harmonised surveys for which you receive a grant. "]
[]
["VAT RULE"]
[10,"Please confirm that the VAT rule has been applied correctly."]

{"sheet":"Calculation Overview","index":16,"n_rows":44,"n_cols":21,"rows_kept":44,"cut":false,"hidden":true,"merged":[[36,2,36,14],[33,1,33,20],[1,15,1,20],[0,2,0,20],[1,2,1,7],[1,8,1,13]]}
[null,"ECFIN/000/2020/000000","Overview Budget & Final Financial Statement - Calculation of eligible costs"]
[null,null,"BUDGET",null,null,null,null,null,"FINAL",null,null,null,null,null,null,"FINAL ELIGIBLE"]
[null,null,"Consumer","Construction","Industry","Retail trade","Services","Total","Consumer","Construction","Industry","Retail trade","Services","Total","CTRL ADM COSTS","Consumer","Construction","Industry","Retail trade","Services","Total"]
[null,"Staff Costs ",{"$f":"C5+C11+C12+C13+C14","v":0},{"$f":"D5+D11+D12+D13+D14","v":0},0,0,0,{"$f":"H5+H11+H12+H13+H14","v":0},{"$f":"I5+I11+I12+I13+I14","v":0},{"$f":"J5+J11+J12+J13+J14","v":0},0,0,0,{"$f":"N5+N11+N12+N13+N14","v":0},null,{"$f":"P5+P11+P12+P13+P14","v":0},{"$f":"Q5+Q11+Q12+Q13+Q14","v":0},0,0,0,0]
["I.I","Permanent staff",{"$f":"SUM(C6:C10)","v":0},{"$f":"SUM(D6:D10)","v":0},0,0,0,0,0,{"$f":"SUM(J6:J10)","v":0},0,0,0,{"$f":"SUM(N6:N10)","v":0},null,{"$f":"SUM(P6:P10)","v":0},{"$f":"SUM(Q6:Q10)","v":0},0,0,0,0]
[null,"Managers",{"$f":"Consumer!I25","v":0},{"$f":"Construction!I25","v":0},{"$f":"Industry!I25","v":0},{"$f":"'Retail Trade'!I25","v":0},{"$f":"Services!I25","v":0},{"$f":"SUM(C6:G6)","v":0},{"$f":"Consumer!M25","v":0},{"$f":"Construction!M25","v":0},{"$f":"Industry!M25","v":0},{"$f":"'Retail Trade'!M25","v":0},{"$f":"Services!M25","v":0},{"$f":"SUM(I6:M6)","v":0},null,{"$f":"+I6","v":0},{"$f":"+J6","v":0},{"$f":"+K6","v":0},{"$f":"+L6","v":0},{"$f":"+M6","v":0},{"$f":"SUM(P6:T6)","v":0}]
[null,"Researchers",{"$f":"Consumer!I27","v":0},{"$f":"Construction!I27","v":0},{"$f":"Industry!I27","v":0},{"$f":"'Retail Trade'!I27","v":0},{"$f":"Services!I27","v":0},{"$f":"SUM(C7:G7)","v":0},{"$f":"Consumer!M27","v":0},{"$f":"Construction!M27","v":0},{"$f":"Industry!M27","v":0},{"$f":"'Retail Trade'!M27","v":0},{"$f":"Services!M27","v":0},{"$f":"SUM(I7:M7)","v":0},null,{"$f":"+I7","v":0},{"$f":"+J7","v":0},0,0,0,{"$f":"SUM(P7:T7)","v":0}]
[null,"Interviewers",{"$f":"Consumer!I29","v":0},{"$f":"Construction!I29","v":0},{"$f":"Industry!I29","v":0},{"$f":"'Retail Trade'!I29","v":0},{"$f":"Services!I29","v":0},0,{"$f":"Consumer!M29","v":0},{"$f":"Construction!M29","v":0},{"$f":"Industry!M29","v":0},{"$f":"'Retail Trade'!M29","v":0},{"$f":"Services!M29","v":0},0,null,0,0,0,0,0,0]
[null,"Technical staff",{"$f":"Consumer!I31","v":0},{"$f":"Construction!I31","v":0},{"$f":"Industry!I31","v":0},{"$f":"'Retail Trade'!I31","v":0},{"$f":"Services!I31","v":0},0,{"$f":"Consumer!M31","v":0},{"$f":"Construction!M31","v":0},{"$f":"Industry!M31","v":0},{"$f":"'Retail Trade'!M31","v":0},{"$f":"Services!M31","v":0},0,null,0,0,0,0,0,0]
[null,"Administrative staff",{"$f":"Consumer!I33","v":0},{"$f":"Construction!I33","v":0},{"$f":"Industry!I33","v":0},{"$f":"'Retail Trade'!I33","v":0},{"$f":"Services!I33","v":0},0,{"$f":"Consumer!M33","v":0},{"$f":"Construction!M33","v":0},{"$f":"Industry!M33","v":0},{"$f":"'Retail Trade'!M33","v":0},{"$f":"Services!M33","v":0},0,null,0,0,0,0,0,0]
["I.2","Temporary staff",{"$f":"Consumer!I35","v":0},{"$f":"Construction!I35","v":0},{"$f":"Industry!I35","v":0},{"$f":"'Retail Trade'!I35","v":0},{"$f":"Services!I35","v":0},0,{"$f":"Consumer!M35","v":0},{"$f":"Construction!M35","v":0},{"$f":"Industry!M35","v":0},{"$f":"'Retail Trade'!M35","v":0},{"$f":"Services!M35","v":0},0,null,0,0,0,0,0,0]
["I.3","Staff under civil contracts",{"$f":"Consumer!I37","v":0},{"$f":"Construction!I37","v":0},{"$f":"Industry!I37","v":0},{"$f":"'Retail Trade'!I37","v":0},{"$f":"Services!I37","v":0},0,{"$f":"Consumer!M37","v":0},{"$f":"Construction!M37","v":0},{"$f":"Industry!M37","v":0},{"$f":"'Retail Trade'!M37","v":0},{"$f":"Services!M37","v":0},0,null,0,0,0,0,0,0]
["I.4","Seconded staff",{"$f":"Consumer!I39","v":0},{"$f":"Construction!I39","v":0},{"$f":"Industry!I39","v":0},{"$f":"'Retail Trade'!I39","v":0},{"$f":"Services!I39","v":0},0,{"$f":"Consumer!M39","v":0},{"$f":"Construction!M39","v":0},{"$f":"Industry!M39","v":0},{"$f":"'Retail Trade'!M39","v":0},{"$f":"Services!M39","v":0},0,null,0,0,0,0,0,0]
["I.5","Staff paid based on deliverables",{"$f":"Consumer!I43","v":0},{"$f":"Construction!I43","v":0},{"$f":"Industry!I43","v":0},{"$f":"'Retail Trade'!I43","v":0},{"$f":"Services!I43","v":0},0,{"$f":"Consumer!M43","v":0},{"$f":"Construction!M43","v":0},{"$f":"Industry!M43","v":0},{"$f":"'Retail Trade'!M43","v":0},{"$f":"Services!M43","v":0},0,null,0,0,0,0,0,0]
[null,"TOTAL ADMINISTRATIVE COSTS",{"$f":"C16+C17+C18","v":0},{"$f":"D16+D17+D18","v":0},0,0,0,{"$f":"SUM(C15:G15)","v":0},{"$f":"I16+I17+I18","v":0},{"$f":"J16+J17+J18","v":0},0,0,0,{"$f":"SUM(N16:N18)","v":0},null,{"$f":"SUM(P16:P18)","v":0},{"$f":"SUM(Q16:Q18)","v":0},0,0,0,{"$f":"SUM(P15:T15)","v":0}]
[null,"Subcontracting ",{"$f":"Consumer!I49","v":0},{"$f":"Construction!I49","v":0},{"$f":"Industry!I49","v":0},{"$f":"'Retail Trade'!I49","v":0},{"$f":"Services!I49","v":0},0,{"$f":"Consumer!M49","v":0},{"$f":"Construction!M49","v":0},{"$f":"Industry!M49","v":0},{"$f":"'Retail Trade'!M49","v":0},{"$f":"Services!M49","v":0},0,null,0,{"$f":"+J16","v":0},{"$f":"+K16","v":0},{"$f":"+L16","v":0},{"$f":"+M16","v":0},0]
[null,"Up-date Software / Process re-design",{"$f":"Consumer!I51","v":0},{"$f":"Construction!I51","v":0},{"$f":"Industry!I51","v":0},{"$f":"'Retail Trade'!I51","v":0},{"$f":"Services!I51","v":0},0,{"$f":"Consumer!M51","v":0},{"$f":"Construction!M51","v":0},{"$f":"Industry!M51","v":0},{"$f":"'Retail Trade'!M51","v":0},{"$f":"Services!M51","v":0},0,null,0,0,0,0,0,{"$f":"SUM(P17:T17)","v":0}]
[null,"Administrative costs (under flat-rate financing or/and real incurred)",{"$f":"C19","v":0},{"$f":"D19","v":0},0,0,0,0,{"$f":"IF(C29>0.5,I19,I29)","v":0},{"$f":"IF(D29>0.5,J19,J29)","v":0},{"$f":"IF(E29>0.5,K19,K29)","v":0},0,0,{"$f":"SUM(I18:M18)","v":0},null,{"$f":"IF(C29>0.5,P19,P29)","v":0},{"$f":"IF(D29>0.5,Q19,Q29)","v":0},{"$f":"IF(E29>0.5,R19,R29)","v":0},{"$f":"IF(F29>0.5,S19,S29)","v":0},0,{"$f":"SUM(P18:T18)","v":0}]
[null,"Administrative costs (under flat-rate financing or real incurred) / Real incurred administrative costs",{"$f":"SUM(C20:C28)","v":0},{"$f":"SUM(D20:D28)","v":0},0,0,0,0,{"$f":"SUM(I20:I28)","v":0},0,0,0,0,0,0,{"$f":"SUM(P20:P28)","v":0},0,0,0,0,0]
[null,"Costs for travel and subsistence allowances",{"$f":"Consumer!I54","v":0},{"$f":"Construction!I54","v":0},{"$f":"Industry!I54","v":0},{"$f":"'Retail Trade'!I54","v":0},{"$f":"Services!I54","v":0},0,{"$f":"Consumer!M54","v":0},{"$f":"Construction!M54","v":0},{"$f":"Industry!M54","v":0},{"$f":"'Retail Trade'!M54","v":0},{"$f":"Services!M54","v":0},0,{"$f":"Consumer!J54+Construction!J54+Industry!J54+'Retail Trade'!J54+Services!J54","v":0},0,{"$f":"+J20","v":0},{"$f":"+K20","v":0},{"$f":"+L20","v":0},{"$f":"+M20","v":0},0]
[null,"Costs for printing",{"$f":"Consumer!I55","v":0},{"$f":"Construction!I55","v":0},{"$f":"Industry!I55","v":0},{"$f":"'Retail Trade'!I55","v":0},{"$f":"Services!I55","v":0},0,{"$f":"Consumer!M55","v":0},{"$f":"Construction!M55","v":0},{"$f":"Industry!M55","v":0},{"$f":"'Retail Trade'!M55","v":0},{"$f":"Services!M55","v":0},0,{"$f":"Consumer!J55+Construction!J55+Industry!J55+'Retail Trade'!J55+Services!J55","v":0},0,0,0,0,0,0]
[null,"Costs for mailing ",{"$f":"Consumer!I56","v":0},{"$f":"Construction!I56","v":0},{"$f":"Industry!I56","v":0},{"$f":"'Retail Trade'!I56","v":0},{"$f":"Services!I56","v":0},0,{"$f":"Consumer!M56","v":0},{"$f":"Construction!M56","v":0},{"$f":"Industry!M56","v":0},{"$f":"'Retail Trade'!M56","v":0},{"$f":"Services!M56","v":0},0,{"$f":"Consumer!J56+Construction!J56+Industry!J56+'Retail Trade'!J56+Services!J56","v":0},0,0,0,0,0,0]
[null,"Costs for communication",{"$f":"Consumer!I57","v":0},{"$f":"Construction!I57","v":0},{"$f":"Industry!I57","v":0},{"$f":"'Retail Trade'!I57","v":0},{"$f":"Services!I57","v":0},0,{"$f":"Consumer!M57","v":0},{"$f":"Construction!M57","v":0},{"$f":"Industry!M57","v":0},{"$f":"'Retail Trade'!M57","v":0},{"$f":"Services!M57","v":0},0,{"$f":"Consumer!J57+Construction!J57+Industry!J57+'Retail Trade'!J57+Services!J57","v":0},0,0,0,0,0,0]
[null,"Costs for translation",{"$f":"Consumer!I58","v":0},{"$f":"Construction!I58","v":0},{"$f":"Industry!I58","v":0},{"$f":"'Retail Trade'!I58","v":0},{"$f":"Services!I58","v":0},0,{"$f":"Consumer!M58","v":0},{"$f":"Construction!M58","v":0},{"$f":"Industry!M58","v":0},{"$f":"'Retail Trade'!M58","v":0},{"$f":"Services!M58","v":0},0,{"$f":"Consumer!J58+Construction!J58+Industry!J58+'Retail Trade'!J58+Services!J58","v":0},0,0,0,0,0,0]
[null,"Costs of materials",{"$f":"Consumer!I59","v":0},{"$f":"Construction!I59","v":0},{"$f":"Industry!I59","v":0},{"$f":"'Retail Trade'!I59","v":0},{"$f":"Services!I59","v":0},0,{"$f":"Consumer!M59","v":0},{"$f":"Construction!M59","v":0},{"$f":"Industry!M59","v":0},{"$f":"'Retail Trade'!M59","v":0},{"$f":"Services!M59","v":0},0,{"$f":"Consumer!J59+Construction!J59+Industry!J59+'Retail Trade'!J59+Services!J59","v":0},0,0,0,0,0,0]
[null,"Costs for fees for IT Software and data",{"$f":"Consumer!I60","v":0},{"$f":"Construction!I60","v":0},{"$f":"Industry!I60","v":0},{"$f":"'Retail Trade'!I60","v":0},{"$f":"Services!I60","v":0},0,{"$f":"Consumer!M60","v":0},{"$f":"Construction!M60","v":0},{"$f":"Industry!M60","v":0},{"$f":"'Retail Trade'!M60","v":0},{"$f":"Services!M60","v":0},0,{"$f":"Consumer!J60+Construction!J60+Industry!J60+'Retail Trade'!J60+Services!J60","v":0},0,0,0,0,0,0]
[null,"Certain other costs ",{"$f":"Consumer!I61","v":0},{"$f":"Construction!I61","v":0},{"$f":"Industry!I61","v":0},{"$f":"'Retail Trade'!I61","v":0},{"$f":"Services!I61","v":0},0,{"$f":"Consumer!M61","v":0},{"$f":"Construction!M61","v":0},{"$f":"Industry!M61","v":0},{"$f":"'Retail Trade'!M61","v":0},{"$f":"Services!M61","v":0},0,{"$f":"Consumer!J61+Construction!J61+Industry!J61+'Retail Trade'!J61+Services!J61","v":0},0,0,0,0,0,0]
[null,"If lines were added in this section of the individual surveys, please add them here",{"$f":"Consumer!I62","v":0},{"$f":"Construction!I62","v":0},{"$f":"Industry!I62","v":0},{"$f":"'Retail Trade'!I62","v":0},{"$f":"Services!I62","v":0},{"$f":"SUM(C28:G28)","v":0},{"$f":"Consumer!M62","v":0},{"$f":"Construction!M62","v":0},{"$f":"Industry!M62","v":0},{"$f":"'Retail Trade'!M62","v":0},{"$f":"Services!M62","v":0},{"$f":"SUM(I28:M28)","v":0},{"$f":"Consumer!J62+Construction!J62+Industry!J62+'Retail Trade'!J62+Services!J62","v":0},{"$f":"+I28","v":0},{"$f":"+J28","v":0},{"$f":"+K28","v":0},{"$f":"+L28","v":0},{"$f":"+M28","v":0},{"$f":"SUM(P28:T28)","v":0}]
[null,"Flat rate financing for administrative costs / Administrative costs under flat rate financing",{"$f":"Consumer!I63","v":0},{"$f":"Construction!I63","v":0},{"$f":"Industry!I63","v":0},{"$f":"'Retail Trade'!I63","v":0},{"$f":"Services!I63","v":0},null,{"$f":"Consumer!M63","v":0},{"$f":"Construction!M63","v":0},{"$f":"Industry!M63","v":0},{"$f":"'Retail Trade'!M63","v":0},{"$f":"Services!M63","v":0},{"$f":"SUM(I29:M29)","v":0},null,{"$f":"I29","v":0},{"$f":"J29","v":0},{"$f":"K29","v":0},{"$f":"L29","v":0},{"$f":"M29","v":0},{"$f":"SUM(P29:T29)","v":0}]
[null,"Total Direct Costs",{"$f":"C15+C4","v":0},0,0,0,0,0,0,0,0,{"$f":"L15+L4","v":0},0,{"$f":"SUM(I30:M30)","v":0},null,{"$f":"P15+P4","v":0},0,0,0,0,0]
[null,"Indirect Costs (7% of total eligible direct costs excluding costs for subcontracting)",{"$f":"+Indirect_Costs","v":0},{"$f":"Construction!I64","v":0},{"$f":"Industry!Indirect_Costs","v":0},{"$f":"'Retail Trade'!Indirect_Costs","v":0},{"$f":"Services!Indirect_Costs","v":0},{"$f":"Total!Indirect_Costs","v":0},{"$f":"Indirect_Costs_Final","v":0},{"$f":"Construction!Indirect_Costs_Final","v":0},{"$f":"Industry!Indirect_Costs_Final","v":0},{"$f":"'Retail Trade'!Indirect_Costs_Final","v":0},{"$f":"Services!Indirect_Costs_Final","v":0},{"$f":"Total!G37","v":0},null,{"$f":"ROUNDDOWN((P30-P16)*I33,2)","v":0},{"$f":"ROUNDDOWN((Q30-Q16)*J33,2)","v":0},{"$f":"ROUNDDOWN((R30-R16)*K33,2)","v":0},{"$f":"ROUNDDOWN((S30-S16)*L33,2)","v":0},{"$f":"ROUNDDOWN((T30-T16)*M33,2)","v":0},{"$f":"SUM(P31:T31)","v":0}]
[null,"TOTAL COSTS",{"$f":"C30+C31","v":0},0,{"$f":"E30+E31","v":0},0,0,{"$f":"H30+H31","v":0},{"$f":"I30+I31","v":0},0,0,0,0,0,null,0,{"$f":"Q30+Q31","v":0},{"$f":"R30+R31","v":0},0,0,0]
[null,"% indirect costs",{"$f":"Consumer!I66","v":7.0000000000000007E-2},{"$f":"Construction!I66","v":7.0000000000000007E-2},{"$f":"Industry!I66","v":7.0000000000000007E-2},{"$f":"'Retail Trade'!I66","v":7.0000000000000007E-2},{"$f":"Services!I66","v":7.0000000000000007E-2},null,{"$f":"Consumer!M66","v":7.0000000000000007E-2},{"$f":"Construction!M66","v":7.0000000000000007E-2},{"$f":"Industry!M66","v":7.0000000000000007E-2},{"$f":"'Retail Trade'!M66","v":7.0000000000000007E-2},{"$f":"Services!M66","v":7.0000000000000007E-2},null,null,{"$f":"I33","v":7.0000000000000007E-2},{"$f":"J33","v":7.0000000000000007E-2},7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2]
[null,"CALCULATION BALANCE"]
[null,"Total calculated (eligible) Grant",{"$f":"Consumer!I14","v":0},{"$f":"Construction!I14","v":0},{"$f":"Industry!I14","v":0},{"$f":"'Retail Trade'!I14","v":0},{"$f":"Services!I14","v":0},{"$f":"Total!F14","v":0},{"$f":"+Consumer!M14","v":0},{"$f":"Construction!M14","v":0},{"$f":"Industry!M14","v":0},{"$f":"'Retail Trade'!M14","v":0},{"$f":"Services!M14","v":0},{"$f":"SUM(I35:M35)","v":0},null,{"$f":"IF(P32>C32,C41,P32*P36)","v":0},{"$f":"IF(Q32>D32,D41,Q32*Q36)","v":0},{"$f":"IF(R32>E32,E41,R32*R36)","v":0},0,0,{"$f":"SUM(P35:T35)","v":0}]
[null,"Grant percentage",{"$f":"+Consumer!I17","v":0},{"$f":"Construction!I17","v":0},{"$f":"Industry!I17","v":0},{"$f":"'Retail Trade'!I17","v":0},{"$f":"Services!I17","v":0},null,{"$f":"+Consumer!M17","v":0},{"$f":"Construction!M17","v":0},{"$f":"Industry!M17","v":0},{"$f":"'Retail Trade'!M17","v":0},{"$f":"Services!M17","v":0},null,null,{"$f":"I36","v":0},0,0,0,0]
[null,"Cut of grant for non delivery - in %","Clarification on the calculation methodology applied",null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,"Cut of the maximum grant for non delivery",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P35*P37","v":0},{"$f":"Q35*Q37","v":0},{"$f":"R35*R37","v":0},0,0,{"$f":"SUM(P38:T38)","v":0}]
[null,"Maximum eligible grant after cut for non delivery",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P35-P38","v":0},{"$f":"Q35-Q38","v":0},{"$f":"R35-R38","v":0},0,0,{"$f":"SUM(P39:T39)","v":0}]
[null,"Pre-financing payment",{"$f":"Consumer!I15","v":0},{"$f":"Construction!I15","v":0},{"$f":"Industry!I15","v":0},{"$f":"'Retail Trade'!I15","v":0},{"$f":"Services!I15","v":0},null,{"$f":"C40","v":0},{"$f":"D40","v":0},0,0,0,null,null,0,0,0,0,0,{"$f":"SUM(P40:T40)","v":0}]
[null,"Accepted payment calculated by A3",{"$f":"C35-C40","v":0},{"$f":"D35-D40","v":0},0,0,0,null,{"$f":"I35-I40","v":0},{"$f":"J35-J40","v":0},0,0,0,null,null,{"$f":"P39-P40","v":0},{"$f":"Q39-Q40","v":0},0,0,0,0]
[]
[null,"Payment requested by beneficiary",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Consumer!M16","v":0},{"$f":"Construction!M16","v":0},{"$f":"Industry!M16","v":0},{"$f":"'Retail Trade'!M16","v":0},{"$f":"Services!M16","v":0},0]
[null,"Difference",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P41-P43","v":0},{"$f":"Q41-Q43","v":0},0,0,0,0]

{"sheet":"Calculation Balance","index":17,"n_rows":31,"n_cols":4,"rows_kept":31,"cut":false,"hidden":true,"merged":[[3,4,3,6],[4,0,4,3],[5,0,5,3],[0,0,0,3],[1,0,1,3],[2,0,2,3],[3,0,3,3]]}
[{"$f":"[0]!HeadingLine1","v":"BUDGET AND FINAL FINANCIAL STATEMENT FOR GRANT AGREEMENT PERIOD MAY 2023 - APRIL 2024"}]
["CALCULATION SHEET"]
[{"$f":"[0]!HeadingLine4","v":"FINANCING PLAN AND COSTS OF THE SURVEYS"}]
[{"$f":"[0]!HeadingLine5","v":"(see Framework partnership agreement: Article II.19 on Eligible costs)"}]
[{"$f":"Total!C6","v":"ECFIN/XXX/2023/000000"}]
[""]
[null,"BUDGET ESTIMATION","FINAL FINANCIAL STATEMENT","APPROVED ELIGIBLE  COSTS             "]
["Staff Costs",{"$f":"B9+B10+B11+B12+B13","v":0},{"$f":"C9+C10+C11+C12+C13","v":0},{"$f":"D9+D10+D11+D12+D13","v":0}]
["Permanent staff",{"$f":"'Calculation Overview'!H5","v":0},{"$f":"'Calculation Overview'!N5","v":0},{"$f":"'Calculation Overview'!U5","v":0}]
["Temporary staff",{"$f":"'Calculation Overview'!H11","v":0},{"$f":"'Calculation Overview'!N11","v":0},{"$f":"'Calculation Overview'!U11","v":0}]
["Staff under civil contracts",{"$f":"'Calculation Overview'!H12","v":0},{"$f":"'Calculation Overview'!N12","v":0},{"$f":"'Calculation Overview'!U12","v":0}]
["Seconded staff",{"$f":"'Calculation Overview'!H13","v":0},{"$f":"'Calculation Overview'!N13","v":0},{"$f":"'Calculation Overview'!U13","v":0}]
["Staff paid based on deliverables",{"$f":"'Calculation Overview'!H14","v":0},{"$f":"'Calculation Overview'!N14","v":0},{"$f":"'Calculation Overview'!U14","v":0}]
["Administrative Costs",{"$f":"SUM(B15:B17)","v":0},{"$f":"SUM(C15:C18)","v":0},{"$f":"SUM(D15:D18)","v":0}]
["Subcontracting ",{"$f":"'Calculation Overview'!H16","v":0},{"$f":"'Calculation Overview'!N16","v":0},{"$f":"'Calculation Overview'!U16","v":0}]
["Update Software / process re-design",{"$f":"'Calculation Overview'!H17","v":0},{"$f":"'Calculation Overview'!N17","v":0},{"$f":"'Calculation Overview'!U17","v":0}]
["Administrative costs (under flat-rate financing or not)",{"$f":"'Calculation Overview'!H19","v":0},{"$f":"'Calculation Overview'!N19","v":0},{"$f":"'Calculation Overview'!U19","v":0}]
["Administrative costs under flat rate financing",null,{"$f":"'Calculation Overview'!N29","v":0},{"$f":"'Calculation Overview'!U29","v":0}]
["Total Direct Costs",{"$f":"B14+B8","v":0},{"$f":"C14+C8","v":0},{"$f":"D14+D8","v":0}]
["Indirect Costs (max 7% direct costs)",{"$f":"'Calculation Overview'!H31","v":0},{"$f":"'Calculation Overview'!N31","v":0},{"$f":"'Calculation Overview'!U31","v":0}]
["TOTAL COSTS",{"$f":"B19+B20","v":0},{"$f":"C19+C20","v":0},{"$f":"D19+D20","v":0}]
[]
["EC contribution : ","maximum grant",null,{"$f":"Total!F14","v":0}]
["Pre-Financing",null,null,{"$f":"Total!G15","v":0}]
["Maximum amount to be paid",null,null,{"$f":"D23-D24","v":0}]
[]
["Payment requested by beneficiary",{"$f":"Total!G16","v":0}]
["Accepted payment calculated by A3",{"$f":"'Calculation Overview'!U41","v":0}]
["Difference",{"$f":"B27-D28","v":0}]
[]
["Amount to be paid:",null,null,{"$f":"B28","v":0}]