{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["記録一覧","注文書","林","田中","中村","松村","設定","登録台帳"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":13,"comments":1,"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":5,"n_cols":17,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[1,{"$f":"A1+1","v":2},{"$f":"B1+1","v":3},4,5,6,7,8,9,10,11,12,13,14,15,16,17]
[]
[null,null,null,null,"発　注　台　帳"]
[]
[null,null,"入力日時","発注日","発注番号","発注先","商品名","単価","数量","金額","担当者","入力日","受入日","備考欄","担当者名"]

{"sheet":"注文書","index":1,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[[14,2,15,5]]}
[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,"備考"]

{"sheet":"林","index":2,"n_rows":5,"n_cols":15,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,null,null,"発　注　台　帳"]
[]
[null,null,"入力日時","発注日","発注番号","発注先","商品名","単価","数量","金額","担当者","入力日","受入日","備考欄","担当者名"]

{"sheet":"田中","index":3,"n_rows":5,"n_cols":15,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,null,null,"発　注　台　帳"]
[]
[null,null,"入力日時","発注日","発注番号","発注先","商品名","単価","数量","金額","担当者","入力日","受入日","備考欄","担当者名"]

{"sheet":"中村","index":4,"n_rows":5,"n_cols":15,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,null,null,"発　注　台　帳"]
[]
[null,null,"入力日時","発注日","発注番号","発注先","商品名","単価","数量","金額","担当者","入力日","受入日","備考欄","担当者名"]

{"sheet":"松村","index":5,"n_rows":5,"n_cols":15,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,null,null,"発　注　台　帳"]
[]
[null,null,"入力日時","発注日","発注番号","発注先","商品名","単価","数量","金額","担当者","入力日","受入日","備考欄","担当者名"]

{"sheet":"設定","index":6,"n_rows":15,"n_cols":22,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[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,"T01","有田",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PO210902-05","松村製作所"]
[null,"T02","伊藤"]
[null,"T03","鈴木"]
[null,"T04","中村"]
[null,"T05","太田"]
[null,"T06","山口"]
[null,"T07","金田"]
[null,"T08","野口"]
[null,"T09","田中"]
[null,"T10","林"]

{"sheet":"登録台帳","index":7,"n_rows":16,"n_cols":55,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[1,{"$f":"A1+1","v":2},{"$f":"B1+1","v":3},4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55]
[null,null,null,null,null,null,"「正式会社名は、Ｂ列の会社名を読込むように関数を設定しています。"]
[null,null,null,null,null,"正式会社名",{"$f":"IF($B$6=\"\",\"\",$B$6)","v":"林エンジニアリング株式会社"},null,null,null,"正式会社名",{"$f":"IF($B$7=\"\",\"\",$B$7)","v":"田中コーポレーション"},null,null,null,"正式会社名",{"$f":"IF($B$8=\"\",\"\",$B$8)","v":"株式会社中村工業"},null,null,null,"正式会社名",{"$f":"IF($B$9=\"\",\"\",$B$9)","v":"松村製作所"},null,null,null,"正式会社名",{"$f":"IF($B$10=\"\",\"\",$B$10)","v":""},null,null,null,"正式会社名",{"$f":"IF($B$11=\"\",\"\",$B$11)","v":""},null,null,null,"正式会社名",{"$f":"IF($B$12=\"\",\"\",$B$12)","v":""},null,null,null,"正式会社名",{"$f":"IF($B$13=\"\",\"\",$B$13)","v":""},null,null,null,"正式会社名",{"$f":"IF($B$14=\"\",\"\",$B$14)","v":""},null,null,null,"正式会社名",{"$f":"IF($B$15=\"\",\"\",$B$15)","v":""}]
[null,null,null,null,null,"商品名範囲名前",{"$f":"$C$6","v":"会社名1"},null,null,null,"商品名範囲名前",{"$f":"$C$7","v":"会社名2"},null,null,null,"商品名範囲名前",{"$f":"$C$8","v":"会社名3"},null,null,null,"商品名範囲名前",{"$f":"$C$9","v":"会社名4"},null,null,null,"商品名範囲名前",{"$f":"$C$10","v":"会社名5"},null,null,null,"商品名範囲名前",{"$f":"$C$11","v":"会社名6"},null,null,null,"商品名範囲名前",{"$f":"$C$12","v":"会社名7"},null,null,null,"商品名範囲名前",{"$f":"$C$13","v":"会社名8"},null,null,null,"商品名範囲名前",{"$f":"$C$14","v":"会社名9"},null,null,null,"商品名範囲名前",{"$f":"$C$15","v":"会社名10"}]
[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","林",null,null,"林商品Ａ",1000,null,null,null,"田中商品Ａ",100,null,null,null,"中村商品Ａ",20000,null,null,null,"松村商品Ａ",3000]
[null,"田中コーポレーション","会社名2","田中",null,null,"林商品Ｂ",1200,null,null,null,"田中商品Ｂ",120,null,null,null,"中村商品Ｂ",21000,null,null,null,"松村商品Ｂ",4000]
[null,"株式会社中村工業","会社名3","中村",null,null,"林商品Ｃ",1300,null,null,null,"田中商品Ｃ",130,null,null,null,"中村商品Ｃ",22000,null,null,null,"松村商品Ｃ",5000]
[null,"松村製作所","会社名4","松村",null,null,"林商品Ｄ",1400,null,null,null,"田中商品Ｄ",140,null,null,null,"中村商品Ｄ",23000,null,null,null,"松村商品Ｄ",6000]
[null,null,"会社名5",null,null,null,"林商品Ｅ",1500,null,null,null,"田中商品Ｅ",150,null,null,null,"中村商品Ｅ",24000,null,null,null,"松村商品Ｅ",7000]
[null,null,"会社名6",null,null,null,"林商品Ｆ",1600,null,null,null,"田中商品Ｆ",160,null,null,null,"中村商品Ｆ",25000,null,null,null,"松村商品Ｆ",8000]
[null,null,"会社名7",null,null,null,"林商品Ｇ",1700,null,null,null,"田中商品Ｇ",170,null,null,null,"中村商品Ｇ",26000,null,null,null,"松村商品Ｇ",9000]
[null,null,"会社名8",null,null,null,"林商品Ｈ",1800,null,null,null,"田中商品Ｈ",180,null,null,null,"中村商品Ｈ",27000,null,null,null,"松村商品Ｈ",10000]
[null,null,"会社名9",null,null,null,"林商品Ｉ",1900,null,null,null,"田中商品Ｉ",190,null,null,null,"中村商品Ｉ",28000,null,null,null,"松村商品Ｉ",11000]
[null,null,"会社名10",null,null,null,"林商品Ｊ",2000,null,null,null,"田中商品Ｊ",200,null,null,null,"中村商品Ｊ",29000,null,null,null,"松村商品Ｊ",12000]
[null,null,null,null,null,null,"林商品Ｋ",2100,null,null,null,"田中商品Ｋ",210,null,null,null,"中村商品Ｋ",30000,null,null,null,"松村商品Ｋ",13000]