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....