Spreadsheet: 85115d1285176397-how-to-leave-some-cells-unlocked-in-protected-sheet-contractor-evaluation-7july10
Sheet: weighting

Contractor Performance Evaluation Pairwise Matrix |  |  |  |  |  | 1 | slightly more important
 |  |  |  |  |  | 2 | more important
 |  |  |  |  |  | 3 | much more important |  |  |  |  |  |  |  | TOTALS | subweight | total weight | %
SAFETY STANDARDS AND REGULATIONS |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.2608695652173913 |  |  |  | 0.2608695652173913
 |  |  |  |  |  | A | B | C
Did the contractor comply with OHSA requirements? |  |  |  |  | A |  | A | A2 |  |  |  |  |  | A | 3 | 0.5 | 0.1304347826086956 | 0.1304347826086956
Did the contractor meet the environmental and safety regulatory requirements of the contract? |  |  |  |  | B |  |  | B2C |  |  |  |  |  | B | 2 | 0.3333333333333333 | 0.08695652173913043 | 0.08695652173913043
Did the contractor take adequate precautions with any hazardous and materials and designated substances? |  |  |  |  | C |  |  |  |  |  |  |  |  | C | 1 | 0.1666666666666667 | 0.04347826086956522 | 0.04347826086956522
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | 0.9999999999999999 | 0.2608695652173913
QUALITY OF WORK AND COMPLIANCE WITH STANDARDS AND SPECIFICATIONS |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.2173913043478261 |  |  |  | 0.2173913043478261
 |  |  |  |  |  | A | B | C | D
Did the contractor comply with standards and specifications in the contract? |  |  |  |  | A |  | AB | A | A |  |  |  |  | A | 3 | 0.3 | 0.06521739130434782 | 0.06521739130434782
Were the material quality and workmanship in compliance with the contract documents? |  |  |  |  | B |  |  | BC | BD |  |  |  |  | B | 3 | 0.3 | 0.06521739130434782 | 0.06521739130434782
Did the contractor demonstrate the importance of delivering high-quality services and products? |  |  |  |  | C |  |  |  | CD |  |  |  |  | C | 2 | 0.2 | 0.04347826086956522 | 0.04347826086956522
Did the contractor promptly correct defective work as the project progressed? |  |  |  |  | D |  |  |  |  |  |  |  |  | D | 2 | 0.2 | 0.04347826086956522 | 0.04347826086956522
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 | 1 | 0.2173913043478261
TEAMWORK AND SERVICE FOCUS |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.04347826086956522 |  |  |  | 0.04347826086956522
 |  |  |  |  |  | A | B | C
Did the contractor communicate with the contract administrator in accordance with the contract documents? |  |  |  |  | A |  | AB | AC |  |  |  |  |  | A | 2 | 0.3333333333333333 | 0.0144927536231884 | 0.0144927536231884
Was the contractor cooperative with the City and contract administrator? |  |  |  |  | B |  |  | BC |  |  |  |  |  | B | 2 | 0.3333333333333333 | 0.0144927536231884 | 0.0144927536231884
Did the contractor collaborte and work in partnership with the project team? |  |  |  |  | C |  |  |  |  |  |  |  |  | C | 2 | 0.3333333333333333 | 0.0144927536231884 | 0.0144927536231884
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | 1 | 0.04347826086956522
ORGANIZATION AND MANAGEMENT |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.1304347826086956 |  |  |  | 0.1304347826086956
 |  |  |  |  |  | A | B | C | D | E | F | G | H | I
Did the contractor submit a satisfactory baseline schedule? |  |  |  |  | A |  | AB | A | D | E | F | A | AH | AI | 5 | 0.1 | 0.01304347826086957 | 0.01304347826086957
Did the contractor commence the work on time? |  |  |  |  | B |  |  | B | D | E | F | B | H | I | 3 | 0.06 | 0.007826086956521738 | 0.007826086956521738
Did the contractor submit schedule updates in accordance with the contract? |  |  |  |  | C |  |  |  | D2 | E | F2 | C | H | I | 1 | 0.02 | 0.002608695652173913 | 0.002608695652173913
Did the contractor adequately staff and resource the project? |  |  |  |  | D |  |  |  |  | DE | DF | D | DH | DI | 9 | 0.18 | 0.02347826086956522 | 0.02347826086956522
Did the contractor provide adequate site supervision? |  |  |  |  | E |  |  |  |  |  | EF | E | E | EI | 8 | 0.16 | 0.0208695652173913 | 0.0208695652173913
Did the contractor effectively coordinate and manage the work of its subcontractors? |  |  |  |  | F |  |  |  |  |  |  | F | FH | FI | 9 | 0.18 | 0.02347826086956522 | 0.02347826086956522
Did a person with decision-making authority represent the contractor at pay/progress meetings? |  |  |  |  | G |  |  |  |  |  |  |  | H | I | 1 | 0.02 | 0.002608695652173913 | 0.002608695652173913
Did the contractor submit timely RFI's as needed? |  |  |  |  | H |  |  |  |  |  |  |  |  | I | 6 | 0.12 | 0.01565217391304348 | 0.01565217391304348
Were shop drawings submitted according to shop drawing schedule and in compliance with the contract? |  |  |  |  | I |  |  |  |  |  |  |  |  |  | 8 | 0.16 | 0.0208695652173913 | 0.0208695652173913
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 50 | 1 | 0.1304347826086956
WORK PERFORMANCE |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.2173913043478261 |  |  |  | 0.2173913043478261
 |  |  |  |  |  | A | B | C | D | E | F | G | H
Did the contractor follow the approved schedule? |  |  |  |  | A |  | AB | A | D | A | AF | A | H | A | 5 | 0.1282051282051282 | 0.02787068004459308 | 0.02787068004459308
Did the contractor provide effective quality assurance and quality control? |  |  |  |  | B |  |  | B | BD | B | BF | B | H | B | 6 | 0.1538461538461539 | 0.0334448160535117 | 0.0334448160535117
Did the contractor keep the site clean and free of trash and debris? |  |  |  |  | C |  |  |  | D | CE | F2 | G | H2 | C | 1 | 0.02564102564102564 | 0.005574136008918617 | 0.005574136008918617
Did the contractor comply with change orders, change directives, site instructions, and RFQs? |  |  |  |  | D |  |  |  |  | D | DF | D | DH | D | 7 | 0.1794871794871795 | 0.03901895206243032 | 0.03901895206243032
Did the contractor have authorization to perform additional work? |  |  |  |  | E |  |  |  |  |  | F | G | H2 | E | 1 | 0.02564102564102564 | 0.005574136008918617 | 0.005574136008918617
Did the contractor adequately address disputes and claims with subcontractors and third parties? |  |  |  |  | F |  |  |  |  |  |  | F | H | F | 7 | 0.1794871794871795 | 0.03901895206243032 | 0.03901895206243032
Did the contractor address City requests promptly and effectively? |  |  |  |  | G |  |  |  |  |  |  |  | H2 | G | 2 | 0.05128205128205128 | 0.01114827201783723 | 0.01114827201783723
Was the quality and submission timelines of the following items acceptable? |  |  |  |  | H |  |  |  |  |  |  |  |  | H | 10 | n/a | n/a
● | two week look ahead schedule |  |  |  |  |  |  |  |  |  |  |  |  |  | 39 | 0.05128205128205128 | 0.01114827201783723 | 0.01114827201783723
● | accurate and complete record documents (as-builts) |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.05128205128205128 | 0.01114827201783723 | 0.01114827201783723
● | Complete operations and maintenance manuals and closeout documents |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.05128205128205128 | 0.01114827201783723 | 0.01114827201783723
● | Startup testing and commissioning reports |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.05128205128205128 | 0.01114827201783723 | 0.01114827201783723
● | Training plan and manuals |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.05128205128205128 | 0.01114827201783723 | 0.01114827201783723
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0.2173913043478261
CONTRACTOR PERFORMANCE AND DILIGENCE |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.1304347826086956 |  |  |  | 0.1304347826086956
 |  |  |  |  |  | A | B | C | D | E | F | G
Did the contractor actively work to respond to project problems in a timely fashion. |  |  |  |  | A |  | AB | C | AD | E | F | AG |  | A | 3 | 0.09375 | 0.01222826086956522 | 0.01222826086956522
Did the contractor suggest solutions to project problems and display initiative to implement solutions? |  |  |  |  | B |  |  | C | B | E | BF | BG |  | B | 4 | 0.125 | 0.01630434782608696 | 0.01630434782608696
Did the contractor demonstrate accountability for problems for which they where responsible? |  |  |  |  | C |  |  |  | C | CE | CF | CG |  | C | 6 | 0.1875 | 0.02445652173913043 | 0.02445652173913043
Did the contractor submit accurate, complete invoices? |  |  |  |  | D |  |  |  |  | E | F | G |  | D | 1 | 0.03125 | 0.004076086956521739 | 0.004076086956521739
Did the contractor provide competitive change order pricing? |  |  |  |  | E |  |  |  |  |  | EF | EG |  | E | 6 | 0.1875 | 0.02445652173913043 | 0.02445652173913043
Did the contractor accept financial responsibility for the scope and extents of the contract? |  |  |  |  | F |  |  |  |  |  |  | FG |  | F | 6 | 0.1875 | 0.02445652173913043 | 0.02445652173913043
Did the contractor coordinate to minimize disruption of  operations with the City and customers? |  |  |  |  | G |  |  |  |  |  |  |  |  | G | 6 | 0.1875 | 0.02445652173913043 | 0.02445652173913043
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 32 | 1 | 0.1304347826086956
OVERALL |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  | 1
 |  |  |  |  |  | A | B | C | D | E | F
Safety Standards and Regulations |  |  |  |  | A |  | A | A2 | A | A | A |  |  | A | 6 | 0.2608695652173913 | 0.2608695652173913 | 0.2608695652173913
Quality of Work and Compliance with Standards and Specifications |  |  |  |  | B |  |  | B | B2 | BE | B |  |  | B | 5 | 0.2173913043478261 | 0.2173913043478261 | 0.2173913043478261
Teamwork and Service Focus |  |  |  |  | C |  |  |  | D | CE | EF |  |  | C | 1 | 0.04347826086956522 | 0.04347826086956522 | 0.04347826086956522
Organization and Management |  |  |  |  | D |  |  |  |  | DE | DF |  |  | D | 3 | 0.1304347826086956 | 0.1304347826086956 | 0.1304347826086956
Work Performance |  |  |  |  | E |  |  |  |  |  | EF |  |  | E | 5 | 0.2173913043478261 | 0.2173913043478261 | 0.2173913043478261
[NAME] and [NAME] |  |  |  |  | F |  |  |  |  |  |  |  |  | F | 3 | 0.1304347826086956 | 0.1304347826086956 | 0.1304347826086956
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23 | 1 | 1