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

gawa
15 - Aurora
15 - Aurora

Done

DaisukeTsuchiya
13 - Pulsar
Spoiler
スクリーンショット 2023-09-22 092024.jpg

mithily
8 - Asteroid
Spoiler
a nice batch macro
danielprince
7 - Meteor

Solved

sknman92
8 - Asteroid

my solution. couldn't get the avg daily figures to match up perfectly though

asultanov
8 - Asteroid
Spoiler
Screenshot 2024-02-20 145529.pngScreenshot 2024-02-20 145546.png
olga_strubbe
10 - Fireball

Thank you, @NicoleJohnson!  This was a great practice for batch macro for me. 

I followed a similar approach for batch macro as in the solution provided - this seemed to be a straightforward approach to me. 

 

Workflow: 

wf.png

 

Batch macro: 

2024-02-28_18-01-29.png

 

olga_strubbe
10 - Fireball

I forgot to attach my macro, so sorry.  Here it is i addition to my earlier submission:

Please note due to securing setting when uploading data from my work PC, I just used 'Placeholder' text in macro input - you can update that to the data set fields  - just fyi :)  Thanks,

 

AGilbert
8 - Asteroid

macros inside of other macros make me feel like... 

 

 

Spoiler

AGilbert_0-1712292439793.gif

 

AGilbert_1-1712292492237.gif