{"text_format":"3","workbook":"xls","n_sheets":3,"sheets":["Totals Breakdown","Individual Transaction","Payment Method Totals"],"not_rendered":{"external_links":1,"defined_names":2},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Totals Breakdown","index":0,"n_rows":126,"n_cols":11,"rows_kept":126,"merged":[[0,0,0,4]],"flags":["formulas_cached_only"]}
["Audit Trail"]
["Begin Date","2014-07-01","to ","End Date","2021-06-23"]
["Sum of Amt"]
["Transaction Branch","Item Branch","Settlement","Fee Type","Total"]
["WONDER","WONDER","Paid","Fine",{"v":190.24999999999991,"d":"$190.25"},null,"Total Paid",{"v":4288.98,"d":"$4,288.98"},null,"Total Waived",{"v":0,"d":"$0.00"}]
[{"$nulls":3},"Lost",{"v":363.9,"d":"$363.90"},null,"Total Refund",{"v":37.95,"d":"$37.95"},null,"Total Cancelled",{"v":0,"d":"$0.00"}]
[{"$nulls":3},"Manual Fine",{"v":416.9000000000001,"d":"$416.90"},null,"Total(Paid-Refund)",{"v":4251.03,"d":"$4,251.03"}]
[{"$nulls":3},"Processing Fee",{"v":110,"d":"$110.00"}]
[null,null,"Paid Total",null,{"v":1081.05,"d":"$1,081.05"}]
[null,"WONDER Total",null,null,{"v":1081.05,"d":"$1,081.05"}]
[null,"CIRCEN","Refund","Manual Fine",{"v":1,"d":"$1.00"}]
[null,null,"Refund Total",null,{"v":1,"d":"$1.00"}]
[null,"CIRCEN Total",null,null,{"v":1,"d":"$1.00"}]
[null,"EDGWTR","Paid","Fine",{"v":0.55,"d":"$0.55"}]
[{"$nulls":3},"Manual Fine",{"v":15,"d":"$15.00"}]
[null,null,"Paid Total",null,{"v":15.55,"d":"$15.55"}]
[null,"EDGWTR Total",null,null,{"v":15.55,"d":"$15.55"}]
["WONDER Total",{"$nulls":3},{"v":1097.6,"d":"$1,097.60"}]
["EDGWTR","WONDER","Refund","Lost",{"v":16.95,"d":"$16.95"}]
[null,null,"Refund Total",null,{"v":16.95,"d":"$16.95"}]
[null,"WONDER Total",null,null,{"v":16.95,"d":"$16.95"}]
[null,"CIRCEN","Refund","Manual Fine",{"v":0.5,"d":"$0.50"}]
[null,null,"Refund Total",null,{"v":0.5,"d":"$0.50"}]
[null,"CIRCEN Total",null,null,{"v":0.5,"d":"$0.50"}]
[null,"EDGWTR","Paid","Fine",{"v":120.75,"d":"$120.75"}]
[{"$nulls":3},"Lost",{"v":296.93,"d":"$296.93"}]
[{"$nulls":3},"Manual Fine",{"v":213.68999999999997,"d":"$213.69"}]
[{"$nulls":3},"Processing Fee",{"v":126.5,"d":"$126.50"}]
[null,null,"Paid Total",null,{"v":757.87,"d":"$757.87"}]
[null,null,"Refund","Lost",{"v":10,"d":"$10.00"}]
[{"$nulls":3},"Processing Fee",{"v":9,"d":"$9.00"}]
[null,null,"Refund Total",null,{"v":19,"d":"$19.00"}]
[null,"EDGWTR Total",null,null,{"v":776.87,"d":"$776.87"}]
["EDGWTR Total",{"$nulls":3},{"v":794.3199999999999,"d":"$794.32"}]
["DISCO","EDGWTR","Paid","Fine",{"v":2.8499999999999996,"d":"$2.85"}]
[{"$nulls":3},"Manual Fine",{"v":0.7,"d":"$0.70"}]
[null,null,"Paid Total",null,{"v":3.55,"d":"$3.55"}]
[null,"EDGWTR Total",null,null,{"v":3.55,"d":"$3.55"}]
[null,"DISCO","Paid","Fine",{"v":196.35000000000002,"d":"$196.35"}]
[{"$nulls":3},"Lost",{"v":15,"d":"$15.00"}]
[{"$nulls":3},"Manual Fine",{"v":200.89,"d":"$200.89"}]
[{"$nulls":3},"Processing Fee",{"v":10,"d":"$10.00"}]
[null,null,"Paid Total",null,{"v":422.24,"d":"$422.24"}]
[null,"DISCO Total",null,null,{"v":422.24,"d":"$422.24"}]
["DISCO Total",{"$nulls":3},{"v":425.79,"d":"$425.79"}]
["CIRCEN","CIRCEN","Paid","Fine",{"v":71.14999999999999,"d":"$71.15"}]
[{"$nulls":3},"Lost",{"v":244.93,"d":"$244.93"}]
[{"$nulls":3},"Manual Fine",{"v":265.35,"d":"$265.35"}]
[{"$nulls":3},"Processing Fee",{"v":73,"d":"$73.00"}]
[null,null,"Paid Total",null,{"v":654.4300000000001,"d":"$654.43"}]
[null,"CIRCEN Total",null,null,{"v":654.4300000000001,"d":"$654.43"}]
["CIRCEN Total",{"$nulls":3},{"v":654.4300000000001,"d":"$654.43"}]
["AYERS","CIRCEN","Refund","Manual Fine",{"v":0.5,"d":"$0.50"}]
[null,null,"Refund Total",null,{"v":0.5,"d":"$0.50"}]
[null,"CIRCEN Total",null,null,{"v":0.5,"d":"$0.50"}]
[null,"AYERS","Paid","Fine",{"v":24.3,"d":"$24.30"}]
[{"$nulls":3},"Lost",{"v":15,"d":"$15.00"}]
[{"$nulls":3},"Manual Fine",{"v":265.95000000000005,"d":"$265.95"}]
[{"$nulls":3},"Processing Fee",{"v":10,"d":"$10.00"}]
[null,null,"Paid Total",null,{"v":315.25000000000006,"d":"$315.25"}]
[null,"AYERS Total",null,null,{"v":315.25000000000006,"d":"$315.25"}]
["AYERS Total",{"$nulls":3},{"v":315.75000000000006,"d":"$315.75"}]
["WVERLY","EDGWTR","Paid","Manual Fine",{"v":3,"d":"$3.00"}]
[null,null,"Paid Total",null,{"v":3,"d":"$3.00"}]
[null,"EDGWTR Total",null,null,{"v":3,"d":"$3.00"}]
[null,"WVERLY","Paid","Fine",{"v":29.000000000000004,"d":"$29.00"}]
[{"$nulls":3},"Manual Fine",{"v":56.699999999999996,"d":"$56.70"}]
[{"$nulls":3},"Processing Fee",{"v":10,"d":"$10.00"}]
[null,null,"Paid Total",null,{"v":95.7,"d":"$95.70"}]
[null,"WVERLY Total",null,null,{"v":95.7,"d":"$95.70"}]
["WVERLY Total",{"$nulls":3},{"v":98.69999999999999,"d":"$98.70"}]
["VRTUAL","EDGWTR","Paid","Fine",{"v":71.35000000000001,"d":"$71.35"}]
[{"$nulls":3},"Manual Fine",{"v":203.8,"d":"$203.80"}]
[null,null,"Paid Total",null,{"v":275.15000000000003,"d":"$275.15"}]
[null,"EDGWTR Total",null,null,{"v":275.15000000000003,"d":"$275.15"}]
[null,"VRTUAL","Paid","Manual Fine",{"v":11.25,"d":"$11.25"}]
[null,null,"Paid Total",null,{"v":11.25,"d":"$11.25"}]
[null,"VRTUAL Total",null,null,{"v":11.25,"d":"$11.25"}]
["VRTUAL Total",{"$nulls":3},{"v":286.40000000000003,"d":"$286.40"}]
["SPAROW","SPAROW","Paid","Fine",{"v":47.55,"d":"$47.55"}]
[{"$nulls":3},"Manual Fine",{"v":16.7,"d":"$16.70"}]
[null,null,"Paid Total",null,{"v":64.25,"d":"$64.25"}]
[null,"SPAROW Total",null,null,{"v":64.25,"d":"$64.25"}]
["SPAROW Total",{"$nulls":3},{"v":64.25,"d":"$64.25"}]
["SHEPRD","SHEPRD","Paid","Fine",{"v":27.549999999999997,"d":"$27.55"}]
[{"$nulls":3},"Manual Fine",{"v":40.75,"d":"$40.75"}]
[null,null,"Paid Total",null,{"v":68.3,"d":"$68.30"}]
[null,"SHEPRD Total",null,null,{"v":68.3,"d":"$68.30"}]
["SHEPRD Total",{"$nulls":3},{"v":68.3,"d":"$68.30"}]
["MIDCIT","EDGWTR","Paid","Manual Fine",{"v":15,"d":"$15.00"}]
[null,null,"Paid Total",null,{"v":15,"d":"$15.00"}]
[null,"EDGWTR Total",null,null,{"v":15,"d":"$15.00"}]
[null,"MIDCIT","Paid","Fine",{"v":24.5,"d":"$24.50"}]
[{"$nulls":3},"Manual Fine",{"v":108.89999999999999,"d":"$108.90"}]
[null,null,"Paid Total",null,{"v":133.39999999999998,"d":"$133.40"}]
[null,"MIDCIT Total",null,null,{"v":133.39999999999998,"d":"$133.40"}]
["MIDCIT Total",{"$nulls":3},{"v":148.39999999999998,"d":"$148.40"}]
["HOMETN","HOMETN","Paid","Fine",{"v":15.95,"d":"$15.95"}]
[{"$nulls":3},"Manual Fine",{"v":44.75,"d":"$44.75"}]
[null,null,"Paid Total",null,{"v":60.7,"d":"$60.70"}]
[null,"HOMETN Total",null,null,{"v":60.7,"d":"$60.70"}]
["HOMETN Total",{"$nulls":3},{"v":60.7,"d":"$60.70"}]
["NORTHN","EDGWTR","Paid","Fine",{"v":18.180000000000003,"d":"$18.18"}]
[{"$nulls":3},"Manual Fine",{"v":89.99000000000001,"d":"$89.99"}]
[null,null,"Paid Total",null,{"v":108.17000000000002,"d":"$108.17"}]
[null,"EDGWTR Total",null,null,{"v":108.17000000000002,"d":"$108.17"}]
[null,"NORTHN","Paid","Fine",{"v":75.70000000000002,"d":"$75.70"}]
[{"$nulls":3},"Manual Fine",{"v":48.69999999999999,"d":"$48.70"}]
[null,null,"Paid Total",null,{"v":124.4,"d":"$124.40"}]
[null,"NORTHN Total",null,null,{"v":124.4,"d":"$124.40"}]
["NORTHN Total",{"$nulls":3},{"v":232.57000000000002,"d":"$232.57"}]
["PICKWK","PICKWK","Paid","Fine",{"v":16.15,"d":"$16.15"}]
[{"$nulls":3},"Manual Fine",{"v":56.550000000000004,"d":"$56.55"}]
[null,null,"Paid Total",null,{"v":72.7,"d":"$72.70"}]
[null,"PICKWK Total",null,null,{"v":72.7,"d":"$72.70"}]
["PICKWK Total",{"$nulls":3},{"v":72.7,"d":"$72.70"}]
["SAPL","EDGWTR","Paid","Fine",{"v":2.5500000000000003,"d":"$2.55"}]
[{"$nulls":3},"Manual Fine",{"v":1.05,"d":"$1.05"}]
[null,null,"Paid Total",null,{"v":3.6000000000000005,"d":"$3.60"}]
[null,"EDGWTR Total",null,null,{"v":3.6000000000000005,"d":"$3.60"}]
["SAPL Total",{"$nulls":3},{"v":3.6000000000000005,"d":"$3.60"}]
["FRANK","EDGWTR","Paid","Fine",{"v":3.42,"d":"$3.42"}]
[null,null,"Paid Total",null,{"v":3.42,"d":"$3.42"}]
[null,"EDGWTR Total",null,null,{"v":3.42,"d":"$3.42"}]
["FRANK Total",{"$nulls":3},{"v":3.42,"d":"$3.42"}]
["Grand Total",{"$nulls":3},{"v":4326.93,"d":"$4,326.93"}]

{"sheet":"Individual Transaction","index":1,"n_rows":2,"n_cols":7,"rows_kept":2,"merged":[[0,0,0,12]],"flags":["formulas_cached_only"]}
["Audit Trail"]
[null,null,"Begin Date","2014-07-01","to","End Date","2021-06-23"]

{"sheet":"Payment Method Totals","index":2,"n_rows":64,"n_cols":5,"rows_kept":64,"merged":[[0,0,0,3]],"flags":["formulas_cached_only"]}
["Audit Trail"]
["Begin Date","2014-07-01","to ","End Date","2021-06-23"]
["Sum of Amt"]
["Transaction Branch","Payment Method","Fee Type","Total"]
["WONDER","Cash",null,{"v":912.1999999999999,"d":"$912.20"}]
[null,"Check",null,{"v":35.5,"d":"$35.50"}]
[null,"Credit Card",null,{"v":5,"d":"$5.00"}]
[null,"Invalid","Paid",{"v":143.89999999999998,"d":"$143.90"}]
[null,null,"Refund",{"v":1,"d":"$1.00"}]
[null,"Invalid Total",null,{"v":144.89999999999998,"d":"$144.90"}]
["WONDER Total",null,null,{"v":1097.6,"d":"$1,097.60"}]
["EDGWTR","Cash",null,{"v":598.13,"d":"$598.13"}]
[null,"Credit Card",null,{"v":12.5,"d":"$12.50"}]
[null,"Invalid","Paid",{"v":147.24,"d":"$147.24"}]
[null,null,"Refund",{"v":36.45,"d":"$36.45"}]
[null,"Invalid Total",null,{"v":183.69,"d":"$183.69"}]
["EDGWTR Total",null,null,{"v":794.32,"d":"$794.32"}]
["DISCO","Credit Card",null,{"v":422.24,"d":"$422.24"}]
[null,"Invalid","Paid",{"v":3.55,"d":"$3.55"}]
[null,"Invalid Total",null,{"v":3.55,"d":"$3.55"}]
["DISCO Total",null,null,{"v":425.79,"d":"$425.79"}]
["CIRCEN","Cash",null,{"v":539.03,"d":"$539.03"}]
[null,"Invalid","Paid",{"v":115.4,"d":"$115.40"}]
[null,"Invalid Total",null,{"v":115.4,"d":"$115.40"}]
["CIRCEN Total",null,null,{"v":654.43,"d":"$654.43"}]
["AYERS","Cash",null,{"v":80.15,"d":"$80.15"}]
[null,"Credit Card",null,{"v":25,"d":"$25.00"}]
[null,"Invalid","Paid",{"v":210.10000000000002,"d":"$210.10"}]
[null,null,"Refund",{"v":0.5,"d":"$0.50"}]
[null,"Invalid Total",null,{"v":210.60000000000002,"d":"$210.60"}]
["AYERS Total",null,null,{"v":315.75,"d":"$315.75"}]
["WVERLY","Cash",null,{"v":13,"d":"$13.00"}]
[null,"Invalid","Paid",{"v":85.7,"d":"$85.70"}]
[null,"Invalid Total",null,{"v":85.7,"d":"$85.70"}]
["WVERLY Total",null,null,{"v":98.7,"d":"$98.70"}]
["VRTUAL","Credit Card",null,{"v":286.3999999999999,"d":"$286.40"}]
["VRTUAL Total",null,null,{"v":286.3999999999999,"d":"$286.40"}]
["SPAROW","Cash",null,{"v":47.4,"d":"$47.40"}]
[null,"Invalid","Paid",{"v":16.85,"d":"$16.85"}]
[null,"Invalid Total",null,{"v":16.85,"d":"$16.85"}]
["SPAROW Total",null,null,{"v":64.25,"d":"$64.25"}]
["SHEPRD","Invalid","Paid",{"v":68.3,"d":"$68.30"}]
[null,"Invalid Total",null,{"v":68.3,"d":"$68.30"}]
["SHEPRD Total",null,null,{"v":68.3,"d":"$68.30"}]
["MIDCIT","Credit Card",null,{"v":5,"d":"$5.00"}]
[null,"Invalid","Paid",{"v":143.3999999999999,"d":"$143.40"}]
[null,"Invalid Total",null,{"v":143.3999999999999,"d":"$143.40"}]
["MIDCIT Total",null,null,{"v":148.3999999999999,"d":"$148.40"}]
["HOMETN","Invalid","Paid",{"v":60.7,"d":"$60.70"}]
[null,"Invalid Total",null,{"v":60.7,"d":"$60.70"}]
["HOMETN Total",null,null,{"v":60.7,"d":"$60.70"}]
["NORTHN","Invalid","Paid",{"v":232.57,"d":"$232.57"}]
[null,"Invalid Total",null,{"v":232.57,"d":"$232.57"}]
["NORTHN Total",null,null,{"v":232.57,"d":"$232.57"}]
["PICKWK","Invalid","Paid",{"v":72.70000000000002,"d":"$72.70"}]
[null,"Invalid Total",null,{"v":72.70000000000002,"d":"$72.70"}]
["PICKWK Total",null,null,{"v":72.70000000000002,"d":"$72.70"}]
["SAPL","Invalid","Paid",{"v":3.6,"d":"$3.60"}]
[null,"Invalid Total",null,{"v":3.6,"d":"$3.60"}]
["SAPL Total",null,null,{"v":3.6,"d":"$3.60"}]
["FRANK","Invalid","Paid",{"v":3.42,"d":"$3.42"}]
[null,"Invalid Total",null,{"v":3.42,"d":"$3.42"}]
["FRANK Total",null,null,{"v":3.42,"d":"$3.42"}]
["Grand Total",null,null,{"v":4326.93,"d":"$4,326.93"}]