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

Yoshiro_Fujimori
15 - Aurora

My solution.

Spoiler
Main Flow
  Yoshiro_Fujimori_0-1680999135989.png

Divide Macro

  Yoshiro_Fujimori_1-1680999276485.png


Calculate Quotient & Remainder
  Temp_Dividend = ToNumber( [Remainder] + Substring([Dividend],[Engine.IterationNumber],1) )

  Temp_Quotient = ToNumber(FLOOR([Temp_Dividend] / [Divisor]))
  Quotient = [Quotient] + ToString([Temp_Quotient])
  Remainder = [Temp_Dividend] - [Divisor] * ToNumber([Temp_Quotient])

Christina_H
14 - Magnetar

Wow, this one took some effort!  Good challenge.

ed_hayter
12 - Quasar
Spoiler
Well this challenge had me well and truly stumped. To be frank I still am, i had used the python tool the other week and with the help of chatgpt for some troubleshooting hoped that Python could handle bigger integers. It seemed to work

Challenge 284 WF Image.png
JennyMartin
9 - Comet
Spoiler
AWC284M.png

Going back to the days of long division with this challenge! Find video solution here: https://youtu.be/26AuFGDo5-Y

gawa
16 - Nebula
16 - Nebula

Used some trick to make it easy but it's not generic solution

alacoume
9 - Comet

I have done it with R!

jerviss53
8 - Asteroid

Macro Attached

networkmike42
8 - Asteroid

Workflow (pretty simple)

Spoiler
Workflow.png

 Macro

Spoiler
Macro.png

JosephSerpis
17 - Castor
17 - Castor

Challenge Completed

 

Spoiler
Weekly_Challenge_284JPG.JPG
olga_strubbe
11 - Bolide

This was a neat challenge.  Thank you, @AYXAcademy!  It gave me a chance to practice iterative macros.  

I leveraged the approach provided in using a supplementary text input to solve this challenge.  See my solution attached. 

 

My workflow:

flow.png

Macro:

2024-02-23_09-56-56.png