{"text_format":"1","workbook":"xlsx","n_sheets":2,"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":16,"n_cols":11,"rows_kept":16,"cut":false,"hidden":false,"merged":[[0,10,0,11]]}
[null,null,null,null,null,"년도",2023,"월",3,null,"Haja_Go!!"]
["고객명","서비스기간","파견근로자1","파견근로자2",null,"시작일","종료일"]
["엑사남",{"$f":"$I$1&\".\"&F3&\" - \" &$I$1&\".\"&G3","v":"3.5 - 3.31"},119,"샴샴",null,5,31]
["다잡",{"$f":"$I$1&\".\"&F4&\" - \" &$I$1&\".\"&G4","v":"3.8 - 3.25"},"도전","DBCon",null,8,25]
["뽀리너","3.1 - 3.10","완쵸","무지",null,1,10]
["준빠","3.2 - 3.14","형형","자동업무",null,2,14]
["Haja","3.8 - 3.20","술이아빠","시훈아빠",null,8,20]
["잔머리","3.2 - 3.4","도짱","엑초보",null,2,4]
["딱총","3.1 - 3.9","무지초보","연구원",null,1,9]
["모카","3.4 - 3.5","찬","일라이",null,4,5]
[]
[]
["기초방 33",null,"근무일정의 일정에 따라 근무자추출 시트에 해당 시작일과 종료일에 근무일정 시트의 음영색을 근무기간 동안"]
[null,null,"색칠하는 칸트차트를 완성하시고"]
[]
[null,null,"시작일과 종료일에 따라 동적으로 음영색의 영역이 변화가 되어야 함"]

{"sheet":"근무자추출","index":1,"n_rows":10,"n_cols":34,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["고객별 서비스 파견현황",null,null,{"$f":"DATE(근무일정!G1,근무일정!I1,1)","v":"2023-03-01"}]
["고객명","파견자1","파견자2","2023-03-01","2023-03-02","2023-03-03","2023-03-04","2023-03-05","2023-03-06","2023-03-07","2023-03-08","2023-03-09","2023-03-10","2023-03-11","2023-03-12","2023-03-13","2023-03-14","2023-03-15","2023-03-16","2023-03-17","2023-03-18","2023-03-19","2023-03-20","2023-03-21","2023-03-22","2023-03-23","2023-03-24","2023-03-25","2023-03-26","2023-03-27","2023-03-28","2023-03-29","2023-03-30","2023-03-31"]
["엑사남",119,"샴샴"]
["다잡","도전","DBCon"]
["뽀리너","완쵸","무지"]
["준빠","형형","자동업무"]
["Haja","술이아빠","시훈아빠"]
["잔머리","도짱","엑초보"]
["딱총","무지초보","연구원"]
["모카","찬","일라이"]