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

{"sheet":"menu","index":0,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[1]
[null,null,"在庫処理メニュー",null,{"$f":"IF(F2=0,\"\",\"価格データが変更された                   在庫報告書データの変更を要す。\")","v":""},{"$f":"(標準部品計算1!G2+標準部品計算1!N2)-(標準部品計算1!G3+標準部品計算1!N3)","v":0}]
[null,null,null,null,null,"チェック値"]
[null,null,"　",null,"　"]
[null,null,"　",null," "]
[null,null," ",null," "]
[null,null,"　",null,"　"]
[null,null,"　",null,"　"]
[null,null," ",null,"2021-06-30"]
[null,null,"　",null,"入力更新日 (例　2020/3/20)"]
[null,null,"　"]

{"sheet":"標準部品入力1","index":1,"n_rows":70,"n_cols":12,"rows_kept":70,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[" ",null,null,null," "]
[" ","標準部品数量 　入力画面",null,null,null,"　",null," "]
[null,"A-10","加工部品在庫表",null,null,"A-10","購入部品在庫表",null,null,"A-20","部品在庫表"]
[null,"品番","品名","数量",null,"品番","品名","数量",null,"品番","品名","数量"]
[null,"A0-01","フレームA",10,null,"A0-09","スプリング",3]
[null,"A0-02a","カバーA",9,null,"A0-08","握り玉",3]
[null,"A0-02b","カバーB",10,null,"A0-01","キャスター",24]
[null,"A0-05","カバーC",9,null,"A1-01","ベアリング",504]
[null,"A0-06","カバーD",13,null,"A1-01","ベアリング",216]
[null,"A0-08","タックA",14,null,"A1-02","ベアリング",24]
[null,"A0-09","タックB",14,null,"A1-19","ピローユニット",12]
[null,"A0-10","カラーA",14,null,"A1-21","ベアリング",16]
[null,"A0-11","カラーB",15,null,"A1-01","シール",504]
[null,"A0-12","レバー",16,null,"A1-22","ベアリング",24]
[null,"A0-13a","上部カバー(右)",14,null,"A1-02","止め板",6]
[null,"A0-13B","上部カバー(左)",16,null,"A1-25","キー",3]
[null,"A0-14","下部カバー",22,null,"A1-25","三相ギヤードモートル",3]
[null,"A0-15","電装カバー",22,null,"A2","ベアリング",276]
[null,"A0-17","ハンドル",16,null,"A3-02","ドライメット",6]
[null,"A0-50","電装BOX",25,null,"A3-06","ノブ",3]
[null,"A1-01","上サイド(L)",18,null,"A3-01","ベアリング",6]
[null,"A1-02","上サイド(R)",18,null,"A4-20","ノブ",12]
[null,"A1-03","下サイド(L)",18,null,"A4-16","ベアリング",6]
[null,"A1-04","下サイド(R)",18,null,"A6-03","ベアリング",120]
[null,"A1-06","ローラーA",63,null,"A6-05","ベアリング",12]
[null,"A1-08","ローラーギヤ",63,null,"A7-02","ベアリング",6]
[null,"A1-10","ギヤA",54,null,"A7-05","ニードルベアリング",7]
[null,"A1-11","ギヤB",6,null,"B1-02","ピストン",3]
[null,"A1-13","ギヤピン",51,null,"B2-02","ナールドノブ",3]
[null,"A2-01","上ライナー",5,null,null,"ダイヤルゲージ",3]
[null,"A2-02","上軸受座",5]
[null,"A2-03","上軸受",12]
[null,"A3-01","ロール",6]
[null,"A3-02","ロール軸受",12]
[null,"A3-03","ステー",6]
[null,"A4-01","プレートA",6]
[null,"A4-02","プレートB",6]
[null,"A6-01","BKT (A)",46]
[null,"A6-02","BKT (B)",46]
[null,"A6-03","軸",12]
[null,"A7-01","ガイドベース",6]
[null,"A7-02","軸受",92]
[null,"A7-03","ﾛｰﾗｰ(下)",6]
[null,"A7-04","ﾛｰﾗｰ(上)",6]
[null,"B1-01","取付板(a)",20]
[null,"B1-02","取付板(b)",124]
[null,"B1-04","カム",20]
[null,"B2-01","スタンド",20]
[null,"B2-02","ブロック",20]
[null,"C-01","タンク",20]
[null,"A9-01","受板",14]
[null,"A9-04","押え板",7]
[null,"J-01","治具(A)",20]
[null,"J-02","治具(B)",50]
[null,null,null,0]
[]
[null,null," "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null," "]

{"sheet":"標準部品計算1","index":2,"n_rows":81,"n_cols":14,"rows_kept":81,"cut":false,"hidden":false,"merged":[[1,2,1,3],[1,9,1,10]]}
[null,null,null,null,null,"$A$1"]
[null," ","毎月棚卸入力計算と印刷画面",null,null,{"$f":"SUM(E5:E80)","v":5246136},{"$f":"SUM(G5:G79)","v":316526},null," ","毎月棚卸入力計算と印刷画面",null,null,{"$f":"SUM(L5:L80)","v":234590},{"$f":"SUM(N5:N79)","v":20036}]
[null,"A-10",null,"毎月棚卸標準部品",null,{"$f":"E81","v":5246136},316526,null,"A-10",null,"毎月棚卸標準部品",null,{"$f":"L81","v":234590},20036]
[null,"品番","品名","数量","加工費"," ","加工単価",null,"品番","品名","数量","加工費"," ","加工単価"]
[null,"A0-01","フレームA",10,{"$f":"G5*D5","v":580000},null,58000,null,"A0-09","スプリング",3,{"$f":"N5*K5","v":30},null,10]
[null,"A0-02a","カバーA",9,15120,null,1680,null,"A0-08","握り玉",3,{"$f":"N6*K6","v":60},null,20]
[null,"A0-02b","カバーB",10,5900,null,590,null,"A0-01","キャスター",24,14640,null,610]
[null,"A0-05","カバーC",9,8460,null,940,null,"A1-01","ベアリング",504,94752,null,188]
[null,"A0-06","カバーD",13,33670,null,2590,null,"A1-01","ベアリング",216,2160,null,10]
[null,"A0-08","タックA",14,4760,null,340,null,"A1-02","ベアリング",24,240,null,10]
[null,"A0-09","タックB",14,3500,null,250,null,"A1-19","ピローユニット",12,10572,null,881]
[null,"A0-10","カラーA",14,3080,null,220,null,"A1-21","ベアリング",16,160,null,10]
[null,"A0-11","カラーB",15,6450,null,430,null,"A1-01","シール",504,52920,null,105]
[null,"A0-12","レバー",16,3200,null,200,null,"A1-22","ベアリング",24,240,null,10]
[null,"A0-13a","上部カバー(右)",14,17500,null,1250,null,"A1-02","止め板",6,60,null,10]
[null,"A0-13B","上部カバー(左)",16,20000,null,1250,null,"A1-25","キー",3,756,null,252]
[null,"A0-14","下部カバー",22,12100,null,550,null,"A1-25","三相ギヤードモートル",3,30,null,10]
[null,"A0-15","電装カバー",22,6160,null,280,null,"A2","ベアリング",276,2760,null,10]
[null,"A0-17","ハンドル",16,15200,null,950,null,"A3-02","ドライメット",6,60,null,10]
[null,"A0-50","電装BOX",25,1850000,null,74000,null,"A3-06","ノブ",3,30,null,10]
[null,"A1-01","上サイド(L)",18,201240,null,11180,null,"A3-01","ベアリング",6,60,null,10]
[null,"A1-02","上サイド(R)",18,214560,null,11920,null,"A4-20","ノブ",12,120,null,10]
[null,"A1-03","下サイド(L)",18,277020,null,15390,null,"A4-16","ベアリング",6,60,null,10]
[null,"A1-04","下サイド(R)",18,277020,null,15390,null,"A6-03","ベアリング",120,1200,null,10]
[null,"A1-06","ローラーA",63,315000,null,5000,null,"A6-05","ベアリング",12,120,null,10]
[null,"A1-08","ローラーギヤ",63,69300,null,1100,null,"A7-02","ベアリング",6,60,null,10]
[null,"A1-10","ギヤA",54,78300,null,1450,null,"A7-05","ニードルベアリング",7,70,null,10]
[null,"A1-11","ギヤB",6,9600,null,1600,null,"B1-02","ピストン",3,42000,null,14000]
[null,"A1-13","ギヤピン",51,17850,null,350,null,"B2-02","ナールドノブ",3,30,null,10]
[null,"A2-01","上ライナー",5,9850,null,1970,null,null,"ダイヤルゲージ",3,11400,null,3800]
[null,"A2-02","上軸受座",5,20050,null,4010,null,null,null,null,0,null,0]
[null,"A2-03","上軸受",12,35640,null,2970]
[null,"A3-01","ロール",6,156,null,26]
[null,"A3-02","ロール軸受",12,17040,null,1420]
[null,"A3-03","ステー",6,7920,null,1320]
[null,"A4-01","プレートA",6,207000,null,34500]
[null,"A4-02","プレートB",6,{"$f":"G37*D37","v":238800},null,39800]
[null,"A6-01","BKT (A)",46,62560,null,1360]
[null,"A6-02","BKT (B)",46,62560,null,1360]
[null,"A6-03","軸",12,10320,null,860]
[null,"A7-01","ガイドベース",6,15600,null,2600]
[null,"A7-02","軸受",92,95680,null,1040]
[null,"A7-03","ﾛｰﾗｰ(下)",6,14880,null,2480]
[null,"A7-04","ﾛｰﾗｰ(上)",6,13380,null,2230]
[null,"B1-01","取付板(a)",20,43800,null,2190]
[null,"B1-02","取付板(b)",124,186000,null,1500]
[null,"B1-04","カム",20,31000,null,1550]
[null,"B2-01","スタンド",20,23600,null,1180]
[null,"B2-02","ブロック",20,28000,null,1400]
[null,"C-01","タンク",20,76400,null,3820]
[null,"A9-01","受板",14,140,null,10]
[null,"A9-04","押え板",7,70,null,10]
[null,"J-01","治具(A)",20,200,null,10]
[null,"J-02","治具(B)",50,500,null,10]
[null,null,null,0,null,null,0]
[null,null,null,null,null,null,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"合計",null,{"$f":"SUM(E5:E80)","v":5246136},null,null,null,null,"合計",null,{"$f":"SUM(L5:L80)","v":234590}]