(PFMEA) Potential Failure Modes and Effects Analysis Information Template Sheet
Includes different tabs for PFMEA,DFMEA, severities like level of hazard,probability of failure and occurrence,detection of failures and the directions.
FMEA Product Example
Download this editable sample templates for excel. You can even print them, some of them contains MACRO and examples to understand how they work.For Product : This worksheet helps user to identify the potential failure and their effects on product reliability. The product with high RPN requires most attention as it has more chances to fail. Probability of the failure along with detect-ability and severity are examined and tracked.
Share this:
Interview Rating Template Free
HR management is not a easy task. They have to do a lot of stuff including interviewing a perfect employee for their company. We are proving some templates or checklists that can save your time and mange information easily as they can be organized in spreadsheet form. You can even print them and use them. You should download one or every template to have a look and use them after editing.The key points in a interview templates are already covered…
Share this:
3 Nifty Ways to Change date Formats In Excel
Change date format mm/dd/yyyy to dd/mm/yyyy in excel This problem is faced by many Indian users as the U.S system of mm/dd/yyyy is quite strange to them and for them it creates problem each time they look at it. So here i am sharing some tips to fix it. Without using any code or Macro First i am taking here an example of date 9/23/2015 now to convert it into dd/mm/yyyy use this. Right click that particular cell in…
Share this:
Send Email Vba Code Excel Examples
Here are examples of VBA MACRO codes that allows to send emails within Ms Excel. It is not a rocket science to understand how to send the email using MS outlook via VBA code. Basically I use Excel to list the e-mail addresses and the name of the attachments. Here is MACRO to send mail via CDO Whenever macro sends out an e-mail,via MS outlook you have to authorize it Select “yes” to authorize it . Below is code for sending…
Share this:
Excel Drag Not Working 2007 and 2010
Following are the tips that can be used to make drag function work properly in MS excel. In 2007 or 2008 version You have to open excel and click on options > it is beneath the file menu. You can see in this image. Now click on Advanced category, under Editing options. Now you have to clear the Enable fill handle ( Follow the images to understand it better) and change the cell drag-and-drop check box to turn on or…
Share this:
Best Software To Recover Severely Corrupted Ms Excel File ?
There are plenty of Excel spreadsheet recovery software’s out there which one is your favorite ? I am including some of them here,their features along with their prices. It is not a review exactly for these tools but you can help me here by posting your comments and tell us which one is best? and why i should pay or not for that software. 1. Cimaware’s Excel fix : It comes with a price tag of €79. Developers say that…
Share this:
Manage Mysql using Ms Access
Create edit and manage MYSQL database from MS Access This simple tool can help you to manage MYSQL dbase from MS Access without any knowledge of My SQL. User can easily modify /create/open tables within Access. It connects both the databases where you can edit,add and delete just like the normal ACCESS tables and then export the tables to the MYsql server. Here is the tool download page This tool was previously a paid software but now they are giving…
Share this:
Quiz Template Download Without Any Hassle !!!
This spreadsheet template allows user to fill in quiz data. It is easier to understand first of all you have to type in the quiz name.After it you can fill in questions and the answers. Nice and easy template. You can even print this template after filling. Here is a Power point template User has to fill in the questions and place the answers in text box as they are labelled where to put right and where to…
Share this:
Macro To copy the worksheet column to another sheets row.
Why use VBA when we can use transpose : This macro is made for those who work on large and complicated data files. To debug the MACRO you have to press F8 in Microsoft Visual Basic. Suppose if you have a larger spreadsheet where you have to backup and view,sort around 30 columns rom one part of the sheet to another part of the worksheet and on a daily basis. Then how will you do it. Yeah we know transpose..but…