{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["圧縮","使い方"],"not_rendered":{"charts":0,"images":0,"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":16,"n_cols":10,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[null,null,null,{"$f":"ROUND(A1,-INT(LOG($G$12)))","v":{"$error":"#NUM!"}},null,"元データ情報",null,null,"X","Y"]
[null,null,null,null,null,"X最小値",{"$f":"MIN(A:A)","v":0},null,{"$f":"G10","v":0},{"$f":"IFERROR(SUMIF(D:D,I2,B:B)/COUNTIF(D:D,I2),0)","v":0}]
[null,null,null,null,null,"X最大値",{"$f":"MAX(A:A)","v":0},null,{"$f":"I2+$G$12","v":0},{"$f":"IFERROR(SUMIF(D:D,I3,B:B)/COUNTIF(D:D,I3),0)","v":0}]
[null,null,null,null,null,"データ開始行",{"$f":"MATCH(G2,A:A,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,"データ終了行",{"$f":"MATCH(G3,A:A,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,"データ数",{"$f":"COUNT(A:A)","v":0}]
[]
[]
[null,null,null,null,null,"集計条件"]
[null,null,null,null,null,"X開始値"]
[null,null,null,null,null,"X終了値"]
[null,null,null,null,null,"刻み幅"]
[null,null,null,null,null,null,{"$f":"-INT(LOG(G12))","v":{"$error":"#NUM!"}}]
[null,null,null,null,null,"集計データ数",{"$f":"(G11-G10)/G12+1","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,"集計開始行",2]
[null,null,null,null,null,"集計終了行",{"$f":"(G11-G10)/G12+2","v":{"$error":"#DIV/0!"}}]

{"sheet":"使い方","index":1,"n_rows":16,"n_cols":3,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[1,null,"白抜きのセルのみ変更可"]
[2,null,"クロマト/スペクトルのXデータをA列に、YデータをB列にコピー、1行目のタイトルは不要"]
[3,null,"X開始値、X終了値、刻み幅を入力"]
[4,null,"[計算]ボタンをクリック"]
[5,null,"J列を集計ファイルに値コピー"]
[]
[null,null,"本シートはマクロ使用を前提とする。マクロが使えない場合は、手動で次の操作をする。"]
[6,null,"D1セルの数式をD2以下の列にコピー。最終行はB列の最終行と同じ"]
[7,null,"I3:J3セルの関数を下にコピー。最終行は集計終了行"]
[]
[null,null,"本シートで行っていること：D列にA列のデータを刻み幅で丸めた数値に変換"]
[null,null,"D列の同じ数字の平均をJ列に記入"]
[]
[null,"※","グラフ/スペクトルのテキストデータはデータ数が数万個になる場合がある。このようなデータは計算に間がかかる。"]
[null,null,"Excelでのグラフ化、定量ではデータ数は数千個で十分な精度を持つ"]
[null,null,"数万のデータを数千に圧縮することで必要な精度を維持したまま、Excelでの処理が早くなる。"]