{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["改定履歴","Sheet1","Sheet2","iE_Setting"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":2,"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":"改定履歴","index":0,"n_rows":9,"n_cols":10,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[null,"date","VER","内容",null,null,null,null,null,"作業者"]
[null,"2020-09-30","1.00","新規作成",null,null,null,null,null,"光永"]
[null,"2020-11-18",1.01,"フォームの変更",null,null,null,null,null,"光永"]
[null,"2020-11-26","1.02","フォームの変更",null,null,null,null,null,"豊田"]
[null,"2020-12-22",1.03,"ヘッダ削除その他微調整",null,null,null,null,null,"光永"]
[null,"2020-12-23","1.04","フォームの変更、その他微調整",null,null,null,null,null,"豊田"]
[null,"2021-05-27","1.05","ボタンの変更、フィルタ再設定、ウィンドウ枠の固定",null,null,null,null,null,"豊田"]
[null,"2021-08-16","1.06","入力中の行が選択中となっているのを分かりやすくした",null,null,null,null,null,"豊田"]

{"sheet":"Sheet1","index":1,"n_rows":12,"n_cols":120,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[null,"棚卸一覧_2"]
[]
[null,null,"部門","00020",{"$f":"\"'\"&D4&\"'\"","v":"'00020'"},null,null,null,null,null,null,null,null,{"$f":"IF(M4=\"\",\"LIKE '%'\",\"LIKE '%\"&M4&\"%'\")","v":"LIKE '%'"}]
[null,null,"商品",null,{"$f":"_xlfn.SWITCH(D8,1,IF(D5=\"\",\"LIKE '%'\",\"like '%\"&D5&\"%'\"),2,IF(D5=\"\",\"LIKE '%'\",\"NOT LIKE '%\"&D5&\"%'\"),3,IF(D5=\"\",\"LIKE '%'\",\"LIKE '%\"&D5&\"%'\"))","v":"LIKE '%'"},null,null,null,null,null,null,null,null,{"$f":"IF(M5=\"\",\"LIKE '%'\",\"LIKE '%\"&M5&\"%'\")","v":"LIKE '%'"}]
[null,null,"材質",null,{"$f":"IF(D6=\"\",\"LIKE '%'\",\"LIKE '%\"&D6&\"%'\")","v":"LIKE '%'"},null,null,null,null,null,null,null,null,{"$f":"IF(M6=\"\",\"LIKE '%'\",\"LIKE '%\"&M6&\"%'\")","v":"LIKE '%'"}]
[null,null,"色調",null,{"$f":"IF(D7=\"\",\"LIKE '%'\",\"LIKE '%\"&D7&\"%'\")","v":"LIKE '%'"}]
[null,null,"切替",2,"1：コイル　2：コイル以外 3:商品指定",null,null,null,null,null,null,null,null,{"$f":"IF(M8=\"\",\"LIKE '%'\",\"LIKE '%\"&M8&\"%'\")","v":"LIKE '%'"}]
[null,null,null,null,"ロケーション：",null,"シール済",{"$f":"MAX((DB:DB),(K:K),(P:P),(U:U),(Z:Z),(AE:AE),(AJ:AJ),(AO:AO),(AT:AT),(AY:AY),(BD:BD),(BI:BI),(BN:BN),(BS:BS),(BX:BX),(CC:CC),(CH:CH),(CM:CM),(CR:CR),(CW:CW))","v":0}]
[]
[null,null,"製品コード","製品名","材質","数量","在庫数","実棚数","差異","金額","SEQ","箱入数","箱数","バラ","小計","SEQ","箱入数","箱数","バラ","小計","SEQ","箱入数","箱数","バラ","小計","SEQ","箱入数","箱数","バラ","小計","SEQ","箱入数","箱数","バラ","小計","SEQ","箱入数","箱数","バラ","小計","SEQ","箱入数","箱数","バラ","小計","SEQ","箱入数","箱数","バラ","小計","SEQ","箱入数","箱数","バラ","小計","SEQ","箱入数","箱数","バラ","小計","SEQ","箱入数","箱数","バラ","小計","SEQ","箱入数","箱数","バラ","小計","SEQ","箱入数","箱数","バラ","小計","SEQ","箱入数","箱数","バラ","小計","SEQ","箱入数","箱数","バラ","小計","SEQ","箱入数","箱数","バラ","小計","SEQ","箱入数","箱数","バラ","小計","SEQ","箱入数","箱数","バラ","小計","SEQ","箱入数","箱数","バラ","小計","SEQ","箱入数","箱数","バラ","小計","備考","規格","色調名","板厚","幅","長さ","OP1","OP2"]
[1,{"$f":"C12&DH12","v":"WZ99900000005404910000"},"WZ99900","その他特注製作品１中間品","00",{"$f":"O12+T12+Y12+AD12+AI12+AN12+AS12+AX12+BC12+BH12+BM12+BR12+BW12+CB12+CG12+CL12+CQ12+CV12+DA12+DF12","v":0},11924,null,null,1350,null,null,null,null,{"$f":"(L12*M12)+N12","v":0},null,null,null,null,{"$f":"(Q12*R12)+S12","v":0},null,null,null,null,{"$f":"(V12*W12)+X12","v":0},null,null,null,null,{"$f":"(AA12*AB12)+AC12","v":0},null,null,null,null,{"$f":"(AF12*AG12)+AH12","v":0},null,null,null,null,{"$f":"(AK12*AL12)+AM12","v":0},null,null,null,null,{"$f":"(AP12*AQ12)+AR12","v":0},null,null,null,null,{"$f":"(AU12*AV12)+AW12","v":0},null,null,null,null,{"$f":"(AZ12*BA12)+BB12","v":0},null,null,null,null,{"$f":"(BE12*BF12)+BG12","v":0},null,null,null,null,{"$f":"(BJ12*BK12)+BL12","v":0},null,null,null,null,{"$f":"(BO12*BP12)+BQ12","v":0},null,null,null,null,{"$f":"(BT12*BU12)+BV12","v":0},null,null,null,null,{"$f":"(BY12*BZ12)+CA12","v":0},null,null,null,null,{"$f":"(CD12*CE12)+CF12","v":0},null,null,null,null,{"$f":"(CI12*CJ12)+CK12","v":0},null,null,null,null,{"$f":"(CN12*CO12)+CP12","v":0},null,null,null,null,{"$f":"(CS12*CT12)+CU12","v":0},null,null,null,null,{"$f":"(CX12*CY12)+CZ12","v":0},null,null,null,null,{"$f":"(DC12*DD12)+DE12","v":0},null,"000005404910000","00000","540.00","491","0","00","00",{"$f":"C12&E12&DP12&DJ12&DK12&DL12","v":"WZ999000000000540.004910"},"00000"]

{"sheet":"Sheet2","index":2,"n_rows":6,"n_cols":120,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[1,2,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,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120]
[null,null,"工場","00020"]
[]
[null,null,"製品コード","製品名","材質","数量","在庫数","実棚数","差異","金額","SEQ","箱入数","箱数","バラ","小計","SEQ","箱入数","箱数","バラ","小計","SEQ","箱入数","箱数","バラ","小計","SEQ","箱入数","箱数","バラ","小計","SEQ","箱入数","箱数","バラ","小計","SEQ","箱入数","箱数","バラ","小計","SEQ","箱入数","箱数","バラ","小計","SEQ","箱入数","箱数","バラ","小計","SEQ","箱入数","箱数","バラ","小計","SEQ","箱入数","箱数","バラ","小計","SEQ","箱入数","箱数","バラ","小計","SEQ","箱入数","箱数","バラ","小計","SEQ","箱入数","箱数","バラ","小計","SEQ","箱入数","箱数","バラ","小計","SEQ","箱入数","箱数","バラ","小計","SEQ","箱入数","箱数","バラ","小計","SEQ","箱入数","箱数","バラ","小計","SEQ","箱入数","箱数","バラ","小計","SEQ","箱入数","箱数","バラ","小計","SEQ","箱入数","箱数","バラ","小計","備考","規格","色調名","板厚","幅","長さ","OP1","OP2"]
[1,{"$f":"C5&DH5","v":"WZ99900000005404910000"},"WZ99900","その他特注製作品１中間品","00",{"$f":"O5+T5+Y5+AD5+AI5+AN5+AS5+AX5+BC5+BH5+BM5+BR5+BW5+CB5+CG5+CL5+CQ5+CV5+DA5+DF5","v":0},11924,null,null,1350,null,null,null,null,{"$f":"(L5*M5)+N5","v":0},null,null,null,null,{"$f":"(Q5*R5)+S5","v":0},null,null,null,null,{"$f":"(V5*W5)+X5","v":0},null,null,null,null,{"$f":"(AA5*AB5)+AC5","v":0},null,null,null,null,{"$f":"(AF5*AG5)+AH5","v":0},null,null,null,null,{"$f":"(AK5*AL5)+AM5","v":0},null,null,null,null,{"$f":"(AP5*AQ5)+AR5","v":0},null,null,null,null,{"$f":"(AU5*AV5)+AW5","v":0},null,null,null,null,{"$f":"(AZ5*BA5)+BB5","v":0},null,null,null,null,{"$f":"(BE5*BF5)+BG5","v":0},null,null,null,null,{"$f":"(BJ5*BK5)+BL5","v":0},null,null,null,null,{"$f":"(BO5*BP5)+BQ5","v":0},null,null,null,null,{"$f":"(BT5*BU5)+BV5","v":0},null,null,null,null,{"$f":"(BY5*BZ5)+CA5","v":0},null,null,null,null,{"$f":"(CD5*CE5)+CF5","v":0},null,null,null,null,{"$f":"(CI5*CJ5)+CK5","v":0},null,null,null,null,{"$f":"(CN5*CO5)+CP5","v":0},null,null,null,null,{"$f":"(CS5*CT5)+CU5","v":0},null,null,null,null,{"$f":"(CX5*CY5)+CZ5","v":0},null,null,null,null,{"$f":"(DC5*DD5)+DE5","v":0},null,"000005404910000","00000","540.00","491","0","00","00",{"$f":"C5&E5&DP5&DJ5&DK5&DL5","v":"WZ999000000000540.004910"},"00000"]
[null,{"$f":"C6&DH6","v":""},null,null,null,{"$f":"+(L6*M6)+N6+(Q6*R6)+S6+(V6*W6)+X6","v":0}]

{"sheet":"iE_Setting","index":3,"n_rows":171,"n_cols":4,"rows_kept":171,"cut":false,"hidden":true,"merged":[]}
["http://10.6.1.5/EVOLIOWebService/Service.asmx"]
[0]
[0]
[]
[]
[]
[]
[]
[]
[]
[null,"C000000002"]
[null,"G000000044"]
[null,"レポート_S_棚卸一覧2_対応付け"]
[null,"レポート_S_棚卸一覧2"]
[]
[null,1,null,1]
[null,4]
[null,0]
[]
[null,"<?xml version=\"1.0\" encoding=\"utf-16\"?><ReportDefine xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\" xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\"><ReportSheet>Sheet1</ReportSheet><ReportSheetCol>2</ReportSheetCol><ReportStartCell>$12:$12</ReportStartCell><ReportPageRows>0</ReportPageRows><ReportAnotherFile>false</ReportAnotherFile><ReportFileRequest>false</ReportFileRequest><LayoutSheet>Sheet2</LayoutSheet><LayoutSheetCol>4</LayoutSheetCol><LayoutSheetHidden>false</LayoutSheetHidden><ReportHeaderCell /><ReportHeaderFlag>false</ReportHeaderFlag><PageHeaderCell /><DetailCell>$5:$5</DetailCell><DetailCell2>$6:$6</DetailCell2><DetailCount>0</DetailCount><DetailSpaceFlag>false</DetailSpaceFlag><DetailSpaceEven>false</DetailSpaceEven><PageFooterCell /><ReportFooterCell /><ReportFooterFlag>false</ReportFooterFlag><GroupInfo /></ReportDefine>"]
[null,"S棚卸2"]
[null,"<condition><para name=\"$倉庫$\" sheet=\"Sheet1\" sheetcol=\"2\" cell=\"E4\" /><para name=\"$商品$\" sheet=\"Sheet1\" sheetcol=\"2\" cell=\"E5\" /><para name=\"$材質$\" sheet=\"Sheet1\" sheetcol=\"2\" cell=\"E6\" /><para name=\"$色調$\" sheet=\"Sheet1\" sheetcol=\"2\" cell=\"E7\" /></condition>"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,0]
[]
[null,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,24]
[null,"ExtractButton_2"]
[]
[null,"Button"]
[null,48]
[null,14.25]
[null,58.5]
[null,"Placement"]
[null,3]
[]
[]
[null,"<?xml version=\"1.0\" encoding=\"utf-16\"?><ButtonOption xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\" xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\"><MsgBeforeFlag>false</MsgBeforeFlag><MsgBefore /><MsgAfterFlag>false</MsgAfterFlag><MsgAfter /><CurSheetName /><CurSheetCol>0</CurSheetCol></ButtonOption>"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"<?xml version=\"1.0\" encoding=\"utf-16\"?><ButtonOption xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\" xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\"><MsgBeforeFlag>true</MsgBeforeFlag><MsgBefore /><MsgAfterFlag>true</MsgAfterFlag><MsgAfter /><CurSheetName /><CurSheetCol>0</CurSheetCol></ButtonOption>"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"検索"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,0]