{"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":6400000,"d":"₩6,400,000"},{"v":6200000,"d":"₩6,200,000"},{"v":4450000,"d":"₩4,450,000"},{"$f":"tblData[[#This Row],[금액]]-tblData[[#This Row],[비용]]","v":{"v":1950000,"d":"₩1,950,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":14600000,"d":"₩14,600,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":50800000,"d":"₩50,800,000"}},{"$f":"SUMIFS(tblData[금액],tblData[날짜],\">=\"&DATE(YEAR(tblData[[#This Row],[날짜]]),1,1),tblData[날짜],\"<=\"&DATE(YEAR(tblData[[#This Row],[날짜]]),12,31))","v":{"v":143800000,"d":"₩143,800,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":14600000,"d":"₩14,600,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":50800000,"d":"₩50,800,000"}},{"$f":"IFERROR(TREND($N$6:INDEX($N:$N,ROW(),1),$J$6:INDEX($J:$J,ROW(),1),tblData[[#This Row],[년]]+1),\"\")","v":{"v":143800000,"d":"₩143,800,000"}}]
[null,{"$f":"40659+(365*2)","v":"2013-04-25"},"한미 교역 (주)",{"v":8200000,"d":"₩8,200,000"},{"v":8000000,"d":"₩8,000,000"},{"v":6400000,"d":"₩6,400,000"},{"$f":"tblData[[#This Row],[금액]]-tblData[[#This Row],[비용]]","v":{"v":1800000,"d":"₩1,800,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":14600000,"d":"₩14,600,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":50800000,"d":"₩50,800,000"}},{"$f":"SUMIFS(tblData[금액],tblData[날짜],\">=\"&DATE(YEAR(tblData[[#This Row],[날짜]]),1,1),tblData[날짜],\"<=\"&DATE(YEAR(tblData[[#This Row],[날짜]]),12,31))","v":{"v":143800000,"d":"₩143,800,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":14600000,"d":"₩14,600,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":50800000,"d":"₩50,800,000"}},{"$f":"IFERROR(TREND($N$6:INDEX($N:$N,ROW(),1),$J$6:INDEX($J:$J,ROW(),1),tblData[[#This Row],[년]]+1),\"\")","v":{"v":143800000,"d":"₩143,800,000"}}]
[null,{"$f":"40671+(365*2)","v":"2013-05-07"},"대진 상사 (주)",{"v":4400000,"d":"₩4,400,000"},{"v":4200000,"d":"₩4,200,000"},{"v":2600000,"d":"₩2,600,000"},{"$f":"tblData[[#This Row],[금액]]-tblData[[#This Row],[비용]]","v":{"v":1800000,"d":"₩1,800,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":21800000,"d":"₩21,800,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":50800000,"d":"₩50,800,000"}},{"$f":"SUMIFS(tblData[금액],tblData[날짜],\">=\"&DATE(YEAR(tblData[[#This Row],[날짜]]),1,1),tblData[날짜],\"<=\"&DATE(YEAR(tblData[[#This Row],[날짜]]),12,31))","v":{"v":143800000,"d":"₩143,800,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":29000000,"d":"₩29,000,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":50800000,"d":"₩50,800,000"}},{"$f":"IFERROR(TREND($N$6:INDEX($N:$N,ROW(),1),$J$6:INDEX($J:$J,ROW(),1),tblData[[#This Row],[년]]+1),\"\")","v":{"v":143800000,"d":"₩143,800,000"}}]
[null,{"$f":"40678+(365*2)","v":"2013-05-14"},"베네디스 유통 ㈜",{"v":5400000,"d":"₩5,400,000"},{"v":5500000,"d":"₩5,500,000"},{"v":4500000,"d":"₩4,500,000"},{"$f":"tblData[[#This Row],[금액]]-tblData[[#This Row],[비용]]","v":{"v":900000,"d":"₩900,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":21800000,"d":"₩21,800,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":50800000,"d":"₩50,800,000"}},{"$f":"SUMIFS(tblData[금액],tblData[날짜],\">=\"&DATE(YEAR(tblData[[#This Row],[날짜]]),1,1),tblData[날짜],\"<=\"&DATE(YEAR(tblData[[#This Row],[날짜]]),12,31))","v":{"v":143800000,"d":"₩143,800,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":29000000,"d":"₩29,000,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":50800000,"d":"₩50,800,000"}},{"$f":"IFERROR(TREND($N$6:INDEX($N:$N,ROW(),1),$J$6:INDEX($J:$J,ROW(),1),tblData[[#This Row],[년]]+1),\"\")","v":{"v":143800000,"d":"₩143,800,000"}}]
[null,{"$f":"40678+(365*2)","v":"2013-05-14"},"정금 상사 (주)",{"v":5800000,"d":"₩5,800,000"},{"v":6000000,"d":"₩6,000,000"},{"v":4500000,"d":"₩4,500,000"},{"$f":"tblData[[#This Row],[금액]]-tblData[[#This Row],[비용]]","v":{"v":1300000,"d":"₩1,300,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":21800000,"d":"₩21,800,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":50800000,"d":"₩50,800,000"}},{"$f":"SUMIFS(tblData[금액],tblData[날짜],\">=\"&DATE(YEAR(tblData[[#This Row],[날짜]]),1,1),tblData[날짜],\"<=\"&DATE(YEAR(tblData[[#This Row],[날짜]]),12,31))","v":{"v":143800000,"d":"₩143,800,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":29000000,"d":"₩29,000,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":50800000,"d":"₩50,800,000"}},{"$f":"IFERROR(TREND($N$6:INDEX($N:$N,ROW(),1),$J$6:INDEX($J:$J,ROW(),1),tblData[[#This Row],[년]]+1),\"\")","v":{"v":143800000,"d":"₩143,800,000"}}]
[null,{"$f":"40693+(365*2)","v":"2013-05-29"},"미림 백화점 ㈜",{"v":6200000,"d":"₩6,200,000"},{"v":6000000,"d":"₩6,000,000"},{"v":4500000,"d":"₩4,500,000"},{"$f":"tblData[[#This Row],[금액]]-tblData[[#This Row],[비용]]","v":{"v":1700000,"d":"₩1,700,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":21800000,"d":"₩21,800,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":50800000,"d":"₩50,800,000"}},{"$f":"SUMIFS(tblData[금액],tblData[날짜],\">=\"&DATE(YEAR(tblData[[#This Row],[날짜]]),1,1),tblData[날짜],\"<=\"&DATE(YEAR(tblData[[#This Row],[날짜]]),12,31))","v":{"v":143800000,"d":"₩143,800,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":29000000.000000007,"d":"₩29,000,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":50800000,"d":"₩50,800,000"}},{"$f":"IFERROR(TREND($N$6:INDEX($N:$N,ROW(),1),$J$6:INDEX($J:$J,ROW(),1),tblData[[#This Row],[년]]+1),\"\")","v":{"v":143800000,"d":"₩143,800,000"}}]
[null,{"$f":"40705+(365*2)","v":"2013-06-10"},"동광 통상 ㈜",{"v":6900000,"d":"₩6,900,000"},{"v":7500000,"d":"₩7,500,000"},{"v":5400000,"d":"₩5,400,000"},{"$f":"tblData[[#This Row],[금액]]-tblData[[#This Row],[비용]]","v":{"v":1500000,"d":"₩1,500,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":14400000,"d":"₩14,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":50800000,"d":"₩50,800,000"}},{"$f":"SUMIFS(tblData[금액],tblData[날짜],\">=\"&DATE(YEAR(tblData[[#This Row],[날짜]]),1,1),tblData[날짜],\"<=\"&DATE(YEAR(tblData[[#This Row],[날짜]]),12,31))","v":{"v":143800000,"d":"₩143,800,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":21600000,"d":"₩21,600,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":50800000,"d":"₩50,800,000"}},{"$f":"IFERROR(TREND($N$6:INDEX($N:$N,ROW(),1),$J$6:INDEX($J:$J,ROW(),1),tblData[[#This Row],[년]]+1),\"\")","v":{"v":143800000,"d":"₩143,800,000"}}]
[null,{"$f":"40716+(365*2)","v":"2013-06-21"},"한미 교역 (주)",{"v":7500000,"d":"₩7,500,000"},{"v":7200000,"d":"₩7,200,000"},{"v":6500000,"d":"₩6,500,000"},{"$f":"tblData[[#This Row],[금액]]-tblData[[#This Row],[비용]]","v":{"v":1000000,"d":"₩1,000,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":14400000,"d":"₩14,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":50800000,"d":"₩50,800,000"}},{"$f":"SUMIFS(tblData[금액],tblData[날짜],\">=\"&DATE(YEAR(tblData[[#This Row],[날짜]]),1,1),tblData[날짜],\"<=\"&DATE(YEAR(tblData[[#This Row],[날짜]]),12,31))","v":{"v":143800000,"d":"₩143,800,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":17950000,"d":"₩17,950,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":50800000,"d":"₩50,800,000"}},{"$f":"IFERROR(TREND($N$6:INDEX($N:$N,ROW(),1),$J$6:INDEX($J:$J,ROW(),1),tblData[[#This Row],[년]]+1),\"\")","v":{"v":143800000,"d":"₩143,800,000"}}]
[null,{"$f":"40731+(365*2)","v":"2013-07-06"},"대진 상사 (주)",{"v":8700000,"d":"₩8,700,000"},{"v":8500000,"d":"₩8,500,000"},{"v":7250000,"d":"₩7,250,000"},{"$f":"tblData[[#This Row],[금액]]-tblData[[#This Row],[비용]]","v":{"v":1450000,"d":"₩1,450,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":8700000,"d":"₩8,700,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":49100000,"d":"₩49,100,000"}},{"$f":"SUMIFS(tblData[금액],tblData[날짜],\">=\"&DATE(YEAR(tblData[[#This Row],[날짜]]),1,1),tblData[날짜],\"<=\"&DATE(YEAR(tblData[[#This Row],[날짜]]),12,31))","v":{"v":143800000,"d":"₩143,800,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":10776470.588235293,"d":"₩10,776,471"}},{"$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":47400000,"d":"₩47,400,000"}},{"$f":"IFERROR(TREND($N$6:INDEX($N:$N,ROW(),1),$J$6:INDEX($J:$J,ROW(),1),tblData[[#This Row],[년]]+1),\"\")","v":{"v":143800000,"d":"₩143,800,000"}}]
[null,{"$f":"40761+(365*2)","v":"2013-08-05"},"베네디스 유통 ㈜",{"v":8500000,"d":"₩8,500,000"},{"v":8300000,"d":"₩8,300,000"},{"v":7100000,"d":"₩7,100,000"},{"$f":"tblData[[#This Row],[금액]]-tblData[[#This Row],[비용]]","v":{"v":1400000,"d":"₩1,400,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":16400000,"d":"₩16,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":49100000,"d":"₩49,100,000"}},{"$f":"SUMIFS(tblData[금액],tblData[날짜],\">=\"&DATE(YEAR(tblData[[#This Row],[날짜]]),1,1),tblData[날짜],\"<=\"&DATE(YEAR(tblData[[#This Row],[날짜]]),12,31))","v":{"v":143800000,"d":"₩143,800,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":12455862.068965519,"d":"₩12,455,862"}},{"$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":47400000,"d":"₩47,400,000"}},{"$f":"IFERROR(TREND($N$6:INDEX($N:$N,ROW(),1),$J$6:INDEX($J:$J,ROW(),1),tblData[[#This Row],[년]]+1),\"\")","v":{"v":143800000,"d":"₩143,800,000"}}]
[null,{"$f":"40775+(365*2)","v":"2013-08-19"},"정금 상사 (주)",{"v":7900000,"d":"₩7,900,000"},{"v":7700000,"d":"₩7,700,000"},{"v":6600000,"d":"₩6,600,000"},{"$f":"tblData[[#This Row],[금액]]-tblData[[#This Row],[비용]]","v":{"v":1300000,"d":"₩1,300,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":16400000,"d":"₩16,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":49100000,"d":"₩49,100,000"}},{"$f":"SUMIFS(tblData[금액],tblData[날짜],\">=\"&DATE(YEAR(tblData[[#This Row],[날짜]]),1,1),tblData[날짜],\"<=\"&DATE(YEAR(tblData[[#This Row],[날짜]]),12,31))","v":{"v":143800000,"d":"₩143,800,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":13667567.567567568,"d":"₩13,667,568"}},{"$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":47400000,"d":"₩47,400,000"}},{"$f":"IFERROR(TREND($N$6:INDEX($N:$N,ROW(),1),$J$6:INDEX($J:$J,ROW(),1),tblData[[#This Row],[년]]+1),\"\")","v":{"v":143800000,"d":"₩143,800,000"}}]
[null,{"$f":"40791+(365*2)","v":"2013-09-04"},"미림 백화점 ㈜",{"v":9100000,"d":"₩9,100,000"},{"v":8900000,"d":"₩8,900,000"},{"v":7900000,"d":"₩7,900,000"},{"$f":"tblData[[#This Row],[금액]]-tblData[[#This Row],[비용]]","v":{"v":1200000,"d":"₩1,200,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":24000000,"d":"₩24,000,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":49100000,"d":"₩49,100,000"}},{"$f":"SUMIFS(tblData[금액],tblData[날짜],\">=\"&DATE(YEAR(tblData[[#This Row],[날짜]]),1,1),tblData[날짜],\"<=\"&DATE(YEAR(tblData[[#This Row],[날짜]]),12,31))","v":{"v":143800000,"d":"₩143,800,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":17651666.666666664,"d":"₩17,651,667"}},{"$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":47400000,"d":"₩47,400,000"}},{"$f":"IFERROR(TREND($N$6:INDEX($N:$N,ROW(),1),$J$6:INDEX($J:$J,ROW(),1),tblData[[#This Row],[년]]+1),\"\")","v":{"v":143800000,"d":"₩143,800,000"}}]
[null,{"$f":"40807+(365*2)","v":"2013-09-20"},"한미 교역 (주)",{"v":5600000,"d":"₩5,600,000"},{"v":5800000,"d":"₩5,800,000"},{"v":4500000,"d":"₩4,500,000"},{"$f":"tblData[[#This Row],[금액]]-tblData[[#This Row],[비용]]","v":{"v":1100000,"d":"₩1,100,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":24000000,"d":"₩24,000,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":49100000,"d":"₩49,100,000"}},{"$f":"SUMIFS(tblData[금액],tblData[날짜],\">=\"&DATE(YEAR(tblData[[#This Row],[날짜]]),1,1),tblData[날짜],\"<=\"&DATE(YEAR(tblData[[#This Row],[날짜]]),12,31))","v":{"v":143800000,"d":"₩143,800,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":19877911.646586344,"d":"₩19,877,912"}},{"$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":47400000,"d":"₩47,400,000"}},{"$f":"IFERROR(TREND($N$6:INDEX($N:$N,ROW(),1),$J$6:INDEX($J:$J,ROW(),1),tblData[[#This Row],[년]]+1),\"\")","v":{"v":143800000,"d":"₩143,800,000"}}]
[null,{"$f":"40812+(365*2)","v":"2013-09-25"},"대진 상사 (주)",{"v":9300000,"d":"₩9,300,000"},{"v":9100000,"d":"₩9,100,000"},{"v":7500000,"d":"₩7,500,000"},{"$f":"tblData[[#This Row],[금액]]-tblData[[#This Row],[비용]]","v":{"v":1800000,"d":"₩1,800,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":24000000,"d":"₩24,000,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":49100000,"d":"₩49,100,000"}},{"$f":"SUMIFS(tblData[금액],tblData[날짜],\">=\"&DATE(YEAR(tblData[[#This Row],[날짜]]),1,1),tblData[날짜],\"<=\"&DATE(YEAR(tblData[[#This Row],[날짜]]),12,31))","v":{"v":143800000,"d":"₩143,800,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":21138050.31446541,"d":"₩21,138,050"}},{"$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":47400000.00000001,"d":"₩47,400,000"}},{"$f":"IFERROR(TREND($N$6:INDEX($N:$N,ROW(),1),$J$6:INDEX($J:$J,ROW(),1),tblData[[#This Row],[년]]+1),\"\")","v":{"v":143800000,"d":"₩143,800,000"}}]
[null,{"$f":"40832+(365*2)","v":"2013-10-15"},"베네디스 유통 ㈜",{"v":8800000,"d":"₩8,800,000"},{"v":9350000,"d":"₩9,350,000"},{"v":7100000,"d":"₩7,100,000"},{"$f":"tblData[[#This Row],[금액]]-tblData[[#This Row],[비용]]","v":{"v":1700000,"d":"₩1,700,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":8800000,"d":"₩8,800,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":43900000,"d":"₩43,900,000"}},{"$f":"SUMIFS(tblData[금액],tblData[날짜],\">=\"&DATE(YEAR(tblData[[#This Row],[날짜]]),1,1),tblData[날짜],\"<=\"&DATE(YEAR(tblData[[#This Row],[날짜]]),12,31))","v":{"v":143800000,"d":"₩143,800,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":17951744.18604651,"d":"₩17,951,744"}},{"$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":43258139.53488372,"d":"₩43,258,140"}},{"$f":"IFERROR(TREND($N$6:INDEX($N:$N,ROW(),1),$J$6:INDEX($J:$J,ROW(),1),tblData[[#This Row],[년]]+1),\"\")","v":{"v":143800000,"d":"₩143,800,000"}}]
[null,{"$f":"40853+(365*2)","v":"2013-11-05"},"정금 상사 (주)",{"v":9100000,"d":"₩9,100,000"},{"v":9200000,"d":"₩9,200,000"},{"v":7850000,"d":"₩7,850,000"},{"$f":"tblData[[#This Row],[금액]]-tblData[[#This Row],[비용]]","v":{"v":1250000,"d":"₩1,250,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":25600000,"d":"₩25,600,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":43900000,"d":"₩43,900,000"}},{"$f":"SUMIFS(tblData[금액],tblData[날짜],\">=\"&DATE(YEAR(tblData[[#This Row],[날짜]]),1,1),tblData[날짜],\"<=\"&DATE(YEAR(tblData[[#This Row],[날짜]]),12,31))","v":{"v":143800000,"d":"₩143,800,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":20556130.108423688,"d":"₩20,556,130"}},{"$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":42312903.22580645,"d":"₩42,312,903"}},{"$f":"IFERROR(TREND($N$6:INDEX($N:$N,ROW(),1),$J$6:INDEX($J:$J,ROW(),1),tblData[[#This Row],[년]]+1),\"\")","v":{"v":143800000,"d":"₩143,800,000"}}]
[null,{"$f":"40874+(365*2)","v":"2013-11-26"},"미림 백화점 ㈜",{"v":9000000,"d":"₩9,000,000"},{"v":10000000,"d":"₩10,000,000"},{"v":7575000,"d":"₩7,575,000"},{"$f":"tblData[[#This Row],[금액]]-tblData[[#This Row],[비용]]","v":{"v":1425000,"d":"₩1,425,000"}},{"$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":25600000,"d":"₩25,600,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":43900000,"d":"₩43,900,000"}},{"$f":"SUMIFS(tblData[금액],tblData[날짜],\">=\"&DATE(YEAR(tblData[[#This Row],[날짜]]),1,1),tblData[날짜],\"<=\"&DATE(YEAR(tblData[[#This Row],[날짜]]),12,31))","v":{"v":143800000,"d":"₩143,800,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":21997139.141742524,"d":"₩21,997,139"}},{"$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":41811111.11111112,"d":"₩41,811,111"}},{"$f":"IFERROR(TREND($N$6:INDEX($N:$N,ROW(),1),$J$6:INDEX($J:$J,ROW(),1),tblData[[#This Row],[년]]+1),\"\")","v":{"v":143800000,"d":"₩143,800,000"}}]
[null,{"$f":"40878+(365*2)","v":"2013-11-30"},"미림 백화점 ㈜",{"v":7500000,"d":"₩7,500,000"},{"v":8000000,"d":"₩8,000,000"},{"v":5850000,"d":"₩5,850,000"},{"$f":"tblData[[#This Row],[금액]]-tblData[[#This Row],[비용]]","v":{"v":1650000,"d":"₩1,650,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":25600000,"d":"₩25,600,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":43900000,"d":"₩43,900,000"}},{"$f":"SUMIFS(tblData[금액],tblData[날짜],\">=\"&DATE(YEAR(tblData[[#This Row],[날짜]]),1,1),tblData[날짜],\"<=\"&DATE(YEAR(tblData[[#This Row],[날짜]]),12,31))","v":{"v":143800000,"d":"₩143,800,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":22917634.523175277,"d":"₩22,917,635"}},{"$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":41500000,"d":"₩41,500,000"}},{"$f":"IFERROR(TREND($N$6:INDEX($N:$N,ROW(),1),$J$6:INDEX($J:$J,ROW(),1),tblData[[#This Row],[년]]+1),\"\")","v":{"v":143800000,"d":"₩143,800,000"}}]
[null,{"$f":"40889+(365*2)","v":"2013-12-11"},"한미 교역 (주)",{"v":9500000,"d":"₩9,500,000"},{"v":9200000,"d":"₩9,200,000"},{"v":8500000,"d":"₩8,500,000"},{"$f":"tblData[[#This Row],[금액]]-tblData[[#This Row],[비용]]","v":{"v":1000000,"d":"₩1,000,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":9500000,"d":"₩9,500,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":43900000,"d":"₩43,900,000"}},{"$f":"SUMIFS(tblData[금액],tblData[날짜],\">=\"&DATE(YEAR(tblData[[#This Row],[날짜]]),1,1),tblData[날짜],\"<=\"&DATE(YEAR(tblData[[#This Row],[날짜]]),12,31))","v":{"v":143800000,"d":"₩143,800,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":20504314.720812183,"d":"₩20,504,315"}},{"$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":41288235.294117644,"d":"₩41,288,235"}},{"$f":"IFERROR(TREND($N$6:INDEX($N:$N,ROW(),1),$J$6:INDEX($J:$J,ROW(),1),tblData[[#This Row],[년]]+1),\"\")","v":{"v":143800000,"d":"₩143,800,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":6400000,"d":"₩6,400,000"}]
[{"$nulls":4},"한미 교역 (주)",{"v":8200000,"d":"₩8,200,000"}]
[{"$nulls":3},"2013-05-01","대진 상사 (주)",{"v":4400000,"d":"₩4,400,000"}]
[{"$nulls":4},"미림 백화점 ㈜",{"v":6200000,"d":"₩6,200,000"}]
[{"$nulls":4},"베네디스 유통 ㈜",{"v":5400000,"d":"₩5,400,000"}]
[{"$nulls":4},"정금 상사 (주)",{"v":5800000,"d":"₩5,800,000"}]
[{"$nulls":3},"2013-06-01","동광 통상 ㈜",{"v":6900000,"d":"₩6,900,000"}]
[{"$nulls":4},"한미 교역 (주)",{"v":7500000,"d":"₩7,500,000"}]
[null,null,"2분기  요약",null,null,{"v":50800000,"d":"₩50,800,000"}]
[null,null,{"v":3,"d":"3분기 "},"2013-07-01","대진 상사 (주)",{"v":8700000,"d":"₩8,700,000"}]
[{"$nulls":3},"2013-08-01","베네디스 유통 ㈜",{"v":8500000,"d":"₩8,500,000"}]
[{"$nulls":4},"정금 상사 (주)",{"v":7900000,"d":"₩7,900,000"}]
[{"$nulls":3},"2013-09-01","대진 상사 (주)",{"v":9300000,"d":"₩9,300,000"}]
[{"$nulls":4},"미림 백화점 ㈜",{"v":9100000,"d":"₩9,100,000"}]
[{"$nulls":4},"한미 교역 (주)",{"v":5600000,"d":"₩5,600,000"}]
[null,null,"3분기  요약",null,null,{"v":49100000,"d":"₩49,100,000"}]
[null,null,{"v":4,"d":"4분기 "},"2013-10-01","베네디스 유통 ㈜",{"v":8800000,"d":"₩8,800,000"}]
[{"$nulls":3},"2013-11-01","미림 백화점 ㈜",{"v":16500000,"d":"₩16,500,000"}]
[{"$nulls":4},"정금 상사 (주)",{"v":9100000,"d":"₩9,100,000"}]
[{"$nulls":3},"2013-12-01","한미 교역 (주)",{"v":9500000,"d":"₩9,500,000"}]
[null,null,"4분기  요약",null,null,{"v":43900000,"d":"₩43,900,000"}]
[null,"2013 요약",{"$nulls":3},{"v":143800000,"d":"₩143,800,000"}]
[null,"총합계",{"$nulls":3},{"v":143800000,"d":"₩143,800,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 21, 2012"}]
[null,"월 판매 예측"]
[null,{"$f":"\"오늘 날짜: \"&UPPER(TEXT(TODAY(),\"yyyy년 M월 d일\"))","v":"오늘 날짜: 2012년 9월 21일"},null,{"$f":"--TRIM(RIGHT(K1,LEN(K1)-FIND(\":\",K1)))","v":"2012-09-21"}]
[]
[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":19451903.553299494,"d":"₩19,451,904"}},null,{"$f":"TREND(tblData[[분기 ]],tblData[MONTH NUM (HIDE)],IF(MONTH(fDate)=12,13,MONTH(fDate)+1))","v":{"v":46098984.77157361,"d":"₩46,098,985"}},null,null,{"$f":"TREND(tblData[[년 ]],tblData[MONTH NUM (HIDE)],IF(MONTH(fDate)=12,13,MONTH(fDate)+1))","v":{"v":143800000,"d":"₩143,800,000"}}]
[]
[null,"판매 기록"]
{"$rows_empty":13}
[null,"월간 예측",{"$nulls":3},"분기 예측"]
{"$rows_empty":7}
[null,"연간 예측",{"$nulls":3},"수입 흐름"]
[]
[]
[]
[]
[{"$nulls":9}," "]