chalkoutline
Jr. Member
- #1
Thread Owner
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.
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.
