{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["1.HE_Gantt","2.Overall_budgetHE","3.Personnel_effort_Part 1","3.Personnel_effort_Part 2","4.Other_direct_costs"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"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":"1.HE_Gantt","index":0,"n_rows":50,"n_cols":39,"rows_kept":50,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"Year",1,null,null,null,null,null,null,null,null,null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,"Project Month",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36]
[null,"Activities ▿","Leader","Leader"]
[null,"WP1:  Project Management","TBD"]
[null,"Task 1.1 Task Name","TBD"]
[null,"Task 1.2 Task Name","TBD"]
[null,"Task 1.3 Task Name","TBD"]
[null,"Task 1.4 Task Name","TBD"]
[null,"Task 1.5 Task Name","TBD"]
[null,"WP2:  TBD ","TBD"]
[null,"Task 2.1  Task Name","TBD"]
[null,"Task 2.2  Task Name","TBD"]
[null,"Task 2.3  Task Name","TBD"]
[null,"Task 2.4  Task Name","TBD"]
[null,"Task 2.5  Task Name","TBD"]
[null,"WP3:  TBD","TBD"]
[null,"Task 3.1  Task Name","TBD"]
[null,"Task 3.2  Task Name","TBD"]
[null,"Task 3.3  Task Name","TBD"]
[null,"Task 3.4  Task Name","TBD"]
[null,"Task 3.5  Task Name","TBD"]
[null,"WP4:  TBD","TBD"]
[null,"Task 4.1  Task Name","TBD"]
[null,"Task 4.2  Task Name","TBD"]
[null,"Task 4.3  Task Name","TBD"]
[null,"Task 4.4  Task Name","TBD"]
[null,"Task 4.5  Task Name","TBD"]
[null,"WP5:  TBD","TBD"]
[null,"Task 5.1  Task Name","TBD"]
[null,"Task 5.2  Task Name","TBD"]
[null,"Task 5.3  Task Name","TBD"]
[null,"Task 5.4  Task Name","TBD"]
[null,"WP6:  TBD","TBD"]
[null,"Task 6.1  Task Name","TBD"]
[null,"Task 6.2  Task Name","TBD"]
[null,"Task 6.3  Task Name","TBD"]
[null,"Task 6.4  Task Name","TBD"]
[null,"Task 6.5  Task Name","TBD"]
[null,"WP7:  Impact assessment, LCA & TCO","TBD"]
[null,"Task 7.1  Task Name","TBD"]
[null,"Task 7.2  Task Name","TBD"]
[null,"Task 7.3  Task Name","TBD"]
[null,"Task 7.4  Task Name","TBD"]
[null,"Task 7.5  Task Name","TBD"]
[null,null," = Execution"]
[null,null," = Preparation & execution"]
[null,"✪"," = Event"]
[null,"⚑"," = Milestone"]

{"sheet":"2.Overall_budgetHE","index":1,"n_rows":10,"n_cols":25,"rows_kept":10,"cut":false,"hidden":false,"merged":[[4,5,4,17],[8,0,8,2],[4,3,5,3],[4,4,5,4],[4,1,5,1],[4,2,5,2],[1,3,2,17],[2,22,2,23],[2,18,2,21],[1,18,1,23],[3,3,3,17],[3,18,3,21],[4,23,5,23],[4,24,5,24],[4,18,5,18],[4,19,5,19],[4,20,5,20],[4,21,5,21],[4,22,5,22]]}
["Overall budget (as to be inserted in the proposal)"]
[null,null,null,"Estimated expenditures",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Estimated income"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Requested EU contribution",null,null,null,"Other sources of financing"]
[null,null,null,"Estimated eligible costs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EU contribution to eligible costs",null,null,null,"Financial contributions","Own resources"]
[null,"Partcipant name","Country","A. Personnel costs","B. Other Expenses","C. Purchase costs",null,null,null,null,null,null,null,null,null,null,null,null,"Total eligible costs ","Funding rate","% of overall budget","Maximum  contribution to eligible costs","Requested TIP contribution to eligible costs (Requested Grant amount)","Financial Contributions","Own resources"]
["#",null,null,null,null,"C.1 Travel and subsistence","C.2 Equipment","C.3 Depreciation","C.4 Other goods, works and services","C.4 Sub-contracting cost","D.1 Financial support to third parties (Actual costs)","D.2 Internally invoiced goods and services (Unit costs - usual accounting practices)","D.3 Transnational access to research infrastructures","D.4 Virtual access to research infrastructure","D.5. PCP/PPI procurement costs (actual costs)","D.6 Euratom Cofund staff mobility costs (Unit costs)","D.7 ERC additional funding (Actual costs)","C.5 Sub-contracting cost"]
[1,"TBD","TBD",{"$f":"'3.Personnel_effort_Part 1'!D77","v":0},{"$f":"'4.Other_direct_costs'!B13","v":0},{"$f":"'4.Other_direct_costs'!B8","v":0},{"$f":"'4.Other_direct_costs'!B9","v":0},{"$f":"'4.Other_direct_costs'!B10","v":0},{"$f":"'4.Other_direct_costs'!B11","v":0},{"$f":"'4.Other_direct_costs'!C11","v":0},{"$f":"'4.Other_direct_costs'!D11","v":0},{"$f":"'4.Other_direct_costs'!E11","v":0},{"$f":"'4.Other_direct_costs'!F11","v":0},{"$f":"'4.Other_direct_costs'!G11","v":0},{"$f":"'4.Other_direct_costs'!H11","v":0},{"$f":"'4.Other_direct_costs'!I11","v":0},{"$f":"'4.Other_direct_costs'!J11","v":0},{"$f":"'4.Other_direct_costs'!B12","v":0},{"$f":"D7+E7","v":0},null,{"$f":"S7/S9","v":{"$error":"#DIV/0!"}},{"$f":"V9*U7","v":{"$error":"#DIV/0!"}},{"$f":"IF(S7<V7,S7,V7)","v":{"$error":"#DIV/0!"}}]
[2,"TBD","TBD",{"$f":"'3.Personnel_effort_Part 2'!D77","v":0},{"$f":"'4.Other_direct_costs'!B21","v":0},{"$f":"'4.Other_direct_costs'!B16","v":0},{"$f":"'4.Other_direct_costs'!B17","v":0},{"$f":"'4.Other_direct_costs'!B18","v":0},{"$f":"'4.Other_direct_costs'!B19","v":0},{"$f":"'4.Other_direct_costs'!C19","v":0},{"$f":"'4.Other_direct_costs'!D19","v":0},{"$f":"'4.Other_direct_costs'!E19","v":0},{"$f":"'4.Other_direct_costs'!F19","v":0},{"$f":"'4.Other_direct_costs'!G19","v":0},{"$f":"'4.Other_direct_costs'!H19","v":0},{"$f":"'4.Other_direct_costs'!I19","v":0},{"$f":"'4.Other_direct_costs'!J19","v":0},{"$f":"'4.Other_direct_costs'!B20","v":0},{"$f":"D8+E8","v":0},null,{"$f":"S8/S9","v":{"$error":"#DIV/0!"}},{"$f":"U8*V9","v":{"$error":"#DIV/0!"}},{"$f":"IF(S8<V8,S8,V8)","v":{"$error":"#DIV/0!"}}]
["TOTALS",null,null,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,{"$f":"SUM(S7:S8)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(W7:W8)","v":{"$error":"#DIV/0!"}}]

{"sheet":"3.Personnel_effort_Part 1","index":2,"n_rows":77,"n_cols":40,"rows_kept":77,"cut":false,"hidden":false,"merged":[[0,4,3,39],[73,0,73,1]]}
["Detailed personnel effort per task",null,null,null,"Please fill in the effort per men.month in the table below"]
[]
[]
["PART NAME"]
["Activities","Part Inv.","SUBTOTAL (PMs)","%",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36]
["WP1:  Project Management","TBD",{"$f":"SUM(C7:C9)","v":0},{"$f":"C6/$C$74","v":{"$error":"#DIV/0!"}}]
["Task 1.1 ","TBD",{"$f":"SUM(E7:AN7)","v":0},{"$f":"C7/$C$74","v":{"$error":"#DIV/0!"}}]
["Task 1.2 ","TBD",{"$f":"SUM(E8:AN8)","v":0},{"$error":"#DIV/0!"}]
["Task 1.3 ","TBD",0,{"$error":"#DIV/0!"}]
["Task 1.4 Task Name","TBD",0,{"$error":"#DIV/0!"}]
["Task 1.5 Task Name","TBD",0,{"$error":"#DIV/0!"}]
["Task 1.6 Task Name","TBD",0,{"$error":"#DIV/0!"}]
["Task 1.7 Task Name","TBD",0,{"$error":"#DIV/0!"}]
["Task 1.8 Task Name","TBD",0,{"$error":"#DIV/0!"}]
["WP2:  TBD ","TBD",{"$f":"SUM(C16:C20)","v":0},{"$error":"#DIV/0!"}]
["Task 2.1  Task Name","TBD",0,{"$error":"#DIV/0!"}]
["Task 2.2  Task Name","TBD",0,{"$error":"#DIV/0!"}]
["Task 2.3  Task Name","TBD",0,{"$error":"#DIV/0!"}]
["Task 2.4  Task Name","TBD",0,{"$error":"#DIV/0!"}]
["Task 2.5  Task Name","TBD",0,{"$error":"#DIV/0!"}]
["Task 2.6 Task Name","TBD",0,{"$error":"#DIV/0!"}]
["Task 2.7 Task Name","TBD",0,{"$error":"#DIV/0!"}]
["Task 2.8 Task Name","TBD",0,{"$error":"#DIV/0!"}]
["WP3:  TBD","TBD",{"$f":"SUM(C25:C29)","v":0},{"$error":"#DIV/0!"}]
["Task 3.1  Task Name","TBD",0,{"$error":"#DIV/0!"}]
["Task 3.2  Task Name","TBD",0,{"$error":"#DIV/0!"}]
["Task 3.3  Task Name","TBD",0,{"$error":"#DIV/0!"}]
["Task 3.4  Task Name","TBD",0,{"$error":"#DIV/0!"}]
["Task 3.5  Task Name","TBD",0,{"$error":"#DIV/0!"}]
["Task 3.7 Task Name","TBD",0,{"$error":"#DIV/0!"}]
["Task 3.8 Task Name","TBD",0,{"$error":"#DIV/0!"}]
["WP4:  TBD","TBD",{"$f":"SUM(C33:C37)","v":0},{"$error":"#DIV/0!"}]
["Task 4.1  Task Name","TBD",0,{"$error":"#DIV/0!"}]
["Task 4.2  Task Name","TBD",0,{"$error":"#DIV/0!"}]
["Task 4.3  Task Name","TBD",0,{"$error":"#DIV/0!"}]
["Task 4.4  Task Name","TBD",0,{"$error":"#DIV/0!"}]
["Task 4.5  Task Name","TBD",0,{"$error":"#DIV/0!"}]
["Task 4.5 Task Name","TBD",0,{"$error":"#DIV/0!"}]
["Task 4.6 Task Name","TBD",0,{"$error":"#DIV/0!"}]
["Task 4.7 Task Name","TBD",0,{"$error":"#DIV/0!"}]
["Task 4.8 Task Name","TBD",0,{"$error":"#DIV/0!"}]
["WP5:  TBD","TBD",{"$f":"SUM(C43:C47)","v":0},{"$error":"#DIV/0!"}]
["Task 5.1  Task Name","TBD",0,{"$error":"#DIV/0!"}]
["Task 5.2  Task Name","TBD",0,{"$error":"#DIV/0!"}]
["Task 5.3  Task Name","TBD",0,{"$error":"#DIV/0!"}]
["Task 5.4  Task Name","TBD",0,{"$error":"#DIV/0!"}]
["Task 5.5  Task Name","TBD",0,{"$error":"#DIV/0!"}]
["Task 5.6 Task Name","TBD",0,{"$error":"#DIV/0!"}]
["Task 5.7 Task Name","TBD",0,{"$error":"#DIV/0!"}]
["Task 5.8 Task Name","TBD",0,{"$error":"#DIV/0!"}]
["WP6:  TBD","TBD",{"$f":"SUM(C52:C56)","v":0},{"$error":"#DIV/0!"}]
["Task 6.1  Task Name","TBD",0,{"$error":"#DIV/0!"}]
["Task 6.2  Task Name","TBD",0,{"$error":"#DIV/0!"}]
["Task 6.3  Task Name","TBD",0,{"$error":"#DIV/0!"}]
["Task 6.4  Task Name","TBD",0,{"$error":"#DIV/0!"}]
["Task 6.5  Task Name","TBD",0,{"$error":"#DIV/0!"}]
["Task 6.5 Task Name","PT6",0,{"$error":"#DIV/0!"}]
["Task 6.6 Task Name","PT7",0,{"$error":"#DIV/0!"}]
["Task 6.7 Task Name","PT8",0,{"$error":"#DIV/0!"}]
["Task 6.8 Task Name","PT9",0,{"$error":"#DIV/0!"}]
["WP7: TBD","TBD",{"$f":"SUM(C62:C66)","v":0},{"$error":"#DIV/0!"}]
["Task 7.1  Task Name","TBD",0,{"$error":"#DIV/0!"}]
["Task 7.2  Task Name","TBD",0,{"$error":"#DIV/0!"}]
["Task 7.3  Task Name","TBD",0,{"$error":"#DIV/0!"}]
["Task 7.4  Task Name","TBD",0,{"$error":"#DIV/0!"}]
["Task 7.5  Task Name","TBD",0,{"$error":"#DIV/0!"}]
["Task 7.6 Task Name","PT7",0,{"$error":"#DIV/0!"}]
["Task 7.7 Task Name","PT8",0,{"$error":"#DIV/0!"}]
["Task 7.8 Task Name","PT9",0,{"$error":"#DIV/0!"}]
["Task 8.5 Task Name","PT6",0,{"$error":"#DIV/0!"}]
["Task 8.6 Task Name","PT7",0,{"$error":"#DIV/0!"}]
["Task 8.7 Task Name","PT8",0,{"$error":"#DIV/0!"}]
["Task 8.8 Task Name","PT9",0,{"$error":"#DIV/0!"}]
["Total PMs",null,{"$f":"SUM(C61+C51+C42+C32+C24+C15+C6)","v":0}]
[]
["Average monthly personnel rate.  Please change with the value provided by the partner."]
["Total HR Cost",null,null,{"$f":"D76*C74","v":0}]

{"sheet":"3.Personnel_effort_Part 2","index":3,"n_rows":77,"n_cols":40,"rows_kept":77,"cut":false,"hidden":false,"merged":[[0,4,3,39],[73,0,73,1]]}
["Detailed personnel effort per task",null,null,null,"Please fill in the effort per men.month in the table below"]
[]
[]
["PART NAME"]
["Activities","Part Inv.","SUBTOTAL (PMs)","%",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36]
["WP1:  Project Management","TBD",{"$f":"SUM(C7:C9)","v":0},{"$f":"C6/$C$74","v":{"$error":"#DIV/0!"}}]
["Task 1.1 ","TBD",{"$f":"SUM(E7:AN7)","v":0},{"$f":"C7/$C$74","v":{"$error":"#DIV/0!"}}]
["Task 1.2 ","TBD",{"$f":"SUM(E8:AN8)","v":0},{"$error":"#DIV/0!"}]
["Task 1.3 ","TBD",0,{"$error":"#DIV/0!"}]
["Task 1.4 Task Name","TBD",0,{"$error":"#DIV/0!"}]
["Task 1.5 Task Name","TBD",0,{"$error":"#DIV/0!"}]
["Task 1.6 Task Name","TBD",0,{"$error":"#DIV/0!"}]
["Task 1.7 Task Name","TBD",0,{"$error":"#DIV/0!"}]
["Task 1.8 Task Name","TBD",0,{"$error":"#DIV/0!"}]
["WP2:  TBD ","TBD",{"$f":"SUM(C16:C20)","v":0},{"$error":"#DIV/0!"}]
["Task 2.1  Task Name","TBD",0,{"$error":"#DIV/0!"}]
["Task 2.2  Task Name","TBD",0,{"$error":"#DIV/0!"}]
["Task 2.3  Task Name","TBD",0,{"$error":"#DIV/0!"}]
["Task 2.4  Task Name","TBD",0,{"$error":"#DIV/0!"}]
["Task 2.5  Task Name","TBD",0,{"$error":"#DIV/0!"}]
["Task 2.6 Task Name","TBD",0,{"$error":"#DIV/0!"}]
["Task 2.7 Task Name","TBD",0,{"$error":"#DIV/0!"}]
["Task 2.8 Task Name","TBD",0,{"$error":"#DIV/0!"}]
["WP3:  TBD","TBD",{"$f":"SUM(C25:C29)","v":0},{"$error":"#DIV/0!"}]
["Task 3.1  Task Name","TBD",0,{"$error":"#DIV/0!"}]
["Task 3.2  Task Name","TBD",0,{"$error":"#DIV/0!"}]
["Task 3.3  Task Name","TBD",0,{"$error":"#DIV/0!"}]
["Task 3.4  Task Name","TBD",{"$f":"SUM(E28:AN28)","v":0},{"$error":"#DIV/0!"}]
["Task 3.5  Task Name","TBD",0,{"$error":"#DIV/0!"}]
["Task 3.7 Task Name","TBD",0,{"$error":"#DIV/0!"}]
["Task 3.8 Task Name","TBD",0,{"$error":"#DIV/0!"}]
["WP4:  TBD","TBD",{"$f":"SUM(C33:C37)","v":0},{"$error":"#DIV/0!"}]
["Task 4.1  Task Name","TBD",0,{"$error":"#DIV/0!"}]
["Task 4.2  Task Name","TBD",0,{"$error":"#DIV/0!"}]
["Task 4.3  Task Name","TBD",0,{"$error":"#DIV/0!"}]
["Task 4.4  Task Name","TBD",{"$f":"SUM(E36:AN36)","v":0},{"$error":"#DIV/0!"}]
["Task 4.5  Task Name","TBD",0,{"$error":"#DIV/0!"}]
["Task 4.5 Task Name","TBD",0,{"$error":"#DIV/0!"}]
["Task 4.6 Task Name","TBD",0,{"$error":"#DIV/0!"}]
["Task 4.7 Task Name","TBD",0,{"$error":"#DIV/0!"}]
["Task 4.8 Task Name","TBD",0,{"$error":"#DIV/0!"}]
["WP5:  TBD","TBD",{"$f":"SUM(C43:C47)","v":0},{"$error":"#DIV/0!"}]
["Task 5.1  Task Name","TBD",0,{"$error":"#DIV/0!"}]
["Task 5.2  Task Name","TBD",0,{"$error":"#DIV/0!"}]
["Task 5.3  Task Name","TBD",0,{"$error":"#DIV/0!"}]
["Task 5.4  Task Name","TBD",0,{"$error":"#DIV/0!"}]
["Task 5.5  Task Name","TBD",0,{"$error":"#DIV/0!"}]
["Task 5.6 Task Name","TBD",0,{"$error":"#DIV/0!"}]
["Task 5.7 Task Name","TBD",0,{"$error":"#DIV/0!"}]
["Task 5.8 Task Name","TBD",0,{"$error":"#DIV/0!"}]
["WP6:  TBD","TBD",{"$f":"SUM(C52:C56)","v":0},{"$error":"#DIV/0!"}]
["Task 6.1  Task Name","TBD",0,{"$error":"#DIV/0!"}]
["Task 6.2  Task Name","TBD",0,{"$error":"#DIV/0!"}]
["Task 6.3  Task Name","TBD",0,{"$error":"#DIV/0!"}]
["Task 6.4  Task Name","TBD",{"$f":"SUM(E55:AN55)","v":0},{"$error":"#DIV/0!"}]
["Task 6.5  Task Name","TBD",0,{"$error":"#DIV/0!"}]
["Task 6.5 Task Name","PT6",0,{"$error":"#DIV/0!"}]
["Task 6.6 Task Name","PT7",0,{"$error":"#DIV/0!"}]
["Task 6.7 Task Name","PT8",0,{"$error":"#DIV/0!"}]
["Task 6.8 Task Name","PT9",0,{"$error":"#DIV/0!"}]
["WP7: TBD","TBD",{"$f":"SUM(C62:C66)","v":0},{"$error":"#DIV/0!"}]
["Task 7.1  Task Name","TBD",0,{"$error":"#DIV/0!"}]
["Task 7.2  Task Name","TBD",0,{"$error":"#DIV/0!"}]
["Task 7.3  Task Name","TBD",0,{"$error":"#DIV/0!"}]
["Task 7.4  Task Name","TBD",0,{"$error":"#DIV/0!"}]
["Task 7.5  Task Name","TBD",0,{"$error":"#DIV/0!"}]
["Task 7.6 Task Name","PT7",0,{"$error":"#DIV/0!"}]
["Task 7.7 Task Name","PT8",0,{"$error":"#DIV/0!"}]
["Task 7.8 Task Name","PT9",0,{"$error":"#DIV/0!"}]
["Task 8.5 Task Name","PT6",0,{"$error":"#DIV/0!"}]
["Task 8.6 Task Name","PT7",0,{"$error":"#DIV/0!"}]
["Task 8.7 Task Name","PT8",0,{"$error":"#DIV/0!"}]
["Task 8.8 Task Name","PT9",0,{"$error":"#DIV/0!"}]
["Total PMs",null,{"$f":"SUM(C61+C51+C42+C32+C24+C15+C6)","v":0}]
[]
["Average monthly personnel rate.  Please change with the value provided by the partner."]
["Total HR Cost",null,null,{"$f":"D76*C74","v":0}]

{"sheet":"4.Other_direct_costs","index":4,"n_rows":29,"n_cols":3,"rows_kept":29,"cut":false,"hidden":false,"merged":[[2,0,2,2],[3,0,3,2]]}
["Other direct cost items"]
["Travel, Equipment, Goods and services"]
["Please complete the table below for each applicant\nOpen one line per expense\nPlease justify the reason of the expence / the WP it will be related to when relevant please specify the subcontactor name and provide an estimate\n"]
["Please DO NOT insert lines, as this file is automated; include the total cost per budget line (this also applies to LRI)"]
[]
[]
["PART 1","Cost (€)","Justification"]
["Travel"]
["Equipment"]
["Depreciation"]
["Other goods and services"]
["Sub-Contracting costs (test , study …)"]
["Total (€)",{"$f":"SUM(B8:B12)","v":0}]
[]
["PART 2","Cost (€)","Justification"]
["Travel"]
["Equipment"]
["Depreciation"]
["Other goods and services"]
["Sub-Contracting costs (test , study …)"]
["Total (€)",{"$f":"SUM(B16:B20)","v":0}]
[]
["PART 3","Cost (€)","Justification"]
["Travel"]
["Equipment"]
["Depreciation"]
["Other goods and services"]
["Sub-Contracting costs (test , study …)"]
["Total (€)",{"$f":"SUM(B24:B28)","v":0}]