I created a production tracking worksheet (see attachment), that breaks down everything that we want. But we need something visually that shows how far along they are while working. On their desk they have a Standard Production Job Aid (see 2nd tab) that's laminated so they can use it multiple times. They cross off the amount of claims they have worked (stick = 30 min). It's a tall order but if anyone has any suggestions on how to make the second tab reflective of the work in the first tab, it would make a lot of people happy. The first tab is broken up into formulas (shaded part they do not touch) and entry cells (clear cells they enter their production count and hours worked). I have been messing around with a chart but not sure if that's the best way. If it could some how shad or change the color of the stick part to the amount of claims worked that would be ideal. Any suggestions will be helpful.
Thanks again,
Seahawk56
P.S. I just found out you can not attach a workbook and I can't figure out the htmlMaker form Colo. If you are interested in trying to answer this, please reply with an e-mail address and I will e-mail it to you. Or if someone knows a better way let me know. Thanks again!
Thanks again,
Seahawk56
P.S. I just found out you can not attach a workbook and I can't figure out the htmlMaker form Colo. If you are interested in trying to answer this, please reply with an e-mail address and I will e-mail it to you. Or if someone knows a better way let me know. Thanks again!
