{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Main","CreateProject","Tables","Utilities"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":12,"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":"Main","index":0,"n_rows":2,"n_cols":16,"rows_kept":2,"cut":false,"hidden":false,"merged":[[1,10,1,11]]}
[]
["計画くん",null,"Main Menu",null,null,null,null,null,null,"Date","2023-04-08",null,null,null,null,"UserID"]

{"sheet":"CreateProject","index":1,"n_rows":28,"n_cols":18,"rows_kept":28,"cut":false,"hidden":false,"merged":[[4,3,4,5],[15,14,15,16],[16,14,16,16],[17,14,17,16]]}
[]
[null,"CREATE NEW PROJECT",null,null,null,null,null,"Date: ",{"$f":"Main!K2","v":"2023-04-08"}]
[null,null,null,null,null,null,null,null,null,null,null,"Count"]
[]
[null,null,"Project Name",null,null,null,null,"Branch Code","ALL",null,{"$f":"myWhereStrBr(BranchCode)","v":""},{"$f":"myCountRecords(B$7,K5,TRUE)","v":10545}]
[]
[null,"item_mst",null,null,{"$f":"MATCH(B7,Tables!B:B,0)","v":20},null,null,null,null,null,"E列とK列は、ユーザー向けには非表示",null,null,"sales_data",null,"Sales History 25 months"]
[null,null,"item",null,{"$f":"HLOOKUP(C8,INDIRECT(\"Tables!\" &  $E$7+1 & \":\" & $E$7+2),2,FALSE)","v":"TEXT"},null,"と等しい","かつ",null,"と等しい",{"$f":"myWhereStr(B$7,C8:J8)","v":""},{"$f":"myCountRecords(B$7,K8)","v":""},null,null,"Data From",{"$f":"EOMONTH(I2,-25)+1","v":"2021-04-01"},"To",{"$f":"I2-1","v":"2023-04-07"}]
[null,null,"description",null,"TEXT",null,"と等しい","かつ",null,"と等しい",{"$f":"myWhereStr(B$7,C9:J9)","v":""},{"$f":"myCountRecords(B$7,K9)","v":""}]
[null,null,"status","*",{"$f":"HLOOKUP(C10,INDIRECT(\"Tables!\" &  $E$7+1 & \":\" & $E$7+2),2,FALSE)","v":"TEXT"},null,"と等しい","かつ",null,"と等しい",{"$f":"myWhereStr(B$7,C10:J10)","v":""},{"$f":"myCountRecords(B$7,K10)","v":""},null,"forecast_data"]
[null,null,"category1","*",{"$f":"HLOOKUP(C11,INDIRECT(\"Tables!\" &  $E$7+1 & \":\" & $E$7+2),2,FALSE)","v":"TEXT"},"Housing Equipment","と等しい","かつ",null,"と等しい",{"$f":"myWhereStr(B$7,C11:J11)","v":"item_mst.category1='Housing Equipment'"},{"$f":"myCountRecords(B$7,K11)","v":815},null,null,"Data From",{"$f":"EOMONTH(I2,-1)+1","v":"2023-04-01"},"To",{"$f":"EOMONTH(I2,11)","v":"2024-03-31"}]
[null,null,"category2",null,"TEXT",null,"と等しい","かつ",null,"と等しい",{"$f":"myWhereStr(B$7,C12:J12)","v":""},{"$f":"myCountRecords(B$7,K12)","v":""}]
[null,null,"abc_rank","*","TEXT",null,"と等しい","かつ",null,"と等しい",{"$f":"myWhereStr(B$7,C13:J13)","v":""},{"$f":"myCountRecords(B$7,K13)","v":""}]
[null,null,"buyer_code","*","TEXT",null,"と等しい","かつ",null,"と等しい",{"$f":"myWhereStr(B$7,C14:J14)","v":""},{"$f":"myCountRecords(B$7,K14)","v":""}]
[null,null,"seasonality","*","TEXT",null,"と等しい","かつ",null,"と等しい",{"$f":"myWhereStr(B$7,C15:J15)","v":""},{"$f":"myCountRecords(B$7,K15)","v":""},null,"Sort Order"]
[null,null,"list_price",null,"INTEGER",null,"と等しい","かつ",null,"と等しい",{"$f":"myWhereStr(B$7,C16:J16)","v":""},{"$f":"myCountRecords(B$7,K16)","v":""},null,1,"item",null,null,"昇順"]
[null,null,"avg_price",null,"REAL",null,"と等しい","かつ",null,"と等しい",{"$f":"myWhereStr(B$7,C17:J17)","v":""},{"$f":"myCountRecords(B$7,K17)","v":""},null,2,null,null,null,"昇順"]
[null,null,"avg_cost",null,"REAL",null,"と等しい","かつ",null,"と等しい",{"$f":"myWhereStr(B$7,C18:J18)","v":""},{"$f":"myCountRecords(B$7,K18)","v":""},null,3,null,null,null,"昇順"]
[null,null,"vendor","*","TEXT",null,"以上","かつ",null,"と等しい",{"$f":"myWhereStr(B$7,C19:J19)","v":""},{"$f":"myCountRecords(B$7,K19)","v":""}]
[null,null,"vendor_item",null,"TEXT",null,"と等しい","かつ",null,"と等しい",{"$f":"myWhereStr(B$7,C20:J20)","v":""},{"$f":"myCountRecords(B$7,K20)","v":""}]
[null,null,"leadtime","*","INTEGER",null,"と等しい","かつ",null,"と等しい",{"$f":"myWhereStr(B$7,C21:J21)","v":""},{"$f":"myCountRecords(B$7,K21)","v":""}]
[null,null,"unit_leadtime","*","TEXT",null,"と等しい","かつ",null,"と等しい",{"$f":"myWhereStr(B$7,C22:J22)","v":""},{"$f":"myCountRecords(B$7,K22)","v":""}]
[null,null,"min_stock_month","*","REAL",null,"と等しい","かつ",null,"と等しい",{"$f":"myWhereStr(B$7,C23:J23)","v":""},{"$f":"myCountRecords(B$7,K23)","v":""}]
[null,null,"first_sales_date",null,"TEXT",null,"と等しい","かつ",null,"と等しい",{"$f":"myWhereStr(B$7,C24:J24)","v":""},{"$f":"myCountRecords(B$7,K24)","v":""}]
[null,null,"last_update",null,"TEXT",null,"と等しい","かつ",null,"と等しい",{"$f":"myWhereStr(B$7,C25:J25)","v":""},{"$f":"myCountRecords(B$7,K25)","v":""}]
[null,null,null,null,null,"ブランク指定には「空白」と記入",null,null,"ブランク指定には「空白」と記入"]
[null,null,null,null,null,null,"上記の条件の","すべて","を満たすレコード数",null,{"$f":"myWhereStrAll(K8:K25,H27,K5)","v":"(item_mst.category1='Housing Equipment')"},{"$f":"myCountRecords(B$7,K27)","v":815}]
[null,{"$f":"VLOOKUP(B7,Tables!B:D,3,FALSE)","v":24},"Columns"]

{"sheet":"Tables","index":2,"n_rows":104,"n_cols":25,"rows_kept":104,"cut":false,"hidden":false,"merged":[[103,1,108,11]]}
["Database Name","StockMove.sqlite3",null,null,null,"アクションメニューを表示するには、テーブル名のセルを選択してください",null,null,null,null,"＜カスタムSQL文用セルへ移動"]
["Table Name","sales_data","field count",{"$f":"COUNTA(B3:AH3)","v":5}]
["Field Name","item","branch","date","qty","amount"]
["Type","TEXT","TEXT","TEXT","INTEGER","INTEGER"]
["Key",null,null,null,null,null,"PRIMARY KEY(item,branch,date)"]
["Schema","CREATE TABLE sales_data(item TEXT ,branch TEXT ,date TEXT ,qty INTEGER ,amount INTEGER ,PRIMARY KEY(item,branch,date))"]
["Remarks","0,0,0,101,0,0","0,0,0,101,0,0"]
["Table Name","stock_data","field count",{"$f":"COUNTA(B9:AH9)","v":4}]
["Field Name","item","branch","date","qty"]
["Type","TEXT","TEXT","TEXT","INTEGER"]
["Key",null,null,null,null,"PRIMARY KEY(item,branch,date)"]
["Schema","CREATE TABLE stock_data(item TEXT ,branch TEXT ,date TEXT ,qty INTEGER ,PRIMARY KEY(item,branch,date))"]
["Remarks","0,0,0,101,0,0"]
["Table Name","openpo_data","field count",{"$f":"COUNTA(B15:AH15)","v":7}]
["Field Name","item","branch","order_date","due_date","qty","amount","vendor"]
["Type","TEXT","TEXT","TEXT","TEXT","INTEGER","INTEGER","TEXT"]
["Key"]
["Schema","CREATE TABLE openpo_data(item TEXT ,branch TEXT ,order_date TEXT ,due_date TEXT ,qty INTEGER ,amount INTEGER ,vendor TEXT )"]
["Remarks","0,0,0,101,0,0"]
["Table Name","item_mst","field count",{"$f":"COUNTA(B21:AH21)","v":24}]
["Field Name","item","description","status","category1","category2","abc_rank","buyer_code","seasonality","list_price","avg_price","avg_cost","vendor","vendor_item","leadtime","unit_leadtime","pack_large","pack_medium","pack_small","order_unit","min_stock_month","sku_branch","first_sales_date","last_update","last_update_user"]
["Type","TEXT","TEXT","TEXT","TEXT","TEXT","TEXT","TEXT","TEXT","INTEGER","REAL","REAL","TEXT","TEXT","INTEGER","TEXT","INTEGER","INTEGER","INTEGER","TEXT","REAL","TEXT","TEXT","TEXT","TEXT"]
["Key","PRIMARY KEY"]
["Schema","CREATE TABLE item_mst(item TEXT PRIMARY KEY,description TEXT ,status TEXT ,category1 TEXT ,category2 TEXT ,abc_rank TEXT ,buyer_code TEXT ,seasonality TEXT ,list_price INTEGER ,avg_price REAL ,avg_cost REAL ,vendor TEXT ,vendor_item TEXT ,leadtime INTEGER ,unit_leadtime TEXT ,pack_large INTEGER ,pack_medium INTEGER ,pack_small INTEGER ,order_unit TEXT ,min_stock_month REAL ,sku_branch TEXT ,first_sales_date TEXT ,last_update TEXT ,last_update_user TEXT )"]
["Remarks","0,0,0,101,0,0","0,0,0,101,0,0"]
["Table Name","itemchange_mst","field count",{"$f":"COUNTA(B27:AH27)","v":5}]
["Field Name","change_id","item","status","inheritance_ratio","date"]
["Type","TEXT","TEXT","TEXT","REAL","TEXT"]
["Key","PRIMARY KEY"]
["Schema","CREATE TABLE itemchange_mst(change_id TEXT PRIMARY KEY,item TEXT ,status TEXT ,inheritance_ratio REAL ,date TEXT )"]
["Remarks","0,0,0,101,0,0"]
["Table Name","vendor_mst","field count",{"$f":"COUNTA(B33:AH33)","v":10}]
["Field Name","vendor_code","company_name","city","state","postal_code","country","title","contact_person","email","buyer_code"]
["Type","TEXT","TEXT","TEXT","TEXT","TEXT","TEXT","TEXT","TEXT","TEXT","TEXT"]
["Key","PRIMARY KEY"]
["Schema","CREATE TABLE vendor_mst(vendor_code TEXT PRIMARY KEY,company_name TEXT ,city TEXT ,state TEXT ,postal_code TEXT ,country TEXT ,title TEXT ,contact_person TEXT ,email TEXT ,buyer_code TEXT )"]
["Remarks","0,0,0,101,0,0"]
["Table Name","employee_mst","field count",{"$f":"COUNTA(B39:AH39)","v":4}]
["Field Name","employee_code","name","birth_date","department"]
["Type","TEXT","TEXT","TEXT","TEXT"]
["Key","PRIMARY KEY"]
["Schema","CREATE TABLE employee_mst(employee_code TEXT PRIMARY KEY,name TEXT ,birth_date TEXT ,department TEXT )"]
["Remarks","0,0,0,101,0,0"]
["Table Name","forecast_data","field count",{"$f":"COUNTA(B45:AH45)","v":9}]
["Field Name","item","branch","date","sales_qty","sales_price","purchase_qty","adjust_qty","last_update","last_update_user"]
["Type","TEXT","TEXT","TEXT","INTEGER","INTEGER","INTEGER","INTEGER","TEXT","TEXT"]
["Key",null,null,null,null,null,null,null,null,null,"PRIMARY KEY(item,branch,date)"]
["Schema","CREATE TABLE forecast_data(item TEXT ,branch TEXT ,date TEXT ,sales_qty INTEGER ,sales_price INTEGER ,purchase_qty INTEGER ,adjust_qty INTEGER ,last_update TEXT ,last_update_user TEXT ,PRIMARY KEY(item,branch,date))"]
["Remarks","0,0,0,101,0,0"]
["Table Name","project_mst","field count",{"$f":"COUNTA(B51:AH51)","v":10}]
["Field Name","project_id","branch","type","vendor","create_date","target_date","buyer_code","item_count","finish_count","sql_used"]
["Type","TEXT","TEXT","TEXT","TEXT","TEXT","TEXT","TEXT","INTEGER","INTEGER","TEXT"]
["Key","PRIMARY KEY"]
["Schema","CREATE TABLE project_mst(project_id TEXT PRIMARY KEY,branch TEXT ,type TEXT ,vendor TEXT ,create_date TEXT ,target_date TEXT ,buyer_code TEXT ,item_count INTEGER ,finish_count INTEGER ,sql_used TEXT )"]
["Remarks","0,0,0,101,0,0"]
["Table Name"]
["Field Name"]
["Type"]
["Key"]
["Schema"]
["Remarks"]
["Table Name"]
["Field Name"]
["Type"]
["Key"]
["Schema"]
["Remarks"]
["Table Name"]
["Field Name"]
["Type"]
["Key"]
["Schema"]
["Remarks"]
["Table Name"]
["Field Name"]
["Type"]
["Key"]
["Schema"]
["Remarks"]
["Table Name"]
["Field Name"]
["Type"]
["Key"]
["Schema"]
["Remarks"]
["Table Name"]
["Field Name"]
["Type"]
["Key"]
["Schema"]
["Remarks"]
["Table Name"]
["Field Name"]
["Type"]
["Key"]
["Schema"]
["Remarks"]
["Table Name"]
["Field Name"]
["Type"]
["Key"]
["Schema"]
["Remarks"]
["Custom SQL","VACUUM"]

{"sheet":"Utilities","index":3,"n_rows":3,"n_cols":2,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["FamilyBooks"]
["Name","Type"]
["Simulation.xlsm"]