{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Eelarve kavand"],"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":"Eelarve kavand","index":0,"n_rows":23,"n_cols":14,"rows_kept":23,"cut":false,"hidden":false,"merged":[[0,0,0,8],[2,10,2,13]]}
["Working tool to assist compiling the budget for a personal research funding application. NB! This detailed budget will not be evaluated. This is a working tool for applicants helping to choose the needed fixed grant volume."]
["Costs",2018,2019,2020,2021,2022,"TOTAL","AVERAGE ANNUAL BUDGET","NB! In case researchers from different R&D institutions are involved in the team project, when drawing up the budget please consider how the expenses will be divided between the institutions over the years. This is later required when drawing up the consortium agreement between the institutions.",null,"When you have calculated the detailed budget you can estimate for which fixed grant volume to apply for"]
["Direct costs",{"$f":"SUM(B4,B16)","v":0},{"$f":"SUM(C4,C16)","v":0},{"$f":"SUM(D4,D16)","v":0},{"$f":"SUM(E4,E16)","v":0},{"$f":"SUM(F4,F16)","v":0},{"$f":"SUM(B3:F3)","v":0},{"$f":"AVERAGEIF(B3:F3,\">0\",B3:F3)","v":{"$error":"#DIV/0!"}},null,null,"Fixed grant volumes for team grant applications submitted in 2017: "]
["Personnel costs, incl.",{"$f":"SUM(B5,B12)","v":0},{"$f":"SUM(C5,C12)","v":0},{"$f":"SUM(D5,D12)","v":0},{"$f":"SUM(E5,E12)","v":0},{"$f":"SUM(F5,F12)","v":0},{"$f":"SUM(B4:F4)","v":0},{"$f":"AVERAGEIF(B4:F4,\">0\",B4:F4)","v":{"$error":"#DIV/0!"}},"NB! Coloured boxes are locked, please do not fill any data into these boxes, the sums will be calculated automatically",null,null,"Direct expenses (per annum)","Overhead expenses (per annum)","Total fixed grant volume  (per annum) "]
["Wages along with any and all state taxes, contributions, benefits and compensation arising from law",{"$f":"SUM(B6:B11)","v":0},{"$f":"SUM(C6:C11)","v":0},{"$f":"SUM(D6:D11)","v":0},{"$f":"SUM(E6:E11)","v":0},{"$f":"SUM(F6:F11)","v":0},{"$f":"SUM(B5:F5)","v":0},null,null,null,"Small team grant (non-experimental)","105 000","26 250","131 250"]
["Primary research staff 1",null,null,null,null,null,null,null,"Please enter the annual expenditure into each cell",null,"Large team grant (non-experimental)","148 000","37 000","185 000"]
["Primary research staff  2 ",null,null,null,null,null,null,null,null,null,"Small team grant (experimental)","114 000","28 500","142 500"]
["In case of involving more primary research staff, please add more rows here",null,null,null,null,null,null,null,null,null,"Large team grant (experimental)","160 000","40 000","200 000"]
["Other research staff  1"]
["In case of involving more other research staff, please add more rows here"]
["Other research staff 2"]
["Research scholarships of master students and PhD students",{"$f":"SUM(B13:B15)","v":0},{"$f":"SUM(C13:C15)","v":0},0,0,0,{"$f":"SUM(B12:F12)","v":0}]
["Student 1"]
["In case of involving more students, please add more rows here"]
["Student 2"]
["Research related costs, incl.",{"$f":"SUM(B17:B21)","v":0},{"$f":"SUM(C17:C21)","v":0},0,0,0,0,{"$f":"AVERAGEIF(B16:F16,\">0\",B16:F16)","v":{"$error":"#DIV/0!"}}]
["travel costs, incl. conference participation costs of students, etc. ",null,null,null,null,null,0,null,"Estimated annual travel costs of all personnel involved in the project"]
["Acquisition costs of fixed assets directly related to the implementation of the project (in accordance with the definition established by the host institution)",null,null,null,null,null,0,null,"Acquisition costs which are below the fixed cost limit shall be indicated in the budget line \"research related costs\".  Information about the fixed assets acquisition costs can be obtained from the financial department of your institution. "]
["Costs relating to the publication and popularisation of results of R&D obtained by way of implementing a research project",null,null,null,null,null,0]
["Subcontracting costs",null,null,null,null,null,0]
["Other research related direct costs based on the characteristics of the project",null,null,null,null,null,0,null,"Please include purchases which are below the fixed acquisition costs set in your institution. Please also indicate costs related to experimentalmethods. "]
["Overhead expenses",{"$f":"B3*0.25","v":0},{"$f":"C3*0.25","v":0},{"$f":"D3*0.25","v":0},{"$f":"E3*0.25","v":0},{"$f":"F3*0.25","v":0},0,null,"Overhead expenses will be calculated automatically "]
["Total grant volume",{"$f":"SUM(B3,B22)","v":0},{"$f":"SUM(C3,C22)","v":0},{"$f":"SUM(D3,D22)","v":0},{"$f":"SUM(E3,E22)","v":0},{"$f":"SUM(F3,F22)","v":0},0,{"$f":"AVERAGEIF(B23:F23, \">0\",B23:F23)","v":{"$error":"#DIV/0!"}},"This sum is to assist the applicant in choosing the fixed grant volume  (small or large). If the calculated sum is in between, the applicant can either choose a small or large grant amount by justifying it, or apply for a grant different from the fixed frant volume (but it cannot be bigger than the fixed large grant)"]