My Beale Cipher Decoder

[chalkoutline]

Hello,

I have attached my Excel workbook for numbering and decoding the Declaration of Independence (DOI). It was too large to upload it so it is zipped.

STEP 2 - DECODER WORKSHEET
The Decoder worksheet is set to “1820 Declaration of Independence” and “Cipher 2”. Both are dropdown lists which can be used to select other documents and choose between Cipher 1, 2 or 3.

The Decoder also has a table which allows up to 12 shifts. One must enter a starting location and the amount you would like to shift. The DOI requires 4 shifts (i.e., 245, 485, 625 and 668) to account for skipped word when the creator numbered the DOI.

The decoded message is shown below starting at Row 44. You will find several colored cells that correspond to the “shift” entered. For example: The heading for Shift 1 is GREEN. When you enter values for Shift 1, the letters that change in the message will be highlighted to GREEN also.
You can scroll up and down through the decoded message using your mouse.

1820 DECLARTION WORKSHEET
The 1820 DOI tab shows the original document I used and how I had to modify it to fully decode the message.

STEP 1 – CSV FILE WORKSHEET
This Decoder may also be used for any other documents by creating a CSV file and copying it to one of the formatted lines in this worksheet.

There are a few more DECODER features when dealing with a new document.
1. Use First Letter or Last letter of the word.
2. Read the document forwards or backwards
3. Set the start point for the document. This allows you to begin decoding after titled, TOCs, Prefaces, etc.
4. You may also set a start point for the Decoded message. For example: If you would like to see the Gillowby strings, keep the document set to 1820 Declaration of Independence but use the drop down list to select Cipher 1. The decoded message will change to gibberish. However, by changing the value for the “Cipher Start” from 1 to 188, the Gillowby string ABCDEFGHIIJKLMMNOHP will appear in Row 44 avoiding the need to scroll.

I have included instruction worksheets as well.

 

[chalkoutline]

Hello,

I have attached my Excel workbook for numbering and decoding the Declaration of Independence (DOI). It was too large to upload it so it is zipped.

STEP 2 - DECODER WORKSHEET
The Decoder worksheet is set to “1820 Declaration of Independence” and “Cipher 2”. Both are dropdown lists which can be used to select other documents and choose between Cipher 1, 2 or 3.

The Decoder also has a table which allows up to 12 shifts. One must enter a starting location and the amount you would like to shift. The DOI requires 4 shifts (i.e., 245, 485, 625 and 668) to account for skipped word when the creator numbered the DOI.

The decoded message is shown below starting at Row 44. You will find several colored cells that correspond to the “shift” entered. For example: The heading for Shift 1 is GREEN. When you enter values for Shift 1, the letters that change in the message will be highlighted to GREEN also.
You can scroll up and down through the decoded message using your mouse.

1820 DECLARTION WORKSHEET
The 1820 DOI tab shows the original document I used and how I had to modify it to fully decode the message.

STEP 1 – CSV FILE WORKSHEET
This Decoder may also be used for any other documents by creating a CSV file and copying it to one of the formatted lines in this worksheet.

There are a few more DECODER features when dealing with a new document.
1. Use First Letter or Last letter of the word.
2. Read the document forwards or backwards
3. Set the start point for the document. This allows you to begin decoding after titled, TOCs, Prefaces, etc.
4. You may also set a start point for the Decoded message. For example: If you would like to see the Gillowby strings, keep the document set to 1820 Declaration of Independence but use the drop down list to select Cipher 1. The decoded message will change to gibberish. However, by changing the value for the “Cipher Start” from 1 to 188, the Gillowby string ABCDEFGHIIJKLMMNOHP will appear in Row 44 avoiding the need to scroll.

I have included instruction worksheets as well.

BTW, to see the TB signature, you must keep "Cipher 1" selected, choose DOI -1885 pamphlet, and clear all "Shift numbers ". Then scroll to the bottom of the gibberish and you will see "TB" right before the zeros start.

There is a lot going on in this work so you can only access designated cells..

 

[chalkoutline]

Hello,

I have attached my Excel workbook for numbering and decoding the Declaration of Independence (DOI). It was too large to upload it so it is zipped.

STEP 2 - DECODER WORKSHEET
The Decoder worksheet is set to “1820 Declaration of Independence” and “Cipher 2”. Both are dropdown lists which can be used to select other documents and choose between Cipher 1, 2 or 3.

The Decoder also has a table which allows up to 12 shifts. One must enter a starting location and the amount you would like to shift. The DOI requires 4 shifts (i.e., 245, 485, 625 and 668) to account for skipped word when the creator numbered the DOI.

The decoded message is shown below starting at Row 44. You will find several colored cells that correspond to the “shift” entered. For example: The heading for Shift 1 is GREEN. When you enter values for Shift 1, the letters that change in the message will be highlighted to GREEN also.
You can scroll up and down through the decoded message using your mouse.

1820 DECLARTION WORKSHEET
The 1820 DOI tab shows the original document I used and how I had to modify it to fully decode the message.

STEP 1 – CSV FILE WORKSHEET
This Decoder may also be used for any other documents by creating a CSV file and copying it to one of the formatted lines in this worksheet.

There are a few more DECODER features when dealing with a new document.
1. Use First Letter or Last letter of the word.
2. Read the document forwards or backwards
3. Set the start point for the document. This allows you to begin decoding after titled, TOCs, Prefaces, etc.
4. You may also set a start point for the Decoded message. For example: If you would like to see the Gillowby strings, keep the document set to 1820 Declaration of Independence but use the drop down list to select Cipher 1. The decoded message will change to gibberish. However, by changing the value for the “Cipher Start” from 1 to 188, the Gillowby string ABCDEFGHIIJKLMMNOHP will appear in Row 44 avoiding the need to scroll.

I have included instruction worksheets as well.

For the first time to open this workbook on my phone and it was difficultand slow. I recommend only using a pc.

 

[Katytech]

Hello,

I have attached my Excel workbook for numbering and decoding the Declaration of Independence (DOI). It was too large to upload it so it is zipped.

STEP 2 - DECODER WORKSHEET
The Decoder worksheet is set to “1820 Declaration of Independence” and “Cipher 2”. Both are dropdown lists which can be used to select other documents and choose between Cipher 1, 2 or 3.

The Decoder also has a table which allows up to 12 shifts. One must enter a starting location and the amount you would like to shift. The DOI requires 4 shifts (i.e., 245, 485, 625 and 668) to account for skipped word when the creator numbered the DOI.

The decoded message is shown below starting at Row 44. You will find several colored cells that correspond to the “shift” entered. For example: The heading for Shift 1 is GREEN. When you enter values for Shift 1, the letters that change in the message will be highlighted to GREEN also.
You can scroll up and down through the decoded message using your mouse.

1820 DECLARTION WORKSHEET
The 1820 DOI tab shows the original document I used and how I had to modify it to fully decode the message.

STEP 1 – CSV FILE WORKSHEET
This Decoder may also be used for any other documents by creating a CSV file and copying it to one of the formatted lines in this worksheet.

There are a few more DECODER features when dealing with a new document.
1. Use First Letter or Last letter of the word.
2. Read the document forwards or backwards
3. Set the start point for the document. This allows you to begin decoding after titled, TOCs, Prefaces, etc.
4. You may also set a start point for the Decoded message. For example: If you would like to see the Gillowby strings, keep the document set to 1820 Declaration of Independence but use the drop down list to select Cipher 1. The decoded message will change to gibberish. However, by changing the value for the “Cipher Start” from 1 to 188, the Gillowby string ABCDEFGHIIJKLMMNOHP will appear in Row 44 avoiding the need to scroll.

I have included instruction worksheets as well.

Fantastic work on the Decoder. I did this on paper (the long way) your process is so much easier.. I am having an issue with "Cipher 3". is there something i am missing? how can i correct it? Again, thank you for sharing.

 

[chalkoutline]

Fantastic work on the Decoder. I did this on paper (the long way) your process is so much easier.. I am having an issue with "Cipher 3". is there something i am missing? how can i correct it? Again, thank you for sharing.

Fantastic work on the Decoder. I did this on paper (the long way) your process is so much easier.. I am having an issue with "Cipher 3". is there something i am missing? how can i correct it? Again, thank you for sharing.

I am so sorry. I corrected Cipher 3 and attached RevA of the Beale Decoder. Thanks for letting me know.

 

[Katytech]

I am so sorry. I corrected Cipher 3 and attached RevA of the Beale Decoder. Thanks for letting me know.

Thank you for the quick reply. Again, great work. I am new to this adventure. still reading over all the post and read some great and quite frankly, over my head solves.. lol What a rabbit hole. i do enjoy a bit of hid and seek. It seems to me if this tail is true and there are only 3 main known cave systems in this area and only two with suitable land for farming. as stated in some documents i was reading Beale changed his mind on where to hid it due to farmers using the cave to store their crops, It makes seance he would have found a place between one of these 3 locations. and this location would need to be whare he would not worried about being farmed. This Leeds to some obvious locations, grave, (6 feet under) Side of the road, (Old forgotten trail) Root cellar, to name a few. Also, there are only two historic towns with in the 4-5 mile mark outside the tavern location. As you have stated, i keep reading someone has solved one of the other ciphers.. who knows, darn sure smarter folks than me out there. Im going thru other time line historical documents prior to 1820's. Thanks to you work it will save me a lot of writing. If i find anything of interest, i will be glad to send it your way and you can do with it as you will. I am to old to be digging and i need this kind of activity to keep me young.. lol