Showing posts with label Tools. Show all posts
Showing posts with label Tools. Show all posts

Wednesday, February 12, 2014

Tools: Excel Password Breaker

Ever had an excel file whose password you have forgotten and you needed to change one of the cells that is locked?

Well now you can use an excel to "break" the other excel workbook!

Instructions: 

1) Save Password Breaker file into the same folder as the password protected file you intend to break.

If you need to break the password for a protected Workbook,

2a) Open Password Breaker file and type in the name of the file in cell . Please remember to include the correct file extension , i.e. ".xlsx",".xls",".xlsm"

3a)  Click on Break Excel Workbook button. Once password is broken, a message box will appear informing you that the file has been cracked. Save file to continue. Please note that this process takes some time (approximately 5-20min, depending on your  processing ability).

If you need to break the password for a protected Worksheet,

2b) Open Password Breaker file and type in the name of the file in cell and the name of the sheet in cell . Please remember to include the file extension , i.e. ".xlsx",".xls",".xlsm"


3b)  Click on Break Excel Worksheet button. Once password is broken, a message box will appear informing you that the file has been cracked. Save file to continue. Please note that this process takes some time (approximately 5-20min, depending on your  processing ability).

Download link:
https://drive.google.com/file/d/0B9IgWwXHEwE6QnV5YjRLNXZaSWs/edit?usp=sharing

Note: This excel runs on macros and requires macros to be enabled. To enable macros view instructions in the link below:

http://office.microsoft.com/en-sg/excel-help/enable-macros-to-run-HP001119579.aspx


PS: Please do not abuse the purpose of this tool. This tool should only be used to break protected excel workbooks in which you have permission/authority to edit but may have forgotten the password on. Do not use this tool for illegal purposes. Thanks.

L.A.M.

If you liked this, you might also like other tools available on my blog:

NRIC Suffix Checker

Property Valuation Tool

When to Sell My Flat Tool

Military Expenditure Simulator

L.A.M. Tools: NRIC Suffix Checker



The NRIC or the National Registration Identity Card is a identity document used in Singapore. There is a prefix (S,T,F, or G) depending on the status of the holder.
  • Singapore citizens and permanent residents born before the year 2000 are assigned the letter "S".
  • Singapore citizens and permanent residents born in and after 2000 are assigned the letter "T".
  • Foreigners holding employment or student passes issued before 2000 are assigned the letter "F".
  • Foreigners holding employment or student passes issued in and after 2000 are assigned the letter "G".
This is followed by a 7 digit serial number assigned to the document holder.

Finally, there is a suffix, a checksum letter calculated based on the prefix and the 7 digit serial number. This is based on an algorithm that is not publicly available, however, you can use the tool below to "calculate" the suffix of any NRIC number.






Do you know?
The first 4 NRIC numbers numerically are

1) S0000001I (Yusof bin Ishak, first President of Singapore, deceased November 1970)

2) S0000002G (first Chief Justice of Singapore Wee Chong Jin, deceased June 2005)
3) S0000003E (first Prime Minister of Singapore Lee Kuan Yew, deceased March 2015), 
4) S0000004C (Kwa Geok Choo, wife of Lee Kuan Yew, deceased October 2010) .

L.A.M.

If you liked this, you might also like:

L.A.M. Tools: Excel Password Breaker

L.A.M on Whether Our Military Spending is Too High