{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["LPC"],"not_rendered":{"charts":0,"images":3,"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":"LPC","index":0,"n_rows":32,"n_cols":23,"rows_kept":32,"cut":false,"hidden":false,"merged":[[24,1,24,2],[23,1,23,2],[23,14,23,15],[29,14,29,15],[30,14,30,15],[19,1,19,2],[23,3,23,4],[23,5,23,6],[23,7,23,8],[22,5,22,6],[22,7,22,8],[22,3,22,4],[26,14,26,15],[25,14,25,15],[24,14,24,15],[24,3,24,4],[28,14,28,15],[24,7,24,8],[24,5,24,6],[22,1,22,2],[4,1,4,4],[18,1,18,2],[17,1,17,2],[14,13,14,18],[8,0,8,2],[14,3,14,8],[5,5,5,7],[6,5,6,7],[7,1,7,2],[14,0,14,2],[10,0,10,2],[11,0,11,2],[12,0,12,2],[15,1,15,2],[16,1,16,2],[31,0,32,18],[21,1,21,8],[7,5,7,8],[4,13,6,18],[0,15,1,18],[2,15,2,18],[0,4,1,14],[0,0,2,3],[5,1,5,2],[4,5,4,7],[8,3,8,8],[9,1,9,2],[21,14,21,15],[20,16,20,18],[27,14,27,15],[22,14,22,15]]}
[" ",null,null,null,"Lowest Price Conforming Method ",null,null,null,null,null,null,null,null,null,null,"Appendix VII"]
[]
[null,null,null,null,null,"Physical Works",null,"Professional Services",null,null,null,null,null,null,null,"  Form J"]
[]
["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 Prices 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 Price Evaluation",null,null,"Price (Lowest to highest price)"]
[null,"Tenderer"]
["Tender Price"]
["Less all Schedule Fixed Amounts",null,null,{"$f":"IF(D16=\"\",\"\",$I$6)","v":""},"","","","",""]
["Evaluation Price",null,null,{"$f":"IF(D16=\"\",\"\",D11-D12)","v":""},"","","","",""]
[]
["ENVELOPE 2 Non-Price Evaluation",null,null,"Non-Price Tenderers Grades ( Pass / Fail)"]
["Weighting","Tenderer",null,{"$f":"IF(D10=\"\",\"\",D10)","v":""},{"$f":"IF(E10=\"\",\"\",E10)","v":""},"","","","",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J16=\"\",\"\",J16)","v":""},{"$f":"IF(K16=\"\",\"\",K16)","v":""},{"$f":"IF(L16=\"\",\"\",L16)","v":""},{"$f":"IF(M16=\"\",\"\",M16)","v":""}]
["P/F","Relevant Experience",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J$16=\"\",\"\",$A17*J17)","v":""},"","",""]
["P/F","Track Record",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",""]
["P/F","Relevant Skills",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",""]
["P/F","Methodology",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tenderer's Full Name"]
[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(D10=\"\",\"\",D10)","v":""}]
["TET Signature",null,null,null,null,null,null,null,null,{"$f":"IF(J16=\"\",\"\",$I$6)","v":""},{"$f":"IF(K16=\"\",\"\",$I$6)","v":""},{"$f":"IF(L16=\"\",\"\",$I$6)","v":""},{"$f":"IF(M16=\"\",\"\",$I$6)","v":""},null,{"$f":"IF(E10=\"\",\"\",E10)","v":""}]
["Date",null,null,null,null,null,null,null,null,{"$f":"IF(J16=\"\",\"\",J22-J23)","v":""},{"$f":"IF(K16=\"\",\"\",K22-K23)","v":""},{"$f":"IF(L16=\"\",\"\",L22-L23)","v":""},{"$f":"IF(M16=\"\",\"\",M22-M23)","v":""},null,{"$f":"IF(F10=\"\",\"\",F10)","v":""}]
["TET Name",null,null,null,null,null,null,null,null,{"$f":"IF(J16=\"\",\"\",J24-#REF!)","v":""},{"$f":"IF(K16=\"\",\"\",K24-#REF!)","v":""},{"$f":"IF(L16=\"\",\"\",L24-#REF!)","v":""},{"$f":"IF(M16=\"\",\"\",M24-#REF!)","v":""},null,{"$f":"IF(G10=\"\",\"\",G10)","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(J25=MIN($J$25:$M$25),\"Lowest\",\"\")","v":""},{"$f":"IF(K25=MIN($J$25:$M$25),\"Lowest\",\"\")","v":""},{"$f":"IF(L25=MIN($J$25:$M$25),\"Lowest\",\"\")","v":""},{"$f":"IF(M25=MIN($J$25:$M$25),\"Lowest\",\"\")","v":""},null,{"$f":"IF(H10=\"\",\"\",H10)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I10=\"\",\"\",I10)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J16=\"\",\"\",J16)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K16=\"\",\"\",K16)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L16=\"\",\"\",L16)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M16=\"\",\"\",M16)","v":""}]
["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."]