{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Manual","Merge","Edit","List"],"not_rendered":{"charts":0,"images":21,"macros":1,"external_links":0,"defined_names":4,"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":"Manual","index":0,"n_rows":253,"n_cols":49,"rows_kept":253,"cut":false,"hidden":false,"merged":[[1,40,1,44],[1,46,1,53],[61,35,61,36],[0,0,1,18],[1,19,1,25],[1,27,1,32],[1,34,1,38],[61,25,61,26],[61,27,61,28],[61,29,61,30],[61,31,61,32],[61,33,61,34],[78,23,78,24],[78,25,78,28],[62,35,62,36],[63,23,63,24],[63,25,63,28],[63,29,63,32],[63,33,63,36],[62,23,62,24],[62,25,62,26],[62,27,62,28],[62,29,62,30],[62,31,62,32],[62,33,62,34],[76,35,76,36],[77,23,77,24],[77,25,77,26],[77,27,77,28],[77,29,77,30],[77,31,77,32],[77,33,77,34],[77,35,77,36],[76,25,76,26],[76,27,76,28],[76,29,76,30],[76,31,76,32],[76,33,76,34],[78,29,78,32],[78,33,78,36],[102,46,102,48],[105,46,105,48],[106,46,106,48],[103,46,103,48],[107,46,107,48],[108,46,108,48],[110,46,110,48],[215,46,215,48],[217,46,217,48],[113,6,113,20],[219,5,219,17],[114,6,114,19],[115,6,115,19],[209,46,209,48],[210,46,210,48],[212,46,212,48],[214,46,214,48]]}
["■付録.  CSMA マニュアル"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"■本ツール機能について",null,null,null,null,null,null,null,"■Mergeシート説明",null,null,null,null,null,null,"■Editシート説明",null,null,null,null,null,"■Listシート説明",null,null,null,null,null,"※右クリック機能の使用手順"]
[]
[null,"■本ツール機能について"]
[]
[null,null,"本ツールには、「Merge（表の結合）機能」 と 「Edit（セルの編集）機能」 がある"]
[]
[null,null,"機能イメージ"]
[]
[null,null,"Merge機能",null,null,null,null,"複数の表を1つの表にマージする。\n\nマージ元となる表は、複数のファイルから選出することも可能。"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Edit機能",null,null,null,null,"単純転記機能、記号変更機能、数値変換機能がある。（以下）"]
[null,null,null,null,null,null,null,null,"単純転記：インプットのセルから、アウトプットのセルへ、転記"]
[null,null,null,null,null,null,null,null,"記号変換：ツール内のListシートの設定を元に、数値から記号へ変換してアウトプットのセルに出力"]
[null,null,null,null,null,null,null,null,"数値変換：ツール内のListシートの設定を元に、数値を丸めアウトプットのセルに出力"]
[null,null,null,"1.単純転記"]
[]
[null,null,null,null,"Input",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Output"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"2.記号変換"]
[]
[null,null,null,null,"Input",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Output"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"変換条件例"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"上限",null,"下限",null,"上限",null,"下限",null,"上限",null,"下限"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"条件",null,12,null,9,null,8,null,5,null,4,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"変換",null,"☀",null,null,null,"☁",null,null,null,"☂"]
[]
[null,null,null,"3.数値変換"]
[]
[null,null,null,null,"Input",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Output"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"変換条件例"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"上限",null,"下限",null,"上限",null,"下限",null,"上限",null,"下限"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"条件",null,10,null,6,null,5,null,0,null,-1,null,-5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"変換",null,10,null,null,null,5,null,null,null,0]
[]
[]
[null,"■Mergeシート説明"]
[]
[null,null,"ボタンについて"]
[null,null,null,null,null,null,"Merge！：","シート内設定されたパラメータをインプットとし、アウトプットに表形式でマージする"]
[]
[null,null,"各パラメータについて"]
[]
[null,null,null,"Input",null,null,null,"①",null,null,null,null,null,null,null,"フォルダパス(絶対パス)",null,null,"マージ元ファイルの絶対パスを指定(フォルダパス)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"※ 右クリック機能あり"]
[null,null,null,null,null,null,null,"②",null,null,null,null,null,null,null,"ファイル名",null,null,"マージ元ファイルのファイル名を指定",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"※ 右クリック機能あり"]
[null,null,null,null,null,null,null,"③",null,null,null,null,null,null,null,"シート名",null,null,"マージ元の対象の表があるシートを指定"]
[null,null,null,null,null,null,null,"④",null,null,null,null,null,null,null,"Input範囲(開始)",null,null,"マージ対象の表の左上セルを指定",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"※ 右クリック機能あり"]
[null,null,null,null,null,null,null,"⑤",null,null,null,null,null,null,null,"Input範囲(終了)",null,null,"マージ対象の表の右下セルを指定",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"※ 右クリック機能あり"]
[null,null,null,"Output",null,null,null,"⑥",null,null,null,null,null,null,null,"フォルダパス(絶対パス)",null,null,"マージ先ファイルの絶対パスを指定(フォルダパス)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"※ 右クリック機能あり"]
[null,null,null,null,null,null,null,"⑦",null,null,null,null,null,null,null,"ファイル名",null,null,"マージ先ファイルのファイル名を指定",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"※ 右クリック機能あり"]
[null,null,null,null,null,null,null,"⑧",null,null,null,null,null,null,null,"シート名",null,null,"マージ先の対象のシートを指定"]
[null,null,null,null,null,null,null,"⑨",null,null,null,null,null,null,null,"Outputセル",null,null,"マージ先の基点となるセルを指定(左上)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"※ 右クリック機能あり"]
[]
[null,null,null,"※各セルを右クリックすることで簡易入力が可能"]
[null,null,null,null,"右クリック機能について"]
[null,null,null,null,null,"右クリック機能を使用するには、以下条件が存在する"]
[]
[null,null,null,"Input",null,null,null,"①",null,null,null,null,null,null,null,"フォルダパス(絶対パス)",null,null,"条件なし（常に使用可能）",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"使用手順"]
[null,null,null,null,null,null,null,"②",null,null,null,null,null,null,null,"ファイル名",null,null,"フォルダパス（絶対パス）（①）が入力されていること",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"使用手順"]
[null,null,null,null,null,null,null,"③",null,null,null,null,null,null,null,"シート名"]
[null,null,null,null,null,null,null,"④",null,null,null,null,null,null,null,"Input範囲(開始)",null,null,"フォルダパス（絶対パス）（①）、ファイル名（②）、シート名（③）が入力されていること",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"使用手順"]
[null,null,null,null,null,null,null,"⑤",null,null,null,null,null,null,null,"Input範囲(終了)",null,null,"フォルダパス（絶対パス）（①）、ファイル名（②）、シート名（③）が入力されていること",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"使用手順"]
[null,null,null,"Output",null,null,null,"⑥",null,null,null,null,null,null,null,"フォルダパス(絶対パス)",null,null,"条件なし（常に使用可能）",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"使用手順"]
[null,null,null,null,null,null,null,"⑦",null,null,null,null,null,null,null,"ファイル名",null,null,"フォルダパス（絶対パス）（⑥）が入力されていること",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"使用手順"]
[null,null,null,null,null,null,null,"⑧",null,null,null,null,null,null,null,"シート名"]
[null,null,null,null,null,null,null,"⑨",null,null,null,null,null,null,null,"Outputセル",null,null,"フォルダパス（絶対パス）（⑥）、ファイル名（⑦）、シート名（⑧）が入力されていること",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"使用手順"]
[]
[null,null,null,null,null,"右クリック機能の使用手順"]
[null,null,null,null,null,null,"ⅰ.フォルダパス（絶対パス）（①、⑥）設定手順"]
[null,null,null,null,null,null,"ⅱ.ファイル名（②、⑦）設定手順"]
[null,null,null,null,null,null,"ⅲ.セル、範囲（④、⑤、⑨）設定手順"]
[]
[null,null,null,null,null,null,"（以下詳細）"]
[null,null,null,null,null,null,"ⅰ.フォルダパス（絶対パス）（①、⑥）設定手順"]
[null,null,null,null,null,null,null,null,"右クリック押下で、フォルダ選択のダイアログが表示されるので、"]
[null,null,null,null,null,null,null,null,"対象フォルダを選択し、OKボタンを押下"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"OKボタンを押下することで、パスが入力される"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"ⅱ.ファイル名（②、⑦）設定手順"]
[null,null,null,null,null,null,null,null,"右クリック押下でファイル選択ダイアログが表示されるので、"]
[null,null,null,null,null,null,null,null,"対象ファイルを選択し、開くボタンを押下"]
[null,null,null,null,null,null,null,null,null,"※ ダイアログは①、⑥で指定したフォルダが表示される"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"開くボタンを押下することで、ファイル名が入力される"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"ⅲ.セル、範囲（④、⑤、⑨）設定手順"]
[null,null,null,null,null,null,null,null,"右クリック押下で指定したファイルの対象シートが開かれるので、"]
[null,null,null,null,null,null,null,null,"設定したいセルを選択し、OKボタンを押下"]
[]
[null,null,null,null,null,null,null,null,"セルを選択することで、入力ダイアログにセル名が入力される"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"OKボタン押下することで、指定したセル名が入力される"]
[null,null,null,null,null,null,null,null,null,"※ 入力されるセル名は「$」なしに自動変換される"]
[]
[]
[]
[]
[null,"■Editシート説明"]
[]
[null,null,"ボタンについて"]
[null,null,null,null,null,null,"Edit！：","シート内に設定されたパラメータをインプットとし、転記・記号変換・数値変換処理を行う"]
[]
[null,null,"各パラメータについて"]
[]
[null,null,null,"Input",null,null,null,"①",null,null,null,null,null,null,null,"フォルダパス(絶対パス)",null,null,"インプット元ファイルの絶対パスを指定(フォルダパス)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"※ 右クリック機能あり"]
[null,null,null,null,null,null,null,"②",null,null,null,null,null,null,null,"ファイル名",null,null,"インプット元ファイルのファイル名を指定",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"※ 右クリック機能あり"]
[null,null,null,null,null,null,null,"③",null,null,null,null,null,null,null,"シート名",null,null,"インプット元のセルがあるシートを指定"]
[null,null,null,null,null,null,null,"④",null,null,null,null,null,null,null,"Inputセル",null,null,"インプット対象セル",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"※ 右クリック機能あり"]
[null,null,null,null,null,null,"編集タイプ：","⑤",null,"インプットに対する処理を以下から選択"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"単純転記",null,null,null,null,"インプットの値をそのままアウトプットに転記する"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"記号変換",null,null,null,null,"インプットに対し、Listシートに設定された記号に変換を行う（数値範囲 ⇒ 記号）"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"数値変換",null,null,null,null,"インプットに対し、Listシートに設定さえた値に変換を行う（数値範囲 ⇒ 数値）"]
[null,null,null,"Output",null,null,null,"⑥",null,null,null,null,null,null,null,"フォルダパス(絶対パス)",null,null,"アウトプット先ファイルの絶対パスを指定(フォルダパス)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"※ 右クリック機能あり"]
[null,null,null,null,null,null,null,"⑦",null,null,null,null,null,null,null,"ファイル名",null,null,"アウトプット先ファイルのファイル名を指定",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"※ 右クリック機能あり"]
[null,null,null,null,null,null,null,"⑧",null,null,null,null,null,null,null,"シート名",null,null,"アウトプット先のセルがあるシートを指定"]
[null,null,null,null,null,null,null,"⑨",null,null,null,null,null,null,null,"Outputセル",null,null,"アウトプット対象セル",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"※ 右クリック機能あり"]
[]
[null,null,null,"※各セルを右クリックすることで簡易入力が可能"]
[null,null,null,null,"右クリック機能について"]
[null,null,null,null,null,"右クリック機能を使用するには、以下条件が存在する"]
[]
[null,null,null,"Input",null,null,null,"①",null,null,null,null,null,null,null,"フォルダパス(絶対パス)",null,null,"条件なし（常に使用可能）",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"使用手順"]
[null,null,null,null,null,null,null,"②",null,null,null,null,null,null,null,"ファイル名",null,null,"フォルダパス（絶対パス）（①）が入力されていること",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"使用手順"]
[null,null,null,null,null,null,null,"③",null,null,null,null,null,null,null,"シート名"]
[null,null,null,null,null,null,null,"④",null,null,null,null,null,null,null,"Inputセル",null,null,"フォルダパス（絶対パス）（①）、ファイル名（②）、シート名（③）が入力されていること",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"使用手順"]
[null,null,null,null,null,null,"編集タイプ：","⑤"]
[null,null,null,"Output",null,null,null,"⑥",null,null,null,null,null,null,null,"フォルダパス(絶対パス)",null,null,"条件なし（常に使用可能）",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"使用手順"]
[null,null,null,null,null,null,null,"⑦",null,null,null,null,null,null,null,"ファイル名",null,null,"フォルダパス（絶対パス）（⑥）が入力されていること",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"使用手順"]
[null,null,null,null,null,null,null,"⑧",null,null,null,null,null,null,null,"シート名"]
[null,null,null,null,null,null,null,"⑨",null,null,null,null,null,null,null,"Outputセル",null,null,"フォルダパス（絶対パス）（⑥）、ファイル名（⑦）、シート名（⑧）が入力されていること",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"使用手順"]
[]
[null,null,null,null,null,"(右クリック機能の使用手順は上記に記載)"]
[]
[null,"■Listシート説明"]
[]
[null,null,"記号変換条件について"]
[null,null,null,"※ 設定条件"]
[null,null,null,null,"・最大10個の条件が設定可能"]
[null,null,null,null,"・条件は左詰めで設定"]
[null,null,null,null,"・Inputは数値のみ"]
[null,null,null,null,"・各条件には上限と下限を設定（設定しなかった場合、正常に処理が完了しない可能性あり）"]
[]
[null,null,null,"（設定例）"]
[]
[]
[]
[]
[]
[null,null,null,"※ 設定条件やInputに異常がある場合は、Outputセルに 「#Error(Symbol Convesion)」 を記載"]
[]
[]
[null,null,"数値変換条件について"]
[null,null,null,"※ 設定条件"]
[null,null,null,null,"・最大10個の条件が設定可能"]
[null,null,null,null,"・条件は左詰めで設定"]
[null,null,null,null,"・Inputは数値のみ"]
[null,null,null,null,"・各条件には上限と下限を設定（設定しなかった場合、正常に処理が完了しない可能性あり）"]
[]
[null,null,null,"（設定例）"]
[]
[]
[]
[]
[]
[null,null,null,"※ 設定条件やInputに異常がある場合は、Outputセルに 「#Error(Nomber Round)」 を記載"]

{"sheet":"Merge","index":1,"n_rows":7,"n_cols":11,"rows_kept":7,"cut":false,"hidden":false,"merged":[[4,2,4,6],[4,7,4,10],[5,5,5,6]]}
[]
[]
[null,null,null,"色付きセルは右クリックで簡易的に値セット可能。"]
[]
[null,null,"Input",null,null,null,null,"Output"]
[null,null,null,null,null,"Input範囲"]
[null,null,"フォルダパス(絶対パス）","ファイル名","シート名","開始","終了","フォルダパス（絶対パス）","ファイル名","シート名","Outputセル"]

{"sheet":"Edit","index":2,"n_rows":6,"n_cols":11,"rows_kept":6,"cut":false,"hidden":false,"merged":[[4,2,4,5],[4,7,4,10]]}
[null,null,null,null,null,null,"単純転記"]
[null,null,null,null,null,null,"記号変換"]
[null,null,null,"色付きセルは右クリックで簡易的に値セット可能。",null,null,"数値変換"]
[]
[null,null,"Input",null,null,null,null,"Output"]
[null,null,"フォルダパス(絶対パス）","ファイル名","シート名","Inputセル","編集タイプ","フォルダパス（絶対パス）","ファイル名","シート名","Outputセル"]

{"sheet":"List","index":3,"n_rows":13,"n_cols":24,"rows_kept":13,"cut":false,"hidden":false,"merged":[[6,16,6,17],[6,18,6,19],[6,20,6,21],[6,22,6,23],[12,14,12,15],[12,16,12,17],[12,18,12,19],[12,20,12,21],[12,22,12,23],[6,14,6,15],[12,4,12,5],[12,6,12,7],[12,8,12,9],[12,10,12,11],[12,12,12,13],[6,4,6,5],[6,6,6,7],[6,8,6,9],[6,10,6,11],[6,12,6,13]]}
["■List"]
[null,null,null,"※ 各条件は左詰めで設定"]
[]
[null,"■記号変換"]
[null,null,null,null,"上限","下限","上限","下限","上限","下限","上限","下限","上限","下限","上限","下限","上限","下限","上限","下限","上限","下限","上限","下限"]
[null,null,null,"条件"]
[null,null,null,"変換"]
[]
[]
[null,"■数値変換"]
[null,null,null,null,"上限","下限","上限","下限","上限","下限","上限","下限","上限","下限","上限","下限","上限","下限","上限","下限","上限","下限","上限","下限"]
[null,null,null,"条件"]
[null,null,null,"変換"]