{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Mục nhập Dữ liệu","Báo cáo Bán hàng","Dự báo Bán hàng"],"not_rendered":{"charts":5,"defined_names":7,"pivot_tables":1},"read":"whole","date_system":"1900"}

{"sheet":"Mục nhập Dữ liệu","index":0,"n_rows":24,"n_cols":17,"rows_kept":24}
[{"$nulls":9},{"$f":"365*2","v":730}]
[null,"MỤC NHẬP DỮ LIỆU HÀNG THÁNG"]
[{"$nulls":11},"TỔNG CỘNG",null,null,"DỰ BÁO"]
[]
[null,"NGÀY","CÔNG TY","SỐ TIỀN","THEO KẾ HOẠCH","CHI PHÍ","DOANH THU","THÁNG","QUÝ","NĂM","MONTH NUM (HIDE)","THÁNG ","QUÝ ","HÀNG NĂM ","THÁNG  ","QUÝ  ","NĂM  "]
[null,{"$f":"40657+(365*2)","v":"2013-04-23"},"A. Datum Corporation",{"v":133120000,"d":"₫133,120,000"},{"v":128960000,"d":"₫128,960,000"},{"v":92560000,"d":"₫92,560,000"},{"$f":"tblData[[#This Row],[SỐ TIỀN]]-tblData[[#This Row],[CHI PHÍ]]","v":{"v":40560000,"d":"₫40,560,000"}},{"$f":"DATE(YEAR('Mục nhập Dữ liệu'!$B6),MONTH('Mục nhập Dữ liệu'!$B6),1)","v":"2013-04-01"},{"$f":"LOOKUP(MONTH('Mục nhập Dữ liệu'!$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":"Quý 2"}},{"$f":"YEAR('Mục nhập Dữ liệu'!$B6)","v":2013},{"$f":"MONTH(tblData[[#This Row],[NGÀY]])","v":4},{"$f":"SUMIFS(tblData[SỐ TIỀN],tblData[NGÀY],\">=\"&EOMONTH(tblData[[#This Row],[NGÀY]],-1)+1,tblData[NGÀY],\"<=\"&EOMONTH(tblData[[#This Row],[NGÀY]],0))","v":{"v":303680000,"d":"₫303,680,000"}},{"$f":"SUMIFS(tblData[SỐ TIỀN],tblData[NGÀY],\">=\"&DATE(YEAR(tblData[[#This Row],[NGÀY]]),1,1),tblData[NGÀY],\"<=\"&DATE(YEAR(tblData[[#This Row],[NGÀY]]),12,31),tblData[QUÝ],tblData[[#This Row],[QUÝ]])","v":{"v":1056640000,"d":"₫1,056,640,000"}},{"$f":"SUMIFS(tblData[SỐ TIỀN],tblData[NGÀY],\">=\"&DATE(YEAR(tblData[[#This Row],[NGÀY]]),1,1),tblData[NGÀY],\"<=\"&DATE(YEAR(tblData[[#This Row],[NGÀY]]),12,31))","v":{"v":2991040000,"d":"₫2,991,040,000"}},{"$f":"IFERROR(TREND($L$6:INDEX($L:$L,ROW(),1),$K$6:INDEX($K:$K,ROW(),1),IF(MONTH(tblData[[#This Row],[NGÀY]])=12,13,MONTH(tblData[[#This Row],[NGÀY]])+1)),\"\")","v":{"v":303680000,"d":"₫303,680,000"}},{"$f":"IFERROR(TREND($M$6:INDEX($M:$M,ROW(),1),$I$6:INDEX($I:$I,ROW(),1),IF(tblData[[#This Row],[QUÝ]]=4,5,tblData[[#This Row],[QUÝ]]+1)),\"\")","v":{"v":1056640000,"d":"₫1,056,640,000"}},{"$f":"IFERROR(TREND($N$6:INDEX($N:$N,ROW(),1),$J$6:INDEX($J:$J,ROW(),1),tblData[[#This Row],[NĂM]]+1),\"\")","v":{"v":2991040000,"d":"₫2,991,040,000"}}]
[null,{"$f":"40659+(365*2)","v":"2013-04-25"},"Contoso Pharmaceuticals",{"v":170560000,"d":"₫170,560,000"},{"v":166400000,"d":"₫166,400,000"},{"v":133120000,"d":"₫133,120,000"},{"$f":"tblData[[#This Row],[SỐ TIỀN]]-tblData[[#This Row],[CHI PHÍ]]","v":{"v":37440000,"d":"₫37,440,000"}},{"$f":"DATE(YEAR('Mục nhập Dữ liệu'!$B7),MONTH('Mục nhập Dữ liệu'!$B7),1)","v":"2013-04-01"},{"$f":"LOOKUP(MONTH('Mục nhập Dữ liệu'!$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":"Quý 2"}},{"$f":"YEAR('Mục nhập Dữ liệu'!$B7)","v":2013},{"$f":"MONTH(tblData[[#This Row],[NGÀY]])","v":4},{"$f":"SUMIFS(tblData[SỐ TIỀN],tblData[NGÀY],\">=\"&EOMONTH(tblData[[#This Row],[NGÀY]],-1)+1,tblData[NGÀY],\"<=\"&EOMONTH(tblData[[#This Row],[NGÀY]],0))","v":{"v":303680000,"d":"₫303,680,000"}},{"$f":"SUMIFS(tblData[SỐ TIỀN],tblData[NGÀY],\">=\"&DATE(YEAR(tblData[[#This Row],[NGÀY]]),1,1),tblData[NGÀY],\"<=\"&DATE(YEAR(tblData[[#This Row],[NGÀY]]),12,31),tblData[QUÝ],tblData[[#This Row],[QUÝ]])","v":{"v":1056640000,"d":"₫1,056,640,000"}},{"$f":"SUMIFS(tblData[SỐ TIỀN],tblData[NGÀY],\">=\"&DATE(YEAR(tblData[[#This Row],[NGÀY]]),1,1),tblData[NGÀY],\"<=\"&DATE(YEAR(tblData[[#This Row],[NGÀY]]),12,31))","v":{"v":2991040000,"d":"₫2,991,040,000"}},{"$f":"IFERROR(TREND($L$6:INDEX($L:$L,ROW(),1),$K$6:INDEX($K:$K,ROW(),1),IF(MONTH(tblData[[#This Row],[NGÀY]])=12,13,MONTH(tblData[[#This Row],[NGÀY]])+1)),\"\")","v":{"v":303680000,"d":"₫303,680,000"}},{"$f":"IFERROR(TREND($M$6:INDEX($M:$M,ROW(),1),$I$6:INDEX($I:$I,ROW(),1),IF(tblData[[#This Row],[QUÝ]]=4,5,tblData[[#This Row],[QUÝ]]+1)),\"\")","v":{"v":1056640000,"d":"₫1,056,640,000"}},{"$f":"IFERROR(TREND($N$6:INDEX($N:$N,ROW(),1),$J$6:INDEX($J:$J,ROW(),1),tblData[[#This Row],[NĂM]]+1),\"\")","v":{"v":2991040000,"d":"₫2,991,040,000"}}]
[null,{"$f":"40671+(365*2)","v":"2013-05-07"},"Consolidated Messenger",{"v":91520000,"d":"₫91,520,000"},{"v":87360000,"d":"₫87,360,000"},{"v":54080000,"d":"₫54,080,000"},{"$f":"tblData[[#This Row],[SỐ TIỀN]]-tblData[[#This Row],[CHI PHÍ]]","v":{"v":37440000,"d":"₫37,440,000"}},{"$f":"DATE(YEAR('Mục nhập Dữ liệu'!$B8),MONTH('Mục nhập Dữ liệu'!$B8),1)","v":"2013-05-01"},{"$f":"LOOKUP(MONTH('Mục nhập Dữ liệu'!$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":"Quý 2"}},{"$f":"YEAR('Mục nhập Dữ liệu'!$B8)","v":2013},{"$f":"MONTH(tblData[[#This Row],[NGÀY]])","v":5},{"$f":"SUMIFS(tblData[SỐ TIỀN],tblData[NGÀY],\">=\"&EOMONTH(tblData[[#This Row],[NGÀY]],-1)+1,tblData[NGÀY],\"<=\"&EOMONTH(tblData[[#This Row],[NGÀY]],0))","v":{"v":453440000,"d":"₫453,440,000"}},{"$f":"SUMIFS(tblData[SỐ TIỀN],tblData[NGÀY],\">=\"&DATE(YEAR(tblData[[#This Row],[NGÀY]]),1,1),tblData[NGÀY],\"<=\"&DATE(YEAR(tblData[[#This Row],[NGÀY]]),12,31),tblData[QUÝ],tblData[[#This Row],[QUÝ]])","v":{"v":1056640000,"d":"₫1,056,640,000"}},{"$f":"SUMIFS(tblData[SỐ TIỀN],tblData[NGÀY],\">=\"&DATE(YEAR(tblData[[#This Row],[NGÀY]]),1,1),tblData[NGÀY],\"<=\"&DATE(YEAR(tblData[[#This Row],[NGÀY]]),12,31))","v":{"v":2991040000,"d":"₫2,991,040,000"}},{"$f":"IFERROR(TREND($L$6:INDEX($L:$L,ROW(),1),$K$6:INDEX($K:$K,ROW(),1),IF(MONTH(tblData[[#This Row],[NGÀY]])=12,13,MONTH(tblData[[#This Row],[NGÀY]])+1)),\"\")","v":{"v":603199999.9999999,"d":"₫603,200,000"}},{"$f":"IFERROR(TREND($M$6:INDEX($M:$M,ROW(),1),$I$6:INDEX($I:$I,ROW(),1),IF(tblData[[#This Row],[QUÝ]]=4,5,tblData[[#This Row],[QUÝ]]+1)),\"\")","v":{"v":1056640000,"d":"₫1,056,640,000"}},{"$f":"IFERROR(TREND($N$6:INDEX($N:$N,ROW(),1),$J$6:INDEX($J:$J,ROW(),1),tblData[[#This Row],[NĂM]]+1),\"\")","v":{"v":2991040000,"d":"₫2,991,040,000"}}]
[null,{"$f":"40678+(365*2)","v":"2013-05-14"},"Proseware, Inc.",{"v":112320000,"d":"₫112,320,000"},{"v":114400000,"d":"₫114,400,000"},{"v":93600000,"d":"₫93,600,000"},{"$f":"tblData[[#This Row],[SỐ TIỀN]]-tblData[[#This Row],[CHI PHÍ]]","v":{"v":18720000,"d":"₫18,720,000"}},{"$f":"DATE(YEAR('Mục nhập Dữ liệu'!$B9),MONTH('Mục nhập Dữ liệu'!$B9),1)","v":"2013-05-01"},{"$f":"LOOKUP(MONTH('Mục nhập Dữ liệu'!$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":"Quý 2"}},{"$f":"YEAR('Mục nhập Dữ liệu'!$B9)","v":2013},{"$f":"MONTH(tblData[[#This Row],[NGÀY]])","v":5},{"$f":"SUMIFS(tblData[SỐ TIỀN],tblData[NGÀY],\">=\"&EOMONTH(tblData[[#This Row],[NGÀY]],-1)+1,tblData[NGÀY],\"<=\"&EOMONTH(tblData[[#This Row],[NGÀY]],0))","v":{"v":453440000,"d":"₫453,440,000"}},{"$f":"SUMIFS(tblData[SỐ TIỀN],tblData[NGÀY],\">=\"&DATE(YEAR(tblData[[#This Row],[NGÀY]]),1,1),tblData[NGÀY],\"<=\"&DATE(YEAR(tblData[[#This Row],[NGÀY]]),12,31),tblData[QUÝ],tblData[[#This Row],[QUÝ]])","v":{"v":1056640000,"d":"₫1,056,640,000"}},{"$f":"SUMIFS(tblData[SỐ TIỀN],tblData[NGÀY],\">=\"&DATE(YEAR(tblData[[#This Row],[NGÀY]]),1,1),tblData[NGÀY],\"<=\"&DATE(YEAR(tblData[[#This Row],[NGÀY]]),12,31))","v":{"v":2991040000,"d":"₫2,991,040,000"}},{"$f":"IFERROR(TREND($L$6:INDEX($L:$L,ROW(),1),$K$6:INDEX($K:$K,ROW(),1),IF(MONTH(tblData[[#This Row],[NGÀY]])=12,13,MONTH(tblData[[#This Row],[NGÀY]])+1)),\"\")","v":{"v":603199999.9999999,"d":"₫603,200,000"}},{"$f":"IFERROR(TREND($M$6:INDEX($M:$M,ROW(),1),$I$6:INDEX($I:$I,ROW(),1),IF(tblData[[#This Row],[QUÝ]]=4,5,tblData[[#This Row],[QUÝ]]+1)),\"\")","v":{"v":1056640000,"d":"₫1,056,640,000"}},{"$f":"IFERROR(TREND($N$6:INDEX($N:$N,ROW(),1),$J$6:INDEX($J:$J,ROW(),1),tblData[[#This Row],[NĂM]]+1),\"\")","v":{"v":2991040000,"d":"₫2,991,040,000"}}]
[null,{"$f":"40678+(365*2)","v":"2013-05-14"},"Trường Mỹ thuật",{"v":120640000,"d":"₫120,640,000"},{"v":124800000,"d":"₫124,800,000"},{"v":93600000,"d":"₫93,600,000"},{"$f":"tblData[[#This Row],[SỐ TIỀN]]-tblData[[#This Row],[CHI PHÍ]]","v":{"v":27040000,"d":"₫27,040,000"}},{"$f":"DATE(YEAR('Mục nhập Dữ liệu'!$B10),MONTH('Mục nhập Dữ liệu'!$B10),1)","v":"2013-05-01"},{"$f":"LOOKUP(MONTH('Mục nhập Dữ liệu'!$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":"Quý 2"}},{"$f":"YEAR('Mục nhập Dữ liệu'!$B10)","v":2013},{"$f":"MONTH(tblData[[#This Row],[NGÀY]])","v":5},{"$f":"SUMIFS(tblData[SỐ TIỀN],tblData[NGÀY],\">=\"&EOMONTH(tblData[[#This Row],[NGÀY]],-1)+1,tblData[NGÀY],\"<=\"&EOMONTH(tblData[[#This Row],[NGÀY]],0))","v":{"v":453440000,"d":"₫453,440,000"}},{"$f":"SUMIFS(tblData[SỐ TIỀN],tblData[NGÀY],\">=\"&DATE(YEAR(tblData[[#This Row],[NGÀY]]),1,1),tblData[NGÀY],\"<=\"&DATE(YEAR(tblData[[#This Row],[NGÀY]]),12,31),tblData[QUÝ],tblData[[#This Row],[QUÝ]])","v":{"v":1056640000,"d":"₫1,056,640,000"}},{"$f":"SUMIFS(tblData[SỐ TIỀN],tblData[NGÀY],\">=\"&DATE(YEAR(tblData[[#This Row],[NGÀY]]),1,1),tblData[NGÀY],\"<=\"&DATE(YEAR(tblData[[#This Row],[NGÀY]]),12,31))","v":{"v":2991040000,"d":"₫2,991,040,000"}},{"$f":"IFERROR(TREND($L$6:INDEX($L:$L,ROW(),1),$K$6:INDEX($K:$K,ROW(),1),IF(MONTH(tblData[[#This Row],[NGÀY]])=12,13,MONTH(tblData[[#This Row],[NGÀY]])+1)),\"\")","v":{"v":603200000,"d":"₫603,200,000"}},{"$f":"IFERROR(TREND($M$6:INDEX($M:$M,ROW(),1),$I$6:INDEX($I:$I,ROW(),1),IF(tblData[[#This Row],[QUÝ]]=4,5,tblData[[#This Row],[QUÝ]]+1)),\"\")","v":{"v":1056640000,"d":"₫1,056,640,000"}},{"$f":"IFERROR(TREND($N$6:INDEX($N:$N,ROW(),1),$J$6:INDEX($J:$J,ROW(),1),tblData[[#This Row],[NĂM]]+1),\"\")","v":{"v":2991040000,"d":"₫2,991,040,000"}}]
[null,{"$f":"40693+(365*2)","v":"2013-05-29"},"Trey Research",{"v":128960000,"d":"₫128,960,000"},{"v":124800000,"d":"₫124,800,000"},{"v":93600000,"d":"₫93,600,000"},{"$f":"tblData[[#This Row],[SỐ TIỀN]]-tblData[[#This Row],[CHI PHÍ]]","v":{"v":35360000,"d":"₫35,360,000"}},{"$f":"DATE(YEAR('Mục nhập Dữ liệu'!$B11),MONTH('Mục nhập Dữ liệu'!$B11),1)","v":"2013-05-01"},{"$f":"LOOKUP(MONTH('Mục nhập Dữ liệu'!$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":"Quý 2"}},{"$f":"YEAR('Mục nhập Dữ liệu'!$B11)","v":2013},{"$f":"MONTH(tblData[[#This Row],[NGÀY]])","v":5},{"$f":"SUMIFS(tblData[SỐ TIỀN],tblData[NGÀY],\">=\"&EOMONTH(tblData[[#This Row],[NGÀY]],-1)+1,tblData[NGÀY],\"<=\"&EOMONTH(tblData[[#This Row],[NGÀY]],0))","v":{"v":453440000,"d":"₫453,440,000"}},{"$f":"SUMIFS(tblData[SỐ TIỀN],tblData[NGÀY],\">=\"&DATE(YEAR(tblData[[#This Row],[NGÀY]]),1,1),tblData[NGÀY],\"<=\"&DATE(YEAR(tblData[[#This Row],[NGÀY]]),12,31),tblData[QUÝ],tblData[[#This Row],[QUÝ]])","v":{"v":1056640000,"d":"₫1,056,640,000"}},{"$f":"SUMIFS(tblData[SỐ TIỀN],tblData[NGÀY],\">=\"&DATE(YEAR(tblData[[#This Row],[NGÀY]]),1,1),tblData[NGÀY],\"<=\"&DATE(YEAR(tblData[[#This Row],[NGÀY]]),12,31))","v":{"v":2991040000,"d":"₫2,991,040,000"}},{"$f":"IFERROR(TREND($L$6:INDEX($L:$L,ROW(),1),$K$6:INDEX($K:$K,ROW(),1),IF(MONTH(tblData[[#This Row],[NGÀY]])=12,13,MONTH(tblData[[#This Row],[NGÀY]])+1)),\"\")","v":{"v":603200000,"d":"₫603,200,000"}},{"$f":"IFERROR(TREND($M$6:INDEX($M:$M,ROW(),1),$I$6:INDEX($I:$I,ROW(),1),IF(tblData[[#This Row],[QUÝ]]=4,5,tblData[[#This Row],[QUÝ]]+1)),\"\")","v":{"v":1056640000,"d":"₫1,056,640,000"}},{"$f":"IFERROR(TREND($N$6:INDEX($N:$N,ROW(),1),$J$6:INDEX($J:$J,ROW(),1),tblData[[#This Row],[NĂM]]+1),\"\")","v":{"v":2991040000,"d":"₫2,991,040,000"}}]
[null,{"$f":"40705+(365*2)","v":"2013-06-10"},"A. Datum Corporation",{"v":143520000,"d":"₫143,520,000"},{"v":156000000,"d":"₫156,000,000"},{"v":112320000,"d":"₫112,320,000"},{"$f":"tblData[[#This Row],[SỐ TIỀN]]-tblData[[#This Row],[CHI PHÍ]]","v":{"v":31200000,"d":"₫31,200,000"}},{"$f":"DATE(YEAR('Mục nhập Dữ liệu'!$B12),MONTH('Mục nhập Dữ liệu'!$B12),1)","v":"2013-06-01"},{"$f":"LOOKUP(MONTH('Mục nhập Dữ liệu'!$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":"Quý 2"}},{"$f":"YEAR('Mục nhập Dữ liệu'!$B12)","v":2013},{"$f":"MONTH(tblData[[#This Row],[NGÀY]])","v":6},{"$f":"SUMIFS(tblData[SỐ TIỀN],tblData[NGÀY],\">=\"&EOMONTH(tblData[[#This Row],[NGÀY]],-1)+1,tblData[NGÀY],\"<=\"&EOMONTH(tblData[[#This Row],[NGÀY]],0))","v":{"v":299520000,"d":"₫299,520,000"}},{"$f":"SUMIFS(tblData[SỐ TIỀN],tblData[NGÀY],\">=\"&DATE(YEAR(tblData[[#This Row],[NGÀY]]),1,1),tblData[NGÀY],\"<=\"&DATE(YEAR(tblData[[#This Row],[NGÀY]]),12,31),tblData[QUÝ],tblData[[#This Row],[QUÝ]])","v":{"v":1056640000,"d":"₫1,056,640,000"}},{"$f":"SUMIFS(tblData[SỐ TIỀN],tblData[NGÀY],\">=\"&DATE(YEAR(tblData[[#This Row],[NGÀY]]),1,1),tblData[NGÀY],\"<=\"&DATE(YEAR(tblData[[#This Row],[NGÀY]]),12,31))","v":{"v":2991040000,"d":"₫2,991,040,000"}},{"$f":"IFERROR(TREND($L$6:INDEX($L:$L,ROW(),1),$K$6:INDEX($K:$K,ROW(),1),IF(MONTH(tblData[[#This Row],[NGÀY]])=12,13,MONTH(tblData[[#This Row],[NGÀY]])+1)),\"\")","v":{"v":449280000,"d":"₫449,280,000"}},{"$f":"IFERROR(TREND($M$6:INDEX($M:$M,ROW(),1),$I$6:INDEX($I:$I,ROW(),1),IF(tblData[[#This Row],[QUÝ]]=4,5,tblData[[#This Row],[QUÝ]]+1)),\"\")","v":{"v":1056640000,"d":"₫1,056,640,000"}},{"$f":"IFERROR(TREND($N$6:INDEX($N:$N,ROW(),1),$J$6:INDEX($J:$J,ROW(),1),tblData[[#This Row],[NĂM]]+1),\"\")","v":{"v":2991040000,"d":"₫2,991,040,000"}}]
[null,{"$f":"40716+(365*2)","v":"2013-06-21"},"Contoso Pharmaceuticals",{"v":156000000,"d":"₫156,000,000"},{"v":149760000,"d":"₫149,760,000"},{"v":135200000,"d":"₫135,200,000"},{"$f":"tblData[[#This Row],[SỐ TIỀN]]-tblData[[#This Row],[CHI PHÍ]]","v":{"v":20800000,"d":"₫20,800,000"}},{"$f":"DATE(YEAR('Mục nhập Dữ liệu'!$B13),MONTH('Mục nhập Dữ liệu'!$B13),1)","v":"2013-06-01"},{"$f":"LOOKUP(MONTH('Mục nhập Dữ liệu'!$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":"Quý 2"}},{"$f":"YEAR('Mục nhập Dữ liệu'!$B13)","v":2013},{"$f":"MONTH(tblData[[#This Row],[NGÀY]])","v":6},{"$f":"SUMIFS(tblData[SỐ TIỀN],tblData[NGÀY],\">=\"&EOMONTH(tblData[[#This Row],[NGÀY]],-1)+1,tblData[NGÀY],\"<=\"&EOMONTH(tblData[[#This Row],[NGÀY]],0))","v":{"v":299520000,"d":"₫299,520,000"}},{"$f":"SUMIFS(tblData[SỐ TIỀN],tblData[NGÀY],\">=\"&DATE(YEAR(tblData[[#This Row],[NGÀY]]),1,1),tblData[NGÀY],\"<=\"&DATE(YEAR(tblData[[#This Row],[NGÀY]]),12,31),tblData[QUÝ],tblData[[#This Row],[QUÝ]])","v":{"v":1056640000,"d":"₫1,056,640,000"}},{"$f":"SUMIFS(tblData[SỐ TIỀN],tblData[NGÀY],\">=\"&DATE(YEAR(tblData[[#This Row],[NGÀY]]),1,1),tblData[NGÀY],\"<=\"&DATE(YEAR(tblData[[#This Row],[NGÀY]]),12,31))","v":{"v":2991040000,"d":"₫2,991,040,000"}},{"$f":"IFERROR(TREND($L$6:INDEX($L:$L,ROW(),1),$K$6:INDEX($K:$K,ROW(),1),IF(MONTH(tblData[[#This Row],[NGÀY]])=12,13,MONTH(tblData[[#This Row],[NGÀY]])+1)),\"\")","v":{"v":373360000,"d":"₫373,360,000"}},{"$f":"IFERROR(TREND($M$6:INDEX($M:$M,ROW(),1),$I$6:INDEX($I:$I,ROW(),1),IF(tblData[[#This Row],[QUÝ]]=4,5,tblData[[#This Row],[QUÝ]]+1)),\"\")","v":{"v":1056640000,"d":"₫1,056,640,000"}},{"$f":"IFERROR(TREND($N$6:INDEX($N:$N,ROW(),1),$J$6:INDEX($J:$J,ROW(),1),tblData[[#This Row],[NĂM]]+1),\"\")","v":{"v":2991040000,"d":"₫2,991,040,000"}}]
[null,{"$f":"40731+(365*2)","v":"2013-07-06"},"Consolidated Messenger",{"v":180960000,"d":"₫180,960,000"},{"v":176800000,"d":"₫176,800,000"},{"v":150800000,"d":"₫150,800,000"},{"$f":"tblData[[#This Row],[SỐ TIỀN]]-tblData[[#This Row],[CHI PHÍ]]","v":{"v":30160000,"d":"₫30,160,000"}},{"$f":"DATE(YEAR('Mục nhập Dữ liệu'!$B14),MONTH('Mục nhập Dữ liệu'!$B14),1)","v":"2013-07-01"},{"$f":"LOOKUP(MONTH('Mục nhập Dữ liệu'!$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":"Quý 3"}},{"$f":"YEAR('Mục nhập Dữ liệu'!$B14)","v":2013},{"$f":"MONTH(tblData[[#This Row],[NGÀY]])","v":7},{"$f":"SUMIFS(tblData[SỐ TIỀN],tblData[NGÀY],\">=\"&EOMONTH(tblData[[#This Row],[NGÀY]],-1)+1,tblData[NGÀY],\"<=\"&EOMONTH(tblData[[#This Row],[NGÀY]],0))","v":{"v":180960000,"d":"₫180,960,000"}},{"$f":"SUMIFS(tblData[SỐ TIỀN],tblData[NGÀY],\">=\"&DATE(YEAR(tblData[[#This Row],[NGÀY]]),1,1),tblData[NGÀY],\"<=\"&DATE(YEAR(tblData[[#This Row],[NGÀY]]),12,31),tblData[QUÝ],tblData[[#This Row],[QUÝ]])","v":{"v":1021280000,"d":"₫1,021,280,000"}},{"$f":"SUMIFS(tblData[SỐ TIỀN],tblData[NGÀY],\">=\"&DATE(YEAR(tblData[[#This Row],[NGÀY]]),1,1),tblData[NGÀY],\"<=\"&DATE(YEAR(tblData[[#This Row],[NGÀY]]),12,31))","v":{"v":2991040000,"d":"₫2,991,040,000"}},{"$f":"IFERROR(TREND($L$6:INDEX($L:$L,ROW(),1),$K$6:INDEX($K:$K,ROW(),1),IF(MONTH(tblData[[#This Row],[NGÀY]])=12,13,MONTH(tblData[[#This Row],[NGÀY]])+1)),\"\")","v":{"v":224150588.23529416,"d":"₫224,150,588"}},{"$f":"IFERROR(TREND($M$6:INDEX($M:$M,ROW(),1),$I$6:INDEX($I:$I,ROW(),1),IF(tblData[[#This Row],[QUÝ]]=4,5,tblData[[#This Row],[QUÝ]]+1)),\"\")","v":{"v":985920000,"d":"₫985,920,000"}},{"$f":"IFERROR(TREND($N$6:INDEX($N:$N,ROW(),1),$J$6:INDEX($J:$J,ROW(),1),tblData[[#This Row],[NĂM]]+1),\"\")","v":{"v":2991040000,"d":"₫2,991,040,000"}}]
[null,{"$f":"40761+(365*2)","v":"2013-08-05"},"Proseware, Inc.",{"v":176800000,"d":"₫176,800,000"},{"v":172640000,"d":"₫172,640,000"},{"v":147680000,"d":"₫147,680,000"},{"$f":"tblData[[#This Row],[SỐ TIỀN]]-tblData[[#This Row],[CHI PHÍ]]","v":{"v":29120000,"d":"₫29,120,000"}},{"$f":"DATE(YEAR('Mục nhập Dữ liệu'!$B15),MONTH('Mục nhập Dữ liệu'!$B15),1)","v":"2013-08-01"},{"$f":"LOOKUP(MONTH('Mục nhập Dữ liệu'!$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":"Quý 3"}},{"$f":"YEAR('Mục nhập Dữ liệu'!$B15)","v":2013},{"$f":"MONTH(tblData[[#This Row],[NGÀY]])","v":8},{"$f":"SUMIFS(tblData[SỐ TIỀN],tblData[NGÀY],\">=\"&EOMONTH(tblData[[#This Row],[NGÀY]],-1)+1,tblData[NGÀY],\"<=\"&EOMONTH(tblData[[#This Row],[NGÀY]],0))","v":{"v":341120000,"d":"₫341,120,000"}},{"$f":"SUMIFS(tblData[SỐ TIỀN],tblData[NGÀY],\">=\"&DATE(YEAR(tblData[[#This Row],[NGÀY]]),1,1),tblData[NGÀY],\"<=\"&DATE(YEAR(tblData[[#This Row],[NGÀY]]),12,31),tblData[QUÝ],tblData[[#This Row],[QUÝ]])","v":{"v":1021280000,"d":"₫1,021,280,000"}},{"$f":"SUMIFS(tblData[SỐ TIỀN],tblData[NGÀY],\">=\"&DATE(YEAR(tblData[[#This Row],[NGÀY]]),1,1),tblData[NGÀY],\"<=\"&DATE(YEAR(tblData[[#This Row],[NGÀY]]),12,31))","v":{"v":2991040000,"d":"₫2,991,040,000"}},{"$f":"IFERROR(TREND($L$6:INDEX($L:$L,ROW(),1),$K$6:INDEX($K:$K,ROW(),1),IF(MONTH(tblData[[#This Row],[NGÀY]])=12,13,MONTH(tblData[[#This Row],[NGÀY]])+1)),\"\")","v":{"v":259081931.03448275,"d":"₫259,081,931"}},{"$f":"IFERROR(TREND($M$6:INDEX($M:$M,ROW(),1),$I$6:INDEX($I:$I,ROW(),1),IF(tblData[[#This Row],[QUÝ]]=4,5,tblData[[#This Row],[QUÝ]]+1)),\"\")","v":{"v":985920000,"d":"₫985,920,000"}},{"$f":"IFERROR(TREND($N$6:INDEX($N:$N,ROW(),1),$J$6:INDEX($J:$J,ROW(),1),tblData[[#This Row],[NĂM]]+1),\"\")","v":{"v":2991040000,"d":"₫2,991,040,000"}}]
[null,{"$f":"40775+(365*2)","v":"2013-08-19"},"Trường Mỹ thuật",{"v":164320000,"d":"₫164,320,000"},{"v":160160000,"d":"₫160,160,000"},{"v":137280000,"d":"₫137,280,000"},{"$f":"tblData[[#This Row],[SỐ TIỀN]]-tblData[[#This Row],[CHI PHÍ]]","v":{"v":27040000,"d":"₫27,040,000"}},{"$f":"DATE(YEAR('Mục nhập Dữ liệu'!$B16),MONTH('Mục nhập Dữ liệu'!$B16),1)","v":"2013-08-01"},{"$f":"LOOKUP(MONTH('Mục nhập Dữ liệu'!$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":"Quý 3"}},{"$f":"YEAR('Mục nhập Dữ liệu'!$B16)","v":2013},{"$f":"MONTH(tblData[[#This Row],[NGÀY]])","v":8},{"$f":"SUMIFS(tblData[SỐ TIỀN],tblData[NGÀY],\">=\"&EOMONTH(tblData[[#This Row],[NGÀY]],-1)+1,tblData[NGÀY],\"<=\"&EOMONTH(tblData[[#This Row],[NGÀY]],0))","v":{"v":341120000,"d":"₫341,120,000"}},{"$f":"SUMIFS(tblData[SỐ TIỀN],tblData[NGÀY],\">=\"&DATE(YEAR(tblData[[#This Row],[NGÀY]]),1,1),tblData[NGÀY],\"<=\"&DATE(YEAR(tblData[[#This Row],[NGÀY]]),12,31),tblData[QUÝ],tblData[[#This Row],[QUÝ]])","v":{"v":1021280000,"d":"₫1,021,280,000"}},{"$f":"SUMIFS(tblData[SỐ TIỀN],tblData[NGÀY],\">=\"&DATE(YEAR(tblData[[#This Row],[NGÀY]]),1,1),tblData[NGÀY],\"<=\"&DATE(YEAR(tblData[[#This Row],[NGÀY]]),12,31))","v":{"v":2991040000,"d":"₫2,991,040,000"}},{"$f":"IFERROR(TREND($L$6:INDEX($L:$L,ROW(),1),$K$6:INDEX($K:$K,ROW(),1),IF(MONTH(tblData[[#This Row],[NGÀY]])=12,13,MONTH(tblData[[#This Row],[NGÀY]])+1)),\"\")","v":{"v":284285405.4054053,"d":"₫284,285,405"}},{"$f":"IFERROR(TREND($M$6:INDEX($M:$M,ROW(),1),$I$6:INDEX($I:$I,ROW(),1),IF(tblData[[#This Row],[QUÝ]]=4,5,tblData[[#This Row],[QUÝ]]+1)),\"\")","v":{"v":985920000,"d":"₫985,920,000"}},{"$f":"IFERROR(TREND($N$6:INDEX($N:$N,ROW(),1),$J$6:INDEX($J:$J,ROW(),1),tblData[[#This Row],[NĂM]]+1),\"\")","v":{"v":2991040000,"d":"₫2,991,040,000"}}]
[null,{"$f":"40791+(365*2)","v":"2013-09-04"},"Trey Research",{"v":189280000,"d":"₫189,280,000"},{"v":185120000,"d":"₫185,120,000"},{"v":164320000,"d":"₫164,320,000"},{"$f":"tblData[[#This Row],[SỐ TIỀN]]-tblData[[#This Row],[CHI PHÍ]]","v":{"v":24960000,"d":"₫24,960,000"}},{"$f":"DATE(YEAR('Mục nhập Dữ liệu'!$B17),MONTH('Mục nhập Dữ liệu'!$B17),1)","v":"2013-09-01"},{"$f":"LOOKUP(MONTH('Mục nhập Dữ liệu'!$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":"Quý 3"}},{"$f":"YEAR('Mục nhập Dữ liệu'!$B17)","v":2013},{"$f":"MONTH(tblData[[#This Row],[NGÀY]])","v":9},{"$f":"SUMIFS(tblData[SỐ TIỀN],tblData[NGÀY],\">=\"&EOMONTH(tblData[[#This Row],[NGÀY]],-1)+1,tblData[NGÀY],\"<=\"&EOMONTH(tblData[[#This Row],[NGÀY]],0))","v":{"v":499200000,"d":"₫499,200,000"}},{"$f":"SUMIFS(tblData[SỐ TIỀN],tblData[NGÀY],\">=\"&DATE(YEAR(tblData[[#This Row],[NGÀY]]),1,1),tblData[NGÀY],\"<=\"&DATE(YEAR(tblData[[#This Row],[NGÀY]]),12,31),tblData[QUÝ],tblData[[#This Row],[QUÝ]])","v":{"v":1021280000,"d":"₫1,021,280,000"}},{"$f":"SUMIFS(tblData[SỐ TIỀN],tblData[NGÀY],\">=\"&DATE(YEAR(tblData[[#This Row],[NGÀY]]),1,1),tblData[NGÀY],\"<=\"&DATE(YEAR(tblData[[#This Row],[NGÀY]]),12,31))","v":{"v":2991040000,"d":"₫2,991,040,000"}},{"$f":"IFERROR(TREND($L$6:INDEX($L:$L,ROW(),1),$K$6:INDEX($K:$K,ROW(),1),IF(MONTH(tblData[[#This Row],[NGÀY]])=12,13,MONTH(tblData[[#This Row],[NGÀY]])+1)),\"\")","v":{"v":367154666.6666667,"d":"₫367,154,667"}},{"$f":"IFERROR(TREND($M$6:INDEX($M:$M,ROW(),1),$I$6:INDEX($I:$I,ROW(),1),IF(tblData[[#This Row],[QUÝ]]=4,5,tblData[[#This Row],[QUÝ]]+1)),\"\")","v":{"v":985920000,"d":"₫985,920,000"}},{"$f":"IFERROR(TREND($N$6:INDEX($N:$N,ROW(),1),$J$6:INDEX($J:$J,ROW(),1),tblData[[#This Row],[NĂM]]+1),\"\")","v":{"v":2991040000,"d":"₫2,991,040,000"}}]
[null,{"$f":"40807+(365*2)","v":"2013-09-20"},"Contoso Pharmaceuticals",{"v":116480000,"d":"₫116,480,000"},{"v":120640000,"d":"₫120,640,000"},{"v":93600000,"d":"₫93,600,000"},{"$f":"tblData[[#This Row],[SỐ TIỀN]]-tblData[[#This Row],[CHI PHÍ]]","v":{"v":22880000,"d":"₫22,880,000"}},{"$f":"DATE(YEAR('Mục nhập Dữ liệu'!$B18),MONTH('Mục nhập Dữ liệu'!$B18),1)","v":"2013-09-01"},{"$f":"LOOKUP(MONTH('Mục nhập Dữ liệu'!$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":"Quý 3"}},{"$f":"YEAR('Mục nhập Dữ liệu'!$B18)","v":2013},{"$f":"MONTH(tblData[[#This Row],[NGÀY]])","v":9},{"$f":"SUMIFS(tblData[SỐ TIỀN],tblData[NGÀY],\">=\"&EOMONTH(tblData[[#This Row],[NGÀY]],-1)+1,tblData[NGÀY],\"<=\"&EOMONTH(tblData[[#This Row],[NGÀY]],0))","v":{"v":499200000,"d":"₫499,200,000"}},{"$f":"SUMIFS(tblData[SỐ TIỀN],tblData[NGÀY],\">=\"&DATE(YEAR(tblData[[#This Row],[NGÀY]]),1,1),tblData[NGÀY],\"<=\"&DATE(YEAR(tblData[[#This Row],[NGÀY]]),12,31),tblData[QUÝ],tblData[[#This Row],[QUÝ]])","v":{"v":1021280000,"d":"₫1,021,280,000"}},{"$f":"SUMIFS(tblData[SỐ TIỀN],tblData[NGÀY],\">=\"&DATE(YEAR(tblData[[#This Row],[NGÀY]]),1,1),tblData[NGÀY],\"<=\"&DATE(YEAR(tblData[[#This Row],[NGÀY]]),12,31))","v":{"v":2991040000,"d":"₫2,991,040,000"}},{"$f":"IFERROR(TREND($L$6:INDEX($L:$L,ROW(),1),$K$6:INDEX($K:$K,ROW(),1),IF(MONTH(tblData[[#This Row],[NGÀY]])=12,13,MONTH(tblData[[#This Row],[NGÀY]])+1)),\"\")","v":{"v":413460562.248996,"d":"₫413,460,562"}},{"$f":"IFERROR(TREND($M$6:INDEX($M:$M,ROW(),1),$I$6:INDEX($I:$I,ROW(),1),IF(tblData[[#This Row],[QUÝ]]=4,5,tblData[[#This Row],[QUÝ]]+1)),\"\")","v":{"v":985920000,"d":"₫985,920,000"}},{"$f":"IFERROR(TREND($N$6:INDEX($N:$N,ROW(),1),$J$6:INDEX($J:$J,ROW(),1),tblData[[#This Row],[NĂM]]+1),\"\")","v":{"v":2991040000,"d":"₫2,991,040,000"}}]
[null,{"$f":"40812+(365*2)","v":"2013-09-25"},"Consolidated Messenger",{"v":193440000,"d":"₫193,440,000"},{"v":189280000,"d":"₫189,280,000"},{"v":156000000,"d":"₫156,000,000"},{"$f":"tblData[[#This Row],[SỐ TIỀN]]-tblData[[#This Row],[CHI PHÍ]]","v":{"v":37440000,"d":"₫37,440,000"}},{"$f":"DATE(YEAR('Mục nhập Dữ liệu'!$B19),MONTH('Mục nhập Dữ liệu'!$B19),1)","v":"2013-09-01"},{"$f":"LOOKUP(MONTH('Mục nhập Dữ liệu'!$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":"Quý 3"}},{"$f":"YEAR('Mục nhập Dữ liệu'!$B19)","v":2013},{"$f":"MONTH(tblData[[#This Row],[NGÀY]])","v":9},{"$f":"SUMIFS(tblData[SỐ TIỀN],tblData[NGÀY],\">=\"&EOMONTH(tblData[[#This Row],[NGÀY]],-1)+1,tblData[NGÀY],\"<=\"&EOMONTH(tblData[[#This Row],[NGÀY]],0))","v":{"v":499200000,"d":"₫499,200,000"}},{"$f":"SUMIFS(tblData[SỐ TIỀN],tblData[NGÀY],\">=\"&DATE(YEAR(tblData[[#This Row],[NGÀY]]),1,1),tblData[NGÀY],\"<=\"&DATE(YEAR(tblData[[#This Row],[NGÀY]]),12,31),tblData[QUÝ],tblData[[#This Row],[QUÝ]])","v":{"v":1021280000,"d":"₫1,021,280,000"}},{"$f":"SUMIFS(tblData[SỐ TIỀN],tblData[NGÀY],\">=\"&DATE(YEAR(tblData[[#This Row],[NGÀY]]),1,1),tblData[NGÀY],\"<=\"&DATE(YEAR(tblData[[#This Row],[NGÀY]]),12,31))","v":{"v":2991040000,"d":"₫2,991,040,000"}},{"$f":"IFERROR(TREND($L$6:INDEX($L:$L,ROW(),1),$K$6:INDEX($K:$K,ROW(),1),IF(MONTH(tblData[[#This Row],[NGÀY]])=12,13,MONTH(tblData[[#This Row],[NGÀY]])+1)),\"\")","v":{"v":439671446.5408805,"d":"₫439,671,447"}},{"$f":"IFERROR(TREND($M$6:INDEX($M:$M,ROW(),1),$I$6:INDEX($I:$I,ROW(),1),IF(tblData[[#This Row],[QUÝ]]=4,5,tblData[[#This Row],[QUÝ]]+1)),\"\")","v":{"v":985920000,"d":"₫985,920,000"}},{"$f":"IFERROR(TREND($N$6:INDEX($N:$N,ROW(),1),$J$6:INDEX($J:$J,ROW(),1),tblData[[#This Row],[NĂM]]+1),\"\")","v":{"v":2991040000,"d":"₫2,991,040,000"}}]
[null,{"$f":"40832+(365*2)","v":"2013-10-15"},"Proseware, Inc.",{"v":183040000,"d":"₫183,040,000"},{"v":194480000,"d":"₫194,480,000"},{"v":147680000,"d":"₫147,680,000"},{"$f":"tblData[[#This Row],[SỐ TIỀN]]-tblData[[#This Row],[CHI PHÍ]]","v":{"v":35360000,"d":"₫35,360,000"}},{"$f":"DATE(YEAR('Mục nhập Dữ liệu'!$B20),MONTH('Mục nhập Dữ liệu'!$B20),1)","v":"2013-10-01"},{"$f":"LOOKUP(MONTH('Mục nhập Dữ liệu'!$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":"Quý 4"}},{"$f":"YEAR('Mục nhập Dữ liệu'!$B20)","v":2013},{"$f":"MONTH(tblData[[#This Row],[NGÀY]])","v":10},{"$f":"SUMIFS(tblData[SỐ TIỀN],tblData[NGÀY],\">=\"&EOMONTH(tblData[[#This Row],[NGÀY]],-1)+1,tblData[NGÀY],\"<=\"&EOMONTH(tblData[[#This Row],[NGÀY]],0))","v":{"v":183040000,"d":"₫183,040,000"}},{"$f":"SUMIFS(tblData[SỐ TIỀN],tblData[NGÀY],\">=\"&DATE(YEAR(tblData[[#This Row],[NGÀY]]),1,1),tblData[NGÀY],\"<=\"&DATE(YEAR(tblData[[#This Row],[NGÀY]]),12,31),tblData[QUÝ],tblData[[#This Row],[QUÝ]])","v":{"v":913120000,"d":"₫913,120,000"}},{"$f":"SUMIFS(tblData[SỐ TIỀN],tblData[NGÀY],\">=\"&DATE(YEAR(tblData[[#This Row],[NGÀY]]),1,1),tblData[NGÀY],\"<=\"&DATE(YEAR(tblData[[#This Row],[NGÀY]]),12,31))","v":{"v":2991040000,"d":"₫2,991,040,000"}},{"$f":"IFERROR(TREND($L$6:INDEX($L:$L,ROW(),1),$K$6:INDEX($K:$K,ROW(),1),IF(MONTH(tblData[[#This Row],[NGÀY]])=12,13,MONTH(tblData[[#This Row],[NGÀY]])+1)),\"\")","v":{"v":373396279.0697674,"d":"₫373,396,279"}},{"$f":"IFERROR(TREND($M$6:INDEX($M:$M,ROW(),1),$I$6:INDEX($I:$I,ROW(),1),IF(tblData[[#This Row],[QUÝ]]=4,5,tblData[[#This Row],[QUÝ]]+1)),\"\")","v":{"v":899769302.3255813,"d":"₫899,769,302"}},{"$f":"IFERROR(TREND($N$6:INDEX($N:$N,ROW(),1),$J$6:INDEX($J:$J,ROW(),1),tblData[[#This Row],[NĂM]]+1),\"\")","v":{"v":2991040000,"d":"₫2,991,040,000"}}]
[null,{"$f":"40853+(365*2)","v":"2013-11-05"},"Trường Mỹ thuật",{"v":189280000,"d":"₫189,280,000"},{"v":191360000,"d":"₫191,360,000"},{"v":163280000,"d":"₫163,280,000"},{"$f":"tblData[[#This Row],[SỐ TIỀN]]-tblData[[#This Row],[CHI PHÍ]]","v":{"v":26000000,"d":"₫26,000,000"}},{"$f":"DATE(YEAR('Mục nhập Dữ liệu'!$B21),MONTH('Mục nhập Dữ liệu'!$B21),1)","v":"2013-11-01"},{"$f":"LOOKUP(MONTH('Mục nhập Dữ liệu'!$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":"Quý 4"}},{"$f":"YEAR('Mục nhập Dữ liệu'!$B21)","v":2013},{"$f":"MONTH(tblData[[#This Row],[NGÀY]])","v":11},{"$f":"SUMIFS(tblData[SỐ TIỀN],tblData[NGÀY],\">=\"&EOMONTH(tblData[[#This Row],[NGÀY]],-1)+1,tblData[NGÀY],\"<=\"&EOMONTH(tblData[[#This Row],[NGÀY]],0))","v":{"v":532480000,"d":"₫532,480,000"}},{"$f":"SUMIFS(tblData[SỐ TIỀN],tblData[NGÀY],\">=\"&DATE(YEAR(tblData[[#This Row],[NGÀY]]),1,1),tblData[NGÀY],\"<=\"&DATE(YEAR(tblData[[#This Row],[NGÀY]]),12,31),tblData[QUÝ],tblData[[#This Row],[QUÝ]])","v":{"v":913120000,"d":"₫913,120,000"}},{"$f":"SUMIFS(tblData[SỐ TIỀN],tblData[NGÀY],\">=\"&DATE(YEAR(tblData[[#This Row],[NGÀY]]),1,1),tblData[NGÀY],\"<=\"&DATE(YEAR(tblData[[#This Row],[NGÀY]]),12,31))","v":{"v":2991040000,"d":"₫2,991,040,000"}},{"$f":"IFERROR(TREND($L$6:INDEX($L:$L,ROW(),1),$K$6:INDEX($K:$K,ROW(),1),IF(MONTH(tblData[[#This Row],[NGÀY]])=12,13,MONTH(tblData[[#This Row],[NGÀY]])+1)),\"\")","v":{"v":427567506.25521266,"d":"₫427,567,506"}},{"$f":"IFERROR(TREND($M$6:INDEX($M:$M,ROW(),1),$I$6:INDEX($I:$I,ROW(),1),IF(tblData[[#This Row],[QUÝ]]=4,5,tblData[[#This Row],[QUÝ]]+1)),\"\")","v":{"v":880108387.0967743,"d":"₫880,108,387"}},{"$f":"IFERROR(TREND($N$6:INDEX($N:$N,ROW(),1),$J$6:INDEX($J:$J,ROW(),1),tblData[[#This Row],[NĂM]]+1),\"\")","v":{"v":2991040000,"d":"₫2,991,040,000"}}]
[null,{"$f":"40874+(365*2)","v":"2013-11-26"},"Trey Research",{"v":187200000,"d":"₫187,200,000"},{"v":208000000,"d":"₫208,000,000"},{"v":157560000,"d":"₫157,560,000"},{"$f":"tblData[[#This Row],[SỐ TIỀN]]-tblData[[#This Row],[CHI PHÍ]]","v":{"v":29640000,"d":"₫29,640,000"}},{"$f":"DATE(YEAR('Mục nhập Dữ liệu'!$B22),MONTH('Mục nhập Dữ liệu'!$B22),1)","v":"2013-11-01"},{"$f":"LOOKUP(MONTH('Mục nhập Dữ liệu'!$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":"Quý 4"}},{"$f":"YEAR('Mục nhập Dữ liệu'!$B22)","v":2013},{"$f":"MONTH(tblData[[#This Row],[NGÀY]])","v":11},{"$f":"SUMIFS(tblData[SỐ TIỀN],tblData[NGÀY],\">=\"&EOMONTH(tblData[[#This Row],[NGÀY]],-1)+1,tblData[NGÀY],\"<=\"&EOMONTH(tblData[[#This Row],[NGÀY]],0))","v":{"v":532480000,"d":"₫532,480,000"}},{"$f":"SUMIFS(tblData[SỐ TIỀN],tblData[NGÀY],\">=\"&DATE(YEAR(tblData[[#This Row],[NGÀY]]),1,1),tblData[NGÀY],\"<=\"&DATE(YEAR(tblData[[#This Row],[NGÀY]]),12,31),tblData[QUÝ],tblData[[#This Row],[QUÝ]])","v":{"v":913120000,"d":"₫913,120,000"}},{"$f":"SUMIFS(tblData[SỐ TIỀN],tblData[NGÀY],\">=\"&DATE(YEAR(tblData[[#This Row],[NGÀY]]),1,1),tblData[NGÀY],\"<=\"&DATE(YEAR(tblData[[#This Row],[NGÀY]]),12,31))","v":{"v":2991040000,"d":"₫2,991,040,000"}},{"$f":"IFERROR(TREND($L$6:INDEX($L:$L,ROW(),1),$K$6:INDEX($K:$K,ROW(),1),IF(MONTH(tblData[[#This Row],[NGÀY]])=12,13,MONTH(tblData[[#This Row],[NGÀY]])+1)),\"\")","v":{"v":457540494.1482445,"d":"₫457,540,494"}},{"$f":"IFERROR(TREND($M$6:INDEX($M:$M,ROW(),1),$I$6:INDEX($I:$I,ROW(),1),IF(tblData[[#This Row],[QUÝ]]=4,5,tblData[[#This Row],[QUÝ]]+1)),\"\")","v":{"v":869671111.1111113,"d":"₫869,671,111"}},{"$f":"IFERROR(TREND($N$6:INDEX($N:$N,ROW(),1),$J$6:INDEX($J:$J,ROW(),1),tblData[[#This Row],[NĂM]]+1),\"\")","v":{"v":2991040000,"d":"₫2,991,040,000"}}]
[null,{"$f":"40878+(365*2)","v":"2013-11-30"},"Trey Research",{"v":156000000,"d":"₫156,000,000"},{"v":166400000,"d":"₫166,400,000"},{"v":121680000,"d":"₫121,680,000"},{"$f":"tblData[[#This Row],[SỐ TIỀN]]-tblData[[#This Row],[CHI PHÍ]]","v":{"v":34320000,"d":"₫34,320,000"}},{"$f":"DATE(YEAR('Mục nhập Dữ liệu'!$B23),MONTH('Mục nhập Dữ liệu'!$B23),1)","v":"2013-11-01"},{"$f":"LOOKUP(MONTH('Mục nhập Dữ liệu'!$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":"Quý 4"}},{"$f":"YEAR('Mục nhập Dữ liệu'!$B23)","v":2013},{"$f":"MONTH(tblData[[#This Row],[NGÀY]])","v":11},{"$f":"SUMIFS(tblData[SỐ TIỀN],tblData[NGÀY],\">=\"&EOMONTH(tblData[[#This Row],[NGÀY]],-1)+1,tblData[NGÀY],\"<=\"&EOMONTH(tblData[[#This Row],[NGÀY]],0))","v":{"v":532480000,"d":"₫532,480,000"}},{"$f":"SUMIFS(tblData[SỐ TIỀN],tblData[NGÀY],\">=\"&DATE(YEAR(tblData[[#This Row],[NGÀY]]),1,1),tblData[NGÀY],\"<=\"&DATE(YEAR(tblData[[#This Row],[NGÀY]]),12,31),tblData[QUÝ],tblData[[#This Row],[QUÝ]])","v":{"v":913120000,"d":"₫913,120,000"}},{"$f":"SUMIFS(tblData[SỐ TIỀN],tblData[NGÀY],\">=\"&DATE(YEAR(tblData[[#This Row],[NGÀY]]),1,1),tblData[NGÀY],\"<=\"&DATE(YEAR(tblData[[#This Row],[NGÀY]]),12,31))","v":{"v":2991040000,"d":"₫2,991,040,000"}},{"$f":"IFERROR(TREND($L$6:INDEX($L:$L,ROW(),1),$K$6:INDEX($K:$K,ROW(),1),IF(MONTH(tblData[[#This Row],[NGÀY]])=12,13,MONTH(tblData[[#This Row],[NGÀY]])+1)),\"\")","v":{"v":476686798.0820458,"d":"₫476,686,798"}},{"$f":"IFERROR(TREND($M$6:INDEX($M:$M,ROW(),1),$I$6:INDEX($I:$I,ROW(),1),IF(tblData[[#This Row],[QUÝ]]=4,5,tblData[[#This Row],[QUÝ]]+1)),\"\")","v":{"v":863200000,"d":"₫863,200,000"}},{"$f":"IFERROR(TREND($N$6:INDEX($N:$N,ROW(),1),$J$6:INDEX($J:$J,ROW(),1),tblData[[#This Row],[NĂM]]+1),\"\")","v":{"v":2991040000,"d":"₫2,991,040,000"}}]
[null,{"$f":"40889+(365*2)","v":"2013-12-11"},"Contoso Pharmaceuticals",{"v":197600000,"d":"₫197,600,000"},{"v":191360000,"d":"₫191,360,000"},{"v":176800000,"d":"₫176,800,000"},{"$f":"tblData[[#This Row],[SỐ TIỀN]]-tblData[[#This Row],[CHI PHÍ]]","v":{"v":20800000,"d":"₫20,800,000"}},{"$f":"DATE(YEAR('Mục nhập Dữ liệu'!$B24),MONTH('Mục nhập Dữ liệu'!$B24),1)","v":"2013-12-01"},{"$f":"LOOKUP(MONTH('Mục nhập Dữ liệu'!$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":"Quý 4"}},{"$f":"YEAR('Mục nhập Dữ liệu'!$B24)","v":2013},{"$f":"MONTH(tblData[[#This Row],[NGÀY]])","v":12},{"$f":"SUMIFS(tblData[SỐ TIỀN],tblData[NGÀY],\">=\"&EOMONTH(tblData[[#This Row],[NGÀY]],-1)+1,tblData[NGÀY],\"<=\"&EOMONTH(tblData[[#This Row],[NGÀY]],0))","v":{"v":197600000,"d":"₫197,600,000"}},{"$f":"SUMIFS(tblData[SỐ TIỀN],tblData[NGÀY],\">=\"&DATE(YEAR(tblData[[#This Row],[NGÀY]]),1,1),tblData[NGÀY],\"<=\"&DATE(YEAR(tblData[[#This Row],[NGÀY]]),12,31),tblData[QUÝ],tblData[[#This Row],[QUÝ]])","v":{"v":913120000,"d":"₫913,120,000"}},{"$f":"SUMIFS(tblData[SỐ TIỀN],tblData[NGÀY],\">=\"&DATE(YEAR(tblData[[#This Row],[NGÀY]]),1,1),tblData[NGÀY],\"<=\"&DATE(YEAR(tblData[[#This Row],[NGÀY]]),12,31))","v":{"v":2991040000,"d":"₫2,991,040,000"}},{"$f":"IFERROR(TREND($L$6:INDEX($L:$L,ROW(),1),$K$6:INDEX($K:$K,ROW(),1),IF(MONTH(tblData[[#This Row],[NGÀY]])=12,13,MONTH(tblData[[#This Row],[NGÀY]])+1)),\"\")","v":{"v":426489746.1928934,"d":"₫426,489,746"}},{"$f":"IFERROR(TREND($M$6:INDEX($M:$M,ROW(),1),$I$6:INDEX($I:$I,ROW(),1),IF(tblData[[#This Row],[QUÝ]]=4,5,tblData[[#This Row],[QUÝ]]+1)),\"\")","v":{"v":858795294.1176472,"d":"₫858,795,294"}},{"$f":"IFERROR(TREND($N$6:INDEX($N:$N,ROW(),1),$J$6:INDEX($J:$J,ROW(),1),tblData[[#This Row],[NĂM]]+1),\"\")","v":{"v":2991040000,"d":"₫2,991,040,000"}}]

{"sheet":"Báo cáo Bán hàng","index":1,"n_rows":28,"n_cols":6,"rows_kept":28}
[]
[null,"BÁO CÁO BÁN HÀNG HÀNG THÁNG"]
[]
[]
[null,"NĂM","QUÝ","THÁNG","CÔNG TY","Tổng của SỐ TIỀN"]
[null,2013,{"v":2,"d":"Quý 2"},"2013-04-01","A. Datum Corporation",{"v":133120000,"d":"₫133,120,000"}]
[{"$nulls":4},"Contoso Pharmaceuticals",{"v":170560000,"d":"₫170,560,000"}]
[{"$nulls":3},"2013-05-01","Consolidated Messenger",{"v":91520000,"d":"₫91,520,000"}]
[{"$nulls":4},"Proseware, Inc.",{"v":112320000,"d":"₫112,320,000"}]
[{"$nulls":4},"Trey Research",{"v":128960000,"d":"₫128,960,000"}]
[{"$nulls":4},"Trường Mỹ thuật2",{"v":120640000,"d":"₫120,640,000"}]
[{"$nulls":3},"2013-06-01","A. Datum Corporation",{"v":143520000,"d":"₫143,520,000"}]
[{"$nulls":4},"Contoso Pharmaceuticals",{"v":156000000,"d":"₫156,000,000"}]
[null,null,"Quarter 2 Tổng",null,null,{"v":1056640000,"d":"₫1,056,640,000"}]
[null,null,{"v":3,"d":"Quý 3"},"2013-07-01","Consolidated Messenger",{"v":180960000,"d":"₫180,960,000"}]
[{"$nulls":3},"2013-08-01","Proseware, Inc.",{"v":176800000,"d":"₫176,800,000"}]
[{"$nulls":4},"Trường Mỹ thuật2",{"v":164320000,"d":"₫164,320,000"}]
[{"$nulls":3},"2013-09-01","Consolidated Messenger",{"v":193440000,"d":"₫193,440,000"}]
[{"$nulls":4},"Contoso Pharmaceuticals",{"v":116480000,"d":"₫116,480,000"}]
[{"$nulls":4},"Trey Research",{"v":189280000,"d":"₫189,280,000"}]
[null,null,"Quarter 3 Tổng",null,null,{"v":1021280000,"d":"₫1,021,280,000"}]
[null,null,{"v":4,"d":"Quý 4"},"2013-10-01","Proseware, Inc.",{"v":183040000,"d":"₫183,040,000"}]
[{"$nulls":3},"2013-11-01","Trey Research",{"v":343200000,"d":"₫343,200,000"}]
[{"$nulls":4},"Trường Mỹ thuật2",{"v":189280000,"d":"₫189,280,000"}]
[{"$nulls":3},"2013-12-01","Contoso Pharmaceuticals",{"v":197600000,"d":"₫197,600,000"}]
[null,null,"Quarter 4 Tổng",null,null,{"v":913120000,"d":"₫913,120,000"}]
[null," Tổng năm 2013",{"$nulls":3},{"v":2991040000,"d":"₫2,991,040,000"}]
[null,"Tổng Cộng",{"$nulls":3},{"v":2991040000,"d":"₫2,991,040,000"}]

{"sheet":"Dự báo Bán hàng","index":2,"n_rows":43,"n_cols":10,"rows_kept":43}
[]
[null,"DỰ BÁO BÁN HÀNG HÀNG THÁNG"]
[null,{"$f":"\"NGÀY HÔM NAY: \"&TEXT(TODAY(),\"[$-F800]dddd, mmmm dd, yyyy\")","v":"NGÀY HÔM NAY: 16 Tháng Mười 2012"},null,{"$f":"--TRIM(RIGHT(B3,LEN(B3)-FIND(\":\",B3)))","v":"2012-10-16"}]
[]
[null,"THÁNG NÀY","THỰC TẾ","KẾ HOẠCH","CHÊNH LỆCH","%","SỐ THỰC TẾ TÍNH ĐẾN HÔM NAY","SỐ THEO KẾ HOẠCH TÍNH ĐẾN HÔM NAY","SỐ CHÊNH LỆCH TÍNH ĐẾN HÔM NAY","% TÍNH ĐẾN HÔM NAY (YTD)"]
[null,"Số lượng",{"$f":"COUNTIF('Mục nhập Dữ liệu'!$B$6:$B$24,\">=\"&DATE(fYear,MONTH(fDate),1))-COUNTIF('Mục nhập Dữ liệu'!$B$6:$B$24,\">\"&EOMONTH(fDate,0))","v":{"v":0,"d":"₫0.00"}},{"$nulls":3},{"$f":"COUNTIF(tblData[NGÀY],\"<=\"&EOMONTH(fDate,0))","v":{"v":0,"d":"₫0.00"}}]
[null,"Bán hàng",{"$f":"SUMIF(tblData[NGÀY],\">=\"&DATE(fYear,MONTH(fDate),1),tblData[SỐ TIỀN])-SUMIF(tblData[NGÀY],\">\"&EOMONTH(fDate,0),tblData[SỐ TIỀN])","v":{"v":0,"d":"₫0.00"}},{"$f":"SUMIF('Mục nhập Dữ liệu'!$B$6:$B$24,\">=\"&DATE(fYear,MONTH(fDate),1),'Mục nhập Dữ liệu'!$E$6:$E$24)-SUMIF('Mục nhập Dữ liệu'!$B$6:$B$24,\">\"&EOMONTH(fDate,0),'Mục nhập Dữ liệu'!$E$6:$E$24)","v":{"v":0,"d":"₫0.00"}},{"$f":"D7-C7","v":{"v":0,"d":"₫0.00"}},{"$f":"IFERROR(D7/C7,\"-\")","v":"-"},{"$f":"SUMIF(tblData[NGÀY],\"<=\"&EOMONTH(fDate,0),tblData[SỐ TIỀN])","v":{"v":0,"d":"₫0.00"}},{"$f":"SUMIF(tblData[NGÀY],\"<=\"&EOMONTH(fDate,0),tblData[THEO KẾ HOẠCH])","v":{"v":0,"d":"₫0.00"}},{"$f":"H7-G7","v":{"v":0,"d":"₫0.00"}},{"$f":"IFERROR(H7/G7,\"\")","v":""}]
[null,"Doanh thu",{"$f":"(SUMIF(tblData[NGÀY],\">=\"&DATE(fYear,MONTH(fDate),1),tblData[SỐ TIỀN])-SUMIF(tblData[NGÀY],\">\"&EOMONTH(fDate,0),tblData[SỐ TIỀN]))-(SUMIF(tblData[NGÀY],\">=\"&DATE(fYear,MONTH(fDate),1),tblData[CHI PHÍ])-SUMIF(tblData[NGÀY],\">\"&EOMONTH(fDate,0),tblData[CHI PHÍ]))","v":{"v":0,"d":"₫0.00"}},{"$f":"(SUMIF('Mục nhập Dữ liệu'!$B$6:$B$24,\">=\"&DATE(fYear,MONTH(fDate),1),'Mục nhập Dữ liệu'!$E$6:$E$24)-SUMIF('Mục nhập Dữ liệu'!$B$6:$B$24,\">\"&EOMONTH(fDate,0),'Mục nhập Dữ liệu'!$E$6:$E$24))-(SUMIF('Mục nhập Dữ liệu'!$B$6:$B$24,\">=\"&DATE(fYear,MONTH(fDate),1),'Mục nhập Dữ liệu'!$F$6:$F$24)-SUMIF('Mục nhập Dữ liệu'!$B$6:$B$24,\">\"&EOMONTH(fDate,0),'Mục nhập Dữ liệu'!$F$6:$F$24))","v":{"v":0,"d":"₫0.00"}},{"$f":"D8-C8","v":{"v":0,"d":"₫0.00"}},{"$f":"IFERROR(D8/C8,\"-\")","v":"-"},{"$f":"SUMIF('Mục nhập Dữ liệu'!$B$6:$B$24,\"<=\"&EOMONTH(fDate,0),'Mục nhập Dữ liệu'!$F$6:$F$24)","v":{"v":0,"d":"₫0.00"}},{"$f":"SUMIF(tblData[NGÀY],\"<=\"&EOMONTH(fDate,0),tblData[CHI PHÍ])","v":{"v":0,"d":"₫0.00"}},{"$f":"H8-G8","v":{"v":0,"d":"₫0.00"}},{"$f":"IFERROR(H8/G8,\"\")","v":""}]
[null,"Biên",{"$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,"Số Đơn hàng",{"$f":"COUNTIF(tblData[NGÀY],\">=\"&DATE(fYear,MONTH(fDate),1))-COUNTIF(tblData[NGÀY],\">\"&EOMONTH(fDate,0))","v":{"v":0,"d":"₫0.00"}},{"$nulls":3},{"$f":"COUNTIF(tblData[NGÀY],\">\"&EOMONTH(fDate,0))","v":{"v":19,"d":"₫19.00"}}]
[null,"Giá trị Đơn hàng trung bình",{"$f":"IFERROR(C7/C10,\"-\")","v":"-"},{"$nulls":3},{"$f":"IFERROR(G7/G10,\"-\")","v":{"v":0,"d":"₫0.00"}}]
[]
[null,"THÁNG TỚI",null,"THÁNG TỚI",null,"QUÝ TỚI",null,null,"NĂM TỚI"]
[null,"Bán hàng",null,{"$f":"TREND(tblData[[THÁNG ]],tblData[MONTH NUM (HIDE)],IF(MONTH(fDate)=12,13,MONTH(fDate)+1))","v":{"v":411896311.33671737,"d":"₫411,896,311.34"}},null,{"$f":"TREND(tblData[[QUÝ ]],tblData[MONTH NUM (HIDE)],IF(MONTH(fDate)=12,13,MONTH(fDate)+1))","v":{"v":938234856.1759729,"d":"₫938,234,856.18"}},null,null,{"$f":"TREND(tblData[[HÀNG NĂM ]],tblData[MONTH NUM (HIDE)],IF(MONTH(fDate)=12,13,MONTH(fDate)+1))","v":{"v":2991040000,"d":"₫2,991,040,000.00"}}]
[]
[null,"LỊCH SỬ BÁN HÀNG"]
{"$rows_empty":13}
[null,"DỰ BÁO THÁNG",{"$nulls":3},"DỰ BÁO QUÝ"]
{"$rows_empty":7}
[null,"DỰ BÁO NĂM",{"$nulls":3},"DÒNG DOANH THU"]
[]
[]
[]
[]
[{"$nulls":9}," "]