{"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":6,"macros":1,"external_links":0,"defined_names":413,"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":22,"n_cols":1,"rows_kept":22,"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 (Instructions, Start, Detailed table and Consolidated table (participants) and Consolidated table (project). "]
["The EC sheets (EC Data) must be set-up only once for your programme/MGAs (works for all except operating grants - see separate template) as part of the Programme template set-up exercise. \n\nThe Consortium sheets (Start, Detailed table and Consolidated tables) must be filled out and submitted as part of the Proposal (and/or later during GAP):\n- scanned and attached as PDF to the proposal Part B in SEP (for sheets 3 and 4: one per beneficiary/linked third party)\n- uploaded as Excel file in SyGMa (as attachment to the GA Annex 1).\nIf you need the Excel file for the evaluation, ask the coordinator to send them to you by normal e-mail (outside the system)."]
[]
["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: 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 on EC Data sheet (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, you just need to check that it correctly reflects your choices (and if not, contact the LS (Bettina Conte)). \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."]
["To block the document and hide the 2 sheets again, place the cursor on sheet \"1. Instructions\" and press CTRL Q and answer the question box with OK. "]
["After this, you can save the file and it is ready for use by the participants. You should add them to the call documents (for info) and ask SEP to provide them for download in the Submission Tool."]

{"sheet":"EC Data","index":1,"n_rows":172,"n_cols":8,"rows_kept":172,"cut":false,"hidden":false,"merged":[[83,2,83,3],[84,2,84,3],[78,4,78,5],[79,4,79,5],[80,4,80,5],[81,4,81,5],[82,4,82,5],[90,2,90,3],[91,2,91,3],[83,4,83,5],[84,4,84,5],[90,4,90,5],[91,4,91,5],[85,2,85,3],[85,4,85,5],[86,2,86,3],[86,4,86,5],[87,2,87,3],[87,4,87,5],[88,2,88,3],[88,4,88,5],[89,2,89,3],[89,4,89,5],[62,0,62,1],[115,2,115,4],[115,5,133,7],[117,0,117,4],[72,0,72,7],[67,0,67,1],[94,0,94,7],[68,0,68,1],[69,0,69,1],[93,0,93,7],[77,0,77,1],[78,2,78,3],[79,2,79,3],[80,2,80,3],[81,2,81,3],[82,2,82,3],[61,4,61,5],[137,0,138,0],[137,1,138,1],[137,2,141,7],[135,0,135,7],[63,0,63,1],[65,0,65,1],[63,4,63,5],[64,4,64,5],[62,4,62,5],[70,0,70,1],[95,0,95,7],[115,1,116,1],[61,0,61,1],[64,0,64,1],[66,0,66,1],[168,2,168,4],[163,2,163,4],[163,1,164,1],[168,0,169,0],[163,0,164,0],[161,0,161,7],[143,0,144,0],[143,2,143,4],[143,5,150,7],[145,2,145,4],[148,2,148,4],[154,2,154,4],[157,2,157,4],[152,0,153,0],[152,2,152,4],[152,5,159,7],[143,1,144,1],[152,1,153,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],[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]]}
["EC DATA (DETAILED BUDGET TABLE AG — PROPOSAL/GRANT PREPARATION)"]
[]
["Work package numbers"]
[null,null,null,null,"WP_nb","PW"]
[null,null,null,null,6,"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"]
[]
[]
[]
[]
[]
[]
["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!  \nYou 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!  \nYou 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 or Lump Sum","Unit"]
[{"$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 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)'!B22+'4. Consolid table (participant)'!C22+'4. Consolid table (participant)'!D22","v":34900},null,{"$f":"C80*B80","v":24430}]
["B. Subcontracting costs",0.7,{"$f":"'4. Consolid table (participant)'!G22","v":0},null,0]
["C1. Travel and subsistence",0.7,{"$f":"'4. Consolid table (participant)'!H22","v":36800},null,25760]
["C2. Equipment",0.7,{"$f":"'4. Consolid table (participant)'!L22","v":1125},null,787.5]
["C3. Other goods, works and services ",0.7,{"$f":"'4. Consolid table (participant)'!M22","v":0},null,0]
["D.1. Financial support to third parties\n",1,{"$f":"'4. Consolid table (participant)'!N22","v":0},null,0]
[{"$f":"A15","v":"D.2 [Category name]"},1,{"$f":"'4. Consolid table (participant)'!O22","v":0},null,{"$f":"C86*B86","v":0}]
[{"$f":"A16","v":"D.3 [Category name]"},1,{"$f":"'4. Consolid table (participant)'!P22","v":0},null,0]
["D.4 [Category name]",1,{"$f":"'4. Consolid table (participant)'!Q22","v":0},null,0]
["D.5 [Category name]",1,{"$f":"'4. Consolid table (participant)'!R22","v":0},null,0]
["D.6 [Category name]",1,{"$f":"'4. Consolid table (participant)'!S22","v":0},null,{"$f":"C90*B90","v":0}]
["E. Indirect costs",0.7,{"$f":"'4. Consolid table (participant)'!T22","v":5097.7500000000009},null,3568.4250000000006]
[null,null,{"$f":"SUM(C80:C91)","v":77922.75},null,{"$f":"SUM(E80:E91)","v":54545.925000000003}]
[]
["Below the 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]
["Accomodation costs ",0]
["Subsistence costs ",0]
["Personnel"]
["Travel costs  ",0]
["Accomodation costs ",0]
["Subsistence costs ",0]
["Participants"]
["Travel costs  ",0]
["Accomodation costs ",0]
["Subsistence costs ",0]
["Total travel costs",{"$f":"B100+B104+B108","v":0}]
["Total accomodation",{"$f":"B101+B105+B109","v":0}]
["Total subsistence",{"$f":"B102+B106+B110","v":0}]
["Total travel and subsistence",{"$f":"B111+B112+B113","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":"C120*D120","v":0}]
["Accomodation costs ",0,0,0,{"$f":"C121*D121","v":0}]
["Subsistence costs ",0,0,0,{"$f":"C122*D122","v":0}]
["Personnel"]
["Travel costs  ",0,0,0,{"$f":"C124*D124","v":0}]
["Accomodation costs ",0,0,0,{"$f":"C125*D125","v":0}]
["Subsistence costs ",0,0,0,{"$f":"C126*D126","v":0}]
["Participants"]
["Travel costs  ",0,0,0,{"$f":"C128*D128","v":0}]
["Accomodation costs ",0,0,0,{"$f":"C129*D129","v":0}]
["Subsistence costs ",0,0,0,{"$f":"C130*D130","v":0}]
["Total travel costs",{"$f":"B120+B124+B128+E120+E124+E128","v":0}]
["Total accomodation",{"$f":"E121+E125+E129+B121+B125+B129","v":0}]
["Total subsistence",{"$f":"E122+E126+E130+B122+B126+B130","v":0}]
["Total travel and subsistence",{"$f":"B131+B132+B133","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":"B141+B140","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":"C147*D147","v":0}]
["Total financial support 1  ",null,null,null,{"$f":"SUM(E146:E147)","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":"C150*D150","v":0}]
["Total financial support 2  ",null,null,null,{"$f":"SUM(E149:E150)","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":"C156*D156","v":0}]
["Total financial support 1  ",null,null,null,{"$f":"SUM(E155:E156)","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":"C159*D159","v":0}]
["Total financial support  2  ",null,null,null,{"$f":"SUM(E158:E159)","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":"B166","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":"C171*D171","v":0}]
["Total other cost category for this WP",null,null,null,{"$f":"SUM(G171:G171)","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 accomodation 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,"Accomodation 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,"Accomodation 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,"Accomodation 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 accomodation 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":54,"n_cols":1,"rows_kept":54,"cut":false,"hidden":false,"merged":[]}
["INSTRUCTIONS (DETAILED BUDGET TABLE ACTION GRANTS — PROPOSAL/GRANT PREPARATION)"]
[]
["General"]
["The file is composed of 5 sheets (Instructions, Start, Detailed table, Consolidated table (participants) 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: merge, scan and attach it as a single PDF to your Application Form Part B (Funding & Tenders Portal Submission System; only sheets 3, 4, and 5 needed; for sheets 3 and 4: one per beneficiary/affiliated entity; more details on technical instructions are in the Online Manual) \n- for grant preparation (if needed, after changes requested by the EU): merge, scan and attach it as a single PDF to your Desription of the Action (DoA) Part B (Funding & Tenders Portal Grant Preparation tool).\n\nATTENTION! You may be asked to provide an Excel file by email during evaluation and grant preparation, if needed."]
["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 cost reporting before payments (Funding & Tenders Portal 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 (participants) - 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\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 budget 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'."]
["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."]

{"sheet":"2. Start","index":4,"n_rows":22,"n_cols":6,"rows_kept":22,"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 — PROPOSAL/GRANT PREPARATION)"]
[]
["PROJECT DATA"]
["Project number:",null,210747735]
["Project acronym:",null,"FORMATEX23"]
["Participant short name:"]
["Participant PIC:"]
[]
[]
[]
["WORK PACKAGES & TRAVELS"]
[]
[]
[]
[]
["Index","Name","Description","Number of travels","Delete"]
[1,"PROJECT MANAGEMENT","Project and Information Management, Quality Management, Project Controlling, Reporting and documentation",3,null,1]
[2,"PLANNING","Kick-off meeting Brussels and Consortium Kick-Off Meeting, Scenario development for TTX & FSX, Preparation of planning conferences, Planning TTX (incl. Mel/Mil/Injects), Planning FSX (incl. Mel/Mil/Injects), Logistical Planning of all events",3,null,1]
[3,"EXERCISE CONDUCT","Conduct TTX, Conduct FSX",2,null,1]
[4,"DISSEMINATION & VISIBILITY","On-site visibility, Lay-man report, Website, Media work, events, Production of brochures and films, VIP programme and dissemination to other projects",1,null,1]
[5,"EVALUATION","Evaluation Workshop, Evaluation Refresher, Post Exercise Discussion, Project Evaluation and Monitoring",2,null,1]
[6,"WAY FORWARD WORKSHOPS AND SEMINARS","Way Forward Meeting, NATECH Seminar",2,null,1]

{"sheet":"3. Detailed table ","index":5,"n_rows":648,"n_cols":13,"rows_kept":648,"cut":false,"hidden":false,"merged":[[555,0,556,1],[555,2,556,2],[555,3,556,6],[555,7,556,7],[555,8,556,8],[567,0,567,1],[567,3,567,8],[473,7,475,7],[473,8,475,8],[474,3,474,4],[475,3,475,4],[476,3,476,4],[477,3,477,4],[478,3,478,5],[479,1,479,5],[480,1,480,5],[541,8,542,8],[553,0,553,1],[553,3,553,8],[527,0,528,1],[527,2,528,2],[527,3,528,6],[527,7,528,7],[527,8,528,8],[161,1,161,3],[164,1,164,8],[167,1,167,4],[167,6,167,8],[168,1,168,5],[171,1,171,8],[174,1,174,4],[174,6,174,8],[175,1,175,8],[177,1,177,4],[177,6,177,8],[178,1,178,8],[180,1,180,4],[180,6,180,8],[181,1,181,8],[183,1,183,4],[183,6,183,8],[184,1,184,8],[541,7,542,7],[462,2,462,8],[463,1,467,1],[463,2,463,6],[463,7,467,7],[463,8,467,8],[464,2,466,2],[464,3,466,3],[464,4,466,4],[464,5,466,5],[464,6,466,6],[470,3,470,5],[471,1,471,5],[539,0,539,1],[539,3,539,8],[525,0,525,1],[525,3,525,8],[513,8,514,8],[187,1,187,4],[456,3,456,4],[457,3,457,4],[458,3,458,5],[459,1,459,5],[460,1,460,5],[541,0,542,1],[541,2,542,2],[541,3,542,6],[472,2,472,8],[473,1,475,1],[473,2,473,6],[450,3,450,5],[451,1,451,5],[452,2,452,8],[453,1,455,1],[453,2,453,6],[453,7,455,7],[453,8,455,8],[454,3,454,4],[455,3,455,4],[443,7,447,7],[443,8,447,8],[444,2,446,2],[444,3,446,3],[444,4,446,4],[444,5,446,5],[444,6,446,6],[335,6,335,8],[336,6,337,6],[339,6,339,8],[340,6,341,6],[343,6,343,8],[344,6,345,6],[347,6,347,8],[348,6,348,8],[349,6,349,8],[436,3,436,4],[437,3,437,4],[438,3,438,5],[439,1,439,5],[419,1,419,5],[420,1,420,5],[410,3,410,5],[411,1,411,5],[412,2,412,8],[413,1,415,1],[413,2,413,6],[133,1,133,3],[136,1,136,8],[139,1,139,4],[139,6,139,8],[140,1,140,5],[143,1,143,8],[146,1,146,4],[146,6,146,8],[147,1,147,8],[149,1,149,4],[149,6,149,8],[150,1,150,8],[152,1,152,4],[152,6,152,8],[153,1,153,8],[155,1,155,4],[155,6,155,8],[433,7,435,7],[433,8,435,8],[434,3,434,4],[435,3,435,4],[322,6,323,6],[325,6,325,8],[326,6,326,8],[327,6,327,8],[402,2,402,8],[403,1,407,1],[403,2,403,6],[403,7,407,7],[403,8,407,8],[416,3,416,4],[417,3,417,4],[418,3,418,5],[105,1,105,3],[108,1,108,8],[111,1,111,4],[111,6,111,8],[112,1,112,5],[115,1,115,8],[118,1,118,4],[118,6,118,8],[119,1,119,8],[121,1,121,4],[121,6,121,8],[122,1,122,8],[124,1,124,4],[124,6,124,8],[125,1,125,8],[127,1,127,4],[127,6,127,8],[321,6,321,8],[283,6,283,8],[221,0,222,1],[226,6,227,6],[229,6,229,8],[230,6,231,6],[233,6,233,8],[234,6,235,6],[237,6,237,8],[251,6,251,8],[252,6,253,6],[255,6,255,8],[256,6,257,6],[259,6,259,8],[260,6,260,8],[261,6,261,8],[413,7,415,7],[413,8,415,8],[414,3,414,4],[415,3,415,4],[513,0,514,1],[513,2,514,2],[513,3,514,6],[513,7,514,7],[422,2,422,8],[423,1,427,1],[423,2,423,6],[423,7,427,7],[423,8,427,8],[424,2,426,2],[424,3,426,3],[424,4,426,4],[424,5,426,5],[424,6,426,6],[430,3,430,5],[431,1,431,5],[432,2,432,8],[433,1,435,1],[433,2,433,6],[440,1,440,5],[442,2,442,8],[443,1,447,1],[443,2,443,6],[404,2,406,2],[404,3,406,3],[404,4,406,4],[404,5,406,5],[404,6,406,6],[291,6,291,8],[292,6,293,6],[295,6,295,8],[296,6,297,6],[299,6,299,8],[300,6,301,6],[303,6,303,8],[304,6,304,8],[305,6,305,8],[313,6,313,8],[314,6,315,6],[317,6,317,8],[318,6,319,6],[359,1,359,4],[373,7,375,7],[373,8,375,8],[362,2,362,8],[204,3,204,8],[269,6,269,8],[270,6,271,6],[273,6,273,8],[274,6,275,6],[277,6,277,8],[278,6,279,6],[281,6,281,8],[282,6,282,8],[206,3,206,6],[208,3,208,8],[210,3,210,6],[212,3,212,8],[214,3,214,6],[216,3,216,8],[221,3,221,5],[221,7,222,7],[356,3,356,4],[357,3,357,4],[358,3,358,4],[355,6,355,8],[247,6,247,8],[248,6,249,6],[97,1,97,8],[99,1,99,4],[99,6,99,8],[100,1,100,8],[102,1,102,4],[102,6,102,8],[103,1,103,4],[103,6,103,8],[202,3,202,6],[131,6,131,8],[156,1,156,8],[158,1,158,4],[158,6,158,8],[159,1,159,4],[159,6,159,8],[187,6,187,8],[194,3,194,6],[196,3,196,8],[128,1,128,8],[130,1,130,4],[130,6,130,8],[131,1,131,4],[186,1,186,4],[186,6,186,8],[87,1,87,8],[90,1,90,4],[90,6,90,8],[91,1,91,8],[93,1,93,4],[93,6,93,8],[94,1,94,8],[96,1,96,4],[96,6,96,8],[586,1,586,4],[582,1,582,4],[572,2,572,3],[578,1,578,4],[573,2,573,4],[481,7,481,8],[569,3,569,8],[482,0,482,5],[568,0,568,8],[482,7,482,8],[485,0,486,1],[485,2,486,2],[485,3,486,6],[485,7,486,7],[485,8,486,8],[497,0,497,1],[497,3,497,8],[499,0,500,1],[499,2,500,2],[499,3,500,6],[499,7,500,7],[499,8,500,8],[511,0,511,1],[511,3,511,8],[614,0,614,8],[590,1,590,4],[607,7,608,7],[611,4,611,6],[607,8,608,8],[594,1,594,4],[598,1,598,4],[599,1,599,4],[602,0,604,0],[607,2,607,4],[610,2,610,3],[600,0,600,1],[644,3,644,8],[616,3,616,8],[644,0,644,1],[616,0,616,1],[628,3,628,8],[618,3,618,4],[629,3,629,8],[629,0,629,1],[627,3,627,7],[626,0,626,1],[632,0,632,1],[638,0,638,1],[619,1,619,4],[17,6,19,6],[16,0,16,1],[17,8,19,8],[191,7,192,7],[17,0,19,1],[18,2,19,2],[190,0,190,1],[191,8,192,8],[191,3,192,6],[27,6,27,8],[28,1,28,5],[31,1,31,8],[34,1,34,4],[34,6,34,8],[35,1,35,8],[46,6,46,8],[37,1,37,4],[37,6,37,8],[38,1,38,8],[40,1,40,4],[40,6,40,8],[47,1,47,4],[47,6,47,8],[66,1,66,8],[238,6,238,8],[239,6,239,8],[225,6,225,8],[14,0,14,8],[16,2,16,8],[189,0,189,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],[21,1,21,3],[24,1,24,8],[27,1,27,4],[17,7,19,7],[15,0,15,8],[17,2,17,5],[41,1,41,8],[43,1,43,4],[43,6,43,8],[44,1,44,8],[46,1,46,4],[65,1,65,4],[65,6,65,8],[221,6,222,6],[221,8,222,8],[218,1,218,4],[191,2,192,2],[191,0,192,1],[72,1,72,8],[74,1,74,4],[74,6,74,8],[75,1,75,4],[75,6,75,8],[68,1,68,4],[68,6,68,8],[69,1,69,8],[71,1,71,4],[71,6,71,8],[198,3,198,6],[200,3,200,8],[77,1,77,3],[80,1,80,8],[83,1,83,4],[83,6,83,8],[84,1,84,5],[49,1,49,3],[52,1,52,8],[55,1,55,4],[55,6,55,8],[56,1,56,5],[59,1,59,8],[62,1,62,4],[62,6,62,8],[63,1,63,8],[363,1,367,1],[363,2,363,6],[363,7,367,7],[363,8,367,8],[364,2,366,2],[364,3,366,3],[364,4,366,4],[364,5,366,5],[364,6,366,6],[382,2,382,8],[383,1,387,1],[383,2,383,6],[383,7,387,7],[383,8,387,8],[384,2,386,2],[384,3,386,3],[384,4,386,4],[384,5,386,5],[384,6,386,6],[376,3,376,4],[377,3,377,4],[378,3,378,5],[379,1,379,5],[380,1,380,5],[370,3,370,5],[371,1,371,5],[372,2,372,8],[373,1,375,1],[373,2,373,6],[374,3,374,4],[375,3,375,4],[399,1,399,5],[400,1,400,5],[390,3,390,5],[391,1,391,5],[392,2,392,8],[393,1,395,1],[393,2,393,6],[393,7,395,7],[393,8,395,8],[394,3,394,4],[395,3,395,4],[396,3,396,4],[397,3,397,4],[398,3,398,5]]}
["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"]
[]
["EU GRANTS 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":210747735},null,null,null,null,null,null,"2021-06-02T12:35:13","F-18"]
["Project acronym:",{"$f":"IF(ISBLANK('2. Start'!C5),\" \",'2. Start'!C5)","v":"FORMATEX23"},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"]
[]
["EU PROJECT 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"]
[null,null,"Costs  (actual 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"]
["WORK PACKAGE 1",{"$f":"IDX_WP_Name_1","v":"PROJECT MANAGEMENT"},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,"Senior experts/advisors/researchers","monthly",4800,2.5,{"$f":"E23*D23","v":12000},null,"YES 1,2,3,6","Coordinator/Participant to the planning conferences/CBRN Adviser and Civil Protection Expert","Last","4#5","8#9","Shown"]
[null,"Administrative personnel","monthly",3600,1.5,{"$f":"E24*D24","v":5400},null,"YES 1,2,3,6","Support to Coordinator","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":"E26*D26","v":0},null,null,null,"Last","4#5","8#9","Shown"]
[null,"[category 2]","monthly",0,0,{"$f":"E27*D27","v":0},null,null,null,"Authorised","4#5","8#9","Shown"]
[null,"Total employees (or equivalent)",null,null,null,{"$f":"SUM(F22:F27)","v":17400},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":"D30*E30","v":0},null,null,null,"Last","4#5","8#9","Shown"]
[null,"Select a staff category","monthly",0,0,{"$f":"D31*E31","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":"D33*E33","v":0},null,null,null,"Last","4#5","8#9","Shown"]
[null,"[category 2]","monthly",0,0,{"$f":"D34*E34","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(F29:F34)","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,"Hidden"]
[null,"SME owners/natural person beneficiaries without salary","daily",0,0,{"$f":"D37*E37","v":0},null,null,null,"Last","4#5","8#9","Hidden"]
[null,"Total SME owners and natural person beneficiaries without salary",null,null,null,{"$f":"SUM(F36:F37)","v":0},null,null,null,"F-18",null,null,"Hidden"]
[null,"A.5 Volunteers",null,null,null,null,null,null,null,"F-18",null,null,"Hidden"]
[null,"Volunteers","daily",0,0,{"$f":"D40*E40","v":0},null,null,null,"Last","4#5","8#9","Hidden"]
[null,"Total Volunteers",null,null,null,{"$f":"SUM(F39:F40)","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":"D43*E43","v":0},null,null,null,"Last","4#5","8#9","Hidden"]
[null,"Total other personnel costs A.6",null,null,null,{"$f":"SUM(F42:F43)","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":"D46*E46","v":0},null,null,null,"Last","4#5","8#9","Hidden"]
[null,"Total other personnel costs A.7",null,null,null,{"$f":"SUM(F45:F46)","v":0},null,null,null,"F-18",null,null,"Hidden"]
[null,"Total personnel for this WP",null,null,null,{"$f":"F35+F28+F38+F41+F44+F47","v":17400},null,null,null,"F-18"]
["WORK PACKAGE 2",{"$f":"IDX_WP_Name_2","v":"PLANNING"},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":"E51*D51","v":0},null,null,null,"Last","4#5","8#9","Shown"]
[null,"Select a staff category","monthly",0,0,{"$f":"E52*D52","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":"E54*D54","v":0},null,null,null,"Last","4#5","8#9","Shown"]
[null,"[category 2]","monthly",0,0,{"$f":"E55*D55","v":0},null,null,null,"Authorised","4#5","8#9","Shown"]
[null,"Total employees (or equivalent)",null,null,null,{"$f":"SUM(F50:F55)","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":"D58*E58","v":0},null,null,null,"Last","4#5","8#9","Shown"]
[null,"Select a staff category","monthly",0,0,{"$f":"D59*E59","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":"D61*E61","v":0},null,null,null,"Last","4#5","8#9","Shown"]
[null,"[category 2]","monthly",0,0,{"$f":"D62*E62","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(F57:F62)","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,"Hidden"]
[null,"SME owners/natural person beneficiaries without salary","daily",0,0,{"$f":"D65*E65","v":0},null,null,null,"Last","4#5","8#9","Hidden"]
[null,"Total SME owners and natural person beneficiaries without salary",null,null,null,{"$f":"SUM(F64:F65)","v":0},null,null,null,"F-18",null,null,"Hidden"]
[null,"A.5 Volunteers",null,null,null,null,null,null,null,"F-18",null,null,"Hidden"]
[null,"Volunteers","daily",0,0,{"$f":"D68*E68","v":0},null,null,null,"Last","4#5","8#9","Hidden"]
[null,"Total Volunteers",null,null,null,{"$f":"SUM(F67:F68)","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":"D71*E71","v":0},null,null,null,"Last","4#5","8#9","Hidden"]
[null,"Total other personnel costs A.6",null,null,null,{"$f":"SUM(F70:F71)","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":"D74*E74","v":0},null,null,null,"Last","4#5","8#9","Hidden"]
[null,"Total other personnel costs A.7",null,null,null,{"$f":"SUM(F73:F74)","v":0},null,null,null,"F-18",null,null,"Hidden"]
[null,"Total personnel for this WP",null,null,null,{"$f":"F63+F56+F66+F69+F72+F75","v":0},null,null,null,"F-18"]
["WORK PACKAGE 3",{"$f":"IDX_WP_Name_3","v":"EXERCISE CONDUCT"},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,"Technical personnel","monthly",3500,5,{"$f":"E79*D79","v":17500},null,"NO","CBRN Module participating in TTX and FSX","Last","4#5","8#9","Shown"]
[null,"Select a staff category","monthly",0,0,{"$f":"E80*D80","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":"E82*D82","v":0},null,null,null,"Last","4#5","8#9","Shown"]
[null,"[category 2]","monthly",0,0,{"$f":"E83*D83","v":0},null,null,null,"Authorised","4#5","8#9","Shown"]
[null,"Total employees (or equivalent)",null,null,null,{"$f":"SUM(F78:F83)","v":17500},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":"D86*E86","v":0},null,null,null,"Last","4#5","8#9","Shown"]
[null,"Select a staff category","monthly",0,0,{"$f":"D87*E87","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":"D89*E89","v":0},null,null,null,"Last","4#5","8#9","Shown"]
[null,"[category 2]","monthly",0,0,{"$f":"D90*E90","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(F85:F90)","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":"D93*E93","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(F92:F93)","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":"D96*E96","v":0},null,null,null,"Last","4#5","8#9","Hidden"]
[null,"Total Volunteers",null,null,null,{"$f":"SUM(F95:F96)","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":"D99*E99","v":0},null,null,null,"Last","4#5","8#9","Hidden"]
[null,"Total other personnel costs A.6",null,null,null,{"$f":"SUM(F98:F99)","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":"D102*E102","v":0},null,null,null,"Last","4#5","8#9","Hidden"]
[null,"Total other personnel costs A.7",null,null,null,{"$f":"SUM(F101:F102)","v":0},null,null,null,"F-18",null,null,"Hidden"]
[null,"Total personnel for this WP",null,null,null,{"$f":"F91+F84+F94+F97+F100+F103","v":17500},null,null,null,"F-18"]
["WORK PACKAGE 4",{"$f":"IDX_WP_Name_4","v":"DISSEMINATION & VISIBILITY"},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":"E107*D107","v":0},null,null,null,"Last","4#5","8#9","Shown"]
[null,"Select a staff category","monthly",0,0,{"$f":"E108*D108","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":"E110*D110","v":0},null,null,null,"Last","4#5","8#9","Shown"]
[null,"[category 2]","monthly",0,0,{"$f":"E111*D111","v":0},null,null,null,"Authorised","4#5","8#9","Shown"]
[null,"Total employees (or equivalent)",null,null,null,{"$f":"SUM(F106:F111)","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":"D114*E114","v":0},null,null,null,"Last","4#5","8#9","Shown"]
[null,"Select a staff category","monthly",0,0,{"$f":"D115*E115","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":"D117*E117","v":0},null,null,null,"Last","4#5","8#9","Shown"]
[null,"[category 2]","monthly",0,0,{"$f":"D118*E118","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(F113:F118)","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":"D121*E121","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(F120:F121)","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":"D124*E124","v":0},null,null,null,"Last","4#5","8#9","Hidden"]
[null,"Total Volunteers",null,null,null,{"$f":"SUM(F123:F124)","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":"D127*E127","v":0},null,null,null,"Last","4#5","8#9","Hidden"]
[null,"Total other personnel costs A.6",null,null,null,{"$f":"SUM(F126:F127)","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":"D130*E130","v":0},null,null,null,"Last","4#5","8#9","Hidden"]
[null,"Total other personnel costs A.7",null,null,null,{"$f":"SUM(F129:F130)","v":0},null,null,null,"F-18",null,null,"Hidden"]
[null,"Total personnel for this WP",null,null,null,{"$f":"F119+F112+F122+F125+F128+F131","v":0},null,null,null,"F-18"]
["WORK PACKAGE 5",{"$f":"IDX_WP_Name_5","v":"EVALUATION"},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,"Senior experts/advisors/researchers","monthly",0,0,{"$f":"E135*D135","v":0},null,null,null,"Last","4#5","8#9","Shown"]
[null,"Junior experts/advisors/researchers","monthly",0,0,{"$f":"E136*D136","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":"E138*D138","v":0},null,null,null,"Last","4#5","8#9","Shown"]
[null,"[category 2]","monthly",0,0,{"$f":"E139*D139","v":0},null,null,null,"Authorised","4#5","8#9","Shown"]
[null,"Total employees (or equivalent)",null,null,null,{"$f":"SUM(F134:F139)","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":"D142*E142","v":0},null,null,null,"Last","4#5","8#9","Shown"]
[null,"Select a staff category","monthly",0,0,{"$f":"D143*E143","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":"D145*E145","v":0},null,null,null,"Last","4#5","8#9","Shown"]
[null,"[category 2]","monthly",0,0,{"$f":"D146*E146","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(F141:F146)","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":"D149*E149","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(F148:F149)","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":"D152*E152","v":0},null,null,null,"Last","4#5","8#9","Hidden"]
[null,"Total Volunteers",null,null,null,{"$f":"SUM(F151:F152)","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":"D155*E155","v":0},null,null,null,"Last","4#5","8#9","Hidden"]
[null,"Total other personnel costs A.6",null,null,null,{"$f":"SUM(F154:F155)","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":"D158*E158","v":0},null,null,null,"Last","4#5","8#9","Hidden"]
[null,"Total other personnel costs A.7",null,null,null,{"$f":"SUM(F157:F158)","v":0},null,null,null,"F-18",null,null,"Hidden"]
[null,"Total personnel for this WP",null,null,null,{"$f":"F147+F140+F150+F153+F156+F159","v":0},null,null,null,"F-18"]
["WORK PACKAGE 6",{"$f":"IDX_WP_Name_6","v":"WAY FORWARD WORKSHOPS AND SEMINARS"},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":"E163*D163","v":0},null,null,null,"Last","4#5","8#9","Shown"]
[null,"Select a staff category","monthly",0,0,{"$f":"E164*D164","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":"E166*D166","v":0},null,null,null,"Last","4#5","8#9","Shown"]
[null,"[category 2]","monthly",0,0,{"$f":"E167*D167","v":0},null,null,null,"Authorised","4#5","8#9","Shown"]
[null,"Total employees (or equivalent)",null,null,null,{"$f":"SUM(F162:F167)","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":"D170*E170","v":0},null,null,null,"Last","4#5","8#9","Shown"]
[null,"Select a staff category","monthly",0,0,{"$f":"D171*E171","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":"D173*E173","v":0},null,null,null,"Last","4#5","8#9","Shown"]
[null,"[category 2]","monthly",0,0,{"$f":"D174*E174","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(F169:F174)","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":"D177*E177","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(F176:F177)","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":"D180*E180","v":0},null,null,null,"Last","4#5","8#9","Hidden"]
[null,"Total Volunteers",null,null,null,{"$f":"SUM(F179:F180)","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":"D183*E183","v":0},null,null,null,"Last","4#5","8#9","Hidden"]
[null,"Total other personnel costs A.6",null,null,null,{"$f":"SUM(F182:F183)","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":"D186*E186","v":0},null,null,null,"Last","4#5","8#9","Hidden"]
[null,"Total other personnel costs A.7",null,null,null,{"$f":"SUM(F185:F186)","v":0},null,null,null,"F-18",null,null,"Hidden"]
[null,"Total personnel for this WP",null,null,null,{"$f":"F175+F168+F178+F181+F184+F187","v":0},null,null,null,"F-18"]
[]
["Total personnel (all WPs)",null,null,null,null,{"$f":"WP_A1_Total+WP_A2_Total+WP_A3_Total+WP_A4_Total+WP_A5_Total+WP_A6_Total","v":34900},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"]
["WORK PACKAGE 1",{"$f":"IDX_WP_Name_1","v":"PROJECT MANAGEMENT"},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(C194:C196)","v":0},null,null,null,null,null,null,"F-18"]
["WORK PACKAGE 2",{"$f":"IDX_WP_Name_2","v":"PLANNING"},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(C198:C200)","v":0},null,null,null,null,null,null,"F-18"]
["WORK PACKAGE 3",{"$f":"IDX_WP_Name_3","v":"EXERCISE CONDUCT"},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(C202:C204)","v":0},null,null,null,null,null,null,"F-18"]
["WORK PACKAGE 4",{"$f":"IDX_WP_Name_4","v":"DISSEMINATION & VISIBILITY"},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(C206:C208)","v":0},null,null,null,null,null,null,"F-18"]
["WORK PACKAGE 5",{"$f":"IDX_WP_Name_5","v":"EVALUATION"},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(C210:C212)","v":0},null,null,null,null,null,null,"F-18"]
["WORK PACKAGE 6",{"$f":"IDX_WP_Name_6","v":"WAY FORWARD WORKSHOPS AND SEMINARS"},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(C214:C216)","v":0},null,null,null,null,null,null,"F-18"]
[]
[null,"Total subcontracting (all WPs)",null,null,null,{"$f":"WP_C1_Total+WP_C2_Total+WP_C3_Total+WP_C4_Total+WP_C5_Total+WP_C6_Total","v":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 will be 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"]
["WORK PACKAGE 1",{"$f":"IDX_WP_Name_1","v":"PROJECT MANAGEMENT"}]
[null,"Project Coordination Meetings",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":"D227*E227","v":0},null,null,null,"F-18"]
[null,"Accomodation costs ",0,0,0,{"$f":"D228*E228","v":0},null,null,null,"F-18"]
[null,"Subsistence costs ",0,0,0,{"$f":"D229*E229","v":0},null,null,null,"F-18"]
[null,"Personnel",null,null,null,null,null,null,null,"F-18"]
[null,"Travel costs  ",0,550,2,{"$f":"D231*E231","v":1100},null,"NO","Kick-Off in Brussels and Final Meeting in Linz/Austria (flight/local transport: 2x €550,-)","F-18"]
[null,"Accomodation costs ",0,250,2,{"$f":"D232*E232","v":500},null,"NO","Kick-Off in Brussels and Final Meeting in Linz/Austria (accomodation: 2x €250,-)","F-18"]
[null,"Subsistence costs ",0,75,4,{"$f":"D233*E233","v":300},null,"NO","Kick-Off in Brussels and Final Meeting in Linz/Austria (DSA: 2x 2x €75,-)","F-18"]
[null,"Participants",null,null,null,null,null,null,null,"F-18"]
[null,"Travel costs  ",0,0,0,{"$f":"D235*E235","v":0},null,null,null,"F-18"]
[null,"Accomodation costs ",0,0,0,{"$f":"D236*E236","v":0},null,null,null,"F-18"]
[null,"Subsistence costs ",0,0,0,{"$f":"D237*E237","v":0},null,null,null,"F-18"]
[null,"Total travel costs for this travel",{"$f":"C227+C231+C235+F227+F231+F235","v":1100},null,null,null,null,null,null,"F-18",null,null,"Shown"]
[null,"Total accomodation costs for this travel",{"$f":"F228+F232+F236+C228+C232+C236","v":500},null,null,null,null,null,null,"F-18",null,null,"Shown"]
[null,"Total subsistence costs for this travel",{"$f":"F229+F233+F237+C229+C233+C237","v":300},null,null,null,null,null,null,"F-18",null,null,"Shown"]
[null,"Total travel",{"$f":"C238+C239+C240","v":1900},null,null,null,null,null,null,"F-18"]
[null,"Total travel costs for this WP",{"$f":"WP_B1_Travel_1_1_subTotal","v":1100},null,null,null,null,null,null,"F-18",null,null,"Shown"]
[null,"Total accomodation costs for this WP",{"$f":"WP_B1_Travel_1_2_subTotal","v":500},null,null,null,null,null,null,"F-18",null,null,"Shown"]
[null,"Total subsistence costs  for this WP",{"$f":"WP_B1_Travel_1_3_subTotal","v":300},null,null,null,null,null,null,"F-18",null,null,"Shown"]
[null,"Total travel for this WP",{"$f":"C242+C243+C244","v":1900},null,null,0,null,null,null,"F-18"]
["WORK PACKAGE 2",{"$f":"IDX_WP_Name_2","v":"PLANNING"}]
[null,"Planning Conferences",null,null,null,null,null,null,null,"F-18"]
[null,"Speakers",null,null,null,null,null,null,null,"F-18"]
[null,"Travel costs  ",0,450,3,{"$f":"D249*E249","v":1350},null,null,null,"F-18"]
[null,"Accomodation costs ",0,250,3,{"$f":"D250*E250","v":750},null,null,null,"F-18"]
[null,"Subsistence costs ",0,150,3,{"$f":"D251*E251","v":450},null,null,null,"F-18"]
[null,"Personnel",null,null,null,null,null,null,null,"F-18"]
[null,"Travel costs  ",0,450,3,{"$f":"D253*E253","v":1350},null,"NO","IPC, MPC, FPC in Linz/Austria (flight/local transport: 3x €450,-)","F-18"]
[null,"Accomodation costs ",0,250,3,{"$f":"D254*E254","v":750},null,"NO","IPC, MPC, FPC in Linz/Austria (2 days á €125,-)","F-18"]
[null,"Subsistence costs ",0,150,3,{"$f":"D255*E255","v":450},null,"NO","IPC, MPC, FPC in Linz/Austria (2 days DSA á €75,-)","F-18"]
[null,"Participants",null,null,null,null,null,null,null,"F-18"]
[null,"Travel costs  ",0,0,0,{"$f":"D257*E257","v":0},null,null,null,"F-18"]
[null,"Accomodation costs ",0,0,0,{"$f":"D258*E258","v":0},null,null,null,"F-18"]
[null,"Subsistence costs ",0,0,0,{"$f":"D259*E259","v":0},null,null,null,"F-18"]
[null,"Total travel costs for this travel",{"$f":"C249+C253+C257+F249+F253+F257","v":2700},null,null,null,null,null,null,"F-18",null,null,"Shown"]
[null,"Total accomodation costs for this travel",{"$f":"F250+F254+F258+C250+C254+C258","v":1500},null,null,null,null,null,null,"F-18",null,null,"Shown"]
[null,"Total subsistence costs for this travel",{"$f":"F251+F255+F259+C251+C255+C259","v":900},null,null,null,null,null,null,"F-18",null,null,"Shown"]
[null,"Total travel",{"$f":"C260+C261+C262","v":5100},null,null,null,null,null,null,"F-18"]
[null,"Total travel costs for this WP",{"$f":"WP_B2_Travel_1_1_subTotal","v":2700},null,null,null,null,null,null,"F-18",null,null,"Shown"]
[null,"Total accomodation costs for this WP",{"$f":"WP_B2_Travel_1_2_subTotal","v":1500},null,null,null,null,null,null,"F-18",null,null,"Shown"]
[null,"Total subsistence costs  for this WP",{"$f":"WP_B2_Travel_1_3_subTotal","v":900},null,null,null,null,null,null,"F-18",null,null,"Shown"]
[null,"Total travel for this WP",{"$f":"C264+C265+C266","v":5100},null,null,0,null,null,null,"F-18"]
["WORK PACKAGE 3",{"$f":"IDX_WP_Name_3","v":"EXERCISE CONDUCT"}]
[null,"FSX Participation (CBRN Module)",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":"D271*E271","v":0},null,null,null,"F-18"]
[null,"Accomodation costs ",0,0,0,{"$f":"D272*E272","v":0},null,null,null,"F-18"]
[null,"Subsistence costs ",0,0,0,{"$f":"D273*E273","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":"D275*E275","v":0},null,"NO",null,"F-18"]
[null,"Accomodation costs ",0,0,0,{"$f":"D276*E276","v":0},null,"NO",null,"F-18"]
[null,"Subsistence costs ",0,0,0,{"$f":"D277*E277","v":0},null,"NO",null,"F-18"]
[null,"Participants",null,null,null,null,null,null,null,"F-18"]
[null,"Travel costs  ",25000,0,0,{"$f":"D279*E279","v":0},null,"NO","CBRN Module deployment","F-18"]
[null,"Accomodation costs ",0,0,0,{"$f":"D280*E280","v":0},null,null,null,"F-18"]
[null,"Subsistence costs ",0,0,0,{"$f":"D281*E281","v":0},null,null,null,"F-18"]
[null,"Total travel costs for this travel",{"$f":"C271+C275+C279+F271+F275+F279","v":25000},null,null,null,null,null,null,"F-18",null,null,"Shown"]
[null,"Total accomodation costs for this travel",{"$f":"F272+F276+F280+C272+C276+C280","v":0},null,null,null,null,null,null,"F-18",null,null,"Shown"]
[null,"Total subsistence costs for this travel",{"$f":"F273+F277+F281+C273+C277+C281","v":0},null,null,null,null,null,null,"F-18",null,null,"Shown"]
[null,"Total travel",{"$f":"C282+C283+C284","v":25000},null,null,null,null,null,null,"F-18"]
[null,"Total travel costs for this WP",{"$f":"WP_B3_Travel_1_1_subTotal","v":25000},null,null,null,null,null,null,"F-18",null,null,"Shown"]
[null,"Total accomodation costs for this WP",{"$f":"WP_B3_Travel_1_2_subTotal","v":0},null,null,null,null,null,null,"F-18",null,null,"Shown"]
[null,"Total subsistence costs  for this WP",{"$f":"WP_B3_Travel_1_3_subTotal","v":0},null,null,null,null,null,null,"F-18",null,null,"Shown"]
[null,"Total travel for this WP",{"$f":"C286+C287+C288","v":25000},null,null,0,null,null,null,"F-18"]
["WORK PACKAGE 4",{"$f":"IDX_WP_Name_4","v":"DISSEMINATION & VISIBILITY"}]
[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":"D293*E293","v":0},null,null,null,"F-18"]
[null,"Accomodation costs ",0,0,0,{"$f":"D294*E294","v":0},null,null,null,"F-18"]
[null,"Subsistence costs ",0,0,0,{"$f":"D295*E295","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":"D297*E297","v":0},null,null,null,"F-18"]
[null,"Accomodation costs ",0,0,0,{"$f":"D298*E298","v":0},null,null,null,"F-18"]
[null,"Subsistence costs ",0,0,0,{"$f":"D299*E299","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":"D301*E301","v":0},null,null,null,"F-18"]
[null,"Accomodation costs ",0,0,0,{"$f":"D302*E302","v":0},null,null,null,"F-18"]
[null,"Subsistence costs ",0,0,0,{"$f":"D303*E303","v":0},null,null,null,"F-18"]
[null,"Total travel costs for this travel",{"$f":"C293+C297+C301+F293+F297+F301","v":0},null,null,null,null,null,null,"F-18",null,null,"Shown"]
[null,"Total accomodation costs for this travel",{"$f":"F294+F298+F302+C294+C298+C302","v":0},null,null,null,null,null,null,"F-18",null,null,"Shown"]
[null,"Total subsistence costs for this travel",{"$f":"F295+F299+F303+C295+C299+C303","v":0},null,null,null,null,null,null,"F-18",null,null,"Shown"]
[null,"Total travel",{"$f":"C304+C305+C306","v":0},null,null,null,null,null,null,"F-18"]
[null,"Total travel costs for this WP",{"$f":"WP_B4_Travel_1_1_subTotal","v":0},null,null,null,null,null,null,"F-18",null,null,"Shown"]
[null,"Total accomodation costs for this WP",{"$f":"WP_B4_Travel_1_2_subTotal","v":0},null,null,null,null,null,null,"F-18",null,null,"Shown"]
[null,"Total subsistence costs  for this WP",{"$f":"WP_B4_Travel_1_3_subTotal","v":0},null,null,null,null,null,null,"F-18",null,null,"Shown"]
[null,"Total travel for this WP",{"$f":"C308+C309+C310","v":0},null,null,0,null,null,null,"F-18"]
["WORK PACKAGE 5",{"$f":"IDX_WP_Name_5","v":"EVALUATION"}]
[null,"Evaluations Activities (Eval.WS, TTX EVAL, FSX EVAL, PDX)",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":"D315*E315","v":0},null,null,null,"F-18"]
[null,"Accomodation costs ",0,0,0,{"$f":"D316*E316","v":0},null,null,null,"F-18"]
[null,"Subsistence costs ",0,0,0,{"$f":"D317*E317","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":"D319*E319","v":0},null,null,null,"F-18"]
[null,"Accomodation costs ",0,0,0,{"$f":"D320*E320","v":0},null,null,null,"F-18"]
[null,"Subsistence costs ",0,0,0,{"$f":"D321*E321","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":"D323*E323","v":0},null,null,null,"F-18"]
[null,"Accomodation costs ",0,0,0,{"$f":"D324*E324","v":0},null,null,null,"F-18"]
[null,"Subsistence costs ",0,0,0,{"$f":"D325*E325","v":0},null,null,null,"F-18"]
[null,"Total travel costs for this travel",{"$f":"C315+C319+C323+F315+F319+F323","v":0},null,null,null,null,null,null,"F-18",null,null,"Shown"]
[null,"Total accomodation costs for this travel",{"$f":"F316+F320+F324+C316+C320+C324","v":0},null,null,null,null,null,null,"F-18",null,null,"Shown"]
[null,"Total subsistence costs for this travel",{"$f":"F317+F321+F325+C317+C321+C325","v":0},null,null,null,null,null,null,"F-18",null,null,"Shown"]
[null,"Total travel",{"$f":"C326+C327+C328","v":0},null,null,null,null,null,null,"F-18"]
[null,"Total travel costs for this WP",{"$f":"WP_B5_Travel_1_1_subTotal","v":0},null,null,null,null,null,null,"F-18",null,null,"Shown"]
[null,"Total accomodation costs for this WP",{"$f":"WP_B5_Travel_1_2_subTotal","v":0},null,null,null,null,null,null,"F-18",null,null,"Shown"]
[null,"Total subsistence costs  for this WP",{"$f":"WP_B5_Travel_1_3_subTotal","v":0},null,null,null,null,null,null,"F-18",null,null,"Shown"]
[null,"Total travel for this WP",{"$f":"C330+C331+C332","v":0},null,null,0,null,null,null,"F-18"]
["WORK PACKAGE 6",{"$f":"IDX_WP_Name_6","v":"WAY FORWARD WORKSHOPS AND SEMINARS"}]
[null,"Expert Participation in Seminars and Workshops",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":"D337*E337","v":0},null,null,null,"F-18"]
[null,"Accomodation costs ",0,0,0,{"$f":"D338*E338","v":0},null,null,null,"F-18"]
[null,"Subsistence costs ",0,0,0,{"$f":"D339*E339","v":0},null,null,null,"F-18"]
[null,"Personnel",null,null,null,null,null,null,null,"F-18"]
[null,"Travel costs  ",0,450,8,{"$f":"D341*E341","v":3600},null,"NO","CBRN Technologies User Workshop (2participants á €450,-)\nNATECH Conference (2participants á €450,-)\nEnvironmental Analytics Seminar (2participants á €450,-)\nWay Forward Seminar (2participants á €450,-)","F-18"]
[null,"Accomodation costs ",0,0,0,{"$f":"D342*E342","v":0},null,"NO",null,"F-18"]
[null,"Subsistence costs ",0,150,8,{"$f":"D343*E343","v":1200},null,"NO","CBRN Technologies User Workshop (2participants á €150,-DSA)\nNATECH Conference (2participants á €150,-DSA)\nEnvironmental Analytics Seminar (2participants á €150,-DSA)\nWay Forward Seminar (2participants á €150,-DSA)","F-18"]
[null,"Participants",null,null,null,null,null,null,null,"F-18"]
[null,"Travel costs  ",0,0,0,{"$f":"D345*E345","v":0},null,null,null,"F-18"]
[null,"Accomodation costs ",0,0,0,{"$f":"D346*E346","v":0},null,null,null,"F-18"]
[null,"Subsistence costs ",0,0,0,{"$f":"D347*E347","v":0},null,null,null,"F-18"]
[null,"Total travel costs for this travel",{"$f":"C337+C341+C345+F337+F341+F345","v":3600},null,null,null,null,null,null,"F-18",null,null,"Shown"]
[null,"Total accomodation costs for this travel",{"$f":"F338+F342+F346+C338+C342+C346","v":0},null,null,null,null,null,null,"F-18",null,null,"Shown"]
[null,"Total subsistence costs for this travel",{"$f":"F339+F343+F347+C339+C343+C347","v":1200},null,null,null,null,null,null,"F-18",null,null,"Shown"]
[null,"Total travel",{"$f":"C348+C349+C350","v":4800},null,null,null,null,null,null,"F-18"]
[null,"Total travel costs for this WP",{"$f":"WP_B6_Travel_1_1_subTotal","v":3600},null,null,null,null,null,null,"F-18",null,null,"Shown"]
[null,"Total accomodation costs for this WP",{"$f":"WP_B6_Travel_1_2_subTotal","v":0},null,null,null,null,null,null,"F-18",null,null,"Shown"]
[null,"Total subsistence costs  for this WP",{"$f":"WP_B6_Travel_1_3_subTotal","v":1200},null,null,null,null,null,null,"F-18",null,null,"Shown"]
[null,"Total travel for this WP",{"$f":"C352+C353+C354","v":4800},null,null,0,null,null,null,"F-18"]
[]
[null,null,null,"Total travel costs (all WPs)",null,{"$f":"WP_B1_1_subTotal+WP_B2_1_subTotal+WP_B3_1_subTotal+WP_B4_1_subTotal+WP_B5_1_subTotal+WP_B6_1_subTotal","v":32400},null,null,null,"F-24",null,null,"Shown"]
[null,null,null,"Total accomodation (all WPs)",null,{"$f":"WP_B1_2_subTotal+WP_B2_2_subTotal+WP_B3_2_subTotal+WP_B4_2_subTotal+WP_B5_2_subTotal+WP_B6_2_subTotal","v":2000},null,null,null,"F-24",null,null,"Shown"]
[null,null,null,"Total subsistence (all WPs)",null,{"$f":"WP_B1_3_subTotal+WP_B2_3_subTotal+WP_B3_3_subTotal+WP_B4_3_subTotal+WP_B5_3_subTotal+WP_B6_3_subTotal","v":2400},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":36800},null,null,null,"F-24"]
["C.2 Equipment",null,null,null,null,null,null,null,null,"F-24"]
["WORK PACKAGE 1",{"$f":"IDX_WP_Name_1","v":"PROJECT MANAGEMENT"},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(D369=0,0,((E369/D369)*F369)*C369)","v":0},null,null,"Last","3#4#5#6","2#8#9"]
[null,"2 [Equipment short name]",0,0,0,0,{"$f":"IF(D370=0,0,((E370/D370)*F370)*C370)","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":"C371","v":0},null,null,"Last","3","2#8#9","HR"]
[null,"Total depreciation  ",null,null,null,null,{"$f":"SUM(G368:G371)","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":"C377*D377*F377","v":0},null,null,"Last","3#4#5#6","2#8#9"]
[null,"2 [Equipment short name]",0,0,null,0,{"$f":"C378*D378*F378","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":"C379","v":0},null,null,"Last","3","2#8#9"]
[null,"Total rental and leasing",null,null,null,null,{"$f":"SUM(G376:G379)","v":0},null,null,"F-18"]
[null,"Total equipment for this WP",null,null,null,null,{"$f":"G380+G372","v":0},null,null,"F-18"]
["WORK PACKAGE 2",{"$f":"IDX_WP_Name_2","v":"PLANNING"},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(D389=0,0,((E389/D389)*F389)*C389)","v":0},null,null,"Last","3#4#5#6","2#8#9"]
[null,"2 [Equipment short name]",0,0,0,0,{"$f":"IF(D390=0,0,((E390/D390)*F390)*C390)","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":"C391","v":0},null,null,"Last","3","2#8#9","HR"]
[null,"Total depreciation  ",null,null,null,null,{"$f":"SUM(G388:G391)","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":"C397*D397*F397","v":0},null,null,"Last","3#4#5#6","2#8#9"]
[null,"2 [Equipment short name]",0,0,null,0,{"$f":"C398*D398*F398","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":"C399","v":0},null,null,"Last","3","2#8#9"]
[null,"Total rental and leasing",null,null,null,null,{"$f":"SUM(G396:G399)","v":0},null,null,"F-18"]
[null,"Total equipment for this WP",null,null,null,null,{"$f":"G400+G392","v":0},null,null,"F-18"]
["WORK PACKAGE 3",{"$f":"IDX_WP_Name_3","v":"EXERCISE CONDUCT"},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(D409=0,0,((E409/D409)*F409)*C409)","v":0},null,null,"Last","3#4#5#6","2#8#9"]
[null,"2 [Equipment short name]",0,0,0,0,{"$f":"IF(D410=0,0,((E410/D410)*F410)*C410)","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":"C411","v":0},null,null,"Last","3","2#8#9","HR"]
[null,"Total depreciation  ",null,null,null,null,{"$f":"SUM(G408:G411)","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":"C417*D417*F417","v":0},null,null,"Last","3#4#5#6","2#8#9"]
[null,"2 [Equipment short name]",0,0,null,0,{"$f":"C418*D418*F418","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":"C419","v":0},null,null,"Last","3","2#8#9"]
[null,"Total rental and leasing",null,null,null,null,{"$f":"SUM(G416:G419)","v":0},null,null,"F-18"]
[null,"Total equipment for this WP",null,null,null,null,{"$f":"G420+G412","v":0},null,null,"F-18"]
["WORK PACKAGE 4",{"$f":"IDX_WP_Name_4","v":"DISSEMINATION & VISIBILITY"},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(D429=0,0,((E429/D429)*F429)*C429)","v":0},null,null,"Last","3#4#5#6","2#8#9"]
[null,"2 [Equipment short name]",0,0,0,0,{"$f":"IF(D430=0,0,((E430/D430)*F430)*C430)","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":"C431","v":0},null,null,"Last","3","2#8#9","HR"]
[null,"Total depreciation  ",null,null,null,null,{"$f":"SUM(G428:G431)","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":"C437*D437*F437","v":0},null,null,"Last","3#4#5#6","2#8#9"]
[null,"2 [Equipment short name]",0,0,null,0,{"$f":"C438*D438*F438","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":"C439","v":0},null,null,"Last","3","2#8#9"]
[null,"Total rental and leasing",null,null,null,null,{"$f":"SUM(G436:G439)","v":0},null,null,"F-18"]
[null,"Total equipment for this WP",null,null,null,null,{"$f":"G440+G432","v":0},null,null,"F-18"]
["WORK PACKAGE 5",{"$f":"IDX_WP_Name_5","v":"EVALUATION"},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(D449=0,0,((E449/D449)*F449)*C449)","v":0},null,null,"Last","3#4#5#6","2#8#9"]
[null,"2 [Equipment short name]",0,0,0,0,{"$f":"IF(D450=0,0,((E450/D450)*F450)*C450)","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":"C451","v":0},null,null,"Last","3","2#8#9","HR"]
[null,"Total depreciation  ",null,null,null,null,{"$f":"SUM(G448:G451)","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,"Evaluation Tool licence",1500,0.75,null,1,{"$f":"C457*D457*F457","v":1125},"YES WP3","renting cost of an evaluation IT tool (licences for all evaluators)","Last","3#4#5#6","2#8#9"]
[null,"2 [Equipment short name]",0,0,null,0,{"$f":"C458*D458*F458","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":"C459","v":0},null,null,"Last","3","2#8#9"]
[null,"Total rental and leasing",null,null,null,null,{"$f":"SUM(G456:G459)","v":1125},null,null,"F-18"]
[null,"Total equipment for this WP",null,null,null,null,{"$f":"G460+G452","v":1125},null,null,"F-18"]
["WORK PACKAGE 6",{"$f":"IDX_WP_Name_6","v":"WAY FORWARD WORKSHOPS AND SEMINARS"},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(D469=0,0,((E469/D469)*F469)*C469)","v":0},null,null,"Last","3#4#5#6","2#8#9"]
[null,"2 [Equipment short name]",0,0,0,0,{"$f":"IF(D470=0,0,((E470/D470)*F470)*C470)","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":"C471","v":0},null,null,"Last","3","2#8#9","HR"]
[null,"Total depreciation  ",null,null,null,null,{"$f":"SUM(G468:G471)","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":"C477*D477*F477","v":0},null,null,"Last","3#4#5#6","2#8#9"]
[null,"2 [Equipment short name]",0,0,null,0,{"$f":"C478*D478*F478","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":"C479","v":0},null,null,"Last","3","2#8#9"]
[null,"Total rental and leasing",null,null,null,null,{"$f":"SUM(G476:G479)","v":0},null,null,"F-18"]
[null,"Total equipment for this WP",null,null,null,null,{"$f":"G480+G472","v":0},null,null,"F-18"]
[]
["Total equipment (all WPs)",null,null,null,null,null,{"$f":"WP_E11_Total+WP_E12_Total+WP_E13_Total+WP_E14_Total+WP_E15_Total+WP_E16_Total","v":1125},null,null,"F-24"]
["C.3 Other goods, works and services",null,null,null,null,null,null,null,null,"F-24"]
["WORK PACKAGE 1",{"$f":"IDX_WP_Name_1","v":"PROJECT MANAGEMENT"},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(C488:C497)","v":0},null,null,null,null,null,null,"F-18"]
["WORK PACKAGE 2",{"$f":"IDX_WP_Name_2","v":"PLANNING"},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(C502:C511)","v":0},null,null,null,null,null,null,"F-18"]
["WORK PACKAGE 3",{"$f":"IDX_WP_Name_3","v":"EXERCISE CONDUCT"},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(C516:C525)","v":0},null,null,null,null,null,null,"F-18"]
["WORK PACKAGE 4",{"$f":"IDX_WP_Name_4","v":"DISSEMINATION & VISIBILITY"},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(C530:C539)","v":0},null,null,null,null,null,null,"F-18"]
["WORK PACKAGE 5",{"$f":"IDX_WP_Name_5","v":"EVALUATION"},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(C544:C553)","v":0},null,null,null,null,null,null,"F-18"]
["WORK PACKAGE 6",{"$f":"IDX_WP_Name_6","v":"WAY FORWARD WORKSHOPS AND SEMINARS"},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(C558:C567)","v":0},null,null,null,null,null,null,"F-18"]
[]
[null,"Total goods, works and services (all WPs)",{"$f":"WP_E21_Total+WP_E22_Total+WP_E23_Total+WP_E24_Total+WP_E25_Total+WP_E26_Total","v":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":37925},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  (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)'!B25","v":72825},null,null,null,null,null,null,"F-24",null,null,"Shown"]
[null,"Flat-rate (%)",7.0000000000000007E-2,null,null,null,null,null,null,"F-24",null,null,"Shown"]
[null,"Total indirect costs",{"$f":"C603*C604","v":5097.7500000000009},null,null,null,null,null,null,"F-24",null,null,"Shown"]
[null,"Total indirect costs ",{"$f":"C605","v":5097.7500000000009},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":"C603+C605+'4. Consolid table (participant)'!D22","v":77922.75},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":"H612","v":77922.75},null,null,null,null,null,null,"F-24"]
[null,"Single Funding rate (%)",0.85,null,null,null,null,null,null,"F-24",null,null,"Shown"]
[null,{"$f":"\"Multiple funding rates (%) =\n \"& 'EC Data'!B77","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'!E92,C618*C619)","v":66234.337499999994},null,null,null,null,null,null,"F-24"]
[null,"Requested EU contribution ",66234,null,null,null,null,null,null,"F-24"]
[null,"EU CONTRIBUTION",{"$f":"C622","v":66234},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(C628)","v":0},null,null,null,null,null,null,"F-24"]
["Revenues",null,{"$f":"C629","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(C634)","v":0},null,null,null,null,null,null,"F-24"]
[null,"In-kind contributions",{"$f":"SUM(C635)","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(C640)","v":0},null,null,null,null,null,null,"F-24"]
[null,"Financial contributions",{"$f":"SUM(C641)","v":0},null,null,null,null,null,null,"F-24"]
[null,"TOTAL REVENUES AND CONTRIBUTIONS BY THIRD PARTIES   ",{"$f":"C642+C636+C630","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":"H612-C623-C643","v":11688.75},null,null,null,null,null,null,"F-24"]
[null,"OWN RESOURCES",{"$f":"SUM(C646)","v":11688.75},null,null,null,null,null,null,"F-24"]
[null,"TOTAL INCOME PARTICIPANT",{"$f":"C623+C643+C647","v":77922.75},null,null,null,null,null,null,"F-24"]

{"sheet":"4. Consolid table (participant)","index":6,"n_rows":25,"n_cols":23,"rows_kept":25,"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]]}
["EU GRANTS DETAILED BUDGET TABLE (ACTION GRANTS)"]
[]
["Project number:",{"$f":"IF(ISBLANK('2. Start'!C4),\" \",'2. Start'!C4)","v":210747735}]
["Project acronym:",{"$f":"IF(ISBLANK('2. Start'!C5),\" \",'2. Start'!C5)","v":"FORMATEX23"}]
["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 Accomodation","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"]
[{"$f":"\"WP1 \" & IDX_WP_Name_1","v":"WP1 PROJECT MANAGEMENT"},{"$f":"WP_A1_1_subTotal+WP_A1_2_subTotal","v":17400},{"$f":"WP_A1_3_subTotal","v":0},{"$f":"WP_A1_4_subTotal","v":0},{"$f":"WP_A1_5_subTotal","v":0},{"$f":"WP_A1_6_subTotal","v":0},{"$f":"WP_C1_Total","v":0},{"$f":"WP_B1_1_subTotal+WP_B1_2_subTotal+WP_B1_3_subTotal","v":1900},{"$f":"WP_B1_1_subTotal","v":1100},{"$f":"WP_B1_2_subTotal","v":500},{"$f":"WP_B1_3_subTotal","v":300},{"$f":"WP_E11_Total","v":0},{"$f":"WP_E21_Total","v":0},"N/A","N/A","N/A","N/A","N/A","N/A",null,{"$f":"WP_A1_1_subTotal+WP_A1_2_subTotal+WP_A1_3_subTotal+WP_A1_4_subTotal+WP_A1_5_subTotal+WP_A1_6_subTotal+WP_C1_Total+WP_B1_1_subTotal+WP_B1_2_subTotal+WP_B1_3_subTotal+WP_E11_Total+WP_E21_Total","v":19300},null,"Shown"]
[{"$f":"\"WP2 \" & IDX_WP_Name_2","v":"WP2 PLANNING"},{"$f":"WP_A2_1_subTotal+WP_A2_2_subTotal","v":0},{"$f":"WP_A2_3_subTotal","v":0},{"$f":"WP_A2_4_subTotal","v":0},{"$f":"WP_A2_5_subTotal","v":0},{"$f":"WP_A2_6_subTotal","v":0},{"$f":"WP_C2_Total","v":0},{"$f":"WP_B2_1_subTotal+WP_B2_2_subTotal+WP_B2_3_subTotal","v":5100},{"$f":"WP_B2_1_subTotal","v":2700},{"$f":"WP_B2_2_subTotal","v":1500},{"$f":"WP_B2_3_subTotal","v":900},{"$f":"WP_E12_Total","v":0},{"$f":"WP_E22_Total","v":0},"N/A","N/A","N/A","N/A","N/A","N/A",null,{"$f":"WP_A2_1_subTotal+WP_A2_2_subTotal+WP_A2_3_subTotal+WP_A2_4_subTotal+WP_A2_5_subTotal+WP_A2_6_subTotal+WP_C2_Total+WP_B2_1_subTotal+WP_B2_2_subTotal+WP_B2_3_subTotal+WP_E12_Total+WP_E22_Total","v":5100},null,"Shown"]
[{"$f":"\"WP3 \" & IDX_WP_Name_3","v":"WP3 EXERCISE CONDUCT"},{"$f":"WP_A3_1_subTotal+WP_A3_2_subTotal","v":17500},{"$f":"WP_A3_3_subTotal","v":0},{"$f":"WP_A3_4_subTotal","v":0},{"$f":"WP_A3_5_subTotal","v":0},{"$f":"WP_A3_6_subTotal","v":0},{"$f":"WP_C3_Total","v":0},{"$f":"WP_B3_1_subTotal+WP_B3_2_subTotal+WP_B3_3_subTotal","v":25000},{"$f":"WP_B3_1_subTotal","v":25000},{"$f":"WP_B3_2_subTotal","v":0},{"$f":"WP_B3_3_subTotal","v":0},{"$f":"WP_E13_Total","v":0},{"$f":"WP_E23_Total","v":0},"N/A","N/A","N/A","N/A","N/A","N/A",null,{"$f":"WP_A3_1_subTotal+WP_A3_2_subTotal+WP_A3_3_subTotal+WP_A3_4_subTotal+WP_A3_5_subTotal+WP_A3_6_subTotal+WP_C3_Total+WP_B3_1_subTotal+WP_B3_2_subTotal+WP_B3_3_subTotal+WP_E13_Total+WP_E23_Total","v":42500},null,"Shown"]
[{"$f":"\"WP4 \" & IDX_WP_Name_4","v":"WP4 DISSEMINATION & VISIBILITY"},{"$f":"WP_A4_1_subTotal+WP_A4_2_subTotal","v":0},{"$f":"WP_A4_3_subTotal","v":0},{"$f":"WP_A4_4_subTotal","v":0},{"$f":"WP_A4_5_subTotal","v":0},{"$f":"WP_A4_6_subTotal","v":0},{"$f":"WP_C4_Total","v":0},{"$f":"WP_B4_1_subTotal+WP_B4_2_subTotal+WP_B4_3_subTotal","v":0},{"$f":"WP_B4_1_subTotal","v":0},{"$f":"WP_B4_2_subTotal","v":0},{"$f":"WP_B4_3_subTotal","v":0},{"$f":"WP_E14_Total","v":0},{"$f":"WP_E24_Total","v":0},"N/A","N/A","N/A","N/A","N/A","N/A",null,{"$f":"WP_A4_1_subTotal+WP_A4_2_subTotal+WP_A4_3_subTotal+WP_A4_4_subTotal+WP_A4_5_subTotal+WP_A4_6_subTotal+WP_C4_Total+WP_B4_1_subTotal+WP_B4_2_subTotal+WP_B4_3_subTotal+WP_E14_Total+WP_E24_Total","v":0},null,"Shown"]
[{"$f":"\"WP5 \" & IDX_WP_Name_5","v":"WP5 EVALUATION"},{"$f":"WP_A5_1_subTotal+WP_A5_2_subTotal","v":0},{"$f":"WP_A5_3_subTotal","v":0},{"$f":"WP_A5_4_subTotal","v":0},{"$f":"WP_A5_5_subTotal","v":0},{"$f":"WP_A5_6_subTotal","v":0},{"$f":"WP_C5_Total","v":0},{"$f":"WP_B5_1_subTotal+WP_B5_2_subTotal+WP_B5_3_subTotal","v":0},{"$f":"WP_B5_1_subTotal","v":0},{"$f":"WP_B5_2_subTotal","v":0},{"$f":"WP_B5_3_subTotal","v":0},{"$f":"WP_E15_Total","v":1125},{"$f":"WP_E25_Total","v":0},"N/A","N/A","N/A","N/A","N/A","N/A",null,{"$f":"WP_A5_1_subTotal+WP_A5_2_subTotal+WP_A5_3_subTotal+WP_A5_4_subTotal+WP_A5_5_subTotal+WP_A5_6_subTotal+WP_C5_Total+WP_B5_1_subTotal+WP_B5_2_subTotal+WP_B5_3_subTotal+WP_E15_Total+WP_E25_Total","v":1125},null,"Shown"]
[{"$f":"\"WP6 \" & IDX_WP_Name_6","v":"WP6 WAY FORWARD WORKSHOPS AND SEMINARS"},{"$f":"WP_A6_1_subTotal+WP_A6_2_subTotal","v":0},{"$f":"WP_A6_3_subTotal","v":0},{"$f":"WP_A6_4_subTotal","v":0},{"$f":"WP_A6_5_subTotal","v":0},{"$f":"WP_A6_6_subTotal","v":0},{"$f":"WP_C6_Total","v":0},{"$f":"WP_B6_1_subTotal+WP_B6_2_subTotal+WP_B6_3_subTotal","v":4800},{"$f":"WP_B6_1_subTotal","v":3600},{"$f":"WP_B6_2_subTotal","v":0},{"$f":"WP_B6_3_subTotal","v":1200},{"$f":"WP_E16_Total","v":0},{"$f":"WP_E26_Total","v":0},"N/A","N/A","N/A","N/A","N/A","N/A",null,{"$f":"WP_A6_1_subTotal+WP_A6_2_subTotal+WP_A6_3_subTotal+WP_A6_4_subTotal+WP_A6_5_subTotal+WP_A6_6_subTotal+WP_C6_Total+WP_B6_1_subTotal+WP_B6_2_subTotal+WP_B6_3_subTotal+WP_E16_Total+WP_E26_Total","v":4800},null,"Shown"]
[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:B21)","v":34900},0,0,0,0,0,36800,32400,2000,2400,1125,0,0,0,0,0,0,0,{"$f":"WP_F_Total","v":5097.7500000000009},{"$f":"(B22+C22+D22+E22+F22+G22+I22+J22+K22+L22+M22+N22+O22+P22+Q22+R22+T22)","v":77922.75},null,"F-24"]
[]
[]
["Total eligible costs (for controls)",{"$f":"B22+C22+E22+F22+G22+L22+M22+N22+O22+P22+Q22+R22+I22+J22+K22+S22","v":72825}]

{"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]]}
["EU GRANTS DETAILED BUDGET TABLE (ACTION GRANTS)"]
[]
["Project number:",{"$f":"IF(ISBLANK('2. Start'!C4),\" \",'2. Start'!C4)","v":210747735}]
["Project acronym:",{"$f":"IF(ISBLANK('2. Start'!C5),\" \",'2. Start'!C5)","v":"FORMATEX23"}]
[]
["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 Accomodation","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","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: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: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: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: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: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:T21)","v":0}]