{"text_format":"1","workbook":"xlsx","n_sheets":3,"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":20,"n_cols":5,"rows_kept":20,"cut":false,"hidden":false,"merged":[[4,4,20,8],[16,0,16,3]]}
[]
[]
[]
[]
[null,null,null,null,"【年間スケジュール自動生成システムの使い方】\n\n1. 「生成シート」を開きます。このシートです。\n\n2. セル B4 に「生成したい年度（西暦4桁）」を入力します。\n　　例）2024、2025 など\n\n3. 「祝日名を表示する」チェックボックスをONにすると、\n　　祝日名がカレンダー上に表示されます。\n　　OFFにすると背景色のみがつきます。\n\n4. 「スケジュール生成」ボタンをクリックします。\n\n5. 指定した年度のスケジュールが新しいシートとして作成されます。\n　　シート名は「2024年度スケジュール」などとなります。\n\n【注意事項】\n\n・同じ年度のシートがすでに存在している場合は、\n　上書きせずに処理を中止します。必要に応じて手動で削除してください。\n\n・祝日リストは「祝日リスト」シートで管理します。\n　列 B,E,H,K,N に祝日の日付を入力し、その右隣に祝日名を入力してください。\n\n・スケジュールテンプレートのレイアウト（色や書式など）は、\n　「スケジュールテンプレート」シートを修正することでカスタマイズできます。\n\n\n・自己責任でご利用ください。"]
["生成したい年度",2025,"年度"]
[]
["祝日名を表示する",true]
[]
[]
[]
[]
[]
[]
[]
[]
["開発元"]
["藤田建具店"]
["https://door-fujita.com/"]
["贈答用木製雑貨や木製ドアを製作しています。"]

{"sheet":"スケジュールテンプレート","index":1,"n_rows":33,"n_cols":14,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
[null,null,2024,"年度スケジュール"]
[null,null,{"$f":"DATE($C$1,4,1)","v":"2024-04-01"},{"$f":"DATE(YEAR(C2),MONTH(C2)+1,1)","v":"2024-05-01"},{"$f":"DATE(YEAR(D2),MONTH(D2)+1,1)","v":"2024-06-01"},"2024-07-01","2024-08-01","2024-09-01","2024-10-01","2024-11-01","2024-12-01","2025-01-01","2025-02-01","2025-03-01"]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,21]
[null,22]
[null,23]
[null,24]
[null,25]
[null,26]
[null,27]
[null,28]
[null,29]
[null,30]
[null,31]

{"sheet":"祝日リスト","index":2,"n_rows":29,"n_cols":17,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[2027,{"$f":"_xlfn.WEBSERVICE(\"http://api.excelapi.org/datetime/holiday-list?year=\" & $D$1 & \"&line=\"&ROW())","v":"2026/1/1"},{"$f":"_xlfn.WEBSERVICE(\"http://api.excelapi.org/datetime/holiday?date=\"&B1)","v":"元日"},{"$f":"A1-1","v":2026},{"$f":"_xlfn.WEBSERVICE(\"http://api.excelapi.org/datetime/holiday-list?year=\" & $D$1 & \"&line=\"&ROW())","v":"2026/1/1"},{"$f":"_xlfn.WEBSERVICE(\"http://api.excelapi.org/datetime/holiday?date=\"&E1)","v":"元日"},{"$f":"D1-1","v":2025},{"$f":"_xlfn.WEBSERVICE(\"http://api.excelapi.org/datetime/holiday-list?year=\" & $G$1 & \"&line=\"&ROW())","v":"2025/1/1"},{"$f":"_xlfn.WEBSERVICE(\"http://api.excelapi.org/datetime/holiday?date=\"&H1)","v":"元日"},{"$f":"G1-1","v":2024},{"$f":"_xlfn.WEBSERVICE(\"http://api.excelapi.org/datetime/holiday-list?year=\" & $J$1 & \"&line=\"&ROW())","v":"2024/1/1"},{"$f":"_xlfn.WEBSERVICE(\"http://api.excelapi.org/datetime/holiday?date=\"&K1)","v":"元日"},{"$f":"J1-1","v":2023},{"$f":"_xlfn.WEBSERVICE(\"http://api.excelapi.org/datetime/holiday-list?year=\" & $J$1 & \"&line=\"&ROW())","v":"2024/1/1"},{"$f":"_xlfn.WEBSERVICE(\"http://api.excelapi.org/datetime/holiday?date=\"&N1)","v":"元日"},null,"この祝日リストは、左の上の年を書き換えるだけで取得されます。"]
[null,{"$f":"_xlfn.WEBSERVICE(\"http://api.excelapi.org/datetime/holiday-list?year=\" & $D$1 & \"&line=\"&ROW())","v":"2026/1/12"},{"$f":"_xlfn.WEBSERVICE(\"http://api.excelapi.org/datetime/holiday?date=\"&B2)","v":"成人の日"},null,{"$f":"_xlfn.WEBSERVICE(\"http://api.excelapi.org/datetime/holiday-list?year=\" & $D$1 & \"&line=\"&ROW())","v":"2026/1/12"},{"$f":"_xlfn.WEBSERVICE(\"http://api.excelapi.org/datetime/holiday?date=\"&E2)","v":"成人の日"},null,{"$f":"_xlfn.WEBSERVICE(\"http://api.excelapi.org/datetime/holiday-list?year=\" & $G$1 & \"&line=\"&ROW())","v":"2025/1/13"},{"$f":"_xlfn.WEBSERVICE(\"http://api.excelapi.org/datetime/holiday?date=\"&H2)","v":"成人の日"},null,"2024/1/8",{"$f":"_xlfn.WEBSERVICE(\"http://api.excelapi.org/datetime/holiday?date=\"&K2)","v":"成人の日"},null,"2024/1/8",{"$f":"_xlfn.WEBSERVICE(\"http://api.excelapi.org/datetime/holiday?date=\"&N2)","v":"成人の日"}]
[null,"2026/2/11","建国記念の日",null,"2026/2/11","建国記念の日",null,"2025/2/11","建国記念の日",null,"2024/2/11","建国記念の日",null,"2024/2/11","建国記念の日",null,"B,E,H,K,N列にある日付は祝日として機能します"]
[null,"2026/2/23","天皇誕生日",null,"2026/2/23","天皇誕生日",null,"2025/2/23","天皇誕生日",null,"2024/2/12","振替休日",null,"2024/2/12","振替休日"]
[null,"2026/3/20","春分の日",null,"2026/3/20","春分の日",null,"2025/2/24","振替休日",null,"2024/2/23","天皇誕生日",null,"2024/2/23","天皇誕生日"]
[null,"2026/4/29","昭和の日",null,"2026/4/29","昭和の日",null,"2025/3/20","春分の日",null,"2024/3/20","春分の日",null,"2024/3/20","春分の日"]
[null,"2026/5/3","憲法記念日",null,"2026/5/3","憲法記念日",null,"2025/4/29","昭和の日",null,"2024/4/29","昭和の日",null,"2024/4/29","昭和の日"]
[null,"2026/5/4","みどりの日",null,"2026/5/4","みどりの日",null,"2025/5/3","憲法記念日",null,"2024/5/3","憲法記念日",null,"2024/5/3","憲法記念日"]
[null,"2026/5/5","こどもの日",null,"2026/5/5","こどもの日",null,"2025/5/4","みどりの日",null,"2024/5/4","みどりの日",null,"2024/5/4","みどりの日"]
[null,"2026/5/6","振替休日",null,"2026/5/6","振替休日",null,"2025/5/5","こどもの日",null,"2024/5/5","こどもの日",null,"2024/5/5","こどもの日"]
[null,"2026/7/20","海の日",null,"2026/7/20","海の日",null,"2025/5/6","振替休日",null,"2024/5/6","振替休日",null,"2024/5/6","振替休日"]
[null,"2026/8/11","山の日",null,"2026/8/11","山の日",null,"2025/7/21","海の日",null,"2024/7/15","海の日",null,"2024/7/15","海の日"]
[null,"2026/9/21","敬老の日",null,"2026/9/21","敬老の日",null,"2025/8/11","山の日",null,"2024/8/11","山の日",null,"2024/8/11","山の日"]
[null,"2026/9/22","国民の休日",null,"2026/9/22","国民の休日",null,"2025/9/15","敬老の日",null,"2024/8/12","振替休日",null,"2024/8/12","振替休日"]
[null,"2026/9/23","秋分の日",null,"2026/9/23","秋分の日",null,"2025/9/23","秋分の日",null,"2024/9/16","敬老の日",null,"2024/9/16","敬老の日"]
[null,"2026/10/12","スポーツの日",null,"2026/10/12","スポーツの日",null,"2025/10/13","スポーツの日",null,"2024/9/22","秋分の日",null,"2024/9/22","秋分の日"]
[null,"2026/11/3","文化の日",null,"2026/11/3","文化の日",null,{"$f":"_xlfn.WEBSERVICE(\"http://api.excelapi.org/datetime/holiday-list?year=\" & $G$1 & \"&line=\"&ROW())","v":"2025/11/3"},"文化の日",null,"2024/9/23","振替休日",null,"2024/9/23","振替休日"]
[null,"2026/11/23","勤労感謝の日",null,"2026/11/23","勤労感謝の日",null,"2025/11/23","勤労感謝の日",null,"2024/10/14","スポーツの日",null,"2024/10/14","スポーツの日"]
[null,"0","",null,"0","",null,"2025/11/24","振替休日",null,"2024/11/3","文化の日",null,"2024/11/3","文化の日"]
[null,"0","",null,"0","",null,"0","",null,"2024/11/4","振替休日",null,"2024/11/4","振替休日"]
[null,"0","",null,"0","",null,"0","",null,"2024/11/23","勤労感謝の日",null,"2024/11/23","勤労感謝の日"]
[null,null,null,null,null,null,null,null,null,null,"0","",null,"0",""]
[null,null,null,null,null,null,null,null,null,null,"0","",null,"0",""]
[null,null,null,null,null,null,null,null,null,null,"0","",null,"0",""]
[null,null,null,null,null,null,null,null,null,null,"0","",null,"0",""]
[null,null,null,null,null,null,null,null,null,null,"0","",null,"0",""]
[null,null,null,null,null,null,null,null,null,null,"0","",null,"0",""]
[null,null,null,null,null,null,null,null,null,null,"0","",null,"0",""]
[null,null,null,null,null,null,null,null,null,null,"0","",null,"0",""]