{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["이력","세팅","열쇠관리","변경이력"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":6,"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":1,"n_cols":8,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["등록일시","고유번호","교무실명","교무실번호","이름","도어락 등록여부","열쇠회수 여부","분실여부"]

{"sheet":"세팅","index":1,"n_rows":15,"n_cols":5,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["교무실 번호","자물쇠번호",null,"지급",{"$f":"COUNTIF(열쇠관리!F:F,\"지급\")","v":0}]
["교무지원센터",1,null,"회수",{"$f":"COUNTIF(열쇠관리!F:F,\"회수\")","v":0}]
["진로정보연구실",2,null,"확인대상",{"$f":"COUNTIF(열쇠관리!F:F,\"확인바람\")","v":0}]
["학생인성연구실",3,null,"기관명","OO중"]
["1학년 연구실",13,null,"메모","사용방법: 열쇠 RFID등록후 배부, 회수할 경우 태그후 회수 체크, 분실 재발급할 경우 분실재발급 체크후 등록"]
["2학년 연구실",21]
["교육혁신연구실",23]
["일시적관찰실",25]
["보건실",27]
["과학실3",28]
["과학예능연구실",29]
["과학실1",30]
["과학실2",31]
["3학년 연구실",34]
["테스트",0]

{"sheet":"열쇠관리","index":2,"n_rows":4,"n_cols":7,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["고유번호","등록 교무실","지급","회수","분실","상태","고유번호 관리하는 탭"]
["0000768820","테스트",{"$f":"IF(E2=1,\"0\",COUNTIFS(이력!B:B,열쇠관리!A2,이력!G:G,\"false\"))","v":0},{"$f":"COUNTIFS(이력!B:B,열쇠관리!A2,이력!G:G,\"true\")-E2","v":0},{"$f":"COUNTIFS(이력!B:B,열쇠관리!A2,이력!H:H,\"true\")","v":0},{"$f":"IF(E2=1,\"확인바람\",IF(C2-D2=1,\"지급\",IF(AND(C2=0,D2=0),\"\",IF(C2-D2=0,\"회수\",\"확인바람\"))))","v":""}]
["0000720820","테스트",{"$f":"IF(E3=1,\"0\",COUNTIFS(이력!B:B,열쇠관리!A3,이력!G:G,\"false\"))","v":0},{"$f":"COUNTIFS(이력!B:B,열쇠관리!A3,이력!G:G,\"true\")-E3","v":0},{"$f":"COUNTIFS(이력!B:B,열쇠관리!A3,이력!H:H,\"true\")","v":0},{"$f":"IF(E3=1,\"확인바람\",IF(C3-D3=1,\"지급\",IF(AND(C3=0,D3=0),\"\",IF(C3-D3=0,\"회수\",\"확인바람\"))))","v":""}]
["0001072260","테스트",{"$f":"IF(E4=1,\"0\",COUNTIFS(이력!B:B,열쇠관리!A4,이력!G:G,\"false\"))","v":0},{"$f":"COUNTIFS(이력!B:B,열쇠관리!A4,이력!G:G,\"true\")-E4","v":0},{"$f":"COUNTIFS(이력!B:B,열쇠관리!A4,이력!H:H,\"true\")","v":0},""]

{"sheet":"변경이력","index":3,"n_rows":4,"n_cols":2,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["2021-11-29","최초 만듬"]
[null,"처음 등록후 고유값 관리하여 해당 실만 사용하도록 수정 (화이트리스트)"]
[null,"개별 열쇠 관리기능 추가"]
["2021-11-30","검색기능 개선 - 연속검색 가능"]