{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["상업 송장","고객"],"not_rendered":{"defined_names":18},"read":"whole","date_system":"1900"}

{"sheet":"상업 송장","index":0,"n_rows":19,"n_cols":10,"rows_kept":19,"merged":[[0,1,1,3],[0,6,0,7],[1,6,1,7]]}
[null,"TAILSPIN TOYS",null,null,"123 Main Street","전화 번호: 123-555-0123","tailspin@interestingsite.com",null,null,"고객"]
[{"$nulls":4},"Ocean View,  MO 12345","팩스: 123-555-0124","www.tailspintoys.com"]
[]
[null,"청구지:","Lilli Allik","전화 번호:",{"$f":"IFERROR(VLOOKUP(청구이름,고객목록[],8,FALSE),\"\")","v":"432-555-0178"},null,"송장 번호:",34567]
[null,"주소:",{"$f":"IFERROR(VLOOKUP(청구이름,고객목록[],3,FALSE),\"\")","v":"345 Cherry Street"},"팩스:",{"$f":"IFERROR(VLOOKUP(청구이름,고객목록[],10,FALSE),\"\")","v":"432-555-0187"},null,"송장 날짜:",{"$f":"TODAY()","v":"2022-12-13"}]
[null,null,{"$f":"IF(VLOOKUP(청구이름,고객목록[],4,FALSE)<>\"\",VLOOKUP(청구이름,고객목록[],4,FALSE),IF(VLOOKUP(청구이름,고객목록[],5,FALSE)<>\"\",CONCATENATE(VLOOKUP(청구이름,고객목록[],5,FALSE),\", \",VLOOKUP(청구이름,고객목록[],6,FALSE),\" \",VLOOKUP(청구이름,고객목록[],7,FALSE)),CONCATENATE(VLOOKUP(청구이름,고객목록[],6,FALSE),\" \",VLOOKUP(청구이름,고객목록[],7,FALSE))))","v":"Suite 123"},"전자 메일:",{"$f":"IFERROR(VLOOKUP(청구이름,고객목록[],9,FALSE),\"\")","v":"mike@excellentwebsite.com"},null,"연락처:",{"$f":"IFERROR(VLOOKUP(청구이름,고객목록[],2,FALSE),\"\")","v":"유정호"}]
[null,null,{"$f":"IF(VLOOKUP(청구이름,고객목록[],4,FALSE)=\"\",\"\",IF(VLOOKUP(청구이름,고객목록[],5,FALSE)<>\"\",CONCATENATE(VLOOKUP(청구이름,고객목록[],5,FALSE),\", \",VLOOKUP(청구이름,고객목록[],6,FALSE),\" \",VLOOKUP(청구이름,고객목록[],7,FALSE)),CONCATENATE(VLOOKUP(청구이름,고객목록[],6,FALSE),\" \",VLOOKUP(청구이름,고객목록[],7,FALSE))))","v":"Albany, SD 12345"}]
[null,"날짜","항목 번호","설명","수량","단가","할인","합계"]
[null,{"$f":"TODAY()","v":"2022-12-13"},789807,"목재",4,{"v":10,"d":"₩10.00"},{"v":2,"d":"₩2.00"},{"$f":"IF(AND(송장항목[[#This Row],[수량]]<>\"\",송장항목[[#This Row],[단가]]<>\"\"),(송장항목[[#This Row],[수량]]*송장항목[[#This Row],[단가]])-송장항목[[#This Row],[할인]],\"\")","v":{"v":38,"d":"₩38.00"}}]
[{"$nulls":7},{"$f":"IF(AND(송장항목[[#This Row],[수량]]<>\"\",송장항목[[#This Row],[단가]]<>\"\"),(송장항목[[#This Row],[수량]]*송장항목[[#This Row],[단가]])-송장항목[[#This Row],[할인]],\"\")","v":""}]
[{"$nulls":7},{"$f":"IF(AND(송장항목[[#This Row],[수량]]<>\"\",송장항목[[#This Row],[단가]]<>\"\"),(송장항목[[#This Row],[수량]]*송장항목[[#This Row],[단가]])-송장항목[[#This Row],[할인]],\"\")","v":""}]
[{"$nulls":7},{"$f":"IF(AND(송장항목[[#This Row],[수량]]<>\"\",송장항목[[#This Row],[단가]]<>\"\"),(송장항목[[#This Row],[수량]]*송장항목[[#This Row],[단가]])-송장항목[[#This Row],[할인]],\"\")","v":""}]
[{"$nulls":7},{"$f":"IF(AND(송장항목[[#This Row],[수량]]<>\"\",송장항목[[#This Row],[단가]]<>\"\"),(송장항목[[#This Row],[수량]]*송장항목[[#This Row],[단가]])-송장항목[[#This Row],[할인]],\"\")","v":""}]
[{"$nulls":6},"송장 소계",{"$f":"SUM(송장항목[합계])","v":{"v":38,"d":"₩38.00"}}]
[{"$nulls":6},"세율",{"v":0.089,"d":"9%"}]
[{"$nulls":6},"판매세",{"$f":"송장소계*판매세율","v":{"v":3.3819999999999997,"d":"₩3.38"}}]
[{"$nulls":6},"배송료",{"v":5,"d":"₩5.00"}]
[null,{"$f":"\"수표 지급인 \"&UPPER(회사이름)&\".\"","v":"수표 지급인 TAILSPIN TOYS."},{"$nulls":4},"받은 금액",{"v":0,"d":"₩0.00"}]
[null,"지불 기한이 10일 남은 총합계입니다. 연체된 계정에는 월 2%의 이율이 적용됩니다.",{"$nulls":4},"합계",{"$f":"송장소계+판매세+배송료-예수금","v":{"v":46.382,"d":"₩46.38"}}]

{"sheet":"고객","index":1,"n_rows":4,"n_cols":13,"rows_kept":4}
[null,"고객",{"$nulls":10},"상업 송장"]
[null,"회사 이름","연락처 정보","주소","주소2","도시","시/도","우편 번호","전화 번호","전자 메일","팩스"]
[null,"Lilli Allik","유정호","345 Cherry Street","Suite 123","Albany","SD",12345,"432-555-0178","mike@excellentwebsite.com","432-555-0187"]
[null,"Contoso, Ltd","조지민","567 Walnut Lane",null,"Moline","MO","09876","432-555-0189","contoso@websitegoeshere.com","432-555-0123"]