How to Create an Injection Molding Cycle Time Calculator in Excel?

Get FREE Advanced Excel Exercises with Solutions!

In industries, it is one of the most important works of the molding engineer to calculate the injection molding cycle time. Production can vary a lot with this time. In this article, I will show you all steps to create an injection molding cycle time calculator in Excel.


What Is Injection Molding Cycle Time?

Injection molding cycle time is the total cycle time for the total procedure of injection molding in industries. It includes the total injection time, pressurized holding time, charging time, cooling time, etc.

The formula to calculate the injection molding cycle time would be:

T=Ti + Tp + Ts + Tm + Tc + To + Te

Here,

Ti = Total Filling / Injection Time

Tp = Total Pressurized Holding Time

Ts = Total Screw Driving Time

Tm = Total Charging / Melting Time

Tc = Total Time for Cooling

To = Total Time for Operating

Te = Total Drop, Robot, Ejection Time


How to Create an Injection Molding Cycle Time Calculator in Excel: Step-by-Step Procedures

Say, you are given the required time ranges for several sectionsโ€™ required time to complete the injection molding cycle time.

Sample Dataset to Create an Injection Molding Cycle Time Calculator in Excel

Moreover, you are given a table to calculate the cooling time for various materials according to their thickness.

Cooling Time Table

Now, you need to calculate the total injection molding cycle time in Excel. Go through the steps below to do this.

Read More:ย How to Calculate Hours Worked Minus Lunch with Excel Formula


๐Ÿ“Œ Step 1: Input the Required Values

First, you will need to input the required values of your production materials and time values for several sections.

  • To do this, at the very beginning, click on cells as shown below and insert the required value from your production particulars at the Sample Dataset worksheet.

Input the Required Values in Sample Dataset to Create an Injection Molding Cycle Time Calculator in Excel

  • Afterward, click on cell C5 and insert the name of your material (PVC (soft) here).

Record the Material Type in Calculator

  • Following, click on cell C6 and insert the value for the thickness of your material (6 here).

Record Thickness in Injection Molding Cycle Time Calculator in Excel

  • Afterward, insert the required times in the following cells as shown in the image below. You can input these values from the given value range in the Sample Dataset worksheet.

Fill the Time Values from Given Ranges

Read More: How to Calculate Hours and Minutes for Payroll Excel


๐Ÿ“Œ Step 2: Calculate Total Injection Time

Now, you need to calculate the total injection time.

  • To do this, firstly, click on cell C7 and insert the following formula to calculate the total amount of shot weight.
=('Sample Dataset'!C5*'Sample Dataset'!C6)+'Sample Dataset'!C7
  • Subsequently, press the Enter key.

Formula to Calculate the Total Amount of Shot Weight

  • Afterward, click on cell C8 and insert the following formula to calculate the total injection time.
=ABS((C7/20)-(0.5*'Sample Dataset'!C8))+'Sample Dataset'!C9
  • Following, press the Enter key.

Formula to Calculate the Total Injection Time

Read More: How to Calculate On Time Delivery Performance in Excel


๐Ÿ“Œ Step 3: Calculate Total Melting / Charging Time

At this time, you will need to calculate the total charging time.

  • In order to do this, click on cell C11 first.
  • Subsequently, insert the following formula and hit the Enter key.
='Sample Dataset'!C12/'Sample Dataset'!C13

Formula to Calculate the Total Charging Time

Thus, you will get the total charging time.

Read More:ย How to Calculate Production per Hour in Excel


๐Ÿ“Œ Step 4: Calculate Total Cooling Time

Now, another important step is to calculate the total cooling time.

  • To do this, first and foremost, click on cell C12.
  • Following, insert the formula below.
=INDEX('Cooling Time Table'!B4:H16,MATCH(Calculator!C5,'Cooling Time Table'!B4:B16,0),MATCH(C6,'Cooling Time Table'!B5:H5,0))
  • Subsequently, hit the Enter key.

Formula to Calculate the Total Cooling Time

As a result, you will find the injection molding cycleโ€™s cooling time in the given table.

Read More: How to Calculate Total Hours Worked in a Week in Excel


๐Ÿ“Œ Step 5: Calculate Total Injection Molding Cycle Time

Finally, you will need to calculate the total injection molding cycle time now.

  • In order to do this, click on cell C15 and insert the following formula.
=SUM(C8:C14)
  • Subsequently, hit the Enter key.

Formula to Calculate the Total Injection Molding Cycle Time

Thus, you will get the total injection molding cycle time. And, your injection molding cycle time calculator is ready in Excel. Just use the values at the proper cells and you will automatically find the total injection molding cycle time.

Read More:ย How to Calculate Billable Hours in Excel


Download Practice Workbook

You can download our practice workbook from here for free!


Conclusion

So, in this article, I have shown you all the steps to create an injection molding cycle time calculator in Excel. Read the full article carefully and practice accordingly. I hope you find this article helpful and informative. You are very welcome to comment here if you have any further questions or recommendations.


Related Articles

What is ExcelDemy?

ExcelDemy Learn Excel & Excel Solutions Center provides free Excel tutorials, free support , online Excel training and Excel consultancy services for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Tanjim Reza
Tanjim Reza

Hello! I am Md. Tanjim Reza Tanim. I have just completed my B.Sc from Naval Architecture & Marine Engineering Department, BUET. Currently, I am working as an Excel & VBA content developer. I always had a great fascination with Microsoft Excel and its cool functions and formulas. Here, I am learning every day about new functions and formulas and working on applying MS Excel to the analysis of our real-life problems. I have great enthusiasm for learning any kind of new things, writing articles, and solving real-life problems.

2 Comments
  1. where did you get the data for cooling times?

    • Hello, PJ!
      Hope you are doing well. Thank you for your query.
      Cooling time mainly refers to the time elapsed from the end of holding pressure to the opening of the mold. This value depends on various factors like the wall thickness, product shape, mold temperature, melt properties, etc. To get a better product, the cooling time should be as low as possible.
      You can search google thoroughly or visit industrial yards to learn about the actual cooling time values.

      Regards,
      Md. Tanjim Reza Tanim

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo