{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["資料項目","銷售報表","銷售預估"],"not_rendered":{"charts":5,"defined_names":7,"pivot_tables":1},"read":"whole","date_system":"1900"}

{"sheet":"資料項目","index":0,"n_rows":24,"n_cols":17,"rows_kept":24}
[{"$nulls":9},{"$f":"365*2","v":730}]
[null,"每月 資料項目"]
[{"$nulls":11},"合計",null,null,"預測"]
[]
[null,"日期","公司","金額","計劃","成本","營收","月份","季度","年度","MONTH NUM (HIDE)","月份 ","季度 ","整年 ","月份  ","季度  ","年度  "]
[null,{"$f":"40657+(365*2)","v":"2013-04-23"},"A. Datum Corporation",{"v":192000,"d":"NT$192,000"},{"v":186000,"d":"NT$186,000"},{"v":133500,"d":"NT$133,500"},{"$f":"tblData[[#This Row],[金額]]-tblData[[#This Row],[成本]]","v":{"v":58500,"d":"NT$58,500"}},{"$f":"DATE(YEAR(資料項目!$B6),MONTH(資料項目!$B6),1)","v":"2013-04-01"},{"$f":"LOOKUP(MONTH(資料項目!$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":" 第 2 季"}},{"$f":"YEAR(資料項目!$B6)","v":2013},{"$f":"MONTH(tblData[[#This Row],[日期]])","v":4},{"$f":"SUMIFS(tblData[金額],tblData[日期],\">=\"&EOMONTH(tblData[[#This Row],[日期]],-1)+1,tblData[日期],\"<=\"&EOMONTH(tblData[[#This Row],[日期]],0))","v":{"v":438000,"d":"NT$438,000"}},{"$f":"SUMIFS(tblData[金額],tblData[日期],\">=\"&DATE(YEAR(tblData[[#This Row],[日期]]),1,1),tblData[日期],\"<=\"&DATE(YEAR(tblData[[#This Row],[日期]]),12,31),tblData[季度],tblData[[#This Row],[季度]])","v":{"v":1524000,"d":"NT$1,524,000"}},{"$f":"SUMIFS(tblData[金額],tblData[日期],\">=\"&DATE(YEAR(tblData[[#This Row],[日期]]),1,1),tblData[日期],\"<=\"&DATE(YEAR(tblData[[#This Row],[日期]]),12,31))","v":{"v":4314000,"d":"NT$4,314,000"}},{"$f":"IFERROR(TREND($L$6:INDEX($L:$L,ROW(),1),$K$6:INDEX($K:$K,ROW(),1),IF(MONTH(tblData[[#This Row],[日期]])=12,13,MONTH(tblData[[#This Row],[日期]])+1)),\"\")","v":{"v":438000,"d":"NT$438,000"}},{"$f":"IFERROR(TREND($M$6:INDEX($M:$M,ROW(),1),$I$6:INDEX($I:$I,ROW(),1),IF(tblData[[#This Row],[季度]]=4,5,tblData[[#This Row],[季度]]+1)),\"\")","v":{"v":1524000,"d":"NT$1,524,000"}},{"$f":"IFERROR(TREND($N$6:INDEX($N:$N,ROW(),1),$J$6:INDEX($J:$J,ROW(),1),tblData[[#This Row],[年度]]+1),\"\")","v":{"v":4314000,"d":"NT$4,314,000"}}]
[null,{"$f":"40659+(365*2)","v":"2013-04-25"},"Contoso 製藥",{"v":246000,"d":"NT$246,000"},{"v":240000,"d":"NT$240,000"},{"v":192000,"d":"NT$192,000"},{"$f":"tblData[[#This Row],[金額]]-tblData[[#This Row],[成本]]","v":{"v":54000,"d":"NT$54,000"}},{"$f":"DATE(YEAR(資料項目!$B7),MONTH(資料項目!$B7),1)","v":"2013-04-01"},{"$f":"LOOKUP(MONTH(資料項目!$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":" 第 2 季"}},{"$f":"YEAR(資料項目!$B7)","v":2013},{"$f":"MONTH(tblData[[#This Row],[日期]])","v":4},{"$f":"SUMIFS(tblData[金額],tblData[日期],\">=\"&EOMONTH(tblData[[#This Row],[日期]],-1)+1,tblData[日期],\"<=\"&EOMONTH(tblData[[#This Row],[日期]],0))","v":{"v":438000,"d":"NT$438,000"}},{"$f":"SUMIFS(tblData[金額],tblData[日期],\">=\"&DATE(YEAR(tblData[[#This Row],[日期]]),1,1),tblData[日期],\"<=\"&DATE(YEAR(tblData[[#This Row],[日期]]),12,31),tblData[季度],tblData[[#This Row],[季度]])","v":{"v":1524000,"d":"NT$1,524,000"}},{"$f":"SUMIFS(tblData[金額],tblData[日期],\">=\"&DATE(YEAR(tblData[[#This Row],[日期]]),1,1),tblData[日期],\"<=\"&DATE(YEAR(tblData[[#This Row],[日期]]),12,31))","v":{"v":4314000,"d":"NT$4,314,000"}},{"$f":"IFERROR(TREND($L$6:INDEX($L:$L,ROW(),1),$K$6:INDEX($K:$K,ROW(),1),IF(MONTH(tblData[[#This Row],[日期]])=12,13,MONTH(tblData[[#This Row],[日期]])+1)),\"\")","v":{"v":438000,"d":"NT$438,000"}},{"$f":"IFERROR(TREND($M$6:INDEX($M:$M,ROW(),1),$I$6:INDEX($I:$I,ROW(),1),IF(tblData[[#This Row],[季度]]=4,5,tblData[[#This Row],[季度]]+1)),\"\")","v":{"v":1524000,"d":"NT$1,524,000"}},{"$f":"IFERROR(TREND($N$6:INDEX($N:$N,ROW(),1),$J$6:INDEX($J:$J,ROW(),1),tblData[[#This Row],[年度]]+1),\"\")","v":{"v":4314000,"d":"NT$4,314,000"}}]
[null,{"$f":"40671+(365*2)","v":"2013-05-07"},"Consolidated Messenger",{"v":132000,"d":"NT$132,000"},{"v":126000,"d":"NT$126,000"},{"v":78000,"d":"NT$78,000"},{"$f":"tblData[[#This Row],[金額]]-tblData[[#This Row],[成本]]","v":{"v":54000,"d":"NT$54,000"}},{"$f":"DATE(YEAR(資料項目!$B8),MONTH(資料項目!$B8),1)","v":"2013-05-01"},{"$f":"LOOKUP(MONTH(資料項目!$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":" 第 2 季"}},{"$f":"YEAR(資料項目!$B8)","v":2013},{"$f":"MONTH(tblData[[#This Row],[日期]])","v":5},{"$f":"SUMIFS(tblData[金額],tblData[日期],\">=\"&EOMONTH(tblData[[#This Row],[日期]],-1)+1,tblData[日期],\"<=\"&EOMONTH(tblData[[#This Row],[日期]],0))","v":{"v":654000,"d":"NT$654,000"}},{"$f":"SUMIFS(tblData[金額],tblData[日期],\">=\"&DATE(YEAR(tblData[[#This Row],[日期]]),1,1),tblData[日期],\"<=\"&DATE(YEAR(tblData[[#This Row],[日期]]),12,31),tblData[季度],tblData[[#This Row],[季度]])","v":{"v":1524000,"d":"NT$1,524,000"}},{"$f":"SUMIFS(tblData[金額],tblData[日期],\">=\"&DATE(YEAR(tblData[[#This Row],[日期]]),1,1),tblData[日期],\"<=\"&DATE(YEAR(tblData[[#This Row],[日期]]),12,31))","v":{"v":4314000,"d":"NT$4,314,000"}},{"$f":"IFERROR(TREND($L$6:INDEX($L:$L,ROW(),1),$K$6:INDEX($K:$K,ROW(),1),IF(MONTH(tblData[[#This Row],[日期]])=12,13,MONTH(tblData[[#This Row],[日期]])+1)),\"\")","v":{"v":870000,"d":"NT$870,000"}},{"$f":"IFERROR(TREND($M$6:INDEX($M:$M,ROW(),1),$I$6:INDEX($I:$I,ROW(),1),IF(tblData[[#This Row],[季度]]=4,5,tblData[[#This Row],[季度]]+1)),\"\")","v":{"v":1524000,"d":"NT$1,524,000"}},{"$f":"IFERROR(TREND($N$6:INDEX($N:$N,ROW(),1),$J$6:INDEX($J:$J,ROW(),1),tblData[[#This Row],[年度]]+1),\"\")","v":{"v":4314000,"d":"NT$4,314,000"}}]
[null,{"$f":"40678+(365*2)","v":"2013-05-14"},"Proseware, Inc.",{"v":162000,"d":"NT$162,000"},{"v":165000,"d":"NT$165,000"},{"v":135000,"d":"NT$135,000"},{"$f":"tblData[[#This Row],[金額]]-tblData[[#This Row],[成本]]","v":{"v":27000,"d":"NT$27,000"}},{"$f":"DATE(YEAR(資料項目!$B9),MONTH(資料項目!$B9),1)","v":"2013-05-01"},{"$f":"LOOKUP(MONTH(資料項目!$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":" 第 2 季"}},{"$f":"YEAR(資料項目!$B9)","v":2013},{"$f":"MONTH(tblData[[#This Row],[日期]])","v":5},{"$f":"SUMIFS(tblData[金額],tblData[日期],\">=\"&EOMONTH(tblData[[#This Row],[日期]],-1)+1,tblData[日期],\"<=\"&EOMONTH(tblData[[#This Row],[日期]],0))","v":{"v":654000,"d":"NT$654,000"}},{"$f":"SUMIFS(tblData[金額],tblData[日期],\">=\"&DATE(YEAR(tblData[[#This Row],[日期]]),1,1),tblData[日期],\"<=\"&DATE(YEAR(tblData[[#This Row],[日期]]),12,31),tblData[季度],tblData[[#This Row],[季度]])","v":{"v":1524000,"d":"NT$1,524,000"}},{"$f":"SUMIFS(tblData[金額],tblData[日期],\">=\"&DATE(YEAR(tblData[[#This Row],[日期]]),1,1),tblData[日期],\"<=\"&DATE(YEAR(tblData[[#This Row],[日期]]),12,31))","v":{"v":4314000,"d":"NT$4,314,000"}},{"$f":"IFERROR(TREND($L$6:INDEX($L:$L,ROW(),1),$K$6:INDEX($K:$K,ROW(),1),IF(MONTH(tblData[[#This Row],[日期]])=12,13,MONTH(tblData[[#This Row],[日期]])+1)),\"\")","v":{"v":870000,"d":"NT$870,000"}},{"$f":"IFERROR(TREND($M$6:INDEX($M:$M,ROW(),1),$I$6:INDEX($I:$I,ROW(),1),IF(tblData[[#This Row],[季度]]=4,5,tblData[[#This Row],[季度]]+1)),\"\")","v":{"v":1524000,"d":"NT$1,524,000"}},{"$f":"IFERROR(TREND($N$6:INDEX($N:$N,ROW(),1),$J$6:INDEX($J:$J,ROW(),1),tblData[[#This Row],[年度]]+1),\"\")","v":{"v":4314000,"d":"NT$4,314,000"}}]
[null,{"$f":"40678+(365*2)","v":"2013-05-14"},"美術學校",{"v":174000,"d":"NT$174,000"},{"v":180000,"d":"NT$180,000"},{"v":135000,"d":"NT$135,000"},{"$f":"tblData[[#This Row],[金額]]-tblData[[#This Row],[成本]]","v":{"v":39000,"d":"NT$39,000"}},{"$f":"DATE(YEAR(資料項目!$B10),MONTH(資料項目!$B10),1)","v":"2013-05-01"},{"$f":"LOOKUP(MONTH(資料項目!$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":" 第 2 季"}},{"$f":"YEAR(資料項目!$B10)","v":2013},{"$f":"MONTH(tblData[[#This Row],[日期]])","v":5},{"$f":"SUMIFS(tblData[金額],tblData[日期],\">=\"&EOMONTH(tblData[[#This Row],[日期]],-1)+1,tblData[日期],\"<=\"&EOMONTH(tblData[[#This Row],[日期]],0))","v":{"v":654000,"d":"NT$654,000"}},{"$f":"SUMIFS(tblData[金額],tblData[日期],\">=\"&DATE(YEAR(tblData[[#This Row],[日期]]),1,1),tblData[日期],\"<=\"&DATE(YEAR(tblData[[#This Row],[日期]]),12,31),tblData[季度],tblData[[#This Row],[季度]])","v":{"v":1524000,"d":"NT$1,524,000"}},{"$f":"SUMIFS(tblData[金額],tblData[日期],\">=\"&DATE(YEAR(tblData[[#This Row],[日期]]),1,1),tblData[日期],\"<=\"&DATE(YEAR(tblData[[#This Row],[日期]]),12,31))","v":{"v":4314000,"d":"NT$4,314,000"}},{"$f":"IFERROR(TREND($L$6:INDEX($L:$L,ROW(),1),$K$6:INDEX($K:$K,ROW(),1),IF(MONTH(tblData[[#This Row],[日期]])=12,13,MONTH(tblData[[#This Row],[日期]])+1)),\"\")","v":{"v":870000,"d":"NT$870,000"}},{"$f":"IFERROR(TREND($M$6:INDEX($M:$M,ROW(),1),$I$6:INDEX($I:$I,ROW(),1),IF(tblData[[#This Row],[季度]]=4,5,tblData[[#This Row],[季度]]+1)),\"\")","v":{"v":1524000,"d":"NT$1,524,000"}},{"$f":"IFERROR(TREND($N$6:INDEX($N:$N,ROW(),1),$J$6:INDEX($J:$J,ROW(),1),tblData[[#This Row],[年度]]+1),\"\")","v":{"v":4314000,"d":"NT$4,314,000"}}]
[null,{"$f":"40693+(365*2)","v":"2013-05-29"},"正人資源",{"v":186000,"d":"NT$186,000"},{"v":180000,"d":"NT$180,000"},{"v":135000,"d":"NT$135,000"},{"$f":"tblData[[#This Row],[金額]]-tblData[[#This Row],[成本]]","v":{"v":51000,"d":"NT$51,000"}},{"$f":"DATE(YEAR(資料項目!$B11),MONTH(資料項目!$B11),1)","v":"2013-05-01"},{"$f":"LOOKUP(MONTH(資料項目!$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":" 第 2 季"}},{"$f":"YEAR(資料項目!$B11)","v":2013},{"$f":"MONTH(tblData[[#This Row],[日期]])","v":5},{"$f":"SUMIFS(tblData[金額],tblData[日期],\">=\"&EOMONTH(tblData[[#This Row],[日期]],-1)+1,tblData[日期],\"<=\"&EOMONTH(tblData[[#This Row],[日期]],0))","v":{"v":654000,"d":"NT$654,000"}},{"$f":"SUMIFS(tblData[金額],tblData[日期],\">=\"&DATE(YEAR(tblData[[#This Row],[日期]]),1,1),tblData[日期],\"<=\"&DATE(YEAR(tblData[[#This Row],[日期]]),12,31),tblData[季度],tblData[[#This Row],[季度]])","v":{"v":1524000,"d":"NT$1,524,000"}},{"$f":"SUMIFS(tblData[金額],tblData[日期],\">=\"&DATE(YEAR(tblData[[#This Row],[日期]]),1,1),tblData[日期],\"<=\"&DATE(YEAR(tblData[[#This Row],[日期]]),12,31))","v":{"v":4314000,"d":"NT$4,314,000"}},{"$f":"IFERROR(TREND($L$6:INDEX($L:$L,ROW(),1),$K$6:INDEX($K:$K,ROW(),1),IF(MONTH(tblData[[#This Row],[日期]])=12,13,MONTH(tblData[[#This Row],[日期]])+1)),\"\")","v":{"v":869999.9999999999,"d":"NT$870,000"}},{"$f":"IFERROR(TREND($M$6:INDEX($M:$M,ROW(),1),$I$6:INDEX($I:$I,ROW(),1),IF(tblData[[#This Row],[季度]]=4,5,tblData[[#This Row],[季度]]+1)),\"\")","v":{"v":1524000,"d":"NT$1,524,000"}},{"$f":"IFERROR(TREND($N$6:INDEX($N:$N,ROW(),1),$J$6:INDEX($J:$J,ROW(),1),tblData[[#This Row],[年度]]+1),\"\")","v":{"v":4314000,"d":"NT$4,314,000"}}]
[null,{"$f":"40705+(365*2)","v":"2013-06-10"},"A. Datum Corporation",{"v":207000,"d":"NT$207,000"},{"v":225000,"d":"NT$225,000"},{"v":162000,"d":"NT$162,000"},{"$f":"tblData[[#This Row],[金額]]-tblData[[#This Row],[成本]]","v":{"v":45000,"d":"NT$45,000"}},{"$f":"DATE(YEAR(資料項目!$B12),MONTH(資料項目!$B12),1)","v":"2013-06-01"},{"$f":"LOOKUP(MONTH(資料項目!$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":" 第 2 季"}},{"$f":"YEAR(資料項目!$B12)","v":2013},{"$f":"MONTH(tblData[[#This Row],[日期]])","v":6},{"$f":"SUMIFS(tblData[金額],tblData[日期],\">=\"&EOMONTH(tblData[[#This Row],[日期]],-1)+1,tblData[日期],\"<=\"&EOMONTH(tblData[[#This Row],[日期]],0))","v":{"v":432000,"d":"NT$432,000"}},{"$f":"SUMIFS(tblData[金額],tblData[日期],\">=\"&DATE(YEAR(tblData[[#This Row],[日期]]),1,1),tblData[日期],\"<=\"&DATE(YEAR(tblData[[#This Row],[日期]]),12,31),tblData[季度],tblData[[#This Row],[季度]])","v":{"v":1524000,"d":"NT$1,524,000"}},{"$f":"SUMIFS(tblData[金額],tblData[日期],\">=\"&DATE(YEAR(tblData[[#This Row],[日期]]),1,1),tblData[日期],\"<=\"&DATE(YEAR(tblData[[#This Row],[日期]]),12,31))","v":{"v":4314000,"d":"NT$4,314,000"}},{"$f":"IFERROR(TREND($L$6:INDEX($L:$L,ROW(),1),$K$6:INDEX($K:$K,ROW(),1),IF(MONTH(tblData[[#This Row],[日期]])=12,13,MONTH(tblData[[#This Row],[日期]])+1)),\"\")","v":{"v":647999.9999999999,"d":"NT$648,000"}},{"$f":"IFERROR(TREND($M$6:INDEX($M:$M,ROW(),1),$I$6:INDEX($I:$I,ROW(),1),IF(tblData[[#This Row],[季度]]=4,5,tblData[[#This Row],[季度]]+1)),\"\")","v":{"v":1524000,"d":"NT$1,524,000"}},{"$f":"IFERROR(TREND($N$6:INDEX($N:$N,ROW(),1),$J$6:INDEX($J:$J,ROW(),1),tblData[[#This Row],[年度]]+1),\"\")","v":{"v":4314000,"d":"NT$4,314,000"}}]
[null,{"$f":"40716+(365*2)","v":"2013-06-21"},"Contoso 製藥",{"v":225000,"d":"NT$225,000"},{"v":216000,"d":"NT$216,000"},{"v":195000,"d":"NT$195,000"},{"$f":"tblData[[#This Row],[金額]]-tblData[[#This Row],[成本]]","v":{"v":30000,"d":"NT$30,000"}},{"$f":"DATE(YEAR(資料項目!$B13),MONTH(資料項目!$B13),1)","v":"2013-06-01"},{"$f":"LOOKUP(MONTH(資料項目!$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":" 第 2 季"}},{"$f":"YEAR(資料項目!$B13)","v":2013},{"$f":"MONTH(tblData[[#This Row],[日期]])","v":6},{"$f":"SUMIFS(tblData[金額],tblData[日期],\">=\"&EOMONTH(tblData[[#This Row],[日期]],-1)+1,tblData[日期],\"<=\"&EOMONTH(tblData[[#This Row],[日期]],0))","v":{"v":432000,"d":"NT$432,000"}},{"$f":"SUMIFS(tblData[金額],tblData[日期],\">=\"&DATE(YEAR(tblData[[#This Row],[日期]]),1,1),tblData[日期],\"<=\"&DATE(YEAR(tblData[[#This Row],[日期]]),12,31),tblData[季度],tblData[[#This Row],[季度]])","v":{"v":1524000,"d":"NT$1,524,000"}},{"$f":"SUMIFS(tblData[金額],tblData[日期],\">=\"&DATE(YEAR(tblData[[#This Row],[日期]]),1,1),tblData[日期],\"<=\"&DATE(YEAR(tblData[[#This Row],[日期]]),12,31))","v":{"v":4314000,"d":"NT$4,314,000"}},{"$f":"IFERROR(TREND($L$6:INDEX($L:$L,ROW(),1),$K$6:INDEX($K:$K,ROW(),1),IF(MONTH(tblData[[#This Row],[日期]])=12,13,MONTH(tblData[[#This Row],[日期]])+1)),\"\")","v":{"v":538500,"d":"NT$538,500"}},{"$f":"IFERROR(TREND($M$6:INDEX($M:$M,ROW(),1),$I$6:INDEX($I:$I,ROW(),1),IF(tblData[[#This Row],[季度]]=4,5,tblData[[#This Row],[季度]]+1)),\"\")","v":{"v":1524000,"d":"NT$1,524,000"}},{"$f":"IFERROR(TREND($N$6:INDEX($N:$N,ROW(),1),$J$6:INDEX($J:$J,ROW(),1),tblData[[#This Row],[年度]]+1),\"\")","v":{"v":4314000,"d":"NT$4,314,000"}}]
[null,{"$f":"40731+(365*2)","v":"2013-07-06"},"Consolidated Messenger",{"v":261000,"d":"NT$261,000"},{"v":255000,"d":"NT$255,000"},{"v":217500,"d":"NT$217,500"},{"$f":"tblData[[#This Row],[金額]]-tblData[[#This Row],[成本]]","v":{"v":43500,"d":"NT$43,500"}},{"$f":"DATE(YEAR(資料項目!$B14),MONTH(資料項目!$B14),1)","v":"2013-07-01"},{"$f":"LOOKUP(MONTH(資料項目!$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":" 第 3 季"}},{"$f":"YEAR(資料項目!$B14)","v":2013},{"$f":"MONTH(tblData[[#This Row],[日期]])","v":7},{"$f":"SUMIFS(tblData[金額],tblData[日期],\">=\"&EOMONTH(tblData[[#This Row],[日期]],-1)+1,tblData[日期],\"<=\"&EOMONTH(tblData[[#This Row],[日期]],0))","v":{"v":261000,"d":"NT$261,000"}},{"$f":"SUMIFS(tblData[金額],tblData[日期],\">=\"&DATE(YEAR(tblData[[#This Row],[日期]]),1,1),tblData[日期],\"<=\"&DATE(YEAR(tblData[[#This Row],[日期]]),12,31),tblData[季度],tblData[[#This Row],[季度]])","v":{"v":1473000,"d":"NT$1,473,000"}},{"$f":"SUMIFS(tblData[金額],tblData[日期],\">=\"&DATE(YEAR(tblData[[#This Row],[日期]]),1,1),tblData[日期],\"<=\"&DATE(YEAR(tblData[[#This Row],[日期]]),12,31))","v":{"v":4314000,"d":"NT$4,314,000"}},{"$f":"IFERROR(TREND($L$6:INDEX($L:$L,ROW(),1),$K$6:INDEX($K:$K,ROW(),1),IF(MONTH(tblData[[#This Row],[日期]])=12,13,MONTH(tblData[[#This Row],[日期]])+1)),\"\")","v":{"v":323294.1176470588,"d":"NT$323,294"}},{"$f":"IFERROR(TREND($M$6:INDEX($M:$M,ROW(),1),$I$6:INDEX($I:$I,ROW(),1),IF(tblData[[#This Row],[季度]]=4,5,tblData[[#This Row],[季度]]+1)),\"\")","v":{"v":1422000,"d":"NT$1,422,000"}},{"$f":"IFERROR(TREND($N$6:INDEX($N:$N,ROW(),1),$J$6:INDEX($J:$J,ROW(),1),tblData[[#This Row],[年度]]+1),\"\")","v":{"v":4314000,"d":"NT$4,314,000"}}]
[null,{"$f":"40761+(365*2)","v":"2013-08-05"},"Proseware, Inc.",{"v":255000,"d":"NT$255,000"},{"v":249000,"d":"NT$249,000"},{"v":213000,"d":"NT$213,000"},{"$f":"tblData[[#This Row],[金額]]-tblData[[#This Row],[成本]]","v":{"v":42000,"d":"NT$42,000"}},{"$f":"DATE(YEAR(資料項目!$B15),MONTH(資料項目!$B15),1)","v":"2013-08-01"},{"$f":"LOOKUP(MONTH(資料項目!$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":" 第 3 季"}},{"$f":"YEAR(資料項目!$B15)","v":2013},{"$f":"MONTH(tblData[[#This Row],[日期]])","v":8},{"$f":"SUMIFS(tblData[金額],tblData[日期],\">=\"&EOMONTH(tblData[[#This Row],[日期]],-1)+1,tblData[日期],\"<=\"&EOMONTH(tblData[[#This Row],[日期]],0))","v":{"v":492000,"d":"NT$492,000"}},{"$f":"SUMIFS(tblData[金額],tblData[日期],\">=\"&DATE(YEAR(tblData[[#This Row],[日期]]),1,1),tblData[日期],\"<=\"&DATE(YEAR(tblData[[#This Row],[日期]]),12,31),tblData[季度],tblData[[#This Row],[季度]])","v":{"v":1473000,"d":"NT$1,473,000"}},{"$f":"SUMIFS(tblData[金額],tblData[日期],\">=\"&DATE(YEAR(tblData[[#This Row],[日期]]),1,1),tblData[日期],\"<=\"&DATE(YEAR(tblData[[#This Row],[日期]]),12,31))","v":{"v":4314000,"d":"NT$4,314,000"}},{"$f":"IFERROR(TREND($L$6:INDEX($L:$L,ROW(),1),$K$6:INDEX($K:$K,ROW(),1),IF(MONTH(tblData[[#This Row],[日期]])=12,13,MONTH(tblData[[#This Row],[日期]])+1)),\"\")","v":{"v":373675.86206896557,"d":"NT$373,676"}},{"$f":"IFERROR(TREND($M$6:INDEX($M:$M,ROW(),1),$I$6:INDEX($I:$I,ROW(),1),IF(tblData[[#This Row],[季度]]=4,5,tblData[[#This Row],[季度]]+1)),\"\")","v":{"v":1422000,"d":"NT$1,422,000"}},{"$f":"IFERROR(TREND($N$6:INDEX($N:$N,ROW(),1),$J$6:INDEX($J:$J,ROW(),1),tblData[[#This Row],[年度]]+1),\"\")","v":{"v":4314000,"d":"NT$4,314,000"}}]
[null,{"$f":"40775+(365*2)","v":"2013-08-19"},"美術學校",{"v":237000,"d":"NT$237,000"},{"v":231000,"d":"NT$231,000"},{"v":198000,"d":"NT$198,000"},{"$f":"tblData[[#This Row],[金額]]-tblData[[#This Row],[成本]]","v":{"v":39000,"d":"NT$39,000"}},{"$f":"DATE(YEAR(資料項目!$B16),MONTH(資料項目!$B16),1)","v":"2013-08-01"},{"$f":"LOOKUP(MONTH(資料項目!$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":" 第 3 季"}},{"$f":"YEAR(資料項目!$B16)","v":2013},{"$f":"MONTH(tblData[[#This Row],[日期]])","v":8},{"$f":"SUMIFS(tblData[金額],tblData[日期],\">=\"&EOMONTH(tblData[[#This Row],[日期]],-1)+1,tblData[日期],\"<=\"&EOMONTH(tblData[[#This Row],[日期]],0))","v":{"v":492000,"d":"NT$492,000"}},{"$f":"SUMIFS(tblData[金額],tblData[日期],\">=\"&DATE(YEAR(tblData[[#This Row],[日期]]),1,1),tblData[日期],\"<=\"&DATE(YEAR(tblData[[#This Row],[日期]]),12,31),tblData[季度],tblData[[#This Row],[季度]])","v":{"v":1473000,"d":"NT$1,473,000"}},{"$f":"SUMIFS(tblData[金額],tblData[日期],\">=\"&DATE(YEAR(tblData[[#This Row],[日期]]),1,1),tblData[日期],\"<=\"&DATE(YEAR(tblData[[#This Row],[日期]]),12,31))","v":{"v":4314000,"d":"NT$4,314,000"}},{"$f":"IFERROR(TREND($L$6:INDEX($L:$L,ROW(),1),$K$6:INDEX($K:$K,ROW(),1),IF(MONTH(tblData[[#This Row],[日期]])=12,13,MONTH(tblData[[#This Row],[日期]])+1)),\"\")","v":{"v":410027.027027027,"d":"NT$410,027"}},{"$f":"IFERROR(TREND($M$6:INDEX($M:$M,ROW(),1),$I$6:INDEX($I:$I,ROW(),1),IF(tblData[[#This Row],[季度]]=4,5,tblData[[#This Row],[季度]]+1)),\"\")","v":{"v":1422000,"d":"NT$1,422,000"}},{"$f":"IFERROR(TREND($N$6:INDEX($N:$N,ROW(),1),$J$6:INDEX($J:$J,ROW(),1),tblData[[#This Row],[年度]]+1),\"\")","v":{"v":4314000,"d":"NT$4,314,000"}}]
[null,{"$f":"40791+(365*2)","v":"2013-09-04"},"正人資源",{"v":273000,"d":"NT$273,000"},{"v":267000,"d":"NT$267,000"},{"v":237000,"d":"NT$237,000"},{"$f":"tblData[[#This Row],[金額]]-tblData[[#This Row],[成本]]","v":{"v":36000,"d":"NT$36,000"}},{"$f":"DATE(YEAR(資料項目!$B17),MONTH(資料項目!$B17),1)","v":"2013-09-01"},{"$f":"LOOKUP(MONTH(資料項目!$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":" 第 3 季"}},{"$f":"YEAR(資料項目!$B17)","v":2013},{"$f":"MONTH(tblData[[#This Row],[日期]])","v":9},{"$f":"SUMIFS(tblData[金額],tblData[日期],\">=\"&EOMONTH(tblData[[#This Row],[日期]],-1)+1,tblData[日期],\"<=\"&EOMONTH(tblData[[#This Row],[日期]],0))","v":{"v":720000,"d":"NT$720,000"}},{"$f":"SUMIFS(tblData[金額],tblData[日期],\">=\"&DATE(YEAR(tblData[[#This Row],[日期]]),1,1),tblData[日期],\"<=\"&DATE(YEAR(tblData[[#This Row],[日期]]),12,31),tblData[季度],tblData[[#This Row],[季度]])","v":{"v":1473000,"d":"NT$1,473,000"}},{"$f":"SUMIFS(tblData[金額],tblData[日期],\">=\"&DATE(YEAR(tblData[[#This Row],[日期]]),1,1),tblData[日期],\"<=\"&DATE(YEAR(tblData[[#This Row],[日期]]),12,31))","v":{"v":4314000,"d":"NT$4,314,000"}},{"$f":"IFERROR(TREND($L$6:INDEX($L:$L,ROW(),1),$K$6:INDEX($K:$K,ROW(),1),IF(MONTH(tblData[[#This Row],[日期]])=12,13,MONTH(tblData[[#This Row],[日期]])+1)),\"\")","v":{"v":529550,"d":"NT$529,550"}},{"$f":"IFERROR(TREND($M$6:INDEX($M:$M,ROW(),1),$I$6:INDEX($I:$I,ROW(),1),IF(tblData[[#This Row],[季度]]=4,5,tblData[[#This Row],[季度]]+1)),\"\")","v":{"v":1422000,"d":"NT$1,422,000"}},{"$f":"IFERROR(TREND($N$6:INDEX($N:$N,ROW(),1),$J$6:INDEX($J:$J,ROW(),1),tblData[[#This Row],[年度]]+1),\"\")","v":{"v":4314000,"d":"NT$4,314,000"}}]
[null,{"$f":"40807+(365*2)","v":"2013-09-20"},"Contoso 製藥",{"v":168000,"d":"NT$168,000"},{"v":174000,"d":"NT$174,000"},{"v":135000,"d":"NT$135,000"},{"$f":"tblData[[#This Row],[金額]]-tblData[[#This Row],[成本]]","v":{"v":33000,"d":"NT$33,000"}},{"$f":"DATE(YEAR(資料項目!$B18),MONTH(資料項目!$B18),1)","v":"2013-09-01"},{"$f":"LOOKUP(MONTH(資料項目!$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":" 第 3 季"}},{"$f":"YEAR(資料項目!$B18)","v":2013},{"$f":"MONTH(tblData[[#This Row],[日期]])","v":9},{"$f":"SUMIFS(tblData[金額],tblData[日期],\">=\"&EOMONTH(tblData[[#This Row],[日期]],-1)+1,tblData[日期],\"<=\"&EOMONTH(tblData[[#This Row],[日期]],0))","v":{"v":720000,"d":"NT$720,000"}},{"$f":"SUMIFS(tblData[金額],tblData[日期],\">=\"&DATE(YEAR(tblData[[#This Row],[日期]]),1,1),tblData[日期],\"<=\"&DATE(YEAR(tblData[[#This Row],[日期]]),12,31),tblData[季度],tblData[[#This Row],[季度]])","v":{"v":1473000,"d":"NT$1,473,000"}},{"$f":"SUMIFS(tblData[金額],tblData[日期],\">=\"&DATE(YEAR(tblData[[#This Row],[日期]]),1,1),tblData[日期],\"<=\"&DATE(YEAR(tblData[[#This Row],[日期]]),12,31))","v":{"v":4314000,"d":"NT$4,314,000"}},{"$f":"IFERROR(TREND($L$6:INDEX($L:$L,ROW(),1),$K$6:INDEX($K:$K,ROW(),1),IF(MONTH(tblData[[#This Row],[日期]])=12,13,MONTH(tblData[[#This Row],[日期]])+1)),\"\")","v":{"v":596337.3493975904,"d":"NT$596,337"}},{"$f":"IFERROR(TREND($M$6:INDEX($M:$M,ROW(),1),$I$6:INDEX($I:$I,ROW(),1),IF(tblData[[#This Row],[季度]]=4,5,tblData[[#This Row],[季度]]+1)),\"\")","v":{"v":1422000,"d":"NT$1,422,000"}},{"$f":"IFERROR(TREND($N$6:INDEX($N:$N,ROW(),1),$J$6:INDEX($J:$J,ROW(),1),tblData[[#This Row],[年度]]+1),\"\")","v":{"v":4314000,"d":"NT$4,314,000"}}]
[null,{"$f":"40812+(365*2)","v":"2013-09-25"},"Consolidated Messenger",{"v":279000,"d":"NT$279,000"},{"v":273000,"d":"NT$273,000"},{"v":225000,"d":"NT$225,000"},{"$f":"tblData[[#This Row],[金額]]-tblData[[#This Row],[成本]]","v":{"v":54000,"d":"NT$54,000"}},{"$f":"DATE(YEAR(資料項目!$B19),MONTH(資料項目!$B19),1)","v":"2013-09-01"},{"$f":"LOOKUP(MONTH(資料項目!$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":" 第 3 季"}},{"$f":"YEAR(資料項目!$B19)","v":2013},{"$f":"MONTH(tblData[[#This Row],[日期]])","v":9},{"$f":"SUMIFS(tblData[金額],tblData[日期],\">=\"&EOMONTH(tblData[[#This Row],[日期]],-1)+1,tblData[日期],\"<=\"&EOMONTH(tblData[[#This Row],[日期]],0))","v":{"v":720000,"d":"NT$720,000"}},{"$f":"SUMIFS(tblData[金額],tblData[日期],\">=\"&DATE(YEAR(tblData[[#This Row],[日期]]),1,1),tblData[日期],\"<=\"&DATE(YEAR(tblData[[#This Row],[日期]]),12,31),tblData[季度],tblData[[#This Row],[季度]])","v":{"v":1473000,"d":"NT$1,473,000"}},{"$f":"SUMIFS(tblData[金額],tblData[日期],\">=\"&DATE(YEAR(tblData[[#This Row],[日期]]),1,1),tblData[日期],\"<=\"&DATE(YEAR(tblData[[#This Row],[日期]]),12,31))","v":{"v":4314000,"d":"NT$4,314,000"}},{"$f":"IFERROR(TREND($L$6:INDEX($L:$L,ROW(),1),$K$6:INDEX($K:$K,ROW(),1),IF(MONTH(tblData[[#This Row],[日期]])=12,13,MONTH(tblData[[#This Row],[日期]])+1)),\"\")","v":{"v":634141.5094339622,"d":"NT$634,142"}},{"$f":"IFERROR(TREND($M$6:INDEX($M:$M,ROW(),1),$I$6:INDEX($I:$I,ROW(),1),IF(tblData[[#This Row],[季度]]=4,5,tblData[[#This Row],[季度]]+1)),\"\")","v":{"v":1421999.9999999998,"d":"NT$1,422,000"}},{"$f":"IFERROR(TREND($N$6:INDEX($N:$N,ROW(),1),$J$6:INDEX($J:$J,ROW(),1),tblData[[#This Row],[年度]]+1),\"\")","v":{"v":4314000,"d":"NT$4,314,000"}}]
[null,{"$f":"40832+(365*2)","v":"2013-10-15"},"Proseware, Inc.",{"v":264000,"d":"NT$264,000"},{"v":280500,"d":"NT$280,500"},{"v":213000,"d":"NT$213,000"},{"$f":"tblData[[#This Row],[金額]]-tblData[[#This Row],[成本]]","v":{"v":51000,"d":"NT$51,000"}},{"$f":"DATE(YEAR(資料項目!$B20),MONTH(資料項目!$B20),1)","v":"2013-10-01"},{"$f":"LOOKUP(MONTH(資料項目!$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":" 第 4 季"}},{"$f":"YEAR(資料項目!$B20)","v":2013},{"$f":"MONTH(tblData[[#This Row],[日期]])","v":10},{"$f":"SUMIFS(tblData[金額],tblData[日期],\">=\"&EOMONTH(tblData[[#This Row],[日期]],-1)+1,tblData[日期],\"<=\"&EOMONTH(tblData[[#This Row],[日期]],0))","v":{"v":264000,"d":"NT$264,000"}},{"$f":"SUMIFS(tblData[金額],tblData[日期],\">=\"&DATE(YEAR(tblData[[#This Row],[日期]]),1,1),tblData[日期],\"<=\"&DATE(YEAR(tblData[[#This Row],[日期]]),12,31),tblData[季度],tblData[[#This Row],[季度]])","v":{"v":1317000,"d":"NT$1,317,000"}},{"$f":"SUMIFS(tblData[金額],tblData[日期],\">=\"&DATE(YEAR(tblData[[#This Row],[日期]]),1,1),tblData[日期],\"<=\"&DATE(YEAR(tblData[[#This Row],[日期]]),12,31))","v":{"v":4314000,"d":"NT$4,314,000"}},{"$f":"IFERROR(TREND($L$6:INDEX($L:$L,ROW(),1),$K$6:INDEX($K:$K,ROW(),1),IF(MONTH(tblData[[#This Row],[日期]])=12,13,MONTH(tblData[[#This Row],[日期]])+1)),\"\")","v":{"v":538552.3255813953,"d":"NT$538,552"}},{"$f":"IFERROR(TREND($M$6:INDEX($M:$M,ROW(),1),$I$6:INDEX($I:$I,ROW(),1),IF(tblData[[#This Row],[季度]]=4,5,tblData[[#This Row],[季度]]+1)),\"\")","v":{"v":1297744.1860465116,"d":"NT$1,297,744"}},{"$f":"IFERROR(TREND($N$6:INDEX($N:$N,ROW(),1),$J$6:INDEX($J:$J,ROW(),1),tblData[[#This Row],[年度]]+1),\"\")","v":{"v":4314000,"d":"NT$4,314,000"}}]
[null,{"$f":"40853+(365*2)","v":"2013-11-05"},"美術學校",{"v":273000,"d":"NT$273,000"},{"v":276000,"d":"NT$276,000"},{"v":235500,"d":"NT$235,500"},{"$f":"tblData[[#This Row],[金額]]-tblData[[#This Row],[成本]]","v":{"v":37500,"d":"NT$37,500"}},{"$f":"DATE(YEAR(資料項目!$B21),MONTH(資料項目!$B21),1)","v":"2013-11-01"},{"$f":"LOOKUP(MONTH(資料項目!$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":" 第 4 季"}},{"$f":"YEAR(資料項目!$B21)","v":2013},{"$f":"MONTH(tblData[[#This Row],[日期]])","v":11},{"$f":"SUMIFS(tblData[金額],tblData[日期],\">=\"&EOMONTH(tblData[[#This Row],[日期]],-1)+1,tblData[日期],\"<=\"&EOMONTH(tblData[[#This Row],[日期]],0))","v":{"v":768000,"d":"NT$768,000"}},{"$f":"SUMIFS(tblData[金額],tblData[日期],\">=\"&DATE(YEAR(tblData[[#This Row],[日期]]),1,1),tblData[日期],\"<=\"&DATE(YEAR(tblData[[#This Row],[日期]]),12,31),tblData[季度],tblData[[#This Row],[季度]])","v":{"v":1317000,"d":"NT$1,317,000"}},{"$f":"SUMIFS(tblData[金額],tblData[日期],\">=\"&DATE(YEAR(tblData[[#This Row],[日期]]),1,1),tblData[日期],\"<=\"&DATE(YEAR(tblData[[#This Row],[日期]]),12,31))","v":{"v":4314000,"d":"NT$4,314,000"}},{"$f":"IFERROR(TREND($L$6:INDEX($L:$L,ROW(),1),$K$6:INDEX($K:$K,ROW(),1),IF(MONTH(tblData[[#This Row],[日期]])=12,13,MONTH(tblData[[#This Row],[日期]])+1)),\"\")","v":{"v":616683.9032527106,"d":"NT$616,684"}},{"$f":"IFERROR(TREND($M$6:INDEX($M:$M,ROW(),1),$I$6:INDEX($I:$I,ROW(),1),IF(tblData[[#This Row],[季度]]=4,5,tblData[[#This Row],[季度]]+1)),\"\")","v":{"v":1269387.0967741937,"d":"NT$1,269,387"}},{"$f":"IFERROR(TREND($N$6:INDEX($N:$N,ROW(),1),$J$6:INDEX($J:$J,ROW(),1),tblData[[#This Row],[年度]]+1),\"\")","v":{"v":4314000,"d":"NT$4,314,000"}}]
[null,{"$f":"40874+(365*2)","v":"2013-11-26"},"正人資源",{"v":270000,"d":"NT$270,000"},{"v":300000,"d":"NT$300,000"},{"v":227250,"d":"NT$227,250"},{"$f":"tblData[[#This Row],[金額]]-tblData[[#This Row],[成本]]","v":{"v":42750,"d":"NT$42,750"}},{"$f":"DATE(YEAR(資料項目!$B22),MONTH(資料項目!$B22),1)","v":"2013-11-01"},{"$f":"LOOKUP(MONTH(資料項目!$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":" 第 4 季"}},{"$f":"YEAR(資料項目!$B22)","v":2013},{"$f":"MONTH(tblData[[#This Row],[日期]])","v":11},{"$f":"SUMIFS(tblData[金額],tblData[日期],\">=\"&EOMONTH(tblData[[#This Row],[日期]],-1)+1,tblData[日期],\"<=\"&EOMONTH(tblData[[#This Row],[日期]],0))","v":{"v":768000,"d":"NT$768,000"}},{"$f":"SUMIFS(tblData[金額],tblData[日期],\">=\"&DATE(YEAR(tblData[[#This Row],[日期]]),1,1),tblData[日期],\"<=\"&DATE(YEAR(tblData[[#This Row],[日期]]),12,31),tblData[季度],tblData[[#This Row],[季度]])","v":{"v":1317000,"d":"NT$1,317,000"}},{"$f":"SUMIFS(tblData[金額],tblData[日期],\">=\"&DATE(YEAR(tblData[[#This Row],[日期]]),1,1),tblData[日期],\"<=\"&DATE(YEAR(tblData[[#This Row],[日期]]),12,31))","v":{"v":4314000,"d":"NT$4,314,000"}},{"$f":"IFERROR(TREND($L$6:INDEX($L:$L,ROW(),1),$K$6:INDEX($K:$K,ROW(),1),IF(MONTH(tblData[[#This Row],[日期]])=12,13,MONTH(tblData[[#This Row],[日期]])+1)),\"\")","v":{"v":659914.1742522757,"d":"NT$659,914"}},{"$f":"IFERROR(TREND($M$6:INDEX($M:$M,ROW(),1),$I$6:INDEX($I:$I,ROW(),1),IF(tblData[[#This Row],[季度]]=4,5,tblData[[#This Row],[季度]]+1)),\"\")","v":{"v":1254333.3333333335,"d":"NT$1,254,333"}},{"$f":"IFERROR(TREND($N$6:INDEX($N:$N,ROW(),1),$J$6:INDEX($J:$J,ROW(),1),tblData[[#This Row],[年度]]+1),\"\")","v":{"v":4314000,"d":"NT$4,314,000"}}]
[null,{"$f":"40878+(365*2)","v":"2013-11-30"},"正人資源",{"v":225000,"d":"NT$225,000"},{"v":240000,"d":"NT$240,000"},{"v":175500,"d":"NT$175,500"},{"$f":"tblData[[#This Row],[金額]]-tblData[[#This Row],[成本]]","v":{"v":49500,"d":"NT$49,500"}},{"$f":"DATE(YEAR(資料項目!$B23),MONTH(資料項目!$B23),1)","v":"2013-11-01"},{"$f":"LOOKUP(MONTH(資料項目!$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":" 第 4 季"}},{"$f":"YEAR(資料項目!$B23)","v":2013},{"$f":"MONTH(tblData[[#This Row],[日期]])","v":11},{"$f":"SUMIFS(tblData[金額],tblData[日期],\">=\"&EOMONTH(tblData[[#This Row],[日期]],-1)+1,tblData[日期],\"<=\"&EOMONTH(tblData[[#This Row],[日期]],0))","v":{"v":768000,"d":"NT$768,000"}},{"$f":"SUMIFS(tblData[金額],tblData[日期],\">=\"&DATE(YEAR(tblData[[#This Row],[日期]]),1,1),tblData[日期],\"<=\"&DATE(YEAR(tblData[[#This Row],[日期]]),12,31),tblData[季度],tblData[[#This Row],[季度]])","v":{"v":1317000,"d":"NT$1,317,000"}},{"$f":"SUMIFS(tblData[金額],tblData[日期],\">=\"&DATE(YEAR(tblData[[#This Row],[日期]]),1,1),tblData[日期],\"<=\"&DATE(YEAR(tblData[[#This Row],[日期]]),12,31))","v":{"v":4314000,"d":"NT$4,314,000"}},{"$f":"IFERROR(TREND($L$6:INDEX($L:$L,ROW(),1),$K$6:INDEX($K:$K,ROW(),1),IF(MONTH(tblData[[#This Row],[日期]])=12,13,MONTH(tblData[[#This Row],[日期]])+1)),\"\")","v":{"v":687529.0356952585,"d":"NT$687,529"}},{"$f":"IFERROR(TREND($M$6:INDEX($M:$M,ROW(),1),$I$6:INDEX($I:$I,ROW(),1),IF(tblData[[#This Row],[季度]]=4,5,tblData[[#This Row],[季度]]+1)),\"\")","v":{"v":1245000,"d":"NT$1,245,000"}},{"$f":"IFERROR(TREND($N$6:INDEX($N:$N,ROW(),1),$J$6:INDEX($J:$J,ROW(),1),tblData[[#This Row],[年度]]+1),\"\")","v":{"v":4314000,"d":"NT$4,314,000"}}]
[null,{"$f":"40889+(365*2)","v":"2013-12-11"},"Contoso 製藥",{"v":285000,"d":"NT$285,000"},{"v":276000,"d":"NT$276,000"},{"v":255000,"d":"NT$255,000"},{"$f":"tblData[[#This Row],[金額]]-tblData[[#This Row],[成本]]","v":{"v":30000,"d":"NT$30,000"}},{"$f":"DATE(YEAR(資料項目!$B24),MONTH(資料項目!$B24),1)","v":"2013-12-01"},{"$f":"LOOKUP(MONTH(資料項目!$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":" 第 4 季"}},{"$f":"YEAR(資料項目!$B24)","v":2013},{"$f":"MONTH(tblData[[#This Row],[日期]])","v":12},{"$f":"SUMIFS(tblData[金額],tblData[日期],\">=\"&EOMONTH(tblData[[#This Row],[日期]],-1)+1,tblData[日期],\"<=\"&EOMONTH(tblData[[#This Row],[日期]],0))","v":{"v":285000,"d":"NT$285,000"}},{"$f":"SUMIFS(tblData[金額],tblData[日期],\">=\"&DATE(YEAR(tblData[[#This Row],[日期]]),1,1),tblData[日期],\"<=\"&DATE(YEAR(tblData[[#This Row],[日期]]),12,31),tblData[季度],tblData[[#This Row],[季度]])","v":{"v":1317000,"d":"NT$1,317,000"}},{"$f":"SUMIFS(tblData[金額],tblData[日期],\">=\"&DATE(YEAR(tblData[[#This Row],[日期]]),1,1),tblData[日期],\"<=\"&DATE(YEAR(tblData[[#This Row],[日期]]),12,31))","v":{"v":4314000,"d":"NT$4,314,000"}},{"$f":"IFERROR(TREND($L$6:INDEX($L:$L,ROW(),1),$K$6:INDEX($K:$K,ROW(),1),IF(MONTH(tblData[[#This Row],[日期]])=12,13,MONTH(tblData[[#This Row],[日期]])+1)),\"\")","v":{"v":615129.4416243655,"d":"NT$615,129"}},{"$f":"IFERROR(TREND($M$6:INDEX($M:$M,ROW(),1),$I$6:INDEX($I:$I,ROW(),1),IF(tblData[[#This Row],[季度]]=4,5,tblData[[#This Row],[季度]]+1)),\"\")","v":{"v":1238647.0588235294,"d":"NT$1,238,647"}},{"$f":"IFERROR(TREND($N$6:INDEX($N:$N,ROW(),1),$J$6:INDEX($J:$J,ROW(),1),tblData[[#This Row],[年度]]+1),\"\")","v":{"v":4314000,"d":"NT$4,314,000"}}]

{"sheet":"銷售報表","index":1,"n_rows":28,"n_cols":6,"rows_kept":28}
[]
[null,"每月 銷售報表"]
[]
[]
[null,"年度","季度","月份","公司","加總 - 金額"]
[null,2013,{"v":2,"d":" 第 2 季"},"2013-04-01","A. Datum Corporation",{"v":192000,"d":"NT$192,000"}]
[{"$nulls":4},"Contoso 製藥",{"v":246000,"d":"NT$246,000"}]
[{"$nulls":3},"2013-05-01","Consolidated Messenger",{"v":132000,"d":"NT$132,000"}]
[{"$nulls":4},"Proseware, Inc.",{"v":162000,"d":"NT$162,000"}]
[{"$nulls":4},"美術學校",{"v":174000,"d":"NT$174,000"}]
[{"$nulls":4},"正人資源",{"v":186000,"d":"NT$186,000"}]
[{"$nulls":3},"2013-06-01","A. Datum Corporation",{"v":207000,"d":"NT$207,000"}]
[{"$nulls":4},"Contoso 製藥",{"v":225000,"d":"NT$225,000"}]
[null,null,"Quarter 2 合計",null,null,{"v":1524000,"d":"NT$1,524,000"}]
[null,null,{"v":3,"d":" 第 3 季"},"2013-07-01","Consolidated Messenger",{"v":261000,"d":"NT$261,000"}]
[{"$nulls":3},"2013-08-01","Proseware, Inc.",{"v":255000,"d":"NT$255,000"}]
[{"$nulls":4},"美術學校",{"v":237000,"d":"NT$237,000"}]
[{"$nulls":3},"2013-09-01","Consolidated Messenger",{"v":279000,"d":"NT$279,000"}]
[{"$nulls":4},"Contoso 製藥",{"v":168000,"d":"NT$168,000"}]
[{"$nulls":4},"正人資源",{"v":273000,"d":"NT$273,000"}]
[null,null,"Quarter 3 合計",null,null,{"v":1473000,"d":"NT$1,473,000"}]
[null,null,{"v":4,"d":" 第 4 季"},"2013-10-01","Proseware, Inc.",{"v":264000,"d":"NT$264,000"}]
[{"$nulls":3},"2013-11-01","美術學校",{"v":273000,"d":"NT$273,000"}]
[{"$nulls":4},"正人資源",{"v":495000,"d":"NT$495,000"}]
[{"$nulls":3},"2013-12-01","Contoso 製藥",{"v":285000,"d":"NT$285,000"}]
[null,null,"Quarter 4 合計",null,null,{"v":1317000,"d":"NT$1,317,000"}]
[null,"2013 合計",{"$nulls":3},{"v":4314000,"d":"NT$4,314,000"}]
[null,"總計",{"$nulls":3},{"v":4314000,"d":"NT$4,314,000"}]

{"sheet":"銷售預估","index":2,"n_rows":43,"n_cols":10,"rows_kept":43}
[{"$nulls":8},{"$f":"\"TODAY'S DATE: \"&UPPER(TEXT(TODAY(),\"mmm d, yyyy\"))","v":"TODAY'S DATE: SEP 28, 2012"}]
[null,"每月 銷售預估"]
[null,{"$f":"\"今天的日期：\"&(TEXT(TODAY(),\"yyyy年M月d日\"))","v":"今天的日期：2012年9月28日"},null,{"$f":"--TRIM(RIGHT(I1,LEN(I1)-FIND(\":\",I1)))","v":"2012-09-28"}]
[]
[null,"本月份","實際額","計劃","差異","%","YTD 實際值","YTD 計劃值","YTD 差異","YTD %"]
[null,"數量",{"$f":"COUNTIF(資料項目!$B$6:$B$24,\">=\"&DATE(fYear,MONTH(fDate),1))-COUNTIF(資料項目!$B$6:$B$24,\">\"&EOMONTH(fDate,0))","v":0},{"$nulls":3},{"$f":"COUNTIF(tblData[日期],\"<=\"&EOMONTH(fDate,0))","v":0}]
[null,"銷售",{"$f":"SUMIF(tblData[日期],\">=\"&DATE(fYear,MONTH(fDate),1),tblData[金額])-SUMIF(tblData[日期],\">\"&EOMONTH(fDate,0),tblData[金額])","v":0},{"$f":"SUMIF(資料項目!$B$6:$B$24,\">=\"&DATE(fYear,MONTH(fDate),1),資料項目!$E$6:$E$24)-SUMIF(資料項目!$B$6:$B$24,\">\"&EOMONTH(fDate,0),資料項目!$E$6:$E$24)","v":0},{"$f":"D7-C7","v":0},{"$f":"IFERROR(D7/C7,\"-\")","v":"-"},{"$f":"SUMIF(tblData[日期],\"<=\"&EOMONTH(fDate,0),tblData[金額])","v":0},{"$f":"SUMIF(tblData[日期],\"<=\"&EOMONTH(fDate,0),tblData[計劃])","v":0},{"$f":"H7-G7","v":0},{"$f":"IFERROR(H7/G7,\"\")","v":""}]
[null,"營收",{"$f":"(SUMIF(tblData[日期],\">=\"&DATE(fYear,MONTH(fDate),1),tblData[金額])-SUMIF(tblData[日期],\">\"&EOMONTH(fDate,0),tblData[金額]))-(SUMIF(tblData[日期],\">=\"&DATE(fYear,MONTH(fDate),1),tblData[成本])-SUMIF(tblData[日期],\">\"&EOMONTH(fDate,0),tblData[成本]))","v":0},{"$f":"(SUMIF(資料項目!$B$6:$B$24,\">=\"&DATE(fYear,MONTH(fDate),1),資料項目!$E$6:$E$24)-SUMIF(資料項目!$B$6:$B$24,\">\"&EOMONTH(fDate,0),資料項目!$E$6:$E$24))-(SUMIF(資料項目!$B$6:$B$24,\">=\"&DATE(fYear,MONTH(fDate),1),資料項目!$F$6:$F$24)-SUMIF(資料項目!$B$6:$B$24,\">\"&EOMONTH(fDate,0),資料項目!$F$6:$F$24))","v":0},{"$f":"D8-C8","v":0},{"$f":"IFERROR(D8/C8,\"-\")","v":"-"},{"$f":"SUMIF(資料項目!$B$6:$B$24,\"<=\"&EOMONTH(fDate,0),資料項目!$F$6:$F$24)","v":0},{"$f":"SUMIF(tblData[日期],\"<=\"&EOMONTH(fDate,0),tblData[成本])","v":0},{"$f":"H8-G8","v":0},{"$f":"IFERROR(H8/G8,\"\")","v":""}]
[null,"利潤",{"$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,"訂單數量",{"$f":"COUNTIF(tblData[日期],\">=\"&DATE(fYear,MONTH(fDate),1))-COUNTIF(tblData[日期],\">\"&EOMONTH(fDate,0))","v":0},{"$nulls":3},{"$f":"COUNTIF(tblData[日期],\">\"&EOMONTH(fDate,0))","v":{"v":19,"d":"NT$19"}}]
[null,"平均訂單價值",{"$f":"IFERROR(C7/C10,\"-\")","v":"-"},{"$nulls":3},{"$f":"IFERROR(G7/G10,\"-\")","v":0}]
[]
[null,"預測",null,"下一月",null,"下一季度",null,null,"下一年"]
[null,"銷售",null,{"$f":"TREND(tblData[[月份 ]],tblData[MONTH NUM (HIDE)],IF(MONTH(fDate)=12,13,MONTH(fDate)+1))","v":{"v":583557.1065989847,"d":"NT$583,557.11"}},null,{"$f":"TREND(tblData[[季度 ]],tblData[MONTH NUM (HIDE)],IF(MONTH(fDate)=12,13,MONTH(fDate)+1))","v":{"v":1382969.5431472082,"d":"NT$1,382,969.54"}},null,null,{"$f":"TREND(tblData[[整年 ]],tblData[MONTH NUM (HIDE)],IF(MONTH(fDate)=12,13,MONTH(fDate)+1))","v":{"v":4314000,"d":"NT$4,314,000.00"}}]
[]
[null,"銷售歷史"]
{"$rows_empty":13}
[null,"月度預測",{"$nulls":3},"季度預測"]
{"$rows_empty":7}
[null,"年度預測",{"$nulls":3},"收益額"]
[]
[]
[]
[]
[{"$nulls":9}," "]