Skip to content

Instantly share code, notes, and snippets.

@atoponce

atoponce/readme.md

Last active January 24, 2023 04:01
Show Gist options
  • Save atoponce/9b28b087c105f3f242a54d257275310c to your computer and use it in GitHub Desktop.
Save atoponce/9b28b087c105f3f242a54d257275310c to your computer and use it in GitHub Desktop.
Download ZIP
Spreadsheet password and passphrase generators
Raw
readme.md

Password and passphrase generators

The following code should work for Microsoft Excel and LibreOffice Calc spreadsheet software.

Password generator code

=CONCAT(CHAR(RANDBETWEEN(33,126)),CHAR(RANDBETWEEN(33,126)),CHAR(RANDBETWEEN(33,126)),CHAR(RANDBETWEEN(33,126)),CHAR(RANDBETWEEN(33,126)),CHAR(RANDBETWEEN(33,126)),CHAR(RANDBETWEEN(33,126)),CHAR(RANDBETWEEN(33,126)),CHAR(RANDBETWEEN(33,126)),CHAR(RANDBETWEEN(33,126)),CHAR(RANDBETWEEN(33,126)))

Passphrase generator code

Create a sheet called "EFF Short List" and paste the short list #1 into the sheet, with the dice rolls in the first column and the words in the second.

=CONCAT(INDEX($'EFF Short List'.B$1:$'EFF Short List'.B$1296,RANDBETWEEN(1,1296)),"-",INDEX($'EFF Short List'.B$1:$'EFF Short List'.B$1296,RANDBETWEEN(1,1296)),"-",INDEX($'EFF Short List'.B$1:$'EFF Short List'.B$1296,RANDBETWEEN(1,1296)),"-",INDEX($'EFF Short List'.B$1:$'EFF Short List'.B$1296,RANDBETWEEN(1,1296)),"-",INDEX($'EFF Short List'.B$1:$'EFF Short List'.B$1296,RANDBETWEEN(1,1296)),"-",INDEX($'EFF Short List'.B$1:$'EFF Short List'.B$1296,RANDBETWEEN(1,1296)),"-",INDEX($'EFF Short List'.B$1:$'EFF Short List'.B$1296,RANDBETWEEN(1,1296)))
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment