00_How_to_Use

TSCNET Bid Evaluation Matrix	Unnamed: 1
Transparent bidder-facing award calculation using standard Excel formulas only.

1. Eligibility	Only tenders marked Eligible are scored and ranked.
2. Price	Enter the two Year 1 net daily rates. The evaluated price uses 600 Manual Tester and 660 Automation Specialist person-days.
3. Performance improvements	Both improvements = 10 points; one = 5 points; neither = 0 points.
4. K1 and K2	Select 0, 20, 40, 60, 80 or 100 for each topic and document the rationale.
5. Final result	Price /60 + Performance /10 + K1 /15 + K2 /15 = maximum 100 points.
Colour convention	Light blue cells are inputs. Light grey cells are labels or fixed information. White cells contain formulas or linked results.
Test data version	This is the clean working template.

01_Eligibility

Eligibility Review	Unnamed: 1	Unnamed: 2	Unnamed: 3	Unnamed: 4	Unnamed: 5	Unnamed: 6	Unnamed: 7	Unnamed: 8	Unnamed: 9	Unnamed: 10	Unnamed: 11	Unnamed: 12	Unnamed: 13	Unnamed: 14
Record completeness and the documented eligibility decision before award scoring.
Bidder ID	Tenderer legal name	Eligibility status	Letter of Tender	Annex 1, if applicable	Annex 2, if applicable	Annex 3	Annex 4	Annex 5 and CVs	Annex 6	Annex 7	Annex 8	Annex 9	Annex K1 and K2	Decision rationale / clarification reference
BID-01
BID-02
BID-03
BID-04
BID-05
BID-06
BID-07
BID-08
BID-09
BID-10

02_Price_Evaluation

Bidder Price Evaluation	Unnamed: 1	Unnamed: 2	Unnamed: 3	Unnamed: 4	Unnamed: 5	Unnamed: 6	Unnamed: 7	Unnamed: 8	Unnamed: 9	Unnamed: 10	Unnamed: 11	Unnamed: 12
The full weighted-price calculation and resulting price score are visible.
Bidder ID	Tenderer	Eligibility	Manual Tester Y1 rate net EUR	Manual volume	Manual weighted amount	Automation Specialist Y1 rate net EUR	Automation volume	Automation weighted amount	Evaluated price net EUR	Eligible price helper	Lowest eligible price	Price score / 60
BID-01				600			660
BID-02				600			660
BID-03				600			660
BID-04				600			660
BID-05				600			660
BID-06				600			660
BID-07				600			660
BID-08				600			660
BID-09				600			660
BID-10				600			660

03_Performance_Improvements

Performance Improvement Evaluation	Unnamed: 1	Unnamed: 2	Unnamed: 3	Unnamed: 4	Unnamed: 5	Unnamed: 6	Unnamed: 7
Select Yes or No for each binding improvement offered in the Letter of Tender.
Bidder ID	Tenderer	Eligibility	Shorter confirmation periods offered	Simplified recall right offered	Number offered	Points / 10	Explanation
BID-01
BID-02
BID-03
BID-04
BID-05
BID-06
BID-07
BID-08
BID-09
BID-10

04_K1_Evaluation

Annex K1 Concept Evaluation	Unnamed: 1	Unnamed: 2	Unnamed: 3	Unnamed: 4	Unnamed: 5	Unnamed: 6	Unnamed: 7	Unnamed: 8	Unnamed: 9	Unnamed: 10
All four topic scores, rationale, raw average and weighted score are shown.
Bidder ID	Tenderer	Eligibility	Topic	Published topic	Score	Level	Evaluator rationale / evidence reference	Raw average / 100	Weight	Weighted / 15
BID-01			i	Candidate Sourcing Infrastructure and Availability Strategy					0.15
BID-01			ii	Strategies for Long-Term Candidate Engagement and Development					0.15
BID-01			iii	Contingency Planning for Unexpected Operational Absences					0.15
BID-01			iv	Replacement Procedure following Formal Rejection or Recall					0.15
BID-02			i	Candidate Sourcing Infrastructure and Availability Strategy					0.15
BID-02			ii	Strategies for Long-Term Candidate Engagement and Development					0.15
BID-02			iii	Contingency Planning for Unexpected Operational Absences					0.15
BID-02			iv	Replacement Procedure following Formal Rejection or Recall					0.15
BID-03			i	Candidate Sourcing Infrastructure and Availability Strategy					0.15
BID-03			ii	Strategies for Long-Term Candidate Engagement and Development					0.15
BID-03			iii	Contingency Planning for Unexpected Operational Absences					0.15
BID-03			iv	Replacement Procedure following Formal Rejection or Recall					0.15
BID-04			i	Candidate Sourcing Infrastructure and Availability Strategy					0.15
BID-04			ii	Strategies for Long-Term Candidate Engagement and Development					0.15
BID-04			iii	Contingency Planning for Unexpected Operational Absences					0.15
BID-04			iv	Replacement Procedure following Formal Rejection or Recall					0.15
BID-05			i	Candidate Sourcing Infrastructure and Availability Strategy					0.15
BID-05			ii	Strategies for Long-Term Candidate Engagement and Development					0.15
BID-05			iii	Contingency Planning for Unexpected Operational Absences					0.15
BID-05			iv	Replacement Procedure following Formal Rejection or Recall					0.15
BID-06			i	Candidate Sourcing Infrastructure and Availability Strategy					0.15
BID-06			ii	Strategies for Long-Term Candidate Engagement and Development					0.15
BID-06			iii	Contingency Planning for Unexpected Operational Absences					0.15
BID-06			iv	Replacement Procedure following Formal Rejection or Recall					0.15
BID-07			i	Candidate Sourcing Infrastructure and Availability Strategy					0.15
BID-07			ii	Strategies for Long-Term Candidate Engagement and Development					0.15
BID-07			iii	Contingency Planning for Unexpected Operational Absences					0.15
BID-07			iv	Replacement Procedure following Formal Rejection or Recall					0.15
BID-08			i	Candidate Sourcing Infrastructure and Availability Strategy					0.15
BID-08			ii	Strategies for Long-Term Candidate Engagement and Development					0.15
BID-08			iii	Contingency Planning for Unexpected Operational Absences					0.15
BID-08			iv	Replacement Procedure following Formal Rejection or Recall					0.15
BID-09			i	Candidate Sourcing Infrastructure and Availability Strategy					0.15
BID-09			ii	Strategies for Long-Term Candidate Engagement and Development					0.15
BID-09			iii	Contingency Planning for Unexpected Operational Absences					0.15
BID-09			iv	Replacement Procedure following Formal Rejection or Recall					0.15
BID-10			i	Candidate Sourcing Infrastructure and Availability Strategy					0.15
BID-10			ii	Strategies for Long-Term Candidate Engagement and Development					0.15
BID-10			iii	Contingency Planning for Unexpected Operational Absences					0.15
BID-10			iv	Replacement Procedure following Formal Rejection or Recall					0.15

05_K2_Evaluation

Annex K2 Concept Evaluation	Unnamed: 1	Unnamed: 2	Unnamed: 3	Unnamed: 4	Unnamed: 5	Unnamed: 6	Unnamed: 7	Unnamed: 8	Unnamed: 9	Unnamed: 10
All four topic scores, rationale, raw average and weighted score are shown.
Bidder ID	Tenderer	Eligibility	Topic	Published topic	Score	Level	Evaluator rationale / evidence reference	Raw average / 100	Weight	Weighted / 15
BID-01			i	Recruiting Process and Selection Methods					0.15
BID-01			ii	Verification of Qualifications and Professional Experience					0.15
BID-01			iii	Ongoing Performance Monitoring and Escalation					0.15
BID-01			iv	Quality Assurance in the Involvement of Subcontractors					0.15
BID-02			i	Recruiting Process and Selection Methods					0.15
BID-02			ii	Verification of Qualifications and Professional Experience					0.15
BID-02			iii	Ongoing Performance Monitoring and Escalation					0.15
BID-02			iv	Quality Assurance in the Involvement of Subcontractors					0.15
BID-03			i	Recruiting Process and Selection Methods					0.15
BID-03			ii	Verification of Qualifications and Professional Experience					0.15
BID-03			iii	Ongoing Performance Monitoring and Escalation					0.15
BID-03			iv	Quality Assurance in the Involvement of Subcontractors					0.15
BID-04			i	Recruiting Process and Selection Methods					0.15
BID-04			ii	Verification of Qualifications and Professional Experience					0.15
BID-04			iii	Ongoing Performance Monitoring and Escalation					0.15
BID-04			iv	Quality Assurance in the Involvement of Subcontractors					0.15
BID-05			i	Recruiting Process and Selection Methods					0.15
BID-05			ii	Verification of Qualifications and Professional Experience					0.15
BID-05			iii	Ongoing Performance Monitoring and Escalation					0.15
BID-05			iv	Quality Assurance in the Involvement of Subcontractors					0.15
BID-06			i	Recruiting Process and Selection Methods					0.15
BID-06			ii	Verification of Qualifications and Professional Experience					0.15
BID-06			iii	Ongoing Performance Monitoring and Escalation					0.15
BID-06			iv	Quality Assurance in the Involvement of Subcontractors					0.15
BID-07			i	Recruiting Process and Selection Methods					0.15
BID-07			ii	Verification of Qualifications and Professional Experience					0.15
BID-07			iii	Ongoing Performance Monitoring and Escalation					0.15
BID-07			iv	Quality Assurance in the Involvement of Subcontractors					0.15
BID-08			i	Recruiting Process and Selection Methods					0.15
BID-08			ii	Verification of Qualifications and Professional Experience					0.15
BID-08			iii	Ongoing Performance Monitoring and Escalation					0.15
BID-08			iv	Quality Assurance in the Involvement of Subcontractors					0.15
BID-09			i	Recruiting Process and Selection Methods					0.15
BID-09			ii	Verification of Qualifications and Professional Experience					0.15
BID-09			iii	Ongoing Performance Monitoring and Escalation					0.15
BID-09			iv	Quality Assurance in the Involvement of Subcontractors					0.15
BID-10			i	Recruiting Process and Selection Methods					0.15
BID-10			ii	Verification of Qualifications and Professional Experience					0.15
BID-10			iii	Ongoing Performance Monitoring and Escalation					0.15
BID-10			iv	Quality Assurance in the Involvement of Subcontractors					0.15

06_Final_Ranking

Final Evaluation and Ranking	Unnamed: 1	Unnamed: 2	Unnamed: 3	Unnamed: 4	Unnamed: 5	Unnamed: 6	Unnamed: 7	Unnamed: 8	Unnamed: 9	Unnamed: 10
Only eligible tenders with complete component scores receive a rank.
Bidder ID	Tenderer	Eligibility	Evaluated price	Price / 60	Performance / 10	K1 / 15	K2 / 15	Total / 100	Rank	Result note
BID-01
BID-02
BID-03
BID-04
BID-05
BID-06
BID-07
BID-08
BID-09
BID-10

07_Parameters

Evaluation Parameters	Unnamed: 1	Unnamed: 2	Unnamed: 3	Unnamed: 4	Unnamed: 5
Fixed published values used in the calculations.
Parameter	Value	Unit	Plain-language purpose	Source document	Type
Maximum price score	60	points	Maximum award points for price.	Bidding Conditions, XI	Fixed
Maximum performance score	10	points	Maximum award points for the two improvements.	Bidding Conditions, XI	Fixed
K1 weighting	0.15	share	Converts raw 0-100 score into maximum 15 points.	Concept Evaluation Matrix	Fixed
K2 weighting	0.15	share	Converts raw 0-100 score into maximum 15 points.	Concept Evaluation Matrix	Fixed
Maximum total score	100	points	Maximum total award score.	Calculated	Formula
Manual Tester evaluation volume	600	person-days	Year 1 price weighting volume.	Annex 5 FA	Fixed
Automation Specialist evaluation volume	660	person-days	Year 1 price weighting volume.	Annex 5 FA	Fixed
Price zero-point threshold	2	times lowest	Price at or above twice the lowest eligible price receives zero.	Bidding Conditions, XI	Fixed

08_Source_Register

Source Register	Unnamed: 1	Unnamed: 2	Unnamed: 3	Unnamed: 4
Documents reflected in the evaluation structure.
Document	Role	Information used	Formula impact	Note
Bidding Conditions.docx	Primary methodology	Weights, price score, performance score and overall evaluation	Direct	Controlling award rules
Annex 1_to Bidding Conditions_Evaluation Matrix.docx	Concept method	K1/K2 topics, score levels, average and weighting	Direct	Detailed level descriptions remain controlling
Letter of Tender.docx	Declarations	Two performance improvements and submission list	Direct	Yes/No inputs
Annex 5_FA_Estimated and Maximum Framework Volume.docx	Volumes	600 and 660 person-days for Year 1 price weighting	Direct	Evaluated price
Annex 8_to LoT_Price Schedule.xlsx	Commercial inputs	Separate Year 1 profile rates	Direct	Price inputs
Annexes 1-7 and 9	Eligibility	Completeness and suitability	Gate	No award points

TSCNET_Bid_Evaluation_Matrix.xlsx

00_How_to_Use

01_Eligibility

02_Price_Evaluation

03_Performance_Improvements

04_K1_Evaluation

05_K2_Evaluation

06_Final_Ranking

07_Parameters

08_Source_Register