{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["경비 보고서"],"not_rendered":{"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"경비 보고서","index":0,"n_rows":45,"n_cols":10,"rows_kept":45,"merged":[[18,1,18,9],[27,1,27,9],[35,1,35,9],[40,1,43,4]]}
["회사 이름"]
["경비 보고서"]
[]
[null,"직원:","홍영주",{"$nulls":3},"결재자:"]
[null,"부서:","영업부"]
[null,"주중 근무 종료일:","2013-03-07",{"$nulls":3},"날짜:"]
[null,"주행 지원:",{"v":670,"d":"₩670.00"}]
[]
[null,null,{"$f":"UPPER(TEXT(C10,\"aaaa\"))","v":"금요일"},"토요일","일요일","월요일","화요일","수요일","목요일"]
[null,"교통",{"$f":"주중_근무_종료일-6","v":"2013-03-01"},{"$f":"주중_근무_종료일-5","v":"2013-03-02"},{"$f":"주중_근무_종료일-4","v":"2013-03-03"},{"$f":"주중_근무_종료일-3","v":"2013-03-04"},{"$f":"주중_근무_종료일-2","v":"2013-03-05"},{"$f":"주중_근무_종료일-1","v":"2013-03-06"},{"$f":"주중_근무_종료일","v":"2013-03-07"},"합계"]
[null,"주행 거리",{"v":145,"d":"145 "},{"$nulls":6},{"$f":"SUM(교통비[[#This Row],[Day 1]:[Day 7]])","v":{"v":145,"d":"145 "}}]
[null,"주행 거리 정산",{"$f":"C11*마일리지_요율","v":{"v":97150,"d":"₩97,150"}},{"$f":"D11*마일리지_요율","v":{"v":0,"d":"₩0"}},{"v":0,"d":"₩0"},{"v":0,"d":"₩0"},{"v":0,"d":"₩0"},{"v":0,"d":"₩0"},{"v":0,"d":"₩0"},{"$f":"SUM(교통비[[#This Row],[Day 1]:[Day 7]])","v":{"v":97150,"d":"₩97,150"}}]
[null,"주차 및 통행료",{"$nulls":3},{"v":17000,"d":"₩17,000"},{"$nulls":3},{"$f":"SUM(교통비[[#This Row],[Day 1]:[Day 7]])","v":{"v":17000,"d":"₩17,000"}}]
[null,"자동차 렌트",{"v":79000,"d":"₩79,000"},null,null,{"v":79000,"d":"₩79,000"},{"$nulls":3},{"$f":"SUM(교통비[[#This Row],[Day 1]:[Day 7]])","v":{"v":158000,"d":"₩158,000"}}]
[null,"택시/리무진",{"$nulls":7},{"$f":"SUM(교통비[[#This Row],[Day 1]:[Day 7]])","v":{"v":0,"d":"₩0"}}]
[null,"기타(기차 또는 버스)",{"$nulls":7},{"$f":"SUM(교통비[[#This Row],[Day 1]:[Day 7]])","v":{"v":0,"d":"₩0"}}]
[null,"항공료",{"$nulls":3},{"v":235000,"d":"₩235,000"},{"$nulls":3},{"$f":"SUM(교통비[[#This Row],[Day 1]:[Day 7]])","v":{"v":235000,"d":"₩235,000"}}]
[null,"합계",{"$f":"SUBTOTAL(109,C12:C17)","v":{"v":176150,"d":"₩176,150"}},{"$f":"SUBTOTAL(109,D12:D17)","v":{"v":0,"d":"₩0"}},null,{"$f":"SUBTOTAL(109,F12:F17)","v":{"v":331000,"d":"₩331,000"}},{"$f":"SUBTOTAL(109,G12:G17)","v":{"v":0,"d":"₩0"}},{"$f":"SUBTOTAL(109,H12:H17)","v":{"v":0,"d":"₩0"}},{"$f":"SUBTOTAL(109,I12:I17)","v":{"v":0,"d":"₩0"}},{"$f":"SUM(J12:J17)","v":{"v":507150,"d":"₩507,150"}}]
[]
[null,"숙박 & 식사"]
[null,"숙박비",{"v":145000,"d":"₩145,000"},{"$nulls":6},{"$f":"SUM(숙박_식사[[#This Row],[Day 1]:[Day 7]])","v":{"v":145000,"d":"₩145,000"}}]
[null,"아침식사",{"v":11490,"d":"₩11,490"},{"$nulls":6},{"$f":"SUM(숙박_식사[[#This Row],[Day 1]:[Day 7]])","v":{"v":11490,"d":"₩11,490"}}]
[null,"점심식사",{"v":12000,"d":"₩12,000"},{"$nulls":6},{"$f":"SUM(숙박_식사[[#This Row],[Day 1]:[Day 7]])","v":{"v":12000,"d":"₩12,000"}}]
[null,"저녁식사",{"v":17000,"d":"₩17,000"},{"$nulls":6},{"$f":"SUM(숙박_식사[[#This Row],[Day 1]:[Day 7]])","v":{"v":17000,"d":"₩17,000"}}]
[null,"스낵",{"$f":"C24*마일리지_요율","v":{"v":11390000,"d":"₩11,390,000"}},{"$nulls":6},{"$f":"SUM(숙박_식사[[#This Row],[Day 1]:[Day 7]])","v":{"v":11390000,"d":"₩11,390,000"}}]
[null,"식사 비용 소계",{"$f":"SUM(C22:C24)","v":{"v":40490,"d":"₩40,490"}},{"$f":"SUM(D22:D24)","v":{"v":0,"d":"₩0"}},{"v":0,"d":"₩0"},{"v":0,"d":"₩0"},{"v":0,"d":"₩0"},{"v":0,"d":"₩0"},{"v":0,"d":"₩0"},{"$f":"SUM(숙박_식사[[#This Row],[Day 1]:[Day 7]])","v":{"v":40490,"d":"₩40,490"}}]
[null,"합계",{"$f":"SUBTOTAL(109,C21,C26)","v":{"v":185490,"d":"₩185,490"}},{"$f":"SUBTOTAL(109,D21,D26)","v":{"v":0,"d":"₩0"}},{"v":0,"d":"₩0"},{"v":0,"d":"₩0"},{"v":0,"d":"₩0"},{"v":0,"d":"₩0"},{"v":0,"d":"₩0"},{"$f":"SUBTOTAL(109,J21,J26)","v":{"v":185490,"d":"₩185,490"}}]
[]
[null,"기타"]
[null,"소모품",{"$nulls":7},{"$f":"SUM(기타[[#This Row],[Day 1]:[Day 7]])","v":{"v":0,"d":"₩0"}}]
[null,"장비",{"$nulls":7},{"$f":"SUM(기타[[#This Row],[Day 1]:[Day 7]])","v":{"v":0,"d":"₩0"}}]
[null,"전화, 팩스, 인터넷",{"$nulls":7},{"$f":"SUM(기타[[#This Row],[Day 1]:[Day 7]])","v":{"v":0,"d":"₩0"}}]
[null,"기타*",{"$nulls":7},{"$f":"SUM(기타[[#This Row],[Day 1]:[Day 7]])","v":{"v":0,"d":"₩0"}}]
[null,"여가",{"$nulls":3},{"v":199000,"d":"₩199,000"},{"$nulls":3},{"$f":"SUM(기타[[#This Row],[Day 1]:[Day 7]])","v":{"v":199000,"d":"₩199,000"}}]
[null,"합계",{"$f":"SUBTOTAL(109,기타[Day 1])","v":{"v":0,"d":"₩0"}},{"$f":"SUBTOTAL(109,기타[Day 2])","v":{"v":0,"d":"₩0"}},{"$f":"SUBTOTAL(109,기타[Day 3])","v":{"v":0,"d":"₩0"}},{"$f":"SUBTOTAL(109,기타[Day 4])","v":{"v":199000,"d":"₩199,000"}},{"$f":"SUBTOTAL(109,기타[Day 5])","v":{"v":0,"d":"₩0"}},{"$f":"SUBTOTAL(109,기타[Day 6])","v":{"v":0,"d":"₩0"}},{"$f":"SUBTOTAL(109,기타[Day 7])","v":{"v":0,"d":"₩0"}},{"$f":"SUBTOTAL(109,기타[Total])","v":{"v":199000,"d":"₩199,000"}}]
[]
[null,"총합계",{"$f":"SUM(기타[[#Totals],[Day 1]],숙박_식사[[#Totals],[Day 1]],교통비[[#Totals],[Day 1]])","v":{"v":361640,"d":"₩361,640"}},{"$f":"SUM(기타[[#Totals],[Day 2]],숙박_식사[[#Totals],[Day 2]],교통비[[#Totals],[Day 2]])","v":{"v":0,"d":"₩0"}},{"$f":"SUM(기타[[#Totals],[Day 3]],숙박_식사[[#Totals],[Day 3]],교통비[[#Totals],[Day 3]])","v":{"v":0,"d":"₩0"}},{"$f":"SUM(기타[[#Totals],[Day 4]],숙박_식사[[#Totals],[Day 4]],교통비[[#Totals],[Day 4]])","v":{"v":530000,"d":"₩530,000"}},{"$f":"SUM(기타[[#Totals],[Day 5]],숙박_식사[[#Totals],[Day 5]],교통비[[#Totals],[Day 5]])","v":{"v":0,"d":"₩0"}},{"$f":"SUM(기타[[#Totals],[Day 6]],숙박_식사[[#Totals],[Day 6]],교통비[[#Totals],[Day 6]])","v":{"v":0,"d":"₩0"}},{"$f":"SUM(기타[[#Totals],[Day 7]],숙박_식사[[#Totals],[Day 7]],교통비[[#Totals],[Day 7]])","v":{"v":0,"d":"₩0"}},{"$f":"SUM(기타[[#Totals],[Total]],숙박_식사[[#Totals],[Total]],교통비[[#Totals],[Total]])","v":{"v":891640,"d":"₩891,640"}}]
[]
[{"$nulls":9},"총 지출"]
[null,"*\"여가\" 및 \"기타\" 항목에 대한 비즈니스 목적:",{"$nulls":7},{"$f":"SUM(J18,J27,J35)","v":{"v":891640,"d":"₩891,640"}}]
[{"$nulls":9},"선불"]
[]
[{"$nulls":9},"총 정산 금액"]
[{"$nulls":9},{"$f":"J40-J42","v":{"v":891640,"d":"₩891,640"}}]
[{"$nulls":9},"모든 영수증을 첨부하세요."]