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 #191: BINGO!

DaisukeTsuchiya
パルサー
スポイラ
キャプチャ.JPGキャプチャ2.JPG

  

apathetichell
アルタイル

2021-05-30.png

So it's an app. two batch macros, and an iterative macro. I realized I should used a random sample tool instead of the iterative macro but at the time that seemed like the easiest solution to the "how do I choose a random item and prevent that item from begin chosen a second time" problem... So app takes in the number of cards wanted. Control/Batch deals with layout and calls the batch for the different card type. Second batch controls the iterative part - which is basically just a random % sample tool but oh so much more fun...

DataHabanero
コメット

Ready, awesome and fun challenge!

sarahkelly
アステロイド

Landed somewhere between Intermediate and Advanced on this one.

EW
ボリード

This challenge was so much fun!  Reminds me of one of the first Excel macros I ever wrote, to generate random BINGO cards based on stuff a certain friend always said!  

 

スポイラ
I should say the first half of the challenge was fun!  The second half was table border and layout hell for me.  I need to learn the Reporting tools better to do these in a decent amount of time.  😬  191_EW.PNG
AndrewSu
Alteryx
Alteryx

my take 🙂

Qiu
21 - Polaris
21 - Polaris
スポイラ
challenge_191.PNG
Watermark
12 - Quasar
12 - Quasar
スポイラ
MT Solution 191.png

Original_Yodies
アステロイド

completed as Beginner, to continue Intermediate with iterative macro soon.

スポイラ
Original_Yodies_0-1648055115997.png

 

leozhang2work
コメット
スポイラ
191 - 1.png191 - 2.png191 - 3.png

Did Intermediate, tried Advanced, the format is just too hard 😂