{"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":10,"n_cols":7,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,5,0,6],[0,0,0,3]]}
["판매현황",null,null,null,null,"품목별 판매건수"]
[]
["품목","수량","단가","금액","","품목","건수"]
["냉장고",6,250,1500,null,"컴퓨터",{"$f":"COUNTIF($A$4:$A$10,F4)","v":3}]
["컴퓨터",8,300,2400,null,"캠코더",{"$f":"COUNTIF($A$4:$A$10,F5)","v":2}]
["냉장고",5,250,1250,null,"냉장고",2]
["캠코더",7,500,3500]
["컴퓨터",10,300,3000]
["캠코더",5,500,2500]
["컴퓨터",7,300,2100]

{"sheet":"기출","index":1,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,1,0,4]]}
[null,"고급형 제품의 평균"]
[null,"등급","판매량","단가","원가비율"]
[null,"고급형",35,1200,0.7]
[null,"중급형",60,800,0.6]
[null,"보급형",120,600,0.55000000000000004]
[null,"보급형",60,800,0.55000000000000004]
[null,"고급형",25,600,0.7]
[null,"중급형",54,800,0.6]
[null,"평균",{"$f":"SUMIF($B$3:$B$8,\"고급형\",C3:C8)/COUNTIF($B$3:$B$8,\"고급형\")","v":30},{"$f":"SUMIF($B$3:$B$8,\"고급형\",D3:D8)/COUNTIF($B$3:$B$8,\"고급형\")","v":900},0.7]
[]
[]
[null,null,{"$f":"COUNTIF($B$3:$B$8,\"고급형\")","v":2}]
[null,null,{"$f":"COUNT(($B$3:$B$8=\"고급형\")*C3:C8)","v":6}]
[null,null,{"$f":"COUNT(IF(($B$3:$B$8=\"고급형\"),C3:C8))","v":2}]