{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Instructions","Program Plan Application","Program Plan Approval"],"not_rendered":{"charts":0,"images":0,"macros":1,"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":"Instructions","index":0,"n_rows":20,"n_cols":1,"rows_kept":20,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["Attachment 3 \nFollow the instructions below to complete the Program Plan Application tab.  \nThe Program Plan Approval tab is locked and is not to be completed by your organization."]
[]
["Part 1, A. Contact Information"]
["Enter requested Contractor Name and Contractor's corresponding Contract Number.   Enter Program Plan Application date.  Enter your Organization Name, Division Name, Payment Program Name, and a Desription of the Program.  Please note:  Separate Program Plan Application Forms must be submitted to OGS for each Payment Program within your Organization or Division.  \nProvide Contact Information for TWO indivduals within your organization.\n"]
["Part 1, B. Description of Existing Payment Program"]
["Question 1:  Enter a brief description of your existing payment program.  If no program exists, enter \"n/a\".\nQuestions 2-7: Select the applicable response from the drop-down, and provide additional information by typing in the boxes below your selection.\n"]
["Part 1, C. Description of Proposed PPS Program"]
["Answer all questions about your desired payment program.\n"]
["Part 1, D. Description of Program Attributes and Procedures"]
["Type your responses in the \"Description\" boxes provided.\nList the payment gateway provider and point of sales terminals and/or software being used.  Include Make and Model Number of all Point of Sales terminals in use. \n"]
["Part 1, E. Transaction and Collection Information"]
["Select the fiscal year from the drop-down below \"Actual Collections\".  \nProvide the actual number of transactions, dollar value, and average ticket for the fiscal year in the cells provided.\n\nSelect the next two fiscal years from the drop-down below \"Projected Collections\".\nProvide the anticipated number of transactions, dollar value, and average ticket that you expect in the next two fiscal years for the desired payment program.\n"]
["Part 1, F. Total Projected Number of Transactions"]
["Enter the information requested for the next two fiscal years based on the projected number of transactions for your desired payment program.\n"]
["Part 2, A. Payment Processing Services Contractor Services - Projected Costs"]
["Enter the information requested for the next two fiscal years based on projected costs for your desired payment program.\nSome cells are locked and will calculate automatically based on values you enter.\n"]
["Part 2, B. Payment Processing Services Benefits - Projected"]
["Enter the information requested for the next two fiscal years based on projected benefits from your desired payment program.\nSome cells are locked and will calculate automatically based on values you enter.\n"]
["Part 2, C. Net Impact of Offering Payment Processing Services - Projected"]
["Net Impact cells are locked and will calculate automatically based on values you enter.\nEnter a response to a or b, based on the Net Impact to your organization.\n"]

{"sheet":"Program Plan Application","index":1,"n_rows":127,"n_cols":5,"rows_kept":127,"cut":false,"hidden":false,"merged":[[125,4,126,4],[125,2,125,3],[126,2,126,3],[65,2,65,3],[63,2,63,3],[61,2,61,3],[43,2,43,3],[32,2,32,3],[22,0,22,3],[23,2,23,3],[24,2,24,3],[25,2,25,3],[26,2,26,3],[27,2,27,3],[28,2,28,3],[29,2,29,3],[120,0,120,1],[86,0,86,3],[59,0,59,1],[61,0,61,1],[63,0,63,1],[75,0,75,1],[81,0,81,1],[59,2,59,3],[67,0,67,1],[69,0,69,1],[60,0,60,3],[62,0,62,3],[64,0,64,3],[66,0,66,3],[71,0,71,1],[74,0,74,1],[68,0,68,3],[69,2,69,3],[67,2,67,3],[71,2,71,3],[70,0,70,1],[70,2,70,3],[80,0,80,3],[74,3,74,4],[73,0,73,4],[55,0,55,1],[56,0,56,3],[57,0,57,1],[58,0,58,3],[44,2,44,3],[45,2,45,3],[46,2,46,3],[47,2,47,3],[48,2,48,3],[49,2,49,3],[43,0,44,0],[46,0,47,0],[48,0,49,0],[51,0,51,3],[52,0,52,3],[53,0,53,1],[53,2,53,3],[54,0,54,3],[55,2,55,3],[57,2,57,3],[65,0,65,1],[35,0,36,0],[33,2,33,3],[38,0,38,3],[41,0,42,0],[34,2,34,3],[35,2,35,3],[36,2,36,3],[39,2,39,3],[40,2,40,3],[41,2,41,3],[42,2,42,3],[32,0,34,0],[0,0,0,3],[2,0,2,3],[6,0,6,1],[8,0,8,1],[9,0,9,1],[6,2,6,3],[8,2,8,3],[9,2,9,3],[30,0,31,0],[13,0,13,1],[14,0,14,1],[16,0,16,1],[17,0,17,1],[18,0,18,1],[19,0,19,1],[20,0,20,1],[24,0,25,0],[26,0,27,0],[28,0,29,0],[30,2,30,3],[31,2,31,3],[7,2,7,3],[10,2,10,3],[1,0,1,1],[87,6,87,7],[108,0,108,1],[102,0,104,0],[104,4,104,5],[105,4,105,5],[88,4,88,5],[89,4,89,5],[90,4,90,5],[93,4,93,5],[95,4,95,5],[96,4,96,5],[98,4,98,5],[99,4,99,5],[88,0,90,0],[93,0,95,0],[96,0,98,0],[99,0,99,1],[87,4,87,5],[104,6,104,7],[105,6,105,7],[108,4,108,5],[108,6,108,7],[87,0,87,1],[91,4,92,5],[123,0,123,1],[124,0,124,1],[111,0,111,1],[100,4,100,5],[102,4,102,5],[88,6,88,7],[89,6,89,7],[90,6,90,7],[91,6,91,7],[92,6,92,7],[93,6,93,7],[95,6,95,7],[96,6,96,7],[98,6,98,7],[99,6,99,7],[100,6,100,7],[102,6,102,7],[110,0,110,3],[122,0,122,3],[1,2,1,3],[15,0,15,1],[10,0,10,1],[7,0,7,1],[5,0,5,1],[3,0,3,1],[4,0,4,1],[3,2,3,3],[4,2,4,3],[5,2,5,3],[11,0,11,1],[12,0,12,1]]}
["Attachment 3 - Program Plan Application Form"]
["Application Date:",null,"Please enter a date"]
["Part 1, A. Contact Information"]
["Contractor Name: "]
["Contract Number "]
["Program Plan Application Date: "]
["Authorized User Name (Organization Name):"]
["Authorized User Division Name:"]
["Authorized User Payment Program Name:"]
["Description of Payment Program: "]
["Payment Program Address: "]
[null,null,"Contact Individual","Secondary Contact Individual"]
["Contact Person Name:"]
["Title:"]
["Contact Person's Organization Name",null," "]
["Contact Person's Division Name: "]
["Contact Person's Address Line 1:"]
["Address Line 2:"]
["City, State, ZIP:",null," "]
["Phone:"]
["Email Address:"]
[]
["Part 1, B. Description of Existing Payment Program"]
[1,"Description of existing program if applicable (please respond N/A if not applicable):"]
[2,"Description of customers served:","            Individuals              Businesses                  Other (describe below)"]
[null,"Other Description:"]
[3,"Types of payments currently accepted:","            Cash                       Checks                    Credit                      Debit\n\n                  ACH                        Other (describe below)"]
[null,"Other Description:"]
[4,"How frequently do customers remit payments?","           One-Time Payments            Regular Payments (recurring)            Other (describe below)"]
[null,"Other Description (payment processing):"]
[5,"How are payments received?","          Along with statement            Separate from any form              Electronically\n\n                Online                                           Other (describe below)"]
[null,"Other Description:"]
[6,"Where are payments received?","          Agency receives payments            Received at Remote Locations (indicate below how many locations) \n\n                 Other (describe below)"]
[null,"Number of Locations:"]
[null,"Other Description:"]
[7,"Do you currently offer a Payment Processing Services program?","Please Make a Selection"]
[null,"Description of Program and Name of Contractor:"]
[]
["Part 1, C. Description of Proposed PPS Program"]
[1,"Desired Implementation Date:","Please enter a date"]
[2,"Provide a description of the desired Payment Processing Services program:"]
[3,"How will you be offering Payment Processing Services transactions?","          Face-to-Face Transactions            Internet Transactions            IVR Transactions\n\n               Mail Order Transactions               Telephone Order Transactions            Electronically\n\n          Mobile                     Other (describe below)"]
[null,"Other Description:"]
[4,"What services will you use to implement PPS programs? Maybe what credit card types will you be using? ","          MC/Visa/Discover            American Express            Other (describe below)"]
[null,"Other Description:"]
[5,"If you are developing an Internet and/or IVR application that will offer Payment Processing Services payment options through a third party gateway provider, describe your plans to procure these services."]
[6,"If you are offering credit/off-line debit card payments, do you plan to pass the merchant fee onto your customers?","Please Make a Selection"]
[null,"Methods to be used:"]
[7,"If you will be offering an Internet and/or IVR application, do you plan to pass any usage fees onto your customers?","Please Make a Selection"]
[null,"Methods to be used:"]
[]
["Part 1, D. Description of Program Attributes and Procedures"]
["Customer Benefits\nDiscuss the benefits that will be provided to your customers by offering PPS payment options.  Examples include: convenience of offering multiple payment options, PPS facilitates e-commerce transactions over the Internet offering 24 x 7 service, eliminates the need to travel or mail payments, customers receive benefits from their credit/charge card (e.g., air miles, additional time to pay), etc."]
["Description:",null,"Please enter a response"]
["Authorized User Benefits\nDiscuss the benefits that your agency will receive by offering EVT payment options.  Examples include: reduced manual processing requirements, reduced errors associated with processing paper transactions, increased compliance (i.e., customers may make payments if they do not have the cash on hand), the agency may receive funds sooner (i.e., eliminates mail delays and reduces the time to deposit), guarantees funds since transactions are pre-approved and reduces or eliminates the potential for dishonored checks, allows the agency to reallocate staff, the agency benefits from a statewide contract minimizing redundant procurement efforts, etc."]
["Description:",null,"Please enter a response"]
["Internet and Interactive Voice Response Applications\nIf you will be offering EVT payments over the Internet and/or through Interactive Voice Response application, provide a description of these services and the associated benefits (both financial and other) to authorized user and your customers. "]
["Description:",null,"Please enter a response"]
["Retaining Customer Signatures\nDiscuss the procedures your agency will use to retain customer authorizations and, if any special procedures will be developed to store and/or retrieve this information."]
["Description:",null,"Please enter a response"]
["Associating E-Payments to Transactions\nIf applicable, discuss how your agency plans to associate e-payments to transactions (e.g., do you plan to store cross-reference fields such as the Authorized User Unique Field to associate e-payments to transactions).  Also, discuss how your agency plans to handle rejected transactions and how it will provide receipts to your customers."]
["Description:",null,"Please enter a response"]
["Methods for Reconciling E-Payments and Invoices\nDiscuss how your agency plans to reconcile electronic payments submitted with settled funds (i.e., verify that correct number of transactions were processed and correct amount of funds were received) and how you will reconcile and process vendor invoices (i.e., verify that you are charged for the correct number of transactions at the correct rate)."]
["Description:",null,"Please enter a response"]
["Refunds and Chargebacks\nDiscuss how your agency plans to handle refunds and chargebacks including any special procedures for accessing and retrieving information, and if you plan to have any special notices that you will provide to your customers to minimize chargebacks, etc."]
["Description:",null,"Please enter a response"]
["Security\nDiscuss how your agency plans to handle security of stored and transmitted e-payment information (e.g., credit card numbers, ACH bank account information, etc.).and ensure PCI compliance."]
["Description:",null,"Please enter a response"]
["Other\nPlease provide any additional information about your plans to offer EVT applications that will assist the EVTA and the Division of the Budget in reviewing your agency plans."]
["Description:",null,"Please enter a response"]
["Please list the payment gateway provider being utilized to process transactions for this payment program:",null,"Please enter a response"]
["Please list the point of sales terminals (Make/Model) and/or software being utilized to process transactions for this payment program:",null,"Please enter a response"]
[]
["Part 1, E. Transaction and Collection Information"]
[null,null,"Actual Collections","Projected Collections"]
[null,null,"Please Make a Selection","Please Make a Selection","Please Make a Selection"]
[1,"Transactions:"]
[2,"Value ($):"]
[3,"Average Ticket:"]
[]
["Part 1, F. Total Projected Number of Transactions"]
[null,null,{"$f":"IF($D$76=\"Please Make a Selection\", \"\",$D$76)","v":""},{"$f":"IF($E$76=\"Please Make a Selection\", \"\",$E$76)","v":""}]
[1,"Projected Usage Percent - All Types of Transactions (%):"]
[2,"Projected Number of Payment Processing Services Transactions:"]
[3,"Projected Value of Payment Processing Services Transactions ($): "]
[]
["Part 2, A. Payment Processing Services Contractor Services - Projected Costs"]
["i. Recurring Costs",null,{"$f":"IF($D$76=\"Please Make a Selection\", \"\",$D$76)","v":""},{"$f":"IF($E$76=\"Please Make a Selection\", \"\",$E$76)","v":""}]
["a.","Gross Transaction Fees ($)"]
[null,"Less: Device User Convenience Fees ($)"]
[null,"Net Transaction Fees (calculated)",{"$f":"C89-C90","v":0},{"$f":"D89-D90","v":0}]
["b.","Equipment Lease Fees ($) (please write N/A if not applicable)"]
["c.","Equipment Rental Fees  ($) (please write N/A if not applicable)"]
["d.","Other Recurring Costs (Explain Below)","Please Make a Selection","Please Make a Selection"]
[null,"Other Recurring Costs ($)"]
[null,"Other Recurring Costs (Explain)"]
["e.","Other Agency Recurring Costs (Explain Below)","Please Make a Selection","Please Make a Selection"]
[null,"Other Agency Recurring Costs ($)"]
[null,"Other Agency Recurring Costs (Explain)"]
["ii. Non-Recurring Costs",null,{"$f":"IF($D$76=\"Please Make a Selection\", \"\",$D$76)","v":""},{"$f":"IF($E$76=\"Please Make a Selection\", \"\",$E$76)","v":""}]
["a. ","Equipment Purchases ($)"]
[null,"Provide description of purchased equipment (Make/Model)"]
["b.","Other Non-Recurring Costs (Explain Below)","Please Make a Selection","Please Make a Selection"]
[null,"Other Non-Recurring Costs ($)"]
[null,"Other Non-Recurring Costs (Explain)"]
["c. ","Agency Development Costs","Please Make a Selection","Please Make a Selection"]
[null,"Agency Development Costs ($)"]
[null,"Provide brief description of Agency Development Costs"]
["iii. Total Payment Processing Services Costs (calculated)",null,{"$f":"IFERROR(SUM(C91:C93,C95,C98,C101,C104,C107),\"\")","v":0},{"$f":"SUM(D91:D99,D101:D106)","v":0}]
[]
["Part 2, B. Payment Processing Services Benefits - Projected"]
["i. Cost Savings",null,{"$f":"IF($D$76=\"Please Make a Selection\", \"\",$D$76)","v":""},{"$f":"IF($E$76=\"Please Make a Selection\", \"\",$E$76)","v":""}]
["a.","Benefit from reduced cash/check processing costs ($)"]
["b.","Benefit from eliminating mail delays ($)"]
["c.","Benefit from reducing dishonored checks ($)"]
["d.","Benefit from increased collections (i.e. less uncollectables) ($)"]
[null,"Other Cost Savings: List other cost savings in e - g. "]
["e."]
["f."]
["g."]
["ii. Total Payment Processing Services Savings (calculated)",null,{"$f":"SUM(C113:C120)","v":0},{"$f":"SUM(D113:D120)","v":0}]
[]
["Part 2, C. Net Impact of Offering Payment Processing Services - Projected"]
[null,null,{"$f":"IF($D$76=\"Please Make a Selection\", \"\",$D$76)","v":""},{"$f":"IF($E$76=\"Please Make a Selection\", \"\",$E$76)","v":""}]
["i. Net Impact (Total Payment Processing Services Cost - Total Payment Processing Services Cost Savings)",null,{"$f":"C121-C109","v":0},{"$f":"D121-D109","v":0}]
["a. ","If the Net Impact offering Payment Processing Services results in an additional cost to your agency, indicate how your organization is proposing to cover these costs. ","Please enter a response"]
["b. ","If the impact is to result in a savings, indicate how your organization proposed to repurpose these saving or reallocate to a different program area.  ","Please enter a response"]

{"sheet":"Program Plan Approval","index":2,"n_rows":26,"n_cols":10,"rows_kept":26,"cut":false,"hidden":false,"merged":[[15,18,16,22],[10,0,10,17],[0,0,0,17],[2,0,2,17],[3,0,3,17],[5,0,5,17],[6,0,6,17],[7,2,7,17],[8,2,8,17],[11,0,11,17],[12,0,12,17],[14,0,14,17],[15,0,15,2],[15,3,15,17],[23,0,23,17],[16,0,16,2],[16,3,16,17],[18,0,18,17],[19,0,19,6],[20,2,20,3],[20,5,20,6],[21,2,21,3],[21,5,21,6],[21,9,21,12],[21,13,21,14],[21,16,21,17],[20,0,20,1],[20,4,21,4],[20,9,20,11],[25,0,25,1],[26,13,26,14],[26,16,26,17],[24,0,24,6],[25,2,25,3],[25,5,25,6],[26,2,26,3],[26,5,26,6],[26,9,26,12],[25,9,25,11]]}
["Program Plan Application Form\nPart 3, Program Plan Approval       "]
[]
["Introduction"]
["For State Agencies:  Part 3, Program Plan Approval is used to inform State agencies if their Program Plan Application has been approved or disapproved.  The Office of General Services (OGS) Electronic Value Transfer Administration (EVTA), and the Division of the Budget (DOB) approval is required.  \nFor Non State Agencies: Office of General Services (OGS) Electronic Value Transfer Administration (EVTA) is required. (DOB approval is not required for Non State Agencies.)  \nFor State Agencies and Non State Agencies:  An approved Program Plan Application Form authorizes the implementation of an electronic payment program in accordance with the application.  Separate Program Plan Application Forms must be submitted for multiple payment programs within an agency, division or organization.  Disapproval prohibits the implementation of an electronic payment program as requested in the Program Plan Application Form. Applicants may, however, modify and resubmit a Program Plan Application Form for approval.  In order to utilize any of the Office of General Services' (OGS) Payment Processing Services Contracts, State Agencies and Non-State Agencies will be required to provide the Contractor with a copy of this Program Plan Approval indicating their plan has been approved. "]
[]
["OGS Payment Processing Services Contracts"]
["A copy of Part 3, indicating the Program Plan Application is \"Approved\" must be provided to the Contractor in order for the Contractor to provide billable services.  If Applicant is choosing to accept American Express branded cards, a copy of the approved application shall also be provided to American Express (Contract PS65669)."]
[]
[]
[]
["Completion of Sections B & C"]
["Section B, State Agency Application Status.  Will be completed by the OGS (EVTA) and DOB and is used to indicate the outcome of the evaluation process for applications submitted by State Agencies.  If the \"Approved\" box is checked, the Program Plan Application is approved.  If the \"Disapproved\" box is checked, the Program Plan Application is disapproved.  Approval is in effect for the full term of the Payment Processing Services Contract, except that a modified Program Plan Application Form must be submitted to the OGS EVTA in order to receive approval to expand the scope of services, or if the scope of services expands beyond those identified in the attached approved program plan. Please note: A new Program Plan Application Form must be submitted for OGS (EVTA) and DOB approval by the Authorized User to the OGS EVTA for the add-on of any additional Payment Programs within the organization. "]
["Section C, Non-State Agency Application Status. Will be completed by the OGS (EVTA) and is used to indicate that the Program Plan Application is approved. Approval is in effect for the full term of the Payment Processing Services Contract indefinitely, except that a modified Program Plan Application Form EVTA-1 Application must be submitted to the OGS EVTA in order to receive approval to expand the scope of services, or if the scope of services expands beyond those identified in the attached approved program plan. Please note: A new Program Plan Application Form must be submitted for OGS (EVTA) and DOB approval by the Authorized User to the OGS EVTA for the add-on of any additional Payment Programs within the organization. "]
[]
["Section A, Applicant Information"]
["Authorized User Name:",null,null,{"$f":"IFERROR(IF('Program Plan Application'!C7:D7=\"\",\"\",'Program Plan Application'!C7:D7),\"\")","v":""}]
[" Payment Program Name:",null,null,{"$f":"IFERROR(IF('Program Plan Application'!C9:D9=\"\",\"\",'Program Plan Application'!C9:D9),\"\")","v":""}]
[]
["Section B, State Agency Application Status (to be completed by  OGS (EVTA) and DOB)"]
["Application Status",null,null,null,null,null,null,"Program #"]
[null,null,"Approved",null,null,"Disapproved",null,"EVTA/DOB ",null,"Approval Date"]
[]
[]
["Section C, Non-State Agency Application Status (to be completed by OGS (EVTA)"]
["Application Status",null,null,null,null,null,null,"Program # "]
[null,null,"Approved",null,null,null,null,"EVTA: ",null,"Approval Date "]