{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Evaluation Tool","Checklist"," BenchMark","Background","Sections 1 & 3","Section 4","Sections 5 & 6","Section 7","Compliance Considerations","Instructions","Sheet1"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":52,"comments":2,"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":"Evaluation Tool","index":0,"n_rows":52,"n_cols":20,"rows_kept":52,"cut":false,"hidden":false,"merged":[[2,2,2,16],[1,2,1,16],[40,4,40,6],[47,4,47,6],[45,4,45,6],[25,4,25,6],[29,4,29,6],[42,4,42,6],[46,4,46,6],[41,4,41,6],[6,5,6,7],[6,3,6,4],[18,3,18,4],[28,11,28,12],[25,11,25,12],[26,11,26,12],[11,3,11,8],[28,4,28,6],[20,2,20,16],[14,3,14,4],[24,4,24,6],[13,3,13,4],[17,3,17,4],[24,11,24,12],[4,11,4,14],[5,11,5,14],[49,4,49,6],[44,4,44,6],[38,4,38,6],[48,4,48,6],[26,4,26,6],[8,2,8,16],[10,3,10,4],[16,3,16,4],[15,3,15,4],[12,3,12,4],[37,4,37,6],[27,11,27,12],[23,4,23,6],[13,9,17,9],[4,3,4,4],[4,5,4,7],[5,5,5,7],[4,9,4,10],[5,9,5,10],[5,3,5,4],[31,4,31,6],[42,3,44,3],[45,3,50,3],[24,3,29,3],[30,3,34,3],[35,3,41,3],[43,4,43,6],[30,4,30,6],[39,4,39,6],[27,4,27,6],[50,4,50,6],[35,4,35,6],[36,4,36,6],[34,4,34,6],[33,4,33,6],[32,4,32,6]]}
["AAABBBAAAAB$"]
[null,null,"State Purchasing Division - RFP Preparation Scorecard "]
[null,null,"Please refer to the \"Instructions\" Tab for information on the use of this form."]
[null,null,null,"Section A. General Information About the Agency and RFP"]
[null,null,null,"Purpose of RFP",null,null,null,null,null,"FY",null,null,null,null,null,null,null,"Strategic Support Analyst","Yes"]
[null,null,null,"Name of the Scorer",null,null,null,null,null,"Agency",null,null,null,null,null,null,null,"Category Analyst","No"]
[null,null,null,"Scorer's Title:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Asst. Category Manager"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Category Manager",null,2010]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2011]
[null,null,null,"Section B. Summary",null,"Grade",{"$f":"IF($K$52=4,1,IF(OR($I$19>=3,$H$19>=5),1,IF(OR(AND($H$19<=4,$H$19>=3),AND($I$19>=1,$I$19<=2)),2,IF(OR($H$19=2,$I$19=1),3,IF(AND($H$19<=1,$I$19=0),4,\"\")))))","v":4},null,null,null,null,null,null,null,null,null,null,"Category Cluster Manager ",null,2012]
[null,null,null,"Rating",null,null,null,null,null,null,null,null,null,null,null,null,null,"Strategic Sourcing Director",null,2013]
[null,null,null,"Evaluation Criteria",null,"No. of Errors","Evaluation","Minors","Majors",null,null,null,null,null,null,null,null,"Senior Strategic Support Analyst",null,2014]
[null,null,null,"Introduction and Offeror Information (Sections 1 and 3)",null,{"$f":"H30","v":0},{"$f":"IF($I$14>=1,\"Needs Work\",\"\")","v":""},{"$f":"J30","v":0},{"$f":"I30","v":0},null,null,null,null,null,null,null,null,"Strategic Support Lead",null,2015]
[null,null,null,"RFP Proposal Factors (Section 4)",null,{"$f":"H35","v":0},{"$f":"IF($I$15>=1,\"Needs Work\",\"\")","v":""},{"$f":"J35","v":0},{"$f":"I35","v":0},null,null,null,null,null,null,null,null,"Information Specialist/Consultant, Special Projects",null,2016]
[null,null,null,"Cost Proposal, Proposal Evaluation, Negotiations and Award (Sections 5 and 6)",null,{"$f":"H42","v":0},{"$f":"IF($I$16>=1,\"Needs Work\",\"\")","v":""},{"$f":"J42","v":0},{"$f":"I42","v":0},null,null,null,null,null,null,null,null,"Consultant, Special Projects",null,2017]
[null,null,null,"Contract Terms and Conditions (Section 7)",null,{"$f":"H45","v":0},{"$f":"IF($I$17>=1,\"Needs Work\",\"\")","v":""},{"$f":"J45","v":0},{"$f":"I45","v":0},null,null,null,null,null,null,null,null,"Executive Consultant, Special Projects"]
[null,null,null,"Compliance Considerations ",null,{"$f":"H51","v":0},{"$f":"IF($I$18>=1,\"Needs Work\",\"\")","v":""},{"$f":"J51","v":0},{"$f":"I51","v":0},null,null,null,null,null,null,null,null,"Executive Consultant, Special Projects"]
[null,null,null,"RFP Evaluation Results",null,{"$f":"SUM(F14:F18)","v":0},{"$f":"IF(G11>=3,\"Meets Requirements\",\"Needs Work\")","v":"Meets Requirements"},{"$f":"IF(SUM($H$14:$H$18)<>0,SUM($H$14:$H$18),0)","v":0},{"$f":"IF(SUM($I$14:$I$18)<>0,SUM($I$14:$I$18),0)","v":0}]
[]
[]
[]
[null,null,null,"Section C. RFP Evaluation Criteria"]
[null,null,null,"Category","Criteria",null,null,"Answer","Majors","Minors"]
[null,null,null,"Introduction and Offeror Information (Sections 1 and 3)","Are the purpose and description of the Procurement clearly stated?",null,null,null,{"$f":"IF($H25=\"No\",\"Major\",\"\")","v":""},{"$f":"IF($H25=\"No\",\"\",\"\")","v":""},null,"Scale",null,"Score","Pass Score?"]
[null,null,null,null,"Does it include a schedule of events?",null,null,null,{"$f":"IF($H26=\"No\",\"Major\",\"\")","v":""},{"$f":"IF($H26=\"Yes\",\"\",\"\")","v":""},null,"No Major, ≤ 1 Minor Errors",null,4,"Yes"]
[null,null,null,null,"Is the schedule of events too aggressive?  Is the time to complete all the events unrealistic?",null,null,null,{"$f":"IF($H27=\"Yes\",\"Major\",\"\")","v":""},{"$f":"IF($H27=\"No\",\"\",\"\")","v":""},null,"No Major, ≤ 2 Minor",null,3,"Yes"]
[null,null,null,null,"Does it include an agency/university definition of terms that is specific to the solicitation?",null,null,null,{"$f":"IF($H28=\"No\",\"\",\"\")","v":""},{"$f":"IF($H28=\"No\",\"Minor\",\"\")","v":""},null,"1-2 Major, 3-4 Minor",null,2,"No"]
[null,null,null,null,"Does it include adequate insurance requirements?",null,null,null,{"$f":"IF(OR($H29=\"No\",$H29=\"N/A\"),\"\",\"\")","v":""},{"$f":"IF($H29=\"No\",\"Minor\",\"\")","v":""},null,"≥ 3 Major, ≥ 5 Minor",null,1,"No"]
[null,null,null,null,"Total Number of Errors",null,null,{"$f":" $I30+$J30","v":0},{"$f":"COUNTIF($I25:$I29,\"Major\")","v":0},{"$f":"COUNTIF($J25:$J29,\"Minor\")","v":0},{"$f":"IF(AND($H$25=\"Yes\",$H$26=\"Yes\",$H$27=\"No\",$H$28=\"Yes\",$H$29=\"Yes\"),0,1)","v":1}]
[null,null,null,"RFP Proposal Factors \n(Section 4)","Is the Technical Proposal introduction written appropriately (If applicable)?",null,null,null,{"$f":"IF($H31=\"Yes\",\"\",\"\")","v":""},{"$f":"IF($H31=\"No\",\"Minor\",\"\")","v":""}]
[null,null,null,null,"Are mandatory requirements too restrictive  or geared to a specific supplier?",null,null,null,{"$f":"IF($H32=\"Yes\",\"Major\",\"\")","v":""},{"$f":"IF($H32=\"Yes\",\"\",\"\")","v":""}]
[null,null,null,null,"Have the RFP questions captured the key elements to be evaluated?",null,null,null,{"$f":"IF($H33=\"No\",\"Major\",\"\")","v":""},{"$f":"IF($H33=\"Yes\",\"\",\"\")","v":""}]
[null,null,null,null,"Are there inconsistencies in the RFP?  (For example, conflicting terminology or requirements)",null,null,null,{"$f":"IF($H34=\"Yes\",\"Major\",\"\")","v":""}]
[null,null,null,null,"Total Number of Errors",null,null,{"$f":" $I35+$J35","v":0},{"$f":"IF(ISBLANK(I31:I34),\"NA\",COUNTIF(I31:I34,\"Major\"))","v":0},{"$f":"IF(ISBLANK(J31:J34),\"NA\",COUNTIF(J31:J34,\"Minor\"))","v":0},{"$f":"IF(AND($H$31=\"Yes\",$H$32=\"No\",$H$33=\"Yes\",$H$34=\"No\"),1,0)","v":0}]
[null,null,null,"Cost Proposal, Proposal Evaluation, Negotiations, and Award \n(Sections 5 and 6)","Does the cost proposal support the technical requirements?",null,null,null,{"$f":"IF($H36=\"No\",\"Major\",\"\")","v":""},{"$f":"IF($H36=\"Yes\",\"\",\"\")","v":""}]
[null,null,null,null,"If applicable, is the appropriate negotiation language included?",null,null,null,{"$f":"IF(OR($H37=\"Yes\",$H37=\"N/A\"),\"\",\"\")","v":""},{"$f":"IF($H37=\"No\",\"Minor\",\"\")","v":""}]
[null,null,null,null,"Is the appropriate award language included?",null,null,null,{"$f":"IF($H38=\"No\",\"Major\",\"\")","v":""},{"$f":"IF($H38=\"No\",\"\",\"\")","v":""}]
[null,null,null,null,"Are there points assigned for the technical and cost proposal in the RFP?",null,null,null,{"$f":"IF($H39=\"No\",\"Major\",\"\")","v":""},{"$f":"IF($H39=\"Yes\",\"\",\"\")","v":""}]
[null,null,null,null,"Has the Cost Methodology been documented?",null,null,null,{"$f":"IF($H40=\"No\",\"Major\",\"\")","v":""},{"$f":"IF($H40=\"Yes\",\"\",\"\")","v":""}]
[null,null,null,null,"Has the Supplier Individual Evaluation worksheet, SPD-EP007,  been submitted with points assigned to all scored questions?",null,null,null,{"$f":"IF($H41=\"No\",\"Major\",\"\")","v":""},{"$f":"IF($H41=\"Yes\",\"\",\"\")","v":""}]
[null,null,null,null,"Total Number of Errors",null,null,{"$f":" $I42+$J42","v":0},{"$f":"IF(ISBLANK(I36:I41),\"NA\",COUNTIF(I36:I41,\"Major\"))","v":0},{"$f":"IF(ISBLANK(J36:J41),\"NA\",COUNTIF(J36:J41,\"Minor\"))","v":0},{"$f":"IF(AND($H$36=\"Yes\",$H$37=\"Yes\",$H$37=\"N/A\",,$H$38=\"Yes\",$H$39=\"Yes\",$H$40=\"Yes\",$H$41=\"Yes\"),1,0)","v":0}]
[null,null,null,"Contract Terms and Conditions \n(Section 7)","Is there a reference to a contract?",null,null,null,{"$f":"IF($H43=\"No\",\"Major\",\"\")","v":""},{"$f":"IF($H43=\"Yes\",\"\",\"\")","v":""}]
[null,null,null,null,"Is the appropriate contract attached?  ",null,null,null,{"$f":"IF($H44=\"No\",\"Major\",\"\" )","v":""},{"$f":"IF($H44=\"No\",\"\",\"\")","v":""}]
[null,null,null,null,"Total Number of Errors",null,null,{"$f":" $I45+$J45","v":0},{"$f":"IF(ISBLANK($I43:$I44),\"NA\",COUNTIF($I43:$I44,\"Major\"))","v":0},{"$f":"IF(ISBLANK($J43:$J44),\"NA\",COUNTIF($J43:$J44,\"Minor\"))","v":0},{"$f":"IF(AND($H$43=\"Yes\",$H$44=\"No\"),1,0)","v":0}]
[null,null,null,"Compliance Considerations","Does it follow the latest RFP template?",null,null,null,{"$f":"IF($H46=\"No\",\"Major\",\"\")","v":""},{"$f":"IF($H46=\"No\",\"\",\"\")","v":""}]
[null,null,null,null,"Is the correct technology specified in the eRFP (TGM or eSource)",null,null,null,{"$f":"IF($H47=\"No\",\"Major\",\"\")","v":""}]
[null,null,null,null,"Does it include a link to the GPM?",null,null,null,{"$f":"IF($H48=\"Yes\",\"\",\"\")","v":""},{"$f":"IF($H48=\"No\",\"Minor\",\"\")","v":""}]
[null,null,null,null,"Has the Issuing Officer completed the Checklist and Background Tabs and submitted with the RFP for review?",null,null,null,{"$f":"IF($H49=\"No\",\"Major\",\"\")","v":""}]
[null,null,null,null,"If applicable, has the APO/CUPO forwarded the completed RFP Preparation Scorecard and materials to SPD for review?",null,null,null,{"$f":"IF($H50=\"No\",\"Major\",\"\")","v":""},{"$f":"IF($H50=\"No\",\"\",\"\")","v":""},null,{"$f":"IF(OR(Checklist!F$14>0,Checklist!F$19>0,Checklist!F$22>0,Checklist!F$30>0,Checklist!F$37>0,Checklist!F$41>0,Checklist!F$43>0),1,0)","v":0}]
[null,null,null,null,"Total Number of Errors",null,null,{"$f":" $I51+$J51","v":0},{"$f":"IF(ISBLANK($I46:$I50),\"NA\",COUNTIF($I46:$I50,\"Major\"))","v":0},{"$f":"IF(ISBLANK($J46:$J50),\"NA\",COUNTIF($J46:$J50,\"Minor\"))","v":0},{"$f":"IF(AND($H$46=\"Yes\",$H$47=\"Yes\",$H$48=\"Yes\",$H$50=\"Yes\"),0,1)","v":1}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND($K$30=1,$K$35=1,$K$42=1,$K$45=1,$K$51=1),1,\"\")","v":""}]

{"sheet":"Checklist","index":1,"n_rows":43,"n_cols":9,"rows_kept":43,"cut":false,"hidden":false,"merged":[[37,1,40,1],[32,2,32,4],[36,2,36,4],[7,2,7,4],[41,1,42,1],[39,2,39,4],[41,2,41,4],[22,1,29,1],[22,2,22,4],[38,2,38,4],[40,2,40,4],[42,2,42,4],[8,2,8,4],[15,2,15,4],[37,2,37,4],[34,2,34,4],[33,2,33,4],[29,2,29,4],[35,2,35,4],[28,2,28,4],[30,2,30,4],[31,2,31,4],[26,2,26,4],[1,1,3,6],[30,1,36,1],[12,2,12,4],[24,2,24,4],[25,2,25,4],[27,2,27,4],[19,1,21,1],[9,2,9,4],[4,1,6,6],[11,2,11,4],[17,2,17,4],[18,2,18,4],[21,2,21,4],[23,2,23,4],[10,2,10,4],[19,2,19,4],[14,2,14,4],[13,2,13,4],[16,2,16,4],[20,2,20,4]]}
[]
[null,"Request for Proposal (RFP) Preparation Checklist"]
[]
[]
[null,"Use this checklist to ensure that you collected all necessary information and completed all necessary steps for the RFP"]
[]
[]
[null,"Category","Checklist",null,null,"Answer","Risk"]
[null,"Purpose of Procurement","Does the introduction offer a clear idea of who, what, when, where, and how (in no more than 3 paragraphs) to identify the work requested?",null,null,null,{"$f":"IF(OR($F9=\"No\",$F9=\"Incomplete\"),\"Major\",\"\")","v":""}]
[null,null,"Did you reference any hyperlinks to websites or provide attached documents where additional information related to programs or volume would be available to the supplier?",null,null,null,{"$f":"IF($F10=\"No\",\"Minor\",\"\")","v":""},null,"Yes"]
[null,null,"Did you indicate whether single or multiple awards will be made as a result of this solicitation?",null,null,null,{"$f":"IF(OR($F11=\"No\",$F11=\"Incomplete\"),\"Major\",\"\")","v":""},null,"No"]
[null,null,"Did you check to ensure that the requirements cannot be perceived as restrictive or copied from a Supplier’s website?",null,null,null,{"$f":"IF(OR($F12=\"No\",$F12=\"Incomplete\"),\"Major\",\"\")","v":""},null,"N/A"]
[null,null,"If the solicitation is a Sole Brand or Sole Source and SPD is conducting the solicitation on behalf of the agency/university, have you submitted the Sole Brand or the Sole Source form to SPD with your justification?",null,null,null,{"$f":"IF($F13=\"No\",\"Minor\",\"\")","v":""}]
[null,null,"Total Number of \"No\" Answers",null,null,{"$f":" COUNTIF(F9:F13,\"No\")","v":0},{"$f":"IF(ISBLANK(G9:G13),\"NA\",COUNTIF(G9:G13,\"Major\"))","v":0}]
[null,"Schedule of Events","Did you include dates that are reasonable based on the 7-stage procurement methodology and the category being procured? ",null,null,null,{"$f":"IF(OR($F15=\"No\",$F15=\"Incomplete\"),\"Major\",\"\")","v":""}]
[null,null,"Did you check to ensure that all necessary events are included in the schedule of events?",null,null,null,{"$f":"IF(OR($F16=\"No\",$F16=\"Incomplete\"),\"Major\",\"\")","v":""}]
[null,null,"If applicable, did you include an offerors' conferences/pre-bid conferences in your schedule of events?",null,null,null,{"$f":"IF($F17=\"No\",\"Minor\",\"\")","v":""}]
[null,null,"Did the project team create an internal project plan that includes the schedule of events posted to the offeror and all the events that need to happen for the RFP to be completed, evaluated, etc.?  ",null,null,null,{"$f":"IF(OR($F18=\"No\",$F18=\"Incomplete\"),\"Major\",\"\")","v":""}]
[null,null,"Total Number of \"No\" Answers",null,null,{"$f":" COUNTIF(F15:F18,\"No\")","v":0},{"$f":"IF(ISBLANK(G15:G18),\"NA\",COUNTIF(G15:G18,\"Major\"))","v":0}]
[null,"Bonds and Insurance","Did you read the information regarding bonds and insurance found on SPD’s website (SPD form SPD-SP015 Insurance and Bonding Guidelines in Stage 3) to become familiar with the insurance and bonds requirements and discuss the insurance and bond requirements with the end user and Legal Counsel(s) to determine if additional/special/unique bonds and/or insurance are necessary for the proposal?",null,null,null,{"$f":"IF(OR($F20=\"No\",$F20=\"Incomplete\"),\"Major\",\"\")","v":""}]
[null,null,"Did you include appropriate bond/insurance requirements in the RFP?  Is the appropriate award language related to receiving bonds/insurance included?",null,null,null,{"$f":"IF(OR($F21=\"No\",$F21=\"Incomplete\"),\"Major\",\"\")","v":""}]
[null,null,"Total Number of \"No\" Answers",null,null,{"$f":" COUNTIF(F20:F21,\"No\")","v":0},{"$f":"IF(ISBLANK(G20:G21),\"NA\",COUNTIF(G20:G21,\"Major\"))","v":0}]
[null,"Documents","Did you fully detail in Section 8 of the eRFP all supporting documents?  (For example, schematics, maps, agency demographics, etc.)",null,null,null,{"$f":"IF($F23=\"No\",\"Minor\",\"\")","v":""}]
[null,null,"If no Additional Scored Worksheet is included with the solicitation, did you annotate the Section 8 List with Additional Scored Worksheet - \"N/A\" ?",null,null,null,{"$f":"IF($F24=\"No\",\"Minor\",\"\")","v":""}]
[null,null,"Did you include an agency definition of terms that is specific to the solicitation?",null,null,null,{"$f":"IF($F25=\"No\",\"Minor\",\"\")","v":""}]
[null,null,"Did you complete the Requirements Spreadsheet in its entirety (Technical/Cost Split, Major Categories, Questions, Points, Requested Documents) for review by the APO/CUPO?",null,null,null,{"$f":"IF($F26=\"No\",\"Major\",\"\")","v":""}]
[null,null,"Did the approving officer/APO/CUPO separate the Requirements Sheet into the Proposal Factors Sheets (Mandatory, Mandatory Scored, and/or Additional Scored worksheets)?",null,null,null,{"$f":"IF(OR($F27=\"No\",$F27=\"Incomplete\"),\"Major\",\"\")","v":""}]
[null,null,"Did you include Cost Sheet(s) and does the cost sheet support the technical requirements?",null,null,null,{"$f":"IF(OR($F28=\"No\",$F28=\"Incomplete\"),\"Major\",\"\")","v":""}]
[null,null,"Did you check that all documents requested from the offeror in questions allow for attachments on the Master Requirements Worksheet?",null,null,null,{"$f":"IF(OR($F29=\"No\",$F29=\"Incomplete\"),\"Minor\",\"\")","v":""}]
[null,null,"Total Number of \"No\" Answers",null,null,{"$f":" COUNTIF(F23:F29,\"No\")","v":0},{"$f":"IF(ISBLANK(G23:G29),\"NA\",COUNTIF(G23:G29,\"Major\"))","v":0}]
[null,"Evaluation Process","Have you identified Evaluation Committee Members (EC)?",null,null,null,{"$f":"IF(OR($F31=\"No\",$F31=\"Incomplete\"),\"Major\",\"\")","v":""}]
[null,null,"Did you hold a kick off meeting with the ECs to discuss individual and group roles and responsibilities, conflict of interest and time commitments?",null,null,null,""]
[null,null,"Did you review the evaluation process and the scoring rating system with the EC?  Do all members fully understand the scoring rating system?",null,null,null,""]
[null,null,"Did you have each individual EC member complete the EC Member Participation Form (SPD-SPR004)?",null,null,null,""]
[null,null,"If necessary (depending on conflict of interest, schedule conflicts, etc.), did you replace the EC member? ",null,null,null,""]
[null,null,"If including offerors demonstrations as a component of the solicitation, have you identified in the RFP Proposal Factors/RFP Template who will be invited to present and the evaluation criteria for the demonstration?",null,null,null,""]
[null,null,"Total Number of \"No\" Answers",null,null,{"$f":" COUNTIF(F31:F35,\"No\")","v":0},{"$f":"IF(ISBLANK(G31:G36),\"NA\",COUNTIF(G31:G36,\"Major\"))","v":0}]
[null,"Agency Additional Requirements/ Approvals","Did you obtain approvals from all necessary internal departments/divisions from your entity?",null,null,null,{"$f":"IF(OR($F38=\"No\",$F38=\"Incomplete\"),\"Major\",\"\")","v":""}]
[null,null,"Did you check to ensure you followed your entity’s internal procurement/policy for this type of purchase?",null,null,null,{"$f":"IF(OR($F39=\"No\",$F39=\"Incomplete\"),\"Major\",\"\")","v":""}]
[null,null,"Have you engaged your Agency's/University's Contracts Department/Division to ensure that contract execution can be accomplished within the schedule of events?",null,null,null,{"$f":"IF(OR($F40=\"No\",$F40=\"Incomplete\"),\"Major\",\"\")","v":""}]
[null,null,"Total Number of \"No\" Answers",null,null,{"$f":" COUNTIF(F38:F39,\"No\")","v":0},{"$f":"IF(ISBLANK(G38:G39),\"NA\",COUNTIF(G38:G39,\"Major\"))","v":0}]
[null,"External Requirements/ Approvals","Did you obtain all necessary external additional approvals?  For example, Georgia Technology Authority (GTA) approval, Executive Orders, BOR Security Policy Sign Off (for Universities Only).",null,null,null,{"$f":"IF(OR($F42=\"No\",$F42=\"Incomplete\"),\"Major\",\"\")","v":""}]
[null,null,"Total Number of \"No\" Answers",null,null,{"$f":" COUNTIF(F42:F42,\"No\")","v":0},{"$f":"IF(ISBLANK(G42:G42),\"NA\",COUNTIF(G42:G42,\"Major\"))","v":0}]

{"sheet":" BenchMark","index":2,"n_rows":28,"n_cols":27,"rows_kept":28,"cut":false,"hidden":true,"merged":[]}
["Position ","Key Skills"]
[null,"Strategic Sourcing / Job Specific Skills",null,null,null,null,null,null,null,"Government Affairs",null,null,"Supporting Technical",null,null,null,"Leadership",null,null,null,null,null,"Personal Characteristic"]
[null,"Category Knowledge ","Vendor Negotiation ","Strategic Cost Management ","Spend Analysis ","Vendor Relationship Management ","Vendor Performance Evaluation ","Customer Relationship Management","Average","Policy Development ","GPM and Procedure Knowledge","Average","Analytics ","Data Management and Computer Application Skills ","Technical Writing (RFP)","Average","Communication ","Decision-Making ","Organization ","Project and Risk Management ","Coaching and Staff Development","Average","Independence and Direction ","Teamwork ","Flexibility and Adaptability ","Ethical Standard and Political Awareness","Average"]
["Strategic Support Analyst",1.5,1.5,1.5,1.5,1.5,1.5,1.5,{"$f":"AVERAGE(B4:H4)","v":1.5},1,1,{"$f":"AVERAGE(J4:K4)","v":1},1,1,1,{"$f":"AVERAGE(M4:O4)","v":1},1.5,1.5,1.5,1.5,1.5,{"$f":"AVERAGE(Q4:U4)","v":1.5},2,2,2,2,{"$f":"AVERAGE(W4:Z4)","v":2}]
["Category Analyst",2,2,2,2,2,2,2,2,1.5,1.5,{"$f":"AVERAGE(J5:K5)","v":1.5},3,3,3,{"$f":"AVERAGE(M5:O5)","v":3},2,2,2,2,2,{"$f":"AVERAGE(Q5:U5)","v":2},2.5,2.5,2.5,2.5,2.5]
["Asst. Category Manager",3,3,3,3,3,3,3,3,2,2,2,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3]
["Category Manager",4,4,4,4,4,4,4,4,3,3,3,3.5,3.5,3.5,3.5,3.5,3.5,3.5,3.5,3.5,3.5,3.5,3.5,3.5,3.5,3.5]
["Category Cluster Manager ",4.5,4.5,4.5,4.5,4.5,4.5,4.5,4.5,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4]
["Strategic Sourcing Director",5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5]
["Senior Strategic Support Analyst",2,2,2,2,2,2,2,2,1.5,1.5,1.5,3,3,3,3,2,2,2,2,2,2,2.5,2.5,2.5,2.5,2.5]
["Strategic Support Lead",4.5,4.5,4.5,4.5,4.5,4.5,4.5,4.5,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4]
["Information Specialist/Consultant, Special Projects",2,2,2,2,2,2,2,2,1.5,1.5,1.5,3,3,3,3,2,2,2,2,2,2,2.5,2.5,2.5,2.5,2.5]
["Consultant, Special Projects",3,3,3,3,3,3,3,3,2,2,2,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3]
["Senior Consultant, Special Projects",4,4,4,4,4,4,4,4,3,3,3,3.5,3.5,3.5,3.5,3.5,3.5,3.5,3.5,3.5,3.5,3.5,3.5,3.5,3.5,3.5]
["Executive Consultant, Special Projects",4.5,4.5,4.5,4.5,4.5,4.5,4.5,4.5,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4]
["Data Analyst, Procurement Apps","NA","NA",2,2,2,"NA",2,2,2,2,2,3,3,"NA",3,1.5,1.5,1.5,1.5,1.5,1.5,2,2,2,2,2]
["IT Analyst, Procurement Applications","NA","NA",3,3,3,"NA",3,3,3,3,3,4,4,"NA",4,2,2,2,2,2,2,2.5,2.5,2.5,null,2.5]
["Manager, Procurement Applications","NA","NA","NA",4,4,"NA",4,4,4,4,4,5,5,"NA",5,4,4,4,4,4,4,4,4,4,4,4]
["Officer, Process Improvement ","NA",4,"NA","NA",4,4,4,4,5,5,5,"NA","NA",4,4,4,4,4,4,4,4,4,4,4,4,4]
["Analyst, Process Improvement","NA",2,"NA",2,2,"NA",2,2,4,4,4,"NA","NA",3,3,2,2,2,2,2,2,2.5,2.5,2.5,2.5,2.5]
["Officer, Marketing and Communications ","NA","NA","NA","NA",5,"NA",5,5,5,5,5,2,"NA","NA",2,5,5,5,5,5,5,4,4,4,4,4]
["Marketing and Communications Specialist","NA","NA","NA","NA",3,"NA",3,3,3,3,3,3,"NA","NA",3,3,3,3,3,3,3,2.5,2.5,2.5,2.5,2.5]
["Customer and Vendor Satisfaction Specialist","NA","NA","NA","NA",3,3,3,3,3,3,3,2,"NA","NA",2,3,3,3,3,3,3,2.5,2.5,2.5,2.5,2.5]
["Officer, Customer and Vendor Satisfaction","NA","NA","NA","NA",5,5,5,5,5,5,5,3,"NA","NA",3,5,5,5,5,5,5,4,4,4,4,4]
["Training Specialist","NA",3,"NA","NA",3,"NA",3,3,4,4,4,2,2,2,2,3,3,3,3,3,3,3,3,3,3,3]
["Manager, Professional Development","NA",4,"NA","NA",4,"NA",4,4,5,5,5,3,3,3,3,4.5,4.5,4.5,4.5,4.5,4.5,4,4,4,4,4]
["Chief Learning Officer","NA",4,4,4,4,4,4,4,5,5,5,4,4,4,4,4.5,4.5,4.5,4.5,4.5,4.5,5,5,5,5,5]
["Knowledge Center Director","NA",5,5,5,5,5,5,{"$f":"AVERAGE(B28:H28)","v":5},5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,{"$f":"AVERAGE(W28:Z28)","v":5}]

{"sheet":"Background","index":3,"n_rows":12,"n_cols":2,"rows_kept":12,"cut":false,"hidden":false,"merged":[[4,5,4,6],[7,5,7,6],[2,1,2,6],[3,1,3,6],[11,1,11,4],[4,1,4,4],[5,1,5,4],[6,1,6,4],[7,1,7,4],[10,1,10,4],[8,1,8,4],[9,1,9,4]]}
[]
[]
[null,"Answer the following questions"]
[]
[null,"Identify the Business Owner involved in the creation of the solicitation.  Explain the roles of the Cross Functional Team members, their expertise/background, and include contact information and his/her relationship to the procurement."]
[null,"Were you part of the development process from the beginning?  If not, when were your first contacted? "]
[null,"Did you have a kick-off meeting with the end users/cross functional team to guide them through the process of creating the RFP?  "]
[null,"How many meetings did you have with the end users/cross functional team?  Document dates and purpose of each meeting."]
[null,"Were external parties (consultants) involved in the development process? Was their firm notified that they could not bid on the solicitation or any other related components of the project?"]
[null,"Does the contract with the consultant provide for additional work during the solicitation process or contract period?"]
[null," What portion(s) of the RFP did these individuals create (i.e.  Did they write ALL of the questions and develop the methodology?, facilitate conferences, or market research, etc.)"]
[null," Have you verified that the direction of the RFP as developed by the Consultant does not point to a specific supplier with whom they've worked?"]

{"sheet":"Sections 1 & 3","index":4,"n_rows":12,"n_cols":30,"rows_kept":12,"cut":false,"hidden":false,"merged":[[22,1,22,5],[22,6,22,11],[17,1,17,5],[17,6,17,11],[18,1,18,5],[18,6,18,11],[21,1,21,5],[21,6,21,11],[19,1,19,5],[19,6,19,11],[20,1,20,5],[20,6,20,11],[15,1,15,5],[15,6,15,11],[16,1,16,5],[16,6,16,11],[7,6,7,11],[8,6,8,11],[12,6,12,11],[13,1,13,5],[13,6,13,11],[7,1,7,5],[14,6,14,11],[12,1,12,5],[1,1,4,12],[10,6,10,11],[5,6,5,11],[6,6,6,11],[14,1,14,5],[9,6,9,11],[8,1,8,5],[9,1,9,5],[10,1,10,5],[11,1,11,4],[11,6,11,12],[5,1,5,5],[6,1,6,5]]}
[]
[null,"Action Plan\nIntroduction and Offeror Information\nSections 1 and 3"]
[]
[]
[]
[null,"Criteria",null,null,null,null,"Action Plan",null,null,null,null,null,"Status",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Not Applicable"]
[null,{"$f":"'Evaluation Tool'!E$25","v":"Are the purpose and description of the Procurement clearly stated?"},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,"Not started"]
[null,{"$f":"'Evaluation Tool'!E$26","v":"Does it include a schedule of events?"},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,"Completed"]
[null,{"$f":"'Evaluation Tool'!E$27","v":"Is the schedule of events too aggressive?  Is the time to complete all the events unrealistic?"}]
[null,{"$f":"'Evaluation Tool'!E$28","v":"Does it include an agency/university definition of terms that is specific to the solicitation?"}]
[null,{"$f":"'Evaluation Tool'!E$29","v":"Does it include adequate insurance requirements?"}]
[null,"Comments:"]

{"sheet":"Section 4","index":5,"n_rows":11,"n_cols":13,"rows_kept":11,"cut":false,"hidden":false,"merged":[[23,1,23,5],[23,6,23,11],[18,1,18,5],[18,6,18,11],[19,1,19,5],[21,1,21,5],[21,6,21,11],[20,6,20,11],[19,6,19,11],[22,1,22,5],[22,6,22,11],[16,6,16,11],[13,6,13,11],[17,6,17,11],[12,6,12,11],[9,6,9,11],[20,1,20,5],[17,1,17,5],[16,1,16,5],[13,1,13,5],[14,1,14,5],[1,1,4,12],[5,1,5,5],[5,6,5,11],[6,1,6,5],[6,6,6,11],[7,1,7,5],[7,6,7,11],[15,1,15,5],[15,6,15,11],[8,6,8,11],[9,1,9,5],[11,1,11,5],[11,6,11,11],[12,1,12,5],[8,1,8,5],[10,6,10,12],[10,1,10,4],[14,6,14,11]]}
[]
[null,"Action Plan\nRFP Proposal Factors\nSection 4"]
[]
[]
[]
[null,"Criteria",null,null,null,null,"Action Plan",null,null,null,null,null,"Status"]
[null,{"$f":"'Evaluation Tool'!E$31","v":"Is the Technical Proposal introduction written appropriately (If applicable)?"}]
[null,{"$f":"'Evaluation Tool'!E$32","v":"Are mandatory requirements too restrictive  or geared to a specific supplier?"}]
[null,{"$f":"'Evaluation Tool'!E$33","v":"Have the RFP questions captured the key elements to be evaluated?"}]
[null,{"$f":"'Evaluation Tool'!E$34","v":"Are there inconsistencies in the RFP?  (For example, conflicting terminology or requirements)"}]
[null,"Comments:"]

{"sheet":"Sections 5 & 6","index":6,"n_rows":13,"n_cols":13,"rows_kept":13,"cut":false,"hidden":false,"merged":[[16,1,16,5],[16,6,16,11],[17,1,17,5],[17,6,17,11],[23,1,23,5],[23,6,23,11],[18,1,18,5],[18,6,18,11],[19,1,19,5],[19,6,19,11],[20,1,20,5],[20,6,20,11],[21,1,21,5],[21,6,21,11],[22,1,22,5],[22,6,22,11],[15,1,15,5],[15,6,15,11],[8,6,8,11],[9,1,9,5],[9,6,9,11],[11,1,11,5],[11,6,11,11],[10,1,10,5],[13,1,13,5],[13,6,13,11],[8,1,8,5],[14,1,14,5],[14,6,14,11],[10,6,10,11],[12,1,12,4],[12,6,12,12],[1,1,4,12],[5,1,5,5],[5,6,5,11],[6,1,6,5],[6,6,6,11],[7,1,7,5],[7,6,7,11]]}
[]
[null,"Action Plan\nCost Proposal, Proposal Evaluation, Negotiations , and Award\nSections 5 and 6"]
[]
[]
[]
[null,"Criteria",null,null,null,null,"Action Plan",null,null,null,null,null,"Status"]
[null,{"$f":"'Evaluation Tool'!E$36","v":"Does the cost proposal support the technical requirements?"}]
[null,{"$f":"'Evaluation Tool'!E$37","v":"If applicable, is the appropriate negotiation language included?"}]
[null,{"$f":"'Evaluation Tool'!E$38","v":"Is the appropriate award language included?"}]
[null,{"$f":"'Evaluation Tool'!E$39","v":"Are there points assigned for the technical and cost proposal in the RFP?"}]
[null,{"$f":"'Evaluation Tool'!E$40","v":"Has the Cost Methodology been documented?"}]
[null,{"$f":"'Evaluation Tool'!E$41","v":"Has the Supplier Individual Evaluation worksheet, SPD-EP007,  been submitted with points assigned to all scored questions?"}]
[null,"Comments:"]

{"sheet":"Section 7","index":7,"n_rows":9,"n_cols":13,"rows_kept":9,"cut":false,"hidden":false,"merged":[[16,1,16,5],[16,6,16,11],[17,1,17,5],[17,6,17,11],[23,1,23,5],[23,6,23,11],[18,1,18,5],[18,6,18,11],[19,1,19,5],[19,6,19,11],[20,1,20,5],[20,6,20,11],[21,1,21,5],[21,6,21,11],[22,1,22,5],[22,6,22,11],[14,1,14,5],[14,6,14,11],[9,6,9,11],[15,1,15,5],[15,6,15,11],[10,1,10,5],[10,6,10,11],[11,1,11,5],[11,6,11,11],[9,1,9,5],[12,1,12,5],[12,6,12,11],[13,1,13,5],[13,6,13,11],[8,1,8,5],[8,6,8,12],[1,1,4,12],[5,1,5,5],[5,6,5,11],[6,1,6,5],[6,6,6,11],[7,1,7,5],[7,6,7,11]]}
[]
[null,"Action Plan\nContract Terms and Conditions\nSection 7"]
[]
[]
[]
[null,"Criteria",null,null,null,null,"Action Plan",null,null,null,null,null,"Status"]
[null,{"$f":"'Evaluation Tool'!E$43","v":"Is there a reference to a contract?"}]
[null,{"$f":"'Evaluation Tool'!E$44","v":"Is the appropriate contract attached?  "}]
[null,"Comments:"]

{"sheet":"Compliance Considerations","index":8,"n_rows":12,"n_cols":13,"rows_kept":12,"cut":false,"hidden":false,"merged":[[18,1,18,5],[18,6,18,11],[19,1,19,5],[19,6,19,11],[25,1,25,5],[25,6,25,11],[20,1,20,5],[20,6,20,11],[21,1,21,5],[21,6,21,11],[22,1,22,5],[22,6,22,11],[23,1,23,5],[23,6,23,11],[24,1,24,5],[24,6,24,11],[17,1,17,5],[17,6,17,11],[14,1,14,5],[9,6,9,11],[12,1,12,5],[12,6,12,11],[13,1,13,5],[13,6,13,11],[9,1,9,5],[10,1,10,4],[10,6,10,10],[11,1,11,4],[11,6,11,12],[14,6,14,11],[15,1,15,5],[15,6,15,11],[16,1,16,5],[16,6,16,11],[8,6,8,11],[1,1,4,12],[5,1,5,5],[5,6,5,11],[6,1,6,5],[6,6,6,11],[7,1,7,5],[7,6,7,11],[8,1,8,5]]}
[]
[null,"Action Plan\nCompliance Considerations"]
[]
[]
[]
[null,"Criteria",null,null,null,null,"Action Plan",null,null,null,null,null,"Status"]
[null,{"$f":"'Evaluation Tool'!E$46","v":"Does it follow the latest RFP template?"}]
[null,{"$f":"'Evaluation Tool'!E$47","v":"Is the correct technology specified in the eRFP (TGM or eSource)"}]
[null,{"$f":"'Evaluation Tool'!E$48","v":"Does it include a link to the GPM?"}]
[null,"Has the Issuing Officer completed the Checklist and Background Tabs with the RFP for review?"]
[null,{"$f":"'Evaluation Tool'!E$50","v":"If applicable, has the APO/CUPO forwarded the completed RFP Preparation Scorecard and materials to SPD for review?"}]
[null,"Comments:"]

{"sheet":"Instructions","index":9,"n_rows":13,"n_cols":30,"rows_kept":13,"cut":false,"hidden":false,"merged":[[23,1,23,5],[23,6,23,11],[24,1,24,5],[24,6,24,11],[20,1,20,5],[20,6,20,11],[21,1,21,5],[21,6,21,11],[22,1,22,5],[22,6,22,11],[17,1,17,5],[17,6,17,11],[18,1,18,5],[18,6,18,11],[19,1,19,5],[19,6,19,11],[15,1,15,5],[15,6,15,11],[11,1,11,4],[11,6,11,10],[16,1,16,5],[16,6,16,11],[10,1,10,5],[10,6,10,11],[12,1,13,12],[14,1,14,5],[14,6,14,11],[7,1,7,5],[7,6,7,11],[8,1,8,5],[8,6,8,11],[9,1,9,5],[9,6,9,11],[1,1,4,12],[5,1,5,5],[5,6,5,11],[6,1,6,5],[6,6,6,11]]}
[]
[null,"\nUse of the RFP Scorecard By Issuing Officer and APO/CUPO Reviewer\n\n"]
[]
[]
[]
[null,"Steps",null,null,null,null,"Action Plan",null,null,null,null,null,"Outputs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Not Applicable"]
[null,1,null,null,null,null,"Issuing Officer prepares the RFP and completes the Checklist and Background Tabs and submits to the APO/CUPO for review.",null,null,null,null,null,"Completed RFP\nCompleted Checklist\nCompleted Background",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Not started"]
[null,2,null,null,null,null,"APO/CUPO uses the Evaluation Tool Tab to score the materials provided.  \n\nInformation about compliance may be included for the question.  Please hover over the red triangle in the upper right hand corner of any question on the Evaluation Tool Tab to see available comments or guidance.",null,null,null,null,null,"Completed Scorecard\n",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Completed"]
[null,3,null,null,null,null,"APO/CUPO clicks on the area of non-compliance and prepares an Action Plan for each area for the Issuing Officer to resolve and selects as \"Not Started\" in the drop down box.  For those items that are compliant, the APO/CUPO will select \"N/A\" from the drop down box as it does not apply to the Action Plan.  At the bottom of each tab is a place to add instructional comments to the Issuing Officer by the APO/CUPO.",null,null,null,null,null,"Action Plan and Instructional Comments to Issuing Officer"]
[null,4,null,null,null,null,"Issuing Officer corrects the items identified on the Action Plan, and annotates in the \"Comments\" field that the required changes have been made, and returns all updated documents to the APO/CUPO.",null,null,null,null,null,"Revised RFP, Supporting Documents, and Comments to APO/CUPO"]
[null,5,null,null,null,null,"The APO/CUPO reviews the revised documents and adjusts the Evaluation Tool for Compliance, and selects \"Completed\" on the related tabs to demonstrate that the RFP is complete.  The APO/CUPO should also document in the Comments field that all items have been resolved.",null,null,null,null,null,"Updated Scorecard\nUpdated Comments"]
[null,6,null,null,null,null,"If the RFP exceeds the DPA of the Entity, the APO/CUPO is required to submit the RFP Preparation Scorecard to SPD Process Improvement Section (processimprovement@doas.ga.gov) prior to posting the RFP.",null,null,null,null,null,"RFP, Supporting Documents and Methodology sent to SPD Process Improvement Section"]
[null,"Please Note: \n1. The RFP Scorecard is required for all solicitations and must be kept with the Solicitation records by the Entity for review during any Compliance Audit.\n2.  APO/CUPO should verify if waivers or additional approval processes apply to either the solicitation or the business owner and address them with the Issuing Officer during the solicitation process.\n3. All \"Comments\" should be dated, and deadlines provided for the Issuing Officer to return the required documents to the APO/CUPO. \n4. This tool is designed to be used as a training tool for the Issuing Officer and to support the Performance Review Process for the individual development of the Issuing Officer."]

{"sheet":"Sheet1","index":10,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}