{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["注文書","計算書","送料","北海道沖縄","コレクトと時間帯"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":3,"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":"注文書","index":0,"n_rows":61,"n_cols":12,"rows_kept":61,"cut":false,"hidden":false,"merged":[[26,7,26,9],[27,7,27,8],[27,9,27,10],[0,1,0,11],[2,1,3,1],[2,7,3,7],[18,1,18,3],[19,1,19,3],[25,7,25,9]]}
[null,"　　　　　　　　　　　　　　　　　　　　　　　　ご    注    文    書　　　　　　　　　　　　　　　年　　　月　　　日"]
[null,"お　名　前　　　　　　　　　　　　　　　（WM・Ｍ・ＡＧ・ＧＡＧ）",null,null,null,null,null,"　　ポジション選択⇒","WM","グループ名　　　　　　　　　  "]
[null,"品　　名\n（軽減税率）","本体価格\n（税抜）","ポジション\n価格（税抜）","数量","合　　計\n（税抜）",null,"品　　名\n（標準税率）","本体価格\n（税抜）","ポジション\n価格（税抜）","数量","合　　計\n（税抜）"]
[null,null,null,"①","②","①×②",null,null,null,"⑤","⑥","⑤×⑥"]
[null,"エイジレスパワー",17000,{"$f":"ROUND(C5*$F$28,0)","v":13600},null,{"$f":"IF(D5*E5<>0,D5*E5,\"\")","v":""},null,"ｼﾙｷｰﾀﾞｲﾔﾓﾝﾄﾞ　ｳｫｯｼﾝｸﾞ",12000,{"$f":"ROUND(I5*$F$28,0)","v":9600},null,{"$f":"IF(J5*K5<>0,J5*K5,\"\")","v":""}]
[null,"ＳＯＤサプライズ　",21000,{"$f":"ROUND(C6*$F$28,0)","v":16800},null,{"$f":"IF(D6*E6<>0,D6*E6,\"\")","v":""},null,"ｼﾙｷｰﾀﾞｲﾔﾓﾝﾄﾞ　ｴｯｾﾝｽ",14000,{"$f":"ROUND(I6*$F$28,0)","v":11200},null,{"$f":"IF(J6*K6<>0,J6*K6,\"\")","v":""}]
[null,"納豆芽胞",12000,9600,null,"",null,"ｼﾙｷｰﾀﾞｲﾔﾓﾝﾄﾞ　ｸﾘｰﾑ",10000,8000,null,""]
[null,"エンジェルウィング・エフェクト",18000,14400,null,"",null,"ｼﾙｷｰﾀﾞｲﾔﾓﾝﾄﾞ　ｼﾞｪﾙ",12000,{"$f":"ROUND(I8*$F$28,0)","v":9600},null,""]
[null,"ＳＨＩＫＩＳＯ・色素",18000,14400,null,{"$f":"IF(D9*E9<>0,D9*E9,\"\")","v":""},null,"ミネラックス　パック",10000,8000,null,{"$f":"IF(J9*K9<>0,J9*K9,\"\")","v":""}]
[null,"南極のオメガ",17000,13600,null,{"$f":"IF(D10*E10<>0,D10*E10,\"\")","v":""},null,"ＧシャンプーＮＦ",5800,4640,null,{"$f":"IF(J10*K10<>0,J10*K10,\"\")","v":""}]
[null,"ＫＯＵＳＯ　ＡＬＩＶＥ",16000,12800,null,{"$f":"IF(D11*E11<>0,D11*E11,\"\")","v":""},null,"ＧコンディショナーＮＦ",5800,4640,null,{"$f":"IF(J11*K11<>0,J11*K11,\"\")","v":""}]
[null,"コツガスピード　　　　",9000,7200,null,{"$f":"IF(D12*E12<>0,D12*E12,\"\")","v":""},null,"ムースウォッシングＮＦ",8000,6400,null,""]
[null,"ＢＩＯＸＧ－３１０　",23000,18400,null,"",null,"セレブＵＶクリーム",5600,4480,null,""]
[null,"遠赤焙煎ルイボスティー",8700,6960,null,"",null,"イオンウォーター",7500,6000,null,""]
[null,"ナノルチン",12000,9600,null,"",null,"ＢＡＣフレッシュナー",10000,8000,null,""]
[null,"ｴｲｼﾞﾚｽﾊﾟﾜｰお試しﾊﾟｯｸ",1750,1750,null,"",null,"ＡＲエッセンス",10000,8000,null,""]
[null,null,null,null,null,"",null,"ミネラルソープ",4000,3200,null,""]
[null,null,null,0,null,"",null,"ﾋﾟｭｱＦﾌｧﾝﾃﾞｰｼｮﾝ①ｲｴﾛｰ",5100,4080,null,""]
[null,"　　　　　８％課税対象合計（税抜）　　　　　",null,null,"③",{"$f":"SUM(F5:F18)","v":0},null,"ﾋﾟｭｱＦﾌｧﾝﾃﾞｰｼｮﾝ②ﾍﾞｰｼﾞｭ",4500,3600,null,""]
[null,"８％消費税　（③×８％）",null,null,"④",{"$f":"ROUND(SUM(F5:F18)*0.08,0)","v":0},null,"ﾋﾟｭｱＦﾌｧﾝﾃﾞｰｼｮﾝ③ﾅﾁｭﾗﾙ",4500,3600,null,""]
[null,"　ﾐﾈﾗｯｸｽ ﾊﾟｰﾌｪｸﾄｸﾘｰﾅｰ",5300,{"$f":"ROUND(C21*$F$28,0)","v":4240},null,{"$f":"IF(D21*E21<>0,D21*E21,\"\")","v":""},null,"ﾋﾟｭｱＦﾌｧﾝﾃﾞｰｼｮﾝ④ｵｰｸﾙ",4500,3600,null,""]
[null,"　もりの泉",3900,3120,null,{"$f":"IF(D22*E22<>0,D22*E22,\"\")","v":""},null,"ボディークリーム",16000,12800,null,""]
[null,"　ハ元気",3000,2400,null,"",null,"マッサージローション",17000,13600,null,""]
[null,"交換ｶｰﾄﾘｯｼﾞIEC-12000",10000,{"$f":"C24","v":10000},null,"",null,"レフィル①②③",3800,3040,null,""]
[null,"備品",null,{"$f":"C25","v":0},null,"",null,"10%課税対象小計２",null,null,"⑧",{"$f":"SUM(L5:L24)","v":0}]
[null,null,null,0,null,"",null,"　　　　　１０％課税対象合計（税抜）　　　　　",null,null,"⑦+⑧",{"$f":"F27+L25","v":0}]
[null,"10%課税対象小計１",null,null,"⑦",{"$f":"SUM(F21:F26)","v":0},null,"　１０％消費税　（⑦+⑧）×１０％",null,null,"⑨",{"$f":"ROUND(L26*0.1,0)","v":0}]
[null,"備考",null,null,null,{"$f":"IF($I$2=\"GAG\",0.47,IF($I$2=\"AG\",0.57,IF($I$2=\"M\",0.7,IF($I$2=\"WM\",0.8,IF($I$2=\"定価\",1,0)))))","v":0.8},null,"総合計　③＋④＋⑦＋⑧+⑨",null,{"$f":"F19+F20+L26+L27","v":0},null,"WX-0396"]
[null,"                                                                                                            株式会社マスタワールド",null,null,null,null,null,null,null,null,null,"2024.04.01"]
[]
[]
[null,0,"GAG"]
[null,1,"AG"]
[null,2,"M"]
[null,3,"WM"]
[null,4,"定価"]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,21]
[null,22]
[null,23]
[null,24]
[null,25]
[null,26]
[null,27]
[null,28]
[null,29]

{"sheet":"計算書","index":1,"n_rows":79,"n_cols":12,"rows_kept":79,"cut":false,"hidden":false,"merged":[[0,1,0,8],[2,1,3,1]]}
[null,"計算書"]
[null,"ポジション選択　⇒　",null,"WM",null,null,"version12","2024.04.01"]
[null,"品　　名\n（軽減税率）","消費税率","本体価格\n（税抜）","数量","BV","ポジション\n価格（税抜）","合　　計\n（税抜）"]
[null,null,null,null,"①",null,"②","①×②"]
[null,"エイジレスパワー",0.08,17000,null,{"$f":"D5*E5","v":0},{"$f":"ROUND(D5*$K$9,0)","v":13600},{"$f":"E5*G5","v":0},null,null,"GAG"]
[null,"ＳＯＤサプライズ　",0.08,21000,null,{"$f":"D6*E6","v":0},16800,0,null,null,"AG"]
[null,"納豆芽胞",0.08,12000,null,0,9600,0,null,null,"M"]
[null,"エンジェルウィング・エフェクト",0.08,18000,null,0,14400,0,null,null,"WM"]
[null,"ＳＨＩＫＩＳＯ・色素",0.08,18000,null,0,14400,0,null,null,{"$f":"IF($D$2=\"GAG\",0.47,IF($D$2=\"AG\",0.57,IF($D$2=\"M\",0.7,IF($D$2=\"WM\",0.8,IF($D$2=\"定価\",1,0)))))","v":0.8}]
[null,"南極のオメガ",0.08,17000,null,0,13600,0]
[null,"ＫＯＵＳＯ　ＡＬＩＶＥ",0.08,16000,null,0,12800,0,null,null,"ＢＶ合計",{"$f":"SUM(F5:F64)","v":0}]
[null,"コツガスピード　　　　",0.08,9000,null,0,7200,0]
[null,"ナノルチン",0.08,12000,null,0,9600,0]
[null,"クリア（袋入り・180粒）",0.08,10000,null,0,8000,0,null,null,"   ８％課税対象合計（税抜）",{"$f":"SUM(H5:H19)","v":0}]
[null,"遠赤焙煎ルイボスティー",0.08,8700,null,0,6960,0,null,null,"１０％課税対象合計（税抜）",{"$f":"SUM(H20:H79)","v":0}]
[null,"ＢＩＯＸＧ－３１０　",0.08,23000,null,0,18400,0,null,null,"　合計金額　（税抜）",{"$f":"SUM(L14:L15)","v":0}]
[null,"クリア（袋入り・180粒）",0.08,10000,null,0,8000,0,null,null,"消費税　　８％",{"$f":"ROUND(L14*0.08,0)","v":0}]
[null,"(健康食品金額手入力）",0.08,null,null,0,0,0,null,null,"消費税　１０％",{"$f":"ROUND(L15*0.1,0)","v":0}]
[null,"備品ｴｲｼﾞﾚｽﾊﾟﾜｰお試しパック",0.08,1750,null,0,{"$f":"D19","v":1750},0,null,null,"総合計",{"$f":"SUM(L16:L18)","v":0}]
[null,"ｼﾙｷｰﾀﾞｲﾔﾓﾝﾄﾞ　ｳｫｯｼﾝｸﾞ",0.1,12000,null,0,9600,0]
[null,"ｼﾙｷｰﾀﾞｲﾔﾓﾝﾄﾞ　ｴｯｾﾝｽ",0.1,14000,null,0,11200,0]
[null,"ｼﾙｷｰﾀﾞｲﾔﾓﾝﾄﾞ　ｸﾘｰﾑ",0.1,10000,null,0,8000,0,null,null,"入力するのは　　　色のセルだけです。"]
[null,"ｼﾙｷｰﾀﾞｲﾔﾓﾝﾄﾞ　ｼﾞｪﾙ",0.1,12000,null,{"$f":"D23*E23","v":0},9600,0,null,null,"数量入力をクリアするには「数量クリア」ボタンを"]
[null,"ミネラックス　パック",0.1,10000,null,0,8000,0,null,null,"クリックしてください。"]
[null,"ＧシャンプーＮＦ",0.1,5800,null,0,4640,0]
[null,"ＧコンディショナーＮＦ",0.1,5800,null,0,4640,0]
[null,"ムースウォッシングＮＦ",0.1,8000,null,0,6400,0]
[null,"セレブＵＶクリーム",0.1,5600,null,0,4480,0]
[null,"イオンウォーター",0.1,7500,null,0,6000,0]
[null,"ＢＡＣフレッシュナー",0.1,10000,null,0,8000,0]
[null,"ＡＲエッセンス",0.1,10000,null,0,8000,0]
[null,"ミネラルソープ",0.1,4000,null,0,3200,0]
[null,"ﾋﾟｭｱＦﾌｧﾝﾃﾞｰｼｮﾝ①ｲｴﾛｰ",0.1,5100,null,0,4080,0]
[null,"ﾋﾟｭｱＦﾌｧﾝﾃﾞｰｼｮﾝ②ﾍﾞｰｼﾞｭ",0.1,4500,null,0,3600,0]
[null,"ﾋﾟｭｱＦﾌｧﾝﾃﾞｰｼｮﾝ③ﾅﾁｭﾗﾙ",0.1,4500,null,0,3600,0]
[null,"ﾋﾟｭｱＦﾌｧﾝﾃﾞｰｼｮﾝ④ｵｰｸﾙ",0.1,4500,null,0,3600,0]
[null,"ボディークリーム",0.1,16000,null,0,12800,0]
[null,"マッサージローション",0.1,17000,null,0,13600,0]
[null,"レフィル①ピンク",0.1,3800,null,0,3040,0]
[null,"レフィル②オークル",0.1,3800,null,0,3040,0]
[null,"レフィル③ナチュラル",0.1,3800,null,0,3040,0]
[null,"クイーンズケース",0.1,2700,null,0,2160,0]
[null,"(化粧品金額手入力）",0.1,31000,null,0,24800,0]
[null,"金箔シート１０枚セット",0.1,6000,null,0,{"$f":"D44","v":6000},0]
[]
[null,"　ﾐﾈﾗｯｸｽ ﾊﾟｰﾌｪｸﾄｸﾘｰﾅｰ",0.1,5300,null,0,{"$f":"ROUND(D46*$K$9,0)","v":4240},{"$f":"E46*G46","v":0}]
[null,"　調合容器 備品",0.1,120,null,0,{"$f":"D47","v":120},0]
[null,"　もりの泉",0.1,3900,null,0,{"$f":"ROUND(D48*$K$9,0)","v":3120},0]
[null,"　ハ元気",0.1,3000,null,0,{"$f":"ROUND(D49*$K$9,0)","v":2400},0]
[null,"エクセル　FX",0.1,363000,null,{"$f":"D50*E50","v":0},{"$f":"ROUND(D50*$K$9,0)","v":290400},0]
[null,"エクセル　FXファイル",0.1,500,null,0,{"$f":"D51","v":500},0]
[null,"エクセル使用方法ﾗﾐﾈｰﾄ",0.1,100,null,0,{"$f":"D52","v":100},0]
[null,"ＷＤ",0.1,180000,null,0,{"$f":"ROUND(D53*$K$9,0)","v":144000},0]
[]
[null,"下着・インナー（モカ・黒）",0.1,34000,null,0,{"$f":"ROUND(D55*$K$9,0)","v":27200},{"$f":"E55*G55","v":0}]
[null,"下着・ガードル（モカ・黒）",0.1,34000,null,0,{"$f":"ROUND(D56*$K$9,0)","v":27200},0]
[null,"特注・３Ｌと４Ｌ",0.1,3000,null,0,{"$f":"D57","v":3000},0]
[null,"特注・５Ｌと６Ｌ",0.1,6000,null,0,{"$f":"D58","v":6000},0]
[null,"ブラジャー・メッシュ",0.1,32000,null,0,{"$f":"ROUND(D59*$K$9,0)","v":25600},0]
[null,"ブラジャー・サテン（モ・黒）",0.1,38000,null,0,{"$f":"ROUND(D60*$K$9,0)","v":30400},0]
[null,"特注・ブラ９０～",0.1,3000,null,0,{"$f":"D61","v":3000},0]
[null,"特注・Ｇ～",0.1,5000,null,0,{"$f":"D62","v":5000},0]
[null,"ショーツ　～６Ｌ",0.1,5200,null,0,{"$f":"ROUND(D63*$K$9,0)","v":4160},0]
[null,"特注・ショーツ５Ｌ～",0.1,600,null,0,{"$f":"D64","v":600},0]
[null,null,0.1]
[null,"交換ｶｰﾄﾘｯｼﾞIEC-12000",0.1,10000,null,0,{"$f":"D66","v":10000},{"$f":"E66*G66","v":0}]
[null,"ｴｲｼﾞﾚｽﾊﾟﾜｰお試しパック",0.08,1750,null,0,1750,0]
[null,"備品１・金額手入力",0.1,null,null,0,0,0]
[null,"備品２・金額手入力",0.1,null,null,0,0,0]
[null,"送料・九州～5kg",0.1,710,null,0,710,0]
[null,"送料・中国～5kg",0.1,710,null,0,710,0]
[null,"送料・四国～5kg",0.1,920,null,0,920,0]
[null,"送料・関西～5kg",0.1,920,null,0,920,0]
[null,"送料・中部～5kg",0.1,1040,null,0,1040,0]
[null,"送料・北陸～5kg",0.1,1040,null,0,1040,0]
[null,"送料・信越～5kg",0.1,1180,null,0,1180,0]
[null,"送料・関東～5kg",0.1,1180,null,0,1180,0]
[null,"送料・東北～5kg",0.1,1460,null,0,1460,0]
[null,"送料（金額手入力）",0.1,1000,null,0,1000,0]

{"sheet":"送料","index":2,"n_rows":33,"n_cols":7,"rows_kept":33,"cut":false,"hidden":false,"merged":[[26,4,26,6],[10,1,10,2],[11,1,11,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[23,0,23,1],[9,1,9,2],[0,0,0,6],[4,1,5,1],[6,1,6,2],[7,1,7,2],[8,1,8,2]]}
["送　料　価　格　表"]
[]
["２０２３年　（令和５年）　５月　１日　改正",null,null,"※価格は全て税別",null,null,"Ｎｏ.1"]
[]
[null,"地　　　　　域","ｻｲｽﾞ\n3辺合計","80cmまで","100cmまで","120cmまで","160cmまで"]
[null,null,"重さ","5kg以内","10kg以内","15kg以内","25kg以内"]
[99600070,"　九州内　（熊本・福岡・佐賀・\n　　　　　　　　大分・長崎・宮崎・鹿児島）",null,710,790,1180,1380]
[99600080,"　中国　（岡山・広島・山口・鳥取・島根）",null,710,790,1180,1380]
[99600090,"　四国　（香川・徳島・愛媛・高知）",null,920,1000,1390,1590]
[99600100,"　関西　(大阪・京都・滋賀・奈良・\n　　　　　　　　　　　　　　　和歌山・兵庫）",null,920,1000,1390,1590]
[99600110,"　中部　（三重・愛知・静岡・岐阜）",null,1040,1120,1410,1610]
[99600120,"　北陸　（富山・石川・福井）",null,1040,1120,1410,1610]
[99600130,"  信越　（新潟・長野）",null,1180,1260,1650,1850]
[99600140,"　関東　（東京・神奈川・千葉・\n　　　　　群馬・埼玉・茨城・栃木・山梨）",null,1180,1260,1650,1850]
[99600160,"　東北　（宮城・山形・福島・青森・\n　　　　　　　　　　　　　　　　秋田・岩手）",null,1460,1540,1930,2130]
[null,"ｻｲｽﾞ・3辺合計\n　　重　　さ"]
[99600170,"　北海道"]
[99600180,"　沖縄"]
[99600190,"　クール便　"]
[]
[]
[]
[]
["時間指定は５つの時間帯となります。"]
["　　　　午前中　・　14時～16時　・　16時～18時　・　18時～20時　・　19時～21時"]
[]
["※目安として"]
[null,"パーフェクトクリーナー・１本 ⇒ １,０００ｇ",null,"　　　健康食品　１点　　　⇒　約２５０ｇ"]
[null,"もりの泉　１本　　　　　　　　 ⇒  ９００ｇ",null,"　　　シャンプー類　１点　⇒　４８０g"]
[null,"ルイボスティー　１個　　　　 ⇒  ５００ｇ",null,"　　　化粧品　１点　　　　 ⇒　２００ｇ"]
[]
["2023.04.18","                            　　株式会社マスタワールド"]
[null,null,null,null,null,null,"WX-0022B"]

{"sheet":"北海道沖縄","index":3,"n_rows":13,"n_cols":14,"rows_kept":13,"cut":false,"hidden":true,"merged":[]}
[null,"60cmまで","80cmまで","100cmまで","120cmまで","140cmまで","160cmまで"]
[null,"２ｋｇ以内","５ｋｇ以内","１０ｋｇ以内","１５ｋｇ以内","２０ｋｇ以内","２５ｋｇ以内"]
[null,{"$f":"I3*1.1","v":2442},2728,3036.0000000000005,3355.0000000000005,3696.0000000000005,4015.0000000000005,null,2220,2480,2760,3050,3360,3650]
[null,1430.0000000000002,2046.0000000000002,2684,3333.0000000000005,4004.0000000000005,4653,null,1300,1860,2440,3030,3640,4230]
[null,{"$f":"I5*1.1","v":220.00000000000003},{"$f":"J5*1.1","v":220.00000000000003},{"$f":"K5*1.1","v":330},{"$f":"L5*1.1","v":660},null,null,null,200,200,300,600]
[]
[]
[]
[null,"60cmまで","80cmまで","100cmまで","120cmまで","140cmまで","160cmまで"]
[null,"２ｋｇ以内","５ｋｇ以内","１０ｋｇ以内","１５ｋｇ以内","２０ｋｇ以内","２５ｋｇ以内"]
[null,2220,2480,2760,3050,3360,3650]
[null,1300,1860,2440,3030,3640,4230]
[null,200,200,300,600]

{"sheet":"コレクトと時間帯","index":4,"n_rows":8,"n_cols":6,"rows_kept":8,"cut":false,"hidden":true,"merged":[[2,5,3,5],[1,0,1,1],[2,0,3,1],[2,2,3,2],[2,3,3,3],[2,4,3,4]]}
["コレクト手数料　（1回の品代金が最大３０万までです。）"]
["品代金",null,"1万円未満","1万円以上3万円未満","3万円以上10万円未満","10万円以上30万円以下"]
["※代引き手数料を含む\n合計金額が品代金です",null,330,440,660,1100]
[]
[]
[]
["時間指定は５つの時間帯となります。"]
["　　　　午前中　・　14時～16時　・　16時～18時　・　18時～20時　・　19時～21時"]