Challenge #108: HeLa Cell Multiplication

[danilang]

Basic core Alteryx solution.  No Macros.  No highfalutin math.  Logs are for building homes with ;)

Slight difference with other core solutions having to do with the number of rows generated and how the start and end dates are calculated

Spoiler

Dan

P.S. Never had to actually spell "Highfalutin".  Seems like there aren't enough "o"s in it

[Ruud]

My solution. I fell for the good ol' int-trap.

Spoiler

Macro:


Workflow:

[DavidP]

Fun challenge!

I think a great new tool would be a cross between the Generate Rows Tool and the Multi-Row formula Tool, where you can update the value of multiple fields with formulas each time it cycles through the loop and even refer to previous rows. I guess that's what Macros are for...

[JoBen]

Cheers!

[pasccout]

Here is my solution

[NilsM]

Spoiler

My solution.

[jssandom]

My solution using Generate Rows

[kelly_gilbert]

Spoiler

I guess the easiest solution is to calculate the result mathematically, but I also took this as an opportunity to practice creating iterative macros!

Main workflow:


Iterative macro:

[olivia_paquot]

I was afraid of the macro iterative - I came out without :-)

[RolandSchubert]

My solution - without macros