Start Free Trial

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 #486: Prepare for Your Assignment Reviews!

mmontgomery
11 - Bolide
11 - Bolide

c486

Spoiler
c486.png
DaisukeTsuchiya
14 - Magnetar
14 - Magnetar

I couldn't get the same answer.

Spoiler
スクリーンショット 2025-08-16 103953.png

 

JulianHalseyMilhaupt
6 - Meteoroid

I assumed the student could not have a prep day on a review day and that they could not prep for two reviews in the same day.

 

Spoiler
JulianHalseyMilhaupt_0-1755316681372.png

 

clewis28
6 - Meteoroid
Spoiler
clewis28_0-1755447617102.png

 

Spoiler
clewis28_1-1755447648695.png

 

Spoiler
clewis28_2-1755447683329.png

 

Reesetrain2
9 - Comet
9 - Comet

All,

 

My solution!

Spoiler
Screenshot 2025-08-18 102610.png

barrymoe
8 - Asteroid

almost impossible!

wbasuki
8 - Asteroid

I see that there are some 'non working day' under preparation day in the output table, therefore I change my goal to match with the output table and not consider 'non working day' in the workflow, and here it is.

Spoiler
Screenshot 2025-08-20 101216.png
RebekaMazuchova
8 - Asteroid

I wouldn't consider this one Basic/Core, as I believe it requires the use of an iterative macro. 

Btw, we should have started the preparations in March 2024.

Yanxuliu
7 - Meteor

Challenge #486: Prepare for Your Assignment Reviews!

jtmoll
6 - Meteoroid

A lot more difficult than I thought factoring in no duplicate Prep Dates

 

Spoiler
jtmoll_0-1755708938355.pngjtmoll_1-1755708982888.png