Evidence Library Template

The reusable evidence system that cuts tender time by 40-60%

Every tender asks for the same evidence: case studies, KPIs, policies, testimonials. Yet most providers start from scratch every time.

The cost: 80-120 hours per tender. Evidence rediscovered, rewritten, refound. Inconsistent quality. Valuable proof buried or forgotten.

The solution: Build an evidence library once. Reuse and refine it on every tender.

This template gives you a complete, organised structure for rapid tender response.

---

What you get

Excel Template with 5 pre-built collections:

1. Case Studies Collection — Structured templates for 10+ case studies
2. KPIs and Metrics Collection — Monthly tracking dashboards
3. Policies and Procedures Collection — Document register
4. Testimonials Collection — Quote database with permissions
5. Staff and Team Collection — Capability evidence

Plus:

• Setup guide (30 minutes to implement)
• Example entries for each collection
• Search/filter instructions
• Maintenance schedule
• Tender extraction workflow

---

Collection 1: Case Studies

Why case studies win tenders

Evaluators want proof, not promises. One specific case study with real outcomes beats ten pages of generic claims.

Template structure

For each case study, capture:

CASE STUDY ID: CS-[TYPE]-[YEAR]-[NUMBER]
Example: CS-SL-2025-001

SERVICE TYPE: [Supported Living/Domiciliary Care/etc.]
COHORT: [Learning Disability/Autism/Mental Health/etc.]
LOCATION: [Geography]
DATE: [When delivered]
CONTRACT VALUE: [If relevant]

CHALLENGE:
• What was the situation at start?
• What difficulties or risks existed?
• What did the commissioner need?

INTERVENTION:
• What did you do?
• What approach did you take?
• What resources/staffing?
• How long did it take?

OUTCOMES:
• Specific results achieved
• Numbers, percentages, dates
• Before/after comparison
• Goal attainment

EVIDENCE:
• How outcomes were measured
• Who verified results
• Documentation available

QUOTE:
• Service user/family/commissioner testimonial
• Permission status: [Full/Anonymous/Internal]
• Source details

TENDER RELEVANCE:
• Which questions this supports
• Keywords for search
• Related case studies

Example entry

ID: CS-SL-2025-001
SERVICE: Supported Living
COHORT: Learning Disability + Autism
LOCATION: Manchester
DATE: Jan 2023 - Present
VALUE: £450K/year

CHALLENGE:
Client was in residential care, wanted to move to
independent living but needed 24/7 support initially.
Commissioner wanted proof of progression capability.

INTERVENTION:
Assigned key worker + consistent team of 3.
Person-centred planning with monthly reviews.
Skills development programme: cooking, budgeting,
travel training. Community integration activities.

OUTCOMES:
• Support hours: 24/7 → 8hrs/day (67% reduction)
• Independent cooking: 0/5 → 4/5 meals
• Bus travel: None → Independent with phone backup
• Volunteering: 0 → 2 mornings/week
• Outcome goal attainment: 85%

EVIDENCE:
Measured via monthly GAS assessments. Verified
by social worker and family. CQC inspection noted
progression as strength.

QUOTE:
"The consistency of staff and their focus on my
goals has changed my life. I never thought I'd
be this independent." — Service user K, 2025
[Permission: Full, signed consent form on file]

RELEVANCE:
• Person-centred outcomes questions
• Independence progression evidence
• Workforce consistency proof
• Safeguarding with least restriction

KEYWORDS: progression, independence, learning disability,
autism, outcomes, person-centred

---

Collection 2: KPIs and Metrics

Why KPIs matter

Numbers back your claims. “87% retention” beats “excellent retention” every time.

Template structure

Dashboard format with monthly tracking:

CATEGORY: [Workforce/Outcomes/Quality/Operations/Finance]
METRIC NAME: [Clear label]
CURRENT VALUE: [Number with date]
PREVIOUS VALUE: [Last month/quarter]
TREND: [↑ Improving / → Stable / ↓ Declining]
TARGET: [Your goal]
BENCHMARK: [Sector average]
FREQUENCY: [How often updated]
SOURCE: [How calculated]

SPARKLINE: [Mini chart of trend]
STATUS: [🟢 On target / 🟠 Watch / 🔴 Action needed]

Essential KPIs to track

WORKFORCE:

• Staff retention (12-month rolling %)
• Average tenure (years)
• Time-to-hire (days)
• Training completion (%)
• Sickness absence (%)
• Agency usage (%)

OUTCOMES:

• Service users achieving goals (%)
• Independence markers improved (%)
• Community participation (activities/week)
• Hospital admissions (reduction)
• Goal Attainment Scaling (average score)

QUALITY:

• Complaints (number/month)
• Compliments (number/month)
• Safeguarding alerts (number/outcomes)
• Incidents (number/severity)
• CQC domain scores

OPERATIONS:

• Punctuality (% on-time)
• Visit completion (%)
• Continuity (% regular carer)
• Response times (minutes)

Example dashboard row

CATEGORY: Workforce
METRIC: Staff Retention (12-month rolling)
CURRENT: 87% (Jan 2026)
PREVIOUS: 86% (Dec 2025)
TREND: ↑ Improving
TARGET: 85%
BENCHMARK: 68% (sector average)
FREQUENCY: Monthly
SOURCE: HR system leaver/joiner data
SPARKLINE: [███████████░░░ 87%]
STATUS: 🟢 On target

---

Collection 3: Policies and Procedures

Why policy evidence is critical

Tenders require proof of systems and safeguards. Current, reviewed policies show a genuine compliance culture.

Template structure

POLICY NAME: [Clear title]
VERSION: [Number]
LAST REVIEWED: [Date]
NEXT REVIEW: [Date]
REVIEWER: [Who approved]
STATUS: [Current/Review pending/Update needed]

SUMMARY (for tenders):
[3-4 sentences on approach and key commitments]

KEY POINTS:
• [Bullet 1]
• [Bullet 2]
• [Bullet 3]

EVIDENCE OF IMPLEMENTATION:
• Staff training: [hours, frequency, completion %]
• Monitoring: [audits, checks, reviews]
• Recent improvements: [changes made]

ATTACHMENTS:
• Full policy document
• Related procedures
• Training materials
• Audit checklists

Core policies to maintain

Tier 1 (Must have, always current):

1. Safeguarding Adults (and Children if applicable)
2. Mental Capacity Act / Liberty Protection Safeguards
3. Risk Assessment and Management
4. Person-Centred Planning
5. Staff Recruitment and Selection (Safer Recruitment)
6. Staff Training and Development
7. Supervision and Appraisal
8. Complaints Handling
9. Medication Management (if applicable)
10. Health and Safety
11. Data Protection / GDPR
12. Whistleblowing
13. Quality Assurance
14. Equality and Diversity
15. Business Continuity

Tier 2 (Service-specific):

• Challenging Behaviour / PBS (if relevant)
• Dementia Care (if relevant)
• Autism-specific approaches
• End of Life Care
• Mental Health Crisis
• And others as applicable

---

Collection 4: Testimonials

Why testimonials matter

Third-party proof carries weight that self-assessment cannot. What service users, families, and commissioners say is more convincing than anything you write about yourself.

Template structure

REFERENCE: TEST-[SOURCE]-[TOPIC]-[DATE]
Example: TEST-FAMILY-OUTCOMES-2025-08

SOURCE TYPE:
☐ Service user
☐ Family member
☐ Commissioner
☐ Health professional
☐ Advocate
☐ Other professional

SERVICE TYPE: [What they received]
DATE COLLECTED: [When]
PERMISSION STATUS:
☐ Full permission (name can be used)
☐ Anonymous (quote only, no name)
☐ Internal use only (not for tenders)
☐ Pending (awaiting confirmation)

QUOTE:
"Exact words from the person"

CONTEXT:
• What service/circumstance
• Specific outcomes achieved
• Why this is compelling

USAGE NOTES:
• Which tender questions this fits
• Any restrictions on use
• Contact for permission verification

RELATED EVIDENCE:
• Case study reference
• KPI data supporting quote
• Photo/video (if applicable)

Permission tracking

Critical: Never use quotes without verified permission.

PERMISSION LOG:
Date requested: _____
Date granted: _____
Granted by: _____
Scope: ☐ Full ☐ Anonymous ☐ Internal only
Expiry/Review date: _____
Signature on file: ☐ Yes ☐ No
File location: _____

---

Collection 5: Staff and Team

Why team evidence matters

Commissioners are buying from people, not organisations. Your team’s capability and stability is a genuine differentiator.

Template structure

For key roles:

NAME: [Or role if anonymous for tenders]
POSITION: [Job title]
QUALIFICATIONS: [Degrees, diplomas, NVQs, registrations]
PROFESSIONAL REGISTRATION: [If applicable: NMC/HCPC/GMC]
EXPERIENCE:
• Years in role: _____
• Years in sector: _____
• Previous relevant positions

SPECIALISMS: [Specific expertise areas]
ACHIEVEMENTS: [Awards, publications, innovations]

QUOTE:
"How I deliver quality/support my team"

TENDER RELEVANCE:
• Which questions this supports
• What expertise they bring
• How they demonstrate quality

AVAILABILITY FOR INTERVIEWS:
☐ Yes ☐ No ☐ Case-by-case

For team overview:

TEAM STRUCTURE:
• Organisational chart
• Reporting lines
• Key roles and responsibilities

TEAM METRICS:
• Total staff: _____
• FTE breakdown by role: _____
• Average tenure: _____
• Qualification levels: _____
• Specialist skills: _____

---

Using Your Evidence Library in Practice

For framework applications

Week 1: Export relevant case studies, latest KPIs, current policies Week 2: Adapt examples to tender requirements Week 3: Customise, add tender-specific detail Week 4: Review, validate, submit

Time saved: 40-60% vs starting from scratch

For mini-competitions

Day 1: Identify required evidence from tender Day 2: Extract from library, adapt quickly Day 3-4: Customise, submit

Time saved: 50-70% vs writing fresh

For DPS call-offs

Hour 1: Rapid bid/no-bid based on evidence availability Hour 2-8: Extract, adapt, customise Hour 9-12: Quality check, submit

Time saved: 60% per response

---

Maintenance Schedule

Monthly (15 minutes)

• Update KPIs with latest data
• Check for new testimonials to add
• Verify policy review dates

Quarterly (1 hour)

• Add 1-2 new case studies
• Review and archive outdated evidence (>3 years)
• Update staff information
• Check testimonial permissions still valid

Annually (half day)

• Full policy review and refresh
• Comprehensive KPI trend analysis
• Case study audit (retire weak ones, add strong new ones)
• Team capability review
• Library structure optimisation

---

Setup Instructions

Step 1: Download and open

1. Download the Excel template
2. Open in Excel, Google Sheets, or compatible
3. Review the 5 collection tabs

Step 2: Gather existing evidence

1. Find your current case studies
2. Pull together KPI data (last 12 months)
3. List all policies with dates
4. Collect testimonials (with permission status)
5. Compile staff information

Step 3: Populate the template

1. Enter existing case studies (aim for 5-10)
2. Input KPI data (at least 6 months history)
3. List all policies (even if need updating)
4. Add testimonials (mark permission status)
5. Add key staff profiles

Step 4: Set up maintenance

1. Add monthly calendar reminder for KPI updates
2. Assign owner for each collection
3. Schedule quarterly review meeting
4. Set annual review date

Step 5: Use for your next tender

1. Review tender requirements
2. Search library for relevant evidence
3. Extract and adapt
4. Fill gaps with new content
5. Submit with confidence

---

Advanced: Integration with tender workflow

Before tender arrives

• Keep library current (follow maintenance schedule)
• Brief team on evidence collection
• Set up search/filter for quick retrieval

When tender arrives

1. Hour 1: Map tender questions to evidence needs
2. Hour 2: Search library for each requirement
3. Hour 3: Extract relevant case studies, KPIs, quotes
4. Hour 4: Gap analysis — what’s missing?
5. Hour 5+: Write new content only where necessary

During writing

• Copy from library, paste into response
• Customise for tender context
• Add tender-specific detail
• Cross-reference to library ID (for validation)

Post-submission

• Note which evidence was used
• Identify gaps for future collection
• Update library with new case studies from this tender
• Archive any outdated content

---

The ROI of Evidence Library

Time savings

• Before library: 100 hours average tender
• With library: 50-60 hours average tender
• Saving: 40-50 hours per tender
• Value: £2,000-£5,000 per tender (at £50/hour)

Quality improvement

• Consistent evidence across tenders
• Iterative improvement (better each time)
• Nothing forgotten or overlooked
• Stronger, more specific examples

Win rate impact

• Before: Rushed, inconsistent quality
• After: Professional, comprehensive responses
• Typical improvement: 15% → 35% win rate

Payback calculation

• Setup time: 4-8 hours one-time
• Monthly maintenance: 15 minutes
• Savings per tender: 40 hours
• Payback: First tender

---

Included Files

1. Evidence_Library_Template.xlsx

• 5 pre-built collections
• Example entries for each
• Search/filter enabled
• Charts and dashboards
• Auto-calculations

2. Setup_Guide.pdf

• 30-minute setup instructions
• Data gathering checklist
• Maintenance schedule template
• User guide with screenshots

3. Quick_Start_Checklist.pdf

• Day 1: Download and review
• Day 2: Gather existing evidence
• Day 3: Populate template
• Day 4: Set maintenance routine
• Day 5: Use for next tender

---

Support and Next Steps

DIY approach

Use this template to build your own library. Expect 4-8 hours to set up, 15 minutes per month to maintain.

Expert support

We offer:

• Evidence Library Build Service — We populate it for you
• Tender Response Service — We extract and adapt for each tender
• Evidence Review — Objective assessment of your current evidence

Results:

• Library built in 2-3 days
• Ready to use immediately
• Ongoing maintenance support available

---

Template version 1.0 — February 2026. Updated quarterly with best practices.