{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["管理画面","src","temp","set","グラフ用"],"not_rendered":{"charts":0,"images":2,"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":"管理画面","index":0,"n_rows":21,"n_cols":5,"rows_kept":21,"cut":false,"hidden":false,"merged":[[1,1,2,12]]}
[]
[null,"かんたんKPI　集計ツール　ver1.23"]
[]
[]
[]
[null,null,"１．かんたんKPI明細データの取込"]
[null,null,null,null,"CSV取込ボタンを押し、かんたんKPI明細データを選択して下さい。"]
[null,null,null,null,"取込csv："]
[]
[null,null,"２．KPI自動集計（表またはグラフの出力を行います）"]
[null,null,null,"● 表出力"]
[null,null,null,"　KPIの一覧表（実績/時間 および 時間/実績）を自動出力します。"]
[]
[null,null,null,"● グラフ出力"]
[null,null,null,"　下記リストからグラフ化したいKPIを選択し、グラフ出力ボタンを押して下さい。"]
[]
[null,null,null,null,"＊日別KPIグラフ、および作業実績とKPIの散布図グラフが出力されます"]
[]
[null,null,"３．データクリア"]
[null,null,"　　集計結果の初期化を行います。"]
[null,null,"　　集計に時間がかかる場合や計測データを変更する際にデータクリアを実施して下さい。"]

{"sheet":"src","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"temp","index":2,"n_rows":64,"n_cols":12,"rows_kept":64,"cut":false,"hidden":true,"merged":[]}
["KPIレベル1","KPIレベル2","KPIレベル3","KPI名","日付","実績","作業時間","KPI","KPI単位","計算日","分/実績","KPI単位②"]
["全体","入荷","---","入荷",42304,148,20.25,7.31,"ライン/時間",42545,8.2094594594594597,"分/ライン"]
["全体","入荷","---","入荷",42305,292,27.5,10.62,"ライン/時間",42538,5.6506849315068495,"分/ライン"]
["全体","入荷","---","入荷",42306,263,19.5,13.49,"ライン/時間",42538,4.4486692015209126,"分/ライン"]
["全体","入荷","---","入荷",42307,114,12.75,8.94,"ライン/時間",42538,6.7105263157894735,"分/ライン"]
["全体","入荷","---","入荷",42308,0,8.5,0,"ライン/時間",42538,0,"分/ライン"]
["全体","入荷","---","入荷",42309,0,0,0,"ライン/時間",42538,0,"分/ライン"]
["全体","入荷","---","入荷",42310,39,6.25,6.24,"ライン/時間",42538,9.615384615384615,"分/ライン"]
["全体","入荷","---","入荷",42311,0,0,0,"ライン/時間",42538,0,"分/ライン"]
["全体","入荷","---","入荷",42312,413,30.25,13.65,"ライン/時間",42538,4.3946731234866832,"分/ライン"]
["全体","入荷","---","荷下ろし・荷受け",42304,148,1.25,118.4,"ライン/時間",42545,0.5067567567567568,"分/ライン"]
["全体","入荷","---","荷下ろし・荷受け",42305,292,4.5,64.89,"ライン/時間",42538,0.92465753424657537,"分/ライン"]
["全体","入荷","---","荷下ろし・荷受け",42306,263,4.25,61.88,"ライン/時間",42538,0.96958174904942962,"分/ライン"]
["全体","入荷","---","荷下ろし・荷受け",42307,114,3.25,35.08,"ライン/時間",42538,1.7105263157894737,"分/ライン"]
["全体","入荷","---","荷下ろし・荷受け",42308,0,6.25,0,"ライン/時間",42538,0,"分/ライン"]
["全体","入荷","---","荷下ろし・荷受け",42309,0,0,0,"ライン/時間",42538,0,"分/ライン"]
["全体","入荷","---","荷下ろし・荷受け",42310,39,0,0,"ライン/時間",42538,0,"分/ライン"]
["全体","入荷","---","荷下ろし・荷受け",42311,0,0,0,"ライン/時間",42538,0,"分/ライン"]
["全体","入荷","---","荷下ろし・荷受け",42312,413,4,103.25,"ライン/時間",42538,0.58111380145278446,"分/ライン"]
["全体","入荷","---","入荷検品",42304,148,5,29.6,"ライン/時間",42545,2.0270270270270272,"分/ライン"]
["全体","入荷","---","入荷検品",42305,292,7.75,37.68,"ライン/時間",42538,1.5924657534246576,"分/ライン"]
["全体","入荷","---","入荷検品",42306,263,4.5,58.44,"ライン/時間",42538,1.0266159695817489,"分/ライン"]
["全体","入荷","---","入荷検品",42307,114,2.75,41.45,"ライン/時間",42538,1.4473684210526316,"分/ライン"]
["全体","入荷","---","入荷検品",42308,0,0.25,0,"ライン/時間",42538,0,"分/ライン"]
["全体","入荷","---","入荷検品",42309,0,0,0,"ライン/時間",42538,0,"分/ライン"]
["全体","入荷","---","入荷検品",42310,39,3,13,"ライン/時間",42538,4.615384615384615,"分/ライン"]
["全体","入荷","---","入荷検品",42311,0,0,0,"ライン/時間",42538,0,"分/ライン"]
["全体","入荷","---","入荷検品",42312,413,9.25,44.65,"ライン/時間",42538,1.3438256658595642,"分/ライン"]
["全体","入荷","---","棚入",42304,148,14,10.57,"ライン/時間",42545,5.6756756756756754,"分/ライン"]
["全体","入荷","---","棚入",42305,292,15.25,19.149999999999999,"ライン/時間",42538,3.1335616438356166,"分/ライン"]
["全体","入荷","---","棚入",42306,263,10.75,24.47,"ライン/時間",42538,2.452471482889734,"分/ライン"]
["全体","入荷","---","棚入",42307,114,6.75,16.89,"ライン/時間",42538,3.5526315789473686,"分/ライン"]
["全体","入荷","---","棚入",42308,0,2,0,"ライン/時間",42538,0,"分/ライン"]
["全体","入荷","---","棚入",42309,0,0,0,"ライン/時間",42538,0,"分/ライン"]
["全体","入荷","---","棚入",42310,39,3.25,12,"ライン/時間",42538,5,"分/ライン"]
["全体","入荷","---","棚入",42311,0,0,0,"ライン/時間",42538,0,"分/ライン"]
["全体","入荷","---","棚入",42312,413,17,24.29,"ライン/時間",42538,2.4697336561743342,"分/ライン"]
["全体","出荷","---","出荷",42304,3378,82.366669999999999,41.01,"ライン/時間",42545,1.4629959147424512,"分/ライン"]
["全体","出荷","---","出荷",42305,2953,65.316670000000002,45.21,"ライン/時間",42538,1.3271250253979003,"分/ライン"]
["全体","出荷","---","出荷",42306,2811,62.716670000000001,44.82,"ライン/時間",42538,1.3386695837780149,"分/ライン"]
["全体","出荷","---","出荷",42307,3089,70.2,44,"ライン/時間",42538,1.3635480738102945,"分/ライン"]
["全体","出荷","---","出荷",42308,64,1.43333,44.65,"ライン/時間",42538,1.3437468749999999,"分/ライン"]
["全体","出荷","---","出荷",42309,57,1.75,32.57,"ライン/時間",42538,1.8421052631578947,"分/ライン"]
["全体","出荷","---","出荷",42310,7143,102.76667,69.510000000000005,"ライン/時間",42538,0.86322276354472915,"分/ライン"]
["全体","出荷","---","出荷",42311,83,4.0333300000000003,20.58,"ライン/時間",42538,2.9156602409638559,"分/ライン"]
["全体","出荷","---","出荷",42312,6279,93.583330000000004,67.099999999999994,"ライン/時間",42538,0.89425064500716678,"分/ライン"]
["全体","出荷","---","ピッキング",42304,3378,44.183329999999998,76.45,"ライン/時間",42545,0.78478383658969808,"分/ライン"]
["全体","出荷","---","ピッキング",42305,2953,26.75,110.39,"ライン/時間",42538,0.54351506942092787,"分/ライン"]
["全体","出荷","---","ピッキング",42306,2811,29.75,94.49,"ライン/時間",42538,0.63500533617929567,"分/ライン"]
["全体","出荷","---","ピッキング",42307,3089,32.5,95.05,"ライン/時間",42538,0.63127225639365492,"分/ライン"]
["全体","出荷","---","ピッキング",42308,64,0.35,182.86,"ライン/時間",42538,0.328125,"分/ライン"]
["全体","出荷","---","ピッキング",42309,57,1.75,32.57,"ライン/時間",42538,1.8421052631578947,"分/ライン"]
["全体","出荷","---","ピッキング",42310,7143,55.616669999999999,128.43,"ライン/時間",42538,0.46717068458630828,"分/ライン"]
["全体","出荷","---","ピッキング",42311,83,4.0333300000000003,20.58,"ライン/時間",42538,2.9156602409638559,"分/ライン"]
["全体","出荷","---","ピッキング",42312,6279,35.25,178.13,"ライン/時間",42538,0.33683707596751072,"分/ライン"]
["全体","出荷","---","出荷検品",42304,3378,17.5,193.03,"ライン/時間",42545,0.31083481349911191,"分/ライン"]
["全体","出荷","---","出荷検品",42305,2953,18.75,157.49,"ライン/時間",42538,0.3809685066034541,"分/ライン"]
["全体","出荷","---","出荷検品",42306,2811,17.5,160.63,"ライン/時間",42538,0.37353255069370334,"分/ライン"]
["全体","出荷","---","出荷検品",42307,3089,23.716670000000001,130.25,"ライン/時間",42538,0.46066694723211393,"分/ライン"]
["全体","出荷","---","出荷検品",42308,64,0.25,256,"ライン/時間",42538,0.234375,"分/ライン"]
["全体","出荷","---","出荷検品",42309,57,0,0,"ライン/時間",42538,0,"分/ライン"]
["全体","出荷","---","出荷検品",42310,7143,31.566669999999998,226.28,"ライン/時間",42538,0.2651547249055019,"分/ライン"]
["全体","出荷","---","出荷検品",42311,83,0,0,"ライン/時間",42538,0,"分/ライン"]
["全体","出荷","---","出荷検品",42312,6279,42.333329999999997,148.32,"ライン/時間",42538,0.40452298136645959,"分/ライン"]

{"sheet":"set","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"グラフ用","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}