I am trying to recreate an excel process in Grasshopper using a script. I was initially looking at foreach loops in a C# component but am struggling. To be honest i don’t mind which language its in, so long as it works!
Below is an image of the excel sheet.
The process outputs the data in column C based on all other data which is predefined (ideally as lists/numerical inputs into a Grasshopper component). The formula in C5 is a unique initialisation =A5-B5-B1 then all subsequent items on the list follow the pattern as per C6 which is =IF(C5+A6-B6-$B$1>$B$2,$B$2,C5+A6-B6-$B$1).
Any assistance greatly appreciated