{"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,"車架",120000,135000,150000,150000,{"$f":"SUM(Sales[[#This Row],[第 1 季]:[第 4 季]])","v":555000}]
[null,"前碟剎",8820,7500,9690,11040,{"$f":"SUM(Sales[[#This Row],[第 1 季]:[第 4 季]])","v":37050}]
[null,"前剎車器制動器",6000,5100,6600,7500,{"$f":"SUM(Sales[[#This Row],[第 1 季]:[第 4 季]])","v":25200}]
[null,"後碟剎",12000,10200,13200,15000,{"$f":"SUM(Sales[[#This Row],[第 1 季]:[第 4 季]])","v":50400}]
[null,"後剎車器制動器",8820,7500,9690,11040,{"$f":"SUM(Sales[[#This Row],[第 1 季]:[第 4 季]])","v":37050}]
[null,"坐墊",7050,6000,960,8820,{"$f":"SUM(Sales[[#This Row],[第 1 季]:[第 4 季]])","v":22830}]
[null,"前叉",3000,2550,3300,3750,{"$f":"SUM(Sales[[#This Row],[第 1 季]:[第 4 季]])","v":12600}]
[null,"剎車線",9000,7650,9900,11250,{"$f":"SUM(Sales[[#This Row],[第 1 季]:[第 4 季]])","v":37800}]
[null,"變速線",7500,6390,8250,9390,{"$f":"SUM(Sales[[#This Row],[第 1 季]:[第 4 季]])","v":31530}]
[null,"後鏈輪",12000,10200,13200,15000,{"$f":"SUM(Sales[[#This Row],[第 1 季]:[第 4 季]])","v":50400}]
[null,"前鏈輪",6000,5100,6600,7500,{"$f":"SUM(Sales[[#This Row],[第 1 季]:[第 4 季]])","v":25200}]
[null,"手把",56850,48330,103350,99990,{"$f":"SUM(Sales[[#This Row],[第 1 季]:[第 4 季]])","v":308520}]
[null,"煞車把手",16320,13860,17940,20400,{"$f":"SUM(Sales[[#This Row],[第 1 季]:[第 4 季]])","v":68520}]
[null,"座桿",6000,5100,6600,7500,{"$f":"SUM(Sales[[#This Row],[第 1 季]:[第 4 季]])","v":25200}]
[null,"把手束",1800,1530,1980,2250,{"$f":"SUM(Sales[[#This Row],[第 1 季]:[第 4 季]])","v":7560}]
[null,"座墊包",72390,61530,120000,90480,{"$f":"SUM(Sales[[#This Row],[第 1 季]:[第 4 季]])","v":344400}]
[null,"鋼絲",6990,5940,7680,8730,{"$f":"SUM(Sales[[#This Row],[第 1 季]:[第 4 季]])","v":29340}]
[null,"車圈",10620,9030,11670,13290,{"$f":"SUM(Sales[[#This Row],[第 1 季]:[第 4 季]])","v":44610}]
[null,"車胎",12690,10800,13950,15870,{"$f":"SUM(Sales[[#This Row],[第 1 季]:[第 4 季]])","v":53310}]
[null,"握把",66660,56670,73320,83340,{"$f":"SUM(Sales[[#This Row],[第 1 季]:[第 4 季]])","v":279990}]
[null,"握把套",46500,39540,51150,58140,{"$f":"SUM(Sales[[#This Row],[第 1 季]:[第 4 季]])","v":195330}]
[null,"腳踏車墊",900,780,990,1140,{"$f":"SUM(Sales[[#This Row],[第 1 季]:[第 4 季]])","v":3810}]
[null,"鏈條",6240,5310,6870,7800,{"$f":"SUM(Sales[[#This Row],[第 1 季]:[第 4 季]])","v":26220}]
[null,"變速裝置",10680,9090,11760,13350,{"$f":"SUM(Sales[[#This Row],[第 1 季]:[第 4 季]])","v":44880}]
[null,"快拆花鼓",7740,6570,8520,9690,{"$f":"SUM(Sales[[#This Row],[第 1 季]:[第 4 季]])","v":32520}]
[null,"標準花鼓",12420,10560,13650,15540,{"$f":"SUM(Sales[[#This Row],[第 1 季]:[第 4 季]])","v":52170}]
[null,"踏板",11070,9420,12180,13830,{"$f":"SUM(Sales[[#This Row],[第 1 季]:[第 4 季]])","v":46500}]
[null,"防掉鍊器",9720,8250,10680,12150,{"$f":"SUM(Sales[[#This Row],[第 1 季]:[第 4 季]])","v":40800}]
[null,"鏡子",2610,2220,2880,3270,{"$f":"SUM(Sales[[#This Row],[第 1 季]:[第 4 季]])","v":10980}]

{"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":555000},{"$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":120000},{"$f":"IF($B5>n,\"\",INDEX(Sales[第 2 季],$D5))","v":135000},{"$f":"IF($B5>n,\"\",INDEX(Sales[第 3 季],$D5))","v":150000},{"$f":"IF($B5>n,\"\",INDEX(Sales[第 4 季],$D5))","v":150000},{"$f":"IF($B5>n,\"\",SUM(F5:I5))","v":555000}]
[null,2,{"$f":"IF($B6>n,\"\",LARGE(Sales[合計],2))","v":344400},{"$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":72390},{"$f":"IF($B6>n,\"\",INDEX(Sales[第 2 季],$D6))","v":61530},{"$f":"IF($B6>n,\"\",INDEX(Sales[第 3 季],$D6))","v":120000},{"$f":"IF($B6>n,\"\",INDEX(Sales[第 4 季],$D6))","v":90480},344400]
[null,3,{"$f":"IF($B7>n,\"\",LARGE(Sales[合計],3))","v":308520},{"$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":56850},{"$f":"IF($B7>n,\"\",INDEX(Sales[第 2 季],$D7))","v":48330},{"$f":"IF($B7>n,\"\",INDEX(Sales[第 3 季],$D7))","v":103350},{"$f":"IF($B7>n,\"\",INDEX(Sales[第 4 季],$D7))","v":99990},308520]
[null,4,{"$f":"IF($B8>n,\"\",LARGE(Sales[合計],4))","v":279990},{"$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":66660},{"$f":"IF($B8>n,\"\",INDEX(Sales[第 2 季],$D8))","v":56670},{"$f":"IF($B8>n,\"\",INDEX(Sales[第 3 季],$D8))","v":73320},{"$f":"IF($B8>n,\"\",INDEX(Sales[第 4 季],$D8))","v":83340},279990]
[null,5,{"$f":"IF($B9>n,\"\",LARGE(Sales[合計],5))","v":195330},{"$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":46500},{"$f":"IF($B9>n,\"\",INDEX(Sales[第 2 季],$D9))","v":39540},{"$f":"IF($B9>n,\"\",INDEX(Sales[第 3 季],$D9))","v":51150},{"$f":"IF($B9>n,\"\",INDEX(Sales[第 4 季],$D9))","v":58140},195330]
[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=\"是\"","v":false},null,null,"其他",{"$f":"SUM(Sales[第 1 季]) - SUM(F5:F14)","v":195990},{"$f":"SUM(Sales[第 2 季]) - SUM(G5:G14)","v":166650},{"$f":"SUM(Sales[第 3 季]) - SUM(H5:H14)","v":208740},{"$f":"SUM(Sales[第 4 季]) - SUM(I5:I14)","v":245100},{"$f":"SUM(Sales[合計]) - SUM(J5:J14)","v":816480}]
[]
[null,null,null,null,"合計",{"$f":"SUM(Sales[第 1 季])","v":558390},{"$f":"SUM(Sales[第 2 季])","v":507720},{"$f":"SUM(Sales[第 3 季])","v":706560},{"$f":"SUM(Sales[第 4 季])","v":727050},{"$f":"SUM(Sales[合計])","v":2499720}]
[]
[]
[]
[null,{"$f":"\"總銷售額和前 \" & n & \" 大暢銷產品\"","v":"總銷售額和前 5 大暢銷產品"}]