{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Project budget","INFO"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":11,"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":"Project budget","index":0,"n_rows":119,"n_cols":152,"rows_kept":119,"cut":false,"hidden":false,"merged":[[118,10,118,12],[116,10,116,12],[114,10,114,12],[14,7,15,16],[13,13,13,16],[13,10,13,12],[15,3,15,6],[97,2,97,3],[48,2,48,7],[14,3,14,6],[13,3,13,6],[17,2,17,5],[91,2,91,7],[64,2,64,17],[32,2,32,5],[94,2,94,3],[95,2,95,3],[94,5,94,6],[95,5,95,6],[98,2,98,3],[99,2,99,3],[96,5,96,6],[97,5,97,6],[98,5,98,6],[96,2,96,3],[114,2,114,3],[114,4,114,5],[114,6,114,7],[112,2,112,3],[99,5,99,6],[104,2,104,3],[109,2,109,3],[111,2,111,3],[105,2,105,3],[102,2,102,9],[106,2,106,3],[110,2,110,3],[108,2,108,3],[107,2,107,3],[116,2,116,3],[116,4,116,5],[116,6,116,7],[118,2,118,3],[118,4,118,5],[118,6,118,7]]}
[]
[null,null,null,null,null,null,null,null,null,null,"F-SEE-120/02.2020",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Director/Project manager","Code ","Yes",null,"M"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Researcher/Teacher/Trainer",null,"No",null,"F",null,null,null,null,"100-499 km","D1",180]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Technical",null,null,null,null,null,null,null,null,"500-1999 km","D2",275]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Administrative",null,null,null,null,null,null,null,null,"2000-2999 km","D3",360]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Institution Role",null,null,"3000-3999 km","D4",530]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Country",null,null,null,null,null,"Project Promoter",null,null,"4000-7999 km","D5",820]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Host institution"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Manager","Teacher/Trainer/Researcher","Technician","Administrative staff"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Romania ",null,"RO",294,241,190,157,"O1","E1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Liechtenstein","LI",294,241,190,157]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Norway","NO",294,241,190,157,"O2","E2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Iceland","IS",280,214,162,131,"O3","E3"]
[null,null,"Project no.",null,null,null,null,null,null,null,"Intermediary Report"]
[null,null,"Project Title",null,null,null,null," Declaration of expenditure                                                                                                                                                                                         Projects in the field of school education                                                                                                                                                             Call for proposals 2018 Round 2        "]
[null,null,"Reporting period                       (dd/mm/yyyy-dd/mm/yyyy)"]
[]
[null,null,"1.Institutions involved in the project"]
[]
[null,null,"Name of the institution                                    (including Project Promoter)","Institution role in project","Country","Town"]
[null,null,null,"Project Promoter"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"2. Costs for the organisational support"]
[]
[null,null,"Name of the institution                                    (including the Project Promoter)","Institution role in project","Number of participants in mobility","Organisational support                Amount spent                                              (Euro)","Grant approved by  PO","Ineligible grant declared by PP","Comments",null,null,null,null,null,null,null,null,null,null,null,null,"Grant approved by  PO","Ineligible grant declared by PP","Comments"]
[null,null,null,{"$f":"D21","v":"Project Promoter"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,{"$f":"SUM(F37:F45)","v":0},{"$f":"SUM(G36:G45)","v":0},{"$f":"SUM(H36:H45)","v":0}]
[]
[]
[null,null,"3. Costs for the participation in structured courses -fees (if applicable)"]
[]
[null,null,"Name of the institution                             (course provider)                                   ","Structured course title ","Structured course period dd/mm/yyyy - dd/mm/yyyy","Duration                  (number of days          without travel days)","Number of participants","Structured courses Amount spent  (Euro)","Grant approved by  PO","Ineligible grant declared by PP","Comments"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Distance code","Distance band","Euro"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"D1","100-499 km",180]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"D2","500-1999 km",275]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"D3","2000-2999 km",360]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"D4","3000-3999 km",530]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"D5","4000-7999 km",820]
[]
[null,null,null,null,null,{"$f":"SUM(F52:F62)","v":0},{"$f":"SUM(G52:G62)","v":0},{"$f":"SUM(H52:H62)","v":0},{"$f":"SUM(I52:I62)","v":0},{"$f":"SUM(J52:J62)","v":0}]
[]
[null,null,"4. Mobility costs for participants"]
[]
[]
[]
[null,null,"Name of the host institution    \n","Destination country ","Participant name and surname","Gender","Type of mobility       ","Number of activity days (excluding travel days)  of              structured course","Number of activity days (excluding travel days)  of                     other (job shadowing, seminars, study visit)","Number of travel days      (if applicable)","Total number of days","Individual support spent (Euro)","Distance band","Travel - amount spent (Euro)          ","Linguistic support?","Grant for linguistic support - amount spent   (Euro) ","Accompanying person grant (only for special needs) amount spent","Total grant -amount spent","Grant approved by  PO","Ineligible grant declared by PP","Comments"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"H70+I70+J70","v":0},null,null,null,null,null,null,{"$f":"IF(E70>0,L70+N70+P70+Q70,\" \")","v":" "}]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,{"$f":"IF(E71>0,L71+N71+P71+Q71,\" \")","v":" "}]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K70:K87)","v":0},{"$f":"SUM(L70:L87)","v":0},null,{"$f":"SUM(N70:N87)","v":0},null,{"$f":"SUM(P70:P87)","v":0},{"$f":"SUM(Q70:Q87)","v":0},{"$f":"SUM(R70:R87)","v":0},{"$f":"SUM(S70:S87)","v":0},{"$f":"SUM(T70:T87)","v":0}]
[]
[]
[]
[null,null,"5. Special needs support (real costs)"]
[]
[null,null,"Name of the Project Promoter   ",null,"Participant name and surname  (with special needs)","Additional costs description",null,"Total grant -          amount spent (Euro)","Grant approved by  PO","Ineligible grant declared by PP","Comments"]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"SUM(H95:H99)","v":0},{"$f":"SUM(I95:I99)","v":0},{"$f":"SUM(J95:J99)","v":0}]
[]
[]
[null,null,"6. Budget Summary"]
[]
[null,null,"Expenditure",null,{"$f":"$C21","v":0},{"$f":"C22","v":0},{"$f":"$C23","v":0},{"$f":"$C24","v":0},{"$f":"$C25","v":0},"Total grant Amount spent (Euro)","Grant approved by  PO","Ineligible grant declared by PP","Comments"]
[null,null,"Organisational support (project promoter)",null,{"$f":"F36","v":0},null,null,null,null,{"$f":"E106","v":0}]
[null,null,"Organisational support ( host institutions)",null,null,{"$f":" SUMIF($C$36:$C$45,F105,$F$36:$H$45)","v":0},{"$f":" SUMIF($C$36:$C$45,G105,$F$36:$H$45)","v":0},{"$f":" SUMIF($C$36:$C$45,H105,$F$36:$H$45)","v":0},{"$f":" SUMIF($C$36:$C$45,I105,$F$36:$H$45)","v":0},{"$f":"SUM(F107:I107)","v":0}]
[null,null,"Course fees",null,null,{"$f":" SUMIF($C$52:$C$62,F105,$H$52:$H$62)","v":0},{"$f":" SUMIF($C$52:$C$62,G105,$H$52:$H$62)","v":0},{"$f":" SUMIF($C$52:$C$62,H105,$H$52:$H$62)","v":0},{"$f":" SUMIF($C$52:$C$62,I105,$H$52:$H$62)","v":0},{"$f":"SUM(F108:I108)","v":0}]
[null,null,"Individual support",null,{"$f":"L88","v":0},null,null,null,null,{"$f":"E109","v":0}]
[null,null," Travel costs",null,{"$f":"N88","v":0},null,null,null,null,{"$f":"E110","v":0}]
[null,null,"Linguistic support",null,{"$f":"P88","v":0},null,null,null,null,{"$f":"E111","v":0}]
[null,null,"Special needs",null,{"$f":"H100+Q88","v":0},null,null,null,null,{"$f":"E112","v":0}]
[null,null,"Total grant spent                    ",null,{"$f":"SUM(E106:E112)","v":0},{"$f":"F107+F108","v":0},{"$f":"G107+G108","v":0},0,0,{"$f":"SUM(J106:J112)","v":0},{"$f":"SUM(K106:K112)","v":0},{"$f":"SUM(L106:L112)","v":0}]
[]
[null,null,"Total grant awarded (according to the grant agreement signed with PO)",null,null,null,null,null,null,0]
[]
[null,null,"First advance payment",null,null,null,null,null,null,{"$f":"ROUND(J115*0.8,2)","v":0}]
[]
[null,null,"% spent grant out of first advance payment",null,null,null,null,null,null,{"$f":"ROUND(IF(J117>0,J113*100/J117,\" \"),2)","v":{"$error":"#VALUE!"}},{"$f":"ROUND(IF(K117>0,K113*100/K117,\" \"),2)","v":{"$error":"#VALUE!"}}]

{"sheet":"INFO","index":1,"n_rows":14,"n_cols":13,"rows_kept":14,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Distance band","Distance code","Euro",null,null,null,null,null,null,null,"Country ","Country code"]
[null,"100-499 km","D1",180,null,null,null,null,null,null,null,"Liechtenstein","LI"]
[null,"500-1999 km","D2",275,null,null,null,null,null,null,null,"Norway","NO"]
[null,"2000-2999 km","D3",360,null,null,null,null,null,null,null,"Iceland","IS"]
[null,"3000-3999 km","D4",530]
[null,"4000-7999 km","D5",820]
[]
[null,"Type of Mobility"]
[null,"Job shadowing"]
[null,"Structured course"]
[null,"Study visit"]
[null,"Seminar"]
[null,"Mixed (structured course+job shadowing/ study visit / seminar)",null,null,null,null,null,null,null,null,null,"Romania","RO"]