{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["ユーザー定義","放物線","二次関数(右辺)","二次関数(両辺)","反比例","正比例","サインカーブ","使い方","piano"],"not_rendered":{"charts":7,"images":1,"macros":1,"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":33,"n_cols":7,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
["Y","Normalize","Key","min","max","range","PLAY"]
[{"$f":"225-(15-ROW()+2)^2","v":0},{"$f":"IF(A2<>\"\",(A2-$D$2)/$F$2,\"\")","v":0},{"$f":"IF(A2<>\"\",INT($D$4+(B2*$F$4)),\"\")","v":25},{"$f":"MIN(A:A)","v":0},{"$f":"MAX(A:A)","v":180},{"$f":"E2-D2","v":180}]
[10,{"$f":"IF(A3<>\"\",(A3-$D$2)/$F$2,\"\")","v":5.5555555555555552E-2},{"$f":"IF(A3<>\"\",INT($D$4+(B3*$F$4)),\"\")","v":28},"Low","High","diff","time"]
[20,0.1111111111111111,31,25,85,{"$f":"E4-D4","v":60},150]
[10,5.5555555555555552E-2,28]
[30,0.16666666666666666,35]
[40,0.22222222222222221,38]
[30,0.16666666666666666,35]
[40,0.22222222222222221,38]
[50,0.27777777777777779,41]
[60,0.33333333333333331,45]
[50,0.27777777777777779,41]
[60,0.33333333333333331,45]
[70,0.3888888888888889,48]
[80,0.44444444444444442,51]
[90,0.5,55]
[80,0.44444444444444442,51]
[90,0.5,55]
[100,0.55555555555555558,58]
[120,0.66666666666666663,65]
[140,0.77777777777777779,71]
[180,1,85]
[null,"",""]
[null,"",""]
[null,"",""]
[null,"",""]
[null,"",""]
[null,"",""]
[null,"",""]
[null,"",""]
[null,"",""]
[null,"",""]
[null,"",""]

{"sheet":"放物線","index":1,"n_rows":33,"n_cols":7,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
["Y","Normalize","Key","min","max","range","PLAY"]
[{"$f":"225-(15-ROW()+2)^2","v":0},{"$f":"IF(A2<>\"\",(A2-$D$2)/$F$2,\"\")","v":0},{"$f":"IF(A2<>\"\",INT($D$4+(B2*$F$4)),\"\")","v":25},{"$f":"MIN(A:A)","v":0},{"$f":"MAX(A:A)","v":225},{"$f":"E2-D2","v":225}]
[{"$f":"225-(15-ROW()+2)^2","v":29},{"$f":"IF(A3<>\"\",(A3-$D$2)/$F$2,\"\")","v":0.12888888888888889},{"$f":"IF(A3<>\"\",INT($D$4+(B3*$F$4)),\"\")","v":32},"Low","High","diff","time"]
[56,0.24888888888888888,39,25,85,{"$f":"E4-D4","v":60},150]
[81,0.36,46]
[104,0.4622222222222222,52]
[125,0.55555555555555558,58]
[144,0.64,63]
[161,0.7155555555555555,67]
[176,0.78222222222222226,71]
[189,0.84,75]
[200,0.88888888888888884,78]
[209,0.92888888888888888,80]
[216,0.96,82]
[221,0.98222222222222222,83]
[224,0.99555555555555553,84]
[225,1,85]
[224,0.99555555555555553,84]
[221,0.98222222222222222,83]
[216,0.96,82]
[209,0.92888888888888888,80]
[200,0.88888888888888884,78]
[189,0.84,75]
[176,0.78222222222222226,71]
[161,0.7155555555555555,67]
[144,0.64,63]
[125,0.55555555555555558,58]
[104,0.4622222222222222,52]
[81,0.36,46]
[56,0.24888888888888888,39]
[29,0.12888888888888889,32]
[0,0,25]
[null,"",""]

{"sheet":"二次関数(右辺)","index":2,"n_rows":33,"n_cols":7,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
["Y","Normalize","Key","min","max","range","PLAY"]
[{"$f":"(ROW()-2)^2","v":0},{"$f":"IF(A2<>\"\",(A2-$D$2)/$F$2,\"\")","v":0},{"$f":"IF(A2<>\"\",INT($D$4+(B2*$F$4)),\"\")","v":25},{"$f":"MIN(A:A)","v":0},{"$f":"MAX(A:A)","v":676},{"$f":"E2-D2","v":676}]
[{"$f":"(ROW()-2)^2","v":1},{"$f":"IF(A3<>\"\",(A3-$D$2)/$F$2,\"\")","v":1.4792899408284023E-3},{"$f":"IF(A3<>\"\",INT($D$4+(B3*$F$4)),\"\")","v":25},"Low","High","diff","time"]
[4,5.9171597633136093E-3,25,25,85,{"$f":"E4-D4","v":60},100]
[9,1.3313609467455622E-2,25]
[16,2.3668639053254437E-2,26]
[25,3.6982248520710061E-2,27]
[36,5.3254437869822487E-2,28]
[49,7.2485207100591711E-2,29]
[64,9.4674556213017749E-2,30]
[81,0.11982248520710059,32]
[100,0.14792899408284024,33]
[121,0.17899408284023668,35]
[144,0.21301775147928995,37]
[169,0.25,40]
[196,0.28994082840236685,42]
[225,0.33284023668639051,44]
[256,0.378698224852071,47]
[289,0.4275147928994083,50]
[324,0.47928994082840237,53]
[361,0.53402366863905326,57]
[400,0.59171597633136097,60]
[441,0.65236686390532539,64]
[484,0.71597633136094674,67]
[529,0.78254437869822491,71]
[576,0.85207100591715978,76]
[625,0.92455621301775148,80]
[676,1,85]
[null,"",""]
[null,"",""]
[null,"",""]
[null,"",""]
[null,"",""]

{"sheet":"二次関数(両辺)","index":3,"n_rows":33,"n_cols":7,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
["Y","Normalize","Key","min","max","range","PLAY"]
[{"$f":"(ROW()-15)^2","v":169},{"$f":"IF(A2<>\"\",(A2-$D$2)/$F$2,\"\")","v":1},{"$f":"IF(A2<>\"\",INT($D$4+(B2*$F$4)),\"\")","v":85},{"$f":"MIN(A:A)","v":0},{"$f":"MAX(A:A)","v":169},{"$f":"E2-D2","v":169}]
[{"$f":"(ROW()-15)^2","v":144},{"$f":"IF(A3<>\"\",(A3-$D$2)/$F$2,\"\")","v":0.85207100591715978},{"$f":"IF(A3<>\"\",INT($D$4+(B3*$F$4)),\"\")","v":76},"Low","High","diff","time"]
[121,0.71597633136094674,67,25,85,{"$f":"E4-D4","v":60},100]
[100,0.59171597633136097,60]
[81,0.47928994082840237,53]
[64,0.378698224852071,47]
[49,0.28994082840236685,42]
[36,0.21301775147928995,37]
[25,0.14792899408284024,33]
[16,9.4674556213017749E-2,30]
[9,5.3254437869822487E-2,28]
[4,2.3668639053254437E-2,26]
[1,5.9171597633136093E-3,25]
[0,0,25]
[1,5.9171597633136093E-3,25]
[4,2.3668639053254437E-2,26]
[9,5.3254437869822487E-2,28]
[16,9.4674556213017749E-2,30]
[25,0.14792899408284024,33]
[36,0.21301775147928995,37]
[49,0.28994082840236685,42]
[64,0.378698224852071,47]
[81,0.47928994082840237,53]
[100,0.59171597633136097,60]
[121,0.71597633136094674,67]
[144,0.85207100591715978,76]
[169,1,85]
[null,"",""]
[null,"",""]
[null,"",""]
[null,"",""]
[null,"",""]

{"sheet":"反比例","index":4,"n_rows":33,"n_cols":7,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
["Y","Normalize","Key","min","max","range","PLAY"]
[{"$f":"10/ROW()","v":5},{"$f":"IF(A2<>\"\",(A2-$D$2)/$F$2,\"\")","v":1},{"$f":"IF(A2<>\"\",INT($D$4+(B2*$F$4)),\"\")","v":85},{"$f":"MIN(A:A)","v":0.30303030303030304},{"$f":"MAX(A:A)","v":5},{"$f":"E2-D2","v":4.6969696969696972}]
[{"$f":"10/ROW()","v":3.3333333333333335},{"$f":"IF(A3<>\"\",(A3-$D$2)/$F$2,\"\")","v":0.64516129032258063},{"$f":"IF(A3<>\"\",INT($D$4+(B3*$F$4)),\"\")","v":63},"Low","High","diff","time"]
[2.5,0.46774193548387089,53,25,85,{"$f":"E4-D4","v":60},100]
[2,0.36129032258064514,46]
[1.6666666666666667,0.29032258064516131,42]
[1.4285714285714286,0.23963133640552994,39]
[1.25,0.20161290322580644,37]
[1.1111111111111112,0.17204301075268819,35]
[1,0.14838709677419354,33]
[0.90909090909090906,0.1290322580645161,32]
[0.83333333333333337,0.1129032258064516,31]
[0.76923076923076927,9.9255583126550875E-2,30]
[0.7142857142857143,8.755760368663594E-2,30]
[0.66666666666666663,7.7419354838709667E-2,29]
[0.625,6.8548387096774188E-2,29]
[0.58823529411764708,6.0721062618595827E-2,28]
[0.55555555555555558,5.3763440860215055E-2,28]
[0.52631578947368418,4.7538200339558565E-2,27]
[0.5,4.1935483870967738E-2,27]
[0.47619047619047616,3.6866359447004601E-2,27]
[0.45454545454545453,3.2258064516129024E-2,26]
[0.43478260869565216,2.8050490883590459E-2,26]
[0.41666666666666669,2.4193548387096774E-2,26]
[{"$f":"10/ROW()","v":0.4},2.0645161290322584E-2,26]
[0.38461538461538464,1.7369727047146403E-2,26]
[0.37037037037037035,1.4336917562724007E-2,25]
[0.35714285714285715,1.1520737327188939E-2,25]
[0.34482758620689657,8.8987764182424951E-3,25]
[0.33333333333333331,6.4516129032258004E-3,25]
[0.32258064516129031,4.162330905306968E-3,25]
[0.3125,2.0161290322580627E-3,25]
[0.30303030303030304,0,25]

{"sheet":"正比例","index":5,"n_rows":33,"n_cols":7,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
["Y","Normalize","Key","min","max","range","PLAY"]
[0,{"$f":"IF(A2<>\"\",(A2-$D$2)/$F$2,\"\")","v":0},{"$f":"IF(A2<>\"\",INT($D$4+(B2*$F$4)),\"\")","v":25},{"$f":"MIN(A:A)","v":0},{"$f":"MAX(A:A)","v":240},{"$f":"E2-D2","v":240}]
[{"$f":"A2+10","v":10},{"$f":"IF(A3<>\"\",(A3-$D$2)/$F$2,\"\")","v":4.1666666666666664E-2},{"$f":"IF(A3<>\"\",INT($D$4+(B3*$F$4)),\"\")","v":27},"Low","High","diff","time"]
[{"$f":"A3+10","v":20},8.3333333333333329E-2,29,25,80,{"$f":"E4-D4","v":55},100]
[30,0.125,31]
[40,0.16666666666666666,34]
[50,0.20833333333333334,36]
[60,0.25,38]
[70,0.29166666666666669,41]
[80,0.33333333333333331,43]
[90,0.375,45]
[100,0.41666666666666669,47]
[110,0.45833333333333331,50]
[120,0.5,52]
[130,0.54166666666666663,54]
[140,0.58333333333333337,57]
[150,0.625,59]
[160,0.66666666666666663,61]
[170,0.70833333333333337,63]
[180,0.75,66]
[190,0.79166666666666663,68]
[200,0.83333333333333337,70]
[210,0.875,73]
[220,0.91666666666666663,75]
[230,0.95833333333333337,77]
[240,1,80]
[null,"",""]
[null,"",""]
[null,"",""]
[null,"",""]
[null,"",""]
[null,"",""]
[null,"",""]

{"sheet":"サインカーブ","index":6,"n_rows":33,"n_cols":7,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
["Y","Normalize","Key","min","max","range","PLAY"]
[0,{"$f":"IF(A2<>\"\",(A2-$D$2)/$F$2,\"\")","v":0.5},{"$f":"IF(A2<>\"\",INT($D$4+(B2*$F$4)),\"\")","v":47},{"$f":"MIN(A:A)","v":-1},{"$f":"MAX(A:A)","v":1},{"$f":"E2-D2","v":2}]
[0.25881904510252074,{"$f":"IF(A3<>\"\",(A3-$D$2)/$F$2,\"\")","v":0.62940952255126037},{"$f":"IF(A3<>\"\",INT($D$4+(B3*$F$4)),\"\")","v":50},"Low","High","diff","time"]
[0.49999999999999994,0.75,53,35,60,{"$f":"E4-D4","v":25},100]
[0.70710678118654746,0.85355339059327373,56]
[0.8660254037844386,0.9330127018922193,58]
[0.96592582628906831,0.9829629131445341,59]
[1,1,60]
[0.96592582628906831,0.9829629131445341,59]
[0.86602540378443871,0.93301270189221941,58]
[0.70710678118654757,0.85355339059327373,56]
[0.49999999999999994,0.75,53]
[0.25881904510252102,0.62940952255126048,50]
[1.22514845490862E-16,0.50000000000000011,47]
[-0.25881904510252079,0.37059047744873963,44]
[-0.50000000000000011,0.24999999999999994,41]
[-0.70710678118654746,0.14644660940672627,38]
[-0.86602540378443837,6.6987298107780813E-2,36]
[-0.96592582628906831,1.7037086855465844E-2,35]
[-1,0,35]
[-0.96592582628906842,1.7037086855465788E-2,35]
[-0.8660254037844386,6.6987298107780702E-2,36]
[-0.70710678118654768,0.14644660940672616,38]
[-0.50000000000000044,0.24999999999999978,41]
[-0.25881904510252068,0.37059047744873963,44]
[-2.45029690981724E-16,0.49999999999999989,47]
[null,"",""]
[null,"",""]
[null,"",""]
[null,"",""]
[null,"",""]
[null,"",""]
[null,"",""]

{"sheet":"使い方","index":7,"n_rows":15,"n_cols":2,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["１　ツールの名称","SoundGraph(さうんどぐらふ) Ver 1.12"]
["２　目的","グラフを音で聞く"]
["３　各シート"]
["ユーザー定義","ユーザー自身が数値を入力してグラフを描画し音で聞く。"]
["正比例","正比例のグラフ"]
["反比例","反比例のグラフ"]
["放物線","放物線のグラフ"]
["二次関数","二次関数のグラフ"]
["使い方","このシート"]
["４　操作方法","各シートでG1セルをクリックするとそのシートのグラフの音が鳴る。"]
[null,"ユーザー定義シートではA2からA33までのセルに数値を入力できる。"]
[null,"D4セルは鳴らしたい最も低い音を、E４セルには最も高い音の番号を入力する。"]
[null,"G４セルには一つの音の長さをmsec単位で入力する。"]
["ご意見こちらまで","Dr.dbTarzan@gmail.com"]
[null,"高橋信行"]

{"sheet":"piano","index":8,"n_rows":104,"n_cols":4,"rows_kept":104,"cut":false,"hidden":true,"merged":[[0,2,1,3]]}
["鍵盤","周波数","音階名※"]
["番号","(Hz)"]
[1,27.5,"ラ0","A0"]
[2,29.135000000000002,"ラ#0","A#0"]
[3,30.867999999999999,"シ0","B0"]
[4,32.703000000000003,"ド1","C1"]
[5,34.648000000000003,"ド#1","C#1"]
[6,36.707999999999998,"レ1","D1"]
[7,38.890999999999998,"レ#1","D#1"]
[8,41.203000000000003,"ミ1","E1"]
[9,43.654000000000003,"ファ1","F1"]
[10,46.249000000000002,"ファ#1","F#1"]
[11,48.999000000000002,"ソ1","G1"]
[12,51.912999999999997,"ソ#1","G#1"]
[13,55,"ラ1","A1"]
[14,58.27,"ラ#1","A#1"]
[15,61.734999999999999,"シ1","B1"]
[16,65.406000000000006,"ド2","C2"]
[17,69.296000000000006,"ド#2","C#2"]
[18,73.415999999999997,"レ2","D2"]
[19,77.781999999999996,"レ#2","D#2"]
[20,82.406999999999996,"ミ2","E2"]
[21,87.307000000000002,"ファ2","F2"]
[22,92.498999999999995,"ファ#2","F#2"]
[23,97.998999999999995,"ソ2","G2"]
[24,103.82599999999999,"ソ#2","G#2"]
[25,110,"ラ2","A2"]
[26,116.541,"ラ#2","A#2"]
[27,123.471,"シ2","B2"]
[28,130.81299999999999,"ド3","C3"]
[29,138.59100000000001,"ド#3","C#3"]
[30,146.83199999999999,"レ3","D3"]
[31,155.56299999999999,"レ#3","D#3"]
[32,164.81399999999999,"ミ3","E3"]
[33,174.614,"ファ3","F3"]
[34,184.99700000000001,"ファ#3","F#3"]
[35,195.99799999999999,"ソ3","G3"]
[36,207.65199999999999,"ソ#3","G#3"]
[37,220,"ラ3","A3"]
[38,233.08199999999999,"ラ#3","A#3"]
[39,246.94200000000001,"シ3","B3"]
[40,261.62599999999998,"ド4","C4"]
[41,277.18299999999999,"ド#4","C#4"]
[42,293.66500000000002,"レ4","D4"]
[43,311.12700000000001,"レ#4","D#4"]
[44,329.62799999999999,"ミ4","E4"]
[45,349.22800000000001,"ファ4","F4"]
[46,369.99400000000003,"ファ#4","F#4"]
[47,391.995,"ソ4","G4"]
[48,415.30500000000001,"ソ#4","G#4"]
[49,440,"ラ4","A4"]
[50,466.16399999999999,"ラ#4","A#4"]
[51,493.88299999999998,"シ4","B4"]
[52,523.25099999999998,"ド5","C5"]
[53,554.36500000000001,"ド#5","C#5"]
[54,587.33000000000004,"レ5","D5"]
[55,622.25400000000002,"レ#5","D#5"]
[56,659.255,"ミ5","E5"]
[57,698.45600000000002,"ファ5","F5"]
[58,739.98900000000003,"ファ#5","F#5"]
[59,783.99099999999999,"ソ5","G5"]
[60,830.60900000000004,"ソ#5","G#5"]
[61,880,"ラ5","A5"]
[62,932.32799999999997,"ラ#5","A#5"]
[63,987.76700000000005,"シ5","B5"]
[64,1046.502,"ド6","C6"]
[65,1108.731,"ド#6","C#6"]
[66,1174.6590000000001,"レ6","D6"]
[67,1244.508,"レ#6","D#6"]
[68,1318.51,"ミ6","E6"]
[69,1396.913,"ファ6","F6"]
[70,1479.9780000000001,"ファ#6","F#6"]
[71,1567.982,"ソ6","G6"]
[72,1661.2190000000001,"ソ#6","G#6"]
[73,1760,"ラ6","A6"]
[74,1864.655,"ラ#6","A#6"]
[75,1975.5329999999999,"シ6","B6"]
[76,2093.0050000000001,"ド7","C7"]
[77,2217.4609999999998,"ド#7","C#7"]
[78,2349.3180000000002,"レ7","D7"]
[79,2489.0160000000001,"レ#7","D#7"]
[80,2637.02,"ミ7","E7"]
[81,2793.826,"ファ7","F7"]
[82,2959.9549999999999,"ファ#7","F#7"]
[83,3135.9630000000002,"ソ7","G7"]
[84,3322.4380000000001,"ソ#7","G#7"]
[85,3520,"ラ7","A7"]
[86,3729.31,"ラ#7","A#7"]
[87,3951.0659999999998,"シ7","B7"]
[88,4186.009,"ド8","C8"]
[]
["※音階名は国際式音名表記です。"]
[]
["人間が聞くことが出来る周波数は、個人差や年齢差はありますが20Hz～20000Hzと言われています。"]
["聴力は年齢を重ねるとともに衰えていき、とくに高い周波数の音が聞こえづらくなっていき、15000Hz以上の音は２０代後半ごろよりだんだん聞こえなくなるようです。"]
["下記の周波数音も、どのように聞こえるかお試しください。"]
[]
["5000Hzを聴く　"]
[]
["　 10000Hzを聴く　　 15000Hzを聴く　　 20000Hzを聴く　"]
[]
["h51602"]
[]
["｜鍵盤｜譜面｜１１２鍵｜音階｜ サイトマップ｜ホーム｜"]