{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["READ THIS FIRST","budget application partner","Budget application totals"],"not_rendered":{"defined_names":8},"read":"whole","date_system":"1900"}

{"sheet":"READ THIS FIRST","index":0,"n_rows":1,"n_cols":1,"rows_kept":1,"merged":[[0,0,28,14]]}
["This page contains general guidelines for completing this template. Please read them carefully before you start.\n\nThis Excel file is to be used for the BUDGET APPLICATION and consists of 2 tabs:\n1) \"Budget Application Partner\" tab, to be copied for and completed by each partner individually\n(2) \"Budget Application Totals\" tab, in which the figures from the individual tabs are aggregated if there are multiple partners\n\nOnly fill in the white and yellow fields. The gray fields are either informative or calculated fields that are not editable.\n\nFor security reasons, you cannot insert rows yourself. If you do need more rows than anticipated, please contact verificatie@vlaio.be for a modified Excel file. \n\nThe tabs have been designed with the maximum duration of the various project types in mind. You can reduce or increase the number of year columns by using Excel’s hide function. This template has been set up for 3-year projects.\n\nEach partner or research institution should complete a separate version of the “Budget Application Partner\" tab. You can easily copy this tab by right clicking on the tab name. You can change the tab name by double-clicking it, which will be necessary for projects involving several partners. \n\nAll cost statements should be collected by the lead applicant for the project. The lead applicant should also complete the \"Budget Application Totals\" tab. All tabs are collected in the same Excel file. To avoid errors, it is recommended to copy the original tab of this template each time and to avoid making copies of copies. Please submit this Excel file (not a PDF file) to the Agency for Innovation and Entrepreneurship via the digital platform.\n\nFor a detailed summary of costs deemed eligible for funding by the Agency for Innovation and Entrepreneurship and which explanation/justification is required, please see the guide to the VLAIO cost model. You can find this document on our website (www.vlaio.be) by going to the required documents for your chosen project type.\n\nIf you have any questions about this Excel cost template, please contact verificatie@vlaio.be. \n \n\n\n\n"]

{"sheet":"budget application partner","index":1,"n_rows":190,"n_cols":20,"rows_kept":190,"merged":[[0,0,0,18],[2,0,2,18],[3,0,3,1],[3,2,3,18],[4,2,4,18],[5,0,5,1],[5,2,5,18],[6,0,6,1],[6,2,6,18],[8,0,8,18],[10,0,10,4],[12,0,12,4],[13,0,13,4],[13,5,13,10],[13,11,13,17],[14,0,14,3],[15,0,15,3],[16,0,16,3],[17,0,17,3],[18,0,18,3],[19,0,19,3],[20,0,20,3],[21,0,21,3],[22,0,22,3],[23,0,23,3],[24,0,24,3],[25,0,25,3],[26,0,26,3],[27,0,27,3],[28,0,28,3],[29,0,29,3],[30,0,30,3],[31,0,31,3],[32,0,32,3],[33,0,33,3],[34,0,34,3],[35,0,35,3],[36,0,36,3],[37,0,37,3],[38,0,38,3],[39,0,39,3],[40,0,40,3],[41,0,41,3],[42,0,42,3],[43,0,43,3],[44,0,44,3],[45,0,45,3],[46,0,46,3],[47,0,47,3],[48,0,48,3],[49,0,49,3],[50,0,50,3],[51,0,51,3],[52,0,52,3],[53,0,53,3],[54,0,54,3],[55,0,55,3],[56,0,56,3],[57,0,57,3],[58,0,58,3],[59,0,59,3],[60,0,60,3],[61,0,61,3],[62,0,62,3],[63,0,63,3],[64,0,64,3],[65,0,65,3],[66,0,66,3],[67,0,67,3],[68,0,68,3],[69,0,69,3],[70,0,70,3],[71,0,71,3],[72,0,72,3],[73,0,73,3],[74,0,74,3],[75,0,75,3],[76,0,76,3],[77,0,77,3],[78,0,78,3],[79,0,79,3],[80,0,80,3],[81,0,81,3],[82,0,82,3],[83,0,83,3],[84,0,84,3],[85,0,85,3],[86,0,86,3],[87,0,87,4],[88,0,88,18],[90,0,90,18],[91,0,97,18],[99,0,99,5],[102,0,102,5],[104,0,104,5],[107,0,107,5],[109,0,109,18],[110,0,124,18],[125,0,125,6],[125,11,125,18],[126,2,126,3],[126,11,147,18],[127,2,127,3],[128,2,128,3],[129,2,129,3],[130,2,130,3],[131,2,131,3],[132,2,132,3],[133,2,133,3],[134,2,134,3],[135,2,135,3],[136,2,136,3],[137,2,137,3],[138,2,138,3],[139,2,139,3],[140,2,140,3],[141,2,141,3],[142,2,142,3],[143,2,143,3],[144,2,144,3],[145,2,145,3],[146,2,146,3],[147,2,147,3],[148,0,148,18],[150,0,150,6],[150,11,150,18],[151,0,151,1],[151,11,162,18],[152,0,152,1],[153,0,153,1],[154,0,154,1],[155,0,155,1],[156,0,156,1],[157,0,157,1],[158,0,158,1],[159,0,159,1],[160,0,160,1],[161,0,161,1],[162,2,162,3],[163,0,163,18],[164,0,164,18],[169,0,169,1],[169,2,169,3],[169,5,169,6],[169,7,169,11],[169,12,169,17],[170,0,170,1],[170,2,170,3],[170,5,170,6],[170,7,170,11],[170,12,170,17],[171,0,171,1],[171,2,171,3],[171,5,171,6],[171,7,171,11],[171,12,171,17],[172,0,172,1],[172,2,172,3],[172,5,172,6],[172,7,172,11],[172,12,172,17],[173,0,173,1],[173,2,173,3],[173,5,173,6],[173,7,173,11],[173,12,173,17],[174,0,174,1],[174,2,174,3],[174,5,174,6],[174,7,174,11],[174,12,174,17],[175,0,175,1],[175,2,175,3],[175,5,175,6],[175,7,175,11],[175,12,175,17],[176,0,176,1],[176,2,176,3],[176,5,176,6],[176,7,176,11],[176,12,176,17],[177,0,177,1],[177,2,177,3],[177,5,177,6],[177,7,177,11],[177,12,177,17],[178,0,178,1],[178,2,178,3],[178,5,178,6],[178,7,178,11],[178,12,178,17],[179,0,179,1],[179,2,179,3],[179,5,179,6],[179,7,179,11],[179,12,179,17],[180,0,180,1],[180,2,180,3],[180,5,180,6],[180,7,180,11],[180,12,180,17],[181,0,181,1],[181,2,181,3],[181,5,181,6],[181,7,181,11],[181,12,181,17],[182,0,182,1],[182,2,182,3],[182,5,182,6],[182,7,182,11],[182,12,182,17],[183,0,183,1],[183,2,183,3],[183,5,183,6],[183,7,183,11],[183,12,183,17],[184,0,184,1],[184,2,184,3],[184,5,184,6],[184,7,184,11],[184,12,184,17],[185,0,185,1],[185,2,185,3],[185,5,185,6],[185,7,185,11],[185,12,185,17],[186,0,186,1],[186,2,186,3],[186,5,186,6],[186,7,186,11],[186,12,186,17],[187,0,187,18],[187,19,187,20],[188,0,188,1],[188,2,188,3],[188,5,188,6],[188,7,188,11],[188,12,188,17],[188,19,188,20],[189,0,189,18],[189,19,189,20]]}
[{"$f":"\"Begrotingsaanvraag : \" & C6","v":"Begrotingsaanvraag : "}]
[]
["PROJECT DETAILS"]
["Project name:"]
["Project term (from xx/xx/20xx to xx/xx/20xx)"]
["Company name or institution:"]
["Contact person for additional information (name, position, phone number and email address):"]
[]
["STAFFING COSTS\n"]
[{"$nulls":5},"project year 1","project year 2","project year 3","Project year 4","Project year 5","Project year 6"]
["Number of hours worked on an annual basis (1):",{"$nulls":4},{"v":1596,"d":"1,596"},{"v":1596,"d":"1,596"},{"v":1596,"d":"1,596"},{"v":1596,"d":"1,596"},{"v":1596,"d":"1,596"},{"v":1596,"d":"1,596"}]
[{"$nulls":5},{"$f":"IF(F11>1720,1720,F11)","v":1596},{"$f":"IF(G11>1720,1720,G11)","v":1596},1596,1596,1596,1596]
["Employee (e), Operating costs (o), Barema (b)"]
["Staff",{"$nulls":4},{"$f":"IF(COUNTIFS($E$16:$E$87,\"=b\")>0,\"Jaarloonkost\",\"bruto maandloon (3)\")","v":"Jaarloonkost"},{"$nulls":5},"PM spent on project"]
["Name or staff category",{"$nulls":3},"Code (2)",{"$f":"IF(COUNTIFS($E$16:$E$87,\"=b\")>0,\"Jaarloonkost jaar 1\",\"Vast maandloon jaar 1\")","v":"Jaarloonkost jaar 1"},{"$f":"IF(COUNTIFS($E$16:$E$87,\"=b\")>0,\"Jaarloonkost jaar 2\",\"Vast maandloon jaar 2\")","v":"Jaarloonkost jaar 2"},{"$f":"IF(COUNTIFS($E$16:$E$87,\"=b\")>0,\"Jaarloonkost jaar 3\",\"Vast maandloon jaar 3\")","v":"Jaarloonkost jaar 3"},{"$f":"IF(COUNTIFS($E$16:$E$87,\"=b\")>0,\"Jaarloonkost jaar 4\",\"Vast maandloon jaar 4\")","v":"Jaarloonkost jaar 4"},{"$f":"IF(COUNTIFS($E$16:$E$87,\"=b\")>0,\"Jaarloonkost jaar 5\",\"Vast maandloon jaar 5\")","v":"Jaarloonkost jaar 5"},{"$f":"IF(COUNTIFS($E$16:$E$87,\"=b\")>0,\"Jaarloonkost jaar 6\",\"Vast maandloon jaar 6\")","v":"Jaarloonkost jaar 6"},"PM Yr 1","PM Yr 2","PM Yr 3","PM Yr 4","PM Yr 5","PM Yr 6","total accepted PMs","Project staffing costs"]
[{"$nulls":4},"b",{"$nulls":12},{"$f":"SUM(L16:Q16)","v":{"v":0,"d":"0.0"}},{"$f":"IF(E16=\"o\",0,IF(COUNTIFS($E$16:$E$87,\"=b\")>0,IF(E16=\"b\",(F16/12*L16)+(G16/12*M16)+(H16/12*N16)+(I16/12*O16)+(J16/12*P16)+(K16/12*Q16),0),(F16*1.2%*$F$12/12*L16)+(G16*1.2%*$G$12/12*M16)+(H16*1.2%*$H$12/12*N16)+(I16*1.2%*$I$12/12*O16)+(J16*1.2%*$J$12/12*P16)+(K16*1.2%*$K$12/12*Q16)))","v":{"v":0,"d":"0 €"}},{"$f":"IF(E16=\"o\",0,SUM(L16:Q16))","v":0}]
[{"$nulls":17},{"$f":"SUM(L17:Q17)","v":{"v":0,"d":"0.0"}},{"$f":"IF(E17=\"o\",0,IF(COUNTIFS($E$16:$E$87,\"=b\")>0,IF(E17=\"b\",(F17/12*L17)+(G17/12*M17)+(H17/12*N17)+(I17/12*O17)+(J17/12*P17)+(K17/12*Q17),0),(F17*1.2%*$F$12/12*L17)+(G17*1.2%*$G$12/12*M17)+(H17*1.2%*$H$12/12*N17)+(I17*1.2%*$I$12/12*O17)+(J17*1.2%*$J$12/12*P17)+(K17*1.2%*$K$12/12*Q17)))","v":{"v":0,"d":"0 €"}},{"$f":"IF(E17=\"o\",0,SUM(L17:Q17))","v":0}]
[{"$nulls":17},{"v":0,"d":"0.0"},{"v":0,"d":"0 €"},0]
[{"$nulls":17},{"v":0,"d":"0.0"},{"v":0,"d":"0 €"},0]
[{"$nulls":17},{"v":0,"d":"0.0"},{"v":0,"d":"0 €"},0]
[{"$nulls":17},{"v":0,"d":"0.0"},{"v":0,"d":"0 €"},0]
[{"$nulls":17},{"v":0,"d":"0.0"},{"v":0,"d":"0 €"},0]
[{"$nulls":17},{"v":0,"d":"0.0"},{"v":0,"d":"0 €"},0]
[{"$nulls":17},{"v":0,"d":"0.0"},{"v":0,"d":"0 €"},0]
[{"$nulls":17},{"v":0,"d":"0.0"},{"v":0,"d":"0 €"},0]
[{"$nulls":17},{"v":0,"d":"0.0"},{"v":0,"d":"0 €"},0]
[{"$nulls":17},{"v":0,"d":"0.0"},{"v":0,"d":"0 €"},0]
[{"$nulls":17},{"v":0,"d":"0.0"},{"v":0,"d":"0 €"},0]
[{"$nulls":17},{"v":0,"d":"0.0"},{"v":0,"d":"0 €"},0]
[{"$nulls":17},{"v":0,"d":"0.0"},{"v":0,"d":"0 €"},0]
[{"$nulls":17},{"v":0,"d":"0.0"},{"v":0,"d":"0 €"},0]
[{"$nulls":17},{"v":0,"d":"0.0"},{"v":0,"d":"0 €"},0]
[{"$nulls":17},{"v":0,"d":"0.0"},{"v":0,"d":"0 €"},0]
[{"$nulls":17},{"v":0,"d":"0.0"},{"v":0,"d":"0 €"},0]
[{"$nulls":17},{"v":0,"d":"0.0"},{"v":0,"d":"0 €"},0]
[{"$nulls":17},{"v":0,"d":"0.0"},{"v":0,"d":"0 €"},0]
[{"$nulls":17},{"v":0,"d":"0.0"},{"v":0,"d":"0 €"},0]
[{"$nulls":17},{"v":0,"d":"0.0"},{"v":0,"d":"0 €"},0]
[{"$nulls":17},{"v":0,"d":"0.0"},{"v":0,"d":"0 €"},0]
[{"$nulls":17},{"v":0,"d":"0.0"},{"v":0,"d":"0 €"},0]
[{"$nulls":17},{"v":0,"d":"0.0"},{"v":0,"d":"0 €"},0]
[{"$nulls":17},{"v":0,"d":"0.0"},{"v":0,"d":"0 €"},0]
[{"$nulls":17},{"v":0,"d":"0.0"},{"v":0,"d":"0 €"},0]
[{"$nulls":17},{"v":0,"d":"0.0"},{"v":0,"d":"0 €"},0]
[{"$nulls":17},{"v":0,"d":"0.0"},{"v":0,"d":"0 €"},{"$f":"IF(E45=\"w\",0,SUM(L45:Q45))","v":0}]
[{"$nulls":17},{"v":0,"d":"0.0"},{"v":0,"d":"0 €"},0]
[{"$nulls":17},{"v":0,"d":"0.0"},{"v":0,"d":"0 €"},0]
[{"$nulls":17},{"v":0,"d":"0.0"},{"v":0,"d":"0 €"},0]
[{"$nulls":17},{"v":0,"d":"0.0"},{"v":0,"d":"0 €"},0]
[{"$nulls":17},{"v":0,"d":"0.0"},{"v":0,"d":"0 €"},0]
[{"$nulls":17},{"v":0,"d":"0.0"},{"v":0,"d":"0 €"},0]
[{"$nulls":17},{"v":0,"d":"0.0"},{"v":0,"d":"0 €"},0]
[{"$nulls":17},{"v":0,"d":"0.0"},{"v":0,"d":"0 €"},0]
[{"$nulls":17},{"v":0,"d":"0.0"},{"v":0,"d":"0 €"},0]
[{"$nulls":17},{"v":0,"d":"0.0"},{"v":0,"d":"0 €"},0]
[{"$nulls":17},{"v":0,"d":"0.0"},{"v":0,"d":"0 €"},0]
[{"$nulls":17},{"v":0,"d":"0.0"},{"v":0,"d":"0 €"},0]
[{"$nulls":17},{"v":0,"d":"0.0"},{"v":0,"d":"0 €"},0]
[{"$nulls":17},{"v":0,"d":"0.0"},{"v":0,"d":"0 €"},0]
[{"$nulls":17},{"v":0,"d":"0.0"},{"v":0,"d":"0 €"},0]
[{"$nulls":17},{"v":0,"d":"0.0"},{"v":0,"d":"0 €"},0]
[{"$nulls":17},{"v":0,"d":"0.0"},{"v":0,"d":"0 €"},0]
[{"$nulls":17},{"v":0,"d":"0.0"},{"v":0,"d":"0 €"},0]
[{"$nulls":17},{"v":0,"d":"0.0"},{"v":0,"d":"0 €"},0]
[{"$nulls":17},{"v":0,"d":"0.0"},{"v":0,"d":"0 €"},0]
[{"$nulls":17},{"v":0,"d":"0.0"},{"v":0,"d":"0 €"},0]
[{"$nulls":17},{"v":0,"d":"0.0"},{"v":0,"d":"0 €"},0]
[{"$nulls":17},{"v":0,"d":"0.0"},{"v":0,"d":"0 €"},0]
[{"$nulls":17},{"v":0,"d":"0.0"},{"v":0,"d":"0 €"},0]
[{"$nulls":17},{"v":0,"d":"0.0"},{"v":0,"d":"0 €"},0]
[{"$nulls":17},{"v":0,"d":"0.0"},{"v":0,"d":"0 €"},0]
[{"$nulls":17},{"v":0,"d":"0.0"},{"v":0,"d":"0 €"},0]
[{"$nulls":17},{"v":0,"d":"0.0"},{"v":0,"d":"0 €"},0]
[{"$nulls":17},{"v":0,"d":"0.0"},{"v":0,"d":"0 €"},0]
[{"$nulls":17},{"v":0,"d":"0.0"},{"v":0,"d":"0 €"},0]
[{"$nulls":17},{"v":0,"d":"0.0"},{"v":0,"d":"0 €"},0]
[{"$nulls":17},{"v":0,"d":"0.0"},{"v":0,"d":"0 €"},0]
[{"$nulls":17},{"v":0,"d":"0.0"},{"v":0,"d":"0 €"},0]
[{"$nulls":17},{"v":0,"d":"0.0"},{"v":0,"d":"0 €"},0]
[{"$nulls":17},{"v":0,"d":"0.0"},{"v":0,"d":"0 €"},0]
[{"$nulls":17},{"$f":"SUM(L81:Q81)","v":{"v":0,"d":"0.0"}},{"$f":"IF(E81=\"o\",0,IF(COUNTIFS($E$16:$E$87,\"=b\")>0,IF(E81=\"b\",(F81/12*L81)+(G81/12*M81)+(H81/12*N81)+(I81/12*O81)+(J81/12*P81)+(K81/12*Q81),0),(F81*1.2%*$F$12/12*L81)+(G81*1.2%*$G$12/12*M81)+(H81*1.2%*$H$12/12*N81)+(I81*1.2%*$I$12/12*O81)+(J81*1.2%*$J$12/12*P81)+(K81*1.2%*$K$12/12*Q81)))","v":{"v":0,"d":"0 €"}},{"$f":"IF(E81=\"w\",0,SUM(L81:Q81))","v":0}]
[{"$nulls":17},{"v":0,"d":"0.0"},{"v":0,"d":"0 €"},0]
[{"$nulls":17},{"v":0,"d":"0.0"},{"v":0,"d":"0 €"},0]
[{"$nulls":17},{"v":0,"d":"0.0"},{"v":0,"d":"0 €"},0]
[{"$nulls":17},{"v":0,"d":"0.0"},{"v":0,"d":"0 €"},0]
[{"$nulls":17},{"v":0,"d":"0.0"},{"v":0,"d":"0 €"},0]
[{"$nulls":17},{"v":0,"d":"0.0"},{"v":0,"d":"0 €"},0]
["TOTAL STAFFING COSTS",{"$nulls":10},{"$f":"SUM(L16:L87)","v":{"v":0,"d":"0.0"}},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"$f":"SUM(R16:R87)","v":{"v":0,"d":"0.0"}},{"$f":"SUM(S16:S87)","v":{"v":0,"d":"0 €"}},{"$f":"SUM(T16:T87)","v":0}]
["(1) By default, VLAIO estimates that an AWU consists of 1,596 hours.\n(2) Please enter one of the following codes in the “Code”column. \n“e”: for project members with employee status (=with a payslip and therefore on the company’s payroll). Self-employed professionals who submit invoices for their services, including business managers contracted through management service companies, are considered third-party services.\n“o\": (operating costs) for business managers and working partners listed in the company's share register + self-employed professionals and freelancers with a long-term formal commitment to the applicant company who may or may not pay themselves a salary (PMs do not count towards overhead costs, whereas they are considered in determining the ceiling on operating costs, except for workers who have a full replacement income). Long-term formal commitment means that the worker in question has or had the intention to work for the company for 12 consecutive months or for at least half the runtime of the project, provided that they do not work exclusively for the applicant company.\n“b” : (barema/pay scale) for companies or research institutions that have made prior arrangements with regard to the use of gross wages for certain staff categories or that have fixed pay scales. These rates are entered on an annual basis.\n(3) Wage costs are calculated based on a standard hourly rate (SHR) multiplied by the time spent on the project. The SHR is determined on a flat rate basis by multiplying the average gross monthly wages over the first project year (assuming full-time employment) of the staff member concerned at the start of the project by the coefficient 1.2%. For employees who are yet to be contracted at the start of the project, one can enter the estimated gross monthly wages for their first month of employment. These average gross monthly wages are based on the fixed monthly wages/basic monthly wages/fixed compensation, i.e. without any other allowances or benefits, such as holiday pay or an end-of-year bonus, as these are already included in the 1.2% coefficient. Example: employee X works part-time (50%) and their average gross wages over the next 12 months = EUR 2,000/month. This employee’s gross monthly salary will be = (EUR 2,000/50%) = EUR 4,000, EUR 4,000 x 1.2% = EUR 48/hour (= SHR). For projects spanning multiple years, an annual indexation of 2% may be applied.\n\n"]
[]
["Notes on staffing costs "]
{"$rows_empty":8}
["OVERHEAD COSTS"]
[null,null,"Person Months","AWUs","overhead/AWU (*)"]
["calculated overhead costs",null,{"$f":"T88","v":{"v":0,"d":"0.0"}},{"$f":"+C102/12","v":{"v":0,"d":"0.0"}},{"v":25000,"d":"25,000 €"},{"$f":"$E$102*$D$102","v":{"v":0,"d":"0 €"}}]
["*overhead costs are capped at EUR 25,000/AWU for employees with employee status. If this sum is expected to be lower, it must be changed here."]
[]
["OPERATING COSTS"]
[null,null,"Person Months","AWUs","operating cost ceiling (*)","submitted"]
["operating costs",null,{"$f":"R88","v":{"v":0,"d":"0.0"}},{"$f":"C107/12","v":{"v":0,"d":"0.0"}},{"$f":"25000*D107","v":{"v":0,"d":"0 €"}},{"v":0,"d":"0 €"}]
["*operating costs can be easily claimed up to a ceiling of EUR 25,000/person-year without requiring additional substantiation. Attention: this is not a fixed amount! At final settlement, these costs can be requested in detail by the verification department. The ceiling of EUR 25,000/AWU can only be broken if the additional operating costs above this ceiling represent at least 10% of the total partner budget. In these cases, however, a detailed substantiation of all operating costs must be provided. These costs must be substantiated in detail in the table below or in a separate tab attached to this Excel file. No budget transfers exceeding 10% may be made between the various budgeted items in those cases."]
[]
["If exceeding the ceiling of EUR 25,000/AWU, the claimed operating expenses must be substantiated in the table below or in a separate tab in this Excel file."]
{"$rows_empty":15}
["THIRD-PARTY SERVICES  (*)",{"$nulls":10},"Notes on third-party services"]
["Name of supplier/provider","Company number (BExxx.xxx)","Description",null,"cost driver (number of PMs; number of tests; ...)","Country","Costs excluding VAT (**)"]
{"$rows_empty":20}
["OVERALL THIRD-PARTY SERVICES",{"$nulls":5},{"$f":"SUM(G128:G147)","v":{"v":0,"d":"0 €"}}]
["(*)This category is for third parties (companies, self-employed professionals, freelancers, knowledge centres and research institutions) who provide a service as a subcontractor on behalf of a project or research partner, as well as management companies.  Business managers and working partners, as well as self-employed professionals and freelancers with a long-term formal commitment to the company applying for aid who do not pay themselves, or only pay themselves partially, can also report their PMs under the Staffing costs category using the code “o\", provided they do not have a full replacement income. Long-term formal commitment means that the worker in question has or had the intention to work for the company for 12 consecutive months or for at least half the runtime of the project. When opting for AWUs as a cost driver, an AWU is, by default, considered to consist of 1596 hours or 210 working days.\nSupport measure for start-ups that were founded less than 6 years before the application for aid is submitted - managers and working partners included in the company’s share register can pay themselves through a Current Account (capped at EUR 8,500/month). This means that (part of) their invoiced costs during the project term do not have to be demonstrated as actual cash expenditure in order to be taken into account as eligible costs in the final audit. If you are planning to make use of this measure, please indicate this clearly in the table.\n(**)Rendered services and customised goods that were not capitalised and amounted to at least EUR 10,000 excluding VAT are eligible for inclusion in the Third-party services category. Costs below this amount are to be categorised under operating costs.\nCosts for third-party services must be accounted for by attaching a quote, an invoice for a comparable assignment or a substantiated estimate to the application file or explaining them in in Excel cost template."]
[]
[" INVESTMENT COSTS (*)",{"$nulls":10},"Notes on investment costs"]
["Description of capitalised expenses",null,"Purchase price excluding VAT","Economic lifetime in months","time used during the project period expressed in months","Usage rate for the project (%)","Depreciation (**)"]
[{"$nulls":6},{"$f":"IF(D153=0,0,(C153/D153)*E153*F153)","v":{"v":0,"d":"0 €"}}]
[{"$nulls":6},{"$f":"IF(D154=0,0,(C154/D154)*E154*F154)","v":{"v":0,"d":"0 €"}}]
[{"$nulls":6},{"v":0,"d":"0 €"}]
[{"$nulls":6},{"v":0,"d":"0 €"}]
[{"$nulls":6},{"v":0,"d":"0 €"}]
[{"$nulls":6},{"v":0,"d":"0 €"}]
[{"$nulls":6},{"v":0,"d":"0 €"}]
[{"$nulls":6},{"v":0,"d":"0 €"}]
[{"$nulls":6},{"v":0,"d":"0 €"}]
[{"$nulls":6},{"v":0,"d":"0 €"}]
["TOTAL INVESTMENT COSTS",{"$nulls":5},{"$f":"SUM(G153:G162)","v":{"v":0,"d":"0 €"}}]
["(*)Only depreciation costs related to investments that are specifically necessary for the execution of the project or funded activities are eligible. The standard depreciation rate is based on a 5-year period. Other depreciation schedules may be considered in exceptional cases, but they may never be shorter than 3 years.  Investments are to be allocated on a pro rate basis according to the usage, utilisation or occupancy rate and the period of use of the investment good within the project term. \n(**)Only depreciated costs of at least EUR 20,000 that represent at least 10% of the overall partner budget are eligible for the Investment costs category. Costs below this amount are to be categorised under operating costs.\nThe investment costs must be justified on request by means of depreciation tables and the overview of the balance sheet accounts (class 2) if they already appear as depreciating assets in the accounts and/or be substantiated by an offer or invoice in an attachment or in the field under \"Explanation of investment costs \"."]
["OVERVIEW"]
["Applied grant rate (*)"]
["Person Months for companies (“o”)",{"$f":"SUMIF(E16:E87,\"o\",R16:R87)","v":{"v":0,"d":"0.0"}}]
["Total PMs submitted",{"$f":"R88","v":{"v":0,"d":"0.0"}}]
[]
[null,null,"Staffing costs",null,"Overhead costs","Operating costs",null,"Investment costs",{"$nulls":4},"Budget",{"$nulls":5},"Grant"]
[{"$f":"\"Begunstigde : \" &C6","v":"Begunstigde : "},null,{"$f":"S88","v":{"v":0,"d":"0 €"}},null,{"$f":"F102","v":{"v":0,"d":"0 €"}},{"$f":"F107","v":{"v":0,"d":"0 €"}},null,{"$f":"G163","v":{"v":0,"d":"0 €"}},{"$nulls":4},{"$f":"SUM(C171:L171)","v":{"v":0,"d":"0 €"}}]
[{"$f":"IF(ISBLANK(A128),\"\",A128)","v":""},{"$nulls":11},{"$f":"G128","v":{"v":0,"d":"0 €"}}]
["",{"$nulls":11},{"$f":"G129","v":{"v":0,"d":"0 €"}}]
["",{"$nulls":11},{"$f":"G130","v":{"v":0,"d":"0 €"}}]
["",{"$nulls":11},{"$f":"G131","v":{"v":0,"d":"0 €"}}]
["",{"$nulls":11},{"v":0,"d":"0 €"}]
["",{"$nulls":11},{"$f":"G133","v":{"v":0,"d":"0 €"}}]
["",{"$nulls":11},{"v":0,"d":"0 €"}]
["",{"$nulls":11},{"v":0,"d":"0 €"}]
["",{"$nulls":11},{"v":0,"d":"0 €"}]
["",{"$nulls":11},{"v":0,"d":"0 €"}]
["",{"$nulls":11},{"v":0,"d":"0 €"}]
["",{"$nulls":11},{"v":0,"d":"0 €"}]
["",{"$nulls":11},{"v":0,"d":"0 €"}]
["",{"$nulls":11},{"v":0,"d":"0 €"}]
["",{"$nulls":11},{"v":0,"d":"0 €"}]
["Total",{"$nulls":11},{"$f":"SUM(M171:R186)","v":{"v":0,"d":"0 €"}},{"$nulls":5},{"$f":"M187*B166","v":{"v":0,"d":"0 €"}}]
["(*) the claimed grant rate should be entered here"]
[]
["The applicant notes that the Agency for Innovation and Entrepreneurship may always review and recover the grant if a party has made false or incomplete statements for the purpose of the grant or any other benefit."]

{"sheet":"Budget application totals","index":2,"n_rows":26,"n_cols":15,"rows_kept":26,"merged":[[0,0,0,14],[2,0,2,14],[3,0,3,1],[3,2,3,14],[4,0,4,1],[4,2,4,14],[5,0,5,1],[5,2,5,14],[6,0,6,1],[6,2,6,14],[8,0,8,14],[9,0,10,0],[9,1,10,1],[9,2,10,3],[9,4,10,4],[9,5,10,5],[9,6,10,6],[9,7,10,7],[9,12,10,12],[9,13,10,13],[9,14,10,14],[11,2,11,3],[12,2,12,3],[13,2,13,3],[14,2,14,3],[15,2,15,3],[16,2,16,3],[17,2,17,3],[18,2,18,3],[19,2,19,3],[20,2,20,3],[21,2,21,3],[22,0,22,14],[23,0,23,14],[25,0,25,14]]}
["Project overview"]
["This tab only needs to be filled in if there are multiple partners involved in the project"]
["PROJECT DETAILS"]
["Project name:"]
["Project term (from xx/xx/20xx to xx/xx/20xx)"]
["Company name or institution of main applicant:"]
["Contact person for additional information (name, position, phone number and email address):"]
[]
["Totals by partner in budget application"]
["Name of beneficiary partner (1)","Total PMs submitted","Staffing costs",null,"Overhead costs","Operating costs","Third-party services","Investment costs","RI 1 (2)","RI 2","RI 3","RI 4","Total costs","Applied grant%","Amount of funding applied for "]
[{"$nulls":8},"Name of RI","Name of RI","Name of RI","Name of RI"]
["Partner 1",{"$nulls":11},{"$f":"SUM(C12:L12)","v":{"v":0,"d":"0 €"}},null,{"$f":"M12*N12","v":{"v":0,"d":"0 €"}}]
["Partner 2",{"$nulls":11},{"$f":"SUM(C13:L13)","v":{"v":0,"d":"0 €"}},null,{"$f":"M13*N13","v":{"v":0,"d":"0 €"}}]
["Partner 3",{"$nulls":11},{"v":0,"d":"0 €"},null,{"v":0,"d":"0 €"}]
["Partner 4",{"$nulls":11},{"v":0,"d":"0 €"},null,{"v":0,"d":"0 €"}]
["Partner 5",{"$nulls":11},{"v":0,"d":"0 €"},null,{"v":0,"d":"0 €"}]
["Partner 6",{"$nulls":11},{"v":0,"d":"0 €"},null,{"v":0,"d":"0 €"}]
["Partner 7",{"$nulls":11},{"v":0,"d":"0 €"},null,{"v":0,"d":"0 €"}]
["Partner 8",{"$nulls":11},{"v":0,"d":"0 €"},null,{"v":0,"d":"0 €"}]
["Partner 9",{"$nulls":11},{"v":0,"d":"0 €"},null,{"v":0,"d":"0 €"}]
["Partner 10",{"$nulls":11},{"v":0,"d":"0 €"},null,{"v":0,"d":"0 €"}]
[null,{"$f":"SUM(B12:B21)","v":{"v":0,"d":"0.0"}},{"$nulls":6},{"$f":"SUM(I12:I21)","v":{"v":0,"d":"0 €"}},{"$f":"SUM(J12:J21)","v":{"v":0,"d":"0 €"}},{"$f":"SUM(K12:K21)","v":{"v":0,"d":"0 €"}},{"$f":"SUM(L12:L21)","v":{"v":0,"d":"0 €"}},{"$f":"SUM(M12:M21)","v":{"v":0,"d":"0 €"}},null,{"$f":"SUM(O12:O21)","v":{"v":0,"d":"0 €"}}]
["(1) please enter the name of the business partner or knowledge institution here. The knowledge institution can be placed in this column if they are a beneficiary in ICON / COOCK / TETRA / ... or in the RI columns if they are a Research partner."]
["(2) If a research partner is to be paid by multiple business partners, please split the amount over the various business partners here. Example: an RI has reported a budget of EUR 10,000 EUR and is reimbursed for this by business partner 1 and business partner 2. If both business partners contribute half, EUR 5,000 should be categorised under business partner 1 and EUR 5,000 EUR under business partner 2. Other splits are possible, of course, but the total at the bottom of the column for each RI must be equal to the total budgeted costs for the RI in question, which must draw up a separate financial report."]
[]
["This document will also serve as the basis for all communication with VLAIO during the execution of your project.  Any requests for budget transfers between partners must be made based on this application document.  The necessary explanations must then be given below. "]