{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Andmesisestus","Müügiaruanne","Müügiprognoos"],"not_rendered":{"charts":5,"defined_names":7,"pivot_tables":1},"read":"whole","date_system":"1900"}

{"sheet":"Andmesisestus","index":0,"n_rows":24,"n_cols":17,"rows_kept":24}
[{"$nulls":9},{"$f":"365*2","v":730}]
[null,"KUUS ANDMESISESTUS"]
[{"$nulls":11},"KOGUSUMMAD",null,null,"PROGNOOS"]
[]
[null,"KUUPÄEV","ETTEVÕTE","SUMMA","PLAANITUD","KULU","TULU","KUU","KVARTAL","AASTA","KUU NR (PEIDA)","KUU ","KVARTAL ","AASTAS ","KUU  ","KVARTAL  ","AASTA  "]
[null,{"$f":"40657+(365*2)","v":"2013-04-23"},"A. Datum Corporation",{"v":6400,"d":"6,400.00 €"},{"v":6200,"d":"6,200.00 €"},{"v":4450,"d":"4,450.00 €"},{"$f":"tblAndmed[[#This Row],[SUMMA]]-tblAndmed[KULU]","v":{"v":1950,"d":"1,950.00 €"}},{"$f":"DATE(YEAR(Andmesisestus!$B6),MONTH(Andmesisestus!$B6),1)","v":"2013-04-01"},{"$f":"LOOKUP(MONTH(Andmesisestus!$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":"Kvartal 2"}},{"$f":"YEAR(Andmesisestus!$B6)","v":2013},{"$f":"MONTH(tblAndmed[[#This Row],[KUUPÄEV]])","v":4},{"$f":"SUMIFS(tblAndmed[SUMMA],tblAndmed[KUUPÄEV],\">=\"&EOMONTH(tblAndmed[[#This Row],[KUUPÄEV]],-1)+1,tblAndmed[KUUPÄEV],\"<=\"&EOMONTH(tblAndmed[[#This Row],[KUUPÄEV]],0))","v":{"v":14600,"d":"14,600.00 €"}},{"$f":"SUMIFS(tblAndmed[SUMMA],tblAndmed[KUUPÄEV],\">=\"&DATE(YEAR(tblAndmed[KUUPÄEV]),1,1),tblAndmed[KUUPÄEV],\"<=\"&DATE(YEAR(tblAndmed[KUUPÄEV]),12,31),tblAndmed[KVARTAL],tblAndmed[KVARTAL])","v":{"v":50800,"d":"50,800.00 €"}},{"$f":"SUMIFS(tblAndmed[SUMMA],tblAndmed[KUUPÄEV],\">=\"&DATE(YEAR(tblAndmed[KUUPÄEV]),1,1),tblAndmed[KUUPÄEV],\"<=\"&DATE(YEAR(tblAndmed[KUUPÄEV]),12,31))","v":{"v":143800,"d":"143,800.00 €"}},{"$f":"IFERROR(TREND($L$6:INDEX($L:$L,ROW(),1),$K$6:INDEX($K:$K,ROW(),1),IF(MONTH(tblAndmed[[#This Row],[KUUPÄEV]])=12,13,MONTH(tblAndmed[[#This Row],[KUUPÄEV]])+1)),\"\")","v":{"v":14600,"d":"14,600.00 €"}},{"$f":"IFERROR(TREND($M$6:INDEX($M:$M,ROW(),1),$I$6:INDEX($I:$I,ROW(),1),IF(tblAndmed[KVARTAL]=4,5,tblAndmed[KVARTAL]+1)),\"\")","v":{"v":50800,"d":"50,800.00 €"}},{"$f":"IFERROR(TREND($N$6:INDEX($N:$N,ROW(),1),$J$6:INDEX($J:$J,ROW(),1),tblAndmed[AASTA]+1),\"\")","v":{"v":143800,"d":"143,800.00 €"}}]
[null,{"$f":"40659+(365*2)","v":"2013-04-25"},"Contoso Pharmaceuticals",{"v":8200,"d":"8,200.00 €"},{"v":8000,"d":"8,000.00 €"},{"v":6400,"d":"6,400.00 €"},{"$f":"tblAndmed[[#This Row],[SUMMA]]-tblAndmed[KULU]","v":{"v":1800,"d":"1,800.00 €"}},{"$f":"DATE(YEAR(Andmesisestus!$B7),MONTH(Andmesisestus!$B7),1)","v":"2013-04-01"},{"$f":"LOOKUP(MONTH(Andmesisestus!$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":"Kvartal 2"}},{"$f":"YEAR(Andmesisestus!$B7)","v":2013},{"$f":"MONTH(tblAndmed[[#This Row],[KUUPÄEV]])","v":4},{"$f":"SUMIFS(tblAndmed[SUMMA],tblAndmed[KUUPÄEV],\">=\"&EOMONTH(tblAndmed[[#This Row],[KUUPÄEV]],-1)+1,tblAndmed[KUUPÄEV],\"<=\"&EOMONTH(tblAndmed[[#This Row],[KUUPÄEV]],0))","v":{"v":14600,"d":"14,600.00 €"}},{"$f":"SUMIFS(tblAndmed[SUMMA],tblAndmed[KUUPÄEV],\">=\"&DATE(YEAR(tblAndmed[KUUPÄEV]),1,1),tblAndmed[KUUPÄEV],\"<=\"&DATE(YEAR(tblAndmed[KUUPÄEV]),12,31),tblAndmed[KVARTAL],tblAndmed[KVARTAL])","v":{"v":50800,"d":"50,800.00 €"}},{"$f":"SUMIFS(tblAndmed[SUMMA],tblAndmed[KUUPÄEV],\">=\"&DATE(YEAR(tblAndmed[KUUPÄEV]),1,1),tblAndmed[KUUPÄEV],\"<=\"&DATE(YEAR(tblAndmed[KUUPÄEV]),12,31))","v":{"v":143800,"d":"143,800.00 €"}},{"$f":"IFERROR(TREND($L$6:INDEX($L:$L,ROW(),1),$K$6:INDEX($K:$K,ROW(),1),IF(MONTH(tblAndmed[[#This Row],[KUUPÄEV]])=12,13,MONTH(tblAndmed[[#This Row],[KUUPÄEV]])+1)),\"\")","v":{"v":14600,"d":"14,600.00 €"}},{"$f":"IFERROR(TREND($M$6:INDEX($M:$M,ROW(),1),$I$6:INDEX($I:$I,ROW(),1),IF(tblAndmed[KVARTAL]=4,5,tblAndmed[KVARTAL]+1)),\"\")","v":{"v":50800,"d":"50,800.00 €"}},{"$f":"IFERROR(TREND($N$6:INDEX($N:$N,ROW(),1),$J$6:INDEX($J:$J,ROW(),1),tblAndmed[AASTA]+1),\"\")","v":{"v":143800,"d":"143,800.00 €"}}]
[null,{"$f":"40671+(365*2)","v":"2013-05-07"},"Consolidated Messenger",{"v":4400,"d":"4,400.00 €"},{"v":4200,"d":"4,200.00 €"},{"v":2600,"d":"2,600.00 €"},{"$f":"tblAndmed[[#This Row],[SUMMA]]-tblAndmed[KULU]","v":{"v":1800,"d":"1,800.00 €"}},{"$f":"DATE(YEAR(Andmesisestus!$B8),MONTH(Andmesisestus!$B8),1)","v":"2013-05-01"},{"$f":"LOOKUP(MONTH(Andmesisestus!$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":"Kvartal 2"}},{"$f":"YEAR(Andmesisestus!$B8)","v":2013},{"$f":"MONTH(tblAndmed[[#This Row],[KUUPÄEV]])","v":5},{"$f":"SUMIFS(tblAndmed[SUMMA],tblAndmed[KUUPÄEV],\">=\"&EOMONTH(tblAndmed[[#This Row],[KUUPÄEV]],-1)+1,tblAndmed[KUUPÄEV],\"<=\"&EOMONTH(tblAndmed[[#This Row],[KUUPÄEV]],0))","v":{"v":21800,"d":"21,800.00 €"}},{"$f":"SUMIFS(tblAndmed[SUMMA],tblAndmed[KUUPÄEV],\">=\"&DATE(YEAR(tblAndmed[KUUPÄEV]),1,1),tblAndmed[KUUPÄEV],\"<=\"&DATE(YEAR(tblAndmed[KUUPÄEV]),12,31),tblAndmed[KVARTAL],tblAndmed[KVARTAL])","v":{"v":50800,"d":"50,800.00 €"}},{"$f":"SUMIFS(tblAndmed[SUMMA],tblAndmed[KUUPÄEV],\">=\"&DATE(YEAR(tblAndmed[KUUPÄEV]),1,1),tblAndmed[KUUPÄEV],\"<=\"&DATE(YEAR(tblAndmed[KUUPÄEV]),12,31))","v":{"v":143800,"d":"143,800.00 €"}},{"$f":"IFERROR(TREND($L$6:INDEX($L:$L,ROW(),1),$K$6:INDEX($K:$K,ROW(),1),IF(MONTH(tblAndmed[[#This Row],[KUUPÄEV]])=12,13,MONTH(tblAndmed[[#This Row],[KUUPÄEV]])+1)),\"\")","v":{"v":28999.999999999996,"d":"29,000.00 €"}},{"$f":"IFERROR(TREND($M$6:INDEX($M:$M,ROW(),1),$I$6:INDEX($I:$I,ROW(),1),IF(tblAndmed[KVARTAL]=4,5,tblAndmed[KVARTAL]+1)),\"\")","v":{"v":50800,"d":"50,800.00 €"}},{"$f":"IFERROR(TREND($N$6:INDEX($N:$N,ROW(),1),$J$6:INDEX($J:$J,ROW(),1),tblAndmed[AASTA]+1),\"\")","v":{"v":143800,"d":"143,800.00 €"}}]
[null,{"$f":"40678+(365*2)","v":"2013-05-14"},"Proseware, Inc.",{"v":5400,"d":"5,400.00 €"},{"v":5500,"d":"5,500.00 €"},{"v":4500,"d":"4,500.00 €"},{"$f":"tblAndmed[[#This Row],[SUMMA]]-tblAndmed[KULU]","v":{"v":900,"d":"900.00 €"}},{"$f":"DATE(YEAR(Andmesisestus!$B9),MONTH(Andmesisestus!$B9),1)","v":"2013-05-01"},{"$f":"LOOKUP(MONTH(Andmesisestus!$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":"Kvartal 2"}},{"$f":"YEAR(Andmesisestus!$B9)","v":2013},{"$f":"MONTH(tblAndmed[[#This Row],[KUUPÄEV]])","v":5},{"$f":"SUMIFS(tblAndmed[SUMMA],tblAndmed[KUUPÄEV],\">=\"&EOMONTH(tblAndmed[[#This Row],[KUUPÄEV]],-1)+1,tblAndmed[KUUPÄEV],\"<=\"&EOMONTH(tblAndmed[[#This Row],[KUUPÄEV]],0))","v":{"v":21800,"d":"21,800.00 €"}},{"$f":"SUMIFS(tblAndmed[SUMMA],tblAndmed[KUUPÄEV],\">=\"&DATE(YEAR(tblAndmed[KUUPÄEV]),1,1),tblAndmed[KUUPÄEV],\"<=\"&DATE(YEAR(tblAndmed[KUUPÄEV]),12,31),tblAndmed[KVARTAL],tblAndmed[KVARTAL])","v":{"v":50800,"d":"50,800.00 €"}},{"$f":"SUMIFS(tblAndmed[SUMMA],tblAndmed[KUUPÄEV],\">=\"&DATE(YEAR(tblAndmed[KUUPÄEV]),1,1),tblAndmed[KUUPÄEV],\"<=\"&DATE(YEAR(tblAndmed[KUUPÄEV]),12,31))","v":{"v":143800,"d":"143,800.00 €"}},{"$f":"IFERROR(TREND($L$6:INDEX($L:$L,ROW(),1),$K$6:INDEX($K:$K,ROW(),1),IF(MONTH(tblAndmed[[#This Row],[KUUPÄEV]])=12,13,MONTH(tblAndmed[[#This Row],[KUUPÄEV]])+1)),\"\")","v":{"v":29000,"d":"29,000.00 €"}},{"$f":"IFERROR(TREND($M$6:INDEX($M:$M,ROW(),1),$I$6:INDEX($I:$I,ROW(),1),IF(tblAndmed[KVARTAL]=4,5,tblAndmed[KVARTAL]+1)),\"\")","v":{"v":50800,"d":"50,800.00 €"}},{"$f":"IFERROR(TREND($N$6:INDEX($N:$N,ROW(),1),$J$6:INDEX($J:$J,ROW(),1),tblAndmed[AASTA]+1),\"\")","v":{"v":143800,"d":"143,800.00 €"}}]
[null,{"$f":"40678+(365*2)","v":"2013-05-14"},"School of Fine Art",{"v":5800,"d":"5,800.00 €"},{"v":6000,"d":"6,000.00 €"},{"v":4500,"d":"4,500.00 €"},{"$f":"tblAndmed[[#This Row],[SUMMA]]-tblAndmed[KULU]","v":{"v":1300,"d":"1,300.00 €"}},{"$f":"DATE(YEAR(Andmesisestus!$B10),MONTH(Andmesisestus!$B10),1)","v":"2013-05-01"},{"$f":"LOOKUP(MONTH(Andmesisestus!$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":"Kvartal 2"}},{"$f":"YEAR(Andmesisestus!$B10)","v":2013},{"$f":"MONTH(tblAndmed[[#This Row],[KUUPÄEV]])","v":5},{"$f":"SUMIFS(tblAndmed[SUMMA],tblAndmed[KUUPÄEV],\">=\"&EOMONTH(tblAndmed[[#This Row],[KUUPÄEV]],-1)+1,tblAndmed[KUUPÄEV],\"<=\"&EOMONTH(tblAndmed[[#This Row],[KUUPÄEV]],0))","v":{"v":21800,"d":"21,800.00 €"}},{"$f":"SUMIFS(tblAndmed[SUMMA],tblAndmed[KUUPÄEV],\">=\"&DATE(YEAR(tblAndmed[KUUPÄEV]),1,1),tblAndmed[KUUPÄEV],\"<=\"&DATE(YEAR(tblAndmed[KUUPÄEV]),12,31),tblAndmed[KVARTAL],tblAndmed[KVARTAL])","v":{"v":50800,"d":"50,800.00 €"}},{"$f":"SUMIFS(tblAndmed[SUMMA],tblAndmed[KUUPÄEV],\">=\"&DATE(YEAR(tblAndmed[KUUPÄEV]),1,1),tblAndmed[KUUPÄEV],\"<=\"&DATE(YEAR(tblAndmed[KUUPÄEV]),12,31))","v":{"v":143800,"d":"143,800.00 €"}},{"$f":"IFERROR(TREND($L$6:INDEX($L:$L,ROW(),1),$K$6:INDEX($K:$K,ROW(),1),IF(MONTH(tblAndmed[[#This Row],[KUUPÄEV]])=12,13,MONTH(tblAndmed[[#This Row],[KUUPÄEV]])+1)),\"\")","v":{"v":29000,"d":"29,000.00 €"}},{"$f":"IFERROR(TREND($M$6:INDEX($M:$M,ROW(),1),$I$6:INDEX($I:$I,ROW(),1),IF(tblAndmed[KVARTAL]=4,5,tblAndmed[KVARTAL]+1)),\"\")","v":{"v":50800,"d":"50,800.00 €"}},{"$f":"IFERROR(TREND($N$6:INDEX($N:$N,ROW(),1),$J$6:INDEX($J:$J,ROW(),1),tblAndmed[AASTA]+1),\"\")","v":{"v":143800,"d":"143,800.00 €"}}]
[null,{"$f":"40693+(365*2)","v":"2013-05-29"},"Trey Research",{"v":6200,"d":"6,200.00 €"},{"v":6000,"d":"6,000.00 €"},{"v":4500,"d":"4,500.00 €"},{"$f":"tblAndmed[[#This Row],[SUMMA]]-tblAndmed[KULU]","v":{"v":1700,"d":"1,700.00 €"}},{"$f":"DATE(YEAR(Andmesisestus!$B11),MONTH(Andmesisestus!$B11),1)","v":"2013-05-01"},{"$f":"LOOKUP(MONTH(Andmesisestus!$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":"Kvartal 2"}},{"$f":"YEAR(Andmesisestus!$B11)","v":2013},{"$f":"MONTH(tblAndmed[[#This Row],[KUUPÄEV]])","v":5},{"$f":"SUMIFS(tblAndmed[SUMMA],tblAndmed[KUUPÄEV],\">=\"&EOMONTH(tblAndmed[[#This Row],[KUUPÄEV]],-1)+1,tblAndmed[KUUPÄEV],\"<=\"&EOMONTH(tblAndmed[[#This Row],[KUUPÄEV]],0))","v":{"v":21800,"d":"21,800.00 €"}},{"$f":"SUMIFS(tblAndmed[SUMMA],tblAndmed[KUUPÄEV],\">=\"&DATE(YEAR(tblAndmed[KUUPÄEV]),1,1),tblAndmed[KUUPÄEV],\"<=\"&DATE(YEAR(tblAndmed[KUUPÄEV]),12,31),tblAndmed[KVARTAL],tblAndmed[KVARTAL])","v":{"v":50800,"d":"50,800.00 €"}},{"$f":"SUMIFS(tblAndmed[SUMMA],tblAndmed[KUUPÄEV],\">=\"&DATE(YEAR(tblAndmed[KUUPÄEV]),1,1),tblAndmed[KUUPÄEV],\"<=\"&DATE(YEAR(tblAndmed[KUUPÄEV]),12,31))","v":{"v":143800,"d":"143,800.00 €"}},{"$f":"IFERROR(TREND($L$6:INDEX($L:$L,ROW(),1),$K$6:INDEX($K:$K,ROW(),1),IF(MONTH(tblAndmed[[#This Row],[KUUPÄEV]])=12,13,MONTH(tblAndmed[[#This Row],[KUUPÄEV]])+1)),\"\")","v":{"v":29000,"d":"29,000.00 €"}},{"$f":"IFERROR(TREND($M$6:INDEX($M:$M,ROW(),1),$I$6:INDEX($I:$I,ROW(),1),IF(tblAndmed[KVARTAL]=4,5,tblAndmed[KVARTAL]+1)),\"\")","v":{"v":50800,"d":"50,800.00 €"}},{"$f":"IFERROR(TREND($N$6:INDEX($N:$N,ROW(),1),$J$6:INDEX($J:$J,ROW(),1),tblAndmed[AASTA]+1),\"\")","v":{"v":143800,"d":"143,800.00 €"}}]
[null,{"$f":"40705+(365*2)","v":"2013-06-10"},"A. Datum Corporation",{"v":6900,"d":"6,900.00 €"},{"v":7500,"d":"7,500.00 €"},{"v":5400,"d":"5,400.00 €"},{"$f":"tblAndmed[[#This Row],[SUMMA]]-tblAndmed[KULU]","v":{"v":1500,"d":"1,500.00 €"}},{"$f":"DATE(YEAR(Andmesisestus!$B12),MONTH(Andmesisestus!$B12),1)","v":"2013-06-01"},{"$f":"LOOKUP(MONTH(Andmesisestus!$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":"Kvartal 2"}},{"$f":"YEAR(Andmesisestus!$B12)","v":2013},{"$f":"MONTH(tblAndmed[[#This Row],[KUUPÄEV]])","v":6},{"$f":"SUMIFS(tblAndmed[SUMMA],tblAndmed[KUUPÄEV],\">=\"&EOMONTH(tblAndmed[[#This Row],[KUUPÄEV]],-1)+1,tblAndmed[KUUPÄEV],\"<=\"&EOMONTH(tblAndmed[[#This Row],[KUUPÄEV]],0))","v":{"v":14400,"d":"14,400.00 €"}},{"$f":"SUMIFS(tblAndmed[SUMMA],tblAndmed[KUUPÄEV],\">=\"&DATE(YEAR(tblAndmed[KUUPÄEV]),1,1),tblAndmed[KUUPÄEV],\"<=\"&DATE(YEAR(tblAndmed[KUUPÄEV]),12,31),tblAndmed[KVARTAL],tblAndmed[KVARTAL])","v":{"v":50800,"d":"50,800.00 €"}},{"$f":"SUMIFS(tblAndmed[SUMMA],tblAndmed[KUUPÄEV],\">=\"&DATE(YEAR(tblAndmed[KUUPÄEV]),1,1),tblAndmed[KUUPÄEV],\"<=\"&DATE(YEAR(tblAndmed[KUUPÄEV]),12,31))","v":{"v":143800,"d":"143,800.00 €"}},{"$f":"IFERROR(TREND($L$6:INDEX($L:$L,ROW(),1),$K$6:INDEX($K:$K,ROW(),1),IF(MONTH(tblAndmed[[#This Row],[KUUPÄEV]])=12,13,MONTH(tblAndmed[[#This Row],[KUUPÄEV]])+1)),\"\")","v":{"v":21600.000000000004,"d":"21,600.00 €"}},{"$f":"IFERROR(TREND($M$6:INDEX($M:$M,ROW(),1),$I$6:INDEX($I:$I,ROW(),1),IF(tblAndmed[KVARTAL]=4,5,tblAndmed[KVARTAL]+1)),\"\")","v":{"v":50800,"d":"50,800.00 €"}},{"$f":"IFERROR(TREND($N$6:INDEX($N:$N,ROW(),1),$J$6:INDEX($J:$J,ROW(),1),tblAndmed[AASTA]+1),\"\")","v":{"v":143800,"d":"143,800.00 €"}}]
[null,{"$f":"40716+(365*2)","v":"2013-06-21"},"Contoso Pharmaceuticals",{"v":7500,"d":"7,500.00 €"},{"v":7200,"d":"7,200.00 €"},{"v":6500,"d":"6,500.00 €"},{"$f":"tblAndmed[[#This Row],[SUMMA]]-tblAndmed[KULU]","v":{"v":1000,"d":"1,000.00 €"}},{"$f":"DATE(YEAR(Andmesisestus!$B13),MONTH(Andmesisestus!$B13),1)","v":"2013-06-01"},{"$f":"LOOKUP(MONTH(Andmesisestus!$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":"Kvartal 2"}},{"$f":"YEAR(Andmesisestus!$B13)","v":2013},{"$f":"MONTH(tblAndmed[[#This Row],[KUUPÄEV]])","v":6},{"$f":"SUMIFS(tblAndmed[SUMMA],tblAndmed[KUUPÄEV],\">=\"&EOMONTH(tblAndmed[[#This Row],[KUUPÄEV]],-1)+1,tblAndmed[KUUPÄEV],\"<=\"&EOMONTH(tblAndmed[[#This Row],[KUUPÄEV]],0))","v":{"v":14400,"d":"14,400.00 €"}},{"$f":"SUMIFS(tblAndmed[SUMMA],tblAndmed[KUUPÄEV],\">=\"&DATE(YEAR(tblAndmed[KUUPÄEV]),1,1),tblAndmed[KUUPÄEV],\"<=\"&DATE(YEAR(tblAndmed[KUUPÄEV]),12,31),tblAndmed[KVARTAL],tblAndmed[KVARTAL])","v":{"v":50800,"d":"50,800.00 €"}},{"$f":"SUMIFS(tblAndmed[SUMMA],tblAndmed[KUUPÄEV],\">=\"&DATE(YEAR(tblAndmed[KUUPÄEV]),1,1),tblAndmed[KUUPÄEV],\"<=\"&DATE(YEAR(tblAndmed[KUUPÄEV]),12,31))","v":{"v":143800,"d":"143,800.00 €"}},{"$f":"IFERROR(TREND($L$6:INDEX($L:$L,ROW(),1),$K$6:INDEX($K:$K,ROW(),1),IF(MONTH(tblAndmed[[#This Row],[KUUPÄEV]])=12,13,MONTH(tblAndmed[[#This Row],[KUUPÄEV]])+1)),\"\")","v":{"v":17950,"d":"17,950.00 €"}},{"$f":"IFERROR(TREND($M$6:INDEX($M:$M,ROW(),1),$I$6:INDEX($I:$I,ROW(),1),IF(tblAndmed[KVARTAL]=4,5,tblAndmed[KVARTAL]+1)),\"\")","v":{"v":50800,"d":"50,800.00 €"}},{"$f":"IFERROR(TREND($N$6:INDEX($N:$N,ROW(),1),$J$6:INDEX($J:$J,ROW(),1),tblAndmed[AASTA]+1),\"\")","v":{"v":143800,"d":"143,800.00 €"}}]
[null,{"$f":"40731+(365*2)","v":"2013-07-06"},"Consolidated Messenger",{"v":8700,"d":"8,700.00 €"},{"v":8500,"d":"8,500.00 €"},{"v":7250,"d":"7,250.00 €"},{"$f":"tblAndmed[[#This Row],[SUMMA]]-tblAndmed[KULU]","v":{"v":1450,"d":"1,450.00 €"}},{"$f":"DATE(YEAR(Andmesisestus!$B14),MONTH(Andmesisestus!$B14),1)","v":"2013-07-01"},{"$f":"LOOKUP(MONTH(Andmesisestus!$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":"Kvartal 3"}},{"$f":"YEAR(Andmesisestus!$B14)","v":2013},{"$f":"MONTH(tblAndmed[[#This Row],[KUUPÄEV]])","v":7},{"$f":"SUMIFS(tblAndmed[SUMMA],tblAndmed[KUUPÄEV],\">=\"&EOMONTH(tblAndmed[[#This Row],[KUUPÄEV]],-1)+1,tblAndmed[KUUPÄEV],\"<=\"&EOMONTH(tblAndmed[[#This Row],[KUUPÄEV]],0))","v":{"v":8700,"d":"8,700.00 €"}},{"$f":"SUMIFS(tblAndmed[SUMMA],tblAndmed[KUUPÄEV],\">=\"&DATE(YEAR(tblAndmed[KUUPÄEV]),1,1),tblAndmed[KUUPÄEV],\"<=\"&DATE(YEAR(tblAndmed[KUUPÄEV]),12,31),tblAndmed[KVARTAL],tblAndmed[KVARTAL])","v":{"v":49100,"d":"49,100.00 €"}},{"$f":"SUMIFS(tblAndmed[SUMMA],tblAndmed[KUUPÄEV],\">=\"&DATE(YEAR(tblAndmed[KUUPÄEV]),1,1),tblAndmed[KUUPÄEV],\"<=\"&DATE(YEAR(tblAndmed[KUUPÄEV]),12,31))","v":{"v":143800,"d":"143,800.00 €"}},{"$f":"IFERROR(TREND($L$6:INDEX($L:$L,ROW(),1),$K$6:INDEX($K:$K,ROW(),1),IF(MONTH(tblAndmed[[#This Row],[KUUPÄEV]])=12,13,MONTH(tblAndmed[[#This Row],[KUUPÄEV]])+1)),\"\")","v":{"v":10776.470588235294,"d":"10,776.47 €"}},{"$f":"IFERROR(TREND($M$6:INDEX($M:$M,ROW(),1),$I$6:INDEX($I:$I,ROW(),1),IF(tblAndmed[KVARTAL]=4,5,tblAndmed[KVARTAL]+1)),\"\")","v":{"v":47400,"d":"47,400.00 €"}},{"$f":"IFERROR(TREND($N$6:INDEX($N:$N,ROW(),1),$J$6:INDEX($J:$J,ROW(),1),tblAndmed[AASTA]+1),\"\")","v":{"v":143800,"d":"143,800.00 €"}}]
[null,{"$f":"40761+(365*2)","v":"2013-08-05"},"Proseware, Inc.",{"v":8500,"d":"8,500.00 €"},{"v":8300,"d":"8,300.00 €"},{"v":7100,"d":"7,100.00 €"},{"$f":"tblAndmed[[#This Row],[SUMMA]]-tblAndmed[KULU]","v":{"v":1400,"d":"1,400.00 €"}},{"$f":"DATE(YEAR(Andmesisestus!$B15),MONTH(Andmesisestus!$B15),1)","v":"2013-08-01"},{"$f":"LOOKUP(MONTH(Andmesisestus!$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":"Kvartal 3"}},{"$f":"YEAR(Andmesisestus!$B15)","v":2013},{"$f":"MONTH(tblAndmed[[#This Row],[KUUPÄEV]])","v":8},{"$f":"SUMIFS(tblAndmed[SUMMA],tblAndmed[KUUPÄEV],\">=\"&EOMONTH(tblAndmed[[#This Row],[KUUPÄEV]],-1)+1,tblAndmed[KUUPÄEV],\"<=\"&EOMONTH(tblAndmed[[#This Row],[KUUPÄEV]],0))","v":{"v":16400,"d":"16,400.00 €"}},{"$f":"SUMIFS(tblAndmed[SUMMA],tblAndmed[KUUPÄEV],\">=\"&DATE(YEAR(tblAndmed[KUUPÄEV]),1,1),tblAndmed[KUUPÄEV],\"<=\"&DATE(YEAR(tblAndmed[KUUPÄEV]),12,31),tblAndmed[KVARTAL],tblAndmed[KVARTAL])","v":{"v":49100,"d":"49,100.00 €"}},{"$f":"SUMIFS(tblAndmed[SUMMA],tblAndmed[KUUPÄEV],\">=\"&DATE(YEAR(tblAndmed[KUUPÄEV]),1,1),tblAndmed[KUUPÄEV],\"<=\"&DATE(YEAR(tblAndmed[KUUPÄEV]),12,31))","v":{"v":143800,"d":"143,800.00 €"}},{"$f":"IFERROR(TREND($L$6:INDEX($L:$L,ROW(),1),$K$6:INDEX($K:$K,ROW(),1),IF(MONTH(tblAndmed[[#This Row],[KUUPÄEV]])=12,13,MONTH(tblAndmed[[#This Row],[KUUPÄEV]])+1)),\"\")","v":{"v":12455.862068965516,"d":"12,455.86 €"}},{"$f":"IFERROR(TREND($M$6:INDEX($M:$M,ROW(),1),$I$6:INDEX($I:$I,ROW(),1),IF(tblAndmed[KVARTAL]=4,5,tblAndmed[KVARTAL]+1)),\"\")","v":{"v":47400,"d":"47,400.00 €"}},{"$f":"IFERROR(TREND($N$6:INDEX($N:$N,ROW(),1),$J$6:INDEX($J:$J,ROW(),1),tblAndmed[AASTA]+1),\"\")","v":{"v":143800,"d":"143,800.00 €"}}]
[null,{"$f":"40775+(365*2)","v":"2013-08-19"},"School of Fine Art",{"v":7900,"d":"7,900.00 €"},{"v":7700,"d":"7,700.00 €"},{"v":6600,"d":"6,600.00 €"},{"$f":"tblAndmed[[#This Row],[SUMMA]]-tblAndmed[KULU]","v":{"v":1300,"d":"1,300.00 €"}},{"$f":"DATE(YEAR(Andmesisestus!$B16),MONTH(Andmesisestus!$B16),1)","v":"2013-08-01"},{"$f":"LOOKUP(MONTH(Andmesisestus!$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":"Kvartal 3"}},{"$f":"YEAR(Andmesisestus!$B16)","v":2013},{"$f":"MONTH(tblAndmed[[#This Row],[KUUPÄEV]])","v":8},{"$f":"SUMIFS(tblAndmed[SUMMA],tblAndmed[KUUPÄEV],\">=\"&EOMONTH(tblAndmed[[#This Row],[KUUPÄEV]],-1)+1,tblAndmed[KUUPÄEV],\"<=\"&EOMONTH(tblAndmed[[#This Row],[KUUPÄEV]],0))","v":{"v":16400,"d":"16,400.00 €"}},{"$f":"SUMIFS(tblAndmed[SUMMA],tblAndmed[KUUPÄEV],\">=\"&DATE(YEAR(tblAndmed[KUUPÄEV]),1,1),tblAndmed[KUUPÄEV],\"<=\"&DATE(YEAR(tblAndmed[KUUPÄEV]),12,31),tblAndmed[KVARTAL],tblAndmed[KVARTAL])","v":{"v":49100,"d":"49,100.00 €"}},{"$f":"SUMIFS(tblAndmed[SUMMA],tblAndmed[KUUPÄEV],\">=\"&DATE(YEAR(tblAndmed[KUUPÄEV]),1,1),tblAndmed[KUUPÄEV],\"<=\"&DATE(YEAR(tblAndmed[KUUPÄEV]),12,31))","v":{"v":143800,"d":"143,800.00 €"}},{"$f":"IFERROR(TREND($L$6:INDEX($L:$L,ROW(),1),$K$6:INDEX($K:$K,ROW(),1),IF(MONTH(tblAndmed[[#This Row],[KUUPÄEV]])=12,13,MONTH(tblAndmed[[#This Row],[KUUPÄEV]])+1)),\"\")","v":{"v":13667.567567567567,"d":"13,667.57 €"}},{"$f":"IFERROR(TREND($M$6:INDEX($M:$M,ROW(),1),$I$6:INDEX($I:$I,ROW(),1),IF(tblAndmed[KVARTAL]=4,5,tblAndmed[KVARTAL]+1)),\"\")","v":{"v":47400.00000000001,"d":"47,400.00 €"}},{"$f":"IFERROR(TREND($N$6:INDEX($N:$N,ROW(),1),$J$6:INDEX($J:$J,ROW(),1),tblAndmed[AASTA]+1),\"\")","v":{"v":143800,"d":"143,800.00 €"}}]
[null,{"$f":"40791+(365*2)","v":"2013-09-04"},"Trey Research",{"v":9100,"d":"9,100.00 €"},{"v":8900,"d":"8,900.00 €"},{"v":7900,"d":"7,900.00 €"},{"$f":"tblAndmed[[#This Row],[SUMMA]]-tblAndmed[KULU]","v":{"v":1200,"d":"1,200.00 €"}},{"$f":"DATE(YEAR(Andmesisestus!$B17),MONTH(Andmesisestus!$B17),1)","v":"2013-09-01"},{"$f":"LOOKUP(MONTH(Andmesisestus!$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":"Kvartal 3"}},{"$f":"YEAR(Andmesisestus!$B17)","v":2013},{"$f":"MONTH(tblAndmed[[#This Row],[KUUPÄEV]])","v":9},{"$f":"SUMIFS(tblAndmed[SUMMA],tblAndmed[KUUPÄEV],\">=\"&EOMONTH(tblAndmed[[#This Row],[KUUPÄEV]],-1)+1,tblAndmed[KUUPÄEV],\"<=\"&EOMONTH(tblAndmed[[#This Row],[KUUPÄEV]],0))","v":{"v":24000,"d":"24,000.00 €"}},{"$f":"SUMIFS(tblAndmed[SUMMA],tblAndmed[KUUPÄEV],\">=\"&DATE(YEAR(tblAndmed[KUUPÄEV]),1,1),tblAndmed[KUUPÄEV],\"<=\"&DATE(YEAR(tblAndmed[KUUPÄEV]),12,31),tblAndmed[KVARTAL],tblAndmed[KVARTAL])","v":{"v":49100,"d":"49,100.00 €"}},{"$f":"SUMIFS(tblAndmed[SUMMA],tblAndmed[KUUPÄEV],\">=\"&DATE(YEAR(tblAndmed[KUUPÄEV]),1,1),tblAndmed[KUUPÄEV],\"<=\"&DATE(YEAR(tblAndmed[KUUPÄEV]),12,31))","v":{"v":143800,"d":"143,800.00 €"}},{"$f":"IFERROR(TREND($L$6:INDEX($L:$L,ROW(),1),$K$6:INDEX($K:$K,ROW(),1),IF(MONTH(tblAndmed[[#This Row],[KUUPÄEV]])=12,13,MONTH(tblAndmed[[#This Row],[KUUPÄEV]])+1)),\"\")","v":{"v":17651.666666666668,"d":"17,651.67 €"}},{"$f":"IFERROR(TREND($M$6:INDEX($M:$M,ROW(),1),$I$6:INDEX($I:$I,ROW(),1),IF(tblAndmed[KVARTAL]=4,5,tblAndmed[KVARTAL]+1)),\"\")","v":{"v":47400,"d":"47,400.00 €"}},{"$f":"IFERROR(TREND($N$6:INDEX($N:$N,ROW(),1),$J$6:INDEX($J:$J,ROW(),1),tblAndmed[AASTA]+1),\"\")","v":{"v":143800,"d":"143,800.00 €"}}]
[null,{"$f":"40807+(365*2)","v":"2013-09-20"},"Contoso Pharmaceuticals",{"v":5600,"d":"5,600.00 €"},{"v":5800,"d":"5,800.00 €"},{"v":4500,"d":"4,500.00 €"},{"$f":"tblAndmed[[#This Row],[SUMMA]]-tblAndmed[KULU]","v":{"v":1100,"d":"1,100.00 €"}},{"$f":"DATE(YEAR(Andmesisestus!$B18),MONTH(Andmesisestus!$B18),1)","v":"2013-09-01"},{"$f":"LOOKUP(MONTH(Andmesisestus!$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":"Kvartal 3"}},{"$f":"YEAR(Andmesisestus!$B18)","v":2013},{"$f":"MONTH(tblAndmed[[#This Row],[KUUPÄEV]])","v":9},{"$f":"SUMIFS(tblAndmed[SUMMA],tblAndmed[KUUPÄEV],\">=\"&EOMONTH(tblAndmed[[#This Row],[KUUPÄEV]],-1)+1,tblAndmed[KUUPÄEV],\"<=\"&EOMONTH(tblAndmed[[#This Row],[KUUPÄEV]],0))","v":{"v":24000,"d":"24,000.00 €"}},{"$f":"SUMIFS(tblAndmed[SUMMA],tblAndmed[KUUPÄEV],\">=\"&DATE(YEAR(tblAndmed[KUUPÄEV]),1,1),tblAndmed[KUUPÄEV],\"<=\"&DATE(YEAR(tblAndmed[KUUPÄEV]),12,31),tblAndmed[KVARTAL],tblAndmed[KVARTAL])","v":{"v":49100,"d":"49,100.00 €"}},{"$f":"SUMIFS(tblAndmed[SUMMA],tblAndmed[KUUPÄEV],\">=\"&DATE(YEAR(tblAndmed[KUUPÄEV]),1,1),tblAndmed[KUUPÄEV],\"<=\"&DATE(YEAR(tblAndmed[KUUPÄEV]),12,31))","v":{"v":143800,"d":"143,800.00 €"}},{"$f":"IFERROR(TREND($L$6:INDEX($L:$L,ROW(),1),$K$6:INDEX($K:$K,ROW(),1),IF(MONTH(tblAndmed[[#This Row],[KUUPÄEV]])=12,13,MONTH(tblAndmed[[#This Row],[KUUPÄEV]])+1)),\"\")","v":{"v":19877.911646586344,"d":"19,877.91 €"}},{"$f":"IFERROR(TREND($M$6:INDEX($M:$M,ROW(),1),$I$6:INDEX($I:$I,ROW(),1),IF(tblAndmed[KVARTAL]=4,5,tblAndmed[KVARTAL]+1)),\"\")","v":{"v":47400,"d":"47,400.00 €"}},{"$f":"IFERROR(TREND($N$6:INDEX($N:$N,ROW(),1),$J$6:INDEX($J:$J,ROW(),1),tblAndmed[AASTA]+1),\"\")","v":{"v":143800,"d":"143,800.00 €"}}]
[null,{"$f":"40812+(365*2)","v":"2013-09-25"},"Consolidated Messenger",{"v":9300,"d":"9,300.00 €"},{"v":9100,"d":"9,100.00 €"},{"v":7500,"d":"7,500.00 €"},{"$f":"tblAndmed[[#This Row],[SUMMA]]-tblAndmed[KULU]","v":{"v":1800,"d":"1,800.00 €"}},{"$f":"DATE(YEAR(Andmesisestus!$B19),MONTH(Andmesisestus!$B19),1)","v":"2013-09-01"},{"$f":"LOOKUP(MONTH(Andmesisestus!$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":"Kvartal 3"}},{"$f":"YEAR(Andmesisestus!$B19)","v":2013},{"$f":"MONTH(tblAndmed[[#This Row],[KUUPÄEV]])","v":9},{"$f":"SUMIFS(tblAndmed[SUMMA],tblAndmed[KUUPÄEV],\">=\"&EOMONTH(tblAndmed[[#This Row],[KUUPÄEV]],-1)+1,tblAndmed[KUUPÄEV],\"<=\"&EOMONTH(tblAndmed[[#This Row],[KUUPÄEV]],0))","v":{"v":24000,"d":"24,000.00 €"}},{"$f":"SUMIFS(tblAndmed[SUMMA],tblAndmed[KUUPÄEV],\">=\"&DATE(YEAR(tblAndmed[KUUPÄEV]),1,1),tblAndmed[KUUPÄEV],\"<=\"&DATE(YEAR(tblAndmed[KUUPÄEV]),12,31),tblAndmed[KVARTAL],tblAndmed[KVARTAL])","v":{"v":49100,"d":"49,100.00 €"}},{"$f":"SUMIFS(tblAndmed[SUMMA],tblAndmed[KUUPÄEV],\">=\"&DATE(YEAR(tblAndmed[KUUPÄEV]),1,1),tblAndmed[KUUPÄEV],\"<=\"&DATE(YEAR(tblAndmed[KUUPÄEV]),12,31))","v":{"v":143800,"d":"143,800.00 €"}},{"$f":"IFERROR(TREND($L$6:INDEX($L:$L,ROW(),1),$K$6:INDEX($K:$K,ROW(),1),IF(MONTH(tblAndmed[[#This Row],[KUUPÄEV]])=12,13,MONTH(tblAndmed[[#This Row],[KUUPÄEV]])+1)),\"\")","v":{"v":21138.050314465407,"d":"21,138.05 €"}},{"$f":"IFERROR(TREND($M$6:INDEX($M:$M,ROW(),1),$I$6:INDEX($I:$I,ROW(),1),IF(tblAndmed[KVARTAL]=4,5,tblAndmed[KVARTAL]+1)),\"\")","v":{"v":47400,"d":"47,400.00 €"}},{"$f":"IFERROR(TREND($N$6:INDEX($N:$N,ROW(),1),$J$6:INDEX($J:$J,ROW(),1),tblAndmed[AASTA]+1),\"\")","v":{"v":143800,"d":"143,800.00 €"}}]
[null,{"$f":"40832+(365*2)","v":"2013-10-15"},"Proseware, Inc.",{"v":8800,"d":"8,800.00 €"},{"v":9350,"d":"9,350.00 €"},{"v":7100,"d":"7,100.00 €"},{"$f":"tblAndmed[[#This Row],[SUMMA]]-tblAndmed[KULU]","v":{"v":1700,"d":"1,700.00 €"}},{"$f":"DATE(YEAR(Andmesisestus!$B20),MONTH(Andmesisestus!$B20),1)","v":"2013-10-01"},{"$f":"LOOKUP(MONTH(Andmesisestus!$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":"Kvartal 4"}},{"$f":"YEAR(Andmesisestus!$B20)","v":2013},{"$f":"MONTH(tblAndmed[[#This Row],[KUUPÄEV]])","v":10},{"$f":"SUMIFS(tblAndmed[SUMMA],tblAndmed[KUUPÄEV],\">=\"&EOMONTH(tblAndmed[[#This Row],[KUUPÄEV]],-1)+1,tblAndmed[KUUPÄEV],\"<=\"&EOMONTH(tblAndmed[[#This Row],[KUUPÄEV]],0))","v":{"v":8800,"d":"8,800.00 €"}},{"$f":"SUMIFS(tblAndmed[SUMMA],tblAndmed[KUUPÄEV],\">=\"&DATE(YEAR(tblAndmed[KUUPÄEV]),1,1),tblAndmed[KUUPÄEV],\"<=\"&DATE(YEAR(tblAndmed[KUUPÄEV]),12,31),tblAndmed[KVARTAL],tblAndmed[KVARTAL])","v":{"v":43900,"d":"43,900.00 €"}},{"$f":"SUMIFS(tblAndmed[SUMMA],tblAndmed[KUUPÄEV],\">=\"&DATE(YEAR(tblAndmed[KUUPÄEV]),1,1),tblAndmed[KUUPÄEV],\"<=\"&DATE(YEAR(tblAndmed[KUUPÄEV]),12,31))","v":{"v":143800,"d":"143,800.00 €"}},{"$f":"IFERROR(TREND($L$6:INDEX($L:$L,ROW(),1),$K$6:INDEX($K:$K,ROW(),1),IF(MONTH(tblAndmed[[#This Row],[KUUPÄEV]])=12,13,MONTH(tblAndmed[[#This Row],[KUUPÄEV]])+1)),\"\")","v":{"v":17951.74418604651,"d":"17,951.74 €"}},{"$f":"IFERROR(TREND($M$6:INDEX($M:$M,ROW(),1),$I$6:INDEX($I:$I,ROW(),1),IF(tblAndmed[KVARTAL]=4,5,tblAndmed[KVARTAL]+1)),\"\")","v":{"v":43258.139534883725,"d":"43,258.14 €"}},{"$f":"IFERROR(TREND($N$6:INDEX($N:$N,ROW(),1),$J$6:INDEX($J:$J,ROW(),1),tblAndmed[AASTA]+1),\"\")","v":{"v":143800,"d":"143,800.00 €"}}]
[null,{"$f":"40853+(365*2)","v":"2013-11-05"},"School of Fine Art",{"v":9100,"d":"9,100.00 €"},{"v":9200,"d":"9,200.00 €"},{"v":7850,"d":"7,850.00 €"},{"$f":"tblAndmed[[#This Row],[SUMMA]]-tblAndmed[KULU]","v":{"v":1250,"d":"1,250.00 €"}},{"$f":"DATE(YEAR(Andmesisestus!$B21),MONTH(Andmesisestus!$B21),1)","v":"2013-11-01"},{"$f":"LOOKUP(MONTH(Andmesisestus!$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":"Kvartal 4"}},{"$f":"YEAR(Andmesisestus!$B21)","v":2013},{"$f":"MONTH(tblAndmed[[#This Row],[KUUPÄEV]])","v":11},{"$f":"SUMIFS(tblAndmed[SUMMA],tblAndmed[KUUPÄEV],\">=\"&EOMONTH(tblAndmed[[#This Row],[KUUPÄEV]],-1)+1,tblAndmed[KUUPÄEV],\"<=\"&EOMONTH(tblAndmed[[#This Row],[KUUPÄEV]],0))","v":{"v":25600,"d":"25,600.00 €"}},{"$f":"SUMIFS(tblAndmed[SUMMA],tblAndmed[KUUPÄEV],\">=\"&DATE(YEAR(tblAndmed[KUUPÄEV]),1,1),tblAndmed[KUUPÄEV],\"<=\"&DATE(YEAR(tblAndmed[KUUPÄEV]),12,31),tblAndmed[KVARTAL],tblAndmed[KVARTAL])","v":{"v":43900,"d":"43,900.00 €"}},{"$f":"SUMIFS(tblAndmed[SUMMA],tblAndmed[KUUPÄEV],\">=\"&DATE(YEAR(tblAndmed[KUUPÄEV]),1,1),tblAndmed[KUUPÄEV],\"<=\"&DATE(YEAR(tblAndmed[KUUPÄEV]),12,31))","v":{"v":143800,"d":"143,800.00 €"}},{"$f":"IFERROR(TREND($L$6:INDEX($L:$L,ROW(),1),$K$6:INDEX($K:$K,ROW(),1),IF(MONTH(tblAndmed[[#This Row],[KUUPÄEV]])=12,13,MONTH(tblAndmed[[#This Row],[KUUPÄEV]])+1)),\"\")","v":{"v":20556.130108423687,"d":"20,556.13 €"}},{"$f":"IFERROR(TREND($M$6:INDEX($M:$M,ROW(),1),$I$6:INDEX($I:$I,ROW(),1),IF(tblAndmed[KVARTAL]=4,5,tblAndmed[KVARTAL]+1)),\"\")","v":{"v":42312.90322580645,"d":"42,312.90 €"}},{"$f":"IFERROR(TREND($N$6:INDEX($N:$N,ROW(),1),$J$6:INDEX($J:$J,ROW(),1),tblAndmed[AASTA]+1),\"\")","v":{"v":143800,"d":"143,800.00 €"}}]
[null,{"$f":"40874+(365*2)","v":"2013-11-26"},"Trey Research",{"v":9000,"d":"9,000.00 €"},{"v":10000,"d":"10,000.00 €"},{"v":7575,"d":"7,575.00 €"},{"$f":"tblAndmed[[#This Row],[SUMMA]]-tblAndmed[KULU]","v":{"v":1425,"d":"1,425.00 €"}},{"$f":"DATE(YEAR(Andmesisestus!$B22),MONTH(Andmesisestus!$B22),1)","v":"2013-11-01"},{"$f":"LOOKUP(MONTH(Andmesisestus!$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":"Kvartal 4"}},{"$f":"YEAR(Andmesisestus!$B22)","v":2013},{"$f":"MONTH(tblAndmed[[#This Row],[KUUPÄEV]])","v":11},{"$f":"SUMIFS(tblAndmed[SUMMA],tblAndmed[KUUPÄEV],\">=\"&EOMONTH(tblAndmed[[#This Row],[KUUPÄEV]],-1)+1,tblAndmed[KUUPÄEV],\"<=\"&EOMONTH(tblAndmed[[#This Row],[KUUPÄEV]],0))","v":{"v":25600,"d":"25,600.00 €"}},{"$f":"SUMIFS(tblAndmed[SUMMA],tblAndmed[KUUPÄEV],\">=\"&DATE(YEAR(tblAndmed[KUUPÄEV]),1,1),tblAndmed[KUUPÄEV],\"<=\"&DATE(YEAR(tblAndmed[KUUPÄEV]),12,31),tblAndmed[KVARTAL],tblAndmed[KVARTAL])","v":{"v":43900,"d":"43,900.00 €"}},{"$f":"SUMIFS(tblAndmed[SUMMA],tblAndmed[KUUPÄEV],\">=\"&DATE(YEAR(tblAndmed[KUUPÄEV]),1,1),tblAndmed[KUUPÄEV],\"<=\"&DATE(YEAR(tblAndmed[KUUPÄEV]),12,31))","v":{"v":143800,"d":"143,800.00 €"}},{"$f":"IFERROR(TREND($L$6:INDEX($L:$L,ROW(),1),$K$6:INDEX($K:$K,ROW(),1),IF(MONTH(tblAndmed[[#This Row],[KUUPÄEV]])=12,13,MONTH(tblAndmed[[#This Row],[KUUPÄEV]])+1)),\"\")","v":{"v":21997.139141742522,"d":"21,997.14 €"}},{"$f":"IFERROR(TREND($M$6:INDEX($M:$M,ROW(),1),$I$6:INDEX($I:$I,ROW(),1),IF(tblAndmed[KVARTAL]=4,5,tblAndmed[KVARTAL]+1)),\"\")","v":{"v":41811.11111111111,"d":"41,811.11 €"}},{"$f":"IFERROR(TREND($N$6:INDEX($N:$N,ROW(),1),$J$6:INDEX($J:$J,ROW(),1),tblAndmed[AASTA]+1),\"\")","v":{"v":143800,"d":"143,800.00 €"}}]
[null,{"$f":"40878+(365*2)","v":"2013-11-30"},"Trey Research",{"v":7500,"d":"7,500.00 €"},{"v":8000,"d":"8,000.00 €"},{"v":5850,"d":"5,850.00 €"},{"$f":"tblAndmed[[#This Row],[SUMMA]]-tblAndmed[KULU]","v":{"v":1650,"d":"1,650.00 €"}},{"$f":"DATE(YEAR(Andmesisestus!$B23),MONTH(Andmesisestus!$B23),1)","v":"2013-11-01"},{"$f":"LOOKUP(MONTH(Andmesisestus!$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":"Kvartal 4"}},{"$f":"YEAR(Andmesisestus!$B23)","v":2013},{"$f":"MONTH(tblAndmed[[#This Row],[KUUPÄEV]])","v":11},{"$f":"SUMIFS(tblAndmed[SUMMA],tblAndmed[KUUPÄEV],\">=\"&EOMONTH(tblAndmed[[#This Row],[KUUPÄEV]],-1)+1,tblAndmed[KUUPÄEV],\"<=\"&EOMONTH(tblAndmed[[#This Row],[KUUPÄEV]],0))","v":{"v":25600,"d":"25,600.00 €"}},{"$f":"SUMIFS(tblAndmed[SUMMA],tblAndmed[KUUPÄEV],\">=\"&DATE(YEAR(tblAndmed[KUUPÄEV]),1,1),tblAndmed[KUUPÄEV],\"<=\"&DATE(YEAR(tblAndmed[KUUPÄEV]),12,31),tblAndmed[KVARTAL],tblAndmed[KVARTAL])","v":{"v":43900,"d":"43,900.00 €"}},{"$f":"SUMIFS(tblAndmed[SUMMA],tblAndmed[KUUPÄEV],\">=\"&DATE(YEAR(tblAndmed[KUUPÄEV]),1,1),tblAndmed[KUUPÄEV],\"<=\"&DATE(YEAR(tblAndmed[KUUPÄEV]),12,31))","v":{"v":143800,"d":"143,800.00 €"}},{"$f":"IFERROR(TREND($L$6:INDEX($L:$L,ROW(),1),$K$6:INDEX($K:$K,ROW(),1),IF(MONTH(tblAndmed[[#This Row],[KUUPÄEV]])=12,13,MONTH(tblAndmed[[#This Row],[KUUPÄEV]])+1)),\"\")","v":{"v":22917.63452317528,"d":"22,917.63 €"}},{"$f":"IFERROR(TREND($M$6:INDEX($M:$M,ROW(),1),$I$6:INDEX($I:$I,ROW(),1),IF(tblAndmed[KVARTAL]=4,5,tblAndmed[KVARTAL]+1)),\"\")","v":{"v":41500,"d":"41,500.00 €"}},{"$f":"IFERROR(TREND($N$6:INDEX($N:$N,ROW(),1),$J$6:INDEX($J:$J,ROW(),1),tblAndmed[AASTA]+1),\"\")","v":{"v":143800,"d":"143,800.00 €"}}]
[null,{"$f":"40889+(365*2)","v":"2013-12-11"},"Contoso Pharmaceuticals",{"v":9500,"d":"9,500.00 €"},{"v":9200,"d":"9,200.00 €"},{"v":8500,"d":"8,500.00 €"},{"$f":"tblAndmed[[#This Row],[SUMMA]]-tblAndmed[KULU]","v":{"v":1000,"d":"1,000.00 €"}},{"$f":"DATE(YEAR(Andmesisestus!$B24),MONTH(Andmesisestus!$B24),1)","v":"2013-12-01"},{"$f":"LOOKUP(MONTH(Andmesisestus!$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":"Kvartal 4"}},{"$f":"YEAR(Andmesisestus!$B24)","v":2013},{"$f":"MONTH(tblAndmed[[#This Row],[KUUPÄEV]])","v":12},{"$f":"SUMIFS(tblAndmed[SUMMA],tblAndmed[KUUPÄEV],\">=\"&EOMONTH(tblAndmed[[#This Row],[KUUPÄEV]],-1)+1,tblAndmed[KUUPÄEV],\"<=\"&EOMONTH(tblAndmed[[#This Row],[KUUPÄEV]],0))","v":{"v":9500,"d":"9,500.00 €"}},{"$f":"SUMIFS(tblAndmed[SUMMA],tblAndmed[KUUPÄEV],\">=\"&DATE(YEAR(tblAndmed[KUUPÄEV]),1,1),tblAndmed[KUUPÄEV],\"<=\"&DATE(YEAR(tblAndmed[KUUPÄEV]),12,31),tblAndmed[KVARTAL],tblAndmed[KVARTAL])","v":{"v":43900,"d":"43,900.00 €"}},{"$f":"SUMIFS(tblAndmed[SUMMA],tblAndmed[KUUPÄEV],\">=\"&DATE(YEAR(tblAndmed[KUUPÄEV]),1,1),tblAndmed[KUUPÄEV],\"<=\"&DATE(YEAR(tblAndmed[KUUPÄEV]),12,31))","v":{"v":143800,"d":"143,800.00 €"}},{"$f":"IFERROR(TREND($L$6:INDEX($L:$L,ROW(),1),$K$6:INDEX($K:$K,ROW(),1),IF(MONTH(tblAndmed[[#This Row],[KUUPÄEV]])=12,13,MONTH(tblAndmed[[#This Row],[KUUPÄEV]])+1)),\"\")","v":{"v":20504.31472081218,"d":"20,504.31 €"}},{"$f":"IFERROR(TREND($M$6:INDEX($M:$M,ROW(),1),$I$6:INDEX($I:$I,ROW(),1),IF(tblAndmed[KVARTAL]=4,5,tblAndmed[KVARTAL]+1)),\"\")","v":{"v":41288.23529411765,"d":"41,288.24 €"}},{"$f":"IFERROR(TREND($N$6:INDEX($N:$N,ROW(),1),$J$6:INDEX($J:$J,ROW(),1),tblAndmed[AASTA]+1),\"\")","v":{"v":143800,"d":"143,800.00 €"}}]

{"sheet":"Müügiaruanne","index":1,"n_rows":28,"n_cols":6,"rows_kept":28}
[]
[null,"KUUS MÜÜGIARUANNE"]
[]
[]
[null,"AASTA","KVARTAL","KUU","ETTEVÕTE","KOGU MÜÜK"]
[null,2013,{"v":2,"d":" Kvartal 2"},"2013-04-01","A. Datum Corporation",{"v":6400,"d":"6,400.00 €"}]
[{"$nulls":4},"Contoso Pharmaceuticals",{"v":8200,"d":"8,200.00 €"}]
[{"$nulls":3},"2013-05-01","Consolidated Messenger",{"v":4400,"d":"4,400.00 €"}]
[{"$nulls":4},"Proseware, Inc.",{"v":5400,"d":"5,400.00 €"}]
[{"$nulls":4},"School of Fine Art",{"v":5800,"d":"5,800.00 €"}]
[{"$nulls":4},"Trey Research",{"v":6200,"d":"6,200.00 €"}]
[{"$nulls":3},"2013-06-01","A. Datum Corporation",{"v":6900,"d":"6,900.00 €"}]
[{"$nulls":4},"Contoso Pharmaceuticals",{"v":7500,"d":"7,500.00 €"}]
[null,null," Kvartal 2 Kokku",null,null,{"v":50800,"d":"50,800.00 €"}]
[null,null,{"v":3,"d":" Kvartal 3"},"2013-07-01","Consolidated Messenger",{"v":8700,"d":"8,700.00 €"}]
[{"$nulls":3},"2013-08-01","Proseware, Inc.",{"v":8500,"d":"8,500.00 €"}]
[{"$nulls":4},"School of Fine Art",{"v":7900,"d":"7,900.00 €"}]
[{"$nulls":3},"2013-09-01","Consolidated Messenger",{"v":9300,"d":"9,300.00 €"}]
[{"$nulls":4},"Contoso Pharmaceuticals",{"v":5600,"d":"5,600.00 €"}]
[{"$nulls":4},"Trey Research",{"v":9100,"d":"9,100.00 €"}]
[null,null," Kvartal 3 Kokku",null,null,{"v":49100,"d":"49,100.00 €"}]
[null,null,{"v":4,"d":" Kvartal 4"},"2013-10-01","Proseware, Inc.",{"v":8800,"d":"8,800.00 €"}]
[{"$nulls":3},"2013-11-01","School of Fine Art",{"v":9100,"d":"9,100.00 €"}]
[{"$nulls":4},"Trey Research",{"v":16500,"d":"16,500.00 €"}]
[{"$nulls":3},"2013-12-01","Contoso Pharmaceuticals",{"v":9500,"d":"9,500.00 €"}]
[null,null," Kvartal 4 Kokku",null,null,{"v":43900,"d":"43,900.00 €"}]
[null," 2013 Kokku",{"$nulls":3},{"v":143800,"d":"143,800.00 €"}]
[null,"Üldkokkuvõte",{"$nulls":3},{"v":143800,"d":"143,800.00 €"}]

{"sheet":"Müügiprognoos","index":2,"n_rows":43,"n_cols":10,"rows_kept":43}
[]
[null,"KUUS MÜÜGIPROGNOOS"]
[null,{"$f":"\"TÄNANE KUUPÄEV: \"&UPPER(TEXT(TODAY(),\"d mmmm yyyy\"))","v":"TÄNANE KUUPÄEV: 17 JUULI 2013"},null,{"$f":"--TRIM(RIGHT(B3,LEN(B3)-FIND(\":\",B3)))","v":"2013-07-17"}]
[]
[null,"SELLEL KUUL","TEGELIK","PLAANITUD","DISPERSIOON","%","AASTA ALGUSEST TÄNASENI TEGELIK","AASTA ALGUSEST TÄNASENI PLAAN","AASTA ALGUSEST TÄNASENI DISPERSIOON","Aasta algusest tänaseni %"]
[null,"Hulk",{"$f":"COUNTIF(Andmesisestus!$B$6:$B$24,\">=\"&DATE(fAasta,MONTH(fKuupäev),1))-COUNTIF(Andmesisestus!$B$6:$B$24,\">\"&EOMONTH(fKuupäev,0))","v":9},{"$nulls":3},{"$f":"COUNTIF(tblAndmed[KUUPÄEV],\"<=\"&EOMONTH(fKuupäev,0))","v":9}]
[null,"Müük",{"$f":"SUMIF(tblAndmed[KUUPÄEV],\">=\"&DATE(fAasta,MONTH(fKuupäev),1),tblAndmed[SUMMA])-SUMIF(tblAndmed[KUUPÄEV],\">\"&EOMONTH(fKuupäev,0),tblAndmed[SUMMA])","v":{"v":59500,"d":"59,500.00 €"}},{"$f":"SUMIF(Andmesisestus!$B$6:$B$24,\">=\"&DATE(fAasta,MONTH(fKuupäev),1),Andmesisestus!$E$6:$E$24)-SUMIF(Andmesisestus!$B$6:$B$24,\">\"&EOMONTH(fKuupäev,0),Andmesisestus!$E$6:$E$24)","v":{"v":59100,"d":"59,100.00 €"}},{"$f":"D7-C7","v":{"v":-400,"d":"-400.00 €"}},{"$f":"IFERROR(D7/C7,\"-\")","v":{"v":0.9932773109243698,"d":"99.33%"}},{"$f":"SUMIF(tblAndmed[KUUPÄEV],\"<=\"&EOMONTH(fKuupäev,0),tblAndmed[SUMMA])","v":{"v":59500,"d":"59,500.00 €"}},{"$f":"SUMIF(tblAndmed[KUUPÄEV],\"<=\"&EOMONTH(fKuupäev,0),tblAndmed[PLAANITUD])","v":{"v":59100,"d":"59,100.00 €"}},{"$f":"H7-G7","v":{"v":-400,"d":"-400.00 €"}},{"$f":"IFERROR(H7/G7,\"\")","v":{"v":0.9932773109243698,"d":"99.33%"}}]
[null,"Tulud",{"$f":"(SUMIF(tblAndmed[KUUPÄEV],\">=\"&DATE(fAasta,MONTH(fKuupäev),1),tblAndmed[SUMMA])-SUMIF(tblAndmed[KUUPÄEV],\">\"&EOMONTH(fKuupäev,0),tblAndmed[SUMMA]))-(SUMIF(tblAndmed[KUUPÄEV],\">=\"&DATE(fAasta,MONTH(fKuupäev),1),tblAndmed[KULU])-SUMIF(tblAndmed[KUUPÄEV],\">\"&EOMONTH(fKuupäev,0),tblAndmed[KULU]))","v":{"v":13400,"d":"13,400.00 €"}},{"$f":"(SUMIF(Andmesisestus!$B$6:$B$24,\">=\"&DATE(fAasta,MONTH(fKuupäev),1),Andmesisestus!$E$6:$E$24)-SUMIF(Andmesisestus!$B$6:$B$24,\">\"&EOMONTH(fKuupäev,0),Andmesisestus!$E$6:$E$24))-(SUMIF(Andmesisestus!$B$6:$B$24,\">=\"&DATE(fAasta,MONTH(fKuupäev),1),Andmesisestus!$F$6:$F$24)-SUMIF(Andmesisestus!$B$6:$B$24,\">\"&EOMONTH(fKuupäev,0),Andmesisestus!$F$6:$F$24))","v":{"v":13000,"d":"13,000.00 €"}},{"$f":"D8-C8","v":{"v":-400,"d":"-400.00 €"}},{"$f":"IFERROR(D8/C8,\"-\")","v":{"v":0.9701492537313433,"d":"97.01%"}},{"$f":"SUMIF(Andmesisestus!$B$6:$B$24,\"<=\"&EOMONTH(fKuupäev,0),Andmesisestus!$F$6:$F$24)","v":{"v":46100,"d":"46,100.00 €"}},{"$f":"SUMIF(tblAndmed[KUUPÄEV],\"<=\"&EOMONTH(fKuupäev,0),tblAndmed[SUMMA])","v":{"v":59500,"d":"59,500.00 €"}},{"$f":"H8-G8","v":{"v":13400,"d":"13,400.00 €"}},{"$f":"IFERROR(H8/G8,\"\")","v":{"v":1.2906724511930585,"d":"129.07%"}}]
[null,"Kasum",{"$f":"IFERROR(C8/C7,\"-\")","v":{"v":0.22521008403361345,"d":"22.52%"}},{"$f":"IFERROR(D8/D7,\"-\")","v":{"v":0.21996615905245348,"d":"22.00%"}},null,{"$f":"IFERROR(F8/F7,\"-\")","v":{"v":0.9767154077329091,"d":"97.67%"}},{"$f":"IFERROR(G8/G7,\"\")","v":{"v":0.7747899159663866,"d":"77.48%"}},{"$f":"IFERROR(H8/H7,\"\")","v":{"v":1.0067681895093064,"d":"100.68%"}},null,{"$f":"IFERROR(J8/J7,\"\")","v":{"v":1.2994079669371739,"d":"129.94%"}}]
[null,"Tellimuste arv",{"$f":"COUNTIF(tblAndmed[KUUPÄEV],\">=\"&DATE(fAasta,MONTH(fKuupäev),1))-COUNTIF(tblAndmed[KUUPÄEV],\">\"&EOMONTH(fKuupäev,0))","v":9},{"$nulls":3},{"$f":"COUNTIF(tblAndmed[KUUPÄEV],\">\"&EOMONTH(fKuupäev,0))","v":10}]
[null,"Keskmine tellimuse väärtus",{"$f":"IFERROR(C7/C10,\"-\")","v":{"v":6611.111111111111,"d":"6,611.11 €"}},{"$nulls":3},{"$f":"IFERROR(G7/G10,\"-\")","v":{"v":5950,"d":"5,950.00 €"}}]
[]
[null,"PROGNOOS",null,"JÄRGMINE KUU",null,"JÄRGMINE KVARTAL",null,null,"JÄRGMINE AASTA"]
[null,"Müük",null,{"$f":"TREND(tblAndmed[[KUU ]],tblAndmed[KUU NR (PEIDA)],IF(MONTH(fKuupäev)=12,13,MONTH(fKuupäev)+1))","v":{"v":18750.296108291033,"d":"18,750.30 €"}},null,{"$f":"TREND(tblAndmed[[KVARTAL ]],tblAndmed[KUU NR (PEIDA)],IF(MONTH(fKuupäev)=12,13,MONTH(fKuupäev)+1))","v":{"v":48082.064297800345,"d":"48,082.06 €"}},null,null,{"$f":"TREND(tblAndmed[[AASTAS ]],tblAndmed[KUU NR (PEIDA)],IF(MONTH(fKuupäev)=12,13,MONTH(fKuupäev)+1))","v":{"v":143800,"d":"143,800.00 €"}}]
[]
[null,"MÜÜGIAJALUGU"]
{"$rows_empty":13}
[null,"KUUPROGNOOS",{"$nulls":3},"KVARTALIPROGNOOS"]
{"$rows_empty":7}
[null,"AASTAPROGNOOS",{"$nulls":3},"TULUVOOG"]
[]
[]
[]
[]
[{"$nulls":9}," "]