{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Duomenų įvestis","Pardavimo ataskaita","Pardavimo prognozė"],"not_rendered":{"charts":5,"external_links":1,"defined_names":8,"pivot_tables":1},"read":"whole","date_system":"1900"}

{"sheet":"Duomenų įvestis","index":0,"n_rows":24,"n_cols":17,"rows_kept":24}
[{"$nulls":9},{"$f":"365*2","v":730}]
[null,"MĖNESINĖ DUOMENŲ ĮVESTIS"]
[{"$nulls":11},"BENDROSIOS SUMOS",null,null,"PROGNOZĖ"]
[]
[null,"DATA","ĮMONĖ","SUMA","SUPLANUOTA","IŠLAIDOS","PAJAMOS","MĖNUO","KETVIRTIS","METAI","MĖNESIO NUMERI (SLĖPTI)","MĖNUO ","KETVIRTIS ","METŲ ","MĖNUO  ","KETVIRTIS  ","METAI  "]
[null,{"$f":"40657+(365*2)","v":"2013-04-23"},"A. AB „Datum“",{"v":6400,"d":"6,400.00 Lt"},{"v":6200,"d":"6,200.00 Lt"},{"v":4450,"d":"4,450.00 Lt"},{"$f":"tblDuomenys[[#This Row],[SUMA]]-tblDuomenys[[#This Row],[IŠLAIDOS]]","v":{"v":1950,"d":"1,950.00 Lt"}},{"$f":"DATE(YEAR('Duomenų įvestis'!$B6),MONTH('Duomenų įvestis'!$B6),1)","v":"2013-04-01"},{"$f":"LOOKUP(MONTH('Duomenų įvestis'!$H6),{1,1;2,1;3,1;4,2;5,2;6,2;7,3;8,3;9,3;10,4;11,4;12,4})","v":{"v":2,"d":"Ketvirtis 2"}},{"$f":"YEAR('Duomenų įvestis'!$B6)","v":2013},{"$f":"MONTH([1]!tblData[[#This Row],[DATE]])","v":4},{"$f":"SUMIFS(tblDuomenys[SUMA],tblDuomenys[DATA],\">=\"&EOMONTH(tblDuomenys[[#This Row],[DATA]],-1)+1,tblDuomenys[DATA],\"<=\"&EOMONTH(tblDuomenys[[#This Row],[DATA]],0))","v":{"v":14600,"d":"14,600.00 Lt"}},{"$f":"SUMIFS(tblDuomenys[SUMA],tblDuomenys[DATA],\">=\"&DATE(YEAR(tblDuomenys[[#This Row],[DATA]]),1,1),tblDuomenys[DATA],\"<=\"&DATE(YEAR(tblDuomenys[[#This Row],[DATA]]),12,31),tblDuomenys[KETVIRTIS],tblDuomenys[[#This Row],[KETVIRTIS]])","v":{"v":50800,"d":"50,800.00 Lt"}},{"$f":"SUMIFS(tblDuomenys[SUMA],tblDuomenys[DATA],\">=\"&DATE(YEAR(tblDuomenys[[#This Row],[DATA]]),1,1),tblDuomenys[DATA],\"<=\"&DATE(YEAR(tblDuomenys[[#This Row],[DATA]]),12,31))","v":{"v":143800,"d":"143,800.00 Lt"}},{"$f":"IFERROR(TREND($L$6:INDEX($L:$L,ROW(),1),$K$6:INDEX($K:$K,ROW(),1),IF(MONTH(tblDuomenys[[#This Row],[DATA]])=12,13,MONTH(tblDuomenys[[#This Row],[DATA]])+1)),\"\")","v":{"v":14600,"d":"14,600.00 Lt"}},{"$f":"IFERROR(TREND($M$6:INDEX($M:$M,ROW(),1),$I$6:INDEX($I:$I,ROW(),1),IF(tblDuomenys[[#This Row],[KETVIRTIS]]=4,5,tblDuomenys[[#This Row],[KETVIRTIS]]+1)),\"\")","v":{"v":50800,"d":"50,800.00 Lt"}},{"$f":"IFERROR(TREND($N$6:INDEX($N:$N,ROW(),1),$J$6:INDEX($J:$J,ROW(),1),tblDuomenys[[#This Row],[METAI]]+1),\"\")","v":{"v":143800,"d":"143,800.00 Lt"}}]
[null,{"$f":"40659+(365*2)","v":"2013-04-25"},"„Contoso“ medikamentai",{"v":8200,"d":"8,200.00 Lt"},{"v":8000,"d":"8,000.00 Lt"},{"v":6400,"d":"6,400.00 Lt"},{"$f":"tblDuomenys[[#This Row],[SUMA]]-tblDuomenys[[#This Row],[IŠLAIDOS]]","v":{"v":1800,"d":"1,800.00 Lt"}},{"$f":"DATE(YEAR('Duomenų įvestis'!$B7),MONTH('Duomenų įvestis'!$B7),1)","v":"2013-04-01"},{"$f":"LOOKUP(MONTH('Duomenų įvestis'!$H7),{1,1;2,1;3,1;4,2;5,2;6,2;7,3;8,3;9,3;10,4;11,4;12,4})","v":{"v":2,"d":"Ketvirtis 2"}},{"$f":"YEAR('Duomenų įvestis'!$B7)","v":2013},{"$f":"MONTH([1]!tblData[[#This Row],[DATE]])","v":4},{"$f":"SUMIFS(tblDuomenys[SUMA],tblDuomenys[DATA],\">=\"&EOMONTH(tblDuomenys[[#This Row],[DATA]],-1)+1,tblDuomenys[DATA],\"<=\"&EOMONTH(tblDuomenys[[#This Row],[DATA]],0))","v":{"v":14600,"d":"14,600.00 Lt"}},{"$f":"SUMIFS(tblDuomenys[SUMA],tblDuomenys[DATA],\">=\"&DATE(YEAR(tblDuomenys[[#This Row],[DATA]]),1,1),tblDuomenys[DATA],\"<=\"&DATE(YEAR(tblDuomenys[[#This Row],[DATA]]),12,31),tblDuomenys[KETVIRTIS],tblDuomenys[[#This Row],[KETVIRTIS]])","v":{"v":50800,"d":"50,800.00 Lt"}},{"$f":"SUMIFS(tblDuomenys[SUMA],tblDuomenys[DATA],\">=\"&DATE(YEAR(tblDuomenys[[#This Row],[DATA]]),1,1),tblDuomenys[DATA],\"<=\"&DATE(YEAR(tblDuomenys[[#This Row],[DATA]]),12,31))","v":{"v":143800,"d":"143,800.00 Lt"}},{"$f":"IFERROR(TREND($L$6:INDEX($L:$L,ROW(),1),$K$6:INDEX($K:$K,ROW(),1),IF(MONTH(tblDuomenys[[#This Row],[DATA]])=12,13,MONTH(tblDuomenys[[#This Row],[DATA]])+1)),\"\")","v":{"v":14600,"d":"14,600.00 Lt"}},{"$f":"IFERROR(TREND($M$6:INDEX($M:$M,ROW(),1),$I$6:INDEX($I:$I,ROW(),1),IF(tblDuomenys[[#This Row],[KETVIRTIS]]=4,5,tblDuomenys[[#This Row],[KETVIRTIS]]+1)),\"\")","v":{"v":50800,"d":"50,800.00 Lt"}},{"$f":"IFERROR(TREND($N$6:INDEX($N:$N,ROW(),1),$J$6:INDEX($J:$J,ROW(),1),tblDuomenys[[#This Row],[METAI]]+1),\"\")","v":{"v":143800,"d":"143,800.00 Lt"}}]
[null,{"$f":"40671+(365*2)","v":"2013-05-07"},"„Consolidated“ kurjeris",{"v":4400,"d":"4,400.00 Lt"},{"v":4200,"d":"4,200.00 Lt"},{"v":2600,"d":"2,600.00 Lt"},{"$f":"tblDuomenys[[#This Row],[SUMA]]-tblDuomenys[[#This Row],[IŠLAIDOS]]","v":{"v":1800,"d":"1,800.00 Lt"}},{"$f":"DATE(YEAR('Duomenų įvestis'!$B8),MONTH('Duomenų įvestis'!$B8),1)","v":"2013-05-01"},{"$f":"LOOKUP(MONTH('Duomenų įvestis'!$H8),{1,1;2,1;3,1;4,2;5,2;6,2;7,3;8,3;9,3;10,4;11,4;12,4})","v":{"v":2,"d":"Ketvirtis 2"}},{"$f":"YEAR('Duomenų įvestis'!$B8)","v":2013},{"$f":"MONTH([1]!tblData[[#This Row],[DATE]])","v":5},{"$f":"SUMIFS(tblDuomenys[SUMA],tblDuomenys[DATA],\">=\"&EOMONTH(tblDuomenys[[#This Row],[DATA]],-1)+1,tblDuomenys[DATA],\"<=\"&EOMONTH(tblDuomenys[[#This Row],[DATA]],0))","v":{"v":21800,"d":"21,800.00 Lt"}},{"$f":"SUMIFS(tblDuomenys[SUMA],tblDuomenys[DATA],\">=\"&DATE(YEAR(tblDuomenys[[#This Row],[DATA]]),1,1),tblDuomenys[DATA],\"<=\"&DATE(YEAR(tblDuomenys[[#This Row],[DATA]]),12,31),tblDuomenys[KETVIRTIS],tblDuomenys[[#This Row],[KETVIRTIS]])","v":{"v":50800,"d":"50,800.00 Lt"}},{"$f":"SUMIFS(tblDuomenys[SUMA],tblDuomenys[DATA],\">=\"&DATE(YEAR(tblDuomenys[[#This Row],[DATA]]),1,1),tblDuomenys[DATA],\"<=\"&DATE(YEAR(tblDuomenys[[#This Row],[DATA]]),12,31))","v":{"v":143800,"d":"143,800.00 Lt"}},{"$f":"IFERROR(TREND($L$6:INDEX($L:$L,ROW(),1),$K$6:INDEX($K:$K,ROW(),1),IF(MONTH(tblDuomenys[[#This Row],[DATA]])=12,13,MONTH(tblDuomenys[[#This Row],[DATA]])+1)),\"\")","v":{"v":28999.999999999996,"d":"29,000.00 Lt"}},{"$f":"IFERROR(TREND($M$6:INDEX($M:$M,ROW(),1),$I$6:INDEX($I:$I,ROW(),1),IF(tblDuomenys[[#This Row],[KETVIRTIS]]=4,5,tblDuomenys[[#This Row],[KETVIRTIS]]+1)),\"\")","v":{"v":50800,"d":"50,800.00 Lt"}},{"$f":"IFERROR(TREND($N$6:INDEX($N:$N,ROW(),1),$J$6:INDEX($J:$J,ROW(),1),tblDuomenys[[#This Row],[METAI]]+1),\"\")","v":{"v":143800,"d":"143,800.00 Lt"}}]
[null,{"$f":"40678+(365*2)","v":"2013-05-14"},"UAB „Proseware“",{"v":5400,"d":"5,400.00 Lt"},{"v":5500,"d":"5,500.00 Lt"},{"v":4500,"d":"4,500.00 Lt"},{"$f":"tblDuomenys[[#This Row],[SUMA]]-tblDuomenys[[#This Row],[IŠLAIDOS]]","v":{"v":900,"d":"900.00 Lt"}},{"$f":"DATE(YEAR('Duomenų įvestis'!$B9),MONTH('Duomenų įvestis'!$B9),1)","v":"2013-05-01"},{"$f":"LOOKUP(MONTH('Duomenų įvestis'!$H9),{1,1;2,1;3,1;4,2;5,2;6,2;7,3;8,3;9,3;10,4;11,4;12,4})","v":{"v":2,"d":"Ketvirtis 2"}},{"$f":"YEAR('Duomenų įvestis'!$B9)","v":2013},{"$f":"MONTH([1]!tblData[[#This Row],[DATE]])","v":5},{"$f":"SUMIFS(tblDuomenys[SUMA],tblDuomenys[DATA],\">=\"&EOMONTH(tblDuomenys[[#This Row],[DATA]],-1)+1,tblDuomenys[DATA],\"<=\"&EOMONTH(tblDuomenys[[#This Row],[DATA]],0))","v":{"v":21800,"d":"21,800.00 Lt"}},{"$f":"SUMIFS(tblDuomenys[SUMA],tblDuomenys[DATA],\">=\"&DATE(YEAR(tblDuomenys[[#This Row],[DATA]]),1,1),tblDuomenys[DATA],\"<=\"&DATE(YEAR(tblDuomenys[[#This Row],[DATA]]),12,31),tblDuomenys[KETVIRTIS],tblDuomenys[[#This Row],[KETVIRTIS]])","v":{"v":50800,"d":"50,800.00 Lt"}},{"$f":"SUMIFS(tblDuomenys[SUMA],tblDuomenys[DATA],\">=\"&DATE(YEAR(tblDuomenys[[#This Row],[DATA]]),1,1),tblDuomenys[DATA],\"<=\"&DATE(YEAR(tblDuomenys[[#This Row],[DATA]]),12,31))","v":{"v":143800,"d":"143,800.00 Lt"}},{"$f":"IFERROR(TREND($L$6:INDEX($L:$L,ROW(),1),$K$6:INDEX($K:$K,ROW(),1),IF(MONTH(tblDuomenys[[#This Row],[DATA]])=12,13,MONTH(tblDuomenys[[#This Row],[DATA]])+1)),\"\")","v":{"v":29000,"d":"29,000.00 Lt"}},{"$f":"IFERROR(TREND($M$6:INDEX($M:$M,ROW(),1),$I$6:INDEX($I:$I,ROW(),1),IF(tblDuomenys[[#This Row],[KETVIRTIS]]=4,5,tblDuomenys[[#This Row],[KETVIRTIS]]+1)),\"\")","v":{"v":50800,"d":"50,800.00 Lt"}},{"$f":"IFERROR(TREND($N$6:INDEX($N:$N,ROW(),1),$J$6:INDEX($J:$J,ROW(),1),tblDuomenys[[#This Row],[METAI]]+1),\"\")","v":{"v":143800,"d":"143,800.00 Lt"}}]
[null,{"$f":"40678+(365*2)","v":"2013-05-14"},"Dailiųjų menų mokykla",{"v":5800,"d":"5,800.00 Lt"},{"v":6000,"d":"6,000.00 Lt"},{"v":4500,"d":"4,500.00 Lt"},{"$f":"tblDuomenys[[#This Row],[SUMA]]-tblDuomenys[[#This Row],[IŠLAIDOS]]","v":{"v":1300,"d":"1,300.00 Lt"}},{"$f":"DATE(YEAR('Duomenų įvestis'!$B10),MONTH('Duomenų įvestis'!$B10),1)","v":"2013-05-01"},{"$f":"LOOKUP(MONTH('Duomenų įvestis'!$H10),{1,1;2,1;3,1;4,2;5,2;6,2;7,3;8,3;9,3;10,4;11,4;12,4})","v":{"v":2,"d":"Ketvirtis 2"}},{"$f":"YEAR('Duomenų įvestis'!$B10)","v":2013},{"$f":"MONTH([1]!tblData[[#This Row],[DATE]])","v":5},{"$f":"SUMIFS(tblDuomenys[SUMA],tblDuomenys[DATA],\">=\"&EOMONTH(tblDuomenys[[#This Row],[DATA]],-1)+1,tblDuomenys[DATA],\"<=\"&EOMONTH(tblDuomenys[[#This Row],[DATA]],0))","v":{"v":21800,"d":"21,800.00 Lt"}},{"$f":"SUMIFS(tblDuomenys[SUMA],tblDuomenys[DATA],\">=\"&DATE(YEAR(tblDuomenys[[#This Row],[DATA]]),1,1),tblDuomenys[DATA],\"<=\"&DATE(YEAR(tblDuomenys[[#This Row],[DATA]]),12,31),tblDuomenys[KETVIRTIS],tblDuomenys[[#This Row],[KETVIRTIS]])","v":{"v":50800,"d":"50,800.00 Lt"}},{"$f":"SUMIFS(tblDuomenys[SUMA],tblDuomenys[DATA],\">=\"&DATE(YEAR(tblDuomenys[[#This Row],[DATA]]),1,1),tblDuomenys[DATA],\"<=\"&DATE(YEAR(tblDuomenys[[#This Row],[DATA]]),12,31))","v":{"v":143800,"d":"143,800.00 Lt"}},{"$f":"IFERROR(TREND($L$6:INDEX($L:$L,ROW(),1),$K$6:INDEX($K:$K,ROW(),1),IF(MONTH(tblDuomenys[[#This Row],[DATA]])=12,13,MONTH(tblDuomenys[[#This Row],[DATA]])+1)),\"\")","v":{"v":29000,"d":"29,000.00 Lt"}},{"$f":"IFERROR(TREND($M$6:INDEX($M:$M,ROW(),1),$I$6:INDEX($I:$I,ROW(),1),IF(tblDuomenys[[#This Row],[KETVIRTIS]]=4,5,tblDuomenys[[#This Row],[KETVIRTIS]]+1)),\"\")","v":{"v":50800,"d":"50,800.00 Lt"}},{"$f":"IFERROR(TREND($N$6:INDEX($N:$N,ROW(),1),$J$6:INDEX($J:$J,ROW(),1),tblDuomenys[[#This Row],[METAI]]+1),\"\")","v":{"v":143800,"d":"143,800.00 Lt"}}]
[null,{"$f":"40693+(365*2)","v":"2013-05-29"},"„Trey“ tyrimai",{"v":6200,"d":"6,200.00 Lt"},{"v":6000,"d":"6,000.00 Lt"},{"v":4500,"d":"4,500.00 Lt"},{"$f":"tblDuomenys[[#This Row],[SUMA]]-tblDuomenys[[#This Row],[IŠLAIDOS]]","v":{"v":1700,"d":"1,700.00 Lt"}},{"$f":"DATE(YEAR('Duomenų įvestis'!$B11),MONTH('Duomenų įvestis'!$B11),1)","v":"2013-05-01"},{"$f":"LOOKUP(MONTH('Duomenų įvestis'!$H11),{1,1;2,1;3,1;4,2;5,2;6,2;7,3;8,3;9,3;10,4;11,4;12,4})","v":{"v":2,"d":"Ketvirtis 2"}},{"$f":"YEAR('Duomenų įvestis'!$B11)","v":2013},{"$f":"MONTH([1]!tblData[[#This Row],[DATE]])","v":5},{"$f":"SUMIFS(tblDuomenys[SUMA],tblDuomenys[DATA],\">=\"&EOMONTH(tblDuomenys[[#This Row],[DATA]],-1)+1,tblDuomenys[DATA],\"<=\"&EOMONTH(tblDuomenys[[#This Row],[DATA]],0))","v":{"v":21800,"d":"21,800.00 Lt"}},{"$f":"SUMIFS(tblDuomenys[SUMA],tblDuomenys[DATA],\">=\"&DATE(YEAR(tblDuomenys[[#This Row],[DATA]]),1,1),tblDuomenys[DATA],\"<=\"&DATE(YEAR(tblDuomenys[[#This Row],[DATA]]),12,31),tblDuomenys[KETVIRTIS],tblDuomenys[[#This Row],[KETVIRTIS]])","v":{"v":50800,"d":"50,800.00 Lt"}},{"$f":"SUMIFS(tblDuomenys[SUMA],tblDuomenys[DATA],\">=\"&DATE(YEAR(tblDuomenys[[#This Row],[DATA]]),1,1),tblDuomenys[DATA],\"<=\"&DATE(YEAR(tblDuomenys[[#This Row],[DATA]]),12,31))","v":{"v":143800,"d":"143,800.00 Lt"}},{"$f":"IFERROR(TREND($L$6:INDEX($L:$L,ROW(),1),$K$6:INDEX($K:$K,ROW(),1),IF(MONTH(tblDuomenys[[#This Row],[DATA]])=12,13,MONTH(tblDuomenys[[#This Row],[DATA]])+1)),\"\")","v":{"v":29000,"d":"29,000.00 Lt"}},{"$f":"IFERROR(TREND($M$6:INDEX($M:$M,ROW(),1),$I$6:INDEX($I:$I,ROW(),1),IF(tblDuomenys[[#This Row],[KETVIRTIS]]=4,5,tblDuomenys[[#This Row],[KETVIRTIS]]+1)),\"\")","v":{"v":50800,"d":"50,800.00 Lt"}},{"$f":"IFERROR(TREND($N$6:INDEX($N:$N,ROW(),1),$J$6:INDEX($J:$J,ROW(),1),tblDuomenys[[#This Row],[METAI]]+1),\"\")","v":{"v":143800,"d":"143,800.00 Lt"}}]
[null,{"$f":"40705+(365*2)","v":"2013-06-10"},"A. AB „Datum“",{"v":6900,"d":"6,900.00 Lt"},{"v":7500,"d":"7,500.00 Lt"},{"v":5400,"d":"5,400.00 Lt"},{"$f":"tblDuomenys[[#This Row],[SUMA]]-tblDuomenys[[#This Row],[IŠLAIDOS]]","v":{"v":1500,"d":"1,500.00 Lt"}},{"$f":"DATE(YEAR('Duomenų įvestis'!$B12),MONTH('Duomenų įvestis'!$B12),1)","v":"2013-06-01"},{"$f":"LOOKUP(MONTH('Duomenų įvestis'!$H12),{1,1;2,1;3,1;4,2;5,2;6,2;7,3;8,3;9,3;10,4;11,4;12,4})","v":{"v":2,"d":"Ketvirtis 2"}},{"$f":"YEAR('Duomenų įvestis'!$B12)","v":2013},{"$f":"MONTH([1]!tblData[[#This Row],[DATE]])","v":6},{"$f":"SUMIFS(tblDuomenys[SUMA],tblDuomenys[DATA],\">=\"&EOMONTH(tblDuomenys[[#This Row],[DATA]],-1)+1,tblDuomenys[DATA],\"<=\"&EOMONTH(tblDuomenys[[#This Row],[DATA]],0))","v":{"v":14400,"d":"14,400.00 Lt"}},{"$f":"SUMIFS(tblDuomenys[SUMA],tblDuomenys[DATA],\">=\"&DATE(YEAR(tblDuomenys[[#This Row],[DATA]]),1,1),tblDuomenys[DATA],\"<=\"&DATE(YEAR(tblDuomenys[[#This Row],[DATA]]),12,31),tblDuomenys[KETVIRTIS],tblDuomenys[[#This Row],[KETVIRTIS]])","v":{"v":50800,"d":"50,800.00 Lt"}},{"$f":"SUMIFS(tblDuomenys[SUMA],tblDuomenys[DATA],\">=\"&DATE(YEAR(tblDuomenys[[#This Row],[DATA]]),1,1),tblDuomenys[DATA],\"<=\"&DATE(YEAR(tblDuomenys[[#This Row],[DATA]]),12,31))","v":{"v":143800,"d":"143,800.00 Lt"}},{"$f":"IFERROR(TREND($L$6:INDEX($L:$L,ROW(),1),$K$6:INDEX($K:$K,ROW(),1),IF(MONTH(tblDuomenys[[#This Row],[DATA]])=12,13,MONTH(tblDuomenys[[#This Row],[DATA]])+1)),\"\")","v":{"v":21600.000000000004,"d":"21,600.00 Lt"}},{"$f":"IFERROR(TREND($M$6:INDEX($M:$M,ROW(),1),$I$6:INDEX($I:$I,ROW(),1),IF(tblDuomenys[[#This Row],[KETVIRTIS]]=4,5,tblDuomenys[[#This Row],[KETVIRTIS]]+1)),\"\")","v":{"v":50800,"d":"50,800.00 Lt"}},{"$f":"IFERROR(TREND($N$6:INDEX($N:$N,ROW(),1),$J$6:INDEX($J:$J,ROW(),1),tblDuomenys[[#This Row],[METAI]]+1),\"\")","v":{"v":143800,"d":"143,800.00 Lt"}}]
[null,{"$f":"40716+(365*2)","v":"2013-06-21"},"„Contoso“ medikamentai",{"v":7500,"d":"7,500.00 Lt"},{"v":7200,"d":"7,200.00 Lt"},{"v":6500,"d":"6,500.00 Lt"},{"$f":"tblDuomenys[[#This Row],[SUMA]]-tblDuomenys[[#This Row],[IŠLAIDOS]]","v":{"v":1000,"d":"1,000.00 Lt"}},{"$f":"DATE(YEAR('Duomenų įvestis'!$B13),MONTH('Duomenų įvestis'!$B13),1)","v":"2013-06-01"},{"$f":"LOOKUP(MONTH('Duomenų įvestis'!$H13),{1,1;2,1;3,1;4,2;5,2;6,2;7,3;8,3;9,3;10,4;11,4;12,4})","v":{"v":2,"d":"Ketvirtis 2"}},{"$f":"YEAR('Duomenų įvestis'!$B13)","v":2013},{"$f":"MONTH([1]!tblData[[#This Row],[DATE]])","v":6},{"$f":"SUMIFS(tblDuomenys[SUMA],tblDuomenys[DATA],\">=\"&EOMONTH(tblDuomenys[[#This Row],[DATA]],-1)+1,tblDuomenys[DATA],\"<=\"&EOMONTH(tblDuomenys[[#This Row],[DATA]],0))","v":{"v":14400,"d":"14,400.00 Lt"}},{"$f":"SUMIFS(tblDuomenys[SUMA],tblDuomenys[DATA],\">=\"&DATE(YEAR(tblDuomenys[[#This Row],[DATA]]),1,1),tblDuomenys[DATA],\"<=\"&DATE(YEAR(tblDuomenys[[#This Row],[DATA]]),12,31),tblDuomenys[KETVIRTIS],tblDuomenys[[#This Row],[KETVIRTIS]])","v":{"v":50800,"d":"50,800.00 Lt"}},{"$f":"SUMIFS(tblDuomenys[SUMA],tblDuomenys[DATA],\">=\"&DATE(YEAR(tblDuomenys[[#This Row],[DATA]]),1,1),tblDuomenys[DATA],\"<=\"&DATE(YEAR(tblDuomenys[[#This Row],[DATA]]),12,31))","v":{"v":143800,"d":"143,800.00 Lt"}},{"$f":"IFERROR(TREND($L$6:INDEX($L:$L,ROW(),1),$K$6:INDEX($K:$K,ROW(),1),IF(MONTH(tblDuomenys[[#This Row],[DATA]])=12,13,MONTH(tblDuomenys[[#This Row],[DATA]])+1)),\"\")","v":{"v":17950,"d":"17,950.00 Lt"}},{"$f":"IFERROR(TREND($M$6:INDEX($M:$M,ROW(),1),$I$6:INDEX($I:$I,ROW(),1),IF(tblDuomenys[[#This Row],[KETVIRTIS]]=4,5,tblDuomenys[[#This Row],[KETVIRTIS]]+1)),\"\")","v":{"v":50800,"d":"50,800.00 Lt"}},{"$f":"IFERROR(TREND($N$6:INDEX($N:$N,ROW(),1),$J$6:INDEX($J:$J,ROW(),1),tblDuomenys[[#This Row],[METAI]]+1),\"\")","v":{"v":143800,"d":"143,800.00 Lt"}}]
[null,{"$f":"40731+(365*2)","v":"2013-07-06"},"„Consolidated“ kurjeris",{"v":8700,"d":"8,700.00 Lt"},{"v":8500,"d":"8,500.00 Lt"},{"v":7250,"d":"7,250.00 Lt"},{"$f":"tblDuomenys[[#This Row],[SUMA]]-tblDuomenys[[#This Row],[IŠLAIDOS]]","v":{"v":1450,"d":"1,450.00 Lt"}},{"$f":"DATE(YEAR('Duomenų įvestis'!$B14),MONTH('Duomenų įvestis'!$B14),1)","v":"2013-07-01"},{"$f":"LOOKUP(MONTH('Duomenų įvestis'!$H14),{1,1;2,1;3,1;4,2;5,2;6,2;7,3;8,3;9,3;10,4;11,4;12,4})","v":{"v":3,"d":"Ketvirtis 3"}},{"$f":"YEAR('Duomenų įvestis'!$B14)","v":2013},{"$f":"MONTH([1]!tblData[[#This Row],[DATE]])","v":7},{"$f":"SUMIFS(tblDuomenys[SUMA],tblDuomenys[DATA],\">=\"&EOMONTH(tblDuomenys[[#This Row],[DATA]],-1)+1,tblDuomenys[DATA],\"<=\"&EOMONTH(tblDuomenys[[#This Row],[DATA]],0))","v":{"v":8700,"d":"8,700.00 Lt"}},{"$f":"SUMIFS(tblDuomenys[SUMA],tblDuomenys[DATA],\">=\"&DATE(YEAR(tblDuomenys[[#This Row],[DATA]]),1,1),tblDuomenys[DATA],\"<=\"&DATE(YEAR(tblDuomenys[[#This Row],[DATA]]),12,31),tblDuomenys[KETVIRTIS],tblDuomenys[[#This Row],[KETVIRTIS]])","v":{"v":49100,"d":"49,100.00 Lt"}},{"$f":"SUMIFS(tblDuomenys[SUMA],tblDuomenys[DATA],\">=\"&DATE(YEAR(tblDuomenys[[#This Row],[DATA]]),1,1),tblDuomenys[DATA],\"<=\"&DATE(YEAR(tblDuomenys[[#This Row],[DATA]]),12,31))","v":{"v":143800,"d":"143,800.00 Lt"}},{"$f":"IFERROR(TREND($L$6:INDEX($L:$L,ROW(),1),$K$6:INDEX($K:$K,ROW(),1),IF(MONTH(tblDuomenys[[#This Row],[DATA]])=12,13,MONTH(tblDuomenys[[#This Row],[DATA]])+1)),\"\")","v":{"v":10776.470588235294,"d":"10,776.47 Lt"}},{"$f":"IFERROR(TREND($M$6:INDEX($M:$M,ROW(),1),$I$6:INDEX($I:$I,ROW(),1),IF(tblDuomenys[[#This Row],[KETVIRTIS]]=4,5,tblDuomenys[[#This Row],[KETVIRTIS]]+1)),\"\")","v":{"v":47400,"d":"47,400.00 Lt"}},{"$f":"IFERROR(TREND($N$6:INDEX($N:$N,ROW(),1),$J$6:INDEX($J:$J,ROW(),1),tblDuomenys[[#This Row],[METAI]]+1),\"\")","v":{"v":143800,"d":"143,800.00 Lt"}}]
[null,{"$f":"40761+(365*2)","v":"2013-08-05"},"UAB „Proseware“",{"v":8500,"d":"8,500.00 Lt"},{"v":8300,"d":"8,300.00 Lt"},{"v":7100,"d":"7,100.00 Lt"},{"$f":"tblDuomenys[[#This Row],[SUMA]]-tblDuomenys[[#This Row],[IŠLAIDOS]]","v":{"v":1400,"d":"1,400.00 Lt"}},{"$f":"DATE(YEAR('Duomenų įvestis'!$B15),MONTH('Duomenų įvestis'!$B15),1)","v":"2013-08-01"},{"$f":"LOOKUP(MONTH('Duomenų įvestis'!$H15),{1,1;2,1;3,1;4,2;5,2;6,2;7,3;8,3;9,3;10,4;11,4;12,4})","v":{"v":3,"d":"Ketvirtis 3"}},{"$f":"YEAR('Duomenų įvestis'!$B15)","v":2013},{"$f":"MONTH([1]!tblData[[#This Row],[DATE]])","v":8},{"$f":"SUMIFS(tblDuomenys[SUMA],tblDuomenys[DATA],\">=\"&EOMONTH(tblDuomenys[[#This Row],[DATA]],-1)+1,tblDuomenys[DATA],\"<=\"&EOMONTH(tblDuomenys[[#This Row],[DATA]],0))","v":{"v":16400,"d":"16,400.00 Lt"}},{"$f":"SUMIFS(tblDuomenys[SUMA],tblDuomenys[DATA],\">=\"&DATE(YEAR(tblDuomenys[[#This Row],[DATA]]),1,1),tblDuomenys[DATA],\"<=\"&DATE(YEAR(tblDuomenys[[#This Row],[DATA]]),12,31),tblDuomenys[KETVIRTIS],tblDuomenys[[#This Row],[KETVIRTIS]])","v":{"v":49100,"d":"49,100.00 Lt"}},{"$f":"SUMIFS(tblDuomenys[SUMA],tblDuomenys[DATA],\">=\"&DATE(YEAR(tblDuomenys[[#This Row],[DATA]]),1,1),tblDuomenys[DATA],\"<=\"&DATE(YEAR(tblDuomenys[[#This Row],[DATA]]),12,31))","v":{"v":143800,"d":"143,800.00 Lt"}},{"$f":"IFERROR(TREND($L$6:INDEX($L:$L,ROW(),1),$K$6:INDEX($K:$K,ROW(),1),IF(MONTH(tblDuomenys[[#This Row],[DATA]])=12,13,MONTH(tblDuomenys[[#This Row],[DATA]])+1)),\"\")","v":{"v":12455.862068965516,"d":"12,455.86 Lt"}},{"$f":"IFERROR(TREND($M$6:INDEX($M:$M,ROW(),1),$I$6:INDEX($I:$I,ROW(),1),IF(tblDuomenys[[#This Row],[KETVIRTIS]]=4,5,tblDuomenys[[#This Row],[KETVIRTIS]]+1)),\"\")","v":{"v":47400,"d":"47,400.00 Lt"}},{"$f":"IFERROR(TREND($N$6:INDEX($N:$N,ROW(),1),$J$6:INDEX($J:$J,ROW(),1),tblDuomenys[[#This Row],[METAI]]+1),\"\")","v":{"v":143800,"d":"143,800.00 Lt"}}]
[null,{"$f":"40775+(365*2)","v":"2013-08-19"},"Dailiųjų menų mokykla",{"v":7900,"d":"7,900.00 Lt"},{"v":7700,"d":"7,700.00 Lt"},{"v":6600,"d":"6,600.00 Lt"},{"$f":"tblDuomenys[[#This Row],[SUMA]]-tblDuomenys[[#This Row],[IŠLAIDOS]]","v":{"v":1300,"d":"1,300.00 Lt"}},{"$f":"DATE(YEAR('Duomenų įvestis'!$B16),MONTH('Duomenų įvestis'!$B16),1)","v":"2013-08-01"},{"$f":"LOOKUP(MONTH('Duomenų įvestis'!$H16),{1,1;2,1;3,1;4,2;5,2;6,2;7,3;8,3;9,3;10,4;11,4;12,4})","v":{"v":3,"d":"Ketvirtis 3"}},{"$f":"YEAR('Duomenų įvestis'!$B16)","v":2013},{"$f":"MONTH([1]!tblData[[#This Row],[DATE]])","v":8},{"$f":"SUMIFS(tblDuomenys[SUMA],tblDuomenys[DATA],\">=\"&EOMONTH(tblDuomenys[[#This Row],[DATA]],-1)+1,tblDuomenys[DATA],\"<=\"&EOMONTH(tblDuomenys[[#This Row],[DATA]],0))","v":{"v":16400,"d":"16,400.00 Lt"}},{"$f":"SUMIFS(tblDuomenys[SUMA],tblDuomenys[DATA],\">=\"&DATE(YEAR(tblDuomenys[[#This Row],[DATA]]),1,1),tblDuomenys[DATA],\"<=\"&DATE(YEAR(tblDuomenys[[#This Row],[DATA]]),12,31),tblDuomenys[KETVIRTIS],tblDuomenys[[#This Row],[KETVIRTIS]])","v":{"v":49100,"d":"49,100.00 Lt"}},{"$f":"SUMIFS(tblDuomenys[SUMA],tblDuomenys[DATA],\">=\"&DATE(YEAR(tblDuomenys[[#This Row],[DATA]]),1,1),tblDuomenys[DATA],\"<=\"&DATE(YEAR(tblDuomenys[[#This Row],[DATA]]),12,31))","v":{"v":143800,"d":"143,800.00 Lt"}},{"$f":"IFERROR(TREND($L$6:INDEX($L:$L,ROW(),1),$K$6:INDEX($K:$K,ROW(),1),IF(MONTH(tblDuomenys[[#This Row],[DATA]])=12,13,MONTH(tblDuomenys[[#This Row],[DATA]])+1)),\"\")","v":{"v":13667.567567567567,"d":"13,667.57 Lt"}},{"$f":"IFERROR(TREND($M$6:INDEX($M:$M,ROW(),1),$I$6:INDEX($I:$I,ROW(),1),IF(tblDuomenys[[#This Row],[KETVIRTIS]]=4,5,tblDuomenys[[#This Row],[KETVIRTIS]]+1)),\"\")","v":{"v":47400.00000000001,"d":"47,400.00 Lt"}},{"$f":"IFERROR(TREND($N$6:INDEX($N:$N,ROW(),1),$J$6:INDEX($J:$J,ROW(),1),tblDuomenys[[#This Row],[METAI]]+1),\"\")","v":{"v":143800,"d":"143,800.00 Lt"}}]
[null,{"$f":"40791+(365*2)","v":"2013-09-04"},"„Trey“ tyrimai",{"v":9100,"d":"9,100.00 Lt"},{"v":8900,"d":"8,900.00 Lt"},{"v":7900,"d":"7,900.00 Lt"},{"$f":"tblDuomenys[[#This Row],[SUMA]]-tblDuomenys[[#This Row],[IŠLAIDOS]]","v":{"v":1200,"d":"1,200.00 Lt"}},{"$f":"DATE(YEAR('Duomenų įvestis'!$B17),MONTH('Duomenų įvestis'!$B17),1)","v":"2013-09-01"},{"$f":"LOOKUP(MONTH('Duomenų įvestis'!$H17),{1,1;2,1;3,1;4,2;5,2;6,2;7,3;8,3;9,3;10,4;11,4;12,4})","v":{"v":3,"d":"Ketvirtis 3"}},{"$f":"YEAR('Duomenų įvestis'!$B17)","v":2013},{"$f":"MONTH([1]!tblData[[#This Row],[DATE]])","v":9},{"$f":"SUMIFS(tblDuomenys[SUMA],tblDuomenys[DATA],\">=\"&EOMONTH(tblDuomenys[[#This Row],[DATA]],-1)+1,tblDuomenys[DATA],\"<=\"&EOMONTH(tblDuomenys[[#This Row],[DATA]],0))","v":{"v":24000,"d":"24,000.00 Lt"}},{"$f":"SUMIFS(tblDuomenys[SUMA],tblDuomenys[DATA],\">=\"&DATE(YEAR(tblDuomenys[[#This Row],[DATA]]),1,1),tblDuomenys[DATA],\"<=\"&DATE(YEAR(tblDuomenys[[#This Row],[DATA]]),12,31),tblDuomenys[KETVIRTIS],tblDuomenys[[#This Row],[KETVIRTIS]])","v":{"v":49100,"d":"49,100.00 Lt"}},{"$f":"SUMIFS(tblDuomenys[SUMA],tblDuomenys[DATA],\">=\"&DATE(YEAR(tblDuomenys[[#This Row],[DATA]]),1,1),tblDuomenys[DATA],\"<=\"&DATE(YEAR(tblDuomenys[[#This Row],[DATA]]),12,31))","v":{"v":143800,"d":"143,800.00 Lt"}},{"$f":"IFERROR(TREND($L$6:INDEX($L:$L,ROW(),1),$K$6:INDEX($K:$K,ROW(),1),IF(MONTH(tblDuomenys[[#This Row],[DATA]])=12,13,MONTH(tblDuomenys[[#This Row],[DATA]])+1)),\"\")","v":{"v":17651.666666666668,"d":"17,651.67 Lt"}},{"$f":"IFERROR(TREND($M$6:INDEX($M:$M,ROW(),1),$I$6:INDEX($I:$I,ROW(),1),IF(tblDuomenys[[#This Row],[KETVIRTIS]]=4,5,tblDuomenys[[#This Row],[KETVIRTIS]]+1)),\"\")","v":{"v":47400,"d":"47,400.00 Lt"}},{"$f":"IFERROR(TREND($N$6:INDEX($N:$N,ROW(),1),$J$6:INDEX($J:$J,ROW(),1),tblDuomenys[[#This Row],[METAI]]+1),\"\")","v":{"v":143800,"d":"143,800.00 Lt"}}]
[null,{"$f":"40807+(365*2)","v":"2013-09-20"},"„Contoso“ medikamentai",{"v":5600,"d":"5,600.00 Lt"},{"v":5800,"d":"5,800.00 Lt"},{"v":4500,"d":"4,500.00 Lt"},{"$f":"tblDuomenys[[#This Row],[SUMA]]-tblDuomenys[[#This Row],[IŠLAIDOS]]","v":{"v":1100,"d":"1,100.00 Lt"}},{"$f":"DATE(YEAR('Duomenų įvestis'!$B18),MONTH('Duomenų įvestis'!$B18),1)","v":"2013-09-01"},{"$f":"LOOKUP(MONTH('Duomenų įvestis'!$H18),{1,1;2,1;3,1;4,2;5,2;6,2;7,3;8,3;9,3;10,4;11,4;12,4})","v":{"v":3,"d":"Ketvirtis 3"}},{"$f":"YEAR('Duomenų įvestis'!$B18)","v":2013},{"$f":"MONTH([1]!tblData[[#This Row],[DATE]])","v":9},{"$f":"SUMIFS(tblDuomenys[SUMA],tblDuomenys[DATA],\">=\"&EOMONTH(tblDuomenys[[#This Row],[DATA]],-1)+1,tblDuomenys[DATA],\"<=\"&EOMONTH(tblDuomenys[[#This Row],[DATA]],0))","v":{"v":24000,"d":"24,000.00 Lt"}},{"$f":"SUMIFS(tblDuomenys[SUMA],tblDuomenys[DATA],\">=\"&DATE(YEAR(tblDuomenys[[#This Row],[DATA]]),1,1),tblDuomenys[DATA],\"<=\"&DATE(YEAR(tblDuomenys[[#This Row],[DATA]]),12,31),tblDuomenys[KETVIRTIS],tblDuomenys[[#This Row],[KETVIRTIS]])","v":{"v":49100,"d":"49,100.00 Lt"}},{"$f":"SUMIFS(tblDuomenys[SUMA],tblDuomenys[DATA],\">=\"&DATE(YEAR(tblDuomenys[[#This Row],[DATA]]),1,1),tblDuomenys[DATA],\"<=\"&DATE(YEAR(tblDuomenys[[#This Row],[DATA]]),12,31))","v":{"v":143800,"d":"143,800.00 Lt"}},{"$f":"IFERROR(TREND($L$6:INDEX($L:$L,ROW(),1),$K$6:INDEX($K:$K,ROW(),1),IF(MONTH(tblDuomenys[[#This Row],[DATA]])=12,13,MONTH(tblDuomenys[[#This Row],[DATA]])+1)),\"\")","v":{"v":19877.911646586344,"d":"19,877.91 Lt"}},{"$f":"IFERROR(TREND($M$6:INDEX($M:$M,ROW(),1),$I$6:INDEX($I:$I,ROW(),1),IF(tblDuomenys[[#This Row],[KETVIRTIS]]=4,5,tblDuomenys[[#This Row],[KETVIRTIS]]+1)),\"\")","v":{"v":47400,"d":"47,400.00 Lt"}},{"$f":"IFERROR(TREND($N$6:INDEX($N:$N,ROW(),1),$J$6:INDEX($J:$J,ROW(),1),tblDuomenys[[#This Row],[METAI]]+1),\"\")","v":{"v":143800,"d":"143,800.00 Lt"}}]
[null,{"$f":"40812+(365*2)","v":"2013-09-25"},"„Consolidated“ kurjeris",{"v":9300,"d":"9,300.00 Lt"},{"v":9100,"d":"9,100.00 Lt"},{"v":7500,"d":"7,500.00 Lt"},{"$f":"tblDuomenys[[#This Row],[SUMA]]-tblDuomenys[[#This Row],[IŠLAIDOS]]","v":{"v":1800,"d":"1,800.00 Lt"}},{"$f":"DATE(YEAR('Duomenų įvestis'!$B19),MONTH('Duomenų įvestis'!$B19),1)","v":"2013-09-01"},{"$f":"LOOKUP(MONTH('Duomenų įvestis'!$H19),{1,1;2,1;3,1;4,2;5,2;6,2;7,3;8,3;9,3;10,4;11,4;12,4})","v":{"v":3,"d":"Ketvirtis 3"}},{"$f":"YEAR('Duomenų įvestis'!$B19)","v":2013},{"$f":"MONTH([1]!tblData[[#This Row],[DATE]])","v":9},{"$f":"SUMIFS(tblDuomenys[SUMA],tblDuomenys[DATA],\">=\"&EOMONTH(tblDuomenys[[#This Row],[DATA]],-1)+1,tblDuomenys[DATA],\"<=\"&EOMONTH(tblDuomenys[[#This Row],[DATA]],0))","v":{"v":24000,"d":"24,000.00 Lt"}},{"$f":"SUMIFS(tblDuomenys[SUMA],tblDuomenys[DATA],\">=\"&DATE(YEAR(tblDuomenys[[#This Row],[DATA]]),1,1),tblDuomenys[DATA],\"<=\"&DATE(YEAR(tblDuomenys[[#This Row],[DATA]]),12,31),tblDuomenys[KETVIRTIS],tblDuomenys[[#This Row],[KETVIRTIS]])","v":{"v":49100,"d":"49,100.00 Lt"}},{"$f":"SUMIFS(tblDuomenys[SUMA],tblDuomenys[DATA],\">=\"&DATE(YEAR(tblDuomenys[[#This Row],[DATA]]),1,1),tblDuomenys[DATA],\"<=\"&DATE(YEAR(tblDuomenys[[#This Row],[DATA]]),12,31))","v":{"v":143800,"d":"143,800.00 Lt"}},{"$f":"IFERROR(TREND($L$6:INDEX($L:$L,ROW(),1),$K$6:INDEX($K:$K,ROW(),1),IF(MONTH(tblDuomenys[[#This Row],[DATA]])=12,13,MONTH(tblDuomenys[[#This Row],[DATA]])+1)),\"\")","v":{"v":21138.050314465407,"d":"21,138.05 Lt"}},{"$f":"IFERROR(TREND($M$6:INDEX($M:$M,ROW(),1),$I$6:INDEX($I:$I,ROW(),1),IF(tblDuomenys[[#This Row],[KETVIRTIS]]=4,5,tblDuomenys[[#This Row],[KETVIRTIS]]+1)),\"\")","v":{"v":47400,"d":"47,400.00 Lt"}},{"$f":"IFERROR(TREND($N$6:INDEX($N:$N,ROW(),1),$J$6:INDEX($J:$J,ROW(),1),tblDuomenys[[#This Row],[METAI]]+1),\"\")","v":{"v":143800,"d":"143,800.00 Lt"}}]
[null,{"$f":"40832+(365*2)","v":"2013-10-15"},"UAB „Proseware“",{"v":8800,"d":"8,800.00 Lt"},{"v":9350,"d":"9,350.00 Lt"},{"v":7100,"d":"7,100.00 Lt"},{"$f":"tblDuomenys[[#This Row],[SUMA]]-tblDuomenys[[#This Row],[IŠLAIDOS]]","v":{"v":1700,"d":"1,700.00 Lt"}},{"$f":"DATE(YEAR('Duomenų įvestis'!$B20),MONTH('Duomenų įvestis'!$B20),1)","v":"2013-10-01"},{"$f":"LOOKUP(MONTH('Duomenų įvestis'!$H20),{1,1;2,1;3,1;4,2;5,2;6,2;7,3;8,3;9,3;10,4;11,4;12,4})","v":{"v":4,"d":"Ketvirtis 4"}},{"$f":"YEAR('Duomenų įvestis'!$B20)","v":2013},{"$f":"MONTH([1]!tblData[[#This Row],[DATE]])","v":10},{"$f":"SUMIFS(tblDuomenys[SUMA],tblDuomenys[DATA],\">=\"&EOMONTH(tblDuomenys[[#This Row],[DATA]],-1)+1,tblDuomenys[DATA],\"<=\"&EOMONTH(tblDuomenys[[#This Row],[DATA]],0))","v":{"v":8800,"d":"8,800.00 Lt"}},{"$f":"SUMIFS(tblDuomenys[SUMA],tblDuomenys[DATA],\">=\"&DATE(YEAR(tblDuomenys[[#This Row],[DATA]]),1,1),tblDuomenys[DATA],\"<=\"&DATE(YEAR(tblDuomenys[[#This Row],[DATA]]),12,31),tblDuomenys[KETVIRTIS],tblDuomenys[[#This Row],[KETVIRTIS]])","v":{"v":43900,"d":"43,900.00 Lt"}},{"$f":"SUMIFS(tblDuomenys[SUMA],tblDuomenys[DATA],\">=\"&DATE(YEAR(tblDuomenys[[#This Row],[DATA]]),1,1),tblDuomenys[DATA],\"<=\"&DATE(YEAR(tblDuomenys[[#This Row],[DATA]]),12,31))","v":{"v":143800,"d":"143,800.00 Lt"}},{"$f":"IFERROR(TREND($L$6:INDEX($L:$L,ROW(),1),$K$6:INDEX($K:$K,ROW(),1),IF(MONTH(tblDuomenys[[#This Row],[DATA]])=12,13,MONTH(tblDuomenys[[#This Row],[DATA]])+1)),\"\")","v":{"v":17951.74418604651,"d":"17,951.74 Lt"}},{"$f":"IFERROR(TREND($M$6:INDEX($M:$M,ROW(),1),$I$6:INDEX($I:$I,ROW(),1),IF(tblDuomenys[[#This Row],[KETVIRTIS]]=4,5,tblDuomenys[[#This Row],[KETVIRTIS]]+1)),\"\")","v":{"v":43258.139534883725,"d":"43,258.14 Lt"}},{"$f":"IFERROR(TREND($N$6:INDEX($N:$N,ROW(),1),$J$6:INDEX($J:$J,ROW(),1),tblDuomenys[[#This Row],[METAI]]+1),\"\")","v":{"v":143800,"d":"143,800.00 Lt"}}]
[null,{"$f":"40853+(365*2)","v":"2013-11-05"},"Dailiųjų menų mokykla",{"v":9100,"d":"9,100.00 Lt"},{"v":9200,"d":"9,200.00 Lt"},{"v":7850,"d":"7,850.00 Lt"},{"$f":"tblDuomenys[[#This Row],[SUMA]]-tblDuomenys[[#This Row],[IŠLAIDOS]]","v":{"v":1250,"d":"1,250.00 Lt"}},{"$f":"DATE(YEAR('Duomenų įvestis'!$B21),MONTH('Duomenų įvestis'!$B21),1)","v":"2013-11-01"},{"$f":"LOOKUP(MONTH('Duomenų įvestis'!$H21),{1,1;2,1;3,1;4,2;5,2;6,2;7,3;8,3;9,3;10,4;11,4;12,4})","v":{"v":4,"d":"Ketvirtis 4"}},{"$f":"YEAR('Duomenų įvestis'!$B21)","v":2013},{"$f":"MONTH([1]!tblData[[#This Row],[DATE]])","v":11},{"$f":"SUMIFS(tblDuomenys[SUMA],tblDuomenys[DATA],\">=\"&EOMONTH(tblDuomenys[[#This Row],[DATA]],-1)+1,tblDuomenys[DATA],\"<=\"&EOMONTH(tblDuomenys[[#This Row],[DATA]],0))","v":{"v":25600,"d":"25,600.00 Lt"}},{"$f":"SUMIFS(tblDuomenys[SUMA],tblDuomenys[DATA],\">=\"&DATE(YEAR(tblDuomenys[[#This Row],[DATA]]),1,1),tblDuomenys[DATA],\"<=\"&DATE(YEAR(tblDuomenys[[#This Row],[DATA]]),12,31),tblDuomenys[KETVIRTIS],tblDuomenys[[#This Row],[KETVIRTIS]])","v":{"v":43900,"d":"43,900.00 Lt"}},{"$f":"SUMIFS(tblDuomenys[SUMA],tblDuomenys[DATA],\">=\"&DATE(YEAR(tblDuomenys[[#This Row],[DATA]]),1,1),tblDuomenys[DATA],\"<=\"&DATE(YEAR(tblDuomenys[[#This Row],[DATA]]),12,31))","v":{"v":143800,"d":"143,800.00 Lt"}},{"$f":"IFERROR(TREND($L$6:INDEX($L:$L,ROW(),1),$K$6:INDEX($K:$K,ROW(),1),IF(MONTH(tblDuomenys[[#This Row],[DATA]])=12,13,MONTH(tblDuomenys[[#This Row],[DATA]])+1)),\"\")","v":{"v":20556.130108423687,"d":"20,556.13 Lt"}},{"$f":"IFERROR(TREND($M$6:INDEX($M:$M,ROW(),1),$I$6:INDEX($I:$I,ROW(),1),IF(tblDuomenys[[#This Row],[KETVIRTIS]]=4,5,tblDuomenys[[#This Row],[KETVIRTIS]]+1)),\"\")","v":{"v":42312.90322580645,"d":"42,312.90 Lt"}},{"$f":"IFERROR(TREND($N$6:INDEX($N:$N,ROW(),1),$J$6:INDEX($J:$J,ROW(),1),tblDuomenys[[#This Row],[METAI]]+1),\"\")","v":{"v":143800,"d":"143,800.00 Lt"}}]
[null,{"$f":"40874+(365*2)","v":"2013-11-26"},"„Trey“ tyrimai",{"v":9000,"d":"9,000.00 Lt"},{"v":10000,"d":"10,000.00 Lt"},{"v":7575,"d":"7,575.00 Lt"},{"$f":"tblDuomenys[[#This Row],[SUMA]]-tblDuomenys[[#This Row],[IŠLAIDOS]]","v":{"v":1425,"d":"1,425.00 Lt"}},{"$f":"DATE(YEAR('Duomenų įvestis'!$B22),MONTH('Duomenų įvestis'!$B22),1)","v":"2013-11-01"},{"$f":"LOOKUP(MONTH('Duomenų įvestis'!$H22),{1,1;2,1;3,1;4,2;5,2;6,2;7,3;8,3;9,3;10,4;11,4;12,4})","v":{"v":4,"d":"Ketvirtis 4"}},{"$f":"YEAR('Duomenų įvestis'!$B22)","v":2013},{"$f":"MONTH([1]!tblData[[#This Row],[DATE]])","v":11},{"$f":"SUMIFS(tblDuomenys[SUMA],tblDuomenys[DATA],\">=\"&EOMONTH(tblDuomenys[[#This Row],[DATA]],-1)+1,tblDuomenys[DATA],\"<=\"&EOMONTH(tblDuomenys[[#This Row],[DATA]],0))","v":{"v":25600,"d":"25,600.00 Lt"}},{"$f":"SUMIFS(tblDuomenys[SUMA],tblDuomenys[DATA],\">=\"&DATE(YEAR(tblDuomenys[[#This Row],[DATA]]),1,1),tblDuomenys[DATA],\"<=\"&DATE(YEAR(tblDuomenys[[#This Row],[DATA]]),12,31),tblDuomenys[KETVIRTIS],tblDuomenys[[#This Row],[KETVIRTIS]])","v":{"v":43900,"d":"43,900.00 Lt"}},{"$f":"SUMIFS(tblDuomenys[SUMA],tblDuomenys[DATA],\">=\"&DATE(YEAR(tblDuomenys[[#This Row],[DATA]]),1,1),tblDuomenys[DATA],\"<=\"&DATE(YEAR(tblDuomenys[[#This Row],[DATA]]),12,31))","v":{"v":143800,"d":"143,800.00 Lt"}},{"$f":"IFERROR(TREND($L$6:INDEX($L:$L,ROW(),1),$K$6:INDEX($K:$K,ROW(),1),IF(MONTH(tblDuomenys[[#This Row],[DATA]])=12,13,MONTH(tblDuomenys[[#This Row],[DATA]])+1)),\"\")","v":{"v":21997.139141742522,"d":"21,997.14 Lt"}},{"$f":"IFERROR(TREND($M$6:INDEX($M:$M,ROW(),1),$I$6:INDEX($I:$I,ROW(),1),IF(tblDuomenys[[#This Row],[KETVIRTIS]]=4,5,tblDuomenys[[#This Row],[KETVIRTIS]]+1)),\"\")","v":{"v":41811.11111111111,"d":"41,811.11 Lt"}},{"$f":"IFERROR(TREND($N$6:INDEX($N:$N,ROW(),1),$J$6:INDEX($J:$J,ROW(),1),tblDuomenys[[#This Row],[METAI]]+1),\"\")","v":{"v":143800,"d":"143,800.00 Lt"}}]
[null,{"$f":"40878+(365*2)","v":"2013-11-30"},"„Trey“ tyrimai",{"v":7500,"d":"7,500.00 Lt"},{"v":8000,"d":"8,000.00 Lt"},{"v":5850,"d":"5,850.00 Lt"},{"$f":"tblDuomenys[[#This Row],[SUMA]]-tblDuomenys[[#This Row],[IŠLAIDOS]]","v":{"v":1650,"d":"1,650.00 Lt"}},{"$f":"DATE(YEAR('Duomenų įvestis'!$B23),MONTH('Duomenų įvestis'!$B23),1)","v":"2013-11-01"},{"$f":"LOOKUP(MONTH('Duomenų įvestis'!$H23),{1,1;2,1;3,1;4,2;5,2;6,2;7,3;8,3;9,3;10,4;11,4;12,4})","v":{"v":4,"d":"Ketvirtis 4"}},{"$f":"YEAR('Duomenų įvestis'!$B23)","v":2013},{"$f":"MONTH([1]!tblData[[#This Row],[DATE]])","v":11},{"$f":"SUMIFS(tblDuomenys[SUMA],tblDuomenys[DATA],\">=\"&EOMONTH(tblDuomenys[[#This Row],[DATA]],-1)+1,tblDuomenys[DATA],\"<=\"&EOMONTH(tblDuomenys[[#This Row],[DATA]],0))","v":{"v":25600,"d":"25,600.00 Lt"}},{"$f":"SUMIFS(tblDuomenys[SUMA],tblDuomenys[DATA],\">=\"&DATE(YEAR(tblDuomenys[[#This Row],[DATA]]),1,1),tblDuomenys[DATA],\"<=\"&DATE(YEAR(tblDuomenys[[#This Row],[DATA]]),12,31),tblDuomenys[KETVIRTIS],tblDuomenys[[#This Row],[KETVIRTIS]])","v":{"v":43900,"d":"43,900.00 Lt"}},{"$f":"SUMIFS(tblDuomenys[SUMA],tblDuomenys[DATA],\">=\"&DATE(YEAR(tblDuomenys[[#This Row],[DATA]]),1,1),tblDuomenys[DATA],\"<=\"&DATE(YEAR(tblDuomenys[[#This Row],[DATA]]),12,31))","v":{"v":143800,"d":"143,800.00 Lt"}},{"$f":"IFERROR(TREND($L$6:INDEX($L:$L,ROW(),1),$K$6:INDEX($K:$K,ROW(),1),IF(MONTH(tblDuomenys[[#This Row],[DATA]])=12,13,MONTH(tblDuomenys[[#This Row],[DATA]])+1)),\"\")","v":{"v":22917.63452317528,"d":"22,917.63 Lt"}},{"$f":"IFERROR(TREND($M$6:INDEX($M:$M,ROW(),1),$I$6:INDEX($I:$I,ROW(),1),IF(tblDuomenys[[#This Row],[KETVIRTIS]]=4,5,tblDuomenys[[#This Row],[KETVIRTIS]]+1)),\"\")","v":{"v":41500,"d":"41,500.00 Lt"}},{"$f":"IFERROR(TREND($N$6:INDEX($N:$N,ROW(),1),$J$6:INDEX($J:$J,ROW(),1),tblDuomenys[[#This Row],[METAI]]+1),\"\")","v":{"v":143800,"d":"143,800.00 Lt"}}]
[null,{"$f":"40889+(365*2)","v":"2013-12-11"},"„Contoso“ medikamentai",{"v":9500,"d":"9,500.00 Lt"},{"v":9200,"d":"9,200.00 Lt"},{"v":8500,"d":"8,500.00 Lt"},{"$f":"tblDuomenys[[#This Row],[SUMA]]-tblDuomenys[[#This Row],[IŠLAIDOS]]","v":{"v":1000,"d":"1,000.00 Lt"}},{"$f":"DATE(YEAR('Duomenų įvestis'!$B24),MONTH('Duomenų įvestis'!$B24),1)","v":"2013-12-01"},{"$f":"LOOKUP(MONTH('Duomenų įvestis'!$H24),{1,1;2,1;3,1;4,2;5,2;6,2;7,3;8,3;9,3;10,4;11,4;12,4})","v":{"v":4,"d":"Ketvirtis 4"}},{"$f":"YEAR('Duomenų įvestis'!$B24)","v":2013},{"$f":"MONTH([1]!tblData[[#This Row],[DATE]])","v":12},{"$f":"SUMIFS(tblDuomenys[SUMA],tblDuomenys[DATA],\">=\"&EOMONTH(tblDuomenys[[#This Row],[DATA]],-1)+1,tblDuomenys[DATA],\"<=\"&EOMONTH(tblDuomenys[[#This Row],[DATA]],0))","v":{"v":9500,"d":"9,500.00 Lt"}},{"$f":"SUMIFS(tblDuomenys[SUMA],tblDuomenys[DATA],\">=\"&DATE(YEAR(tblDuomenys[[#This Row],[DATA]]),1,1),tblDuomenys[DATA],\"<=\"&DATE(YEAR(tblDuomenys[[#This Row],[DATA]]),12,31),tblDuomenys[KETVIRTIS],tblDuomenys[[#This Row],[KETVIRTIS]])","v":{"v":43900,"d":"43,900.00 Lt"}},{"$f":"SUMIFS(tblDuomenys[SUMA],tblDuomenys[DATA],\">=\"&DATE(YEAR(tblDuomenys[[#This Row],[DATA]]),1,1),tblDuomenys[DATA],\"<=\"&DATE(YEAR(tblDuomenys[[#This Row],[DATA]]),12,31))","v":{"v":143800,"d":"143,800.00 Lt"}},{"$f":"IFERROR(TREND($L$6:INDEX($L:$L,ROW(),1),$K$6:INDEX($K:$K,ROW(),1),IF(MONTH(tblDuomenys[[#This Row],[DATA]])=12,13,MONTH(tblDuomenys[[#This Row],[DATA]])+1)),\"\")","v":{"v":20504.31472081218,"d":"20,504.31 Lt"}},{"$f":"IFERROR(TREND($M$6:INDEX($M:$M,ROW(),1),$I$6:INDEX($I:$I,ROW(),1),IF(tblDuomenys[[#This Row],[KETVIRTIS]]=4,5,tblDuomenys[[#This Row],[KETVIRTIS]]+1)),\"\")","v":{"v":41288.23529411765,"d":"41,288.24 Lt"}},{"$f":"IFERROR(TREND($N$6:INDEX($N:$N,ROW(),1),$J$6:INDEX($J:$J,ROW(),1),tblDuomenys[[#This Row],[METAI]]+1),\"\")","v":{"v":143800,"d":"143,800.00 Lt"}}]

{"sheet":"Pardavimo ataskaita","index":1,"n_rows":28,"n_cols":6,"rows_kept":28}
[]
[null,"MĖNESINĖ PARDAVIMO ATASKAITA"]
[]
[]
[null,"METAI","KETVIRTIS","MĖNUO","ĮMONĖ","BENDROJI PARDAVIMO SUMA"]
[null,2013,{"v":2,"d":"Ketvirtis 2"},"2013-04-01","A. AB „Datum“",{"v":6400,"d":"6,400.00 Lt"}]
[{"$nulls":4},"„Contoso“ medikamentai",{"v":8200,"d":"8,200.00 Lt"}]
[{"$nulls":3},"2013-05-01","„Consolidated“ kurjeris",{"v":4400,"d":"4,400.00 Lt"}]
[{"$nulls":4},"UAB „Proseware“",{"v":5400,"d":"5,400.00 Lt"}]
[{"$nulls":4},"Dailiųjų menų mokykla",{"v":5800,"d":"5,800.00 Lt"}]
[{"$nulls":4},"„Trey“ tyrimai",{"v":6200,"d":"6,200.00 Lt"}]
[{"$nulls":3},"2013-06-01","A. AB „Datum“",{"v":6900,"d":"6,900.00 Lt"}]
[{"$nulls":4},"„Contoso“ medikamentai",{"v":7500,"d":"7,500.00 Lt"}]
[null,null,"Ketvirtis 2 Suma",null,null,{"v":50800,"d":"50,800.00 Lt"}]
[null,null,{"v":3,"d":"Ketvirtis 3"},"2013-07-01","„Consolidated“ kurjeris",{"v":8700,"d":"8,700.00 Lt"}]
[{"$nulls":3},"2013-08-01","UAB „Proseware“",{"v":8500,"d":"8,500.00 Lt"}]
[{"$nulls":4},"Dailiųjų menų mokykla",{"v":7900,"d":"7,900.00 Lt"}]
[{"$nulls":3},"2013-09-01","„Consolidated“ kurjeris",{"v":9300,"d":"9,300.00 Lt"}]
[{"$nulls":4},"„Contoso“ medikamentai",{"v":5600,"d":"5,600.00 Lt"}]
[{"$nulls":4},"„Trey“ tyrimai",{"v":9100,"d":"9,100.00 Lt"}]
[null,null,"Ketvirtis 3 Suma",null,null,{"v":49100,"d":"49,100.00 Lt"}]
[null,null,{"v":4,"d":"Ketvirtis 4"},"2013-10-01","UAB „Proseware“",{"v":8800,"d":"8,800.00 Lt"}]
[{"$nulls":3},"2013-11-01","Dailiųjų menų mokykla",{"v":9100,"d":"9,100.00 Lt"}]
[{"$nulls":4},"„Trey“ tyrimai",{"v":16500,"d":"16,500.00 Lt"}]
[{"$nulls":3},"2013-12-01","„Contoso“ medikamentai",{"v":9500,"d":"9,500.00 Lt"}]
[null,null,"Ketvirtis 4 Suma",null,null,{"v":43900,"d":"43,900.00 Lt"}]
[null," 2013 Suma",{"$nulls":3},{"v":143800,"d":"143,800.00 Lt"}]
[null,"Bendroji suma",{"$nulls":3},{"v":143800,"d":"143,800.00 Lt"}]

{"sheet":"Pardavimo prognozė","index":2,"n_rows":43,"n_cols":10,"rows_kept":43}
[]
[null,"MĖNESINĖ PARDAVIMO PROGNOZĖ"]
[null,{"$f":"\"ŠIANDIENOS DATA: \"&UPPER(TEXT(TODAY(),\"yyyy.mm.dd\"))","v":"ŠIANDIENOS DATA: 2012.09.25"},null,{"$f":"--TRIM(RIGHT(B3,LEN(B3)-FIND(\":\",B3)))","v":"2012-09-25"}]
[]
[null,"ŠĮ MĖNESĮ","FAKTIŠKAI","PLANAS","NUOKRYPIS","%","FAKTIŠKAI NUO METŲ PRADŽIOS","PLANAS NUO METŲ PRADŽIOS","NUOKRYPIS NUO METŲ PRADŽIOS","% nuo metų pradžios"]
[null,"Kiekis",{"$f":"COUNTIF('Duomenų įvestis'!$B$6:$B$24,\">=\"&DATE(fYear,MONTH(fDate),1))-COUNTIF('Duomenų įvestis'!$B$6:$B$24,\">\"&EOMONTH(fDate,0))","v":0},{"$nulls":3},{"$f":"COUNTIF(tblDuomenys[DATA],\"<=\"&EOMONTH(fDate,0))","v":0}]
[null,"Pardavimas",{"$f":"SUMIF(tblDuomenys[DATA],\">=\"&DATE(fYear,MONTH(fDate),1),tblDuomenys[SUMA])-SUMIF(tblDuomenys[DATA],\">\"&EOMONTH(fDate,0),tblDuomenys[SUMA])","v":{"v":0,"d":"0.00 Lt"}},{"$f":"SUMIF('Duomenų įvestis'!$B$6:$B$24,\">=\"&DATE(fYear,MONTH(fDate),1),'Duomenų įvestis'!$E$6:$E$24)-SUMIF('Duomenų įvestis'!$B$6:$B$24,\">\"&EOMONTH(fDate,0),'Duomenų įvestis'!$E$6:$E$24)","v":{"v":0,"d":"0.00 Lt"}},{"$f":"D7-C7","v":{"v":0,"d":"0.00 Lt"}},{"$f":"IFERROR(D7/C7,\"-\")","v":"-"},{"$f":"SUMIF(tblDuomenys[DATA],\"<=\"&EOMONTH(fDate,0),tblDuomenys[SUMA])","v":{"v":0,"d":"0.00 Lt"}},{"$f":"SUMIF(tblDuomenys[DATA],\"<=\"&EOMONTH(fDate,0),tblDuomenys[SUPLANUOTA])","v":{"v":0,"d":"0.00 Lt"}},{"$f":"H7-G7","v":{"v":0,"d":"0.00 Lt"}},{"$f":"IFERROR(H7/G7,\"\")","v":""}]
[null,"Pajamos",{"$f":"(SUMIF(tblDuomenys[DATA],\">=\"&DATE(fYear,MONTH(fDate),1),tblDuomenys[SUMA])-SUMIF(tblDuomenys[DATA],\">\"&EOMONTH(fDate,0),tblDuomenys[SUMA]))-(SUMIF(tblDuomenys[DATA],\">=\"&DATE(fYear,MONTH(fDate),1),tblDuomenys[IŠLAIDOS])-SUMIF(tblDuomenys[DATA],\">\"&EOMONTH(fDate,0),tblDuomenys[IŠLAIDOS]))","v":{"v":0,"d":"0.00 Lt"}},{"$f":"(SUMIF('Duomenų įvestis'!$B$6:$B$24,\">=\"&DATE(fYear,MONTH(fDate),1),'Duomenų įvestis'!$E$6:$E$24)-SUMIF('Duomenų įvestis'!$B$6:$B$24,\">\"&EOMONTH(fDate,0),'Duomenų įvestis'!$E$6:$E$24))-(SUMIF('Duomenų įvestis'!$B$6:$B$24,\">=\"&DATE(fYear,MONTH(fDate),1),'Duomenų įvestis'!$F$6:$F$24)-SUMIF('Duomenų įvestis'!$B$6:$B$24,\">\"&EOMONTH(fDate,0),'Duomenų įvestis'!$F$6:$F$24))","v":{"v":0,"d":"0.00 Lt"}},{"$f":"D8-C8","v":{"v":0,"d":"0.00 Lt"}},{"$f":"IFERROR(D8/C8,\"-\")","v":"-"},{"$f":"SUMIF('Duomenų įvestis'!$B$6:$B$24,\"<=\"&EOMONTH(fDate,0),'Duomenų įvestis'!$F$6:$F$24)","v":{"v":0,"d":"0.00 Lt"}},{"$f":"SUMIF(tblDuomenys[DATA],\"<=\"&EOMONTH(fDate,0),tblDuomenys[IŠLAIDOS])","v":{"v":0,"d":"0.00 Lt"}},{"$f":"H8-G8","v":{"v":0,"d":"0.00 Lt"}},{"$f":"IFERROR(H8/G8,\"\")","v":""}]
[null,"Marža",{"$f":"IFERROR(C8/C7,\"-\")","v":"-"},{"$f":"IFERROR(D8/D7,\"-\")","v":"-"},null,{"$f":"IFERROR(F8/F7,\"-\")","v":"-"},{"$f":"IFERROR(G8/G7,\"\")","v":""},{"$f":"IFERROR(H8/H7,\"\")","v":""},null,{"$f":"IFERROR(J8/J7,\"\")","v":""}]
[null,"Užsakymų skaičius",{"$f":"COUNTIF(tblDuomenys[DATA],\">=\"&DATE(fYear,MONTH(fDate),1))-COUNTIF(tblDuomenys[DATA],\">\"&EOMONTH(fDate,0))","v":0},{"$nulls":3},{"$f":"COUNTIF(tblDuomenys[DATA],\">\"&EOMONTH(fDate,0))","v":19}]
[null,"Vidutinė užsakymo vertė",{"$f":"IFERROR(C7/C10,\"-\")","v":"-"},{"$nulls":3},{"$f":"IFERROR(G7/G10,\"-\")","v":{"v":0,"d":"0.00 Lt"}}]
[]
[null,"PROGNOZĖ",null,"KITAS MĖNUO",null,"KITAS KETVIRTIS",null,null,"KITI METAI"]
[null,"Pardavimas",null,{"$f":"TREND(tblDuomenys[MĖNUO],tblDuomenys[MĖNESIO NUMERI (SLĖPTI)],IF(MONTH(fDate)=12,13,MONTH(fDate)+1))","v":{"v":41548.26776649747,"d":"41,548.27 Lt"}},null,{"$f":"TREND(tblDuomenys[KETVIRTIS],tblDuomenys[MĖNESIO NUMERI (SLĖPTI)],IF(MONTH(fDate)=12,13,MONTH(fDate)+1))","v":{"v":3.5634517766497456,"d":"3.56 Lt"}},null,null,{"$f":"TREND(tblDuomenys[[METŲ ]],tblDuomenys[MĖNESIO NUMERI (SLĖPTI)],IF(MONTH(fDate)=12,13,MONTH(fDate)+1))","v":{"v":143800,"d":"143,800.00 Lt"}}]
[]
[null,"PARDAVIMO RETROSPEKTYVA"]
{"$rows_empty":13}
[null,"MĖNESIO PROGNOZĖ",{"$nulls":3},"KETVIRČIO PROGNOZĖ"]
{"$rows_empty":7}
[null,"METŲ PROGNOZĖ",{"$nulls":3},"PAJAMŲ SRAUTAS"]
[]
[]
[]
[]
[{"$nulls":9}," "]