{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["기본작업-1","기본작업-2","계산작업","분석작업-1","분석작업-2","기타작업-1","기타작업-2","기타작업-3"],"not_rendered":{"charts":2,"images":3,"macros":1,"external_links":0,"defined_names":3,"comments":0,"pivot_tables":1},"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":"기본작업-1","index":0,"n_rows":38,"n_cols":6,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
["[표1]"]
["예매일자","구분","공연이름","가격","예매수량","총금액"]
["2022-06-09","무용","백설공주",15000,3,{"$f":"D3*E3","v":45000}]
["2022-04-08","가족극","헨리의모험",23000,32,736000]
["2022-05-11","뮤지컬","천사의노래",31000,2,62000]
["2022-07-21","가족극","행복한우리집",16000,30,480000]
["2022-06-09","콘서트","7080콘서트",35000,3,105000]
["2022-06-29","콘서트","7080콘서트",35000,3,105000]
["2022-04-05","뮤지컬","피노키오",19900,19,378100]
["2022-05-08","콘서트","아이돌대축제",43000,29,1247000]
["2022-02-05","가족극","요술친구",21000,15,315000]
["2022-04-07","가족극","헨리의모험",23000,6,138000]
["2022-01-25","가족극","행복한우리집",16000,5,80000]
["2022-03-30","뮤지컬","피노키오",19900,21,417900]
["2022-06-02","콘서트","아이돌대축제",43000,26,1118000]
["2022-04-27","가족극","행복한우리집",16000,2,32000]
["2022-05-20","콘서트","7080콘서트",35000,11,385000]
["2022-05-07","뮤지컬","천사의노래",31000,21,651000]
["2022-03-24","무용","백설공주",15000,5,75000]
["2022-06-08","뮤지컬","피노키오",19900,9,179100]
["2022-07-29","무용","백설공주",15000,19,285000]
["2022-06-05","콘서트","7080콘서트",35000,10,350000]
["2022-05-03","가족극","요술친구",21000,2,42000]
["2022-02-27","뮤지컬","천사의노래",31000,27,837000]
["2022-08-29","뮤지컬","피노키오",19900,5,99500]
["2022-04-02","뮤지컬","천사의노래",31000,6,186000]
["2022-07-25","콘서트","아이돌대축제",43000,4,172000]
["2022-06-02","가족극","헨리의모험",23000,2,46000]
[]
["조건"]
[{"$f":"AND(DAY($A3)>=20,$E3>=AVERAGE($E$3:$E$28))","v":false}]
[]
[]
["예매일자","구분","공연이름","가격","예매수량","총금액"]
["2022-07-21","가족극","행복한우리집",16000,30,480000]
["2022-03-30","뮤지컬","피노키오",19900,21,417900]
["2022-07-29","무용","백설공주",15000,19,285000]
["2022-02-27","뮤지컬","천사의노래",31000,27,837000]

{"sheet":"기본작업-2","index":1,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[null,"[표1]"]
[null,"공연이름","가격","예매수량 합계","총금액"]
[null,"아이돌대축제",43000,59,{"$f":"C4*D4","v":2537000}]
[null,"천사의노래",31000,56,1736000]
[null,"피노키오",19900,54,1074600]
[null,"헨리의모험",23000,40,920000]
[null,"행복한우리집",16000,37,592000]
[null,"7080콘서트",35000,27,945000]
[null,"백설공주",15000,27,405000]
[null,"요술친구",21000,17,357000]

{"sheet":"계산작업","index":2,"n_rows":40,"n_cols":8,"rows_kept":40,"cut":false,"hidden":false,"merged":[[6,3,6,5],[7,3,7,5]]}
["[표1] 공연별 매출액",null,null,"[표2] 2/4분기 월별 최대 예매수량"]
["공연이름","총금액 평균",null,"예매월","최대 예매수량"]
["7080콘서트",{"$f":"AVERAGEIFS($F$15:$F$40,$A$15:$A$40,$A3,$E$15:$E$40,\">=5\")","v":367500},null,4,{"$f":"MAXA((MONTH($C$15:$C$40)=$D3)*$E$15:$E$40)","v":32}]
["피노키오",{"$f":"AVERAGEIFS($F$15:$F$40,$A$15:$A$40,$A4,$E$15:$E$40,\">=5\")","v":268650},null,5,{"$f":"MAXA((MONTH($C$15:$C$40)=$D4)*$E$15:$E$40)","v":29}]
["아이돌대축제",{"$f":"AVERAGEIFS($F$15:$F$40,$A$15:$A$40,$A5,$E$15:$E$40,\">=5\")","v":1182500},null,6,{"$f":"MAXA((MONTH($C$15:$C$40)=$D5)*$E$15:$E$40)","v":26}]
["요술친구",{"$f":"AVERAGEIFS($F$15:$F$40,$A$15:$A$40,$A6,$E$15:$E$40,\">=5\")","v":315000}]
["백설공주",{"$f":"AVERAGEIFS($F$15:$F$40,$A$15:$A$40,$A7,$E$15:$E$40,\">=5\")","v":180000},null,"[표3] 가격이 30,000 이상, 예매수량이 20 이상인 예매 건수"]
["헨리의모험",{"$f":"AVERAGEIFS($F$15:$F$40,$A$15:$A$40,$A8,$E$15:$E$40,\">=5\")","v":437000}]
["천사의노래",{"$f":"AVERAGEIFS($F$15:$F$40,$A$15:$A$40,$A9,$E$15:$E$40,\">=5\")","v":558000}]
["행복한우리집",{"$f":"AVERAGEIFS($F$15:$F$40,$A$15:$A$40,$A10,$E$15:$E$40,\">=5\")","v":280000}]
[]
[]
["[표4]"]
["공연이름","구분","예매일자","가격","예매수량","총금액","누적개수","할인액"]
["7080콘서트","C-콘서트","2020-06-09",35000,3,{"$f":"D15*E15","v":105000},null,{"$f":"fn할인액($B15, $F15)","v":""}]
["피노키오","M-뮤지컬","2020-04-05",19900,19,378100,null,{"$f":"fn할인액($B16, $F16)","v":56715}]
["아이돌대축제","C-콘서트","2020-05-08",43000,29,1247000,null,124700]
["요술친구","K-가족극","2020-02-05",21000,15,315000,null,""]
["백설공주","Y-무용","2020-07-15",15000,19,285000,null,""]
["7080콘서트","C-콘서트","2020-06-05",35000,10,350000,null,35000]
["요술친구","K-가족극","2020-05-03",21000,2,42000,null,""]
["천사의노래","M-뮤지컬","2020-02-01",31000,27,837000,null,125550]
["헨리의모험","K-가족극","2020-04-07",23000,6,138000,null,""]
["행복한우리집","K-가족극","2020-01-09",16000,5,80000,null,""]
["피노키오","M-뮤지컬","2020-02-12",19900,21,417900,null,62685]
["아이돌대축제","C-콘서트","2020-06-02",43000,26,1118000,null,111800]
["백설공주","Y-무용","2020-06-09",15000,3,45000,null,""]
["헨리의모험","K-가족극","2020-04-08",23000,32,736000,null,""]
["천사의노래","M-뮤지컬","2020-05-11",31000,2,62000,null,""]
["행복한우리집","K-가족극","2020-07-08",16000,30,480000,null,""]
["7080콘서트","C-콘서트","2020-06-09",35000,3,105000,null,""]
["행복한우리집","K-가족극","2020-04-05",16000,2,32000,null,""]
["7080콘서트","C-콘서트","2020-05-19",35000,11,385000,null,38500]
["천사의노래","M-뮤지컬","2020-05-07",31000,21,651000,null,97650]
["백설공주","Y-무용","2020-03-24",15000,5,75000,null,""]
["피노키오","M-뮤지컬","2020-06-08",19900,9,179100,null,""]
["피노키오","M-뮤지컬","2020-08-14",19900,5,99500,null,""]
["천사의노래","M-뮤지컬","2020-04-02",31000,6,186000,null,""]
["아이돌대축제","C-콘서트","2020-07-11",43000,4,172000,null,""]
["헨리의모험","K-가족극","2020-06-02",23000,2,46000,null,""]

{"sheet":"분석작업-1","index":3,"n_rows":31,"n_cols":6,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
[]
["구분","뮤지컬"]
[]
[null,null,null,"공연이름"]
["분기","예매일자","값","천사의노래","피노키오","총합계"]
["1사분기"]
[null,"2월"]
[null,null,"최대 : 예매수량",27,21,27]
[null,null,"최대 : 총금액",837000,417900,837000]
["1사분기 최대 : 예매수량",null,null,27,21,27]
["1사분기 최대 : 총금액",null,null,837000,417900,837000]
["2사분기"]
[null,"4월"]
[null,null,"최대 : 예매수량",6,19,19]
[null,null,"최대 : 총금액",186000,378100,378100]
[null,"5월"]
[null,null,"최대 : 예매수량",21,"***",21]
[null,null,"최대 : 총금액",651000,"***",651000]
[null,"6월"]
[null,null,"최대 : 예매수량","***",9,9]
[null,null,"최대 : 총금액","***",179100,179100]
["2사분기 최대 : 예매수량",null,null,21,19,21]
["2사분기 최대 : 총금액",null,null,651000,378100,651000]
["3사분기"]
[null,"8월"]
[null,null,"최대 : 예매수량","***",5,5]
[null,null,"최대 : 총금액","***",99500,99500]
["3사분기 최대 : 예매수량",null,null,"***",5,5]
["3사분기 최대 : 총금액",null,null,"***",99500,99500]
["전체 최대 : 예매수량",null,null,27,21,27]
["전체 최대 : 총금액",null,null,837000,417900,837000]

{"sheet":"분석작업-2","index":4,"n_rows":38,"n_cols":7,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
[]
[null,"[표1]"]
[null,"공연이름","구분","예매일자","가격","예매수량","총금액"]
[null,"행복한우리집","가족극","2020-07-08",16000,30,480000]
[null,"헨리의모험","가족극","2020-06-02",23000,2,46000]
[null,"요술친구","가족극","2020-05-03",21000,2,42000]
[null,"헨리의모험","가족극","2020-04-08",23000,32,736000]
[null,"헨리의모험","가족극","2020-04-07",23000,6,138000]
[null,"행복한우리집","가족극","2020-04-05",16000,2,32000]
[null,"요술친구","가족극","2020-02-05",21000,15,315000]
[null,"행복한우리집","가족극","2020-01-09",16000,5,80000]
[null,null,"가족극 평균",null,null,{"$f":"SUBTOTAL(1,F4:F11)","v":11.75},{"$f":"SUBTOTAL(1,G4:G11)","v":233625}]
[null,null,"가족극 요약",null,null,{"$f":"SUBTOTAL(9,F4:F11)","v":94},{"$f":"SUBTOTAL(9,G4:G11)","v":1869000}]
[null,"백설공주","무용","2020-07-15",15000,19,285000]
[null,"백설공주","무용","2020-06-09",15000,3,45000]
[null,"백설공주","무용","2020-03-24",15000,5,75000]
[null,null,"무용 평균",null,null,{"$f":"SUBTOTAL(1,F14:F16)","v":9},{"$f":"SUBTOTAL(1,G14:G16)","v":135000}]
[null,null,"무용 요약",null,null,{"$f":"SUBTOTAL(9,F14:F16)","v":27},{"$f":"SUBTOTAL(9,G14:G16)","v":405000}]
[null,"피노키오","뮤지컬","2020-08-14",19900,5,99500]
[null,"피노키오","뮤지컬","2020-06-08",19900,9,179100]
[null,"천사의노래","뮤지컬","2020-05-11",31000,2,62000]
[null,"천사의노래","뮤지컬","2020-05-07",31000,21,651000]
[null,"피노키오","뮤지컬","2020-04-05",19900,19,378100]
[null,"천사의노래","뮤지컬","2020-04-02",31000,6,186000]
[null,"피노키오","뮤지컬","2020-02-12",19900,21,417900]
[null,"천사의노래","뮤지컬","2020-02-01",31000,27,837000]
[null,null,"뮤지컬 평균",null,null,{"$f":"SUBTOTAL(1,F19:F26)","v":13.75},{"$f":"SUBTOTAL(1,G19:G26)","v":351325}]
[null,null,"뮤지컬 요약",null,null,{"$f":"SUBTOTAL(9,F19:F26)","v":110},{"$f":"SUBTOTAL(9,G19:G26)","v":2810600}]
[null,"아이돌대축제","콘서트","2020-07-11",43000,4,172000]
[null,"7080콘서트","콘서트","2020-06-09",35000,3,105000]
[null,"7080콘서트","콘서트","2020-06-05",35000,10,350000]
[null,"아이돌대축제","콘서트","2020-06-02",43000,26,1118000]
[null,"7080콘서트","콘서트","2020-05-19",35000,11,385000]
[null,"아이돌대축제","콘서트","2020-05-08",43000,29,1247000]
[null,null,"콘서트 평균",null,null,{"$f":"SUBTOTAL(1,F29:F34)","v":13.833333333333334},{"$f":"SUBTOTAL(1,G29:G34)","v":562833.33333333337}]
[null,null,"콘서트 요약",null,null,{"$f":"SUBTOTAL(9,F29:F34)","v":83},{"$f":"SUBTOTAL(9,G29:G34)","v":3377000}]
[null,null,"전체 평균",null,null,{"$f":"SUBTOTAL(1,F4:F34)","v":12.56},{"$f":"SUBTOTAL(1,G4:G34)","v":338464}]
[null,null,"총합계",null,null,{"$f":"SUBTOTAL(9,F4:F34)","v":314},{"$f":"SUBTOTAL(9,G4:G34)","v":8461600}]

{"sheet":"기타작업-1","index":5,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["공연별 관람 현황"]
[]
["공연이름","10월","11월","12월"]
["7080콘서트",1250,1250,5420]
["피노키오",2543,251,2541]
["아이돌대축제",1251,3541,5235]
["요술친구",2543,2541,2152]
["백설공주",1245,2354,5254]
["헨리의모험",2515,2510,1442]
["천사의노래",5212,2358,2541]
["행복한우리집",1254,2510,5841]

{"sheet":"기타작업-2","index":6,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[null,"[표1]"]
[null,"공연이름","가격","예매수량","총금액"]
[null,"7080콘서트",35000,100,{"$f":"C4*D4","v":3500000}]
[null,"백설공주",15000,35,525000]
[null,"아이돌대축제",43000,89,3827000]
[null,"요술친구",21000,120,2520000]
[null,"천사의노래",31000,75,2325000]
[null,"피노키오",19900,30,597000]
[null,"행복한우리집",16000,59,944000]
[null,"헨리의모험",23000,80,1840000]

{"sheet":"기타작업-3","index":7,"n_rows":12,"n_cols":13,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[null,null,"[표1]","공연 예매"]
[]
[]
[null,null,"예매일자","공연장","공연명","좌석수","구분","가격","총금액",null,"공연명","구분","가격"]
[null,null,"2023-11-30","아트센터","피노키오",2,"뮤지컬",19900,"39,800원",null,"7080콘서트","콘서트",35000]
[null,null,"2023-11-30","대학로소극장","요술친구",4,"가족극",21000,"84,000원",null,"피노키오","뮤지컬",19900]
[null,null,null,null,null,null,null,null,null,null,"아이돌대축제","콘서트",43000]
[null,null,null,null,null,null,null,null,null,null,"요술친구","가족극",21000]
[null,null,null,null,null,null,null,null,null,null,"백설공주","무용",15000]
[null,null,null,null,null,null,null,null,null,null,"헨리의모험","가족극",23000]
[null,null,null,null,null,null,null,null,null,null,"천사의노래","뮤지컬",31000]
[null,null,null,null,null,null,null,null,null,null,"행복한우리집","가족극",16000]