{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["GMS120"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"GMS120","index":0,"n_rows":10,"n_cols":16,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,2,2,9],[6,9,7,9],[7,0,7,1]]}
[]
[null,null,"판매가 산출식",null,null,null,null,null,null,null,"기준환율",null,null,"USD",1060,{"$f":"IF($K$3=N2,$D$10,$D$10*($L$3/(O2-30)))","v":114.99}]
[null,null,null,null,null,null,null,null,null,null,"USD",{"$f":"INDEX(N2:O5,MATCH(K3,N2:N5,0),2)-30","v":1030},null,"AUD",957.71,{"$f":"IF($K$3=N3,$D$10,$D$10*($L$3/(O3-30)))","v":127.66888359508897}]
["매입가","중  량","수   량","수수료(%)","목표가","배송지역","우체국보험","할인등록(%)","EMS할인율","Free Shipping","거래방식","추가할인(%)",null,"CAD",966.89,126.41793593698299]
[86560,0.5,1,0.09,114.99,"4지역","미가입",0,0.2,"무   료","eBay",0,null,"GBP",1770.73,68.040247482378078]
[]
[null,null,null,null,null,null,null,null,null,"과표중량","일반","EMS",null,"Shipping",{"$f":"I10/INDEX(N2:O5,MATCH(K3,N2:N5,0),2)","v":8.8301886792452837}]
[{"$f":"K5&\" 거래\"","v":"eBay 거래"},null,null,null,null,null,null,null,null,null,{"$f":"IF(B5=0,\"0\",IF((B5*IF(C5=0,1,C5))>2,\"중량초과\",IF((B5*IF(C5=0,1,C5))<=0.1,0.1,IF((B5*IF(C5=0,1,C5))<=0.25,0.25,IF((B5*IF(C5=0,1,C5))<=0.5,0.5,ROUNDUP((B5*IF(C5=0,1,C5))/0.5,0)/2)))))","v":0.5},{"$f":"IF(B5=0,0,IF((B5*IF(C5=0,1,C5))>30,\"중량초과\",IF((B5*IF(C5=0,1,C5))<=0.5,0.5,IF((B5*IF(C5=0,1,C5))<=0.75,0.75,IF((B5*IF(C5=0,1,C5))<=1,1,IF((B5*IF(C5=0,1,C5))<=1.25,1.25,IF((B5*IF(C5=0,1,C5))<=1.5,1.5,IF((B5*IF(C5=0,1,C5))<=1.75,1.75,ROUNDUP((B5*IF(C5=0,1,C5))/0.5,0)/2))))))))","v":0.5}]
["배송방법","등록가","배송료","할인가","실수익","수익률(%)","eBay수수료","Paypal 수수료","실배송료","보험료","배송비 할인","부가세환급"]
["RR",{"$f":"IF(A5=0,0,IF(I10=\"중량초과\",0,IF(J5=\"일   반\",IF(E5=0,((A5*C5/L3+C10)*(1/1.1+D5+4%)-C10)/(1-H5)+3,(E5*C5-C10)/(1-H5)),IF(E5=0,((A5*C5/L3+C10)*(1/1.1+D5+4%)-C10)/(1-H5)+I10/ROUNDDOWN(L3,-2)+3,(E5*C5-C10)/(1-H5)))))","v":114.99},{"$f":"IF(J5=\"일   반\",I10/ROUNDDOWN(L3,-2),0)","v":0},{"$f":"IF(B10=0,0,B10*(1-H5-L5))","v":114.99},{"$f":"IF(B10=0,0,((D10+C10)*L3+K10+L10)-(A5*C5+I10+J10+(G10+H10)*L3))","v":14801.069609090904},{"$f":"IF(B10=0,0,(E10/L3)/(D10+C10))","v":0.12496713187462399},{"$f":"IF(K5=\"PP Invoice\",0,IF(D10=0,0,(D10+C10)*D5))","v":10.3491},{"$f":"IF(D10=0,0,IF(A5=0,0,(D10+C10)*3.9%+0.3))","v":4.7846099999999998},{"$f":"IFERROR(IF(A5=0,0,IF(B5=0,0,IF(A10=\"무등기\",IF(K8>2,\"중량초과\",IF(F5=\"1지역\",INDEX([1]data!D:H,MATCH(K8,[1]data!D:D,0),2)*100%,\nIF(F5=\"2지역\",INDEX([1]data!D:H,MATCH(K8,[1]data!D:D,0),3)*100%,\nIF(F5=\"3지역\",INDEX([1]data!D:H,MATCH(K8,[1]data!D:D,0),4)*100%,\nIF(F5=\"4지역\",INDEX([1]data!D:H,MATCH(K8,[1]data!D:D,0),5)*100%,\"지역오류\"))))),\nIF(A10=\"RR\",IF(K8>2,\"중량초과\",IF(F5=\"1지역\",INDEX([1]data!J:N,MATCH(K8,[1]data!J:J,0),2)*100%,\nIF(F5=\"2지역\",INDEX([1]data!J:N,MATCH(K8,[1]data!J:J,0),3)*100%,\nIF(F5=\"3지역\",INDEX([1]data!J:N,MATCH(K8,[1]data!J:J,0),4)*100%,\nIF(F5=\"4지역\",INDEX([1]data!J:N,MATCH(K8,[1]data!J:J,0),5)*100%,\"지역오류\"))))),\nIF(A10=\"국제소포\",IF(L8>20,\"중량초과\",IF(F5=\"1지역\",INDEX([1]data!AB:AL,MATCH(K8,[1]data!AB:AB,0),2)*100%,\nIF(F5=\"2지역\",INDEX([1]data!AB:AL,MATCH(L8,[1]data!AB:AB,0),3)*100%,\nIF(F5=\"3지역\",INDEX([1]data!AB:AL,MATCH(L8,[1]data!AB:AB,0),4)*100%,\nIF(F5=\"4지역\",INDEX([1]data!AB:AL,MATCH(L8,[1]data!AB:AB,0),5)*100%,\nIF(F5=\"특1지역\",INDEX([1]data!AB:AL,MATCH(L8,[1]data!AB:AB,0),6)*100%,\nIF(F5=\"특2지역\",INDEX([1]data!AB:AL,MATCH(L8,[1]data!AB:AB,0),7)*100%,\nIF(F5=\"특3지역\",INDEX([1]data!AB:AL,MATCH(L8,[1]data!AB:AB,0),8)*100%,\nIF(F5=\"특4지역\",INDEX([1]data!AB:AL,MATCH(L8,[1]data!AB:AB,0),9)*100%,\nIF(F5=\"특5지역\",INDEX([1]data!AB:AL,MATCH(L8,[1]data!AB:AB,0),10)*100%,\nIF(F5=\"특6지역\",INDEX([1]data!AB:AL,MATCH(L8,[1]data!AB:AB,0),11)*100%,\"지역오류\"))))))))))),\nIF(L8>30,\"중량초과\",IF(F5=\"1지역\",INDEX([1]data!P:Z,MATCH(L8,[1]data!P:P,0),2)*100%,\nIF(F5=\"2지역\", INDEX([1]data!P:Z,MATCH(L8,[1]data!P:P,0),3)*100%,\nIF(F5=\"3지역\", INDEX([1]data!P:Z,MATCH(L8,[1]data!P:P,0),4)*100%,\nIF(F5=\"4지역\", INDEX([1]data!P:Z,MATCH(L8,[1]data!P:P,0),5)*100%,\nIF(F5=\"특1지역\",INDEX([1]data!P:Z,MATCH(L8,[1]data!P:P,0),6)*100%,\nIF(F5=\"특2지역\",INDEX([1]data!P:Z,MATCH(L8,[1]data!P:P,0),7)*100%,\nIF(F5=\"특3지역\",INDEX([1]data!P:Z,MATCH(L8,[1]data!P:P,0),8)*100%,\nIF(F5=\"특4지역\",INDEX([1]data!P:Z,MATCH(L8,[1]data!P:P,0),9)*100%,\nIF(F5=\"특5지역\",IINDEX([1]data!P:Z,MATCH(L8,[1]data!P:P,0),10)*100%,INDEX([1]data!P:Z,MATCH(L8,[1]data!P:P,0),11)*100%))))))))))))))),\"오류\")","v":9360},{"$f":"IF(B10=0,0,IF(G5=\"가   입\",IF(J5=\"일   반\",ROUNDUP(((B10*C5*L3/114300)*550+1950),-1),ROUNDUP((((B10-(I10/ROUNDDOWN(L3,-2)))*C5*L3/114300)*550+1950),-1)),0))","v":0},{"$f":"IF(B10=0,0,IF(A10=\"EMS\",I10*I5,0))","v":0},{"$f":"IF(B10=0,0,A5*C5-(A5*C5/1.1))","v":7869.0909090909117}]