{"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,"日期","公司","金额","计划","成本","收入","月","季度","年","月 ","月  ","季度 ","每年 ","月   ","季度  ","年  "]
[null,{"$f":"40657+(365*2)","v":"2013-04-23"},"三捷实业",{"v":64000,"d":"¥64,000.00"},{"v":62000,"d":"¥62,000.00"},{"v":44500,"d":"¥44,500.00"},{"$f":"tblData[[#This Row],[金额]]-tblData[[#This Row],[成本]]","v":{"v":19500,"d":"¥19,500.00"}},{"$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":146000,"d":"¥146,000.00"}},{"$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":508000,"d":"¥508,000.00"}},{"$f":"SUMIFS(tblData[金额],tblData[日期],\">=\"&DATE(YEAR(tblData[[#This Row],[日期]]),1,1),tblData[日期],\"<=\"&DATE(YEAR(tblData[[#This Row],[日期]]),12,31))","v":{"v":1438000,"d":"¥1,438,000.00"}},{"$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":146000,"d":"¥146,000.00"}},{"$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":508000,"d":"¥508,000.00"}},{"$f":"IFERROR(TREND($N$6:INDEX($N:$N,ROW(),1),$J$6:INDEX($J:$J,ROW(),1),tblData[[#This Row],[年]]+1),\"\")","v":{"v":1438000,"d":"¥1,438,000.00"}}]
[null,{"$f":"40659+(365*2)","v":"2013-04-25"},"康浦制药",{"v":82000,"d":"¥82,000.00"},{"v":80000,"d":"¥80,000.00"},{"v":64000,"d":"¥64,000.00"},{"$f":"tblData[[#This Row],[金额]]-tblData[[#This Row],[成本]]","v":{"v":18000,"d":"¥18,000.00"}},{"$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":146000,"d":"¥146,000.00"}},{"$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":508000,"d":"¥508,000.00"}},{"$f":"SUMIFS(tblData[金额],tblData[日期],\">=\"&DATE(YEAR(tblData[[#This Row],[日期]]),1,1),tblData[日期],\"<=\"&DATE(YEAR(tblData[[#This Row],[日期]]),12,31))","v":{"v":1438000,"d":"¥1,438,000.00"}},{"$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":146000,"d":"¥146,000.00"}},{"$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":508000,"d":"¥508,000.00"}},{"$f":"IFERROR(TREND($N$6:INDEX($N:$N,ROW(),1),$J$6:INDEX($J:$J,ROW(),1),tblData[[#This Row],[年]]+1),\"\")","v":{"v":1438000,"d":"¥1,438,000.00"}}]
[null,{"$f":"40671+(365*2)","v":"2013-05-07"},"百达",{"v":44000,"d":"¥44,000.00"},{"v":42000,"d":"¥42,000.00"},{"v":26000,"d":"¥26,000.00"},{"$f":"tblData[[#This Row],[金额]]-tblData[[#This Row],[成本]]","v":{"v":18000,"d":"¥18,000.00"}},{"$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":218000,"d":"¥218,000.00"}},{"$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":508000,"d":"¥508,000.00"}},{"$f":"SUMIFS(tblData[金额],tblData[日期],\">=\"&DATE(YEAR(tblData[[#This Row],[日期]]),1,1),tblData[日期],\"<=\"&DATE(YEAR(tblData[[#This Row],[日期]]),12,31))","v":{"v":1438000,"d":"¥1,438,000.00"}},{"$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":290000.00000000006,"d":"¥290,000.00"}},{"$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":508000,"d":"¥508,000.00"}},{"$f":"IFERROR(TREND($N$6:INDEX($N:$N,ROW(),1),$J$6:INDEX($J:$J,ROW(),1),tblData[[#This Row],[年]]+1),\"\")","v":{"v":1438000,"d":"¥1,438,000.00"}}]
[null,{"$f":"40678+(365*2)","v":"2013-05-14"},"同恒公司",{"v":54000,"d":"¥54,000.00"},{"v":55000,"d":"¥55,000.00"},{"v":45000,"d":"¥45,000.00"},{"$f":"tblData[[#This Row],[金额]]-tblData[[#This Row],[成本]]","v":{"v":9000,"d":"¥9,000.00"}},{"$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":218000,"d":"¥218,000.00"}},{"$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":508000,"d":"¥508,000.00"}},{"$f":"SUMIFS(tblData[金额],tblData[日期],\">=\"&DATE(YEAR(tblData[[#This Row],[日期]]),1,1),tblData[日期],\"<=\"&DATE(YEAR(tblData[[#This Row],[日期]]),12,31))","v":{"v":1438000,"d":"¥1,438,000.00"}},{"$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":289999.99999999994,"d":"¥290,000.00"}},{"$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":508000,"d":"¥508,000.00"}},{"$f":"IFERROR(TREND($N$6:INDEX($N:$N,ROW(),1),$J$6:INDEX($J:$J,ROW(),1),tblData[[#This Row],[年]]+1),\"\")","v":{"v":1438000,"d":"¥1,438,000.00"}}]
[null,{"$f":"40678+(365*2)","v":"2013-05-14"},"凡雅艺术学院",{"v":58000,"d":"¥58,000.00"},{"v":60000,"d":"¥60,000.00"},{"v":45000,"d":"¥45,000.00"},{"$f":"tblData[[#This Row],[金额]]-tblData[[#This Row],[成本]]","v":{"v":13000,"d":"¥13,000.00"}},{"$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":218000,"d":"¥218,000.00"}},{"$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":508000,"d":"¥508,000.00"}},{"$f":"SUMIFS(tblData[金额],tblData[日期],\">=\"&DATE(YEAR(tblData[[#This Row],[日期]]),1,1),tblData[日期],\"<=\"&DATE(YEAR(tblData[[#This Row],[日期]]),12,31))","v":{"v":1438000,"d":"¥1,438,000.00"}},{"$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":290000,"d":"¥290,000.00"}},{"$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":508000,"d":"¥508,000.00"}},{"$f":"IFERROR(TREND($N$6:INDEX($N:$N,ROW(),1),$J$6:INDEX($J:$J,ROW(),1),tblData[[#This Row],[年]]+1),\"\")","v":{"v":1438000,"d":"¥1,438,000.00"}}]
[null,{"$f":"40693+(365*2)","v":"2013-05-29"},"光明杂志",{"v":62000,"d":"¥62,000.00"},{"v":60000,"d":"¥60,000.00"},{"v":45000,"d":"¥45,000.00"},{"$f":"tblData[[#This Row],[金额]]-tblData[[#This Row],[成本]]","v":{"v":17000,"d":"¥17,000.00"}},{"$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":218000,"d":"¥218,000.00"}},{"$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":508000,"d":"¥508,000.00"}},{"$f":"SUMIFS(tblData[金额],tblData[日期],\">=\"&DATE(YEAR(tblData[[#This Row],[日期]]),1,1),tblData[日期],\"<=\"&DATE(YEAR(tblData[[#This Row],[日期]]),12,31))","v":{"v":1438000,"d":"¥1,438,000.00"}},{"$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":290000,"d":"¥290,000.00"}},{"$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":508000,"d":"¥508,000.00"}},{"$f":"IFERROR(TREND($N$6:INDEX($N:$N,ROW(),1),$J$6:INDEX($J:$J,ROW(),1),tblData[[#This Row],[年]]+1),\"\")","v":{"v":1438000,"d":"¥1,438,000.00"}}]
[null,{"$f":"40705+(365*2)","v":"2013-06-10"},"三捷实业",{"v":69000,"d":"¥69,000.00"},{"v":75000,"d":"¥75,000.00"},{"v":54000,"d":"¥54,000.00"},{"$f":"tblData[[#This Row],[金额]]-tblData[[#This Row],[成本]]","v":{"v":15000,"d":"¥15,000.00"}},{"$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":144000,"d":"¥144,000.00"}},{"$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":508000,"d":"¥508,000.00"}},{"$f":"SUMIFS(tblData[金额],tblData[日期],\">=\"&DATE(YEAR(tblData[[#This Row],[日期]]),1,1),tblData[日期],\"<=\"&DATE(YEAR(tblData[[#This Row],[日期]]),12,31))","v":{"v":1438000,"d":"¥1,438,000.00"}},{"$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":216000,"d":"¥216,000.00"}},{"$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":508000,"d":"¥508,000.00"}},{"$f":"IFERROR(TREND($N$6:INDEX($N:$N,ROW(),1),$J$6:INDEX($J:$J,ROW(),1),tblData[[#This Row],[年]]+1),\"\")","v":{"v":1438000,"d":"¥1,438,000.00"}}]
[null,{"$f":"40716+(365*2)","v":"2013-06-21"},"康浦制药",{"v":75000,"d":"¥75,000.00"},{"v":72000,"d":"¥72,000.00"},{"v":65000,"d":"¥65,000.00"},{"$f":"tblData[[#This Row],[金额]]-tblData[[#This Row],[成本]]","v":{"v":10000,"d":"¥10,000.00"}},{"$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":144000,"d":"¥144,000.00"}},{"$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":508000,"d":"¥508,000.00"}},{"$f":"SUMIFS(tblData[金额],tblData[日期],\">=\"&DATE(YEAR(tblData[[#This Row],[日期]]),1,1),tblData[日期],\"<=\"&DATE(YEAR(tblData[[#This Row],[日期]]),12,31))","v":{"v":1438000,"d":"¥1,438,000.00"}},{"$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":179500,"d":"¥179,500.00"}},{"$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":508000,"d":"¥508,000.00"}},{"$f":"IFERROR(TREND($N$6:INDEX($N:$N,ROW(),1),$J$6:INDEX($J:$J,ROW(),1),tblData[[#This Row],[年]]+1),\"\")","v":{"v":1438000,"d":"¥1,438,000.00"}}]
[null,{"$f":"40731+(365*2)","v":"2013-07-06"},"百达",{"v":87000,"d":"¥87,000.00"},{"v":85000,"d":"¥85,000.00"},{"v":72500,"d":"¥72,500.00"},{"$f":"tblData[[#This Row],[金额]]-tblData[[#This Row],[成本]]","v":{"v":14500,"d":"¥14,500.00"}},{"$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":87000,"d":"¥87,000.00"}},{"$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":491000,"d":"¥491,000.00"}},{"$f":"SUMIFS(tblData[金额],tblData[日期],\">=\"&DATE(YEAR(tblData[[#This Row],[日期]]),1,1),tblData[日期],\"<=\"&DATE(YEAR(tblData[[#This Row],[日期]]),12,31))","v":{"v":1438000,"d":"¥1,438,000.00"}},{"$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":107764.70588235298,"d":"¥107,764.71"}},{"$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":474000,"d":"¥474,000.00"}},{"$f":"IFERROR(TREND($N$6:INDEX($N:$N,ROW(),1),$J$6:INDEX($J:$J,ROW(),1),tblData[[#This Row],[年]]+1),\"\")","v":{"v":1438000,"d":"¥1,438,000.00"}}]
[null,{"$f":"40761+(365*2)","v":"2013-08-05"},"同恒公司",{"v":85000,"d":"¥85,000.00"},{"v":83000,"d":"¥83,000.00"},{"v":71000,"d":"¥71,000.00"},{"$f":"tblData[[#This Row],[金额]]-tblData[[#This Row],[成本]]","v":{"v":14000,"d":"¥14,000.00"}},{"$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":164000,"d":"¥164,000.00"}},{"$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":491000,"d":"¥491,000.00"}},{"$f":"SUMIFS(tblData[金额],tblData[日期],\">=\"&DATE(YEAR(tblData[[#This Row],[日期]]),1,1),tblData[日期],\"<=\"&DATE(YEAR(tblData[[#This Row],[日期]]),12,31))","v":{"v":1438000,"d":"¥1,438,000.00"}},{"$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":124558.62068965519,"d":"¥124,558.62"}},{"$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":474000,"d":"¥474,000.00"}},{"$f":"IFERROR(TREND($N$6:INDEX($N:$N,ROW(),1),$J$6:INDEX($J:$J,ROW(),1),tblData[[#This Row],[年]]+1),\"\")","v":{"v":1438000,"d":"¥1,438,000.00"}}]
[null,{"$f":"40775+(365*2)","v":"2013-08-19"},"凡雅艺术学院",{"v":79000,"d":"¥79,000.00"},{"v":77000,"d":"¥77,000.00"},{"v":66000,"d":"¥66,000.00"},{"$f":"tblData[[#This Row],[金额]]-tblData[[#This Row],[成本]]","v":{"v":13000,"d":"¥13,000.00"}},{"$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":164000,"d":"¥164,000.00"}},{"$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":491000,"d":"¥491,000.00"}},{"$f":"SUMIFS(tblData[金额],tblData[日期],\">=\"&DATE(YEAR(tblData[[#This Row],[日期]]),1,1),tblData[日期],\"<=\"&DATE(YEAR(tblData[[#This Row],[日期]]),12,31))","v":{"v":1438000,"d":"¥1,438,000.00"}},{"$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":136675.67567567568,"d":"¥136,675.68"}},{"$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":474000,"d":"¥474,000.00"}},{"$f":"IFERROR(TREND($N$6:INDEX($N:$N,ROW(),1),$J$6:INDEX($J:$J,ROW(),1),tblData[[#This Row],[年]]+1),\"\")","v":{"v":1438000,"d":"¥1,438,000.00"}}]
[null,{"$f":"40791+(365*2)","v":"2013-09-04"},"光明杂志",{"v":91000,"d":"¥91,000.00"},{"v":89000,"d":"¥89,000.00"},{"v":79000,"d":"¥79,000.00"},{"$f":"tblData[[#This Row],[金额]]-tblData[[#This Row],[成本]]","v":{"v":12000,"d":"¥12,000.00"}},{"$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":240000,"d":"¥240,000.00"}},{"$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":491000,"d":"¥491,000.00"}},{"$f":"SUMIFS(tblData[金额],tblData[日期],\">=\"&DATE(YEAR(tblData[[#This Row],[日期]]),1,1),tblData[日期],\"<=\"&DATE(YEAR(tblData[[#This Row],[日期]]),12,31))","v":{"v":1438000,"d":"¥1,438,000.00"}},{"$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":176516.6666666667,"d":"¥176,516.67"}},{"$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":474000,"d":"¥474,000.00"}},{"$f":"IFERROR(TREND($N$6:INDEX($N:$N,ROW(),1),$J$6:INDEX($J:$J,ROW(),1),tblData[[#This Row],[年]]+1),\"\")","v":{"v":1438000,"d":"¥1,438,000.00"}}]
[null,{"$f":"40807+(365*2)","v":"2013-09-20"},"康浦制药",{"v":56000,"d":"¥56,000.00"},{"v":58000,"d":"¥58,000.00"},{"v":45000,"d":"¥45,000.00"},{"$f":"tblData[[#This Row],[金额]]-tblData[[#This Row],[成本]]","v":{"v":11000,"d":"¥11,000.00"}},{"$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":240000,"d":"¥240,000.00"}},{"$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":491000,"d":"¥491,000.00"}},{"$f":"SUMIFS(tblData[金额],tblData[日期],\">=\"&DATE(YEAR(tblData[[#This Row],[日期]]),1,1),tblData[日期],\"<=\"&DATE(YEAR(tblData[[#This Row],[日期]]),12,31))","v":{"v":1438000,"d":"¥1,438,000.00"}},{"$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":198779.11646586342,"d":"¥198,779.12"}},{"$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":474000,"d":"¥474,000.00"}},{"$f":"IFERROR(TREND($N$6:INDEX($N:$N,ROW(),1),$J$6:INDEX($J:$J,ROW(),1),tblData[[#This Row],[年]]+1),\"\")","v":{"v":1438000,"d":"¥1,438,000.00"}}]
[null,{"$f":"40812+(365*2)","v":"2013-09-25"},"百达",{"v":93000,"d":"¥93,000.00"},{"v":91000,"d":"¥91,000.00"},{"v":75000,"d":"¥75,000.00"},{"$f":"tblData[[#This Row],[金额]]-tblData[[#This Row],[成本]]","v":{"v":18000,"d":"¥18,000.00"}},{"$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":240000,"d":"¥240,000.00"}},{"$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":491000,"d":"¥491,000.00"}},{"$f":"SUMIFS(tblData[金额],tblData[日期],\">=\"&DATE(YEAR(tblData[[#This Row],[日期]]),1,1),tblData[日期],\"<=\"&DATE(YEAR(tblData[[#This Row],[日期]]),12,31))","v":{"v":1438000,"d":"¥1,438,000.00"}},{"$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":211380.5031446541,"d":"¥211,380.50"}},{"$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":474000,"d":"¥474,000.00"}},{"$f":"IFERROR(TREND($N$6:INDEX($N:$N,ROW(),1),$J$6:INDEX($J:$J,ROW(),1),tblData[[#This Row],[年]]+1),\"\")","v":{"v":1438000,"d":"¥1,438,000.00"}}]
[null,{"$f":"40832+(365*2)","v":"2013-10-15"},"同恒公司",{"v":88000,"d":"¥88,000.00"},{"v":93500,"d":"¥93,500.00"},{"v":71000,"d":"¥71,000.00"},{"$f":"tblData[[#This Row],[金额]]-tblData[[#This Row],[成本]]","v":{"v":17000,"d":"¥17,000.00"}},{"$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":88000,"d":"¥88,000.00"}},{"$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":439000,"d":"¥439,000.00"}},{"$f":"SUMIFS(tblData[金额],tblData[日期],\">=\"&DATE(YEAR(tblData[[#This Row],[日期]]),1,1),tblData[日期],\"<=\"&DATE(YEAR(tblData[[#This Row],[日期]]),12,31))","v":{"v":1438000,"d":"¥1,438,000.00"}},{"$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":179517.44186046513,"d":"¥179,517.44"}},{"$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":432581.39534883725,"d":"¥432,581.40"}},{"$f":"IFERROR(TREND($N$6:INDEX($N:$N,ROW(),1),$J$6:INDEX($J:$J,ROW(),1),tblData[[#This Row],[年]]+1),\"\")","v":{"v":1438000,"d":"¥1,438,000.00"}}]
[null,{"$f":"40853+(365*2)","v":"2013-11-05"},"凡雅艺术学院",{"v":91000,"d":"¥91,000.00"},{"v":92000,"d":"¥92,000.00"},{"v":78500,"d":"¥78,500.00"},{"$f":"tblData[[#This Row],[金额]]-tblData[[#This Row],[成本]]","v":{"v":12500,"d":"¥12,500.00"}},{"$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":256000,"d":"¥256,000.00"}},{"$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":439000,"d":"¥439,000.00"}},{"$f":"SUMIFS(tblData[金额],tblData[日期],\">=\"&DATE(YEAR(tblData[[#This Row],[日期]]),1,1),tblData[日期],\"<=\"&DATE(YEAR(tblData[[#This Row],[日期]]),12,31))","v":{"v":1438000,"d":"¥1,438,000.00"}},{"$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":205561.30108423688,"d":"¥205,561.30"}},{"$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":423129.0322580645,"d":"¥423,129.03"}},{"$f":"IFERROR(TREND($N$6:INDEX($N:$N,ROW(),1),$J$6:INDEX($J:$J,ROW(),1),tblData[[#This Row],[年]]+1),\"\")","v":{"v":1438000,"d":"¥1,438,000.00"}}]
[null,{"$f":"40874+(365*2)","v":"2013-11-26"},"光明杂志",{"v":90000,"d":"¥90,000.00"},{"v":100000,"d":"¥100,000.00"},{"v":75750,"d":"¥75,750.00"},{"$f":"tblData[[#This Row],[金额]]-tblData[[#This Row],[成本]]","v":{"v":14250,"d":"¥14,250.00"}},{"$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":256000,"d":"¥256,000.00"}},{"$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":439000,"d":"¥439,000.00"}},{"$f":"SUMIFS(tblData[金额],tblData[日期],\">=\"&DATE(YEAR(tblData[[#This Row],[日期]]),1,1),tblData[日期],\"<=\"&DATE(YEAR(tblData[[#This Row],[日期]]),12,31))","v":{"v":1438000,"d":"¥1,438,000.00"}},{"$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":219971.39141742524,"d":"¥219,971.39"}},{"$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":418111.1111111111,"d":"¥418,111.11"}},{"$f":"IFERROR(TREND($N$6:INDEX($N:$N,ROW(),1),$J$6:INDEX($J:$J,ROW(),1),tblData[[#This Row],[年]]+1),\"\")","v":{"v":1438000,"d":"¥1,438,000.00"}}]
[null,{"$f":"40878+(365*2)","v":"2013-11-30"},"光明杂志",{"v":75000,"d":"¥75,000.00"},{"v":80000,"d":"¥80,000.00"},{"v":58500,"d":"¥58,500.00"},{"$f":"tblData[[#This Row],[金额]]-tblData[[#This Row],[成本]]","v":{"v":16500,"d":"¥16,500.00"}},{"$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":256000,"d":"¥256,000.00"}},{"$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":439000,"d":"¥439,000.00"}},{"$f":"SUMIFS(tblData[金额],tblData[日期],\">=\"&DATE(YEAR(tblData[[#This Row],[日期]]),1,1),tblData[日期],\"<=\"&DATE(YEAR(tblData[[#This Row],[日期]]),12,31))","v":{"v":1438000,"d":"¥1,438,000.00"}},{"$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":229176.34523175278,"d":"¥229,176.35"}},{"$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":415000,"d":"¥415,000.00"}},{"$f":"IFERROR(TREND($N$6:INDEX($N:$N,ROW(),1),$J$6:INDEX($J:$J,ROW(),1),tblData[[#This Row],[年]]+1),\"\")","v":{"v":1438000,"d":"¥1,438,000.00"}}]
[null,{"$f":"40889+(365*2)","v":"2013-12-11"},"康浦制药",{"v":95000,"d":"¥95,000.00"},{"v":92000,"d":"¥92,000.00"},{"v":85000,"d":"¥85,000.00"},{"$f":"tblData[[#This Row],[金额]]-tblData[[#This Row],[成本]]","v":{"v":10000,"d":"¥10,000.00"}},{"$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":95000,"d":"¥95,000.00"}},{"$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":439000,"d":"¥439,000.00"}},{"$f":"SUMIFS(tblData[金额],tblData[日期],\">=\"&DATE(YEAR(tblData[[#This Row],[日期]]),1,1),tblData[日期],\"<=\"&DATE(YEAR(tblData[[#This Row],[日期]]),12,31))","v":{"v":1438000,"d":"¥1,438,000.00"}},{"$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":205043.14720812184,"d":"¥205,043.15"}},{"$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":412882.35294117645,"d":"¥412,882.35"}},{"$f":"IFERROR(TREND($N$6:INDEX($N:$N,ROW(),1),$J$6:INDEX($J:$J,ROW(),1),tblData[[#This Row],[年]]+1),\"\")","v":{"v":1438000,"d":"¥1,438,000.00"}}]

{"sheet":"销售报告","index":1,"n_rows":28,"n_cols":6,"rows_kept":28}
[]
[null,"每月 销售报告"]
[]
[]
[null,"年","季度","月","公司","求和项:金额"]
[null,2013,{"v":2,"d":"季度 2"},"2013-04-01","康浦制药",{"v":82000,"d":"¥82,000.00"}]
[{"$nulls":4},"三捷实业",{"v":64000,"d":"¥64,000.00"}]
[{"$nulls":3},"2013-05-01","百达",{"v":44000,"d":"¥44,000.00"}]
[{"$nulls":4},"凡雅艺术学院",{"v":58000,"d":"¥58,000.00"}]
[{"$nulls":4},"光明杂志",{"v":62000,"d":"¥62,000.00"}]
[{"$nulls":4},"同恒公司",{"v":54000,"d":"¥54,000.00"}]
[{"$nulls":3},"2013-06-01","康浦制药",{"v":75000,"d":"¥75,000.00"}]
[{"$nulls":4},"三捷实业",{"v":69000,"d":"¥69,000.00"}]
[null,null,"第 2 季度总计",null,null,{"v":508000,"d":"¥508,000.00"}]
[null,null,{"v":3,"d":"季度 3"},"2013-07-01","百达",{"v":87000,"d":"¥87,000.00"}]
[{"$nulls":3},"2013-08-01","凡雅艺术学院",{"v":79000,"d":"¥79,000.00"}]
[{"$nulls":4},"同恒公司",{"v":85000,"d":"¥85,000.00"}]
[{"$nulls":3},"2013-09-01","百达",{"v":93000,"d":"¥93,000.00"}]
[{"$nulls":4},"光明杂志",{"v":91000,"d":"¥91,000.00"}]
[{"$nulls":4},"康浦制药",{"v":56000,"d":"¥56,000.00"}]
[null,null,"第 2 季度总计",null,null,{"v":491000,"d":"¥491,000.00"}]
[null,null,{"v":4,"d":"季度 4"},"2013-10-01","同恒公司",{"v":88000,"d":"¥88,000.00"}]
[{"$nulls":3},"2013-11-01","凡雅艺术学院",{"v":91000,"d":"¥91,000.00"}]
[{"$nulls":4},"光明杂志",{"v":165000,"d":"¥165,000.00"}]
[{"$nulls":3},"2013-12-01","康浦制药",{"v":95000,"d":"¥95,000.00"}]
[null,null,"第 2 季度总计",null,null,{"v":439000,"d":"¥439,000.00"}]
[null,"2013 总计",{"$nulls":3},{"v":1438000,"d":"¥1,438,000.00"}]
[null,"总计",{"$nulls":3},{"v":1438000,"d":"¥1,438,000.00"}]

{"sheet":"销售预测","index":2,"n_rows":85,"n_cols":11,"rows_kept":85}
[{"$nulls":10},{"$f":"\"TODAY'S DATE: \"&UPPER(TEXT(TODAY(),\"mmm d, yyyy\"))","v":"TODAY'S DATE: NOV 28, 2012"}]
[null,"每月 销售预测"]
[null,{"$f":"\"今天的日期 : \"&UPPER(TEXT(TODAY(),\" yyyy年 m月 d日\"))","v":"今天的日期 :  2012年 11月 28日"},null,{"$f":"TRIM(RIGHT(B85,LEN(B85)-FIND(\":\",B85)))","v":"2012年11月28日"}]
[]
[null,"本月","实际","计划","差异","%","年初至今实际值","年初至今计划","年初至今差异","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":{"v":0,"d":"¥0.00"}},{"$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":{"v":0,"d":"¥0.00"}},{"$f":"D7-C7","v":{"v":0,"d":"¥0.00"}},{"$f":"IFERROR(D7/C7,\"-\")","v":"-"},{"$f":"SUMIF(tblData[日期],\"<=\"&EOMONTH(fDate,0),tblData[金额])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUMIF(tblData[日期],\"<=\"&EOMONTH(fDate,0),tblData[计划])","v":{"v":0,"d":"¥0.00"}},{"$f":"H7-G7","v":{"v":0,"d":"¥0.00"}},{"$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":{"v":0,"d":"¥0.00"}},{"$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":{"v":0,"d":"¥0.00"}},{"$f":"D8-C8","v":{"v":0,"d":"¥0.00"}},{"$f":"IFERROR(D8/C8,\"-\")","v":"-"},{"$f":"SUMIF(数据输入!$B$6:$B$24,\"<=\"&EOMONTH(fDate,0),数据输入!$F$6:$F$24)","v":{"v":0,"d":"¥0.00"}},{"$f":"SUMIF(tblData[日期],\"<=\"&EOMONTH(fDate,0),tblData[成本])","v":{"v":0,"d":"¥0.00"}},{"$f":"H8-G8","v":{"v":0,"d":"¥0.00"}},{"$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":19}]
[null,"平均订单价值",{"$f":"IFERROR(C7/C10,\"-\")","v":"-"},{"$nulls":3},{"$f":"IFERROR(G7/G10,\"-\")","v":{"v":0,"d":"¥0.00"}}]
[]
[null,"预测",null,"下个月",null,"下一季度",null,null,"下一年"]
[null,"销售",null,{"$f":"TREND(tblData[月],tblData[[月 ]],IF(MONTH(fDate)=12,13,MONTH(fDate)+1))","v":{"v":41609.471658206436,"d":"¥41,609.47"}},null,{"$f":"TREND(tblData[[季度 ]],tblData[[月 ]],IF(MONTH(fDate)=12,13,MONTH(fDate)+1))","v":{"v":441159.0524534687,"d":"¥441,159.05"}},null,null,{"$f":"TREND(tblData[[年  ]],tblData[[月 ]],IF(MONTH(fDate)=12,13,MONTH(fDate)+1))","v":{"v":1438000,"d":"¥1,438,000.00"}}]
[]
[null,"销售历史记录"]
{"$rows_empty":13}
[null,"月度预测",{"$nulls":3},"季度预测"]
{"$rows_empty":7}
[null,"年度预测",{"$nulls":3},"收入流"]
[]
[]
[]
[]
[{"$nulls":9}," "]
{"$rows_empty":41}
[null,{"$f":"\"今天的日期 : \"&UPPER(TEXT(TODAY(),\"[$-F800]yyyy,M,dd\"))","v":"今天的日期 : 2012年11月28日"}]