Looking for a way to keep track of how much time 3 units are running during a shift. This workbook allows the user to log samples in(i.e. start a unit) and then log samples out(i.e. remove them from the list of samples running on a unit). It also does many other tasks however those are all working correctly. This is the final piece of this very involved puzzle for me.
Here is what is supposed to happen:
1st- There is a code written in the Nucomat_Dashboard sheet which watches the value of cell “N4” and sets the start times of the units if they have samples loaded on them.(i.e. if “N4” = “Dayshift” and “N13” is >0 then the start time recorded in “AA2” should be 05:00.)
2nd- There is a macro(LookatU5) which should look at the value of “N13” anytime samples are loaded and determine: If the unit was already running, then don’t do anything. If the unit was empty(i.e “N13” = 0, then insert the current time in cell “AA2” or the next empty cell in that range. Each of the 3 units has its own macro.
3rd- There is a macro(Stopwatch_Units) which should look at the value of “N13” AFTER samples are scanned out(i.e removed from the units) and if “AA2>0” AND “N13=0” then insert the current time in the 1st empty cell in the appropriate named range(i.e. Named Range: U5Stop=”AB2:AB9”)
4th-There is a macro(End_Runs) which should look at the value of “N13” and if the value is NOT 0 it should insert either “05:00” or”17:00” in the 1st empty cell in the named range(i.e U5Stop) which indicates that the unit is still running at the end of the shift.
I am not sure that this is the best approach to take to accomplish this task. I am getting various error messages with each of the above mentioned codes. If you are interested in testing it for yourself, sample id’s can be copied from the “Received” tab using Column A data, and pasted into the log in or log out areas to simulate us actually using the workbook. From there you should be able to reproduce the issues I am having. The password is “Nuco123”. I GREATLY appreciate any help or words of wisdom on this. I am new to this and have learned a great deal from forums like this as you can see from this project. I am excited to keep learning and growing my skills! Thanks again
Here is what is supposed to happen:
1st- There is a code written in the Nucomat_Dashboard sheet which watches the value of cell “N4” and sets the start times of the units if they have samples loaded on them.(i.e. if “N4” = “Dayshift” and “N13” is >0 then the start time recorded in “AA2” should be 05:00.)
2nd- There is a macro(LookatU5) which should look at the value of “N13” anytime samples are loaded and determine: If the unit was already running, then don’t do anything. If the unit was empty(i.e “N13” = 0, then insert the current time in cell “AA2” or the next empty cell in that range. Each of the 3 units has its own macro.
3rd- There is a macro(Stopwatch_Units) which should look at the value of “N13” AFTER samples are scanned out(i.e removed from the units) and if “AA2>0” AND “N13=0” then insert the current time in the 1st empty cell in the appropriate named range(i.e. Named Range: U5Stop=”AB2:AB9”)
4th-There is a macro(End_Runs) which should look at the value of “N13” and if the value is NOT 0 it should insert either “05:00” or”17:00” in the 1st empty cell in the named range(i.e U5Stop) which indicates that the unit is still running at the end of the shift.
I am not sure that this is the best approach to take to accomplish this task. I am getting various error messages with each of the above mentioned codes. If you are interested in testing it for yourself, sample id’s can be copied from the “Received” tab using Column A data, and pasted into the log in or log out areas to simulate us actually using the workbook. From there you should be able to reproduce the issues I am having. The password is “Nuco123”. I GREATLY appreciate any help or words of wisdom on this. I am new to this and have learned a great deal from forums like this as you can see from this project. I am excited to keep learning and growing my skills! Thanks again
