How do I collate information across multiple sites

[Tanya0979]

Hi all,
A skills assessment questionnaire has been sent to staff and I now need to collate the information for each different site. I am a bit unsure the best way to set up the spreadsheet and then how to combine the information for all sites

Name
Job Title & Team

<tbody>
</tbody>

Please indicate if you undertake the following competences and your level of confidence in undertaking that competence.
* Level 1 - little or no confidence, level 2 – some, level 3 – good, level 4 – high

[TABLE="width: 616"]
<tbody>[TR]
[TD]Competency
[/TD]
[TD]Yes/
No
[/TD]
[TD]Confidence level 1-4
[/TD]
[TD]Experience (yrs months)
[/TD]
[TD]Formal training
[/TD]
[TD]Comments
[/TD]
[/TR]
[TR]
[TD]Use of risk assessment tools for pressure area care i.e. waterlow , SKINN bundle
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]Use of Nutrition and hydration tools i.e. MUST
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]Grading of pressure ulcers
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]Understanding of wound care formulary including correct Dressing choices

[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]Tissue Viability/cellulites/ulcer management.
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]Topical Negative Pressure

[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]Plural Drains

[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[/TR]
</tbody>[/TABLE]


Any help would be appreciated.