Project 2 - Create a report using PowerQuery, Macro VBA, List Functions and Data Validation functions for Data Reporting of Supply Chain Management companies

Create VBA Code to convert selected data into pdf from applicant data   Sub PDF()'' PDF Macro' PDF'' Keyboard Shortcut: Ctrl+Shift+P Dim ID As String ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _ "D:\DATA SCIENCE\Myfile" + Myfile + ".pdf", _ IgnorePrintAreas:=False, OpenAfterPublish:= _ False End Sub…

d. Make Customized Tab by naming ABC and keep few data formatting commands in the newly created Tab. In On-line Excel Customisse ribbon tab is not available, i dont have a pirated version of excel. Other Question are perform in excel Sheet which is attched below.

Fender Fender is a part of an automobile, motorcycle or other vehicle body that frames a wheel well (the fender underside). Its primary purpose is to prevent sand, mud, rocks, liquids, and other road spray from being thrown into the air by the rotating tire. Fenders are…

OBJECTIVE : The main objective of this project is to design a fender using  a new age design software - NX - CAD DESIGN OF CAR FENDER Fender is  the part of an automobile, motor cycle or other vehicle body that frames a wheel well (the fender underside). Its primary purpose is to prevent sand, mud,…

Aim: To find the section modulus of the hood and optimization to improve the overall section modulus.   Objective: Use the section from your Hood design and calculate the section modulus using the formula S= I/y.   WHAT IS SECTION MODULUS The Section modulus is a cross-section geometry property of structural…

Hood design Aim: To Design Hood outer panel, inner panel and the necessary reinforcements by following the Master section with the design parameter Introduction: Hood is the main component of a car at the front portion. It is used to decorate the car and add a luxurious look. The shape of the Hood is made aerodynamic…

DOOR TRIM LOWER WITH ENGINEERING FEATURES (HEAT STAKES AND LOCATORS) Aim: To design a solid body from the given class A surfaces by creating tooling axis, B and C surface  then do the draft analysis for the same then conclude the result by adding engineering features like heat stakes and the locators. Objectives:…

Project Tiltle : ASSEMBLY WORKBENCH 1) Quick Return Mechanism : Part modeling :-           Now Assemble all the the parts in Assembly workbench using Constraints :       2) CV Joint : Part modeling :-               Now Assemble…

UNDERBODY COATING   Underbody Coating is a sprayable coating, which protects the under surface of the vehicle from corrosion. Underbody coating provides long term protection from corrosion to car's underbody. It also protects parts like internal body panels, frame rails and other inner cavities that are…

BENCHMARKING 1: Mr . D.S. Pughazhyendhii\'s family requires what Safe Car yet the value which offers an Equilibrium strike of Mileage, Maintenance with Good space, Features and a Social Status too of not to be owning a car which is of entry segment but one which offers Value. With Transformation happening in Mindsets -…

AIM:     Create the Pillar, Plastic component through the given Class-A surface. To begin with, the tooling axis for the given Class-A Surface should be created meeting the requirements of the draft angle and at the end perform the Draft analysis on the model.   A below image is given class A with master…

Objective: The main aim of this challenge is to create B-side features of the 'Door Trim', with the help of CATIA V5. Overview: Created a 2.5mm solid part body of door trim with the help of class A surface, and created a B-side attachment feature 'Dog House' by considering the design parameters. Tooling axis:…

Objective: The main objective of this challenge is to create the B-side features RIBs and Screw Bosses for a given drill handle. Overview: Creating the class B and class C surfaces to the door handle, and creating the B side features (RIBs and Screw Bosses) by considering all the design parameters.Design parameters…

Objective: The main objective of this challenge is to design a Core and Cavity for a Switch Bezel' in CATIA V5 with the help of a surface workbench. Before we design the core and cavity, we should perform a draft analysis on the solid part body of the switch bezel.  Core Design: Initially, I have taken the boundary…

DOOR TRIM LOWER AIM: to make a model from the provided class-A surface.INTRODUCTION:CLASS-A SURFACE: a surface made by the designer which is given as input to the plastic modeler to work on. It is an aesthetic surfaceand the outermost surface.CLASS-B SURFACE: a surface below a certain thickness from the…

BUMPER DESIGN :- Aim- Create the Bumper Plastic component through the given Class-A surface. To begin with, the tooling axis for the given Class-A Surface should be created meeting the requirements of the draft angle and at the end perform the Draft analysis on the model.    Class A Surface- Class A Surface…

TO DESIGN A COIN HOLDER BY USING CLASS A SURFACE  AIM:  To design a coin holder Plastic component through the given Class-A surface by creating a tooling axis and draft analysis of the given surface.   DESIGN PROCEDURE:  To setup the class-A surface and to creating a tooling axis   add…

DESIGN AND DRAFT ANALYSIS OF SWITCH BEZEL OBJECTIVE The objective of the project is to design the switch bezel and to do a draft analysis for it by creating the required tooling direction with the help of Bisecting method. INTRODUCTION The control panel bezel is the frame part of the window switch that holds its switch…