{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Brook's Law"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":1,"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":"Brook's Law","index":0,"n_rows":39,"n_cols":23,"rows_kept":39,"cut":false,"hidden":false,"merged":[[2,4,2,14],[38,0,39,18],[31,14,31,15],[32,14,32,15],[33,14,33,15],[35,5,35,6],[35,7,35,8],[17,4,17,5],[19,13,19,18],[22,13,22,14],[20,13,20,14],[20,7,20,8],[30,14,30,15],[4,5,4,7],[5,5,5,7],[6,5,6,7],[4,1,4,4],[27,0,27,2],[25,0,25,2],[26,0,26,2],[7,1,7,2],[8,0,8,2],[24,0,24,2],[12,1,12,2],[11,1,11,2],[21,3,21,4],[14,0,14,2],[15,0,15,2],[20,3,20,4],[37,5,37,6],[36,1,36,2],[36,3,36,4],[36,5,36,6],[35,1,35,2],[37,1,37,2],[4,13,6,18],[0,15,1,18],[37,13,37,14],[37,15,37,18],[24,14,24,15],[2,15,2,18],[0,4,1,14],[35,3,35,4],[36,15,36,18],[37,7,37,8],[36,7,36,8],[36,13,36,14],[0,0,2,3],[5,1,5,2],[19,1,19,8],[37,3,37,4],[8,13,8,18],[21,1,21,2],[22,1,22,2],[22,3,22,4],[22,5,22,6],[10,1,10,2],[9,1,9,2],[22,7,22,8],[21,7,21,8],[20,15,20,18],[21,15,21,18],[22,15,22,18],[21,13,21,14],[21,5,21,6],[7,5,7,8],[17,0,17,2],[20,1,20,2],[8,3,8,8],[16,0,16,1],[13,1,13,2],[20,5,20,6],[34,14,34,15],[17,6,17,7],[35,14,35,15],[15,13,15,18],[23,0,23,4],[23,13,23,14],[29,14,29,15],[28,14,28,15],[27,14,27,15],[26,14,26,15],[23,15,23,18],[25,16,25,18],[25,14,25,15],[24,16,24,18],[34,1,34,8]]}
[" ",null,null,null,"Brook's Law Method",null,null,null,null,null,null,null,null,null,null,"Appendix VII"]
[]
[null,null,null,null,"Professional Services",null,null,null,null,null,null,null,null,null,null,"  Form I"]
[]
["Contract For:",null,null,null,null,"Base Estimate (1)",null,null,null,null,null,null,null,"Remove Provisional Sums (or any other Schedule fixed amounts in the RFT) from the Tender Price and Estimate"]
["Contract No:",null,null,null,null,"Less all Schedule Fixed Amounts"]
["Date:",null,null,null,null,"Evaluation Estimate",null,null,{"$f":"IF(I5=\"\",\"\",I5-I6)","v":""}]
[null,null,null,null,null,"Please fill in the green fields only"]
["ENVELOPE 1 Non-Price Evaluation",null,null,"Non-Price Tenderers Grades ",null,null,null,null,null,null,null,null,null,"Tenderers Indices (Grade x Weighting)"]
["Weighting","Tenderer",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D10=\"\",\"\",D10)","v":""},"","","","","",{"$f":"IF(J10=\"\",\"\",J10)","v":""},{"$f":"IF(K10=\"\",\"\",K10)","v":""},{"$f":"IF(L10=\"\",\"\",L10)","v":""},{"$f":"IF(M10=\"\",\"\",M10)","v":""}]
[null,"Relevant Experience",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D$10=\"\",\"\",$A11*D11)","v":""},"","","","","",{"$f":"IF(J$10=\"\",\"\",$A11*J11)","v":""},"","",""]
[null,"Track Record",null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","",""]
[null,"Relevant Skills",null,null,null,null,null,null,null,null,null,null,null,"","","","","",{"$f":"IF(I$10=\"\",\"\",$A13*I13)","v":""},"","","",""]
[null,"Methodology",null,null,null,null,null,null,null,null,null,null,null,"","","","","",{"$f":"IF(I$10=\"\",\"\",$A14*I14)","v":""},"","","",""]
["Non-Priced Attributes Weighted Sum",null,null,{"$f":"IF(D10=\"\",\"\",N15)","v":""},"","","","","","","","","",{"$f":"IF(D10=\"\",\"\",SUM(N11:N14))","v":""},"","","","","","","","",""]
["Final (Manual) Adjusted Weighted Sum",null,null,{"$f":"D15","v":""},{"$f":"E15","v":""},null,null,null,null," "," "," "," ","May not be altered once price envelope is opened",null,null,null,null,null,{"$f":"IF(J11=\"\",\"\",SUM(T12:T15))","v":""},{"$f":"IF(K11=\"\",\"\",SUM(U12:U15))","v":""},{"$f":"IF(L11=\"\",\"\",SUM(V12:V15))","v":""},{"$f":"IF(M11=\"\",\"\",SUM(W12:W15))","v":""}]
[null,null,null,null,null,{"$f":"SUM(F11:F14)","v":0},0,0,0,0,0,0,0]
["Highest Overall (Adjusted) Weighted Sum",null,null,{"$f":"IF(D10=\"\",\"\",MAX(D16:M16))","v":""},"Name of preferred tenderer"]
[]
[null,"TET's agreement on the calculated or adjusted Weighted Sum, and calculations verified correct:",null,null,null,null,null,null,null,null,null,null,null,"Authorisation to open price envelope:"]
["TET Signature",null,null,null,null,null,null,null,null,null,null,null,null,"Signature"]
["Date",null,null,null,null,null,null,null,null,null,null,null,null,"Date"]
["TET Name",null,null,null,null,null,null,null,null,null,null,null,null,"Delegated Authority"]
["ENVELOPE 2  Price of Highest Overall Weighted Sum Tender",null,null,null,null,null,null,null,null,null,null,null,null,"Preferred Tenderer Name",null,{"$f":"G18","v":0}]
["Tender Price of Highest Overall Weighted Sum Tender",null,null,0,0,null,null,null,null,null,null,0]
["Less all Schedule Fixed Amounts",null,null,{"$f":"IF(D10=\"\",\"\",$I$6)","v":""},"","","","","","","","","",null,{"$f":"IF(E10=\"\",\"\",E10)","v":""},null,"Tenderer Full Name"]
["Price for Negotiation",null,null,{"$f":"IF(D10=\"\",\"\",D25-D26)","v":""},"","","","","","","","","",null,{"$f":"IF(D10=\"\",\"\",D10)","v":""}]
["Adjusted (Manual) Evaluation Price",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E10=\"\",\"\",E10)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F10=\"\",\"\",F10)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G10=\"\",\"\",G10)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J10=\"\",\"\",J10)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K10=\"\",\"\",K10)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L10=\"\",\"\",L10)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M10=\"\",\"\",M10)","v":""}]
[null,"The assessment above reflects the evaluation of the TET. All TET members have completed and signed appendix IX – Potential Conflict of Interest/Bias Declaration:",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(H10=\"\",\"\",H10)","v":""}]
["TET Signature",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I10=\"\",\"\",I10)","v":""}]
["Date"]
["TET Name"]
["Note: This spreadsheet allows up to 10 tenderers to be evaluated. First unprotect the worksheet by selecting \"Tools\", \"Protection\", \"Unprotect\". Highlight column I and N, and select \"Unhide\". Repeat the same for Column S and X, and row 35 and 40.                           (1)  Refer to Terminology Section of SM021 for definition of Base Estimate."]