Maintenance... Predictive yes, but when....

Hi everyone,

In this article I would like to talk about how can mix perfectly production and maintenance. Of course maintenance team is always at work, especially when the production miss.

In that day you have the control of what you want to do. We take the example of the maintenance of a palletizer.

What is a palletizer?  From beverage to tissue, from food to petrochemical, it is always present.
It is  is a machine which provides automatic means for stacking cases of goods or products onto a pallet.

Palletizers

I've done the classical maintenance not during the production, but in a stop period to not limitate it. Obviously we had some problem that we have to face in the next days, because the noise of an a motor might create a lots of trouble for us.

Greasing mechanical parts

So, you decide to do predictive maintenance to save the machine and production too.

Try to do it when the production miss, because you have time to better think about what you might improve and better understand the problem that we might face. I know it's no easy... but we never give up, to maintain the line in a healthy line...

INDUSTRIAL ENGINEER

Let's see this video for who want to understand better what the Industrial Engineer does!!

Project Documentation System...

Important EXCEL SKILLS - SUM AND IF

Hi everyone, today we start knowing how Excel works and which functions are important and which are the most used.

1- SUM

When you create a sheet in Excel, an important need is to do a sum. If the number of the cells are wise you can use this symbol:

                               

We explain the use of it with an example:

After you have inserted the values in the columns, for example from the cell B2 to B6, you click on SUM symbol and it does the sum of the adjacent row, or you can select the cells you care and click on the symbol:

Remember, if you don't want to use the symbol you can write in the cell:

=SUM(B2:B6).

In case of the SUM function, you have to indicate the area of the cells, writing the first one and the last one separate by ":" symbol.

The symbol ":" means always 'from....to', and you use it whenever you have to specify a range of cells.

2 - IF

This is one of the function more useful of the Excel. This is part of the LOGICAL functions, because it allows Excel to do analysis, and in base on it to do a specific action among different alternatives.

Excel does the test asked by the user, the test could be a verification of an equality or >/<; If the test is satisfied Excel does an action, in the opposite case it does another action.

To summarize:

1. You need IF when you want Excel performs one of several possible actions in base on what happened in a cell.
2. In the Function, remember to write the cells.
3. If you copy the function IF() in an adjacent cell, remember to block the cells that have to be fixed with $.

We can do an example:

In a table we put sales made by sellers of a company. In based on the amount of revenue, they get 10% if are under 50000$ and 15% if they got more.

We have created a column where we put the values, and from there we wrote our function IF.

For example:

=IF(B9<800; "insufficient"; IF (B9<900;"sufficient","we are doing good")) 

If you follow this way of thinking, you will able to make important and useful sheet that can help you in your work.

If you want more information leave a comment below.

Don't forget to share this article and subscribe to my blog.

Keep the information useful for all of us!!

Emanuele Battista