{"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,"フレーム",400000,450000,500000,500000,{"$f":"SUM(Sales[[#This Row],[第 1 四半期]:[第 4 四半期]])","v":1850000}]
[null,"ディスク ブレーキ (フロント)",29400,24990,32340,36750,{"$f":"SUM(Sales[[#This Row],[第 1 四半期]:[第 4 四半期]])","v":123480}]
[null,"キャリパー ブレーキ (フロント)",20000,17000,22000,25000,{"$f":"SUM(Sales[[#This Row],[第 1 四半期]:[第 4 四半期]])","v":84000}]
[null,"ディスク ブレーキ (リア)",40000,34000,44000,50000,{"$f":"SUM(Sales[[#This Row],[第 1 四半期]:[第 4 四半期]])","v":168000}]
[null,"キャリパー ブレーキ (リア)",29400,24990,32340,36750,{"$f":"SUM(Sales[[#This Row],[第 1 四半期]:[第 4 四半期]])","v":123480}]
[null,"サドル",23500,19975,3200,29375,{"$f":"SUM(Sales[[#This Row],[第 1 四半期]:[第 4 四半期]])","v":76050}]
[null,"フォーク",10000,8500,11000,12500,{"$f":"SUM(Sales[[#This Row],[第 1 四半期]:[第 4 四半期]])","v":42000}]
[null,"ブレーキ ワイヤー",30000,25500,33000,37500,{"$f":"SUM(Sales[[#This Row],[第 1 四半期]:[第 4 四半期]])","v":126000}]
[null,"シフト ワイヤー",25000,21250,27500,31250,{"$f":"SUM(Sales[[#This Row],[第 1 四半期]:[第 4 四半期]])","v":105000}]
[null,"リア スプロケット",40000,34000,44000,50000,{"$f":"SUM(Sales[[#This Row],[第 1 四半期]:[第 4 四半期]])","v":168000}]
[null,"フロント スプロケット",20000,17000,22000,25000,{"$f":"SUM(Sales[[#This Row],[第 1 四半期]:[第 4 四半期]])","v":84000}]
[null,"ハンドル バー",189500,161075,344500,333300,{"$f":"SUM(Sales[[#This Row],[第 1 四半期]:[第 4 四半期]])","v":1028375}]
[null,"ブレーキ レバー",54400,46240,59840,68000,{"$f":"SUM(Sales[[#This Row],[第 1 四半期]:[第 4 四半期]])","v":228480}]
[null,"シート ポスト",20000,17000,22000,25000,{"$f":"SUM(Sales[[#This Row],[第 1 四半期]:[第 4 四半期]])","v":84000}]
[null,"ハンドル バー クランプ",6000,5100,6600,7500,{"$f":"SUM(Sales[[#This Row],[第 1 四半期]:[第 4 四半期]])","v":25200}]
[null,"サドル バッグ",241300,205105,400000,301625,{"$f":"SUM(Sales[[#This Row],[第 1 四半期]:[第 4 四半期]])","v":1148030}]
[null,"スポーク",23300,19805,25630,29125,{"$f":"SUM(Sales[[#This Row],[第 1 四半期]:[第 4 四半期]])","v":97860}]
[null,"リム",35400,30090,38940,44250,{"$f":"SUM(Sales[[#This Row],[第 1 四半期]:[第 4 四半期]])","v":148680}]
[null,"タイヤ",42300,35955,46530,52875,{"$f":"SUM(Sales[[#This Row],[第 1 四半期]:[第 4 四半期]])","v":177660}]
[null,"ハンドル グリップ",222200,188870,244420,277750,{"$f":"SUM(Sales[[#This Row],[第 1 四半期]:[第 4 四半期]])","v":933240}]
[null,"グリップ テープ",155040,131784,170544,193800,{"$f":"SUM(Sales[[#This Row],[第 1 四半期]:[第 4 四半期]])","v":651168}]
[null,"パッド",3000,2550,3300,3750,{"$f":"SUM(Sales[[#This Row],[第 1 四半期]:[第 4 四半期]])","v":12600}]
[null,"チェーン",20800,17680,22880,26000,{"$f":"SUM(Sales[[#This Row],[第 1 四半期]:[第 4 四半期]])","v":87360}]
[null,"ディレイラー",35600,30260,39160,44500,{"$f":"SUM(Sales[[#This Row],[第 1 四半期]:[第 4 四半期]])","v":149520}]
[null,"クイック リリース ハブ",25800,21930,28380,32250,{"$f":"SUM(Sales[[#This Row],[第 1 四半期]:[第 4 四半期]])","v":108360}]
[null,"スタンダード ハブ",41400,35190,45540,51750,{"$f":"SUM(Sales[[#This Row],[第 1 四半期]:[第 4 四半期]])","v":173880}]
[null,"ペダル",36900,31365,40590,46125,{"$f":"SUM(Sales[[#This Row],[第 1 四半期]:[第 4 四半期]])","v":154980}]
[null,"チェーン ガード",32400,27540,35640,40500,{"$f":"SUM(Sales[[#This Row],[第 1 四半期]:[第 4 四半期]])","v":136080}]
[null,"ミラー",8700,7395,9570,10875,{"$f":"SUM(Sales[[#This Row],[第 1 四半期]:[第 4 四半期]])","v":36540}]

{"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":1850000},{"$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":400000},{"$f":"IF($B5>n,\"\",INDEX(Sales[第 2 四半期],$D5))","v":450000},{"$f":"IF($B5>n,\"\",INDEX(Sales[第 3 四半期],$D5))","v":500000},{"$f":"IF($B5>n,\"\",INDEX(Sales[第 4 四半期],$D5))","v":500000},{"$f":"IF($B5>n,\"\",SUM(F5:I5))","v":1850000}]
[null,2,{"$f":"IF($B6>n,\"\",LARGE(Sales[合計],2))","v":1148030},{"$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":241300},{"$f":"IF($B6>n,\"\",INDEX(Sales[第 2 四半期],$D6))","v":205105},{"$f":"IF($B6>n,\"\",INDEX(Sales[第 3 四半期],$D6))","v":400000},{"$f":"IF($B6>n,\"\",INDEX(Sales[第 4 四半期],$D6))","v":301625},1148030]
[null,3,{"$f":"IF($B7>n,\"\",LARGE(Sales[合計],3))","v":1028375},{"$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":189500},{"$f":"IF($B7>n,\"\",INDEX(Sales[第 2 四半期],$D7))","v":161075},{"$f":"IF($B7>n,\"\",INDEX(Sales[第 3 四半期],$D7))","v":344500},{"$f":"IF($B7>n,\"\",INDEX(Sales[第 4 四半期],$D7))","v":333300},1028375]
[null,4,{"$f":"IF($B8>n,\"\",LARGE(Sales[合計],4))","v":933240},{"$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":222200},{"$f":"IF($B8>n,\"\",INDEX(Sales[第 2 四半期],$D8))","v":188870},{"$f":"IF($B8>n,\"\",INDEX(Sales[第 3 四半期],$D8))","v":244420},{"$f":"IF($B8>n,\"\",INDEX(Sales[第 4 四半期],$D8))","v":277750},933240]
[null,5,{"$f":"IF($B9>n,\"\",LARGE(Sales[合計],5))","v":651168},{"$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":155040},{"$f":"IF($B9>n,\"\",INDEX(Sales[第 2 四半期],$D9))","v":131784},{"$f":"IF($B9>n,\"\",INDEX(Sales[第 3 四半期],$D9))","v":170544},{"$f":"IF($B9>n,\"\",INDEX(Sales[第 4 四半期],$D9))","v":193800},651168]
[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":653300},{"$f":"SUM(Sales[第 2 四半期]) - SUM(G5:G14)","v":555305},{"$f":"SUM(Sales[第 3 四半期]) - SUM(H5:H14)","v":695980},{"$f":"SUM(Sales[第 4 四半期]) - SUM(I5:I14)","v":816625},{"$f":"SUM(Sales[合計]) - SUM(J5:J14)","v":2721210}]
[]
[null,null,null,null,"合計",{"$f":"SUM(Sales[第 1 四半期])","v":1861340},{"$f":"SUM(Sales[第 2 四半期])","v":1692139},{"$f":"SUM(Sales[第 3 四半期])","v":2355444},{"$f":"SUM(Sales[第 4 四半期])","v":2423100},{"$f":"SUM(Sales[合計])","v":8332023}]
[]
[]
[]
[null,{"$f":"\"総売上および上位  \" & n & \" 製品\"","v":"総売上および上位  5 製品"}]