Looking at the screenshot can you create code that would adjust the 1. stop time when the run time and or soak time is changed. 2. Continue the process thru the table. The start time for “A” is 4:00 AM. The start for the next zone in each “Days Group” is determinedon the previous soak time of the zone that is running This is created in Numbers 15.2.1
[Edited by Moderator]
MacBook Air 13″, macOS 26.5
This is easy to do - as long as your data is setup correctly.
The short answer is that the formula for cell H12 should be simply:
=G2+E2+F2
in other words, the start time, plus the run time, plus the soak time.
From here, it's easy to link the next start time to the previous zone's end time.
This will work automatically, AS LONG as the values in columns E and F (Run Time and Soak Time) are set as Duration fields.
If they are, and Numbers knows they represent minutes, it will happily add them to a date/time value.
In my recreation of your table, I have set columns E and F as Duration (Inspector -> Format -> Cell -> Data Format)
and you can see the formula in H2 references these cells with a simple addition.
This is easy to do - as long as your data is setup correctly.
The short answer is that the formula for cell H12 should be simply:
=G2+E2+F2
in other words, the start time, plus the run time, plus the soak time.
From here, it's easy to link the next start time to the previous zone's end time.
This will work automatically, AS LONG as the values in columns E and F (Run Time and Soak Time) are set as Duration fields.
If they are, and Numbers knows they represent minutes, it will happily add them to a date/time value.
In my recreation of your table, I have set columns E and F as Duration (Inspector -> Format -> Cell -> Data Format)
and you can see the formula in H2 references these cells with a simple addition.
> If you can follow the run number in Col "I" you can see that the next zone to run has either started right after one has stopped or is waiting for the soak period is done.
That's a whole different level of complexity that was not apparent from your original post.
What is sounds like you want is the Start time of any given zone to equal the Start time of the previous 'Run' + that zone's Run Time.
I'm having trouble, though, working out the exact flow you're aiming for (no pun intended).
Can you elaborate the actual logic you want to apply... I think it's something like
For any given 'zone' check it's 'Run' order - e.g. 'Zone B = 4'
Find the zone that has the preceding Run value for the same Days - e.g. which Zone has the same 'Mon & Thu" schedule with the Run value of 3 => Zone E
Take that schedule (Zone E)'s Start time and add it's Run time and Soak time to determine this zone's Start time.
Is that about right? I want to make sure I understand your flow before I go too far down the wrong path :)
Thanks, I knew how to do what you did.
What I am looking for is code to automatically change the entire table if I were to alter either the run or soak times. The second cycle for each zone can not run until the soak time for the particular zone has completed but another zone could start up. If you can follow the run number in Col "I" you can see that the next zone to run has either started right after one has stopped or is waiting for the soak period is done. Try to follow the sequence by the run number in conjunction with the start and stop times associated.
Numbers: Auto-adjust sequential stop times with run/soak
