{"text_format":"5","workbook":"xls","n_sheets":2,"sheets":["1.2 correct delivery","1.3 on time"],"props":{"creator":"NYK","last_modified_by":"Watchara Boonlon","company":"NESC"},"not_rendered":{"charts":2,"external_links":1},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"1.2 correct delivery","index":0,"n_rows":35,"n_cols":18,"rows_kept":35,"merged":[[0,0,0,17],[2,0,2,3],[2,4,2,7],[3,0,3,3],[3,4,3,7],[4,0,4,7],[5,0,5,7],[6,0,6,3],[6,4,6,7],[7,0,9,3],[7,6,7,7],[8,4,8,7],[9,6,9,7],[10,0,10,7],[11,0,11,7],[12,0,12,3],[12,4,12,7],[13,0,13,3],[13,4,13,7],[15,0,16,5],[15,6,15,11],[15,12,15,17],[17,0,17,5],[18,0,18,5],[18,6,18,7],[18,9,18,10],[18,12,18,13],[18,15,18,16],[19,0,19,5],[20,0,20,5],[21,0,21,5],[22,0,22,5],[23,0,23,5],[23,6,23,8],[23,9,23,11],[23,12,23,14],[23,15,23,17],[24,0,24,5],[25,0,25,5],[26,0,26,5],[26,6,26,8],[26,9,26,11],[26,12,26,14],[26,15,26,17],[28,0,29,5],[28,6,28,11],[28,12,28,17],[30,0,30,5],[31,0,31,5],[31,6,31,7],[31,9,31,10],[31,12,31,13],[31,15,31,16],[34,1,34,5],[34,6,34,11],[34,12,34,14],[34,15,34,17],[35,1,35,5],[35,6,35,11],[35,12,35,14],[35,15,35,17],[36,1,36,5],[36,6,36,11],[36,12,36,14],[36,15,36,17],[37,1,37,5],[37,6,37,11],[37,12,37,14],[37,15,37,17],[38,1,38,5],[38,6,38,11],[38,12,38,14],[38,15,38,17],[39,1,39,5],[39,6,39,11],[39,12,39,14],[39,15,39,17],[40,1,40,5],[40,6,40,11],[40,12,40,14],[40,15,40,17],[41,1,41,5],[41,6,41,11],[41,12,41,14],[41,15,41,17],[42,1,42,5],[42,6,42,11],[42,12,42,14],[42,15,42,17],[43,1,43,5],[43,6,43,11],[43,12,43,14],[43,15,43,17],[44,1,44,5],[44,6,44,11],[44,12,44,14],[44,15,44,17],[45,1,45,5],[45,6,45,11],[45,12,45,14],[45,15,45,17]],"headers":{"header":["","","Issue A6"],"footer":["Arranged By : Watchara Boonlon","FM - QSG - QMS - 2 - 0","Effective Date : 1 August 2010"]},"flags":["formulas_cached_only"]}
["Quality Objective Monitoring & Measurement"]
["Part 1  Details of Quality Objective & KPI",{"$nulls":7},"Part 4 Analysis of data"]
["Activity / Service",{"$nulls":3},"Group"]
["Transportation",{"$nulls":3},"LLC1"]
["Quality Objective / Purpose or Benefit"]
["Share this ratio and encourage to decrease for customer satisfaction."]
["Key performance indicator",{"$nulls":3},"Last Performance"]
["1.2 % Correct Delivery",{"$nulls":4},97,"%"]
[{"$nulls":4},"Taget"]
[{"$nulls":5},100,"%"]
["Formular"]
["Total Number of Correctly Delivered Trip x 100\nAccumulated delivered Trip"]
["frequency of monitoring",{"$nulls":3},"Frequency of measurement"]
["Monthly",{"$nulls":3},"Quarterly"]
["Part 2  Records of operation"]
["Performance",{"$nulls":5},2010,{"$nulls":5},2011]
[{"$nulls":6},"Jul","Aug","Sep","Oct","Nov","Dec","Jan","Feb","Mar","Apr","May","Jun"]
["Trends of Performance - Yearly",{"$nulls":5},{"v":99.84693877551021,"d":"99.85"},{"v":99.79863692688971,"d":"99.80"},{"v":99.866693195384,"d":"99.87"},{"v":99.89998507239886,"d":"99.90"},{"v":99.92131086835771,"d":"99.92"},{"v":99.93269277666683,"d":"99.93"},{"v":99.95785490849832,"d":"99.96"},{"v":99.99451599045783,"d":"99.99"},{"v":99.99549849649783,"d":"100.00"},{"v":99.99556186756612,"d":"100.00"},{"v":99.99639262652862,"d":"100.00"},{"v":99.9973109846278,"d":"100.00"}]
["Performance - Quarterly",{"$nulls":7},{"v":99.866693195384,"d":"99.87"},null,null,{"v":99.99617261506076,"d":"100.00"},null,null,{"v":99.99489960726976,"d":"99.99"},null,null,{"v":100,"d":"100.00"}]
["Performance - Monthly",{"$nulls":5},{"v":99.84693877551021,"d":"99.85"},{"v":99.75301204819277,"d":"99.75"},{"v":99.9888765294772,"d":"99.99"},{"v":100,"d":"100.00"},{"v":99.99485225985792,"d":"99.99"},{"v":99.99378843406423,"d":"99.99"},{"v":100,"d":"100.00"},{"v":99.98960228749675,"d":"99.99"},{"v":99.9949096462204,"d":"99.99"},{"v":100,"d":"100.00"},{"v":100,"d":"100.00"},{"v":100,"d":"100.00"}]
["Target",{"$nulls":5},100,100,100,100,100,100,100,100,100,100,100,100]
["Accumulated delivered Trip",{"$nulls":5},{"v":15680,"d":"15,680"},{"v":16600,"d":"16,600"},{"v":17980,"d":"17,980"},{"v":16730,"d":"16,730"},{"v":19426,"d":"19,426"},{"v":16099,"d":"16,099"},{"v":19939,"d":"19,939"},{"v":19235,"d":"19,235"},{"v":19645,"d":"19,645"},{"v":18316,"d":"18,316"},{"v":17650,"d":"17,650"},{"v":16780,"d":"16,780"}]
["Accumulated delivered Trip - Yearly",{"$nulls":5},{"v":15680,"d":"15,680"},{"v":32280,"d":"32,280"},{"v":50260,"d":"50,260"},{"v":66990,"d":"66,990"},{"v":86416,"d":"86,416"},{"v":102515,"d":"102,515"},{"v":106774,"d":"106,774"},{"v":109409,"d":"109,409"},{"v":111074,"d":"111,074"},{"v":112660,"d":"112,660"},{"v":110884,"d":"110,884"},{"v":111565,"d":"111,565"}]
["Accumulated delivered Trip - Quarterly",{"$nulls":5},{"v":50260,"d":"50,260"},null,null,{"v":52255,"d":"52,255"},null,null,{"v":58819,"d":"58,819"},null,null,{"v":52746,"d":"52,746"}]
["Total Number of Correctly Delivered Trip",{"$nulls":5},{"v":15656,"d":"15,656"},{"v":16559,"d":"16,559"},{"v":17978,"d":"17,978"},{"v":16730,"d":"16,730"},{"v":19425,"d":"19,425"},{"v":16098,"d":"16,098"},{"v":19939,"d":"19,939"},{"v":19233,"d":"19,233"},{"v":19644,"d":"19,644"},{"v":18316,"d":"18,316"},{"v":17650,"d":"17,650"},{"v":16780,"d":"16,780"}]
["Accumulated delivered Trip - Yearly (time)",{"$nulls":5},15656,32215,50193,66923,86348,102446,106729,109403,111069,112655,110880,111562]
["Accumulated delivered Trip - Quarterly (time)",{"$nulls":5},50193,null,null,52253,null,null,58816,null,null,52746]
["Part 3 Evaluation"]
["Performance",{"$nulls":5},2010,{"$nulls":5},2011]
[{"$nulls":6},"Jul","Aug","Sep","Oct","Nov","Dec","Jan","Feb","Mar","Apr","May","Jun"]
["Performance - monthly",{"$nulls":5},"Failed","Failed","Failed","Hit target","Failed","Failed","Hit target","Failed","Failed","Hit target","Hit target","Hit target"]
["Performance - Quarter",{"$nulls":7},"Failed",null,null,"Failed",null,null,"Failed",null,null,"Hit target"]
[]
["Part 4  Root cause analysis & Corrective Action"]
["No.","Root cause",{"$nulls":4},"Corrective Action",{"$nulls":5},"Timeline",null,null,"Person in charge"]

{"sheet":"1.3 on time","index":1,"n_rows":35,"n_cols":18,"rows_kept":35,"merged":[[0,0,0,17],[2,0,2,3],[2,4,2,7],[3,0,3,3],[3,4,3,7],[4,0,4,7],[5,0,5,7],[6,0,6,3],[6,4,6,7],[7,0,9,3],[7,6,7,7],[8,4,8,7],[9,6,9,7],[10,0,10,7],[11,0,11,7],[12,0,12,3],[12,4,12,7],[13,0,13,3],[13,4,13,7],[15,0,16,5],[15,6,15,11],[15,12,15,17],[17,0,17,5],[18,0,18,5],[18,6,18,7],[18,9,18,10],[18,12,18,13],[18,15,18,16],[19,0,19,5],[20,0,20,5],[21,0,21,5],[22,0,22,5],[23,0,23,5],[23,6,23,8],[23,9,23,11],[23,12,23,14],[23,15,23,17],[24,0,24,5],[25,0,25,5],[26,0,26,5],[26,6,26,8],[26,9,26,11],[26,12,26,14],[26,15,26,17],[28,0,29,5],[28,6,28,11],[28,12,28,17],[30,0,30,5],[31,0,31,5],[31,6,31,7],[31,9,31,10],[31,12,31,13],[31,15,31,16],[34,1,34,5],[34,6,34,11],[34,12,34,14],[34,15,34,17],[35,1,35,5],[35,6,35,11],[35,12,35,14],[35,15,35,17],[36,1,36,5],[36,6,36,11],[36,12,36,14],[36,15,36,17],[37,1,37,5],[37,6,37,11],[37,12,37,14],[37,15,37,17],[38,1,38,5],[38,6,38,11],[38,12,38,14],[38,15,38,17],[39,1,39,5],[39,6,39,11],[39,12,39,14],[39,15,39,17],[40,1,40,5],[40,6,40,11],[40,12,40,14],[40,15,40,17],[41,1,41,5],[41,6,41,11],[41,12,41,14],[41,15,41,17],[42,1,42,5],[42,6,42,11],[42,12,42,14],[42,15,42,17],[43,1,43,5],[43,6,43,11],[43,12,43,14],[43,15,43,17],[44,1,44,5],[44,6,44,11],[44,12,44,14],[44,15,44,17],[45,1,45,5],[45,6,45,11],[45,12,45,14],[45,15,45,17]],"headers":{"header":["","","Issue A7"],"footer":["Arranged By : Watchara Boonlon","FM - QSG - QMS - 2 - 0","Effective Date : 1 August 2010"]},"flags":["formulas_cached_only"]}
["Quality Objective Monitoring & Measurement"]
["Part 1  Details of Quality Objective & KPI",{"$nulls":7},"Part 4 Analysis of data"]
["Activity / Service",{"$nulls":3},"Group"]
["Transportation",{"$nulls":3},"LLC1"]
["Quality Objective / Purpose or Benefit"]
["Share this ratio and encourage to decrease for customer satisfaction."]
["Key performance indicator",{"$nulls":3},"Last Performance"]
["1.3 % On Time Delivery ",{"$nulls":4},97,"%"]
[{"$nulls":4},"Taget"]
[{"$nulls":5},100,"%"]
["Formular"]
["Total Number of On Time Delivered Trip x 100\nAccumulated delivered Trip"]
["frequency of monitoring",{"$nulls":3},"Frequency of measurement"]
["Monthly",{"$nulls":3},"Quarterly"]
["Part 2  Records of operation"]
["Performance",{"$nulls":5},2010,{"$nulls":5},2011]
[{"$nulls":6},"Jul","Aug","Sep","Oct","Nov","Dec","Jan","Feb","Mar","Apr","May","Jun"]
["Trends of Performance - Yearly",{"$nulls":5},{"v":99.84693877551021,"d":"99.85"},{"v":99.79863692688971,"d":"99.80"},{"v":99.866693195384,"d":"99.87"},{"v":99.89998507239886,"d":"99.90"},{"v":99.92131086835771,"d":"99.92"},{"v":99.931717309662,"d":"99.93"},{"v":99.95691835090939,"d":"99.96"},{"v":99.99542999204819,"d":"100.00"},{"v":99.9972990978987,"d":"100.00"},{"v":99.99733712053968,"d":"100.00"},{"v":99.99819631326432,"d":"100.00"},{"v":100,"d":"100.00"}]
["Performance - Quarterly",{"$nulls":7},{"v":99.866693195384,"d":"99.87"},null,null,{"v":99.99425892259114,"d":"99.99"},null,null,{"v":100,"d":"100.00"},null,null,{"v":100,"d":"100.00"}]
["Performance - Monthly",{"$nulls":5},{"v":99.84693877551021,"d":"99.85"},{"v":99.75301204819277,"d":"99.75"},{"v":99.9888765294772,"d":"99.99"},{"v":100,"d":"100.00"},{"v":99.99485225985792,"d":"99.99"},{"v":99.98757686812846,"d":"99.99"},{"v":100,"d":"100.00"},{"v":100,"d":"100.00"},{"v":100,"d":"100.00"},{"v":100,"d":"100.00"},{"v":100,"d":"100.00"},{"v":100,"d":"100.00"}]
["Target",{"$nulls":5},100,100,100,100,100,100,100,100,100,100,100,100]
["Accumulated delivered Trip",{"$nulls":5},{"v":15680,"d":"15,680"},{"v":16600,"d":"16,600"},{"v":17980,"d":"17,980"},{"v":16730,"d":"16,730"},{"v":19426,"d":"19,426"},{"v":16099,"d":"16,099"},{"v":19939,"d":"19,939"},{"v":19235,"d":"19,235"},{"v":19645,"d":"19,645"},{"v":18316,"d":"18,316"},{"v":17650,"d":"17,650"},{"v":16780,"d":"16,780"}]
["Accumulated delivered Trip - Yearly",{"$nulls":5},{"v":15680,"d":"15,680"},{"v":32280,"d":"32,280"},{"v":50260,"d":"50,260"},{"v":66990,"d":"66,990"},{"v":86416,"d":"86,416"},{"v":102515,"d":"102,515"},{"v":106774,"d":"106,774"},{"v":109409,"d":"109,409"},{"v":111074,"d":"111,074"},{"v":112660,"d":"112,660"},{"v":110884,"d":"110,884"},{"v":111565,"d":"111,565"}]
["Accumulated delivered Trip - Quarterly",{"$nulls":5},{"v":50260,"d":"50,260"},null,null,{"v":52255,"d":"52,255"},null,null,{"v":58819,"d":"58,819"},null,null,{"v":52746,"d":"52,746"}]
["Total Number of On Time Delivered Trip",{"$nulls":5},{"v":15656,"d":"15,656"},{"v":16559,"d":"16,559"},{"v":17978,"d":"17,978"},{"v":16730,"d":"16,730"},{"v":19425,"d":"19,425"},{"v":16097,"d":"16,097"},{"v":19939,"d":"19,939"},{"v":19235,"d":"19,235"},{"v":19645,"d":"19,645"},{"v":18316,"d":"18,316"},{"v":17650,"d":"17,650"},{"v":16780,"d":"16,780"}]
["Accumulated delivered Trip - Yearly (time)",{"$nulls":5},15656,32215,50193,66923,86348,102445,106728,109404,111071,112657,110882,111565]
["Accumulated delivered Trip - Quarterly (time)",{"$nulls":5},50193,null,null,52252,null,null,58819,null,null,52746]
["Part 3 Evaluation"]
["Performance",{"$nulls":5},2010,{"$nulls":5},2011]
[{"$nulls":6},"Jul","Aug","Sep","Oct","Nov","Dec","Jan","Feb","Mar","Apr","May","Jun"]
["Performance - monthly",{"$nulls":5},"Failed","Failed","Failed","Hit target","Failed","Failed","Hit target","Hit target","Hit target","Hit target","Hit target","Hit target"]
["Performance - Quarter",{"$nulls":7},"Failed",null,null,"Failed",null,null,"Hit target",null,null,"Hit target"]
[]
["Part 4  Root cause analysis & Corrective Action"]
["No.","Root cause",{"$nulls":4},"Corrective Action",{"$nulls":5},"Timeline",null,null,"Person in charge"]