General Discussion Forum

Back to General Discussion Forum

Advent Of Code 2022 Pinned Upload Images Link
Alex Hedley
3 months ago

Anyone planning on doing AoC this year?

Alex Hedley
3 months ago

Could be a new video type like TechHelp or FastTip

Alex Hedley
2 months ago

Day1 was fun, anyone else completed it?

Adam Schwanz
2 months ago

Yep just finished it with VBA. Not sure if I cheated though, I pasted the value list into a table, maybe I was supposed to import that part with code.

Adam Schwanz
2 months ago

What language did you use Alex?

Alex Hedley
2 months ago

Oh fab, I think that's fair, that's just the util stuff.

Prob would be worth having a procedure to import data from a text file as each day you get a different input and you can test on the sample one then the actual.

You got it up on GitHub?

I picked C# again.

Adam Schwanz
2 months ago

Nope, I'll make a GitHub tonight for this and see how many I do lol

Alex Hedley
2 months ago

I'd love to see it,
Also don't forget to use VCS so I can easily see the code.

Adam Schwanz
2 months ago

I don't know what I'm doing but I think I shared it LOL.

SPOILER ALERT, vba solutions HERE

Adam Schwanz
2 months ago

I'll need to go back and look at the videos I think you made about GitHub for how I'm supposed to do it LOL.

Alex Hedley
2 months ago

Do you have the plug-in in Access?

Adam Schwanz
2 months ago

Probably not, havent really ever used GitHub.

Alex Hedley
2 months ago

No, the VCS access add-in.

See videos.

Adam Schwanz
2 months ago

I'll check them out tonight and fix it. Thanks

Adam Schwanz
2 months ago

I haven't watched yet, but I found out how to clean it up a little bit I think, uploaded vba Day 2 part1/2. Really easy day, I even coded more than I had to I think. See how many days VBA can last.

Adam Schwanz
2 months ago

Kevin Scott either of you doing it?

Kevin Robertson
2 months ago

No, at least not at the moment.

Alex Hedley
2 months ago

🤘📰✂️

Scott Axton
2 months ago

Not me. In case you haven't noticed I've been MIA quite a bit lately.
Slammed at work. The Monday, Tuesday and Wednesday of last week we logged almost 500 phone calls. Our busy time of the year!
Life is good though - just busy.

Adam Schwanz
2 months ago

Alex did you do day3?
I have a lot of lines that have no matching characters if split in the middle

One of my lines is
LTmnZTgMmbWWGWZQZb
There is no matching letters on the left 9 to the right 9

Am I missing something?

Adam Schwanz
2 months ago

I don't want to talk about it LOL. There is a Z. I'm just blind

Alex Hedley
2 months ago

Did you brute force it?

Adam Schwanz
2 months ago

Yea, I was actually having some trouble with this one getting it to match characters correctly, it was picking and choosing where it wanted to match. I had about a page worth of code trying to get super technical with it, then dumbed it down to the most basic possible and it worked lol. Swear that didn't work the first time ;). Uploaded D3P1 working on P2 now.

Alex Hedley
2 months ago

🧝 Day 4 was fun, and Part 2 was a quick addition.

Adam Schwanz
2 months ago

I think this is it for VBA boys LOL.

Adam Schwanz
2 months ago

Alex any ideas?

Alex Hedley
2 months ago

Did you try a Stack to push and pop from?



Dim stack as Object

Set stack = CreateObject("System.Collections.Stack") 'Create Stack

 

stack.Push "Hello"

stack.Push "There"

stack.Push "Mr"

stack.Push "Smith"

 

peekAtTopOfStack = stack.Peek()

doesContain = stack.Contains("htrh") 'Result: False

doesContain = stack.Contains("Hello") 'Result: True

    

'Get item from the top of the stack (LIFO)

topStack = stack.Pop()  'Result: "Smith"

 

'Clear the Stack

stack.Clear

 

Set stack = Nothing

Adam Schwanz
2 months ago

No I did not, I didn't know there was a stack object. I was trying to brute force code it with pages of code lol. I'll try something like that. Thanks

Alex Hedley
2 months ago

Break it down into simple problems first.
How to I add items to a stack, how do I move from one to another.
Work on parsing the commands, how would you then call that against your collection object.

Alex Hedley
2 months ago

Day 6 - 🧝☎️

Adam Schwanz
2 months ago

Yea did day 6.

Part 2 i did with reallly ugly code though lol.

Coming back to day 5 when I have some free time.

Alex Hedley
2 months ago

Day 6 - Part 2 was one input change for me, which was lucky, or well thought ahead, who knows.

Alex Hedley
2 months ago

Day 7 - Fun stackoverflow

Alex Hedley
2 months ago

Day 8 - 🌲

Alex Hedley
2 months ago

Day 9 - 🌉

Adam Schwanz
2 months ago

I'm falling behind getting busy at work lol. I'm almost done with day 7, day 8 looks interesting, still need to go back to that stack too lol.

This thread is now closed. If you wish to comment, start a NEW discussion, below.

Back to General Discussion Forum Comments

Subscribe to General Discussion Forum
Get notifications when this page is updated