Ready to Start Your Career?

By: ProgrammerE
November 9, 2016
Creating Secure Passwords with Two Pieces of Paper

By: ProgrammerE
November 9, 2016

- Open Excel.
- Copy this formula into cell A1 - T20: "=IF(ROUND(RAND(),0)=0,CHAR(RANDBETWEEN(65, 90)),CHAR(RANDBETWEEN(97, 122)))" (Without the quotes) *This puts either a lower case or upper case letter in the cell, allowing for 26 * 2 = 52 different possible letters per Cell, for all 400 cells.
- Print this out and place it in easy to reach locations. This is your public key. Feel free to post it online, or stick it on your laptop.
- Open another Tab on this worksheet.
- Copy this formula into A1-A20: "=CHAR(RANDBETWEEN(65,84)) & RANDBETWEEN(1, 20)"
- Overlay a blank piece of paper on top of your public key.
- For each Row/Column combination as per step 5, outline the box with a pencil on your new sheet of paper.
- Cut out each of these boxes with scissors.
- Overlay the Paper. You should only see the 20 (or less, if two of the values in the second workbook were the same) values. This will be your password. The second piece of paper is your private key. Keep it secret.
- Repeat this for all the keys you need.
- For good security, replace private keys every 60 days (or every 30 if you want airtight security)
X | D | s | D | p |
z | e | N | G | l |
m | k | p | T | P |
z | j | e | u | F |
W | x | v | I | I |
D5 |
C1 |
E1 |
C5 |
A3 |