{"text_format":"1","workbook":"xlsx","n_sheets":25,"sheets":["このアプリについて","ナビゲーションメニュー","ユーザー登録フォーム","店舗設定","顧客一覧","顧客登録","商品一覧","商品登録","商品一括登録","商品分析","受注一覧","受注登録","出荷登録","請求登録","入金登録","請求書","システムマスタ","帳票設定","ルールシート","ゆうパック宛名エクスポート","ヤマトB2エクスポート","発注一覧","発注登録","検品登録","支払登録"],"not_rendered":{"charts":0,"images":32,"macros":1,"external_links":2,"defined_names":36,"comments":7,"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":81,"n_cols":8,"rows_kept":81,"cut":false,"hidden":false,"merged":[[73,25,73,26],[73,28,73,29],[3,25,3,26],[3,28,3,29],[3,31,3,32],[52,25,52,26],[52,28,52,29],[1,25,1,26],[1,28,1,29],[1,31,1,32],[60,25,60,26],[60,28,60,29]]}
[]
[null,null,"　　　このアプリについて"]
[]
[null,null,"特徴"]
[]
[null,"本アプリは楽天、Yahoo、Amazonなどの複数のネットショップを一括して管理、運営する事のできるEXCEL版クラウド型ネットショップ一元管理システムです。"]
[null,"バラバラになっている様々な業務を一元化・自動化し、毎日の「手間」を削減します。"]
[]
[null,"それぞれの店舗管理画面で行っていた受注処理や出荷業務、在庫管理を本アプリ内で完結します。加えて、単純作業の自動化によって"]
[null,"人数を増やさずにネットショップの多店舗展開、運営をお手伝いします。"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"他社サービスとは「ここ」が違います。"]
[]
[null,"ネットショップ業務の効率化・自動化はもちろんのこと、実店舗や外部システムとの連携など"]
[null,"通販業務のあらゆるシーンで活用できる「汎用性」が強みです。"]
[null,"業務上の課題にぶつかった時に「じゃあ、本アプリでどうにかしよう」と言えるような、ネットショップの基幹的な役割として機能します。"]
[]
[]
[]
[null,null,"主な機能"]
[]
[null,"・店舗管理"]
[null,"・商品管理"]
[null,"・顧客管理"]
[null,"・販売管理"]
[null,"・購買管理",null,null,null,null,null,"COMING SOON"]
[null,"・在庫管理",null,null,null,null,null,"COMING SOON"]
[null,null,null,"Amazonでの在庫状況について"]
[null,null,null,"https://www.amazon.co.jp/gp/help/customer/display.html?&nodeId=915624"]
[null,"・データ分析",null,null,null,null,null,"COMING SOON"]
[]
[]
[null,null,"成長に合わせてご利用できる料金"]
[]
[null,"本アプリは、基本料金1万円と受注件数による従量課金のみ。店舗数や商品数による課金がなく、事業拡大に最適な料金体系になっています。"]
[]
[null,"本アプリは、店舗の規模や取り扱い商材に関わらず、長くご利用いただきたいので店舗数・取り扱い商品数による追加費用などはいただいておりません。"]
[null,"新しいモールへの出店や新商品の開発など、新しいことへの挑戦・ビジネスの拡大に、成長に合わせて中長期的にご利用いただけます。"]
[]
[null,"また初期費用も必要ございませんので始めやすく、月々のご利用金額は実際にご利用いただいた分だけとなりますので無駄なコストが発生しません。"]

{"sheet":"ナビゲーションメニュー","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"ユーザー登録フォーム","index":2,"n_rows":33,"n_cols":5,"rows_kept":33,"cut":false,"hidden":true,"merged":[]}
["ユーザー登録フォーム"]
[]
["企業情報"]
[]
[null,"企業名","必須",null,"プロバランス株式会社"]
[null,null,null,null,"例: 有限会社ポートフォリオ"]
[null,null,null,null,"個人事業主の場合は屋号を入力してください"]
[]
[null,"企業名かな","必須",null,"ﾌﾟﾛﾊﾞﾗﾝｽ"]
[null,null,null,null,"個人事業主の場合は屋号を入力してください"]
[]
[null,"郵便番号","必須",null,121999]
[]
[]
[null,"住所 ","必須",null,"東京都港区"]
[]
[null,"電話番号","必須",null,31234444]
[]
[]
["ユーザー情報"]
[]
[null,"氏名","必須",null,"大坂"]
[]
[null,"メールアドレス","必須",null,"osaka@muve.co.jp"]
[]
[null,"メールアドレス（確認）","必須",null,"osaka@muve.co.jp"]
[]
[null,"パスワード","必須",null,"ttest"]
[]
[]
[null,"有効期限",null,null,"2020-12-31"]
[]
[null,"アクセストークン",null,null,"test"]

{"sheet":"店舗設定","index":3,"n_rows":17,"n_cols":7,"rows_kept":17,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,"　　店舗設定"]
[]
[]
[]
[]
[]
[null,null,"店舗区分","店舗名","住所","ユーザID","パスワード"]
[null,null,"ネット","メルカリ","-"]
[null,null,"ネット","Amazon","-"]
[null,null,"ネット","Yahooショッピング","-"]
[null,null,"ネット","ラクマ","-"]
[null,null,"リアル","その他店舗1",null,"-","-"]
[null,null,"リアル","その他店舗2",null,"-","-"]
[null,null,"リアル","その他店舗3",null,"-","-"]
[null,null,"リアル","その他店舗4",null,"-","-"]
[null,null,"リアル","その他店舗5",null,"-","-"]

{"sheet":"顧客一覧","index":4,"n_rows":17,"n_cols":7,"rows_kept":17,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,"　　　顧客一覧"]
[]
[null,null,"顧客名"]
[null,null,"担当者"]
[null,null,"タグ"]
[null,null,"顧客区分"]
[]
[]
[]
[]
[null,null,"顧客コード","顧客名","担当者","担当者電話番号","担当者メールアドレス"]
[null,null,1,"株式会社マイクロソフト","contact",111,"email"]
[null,null,2,"株式会社グーグル","??????",31112222,"email@google.com"]
[null,null,3,"アマゾン株式会社",null,"03-3333-2123"]
[null,null,4,"株式会社テクノプロ","ww","03-111-1111","info@techonopro.co.jp"]
[null,null,5,"株式会社ピー・エス・アイ",null,null,"info@psi-net.co.jp"]

{"sheet":"顧客登録","index":5,"n_rows":41,"n_cols":5,"rows_kept":41,"cut":false,"hidden":true,"merged":[[1,25,1,26],[1,28,1,29],[1,31,1,32]]}
[]
[null,null,"　　　顧客登録"]
[]
[]
[]
[]
[]
[]
[null,"■基本情報"]
[null,null,"顧客コード",2]
[null,null,"顧客名","株式会社グーグル"]
[null,null,"フリガナ"]
[null,null,"顧客区分",null,{"$f":"VLOOKUP(D13,テーブル8[],2,FALSE)","v":{"$error":"#N/A"}}]
[null,null,"〒",null,"　　　　"]
[null,null,"住所1","住所1"]
[null,null,"住所2","住所2"]
[null,null,"代表電話番号"]
[null,null,"URL"]
[null,null,"格付"]
[null,null,"担当者名","??????"]
[null,null,"担当者電話番号"]
[null,null,"担当者メールアドレス","email@google.com"]
[null,null,"備考","新規登録"]
[]
[]
[null,"■タグ情報"]
[null,null,"タグ1",null,"　　　　"]
[null,null,"タグ2",null,"　　　　"]
[null,null,"タグ3",null,"　　　　"]
[]
[]
[null,"■請求情報"]
[null,null,"クレジット種類"]
[null,null,"番号"]
[null,null,"名義人"]
[null,null,"有効期限"]
[null,null,"支払区分"]
[]
[]
[null,"■購入履歴"]
[null,null,"購入日付","商品名（商品コード）","購入金額"]

{"sheet":"商品一覧","index":6,"n_rows":15,"n_cols":11,"rows_kept":15,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,"　　　商品一覧"]
[]
[null,null,"カテゴリ大"]
[null,null,"カテゴリ中"]
[null,null,"カテゴリ小"]
[null,null,"商品名"]
[null,null,"タグ"]
[]
[]
[]
[]
[null,null,"商品コード","商品名","カテゴリ","ASIN","在庫数","メルカリ","ヤフオク","ラクマ","Amazon"]
[null,null,"B01M3VP8NW","S.H.フィギュアーツ ドラゴンボール ゼノバース トランクス","時計","B01M3VP8NW",0,"〇","〇","〇","〇"]
[null,null,"B074X4W9ZN","スマート ブレスレット","時計","B074X4W9ZN",0,"〇","〇","〇","〇"]

{"sheet":"商品登録","index":7,"n_rows":73,"n_cols":14,"rows_kept":73,"cut":false,"hidden":true,"merged":[[1,24,1,25],[1,27,1,28],[1,30,1,31]]}
[]
[null,null,"　　　商品登録"]
[]
[]
[]
[]
[]
[null,"■基本情報",null,null,null,"■商品画像"]
[null,null,"商品コード","B01M3VP8NW",null,null,"PHOTO"]
[null,null,"ASIN","B01M3VP8NW"]
[null,null,"商品名","S.H.フィギュアーツ ドラゴンボール ゼノバース トランクス"]
[null,null,"詳細"]
[null,null,"カテゴリー1"]
[null,null,"カテゴリー2"]
[null,null,"カテゴリー3"]
[null,null,"カテゴリー4"]
[null,null,"商品の状態"]
[null,null,"配送費"]
[null,null,"配送エリア"]
[null,null,"価格"]
[null,null,"備考"]
[null,null,null,0]
[null,"■画像",null,null,null,"■商品分析-価格推移"]
[null,null,"画像1",null,null,null,"日付","ランキング","新品出品者数","新品最安値","中古出品者数","中古最安値","コレクター出品者数","コレクター最安値"]
[null,null,"画像2",null,null,null,"12/15 18時",19647,28,"￥3,000",4,"￥2,979",0]
[null,null,"画像3",null,null,null,"12/13 18時",38990,28,"￥3,300",4,"￥2,979",0]
[null,null,"画像4",null,null,null,"12/11 21時",30370,28,"￥3,300",4,"￥2,979",0]
[null,null,"画像5",null,null,null,"12/09 22時",9145,28,"￥4,092",4,"￥2,979",0]
[null,null,null,null,null,null,"12/07 19時",11890,29,"￥3,500",4,"￥2,979",0]
[null,null,null,null,null,null,"12/05 15時",52167,28,"￥3,500",4,"￥2,979",0]
[null,"■タグ情報",null,null,null,null,"12/03 16時",25633,27,"￥3,495",5,"￥2,980",0]
[null,null,"タグ1",null,null,null,"12/01 22時",38544,27,"￥3,495",5,"￥2,980",0]
[null,null,"タグ2",null,null,null,"11/29 22時",17496,29,"￥4,095",5,"￥2,985",0]
[null,null,"タグ3",null,null,null,"11/27 21時",21792,30,"￥3,500",5,"￥2,985",0]
[null,null,null,null,null,null,"11/25 16時",57810,30,"￥3,500",5,"￥2,985",0]
[null,null,null,null,null,null,"11/23 16時",46901,30,"￥3,500",5,"￥2,985",0]
[null,"■出品情報",null,null,null,null,"11/21 21時",35971,27,"￥3,500",5,"￥2,916",0]
[null,null,"メルカリ","〇",null,null,"11/19 21時",10262,27,"￥3,500",5,"￥2,916",0]
[null,null,"ヤフオク！","〇",null,null,"11/17 19時",41544,27,"￥3,500",5,"￥2,916",0]
[null,null,"ラクマ","〇",null,null,"11/15 20時",16035,27,"￥3,500",4,"￥2,916",0]
[null,null,"Amazon","〇",null,null,"11/13 21時",39099,28,"￥3,499",4,"￥2,916",0]
[null,null,null,null,null,null,"11/11 20時",11828,28,"￥3,499",4,"￥2,916",0]
[null,null,null,null,null,null,"11/09 14時",51938,28,"￥3,499",4,"￥2,916",0]
[null,"■販売履歴",null,null,null,null,"11/07 16時",37791,29,"￥3,499",4,"￥2,916",0]
[null,null,"販売日","顧客名（顧客コード）","販売金額",null,"11/05 22時",18944,29,"￥3,499",4,"￥2,916",0]
[null,null,null,null,null,null,"11/03 21時",23076,28,"￥3,499",4,"￥2,916",0]
[null,null,null,null,null,null,"11/01 15時",28961,27,"￥3,499",5,"￥2,916",0]
[null,null,null,null,null,null,"10/30 20時",10127,27,"￥3,499",5,"￥2,916",0]
[null,null,null,null,null,null,"10/28 21時",14368,26,"￥3,500",5,"￥2,916",0]
[null,null,null,null,null,null,"10/26 19時",8246,31,"￥2,800",5,"￥3,240",0]
[null,null,null,null,null,null,"10/24 22時",36747,32,"￥2,800",5,"￥3,240",0]
[null,null,null,null,null,null,"10/22 08時",63546,32,"￥2,800",5,"￥3,240",0]
[null,null,null,null,null,null,"10/20 06時",59859,31,"￥2,800",5,"￥3,240",0]
[null,null,null,null,null,null,"10/18 21時",46842,31,"￥2,800",5,"￥3,240",0]
[null,null,null,null,null,null,"10/16 20時",21217,30,"￥2,800",5,"￥3,240",0]
[null,null,null,null,null,null,"10/14 16時",48234,30,"￥2,800",5,"￥3,300",0]
[null,null,null,null,null,null,"10/12 23時",31941,31,"￥2,800",5,"￥3,300",0]
[null,null,null,null,null,null,"10/10 22時",3600,31,"￥2,800",5,"￥3,300",0]
[null,null,null,null,null,null,"10/08 18時",43753,31,"￥2,800",4,"￥3,240",0]
[null,null,null,null,null,null,"10/06 14時",65489,31,"￥2,800",4,"￥3,240",0]
[null,null,null,null,null,null,"10/04 13時",69265,32,"￥3,000",4,"￥3,240",0]
[null,null,null,null,null,null,"10/02 12時",64544,33,"￥3,500",4,"￥3,240",0]
[null,null,null,null,null,null,"09/30 16時",49010,32,"￥3,500",4,"￥3,240",0]
[null,null,null,null,null,null,"09/28 15時",40529,33,"￥3,500",4,"￥3,240",0]
[null,null,null,null,null,null,"09/26 19時",42577,34,"￥3,500",4,"￥3,240",0]
[null,null,null,null,null,null,"09/24 20時",47587,32,"￥3,500",4,"￥3,240",0]
[null,null,null,null,null,null,"09/22 22時",14462,33,"￥3,500",4,"￥3,240",0]
[null,null,null,null,null,null,"09/20 20時",56254,32,"￥3,500",4,"￥3,240",0]
[null,null,null,null,null,null,"09/18 21時",48302,30,"￥3,500",5,"￥3,240",0]
[]
[]
[]
[null,null,null,null,null,null,"過去1ヶ月目販売数","過去2ヶ月目販売数","過去3ヶ月目販売数"]

{"sheet":"商品一括登録","index":8,"n_rows":2,"n_cols":13,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
[]
["日本ASIN","アメリカASIN","商品名","検索文字補助","日本価格","日本ポイント","手数料","アメリカ価格","重量[g]","高さ[cm]","長さ[cm]","幅[cm]","例外コード"]

{"sheet":"商品分析","index":9,"n_rows":12,"n_cols":40,"rows_kept":12,"cut":false,"hidden":true,"merged":[]}
[]
["No","日本ASIN","アメリカASIN","商品名","検索文字補助","日本価格\n[円]","日本\nポイント","手数料\n[円]","アメリカ\n価格\n[$]","重量\n[g]","高さ\n[cm]","長さ\n[cm]","幅\n[cm]","サイズ\n[cm^3]","1月前\n販売数","2月前\n販売数","3月前\n販売数","3ヶ月\n合計\n販売数","購入日","購入個数","購入価格\n[$]","送料\n[$]","仕入れ\nID","希望販売価格\n[円](option)","jAmaLink","usAmaLink","usAma2Link","eBayLink","予想\n購入価格","予想\n転送料","予想\n関税","予想\n国内送料\n(+代行費)","予想\n仕入れ値","予想\n入金額","予想\n利益","予想\nROI","高利\n益率","ASIN\n不一致","ASIN\nずれ","リピート\nフラグ"]
[1,{"$f":"TEXT(商品一括登録!A3,0)","v":"0"},{"$f":"TEXT(商品一括登録!B3,0)","v":"0"},{"$f":"商品一括登録!C3","v":0},{"$f":"商品一括登録!D3","v":0},{"$f":"商品一括登録!E3","v":0},{"$f":"商品一括登録!F3","v":0},{"$f":"商品一括登録!G3","v":0},{"$f":"商品一括登録!H3","v":0},{"$f":"商品一括登録!I3","v":0},{"$f":"商品一括登録!J3","v":0},{"$f":"商品一括登録!K3","v":0},{"$f":"商品一括登録!L3","v":0},{"$f":"K3*L3*M3","v":0},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(O3:Q3)","v":{"$error":"#REF!"}},null,null,null,null,null,null,{"$f":"HYPERLINK(\"https://www.amazon.co.jp/dp/\"&B3)","v":"https://www.amazon.co.jp/dp/0"},{"$f":"HYPERLINK(\"https://www.amazon.com/gp/offer-listing/\"&C3&\"/ref=olp_f_new?ie=UTF8&f_new=true\")","v":"https://www.amazon.com/gp/offer-listing/0/ref=olp_f_new?ie=UTF8&f_new=true"},{"$f":"HYPERLINK(\"https://www.amazon.com/s/ref=nb_sb_noss?url=search-alias%3Daps&field-keywords=\"&E3)","v":"https://www.amazon.com/s/ref=nb_sb_noss?url=search-alias%3Daps&field-keywords=0"},{"$f":"HYPERLINK(\"http://www.ebay.com/sch/i.html?_from=R40&_sacat=0&LH_ItemCondition=3&_nkw=\"&E3&\"&_sop=15\")","v":"http://www.ebay.com/sch/i.html?_from=R40&_sacat=0&LH_ItemCondition=3&_nkw=0&_sop=15"},{"$f":"IF(U3=\"\",I3*#REF!,U3*#REF!)","v":{"$error":"#REF!"}},{"$f":"J3*#REF!","v":{"$error":"#REF!"}},{"$f":"((AC3/100)*#REF!)","v":{"$error":"#REF!"}},{"$f":"(#REF!*J3)+#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(AC3:AF3)","v":{"$error":"#REF!"}},{"$f":"F3-G3-H3","v":0},{"$f":"AH3-AG3","v":{"$error":"#REF!"}},{"$f":"AI3/AG3*100","v":{"$error":"#REF!"}},{"$f":"IF(AJ3>#REF!,\"o\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(B3<>C3,\"o\",\"\")","v":""},{"$f":"IF(商品一括登録!A3=#REF!,\"o\",\"x\")","v":{"$error":"#REF!"}},{"$f":"IF(IFERROR(VLOOKUP(B3,#REF!,1,FALSE),\"\")<>\"\",\"o\",\"\")","v":""}]
[{"$f":"A3+1","v":2},{"$f":"TEXT(商品一括登録!A4,0)","v":"0"},{"$f":"TEXT(商品一括登録!B4,0)","v":"0"},{"$f":"商品一括登録!C4","v":0},{"$f":"商品一括登録!D4","v":0},{"$f":"商品一括登録!E4","v":0},{"$f":"商品一括登録!F4","v":0},{"$f":"商品一括登録!G4","v":0},{"$f":"商品一括登録!H4","v":0},{"$f":"商品一括登録!I4","v":0},{"$f":"商品一括登録!J4","v":0},{"$f":"商品一括登録!K4","v":0},{"$f":"商品一括登録!L4","v":0},{"$f":"K4*L4*M4","v":0},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(O4:Q4)","v":{"$error":"#REF!"}},null,null,null,null,null,null,"https://www.amazon.co.jp/dp/0","https://www.amazon.com/gp/offer-listing/0/ref=olp_f_new?ie=UTF8&f_new=true","https://www.amazon.com/s/ref=nb_sb_noss?url=search-alias%3Daps&field-keywords=0","http://www.ebay.com/sch/i.html?_from=R40&_sacat=0&LH_ItemCondition=3&_nkw=0&_sop=15",{"$f":"IF(U4=\"\",I4*#REF!,U4*#REF!)","v":{"$error":"#REF!"}},{"$f":"J4*#REF!","v":{"$error":"#REF!"}},{"$f":"((AC4/100)*#REF!)","v":{"$error":"#REF!"}},{"$f":"(#REF!*J4)+#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"F4-G4-H4","v":0},{"$f":"AH4-AG4","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"IF(AJ4>#REF!,\"o\",\"\")","v":{"$error":"#REF!"}},"",{"$f":"IF(商品一括登録!A4=#REF!,\"o\",\"x\")","v":{"$error":"#REF!"}},{"$f":"IF(IFERROR(VLOOKUP(B4,#REF!,1,FALSE),\"\")<>\"\",\"o\",\"\")","v":""}]
[{"$f":"A4+1","v":3},{"$f":"TEXT(商品一括登録!A5,0)","v":"0"},{"$f":"TEXT(商品一括登録!B5,0)","v":"0"},{"$f":"商品一括登録!C5","v":0},{"$f":"商品一括登録!D5","v":0},{"$f":"商品一括登録!E5","v":0},{"$f":"商品一括登録!F5","v":0},{"$f":"商品一括登録!G5","v":0},{"$f":"商品一括登録!H5","v":0},{"$f":"商品一括登録!I5","v":0},{"$f":"商品一括登録!J5","v":0},{"$f":"商品一括登録!K5","v":0},{"$f":"商品一括登録!L5","v":0},0,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},null,null,null,null,null,null,"https://www.amazon.co.jp/dp/0","https://www.amazon.com/gp/offer-listing/0/ref=olp_f_new?ie=UTF8&f_new=true","https://www.amazon.com/s/ref=nb_sb_noss?url=search-alias%3Daps&field-keywords=0","http://www.ebay.com/sch/i.html?_from=R40&_sacat=0&LH_ItemCondition=3&_nkw=0&_sop=15",{"$f":"IF(U5=\"\",I5*#REF!,U5*#REF!)","v":{"$error":"#REF!"}},{"$f":"J5*#REF!","v":{"$error":"#REF!"}},{"$f":"((AC5/100)*#REF!)","v":{"$error":"#REF!"}},{"$f":"(#REF!*J5)+#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},0,{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(AJ5>#REF!,\"o\",\"\")","v":{"$error":"#REF!"}},"",{"$f":"IF(商品一括登録!A5=#REF!,\"o\",\"x\")","v":{"$error":"#REF!"}},{"$f":"IF(IFERROR(VLOOKUP(B5,#REF!,1,FALSE),\"\")<>\"\",\"o\",\"\")","v":""}]
[4,{"$f":"TEXT(商品一括登録!A6,0)","v":"0"},{"$f":"TEXT(商品一括登録!B6,0)","v":"0"},{"$f":"商品一括登録!C6","v":0},{"$f":"商品一括登録!D6","v":0},{"$f":"商品一括登録!E6","v":0},{"$f":"商品一括登録!F6","v":0},{"$f":"商品一括登録!G6","v":0},{"$f":"商品一括登録!H6","v":0},{"$f":"商品一括登録!I6","v":0},{"$f":"商品一括登録!J6","v":0},{"$f":"商品一括登録!K6","v":0},{"$f":"商品一括登録!L6","v":0},0,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},null,null,null,null,null,null,"https://www.amazon.co.jp/dp/0","https://www.amazon.com/gp/offer-listing/0/ref=olp_f_new?ie=UTF8&f_new=true","https://www.amazon.com/s/ref=nb_sb_noss?url=search-alias%3Daps&field-keywords=0","http://www.ebay.com/sch/i.html?_from=R40&_sacat=0&LH_ItemCondition=3&_nkw=0&_sop=15",{"$f":"IF(U6=\"\",I6*#REF!,U6*#REF!)","v":{"$error":"#REF!"}},{"$f":"J6*#REF!","v":{"$error":"#REF!"}},{"$f":"((AC6/100)*#REF!)","v":{"$error":"#REF!"}},{"$f":"(#REF!*J6)+#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},0,{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(AJ6>#REF!,\"o\",\"\")","v":{"$error":"#REF!"}},"",{"$f":"IF(商品一括登録!A6=#REF!,\"o\",\"x\")","v":{"$error":"#REF!"}},{"$f":"IF(IFERROR(VLOOKUP(B6,#REF!,1,FALSE),\"\")<>\"\",\"o\",\"\")","v":""}]
[5,{"$f":"TEXT(商品一括登録!A7,0)","v":"0"},{"$f":"TEXT(商品一括登録!B7,0)","v":"0"},{"$f":"商品一括登録!C7","v":0},{"$f":"商品一括登録!D7","v":0},{"$f":"商品一括登録!E7","v":0},{"$f":"商品一括登録!F7","v":0},{"$f":"商品一括登録!G7","v":0},{"$f":"商品一括登録!H7","v":0},{"$f":"商品一括登録!I7","v":0},{"$f":"商品一括登録!J7","v":0},{"$f":"商品一括登録!K7","v":0},{"$f":"商品一括登録!L7","v":0},0,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},null,null,null,null,null,null,"https://www.amazon.co.jp/dp/0","https://www.amazon.com/gp/offer-listing/0/ref=olp_f_new?ie=UTF8&f_new=true","https://www.amazon.com/s/ref=nb_sb_noss?url=search-alias%3Daps&field-keywords=0","http://www.ebay.com/sch/i.html?_from=R40&_sacat=0&LH_ItemCondition=3&_nkw=0&_sop=15",{"$f":"IF(U7=\"\",I7*#REF!,U7*#REF!)","v":{"$error":"#REF!"}},{"$f":"J7*#REF!","v":{"$error":"#REF!"}},{"$f":"((AC7/100)*#REF!)","v":{"$error":"#REF!"}},{"$f":"(#REF!*J7)+#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},0,{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(AJ7>#REF!,\"o\",\"\")","v":{"$error":"#REF!"}},"",{"$f":"IF(商品一括登録!A7=#REF!,\"o\",\"x\")","v":{"$error":"#REF!"}},{"$f":"IF(IFERROR(VLOOKUP(B7,#REF!,1,FALSE),\"\")<>\"\",\"o\",\"\")","v":""}]
[6,{"$f":"TEXT(商品一括登録!A8,0)","v":"0"},{"$f":"TEXT(商品一括登録!B8,0)","v":"0"},{"$f":"商品一括登録!C8","v":0},{"$f":"商品一括登録!D8","v":0},{"$f":"商品一括登録!E8","v":0},{"$f":"商品一括登録!F8","v":0},{"$f":"商品一括登録!G8","v":0},{"$f":"商品一括登録!H8","v":0},{"$f":"商品一括登録!I8","v":0},{"$f":"商品一括登録!J8","v":0},{"$f":"商品一括登録!K8","v":0},{"$f":"商品一括登録!L8","v":0},0,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},null,null,null,null,null,null,"https://www.amazon.co.jp/dp/0","https://www.amazon.com/gp/offer-listing/0/ref=olp_f_new?ie=UTF8&f_new=true","https://www.amazon.com/s/ref=nb_sb_noss?url=search-alias%3Daps&field-keywords=0","http://www.ebay.com/sch/i.html?_from=R40&_sacat=0&LH_ItemCondition=3&_nkw=0&_sop=15",{"$f":"IF(U8=\"\",I8*#REF!,U8*#REF!)","v":{"$error":"#REF!"}},{"$f":"J8*#REF!","v":{"$error":"#REF!"}},{"$f":"((AC8/100)*#REF!)","v":{"$error":"#REF!"}},{"$f":"(#REF!*J8)+#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},0,{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(AJ8>#REF!,\"o\",\"\")","v":{"$error":"#REF!"}},"",{"$f":"IF(商品一括登録!A8=#REF!,\"o\",\"x\")","v":{"$error":"#REF!"}},{"$f":"IF(IFERROR(VLOOKUP(B8,#REF!,1,FALSE),\"\")<>\"\",\"o\",\"\")","v":""}]
[7,{"$f":"TEXT(商品一括登録!A9,0)","v":"0"},{"$f":"TEXT(商品一括登録!B9,0)","v":"0"},{"$f":"商品一括登録!C9","v":0},{"$f":"商品一括登録!D9","v":0},{"$f":"商品一括登録!E9","v":0},{"$f":"商品一括登録!F9","v":0},{"$f":"商品一括登録!G9","v":0},{"$f":"商品一括登録!H9","v":0},{"$f":"商品一括登録!I9","v":0},{"$f":"商品一括登録!J9","v":0},{"$f":"商品一括登録!K9","v":0},{"$f":"商品一括登録!L9","v":0},0,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},null,null,null,null,null,null,"https://www.amazon.co.jp/dp/0","https://www.amazon.com/gp/offer-listing/0/ref=olp_f_new?ie=UTF8&f_new=true","https://www.amazon.com/s/ref=nb_sb_noss?url=search-alias%3Daps&field-keywords=0","http://www.ebay.com/sch/i.html?_from=R40&_sacat=0&LH_ItemCondition=3&_nkw=0&_sop=15",{"$f":"IF(U9=\"\",I9*#REF!,U9*#REF!)","v":{"$error":"#REF!"}},{"$f":"J9*#REF!","v":{"$error":"#REF!"}},{"$f":"((AC9/100)*#REF!)","v":{"$error":"#REF!"}},{"$f":"(#REF!*J9)+#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},0,{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(AJ9>#REF!,\"o\",\"\")","v":{"$error":"#REF!"}},"",{"$f":"IF(商品一括登録!A9=#REF!,\"o\",\"x\")","v":{"$error":"#REF!"}},{"$f":"IF(IFERROR(VLOOKUP(B9,#REF!,1,FALSE),\"\")<>\"\",\"o\",\"\")","v":""}]
[8,{"$f":"TEXT(商品一括登録!A10,0)","v":"0"},{"$f":"TEXT(商品一括登録!B10,0)","v":"0"},{"$f":"商品一括登録!C10","v":0},{"$f":"商品一括登録!D10","v":0},{"$f":"商品一括登録!E10","v":0},{"$f":"商品一括登録!F10","v":0},{"$f":"商品一括登録!G10","v":0},{"$f":"商品一括登録!H10","v":0},{"$f":"商品一括登録!I10","v":0},{"$f":"商品一括登録!J10","v":0},{"$f":"商品一括登録!K10","v":0},{"$f":"商品一括登録!L10","v":0},0,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},null,null,null,null,null,null,"https://www.amazon.co.jp/dp/0","https://www.amazon.com/gp/offer-listing/0/ref=olp_f_new?ie=UTF8&f_new=true","https://www.amazon.com/s/ref=nb_sb_noss?url=search-alias%3Daps&field-keywords=0","http://www.ebay.com/sch/i.html?_from=R40&_sacat=0&LH_ItemCondition=3&_nkw=0&_sop=15",{"$f":"IF(U10=\"\",I10*#REF!,U10*#REF!)","v":{"$error":"#REF!"}},{"$f":"J10*#REF!","v":{"$error":"#REF!"}},{"$f":"((AC10/100)*#REF!)","v":{"$error":"#REF!"}},{"$f":"(#REF!*J10)+#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},0,{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(AJ10>#REF!,\"o\",\"\")","v":{"$error":"#REF!"}},"",{"$f":"IF(商品一括登録!A10=#REF!,\"o\",\"x\")","v":{"$error":"#REF!"}},{"$f":"IF(IFERROR(VLOOKUP(B10,#REF!,1,FALSE),\"\")<>\"\",\"o\",\"\")","v":""}]
[9,{"$f":"TEXT(商品一括登録!A11,0)","v":"0"},{"$f":"TEXT(商品一括登録!B11,0)","v":"0"},{"$f":"商品一括登録!C11","v":0},{"$f":"商品一括登録!D11","v":0},{"$f":"商品一括登録!E11","v":0},{"$f":"商品一括登録!F11","v":0},{"$f":"商品一括登録!G11","v":0},{"$f":"商品一括登録!H11","v":0},{"$f":"商品一括登録!I11","v":0},{"$f":"商品一括登録!J11","v":0},{"$f":"商品一括登録!K11","v":0},{"$f":"商品一括登録!L11","v":0},0,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},null,null,null,null,null,null,"https://www.amazon.co.jp/dp/0","https://www.amazon.com/gp/offer-listing/0/ref=olp_f_new?ie=UTF8&f_new=true","https://www.amazon.com/s/ref=nb_sb_noss?url=search-alias%3Daps&field-keywords=0","http://www.ebay.com/sch/i.html?_from=R40&_sacat=0&LH_ItemCondition=3&_nkw=0&_sop=15",{"$f":"IF(U11=\"\",I11*#REF!,U11*#REF!)","v":{"$error":"#REF!"}},{"$f":"J11*#REF!","v":{"$error":"#REF!"}},{"$f":"((AC11/100)*#REF!)","v":{"$error":"#REF!"}},{"$f":"(#REF!*J11)+#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},0,{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(AJ11>#REF!,\"o\",\"\")","v":{"$error":"#REF!"}},"",{"$f":"IF(商品一括登録!A11=#REF!,\"o\",\"x\")","v":{"$error":"#REF!"}},{"$f":"IF(IFERROR(VLOOKUP(B11,#REF!,1,FALSE),\"\")<>\"\",\"o\",\"\")","v":""}]
[10,{"$f":"TEXT(商品一括登録!A12,0)","v":"0"},{"$f":"TEXT(商品一括登録!B12,0)","v":"0"},{"$f":"商品一括登録!C12","v":0},{"$f":"商品一括登録!D12","v":0},{"$f":"商品一括登録!E12","v":0},{"$f":"商品一括登録!F12","v":0},{"$f":"商品一括登録!G12","v":0},{"$f":"商品一括登録!H12","v":0},{"$f":"商品一括登録!I12","v":0},{"$f":"商品一括登録!J12","v":0},{"$f":"商品一括登録!K12","v":0},{"$f":"商品一括登録!L12","v":0},0,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},null,null,null,null,null,null,"https://www.amazon.co.jp/dp/0","https://www.amazon.com/gp/offer-listing/0/ref=olp_f_new?ie=UTF8&f_new=true","https://www.amazon.com/s/ref=nb_sb_noss?url=search-alias%3Daps&field-keywords=0","http://www.ebay.com/sch/i.html?_from=R40&_sacat=0&LH_ItemCondition=3&_nkw=0&_sop=15",{"$f":"IF(U12=\"\",I12*#REF!,U12*#REF!)","v":{"$error":"#REF!"}},{"$f":"J12*#REF!","v":{"$error":"#REF!"}},{"$f":"((AC12/100)*#REF!)","v":{"$error":"#REF!"}},{"$f":"(#REF!*J12)+#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},0,{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(AJ12>#REF!,\"o\",\"\")","v":{"$error":"#REF!"}},"",{"$f":"IF(商品一括登録!A12=#REF!,\"o\",\"x\")","v":{"$error":"#REF!"}},{"$f":"IF(IFERROR(VLOOKUP(B12,#REF!,1,FALSE),\"\")<>\"\",\"o\",\"\")","v":""}]

{"sheet":"受注一覧","index":10,"n_rows":18,"n_cols":15,"rows_kept":18,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,"　　　受注一覧"]
[]
[null,null,"対象期間",null,"～"]
[null,null,"状態"]
[null,null,"店舗",5,"その他店舗1"]
[null,null,"顧客"]
[null,null,"伝票No"]
[]
[]
[]
[null,null,"伝票No","販売年月日","品名","単価","数量","金額","顧客ID","顧客名","顧客担当者","メールアドレス","納期","請求月","備考"]
[null,null,1,"2017-12-01T00:00:00",null,null,null,10000,1,"株式会社マイクロソフト","contact"]
[null,null,2,"2017-12-05T00:00:00",null,null,null,10000,1,"株式会社マイクロソフト","contact"]
[null,null,3,"2017-12-07T00:00:00",null,null,null,10000,1,"株式会社マイクロソフト","contact"]
[null,null,4,"2017-12-08T00:00:00","ttest",200,5,1000,1,"株式会社マイクロソフト","contact",null,null,"memo"]
[null,null,5,"2017-12-08T00:00:00","ttest",200,5,1000,1,"株式会社マイクロソフト","contact",null,null,"memo"]
[null,null,6,"2017-12-08T00:00:00","test2",100,10,1000,1,"株式会社マイクロソフト","contact",null,null,"mmmmmeeee"]

{"sheet":"受注登録","index":11,"n_rows":92,"n_cols":16,"rows_kept":92,"cut":false,"hidden":true,"merged":[[1,25,1,26],[1,28,1,29],[1,31,1,32]]}
[]
[null,null,"　　　受注登録"]
[]
[]
[]
[]
[]
[]
[null,"■登録情報"]
[null,null,"伝票No",2]
[null,null,"受注状態","株式会社マイクロソフト"]
[null,null,"受注年月日"]
[null,null,"店舗"]
[null,null,"顧客区分",1,{"$f":"VLOOKUP(D14,テーブル8[],2,FALSE)","v":"一般"}]
[null,null,"平均単価"]
[null,null,"数量"]
[null,null,"金額"]
[null,null,"納期"]
[null,null,"請求日"]
[null,null,"担当者"]
[null,null,"納品書特記事項"]
[null,null,"出荷日"]
[null,null,"入金確認日"]
[null,null,"備考"]
[]
[]
[null,"■顧客情報"]
[null,null,"顧客ID"]
[null,null,"顧客名"]
[null,null,"フリガナ"]
[null,null,"顧客区分"]
[null,null,"〒"]
[null,null,"住所1"]
[null,null,"住所2"]
[null,null,"代表電話番号"]
[null,null,"URL"]
[null,null,"格付"]
[null,null,"担当者名"]
[null,null,"担当者電話番号"]
[null,null,"担当者メールアドレス"]
[null,null,"購入回数"]
[null,null,"備考"]
[]
[]
[null,"■送り先情報"]
[null,null,"送り先名"]
[null,null,"フリガナ"]
[null,null,"電話番号"]
[null,null,"〒"]
[null,null,"住所1"]
[null,null,"住所2"]
[null,null,"ギフト"]
[null,null,"発送方法"]
[null,null,"時間指定"]
[null,null,"配達希望日"]
[null,null,"発送伝票番号"]
[null,null,"郵便"]
[null,null,"送り状"]
[null,null,"シール1"]
[null,null,"シール2"]
[null,null,"シール3"]
[null,null,"シール4"]
[null,null,"温度"]
[null,null,"営業所止"]
[null,null,"ラベル発行日"]
[null,null,"発送伝票備考欄"]
[null,null,"出荷予定"]
[]
[]
[null,"■請求情報"]
[null,null,"支払方法"]
[null,null,"入金日"]
[null,null,"クレジット種類"]
[null,null,"番号"]
[null,null,"名義人"]
[null,null,"有効期限"]
[null,null,"支払区分"]
[null,null,"入金状況"]
[null,null,"入金額"]
[null,null,"承認状況"]
[null,null,"承認番号"]
[null,null,"承認日"]
[]
[]
[null,null,"商品計（税込）"]
[null,null,"手数料（税込）"]
[null,null,"発送代（税込）"]
[null,null,"他費用（税込）"]
[null,null,"ポイント数"]
[]
[null,"■商品情報"]
[null,null,"商品コード","列1","ASIN","受注数","引当数","予約引当","引当日","売単価","小計","原単価","掛率","同梱元伝票","取扱区分","商品区分"]

{"sheet":"出荷登録","index":12,"n_rows":17,"n_cols":14,"rows_kept":17,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,"　　　出荷登録"]
[]
[null,null,"対象期間","2017-7-1","～","2017-7-31"]
[null,null,"出荷状態"]
[null,null,"店舗"]
[null,null,"顧客名"]
[null,null,"伝票No"]
[]
[]
[]
[null,null,"伝票No","販売年月日","品名","単価","数量","金額","顧客ID","顧客名","顧客担当者","納期","請求月","備考"]
[null,null,42767,null,null,null,null,null,1,"株式会社マイクロソフト","contact","2017-12-31","2018-01-31"]
[null,null,42795,null,null,null,null,null,1,"株式会社マイクロソフト","contact","2017-12-31","2018-01-31"]
[null,null,42826,null,null,null,null,null,1,"株式会社マイクロソフト","contact","2017-12-31","2018-01-31"]
[null,null,42767,null,null,null,null,null,1,"株式会社マイクロソフト","contact","2017-12-31","2018-01-31"]
[null,null,42736,null,null,null,null,null,1,"株式会社マイクロソフト","contact","2017-12-31","2018-01-31"]

{"sheet":"請求登録","index":13,"n_rows":17,"n_cols":37,"rows_kept":17,"cut":false,"hidden":true,"merged":[[1,28,1,29],[1,31,1,32],[1,34,1,35]]}
[]
[null,null,"　　　請求登録",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"年",null,null,"月",null,null,"日"]
[]
[null,null,"対象期間","2017-7-1","～","2017-7-31"]
[null,null,"請求状態"]
[null,null,"店舗"]
[null,null,"顧客名"]
[null,null,"伝票No"]
[]
[]
[]
[null,null,"伝票No","販売年月日","品名","単価","数量","金額","顧客ID","顧客名","顧客担当者","納期","請求月","備考"]
[null,null,42767,null,null,null,null,null,1,"株式会社マイクロソフト","contact","2017-12-31","2018-01-31"]
[null,null,42795,null,null,null,null,null,1,"株式会社マイクロソフト","contact","2017-12-31","2018-01-31"]
[null,null,42826,null,null,null,null,null,1,"株式会社マイクロソフト","contact","2017-12-31","2018-01-31"]
[null,null,42767,null,null,null,null,null,1,"株式会社マイクロソフト","contact","2017-12-31","2018-01-31"]
[null,null,42736,null,null,null,null,null,1,"株式会社マイクロソフト","contact","2017-12-31","2018-01-31"]

{"sheet":"入金登録","index":14,"n_rows":17,"n_cols":37,"rows_kept":17,"cut":false,"hidden":true,"merged":[[1,28,1,29],[1,31,1,32],[1,34,1,35]]}
[]
[null,null,"　　　入金登録",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"年",null,null,"月",null,null,"日"]
[]
[null,null,"対象期間","2017-7-1","～","2017-7-31"]
[null,null,"入金状態"]
[null,null,"店舗"]
[null,null,"顧客名"]
[null,null,"伝票No"]
[]
[]
[]
[null,null,"伝票No","販売年月日","品名","単価","数量","金額","顧客ID","顧客名","顧客担当者","納期","請求月","備考"]
[null,null,42767,null,null,null,null,null,1,"株式会社マイクロソフト","contact","2017-12-31","2018-01-31"]
[null,null,42795,null,null,null,null,null,1,"株式会社マイクロソフト","contact","2017-12-31","2018-01-31"]
[null,null,42826,null,null,null,null,null,1,"株式会社マイクロソフト","contact","2017-12-31","2018-01-31"]
[null,null,42767,null,null,null,null,null,1,"株式会社マイクロソフト","contact","2017-12-31","2018-01-31"]
[null,null,42736,null,null,null,null,null,1,"株式会社マイクロソフト","contact","2017-12-31","2018-01-31"]

{"sheet":"請求書","index":15,"n_rows":32,"n_cols":34,"rows_kept":32,"cut":false,"hidden":true,"merged":[[27,22,27,26],[27,27,27,33],[28,22,28,26],[28,27,28,33],[29,22,29,26],[29,27,29,33],[26,2,26,3],[26,4,26,12],[26,13,26,17],[26,18,26,21],[26,22,26,26],[26,27,26,33],[28,19,28,21],[25,2,25,3],[25,4,25,12],[25,13,25,17],[25,18,25,21],[25,22,25,26],[25,27,25,33],[24,2,24,3],[24,4,24,12],[24,13,24,17],[24,18,24,21],[24,22,24,26],[24,27,24,33],[23,2,23,3],[23,4,23,12],[23,13,23,17],[23,18,23,21],[23,22,23,26],[23,27,23,33],[22,2,22,3],[22,4,22,12],[22,13,22,17],[22,18,22,21],[22,22,22,26],[22,27,22,33],[21,2,21,3],[21,4,21,12],[21,13,21,17],[21,18,21,21],[21,22,21,26],[21,27,21,33],[20,2,20,3],[20,4,20,12],[20,13,20,17],[20,18,20,21],[20,22,20,26],[20,27,20,33],[19,2,19,3],[19,4,19,12],[19,13,19,17],[19,18,19,21],[19,22,19,26],[19,27,19,33],[18,2,18,3],[18,4,18,12],[18,13,18,17],[18,18,18,21],[18,22,18,26],[18,27,18,33],[17,2,17,3],[17,4,17,12],[17,13,17,17],[17,18,17,21],[17,22,17,26],[17,27,17,33],[16,2,16,3],[16,4,16,12],[16,13,16,17],[16,18,16,21],[16,22,16,26],[16,27,16,33],[15,2,15,3],[15,4,15,12],[15,13,15,17],[15,18,15,21],[15,22,15,26],[15,27,15,33],[14,2,14,3],[14,4,14,12],[14,13,14,17],[14,18,14,21],[14,22,14,26],[14,27,14,33],[13,2,13,3],[13,4,13,12],[13,13,13,17],[13,18,13,21],[13,22,13,26],[13,27,13,33],[12,2,12,3],[12,4,12,12],[12,13,12,17],[12,18,12,21],[12,22,12,26],[12,27,12,33],[11,2,11,3],[11,4,11,12],[11,13,11,17],[11,18,11,21],[11,22,11,26],[11,27,11,33],[10,2,10,3],[10,4,10,12],[10,13,10,17],[10,18,10,21],[10,22,10,26],[10,27,10,33],[5,2,5,18],[5,21,5,33],[6,2,6,18],[6,24,6,33],[7,24,7,33],[8,24,8,33],[1,25,1,26],[1,28,1,29],[1,31,1,32],[3,2,3,18],[3,21,3,33],[4,2,4,18],[4,22,4,33]]}
[]
[null,null,null,"請求書",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"年",null,null,"月",null,null,"日"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"システムマスタ!D9","v":"有限会社ポートフォリオ"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"〒",{"$f":"システムマスタ!L9","v":"193-0033"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"システムマスタ!L10","v":"東京都八王子市旭町4-11-9"}]
[null,null,"【担当者名を記載】",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"担当",null,"：",{"$f":"システムマスタ!D19","v":"名前："}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TEL",null,"：",{"$f":"システムマスタ!L13","v":"042-665-1234"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FAX",null,"：",{"$f":"システムマスタ!L16","v":"042-665-1235"}]
[]
[null,null,"No.",null,"品名",null,null,null,null,null,null,null,null,"単価",null,null,null,null,"数量",null,null,null,"金額",null,null,null,null,"備考"]
[null,null,1,null,"○○○○",null,null,null,null,null,null,null,null,100000,null,null,null,null,1,null,null,null,{"$f":"IF(N12*S12>0,N12*S12,\"\")","v":100000}]
[null,null,2]
[null,null,3]
[null,null,4]
[null,null,5]
[null,null,6]
[null,null,7]
[null,null,8]
[null,null,9]
[null,null,10]
[null,null,11]
[null,null,12]
[null,null,13]
[null,null,14]
[null,null,15]
[null,null,16]
[null,null,null,null,"小計",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(W12:AA26)>0,SUM(W12:AA26),\"\")","v":100000}]
[null,null,null,null,"消費税",null,null,null,null,null,null,null,null,null,null,"消費税率",null,null,null,{"$f":"システムマスタ!D27","v":0.08},null,null,{"$f":"W28*T29","v":8000}]
[null,null,null,null,"税込合計",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(W28>0,W28+W29,\"\")","v":108000}]
[]
[null,null,"備考"]

{"sheet":"システムマスタ","index":16,"n_rows":34,"n_cols":16,"rows_kept":34,"cut":false,"hidden":true,"merged":[[19,4,19,7],[22,4,22,7],[23,4,23,7],[22,11,22,15],[18,11,18,15],[23,11,23,15],[19,11,19,15],[8,3,8,7],[9,11,9,15],[18,4,18,7],[12,11,12,12],[15,11,15,12],[12,3,12,7],[15,3,15,7]]}
[]
[null,null,"　　システムマスタ"]
[]
[]
[]
[]
[]
[null,"■会社名",null,null,null,null,null,null,null,"■会社住所"]
[null,null,null,"有限会社ポートフォリオ",null,null,null,null,null,null,null,"193-0033"]
[null,null,"カナ","ﾕｳｹﾞﾝｶﾞｲｼｬﾎﾟｰﾄﾌｫﾘｵ",null,null,null,null,null,null,null,"東京都八王子市旭町4-11-9"]
[]
[null,"■会社署名",null,null,null,null,null,null,null,"■会社TEL"]
[null,null,null,"D:\\vba\\販売・仕入管理\\mail_templates\\signiture.txt",null,null,null,null,null,null,null,"042-665-1234"]
[]
[null,"■会社URL",null,null,null,null,null,null,null,"■会社FAX"]
[null,null,null,"http://www.port-folio.co.jp",null,null,null,null,null,null,null,"042-665-1235"]
[]
[null,"■営業担当者",null,null,null,null,null,null,null,"■サンクスメールテンプレート"]
[null,null,null,"名前：","営業太郎",null,null,null,null,null,null,"<% customer_name %>様　ご注文誠にありがとうございました。"]
[null,null,null,"メール：","example@example.jp",null,null,null,null,null,null,"D:\\vba\\販売・仕入管理\\mail_templates\\thanks.txt"]
[]
[null,"■購買担当者",null,null,null,null,null,null,null,"■発送連絡メールテンプレート"]
[null,null,null,"名前：","購買二郎",null,null,null,null,null,null,"<% customer_name %>様　発送いたしました。"]
[null,null,null,"メール：","example@example.jp",null,null,null,null,null,null,false]
[]
[null,"■税設定",null,null,null,"■為替レート[円/ドル]",null,null,null,"■目標ROI"]
[null,null,"率",0.08,null,null,115,null,null,null,null,0.2]
[]
[]
[null,"■顧客区分",null,null,null,"■住所",null,null,null,null,"■カテゴリ"]
[null,null,"コード","区分",null,null,"郵便番号","住所1","住所2",null,null,"カテゴリコード","カテゴリ1","カテゴリ2","カテゴリ3","カテゴリ4"]
[null,null,1,"一般",null,null,1930824,"東京都八王子市","長房町"]
[null,null,2,"常連"]
[null,null,99,"ブラック"]

{"sheet":"帳票設定","index":17,"n_rows":20,"n_cols":7,"rows_kept":20,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,"　　帳票設定"]
[]
[]
[]
[]
[]
[null,null,null,"帳票","項目","行","列"]
[null,null,null,"請求書","請求年",2,26]
[null,null,null,"請求書","請求月",2,29]
[null,null,null,"請求書","請求日",2,32]
[null,null,null,"請求書","顧客名",7,3]
[null,null,null,"請求書","品名","-",5]
[null,null,null,"請求書","単価","-",14]
[null,null,null,"請求書","数量","-",19]
[null,null,null,"請求書","金額","-",23]
[null,null,null,"請求書","備考1","-",28]
[null,null,null,"請求書","備考2_1",33,3]
[null,null,null,"請求書","備考2_2",34,3]
[null,null,null,"請求書","備考2_3",35,3]

{"sheet":"ルールシート","index":18,"n_rows":12,"n_cols":13,"rows_kept":12,"cut":false,"hidden":true,"merged":[]}
["列1","No.","項目名称","文字形式","桁数","宅急便\n必須項目","DM便\n必須項目","正規表現","シート名","列番号","元の値","変換後の値","備考"]
["ご依頼主データ",1,"ご依頼主コード","半角英数字","20文字",null,null,"^[a-zA-Z\\d]{0,12}$","インプット",1,null,{"$f":"テーブル143[[#This Row],[元の値]]","v":0}]
["ご依頼主データ",2,"ご依頼主電話番号","半角英数字&ハイフン","15文字","○",null,"^[a-zA-Z\\d-]{0,15}$","インプット",5,null,{"$f":"テーブル143[[#This Row],[元の値]]","v":0},"ハイフン含む"]
["ご依頼主データ",3,"ご依頼主電話番号枝番","半角英数字","2文字",null,null,null,"インプット","-",null,"0","「0」固定"]
["ご依頼主データ",4,"ご依頼主郵便番号","半角英数字&ハイフン","8文字","○",null,"^[a-zA-Z\\d-]{7,8}$","インプット",7,null,{"$f":"テーブル143[[#This Row],[元の値]]","v":0},"ハイフンなし半角7文字も可"]
["ご依頼主データ",5,"ご依頼主住所","全角/半角\n都道府県（４文字）\n＋市区郡町村（１２文字）\n＋町・番地（１６文字）","32文字/64文字","○",null,"^.{0,64}$","インプット",8,null,{"$f":"テーブル143[[#This Row],[元の値]]","v":0}]
["ご依頼主データ",6,"ご依頼主住所（アパートマンション名）","全角/半角 ","16文字/32文字",null,null,null,"インプット","-",null,null,"空白固定"]
["ご依頼主データ",7,"ご依頼主名","全角/半角 ","16文字/32文字","○",null,"^.{0,32}$","インプット",2,null,{"$f":"テーブル143[[#This Row],[元の値]]","v":0}]
["ご依頼主データ",8,"ご依頼主名略称カナ","半角カタカナ","50文字",null,null,"^[ｦ-ﾟ]{0,50}$","インプット",3,null,{"$f":"テーブル143[[#This Row],[元の値]]","v":0}]
["ご依頼主データ",9,"ご請求先顧客コード","半角数字 ","12文字",null,null,null,"インプット",1,null,{"$f":"テーブル143[[#This Row],[元の値]]","v":0}]
["ご依頼主データ",10,"ご請求先分類コード","半角数字 ","3文字",null,null,null,"インプット","-",null,{"$f":"IF(K10=1,\"A\",\"B\")","v":"B"},"顧客コードが1の場合「A」、それ以外の場合「B」"]
["ご依頼主データ",11,"運賃管理番号","半角数字 ","2文字",null,null,"^\\d{1,2}$","インプット","-","[row]",{"$f":"テーブル143[[#This Row],[元の値]]","v":"[row]"},"データの行番号"]

{"sheet":"ゆうパック宛名エクスポート","index":19,"n_rows":127,"n_cols":14,"rows_kept":127,"cut":false,"hidden":true,"merged":[]}
["データ種類","No.","項目名","文字形式","桁数","必須","正規表現","シート名","列番号","元の値","返還後の値","説明"]
["アドレス帳(標準フォーマット)",1,"利用区分","数値",1,"○",null,null,null,null,1,"ご依頼主の場合は「0」、お届け先の場合は「1」を必ず設定してください。"]
["アドレス帳(標準フォーマット)",2,"お名前","全角文字",25,"※1",null,null,null,null,{"$f":"テーブル20[[#This Row],[元の値]]","v":0},null,null,"※1　お名前、法人名のどちらか一方は必ず設定してください。"]
["アドレス帳(標準フォーマット)",3,"お名前（カナ）","全角カナ",25,"-",null,null,null,null,{"$f":"テーブル20[[#This Row],[元の値]]","v":0}]
["アドレス帳(標準フォーマット)",4,"法人名","全角文字",25,"※1",null,null,null,null,{"$f":"テーブル20[[#This Row],[元の値]]","v":0},"法人名と部署名は合計で30文字以下になるように設定してください。",null,"※1　お名前、法人名のどちらか一方は必ず設定してください。"]
["アドレス帳(標準フォーマット)",5,"部署名","全角文字",25,"-",null,null,null,null,{"$f":"テーブル20[[#This Row],[元の値]]","v":0},"法人名と部署名は合計で30文字以下になるように設定してください。"]
["アドレス帳(標準フォーマット)",6,"敬称","全角文字",2,"-",null,null,null,null,{"$f":"テーブル20[[#This Row],[元の値]]","v":0},"「様」「殿」「御中」「行」「係」「宛」のいずれかを設定してください。\n（何も設定しない場合は敬称を付加しません）"]
["アドレス帳(標準フォーマット)",7,"郵便番号","半角数字",7,"○",null,null,null,null,{"$f":"テーブル20[[#This Row],[元の値]]","v":0}]
["アドレス帳(標準フォーマット)",8,"都道府県","全角文字",4,"-",null,null,null,null,{"$f":"テーブル20[[#This Row],[元の値]]","v":0}]
["アドレス帳(標準フォーマット)",9,"市区町村郡","全角文字",25,"○",null,null,null,null,{"$f":"テーブル20[[#This Row],[元の値]]","v":0},"都道府県と市区町村郡は合計で25文字以下になるように設定してください。"]
["アドレス帳(標準フォーマット)",10,"丁目番地号","全角文字",25,"-",null,null,null,null,{"$f":"テーブル20[[#This Row],[元の値]]","v":0}]
["アドレス帳(標準フォーマット)",11,"建物名・部屋番号など","全角文字",25,"-",null,null,null,null,{"$f":"テーブル20[[#This Row],[元の値]]","v":0}]
["アドレス帳(標準フォーマット)",12,"電話番号","半角数字",13,"-",null,null,null,null,{"$f":"テーブル20[[#This Row],[元の値]]","v":0},"11～13桁の間で設定してください。また「-」（ハイフン）が必ず2つ入るようにしてください。\n（例）03-3000-0000"]
["アドレス帳(標準フォーマット)",13,"メールアドレス","半角英数記号",100,"No.14のメール通知サービスに「１」を設定した場合必須",null,null,null,null,{"$f":"テーブル20[[#This Row],[元の値]]","v":0}]
["アドレス帳(標準フォーマット)",14,"メール通知サービス","半角数字",1,"○",null,null,null,null,{"$f":"テーブル20[[#This Row],[元の値]]","v":0},"利用しない場合「0」を、利用する場合は「1」を設定してください。"]
["アドレス帳(標準フォーマット)",15,"メモ","全角／半角文字",100,"-",null,null,null,null,{"$f":"テーブル20[[#This Row],[元の値]]","v":0}]
["アドレス帳(標準フォーマット)",16,"予備１","-","-","-","-","-","-","-",{"$f":"テーブル20[[#This Row],[元の値]]","v":"-"},"現在、使用されておりません。"]
["アドレス帳(標準フォーマット)",17,"予備２","-","-","-","-","-","-","-",{"$f":"テーブル20[[#This Row],[元の値]]","v":"-"},"現在、使用されておりません。"]
["アドレス帳(標準フォーマット)",18,"予備３","-","-","-","-","-","-","-",{"$f":"テーブル20[[#This Row],[元の値]]","v":"-"},"現在、使用されておりません。"]
["アドレス帳(標準フォーマット)",19,"予備４","-","-","-","-","-","-","-",{"$f":"テーブル20[[#This Row],[元の値]]","v":"-"},"現在、使用されておりません。"]
["アドレス帳(標準フォーマット)",20,"予備５","-","-","-","-","-","-","-",{"$f":"テーブル20[[#This Row],[元の値]]","v":"-"},"現在、使用されておりません。"]
["アドレス帳(ＷＥＢプリントフォーマット)",1,"アドレスグループ",null,1,"-",null,null,null,null,{"$f":"テーブル20[[#This Row],[元の値]]","v":0},"※2"]
["アドレス帳(ＷＥＢプリントフォーマット)",2,"利用区分","半角数字",1,"○",null,null,null,null,{"$f":"テーブル20[[#This Row],[元の値]]","v":0},"ご依頼主の場合は「0」、お届け先の場合は「1」を必ず設定してください。"]
["アドレス帳(ＷＥＢプリントフォーマット)",3,"姓","全角文字",25,"※1",null,null,null,null,{"$f":"テーブル20[[#This Row],[元の値]]","v":0},"姓と名は合計で25文字以下になるように設定してください。",null,"※1　姓、法人名のどちらか一方は必ず設定してください。"]
["アドレス帳(ＷＥＢプリントフォーマット)",4,"名","全角文字",25,"-",null,null,null,null,{"$f":"テーブル20[[#This Row],[元の値]]","v":0},"姓と名は合計で25文字以下になるように設定してください。"]
["アドレス帳(ＷＥＢプリントフォーマット)",5,"姓（カナ）","全角カナ",25,"-",null,null,null,null,{"$f":"テーブル20[[#This Row],[元の値]]","v":0},"姓と名は合計で25文字以下になるように設定してください。"]
["アドレス帳(ＷＥＢプリントフォーマット)",6,"名（カナ）","全角カナ",25,"-",null,null,null,null,{"$f":"テーブル20[[#This Row],[元の値]]","v":0},"姓と名は合計で25文字以下になるように設定してください。"]
["アドレス帳(ＷＥＢプリントフォーマット)",7,"法人名","全角文字",25,"※1",null,null,null,null,{"$f":"テーブル20[[#This Row],[元の値]]","v":0},"法人名と部署名は合計で30文字以下になるように設定してください。",null,"※1　姓、法人名のどちらか一方は必ず設定してください。"]
["アドレス帳(ＷＥＢプリントフォーマット)",8,"部署名","全角文字",25,"-",null,null,null,null,{"$f":"テーブル20[[#This Row],[元の値]]","v":0},"法人名と部署名は合計で30文字以下になるように設定してください。"]
["アドレス帳(ＷＥＢプリントフォーマット)",9,"法人名（カナ）",null,60,"-",null,null,null,null,{"$f":"テーブル20[[#This Row],[元の値]]","v":0},"※2",null,"※2　Webゆうパックプリントサービスでは、アドレスグループ、法人名・部署名のカナは設定できません。設定しても、反映されません。"]
["アドレス帳(ＷＥＢプリントフォーマット)",10,"部署名（カナ）",null,60,"-",null,null,null,null,{"$f":"テーブル20[[#This Row],[元の値]]","v":0},"※2",null,"※2　Webゆうパックプリントサービスでは、アドレスグループ、法人名・部署名のカナは設定できません。設定しても、反映されません。"]
["アドレス帳(ＷＥＢプリントフォーマット)",11,"敬称","全角文字",2,"-",null,null,null,null,{"$f":"テーブル20[[#This Row],[元の値]]","v":0},"「様」「殿」「御中」「行」「係」「宛」のいずれかを設定してください。\n（何も設定しない場合は「敬称なし」となります）"]
["アドレス帳(ＷＥＢプリントフォーマット)",12,"郵便番号","半角数字",7,"○",null,null,null,null,{"$f":"テーブル20[[#This Row],[元の値]]","v":0}]
["アドレス帳(ＷＥＢプリントフォーマット)",13,"都道府県","全角文字",4,"-",null,null,null,null,{"$f":"テーブル20[[#This Row],[元の値]]","v":0}]
["アドレス帳(ＷＥＢプリントフォーマット)",14,"市区町村郡","全角文字",25,"○",null,null,null,null,{"$f":"テーブル20[[#This Row],[元の値]]","v":0},"都道府県と市区町村郡は合計で25文字以下になるように設定してください。"]
["アドレス帳(ＷＥＢプリントフォーマット)",15,"丁目番地号","全角文字",25,"-",null,null,null,null,{"$f":"テーブル20[[#This Row],[元の値]]","v":0}]
["アドレス帳(ＷＥＢプリントフォーマット)",16,"建物名・部屋番号など","全角文字",25,"-",null,null,null,null,{"$f":"テーブル20[[#This Row],[元の値]]","v":0}]
["アドレス帳(ＷＥＢプリントフォーマット)",17,"電話番号","半角数字",13,"-",null,null,null,null,{"$f":"テーブル20[[#This Row],[元の値]]","v":0},"11～13桁の間で設定してください。また「-」（ハイフン）が必ず2つ入るようにしてください。\n（例）03-3000-0000"]
["アドレス帳(ＷＥＢプリントフォーマット)",18,"メールアドレス","半角英数記号",100,"No.19のメール通知サービスに「１」を設定した場合必須",null,null,null,null,{"$f":"テーブル20[[#This Row],[元の値]]","v":0}]
["アドレス帳(ＷＥＢプリントフォーマット)",19,"メール通知サービス","半角数字",1,"○",null,null,null,null,{"$f":"テーブル20[[#This Row],[元の値]]","v":0},"利用しない場合「0」を、利用する場合は「1」を設定してください。"]
["出荷予定データ(標準フォーマット)",1,"商品","半角数字",1,"○",null,null,null,null,{"$f":"テーブル20[[#This Row],[元の値]]","v":0},"ゆうパックの場合は「1」、ゆうメールの場合は「2」、ポスパケットの場合は「3」、定形郵便の場合は「4」、定形外郵便の場合は、「5」を必ず設定してください。"]
["出荷予定データ(標準フォーマット)",2,"着払/代引","半角数字",1,"※1",null,null,null,null,{"$f":"テーブル20[[#This Row],[元の値]]","v":0},"No.1の商品がゆうパック「1」の場合に設定してください。\n元払ゆうパックの場合は「0」、着払ゆうパックの場合は「1」、代金引換の場合は「2」を設定してください。\n空白の場合は、元払ゆうパック「0」を設定します。",null,"※1　説明を参照してください。"]
["出荷予定データ(標準フォーマット)",3,"ゴルフ/スキー/空港","-",1,"-","-","-","-","-",{"$f":"テーブル20[[#This Row],[元の値]]","v":"-"},"現在、使用されておりません。"]
["出荷予定データ(標準フォーマット)",4,"往復","-",1,"-","-","-","-","-",{"$f":"テーブル20[[#This Row],[元の値]]","v":"-"},"現在、使用されておりません。"]
["出荷予定データ(標準フォーマット)",5,"書留/特定記録","半角数字",1,"※1",null,null,null,null,{"$f":"テーブル20[[#This Row],[元の値]]","v":0},"No.1の商品がゆうメール「2」、定形郵便「4」、定形外郵便「5」の場合に設定してください。\nなしの場合は「0」、書留の場合は｢1」、簡易書留の場合は｢2」、特定記録の場合は｢3」を設定してください。\n空白の場合は、なし「0」を設定します。",null,"※1　説明を参照してください。"]
["出荷予定データ(標準フォーマット)",6,"配達方法","半角数字",1,"※1",null,null,null,null,{"$f":"テーブル20[[#This Row],[元の値]]","v":0},"No.1の商品がゆうメール「2」、定形郵便「4」、定形外郵便「5」の場合に設定してください。\nなしの場合は「0」、配達時間帯指定は｢1」、速達の場合は｢2」を設定してください。\n空白の場合は、なし「0」を設定します。",null,"※1　説明を参照してください。"]
["出荷予定データ(標準フォーマット)",7,"作成数","半角数字",2,"-",null,null,null,null,{"$f":"テーブル20[[#This Row],[元の値]]","v":0},"「1」～「10」の値を設定してください。\n空白の場合「1」を設定します。"]
["出荷予定データ(標準フォーマット)",8,"お届け先のお名前","全角文字",25,"※2",null,null,null,null,{"$f":"テーブル20[[#This Row],[元の値]]","v":0},null,null,"※2　お届け先のお名前、お届け先の法人名どちらか一方は必ず設定してください。"]
["出荷予定データ(標準フォーマット)",9,"お届け先の敬称","全角文字",2,"-",null,null,null,null,{"$f":"テーブル20[[#This Row],[元の値]]","v":0},"「様」「殿」「御中」「行」「係」「宛」のいずれかを設定してください。\n（何も設定しない場合は「様」となります）"]
["出荷予定データ(標準フォーマット)",10,"お届け先のお名前（カナ）","全角カナ",25,"-",null,null,null,null,{"$f":"テーブル20[[#This Row],[元の値]]","v":0}]
["出荷予定データ(標準フォーマット)",11,"お届け先の郵便番号","半角数字",7,"○",null,null,null,null,{"$f":"テーブル20[[#This Row],[元の値]]","v":0}]
["出荷予定データ(標準フォーマット)",12,"お届け先の都道府県","全角文字",5,"-",null,null,null,null,{"$f":"テーブル20[[#This Row],[元の値]]","v":0}]
["出荷予定データ(標準フォーマット)",13,"お届け先の市区町村郡","全角文字",25,"○",null,null,null,null,{"$f":"テーブル20[[#This Row],[元の値]]","v":0},"都道府県と市区町村郡は合計で25文字以下になるように設定してください。"]
["出荷予定データ(標準フォーマット)",14,"お届け先の丁目番地号","全角文字",25,"-",null,null,null,null,{"$f":"テーブル20[[#This Row],[元の値]]","v":0}]
["出荷予定データ(標準フォーマット)",15,"お届け先の建物名・部屋番号など","全角文字",25,"-",null,null,null,null,{"$f":"テーブル20[[#This Row],[元の値]]","v":0}]
["出荷予定データ(標準フォーマット)",16,"お届け先の電話番号","半角数字",13,"※1",null,null,null,null,{"$f":"テーブル20[[#This Row],[元の値]]","v":0},"11～13桁の間で設定してください。No.1の商品がゆうパック「1」かつNo.2の着払／代引が代金引換「2」の場合は必ず設定してください。（例）03-3000-0000"]
["出荷予定データ(標準フォーマット)",17,"お届け先の法人名","全角文字",25,"※2",null,null,null,null,{"$f":"テーブル20[[#This Row],[元の値]]","v":0},null,null,"※2　お届け先のお名前、お届け先の法人名どちらか一方は必ず設定してください。"]
["出荷予定データ(標準フォーマット)",18,"お届け先の部署名","全角文字",25,"-",null,null,null,null,{"$f":"テーブル20[[#This Row],[元の値]]","v":0}]
["出荷予定データ(標準フォーマット)",19,"お届け先のメールアドレス","半角文字",100,"※1",null,null,null,null,{"$f":"テーブル20[[#This Row],[元の値]]","v":0},"下記の項目に「1」を設定した場合は必ず設定してください。\nNo.68の配達予定日通知 (お届け先)、No.69の配達完了通知 (お届け先)、No.70の不在持戻り通知 (お届け先)、 No.71の郵便局留通知 (お届け先)"]
["出荷予定データ(標準フォーマット)",20,"空港略称","-",60,"-","-","-","-","-",{"$f":"テーブル20[[#This Row],[元の値]]","v":"-"},"現在、使用されておりません。"]
["出荷予定データ(標準フォーマット)",21,"空港コード","-",4,"-","-","-","-","-",{"$f":"テーブル20[[#This Row],[元の値]]","v":"-"},"現在、使用されておりません。"]
["出荷予定データ(標準フォーマット)",22,"受取人様のお名前","-",25,"-","-","-","-","-",{"$f":"テーブル20[[#This Row],[元の値]]","v":"-"},"現在、使用されておりません。"]
["出荷予定データ(標準フォーマット)",23,"ご依頼主のお名前","全角文字",25,"※3",null,null,null,null,{"$f":"テーブル20[[#This Row],[元の値]]","v":0}]
["出荷予定データ(標準フォーマット)",24,"ご依頼主の敬称","全角文字",2,"-",null,null,null,null,{"$f":"テーブル20[[#This Row],[元の値]]","v":0},"「様」「殿」「御中」「行」「係」「宛」のいずれかを設定してください。\n（何も設定しない場合は敬称を付加しません）"]
["出荷予定データ(標準フォーマット)",25,"ご依頼主のお名前（カナ）","全角文字",25,"-",null,null,null,null,{"$f":"テーブル20[[#This Row],[元の値]]","v":0}]
["出荷予定データ(標準フォーマット)",26,"ご依頼主の郵便番号","半角数字",7,"※1",null,null,null,null,{"$f":"テーブル20[[#This Row],[元の値]]","v":0},"必ず7桁で設定してください。No.1の商品がゆうパック「1」、ポスパケット「3」または、 配達時間帯指定郵便（No.1の商品が定形郵便「4」、定形外郵便「5」かつNo.6の配達方法が配達時間帯指定「1」）の場合は必ず設定してください。"]
["出荷予定データ(標準フォーマット)",27,"ご依頼主の都道府県","全角文字",5,"-",null,null,null,null,{"$f":"テーブル20[[#This Row],[元の値]]","v":0}]
["出荷予定データ(標準フォーマット)",28,"ご依頼主の市区町村郡","全角文字",25,"※1",null,null,null,null,{"$f":"テーブル20[[#This Row],[元の値]]","v":0},"No.1の商品がゆうパック「1」、ポスパケット「3」または、 配達時間帯指定郵便（No.1の商品が定形郵便「4」、定形外郵便「5」かつNo.6の配達方法が配達時間帯指定「1」）の場合は必ず設定してください。\n（都道府県と市区町村郡は合計で25文字以下になるように設定してください。）"]
["出荷予定データ(標準フォーマット)",29,"ご依頼主の丁目番地号","全角文字",25,"-",null,null,null,null,{"$f":"テーブル20[[#This Row],[元の値]]","v":0}]
["出荷予定データ(標準フォーマット)",30,"ご依頼主の建物名・部屋番号など","全角文字",25,"-",null,null,null,null,{"$f":"テーブル20[[#This Row],[元の値]]","v":0}]
["出荷予定データ(標準フォーマット)",31,"ご依頼主の電話番号","半角数字",13,"※1",null,null,null,null,{"$f":"テーブル20[[#This Row],[元の値]]","v":0},"11～13桁の間で設定してください。No.1の商品がゆうパック「1」かつNo.2の着払／代引が代金引換「2」の場合は必ず設定してください。（例）03-3000-0000"]
["出荷予定データ(標準フォーマット)",32,"ご依頼主の法人名","全角文字",25,"※3",null,null,null,null,{"$f":"テーブル20[[#This Row],[元の値]]","v":0},null,null,"※3　No.1の商品がゆうパック「1」、ポスパケット「3」または、配達時間帯指定郵便（No.1の商品が定形郵便「4」、定形外郵便「5」かつNo.6の配達方法が配達時間帯指定「1」）の場合ご依頼主のお名前、ご依頼主の法人名どちらか一方は必ず設定してください"]
["出荷予定データ(標準フォーマット)",33,"ご依頼主の部署名","全角文字",25,"-",null,null,null,null,{"$f":"テーブル20[[#This Row],[元の値]]","v":0}]
["出荷予定データ(標準フォーマット)",34,"ご依頼主のメールアドレス","半角文字",100,"※1",null,null,null,null,{"$f":"テーブル20[[#This Row],[元の値]]","v":0},"No.72の配達完了通知 (依頼主)に「1」を設定した場合は必ず設定してください。"]
["出荷予定データ(標準フォーマット)",35,"品名","全角文字",20,"※1",null,null,null,null,{"$f":"テーブル20[[#This Row],[元の値]]","v":0},"No.1の商品がゆうパック「1」、ポスパケット「3」の場合は必ず設定してください。"]
["出荷予定データ(標準フォーマット)",36,"品名番号","半角文字",20,"-",null,null,null,null,{"$f":"テーブル20[[#This Row],[元の値]]","v":0}]
["出荷予定データ(標準フォーマット)",37,"個数","半角数字",5,"-",null,null,null,null,{"$f":"テーブル20[[#This Row],[元の値]]","v":0}]
["出荷予定データ(標準フォーマット)",38,"発送予定日","日付",8,"-",null,null,null,null,{"$f":"テーブル20[[#This Row],[元の値]]","v":0},"YYYYMMDDの形式で現在より未来の日付を設定してください。"]
["出荷予定データ(標準フォーマット)",39,"発送予定時間帯","半角数字",1,"-",null,null,null,null,{"$f":"テーブル20[[#This Row],[元の値]]","v":0},"指定なしの場合は「0」、午前差出の場合は「1」、午後差出の場合は「2」を設定してください。"]
["出荷予定データ(標準フォーマット)",40,"セキュリティ","半角数字",1,"-",null,null,null,null,{"$f":"テーブル20[[#This Row],[元の値]]","v":0},"セキュリティなしの場合は「0」、セキュリティありの場合は「1」を設定してください。"]
["出荷予定データ(標準フォーマット)",41,"重量","半角数字",4,"-",null,null,null,null,{"$f":"テーブル20[[#This Row],[元の値]]","v":0},"No.1の商品がゆうメール「2」の場合、150g以内「150」、250g以内「250」、500g以内「500」、1kg以内「1000」、2kg以内「2000」、3kg以内「3000」を設定してください。 \nNo.1の商品がポスパケット「3」の場合、1kg以内「1000」を設定してください。 \nNo.1の商品が定形郵便「4」の場合、25g以内「25｣、50g以内「50」を設定してください。 \nNo.1の商品が定形外郵便「5」の場合、50g以内「50｣、100g以内「100」、150g以内「150」、250g以内「250」、500g以内「500」、1kg以内「1000」、2kg以内「2000」、4kg以内「4000」を設定してください。"]
["出荷予定データ(標準フォーマット)",42,"損害要償額","半角数字",7,"-",null,null,null,null,{"$f":"テーブル20[[#This Row],[元の値]]","v":0}]
["出荷予定データ(標準フォーマット)",43,"保冷","全角文字",1,"-",null,null,null,null,{"$f":"テーブル20[[#This Row],[元の値]]","v":0},"保冷なしの場合は「0」、チルドの場合は「1」を設定してください。"]
["出荷予定データ(標準フォーマット)",44,"取扱上の注意　こわれもの","全角文字",1,"-",null,null,null,null,{"$f":"テーブル20[[#This Row],[元の値]]","v":0},"取扱上の注意にこわれものを追加する場合は「1」を設定してください。"]
["出荷予定データ(標準フォーマット)",45,"取扱上の注意　なまもの","全角文字",1,"-",null,null,null,null,{"$f":"テーブル20[[#This Row],[元の値]]","v":0},"取扱上の注意になまものを追加する場合は「1」を設定してください。"]
["出荷予定データ(標準フォーマット)",46,"取扱上の注意　ビン類","全角文字",1,"-",null,null,null,null,{"$f":"テーブル20[[#This Row],[元の値]]","v":0},"取扱上の注意にビン類を追加する場合は「1」を設定してください。"]
["出荷予定データ(標準フォーマット)",47,"取扱上の注意　逆さま厳禁","全角文字",1,"-",null,null,null,null,{"$f":"テーブル20[[#This Row],[元の値]]","v":0},"取扱上の注意に逆さま厳禁を追加する場合は「1」を設定してください。"]
["出荷予定データ(標準フォーマット)",48,"取扱上の注意　下積み厳禁","全角文字",1,"-",null,null,null,null,{"$f":"テーブル20[[#This Row],[元の値]]","v":0},"取扱上の注意に下積み厳禁を追加する場合は「1」を設定してください。"]
["出荷予定データ(標準フォーマット)",49,"25kg超荷物","全角文字",1,"-",null,null,null,null,{"$f":"テーブル20[[#This Row],[元の値]]","v":0},"25kg以下の場合は「0」、25kg超の場合は「1」を設定してください。"]
["出荷予定データ(標準フォーマット)",50,"差出予定日","日付",8,"-",null,null,null,null,{"$f":"テーブル20[[#This Row],[元の値]]","v":0},"YYYYMMDDの形式で現在日付から100日以内の日付を設定してください。"]
["出荷予定データ(標準フォーマット)",51,"差出予定時間帯","全角文字",1,"-",null,null,null,null,{"$f":"テーブル20[[#This Row],[元の値]]","v":0},"指定なしの場合は「0」、午前差出の場合は「1」、午後差出の場合は 「2」を設定してください。"]
["出荷予定データ(標準フォーマット)",52,"配達希望日","日付",8,"※1",null,null,null,null,{"$f":"テーブル20[[#This Row],[元の値]]","v":0},"YYYYMMDDの形式で差出予定日（発送予定日）より14日以内の日付を設定してください。商品が配達時間帯指定郵便（No.1の商品が定形郵便「4」、定形外郵便「5」かつNo.6の配達方法が配達時間帯指定「1」）の場合は必ず設定してください。"]
["出荷予定データ(標準フォーマット)",53,"配達希望時間帯","半角数字",2,"※1",null,null,null,null,{"$f":"テーブル20[[#This Row],[元の値]]","v":0},"No.1の商品がゆうパック「1」の場合、午前「51｣、12～14時「52」、14～16時「53」、16～18時「54」、18～20時「55」20～21時「56」、希望なし「00」を設定してください。 　\nNo.6の配達方法が配達時間帯指定「1」の場合、8～12時「61｣、12～17時「62」、17～21時「63」を設定してください。商品が配達時間帯指定郵便（No.1の商品が定形郵便「4」、定形外郵便「5」かつNo.6の配達方法が配達時間帯指定「1」）の場合は必ず設定してください。　　　　　　　　　　　　　　　　　　　　　　　　　　　　　"]
["出荷予定データ(標準フォーマット)",54,"クラブ本数","-",2,"-","-","-","-","-",{"$f":"テーブル20[[#This Row],[元の値]]","v":"-"},"現在、使用されておりません。"]
["出荷予定データ(標準フォーマット)",55,"ご使用日(プレー日)","-",8,"-","-","-","-","-",{"$f":"テーブル20[[#This Row],[元の値]]","v":"-"},"現在、使用されておりません。"]
["出荷予定データ(標準フォーマット)",56,"ご使用時間","-",2,"-","-","-","-","-",{"$f":"テーブル20[[#This Row],[元の値]]","v":"-"},"現在、使用されておりません。"]
["出荷予定データ(標準フォーマット)",57,"搭乗日","-",8,"-","-","-","-","-",{"$f":"テーブル20[[#This Row],[元の値]]","v":"-"},"現在、使用されておりません。"]
["出荷予定データ(標準フォーマット)",58,"搭乗時間","-",2,"-","-","-","-","-",{"$f":"テーブル20[[#This Row],[元の値]]","v":"-"},"現在、使用されておりません。"]
["出荷予定データ(標準フォーマット)",59,"搭乗便名","-",20,"-","-","-","-","-",{"$f":"テーブル20[[#This Row],[元の値]]","v":"-"},"現在、使用されておりません。"]
["出荷予定データ(標準フォーマット)",60,"復路発送予定日","-",8,"-","-","-","-","-",{"$f":"テーブル20[[#This Row],[元の値]]","v":"-"},"現在、使用されておりません。"]
["出荷予定データ(標準フォーマット)",61,"お支払方法","半角数字",1,"-",null,null,null,null,{"$f":"テーブル20[[#This Row],[元の値]]","v":0},"通常払い(料金別納)の場合は「0」、月締め払い(料金後納)の場合は「1」、切手を荷物に貼付するの場合は「2」を設定してください。"]
["出荷予定データ(標準フォーマット)",62,"摘要/記事","全角文字",25,"-",null,null,null,null,{"$f":"テーブル20[[#This Row],[元の値]]","v":0}]
["出荷予定データ(標準フォーマット)",63,"サイズ","半角数字",3,"-",null,null,null,null,{"$f":"テーブル20[[#This Row],[元の値]]","v":0},"商品がゆうパックの場合、60サイズ「060」、80サイズ「080」、100サイズ「100」、120サイズ「120」、140サイズ「140」、160サイズ「160」、170サイズ「170｣を設定してください。"]
["出荷予定データ(標準フォーマット)",64,"差出方法","半角数字",1,"-",null,null,null,null,{"$f":"テーブル20[[#This Row],[元の値]]","v":0},"持込の場合は「1」、集荷の場合は「0」を設定してください。"]
["出荷予定データ(標準フォーマット)",65,"割引","半角数字",1,"-",null,null,null,null,{"$f":"テーブル20[[#This Row],[元の値]]","v":0},"利用しないの場合は「0」、同一あて先割引の場合は「1」、複数口割引の場合は「2」を設定してください。"]
["出荷予定データ(標準フォーマット)",66,"代金引換金額","半角数字",7,"※1",null,null,null,null,{"$f":"テーブル20[[#This Row],[元の値]]","v":0},"No.1の商品がゆうパック「1」かつNo.2の着払／代引が代金引換「2」の場合は必ず設定してください"]
["出荷予定データ(標準フォーマット)",67,"うち消費税等","半角数字",6,"-",null,null,null,null,{"$f":"テーブル20[[#This Row],[元の値]]","v":0}]
["出荷予定データ(標準フォーマット)",68,"配達予定日通知 (お届け先)","半角数字",1,"-",null,null,null,null,{"$f":"テーブル20[[#This Row],[元の値]]","v":0},"利用しないの場合は「0」、利用するの場合は「1」を設定してください。"]
["出荷予定データ(標準フォーマット)",69,"配達完了通知 (お届け先)","半角数字",1,"-",null,null,null,null,{"$f":"テーブル20[[#This Row],[元の値]]","v":0},"利用しないの場合は「0」、利用するの場合は「1」を設定してください。"]
["出荷予定データ(標準フォーマット)",70,"不在持戻り通知 (お届け先)","半角数字",1,"-",null,null,null,null,{"$f":"テーブル20[[#This Row],[元の値]]","v":0},"利用しないの場合は「0」、利用するの場合は「1」を設定してください。"]
["出荷予定データ(標準フォーマット)",71,"郵便局留通知 (お届け先)","半角数字",1,"-",null,null,null,null,{"$f":"テーブル20[[#This Row],[元の値]]","v":0},"利用しないの場合は「0」、利用するの場合は「1」を設定してください。"]
["出荷予定データ(標準フォーマット)",72,"配達完了通知 (依頼主)","半角数字",1,"-",null,null,null,null,{"$f":"テーブル20[[#This Row],[元の値]]","v":0},"利用しないの場合は「0」、利用するの場合は「1」を設定してください。"]
["品名データ(標準フォーマット)",1,"品名","全角文字",20,"○",null,null,null,null,{"$f":"テーブル20[[#This Row],[元の値]]","v":0}]
["品名データ(標準フォーマット)",2,"品名（カナ）","全角カナ",20,"○",null,null,null,null,{"$f":"テーブル20[[#This Row],[元の値]]","v":0}]
["品名データ(標準フォーマット)",3,"品名番号","半角文字",20,"-",null,null,null,null,{"$f":"テーブル20[[#This Row],[元の値]]","v":0}]
["品名データ(標準フォーマット)",4,"サイズ","半角数字",3,"-",null,null,null,null,{"$f":"テーブル20[[#This Row],[元の値]]","v":0},"60サイズ「060」、80サイズ「080」、100サイズ「100」、120サイズ「120」、140サイズ「140」、160サイズ「160」、170サイズ「170｣を設定してください。"]
["品名データ(標準フォーマット)",5,"25kg超荷物","半角数字",1,"-",null,null,null,null,{"$f":"テーブル20[[#This Row],[元の値]]","v":0},"25kg以下の場合は「0」、25kg超の場合は「1」を設定してください。"]
["品名データ(標準フォーマット)",6,"数量","半角数字",5,"-",null,null,null,null,{"$f":"テーブル20[[#This Row],[元の値]]","v":0}]
["品名データ(標準フォーマット)",7,"保冷","半角数字",1,"-",null,null,null,null,{"$f":"テーブル20[[#This Row],[元の値]]","v":0},"保冷なしの場合は「0」、チルドの場合は「1」を設定してください。"]
["品名データ(標準フォーマット)",8,"取扱上の注意　こわれもの","半角数字",1,"-",null,null,null,null,{"$f":"テーブル20[[#This Row],[元の値]]","v":0},"取扱上の注意にこわれものを追加する場合は「1」を設定してください。"]
["品名データ(標準フォーマット)",9,"取扱上の注意　なまもの","半角数字",1,"-",null,null,null,null,{"$f":"テーブル20[[#This Row],[元の値]]","v":0},"取扱上の注意になまものを追加する場合は「1」を設定してください。"]
["品名データ(標準フォーマット)",10,"取扱上の注意　ビン類","半角数字",1,"-",null,null,null,null,{"$f":"テーブル20[[#This Row],[元の値]]","v":0},"取扱上の注意にビン類を追加する場合は「1」を設定してください。"]
["品名データ(標準フォーマット)",11,"取扱上の注意　逆さま厳禁","半角数字",1,"-",null,null,null,null,{"$f":"テーブル20[[#This Row],[元の値]]","v":0},"取扱上の注意に逆さま厳禁を追加する場合は「1」を設定してください。"]
["品名データ(標準フォーマット)",12,"取扱上の注意　下積み厳禁","半角数字",1,"-",null,null,null,null,{"$f":"テーブル20[[#This Row],[元の値]]","v":0},"取扱上の注意に下積み厳禁を追加する場合は「1」を設定してください。"]
["品名データ(標準フォーマット)",13,"備考","全角／半角文字",100,"-",null,null,null,null,{"$f":"テーブル20[[#This Row],[元の値]]","v":0}]
["品名データ(標準フォーマット)",14,"予備１","-",50,"-","-","-","-","-",{"$f":"テーブル20[[#This Row],[元の値]]","v":"-"},"現在、使用されておりません。"]
["品名データ(標準フォーマット)",15,"予備２","-",50,"-","-","-","-","-",{"$f":"テーブル20[[#This Row],[元の値]]","v":"-"},"現在、使用されておりません。"]

{"sheet":"ヤマトB2エクスポート","index":20,"n_rows":305,"n_cols":8,"rows_kept":305,"cut":false,"hidden":true,"merged":[]}
["列1","No.","項目名称","文字形式","最大入出力文字数","宅急便\n必須項目","DM便\n必須項目","備考"]
["送り状発行データ",1,"お客様管理番号","半角英数字","50文字"]
[null,2,"送り状種別","半角数字","1文字","○","○","0 : 発払\n2 : コレクト\n3 : DM便\n4 : タイム\n5 : 着払\n7 : ネコポス\n 8 : 宅急便コンパクト\n 9 : 宅急便コンパクトコレクト"]
[null,3,"クール区分","半角数字＆空白","1文字","（○）",null,"0または空白 : 通常\n1 : クール冷凍\n2 : クール冷蔵\n※発払・コレクト・着払のみ指定可能"]
[null,4,"伝票番号","半角数字","12文字",null,null,"データ入力用は空白を指定"]
[null,null,null,null,null,null,null,"（データ出力用の項目として使用）"]
[]
[null,null,null,null,null,null,null,"※ただし、データ入力時に使用する場合有り"]
[null,null,null,null,null,null,null,"（伝票番号を指定して取込む場合のみ）"]
[null,5,"出荷予定日","半角数字","10文字","○","○","YYYY/MM/DD形式"]
[null,6,"お届け予定","半角数字","10文字",null,null,"YYYY/MM/DD形式"]
[null,null,"（指定）日"]
[null,null,null,null,null,null,null,"※入力なしの場合、印字されません"]
[null,7,"配達時間帯","半角数字＆空白","4文字",null,null,"【発払・コレクト・着払】\n空白 : 指定なし\n0812 : 午前中\n1214 : 12～14時\n1416 : 14～16時\n1618 : 16～18時\n1820 : 18～20時\n2021 : 20～21時\n\n【タイム】\n0010 : 午前10時まで\n0017 : 午後5時まで"]
[null,8,"お届け先コード","半角","20文字"]
[null,null,null,"英数字"]
[null,9,"お届け先","半角数字＆ハイフン","15文字","○","○","ハイフン含む"]
[null,null,"電話番号"]
[null,10,"お届け先","半角数字","2文字"]
[null,null,"電話番号枝番"]
[null,11,"お届け先郵便番号","半角数字＆ハイフン","8文字","○","○","ハイフンなし半角7文字も可"]
[null,12,"お届け先住所","全角/","32文字","○","○"]
[null,null,null,"半角","/64文字"]
[null,null,null,"都道府県（4文字）"]
[null,null,null,"＋市区郡町村（12文字）"]
[null,null,null,"＋町・番地（16文字）"]
[null,13,"お届け先住所","全角/","16文字"]
[null,null,"（アパート","半角","/32文字"]
[null,null,"マンション名）"]
[null,14,"お届け先","全角/","25文字"]
[null,null,"会社・部門名1","半角","/50文字"]
[null,15,"お届け先","全角/","25文字"]
[null,null,"会社・部門名2","半角","/50文字"]
[null,16,"お届け先名","全角/","16文字","○","○"]
[null,null,null,"半角","/32文字"]
[null,17,"お届け先名略称カナ","半角","50文字"]
[null,null,null,"カタカナ"]
[null,18,"敬称","全角/","2文字",null,null,"DM便のみ指定可能"]
[null,null,null,"半角","/4文字",null,null,"【入力例】"]
[null,null,null,null,null,null,null,"様・御中・殿・行・係・宛・先生・なし"]
[null,19,"ご依頼主コード","半角","20文字"]
[null,null,null,"英数字"]
[null,20,"ご依頼主電話番号","半角数字＆ハイフン","15文字","○",null,"ハイフン含む"]
[null,21,"ご依頼主","半角数字","2文字"]
[null,null,"電話番号枝番"]
[null,22,"ご依頼主郵便番号","半角数字＆ハイフン","8文字","○",null,"ハイフンなし半角7文字も可"]
[null,23,"ご依頼主住所","全角/","32文字","○"]
[null,null,null,"半角","/64文字"]
[null,null,null,"都道府県（4文字）"]
[null,null,null,"＋市区郡町村（12文字）"]
[null,null,null,"＋町・番地（16文字）"]
[null,24,"ご依頼主住所","全角/","16文字"]
[null,null,"（アパート","半角","/32文字"]
[null,null,"マンション名）"]
[null,25,"ご依頼主名","全角/","16文字","○"]
[null,null,null,"半角","/32文字"]
[null,26,"ご依頼主略称カナ","半角","50文字"]
[null,null,null,"カタカナ"]
[null,27,"品名コード1","半角","30文字"]
[null,null,null,"英数字"]
[null,28,"品名1","全角/","25文字","○"]
[null,null,null,"半角","/50文字"]
[null,29,"品名コード2","半角","30文字"]
[null,null,null,"英数字"]
[null,30,"品名2","全角/","25文字"]
[null,null,null,"半角","/50文字"]
[null,31,"荷扱い1","全角/","10文字"]
[null,null,null,"半角","/20文字"]
[null,32,"荷扱い2","全角/","10文字"]
[null,null,null,"半角","/20文字"]
[null,33,"記事","全角/","16文字"]
[null,null,null,"半角","/32文字"]
[null,34,"コレクト代金引換額","半角数字","7文字","（○）",null,"送り状種別がコレクトの場合は必須"]
[null,null,"（税込）",null,null,null,null,"300,000円以下"]
[null,35,"コレクト内消費税額等","半角数字","7文字","（○）",null,"送り状種別がコレクトの場合は必須"]
[null,36,"営業所止置き","半角数字","1文字",null,null,"0 : 利用しない"]
[null,null,null,null,null,null,null,"1 : 利用する"]
[null,37,"営業所コード","半角数字","6文字","（○）",null,"止置きを利用する場合は必須"]
[null,38,"発行枚数","半角数字","2文字",null,null,"通常は「1」、発払・タイム・着払、ネコポスのみ「2」～「99」の指定可能"]
[null,39,"個数口枠の印字","半角数字","1文字",null,null,"1 : 印字する"]
[null,null,null,null,null,null,null,"2 : 印字しない"]
[null,40,"ご請求先顧客コード","半角数字","12文字","○",null,"※DM便、メール便速達、着払いの場合、非入力項目"]
[null,41,"ご請求先分類コード","半角数字","3文字",null,null,"※DM便、メール便速達、着払いの場合、非入力項目"]
[null,42,"運賃管理番号","半角数字","2文字","○",null,"※DM便、メール便速達、着払いの場合、非入力項目"]
[null,43,"注文時カード払い","半角数字","1文字",null,null,"0 : 無し"]
[null,null,"データ登録",null,null,null,null,"1 : 有り"]
[null,44,"注文時カード払い","半角","9文字"]
[null,null,"加盟店番号","英数字"]
[null,45,"注文時カード払い","半角","23文字","（○）",null,"注文時カード払いデータ有りの場合は必須"]
[null,null,"申込受付番号1","英数字"]
[null,46,"注文時カード払い","半角","23文字"]
[null,null,"申込受付番号2","英数字"]
[null,47,"注文時カード払い","半角","23文字"]
[null,null,"申込受付番号3","英数字"]
[null,48,"お届け予定ｅメール","半角数字","1文字",null,null,"0 : 利用しない"]
[null,null,"利用区分",null,null,null,null,"1 : 利用する"]
[null,49,"お届け予定ｅメール","半角","60文字","（○）",null,"お届け予定eメールを利用する場合は必須"]
[null,null,"e-mailアドレス","英数字＆記号"]
[null,50,"入力機種","半角数字","1文字",null,null,"1 : PC"]
[null,null,null,null,null,null,null,"2 : 携帯電話"]
[null,51,"お届け予定eメール","全角/","74文字/148文字",null,null,"半角カタカナ及び半角スペースは使用不可"]
[null,null,"メッセージ","半角"]
[null,52,"お届け完了ｅメール","半角数字","1文字",null,null,"0 : 利用しない"]
[null,null,"利用区分",null,null,null,null,"1 : 利用する"]
[null,53,"お届け完了ｅメール","半角","60文字","（○）",null,"お届け完了eメールを利用する場合は必須"]
[null,null,"e-mailアドレス","英数字"]
[null,54,"お届け完了eメール","全角/","159文字/318文字"]
[null,null,"メッセージ","半角"]
[null,55,"クロネコ収納代行","半角数字","1文字",null,null,"0 : 無し"]
[null,null,"利用区分",null,null,null,null,"1 : 有り"]
[null,56,"予備","半角数字","1文字"]
[null,57,"収納代行請求金額","半角数字","7文字","（○）",null,"収納代行を利用する場合は必須"]
[null,null,"(税込)",null,null,null,null,"300,000円以下"]
[null,58,"収納代行内","半角数字","7文字","（○）",null,"収納代行を利用する場合は必須"]
[null,null,"消費税額等"]
[null,59,"収納代行","半角数字＆ハイフン","8文字","（○）",null,"収納代行を利用する場合は必須"]
[null,null,"請求先郵便番号",null,null,null,null,"ハイフンなし半角7文字も可"]
[null,60,"収納代行","全角/","32文字","（○）"]
[null,null,"請求先住所","半角","/64文字"]
[null,null,null,"都道府県（4文字）"]
[null,null,null,"＋市区郡町村（12文字）"]
[null,null,null,"＋町・番地（16文字）"]
[null,61,"収納代行","全角/","16文字"]
[null,null,"請求先住所","半角","/32文字"]
[null,null,"（アパートマンション名）"]
[null,62,"収納代行請求先","全角/","25文字"]
[null,null,"会社・部門名1","半角","/50文字"]
[null,63,"収納代行請求先","全角/","25文字"]
[null,null,"会社・部門名2","半角","/50文字"]
[null,64,"収納代行","全角/","16文字","（○）",null,"収納代行を利用する場合は必須"]
[null,null,"請求先名（漢字）","半角","/32文字"]
[null,65,"収納代行","半角","50文字","（○）",null,"収納代行を利用する場合は必須"]
[null,null,"請求先名（カナ）","カタカナ"]
[null,66,"収納代行","全角/","16文字","（○）",null,"収納代行を利用する場合は必須"]
[null,null,"問合せ先名（漢字）","半角","/32文字"]
[null,67,"収納代行","半角数字＆ハイフン","8文字","（○）",null,"収納代行を利用する場合は必須"]
[null,null,"問合せ先",null,null,null,null,"ハイフンなし半角7文字も可"]
[null,null,"郵便番号"]
[null,68,"収納代行","全角/","32文字","（○）"]
[null,null,"問合せ先住所","半角","/64文字"]
[null,null,null,"都道府県（4文字）"]
[null,null,null,"＋市区郡町村（12文字）"]
[null,null,null,"＋町・番地（16文字）"]
[null,69,"収納代行","全角/","16文字"]
[null,null,"問合せ先住所","半角","/32文字"]
[null,null,"（アパート"]
[null,null,"マンション名）"]
[null,70,"収納代行","半角数字＆ハイフン","15文字","（○）",null,"収納代行を利用する場合は必須"]
[null,null,"問合せ先電話番号",null,null,null,null,"ハイフン含む"]
[null,71,"収納代行","半角","20文字"]
[null,null,"管理番号","英数字"]
[null,72,"収納代行品名","全角/","25文字"]
[null,null,null,"半角","/50文字"]
[null,73,"収納代行備考","全角/","14文字"]
[null,null,null,"半角","/28文字"]
[null,74,"予備","全角/","10文字/20文字"]
[null,null,null,"半角"]
[null,75,"予備","全角/","10文字/20文字"]
[null,null,null,"半角"]
[null,76,"予備","半角","20文字"]
[null,null,null,"英数字"]
[null,77,"予備","全角/","10文字/20文字"]
[null,null,null,"半角"]
[null,78,"予備","半角","20文字"]
[null,null,null,"英数字"]
[null,79,"予備","全角/","10文字/20文字"]
[null,null,null,"半角"]
[null,80,"予備","半角","20文字"]
[null,null,null,"英数字"]
[null,81,"予備","全角/","10文字/20文字"]
[null,null,null,"半角"]
[null,82,"予備","半角","20文字"]
[null,null,null,"英数字"]
[null,83,"予備","全角/","10文字/20文字"]
[null,null,null,"半角"]
[null,84,"予備","半角","20文字"]
[null,null,null,"英数字"]
[null,85,"予備","半角数字","12文字"]
[null,86,"予備","半角数字","3文字"]
[null,87,"投函予定メール","半角数字","1文字",null,null,"0 : 利用しない"]
[null,null,"利用区分",null,null,null,null,"1 : 利用する PC宛て"]
[null,null,null,null,null,null,null,"2 : 利用する モバイル宛て"]
[null,88,"投函予定メール","半角","60文字","（○）",null,"お届け予定eメールを利用する場合は必須"]
[null,null,"e-mailアドレス","英数字＆記号"]
[null,89,"投函予定メール","全角/","74文字/148文字",null,null,"半角カタカナ及び半角スペースは使えません"]
[null,null,"メッセージ","半角"]
[null,90,"投函完了メール","半角数字","1文字",null,null,"0 : 利用しない"]
[null,null,"（受人宛て）利用区分",null,null,null,null,"1 : 利用する PC宛て"]
[null,null,null,null,null,null,null,"2 : 利用する モバイル宛て"]
[null,91,"投函完了メール","半角","60文字","（○）",null,"投函完了eメール（受人）を利用する場合は必須"]
[null,null,"（受人）","英数字"]
[null,null,"e-mailアドレス"]
[null,92,"投函完了メール","全角/","159文字/318文字"]
[null,null,"（受人）","半角"]
[null,null,"メールメッセージ"]
[null,93,"投函完了メール","半角数字","1文字",null,null,"0 : 利用しない"]
[null,null,"（出人宛て）利用区分",null,null,null,null,"1 : 利用する PC宛て"]
[null,null,null,null,null,null,null,"2 : 利用する モバイル宛て"]
[null,94,"投函完了メール","半角","60文字","（○）",null,"投函完了eメール（出人）を利用する場合は必須"]
[null,null,"（出人）","英数字"]
[null,null,"e-mailアドレス"]
[null,95,"投函完了メール","全角/","159文字/318文字"]
[null,null,"（出人）","半角"]
[null,null,"メールメッセージ"]
[]
["お届け先データ",1,"お届け先コード","20文字"," "," "]
[null,2,"お届け先電話番号"]
[null,"＆"]
[null,"ハイフン","15文字","ハイフン含む"]
[null,3,"お届け先"]
[null,"電話番号枝番","半角数字"," "," "]
[null,4,"お届け先郵便番号"]
[null,"＆"]
[null,"ハイフン","8文字","ハイフンなし半角7文字も可"]
[null,5,"お届け先住所"]
[null,"都道府県"]
[null,"（4文字）"]
[null,"＋"]
[null,"市区郡町村"]
[null,"（12文字）"]
[null,"＋"]
[null,"町・番地"]
[null,"（１6文字）","32文字"]
[null,"/64文字","○"]
[null,6,"お届け先住所"]
[null,"（アパートマンション名）","全角/半角"]
[null,"/32文字"," "]
[null,7,"お届け先"]
[null,"会社・部門名1","全角/半角"]
[null,"/50文字"," "]
[null,8,"お届け先"]
[null,"会社・部門名2","全角/半角"]
[null,"/50文字"," "]
[null,9,"お届け先名","16文字"]
[null,"/32文字","○"]
[null,10,"お届け先名略称カナ","50文字"," "," "]
[null,11,"敬称","2文字"]
[null,"/4文字"," "]
[null,"【入力例】"]
[null,"様・御中・殿・行・係・宛先・先生"]
[null,12,"ご依頼主コード","20文字"," "," "]
[null,13,"ご依頼主電話番号"]
[null,"＆"]
[null,"ハイフン","15文字"," "]
[null,14,"ご依頼主"]
[null,"電話番号枝番","半角数字"," "," "]
[null,15,"荷扱い1","10文字"]
[null,"/20文字"," "]
[null,16,"荷扱い2","10文字"]
[null,"/20文字"," "]
[null,17,"記事","16文字"]
[null,"/32文字"," "]
[null,18,"品名コード1","30文字"," "," "]
[null,19,"品名1","25文字"]
[null,"/50文字"," "]
[null,20,"品名コード2","30文字"," "," "]
[null,21,"品名2","25文字"]
[null,"/50文字"," "]
[null,22,"配達時間帯"]
[null,"＆"]
[null,"空白","4文字"]
[null,"【発払・コレクト・着払】"]
[null,"空白 : 指定なし"]
[null,"0812 : 午前中"]
[null,"1214 : 12～14時"]
[null,"1416 : 14～16時"]
[null,"1618 : 16～18時"]
[null,"1820 : 18～20時"]
[null,"2021 : 20～21時"]
[]
[null,"【タイム】"]
[null,"0010 : 午前10時まで"]
[null,"0017 : 午後5時まで"]
[]
[null,23,"お届け予定ｅメール"]
[null,"利用区分","半角数字"," ","0 : 利用しない"]
[null,"1 : 利用する"]
[null,24,"お届け予定ｅメール"]
[null,"e-mailアドレス","半角英数字"]
[null,"＆"]
[null,"記号","60文字","お届け予定eメールを利用する場合は必須"]
[null,25,"入力機種","1文字"," ","1 : PC"]
[null,"2 : 携帯電話"]
[null,26,"お届け完了ｅメール"]
[null,"利用区分","半角数字"," ","0 : 利用しない"]
[null,"1 : 利用する"]
[null,27,"お届け完了ｅメール"]
[null,"e-mailアドレス","半角英数字","（○）","お届け完了eメールを利用する場合は必須"]
[]
["ご依頼主データ",1,"ご依頼主コード","半角英数字","20文字"]
["ご依頼主データ",2,"ご依頼主電話番号","半角英数字&ハイフン","15文字","○",null,"ハイフン含む"]
["ご依頼主データ",3,"ご依頼主電話番号枝番","半角英数字","2文字"]
["ご依頼主データ",4,"ご依頼主郵便番号","半角英数字&ハイフン","8文字","○",null,"ハイフンなし半角7文字も可"]
["ご依頼主データ",5,"ご依頼主住所","全角/半角\n都道府県（４文字）\n＋市区郡町村（１２文字）\n＋町・番地（１６文字）","32文字/64文字","○"]
["ご依頼主データ",6,"ご依頼主住所（アパートマンション名）","全角/半角 ","16文字/32文字"]
["ご依頼主データ",7,"ご依頼主名","全角/半角 ","16文字/32文字","○"]
["ご依頼主データ",8,"ご依頼主名略称カナ","半角カタカナ","50文字"]
["ご依頼主データ",9,"ご請求先顧客コード","半角数字 ","12文字"]
["ご依頼主データ",10,"ご請求先分類コード","半角数字 ","3文字"]
["ご依頼主データ",11,"運賃管理番号","半角数字 ","2文字"]
["品名データ",1,"品名コード１","30文字",null,"○"]
["品名データ",2,"品名１","25文字/50文字",null,"○"]
["品名データ",3,"荷扱い１","10文字/20文字"]
["品名データ",4,"荷扱い２","10文字/20文字"]
["品名データ",5,"記事","22文字/44文字"]

{"sheet":"発注一覧","index":21,"n_rows":23,"n_cols":18,"rows_kept":23,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,"　　　発注一覧"]
[]
[null,null,"対象期間",null,"～"]
[null,null,"状態"]
[null,null,"店舗"]
[null,null,"顧客名"]
[null,null,"伝票No"]
[]
[]
[]
[]
[null,null,"伝票番号","商品コード","商品名","出品価格","出品ポイント","手数料","重量[g]","高さ[cm]","長さ[cm]","幅[cm]","サイズ[cm^3]","購入日","購入個数","購入価格[$]","送料","希望販売価格"]
[null,null,{"$f":"商品分析!W3","v":0},{"$f":"商品分析!B3","v":"0"},{"$f":"商品分析!D3","v":0},{"$f":"商品分析!F3","v":0},{"$f":"IF(商品分析!X3<>\"\",0,商品分析!G3)","v":0},{"$f":"商品分析!H3","v":0},{"$f":"商品分析!J3","v":0},{"$f":"商品分析!K3","v":0},{"$f":"商品分析!L3","v":0},{"$f":"商品分析!M3","v":0},{"$f":"商品分析!N3","v":0},{"$f":"IF(商品分析!S3<>\"\",商品分析!S3,\"\")","v":""},{"$f":"IF(商品分析!T3<>\"\",商品分析!T3,\"\")","v":""},{"$f":"IF(商品分析!U3<>\"\",商品分析!U3,\"\")","v":""},{"$f":"IF(商品分析!V3<>\"\",商品分析!V3,\"\")","v":""},{"$f":"IF(商品分析!X3<>\"\",商品分析!X3,\"\")","v":""}]
[null,null,{"$f":"商品分析!W4","v":0},{"$f":"商品分析!B4","v":"0"},{"$f":"商品分析!D4","v":0},{"$f":"商品分析!F4","v":0},{"$f":"IF(商品分析!X4<>\"\",0,商品分析!G4)","v":0},{"$f":"商品分析!H4","v":0},{"$f":"商品分析!J4","v":0},{"$f":"商品分析!K4","v":0},{"$f":"商品分析!L4","v":0},{"$f":"商品分析!M4","v":0},{"$f":"商品分析!N4","v":0},{"$f":"IF(商品分析!S4<>\"\",商品分析!S4,\"\")","v":""},{"$f":"IF(商品分析!T4<>\"\",商品分析!T4,\"\")","v":""},{"$f":"IF(商品分析!U4<>\"\",商品分析!U4,\"\")","v":""},{"$f":"IF(商品分析!V4<>\"\",商品分析!V4,\"\")","v":""},{"$f":"IF(商品分析!X4<>\"\",商品分析!X4,\"\")","v":""}]
[null,null,{"$f":"商品分析!W5","v":0},{"$f":"商品分析!B5","v":"0"},{"$f":"商品分析!D5","v":0},{"$f":"商品分析!F5","v":0},{"$f":"IF(商品分析!X5<>\"\",0,商品分析!G5)","v":0},{"$f":"商品分析!H5","v":0},{"$f":"商品分析!J5","v":0},{"$f":"商品分析!K5","v":0},{"$f":"商品分析!L5","v":0},{"$f":"商品分析!M5","v":0},{"$f":"商品分析!N5","v":0},{"$f":"IF(商品分析!S5<>\"\",商品分析!S5,\"\")","v":""},{"$f":"IF(商品分析!T5<>\"\",商品分析!T5,\"\")","v":""},{"$f":"IF(商品分析!U5<>\"\",商品分析!U5,\"\")","v":""},{"$f":"IF(商品分析!V5<>\"\",商品分析!V5,\"\")","v":""},{"$f":"IF(商品分析!X5<>\"\",商品分析!X5,\"\")","v":""}]
[null,null,{"$f":"商品分析!W6","v":0},{"$f":"商品分析!B6","v":"0"},{"$f":"商品分析!D6","v":0},{"$f":"商品分析!F6","v":0},{"$f":"IF(商品分析!X6<>\"\",0,商品分析!G6)","v":0},{"$f":"商品分析!H6","v":0},{"$f":"商品分析!J6","v":0},{"$f":"商品分析!K6","v":0},{"$f":"商品分析!L6","v":0},{"$f":"商品分析!M6","v":0},{"$f":"商品分析!N6","v":0},{"$f":"IF(商品分析!S6<>\"\",商品分析!S6,\"\")","v":""},{"$f":"IF(商品分析!T6<>\"\",商品分析!T6,\"\")","v":""},{"$f":"IF(商品分析!U6<>\"\",商品分析!U6,\"\")","v":""},{"$f":"IF(商品分析!V6<>\"\",商品分析!V6,\"\")","v":""},{"$f":"IF(商品分析!X6<>\"\",商品分析!X6,\"\")","v":""}]
[null,null,{"$f":"商品分析!W7","v":0},{"$f":"商品分析!B7","v":"0"},{"$f":"商品分析!D7","v":0},{"$f":"商品分析!F7","v":0},{"$f":"IF(商品分析!X7<>\"\",0,商品分析!G7)","v":0},{"$f":"商品分析!H7","v":0},{"$f":"商品分析!J7","v":0},{"$f":"商品分析!K7","v":0},{"$f":"商品分析!L7","v":0},{"$f":"商品分析!M7","v":0},{"$f":"商品分析!N7","v":0},{"$f":"IF(商品分析!S7<>\"\",商品分析!S7,\"\")","v":""},{"$f":"IF(商品分析!T7<>\"\",商品分析!T7,\"\")","v":""},{"$f":"IF(商品分析!U7<>\"\",商品分析!U7,\"\")","v":""},{"$f":"IF(商品分析!V7<>\"\",商品分析!V7,\"\")","v":""},{"$f":"IF(商品分析!X7<>\"\",商品分析!X7,\"\")","v":""}]
[null,null,{"$f":"商品分析!W8","v":0},{"$f":"商品分析!B8","v":"0"},{"$f":"商品分析!D8","v":0},{"$f":"商品分析!F8","v":0},{"$f":"IF(商品分析!X8<>\"\",0,商品分析!G8)","v":0},{"$f":"商品分析!H8","v":0},{"$f":"商品分析!J8","v":0},{"$f":"商品分析!K8","v":0},{"$f":"商品分析!L8","v":0},{"$f":"商品分析!M8","v":0},{"$f":"商品分析!N8","v":0},{"$f":"IF(商品分析!S8<>\"\",商品分析!S8,\"\")","v":""},{"$f":"IF(商品分析!T8<>\"\",商品分析!T8,\"\")","v":""},{"$f":"IF(商品分析!U8<>\"\",商品分析!U8,\"\")","v":""},{"$f":"IF(商品分析!V8<>\"\",商品分析!V8,\"\")","v":""},{"$f":"IF(商品分析!X8<>\"\",商品分析!X8,\"\")","v":""}]
[null,null,{"$f":"商品分析!W9","v":0},{"$f":"商品分析!B9","v":"0"},{"$f":"商品分析!D9","v":0},{"$f":"商品分析!F9","v":0},{"$f":"IF(商品分析!X9<>\"\",0,商品分析!G9)","v":0},{"$f":"商品分析!H9","v":0},{"$f":"商品分析!J9","v":0},{"$f":"商品分析!K9","v":0},{"$f":"商品分析!L9","v":0},{"$f":"商品分析!M9","v":0},{"$f":"商品分析!N9","v":0},{"$f":"IF(商品分析!S9<>\"\",商品分析!S9,\"\")","v":""},{"$f":"IF(商品分析!T9<>\"\",商品分析!T9,\"\")","v":""},{"$f":"IF(商品分析!U9<>\"\",商品分析!U9,\"\")","v":""},{"$f":"IF(商品分析!V9<>\"\",商品分析!V9,\"\")","v":""},{"$f":"IF(商品分析!X9<>\"\",商品分析!X9,\"\")","v":""}]
[null,null,{"$f":"商品分析!W10","v":0},{"$f":"商品分析!B10","v":"0"},{"$f":"商品分析!D10","v":0},{"$f":"商品分析!F10","v":0},{"$f":"IF(商品分析!X10<>\"\",0,商品分析!G10)","v":0},{"$f":"商品分析!H10","v":0},{"$f":"商品分析!J10","v":0},{"$f":"商品分析!K10","v":0},{"$f":"商品分析!L10","v":0},{"$f":"商品分析!M10","v":0},{"$f":"商品分析!N10","v":0},{"$f":"IF(商品分析!S10<>\"\",商品分析!S10,\"\")","v":""},{"$f":"IF(商品分析!T10<>\"\",商品分析!T10,\"\")","v":""},{"$f":"IF(商品分析!U10<>\"\",商品分析!U10,\"\")","v":""},{"$f":"IF(商品分析!V10<>\"\",商品分析!V10,\"\")","v":""},{"$f":"IF(商品分析!X10<>\"\",商品分析!X10,\"\")","v":""}]
[null,null,{"$f":"商品分析!W11","v":0},{"$f":"商品分析!B11","v":"0"},{"$f":"商品分析!D11","v":0},{"$f":"商品分析!F11","v":0},{"$f":"IF(商品分析!X11<>\"\",0,商品分析!G11)","v":0},{"$f":"商品分析!H11","v":0},{"$f":"商品分析!J11","v":0},{"$f":"商品分析!K11","v":0},{"$f":"商品分析!L11","v":0},{"$f":"商品分析!M11","v":0},{"$f":"商品分析!N11","v":0},{"$f":"IF(商品分析!S11<>\"\",商品分析!S11,\"\")","v":""},{"$f":"IF(商品分析!T11<>\"\",商品分析!T11,\"\")","v":""},{"$f":"IF(商品分析!U11<>\"\",商品分析!U11,\"\")","v":""},{"$f":"IF(商品分析!V11<>\"\",商品分析!V11,\"\")","v":""},{"$f":"IF(商品分析!X11<>\"\",商品分析!X11,\"\")","v":""}]
[null,null,{"$f":"商品分析!W12","v":0},{"$f":"商品分析!B12","v":"0"},{"$f":"商品分析!D12","v":0},{"$f":"商品分析!F12","v":0},{"$f":"IF(商品分析!X12<>\"\",0,商品分析!G12)","v":0},{"$f":"商品分析!H12","v":0},{"$f":"商品分析!J12","v":0},{"$f":"商品分析!K12","v":0},{"$f":"商品分析!L12","v":0},{"$f":"商品分析!M12","v":0},{"$f":"商品分析!N12","v":0},{"$f":"IF(商品分析!S12<>\"\",商品分析!S12,\"\")","v":""},{"$f":"IF(商品分析!T12<>\"\",商品分析!T12,\"\")","v":""},{"$f":"IF(商品分析!U12<>\"\",商品分析!U12,\"\")","v":""},{"$f":"IF(商品分析!V12<>\"\",商品分析!V12,\"\")","v":""},{"$f":"IF(商品分析!X12<>\"\",商品分析!X12,\"\")","v":""}]

{"sheet":"発注登録","index":22,"n_rows":24,"n_cols":5,"rows_kept":24,"cut":false,"hidden":true,"merged":[[1,25,1,26],[1,28,1,29],[1,31,1,32]]}
[]
[null,null,"　　　仕入登録"]
[]
[]
[]
[]
[]
[]
[null,"■登録情報"]
[null,null,"伝票No"]
[null,null,"受注状態"]
[null,null,"受注年月日"]
[null,null,"店舗"]
[null,null,"顧客区分",2,{"$f":"VLOOKUP(D14,テーブル8[],2,FALSE)","v":"常連"}]
[null,null,"平均単価"]
[null,null,"数量"]
[null,null,"金額"]
[null,null,"納期"]
[null,null,"請求日"]
[null,null,"担当者"]
[null,null,"納品書特記事項"]
[null,null,"出荷日"]
[null,null,"入金確認日"]
[null,null,"備考"]

{"sheet":"検品登録","index":23,"n_rows":23,"n_cols":18,"rows_kept":23,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,"　　　検品登録"]
[]
[null,null,"対象期間",null,"～"]
[null,null,"状態"]
[null,null,"店舗"]
[null,null,"顧客名"]
[null,null,"伝票No"]
[]
[]
[]
[]
[null,null,"伝票番号","商品コード","商品名","出品価格","出品ポイント","手数料","重量[g]","高さ[cm]","長さ[cm]","幅[cm]","サイズ[cm^3]","購入日","購入個数","購入価格[$]","送料","希望販売価格"]
[null,null,{"$f":"商品分析!W3","v":0},{"$f":"商品分析!B3","v":"0"},{"$f":"商品分析!D3","v":0},{"$f":"商品分析!F3","v":0},{"$f":"IF(商品分析!X3<>\"\",0,商品分析!G3)","v":0},{"$f":"商品分析!H3","v":0},{"$f":"商品分析!J3","v":0},{"$f":"商品分析!K3","v":0},{"$f":"商品分析!L3","v":0},{"$f":"商品分析!M3","v":0},{"$f":"商品分析!N3","v":0},{"$f":"IF(商品分析!S3<>\"\",商品分析!S3,\"\")","v":""},{"$f":"IF(商品分析!T3<>\"\",商品分析!T3,\"\")","v":""},{"$f":"IF(商品分析!U3<>\"\",商品分析!U3,\"\")","v":""},{"$f":"IF(商品分析!V3<>\"\",商品分析!V3,\"\")","v":""},{"$f":"IF(商品分析!X3<>\"\",商品分析!X3,\"\")","v":""}]
[null,null,{"$f":"商品分析!W4","v":0},{"$f":"商品分析!B4","v":"0"},{"$f":"商品分析!D4","v":0},{"$f":"商品分析!F4","v":0},{"$f":"IF(商品分析!X4<>\"\",0,商品分析!G4)","v":0},{"$f":"商品分析!H4","v":0},{"$f":"商品分析!J4","v":0},{"$f":"商品分析!K4","v":0},{"$f":"商品分析!L4","v":0},{"$f":"商品分析!M4","v":0},{"$f":"商品分析!N4","v":0},{"$f":"IF(商品分析!S4<>\"\",商品分析!S4,\"\")","v":""},{"$f":"IF(商品分析!T4<>\"\",商品分析!T4,\"\")","v":""},{"$f":"IF(商品分析!U4<>\"\",商品分析!U4,\"\")","v":""},{"$f":"IF(商品分析!V4<>\"\",商品分析!V4,\"\")","v":""},{"$f":"IF(商品分析!X4<>\"\",商品分析!X4,\"\")","v":""}]
[null,null,{"$f":"商品分析!W5","v":0},{"$f":"商品分析!B5","v":"0"},{"$f":"商品分析!D5","v":0},{"$f":"商品分析!F5","v":0},{"$f":"IF(商品分析!X5<>\"\",0,商品分析!G5)","v":0},{"$f":"商品分析!H5","v":0},{"$f":"商品分析!J5","v":0},{"$f":"商品分析!K5","v":0},{"$f":"商品分析!L5","v":0},{"$f":"商品分析!M5","v":0},{"$f":"商品分析!N5","v":0},{"$f":"IF(商品分析!S5<>\"\",商品分析!S5,\"\")","v":""},{"$f":"IF(商品分析!T5<>\"\",商品分析!T5,\"\")","v":""},{"$f":"IF(商品分析!U5<>\"\",商品分析!U5,\"\")","v":""},{"$f":"IF(商品分析!V5<>\"\",商品分析!V5,\"\")","v":""},{"$f":"IF(商品分析!X5<>\"\",商品分析!X5,\"\")","v":""}]
[null,null,{"$f":"商品分析!W6","v":0},{"$f":"商品分析!B6","v":"0"},{"$f":"商品分析!D6","v":0},{"$f":"商品分析!F6","v":0},{"$f":"IF(商品分析!X6<>\"\",0,商品分析!G6)","v":0},{"$f":"商品分析!H6","v":0},{"$f":"商品分析!J6","v":0},{"$f":"商品分析!K6","v":0},{"$f":"商品分析!L6","v":0},{"$f":"商品分析!M6","v":0},{"$f":"商品分析!N6","v":0},{"$f":"IF(商品分析!S6<>\"\",商品分析!S6,\"\")","v":""},{"$f":"IF(商品分析!T6<>\"\",商品分析!T6,\"\")","v":""},{"$f":"IF(商品分析!U6<>\"\",商品分析!U6,\"\")","v":""},{"$f":"IF(商品分析!V6<>\"\",商品分析!V6,\"\")","v":""},{"$f":"IF(商品分析!X6<>\"\",商品分析!X6,\"\")","v":""}]
[null,null,{"$f":"商品分析!W7","v":0},{"$f":"商品分析!B7","v":"0"},{"$f":"商品分析!D7","v":0},{"$f":"商品分析!F7","v":0},{"$f":"IF(商品分析!X7<>\"\",0,商品分析!G7)","v":0},{"$f":"商品分析!H7","v":0},{"$f":"商品分析!J7","v":0},{"$f":"商品分析!K7","v":0},{"$f":"商品分析!L7","v":0},{"$f":"商品分析!M7","v":0},{"$f":"商品分析!N7","v":0},{"$f":"IF(商品分析!S7<>\"\",商品分析!S7,\"\")","v":""},{"$f":"IF(商品分析!T7<>\"\",商品分析!T7,\"\")","v":""},{"$f":"IF(商品分析!U7<>\"\",商品分析!U7,\"\")","v":""},{"$f":"IF(商品分析!V7<>\"\",商品分析!V7,\"\")","v":""},{"$f":"IF(商品分析!X7<>\"\",商品分析!X7,\"\")","v":""}]
[null,null,{"$f":"商品分析!W8","v":0},{"$f":"商品分析!B8","v":"0"},{"$f":"商品分析!D8","v":0},{"$f":"商品分析!F8","v":0},{"$f":"IF(商品分析!X8<>\"\",0,商品分析!G8)","v":0},{"$f":"商品分析!H8","v":0},{"$f":"商品分析!J8","v":0},{"$f":"商品分析!K8","v":0},{"$f":"商品分析!L8","v":0},{"$f":"商品分析!M8","v":0},{"$f":"商品分析!N8","v":0},{"$f":"IF(商品分析!S8<>\"\",商品分析!S8,\"\")","v":""},{"$f":"IF(商品分析!T8<>\"\",商品分析!T8,\"\")","v":""},{"$f":"IF(商品分析!U8<>\"\",商品分析!U8,\"\")","v":""},{"$f":"IF(商品分析!V8<>\"\",商品分析!V8,\"\")","v":""},{"$f":"IF(商品分析!X8<>\"\",商品分析!X8,\"\")","v":""}]
[null,null,{"$f":"商品分析!W9","v":0},{"$f":"商品分析!B9","v":"0"},{"$f":"商品分析!D9","v":0},{"$f":"商品分析!F9","v":0},{"$f":"IF(商品分析!X9<>\"\",0,商品分析!G9)","v":0},{"$f":"商品分析!H9","v":0},{"$f":"商品分析!J9","v":0},{"$f":"商品分析!K9","v":0},{"$f":"商品分析!L9","v":0},{"$f":"商品分析!M9","v":0},{"$f":"商品分析!N9","v":0},{"$f":"IF(商品分析!S9<>\"\",商品分析!S9,\"\")","v":""},{"$f":"IF(商品分析!T9<>\"\",商品分析!T9,\"\")","v":""},{"$f":"IF(商品分析!U9<>\"\",商品分析!U9,\"\")","v":""},{"$f":"IF(商品分析!V9<>\"\",商品分析!V9,\"\")","v":""},{"$f":"IF(商品分析!X9<>\"\",商品分析!X9,\"\")","v":""}]
[null,null,{"$f":"商品分析!W10","v":0},{"$f":"商品分析!B10","v":"0"},{"$f":"商品分析!D10","v":0},{"$f":"商品分析!F10","v":0},{"$f":"IF(商品分析!X10<>\"\",0,商品分析!G10)","v":0},{"$f":"商品分析!H10","v":0},{"$f":"商品分析!J10","v":0},{"$f":"商品分析!K10","v":0},{"$f":"商品分析!L10","v":0},{"$f":"商品分析!M10","v":0},{"$f":"商品分析!N10","v":0},{"$f":"IF(商品分析!S10<>\"\",商品分析!S10,\"\")","v":""},{"$f":"IF(商品分析!T10<>\"\",商品分析!T10,\"\")","v":""},{"$f":"IF(商品分析!U10<>\"\",商品分析!U10,\"\")","v":""},{"$f":"IF(商品分析!V10<>\"\",商品分析!V10,\"\")","v":""},{"$f":"IF(商品分析!X10<>\"\",商品分析!X10,\"\")","v":""}]
[null,null,{"$f":"商品分析!W11","v":0},{"$f":"商品分析!B11","v":"0"},{"$f":"商品分析!D11","v":0},{"$f":"商品分析!F11","v":0},{"$f":"IF(商品分析!X11<>\"\",0,商品分析!G11)","v":0},{"$f":"商品分析!H11","v":0},{"$f":"商品分析!J11","v":0},{"$f":"商品分析!K11","v":0},{"$f":"商品分析!L11","v":0},{"$f":"商品分析!M11","v":0},{"$f":"商品分析!N11","v":0},{"$f":"IF(商品分析!S11<>\"\",商品分析!S11,\"\")","v":""},{"$f":"IF(商品分析!T11<>\"\",商品分析!T11,\"\")","v":""},{"$f":"IF(商品分析!U11<>\"\",商品分析!U11,\"\")","v":""},{"$f":"IF(商品分析!V11<>\"\",商品分析!V11,\"\")","v":""},{"$f":"IF(商品分析!X11<>\"\",商品分析!X11,\"\")","v":""}]
[null,null,{"$f":"商品分析!W12","v":0},{"$f":"商品分析!B12","v":"0"},{"$f":"商品分析!D12","v":0},{"$f":"商品分析!F12","v":0},{"$f":"IF(商品分析!X12<>\"\",0,商品分析!G12)","v":0},{"$f":"商品分析!H12","v":0},{"$f":"商品分析!J12","v":0},{"$f":"商品分析!K12","v":0},{"$f":"商品分析!L12","v":0},{"$f":"商品分析!M12","v":0},{"$f":"商品分析!N12","v":0},{"$f":"IF(商品分析!S12<>\"\",商品分析!S12,\"\")","v":""},{"$f":"IF(商品分析!T12<>\"\",商品分析!T12,\"\")","v":""},{"$f":"IF(商品分析!U12<>\"\",商品分析!U12,\"\")","v":""},{"$f":"IF(商品分析!V12<>\"\",商品分析!V12,\"\")","v":""},{"$f":"IF(商品分析!X12<>\"\",商品分析!X12,\"\")","v":""}]

{"sheet":"支払登録","index":24,"n_rows":23,"n_cols":18,"rows_kept":23,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,"　　　支払登録"]
[]
[null,null,"対象期間",null,"～"]
[null,null,"状態"]
[null,null,"店舗"]
[null,null,"顧客名"]
[null,null,"伝票No"]
[]
[]
[]
[]
[null,null,"伝票番号","商品コード","商品名","出品価格","出品ポイント","手数料","重量[g]","高さ[cm]","長さ[cm]","幅[cm]","サイズ[cm^3]","購入日","購入個数","購入価格[$]","送料","希望販売価格"]
[null,null,{"$f":"商品分析!W3","v":0},{"$f":"商品分析!B3","v":"0"},{"$f":"商品分析!D3","v":0},{"$f":"商品分析!F3","v":0},{"$f":"IF(商品分析!X3<>\"\",0,商品分析!G3)","v":0},{"$f":"商品分析!H3","v":0},{"$f":"商品分析!J3","v":0},{"$f":"商品分析!K3","v":0},{"$f":"商品分析!L3","v":0},{"$f":"商品分析!M3","v":0},{"$f":"商品分析!N3","v":0},{"$f":"IF(商品分析!S3<>\"\",商品分析!S3,\"\")","v":""},{"$f":"IF(商品分析!T3<>\"\",商品分析!T3,\"\")","v":""},{"$f":"IF(商品分析!U3<>\"\",商品分析!U3,\"\")","v":""},{"$f":"IF(商品分析!V3<>\"\",商品分析!V3,\"\")","v":""},{"$f":"IF(商品分析!X3<>\"\",商品分析!X3,\"\")","v":""}]
[null,null,{"$f":"商品分析!W4","v":0},{"$f":"商品分析!B4","v":"0"},{"$f":"商品分析!D4","v":0},{"$f":"商品分析!F4","v":0},{"$f":"IF(商品分析!X4<>\"\",0,商品分析!G4)","v":0},{"$f":"商品分析!H4","v":0},{"$f":"商品分析!J4","v":0},{"$f":"商品分析!K4","v":0},{"$f":"商品分析!L4","v":0},{"$f":"商品分析!M4","v":0},{"$f":"商品分析!N4","v":0},{"$f":"IF(商品分析!S4<>\"\",商品分析!S4,\"\")","v":""},{"$f":"IF(商品分析!T4<>\"\",商品分析!T4,\"\")","v":""},{"$f":"IF(商品分析!U4<>\"\",商品分析!U4,\"\")","v":""},{"$f":"IF(商品分析!V4<>\"\",商品分析!V4,\"\")","v":""},{"$f":"IF(商品分析!X4<>\"\",商品分析!X4,\"\")","v":""}]
[null,null,{"$f":"商品分析!W5","v":0},{"$f":"商品分析!B5","v":"0"},{"$f":"商品分析!D5","v":0},{"$f":"商品分析!F5","v":0},{"$f":"IF(商品分析!X5<>\"\",0,商品分析!G5)","v":0},{"$f":"商品分析!H5","v":0},{"$f":"商品分析!J5","v":0},{"$f":"商品分析!K5","v":0},{"$f":"商品分析!L5","v":0},{"$f":"商品分析!M5","v":0},{"$f":"商品分析!N5","v":0},{"$f":"IF(商品分析!S5<>\"\",商品分析!S5,\"\")","v":""},{"$f":"IF(商品分析!T5<>\"\",商品分析!T5,\"\")","v":""},{"$f":"IF(商品分析!U5<>\"\",商品分析!U5,\"\")","v":""},{"$f":"IF(商品分析!V5<>\"\",商品分析!V5,\"\")","v":""},{"$f":"IF(商品分析!X5<>\"\",商品分析!X5,\"\")","v":""}]
[null,null,{"$f":"商品分析!W6","v":0},{"$f":"商品分析!B6","v":"0"},{"$f":"商品分析!D6","v":0},{"$f":"商品分析!F6","v":0},{"$f":"IF(商品分析!X6<>\"\",0,商品分析!G6)","v":0},{"$f":"商品分析!H6","v":0},{"$f":"商品分析!J6","v":0},{"$f":"商品分析!K6","v":0},{"$f":"商品分析!L6","v":0},{"$f":"商品分析!M6","v":0},{"$f":"商品分析!N6","v":0},{"$f":"IF(商品分析!S6<>\"\",商品分析!S6,\"\")","v":""},{"$f":"IF(商品分析!T6<>\"\",商品分析!T6,\"\")","v":""},{"$f":"IF(商品分析!U6<>\"\",商品分析!U6,\"\")","v":""},{"$f":"IF(商品分析!V6<>\"\",商品分析!V6,\"\")","v":""},{"$f":"IF(商品分析!X6<>\"\",商品分析!X6,\"\")","v":""}]
[null,null,{"$f":"商品分析!W7","v":0},{"$f":"商品分析!B7","v":"0"},{"$f":"商品分析!D7","v":0},{"$f":"商品分析!F7","v":0},{"$f":"IF(商品分析!X7<>\"\",0,商品分析!G7)","v":0},{"$f":"商品分析!H7","v":0},{"$f":"商品分析!J7","v":0},{"$f":"商品分析!K7","v":0},{"$f":"商品分析!L7","v":0},{"$f":"商品分析!M7","v":0},{"$f":"商品分析!N7","v":0},{"$f":"IF(商品分析!S7<>\"\",商品分析!S7,\"\")","v":""},{"$f":"IF(商品分析!T7<>\"\",商品分析!T7,\"\")","v":""},{"$f":"IF(商品分析!U7<>\"\",商品分析!U7,\"\")","v":""},{"$f":"IF(商品分析!V7<>\"\",商品分析!V7,\"\")","v":""},{"$f":"IF(商品分析!X7<>\"\",商品分析!X7,\"\")","v":""}]
[null,null,{"$f":"商品分析!W8","v":0},{"$f":"商品分析!B8","v":"0"},{"$f":"商品分析!D8","v":0},{"$f":"商品分析!F8","v":0},{"$f":"IF(商品分析!X8<>\"\",0,商品分析!G8)","v":0},{"$f":"商品分析!H8","v":0},{"$f":"商品分析!J8","v":0},{"$f":"商品分析!K8","v":0},{"$f":"商品分析!L8","v":0},{"$f":"商品分析!M8","v":0},{"$f":"商品分析!N8","v":0},{"$f":"IF(商品分析!S8<>\"\",商品分析!S8,\"\")","v":""},{"$f":"IF(商品分析!T8<>\"\",商品分析!T8,\"\")","v":""},{"$f":"IF(商品分析!U8<>\"\",商品分析!U8,\"\")","v":""},{"$f":"IF(商品分析!V8<>\"\",商品分析!V8,\"\")","v":""},{"$f":"IF(商品分析!X8<>\"\",商品分析!X8,\"\")","v":""}]
[null,null,{"$f":"商品分析!W9","v":0},{"$f":"商品分析!B9","v":"0"},{"$f":"商品分析!D9","v":0},{"$f":"商品分析!F9","v":0},{"$f":"IF(商品分析!X9<>\"\",0,商品分析!G9)","v":0},{"$f":"商品分析!H9","v":0},{"$f":"商品分析!J9","v":0},{"$f":"商品分析!K9","v":0},{"$f":"商品分析!L9","v":0},{"$f":"商品分析!M9","v":0},{"$f":"商品分析!N9","v":0},{"$f":"IF(商品分析!S9<>\"\",商品分析!S9,\"\")","v":""},{"$f":"IF(商品分析!T9<>\"\",商品分析!T9,\"\")","v":""},{"$f":"IF(商品分析!U9<>\"\",商品分析!U9,\"\")","v":""},{"$f":"IF(商品分析!V9<>\"\",商品分析!V9,\"\")","v":""},{"$f":"IF(商品分析!X9<>\"\",商品分析!X9,\"\")","v":""}]
[null,null,{"$f":"商品分析!W10","v":0},{"$f":"商品分析!B10","v":"0"},{"$f":"商品分析!D10","v":0},{"$f":"商品分析!F10","v":0},{"$f":"IF(商品分析!X10<>\"\",0,商品分析!G10)","v":0},{"$f":"商品分析!H10","v":0},{"$f":"商品分析!J10","v":0},{"$f":"商品分析!K10","v":0},{"$f":"商品分析!L10","v":0},{"$f":"商品分析!M10","v":0},{"$f":"商品分析!N10","v":0},{"$f":"IF(商品分析!S10<>\"\",商品分析!S10,\"\")","v":""},{"$f":"IF(商品分析!T10<>\"\",商品分析!T10,\"\")","v":""},{"$f":"IF(商品分析!U10<>\"\",商品分析!U10,\"\")","v":""},{"$f":"IF(商品分析!V10<>\"\",商品分析!V10,\"\")","v":""},{"$f":"IF(商品分析!X10<>\"\",商品分析!X10,\"\")","v":""}]
[null,null,{"$f":"商品分析!W11","v":0},{"$f":"商品分析!B11","v":"0"},{"$f":"商品分析!D11","v":0},{"$f":"商品分析!F11","v":0},{"$f":"IF(商品分析!X11<>\"\",0,商品分析!G11)","v":0},{"$f":"商品分析!H11","v":0},{"$f":"商品分析!J11","v":0},{"$f":"商品分析!K11","v":0},{"$f":"商品分析!L11","v":0},{"$f":"商品分析!M11","v":0},{"$f":"商品分析!N11","v":0},{"$f":"IF(商品分析!S11<>\"\",商品分析!S11,\"\")","v":""},{"$f":"IF(商品分析!T11<>\"\",商品分析!T11,\"\")","v":""},{"$f":"IF(商品分析!U11<>\"\",商品分析!U11,\"\")","v":""},{"$f":"IF(商品分析!V11<>\"\",商品分析!V11,\"\")","v":""},{"$f":"IF(商品分析!X11<>\"\",商品分析!X11,\"\")","v":""}]
[null,null,{"$f":"商品分析!W12","v":0},{"$f":"商品分析!B12","v":"0"},{"$f":"商品分析!D12","v":0},{"$f":"商品分析!F12","v":0},{"$f":"IF(商品分析!X12<>\"\",0,商品分析!G12)","v":0},{"$f":"商品分析!H12","v":0},{"$f":"商品分析!J12","v":0},{"$f":"商品分析!K12","v":0},{"$f":"商品分析!L12","v":0},{"$f":"商品分析!M12","v":0},{"$f":"商品分析!N12","v":0},{"$f":"IF(商品分析!S12<>\"\",商品分析!S12,\"\")","v":""},{"$f":"IF(商品分析!T12<>\"\",商品分析!T12,\"\")","v":""},{"$f":"IF(商品分析!U12<>\"\",商品分析!U12,\"\")","v":""},{"$f":"IF(商品分析!V12<>\"\",商品分析!V12,\"\")","v":""},{"$f":"IF(商品分析!X12<>\"\",商品分析!X12,\"\")","v":""}]