Create a dial effect with Excel columnHow can I merge contents of 2 cells into 1 and shift the remaining...
Perform and show arithmetic with LuaLaTeX
What's that red-plus icon near a text?
Is it unprofessional to ask if a job posting on GlassDoor is real?
Alternative to sending password over mail?
Modeling an IP Address
tikz convert color string to hex value
A newer friend of my brother's gave him a load of baseball cards that are supposedly extremely valuable. Is this a scam?
Can a vampire attack twice with their claws using Multiattack?
When a company launches a new product do they "come out" with a new product or do they "come up" with a new product?
NMaximize is not converging to a solution
Is it possible to run Internet Explorer on OS X El Capitan?
Did Shadowfax go to Valinor?
What defenses are there against being summoned by the Gate spell?
What's the point of deactivating Num Lock on login screens?
How do I deal with an unproductive colleague in a small company?
Arrow those variables!
Accidentally leaked the solution to an assignment, what to do now? (I'm the prof)
High voltage LED indicator 40-1000 VDC without additional power supply
meaning of に in 本当に?
Why do I get two different answers for this counting problem?
Why are electrically insulating heatsinks so rare? Is it just cost?
Paid for article while in US on F-1 visa?
How does one intimidate enemies without having the capacity for violence?
Rock identification in KY
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
edited 21 hours ago
karel
9,35493339
asked 22 hours ago
Yuriy FYuriy F
12
New contributor
Yuriy F is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
|
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
edited 21 hours ago
karel
9,35493339
asked 22 hours ago
Yuriy FYuriy F
12
New contributor
Yuriy F is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
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
22 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
22 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
22 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
22 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
21 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
edited 21 hours ago
karel
9,35493339
asked 22 hours ago
Yuriy FYuriy F
12
New contributor
Yuriy F is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
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
edited 21 hours ago
karel
9,35493339
asked 22 hours ago
Yuriy FYuriy F
12
New contributor
Yuriy F is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
edited 21 hours ago
karel
9,35493339
asked 22 hours ago
Yuriy FYuriy F
12
New contributor
Yuriy F is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
edited 21 hours ago
karel
9,35493339
edited 21 hours ago
karel
9,35493339
edited 21 hours ago
karel
9,35493339
9,35493339
asked 22 hours ago
Yuriy FYuriy F
12
New contributor
Yuriy F is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 22 hours ago
Yuriy FYuriy F
12
asked 22 hours ago
Yuriy FYuriy F
12
12
New contributor
Yuriy F is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
Yuriy F is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Yuriy F is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
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
22 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
22 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
22 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
22 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
21 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
22 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
22 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
22 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
22 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
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
22 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
22 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
22 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
22 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
22 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
22 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
22 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
22 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
21 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
21 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
answered 18 hours ago
StormweakerStormweaker
965
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
answered 18 hours ago
StormweakerStormweaker
965
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
answered 18 hours ago
StormweakerStormweaker
965
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
answered 18 hours ago
StormweakerStormweaker
965
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 18 hours ago
StormweakerStormweaker
965
answered 18 hours ago
StormweakerStormweaker
965
answered 18 hours ago
StormweakerStormweaker
965
answered 18 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
22 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
22 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
22 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
22 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
21 hours ago