Placement 2025 Scholarship: Your Future Starts Here | 6 Guaranteed Job Interviews | Limited to 100 seats. Apply Now

00D 00H 00M 00S

Menu

Executive Programs

Workshops

Projects

Blogs

Careers

Placements

Student Reviews

For Business

More

Academic Training

Informative Articles

Find Jobs

We are Hiring!

All Courses

Choose a category

Mechanical

Electrical

Civil

Computer Science

Electronics

Offline Program

All Courses

All Courses

logo

CHOOSE A CATEGORY

Mechanical

Electrical

Civil

Computer Science

Electronics

Offline Program

Top Job Leading Courses

Automotive

CFD

FEA

Design

MBD

Med Tech

Courses by Software

Design

Solver

Automation

Vehicle Dynamics

CFD Solver

Preprocessor

Courses by Semester

First Year

Second Year

Third Year

Fourth Year

Courses by Domain

Automotive

CFD

Design

FEA

Tool-focused Courses

Design

Solver

Automation

Preprocessor

CFD Solver

Vehicle Dynamics

Machine learning

Machine Learning and AI

POPULAR COURSES

coursePost Graduate Program in Hybrid Electric Vehicle Design and Analysis
coursePost Graduate Program in Computational Fluid Dynamics
coursePost Graduate Program in CAD
coursePost Graduate Program in CAE
coursePost Graduate Program in Manufacturing Design
coursePost Graduate Program in Computational Design and Pre-processing
coursePost Graduate Program in Complete Passenger Car Design & Product Development
Executive Programs
Workshops
For Business

Success Stories

Placements

Student Reviews

More

Projects

Blogs

Academic Training

Find Jobs

Informative Articles

We're Hiring!

phone+91 9342691281Log in
  1. Home/
  2. Anupama Yeragudipati/
  3. Project 2 - Create a report using PowerQuery, Macro VBA, List Functions and Data Validation functions for Data Reporting of Supply Chain Management companies

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

The below is link to Dashboard https://docs.google.com/spreadsheets/d/1U2-YBp2mopGDFowI7Vaj00PJdOvxRCIc/edit?usp=drive_link&ouid=103286046492277190255&rtpof=true&sd=true   The below is link to macros file https://docs.google.com/spreadsheets/d/1km0Bm8VFvkT84pGQcgMnOc94rPY083yD/edit?usp=drive_link&ouid=103286046492277190255&rtpof=true&sd=true…

    • Anupama Yeragudipati

      updated on 07 Jun 2023

    The below is link to Dashboard

    https://docs.google.com/spreadsheets/d/1U2-YBp2mopGDFowI7Vaj00PJdOvxRCIc/edit?usp=drive_link&ouid=103286046492277190255&rtpof=true&sd=true

     

    The below is link to macros file

    https://docs.google.com/spreadsheets/d/1km0Bm8VFvkT84pGQcgMnOc94rPY083yD/edit?usp=drive_link&ouid=103286046492277190255&rtpof=true&sd=true

     

    Link of pdf file

    https://drive.google.com/file/d/1huhGgNQq_B-w4VaLaKc9PI8YrXLUo2Vl/view?usp=drive_link

    The VBA code is mentioned below

    For conditional formatting a macro is recorded and conditional formatting using different criterias has been done and freeze planes of first row

     

    Public Sub ExcelToPDF()

    Dim ThisRng As Range

    Dim strfile As String

    Dim myfile As Variant

     

    If Selection.Count = 1 Then

    Set ThisRng = Application.InputBox("Select a range", "Get Range", Type:=8)

    Else

    Set ThisRng = Selection

    End If

    strfile = "Selection" & "_" _

    & Format(Now(), "yyyymmdd_hhmmss") _

    & ".pdf"

    strfile = ThisWorkbook.Path & "\" & strfile

     

    myfile = Application.GetSaveAsFilename _

    (InitialFileName:=strfile, _

    FileFilter:="PDF Files (*.pdf), *.pdf", _

    Title:="Select Folder and File Name to Save as PDF")

     

    If myfile <> "False" Then

    ThisRng.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _

    myfile, Quality:=xlQualityStandard, IncludeDocProperties:=True, _

    IgnorePrintAreas:=False, OpenAfterPublish:=True

    Else

    MsgBox "No File Selected. PDF will not be saved", vbOKOnly, "No File Selected"

    End If

    End Sub

     

    Sub SpellCheckInSpecificSheets()
    Worksheets("Sheet1").CheckSpelling

    End Sub

    Sub SpellCheckInSelectedCells()
    Selection.CheckSpelling
    End Sub

    Leave a comment

    Thanks for choosing to leave a comment. Please keep in mind that all the comments are moderated as per our comment policy, and your email will not be published for privacy reasons. Please leave a personal & meaningful conversation.

    Please  login to add a comment

    Other comments...

    No comments yet!
    Be the first to add a comment

    Read more Projects by Anupama Yeragudipati (21)

    Project 2

    Objective:

    First KMeans (Initial Run) Objective: To apply KMeans clustering on the car dataset (likely based on features like fuel type, city mpg, highway mpg, etc.), without much prior tuning or pre-processing. Steps: Standard KMeans clustering applied using default parameters (e.g., random initialization, fixed number of clusters).…

    calendar

    28 Apr 2025 12:48 PM IST

      Read more

      Project 1

      Objective:

      ???? Automobile Dataset (1985) Analysis – Project Report ???? Objective The purpose of this project is to perform data cleaning, exploratory data analysis (EDA), and basic machine learning modeling on the 1985 Automobile dataset. This analysis aims to uncover insights into vehicle fuel efficiency, engine performance, and trends…

      calendar

      09 Apr 2025 06:25 PM IST

        Read more

        Unsupervised Learning - Kmeans Week 11 Challenge

        Objective:

        How does similarity is calculated if data is categorical in nature1. Hamming Distance Used when categorical variables are binary (0/1, Yes/No, True/False). It calculates the number of positions at which two strings of equal length are different. Formula: d(x,y)=∑i=1nI(xi≠yi)d(x, y) = \sum_{i=1}^{n} I(x_i \neq y_i)d(x,y)=i=1∑n​I(xi​=yi​)…

        calendar

        06 Apr 2025 05:16 PM IST

          Read more

          Supervised Learning - Classification Week 9 Challenge

          Objective:

          1. What is a Neural Network?A Neural Network is a computational model inspired by the human brain. It consists of layers of artificial neurons that process input data to make predictions or classifications. It is commonly used in machine learning for tasks like image recognition, speech processing, and pattern detection.…

          calendar

          24 Mar 2025 04:10 PM IST

            Read more

            Schedule a counselling session

            Please enter your name
            Please enter a valid email
            Please enter a valid number

            Related Courses

            coursecard

            Design loads considered on bridges

            Recently launched

            10 Hours of Content

            coursecard

            Design of Steel Superstructure in Bridges

            Recently launched

            16 Hours of Content

            coursecard

            Design for Manufacturability (DFM)

            Recently launched

            11 Hours of Content

            coursecard

            CATIA for Medical Product Design

            Recently launched

            5 Hours of Content

            coursecardcoursetype

            Accelerated Career Program in Embedded Systems (On-Campus) Courseware Partner: IT-ITes SSC nasscom

            Recently launched

            0 Hours of Content

            Schedule a counselling session

            Please enter your name
            Please enter a valid email
            Please enter a valid number

            logo

            Skill-Lync offers industry relevant advanced engineering courses for engineering students by partnering with industry experts.

            https://d27yxarlh48w6q.cloudfront.net/web/v1/images/facebook.svghttps://d27yxarlh48w6q.cloudfront.net/web/v1/images/insta.svghttps://d27yxarlh48w6q.cloudfront.net/web/v1/images/twitter.svghttps://d27yxarlh48w6q.cloudfront.net/web/v1/images/youtube.svghttps://d27yxarlh48w6q.cloudfront.net/web/v1/images/linkedin.svg

            Our Company

            News & EventsBlogCareersGrievance RedressalSkill-Lync ReviewsTermsPrivacy PolicyBecome an Affiliate
            map
            EpowerX Learning Technologies Pvt Ltd.
            4th Floor, BLOCK-B, Velachery - Tambaram Main Rd, Ram Nagar South, Madipakkam, Chennai, Tamil Nadu 600042.
            mail
            info@skill-lync.com
            mail
            ITgrievance@skill-lync.com

            Top Individual Courses

            Computational Combustion Using Python and CanteraIntroduction to Physical Modeling using SimscapeIntroduction to Structural Analysis using ANSYS WorkbenchIntroduction to Structural Analysis using ANSYS Workbench

            Top PG Programs

            Post Graduate Program in Hybrid Electric Vehicle Design and AnalysisPost Graduate Program in Computational Fluid DynamicsPost Graduate Program in CADPost Graduate Program in Electric Vehicle Design & Development

            Skill-Lync Plus

            Executive Program in Electric Vehicle Embedded SoftwareExecutive Program in Electric Vehicle DesignExecutive Program in Cybersecurity

            Trending Blogs

            Heat Transfer Principles in Energy-Efficient Refrigerators and Air Conditioners Advanced Modeling and Result Visualization in Simscape Exploring Simulink and Library Browser in Simscape Advanced Simulink Tools and Libraries in SimscapeExploring Simulink Basics in Simscape

            © 2025 Skill-Lync Inc. All Rights Reserved.

                        Do You Want To Showcase Your Technical Skills?
                        Sign-Up for our projects.