{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Bid Summary","Bid Worksheet","Sheet3"],"not_rendered":{"images":1,"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"Bid Summary","index":0,"n_rows":35,"n_cols":5,"rows_kept":35,"merged":[[0,1,0,5],[1,3,1,5],[2,3,2,5]]}
[]
[null,"Bid Evaluation for:"]
[null,{"$f":"TODAY()","v":"2011-07-05"},"By:"]
[null,"Bidder",null,"Price Rank","Overall Rank"]
[null,{"$f":"'Bid Worksheet'!C18","v":"Bidder 1"},null,{"$f":"RANK","v":2},{"$f":"'Bid Worksheet'!D35","v":3}]
[null,{"$f":"'Bid Worksheet'!E18","v":"Bidder 2"},null,{"$f":"'Bid Worksheet'!E21","v":3},{"$f":"'Bid Worksheet'!F35","v":4}]
[null,{"$f":"'Bid Worksheet'!G18","v":"Bidder 3"},null,{"$f":"'Bid Worksheet'!G21","v":1},{"$f":"'Bid Worksheet'!H35","v":1}]
[null,{"$f":"'Bid Worksheet'!I18","v":"Bidder 4"},null,{"$f":"'Bid Worksheet'!I21","v":4},{"$f":"'Bid Worksheet'!J35","v":2}]
[null,{"$f":"'Bid Worksheet'!K18","v":"Bidder 5"},null,{"$f":"'Bid Worksheet'!K21","v":{"$error":"#N/A"}},{"$f":"'Bid Worksheet'!L35","v":0}]
[null,{"$f":"'Bid Worksheet'!M18","v":"Bidder 6"},null,{"$f":"'Bid Worksheet'!M21","v":{"$error":"#N/A"}},{"$f":"'Bid Worksheet'!N35","v":0}]
{"$rows_empty":24}
["Password = Vikings"]

{"sheet":"Bid Worksheet","index":1,"n_rows":35,"n_cols":16,"rows_kept":35,"merged":[[5,1,5,8],[19,3,21,3],[19,5,21,5],[19,7,21,7],[19,9,21,9],[19,11,21,11],[19,13,21,13]]}
[]
["Instructions: Complete YELLOW cells"]
[1,"Determine importance of Price in overall bid and put as % in cell O:21"]
[2,"Bid Criteria should match what is in RFP"]
[3,"Determine importance of each non price criteria in relation to rank , % of total bid will auto calculate"]
[4,"Bid Price - prices should reflect the whole life cost of the purchase where possible.  In all cases the prices entered in the template must represent a ‘like for like’ comparison between bidders."]
[5,"Use the following guide when ranking quality and technical criteria"]
[null,"Scoring Rationale:","0= no submission/submission not relevant"]
[null,null,"1= submission partially relevant but poor"]
[null,null,"2= submission partially relevant and acceptable"]
[null,null,"3= submission completely relevant and acceptable"]
[null,null,"4= submission completely relevant and good"]
[null,null,"5= submission completely relevant and exceptional"]
[6,"For more than 4 bidders edit formula in D:35 to include the addional array and copy paste across all bidders."]
[]
[]
[]
[null,"Cost","Bidder 1",null,"Bidder 2",null,"Bidder 3",null,"Bidder 4",null,"Bidder 5",null,"Bidder 6",null,"Lowest Cost"]
["C-1","Bid Price",115,null,120,null,110,null,122,{"$nulls":5},{"$f":"SMALL(C19:M19,1)","v":110}]
[null,"% Variance",{"$f":"100%-($O$19/C$19)","v":{"v":0.04347826086956519,"d":"4.35%"}},null,{"$f":"100%-($O$19/E$19)","v":{"v":0.08333333333333337,"d":"8.33%"}},null,{"$f":"100%-($O$19/G$19)","v":{"v":0,"d":"0.00%"}},null,{"$f":"100%-($O$19/I$19)","v":{"v":0.09836065573770492,"d":"9.84%"}},null,{"$f":"100%-($O$19/K$19)","v":{"$error":"#DIV/0!"}},null,{"$f":"100%-($O$19/M$19)","v":{"$error":"#DIV/0!"}},null,"Weight as % of total"]
[null,"Rank by Price",{"$f":"RANK(C$19,$C$19:$M$19,1)","v":2},null,{"$f":"RANK(E$19,$C$19:$M$19,1)","v":3},null,{"$f":"RANK(G$19,$C$19:$M$19,1)","v":1},null,{"$f":"RANK(I$19,$C$19:$M$19,1)","v":4},null,{"$f":"RANK(K$19,$C$19:$M$19,1)","v":{"$error":"#N/A"}},null,{"$f":"RANK(M$19,$C$19:$M$19,1)","v":{"$error":"#N/A"}},null,{"v":0.5,"d":"50%"}]
[null,"Quality and Technical",{"$nulls":12},"Weight (% of importance) does not have to =100%","MAX"]
["C-2","Spec 1",5,{"$f":"C23*$O23","v":{"v":5,"d":"5.0"}},5,{"$f":"E23*$O23","v":5},5,{"$f":"G23*$O23","v":5},5,{"$f":"I23*$O23","v":5},null,{"$f":"K23*$O23","v":0},null,{"$f":"M23*$O23","v":0},{"v":1,"d":"100%"},{"$f":"5*O23","v":5}]
["C-3","Spec 2",4,{"v":4,"d":"4.0"},4,4,4,{"$f":"G24*$O24","v":4},5,{"$f":"I24*$O24","v":5},null,{"$f":"K24*$O24","v":0},null,{"$f":"M24*$O24","v":0},{"v":1,"d":"100%"},5]
["C-4","Spec 3",5,{"v":3.75,"d":"3.8"},5,3.75,5,{"$f":"G25*$O25","v":3.75},5,{"$f":"I25*$O25","v":3.75},null,{"$f":"K25*$O25","v":0},null,{"$f":"M25*$O25","v":0},{"v":0.75,"d":"75%"},3.75]
["C-5","Spec 4",4,{"v":3,"d":"3.0"},4,3,4,{"$f":"G26*$O26","v":3},5,{"$f":"I26*$O26","v":3.75},null,{"$f":"K26*$O26","v":0},null,{"$f":"M26*$O26","v":0},{"v":0.75,"d":"75%"},3.75]
["C-6","Spec 5",5,{"v":3.75,"d":"3.8"},5,3.75,5,{"$f":"G27*$O27","v":3.75},5,{"$f":"I27*$O27","v":3.75},null,{"$f":"K27*$O27","v":0},null,{"$f":"M27*$O27","v":0},{"v":0.75,"d":"75%"},3.75]
["C-7","Spec 6",5,2.5,5,2.5,5,{"$f":"G28*$O28","v":2.5},5,{"$f":"I28*$O28","v":2.5},null,{"$f":"K28*$O28","v":0},null,{"$f":"M28*$O28","v":0},{"v":0.5,"d":"50%"},2.5]
["C-8","Spec 7",4,{"v":2,"d":"2.0"},4,2,4,{"$f":"G29*$O29","v":2},5,{"$f":"I29*$O29","v":2.5},null,{"$f":"K29*$O29","v":0},null,{"$f":"M29*$O29","v":0},{"v":0.5,"d":"50%"},2.5]
["C-9","Spec 8",5,0.5,5,0.5,5,{"$f":"G30*$O30","v":0.5},5,{"$f":"I30*$O30","v":0.5},null,{"$f":"K30*$O30","v":0},null,{"$f":"M30*$O30","v":0},{"v":0.1,"d":"10%"},0.5]
["C-10","Spec 9",5,0.5,5,0.5,5,{"$f":"G31*$O31","v":0.5},5,{"$f":"I31*$O31","v":0.5},null,{"$f":"K31*$O31","v":0},null,{"$f":"M31*$O31","v":0},{"v":0.1,"d":"10%"},0.5]
[null,"Quality and Technical Score",null,{"$f":"(SUM(D23:D31)+(SUM(D23:D31)*$P$33))*$O$32","v":{"v":20.642201834862384,"d":"20.6"}},null,{"$f":"(SUM(F23:F31)+(SUM(F23:F31)*$P$33))*$O$32","v":20.642201834862384},null,20.642201834862384,null,22.5,null,0,null,0,{"$f":"100%-$O$21","v":{"v":0.5,"d":"50%"}},{"$f":"SUM(P23:P31)","v":27.25}]
[null,"Price (weighted score)",null,{"$f":"$O$33-($O$33*C20)","v":{"v":21.521739130434785,"d":"21.5"}},null,{"$f":"$O$33-($O$33*E20)","v":{"v":20.625,"d":"20.63"}},null,{"$f":"$O$33-($O$33*G20)","v":{"v":22.5,"d":"22.50"}},null,{"$f":"$O$33-($O$33*I20)","v":{"v":20.28688524590164,"d":"20.29"}},null,{"$f":"$O$33-($O$33*K20)","v":{"$error":"#DIV/0!"}},null,{"$f":"$O$33-($O$33*M20)","v":{"$error":"#DIV/0!"}},{"$f":"(COUNTIF(B23:B31,\">{}\")*5)*O21","v":22.5},{"$f":"(45-P32)/P32","v":{"v":0.6513761467889908,"d":"65.14%"}}]
[null,"Overall Weighted Score",null,{"$f":"SUM(D32:D33)","v":{"v":42.16394096529717,"d":"42.2"}},null,{"$f":"SUM(F32:F33)","v":{"v":41.267201834862384,"d":"41.27"}},null,{"v":43.142201834862384,"d":"43.14"},null,{"v":42.786885245901644,"d":"42.79"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[null,"Overall Rank",null,{"$f":"RANK(D34,$D34:$J34,)","v":3},null,{"$f":"RANK(F34,$D34:$J34,)","v":4},null,{"$f":"RANK(H34,$D34:$J34,)","v":1},null,{"$f":"RANK(J34,$D34:$J34,)","v":2}]

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0}