This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Hi,
I am looking to redesign our tracker sheet (it's included inside the cabinet for people to fill out), for any spare PPE/uniform that is kept it our cupboard.
This is purely to issue out any any spares, people take what they need and record on the sheet what they have taken and sign/initial it, we don't need anything complicated just something that is better than the below, otherwise people won't bother filling it in!
| Order Code | Item Name | PPE/Corp | Qty Available In Cabinet | Size Taken Out (People Fill this in) | Initial's<br><br>(People Fill this in) | Date<br><br>(People Fill this in) |
|---|---|---|---|---|---|---|
| 12345 | T shirt | Corp | 2 | 18, Medium | Mr X | 01/07/24 |
| 56789 | Combat Trousers | PPE | 4 | 10, 14, M, L | Miss Y | 09/07/24 |
| 34567 | Helmet | PPE | 5 | - | Mrs XY | 14/08/24 |
Can anyone come with something that is more suited to what we need.
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
It's ok i've managed to come up with something that has separate sections on the same page for the excisting spares stock list count and recording what has been taken.
Let me put it another way: imagine you had to take a tool in our company.
Would you be able to fill out a form like yours? I tell you clearly: you are not.
If I were in your company and take a T-shirt from the cabinet, I would expect a form that asks me:
What did you take?
How many did you take?
Who are you?
And maybe when did you take it?
I don't know anything else beyond that. Therefore, this information is reasonable and IMHO completely sufficient.
Andreas.
The order code is not what they write in that is already on the sheet, we just want a record of everything that has been taken out of the cupboard. We need to account for everything. I should have made clear, that the final 3 columns is what people actually write on the sheet.
We have something very similar in our company for cutting tools. If I compare it with your form, IMHO you ask for far too much information.
You already know exactly what was taken out via the "Order Code", so "Item Name" and "Size Taken Out" are superfluous.
If "Initial's" makes it clear who took it out, why then do we need PPE/Corp? It would only make sense if that the user takes something out for someone else; I assume that the user belongs to PPE or Corp...
"Qty Available In Cabinet" is wrong, nobody wants to count the current inventory, change it to "Qty taken".
You can then make the appropriate deductions in your inventory system and then know how much inventory is still in stock.
The date is also questionable, what is the use of this information? Who cares if I took a T-shirt out on Aug 15 or Sep 20... gone is gone.
So all that remains is "Order Code", "User Name" and "Qty taken", nothing more is needed.
Andreas.
This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
Comments have been turned off. Learn more