{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["新規入会申込明細","更新申込明細","更新申込明細 (原本)","設定","入力欄説明","旧レイアウトデータ取込","TODO"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":1,"defined_names":145,"comments":2,"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":9,"n_cols":27,"rows_kept":9,"cut":false,"hidden":false,"merged":[[2,6,2,7],[3,0,3,3],[5,1,5,2],[6,1,6,2],[0,0,0,1],[1,0,2,0],[1,1,2,3]]}
[]
[2027,"IKI・IKIライフクラブ\n新規入会申込書"]
[null,null,null,null,{"$f":"設定!F22","v":"(基本申込用紙)"},null,"お申込内容の集計"]
[{"$f":"IF(A2=\"\",\"\",\"【年度の期間　\"& A2-1&\"/07/01～\"&A2&\"/06/30】\")","v":"【年度の期間　2026/07/01～2027/06/30】"},null,null,null,{"$f":"\"(バージョン\"&設定!F26&\")\"","v":"(バージョン2.1.0)"},null,"■入会者数  ",{"$f":"COUNTA(C:C)-1","v":0}]
["　お問合せ：事務局 03-3288-3598",null,null,"申請書の送付先：ikiiki@uazensen.jp",null,null,"■入会金計",{"$f":"SUM(L:L)","v":0}]
["※組織コード[組合は数字10桁]","※組織名[全角]",null,"※申請日[数字8桁]","※お支払予定日[数字8桁]",null,"■年会費計",{"$f":"SUM(M:M)","v":0}]
[null,null,null,null,null,null,"■支払予定額",{"$f":"SUM(H5+H6)","v":0}]
[null,null,null,"2020-07-01","2021-06-30"]
["管理番号\n[半角英数20桁]","※姓\n","※名","※姓（ｶﾅ）\n","※名（ｶﾅ）\n","※性別\n[ﾘｽﾄ選択]","※生年月日\n[数字8桁]","※入会時資格区分\n[ﾘｽﾄ選択]","退職日\n[数字8桁]","※支払方法区分\n[ﾘｽﾄ選択]",{"$f":"IF(入会_入会年度_タイトル=\"\",\"年齢\",入会_入会年度_タイトル-1&\"/07/01 \"& CHAR(10) &\"時点年齢\")","v":"2026/07/01 \n時点年齢"},"入会金","初回年会費","合計額","会員資格\n有効期限","組合役員歴\n[ﾘｽﾄ選択]","※組合員歴(年)\n[数字2桁]","事業所・店舗名\n[全角15桁半角30桁]","※出身組合コード\n[組合は数字10桁]","※出身組合名\n[全角15桁半角30桁]","※郵便番号\n[数字7桁(ﾊｲﾌﾝ入力しない)]","※個人住所１\n都道府県・市区町村・町域・番地[全角20桁半角40桁]","個人住所２\n個人住所１に入りきらない場合[全角20桁半角40桁]","個人住所３\nビル名など[全角20桁半角40桁]","※日中連絡がつく\n電話番号[半角20桁]","メールアドレス\n[半角50桁]","活動希望県支部\n[ﾘｽﾄ選択]"]

{"sheet":"更新申込明細","index":1,"n_rows":9,"n_cols":27,"rows_kept":9,"cut":false,"hidden":true,"merged":[[5,1,5,2],[6,1,6,2],[0,0,0,1],[1,0,2,0],[1,1,2,3],[3,0,3,3]]}
[]
[2027,"IKI・IKIライフクラブ\n更新申込書",null,null,null,null,"お申込内容の集計"]
[null,null,null,null,null,null,"■更新予定者数  ",{"$f":"COUNTA(C:C)-1","v":0}]
[{"$f":"IF(A2=\"\",\"\",\"【年度の期間　\"& A2-1&\"/07/01～\"&A2&\"/06/30】\")","v":"【年度の期間　2026/07/01～2027/06/30】"},null,null,null,{"$f":"\"(バージョン\"&設定!F26&\")\"","v":"(バージョン2.1.0)"},null,"■更新回答者数",{"$f":"COUNTIF(L:L,支払方法区分_1)+COUNTIF(L:L,支払方法区分_2)","v":0}]
["　お問合せ：事務局 03-3288-3598",null,null,"申請書の送付先：ikiiki@uazensen.jp",null,null,"■支払：1年分",{"$f":"SUMIF(L:L,支払方法区分_1,M:M)","v":0}]
["組織コード","組織名",null,"※申請日[数字8桁]","※お支払予定日[数字8桁]",null,"■支払：65歳迄",{"$f":"SUMIF(L:L,支払方法区分_2,M:M)","v":0}]
[null,null,null,null,null,null,"■支払予定額",{"$f":"SUM(M:M)","v":0}]
[null,null,null,"2020-07-01","2021-06-30"]
["管理番号\n[半角英数20桁]","姓\n","名","姓（ｶﾅ）\n","名（ｶﾅ）\n","性別","生年月日\n","入会日",{"$f":"\"会員資格\"&CHAR(10)&\"有効期限\"","v":"会員資格\n有効期限"},"会員№",{"$f":"IF(A2=\"\",\"年齢\",A2-1&\"/07/01 \"& CHAR(10) &\"時点年齢\")","v":"2026/07/01 \n時点年齢"},"※更新区分\n[ﾘｽﾄ選択]","支払年会費\n",{"$f":"\"更新後\"&CHAR(10)&\"有効期限\"","v":"更新後\n有効期限"},"事業所・店舗名\n[全角15桁半角30桁]",{"$f":"\"郵便番号\"&CHAR(10)&\"[数字7桁(ﾊｲﾌﾝ入力しない)]\"","v":"郵便番号\n[数字7桁(ﾊｲﾌﾝ入力しない)]"},"個人住所１\n都道府県・市区町村・町域・番地[全角20桁半角40桁]","個人住所２\n個人住所１に入りきらない場合[全角20桁半角40桁]","個人住所３\nビル名など[全角20桁半角40桁]","日中連絡がつく\n電話番号[半角20桁]","メールアドレス\n[半角50桁]","活動希望県支部\n[ﾘｽﾄ選択]","出身組合コード\n","出身組合名\n","チェック結果","同一人物チェック","入会時\n資格区分"]

{"sheet":"更新申込明細 (原本)","index":2,"n_rows":9,"n_cols":24,"rows_kept":9,"cut":false,"hidden":true,"merged":[[5,1,5,2],[6,1,6,2],[1,4,2,4],[0,0,0,1],[1,0,2,0],[1,1,2,3],[3,0,3,3]]}
[]
[2027,"IKI・IKIライフクラブ\n更新手続申込書",null,null,"（原本）"]
[]
[{"$f":"IF(A2=\"\",\"\",\"【更新後資格有効期間　\"& A2-1&\"/07/01～\"&A2&\"/06/30】\")","v":"【更新後資格有効期間　2026/07/01～2027/06/30】"},null,null,null,{"$f":"\"(バージョン\"&設定!F26&\")\"","v":"(バージョン2.1.0)"}]
["　お問合せ：事務局 03-3288-3598",null,null,"申請書の送付先：ikiiki@uazensen.jp"]
["組織コード","組織名",null,"※申請日[数字8桁]","※お支払予定日[数字8桁]"]
[]
[null,null,null,"2020-07-01","2021-06-30"]
["管理番号\n[半角英数20桁]","姓\n","名","姓（ｶﾅ）\n","名（ｶﾅ）\n","性別","生年月日\n","入会日",{"$f":"\"会員資格\"&CHAR(10)&\"有効期限\"","v":"会員資格\n有効期限"},"会員№",{"$f":"IF(A2=\"\",\"年齢\",A2-1&\"/07/01 \"& CHAR(10) &\"時点年齢\")","v":"2026/07/01 \n時点年齢"},"※更新区分\n[ﾘｽﾄ選択]","支払年会費\n",{"$f":"\"更新後\"&CHAR(10)&\"有効期限\"","v":"更新後\n有効期限"},"事業所・店舗名\n[全角15桁半角30桁]",{"$f":"\"郵便番号\"&CHAR(10)&\"[数字7桁(ﾊｲﾌﾝ入力しない]\"","v":"郵便番号\n[数字7桁(ﾊｲﾌﾝ入力しない]"},"※個人住所１\n都道府県・市区町村・町域・番地[全角20桁半角40桁]","個人住所２\n個人住所１に入りきらない場合[全角20桁半角40桁]","個人住所３\nビル名など[全角20桁半角40桁]","※日中連絡がつく\n電話番号[半角20桁]","メールアドレス\n[半角50桁]","活動希望県支部\n[ﾘｽﾄ選択]","出身組合コード\n[組合は数字10桁]","出身組合名\n[全角15桁半角30桁]"]

{"sheet":"設定","index":3,"n_rows":72,"n_cols":12,"rows_kept":72,"cut":false,"hidden":true,"merged":[]}
["性別区分","男性",null,"年会費","年会費",500,null,"バージョン","リリース日","シート","内容","担当者"]
[null,"女性",null,null,"年会費支払免除年齢",65,null,"1.0.0","2020-09-15",null,"9/15リリース","佐藤"]
[null,"記載しない",null,null,"年齢算出基準日(入会)",null,null,"1.0.1","2020-09-16","設定","7/1時点65歳年会費0になるように修正","佐藤"]
[null,"男",null,null,"年齢算出基準日(更新)",null,null,null,null,"会員申込明細","年会費の表示不具合を修正"]
[null,"女",null,null,"年会費免除期間(一括時のみ）",-1,null,"1.0.2","2020-09-16","設定","7/1時点65歳年会費0になるように修正","佐藤"]
["組合役員歴区分","退任役員",null,null,"年会費免除期間(お待たせキャンペーン）",-1,null,null,null,"会員申込明細","年会費の表示不具合を修正"]
[null,"現役役員",null,null,"年会費免除年会費年数下限",2,null,"1.0.3","2020-09-25","設定","年会費支払免除年齢66→65","佐藤"]
[null,"役員歴なし",null,"入会金","組合員",1000,null,"1.0.4","2020-10-21","設定","選択肢の値の先頭数字を除去","佐藤"]
["入会時資格区分","組合員",null,null,"組合役員",1000,null,null,null,"会員申込明細","住所関係の列に「個人の」を追記"]
[null,"組合役員",null,null,"退職者",6000,null,null,null,"事務局用","印刷用シート「事務局用」を追加（財政局用）"]
[null,"退職者",null,null,"組織内・準組織内議員",6000,null,null,null,"会員申込明細","明細数減　50000→10000",1000]
[null,"組織内・準組織内議員",null,null,"現役元組合員",6000,null,"1.0.5","2020-10-26","会員申込明細","入会金を出すVLOOKUP引数不足によるバグ対応","佐藤"]
[null,"現役元組合員など",null,"特典","退職者お待たせキャンペーン値引き",-5000,null,"1.0.6","2020-11-23","会員申込基本情報","管理組合という表現は友の会での用語なため非表示","佐藤"]
["支払方法区分","①1年分",null,null,null,null,null,null,null,"会員申込基本情報","下記入力規則を追加","新井"]
[null,"②65歳まで一括",null,null,null,null,null,null,null,"会員申込明細","・日本語セルは日本語モードオン","新井"]
["↓更新時のみ表示","③退会（任意）",null,null,null,null,null,null,null,null,"・数字、英数字セルは日本語入力を無効","新井"]
[null,"④退会（死亡）",null,null,null,null,null,null,null,null,"・日付は本日基準で120年前から30年後の範囲外はエラー表示","新井"]
[null,"⑤異動・継続",null,"退職者お待たせキャンペーン","申請日期限","2022-06-30",null,null,null,null,"・選択項目は入力時にｴﾗｰ表示","新井"]
[null,"⑥未確認",null,null,"退職日　適用開始日","2018-09-01","　",null,null,null,"・郵便番号は数字7桁以外エラー表示（ハイフン付き自動変換）","新井"]
["会費支払区分","管理組合支払",null,null,"退職日　適用終了日","2020-09-14",null,null,null,null,"・電話番号は11-20桁以外はｴﾗｰ表示","新井"]
[null,"個人支払",null,null,null,null,null,null,null,null,"・年組合歴は数字1-100以外エラー表示","新井"]
["申請種別区分",1,null,"会員資格制限",{"$f":"A24","v":"入会申込種類区分"},"(基本申込用紙)",null,null,null,null,"・メルアドは＠なしと。なしはｴﾗｰ表示","新井"]
["1：入会/２：更新",2,null,null,"組合員歴（年）以下はNG",2,null,null,null,null,"・基本と明細の項目説明を丁寧いに","新井"]
["入会申込種類区分","(基本申込用紙)",null,null,null,null,null,null,null,"設定","設定シート年齢算出基準日の式修正。申請日未設定の場合、システム日から計算する。","佐藤"]
[null,"(全組合員申込用紙)",null,null,null,null,null,null,null,"会員申込明細","明細数減　10000→2000","佐藤"]
["県支部","北海道",null,"バージョン",null,{"$f":"INDEX(H:H,MAX(INDEX((LEN(H2:H10002)>0)*ROW(H2:H10002),0),1))","v":"2.1.0"},null,null,null,"会員申込明細","明細行を1行ずつ色付け","佐藤"]
[null,"青森県",null,null,null,null,null,null,null,"会員申込明細","参照式の切り取り対応","佐藤"]
[null,"岩手県",null,"会費支払","管理組合支払",null,null,"1.0.7","2020-11-30","会員申込基本情報","組合コードの10桁チェックは削除","佐藤"]
[null,"宮城県",null,null,null,null,null,null,null,"会員申込明細","組合コードの10桁チェックは削除/郵便番号の7桁チェックは削除","佐藤"]
[null,"秋田県",null,"申請種別区分",1,null,null,"1.0.8","2020-12-21","変更目的","64歳時加入の年会費0円→500円に仕様変更","佐藤"]
[null,"山形県",null,null,null,null,null,null,null,"設定","年会費免除年会費年数下限項目追加","佐藤"]
[null,"福島県",null,"申請行№",null,null,null,null,null,"会員申込明細","AI列（初回特典値引き）に会費免除期間を適用する年会費年数の下限条件を追加","佐藤"]
[null,"茨城県",null,null,null,null,null,"1.0.8","2021-02-07","事務局用","生年月日、退職日の参照先不具合修正","佐藤"]
[null,"栃木県",null,"制度改定日","2026年度制度改定","2025-07-01",null,null,null,"会員申込一覧","1万人、5万人版を作成","佐藤"]
[null,"群馬県",null,null,"2027年度制度改定","2026-07-01"]
[null,"埼玉県",null,null,null,null,null,"1.0.9","2021-05-04","会員申込基本情報","申請日、送金日未入力の場合、金額がエラーになるように変更","佐藤"]
[null,"千葉県",null,null,null,null,null,null,null,"設定","申請日、送金日未入力の場合のエラーメッセージを追加","佐藤"]
[null,"東京都"]
[null,"山梨県",null,null,null,null,null,"2.0.0","2021-09-27","新規入会申込明細","新規入会申込明細に変更","佐藤"]
[null,"神奈川県"]
[null,"新潟県"]
[null,"富山県",null,null,null,null,null,"2.0.1","2024-07-26","入力欄説明","入力欄説明を追加","佐藤"]
[null,"石川県"]
[null,"福井県"]
[null,"長野県",null,null,null,null,null,"2.0.2","2025-06-24","内部処理","新規入会時の年会費2年分扱いのキャンペーン終了に伴う変更","佐藤"]
[null,"岐阜県"]
[null,"静岡県"]
[null,"愛知県",null,null,null,null,null,"2.0.3","2025-07-02","内部処理","前回変更の対応漏れ対応","佐藤"]
[null,"三重県",null,null,null,null,null,null,null,null,"明細の有効期限が1年分の際に、キャンペーンを加味した2年分の表示になっていた。"]
[null,"滋賀県"]
[null,"京都府",null,null,null,null,null,"2.1.0","2026-06-15","内部処理","2027年度制度改定対応","野田"]
[null,"大阪府",null,null,null,null,null,null,null,null,"・2027年度以降に新規入会する「組合員」と「組合役員」について、"]
[null,"兵庫県",null,null,null,null,null,null,null,null,"　・65歳以上であっても年会費を発生させる"]
[null,"奈良県",null,null,null,null,null,null,null,null,"　・65歳以上であっても「永久会員」とせず、有効期限を表示する"]
[null,"和歌山県",null,null,null,null,null,null,null,null,"・2026年度以前を入力した場合、エラーとする処理を追加"]
[null,"鳥取県",null,null,null,null,null,null,null,null,"・65歳以上の会員が支払方法「65歳まで一括」を選択した場合エラーとする処理を追加"]
[null,"島根県"]
[null,"岡山県"]
[null,"広島県"]
[null,"山口県"]
[null,"徳島県"]
[null,"香川県"]
[null,"高知県"]
[null,"愛媛県"]
[null,"福岡県"]
[null,"佐賀県"]
[null,"長崎県"]
[null,"熊本県"]
[null,"大分県"]
[null,"宮崎県"]
[null,"鹿児島県"]
[null,"沖縄県"]

{"sheet":"入力欄説明","index":4,"n_rows":72,"n_cols":7,"rows_kept":72,"cut":false,"hidden":false,"merged":[[45,4,46,4],[47,4,48,4]]}
["１．申込書　固定表示部分の説明"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["№","名称","入力可否","入力必須","入力形式","説明","入力例"]
[1,"年度","○","○","半角数字4桁","入会を希望する年度を入力してください。会員となれる期間は【年度の期間】で確認ができます。","2023"]
[2,"申込種別","○","○","選択式","組合の加入種類に対応して、基本申込／組織一括申込のどちらかを選択してください。","基本申込"]
[3,"組織コード","○","○","半角英数字10桁","組合コード10桁を入力してください。\nゼンセン都道府県支部の場合「A7000」＋県支部コード前ゼロ5桁を入力してください。","0000100000（組合）\nA700013000（都道府県支部）"]
[4,"組織名","○","○","全角文字15桁","組織の名前を入力してください。","○○○○○○労働組合"]
[5,"申請日","○","○","半角数字8桁","IKI・IKIライフクラブ事務局に申請した日付を入力してください。","20220701"]
[6,"お支払予定日","○","○","半角数字8桁","入会金・年会費を送金する予定日を入力してください。","20220715"]
[7,"お申込内容の集計","×",null,"－","入会者数：明細表示部分に入力した会員数が表示されます。\n入会金計：会員の入会金の合計が表示されます。\n年会費計：会員の年会費の合計が表示されます。\n支払予定額：入会金計＋年会費計が表示されます（お支払いいただく金額です）","－"]
[8,"入力内容チェックボタン","×",null,"－","申込書の入力チェックを行います。","－"]
[9,"申込書保存ボタン","×",null,"－","申込書の保存を行います。","－"]
[]
["２．申込書　明細表示部分の説明"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["№","名称","入力可否","入力必須","入力形式","説明","入力例"]
[1,"管理番号","○","○","半角英数字20桁","組織で管理している社員番号や組合員番号を入力してください。","0000123"]
[2,"姓","○","○","全角文字9桁\n半角文字19桁","会員となる方の苗字を入力してください（外国籍の場合はファミリーネーム）","ゼンセン"]
[3,"名","○","○",null,"会員となる方の名前を入力してください（外国籍の場合はファーストネーム）","太郎"]
[4,"姓(ｶﾅ)","○","○","半角文字19桁","会員となる方の苗字を半角カナで入力してください（外国籍の場合はファミリーネーム）","ｾﾞﾝｾﾝ"]
[5,"名(ｶﾅ)","○","○",null,"会員となる方の名前を半角カナで入力してください（外国籍の場合はファーストネーム）","ﾀﾛｳ"]
[6,"性別","○","○","選択式","性別を選択してください。","男性"]
[7,"生年月日","○","○","半角数字8桁","生年月日を西暦8桁で入力してください。",19700401]
[8,"入会時資格区分","○","○","選択式","会員の入会時の資格を次の選択肢から選んでください。\n組合員\n組合役員\n退職者\n組織内・準組織内議員\n現役元組合員など","組合員"]
[9,"退職日","○",null,"半角数字8桁","入会時資格区分が「退職者」の場合、退職日を入力してください。","20221231"]
[10,"支払方法区分","○","○","選択式","年会費の支払方法を次の選択肢から選んでください。\n①1年分\n②65歳まで一括","②65歳まで一括"]
[11,"時点年齢","×",null,"－","入会期間の初日時点の年齢が表示されます。","－"]
["№","名称","入力可否","入力必須","入力形式","説明","入力例"]
[12,"入会金","×",null,"－","入会時の入会金が表示されます。","－"]
[13,"初回年会費","×",null,"－","入会時の初回年会費が表示されます。","－"]
[14,"合計額","×",null,"－","入会金＋初回年会費が表示されます。","－"]
[15,"会員資格有効期限","×",null,"－","年会費の有効期限（会員資格の期限）が表示されます。","－"]
[16,"組合役員歴","○",null,"選択式","組合役員の経験がある場合、次の選択肢から選んでください。\n省略時は「役員歴なし」の扱いとなります。\n退任役員\n現役役員\n役員歴なし","役員歴なし"]
[17,"組合員歴（年）","○",null,"半角数字2桁","組合員歴を入力してください。申込種別が「基本申込」の場合、2年未満はエラーとなります。","20"]
[18,"事業所・店舗名","○",null,"全角文字15桁","会員が務めている事業所・店舗名を入力してください。","△△△店"]
[19,"出身組合コード","○","○","半角英数字10桁","会員の出身組合を入力してください。","0000100000"]
[20,"出身組合名","○","○","全角文字15桁","会員の出身組合の名前を入力してください。","○○○○○○労働組合"]
[21,"郵便番号","○","○","半角数字7桁","会員の個人住所の郵便番号を入力してください。","1028273"]
[22,"個人住所１","○","○","全角文字20桁\n半角文字40桁","会員の個人住所（都道府県・市区町村・町域・番地）を入力してください。","東京都千代田区九段南 4-8-16"]
[23,"個人住所２","○",null,"全角文字20桁\n半角文字40桁","会員の個人住所（都道府県・市区町村・町域・番地）を個人住所１に入りきらない場合、入力してください。"]
[24,"個人住所３","○",null,"全角文字20桁\n半角文字40桁","会員の個人住所（ビル名など）を入力してください。"]
[25,"日中連絡がつく電話番号","○","○","半角英数字10桁","会員と日中連絡がつく電話番号を入力してください。","03-3288-3598"]
[26,"メールアドレス","○",null,"半角英数字50桁","会員のメールアドレスを入力してください。"]
[27,"活動希望県支部","○",null,"選択式","会員がIKI・IKIライフクラブのイベントに参加する場合、連絡させていただく\nUAゼンセンの都道府県支部を選択してください。","東京都"]

{"sheet":"旧レイアウトデータ取込","index":5,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[[1,1,2,9]]}

{"sheet":"TODO","index":6,"n_rows":58,"n_cols":4,"rows_kept":58,"cut":false,"hidden":true,"merged":[]}
["№","シート","内容","回答"]
[{"$f":"ROW()-1","v":1},"共通","EXCEL起動時にシート保護をかける","不要：呼び出しPG側で実装"]
[{"$f":"ROW()-1","v":2},"共通","EXCEL起動時に設定の申請種別区分で表示シートを設定する","済"]
[3,"共通","EXCEL起動時に申請区分：新規の場合、システム日付から申請年度を初期入力する","済"]
[4,"新規入会申込明細","条件付き書式　必須入力セルが未入力の場合、背景色をピンクにする","済"]
[5,"更新申込明細","条件付き書式　必須入力セルが未入力の場合、背景色をピンクにする","済"]
[6,"新規入会申込明細","説明追加　色がピンクのセルに入力を促すような説明文を表示","済"]
[7,"更新申込明細","説明追加　色がピンクのセルに入力を促すような説明文を表示","済"]
[8,"新規入会申込明細","説明追加　入力が終わったら、入力チェック、保存ボタンを押す手順の説明文を表示","済"]
[9,"更新申込明細","説明追加　入力が終わったら、入力チェック、保存ボタンを押す手順の説明文を表示","済"]
[10,"新規入会申込明細","入力チェックのチェック内容再確認","済"]
[11,"更新申込明細","入力チェックのチェック内容再確認","済"]
[12,"新規入会申込明細","シート保護時の操作性確認　行挿入、削除可能　他シートから貼り付けて書式崩れないか","済"]
[13,"更新申込明細","シート保護時の操作性確認　行挿入、削除不可　他シートから貼り付けて書式崩れないか","済"]
[14,"新規入会申込明細","【お支払いは入会年度の期間の日付を入力してください】→具体的な期間表示にする","済"]
[15,"更新申込明細","【お支払いは入会年度の期間の日付を入力してください】→具体的な期間表示にする","済"]
[16,"新規入会申込明細","基本申込用紙の場合、組合員歴3年未満はエラーチェックを追加","済"]
[17,"共通","管理番号のチェック","済"]
[18,"共通","申請ボタン押下、ダイアログの拡張子設定が全てしかなく、拡張子が選択できません。","済"]
[19,"新規入会申込明細","組合員歴（年）の背景色バグ","済"]
[20,"新規入会申込明細","65歳以上の方の会員資格有効期限「永久会員」にする","済"]
[21,"新規入会申込明細","入会時資格が退職者の場合、退職日必須チェック","済"]
[22,"新規入会申込明細","組合員歴（年）必須チェック","済"]
[23,"新規入会申込明細","住所１～住所３のチェック名称","済"]
[24,"新規入会申込明細","電話番号の必須チェック","済"]
[25,"更新申込明細","電話番号の必須チェック","済"]
[26,"更新申込明細","列タイトル名前の定義設定","済"]
[27,"更新申込明細","支払予定日のチェック（期間チェック）","済"]
[28,"新規入会申込明細","支払予定日のチェック（期間チェック）","済"]
[29,"更新申込明細","セルタイトル説明","済"]
[30,"新規入会申込明細","EXCEL内同一人物チェック","済"]
[31,"更新申込明細_原本","名前の定義を設定","済"]
[32,"更新申込明細","起動時の処理を分岐　プロテクト付き起動の場合　プロテクト解除→起動時処理→プロテクト設定","済"]
[33,"更新申込明細","金額計算処理をプロテクト制御分岐　プロテクト解除→金額計算処理→プロテクト設定","済"]
[34,"共通","入力内容チェック後に、変更が発生しているか視覚的にわかるようにする","済"]
[35,"共通","入力内容チェックボタン、保存ボタンを必ず押してもらえるような仕掛け","済"]
[36,"共通","説明欄にカード名表記に利用される旨を記載してください。","済"]
[37,"共通","入力内容チェックで、入力内容強制変換　名前(ｶﾅ)","済"]
[38,"共通","入力内容チェックで、入力内容強制変換　申請日","済"]
[39,"共通","入力内容チェックで、入力内容強制変換　支払予定日","済"]
[40,"共通","入力内容チェックで、入力内容強制変換　生年月日","済"]
[41,"共通","入力内容チェックで、入力内容強制変換　退職日","済"]
[42,"共通","カナ姓名複合桁数チェック","済"]
[43,"共通","明細未入力チェック","済"]
[44,"更新申込明細","更新区分　②～⑥を選択したときの、年会費・更新後有効期限の不具合","済"]
[45,"共通","チェック済み行のチェックスキップ処理","済"]
[46,"共通","チェック処理状況表示","済"]
[47,"共通","保存時にチェック未処理だとエラー実施","PGから保存した際に発動してしまうので、なし"]
[48,"共通","住所１～３矯正処理","済"]
[49,"更新申込明細","11行目　変更セルの色が変わらない不具合を対応","済"]
[50,"共通","日付項目にピリオド区切りの日付をいれても変換できるように変更","済"]
[51,"共通","チェック完了後に保存し閉じる→再立ち上げして保存を押すと内容チェックを押してのメッセージが出る","済"]
[52,"共通","他EXCELからコピペで貼り付けると書式が崩れてしまうのを何とかしたい","取込機能を追加する"]
[53,"共通","郵便番号チェック　数字7桁にする（数字以外入ってたら除外する）","済"]
[54,"共通","ステータスバーメッセージが残ってしまうのでクリアする","済"]
[55,"共通","住所１～住所３のタイトル、説明を最適化"]
[56,"共通","年度変更時にAB列（チェック済フラグ）クリア。年齢再計算のため"]
[57,"取込","取込時に取込元の申請日から年度を設定する処理追加"]