{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["In-Take-Scoping (2)","Pricing Sheet","Bid"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":9,"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":"In-Take-Scoping (2)","index":0,"n_rows":127,"n_cols":11,"rows_kept":127,"cut":false,"hidden":false,"merged":[[0,0,0,1],[4,0,13,0]]}
["Scoping:"]
[null,null,null,null,null,null,null,true]
["BSA/AML Review:",null,null,"Asset Range:"]
[]
[null,"BSA Compliance Review",null,"<$150,000,000",null,null,null,true,null,false,{"$f":"SUM(IF(J5,'Pricing Sheet'!C2),IF(J6,'Pricing Sheet'!C13),IF(J7,'Pricing Sheet'!C24),IF(J8,'Pricing Sheet'!C35),IF(J9,'Pricing Sheet'!C46))","v":0}]
[null,"CIP Monitoring (including Beneficial Ownership)",null,"<$300,000,000",null,null,null,true,null,false]
[null,"CDD",null,"<$500,000,000",null,null,null,true,null,false]
[null,"Wire Monitoring",null,"<$750,000,000",null,null,null,true,null,false]
[null,"ACH Monitoring",null,"<$1,000,000,000",null,null,null,false,null,false]
[null,"CTR Monitoring (including exemptions)",null,null,null,null,null,true]
[null,"SAR Participation and Monitoring",null,"State:",null,null,null,false]
[null,"High Risk Monitoring",null,null,null,null,null,true,null,null,{"$f":"SUM(IF(H2,'Pricing Sheet'!C2),IF(H17,'Pricing Sheet'!C3),IF(H28,'Pricing Sheet'!C4),IF(H43,'Pricing Sheet'!C5),IF(H57,'Pricing Sheet'!C2),IF(H67,'Pricing Sheet'!C2),IF(H74,'Pricing Sheet'!C2),IF(H12,'Pricing Sheet'!C2))","v":10000}]
[null,"314(a) Monitoring",null,"Texas",null,null,null,false]
[null,"Training",null,"Out of State",null,null,null,true]
[]
["Deposit Compliance Review:",null,null,"Memberhip Level:"]
[null,null,null,null,null,null,null,false]
[null,"Truth in Savings",null,"Platnium Membership","<6"]
[null,"Privacy of Consumer Financial Information",null,"Gold Membership","<5"]
[null,"Electronic Banking",null,"Silver Membership","<4"]
[null,"Electronic Fund Transfers",null,"Bronze Membership","<2"]
[null,"Expedited Funds Availability"]
[null,"Interest on Deposits"]
[null,"Unlawful Internet Gambling"]
[null,"NOW Account & MMDA"]
[]
["Lending Compliance Review:"]
[null,null,null,null,null,null,null,false]
[null,"Truth in Lending"]
[null,"TRID"]
[null,"Homeowners Protection"]
[null,"Homeownership Counseling"]
[null,"Credit Practices Rule"]
[null,"Equal Credit Opportunity"]
[null,"Fair Housing"]
[null,"Home Mortgage Disclosure "]
[null,"Fair Credit Reporting & FACT"]
[null,"Flood Insurance"]
[null,"Privacy"]
[null,"Regulation O – Insider Activities- optional"]
[]
["ACH:"]
[null,null,null,null,null,null,null,false]
[null,"Policies"]
[null,"Procedures"]
[null,"Training"]
[null,"Agreements"]
[null,"Records"]
[null,"Retention"]
[null,"Prenotes"]
[null,"NOC’s"]
[null,"Returns"]
[null,"Stop Payments"]
[null,"Disclosures"]
[]
["Internal Control Review:"]
[null,null,null,null,null,null,null,false]
[null,"Adequacy of internal controls "]
[null,"Compliance with procedures"]
[null,"Review of the operation "]
[null,"Teller cash "]
[null,"Vault Cash"]
[null,"Monetary Instrument reconciliation"]
[null,"Dual Control Logs"]
[]
["Fair Lending Process Review:"]
[null,null,null,null,null,null,null,false]
[null,"Determine the strength of policy and procedures, "]
[null,"Identify deviations in rates based off of pricing sheet, "]
[null,"Identify variance in rates between population segments,"]
[null,"Review processes around applications"]
[]
["IT:"]
[null,null,null,null,null,null,null,false]
[null,"Corporate Governance of IT and GLBA"]
[null,"IT Planning and Risk Assessment"]
[null,"Reporting/Oversight of IT-Related Risks"]
[null,"IT Policies and Procedures"]
[null,"Project Management"]
[null,"New Vendor Selection"]
[null,"Vendor Risk Rating and Classification"]
[null,"Monitoring Service Provider Relationship(s)"]
[null,"Review of Contracts, SLAs and SOC Reports"]
[null,"Asset Management and System Diagrams"]
[null,"Network Authentication Controls"]
[null,"Access Provisioning"]
[null,"Access Deprovisioning"]
[null,"Periodic User Access Reviews"]
[null,"System Administration"]
[null,"Application Authentication"]
[null,"Periodic User Access Reviews"]
[null,"Access Provisioning"]
[null,"Access Deprovisioning"]
[null,"Application Administrator(s)"]
[null,"Segregation of Duties"]
[null,"Job Processing and Monitoring"]
[null,"Physical and Environmental Security"]
[null,"Malware Prevention and Detection"]
[null,"Firewall Maintenance"]
[null,"Wireless Security "]
[null,"Remote Access Security (Multifactor)"]
[null,"Inherent Risk Profile and Maturity"]
[null,"Incident Response Policy, Escalation and Reporting"]
[null,"Annual Information Security Training"]
[null,"Security Logging, Monitoring and Analysis"]
[null,"Data Loss Prevention Controls and Secure Transfer"]
[null,"Detection, Response and Mitigation"]
[null,"Mobile Equipment Encryption"]
[null,"Board and Senior Management Oversight"]
[null,"Business Continuity and Disaster Recovery Plan"]
[null,"Business Impact Analysis (BIA) and Risk Assessment"]
[null,"Business Continuity and Disaster Recovery Testing"]
[null,"Backup and Restoration Procedures"]
[null,"Change Management Standards and Methodologies"]
[null,"Change Documentation, Testing and Approvals"]
[null,"Segregation of Development and Production"]
[null,"Patch Management"]
[null,"Customer Enrollment, Awareness and Training"]
[null,"Logging and Monitoring"]
[]
["Other:"]
[]
[null,"CRA"]
[null,"HMDA Scrub"]
[null,"Flood Scrub"]
[null,"Fair Lending process"]
[null,"Loan Review"]

{"sheet":"Pricing Sheet","index":1,"n_rows":54,"n_cols":4,"rows_kept":54,"cut":false,"hidden":false,"merged":[[39,0,42,0],[50,0,53,0]]}
["Asset Size: ","Audit","Cost (to bank)","20% C/A Discount"]
["<150","BSA",5000,1000]
[null,"Deposits",5000,1000]
[null,"Lending",5000,1000]
[null,"ACH",5000,1000]
[null,"Internal Controls",5000,1000]
[null,"HMDA Scrub",10000,2000]
[null,"Flood Scrub",10000,2000]
[null,"Fair Lending process",10000,2000]
[null,"Loan Review",10000,2000]
[]
[]
["<300","BSA",7000,1400]
[null,"Deposits",7000,1400]
[null,"Lending",7000,1400]
[null,"ACH",7000,1400]
[null,"Internal Controls",7000,1400]
[null,"HMDA Scrub",15000,3000]
[null,"Flood Scrub",15000,3000]
[null,"Fair Lending process",15000,3000]
[null,"Loan Review",15000,3000]
[]
[]
["<500","BSA",9000,1800]
[null,"Deposits",9000,1800]
[null,"Lending",9000,1800]
[null,"ACH",9000,1800]
[null,"Internal Controls",9000,1800]
[null,"HMDA Scrub",20000,4000]
[null,"Flood Scrub",20000,4000]
[null,"Fair Lending process",20000,4000]
[null,"Loan Review",20000,4000]
[]
[]
["<750","BSA",11000,2200]
[null,"Deposits",11000,2200]
[null,"Lending",11000,2200]
[null,"ACH",11000,2200]
[null,"Internal Controls",11000,2200]
["Nothing bid at this level currently","HMDA Scrub",30000,6000]
[null,"Flood Scrub",30000,6000]
[null,"Fair Lending process",30000,6000]
[null,"Loan Review",30000,6000]
[]
[]
["<1B","BSA",13000,2600]
[null,"Deposits",13000,2600]
[null,"Lending",13000,2600]
[null,"ACH",13000,2600]
[null,"Internal Controls",13000,2600]
["Nothing bid at this level currently","HMDA Scrub",40000,8000]
[null,"Flood Scrub",40000,8000]
[null,"Fair Lending process",40000,8000]
[null,"Loan Review",40000,8000]

{"sheet":"Bid","index":2,"n_rows":7,"n_cols":4,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Scope and Price:"]
[]
["Bank Name:","Address:","State:","Price:"]
[]
[]
[]
["Scope:"]