{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Summary","Introduction","Instructions","Price Criteria","Quality Criteria","Price & Quality Combined","Summary ","Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Summary","index":0,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":true,"merged":[]}
[]
[]
["Tenderer","Overall Score","Rank"]
[{"$f":"Instructions!#REF!","v":{"$error":"#REF!"}},{"$f":"'Price & Quality Combined'!H24","v":0},{"$f":"'Price & Quality Combined'!H25","v":"N/A"}]
[{"$f":"Instructions!#REF!","v":{"$error":"#REF!"}},{"$f":"'Price & Quality Combined'!K24","v":0},{"$f":"'Price & Quality Combined'!K25","v":"N/A"}]
[{"$f":"Instructions!#REF!","v":{"$error":"#REF!"}},{"$f":"'Price & Quality Combined'!N24","v":0},{"$f":"'Price & Quality Combined'!N25","v":"N/A"}]
[{"$f":"Instructions!#REF!","v":{"$error":"#REF!"}},{"$f":"'Price & Quality Combined'!Q24","v":0},{"$f":"'Price & Quality Combined'!Q25","v":"N/A"}]
[{"$f":"Instructions!#REF!","v":{"$error":"#REF!"}},{"$f":"'Price & Quality Combined'!T24","v":0},{"$f":"'Price & Quality Combined'!T25","v":"N/A"}]
[{"$f":"Instructions!#REF!","v":{"$error":"#REF!"}},{"$f":"'Price & Quality Combined'!W24","v":0},{"$f":"'Price & Quality Combined'!W25","v":"N/A"}]
[{"$f":"Instructions!#REF!","v":{"$error":"#REF!"}},{"$f":"'Price & Quality Combined'!Z24","v":0},{"$f":"'Price & Quality Combined'!Z25","v":"N/A"}]
[{"$f":"Instructions!#REF!","v":{"$error":"#REF!"}},{"$f":"'Price & Quality Combined'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Price & Quality Combined'!#REF!","v":{"$error":"#REF!"}}]
[{"$f":"Instructions!#REF!","v":{"$error":"#REF!"}},{"$f":"'Price & Quality Combined'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Price & Quality Combined'!#REF!","v":{"$error":"#REF!"}}]
[{"$f":"Instructions!#REF!","v":{"$error":"#REF!"}},{"$f":"'Price & Quality Combined'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Price & Quality Combined'!#REF!","v":{"$error":"#REF!"}}]

{"sheet":"Introduction","index":1,"n_rows":58,"n_cols":8,"rows_kept":58,"cut":false,"hidden":false,"merged":[[42,5,46,5],[32,5,36,5],[49,2,49,3],[52,2,56,2],[52,5,56,5],[52,3,52,4],[53,3,53,4],[54,3,54,4],[55,3,55,4],[56,3,56,4],[11,2,11,3],[29,2,29,4],[12,2,14,3],[12,4,14,4],[43,3,43,4],[33,3,33,4],[32,3,32,4],[15,2,17,3],[18,2,21,3],[22,2,24,3],[30,3,30,4],[31,3,31,4],[26,2,27,10],[13,7,15,10],[13,6,15,6],[16,7,18,10],[16,6,18,6],[22,4,24,4],[15,4,17,4],[18,4,21,4],[19,7,20,10],[19,6,20,6],[21,7,23,10],[21,6,23,6],[3,2,3,10],[5,2,5,13],[9,2,9,7],[6,2,6,7],[4,2,4,10],[8,2,8,3],[12,7,12,10],[11,6,11,10],[57,2,57,4],[34,3,34,4],[44,3,44,4],[45,3,45,4],[46,3,46,4],[47,2,47,4],[39,2,39,3],[35,3,35,4],[36,3,36,4],[37,2,37,4],[41,3,41,4],[42,3,42,4],[42,2,46,2],[32,2,36,2]]}
[]
[null,null,"Introduction to the PeatlandACTION Tender Scoring Matrix"]
[]
[null,null,"• This scoring matrix template is based on the template within the Scottish Government's Procurement Journey."]
[null,null,"• By using the Tender Scoring Matrix, it is possible to identify the best value for money proposal taking account of both qualitative and financial criteria."]
[null,null,"• Evaluation of tenders using the Quality Price Matrix must be undertaken strictly in accordance with the criteria and associated weightings that have been published in the contract notice or invitation to tender. "]
[null,null,"• The scoring methodology and weightings should also be published in the tender documentation."]
[]
[null,null,"Weighting the Criteria"]
[null,null,"The table below provides the preferred ratios depending on the nature of the goods/services/works being procured.  Weightings should always total 100."]
[]
[null,null,"Peatland Action Examples",null,"Suggested Price/Quality Ratio",null,"Scoring Methodology for Quality Criteria"]
[null,null,"Purchased goods eg. coir logs, monitoring equipment, etc.",null,"100:0 to 90:10",null,"0 - Unacceptable","Nil or inadequate response. Fails to demonstrate an ability to meet the requirement."]
[null,null,null,null,null,null,"1 - Poor","Response is partially relevant but generally poor.  The response addresses some elements of the requirement but contains insufficient/limited detail or explanation  to demonstrate how  the requirement will be fulfilled."]
[]
[null,null,"Basic peatland restoration eg. mainly ditch blocking, reprofiling ",null,"80:20 to 60:40"]
[null,null,null,null,null,null,"2 - Acceptable","Response is relevant and acceptable. The response addresses a broad understanding of the requirement but may lack details on how the requirement will be fulfilled in certain areas. "]
[]
[null,null,"Standard upland restoration eg. ditch blocking, reprofiling, cell bunding at high altitude; or \nforest to bog",null,"60:40 to 40:60"]
[null,null,null,null,null,null,"3 - Good","Response is relevant and good. The response is sufficiently detailed to demonstrate a good understanding and provides details on how the requirements will be fulfilled."]
[]
[null,null,null,null,null,null,"4 - Excellent","Response is completely relevant and excellent overall. The response is comprehensive, unambiguous and demonstrates a thorough understanding of the requirement and provides details of how the requirement will be met in full."]
[null,null,"Complex multiple activity restoration; or \nheavily eroded peat/peat pan stabilisation",null,"40:60 to 30:70"]
[]
[]
[]
[null,null,"NatureScot expects all organisations with a workforce must be able to demonstrate they meet the Fair Work First policy for all new grant offers issued from 1st July 2023. These criteria are: for employees to receive at least the real Living Wage; and for workers to be provided with appropriate channels for effective voice. "]
[]
[]
[null,null,"Example of a basic peatland restoration project"]
[null,null,"Scoring Criteria ","Description",null,"Price/Quality Ratio"]
[null,null,"Costs","• Value for money - delivery costs",null,0.7]
[null,null,"Quality","• Methodology compatible with site access and sensitivities",null,0.3]
[null,null,null,"• Evidence of working in similar project environments"]
[null,null,null,"• Relevant knowledge, skills and experience of proposed personnel (as evidenced in CVs)"]
[null,null,null,"• Timetable and delivery including risk management"]
[null,null,null,"• Environmental impact (ie. Efforts to limit negtaive impact)"]
[null,null,"total",null,null,{"$f":"SUM(F32:F37)","v":1}]
[]
[null,null,"Example of a standard peatland restoration project"]
[null,null,"Scoring Criteria ","Description",null,"Price/Quality Ratio"]
[null,null,"Costs","• Value for money - delivery costs",null,0.4]
[null,null,"Quality","• Methodology compatible with site access and sensitivities",null,0.6]
[null,null,null,"• Evidence of having successfully executed similar projects is demonstrated"]
[null,null,null,"• Relevant knowledge, skills and experience of proposed personnel (as evidenced in CVs)"]
[null,null,null,"• Timetable and delivery including risk management"]
[null,null,null,"• Environmental impact (ie. Efforts to limit negtaive impact)"]
[null,null,"total",null,null,{"$f":"SUM(F42:F47)","v":1}]
[]
[null,null,"Example of a complex peatland restoration project"]
[null,null,"Scoring Criteria ","Description",null,"Price/Quality Ratio"]
[null,null,"Costs","• Value for money - delivery costs",null,0.3]
[null,null,"Quality","• Methodology compatible with site access and sensitivities",null,0.7]
[null,null,null,"• Evidence of having successfully executed similar projects is demonstrated"]
[null,null,null,"• Relevant knowledge, skills and experience of proposed personnel (as evidenced in CVs)"]
[null,null,null,"• Timetable and delivery including risk management"]
[null,null,null,"• Environmental impact (ie. Efforts to limit negtaive impact)"]
[null,null,"total",null,null,{"$f":"SUM(F52:F57)","v":1}]

{"sheet":"Instructions","index":2,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,0,0,16383],[1,2,1,3]]}
[]
[null,null,"Instructions for the use of the Quality Price Evaluation Matrix"]
[null,null,null,null,"Insert Supplier's names in the cells below:"]
[null,null,"1)","Enter the Supplier's name for each tender received in column E - the Price Criteria, Quality Criteria and Combined worksheets will be updated automatically.","Tenderer's name - 1"]
[null,null,"2)","The criteria, sub-criteria and associated weightings used to evaluate tenders must be included in the tender documentation. Weightings applied at all levels must total 100.","Tenderer's name - 2"]
[null,null,"3)","Data should only be entered into green cells, all other cells will be populated automatically.","Tenderer's name - 3"]
[null,null,"4)","Enter the criteria, sub-criteria and associated weightings for Quality in the Quality Criteria worksheet. These should be the same as defined in the Statement of Requirements","Tenderer's name - 4"]
[null,null,"5)","Actual quoted costs should be inserted into the Price Criteria worksheet. ","Tenderer's name - 5"]
[null,null,"6)","The score entered into the Quality Criteria worksheet will be the final scores from the pre-defined evaluation process agreed with your evaluators and shared with the suppliers in the tender documentation.","Tenderer's name - 6"]
[null,null,"7)","In the Price & Quality Combined worksheet there is the option to included quality thresholds which have to be attained.   ","Tenderer's name - 7"]
[null,null,"8)","You can add additional suppliers by inserting the appropriate number of columns in each worksheet and copying the formula from existing columns. Start by inserting the changes on the Price and Quality worksheets then amend the Combined worksheet. Add additional names under the list provided opposite.  "]

{"sheet":"Price Criteria","index":3,"n_rows":28,"n_cols":17,"rows_kept":28,"cut":false,"hidden":false,"merged":[[18,1,18,2],[24,1,24,2],[25,1,25,2],[27,1,27,2],[1,1,1,10],[12,1,12,2],[19,1,19,2],[22,1,22,2],[26,1,26,2],[21,1,21,2],[16,1,16,2],[15,1,15,2],[17,1,17,2],[20,1,20,2],[23,1,23,2],[9,1,9,2],[10,1,10,2],[13,1,13,2],[14,1,14,2],[5,1,5,2],[6,1,6,2],[7,1,7,2],[8,1,8,2],[11,1,11,2],[5,3,5,4],[5,5,5,6],[5,9,5,10],[5,11,5,12],[5,7,5,8],[5,17,5,19],[5,20,5,22],[5,23,5,25],[5,15,5,16],[5,13,5,14]]}
[]
[null,"Please note, you should only type in green cells. Type shown in italics is for illustration purposes and can be amended. \nAdditional tenders can be added by inserting columns per submission between existing tenders e.g. Tender 1 and Tender 2 and copying the formula. Repeat in both the Quality Criteria and the Price and Quality Combined worksheets."]
[]
[null,"Project Weighting for Price",0.4]
[]
[null,null,null,{"$f":"Instructions!E4","v":"Tenderer's name - 1"},null,{"$f":"Instructions!E5","v":"Tenderer's name - 2"},null,{"$f":"Instructions!E6","v":"Tenderer's name - 3"},null,{"$f":"Instructions!E7","v":"Tenderer's name - 4"},null,{"$f":"Instructions!E8","v":"Tenderer's name - 5"},null,{"$f":"Instructions!E9","v":"Tenderer's name - 6"},null,{"$f":"Instructions!E10","v":"Tenderer's name - 7"}]
[null,"Price of goods/provision of service \n(amend as required)"]
[null,"Gully reprofiling - gullies over 50cm deep."]
[null,"Gully blocking including micro gullies - peat dams / bunds / baffles in wide gullies to push water away from reprofiled edgesGully blocking including micro gullies - peat dams / bunds / baffles in wide gullies to push water away from reprofiled edges","Gully blocking including micro gullies - peat dams / bunds / baffles in wide gullies to push water away from reprofiled edgesGully blocking including micro gullies - peat dams / bunds / baffles in wide gullies to push water away from reprofiled edges"]
[null,"Drain damming","Drain damming"]
[null,"Drain reprofiling","Drain reprofiling"]
[null,"Hag reprofiling","Hag reprofiling"]
[null,"Cell bunding","Cell bunding"]
[null,"Sphagnum transplanting","Sphagnum transplanting"]
[null,"Data capture","Data capture"]
[null,"Mobilisation","Mobilisation"]
[null,"Travel/subsistence","Travel/subsitence"]
[null,"Equipment hire","Equipment hire"]
[null,"Fuel","Fuel"]
[null,"Project management / reporting","Project management / reporting"]
[null,"Amount to reinstate and damage caused to the access route","Amount to reinstate and damage caused to the access route"]
[null,"Welfare unit","Welfare unit"]
[null,"Support equipment provision","Support equipment provision"]
[]
[]
[]
[]
[null,"Total Price",null,null,{"$f":"SUM(E8:E27)","v":0},null,{"$f":"SUM(G8:G27)","v":0},null,{"$f":"SUM(I8:I27)","v":0},null,{"$f":"SUM(K8:K27)","v":0},null,{"$f":"SUM(M8:M27)","v":0},null,{"$f":"SUM(O8:O27)","v":0},null,{"$f":"SUM(Q8:Q27)","v":0}]

{"sheet":"Quality Criteria","index":4,"n_rows":11,"n_cols":27,"rows_kept":11,"cut":false,"hidden":false,"merged":[[10,2,10,3],[3,1,3,2],[8,2,8,3],[9,2,9,3],[7,2,7,3],[1,1,1,8],[6,2,6,3],[5,24,5,26],[5,27,5,29],[5,21,5,23],[5,6,5,8],[5,9,5,11],[5,12,5,14],[5,15,5,17],[5,18,5,20],[2,6,2,7],[3,6,3,7],[2,9,2,11],[3,9,3,11]]}
[]
[null,"Please note, you should only type in green cells. Type shown in italics is for illustration purposes and can be amended. \nAdditional tenders can be added by inserting columns per submission between existing tenders e.g. Tender 1 and Tender 2 and copying the formula. \nRepeat in both the Price and the Price & Quality Combined worksheets."]
[]
[null,"Project Weighting for Quality",null,0.6]
[]
[null,null,null,null,null,null,{"$f":"Instructions!E4","v":"Tenderer's name - 1"},null,null,{"$f":"Instructions!E5","v":"Tenderer's name - 2"},null,null,{"$f":"Instructions!E6","v":"Tenderer's name - 3"},null,null,{"$f":"Instructions!E7","v":"Tenderer's name - 4"},null,null,{"$f":"Instructions!E8","v":"Tenderer's name - 5"},null,null,{"$f":"Instructions!E9","v":"Tenderer's name - 6"},null,null,{"$f":"Instructions!E10","v":"Tenderer's name - 7"}]
[null,null,"Quality Criteria (amend as required)",null,"Section Weighting %","Question Weighting","Score \n(out of 4)","Score (%)","Section Weighted Score","Score \n(out of 4)","Score (%)","Section Weighted Score","Score \n(out of 4)","Score (%)","Section Weighted Score","Score \n(out of 4)","Score (%)","Section Weighted Score","Score \n(out of 4)","Score (%)","Section Weighted Score","Score \n(out of 4)","Score (%)","Section Weighted Score","Score \n(out of 4)","Score (%)","Question Weighted Score"]
[null,"Methodology","The tenderer should demonstrate their understanding of the aims of the peatland restoration on this site and the techniques specificed, as well as their ability to work practically and sensiitively on peatland sites.",null,0.35,1,null,{"$f":"(G8/4)","v":0},{"$f":"(H8*$F8*$E$8)*100","v":0},null,{"$f":"(J8/4)","v":0},{"$f":"(K8*$F8*$E$8)*100","v":0},null,{"$f":"(M8/4)","v":0},{"$f":"(N8*$F8*$E$8)*100","v":0},null,{"$f":"(P8/4)","v":0},{"$f":"(Q8*$F8*$E$8)*100","v":0},null,{"$f":"(S8/4)","v":0},{"$f":"(T8*$F8*$E$8)*100","v":0},null,{"$f":"(V8/4)","v":0},{"$f":"(W8*$F8*$E$8)*100","v":0},null,{"$f":"(Y8/4)","v":0},{"$f":"(Z8*$F8*$E$8)*100","v":0}]
[null,"Experience","The tenderer should demonstrate relevant knowledge, skills and any comparable of the project team (especially machine operators) proposed to the carry out the works)",null,0.35,1,null,0,{"$f":"(H9*$F9*$E$9)*100","v":0},null,0,{"$f":"(K9*$F9*$E$9)*100","v":0},null,0,{"$f":"(N9*$F9*$E$9)*100","v":0},null,0,{"$f":"(Q9*$F9*$E$9)*100","v":0},null,0,{"$f":"(T9*$F9*$E$9)*100","v":0},null,0,{"$f":"(W9*$F9*$E$9)*100","v":0},null,0,{"$f":"(Z9*$F9*$E$9)*100","v":0}]
[null,"Timescales","The tenderer should demonstrate an ability to adhere to the agreed timetable for delivery and manage any risk to that delivery timescale",null,0.2,1,null,0,{"$f":"(H10*$F10*$E$10)*100","v":0},null,0,{"$f":"(K10*$F10*$E$10)*100","v":0},null,0,{"$f":"(N10*$F10*$E$10)*100","v":0},null,0,{"$f":"(Q10*$F10*$E$10)*100","v":0},null,0,{"$f":"(T10*$F10*$E$10)*100","v":0},null,0,{"$f":"(W10*$F10*$E$10)*100","v":0},null,0,{"$f":"(Z10*$F10*$E$10)*100","v":0}]
[null,"Sustainability ","The tenderer should carry out the project in a manner that avoids or minimises negative impacts on the environment, supports sustainability, fari working practices and the local economy and community ",null,0.1,1,null,0,{"$f":"(H11*$F11*$E$11)*100","v":0},null,0,{"$f":"(K11*$F11*$E$11)*100","v":0},null,0,{"$f":"(N11*$F11*$E$11)*100","v":0},null,0,{"$f":"(Q11*$F11*$E$11)*100","v":0},null,0,{"$f":"(T11*$F11*$E$11)*100","v":0},null,0,{"$f":"(W11*$F11*$E$11)*100","v":0},null,0,{"$f":"(Z11*$F11*$E$11)*100","v":0}]

{"sheet":"Price & Quality Combined","index":5,"n_rows":36,"n_cols":26,"rows_kept":36,"cut":false,"hidden":false,"merged":[[27,14,29,16],[27,17,29,19],[27,20,29,22],[27,23,29,25],[15,1,15,3],[26,20,26,22],[26,23,26,25],[26,14,26,16],[26,17,26,19],[15,5,15,6],[16,11,16,12],[17,5,17,6],[24,8,24,9],[24,11,24,12],[17,8,17,9],[17,11,17,12],[35,1,35,8],[9,1,9,4],[32,1,32,9],[33,1,33,7],[20,1,20,2],[23,1,23,4],[24,1,24,4],[16,8,16,9],[26,1,29,4],[18,1,18,4],[19,1,19,4],[25,1,25,4],[24,5,24,6],[23,5,23,6],[23,8,23,9],[16,5,16,6],[17,14,17,15],[23,11,23,12],[19,8,19,9],[20,8,20,9],[19,11,19,12],[20,11,20,12],[19,14,19,15],[20,14,20,15],[26,5,26,7],[26,11,26,13],[26,8,26,10],[27,5,29,7],[27,8,29,10],[27,11,29,13],[9,26,9,28],[9,20,9,22],[9,23,9,25],[9,17,9,19],[1,1,1,2],[6,1,6,2],[7,1,7,2],[9,5,9,7],[9,8,9,10],[5,2,5,4],[8,1,8,2],[14,1,14,2],[5,6,5,7],[3,1,3,7],[10,1,10,2],[17,17,17,18],[15,8,15,9],[15,11,15,12],[15,14,15,15],[15,17,15,18],[16,14,16,15],[16,17,16,18],[9,11,9,13],[9,14,9,16],[11,1,11,2],[12,1,12,2],[13,1,13,2],[21,1,21,4],[22,1,22,4],[15,20,15,21],[15,23,15,24],[17,23,17,24],[17,20,17,21],[16,23,16,24],[16,20,16,21],[19,23,19,24],[20,23,20,24],[19,17,19,18],[20,17,20,18],[19,20,19,21],[20,20,20,21],[19,5,19,6],[20,5,20,6]]}
[]
[null,"Tender Scoring Matrix"]
[]
[null,"Please note, you should only type in green cells. Type shown in italics is for illustation purposes. \nActual criteria, weightings and data may vary from project to project.\nAdditional Tenders can be added by inserting THREE columns per tender and copying formula from an existing tender.\nAdd the tenders to the Price Criteria and Quality Criteria worksheets FIRST and align new entries across ALL three worksheets.",null,null,null,null,null,null," "]
[]
[null,"Procurement title:",null,null,null,"Evaluator:"]
[]
[null,"Project quality weighting (%):",null,0.6]
[null,"Project price weighting (%):",null,0.4]
[null,"QUALITY SCORES",null,null,null,{"$f":"Instructions!E4","v":"Tenderer's name - 1"},null,null,{"$f":"Instructions!E5","v":"Tenderer's name - 2"},null,null,{"$f":"Instructions!E6","v":"Tenderer's name - 3"},null,null,{"$f":"Instructions!E7","v":"Tenderer's name - 4"},null,null,{"$f":"Instructions!E8","v":"Tenderer's name - 5"},null,null,{"$f":"Instructions!E9","v":"Tenderer's name - 6"},null,null,{"$f":"Instructions!E10","v":"Tenderer's name - 7"}]
[null,"Example Technical & Quality Criteria",null,"Individual Quality Threshold (optional)","Section Criteria Weight ","Quality Threshold reached?","Section Score","Section Weighted Score","Quality Threshold reached?","Section Score","Section Weighted Score","Quality Threshold reached?","Section Score","Section Weighted Score","Quality Threshold reached?","Section Score","Section Weighted Score","Quality Threshold reached?","Section Score","Section Weighted Score","Quality Threshold reached?","Section Score","Section Weighted Score","Quality Threshold reached?","Section Score","Section Weighted Score"]
[null,{"$f":"'Quality Criteria'!B8","v":"Methodology"},null,3,{"$f":"'Quality Criteria'!E8","v":0.35},{"$f":"IF(G12<$D12,\"No\",\"Yes\")","v":"No"},{"$f":"'Quality Criteria'!G8","v":0},{"$f":"'Quality Criteria'!I8","v":0},{"$f":"IF(J12<$D12,\"No\",\"Yes\")","v":"No"},{"$f":"'Quality Criteria'!J8","v":0},{"$f":"'Quality Criteria'!L8","v":0},{"$f":"IF(M12<$D12,\"No\",\"Yes\")","v":"No"},{"$f":"'Quality Criteria'!M8","v":0},{"$f":"'Quality Criteria'!O8","v":0},{"$f":"IF(P12<$D12,\"No\",\"Yes\")","v":"No"},{"$f":"'Quality Criteria'!P8","v":0},{"$f":"'Quality Criteria'!R8","v":0},{"$f":"IF(S12<$D12,\"No\",\"Yes\")","v":"No"},{"$f":"'Quality Criteria'!S8","v":0},{"$f":"'Quality Criteria'!U8","v":0},{"$f":"IF(V12<$D12,\"No\",\"Yes\")","v":"No"},{"$f":"'Quality Criteria'!V8","v":0},{"$f":"'Quality Criteria'!X8","v":0},{"$f":"IF(Y12<$D12,\"No\",\"Yes\")","v":"No"},{"$f":"'Quality Criteria'!Y8","v":0},{"$f":"'Quality Criteria'!AA8","v":0}]
[null,"Experience",null,3,{"$f":"'Quality Criteria'!E9","v":0.35},{"$f":"IF(G13<$D13,\"No\",\"Yes\")","v":"No"},{"$f":"'Quality Criteria'!G9","v":0},{"$f":"'Quality Criteria'!I9","v":0},{"$f":"IF(J13<$D13,\"No\",\"Yes\")","v":"No"},{"$f":"'Quality Criteria'!J9","v":0},{"$f":"'Quality Criteria'!L9","v":0},{"$f":"IF(M13<$D13,\"No\",\"Yes\")","v":"No"},{"$f":"'Quality Criteria'!M9","v":0},{"$f":"'Quality Criteria'!O9","v":0},"No",{"$f":"'Quality Criteria'!P9","v":0},{"$f":"'Quality Criteria'!R9","v":0},"No",{"$f":"'Quality Criteria'!S9","v":0},{"$f":"'Quality Criteria'!U9","v":0},"No",{"$f":"'Quality Criteria'!V9","v":0},{"$f":"'Quality Criteria'!X9","v":0},"No",{"$f":"'Quality Criteria'!Y9","v":0},{"$f":"'Quality Criteria'!AA9","v":0}]
[null,{"$f":"'Quality Criteria'!B10","v":"Timescales"},null,3,{"$f":"'Quality Criteria'!E10","v":0.2},"No",{"$f":"'Quality Criteria'!G10","v":0},{"$f":"'Quality Criteria'!I10","v":0},"No",{"$f":"'Quality Criteria'!J10","v":0},{"$f":"'Quality Criteria'!L10","v":0},"No",{"$f":"'Quality Criteria'!M10","v":0},{"$f":"'Quality Criteria'!O10","v":0},"No",{"$f":"'Quality Criteria'!P10","v":0},{"$f":"'Quality Criteria'!R10","v":0},"No",{"$f":"'Quality Criteria'!S10","v":0},{"$f":"'Quality Criteria'!U10","v":0},"No",{"$f":"'Quality Criteria'!V10","v":0},{"$f":"'Quality Criteria'!X10","v":0},"No",{"$f":"'Quality Criteria'!Y10","v":0},{"$f":"'Quality Criteria'!AA10","v":0}]
[null,{"$f":"'Quality Criteria'!B11","v":"Sustainability "},null,2,{"$f":"'Quality Criteria'!E11","v":0.1},"No",{"$f":"'Quality Criteria'!G11","v":0},{"$f":"'Quality Criteria'!I11","v":0},"No",{"$f":"'Quality Criteria'!J11","v":0},{"$f":"'Quality Criteria'!L11","v":0},"No",{"$f":"'Quality Criteria'!M11","v":0},{"$f":"'Quality Criteria'!O11","v":0},"No",{"$f":"'Quality Criteria'!P11","v":0},{"$f":"'Quality Criteria'!R11","v":0},"No",{"$f":"'Quality Criteria'!S11","v":0},{"$f":"'Quality Criteria'!U11","v":0},"No",{"$f":"'Quality Criteria'!V11","v":0},{"$f":"'Quality Criteria'!X11","v":0},"No",{"$f":"'Quality Criteria'!Y11","v":0},{"$f":"'Quality Criteria'!AA11","v":0}]
[null,"Quality Totals (MUST EQUAL 100%)",null,null,{"$f":"SUM(E12:E15)","v":0.99999999999999989},null,null,{"$f":"SUM(H12:H15)","v":0},null,null,{"$f":"SUM(K12:K15)","v":0},null,null,{"$f":"SUM(N12:N15)","v":0},null,null,{"$f":"SUM(Q12:Q15)","v":0},null,null,{"$f":"SUM(T12:T15)","v":0},null,null,{"$f":"SUM(W12:W15)","v":0},null,null,{"$f":"SUM(Z12:Z15)","v":0}]
[null,null,null,null,null,"All quality thresholds reached?",null,{"$f":"IF(COUNTIF(F12:F15,\"No\"),\"No\", \"Yes\")","v":"No"},"All quality thresholds reached?",null,{"$f":"IF(COUNTIF(I12:I15,\"No\"),\"No\", \"Yes\")","v":"No"},"All quality thresholds reached?",null,{"$f":"IF(COUNTIF(L12:L15,\"No\"),\"No\", \"Yes\")","v":"No"},"All quality thresholds reached?",null,{"$f":"IF(COUNTIF(O12:O15,\"No\"),\"No\", \"Yes\")","v":"No"},"All quality thresholds reached?",null,{"$f":"IF(COUNTIF(R12:R15,\"No\"),\"No\", \"Yes\")","v":"No"},"All quality thresholds reached?",null,{"$f":"IF(COUNTIF(U12:U15,\"No\"),\"No\", \"Yes\")","v":"No"},"All quality thresholds reached?",null,{"$f":"IF(COUNTIF(X12:X15,\"No\"),\"No\", \"Yes\")","v":"No"}]
[null,null,null,null,null,"OVERALL QUALITY SCORE",null,{"$f":"SUM(H16)","v":0},"OVERALL QUALITY SCORE",null,{"$f":"K16","v":0},"OVERALL QUALITY SCORE",null,{"$f":"N16","v":0},"OVERALL QUALITY SCORE",null,{"$f":"Q16","v":0},"OVERALL QUALITY SCORE",null,{"$f":"T16","v":0},"OVERALL QUALITY SCORE",null,{"$f":"W16","v":0},"OVERALL QUALITY SCORE",null,{"$f":"Z16","v":0}]
[null,"PRICE SCORES"]
[null,"Tender price (whole life costs)",null,null,null,{"$f":"F10&\" price = \"","v":"Tenderer's name - 1 price = "},null,{"$f":"'Price Criteria'!E28","v":0},{"$f":"I10&\" price = \"","v":"Tenderer's name - 2 price = "},null,{"$f":"'Price Criteria'!G28","v":0},{"$f":"L10&\" price = \"","v":"Tenderer's name - 3 price = "},null,{"$f":"'Price Criteria'!I28","v":0},{"$f":"O10&\" price = \"","v":"Tenderer's name - 4 price = "},null,{"$f":"'Price Criteria'!K28","v":0},{"$f":"R10&\" price = \"","v":"Tenderer's name - 5 price = "},null,{"$f":"'Price Criteria'!M28","v":0},{"$f":"U10&\" price = \"","v":"Tenderer's name - 6 price = "},null,{"$f":"'Price Criteria'!O28","v":0},{"$f":"X10&\" price = \"","v":"Tenderer's name - 7 price = "},null,{"$f":"'Price Criteria'!Q28","v":0}]
[null,"Weighted Price score                      ",null,"Lowest Cost",{"$f":"SMALL(H20:Z20,IF(COUNTIF(H20:Z20,\">0\")=0,COUNTIF(H20:Z20,0),COUNTIF(H20:Z20,0)+1))","v":0},{"$f":"F10&\" price score =\"","v":"Tenderer's name - 1 price score ="},null,{"$f":"IF(H20=0,\"0\",(100*($E$21/H20)))","v":"0"},{"$f":"I10&\" price score =\"","v":"Tenderer's name - 2 price score ="},null,{"$f":"IF(K20=0,\"0\",(100*($E$21/K20)))","v":"0"},{"$f":"L10&\" price score =\"","v":"Tenderer's name - 3 price score ="},null,{"$f":"IF(N20=0,\"0\",(100*($E$21/N20)))","v":"0"},{"$f":"O10&\" price score =\"","v":"Tenderer's name - 4 price score ="},null,{"$f":"IF(Q20=0,\"0\",(100*($E$21/Q20)))","v":"0"},{"$f":"R10&\" price score =\"","v":"Tenderer's name - 5 price score ="},null,{"$f":"IF(T20=0,\"0\",(100*($E$21/T20)))","v":"0"},{"$f":"U10&\" price score =\"","v":"Tenderer's name - 6 price score ="},null,{"$f":"IF(W20=0,\"0\",(100*($E$21/W20)))","v":"0"},{"$f":"X10&\" price score =\"","v":"Tenderer's name - 7 price score ="},null,{"$f":"IF(Z20=0,\"0\",(100*($E$21/Z20)))","v":"0"}]
[null,"Weighted Quality Score",null,null,null,null,{"$f":"($D$8*100)&\"% x \"&TEXT(H18,\"0.0\")&\" = \"","v":"60% x 0.0 = "},{"$f":"H18*$D$8","v":0},null,{"$f":"($D$8*100)&\"% x \"&TEXT(K18,\"0.0\")&\" = \"","v":"60% x 0.0 = "},{"$f":"K18*$D$8","v":0},null,{"$f":"($D$8*100)&\"% x \"&TEXT(N18,\"0.0\")&\" = \"","v":"60% x 0.0 = "},{"$f":"N18*$D$8","v":0},null,{"$f":"($D$8*100)&\"% x \"&TEXT(Q18,\"0.0\")&\" = \"","v":"60% x 0.0 = "},{"$f":"Q18*$D$8","v":0},null,{"$f":"($D$8*100)&\"% x \"&TEXT(T18,\"0.0\")&\" = \"","v":"60% x 0.0 = "},{"$f":"T18*$D$8","v":0},null,{"$f":"($D$8*100)&\"% x \"&TEXT(W18,\"0.0\")&\" = \"","v":"60% x 0.0 = "},{"$f":"W18*$D$8","v":0},null,{"$f":"($D$8*100)&\"% x \"&TEXT(Z18,\"0.0\")&\" = \"","v":"60% x 0.0 = "},{"$f":"Z18*$D$8","v":0}]
[null,"Project price weighting x price score",null,null,null,null,{"$f":"($D$9*100)&\"% x \"&TEXT(H21,\"0.0\")&\" = \"","v":"40% x 0.0 = "},{"$f":"H21*$D$9","v":0},null,{"$f":"($D$9*100)&\"% x \"&TEXT(K21,\"0.0\")&\" = \"","v":"40% x 0.0 = "},{"$f":"K21*$D$9","v":0},null,{"$f":"($D$9*100)&\"% x \"&TEXT(N21,\"0.0\")&\" = \"","v":"40% x 0.0 = "},{"$f":"N21*$D$9","v":0},null,{"$f":"($D$9*100)&\"% x \"&TEXT(Q21,\"0.0\")&\" = \"","v":"40% x 0.0 = "},{"$f":"Q21*$D$9","v":0},null,{"$f":"($D$9*100)&\"% x \"&TEXT(T21,\"0.0\")&\" = \"","v":"40% x 0.0 = "},{"$f":"T21*$D$9","v":0},null,{"$f":"($D$9*100)&\"% x \"&TEXT(W21,\"0.0\")&\" = \"","v":"40% x 0.0 = "},{"$f":"W21*$D$9","v":0},null,{"$f":"($D$9*100)&\"% x \"&TEXT(Z21,\"0.0\")&\" = \"","v":"40% x 0.0 = "},{"$f":"Z21*$D$9","v":0}]
[null,"Overall score",null,null,null,null,null,{"$f":"H23+H22","v":0},null,null,{"$f":"K23+K22","v":0},null,null,{"$f":"N23+N22","v":0},null,null,{"$f":"Q22+Q23","v":0},null,null,{"$f":"T22+T23","v":0},null,null,{"$f":"W22+W23","v":0},null,null,{"$f":"Z22+Z23","v":0}]
[null,"Order of tenders (ranking)",null,null,null,null,null,{"$f":"IF(H17=\"YES\",RANK(H26,$H$26:$Z$26),\"N/A\")","v":"N/A"},null,null,{"$f":"IF(K17=\"YES\",RANK(K26,$H$26:$Z$26),\"N/A\")","v":"N/A"},null,null,{"$f":"IF(N17=\"YES\",RANK(N26,$H$26:$Z$26),\"N/A\")","v":"N/A"},null,null,{"$f":"IF(Q17=\"YES\",RANK(Q26,$H$26:$Z$26),\"N/A\")","v":"N/A"},null,null,{"$f":"IF(T17=\"YES\",RANK(T26,$H$26:$Z$26),\"N/A\")","v":"N/A"},null,null,{"$f":"IF(W17=\"YES\",RANK(W26,$H$26:$Z$26),\"N/A\")","v":"N/A"},null,null,{"$f":"IF(Z17=\"YES\",RANK(Z26,$H$26:$Z$26),\"N/A\")","v":"N/A"}]
[null,null,null,null,null,null,null,{"$f":"IF(H17=\"YES\",H24,0)","v":0},null,null,{"$f":"IF(K17=\"YES\",K24,0)","v":0},null,null,{"$f":"IF(N17=\"YES\",N24,0)","v":0},null,null,{"$f":"IF(Q17=\"YES\",Q24,0)","v":0},null,null,{"$f":"IF(T17=\"YES\",T24,0)","v":0},null,null,{"$f":"IF(W17=\"YES\",W24,0)","v":0},null,null,{"$f":"IF(Z17=\"YES\",Z24,0)","v":0}]
[null,"Comments",null,null,null,{"$f":"IF(H17=\"No\",\"This tender does not meet at least one quality threshold\",\"\")","v":"This tender does not meet at least one quality threshold"},null,null,{"$f":"IF(K17=\"No\",\"This tender does not meet at least one quality threshold\",\"\")","v":"This tender does not meet at least one quality threshold"},null,null,{"$f":"IF(N17=\"No\",\"This tender does not meet at least one quality threshold\",\"\")","v":"This tender does not meet at least one quality threshold"},null,null,{"$f":"IF(Q17=\"No\",\"This tender does not meet at least one quality threshold\",\"\")","v":"This tender does not meet at least one quality threshold"},null,null,{"$f":"IF(T17=\"No\",\"This tender does not meet at least one quality threshold\",\"\")","v":"This tender does not meet at least one quality threshold"},null,null,{"$f":"IF(W17=\"No\",\"This tender does not meet at least one quality threshold\",\"\")","v":"This tender does not meet at least one quality threshold"},null,null,{"$f":"IF(Z17=\"No\",\"This tender does not meet at least one quality threshold\",\"\")","v":"This tender does not meet at least one quality threshold"}]
[]
[]
[]
[null,null,null,{"$f":"COUNTIF(H20:Z20,\">0\")","v":0}]
[]
[null,"N.B. The scoring methodology for Quality built into this matix is 0-4, if you decide to use another scale the formula in cells G16 to G22 for   "]
[null,"Tender 1 and the equivilent cells for all other tenders must be amended accordingly. "]
[]
[null,"The Evaluation Matrix pricing is scored relatively to the best price whereas quality is scored individually i.e. not relatively."]

{"sheet":"Summary ","index":6,"n_rows":8,"n_cols":10,"rows_kept":8,"cut":false,"hidden":false,"merged":[[3,1,3,2],[1,1,1,2]]}
[]
[null,"Summary of Decision Making "]
[]
[null,"Quality Criteria",null,{"$f":"Instructions!E4","v":"Tenderer's name - 1"},{"$f":"Instructions!E5","v":"Tenderer's name - 2"},{"$f":"Instructions!E6","v":"Tenderer's name - 3"},{"$f":"Instructions!E7","v":"Tenderer's name - 4"},{"$f":"Instructions!E8","v":"Tenderer's name - 5"},{"$f":"Instructions!E9","v":"Tenderer's name - 6"},{"$f":"Instructions!E10","v":"Tenderer's name - 7"}]
[null,"Methodology","The tenderer should demonstrate their understanding of the aims of the peatland restoration on this site and the techniques specificed, as well as their ability to work practically and sensiitively on peatland sites."]
[null,"Experience ","The tenderer should demonstrate relevant knowledge, skills and any comparable of the project team (especially machine operators) proposed to the carry out the works)"]
[null,"Timescales","The tenderer should demonstrate an ability to adhere to the agreed timetable for delivery and manage any risk to that delivery timescale"]
[null,"Sustainability ","The tenderer should carry out the project in a manner that avoids or minimises negative impacts on the environment, supports sustainability, fari working practices and the local economy and community "]

{"sheet":"Sheet1","index":7,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}