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
HeLa Cool!
My solution wasn't though. Quite clunky but I got there
Spoiler
Process
- Change data type of HeLa Cell Count to Int32
- Generate a bunch of rows (I chose 50 for some flexibility - though I knew I only needed 14 splits)
- Calculate Max Cells (30 * 400,000)
- Calculate date/time for each cell split
- Calculate number of cells after each split
- Calculate start date/time for each cell split
- Set flag for when number of cells exceeds the max cell count
- Filter out those iterations where cell count is less than max cell count
- Choose first instance where cell count exceeds max cell count
If I shifted some of these tools around I could reduce a couple of steps and/or number of tools....
- Change data type of HeLa Cell Count to Int32
- Generate a bunch of rows (I chose 50 for some flexibility - though I knew I only needed 14 splits)
- Calculate Max Cells (30 * 400,000)
- Calculate date/time for each cell split
- Calculate number of cells after each split
- Calculate start date/time for each cell split
- Set flag for when number of cells exceeds the max cell count
- Filter out those iterations where cell count is less than max cell count
- Choose first instance where cell count exceeds max cell count
If I shifted some of these tools around I could reduce a couple of steps and/or number of tools....
