ࡱ> QP ZO\pJohn, Hedd Wyn J Ba== Q,8X@"1Arial1Arial1Arial1Arial1QTahoma1QTahoma1Arial1Arial1Arial1Arial1Calibri1 Calibri1Calibri14Calibri1 Calibri1Calibri1Arial1Calibri1,8Calibri18Calibri18Calibri1 Arial1>Calibri14Calibri1<Calibri1?Calibri1h8Cambria1Calibri1 Calibri1Arial""#,##0;\-""#,##0""#,##0;[Red]\-""#,##0""#,##0.00;\-""#,##0.00#""#,##0.00;[Red]\-""#,##0.005*0_-""* #,##0_-;\-""* #,##0_-;_-""* "-"_-;_-@_-,)'_-* #,##0_-;\-* #,##0_-;_-* "-"_-;_-@_-=,8_-""* #,##0.00_-;\-""* #,##0.00_-;_-""* "-"??_-;_-@_-4+/_-* #,##0.00_-;\-* #,##0.00_-;_-* "-"??_-;_-@_-0.0 ""#,##0.00 ""#,##0"Yes";"Yes";"No""True";"True";"False""On";"On";"Off"],[$ -2]\ #,##0.00_);[Red]\([$ -2]\ #,##0.00\)                                                                      ff + ) , *      P  P         `            a>        "   (@ @   (@@   (@   ( @   (@@   ( @   (@   (   (   (@   (@   (   (@ @   (@  (@@  (@  "8  "8  (@   ,   , "8@ @  "8@ @  "<@ @  "<@ @   (@  "8@  "8@   , @  "<@ @    "<@ @  "  "  "  "  "<@@  "<@  "< @  "<@ @  "<@@  "<@  "8  "8@  "8  "<@@  "<@  "<@ @ "8@@ "8@ "8 @ "8@ @  "< @  "8@ @  "<@  "<  "< @  "<@ @  "<  "<@ ||*T}A} 00_)ef[$ -}A} 00_)ef[$ -}A} 00_)ef[$ -}A} 00_)ef[$ -}A} 00_)ef[$ -}A} 00_)ef [$ -}A} 00_)L[$ -}A} 00_)L[$ -}A} 00_)L[$ -}A} 00_)L[$ -}A} 00_)L[$ -}A} 00_)L [$ -}A} 00_)23[$ -}A} 00_)23[$ -}A} 00_)23[$ -}A} 00_)23[$ -}A}  00_)23[$ -}A}! 00_)23 [$ -}A}" 00_)[$ -}A}# 00_)[$ -}A}$ 00_)[$ -}A}% 00_)[$ -}A}& 00_)[$ -}A}' 00_) [$ -}A}( 00_)[$ -}}) }00_)[$ -##0.  }}* 00_)[$ -???##0.??? ??? ???}-}/ 00_)}(}0  00_)}A}1 a00_)[$ -}A}2 00_)[$ -}A}3 00_)?[$ -}A}4 00_)23[$ -}-}5 00_)}(}6  00_)}}7 ??v00_)̙[$ -##0.  }A}8 }00_)[$ -}A}9 e00_)[$ -}x}:00_)[$##  }}; ???00_)[$???## ???  ??? ???}-}= 00_)}U}> 00_)[$## }-}? 00_)}(}a 00_) 20% - Accent1M 20% - Accent1 ef % 20% - Accent2M" 20% - Accent2 ef % 20% - Accent3M& 20% - Accent3 ef % 20% - Accent4M* 20% - Accent4 ef % 20% - Accent5M. 20% - Accent5 ef % 20% - Accent6M2 20% - Accent6  ef % 40% - Accent1M 40% - Accent1 L % 40% - Accent2M# 40% - Accent2 L渷 % 40% - Accent3M' 40% - Accent3 L % 40% - Accent4M+ 40% - Accent4 L % 40% - Accent5M/ 40% - Accent5 L % 40% - Accent6M3 40% - Accent6  Lմ % 60% - Accent1M 60% - Accent1 23 % 60% - Accent2M$ 60% - Accent2 23ږ % 60% - Accent3M( 60% - Accent3 23כ % 60% - Accent4M, 60% - Accent4 23 % 60% - Accent5M0 60% - Accent5 23 %! 60% - Accent6M4 60% - Accent6  23 % "Accent1AAccent1 O % #Accent2A!Accent2 PM % $Accent3A%Accent3 Y % %Accent4A)Accent4 d % &Accent5A-Accent5 K % 'Accent6A1Accent6  F %(Bad9Bad  %) Calculation Calculation  }% * Check Cell Check Cell  %????????? ???+ Comma,( Comma [0]-&Currency.. Currency [0]/Explanatory TextG5Explanatory Text %0 F Followed Hyperlink   1Good;Good  a%2 Heading 1G Heading 1 I}%O3 Heading 2G Heading 2 I}%?4 Heading 3G Heading 3 I}%235 Heading 49 Heading 4 I}%64 Hyperlink   7InputuInput ̙ ??v% 8 Linked CellK Linked Cell }% 9NeutralANeutral  e%"Normal :Noteb Note   ;OutputwOutput  ???%????????? ???<$Percent =Title1Title I}% >TotalMTotal %OO? Warning Text? Warning Text %XTableStyleMedium2PivotStyleLight16`F Tender Result,5fnfX8@jb(1)k3  @@  +(CriteriaScore*Quality points as a % of the highest scoreQuality Scores Price ScoresTotal tender price!Price point (lowest/actual x 100)Overall Scores Overall scoreOrder of tendersTotalsDecide upon criteraQGive each criteria a weighting dependent upon level of importance (see (a) below)dGive each supplier a score for each criteria dependent upon your view of their offer (see (b) below)>Calculate the weighted score for each supplier (see [c] below)QGive the supplier with the highest score a "points" figure of 100 (see (d) below)1List the different prices offered (see (f) below)QGive the supplier with the highest score a "points" figure of 100 (see (g) below)!Quality score x quality weightingPrice score x price weighting 0Calculate weighted quality score (see (i) below).Calculate weighted price score (see (j) below)YAdd together total weighted quality score plus total weighted price score (see (k) below)3Highest score is the winning offer (see (l) below) XCalculate the scores for the other suppliers as a % of the highest score (see (e) below)XCalculate the scores for the other suppliers as a % of the highest score (see (h) below)Quality (40% weighting)Price (60% weighting)Gwalia1st 2ndPart a)part c)PassPart b)1stPresentation & Interview Provider A Provider BExample Tender - Scoring Matrix*h3 45Hg7 o8cc PK![Content_Types].xmlN0EH-J@%ǎǢ|ș$زULTB l,3;rØJB+$G]7O٭Vނβ5qx\P s6*+FC]\dzS\1 f˜!(B: Q}qCZ2 %u?E+zo^ͫɛW/_/hyB'~oӯ>O~ߌWu?/f fJ__ꏿ?iߗ0ç,OȱHQ7k_r:o7cf@Ht_o ogG'$ 8?NRx(hdžWE73:ഉ2ϵEU JÄzbq44o>d̳! Pbɇ 5df^ &=d)e٤3ڳ32Iz#1!7?3XhHHN!u?4 9Yʰ))dQUPDnx ۍ*{ڒю!pUf;w a6B][ۊfǭR٘j8XY;Zy5wtuH%GFuXYS/Z[א}nWqR]g{2W^Bjӑg9݀9n14cаE^ jRc0`R}ڈ{-JXh*'ItFf|!oB[ kO~q.~(fqnx@QnM U2طx[VWŦ5R3UzG;@ɔ~ NV@MNO@]M@  Ba MKKKKKMN]B D EEED'Eb@ "DDDD!F`@ DD!Ya@ DD BMKKKKKMN]B MKKKK%VY@ &DDdD%_X@&DDd%[Y@&DDd BMKKKKVMW]B U K KKKVMW]B B X(b^^X\ -!-"-#-$-%-&-'-(-)-*- MKKKKKMN]B !D !EEF~ !p@!q~ !r@!r~ !bzA! B ! dc !dc !dc !dc "C "CCC%"gb@ 'D!D!d"h%"iY@'D!D!d"j%"`qqS@'D!D!d" B " ee "ee "ee "ee#MKKKKKKN]B $U$KKKKKKN]B %MKKKKKKN]B &O &OGH &kD@ " D(&l &{C@) D(&| &ZD@ D(& B & cc &cc &cc &cc 'P 'PIJ 'yV@  D"<'z '}N@ D"<'~ '`VUUUUUG@" D"< ' ff 'ff 'ff 'ff(MKKKKKKN]B )D )EEF#)g@`@ ) %&(,/)h#)wZZZZZX@) %&(,/)x!)`U@pV D&D') B ) ff )ff )ff )ff *D *EEF *s*t *u#*v *X* B * cc *cc *cc *ccF*j (   x  6ȜWXPP?  $+]4@  IM7]t <(f) <  xx  6WXPP? + ]4@ 9jIXG&SX <(f) < xx  68WXPP? (+]4@ Ae4OͫSX <(k) <  xx  6hWXPP? ! %U]4@ }YJDX <(k) < xx  6(WXPP? )-+]4@ kJ @(&3 |X <(l) <  tixx  6WXPP? " &k]4@ Sitq@^_(axX <(l) <  ?xx & 6HWXPP? !%U]4&@ 蚤QnIyX 8<9(g) best price is given 100 points; lowest/actual x 100 <7 8 xx ' 6WXPP?  ]4'@ FK:G:X 8<9(g) best price is given 100 points; lowest/actual x 100 <37 8 xx ) 6xWXPP? %(]4)@ ifJAYX 8<9(i) quality score of ?? x 40% overall quality weighting <7 8xx * 6XWXPP?  "]4*@ `TOFE X 8<9(i) quality score of ?? x 40% overall quality weighting <.7 8xx , 6WXPP? &*]4,@ 3XG \;AX 8<9(g) best price is given 100 points; lowest/actual x 100 <7 8 xx - 6WXPP?  5 $K]4-@ 9^@Kf X 8<9(g) best price is given 100 points; lowest/actual x 100 <37 8 xx h 6șWXPP? & U*]4h@ X-^Ccy X 8<9(g) best price is given 100 points; lowest/actual x 100 <37 8 !rmalcolm!rmalcolm"&rmalcolm"'rmalcolm&)rmalcolm&*rmalcolm',rmalcolm'-rmalcolm'hrmalcolm)rmalcolm)rmalcolm*rmalcolm*rmalcolm>@lcjc R*****))))''&&''""""&&!!!!))** !! "" && '' )) ""&&''))** !!""&&''**!!""&&''))**!!7ggD Oh+'0HPd  rmalcolmJohn, Hedd Wyn JMicrosoft Excel@5gf@<@3H ՜.+,0 PX|  Vale of Glamorgan Council Tender Result  Worksheets  !"#$%&'()*+,-./0123456789:;<=>?ABCDEFGIJKLMNORoot Entry F`L.KWorkbook ~SummaryInformation(@DocumentSummaryInformation8H