{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["main","main2","pdata","pdata2"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":6,"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":"main","index":0,"n_rows":52,"n_cols":11,"rows_kept":52,"cut":false,"hidden":false,"merged":[]}
["入力規則の例（データの範囲の制限）"]
[null,null,null,"入力値の種類","データ","最小値","最大値",null,"入力時のメッセージ","エラーメッセージ","日本語入力"]
["手動設定",null,null,"整数値","次の値の間",0,10,null,"データを入力してください（整数　0～10）","入力されたデータの値が範囲外です","コントロールなし"]
[]
[null,null,null,"整数値",null,0,10,null,"データを入力してください","入力されたデータは範囲外です","コントロールなし"]
[]
[]
["（標準モジュール）マクロ名：inputc1　　解除ﾏｸﾛ：clr1"]
["入力規則の例（リスト選択）"]
[null,null,null,"入力値の種類","データ",null,null,null,"入力時のメッセージ","エラーメッセージ"]
["手動設定","岩手県",null,"リスト","”=pdata!R2C1:R9C1”"]
[]
[null,null,null,"リスト","”=pdata!R2C2:R5C2”　レンジ設定でも",null,null,null,"選択してください"]
[null,null,null,null,"\"=くだもの\"   名前での設定でもどちらも可能",null,null,null,"選択してください"]
[null,null,null,null,"(名前を使う場合はあらかじめ範囲の名前の設定が必要）"]
["（標準モジュール）マクロ名：inputc3　　解除ﾏｸﾛ：clr3",null,null,null,"[数式]->[名前の定義]->",null,"名前:”くだもの”　範囲:\"=pdata!R2C2:R5C2\""]
["入力規則の例（日付データの範囲の制限）"]
[null,null,null,"入力値の種類","データ","最小値","最大値",null,"入力時のメッセージ","エラーメッセージ"]
["手動設定",null,null,"日付","次の値の間","2021-01-01","2021-12-31",null,"データを入力してください（日付　20**/**/**）","入力されたデータの値が範囲外です"]
[]
[null,null,null,"日付","次の値の間","2021-01-01","2021-12-31",null,"データを入力してください（日付　20**/**/**）","入力されたデータの値が範囲外です"]
[]
[]
["（標準モジュール）マクロ名：inputc5　　解除ﾏｸﾛ：clr5"]
["入力規則の例（リスト選択:2階層）名前の利用",null,null,"1階層目の値によって2階層目に表示される項目が変わります"]
[null,"1階層目","2階層目",null,"1階層目","2階層目"]
["手動設定","もも","なつっこ","リスト","\"=くだもの\" ","”=INDIRECT(R27C2)”",null,"2階層目の参照元は1階層目の入力欄を参照（名前）"]
[null,null,null,null,"（あらかじめ名前の設定をする：「数式」->[名前の定義]->名前と参照範囲を設定する））"]
[null,null,null,null,"1階層目","名前：'\"=くだもの\" ",null,"範囲：”=pdata!R2C2:R5C2”"]
[null,null,null,null,"2階層目","名前：'\"=りんご\" ",null,"範囲：”=pdata!R2C3:R2C8”"]
[null,null,null,null,null,"名前：'\"=もも\" ",null,"範囲：”=pdata!R3C3:R3C7”"]
[null,null,null,null,null,"名前：'\"=すいか\" ",null,"範囲：”=pdata!R4C3:R4C6”"]
[null,null,null,null,null,"名前：'\"=ぶどう\" ",null,"範囲：”=pdata!R5C3:R5C9”"]
["（名前の利用）"]
[null,"もも","あかつき",null,"\"=くだもの\" ","call getnt(サブルーチン呼び出し）"]
[null,null,null,null,null,"1階層目が変化した場合に、getntを実行"]
[null,null,null,null,null,"getnt（1階層の内容を展開して、コンマ区切りの文字列に変換して、それをもとに2階層目の文字列規則を設定）"]
["（標準モジュール）マクロ名：inputc7　　解除ﾏｸﾛ：clr7",null,null,null,null,"（例）"]
["（シートモジュール）gentnt",null,null,null,null,"1階層目　「りんご」"]
[null,null,null,null,null,"「リンゴ」の名前の内容"]
[null,null,null,null,null,"ふじ　トキ　紅玉　世界一　ジョナゴールド　陸奥"]
[null,null,null,null,null,"2階層目入力規則設定用文字列：\"ふじ,トキ,紅玉,世界一,ジョナゴールド,陸奥\""]
["入力規則の例（リスト選択:2階層）範囲の利用",null,null,"1階層目の値によって2階層目に表示される項目が変わります"]
[null,null,null,null,"1階層目",null,"2階層目"]
[null,null,null,null,"”=pdata!R2C2:R5C2”",null,"”=pdata!R2C3:R2C8”"]
[null,null,null,null,"（くだものの範囲）",null,"（例：りんごの範囲　自動設定）"]
[null,null,null,null,null,"1階層目が変化した場合に、getnt2を実行"]
["（標準モジュール）マクロ名：inputc9　　解除ﾏｸﾛ：clr9",null,null,null,null,"getnt2（1階層の内容を検索して対応する、2階層目のデータの範囲を算出し。入力規則に設定する）"]
["（シートモジュール）gentnt2",null,null,null,null,"(例）"]
[null,null,null,null,null,"1階層目　「りんご」",null,null,"”=pdata!R2C2:R5C2”"]
[null,null,null,null,null,"「リンゴ」の2階層目の属性範囲",null,null,"”=pdata!R2C3:R2C8”"]
[null,null,null,null,null,"findメソッドで検索し、該当エリアを算出"]

{"sheet":"main2","index":1,"n_rows":31,"n_cols":5,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
["入力規則の例（リスト選択:3階層）",null,null,null,"固定入力欄"]
[null,"1階層目","2階層目","3階層目"]
[null,"品名","品種","産地"]
[]
[]
[]
["（標準モジュール）マクロ名：Sub getnt3（1階層目）　getit1（2階層目） 　getit2（3階層目）　解除ﾏｸﾛ：clr10"]
["（シートモジュール） Worksheet_Changeアクション",null,null,null,"Call getit1      Call getit2"]
[]
[]
["入力規則の例（リスト選択:3階層）",null,null,null,"マトリックス表入力"]
[null,"1階層目","2階層目","3階層目"]
["日付","品名","品種","産地"]
["2021-12-01","もも","あかつき","福島"]
["2021-12-02","すいか","タヒチ","熊本"]
["2021-12-03","ぶどう","アレキサンドリア","長野"]
["2021-12-04","りんご","トキ","岩手"]
["2021-12-05","りんご","紅玉","長野"]
["2021-12-06","りんご","ジョナゴールド","北海道"]
["2021-12-07","もも","白鳳","福島"]
["2021-12-08","すいか","縞王","千葉"]
["2021-12-09","もも","なつっこ","山形"]
["2021-12-10","ぶどう","シャインマスカット","山梨"]
["2021-12-11","すいか","縞王","山形"]
[]
[]
[]
[]
[]
["（標準モジュール）マクロ名：Sub getnt4（1階層目）　pgetit1（2階層目） 　pgetit2（3階層目）　解除ﾏｸﾛ：clr11"]
["（シートモジュール） Worksheet_Changeアクション",null,null,null,"Call pgetit1      Call pgetit2"]

{"sheet":"pdata","index":2,"n_rows":9,"n_cols":9,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["データ1","データ2-1","データ2-2","データ2-3","データ2-4","データ2-5","データ2-6","データ2-7","データ2-8"]
["北海道","りんご","ふじ","トキ","紅玉","世界一","ジョナゴールド","陸奥"]
["青森県","もも","ちよひめ","白鳳","あかつき","なつっこ","ゆうぞら"]
["岩手県","すいか","祭ばやし","縞王","味きらら","タヒチ"]
["宮城県","ぶどう","巨峰","デラウエア","ピオーネ","シャインマスカット","アレキサンドリア","キングデラ","ナガノパープル"]
["秋田県"]
["山形県"]
["福島県"]
["茨城県"]

{"sheet":"pdata2","index":3,"n_rows":23,"n_cols":7,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["1階層目（名前）","2階層目（品種名）","3階層目（産地）ダミーデータ"]
["りんご","ふじ","青森","山形","長野"]
[null,"トキ","福島","秋田","岩手","群馬"]
[null,"紅玉","青森","長野"]
[null,"世界一","群馬","山形","岩手"]
[null,"ジョナゴールド","北海道","福島"]
[null,"陸奥","青森","岩手","長野","山形"]
["もも","ちよひめ","山梨","福島","長野"]
[null,"白鳳","和歌山","福島"]
[null,"あかつき","秋田","長野","福島","新潟"]
[null,"なつっこ","福島","山形"]
[null,"ゆうぞら","長野","福島","山梨","山形"]
["すいか","祭ばやし","熊本","山形","千葉"]
[null,"縞王","山形","千葉"]
[null,"味きらら","熊本","千葉","山形"]
[null,"タヒチ","鳥取","新潟","熊本"]
["ぶどう","巨峰","山梨","山形","福岡","岡山"]
[null,"デラウエア","長野","山梨"]
[null,"ピオーネ","岡山","山梨","長野","福岡","北海道"]
[null,"シャインマスカット","岡山","山梨","長野"]
[null,"アレキサンドリア","山形","福岡","長野","山梨"]
[null,"キングデラ","福岡","山梨"]
[null,"ナガノパープル","長野","山形","岡山"]