Weekly Challenges

rmassambane · ‎01-26-2020

Nice one! I'm going to try Section III another day!

Pang_Hee_Choy · ‎02-11-2020

I have another solution for Section 3. Which also indicate by the site from JohnJPS

It also ease to encoded.

Spoiler

After I replace all the Text/Character to RecordID it become like this.

After I convert to List. I found there have a fixed movement. which is Add 192 and the next will be minus 145.

Hence I create a list to test. I found another issue, it over 336 recordID.

After an analysis, it equal to the list when i used MOD( [Test] , 337) (I have no idea why not 336)

then base on this logic. we can ease to build a workflow for this.

After I replace all the Text/Character to RecordID it become like this.After I convert to List. I found there have a fixed movement. which is Add 192 and the next will be minus 145.Hence I create a list to test. I found another issue, it over 336 recordID. After an analysis, it equal to the list when i used MOD( [Test] , 337) (I have no idea why not 336)then base on this logic. we can ease to build a workflow for this.

Here my workflow

JohnJPS · ‎02-12-2020

@Pang_Hee_Choy,

Great work - very nice and concise. Mod(337) is a Mod of the length of the original text: and also, 192 + 145 = 337, that same length. So, what you've just created is a very quick/easy way to address any such mapping by using your trick of adding things up and the applying the Mod() function to specify the entire transposition: even if you didn't have the hint we found at the website, you could run through an iterative macro that tries 1/336 then 2/335 and etc up through all possibilities, and one of the outputs will be the correct answer. A great tool to have in your bag of tricks. My second solution does something similar, but at first glance, yours definitely looks more efficient.

Again - great job!

- John

dsmdavid · ‎02-24-2020

Sections I & II. Need to spend some more time to understand S.III

Spoiler

atcodedog05 · ‎04-05-2020

This was a great challenge. Need to come back again to work more on this.

hanykowska · ‎05-20-2020

hat's a good challenge! Will tackle sections III and IV another time (mostly because I saw some hints so now I'm trying to forget them and try again with a clear-ish mind).

Spoiler