{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Instructions","Summary ","1","2"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":2,"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":"Instructions","index":0,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[[0,3,0,5],[5,1,5,5],[8,1,8,5],[2,0,2,5],[4,1,4,5],[6,1,6,5],[7,1,7,5]]}
[null,null,null,"Business Plan Annex “Necessary Resources”\nNo. 1B"]
[]
["Instructions for completing"]
[]
[1,"This Business Plan Annex No. 1B is to be completed only for the project activities, specified in Clause 10.2. of the Description No. 2 of project financing conditions for Measure No. 01.2.1-LVPA-K-823 “SMARTINVEST LT+” of the 1 Priority of the European Union funds investment operational programme “Promoting Research, Experimental Development and Innovation” for 2014-2020."]
[2,"Only fill in the fields marked in green."]
[3,"Do not delete unnecessary rows, columns. You can only hide the rows, columns (if necessary)."]
[4,"Fill in a separate sheet for each of the first level (three-digit number in the application) physical indicator specified in section 6 “Project Rationale” of the application. The title and number of the physical indicator must match the titles and numbers of the physical indicators specified in the application. Where the project is carried out with a partner(s), it is recommended that the physical indicators of the applicant and the partner(s) are determined separately for the activities carried out with the partner(s).\nPlease note that only one category of budget costs may be assigned to one physical indicator.\n"]
[5,"This Annex to the Business Plan (in paper and electronic versions) must be submitted together with the Business Plan. The electronic version provided by the Lithuanian Business Support Agency must be with all the formulas used for the calculations."]

{"sheet":"Summary ","index":1,"n_rows":19,"n_cols":6,"rows_kept":19,"cut":false,"hidden":false,"merged":[[20,0,20,3],[0,0,0,5],[8,0,8,5],[6,0,6,3]]}
["Summary table of the costs of the activities carried out in accordance with Clause 10.2 of the Description by the physical indicator (the table is filled in automatically)"]
[]
["Physical indicator No.","Physical indicator title","Unit of measurement of the physical indicator","Number of units of the physical indicator","Amount of costs eligible for financing, Eur","Amount of financing, Eur"]
[4,"Equipment, facilities and other assets",null,null,{"$f":"SUM(E5:E6)","v":0},{"$f":"SUM(F5:F6)","v":0}]
[{"$f":"'1'!$D$1","v":0},{"$f":"'1'!$D$2","v":0},{"$f":"'1'!$D$3","v":0},{"$f":"'1'!$H$3","v":0},{"$f":"'1'!$G$9","v":0},{"$f":"'1'!$I$9","v":0}]
[{"$f":"'2'!$D$1","v":0},{"$f":"'2'!$D$2","v":0},{"$f":"'2'!$D$3","v":0},{"$f":"'2'!$H$3","v":0},{"$f":"'2'!$G$9","v":0},{"$f":"'2'!$I$9","v":0}]
["Total:",null,null,null,{"$f":"E4","v":0},{"$f":"F4","v":0}]
[]
[]
[]
["Summary table of the costs of the activities carried out in accordance with Clause 10.2 of the Description by the category of costs (the table is filled in automatically)"]
[]
["Physical indicator No.","Physical indicator title","Amount of costs eligible for financing, Eur","Amount of financing, Eur"]
[4,"EQUIPMENT, FACILITIES AND OTHER ASSETS",{"$f":"'1'!G9+'2'!G9","v":0},{"$f":"'1'!I9+'2'!I9","v":0}]
["4.1","Furniture (furniture necessary for the direct performance of the R&ED activities and for the creation of workplaces for researchers and assistance staff)",{"$f":"'1'!G10+'2'!G10","v":0},{"$f":"'1'!I10+'2'!I10","v":0}]
["4.2","Computer hardware",{"$f":"'1'!G21+'2'!G21","v":0},{"$f":"'1'!I21+'2'!I21","v":0}]
["4.3","Patents, licences, related to the R&ED and innovation infrastructure or the use thereof",{"$f":"'1'!G27+'2'!G27","v":0},{"$f":"'1'!I27+'2'!I27","v":0}]
["4.4","Other plant, equipment, devices, tools and installations, assigned to the infrastructure of the R&ED and innovations",{"$f":"'1'!G33+'2'!G33","v":0},{"$f":"'1'!I33+'2'!I33","v":0}]
[null,"Total amount of costs eligible for financing of the activities performed under Clause 10.2 of the Description:",{"$f":"C14","v":0},{"$f":"D14","v":0}]

{"sheet":"1","index":2,"n_rows":54,"n_cols":10,"rows_kept":54,"cut":false,"hidden":false,"merged":[[21,1,21,2],[22,1,22,2],[23,1,23,2],[39,1,39,2],[40,1,40,2],[37,1,37,2],[38,1,38,2],[30,1,30,2],[31,1,31,2],[32,1,32,2],[29,1,29,2],[24,1,24,2],[25,1,25,2],[26,1,26,2],[27,1,27,2],[28,1,28,2],[44,1,44,2],[45,1,45,2],[46,1,46,2],[47,1,47,2],[48,1,48,2],[53,0,53,5],[9,1,9,2],[10,1,10,2],[11,1,11,2],[12,1,12,2],[52,1,52,2],[33,1,33,2],[34,1,34,2],[35,1,35,2],[36,1,36,2],[50,1,50,2],[51,1,51,2],[49,1,49,2],[41,1,41,2],[42,1,42,2],[43,1,43,2],[1,0,1,2],[18,1,18,2],[1,3,1,9],[19,1,19,2],[20,1,20,2],[7,1,7,2],[2,5,2,6],[2,3,2,4],[3,0,3,2],[3,3,3,8],[13,1,13,2],[14,1,14,2],[15,1,15,2],[16,1,16,2],[17,1,17,2],[8,1,8,5]]}
[null,null,"Physical indicator No.:"]
["Physical indicator title:"]
[null,null,"Unit of measurement of the physical indicator:",null,null,"Number of units of the physical indicator:"]
["Legal entity (applicant, partner) responsible for the physical indicator:"]
[]
[null,null,"Intensity of financing:"]
[]
["Row No.","Title of the category of costs",null,"Unit of measurement","Quantity","Unit price without VAT, Eur","Amount of costs eligible for financing without VAT, Eur","Share of the time spent using the infrastructure specifically for the R&ED activities , per cent","Amount of financing, Eur","Title, date and No. of documents supporting the costs (at least 3, including commercial proposals, estimates, technical projects, etc.)"]
[4,"EQUIPMENT, FACILITIES AND OTHER ASSETS",null,null,null,null,{"$f":"SUM(G10,G21,G27,G33)","v":0},null,{"$f":"SUM(I10,I21,I27,I33)","v":0}]
["4.1","Furniture (furniture necessary for the direct performance of the R&ED activities and for the creation of workplaces for researchers and assistance staff)",null,null,null,null,{"$f":"SUM(G11:G20)","v":0},null,{"$f":"SUM(I11:I20)","v":0}]
["4.1.1","Title of the costs",null,null,null,null,{"$f":"ROUND(E11*F11,2)","v":0},null,{"$f":"ROUND(G11*$D$6*H11,2)","v":0}]
["4.1.2","Title of the costs",null,null,null,null,{"$f":"ROUND(E12*F12,2)","v":0},null,{"$f":"ROUND(G12*$D$6*H12,2)","v":0}]
["4.1.3","Title of the costs",null,null,null,null,0,null,0]
["4.1.4","Title of the costs",null,null,null,null,0,null,0]
["4.1.5","Title of the costs",null,null,null,null,0,null,0]
["4.1.6","Title of the costs",null,null,null,null,0,null,0]
["4.1.7","Title of the costs",null,null,null,null,0,null,0]
["4.1.8","Title of the costs",null,null,null,null,0,null,0]
["4.1.9","Title of the costs",null,null,null,null,0,null,0]
["4.1.10","Title of the costs",null,null,null,null,0,null,0]
["4.2","Computer hardware",null,null,null,null,{"$f":"SUM(G22:G26)","v":0},null,{"$f":"SUM(I22:I26)","v":0}]
["4.2.1","Title of the costs",null,null,null,null,0,null,{"$f":"ROUND(G22*$D$6*H22,2)","v":0}]
["4.2.2","Title of the costs",null,null,null,null,0,null,{"$f":"ROUND(G23*$D$6*H23,2)","v":0}]
["4.2.3","Title of the costs",null,null,null,null,0,null,0]
["4.2.4","Title of the costs",null,null,null,null,0,null,0]
["4.2.5","Title of the costs",null,null,null,null,0,null,0]
["4.3","Patents, licences, related to the R&ED and innovation infrastructure or the use thereof",null,null,null,null,{"$f":"SUM(G28:G32)","v":0},null,{"$f":"SUM(I28:I32)","v":0}]
["4.3.1","Title of the costs",null,null,null,null,0,null,{"$f":"ROUND(G28*$D$6*H28,2)","v":0}]
["4.3.2","Title of the costs",null,null,null,null,0,null,{"$f":"ROUND(G29*$D$6*H29,2)","v":0}]
["4.3.3","Title of the costs",null,null,null,null,0,null,0]
["4.3.4","Title of the costs",null,null,null,null,0,null,0]
["4.3.5","Title of the costs",null,null,null,null,0,null,0]
["4.4","Other plant, equipment, devices, tools and installations, assigned to the infrastructure of the R&ED and innovations",null,null,null,null,{"$f":"SUM(G34:G53)","v":0},null,{"$f":"SUM(I34:I53)","v":0}]
["4.4.1","Title of the costs",null,null,null,null,0,null,{"$f":"ROUND(G34*$D$6*H34,2)","v":0}]
["4.4.2","Title of the costs",null,null,null,null,0,null,{"$f":"ROUND(G35*$D$6*H35,2)","v":0}]
["4.4.3","Title of the costs",null,null,null,null,0,null,0]
["4.4.4","Title of the costs",null,null,null,null,0,null,0]
["4.4.5","Title of the costs",null,null,null,null,0,null,0]
["4.4.6","Title of the costs",null,null,null,null,0,null,0]
["4.4.7","Title of the costs",null,null,null,null,0,null,0]
["4.4.8","Title of the costs",null,null,null,null,0,null,0]
["4.4.9","Title of the costs",null,null,null,null,0,null,0]
["4.4.10","Title of the costs",null,null,null,null,0,null,0]
["4.4.11","Title of the costs",null,null,null,null,0,null,0]
["4.4.12","Title of the costs",null,null,null,null,0,null,0]
["4.4.13","Title of the costs",null,null,null,null,0,null,0]
["4.4.14","Title of the costs",null,null,null,null,0,null,0]
["4.4.15","Title of the costs",null,null,null,null,0,null,0]
["4.4.16","Title of the costs",null,null,null,null,0,null,0]
["4.4.17","Title of the costs",null,null,null,null,0,null,0]
["4.4.18","Title of the costs",null,null,null,null,0,null,0]
["4.4.19","Title of the costs",null,null,null,null,0,null,0]
["4.4.20","Title of the costs",null,null,null,null,0,null,0]
["Total costs eligible for financing:",null,null,null,null,null,{"$f":"G9","v":0},null,{"$f":"I9","v":0}]

{"sheet":"2","index":3,"n_rows":54,"n_cols":10,"rows_kept":54,"cut":false,"hidden":false,"merged":[[7,1,7,2],[2,3,2,4],[2,5,2,6],[41,1,41,2],[42,1,42,2],[26,1,26,2],[27,1,27,2],[28,1,28,2],[29,1,29,2],[30,1,30,2],[31,1,31,2],[9,1,9,2],[3,3,3,8],[8,1,8,5],[33,1,33,2],[10,1,10,2],[19,1,19,2],[20,1,20,2],[21,1,21,2],[34,1,34,2],[23,1,23,2],[24,1,24,2],[25,1,25,2],[43,1,43,2],[35,1,35,2],[36,1,36,2],[37,1,37,2],[38,1,38,2],[39,1,39,2],[40,1,40,2],[46,1,46,2],[1,3,1,9],[45,1,45,2],[44,1,44,2],[22,1,22,2],[11,1,11,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[15,1,15,2],[16,1,16,2],[17,1,17,2],[18,1,18,2],[32,1,32,2],[1,0,1,2],[3,0,3,2],[53,0,53,5],[47,1,47,2],[48,1,48,2],[49,1,49,2],[50,1,50,2],[51,1,51,2],[52,1,52,2]]}
[null,null,"Physical indicator No.:"]
["Physical indicator title:"]
[null,null,"Unit of measurement of the physical indicator:",null,null,"Number of units of the physical indicator:"]
["Legal entity (applicant, partner) responsible for the physical indicator:"]
[]
[null,null,"Intensity of financing:"]
[]
["Row No.","Title of the category of costs",null,"Unit of measurement","Quantity","Unit price without VAT, Eur","Amount of costs eligible for financing without VAT, Eur","Share of the time spent using the infrastructure specifically for the R&ED activities, per cent","Amount of financing, Eur","Title, date and No. of documents supporting the costs (at least 3, including commercial proposals, estimates, technical projects, etc.)"]
[4,"EQUIPMENT, FACILITIES AND OTHER ASSETS",null,null,null,null,{"$f":"SUM(G10,G21,G27,G33)","v":0},null,{"$f":"SUM(I10,I21,I27,I33)","v":0}]
["4.1","Furniture (furniture necessary for the direct performance of the R&ED activities and for the creation of workplaces for researchers and assistance staff)",null,null,null,null,{"$f":"SUM(G11:G20)","v":0},null,{"$f":"SUM(I11:I20)","v":0}]
["4.1.1","Title of the costs",null,null,null,null,{"$f":"ROUND(E11*F11,2)","v":0},null,{"$f":"ROUND(G11*$D$6*H11,2)","v":0}]
["4.1.2","Title of the costs",null,null,null,null,0,null,{"$f":"ROUND(G12*$D$6*H12,2)","v":0}]
["4.1.3","Title of the costs",null,null,null,null,0,null,0]
["4.1.4","Title of the costs",null,null,null,null,0,null,0]
["4.1.5","Title of the costs",null,null,null,null,0,null,0]
["4.1.6","Title of the costs",null,null,null,null,0,null,0]
["4.1.7","Title of the costs",null,null,null,null,0,null,0]
["4.1.8","Title of the costs",null,null,null,null,0,null,0]
["4.1.9","Title of the costs",null,null,null,null,0,null,0]
["4.1.10","Title of the costs",null,null,null,null,0,null,0]
["4.2","Computer hardware",null,null,null,null,{"$f":"SUM(G22:G26)","v":0},null,{"$f":"SUM(I22:I26)","v":0}]
["4.2.1","Title of the costs",null,null,null,null,0,null,{"$f":"ROUND(G22*$D$6*H22,2)","v":0}]
["4.2.2","Title of the costs",null,null,null,null,0,null,{"$f":"ROUND(G23*$D$6*H23,2)","v":0}]
["4.2.3","Title of the costs",null,null,null,null,0,null,0]
["4.2.4","Title of the costs",null,null,null,null,0,null,0]
["4.2.5","Title of the costs",null,null,null,null,0,null,0]
["4.3","Patents, licences, related to the R&ED and innovation infrastructure or the use thereof",null,null,null,null,{"$f":"SUM(G28:G32)","v":0},null,{"$f":"SUM(I28:I32)","v":0}]
["4.3.1","Title of the costs",null,null,null,null,0,null,{"$f":"ROUND(G28*$D$6*H28,2)","v":0}]
["4.3.2","Title of the costs",null,null,null,null,0,null,{"$f":"ROUND(G29*$D$6*H29,2)","v":0}]
["4.3.3","Title of the costs",null,null,null,null,0,null,0]
["4.3.4","Title of the costs",null,null,null,null,0,null,0]
["4.3.5","Title of the costs",null,null,null,null,0,null,0]
["4.4","Other plant, equipment, devices, tools and installations, assigned to the infrastructure of the R&ED and innovations",null,null,null,null,{"$f":"SUM(G34:G53)","v":0},null,{"$f":"SUM(I34:I53)","v":0}]
["4.4.1","Title of the costs",null,null,null,null,0,null,{"$f":"ROUND(G34*$D$6*H34,2)","v":0}]
["4.4.2","Title of the costs",null,null,null,null,0,null,{"$f":"ROUND(G35*$D$6*H35,2)","v":0}]
["4.4.3","Title of the costs",null,null,null,null,0,null,0]
["4.4.4","Title of the costs",null,null,null,null,0,null,0]
["4.4.5","Title of the costs",null,null,null,null,0,null,0]
["4.4.6","Title of the costs",null,null,null,null,0,null,0]
["4.4.7","Title of the costs",null,null,null,null,0,null,0]
["4.4.8","Title of the costs",null,null,null,null,0,null,0]
["4.4.9","Title of the costs",null,null,null,null,0,null,0]
["4.4.10","Title of the costs",null,null,null,null,0,null,0]
["4.4.11","Title of the costs",null,null,null,null,0,null,0]
["4.4.12","Title of the costs",null,null,null,null,0,null,0]
["4.4.13","Title of the costs",null,null,null,null,0,null,0]
["4.4.14","Title of the costs",null,null,null,null,0,null,0]
["4.4.15","Title of the costs",null,null,null,null,0,null,0]
["4.4.16","Title of the costs",null,null,null,null,0,null,0]
["4.4.17","Title of the costs",null,null,null,null,0,null,0]
["4.4.18","Title of the costs",null,null,null,null,0,null,0]
["4.4.19","Title of the costs",null,null,null,null,0,null,0]
["4.4.20","Title of the costs",null,null,null,null,0,null,0]
["Total costs eligible for financing:",null,null,null,null,null,{"$f":"G9","v":0},null,{"$f":"I9","v":0}]