{"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"},"山門屋",{"v":640000,"d":"¥640,000"},{"v":620000,"d":"¥620,000"},{"v":445000,"d":"¥445,000"},{"$f":"tblData[[#This Row],[金額]]-tblData[[#This Row],[費用]]","v":{"v":195000,"d":"¥195,000"}},{"$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":1460000,"d":"¥1,460,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":5080000,"d":"¥5,080,000"}},{"$f":"SUMIFS(tblData[金額],tblData[日付],\">=\"&DATE(YEAR(tblData[[#This Row],[日付]]),1,1),tblData[日付],\"<=\"&DATE(YEAR(tblData[[#This Row],[日付]]),12,31))","v":{"v":14380000,"d":"¥14,380,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":1460000,"d":"¥1,460,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":5080000,"d":"¥5,080,000"}},{"$f":"IFERROR(TREND($N$6:INDEX($N:$N,ROW(),1),$J$6:INDEX($J:$J,ROW(),1),tblData[[#This Row],[年]]+1),\"\")","v":{"v":14380000,"d":"¥14,380,000"}}]
[null,{"$f":"40659+(365*2)","v":"2013-04-25"},"蓬莱堂",{"v":820000,"d":"¥820,000"},{"v":800000,"d":"¥800,000"},{"v":640000,"d":"¥640,000"},{"$f":"tblData[[#This Row],[金額]]-tblData[[#This Row],[費用]]","v":{"v":180000,"d":"¥180,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":1460000,"d":"¥1,460,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":5080000,"d":"¥5,080,000"}},{"$f":"SUMIFS(tblData[金額],tblData[日付],\">=\"&DATE(YEAR(tblData[[#This Row],[日付]]),1,1),tblData[日付],\"<=\"&DATE(YEAR(tblData[[#This Row],[日付]]),12,31))","v":{"v":14380000,"d":"¥14,380,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":1460000,"d":"¥1,460,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":5080000,"d":"¥5,080,000"}},{"$f":"IFERROR(TREND($N$6:INDEX($N:$N,ROW(),1),$J$6:INDEX($J:$J,ROW(),1),tblData[[#This Row],[年]]+1),\"\")","v":{"v":14380000,"d":"¥14,380,000"}}]
[null,{"$f":"40671+(365*2)","v":"2013-05-07"},"びしゃもんや",{"v":440000,"d":"¥440,000"},{"v":420000,"d":"¥420,000"},{"v":260000,"d":"¥260,000"},{"$f":"tblData[[#This Row],[金額]]-tblData[[#This Row],[費用]]","v":{"v":180000,"d":"¥180,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":2180000,"d":"¥2,180,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":5080000,"d":"¥5,080,000"}},{"$f":"SUMIFS(tblData[金額],tblData[日付],\">=\"&DATE(YEAR(tblData[[#This Row],[日付]]),1,1),tblData[日付],\"<=\"&DATE(YEAR(tblData[[#This Row],[日付]]),12,31))","v":{"v":14380000,"d":"¥14,380,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":2900000,"d":"¥2,900,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":5080000,"d":"¥5,080,000"}},{"$f":"IFERROR(TREND($N$6:INDEX($N:$N,ROW(),1),$J$6:INDEX($J:$J,ROW(),1),tblData[[#This Row],[年]]+1),\"\")","v":{"v":14380000,"d":"¥14,380,000"}}]
[null,{"$f":"40678+(365*2)","v":"2013-05-14"},"肥後株式会社",{"v":540000,"d":"¥540,000"},{"v":550000,"d":"¥550,000"},{"v":450000,"d":"¥450,000"},{"$f":"tblData[[#This Row],[金額]]-tblData[[#This Row],[費用]]","v":{"v":90000,"d":"¥90,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":2180000,"d":"¥2,180,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":5080000,"d":"¥5,080,000"}},{"$f":"SUMIFS(tblData[金額],tblData[日付],\">=\"&DATE(YEAR(tblData[[#This Row],[日付]]),1,1),tblData[日付],\"<=\"&DATE(YEAR(tblData[[#This Row],[日付]]),12,31))","v":{"v":14380000,"d":"¥14,380,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":2900000,"d":"¥2,900,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":5080000,"d":"¥5,080,000"}},{"$f":"IFERROR(TREND($N$6:INDEX($N:$N,ROW(),1),$J$6:INDEX($J:$J,ROW(),1),tblData[[#This Row],[年]]+1),\"\")","v":{"v":14380000,"d":"¥14,380,000"}}]
[null,{"$f":"40678+(365*2)","v":"2013-05-14"},"大宮ユニオン",{"v":580000,"d":"¥580,000"},{"v":600000,"d":"¥600,000"},{"v":450000,"d":"¥450,000"},{"$f":"tblData[[#This Row],[金額]]-tblData[[#This Row],[費用]]","v":{"v":130000,"d":"¥130,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":2180000,"d":"¥2,180,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":5080000,"d":"¥5,080,000"}},{"$f":"SUMIFS(tblData[金額],tblData[日付],\">=\"&DATE(YEAR(tblData[[#This Row],[日付]]),1,1),tblData[日付],\"<=\"&DATE(YEAR(tblData[[#This Row],[日付]]),12,31))","v":{"v":14380000,"d":"¥14,380,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":2900000.0000000005,"d":"¥2,900,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":5080000,"d":"¥5,080,000"}},{"$f":"IFERROR(TREND($N$6:INDEX($N:$N,ROW(),1),$J$6:INDEX($J:$J,ROW(),1),tblData[[#This Row],[年]]+1),\"\")","v":{"v":14380000,"d":"¥14,380,000"}}]
[null,{"$f":"40693+(365*2)","v":"2013-05-29"},"ヒロコーポレーション",{"v":620000,"d":"¥620,000"},{"v":600000,"d":"¥600,000"},{"v":450000,"d":"¥450,000"},{"$f":"tblData[[#This Row],[金額]]-tblData[[#This Row],[費用]]","v":{"v":170000,"d":"¥170,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":2180000,"d":"¥2,180,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":5080000,"d":"¥5,080,000"}},{"$f":"SUMIFS(tblData[金額],tblData[日付],\">=\"&DATE(YEAR(tblData[[#This Row],[日付]]),1,1),tblData[日付],\"<=\"&DATE(YEAR(tblData[[#This Row],[日付]]),12,31))","v":{"v":14380000,"d":"¥14,380,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":2900000,"d":"¥2,900,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":5080000,"d":"¥5,080,000"}},{"$f":"IFERROR(TREND($N$6:INDEX($N:$N,ROW(),1),$J$6:INDEX($J:$J,ROW(),1),tblData[[#This Row],[年]]+1),\"\")","v":{"v":14380000,"d":"¥14,380,000"}}]
[null,{"$f":"40705+(365*2)","v":"2013-06-10"},"山門屋",{"v":690000,"d":"¥690,000"},{"v":750000,"d":"¥750,000"},{"v":540000,"d":"¥540,000"},{"$f":"tblData[[#This Row],[金額]]-tblData[[#This Row],[費用]]","v":{"v":150000,"d":"¥150,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":1440000,"d":"¥1,440,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":5080000,"d":"¥5,080,000"}},{"$f":"SUMIFS(tblData[金額],tblData[日付],\">=\"&DATE(YEAR(tblData[[#This Row],[日付]]),1,1),tblData[日付],\"<=\"&DATE(YEAR(tblData[[#This Row],[日付]]),12,31))","v":{"v":14380000,"d":"¥14,380,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":2160000.0000000005,"d":"¥2,160,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":5080000,"d":"¥5,080,000"}},{"$f":"IFERROR(TREND($N$6:INDEX($N:$N,ROW(),1),$J$6:INDEX($J:$J,ROW(),1),tblData[[#This Row],[年]]+1),\"\")","v":{"v":14380000,"d":"¥14,380,000"}}]
[null,{"$f":"40716+(365*2)","v":"2013-06-21"},"蓬莱堂",{"v":750000,"d":"¥750,000"},{"v":720000,"d":"¥720,000"},{"v":650000,"d":"¥650,000"},{"$f":"tblData[[#This Row],[金額]]-tblData[[#This Row],[費用]]","v":{"v":100000,"d":"¥100,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":1440000,"d":"¥1,440,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":5080000,"d":"¥5,080,000"}},{"$f":"SUMIFS(tblData[金額],tblData[日付],\">=\"&DATE(YEAR(tblData[[#This Row],[日付]]),1,1),tblData[日付],\"<=\"&DATE(YEAR(tblData[[#This Row],[日付]]),12,31))","v":{"v":14380000,"d":"¥14,380,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":1795000,"d":"¥1,795,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":5080000,"d":"¥5,080,000"}},{"$f":"IFERROR(TREND($N$6:INDEX($N:$N,ROW(),1),$J$6:INDEX($J:$J,ROW(),1),tblData[[#This Row],[年]]+1),\"\")","v":{"v":14380000,"d":"¥14,380,000"}}]
[null,{"$f":"40731+(365*2)","v":"2013-07-06"},"びしゃもんや",{"v":870000,"d":"¥870,000"},{"v":850000,"d":"¥850,000"},{"v":725000,"d":"¥725,000"},{"$f":"tblData[[#This Row],[金額]]-tblData[[#This Row],[費用]]","v":{"v":145000,"d":"¥145,000"}},{"$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":870000,"d":"¥870,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":4910000,"d":"¥4,910,000"}},{"$f":"SUMIFS(tblData[金額],tblData[日付],\">=\"&DATE(YEAR(tblData[[#This Row],[日付]]),1,1),tblData[日付],\"<=\"&DATE(YEAR(tblData[[#This Row],[日付]]),12,31))","v":{"v":14380000,"d":"¥14,380,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":1077647.0588235294,"d":"¥1,077,647"}},{"$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":4740000,"d":"¥4,740,000"}},{"$f":"IFERROR(TREND($N$6:INDEX($N:$N,ROW(),1),$J$6:INDEX($J:$J,ROW(),1),tblData[[#This Row],[年]]+1),\"\")","v":{"v":14380000,"d":"¥14,380,000"}}]
[null,{"$f":"40761+(365*2)","v":"2013-08-05"},"肥後株式会社",{"v":850000,"d":"¥850,000"},{"v":830000,"d":"¥830,000"},{"v":710000,"d":"¥710,000"},{"$f":"tblData[[#This Row],[金額]]-tblData[[#This Row],[費用]]","v":{"v":140000,"d":"¥140,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":1640000,"d":"¥1,640,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":4910000,"d":"¥4,910,000"}},{"$f":"SUMIFS(tblData[金額],tblData[日付],\">=\"&DATE(YEAR(tblData[[#This Row],[日付]]),1,1),tblData[日付],\"<=\"&DATE(YEAR(tblData[[#This Row],[日付]]),12,31))","v":{"v":14380000,"d":"¥14,380,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":1245586.206896552,"d":"¥1,245,586"}},{"$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":4740000,"d":"¥4,740,000"}},{"$f":"IFERROR(TREND($N$6:INDEX($N:$N,ROW(),1),$J$6:INDEX($J:$J,ROW(),1),tblData[[#This Row],[年]]+1),\"\")","v":{"v":14380000,"d":"¥14,380,000"}}]
[null,{"$f":"40775+(365*2)","v":"2013-08-19"},"大宮ユニオン",{"v":790000,"d":"¥790,000"},{"v":770000,"d":"¥770,000"},{"v":660000,"d":"¥660,000"},{"$f":"tblData[[#This Row],[金額]]-tblData[[#This Row],[費用]]","v":{"v":130000,"d":"¥130,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":1640000,"d":"¥1,640,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":4910000,"d":"¥4,910,000"}},{"$f":"SUMIFS(tblData[金額],tblData[日付],\">=\"&DATE(YEAR(tblData[[#This Row],[日付]]),1,1),tblData[日付],\"<=\"&DATE(YEAR(tblData[[#This Row],[日付]]),12,31))","v":{"v":14380000,"d":"¥14,380,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":1366756.7567567565,"d":"¥1,366,757"}},{"$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":4740000,"d":"¥4,740,000"}},{"$f":"IFERROR(TREND($N$6:INDEX($N:$N,ROW(),1),$J$6:INDEX($J:$J,ROW(),1),tblData[[#This Row],[年]]+1),\"\")","v":{"v":14380000,"d":"¥14,380,000"}}]
[null,{"$f":"40791+(365*2)","v":"2013-09-04"},"ヒロコーポレーション",{"v":910000,"d":"¥910,000"},{"v":890000,"d":"¥890,000"},{"v":790000,"d":"¥790,000"},{"$f":"tblData[[#This Row],[金額]]-tblData[[#This Row],[費用]]","v":{"v":120000,"d":"¥120,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":2400000,"d":"¥2,400,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":4910000,"d":"¥4,910,000"}},{"$f":"SUMIFS(tblData[金額],tblData[日付],\">=\"&DATE(YEAR(tblData[[#This Row],[日付]]),1,1),tblData[日付],\"<=\"&DATE(YEAR(tblData[[#This Row],[日付]]),12,31))","v":{"v":14380000,"d":"¥14,380,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":1765166.6666666665,"d":"¥1,765,167"}},{"$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":4740000,"d":"¥4,740,000"}},{"$f":"IFERROR(TREND($N$6:INDEX($N:$N,ROW(),1),$J$6:INDEX($J:$J,ROW(),1),tblData[[#This Row],[年]]+1),\"\")","v":{"v":14380000,"d":"¥14,380,000"}}]
[null,{"$f":"40807+(365*2)","v":"2013-09-20"},"蓬莱堂",{"v":560000,"d":"¥560,000"},{"v":580000,"d":"¥580,000"},{"v":450000,"d":"¥450,000"},{"$f":"tblData[[#This Row],[金額]]-tblData[[#This Row],[費用]]","v":{"v":110000,"d":"¥110,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":2400000,"d":"¥2,400,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":4910000,"d":"¥4,910,000"}},{"$f":"SUMIFS(tblData[金額],tblData[日付],\">=\"&DATE(YEAR(tblData[[#This Row],[日付]]),1,1),tblData[日付],\"<=\"&DATE(YEAR(tblData[[#This Row],[日付]]),12,31))","v":{"v":14380000,"d":"¥14,380,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":1987791.1646586345,"d":"¥1,987,791"}},{"$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":4740000,"d":"¥4,740,000"}},{"$f":"IFERROR(TREND($N$6:INDEX($N:$N,ROW(),1),$J$6:INDEX($J:$J,ROW(),1),tblData[[#This Row],[年]]+1),\"\")","v":{"v":14380000,"d":"¥14,380,000"}}]
[null,{"$f":"40812+(365*2)","v":"2013-09-25"},"びしゃもんや",{"v":930000,"d":"¥930,000"},{"v":910000,"d":"¥910,000"},{"v":750000,"d":"¥750,000"},{"$f":"tblData[[#This Row],[金額]]-tblData[[#This Row],[費用]]","v":{"v":180000,"d":"¥180,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":2400000,"d":"¥2,400,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":4910000,"d":"¥4,910,000"}},{"$f":"SUMIFS(tblData[金額],tblData[日付],\">=\"&DATE(YEAR(tblData[[#This Row],[日付]]),1,1),tblData[日付],\"<=\"&DATE(YEAR(tblData[[#This Row],[日付]]),12,31))","v":{"v":14380000,"d":"¥14,380,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":2113805.0314465407,"d":"¥2,113,805"}},{"$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":4740000,"d":"¥4,740,000"}},{"$f":"IFERROR(TREND($N$6:INDEX($N:$N,ROW(),1),$J$6:INDEX($J:$J,ROW(),1),tblData[[#This Row],[年]]+1),\"\")","v":{"v":14380000,"d":"¥14,380,000"}}]
[null,{"$f":"40832+(365*2)","v":"2013-10-15"},"肥後株式会社",{"v":880000,"d":"¥880,000"},{"v":935000,"d":"¥935,000"},{"v":710000,"d":"¥710,000"},{"$f":"tblData[[#This Row],[金額]]-tblData[[#This Row],[費用]]","v":{"v":170000,"d":"¥170,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":880000,"d":"¥880,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":4390000,"d":"¥4,390,000"}},{"$f":"SUMIFS(tblData[金額],tblData[日付],\">=\"&DATE(YEAR(tblData[[#This Row],[日付]]),1,1),tblData[日付],\"<=\"&DATE(YEAR(tblData[[#This Row],[日付]]),12,31))","v":{"v":14380000,"d":"¥14,380,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":1795174.418604651,"d":"¥1,795,174"}},{"$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":4325813.953488372,"d":"¥4,325,814"}},{"$f":"IFERROR(TREND($N$6:INDEX($N:$N,ROW(),1),$J$6:INDEX($J:$J,ROW(),1),tblData[[#This Row],[年]]+1),\"\")","v":{"v":14380000,"d":"¥14,380,000"}}]
[null,{"$f":"40853+(365*2)","v":"2013-11-05"},"大宮ユニオン",{"v":910000,"d":"¥910,000"},{"v":920000,"d":"¥920,000"},{"v":785000,"d":"¥785,000"},{"$f":"tblData[[#This Row],[金額]]-tblData[[#This Row],[費用]]","v":{"v":125000,"d":"¥125,000"}},{"$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":2560000,"d":"¥2,560,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":4390000,"d":"¥4,390,000"}},{"$f":"SUMIFS(tblData[金額],tblData[日付],\">=\"&DATE(YEAR(tblData[[#This Row],[日付]]),1,1),tblData[日付],\"<=\"&DATE(YEAR(tblData[[#This Row],[日付]]),12,31))","v":{"v":14380000,"d":"¥14,380,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":2055613.0108423685,"d":"¥2,055,613"}},{"$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":4231290.322580645,"d":"¥4,231,290"}},{"$f":"IFERROR(TREND($N$6:INDEX($N:$N,ROW(),1),$J$6:INDEX($J:$J,ROW(),1),tblData[[#This Row],[年]]+1),\"\")","v":{"v":14380000,"d":"¥14,380,000"}}]
[null,{"$f":"40874+(365*2)","v":"2013-11-26"},"ヒロコーポレーション",{"v":900000,"d":"¥900,000"},{"v":1000000,"d":"¥1,000,000"},{"v":757500,"d":"¥757,500"},{"$f":"tblData[[#This Row],[金額]]-tblData[[#This Row],[費用]]","v":{"v":142500,"d":"¥142,500"}},{"$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":2560000,"d":"¥2,560,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":4390000,"d":"¥4,390,000"}},{"$f":"SUMIFS(tblData[金額],tblData[日付],\">=\"&DATE(YEAR(tblData[[#This Row],[日付]]),1,1),tblData[日付],\"<=\"&DATE(YEAR(tblData[[#This Row],[日付]]),12,31))","v":{"v":14380000,"d":"¥14,380,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":2199713.914174252,"d":"¥2,199,714"}},{"$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":4181111.1111111115,"d":"¥4,181,111"}},{"$f":"IFERROR(TREND($N$6:INDEX($N:$N,ROW(),1),$J$6:INDEX($J:$J,ROW(),1),tblData[[#This Row],[年]]+1),\"\")","v":{"v":14380000,"d":"¥14,380,000"}}]
[null,{"$f":"40878+(365*2)","v":"2013-11-30"},"ヒロコーポレーション",{"v":750000,"d":"¥750,000"},{"v":800000,"d":"¥800,000"},{"v":585000,"d":"¥585,000"},{"$f":"tblData[[#This Row],[金額]]-tblData[[#This Row],[費用]]","v":{"v":165000,"d":"¥165,000"}},{"$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":2560000,"d":"¥2,560,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":4390000,"d":"¥4,390,000"}},{"$f":"SUMIFS(tblData[金額],tblData[日付],\">=\"&DATE(YEAR(tblData[[#This Row],[日付]]),1,1),tblData[日付],\"<=\"&DATE(YEAR(tblData[[#This Row],[日付]]),12,31))","v":{"v":14380000,"d":"¥14,380,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":2291763.4523175284,"d":"¥2,291,763"}},{"$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":4150000,"d":"¥4,150,000"}},{"$f":"IFERROR(TREND($N$6:INDEX($N:$N,ROW(),1),$J$6:INDEX($J:$J,ROW(),1),tblData[[#This Row],[年]]+1),\"\")","v":{"v":14380000,"d":"¥14,380,000"}}]
[null,{"$f":"40889+(365*2)","v":"2013-12-11"},"蓬莱堂",{"v":950000,"d":"¥950,000"},{"v":920000,"d":"¥920,000"},{"v":850000,"d":"¥850,000"},{"$f":"tblData[[#This Row],[金額]]-tblData[[#This Row],[費用]]","v":{"v":100000,"d":"¥100,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":950000,"d":"¥950,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":4390000,"d":"¥4,390,000"}},{"$f":"SUMIFS(tblData[金額],tblData[日付],\">=\"&DATE(YEAR(tblData[[#This Row],[日付]]),1,1),tblData[日付],\"<=\"&DATE(YEAR(tblData[[#This Row],[日付]]),12,31))","v":{"v":14380000,"d":"¥14,380,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":2050431.4720812184,"d":"¥2,050,431"}},{"$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":4128823.529411765,"d":"¥4,128,824"}},{"$f":"IFERROR(TREND($N$6:INDEX($N:$N,ROW(),1),$J$6:INDEX($J:$J,ROW(),1),tblData[[#This Row],[年]]+1),\"\")","v":{"v":14380000,"d":"¥14,380,000"}}]

{"sheet":"売上レポート","index":1,"n_rows":28,"n_cols":6,"rows_kept":28}
[]
[null,"月次売上レポート"]
[]
[]
[null,"年","四半期","月","会社","総売上"]
[null,2013,{"v":2,"d":"四半期 2"},"2013-04-01","山門屋",{"v":640000,"d":"¥640,000"}]
[{"$nulls":4},"蓬莱堂",{"v":820000,"d":"¥820,000"}]
[{"$nulls":3},"2013-05-01","びしゃもんや",{"v":440000,"d":"¥440,000"}]
[{"$nulls":4},"ヒロコーポレーション",{"v":620000,"d":"¥620,000"}]
[{"$nulls":4},"大宮ユニオン",{"v":580000,"d":"¥580,000"}]
[{"$nulls":4},"肥後株式会社",{"v":540000,"d":"¥540,000"}]
[{"$nulls":3},"2013-06-01","山門屋",{"v":690000,"d":"¥690,000"}]
[{"$nulls":4},"蓬莱堂",{"v":750000,"d":"¥750,000"}]
[null,null,"Quarter 2 集計",null,null,{"v":5080000,"d":"¥5,080,000"}]
[null,null,{"v":3,"d":"四半期 3"},"2013-07-01","びしゃもんや",{"v":870000,"d":"¥870,000"}]
[{"$nulls":3},"2013-08-01","大宮ユニオン",{"v":790000,"d":"¥790,000"}]
[{"$nulls":4},"肥後株式会社",{"v":850000,"d":"¥850,000"}]
[{"$nulls":3},"2013-09-01","びしゃもんや",{"v":930000,"d":"¥930,000"}]
[{"$nulls":4},"ヒロコーポレーション",{"v":910000,"d":"¥910,000"}]
[{"$nulls":4},"蓬莱堂",{"v":560000,"d":"¥560,000"}]
[null,null,"Quarter 3 集計",null,null,{"v":4910000,"d":"¥4,910,000"}]
[null,null,{"v":4,"d":"四半期 4"},"2013-10-01","肥後株式会社",{"v":880000,"d":"¥880,000"}]
[{"$nulls":3},"2013-11-01","ヒロコーポレーション",{"v":1650000,"d":"¥1,650,000"}]
[{"$nulls":4},"大宮ユニオン",{"v":910000,"d":"¥910,000"}]
[{"$nulls":3},"2013-12-01","蓬莱堂",{"v":950000,"d":"¥950,000"}]
[null,null,"Quarter 4 集計",null,null,{"v":4390000,"d":"¥4,390,000"}]
[null,"2013 集計",{"$nulls":3},{"v":14380000,"d":"¥14,380,000"}]
[null,"総計",{"$nulls":3},{"v":14380000,"d":"¥14,380,000"}]

{"sheet":"販売予測","index":2,"n_rows":43,"n_cols":11,"rows_kept":43}
[{"$nulls":10},{"$f":"\"TODAY'S DATE: \"&UPPER(TEXT(TODAY(),\"mmm d, yyyy\"))","v":"TODAY'S DATE: SEP 27, 2012"}]
[null,"月次販売予測"]
[null,{"$f":"\"今日の日付: \"&UPPER(TEXT(TODAY(),\"yyyy 年 m 月 d 日\"))","v":"今日の日付: 2012 年 9 月 27 日"},null,{"$f":"--TRIM(RIGHT(K1,LEN(K1)-FIND(\":\",K1)))","v":"2012-09-27"}]
[]
[null,"今月","実際","計画","差異","%","(年度) 累計の実績","(年度) 累計の計画","(年度) 累計の差異","(年度) 累計の比率"]
[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"}},{"$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"}},{"$f":"D7-C7","v":{"v":0,"d":"¥0"}},{"$f":"IFERROR(D7/C7,\"-\")","v":"-"},{"$f":"SUMIF(tblData[日付],\"<=\"&EOMONTH(fDate,0),tblData[金額])","v":{"v":0,"d":"¥0"}},{"$f":"SUMIF(tblData[日付],\"<=\"&EOMONTH(fDate,0),tblData[計画])","v":{"v":0,"d":"¥0"}},{"$f":"H7-G7","v":{"v":0,"d":"¥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":{"v":0,"d":"¥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":{"v":0,"d":"¥0"}},{"$f":"D8-C8","v":{"v":0,"d":"¥0"}},{"$f":"IFERROR(D8/C8,\"-\")","v":"-"},{"$f":"SUMIF(データ入力!$B$6:$B$24,\"<=\"&EOMONTH(fDate,0),データ入力!$F$6:$F$24)","v":{"v":0,"d":"¥0"}},{"$f":"SUMIF(tblData[日付],\"<=\"&EOMONTH(fDate,0),tblData[費用])","v":{"v":0,"d":"¥0"}},{"$f":"H8-G8","v":{"v":0,"d":"¥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":19}]
[null,"平均注文額",{"$f":"IFERROR(C7/C10,\"-\")","v":"-"},{"$nulls":3},{"$f":"IFERROR(G7/G10,\"-\")","v":{"v":0,"d":"¥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":1945190.3553299494,"d":"¥1,945,190"}},null,{"$f":"TREND(tblData[[四半期 ]],tblData[MONTH NUM (HIDE)],IF(MONTH(fDate)=12,13,MONTH(fDate)+1))","v":{"v":4609898.477157361,"d":"¥4,609,898"}},null,null,{"$f":"TREND(tblData[[年間 ]],tblData[MONTH NUM (HIDE)],IF(MONTH(fDate)=12,13,MONTH(fDate)+1))","v":{"v":14380000,"d":"¥14,380,000"}}]
[]
[null,"販売履歴"]
{"$rows_empty":13}
[null,"月間予測",{"$nulls":3},"四半期予測"]
{"$rows_empty":7}
[null,"年間予測",{"$nulls":3},"収益の推移"]
[]
[]
[]
[]
[{"$nulls":9}," "]