{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Banking Services","Retail Lockbox","ECR Interest"],"not_rendered":{"defined_names":4},"read":"whole","date_system":"1900"}

{"sheet":"Banking Services","index":0,"n_rows":116,"n_cols":7,"rows_kept":116,"merged":[[2,2,2,6]]}
[{"$f":"A103","v":0}]
[]
["INDIAN RIVER COUNTY, FLORIDA",null,"EXHIBIT \"A\""]
["BANKING AND LOCKBOX SERVICES PROPOSAL"]
["Volume Analysis - Cost Proposal"]
[]
["The undersigned, as PROPOSER, declares that he/she has reviewed the RFP specifications for the scope of the services; has read all special provisions furnished prior to the opening of the responses; and he/she is satisfied relative to the work to be performed."]
[]
["The PROPOSER proposes the following fees:"]
[null,null,"Annual",{"$nulls":3},"Total"]
[null,null,"Volume",null,"Per Item ",null,"Annual"]
[null,null,"Totals",null,"Cost",null,"Cost"]
["GENERAL ACCOUNT SERVICES"]
["ACCOUNT MAINTENANCE - 8 ACCOUNTS",null,{"v":96,"d":"96 "},{"$nulls":3},{"$f":"+C14*E14","v":{"v":0,"d":"$0.00"}}]
["ZBA PARENT ACCOUNT",null,{"v":12,"d":"12 "},{"$nulls":3},{"$f":"+C15*E15","v":{"v":0,"d":"$0.00"}}]
["ZBA SUB ACCOUNT",null,{"v":72,"d":"72 "},{"$nulls":3},{"$f":"+C16*E16","v":{"v":0,"d":"$0.00"}}]
[]
[]
["DEPOSITORY SERVICES"]
["DEPOSITS PROCESSED",null,{"v":6906,"d":"6,906 "},{"$nulls":3},{"$f":"+C20*E20","v":{"v":0,"d":"$0.00"}}]
["CHECKS DEPOSITED",null,{"v":28491,"d":"28,491 "},{"$nulls":3},{"v":0,"d":"$0.00"}]
["REMOTE DEPOSIT CAPTURE PER ITEM FEE",null,{"v":6522,"d":"6,522 "},{"$nulls":3},{"v":0,"d":"$0.00"}]
["CHECKS PAID                          ",null,{"v":16497,"d":"16,497 "},{"$nulls":3},{"v":0,"d":"$0.00"}]
["DIGITAL EXPRESS DEPOSIT CORRECTION",null,{"v":4,"d":"4 "},{"$nulls":3},{"v":0,"d":"$0.00"}]
["REMOTE DEPOSIT CAPTURE MAINTENANCE",null,{"v":12,"d":"12 "},{"$nulls":3},{"v":0,"d":"$0.00"}]
["REMOTE DEPOSIT CAPTURE -ADDL SCANNER",null,{"v":12,"d":"12 "},{"$nulls":3},{"v":0,"d":"$0.00"}]
[]
[]
["SUPPLIES"]
["DISPOSABLE NIGHT BAGS",null,{"v":3000,"d":"3,000"},{"$nulls":3},{"$f":"+C30*E30","v":{"v":0,"d":"$0.00"}}]
["DEPOSIT TICKETS (3-Part)",null,{"v":6000,"d":"6,000"},{"$nulls":3},{"$f":"+C31*E31","v":{"v":0,"d":"$0.00"}}]
[]
[]
["PAPER DISBURSEMENT SERVICES"]
["POSITIVE PAY ONLY - PER CHECK ISSUED",null,{"v":0,"d":"0 "},{"$nulls":3},{"$f":"+C35*E35","v":{"v":0,"d":"$0.00"}}]
["RETURN DEPOSITED ITEM - FINAL PRESENTMENT",null,{"v":41,"d":"41 "},{"$nulls":3},{"$f":"+C36*E36","v":{"v":0,"d":"$0.00"}}]
[]
[]
["ACCOUNT RECONCILEMENT"]
["FULL CHECK BLOCK POSITIVE PAY",null,{"v":36,"d":"36 "},{"$nulls":3},{"$f":"+C40*E40","v":{"v":0,"d":"$0.00"}}]
["PAYEE POS PAY MONTHLY MAINT",null,{"v":60,"d":"60 "},{"$nulls":3},{"v":0,"d":"$0.00"}]
["ARP PAID ITEMS",null,{"v":16503,"d":"16,503 "},{"$nulls":3},{"v":0,"d":"$0.00"}]
["ARP-PD/DEP ITEM OUTPUT FILE",null,{"v":12,"d":"12 "},{"$nulls":3},{"v":0,"d":"$0.00"}]
["POSITIVE PAY MAINTENANCE - 5 ACCOUNTS",null,{"v":60,"d":"60 "},{"$nulls":3},{"v":0,"d":"$0.00"}]
["ARP ISSUE FILE TRANSMISSION",null,{"v":120,"d":"120 "},{"$nulls":3},{"v":0,"d":"$0.00"}]
["PAID/DEPOSITED ITEM OUTPUT FILE",null,{"v":31,"d":"31 "},{"$nulls":3},{"v":0,"d":"$0.00"}]
[]
[]
["GENERAL ACH SERVICES"]
["ACH RECEIVED CREDITS",null,{"v":6302.000000000001,"d":"6,302 "},{"$nulls":3},{"$f":"+C50*E50","v":{"v":0,"d":"$0.00"}}]
["ACH RECEIVED DEBITS",null,{"v":1231,"d":"1,231 "},{"$nulls":3},{"v":0,"d":"$0.00"}]
["ACH RETURNED ITEM",null,{"v":675,"d":"675 "},{"$nulls":3},{"v":0,"d":"$0.00"}]
["ACH DEBIT BLOCK ",null,{"v":60,"d":"60 "},{"$nulls":3},{"v":0,"d":"$0.00"}]
["ACH POSITIVE PAY ",null,{"v":36,"d":"36 "},{"$nulls":3},{"v":0,"d":"$0.00"}]
["ACH FILTER",null,{"v":515,"d":"515 "},{"$nulls":3},{"v":0,"d":"$0.00"}]
["ACH NOTIFICATIONS OF CHANGE",null,{"v":1863,"d":"1,863 "},{"$nulls":3},{"v":0,"d":"$0.00"}]
[]
[]
["WIRE & OTHER FUNDS TRANSFER SERVICE"]
["WIRE IN DOMESTIC                         ",null,208,{"$nulls":3},{"$f":"+C60*E60","v":{"v":0,"d":"$0.00"}}]
["WIRE IN DOMESTIC EXCEPTION           ",null,16,{"$nulls":3},{"$f":"+C61*E61","v":{"v":0,"d":"$0.00"}}]
["WIRE IN FOREIGN",null,0,{"$nulls":3},{"$f":"+C62*E62","v":{"v":0,"d":"$0.00"}}]
["WIRE-OUTGOING DOMESTIC",null,84,{"$nulls":3},{"$f":"+C63*E63","v":{"v":0,"d":"$0.00"}}]
[]
[]
["INFORMATION SERVICES"]
["ONLINE BANKING MONTHLY MAINTENANCE FEE",null,12,{"$nulls":3},{"$f":"+C67*E67","v":{"v":0,"d":"$0.00"}}]
["ONLINE BANKING TRANSACTION RECORD",null,{"$f":"32578+250*12","v":{"v":35578,"d":"35,578"}},{"$nulls":3},{"v":0,"d":"$0.00"}]
["TD E-TREASURY BALANCE REPORTING ACCOUNTS",null,{"$f":"96+2*12","v":120},{"$nulls":3},{"v":0,"d":"$0.00"}]
["ONLINE BANKING SECURITY TOKEN",null,330,{"$nulls":3},{"v":0,"d":"$0.00"}]
["ONLINE BANKING ACH BATCH INITIATED",null,856,{"$nulls":3},{"v":0,"d":"$0.00"}]
["ONLINE BANKING STOP PAYMENT",null,4,{"$nulls":3},{"v":0,"d":"$0.00"}]
["ONLINE BANKING BOOK TRANSFER ",null,13,{"$nulls":3},{"v":0,"d":"$0.00"}]
["ONLINE BANKING -  ACH INITIATED                ",null,{"v":237814,"d":"237,814"},{"$nulls":3},{"v":0,"d":"$0.00"}]
["ONLINE BANKING -  ACH ADDENDA RECORD INITIATED                ",null,25,{"$nulls":3},{"v":0,"d":"$0.00"}]
["ONLINE BANKING - ACH TRANSACTION REVERSAL",null,2,{"$nulls":3},{"v":0,"d":"$0.00"}]
["ONLINE BANKING - ISSUE/CANCEL TRANSACTIONS",null,4,{"$nulls":3},{"v":0,"d":"$0.00"}]
[]
[]
[]
[]
[]
["OTHER SERVICE FEES NOT LISTED (PLEASE SPECIFY):"]
{"$rows_empty":10}
["TOTAL ANNUALSERVICES COST:",{"$nulls":5},{"$f":"-SUM(G14:G92)","v":{"v":0,"d":"$0.00"}}]
[]
[]
[]
[]
[]
["The undersigned hereby certifies that they have read and understand the contents of this solicitation and agree to furnish at the prices shown above all of the services specified in the RFP document, subject to all instructions, conditions, specifications, and attachments hereto.  Failure to have read all the provisions of this solicitation shall not be cause to alter any resulting contract or additional compensation."]
[]
["Name of Firm:"]
[]
["Address:"]
[]
[]
[]
["Phone Number:"]
[]
["Email:"]
[]
["Authorized Signature:"]
[]
["Title:"]
[]
["Date Signed:"]

{"sheet":"Retail Lockbox","index":1,"n_rows":103,"n_cols":7,"rows_kept":103,"merged":[[2,2,2,6]]}
[{"$f":"'Banking Services'!A103","v":0}]
[]
["INDIAN RIVER COUNTY, FLORIDA",null,"EXHIBIT \"A\""]
["BANKING AND LOCKBOX SERVICES PROPOSAL"]
["Retail Lockbox"]
[]
[null,null,"Annual",{"$nulls":3},"Total"]
[null,null,"Volume",null,"Per Item ",null,"Annual"]
[null,null,"Totals",null,"Cost",null,"Cost"]
["RETAIL LOCKBOX (RLB) SERVICES"]
["Deposit Administrative Fee - Monthly ",null,12,{"$nulls":3},{"$f":"+C11*E11","v":{"v":0,"d":"$0.00"}}]
["Account Maintenace",null,12,{"$nulls":3},{"v":0,"d":"$0.00"}]
["Return Item",null,72,{"$nulls":3},{"v":0,"d":"$0.00"}]
["Electronic Debits",null,29,{"$nulls":3},{"v":0,"d":"$0.00"}]
["Electronic Credits",null,250,{"$nulls":3},{"v":0,"d":"$0.00"}]
["Checks Paid - Debits",null,19,{"$nulls":3},{"v":0,"d":"$0.00"}]
["Deposits - Credits",null,{"v":1480,"d":"1,480"},{"$nulls":3},{"v":0,"d":"$0.00"}]
["Items Deposited on Us",null,273,{"$nulls":3},{"v":0,"d":"$0.00"}]
["Items Deposited Local",null,262,{"$nulls":3},{"v":0,"d":"$0.00"}]
["Items Deposited Regional",null,{"v":30010,"d":"30,010"},{"$nulls":3},{"v":0,"d":"$0.00"}]
["Items Deposited Other Fed",null,{"v":57876,"d":"57,876"},{"$nulls":3},{"v":0,"d":"$0.00"}]
["Wire Outgoing",null,15,{"$nulls":3},{"v":0,"d":"$0.00"}]
["ACH Alert Monthly Maint",null,12,{"$nulls":3},{"v":0,"d":"$0.00"}]
["ACH Alert Account Fee",null,12,{"$nulls":3},{"v":0,"d":"$0.00"}]
["Detail Trans Per Item",null,{"$f":"2410+500*12","v":{"v":8410,"d":"8,410"}},{"$nulls":3},{"v":0,"d":"$0.00"}]
["Previous Day Information",null,36,{"$nulls":3},{"v":0,"d":"$0.00"}]
["RDI Report",null,9,{"$nulls":3},{"v":0,"d":"$0.00"}]
["No Check Pos Pay Per Acct",null,12,{"$nulls":3},{"v":0,"d":"$0.00"}]
["RLB Monthly Maintenance",null,12,{"$nulls":3},{"v":0,"d":"$0.00"}]
["RLB Per Item Fee",null,{"v":88413,"d":"88,413"},{"$nulls":3},{"v":0,"d":"$0.00"}]
["RLB Per Item Fee-CIE Payments",null,{"v":80954,"d":"80,954"},{"$nulls":3},{"v":0,"d":"$0.00"}]
["RLB Multi Coupons/Checks",null,{"v":2153,"d":"2,153"},{"$nulls":3},{"v":0,"d":"$0.00"}]
["RLB No Payment Coupon w/Check",null,{"v":10126,"d":"10,126"},{"$nulls":3},{"v":0,"d":"$0.00"}]
["RLB Unprocessable Item",null,237,{"$nulls":3},{"v":0,"d":"$0.00"}]
["RLB Cash Payments",null,2,{"$nulls":3},{"v":0,"d":"$0.00"}]
["RLB Data Transmission",null,249,{"$nulls":3},{"v":0,"d":"$0.00"}]
["RLB Exception Monthly Maintenance",null,12,{"$nulls":3},{"v":0,"d":"$0.00"}]
["RLB Exception Decision Per Item",null,{"v":3471,"d":"3,471"},{"$nulls":3},{"v":0,"d":"$0.00"}]
["RLB Image Monthly Maintenance",null,12,{"$nulls":3},{"$f":"+C39*E39","v":{"v":0,"d":"$0.00"}}]
[]
[]
["TOTAL ANNUAL LOCKBOX COST:",{"$nulls":5},{"$f":"SUM(G11:G41)","v":{"v":0,"d":"$0.00"}}]
{"$rows_empty":60}
["Bob"]

{"sheet":"ECR Interest","index":2,"n_rows":103,"n_cols":3,"rows_kept":103,"merged":[[2,2,2,6]]}
[{"$f":"'Banking Services'!A103","v":0}]
[]
["INDIAN RIVER COUNTY, FLORIDA",null,"EXHIBIT \"A\""]
["BANKING AND LOCKBOX SERVICES PROPOSAL"]
["Earnings Credit and Interest"]
[]
["Please complete the following table to indicate the proposed interest/earnings rate calculation."]
[]
[]
["County Average Daily Balance",null,{"v":24000000,"d":"$24,000,000"}]
[]
["Reserve Requirement"]
[]
["Balance Upon Which Credit will be Based"]
[]
["Earnings Credit Rate"]
[]
["Floor Rate for Earnings Credit"]
[]
["Interest Rate"]
[]
["Floor Interest Rate"]
{"$rows_empty":80}
["Bob"]