{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["지출 요약","지출분개장"],"not_rendered":{"defined_names":6},"read":"whole","date_system":"1900"}

{"sheet":"지출 요약","index":0,"n_rows":18,"n_cols":11,"rows_kept":18,"merged":[[0,1,0,3],[0,4,0,10]]}
[null,"지출 요약",null,null,"아래 지출 요약 표 머리글에서 범주 이름을 수정하여 이 서식 파일을 요구에 맞게 사용자 지정합니다. 범주를 추가해야 하는 경우 표의 마지막 열을 복사한 후 복사된 열의 오른쪽에 붙여넣습니다. 범주 이름을 변경하면 수식이 자동으로 업데이트됩니다. 이 표의 행 수는 지출분개장 워크시트와 같아야 합니다."]
[null,"날짜","자동차 보험","사무용품","전기","담보 대출","전화","비어 있음 1","비어 있음 2","비어 있음 3","비어 있음 4"]
[null,{"$f":"IFERROR(INDEX(기입장[],ROW(A1),1),\"\")","v":"2018-04-05"},{"$f":"IFERROR(INDIRECT(\"기입장[@금액]\")*(INDIRECT(\"기입장[@범주]\")=범주이름),\"\")","v":0},0,0,{"v":1200,"d":"₩1,200.00"},0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(기입장[],ROW(A2),1),\"\")","v":"2018-04-10"},0,0,{"v":85,"d":"₩85.00"},0,0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(기입장[],ROW(A3),1),\"\")","v":"2018-04-15"},{"v":100,"d":"₩100.00"},0,0,0,0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(기입장[],ROW(A4),1),\"\")","v":"2018-04-20"},0,0,0,{"v":1200,"d":"₩1,200.00"},0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(기입장[],ROW(A5),1),\"\")","v":"2018-04-25"},0,0,0,{"v":99,"d":"₩99.00"},0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(기입장[],ROW(A6),1),\"\")","v":"2018-04-30"},0,0,0,0,{"v":68,"d":"₩68.00"},0,0,0,0]
[null,{"$f":"IFERROR(INDEX(기입장[],ROW(A7),1),\"\")","v":"2018-05-05"},{"v":100,"d":"₩100.00"},0,0,0,0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(기입장[],ROW(A8),1),\"\")","v":"2018-05-10"},0,{"v":345,"d":"₩345.00"},0,0,0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(기입장[],ROW(A9),1),\"\")","v":"2018-05-15"},0,0,0,{"v":1200,"d":"₩1,200.00"},0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(기입장[],ROW(A10),1),\"\")","v":"2018-05-20"},0,0,{"v":74,"d":"₩74.00"},0,0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(기입장[],ROW(A11),1),\"\")","v":"2018-05-25"},0,0,0,0,{"v":123,"d":"₩123.00"},0,0,0,0]
[null,{"$f":"IFERROR(INDEX(기입장[],ROW(A12),1),\"\")","v":"2018-05-30"},0,{"v":99,"d":"₩99.00"},0,0,0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(기입장[],ROW(A13),1),\"\")","v":"2018-06-04"},{"v":100,"d":"₩100.00"},0,0,0,0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(기입장[],ROW(A14),1),\"\")","v":"2018-06-09"},0,0,0,{"v":1200,"d":"₩1,200.00"},0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(기입장[],ROW(A15),1),\"\")","v":"2018-06-14"},0,{"v":128,"d":"₩128.00"},0,0,0,0,0,0,0]
[null,null,{"$f":"SUBTOTAL(109,지출요약[자동차 보험])","v":{"v":300,"d":"₩300.00"}},{"$f":"SUBTOTAL(109,지출요약[사무용품])","v":{"v":572,"d":"₩572.00"}},{"$f":"SUBTOTAL(109,지출요약[전기])","v":{"v":159,"d":"₩159.00"}},{"$f":"SUBTOTAL(109,지출요약[담보 대출])","v":{"v":4899,"d":"₩4,899.00"}},{"$f":"SUBTOTAL(109,지출요약[전화])","v":{"v":191,"d":"₩191.00"}},{"$f":"SUBTOTAL(109,지출요약[비어 있음 1])","v":0},{"$f":"SUBTOTAL(109,지출요약[비어 있음 2])","v":0},{"$f":"SUBTOTAL(109,지출요약[비어 있음 3])","v":0},{"$f":"SUBTOTAL(109,지출요약[비어 있음 4])","v":0}]

{"sheet":"지출분개장","index":1,"n_rows":18,"n_cols":6,"rows_kept":18,"merged":[[0,1,0,3]]}
[null,"지출분개장"]
[null,"날짜","번호","설명","범주","금액"]
[null,{"$f":"TODAY()-70","v":"2018-04-05"},"100","나라 은행","담보 대출",{"v":1200,"d":"₩1,200.00"}]
[null,{"$f":"TODAY()-65","v":"2018-04-10"},101,"지역 전력 공사","전기",{"v":85,"d":"₩85.00"}]
[null,{"$f":"TODAY()-60","v":"2018-04-15"},102,"서주 보험 (주)","자동차 보험",{"v":100,"d":"₩100.00"}]
[null,{"$f":"TODAY()-55","v":"2018-04-20"},103,"나라 은행","담보 대출",{"v":1200,"d":"₩1,200.00"}]
[null,{"$f":"TODAY()-50","v":"2018-04-25"},104,"지역 전력 공사","담보 대출",{"v":99,"d":"₩99.00"}]
[null,{"$f":"TODAY()-45","v":"2018-04-30"},105,"선진 네트워크","전화",{"v":68,"d":"₩68.00"}]
[null,{"$f":"TODAY()-40","v":"2018-05-05"},106,"서주 보험 (주)","자동차 보험",{"v":100,"d":"₩100.00"}]
[null,{"$f":"TODAY()-35","v":"2018-05-10"},107,"양정 물산 ㈜","사무용품",{"v":345,"d":"₩345.00"}]
[null,{"$f":"TODAY()-30","v":"2018-05-15"},110,"나라 은행","담보 대출",{"v":1200,"d":"₩1,200.00"}]
[null,{"$f":"TODAY()-25","v":"2018-05-20"},111,"지역 전력 공사","전기",{"v":74,"d":"₩74.00"}]
[null,{"$f":"TODAY()-20","v":"2018-05-25"},108,"선진 네트워크","전화",{"v":123,"d":"₩123.00"}]
[null,{"$f":"TODAY()-15","v":"2018-05-30"},109,"양정 물산 ㈜","사무용품",{"v":99,"d":"₩99.00"}]
[null,{"$f":"TODAY()-10","v":"2018-06-04"},112,"서주 보험 (주)","자동차 보험",{"v":100,"d":"₩100.00"}]
[null,{"$f":"TODAY()-5","v":"2018-06-09"},113,"나라 은행","담보 대출",{"v":1200,"d":"₩1,200.00"}]
[null,{"$f":"TODAY()","v":"2018-06-14"},114,"양정 물산 ㈜","사무용품",{"v":128,"d":"₩128.00"}]
[null,"합계",{"$nulls":3},{"$f":"SUBTOTAL(109,기입장[금액])","v":{"v":6121,"d":"₩6,121.00"}}]