{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["EC Instructions","EC Data","EC Format","1. Instructions","2. Start","3. Detailed table ","4. Consolid table (participant)","5. Consolid table (project)"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":0,"defined_names":232,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"EC Instructions","index":0,"n_rows":23,"n_cols":1,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["EC INSTRUCTIONS (DETAILED BUDGET TABLE (AG) — PROPOSAL/GRANT PREPARATION) "]
[]
[]
["General"]
["The file is composed of 3 password-protected sheets for EU staff (EC Instructions, EC Data and EC Format) and 5 sheets for the Consortium (1. Instructions, 2. Start, 3. Detailed table and 4. Consolidated table (participant) and 5. Consolidated table (project). "]
["The EC sheets (EC Data) must be set-up only once for your programme/MGAs (works for all MGAs, except operating grants - see separate template) as part of the Programme template set-up exercise. \n"]
["The Participant sheets (2. Start, 3. Detailed table and 4. Consolidated table) must be filled out and submitted as part of the Proposal (and later during GAP):\n- dowloaded, filled in, scanned and uploaded as single xlsx/PDF for the project in SEP/SyGMa (for sheets 3 and 4: one per beneficiary/linked third party inside the single xlsx/PDF).\nFor security reasons, the document can NOT be uploaded as excel with macros (xlsm). Once filled in and finalised, it must therefore be saved as xlsx/PDF copy, and this copy must be used for the upload."]
[]
["Getting started"]
["To use the file, the Excel Macro security settings must be enabled on your computer. This is managed and checked when opening the file, but contact your IT team if you encounter problems."]
["Download the file for set-up: Before downloading close all other excel files (open excel files may hamper the macros). Download the file from the ToolKit using EDIT WORKBOOK - EDIT IN EXCEL - SAVE AS to save a copy on your desktop. Then close the document and re-open it.  "]
["Unblock the file:  Before starting (and after each time you save), you have to unblock the file by clicking the 'Unprotect All Sheets' button (or alternatively by pressing Ctrl Q + Password: Detailed budget table). If it doesn't work, try several times.\n\n"]
[]
["EC Data sheet"]
["Make your choices in the EC Data sheet. \nWhen finished, click on the 'Save & Update Detailed Budget Table' button."]
[]
["EC Format sheet"]
["The EC-Format sheet is for view-only purposes. You do NOT need to do anything on it. \nThis sheet shows the rows that will be copied into the table for each new WP the participants will choose (via their Start sheet)."]
[]
["Testing"]
["Test your configuration several times with real numbers. You need to be sure that the table works for your participants."]
["If you would like to hide the 3 EC sheets, place the cursor on sheet '1. Instructions' and press CTRL Q and answer the question box with OK. (Normally this is not done; we normally publish with the 3 EC sheets visible)."]
["After this, you can save the file and it is ready for use."]

{"sheet":"EC Data","index":1,"n_rows":180,"n_cols":8,"rows_kept":180,"cut":false,"hidden":false,"merged":[[67,4,67,5],[68,4,68,5],[69,4,69,5],[70,4,70,5],[96,4,96,5],[97,2,97,3],[97,4,97,5],[80,0,80,7],[75,0,75,1],[76,0,76,1],[77,0,77,1],[78,0,78,1],[72,0,72,7],[100,0,100,7],[91,2,91,3],[92,2,92,3],[86,4,86,5],[87,4,87,5],[88,4,88,5],[89,4,89,5],[90,4,90,5],[98,4,98,5],[99,4,99,5],[93,2,93,3],[93,4,93,5],[94,2,94,3],[94,4,94,5],[95,2,95,3],[95,4,95,5],[88,2,88,3],[89,2,89,3],[90,2,90,3],[98,2,98,3],[99,2,99,3],[91,4,91,5],[92,4,92,5],[96,2,96,3],[145,0,146,0],[145,1,146,1],[145,2,149,7],[143,0,143,7],[63,0,63,1],[65,0,65,1],[63,4,63,5],[64,4,64,5],[70,0,70,1],[103,0,103,7],[123,1,124,1],[64,0,64,1],[66,0,66,1],[123,2,123,4],[123,5,141,7],[125,0,125,4],[74,0,74,1],[102,0,102,7],[68,0,68,1],[69,0,69,1],[101,0,101,7],[85,0,85,1],[86,2,86,3],[87,2,87,3],[176,2,176,4],[171,2,171,4],[171,1,172,1],[176,0,177,0],[171,0,172,0],[169,0,169,7],[151,0,152,0],[151,2,151,4],[151,5,158,7],[153,2,153,4],[156,2,156,4],[162,2,162,4],[165,2,165,4],[160,0,161,0],[160,2,160,4],[160,5,167,7],[151,1,152,1],[160,1,161,1],[0,0,0,7],[2,0,2,7],[3,0,4,3],[3,6,4,7],[30,0,30,7],[7,2,7,4],[8,2,19,7],[23,2,28,7],[73,0,73,1],[32,0,43,0],[32,2,43,7],[60,0,60,7],[45,0,45,7],[47,2,52,7],[48,0,52,0],[53,2,58,7],[54,0,58,0],[61,4,61,5],[62,4,62,5],[61,0,61,1],[62,0,62,1],[67,0,67,1],[65,4,65,5],[66,4,66,5]]}
["EC DATA (DETAILED BUDGET TABLE (AG) — PROPOSAL/GRANT PREPARATION)"]
[]
["Work package numbers"]
[null,null,null,null,"WP_nb","PW"]
[null,null,null,null,0,"Detailed budget table"]
[]
["Which cost categories?"]
[null,"1=Yes / 0=No","Index and WP"]
["A. Personnel costs",1,0]
["B. Subcontracting costs",1]
["C1. Travel and subsistence",1]
["C2. Equipment",1]
["C3. Other goods, works and services ",1]
["D.1. Financial support to third parties",0]
["D.2 [Category name]",0]
["D.3 [Category name]",0]
["D.4 [Category name]",0]
["D.5 [Category name]",0]
["D.6 [Category name]",0]
["E. Indirect costs",1]
[]
["Which staff type?"]
[null,"1=Yes / 0=No"]
["A.1 Employees (or equivalent)",1]
["A.2 + A.3 Natural persons under direct contract and seconded persons ",1]
["A.4 SME owners without salary and natural person beneficiaries without salary",1]
["A.5 Volunteers",0]
["A.6 [Category name]",0]
["A.7 [Category name]",0]
[]
["Which staff categories?"]
[null,"Drop-down menu"]
[null,"Select a staff category","This is the default list for personnel categories. \n\nATTENTION! The categories can be changed if needed but please don't  insert blank lines between 2 categories (otherwise the drop down menu will not work)"]
[null,"Project managers"]
[null,"Senior experts/advisors/researchers"]
[null,"Junior experts/advisors/researchers"]
[null,"Trainers/teachers"]
[null,"Technical personnel"]
[null,"Administrative personnel"]
[null,"Other"]
[]
[]
[]
[]
[]
["Which type of personnel cost rate? "]
[null,"Drop-down menu"]
[{"$f":"A28","v":"A.6 [Category name]"},"Select a type of rate","This list contains the options for the types of rates available for the 'Other personnel costs'.\n\nATTENTION! You must chose the rate provided for in your MGA (usually 'daily' or 'other')."]
[null,"Monthly"]
[null,"Daily"]
[null,"Hourly"]
[null,"Other"]
[]
[{"$f":"A29","v":"A.7 [Category name]"},"Select a type of rate","This list contains the options for the types of rates available for the 'Other personnel costs'.\n\nATTENTION! You must chose the rate provided for in your MGA (usually 'daily' or 'other')."]
[null,"Monthly"]
[null,"Daily"]
[null,"Hourly"]
[null,"Other"]
[]
[]
["Which type of costs (actual, lump sum or unit)?"]
["Travel and subsistence",null,"Actual","Unit or Actual","Subdivided\n1=Yes / 0=No"]
["C.1. Travel and subsistence",null,null,null,1,null,null,2]
["Financial support to third parties",null,"Actual","Unit","Actual and Unit"]
["D.1. Financial Support",null,null,null,null,null,null,1]
["Other cost categories",null,"Actual","Unit"," Lump Sum"]
[{"$f":"A15","v":"D.2 [Category name]"},null,null,null,null,null,null,1]
[{"$f":"A16","v":"D.3 [Category name]"},null,null,null,null,null,null,1]
[{"$f":"A17","v":"D.4 [Category name]"},null,null,null,null,null,null,1]
[{"$f":"A18","v":"D.5 [Category name]"},null,null,null,null,null,null,1]
[{"$f":"A19","v":"D.6 [Category name]"},null,null,null,null,null,null,1]
[]
["Which type of indirect cost rate?"]
["Option 1: STANDARD 7%",null,null,null,null,null,null,1]
["Option 2: HE 25%",null,null,null,null,null,null,1]
["Option 3: AGRIP 4%"]
["Option 4: RFCS 35%"]
["Option 5: SMP ESS 30%"]
["Option 6: NO INDIRECT COSTS 0%"]
[]
["Which type of funding rate?"]
[]
["Single funding rate",null,null,null,null,null,null,1]
["Multiple funding rates"]
["For Multiple funding rates:\n1) Enter the formula for the calculation (see Annex 2 MGA)\nexample (a1 + a2 + a3 + a4 + a5) * V% + b * W% + ( [c1]+ [c1a + c1b + c1c] + c2 + c3) * X% + (d1)* Y1%  + d2* Y2%+ d3 * Y3%+ d4* Y4% + d5 * Y5%+ d6* Y6% + e * Z%","(a1 + a2 + a3 + a4 + a5) * 70% + b * 70% + ( c1+ c2 + c3) * 70% + (d1) * 100% + (e) * 70%"]
["For Multiple funding rates:\n2) Enter the rates per category"]
["Cost categories","Rates","Total costs",null,"EU contribution"]
["A. Personnel costs",0.7,{"$f":"'4. Consolid table (participant)'!B16+'4. Consolid table (participant)'!C16+'4. Consolid table (participant)'!D16","v":0},null,{"$f":"C88*B88","v":0}]
["B. Subcontracting costs",0.7,{"$f":"'4. Consolid table (participant)'!G16","v":0},null,0]
["C1. Travel and subsistence",0.7,{"$f":"'4. Consolid table (participant)'!H16","v":0},null,0]
["C2. Equipment",0.7,{"$f":"'4. Consolid table (participant)'!L16","v":0},null,0]
["C3. Other goods, works and services ",0.7,{"$f":"'4. Consolid table (participant)'!M16","v":0},null,0]
["D.1. Financial support to third parties\n",1,{"$f":"'4. Consolid table (participant)'!N16","v":0},null,0]
[{"$f":"A15","v":"D.2 [Category name]"},1,{"$f":"'4. Consolid table (participant)'!O16","v":0},null,{"$f":"C94*B94","v":0}]
[{"$f":"A16","v":"D.3 [Category name]"},1,{"$f":"'4. Consolid table (participant)'!P16","v":0},null,0]
[{"$f":"A17","v":"D.4 [Category name]"},1,{"$f":"'4. Consolid table (participant)'!Q16","v":0},null,0]
[{"$f":"A18","v":"D.5 [Category name]"},1,{"$f":"'4. Consolid table (participant)'!R16","v":0},null,0]
[{"$f":"A19","v":"D.6 [Category name]"},1,{"$f":"'4. Consolid table (participant)'!S16","v":0},null,{"$f":"C98*B98","v":0}]
["E. Indirect costs",0.7,{"$f":"'4. Consolid table (participant)'!T16","v":0},null,0]
[null,null,{"$f":"SUM(C88:C99)","v":0},null,{"$f":"SUM(E88:E99)","v":0}]
[]
["Display for each category and type cost"]
["C.1. Travel and subsistence costs"]
["Actual costs"]
[null,"Costs \n(actual costs)"]
["1 [Travel short name]"]
["Speakers"]
["Travel costs  ",0]
["Accommodation costs ",0]
["Subsistence costs ",0]
["Personnel"]
["Travel costs  ",0]
["Accommodation costs ",0]
["Subsistence costs ",0]
["Participants"]
["Travel costs  ",0]
["Accommodation costs ",0]
["Subsistence costs ",0]
["Total travel costs",{"$f":"B108+B112+B116","v":0}]
["Total accommodation",{"$f":"B109+B113+B117","v":0}]
["Total subsistence",{"$f":"B110+B114+B118","v":0}]
["Total travel and subsistence",{"$f":"B119+B120+B121","v":0}]
["Unit or Actual costs"]
[null,"Costs \n(actual costs)","Costs (unit costs)"]
[null,null,"Amount per unit","Number of units ","Total\n(EUR)   "]
["1 [Travel short name]"]
["Speakers"]
["Travel costs  ",0,0,0,{"$f":"C128*D128","v":0}]
["Accommodation costs ",0,0,0,{"$f":"C129*D129","v":0}]
["Subsistence costs ",0,0,0,{"$f":"C130*D130","v":0}]
["Personnel"]
["Travel costs  ",0,0,0,{"$f":"C132*D132","v":0}]
["Accommodation costs ",0,0,0,{"$f":"C133*D133","v":0}]
["Subsistence costs ",0,0,0,{"$f":"C134*D134","v":0}]
["Participants"]
["Travel costs  ",0,0,0,{"$f":"C136*D136","v":0}]
["Accommodation costs ",0,0,0,{"$f":"C137*D137","v":0}]
["Subsistence costs ",0,0,0,{"$f":"C138*D138","v":0}]
["Total travel costs",{"$f":"B128+B132+B136+E128+E132+E136","v":0}]
["Total accommodation",{"$f":"E129+E133+E137+B129+B133+B137","v":0}]
["Total subsistence",{"$f":"E130+E134+E138+B130+B134+B138","v":0}]
["Total travel and subsistence",{"$f":"B139+B140+B141","v":0}]
[]
["D.1. Financial support to third parties"]
["Actual costs"]
["Financial support to third parties","Costs\n(actual costs)"]
[]
["1 [Support scheme short name]",0]
["1 [Support scheme short name]",0]
["Total financial support 1  ",{"$f":"B149+B148","v":0}]
["Unit costs"]
["Financial support to third parties",null,"Costs (unit costs)"]
[null,null,"Amount per unit","Number of units","Total \n(EUR)  "]
["1 [Support scheme short name]"]
["[divide scheme in parts if there are different subschemes or different unit costs, e.g. unit cost per host country) ",null,0,0,{"$f":"C155*D155","v":0}]
["Total financial support 1  ",null,null,null,{"$f":"SUM(E154:E155)","v":0}]
["2 [Support scheme short name]"]
["[divide scheme in parts if there are different subschemes or different unit costs, e.g. unit cost per host country) ",null,0,0,{"$f":"C158*D158","v":0}]
["Total financial support 2  ",null,null,null,{"$f":"SUM(E157:E158)","v":0}]
["Actual and Unit costs"]
["Financial support to third parties","Costs\n(actual costs)","Costs (unit costs)"]
[null,null,"Amount per unit","Number of units","Total \n(EUR)  "]
["1 [Support scheme short name]"]
["[divide scheme in parts if there are different subschemes or different unit costs, e.g. unit cost per host country) ",0,0,0,{"$f":"C164*D164","v":0}]
["Total financial support 1  ",null,null,null,{"$f":"SUM(E163:E164)","v":0}]
["2 [Support scheme short name]"]
["[divide scheme in parts if there are different subschemes or different unit costs, e.g. unit cost per host country) ",0,0,0,{"$f":"C167*D167","v":0}]
["Total financial support  2  ",null,null,null,{"$f":"SUM(E166:E167)","v":0}]
[]
["D.2.; D.3.; D.4.; D.5.[category name] "]
["Actual costs or Lump sum"]
["D.2.; D.3.; D.4.; D.5.;D.6 [category name] ","Costs\n(actual costs or lump sum)"]
[]
["[Category name]",0]
["Total other cost category for this WP",{"$f":"B174","v":0}]
["Unit costs"]
["D.2.; D.3.; D.4.; D.5.;D.6 [category name] ",null,"Costs (unit costs)"]
[null,null,"Amount per unit","Number of units","Total\n(EUR)"]
["[Category name]",null,0,0,{"$f":"C179*D179","v":0}]
["Total other cost category for this WP",null,null,null,{"$f":"SUM(G179:G179)","v":0}]

{"sheet":"EC Format","index":2,"n_rows":178,"n_cols":23,"rows_kept":178,"cut":false,"hidden":false,"merged":[[166,0,166,1],[168,1,169,1],[168,2,169,2],[168,7,169,7],[168,8,169,8],[172,1,173,1],[172,3,172,5],[172,7,173,7],[172,8,173,8],[128,1,129,1],[128,2,129,2],[152,7,153,7],[152,8,153,8],[142,3,142,5],[136,0,136,1],[138,1,139,1],[138,2,139,2],[138,7,139,7],[138,8,139,8],[132,1,133,1],[132,7,133,7],[132,8,133,8],[132,3,132,5],[128,7,129,7],[128,8,129,8],[156,0,156,1],[162,1,163,1],[162,7,163,7],[162,8,163,8],[158,1,159,1],[158,2,159,2],[158,7,159,7],[158,8,159,8],[101,6,103,6],[101,7,103,7],[101,8,103,8],[148,2,149,2],[102,3,103,3],[101,3,101,5],[148,7,149,7],[148,8,149,8],[121,6,121,8],[126,0,126,1],[115,1,115,4],[116,3,116,5],[116,6,118,6],[142,1,143,1],[142,7,143,7],[142,8,143,8],[121,3,121,4],[124,3,124,4],[106,6,106,8],[107,3,107,5],[107,6,109,6],[107,7,109,7],[107,8,109,8],[108,3,109,3],[108,4,109,4],[108,5,109,5],[115,6,115,8],[112,6,112,8],[113,2,113,8],[117,3,118,3],[117,4,118,4],[117,5,118,5],[116,7,118,7],[85,3,86,6],[75,8,77,8],[75,2,75,6],[80,3,80,5],[77,3,77,4],[76,3,76,4],[66,2,68,2],[65,8,69,8],[65,7,69,7],[66,3,68,3],[66,4,68,4],[75,7,77,7],[85,8,86,8],[85,7,86,7],[65,2,65,6],[64,2,64,8],[57,6,57,8],[58,6,58,8],[59,6,59,8],[61,6,61,8],[65,1,69,1],[66,6,68,6],[72,3,72,5],[66,5,68,5],[50,6,51,6],[54,6,55,6],[45,6,45,8],[49,6,49,8],[53,6,53,8],[46,6,47,6],[42,0,42,8],[25,1,25,8],[27,1,27,4],[27,6,27,8],[0,0,0,8],[36,0,36,8],[30,0,30,8],[15,1,15,4],[16,1,16,8],[19,1,19,8],[28,6,28,8],[21,6,21,8],[18,6,18,8],[15,6,15,8],[8,6,8,8],[5,1,5,8],[32,3,32,6],[2,1,2,3],[9,1,9,5],[8,1,8,4],[12,1,12,8],[21,1,21,4],[18,1,18,4],[28,1,28,4],[22,1,22,8],[24,1,24,4],[24,6,24,8],[34,3,34,8],[176,0,176,8],[73,1,73,5],[75,1,77,1],[82,1,82,5],[81,1,81,5],[85,0,86,1],[78,3,78,4],[79,3,79,4],[97,0,97,1],[74,2,74,8],[97,3,97,8],[85,2,86,2],[124,6,124,8],[98,0,98,8],[110,2,110,8],[112,1,112,4],[146,0,146,1],[152,1,153,1],[152,3,152,5],[148,1,149,1],[116,8,118,8],[102,4,103,4],[102,5,103,5],[162,3,162,5]]}
["A. Personnel costs ",null,null,null,null,null,null,null,null,"Row to add/delete\n& Height row","Number to 0","Text to blank","Row to hide"]
["WORK PACKAGE 1 ",null,null,null,null,null,null,null,null,"F-18"]
[null,"A.1 Employees (or equivalent)",null,null,null,null,null,null,null,"F-18",null,null,"Shown"]
[null,"Select a staff category","monthly",0,0,{"$f":"E4*D4","v":0},null,null,null,"Last","4#5","8#9","Shown"]
[null,"Select a staff category","monthly",0,0,{"$f":"E5*D5","v":0},null,null,null,"Authorised","4#5","8#9","Shown"]
[null,"Other ",null,null,null,null,null,null,null,"F-18",null,null,"Shown"]
[null,"[category 1]","monthly",0,0,{"$f":"E7*D7","v":0},null,null,null,"Last","4#5","8#9","Shown"]
[null,"[category 2]","monthly",0,0,{"$f":"E8*D8","v":0},null,null,null,"Authorised","4#5","8#9","Shown"]
[null,"Total employees (or equivalent)",null,null,null,{"$f":"SUM(F3:F8)","v":0},null,null,null,"F-18",null,null,"Shown"]
[null,"A.2 + A.3 Natural persons under direct contract and seconded persons ",null,null,null,null,null,null,null,"F-18",null,null,"Shown"]
[null,"Select a staff category","monthly",0,0,{"$f":"D11*E11","v":0},null,null,null,"Last","4#5","8#9","Shown"]
[null,"Select a staff category","monthly",0,0,{"$f":"D12*E12","v":0},null,null,null,"Authorised","4#5","8#9","Shown"]
[null,"Other ",null,null,null,null,null,null,null,"F-18",null,null,"Shown"]
[null,"[category 1]","monthly",0,0,{"$f":"D14*E14","v":0},null,null,null,"Last","4#5","8#9","Shown"]
[null,"[category 2]","monthly",0,0,{"$f":"D15*E15","v":0},null,null,null,"Authorised","4#5","8#9","Shown"]
[null,"Total natural persons under direct contract and seconded persons",null,null,null,{"$f":"SUM(F10:F15)","v":0},null,null,null,"F-18",null,null,"Shown"]
[null,"A.4 SME owners and natural person beneficiaries without salary",null,null,null,null,null,null,null,"F-18",null,null,"Shown"]
[null,"SME owners/natural person beneficiaries without salary","daily",0,0,{"$f":"D18*E18","v":0},null,null,null,"Last","4#5","8#9","Shown"]
[null,"Total SME owners and natural person beneficiaries without salary",null,null,null,{"$f":"SUM(F17:F18)","v":0},null,null,null,"F-18",null,null,"Shown"]
[null,"A.5 Volunteers",null,null,null,null,null,null,null,"F-18",null,null,"Hidden"]
[null,"Volunteers","daily",0,0,{"$f":"D21*E21","v":0},null,null,null,"Last","4#5","8#9","Hidden"]
[null,"Total Volunteers",null,null,null,{"$f":"SUM(F20:F21)","v":0},null,null,null,"F-18",null,null,"Hidden"]
[null,"A.6 [Category name]",null,null,null,null,null,null,null,"F-18",null,null,"Hidden"]
[null,"Other personnel costs A.6","Select a type of rate",0,0,{"$f":"D24*E24","v":0},null,null,null,"Last","4#5","8#9","Hidden"]
[null,"Total other personnel costs A.6",null,null,null,{"$f":"SUM(F23:F24)","v":0},null,null,null,"F-18",null,null,"Hidden"]
[null,"A.7 [Category name]",null,null,null,null,null,null,null,"F-18",null,null,"Hidden"]
[null,"Other personnel costs A.7","Select a type of rate",0,0,{"$f":"D27*E27","v":0},null,null,null,"Last","4#5","8#9","Hidden"]
[null,"Total other personnel costs A.7",null,null,null,{"$f":"SUM(F26:F27)","v":0},null,null,null,"F-18",null,null,"Hidden"]
[null,"Total personnel for this WP",null,null,null,{"$f":"F16+F9+F19+F22+F25+F28","v":0},null,null,null,"F-18"]
[]
["B. Subcontracting costs"]
["WORK PACKAGE 1",null,null,null,null,null,null,null,null,"F-18"]
[null,"1 [Subcontract short name]",0,null,null,null,null,null,null,"Last","3","2#8#9"]
[null,"2 [Subcontract short name]",0,null,null,null,null,null,null,"Authorised","3","2#8#9"]
[null,"Total subcontracting for this WP",{"$f":"SUM(C32:C34)","v":0},null,null,null,null,null,null,"F-18"]
[]
["C. Purchase costs"]
["WORK PACKAGE 1 "]
[null,"Total travel costs for this WP",0,null,null,null,null,null,null,"F-18",null,null,"Shown"]
[null,"Total accommodation costs for this WP",0,null,null,null,null,null,null,"F-18",null,null,"Shown"]
[null,"Total subsistence costs  for this WP",0,null,null,null,null,null,null,"F-18",null,null,"Shown"]
[null,"Total travel for this WP",{"$f":"C39+C40+C41","v":0},null,null,0,null,null,null,"F-18"]
["C.1. Travel and subsistence"]
["WORK PACKAGE 1 ",null,null,null,null,null,null,null,null,"F-18"]
[null,"1 [Travel short name]",null,null,null,null,null,null,null,"F-18"]
[null,"Speakers",null,null,null,null,null,null,null,"F-18"]
[null,"Travel costs  ",0,0,0,{"$f":"D47*E47","v":0},null,null,null,"F-18"]
[null,"Accommodation costs ",0,0,0,{"$f":"D48*E48","v":0},null,null,null,"F-18"]
[null,"Subsistence costs ",0,0,0,{"$f":"D49*E49","v":0},null,null,null,"F-18"]
[null,"Personnel",null,null,null,null,null,null,null,"F-18"]
[null,"Travel costs  ",0,0,0,{"$f":"D51*E51","v":0},null,null,null,"F-18"]
[null,"Accommodation costs ",0,0,0,{"$f":"D52*E52","v":0},null,null,null,"F-18"]
[null,"Subsistence costs ",0,0,0,{"$f":"D53*E53","v":0},null,null,null,"F-18"]
[null,"Participants",null,null,null,null,null,null,null,"F-18"]
[null,"Travel costs  ",0,0,0,{"$f":"D55*E55","v":0},null,null,null,"F-18"]
[null,"Accommodation costs ",0,0,0,{"$f":"D56*E56","v":0},null,null,null,"F-18"]
[null,"Subsistence costs ",0,0,0,{"$f":"D57*E57","v":0},null,null,null,"F-18"]
[null,"Total travel costs for this travel",{"$f":"C47+C51+C55+F47+F51+F55","v":0},null,null,null,null,null,null,"F-18",null,null,"Shown"]
[null,"Total accommodation costs for this travel",{"$f":"F48+F52+F56+C48+C52+C56","v":0},null,null,null,null,null,null,"F-18",null,null,"Shown"]
[null,"Total subsistence costs for this travel",{"$f":"F49+F53+F57+C49+C53+C57","v":0},null,null,null,null,null,null,"F-18",null,null,"Shown"]
[null,"Total travel",{"$f":"C58+C59+C60","v":0},null,null,null,null,null,null,"F-18"]
[null,"Total travel for this WP",0,null,null,0,null,null,null,"F-18"]
["C.2. Equipment",null,null,null,null,null,null,null,null,"F-18"]
["WORK PACKAGE 1",null,null,null,null,null,null,null,null,"F-18"]
[null,"C.2.1 Purchase (depreciation/full cost) ",null,null,null,null,null,null,null,"F-18"]
[null,null,"Costs (actual costs)",null,null,null,null,"Also part of other work packages? YES/NO and which WP","Description of tasks/activities for which the equipment is needed"]
[null,null,"Price","Depreciation method (e.g. 36 month or 60 month)","Number of months  allocated to the action","Rate of use for the action (100% or less if used also for other purposes)","Total\n(EUR) "]
[]
[]
[null,null,"a","b ","c ","d ","e =(c/b *d) * a"]
[null,"1 [Equipment short name]",0,0,0,0,{"$f":"IF(D71=0,0,((E71/D71)*F71)*C71)","v":0},null,null,"Last","3#4#5#6","2#8#9"]
[null,"2 [Equipment short name]",0,0,0,0,{"$f":"IF(D72=0,0,((E72/D72)*F72)*C72)","v":0},null,null,"Authorised","3#4#5#6","2#8#9"]
[null,"3 [Equipment short name]",0,"ATTENTION! Can be used only if full cost option in the grant agreement",null,null,{"$f":"C73","v":0},null,null,"Last","3","2#8#9","HR"]
[null,"Total depreciation  ",null,null,null,null,{"$f":"SUM(G70:G73)","v":0},null,null,"F-18"]
[null,"C.2.2 Rental and leasing (rate of use/full cost)",null,null,null,null,null,null,null,"F-18"]
[null,null,"Costs (actual costs)",null,null,null,null,"Also part of other work packages? YES/NO and which WP","Description of tasks/activities for which the equipment is needed"]
[null,null,"Monthly rent/fee ","Number of months   of  use  for the action",null,"Rate of use for the action (100% or less if used also for other purposes)","Total\n(EUR) "]
[null,null,"a","b",null,"c ","d= a*b*c"]
[null,"1 [Equipment short name]",0,0,null,0,{"$f":"C79*D79*F79","v":0},null,null,"Last","3#4#5#6","2#8#9"]
[null,"2 [Equipment short name]",0,0,null,0,{"$f":"C80*D80*F80","v":0},null,null,"Authorised","3#4#5#6","2#8#9"]
[null,"3 [Equipment short name]",0,"ATTENTION! Can be used only if full cost option in the grant agreement",null,null,{"$f":"C81","v":0},null,null,"Last","3","2#8#9"]
[null,"Total rental and leasing",null,null,null,null,{"$f":"SUM(G78:G81)","v":0},null,null,"F-18"]
[null,"Total equipment for this WP",null,null,null,null,{"$f":"G82+G74","v":0},null,null,"F-18"]
["C.3. Other goods, works and services",null,null,null,null,null,null,null,null,"F-18"]
["WORK PACKAGE 1",null,null,null,null,null,null,null,null,"F-18"]
[null,null,"Costs\n(actual costs)\n",null,null,null,null,"Also part of other work packages? YES/NO and which WP","Description of tasks/activities for which the goods/services are needed; types of goods services needed; how much"]
[null,null,null,null,null,null,null,null,null,"F-18"]
[null,"Consumables",0,null,null,null,null,null,null,"F-18"]
[null,"Conferences, seminars, workshops, trainings & events",0,null,null,null,null,null,null,"F-18"]
[null,"Information & publications",0,null,null,null,null,null,null,"F-18"]
[null,"Other expenses",null,null,null,null,null,null,null,"F-18"]
[null,"1 IPR costs",0,null,null,null,null,null,null,"F-18"]
[null,"2 Bank fees (pre-financing guarantee)",0,null,null,null,null,null,null,"F-18"]
[null,"3 Audit fees (CFS)",0,null,null,null,null,null,null,"F-18"]
[null,"4 Project evaluation ",0,null,null,null,null,null,null,"F-18"]
[null,"[5 short name other]",0,null,null,null,null,null,null,"Last","3","2#8#9"]
[null,"[6 short name other]",0,null,null,null,null,null,null,"Authorised","3","2#8#9"]
["Total goods, works and services for this WP",null,{"$f":"SUM(C88:C97)","v":0},null,null,null,null,null,null,"F-18"]
["D. Other cost categories"]
["D.1. Financial support to third parties",null,null,null,null,null,null,null,null,"F-18",null,null,"Hidden"]
["WORK PACKAGE 1",null,null,null,null,null,null,null,null,"F-18",null,null,"Hidden"]
[null,null,null,null,null,null,null,"Also used  for other work packages?  \nYES/NO and which WP","Description of support scheme (estimated number of recipients; maximum amount per recipient)","F-18",null,null,"Hidden"]
[null,"Financial support to third parties ","Costs \n(actual costs)",null,null,null,null,null,null,"F-18",null,null,"Hidden"]
[null,null,null,null,null,null,null,null,null,"F-18",null,null,"Hidden"]
[null,"[Support scheme short name]",0,null,null,null,null,null,null,"F-18",null,null,"Hidden"]
[null,"[Support scheme short name]",0,null,null,null,null,null,null,"Last","3","2#8#9","Hidden"]
[null,null,{"$f":"SUM(C104:C106)","v":0},null,null,null,null,null,null,"F-18",null,null,"Hidden"]
[null,null,null,"Costs  (unit costs)",null,null,null,null,null,"F-18",null,null,"Hidden"]
[null,"Financial support to third parties ","Actual costs","Amount per unit","Number of units","Total",null,null,null,"F-18",null,null,"Hidden"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Hidden"]
[null,"1 [Support scheme short name]",null,null,null,null,null,null,null,"F-18",null,null,"Hidden"]
[null,"[divide scheme in parts if there are different subschemes or different unit costs, e.g. unit cost per host country) ",null,0,0,{"$f":"D112*E112","v":0},null,null,null,"Last","4#5","7#8#9","Hidden"]
[null,"Total financial support 1  ",null,null,null,{"$f":"SUM(F111:F112)","v":0},null,null,null,"F-18",null,null,"Hidden"]
[null,"2 [Support scheme short name]",null,null,null,null,null,null,null,"F-18",null,null,"Hidden"]
[null,"[divide scheme in parts if there are different subschemes or different unit costs, e.g. unit cost per host country) ",null,0,0,{"$f":"D115*E115","v":0},null,null,null,"Last","4#5","7#8#9","Hidden"]
[null,"Total financial support 2  ",null,null,null,{"$f":"SUM(F114:F115)","v":0},null,null,null,"F-18",null,null,"Hidden"]
[null,null,null,"Costs  (unit cost)",null,null,null,null,null,"F-18",null,null,"Hidden"]
[null,"Financial support to third parties ","Costs\n(actual costs)","Amount per unit","Number of units","Total",null,null,null,"F-18",null,null,"Hidden"]
[null,null,null,null,null,null,null,null,null,"F-18",null,null,"Hidden"]
[null,"1 [Support scheme short name]",null,null,null,null,null,null,null,"F-18",null,null,"Hidden"]
[null,"[divide scheme in parts if there are different subschemes or different unit costs, e.g. unit cost per host country) ",0,0,0,{"$f":"D121*E121","v":0},null,null,null,"Last","3#4#5","2#8#9","Hidden"]
[null,null,{"$f":"SUM(C120:C121)","v":0},"Total financial support 1  ",null,{"$f":"SUM(F120:F121)+C122","v":0},null,null,null,"F-18",null,null,"Hidden"]
[null,"2 [Support scheme short name]",null,null,null,null,null,null,null,"F-18",null,null,"Hidden"]
[null,"[divide scheme in parts if there are different subschemes or different unit costs, e.g. unit cost per host country) ",0,0,0,{"$f":"D124*E124","v":0},null,null,null,"Last","3#4#5","2#8#9","Hidden"]
[null,null,{"$f":"SUM(C123:C124)","v":0},"Total financial support 2  ",null,{"$f":"SUM(F123:F124)+C125","v":0},null,null,null,"F-18",null,null,"Hidden"]
[null,"Total other cost category D.1 for this WP",{"$f":"C107+F113+F116+F122+F125","v":0},null,null,null,null,null,null,"F-18",null,null,"Hidden"]
[{"$f":"'EC Data'!A15","v":"D.2 [Category name]"},null,null,null,null,null,null,null,null,"F-18",null,null,"Hidden"]
["WORK PACKAGE 1",null,null,null,null,null,null,null,null,"F-18",null,null,"Hidden"]
[null,null,"Costs\n(actual costs)",null,null,null,null,"Also used  for other work packages?  \nYES/NO and which WP","Description of the tasks/activities","F-18",null,null,"Hidden"]
[null,null,null,null,null,null,null,null,null,"F-18",null,null,"Hidden"]
[null,"Other cost category D.2",0,null,null,null,null,null,null,"F-18","3","2#8#9","Hidden"]
[null,null,{"$f":"SUM(C129:C131)","v":0},null,null,null,null,null,null,"F-18",null,null,"Hidden"]
[null,null,null,"Costs  (unit costs)",null,null,null,"Also used  for other work packages?  YES/NO and which WP","Description of the tasks/activities","F-18",null,null,"Hidden"]
[null,null,null,"Amount per unit","Number of units","Total  (EUR) ",null,null,null,"F-18",null,null,"Hidden"]
[null,"Other cost category D.2",null,0,0,{"$f":"D135*E135","v":0},null,null,null,"F-18","4#5","7#8#9","Hidden"]
[null,"Total other cost category D.2 for this WP",{"$f":"C132+F136","v":0},null,null,{"$f":"SUM(F134:F135)","v":0},null,null,null,"F-18",null,null,"Hidden"]
[{"$f":"'EC Data'!A16","v":"D.3 [Category name]"},null,null,null,null,null,null,null,null,"F-18",null,null,"Shown"]
["WORK PACKAGE 1",null,null,null,null,null,null,null,null,"F-18",null,null,"Hidden"]
[null,null,"Costs\n(actual costs)",null,null,null,null,"Also used  for other work packages?  \nYES/NO and which WP","Description of the tasks/activities","F-18",null,null,"Hidden"]
[null,null,null,null,null,null,null,null,null,"F-18",null,null,"Hidden"]
[null,"Other cost category D.3",0,null,null,null,null,null,null,"F-18","3","2#8#9","Hidden"]
[null,null,{"$f":"SUM(C139:C141)","v":0},null,null,null,null,null,null,"F-18",null,null,"Hidden"]
[null,null,null,"Costs  (unit costs)",null,null,null,"Also used  for other work packages?  YES/NO and which WP","Description of the tasks/activities","F-18",null,null,"Hidden"]
[null,null,null,"Amount per unit","Number of units","Total  (EUR) ",null,null,null,"F-18",null,null,"Hidden"]
[null,"Other cost category D.3",null,0,0,{"$f":"D145*E145","v":0},null,null,null,"F-18","4#5","7#8#9","Hidden"]
[null,"Total other cost category D.3 for this WP",{"$f":"C142+F146","v":0},null,null,{"$f":"SUM(F144:F145)","v":0},null,null,null,"F-18",null,null,"Hidden"]
[{"$f":"'EC Data'!A17","v":"D.4 [Category name]"},null,null,null,null,null,null,null,null,"F-18",null,null,"Shown"]
["WORK PACKAGE 1",null,null,null,null,null,null,null,null,"F-18",null,null,"Hidden"]
[null,null,"Costs\n(actual costs)",null,null,null,null,"Also used  for other work packages?  \nYES/NO and which WP","Description of the tasks/activities","F-18",null,null,"Hidden"]
[null,null,null,null,null,null,null,null,null,"F-18",null,null,"Hidden"]
[null,"Other cost category D.4",0,null,null,null,null,null,null,"F-18","3","2#8#9","Hidden"]
[null,null,{"$f":"SUM(C149:C151)","v":0},null,null,null,null,null,null,"F-18",null,null,"Hidden"]
[null,null,null,"Costs  (unit cost)",null,null,null,"Also used  for other work packages?  YES/NO and which WP","Description of the tasks/activities","F-18",null,null,"Hidden"]
[null,null,null,"Amount per unit","Number of units","Total  (EUR) ",null,null,null,"F-18",null,null,"Hidden"]
[null,"Other cost category D.4",null,0,0,{"$f":"D155*E155","v":0},null,null,null,"F-18","4#5","7#8#9","Hidden"]
[null,"Total other cost category D.4 for this WP",{"$f":"C152+F156","v":0},null,null,{"$f":"SUM(F154:F155)","v":0},null,null,null,"F-18",null,null,"Hidden"]
[{"$f":"'EC Data'!A18","v":"D.5 [Category name]"},null,null,null,null,null,null,null,null,"F-18",null,null,"Shown"]
["WORK PACKAGE 1",null,null,null,null,null,null,null,null,"F-18",null,null,"Hidden"]
[null,null,"Costs \n(actual costs)",null,null,null,null,"Also used  for other work packages?  \nYES/NO and which WP","Description of the tasks/activities","F-18",null,null,"Hidden"]
[null,null,null,null,null,null,null,null,null,"F-18",null,null,"Hidden"]
[null,"Other cost category D.5",0,null,null,null,null,null,null,"F-18","3","2#8#9","Hidden"]
[null,null,{"$f":"SUM(C159:C161)","v":0},null,null,null,null,null,null,"F-18",null,null,"Hidden"]
[null,null,null,"Costs  (unit costs)",null,null,null,"Also used  for other work packages?  YES/NO and which WP","Description of the tasks/activities","F-18",null,null,"Hidden"]
[null,null,null,"Amount per unit","Number of units","Total  (EUR) ",null,null,null,"F-18",null,null,"Hidden"]
[null,"Other cost category D.5",null,0,0,{"$f":"D165*E165","v":0},null,null,null,"F-18","4#5","7#8#9","Hidden"]
[null,"Total other cost category D.5 for this WP",{"$f":"C162+F166","v":0},null,null,{"$f":"SUM(F164:F165)","v":0},null,null,null,"F-18",null,null,"Hidden"]
[{"$f":"'EC Data'!A19","v":"D.6 [Category name]"},null,null,null,null,null,null,null,null,"F-18",null,null,"Hidden"]
["WORK PACKAGE 1",null,null,null,null,null,null,null,null,"F-18",null,null,"Hidden"]
[null,null,"Costs \n(actual costs)",null,null,null,null,"Also used  for other work packages?  \nYES/NO and which WP","Description of the tasks/activities","F-18",null,null,"Hidden"]
[null,null,null,null,null,null,null,null,null,"F-18",null,null,"Hidden"]
[null,"Other cost category D.6",0,null,null,null,null,null,null,"Last","3","2#8#9","Hidden"]
[null,null,{"$f":"SUM(C169:C171)","v":0},null,null,null,null,null,null,null,null,null,"Hidden"]
[null,null,null,"Costs  (unit costs)",null,null,null,"Also used  for other work packages?  YES/NO and which WP","Description of the tasks/activities","F-18",null,null,"Hidden"]
[null,null,null,"Amount per unit","Number of units","Total  (EUR) ",null,null,null,"F-18",null,null,"Hidden"]
[null,"Other cost category D.6",null,0,0,{"$f":"D175*E175","v":0},null,null,null,"Last","4#5","7#8#9","Hidden"]
[null,"Total other cost category D.6 for this WP",{"$f":"C172+F176","v":0},null,null,{"$f":"SUM(F174:F175)","v":0},null,null,null,"F-18",null,null,"Hidden"]
["Consolidated table"]
[null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,"Shown"]

{"sheet":"1. Instructions","index":3,"n_rows":45,"n_cols":1,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
["INSTRUCTIONS (DETAILED BUDGET TABLE (AG) — PROPOSAL/GRANT PREPARATION)"]
[]
["General"]
["The file is composed of 5 sheets (Instructions, Start, Detailed table, Consolidated table (participant) and Consolidated table (project)) which must be used to create your Detailed budget table."]
["Depending on the instructions in the call document, you should submit the budget table either as part of your proposal and/or during grant preparation: \n- for proposal: download, fill in, merge, scan and upload it as a single xlsx for the project (Funding & Tenders Portal Submission System; only sheets 3, 4, and 5 needed; for sheets 3 and 4: one per beneficiary/affiliated entity merged into single xlsx) \n- for grant preparation: update original xlsm file (if needed), merge, scan and upload it as a single PDF for the project (Portal Grant Preparation tool).\n\nATTENTION! For security reasons, the document can NOT be uploaded as excel with macros (xlsm). Once filled in and finalised, it must therefore be saved as xlsx/pdf copy, and this copy must be used for the upload. For conversion into PDF, more details are available in the Online Manual."]
["The budget table is broken down by cost category and work packages. For technical reasons, the number of work packages has to be the same in all categories. Please leave them empty, if there are no costs. "]
[]
[]
[]
[]
[]
[]
[]
[]
["The budgeted amounts should be based on detailed, reasonable and accurate estimates. Keep sufficient documentation to be able to explain them if requested."]
["Please take care to insert only costs that are eligible under the EU grant agreement (see eligibility article). All estimated costs must be entered in EUR."]
["You will be asked to fill in a similar table later on for the cost reporting before payments (Funding & Tenders Portal Grant Management Periodic Reporting tool).\nContrary to this table, the cost reporting table should however NOT contain the estimated costs, but the really incurred costs."]
[]
["Getting started"]
["To use the file, the Excel Macro security settings must be enabled on your computer. This is managed and checked when opening the file, but contact your IT support if you encounter problems."]
["Download the file: Before downloading close all other excel files (open excel files may hamper the macros). Download the file from the Portal using EDIT WORKBOOK - EDIT IN EXCEL - SAVE AS to save a copy on your desktop. Then close the document and re-open it.  "]
["Please complete the sheets in their order (Start - Detailed budget table - Consolidated table (participant) - Consolidated table (project))."]
["ATTENTION! White cells mean that you are required to enter data. Blue cells are calculated automatically."]
[]
["Start sheet"]
["Use this sheet to define the generic data (project/participant name and PIC), the work packages (number and names) and the number of travels. This information will be automatically copied into the other sheets."]
["Provide a short name, a description for the work package and confirm the number of travels linked to it."]
["To add a work package, click on 'Add a new WP', enter the name and description (name in ALL CAPITALS) and click on 'Update Detailed Budget Table'.\n\n"]
["To delete a work package, tick the check box and click on 'Update Detailed Budget Table'."]
["Travels can be increased or decreased by changing the number and clicking on 'Update detailed budget table'."]
["Attention! If you delete work packages or travels on the start sheet AFTER having already started working on the other sheets:\n - the work package and all costs will be automatically deleted\n - the travel and all costs will be deleted (from the bottom to the top - the last travel will be deleted first)."]
[]
["Detailed table sheet"]
["Use this sheet to enter the budget for each cost category and work package. "]
["New lines can be added only when column B is white.  Select the cell B on the line that should be added, and click on 'Add new line'. Lines can also be deleted again (except the first one).\n\n\n\n\n\n\n\n\n\n\n"]
["Sub-totals and totals are calculated automatically."]
[]
["Consolidated table (participant) sheet"]
["This sheet shows your budget overview, per work package and cost category. It is calculated automatically. "]
[]
["Consolidated table (project) sheet"]
["This sheet shows the budget overview for the project, per beneficiary, work package and cost category. It needs to be assembled manually by the coordinator on the basis of the detailed budget tables/consolidated budget tables filled out by the participants. "]
[]
["Unprotect sheets"]
["If case of absolute necessity, you can unprotect the sheets via the button below. Pay attention to not delete formula or change the configuration of the file. All lines or columns are needed for the macros. Please be aware that any changes done by you, will be under your own responsibility and at your own risk."]

{"sheet":"2. Start","index":4,"n_rows":16,"n_cols":5,"rows_kept":16,"cut":false,"hidden":false,"merged":[[11,0,14,4],[1,0,1,3],[0,0,0,4],[3,0,3,1],[4,0,4,1],[5,0,5,1],[3,3,6,4],[2,0,2,4],[10,0,10,4],[6,0,6,1]]}
["START (DETAILED BUDGET TABLE (AG) — PROPOSAL/GRANT PREPARATION)"]
[]
["PROJECT DATA"]
["Project number:"]
["Project acronym:"]
["Participant short name:"]
["Participant PIC:"]
[]
[]
[]
["WORK PACKAGES & TRAVELS"]
[]
[]
[]
[]
["Index","Name","Description","Number of travels","Delete"]

{"sheet":"3. Detailed table ","index":5,"n_rows":120,"n_cols":13,"rows_kept":120,"cut":false,"hidden":false,"merged":[[37,7,37,8],[41,3,41,8],[38,0,38,5],[40,0,40,8],[38,7,38,8],[58,1,58,4],[54,1,54,4],[44,2,44,3],[50,1,50,4],[45,2,45,4],[86,0,86,8],[62,1,62,4],[79,7,80,7],[83,4,83,6],[79,8,80,8],[66,1,66,4],[70,1,70,4],[71,1,71,4],[74,0,76,0],[79,2,79,4],[82,2,82,3],[72,0,72,1],[75,3,75,8],[116,3,116,8],[88,3,88,8],[116,0,116,1],[88,0,88,1],[100,3,100,8],[101,3,101,8],[101,0,101,1],[99,3,99,7],[98,0,98,1],[104,0,104,1],[110,0,110,1],[91,1,91,4],[90,3,90,5],[93,3,93,8],[26,1,26,4],[23,2,24,2],[23,0,24,1],[17,7,19,7],[15,0,15,8],[17,2,17,5],[17,6,19,6],[16,0,16,1],[17,8,19,8],[23,7,24,7],[17,0,19,1],[18,2,19,2],[22,0,22,1],[23,8,24,8],[23,3,24,6],[29,6,30,6],[29,8,30,8],[35,1,35,4],[29,3,29,5],[29,0,30,1],[29,7,30,7],[32,3,32,4],[33,3,33,4],[34,3,34,4],[31,6,31,8],[14,0,14,8],[16,2,16,8],[21,0,21,4],[0,0,0,8],[2,0,2,8],[4,4,4,5],[4,6,4,7],[12,0,12,8],[6,7,6,8],[6,4,6,6],[11,0,11,8],[9,0,9,8],[10,0,10,8]]}
["a",null,null,null,null,null,null,null,null,"Row to add/delete\n& Height row","Number to 0","Text to blank","Row to hide"]
[]
["DETAILED BUDGET TABLE (ACTION GRANTS)",null,null,null,null,null,null,null,null,"F-28"]
[]
["Project number:",{"$f":"IF(ISBLANK('2. Start'!C4),\" \",'2. Start'!C4)","v":" "},null,null,null,null,null,null,"2022-12-19T23:36:20","F-18"]
["Project acronym:",{"$f":"IF(ISBLANK('2. Start'!C5),\" \",'2. Start'!C5)","v":" "},null,null,null,null,null,null,null,"F-18"]
["Participant short name:",{"$f":"IF(ISBLANK('2. Start'!C6),\" \",'2. Start'!C6)","v":" "},null,null,null,null,null,null,null,"F-18"]
["Participant PIC:",{"$f":"IF(ISBLANK('2. Start'!C7),\" \",'2. Start'!C7)","v":" "},null,null,null,null,null,null,null,"F-18"]
[]
["ATTENTION: This  table should be  filled out one per participant (beneficiary, affiliated entity)",null,null,null,null,null,null,null,null,"F-18"]
["ATTENTION: This  table may  ONLY contain eligible costs (i.e. costs that comply with the eligibility rules of the grant agreement that is part of your call documents). At proposal stage and during grant preparation, it should contain estimated costs/income. Costs must be estimated in EUR.",null,null,null,null,null,null,null,null,"F-18"]
["ATTENTION! List each budgeted cost item ONLY once in this table, for the main WP.",null,null,null,null,null,null,null,null,"F-18"]
["ATTENTION! White cells mean that you are required to enter data. Blue cells are calculated automatically.",null,null,null,null,null,null,null,null,"F-18"]
[]
["ACTION GRANT BUDGET TABLE (PER PARTICIPANT)",null,null,null,null,null,null,null,null,"F-28"]
["PROJECT COSTS ",null,null,null,null,null,null,null,null,"F-28"]
["A. Personnel costs",null,null,null,null,null,null,null,null,"F-24"]
["! monthly rates allowed for budgeting because simpler to establish the approximate costs; cost reporting will have to be done according to MGA (usually daily rates)",null,"Costs  (actual or unit costs)",null,null,null,null,"Also working for other work packages?    YES/NO and which WP","Description of project role/activities/responsibilities  "]
[null,null,"Type of rate \n(monthly/other)","Rate\n(amount)","Time\n(months/other of work on the action)","Total \n(EUR)",null,null,null,"F-28"]
[null,null,null,"a","b","c = a * b",null,null,null,"F-24"]
[]
["Total personnel (all WPs)",null,null,null,null,0,null,null,null,"F-24"]
["B. Subcontracting costs",null,null,null,null,null,null,null,null,"F-24"]
[null,null,"Costs \n(actual costs)",null,null,null,null,"Also used  for other work packages? \nYES/NO and which WP","Description of subcontracted project tasks/activities"]
[null,null,null,null,null,null,null,null,null,"F-24"]
[]
[null,"Total subcontracting (all WPs)",null,null,null,0,null,null,null,"F-24"]
["C. Purchase costs",null,null,null,null,null,null,null,null,"F-24"]
["C.1 Travel and subsistence",null,null,null,null,null,null,null,null,"F-24"]
[null,null,"Costs \n(actual costs)","Costs  (unit cost)",null,null,null,"Also part of other work packages?  \nYES/NO and which WP","Description (e.g. international/not international; place of activity/destination; number of days; number of persons (speakers, personnel and participants whose costs are covered); transport means; average price per person; subsistence costs/daily allowances)","F-24"]
[null,null,null,"Amount per unit","Number of  units","Total \n ( EUR)  ",null,null,null,"F-24"]
[]
[null,null,null,"Total travel costs (all WPs)",null,0,null,null,null,"F-24",null,null,"Shown"]
[null,null,null,"Total accommodation (all WPs)",null,0,null,null,null,"F-24",null,null,"Shown"]
[null,null,null,"Total subsistence (all WPs)",null,0,null,null,null,"F-24",null,null,"Shown"]
[null,"Total travel and subsistence (all WPs)",null,null,null,{"$f":"WP_B1_Total+WP_B2_Total+WP_B3_Total","v":0},null,null,null,"F-24"]
["C.2 Equipment",null,null,null,null,null,null,null,null,"F-24"]
[]
["Total equipment (all WPs)",null,null,null,null,null,0,null,null,"F-24"]
["C.3 Other goods, works and services",null,null,null,null,null,null,null,null,"F-24"]
[]
[null,"Total goods, works and services (all WPs)",0,null,null,null,null,null,null,"F-24"]
["E.3 Costs of …","ATTENTION! This budget category can only be used if explicitly allowed in the grant agreement ",null,null,null,null,null,null,null,"F-24",null,null,"Hidden"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Hidden"]
[null,null,"Total Other Costs (all WPs)",null,0,null,null,null,null,null,null,null,"Hidden"]
[null,null,"Total purchase costs (all WPs)",null,null,{"$f":"WP_E1_Total+WP_E2_Total+WP_B_Total","v":0},null,null,null,"F-24"]
["D. Other cost categories(N/A)",null,null,null,null,null,null,null,null,"F-24"]
["D.1. Financial support to third parties",null,null,null,null,null,null,null,null,"F-24",null,null,"Hidden"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Hidden"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Hidden"]
[null,"Total D.1 (all WPs)",null,null,null,0,null,null,null,"F-24",null,null,"Hidden"]
[{"$f":"'EC Data'!A15","v":"D.2 [Category name]"},null,null,null,null,null,null,null,null,"F-24",null,null,"Hidden"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Hidden"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Hidden"]
[null,"Total D.2 (all WPs)",null,null,null,0,null,null,null,"F-24",null,null,"Hidden"]
[{"$f":"'EC Data'!A16","v":"D.3 [Category name]"},null,null,null,null,null,null,null,null,"F-24",null,null,"Hidden"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Hidden"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Hidden"]
[null,"Total D.3 (all WPs)",null,null,null,0,null,null,null,"F-24",null,null,"Hidden"]
[{"$f":"'EC Data'!A17","v":"D.4 [Category name]"},null,null,null,null,null,null,null,null,"F-24",null,null,"Hidden"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Hidden"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Hidden"]
[null,"Total D.4 (all WPs)",null,null,null,0,null,null,null,"F-24",null,null,"Hidden"]
[{"$f":"'EC Data'!A18","v":"D.5 [Category name]"},null,null,null,null,null,null,null,null,"F-24",null,null,"Hidden"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Hidden"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Hidden"]
[null,"Total D.5 (all WPs)",null,null,null,0,null,null,null,"F-24",null,null,"Hidden"]
[{"$f":"'EC Data'!A19","v":"D.6 [Category name]"},null,null,null,null,null,null,null,null,"F-24",null,null,"Hidden"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Hidden"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Hidden"]
[null,"Total D.6 (all WPs)",null,null,null,0,null,null,null,"F-24",null,null,"Hidden"]
[null,"Total other cost categories (all WPs)",null,null,null,{"$f":"WP_D06_Total+WP_D05_Total+WP_D04_Total+WP_D03_Total+WP_D02_Total+WP_D_Total","v":0},null,null,null,"F-24",null,null,"Shown"]
["E. Indirect costs",null,null,null,null,null,null,null,null,"F-24"]
[null,null,"Costs \n(flat-rate)",null,null,null,null,null,null,"F-24",null,null,"Shown"]
["ALL WORK PACKAGES ","Total estimated direct costs (on which indirect cost flat-rate is based, see GA eligibility article)",{"$f":"'4. Consolid table (participant)'!B19","v":0},null,null,null,null,null,null,"F-24",null,null,"Shown"]
[null,"Flat-rate (%)",7.0000000000000007E-2," ATTENTION! Check that the rate is in line with the call conditions. Put 0% if you receive an EU Operating Grant and are not eligible to charge indirect costs”",null,null,null,null,null,"F-24",null,null,"Shown"]
[null,"Total indirect costs",{"$f":"C75*C76","v":0},null,null,null,null,null,null,"F-24",null,null,"Shown"]
[null,"Total indirect costs ",{"$f":"C77","v":0},null,null,null,null,null,null,"F-24",null,null,"Shown"]
["G. Costs of …",null,null,null,null,null,null,null,null,null,null,null,"Hidden"]
[null,null,"Costs ",null,null,null,null,"Also part of other work packages? YES/NO and which WP","Description of the tasks/activities",null,null,null,"Hidden"]
[null,null,"Amount per unit","Number of units","Total  (EUR) ",null,null,null,null,"RH",null,null,"Hidden"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Hidden"]
[null,null,"Total costs of ... (all WPs) ",null,0,null,null,null,null,null,null,null,"Hidden"]
[null,null,null,null,"TOTAL COSTS PARTICIPANT",null,null,{"$f":"C75+C77+'4. Consolid table (participant)'!D16","v":0},null,"F-24"]
[]
[]
["PROJECT INCOME",null,null,null,null,null,null,null,null,"F-24"]
["EU CONTRIBUTION (GRANT)",null,null,null,null,null,null,null,null,"F-24"]
[null,null,"Amount\n (EUR)",null,null,null,null,null,null,"F-24"]
[null,"Total  costs ",{"$f":"H84","v":0},null,null,null,null,null,null,"F-24"]
[null,"Single Funding rate (%)",0," ATTENTION! Enter funding rate from the call conditions.",null,null,null,null,null,"F-24",null,null,"Shown"]
[null,{"$f":"\"Multiple funding rates (%) =\n \"& 'EC Data'!B85","v":"Multiple funding rates (%) =\n (a1 + a2 + a3 + a4 + a5) * 70% + b * 70% + ( c1+ c2 + c3) * 70% + (d1) * 100% + (e) * 70%"},null,null,null,null,null,null,null,"F-24",null,null,"Hidden"]
[null,"Maximum EU contribution ",{"$f":"IF(TypeFundRate = 2, 'EC Data'!E100,C90*C91)","v":0},null,null,null,null,null,null,"F-24"]
[null,"Requested EU contribution ",0," ATTENTION❗ In order to avoid rounding issues, please request 1 cent less than the maximum EU contribution.",null,null,null,null,null,"F-24"]
[null,"EU CONTRIBUTION",{"$f":"C94","v":0},null,null,null,null,null,null,"F-24"]
["REVENUES AND CONTRIBUTIONS BY THIRD PARTIES",null,null,null,null,null,null,null,null,"F-24"]
["Revenues",null,null,null,null,null,null,null,null,"F-24"]
["Income generated by the action",null,null,null,null,null,null,null,null,"F-24"]
[null,null,"Amount\n (EUR)",null,null,null,null,null,"Description of the income (type of generated income and number of users, etc)","F-24"]
["ALL WORK PACKAGES ","Estimated income generated by the action",0,null,null,null,null,null,null,"F-24"]
[null,"Total income generated by the action",{"$f":"SUM(C100)","v":0},null,null,null,null,null,null,"F-24"]
["Revenues",null,{"$f":"C101","v":0},null,null,null,null,null,null,"F-24"]
["In-kind contributions by third parties",null,null,null,null,null,null,null,null,"F-24"]
["In-kind contributions by third parties",null,null,null,null,null,null,null,null,"F-24"]
[null,null,"Amount\n (EUR)",null,null,null,null,null,"Description of the contribution (type of contribution, donor, purpose etc)","F-24"]
["ALL WORK PACKAGES ","Estimated in-kind contributions by third parties ",0,null,null,null,null,null,null,"F-24"]
[null,"Total in-kind contributions",{"$f":"SUM(C106)","v":0},null,null,null,null,null,null,"F-24"]
[null,"In-kind contributions",{"$f":"SUM(C107)","v":0},null,null,null,null,null,null,"F-24"]
["Financial contributions by third parties",null,null,null,null,null,null,null,null,"F-24"]
["Financial contributions by third parties",null,null,null,null,null,null,null,null,"F-24"]
[null,null,"Amount\n (EUR)",null,null,null,null,null,"Description of the contribution (type of contribution, donor, purpose, etc)","F-24"]
["ALL WORK PACKAGES ","Estimated financial contributions by third parties ",0,null,null,null,null,null,null,"F-24"]
[null,"Total financial contributions",{"$f":"SUM(C112)","v":0},null,null,null,null,null,null,"F-24"]
[null,"Financial contributions",{"$f":"SUM(C113)","v":0},null,null,null,null,null,null,"F-24"]
[null,"TOTAL REVENUES AND CONTRIBUTIONS BY THIRD PARTIES   ",{"$f":"C114+C108+C102","v":0},null,null,null,null,null,null,"F-24"]
["OWN RESOURCES",null,null,null,null,null,null,null,null,"F-24"]
[null,null,"Amount\n (EUR)  ",null,null,null,null,null,null,"F-24"]
[null,"Own resources",{"$f":"H84-C95-C115","v":0},null,null,null,null,null,null,"F-24"]
[null,"OWN RESOURCES",{"$f":"SUM(C118)","v":0},null,null,null,null,null,null,"F-24"]
[null,"TOTAL INCOME PARTICIPANT",{"$f":"C95+C115+C119","v":0},null,null,null,null,null,null,"F-24"]

{"sheet":"4. Consolid table (participant)","index":6,"n_rows":19,"n_cols":27,"rows_kept":19,"cut":false,"hidden":false,"merged":[[7,0,7,20],[8,0,8,20],[9,20,10,20],[9,7,9,12],[9,0,10,0],[9,1,10,1],[9,2,10,2],[9,3,10,3],[9,19,10,19],[9,4,10,4],[9,6,10,6],[9,13,9,18],[9,5,10,5],[2,1,2,2],[3,1,3,2],[4,1,4,2],[5,1,5,2],[0,0,0,20],[1,0,1,3]]}
["DETAILED BUDGET TABLE (ACTION GRANTS)"]
[]
["Project number:",{"$f":"IF(ISBLANK('2. Start'!C4),\" \",'2. Start'!C4)","v":" "}]
["Project acronym:",{"$f":"IF(ISBLANK('2. Start'!C5),\" \",'2. Start'!C5)","v":" "}]
["Participant short name:",{"$f":"IF(ISBLANK('2. Start'!C6),\" \",'2. Start'!C6)","v":" "}]
["Participant PIC:",{"$f":"IF(ISBLANK('2. Start'!C7),\" \",'2. Start'!C7)","v":" "}]
[]
["CONSOLIDATED COSTS PER WORK PACKAGE (PER PARTICIPANT)"]
["COSTS PER WORK PACKAGE"]
[null,"A.1 Employees\nA.2 + A.3 Natural persons under direct contract and seconded persons\n","A.4 SME owners","A.5 Volunteers ",{"$f":"'EC Data'!A28","v":"A.6 [Category name]"},{"$f":"'EC Data'!A29","v":"A.7 [Category name]"},"B. Subcontracting costs","C. Purchase costs",null,null,null,null,null,"D. Other cost categories",null,null,null,null,null,"E. Indirect costs\n","Total"]
[null,null,null,null,null,null,null,"C.1 Travel and subsistence","C.1 Travel","C.1 Accommodation","C.1 Subsistence","C.2 Equipment","C.3 Other goods, work and services","D.1 Financial support to third parties",{"$f":"'EC Data'!A15","v":"D.2 [Category name]"},{"$f":"'EC Data'!A16","v":"D.3 [Category name]"},{"$f":"'EC Data'!A17","v":"D.4 [Category name]"},{"$f":"'EC Data'!A18","v":"D.5 [Category name]"},{"$f":"'EC Data'!A19","v":"D.6 [Category name]"}]
[null,"a1 - a2","a3","a4","a5","a6","b","c1","c1a","c1b","c1c","c2","c3","d1","d2","d3","d4","d5","d6","e = flat-rate * (a1 + a2 + a3 + a5 + b [+ c1] + [c1a + c1b + c1c] + c2 + c3  + d1 + d2 + d3 + d4 + d5 + d6)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"(N/A)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hidden"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hidden"]
["TOTAL COSTS PARTICIPANT",{"$f":"SUM(B14:B15)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"WP_F_Total","v":0},{"$f":"(B16+C16+D16+E16+F16+G16+I16+J16+K16+L16+M16+N16+O16+P16+Q16+R16+T16)","v":0},{"$f":"G16+I16+J16+K16+L16+M16+N16+O16+P16+Q16+R16","v":0},"F-24",null,null,null,{"$f":"G16+I16+J16+K16+L16+M16+N16+O16+P16+Q16+R16+T16","v":0}]
[]
[]
["Total eligible costs (for controls)",{"$f":"B16+C16+E16+F16+G16+I16+J16+K16+L16+M16+N16+O16+P16+Q16+R16+S16","v":0}]

{"sheet":"5. Consolid table (project)","index":7,"n_rows":21,"n_cols":21,"rows_kept":21,"cut":false,"hidden":false,"merged":[[18,0,18,20],[7,0,7,20],[8,0,8,20],[9,1,10,1],[9,2,10,2],[9,3,10,3],[9,4,10,4],[12,0,12,20],[0,0,0,20],[1,0,1,3],[2,1,2,2],[3,1,3,2],[15,0,15,20],[5,0,5,20],[9,5,10,5],[9,6,10,6],[9,7,9,12],[9,13,9,18],[9,19,10,19],[9,0,11,0],[9,20,11,20]]}
["DETAILED BUDGET TABLE (ACTION GRANTS)"]
[]
["Project number:",{"$f":"IF(ISBLANK('2. Start'!C4),\" \",'2. Start'!C4)","v":" "}]
["Project acronym:",{"$f":"IF(ISBLANK('2. Start'!C5),\" \",'2. Start'!C5)","v":" "}]
[]
["ATTENTION! Delete columns that do not apply for your grant. "]
[]
["CONSOLIDATED COSTS PER WORK PACKAGE (PROJECT)"]
["PROJECT COSTS PER WORK PACKAGE"]
[null,"A.1 Employees\nA.2 + A.3 Natural persons under direct contract and seconded persons","A.4 SME owners","A.5 Volunteers ",{"$f":"'EC Data'!A28","v":"A.6 [Category name]"},{"$f":"'EC Data'!A29","v":"A.7 [Category name]"},"B. Subcontracting costs","C. Purchase costs",null,null,null,null,null,"D. Other cost categories",null,null,null,null,null,"E. Indirect costs\n","Total"]
[null,null,null,null,null,null,null,"C.1 Travel and subsistence","C.1 Travel","C.1 Accommodation","C.1 Subsistence","C.2 Equipment","C.3 Other goods, works and services","D.1 Financial support to third parties",{"$f":"'EC Data'!A15","v":"D.2 [Category name]"},{"$f":"'EC Data'!A16","v":"D.3 [Category name]"},{"$f":"'EC Data'!A17","v":"D.4 [Category name]"},{"$f":"'EC Data'!A18","v":"D.5 [Category name]"},{"$f":"'EC Data'!A19","v":"D.6 [Category name]"}]
[null,"a1 - a2","a3","a4","a5","a6","b","c1","c1a","c1b","c1c","c2","c3","d1","d2","d3","d4","d5","d6",{"$f":"E_Formula_Cons","v":"e = flat-rate * (a1 + a2 + a3 + a5 + b [+ c1] + [c1a + c1b + c1c] + c2 + c3  + d1 + d2 + d3 + d4 + d5 + d6)"}]
["PARTICIPANT [name]"]
["TOTAL COSTS PARTICIPANT (Proposal Step)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B14+C14+D14+E14+F14+G14+H14+L14+M14+N14+O14+P14+Q14+R14+S14+T14)","v":0}]
["TOTAL COSTS PARTICIPANT (Grant Preparation Step)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B15+C15+D15+E15+F15+G15+H15+L15+M15+N15+O15+P15+Q15+R15+S15+T15)","v":0}]
["PARTICIPANT [name]"]
["TOTAL COSTS PARTICIPANT (Proposal Step)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B17+C17+D17+E17+F17+G17+H17+L17+M17+N17+O17+P17+Q17+R17+S17+T17)","v":0}]
["TOTAL COSTS PARTICIPANT (Grant Preparation Step)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B18+C18+D18+E18+F18+G18+H18+L18+M18+N18+O18+P18+Q18+R18+S18+T18)","v":0}]
["PARTICIPANT [name]"]
["TOTAL COSTS PARTICIPANT (Proposal Step)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B20+C20+D20+E20+F20+G20+H20+L20+M20+N20+O20+P20+Q20+R20+S20+T20)","v":0}]
["TOTAL COSTS PARTICIPANT (Grant Preparation Step)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B21+C21+D21+E21+F21+G21+H21+L21+M21+N21+O21+P21+Q21+R21+S21+T21)","v":0}]