Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEA
Ooh child, that was a bumpy ride!
I've webscraped the post to look for any messages with spoilers or attachments and added additional constraint that allowed for only one solution per user.
Then, I've had some issues with getting the gifts list optimised and kept getting errors or some bizarre results! Finally, made it though. The workflow ain't pretty but I'm also tired so happy to be done with this one haha
My solution for challenge #146. I went down the web scraping route and I found that the # of posts was around 44 on the 21st December 2018, so that made up a donation of £880.
To select the items, I was intrigued to use the optimization tool but I couldn't configure it properly :/. I will give it another shot once I have more time to revise the relevant article in the community.
Challenge 146 is done! Decided to go down the optimization route (loving the optimization tool!). @AngelosPachis this might be of interest to you (i know you wanted to get it working)
Workflow:
Batch optimization process:
Really fun challenge, though I feel I could have made it a bit more dynamic in places!
My solution.
I scraped the Challenge#146 top page and get pages number.
After that,I scraped the all pages. And I got the Date and Use Name of each post, too.
After that, I got the quantity of yxmd/yxzp file except JoeM's solution between 12/17-12/21.
I used Optimization tool to fit my budget $840.
If the minimum quantity is 1, it won't be able to meet the 840$.
So I set the minimum qty is 2 and maximize qty is 20.
The remainder was 0.03$.
My shopping List.
scraping block
StoreData Prep and Optimization block
Challenging, but fun. I went ahead and added macro counts to my solution, in the interest of generosity. I'm sure my method would have worked better as an iterative macro, but my brute force method left me with 17 items on the list and 21 cents leftover. It should still come close if the number of submissions changes. I wish I could intuit the optimization tool a bit better, but I'm still struggling with it, hence my brute force option. Regardless, solution attached.
Here is my submission, 85 solutions were submitted, so my solution is based on the amount of $1700.