Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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