{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["분기별 판매 보고서","계산"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":7,"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":63,"n_cols":12,"rows_kept":63,"cut":false,"hidden":false,"merged":[[1,0,3,5]]}
[]
["분기별 판매 보고서",null,null,null,null,null,null,null,null,"상위 표시",5,"제품"]
[]
[null,null,null,null,null,null,null,null,null,"기타 모두 표시","아니요","제품"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"제품","1분기","2분기","3분기","4분기","합계"]
[null,"프레임",4000000,4500000,5000000,5000000,{"$f":"SUM(Sales[[#This Row],[1분기]:[4분기]])","v":18500000}]
[null,"디스크 브레이크, 전방",294000,250000,323000,368000,{"$f":"SUM(Sales[[#This Row],[1분기]:[4분기]])","v":1235000}]
[null,"캘리퍼 브레이크, 전방",200000,170000,220000,250000,{"$f":"SUM(Sales[[#This Row],[1분기]:[4분기]])","v":840000}]
[null,"디스크 브레이크, 후방",400000,340000,440000,500000,{"$f":"SUM(Sales[[#This Row],[1분기]:[4분기]])","v":1680000}]
[null,"캘리퍼 브레이크, 후방",294000,250000,323000,368000,{"$f":"SUM(Sales[[#This Row],[1분기]:[4분기]])","v":1235000}]
[null,"안장",235000,200000,32000,294000,{"$f":"SUM(Sales[[#This Row],[1분기]:[4분기]])","v":761000}]
[null,"포크",100000,85000,110000,125000,{"$f":"SUM(Sales[[#This Row],[1분기]:[4분기]])","v":420000}]
[null,"브레이크 케이블",300000,255000,330000,375000,{"$f":"SUM(Sales[[#This Row],[1분기]:[4분기]])","v":1260000}]
[null,"변속기 케이블",250000,213000,275000,313000,{"$f":"SUM(Sales[[#This Row],[1분기]:[4분기]])","v":1051000}]
[null,"후방 스프로킷",400000,340000,440000,500000,{"$f":"SUM(Sales[[#This Row],[1분기]:[4분기]])","v":1680000}]
[null,"전방 스프로킷",200000,170000,220000,250000,{"$f":"SUM(Sales[[#This Row],[1분기]:[4분기]])","v":840000}]
[null,"핸들바",1895000,1611000,3445000,3333000,{"$f":"SUM(Sales[[#This Row],[1분기]:[4분기]])","v":10284000}]
[null,"브레이크 레버",544000,462000,598000,680000,{"$f":"SUM(Sales[[#This Row],[1분기]:[4분기]])","v":2284000}]
[null,"안장 기둥",200000,170000,220000,250000,{"$f":"SUM(Sales[[#This Row],[1분기]:[4분기]])","v":840000}]
[null,"핸들바 클램프",60000,51000,66000,75000,{"$f":"SUM(Sales[[#This Row],[1분기]:[4분기]])","v":252000}]
[null,"안장 주머니",2413000,2051000,4000000,3016000,{"$f":"SUM(Sales[[#This Row],[1분기]:[4분기]])","v":11480000}]
[null,"스포크",233000,198000,256000,291000,{"$f":"SUM(Sales[[#This Row],[1분기]:[4분기]])","v":978000}]
[null,"림",354000,301000,389000,443000,{"$f":"SUM(Sales[[#This Row],[1분기]:[4분기]])","v":1487000}]
[null,"타이어",423000,360000,465000,529000,{"$f":"SUM(Sales[[#This Row],[1분기]:[4분기]])","v":1777000}]
[null,"그립",2222000,1889000,2444000,2778000,{"$f":"SUM(Sales[[#This Row],[1분기]:[4분기]])","v":9333000}]
[null,"그립 테이프",1550000,1318000,1705000,1938000,{"$f":"SUM(Sales[[#This Row],[1분기]:[4분기]])","v":6511000}]
[null,"패드",30000,26000,33000,38000,{"$f":"SUM(Sales[[#This Row],[1분기]:[4분기]])","v":127000}]
[null,"체인",208000,177000,229000,260000,{"$f":"SUM(Sales[[#This Row],[1분기]:[4분기]])","v":874000}]
[null,"드레일러",356000,303000,392000,445000,{"$f":"SUM(Sales[[#This Row],[1분기]:[4분기]])","v":1496000}]
[null,"퀵 릴리즈 허브",258000,219000,284000,323000,{"$f":"SUM(Sales[[#This Row],[1분기]:[4분기]])","v":1084000}]
[null,"표준 허브",414000,352000,455000,518000,{"$f":"SUM(Sales[[#This Row],[1분기]:[4분기]])","v":1739000}]
[null,"페달",369000,314000,406000,461000,{"$f":"SUM(Sales[[#This Row],[1분기]:[4분기]])","v":1550000}]
[null,"체인 가드",324000,275000,356000,405000,{"$f":"SUM(Sales[[#This Row],[1분기]:[4분기]])","v":1360000}]
[null,"거울",87000,74000,96000,109000,{"$f":"SUM(Sales[[#This Row],[1분기]:[4분기]])","v":366000}]

{"sheet":"계산","index":1,"n_rows":22,"n_cols":10,"rows_kept":22,"cut":false,"hidden":true,"merged":[]}
["*** 이 시트는 숨겨 두어야 합니다. ****"]
[]
[]
[null,null,null,null,"제품","1분기","2분기","3분기","4분기","합계"]
[null,1,{"$f":"IF($B5>n,\"\",LARGE(Sales[합계],1))","v":18500000},{"$f":"IF($B5>n,\"\",IF(C4=C5,MATCH(C5,OFFSET(Sales[합계],D4,),0)+D4,MATCH(C5,Sales[합계],0)))","v":1},{"$f":"IF($B5>n,\"\",INDEX(Sales[제품],D5))","v":"프레임"},{"$f":"IF($B5>n,\"\",INDEX(Sales[1분기],$D5))","v":4000000},{"$f":"IF($B5>n,\"\",INDEX(Sales[2분기],$D5))","v":4500000},{"$f":"IF($B5>n,\"\",INDEX(Sales[3분기],$D5))","v":5000000},{"$f":"IF($B5>n,\"\",INDEX(Sales[4분기],$D5))","v":5000000},{"$f":"IF($B5>n,\"\",SUM(F5:I5))","v":18500000}]
[null,2,{"$f":"IF($B6>n,\"\",LARGE(Sales[합계],2))","v":11480000},{"$f":"IF($B6>n,\"\",IF(C5=C6,MATCH(C6,OFFSET(Sales[합계],D5,),0)+D5,MATCH(C6,Sales[합계],0)))","v":16},{"$f":"IF($B6>n,\"\",INDEX(Sales[제품],D6))","v":"안장 주머니"},{"$f":"IF($B6>n,\"\",INDEX(Sales[1분기],$D6))","v":2413000},{"$f":"IF($B6>n,\"\",INDEX(Sales[2분기],$D6))","v":2051000},{"$f":"IF($B6>n,\"\",INDEX(Sales[3분기],$D6))","v":4000000},{"$f":"IF($B6>n,\"\",INDEX(Sales[4분기],$D6))","v":3016000},11480000]
[null,3,{"$f":"IF($B7>n,\"\",LARGE(Sales[합계],3))","v":10284000},{"$f":"IF($B7>n,\"\",IF(C6=C7,MATCH(C7,OFFSET(Sales[합계],D6,),0)+D6,MATCH(C7,Sales[합계],0)))","v":12},{"$f":"IF($B7>n,\"\",INDEX(Sales[제품],D7))","v":"핸들바"},{"$f":"IF($B7>n,\"\",INDEX(Sales[1분기],$D7))","v":1895000},{"$f":"IF($B7>n,\"\",INDEX(Sales[2분기],$D7))","v":1611000},{"$f":"IF($B7>n,\"\",INDEX(Sales[3분기],$D7))","v":3445000},{"$f":"IF($B7>n,\"\",INDEX(Sales[4분기],$D7))","v":3333000},10284000]
[null,4,{"$f":"IF($B8>n,\"\",LARGE(Sales[합계],4))","v":9333000},{"$f":"IF($B8>n,\"\",IF(C7=C8,MATCH(C8,OFFSET(Sales[합계],D7,),0)+D7,MATCH(C8,Sales[합계],0)))","v":20},{"$f":"IF($B8>n,\"\",INDEX(Sales[제품],D8))","v":"그립"},{"$f":"IF($B8>n,\"\",INDEX(Sales[1분기],$D8))","v":2222000},{"$f":"IF($B8>n,\"\",INDEX(Sales[2분기],$D8))","v":1889000},{"$f":"IF($B8>n,\"\",INDEX(Sales[3분기],$D8))","v":2444000},{"$f":"IF($B8>n,\"\",INDEX(Sales[4분기],$D8))","v":2778000},9333000]
[null,5,{"$f":"IF($B9>n,\"\",LARGE(Sales[합계],5))","v":6511000},{"$f":"IF($B9>n,\"\",IF(C8=C9,MATCH(C9,OFFSET(Sales[합계],D8,),0)+D8,MATCH(C9,Sales[합계],0)))","v":21},{"$f":"IF($B9>n,\"\",INDEX(Sales[제품],D9))","v":"그립 테이프"},{"$f":"IF($B9>n,\"\",INDEX(Sales[1분기],$D9))","v":1550000},{"$f":"IF($B9>n,\"\",INDEX(Sales[2분기],$D9))","v":1318000},{"$f":"IF($B9>n,\"\",INDEX(Sales[3분기],$D9))","v":1705000},{"$f":"IF($B9>n,\"\",INDEX(Sales[4분기],$D9))","v":1938000},6511000]
[null,6,{"$f":"IF($B10>n,\"\",LARGE(Sales[합계],6))","v":""},{"$f":"IF($B10>n,\"\",IF(C9=C10,MATCH(C10,OFFSET(Sales[합계],D9,),0)+D9,MATCH(C10,Sales[합계],0)))","v":""},{"$f":"IF($B10>n,\"\",INDEX(Sales[제품],D10))","v":""},{"$f":"IF($B10>n,\"\",INDEX(Sales[1분기],$D10))","v":""},{"$f":"IF($B10>n,\"\",INDEX(Sales[2분기],$D10))","v":""},{"$f":"IF($B10>n,\"\",INDEX(Sales[3분기],$D10))","v":""},{"$f":"IF($B10>n,\"\",INDEX(Sales[4분기],$D10))","v":""},""]
[null,7,{"$f":"IF($B11>n,\"\",LARGE(Sales[합계],7))","v":""},{"$f":"IF($B11>n,\"\",IF(C10=C11,MATCH(C11,OFFSET(Sales[합계],D10,),0)+D10,MATCH(C11,Sales[합계],0)))","v":""},{"$f":"IF($B11>n,\"\",INDEX(Sales[제품],D11))","v":""},{"$f":"IF($B11>n,\"\",INDEX(Sales[1분기],$D11))","v":""},{"$f":"IF($B11>n,\"\",INDEX(Sales[2분기],$D11))","v":""},{"$f":"IF($B11>n,\"\",INDEX(Sales[3분기],$D11))","v":""},{"$f":"IF($B11>n,\"\",INDEX(Sales[4분기],$D11))","v":""},""]
[null,8,{"$f":"IF($B12>n,\"\",LARGE(Sales[합계],8))","v":""},{"$f":"IF($B12>n,\"\",IF(C11=C12,MATCH(C12,OFFSET(Sales[합계],D11,),0)+D11,MATCH(C12,Sales[합계],0)))","v":""},{"$f":"IF($B12>n,\"\",INDEX(Sales[제품],D12))","v":""},{"$f":"IF($B12>n,\"\",INDEX(Sales[1분기],$D12))","v":""},{"$f":"IF($B12>n,\"\",INDEX(Sales[2분기],$D12))","v":""},{"$f":"IF($B12>n,\"\",INDEX(Sales[3분기],$D12))","v":""},{"$f":"IF($B12>n,\"\",INDEX(Sales[4분기],$D12))","v":""},""]
[null,9,{"$f":"IF($B13>n,\"\",LARGE(Sales[합계],9))","v":""},{"$f":"IF($B13>n,\"\",IF(C12=C13,MATCH(C13,OFFSET(Sales[합계],D12,),0)+D12,MATCH(C13,Sales[합계],0)))","v":""},{"$f":"IF($B13>n,\"\",INDEX(Sales[제품],D13))","v":""},{"$f":"IF($B13>n,\"\",INDEX(Sales[1분기],$D13))","v":""},{"$f":"IF($B13>n,\"\",INDEX(Sales[2분기],$D13))","v":""},{"$f":"IF($B13>n,\"\",INDEX(Sales[3분기],$D13))","v":""},{"$f":"IF($B13>n,\"\",INDEX(Sales[4분기],$D13))","v":""},""]
[null,10,{"$f":"IF($B14>n,\"\",LARGE(Sales[합계],10))","v":""},{"$f":"IF($B14>n,\"\",IF(C13=C14,MATCH(C14,OFFSET(Sales[합계],D13,),0)+D13,MATCH(C14,Sales[합계],0)))","v":""},{"$f":"IF($B14>n,\"\",INDEX(Sales[제품],D14))","v":""},{"$f":"IF($B14>n,\"\",INDEX(Sales[1분기],$D14))","v":""},{"$f":"IF($B14>n,\"\",INDEX(Sales[2분기],$D14))","v":""},{"$f":"IF($B14>n,\"\",INDEX(Sales[3분기],$D14))","v":""},{"$f":"IF($B14>n,\"\",INDEX(Sales[4분기],$D14))","v":""},""]
[null,null,null,null,{"$f":"\"\"","v":""}]
[null,{"$f":"IncludeOther=\"yes\"","v":false},null,null,"기타",{"$f":"SUM(Sales[1분기]) - SUM(F5:F14)","v":6533000},{"$f":"SUM(Sales[2분기]) - SUM(G5:G14)","v":5555000},{"$f":"SUM(Sales[3분기]) - SUM(H5:H14)","v":6958000},{"$f":"SUM(Sales[4분기]) - SUM(I5:I14)","v":8170000},{"$f":"SUM(Sales[합계]) - SUM(J5:J14)","v":27216000}]
[]
[null,null,null,null,"합계",{"$f":"SUM(Sales[1분기])","v":18613000},{"$f":"SUM(Sales[2분기])","v":16924000},{"$f":"SUM(Sales[3분기])","v":23552000},{"$f":"SUM(Sales[4분기])","v":24235000},{"$f":"SUM(Sales[합계])","v":83324000}]
[]
[]
[]
[null,{"$f":"\"전체 및 상위 \" & n & \" 개 제품\"","v":"전체 및 상위 5 개 제품"}]