Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #304: International Bank of Awesome Data - Part III

Brian32
8 - Asteroid

Challenge Solution:

Spoiler
Brian32_0-1660765606795.png

 

SkomantasTamulaitis
8 - Asteroid

This one was pretty tough, had to peek into the solution.

Spoiler
Macro.png




Workflow.png

ggruccio
ACE Emeritus
ACE Emeritus

For some reason I had different debit and credit amounts, but still arrived at the correct totals.

 

Spoiler
ggruccio_0-1661373173949.png

 

Abiramm1
8 - Asteroid

Bit crammed but we got there in the end :)

Spoiler
Abiramm1_0-1662028412291.png

 

JamesCharnley
13 - Pulsar
Spoiler
JamesCharnley_0-1662824423323.pngJamesCharnley_0-1662824668482.png

 

 

This actually ended up being one of the challenges I've struggled the most with trying to deal with that daily avg. Think I got there in the end after admittedly checking a couple of screenshots in the comments, bit hard to tell though with the output differences as others have mentioned!

FrederikE
13 - Pulsar
Spoiler
FrederikE_0-1664611905796.png

 

Sashikumar
8 - Asteroid

Learned

ZacharyRyanTIL
8 - Asteroid

nice

gerda
8 - Asteroid
Spoiler
challenge 304 p2.png
Spoiler
challenge 304 p1.png


Here's the solution, it was quite hard!

OzlemSigbeku
8 - Asteroid

Well, numbers don't match and I still don't know what the Average Opening Balance is being calculated on, but I got the batch working and the outputs outputting. 

Spoiler
OzlemSigbeku_0-1668554258607.png
OzlemSigbeku_1-1668554834260.png