{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["개인 금전 출납부","월간 요약","차트 데이터"],"not_rendered":{"charts":2,"defined_names":7,"pivot_tables":2},"read":"whole","date_system":"1900"}

{"sheet":"개인 금전 출납부","index":0,"n_rows":22,"n_cols":7,"rows_kept":22,"merged":[[8,3,8,6],[19,1,20,1],[21,1,23,1]]}
[null,"개인 금전 출납부"]
[]
[{"$nulls":3},"현금 사용 요약"]
[{"$nulls":3},"개인 금전 출납부","현재 보유 잔고","지출 합계","잔액"]
[{"$nulls":3},"당좌",3000000,{"$f":"SUMIF(현금_지출[계좌],\"=\" &현금_요약_테이블[[#This Row],[개인 금전 출납부]],현금_지출[금액])","v":428000},{"$f":"현금_요약_테이블[[#This Row],[현재 보유 잔고]]-현금_요약_테이블[[#This Row],[지출 합계]]","v":2572000}]
[{"$nulls":3},"저축",500000,{"$f":"SUMIF(현금_지출[계좌],\"=\" &현금_요약_테이블[[#This Row],[개인 금전 출납부]],현금_지출[금액])","v":450000},{"$f":"현금_요약_테이블[[#This Row],[현재 보유 잔고]]-현금_요약_테이블[[#This Row],[지출 합계]]","v":50000}]
[{"$nulls":3},"기타",200000,{"$f":"SUMIF(현금_지출[계좌],\"=\" &현금_요약_테이블[[#This Row],[개인 금전 출납부]],현금_지출[금액])","v":30000},{"$f":"현금_요약_테이블[[#This Row],[현재 보유 잔고]]-현금_요약_테이블[[#This Row],[지출 합계]]","v":170000}]
[{"$nulls":3}," 합계 ",{"$f":"SUBTOTAL(109,현금_요약_테이블[현재 보유 잔고])","v":3700000},{"$f":"SUBTOTAL(109,현금_요약_테이블[지출 합계])","v":908000},{"$f":"SUBTOTAL(109,현금_요약_테이블[잔액])","v":2792000}]
[]
[{"$nulls":3},"현금 지출 내역"]
[{"$nulls":3},"날짜","항목","금액","계좌"]
[{"$nulls":3},"2012-01-04"," ATM 인출 ",{"v":40000,"d":"40,000 "},"당좌"]
[{"$nulls":3},"2012-01-05"," 점심 ",{"v":5000,"d":"5,000 "},"당좌"]
[{"$nulls":3},"2012-01-06"," 자동차 할부금 ",{"v":230000,"d":"230,000 "},"저축"]
[{"$nulls":3},"2012-02-03"," 전기세 ",{"v":70000,"d":"70,000 "},"당좌"]
[{"$nulls":3},"2012-02-07"," 저녁 ",{"v":53000,"d":"53,000 "},"당좌"]
[{"$nulls":3},"2012-03-01"," 현금 출금 ",{"v":100000,"d":"100,000 "},"저축"]
[{"$nulls":3},"2012-03-06"," 자동차 할부금",{"v":230000,"d":"230,000 "},"당좌"]
[{"$nulls":3},"2012-04-06"," 전기세 ",{"v":70000,"d":"70,000 "},"저축"]
[null,"잔액:",null,"2012-04-20"," ATM 인출 ",{"v":30000,"d":"30,000 "},"당좌"]
[{"$nulls":3},"2012-05-03"," ATM 인출 ",{"v":50000,"d":"50,000 "},"저축"]
[null,{"$f":"현금_요약_테이블[[#Totals],[잔액]]/현금_요약_테이블[[#Totals],[현재 보유 잔고]]","v":{"v":0.7545945945945945,"d":"75%"}},null,"2012-05-10"," ATM 인출 ",{"v":30000,"d":"30,000 "},"기타"]

{"sheet":"월간 요약","index":1,"n_rows":26,"n_cols":6,"rows_kept":26}
[null,"월간 요약"]
[null,"잔액:"]
{"$rows_empty":13}
[null,"지출 요약"]
[null,"합계 : 금액"]
[null,null,"당좌","저축","기타","총합계"]
[null,"1월",45000,230000,null,275000]
[null,"2월",123000,null,null,123000]
[null,"3월",230000,100000,null,330000]
[null," 현금 출금 ",null,100000,null,100000]
[null," 자동차 할부금",230000,null,null,230000]
[null,"4월",30000,70000,null,100000]
[null,"5월",null,50000,30000,80000]
[null,"총합계",428000,450000,30000,908000]

{"sheet":"차트 데이터","index":2,"n_rows":10,"n_cols":6,"rows_kept":10}
[null,"피벗 차트 데이터"]
[null,"이 피벗 테이블은 월간 요약 시트의 계좌 요약 피벗 차트에 대한 데이터 원본입니다."]
[null,"합계 : 금액","열 레이블"]
[null,"행 레이블","당좌","저축","기타","총합계"]
[null,"1월",45000,230000,null,275000]
[null,"2월",123000,null,null,123000]
[null,"3월",230000,100000,null,330000]
[null,"4월",30000,70000,null,100000]
[null,"5월",null,50000,30000,80000]
[null,"총합계",428000,450000,30000,908000]