{"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,"车架",40000,45000,50000,50000,{"$f":"SUM(Sales[[#This Row],[第 1 季度]:[第 4 季度]])","v":185000}]
[null,"碟式刹车，前侧",2940,2499,3234,3675,{"$f":"SUM(Sales[[#This Row],[第 1 季度]:[第 4 季度]])","v":12348}]
[null,"卡钳刹车，前侧",2000,1700,2200,2500,{"$f":"SUM(Sales[[#This Row],[第 1 季度]:[第 4 季度]])","v":8400}]
[null,"碟式刹车，后侧",4000,3400,4400,5000,{"$f":"SUM(Sales[[#This Row],[第 1 季度]:[第 4 季度]])","v":16800}]
[null,"卡钳刹车，后侧",2940,2499,3234,3675,{"$f":"SUM(Sales[[#This Row],[第 1 季度]:[第 4 季度]])","v":12348}]
[null,"车座",2350,1997.5,320,2937.5,{"$f":"SUM(Sales[[#This Row],[第 1 季度]:[第 4 季度]])","v":7605}]
[null,"前叉",1000,850,1100,1250,{"$f":"SUM(Sales[[#This Row],[第 1 季度]:[第 4 季度]])","v":4200}]
[null,"刹车线",3000,2550,3300,3750,{"$f":"SUM(Sales[[#This Row],[第 1 季度]:[第 4 季度]])","v":12600}]
[null,"变速线",2500,2125,2750,3125,{"$f":"SUM(Sales[[#This Row],[第 1 季度]:[第 4 季度]])","v":10500}]
[null,"后链轮",4000,3400,4400,5000,{"$f":"SUM(Sales[[#This Row],[第 1 季度]:[第 4 季度]])","v":16800}]
[null,"前链轮",2000,1700,2200,2500,{"$f":"SUM(Sales[[#This Row],[第 1 季度]:[第 4 季度]])","v":8400}]
[null,"把手",18950,16107.5,34450,33330,{"$f":"SUM(Sales[[#This Row],[第 1 季度]:[第 4 季度]])","v":102837.5}]
[null,"刹车把手",5440,4624,5984,6800,{"$f":"SUM(Sales[[#This Row],[第 1 季度]:[第 4 季度]])","v":22848}]
[null,"座杆",2000,1700,2200,2500,{"$f":"SUM(Sales[[#This Row],[第 1 季度]:[第 4 季度]])","v":8400}]
[null,"车把夹",600,510,660,750,{"$f":"SUM(Sales[[#This Row],[第 1 季度]:[第 4 季度]])","v":2520}]
[null,"车座包",24130,20510.5,40000,30162.5,{"$f":"SUM(Sales[[#This Row],[第 1 季度]:[第 4 季度]])","v":114803}]
[null,"辐条",2330,1980.5,2563,2912.5,{"$f":"SUM(Sales[[#This Row],[第 1 季度]:[第 4 季度]])","v":9786}]
[null,"车圈",3540,3009,3894,4425,{"$f":"SUM(Sales[[#This Row],[第 1 季度]:[第 4 季度]])","v":14868}]
[null,"轮胎",4230,3595.5,4653,5287.5,{"$f":"SUM(Sales[[#This Row],[第 1 季度]:[第 4 季度]])","v":17766}]
[null,"把套",22220,18887,24442,27775,{"$f":"SUM(Sales[[#This Row],[第 1 季度]:[第 4 季度]])","v":93324}]
[null,"握把带",15504,13178.4,17054.400000000001,19380,{"$f":"SUM(Sales[[#This Row],[第 1 季度]:[第 4 季度]])","v":65116.800000000003}]
[null,"刹车板",300,255,330,375,{"$f":"SUM(Sales[[#This Row],[第 1 季度]:[第 4 季度]])","v":1260}]
[null,"链条",2080,1768,2288,2600,{"$f":"SUM(Sales[[#This Row],[第 1 季度]:[第 4 季度]])","v":8736}]
[null,"变速器",3560,3026,3916,4450,{"$f":"SUM(Sales[[#This Row],[第 1 季度]:[第 4 季度]])","v":14952}]
[null,"快拆花鼓",2580,2193,2838,3225,{"$f":"SUM(Sales[[#This Row],[第 1 季度]:[第 4 季度]])","v":10836}]
[null,"标准花鼓",4140,3519,4554,5175,{"$f":"SUM(Sales[[#This Row],[第 1 季度]:[第 4 季度]])","v":17388}]
[null,"踏板",3690,3136.5,4059,4612.5,{"$f":"SUM(Sales[[#This Row],[第 1 季度]:[第 4 季度]])","v":15498}]
[null,"链罩",3240,2754,3564,4050,{"$f":"SUM(Sales[[#This Row],[第 1 季度]:[第 4 季度]])","v":13608}]
[null,"反光镜",870,739.5,957,1087.5,{"$f":"SUM(Sales[[#This Row],[第 1 季度]:[第 4 季度]])","v":3654}]

{"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":185000},{"$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":40000},{"$f":"IF($B5>n,\"\",INDEX(Sales[第 2 季度],$D5))","v":45000},{"$f":"IF($B5>n,\"\",INDEX(Sales[第 3 季度],$D5))","v":50000},{"$f":"IF($B5>n,\"\",INDEX(Sales[第 4 季度],$D5))","v":50000},{"$f":"IF($B5>n,\"\",SUM(F5:I5))","v":185000}]
[null,2,{"$f":"IF($B6>n,\"\",LARGE(Sales[总计],2))","v":114803},{"$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":24130},{"$f":"IF($B6>n,\"\",INDEX(Sales[第 2 季度],$D6))","v":20510.5},{"$f":"IF($B6>n,\"\",INDEX(Sales[第 3 季度],$D6))","v":40000},{"$f":"IF($B6>n,\"\",INDEX(Sales[第 4 季度],$D6))","v":30162.5},114803]
[null,3,{"$f":"IF($B7>n,\"\",LARGE(Sales[总计],3))","v":102837.5},{"$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":18950},{"$f":"IF($B7>n,\"\",INDEX(Sales[第 2 季度],$D7))","v":16107.5},{"$f":"IF($B7>n,\"\",INDEX(Sales[第 3 季度],$D7))","v":34450},{"$f":"IF($B7>n,\"\",INDEX(Sales[第 4 季度],$D7))","v":33330},102837.5]
[null,4,{"$f":"IF($B8>n,\"\",LARGE(Sales[总计],4))","v":93324},{"$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":22220},{"$f":"IF($B8>n,\"\",INDEX(Sales[第 2 季度],$D8))","v":18887},{"$f":"IF($B8>n,\"\",INDEX(Sales[第 3 季度],$D8))","v":24442},{"$f":"IF($B8>n,\"\",INDEX(Sales[第 4 季度],$D8))","v":27775},93324]
[null,5,{"$f":"IF($B9>n,\"\",LARGE(Sales[总计],5))","v":65116.800000000003},{"$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":15504},{"$f":"IF($B9>n,\"\",INDEX(Sales[第 2 季度],$D9))","v":13178.4},{"$f":"IF($B9>n,\"\",INDEX(Sales[第 3 季度],$D9))","v":17054.400000000001},{"$f":"IF($B9>n,\"\",INDEX(Sales[第 4 季度],$D9))","v":19380},65116.800000000003]
[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":65330},{"$f":"SUM(Sales[第 2 季度]) - SUM(G5:G14)","v":55530.5},{"$f":"SUM(Sales[第 3 季度]) - SUM(H5:H14)","v":69598},{"$f":"SUM(Sales[第 4 季度]) - SUM(I5:I14)","v":81662.5},{"$f":"SUM(Sales[总计]) - SUM(J5:J14)","v":272121}]
[]
[null,null,null,null,"总计",{"$f":"SUM(Sales[第 1 季度])","v":186134},{"$f":"SUM(Sales[第 2 季度])","v":169213.9},{"$f":"SUM(Sales[第 3 季度])","v":235544.4},{"$f":"SUM(Sales[第 4 季度])","v":242310},{"$f":"SUM(Sales[总计])","v":833202.3}]
[]
[]
[]
[null,{"$f":"\"总计和前 \" & n & \"项产品\"","v":"总计和前 5项产品"}]