{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["발행 수표 기입장"],"not_rendered":{"defined_names":4},"read":"whole","date_system":"1900"}

{"sheet":"발행 수표 기입장","index":0,"n_rows":13,"n_cols":8,"rows_kept":13,"merged":[[2,1,2,2],[3,1,3,2],[4,1,4,2]]}
[null,"발행 수표 기입장"]
[null,"범례",{"$nulls":5},"현재 잔액"]
[null,"DC = 직불 카드",null,"AP = 자동 결제 ",{"$nulls":3},{"$f":"현재_잔액","v":{"v":3311,"d":"₩3,311.00"}}]
[null,"ATM = 자동화된 현금 인출",null,"BP = 온라인 청구서 지불"]
[null,"AD = 자동 예금 ",null,"TR = 온라인 또는 전화 이체"]
[null,"수표/코드","날짜","트랜잭션","설명","인출","예금","잔액"]
[null,null,{"$f":"TODAY()-19","v":"2018-05-26"},"나라 은행","개시 잔액",null,{"v":2000,"d":"₩2,000.00"},{"$f":"IFERROR(발행수표기입장[[#This Row],[예금]], \"\")","v":{"v":2000,"d":"₩2,000.00"}}]
[null,1001,{"$f":"TODAY()-11","v":"2018-06-03"},"참조은 디자인 아트스쿨","선희의 아트 클래스 - 6주",{"v":100,"d":"₩100.00"},null,{"$f":"IFERROR(IF(ISBLANK(발행수표기입장[[#This Row],[인출]]),H7+발행수표기입장[[#This Row],[예금]],H7-발행수표기입장[[#This Row],[인출]]), \"\")","v":{"v":1900,"d":"₩1,900.00"}}]
[null,"AD",{"$f":"TODAY()-11","v":"2018-06-03"},"급여 수표",null,null,{"v":1500,"d":"₩1,500.00"},{"$f":"IFERROR(IF(ISBLANK(발행수표기입장[[#This Row],[인출]]),H8+발행수표기입장[[#This Row],[예금]],H8-발행수표기입장[[#This Row],[인출]]), \"\")","v":{"v":3400,"d":"₩3,400.00"}}]
[null,"DC",{"$f":"TODAY()-8","v":"2018-06-06"},"보람 비디오","영화 대여 + ₩10 캐시백",{"v":16,"d":"₩16.00"},null,{"$f":"IFERROR(IF(ISBLANK(발행수표기입장[[#This Row],[인출]]),H9+발행수표기입장[[#This Row],[예금]],H9-발행수표기입장[[#This Row],[인출]]), \"\")","v":{"v":3384,"d":"₩3,384.00"}}]
[null,"ATM",{"$f":"TODAY()-5","v":"2018-06-09"},null,"외식 현금 지불",{"v":50,"d":"₩50.00"},null,{"$f":"IFERROR(IF(ISBLANK(발행수표기입장[[#This Row],[인출]]),H10+발행수표기입장[[#This Row],[예금]],H10-발행수표기입장[[#This Row],[인출]]), \"\")","v":{"v":3334,"d":"₩3,334.00"}}]
[null,"BP",{"$f":"TODAY()","v":"2018-06-14"},"선진 네트워크",null,{"v":23,"d":"₩23.00"},null,{"$f":"IFERROR(IF(ISBLANK(발행수표기입장[[#This Row],[인출]]),H11+발행수표기입장[[#This Row],[예금]],H11-발행수표기입장[[#This Row],[인출]]), \"\")","v":{"v":3311,"d":"₩3,311.00"}}]
[null,"합계",null,{"$f":"CONCATENATE(\"트랜잭션 개수: \",SUBTOTAL(103,발행수표기입장[트랜잭션]))","v":"트랜잭션 개수: 5"},null,{"$f":"SUBTOTAL(109,발행수표기입장[인출])","v":{"v":189,"d":"₩189.00"}},{"$f":"SUBTOTAL(109,발행수표기입장[예금])","v":{"v":3500,"d":"₩3,500.00"}},{"$f":"발행수표기입장[[#Totals],[예금]]-발행수표기입장[[#Totals],[인출]]","v":{"v":3311,"d":"₩3,311.00"}}]