{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["거래명세서 기본양식_1","거래명세서_2","거래명세서_3"],"not_rendered":{"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"거래명세서 기본양식_1","index":0,"n_rows":52,"n_cols":31,"rows_kept":52,"merged":[[1,1,2,33],[3,1,10,1],[3,2,4,5],[3,6,4,15],[3,16,10,16],[3,17,4,20],[3,21,4,33],[5,2,6,5],[5,6,6,15],[5,17,6,20],[5,21,6,26],[5,27,6,28],[5,29,6,33],[7,2,8,5],[7,6,8,15],[7,17,8,20],[7,21,8,33],[9,2,10,5],[9,6,10,15],[9,17,10,20],[9,21,10,26],[9,27,10,28],[9,29,10,33],[11,4,11,11],[11,12,11,16],[11,17,11,20],[11,21,11,24],[11,25,11,29],[11,30,11,33],[12,4,12,11],[12,12,12,16],[12,17,12,20],[12,21,12,24],[12,25,12,29],[12,30,12,33],[13,4,13,11],[13,12,13,16],[13,17,13,20],[13,21,13,24],[13,25,13,29],[13,30,13,33],[14,4,14,11],[14,12,14,16],[14,17,14,20],[14,21,14,24],[14,25,14,29],[14,30,14,33],[15,4,15,11],[15,12,15,16],[15,17,15,20],[15,21,15,24],[15,25,15,29],[15,30,15,33],[16,4,16,11],[16,12,16,16],[16,17,16,20],[16,21,16,24],[16,25,16,29],[16,30,16,33],[17,4,17,11],[17,12,17,16],[17,17,17,20],[17,21,17,24],[17,25,17,29],[17,30,17,33],[18,4,18,11],[18,12,18,16],[18,17,18,20],[18,21,18,24],[18,25,18,29],[18,30,18,33],[19,4,19,11],[19,12,19,16],[19,17,19,20],[19,21,19,24],[19,25,19,29],[19,30,19,33],[20,4,20,11],[20,12,20,16],[20,17,20,20],[20,21,20,24],[20,25,20,29],[20,30,20,33],[21,4,21,11],[21,12,21,16],[21,17,21,20],[21,21,21,24],[21,25,21,29],[21,30,21,33],[22,4,22,11],[22,12,22,16],[22,17,22,20],[22,21,22,24],[22,25,22,29],[22,30,22,33],[23,4,23,11],[23,12,23,16],[23,17,23,20],[23,21,23,24],[23,25,23,29],[23,30,23,33],[24,1,25,6],[24,7,25,9],[24,10,25,10],[24,11,25,15],[24,16,25,20],[24,21,25,21],[24,22,25,26],[24,27,25,33],[28,1,29,33],[30,1,37,1],[30,2,31,5],[30,6,31,15],[30,16,37,16],[30,17,31,20],[30,21,31,33],[32,2,33,5],[32,6,33,15],[32,17,33,20],[32,21,33,26],[32,27,33,28],[32,29,33,33],[34,2,35,5],[34,6,35,15],[34,17,35,20],[34,21,35,33],[36,2,37,5],[36,6,37,15],[36,17,37,20],[36,21,37,26],[36,27,37,28],[36,29,37,33],[38,4,38,11],[38,12,38,16],[38,17,38,20],[38,21,38,24],[38,25,38,29],[38,30,38,33],[39,4,39,11],[39,12,39,16],[39,17,39,20],[39,21,39,24],[39,25,39,29],[39,30,39,33],[40,4,40,11],[40,12,40,16],[40,17,40,20],[40,21,40,24],[40,25,40,29],[40,30,40,33],[41,4,41,11],[41,12,41,16],[41,17,41,20],[41,21,41,24],[41,25,41,29],[41,30,41,33],[42,4,42,11],[42,12,42,16],[42,17,42,20],[42,21,42,24],[42,25,42,29],[42,30,42,33],[43,4,43,11],[43,12,43,16],[43,17,43,20],[43,21,43,24],[43,25,43,29],[43,30,43,33],[44,4,44,11],[44,12,44,16],[44,17,44,20],[44,21,44,24],[44,25,44,29],[44,30,44,33],[45,4,45,11],[45,12,45,16],[45,17,45,20],[45,21,45,24],[45,25,45,29],[45,30,45,33],[46,4,46,11],[46,12,46,16],[46,17,46,20],[46,21,46,24],[46,25,46,29],[46,30,46,33],[47,4,47,11],[47,12,47,16],[47,17,47,20],[47,21,47,24],[47,25,47,29],[47,30,47,33],[48,4,48,11],[48,12,48,16],[48,17,48,20],[48,21,48,24],[48,25,48,29],[48,30,48,33],[49,4,49,11],[49,12,49,16],[49,17,49,20],[49,21,49,24],[49,25,49,29],[49,30,49,33],[50,4,50,11],[50,12,50,16],[50,17,50,20],[50,21,50,24],[50,25,50,29],[50,30,50,33],[51,1,52,6],[51,7,52,9],[51,10,52,10],[51,11,52,15],[51,16,52,20],[51,21,52,21],[51,22,52,26],[51,27,52,33]]}
[]
[null,"거 래 명 세 서 (공급받는자 보관용)"]
[]
[null,"공\n급\n받\n는\n자","상  호\n(법인명)",{"$nulls":13},"공\n\n급\n\n자","등록번호"]
[]
[null,null,"사업장\n주  소",{"$nulls":14},"상  호\n(법인명)",{"$nulls":9},"성 명"]
[]
[null,null,"전화번호",{"$nulls":14},"사업장\n주  소"]
[]
[null,null,"합계금액\n(VAT포함)",{"$nulls":3},{"$f":"SUM(Z13:Z24)+SUM(AE13:AE24)","v":0},{"$nulls":10},"전  화",{"$nulls":9},"팩 스"]
[]
[null,"년","월","일","품               목",{"$nulls":7},"규격",{"$nulls":4},"수량",{"$nulls":3},"단가",{"$nulls":3},"공급가액",{"$nulls":4},"세액"]
[{"$nulls":25},{"$f":"IF(V13=\"\",\"\",R13*V13)","v":""},{"$nulls":4},{"$f":"IF(V13=\"\",\"\",Z13*0.1)","v":""}]
[{"$nulls":25},"",{"$nulls":4},""]
[{"$nulls":25},"",{"$nulls":4},""]
[{"$nulls":25},"",{"$nulls":4},""]
[{"$nulls":25},"",{"$nulls":4},""]
[{"$nulls":25},"",{"$nulls":4},""]
[{"$nulls":25},"",{"$nulls":4},""]
[{"$nulls":25},"",{"$nulls":4},""]
[{"$nulls":25},"",{"$nulls":4},""]
[{"$nulls":25},"",{"$nulls":4},""]
[{"$nulls":25},"",{"$nulls":4},""]
[{"$nulls":25},"",{"$nulls":4},""]
[null,"인 수 자",{"$nulls":8},"인","납 품 자",{"$nulls":9},"인","미 수 금"]
[]
[]
[]
[null,"거 래 명 세 서 (공급자 보관용)"]
[]
[null,"공\n급\n받\n는\n자","상  호\n(법인명)",{"$nulls":3},{"$f":"G4","v":0},{"$nulls":9},"공\n\n급\n\n자","등록번호",{"$nulls":3},{"$f":"V4","v":0}]
[]
[null,null,"사업장\n주  소",{"$nulls":3},{"$f":"G6","v":0},{"$nulls":10},"상  호\n(법인명)",{"$nulls":3},{"$f":"V6","v":0},{"$nulls":5},"성 명",null,{"$f":"AD6","v":0}]
[]
[null,null,"전화번호",{"$nulls":3},{"$f":"G8","v":0},{"$nulls":10},"사업장\n주  소",{"$nulls":3},{"$f":"V8","v":0}]
[]
[null,null,"합계금액\n(VAT포함)",{"$nulls":3},{"$f":"G10","v":0},{"$nulls":10},"전  화",{"$nulls":3},{"$f":"V10","v":0},{"$nulls":5},"팩 스",null,{"$f":"AD10","v":0}]
[]
[null,"년","월","일","품               목",{"$nulls":7},"규격",{"$nulls":4},"수량",{"$nulls":3},"단가",{"$nulls":3},"공급가액",{"$nulls":4},"세액"]
[null,{"$f":"B13","v":0},0,0,0,{"$nulls":7},{"$f":"M13","v":0},{"$nulls":4},{"$f":"R13","v":0},{"$nulls":3},{"$f":"V13","v":0},{"$nulls":3},{"$f":"Z13","v":""},{"$nulls":4},{"$f":"AE13","v":""}]
[null,0,0,0,0,{"$nulls":7},0,{"$nulls":4},0,{"$nulls":3},0,{"$nulls":3},"",{"$nulls":4},""]
[null,0,0,0,0,{"$nulls":7},0,{"$nulls":4},0,{"$nulls":3},0,{"$nulls":3},"",{"$nulls":4},""]
[null,0,0,0,0,{"$nulls":7},0,{"$nulls":4},0,{"$nulls":3},0,{"$nulls":3},"",{"$nulls":4},""]
[null,0,0,0,0,{"$nulls":7},0,{"$nulls":4},0,{"$nulls":3},0,{"$nulls":3},"",{"$nulls":4},""]
[null,0,0,0,0,{"$nulls":7},0,{"$nulls":4},0,{"$nulls":3},0,{"$nulls":3},"",{"$nulls":4},""]
[null,0,0,0,0,{"$nulls":7},0,{"$nulls":4},0,{"$nulls":3},0,{"$nulls":3},"",{"$nulls":4},""]
[null,0,0,0,0,{"$nulls":7},0,{"$nulls":4},0,{"$nulls":3},0,{"$nulls":3},"",{"$nulls":4},""]
[null,0,0,0,0,{"$nulls":7},0,{"$nulls":4},0,{"$nulls":3},0,{"$nulls":3},"",{"$nulls":4},""]
[null,0,0,0,0,{"$nulls":7},0,{"$nulls":4},0,{"$nulls":3},0,{"$nulls":3},"",{"$nulls":4},""]
[null,0,0,0,0,{"$nulls":7},0,{"$nulls":4},0,{"$nulls":3},0,{"$nulls":3},"",{"$nulls":4},""]
[null,0,0,0,0,{"$nulls":7},0,{"$nulls":4},0,{"$nulls":3},0,{"$nulls":3},"",{"$nulls":4},""]
[null,{"$f":"B25","v":"인 수 자"},{"$nulls":8},"인",{"$f":"L25","v":"납 품 자"},{"$nulls":9},"인",{"$f":"W25","v":"미 수 금"}]

{"sheet":"거래명세서_2","index":1,"n_rows":42,"n_cols":26,"rows_kept":42,"merged":[[0,0,2,5],[1,6,1,7],[1,13,1,22],[2,14,2,16],[3,1,3,5],[3,14,3,22],[4,14,5,22],[5,1,5,4],[6,1,6,4],[6,7,6,10],[6,14,6,16],[6,19,6,22],[8,1,8,5],[8,7,8,8],[8,10,8,11],[8,12,8,14],[8,16,8,18],[8,19,8,22],[9,1,9,5],[9,7,9,8],[9,10,9,11],[9,12,9,14],[9,16,9,18],[9,19,9,22],[10,1,10,5],[10,7,10,8],[10,10,10,11],[10,12,10,14],[10,16,10,18],[10,19,10,22],[11,1,11,5],[11,7,11,8],[11,10,11,11],[11,12,11,14],[11,16,11,18],[11,19,11,22],[12,1,12,5],[12,7,12,8],[12,10,12,11],[12,12,12,14],[12,16,12,18],[12,19,12,22],[13,1,13,5],[13,7,13,8],[13,10,13,11],[13,12,13,14],[13,16,13,18],[13,19,13,22],[14,1,14,5],[14,7,14,8],[14,10,14,11],[14,12,14,14],[14,16,14,18],[14,19,14,22],[15,1,15,5],[15,7,15,8],[15,10,15,11],[15,12,15,14],[15,16,15,18],[15,19,15,22],[16,1,16,5],[16,7,16,8],[16,10,16,11],[16,12,16,14],[16,16,16,18],[16,19,16,22],[17,1,17,5],[17,7,17,8],[17,10,17,11],[17,12,17,14],[17,16,17,18],[17,19,17,22],[19,1,19,2],[19,18,19,20],[23,0,24,5],[23,6,23,8],[23,13,23,22],[24,14,24,16],[25,1,25,5],[25,14,25,22],[26,14,26,22],[27,1,27,4],[27,14,27,22],[28,1,28,4],[28,7,28,10],[28,14,28,16],[28,19,28,22],[30,1,30,5],[30,7,30,8],[30,10,30,11],[30,12,30,14],[30,16,30,18],[30,19,30,22],[31,1,31,5],[31,7,31,8],[31,10,31,11],[31,12,31,14],[31,16,31,18],[31,19,31,22],[32,1,32,5],[32,7,32,8],[32,10,32,11],[32,12,32,14],[32,16,32,18],[32,19,32,22],[33,1,33,5],[33,7,33,8],[33,10,33,11],[33,12,33,14],[33,16,33,18],[33,19,33,22],[34,1,34,5],[34,7,34,8],[34,10,34,11],[34,12,34,14],[34,16,34,18],[34,19,34,22],[35,1,35,5],[35,7,35,8],[35,10,35,11],[35,12,35,14],[35,16,35,18],[35,19,35,22],[36,1,36,5],[36,7,36,8],[36,10,36,11],[36,12,36,14],[36,16,36,18],[36,19,36,22],[37,1,37,5],[37,7,37,8],[37,10,37,11],[37,12,37,14],[37,16,37,18],[37,19,37,22],[38,1,38,5],[38,7,38,8],[38,10,38,11],[38,12,38,14],[38,16,38,18],[38,19,38,22],[39,1,39,5],[39,7,39,8],[39,10,39,11],[39,12,39,14],[39,16,39,18],[39,19,39,22],[41,18,41,20],[42,1,42,8]]}
["거래명세서"]
[{"$nulls":6},"(공급자용)",{"$nulls":6},"공급자"]
[{"$nulls":13},"상호",{"$nulls":3},"    ","대표자",{"$nulls":3},"(인)"]
[{"$nulls":13},"등록번호","000-00-00000"]
[{"$nulls":13},"주소"]
[null,"           년       월        일",{"$nulls":8}," "]
[null,"합계 (부가세 포함)",{"$nulls":5},{"$f":"Q18+T18","v":{"v":0,"d":"₩0"}},{"$nulls":5},"전화",{"$nulls":4},"팩스"]
[]
[null,"품명",{"$nulls":5},"규격",null,null,"수량 ",null,"단가 ",{"$nulls":3},"공급가액 ",null,null,"세액 "]
[{"$nulls":16},{"$f":"K10*M10","v":0},null,null,{"$f":"Q10*0.1","v":0}]
[{"$nulls":16},0,null,null,0]
[{"$nulls":16},0,null,null,0]
[{"$nulls":16},0,null,null,0]
[{"$nulls":16},0,null,null,0]
[{"$nulls":16},0,null,null,0]
[{"$nulls":16},0,null,null,0]
[{"$nulls":16},0,null,null,0]
[null,"합계",{"$nulls":14},{"$f":"SUM(Q10:Q17)","v":0},null,null,{"$f":"SUM(T10:T17)","v":0}]
[]
[{"$nulls":5}," "," ",{"$nulls":9},"인수자",{"$nulls":5},"(인)"]
[]
[]
[]
["거래명세서",{"$nulls":5},"(공급받는자용)",{"$nulls":6},"공급자"]
[{"$nulls":13},"상호",{"$nulls":3},"    ","대표자"]
[null," 귀하",{"$nulls":11},"등록번호"]
[{"$nulls":13},"주소"]
[null,"           년       월        일",{"$nulls":8}," "]
[null,"합계 (부가세 포함)",{"$nulls":5},{"$f":"Q40+T40","v":{"v":0,"d":"₩0"}},{"$nulls":5},"전화",{"$nulls":4},"팩스"]
[]
[null,"품명",{"$nulls":5},"규격",null,null,"수량 ",null,"단가 ",{"$nulls":3},"공급가액 ",null,null,"세액 "]
[{"$nulls":16},{"$f":"K32*M32","v":0},null,null,{"$f":"Q32*0.1","v":0}]
[{"$nulls":16},0,null,null,0]
[{"$nulls":16},0,null,null,0]
[{"$nulls":16},0,null,null,0]
[{"$nulls":16},0,null,null,0]
[{"$nulls":16},0,null,null,0]
[{"$nulls":16},0,null,null,0]
[{"$nulls":16},0,null,null,0]
[null,"합계",{"$nulls":14},{"$f":"SUM(Q32:Q39)","v":0},null,null,{"$f":"SUM(T32:T39)","v":0}]
[]
[{"$nulls":16},"인수자",{"$nulls":5},"(인)",null,null," "]

{"sheet":"거래명세서_3","index":2,"n_rows":37,"n_cols":42,"rows_kept":37,"merged":[[1,12,3,30],[2,1,2,2],[2,3,2,10],[5,1,5,3],[5,5,5,6],[5,8,5,9],[5,17,9,18],[5,19,5,23],[5,24,5,41],[6,19,6,23],[6,24,6,30],[6,31,6,32],[6,33,6,39],[7,1,7,12],[7,19,7,23],[7,24,7,41],[8,19,8,23],[8,24,8,30],[8,31,8,32],[8,33,8,41],[9,19,9,23],[9,24,9,41],[10,9,10,10],[10,11,10,28],[10,29,10,30],[10,31,10,32],[10,33,10,40],[11,0,12,9],[11,10,12,13],[11,14,12,16],[11,17,12,22],[11,23,12,32],[11,33,12,41],[13,0,13,9],[13,10,13,13],[13,14,13,16],[13,17,13,22],[13,23,13,32],[13,33,13,41],[14,0,14,9],[14,10,14,13],[14,14,14,16],[14,17,14,22],[14,23,14,32],[14,33,14,41],[15,0,15,9],[15,10,15,13],[15,14,15,16],[15,17,15,22],[15,23,15,32],[15,33,15,41],[16,0,16,9],[16,10,16,13],[16,14,16,16],[16,17,16,22],[16,23,16,32],[16,33,16,41],[17,0,17,9],[17,10,17,13],[17,14,17,16],[17,17,17,22],[17,23,17,32],[17,33,17,41],[18,0,18,9],[18,10,18,13],[18,14,18,16],[18,17,18,22],[18,23,18,32],[18,33,18,41],[19,0,19,9],[19,10,19,13],[19,14,19,16],[19,17,19,22],[19,23,19,32],[19,33,19,41],[20,0,20,9],[20,10,20,13],[20,14,20,16],[20,17,20,22],[20,23,20,32],[20,33,20,41],[21,0,21,9],[21,10,21,13],[21,14,21,16],[21,17,21,22],[21,23,21,32],[21,33,21,41],[22,0,22,9],[22,10,22,13],[22,14,22,16],[22,17,22,22],[22,23,22,32],[22,33,22,41],[23,0,23,9],[23,10,23,13],[23,14,23,16],[23,17,23,22],[23,23,23,32],[23,33,23,41],[24,0,24,9],[24,10,24,13],[24,14,24,16],[24,17,24,22],[24,23,24,32],[24,33,24,41],[25,0,25,9],[25,10,25,13],[25,14,25,16],[25,17,25,22],[25,23,25,32],[25,33,25,41],[26,0,26,9],[26,10,26,13],[26,14,26,16],[26,17,26,22],[26,23,26,32],[26,33,26,41],[27,0,27,9],[27,10,27,13],[27,14,27,16],[27,17,27,22],[27,23,27,32],[27,33,27,41],[28,0,28,9],[28,10,28,13],[28,14,28,16],[28,17,28,22],[28,23,28,32],[28,33,28,41],[29,0,29,9],[29,10,29,13],[29,14,29,16],[29,17,29,22],[29,23,29,32],[29,33,29,41],[30,0,30,9],[30,10,30,13],[30,14,30,16],[30,17,30,22],[30,23,30,32],[30,33,30,41],[31,0,31,9],[31,10,31,13],[31,14,31,16],[31,17,31,22],[31,23,31,32],[31,33,31,41],[32,0,32,9],[32,10,32,13],[32,14,32,16],[32,17,32,22],[32,23,32,32],[32,33,32,41],[33,0,33,9],[33,10,33,13],[33,14,33,16],[33,17,33,22],[33,23,33,32],[33,33,33,41],[34,0,34,9],[34,10,34,13],[34,14,34,16],[34,17,34,22],[34,23,34,32],[34,33,34,41]]}
[]
[{"$nulls":12},"거 래 명 세 서"]
[null,"NO."]
[]
[]
[{"$nulls":4},"년",null,null,"월",null,null,"일",{"$nulls":6},"공\n\n급\n\n자",null,"등 록 번 호"]
[{"$nulls":19},"상호(법인명)",{"$nulls":11},"성명",{"$nulls":8},"(인)"]
[{"$nulls":13},"귀하",{"$nulls":5},"사업장주소"]
[{"$nulls":19},"업 태",{"$nulls":11},"종목"]
[null,"아래와 같이 계산합니다.",{"$nulls":17},"전화번호"]
[null,"(공급가액+세액)",{"$nulls":7},"금",null,{"$f":"AH11","v":0},{"$nulls":17},"원",null,"( \\",null,{"$f":"X35+AH35","v":0},{"$nulls":7},")"]
["품  목  명",{"$nulls":9},"규 격",{"$nulls":3},"수 량",null,null,"단 가",{"$nulls":5},"공 급 가 액",{"$nulls":9},"세 액"]
[]
[{"$nulls":23},{"$f":"O14*R14","v":0},{"$nulls":9},{"$f":"X14*0.1","v":0}]
[{"$nulls":23},0,{"$nulls":9},0]
[{"$nulls":23},0,{"$nulls":9},0]
[{"$nulls":23},0,{"$nulls":9},0]
[{"$nulls":23},0,{"$nulls":9},0]
[{"$nulls":23},0,{"$nulls":9},0]
[{"$nulls":23},0,{"$nulls":9},0]
[{"$nulls":23},0,{"$nulls":9},0]
[{"$nulls":23},0,{"$nulls":9},0]
[{"$nulls":23},0,{"$nulls":9},0]
[{"$nulls":23},0,{"$nulls":9},0]
[{"$nulls":23},0,{"$nulls":9},0]
[{"$nulls":23},0,{"$nulls":9},0]
[{"$nulls":23},0,{"$nulls":9},0]
[{"$nulls":23},0,{"$nulls":9},0]
[{"$nulls":23},0,{"$nulls":9},0]
[{"$nulls":23},0,{"$nulls":9},0]
[{"$nulls":23},0,{"$nulls":9},0]
[{"$nulls":23},0,{"$nulls":9},0]
[{"$nulls":23},0,{"$nulls":9},0]
[{"$nulls":23},0,{"$nulls":9},0]
["계",{"$nulls":22},{"$f":"SUM(X14:AG34)","v":0},{"$nulls":9},{"$f":"SUM(AH14:AP34)","v":0}]
["※","본 거래명세표는 사업자가 월합계표에 의한 세금계산서를 발행할 경우 거래시마다 사용하는 계산서 이며"]
[null,"월합계로 세금계산서를 작성할 때에 반드시 포함시켜야 한다."]