Challenge #425: Weekly Allowance Distribution

[rishi_gundla]

Spoiler

Done!!!

[PhilipMannering]

Solution attached.

Spoiler

[nSpire]

Spoiler

 

[ARussell34]

Found two ways to solve for this challenge prompt.

[Dlawless610]

Here is my solution. 

 

[BSilverblatt]

Thanks for the challenge! Here's my solution:

[ScottLewis]

Single formula solution (plus a second one to name to name the columns.) 

By using generate rows the way you would to set up the multi-row formula type solution you have all the information for a single formula solution that could be generalized across an arbitrary number of weeks and handles cases where money runs out before week 4. 

Spoiler

The key is that each weeks spending is equal to the difference maximum of 0 and the total - 150*n weeks and the same value calculated at week n-1. 

 

[tammybrown_tds]

There were several ways to solve this with one tool, but I chose for a solution that would allow for more than 4 weeks and different starting amounts.

Spoiler

[stataltgee]

My solution 😊

[Surreywolf]

My solution.