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 #284: Division with Macros

mbogusz
9 - Comet
Spoiler
Weekly Challenge #284 in the canWeekly Challenge #284 in the can
ywang7
7 - Meteor
Spoiler
ywang7_0-1632107820705.png

 

First macro workflow!

alexnajm
16 - Nebula
16 - Nebula

Shoutout to @PhilipMannering for helping me complete this challenge! Not easy for sure...

kelly_gilbert
13 - Pulsar

My solution is pretty similar to the others, except I also implemented it with the Generate Rows tool for a no-macro solution (just for fun!) Thanks for submitting the challenge, @patrick_digan!

 

Spoiler

Like many others, I implemented long division.


Outer workflow (non-macro and macro solutions):

kelly_gilbert_1-1632326102043.png 


Iterative macro:
kelly_gilbert_0-1632326051169.png 
patrick_digan
17 - Castor
17 - Castor

@kelly_gilbert Very cool generate rows solutions. Reminds me of the AdventOfCode type solutions!

kelly_gilbert
13 - Pulsar

@patrick_digan, yes, I totally learned that trick (from either you or @jdunkerley79) during Advent of Code 2019 😄

AdhirKirtikar
7 - Meteor

Hahahah... It's really not... "Hint: It's not 1,000,460,202,682,230,000 with remainder -442"

This one was the first answer that I got.... 😰

Really tough one, had to scratch the head intensely as I am not that good in macros yet. But finally got it after writing all the steps in excel 😬

Spoiler
challenge_284_AdhirKirtikar_ExcelWorking.png

 

Spoiler
challenge_284_AdhirKirtikar_MC.pngchallenge_284_AdhirKirtikar_WF.png

  

 

rmassambane
10 - Fireball

another one

ArtApa
Alteryx
Alteryx

Here is my solution:

 

Spoiler
ArtApa_0-1633396072298.png

 

ArtApa_1-1633392720676.png

 

apathetichell
18 - Pollux

I know I could follow @Maskell_Rascal 's Python tool with an R big int package but the iterative macro is kind of fun.