{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Main","MST_STAFF","TBL_LEAVE","有給付与について","Image","Output"],"not_rendered":{"charts":0,"images":2,"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":"Main","index":0,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["有給管理"]

{"sheet":"MST_STAFF","index":1,"n_rows":10,"n_cols":7,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["社員ID","名前","振り仮名","入社日","退社日","雇用形態","備考"]
["P0000","一軒家 治","いっけんや おさむ","1990-04-01",null,"パート"]
["P0001","代紋 明代","だいもん あきよ","1995-04-01",null,"パート2","週2日勤務"]
["P0002","葵 睦弘","あおい むつひろ","1990-06-23",null,"パート","週3日勤務"]
["P0003","水戸 幸代","みと さちよ","1992-04-01","2020-03-31","パート4","週4日勤務"]
["S0000","徳川 大輔","とくがわ だいすけ","2010-04-01",null,"契約社員"]
["S0001","星 明日香","ほし あすか","2012-04-01","2022-03-31","契約社員3","週3日勤務"]
["S0002","村上 元也","むらかみ もとなり","2011-01-27",null,"正社員"]
["S0003","谷口 鈴","たにぐち すず","2018-04-01",null,"正社員"]
["S0004","松川 七菜","まつかわ なな","2021-04-01",null,"正社員"]

{"sheet":"TBL_LEAVE","index":2,"n_rows":36,"n_cols":7,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
["ID","日付","休暇種別","社員ID","名前","理由","備考"]
["20150617:P0000","2015-06-17","有給","P0000","一軒家 治","通院の為。","テストデータ"]
["20201013:P0000","2020-10-13","法廷","P0000","一軒家 治","育児休暇。","テストデータ"]
["20201210:P0000","2020-12-10","有給","P0000","一軒家 治","私用の為。","テストデータ"]
["20201213:P0000","2020-12-13","有給","P0000","一軒家 治","私用の為。","テストデータ"]
["20210629:P0000","2021-06-29","休暇","P0000","一軒家 治","病欠。","テストデータ"]
["20220518:P0000","2022-05-18","休暇","P0000","一軒家 治","病欠。","テストデータ"]
["20230301:P0000","2023-03-01","有給","P0000","一軒家 治","仕様の為。","テストデータ"]
["20230310:P0000","2023-03-10","有給","P0000","一軒家 治","仕様の為。","テストデータ"]
["20231222:P0000","2023-10-22","有給","P0000","一軒家 治","私用の為。","テストデータ"]
[{"$f":"YEAR(B11) &RIGHT( \"00\"&MONTH(B11),2) & RIGHT(\"00\" &DAY(B11),2)&\":\"&D11","v":"20221201:P0000"},"2022-12-01","有給","P0000","一軒家 治","入院。","テストデータ"]
[{"$f":"YEAR(B12) &RIGHT( \"00\"&MONTH(B12),2) & RIGHT(\"00\" &DAY(B12),2)&\":\"&D12","v":"20221202:P0000"},{"$f":"B11+1","v":"2022-12-02"},"有給","P0000","一軒家 治","入院。","テストデータ"]
["20221203:P0000",{"$f":"B12+1","v":"2022-12-03"},"有給","P0000","一軒家 治","入院。","テストデータ"]
["20221204:P0000","2022-12-04","有給","P0000","一軒家 治","入院。","テストデータ"]
["20221205:P0000","2022-12-05","有給","P0000","一軒家 治","入院。","テストデータ"]
["20221206:P0000","2022-12-06","有給","P0000","一軒家 治","入院。","テストデータ"]
["20221207:P0000","2022-12-07","有給","P0000","一軒家 治","入院。","テストデータ"]
["20221208:P0000","2022-12-08","有給","P0000","一軒家 治","入院。","テストデータ"]
["20221209:P0000","2022-12-09","有給","P0000","一軒家 治","入院。","テストデータ"]
["20221210:P0000","2022-12-10","有給","P0000","一軒家 治","入院。","テストデータ"]
["20221211:P0000","2022-12-11","有給","P0000","一軒家 治","入院。","テストデータ"]
["20221212:P0000","2022-12-12","有給","P0000","一軒家 治","入院。","テストデータ"]
["20221213:P0000","2022-12-13","有給","P0000","一軒家 治","入院。","テストデータ"]
["20221214:P0000","2022-12-14","有給","P0000","一軒家 治","入院。","テストデータ"]
["20221215:P0000","2022-12-15","有給","P0000","一軒家 治","入院。","テストデータ"]
["20221216:P0000","2022-12-16","有給","P0000","一軒家 治","入院。","テストデータ"]
["20221217:P0000","2022-12-17","有給","P0000","一軒家 治","入院。","テストデータ"]
["20221218:P0000","2022-12-18","有給","P0000","一軒家 治","入院。","テストデータ"]
["20221219:P0000","2022-12-19","有給","P0000","一軒家 治","入院。","テストデータ"]
["20221220:P0000","2022-12-20","有給","P0000","一軒家 治","入院。","テストデータ"]
["20221221:P0000","2022-12-21","有給","P0000","一軒家 治","入院。","テストデータ"]
["20221222:P0000","2022-12-22","有給","P0000","一軒家 治","入院。","テストデータ"]
["20221223:P0000","2022-12-23","有給","P0000","一軒家 治","入院。","テストデータ"]
["20221224:P0000","2022-12-24","有給","P0000","一軒家 治","入院。","テストデータ"]
["20221225:P0000","2022-12-25","有給","P0000","一軒家 治","入院。","テストデータ"]
["20221226:P0000","2022-12-26","有給","P0000","一軒家 治","入院。","テストデータ"]

{"sheet":"有給付与について","index":3,"n_rows":15,"n_cols":10,"rows_kept":15,"cut":false,"hidden":false,"merged":[[2,0,6,0],[1,0,1,2],[2,2,6,2]]}
["有給付与日数"]
["継続勤続年数【年】",null,null,0.5,1.5,2.5,3.5,4.5,5.5,"6.5以上"]
["労働日数","週5日以上","付与数\n【日】",10,11,12,14,16,18,20]
[null,"週4日",null,7,8,9,10,12,13,15]
[null,"週3日",null,5,6,6,8,9,10,11]
[null,"週2日",null,3,4,4,5,6,6,7]
[null,"週1日",null,1,2,2,2,3,3,3]
[]
["有給付与の基本ルール"]
["有給付与日は、入社後、最初が半年で、それ以降は付与日から1年毎。"]
["有給の時効は付与日から2年とする。"]
["雇用形態(正社員、パート etc.)に関わらず、週所定労働日数に応じて、有給付与日数を定める仕様。"]
["今回の仕様では、営業日数や営業時間に対して、何割以上の勤務を要求するといった条件設定はしてありません。"]
[]
["※それぞれの会社の就業規則に応じて、仕様および、プログラムを変更してください。"]

{"sheet":"Image","index":4,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,"私は、いつも"]
[null,null,null,null,null,"オンライン画像を参考にして、図形描画しています。"]
[]
[null,null,null,null,null,"オンライン画像は、"]
[null,null,null,null,null,"エクセルのリボンの【タブ】-【図】-【オンライン画像】"]
[null,null,null,null,null,"から、挿入できます。"]
[]
[null,null,null,null,null,"今回の場合は、キーワードに\"イラスト 彼岸花\""]
[null,null,null,null,null,"で検索した画像を参考にして、描画しました。"]

{"sheet":"Output","index":5,"n_rows":4,"n_cols":9,"rows_kept":4,"cut":false,"hidden":false,"merged":[[0,3,0,5]]}
["社員ID","社員名","項目","付与日",null,null,"現時点",null,"※括弧付きの値は、有給申請しているが、未消化のデータです。"]
[null,null,null,"2020-10-01","2021-10-01","2022-10-01","有給残"]
["P0000","一軒家 治","付与数",20,20,20,"11 (-1)"]
[null,null,"消化数",0,20,"8 (+1)"]