Project 1 - Data Cleaning and Transformation using Pivot table and Charts for the Report on requirement of Team Hiring

Aim: This projects aims to analyze the data in detail on vaccinated people and fully vaccinated people by country in starting 2020 till the year 2022.  Introduction: The Covid 19 pandamic casued by Corona Virus, believed to be originating from China, Caused several fatalities throughout the world. The entire…

All the functions are performed in the excel sheet attached. 

Underbody coating is the process of applying a protective layer on the exposed sheet metal surface beneath the body of the car. It is done so as to protect the exposed body of the car from any damage from external environment and abrassion, impact, and chemical substances or water as these things can cause a major damage…

The P-clip acts as a support part for the wire bundle. Here in electrical part design workbench it is defined as a support part. It has one entry and exit point.  The direction of entry and exit can be either of the two points.  Firstly the geometrical set is defined.  Then the part is defined as support…

In Catia, to make wiring harness, mainly Electrical harness disciplin which contains several electrical workbenches is used.  Here, we have currently used "Electrical part design workbench." Under this workbench, we can define different electrical parts before assemblying them.  The assembly consist of Electrical…

Benchmarking in the automotive industry is the study of comparision between available products in the market, on some dimensions of performance which could be the decisive factors which are relevant to the customer.  The case here suggests that the choice of car should be  1. Spacious since it has to carry 5…

The first step to create the part from surface is to do a feasibility check on class A surface to find if the surface is good enough to work on.  Then after, a tooling axis is created in either the X, Y or Z direction. Depending on which of the direction is clearing the draft analysis, a tooling direction is choosen. …

  This is the tree structure of the output. :   The following part has been created following all the design rules.  First, The given surface is analysed using draft analysis and a feasibility check is also performed for any irregularities in the given surface. A tooling axis is created in Z direction. …

The draft analysis was performed first on the class A surface then on the final part body.  For the class A surface, A small area of the part was observed to be under the required 3 degree draft angle. A change in class A surface might be required.  The final part was observed to have draft angle of less than…

The draft analysis was performed on the Class A surface as well as the final part. Tooling axis was choosen to be in Y axis in order to make sure that other mold can also be used easily. The result of draft directions were obtained to be under 3 degree.     

Report: The tooling axis for this component has been choosen to be Z axis. This also helps with easy changing of mold as the tooling axis for the component are in usual X/Y/Z axis. Via the bisecting method, the tooling axis was tried but it was not successfully performed as the surface is open on one end.   …

  The draft analysis was performed on the closed body surface. It was observed that the top side of surface as well as surface walls were in the range of a draft angle of 0-3 degrees, and the underneath of the part surface was in the negative draft angle.