{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["入金予定","取引先マスタ","支払パターン","祝日マスタ"],"not_rendered":{"charts":0,"images":0,"macros":0,"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":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["取引先","取引先名","請求日","入金予定日"]
["T0001",{"$f":"VLOOKUP(A2,取引先マスタ!A:B,2,0)","v":"株式会社100本ノック"},"2021-02-10","ここに"]
["T0002",{"$f":"VLOOKUP(A3,取引先マスタ!A:B,2,0)","v":"株式会社VBA"},"2021-02-12","入れる"]
["T0003",{"$f":"VLOOKUP(A4,取引先マスタ!A:B,2,0)","v":"株式会社マクロ"},"2021-02-14","ユーザー"]
["T0004",{"$f":"VLOOKUP(A5,取引先マスタ!A:B,2,0)","v":"有限会社エクセル"},"2021-02-16","定義関数"]
["T0005",{"$f":"VLOOKUP(A6,取引先マスタ!A:B,2,0)","v":"Excel合同会社"},"2021-02-18","を作成して"]
["T0006",{"$f":"VLOOKUP(A7,取引先マスタ!A:B,2,0)","v":"取引先名06"},"2021-02-20","ください。"]
["T0007",{"$f":"VLOOKUP(A8,取引先マスタ!A:B,2,0)","v":"取引先名07"},"2021-02-22"]
["T0008",{"$f":"VLOOKUP(A9,取引先マスタ!A:B,2,0)","v":"取引先名08"},"2021-02-24","適当に変更"]
["T0009",{"$f":"VLOOKUP(A10,取引先マスタ!A:B,2,0)","v":"取引先名09"},"2021-02-26","してテスト"]
["T0010",{"$f":"VLOOKUP(A11,取引先マスタ!A:B,2,0)","v":"取引先名10"},"2021-02-28","してください"]

{"sheet":"取引先マスタ","index":1,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["取引先","取引先名","支払パターン"]
["T0001","株式会社100本ノック","P01"]
["T0002","株式会社VBA","P02"]
["T0003","株式会社マクロ","P03"]
["T0004","有限会社エクセル","P04"]
["T0005","Excel合同会社","P05"]
["T0006","取引先名06","P06"]
["T0007","取引先名07","P07"]
["T0008","取引先名08","P08"]
["T0009","取引先名09","P09"]
["T0010","取引先名10","P10"]

{"sheet":"支払パターン","index":2,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["支払パターン","締め日","支払月","支払日"]
["P01","末","1月後","末"]
["P02","末","2月後",15]
["P03","末","3月後",25]
["P04","末","4月後","末"]
["P05","末","6月後","末"]
["P06",5,"0月後","末"]
["P07",15,"1月後",15]
["P08",15,"1月後","末"]
["P09",20,"1月後","末"]
["P10",20,"2月後",20]

{"sheet":"祝日マスタ","index":3,"n_rows":34,"n_cols":3,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
["日付","祝日名","曜日"]
["2021-01-01","元日","金"]
["2021-01-11","成人の日","月"]
["2021-02-11","建国記念の日","木"]
["2021-02-23","天皇誕生日","火"]
["2021-03-20","春分の日","土"]
["2021-04-29","昭和の日","木"]
["2021-05-03","憲法記念日","月"]
["2021-05-04","みどりの日","火"]
["2021-05-05","こどもの日","水"]
["2021-07-22","海の日","木"]
["2021-07-23","スポーツの日","金"]
["2021-08-08","山の日","日"]
["2021-08-09","振替休日","月"]
["2021-09-20","敬老の日","月"]
["2021-09-23","秋分の日","木"]
["2021-11-03","文化の日","水"]
["2021-11-23","勤労感謝の日","火"]
["2022-01-01","元日","土"]
["2022-01-10","成人の日","月"]
["2022-02-11","建国記念の日","金"]
["2022-02-23","天皇誕生日","水"]
["2022-03-21","春分の日","月"]
["2022-04-29","昭和の日","金"]
["2022-05-03","憲法記念日","火"]
["2022-05-04","みどりの日","水"]
["2022-05-05","こどもの日","木"]
["2022-07-18","海の日","月"]
["2022-08-11","山の日","木"]
["2022-09-19","敬老の日","月"]
["2022-09-23","秋分の日","金"]
["2022-10-10","スポーツの日","月"]
["2022-11-03","文化の日","木"]
["2022-11-23","勤労感謝の日","水"]