{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["C2 Instructions","C2 System Level Capacity","C2 Example","C3 Instructions","Worksheet by Shift","C3 Constraint Capacity","C3 Example"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":6,"comments":3,"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":"C2 Instructions","index":0,"n_rows":57,"n_cols":1,"rows_kept":57,"cut":false,"hidden":true,"merged":[]}
["The purpose of this sheet is to analyze the operations and determine any Constraints within the System Level Analysis."]
[]
["A Constraint is defined as the operation with highest utilization in the Production Line.  "]
["A Concern Constraint is any operation where the utilization is over 85%"]
["A Problem Constraint is any operation where the utilization is over 90%. "]
[]
["This sheet is to be used to estimate the capacity at the system level.  "]
["It should be noted that this spreadsheet provides an initial estimate only as it ignores all interactions between component lines."]
["Please input data into NON-SHADED cells only.  The shaded cells are calculated automatically and are password protected."]
["Some column headings have comments associated with them in order to explain the headings better which show up as little red marks on the top right hand corner of the cell they are associated with.  "]
["To view the comment, point the mouse at the cell (or the red mark) and hover.  There is no need to click on the field to see the comment."]
["There are four sheets in this workbook."]
["C2 Instructions "]
["C2 System Level Capacity "]
["C2 Example - an example of what a completed System Level Capacity Estimate looks like."]
[]
[]
["Description of NON-Calculating Input Data fields in this capacity estimation tool:"]
["Supplier Name:  input the name & location of supplier production for this part."]
["Part(s) Name: input the part name based on the part contract.  When the sheet applies to multiple parts, specify name of all the parts."]
["Part(s) Number: input the Allison's part number (not the supplier's internal part number).  "]
["When the sheet applies to multiple (family) parts, specify number of all the parts, starting with the part with the highest production quantity and ending with the part with the lowest quantity."]
["Working Days per Year:  input the number of working days per year the supplier operates as agreed upon in the contract."]
["Contracted Capacity : input the CONTRACTED yearly and daily capacity.  "]
["CONTRACTED CAPACITY SHOULD BE YEARLY CAPACITY/WORKING DAYS PER YEAR"]
["Increased Contracted Capacity: input the increased CONTRACTED yearly and daily capacity.  "]
["INCREASED CONTRACTED CAPACITY SHOULD BE YEARLY CAPACITY/WORKING DAYS PER YEAR"]
[]
[]
["Production System: input each separate production/or operation line separately."]
[]
["System Availability - Where there is no value to enter in each field, enter a 0."]
["Shifts per Week: input the number of working shifts per week for this production line."]
["Shifts per Day: input the number of working shifts per day for this production line."]
["Minutes per shift: input the number of total minutes per shift for this production line."]
["Scheduled Breaks: input in minutes the time spent PER DAY for breaks, lunches, meetings, any other scheduled breaks on this production line if production stops during these events."]
["Changeovers/Tool change: input in minutes the time spent PER DAY for tool changes, setups on this production line, if production stops during tool changes & setups."]
["Planned Maintenance: input in minutes the time spent PER DAY for planned/scheduled maintenance on this production line."]
["Unscheduled Downtime: input an ESTIMATE in minutes the time spent PER DAY for all UNSCHEDULED downtime (breakdowns) in this production line."]
[]
["System Capacity - Where there is no value to enter in each field, enter a 0."]
["Time allocated for other customers: input the total time (in minutes) allocated for other customers on this production line."]
["The definition of \"other customers\" includes all production for other products designated for Allison, which are not reflected in this Capacity Estimate."]
["Line Cycle Time Per Part:  input the cycle time of the line in SECONDS PER PART.  "]
["NOTE - If the final operation of the line produces more than one part per cycle, the Line Cycle time should be calculated by dividing the observed cycle time by the number of parts produced per cycle."]
["Buffer Before/After Operation"]
["% Scrap:  input the scrap rate for this production line (enter as percentage, not fraction. Example: enter a 5% scrap rate as 5 not 0.05)."]
["CONTRACTED parts/day:  input NEWLY contracted parts PER DAY which includes service parts requirement."]
["RESULT - Where the Utilization is greater than 90%, a red X will appear in the Result Column.  This identifies the Problem Constraint Operations."]
["RESULT - Where the Utilization is greater than 85%, a yellow triangle ▲ will appear in the Result Column.  This identifies the Concern Constraint Operations."]
[]
[]
["Actual Run at Rate Study Results"]
["Run at Rate Actual OK parts produced: input the number of OK parts produced during the run at rate study."]
["Available Capacity > Contracted Capacity: If the available capacity of the system is greater than the contracted capacity, input \"YES\", otherwise input \"NO\"."]
["Run at Rate Actual Scrap: input the number of parts scrapped during the run at rate study."]
["Run at Rate Actual Downtime: input the downtime in minutes during the run at rate study."]

{"sheet":"C2 System Level Capacity","index":1,"n_rows":37,"n_cols":33,"rows_kept":37,"cut":false,"hidden":true,"merged":[[3,2,3,6],[3,17,3,19],[3,22,3,27],[0,2,0,6],[1,2,1,6],[2,2,2,6],[2,17,2,19],[2,22,2,27],[4,3,4,4],[4,17,4,19],[4,22,4,27],[5,3,5,4],[5,17,5,19],[5,22,5,27],[31,0,31,27],[32,0,32,27],[33,0,33,27],[7,0,7,1],[7,2,7,10],[7,11,7,19],[7,23,7,27],[8,0,8,1],[30,2,30,27]]}
["Supplier Name"]
["Part(s) Name"]
["Part(s) Number",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Complete Date"]
["Working Days per Year",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Completed by"]
["Contracted Capacity ",null,"Annual",null,null,"Daily",null,null,null,null,null,null,null,null,null,null,null,"SQE Review Date",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"▲"]
["Increased Contracted Capacity ",null,"Annual",null,null,"Daily",null,null,null,null,null,null,null,null,null,null,null,"SQE Reviewed"]
[]
["PRODUCTION SYSTEM",null,"SYSTEM AVAILABILITY (TIME)",null,null,null,null,null,null,null,null,"SYSTEM CAPACITY (UNITS)",null,null,null,null,null,null,null,null,"Post Process Buffer",null,null,"RUN at RATE STUDY RESULTS"]
["List each separate OPERATION in production line",null,"Shifts Per Week","Shifts per Day","Minutes Per Shift","Gross Min Avail/  day","Scheduled Break/Lunch (minutes per day)","Changeovers/Tool Changes (minutes per day)","Planned Maintenance (minutes per day)","Unscheduled Downtime (minutes per day)","Net Available Minutes/day","Time allocated for other customers (minutes)","Net Minutes Available/day for Study Parts","LINE Cycle Time Per Part (seconds)","% Scrap","% True Scrap (Total Loss)","Estimated Throughput for study parts per day","CONTRACTED parts per day","%   Utilization","Result       >85% Concern     >90 Problem","Minimum","Maximum",null,"Total \"All Customers\" Parts Produced","Run at Rate Actual OK parts produced","Available Capacity > Contracted Capacity?","Run at Rate Actual Scrap (part count)","Run at Rate Actual Downtime (minutes)"]
[1,null,null,null,null,{"$f":"D10*E10","v":0},null,null,null,null,{"$f":"F10-G10-H10-I10-J10","v":0},null,{"$f":"K10-L10","v":0},null,null,{"$f":"SUM(O10:O29)","v":0},{"$f":"IF(N10>0,(1-P10)*M10*60/N10,0)","v":0},null,{"$f":"IF(Q10<>0,R10/Q10,0)","v":0},{"$f":"IF(S10>0.8499,IF(S10>0.8999,\"X\",$AG$5),\"\")","v":""},null,null,null,null,null,"YES/NO"]
[2,null,null,null,null,0,null,null,null,null,0,null,0,null,null,{"$f":"P10-O11","v":0},{"$f":"IF(N11<>0,(1-P11)*M11*60/N11,0)","v":0},null,0,"",null,null,null,null,null,"YES/NO"]
[3,null,null,null,null,0,null,null,null,null,0,null,0,null,null,{"$f":"P11-O12","v":0},0,null,{"$f":"IF(Q12<>0,R12/Q12,0)","v":0},"",null,null,null,null,null,"YES/NO"]
[4,null,null,null,null,0,null,null,null,null,0,null,0,null,null,0,0,null,0,"",null,null,null,null,null,"YES/NO"]
[5,null,null,null,null,0,null,null,null,null,0,null,0,null,null,0,0,null,0,"",null,null,null,null,null,"YES/NO"]
[6,null,null,null,null,0,null,null,null,null,0,null,0,null,null,0,0,null,0,"",null,null,null,null,null,"YES/NO"]
[7,null,null,null,null,0,null,null,null,null,0,null,0,null,null,0,0,null,0,"",null,null,null,null,null,"YES/NO"]
[8,null,null,null,null,0,null,null,null,null,0,null,0,null,null,0,0,null,0,"",null,null,null,null,null,"YES/NO"]
[9,null,null,null,null,0,null,null,null,null,0,null,0,null,null,0,0,null,0,"",null,null,null,null,null,"YES/NO"]
[10,null,null,null,null,0,null,null,null,null,0,null,0,null,null,0,0,null,0,"",null,null,null,null,null,"YES/NO"]
[11,null,null,null,null,0,null,null,null,null,0,null,0,null,null,0,0,null,0,"",null,null,null,null,null,"YES/NO"]
[12,null,null,null,null,0,null,null,null,null,0,null,0,null,null,0,0,null,0,"",null,null,null,null,null,"YES/NO"]
[13,null,null,null,null,0,null,null,null,null,0,null,0,null,null,0,0,null,0,"",null,null,null,null,null,"YES/NO"]
[14,null,null,null,null,0,null,null,null,null,0,null,0,null,null,0,0,null,0,"",null,null,null,null,null,"YES/NO"]
[15,null,null,null,null,0,null,null,null,null,0,null,0,null,null,0,0,null,0,"",null,null,null,null,null,"YES/NO"]
[16,null,null,null,null,0,null,null,null,null,0,null,0,null,null,0,0,null,0,"",null,null,null,null,null,"YES/NO"]
[17,null,null,null,null,0,null,null,null,null,0,null,0,null,null,0,0,null,0,"",null,null,null,null,null,"YES/NO"]
[18,null,null,null,null,0,null,null,null,null,0,null,0,null,null,0,0,null,0,"",null,null,null,null,null,"YES/NO"]
[19,null,null,null,null,0,null,null,null,null,0,null,0,null,null,0,0,null,0,"",null,null,null,null,null,"YES/NO"]
[20,null,null,null,null,0,null,null,null,null,0,null,0,null,null,0,0,null,0,{"$f":"IF(S29>0.8499,IF(S29>0.8999,\"X\",AG24),\"\")","v":""},null,null,null,null,null,"YES/NO"]
[]
["Notes/Comments"]
[]
[]
[]
[]
[null,"Legend","▲","Concern constraint - please check operations"]
[null,null,"X","Problem constraint - requires C3 "]

{"sheet":"C2 Example","index":2,"n_rows":37,"n_cols":33,"rows_kept":37,"cut":false,"hidden":true,"merged":[[3,2,3,6],[3,17,3,19],[3,22,3,27],[0,2,0,6],[1,2,1,6],[2,2,2,6],[2,17,2,19],[2,22,2,27],[4,3,4,4],[4,17,4,19],[4,22,4,27],[5,3,5,4],[5,17,5,19],[5,22,5,27],[31,0,31,27],[32,0,32,27],[33,0,33,27],[7,0,7,1],[7,2,7,10],[7,11,7,19],[7,23,7,27],[8,0,8,1],[30,2,30,27]]}
["Supplier Name",null,"XYZ Inc.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"▲"]
["Part(s) Name",null,"XYZ Assembly"]
["Part(s) Number",null,"XYZ000123",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Complete Date",null,null,null,null,"2008-08-01"]
["Working Days per Year",null,235,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Completed by",null,null,null,null,"Bill the Supplier"]
["Contracted Capacity ",null,"Annual",258500,null,"Daily",1100,null,null,null,null,null,null,null,null,null,null,"SQE Review Date",null,null,null,null,"2008-08-25",null,null,null,null,null,null,null,null,null,"▲"]
["Increased Contracted Capacity ",null,"Annual",300000,null,"Daily",1277,null,null,null,null,null,null,null,null,null,null,"SQE Reviewed",null,null,null,null,"Joe the SQE"]
[]
["PRODUCTION SYSTEM",null,"SYSTEM AVAILABILITY (TIME)",null,null,null,null,null,null,null,null,"SYSTEM CAPACITY (UNITS)",null,null,null,null,null,null,null,null,null,"Post Process Buffer",null,"RUN at RATE STUDY RESULTS"]
["List each separate OPERATION in production line",null,"Shifts Per Week","Shifts per Day","Minutes Per Shift","Gross Min Avail/day","Scheduled Break/Lunch (minutes per day)","Changeovers/Tool Changes (minutes per day)","Planned Maintenance (minutes per day)","Unscheduled Downtime (minutes per day)","Net Available Minutes/day","Time allocated for other customers (minutes)","Net Minutes Available/day for Study Parts","LINE Cycle Time Per Part (seconds)","% Scrap","% True Scrap (Total Loss)","Estimated Throughput for study parts per day","NEW CONTRACTED parts per day","% Utilization","Result       >85% Concern     >90 Problem","RESULT: Mark X for possible constraint operation (>85%)","Minimum",null,"Total \"All Customers\" Parts Produced","Run at Rate Actual OK parts produced","Available Capacity > Contracted Capacity?","Run at Rate Actual Scrap (part count)","Run at Rate Actual Downtime (minutes)"]
[1,"OP C10",15,3,480,{"$f":"D10*E10","v":1440},150,45,0,70,{"$f":"F10-G10-H10-I10-J10","v":1175},367,{"$f":"K10-L10","v":808},11,0.04,{"$f":"SUM(O10:O29)","v":0.28000000000000003},{"$f":"IF(N10>0,(1-P10)*M10*60/N10,0)","v":3173.2363636363634},1277,{"$f":"IF(Q10<>0,R10/Q10,0)","v":0.4024282636596993},{"$f":"IF(S10>0.8499,IF(S10>0.8999,\"X\",$AG$5),\"\")","v":""},null,400,null,null,null,"YES/NO"]
[2,"OP C20",15,3,480,1440,150,45,0,75,1170,384,786,11.5,0.02,{"$f":"P10-O11","v":0.26},{"$f":"IF(N11<>0,(1-P11)*M11*60/N11,0)","v":3034.6434782608699},1277,{"$f":"IF(Q11<>0,R11/Q11,0)","v":0.42080725763931864},"",null,400,null,null,null,"YES/NO"]
[3,"SUB-ASSEMBLY C",15,3,480,1440,150,45,0,60,1185,567,618,31,0.01,{"$f":"P11-O12","v":0.25},897.09677419354841,1277,{"$f":"IF(Q12<>0,R12/Q12,0)","v":1.4234807623157137},"X","X",0,null,null,null,"YES/NO"]
[4,"OP A10",15,3,480,1440,150,45,0,90,1155,434,721,26,0.06,0.19,1347.7153846153847,1277,0.9475294372813251,"X",null,200,null,null,null,"YES/NO"]
[5,"OP A20",15,3,480,1440,150,45,0,215,1030,367,663,22,0.06,0.13,1573.1181818181817,1277,0.81176355010026413,"",null,200,null,null,null,"YES/NO"]
[6,"SUB-ASSEMBLY A",15,3,480,1440,150,45,0,80,1165,450,715,26,0.02,0.11,1468.5,1277,0.86959482465100446,"▲",null,500,null,null,null,"YES/NO"]
[7,"OP B10",15,3,480,1440,150,45,45,15,1185,484,701,29,0.01,0.1,1305.3103448275863,1277,0.97831140698473074,"X",null,500,null,null,null,"YES/NO"]
[8,"OP B20",15,3,480,1440,150,45,0,150,1095,384,711,26,1.4999999999999999E-2,8.5000000000000006E-2,1501.3038461538463,1277,0.85059397088172073,"▲",null,400,null,null,null,"YES/NO"]
[9,"OP B30",5,1,480,480,150,45,0,30,255,100,155,3,0.01,7.5000000000000011E-2,2867.5,1277,0.44533565823888405,"",null,4000,null,null,null,"YES/NO"]
[10,"OP B40",15,3,480,1440,150,45,0,100,1145,467,678,28,0.01,6.5000000000000016E-2,1358.4214285714284,1277,0.94006173131628634,"X",null,350,null,null,null,"YES/NO"]
[11,"SUB-ASSEMBLY B",15,3,480,1440,150,45,0,105,1140,384,756,29,0,6.5000000000000016E-2,1462.468965517241,1277,0.87318092220053023,"▲",null,600,null,null,null,"YES/NO"]
[12,"OP D10",15,3,480,1440,150,45,0,110,1135,484,651,14.5,2.5000000000000001E-2,4.0000000000000015E-2,2586.0413793103448,1277,0.49380493684929166,"",null,450,null,null,null,"YES/NO"]
[13,"FINAL ASSEMBLY",15,3,480,1440,150,45,0,30,1215,517,698,27,0,4.0000000000000015E-2,1489.0666666666666,1277,0.85758416905444135,"▲",null,2100,null,null,null,"YES/NO"]
[14,null,null,null,null,0,null,null,null,null,0,null,0,null,null,4.0000000000000015E-2,0,null,0,"",null,null,null,null,null,"YES/NO"]
[15,null,null,null,null,0,null,null,null,null,0,null,0,null,null,4.0000000000000015E-2,0,null,0,"",null,null,null,null,null,"YES/NO"]
[16,null,null,null,null,0,null,null,null,null,0,null,0,null,null,4.0000000000000015E-2,0,null,0,"",null,null,null,null,null,"YES/NO"]
[17,null,null,null,null,0,null,null,null,null,0,null,0,null,null,4.0000000000000015E-2,0,null,0,"",null,null,null,null,null,"YES/NO"]
[18,null,null,null,null,0,null,null,null,null,0,null,0,null,null,4.0000000000000015E-2,0,null,0,"",null,null,null,null,null,"YES/NO"]
[19,null,null,null,null,0,null,null,null,null,0,null,0,null,null,4.0000000000000015E-2,0,null,0,"",null,null,null,null,null,"YES/NO"]
[20,null,null,null,null,0,null,null,null,null,0,null,0,null,null,4.0000000000000015E-2,0,null,0,{"$f":"IF(S29>0.8499,IF(S29>0.8999,\"X\",AG24),\"\")","v":""},null,null,null,null,null,"YES/NO"]
[]
["Notes/Comments"]
[]
[]
[]
[]
[null,"Legend","▲","Concern constraint - please check operations"]
[null,null,"X","Problem constraint - requires C3 "]

{"sheet":"C3 Instructions","index":3,"n_rows":57,"n_cols":1,"rows_kept":57,"cut":false,"hidden":false,"merged":[]}
["The purpose of this sheet is to analyze the operations and determine any Constraints within the System Level Analysis."]
[]
["A Constraint is defined as the operation with highest utilization in the Production Line.  "]
["A Concern Constraint is any operation where the utilization is over 85%"]
["A Problem Constraint is any operation where the utilization is over 90%. "]
[]
["Start with Worksheet by Shift"]
["Enter the process steps"]
["Enter the minutes per shift and time constraints in the non-shaded areas."]
["  Shifts per Week: input the number of working shifts per week for this production operation."]
["  Shifts per Day:  input the number of working shifts per day for this production operation."]
["  Minutes per shift: input the number of total minutes per shift for this production operation."]
["  Scheduled Breaks:  input in minutes the time spent PER DAY for breaks, lunches, meetings, any other scheduled  breaks on this production operation if production stops during these events."]
["  Changeovers/Tool change:  input in minutes the time spent PER DAY for tool changes, setups on this production operation, if production stops during tool changes & setups."]
["  Planned Maintenance:  input in minutes the time spent PER DAY for planned/scheduled maintenance on this production operation."]
["  Unscheduled Downtime:  input ESTIMATE in minutes the time spent PER DAY for UNSCHEDULED downtime (breakdowns) in this production operation."]
["The calculations and the operations will automatically populate the C3 Constraint Capacity Estimate Sheet."]
[]
[]
["C3 Constraint Capacity Estimate Sheet"]
["Please input data into NON-SHADED cells ONLY.  Where there is no value to enter in each field, enter a 0."]
["Shifts per Week: input the number of working shifts per week for this production operation."]
["System Capacity - Where there is no value to enter in each field, enter a 0."]
["Time allocated for other customers: input the total time (in minutes) allocated for other customers on this production operation."]
["The definition of \"other customers\" includes all production for other products designated for Allison, which are not reflected in this Capacity Estimate, and for other non-Allison customers."]
["Line Cycle Time Per Part:  input the cycle time of the line in SECONDS PER PART.  "]
["NOTE - If the final operation of the line produces more than one part per cycle, the Line Cycle time should be calculated by dividing the observed cycle time by the number of parts produced per cycle."]
["Buffer Before/After Operation"]
["% Scrap:  input the scrap rate for this production operation (enter as percentage, not fraction. Example: enter a 5% scrap rate as 5 not 0.05)."]
["CONTRACTED parts/day:  input NEWLY contracted parts PER DAY which includes service parts requirement."]
["RESULT - Where the Utilization is greater than 90%, a red X will appear in the Result Column.  This identifies the Problem Constraint process steps."]
["RESULT - Where the Utilization is greater than 85%, a yellow triangle ▲ will appear in the Result Column.  This identifies the Concern Constraint process steps."]
[]
["Run at Rate Study Results"]
["Run at Rate Actual OK parts produced: input the number of OK parts produced during the run at rate study."]
["Available Capacity > Contracted Capacity: If the available capacity of the system is greater than the contracted capacity, input \"YES\", otherwise input \"NO\"."]
["Run at Rate Actual Scrap: input the number of parts scrapped during the run at rate study."]
["Run at Rate Actual Downtime: input the downtime in minutes during the run at rate study."]
[]
[]
["Description of NON-Calculating Input Data fields in this capacity estimation tool:"]
["Supplier Name:  input the name & location of supplier production for this part."]
["Part(s) Name: input the part name based on the part contract.  When the sheet applies to multiple parts, specify name of all the parts."]
["Part(s) Number: input the Allison's part number (not the supplier's internal part number).  "]
["When the sheet applies to multiple (family) parts, specify number of all the parts, starting with the part with the highest production quantity and ending with the part with the lowest quantity."]
["Working Days per Year:  input the number of working days per year the supplier operates as agreed upon in the contract."]
["Contracted Capacity : input the CONTRACTED yearly and daily capacity.  "]
["CONTRACTED CAPACITY SHOULD BE YEARLY CAPACITY/WORKING DAYS PER YEAR"]
["Increased Contracted Capacity: input the increased CONTRACTED yearly and daily capacity.  "]
["INCREASED CONTRACTED CAPACITY SHOULD BE YEARLY CAPACITY/WORKING DAYS PER YEAR"]
[]
[]
["Actual Run at Rate Study Results"]
["Run at Rate Actual OK parts produced: input the number of OK parts produced during the run at rate study."]
["Available Capacity > Contracted Capacity: If the available capacity of the system is greater than the contracted capacity, input \"YES\", otherwise input \"NO\"."]
["Run at Rate Actual Scrap: input the number of parts scrapped during the run at rate study."]
["Run at Rate Actual Downtime: input the downtime in minutes during the run at rate study."]

{"sheet":"Worksheet by Shift","index":4,"n_rows":27,"n_cols":22,"rows_kept":27,"cut":false,"hidden":false,"merged":[[2,0,3,0],[2,18,2,21],[2,1,3,1],[2,2,2,5],[2,6,2,9],[2,10,2,13],[2,14,2,17]]}
[]
[]
["Number","List each separate process step in constraint operation ","Minutes Per Shift",null,null,null,"Scheduled Break/Lunch (minutes)",null,null,null,"Changeovers/Tool Changes (minutes)",null,null,null,"Planned Maintenance (minutes)",null,null,null,"Unscheduled Downtime (minutes)"]
[null,null,"Shift 1","Shift 2","Shift 3","Per Day","Shift 1","Shift 2","Shift 3","Per Day","Shift 1","Shift 2","Shift 3","Per Day","Shift 1","Shift 2","Shift 3","Per Day","Shift 1","Shift 2","Shift 3","Per Day"]
[1,"Process Step",null,null,null,{"$f":"C5+D5+E5","v":0},null,null,null,{"$f":"G5+H5+I5","v":0},null,null,null,{"$f":"K5+L5+M5","v":0},null,null,null,{"$f":"O5+P5+Q5","v":0},null,null,null,{"$f":"S5+T5+U5","v":0}]
[2,"Process Step",null,null,null,{"$f":"C6+D6+E6","v":0},null,null,null,{"$f":"G6+H6+I6","v":0},null,null,null,{"$f":"K6+L6+M6","v":0},null,null,null,{"$f":"O6+P6+Q6","v":0},null,null,null,{"$f":"S6+T6+U6","v":0}]
[3,"Process Step",null,null,null,{"$f":"C7+D7+E7","v":0},null,null,null,0,null,null,null,0,null,null,null,{"$f":"O7+P7+Q7","v":0},null,null,null,0]
[4,"Process Step",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[5,"Process Step",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[6,"Process Step",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[7,"Process Step",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[8,"Process Step",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[9,"Process Step",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[10,"Process Step",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,{"$f":"O14+P14+Q14","v":0},null,null,null,0]
[11,"Process Step",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[12,"Process Step",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[13,"Process Step",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[14,"Process Step",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[15,"Process Step",null,null,null,{"$f":"C19+D19+E19","v":0},null,null,null,{"$f":"G19+H19+I19","v":0},null,null,null,{"$f":"K19+L19+M19","v":0},null,null,null,{"$f":"O19+P19+Q19","v":0},null,null,null,{"$f":"S19+T19+U19","v":0}]
[16,"Process Step",null,null,null,{"$f":"C20+D20+E20","v":0},null,null,null,{"$f":"G20+H20+I20","v":0},null,null,null,{"$f":"K20+L20+M20","v":0},null,null,null,{"$f":"O20+P20+Q20","v":0},null,null,null,{"$f":"S20+T20+U20","v":0}]
[17,"Process Step",null,null,null,{"$f":"C21+D21+E21","v":0},null,null,null,{"$f":"G21+H21+I21","v":0},null,null,null,{"$f":"K21+L21+M21","v":0},null,null,null,{"$f":"O21+P21+Q21","v":0},null,null,null,{"$f":"S21+T21+U21","v":0}]
[18,"Process Step",null,null,null,{"$f":"C22+D22+E22","v":0},null,null,null,{"$f":"G22+H22+I22","v":0},null,null,null,{"$f":"K22+L22+M22","v":0},null,null,null,{"$f":"O22+P22+Q22","v":0},null,null,null,{"$f":"S22+T22+U22","v":0}]
[19,"Process Step",null,null,null,{"$f":"C23+D23+E23","v":0},null,null,null,{"$f":"G23+H23+I23","v":0},null,null,null,{"$f":"K23+L23+M23","v":0},null,null,null,{"$f":"O23+P23+Q23","v":0},null,null,null,{"$f":"S23+T23+U23","v":0}]
[20,"Process Step",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[]
[]
["IN ALL COLUMNS, ENTER TIME IN MINUTES"]

{"sheet":"C3 Constraint Capacity","index":5,"n_rows":39,"n_cols":33,"rows_kept":39,"cut":false,"hidden":false,"merged":[[4,2,4,6],[4,17,4,19],[4,20,4,25],[1,2,1,6],[2,2,2,6],[3,2,3,6],[3,17,3,19],[3,20,3,25],[5,3,5,4],[5,17,5,19],[5,20,5,25],[6,3,6,4],[6,17,6,19],[6,20,6,25],[33,0,33,25],[34,0,34,25],[35,0,35,25],[9,0,9,1],[9,2,9,8],[9,9,9,19],[9,21,9,25],[10,0,10,1],[32,0,32,1],[32,2,32,25]]}
[]
["Supplier Name",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"▲"]
["Part(s) Name"]
["Part(s) Number",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Complete Date"]
["Working Days per Year",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Completed by"]
["Contracted Capacity ",null,"Annual",null,null,"Daily",null,null,null,null,null,null,null,null,null,null,null,"SQE Review Date",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"▲"]
["Increased Contracted Capacity ",null,"Annual",null,null,"Daily",null,null,null,null,null,null,null,null,null,null,null,"SQE Reviewed"]
[null,"CONSTRAINT PROCESS : Sub Assembly C3"]
[]
["OPERATIONS",null,"OPERATION AVAILABILITY (TIME)",null,null,null,null,null,null,"OPERATION CAPACITY (UNITS)",null,null,null,null,null,null,null,null,null,null,null,"RUN AT RATE STUDY RESULTS"]
["List each separate PROCESS STEOP in the Constraint Operation",null,"Shifts Per Week","Gross Min Avail/day","Scheduled Break/Lunch (minutes)","Change-overs/Tool Changes (minutes)","Planned Maintenance (minutes)","Unscheduled Downtime (minutes)","Net Available Minutes/day","Time allocated for other customers (minutes)","Net Minutes Available/day for Study Parts","Operation Cycle Time Per Part (seconds)","Buffer Before Operation","Buffer After Operation","% Scrap","% True Scrap\n(Total Loss)","Estimated Throughput for study parts per day","NEW CONTRACTED parts per day","% Utilization","Result       >85% Concern     >90 Problem",null,"Total \"All Customers\" Parts Produced","Run at Rate Actual OK parts produced","Available Capacity > Contracted Capacity?","Run at Rate Actual Scrap (part count)","Run at Rate Actual Downtime (minutes)"]
[1,null,null,{"$f":"'Worksheet by Shift'!F5","v":0},{"$f":"'Worksheet by Shift'!J5","v":0},{"$f":"'Worksheet by Shift'!N5","v":0},{"$f":"'Worksheet by Shift'!R5","v":0},{"$f":"'Worksheet by Shift'!V5","v":0},{"$f":"D12-E12-F12-G12-H12","v":0},null,{"$f":"I12-J12","v":0},null,null,null,null,{"$f":"SUM(O12:O31)","v":0},{"$f":"IF(L12<>0,(1-P12)*K12*60/L12,0)","v":0},null,{"$f":"IF(Q12<>0,R12/Q12,0)","v":0},{"$f":"IF(S12>0.8499,IF(S12>0.8999,\"X\",$AG$6),\"\")","v":""},null,null,null,"YES/NO"]
[2,null,null,{"$f":"'Worksheet by Shift'!F6","v":0},{"$f":"'Worksheet by Shift'!J6","v":0},{"$f":"'Worksheet by Shift'!N6","v":0},{"$f":"'Worksheet by Shift'!R6","v":0},{"$f":"'Worksheet by Shift'!V6","v":0},0,null,0,null,null,null,null,{"$f":"SUM(O13:O32)","v":0},0,null,0,"",null,null,null,"YES/NO"]
[3,null,null,{"$f":"'Worksheet by Shift'!F7","v":0},{"$f":"'Worksheet by Shift'!J7","v":0},{"$f":"'Worksheet by Shift'!N7","v":0},{"$f":"'Worksheet by Shift'!R7","v":0},{"$f":"'Worksheet by Shift'!V7","v":0},0,null,0,null,null,null,null,0,0,null,0,"",null,null,null,"YES/NO"]
[4,null,null,{"$f":"'Worksheet by Shift'!F8","v":0},{"$f":"'Worksheet by Shift'!J8","v":0},{"$f":"'Worksheet by Shift'!N8","v":0},{"$f":"'Worksheet by Shift'!R8","v":0},{"$f":"'Worksheet by Shift'!V8","v":0},0,null,0,null,null,null,null,0,0,null,0,"",null,null,null,"YES/NO"]
[5,null,null,{"$f":"'Worksheet by Shift'!F9","v":0},{"$f":"'Worksheet by Shift'!J9","v":0},{"$f":"'Worksheet by Shift'!N9","v":0},{"$f":"'Worksheet by Shift'!R9","v":0},{"$f":"'Worksheet by Shift'!V9","v":0},0,null,0,null,null,null,null,0,0,null,0,"",null,null,null,"YES/NO"]
[6," ",null,{"$f":"'Worksheet by Shift'!F10","v":0},{"$f":"'Worksheet by Shift'!J10","v":0},{"$f":"'Worksheet by Shift'!N10","v":0},{"$f":"'Worksheet by Shift'!R10","v":0},{"$f":"'Worksheet by Shift'!V10","v":0},0,null,0,null,null,null,null,0,0,null,0,"",null,null,null,"YES/NO"]
[7," ",null,{"$f":"'Worksheet by Shift'!F11","v":0},{"$f":"'Worksheet by Shift'!J11","v":0},{"$f":"'Worksheet by Shift'!N11","v":0},{"$f":"'Worksheet by Shift'!R11","v":0},{"$f":"'Worksheet by Shift'!V11","v":0},0,null,0,null,null,null,null,0,0,null,0,"",null,null,null,"YES/NO"]
[8," ",null,{"$f":"'Worksheet by Shift'!F12","v":0},{"$f":"'Worksheet by Shift'!J12","v":0},{"$f":"'Worksheet by Shift'!N12","v":0},{"$f":"'Worksheet by Shift'!R12","v":0},{"$f":"'Worksheet by Shift'!V12","v":0},0,null,0,null,null,null,null,0,0,null,0,"",null,null,null,"YES/NO"]
[9," ",null,{"$f":"'Worksheet by Shift'!F13","v":0},{"$f":"'Worksheet by Shift'!J13","v":0},{"$f":"'Worksheet by Shift'!N13","v":0},{"$f":"'Worksheet by Shift'!R13","v":0},{"$f":"'Worksheet by Shift'!V13","v":0},0,null,0,null,null,null,null,0,0,null,0,"",null,null,null,"YES/NO"]
[10," ",null,{"$f":"'Worksheet by Shift'!F14","v":0},{"$f":"'Worksheet by Shift'!J14","v":0},{"$f":"'Worksheet by Shift'!N14","v":0},{"$f":"'Worksheet by Shift'!R14","v":0},{"$f":"'Worksheet by Shift'!V14","v":0},0,null,0,null,null,null,null,0,0,null,0,"",null,null,null,"YES/NO"]
[11," ",null,{"$f":"'Worksheet by Shift'!F15","v":0},{"$f":"'Worksheet by Shift'!J15","v":0},{"$f":"'Worksheet by Shift'!N15","v":0},{"$f":"'Worksheet by Shift'!R15","v":0},{"$f":"'Worksheet by Shift'!V15","v":0},0,null,0,null,null,null,null,0,0,null,0,"",null,null,null,"YES/NO"]
[12," ",null,{"$f":"'Worksheet by Shift'!F16","v":0},{"$f":"'Worksheet by Shift'!J16","v":0},{"$f":"'Worksheet by Shift'!N16","v":0},{"$f":"'Worksheet by Shift'!R16","v":0},{"$f":"'Worksheet by Shift'!V16","v":0},0,null,0,null,null,null,null,0,0,null,0,"",null,null,null,"YES/NO"]
[13," ",null,{"$f":"'Worksheet by Shift'!F17","v":0},{"$f":"'Worksheet by Shift'!J17","v":0},{"$f":"'Worksheet by Shift'!N17","v":0},{"$f":"'Worksheet by Shift'!R17","v":0},{"$f":"'Worksheet by Shift'!V17","v":0},0,null,0,null,null,null,null,0,0,null,0,"",null,null,null,"YES/NO"]
[14," ",null,{"$f":"'Worksheet by Shift'!F18","v":0},{"$f":"'Worksheet by Shift'!J18","v":0},{"$f":"'Worksheet by Shift'!N18","v":0},{"$f":"'Worksheet by Shift'!R18","v":0},{"$f":"'Worksheet by Shift'!V18","v":0},0,null,0,null,null,null,null,0,0,null,0,"",null,null,null,"YES/NO"]
[15," ",null,{"$f":"'Worksheet by Shift'!F19","v":0},{"$f":"'Worksheet by Shift'!J19","v":0},{"$f":"'Worksheet by Shift'!N19","v":0},{"$f":"'Worksheet by Shift'!R19","v":0},{"$f":"'Worksheet by Shift'!V19","v":0},0,null,0,null,null,null,null,0,0,null,0,"",null,null,null,"YES/NO"]
[16," ",null,{"$f":"'Worksheet by Shift'!F20","v":0},{"$f":"'Worksheet by Shift'!J20","v":0},{"$f":"'Worksheet by Shift'!N20","v":0},{"$f":"'Worksheet by Shift'!R20","v":0},{"$f":"'Worksheet by Shift'!V20","v":0},0,null,0,null,null,null,null,0,0,null,0,"",null,null,null,"YES/NO"]
[17," ",null,{"$f":"'Worksheet by Shift'!F21","v":0},{"$f":"'Worksheet by Shift'!J21","v":0},{"$f":"'Worksheet by Shift'!N21","v":0},{"$f":"'Worksheet by Shift'!R21","v":0},{"$f":"'Worksheet by Shift'!V21","v":0},0,null,0,null,null,null,null,0,0,null,0,"",null,null,null,"YES/NO"]
[18," ",null,{"$f":"'Worksheet by Shift'!F22","v":0},{"$f":"'Worksheet by Shift'!J22","v":0},{"$f":"'Worksheet by Shift'!N22","v":0},{"$f":"'Worksheet by Shift'!R22","v":0},{"$f":"'Worksheet by Shift'!V22","v":0},0,null,0,null,null,null,null,0,0,null,0,"",null,null,null,"YES/NO"]
[19," ",null,{"$f":"'Worksheet by Shift'!F23","v":0},{"$f":"'Worksheet by Shift'!J23","v":0},{"$f":"'Worksheet by Shift'!N23","v":0},{"$f":"'Worksheet by Shift'!R23","v":0},{"$f":"'Worksheet by Shift'!V23","v":0},0,null,0,null,null,null,null,0,0,null,0,"",null,null,null,"YES/NO"]
[20," ",null,{"$f":"'Worksheet by Shift'!F24","v":0},{"$f":"'Worksheet by Shift'!J24","v":0},{"$f":"'Worksheet by Shift'!N24","v":0},{"$f":"'Worksheet by Shift'!R24","v":0},{"$f":"'Worksheet by Shift'!V24","v":0},0,null,0,null,null,null,null,0,0,null,0,{"$f":"IF(S31>0.8499,IF(S31>0.8999,\"X\",AG26),\"\")","v":""},null,null,null,"YES/NO"]
[]
["Notes/Comments"]
[]
[]
[]
[]
[null,"Legend","▲","Concern constraint - please check operations"]
[null,null,"X","Problem constraint "]

{"sheet":"C3 Example","index":6,"n_rows":38,"n_cols":33,"rows_kept":38,"cut":false,"hidden":false,"merged":[[3,2,3,6],[3,17,3,19],[3,20,3,25],[0,2,0,6],[1,2,1,6],[2,2,2,6],[2,17,2,19],[2,20,2,25],[4,3,4,4],[4,17,4,19],[4,20,4,25],[5,3,5,4],[5,17,5,19],[5,20,5,25],[33,0,33,25],[34,0,34,25],[8,2,8,8],[8,9,8,19],[8,21,8,25],[31,0,31,1],[31,2,31,25],[32,0,32,25]]}
["Supplier Name",null,"XYZ Inc.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"▲"]
["Part(s) Name",null,"XYZ Assembly"]
["Part(s) Number",null,"XYZ000123",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Complete Date",null,null,"2008-08-01"]
["Working Days per Year",null,235,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Completed by",null,null,"Bill the Supplier"]
["Contracted Capacity ",null,"Annual",258500,null,"Daily",1100,null,null,null,null,null,null,null,null,null,null,"SQE Review Date",null,null,"2008-08-25",null,null,null,null,null,null,null,null,null,null,null,"▲"]
["Increased Contracted Capacity ",null,"Annual",300000,null,"Daily",1277,null,null,null,null,null,null,null,null,null,null,"SQE Reviewed",null,null,"Joe the SQE"]
[null,"CONSTRAINT PROCESS:SUB-ASSEMBLY C"]
[]
["#","OPERATIONS","OPERATION AVAILABILITY (TIME)",null,null,null,null,null,null,"OPERATION CAPACITY (UNITS)",null,null,null,null,null,null,null,null,null,null,null,"RUN AT RATE STUDY RESULTS"]
[null,"List each separate PROCESS STEP in the Constraint Operation","Shifts Per Week","Gross Min Avail/day","Scheduled Break/Lunch (minutes)","Changeovers/Tool Changes (minutes)","Planned Maintenance (minutes)","Unscheduled Downtime (minutes)","Net Available Minutes/day","Time allocated for other customers (minutes)","Net Minutes Available/day for Study Parts","Operation Cycle Time Per Part (seconds)","Buffer Before Operation","Buffer After Operation","% Scrap","% True Scrap\n(Total Loss)","Estimated Throughput for study parts per day","NEW CONTRACTED parts per day","% Utilization","Result       >85% Concern     >90 Problem",null,"Total \"All Customers\" Parts Produced","Run at Rate Actual OK parts produced","Available Capacity > Contracted Capacity?","Run at Rate Actual Scrap (part count)","Run at Rate Actual Downtime (minutes)"]
[1,"LOAD",15,1440,150,45,0,0,{"$f":"D11-E11-F11-G11-H11","v":1245},566.66999999999996,{"$f":"I11-J11","v":678.33},34,0,0,0.01,0.02,{"$f":"IF(L11<>0,(1-P11)*K11*60/L11,0)","v":1173.1118823529414},1277,{"$f":"IF(Q11<>0,R11/Q11,0)","v":1.088557723444662},{"$f":"IF(S11>0.8499,IF(S11>0.8999,\"X\",$AG$5),\"\")","v":"X"},null,null,null,"YES/NO"]
[2,"PRESS",15,1440,150,45,0,0,1245,566.66999999999996,678.33,10,0,0,0,0.01,4029.2801999999997,1277,0.31693005614253389,"",null,null,null,"YES/NO"]
[3,"WELD",15,1440,150,45,0,0,1245,566.66999999999996,678.33,27,0,0,0,0.01,1492.3259999999998,1277,0.85571115158484146,"▲",null,null,null,"YES/NO"]
[4,"INSPECT",15,1440,150,45,0,0,1245,566.66999999999996,678.33,15,0,0,0.01,{"$f":"O14","v":0.01},2686.1867999999999,1277,0.47539508421380078,"",null,null,null,"YES/NO"]
[5,"UNLOAD",15,1440,150,45,0,0,1245,566.66999999999996,678.33,28,0,0,0,0,1453.5642857142859,1277,0.8785301156271037,"▲",null,null,null,"YES/NO"]
[6,null,null,0,0,0,0,0,0,null,0,null,null,null,null,0,0,null,0,"",null,null,null,"YES/NO"]
[7,null,null,0,0,0,0,0,0,null,0,null,null,null,null,0,0,null,0,"",null,null,null,"YES/NO"]
[8,null,null,0,0,0,0,0,0,null,0,null,null,null,null,0,0,null,0,"",null,null,null,"YES/NO"]
[9,null,null,0,0,0,0,0,0,null,0,null,null,null,null,0,0,null,0,"",null,null,null,"YES/NO"]
[10,null,null,0,0,0,0,0,0,null,0,null,null,null,null,0,0,null,0,"",null,null,null,"YES/NO"]
[11,null,null,0,0,0,0,0,0,null,0,null,null,null,null,0,0,null,0,"",null,null,null,"YES/NO"]
[12,null,null,0,0,0,0,0,0,null,0,null,null,null,null,0,0,null,0,"",null,null,null,"YES/NO"]
[13,null,null,0,0,0,0,0,0,null,0,null,null,null,null,0,0,null,0,"",null,null,null,"YES/NO"]
[14,null,null,0,0,0,0,0,0,null,0,null,null,null,null,0,0,null,0,"",null,null,null,"YES/NO"]
[15,null,null,0,0,0,0,0,0,null,0,null,null,null,null,0,0,null,0,"",null,null,null,"YES/NO"]
[16,null,null,0,0,0,0,0,0,null,0,null,null,null,null,0,0,null,0,"",null,null,null,"YES/NO"]
[17,null,null,0,0,0,0,0,0,null,0,null,null,null,null,0,0,null,0,"",null,null,null,"YES/NO"]
[18,null,null,0,0,0,0,0,0,null,0,null,null,null,null,0,0,null,0,"",null,null,null,"YES/NO"]
[19,null,null,0,0,0,0,0,0,null,0,null,null,null,null,0,0,null,0,"",null,null,null,"YES/NO"]
[20,null,null,0,0,0,0,0,0,null,0,null,null,null,null,0,0,null,0,{"$f":"IF(S30>0.8499,IF(S30>0.8999,\"X\",AG25),\"\")","v":""},null,null,null,"YES/NO"]
[]
["Notes/Comments"]
[]
[]
[]
[]
[null,"Legend","▲","Concern constraint - please check operations"]
[null,null,"X","Problem constraint"]