{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["시작","계획한 지출","실제 지출","지출 차이","지출 분석"],"not_rendered":{"charts":3,"images":3,"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"시작","index":0,"n_rows":8,"n_cols":2,"rows_kept":8}
[null,"이 서식 파일 정보"]
[null,"이 비즈니스 비용 예산 통합 문서를 사용하여 계획한 지출과 실제 지출 및 차이를 추적할 수 있습니다."]
[null,"회사 이름을 입력하고 로고를 추가하세요."]
[null,"계획한 지출 워크시트와 실제 지출 워크시트의 표에 세부 정보를 입력합니다."]
[null,"표는 지출 차이 워크시트와 지출 분석 워크시트의 차트에서 자동으로 업데이트됩니다."]
[null,"참고: "]
[null,"추가적인 지침은 각 워크시트의 A열에 있으며, 이 텍스트는 일부러 숨겨 놓았습니다. 텍스트를 제거하려면 A열을 선택한 다음 [삭제]를 선택합니다. 텍스트를 표시하려면 A열을 선택한 다음 글꼴 색상을 변경합니다."]
[null,"표에 대해 자세히 알려면 표 안에서 SHIFT 키를 누른 채 F10 키를 누르고 [표] 옵션을 선택한 다음, [대체 텍스트]를 선택합니다."]

{"sheet":"계획한 지출","index":1,"n_rows":37,"n_cols":18,"rows_kept":37,"merged":[[1,1,2,3],[1,10,1,12],[1,13,2,14],[2,10,2,12],[3,17,12,19],[8,1,8,2],[19,1,19,2],[28,1,28,2],[33,1,33,2]]}
["이 워크시트의 각 표에 계획한 직원 비용, 사무 비용, 마케팅 비용 및 교육 또는 출장 비용을 입력합니다. 합계는 자동으로 계산됩니다. 이 워크시트의 사용 방법에 대한 유용한 지침은 이 열의 셀에 있습니다. 아래쪽 화살표를 사용하여 시작할 수 있습니다.",{"$nulls":14}," "]
["오른쪽 셀에 회사 이름을 입력하고 N2 셀에 로고를 입력합니다. K2 셀에는 이 워크시트의 제목이 표시됩니다.","회사 이름",{"$nulls":8},"세부 지출 예상 항목",null,null,"이 셀에는 로고 자리 표시자가 있습니다."]
["K3 셀에 팁이 표시됩니다.",{"$nulls":9},"음영 처리된 셀은 계산 결과입니다."]
["오른쪽 셀에는 [계획한 지출] 레이블, C4 ~ N4 셀에는 월, O4 셀에는 [연도] 레이블, R4 셀에는 이 템플릿을 사용하는 방법이 있습니다.","계획한 지출","1월","2월","3월","4월","5월","6월","7월","8월","9월","10월","11월","12월","연도",null,null,"팁: 이 서식 파일을 사용하는 방법\n[계획한 지출]과 [실제 지출] 워크시트의 흰색 셀에 입력 데이터를 입력하면 [지출 차이]와 [지출 분석]이 자동으로 계산됩니다. 한 시트에 행을 추가하는 경우 다른 시트도 일치해야 합니다."]
["오른쪽 셀에서 시작하는 직원 계획 표에서 직원 비용을 입력합니다. 다음 지침은 A10 셀에 있습니다.","직원 비용","1월","2월","3월","4월","5월","6월","7월","8월","9월","10월","11월","12월","연도"]
[null,"급여",{"v":85000,"d":"₩85,000.00"},{"v":85000,"d":"₩85,000.00"},{"v":85000,"d":"₩85,000.00"},{"v":87500,"d":"₩87,500.00"},{"v":87500,"d":"₩87,500.00"},{"v":87500,"d":"₩87,500.00"},{"v":87500,"d":"₩87,500.00"},{"v":92400,"d":"₩92,400.00"},{"v":92400,"d":"₩92,400.00"},{"v":92400,"d":"₩92,400.00"},{"v":92400,"d":"₩92,400.00"},{"v":92400,"d":"₩92,400.00"},{"$f":"SUM(C6:N6)","v":{"v":1067000,"d":"₩1,067,000.00"}}]
[null,"복지",{"$f":"C6*0.27","v":{"v":22950,"d":"₩22,950.00"}},{"v":22950,"d":"₩22,950.00"},{"v":22950,"d":"₩22,950.00"},{"v":23625,"d":"₩23,625.00"},{"v":23625,"d":"₩23,625.00"},{"v":23625,"d":"₩23,625.00"},{"v":23625,"d":"₩23,625.00"},{"v":24948,"d":"₩24,948.00"},{"v":24948,"d":"₩24,948.00"},{"v":24948,"d":"₩24,948.00"},{"v":24948,"d":"₩24,948.00"},{"v":24948,"d":"₩24,948.00"},{"$f":"SUM(C7:N7)","v":{"v":288090,"d":"₩288,090.00"}}]
[null,"소계",{"$f":"SUBTOTAL(109,EmployeePlan[1월])","v":{"v":107950,"d":"₩107,950.00"}},{"$f":"SUBTOTAL(109,EmployeePlan[2월])","v":{"v":107950,"d":"₩107,950.00"}},{"$f":"SUBTOTAL(109,EmployeePlan[3월])","v":{"v":107950,"d":"₩107,950.00"}},{"$f":"SUBTOTAL(109,EmployeePlan[4월])","v":{"v":111125,"d":"₩111,125.00"}},{"$f":"SUBTOTAL(109,EmployeePlan[5월])","v":{"v":111125,"d":"₩111,125.00"}},{"$f":"SUBTOTAL(109,EmployeePlan[6월])","v":{"v":111125,"d":"₩111,125.00"}},{"$f":"SUBTOTAL(109,EmployeePlan[7월])","v":{"v":111125,"d":"₩111,125.00"}},{"$f":"SUBTOTAL(109,EmployeePlan[8월])","v":{"v":117348,"d":"₩117,348.00"}},{"$f":"SUBTOTAL(109,EmployeePlan[9월])","v":{"v":117348,"d":"₩117,348.00"}},{"$f":"SUBTOTAL(109,EmployeePlan[10월])","v":{"v":117348,"d":"₩117,348.00"}},{"$f":"SUBTOTAL(109,EmployeePlan[11월])","v":{"v":117348,"d":"₩117,348.00"}},{"$f":"SUBTOTAL(109,EmployeePlan[12월])","v":{"v":117348,"d":"₩117,348.00"}},{"$f":"SUBTOTAL(109,EmployeePlan[연도])","v":{"v":1355090,"d":"₩1,355,090.00"}}]
[]
["오른쪽 셀에서 시작하는 사무 계획 표에서 사무 비용을 입력합니다. 다음 지침은 A21 셀에 있습니다.","사무 비용","1월","2월","3월","4월","5월","6월","7월","8월","9월","10월","11월","12월","연도"]
[null,"사무실 임대",{"v":9800,"d":"₩9,800.00"},{"v":9800,"d":"₩9,800.00"},{"v":9800,"d":"₩9,800.00"},{"v":9800,"d":"₩9,800.00"},{"v":9800,"d":"₩9,800.00"},{"v":9800,"d":"₩9,800.00"},{"v":9800,"d":"₩9,800.00"},{"v":9800,"d":"₩9,800.00"},{"v":9800,"d":"₩9,800.00"},{"v":9800,"d":"₩9,800.00"},{"v":9800,"d":"₩9,800.00"},{"v":9800,"d":"₩9,800.00"},{"$f":"SUM(C11:N11)","v":{"v":117600,"d":"₩117,600.00"}}]
[null,"가스",null,{"v":400,"d":"₩400.00"},{"v":400,"d":"₩400.00"},{"v":100,"d":"₩100.00"},{"v":100,"d":"₩100.00"},{"v":100,"d":"₩100.00"},{"v":100,"d":"₩100.00"},{"v":100,"d":"₩100.00"},{"v":100,"d":"₩100.00"},{"v":100,"d":"₩100.00"},{"v":400,"d":"₩400.00"},{"v":400,"d":"₩400.00"},{"v":2300,"d":"₩2,300.00"}]
[null,"전기",{"v":300,"d":"₩300.00"},{"v":300,"d":"₩300.00"},{"v":300,"d":"₩300.00"},{"v":300,"d":"₩300.00"},{"v":300,"d":"₩300.00"},{"v":300,"d":"₩300.00"},{"v":300,"d":"₩300.00"},{"v":300,"d":"₩300.00"},{"v":300,"d":"₩300.00"},{"v":300,"d":"₩300.00"},{"v":300,"d":"₩300.00"},{"v":300,"d":"₩300.00"},{"v":3600,"d":"₩3,600.00"}]
[null,"수도",{"v":40,"d":"₩40.00"},{"v":40,"d":"₩40.00"},{"v":40,"d":"₩40.00"},{"v":40,"d":"₩40.00"},{"v":40,"d":"₩40.00"},{"v":40,"d":"₩40.00"},{"v":40,"d":"₩40.00"},{"v":40,"d":"₩40.00"},{"v":40,"d":"₩40.00"},{"v":40,"d":"₩40.00"},{"v":40,"d":"₩40.00"},{"v":40,"d":"₩40.00"},{"v":480,"d":"₩480.00"}]
[null,"전화",{"v":250,"d":"₩250.00"},{"v":250,"d":"₩250.00"},{"v":250,"d":"₩250.00"},{"v":250,"d":"₩250.00"},{"v":250,"d":"₩250.00"},{"v":250,"d":"₩250.00"},{"v":250,"d":"₩250.00"},{"v":250,"d":"₩250.00"},{"v":250,"d":"₩250.00"},{"v":250,"d":"₩250.00"},{"v":250,"d":"₩250.00"},{"v":250,"d":"₩250.00"},{"v":3000,"d":"₩3,000.00"}]
[null,"인터넷 사용",{"v":180,"d":"₩180.00"},{"v":180,"d":"₩180.00"},{"v":180,"d":"₩180.00"},{"v":180,"d":"₩180.00"},{"v":180,"d":"₩180.00"},{"v":180,"d":"₩180.00"},{"v":180,"d":"₩180.00"},{"v":180,"d":"₩180.00"},{"v":180,"d":"₩180.00"},{"v":180,"d":"₩180.00"},{"v":180,"d":"₩180.00"},{"v":180,"d":"₩180.00"},{"v":2160,"d":"₩2,160.00"}]
[null,"사무용품",{"v":200,"d":"₩200.00"},{"v":200,"d":"₩200.00"},{"v":200,"d":"₩200.00"},{"v":200,"d":"₩200.00"},{"v":200,"d":"₩200.00"},{"v":200,"d":"₩200.00"},{"v":200,"d":"₩200.00"},{"v":200,"d":"₩200.00"},{"v":200,"d":"₩200.00"},{"v":200,"d":"₩200.00"},{"v":200,"d":"₩200.00"},{"v":200,"d":"₩200.00"},{"v":2400,"d":"₩2,400.00"}]
[null,"보안",{"v":600,"d":"₩600.00"},{"v":600,"d":"₩600.00"},{"v":600,"d":"₩600.00"},{"v":600,"d":"₩600.00"},{"v":600,"d":"₩600.00"},{"v":600,"d":"₩600.00"},{"v":600,"d":"₩600.00"},{"v":600,"d":"₩600.00"},{"v":600,"d":"₩600.00"},{"v":600,"d":"₩600.00"},{"v":600,"d":"₩600.00"},{"v":600,"d":"₩600.00"},{"v":7200,"d":"₩7,200.00"}]
[null,"소계",{"$f":"SUBTOTAL(109,OfficePlan[1월])","v":{"v":11370,"d":"₩11,370.00"}},{"$f":"SUBTOTAL(109,OfficePlan[2월])","v":{"v":11770,"d":"₩11,770.00"}},{"$f":"SUBTOTAL(109,OfficePlan[3월])","v":{"v":11770,"d":"₩11,770.00"}},{"$f":"SUBTOTAL(109,OfficePlan[4월])","v":{"v":11470,"d":"₩11,470.00"}},{"$f":"SUBTOTAL(109,OfficePlan[5월])","v":{"v":11470,"d":"₩11,470.00"}},{"$f":"SUBTOTAL(109,OfficePlan[6월])","v":{"v":11470,"d":"₩11,470.00"}},{"$f":"SUBTOTAL(109,OfficePlan[7월])","v":{"v":11470,"d":"₩11,470.00"}},{"$f":"SUBTOTAL(109,OfficePlan[8월])","v":{"v":11470,"d":"₩11,470.00"}},{"$f":"SUBTOTAL(109,OfficePlan[9월])","v":{"v":11470,"d":"₩11,470.00"}},{"$f":"SUBTOTAL(109,OfficePlan[10월])","v":{"v":11470,"d":"₩11,470.00"}},{"$f":"SUBTOTAL(109,OfficePlan[11월])","v":{"v":11770,"d":"₩11,770.00"}},{"$f":"SUBTOTAL(109,OfficePlan[12월])","v":{"v":11770,"d":"₩11,770.00"}},{"$f":"SUBTOTAL(109,OfficePlan[연도])","v":{"v":138740,"d":"₩138,740.00"}}]
[]
["오른쪽 셀에서 시작하는 마케팅 계획 표에서 마케팅 비용을 입력합니다. 다음 지침은 A30 셀에 있습니다.","마케팅 비용","1월","2월","3월","4월","5월","6월","7월","8월","9월","10월","11월","12월","연도"]
[null,"웹 사이트 호스팅",{"v":500,"d":"₩500.00"},{"v":500,"d":"₩500.00"},{"v":500,"d":"₩500.00"},{"v":500,"d":"₩500.00"},{"v":500,"d":"₩500.00"},{"v":500,"d":"₩500.00"},{"v":500,"d":"₩500.00"},{"v":500,"d":"₩500.00"},{"v":500,"d":"₩500.00"},{"v":500,"d":"₩500.00"},{"v":500,"d":"₩500.00"},{"v":500,"d":"₩500.00"},{"$f":"SUM(C22:N22)","v":{"v":6000,"d":"₩6,000.00"}}]
[null,"웹 사이트 업데이트",{"v":200,"d":"₩200.00"},{"v":200,"d":"₩200.00"},{"v":200,"d":"₩200.00"},{"v":200,"d":"₩200.00"},{"v":200,"d":"₩200.00"},{"v":1000,"d":"₩1,000.00"},{"v":200,"d":"₩200.00"},{"v":200,"d":"₩200.00"},{"v":200,"d":"₩200.00"},{"v":200,"d":"₩200.00"},{"v":200,"d":"₩200.00"},{"v":1000,"d":"₩1,000.00"},{"v":4000,"d":"₩4,000.00"}]
[null,"자료 준비",{"v":5000,"d":"₩5,000.00"},{"v":0,"d":"₩0.00"},{"v":0,"d":"₩0.00"},{"v":5000,"d":"₩5,000.00"},{"v":0,"d":"₩0.00"},{"v":0,"d":"₩0.00"},{"v":5000,"d":"₩5,000.00"},{"v":0,"d":"₩0.00"},{"v":0,"d":"₩0.00"},{"v":5000,"d":"₩5,000.00"},{"v":0,"d":"₩0.00"},{"v":0,"d":"₩0.00"},{"v":20000,"d":"₩20,000.00"}]
[null,"자료 인쇄",{"v":200,"d":"₩200.00"},{"v":200,"d":"₩200.00"},{"v":200,"d":"₩200.00"},{"v":200,"d":"₩200.00"},{"v":200,"d":"₩200.00"},{"v":200,"d":"₩200.00"},{"v":200,"d":"₩200.00"},{"v":200,"d":"₩200.00"},{"v":200,"d":"₩200.00"},{"v":200,"d":"₩200.00"},{"v":200,"d":"₩200.00"},{"v":200,"d":"₩200.00"},{"v":2400,"d":"₩2,400.00"}]
[null,"마케팅 행사",{"v":2000,"d":"₩2,000.00"},{"v":2000,"d":"₩2,000.00"},{"v":2000,"d":"₩2,000.00"},{"v":5000,"d":"₩5,000.00"},{"v":2000,"d":"₩2,000.00"},{"v":2000,"d":"₩2,000.00"},{"v":2000,"d":"₩2,000.00"},{"v":5000,"d":"₩5,000.00"},{"v":2000,"d":"₩2,000.00"},{"v":2000,"d":"₩2,000.00"},{"v":2000,"d":"₩2,000.00"},{"v":5000,"d":"₩5,000.00"},{"v":33000,"d":"₩33,000.00"}]
[null,"기타 비용",{"v":200,"d":"₩200.00"},{"v":200,"d":"₩200.00"},{"v":200,"d":"₩200.00"},{"v":200,"d":"₩200.00"},{"v":200,"d":"₩200.00"},{"v":200,"d":"₩200.00"},{"v":200,"d":"₩200.00"},{"v":200,"d":"₩200.00"},{"v":200,"d":"₩200.00"},{"v":200,"d":"₩200.00"},{"v":200,"d":"₩200.00"},{"v":200,"d":"₩200.00"},{"v":2400,"d":"₩2,400.00"}]
[null,"소계",{"$f":"SUBTOTAL(109,MarketingPlan[1월])","v":{"v":8100,"d":"₩8,100.00"}},{"$f":"SUBTOTAL(109,MarketingPlan[2월])","v":{"v":3100,"d":"₩3,100.00"}},{"$f":"SUBTOTAL(109,MarketingPlan[3월])","v":{"v":3100,"d":"₩3,100.00"}},{"$f":"SUBTOTAL(109,MarketingPlan[4월])","v":{"v":11100,"d":"₩11,100.00"}},{"$f":"SUBTOTAL(109,MarketingPlan[5월])","v":{"v":3100,"d":"₩3,100.00"}},{"$f":"SUBTOTAL(109,MarketingPlan[6월])","v":{"v":3900,"d":"₩3,900.00"}},{"$f":"SUBTOTAL(109,MarketingPlan[7월])","v":{"v":8100,"d":"₩8,100.00"}},{"$f":"SUBTOTAL(109,MarketingPlan[8월])","v":{"v":6100,"d":"₩6,100.00"}},{"$f":"SUBTOTAL(109,MarketingPlan[9월])","v":{"v":3100,"d":"₩3,100.00"}},{"$f":"SUBTOTAL(109,MarketingPlan[10월])","v":{"v":8100,"d":"₩8,100.00"}},{"$f":"SUBTOTAL(109,MarketingPlan[11월])","v":{"v":3100,"d":"₩3,100.00"}},{"$f":"SUBTOTAL(109,MarketingPlan[12월])","v":{"v":6900,"d":"₩6,900.00"}},{"$f":"SUBTOTAL(109,MarketingPlan[연도])","v":{"v":67800,"d":"₩67,800.00"}}]
[]
["오른쪽 셀에서 시작하는 교육 및 출장 계획 표에서 교육 및 출장 비용을 입력합니다. 다음 지침은 A35 셀에 있습니다.","교육/출장","1월","2월","3월","4월","5월","6월","7월","8월","9월","10월","11월","12월","연도"]
[null,"교육 수업",{"v":2000,"d":"₩2,000.00"},{"v":2000,"d":"₩2,000.00"},{"v":2000,"d":"₩2,000.00"},{"v":2000,"d":"₩2,000.00"},{"v":2000,"d":"₩2,000.00"},{"v":2000,"d":"₩2,000.00"},{"v":2000,"d":"₩2,000.00"},{"v":2000,"d":"₩2,000.00"},{"v":2000,"d":"₩2,000.00"},{"v":2000,"d":"₩2,000.00"},{"v":2000,"d":"₩2,000.00"},{"v":2000,"d":"₩2,000.00"},{"$f":"SUM(C31:N31)","v":{"v":24000,"d":"₩24,000.00"}}]
[null,"교육 관련 출장 비용",{"v":2000,"d":"₩2,000.00"},{"v":2000,"d":"₩2,000.00"},{"v":2000,"d":"₩2,000.00"},{"v":2000,"d":"₩2,000.00"},{"v":2000,"d":"₩2,000.00"},{"v":2000,"d":"₩2,000.00"},{"v":2000,"d":"₩2,000.00"},{"v":2000,"d":"₩2,000.00"},{"v":2000,"d":"₩2,000.00"},{"v":2000,"d":"₩2,000.00"},{"v":2000,"d":"₩2,000.00"},{"v":2000,"d":"₩2,000.00"},{"$f":"SUM(C32:N32)","v":{"v":24000,"d":"₩24,000.00"}}]
[null,"소계",{"$f":"SUBTOTAL(109,TrainingAndTravelPlan[1월])","v":{"v":4000,"d":"₩4,000.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelPlan[2월])","v":{"v":4000,"d":"₩4,000.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelPlan[3월])","v":{"v":4000,"d":"₩4,000.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelPlan[4월])","v":{"v":4000,"d":"₩4,000.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelPlan[5월])","v":{"v":4000,"d":"₩4,000.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelPlan[6월])","v":{"v":4000,"d":"₩4,000.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelPlan[7월])","v":{"v":4000,"d":"₩4,000.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelPlan[8월])","v":{"v":4000,"d":"₩4,000.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelPlan[9월])","v":{"v":4000,"d":"₩4,000.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelPlan[10월])","v":{"v":4000,"d":"₩4,000.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelPlan[11월])","v":{"v":4000,"d":"₩4,000.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelPlan[12월])","v":{"v":4000,"d":"₩4,000.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelPlan[연도])","v":{"v":48000,"d":"₩48,000.00"}}]
[]
["오른쪽 셀에서 시작하는 계획 합계 표에 합계가 자동으로 계산됩니다.","합계","1월","2월","3월","4월","5월","6월","7월","8월","9월","10월","11월","12월","연도"]
[null,"월별 계획된 지출",{"$f":"TrainingAndTravelPlan[[#Totals],[1월]]+MarketingPlan[[#Totals],[1월]]+OfficePlan[[#Totals],[1월]]+EmployeePlan[[#Totals],[1월]]","v":{"v":131420,"d":"₩131,420.00"}},{"$f":"TrainingAndTravelPlan[[#Totals],[2월]]+MarketingPlan[[#Totals],[2월]]+OfficePlan[[#Totals],[2월]]+EmployeePlan[[#Totals],[2월]]","v":{"v":126820,"d":"₩126,820.00"}},{"$f":"TrainingAndTravelPlan[[#Totals],[3월]]+MarketingPlan[[#Totals],[3월]]+OfficePlan[[#Totals],[3월]]+EmployeePlan[[#Totals],[3월]]","v":{"v":126820,"d":"₩126,820.00"}},{"$f":"TrainingAndTravelPlan[[#Totals],[4월]]+MarketingPlan[[#Totals],[4월]]+OfficePlan[[#Totals],[4월]]+EmployeePlan[[#Totals],[4월]]","v":{"v":137695,"d":"₩137,695.00"}},{"$f":"TrainingAndTravelPlan[[#Totals],[5월]]+MarketingPlan[[#Totals],[5월]]+OfficePlan[[#Totals],[5월]]+EmployeePlan[[#Totals],[5월]]","v":{"v":129695,"d":"₩129,695.00"}},{"$f":"TrainingAndTravelPlan[[#Totals],[6월]]+MarketingPlan[[#Totals],[6월]]+OfficePlan[[#Totals],[6월]]+EmployeePlan[[#Totals],[6월]]","v":{"v":130495,"d":"₩130,495.00"}},{"$f":"TrainingAndTravelPlan[[#Totals],[7월]]+MarketingPlan[[#Totals],[7월]]+OfficePlan[[#Totals],[7월]]+EmployeePlan[[#Totals],[7월]]","v":{"v":134695,"d":"₩134,695.00"}},{"$f":"TrainingAndTravelPlan[[#Totals],[8월]]+MarketingPlan[[#Totals],[8월]]+OfficePlan[[#Totals],[8월]]+EmployeePlan[[#Totals],[8월]]","v":{"v":138918,"d":"₩138,918.00"}},{"$f":"TrainingAndTravelPlan[[#Totals],[9월]]+MarketingPlan[[#Totals],[9월]]+OfficePlan[[#Totals],[9월]]+EmployeePlan[[#Totals],[9월]]","v":{"v":135918,"d":"₩135,918.00"}},{"$f":"TrainingAndTravelPlan[[#Totals],[10월]]+MarketingPlan[[#Totals],[10월]]+OfficePlan[[#Totals],[10월]]+EmployeePlan[[#Totals],[10월]]","v":{"v":140918,"d":"₩140,918.00"}},{"$f":"TrainingAndTravelPlan[[#Totals],[11월]]+MarketingPlan[[#Totals],[11월]]+OfficePlan[[#Totals],[11월]]+EmployeePlan[[#Totals],[11월]]","v":{"v":136218,"d":"₩136,218.00"}},{"$f":"TrainingAndTravelPlan[[#Totals],[12월]]+MarketingPlan[[#Totals],[12월]]+OfficePlan[[#Totals],[12월]]+EmployeePlan[[#Totals],[12월]]","v":{"v":140018,"d":"₩140,018.00"}},{"$f":"TrainingAndTravelPlan[[#Totals],[연도]]+MarketingPlan[[#Totals],[연도]]+OfficePlan[[#Totals],[연도]]+EmployeePlan[[#Totals],[연도]]","v":{"v":1609630,"d":"₩1,609,630.00"}}]
[null,"총 계획된 지출",{"$f":"SUM($C$36:C36)","v":{"v":131420,"d":"₩131,420.00"}},{"$f":"SUM($C$36:D36)","v":{"v":258240,"d":"₩258,240.00"}},{"$f":"SUM($C$36:E36)","v":{"v":385060,"d":"₩385,060.00"}},{"$f":"SUM($C$36:F36)","v":{"v":522755,"d":"₩522,755.00"}},{"$f":"SUM($C$36:G36)","v":{"v":652450,"d":"₩652,450.00"}},{"$f":"SUM($C$36:H36)","v":{"v":782945,"d":"₩782,945.00"}},{"$f":"SUM($C$36:I36)","v":{"v":917640,"d":"₩917,640.00"}},{"$f":"SUM($C$36:J36)","v":{"v":1056558,"d":"₩1,056,558.00"}},{"$f":"SUM($C$36:K36)","v":{"v":1192476,"d":"₩1,192,476.00"}},{"$f":"SUM($C$36:L36)","v":{"v":1333394,"d":"₩1,333,394.00"}},{"$f":"SUM($C$36:M36)","v":{"v":1469612,"d":"₩1,469,612.00"}},{"$f":"SUM($C$36:N36)","v":{"v":1609630,"d":"₩1,609,630.00"}}]

{"sheet":"실제 지출","index":2,"n_rows":37,"n_cols":16,"rows_kept":37,"merged":[[1,1,2,3],[1,10,1,12],[1,13,2,14],[2,10,2,12],[8,1,8,2],[19,1,19,2],[28,1,28,2],[33,1,33,2]]}
["이 워크시트의 각 표에 실제 직원 비용, 사무 비용, 마케팅 비용 및 교육 또는 출장 비용을 입력합니다. 합계는 자동으로 계산됩니다. 이 워크시트의 사용 방법에 대한 유용한 지침은 이 열의 셀에 있습니다. 아래쪽 화살표를 사용하여 시작할 수 있습니다.",{"$nulls":14}," "]
["오른쪽 셀에 회사 이름이 자동으로 업데이트됩니다. K2 셀에는 이 워크시트의 제목이 표시됩니다. N2 셀에 로고를 입력합니다.",{"$f":"'계획한 지출'!B2:D3","v":"회사 이름"},{"$nulls":8},{"$f":"worksheet_title","v":"세부 지출 예상 항목"},null,null,"이 셀에는 로고 자리 표시자가 있습니다."]
["K3 셀에 팁이 표시됩니다.",{"$nulls":9},"음영 처리된 셀은 계산 결과입니다."]
["오른쪽 셀에는 [실제 지출] 레이블, C4 ~ N4 셀에는 월, O4 셀에는 [연도] 레이블이 있습니다.","실제 지출","1월","2월","3월","4월","5월","6월","7월","8월","9월","10월","11월","12월","연도"]
["오른쪽 셀에서 시작하는 직원 실제 표에서 직원 비용을 입력합니다. 다음 지침은 A10 셀에 있습니다.","직원 비용","1월","2월","3월","4월","5월","6월","7월","8월","9월","10월","11월","12월","연도"]
[null,"급여",{"v":85000,"d":"₩85,000.00"},{"v":85000,"d":"₩85,000.00"},{"v":85000,"d":"₩85,000.00"},{"v":88000,"d":"₩88,000.00"},{"v":88000,"d":"₩88,000.00"},{"v":88000,"d":"₩88,000.00"},{"$nulls":6},{"$f":"SUM(C6:N6)","v":{"v":519000,"d":"₩519,000.00"}}]
[null,"복지",{"$f":"C6*0.27","v":{"v":22950,"d":"₩22,950.00"}},{"v":22950,"d":"₩22,950.00"},{"v":22950,"d":"₩22,950.00"},{"v":23760,"d":"₩23,760.00"},{"v":23760,"d":"₩23,760.00"},{"v":23760,"d":"₩23,760.00"},{"v":0,"d":"₩0.00"},{"v":0,"d":"₩0.00"},{"v":0,"d":"₩0.00"},{"v":0,"d":"₩0.00"},{"v":0,"d":"₩0.00"},{"v":0,"d":"₩0.00"},{"$f":"SUM(C7:N7)","v":{"v":140130,"d":"₩140,130.00"}}]
[null,"소계",{"$f":"SUBTOTAL(109,EmployeeActual[1월])","v":{"v":107950,"d":"₩107,950.00"}},{"$f":"SUBTOTAL(109,EmployeeActual[2월])","v":{"v":107950,"d":"₩107,950.00"}},{"$f":"SUBTOTAL(109,EmployeeActual[3월])","v":{"v":107950,"d":"₩107,950.00"}},{"$f":"SUBTOTAL(109,EmployeeActual[4월])","v":{"v":111760,"d":"₩111,760.00"}},{"$f":"SUBTOTAL(109,EmployeeActual[5월])","v":{"v":111760,"d":"₩111,760.00"}},{"$f":"SUBTOTAL(109,EmployeeActual[6월])","v":{"v":111760,"d":"₩111,760.00"}},{"$f":"SUBTOTAL(109,EmployeeActual[7월])","v":{"v":0,"d":"₩0.00"}},{"$f":"SUBTOTAL(109,EmployeeActual[8월])","v":{"v":0,"d":"₩0.00"}},{"$f":"SUBTOTAL(109,EmployeeActual[9월])","v":{"v":0,"d":"₩0.00"}},{"$f":"SUBTOTAL(109,EmployeeActual[10월])","v":{"v":0,"d":"₩0.00"}},{"$f":"SUBTOTAL(109,EmployeeActual[11월])","v":{"v":0,"d":"₩0.00"}},{"$f":"SUBTOTAL(109,EmployeeActual[12월])","v":{"v":0,"d":"₩0.00"}},{"$f":"SUBTOTAL(109,EmployeeActual[연도])","v":{"v":659130,"d":"₩659,130.00"}}]
[]
["오른쪽 셀에서 시작하는 사무 실제 표에서 사무 비용을 입력합니다. 다음 지침은 A21 셀에 있습니다.","사무 비용","1월","2월","3월","4월","5월","6월","7월","8월","9월","10월","11월","12월","연도"]
[null,"사무실 임대",{"v":9800,"d":"₩9,800.00"},{"v":9800,"d":"₩9,800.00"},{"v":9800,"d":"₩9,800.00"},{"v":9800,"d":"₩9,800.00"},{"v":9800,"d":"₩9,800.00"},{"v":9800,"d":"₩9,800.00"},{"$nulls":6},{"$f":"SUM(C11:N11)","v":{"v":58800,"d":"₩58,800.00"}}]
[null,"가스",{"v":4,"d":"₩4.00"},{"v":430,"d":"₩430.00"},{"v":385,"d":"₩385.00"},{"v":230,"d":"₩230.00"},{"v":87,"d":"₩87.00"},{"v":88,"d":"₩88.00"},{"$nulls":6},{"v":1224,"d":"₩1,224.00"}]
[null,"전기",{"v":288,"d":"₩288.00"},{"v":278,"d":"₩278.00"},{"v":268,"d":"₩268.00"},{"v":299,"d":"₩299.00"},{"v":306,"d":"₩306.00"},{"v":290,"d":"₩290.00"},{"$nulls":6},{"v":1729,"d":"₩1,729.00"}]
[null,"수도",{"v":35,"d":"₩35.00"},{"v":33,"d":"₩33.00"},{"v":34,"d":"₩34.00"},{"v":36,"d":"₩36.00"},{"v":34,"d":"₩34.00"},{"v":36,"d":"₩36.00"},{"$nulls":6},{"v":208,"d":"₩208.00"}]
[null,"전화",{"v":224,"d":"₩224.00"},{"v":235,"d":"₩235.00"},{"v":265,"d":"₩265.00"},{"v":245,"d":"₩245.00"},{"v":245,"d":"₩245.00"},{"v":220,"d":"₩220.00"},{"$nulls":6},{"v":1434,"d":"₩1,434.00"}]
[null,"인터넷 사용",{"v":180,"d":"₩180.00"},{"v":180,"d":"₩180.00"},{"v":180,"d":"₩180.00"},{"v":180,"d":"₩180.00"},{"v":180,"d":"₩180.00"},{"v":180,"d":"₩180.00"},{"$nulls":6},{"v":1080,"d":"₩1,080.00"}]
[null,"사무용품",{"v":256,"d":"₩256.00"},{"v":142,"d":"₩142.00"},{"v":160,"d":"₩160.00"},{"v":221,"d":"₩221.00"},{"v":256,"d":"₩256.00"},{"v":240,"d":"₩240.00"},{"$nulls":6},{"v":1275,"d":"₩1,275.00"}]
[null,"보안",{"v":600,"d":"₩600.00"},{"v":600,"d":"₩600.00"},{"v":600,"d":"₩600.00"},{"v":600,"d":"₩600.00"},{"v":600,"d":"₩600.00"},{"v":600,"d":"₩600.00"},{"$nulls":6},{"v":3600,"d":"₩3,600.00"}]
[null,"소계",{"$f":"SUBTOTAL(109,OfficeActual[1월])","v":{"v":11387,"d":"₩11,387.00"}},{"$f":"SUBTOTAL(109,OfficeActual[2월])","v":{"v":11698,"d":"₩11,698.00"}},{"$f":"SUBTOTAL(109,OfficeActual[3월])","v":{"v":11692,"d":"₩11,692.00"}},{"$f":"SUBTOTAL(109,OfficeActual[4월])","v":{"v":11611,"d":"₩11,611.00"}},{"$f":"SUBTOTAL(109,OfficeActual[5월])","v":{"v":11508,"d":"₩11,508.00"}},{"$f":"SUBTOTAL(109,OfficeActual[6월])","v":{"v":11454,"d":"₩11,454.00"}},{"$f":"SUBTOTAL(109,OfficeActual[7월])","v":{"v":0,"d":"₩0.00"}},{"$f":"SUBTOTAL(109,OfficeActual[8월])","v":{"v":0,"d":"₩0.00"}},{"$f":"SUBTOTAL(109,OfficeActual[9월])","v":{"v":0,"d":"₩0.00"}},{"$f":"SUBTOTAL(109,OfficeActual[10월])","v":{"v":0,"d":"₩0.00"}},{"$f":"SUBTOTAL(109,OfficeActual[11월])","v":{"v":0,"d":"₩0.00"}},{"$f":"SUBTOTAL(109,OfficeActual[12월])","v":{"v":0,"d":"₩0.00"}},{"$f":"SUBTOTAL(109,OfficeActual[연도])","v":{"v":69350,"d":"₩69,350.00"}}]
[]
["오른쪽 셀에서 시작하는 마케팅 실제 표에서 마케팅 비용을 입력합니다. 다음 지침은 A30 셀에 있습니다.","마케팅 비용","1월","2월","3월","4월","5월","6월","7월","8월","9월","10월","11월","12월","연도"]
[null,"웹 사이트 호스팅",{"v":500,"d":"₩500.00"},{"v":500,"d":"₩500.00"},{"v":500,"d":"₩500.00"},{"v":500,"d":"₩500.00"},{"v":500,"d":"₩500.00"},{"v":500,"d":"₩500.00"},{"$nulls":6},{"$f":"SUM(C22:N22)","v":{"v":3000,"d":"₩3,000.00"}}]
[null,"웹 사이트 업데이트",{"v":200,"d":"₩200.00"},{"v":200,"d":"₩200.00"},{"v":200,"d":"₩200.00"},{"v":200,"d":"₩200.00"},{"v":200,"d":"₩200.00"},{"v":1500,"d":"₩1,500.00"},{"$nulls":6},{"v":2500,"d":"₩2,500.00"}]
[null,"자료 준비",{"v":4800,"d":"₩4,800.00"},{"v":0,"d":"₩0.00"},{"v":0,"d":"₩0.00"},{"v":5500,"d":"₩5,500.00"},{"v":0,"d":"₩0.00"},{"v":0,"d":"₩0.00"},{"$nulls":6},{"v":10300,"d":"₩10,300.00"}]
[null,"자료 인쇄",{"v":100,"d":"₩100.00"},{"v":500,"d":"₩500.00"},{"v":100,"d":"₩100.00"},{"v":100,"d":"₩100.00"},{"v":600,"d":"₩600.00"},{"v":180,"d":"₩180.00"},{"$nulls":6},{"v":1580,"d":"₩1,580.00"}]
[null,"마케팅 행사",{"v":1800,"d":"₩1,800.00"},{"v":2200,"d":"₩2,200.00"},{"v":2200,"d":"₩2,200.00"},{"v":4700,"d":"₩4,700.00"},{"v":1500,"d":"₩1,500.00"},{"v":2300,"d":"₩2,300.00"},{"$nulls":6},{"v":14700,"d":"₩14,700.00"}]
[null,"기타 비용",{"v":145,"d":"₩145.00"},{"v":156,"d":"₩156.00"},{"v":123,"d":"₩123.00"},{"v":223,"d":"₩223.00"},{"v":187,"d":"₩187.00"},{"v":245,"d":"₩245.00"},{"$nulls":6},{"v":1079,"d":"₩1,079.00"}]
[null,"소계",{"$f":"SUBTOTAL(109,MarketingActual[1월])","v":{"v":7545,"d":"₩7,545.00"}},{"$f":"SUBTOTAL(109,MarketingActual[2월])","v":{"v":3556,"d":"₩3,556.00"}},{"$f":"SUBTOTAL(109,MarketingActual[3월])","v":{"v":3123,"d":"₩3,123.00"}},{"$f":"SUBTOTAL(109,MarketingActual[4월])","v":{"v":11223,"d":"₩11,223.00"}},{"$f":"SUBTOTAL(109,MarketingActual[5월])","v":{"v":2987,"d":"₩2,987.00"}},{"$f":"SUBTOTAL(109,MarketingActual[6월])","v":{"v":4725,"d":"₩4,725.00"}},{"$f":"SUBTOTAL(109,MarketingActual[7월])","v":{"v":0,"d":"₩0.00"}},{"$f":"SUBTOTAL(109,MarketingActual[8월])","v":{"v":0,"d":"₩0.00"}},{"$f":"SUBTOTAL(109,MarketingActual[9월])","v":{"v":0,"d":"₩0.00"}},{"$f":"SUBTOTAL(109,MarketingActual[10월])","v":{"v":0,"d":"₩0.00"}},{"$f":"SUBTOTAL(109,MarketingActual[11월])","v":{"v":0,"d":"₩0.00"}},{"$f":"SUBTOTAL(109,MarketingActual[12월])","v":{"v":0,"d":"₩0.00"}},{"$f":"SUBTOTAL(109,MarketingActual[연도])","v":{"v":33159,"d":"₩33,159.00"}}]
[]
["오른쪽 셀에서 시작하는 교육 및 출장 실제 표에서 교육 또는 출장 비용을 입력합니다. 다음 지침은 A35 셀에 있습니다.","교육/출장","1월","2월","3월","4월","5월","6월","7월","8월","9월","10월","11월","12월","연도"]
[null,"교육 수업",{"v":1600,"d":"₩1,600.00"},{"v":2400,"d":"₩2,400.00"},{"v":1400,"d":"₩1,400.00"},{"v":1600,"d":"₩1,600.00"},{"v":1200,"d":"₩1,200.00"},{"v":2800,"d":"₩2,800.00"},{"$nulls":6},{"$f":"SUM(C31:N31)","v":{"v":11000,"d":"₩11,000.00"}}]
[null,"교육 관련 출장 비용",{"v":1200,"d":"₩1,200.00"},{"v":2200,"d":"₩2,200.00"},{"v":1400,"d":"₩1,400.00"},{"v":1200,"d":"₩1,200.00"},{"v":800,"d":"₩800.00"},{"v":3500,"d":"₩3,500.00"},{"$nulls":6},{"$f":"SUM(C32:N32)","v":{"v":10300,"d":"₩10,300.00"}}]
[null,"소계",{"$f":"SUBTOTAL(109,TrainingAndTravelActual[1월])","v":{"v":2800,"d":"₩2,800.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelActual[2월])","v":{"v":4600,"d":"₩4,600.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelActual[3월])","v":{"v":2800,"d":"₩2,800.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelActual[4월])","v":{"v":2800,"d":"₩2,800.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelActual[5월])","v":{"v":2000,"d":"₩2,000.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelActual[6월])","v":{"v":6300,"d":"₩6,300.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelActual[7월])","v":{"v":0,"d":"₩0.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelActual[8월])","v":{"v":0,"d":"₩0.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelActual[9월])","v":{"v":0,"d":"₩0.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelActual[10월])","v":{"v":0,"d":"₩0.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelActual[11월])","v":{"v":0,"d":"₩0.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelActual[12월])","v":{"v":0,"d":"₩0.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelActual[연도])","v":{"v":21300,"d":"₩21,300.00"}}]
[]
["오른쪽 셀에서 시작하는 실제 합계 표에 총 실제 지출이 자동으로 계산됩니다.","총 계획된 지출","1월","2월","3월","4월","5월","6월","7월","8월","9월","10월","11월","12월","연도"]
[null,"월별 실제 지출",{"$f":"TrainingAndTravelActual[[#Totals],[1월]]+MarketingActual[[#Totals],[1월]]+OfficeActual[[#Totals],[1월]]+EmployeeActual[[#Totals],[1월]]","v":{"v":129682,"d":"₩129,682.00"}},{"$f":"TrainingAndTravelActual[[#Totals],[2월]]+MarketingActual[[#Totals],[2월]]+OfficeActual[[#Totals],[2월]]+EmployeeActual[[#Totals],[2월]]","v":{"v":127804,"d":"₩127,804.00"}},{"$f":"TrainingAndTravelActual[[#Totals],[3월]]+MarketingActual[[#Totals],[3월]]+OfficeActual[[#Totals],[3월]]+EmployeeActual[[#Totals],[3월]]","v":{"v":125565,"d":"₩125,565.00"}},{"$f":"TrainingAndTravelActual[[#Totals],[4월]]+MarketingActual[[#Totals],[4월]]+OfficeActual[[#Totals],[4월]]+EmployeeActual[[#Totals],[4월]]","v":{"v":137394,"d":"₩137,394.00"}},{"$f":"TrainingAndTravelActual[[#Totals],[5월]]+MarketingActual[[#Totals],[5월]]+OfficeActual[[#Totals],[5월]]+EmployeeActual[[#Totals],[5월]]","v":{"v":128255,"d":"₩128,255.00"}},{"$f":"TrainingAndTravelActual[[#Totals],[6월]]+MarketingActual[[#Totals],[6월]]+OfficeActual[[#Totals],[6월]]+EmployeeActual[[#Totals],[6월]]","v":{"v":134239,"d":"₩134,239.00"}},{"$f":"TrainingAndTravelActual[[#Totals],[7월]]+MarketingActual[[#Totals],[7월]]+OfficeActual[[#Totals],[7월]]+EmployeeActual[[#Totals],[7월]]","v":{"v":0,"d":"₩0.00"}},{"$f":"TrainingAndTravelActual[[#Totals],[8월]]+MarketingActual[[#Totals],[8월]]+OfficeActual[[#Totals],[8월]]+EmployeeActual[[#Totals],[8월]]","v":{"v":0,"d":"₩0.00"}},{"$f":"TrainingAndTravelActual[[#Totals],[9월]]+MarketingActual[[#Totals],[9월]]+OfficeActual[[#Totals],[9월]]+EmployeeActual[[#Totals],[9월]]","v":{"v":0,"d":"₩0.00"}},{"$f":"TrainingAndTravelActual[[#Totals],[10월]]+MarketingActual[[#Totals],[10월]]+OfficeActual[[#Totals],[10월]]+EmployeeActual[[#Totals],[10월]]","v":{"v":0,"d":"₩0.00"}},{"$f":"TrainingAndTravelActual[[#Totals],[11월]]+MarketingActual[[#Totals],[11월]]+OfficeActual[[#Totals],[11월]]+EmployeeActual[[#Totals],[11월]]","v":{"v":0,"d":"₩0.00"}},{"$f":"TrainingAndTravelActual[[#Totals],[12월]]+MarketingActual[[#Totals],[12월]]+OfficeActual[[#Totals],[12월]]+EmployeeActual[[#Totals],[12월]]","v":{"v":0,"d":"₩0.00"}},{"$f":"TrainingAndTravelActual[[#Totals],[연도]]+MarketingActual[[#Totals],[연도]]+OfficeActual[[#Totals],[연도]]+EmployeeActual[[#Totals],[연도]]","v":{"v":782939,"d":"₩782,939.00"}}]
[null,"총 실제 지출",{"$f":"SUM($C$36:C36)","v":{"v":129682,"d":"₩129,682.00"}},{"$f":"SUM($C$36:D36)","v":{"v":257486,"d":"₩257,486.00"}},{"$f":"SUM($C$36:E36)","v":{"v":383051,"d":"₩383,051.00"}},{"$f":"SUM($C$36:F36)","v":{"v":520445,"d":"₩520,445.00"}},{"$f":"SUM($C$36:G36)","v":{"v":648700,"d":"₩648,700.00"}},{"$f":"SUM($C$36:H36)","v":{"v":782939,"d":"₩782,939.00"}},{"$f":"SUM($C$36:I36)","v":{"v":782939,"d":"₩782,939.00"}},{"$f":"SUM($C$36:J36)","v":{"v":782939,"d":"₩782,939.00"}},{"$f":"SUM($C$36:K36)","v":{"v":782939,"d":"₩782,939.00"}},{"$f":"SUM($C$36:L36)","v":{"v":782939,"d":"₩782,939.00"}},{"$f":"SUM($C$36:M36)","v":{"v":782939,"d":"₩782,939.00"}},{"$f":"SUM($C$36:N36)","v":{"v":782939,"d":"₩782,939.00"}}]

{"sheet":"지출 차이","index":3,"n_rows":37,"n_cols":16,"rows_kept":37,"merged":[[1,1,2,3],[1,10,1,12],[1,13,2,14],[2,10,2,12],[8,1,8,2],[19,1,19,2],[28,1,28,2],[33,1,33,2]]}
["이 워크시트의 각 표에 있는 직원 비용, 사무 비용, 마케팅 비용 및 교육 또는 출장 비용에 대한 지출 차이가 이 워크시트에 자동으로 계산됩니다. 이 워크시트의 사용 방법에 대한 유용한 지침은 이 열의 셀에 있습니다. 아래쪽 화살표를 사용하여 시작할 수 있습니다.",{"$nulls":14}," "]
["오른쪽 셀에 회사 이름이 자동으로 업데이트됩니다. K2 셀에는 이 워크시트의 제목이 표시됩니다. N2 셀에 로고를 입력합니다.",{"$f":"'계획한 지출'!B2:D3","v":"회사 이름"},{"$nulls":8},{"$f":"worksheet_title","v":"세부 지출 예상 항목"},null,null,"이 셀에는 로고 자리 표시자가 있습니다."]
["K3 셀에 팁이 표시됩니다.",{"$nulls":9},"음영 처리된 셀은 계산 결과입니다."]
["오른쪽 셀에는 [지출 차이] 레이블, C4 ~ N4 셀에는 월, O4 셀에는 [연도] 레이블이 있습니다.","지출 차이","1월","2월","3월","4월","5월","6월","7월","8월","9월","10월","11월","12월","연도"]
["오른쪽 셀에서 시작하는 직원 차이 표에 직원 비용 차이가 자동으로 계산됩니다. 다음 지침은 A10 셀에 있습니다.","직원 비용","1월","2월","3월","4월","5월","6월","7월","8월","9월","10월","11월","12월","연도"]
[null,"급여",{"$f":"INDEX(EmployeePlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[1월]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[1월]],EmployeePlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[1월]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[1월]],EmployeeActual[#Headers],0))","v":{"v":0,"d":"₩0.00"}},{"$f":"INDEX(EmployeePlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[2월]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[2월]],EmployeePlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[2월]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[2월]],EmployeeActual[#Headers],0))","v":{"v":0,"d":"₩0.00"}},{"$f":"INDEX(EmployeePlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[3월]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[3월]],EmployeePlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[3월]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[3월]],EmployeeActual[#Headers],0))","v":{"v":0,"d":"₩0.00"}},{"$f":"INDEX(EmployeePlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[4월]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[4월]],EmployeePlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[4월]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[4월]],EmployeeActual[#Headers],0))","v":{"v":-500,"d":"(₩500.00)"}},{"$f":"INDEX(EmployeePlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[5월]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[5월]],EmployeePlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[5월]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[5월]],EmployeeActual[#Headers],0))","v":{"v":-500,"d":"(₩500.00)"}},{"$f":"INDEX(EmployeePlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[6월]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[6월]],EmployeePlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[6월]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[6월]],EmployeeActual[#Headers],0))","v":{"v":-500,"d":"(₩500.00)"}},{"$f":"INDEX(EmployeePlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[7월]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[7월]],EmployeePlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[7월]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[7월]],EmployeeActual[#Headers],0))","v":{"v":87500,"d":"₩87,500.00"}},{"$f":"INDEX(EmployeePlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[8월]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[8월]],EmployeePlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[8월]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[8월]],EmployeeActual[#Headers],0))","v":{"v":92400,"d":"₩92,400.00"}},{"$f":"INDEX(EmployeePlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[9월]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[9월]],EmployeePlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[9월]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[9월]],EmployeeActual[#Headers],0))","v":{"v":92400,"d":"₩92,400.00"}},{"$f":"INDEX(EmployeePlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[10월]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[10월]],EmployeePlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[10월]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[10월]],EmployeeActual[#Headers],0))","v":{"v":92400,"d":"₩92,400.00"}},{"$f":"INDEX(EmployeePlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[11월]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[11월]],EmployeePlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[11월]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[11월]],EmployeeActual[#Headers],0))","v":{"v":92400,"d":"₩92,400.00"}},{"$f":"INDEX(EmployeePlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[12월]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[12월]],EmployeePlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[12월]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[12월]],EmployeeActual[#Headers],0))","v":{"v":92400,"d":"₩92,400.00"}},{"$f":"SUM(EmployeeVariances[[#This Row],[1월]:[12월]])","v":{"v":548000,"d":"₩548,000.00"}}]
[null,"복지",{"$f":"INDEX(EmployeePlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[1월]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[1월]],EmployeePlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[1월]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[1월]],EmployeeActual[#Headers],0))","v":{"v":0,"d":"₩0.00"}},{"$f":"INDEX(EmployeePlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[2월]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[2월]],EmployeePlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[2월]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[2월]],EmployeeActual[#Headers],0))","v":{"v":0,"d":"₩0.00"}},{"$f":"INDEX(EmployeePlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[3월]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[3월]],EmployeePlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[3월]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[3월]],EmployeeActual[#Headers],0))","v":{"v":0,"d":"₩0.00"}},{"$f":"INDEX(EmployeePlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[4월]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[4월]],EmployeePlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[4월]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[4월]],EmployeeActual[#Headers],0))","v":{"v":-135,"d":"(₩135.00)"}},{"$f":"INDEX(EmployeePlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[5월]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[5월]],EmployeePlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[5월]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[5월]],EmployeeActual[#Headers],0))","v":{"v":-135,"d":"(₩135.00)"}},{"$f":"INDEX(EmployeePlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[6월]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[6월]],EmployeePlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[6월]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[6월]],EmployeeActual[#Headers],0))","v":{"v":-135,"d":"(₩135.00)"}},{"$f":"INDEX(EmployeePlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[7월]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[7월]],EmployeePlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[7월]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[7월]],EmployeeActual[#Headers],0))","v":{"v":23625,"d":"₩23,625.00"}},{"$f":"INDEX(EmployeePlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[8월]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[8월]],EmployeePlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[8월]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[8월]],EmployeeActual[#Headers],0))","v":{"v":24948,"d":"₩24,948.00"}},{"$f":"INDEX(EmployeePlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[9월]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[9월]],EmployeePlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[9월]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[9월]],EmployeeActual[#Headers],0))","v":{"v":24948,"d":"₩24,948.00"}},{"$f":"INDEX(EmployeePlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[10월]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[10월]],EmployeePlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[10월]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[10월]],EmployeeActual[#Headers],0))","v":{"v":24948,"d":"₩24,948.00"}},{"$f":"INDEX(EmployeePlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[11월]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[11월]],EmployeePlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[11월]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[11월]],EmployeeActual[#Headers],0))","v":{"v":24948,"d":"₩24,948.00"}},{"$f":"INDEX(EmployeePlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[12월]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[12월]],EmployeePlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[12월]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[12월]],EmployeeActual[#Headers],0))","v":{"v":24948,"d":"₩24,948.00"}},{"$f":"SUM(EmployeeVariances[[#This Row],[1월]:[12월]])","v":{"v":147960,"d":"₩147,960.00"}}]
[null,"소계",{"$f":"SUBTOTAL(109,EmployeeVariances[1월])","v":{"v":0,"d":"₩0.00"}},{"$f":"SUBTOTAL(109,EmployeeVariances[2월])","v":{"v":0,"d":"₩0.00"}},{"$f":"SUBTOTAL(109,EmployeeVariances[3월])","v":{"v":0,"d":"₩0.00"}},{"$f":"SUBTOTAL(109,EmployeeVariances[4월])","v":{"v":-635,"d":"(₩635.00)"}},{"$f":"SUBTOTAL(109,EmployeeVariances[5월])","v":{"v":-635,"d":"(₩635.00)"}},{"$f":"SUBTOTAL(109,EmployeeVariances[6월])","v":{"v":-635,"d":"(₩635.00)"}},{"$f":"SUBTOTAL(109,EmployeeVariances[7월])","v":{"v":111125,"d":"₩111,125.00"}},{"$f":"SUBTOTAL(109,EmployeeVariances[8월])","v":{"v":117348,"d":"₩117,348.00"}},{"$f":"SUBTOTAL(109,EmployeeVariances[9월])","v":{"v":117348,"d":"₩117,348.00"}},{"$f":"SUBTOTAL(109,EmployeeVariances[10월])","v":{"v":117348,"d":"₩117,348.00"}},{"$f":"SUBTOTAL(109,EmployeeVariances[11월])","v":{"v":117348,"d":"₩117,348.00"}},{"$f":"SUBTOTAL(109,EmployeeVariances[12월])","v":{"v":117348,"d":"₩117,348.00"}},{"$f":"SUBTOTAL(109,EmployeeVariances[연도])","v":{"v":695960,"d":"₩695,960.00"}}]
[]
["오른쪽 셀에서 시작하는 사무 차이 표에 사무 비용 차이가 자동으로 계산됩니다. 다음 지침은 A21 셀에 있습니다.","사무 비용","1월","2월","3월","4월","5월","6월","7월","8월","9월","10월","11월","12월","연도"]
[null,"사무실 임대",{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[1월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[1월]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[1월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[1월]],OfficeActual[#Headers],0))","v":{"v":0,"d":"₩0.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[2월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[2월]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[2월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[2월]],OfficeActual[#Headers],0))","v":{"v":0,"d":"₩0.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[3월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[3월]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[3월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[3월]],OfficeActual[#Headers],0))","v":{"v":0,"d":"₩0.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[4월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[4월]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[4월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[4월]],OfficeActual[#Headers],0))","v":{"v":0,"d":"₩0.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[5월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[5월]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[5월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[5월]],OfficeActual[#Headers],0))","v":{"v":0,"d":"₩0.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[6월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[6월]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[6월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[6월]],OfficeActual[#Headers],0))","v":{"v":0,"d":"₩0.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[7월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[7월]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[7월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[7월]],OfficeActual[#Headers],0))","v":{"v":9800,"d":"₩9,800.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[8월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[8월]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[8월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[8월]],OfficeActual[#Headers],0))","v":{"v":9800,"d":"₩9,800.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[9월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[9월]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[9월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[9월]],OfficeActual[#Headers],0))","v":{"v":9800,"d":"₩9,800.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[10월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[10월]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[10월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[10월]],OfficeActual[#Headers],0))","v":{"v":9800,"d":"₩9,800.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[11월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[11월]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[11월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[11월]],OfficeActual[#Headers],0))","v":{"v":9800,"d":"₩9,800.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[12월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[12월]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[12월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[12월]],OfficeActual[#Headers],0))","v":{"v":9800,"d":"₩9,800.00"}},{"$f":"SUM(OfficeVariances[[#This Row],[1월]:[12월]])","v":{"v":58800,"d":"₩58,800.00"}}]
[null,"가스",{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[1월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[1월]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[1월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[1월]],OfficeActual[#Headers],0))","v":{"v":-4,"d":"(₩4.00)"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[2월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[2월]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[2월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[2월]],OfficeActual[#Headers],0))","v":{"v":-30,"d":"(₩30.00)"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[3월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[3월]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[3월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[3월]],OfficeActual[#Headers],0))","v":{"v":15,"d":"₩15.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[4월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[4월]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[4월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[4월]],OfficeActual[#Headers],0))","v":{"v":-130,"d":"(₩130.00)"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[5월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[5월]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[5월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[5월]],OfficeActual[#Headers],0))","v":{"v":13,"d":"₩13.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[6월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[6월]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[6월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[6월]],OfficeActual[#Headers],0))","v":{"v":12,"d":"₩12.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[7월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[7월]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[7월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[7월]],OfficeActual[#Headers],0))","v":{"v":100,"d":"₩100.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[8월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[8월]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[8월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[8월]],OfficeActual[#Headers],0))","v":{"v":100,"d":"₩100.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[9월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[9월]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[9월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[9월]],OfficeActual[#Headers],0))","v":{"v":100,"d":"₩100.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[10월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[10월]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[10월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[10월]],OfficeActual[#Headers],0))","v":{"v":100,"d":"₩100.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[11월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[11월]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[11월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[11월]],OfficeActual[#Headers],0))","v":{"v":400,"d":"₩400.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[12월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[12월]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[12월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[12월]],OfficeActual[#Headers],0))","v":{"v":400,"d":"₩400.00"}},{"$f":"SUM(OfficeVariances[[#This Row],[1월]:[12월]])","v":{"v":1076,"d":"₩1,076.00"}}]
[null,"전기",{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[1월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[1월]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[1월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[1월]],OfficeActual[#Headers],0))","v":{"v":12,"d":"₩12.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[2월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[2월]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[2월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[2월]],OfficeActual[#Headers],0))","v":{"v":22,"d":"₩22.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[3월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[3월]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[3월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[3월]],OfficeActual[#Headers],0))","v":{"v":32,"d":"₩32.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[4월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[4월]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[4월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[4월]],OfficeActual[#Headers],0))","v":{"v":1,"d":"₩1.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[5월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[5월]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[5월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[5월]],OfficeActual[#Headers],0))","v":{"v":-6,"d":"(₩6.00)"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[6월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[6월]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[6월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[6월]],OfficeActual[#Headers],0))","v":{"v":10,"d":"₩10.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[7월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[7월]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[7월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[7월]],OfficeActual[#Headers],0))","v":{"v":300,"d":"₩300.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[8월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[8월]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[8월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[8월]],OfficeActual[#Headers],0))","v":{"v":300,"d":"₩300.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[9월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[9월]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[9월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[9월]],OfficeActual[#Headers],0))","v":{"v":300,"d":"₩300.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[10월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[10월]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[10월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[10월]],OfficeActual[#Headers],0))","v":{"v":300,"d":"₩300.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[11월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[11월]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[11월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[11월]],OfficeActual[#Headers],0))","v":{"v":300,"d":"₩300.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[12월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[12월]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[12월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[12월]],OfficeActual[#Headers],0))","v":{"v":300,"d":"₩300.00"}},{"$f":"SUM(OfficeVariances[[#This Row],[1월]:[12월]])","v":{"v":1871,"d":"₩1,871.00"}}]
[null,"수도",{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[1월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[1월]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[1월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[1월]],OfficeActual[#Headers],0))","v":{"v":5,"d":"₩5.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[2월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[2월]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[2월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[2월]],OfficeActual[#Headers],0))","v":{"v":7,"d":"₩7.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[3월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[3월]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[3월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[3월]],OfficeActual[#Headers],0))","v":{"v":6,"d":"₩6.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[4월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[4월]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[4월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[4월]],OfficeActual[#Headers],0))","v":{"v":4,"d":"₩4.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[5월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[5월]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[5월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[5월]],OfficeActual[#Headers],0))","v":{"v":6,"d":"₩6.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[6월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[6월]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[6월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[6월]],OfficeActual[#Headers],0))","v":{"v":4,"d":"₩4.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[7월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[7월]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[7월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[7월]],OfficeActual[#Headers],0))","v":{"v":40,"d":"₩40.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[8월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[8월]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[8월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[8월]],OfficeActual[#Headers],0))","v":{"v":40,"d":"₩40.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[9월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[9월]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[9월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[9월]],OfficeActual[#Headers],0))","v":{"v":40,"d":"₩40.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[10월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[10월]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[10월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[10월]],OfficeActual[#Headers],0))","v":{"v":40,"d":"₩40.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[11월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[11월]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[11월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[11월]],OfficeActual[#Headers],0))","v":{"v":40,"d":"₩40.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[12월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[12월]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[12월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[12월]],OfficeActual[#Headers],0))","v":{"v":40,"d":"₩40.00"}},{"$f":"SUM(OfficeVariances[[#This Row],[1월]:[12월]])","v":{"v":272,"d":"₩272.00"}}]
[null,"전화",{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[1월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[1월]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[1월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[1월]],OfficeActual[#Headers],0))","v":{"v":26,"d":"₩26.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[2월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[2월]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[2월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[2월]],OfficeActual[#Headers],0))","v":{"v":15,"d":"₩15.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[3월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[3월]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[3월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[3월]],OfficeActual[#Headers],0))","v":{"v":-15,"d":"(₩15.00)"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[4월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[4월]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[4월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[4월]],OfficeActual[#Headers],0))","v":{"v":5,"d":"₩5.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[5월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[5월]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[5월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[5월]],OfficeActual[#Headers],0))","v":{"v":5,"d":"₩5.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[6월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[6월]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[6월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[6월]],OfficeActual[#Headers],0))","v":{"v":30,"d":"₩30.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[7월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[7월]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[7월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[7월]],OfficeActual[#Headers],0))","v":{"v":250,"d":"₩250.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[8월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[8월]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[8월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[8월]],OfficeActual[#Headers],0))","v":{"v":250,"d":"₩250.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[9월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[9월]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[9월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[9월]],OfficeActual[#Headers],0))","v":{"v":250,"d":"₩250.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[10월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[10월]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[10월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[10월]],OfficeActual[#Headers],0))","v":{"v":250,"d":"₩250.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[11월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[11월]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[11월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[11월]],OfficeActual[#Headers],0))","v":{"v":250,"d":"₩250.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[12월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[12월]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[12월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[12월]],OfficeActual[#Headers],0))","v":{"v":250,"d":"₩250.00"}},{"$f":"SUM(OfficeVariances[[#This Row],[1월]:[12월]])","v":{"v":1566,"d":"₩1,566.00"}}]
[null,"인터넷 사용",{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[1월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[1월]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[1월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[1월]],OfficeActual[#Headers],0))","v":{"v":0,"d":"₩0.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[2월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[2월]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[2월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[2월]],OfficeActual[#Headers],0))","v":{"v":0,"d":"₩0.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[3월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[3월]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[3월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[3월]],OfficeActual[#Headers],0))","v":{"v":0,"d":"₩0.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[4월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[4월]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[4월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[4월]],OfficeActual[#Headers],0))","v":{"v":0,"d":"₩0.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[5월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[5월]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[5월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[5월]],OfficeActual[#Headers],0))","v":{"v":0,"d":"₩0.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[6월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[6월]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[6월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[6월]],OfficeActual[#Headers],0))","v":{"v":0,"d":"₩0.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[7월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[7월]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[7월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[7월]],OfficeActual[#Headers],0))","v":{"v":180,"d":"₩180.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[8월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[8월]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[8월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[8월]],OfficeActual[#Headers],0))","v":{"v":180,"d":"₩180.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[9월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[9월]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[9월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[9월]],OfficeActual[#Headers],0))","v":{"v":180,"d":"₩180.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[10월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[10월]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[10월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[10월]],OfficeActual[#Headers],0))","v":{"v":180,"d":"₩180.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[11월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[11월]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[11월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[11월]],OfficeActual[#Headers],0))","v":{"v":180,"d":"₩180.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[12월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[12월]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[12월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[12월]],OfficeActual[#Headers],0))","v":{"v":180,"d":"₩180.00"}},{"$f":"SUM(OfficeVariances[[#This Row],[1월]:[12월]])","v":{"v":1080,"d":"₩1,080.00"}}]
[null,"사무용품",{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[1월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[1월]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[1월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[1월]],OfficeActual[#Headers],0))","v":{"v":-56,"d":"(₩56.00)"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[2월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[2월]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[2월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[2월]],OfficeActual[#Headers],0))","v":{"v":58,"d":"₩58.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[3월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[3월]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[3월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[3월]],OfficeActual[#Headers],0))","v":{"v":40,"d":"₩40.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[4월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[4월]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[4월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[4월]],OfficeActual[#Headers],0))","v":{"v":-21,"d":"(₩21.00)"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[5월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[5월]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[5월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[5월]],OfficeActual[#Headers],0))","v":{"v":-56,"d":"(₩56.00)"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[6월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[6월]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[6월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[6월]],OfficeActual[#Headers],0))","v":{"v":-40,"d":"(₩40.00)"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[7월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[7월]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[7월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[7월]],OfficeActual[#Headers],0))","v":{"v":200,"d":"₩200.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[8월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[8월]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[8월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[8월]],OfficeActual[#Headers],0))","v":{"v":200,"d":"₩200.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[9월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[9월]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[9월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[9월]],OfficeActual[#Headers],0))","v":{"v":200,"d":"₩200.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[10월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[10월]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[10월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[10월]],OfficeActual[#Headers],0))","v":{"v":200,"d":"₩200.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[11월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[11월]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[11월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[11월]],OfficeActual[#Headers],0))","v":{"v":200,"d":"₩200.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[12월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[12월]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[12월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[12월]],OfficeActual[#Headers],0))","v":{"v":200,"d":"₩200.00"}},{"$f":"SUM(OfficeVariances[[#This Row],[1월]:[12월]])","v":{"v":1125,"d":"₩1,125.00"}}]
[null,"보안",{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[1월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[1월]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[1월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[1월]],OfficeActual[#Headers],0))","v":{"v":0,"d":"₩0.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[2월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[2월]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[2월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[2월]],OfficeActual[#Headers],0))","v":{"v":0,"d":"₩0.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[3월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[3월]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[3월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[3월]],OfficeActual[#Headers],0))","v":{"v":0,"d":"₩0.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[4월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[4월]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[4월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[4월]],OfficeActual[#Headers],0))","v":{"v":0,"d":"₩0.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[5월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[5월]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[5월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[5월]],OfficeActual[#Headers],0))","v":{"v":0,"d":"₩0.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[6월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[6월]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[6월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[6월]],OfficeActual[#Headers],0))","v":{"v":0,"d":"₩0.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[7월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[7월]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[7월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[7월]],OfficeActual[#Headers],0))","v":{"v":600,"d":"₩600.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[8월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[8월]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[8월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[8월]],OfficeActual[#Headers],0))","v":{"v":600,"d":"₩600.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[9월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[9월]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[9월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[9월]],OfficeActual[#Headers],0))","v":{"v":600,"d":"₩600.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[10월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[10월]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[10월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[10월]],OfficeActual[#Headers],0))","v":{"v":600,"d":"₩600.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[11월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[11월]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[11월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[11월]],OfficeActual[#Headers],0))","v":{"v":600,"d":"₩600.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[12월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[12월]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[12월]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[12월]],OfficeActual[#Headers],0))","v":{"v":600,"d":"₩600.00"}},{"$f":"SUM(OfficeVariances[[#This Row],[1월]:[12월]])","v":{"v":3600,"d":"₩3,600.00"}}]
[null,"소계",{"$f":"SUBTOTAL(109,OfficeVariances[1월])","v":{"v":-17,"d":"(₩17.00)"}},{"$f":"SUBTOTAL(109,OfficeVariances[2월])","v":{"v":72,"d":"₩72.00"}},{"$f":"SUBTOTAL(109,OfficeVariances[3월])","v":{"v":78,"d":"₩78.00"}},{"$f":"SUBTOTAL(109,OfficeVariances[4월])","v":{"v":-141,"d":"(₩141.00)"}},{"$f":"SUBTOTAL(109,OfficeVariances[5월])","v":{"v":-38,"d":"(₩38.00)"}},{"$f":"SUBTOTAL(109,OfficeVariances[6월])","v":{"v":16,"d":"₩16.00"}},{"$f":"SUBTOTAL(109,OfficeVariances[7월])","v":{"v":11470,"d":"₩11,470.00"}},{"$f":"SUBTOTAL(109,OfficeVariances[8월])","v":{"v":11470,"d":"₩11,470.00"}},{"$f":"SUBTOTAL(109,OfficeVariances[9월])","v":{"v":11470,"d":"₩11,470.00"}},{"$f":"SUBTOTAL(109,OfficeVariances[10월])","v":{"v":11470,"d":"₩11,470.00"}},{"$f":"SUBTOTAL(109,OfficeVariances[11월])","v":{"v":11770,"d":"₩11,770.00"}},{"$f":"SUBTOTAL(109,OfficeVariances[12월])","v":{"v":11770,"d":"₩11,770.00"}},{"$f":"SUBTOTAL(109,OfficeVariances[연도])","v":{"v":69390,"d":"₩69,390.00"}}]
[]
["오른쪽 셀에서 시작하는 마케팅 차이 표에 마케팅 비용 차이가 자동으로 계산됩니다. 다음 지침은 A30 셀에 있습니다.","마케팅 비용","1월","2월","3월","4월","5월","6월","7월","8월","9월","10월","11월","12월","연도"]
[null,"웹 사이트 호스팅",{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[1월]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[1월]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[1월]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[1월]],MarketingActual[#Headers],0))","v":{"v":0,"d":"₩0.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[2월]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[2월]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[2월]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[2월]],MarketingActual[#Headers],0))","v":{"v":0,"d":"₩0.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[3월]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[3월]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[3월]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[3월]],MarketingActual[#Headers],0))","v":{"v":0,"d":"₩0.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[4월]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[4월]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[4월]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[4월]],MarketingActual[#Headers],0))","v":{"v":0,"d":"₩0.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[5월]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[5월]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[5월]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[5월]],MarketingActual[#Headers],0))","v":{"v":0,"d":"₩0.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[6월]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[6월]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[6월]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[6월]],MarketingActual[#Headers],0))","v":{"v":0,"d":"₩0.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[7월]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[7월]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[7월]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[7월]],MarketingActual[#Headers],0))","v":{"v":500,"d":"₩500.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[8월]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[8월]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[8월]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[8월]],MarketingActual[#Headers],0))","v":{"v":500,"d":"₩500.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[9월]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[9월]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[9월]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[9월]],MarketingActual[#Headers],0))","v":{"v":500,"d":"₩500.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[10월]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[10월]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[10월]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[10월]],MarketingActual[#Headers],0))","v":{"v":500,"d":"₩500.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[11월]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[11월]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[11월]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[11월]],MarketingActual[#Headers],0))","v":{"v":500,"d":"₩500.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[12월]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[12월]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[12월]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[12월]],MarketingActual[#Headers],0))","v":{"v":500,"d":"₩500.00"}},{"$f":"SUM(MarketingVariances[[#This Row],[1월]:[12월]])","v":{"v":3000,"d":"₩3,000.00"}}]
[null,"웹 사이트 업데이트",{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[1월]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[1월]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[1월]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[1월]],MarketingActual[#Headers],0))","v":{"v":0,"d":"₩0.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[2월]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[2월]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[2월]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[2월]],MarketingActual[#Headers],0))","v":{"v":0,"d":"₩0.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[3월]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[3월]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[3월]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[3월]],MarketingActual[#Headers],0))","v":{"v":0,"d":"₩0.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[4월]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[4월]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[4월]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[4월]],MarketingActual[#Headers],0))","v":{"v":0,"d":"₩0.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[5월]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[5월]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[5월]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[5월]],MarketingActual[#Headers],0))","v":{"v":0,"d":"₩0.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[6월]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[6월]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[6월]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[6월]],MarketingActual[#Headers],0))","v":{"v":-500,"d":"(₩500.00)"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[7월]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[7월]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[7월]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[7월]],MarketingActual[#Headers],0))","v":{"v":200,"d":"₩200.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[8월]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[8월]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[8월]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[8월]],MarketingActual[#Headers],0))","v":{"v":200,"d":"₩200.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[9월]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[9월]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[9월]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[9월]],MarketingActual[#Headers],0))","v":{"v":200,"d":"₩200.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[10월]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[10월]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[10월]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[10월]],MarketingActual[#Headers],0))","v":{"v":200,"d":"₩200.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[11월]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[11월]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[11월]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[11월]],MarketingActual[#Headers],0))","v":{"v":200,"d":"₩200.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[12월]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[12월]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[12월]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[12월]],MarketingActual[#Headers],0))","v":{"v":1000,"d":"₩1,000.00"}},{"$f":"SUM(MarketingVariances[[#This Row],[1월]:[12월]])","v":{"v":1500,"d":"₩1,500.00"}}]
[null,"자료 준비",{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[1월]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[1월]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[1월]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[1월]],MarketingActual[#Headers],0))","v":{"v":200,"d":"₩200.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[2월]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[2월]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[2월]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[2월]],MarketingActual[#Headers],0))","v":{"v":0,"d":"₩0.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[3월]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[3월]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[3월]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[3월]],MarketingActual[#Headers],0))","v":{"v":0,"d":"₩0.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[4월]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[4월]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[4월]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[4월]],MarketingActual[#Headers],0))","v":{"v":-500,"d":"(₩500.00)"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[5월]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[5월]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[5월]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[5월]],MarketingActual[#Headers],0))","v":{"v":0,"d":"₩0.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[6월]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[6월]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[6월]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[6월]],MarketingActual[#Headers],0))","v":{"v":0,"d":"₩0.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[7월]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[7월]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[7월]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[7월]],MarketingActual[#Headers],0))","v":{"v":5000,"d":"₩5,000.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[8월]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[8월]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[8월]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[8월]],MarketingActual[#Headers],0))","v":{"v":0,"d":"₩0.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[9월]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[9월]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[9월]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[9월]],MarketingActual[#Headers],0))","v":{"v":0,"d":"₩0.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[10월]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[10월]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[10월]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[10월]],MarketingActual[#Headers],0))","v":{"v":5000,"d":"₩5,000.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[11월]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[11월]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[11월]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[11월]],MarketingActual[#Headers],0))","v":{"v":0,"d":"₩0.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[12월]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[12월]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[12월]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[12월]],MarketingActual[#Headers],0))","v":{"v":0,"d":"₩0.00"}},{"$f":"SUM(MarketingVariances[[#This Row],[1월]:[12월]])","v":{"v":9700,"d":"₩9,700.00"}}]
[null,"자료 인쇄",{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[1월]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[1월]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[1월]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[1월]],MarketingActual[#Headers],0))","v":{"v":100,"d":"₩100.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[2월]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[2월]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[2월]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[2월]],MarketingActual[#Headers],0))","v":{"v":-300,"d":"(₩300.00)"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[3월]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[3월]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[3월]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[3월]],MarketingActual[#Headers],0))","v":{"v":100,"d":"₩100.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[4월]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[4월]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[4월]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[4월]],MarketingActual[#Headers],0))","v":{"v":100,"d":"₩100.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[5월]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[5월]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[5월]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[5월]],MarketingActual[#Headers],0))","v":{"v":-400,"d":"(₩400.00)"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[6월]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[6월]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[6월]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[6월]],MarketingActual[#Headers],0))","v":{"v":20,"d":"₩20.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[7월]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[7월]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[7월]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[7월]],MarketingActual[#Headers],0))","v":{"v":200,"d":"₩200.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[8월]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[8월]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[8월]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[8월]],MarketingActual[#Headers],0))","v":{"v":200,"d":"₩200.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[9월]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[9월]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[9월]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[9월]],MarketingActual[#Headers],0))","v":{"v":200,"d":"₩200.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[10월]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[10월]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[10월]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[10월]],MarketingActual[#Headers],0))","v":{"v":200,"d":"₩200.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[11월]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[11월]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[11월]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[11월]],MarketingActual[#Headers],0))","v":{"v":200,"d":"₩200.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[12월]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[12월]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[12월]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[12월]],MarketingActual[#Headers],0))","v":{"v":200,"d":"₩200.00"}},{"$f":"SUM(MarketingVariances[[#This Row],[1월]:[12월]])","v":{"v":820,"d":"₩820.00"}}]
[null,"마케팅 행사",{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[1월]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[1월]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[1월]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[1월]],MarketingActual[#Headers],0))","v":{"v":200,"d":"₩200.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[2월]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[2월]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[2월]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[2월]],MarketingActual[#Headers],0))","v":{"v":-200,"d":"(₩200.00)"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[3월]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[3월]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[3월]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[3월]],MarketingActual[#Headers],0))","v":{"v":-200,"d":"(₩200.00)"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[4월]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[4월]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[4월]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[4월]],MarketingActual[#Headers],0))","v":{"v":300,"d":"₩300.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[5월]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[5월]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[5월]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[5월]],MarketingActual[#Headers],0))","v":{"v":500,"d":"₩500.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[6월]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[6월]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[6월]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[6월]],MarketingActual[#Headers],0))","v":{"v":-300,"d":"(₩300.00)"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[7월]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[7월]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[7월]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[7월]],MarketingActual[#Headers],0))","v":{"v":2000,"d":"₩2,000.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[8월]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[8월]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[8월]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[8월]],MarketingActual[#Headers],0))","v":{"v":5000,"d":"₩5,000.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[9월]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[9월]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[9월]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[9월]],MarketingActual[#Headers],0))","v":{"v":2000,"d":"₩2,000.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[10월]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[10월]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[10월]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[10월]],MarketingActual[#Headers],0))","v":{"v":2000,"d":"₩2,000.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[11월]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[11월]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[11월]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[11월]],MarketingActual[#Headers],0))","v":{"v":2000,"d":"₩2,000.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[12월]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[12월]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[12월]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[12월]],MarketingActual[#Headers],0))","v":{"v":5000,"d":"₩5,000.00"}},{"$f":"SUM(MarketingVariances[[#This Row],[1월]:[12월]])","v":{"v":18300,"d":"₩18,300.00"}}]
[null,"기타 비용",{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[1월]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[1월]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[1월]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[1월]],MarketingActual[#Headers],0))","v":{"v":55,"d":"₩55.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[2월]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[2월]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[2월]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[2월]],MarketingActual[#Headers],0))","v":{"v":44,"d":"₩44.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[3월]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[3월]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[3월]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[3월]],MarketingActual[#Headers],0))","v":{"v":77,"d":"₩77.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[4월]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[4월]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[4월]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[4월]],MarketingActual[#Headers],0))","v":{"v":-23,"d":"(₩23.00)"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[5월]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[5월]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[5월]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[5월]],MarketingActual[#Headers],0))","v":{"v":13,"d":"₩13.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[6월]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[6월]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[6월]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[6월]],MarketingActual[#Headers],0))","v":{"v":-45,"d":"(₩45.00)"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[7월]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[7월]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[7월]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[7월]],MarketingActual[#Headers],0))","v":{"v":200,"d":"₩200.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[8월]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[8월]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[8월]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[8월]],MarketingActual[#Headers],0))","v":{"v":200,"d":"₩200.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[9월]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[9월]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[9월]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[9월]],MarketingActual[#Headers],0))","v":{"v":200,"d":"₩200.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[10월]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[10월]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[10월]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[10월]],MarketingActual[#Headers],0))","v":{"v":200,"d":"₩200.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[11월]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[11월]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[11월]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[11월]],MarketingActual[#Headers],0))","v":{"v":200,"d":"₩200.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[12월]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[12월]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[12월]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[12월]],MarketingActual[#Headers],0))","v":{"v":200,"d":"₩200.00"}},{"$f":"SUM(MarketingVariances[[#This Row],[1월]:[12월]])","v":{"v":1321,"d":"₩1,321.00"}}]
[null,"소계",{"$f":"SUBTOTAL(109,MarketingVariances[1월])","v":{"v":555,"d":"₩555.00"}},{"$f":"SUBTOTAL(109,MarketingVariances[2월])","v":{"v":-456,"d":"(₩456.00)"}},{"$f":"SUBTOTAL(109,MarketingVariances[3월])","v":{"v":-23,"d":"(₩23.00)"}},{"$f":"SUBTOTAL(109,MarketingVariances[4월])","v":{"v":-123,"d":"(₩123.00)"}},{"$f":"SUBTOTAL(109,MarketingVariances[5월])","v":{"v":113,"d":"₩113.00"}},{"$f":"SUBTOTAL(109,MarketingVariances[6월])","v":{"v":-825,"d":"(₩825.00)"}},{"$f":"SUBTOTAL(109,MarketingVariances[7월])","v":{"v":8100,"d":"₩8,100.00"}},{"$f":"SUBTOTAL(109,MarketingVariances[8월])","v":{"v":6100,"d":"₩6,100.00"}},{"$f":"SUBTOTAL(109,MarketingVariances[9월])","v":{"v":3100,"d":"₩3,100.00"}},{"$f":"SUBTOTAL(109,MarketingVariances[10월])","v":{"v":8100,"d":"₩8,100.00"}},{"$f":"SUBTOTAL(109,MarketingVariances[11월])","v":{"v":3100,"d":"₩3,100.00"}},{"$f":"SUBTOTAL(109,MarketingVariances[12월])","v":{"v":6900,"d":"₩6,900.00"}},{"$f":"SUBTOTAL(109,MarketingVariances[연도])","v":{"v":34641,"d":"₩34,641.00"}}]
[]
["오른쪽 셀에서 시작하는 교육 및 출장 차이 표에서 교육 또는 출장 비용의 차이가 자동으로 계산됩니다. 다음 지침은 A35 셀에 있습니다.","교육/출장","1월","2월","3월","4월","5월","6월","7월","8월","9월","10월","11월","12월","연도"]
[null,"교육 수업",{"$f":"INDEX(TrainingAndTravelPlan[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[1월]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[1월]],TrainingAndTravelPlan[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[1월]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[1월]],TrainingAndTravelActual[#Headers],0))","v":{"v":400,"d":"₩400.00"}},{"$f":"INDEX(TrainingAndTravelPlan[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[2월]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[2월]],TrainingAndTravelPlan[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[2월]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[2월]],TrainingAndTravelActual[#Headers],0))","v":{"v":-400,"d":"(₩400.00)"}},{"$f":"INDEX(TrainingAndTravelPlan[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[3월]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[3월]],TrainingAndTravelPlan[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[3월]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[3월]],TrainingAndTravelActual[#Headers],0))","v":{"v":600,"d":"₩600.00"}},{"$f":"INDEX(TrainingAndTravelPlan[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[4월]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[4월]],TrainingAndTravelPlan[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[4월]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[4월]],TrainingAndTravelActual[#Headers],0))","v":{"v":400,"d":"₩400.00"}},{"$f":"INDEX(TrainingAndTravelPlan[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[5월]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[5월]],TrainingAndTravelPlan[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[5월]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[5월]],TrainingAndTravelActual[#Headers],0))","v":{"v":800,"d":"₩800.00"}},{"$f":"INDEX(TrainingAndTravelPlan[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[6월]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[6월]],TrainingAndTravelPlan[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[6월]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[6월]],TrainingAndTravelActual[#Headers],0))","v":{"v":-800,"d":"(₩800.00)"}},{"$f":"INDEX(TrainingAndTravelPlan[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[7월]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[7월]],TrainingAndTravelPlan[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[7월]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[7월]],TrainingAndTravelActual[#Headers],0))","v":{"v":2000,"d":"₩2,000.00"}},{"$f":"INDEX(TrainingAndTravelPlan[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[8월]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[8월]],TrainingAndTravelPlan[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[8월]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[8월]],TrainingAndTravelActual[#Headers],0))","v":{"v":2000,"d":"₩2,000.00"}},{"$f":"INDEX(TrainingAndTravelPlan[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[9월]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[9월]],TrainingAndTravelPlan[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[9월]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[9월]],TrainingAndTravelActual[#Headers],0))","v":{"v":2000,"d":"₩2,000.00"}},{"$f":"INDEX(TrainingAndTravelPlan[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[10월]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[10월]],TrainingAndTravelPlan[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[10월]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[10월]],TrainingAndTravelActual[#Headers],0))","v":{"v":2000,"d":"₩2,000.00"}},{"$f":"INDEX(TrainingAndTravelPlan[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[11월]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[11월]],TrainingAndTravelPlan[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[11월]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[11월]],TrainingAndTravelActual[#Headers],0))","v":{"v":2000,"d":"₩2,000.00"}},{"$f":"INDEX(TrainingAndTravelPlan[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[12월]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[12월]],TrainingAndTravelPlan[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[12월]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[12월]],TrainingAndTravelActual[#Headers],0))","v":{"v":2000,"d":"₩2,000.00"}},{"$f":"SUM(TrainingAndTravelVariances[[#This Row],[1월]:[12월]])","v":{"v":13000,"d":"₩13,000.00"}}]
[null,"교육 관련 출장 비용",{"$f":"INDEX(TrainingAndTravelPlan[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[1월]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[1월]],TrainingAndTravelPlan[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[1월]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[1월]],TrainingAndTravelActual[#Headers],0))","v":{"v":800,"d":"₩800.00"}},{"$f":"INDEX(TrainingAndTravelPlan[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[2월]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[2월]],TrainingAndTravelPlan[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[2월]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[2월]],TrainingAndTravelActual[#Headers],0))","v":{"v":-200,"d":"(₩200.00)"}},{"$f":"INDEX(TrainingAndTravelPlan[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[3월]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[3월]],TrainingAndTravelPlan[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[3월]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[3월]],TrainingAndTravelActual[#Headers],0))","v":{"v":600,"d":"₩600.00"}},{"$f":"INDEX(TrainingAndTravelPlan[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[4월]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[4월]],TrainingAndTravelPlan[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[4월]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[4월]],TrainingAndTravelActual[#Headers],0))","v":{"v":800,"d":"₩800.00"}},{"$f":"INDEX(TrainingAndTravelPlan[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[5월]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[5월]],TrainingAndTravelPlan[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[5월]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[5월]],TrainingAndTravelActual[#Headers],0))","v":{"v":1200,"d":"₩1,200.00"}},{"$f":"INDEX(TrainingAndTravelPlan[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[6월]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[6월]],TrainingAndTravelPlan[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[6월]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[6월]],TrainingAndTravelActual[#Headers],0))","v":{"v":-1500,"d":"(₩1,500.00)"}},{"$f":"INDEX(TrainingAndTravelPlan[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[7월]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[7월]],TrainingAndTravelPlan[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[7월]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[7월]],TrainingAndTravelActual[#Headers],0))","v":{"v":2000,"d":"₩2,000.00"}},{"$f":"INDEX(TrainingAndTravelPlan[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[8월]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[8월]],TrainingAndTravelPlan[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[8월]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[8월]],TrainingAndTravelActual[#Headers],0))","v":{"v":2000,"d":"₩2,000.00"}},{"$f":"INDEX(TrainingAndTravelPlan[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[9월]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[9월]],TrainingAndTravelPlan[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[9월]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[9월]],TrainingAndTravelActual[#Headers],0))","v":{"v":2000,"d":"₩2,000.00"}},{"$f":"INDEX(TrainingAndTravelPlan[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[10월]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[10월]],TrainingAndTravelPlan[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[10월]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[10월]],TrainingAndTravelActual[#Headers],0))","v":{"v":2000,"d":"₩2,000.00"}},{"$f":"INDEX(TrainingAndTravelPlan[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[11월]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[11월]],TrainingAndTravelPlan[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[11월]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[11월]],TrainingAndTravelActual[#Headers],0))","v":{"v":2000,"d":"₩2,000.00"}},{"$f":"INDEX(TrainingAndTravelPlan[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[12월]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[12월]],TrainingAndTravelPlan[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[12월]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[12월]],TrainingAndTravelActual[#Headers],0))","v":{"v":2000,"d":"₩2,000.00"}},{"$f":"SUM(TrainingAndTravelVariances[[#This Row],[1월]:[12월]])","v":{"v":13700,"d":"₩13,700.00"}}]
[null,"소계",{"$f":"SUBTOTAL(109,TrainingAndTravelVariances[1월])","v":{"v":1200,"d":"₩1,200.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelVariances[2월])","v":{"v":-600,"d":"(₩600.00)"}},{"$f":"SUBTOTAL(109,TrainingAndTravelVariances[3월])","v":{"v":1200,"d":"₩1,200.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelVariances[4월])","v":{"v":1200,"d":"₩1,200.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelVariances[5월])","v":{"v":2000,"d":"₩2,000.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelVariances[6월])","v":{"v":-2300,"d":"(₩2,300.00)"}},{"$f":"SUBTOTAL(109,TrainingAndTravelVariances[7월])","v":{"v":4000,"d":"₩4,000.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelVariances[8월])","v":{"v":4000,"d":"₩4,000.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelVariances[9월])","v":{"v":4000,"d":"₩4,000.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelVariances[10월])","v":{"v":4000,"d":"₩4,000.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelVariances[11월])","v":{"v":4000,"d":"₩4,000.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelVariances[12월])","v":{"v":4000,"d":"₩4,000.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelVariances[연도])","v":{"v":26700,"d":"₩26,700.00"}}]
[]
["오른쪽 셀에서 시작하는 합계 차이 표에 지출 차이가 자동으로 계산됩니다.","합계","1월","2월","3월","4월","5월","6월","7월","8월","9월","10월","11월","12월","연도"]
[null,"월별 실제 지출",{"$f":"TrainingAndTravelVariances[[#Totals],[1월]]+MarketingVariances[[#Totals],[1월]]+OfficeVariances[[#Totals],[1월]]+EmployeeVariances[[#Totals],[1월]]","v":{"v":1738,"d":"₩1,738.00"}},{"$f":"TrainingAndTravelVariances[[#Totals],[2월]]+MarketingVariances[[#Totals],[2월]]+OfficeVariances[[#Totals],[2월]]+EmployeeVariances[[#Totals],[2월]]","v":{"v":-984,"d":"(₩984.00)"}},{"$f":"TrainingAndTravelVariances[[#Totals],[3월]]+MarketingVariances[[#Totals],[3월]]+OfficeVariances[[#Totals],[3월]]+EmployeeVariances[[#Totals],[3월]]","v":{"v":1255,"d":"₩1,255.00"}},{"$f":"TrainingAndTravelVariances[[#Totals],[4월]]+MarketingVariances[[#Totals],[4월]]+OfficeVariances[[#Totals],[4월]]+EmployeeVariances[[#Totals],[4월]]","v":{"v":301,"d":"₩301.00"}},{"$f":"TrainingAndTravelVariances[[#Totals],[5월]]+MarketingVariances[[#Totals],[5월]]+OfficeVariances[[#Totals],[5월]]+EmployeeVariances[[#Totals],[5월]]","v":{"v":1440,"d":"₩1,440.00"}},{"$f":"TrainingAndTravelVariances[[#Totals],[6월]]+MarketingVariances[[#Totals],[6월]]+OfficeVariances[[#Totals],[6월]]+EmployeeVariances[[#Totals],[6월]]","v":{"v":-3744,"d":"(₩3,744.00)"}},{"$f":"TrainingAndTravelVariances[[#Totals],[7월]]+MarketingVariances[[#Totals],[7월]]+OfficeVariances[[#Totals],[7월]]+EmployeeVariances[[#Totals],[7월]]","v":{"v":134695,"d":"₩134,695.00"}},{"$f":"TrainingAndTravelVariances[[#Totals],[8월]]+MarketingVariances[[#Totals],[8월]]+OfficeVariances[[#Totals],[8월]]+EmployeeVariances[[#Totals],[8월]]","v":{"v":138918,"d":"₩138,918.00"}},{"$f":"TrainingAndTravelVariances[[#Totals],[9월]]+MarketingVariances[[#Totals],[9월]]+OfficeVariances[[#Totals],[9월]]+EmployeeVariances[[#Totals],[9월]]","v":{"v":135918,"d":"₩135,918.00"}},{"$f":"TrainingAndTravelVariances[[#Totals],[10월]]+MarketingVariances[[#Totals],[10월]]+OfficeVariances[[#Totals],[10월]]+EmployeeVariances[[#Totals],[10월]]","v":{"v":140918,"d":"₩140,918.00"}},{"$f":"TrainingAndTravelVariances[[#Totals],[11월]]+MarketingVariances[[#Totals],[11월]]+OfficeVariances[[#Totals],[11월]]+EmployeeVariances[[#Totals],[11월]]","v":{"v":136218,"d":"₩136,218.00"}},{"$f":"TrainingAndTravelVariances[[#Totals],[12월]]+MarketingVariances[[#Totals],[12월]]+OfficeVariances[[#Totals],[12월]]+EmployeeVariances[[#Totals],[12월]]","v":{"v":140018,"d":"₩140,018.00"}},{"$f":"TrainingAndTravelVariances[[#Totals],[연도]]+MarketingVariances[[#Totals],[연도]]+OfficeVariances[[#Totals],[연도]]+EmployeeVariances[[#Totals],[연도]]","v":{"v":826691,"d":"₩826,691.00"}}]
[null,"총 실제 지출",{"$f":"SUM($C$36:C36)","v":{"v":1738,"d":"₩1,738.00"}},{"$f":"SUM($C$36:D36)","v":{"v":754,"d":"₩754.00"}},{"$f":"SUM($C$36:E36)","v":{"v":2009,"d":"₩2,009.00"}},{"$f":"SUM($C$36:F36)","v":{"v":2310,"d":"₩2,310.00"}},{"$f":"SUM($C$36:G36)","v":{"v":3750,"d":"₩3,750.00"}},{"$f":"SUM($C$36:H36)","v":{"v":6,"d":"₩6.00"}},{"$f":"SUM($C$36:I36)","v":{"v":134701,"d":"₩134,701.00"}},{"$f":"SUM($C$36:J36)","v":{"v":273619,"d":"₩273,619.00"}},{"$f":"SUM($C$36:K36)","v":{"v":409537,"d":"₩409,537.00"}},{"$f":"SUM($C$36:L36)","v":{"v":550455,"d":"₩550,455.00"}},{"$f":"SUM($C$36:M36)","v":{"v":686673,"d":"₩686,673.00"}},{"$f":"SUM($C$36:N36)","v":{"v":826691,"d":"₩826,691.00"}}]

{"sheet":"지출 분석","index":4,"n_rows":14,"n_cols":16,"rows_kept":14,"merged":[[1,1,2,3],[1,5,1,6],[2,4,2,6],[11,1,11,2],[11,3,11,5],[13,1,36,5]]}
["연간 계획 및 실제 지출, 지출 차이 및 차이 비율은 이 워크시트의 각 지출 범주에 대해 자동으로 업데이트됩니다. 이 워크시트의 사용 방법에 대한 유용한 지침은 이 열의 셀에 있습니다. 아래쪽 화살표를 사용하여 시작할 수 있습니다. ",{"$nulls":5}," ",{"$nulls":8}," "]
["오른쪽 셀에 회사 이름이 자동으로 업데이트됩니다. F2 셀에 로고를 입력합니다.",{"$f":"'계획한 지출'!B2:D3","v":"회사 이름"},{"$nulls":3},"이 셀에는 로고 자리 표시자가 있습니다."]
["E3 셀에는 이 워크시트의 제목이 표시됩니다. 다음 지침은 A5 셀에 있습니다.",{"$nulls":3},{"$f":"worksheet_title","v":"세부 지출 예상 항목"}]
[]
["오른쪽 셀에서 시작하는 분석 표에 계획한 지출, 실제 지출, 지출 차이 및 차이 비율이 자동으로 계산됩니다. 다음 지침은 A12 셀에 있습니다.표시됩니다.","지출 범주","계획한 지출","실제 지출","지출 차이","차이 비율"]
[null,"직원 비용",{"$f":"EmployeePlan[[#Totals],[연도]]","v":{"v":1355090,"d":"₩1,355,090.00"}},{"$f":"EmployeeActual[[#Totals],[연도]]","v":{"v":659130,"d":"₩659,130.00"}},{"$f":"C6-D6","v":{"v":695960,"d":"₩695,960.00"}},{"$f":"E6/C6","v":{"v":0.5135895032802249,"d":"51%"}}]
[null,{"$f":"'계획한 지출'!B10","v":"사무 비용"},{"$f":"OfficePlan[[#Totals],[연도]]","v":{"v":138740,"d":"₩138,740.00"}},{"$f":"OfficeActual[[#Totals],[연도]]","v":{"v":69350,"d":"₩69,350.00"}},{"$f":"C7-D7","v":{"v":69390,"d":"₩69,390.00"}},{"$f":"E7/C7","v":{"v":0.5001441545336601,"d":"50%"}}]
[null,{"$f":"'계획한 지출'!B21","v":"마케팅 비용"},{"$f":"MarketingPlan[[#Totals],[연도]]","v":{"v":67800,"d":"₩67,800.00"}},{"$f":"MarketingActual[[#Totals],[연도]]","v":{"v":33159,"d":"₩33,159.00"}},{"$f":"C8-D8","v":{"v":34641,"d":"₩34,641.00"}},{"$f":"E8/C8","v":{"v":0.510929203539823,"d":"51%"}}]
[null,{"$f":"'계획한 지출'!B30","v":"교육/출장"},{"$f":"TrainingAndTravelPlan[[#Totals],[연도]]","v":{"v":48000,"d":"₩48,000.00"}},{"$f":"TrainingAndTravelActual[[#Totals],[연도]]","v":{"v":21300,"d":"₩21,300.00"}},{"$f":"C9-D9","v":{"v":26700,"d":"₩26,700.00"}},{"$f":"E9/C9","v":{"v":0.55625,"d":"56%"}}]
[null,{"$f":"'계획한 지출'!B35","v":"합계"},{"$f":"'계획한 지출'!O36","v":{"v":1609630,"d":"₩1,609,630.00"}},{"$f":"'실제 지출'!O36","v":{"v":782939,"d":"₩782,939.00"}},{"$f":"C10-D10","v":{"v":826691,"d":"₩826,691.00"}},{"$f":"E10/C10","v":{"v":0.5135907009685455,"d":"51%"}}]
[]
["오른쪽 셀에 계획한 지출의 원형 차트가 있고, D12 셀에 실제 지출의 원형 차트가 있습니다. 다음 지침은 A14 셀에 있습니다.","이 셀에는 다양한 범주의 계획 지출을 보여 주는 원형 차트가 있습니다.",null,"이 셀에는 다양한 범주에서 발생한 실제 지출을 보여 주는 원형 차트가 있습니다."]
[]
["오른쪽 셀에 월별 지출의 계획, 실제, 차이를 보여 주는 차트가 있습니다."]