Uniform issue

[Atkin604]

Hi All I do volunteer work for a bloodrun charity and have just been asked to look after all the uniform issue stock etc. as before the were not kept track off is there a uniform spread sheet as when I've searched the internet I cannot find one

[AliGW]

Welcome to the forum!

What would a 'uniform spreadsheet' need to do? You are not going to find one online because you are not asking the right questions in your search terms.

I suggest you search for a stock inventory template and then adapt it to suit your requirements, or possibly a hire company template. Have you looked at the templates that come with Excel? There are three inventory templates with Office 365, for example.

In your user profile, you are asked to tell us the version of Office you are using - you have said Windows 10, which is the operating system, NOT your Office version. Which version of Excel are you running? Please change your profile to reflect this.

[FDibbins]

Agree we need more info/detail. When I 1st read this, my thoughts were about clothing, but perhaps you mean something else?

[AliGW]

I think it is clothing, but the requirement is not specific to clothing: it's to do with issuing out and keeping track of uniform stock, so that's why I suggested stock control (i.e. inventory) templates.

[Atkin604]

Hi All the uniform is the clothing issued to volunteers as there is quiet an expense to the charity and it has never been tracked before or the ordering of uniform has not been tracked. I am using office 365

[FDibbins]

Can you provide us with a dummy file showing the kind of info you have, and what you expect the outcome to look like?

[AliGW]

Then look at the three templates I mentioned. Open Excel - New - look at the templates bottom right concerning inventories.

We can help you to adapt if you find one that's close. Googling may turn up others if you use the right search terms. If nothing else, they may inspire you to know what you want the spreadsheet to do and how it should look, which is your starting point.

[TMS]

Depends on how sophisticated it needs to be. I would think a simple Structured Table would be adequate. Maybe record the employee (perhaps from a drop down list), the date issued, the size, and the reason for issuing a uniform. That could be, for example: new volunteer, damaged, too small, too large, change of role ... probably selected from a drop down box.

You could then create a Pivot Table to analyse the records and, if necessary use the sort and filter functionality to check the details.