How to Create a Dependent Drop Down List in Excel | update dropdown list with respect to another

 



An Excel drop down list is a useful feature when you’re creating data entry forms It shows a list of items as a drop down in a cell, and the user can make a selection from the drop down. This could be useful when you have a list of names, products, or regions that you often need to enter in a set of cells. Sometimes, however, you may want to use more than one drop-down list in Excel such that the items available in a second drop-down list are dependent on the selection made in the first drop-down list. These are called dependent drop-down lists in Excel. #excel #dropdown list

EST 200: Design & Engineering | Module 5 | Sample question Solution

 


Question (20)Describe how to estimate the cost of a particular design using ANY of the following: i) a website, ii) the layout of a plant, iii) the elevation of a building, iv) an electrical or electronic system or device and v) a car. Show how economics will influence the engineering designs. Use hand sketches to support your arguments.

Topic covered Engineering Economics in Design Module 5 - Syllabus Expediency, Economics and Environment in Design Engineering:-Design for Production, Use, and Sustainability. Engineering Economics in Design. Design Rights. Ethics in Design

സത്യത്തിൽ WhatsApp നമ്മുടെ മെസ്സേജുകൾ വായിക്കുന്നുണ്ടോ?

 


സത്യത്തിൽ WhatsApp നമ്മുടെ മെസ്സേജുകൾ വായിക്കുന്നുണ്ടോ? WhatsApp എടുക്കുന്ന ഡാറ്റകൾ എന്തോക്കെ? WhatsApp സേഫ് ആണോ? is signal safe? അറിയാൻ വീഡിയോ കാണു Like and subscribe of you like the video

How to search smart in google | Things you don’t know in google search | Easter egg available!!

 



1. Search specific word/phrase

2. Exclude word/phrase from search

3. Quick calculation 4. Graph plotting (2D/3D) 5. Quick conversion 6. Meaning of a word 7. origin of a word 8. Sunrise/Sunset time 9. Timer/Stopwatch 10. coin flip 11. holyday/Special day search 12. search within a website 13. Flight status 14. Find your phone Easter eggs!!! 15. do a barrel roll 16. google in 1998 17. festivus search Don't forget to give comments and feedbacks Check other videos Easiest way to import pdf file in to excel : https://youtu.be/jET9Y5uvdi8 watch my - 5 tips & Tricks in MS excel course here : https://youtube.com/playlist?list=PLmKq-kgKY8uZCGi-U_bx820HOLmk5NidT if you want to learn python language and you font know programming then watch the course Learn python in Malayalam course : https://youtube.com/playlist?list=PLmKq-kgKY8uZya3cwcX6otT61NPHXbTK0 Photo by Christian Wiediger on Unsplash

The best way to import pdf data to excel | tip for KTU faculties | Easy report making | Malayalam


 This video is especially made for KTU faculties who are facing difficulties in result analysis report making.

with some easy steps you can import all the mark list data into an excel file easily Most of the time converting a pdf file to excel wont work as we wish to do so. in this method there is more customised steps ate there watch the video in full don't forget to give your feedback as comment also please like the video watch my - 5 tips & Tricks in MS excel course here : https://youtube.com/playlist?list=PLmKq-kgKY8uZCGi-U_bx820HOLmk5NidT if you want to learn python language and you font know programming then watch the course Learn python in Malayalam course : https://youtube.com/playlist?list=PLmKq-kgKY8uZya3cwcX6otT61NPHXbTK0 music : Tobu-Sound-of-Goodbye-NCS-Release

EST 200 : Design & Engineering - Module 3 sample question solution - Role of mathematical modelling




Question) Describe the role of mathematical modelling in design engineering. Show how mathematics and physics play a role in designing a lifting mechanism to raise 100 kg of weight to a floor at a height of 10 meters in a construction site. Topic covered Role of Mathematical model in design & engineering

EC 465 MEMS : Module 4


Prepared By:
Mr. Manu Prasad
Asst. Professor
AWH Engineering College

Course objectives:

 To understand the operation of major classes of MEMS devices/systems

 To grasp the fundamentals of standard micro fabrication techniques and processes

 To understand the unique demands , environments and applications of MEMS devices

 To create interest for further study in this area 


Text Books:

 Tai Ran Hsu, MEMS and Microsystems Design and Manufacture, TMH, 2002

 Chang Liu, Foundations of MEMS, Pearson 2012


Syllabus

Materials for MEMS – Silicon – Silicon compounds – Silicon Nitride, Silicon Dioxide, Silicon carbide, Poly Silicon, GaAs , Silicon Piezo resistors, Polymers in MEMS – SU-8, PMMA, PDMS, Langmuir – Blodgett Films, Micro System fabrication – Photolithography – Ion implantation- Diffusion – Oxidation – Chemicalvapour deposition – Etching

Module 4 - Note  Part 1 - click here
                   Note  Part 2 - click here 

 

EC 465 MEMS : Module 3

 


Prepared By:
Mr. Manu Prasad
Asst. Professor
AWH Engineering College

Course objectives:

 To understand the operation of major classes of MEMS devices/systems

 To grasp the fundamentals of standard micro fabrication techniques and processes

 To understand the unique demands , environments and applications of MEMS devices

 To create interest for further study in this area 


Text Books:

 Tai Ran Hsu, MEMS and Microsystems Design and Manufacture, TMH, 2002

 Chang Liu, Foundations of MEMS, Pearson 2012


Syllabus

Scaling laws in miniaturization - scaling in geometry, scaling in rigid body dynamics, Trimmer force scaling vector, scaling in electrostatic and electromagnetic forces, scaling in electricity and fluidic dynamics, scaling in heat conducting and heat convection.


Module 3 - Note - click here

Notes prepared by other teachers

EC 465 MEMS : Module 2

    

Prepared By
Mr. Manu Prasad
Asst. Professor
AWH Engineering College

Course objectives:

 To understand the operation of major classes of MEMS devices/systems

 To grasp the fundamentals of standard micro fabrication techniques and processes

 To understand the unique demands , environments and applications of MEMS devices

 To create interest for further study in this area 


Text Books:

 Tai Ran Hsu, MEMS and Microsystems Design and Manufacture, TMH, 2002

 Chang Liu, Foundations of MEMS, Pearson 2012


Syllabus

Flexural beams: Types of Beams, longitudinal strain under pure bending – Deflection of beams – Spring constant of cantilever – Intrinsic stresses Actuation and Sensing techniques : Thermal sensors and actuators, Electrostatic sensors and actuators , Piezoelectric sensors and actuators, magnetic actuators


Module 2 - Note PPT - click here 

Other notes (notes prepared by other teachers)

note 1

note 2


EC 465 MEMS : Module 1

 

Prepared By:
Mr. Manu Prasad
Asst. Professor
AWH Engineering College

Course objectives:

 To understand the operation of major classes of MEMS devices/systems

 To grasp the fundamentals of standard micro fabrication techniques and processes

 To understand the unique demands , environments and applications of MEMS devices

 To create interest for further study in this area 


Text Books:

 Tai Ran Hsu, MEMS and Microsystems Design and Manufacture, TMH, 2002

 Chang Liu, Foundations of MEMS, Pearson 2012


Syllabus

MEMS and Microsystems: Applications – Multidisciplinary nature of MEMS – principles and examples of Micro sensors and micro actuators – micro accelerometer –comb drives - Micro grippers –micro  motors, micro valves, micro pumps , Shape Memory Alloys. Review of Mechanical concepts: Stress, Strain, Modulus of Elasticity, yield strength, ultimate strength – General stress strain relations – compliance matrix. Overview of commonly used mechanical structures in MEMS - Beams, Cantilevers, Plates, Diaphragms – Typical applications


Module 1 - Note - click here

MEMS intro video explanation - 


**video from YouTube

How to apply possession certificate online | കൈവശാവകാശ സർട്ടിഫിക്കറ്റ് ഓൺലൈനിൽ | step by step

 



കൈവശാവകാശ സർട്ടിഫിക്കറ്റ് വീട്ടിലിരുന്നു ഓൺലൈൻ ആയി എങ്ങനെ അപ്ലൈ ചെയ്യാം ? അതിനായി വീഡിയോ കാണു website link : https://edistrict.kerala.gov.in/ Check out these videos 1) അക്ഷയ സെൻററിൽ പോകാതെ ഓൺലൈനായി എങ്ങനെ കരം അടക്കാം | How to pay land tax online| Step by Step https://youtu.be/XgmteF6EjpM 2)കെട്ടിട കരം എങ്ങനെ വീട്ടിലിരുന്ന് ഓൺലൈനായി അടക്കാം|How to pay Property tax/Building tax online https://youtu.be/ACOagrrkjjg 3)നിങ്ങളുടെ വാട്ടർ ബില്ല് എങ്ങനെ ഓൺലൈൻ ആയി അടയ്ക്കാം | How to pay Kerala Water Authority Bill Online https://youtu.be/lInqHNLrIFc How to playlist : https://youtube.com/playlist?list=PLmKq-kgKY8uZJDlYK5Sn-OR_j7dCwnkyL Learn python in Malayalam course playlist : https://youtube.com/playlist?list=PLmKq-kgKY8uZya3cwcX6otT61NPHXbTK0 5 tips & tricks in excel course playlist : https://youtube.com/playlist?list=PLmKq-kgKY8uZCGi-U_bx820HOLmk5NidT music : Friendly Dance - Nico Staf #possessioncertificate #kerala

Signals & System Lect 15 | Stable & Unstable Systems | Solved examples

  ECT 204 SIGNALS AND SYSTEMS Topics covered  00:00 - Introduction to Stable & unstable Systems 01:08 - BIBO criteria 03:38 Problem No 1...