E Aadhaar password for mail copy PDF received from aadhaar@uidai.gov.in

Hi friends,

I have updated my Aadhaar details from Aadhaar update center.
It is mentioned that within 72 hours, my details will be updated.

Before 72 hours of my updated application, I had received an email from aadhaar@uidai.gov.in with an attachment which is password protected.

As I was unable to find the password to open the file in the sent mail, I have googled to find the answer. I have found mulitple options. You can try the following procedure to open the file with your password.

Procedure to open the document

1. Download the file
2. Rename the file by adding .pdf extension, if missing
3. Try the following passwords
• Password length is 8 characters
• First 4 characters of your name as mentioned in Aadhaar card (All small letters)
• Next 4 characters are your year of birth which is mentioned in Aadhaar card
• Password length is 6 characters
• Pin code of your address as per Aadhaar records
• Pin code of your enrolled area where you have applied the Aadhaar card
4. For me, 8 character password (first 4 characters of my name as mentioned in Aadhaar card + year of birth) worked.

Please send your feedback and queries to psrdotcom@gmail.com

Finding IP address to MAC and vice versa on same network (subnet) or different subnet which is reachable by ping

Hi all,

After long time I got a chance to write the blog.

 

This time it is related to networking.

 

Finding out which all the system up on the network

Syntax

cmd> nmap –sP < regex IP >

Example

cmd> nmap –sP 192.168.1.*

 

Finding MAC address of a device which is connected in same network

Syntax

cmd> ping <broadcast address>

cmd> arp –a [ <IP address> ]

 

Example

cmd> ping 192.168.1.255

cmd> arp –a –> Gives all the IP address and MAC address in the same subnet network

cmd> arp –a 192.168.1.25 –> Give the MAC of the specified IP address

 

arp –a : Lists all the IP addresses which are recently got into network with its MAC addresses

 

Finding MAC address of a device which is connected in same network but different subnet

Syntax

nbtstat –A <IP address>

Example

nbtstat –A 192.168.2.45

 

Please send your comments and feedback to psrdotcom@gmail.com

Finding missing records in worksheet w.r.t other worksheet (or) intersection of two worksheets

Description:

We have two worksheets with similar records with same structure)(not in number of records). We want to know missing records in one worksheet with reference to other worksheet (Or) we want to find the intersection of both sheets.

Solution

Workbooks used are Workbook1.xls, Workbook2.xls, Results.xls
Workbook1 is having Src1 worksheet
Workbook2 is having Src2 worksheet
Results.xls is having Dest1 worksheet which will have Src1-Src2 records

Results.xls is having Dest2 worksheet which will have Src2-Src1 records

    Dim Workbook1, Workbook2, Results As Workbook
    Dim Src1, Src2, Dest1, Dest2 As Sheet1
  
    Application.DisplayAlerts = False
    Application.EnableEvents = False
    Application.ScreenUpdating = False
  
    Windows("Workbook1.xls").Activate
    Set Workbook1= ActiveWorkbook
  
    Windows("Workbook2.xls").Activate
    Set Workbook2= ActiveWorkbook
  
    Windows("Results.xls").Activate
    Set Results = ActiveWorkbook
    
    'Renaming Results workbook sheet1 and sheet2 to Dest1 and Dest2
    Results.Sheets(1).Name = "Dest1"
    Results.Sheets(2).Name = "Dest2"

    Workbook1.Activate
    ActiveWorkbook.Sheets("Src1").Activate
    Set Src1= ActiveSheet
  
    Workbook2.Activate
    ActiveWorkbook.Sheets("Src2").Activate
    Set Src2= ActiveSheet
  
    Results.Activate
    ActiveWorkbook.Sheets("Dest1").Activate
    Set Dest1 = ActiveSheet
    ActiveWorkbook.Sheets("Dest2").Activate
    Set Dest2 = ActiveSheet
   
    Dim Src1rng As Range
    Dim Src2rng As Range
  
    'Select and assign range for Src1 sheet data
    Src1.Activate
    'Selecting range without headers by using offset(1,0)
    Set Src1rng= Range("A1").CurrentRegion.Offset(1, 0)

    'Select and assign range for Src2 sheet data
    Src2.Activate
    Set Src2rng= Range("A1").CurrentRegion.Offset(1, 0)
  
    Dim row_not_exist As Boolean
    'Select each row from the Src1rng
    Src1.Activate
    For Each Src1Row In Src1rng.Rows
        row_not_exist = True
        Src2.Activate
        For Each Src2Row In Src2rng.Rows
            'Comparing cell(s) in Src1rng with cell(s) with Src2rng
            If Src1Row.Cells(1).Value = Src2Row.Cells(1).Value Then
                If Src1Row.Cells(2).Value = Src2Row.Cells(2).Value Then
                            'if record exists in both sheets, no check needed further
                            row_not_exist = False
                            Exit For 'Don't compare with remaining records
                        End If
            End If
        Next Src2Row  'Go to next record in Src2


        'If Src1rng record not exists in Src2rng then 
        'copy the Src1 record into Results workbook Dest1 sheet
        If row_not_exist = True Then
            Src1.Activate
            Src1Row.Cells.Select
            Selection.Copy
            Dest1.Activate
            ActiveCell.Offset(1, 0).Select
            Dest1.Paste
            Application.CutCopyMode = xlCopy
        End If
    Next Src1Row  'Go to next record in Src1
    
    'we can find the viceversa by just changing the names from Src1 to Src2
  
    Application.DisplayAlerts = True
    Application.EnableEvents = True
    Application.ScreenUpdating = True

Sample Output:

Src1 Sheet data	Src2 Sheet data
Names Required ABC  DEF XYZ  WUV PSR  DOT	Names Required ABC  DEF GHI  LKV PSR  DOT
Dest1 Sheet	Dest2 Sheet
Names Required XYZ  WUV	Names Required GHI  LKV

Note:
Dest1 contains the missing(intersection) data, which available in Src1 but not in Src2
Dest2 contains the missing(intersection) data, which available in Src2 but not in Src1

Please let me know if any further queries, contact me psrdotcom@gmail.com 

Finding Date Difference in Excel and by using Macro

Date Difference in Excel

We can use Days360 function to find the days difference

Syntax: 
=days360(startdate, enddate, true)

Example:

A1	B1	C1
3/20/2010	3/26/2010

Type the any one of the following in C1 

To find the days difference, use
 =days360(A1,B1,True)
=B1-A1


To find months difference, use Month(B1)-Month(A1)


To find years difference, use Year(B1)-Year(A1)

Then the sheet A1 and B1 contains the following values with the Date format

A1	B1	C1
3/20/2010	3/26/2010	6

Note: It will return integer value so don't format the resultant(C1) cell to Date.

Date difference by using macro

We can use the datediff function to find the days, months, years difference between two dates

Syntax:
Cell.Value = datediff(interval, Range("startdate_cell").Value, Range("enddate_cell).Value)

Note:
interval can be any one of the following
d - days, m - months, y - years, ym - months excluding years, yd - days excluding years, md - days excluding years and months

Example:
Range("C1").Value = datediff("d", Range("A1").Value, Range("B1").Value)

References:
 http://office.microsoft.com/en-au/excel-help/calculate-the-difference-between-two-dates-HP010070467.aspx

http://www.cpearson.com/excel/datedif.aspx