{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["대시보드","지출 & 수입","예산 보고서","데이터 목록","범주 피벗 테이블"],"not_rendered":{"charts":3,"defined_names":18,"pivot_tables":2},"read":"whole","date_system":"1900"}

{"sheet":"대시보드","index":0,"n_rows":21,"n_cols":16,"rows_kept":21,"merged":[[5,2,5,3],[8,9,8,10],[9,9,9,10],[10,9,10,10]]}
[]
[null,null,"반달분 가계 예산",{"$nulls":12},"대시보드"]
[]
[]
[]
[null,null,{"$f":"CHOOSE(월_번호,\"1월\",\"2월\",\"3월\",\"4월\",\"5월\",\"6월\",\"7월\",\"8월\",\"9월\",\"10월\",\"11월\",\"12월\")","v":"8월"},null,8,{"$nulls":5},2012]
[]
[]
[null,null,"월간 합계","월간 합계",{"$nulls":5},"연간 합계",null,"연간 합계"]
[null,null,"수입","지출",{"$f":"SUMIF(지출[날짜],\"<=\"&월_끝_날짜,지출[금액])-SUMIF(지출[날짜],\"<\"&월_시작_날짜,지출[금액])","v":{"v":0,"d":"₩0"}},{"$nulls":4},"수입",null,"지출",{"$f":"SUM(IF(YEAR(지출[날짜])=K6,지출[금액]))","v":{"v":10242000,"d":"$10,242,000"}}]
[null,null,"지출","수입",{"$f":"SUMIF(수입[날짜],\"<=\"&월_끝_날짜,수입[금액])-SUMIF(수입[날짜],\"<\"&월_시작_날짜,수입[금액])","v":{"v":0,"d":"₩0"}},{"$nulls":4},"지출",null,"수입",{"$f":"SUM(IF(YEAR(수입[날짜])=K6,수입[금액]))","v":{"v":12700000,"d":"$12,700,000"}}]
[]
[]
[]
[]
[]
[{"$nulls":3},"1월","2월","3월","4월","5월","6월","7월","8월","9월","10월","11월","12월"]
[null,null,"수입 1-15",{"$f":"SUMIFS(수입[금액],수입[설명],\"<=\"&중간_날짜,수입[설명],\">=\"&시작_날짜)","v":{"v":0,"d":"₩0"}},{"$f":"SUMIFS(수입[금액],수입[설명],\"<=\"&중간_날짜,수입[설명],\">=\"&시작_날짜)","v":{"v":0,"d":"₩0"}},{"$f":"SUMIFS(수입[금액],수입[설명],\"<=\"&중간_날짜,수입[설명],\">=\"&시작_날짜)","v":{"v":0,"d":"₩0"}},{"$f":"SUMIFS(수입[금액],수입[설명],\"<=\"&중간_날짜,수입[설명],\">=\"&시작_날짜)","v":{"v":0,"d":"₩0"}},{"$f":"SUMIFS(수입[금액],수입[설명],\"<=\"&중간_날짜,수입[설명],\">=\"&시작_날짜)","v":{"v":0,"d":"₩0"}},{"$f":"SUMIFS(수입[금액],수입[설명],\"<=\"&중간_날짜,수입[설명],\">=\"&시작_날짜)","v":{"v":0,"d":"₩0"}},{"$f":"SUMIFS(수입[금액],수입[설명],\"<=\"&중간_날짜,수입[설명],\">=\"&시작_날짜)","v":{"v":0,"d":"₩0"}},{"$f":"SUMIFS(수입[금액],수입[설명],\"<=\"&중간_날짜,수입[설명],\">=\"&시작_날짜)","v":{"v":0,"d":"₩0"}},{"$f":"SUMIFS(수입[금액],수입[설명],\"<=\"&중간_날짜,수입[설명],\">=\"&시작_날짜)","v":{"v":0,"d":"₩0"}},{"$f":"SUMIFS(수입[금액],수입[설명],\"<=\"&중간_날짜,수입[설명],\">=\"&시작_날짜)","v":{"v":0,"d":"₩0"}},{"$f":"SUMIFS(수입[금액],수입[설명],\"<=\"&중간_날짜,수입[설명],\">=\"&시작_날짜)","v":{"v":0,"d":"₩0"}},{"$f":"SUMIFS(수입[금액],수입[설명],\"<=\"&중간_날짜,수입[설명],\">=\"&시작_날짜)","v":{"v":0,"d":"₩0"}}]
[null,null,"수입 16-EOM",{"$f":"SUMIFS(수입[금액],수입[설명],\"<=\"&끝_날짜,수입[설명],\">=\"&중간_날짜+1)","v":{"v":0,"d":"₩0"}},{"$f":"SUMIFS(수입[금액],수입[설명],\"<=\"&끝_날짜,수입[설명],\">=\"&중간_날짜+1)","v":{"v":0,"d":"₩0"}},{"$f":"SUMIFS(수입[금액],수입[설명],\"<=\"&끝_날짜,수입[설명],\">=\"&중간_날짜+1)","v":{"v":0,"d":"₩0"}},{"$f":"SUMIFS(수입[금액],수입[설명],\"<=\"&끝_날짜,수입[설명],\">=\"&중간_날짜+1)","v":{"v":0,"d":"₩0"}},{"$f":"SUMIFS(수입[금액],수입[설명],\"<=\"&끝_날짜,수입[설명],\">=\"&중간_날짜+1)","v":{"v":0,"d":"₩0"}},{"$f":"SUMIFS(수입[금액],수입[설명],\"<=\"&끝_날짜,수입[설명],\">=\"&중간_날짜+1)","v":{"v":0,"d":"₩0"}},{"$f":"SUMIFS(수입[금액],수입[설명],\"<=\"&끝_날짜,수입[설명],\">=\"&중간_날짜+1)","v":{"v":0,"d":"₩0"}},{"$f":"SUMIFS(수입[금액],수입[설명],\"<=\"&끝_날짜,수입[설명],\">=\"&중간_날짜+1)","v":{"v":0,"d":"₩0"}},{"$f":"SUMIFS(수입[금액],수입[설명],\"<=\"&끝_날짜,수입[설명],\">=\"&중간_날짜+1)","v":{"v":0,"d":"₩0"}},{"$f":"SUMIFS(수입[금액],수입[설명],\"<=\"&끝_날짜,수입[설명],\">=\"&중간_날짜+1)","v":{"v":0,"d":"₩0"}},{"$f":"SUMIFS(수입[금액],수입[설명],\"<=\"&끝_날짜,수입[설명],\">=\"&중간_날짜+1)","v":{"v":0,"d":"₩0"}},{"$f":"SUMIFS(수입[금액],수입[설명],\"<=\"&끝_날짜,수입[설명],\">=\"&중간_날짜+1)","v":{"v":0,"d":"₩0"}}]
[null,null,"지출 1-15",{"$f":"SUMIFS(지출[금액],지출[날짜],\"<=\"&중간_날짜,지출[날짜],\">=\"&시작_날짜)","v":{"v":0,"d":"₩0"}},{"$f":"SUMIFS(지출[금액],지출[날짜],\"<=\"&끝_날짜,지출[날짜],\">=\"&시작_날짜)","v":{"v":0,"d":"₩0"}},{"$f":"SUMIFS(지출[금액],지출[날짜],\"<=\"&끝_날짜,지출[날짜],\">=\"&시작_날짜)","v":{"v":0,"d":"₩0"}},{"$f":"SUMIFS(지출[금액],지출[날짜],\"<=\"&끝_날짜,지출[날짜],\">=\"&시작_날짜)","v":{"v":0,"d":"₩0"}},{"$f":"SUMIFS(지출[금액],지출[날짜],\"<=\"&끝_날짜,지출[날짜],\">=\"&시작_날짜)","v":{"v":0,"d":"₩0"}},{"$f":"SUMIFS(지출[금액],지출[날짜],\"<=\"&끝_날짜,지출[날짜],\">=\"&시작_날짜)","v":{"v":0,"d":"₩0"}},{"$f":"SUMIFS(지출[금액],지출[날짜],\"<=\"&끝_날짜,지출[날짜],\">=\"&시작_날짜)","v":{"v":0,"d":"₩0"}},{"$f":"SUMIFS(지출[금액],지출[날짜],\"<=\"&끝_날짜,지출[날짜],\">=\"&시작_날짜)","v":{"v":0,"d":"₩0"}},{"$f":"SUMIFS(지출[금액],지출[날짜],\"<=\"&끝_날짜,지출[날짜],\">=\"&시작_날짜)","v":{"v":1225000,"d":"₩1,225,000"}},{"$f":"SUMIFS(지출[금액],지출[날짜],\"<=\"&끝_날짜,지출[날짜],\">=\"&시작_날짜)","v":{"v":5925000,"d":"₩5,925,000"}},{"$f":"SUMIFS(지출[금액],지출[날짜],\"<=\"&끝_날짜,지출[날짜],\">=\"&시작_날짜)","v":{"v":2792000,"d":"₩2,792,000"}},{"$f":"SUMIFS(지출[금액],지출[날짜],\"<=\"&끝_날짜,지출[날짜],\">=\"&시작_날짜)","v":{"v":0,"d":"₩0"}}]
[null,null,"지출 16-EOM",{"$f":"SUMIFS(지출[금액],지출[날짜],\"<=\"&끝_날짜,지출[날짜],\">=\"&중간_날짜+1)","v":{"v":0,"d":"₩0"}},{"$f":"SUMIFS(지출[금액],지출[날짜],\"<=\"&끝_날짜,지출[날짜],\">=\"&중간_날짜+1)","v":{"v":0,"d":"₩0"}},{"$f":"SUMIFS(지출[금액],지출[날짜],\"<=\"&끝_날짜,지출[날짜],\">=\"&중간_날짜+1)","v":{"v":0,"d":"₩0"}},{"$f":"SUMIFS(지출[금액],지출[날짜],\"<=\"&끝_날짜,지출[날짜],\">=\"&중간_날짜+1)","v":{"v":0,"d":"₩0"}},{"$f":"SUMIFS(지출[금액],지출[날짜],\"<=\"&끝_날짜,지출[날짜],\">=\"&중간_날짜+1)","v":{"v":0,"d":"₩0"}},{"$f":"SUMIFS(지출[금액],지출[날짜],\"<=\"&끝_날짜,지출[날짜],\">=\"&중간_날짜+1)","v":{"v":0,"d":"₩0"}},{"$f":"SUMIFS(지출[금액],지출[날짜],\"<=\"&끝_날짜,지출[날짜],\">=\"&중간_날짜+1)","v":{"v":0,"d":"₩0"}},{"$f":"SUMIFS(지출[금액],지출[날짜],\"<=\"&끝_날짜,지출[날짜],\">=\"&중간_날짜+1)","v":{"v":0,"d":"₩0"}},{"$f":"SUMIFS(지출[금액],지출[날짜],\"<=\"&끝_날짜,지출[날짜],\">=\"&중간_날짜+1)","v":{"v":100000,"d":"₩100,000"}},{"$f":"SUMIFS(지출[금액],지출[날짜],\"<=\"&끝_날짜,지출[날짜],\">=\"&중간_날짜+1)","v":{"v":775000,"d":"₩775,000"}},{"$f":"SUMIFS(지출[금액],지출[날짜],\"<=\"&끝_날짜,지출[날짜],\">=\"&중간_날짜+1)","v":{"v":0,"d":"₩0"}},{"$f":"SUMIFS(지출[금액],지출[날짜],\"<=\"&끝_날짜,지출[날짜],\">=\"&중간_날짜+1)","v":{"v":0,"d":"₩0"}}]

{"sheet":"지출 & 수입","index":1,"n_rows":40,"n_cols":10,"rows_kept":40}
[]
[null,null,"반달분 가계 예산",{"$nulls":6},"수입 & 지출"]
[]
[]
[]
[null,null,"수입",{"$nulls":3},"지출"]
[]
[null,null,"날짜","설명","금액",null,"날짜","범주","설명","금액"]
[null,null,{"$f":"NOW()-14","v":"2012-12-06T21:34:03.390"},"강재석의 급여",{"v":1300000,"d":"₩1,300,000"},null,{"$f":"NOW()-7","v":"2012-12-13T21:34:03.390"},"주거비","대출금 상환",{"v":1000000,"d":"₩1,000,000"}]
[null,null,{"$f":"NOW()-14","v":"2012-12-06T21:34:03.390"},"조경희의 급여",{"v":1300000,"d":"₩1,300,000"},null,{"$f":"NOW()-7","v":"2012-12-13T21:34:03.390"},"주거비","전기",{"v":100000,"d":"₩100,000"}]
[null,null,{"$f":"NOW()-28","v":"2012-11-22T21:34:03.390"},"강재석의 급여",{"v":1500000,"d":"₩1,500,000"},null,"2012-12-13T21:34:03.390","주거비","수도/하수 처리",{"v":50000,"d":"₩50,000"}]
[null,null,"2012-11-22T21:34:03.390","조경희의 급여",{"v":1600000,"d":"₩1,600,000"},null,"2012-12-13T21:34:03.390","주거비","쓰레기 수거",{"v":25000,"d":"₩25,000"}]
[null,null,{"$f":"NOW()-42","v":"2012-11-08T21:34:03.390"},"강재석의 급여",{"v":1300000,"d":"₩1,300,000"},null,"2012-12-13T21:34:03.390","주거비","휴대폰",{"v":100000,"d":"₩100,000"}]
[null,null,"2012-11-08T21:34:03.390","조경희의 급여",{"v":1300000,"d":"₩1,300,000"},null,"2012-12-13T21:34:03.390","주거비","집 전화",{"v":30000,"d":"₩30,000"}]
[null,null,{"$f":"NOW()-56","v":"2012-10-25T21:34:03.390"},"강재석의 급여",{"v":1500000,"d":"₩1,500,000"},null,"2012-12-13T21:34:03.390","주거비","인터넷",{"v":50000,"d":"₩50,000"}]
[null,null,"2012-10-25T21:34:03.390","조경희의 급여",{"v":1600000,"d":"₩1,600,000"},null,"2012-12-13T21:34:03.390","주거비","TV",{"v":50000,"d":"₩50,000"}]
[null,null,{"$f":"NOW()-70","v":"2012-10-11T21:34:03.390"},"강재석의 급여",{"v":1300000,"d":"₩1,300,000"},null,"2012-12-13T21:34:03.390","주거비","유지 관리/수리",{"v":25000,"d":"₩25,000"}]
[{"$nulls":6},{"$f":"NOW()-8","v":"2012-12-12T21:34:03.390"},"주거비","신용 카드 1 ",{"v":100000,"d":"₩100,000"}]
[{"$nulls":6},{"$f":"NOW()-9","v":"2012-12-11T21:34:03.390"},"여가비","영화",{"v":37000,"d":"₩37,000"}]
[{"$nulls":6},{"$f":"NOW()-10","v":"2012-12-10T21:34:03.390"},"식비","식료품",{"v":350000,"d":"₩350,000"}]
[{"$nulls":6},{"$f":"NOW()-11","v":"2012-12-09T21:34:03.390"},"식비","외식비",{"v":75000,"d":"₩75,000"}]
[{"$nulls":6},{"$f":"NOW()-12","v":"2012-12-08T21:34:03.390"},"양육비","점심 식대",{"v":150000,"d":"₩150,000"}]
[{"$nulls":6},{"$f":"NOW()-13","v":"2012-12-07T21:34:03.390"},"투자 계정","저축",{"v":250000,"d":"₩250,000"}]
[{"$nulls":6},{"$f":"NOW()-14","v":"2012-12-06T21:34:03.390"},"투자 계정","투자 계정",{"v":250000,"d":"₩250,000"}]
[{"$nulls":6},{"$f":"NOW()-15","v":"2012-12-05T21:34:03.390"},"개인 용돈","건강/헬스 클럽",{"v":100000,"d":"₩100,000"}]
[{"$nulls":6},{"$f":"NOW()-16","v":"2012-12-04T21:34:03.390"},"애완 동물","식비",{"v":50000,"d":"₩50,000"}]
[{"$nulls":6},{"$f":"NOW()-20","v":"2012-11-30T21:34:03.390"},"애완 동물","미용",{"v":50000,"d":"₩50,000"}]
[{"$nulls":6},{"$f":"NOW()-20","v":"2012-11-30T21:34:03.390"},"애완 동물","기타",{"v":50000,"d":"₩50,000"}]
[{"$nulls":6},{"$f":"NOW()-25","v":"2012-11-25T21:34:03.390"},"교통","자동차 1 할부금 ",{"v":300000,"d":"₩300,000"}]
[{"$nulls":6},{"$f":"NOW()-25","v":"2012-11-25T21:34:03.390"},"교통","자동차 2 할부금 ",{"v":350000,"d":"₩350,000"}]
[{"$nulls":6},{"$f":"NOW()-25","v":"2012-11-25T21:34:03.390"},"교통","자동차 보험",{"v":50000,"d":"₩50,000"}]
[{"$nulls":6},{"$f":"NOW()-30","v":"2012-11-20T21:34:03.390"},"교통","연료",{"v":50000,"d":"₩50,000"}]
[{"$nulls":6},{"$f":"NOW()-31","v":"2012-11-19T21:34:03.390"},"교통","연료",{"v":25000,"d":"₩25,000"}]
[{"$nulls":6},{"$f":"NOW()-42","v":"2012-11-08T21:34:03.390"},"교통","유지 관리/수리",{"v":150000,"d":"₩150,000"}]
[{"$nulls":6},{"$f":"NOW()-45","v":"2012-11-05T21:34:03.390"},"주거비","대출금 상환",{"v":5000000,"d":"₩5,000,000"}]
[{"$nulls":6},{"$f":"NOW()-50","v":"2012-10-31T21:34:03.390"},"주거비","소모품",{"v":200000,"d":"₩200,000"}]
[{"$nulls":6},{"$f":"NOW()-65","v":"2012-10-16T21:34:03.390"},"주거비","집 전화",{"v":100000,"d":"₩100,000"}]
[{"$nulls":6},{"$f":"NOW()-70","v":"2012-10-11T21:34:03.390"},"주거비","쓰레기 수거",{"v":50000,"d":"₩50,000"}]
[{"$nulls":6},{"$f":"NOW()-75","v":"2012-10-06T21:34:03.390"},"주거비","대출금 상환",{"v":1000000,"d":"₩1,000,000"}]
[{"$nulls":6},{"$f":"NOW()-78","v":"2012-10-03T21:34:03.390"},"여가비","영화",{"v":75000,"d":"₩75,000"}]

{"sheet":"예산 보고서","index":2,"n_rows":41,"n_cols":8,"rows_kept":41}
[]
[null,null,"반달분 가계 예산",{"$nulls":4},"수입 & 지출"]
{"$rows_empty":10}
[null,null,"지출",null,null,"범주 합계"]
[]
[null,null,"설명","합계"]
[null,null,"자동차 1 할부금 ",{"v":300000,"d":"₩300,000"}]
[null,null,"자동차 2 할부금 ",{"v":350000,"d":"₩350,000"}]
[null,null,"자동차 보험",{"v":50000,"d":"₩50,000"}]
[null,null,"휴대폰",{"v":100000,"d":"₩100,000"}]
[null,null,"신용 카드 1 ",{"v":100000,"d":"₩100,000"}]
[null,null,"외식비",{"v":75000,"d":"₩75,000"}]
[null,null,"전기",{"v":100000,"d":"₩100,000"}]
[null,null,"식비",{"v":50000,"d":"₩50,000"}]
[null,null,"연료",{"v":75000,"d":"₩75,000"}]
[null,null,"쓰레기 수거",{"v":75000,"d":"₩75,000"}]
[null,null,"식료품",{"v":350000,"d":"₩350,000"}]
[null,null,"미용",{"v":50000,"d":"₩50,000"}]
[null,null,"건강/헬스 클럽",{"v":100000,"d":"₩100,000"}]
[null,null,"집 전화",{"v":130000,"d":"₩130,000"}]
[null,null,"인터넷",{"v":50000,"d":"₩50,000"}]
[null,null,"투자 계정",{"v":250000,"d":"₩250,000"}]
[null,null,"점심 식대",{"v":150000,"d":"₩150,000"}]
[null,null,"유지 관리/수리",{"v":175000,"d":"₩175,000"}]
[null,null,"대출금 상환",{"v":7000000,"d":"₩7,000,000"}]
[null,null,"영화",{"v":112000,"d":"₩112,000"}]
[null,null,"기타",{"v":50000,"d":"₩50,000"}]
[null,null,"저축",{"v":250000,"d":"₩250,000"}]
[null,null,"TV",{"v":50000,"d":"₩50,000"}]
[null,null,"수도/하수 처리",{"v":50000,"d":"₩50,000"}]
[null,null,"소모품",{"v":200000,"d":"₩200,000"}]
[null,null,"합계",{"v":10242000,"d":"₩10,242,000"}]

{"sheet":"데이터 목록","index":3,"n_rows":20,"n_cols":14,"rows_kept":20}
[]
[null,null,"반달분 가계 예산",{"$nulls":10},"데이터 목록"]
[]
[]
[null,null,"설정         아래 범주 데이터는 지출 & 수입 시트의 지출 표에 나와 있는 드롭다운 목록을 채웁니다. 목록을 업데이트하려면 각 범주 아래에 있는 범주 이름이나 설명을 수정하세요."]
[]
[null,null,"주거비","여가비","식비","선물/기부","양육비","투자 계정","의료","기타","개인 용돈","애완 동물","세무/법무","교통"]
[null,null,"대출금 상환","영화","식료품","자선 기부금 1","의복","연금","진료/클리닉","기타","의복","식비","국세","자동차 1 할부금 "]
[null,null,"전기","비디오/영화","외식비","자선 기부금 2","장난감/게임","저축","보험","협회비","미용/손톱 관리","소모품","지방세","자동차 2 할부금 "]
[null,null,"수도/하수 처리","음악",null,"자선 기부금 3","점심 식대","당좌",null,null,"드라이클리닝","의료","국세","자동차 보험"]
[null,null,"쓰레기 수거","콘서트/연극",null,"선물","회비/요금","연금",null,null,"건강/헬스 클럽","미용","기타","면허/등록"]
[null,null,"휴대폰","운동 경기",null,null,"학용품","투자 계정",null,null,"쇼핑","기타","변호사 수임료","연료"]
[null,null,"집 전화","기타",null,null,"기타","학자금",null,null,"기타",null,"아동 지원","유지 관리/수리"]
[null,null,"인터넷",{"$nulls":3},"세탁비","대출",{"$nulls":4},"위자료","대중 교통"]
[null,null,"TV",{"$nulls":4},"학자금 대출",{"$nulls":4},"기타"]
[null,null,"유지 관리/수리"]
[null,null,"소모품"]
[null,null,"케이블/인터넷/전화"]
[null,null,"신용 카드 1 "]
[null,null,"신용 카드 2 "]

{"sheet":"범주 피벗 테이블","index":4,"n_rows":16,"n_cols":14,"rows_kept":16,"hidden":true}
[]
[null,null,"범주 피벗 테이블",{"$nulls":10},"범주 피벗"]
[]
[]
[null,"이 피벗 테이블은 예산 보고서의 범주 합계 피벗 차트에 대한 데이터 원본입니다. "]
[]
[null,null,"행 레이블","합계 : 금액"]
[null,null,"양육비",{"v":150000,"d":"₩150,000"}]
[null,null,"여가비",{"v":112000,"d":"₩112,000"}]
[null,null,"식비",{"v":425000,"d":"₩425,000"}]
[null,null,"주거비",{"v":7880000,"d":"₩7,880,000"}]
[null,null,"투자 계정",{"v":500000,"d":"₩500,000"}]
[null,null,"개인 용돈",{"v":100000,"d":"₩100,000"}]
[null,null,"애완 동물",{"v":150000,"d":"₩150,000"}]
[null,null,"교통",{"v":925000,"d":"₩925,000"}]
[null,null,"총합계",{"v":10242000,"d":"₩10,242,000"}]