{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["판매 데이터","판매 보고서","재고"],"not_rendered":{"defined_names":10,"pivot_tables":1},"read":"whole","date_system":"1900"}

{"sheet":"판매 데이터","index":0,"n_rows":13,"n_cols":11,"rows_kept":13}
[]
[null,"금전 등록기 일일 판매"]
[]
[]
[]
[{"$nulls":10}," "]
[{"$nulls":10}," "]
[null,"날짜","시간","거래 번호","SKU/제품 번호","설명","판매액","세율","판매세","합계"]
[null,"2012-02-01","10:30:00",1001,90001,{"$f":"IFERROR(IF(ISNA(VLOOKUP(표_판매_데이터[[#This Row],[SKU/제품 번호]],표_재고[],2,0)),\"\",VLOOKUP(표_판매_데이터[[#This Row],[SKU/제품 번호]],표_재고[],2,0)),\"No description found\")","v":"담요"},{"v":74950,"d":"₩74,950"},{"v":0.05,"d":"5.00%"},{"$f":"표_판매_데이터[[#This Row],[판매액]]*표_판매_데이터[[#This Row],[세율]]","v":{"v":3747.5,"d":"₩3,748"}},{"$f":"표_판매_데이터[[#This Row],[판매액]]+표_판매_데이터[[#This Row],[판매세]]","v":{"v":78697.5,"d":"₩78,698"}}]
[null,"2012-02-01","10:33:00",1002,90023,{"$f":"IFERROR(IF(ISNA(VLOOKUP(표_판매_데이터[[#This Row],[SKU/제품 번호]],표_재고[],2,0)),\"\",VLOOKUP(표_판매_데이터[[#This Row],[SKU/제품 번호]],표_재고[],2,0)),\"No description found\")","v":"식탁보(6' 원형)"},{"v":34990,"d":"₩34,990"},{"v":0.05,"d":"5.00%"},{"$f":"표_판매_데이터[[#This Row],[판매액]]*표_판매_데이터[[#This Row],[세율]]","v":{"v":1749.5,"d":"₩1,750"}},{"$f":"표_판매_데이터[[#This Row],[판매액]]+표_판매_데이터[[#This Row],[판매세]]","v":{"v":36739.5,"d":"₩36,740"}}]
[null,"2012-02-01","10:45:00",1003,90005,{"$f":"IFERROR(IF(ISNA(VLOOKUP(표_판매_데이터[[#This Row],[SKU/제품 번호]],표_재고[],2,0)),\"\",VLOOKUP(표_판매_데이터[[#This Row],[SKU/제품 번호]],표_재고[],2,0)),\"No description found\")","v":"원형 접시"},{"v":55950,"d":"₩55,950"},{"v":0.05,"d":"5.00%"},{"$f":"표_판매_데이터[[#This Row],[판매액]]*표_판매_데이터[[#This Row],[세율]]","v":{"v":2797.5,"d":"₩2,798"}},{"$f":"표_판매_데이터[[#This Row],[판매액]]+표_판매_데이터[[#This Row],[판매세]]","v":{"v":58747.5,"d":"₩58,748"}}]
[null,"2012-02-01","10:55:00",1004,90004,{"$f":"IFERROR(IF(ISNA(VLOOKUP(표_판매_데이터[[#This Row],[SKU/제품 번호]],표_재고[],2,0)),\"\",VLOOKUP(표_판매_데이터[[#This Row],[SKU/제품 번호]],표_재고[],2,0)),\"No description found\")","v":"사각형 접시"},{"v":2950,"d":"₩2,950"},{"v":0.05,"d":"5.00%"},{"$f":"표_판매_데이터[[#This Row],[판매액]]*표_판매_데이터[[#This Row],[세율]]","v":{"v":147.5,"d":"₩148"}},{"$f":"표_판매_데이터[[#This Row],[판매액]]+표_판매_데이터[[#This Row],[판매세]]","v":{"v":3097.5,"d":"₩3,098"}}]
[null,"2012-02-01","11:45:00",1005,90002,{"$f":"IFERROR(IF(ISNA(VLOOKUP(표_판매_데이터[[#This Row],[SKU/제품 번호]],표_재고[],2,0)),\"\",VLOOKUP(표_판매_데이터[[#This Row],[SKU/제품 번호]],표_재고[],2,0)),\"No description found\")","v":"베개"},{"v":14980,"d":"₩14,980"},{"v":0.05,"d":"5.00%"},{"$f":"표_판매_데이터[[#This Row],[판매액]]*표_판매_데이터[[#This Row],[세율]]","v":{"v":749,"d":"₩749"}},{"$f":"표_판매_데이터[[#This Row],[판매액]]+표_판매_데이터[[#This Row],[판매세]]","v":{"v":15729,"d":"₩15,729"}}]

{"sheet":"판매 보고서","index":1,"n_rows":14,"n_cols":7,"rows_kept":14}
[]
[null,"금전 등록기 일일 판매"]
[]
[]
[]
[]
[]
[null,"SKU/제품 번호","날짜","설명","판매액 ","판매세 ","합계 "]
[null,90001,"2012-02-01","담요",78697.5,3747.5,74950]
[null,90002,"2012-02-01","베개",15729,749,14980]
[null,90004,"2012-02-01","사각형 접시",3097.5,147.5,2950]
[null,90005,"2012-02-01","원형 접시",58747.5,2797.5,55950]
[null,90023,"2012-02-01","식탁보(6' 원형)",36739.5,1749.5,34990]
[null,"총합계",null,null,193011,9191,183820]

{"sheet":"재고","index":2,"n_rows":31,"n_cols":3,"rows_kept":31}
[]
[null,"금전 등록기 일일 판매"]
[]
[]
[]
[]
[]
[null,"SKU/제품 번호","설명"]
[null,90001,"담요"]
[null,90002,"베개"]
[null,90003,"시트"]
[null,90004,"사각형 접시"]
[null,90005,"원형 접시"]
[null,90006,"그릇(대)"]
[null,90007,"그릇(소)"]
[null,90008,"원형 접시(소)"]
[null,90009,"포크(소)"]
[null,90010,"포크(대)"]
[null,90011,"숟가락(소)"]
[null,90012,"숟가락(대)"]
[null,90013,"버터 나이프(소)"]
[null,90014,"버터 나이프(대)"]
[null,90015,"식탁보(10x5)"]
[null,90016,"식탁보(8x5)"]
[null,90017,"식탁보(8x8)"]
[null,90018,"식탁보(6x6)"]
[null,90019,"식탁보(6x4)"]
[null,90020,"식탁보(4x4)"]
[null,90021,"식탁보(10' 원형)"]
[null,90022,"식탁보(8' 원형)"]
[null,90023,"식탁보(6' 원형)"]