Unable to load image

[Join the rDrama leaderboard] Don't forget Advent Of Code! :marseychristmaself2: Santa needs YOU to save christmas:marseypresents:

https://adventofcode.com/

Advent of Code is an annual coding competition/event with daily challenges. Even complete beginners can keep up for the first few days as the difficulty slowly ramps up.:marseymarseylove:

Join the rDrama leaderboard and see how you compare to your fellow dramanauts with the following code:

632268-20c7d1d5

Enter it here https://adventofcode.com/2022/leaderboard/private

99
Jump in the discussion.

No email address required.

Christ OpenOffice fricking sucks. I want to play and this would be fricking easy even in Excel but OO is throwing me bullshit errors and I can't buy Excel because of a one-way feud with Microsoft. (the solution is way easier than what @BasicallyADoxxer is doing)

What's the basic b-word freeware that lets me enter some goddarn if statements?

Jump in the discussion.

No email address required.

I think google sheets has similar formulas and works well

Jump in the discussion.

No email address required.

>with a gmail.com address

I HATE THE ANTICHRIST

Thanks anyway. I saw your solution and I think mine might be a little more elegant (I'm very drunk so there could easily be an infinite loop I'm missing):

![](/images/16699623814697645.webp)

Jump in the discussion.

No email address required.

You can make a throwaway gmail

Also looking at your sheet, that will just keep summing up the total calories of all the elves, not the total calories of each elf

With a slight edit tho

for B cells: =if(A9>0,B8+A9,"") for C cells: =if(B9="",B8,"")

it should work, and I agree it is much simpler than my solution just requires an extra column

Jump in the discussion.

No email address required.



Now playing: Blurry Flurry (Tropical Freeze).mp3

Link copied to clipboard
Action successful!
Error, please refresh the page and try again.