{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["入力シート","マスタ"],"not_rendered":{"macros":1,"external_links":4,"defined_names":26},"read":"whole","date_system":"1900"}

{"sheet":"入力シート","index":0,"n_rows":17,"n_cols":10,"rows_kept":17,"merged":[[0,6,0,7]]}
[null,"品番",629,628,null,null,{"$f":"I2*10+MOD(-SUM(INT(I2/10^{1,3,5,7,9,11;0,2,4,6,8,10})*{1;3}),10)","v":2000000006291},null,null,"Fsworks並び替える"]
[null,"JANCODE",{"$f":"G1","v":2000000006291},null,"←E1を貼り付けている",null,"1～１７","分類",{"$f":"C1+200000000000","v":200000000629},"ILU→マスタ登録→外部マスタ取り込み"]
[null,"KP-20（ラベル機）＋FSWorks（レジ）設定シート　20200718"]
[null,"種別",null,null,{"$f":"VLOOKUP(C4,[2]マスタ!T2:U13,2,FALSE)","v":{"$error":"#N/A"}}]
[null,"商品名",null,null,{"$f":"LEN(C5)","v":0},"KP-20　16文字まで","20～499","惣菜"]
[null,"ラベルフォーマット","通常",{"$f":"C6","v":"通常"},{"$f":"VLOOKUP(D6,[2]マスタ!A2:B10,2,FALSE)","v":1},"FSW　9文字まで","600番","珍味・佃煮"]
[null,"補助品名","-",{"$f":"C7","v":"-"},{"$f":"VLOOKUP(D7,[2]マスタ!D2:F50,2,FALSE)","v":0},null,"700番","煉り物・種"]
[null,"保存方法","-",{"$f":"C8","v":"-"},{"$f":"VLOOKUP(D8,[2]マスタ!G2:H52,2,FALSE)","v":{"$error":"#N/A"}},null,"2000番","前日仕込み",null,"エネルギー"]
[null,"内容量",{"$nulls":4},"1000番","弁当",null,"たんぱく質"]
[null,"単価種別",null,{"$f":"C10","v":0},{"$f":"VLOOKUP(D10,[2]マスタ!J2:K51,2,FALSE)","v":{"$error":"#N/A"}},null,"3000番","直売所用",null,"脂質"]
[null,"税込売価",{"$nulls":4},"4000番","JAN付蒲一商品",null,"炭水化物"]
[null,"税抜原価",{"$nulls":4},"5000番","パッケージJAN",null,"食塩相当量"]
[null,"賞味期限印字",null,{"$f":"C13","v":0},{"$f":"VLOOKUP(D13,[2]マスタ!M2:N3,2,FALSE)","v":{"$error":"#N/A"}},null,"6000番","焼魚"]
[null,"賞味(日or時間)",null,{"$f":"C14","v":0},{"$f":"VLOOKUP(D14,[2]マスタ!P2:Q3,2,FALSE)","v":{"$error":"#N/A"}},null,"7000番","よりどりセール"]
[null,"賞味期間",{"$nulls":4},"8000番","おでん鍋"]
[null,"有効時刻印字",null,{"$f":"C16","v":0},{"$f":"IF(D16=\"\",1,VLOOKUP(C16,[2]マスタ!M2:N3,2,FALSE))","v":{"$error":"#N/A"}},null,"9000番","年末商材"]
[null,"添加物",null,null,{"$f":"LEN(C17)","v":0},"200文字"]

{"sheet":"マスタ","index":1,"n_rows":50,"n_cols":21,"rows_kept":50}
[{"$nulls":3},"ITEM03",null,null,"ITEM07"]
["通常",1,null,"-",0,0,"-",0,21,"個",21,null,"しない",1,null,"日",0,null,null,"弁当",1]
["JANコード添付不要",2,null,"鎌倉産野菜を使用した自然派惣菜",1,1,"冷凍保存して下さい",1,22,"尾",22,null,"する",0,null,"時間",1,null,null,"惣菜",2]
[{"$nulls":3},"伊勢産ひじき",2,2,"高温多湿は避けて保存して下さい",2,23,"枚",23,{"$nulls":8},"焼魚",3]
[{"$nulls":3},"奥久慈の自然卵使用",3,3,"直射日光を避けお早めにお召し上がり下さい。",3,24,"本",24,{"$nulls":8},"煉り物・種",4]
[{"$nulls":3},"食べるのに最適な根室産昆布",4,4,"冷蔵庫に保管し、お早めにお召し上がり下さい。",4,26,"切",26,{"$nulls":8},"おでん鍋",5]
[{"$nulls":3},"具だくさん！",5,5,"直射日光・高温多湿を避け、常温で保存して下さい。",5,27,"袋",27,{"$nulls":8},"とうふ",6]
[{"$nulls":3},"至極のおでん種",6,6,"要冷蔵（1℃～10℃）",6,28,"束",28,{"$nulls":8},"珍味・佃煮",7]
[{"$nulls":3},"訳あり商品に付き超お買得！",7,7,"高温多湿を避け保管には充分にご留意下さい。",7,32,"匹",32,{"$nulls":8},"年末商材",8]
[{"$nulls":3},"愛知・静岡産　うなぎ使用",8,8,"高温多湿を避けて下さい。",8,34,"皿",34,{"$nulls":8},"スポット商材",9]
[{"$nulls":3},"千葉県大原産　地だこ使用",9,{"$nulls":3},35,"盛",35,{"$nulls":8},"特売",10]
[{"$nulls":3},"青森産ほたて使用",10,{"$nulls":3},36,"杯",36,{"$nulls":8},"その他部門",11]
[{"$nulls":3},"モンドセレクション3年連続金賞受賞",11,{"$nulls":3},31,"点",31,{"$nulls":8},"送料",12]
[{"$nulls":3},"房州産菜の花使用",12,{"$nulls":3},25,"ｇ",25]
[{"$nulls":3},"当店人気商品！",13,{"$nulls":3},37,"㎏",37]
[{"$nulls":3},"脂ののったノルウェー産のさばです。",14,{"$nulls":3},33,"ﾊﾟｯｸ",33]
[{"$nulls":3},"プレミアムフライデー",15,{"$nulls":3},42,"ｶﾛﾘｰ",42]
[{"$nulls":3},"ごはん",{"$nulls":4},38,"人前",38]
[{"$nulls":3},"おかず",{"$nulls":4},39,"株",39]
[{"$nulls":8},40,"串",40]
[{"$nulls":8},41,"Ｐ",41]
[{"$nulls":8},30,"-"]
[{"$nulls":8},{"$f":"K23","v":0}]
[{"$nulls":8},0]
[{"$nulls":8},0]
[{"$nulls":8},0]
[{"$nulls":8},0]
[{"$nulls":8},0]
[{"$nulls":8},0]
[{"$nulls":8},0]
[{"$nulls":8},0]
[{"$nulls":8},0]
[{"$nulls":8},0]
[{"$nulls":8},0]
[{"$nulls":8},0]
[{"$nulls":8},0]
[{"$nulls":8},0]
[{"$nulls":8},0]
[{"$nulls":8},0]
[{"$nulls":8},0]
[{"$nulls":8},0]
[{"$nulls":8},0]
[{"$nulls":8},0]
[{"$nulls":8},0]
[{"$nulls":8},0]
[{"$nulls":8},0]
[{"$nulls":8},0]
[{"$nulls":8},0]
[{"$nulls":8},0]
[{"$nulls":8},0]