{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["기본","기출"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"기본","index":0,"n_rows":9,"n_cols":2,"rows_kept":9,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
["날짜에서 월만 추출하기"]
[]
["날짜","월"]
["2020-09-17",{"$f":"MONTH(A4)","v":9}]
["2020-09-17",{"$f":"MONTH(A5)","v":9}]
[44091,{"$f":"MONTH(A6)","v":9}]
["2020-09-17",{"$f":"MONTH(A7)","v":9}]
["2020-09-17",9]
["2020-09-31",{"$error":"#VALUE!"}]

{"sheet":"기출","index":1,"n_rows":17,"n_cols":7,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,1,0,4]]}
[null,"10세 대상의  게임명별 월별매출액의 합계"]
[null,"게임명",4,5,6]
[null,"카드게임",{"$f":"SUM(($C$7:$C$17=$B3)*(MONTH($E$7:$E$17)=C$2)*($D$7:$D$17=\"10세\")*$G$7:$G$17)","v":{"$error":"#VALUE!"}},{"$f":"SUM(($C$7:$C$17=$B3)*(MONTH($E$7:$E$17)=D$2)*($D$7:$D$17=\"10세\")*$G$7:$G$17)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
[null,"크래지"]
[]
[null,"게임코드","게임명","대상","판매일자","수량","매출액"]
[null,"A-01","카드게임","18세","2020-04-09",124,45112]
[null,"G-02","크래지","10세","2020-04-05",142,187000]
[null,"G-02","카드게임","10세","2020-05-08",235,153000]
[null,"G-03","크래지","18세","2020-05-05",88,208500]
[null,"A-01","카드게임","18세","2020-06-01",269,90224]
[null,"G-07","크래지","10세","2020-06-07",131,211200]
[null,"A-07","카드게임","18세","2020-04-09",15,288000]
[null,"A-07","크래지","18세","2020-04-12",122,38400]
[null,"G-04","크래지","10세","2020-05-02",268,52500]
[null,"G-06","카드게임","10세","2020-05-09",141,178500]
[null,"G-04","크래지","10세","2020-06-11",227,70000]