{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["index","이력","원인행위","카드정보"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"comments":1,"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","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"이력","index":1,"n_rows":4,"n_cols":8,"rows_kept":4,"cut":false,"hidden":false,"merged":[[0,1,0,7]]}
[null,"신용카드 사용부"]
["지출품의No","수령일자","카드번호","사용자","품의일자","사용내역","반납일자","사용금액"]
["00232","2020-10-26 오후 2:59:42","테스트2","김하나","2020-08-31","건강체력반 8월 강사료 신청"]
["00230","2020-10-26 오후 3:00:07","4800","김두리","2020-08-30","2020년 1학기 표준화 심리검사비 지출 품의","2020-10-26 오후 3:00:23",5000]

{"sheet":"원인행위","index":2,"n_rows":6,"n_cols":22,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[null,"자료 저장일시:","2020-08-14T04:27:51"]
["품의번호","품의일자","품의제목","품의자","품의\n금액","원인행위\n금액","부서","진행\n상태","결재일자","완료\n요구일","접수자","카드사용","차액","%","지출방법","원인\n행위","검수\n안내","재산\n등재","지출\n결의","서류\n전달","업체정보","비고(필요서류)"]
["00232","2020-08-31","건강체력반 8월 강사료 신청","김하나",540000,0,"체육건강부","품의결재요청",null,"2020-09-30",null,"N",{"$f":"F3-E3","v":-540000},{"$f":"F3/E3","v":0},null,false,false,false,false,false]
["00230","2020-08-30","2020년 1학기 표준화 심리검사비 지출 품의","김두리",1291800,0,"체육건강부","품의결재요청",null,"2020-09-30",null,"N",-1291800,0,null,false,false,false,false,false]
["00227","2020-08-29","본관 교실 빔프로젝트 아일랜드함 설치","김세째",704000,0,"체육건강부","품의결재완료","2020-08-31","2020-09-04",null,"N",-704000,0,null,false,false,false,false,false]
["00226","2020-08-28","금연교육자료 구입","김네째",200000,0,"체육건강부","품의결재완료","2020-08-31","2020-09-30",null,"N",-200000,0,null,false,false,false,false,false]

{"sheet":"카드정보","index":3,"n_rows":8,"n_cols":10,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["RFID 고유값","카드번호","카드번호",null,null,null,{"$f":"MAX(원인행위!B:B)","v":"2020-08-31"},{"$f":"VLOOKUP(G1,원인행위!B:E,2,FALSE)","v":"건강체력반 8월 강사료 신청"},{"$f":"VLOOKUP(G1,원인행위!B:E,3,FALSE)","v":"김하나"},{"$f":"VLOOKUP(G1,원인행위!B:E,4,FALSE)","v":540000}]
["1","테스트2",1,{"$f":"IF((COUNTIFS(이력!C:C,카드정보!B2,이력!G:G,\"\")=0),\"반납\",\"사용중\")","v":"사용중"},null,null,4800,{"$f":"IF(ISERROR(VLOOKUP(G2,B:D,3,FALSE)),\"\",VLOOKUP(G2,B:D,3,FALSE))","v":"반납"}]
["0000000002",4800,"0000-0000-0000-4800",{"$f":"IF((COUNTIFS(이력!C:C,카드정보!B3,이력!G:G,\"\")=0),\"반납\",\"사용중\")","v":"반납"},null,null,null,{"$f":"NOW()","v":44130.62537465278}]
["0000000003",7700,"0000-0000-0000-7700",{"$f":"IF((COUNTIFS(이력!C:C,카드정보!B4,이력!G:G,\"\")=0),\"반납\",\"사용중\")","v":"반납"}]
["0000000004",6400,"0000-0000-0000-6400",{"$f":"IF((COUNTIFS(이력!C:C,카드정보!B5,이력!G:G,\"\")=0),\"반납\",\"사용중\")","v":"반납"}]
["0000000005",9295,"0000-0000-0000-9295",{"$f":"IF((COUNTIFS(이력!C:C,카드정보!B6,이력!G:G,\"\")=0),\"반납\",\"사용중\")","v":"반납"}]
["0000000006",5100,"0000-0000-0000-5100",{"$f":"IF((COUNTIFS(이력!C:C,카드정보!B7,이력!G:G,\"\")=0),\"반납\",\"사용중\")","v":"반납"}]
["0000000007",3500,"0000-0000-0000-3500",{"$f":"IF((COUNTIFS(이력!C:C,카드정보!B8,이력!G:G,\"\")=0),\"반납\",\"사용중\")","v":"반납"}]