Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!
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....
