{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["Objectives","SCO Data Request","Agenda W1 Current","Agenda W2 Future","1-SIPOC","2-TAKT","3-Equipment (OEE)","4-Inventory","5-Current State Map","6-Solution Selection Matrix","6-PP Input Template","7-Future State Map","7-(12) Month Plan","Printouts"],"not_rendered":{"charts":1,"images":11,"macros":1,"external_links":8,"defined_names":3026,"comments":9,"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":"Objectives","index":0,"n_rows":43,"n_cols":7,"rows_kept":43,"cut":false,"hidden":false,"merged":[[0,0,0,6],[3,0,21,0]]}
["VSM Objectives"]
["Supporting Information","Click","Input","Hours","Description","Output","Comments"]
[null,1,"ID family / die line, plant layout",4,"1.0 Build a detailed SIPOC map / select a VSM","SIPOC map","SIPOC steps = VSM steps"]
[null,2,"Mapping module"]
[null,3,"Qty shipped",2,"2.0 Define customer requirements - TAKT","TAKT time for the VSM","TAKT to balance equipment, calculate ADD, 12 months of data minimum"]
[null,4]
[null,5,"Scheduled hours, PAY factors",8,"3.0 Define equipment (OEE)","OEE calculations","Need asset nameplate information, rated speeds, DT data for 12 months"]
[null,6,"OEE training module / Excel calculator"]
[null,7,"Amount, type, $ value",8,"4.0 Define inventory","$, space, inventory time delay"]
[null,8]
[null,9,"SIPOC",4,"5.0 Map: Build process flows (including shipping/supplier logistics)"]
[null,10]
[null,11,"SIPOC",4,"5.1 Map: Build information flows"]
[null,12]
[null,13,"SIPOC",4,"5.2 Map: Create the time line"]
[null,14]
[null,15,null,4,"5.3 Complete the map"]
[null,16]
[null,17,null,4,"6.0 Prioritize opportunities / List projects in pipeline input file",null,"This pipeline input tab equals the fields required for the pipeline database"]
[null,18]
[null,19,null,8,"7.0 Map: Build the future state map & 12 month plan","Future state map, 12 month plan"]
[null,20]
[]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]

{"sheet":"SCO Data Request","index":1,"n_rows":45,"n_cols":2,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Shipment Data:"]
[null,"·        Shipments per week (or per day)"]
[null,"·        By Die description"]
[null,"·        By SKU description"]
[null,"·        Quantity (pallets)"]
[null,"·        Quantity per pallet"]
[null,"·        Ship to name"]
[null,"·        Ship to location"]
[null,"·        For the past (18) months"]
[]
[null,"Inventory:"]
[null,"·        Raw material"]
[null,"·        WIP"]
[null,"·        Finished goods"]
[null,"·        Quantity"]
[null,"·        Type (roll, pallet, etc.)"]
[null,"·        Valuation ($)"]
[null,"·        Location"]
[null,"·        Description"]
[null,"·        Die / SKU description"]
[null,"·        Current on-hand snap shot.  If the current snap shot is seasonally low … or seasonally high please provide a range on what multiplier to use (e.g. – 150% lower in summer, etc.)"]
[]
[null,"Routing information:"]
[null,"·        Routing steps (work centers) for each die"]
[null,"·        Description of SKU"]
[null,"·        Description of work center"]
[]
[null,"Equipment Data:"]
[null,"·        Name / workcenter name"]
[null,"·        Ideal run speed"]
[null,"·        Average run speed"]
[null,"·        Quantity, length of changeover"]
[null,"·        Quantity, duration of down time"]
[null,"·        Top reason codes for down time"]
[null,"·        Yield / scrap %’s"]
[null,"·        Main assets only – (9) months of data"]
[]
[null,"Personnel:"]
[null,"·        List of ‘learning leaders’ in all areas of the plant"]
[null,"·        Name, title, department, years of service"]
[null,"·        Organizational chart"]
[]
[null,"Other:"]
[null,"·        Any past Kaizen report outs / project report outs in the last (12) months"]

{"sheet":"Agenda W1 Current","index":2,"n_rows":45,"n_cols":15,"rows_kept":45,"cut":false,"hidden":false,"merged":[[3,14,10,14],[17,14,18,14],[0,0,0,14],[5,2,10,2],[13,2,16,2],[3,11,10,11],[13,11,16,11],[18,11,21,11],[13,14,16,14],[19,2,21,2],[3,5,10,5],[13,5,21,5],[3,8,10,8],[13,8,21,8],[3,2,4,2]]}
["VSM"]
["T","S","Day 1","T","S","Day 2","T","S","Day 3","T","S","Day 4","T","S","Day 5"]
["07:30:00",null,null,"07:30:00",null,null,"07:30:00",null,null,"07:30:00",null,null,"07:30:00"]
["08:00:00",null,"Opener / ice breaker / or Lean training overview","08:00:00",null,"Define equipment (OEE)","08:00:00",null,"Complete / finish any outstanding work in sections 1, 2, 3, or 4","08:00:00",null,"Create time line.  VA, NVA, delays & total lead time in transactional & manufacturing","08:00:00",null,"Build future state VSM"]
["08:30:00",null,null,"08:30:00",null,null,"08:30:00",null,null,"08:30:00",null,null,"08:30:00"]
["09:00:00",null,"Build SIPOC map\n- Waste walk","09:00:00",null,null,"09:00:00",null,null,"09:00:00",null,null,"09:00:00"]
["09:30:00",null,null,"09:30:00",null,null,"09:30:00",null,null,"09:30:00",null,null,"09:30:00"]
["10:00:00",null,null,"10:00:00",null,null,"10:00:00",null,null,"10:00:00",null,null,"10:00:00"]
["10:30:00",null,null,"10:30:00",null,null,"10:30:00",null,null,"10:30:00",null,null,"10:30:00"]
["11:00:00",null,null,"11:00:00",null,null,"11:00:00",null,null,"11:00:00",null,null,"11:00:00"]
["11:30:00",null,null,"11:30:00",null,null,"11:30:00",null,null,"11:30:00",null,null,"11:30:00"]
["12:00:00",null,null,"12:00:00",null,null,"12:00:00",null,null,"12:00:00",null,null,"12:00:00"]
["12:30:00",null,null,"12:30:00",null,null,"12:30:00",null,null,"12:30:00",null,null,"12:30:00"]
["13:00:00",null,"Define customer requirements - TAKT","13:00:00",null,"Define inventory","13:00:00",null,"Map process flows\nMap information flows\nTake 'before' pictures of the process","13:00:00",null,"Complete the (first pass) of the map","13:00:00",null,"Build 12 month plan"]
["13:30:00",null,null,"13:30:00",null,null,"13:30:00",null,null,"13:30:00",null,null,"13:30:00"]
["14:00:00",null,null,"14:00:00",null,null,"14:00:00",null,null,"14:00:00",null,null,"14:00:00"]
["14:30:00",null,null,"14:30:00",null,null,"14:30:00",null,null,"14:30:00",null,null,"14:30:00"]
["15:00:00",null,null,"15:00:00",null,null,"15:00:00",null,null,"15:00:00",null,null,"15:00:00",null,"Report Out"]
["15:30:00",null,null,"15:30:00",null,null,"15:30:00",null,null,"15:30:00",null,"Begin prioritization","15:30:00"]
["16:00:00",null,"Define equipment (OEE)","16:00:00",null,null,"16:00:00",null,null,"16:00:00",null,null,"16:00:00"]
["16:30:00",null,null,"16:30:00",null,null,"16:30:00",null,null,"16:30:00",null,null,"16:30:00"]
["17:00:00",null,null,"17:00:00",null,null,"17:00:00",null,null,"17:00:00",null,null,"17:00:00"]
[]
[null,null,"Course Timing:","Hours",null,"Daily deliverables from team:",null,null,"Daily deliverables from team:",null,null,"Daily deliverables from team:",null,null,"Daily deliverables from team:"]
[]
[null,null,"1.0 Build a detailed SIPOC map"]
[null,null,"2.0 Define customer requirements - TAKT"]
[null,null,"3.0 Define equipment (OEE)"]
[null,null,"4.0 Define inventory"]
[null,null,"5.0 Map: Build process flows"]
[null,null,"5.1 Map: Build information flows"]
[null,null,"5.2 Map: Create the time line"]
[null,null,"5.3 Complete the map"]
[null,null,"6.0 Prioritize opportunities"]
[null,null,"7.0 Map: Build the future state map & 12 month plan"]
[]
[null,null,"Simulation"]
[null,null,"Book Report"]
[null,null,".pptx Module"]
[null,null,"Teachback / Exercise"]
[]
[null,null,"Status"]
[null,null,"On schedule"]
[null,null,"Late"]
[null,null,"Missed"]

{"sheet":"Agenda W2 Future","index":3,"n_rows":45,"n_cols":9,"rows_kept":45,"cut":false,"hidden":false,"merged":[[0,0,0,8],[3,2,10,2]]}
["VSM"]
["T","S","Day 1","T","S","Day 2","T","S","Day 3"]
["07:30:00",null,null,"07:30:00",null,null,"07:30:00"]
["08:00:00",null,"Review current state map\nReview list of prioritized projects\nReview future state map\nComplete future state map (if needed)","08:00:00",null,"Write charters","08:00:00",null,"Build certificaton matrix (names, speciality areas)"]
["08:30:00",null,null,"08:30:00",null,null,"08:30:00"]
["09:00:00",null,null,"09:00:00",null,null,"09:00:00"]
["09:30:00",null,null,"09:30:00",null,null,"09:30:00"]
["10:00:00",null,null,"10:00:00",null,null,"10:00:00"]
["10:30:00",null,null,"10:30:00",null,null,"10:30:00"]
["11:00:00",null,null,"11:00:00",null,null,"11:00:00"]
["11:30:00",null,null,"11:30:00",null,null,"11:30:00"]
["12:00:00",null,null,"12:00:00",null,null,"12:00:00"]
["12:30:00",null,null,"12:30:00",null,null,"12:30:00"]
["13:00:00",null,null,"13:00:00",null,null,"13:00:00"]
["13:30:00",null,null,"13:30:00",null,"Populate project pipeline","13:30:00"]
["14:00:00",null,null,"14:00:00",null,null,"14:00:00"]
["14:30:00",null,null,"14:30:00",null,null,"14:30:00"]
["15:00:00",null,null,"15:00:00",null,null,"15:00:00"]
["15:30:00",null,null,"15:30:00",null,null,"15:30:00"]
["16:00:00",null,null,"16:00:00",null,null,"16:00:00"]
["16:30:00",null,null,"16:30:00",null,null,"16:30:00"]
["17:00:00",null,null,"17:00:00",null,null,"17:00:00"]
[]
[null,null,"Course Timing:",null,null,"Daily deliverables from team:",null,null,"Daily deliverables from team:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Simulation"]
[null,null,"Book Report"]
[null,null,".pptx Module"]
[null,null,"Teachback / Exercise"]
[]
[null,null,"Status"]
[null,null,"On schedule"]
[null,null,"Late"]
[null,null,"Missed"]

{"sheet":"1-SIPOC","index":4,"n_rows":43,"n_cols":7,"rows_kept":43,"cut":false,"hidden":false,"merged":[[0,0,0,6],[3,0,21,0]]}
["SIPOC"]
["Supporting Information","Click","Input",{"$f":"SUM(D5:D22)","v":1},"Exercise Description","Output","Comment"]
[null,1,"Process knowledge",0.1,"Define the start and end points of the process being evaluated",null,"This frames in the project"]
[null,2,"Markers, flip charts",null,"Have all teams build SIPOC on flip charts"]
[null,3,"Process knowledge, RCFA toolbox",0.1,"Recommend starting at process step.  Most practioners recommend identifing about 5 - 10 key steps.  Each step should be \"Action-Verb\"","list main steps "]
[null,4,null,0.1,"Add inputs (Things) needed for that step.  Mention 6-M's related to Fishbone.  Caution going too detailed or too broadly","Inputs - sources of variation"]
[null,5,null,0.1,"Add the outputs (things) - caution: some people confuse the outputs with their  attributes ","Outputs"]
[null,6,null,0.1,"Identify who provides the inputs - Keep specific as possible","Suppliers"]
[null,7,null,0.1,"Identify who (and their process step) gets the goods or services provided","Customers"]
[null,8,null,0.25,"All teams report out on their SIPOCs and what they learned"]
[null,9,null,0.25,"Invite the other teams to offer comments and offer coaching to all teams"]
[null,10,null,null,"Instruct all teams to record refined SIPOC in their storyboard","Updated Storyboard"]
[null,11,null," "," "]
[null,12,null,null,"WASTE WALK"]
[null,13,null," "," "]
[null,14,null,null,"Affinity voting on steps within process that present most opportunities"]
[null,15,null," "," "]
[null,16]
[null,17,null," "," "]
[null,18]
[null,19,null," "," "]
[null,20]
[]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]

{"sheet":"2-TAKT","index":5,"n_rows":45,"n_cols":8,"rows_kept":45,"cut":false,"hidden":false,"merged":[[8,5,10,7]]}
[]
["Available Time"]
[null,null,"# days worked per year",270]
[null,null,"# shifts per day",3]
[null,null,"Hours",{"$f":"D4*D3*8","v":6480}]
[null,null,"Mins",{"$f":"D5*60","v":388800}]
[null,null,"Seconds",{"$f":"D6*60","v":23328000}]
[]
[null,null,null,null,null,"Demand must be expressed as same unit of measure as available time"]
["Demand",877460,"(1Jan - 15May)",{"$f":"B10*2","v":1754920},"Cartons"]
[null,null,"ADD",{"$f":"D10/D3","v":6499.7037037037035},"Cartons"]
[]
[]
["TAKT"]
[null,"TAKT","Available Time",null,{"$f":"D7","v":23328000},"Secs",{"$f":"E15/E16","v":13.292913637088871},"Secs"]
[null,null,"Demand",null,{"$f":"D10","v":1754920},"Units"]
[]
[]
[null,null,"Cycle Time for (4) Cartons","Raw C/T","OEE","Net C/T","Net C/T","TAKT"]
[null,null,null,null,null,null,null,{"$f":"$G$15","v":13.292913637088871}]
[null,null,"ASI Laminator",{"$f":"C36","v":1.6666666666666667},0.3,{"$f":"G21-D21","v":3.8888888888888893},{"$f":"D21/E21","v":5.5555555555555562},{"$f":"$G$15","v":13.292913637088871}]
[null,null,"Expert Cutter",{"$f":"C40","v":1.6666666666666667},0.27400000000000002,{"$f":"G22-D22","v":4.4160583941605838},{"$f":"D22/E22","v":6.0827250608272507},{"$f":"$G$15","v":13.292913637088871}]
[null,null,"KLC Gluer",{"$f":"C45","v":0.83333333333333337},0.115,{"$f":"G23-D23","v":6.4130434782608701},{"$f":"D23/E23","v":7.2463768115942031},{"$f":"$G$15","v":13.292913637088871}]
[null,null,null,null,null,null,null,{"$f":"$G$15","v":13.292913637088871}]
[null,null,null,{"$f":"SUM(D20:D24)","v":4.166666666666667}]
[]
[]
["CYCLE TIME CALCS BELOW"]
["(4 up per sheet)"]
[]
["Laminator"]
[null,"Speed",500,"feet/minute"]
[null,"VMA Sheet size","58 3/4\""]
[null,null,5,"feet (rounding up)"]
[null,null,{"$f":"C32/C34","v":100},"Sheets / minute"]
[null,null,{"$f":"C35/60","v":1.6666666666666667},"Sheets / second"]
[]
["Cutter","Speed",6000,"Sheets / hour"]
[null,null,{"$f":"C38/60","v":100},"Sheets / minute"]
[null,null,{"$f":"C39/60","v":1.6666666666666667},"Sheets / second"]
[]
["Gluer","Speed",12000,"Cartons / hour"]
[null,null,{"$f":"C42/4","v":3000},"Handicap (cartons / hour)"]
[null,null,{"$f":"C43/60","v":50},"Cartons / minute"]
[null,null,{"$f":"C44/60","v":0.83333333333333337},"Cartons / second"]

{"sheet":"3-Equipment (OEE)","index":6,"n_rows":43,"n_cols":7,"rows_kept":43,"cut":false,"hidden":false,"merged":[[0,0,0,6],[3,0,21,0]]}
["OEE"]
["Supporting Information","Click","Input",{"$f":"SUM(D3:D22)","v":0},"Exercise Description","Output","Comments"]
[null,1,"OEE Excel Calculator",null,"Training / overview",null,"Customize the template based on needs of application"]
[null,2,"OEE Training Module"]
[null,3]
[null,4,"Nameplate run speeds",null,"Calculate performance","P %","Actual / ideal"]
[null,5,"Data to calculate avg. run speeds"]
[null,6]
[null,7,"Scheduled hours (lights on)",null,"Calculate availability","A %","Actual / ideal"]
[null,8,"Downtime data"]
[null,9,"Changeover data"]
[null,10]
[null,11]
[null,12]
[null,13,"Scrap data",null,"Calculate yield","Y %","Actual / ideal"]
[null,14,"Reject data"]
[null,15]
[null,16]
[null,17]
[null,18,null,null,"Calculate OEE","OEE %","P% * A% * Y%"]
[null,19]
[null,20]
[]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]

{"sheet":"4-Inventory","index":7,"n_rows":43,"n_cols":7,"rows_kept":43,"cut":false,"hidden":false,"merged":[[0,0,0,6],[3,0,21,0]]}
["Inventory"]
["Supporting Information","Click","Input",{"$f":"SUM(D5:D22)","v":0},"Exercise Description","Output","Comment"]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13,null," "," "]
[null,14]
[null,15,null," "," "]
[null,16]
[null,17,null," "," "]
[null,18]
[null,19,null," "," "]
[null,20]
[]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]

{"sheet":"5-Current State Map","index":8,"n_rows":82,"n_cols":40,"rows_kept":82,"cut":false,"hidden":false,"merged":[[2,0,4,4],[8,23,8,24],[38,38,38,39],[0,0,1,4]]}
["Instructions",null,null,null,null,null,"Denotes Entry Field",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,"VSM","Entire Facility"]
[]
["Value Stream Mapping Icons",null,null,null,null,null,"Widget Defined","Transactional Processes",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,"Operational Metrics"]
[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,null,null,null,null,"On time delivery"]
[null,null,null,null,null,null,"Lot Size",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,"# Complaints"]
[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,null,null,null,null,"Recordables"]
[null,null,null,null,null,null,"ADD"]
[null,null,null,null,null,null,null,"Type",null,"Email",null,"Job Jackets",null,"Job Jackets",null,null,null,null,null,null,null,null,null,null,"Read"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Summary",null,null,null,null,null,null,null,null,null,null,null,"Financial Metrics"]
[null,null,null,null,null,null,null,"Pieces",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"H10","v":"Pieces"},{"$f":"SUM(I10:T10)","v":0},null,null,null,null,null,null,null,null,null,null,null,"Scrap $"]
[null,null,null,null,null,null,null,"Days",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"H11","v":"Days"},{"$f":"SUM(I11:T11)","v":0}]
[null,null,null,null,null,null,null,"$'s",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"H12","v":"$'s"},{"$f":"SUM(I12:T12)","v":0}]
[null,null,null,null,null,null,null,null,"Define Specs",null,"Review Spec",null,"Quote",null,"Design",null,"Order Materials",null,"Schedule",null,"Create WOs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Transportation"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(Stock check)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Annual costs"]
[null,null,null,null,null,"Manning","# FTE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"G15","v":"# FTE"},{"$f":"SUM(I15:U15)","v":0}]
[null,null,null,null,null,null,"# Temps",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"G16","v":"# Temps"},0]
[null,null,null,null,null,null,"OT $ / Week",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"G28","v":"# Errors / Week"},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"G17","v":"OT $ / Week"},0]
[null,null,null,null,null,"Manning","Handoffs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"G23","v":"Screens Accessed"},0]
[null,null,null,null,null,null,"Approvals",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"G29","v":"Office Distance Ft"},0,null,null,null,null,null,null,null,null,null,null,"Warehousing"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"G24","v":"Outbound Email / Week"},0,null,null,null,null,null,null,null,null,null,null,null,"Annual costs"]
[]
[null,null,null,null,null,"Transactions","Screens Accessed"]
[null,null,null,null,null,null,"Outbound Email / Week"]
[null,null,null,null,null,null,"Inbound Email / Week",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,"Inventory Turns"]
[null,null,null,null,null,null,"Email hours / Week",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"G25","v":"Inbound Email / Week"},{"$f":"SUM(I26:U26)","v":0},null,null,null,null,null,null,null,null,null,null,null,"Annual Sales"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"G26","v":"Email hours / Week"},{"$f":"SUM(I27:U27)","v":0},null,null,null,null,null,null,null,null,null,null,null,"Total Inventory $'s"]
[null,null,null,null,null,"Other","# Errors / Week",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"G19","v":"Handoffs"},{"$f":"SUM(I28:U28)","v":0}]
[null,null,null,null,null,null,"Office Distance Ft",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"G20","v":"Approvals"},{"$f":"SUM(I29:U29)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(I30:U30)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Totals"]
[null,null,null,null,null,null,"Mins","VA",1,null,2,null,3,null,12,null,2,null,0.5,null,0.5,null,null,{"$f":"SUM(I33:V33)","v":21},"Mins"]
[null,null,null,null,null,null,"Hrs","NVA",null,null,null,null,null,null,3,null,4,null,0.5,null,0.5,null,null,{"$f":"SUM(I34:V34)","v":8},"Hrs"]
[null,null,null,null,null,null,"Days","Delay",null,8,null,16,null,60,null,8,null,{"$f":"6*7*8","v":336},null,1,null,1,null,{"$f":"SUM(I35:V35)","v":430},"Days"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Widget Defined",null,"Manufacturing Processes",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,"Summary"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Delivery schedules",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Shipping schedules"]
[null,null,null,null,null,null,null,null,null,null,"Lot Size"]
[null,null,null,null,null,null,null,null,null,null,null,"Inventory"]
[null,null,null,null,null,null,null,null,null,null,"ADD","Type",null,"Rolls","Ink","Corrugated","Sheets",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RM","WIP","FG"]
[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,null,null,null,null,null,null,null,"Read"]
[null,null,null,null,null,null,null,null,null,null,null,"Pieces",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,{"$f":"L45","v":"Pieces"},{"$f":"SUM(N45:AK45)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Days",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,{"$f":"L46","v":"Days"},{"$f":"SUM(N46:AK46)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"$'s",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,{"$f":"L47","v":"$'s"},{"$f":"SUM(N47:AK47)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fab",null,"Machine",null,"Weld",null,"Hydro/Dip",null,"Vessel Assy",null,"Paint",null,"Ready to Ship"]
[]
[null,null,null,null,null,null,null,null,null,null,"Manning","# FTE",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,{"$f":"L50","v":"# FTE"},{"$f":"SUM(U50:AK50)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"# Temps",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,{"$f":"L51","v":"# Temps"},0]
[null,null,null,null,null,null,null,null,null,null,null,"OT $ / Week",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,"OT $ / Week",0]
[null,null,null,null,null,null,null,null,null,null,null,"# Shifts",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,"# Shifts",0]
[null,null,null,null,null,null,null,null,null,null,"Equipment",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,0,0]
[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,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,"Perf","Ideal speed",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,"Ideal speed",0]
[null,null,null,null,null,null,null,null,null,null,null,"Avg. Run Speed",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,"Avg. Run Speed",0]
[null,null,null,null,null,null,null,null,null,null,null,"P %",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,"P %",0]
[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,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,"Avail","DT Hrs",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,"DT Hrs",0]
[null,null,null,null,null,null,null,null,null,null,null,"CO Hrs",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,"CO Hrs",0]
[null,null,null,null,null,null,null,null,null,null,null,"A %",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,"A %",0]
[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,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,"# CO's / Week","Major",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,"# CO's / Week",0]
[null,null,null,null,null,null,null,null,null,null,null,"CO Time","Major",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,"CO Time",0]
[null,null,null,null,null,null,null,null,null,null,null,"# CO's / Week","Minor",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,"# CO's / Week",0]
[null,null,null,null,null,null,null,null,null,null,null,"CO Time","Minor",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,"CO Time",0]
[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,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,"Yield","Scrap %",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,"Scrap %",0]
[null,null,null,null,null,null,null,null,null,null,null,"Scrap $",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,"Scrap $",0]
[null,null,null,null,null,null,null,null,null,null,null,"Y %",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,"Y %",0]
[null,null,null,null,null,null,null,null,null,null,"OEE",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,0,0]
[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,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,"Other"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Units",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Units",null,"Mfg","Trans",null,"Total"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mins","VA (C/T)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mins",null,{"$f":"SUM(U79:AG79)","v":0},{"$f":"X33","v":21},null,{"$f":"AK79+AL79","v":21}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hrs","NVA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hrs",null,{"$f":"SUM(U80:AG80)","v":0},{"$f":"X34","v":8},null,{"$f":"AK80+AL80","v":8}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Days","Delay",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Days",null,{"$f":"SUM(U81:AG81)","v":0},{"$f":"X35","v":430},null,{"$f":"AK81+AL81","v":430}]
[null,null,null,null,null,null,null,null,null,null,null,"Distance Ft"]

{"sheet":"6-Solution Selection Matrix","index":9,"n_rows":51,"n_cols":15,"rows_kept":51,"cut":false,"hidden":false,"merged":[[0,2,0,7],[0,8,0,11]]}
[null,null,"BENEFIT",null,null,null,null,null,"EFFORT"]
[null,"BRAINSTORMED SOLUTIONS/PROJECT IDEAS","Net Income","Strategic Benefit 1","Strategic Benefit 2","Cash Flow","Revenue Growth","TOTAL BENEFIT","Personnel Requirements","Capital Expenditure Requirements","Project Risk (Low, Medium, High)","TOTAL EFFORT","Benefit / Effort","Benefit - Effort","RECOMMENDED PRIORITY"]
["#","Importance Weighting:",0.3,null,null,0.6,0.1,{"$f":"SUM(C3:G3)","v":0.99999999999999989},0.2,0.7,0.1,{"$f":"SUM(I3:K3)","v":0.99999999999999989}]
["1",null,null,null,null,null,null,{"$f":"SUMPRODUCT(C4:G4,$C$3:$G$3)","v":0},null,null,null,{"$f":"SUMPRODUCT(I4:K4,$I$3:$K$3)","v":0},{"$f":"IF(L4=0,0,H4/L4)","v":0},{"$f":"H4-L4","v":0}]
["2",null,null,null,null,null,null,0,null,null,null,0,0,0]
["3",null,null,null,null,null,null,0,null,null,null,0,0,0]
["4",null,null,null,null,null,null,0,null,null,null,0,0,0]
["5",null,null,null,null,null,null,0,null,null,null,0,0,0]
["6",null,null,null,null,null,null,0,null,null,null,0,0,0]
["8",null,null,null,null,null,null,0,null,null,null,0,0,0]
["9",null,null,null,null,null,null,0,null,null,null,0,0,0]
["10",null,null,null,null,null,null,0,null,null,null,0,0,0]
["11",null,null,null,null,null,null,0,null,null,null,0,0,0]
["12",null,null,null,null,null,null,0,null,null,null,0,0,0]
["13",null,null,null,null,null,null,0,null,null,null,0,0,0]
["14",null,null,null,null,null,null,0,null,null,null,0,0,0]
["15",null,null,null,null,null,null,0,null,null,null,0,0,0]
["16",null,null,null,null,null,null,0,null,null,null,0,0,0]
["17",null,null,null,null,null,null,0,null,null,null,0,0,0]
[]
[null,"Valuation Parameters"]
[null,null,null,"(see direction tab for detail)"]
[null,"Net Income:"]
[null,"1 = Net Income impact of less than $25K"]
[null,"3 = Net Income impact of between $25K to $100K"]
[null,"9 = Net Income impact of greater than $100K"]
[]
[null,"Cash Flow:"]
[null,"1 = $25K improvement in Cash Flow"]
[null,"3 = $25K to $50K improvement in Cash Flow"]
[null,"9 = Greater than $50K improvement in Cash Flow"]
[]
[null,"Revenue Growth:"]
[null,"1 = Less than a 1% improvement in Revenue Growth"]
[null,"3 = 1% to 3% improvement in Revenue Growth"]
[null,"9 = Greater than a 3% improvement in Revenue Growth"]
[]
[null,"People Resource Requirements:"]
[null,"1 = 240 or fewer people hours. For example, 1 week Kaizen Event with 6 people (not including preparation & follow-up work)"]
[null,"3 = 240 to 520 people hours"]
[null,"9 = More than 520 people hours"]
[]
[null," Capital Expenditure Requirements:"]
[null,"1 = Less than $25K"]
[null,"3 = Between $25K and $100K"]
[null,"9 = Greater than $100K"]
[]
[null,"Idea/Project Risk"]
[null,"1 = Low"]
[null,"3 = Medium"]
[null,"9 = High"]

{"sheet":"6-PP Input Template","index":10,"n_rows":81,"n_cols":21,"rows_kept":81,"cut":false,"hidden":false,"merged":[[1,0,1,12],[1,13,1,20],[2,0,2,1],[2,7,2,9],[2,10,2,12]]}
[]
["1 - Enter and prioritize a new project",null,null,null,null,null,null,null,null,null,null,null,null,"4 - Enter Project Savings"]
["Project Name",null,null,null,null,null,null,"Benefit",null,null,"Effort"]
["Project Area","Project Name","Plant","Problem Statement","Alignment","Estimated Annual Savings","Financial Assumptions","Net Income","Cash Flow","P-A-Y:OEE","Personnel Requirements","Capital Expenditures","Risk","Primary Metric","Project Type","Primary Tool","Owner","Champion","Estimated Annual Savings","Replication Opportunity Exists","Tools & Standard Work used"]
[null,"Certify_Kaizen Facilitators",null,null,null,21000,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"F5","v":21000}]
[null,"Certify 5 to 7 RCFA Analysts",null,null,null,21000,null,null,null,null,null,null,null,null,null,null,null,null,21000]
[null,"Certify 5 to 7 ToyotaKata Coaches",null,null,null,6000,null,null,null,null,null,null,null,null,null,null,null,null,6000]
[null,"Certify 8 to 12 SMED Experts",null,null,null,17500,null,null,null,null,null,null,null,null,null,null,null,null,17500]
[null,"Certify_5s/Visual Experts",null,null,null,4000,null,null,null,null,null,null,null,null,null,null,null,null,4000]
[null,"Certified Print Crews",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Certified Cutter Crews",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Certified Gluer Crews",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"3P Ideal Layout",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Consolidate one or more locations",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[]
["Drop Down Lists"]
[]
["Project Area",null,"Plant",null,"Alignment",null,null,"Net Income","Cash Flow","P-A-Y:OEE","Personnel Requirements","Capital Expenditures","Risk","Primary Metric","Project Type","Primary Tool"]
[]
["Customer Service",null,"Baldwinsville",null,"1. Design and build an information systems infrastructure that supports our operating processes",null,null,"0 - None","0 - None","0 - None","0 - None","0 - None","1 - Low (easy to train, easy to gain acceptance)","Cycle Time","1. Just-Do-It","3P"]
["Scheduling",null,"Greensboro",null,"2. Create a process to increase sustainability by driving energy reduction",null,null,"1 - Impact of less than $25K","1 - Impact of less than $25K","1 - Less than 3% improvement","1 - 240 or fewer people hours","1 - Less than $5K","3 - Medium","Down time","2. Work Out","5 Why's"]
["Planning",null,"Hamilton",null,"3. Create a platform to drive innovation from identification through implementation",null,null,"3 - Impact of between $25K and $50K","3 - Impact of between $25K and $50K","3 - 3% to 5% improvement","3 - 240 to 520 people hours","3 - Between $5K and $25K","9 - High (difficult to train, hard to gain acceptance)","Change over","3. SCORE","5s"]
["Purchasing",null,"Kansas City",null,"4. Implement a strategically aligned and dynamic packaging sales pipeline management process",null,null,"9 - Impact of greater than $50K","9 - Impact of greater than $50K","9 - Greater than 5% improvement","9 - More than 520 people hours","9 - Greater than $25K",null,"Raw Materials: Scrap / Waste","4. RCFA","Affinity Diagram"]
["Sheeting",null,"Montreal",null,"5. Create and implement company wide, “World Class” operating processes",null,null,null,null,null,null,null,null,"Defective Parts","5. DMAIC","Autonomous Maintenance"]
["Printing",null,"Hastings",null,"6. Create a value focused packaging sales organization",null,null,null,null,null,null,null,null,"Labor","6. Project","Brainstorming"]
["Cutting",null,"Philadelphia Mill",null,"7. Engage the entire organization to create a single high performance culture",null,null,null,null,null,null,null,null,"Supplies / Expenses",null,"Cellular design"]
["Glueing",null,"Alexandria",null,null,null,null,null,null,null,null,null,null,"Inventory (WIP, FG)",null,"Cross training matrix"]
["Laminating",null,null,null,null,null,null,null,null,null,null,null,null,"Transactional",null,"Daily management"]
["Windowing",null,null,null,null,null,null,null,null,null,null,null,null,"Lead time",null,"Data Collection Plan"]
["Mill: Pulp Prep",null,null,null,null,null,null,null,null,null,null,null,null,"Complaints / Returns",null,"Fishbone diagram "]
["Mill: Wet End",null,null,null,null,null,null,null,null,null,null,null,null,"Safety Improvement",null,"FMEA"]
["Mill: Forming",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gantt Chart"]
["Mill: Drying",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Histogram/Bar Chart"]
["Mill: Coating",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kanban "]
["Mill: Wind-Up",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Leader standard work"]
["Mill: Slitting / Rewind",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mind Mapping"]
["Warehouse",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mistake proofing "]
["Shipping",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OEE calculation"]
["Facilities",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pareto analysis "]
["Invoicing",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pivot tables "]
["Finance",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Prioritization Matrix"]
["Other",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RACI Chart"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Scatter Diagram"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Separation of person / machine"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SIPOCr "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SMED"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Spaghetti diagram "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Standard work"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Swim lane map "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TAKT - line of balance "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TPM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VSM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Why-Because"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WORMPIIT form "]
[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,"DOE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fault Tree Analysis"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Heijunka "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Policy deployment"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"QFD "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Stakeholder analysis "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Strategic SVSM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TRIZ"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OTHER"]

{"sheet":"7-Future State Map","index":11,"n_rows":82,"n_cols":40,"rows_kept":82,"cut":false,"hidden":false,"merged":[[0,0,1,4],[2,0,4,4],[8,23,8,24],[38,38,38,39]]}
["Instructions",null,null,null,null,null,"Denotes Entry Field",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,"VSM","Entire Facility"]
[]
["Value Stream Mapping Icons",null,null,null,null,null,"Widget Defined","Transactional Processes",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,"Operational Metrics"]
[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,null,null,null,null,"On time delivery"]
[null,null,null,null,null,null,"Lot Size",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,"# Complaints"]
[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,null,null,null,null,"Recordables"]
[null,null,null,null,null,null,"ADD"]
[null,null,null,null,null,null,null,"Type",null,"Email",null,"Job Jackets",null,"Job Jackets",null,null,null,null,null,null,null,null,null,null,"Read"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Summary",null,null,null,null,null,null,null,null,null,null,null,"Financial Metrics"]
[null,null,null,null,null,null,null,"Pieces",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"H10","v":"Pieces"},{"$f":"SUM(I10:T10)","v":0},null,null,null,null,null,null,null,null,null,null,null,"Scrap $"]
[null,null,null,null,null,null,null,"Days",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"H11","v":"Days"},{"$f":"SUM(I11:T11)","v":0}]
[null,null,null,null,null,null,null,"$'s",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"H12","v":"$'s"},{"$f":"SUM(I12:T12)","v":0}]
[null,null,null,null,null,null,null,null,"Define Specs",null,"Review Spec",null,"Quote",null,"Design",null,"Order Materials",null,"Schedule",null,"Create WOs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Transportation"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(Stock check)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Annual costs"]
[null,null,null,null,null,"Manning","# FTE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"G15","v":"# FTE"},{"$f":"SUM(I15:U15)","v":0}]
[null,null,null,null,null,null,"# Temps",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"G16","v":"# Temps"},0]
[null,null,null,null,null,null,"OT $ / Week",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"G28","v":"# Errors / Week"},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"G17","v":"OT $ / Week"},0]
[null,null,null,null,null,null,"Handoffs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"G23","v":"Screens Accessed"},0]
[null,null,null,null,null,null,"Approvals",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"G29","v":"Office Distance Ft"},0,null,null,null,null,null,null,null,null,null,null,"Warehousing"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"G24","v":"Outbound Email / Week"},0,null,null,null,null,null,null,null,null,null,null,null,"Annual costs"]
[]
[null,null,null,null,null,"Transactions","Screens Accessed"]
[null,null,null,null,null,null,"Outbound Email / Week"]
[null,null,null,null,null,null,"Inbound Email / Week",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,"Inventory Turns"]
[null,null,null,null,null,null,"Email hours / Week",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"G25","v":"Inbound Email / Week"},{"$f":"SUM(I26:U26)","v":0},null,null,null,null,null,null,null,null,null,null,null,"Annual Sales"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"G26","v":"Email hours / Week"},{"$f":"SUM(I27:U27)","v":0},null,null,null,null,null,null,null,null,null,null,null,"Total Inventory $'s"]
[null,null,null,null,null,"Other","# Errors / Week",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"G19","v":"Handoffs"},{"$f":"SUM(I28:U28)","v":0}]
[null,null,null,null,null,null,"Office Distance Ft",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"G20","v":"Approvals"},{"$f":"SUM(I29:U29)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(I30:U30)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Totals"]
[null,null,null,null,null,null,"Mins","VA",1,null,2,null,3,null,12,null,2,null,0.5,null,0.5,null,null,{"$f":"SUM(I33:V33)","v":21},"Mins"]
[null,null,null,null,null,null,"Hrs","NVA",null,null,null,null,null,null,3,null,4,null,0.5,null,0.5,null,null,{"$f":"SUM(I34:V34)","v":8},"Hrs"]
[null,null,null,null,null,null,"Days","Delay",null,8,null,16,null,60,null,8,null,{"$f":"6*7*8","v":336},null,1,null,1,null,{"$f":"SUM(I35:V35)","v":430},"Days"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Widget Defined",null,"Manufacturing Processes",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,"Summary"]
[]
[null,null,null,null,null,null,null,null,null,null,"Lot Size"]
[null,null,null,null,null,null,null,null,null,null,null,"Inventory"]
[null,null,null,null,null,null,null,null,null,null,"ADD","Type",null,"Rolls","Ink","Corrugated","Sheets",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RM","WIP","FG"]
[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,null,null,null,null,null,null,null,"Read"]
[null,null,null,null,null,null,null,null,null,null,null,"Pieces",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,{"$f":"L45","v":"Pieces"},{"$f":"SUM(N45:AK45)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Days",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,{"$f":"L46","v":"Days"},{"$f":"SUM(N46:AK46)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"$'s",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,{"$f":"L47","v":"$'s"},{"$f":"SUM(N47:AK47)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fab",null,"Machine",null,"Weld",null,"Hydro/Dip",null,"Vessel Assy",null,"Paint",null,"Ready to Ship"]
[]
[null,null,null,null,null,null,null,null,null,null,"Manning","# FTE",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,{"$f":"L50","v":"# FTE"},{"$f":"SUM(U50:AK50)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"# Temps",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,{"$f":"L51","v":"# Temps"},0]
[null,null,null,null,null,null,null,null,null,null,null,"OT $ / Week",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,"OT $ / Week",0]
[null,null,null,null,null,null,null,null,null,null,null,"# Shifts",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,"# Shifts",0]
[null,null,null,null,null,null,null,null,null,null,"Equipment",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,0,0]
[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,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,"Perf","Ideal speed",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,"Ideal speed",0]
[null,null,null,null,null,null,null,null,null,null,null,"Avg. Run Speed",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,"Avg. Run Speed",0]
[null,null,null,null,null,null,null,null,null,null,null,"P %",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,"P %",0]
[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,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,"Avail","DT Hrs",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,"DT Hrs",0]
[null,null,null,null,null,null,null,null,null,null,null,"CO Hrs",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,"CO Hrs",0]
[null,null,null,null,null,null,null,null,null,null,null,"A %",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,"A %",0]
[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,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,"# CO's / Week","Major",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,"# CO's / Week",0]
[null,null,null,null,null,null,null,null,null,null,null,"CO Time","Major",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,"CO Time",0]
[null,null,null,null,null,null,null,null,null,null,null,"# CO's / Week","Minor",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,"# CO's / Week",0]
[null,null,null,null,null,null,null,null,null,null,null,"CO Time","Minor",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,"CO Time",0]
[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,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,"Yield","Scrap %",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,"Scrap %",0]
[null,null,null,null,null,null,null,null,null,null,null,"Scrap $",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,"Scrap $",0]
[null,null,null,null,null,null,null,null,null,null,null,"Y %",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,"Y %",0]
[null,null,null,null,null,null,null,null,null,null,"OEE",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,0,0]
[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,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,"Other"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Units",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Units",null,"Mfg","Trans",null,"Total"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mins","VA (C/T)",5,null,2,null,10,null,1,null,1,null,0.5,null,0.5,null,"Mins",null,{"$f":"SUM(U79:AG79)","v":20},{"$f":"X33","v":21},null,{"$f":"AK79+AL79","v":41}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hrs","NVA",10,null,3,null,10,null,2,null,2,null,2,null,1,null,"Hrs",null,{"$f":"SUM(U80:AG80)","v":30},{"$f":"X34","v":8},null,{"$f":"AK80+AL80","v":38}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Days","Delay",null,4,null,4,null,8,null,4,null,4,null,8,null,null,"Days",null,{"$f":"SUM(U81:AG81)","v":32},{"$f":"X35","v":430},null,{"$f":"AK81+AL81","v":462}]
[null,null,null,null,null,null,null,null,null,null,null,"Distance Ft"]

{"sheet":"7-(12) Month Plan","index":12,"n_rows":33,"n_cols":14,"rows_kept":33,"cut":false,"hidden":false,"merged":[[21,2,23,4],[24,5,26,7],[27,8,29,10],[30,11,32,13]]}
[null,"Brainstormed Ideas/Project Descriptions which Support  the High-Level Business Goals","Estimated Impact on Goal #1","Estimated Impact on Goal #2","Estimated Impact on Goal #3","Actual Impact on Goal #1","Actual Impact on Goal #2","Actual Impact on Goal #3"]
[1,"Project 1",0,0,0]
[2,"Project 2",0,0,0]
[3,"Project 3",0,0,0]
[4,"Project 4",0,0,0]
[5,"Project 5",0,0,0]
[6,"Project 6",0,0,0]
[7,"Project 7",0,0,0]
[8,"Project 8",0,0,0]
[9,"Project 9",0,0,0]
[10,"Project 10",0,0,0]
[11,"Project 11",0,0,0]
[12,"Project 12",0,0,0]
[]
[null,"Estimated Current Year Impact =",{"$f":"SUM(C2:C14)","v":0},{"$f":"SUM(D2:D14)","v":0},{"$f":"SUM(E2:E14)","v":0}]
[]
[null,"Target = ",0,0,0]
[]
[]
[null,null,"Implementation Project Timing"]
[null,null,"January","February","March","April","May","June","July","August","September","October","November","December"]
[null,"Project 1","A project started on 1 January and completed in 3 months may only have 9 months worth of impact"]
[null,"Project 2"]
[null,"Project 3"]
[null,"Project 4",null,null,null,"A project started on 1 April and completed in 3 months may only have 6 months worth of impact"]
[null,"Project 5"]
[null,"Project 6"]
[null,"Project 7",null,null,null,null,null,null,"A project started on 1 July and completed in 3 months may only have 3 months worth of impact"]
[null,"Project 8"]
[null,"Project 9"]
[null,"Project 10",null,null,null,null,null,null,null,null,null,"A project started on 1 October and completed in 3 months may not have any impact this year"]
[null,"Project 11"]
[null,"Project 12"]

{"sheet":"Printouts","index":13,"n_rows":37,"n_cols":16,"rows_kept":37,"cut":false,"hidden":false,"merged":[[30,15,30,16],[31,15,31,16],[2,1,2,2],[6,6,6,8],[6,12,6,14],[35,3,35,4],[36,3,36,4],[30,9,30,10],[31,9,31,10]]}
[]
[]
[null,"Equipment",null,"Step #"]
[null,"Manning"]
[null,null,"# FTE"]
[null,null,"# Temps"]
[null,null,null,null,null,null,"PC Operations",null,null,"Step #",null,null,"Manual Operations",null,null,"Step #"]
[null,"Performance","Ideal speed",null,null,null,null,"Manning",null,null,null,null,null,"Manning"]
[null,null,"Avg. Run Speed",null,null,null,null,null,"# FTE",null,null,null,null,null,"# FTE"]
[null,null,"P %",null,null,null,null,null,"# Temps",null,null,null,null,null,"# Temps"]
[]
[null,"Availability","Available Hrs",null,null,null,null,null,"Handoffs",null,null,null,null,null,"Handoffs"]
[null,null,"DT Hrs",null,null,null,null,null,"Approvals",null,null,null,null,null,"Approvals"]
[null,null,"CO Hrs"]
[null,null,"A %",null,null,null,null,"Transactions","Screens Accessed",null,null,null,null,null,"# Errors / Week"]
[null,null,null,null,null,null,null,null,"Outbound Email / Week",null,null,null,null,null,"Office Distance Ft"]
[null,null,"Major # CO's / Week",null,null,null,null,null,"Inbound Email / Week"]
[null,null,"CO Time",null,null,null,null,null,"Email hours / Week",null,null,null,null,"Other"]
[null,null,"Minor # CO's / Week"]
[null,null,"CO Time",null,null,null,null,null,"# Errors / Week"]
[null,null,null,null,null,null,null,null,"Office Distance Ft"]
[null,"Yield","Scrap %"]
[null,null,"Scrap $",null,null,null,null,"Other"]
[null,null,"Y %"]
[null,"OEE"]
[]
[null,"Other",null,null,null,null,null,"Mins","VA (C/T)",null,null,null,null,"Mins","VA (C/T)"]
[null,null,null,null,null,null,null,"Hrs","NVA",null,null,null,null,"Hrs","NVA"]
[null,null,null,null,null,null,null,"Days","Delay",null,null,null,null,"Days","Delay"]
[]
[null,null,null,null,null,null,null,null,"Step Distance Traveled",null,null,null,null,null,"Step Distance Traveled"]
[null,"Mins","VA (C/T)",null,null,null,null,null,"Cumulative Distance Traveled",null,null,null,null,null,"Cumulative Distance Traveled"]
[null,"Hrs","NVA"]
[null,"Days","Delay"]
[]
[null,null,"Step Distance Traveled"]
[null,null,"Cumulative Distance Traveled"]