Forum Discussion
Calculated planting week
Hi all, I grow plants for a living and have a spreadsheet with different plants in the rows, columns represent week 1 to 52 and each plant has quantities entered when we want to have them ready. ...
Updates made. New workbook attached.
Lambda - 'Summarize'
=LAMBDA(a,v,LET(
sched, XLOOKUP(v, ProductFC & " - " & VarietyFC, SalesFC),
Required, TOCOL(FILTER(sched, sched <> 0)),
c, FILTER(COLUMN(sched), sched <> 0) - 3,
ctimes, CHOOSECOLS(XLOOKUP(v, ProductCT & " - " & VarietyCT, CropTime), c),
PlantWk, TOCOL(c - ctimes),
r, ROWS(Required),
VSTACK(a, HSTACK(EXPAND(v, r, , v), PlantWk, Required))
))
=REDUCE(Header,ProductFC&" - "&VarietyFC,Summarize)
Thank you for your reply.
This goes beyond what I fully understand but with the very helpful excel example you gave I can learn a lot.
I need a solution that allows for changing crop growing times throughout the year though which makes it a lot more complicated again.
To clarify I have attached the data with quantity for each plant and when they should be ready and then the time it takes to get them ready. The combination of these two sets of data should allow for us to create a planting schedule.
- Thank you for the file. I've updated my previous post with a new workbook. Let me know what you think about the results sheet. The 'Summarize' function I built is at a point where it can be adjusted as needed to change the display.
