Challenge #425: Weekly Allowance Distribution
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello Maveryx,
After a two-week hiatus from our weekly challenges, while we all attended Inspire, we're back to our regular routine! I hope you enjoyed your break!
A solution to last week’s challenge can be found here.
This challenge was created by @Qiu and inspired by a question posted in our Community. Qiu, your contributions are priceless, and we cannot thank you enough!
The dataset contains a single column with the total monthly allowance for each person in a group of five teenagers. In an effort to budget their money, they want to determine how much, if anything, they would have left over if they budgeted $150 of spending each week for the first four weeks of the month.
Your task is to allocate the money by dividing each teenager’s total amount over five columns representing each week of the month plus a carryover week (Week 1, Week 2, Week 3, Week 4, Carry_Forward), considering their weekly spending limit [$150]). Any remaining funds after the first four weeks should be rolled over into the Carry Forward column.
Need a refresher? Review these lessons in Academy to gear up:
Good luck!
- Labels:
- Advanced
- Data Preparation
- Difficult
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
My solution.
1,000 - 150 * 4 = 400
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
C425. Slightly different answer than provided.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Here's my solution!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Unfortunately don't see a reason why this needs to be dynamic
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator