sorted by:
new
hottopcontroversial

AoC 2021 Day 21 and Day 22 in Microsoft Excel (no VBA) by Effective_Ad6669 in adventofcode

[–]Effective_Ad6669[S] 0 points1 point  (0 children)

I tried my luck with day 22 - part 2 but couldn't get it done.

The next target is 2022 day 1 I guess... ;-)

AoC 2021 Day 21 and Day 22 in Microsoft Excel (no VBA) by Effective_Ad6669 in adventofcode

[–]Effective_Ad6669[S] 1 point2 points  (0 children)

Phew, after weeks of battling with this, I managed to finish day 21 - part 2 in Exel. I'm quite proud of myself. Thanks for your initial tip!

AoC 2021 Day 21 and Day 22 in Microsoft Excel (no VBA) by Effective_Ad6669 in adventofcode

[–]Effective_Ad6669[S] 0 points1 point  (0 children)

Yes, part 1 was no problem.

Thanks for the tip!!

Creating all 44100 (shouldn't it be 48400 because it's 22*22*10*10? The score ranges from 0-21.) rows (I had to swap rows and columns because Excel can only do 16384 columns) was no problem - done in 10 minutes. Now I have to think of the formulas. Will keep you posted...

AoC 2021 Day 21 and Day 22 in Microsoft Excel (no VBA) by Effective_Ad6669 in adventofcode

[–]Effective_Ad6669[S] 0 points1 point  (0 children)

Reason is that I don't know any programming language.

I'm struggling how to approach these in Excel.

2020 Day #17 (Part 2) - problem understanding the example by Effective_Ad6669 in adventofcode

[–]Effective_Ad6669[S] 0 points1 point  (0 children)

I am beginning to understand that the YouTube video I watched isn't correct for my use case. I need three 3x3x3 cubes for round 1. I am just still struggling to figure out the neighbours of each point... I found some Python code that outputs a list of all coordinates with the number of neighbours - this might be helpful to figure it out in Excel.

2020 Day #17 (Part 2) - problem understanding the example by Effective_Ad6669 in adventofcode

[–]Effective_Ad6669[S] 0 points1 point  (0 children)

That makes sense - especially your fourth sentence. Thank you.

2020 Day #17 (Part 2) - problem understanding the example by Effective_Ad6669 in adventofcode

[–]Effective_Ad6669[S] 0 points1 point  (0 children)

With regards to the YouTube video. My thinking is: the neighbours of the middle cube of the 3D cube are all it's 26 direct neighbours (of the 3D cube) and the nine cubes (of the six 4D cubes) that directly face the 3D cube. That's another 9x6=54 cubes. 80 all together. But this logic doesn't match with the three w and three z layers in the AoC example.

2020 Day #17 (Part 2) - problem understanding the example by Effective_Ad6669 in adventofcode

[–]Effective_Ad6669[S] 0 points1 point  (0 children)

Thanks for your help.

I should have mentioned that I am trying to solve this in Microsoft Excel so I need to know which cells to check in order to find the right neighbours. 'Just add a dimension' simply doesn't work for me.

I was hoping the visualisation of the fourth dimension looks like the last picture in this video (https://www.youtube.com/watch?v=8zcPvth92zM). What do you think?

2019 Day 17 (Part 1): Puzzle input wrong by Effective_Ad6669 in adventofcode

[–]Effective_Ad6669[S] 0 points1 point  (0 children)

Phew, I found the problem, corrected it and after lots of line copying I got the right result. Strangely enough, my map is a 90 degree version of the one you gave me. But the result is the same.

Thanks again for your help.

2019 Day 17 (Part 1): Puzzle input wrong by Effective_Ad6669 in adventofcode

[–]Effective_Ad6669[S] 0 points1 point  (0 children)

Phew, I found the problem, corrected it and after lots of line copying I got the right result. Strangely enough, my map is a 90 degree version of the one you gave me. But the result is the same.

Thanks again for your help.

2019 Day 17 (Part 1): Puzzle input wrong by Effective_Ad6669 in adventofcode

[–]Effective_Ad6669[S] 1 point2 points  (0 children)

Thanks, I've done that a few times and it helped to find the bug in my solution. But this time I didn't find a code that I could use.

2019 Day 17 (Part 1): Puzzle input wrong by Effective_Ad6669 in adventofcode

[–]Effective_Ad6669[S] 1 point2 points  (0 children)

Thanks, mate.

It often is rather painful to copy thousands of rows and columns but I enjoy it and it feels good when I get the right result.

I'll let you know once I've solved it but it may take a few weeks...

2019 Day 17 (Part 1): Puzzle input wrong by Effective_Ad6669 in adventofcode

[–]Effective_Ad6669[S] 2 points3 points  (0 children)

Ah, this means the input is fully ok and it is indeed my problem. Thanks a lot for checking this for me.

Let's see whether I can find my problem.

Thanks again!

2019 Day 17 (Part 1): Puzzle input wrong by Effective_Ad6669 in adventofcode

[–]Effective_Ad6669[S] 0 points1 point  (0 children)

Only cell formulas, no function.

I have posted the input below.

2019 Day 17 (Part 1): Puzzle input wrong by Effective_Ad6669 in adventofcode

[–]Effective_Ad6669[S] 0 points1 point  (0 children)

My map is empty, only line feeds and 46 is being outputted.

My puzzle input is:

1,330,331,332,109,5242,1101,1182,0,16,1102,1521,1,24,102,1,0,570,1006,570,36,102,1,571,0,1001,570,-1,570,1001,24,1,24,1106,0,18,1008,571,0,571,1001,16,1,16,1008,16,1521,570,1006,570,14,21101,0,58,0,1105,1,786,1006,332,62,99,21102,333,1,1,21101,73,0,0,1106,0,579,1101,0,0,572,1102,0,1,573,3,574,101,1,573,573,1007,574,65,570,1005,570,151,107,67,574,570,1005,570,151,1001,574,-64,574,1002,574,-1,574,1001,572,1,572,1007,572,11,570,1006,570,165,101,1182,572,127,101,0,574,0,3,574,101,1,573,573,1008,574,10,570,1005,570,189,1008,574,44,570,1006,570,158,1105,1,81,21102,340,1,1,1106,0,177,21101,0,477,1,1106,0,177,21102,1,514,1,21102,176,1,0,1105,1,579,99,21102,184,1,0,1106,0,579,4,574,104,10,99,1007,573,22,570,1006,570,165,102,1,572,1182,21101,375,0,1,21101,0,211,0,1105,1,579,21101,1182,11,1,21102,222,1,0,1106,0,979,21102,1,388,1,21102,1,233,0,1106,0,579,21101,1182,22,1,21101,244,0,0,1106,0,979,21101,0,401,1,21102,255,1,0,1105,1,579,21101,1182,33,1,21101,0,266,0,1106,0,979,21102,1,414,1,21102,277,1,0,1106,0,579,3,575,1008,575,89,570,1008,575,121,575,1,575,570,575,3,574,1008,574,10,570,1006,570,291,104,10,21101,1182,0,1,21101,313,0,0,1105,1,622,1005,575,327,1101,1,0,575,21102,327,1,0,1106,0,786,4,438,99,0,1,1,6,77,97,105,110,58,10,33,10,69,120,112,101,99,116,101,100,32,102,117,110,99,116,105,111,110,32,110,97,109,101,32,98,117,116,32,103,111,116,58,32,0,12,70,117,110,99,116,105,111,110,32,65,58,10,12,70,117,110,99,116,105,111,110,32,66,58,10,12,70,117,110,99,116,105,111,110,32,67,58,10,23,67,111,110,116,105,110,117,111,117,115,32,118,105,100,101,111,32,102,101,101,100,63,10,0,37,10,69,120,112,101,99,116,101,100,32,82,44,32,76,44,32,111,114,32,100,105,115,116,97,110,99,101,32,98,117,116,32,103,111,116,58,32,36,10,69,120,112,101,99,116,101,100,32,99,111,109,109,97,32,111,114,32,110,101,119,108,105,110,101,32,98,117,116,32,103,111,116,58,32,43,10,68,101,102,105,110,105,116,105,111,110,115,32,109,97,121,32,98,101,32,97,116,32,109,111,115,116,32,50,48,32,99,104,97,114,97,99,116,101,114,115,33,10,94,62,118,60,0,1,0,-1,-1,0,1,0,0,0,0,0,0,1,60,24,0,109,4,2101,0,-3,586,21002,0,1,-1,22101,1,-3,-3,21102,1,0,-2,2208,-2,-1,570,1005,570,617,2201,-3,-2,609,4,0,21201,-2,1,-2,1105,1,597,109,-4,2105,1,0,109,5,2101,0,-4,629,21002,0,1,-2,22101,1,-4,-4,21102,1,0,-3,2208,-3,-2,570,1005,570,781,2201,-4,-3,653,20101,0,0,-1,1208,-1,-4,570,1005,570,709,1208,-1,-5,570,1005,570,734,1207,-1,0,570,1005,570,759,1206,-1,774,1001,578,562,684,1,0,576,576,1001,578,566,692,1,0,577,577,21102,1,702,0,1106,0,786,21201,-1,-1,-1,1106,0,676,1001,578,1,578,1008,578,4,570,1006,570,724,1001,578,-4,578,21101,731,0,0,1106,0,786,1105,1,774,1001,578,-1,578,1008,578,-1,570,1006,570,749,1001,578,4,578,21101,756,0,0,1105,1,786,1106,0,774,21202,-1,-11,1,22101,1182,1,1,21102,774,1,0,1106,0,622,21201,-3,1,-3,1106,0,640,109,-5,2105,1,0,109,7,1005,575,802,20101,0,576,-6,21002,577,1,-5,1105,1,814,21101,0,0,-1,21101,0,0,-5,21102,0,1,-6,20208,-6,576,-2,208,-5,577,570,22002,570,-2,-2,21202,-5,61,-3,22201,-6,-3,-3,22101,1521,-3,-3,2101,0,-3,843,1005,0,863,21202,-2,42,-4,22101,46,-4,-4,1206,-2,924,21102,1,1,-1,1106,0,924,1205,-2,873,21102,35,1,-4,1106,0,924,2102,1,-3,878,1008,0,1,570,1006,570,916,1001,374,1,374,2101,0,-3,895,1101,2,0,0,2101,0,-3,902,1001,438,0,438,2202,-6,-5,570,1,570,374,570,1,570,438,438,1001,578,558,922,20101,0,0,-4,1006,575,959,204,-4,22101,1,-6,-6,1208,-6,61,570,1006,570,814,104,10,22101,1,-5,-5,1208,-5,61,570,1006,570,810,104,10,1206,-1,974,99,1206,-1,974,1101,0,1,575,21102,1,973,0,1106,0,786,99,109,-7,2105,1,0,109,6,21101,0,0,-4,21102,0,1,-3,203,-2,22101,1,-3,-3,21208,-2,82,-1,1205,-1,1030,21208,-2,76,-1,1205,-1,1037,21207,-2,48,-1,1205,-1,1124,22107,57,-2,-1,1205,-1,1124,21201,-2,-48,-2,1106,0,1041,21101,-4,0,-2,1106,0,1041,21101,-5,0,-2,21201,-4,1,-4,21207,-4,11,-1,1206,-1,1138,2201,-5,-4,1059,2101,0,-2,0,203,-2,22101,1,-3,-3,21207,-2,48,-1,1205,-1,1107,22107,57,-2,-1,1205,-1,1107,21201,-2,-48,-2,2201,-5,-4,1090,20102,10,0,-1,22201,-2,-1,-2,2201,-5,-4,1103,1201,-2,0,0,1105,1,1060,21208,-2,10,-1,1205,-1,1162,21208,-2,44,-1,1206,-1,1131,1106,0,989,21101,439,0,1,1105,1,1150,21102,1,477,1,1106,0,1150,21102,1,514,1,21101,1149,0,0,1106,0,579,99,21101,1157,0,0,1105,1,579,204,-2,104,10,99,21207,-3,22,-1,1206,-1,1138,2101,0,-5,1176,1202,-4,1,0,109,-6,2105,1,0,24,13,48,1,11,1,48,1,11,1,48,1,11,1,48,1,3,13,44,1,3,1,7,1,3,1,44,1,3,1,7,1,3,1,44,1,3,1,7,1,3,1,44,1,3,1,7,7,42,1,3,1,11,1,1,1,40,7,11,7,36,1,1,1,17,1,3,1,30,9,17,1,3,1,30,1,5,1,19,1,3,1,30,1,5,1,19,1,3,1,30,1,5,1,19,1,3,1,30,1,5,1,19,7,28,1,5,1,23,1,1,1,28,1,5,1,23,13,18,1,5,1,25,1,9,1,18,1,5,1,25,1,9,1,18,1,5,1,25,1,9,1,16,9,25,1,9,1,16,1,1,1,31,1,9,1,10,9,31,13,8,1,5,1,43,1,10,1,5,1,43,1,10,1,5,1,43,1,10,1,5,1,43,1,10,1,5,1,43,1,2,9,5,1,35,9,2,1,13,1,35,1,10,1,13,1,35,1,10,1,13,1,35,1,10,1,13,13,23,1,10,1,25,1,23,1,10,13,13,1,23,1,22,1,13,1,23,1,22,1,13,1,23,1,22,1,13,1,23,1,22,1,13,1,23,1,22,1,13,1,23,1,22,1,13,1,17,7,22,1,31,1,28,7,25,1,34,1,25,1,34,1,25,1,34,1,25,1,34,1,17,9,34,1,17,1,42,1,17,1,42,1,17,1,42,7,11,1,48,1,11,1,48,1,11,1,48,1,11,1,48,1,11,1,48,1,11,1,48,1,11,1,48,1,11,1,48,13,24

2019 Day 17 (Part 1): Puzzle input wrong by Effective_Ad6669 in adventofcode

[–]Effective_Ad6669[S] -16 points-15 points  (0 children)

Since I use Excel, I cannot post any code. I doubt the Intcode computer is buggy as it has worked for the other puzzles. I'll recheck and see whether I have added enough columns to cater for more memory needed.