Create a dial effect with Excel columnHow can I merge contents of 2 cells into 1 and shift the remaining...
What's the point of deactivating Num Lock on login screens?
A newer friend of my brother's gave him a load of baseball cards that are supposedly extremely valuable. Is this a scam?
Alternative to sending password over mail?
Revoked SSL certificate
What does it mean to describe someone as a butt steak?
How is the claim "I am in New York only if I am in America" the same as "If I am in New York, then I am in America?
What does the "remote control" for a QF-4 look like?
What would happen to a modern skyscraper if it rains micro blackholes?
Watching something be written to a file live with tail
What typically incentivizes a professor to change jobs to a lower ranking university?
Is it possible to do 50 km distance without any previous training?
infared filters v nd
Why does Kotter return in Welcome Back Kotter?
Is it inappropriate for a student to attend their mentor's dissertation defense?
Can a monk's single staff be considered dual wielded, as per the Dual Wielder feat?
Can an x86 CPU running in real mode be considered to be basically an 8086 CPU?
What is the word for reserving something for yourself before others do?
When a company launches a new product do they "come out" with a new product or do they "come up" with a new product?
How much RAM could one put in a typical 80386 setup?
High voltage LED indicator 40-1000 VDC without additional power supply
What is a clear way to write a bar that has an extra beat?
RSA: Danger of using p to create q
LWC SFDX source push error TypeError: LWC1009: decl.moveTo is not a function
What doth I be?
Create a dial effect with Excel column
How can I merge contents of 2 cells into 1 and shift the remaining columns in Excel?Excel formula to count when value changes?How to create a dynamically updating variable in MS ExcelHow do you create an Excel table with row headers instead of column headers?Excel - How to return a list of values in one column if a value in another column meets certain criteriaIn Excel have a cell read specific text when two others equal a certain valueFind keywords in paragraphs of text (in Excel)Excel Pivot Table with Multiple IndexesIs there a way to mark/tag an excel cell?Excel: Grading Formula to Omit Certain Cells
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}
I'm looking for a way to take a column of a small but arbitrary length and create a dial effect. I want to be able to shift a column down any amount, and then when the cells go over the set arbitrary amount for the cell contents to go back on top.
For illustration, see this picture of a dial lock. This is essentially what I'm trying to do:
I'm trying to crack a crypt for a class and this would make it much easier.
It doesn't need to be in Excel. If there's a web app that can do that, it would be even better, however Excel has easy manipulation so it would be easiest to implement from scratch probably.
microsoft-excel
New contributor
|
show 2 more comments
I'm looking for a way to take a column of a small but arbitrary length and create a dial effect. I want to be able to shift a column down any amount, and then when the cells go over the set arbitrary amount for the cell contents to go back on top.
For illustration, see this picture of a dial lock. This is essentially what I'm trying to do:
I'm trying to crack a crypt for a class and this would make it much easier.
It doesn't need to be in Excel. If there's a web app that can do that, it would be even better, however Excel has easy manipulation so it would be easiest to implement from scratch probably.
microsoft-excel
New contributor
So are you looking for a function that simply rotates though the alphabet and goes back to A when it reaches Z, and for that function to be triggered by some sort of "shift amount" cell value? (Anyway, I'm sure there are plenty of Caesar cipher tools available online - why Excel? :) )
– Niayesh Isky
21 hours ago
@NiayeshIsky Yes but it isn't the alphabet meaning the values can be alphanumeric, numbers, or letters in random order... I guess a Caesar cipher would've been a better analogy
– Yuriy F
21 hours ago
If it is a Caesar cipher, even if it's alphanumeric, then this decoder may be easier and faster to use than making an Excel sheet (note that it has a ROT-18 function for alphanumeric ciphers).
– Niayesh Isky
21 hours ago
@NiayeshIsky it isn't a standard set... for example, one 'alphabet' or excel column could be "IAGDIORRAESEMCGMIIEDEOANS". Then there are 3 other such strings of equal length and I want to be able to move them each individually, like you would a lock (see pic above)
– Yuriy F
20 hours ago
Oh I see, you're describing a polyalphabetic cipher with changing character sets. That's doable in Excel, though a quick implementation won't be very pretty :)
– Niayesh Isky
20 hours ago
|
show 2 more comments
I'm looking for a way to take a column of a small but arbitrary length and create a dial effect. I want to be able to shift a column down any amount, and then when the cells go over the set arbitrary amount for the cell contents to go back on top.
For illustration, see this picture of a dial lock. This is essentially what I'm trying to do:
I'm trying to crack a crypt for a class and this would make it much easier.
It doesn't need to be in Excel. If there's a web app that can do that, it would be even better, however Excel has easy manipulation so it would be easiest to implement from scratch probably.
microsoft-excel
New contributor
I'm looking for a way to take a column of a small but arbitrary length and create a dial effect. I want to be able to shift a column down any amount, and then when the cells go over the set arbitrary amount for the cell contents to go back on top.
For illustration, see this picture of a dial lock. This is essentially what I'm trying to do:
I'm trying to crack a crypt for a class and this would make it much easier.
It doesn't need to be in Excel. If there's a web app that can do that, it would be even better, however Excel has easy manipulation so it would be easiest to implement from scratch probably.
microsoft-excel
microsoft-excel
New contributor
New contributor
edited 20 hours ago
karel
9,35493339
9,35493339
New contributor
asked 21 hours ago
Yuriy FYuriy F
12
12
New contributor
New contributor
So are you looking for a function that simply rotates though the alphabet and goes back to A when it reaches Z, and for that function to be triggered by some sort of "shift amount" cell value? (Anyway, I'm sure there are plenty of Caesar cipher tools available online - why Excel? :) )
– Niayesh Isky
21 hours ago
@NiayeshIsky Yes but it isn't the alphabet meaning the values can be alphanumeric, numbers, or letters in random order... I guess a Caesar cipher would've been a better analogy
– Yuriy F
21 hours ago
If it is a Caesar cipher, even if it's alphanumeric, then this decoder may be easier and faster to use than making an Excel sheet (note that it has a ROT-18 function for alphanumeric ciphers).
– Niayesh Isky
21 hours ago
@NiayeshIsky it isn't a standard set... for example, one 'alphabet' or excel column could be "IAGDIORRAESEMCGMIIEDEOANS". Then there are 3 other such strings of equal length and I want to be able to move them each individually, like you would a lock (see pic above)
– Yuriy F
20 hours ago
Oh I see, you're describing a polyalphabetic cipher with changing character sets. That's doable in Excel, though a quick implementation won't be very pretty :)
– Niayesh Isky
20 hours ago
|
show 2 more comments
So are you looking for a function that simply rotates though the alphabet and goes back to A when it reaches Z, and for that function to be triggered by some sort of "shift amount" cell value? (Anyway, I'm sure there are plenty of Caesar cipher tools available online - why Excel? :) )
– Niayesh Isky
21 hours ago
@NiayeshIsky Yes but it isn't the alphabet meaning the values can be alphanumeric, numbers, or letters in random order... I guess a Caesar cipher would've been a better analogy
– Yuriy F
21 hours ago
If it is a Caesar cipher, even if it's alphanumeric, then this decoder may be easier and faster to use than making an Excel sheet (note that it has a ROT-18 function for alphanumeric ciphers).
– Niayesh Isky
21 hours ago
@NiayeshIsky it isn't a standard set... for example, one 'alphabet' or excel column could be "IAGDIORRAESEMCGMIIEDEOANS". Then there are 3 other such strings of equal length and I want to be able to move them each individually, like you would a lock (see pic above)
– Yuriy F
20 hours ago
Oh I see, you're describing a polyalphabetic cipher with changing character sets. That's doable in Excel, though a quick implementation won't be very pretty :)
– Niayesh Isky
20 hours ago
So are you looking for a function that simply rotates though the alphabet and goes back to A when it reaches Z, and for that function to be triggered by some sort of "shift amount" cell value? (Anyway, I'm sure there are plenty of Caesar cipher tools available online - why Excel? :) )
– Niayesh Isky
21 hours ago
So are you looking for a function that simply rotates though the alphabet and goes back to A when it reaches Z, and for that function to be triggered by some sort of "shift amount" cell value? (Anyway, I'm sure there are plenty of Caesar cipher tools available online - why Excel? :) )
– Niayesh Isky
21 hours ago
@NiayeshIsky Yes but it isn't the alphabet meaning the values can be alphanumeric, numbers, or letters in random order... I guess a Caesar cipher would've been a better analogy
– Yuriy F
21 hours ago
@NiayeshIsky Yes but it isn't the alphabet meaning the values can be alphanumeric, numbers, or letters in random order... I guess a Caesar cipher would've been a better analogy
– Yuriy F
21 hours ago
If it is a Caesar cipher, even if it's alphanumeric, then this decoder may be easier and faster to use than making an Excel sheet (note that it has a ROT-18 function for alphanumeric ciphers).
– Niayesh Isky
21 hours ago
If it is a Caesar cipher, even if it's alphanumeric, then this decoder may be easier and faster to use than making an Excel sheet (note that it has a ROT-18 function for alphanumeric ciphers).
– Niayesh Isky
21 hours ago
@NiayeshIsky it isn't a standard set... for example, one 'alphabet' or excel column could be "IAGDIORRAESEMCGMIIEDEOANS". Then there are 3 other such strings of equal length and I want to be able to move them each individually, like you would a lock (see pic above)
– Yuriy F
20 hours ago
@NiayeshIsky it isn't a standard set... for example, one 'alphabet' or excel column could be "IAGDIORRAESEMCGMIIEDEOANS". Then there are 3 other such strings of equal length and I want to be able to move them each individually, like you would a lock (see pic above)
– Yuriy F
20 hours ago
Oh I see, you're describing a polyalphabetic cipher with changing character sets. That's doable in Excel, though a quick implementation won't be very pretty :)
– Niayesh Isky
20 hours ago
Oh I see, you're describing a polyalphabetic cipher with changing character sets. That's doable in Excel, though a quick implementation won't be very pretty :)
– Niayesh Isky
20 hours ago
|
show 2 more comments
1 Answer
1
active
oldest
votes
I will describe how to do the dial effect like the lock, if you want to crack a code you should follow the advice of commenters.
The idea for this solution is to have your string of letters in one cell and each row of the dial will extract one letter with MID
. MOD
will be used to make the looping effect.
Insert the string of letters in the cell A1, the other cells of the first row will be used to get the position of each column of the dial.
Add spin buttons through the developer tab in the ribbon and link each one of them with one cell of the first row (you should have one for each column in your dial, I chose two in the example below).
In the first cell of the first dial column, put this formula :
=MID($A$1,1+MOD(C$1+ROW()-ROW($C$2),LEN($A$1)),1)
Then extend for as many columns as you want and as many rows as there are characters in A1.
How this works :
MID($A$1,<N>,1)
will extract the Nth character from cell A1
C$1+ROW()-ROW($C$2)
gets the position of the dial
1+MOD(<P>,LEN($A$1))
loops the position to the first one if it is greater than the length of the string in A1
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Yuriy F is a new contributor. Be nice, and check out our Code of Conduct.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1421691%2fcreate-a-dial-effect-with-excel-column%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
I will describe how to do the dial effect like the lock, if you want to crack a code you should follow the advice of commenters.
The idea for this solution is to have your string of letters in one cell and each row of the dial will extract one letter with MID
. MOD
will be used to make the looping effect.
Insert the string of letters in the cell A1, the other cells of the first row will be used to get the position of each column of the dial.
Add spin buttons through the developer tab in the ribbon and link each one of them with one cell of the first row (you should have one for each column in your dial, I chose two in the example below).
In the first cell of the first dial column, put this formula :
=MID($A$1,1+MOD(C$1+ROW()-ROW($C$2),LEN($A$1)),1)
Then extend for as many columns as you want and as many rows as there are characters in A1.
How this works :
MID($A$1,<N>,1)
will extract the Nth character from cell A1
C$1+ROW()-ROW($C$2)
gets the position of the dial
1+MOD(<P>,LEN($A$1))
loops the position to the first one if it is greater than the length of the string in A1
add a comment |
I will describe how to do the dial effect like the lock, if you want to crack a code you should follow the advice of commenters.
The idea for this solution is to have your string of letters in one cell and each row of the dial will extract one letter with MID
. MOD
will be used to make the looping effect.
Insert the string of letters in the cell A1, the other cells of the first row will be used to get the position of each column of the dial.
Add spin buttons through the developer tab in the ribbon and link each one of them with one cell of the first row (you should have one for each column in your dial, I chose two in the example below).
In the first cell of the first dial column, put this formula :
=MID($A$1,1+MOD(C$1+ROW()-ROW($C$2),LEN($A$1)),1)
Then extend for as many columns as you want and as many rows as there are characters in A1.
How this works :
MID($A$1,<N>,1)
will extract the Nth character from cell A1
C$1+ROW()-ROW($C$2)
gets the position of the dial
1+MOD(<P>,LEN($A$1))
loops the position to the first one if it is greater than the length of the string in A1
add a comment |
I will describe how to do the dial effect like the lock, if you want to crack a code you should follow the advice of commenters.
The idea for this solution is to have your string of letters in one cell and each row of the dial will extract one letter with MID
. MOD
will be used to make the looping effect.
Insert the string of letters in the cell A1, the other cells of the first row will be used to get the position of each column of the dial.
Add spin buttons through the developer tab in the ribbon and link each one of them with one cell of the first row (you should have one for each column in your dial, I chose two in the example below).
In the first cell of the first dial column, put this formula :
=MID($A$1,1+MOD(C$1+ROW()-ROW($C$2),LEN($A$1)),1)
Then extend for as many columns as you want and as many rows as there are characters in A1.
How this works :
MID($A$1,<N>,1)
will extract the Nth character from cell A1
C$1+ROW()-ROW($C$2)
gets the position of the dial
1+MOD(<P>,LEN($A$1))
loops the position to the first one if it is greater than the length of the string in A1
I will describe how to do the dial effect like the lock, if you want to crack a code you should follow the advice of commenters.
The idea for this solution is to have your string of letters in one cell and each row of the dial will extract one letter with MID
. MOD
will be used to make the looping effect.
Insert the string of letters in the cell A1, the other cells of the first row will be used to get the position of each column of the dial.
Add spin buttons through the developer tab in the ribbon and link each one of them with one cell of the first row (you should have one for each column in your dial, I chose two in the example below).
In the first cell of the first dial column, put this formula :
=MID($A$1,1+MOD(C$1+ROW()-ROW($C$2),LEN($A$1)),1)
Then extend for as many columns as you want and as many rows as there are characters in A1.
How this works :
MID($A$1,<N>,1)
will extract the Nth character from cell A1
C$1+ROW()-ROW($C$2)
gets the position of the dial
1+MOD(<P>,LEN($A$1))
loops the position to the first one if it is greater than the length of the string in A1
answered 16 hours ago
StormweakerStormweaker
965
965
add a comment |
add a comment |
Yuriy F is a new contributor. Be nice, and check out our Code of Conduct.
Yuriy F is a new contributor. Be nice, and check out our Code of Conduct.
Yuriy F is a new contributor. Be nice, and check out our Code of Conduct.
Yuriy F is a new contributor. Be nice, and check out our Code of Conduct.
Thanks for contributing an answer to Super User!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1421691%2fcreate-a-dial-effect-with-excel-column%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
So are you looking for a function that simply rotates though the alphabet and goes back to A when it reaches Z, and for that function to be triggered by some sort of "shift amount" cell value? (Anyway, I'm sure there are plenty of Caesar cipher tools available online - why Excel? :) )
– Niayesh Isky
21 hours ago
@NiayeshIsky Yes but it isn't the alphabet meaning the values can be alphanumeric, numbers, or letters in random order... I guess a Caesar cipher would've been a better analogy
– Yuriy F
21 hours ago
If it is a Caesar cipher, even if it's alphanumeric, then this decoder may be easier and faster to use than making an Excel sheet (note that it has a ROT-18 function for alphanumeric ciphers).
– Niayesh Isky
21 hours ago
@NiayeshIsky it isn't a standard set... for example, one 'alphabet' or excel column could be "IAGDIORRAESEMCGMIIEDEOANS". Then there are 3 other such strings of equal length and I want to be able to move them each individually, like you would a lock (see pic above)
– Yuriy F
20 hours ago
Oh I see, you're describing a polyalphabetic cipher with changing character sets. That's doable in Excel, though a quick implementation won't be very pretty :)
– Niayesh Isky
20 hours ago