{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Tech","Content","1. Summary","2. Macro","3. GGbudget","4. Municipalities","5. SurplusGG","6. GGexpenditure","7. GGbudgets"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":8,"comments":3,"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":"Tech","index":0,"n_rows":2,"n_cols":1,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["LT"]
["EN"]

{"sheet":"Content","index":1,"n_rows":31,"n_cols":7,"rows_kept":31,"cut":false,"hidden":false,"merged":[[11,5,11,7],[15,5,15,7],[21,5,21,7],[27,5,27,7],[0,2,0,4],[27,2,27,3],[11,2,11,3],[15,2,15,3],[21,2,21,3],[5,2,5,3],[7,2,7,3],[3,2,3,3],[3,5,3,7],[7,5,7,7]]}
[]
[null,"LT","◄","Switch to English",null,"◄","Rodyti lietuviškai"]
[]
[null,null,"FISKALINĖS DRAUSMĖS TAISYKLIŲ LAIKYMOSI SKAIČIUOKLĖ",null,null,"SPREADSHEET OF THE FULFILMENT OF FISCAL DISCIPLINE RULES  "]
[]
[null,null,"Versija 2.1 2018-09",null,null,null,"Version 2.1 2018-09"]
[]
[null,null,"APRAŠYMAS",null,null,"DESCRIPTION"]
[]
[null,null,null,"Fiskalinės sutarties įgyvendinimo konstituciniame įstatyme Nr. XII-1289 (toliau − KĮ) nustatytų fiskalinės drausmės taisyklių skaičiuoklė skirta skaidriai parodyti fiskalinės drausmės taisykles, pagal kurias priimami sprendimai. 1 dalis pateikia skaičiavimams reikalingų duomenų įvestis ir nurodo šių duomenų šaltinius. 2 dalyje nagrinėjamos trys taisyklių grupės: perteklinio valdžios sektoriaus (toliau − VS) taisyklė; VS išlaidų augimą ribojimo taisyklė ir VS priskiriamų biudžetų taisyklės.",null,null,"Constitutional Law on the Implementation of the Fiscal Treaty Nr. XII-1289 (hereinafter − CL) defines fiscal discipline rules. The aim of this spreadsheet is to show the fiscal discipline rules, which are used for making decisions in a transparent way.  Part 1 provides required input data with their appropriate sources. In part 2 three groups of the fiscal rules are validated: general government (hereinafter − GG) surplus rule; GG sector expenditure growth limiting rule and rules for the budgets attributable to GG.   "]
[]
[null,null,"SUVESTINĖ",null,null,"SUMMARY"]
[]
[null,null,null,"1 lentelė. Fiskalinės drausmės taisyklių laikymosi suvestinė",null,null,"Table 1. Summary of the fulfilment of the fiscal discipline rules "]
[]
[null,null,"1. DUOMENYS",null,null,"1 . DATA"]
[]
[null,null,null,"2 lentelė. Makroekonominiai ir ciklo rodikliai",null,null,"Table 2. Macroeconomic and cyclical indicators"]
[null,null,null,"3 lentelė. VS fiskaliniai rodikliai",null,null,"Table 3. GG fiscal indicators"]
[null,null,null,"4 lentelė. Vietos valdžios biudžetai",null,null,"Table 4. Budget attributable to local government"]
[]
[null,null,"2. FISKALINĖS TAISYKLĖS",null,null,"2. FISCAL RULES"]
[]
[null,null,null,"5 lentelė. Perteklinio VS taisyklė",null,null,"Table 5. Surplus GG rule"]
[null,null,null,"6 lentelė. VS išlaidų augimo ribojimo taisyklė",null,null,"Table 6. GG expenditure growth limiting rule"]
[null,null,null,"7 lentelė. VS priskiriamų biudžetų taisyklė",null,null,"Table 7. Rules for the budgets attributable to GG sector"]
[]
[null,null,"NUORODOS",null,null,"REFERENCES"]
[]
[null,null,"KĮ","Lietuvos Respublikos fiskalinės sutarties įgyvendinimo konstitucinis įstatymas",null,"CL","Republic of Lithuania Constitutional Law on the Implementation of the Fiscal Treaty"]
[null,null,"FDĮ","Lietuvos Respublikos fiskalinės drausmės įstatymas",null,"FDL","Republic of Lithuania Fiscal Discipline Law"]

{"sheet":"1. Summary","index":2,"n_rows":23,"n_cols":7,"rows_kept":23,"cut":false,"hidden":false,"merged":[[22,2,22,3],[8,2,8,3],[8,5,8,6],[21,2,21,3],[15,4,15,6],[9,4,9,6],[10,4,11,4],[22,5,22,6],[21,5,21,6],[0,4,0,5],[19,1,19,3],[5,1,5,3],[9,1,9,3],[15,1,15,3],[2,1,2,3],[10,1,11,1],[6,1,7,1],[2,4,2,6],[5,4,5,6],[6,4,7,4]]}
[null,"↖ atgal į turinį",null,null,"↖ back to content"]
[{"$f":"Kalba","v":"LT"}]
[null,"1 lentelė. Fiskalinės drausmės taisyklių laikymosi suvestinė 2017 m.",null,null,"Table 1. Summary of the fulfilment of the fiscal discipline rules in year 2017"]
[null,"Taisyklė",null,null,"Rule"]
[null,"Institucija, kurios projekcijų pagrindu atliekama analizė","FM","IFI","Institution, projections of which are used for the analysis","MoF","IFI"]
[null,"Perteklinio VS taisyklė",null,null,"Surplus GG sector rule"]
[null,"Ar patenkinta bent viena perteklinio VS taisyklės sąlygų? ",{"$f":"'5. SurplusGG'!E14","v":"Taip"},{"$f":"'5. SurplusGG'!F14","v":"Ne"},"Is at least one condition of the surplus GG rule satisfied?",{"$f":"'5. SurplusGG'!J14","v":"Yes"},{"$f":"'5. SurplusGG'!K14","v":"No"}]
[null,null,{"$f":"'5. SurplusGG'!E15","v":"Tenkinama S1 sąlyga"},{"$f":"'5. SurplusGG'!F15","v":"Netenkinama nei viena iš sąlygų"},null,{"$f":"'5. SurplusGG'!J15","v":"Condition C1 is valid"},{"$f":"'5. SurplusGG'!K15","v":"None of the conditions is valid"}]
[null,"Ar t metai yra išskirtinių aplinkybių metai?","Ne",null,"Is year t a year of exceptional circumstances?",{"$f":"IF(C9=\"NE\",\"No\",\"Yes\")","v":"No"}]
[null,"VS išlaidų augimo ribojimo taisyklė",null,null,"GG expenditure growth limiting rule"]
[null,"Ar susidaro bent viena aplinkybė, leidžianti netaikyti VS išlaidų augimo ribojimo taisyklės?",{"$f":"'6. GGexpenditure'!F19","v":"Taip"},{"$f":"'6. GGexpenditure'!G19","v":"Taip"},"Is at least one escape clause, which allows switching off GG expenditure growth limiting rule, valid?",{"$f":"'6. GGexpenditure'!L19","v":"Yes"},{"$f":"'6. GGexpenditure'!M19","v":"Yes"}]
[null,null,{"$f":"'6. GGexpenditure'!F20","v":"Susidaro aplinkybės"},{"$f":"'6. GGexpenditure'!G20","v":"Susidaro aplinkybės"},null,{"$f":"'6. GGexpenditure'!L20","v":"Escape clauses emerge"},{"$f":"'6. GGexpenditure'!M20","v":"Escape clauses emerge"}]
[null,"Ar taikoma VS išlaidų augimą ribojimo taisyklė?",{"$f":"IF(C11=\"taip\",\"Netaikoma,\",\"Taikoma\")","v":"Netaikoma,"},{"$f":"IF(D11=\"taip\",\"Netaikoma,\",\"Taikoma\")","v":"Netaikoma,"},"Is GG expenditure growth limiting rule applied?",{"$f":"IF(F11=\"yes\",\"Not applied,\",\"Applied\")","v":"Not applied,"},{"$f":"IF(G11=\"yes\",\"Not applied,\",\"Applied\")","v":"Not applied,"}]
[null,null,{"$f":"'6. GGexpenditure'!F26","v":" nes susidarė viena iš KĮ numatytų netaikymo aplinkybių"},{"$f":"'6. GGexpenditure'!G26","v":" nes susidarė viena iš KĮ numatytų netaikymo aplinkybių"},null,{"$f":"'6. GGexpenditure'!L26","v":" since one of CL escape clauses emerged"},{"$f":"'6. GGexpenditure'!M26","v":" since one of CL escape clauses emerged"}]
[null,"Ar galioja VS išlaidų augimą ribojimo taisyklė?",{"$f":"IF(C11=\"taip\",\"Netikrinama\",'6. GGexpenditure'!F25)","v":"Netikrinama"},{"$f":"IF(D11=\"taip\",\"Netikrinama\",'6. GGexpenditure'!G25)","v":"Netikrinama"},"Is GG expenditure growth limiting rule valid?",{"$f":"IF(F11=\"yes\",\"Not verified\",'6. GGexpenditure'!L25)","v":"Not verified"},{"$f":"IF(G11=\"yes\",\"Not verified\",'6. GGexpenditure'!M25)","v":"Not verified"}]
[null,"VS priskiriamų biudžetų taisyklės",null,null,"Rules for the budgets attributable to GG sector"]
[null,"Savivaldybių (j), kurių asignavimai didesni nei 0,3 proc. nominalaus BVP, ir PSDF struktūrinio biudžeto (SB) taisyklė",{"$f":"'7. GGbudgets'!E7","v":"Šiuo metu negalima patikrinti, nes nėra duomenų apie savivaldybių, kurių asignavimai viršija 0,3 proc. BVP, planuojamus struktūrinius balanso rodiklius"},{"$f":"'7. GGbudgets'!F7","v":"Šiuo metu negalima patikrinti, nes nėra duomenų apie savivaldybių, kurių asignavimai viršija 0,3 proc. BVP, planuojamus struktūrinius balanso rodiklius"},"Structural budget rule for local governments (j) with appropriations  exceeding 0,3 % of nominal GDP and NHIF",{"$f":"'7. GGbudgets'!J7","v":"Currently not verified, since no data on local governments appropr. of which exceed 0.3% of GDP, planned appropr. and revenues"},{"$f":"'7. GGbudgets'!K7","v":"Currently not verified, since no data on local governments appropr. of which exceed 0.3% of GDP, planned appropr. and revenues"}]
[null,{"$f":"'7. GGbudgets'!C17","v":"Taisyklė planuojamam VSDF struktūriniam biudžetui"},{"$f":"'7. GGbudgets'!E17","v":"Galioja"},{"$f":"'7. GGbudgets'!F17","v":"Galioja"},{"$f":"'7. GGbudgets'!H17","v":"Rule for SSIF structural budget"},{"$f":"'7. GGbudgets'!J17","v":"Valid"},{"$f":"'7. GGbudgets'!K17","v":"Valid"}]
[null,{"$f":"'7. GGbudgets'!C21","v":"Taisyklė planuojamiems vietos valdžios sektoriaus (j) asignavimams, kurie neviršija 0,3 proc. BVP"},{"$f":"'7. GGbudgets'!E21","v":"Galioja"},{"$f":"'7. GGbudgets'!F21","v":"Galioja"},{"$f":"'7. GGbudgets'!H21","v":"Rule for planned local governments (j) appropriations of which does not exceed 0.3 % of GDP"},{"$f":"'7. GGbudgets'!J21","v":"Valid"},{"$f":"'7. GGbudgets'!K21","v":"Valid"}]
[]
[null,"Šaltiniai:",null,null,"Sources:"]
[null,"Finansų ministerija","FM",null,"Ministry of Finance","MoF"]
[null,"Fiskalinė institucija","IFI",null,"Independent Fiscal Institution","IFI"]

{"sheet":"2. Macro","index":3,"n_rows":48,"n_cols":17,"rows_kept":48,"cut":false,"hidden":false,"merged":[[35,2,36,2],[28,2,29,2],[35,3,36,3],[28,4,29,4],[35,4,36,4],[33,2,34,2],[33,3,34,3],[33,4,34,4],[28,1,29,1],[16,1,17,1],[12,1,13,1],[22,1,23,1],[35,1,36,1],[33,1,34,1],[26,2,27,2],[22,2,23,2],[10,1,11,1],[8,1,9,1],[6,1,7,1],[26,1,27,1],[24,1,25,1],[24,2,25,2],[0,3,0,4],[20,1,21,1],[20,2,21,2],[14,1,15,1],[14,2,15,2],[18,1,19,1],[18,2,19,2],[16,2,17,2],[16,3,17,3],[12,2,13,2],[10,2,11,2],[8,2,9,2],[6,2,7,2],[3,1,4,1],[6,3,7,3],[8,3,9,3],[3,13,3,16],[3,6,3,12],[3,2,4,2],[2,1,2,2],[3,3,4,3],[3,4,4,4],[2,3,2,4],[3,5,4,5],[10,3,11,3],[12,3,13,3],[14,3,15,3],[18,3,19,3],[20,3,21,3],[16,4,17,4],[18,4,19,4],[20,4,21,4],[22,4,23,4],[26,4,27,4],[6,4,7,4],[8,4,9,4],[10,4,11,4],[12,4,13,4],[14,4,15,4],[24,3,25,3],[24,4,25,4],[22,3,23,3],[26,3,27,3],[28,3,29,3]]}
[null,"↖ atgal į turinį",null,"↖ back to content"]
[{"$f":"Kalba","v":"LT"}]
[null,"2 lentelė.    Makroekonominiai ir ciklo rodikliai",null,"Table 2. Macroeconomic and cyclical indicators"]
[null,"Rodiklis ","Žymėjimas | Formulė                    ","Indicator","Notation | Formula",{"$f":"IF(A2=\"LT\",\"Duomenys atnaujinti\",\"Data updated on\")","v":"Duomenys atnaujinti"},{"$f":"IF(A2=\"LT\",\"Faktas\",\"Actuals\")","v":"Faktas"},null,null,null,null,null,null,{"$f":"CONCATENATE(\"2018-09-12\",IF(A2=\"LT\",\" Projekcijos\",\" Projections\"))","v":"2018-09-12 Projekcijos"}]
[null,null,null,null,null,null,2011,{"$f":"G5+1","v":2012},2013,2014,2015,2016,2017,{"$f":"CONCATENATE(M5+1,\"P\")","v":"2018P"},{"$f":"CONCATENATE(M5+2,\"P\")","v":"2019P"},{"$f":"CONCATENATE(M5+3,\"P\")","v":"2020P"},{"$f":"CONCATENATE(M5+4,\"P\")","v":"2021P"}]
[null,"Laikas","T","Time","T",null,"t–8","t−7","t−6","t−5","t−4","t−3","t−2","t−1","t","t+1","t+2"]
[null,"Nominalus BVP, mln. EUR","YN(T)","Nominal GDP, million EUR","YN(T)","2018-10-01",31275.317299292619,33348.476238320509,34959.646115801785,36568.280632331567,37433.906318481269,38849.432230518913,42190.830837764501,{"$f":"M7*(1+N10%)","v":44940.877442114303},{"$f":"N7*(1+O10%)","v":47431.063606970703},{"$f":"O7*(1+P10%)","v":49793.791097433881},{"$f":"P7*(1+Q10%)","v":52259.585317868121}]
[null,null,null,null,null,"2018-08-31",31275.317299292619,33348.476238320509,34959.646115801785,36568.280632331567,37426.609548720866,38680.92153312872,41858.024297164404,44586.378190593146,47056.921456115262,49401.011457179258,51847.355184981818]
[null,"Nominalus BVP, metinis augimas proc.","ΔYN(T)=(YN(T)/YN(T–1)–1)∙100","Nominal GDP growth, annual % change","ΔYN(T)=(YN(T)/YN(T–1)–1)∙100",{"$f":"$F$7","v":"2018-10-01"},null,{"$f":"(H7/G7-1)*100","v":6.628738308834925},4.8313148282016272,4.601403890649447,2.3671489913703159,3.7814004768687237,8.6008943127376938,{"$f":"(N7/M7-1)*100","v":6.5181143621572568},5.5410270261497807,4.9813925954549809,4.9520114176671237]
[null,null,null,null,null,{"$f":"$F$8","v":"2018-08-31"},null,6.628738308834925,4.8313148282016272,4.601403890649447,2.3471951690023252,3.3513908941578796,8.2136170445541659,6.5181143621572568,5.5410270261497807,4.9813925954549809,4.9520114176671237]
[null,"Realus BVP, mln. EUR","YR(T)","Real GDP, million EUR","YR(T)",{"$f":"$F$7","v":"2018-10-01"},29721.407577579896,30858.83222900562,31938.453389413542,33068.303586843584,33736.490956871632,34530.371756547465,35959.911413016227,{"$f":"M11*(1+N14%)","v":37173.289284804268},{"$f":"N11*(1+O14%)","v":38220.303840417218},{"$f":"O11*(1+P14%)","v":39176.097657368387},{"$f":"P11*(1+Q14%)","v":40156.791122089096}]
[null,null,null,null,null,{"$f":"$F$8","v":"2018-08-31"},29721.407577579896,30858.83222900562,31938.453389413542,33068.303586843584,33741.127488322112,34532.316731272193,35866.980276213908,37077.222417668774,38121.531175378499,39074.854936023417,40053.013996321257]
[null,"Realus BVP, metinis augimas proc.","ΔYR(T)=(YR(T)/YR(T–1)–1)∙100","Real GDP growth, annual % change","ΔYR(T)=(YR(T)/YR(T–1)–1)∙100",{"$f":"$F$7","v":"2018-10-01"},null,{"$f":"(H11/G11-1)*100","v":3.8269541859912826},3.4985807382339473,3.5375858174915509,2.0206279051275366,2.3531813094928022,{"$f":"(M11/L11-1)*100","v":4.1399486415830467},3.3742515598879974,2.8165776442090396,2.500748871442604,2.5032954361554616]
[null,null,null,null,null,{"$f":"$F$8","v":"2018-08-31"},null,3.8269541859912826,3.4985807382339473,3.5375858174915509,2.0346489795328271,2.3448808674929822,3.864969603192181,3.3742515598879974,2.8165776442090396,2.500748871442604,2.5032954361554616]
[null,"Potencialus BVP, mln. EUR","Y*(T)","Potential GDP, million EUR","Y*(T)","2018-09-10",31119.7282586168,31736.009303075502,32344.321349656999,33024.723729073397,33773.609520726903,34548.282336367403,35391.501195014498,36344.776630595697,37365.561348285402,38420.663276656996,39489.410785747801]
[null,null,null,null,null,"2018-10-15",31152.128982916653,31549.263460151138,32142.688819119991,32809.45078556837,33507.003678082074,34154.703919095176,35034.254781729447,36210.555526972363,37565.410885684934,38814.618470249385,39960.506990128401]
[null,"Potencialus BVP, metinis augimas proc.","ΔY*(T)=(Y*(T)/Y*(T–1)–1)∙100","Potential GDP growth, annual % change","ΔY*(T)=(Y*(T)/Y*(T–1)–1)∙100",{"$f":"$F$15","v":"2018-09-10"},null,{"$f":"(H15/G15-1)*100","v":1.9803548390177728},{"$f":"(I15/H15-1)*100","v":1.9167880900594181},2.1036223702483481,2.267651950088001,2.2937223075463198,2.4406969076997465,{"$f":"(N15/M15-1)*100","v":2.6935151191481044},2.8086146410111423,2.8237282949852061,2.7816997884576811]
[null,null,null,null,null,{"$f":"$F$16","v":"2018-10-15"},null,{"$f":"(H16/G16-1)*100","v":1.2748229100241204},{"$f":"(I16/H16-1)*100","v":1.8809483768722268},2.0743814252768944,2.126073054598443,1.9330294264323644,2.5751968593190844,3.3575731882168114,3.7416033501705748,3.3254197281800124,2.9522086395292524]
[null,"Atotrūkis nuo potencialo, proc. pot. BVP","AP(T)=(YR(T)/Y*(T)–1)∙100","Output gap (OG), % pot. GDP","OG(T)=(YR(T)/Y*(T–1)–1)∙100",{"$f":"$F$15","v":"2018-09-10"},{"$f":"(G$11/G15-1)*100","v":-4.4933576200162362},{"$f":"(H11/H15-1)*100","v":-2.7639803911479022},-1.2548352950610298,0.13196130913222248,-0.1099040475152413,-5.184217161813276E-2,1.6060641645847973,2.2795920927771274,{"$f":"(O11/O15-1)*100","v":2.2875141207293392},1.9662189985417688,1.6900235355807425]
[null,null,null,null,null,{"$f":"$F$16","v":"2018-10-15"},{"$f":"(G$12/G16-1)*100","v":-4.5926922237685357},{"$f":"(H$12/H16-1)*100","v":-2.1884226616497027},-0.6354024420787141,0.78895804433603001,0.69873096529124989,1.1055953319680345,{"$f":"(M$12/M16-1)*100","v":2.3768894177213395},{"$f":"(N$12/N16-1)*100","v":2.393409540626501},{"$f":"(O$12/O16-1)*100","v":1.4804051828047005},{"$f":"(P$12/P16-1)*100","v":0.67045993502035106},0.23149607740389211]
[null,"Ciklinė VS biudžeto dedamoji, proc. pot. BVP","CB(T) = ε∙AP(T)","Cyclical GG budgetary component, % pot. GDP","CB(T) = ε∙OG(T)",{"$f":"$F$15","v":"2018-09-10"},{"$f":"G19*G38","v":-1.8557566970667054},{"$f":"H19*H38","v":-1.1415239015440835},-0.51824697686020527,5.4500020671607884E-2,-4.5390371623794654E-2,-2.141081687828883E-2,{"$f":"M19*M38","v":0.66330449997352126},{"$f":"N19*N38","v":0.94147153431695352},{"$f":"O19*O38","v":0.94474333186121706},0.81204844639775053,0.69797972019484655]
[null,null,null,null,null,{"$f":"$F$16","v":"2018-10-15"},{"$f":"G20*G38","v":-1.8967818884164052},-0.90381855926132715,-0.26242120857850892,0.32583967231078037,0.28857588866528622,0.45661087210279822,{"$f":"M20*M38","v":0.98165532951891321},{"$f":"N20*N38","v":0.98847814027874492},{"$f":"O20*O38","v":0.61140734049834122},{"$f":"P20*P38","v":0.27689995316340499},9.5607879967807438E-2]
[null,"Ciklinė VSDF biudžeto dedamoji, proc. pot. BVP","CBVSDF(T) = εVSDF∙AP(T)","Cyclical SSIF budgetary component, % pot. GDP","CBSSIF(T) = εSSIF∙OG(T)",{"$f":"$F$15","v":"2018-09-10"},{"$f":"G19*G39","v":-0.46955587129169668},{"$f":"H19*H39","v":-0.28883595087495578},{"$f":"I19*I39","v":-0.1311302883338776},1.3789956804317249E-2,-1.1484972965342715E-2,-5.4175069340948734E-3,0.16783370519911131,{"$f":"N19*N39","v":0.23023880137048988},{"$f":"O19*O39","v":0.23103892619366329},0.19858811885271865,0.17069237709365501]
[null,null,null,null,null,{"$f":"+F26","v":"2018-10-23"},{"$f":"G20*G39","v":-0.47993633738381197},{"$f":"H20*H39","v":-0.22869016814239393},-6.6399555197225624E-2,8.244611563311513E-2,7.3017385872935617E-2,0.1155347121906596,0.24838494415187998,{"$f":"N20*N39","v":0.24173436360327663},{"$f":"O20*O39","v":0.14952092346327475},{"$f":"P20*P39","v":6.7716453437055457E-2},2.3381103817793104E-2]
[null,"Ciklinė PSDF biudžeto dedamoji, proc. pot. BVP","CBPSDF(T) = εPSDF∙AP(T)","Cyclical NHIF budgetary component, % pot. GDP","CBNHIF(T) = εNHIF∙OG(T)",{"$f":"$F$15","v":"2018-09-10"},null,null,null,null,null,null,null,{"$f":"N19*N40","v":0.10258164417497073},{"$f":"O19*O40","v":0.10293813543282027}]
[null,null,null,null,null,"2018-10-23",null,null,null,null,null,null,null,{"$f":"N20*N40","v":0.10770342932819255},{"$f":"O20*O40","v":6.6618233226211521E-2}]
[null,"BVP defliatorius, 2010 = 100","PY(T) = YN(T)/YR(T)","GDP deflator, 2010 = 100","PY(T) = YN(T)/YR(T)",{"$f":"$F$7","v":"2018-10-01"},{"$f":"G7/G11*100","v":105.22825077398051},108.06784907101819,109.45942087286437,110.58408404984061,110.95969158836458,112.50800456022456,117.3274048236195,{"$f":"N7/N11*100","v":120.89561700552895},124.09912753444227,127.10247848810046,130.13884789494952]
[null,null,null,null,null,{"$f":"$F$8","v":"2018-08-31"},{"$f":"G8/G12*100","v":105.22825077398051},108.06784907101819,109.45942087286437,110.58408404984061,110.92281833698149,112.01368803066603,116.70350828202731,{"$f":"N8/N12*100","v":120.25274625033929},123.43922189176875,126.42660232024579,129.4468256240188]
[null,"BVP defliatorius, metinis augimas proc.","ΔPY(T)=(PY(T)/PY(T–1)–1)∙100","GDP deflator, annual % change","ΔPY(T)=(PY(T)/PY(T)–1)∙100",{"$f":"$F$7","v":"2018-10-01"},null,{"$f":"(H27/G27-1)*100","v":2.6985132568029258},{"$f":"(I27/H27-1)*100","v":1.2876834449917496},1.0274704251199474,0.33965786464775771,1.3953832690918766,4.2836065595805328,3.0412435928959702,2.6498152772294725,2.4201225369812951,2.3889143964516357]
[null,null,null,null,null,{"$f":"$F$8","v":"2018-08-31"},null,{"$f":"(H28/G28-1)*100","v":2.6985132568029258},{"$f":"(I28/H28-1)*100","v":1.2876834449917496},1.0274704251199474,0.30631377928509451,0.98344931190847973,4.1868278188263552,3.0412435928959702,2.6498152772294503,2.4201225369812951,2.3889143964516357]
[null,"Vidutinė metinė SVKI infliacija","ΔSVKI(T)","Average annual HICP inflation","ΔHICP(T)",{"$f":"$F$8","v":"2018-08-31"},4.0999999999999996,3.2,1.2,0.2,-0.7,0.7,3.7,2.7,2.5,2.5,2.5]
[null,"ES nominalus BVP, mlrd. EUR","YNES(T)","EU nominal GDP, billion EUR","YNEU(T)","2018-10-15",13218.130800000001,13484.535099999999,13596.773800000001,14071.985199999999,14826.929199999999,14953.4897,15373.553099999999]
[null,"ES nominalus BVP, metinis augimas proc.","ΔYNES(T)=(YNES(T)/YNES(T–1)–1)∙100","EU nominal GDP growth, annual % change","ΔYNEU(T)=(YNEU(T)/YNEU(T–1)–1)∙100",{"$f":"$F$32","v":"2018-10-15"},null,{"$f":"(H32/G32-1)*100","v":2.0154460871275148},0.83235127624090577,3.4950305637944767,5.3648720437824204,0.8535853803092408,2.809132907618217]
[null,"VS biudžeto balansas mln. EUR","BL(T)","Balance of GG budget, million EUR","BL(T)","2018-10-22",null,null,-912.41890639480835,-226.5,-97.4,102.3,206.2]
[null,null,null,null,null,{"$f":"+F8","v":"2018-08-31"},null,null,-912.41890639480835,-226.5,-97.4,102.3,206.2]
[null,"VS biudžeto balansas proc. BVP","B(T)=BL(T)/YN(T)","Balance of GG budget, % of GDP","B(T)=BL(T)/YN(T)",{"$f":"+F34","v":"2018-10-22"},null,null,{"$f":"I34/I7*100","v":-2.6099203160480346},-0.61938925233400699,-0.2601919211191519,0.26332431164756193,0.48873178343630264,{"$f":"+'3. GGbudget'!J7","v":0.38164301460938788}]
[null,null,null,null,null,{"$f":"F8","v":"2018-08-31"},null,null,-2.6099203160480346,-0.61938925233400699,-0.26024264867809505,0.26447146537701793,0.49261761266159099,{"$f":"+'3. GGbudget'!F7","v":0.60000000000000142}]
[null,"VS biudžeto dalinis elastingumas pot. BVP","ε","Semi-elasticity of the GG budget to the OG","ε","2014-12-11",{"$f":"H38","v":0.41299999999999998},{"$f":"I38","v":0.41299999999999998},0.41299999999999998,0.41299999999999998,0.41299999999999998,{"$f":"0.413","v":0.41299999999999998},{"$f":"L38","v":0.41299999999999998},{"$f":"M38","v":0.41299999999999998},{"$f":"N38","v":0.41299999999999998},{"$f":"O38","v":0.41299999999999998},{"$f":"P38","v":0.41299999999999998}]
[null,"VSDF biudžeto semi-elastingumas pot. BVP","εVSDF","Semi-elasticity of the SSIF budget to the OG","εSSIF",{"$f":"F26","v":"2018-10-23"},{"$f":"H39","v":0.1045},0.1045,0.1045,0.1045,0.1045,{"$f":"M39","v":0.1045},0.1045,0.10100000000000001,{"$f":"N39","v":0.10100000000000001},{"$f":"N39","v":0.10100000000000001},{"$f":"N39","v":0.10100000000000001}]
[null,"PSDF biudžeto semi-elastingumas pot. BVP","εPSDF","Semi-elasticity of the NHIF budget to the OG","εNHIF",{"$f":"F26","v":"2018-10-23"},null,null,null,null,null,null,null,4.4999999999999998E-2,{"$f":"N40","v":4.4999999999999998E-2},{"$f":"N40","v":4.4999999999999998E-2},{"$f":"N40","v":4.4999999999999998E-2}]
[]
[null,null,"Šaltiniai:",null,"Sources:"]
[null,null,"Europos Komisija, Eurostatas, Lietuvos statistikos departamentas",null,"European Commission, Eurostat, Statistics Lithuania"]
[null,"2018 pavasario ERS duomenys","Finansų ministerija (FM)","2018 spring EDS data","Ministry of Finance (MoF)"]
[null,null,"Fiskalinės institucijos skaičiavimai",null,"Independent fiscal institution calculations"]
[null,null,"ERS – ekonominės raidos scenarijus",null,"EDS – economic development scenario"]
[null,null,"Dėmesio: langeliai su formulėmis, atnaujinami tik spalvoti langeliai",null,"Warning: cells with formulas, data inputs are marked with coloured cells"]
[null,null,"Apvalinimo tikslumas",null,"Rounding threshold",4.9999999999999899E-2]

{"sheet":"3. GGbudget","index":4,"n_rows":29,"n_cols":13,"rows_kept":29,"cut":false,"hidden":false,"merged":[[3,2,4,2],[2,1,2,2],[3,1,4,1],[3,3,4,3],[3,5,3,6],[3,7,3,8],[3,9,3,10],[3,11,3,12],[0,3,0,4],[3,4,4,4],[2,3,2,4]]}
[null,"↖ atgal į turinį",null,"↖ back to content"]
[{"$f":"Kalba","v":"LT"}]
[null,"3 lentelė.    VS fiskaliniai rodikliai",null,"Table 3. GG fiscal indicators"]
[null,"Rodiklis","Žymėjimas | Formulė    ","Indicator","   Notation | Formula",{"$f":"IF($A$2=\"LT\",\"proc. BVP\",\"% of GDP\")","v":"proc. BVP"},null,{"$f":"IF($A$2=\"LT\",\"mln. EUR\", \"mil. EUR\")","v":"mln. EUR"},null,{"$f":"IF($A$2=\"LT\",\"proc. BVP\",\"% of GDP\")","v":"proc. BVP"},null,{"$f":"IF($A$2=\"LT\",\"mln. EUR\", \"mil. EUR\")","v":"mln. EUR"}]
[null,null,null,null,null,{"$f":"'2. Macro'!N5","v":"2018P"},{"$f":"'2. Macro'!O5","v":"2019P"},{"$f":"F5","v":"2018P"},"2019P","2018P","2019P","2018P","2019P"]
[null,"Nominalus BVP, mln. EUR",null,"Nominal GDP, million EUR",null,null,null,{"$f":"'2. Macro'!N8","v":44586.378190593146},{"$f":"'2. Macro'!O8","v":47056.921456115262},null,null,{"$f":"'2. Macro'!N7","v":44940.877442114303},{"$f":"'2. Macro'!O7","v":47431.063606970703}]
[null,"Grynasis skolinimas (+) / grynasis skolinimasis (-), iš jo","B=VP–VI","Net lending (+) /net borrowing (-), of which","B=TR–TE",{"$f":"F10-F11","v":0.60000000000000142},0.40600000000000003,{"$f":"H10-H11","v":267.51826914356025},188.22768582446224,0.38164301460938788,9.8518727886244051E-2,171.5137194619947,46.728480488505738]
[null,"Valstybinis socialinio draudimo fondas","VSDF","State Social Insurance Fund","SSIF",{"$f":"H8/H6*100","v":0.51364791062647486},{"$f":"I8/I6*100","v":0.84357229014694435},229.017,396.95915000000036,{"$f":"L8/L6*100","v":0.45910096051362909},{"$f":"M8/M6*100","v":0.73998225098016557},206.32399999999961,350.9814521426959]
[null,"Privalomojo sveikatos draudimo fondas","PSDF","National Health Insurance Fund","NHIF",{"$f":"H9/H6*100","v":0.2093688785416869},{"$f":"I9/I6*100","v":0.2103835035029358},93.350000000000136,99,{"$f":"L9/L6*100","v":0.20771735069089109},{"$f":"M9/M6*100","v":0.20872397216378352},{"$f":"H9","v":93.350000000000136},{"$f":"I9","v":99}]
[null,"Visos pajamos","VP","Total revenues","TR",36,36.6,{"$f":"F10*H6/100","v":16051.096148613533},{"$f":"G10*I6/100","v":17222.833252938188},{"$f":"L10/L6*100","v":35.97489363617867},{"$f":"M10/M6*100","v":36.123614713078297},16167.432858966034,17133.814671697197]
[null,"Visos išlaidos, iš jų","VI","Total expenditures, of which","TE",35.4,36.200000000000003,{"$f":"F11*H6/100","v":15783.577879469973},{"$f":"G11*I6/100","v":17034.605567113726},{"$f":"L11/L6*100","v":35.593250621569283},{"$f":"M11/M6*100","v":36.025095985192053},15995.91913950404,17087.086191208691]
[null,"Centrinė valdžia, be pervedimų SAF","CV","Central government, net of transfers to SSF","CG",{"$f":"H12/H6*100","v":19.780032283179889},{"$f":"I12/I6*100","v":20.460752004312795},8819.2000000000007,9628.2000000000007,{"$f":"L12/L6*100","v":18.665648115294132},{"$f":"M12/M6*100","v":19.340154536724018},8388.5060432706541,9173.241]
[null,"Socialinės apsaugos fondai, be pervedimų CV","SAF","Social Security Funds, net of transfers to CG","SSF",{"$f":"H13/H6*100","v":11.50194343680055},{"$f":"I13/I6*100","v":11.564717434979562},5128.3,5442,{"$f":"L13/L6*100","v":12.706022501129333},{"$f":"M13/M6*100","v":12.665328464439362},5710.1979999999994,6007.3]
[null,"Konsoliduotos išlaidos VS posektorių, kurių išlaidos > 3 proc. BVP","AV3=CV+SAF","Consolidated expenditure of GG subsectors with exp.    >  3 % of GDP","AG3=CG+SSF",{"$f":"H14/H6*100","v":31.281975719980437},{"$f":"I14/I6*100","v":32.025469439292351},{"$f":"H12+H13","v":13947.5},{"$f":"I12+I13","v":15070.2},{"$f":"SUM(J12:J13)","v":31.371670616423465},{"$f":"SUM(K12:K13)","v":32.005483001163384},{"$f":"L12+L13","v":14098.704043270653},{"$f":"M12+M13","v":15180.541000000001}]
[null,"Vienkartinės ir kitos laikinosios priemonės","1klp","One-off and temporary measures","1off",-1.1209999999999999E-2,5.398E-2,{"$f":"F15*H6/100","v":-4.9981329951654914},{"$f":"G15*I6/100","v":25.40132620201102},{"$f":"L15/$L$6*100","v":-1.1121574120583854E-2},{"$f":"M15/$M$6*100","v":5.3554199021330649E-2},{"$f":"H15","v":-4.9981329951654914},25.40132620201102]
[null,"Vienkartinės ir kitos laikinosios priemonės, VSDF","1klpVSDF","One-off and temporary measures, SSIF","1offSSIF",{"$f":"H16/$H$6*100","v":0},{"$f":"I16/I6*100","v":0},0,0,{"$f":"L16/$L$6*100","v":0},{"$f":"M16/$M$6*100","v":0},0,0]
[null,"Vienkartinės ir kitos laikinosios priemonės, PSDF","1klpPSDF","One-off and temporary measures, NHIF","1offNHIF",{"$f":"H17/$H$6*100","v":0},{"$f":"I17/I7*100","v":0},0,0,{"$f":"L17/$L$6*100","v":0},{"$f":"M17/$M$6*100","v":0},0,0]
[null,"Lankstumo galimybė dėl vykdomų struktūrinių reformų","SR","Structural reform flexibility clause","SR",0.5,0.5,null,null,0,0]
[null,"Struktūrinis VS balansas, neįtraukiant struktūrinių reformų","SB = B–CB–1klp+SR","Structural GG balance, excluding structural reforms","SB = B–CB–1off+SR",{"$f":"F7-F15-'2. Macro'!N22+F18","v":0.12273185972125655},{"$f":"G7-G15-'2. Macro'!O22+G18","v":0.24061265950165878},null,null,{"$f":"J7-J15-'2. Macro'!N21+J18","v":-0.54870694558698174},{"$f":"K7-K15-'2. Macro'!O21+K18","v":-0.89977880299630364}]
[null,"Struktūrinis VSDF balansas","SBVSDF = VSDF– CBVSDF–1klpVSDF","Structural SSIF balance","SBSSIF = SSIF– CBSSIF–1offSSIF",{"$f":"F8-F16-'2. Macro'!N24","v":0.27191354702319825},{"$f":"G8-G16-'2. Macro'!O24","v":0.69405136668366962},null,null,{"$f":"J8-J16-'2. Macro'!N23","v":0.2288621591431392},{"$f":"K8-K16-'2. Macro'!O23","v":0.50894332478650228}]
[null,"Struktūrinis PSDF balansas","SBPSDF = PSDF– CBPSDF–1klpPSDF","Structural NHIF balance","SBNHIF = NHIF– CBNHIF–1offNHIF",{"$f":"F9-F17-'2. Macro'!N26","v":0.10166544921349435},{"$f":"G9-G17-'2. Macro'!O26","v":0.14376527027672428},null,null,{"$f":"J9-J17-'2. Macro'!N25","v":0.10513570651592036},{"$f":"K9-K17-'2. Macro'!O25","v":0.10578583673096326}]
[null,"Vidutinio laikotarpio tikslas","VLT","Medium-term objective","MTO",-1,-1,null,null,{"$f":"F22","v":-1},{"$f":"G22","v":-1}]
[null,"Struktūrinio postūmio užduotis","SPU","Structural adjustment target","SAT",0,0,null,null,{"$f":"F23","v":0},{"$f":"G23","v":0}]
[]
[null,null,"Šaltiniai:",null,"Sources:"]
[null,null,"Finansų ministerija, VSDF, PSDF",null,"Ministry of Finance, SSIF, NHIF"]
[null,null,"Fiskalinės institucijos skaičiavimai",null,"Independent fiscal institution calculations"]
[]
[null,null,"Dėmesio: langeliai su formulėmis, atnaujinami tik spalvoti langeliai",null,"Warning: cells with formulas, data inputs are marked with coloured cells"]

{"sheet":"4. Municipalities","index":5,"n_rows":72,"n_cols":27,"rows_kept":72,"cut":false,"hidden":true,"merged":[[1,1,1,3],[0,1,0,2],[2,1,3,1],[2,2,3,2],[2,3,3,3],[2,16,2,17],[65,7,65,8],[70,7,70,8],[71,7,71,8],[2,14,2,15],[2,12,2,13],[2,10,2,11],[2,5,3,5],[1,4,1,6],[2,4,3,4],[2,6,3,6],[2,8,2,9],[2,7,3,7]]}
[null,"↖ back to content",null,null,"↖ atgal į turinį"]
[{"$f":"Kalba","v":"LT"},"Table 4. Budget attributable to local government",null,null,"4 lentelė. Vietos valdžios biudžetai"]
[null,"Local government","Appropriations, \n% of GDP","Code","Savivaldybė","Asignavimai, proc. BVP","Kodas","εi",{"$f":"IF(A2=\"LT\",\"Pajamos\",\"Revenues\")","v":"Pajamos"},null,{"$f":"IF(A2=\"LT\",\"Išlaidos\",\"Expenditures\")","v":"Išlaidos"},null,{"$f":"IF(A2=\"LT\",\"Balansas\",\"Balance\")","v":"Balansas"},null,{"$f":"IF($A$2=\"LT\",\"Fiskalinė taisyklė, planavimas\", \"Fiscal rule, plan\")","v":"Fiskalinė taisyklė, planavimas"},null,{"$f":"IF($A$2=\"LT\",\"Fiskalinė taisyklė, vykdymas\", \"Fiscal rule, implementation\")","v":"Fiskalinė taisyklė, vykdymas"}]
[null,null,null,null,null,null,null,null,{"$f":"IF($A$2=\"LT\",\"Planavimas\",\"Plan\")","v":"Planavimas"},{"$f":"IF($A$2=\"LT\",\"Vykdymas\",\"Implementation\")","v":"Vykdymas"},{"$f":"I4","v":"Planavimas"},{"$f":"J4","v":"Vykdymas"},{"$f":"K4","v":"Planavimas"},{"$f":"L4","v":"Vykdymas"},"FM","IFI","FM","IFI",null,{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""}]
[null,"Vilniaus m.",{"$f":"K5/$H$67/10","v":1.5940666791760281},1,"Vilniaus m.",{"$f":"K5/$H$68/10","v":1.2946115460030396},1,{"$f":"IF(F5>0.3, K5/'3. GGbudget'!$I$11/1000*'2. Macro'!$N$38,0)","v":1.3994572651581048E-2},559989.4,587979.80000000005,577220.4,546819.69999999995,{"$f":"I5-K5","v":-17231},{"$f":"J5-L5","v":41160.100000000093},{"$f":"IF(H5>0,IF(M5/$H$67/10-H5*$H$69<-eps,1,0),IF(($H$69+eps>=0)*(M5<0),1,IF(($H$69+eps<0)*(K5/I5>1.015),1,0)))","v":1},{"$f":"IF(H5>0,IF(M5/$I$67/10-H5*$I$69<-eps,1,0),IF(($I$69+eps>=0)*(M5<0),1,IF(($I$69+eps<0)*(K5/I5>1.015),1,0)))","v":1},{"$f":"IF(H5>0,IF(N5/$H$68/10-H5*$H$69<-eps,1,0),IF(($H$69+eps>=0)*(N5<0),1,IF(($H$69+eps<0)*(L5/J5>1.015),1,0)))","v":0},{"$f":"IF(H5>0,IF(N5/$I$68/10-H5*$I$69<-eps,1,0),IF(($I$69+eps>=0)*(N5<0),1,IF(($I$69+eps<0)*(L5/J5>1.015),1,0)))","v":0},null,{"$f":"CONCATENATE(T4,IF((H5>0)*(O5=1),CONCATENATE(E5,\" \"),\"\"))","v":"Vilniaus m. "},{"$f":"CONCATENATE(U4,IF((H5=0)*(O5=1),CONCATENATE(E5,\" \"),\"\"))","v":""},{"$f":"CONCATENATE(V4,IF((H5>0)*(P5=1),CONCATENATE(E5,\" \"),\"\"))","v":"Vilniaus m. "},{"$f":"CONCATENATE(W4,IF((H5=0)*(P5=1),CONCATENATE(E5,\" \"),\"\"))","v":""},{"$f":"CONCATENATE(X4,IF((H5>0)*(Q5=1),CONCATENATE(E5,\" \"),\"\"))","v":""},{"$f":"CONCATENATE(Y4,IF((H5=0)*(Q5=1),CONCATENATE(E5,\" \"),\"\"))","v":""},{"$f":"CONCATENATE(Z4,IF((H5>0)*(R5=1),CONCATENATE(E5,\" \"),\"\"))","v":""},{"$f":"CONCATENATE(AA4,IF((H5=0)*(R5=1),CONCATENATE(E5,\" \"),\"\"))","v":""}]
[null,"Alytaus m.",0.15138403485461069,2,"Alytaus m.",{"$f":"K6/$H$68/10","v":0.12294562201413642},2,{"$f":"IF(F6>0.3, K6/'3. GGbudget'!$I$11/1000*'2. Macro'!$N$38,0)","v":0},49115,59218.1,54817,51667.5,-5702,7550.5999999999985,{"$f":"IF(H6>0,IF(M6/$H$67/10-H6*$H$69<-eps,1,0),IF(($H$69+eps>=0)*(M6<0),1,IF(($H$69+eps<0)*(K6/I6>1.015),1,0)))","v":1},1,{"$f":"IF(H6>0,IF(N6/$H$68/10-H6*$H$69<-eps,1,0),IF(($H$69+eps>=0)*(N6<0),1,IF(($H$69+eps<0)*(L6/J6>1.015),1,0)))","v":0},{"$f":"IF(H6>0,IF(N6/$I$68/10-H6*$I$69<-eps,1,0),IF(($I$69+eps>=0)*(N6<0),1,IF(($I$69+eps<0)*(L6/J6>1.015),1,0)))","v":0},null,{"$f":"CONCATENATE(T5,IF((H6>0)*(O6=1),CONCATENATE(E6,\" \"),\"\"))","v":"Vilniaus m. "},{"$f":"CONCATENATE(U5,IF((H6=0)*(O6=1),CONCATENATE(E6,\" \"),\"\"))","v":"Alytaus m. "},{"$f":"CONCATENATE(V5,IF((H6>0)*(P6=1),CONCATENATE(E6,\" \"),\"\"))","v":"Vilniaus m. "},{"$f":"CONCATENATE(W5,IF((H6=0)*(P6=1),CONCATENATE(E6,\" \"),\"\"))","v":"Alytaus m. "},{"$f":"CONCATENATE(X5,IF((H6>0)*(Q6=1),CONCATENATE(E6,\" \"),\"\"))","v":""},{"$f":"CONCATENATE(Y5,IF((H6=0)*(Q6=1),CONCATENATE(E6,\" \"),\"\"))","v":""},{"$f":"CONCATENATE(Z5,IF((H6>0)*(R6=1),CONCATENATE(E6,\" \"),\"\"))","v":""},{"$f":"CONCATENATE(AA5,IF((H6=0)*(R6=1),CONCATENATE(E6,\" \"),\"\"))","v":""}]
[null,"Birštono m.",2.350474848048165E-2,3,"Birštono m.",1.9089238340053594E-2,3,{"$f":"IF(F7>0.3, K7/'3. GGbudget'!$I$11/1000*'2. Macro'!$N$38,0)","v":0},8517.7000000000007,8679.6,8511.2000000000007,8096.9,6.5,582.70000000000073,0,0,0,0,null,"Vilniaus m. ","Alytaus m. ","Vilniaus m. ","Alytaus m. ","","","",""]
[null,"Druskininkų m.",6.3203117618432086E-2,4,"Druskininkų m.",5.1330027081743411E-2,4,{"$f":"IF(F8>0.3, K8/'3. GGbudget'!$I$11/1000*'2. Macro'!$N$38,0)","v":0},22174.400000000001,23007.599999999999,22886.2,21486.799999999999,-711.79999999999927,1520.7999999999993,{"$f":"IF(H8>0,IF(M8/$H$67/10-H8*$H$69<-eps,1,0),IF(($H$69+eps>=0)*(M8<0),1,IF(($H$69+eps<0)*(K8/I8>1.015),1,0)))","v":1},1,0,0,null,"Vilniaus m. ","Alytaus m. Druskininkų m. ","Vilniaus m. ","Alytaus m. Druskininkų m. ","","","",""]
[null,"Kauno m.",0.88714960410014909,5,"Kauno m.",0.72049314843827283,5,{"$f":"IF(F9>0.3, K9/'3. GGbudget'!$I$11/1000*'2. Macro'!$N$38,0)","v":7.7884317824260339E-3},321241.8,320978.59999999998,321241.8,292694,0,28284.599999999977,0,0,0,0,null,"Vilniaus m. ","Alytaus m. Druskininkų m. ","Vilniaus m. ","Alytaus m. Druskininkų m. ","","","",""]
[null,"Klaipėdos m.",0.5194123571506718,6,"Klaipėdos m.",0.42183758276127853,6,{"$f":"IF(F10>0.3, K10/'3. GGbudget'!$I$11/1000*'2. Macro'!$N$38,0)","v":4.5600062175763911E-3},191141.8,195975.3,188082.1,169971.5,3059.6999999999825,26003.799999999988,0,0,0,0,null,"Vilniaus m. ","Alytaus m. Druskininkų m. ","Vilniaus m. ","Alytaus m. Druskininkų m. ","","","",""]
[null,"Marijampolės m.",0.16429021630360532,7,"Marijampolės m.",0.13342729868233907,7,{"$f":"IF(F11>0.3, K11/'3. GGbudget'!$I$11/1000*'2. Macro'!$N$38,0)","v":0},59490.400000000001,59337.4,59490.400000000001,58823,0,514.40000000000146,0,0,0,0,null,"Vilniaus m. ","Alytaus m. Druskininkų m. ","Vilniaus m. ","Alytaus m. Druskininkų m. ","","","",""]
[null,"Neringos m.",3.2065788085883132E-2,8,"Neringos m.",2.6042034520870182E-2,8,{"$f":"IF(F12>0.3, K12/'3. GGbudget'!$I$11/1000*'2. Macro'!$N$38,0)","v":0},11611.2,12023,11611.2,10369.200000000001,0,1653.7999999999993,0,0,0,0,null,"Vilniaus m. ","Alytaus m. Druskininkų m. ","Vilniaus m. ","Alytaus m. Druskininkų m. ","","","",""]
[null,"Palangos m.",7.3159054354378167E-2,9,"Palangos m.",5.941568047253757E-2,9,{"$f":"IF(F13>0.3, K13/'3. GGbudget'!$I$11/1000*'2. Macro'!$N$38,0)","v":0},27105.7,27576.400000000001,26491.3,25205,614.40000000000146,2371.4000000000015,0,0,0,0,null,"Vilniaus m. ","Alytaus m. Druskininkų m. ","Vilniaus m. ","Alytaus m. Druskininkų m. ","","","",""]
[null,"Panevėžio m.",0.21543303841857001,10,"Panevėžio m.",0.17496263021529407,10,{"$f":"IF(F14>0.3, K14/'3. GGbudget'!$I$11/1000*'2. Macro'!$N$38,0)","v":0},83380.100000000006,82619.7,78009.5,78496.899999999994,5370.6000000000058,4122.8000000000029,0,0,0,0,null,"Vilniaus m. ","Alytaus m. Druskininkų m. ","Vilniaus m. ","Alytaus m. Druskininkų m. ","","","",""]
[null,"Šiaulių m.",0.30699308083577093,11,"Šiaulių m.",0.24932256108537967,11,{"$f":"IF(F15>0.3, K15/'3. GGbudget'!$I$11/1000*'2. Macro'!$N$38,0)","v":0},113796.2,114535.3,111163.9,97994.2,2632.3000000000029,16541.100000000006,0,0,0,0,null,"Vilniaus m. ","Alytaus m. Druskininkų m. ","Vilniaus m. ","Alytaus m. Druskininkų m. ","","","",""]
[null,"Visagino m.",5.9830896501607632E-2,12,"Visagino m.",4.8591298237744981E-2,12,{"$f":"IF(F16>0.3, K16/'3. GGbudget'!$I$11/1000*'2. Macro'!$N$38,0)","v":0},22001.599999999999,22324.7,21665.1,19705,336.5,2619.7000000000007,0,0,0,0,null,"Vilniaus m. ","Alytaus m. Druskininkų m. ","Vilniaus m. ","Alytaus m. Druskininkų m. ","","","",""]
[null,"Akmenės raj.",7.4690651956041285E-2,13,"Akmenės raj.",6.0659558137660427E-2,13,{"$f":"IF(F17>0.3, K17/'3. GGbudget'!$I$11/1000*'2. Macro'!$N$38,0)","v":0},27045.9,27433.3,27045.9,24110.2,0,3323.0999999999985,0,0,0,0,null,"Vilniaus m. ","Alytaus m. Druskininkų m. ","Vilniaus m. ","Alytaus m. Druskininkų m. ","","","",""]
[null,"Alytaus raj.",5.9349821308297669E-2,14,"Alytaus raj.",4.8200595949132646E-2,14,{"$f":"IF(F18>0.3, K18/'3. GGbudget'!$I$11/1000*'2. Macro'!$N$38,0)","v":0},24665.200000000001,25690.5,21490.9,19221.400000000001,3174.2999999999993,6469.0999999999985,0,0,{"$f":"IF(H18>0,IF(N18/$H$68/10-H18*$H$69<-eps,1,0),IF(($H$69+eps>=0)*(N18<0),1,IF(($H$69+eps<0)*(L18/J18>1.015),1,0)))","v":0},{"$f":"IF(H18>0,IF(N18/$I$68/10-H18*$I$69<-eps,1,0),IF(($I$69+eps>=0)*(N18<0),1,IF(($I$69+eps<0)*(L18/J18>1.015),1,0)))","v":0},null,"Vilniaus m. ","Alytaus m. Druskininkų m. ","Vilniaus m. ","Alytaus m. Druskininkų m. ","","","",""]
[null,"Anykščių raj.",7.5996348577148973E-2,15,"Anykščių raj.",6.1719971697108841E-2,15,{"$f":"IF(F19>0.3, K19/'3. GGbudget'!$I$11/1000*'2. Macro'!$N$38,0)","v":0},27518.7,28085.200000000001,27518.7,26058.400000000001,0,2026.7999999999993,0,0,0,0,null,"Vilniaus m. ","Alytaus m. Druskininkų m. ","Vilniaus m. ","Alytaus m. Druskininkų m. ","","","",""]
[null,"Biržų raj.",6.5543871544089596E-2,16,"Biržų raj.",5.3231056127827324E-2,16,{"$f":"IF(F20>0.3, K20/'3. GGbudget'!$I$11/1000*'2. Macro'!$N$38,0)","v":0},23733.8,24028,23733.8,23132.6,0,895.40000000000146,0,0,0,0,null,"Vilniaus m. ","Alytaus m. Druskininkų m. ","Vilniaus m. ","Alytaus m. Druskininkų m. ","","","",""]
[null,"Ignalinos raj.",5.0878810700036844E-2,17,"Ignalinos raj.",4.1320916270088513E-2,17,{"$f":"IF(F21>0.3, K21/'3. GGbudget'!$I$11/1000*'2. Macro'!$N$38,0)","v":0},18423.5,18753.900000000001,18423.5,17555.2,0,1198.7000000000007,0,0,0,0,null,"Vilniaus m. ","Alytaus m. Druskininkų m. ","Vilniaus m. ","Alytaus m. Druskininkų m. ","","","",""]
[null,"Jonavos raj.",0.12642335731607496,18,"Jonavos raj.",0.10267395975584845,18,{"$f":"IF(F22>0.3, K22/'3. GGbudget'!$I$11/1000*'2. Macro'!$N$38,0)","v":0},46867.5,46776.6,45778.6,41451.9,1088.9000000000015,5324.6999999999971,0,0,0,0,null,"Vilniaus m. ","Alytaus m. Druskininkų m. ","Vilniaus m. ","Alytaus m. Druskininkų m. ","","","",""]
[null,"Joniškio raj.",6.5970818874088011E-2,19,"Joniškio raj.",5.3577798801877088E-2,19,{"$f":"IF(F23>0.3, K23/'3. GGbudget'!$I$11/1000*'2. Macro'!$N$38,0)","v":0},23888.400000000001,24133.7,23888.400000000001,23432.1,0,701.60000000000218,0,0,0,0,null,"Vilniaus m. ","Alytaus m. Druskininkų m. ","Vilniaus m. ","Alytaus m. Druskininkų m. ","","","",""]
[null,"Jurbarko raj.",7.3117629969190745E-2,20,"Jurbarko raj.",5.9382037910372318E-2,20,{"$f":"IF(F24>0.3, K24/'3. GGbudget'!$I$11/1000*'2. Macro'!$N$38,0)","v":0},26476.3,26516.7,26476.3,25097,0,1419.7000000000007,0,0,0,0,null,"Vilniaus m. ","Alytaus m. Druskininkų m. ","Vilniaus m. ","Alytaus m. Druskininkų m. ","","","",""]
[null,"Kaišiadorių raj.",7.934261041258929E-2,21,"Kaišiadorių raj.",6.4437617868817049E-2,21,{"$f":"IF(F25>0.3, K25/'3. GGbudget'!$I$11/1000*'2. Macro'!$N$38,0)","v":0},31073.7,29913.599999999999,28730.400000000001,26162.2,2343.2999999999993,3751.3999999999978,0,0,0,0,null,"Vilniaus m. ","Alytaus m. Druskininkų m. ","Vilniaus m. ","Alytaus m. Druskininkų m. ","","","",""]
[null,"Kauno raj.",0.20002951886790946,22,"Kauno raj.",0.16245275561602285,22,{"$f":"IF(F26>0.3, K26/'3. GGbudget'!$I$11/1000*'2. Macro'!$N$38,0)","v":0},73871.5,72224.2,72431.8,69139.5,1439.6999999999971,3084.6999999999971,0,0,0,0,null,"Vilniaus m. ","Alytaus m. Druskininkų m. ","Vilniaus m. ","Alytaus m. Druskininkų m. ","","","",""]
[null,"Kėdainių raj.",0.13850408884956811,23,"Kėdainių raj.",0.11248525230197173,23,{"$f":"IF(F27>0.3, K27/'3. GGbudget'!$I$11/1000*'2. Macro'!$N$38,0)","v":0},50153.1,52993.3,50153.1,47284.9,0,5708.4000000000015,0,0,0,0,null,"Vilniaus m. ","Alytaus m. Druskininkų m. ","Vilniaus m. ","Alytaus m. Druskininkų m. ","","","",""]
[null,"Kelmės raj.",8.8472268745330179E-2,24,"Kelmės raj.",7.1852214286288518E-2,24,{"$f":"IF(F28>0.3, K28/'3. GGbudget'!$I$11/1000*'2. Macro'!$N$38,0)","v":0},32036.3,30528.7,32036.3,29428.5,0,1100.2000000000007,0,0,0,0,null,"Vilniaus m. ","Alytaus m. Druskininkų m. ","Vilniaus m. ","Alytaus m. Druskininkų m. ","","","",""]
[null,"Klaipėdos raj.",0.12964258437027384,25,"Klaipėdos raj.",0.10528843540358326,25,{"$f":"IF(F29>0.3, K29/'3. GGbudget'!$I$11/1000*'2. Macro'!$N$38,0)","v":0},47423.4,46245.1,46944.3,45315.1,479.09999999999854,930,0,0,0,0,null,"Vilniaus m. ","Alytaus m. Druskininkų m. ","Vilniaus m. ","Alytaus m. Druskininkų m. ","","","",""]
[null,"Kretingos raj.",0.10579594663071197,26,"Kretingos raj.",8.5921533783792553E-2,26,{"$f":"IF(F30>0.3, K30/'3. GGbudget'!$I$11/1000*'2. Macro'!$N$38,0)","v":0},38358.400000000001,37808.199999999997,38309.300000000003,36224.400000000001,49.099999999998545,1583.7999999999956,0,0,0,0,null,"Vilniaus m. ","Alytaus m. Druskininkų m. ","Vilniaus m. ","Alytaus m. Druskininkų m. ","","","",""]
[null,"Kupiškio raj.",6.2777551101273241E-2,27,"Kupiškio raj.",5.0984405826432488E-2,27,{"$f":"IF(F31>0.3, K31/'3. GGbudget'!$I$11/1000*'2. Macro'!$N$38,0)","v":0},22898.1,23403.3,22732.1,22063.5,166,1339.7999999999993,0,0,0,0,null,"Vilniaus m. ","Alytaus m. Druskininkų m. ","Vilniaus m. ","Alytaus m. Druskininkų m. ","","","",""]
[null,"Lazdijų raj.",5.9719602986737418E-2,28,"Lazdijų raj.",4.8500911887394367E-2,28,{"$f":"IF(F32>0.3, K32/'3. GGbudget'!$I$11/1000*'2. Macro'!$N$38,0)","v":0},21624.799999999999,22132.400000000001,21624.799999999999,20225.5,0,1906.9000000000015,0,0,0,0,null,"Vilniaus m. ","Alytaus m. Druskininkų m. ","Vilniaus m. ","Alytaus m. Druskininkų m. ","","","",""]
[null,"Mažeikių raj.",0.14975550419160902,30,"Mažeikių raj.",0.12162302075354688,30,{"$f":"IF(F33>0.3, K33/'3. GGbudget'!$I$11/1000*'2. Macro'!$N$38,0)","v":0},54227.3,52534.7,54227.3,51246.6,0,1288.0999999999985,0,0,0,0,null,"Vilniaus m. ","Alytaus m. Druskininkų m. ","Vilniaus m. ","Alytaus m. Druskininkų m. ","","","",""]
[null,"Molėtų raj.",5.1297749315565702E-2,31,"Molėtų raj.",4.1661154715452994E-2,31,{"$f":"IF(F34>0.3, K34/'3. GGbudget'!$I$11/1000*'2. Macro'!$N$38,0)","v":0},18575.2,19023.5,18575.2,18245.599999999999,0,777.90000000000146,0,0,0,0,null,"Vilniaus m. ","Alytaus m. Druskininkų m. ","Vilniaus m. ","Alytaus m. Druskininkų m. ","","","",""]
[null,"Pakruojo raj.",5.866908057838429E-2,32,"Pakruojo raj.",4.7647736510883845E-2,32,{"$f":"IF(F35>0.3, K35/'3. GGbudget'!$I$11/1000*'2. Macro'!$N$38,0)","v":0},21244.400000000001,20687.2,21244.400000000001,20078.900000000001,0,608.29999999999927,0,0,0,0,null,"Vilniaus m. ","Alytaus m. Druskininkų m. ","Vilniaus m. ","Alytaus m. Druskininkų m. ","","","",""]
[null,"Panevėžio raj.",8.5271544583181688E-2,33,"Panevėžio raj.",6.9252765649654185E-2,33,{"$f":"IF(F36>0.3, K36/'3. GGbudget'!$I$11/1000*'2. Macro'!$N$38,0)","v":0},28639.599999999999,32231.3,30877.3,29335.1,-2237.7000000000007,2896.2000000000007,1,1,0,0,null,"Vilniaus m. ","Alytaus m. Druskininkų m. Panevėžio raj. ","Vilniaus m. ","Alytaus m. Druskininkų m. Panevėžio raj. ","","","",""]
[null,"Pasvalio raj.",{"$f":"K37/$H$67/10","v":7.1560625411279347E-2},34,"Pasvalio raj.",5.8117526140454775E-2,34,{"$f":"IF(F37>0.3, K37/'3. GGbudget'!$I$11/1000*'2. Macro'!$N$38,0)","v":0},25912.5,25886.9,25912.5,25543.7,{"$f":"I37-K37","v":0},{"$f":"J37-L37","v":343.20000000000073},{"$f":"IF(H37>0,IF(M37/$H$67/10-H37*$H$69<-eps,1,0),IF(($H$69+eps>=0)*(M37<0),1,IF(($H$69+eps<0)*(K37/I37>1.015),1,0)))","v":0},{"$f":"IF(H37>0,IF(M37/$I$67/10-H37*$I$69<-eps,1,0),IF(($I$69+eps>=0)*(M37<0),1,IF(($I$69+eps<0)*(K37/I37>1.015),1,0)))","v":0},{"$f":"IF(H37>0,IF(N37/$H$68/10-H37*$H$69<-eps,1,0),IF(($H$69+eps>=0)*(N37<0),1,IF(($H$69+eps<0)*(L37/J37>1.015),1,0)))","v":0},{"$f":"IF(H37>0,IF(N37/$I$68/10-H37*$I$69<-eps,1,0),IF(($I$69+eps>=0)*(N37<0),1,IF(($I$69+eps<0)*(L37/J37>1.015),1,0)))","v":0},null,"Vilniaus m. ","Alytaus m. Druskininkų m. Panevėžio raj. ","Vilniaus m. ","Alytaus m. Druskininkų m. Panevėžio raj. ","","","",""]
[null,"Plungės raj.",9.4921769356444557E-2,35,"Plungės raj.",7.7090136931668857E-2,35,{"$f":"IF(F38>0.3, K38/'3. GGbudget'!$I$11/1000*'2. Macro'!$N$38,0)","v":0},34371.699999999997,34281.4,34371.699999999997,33241.800000000003,0,1039.5999999999985,0,0,0,0,null,"Vilniaus m. ","Alytaus m. Druskininkų m. Panevėžio raj. ","Vilniaus m. ","Alytaus m. Druskininkų m. Panevėžio raj. ","","","",""]
[null,"Prienų raj.",7.125684658657154E-2,36,"Prienų raj.",5.787081401790968E-2,36,{"$f":"IF(F39>0.3, K39/'3. GGbudget'!$I$11/1000*'2. Macro'!$N$38,0)","v":0},25802.5,26213.5,25802.5,25243.9,0,969.59999999999854,0,0,0,0,null,"Vilniaus m. ","Alytaus m. Druskininkų m. Panevėžio raj. ","Vilniaus m. ","Alytaus m. Druskininkų m. Panevėžio raj. ","","","",""]
[null,"Radviliškio raj.",0.1120344590399384,37,"Radviliškio raj.",9.0988103645877921E-2,37,{"$f":"IF(F40>0.3, K40/'3. GGbudget'!$I$11/1000*'2. Macro'!$N$38,0)","v":0},40568.300000000003,41333.4,40568.300000000003,37009.5,0,4323.9000000000015,0,0,0,0,null,"Vilniaus m. ","Alytaus m. Druskininkų m. Panevėžio raj. ","Vilniaus m. ","Alytaus m. Druskininkų m. Panevėžio raj. ","","","",""]
[null,"Raseinių raj.",9.4565519643832696E-2,38,"Raseinių raj.",7.680081089704778E-2,38,{"$f":"IF(F41>0.3, K41/'3. GGbudget'!$I$11/1000*'2. Macro'!$N$38,0)","v":0},34983.4,35149.199999999997,34242.699999999997,33395.800000000003,740.70000000000437,1753.3999999999942,0,0,0,0,null,"Vilniaus m. ","Alytaus m. Druskininkų m. Panevėžio raj. ","Vilniaus m. ","Alytaus m. Druskininkų m. Panevėžio raj. ","","","",""]
[null,"Rokiškio raj.",8.2928029031845013E-2,39,"Rokiškio raj.",6.7349493766092589E-2,39,{"$f":"IF(F42>0.3, K42/'3. GGbudget'!$I$11/1000*'2. Macro'!$N$38,0)","v":0},30028.7,30399.5,30028.7,29688.400000000001,0,711.09999999999854,0,0,0,0,null,"Vilniaus m. ","Alytaus m. Druskininkų m. Panevėžio raj. ","Vilniaus m. ","Alytaus m. Druskininkų m. Panevėžio raj. ","","","",""]
[null,"Skuodo r.",4.6826953503570704E-2,40,"Skuodo r.",3.8030225122832349E-2,40,{"$f":"IF(F43>0.3, K43/'3. GGbudget'!$I$11/1000*'2. Macro'!$N$38,0)","v":0},17100.7,17313.900000000001,16956.3,16324.4,144.40000000000146,989.50000000000182,0,0,0,0,null,"Vilniaus m. ","Alytaus m. Druskininkų m. Panevėžio raj. ","Vilniaus m. ","Alytaus m. Druskininkų m. Panevėžio raj. ","","","",""]
[null,"Šakių raj.",7.7931972015673451E-2,41,"Šakių raj.",6.32919764852167E-2,41,{"$f":"IF(F44>0.3, K44/'3. GGbudget'!$I$11/1000*'2. Macro'!$N$38,0)","v":0},28219.599999999999,28713,28219.599999999999,27599.599999999999,0,1113.4000000000015,0,0,0,0,null,"Vilniaus m. ","Alytaus m. Druskininkų m. Panevėžio raj. ","Vilniaus m. ","Alytaus m. Druskininkų m. Panevėžio raj. ","","","",""]
[null,"Šalčininkų raj.",8.3597723259041745E-2,42,"Šalčininkų raj.",6.7893381854430668E-2,42,{"$f":"IF(F45>0.3, K45/'3. GGbudget'!$I$11/1000*'2. Macro'!$N$38,0)","v":0},30466.5,31091.200000000001,30271.200000000001,30038.400000000001,195.29999999999927,1052.7999999999993,0,0,0,0,null,"Vilniaus m. ","Alytaus m. Druskininkų m. Panevėžio raj. ","Vilniaus m. ","Alytaus m. Druskininkų m. Panevėžio raj. ","","","",""]
[null,"Šiaulių raj.",9.8941039369896608E-2,43,"Šiaulių raj.",8.0354362596688364E-2,43,{"$f":"IF(F46>0.3, K46/'3. GGbudget'!$I$11/1000*'2. Macro'!$N$38,0)","v":0},35827.1,36107.300000000003,35827.1,34211,0,1896.3000000000029,0,0,0,0,null,"Vilniaus m. ","Alytaus m. Druskininkų m. Panevėžio raj. ","Vilniaus m. ","Alytaus m. Druskininkų m. Panevėžio raj. ","","","",""]
[null,"Šilalės raj.",6.692827449705338E-2,44,"Šilalės raj.",5.4355390555389696E-2,44,{"$f":"IF(F47>0.3, K47/'3. GGbudget'!$I$11/1000*'2. Macro'!$N$38,0)","v":0},24065.1,24831.7,24235.1,23360,-170,1471.7000000000007,1,1,0,0,null,"Vilniaus m. ","Alytaus m. Druskininkų m. Panevėžio raj. Šilalės raj. ","Vilniaus m. ","Alytaus m. Druskininkų m. Panevėžio raj. Šilalės raj. ","","","",""]
[null,"Šilutės raj.",0.11427579444114608,45,"Šilutės raj.",9.2808390542765268E-2,45,{"$f":"IF(F48>0.3, K48/'3. GGbudget'!$I$11/1000*'2. Macro'!$N$38,0)","v":0},41521.199999999997,42528.1,41379.9,41156.300000000003,141.29999999999563,1371.7999999999956,0,0,0,0,null,"Vilniaus m. ","Alytaus m. Druskininkų m. Panevėžio raj. Šilalės raj. ","Vilniaus m. ","Alytaus m. Druskininkų m. Panevėžio raj. Šilalės raj. ","","","",""]
[null,"Širvintų raj.",5.3489099291980556E-2,46,"Širvintų raj.",4.3440846253994268E-2,46,{"$f":"IF(F49>0.3, K49/'3. GGbudget'!$I$11/1000*'2. Macro'!$N$38,0)","v":0},19368.7,18757.099999999999,19368.7,17905.2,0,851.89999999999782,0,0,0,0,null,"Vilniaus m. ","Alytaus m. Druskininkų m. Panevėžio raj. Šilalės raj. ","Vilniaus m. ","Alytaus m. Druskininkų m. Panevėžio raj. Šilalės raj. ","","","",""]
[null,"Švenčionių raj.",7.3669678942455186E-2,47,"Švenčionių raj.",5.9830381122161116E-2,47,{"$f":"IF(F50>0.3, K50/'3. GGbudget'!$I$11/1000*'2. Macro'!$N$38,0)","v":0},25839.599999999999,25936.1,26676.2,24892,-836.60000000000218,1044.0999999999985,{"$f":"IF(H50>0,IF(M50/$H$67/10-H50*$H$69<-eps,1,0),IF(($H$69+eps>=0)*(M50<0),1,IF(($H$69+eps<0)*(K50/I50>1.015),1,0)))","v":1},1,0,0,null,"Vilniaus m. ","Alytaus m. Druskininkų m. Panevėžio raj. Šilalės raj. Švenčionių raj. ","Vilniaus m. ","Alytaus m. Druskininkų m. Panevėžio raj. Šilalės raj. Švenčionių raj. ","","","",""]
[null,"Tauragės raj.",0.1081201308022945,48,"Tauragės raj.",8.7809105805010362E-2,48,{"$f":"IF(F51>0.3, K51/'3. GGbudget'!$I$11/1000*'2. Macro'!$N$38,0)","v":0},39150.9,40272.400000000001,39150.9,37046.199999999997,0,3226.2000000000044,0,0,0,0,null,"Vilniaus m. ","Alytaus m. Druskininkų m. Panevėžio raj. Šilalės raj. Švenčionių raj. ","Vilniaus m. ","Alytaus m. Druskininkų m. Panevėžio raj. Šilalės raj. Švenčionių raj. ","","","",""]
[null,"Telšių raj.",0.11996860961617017,49,"Telšių raj.",9.7431775719260524E-2,49,{"$f":"IF(F52>0.3, K52/'3. GGbudget'!$I$11/1000*'2. Macro'!$N$38,0)","v":0},43441.3,42862.3,43441.3,42352.1,0,510.20000000000437,0,0,0,0,null,"Vilniaus m. ","Alytaus m. Druskininkų m. Panevėžio raj. Šilalės raj. Švenčionių raj. ","Vilniaus m. ","Alytaus m. Druskininkų m. Panevėžio raj. Šilalės raj. Švenčionių raj. ","","","",""]
[null,"Trakų raj.",9.2745055996129269E-2,50,"Trakų raj.",7.5322332431759315E-2,50,{"$f":"IF(F53>0.3, K53/'3. GGbudget'!$I$11/1000*'2. Macro'!$N$38,0)","v":0},33583.5,34099.300000000003,33583.5,31341,0,2758.3000000000029,0,0,0,0,null,"Vilniaus m. ","Alytaus m. Druskininkų m. Panevėžio raj. Šilalės raj. Švenčionių raj. ","Vilniaus m. ","Alytaus m. Druskininkų m. Panevėžio raj. Šilalės raj. Švenčionių raj. ","","","",""]
[null,"Ukmergės raj.",0.10244057143053042,51,"Ukmergės raj.",8.3196486248407989E-2,51,{"$f":"IF(F54>0.3, K54/'3. GGbudget'!$I$11/1000*'2. Macro'!$N$38,0)","v":0},37094.300000000003,39279.599999999999,37094.300000000003,35537.199999999997,0,3742.4000000000015,0,0,0,0,null,"Vilniaus m. ","Alytaus m. Druskininkų m. Panevėžio raj. Šilalės raj. Švenčionių raj. ","Vilniaus m. ","Alytaus m. Druskininkų m. Panevėžio raj. Šilalės raj. Švenčionių raj. ","","","",""]
[null,"Utenos raj.",9.0960217319687009E-2,52,"Utenos raj.",7.387278656993293E-2,52,{"$f":"IF(F55>0.3, K55/'3. GGbudget'!$I$11/1000*'2. Macro'!$N$38,0)","v":0},32937.199999999997,33371,32937.199999999997,32665,0,706,0,0,0,0,null,"Vilniaus m. ","Alytaus m. Druskininkų m. Panevėžio raj. Šilalės raj. Švenčionių raj. ","Vilniaus m. ","Alytaus m. Druskininkų m. Panevėžio raj. Šilalės raj. Švenčionių raj. ","","","",""]
[null,"Varėnos raj.",6.9488577664204271E-2,53,"Varėnos raj.",5.6434725180949399E-2,53,{"$f":"IF(F56>0.3, K56/'3. GGbudget'!$I$11/1000*'2. Macro'!$N$38,0)","v":0},24655.200000000001,25454.2,25162.2,24619,-507,835.20000000000073,1,1,0,0,null,"Vilniaus m. ","Alytaus m. Druskininkų m. Panevėžio raj. Šilalės raj. Švenčionių raj. Varėnos raj. ","Vilniaus m. ","Alytaus m. Druskininkų m. Panevėžio raj. Šilalės raj. Švenčionių raj. Varėnos raj. ","","","",""]
[null,"Vilkaviškio raj.",9.0571380424061043E-2,54,"Vilkaviškio raj.",7.3556995053075197E-2,54,{"$f":"IF(F57>0.3, K57/'3. GGbudget'!$I$11/1000*'2. Macro'!$N$38,0)","v":0},32796.400000000001,33069.5,32796.400000000001,32424.6,0,644.90000000000146,0,0,0,0,null,"Vilniaus m. ","Alytaus m. Druskininkų m. Panevėžio raj. Šilalės raj. Švenčionių raj. Varėnos raj. ","Vilniaus m. ","Alytaus m. Druskininkų m. Panevėžio raj. Šilalės raj. Švenčionių raj. Varėnos raj. ","","","",""]
[null,"Vilniaus  raj.",0.22835026637028127,55,"Vilniaus  raj.",0.18545327823340743,55,{"$f":"IF(F58>0.3, K58/'3. GGbudget'!$I$11/1000*'2. Macro'!$N$38,0)","v":0},82686.899999999994,86456.7,82686.899999999994,76886.100000000006,0,9570.5999999999913,0,0,0,0,null,"Vilniaus m. ","Alytaus m. Druskininkų m. Panevėžio raj. Šilalės raj. Švenčionių raj. Varėnos raj. ","Vilniaus m. ","Alytaus m. Druskininkų m. Panevėžio raj. Šilalės raj. Švenčionių raj. Varėnos raj. ","","","",""]
[null,"Zarasų raj.",5.0449377906927197E-2,56,"Zarasų raj.",4.0972155042308847E-2,56,{"$f":"IF(F59>0.3, K59/'3. GGbudget'!$I$11/1000*'2. Macro'!$N$38,0)","v":0},18268,18348.2,18268,17472,0,876.20000000000073,0,0,0,0,null,"Vilniaus m. ","Alytaus m. Druskininkų m. Panevėžio raj. Šilalės raj. Švenčionių raj. Varėnos raj. ","Vilniaus m. ","Alytaus m. Druskininkų m. Panevėžio raj. Šilalės raj. Švenčionių raj. Varėnos raj. ","","","",""]
[null,"Elektrėnų sav.",7.4120100090726476E-2,57,"Elektrėnų sav.",6.0196187914771174E-2,57,{"$f":"IF(F60>0.3, K60/'3. GGbudget'!$I$11/1000*'2. Macro'!$N$38,0)","v":0},26839.3,25920.9,26839.3,25553.1,0,367.80000000000291,0,0,0,0,null,"Vilniaus m. ","Alytaus m. Druskininkų m. Panevėžio raj. Šilalės raj. Švenčionių raj. Varėnos raj. ","Vilniaus m. ","Alytaus m. Druskininkų m. Panevėžio raj. Šilalės raj. Švenčionių raj. Varėnos raj. ","","","",""]
[null,"Kalvarijos sav.",2.7778088056416572E-2,58,"Kalvarijos sav.",2.255980505301991E-2,58,{"$f":"IF(F61>0.3, K61/'3. GGbudget'!$I$11/1000*'2. Macro'!$N$38,0)","v":0},9680.2000000000007,10249.4,10058.6,9893,-378.39999999999964,356.39999999999964,1,1,0,0,null,"Vilniaus m. ","Alytaus m. Druskininkų m. Panevėžio raj. Šilalės raj. Švenčionių raj. Varėnos raj. Kalvarijos sav. ","Vilniaus m. ","Alytaus m. Druskininkų m. Panevėžio raj. Šilalės raj. Švenčionių raj. Varėnos raj. Kalvarijos sav. ","","","",""]
[null,"Kazlų Rūdos sav.",2.9934365386706081E-2,59,"Kazlų Rūdos sav.",2.4311012555594615E-2,59,{"$f":"IF(F62>0.3, K62/'3. GGbudget'!$I$11/1000*'2. Macro'!$N$38,0)","v":0},10839.4,10951.5,10839.4,10455.799999999999,0,495.70000000000073,0,0,0,0,null,"Vilniaus m. ","Alytaus m. Druskininkų m. Panevėžio raj. Šilalės raj. Švenčionių raj. Varėnos raj. Kalvarijos sav. ","Vilniaus m. ","Alytaus m. Druskininkų m. Panevėžio raj. Šilalės raj. Švenčionių raj. Varėnos raj. Kalvarijos sav. ","","","",""]
[null,"Pagėgių sav.",2.9646880153505341E-2,60,"Pagėgių sav.",2.4077533174167838E-2,60,{"$f":"IF(F63>0.3, K63/'3. GGbudget'!$I$11/1000*'2. Macro'!$N$38,0)","v":0},10735.3,10783.7,10735.3,10294.799999999999,0,488.90000000000146,0,0,0,0,null,"Vilniaus m. ","Alytaus m. Druskininkų m. Panevėžio raj. Šilalės raj. Švenčionių raj. Varėnos raj. Kalvarijos sav. ","Vilniaus m. ","Alytaus m. Druskininkų m. Panevėžio raj. Šilalės raj. Švenčionių raj. Varėnos raj. Kalvarijos sav. ","","","",""]
[null,"Rietavo sav.",2.5025023416860203E-2,61,"Rietavo sav.",2.0323920371517958E-2,61,{"$f":"IF(F64>0.3, K64/'3. GGbudget'!$I$11/1000*'2. Macro'!$N$38,0)","v":0},9061.7000000000007,8751.2000000000007,9061.7000000000007,8497.5,0,253.70000000000073,0,0,0,0,null,"Vilniaus m. ","Alytaus m. Druskininkų m. Panevėžio raj. Šilalės raj. Švenčionių raj. Varėnos raj. Kalvarijos sav. ","Vilniaus m. ","Alytaus m. Druskininkų m. Panevėžio raj. Šilalės raj. Švenčionių raj. Varėnos raj. Kalvarijos sav. ","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"T3",{"$f":"SUMIF($H$5:$H$64,\">0\",O5:O64)","v":1},{"$f":"SUMIF($H$5:$H$64,\">0\",P5:P64)","v":1},{"$f":"SUMIF($H$5:$H$64,\">0\",Q5:Q64)","v":0},{"$f":"SUMIF($H$5:$H$64,\">0\",R5:R64)","v":0}]
[null,null,null,"t =",null,null,"t =",{"$f":" FirstYear + 7","v":2018},null,null,null,null,null,"T5",{"$f":"SUMIF($H$5:$H$64,\"=0\",O5:O64)","v":7},{"$f":"SUMIF($H$5:$H$64,\"=0\",P5:P64)","v":7},{"$f":"SUMIF($H$5:$H$64,\"=0\",Q5:Q64)","v":0},{"$f":"SUMIF($H$5:$H$64,\"=0\",R5:R64)","v":0}]
[null,null,null,"YNP(t–1) =",null,null,"Y*(t–1) =",{"$f":"+'2. Macro'!N16","v":36210.555526972363},{"$f":"+'2. Macro'!N15","v":36344.776630595697},null,null,null,null,null,{"$f":"T64","v":"Vilniaus m. "},{"$f":"V64","v":"Vilniaus m. "},{"$f":"X64","v":""},{"$f":"Z64","v":""}]
[null,null,null,"YN(t–1) =",null,null,"YN(t–1) =",{"$f":"'3. GGbudget'!H6","v":44586.378190593146},{"$f":"'3. GGbudget'!L6","v":44940.877442114303},null,null,null,null,null,{"$f":"U64","v":"Alytaus m. Druskininkų m. Panevėžio raj. Šilalės raj. Švenčionių raj. Varėnos raj. Kalvarijos sav. "},{"$f":"W64","v":"Alytaus m. Druskininkų m. Panevėžio raj. Šilalės raj. Švenčionių raj. Varėnos raj. Kalvarijos sav. "},{"$f":"Y64","v":""},{"$f":"AA64","v":""}]
[null,null,null,"AP(t) =",null,null,"AP(t) =",{"$f":"'2. Macro'!O20","v":1.4804051828047005},{"$f":"'2. Macro'!O19","v":2.2875141207293392}]
[null,null,null,"Sources:",null,null,"Šaltiniai:"]
[null,null,null,"Ministry of Finance",null,null,"Finansų ministerija","FM"]
[null,null,null,"Independent Fiscal Institution",null,null,"Fiskalinė institucija","IFI"]

{"sheet":"5. SurplusGG","index":6,"n_rows":31,"n_cols":11,"rows_kept":31,"cut":false,"hidden":false,"merged":[[0,6,0,7],[15,2,15,5],[15,7,15,10],[17,9,17,10],[4,7,4,8],[4,2,4,3],[5,8,6,8],[3,6,4,6],[0,1,0,2],[5,2,6,2],[5,1,6,1],[7,1,8,1],[9,1,10,1],[11,1,12,1],[2,1,2,5],[3,1,4,1],[20,9,20,10],[22,9,22,10],[25,9,25,10],[24,9,24,10],[7,3,8,3],[7,8,8,8],[13,3,14,3],[13,8,14,8],[11,3,12,3],[11,8,12,8],[9,6,10,6],[11,6,12,6],[9,8,10,8],[13,6,14,6],[7,6,8,6],[25,4,25,5],[24,4,24,5],[3,4,3,5],[20,4,20,5],[17,4,17,5],[5,6,6,6],[22,4,22,5],[13,1,14,1],[13,2,14,2],[2,6,2,10],[7,2,8,2],[9,2,10,2],[11,2,12,2],[9,3,10,3],[3,9,3,10],[5,3,6,3],[5,7,6,7],[13,7,14,7],[11,7,12,7],[9,7,10,7],[7,7,8,7]]}
[null,"↖ atgal į turinį ",null,null,null,null,"↖ back to content"]
[{"$f":"Kalba","v":"LT"}]
[null,"5 lentelė. Perteklinio VS taisyklės sąlygos",null,null,null,null,"Table 4. Conditions of the surplus GG sector rule"]
[null,"Nr.","Sąlyga","Formulė","Išvada",null,"No.","Condition","Formula","Conclusion"]
[null,null,"Institucija, kurios projekcijų pagrindu atliekama analizė",null,"FM","IFI",null,"Institution, projections of which are used for the analysis",null,"MoF","IFI"]
[null,"S1","VS yra faktiškai perteklinis t metais pagal struktūrinį balansą","SB(t) > 0*",{"$f":"IF(J6,\"Tiesa\",\"Netiesa\")","v":"Tiesa"},{"$f":"IF(K6,\"Tiesa\",\"Netiesa\")","v":"Netiesa"},"C1","In terms of structural balance GG sector is actually in surplus   ","SB(t) > 0*",{"$f":"IF(J19>eps,TRUE,FALSE)","v":true},{"$f":"IF(K19>eps,TRUE,FALSE)","v":false}]
[null,null,null,null,{"$f":"CONCATENATE(TEXT(ROUND(J19,1),\"0,0; –0,0\"),IF(J6,\" ≥ \",\" < \"),\"0,1\")","v":"0,2 ≥ 0,1"},{"$f":"CONCATENATE(TEXT(K19,\"0,0; –0,0\"),IF(K6,\" ≥ \",\" < \"),\"0,1\")","v":" –0,9 < 0,1"},null,null,null,{"$f":"CONCATENATE(TEXT(ROUND(J19,1),\"0.0; –0.0\"),IF(J6,\" ≥ \",\" < \"),\"0.1\")","v":"0.0 ≥ 0.1"},{"$f":"CONCATENATE(TEXT(ROUND(K19,1),\"0.0; –0.0\"),IF(K6,\" ≥ \",\" < \"),\"0.1\")","v":" –0.1 < 0.1"}]
[null,"S2","Faktinio struktūrinio VS balanso rodiklio absoliučioji vertė yra mažesnė negu VLT absoliučioji vertė ir kiekvienais metais mažėja, išskyrus metus, kai produkcijos atotrūkio nuo potencialo rodiklis yra neigiamas","|SB(t)| < |VLT| ir \n|SB(t)| < |SB(t–1)| ir\nAP(t) ≥ 0",{"$f":"IF(J8,\"Tiesa\",\"Netiesa\")","v":"Netiesa"},{"$f":"IF(K8,\"Tiesa\",\"Netiesa\")","v":"Netiesa"},"C2","Actual structural GG sector balance indicator in absolute value is lower than MTO in absolute value and is annually decreasing, with the exception of the  year when the output gap is negative","|SB(t)| < |MTO| and\n|SB(t)| < |SB(t–1)| and\nOG(t) ≥ 0",{"$f":"IF((J22>=-eps)*(ABS(J19)+eps<ABS($J$21))*(ABS(J19)+0.1<ABS(J20)),TRUE,FALSE)","v":false},{"$f":"IF((K22>=-eps)*(ABS(K19)+eps<ABS($J$21))*(ABS(K19)+0.1<ABS(K20)),TRUE,FALSE)","v":false}]
[null,null,null,null,{"$f":"CONCATENATE(TEXT(ROUND(ABS(E19),1),\"0,0; –0,0\"),IF(ABS(E19)+eps<ABS($E$21),\" < \",\" ≥ \"),TEXT(ROUND(ABS(E21),1),\"0,0; –0,0\"),\" ir \n\",TEXT(ROUND(ABS(E19),1),\"0,0; –0,0\"),IF(ABS(E19)+0.1<ABS(E20),\" < \",\" ≥ \"),TEXT(ROUND(ABS(E20),1),\"0,0; –0,0\"),\" ir\n \",TEXT(ROUND(E22,1),\"0,0; –0,0\"),IF(E22<-eps,\" < \",\" ≥ \"),\"0,0\")","v":"0,2 < 1,0 ir \n0,2 ≥ 0,1 ir\n 1,5 ≥ 0,0"},{"$f":"CONCATENATE(TEXT(ROUND(ABS(F19),1),\"0,0; –0,0\"),IF(ABS(F19)+eps<ABS($E$21),\" < \",\" ≥ \"),TEXT(ROUND(ABS(E21),1),\"0,0; –0,0\"),\" ir \n\",TEXT(ROUND(ABS(F19),1),\"0,0; –0,0\"),IF(ABS(F19)+0.1<ABS(F20),\" < \",\" ≥ \"),TEXT(ROUND(ABS(F20),1),\"0,0; –0,0\"),\" ir\n \",TEXT(ROUND(F22,1),\"0,0; –0,0\"),IF(F22<-eps,\" < \",\" ≥ \"),\"0,0\")","v":"0,9 < 1,0 ir \n0,9 ≥ 0,5 ir\n 2,3 ≥ 0,0"},null,null,null,{"$f":"CONCATENATE(TEXT(ROUND(ABS(J19),1),\"0.0; –0.0\"),IF(ABS(J19)+eps<ABS($J$21),\" < \",\" ≥ \"),TEXT(ROUND(ABS($J$21),1),\"0.0; –0.0\"),\" and\n\",TEXT(ROUND(ABS(J19),1),\"0.0; –0.0\"),IF(ABS(J19)+0.1<ABS(J20),\" < \",\" ≥ \"),TEXT(ROUND(ABS(J20),1),\"0.0; –0.0\"),\" and\n\",TEXT(ROUND(J22,1),\"0.0; –0.0\"),IF(J22<-eps,\" < \",\" ≥ \"),\"0.0\")","v":"0.0 < 0.1 and\n0.0 ≥ 0.0 and\n0.2 ≥ 0.0"},{"$f":"CONCATENATE(TEXT(ROUND(ABS(K19),1),\"0.0; –0.0\"),IF(ABS(K19)+eps<ABS($J$21),\" < \",\" ≥ \"),TEXT(ROUND(ABS($J$21),1),\"0.0; –0.0\"),\" and\n\",TEXT(ROUND(ABS(K19),1),\"0.0; –0.0\"),IF(ABS(K19)+0.1<ABS(K20),\" < \",\" ≥ \"),TEXT(ROUND(ABS(K20),1),\"0.0; –0.0\"),\" and\n\",TEXT(ROUND(K22,1),\"0.0; –0.0\"),IF(K22<-eps,\" < \",\" ≥ \"),\"0.0\")","v":"0.1 < 0.1 and\n0.1 ≥ 0.1 and\n0.2 ≥ 0.0"}]
[null,"S3","Faktinio struktūrinio VS balanso rodiklio absoliučioji vertė yra mažesnė negu VLT absoliučioji vertė tais metais, kai produkcijos atotrūkio nuo potencialo rodiklis yra neigiamas","|SB(t)| < |VLT| ir\nAP(t) < 0",{"$f":"IF(J10,\"Tiesa\",\"Netiesa\")","v":"Netiesa"},{"$f":"IF(K10,\"Tiesa\",\"Netiesa\")","v":"Netiesa"},"C3","Actual structural GG sector balance indicator in absolute value is lower than the MTO in absolute value in the year when the output gap is negative","|SB(t)| < |MTO| and\nOG(t) < 0",{"$f":"IF((J22<-eps)*(ABS(J19)+eps<ABS($J$21)),TRUE,FALSE)","v":false},{"$f":"IF((K22<-eps)*(ABS(K19)+eps<ABS($J$21)),TRUE,FALSE)","v":false}]
[null,null,null,null,{"$f":"CONCATENATE(TEXT(ROUND(ABS(E19),1),\"0,0; –0,0\"),IF(ABS(E19)+eps<ABS($E$21),\" < \",\" ≥ \"),TEXT(ROUND(ABS($E$21),1),\"0,0; –0,0\"),\" ir\n\",TEXT(ROUND(E22,1),\"0,0; –0,0\"),IF(E22<-eps,\" < \",\" ≥ \"),\"0,0\")","v":"0,2 < 1,0 ir\n1,5 ≥ 0,0"},{"$f":"CONCATENATE(TEXT(ROUND(ABS(F19),1),\"0,0; –0,0\"),IF(ABS(F19)+eps<ABS($E$21),\" < \",\" ≥ \"),TEXT(ROUND(ABS($E$21),1),\"0,0; –0,0\"),\" ir\n\",TEXT(ROUND(F22,1),\"0,0; –0,0\"),IF(F22<-eps,\" < \",\" ≥ \"),\"0,0\")","v":"0,9 < 1,0 ir\n2,3 ≥ 0,0"},null,null,null,{"$f":"CONCATENATE(TEXT(ROUND(ABS(J19),1),\"0.0; –0.0\"),IF(ABS(J19)+eps<ABS($J$21),\" < \",\" ≥ \"),TEXT(ROUND(ABS($J$21),1),\"0.0; –0.0\"),\" and\n\",TEXT(ROUND(J22,1),\"0.0; –0.0\"),IF(J22<-eps,\" < \",\" ≥ \"),\"0.0\")","v":"0.0 < 0.1 and\n0.2 ≥ 0.0"},{"$f":"CONCATENATE(TEXT(ROUND(ABS(K19),1),\"0.0; –0.0\"),IF(ABS(K19)+eps<ABS($J$21),\" < \",\" ≥ \"),TEXT(ROUND(ABS($J$21),1),\"0.0; –0.0\"),\" and\n\",TEXT(ROUND(K22,1),\"0.0; –0.0\"),IF(K22<-eps,\" < \",\" ≥ \"),\"0.0\")","v":"0.1 < 0.1 and\n0.2 ≥ 0.0"}]
[null,"S4","Faktinio struktūrinio VS balanso rodiklio postūmio VLT link absoliučioji vertė yra ne mažesnė negu struktūrinio postūmio užduoties absoliučioji vertė","SPU(t) > 0 ir\nSB(t) ≥ SB(t–1)+SPU(t)",{"$f":"IF(J12,\"Tiesa\",\"Netiesa\")","v":"Netiesa"},{"$f":"IF(K12,\"Tiesa\",\"Netiesa\")","v":"Netiesa"},"C4","Actual structural GG sector balance indicator adjustment towards the MTO in absolute value is not lower than the structural adjustment target in absolute value.","SAT(t) > 0 and\nSB(t) ≥ SB(t–1)+SAT(t)",{"$f":"IF(($J$23>0)*(J19>=J20+$J$23),TRUE,FALSE)","v":false},{"$f":"IF(($J$23>0)*(K19>=K20+$J$23),TRUE,FALSE)","v":false}]
[null,null,null,null,{"$f":"IF($E$23=0,\"Netaikoma\",CONCATENATE(TEXT(ROUND(E19,1),\"0,0; –0,0\"),IF(E19>=E20+$E$23,\" ≥ \",\" < \"),TEXT(ROUND(E20,1),\"0,0; –0,0\"),\" + \",TEXT(ROUND($E$23,1),\"0,0; –0,0\"),\" = \",TEXT(ROUND(J20+$E$23,1),\"0,0; –0,0\")))","v":"Netaikoma"},{"$f":"IF($E$23=0,\"Netaikoma\",CONCATENATE(TEXT(ROUND(F19,1),\"0,0; –0,0\"),IF(F19>=F20+$E$23,\" ≥ \",\" < \"),TEXT(ROUND(F20,1),\"0,0; –0,0\"),\" + \",TEXT(ROUND($E$23,1),\"0,0; –0,0\"),\" = \",TEXT(ROUND(K20+$E$23,1),\"0,0; –0,0\")))","v":"Netaikoma"},null,null,null,{"$f":"IF($J$23=0,\"Not aplicaple\",CONCATENATE(TEXT(ROUND(J19,1),\"0.0; –0.0\"),IF(J19>=J20+$J$23,\" ≥ \",\" < \"),TEXT(ROUND(J20,1),\"0.0; –0.0\"),\" + \",TEXT(ROUND($J$23,1),\"0.0; –0.0\"),\" = \",TEXT(ROUND(J20+$J$23,1),\"0.0; –0.0\")))","v":"Not aplicaple"},{"$f":"IF($J$23=0,\"Not aplicaple\",CONCATENATE(TEXT(ROUND(K19,1),\"0.0; –0.0\"),IF(K19>=K20+$J$23,\" ≥ \",\" < \"),TEXT(ROUND(K20,1),\"0.0; –0.0\"),\" + \",TEXT(ROUND($J$23,1),\"0.0; –0.0\"),\" = \",TEXT(ROUND(K20+$J$23,1),\"0.0; –0.0\")))","v":"Not aplicaple"}]
[null,"S","t metais, išskyrus metus, kuriais susidaro išskirtinės aplinkybės, turi būti tenkinama bent viena iš  S1–S4 sąlygų ",null,{"$f":"IF(OR(J6,J8,J10,J12),\"Taip\",\"Ne\")","v":"Taip"},{"$f":"IF(OR(K6,K8,K10,K12),\"Taip\",\"Ne\")","v":"Ne"},"C","At year t, with the exception of the year of exceptional circumstances, at least one of the C1–C4 conditions is satisfied ",null,{"$f":"IF(E31>0,\"Yes\",\"No\")","v":"Yes"},{"$f":"IF(F31>0,\"Yes\",\"No\")","v":"No"}]
[null,null,null,null,{"$f":"IF(J14=\"Yes\",IF(E31=1,CONCATENATE(\"Tenkinama \",I27,I28,I29,I30,\" sąlyga\"),CONCATENATE(\"Tenkinamos \", IF(E27=1,CONCATENATE(I27,\" \"),\"\"),IF(E28=1,CONCATENATE(I28,\" \"),\"\"),IF(E29=1,CONCATENATE(I29,\" \"),\"\"),IF(E30=1,CONCATENATE(I30,\" \"),\"\"),\"sąlygos\")),\"Netenkinama nei viena iš sąlygų\")","v":"Tenkinama S1 sąlyga"},{"$f":"IF(K14=\"Yes\",IF(F31=1,CONCATENATE(\"Tenkinama \",H27,H28,H29,H30,\" sąlyga\"),CONCATENATE(\"Tenkinamos \", IF(F27=1,CONCATENATE(H27,\" \"),\"\"),IF(F28=1,CONCATENATE(H28,\" \"),\"\"),IF(F29=1,CONCATENATE(H29,\" \"),\"\"),IF(F30=1,CONCATENATE(H30,\" \"),\"\"),\"sąlygos\")),\"Netenkinama nei viena iš sąlygų\")","v":"Netenkinama nei viena iš sąlygų"},null,null,null,{"$f":"IF(J14=\"Yes\",IF(E31=1,CONCATENATE(\"Condition \",J27,J28,J29,J30,\" is valid\"),CONCATENATE(\"Conditions \", IF(E27=1,CONCATENATE(J27,\" \"),\"\"),IF(E28=1,CONCATENATE(J28,\" \"),\"\"),IF(E29=1,CONCATENATE(J29,\" \"),\"\"),IF(E30=1,CONCATENATE(J30,\" \"),\"\"),\"are valid\")),\"None of the conditions is valid\")","v":"Condition C1 is valid"},{"$f":"IF(K14=\"Yes\",IF(F31=1,CONCATENATE(\"Condition \",K27,K28,K29,K30,\" is valid\"),CONCATENATE(\"Conditions \", IF(F27=1,CONCATENATE(K27,\" \"),\"\"),IF(F28=1,CONCATENATE(K28,\" \"),\"\"),IF(F29=1,CONCATENATE(K29,\" \"),\"\"),IF(F30=1,CONCATENATE(K30,\" \"),\"\"),\"are valid\")),\"None of the conditions is valid\")","v":"None of the conditions is valid"}]
[null,null,"* nelygybės ženklas yra griežtas, jei skirtumas tarp lyginamų pusių po apvalinimo sudaro bent 0,1, \nkitaip ženklas interpretuojamas kaip =",null,null,null,null,"* inequality sign is strict, if a difference between both compared sides\n after rounding is at least 0,1, else the sign is interpreted as ="]
[null,null,"Šaltinis: KĮ 3 straipsnis 1 dalis",null,null,null,null,"Source: CL Article 3(1)"]
[null,null,null,"t =",{"$f":"FirstYear+8","v":2019},null,null,null,"t =",{"$f":"E18","v":2019}]
[null,null,null,"SB(t) =",{"$f":"'3. GGbudget'!G19","v":0.24061265950165878},{"$f":"'3. GGbudget'!K19","v":-0.89977880299630364},null,null,"SB(t) =",{"$f":"E19","v":0.24061265950165878},{"$f":"F19","v":-0.89977880299630364}]
[null,null,null,"SB(t–1) =",{"$f":"'3. GGbudget'!F19","v":0.12273185972125655},{"$f":"'3. GGbudget'!J19","v":-0.54870694558698174},null,null,"SB(t–1) =",0.12273185972125655,{"$f":"F20","v":-0.54870694558698174}]
[null,null,null,"VLT =",{"$f":"'3. GGbudget'!F22","v":-1},null,null,null,"MTO =",-1]
[null,null,null,"AP(t) =",{"$f":"'2. Macro'!O20","v":1.4804051828047005},{"$f":"'2. Macro'!O19","v":2.2875141207293392},null,null,"OG(t) =",1.4804051828047005,{"$f":"F22","v":2.2875141207293392}]
[null,null,null,"SPU(t) =",{"$f":"'3. GGbudget'!F23","v":0},null,null,null,"SAT(t) =",0]
[null,null,null,"Šaltiniai:",null,null,null,null,"Sources:"]
[null,null,null,"Finansų ministerija","FM",null,null,null,"Ministry of Finance","MoF"]
[null,null,null,"Fiskalinė institucija","IFI",null,null,null,"Independent Fiscal Institution","IFI"]
[null,null,"S1","C1",{"$f":"J6*1","v":1},{"$f":"(K6)*1","v":0},{"$f":"IF(#REF!=1,$C27,\"\")","v":{"$error":"#REF!"}},{"$f":"IF(F27=1,$C27,\"\")","v":""},{"$f":"IF(E27=1,$C27,\"\")","v":"S1"},{"$f":"IF(E27=1,$D27,\"\")","v":"C1"},""]
[null,null,"S2","C2",{"$f":"J8*1","v":0},{"$f":"(K8)*1","v":0},{"$f":"IF(#REF!=1,$C28,\"\")","v":{"$error":"#REF!"}},{"$f":"IF(F28=1,$C28,\"\")","v":""},{"$f":"IF(E28=1,$C28,\"\")","v":""},"",""]
[null,null,"S3","C3",{"$f":"J10*1","v":0},{"$f":"(K10)*1","v":0},{"$f":"IF(#REF!=1,$C29,\"\")","v":{"$error":"#REF!"}},{"$f":"IF(F29=1,$C29,\"\")","v":""},{"$f":"IF(E29=1,$C29,\"\")","v":""},"",""]
[null,null,"S4","C4",{"$f":"J12*1","v":0},{"$f":"(K12)*1","v":0},{"$f":"IF(#REF!=1,$C30,\"\")","v":{"$error":"#REF!"}},{"$f":"IF(F30=1,$C30,\"\")","v":""},{"$f":"IF(E30=1,$C30,\"\")","v":""},"",""]
[null,null,null,null,{"$f":"SUM(E27:E30)","v":1},{"$f":"SUM(F27:F30)","v":0}]

{"sheet":"6. GGexpenditure","index":7,"n_rows":59,"n_cols":13,"rows_kept":59,"cut":false,"hidden":false,"merged":[[53,5,53,6],[53,11,53,12],[40,5,40,6],[39,5,39,6],[39,11,39,12],[40,11,40,12],[41,11,41,12],[52,5,52,6],[52,11,52,12],[45,5,45,6],[45,11,45,12],[51,5,51,6],[51,11,51,12],[42,5,42,6],[42,11,42,12],[41,5,41,6],[28,2,28,4],[23,3,23,4],[20,3,20,4],[20,5,20,6],[0,7,0,8],[4,8,4,10],[9,9,10,10],[5,2,6,2],[11,2,12,2],[11,7,12,7],[7,8,8,8],[7,2,8,2],[23,9,23,10],[21,8,25,8],[24,3,25,4],[24,9,25,10],[30,5,30,6],[30,11,30,12],[34,5,34,6],[33,11,33,12],[34,11,34,12],[33,5,33,6],[3,1,4,1],[18,2,19,2],[18,8,19,8],[18,1,19,1],[3,3,3,4],[3,5,3,6],[14,7,15,7],[16,7,17,7],[14,8,15,8],[16,8,17,8],[16,3,17,4],[16,2,17,2],[5,1,6,1],[5,3,6,4],[7,1,8,1],[5,8,6,8],[3,7,4,7],[11,3,12,4],[7,3,8,4],[7,9,8,10],[5,7,6,7],[7,7,8,7],[11,8,12,8],[11,9,12,10],[5,9,6,10],[4,2,4,4],[13,9,13,10],[18,7,19,7],[21,7,25,7],[18,3,19,4],[18,9,19,10],[21,3,22,4],[21,9,22,10],[11,1,12,1],[14,1,15,1],[16,1,17,1],[14,2,15,2],[14,3,15,4],[13,3,13,4],[21,1,25,1],[21,2,25,2],[26,1,27,1],[26,2,27,2],[26,8,27,8],[26,3,27,4],[26,9,27,10],[26,7,27,7],[20,11,20,12],[20,9,20,10],[0,1,0,2],[9,3,10,4],[9,2,10,2],[9,1,10,1],[9,8,10,8],[2,7,2,12],[2,1,2,6],[16,9,17,10],[14,9,15,10],[9,7,10,7],[3,11,3,12],[3,9,3,10]]}
[null,"↖ atgal į turinį ",null,null,null,null,null,"↖ back to content"]
[{"$f":"Kalba","v":"LT"}]
[null,"6 lentelė. VS išlaidų augimo ribojimo taisyklė",null,null,null,null,null,"Table 5. GG expenditure growth limiting rule"]
[null,"Nr.","VS išlaidų augimo ribojimo taisyklės netaikymo aplinkybės","Formulė",null,"Išvada",null,"No.","GG expenditure growh limiting rule application escape clause","Formula",null,"Conclusion"]
[null,null,"Institucija, kurios projekcijų pagrindu atliekama analizė",null,null,"FM","IFI",null,"Institution, projections of which are used for the analysis",null,null,"MoF","IFI"]
[null,"A1","Pagal 4 paskutinius metų ketvirčius apskaičiuotas Lietuvos BVP to meto kainomis augimas yra mažesnis negu daugiametis ES BVP to meto kainomis augimas, padidintas 2 procentiniais punktais",null,null,{"$f":"IF(L6,\"Tiesa\",\"Netiesa\")","v":"Netiesa"},{"$f":"IF(M6,\"Tiesa\",\"Netiesa\")","v":"Netiesa"},"E1","Lithuanian GDP at current prices calculated on the basis of 4 last quarters of the year grows at a slower pace than the multi-annual growth of the GDP of the EU at current prices increased by 2 percentage points",null,null,{"$f":"IF('6. GGexpenditure'!L44+eps<AVERAGE('2. Macro'!H33:L33)+2,TRUE,FALSE)","v":false},{"$f":"IF('6. GGexpenditure'!M44+eps<AVERAGE('2. Macro'!I33:M33)+2,TRUE,FALSE)","v":false}]
[null,null,null,null,null,{"$f":"CONCATENATE(TEXT(ROUND('6. GGexpenditure'!L44,1),\"0,0;–0,0\"),IF(L6,\" < \",\" ≥ \"),TEXT(ROUND(AVERAGE('2. Macro'!I33:M33)+2,1),\"0,0;–0,0\"))","v":"7,5 ≥ 4,7"},{"$f":"CONCATENATE(TEXT(ROUND('6. GGexpenditure'!M44,1),\"0,0;–0,0\"),IF(M6,\" < \",\" ≥ \"),TEXT(ROUND(AVERAGE('2. Macro'!I33:M33)+2,1),\"0,0;–0,0\"))","v":"7,7 ≥ 4,7"},null,null,null,null,{"$f":"CONCATENATE(TEXT(ROUND('6. GGexpenditure'!L44,1),\"0.0;–0.0\"),IF(L6,\" < \",\" ≥ \"),TEXT(ROUND(AVERAGE('2. Macro'!I33:M33)+2,1),\"0.0;–0.0\"))","v":"0.8 ≥ 0.5"},{"$f":"CONCATENATE(TEXT(ROUND('6. GGexpenditure'!M44,1),\"0.0;–0.0\"),IF(M6,\" < \",\" ≥ \"),TEXT(ROUND(AVERAGE('2. Macro'!J33:N33)+2,1),\"0.0;–0.0\"))","v":"0.8 ≥ 0.5"}]
[null,"A2","Numatomas VS balanso rodiklio postūmis yra teigiamas ir sudaro bent 1,0 procentinį punktą BVP","B(t) ≥ B(t–1)+1",null,{"$f":"IF(L8,\"Tiesa\",\"Netiesa\")","v":"Netiesa"},{"$f":"IF(M8,\"Tiesa\",\"Netiesa\")","v":"Netiesa"},"E2","Projected GG sector balance indicator adjustment is positive and makes up at least 1.0 percentage point of GDP","B(t) ≥ B(t–1)+1",null,{"$f":"IF('3. GGbudget'!G7>='3. GGbudget'!F7+1,TRUE,FALSE)","v":false},{"$f":"IF('3. GGbudget'!K7>='3. GGbudget'!J7+1,TRUE,FALSE)","v":false}]
[null,null,null,null,null,{"$f":"CONCATENATE(TEXT(ROUND('3. GGbudget'!G7,1),\"0,0;–0,0\"),IF(L8,\" ≥ \",\" < \"),TEXT(ROUND('3. GGbudget'!F7+1,1),\"0,0;–0,0\"))","v":"0,4 < 1,6"},{"$f":"CONCATENATE(TEXT(ROUND('3. GGbudget'!K7,1),\"0,0;–0,0\"),IF(M8,\" ≥ \",\" < \"),TEXT(ROUND('3. GGbudget'!J7+1,1),\"0,0;–0,0\"))","v":"0,1 < 1,4"},null,null,null,null,{"$f":"CONCATENATE(TEXT(ROUND('3. GGbudget'!G7,1),\"0.0;–0.0\"),IF(L8,\" ≥ \",\" < \"),TEXT(ROUND('3. GGbudget'!F7+1,1),\"0.0;–0.0\"))","v":"0.0 < 0.2"},{"$f":"CONCATENATE(TEXT(ROUND('3. GGbudget'!K7,1),\"0.0;–0.0\"),IF(M8,\" ≥ \",\" < \"),TEXT(ROUND('3. GGbudget'!J7+1,1),\"0.0;–0.0\"))","v":"0.0 < 0.1"}]
[null,"A2*","A2, kai numatomas einamųjų metų VS balanso rodiklio teigiamas postūmis nėra mažesnis už suplanuotą einamųjų kalendorinių metų VS balanso rodiklio teigiamą postūmį daugiau kaip 0,5 procentinio punkto BVP to meto kainomis","B(t) ≥ B(t–1)+1  ir\nB(t–1)–B(t–2) ≥ \nBP(t–1)–BP(t–2)+0,5",null,{"$f":"IF(L10,\"Tiesa\",\"Netiesa\")","v":"Netiesa"},{"$f":"IF(M10,\"Tiesa\",\"Netiesa\")","v":"Netiesa"},"E2*","E2, when projected current year GG sector balance indicator positive adjustment is not greater than planned current year GG positive adjustment more than by 0,5 % of GDP at current prices","B(t) ≥ B(t–1)+1  and\nB(t–1)–B(t–2) ≥  \nBP(t–1)–BP(t–2)+0,5",null,{"$f":"IF(('3. GGbudget'!G7>='3. GGbudget'!F7+1)*(L38-L39>=0.5),TRUE,FALSE)","v":false},{"$f":"IF(('3. GGbudget'!K7>='3. GGbudget'!J7+1)*(M38-M39>=0.5),TRUE,FALSE)","v":false}]
[null,null,null,null,null,{"$f":"CONCATENATE(TEXT(ROUND('3. GGbudget'!G7,1),\"0,0;–0,0\"),IF(('3. GGbudget'!G7>='3. GGbudget'!F7+1),\" ≥ \",\" < \"),TEXT(ROUND('3. GGbudget'!F7+1,1),\"0,0;–0,0\"),\" ir\n\",TEXT(ROUND(F38,1),\"0,0;–0,0\"),IF(F38-F39>=0.5,\" ≥ \",\" < \"),TEXT(ROUND(F39+0.5,1),\"0,0;–0,0\"))","v":"0,4 < 1,6 ir\n0,1 < 0,4"},{"$f":"CONCATENATE(TEXT(ROUND('3. GGbudget'!K7,1),\"0,0;–0,0\"),IF(('3. GGbudget'!K7>='3. GGbudget'!J7+1),\" ≥ \",\" < \"),TEXT(ROUND('3. GGbudget'!J7+1,1),\"0,0;–0,0\"),\" ir\n\",TEXT(ROUND(G38,1),\"0,0;–0,0\"),IF(G38-G39>=0.5,\" ≥ \",\" < \"),TEXT(ROUND(G39+0.5,1),\"0,0;–0,0\"))","v":"0,1 < 1,4 ir\n–0,1 < 0,2"},null,null,null,null,{"$f":"CONCATENATE(TEXT(ROUND('3. GGbudget'!G7,1),\"0.0;–0.0\"),IF(('3. GGbudget'!G7>='3. GGbudget'!F7+1),\" ≥ \",\" < \"),TEXT(ROUND('3. GGbudget'!F7+1,1),\"0.0;–0.0\"),\" and\n\",TEXT(ROUND(L38,1),\"0.0;–0.0\"),IF(L38-L39>=0.5,\" ≥ \",\" < \"),TEXT(ROUND(L39+0.5,1),\"0.0;–0.0\"))","v":"0.0 < 0.2 and\n0.0 < 0.0"},{"$f":"CONCATENATE(TEXT(ROUND('3. GGbudget'!K7,1),\"0.0;–0.0\"),IF(('3. GGbudget'!K7>='3. GGbudget'!J7+1),\" ≥ \",\" < \"),TEXT(ROUND('3. GGbudget'!J7+1,1),\"0.0;–0.0\"),\" and\n\",TEXT(ROUND(M38,1),\"0.0;–0.0\"),IF(M38-M39>=0.5,\" ≥ \",\" < \"),TEXT(ROUND(M39+0.5,1),\"0.0;–0.0\"))","v":"0.0 < 0.1 and\n–0.0 < 0.0"}]
[null,"A3","Ne mažiau kaip penkerių iš eilės einančių metų VS balanso rodiklio aritmetinis vidurkis yra perteklius, ne mažesnis negu 0,1 procento BVP",null,null,{"$f":"IF(L12,\"Tiesa\",\"Netiesa\")","v":"Tiesa"},{"$f":"IF(M12,\"Tiesa\",\"Netiesa\")","v":"Tiesa"},"E3","The arithmetic average of GG sector balance indicator of at least five successive years is in surplus, at least 0.1 % of GDP",null,null,{"$f":"IF(ROUND(AVERAGE('2. Macro'!J37:N37),1)>=0.1,TRUE,FALSE)","v":true},{"$f":"IF(ROUND(AVERAGE('2. Macro'!J36:N36),1)>=0.1,TRUE,FALSE)","v":true}]
[null,null,null,null,null,{"$f":"CONCATENATE(TEXT(ROUND(AVERAGE('2. Macro'!J37:N37),1),\"0,0;–0,0\"),IF(L12,\" ≥ \",\" < \"),\"0,1\")","v":"0,1 ≥ 0,1"},{"$f":"CONCATENATE(TEXT(ROUND(AVERAGE('2. Macro'!J36:N36),1),\"0,0;–0,0\"),IF(M12,\" ≥ \",\" < \"),\"0,1\")","v":"0,1 ≥ 0,1"},null,null,null,null,{"$f":"CONCATENATE(TEXT(ROUND(AVERAGE('2. Macro'!J37:N37),1),\"0.0;–0.0\"),IF(L12,\" ≥ \",\" < \"),\"0.1\")","v":"0.0 ≥ 0.1"},{"$f":"CONCATENATE(TEXT(ROUND(AVERAGE('2. Macro'!J36:N36),1),\"0.0;–0.0\"),IF(M12,\" ≥ \",\" < \"),\"0.1\")","v":"0.0 ≥ 0.1"}]
[null,"A4","Keičiant einamųjų metų bet kurio iš VS priskiriamų biudžetų, kurių kiekvieno atskirai planuojami asignavimai viršija 3 procentus BVP to meto kainomis, pajamas ar išlaidas, pakeistas VS balansas nepablogės, palyginti su buvusiu prieš keitimą","B**(t–1) ≥ B(t–1)",null,"Netaikoma",{"$f":"F14","v":"Netaikoma"},"E4","If planned current year GG sector budgets, the planned appropriations of each of which exceed 3 % of GDP at current prices, are subject to amendment,  the adjusted aggregate balances of the GG budgets is not worse than the one before the amendment","B*(t–1) ≥ B(t–1)",null,"Not applied",{"$f":"L14","v":"Not applied"}]
[null,"A5","Pagal Vyriausybės arba jos įgaliotos institucijos viešai paskelbtą ekonominės raidos scenarijų, dėl kurio tvirtinimo kontrolės institucija paskelbė išvadą, apskaičiuotas produkcijos atotrūkis nuo potencialo planuojamais metais yra neigiamas","AP(t) < 0",null,{"$f":"IF(L15,\"Tiesa\",\"Netiesa\")","v":"Netiesa"},{"$f":"IF(M15,\"Tiesa\",\"Netiesa\")","v":"Netiesa"},"E5","The output gap for the planned year calculated on the basis of the economic development scenario, which is made public by the Government or its authorised institution and in regard to which the monitoring authority published its conclusion, is negative","OG(t) < 0",null,{"$f":"IF(L45+eps<0,TRUE,FALSE)","v":false},{"$f":"IF(M45+eps<0,TRUE,FALSE)","v":false}]
[null,null,null,null,null,{"$f":"CONCATENATE(TEXT(ROUND(L45,1),\"0,0;–0,0\"),IF(L15,\" < \",\" ≥ \"),FIXED(0,1))","v":"1,5 ≥ 0,0"},{"$f":"CONCATENATE(TEXT(ROUND(M45,1),\"0,0;–0,0\"),IF(M15,\" < \",\" ≥ \"),FIXED(0,1))","v":"2,3 ≥ 0,0"},null,null,null,null,{"$f":"CONCATENATE(TEXT(ROUND(L45,1),\"0.0;–0.0\"),IF(L15,\" < \",\" ≥ \"),FIXED(0,1))","v":"0.2 ≥ 0,0"},{"$f":"CONCATENATE(TEXT(ROUND(M45,1),\"0.0;–0.0\"),IF(M15,\" < \",\" ≥ \"),FIXED(0,1))","v":"0.2 ≥ 0,0"}]
[null,"A5*","A5, o prognozuojama vidutinė metinė infliacija, apskaičiuojama pagal suderintą vartotojų kainų indeksą, neviršija 3 procentų","AP(t) < 0 ir ΔSVKI(t) ≤ 3",null,{"$f":"IF(L17,\"Tiesa\",\"Netiesa\")","v":"Netiesa"},{"$f":"IF(M17,\"Tiesa\",\"Netiesa\")","v":"Netiesa"},"E5*","E5, and project annual inflation, estimated by harmonised index of consumer prices is not greater that 3 %","OG(t) < 0 and ΔHICP(t) ≤ 3",null,{"$f":"IF((F45+eps<0)*($F$46<=3),TRUE,FALSE)","v":false},{"$f":"IF((G45+eps<0)*($F$46<=3),TRUE,FALSE)","v":false}]
[null,null,null,null,null,{"$f":"CONCATENATE(TEXT(ROUND(L45,1),\"0,0;–0,0\"),IF(L15,\" < \",\" ≥ \"),FIXED(0,1), \" ir\n\", TEXT(ROUND($L$46,1),\"0,0;–0,0\"),IF(L46<=3,\" ≤ \",\" > \"), FIXED(3,1))","v":"1,5 ≥ 0,0 ir\n2,5 ≤ 3,0"},{"$f":"CONCATENATE(TEXT(ROUND(M45,1),\"0,0;–0,0\"),IF(M15,\" < \",\" ≥ \"),FIXED(0,1), \" ir\n\", TEXT(ROUND($L$46,1),\"0,0;–0,0\"),IF(L46<=3,\" ≤ \",\" > \"), FIXED(3,1))","v":"2,3 ≥ 0,0 ir\n2,5 ≤ 3,0"},null,null,null,null,{"$f":"CONCATENATE(TEXT(ROUND(L45,1),\"0.0;–0.0\"),IF($L$15,\" < \",\" ≥ \"),FIXED(0,1), \" and\n\", TEXT(ROUND($L$46,1),\"0.0;–0.0\"),IF(L46<=3,\" ≤ \",\" > \"), FIXED(3,1))","v":"0.2 ≥ 0,0 and\n0.3 ≤ 3,0"},{"$f":"CONCATENATE(TEXT(ROUND(M45,1),\"0.0;–0.0\"),IF($L$15,\" < \",\" ≥ \"),FIXED(0,1), \" and\n\", TEXT(ROUND($L$46,1),\"0.0;–0.0\"),IF(L46<=3,\" ≤ \",\" > \"), FIXED(3,1))","v":"0.2 ≥ 0,0 and\n0.3 ≤ 3,0"}]
[null,"A","t metais, VS išlaidų augimo ribojimo taisyklė netaikoma, kai susidaro bent viena iš A1–A5 aplinkybių",null,null,{"$f":"IF(L19=\"yes\",\"Taip\",\"Ne\")","v":"Taip"},{"$f":"IF(M19=\"yes\",\"Taip\",\"Ne\")","v":"Taip"},"E","at year t the GG expenditure growth limiting rule is not applied when at least one of the  E1–E5 escape clauses emerges",null,null,{"$f":"+IF((OR(L6=TRUE,L8=TRUE,L12=TRUE,L14=TRUE,L15=TRUE)),\"Yes\",\"No\")","v":"Yes"},{"$f":"+IF((OR(M6=TRUE,M8=TRUE,M12=TRUE,M14=TRUE,M15=TRUE)),\"Yes\",\"No\")","v":"Yes"}]
[null,null,null,null,null,{"$f":"IF(F19=\"TAIP\",IF(F60=1,CONCATENATE(\"Susidaro \",H55,H56,H57,H58,H59,\" aplinkybė\"),CONCATENATE(\"Susidaro \", IF(F55=1,CONCATENATE(H55,\" \"),\"\"),IF(F56=1,CONCATENATE(H56,\" \"),\"\"),IF(F57=1,CONCATENATE(H57,\" \"),\"\"),IF(F58=1,CONCATENATE(H58,\" \"),\"\"),IF(F59=1,CONCATENATE(H59,\" \"),\"\"),\"aplinkybės\")),\"Išimčių nėra\")","v":"Susidaro aplinkybės"},{"$f":"IF(G19=\"TAIP\",IF(G60=1,CONCATENATE(\"Susidaro \",I55,I56,I57,I58,I59,\" aplinkybė\"),CONCATENATE(\"Susidaro \", IF(G55=1,CONCATENATE(I55,\" \"),\"\"),IF(G56=1,CONCATENATE(I56,\" \"),\"\"),IF(G57=1,CONCATENATE(I57,\" \"),\"\"),IF(G58=1,CONCATENATE(I58,\" \"),\"\"),IF(G59=1,CONCATENATE(I59,\" \"),\"\"),\"aplinkybės\")),\"Išimčių nėra\")","v":"Susidaro aplinkybės"},null,null,null,null,{"$f":"IF(L19=\"YES\",IF(F60=1,CONCATENATE(\"Escape clause \",J55,J56,J57,J58,J59,\" emerges\"),CONCATENATE(\"Escape clauses \", IF(F55=1,CONCATENATE(J55,\" \"),\"\"),IF(F56=1,CONCATENATE(J56,\" \"),\"\"),IF(F57=1,CONCATENATE(J57,\" \"),\"\"),IF(F58=1,CONCATENATE(J58,\" \"),\"\"),IF(F59=1,CONCATENATE(J59,\" \"),\"\"),\"emerge\") ),\"There is no escape clauses\")","v":"Escape clauses emerge"},{"$f":"IF(M19=\"YES\",IF(G60=1,CONCATENATE(\"Escape clause \",K55,K56,K57,K58,K59,\" emerges\"),CONCATENATE(\"Escape clauses \", IF(G55=1,CONCATENATE(K55,\" \"),\"\"),IF(G56=1,CONCATENATE(K56,\" \"),\"\"),IF(G57=1,CONCATENATE(K57,\" \"),\"\"),IF(G58=1,CONCATENATE(K58,\" \"),\"\"),IF(G59=1,CONCATENATE(K59,\" \"),\"\"),\"emerge\") ),\"There is no escape clauses\")","v":"Escape clauses emerge"}]
[null,"Nr.","Taisyklė","Formulė",null,"Išvada",null,"No.","Rule","Formula",null,"Conclusion"]
[null,"T1","Metais t rengiant, tvirtinant ir keičiant VS priskiriamų biudžetų, kurių kiekvieno atskirai planuojami asignavimai viršija 3 proc. BVP to meto kainomis (CV, VSDF ir PSDF išlaidos), patvirtinimo įstatymų arba šių įstatymų pakeitimo įstatymų projektus, vadovaujamasi nuostata, kad tuo atveju, kai paskutinių penkerių pasibaigusių metų VS balanso rodiklių aritmetinis vidurkis yra neigiamas, šių biudžetų asignavimų (išskyrus ES finansinės paramos lėšas) visumos augimas turi būti ne didesnis negu 0,5 potencialaus BVP to meto kainomis daugiamečio augimo vidurkio","Jei ",null,{"$f":"IF((L19=\"YES\"),\"\",IF(L22,\"TIESA\",\"NETIESA\"))","v":""},{"$f":"IF((M19=\"YES\"),\"\",IF(M22,\"TIESA\",\"NETIESA\"))","v":""},"R1","At year t the preparation, approval and amendment of draft laws or their draft amending laws on approval of the budgets attributable to the GG sector the planned appropriations of each of which exceed 3 % of GDP (CG and SSF expenditure) at current prices shall rely on the provision that, in case where arithmetic average of GG sector balance indicators of the past five complete years is negative, the aggregate growth of the appropriations of these budgets (net of EU financial support) is not higher than 0.5 % of the average multi-annual growth rate of the potential GDP at current prices","If",null,{"$f":"IF((L19=\"YES\"),\"\",IF(AVERAGE('2. Macro'!I37:M37)+eps<0,TRUE,FALSE))","v":""},{"$f":"IF((M19=\"YES\"),\"\",IF(AVERAGE('2. Macro'!I36:M36)+eps<0,TRUE,FALSE))","v":""}]
[null,null,null,null,null,{"$f":"IF((L19=\"YES\"),\"\",CONCATENATE(TEXT(ROUND(AVERAGE('2. Macro'!I37:M37),1),\"0,0;–0,0\"),IF(L12,\" ≥ \",\" < \"),FIXED(0,1)))","v":""},{"$f":"IF((M19=\"YES\"),\"\",CONCATENATE(TEXT(ROUND(AVERAGE('2. Macro'!J37:N37),1),\"0,0;–0,0\"),IF(M12,\" ≥ \",\" < \"),FIXED(0,1)))","v":""},null,null,null,null,{"$f":"IF((L19=\"YES\"),\"\",CONCATENATE(TEXT(ROUND(AVERAGE('2. Macro'!I37:M37),1),\"0.0;–0.0\"),IF(L12,\" ≥ \",\" < \"),FIXED(0,1)))","v":""},{"$f":"IF((M19=\"YES\"),\"\",CONCATENATE(TEXT(ROUND(AVERAGE('2. Macro'!I36:M36),1),\"0.0;–0.0\"),IF(M12,\" ≥ \",\" < \"),FIXED(0,1)))","v":""}]
[null,null,null,null,null,{"$f":"L24","v":""},{"$f":"M24","v":""},null,null,null,null,{"$f":"IF(L19=\"YES\",\"\",POWER('2. Macro'!Q16/'2. Macro'!G16,0.1)*POWER(PRODUCT(F40:F43),0.25)-1)","v":""},{"$f":"IF(M19=\"YES\",\"\",POWER('2. Macro'!Q15/'2. Macro'!G15,0.1)*POWER(PRODUCT(F40:F43),0.25)-1)","v":""}]
[null,null,null,null,null,{"$f":"IF(F19=\"TAIP\",\"Netaikoma,\",IF(L25,\"Tiesa\",\"Netiesa\"))","v":"Netaikoma,"},{"$f":"IF(G19=\"TAIP\",\"Netaikoma,\",IF(M25,\"Tiesa\",\"Netiesa\"))","v":"Netaikoma,"},null,null,null,null,{"$f":"IF(L19=\"YES\",\"Not applied,\",IF($F$32-$F$34<=($F$33-$F$35)*(1+0.5*L24),TRUE,FALSE))","v":"Not applied,"},{"$f":"IF(M19=\"YES\",\"Not applied,\",IF($G$32-$F$34<=($G$33-$F$35)*(1+0.5*M24),TRUE,FALSE))","v":"Not applied,"}]
[null,null,null,null,null,{"$f":"IF(L19=\"YES\",\" nes susidarė viena iš KĮ numatytų netaikymo aplinkybių\",CONCATENATE(ROUND(($F$32-F34)/($F$33-F35),3),IF(L25,\" ≤ \",\" > \"), ROUND(1+0.5*L24,3)))","v":" nes susidarė viena iš KĮ numatytų netaikymo aplinkybių"},{"$f":"IF(M19=\"YES\",\" nes susidarė viena iš KĮ numatytų netaikymo aplinkybių\",CONCATENATE(ROUND(($G$32-F34)/($G$33-F35),3),IF(M25,\" ≤ \",\" > \"), ROUND(1+0.5*M24,3)))","v":" nes susidarė viena iš KĮ numatytų netaikymo aplinkybių"},null,null,null,null,{"$f":"IF(L19=\"YES\",\" since one of CL escape clauses emerged\",CONCATENATE(ROUND(($F$32-F34)/($F$33-F35),3),IF(L25,\" ≤ \",\" > \"), ROUND(1+0.5*L24,3)))","v":" since one of CL escape clauses emerged"},{"$f":"IF(M19=\"YES\",\" since one of CL escape clauses emerged\",CONCATENATE(ROUND(($G$32-F34)/($G$33-F35),3),IF(M25,\" ≤ \",\" > \"), ROUND(1+0.5*M24,3)))","v":" since one of CL escape clauses emerged"}]
[null,"T2","Pagal FDĮ panaši į T1 išlaidų ribojimo taisyklė turi būti pritaikyta visam konsoliduotam VS biudžetui (be Europos Sąjungos finansinės paramos lėšų)",null,null,{"$f":"IF(F19=\"TAIP\",\"Netaikoma,\",IF(L27,\"Tiesa\",\"Netiesa\"))","v":"Netaikoma,"},{"$f":"IF(G19=\"TAIP\",\"Netaikoma,\",IF(M27,\"Tiesa\",\"Netiesa\"))","v":"Netaikoma,"},"R2","According to FDL a similar to R1 GG consolidated budget's expenditure growth rule is applied (net of EU financial support) ",null,null,{"$f":"IF(L19=\"YES\",\"Not applied,\",IF($F$36-$F$34<=($F$37-$F$35)*(1+0.5*L24),TRUE,FALSE))","v":"Not applied,"},{"$f":"IF(M19=\"YES\",\"Not applied,\",IF($F$36-$F$34<=($F$37-$F$35)*(1+0.5*M24),TRUE,FALSE))","v":"Not applied,"}]
[null,null,null,null,null,{"$f":"IF(L19=\"YES\",\" nes susidarė viena iš FDĮ numatytų netaikymo aplinkybių\",CONCATENATE(ROUND(($F$36-$F$34)/($F$37-$F$35),3),IF(L25,\" ≤ \",\" > \"), ROUND(1+0.5*L24,3)))","v":" nes susidarė viena iš FDĮ numatytų netaikymo aplinkybių"},{"$f":"IF(M19=\"YES\",\" nes susidarė viena iš FDĮ numatytų netaikymo aplinkybių\",CONCATENATE(ROUND(($G$36-$F$34)/($G$37-$F$35),3),IF(M25,\" ≤ \",\" > \"), ROUND(1+0.5*M24,3)))","v":" nes susidarė viena iš FDĮ numatytų netaikymo aplinkybių"},null,null,null,null,{"$f":"IF(L19=\"YES\",\" since one of FDL escape clauses emerged\",CONCATENATE(ROUND(($F$36-$F$34)/($F$37-$F$35),3),IF(L25,\" ≤ \",\" > \"), ROUND(1+0.5*L24,3)))","v":" since one of FDL escape clauses emerged"},{"$f":"IF(M19=\"YES\",\" since one of FDL escape clauses emerged\",CONCATENATE(ROUND(($G$36-$F$34)/($G$37-$F$35),3),IF(M25,\" ≤ \",\" > \"), ROUND(1+0.5*M24,3)))","v":" since one of FDL escape clauses emerged"}]
[null,null,"* nelygybės ženklas yra griežtas, jei skirtumas tarp lyginamų pusių po apvalinimo sudaro bent 0,1, \nkitaip ženklas interpretuojamas kaip =\n** einamaisiais metais keičiamas VS balansas",null,null,null,null,null,"* inequality sign is strict, if a difference between both compared sides after rounding is at least 0,1, \n else the sign is interpreted as =\n** the adjusted aggregate balances of the GG budgets"]
[null,null,"Šaltiniai: KĮ 3 straipsnis 3 dalis, taisyklės pažymėtos * FDĮ 2-3 straipsniai",null,null,null,null,null,"Source: CL Article 3(3), rules denoted by * FDL Articles 2 and 3"]
[null,null,null,null,"t =",{"$f":"FirstYear+8","v":2019},null,null,null,null,"t =",{"$f":"F31","v":2019}]
[null,null,null,null,"AV3(t) =",{"$f":"'3. GGbudget'!I14","v":15070.2},{"$f":"'3. GGbudget'!M14","v":15180.541000000001},null,null,null,"AG3(t) =",15070.2,{"$f":"G32","v":15180.541000000001}]
[null,null,null,null,"AV3(t–1) =",{"$f":"'3. GGbudget'!H14","v":13947.5},{"$f":"'3. GGbudget'!L14","v":14098.704043270653},null,null,null,"AG3(t–1) =",13947.5,{"$f":"G33","v":14098.704043270653}]
[null,null,null,null,"ES(t) =",2242.6999999999998,null,null,null,null,"EU(t) =",2242.6999999999998]
[null,null,null,null,"ES(t–1) =",2101.1999999999998,null,null,null,null,"EU(t–1) =",2101.1999999999998]
[null,null,null,null,"VI(t) =",{"$f":"'3. GGbudget'!I11","v":17034.605567113726},{"$f":"'3. GGbudget'!M11","v":17087.086191208691},null,null,null,"TE(t) =",17034.605567113726,{"$f":"G36","v":17087.086191208691}]
[null,null,null,null,"VI(t–1) =",{"$f":"'3. GGbudget'!H11","v":15783.577879469973},{"$f":"'3. GGbudget'!L11","v":15995.91913950404},null,null,null,"TE(t–1) =",15783.577879469973,{"$f":"G37","v":15995.91913950404}]
[null,null,null,null,"B(t–1)–B(t–2) =",{"$f":"+'2. Macro'!N37-'2. Macro'!M37","v":0.10738238733841043},{"$f":"+'2. Macro'!N36-'2. Macro'!M36","v":-0.10708876882691476},null,null,null,"B(t–1)–B(t–2) =",0.10738238733841043,{"$f":"G38","v":-0.10708876882691476}]
[null,null,null,null,"BP(t–1)–BP(t–2) =",{"$f":"+('2. Macro'!N37-'2. Macro'!M37)-('2. Macro'!M37-'2. Macro'!L37)","v":-0.12076375994616262},{"$f":"+('2. Macro'!N36-'2. Macro'!M36)-('2. Macro'!M36-'2. Macro'!L36)","v":-0.33249624061565547},null,null,null,"BP(t–1)–BP(t–2) =",-0.12076375994616262,{"$f":"G39","v":-0.33249624061565547}]
[null,null,"2018 m. pavasario ERS",null,"PY1(t)/PY1(t–1) =",1.02002721885962,null,null,"Spring 2018 EDS",null,"PY1(t)/PY1(t–1) =",1.02002721885962]
[null,null,"2018 m. rudens ERS",null,"PY2(t)/PY2(t–1) =",1.0264981527722901,null,null,"Autumn 2018 EDS",null,"PY2(t)/PY2(t–1) =",1.0264981527722901]
[null,null,"2017 m. rudens EK projekcijos",null,"PY3(t)/PY3(t–1) =",1.03,null,null,"Autumn 2017 E7 projections",null,"PY3(t)/PY3(t–1) =",1.03]
[null,null,"2018 m. pavasario EK projekcijos",null,"PY4(t)/PY4(t–1) =",1.0229999999999999,null,null,"Spring 2018 EC projections",null,"PY4(t)/PY4(t–1) =",1.0229999999999999]
[null,null,"2017K3-2018K2",null,"ΔYN(t–1) =",7.541381712247313,7.6715384547734855,null,{"$f":"+C44","v":"2017K3-2018K2"},null,"ΔYN(t–1) =",{"$f":"F44","v":7.541381712247313},{"$f":"G44","v":7.6715384547734855}]
[null,null,null,null,"AP(t)  =",{"$f":"'2. Macro'!O20","v":1.4804051828047005},{"$f":"'2. Macro'!O19","v":2.2875141207293392},null,null,null,"OG(t) =",1.4804051828047005,{"$f":"G45","v":2.2875141207293392}]
[null,null,null,null,"ΔSVKI(t) =",{"$f":"'2. Macro'!O31","v":2.5},null,null,null,null," ΔHICP(t) =",2.5]
[null,null,null,null,"AV3(t)–ES(t)=",{"$f":"+F32-F34","v":12827.5},{"$f":"+G32-F34","v":12937.841},null,null,null,"AG3(t)–EU(t)=",{"$f":"+F47","v":12827.5},12937.841]
[null,null,null,null,"AV3(t–1)–ES(t–1)=",{"$f":"+F33-F35","v":11846.3},{"$f":"+G33-F35","v":11997.504043270652},null,null,null,"AG3(t–1)–EU(t–1)=",11846.3,11997.504043270652]
[null,null,null,null,"(AV3(t)-ES(t))/(AV3(t-1)-ES(t-1))=",{"$f":"+(F47/F48-1)*100","v":8.2827549530233071},{"$f":"+(G47/G48-1)*100","v":7.8377715342949239},null,null,null,"(AG3(t)-EU(t))/(AG3(t-1)-EU(t-1))=",8.2827549530233071,7.8377715342949239]
[null,null,null,null,"Ynp10t",{"$f":"(POWER('2. Macro'!Q16/'2. Macro'!G16,0.1)*POWER(PRODUCT(F40:F43),0.25)-1)*100","v":5.0715220872281863},{"$f":"(POWER('2. Macro'!Q15/'2. Macro'!G15,0.1)*POWER(PRODUCT(F40:F43),0.25)-1)*100","v":4.9579122971050271},null,null,null,"Ynp10t",{"$f":"+F50","v":5.0715220872281863},{"$f":"+G50","v":4.9579122971050271}]
[null,null,null,null,"Šaltiniai:",null,null,null,null,null,"Sources:"]
[null,null,null,null,"Finansų ministerija","FM",null,null,null,null,"Ministry of Finance","MoF"]
[null,null,null,null,"Fiskalinė institucija","IFI",null,null,null,null,"Independent Fiscal Institution","IFI"]
[null,null,null,null,"Europos Komisija","EK",null,null,null,null,"European Commission","EC"]
[null,null,null,"A1","E1",{"$f":"(L6)*1","v":0},{"$f":"(M6)*1","v":0},{"$f":"IF(F55=1,$D55,\"\")","v":""},"",{"$f":"IF(F55=1,$E55,\"\")","v":""},""]
[null,null,null,"A2","E2",{"$f":"(L8)*1","v":0},{"$f":"(M8)*1","v":0},"","","",""]
[null,null,null,"A3","E3",null,null,null,"","",""]
[null,null,null,"A4","E4",null,null,null,"","",""]
[null,null,null,"A5","E5",null,null,null,"","",""]

{"sheet":"7. GGbudgets","index":8,"n_rows":30,"n_cols":11,"rows_kept":30,"cut":false,"hidden":false,"merged":[[17,1,20,1],[17,6,20,6],[5,9,5,10],[12,3,13,3],[14,3,15,3],[18,5,19,5],[18,9,19,9],[18,10,19,10],[16,2,16,3],[14,8,15,8],[12,8,13,8],[5,4,5,5],[11,4,11,5],[5,7,6,7],[11,7,15,7],[11,6,16,6],[0,1,0,2],[11,1,16,1],[5,1,6,1],[3,6,4,6],[5,2,6,2],[11,2,15,2],[2,6,2,10],[2,1,2,5],[3,1,4,1],[0,6,0,7],[4,2,4,3],[4,7,4,8],[3,4,3,5],[3,9,3,10],[5,6,6,6],[11,9,11,10],[29,4,29,5],[28,9,28,10],[29,9,29,10],[20,7,20,8],[16,7,16,8],[28,4,28,5],[22,9,22,10],[22,4,22,5],[20,2,20,3],[10,2,10,3],[17,2,19,2],[17,4,17,5],[17,9,17,10],[17,7,19,7],[18,4,19,4],[7,1,10,1],[7,6,10,6],[7,7,9,7],[7,4,7,5],[7,9,7,10],[7,2,9,2],[8,3,9,3],[8,8,9,8]]}
[null,"↖ atgal į turinį ",null,null,null,null,"↖ back to content"]
[{"$f":"Kalba","v":"LT"}]
[null,"7 lentelė. VS priskiriamų biudžetų taisyklės",null,null,null,null,"Table 7. Rules for the budgets attributable to GG sector"]
[null,"Nr.","Taisyklė","Formulė","Išvada",null,"No.","Rule","Formula","Conclusion"]
[null,null,"Institucija, kurios projekcijų pagrindu atliekama analizė",null,"FM","IFI",null,"Institution, projections of which are used for the analysis",null,"MoF","IFI"]
[null,"T31","Nuo 2018 m. sausio 1 d. kiekvienas j-asis vietos valdžios sektoriui priskiriamas biudžetas, kurio asignavimai viršija 0,3 procentą praėjusių metų BVP to meto kainomis, turi būti planuojamas, tvirtinamas, keičiamas ir vykdomas taip, kad, sprendžiant pagal to biudžeto struktūrinį balanso rodiklį, apskaičiuotą kaupiamuoju principu, jis būtų perteklinis arba subalansuotas","t > 2018",{"$f":"IF(J6,\"Tiesa\",\"Netiesa\")","v":"Netiesa"},null,"R31","From 1 January 2018 each j-th budget attributable to local government sector, planned appropriations of which exceeds 0.3 % of GDP in the preceding year at current prices, and NHIF budget must be planned, approved, amended and implemented to be in surplus or balanced when judged by its structural balance indicator calculated on accrual basis","t > 2018",{"$f":"IF((J23-1)>2018,TRUE,FALSE)","v":false}]
[null,null,null,"SBj(t) ≥ 0, ꓯj",{"$f":"IF(J6=TRUE,IF('4. Municipalities'!Q65=0,\"Visos vietos valdžios tinkamai suplanavo biudžetus\",CONCATENATE(\"Vietos valdžia: \",'4. Municipalities'!Q67, \"- nesilaiko fiskalinės taisyklės\")),\"Šiuo metu negalima patikrinti, nes nėra duomenų apie savivaldybių, kurių asignavimai viršija 0,3 proc. BVP, planuojamus struktūrinius balanso rodiklius\")","v":"Šiuo metu negalima patikrinti, nes nėra duomenų apie savivaldybių, kurių asignavimai viršija 0,3 proc. BVP, planuojamus struktūrinius balanso rodiklius"},{"$f":"IF(J6=TRUE,IF('4. Municipalities'!R65=0,\"Visos vietos valdžios tinkamai suplanavo biudžetus\",CONCATENATE(\"Vietos valdžia:\",'4. Municipalities'!R67, \"- nesilaiko fiskalinės taisyklės\")),\"Šiuo metu negalima patikrinti, nes nėra duomenų apie savivaldybių, kurių asignavimai viršija 0,3 proc. BVP, planuojamus struktūrinius balanso rodiklius\")","v":"Šiuo metu negalima patikrinti, nes nėra duomenų apie savivaldybių, kurių asignavimai viršija 0,3 proc. BVP, planuojamus struktūrinius balanso rodiklius"},null,null,"SBj(t) ≥ 0, ꓯj",{"$f":"IF(J6=TRUE,IF('4. Municipalities'!Q65=0,\"All local governments appropriately planned budgets\",CONCATENATE(\"Local governments: \",'4. Municipalities'!Q67, \", do not follow fiscal rule\")),\"Currently not verified, since no data on local governments appropr. of which exceed 0.3% of GDP, planned appropr. and revenues\")","v":"Currently not verified, since no data on local governments appropr. of which exceed 0.3% of GDP, planned appropr. and revenues"},{"$f":"IF(J6=TRUE,IF('4. Municipalities'!R65=0,\"All local governments appropriately planned budgets\",CONCATENATE(\"Local governments: \",'4. Municipalities'!R67, \"- do not follow fiscal rule\")),\"Currently not verified, since no data on local governments appropr. of which exceed 0.3% of GDP, planned appropr. and revenues\")","v":"Currently not verified, since no data on local governments appropr. of which exceed 0.3% of GDP, planned appropr. and revenues"}]
[null,"T32","Nuo 2019 m. sausio 1 d. PSDF biudžetas turi būti planuojamas, tvirtinamas, keičiamas ir vykdomas taip, kad, sprendžiant pagal to biudžeto struktūrinį balanso rodiklį, apskaičiuotą kaupiamuoju principu, jis būtų perteklinis arba subalansuotas","t > 2018",{"$f":"IF(J8,\"Tiesa\",\"Netiesa\")","v":"Tiesa"},null,"R32","From 1 January 2019 NHIF budget must be planned, approved, amended and implemented to be in surplus or balanced when judged by its structural balance indicator calculated on accrual basis","t > 2018",{"$f":"IF(E23>2018,TRUE,FALSE)","v":true}]
[null,null,null,"SBPSDF(t) ≥ 0",{"$f":"IF(J9,\"Tiesa\",\"Netiesa\")","v":"Tiesa"},{"$f":"IF(J9,\"Tiesa\",\"Netiesa\")","v":"Tiesa"},null,null,"SBNHIF ≥ 0",{"$f":"IF(J27>=0,TRUE,FALSE)","v":true},{"$f":"IF(K27>=0,TRUE,FALSE)","v":true}]
[null,null,null,null,{"$f":"CONCATENATE(TEXT(ROUND(J27,1),\"0,0;–0,0\"),IF(J27>= 0,\" ≥ \",\" < \"),FIXED(0,1))","v":"0,1 ≥ 0,0"},{"$f":"CONCATENATE(TEXT(ROUND(K27,1),\"0,0;–0,0\"),IF(K27>=0,\" ≥ \",\" < \"),FIXED(0,1))","v":"0,1 ≥ 0,0"},null,null,null,{"$f":"CONCATENATE(TEXT(ROUND(J27,1),\"0.0;–0.0\"),IF(J27>=0,\" ≥ \",\" < \"),FIXED(0,1))","v":"0.0 ≥ 0,0"},{"$f":"CONCATENATE(TEXT(ROUND(K27,1),\"0.0;–0.0\"),IF(K27>=0,\"≥ \",\" <\"),FIXED(0,1))","v":"0.0≥ 0,0"}]
[null,null,"Taisyklė planuojamam PSDF struktūriniam biudžetui",null,{"$f":"IF(J9,\"Galioja\",\"Negalioja\")","v":"Galioja"},{"$f":"IF(K9,\"Galioja\",\"Negalioja\")","v":"Galioja"},null,null,null,{"$f":"IF(OR(J9:J10),\"Valid\",\"Invalid\")","v":"Valid"},{"$f":"IF(OR(K9:K10),\"Valid\",\"Invalid\")","v":"Valid"}]
[null,"T4","Nuo 2016 m. sausio 1 d. Lietuvos Respublikos atitinkamų metų VSDF biudžetas planuojamas, tvirtinamas, keičiamas ir vykdomas taip, kad jo struktūrinis deficitas, apskaičiuotas kaupiamuoju principu, galėtų didėti t metais, kuriems pagal Vyriausybės arba jos įgaliotos institucijos viešai paskelbtą ekonominės raidos scenarijų, dėl kurio tvirtinimo kontrolės institucija paskelbė savo išvadą, numatomas neigiamas produkcijos atotrūkis nuo potencialo","t > 2016",{"$f":"IF(J12,\"Tiesa\",\"Netiesa\")","v":"Tiesa"},null,"R3","From 1 January 2016 budget of the SSIF of the Republic of Lithuania for a year t shall be planned, approved, amended and implemented in such a way that its structural deficit calculated on accrual basis could increase only in the year when a negative output gap is projected according to the economic development scenario which is made public by the Government of the Republic of Lithuania or its authorised institutions and in regard of which the monitoring authority published its conclusion","t > 2016",{"$f":"IF(E23>2016,TRUE,FALSE)","v":true}]
[null,null,null,"AP(t) < 0",{"$f":"IF(J13,\"Tiesa\",\"Netiesa\")","v":"Netiesa"},{"$f":"IF(K13,\"Tiesa\",\"Netiesa\")","v":"Netiesa"},null,null,"OG(t) < 0 ",{"$f":"IF(J24+eps<0,TRUE,FALSE)","v":false},{"$f":"IF(K24+eps<0,TRUE,FALSE)","v":false}]
[null,null,null,null,{"$f":"CONCATENATE(TEXT(ROUND(J24,1),\"0,0;–0,0\"),IF(J24<0,\" < \",\" ≥ \"),FIXED(0,1))","v":"1,5 ≥ 0,0"},{"$f":"CONCATENATE(TEXT(ROUND(K24,1),\"0,0;–0,0\"),IF(K24<0,\" < \",\" ≥ \"),FIXED(0,1))","v":"2,3 ≥ 0,0"},null,null,null,{"$f":"CONCATENATE(TEXT(ROUND(J24,1),\"0.0;–0.0\"),IF(J24<0,\" < \",\" ≥ \"),FIXED(0,1))","v":"0.2 ≥ 0,0"},{"$f":"CONCATENATE(TEXT(ROUND(K24,1),\"0.0;–0.0\"),IF(K24<0,\" < \",\" ≥ \"),FIXED(0,1))","v":"0.2 ≥ 0,0"}]
[null,null,null,"AP(t) ≥ 0 ir\nSBVSDF(t) ≥ SBVSDF(t–1)",{"$f":"IF(J15,\"Tiesa\",\"Netiesa\")","v":"Tiesa"},{"$f":"IF(K15,\"Tiesa\",\"Netiesa\")","v":"Tiesa"},null,null,"OG(t) ≥ 0 and\nSBSSIF(t) ≥ SBSSIF(t–1)",{"$f":"IF((J24>=0)*(J25>=J26),TRUE,FALSE)","v":true},{"$f":"IF((K24>=0)*(K25+eps>=K26),TRUE,FALSE)","v":true}]
[null,null,null,null,{"$f":"CONCATENATE(TEXT(ROUND(E24,1),\"0,0;–0,0\"),IF(J15,\" ≥ \",\" < \"),FIXED(0,1), \" ir\n\", TEXT(ROUND(E25,1),\"0,0;–0,0\"),IF(E25>=E26,\" ≥ \",\" < \"), TEXT(ROUND(E26,1),\"0,0;–0,0\"))","v":"1,5 ≥ 0,0 ir\n0,7 ≥ 0,3"},{"$f":"CONCATENATE(TEXT(ROUND(F24,1),\"0,0;–0,0\"),IF(K15,\" ≥ \",\" < \"),FIXED(0,1), \" ir\n\", TEXT(ROUND(F25,1),\"0,0;–0,0\"),IF(F25+eps>=F26,\" ≥ \",\" < \"), TEXT(ROUND(F26,1),\"0,0;–0,0\"))","v":"2,3 ≥ 0,0 ir\n0,5 ≥ 0,2"},null,null,null,{"$f":"CONCATENATE(TEXT(ROUND(J24,1),\"0.0;–0.0\"),IF(J15,\" ≥ \",\" < \"),FIXED(0,1), \" and\n\", TEXT(ROUND(J25,1),\"0.0;–0.0\"),IF(J25>=J26,\" ≥ \",\" < \"), TEXT(ROUND(J26,1),\"0.0;–0.0\"))","v":"0.2 ≥ 0,0 and\n0.1 ≥ 0.0"},{"$f":"CONCATENATE(TEXT(ROUND(K24,1),\"0.0;–0.0\"),IF(K15,\" ≥ \",\" < \"),FIXED(0,1), \" and\n\", TEXT(ROUND(K25,1),\"0.0;–0.0\"),IF(K25+eps>=K26,\" ≥ \",\" < \"), TEXT(ROUND(K26,1),\"0.0;–0.0\"))","v":"0.2 ≥ 0,0 and\n0.1 ≥ 0.0"}]
[null,null,"Taisyklė planuojamam VSDF struktūriniam biudžetui",null,{"$f":"IF(OR(J13,J15),\"Galioja\",\"Negalioja\")","v":"Galioja"},{"$f":"IF(OR(K13,K15),\"Galioja\",\"Negalioja\")","v":"Galioja"},null,"Rule for SSIF structural budget",null,{"$f":"IF(OR(J13:J15),\"Valid\",\"Invalid\")","v":"Valid"},{"$f":"IF(OR(K13:K15),\"Valid\",\"Invalid\")","v":"Valid"}]
[null,"T5","Nuo 2016 m. sausio 1 d.  kiekvienas j-asis vietos valdžios sektoriui priskiriamas biudžetas, kurio asignavimai neviršija 0,3 procento praėjusių metų BVP to meto kainomis, turi būti planuojamas, tvirtinamas, keičiamas ir vykdomas taip, kad to biudžeto asignavimai neviršytų jo pajamų, išskyrus metus, kuriais pagal Vyriausybės arba jos įgaliotos institucijos viešai paskelbtą ekonominės raidos scenarijų, dėl kurio tvirtinimo kontrolės institucija paskelbė savo išvadą, numatomas neigiamas produkcijos atotrūkis nuo potencialo. Pastaruoju atveju asignavimai negali viršyti pajamų daugiau kaip 1,5 procento","t > 2016",{"$f":"IF(J18,\"Tiesa\",\"Netiesa\")","v":"Tiesa"},null,"R4","From 1 January 2016 each j-th budget attributable to local government sector, planned appropriations of which does not exceed 0.3 % of GDP in the preceding year at current prices, shall be planned, approved, amended and implemented in such a way that the appropriations of the budget would not exceed its revenue, with the exception of the year when a negative output gap is projected according to the economic development scenario which is made public by the Government or its authorised institution and in regard to which the monitoring authority published its conclusion. In the latter case, the appropriations may not exceed revenue by more than 1.5 %","t>2016",{"$f":"IF(E23>2016,TRUE,FALSE)","v":true}]
[null,null,null,"AP(t) ≥ 0 ir \nVIj(t)/VPj(t) ≤ 1",{"$f":"IF(J18=TRUE,IF('4. Municipalities'!Q66=0,\"Visos vietos valdžios tinkamai suplanavo biudžetus\",CONCATENATE(\"Vietos valdžia: \",'4. Municipalities'!Q68, \", nesilaiko fiskalinės taisyklės\")),\"Dar nėra tikrinama\")","v":"Visos vietos valdžios tinkamai suplanavo biudžetus"},{"$f":"IF(J18=TRUE,IF('4. Municipalities'!R66=0,\"Visos vietos valdžios tinkamai suplanavo biudžetus\",CONCATENATE(\"Vietos valdžia: \",'4. Municipalities'!R68, \"- nesilaiko fiskalinės taisyklės\")),\"Dar nėra tikrinama\")","v":"Visos vietos valdžios tinkamai suplanavo biudžetus"},null,null,"OG(t) ≥ 0 and\nTEj(t)/TRj(t) ≤ 1",{"$f":"IF(J18=TRUE,IF('4. Municipalities'!Q66=0,\"All local governments appropriately planned budgets\",CONCATENATE(\"Local governments: \",'4. Municipalities'!Q68, \", do not follow fiscal rule\")),\"Not applicable yet\")","v":"All local governments appropriately planned budgets"},{"$f":"IF(J18=TRUE,IF('4. Municipalities'!R66=0,\"All local governments appropriately planned budgets\",CONCATENATE(\"Local governments: \",'4. Municipalities'!R68, \"- do not follow fiscal rule\")),\"Not applicable yet\")","v":"All local governments appropriately planned budgets"}]
[null,null,null,"AP(t) < 0 ir \nVIj(t)/VPj(t) ≤ 1,015",null,null,null,null,"OG(t) < 0 and \nTEj(t)/TRj(t) ≤ 1,015"]
[null,null,"Taisyklė planuojamiems vietos valdžios sektoriaus (j) asignavimams, kurie neviršija 0,3 proc. BVP",null,{"$f":"IF('4. Municipalities'!Q66=0,\"Galioja\",\"Negalioja\")","v":"Galioja"},{"$f":"IF('4. Municipalities'!R66=0,\"Galioja\",\"Negalioja\")","v":"Galioja"},null,"Rule for planned local governments (j) appropriations of which does not exceed 0.3 % of GDP",null,{"$f":"IF('4. Municipalities'!Q66=0,\"Valid\",\"Invalid\")","v":"Valid"},{"$f":"IF('4. Municipalities'!R66=0,\"Valid\",\"Invalid\")","v":"Valid"}]
[null,null,"Šaltinis: KĮ 4 straipsnis",null,null,null,null,"Source: CL Article 4"]
[null,null,null,"t =",{"$f":"'2. Macro'!G5+8","v":2019},null,null,null,"t =",{"$f":"E23","v":2019}]
[null,null,null,"AP(t) =",{"$f":"'2. Macro'!O20","v":1.4804051828047005},{"$f":"'2. Macro'!O19","v":2.2875141207293392},null,null,"OG(t) =",{"$f":"E24","v":1.4804051828047005},{"$f":"F24","v":2.2875141207293392}]
[null,null,null,"SBVSDF(t) =",{"$f":"'3. GGbudget'!G20","v":0.69405136668366962},{"$f":"'3. GGbudget'!K20","v":0.50894332478650228},null,null,"SBSSIF(t) =",{"$f":"E25","v":0.69405136668366962},{"$f":"F25","v":0.50894332478650228}]
[null,null,null,"SBVSDF(t–1) =",{"$f":"'3. GGbudget'!F20","v":0.27191354702319825},{"$f":"'3. GGbudget'!J20","v":0.2288621591431392},null,null,"SBSSIF(t–1) =",{"$f":"E26","v":0.27191354702319825},{"$f":"F26","v":0.2288621591431392}]
[null,null,null,"SBPSDF(t) =",{"$f":"+'3. GGbudget'!G21","v":0.14376527027672428},{"$f":"+'3. GGbudget'!K21","v":0.10578583673096326},null,null,"SBNHIF(t) =",{"$f":"E27","v":0.14376527027672428},{"$f":"F27","v":0.10578583673096326}]
[null,null,null,"Šaltiniai:",null,null,null,null,"Sources:"]
[null,null,null,"Finansų ministerija","FM",null,null,null,"Ministry of Finance","MoF"]
[null,null,null,"Fiskalinė institucija","IFI",null,null,null,"Independent Fiscal Institution","IFI"]