{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["Contact and Other Information","ContactData","Program","ProgramData","Performance","PerformanceData","Annual Financial Report","AFRData","Performance Metrics","Quality Checklist ","Transfer Worksheet","Categories","Code","Best Practices"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":2,"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":"Contact and Other Information","index":0,"n_rows":43,"n_cols":12,"rows_kept":43,"cut":false,"hidden":false,"merged":[[19,8,20,8],[23,6,23,9],[0,1,0,7],[11,1,13,2],[18,0,18,3],[17,1,17,3],[11,0,13,0],[3,0,5,0],[7,0,9,0],[19,1,19,3],[22,1,22,3],[23,1,23,3],[20,1,20,3],[21,1,21,3],[27,1,27,3],[28,1,28,3],[24,8,27,8],[33,6,33,9],[32,1,32,3],[33,1,33,3],[28,6,28,9],[29,6,29,9],[30,6,30,9],[31,6,31,9],[29,1,29,3],[30,1,30,3],[31,1,31,3],[24,1,24,3],[25,1,25,3],[26,1,26,3],[38,1,38,3],[36,1,36,3],[34,6,34,9],[34,1,34,3],[35,1,35,3]]}
[]
[1,"Court/County",null,null,null,null,null,null,null,null,{"$f":"INDEX(Code!B1:B59,L2)","v":"Select court/county (see Contact Information worksheet #1)"},1]
[]
[2,"Court Contact:"]
[null,"Telephone Number:"]
[null,"E-mail Address:"]
[null,null,null," "]
[3,"County Contact:"]
[null,"Telephone Number:"]
[null,"E-mail Address:"]
[]
[4,"List collection agencies or programs used by order in which debt is referred:",null,"1.",null,null,null,null,null,null,{"$f":"INDEX(Code!$G$1:$G$7,L12)","v":" "},1]
[null,null,null,2,null,null,null,null,null,null,{"$f":"INDEX(Code!$G$1:$G$7,L13)","v":" "},1]
[null,null,null,"3.",null,null,null,null,null,null,{"$f":"INDEX(Code!$G$1:$G$7,L14)","v":" "},1]
[null,null,null,"4.",null,null,null,null,null,null,{"$f":"INDEX(Code!$G$1:$G$7,L15)","v":" "},1]
[null,null,null,"5.",null,null,null,null,null,null,{"$f":"INDEX(Code!$G$1:$G$7,L16)","v":" "},1]
[]
[5,null,null,null,"     Item 4",null,"Item 5","Item 6a ","Item 6b","Item 7"]
["Below is a description of the collections components (activities) authorized by Penal Code section 1463.007.  As required by Government Code section 68514, for Items 4, 5, 6a, 6b and 7, input the requested information for each collection activity  that the court/county program currently uses:  ",null,null,null,"Check each collections activity performed by program ","Category","Total amount collected per collection activity","Total number of cases by activity ","Total number of individuals associated with those cases","Total administrative cost per collection activity"]
[6,"a. Attempts telephone contact with delinquent debtors for whom the program has a telephone number to inform them of their delinquent status and payment options.",null,null,null,1,null,null,"Enter data as part of Category 3, (activity c)",null,false]
[7,"b. Notifies delinquent debtors for whom the program has an address in writing of their outstanding obligation within 95 days of delinquency.",null,null,null,2,null,null,null,null,false]
[8,"c. Generates internal monthly reports to track collections data, such as age of debt and delinquent amounts outstanding.",null,null,null,3,null,null,null,null,false]
[9,"d. Uses Department of Motor Vehicles information to locate delinquent debtors.",null,null,null,4,null,null,null,null,false]
[10,"e. Accepts payment of delinquent debt by credit card.",null,null,null,3,"Enter data as part of Category 3, (activity c), Row 8 above. ",null,null,null,false]
[11,"a. Sends delinquent debt to the Franchise Tax Board's Court-Ordered Debt Collections Program.",null,null,null,5,null,null,null,null,false]
[12,"b. Sends delinquent debt to the Franchise Tax Board's Interagency Intercept Collections Program.",null,null,null,6,null,null,null,null,false]
[13,"c. Initiates driver's license suspension or hold actions when appropriate for a failure to appear in court.",null,null,null,7,null,null,null,null,false]
[14,"d. Contracts with one or more private debt collectors to collect delinquent debt.",null,null,null,8,null,null,null,null,false]
[15,"e. Sends monthly bills or account statements to all delinquent debtors.",null,null,null,2,"Enter data as part of Category 2 (activity b), Row 7 above.",null,null,null,false]
[16,"f. Contracts with local, regional, state, or national skip tracing or locator resources or services to locate delinquent debtors.",null,null,null,4,"Enter data as part of Category 4, (activity d) in Row 9 above.",null,null,null,false]
[17,"g. Coordinates with the probation department to locate debtors who may be on formal or informal probation.",null,null,null,4,"Enter data as part of Category 4, (activity d)  in Row 9 above. ",null,null,null,false]
[18,"h. Uses Employment Development Department employment and wage information to collect delinquent debt.",null,null,null,4,"Enter data part of Category 4, (activity d) Row 9 above. ",null,null,null,false]
[19,"i. Establishes wage and bank account garnishments where appropriate.",null,null,null,9,null,null,null,null,false]
[20,"j. Places liens on real property owned by delinquent debtors when appropriate.",null,null,null,9,"Enter data as part of Category 9, (activity i) Row 19 above. ",null,null,null,false]
[21,"k. Uses an automated dialer or automatic call distribution system to manage telephone calls.",null,null,null,1,"Enter data as part of Category 1, (activity a) Row 6 above. ",null,null,null,false]
[22,"TOTAL:",null,null,null,null,{"$f":"SUM(G20+G21+G22+G23+G25+G26+G27+G28+G33)","v":0},{"$f":"SUM(H20+H21+H22+H23+H25+H26+H27+H28+H33)","v":0},{"$f":"I22","v":0},{"$f":"SUM(J20+J21+J22+J23+J25+J26+J27+J28+J33)","v":0}]
[]
[]
[null,"Category Key: (See Category tab for task/activities list)"]
[null,"1= Telephone Contact","4= Skip tracing","7= DL Hold"]
[null,"2= Written Notice(s)","5= FTB-COD","8= Private agency"]
[null,"3= Lobby/counter","6= FTB-IIC","9= Wage/bank garnishments and Liens"]
[null,"Is the program qualified as a comprehensive collection program?",null,null,null,null,null,{"$f":"IF((COUNTIF($K$20:$K$24,TRUE)=5) * (COUNTIF($K$25:$K$34,TRUE)>=5),\"Yes\", \"No\")","v":"No"}]

{"sheet":"ContactData","index":1,"n_rows":14,"n_cols":18,"rows_kept":14,"cut":false,"hidden":true,"merged":[]}
["Contact Information"]
["Court-County","CourtContact","CourtPhone","CourtEmail","CountyContact","CountyPhone","CountyEmail","Agency1","Agency2","Agency3","Agency4","Agency5"]
[{"$f":"'Contact and Other Information'!$K$2","v":"Select court/county (see Contact Information worksheet #1)"},{"$f":"IF('Contact and Other Information'!$C$4=\"\",\"N/A\",'Contact and Other Information'!$C$4)","v":"N/A"},{"$f":"IF('Contact and Other Information'!$C$5=\"\",\"N/A\",'Contact and Other Information'!$C$5)","v":"N/A"},{"$f":"IF('Contact and Other Information'!$C$6=\"\",\"N/A\",'Contact and Other Information'!$C$6)","v":"N/A"},{"$f":"IF('Contact and Other Information'!$C$8=\"\",\"N/A\",'Contact and Other Information'!$C$8)","v":"N/A"},{"$f":"IF('Contact and Other Information'!$C$9=\"\",\"N/A\",'Contact and Other Information'!$C$9)","v":"N/A"},{"$f":"IF('Contact and Other Information'!$C$10=\"\",\"N/A\",'Contact and Other Information'!$C$10)","v":"N/A"},{"$f":"IF('Contact and Other Information'!$K$12=\" \",\"N/A\",'Contact and Other Information'!$K$12)","v":"N/A"},{"$f":"IF('Contact and Other Information'!$K$13=\" \",\"N/A\",'Contact and Other Information'!$K$13)","v":"N/A"},{"$f":"IF('Contact and Other Information'!$K$14=\" \",\"N/A\",'Contact and Other Information'!$K$14)","v":"N/A"},{"$f":"IF('Contact and Other Information'!$K$15=\" \",\"N/A\",'Contact and Other Information'!$K$15)","v":"N/A"},{"$f":"IF('Contact and Other Information'!$K$16=\" \",\"N/A\",'Contact and Other Information'!$K$16)","v":"N/A"}]
[]
[]
["ActivityPerformed"]
["Activity1","Activity2","Activity3","Activity4","Activity5","Activity6","Activity7","Activity8","Activity9","Activity10","Activity11","Activity12","Activity13","Activity14","Activity15","Activity16","Comprehensive?","ActivityCount"]
[{"$f":"IF('Contact and Other Information'!$K$20=TRUE,1,0)","v":0},{"$f":"IF('Contact and Other Information'!$K$21=TRUE,1,0)","v":0},{"$f":"IF('Contact and Other Information'!$K$22=TRUE,1,0)","v":0},{"$f":"IF('Contact and Other Information'!$K$23=TRUE,1,0)","v":0},{"$f":"IF('Contact and Other Information'!$K$24=TRUE,1,0)","v":0},{"$f":"IF('Contact and Other Information'!$K$25=TRUE,1,0)","v":0},{"$f":"IF('Contact and Other Information'!$K$26=TRUE,1,0)","v":0},{"$f":"IF('Contact and Other Information'!$K$27=TRUE,1,0)","v":0},{"$f":"IF('Contact and Other Information'!$K$28=TRUE,1,0)","v":0},{"$f":"IF('Contact and Other Information'!$K$29=TRUE,1,0)","v":0},{"$f":"IF('Contact and Other Information'!$K$30=TRUE,1,0)","v":0},{"$f":"IF('Contact and Other Information'!$K$31=TRUE,1,0)","v":0},{"$f":"IF('Contact and Other Information'!$K$32=TRUE,1,0)","v":0},{"$f":"IF('Contact and Other Information'!$K$33=TRUE,1,0)","v":0},{"$f":"IF('Contact and Other Information'!$K$34=TRUE,1,0)","v":0},{"$f":"IF('Contact and Other Information'!$K$35=TRUE,1,0)","v":0},{"$f":"'Contact and Other Information'!$H$43","v":"No"},{"$f":"SUM(A8:P8)","v":0}]
[]
[]
["CollectionActivityData","1 - Telephone","2 - Written Notice(s)","3 - Lobby/Counter","4 - Skip Tracing","5 - FTB-COD","6 - FTB-IIC","7 - DL Hold/Suspension","8 - Private Agency","9 - Wage/Bank Garnishments & Liens",null,"Column1","Category3"]
["Revenue Collected",{"$f":"IF('Contact and Other Information'!$G$20=\"\",\"\",'Contact and Other Information'!$G$20)","v":""},{"$f":"IF('Contact and Other Information'!$G$21=\"\",\"\",'Contact and Other Information'!$G$21)","v":""},{"$f":"IF('Contact and Other Information'!$G$22=\"\",\"\",'Contact and Other Information'!$G$22)","v":""},{"$f":"IF('Contact and Other Information'!$G$23=\"\",\"\",'Contact and Other Information'!$G$23)","v":""},{"$f":"IF('Contact and Other Information'!$G$25=\"\",\"\",'Contact and Other Information'!$G$25)","v":""},{"$f":"IF('Contact and Other Information'!$G$26=\"\",\"\",'Contact and Other Information'!$G$26)","v":""},{"$f":"IF('Contact and Other Information'!$G$27=\"\",\"\",'Contact and Other Information'!$G$27)","v":""},{"$f":"IF('Contact and Other Information'!$G$28=\"\",\"\",'Contact and Other Information'!$G$28)","v":""},{"$f":"IF('Contact and Other Information'!$G$33=\"\",\"\",'Contact and Other Information'!$G$33)","v":""},null,"Item6b",{"$f":"IF('Contact and Other Information'!$I$22=\"\",\"\",'Contact and Other Information'!$I$22)","v":""}]
["Number of Cases",{"$f":"IF('Contact and Other Information'!$H$20=\"\",\"\",'Contact and Other Information'!$H$20)","v":""},{"$f":"IF('Contact and Other Information'!$H$21=\"\",\"\",'Contact and Other Information'!$H$21)","v":""},{"$f":"IF('Contact and Other Information'!$H$22=\"\",\"\",'Contact and Other Information'!$H$22)","v":""},{"$f":"IF('Contact and Other Information'!$H$23=\"\",\"\",'Contact and Other Information'!$H$23)","v":""},{"$f":"IF('Contact and Other Information'!$H$25=\"\",\"\",'Contact and Other Information'!$H$25)","v":""},{"$f":"IF('Contact and Other Information'!$H$26=\"\",\"\",'Contact and Other Information'!$H$26)","v":""},{"$f":"IF('Contact and Other Information'!$H$27=\"\",\"\",'Contact and Other Information'!$H$27)","v":""},{"$f":"IF('Contact and Other Information'!$H$28=\"\",\"\",'Contact and Other Information'!$H$28)","v":""},{"$f":"IF('Contact and Other Information'!$H$33=\"\",\"\",'Contact and Other Information'!$H$33)","v":""}]
["Administrative Cost",{"$f":"IF('Contact and Other Information'!$J$20=\"\",\"\",'Contact and Other Information'!$J$20)","v":""},{"$f":"IF('Contact and Other Information'!$J$21=\"\",\"\",'Contact and Other Information'!$J$21)","v":""},{"$f":"IF('Contact and Other Information'!$J$22=\"\",\"\",'Contact and Other Information'!$J$22)","v":""},{"$f":"IF('Contact and Other Information'!$J$23=\"\",\"\",'Contact and Other Information'!$J$23)","v":""},{"$f":"IF('Contact and Other Information'!$J$25=\"\",\"\",'Contact and Other Information'!$J$25)","v":""},{"$f":"IF('Contact and Other Information'!$J$26=\"\",\"\",'Contact and Other Information'!$J$26)","v":""},{"$f":"IF('Contact and Other Information'!$J$27=\"\",\"\",'Contact and Other Information'!$J$27)","v":""},{"$f":"IF('Contact and Other Information'!$J$28=\"\",\"\",'Contact and Other Information'!$J$28)","v":""},{"$f":"IF('Contact and Other Information'!$J$33=\"\",\"\",'Contact and Other Information'!$J$33)","v":""}]

{"sheet":"Program","index":2,"n_rows":46,"n_cols":4,"rows_kept":46,"cut":false,"hidden":false,"merged":[[32,0,42,2],[27,0,27,2],[28,0,28,2],[29,0,29,2],[30,0,30,2],[31,0,31,2],[0,0,0,2],[1,0,1,2],[2,0,2,2],[3,0,3,2],[26,0,26,2]]}
[{"$f":"IF(TRIM('Contact and Other Information'!K2)=\"SELECT COURT/COUNTY\",\"Select court/county (see Contact Information worksheet #1)\",'Contact and Other Information'!K2)","v":"Select court/county (see Contact Information worksheet #1)"}]
["Use the space below to describe your collection program."]
[]
["Describe the extent to which your collection program is meeting the Judicial Council approved Collections Best Practices and identify any obstacles or problems that prevent the collections program from meeting those objectives. Of the twenty-two (22) Best Practices listed below please check those which your collection program has implemented. Provide an explanation for the best practices currently not being met, below. Also, identify any new or additional practices that have improved your collections program. "]
[null,1,"Develop plan and put in a written MOU that implements and enhances a program in which the court/county collaborate to collect court-ordered debt and monies owed to a court under court order.",false]
[null,2,"Establish and maintain a cooperative superior court and county collection committee responsible for compliance, reporting, and internal enhancements of the joint collection program.",false]
[null,3,"Meet the components of a comprehensive collection program as required under Penal Code section 1463.007 in order that the costs of operating the program can be recovered.",false]
[null,4,"Complete all data components in the Collections Reporting Template.",false]
[null,5," Reconcile amounts placed in collection to the supporting case management and/or accounting systems.",false]
[null,6,"Retain the joint court/county collection reports and supporting documents for at least three years.",false]
[null,7," Take appropriate steps to collect court-ordered debt locally before referring it to the Franchise Tax Board for collection.",false]
[null,8,"Participate in the Franchise Tax Board Court-Ordered Debt (COD) collection program.",false]
[null,9,"Participate in the Franchise Tax Board Interagency Intercept Collections (IIC) program.",false]
[null,10,"Establish a process for handling the discharge of accountability for uncollectible court-ordered debt.",false]
[null,11,"Participate in any program that authorizes the Department of Motor Vehicles to suspend or refuse to renew drive when appropriate for a failure to appear in court. ",false]
[null,12,"Conduct trials by written declaration under Vehicle Code section 40903 and, as appropriate in the context of such trials, impose a civil assessment.",false]
[null,13,"Evaluate the effectiveness and efficiency of external collection agencies or companies to which court-ordered debt is referred for collection.",false]
[null,14,"Accept payments via credit and debit card.",false]
[null,15,"Accept payments via the Internet.",false]
[null,16,"Include in a collection program all court-ordered debt and monies owed to the court under a court order.",false]
[null,17,"Include financial screening to assess each individual's ability to pay prior to processing installment payment plans and account receivables.",false]
[null,18,"Use restitution rebate, as authorized by Government Code section13963(f), to further efforts for the collection of funds owed to the Restitution Fund.",false]
[null,19,"Participate in the statewide master agreement for collection services or renegotiate existing contracts, where feasible, to ensure appropriate levels of services are provided at an economical cost.",false]
[null,20,"Require private vendors to remit the gross amount collected as agreed and submit invoices for commission fees to the court or county on a monthly basis.",false]
[null,21,"Use collection terminology (as established in the glossary, instructions, or other documents approved for use by courts and counties) for the development or enhancement of a collection program.",false]
[null,22,"Require private vendors to complete the components of the Collections Reporting Template that corresponds to their collection programs.",false]
["Please identify areas in collections or distribution (check all that apply) in which program staff would like to receive training, assistance, or additional information.  "]
[null,null,null,false]
[null,null,null,false]
[null,null,null,false]
[null,null,null,false]
["Comments or explanations: ",null,null,false]
[null,null,null,false]
[null,null,null,false]
[null,null,null,false]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"\"The number of best practices used is: \" &(COUNTIF($D$5:$D$26,TRUE))","v":"The number of best practices used is: 0"}]
[null,null,{"$f":"IF((COUNTIF($D$5:$D$26,TRUE))=22,\"Meets all 22 of the recommended collections best practices.\",\"Meets \"&TEXT(COUNTIF($D$5:$D$26,TRUE),\"#0\")&\" of the 22 recommended collections best practices.\")","v":"Meets 0 of the 22 recommended collections best practices."}]
[null,null,{"$f":"_xlfn.CONCAT('Best Practices'!B28&\" \"&'Best Practices'!B29)","v":"The following best practices are currently not being met:  1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, and 22"}]

{"sheet":"ProgramData","index":3,"n_rows":12,"n_cols":26,"rows_kept":12,"cut":false,"hidden":true,"merged":[[5,0,5,1]]}
["BestPractices",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BPReport"]
["BP1","BP2","BP3","BP4","BP5","BP6","BP7","BP8","BP9","BP10","BP11","BP12","BP13","BP14","BP15","BP16","BP17","BP18","BP19","BP20","BP21","BP22","BPCount",null,"How Many","NotMet"]
[{"$f":"IF(Program!$D$5=TRUE,1,0)","v":0},{"$f":"IF(Program!$D$6=TRUE,1,0)","v":0},{"$f":"IF(Program!$D$7=TRUE,1,0)","v":0},{"$f":"IF(Program!$D$8=TRUE,1,0)","v":0},{"$f":"IF(Program!$D$9=TRUE,1,0)","v":0},{"$f":"IF(Program!$D$10=TRUE,1,0)","v":0},{"$f":"IF(Program!$D$11=TRUE,1,0)","v":0},{"$f":"IF(Program!$D$12=TRUE,1,0)","v":0},{"$f":"IF(Program!$D$13=TRUE,1,0)","v":0},{"$f":"IF(Program!$D$14=TRUE,1,0)","v":0},{"$f":"IF(Program!$D$15=TRUE,1,0)","v":0},{"$f":"IF(Program!$D$16=TRUE,1,0)","v":0},{"$f":"IF(Program!$D$17=TRUE,1,0)","v":0},{"$f":"IF(Program!$D$18=TRUE,1,0)","v":0},{"$f":"IF(Program!$D$19=TRUE,1,0)","v":0},{"$f":"IF(Program!$D$20=TRUE,1,0)","v":0},{"$f":"IF(Program!$D$21=TRUE,1,0)","v":0},{"$f":"IF(Program!$D$22=TRUE,1,0)","v":0},{"$f":"IF(Program!$D$23=TRUE,1,0)","v":0},{"$f":"IF(Program!$D$24=TRUE,1,0)","v":0},{"$f":"IF(Program!$D$25=TRUE,1,0)","v":0},{"$f":"IF(Program!$D$26=TRUE,1,0)","v":0},{"$f":"SUM(A3:V3)","v":0},null,{"$f":"Program!C45","v":"Meets 0 of the 22 recommended collections best practices."},{"$f":"Program!C46","v":"The following best practices are currently not being met:  1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, and 22"}]
[]
[]
["TrainingRequested"]
["TRN-AuditJC","TRN-AuditSCO","TRN-RevDist","TRN-Discharge","TRN-Adjustments","TRN-ATP","TRN-CostRcvy","TRN-Other"]
[{"$f":"IF(Program!$D$28=TRUE,1,0)","v":0},{"$f":"IF(Program!$D$29=TRUE,1,0)","v":0},{"$f":"IF(Program!$D$30=TRUE,1,0)","v":0},{"$f":"IF(Program!$D$31=TRUE,1,0)","v":0},{"$f":"IF(Program!$D$32=TRUE,1,0)","v":0},{"$f":"IF(Program!$D$33=TRUE,1,0)","v":0},{"$f":"IF(Program!$D$34=TRUE,1,0)","v":0},{"$f":"IF(Program!$D$35=TRUE,1,0)","v":0}]
[]
[]
["ProgramReport"]
[{"$f":"IF(Program!$A$33=\"\",\"N/A\",Program!A$33)","v":"N/A"}]

{"sheet":"Performance","index":4,"n_rows":33,"n_cols":1,"rows_kept":33,"cut":false,"hidden":false,"merged":[[17,0,31,0],[33,0,55,0],[4,0,15,0]]}
[{"$f":"IF(TRIM('Contact and Other Information'!K2)=\"SELECT COURT/COUNTY\",\"Select court/county (see Contact Information worksheet #1)\",'Contact and Other Information'!K2)","v":"Select court/county (see Contact Information worksheet #1)"}]
["Use the space below to discuss your collection program."]
[]
["Please provide any comments on your performance for the reporting period, by Current Period, Prior Period Inventory, and Combined, that you wish included in the Individual Program Report that will be attached in the Report to the Legislature."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Please explain the extent of your reporting capabilities in terms of providing the information required by \nGC § 68514.  If data cannot be provided at this time or if the reported data differs from the Instructions, please describe the submitted data and any plans for providing this information in the future."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Additional operational information about your collections program for the reporting period."]

{"sheet":"PerformanceData","index":5,"n_rows":6,"n_cols":3,"rows_kept":6,"cut":false,"hidden":true,"merged":[]}
["Question1","Question2","Question3"]
[{"$f":"IF(Performance!$A$5=\"\",\"N/A\",Performance!A$5)","v":"N/A"},{"$f":"IF(Performance!$A$18=\"\",\"N/A\",Performance!A$18)","v":"N/A"},{"$f":"IF(Performance!$A$34=\"\",\"N/A\",Performance!A$34)","v":"N/A"}]
[]
[]
["DashboardComment"]
[{"$f":"IF('Performance Metrics'!$A$30=\"\",\"N/A\",'Performance Metrics'!A$30)","v":"N/A"}]

{"sheet":"Annual Financial Report","index":6,"n_rows":68,"n_cols":13,"rows_kept":68,"cut":false,"hidden":false,"merged":[[47,0,47,12],[67,0,67,1],[67,7,67,8],[30,11,30,12],[31,11,31,12],[32,11,32,12],[33,11,33,12],[34,11,34,12],[35,11,35,12],[36,11,36,12],[38,11,38,12],[39,11,39,12],[40,11,40,12],[41,0,41,12],[37,11,37,12],[29,0,29,12],[2,1,2,2],[3,1,3,2],[4,1,4,2],[5,0,5,12],[17,0,17,12]]}
[null,{"$f":"IF(TRIM('Contact and Other Information'!K2)=\"SELECT COURT/COUNTY\",\"Select court/county (see Contact Information worksheet #1)\",'Contact and Other Information'!K2)","v":"Select court/county (see Contact Information worksheet #1)"}]
[]
[null,"REPORTING PERIOD",null,"Col. A"]
[1,"Beginning Date-First day of Reporting Period",null,"2022-07-01"]
[2,"Ending Date-Last day of Reporting Period",null,"2023-06-30"]
["CURRENT PERIOD (NEWLY-ESTABLISHED) DELINQUENT DEBT: FINES, FEES, FORFEITURES, PENALTIES AND ASSESSMENTS"]
[null,null,"Number of Cases Established or Referred as Delinquent","Value of Cases Established or Referred as Delinquent","Number of Cases with Payment(s) Received                             (Items 1 and 2)      ","Gross Revenue Collected            ","Cost of Collections\n(Penal Code 1463.007)\nenter as negative number","Adjustment: Amount satisfied by Court-ordered Suspension, Dismissal or Alternative Sentence \n(Item 3)","Discharge from Accountability     \n(Item 3)","Net Value of Newly-Established Delinquent Debt at End of Period\n(Col. C - E  - G - H) ","Value of Cases on Installment Agreement                 (Item 8)","Default Balance Installment Agreement        \n(Item 8)","Percentage of Debt Defaulted On \n(Installment Agmt.)                    (Col. K / Col. J) "]
["Row","Program","Col. B","Col. C","Col. D","Col. E","Col. F","Col. G","Col. H","Col. I","Col. J","Col. K","Col. L"]
[3,"Non-Delinquent Collections"]
[{"$f":"A9+1","v":4},"Court Collection Program",null,null,null,null,null,null,null,{"$f":"SUM(D10-F10-H10-I10)","v":0},null,null,{"$f":"IFERROR(L10/K10,\"\")","v":""}]
[5,"County Collection Program",null,null,null,null,null,null,null,0,null,null,{"$f":"IFERROR(L11/K11,\"\")","v":""}]
[6,"Private Agency",null,null,null,null,null,null,null,0,null,null,""]
[7,"FTB Court-Ordered Debt",null,null,null,null,null,null,null,0,null,null,""]
[8,"FTB Interagency Intercept Collection",null,null,null,null,null,null,null,0]
[9,"Intra-Branch Program",null,null,null,null,null,null,null,0,null,null,""]
[10,"Other",null,null,null,null,null,null,null,0,null,null,""]
[{"$f":"A16+1","v":11},"Sub-total Delinquent ",{"$f":"SUM(C10:C16)","v":0},0,0,0,0,0,0,0,0,0]
["PRIOR PERIOD (PREVIOUSLY-ESTABLISHED) DELINQUENT DEBT: FINES, FEES, FORFEITURES, PENALTIES AND ASSESSMENTS"]
[null,null,"Number of Delinquent Cases at Period Beginning \n(Ending Balance from Transfer Worksheet)","Value of Delinquent Cases at Period Beginning\n(Ending Balance from Transfer Worksheet)","Number of Cases with Payment(s) Received   ","Gross Revenue Collected     ","Cost of Collections \n(Penal Code 1463.007)\nenter as negative number","Adjustment: Amount satisfied by Court-ordered Suspension, Dismissal or Alternative Sentence","Discharge from Accountability ","Net Value of Previously-Established Delinquent Debt at End of Period \n(Col. N - P - R - S) ","Value of Cases on Installment Agmt. (Ending Balance from Prior Year) ","Default Balance   Installment Agreement         ","Percentage of Debt Defaulted On \n(Installment Agmt.)                  (Col. V / Col. U) "]
["Row","Program","Col. M","Col. N","Col. O","Col. P","Col. Q","Col. R","Col. S","Col. T","Col. U","Col. V","Col. W"]
[12,"Non-Delinquent Collections"]
[13,"Court Collection Program",null,null,null,null,null,null,null,{"$f":"SUM(D22-F22-H22-I22)","v":0},null,null,{"$f":"IFERROR(L22/K22,\"\")","v":""}]
[14,"County Collection Program",null,null,null,null,null,null,null,{"$f":"SUM(D23-F23-H23-I23)","v":0},null,null,{"$f":"IFERROR(L23/K23,\"\")","v":""}]
[15,"Private Agency",null,null,null,null,null,null,null,{"$f":"SUM(D24-F24-H24-I24)","v":0},null,null,""]
[{"$f":"A24+1","v":16},"FTB Court-Ordered Debt",null,null,null,null,null,null,null,{"$f":"SUM(D25-F25-H25-I25)","v":0},null,null,""]
[17,"FTB Interagency Intercept Collection",null,null,null,null,null,null,null,{"$f":"SUM(D26-F26-H26-I26)","v":0}]
[18,"Intra-Branch Program",null,null,null,null,null,null,null,0,null,null,""]
[{"$f":"A27+1","v":19},"Other",null,null,null,null,null,null,null,0,null,null,""]
[{"$f":"A28+1","v":20},"Sub-total Delinquent ",{"$f":"SUM(C22:C28)","v":0},{"$f":"SUM(D22:D28)","v":0},{"$f":"SUM(E22:E28)","v":0},{"$f":"SUM(F22:F28)","v":0},{"$f":"SUM(G22:G28)","v":0},0,0,0,0,0]
["COMBINED: BEGINNING AND ENDING BALANCES; FINES, FEES, FORFEITURES, PENALTIES AND ASSESSMENTS"]
[null,null," Number of Cases Beginning Balance  "," Value of Cases Beginning Balance  ","Gross Revenue Collected                   ","Cost of Collections (Penal Code 1463.007)  ","Adjustments        ","Discharge from Accountability             "," Net Change in Value          ","Number of Cases - Ending Balance","Value of Cases-Ending Balance    ","Error Messages"]
["Row","Program","Col. X","Col. Y","Col. Z","Col. AA","Col. AB","Col. AC","Col. AD","Col. AE","Col. AF","Col. AG"]
[21,"Non-Delinquent Collections",null,null,{"$f":"F9+F21","v":0}]
[22,"Court Collection Program",{"$f":"C10+C22","v":0},0,0,{"$f":"G10+G22","v":0},0,0,{"$f":"SUM(E34+G34+H34)","v":0},null,{"$f":"D34-I34","v":0},{"$f":"IF(D34-I34=K34,\" \",\"Out of Balance\")","v":" "},{"$f":"IF(H34+J34=L34,\" \",\"Out of Balance\")","v":"Out of Balance"}]
[23,"County Collection Program",0,0,0,0,0,0,{"$f":"SUM(E35+G35+H35)","v":0},null,{"$f":"D35-I35","v":0},{"$f":"IF(D35-I35=K35,\" \",\"Out of Balance\")","v":" "},"Out of Balance"]
[24,"Private Agency",0,0,0,0,0,0,0,null,{"$f":"D36-I36","v":0}," ","Out of Balance"]
[25,"FTB Court-Ordered Debt",0,0,0,0,0,0,{"$f":"SUM(E37+G37+H37)","v":0},null,0," ","Out of Balance"]
[26,"FTB Interagency Intercept Collection",{"$f":"C14+C26","v":0},{"$f":"D14+D26","v":0},0,0,0,0,{"$f":"SUM(E38+G38+H38)","v":0},null,0,{"$f":"IF(D38-I38=K38,\" \",\"Out of Balance\")","v":" "},{"$f":"IF(H38+J38=L38,\" \",\"Out of Balance\")","v":"Out of Balance"}]
[27,"Intra-Branch Program",{"$f":"C15+C27","v":0},{"$f":"D15+D27","v":0},0,0,0,0,0,null,0," ","Out of Balance"]
[28,"Other",{"$f":"C16+C28","v":0},{"$f":"D16+D28","v":0},0,0,0,0,0,null,0," ","Out of Balance"]
[29,"Total Delinquent",{"$f":"SUM(C34:C40)","v":0},{"$f":"SUM(D34:D40)","v":0},0,0,0,0,0,{"$f":"SUM(J34:J40)","v":0},{"$f":"SUM(K34:K40)","v":0}]
["COLLECTIONS FROM CASES SUBJECT TO ABILITY TO PAY DETERMINATION"]
[null,"Period","Online ATP Revenue: Nondelinquent","Online ATP Revenue: Delinquent","Online ATP Revenue: Combined","In-Person ATP Revenue: Nondelinquent","In-Person ATP Revenue: Delinquent","In-Person ATP Revenue: \nCombined",null,"Online ATP Cases w/ Installment Payments: Nondelinquent","Online ATP\nInstallment Costs Claimed: Nondelinquent","In-Person ATP Cases w/ Installment Payments: Nondelinquent","In-Person ATP \nInstallment Costs Claimed: Nondelinquent"]
["Row",null,"Col. AH","Col. AI","Col. AJ","Col. AK","Col. AL","Col. AM",null,"Col. AN","Col. AO","Col. AP","Col. AQ"]
[30,"Current Period",null,null,{"$f":"(C45+D45)","v":0},null,null,{"$f":"(F45+G45)","v":0}]
[31,"Prior Period",null,null,{"$f":"(C46+D46)","v":0},null,null,{"$f":"(F46+G46)","v":0}]
[32,"Combined Periods",{"$f":"C45+C46","v":0},{"$f":"D45+D46","v":0},0,0,0,0,null,{"$f":"J45+J46","v":0},0,0,0]
[" VICTIM RESTITUTION (PC 1202.4)"]
[null,null,"Number of Cases - (Ending Balance from Prior Year)","Value of Cases - \n(Ending Balance from Prior Year) "," Number of Cases Established/ Referred/ Transferred in Period","Value of Cases Established/ Referred/ Transferred in  Period","Gross Revenue Collected","Net Change in Value","Number of Cases - Ending Balance","Value of Cases - Ending Balance","Error Messages"]
["Row","Program","Col. AR","Col. AS","Col. AT","Col. AU","Col. AV","Col. AW","Col. AX","Col. AY","Col. AZ"]
[33,"Non-Delinquent Collections",null,null,null,null,null,null,null,null,{"$f":"IF(D51+H51=J51,\" \",\"Out of Balance\")","v":" "}]
[34,"Court Collection Program",null,null,null,null,null,{"$f":"SUM(F52-G52)","v":0},null,{"$f":"D52+F52-G52","v":0}," "]
[{"$f":"A52+1","v":35},"County Collection Program",null,null,null,null,null,{"$f":"SUM(F53-G53)","v":0},null,{"$f":"D53+F53-G53","v":0}," "]
[36,"Private Agency",null,null,null,null,null,0,null,0," "]
[37,"FTB Court-Ordered Debt",null,null,null,null,null,0,null,0," "]
[38,"FTB Interagency Intercept Collection",null,null,null,null,null,0,null,0]
[39,"Intra-Branch Program",null,null,null,null,null,0,null,0," "]
[40,"Other",null,null,null,null,null,0,null,0," "]
[41,"Total Delinquent ",{"$f":"SUM(C52:C58)","v":0},0,0,0,0,0,{"$f":"SUM(I52:I58)","v":0},0]
[]
["Reviewed by Court",null,null,null,null,null,null,"Reviewed by County"]
[]
[]
[]
["Printed Name",null,null,"Signature",null,null,null,"Printed Name",null,null,"Signature"]
[]
[]
["Date",null,null,"Title (Court Executive or Presiding Judge)",null,null,null,"Date",null,null,"Title (County Auditor-Controller or other)"]

{"sheet":"AFRData","index":7,"n_rows":54,"n_cols":11,"rows_kept":54,"cut":false,"hidden":true,"merged":[]}
["NonDelinquent"]
["NDCurrentCases","NDCurrentValue","NDPriorCases","NDPriorValue","NDTotalCases","NDTotalValue","Restitution"]
[{"$f":"IF('Annual Financial Report'!$E$9=\"\",\"\",'Annual Financial Report'!$E$9)","v":""},{"$f":"IF('Annual Financial Report'!$F$9=\"\",\"\",'Annual Financial Report'!$F$9)","v":""},{"$f":"IF('Annual Financial Report'!$E$21=\"\",\"\",'Annual Financial Report'!$E$21)","v":""},{"$f":"IF('Annual Financial Report'!$F$21=\"\",\"\",'Annual Financial Report'!$F$21)","v":""},{"$f":"IF(SUM(A3,C3)=0,\"\",SUM(A3,C3))","v":""},{"$f":"IF(SUM(B3,D3)=0,\"\",SUM(B3,D3))","v":""},{"$f":"IF('Annual Financial Report'!$G$51=\"\",\"\",'Annual Financial Report'!$G$51)","v":""}]
[]
[]
["Current","CasesBeginning","ValueBeginning","CasesPaid","Revenue","Administrative Cost","Adjustments","Discharge","Installment","Default"]
["Court",{"$f":"IF('Annual Financial Report'!$C$10=\"\",\"\",'Annual Financial Report'!$C$10)","v":""},{"$f":"IF('Annual Financial Report'!$D$10=\"\",\"\",'Annual Financial Report'!$D$10)","v":""},{"$f":"IF('Annual Financial Report'!$E$10=\"\",\"\",'Annual Financial Report'!$E$10)","v":""},{"$f":"IF('Annual Financial Report'!$F$10=\"\",\"\",'Annual Financial Report'!$F$10)","v":""},{"$f":"IF('Annual Financial Report'!$G$10=\"\",\"\",'Annual Financial Report'!$G$10)","v":""},{"$f":"IF('Annual Financial Report'!$H$10=\"\",\"\",'Annual Financial Report'!$H$10)","v":""},{"$f":"IF('Annual Financial Report'!$I$10=\"\",\"\",'Annual Financial Report'!$I$10)","v":""},{"$f":"IF('Annual Financial Report'!$K$10=\"\",\"\",'Annual Financial Report'!$K$10)","v":""},{"$f":"IF('Annual Financial Report'!$L$10=\"\",\"\",'Annual Financial Report'!$L$10)","v":""}]
["County",{"$f":"IF('Annual Financial Report'!$C$11=\"\",\"\",'Annual Financial Report'!$C$11)","v":""},{"$f":"IF('Annual Financial Report'!$D$11=\"\",\"\",'Annual Financial Report'!$D$11)","v":""},{"$f":"IF('Annual Financial Report'!$E$11=\"\",\"\",'Annual Financial Report'!$E$11)","v":""},{"$f":"IF('Annual Financial Report'!$F$11=\"\",\"\",'Annual Financial Report'!$F$11)","v":""},{"$f":"IF('Annual Financial Report'!$G$11=\"\",\"\",'Annual Financial Report'!$G$11)","v":""},{"$f":"IF('Annual Financial Report'!$H$11=\"\",\"\",'Annual Financial Report'!$H$11)","v":""},{"$f":"IF('Annual Financial Report'!$I$11=\"\",\"\",'Annual Financial Report'!$I$11)","v":""},{"$f":"IF('Annual Financial Report'!$K$11=\"\",\"\",'Annual Financial Report'!$K$11)","v":""},{"$f":"IF('Annual Financial Report'!$L$11=\"\",\"\",'Annual Financial Report'!$L$11)","v":""}]
["Private Agency",{"$f":"IF('Annual Financial Report'!$C$12=\"\",\"\",'Annual Financial Report'!$C$12)","v":""},{"$f":"IF('Annual Financial Report'!$D$12=\"\",\"\",'Annual Financial Report'!$D$12)","v":""},{"$f":"IF('Annual Financial Report'!$E$12=\"\",\"\",'Annual Financial Report'!$E$12)","v":""},{"$f":"IF('Annual Financial Report'!$F$12=\"\",\"\",'Annual Financial Report'!$F$12)","v":""},{"$f":"IF('Annual Financial Report'!$G$12=\"\",\"\",'Annual Financial Report'!$G$12)","v":""},{"$f":"IF('Annual Financial Report'!$H$12=\"\",\"\",'Annual Financial Report'!$H$12)","v":""},{"$f":"IF('Annual Financial Report'!$I$12=\"\",\"\",'Annual Financial Report'!$I$12)","v":""},{"$f":"IF('Annual Financial Report'!$K$12=\"\",\"\",'Annual Financial Report'!$K$12)","v":""},{"$f":"IF('Annual Financial Report'!$L$12=\"\",\"\",'Annual Financial Report'!$L$12)","v":""}]
["FTB-COD",{"$f":"IF('Annual Financial Report'!$C$13=\"\",\"\",'Annual Financial Report'!$C$13)","v":""},{"$f":"IF('Annual Financial Report'!$D$13=\"\",\"\",'Annual Financial Report'!D$13)","v":""},{"$f":"IF('Annual Financial Report'!$E$13=\"\",\"\",'Annual Financial Report'!$E$13)","v":""},{"$f":"IF('Annual Financial Report'!$F$13=\"\",\"\",'Annual Financial Report'!$F$13)","v":""},{"$f":"IF('Annual Financial Report'!$G$13=\"\",\"\",'Annual Financial Report'!$G$13)","v":""},{"$f":"IF('Annual Financial Report'!$H$13=\"\",\"\",'Annual Financial Report'!$H$13)","v":""},{"$f":"IF('Annual Financial Report'!$I$13=\"\",\"\",'Annual Financial Report'!$I$13)","v":""},{"$f":"IF('Annual Financial Report'!$K$13=\"\",\"\",'Annual Financial Report'!$K$13)","v":""},{"$f":"IF('Annual Financial Report'!$L$13=\"\",\"\",'Annual Financial Report'!$L$13)","v":""}]
["FTB-IIC",{"$f":"IF('Annual Financial Report'!$C$14=\"\",\"\",'Annual Financial Report'!$C$14)","v":""},{"$f":"IF('Annual Financial Report'!$D$14=\"\",\"\",'Annual Financial Report'!D$14)","v":""},{"$f":"IF('Annual Financial Report'!$E$14=\"\",\"\",'Annual Financial Report'!$E$14)","v":""},{"$f":"IF('Annual Financial Report'!$F$14=\"\",\"\",'Annual Financial Report'!$F$14)","v":""},{"$f":"IF('Annual Financial Report'!$G$14=\"\",\"\",'Annual Financial Report'!$G$14)","v":""},{"$f":"IF('Annual Financial Report'!$H$14=\"\",\"\",'Annual Financial Report'!$H$14)","v":""},{"$f":"IF('Annual Financial Report'!$I$14=\"\",\"\",'Annual Financial Report'!$I$14)","v":""},{"$f":"IF('Annual Financial Report'!$K$14=\"\",\"\",'Annual Financial Report'!$K$14)","v":""},{"$f":"IF('Annual Financial Report'!$L$14=\"\",\"\",'Annual Financial Report'!$L$14)","v":""}]
["Intrabranch",{"$f":"IF('Annual Financial Report'!$C$15=\"\",\"\",'Annual Financial Report'!$C$15)","v":""},{"$f":"IF('Annual Financial Report'!$D$15=\"\",\"\",'Annual Financial Report'!$D$15)","v":""},{"$f":"IF('Annual Financial Report'!$E$15=\"\",\"\",'Annual Financial Report'!$E$15)","v":""},{"$f":"IF('Annual Financial Report'!$F$15=\"\",\"\",'Annual Financial Report'!$F$15)","v":""},{"$f":"IF('Annual Financial Report'!$G$15=\"\",\"\",'Annual Financial Report'!$G$15)","v":""},{"$f":"IF('Annual Financial Report'!$H$15=\"\",\"\",'Annual Financial Report'!$H$15)","v":""},{"$f":"IF('Annual Financial Report'!$I$15=\"\",\"\",'Annual Financial Report'!$I$15)","v":""},{"$f":"IF('Annual Financial Report'!$K$15=\"\",\"\",'Annual Financial Report'!$K$15)","v":""},{"$f":"IF('Annual Financial Report'!$L$15=\"\",\"\",'Annual Financial Report'!$L$15)","v":""}]
["Other",{"$f":"IF('Annual Financial Report'!$C$16=\"\",\"\",'Annual Financial Report'!$C$16)","v":""},{"$f":"IF('Annual Financial Report'!$D$16=\"\",\"\",'Annual Financial Report'!$D$16)","v":""},{"$f":"IF('Annual Financial Report'!$E$16=\"\",\"\",'Annual Financial Report'!$E$16)","v":""},{"$f":"IF('Annual Financial Report'!$F$16=\"\",\"\",'Annual Financial Report'!$F$16)","v":""},{"$f":"IF('Annual Financial Report'!$G$16=\"\",\"\",'Annual Financial Report'!$G$16)","v":""},{"$f":"IF('Annual Financial Report'!$H$16=\"\",\"\",'Annual Financial Report'!$H$16)","v":""},{"$f":"IF('Annual Financial Report'!$I$16=\"\",\"\",'Annual Financial Report'!$I$16)","v":""},{"$f":"IF('Annual Financial Report'!$K$16=\"\",\"\",'Annual Financial Report'!$K$16)","v":""},{"$f":"IF('Annual Financial Report'!$L$16=\"\",\"\",'Annual Financial Report'!$L$16)","v":""}]
[]
[]
["Prior","CasesBeginning","ValueBeginning","CasesPaid","Revenue","Administrative Cost","Adjustments","Discharge","Installment","Default"]
["Court",{"$f":"IF('Annual Financial Report'!$C$22=\"\",\"\",'Annual Financial Report'!$C$22)","v":""},{"$f":"IF('Annual Financial Report'!$D$22=\"\",\"\",'Annual Financial Report'!$D$22)","v":""},{"$f":"IF('Annual Financial Report'!$E$22=\"\",\"\",'Annual Financial Report'!$E$22)","v":""},{"$f":"IF('Annual Financial Report'!$F$22=\"\",\"\",'Annual Financial Report'!$F$22)","v":""},{"$f":"IF('Annual Financial Report'!$G$22=\"\",\"\",'Annual Financial Report'!$G$22)","v":""},{"$f":"IF('Annual Financial Report'!$H$22=\"\",\"\",'Annual Financial Report'!$H$22)","v":""},{"$f":"IF('Annual Financial Report'!$I$22=\"\",\"\",'Annual Financial Report'!$I$22)","v":""},{"$f":"IF('Annual Financial Report'!$K$22=\"\",\"\",'Annual Financial Report'!$K$22)","v":""},{"$f":"IF('Annual Financial Report'!$L$22=\"\",\"\",'Annual Financial Report'!$L$22)","v":""}]
["County",{"$f":"IF('Annual Financial Report'!$C$23=\"\",\"\",'Annual Financial Report'!$C$23)","v":""},{"$f":"IF('Annual Financial Report'!$D$23=\"\",\"\",'Annual Financial Report'!$D$23)","v":""},{"$f":"IF('Annual Financial Report'!$E$23=\"\",\"\",'Annual Financial Report'!$E$23)","v":""},{"$f":"IF('Annual Financial Report'!$F$23=\"\",\"\",'Annual Financial Report'!$F$23)","v":""},{"$f":"IF('Annual Financial Report'!$G$23=\"\",\"\",'Annual Financial Report'!$G$23)","v":""},{"$f":"IF('Annual Financial Report'!$H$23=\"\",\"\",'Annual Financial Report'!$H$23)","v":""},{"$f":"IF('Annual Financial Report'!$I$23=\"\",\"\",'Annual Financial Report'!$I$23)","v":""},{"$f":"IF('Annual Financial Report'!$K$23=\"\",\"\",'Annual Financial Report'!$K$23)","v":""},{"$f":"IF('Annual Financial Report'!$L$23=\"\",\"\",'Annual Financial Report'!$L$23)","v":""}]
["Private Agency",{"$f":"IF('Annual Financial Report'!$C$24=\"\",\"\",'Annual Financial Report'!$C$24)","v":""},{"$f":"IF('Annual Financial Report'!$D$24=\"\",\"\",'Annual Financial Report'!$D$24)","v":""},{"$f":"IF('Annual Financial Report'!$E$24=\"\",\"\",'Annual Financial Report'!$E$24)","v":""},{"$f":"IF('Annual Financial Report'!$F$24=\"\",\"\",'Annual Financial Report'!$F$24)","v":""},{"$f":"IF('Annual Financial Report'!$G$24=\"\",\"\",'Annual Financial Report'!$G$24)","v":""},{"$f":"IF('Annual Financial Report'!$H$24=\"\",\"\",'Annual Financial Report'!$H$24)","v":""},{"$f":"IF('Annual Financial Report'!$I$24=\"\",\"\",'Annual Financial Report'!$I$24)","v":""},{"$f":"IF('Annual Financial Report'!$K$24=\"\",\"\",'Annual Financial Report'!$K$24)","v":""},{"$f":"IF('Annual Financial Report'!$L$24=\"\",\"\",'Annual Financial Report'!$L$24)","v":""}]
["FTB-COD",{"$f":"IF('Annual Financial Report'!$C$25=\"\",\"\",'Annual Financial Report'!$C$25)","v":""},{"$f":"IF('Annual Financial Report'!$D$25=\"\",\"\",'Annual Financial Report'!D$25)","v":""},{"$f":"IF('Annual Financial Report'!$E$25=\"\",\"\",'Annual Financial Report'!$E$25)","v":""},{"$f":"IF('Annual Financial Report'!$F$25=\"\",\"\",'Annual Financial Report'!$F$25)","v":""},{"$f":"IF('Annual Financial Report'!$G$25=\"\",\"\",'Annual Financial Report'!$G$25)","v":""},{"$f":"IF('Annual Financial Report'!$H$25=\"\",\"\",'Annual Financial Report'!$H$25)","v":""},{"$f":"IF('Annual Financial Report'!$I$25=\"\",\"\",'Annual Financial Report'!$I$25)","v":""},{"$f":"IF('Annual Financial Report'!$K$25=\"\",\"\",'Annual Financial Report'!$K$25)","v":""},{"$f":"IF('Annual Financial Report'!$L$25=\"\",\"\",'Annual Financial Report'!$L$25)","v":""}]
["FTB-IIC",{"$f":"IF('Annual Financial Report'!$C$26=\"\",\"\",'Annual Financial Report'!$C$26)","v":""},{"$f":"IF('Annual Financial Report'!$D$26=\"\",\"\",'Annual Financial Report'!D$26)","v":""},{"$f":"IF('Annual Financial Report'!$E$26=\"\",\"\",'Annual Financial Report'!$E$26)","v":""},{"$f":"IF('Annual Financial Report'!$F$26=\"\",\"\",'Annual Financial Report'!$F$26)","v":""},{"$f":"IF('Annual Financial Report'!$G$26=\"\",\"\",'Annual Financial Report'!$G$26)","v":""},{"$f":"IF('Annual Financial Report'!$H$26=\"\",\"\",'Annual Financial Report'!$H$26)","v":""},{"$f":"IF('Annual Financial Report'!$I$26=\"\",\"\",'Annual Financial Report'!$I$26)","v":""},{"$f":"IF('Annual Financial Report'!$K$26=\"\",\"\",'Annual Financial Report'!$K$26)","v":""},{"$f":"IF('Annual Financial Report'!$L$26=\"\",\"\",'Annual Financial Report'!$L$26)","v":""}]
["Intrabranch",{"$f":"IF('Annual Financial Report'!$C$27=\"\",\"\",'Annual Financial Report'!$C$27)","v":""},{"$f":"IF('Annual Financial Report'!$D$27=\"\",\"\",'Annual Financial Report'!$D$27)","v":""},{"$f":"IF('Annual Financial Report'!$E$27=\"\",\"\",'Annual Financial Report'!$E$27)","v":""},{"$f":"IF('Annual Financial Report'!$F$27=\"\",\"\",'Annual Financial Report'!$F$27)","v":""},{"$f":"IF('Annual Financial Report'!$G$27=\"\",\"\",'Annual Financial Report'!$G$27)","v":""},{"$f":"IF('Annual Financial Report'!$H$27=\"\",\"\",'Annual Financial Report'!$H$27)","v":""},{"$f":"IF('Annual Financial Report'!$I$27=\"\",\"\",'Annual Financial Report'!$I$27)","v":""},{"$f":"IF('Annual Financial Report'!$K$27=\"\",\"\",'Annual Financial Report'!$K$27)","v":""},{"$f":"IF('Annual Financial Report'!$L$27=\"\",\"\",'Annual Financial Report'!$L$27)","v":""}]
["Other",{"$f":"IF('Annual Financial Report'!$C$28=\"\",\"\",'Annual Financial Report'!$C$28)","v":""},{"$f":"IF('Annual Financial Report'!$D$28=\"\",\"\",'Annual Financial Report'!$D$28)","v":""},{"$f":"IF('Annual Financial Report'!$E$28=\"\",\"\",'Annual Financial Report'!$E$28)","v":""},{"$f":"IF('Annual Financial Report'!$F$28=\"\",\"\",'Annual Financial Report'!$F$28)","v":""},{"$f":"IF('Annual Financial Report'!$G$28=\"\",\"\",'Annual Financial Report'!$G$28)","v":""},{"$f":"IF('Annual Financial Report'!$H$28=\"\",\"\",'Annual Financial Report'!$H$28)","v":""},{"$f":"IF('Annual Financial Report'!$I$28=\"\",\"\",'Annual Financial Report'!$I$28)","v":""},{"$f":"IF('Annual Financial Report'!$K$28=\"\",\"\",'Annual Financial Report'!$K$28)","v":""},{"$f":"IF('Annual Financial Report'!$L$28=\"\",\"\",'Annual Financial Report'!$L$28)","v":""}]
[]
[]
["Combined","CasesBeginning","ValueBeginning","CasesPaid","Revenue","Administrative Cost","Adjustments","Discharge","Installment","Default"]
["Court",{"$f":"IF(SUM(B7,B17)=0,\"\",SUM(B7,B17))","v":""},"","","","","","","",""]
["County",{"$f":"IF(SUM(B8,B18)=0,\"\",SUM(B8,B18))","v":""},"","","","","","","",""]
["Private Agency",{"$f":"IF(SUM(B9,B19)=0,\"\",SUM(B9,B19))","v":""},"","","","","","","",""]
["FTB-COD",{"$f":"IF(SUM(B10,B20)=0,\"\",SUM(B10,B20))","v":""},"","","","","","","",""]
["FTB-IIC",{"$f":"IF(SUM(B11,B21)=0,\"\",SUM(B11,B21))","v":""},"","","","","","","",""]
["Intrabranch",{"$f":"IF(SUM(B12,B22)=0,\"\",SUM(B12,B22))","v":""},"","","","","","","",""]
["Other",{"$f":"IF(SUM(B13,B23)=0,\"\",SUM(B13,B23))","v":""},"","","","","","","",""]
[]
[]
["Ending Balance","Cases","Value",null,"ATP Value","Online Nnondelinquent","Online Delinquent","Online Combined","In-Person Nondelinquent","In-Person Delinquent","In-Person Combined"]
["Court",{"$f":"IF('Annual Financial Report'!$J$34=\"\",\"\",'Annual Financial Report'!$J$34)","v":""},{"$f":"IF('Annual Financial Report'!$K$34=\"\",\"\",'Annual Financial Report'!$K$34)","v":0},null,"Current",{"$f":"IF('Annual Financial Report'!$C$45=\"\",\"\",'Annual Financial Report'!$C$45)","v":""},{"$f":"IF('Annual Financial Report'!$D$45=\"\",\"\",'Annual Financial Report'!$D$45)","v":""},{"$f":"IF('Annual Financial Report'!$E$45=\"\",\"\",'Annual Financial Report'!$E$45)","v":0},{"$f":"IF('Annual Financial Report'!$F$45=\"\",\"\",'Annual Financial Report'!$F$45)","v":""},{"$f":"IF('Annual Financial Report'!$G$45=\"\",\"\",'Annual Financial Report'!$G$45)","v":""},{"$f":"IF('Annual Financial Report'!$H$45=\"\",\"\",'Annual Financial Report'!$H$45)","v":0}]
["County",{"$f":"IF('Annual Financial Report'!$J$35=\"\",\"\",'Annual Financial Report'!$J$35)","v":""},{"$f":"IF('Annual Financial Report'!$K$35=\"\",\"\",'Annual Financial Report'!$K$35)","v":0},null,"Prior",{"$f":"IF('Annual Financial Report'!$C$46=\"\",\"\",'Annual Financial Report'!$C$46)","v":""},{"$f":"IF('Annual Financial Report'!$D$46=\"\",\"\",'Annual Financial Report'!$D$46)","v":""},{"$f":"IF('Annual Financial Report'!$E$46=\"\",\"\",'Annual Financial Report'!$E$46)","v":0},{"$f":"IF('Annual Financial Report'!$F$46=\"\",\"\",'Annual Financial Report'!$F$46)","v":""},{"$f":"IF('Annual Financial Report'!$G$46=\"\",\"\",'Annual Financial Report'!$G$46)","v":""},{"$f":"IF('Annual Financial Report'!$H$46=\"\",\"\",'Annual Financial Report'!$H$46)","v":0}]
["Private Agency",{"$f":"IF('Annual Financial Report'!$J$36=\"\",\"\",'Annual Financial Report'!$J$36)","v":""},{"$f":"IF('Annual Financial Report'!$K$36=\"\",\"\",'Annual Financial Report'!$K$36)","v":0},null,"Combined",{"$f":"IF('Annual Financial Report'!$C$47=\"\",\"\",'Annual Financial Report'!$C$47)","v":0},{"$f":"IF('Annual Financial Report'!$D$47=\"\",\"\",'Annual Financial Report'!$D$47)","v":0},{"$f":"IF('Annual Financial Report'!$E$47=\"\",\"\",'Annual Financial Report'!$E$47)","v":0},{"$f":"IF('Annual Financial Report'!$F$47=\"\",\"\",'Annual Financial Report'!$F$47)","v":0},{"$f":"IF('Annual Financial Report'!$G$47=\"\",\"\",'Annual Financial Report'!$G$47)","v":0},{"$f":"IF('Annual Financial Report'!$H$47=\"\",\"\",'Annual Financial Report'!$H$47)","v":0}]
["FTB-COD",{"$f":"IF('Annual Financial Report'!$J$37=\"\",\"\",'Annual Financial Report'!$J$37)","v":""},{"$f":"IF('Annual Financial Report'!$K$37=\"\",\"\",'Annual Financial Report'!$K$37)","v":0}]
["FTB-IIC",{"$f":"IF('Annual Financial Report'!$J$38=\"\",\"\",'Annual Financial Report'!$J$38)","v":""},{"$f":"IF('Annual Financial Report'!$K$38=\"\",\"\",'Annual Financial Report'!$K$38)","v":0},null,"ATP Cases-Cost","Online Cases","Online Cost","In-Person Cases","In-Person Cost"]
["Intrabranch",{"$f":"IF('Annual Financial Report'!$J$39=\"\",\"\",'Annual Financial Report'!$J$39)","v":""},{"$f":"IF('Annual Financial Report'!$K$39=\"\",\"\",'Annual Financial Report'!$K$39)","v":0},null,"Current",{"$f":"IF('Annual Financial Report'!$J$45=\"\",\"\",'Annual Financial Report'!$J$45)","v":""},{"$f":"IF('Annual Financial Report'!$K$45=\"\",\"\",'Annual Financial Report'!$K$45)","v":""},{"$f":"IF('Annual Financial Report'!$L$45=\"\",\"\",'Annual Financial Report'!$L$45)","v":""},{"$f":"IF('Annual Financial Report'!$M$45=\"\",\"\",'Annual Financial Report'!$M$45)","v":""}]
["Other",{"$f":"IF('Annual Financial Report'!$J$40=\"\",\"\",'Annual Financial Report'!$J$40)","v":""},{"$f":"IF('Annual Financial Report'!$K$40=\"\",\"\",'Annual Financial Report'!$K$40)","v":0},null,"Prior",{"$f":"IF('Annual Financial Report'!$J$46=\"\",\"\",'Annual Financial Report'!$J$46)","v":""},{"$f":"IF('Annual Financial Report'!$K$46=\"\",\"\",'Annual Financial Report'!$K$46)","v":""},{"$f":"IF('Annual Financial Report'!$L$46=\"\",\"\",'Annual Financial Report'!$L$46)","v":""},{"$f":"IF('Annual Financial Report'!$M$46=\"\",\"\",'Annual Financial Report'!$M$46)","v":""}]
[null,null,null,null,"Combined",{"$f":"IF('Annual Financial Report'!$J$47=\"\",\"\",'Annual Financial Report'!$J$47)","v":0},{"$f":"IF('Annual Financial Report'!$K$47=\"\",\"\",'Annual Financial Report'!$K$47)","v":0},{"$f":"IF('Annual Financial Report'!$L$47=\"\",\"\",'Annual Financial Report'!$L$47)","v":0},{"$f":"IF('Annual Financial Report'!$M$47=\"\",\"\",'Annual Financial Report'!$M$47)","v":0}]
[]
[]
["Restitution","CasesBeginning","ValueBeginning","CasesNew","ValueNew","RestitutionPd","CasesEnding","ValueEnding"]
["Court",{"$f":"IF('Annual Financial Report'!$C$52=\"\",\"\",'Annual Financial Report'!$C$52)","v":""},{"$f":"IF('Annual Financial Report'!$D$52=\"\",\"\",'Annual Financial Report'!$D$52)","v":""},{"$f":"IF('Annual Financial Report'!$E$52=\"\",\"\",'Annual Financial Report'!$E$52)","v":""},{"$f":"IF('Annual Financial Report'!$F$52=\"\",\"\",'Annual Financial Report'!$F$52)","v":""},{"$f":"IF('Annual Financial Report'!$G$52=\"\",\"\",'Annual Financial Report'!$G$52)","v":""},{"$f":"IF('Annual Financial Report'!$I$52=\"\",\"\",'Annual Financial Report'!$I$52)","v":""},{"$f":"IF('Annual Financial Report'!$J$52=\"\",\"\",'Annual Financial Report'!$J$52)","v":0}]
["County",{"$f":"IF('Annual Financial Report'!$C$53=\"\",\"\",'Annual Financial Report'!$C$53)","v":""},{"$f":"IF('Annual Financial Report'!$D$53=\"\",\"\",'Annual Financial Report'!$D$53)","v":""},{"$f":"IF('Annual Financial Report'!$E$53=\"\",\"\",'Annual Financial Report'!$E$53)","v":""},{"$f":"IF('Annual Financial Report'!$F$53=\"\",\"\",'Annual Financial Report'!$F$53)","v":""},{"$f":"IF('Annual Financial Report'!$G$53=\"\",\"\",'Annual Financial Report'!$G$53)","v":""},{"$f":"IF('Annual Financial Report'!$I$53=\"\",\"\",'Annual Financial Report'!$I$53)","v":""},{"$f":"IF('Annual Financial Report'!$J$53=\"\",\"\",'Annual Financial Report'!$J$53)","v":0}]
["Private Agency",{"$f":"IF('Annual Financial Report'!$C$54=\"\",\"\",'Annual Financial Report'!$C$54)","v":""},{"$f":"IF('Annual Financial Report'!$D$54=\"\",\"\",'Annual Financial Report'!$D$54)","v":""},{"$f":"IF('Annual Financial Report'!$E$54=\"\",\"\",'Annual Financial Report'!$E$54)","v":""},{"$f":"IF('Annual Financial Report'!$F$54=\"\",\"\",'Annual Financial Report'!$F$54)","v":""},{"$f":"IF('Annual Financial Report'!$G$54=\"\",\"\",'Annual Financial Report'!$G$54)","v":""},{"$f":"IF('Annual Financial Report'!$I$54=\"\",\"\",'Annual Financial Report'!$I$54)","v":""},{"$f":"IF('Annual Financial Report'!$J$54=\"\",\"\",'Annual Financial Report'!$J$54)","v":0}]
["FTB-COD",{"$f":"IF('Annual Financial Report'!$C$55=\"\",\"\",'Annual Financial Report'!$C$55)","v":""},{"$f":"IF('Annual Financial Report'!$D$55=\"\",\"\",'Annual Financial Report'!D$55)","v":""},{"$f":"IF('Annual Financial Report'!$E$55=\"\",\"\",'Annual Financial Report'!$E$55)","v":""},{"$f":"IF('Annual Financial Report'!$F$55=\"\",\"\",'Annual Financial Report'!$F$55)","v":""},{"$f":"IF('Annual Financial Report'!$G$55=\"\",\"\",'Annual Financial Report'!$G$55)","v":""},{"$f":"IF('Annual Financial Report'!$I$55=\"\",\"\",'Annual Financial Report'!$I$55)","v":""},{"$f":"IF('Annual Financial Report'!$J$55=\"\",\"\",'Annual Financial Report'!$J$55)","v":0}]
["FTB-IIC",{"$f":"IF('Annual Financial Report'!$C$56=\"\",\"\",'Annual Financial Report'!$C$56)","v":""},{"$f":"IF('Annual Financial Report'!$D$56=\"\",\"\",'Annual Financial Report'!D$56)","v":""},{"$f":"IF('Annual Financial Report'!$E$56=\"\",\"\",'Annual Financial Report'!$E$56)","v":""},{"$f":"IF('Annual Financial Report'!$F$56=\"\",\"\",'Annual Financial Report'!$F$56)","v":""},{"$f":"IF('Annual Financial Report'!$G$56=\"\",\"\",'Annual Financial Report'!$G$56)","v":""},{"$f":"IF('Annual Financial Report'!$I$56=\"\",\"\",'Annual Financial Report'!$I$56)","v":""},{"$f":"IF('Annual Financial Report'!$J$56=\"\",\"\",'Annual Financial Report'!$J$56)","v":0}]
["Intrabranch",{"$f":"IF('Annual Financial Report'!$C$57=\"\",\"\",'Annual Financial Report'!$C$57)","v":""},{"$f":"IF('Annual Financial Report'!$D$57=\"\",\"\",'Annual Financial Report'!$D$57)","v":""},{"$f":"IF('Annual Financial Report'!$E$57=\"\",\"\",'Annual Financial Report'!$E$57)","v":""},{"$f":"IF('Annual Financial Report'!$F$57=\"\",\"\",'Annual Financial Report'!$F$57)","v":""},{"$f":"IF('Annual Financial Report'!$G$57=\"\",\"\",'Annual Financial Report'!$G$57)","v":""},{"$f":"IF('Annual Financial Report'!$I$57=\"\",\"\",'Annual Financial Report'!$I$57)","v":""},{"$f":"IF('Annual Financial Report'!$J$57=\"\",\"\",'Annual Financial Report'!$J$57)","v":0}]
["Other",{"$f":"IF('Annual Financial Report'!$C$58=\"\",\"\",'Annual Financial Report'!$C$58)","v":""},{"$f":"IF('Annual Financial Report'!$D$58=\"\",\"\",'Annual Financial Report'!$D$58)","v":""},{"$f":"IF('Annual Financial Report'!$E$58=\"\",\"\",'Annual Financial Report'!$E$58)","v":""},{"$f":"IF('Annual Financial Report'!$F$58=\"\",\"\",'Annual Financial Report'!$F$58)","v":""},{"$f":"IF('Annual Financial Report'!$G$58=\"\",\"\",'Annual Financial Report'!$G$58)","v":""},{"$f":"IF('Annual Financial Report'!$I$58=\"\",\"\",'Annual Financial Report'!$I$58)","v":""},{"$f":"IF('Annual Financial Report'!$J$58=\"\",\"\",'Annual Financial Report'!$J$58)","v":0}]

{"sheet":"Performance Metrics","index":8,"n_rows":29,"n_cols":4,"rows_kept":29,"cut":false,"hidden":false,"merged":[[29,0,35,2],[22,0,23,0],[19,0,20,0],[16,0,17,0],[2,0,3,0],[28,0,28,2]]}
[]
[]
["Collector Effective Index","Current","Prior"]
[null,{"$f":"IFERROR('Annual Financial Report'!E17/'Annual Financial Report'!C17, \"\")","v":""},{"$f":"IFERROR('Annual Financial Report'!E29/'Annual Financial Report'!C29, \"\")","v":""}]
[]
["First Year Resolution Rate",{"$f":"IFERROR(1-('Annual Financial Report'!J17/'Annual Financial Report'!D17),\"\")","v":""}]
[]
["Spend Efficiency Score","Current","Prior","Combined"]
["Court Collection Program",{"$f":"IFERROR(ABS('Annual Financial Report'!G10/'Annual Financial Report'!F10),\"\")","v":""},{"$f":"IFERROR(ABS('Annual Financial Report'!G22/'Annual Financial Report'!F22),\"\")","v":""},{"$f":"IFERROR(ABS('Annual Financial Report'!F34/'Annual Financial Report'!E34),\"\")","v":""}]
["County Collection Program",{"$f":"IFERROR(ABS('Annual Financial Report'!G11/'Annual Financial Report'!F11),\"\")","v":""},{"$f":"IFERROR(ABS('Annual Financial Report'!G23/'Annual Financial Report'!F23),\"\")","v":""},{"$f":"IFERROR(ABS('Annual Financial Report'!F35/'Annual Financial Report'!E35),\"\")","v":""}]
["Private Agency",{"$f":"IFERROR(ABS('Annual Financial Report'!G12/'Annual Financial Report'!F12),\"\")","v":""},{"$f":"IFERROR(ABS('Annual Financial Report'!G24/'Annual Financial Report'!F24),\"\")","v":""},{"$f":"IFERROR(ABS('Annual Financial Report'!F36/'Annual Financial Report'!E36),\"\")","v":""}]
["FTB Court-Ordered Debt",{"$f":"IFERROR(ABS('Annual Financial Report'!G13/'Annual Financial Report'!F13),\"\")","v":""},{"$f":"IFERROR(ABS('Annual Financial Report'!G25/'Annual Financial Report'!F25),\"\")","v":""},{"$f":"IFERROR(ABS('Annual Financial Report'!F37/'Annual Financial Report'!E37),\"\")","v":""}]
["FTB Interagency Intercept Collection",{"$f":"IFERROR(ABS('Annual Financial Report'!G14/'Annual Financial Report'!F14),\"\")","v":""},{"$f":"IFERROR(ABS('Annual Financial Report'!G26/'Annual Financial Report'!F26),\"\")","v":""},{"$f":"IFERROR(ABS('Annual Financial Report'!F38/'Annual Financial Report'!E38),\"\")","v":""}]
["Intra-Branch Program",{"$f":"IFERROR(ABS('Annual Financial Report'!G15/'Annual Financial Report'!F15),\"\")","v":""},{"$f":"IFERROR(ABS('Annual Financial Report'!G27/'Annual Financial Report'!F27),\"\")","v":""},{"$f":"IFERROR(ABS('Annual Financial Report'!F39/'Annual Financial Report'!E39),\"\")","v":""}]
["Other",{"$f":"IFERROR(ABS('Annual Financial Report'!G16/'Annual Financial Report'!F16),\"\")","v":""},{"$f":"IFERROR(ABS('Annual Financial Report'!G28/'Annual Financial Report'!F28),\"\")","v":""},{"$f":"IFERROR(ABS('Annual Financial Report'!F40/'Annual Financial Report'!E40),\"\")","v":""}]
[]
["Cost to Referral Ratio","Current","Prior","Combined"]
[null,{"$f":"IFERROR(ABS('Annual Financial Report'!G17/'Annual Financial Report'!C17),\"\")","v":""},{"$f":"IFERROR(ABS('Annual Financial Report'!G29/'Annual Financial Report'!C29),\"\")","v":""},{"$f":"IFERROR(ABS('Annual Financial Report'!F41/'Annual Financial Report'!C41),\"\")","v":""}]
[]
["Adjustment Score","Adjustments","Score"]
[null,{"$f":"'Annual Financial Report'!G41","v":0},{"$f":"IFERROR((B21/'Annual Financial Report'!D41)*1000,\"\")","v":""}]
[]
["Discharge Score","Discharges","Score"]
[null,{"$f":"'Annual Financial Report'!H41","v":0},{"$f":"IFERROR((B24/'Annual Financial Report'!D41)*1000,\"\")","v":""}]
[]
["Risk Monitor",{"$f":"IFERROR('Annual Financial Report'!C17/('Annual Financial Report'!C17+'Annual Financial Report'!E9),\"\")","v":""}]
[]
[]
["Please provide any brief comments on your performance measures you wish included in the Dashboard for your program. (500 character maximum)"]

{"sheet":"Quality Checklist ","index":9,"n_rows":55,"n_cols":16,"rows_kept":55,"cut":false,"hidden":false,"merged":[[38,2,38,13],[39,2,39,13],[40,2,40,13],[41,2,41,13],[44,2,44,13],[42,2,42,13],[43,2,43,13],[45,2,45,13],[54,2,54,13],[15,0,15,13],[28,0,28,13],[46,0,46,13],[22,2,22,13],[21,2,21,13],[20,2,20,13],[53,2,53,13],[52,2,52,13],[27,2,27,13],[30,2,30,13],[51,2,51,13],[50,2,50,13],[49,2,49,13],[34,2,34,13],[48,2,48,13],[0,2,0,13],[32,2,32,13],[33,2,33,13],[25,2,25,13],[2,2,2,13],[3,2,3,13],[1,2,1,13],[24,2,24,13],[23,2,23,13],[26,2,26,13],[29,2,29,13],[4,2,4,13],[31,2,31,13],[6,2,6,13],[5,2,5,13],[7,2,7,13],[14,2,14,13],[10,2,10,13],[47,2,47,13],[18,2,18,13],[19,2,19,13],[8,2,8,13],[9,2,9,13],[16,2,16,13],[11,2,11,13],[12,2,12,13],[13,2,13,13],[17,2,17,13],[35,0,35,13],[36,2,36,13],[37,2,37,13]]}
["Row","Quality Checklist","CURRENT PERIOD: FINES, FEES, FORFEITURES, PENALTIES AND ASSESSMENTS"]
[1,null,"Row 3, Column D, includes revenues collected for non-delinquent infraction, misdemeanor, and felony cases that were paid in full on or before the due date, or current installment or accounts receivable (A/R) payment plan. Row 3, Column E includes the number of cases associated with non-delinquent revenue collections reported in Row 3, Column D.",null,null,null,null,null,null,null,null,null,null,null,false]
[2,null,"Rows 4-10 include all fines, fees, forfeitures, penalties, and assessments on traffic, criminal, and juvenile delinquency case types (infraction, misdemeanors, and felony), except victim restitution (see Rows 33-41 for more information).",null,null,null,null,null,null,null,null,null,null,null,false]
[3,null,"Rows 4-10, include newly established/referred/transferred cases, gross revenue collected, adjustments, or discharges posted during the reporting period. ",null,null,null,null,null,null,null,null,null,null,null,false]
[4,null,"Rows 4-10, Column B, include the total number of new cases established, referred, or transferred within the reporting period. Any cases that were previously established, but never referred or transferred to collections, are considered new cases and should be reported in this column (the corresponding value of these cases should be reported in Column C). If multiple cases were bundled into one case, only one (1) case should be reported in Column B.",null,null,null,null,null,null,null,null,null,null,null,false]
[5,null,"Rows 4-10, Column C, include the total value of the corresponding cases in Column B, that were established, referred, or transferred during the reporting period only.         ",null,null,null,null,null,null,null,null,null,null,null,false]
[6,null,"Rows 4-10, Column D, include the number of cases with payment(s) received during the reporting period. The number of cases reported may be equal to but not greater than the number of cases established in Column B. ",null,null,null,null,null,null,null,null,null,null,null,false]
[7,null,"Rows 4-10, Column E, include all monies received towards the satisfaction of delinquent court-ordered debt, including installment payments. ",null,null,null,null,null,null,null,null,null,null,null,false]
[8,null,"Rows 4-10, Column F, include the cost of collections that, pursuant to PC 1463.007, is allowable to offset revenue prior to distribution to other governmental entities. Cost of collections is entered in Column F as a negative number unless posting a reversal.",null,null,null,null,null,null,null,null,null,null,null,false]
[9,null,"Value reported in Column G includes the total value of court-ordered debt satisfied by court-ordered dismissal, suspension, or by means other than payment. An amount satisfied by means other than payment includes alternative sentences (e.g., community service or time served in custody in lieu of fine) or non-cash adjustment that decreases or increases the amount outstanding for individual debt items. ",null,null,null,null,null,null,null,null,null,null,null,false]
[10,null,"Value reported in Column H includes all debt deemed uncollectible that was established and discharged in the reporting period, per Government Code section 25257-25259.95.  ",null,null,null,null,null,null,null,null,null,null,null,false]
[11,null,"Column I is the change in value of Cases Referred/Established/Transferred minus (-) Gross Collections, Adjustments, and Discharged debt. (Column C - E - G - H). ",null,null,null,null,null,null,null,null,null,null,null,false]
[12,null,"Rows 4-10, Column J, includes the value of all cases set-up on an installment agreement (A/R or monthly installment payment plan) by the court or collecting entity.",null,null,null,null,null,null,null,null,null,null,null,false]
[13,null,"Rows 4-10, Column K, includes the balances from delinquent cases where the individual is non-compliant with the terms of the agreement (i.e., payments have not been received) and the plan was not reinstated at the end of the fiscal year.",null,null,null,null,null,null,null,null,null,null,null,false]
[14,null,"Column L is formula driven and calculates the percentage of fines and fees defaulted on by dividing the installment agreement balance (amount defaulted on) by the initial value of court-ordered debt set-up on payment plan (Col. K/ Col. J ) ",null,null,null,null,null,null,null,null,null,null,null,false]
["PRIOR PERIODS INVENTORY: FINES, FEES, FORFEITURES, PENALTIES AND ASSESSMENTS"]
[15,null,"Row 12, Column P, includes revenues collected for non-delinquent infraction, misdemeanor and felony cases that were paid in full on or before the due date, or current installment or accounts receivable (A/R) payment plan. Row 12, Column O includes the number of cases associated with non-delinquent revenue collections reported in Row 12, Column P. ",null,null,null,null,null,null,null,null,null,null,null,false]
[16,null,"Rows 13-19 include all fines, fees, forfeitures, penalties, and assessments on traffic, criminal, and juvenile delinquency case types (infraction, misdemeanors, and felonies), except victim restitution (see Row 33-41 for more information).",null,null,null,null,null,null,null,null,null,null,null,false]
[17,null,"Rows 13-19 include all cases in inventory referred or transferred to a collections program in a prior period, and gross revenue collected, court-ordered adjustments, or discharges that were received and posted during the current reporting period.",null,null,null,null,null,null,null,null,null,null,null,false]
[18,null,"Rows 13-19, Column O, include the number of cases with payments received during the reporting period. Note: any late postings from prior year should be reported in Column M, and the case value should be reported in Column N as part of the ending balance from prior year. ",null,null,null,null,null,null,null,null,null,null,null,false]
[19,null,"Rows 13-19, Column P, include all monies received towards the satisfaction of delinquent court-ordered debt. ",null,null,null,null,null,null,null,null,null,null,null,false]
[20,null,"Rows 13-19, Column Q, include the cost of collections that, pursuant to PC 1463.007, is allowable to offset revenue prior to distribution to other governmental entities. Cost of collections is entered in Column Q as a negative number unless posting a reversal.",null,null,null,null,null,null,null,null,null,null,null,false]
[21,null,"Rows 13-19, Column R, includes the total value of court-ordered debt satisfied by court-ordered dismissal, suspension, or by means other than payment. An amount satisfied by means other than payment includes alternative sentences (e.g., community service or time served in custody in lieu of fine) or non-cash adjustment that decreases or increases the amount outstanding for individual debt items. ",null,null,null,null,null,null,null,null,null,null,null,false]
[22,null,"Value reported in Column S includes all previously established debt deemed uncollectible and discharged in the reporting period, per Government Code section 25257-25259.95.  ",null,null,null,null,null,null,null,null,null,null,null,false]
[23,null,"Value reported in Column T is the change in Value of Cases (Ending Balance from Prior Year) minus (-) Gross Collections, Adjustments, and Discharged debt. (Column N - P - R - S). ",null,null,null,null,null,null,null,null,null,null,null,false]
[24,null,"Column U is the value of cases carried over from the prior year for all cases on an installment agreement that remained unpaid at the end of the year.  ",null,null,null,null,null,null,null,null,null,null,null,false]
[25,null,"Column V includes the balance from all cases on an installment agreement carried over where payment(s) were not received in the reporting period.",null,null,null,null,null,null,null,null,null,null,null,false]
[26,null,"Column W captures the percentage of delinquent fines and fees payable in installments that were defaulted on. The cell is formula driven and calculates a percentage by dividing the rolling balance by the value of cases (carried over) on installment agreements. (Column V/Column U) ",null,null,null,null,null,null,null,null,null,null,null,false]
["COMBINED: ENDING BALANCE FINES, FEES, FORFEITURES, PENALTIES AND ASSESSMENTS"]
[27,null,"Row 21, Column Z, includes the combined total of non-delinquent gross revenue collected.  ",null,null,null,null,null,null,null,null,null,null,null,false]
[28,null,"Rows 22-28, Columns X, Y, Z, AA, AB, AC and AD include the combined case number and value of new and prior period inventory, change in value, gross revenues, cost of collections, and adjustments, and discharge from accountability.",null,null,null,null,null,null,null,null,null,null,null,false]
[{"$f":"A31+1","v":29},null,"Rows 22-28, Columns X, Y, Z, AA, AB, AC and AD are formula driven, no input required. Value of Cases reported in Columns Y and AF reconcile to figures reported from underlying systems and vendors. ",null,null,null,null,null,null,null,null,null,null,null,false]
[{"$f":"A32+1","v":30},null,"Value reported in Column AE includes the total number of cases at the end of the reporting period for each program.",null,null,null,null,null,null,null,null,null,null,null,false]
[{"$f":"A33+1","v":31},null,"Values reported in Column AF balance to value of cases at beginning of period (Col. Y), minus the change in value reported in Col. AD (which is the sum of the amounts shown in Col. Z, AB and AC. ) ",null,null,null,null,null,null,null,null,null,null,null,false]
[32,null,"An Error Message in Column AG indicates that the beginning balance in Column Y, minus the value of transactions reported in Column AD does not equal the ending balance reported in Column AF. ",null,null,null,null,null,null,null,null,null,null,null,false]
["COLLECTIONS FROM CASES SUBJECT TO ABILITY-TO-PAY DETERMINATION",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"i"]
[33,null,"Row 30 includes revenues collected, number of cases, and cost of administering those cases which have been subject to an ability to pay (ATP) determination for cases newly established during the reporting period.  This information should ALSO be reported as part of the revenues reported in Rows 3-10  above.",null,null,null,null,null,null,null,null,null,null,null,false]
[34,null,"Row 31 includes revenues collected, number of cases, and cost of administering those cases which have been subject to an ATP determination for cases in inventory at the beginning of the reporting period.  This information should ALSO be reported as part of the revenues reported in Rows 12-19 above.",null,null,null,null,null,null,null,null,null,null,null,false]
[35,null,"Column AH includes revenue collected for nondelinquent ATP cases processed through the online tool established by Government Code section 68645.",null,null,null,null,null,null,null,null,null,null,null,false]
[36,null,"Column AI includes revenue collected for delinquent ATP cases processed through the online tool established by Government Code section 68645.",null,null,null,null,null,null,null,null,null,null,null,false]
[37,null,"Column AK includes revenue collected for nondelinquent ATP cases processed in-person, using a paper form, or other methods aside from the online ATP tool.",null,null,null,null,null,null,null,null,null,null,null,false]
[38,null,"Column AL includes revenue collected for delinquent ATP cases processed in-person, using a paper form, or other methods aside from the online ATP tool.",null,null,null,null,null,null,null,null,null,null,null,false]
[39,null,"Column AN includes the number of nondelinquent ATP cases with installment plans processed through the online tool established by Government Code section 68645.2.",null,null,null,null,null,null,null,null,null,null,null,false]
[40,null,"Column AO includes the administrative cost (up to $35 per case) for nondelinquent ATP cases with installment plans processed through the online tool established by Government Code section 68645.2.",null,null,null,null,null,null,null,null,null,null,null,false]
[41,null,"Column AP includes the number of nondelinquent ATP cases with installment plans processed in-person, using a paper form, or other methods aside from the online ATP tool.",null,null,null,null,null,null,null,null,null,null,null,false]
[42,null,"Column AQ includes the administrative cost (up to $35 per case) for nondelinquent ATP cases with installment plans processed in-person, using a paper form, or other methods aside from the online ATP tool.",null,null,null,null,null,null,null,null,null,null,null,false]
["VICTIM RESTITUTION"]
[43,null,"Row 33 includes only non-delinquent cases referred/established and revenue collected during the reporting period.",null,null,null,null,null,null,null,null,null,null,null,false]
[44,null,"Rows 34-40 include victim restitution not included in Rows 3-10 or 12-19",null,null,null,null,null,null,null,null,null,null,null,false]
[45,null,"Rows 34-40, include cases referred/established and revenue collected during the reporting period.",null,null,null,null,null,null,null,null,null,null,null,false]
[46,null,"Column AR includes the number of victim restitution cases in inventory at the beginning of the period. Column AS includes the value of victim restitution cases in inventory at the beginning of the period.",null,null,null,null,null,null,null,null,null,null,null,false]
[47,null,"Column AT represents the number of cases which reported payment of victim restitution during the reporting period.  Column AU includes the total amount of restitution owed to a victim by court order under Penal Code section 1202.4(f) collected by each collections program during the reporting period. Row 29 includes non-delinquent restitution collections.",null,null,null,null,null,null,null,null,null,null,null,false]
[48,null,"\nColumn AV includes the number of cases of delinquent restitution (new and inventory) not reported in rows 3-10 or 12-19.",null,null,null,null,null,null,null,null,null,null,null,false]
[49,null,"\nColumn AW includes the value of Col. AS plus the Col. AU less the amount shown in column AV (this field is formula-driven, so no separate calculation or entry is required).",null,null,null,null,null,null,null,null,null,null,null,false]
[50,null,"Column AX is blank unless errors or potential errors are detected in the worksheet. If an out of balance message appears correct the identified error or explain in Performance Report.",null,null,null,null,null,null,null,null,null,null,null,false]

{"sheet":"Transfer Worksheet","index":10,"n_rows":15,"n_cols":7,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,"Number of Delinquent Cases at Period Beginning \n(Ending Balance from Prior Year – Col. AE)","Value of Delinquent Cases at Period Beginning\n(Ending Balance from Prior Year – Col. AF)","Number of Cases Transferred Between Programs","Value of Cases Transferred Between Programs","Adjusted Number of Delinquent Cases at Period Beginning \n(Enter in Col. M)","Adjusted Value of Delinquent Cases at Period Beginning\n(Enter in Col. N)"]
["Program","Col. 1","Col. 2","Col. 3","Col. 4","Col. M","Col. N"]
["Non-Delinquent Collections"]
["Court Collection Program",null,null,null,null,{"$f":"SUM(B8+D8)","v":0},{"$f":"SUM(C8+E8)","v":0}]
["County Collection Program",null,null,null,null,{"$f":"SUM(B9+D9)","v":0},0]
["Private Agency",null,null,null,null,0,0]
["FTB Court-Ordered Debt",null,null,null,null,0,0]
["FTB Interagency Intercept Collection",null,null,null,null,0,0]
["Intra-Branch Program",null,null,null,null,0,0]
["Other",null,null,null,null,0,0]
["Sub-total Delinquent ",{"$f":"SUM(B8:B14)","v":0},{"$f":"SUM(C8:C14)","v":0},0,{"$f":"SUM(E8:E14)","v":0},{"$f":"SUM(F8:F14)","v":0},{"$f":"SUM(G8:G14)","v":0}]

{"sheet":"Categories","index":11,"n_rows":24,"n_cols":3,"rows_kept":24,"cut":false,"hidden":false,"merged":[[23,0,23,2],[21,1,22,1]]}
[]
["PC 1463.007 Collections Activity","Category"," Task/Activity "]
[]
["3a. Attempts telephone contact with delinquent debtors for whom the program has a telephone number ",null,"Outbound Call\nInbound Call "]
[null,"1= Telephone Contact"]
["k. Uses an automated dialer or automatic call distribution system to manage telephone calls.",null,"Dialer blast messaging "]
["3b. Notifies delinquent debtors for whom the program has an address in writing of their outstanding obligation within 95 days of delinquency. ",null,"Delinquent Notice (Failure to Appear or Failure to Pay) \nHandle all collections-related mail correspondence                                        \nE-mail received  \nEmail sent                                     "]
[null,"2=Written Notice(s)"]
["4e. Sends monthly bills or account statements to all delinquent debtors."]
["3c. Generates internal monthly reports to track collections data, such as age of debt and delinquent  amounts outstanding.  ","3= Lobby/Counter","Receive/post cash, check and credit card payments   \nProvide case  information to individuals\nEstablish payment plan agreements including amendments to existing plan  \nSchedule walk-in arraignment, upon individual's request to go before a judge\nUpdate DMV, if needed \nEnter notes on the case, etc. \nWork the Out of Court--Collection Queue (Judge orders case be handled in collections)   \nProcess all criminal and juvenile probation orders; update financials and establish payment plans. \nProcess all criminal and juvenile DA forms; update financials and establish payment plans\nProcess payments from Intra-branch, generate weekly payment report \nProcess payments and commission credit adjustments from private agency. Assist vendor w/case info., account balances, email them any directives from Judge on case and prepare commission checks at the end of month. \nProcess all payments and commission credit adjustments from FTB-COD. Contact FTB-COD for additional information such as account balances, levy actions, etc.   "]
[]
["3e. Accepts payment of delinquent debt by credit card. "]
["3d. Uses Department of Motor Vehicles information to locate delinquent debtors."]
["4f. Contracts with local, regional, state, or national skip tracing or locator resources or services to locate delinquent debtors.",null,"Perform skip tracing (DMV, internet, third party vendors)"]
[null,"4=Skip Tracing"]
["4g. Coordinates with the probation department to locate debtors who may be on formal or informal probation.  ",null,"Obtain debtor information from probation and/or EDD"]
["4h. Uses Employment Development Department employment and wage information to collect delinquent debt."]
["4a. Sends delinquent debt to the Franchise Tax Board’s Court-Ordered Debt Collections Program. ","5=FTB-COD ","Refer case to FTB-COD"]
["4b.Sends delinquent debt to the Franchise Tax Board’s Interagency Intercept Collections Program.","6= FTB-IIC","Refer case to FTB-IIC"]
["4c. Initiates driver’s license suspension or hold actions when appropriate for a failure to appear in court.","7=DL Hold/Suspension","Send abstract to DMV for Failure to Appear driver's license hold/suspension"]
["4d. Contracts with one or more private debt collectors to collect delinquent debt.","8= Private Agency","Refer case to private collection agency"]
["4i. Establishes wage and bank account garnishments where appropriate.","9= Wage/bank Garnishments and Liens","Wage and/or bank accounts are garnished"]
["4k. Places liens on real property owned by delinquent debtors when appropriate.",null,"Place liens"]
["Sample list of activities/tasks to be used to report activities utilized in the collection of delinquent court-ordered debt. See corresponding \"Category\"  on the Contact and Other Information Sheet, Items 5, 6 and 7. "]

{"sheet":"Code","index":12,"n_rows":59,"n_cols":7,"rows_kept":59,"cut":false,"hidden":true,"merged":[]}
["Not Selected","Select court/county (see Contact Information worksheet #1)",null,null,null,null," "]
["C010000","Court/County - Alameda",null,null,null,null,"County"]
["C020000","Court/County - Alpine",null,null,null,null,"Court"]
["C030000","Court/County - Amador",null,null,null,null,"Private Agency"]
["C040000","Court/County - Butte",null,null,null,null,"FTB-COD"]
["C050000","Court/County - Calaveras",null,null,null,null,"Intra-branch"]
["C060000","Court/County - Colusa",null,null,null,null,"None"]
["C070000","Court/County - Contra Costa"]
["C080000","Court/County - Del Norte"]
["C090000","Court/County - El Dorado"]
["C100000","Court/County - Fresno"]
["C110000","Court/County - Glenn"]
["C120000","Court/County - Humboldt"]
["C130000","Court/County - Imperial"]
["C140000","Court/County - Inyo"]
["C150000","Court/County - Kern"]
["C160000","Court/County - Kings"]
["C170000","Court/County - Lake"]
["C180000","Court/County - Lassen"]
["C190000","Court/County - Los Angeles"]
["C200000","Court/County - Madera"]
["C210000","Court/County - Marin"]
["C220000","Court/County - Mariposa"]
["C230000","Court/County - Mendocino"]
["C240000","Court/County - Merced"]
["C250000","Court/County - Modoc"]
["C260000","Court/County - Mono"]
["C270000","Court/County - Monterey"]
["C280000","Court/County - Napa"]
["C290000","Court/County - Nevada"]
["C300000","Court/County - Orange"]
["C310000","Court/County - Placer"]
["C320000","Court/County - Plumas"]
["C330000","Court/County - Riverside"]
["C340000","Court/County - Sacramento"]
["C350000","Court/County - San Benito"]
["C360000","Court/County - San Bernardino"]
["C370000","Court/County - San Diego"]
["C380000","Court/County - San Francisco"]
["C390000","Court/County - San Joaquin"]
["C400000","Court/County - San Luis Obispo"]
["C410000","Court/County - San Mateo"]
["C420000","Court/County - Santa Barbara"]
["C430000","Court/County - Santa Clara"]
["C440000","Court/County - Santa Cruz"]
["C450000","Court/County - Shasta"]
["C460000","Court/County - Sierra"]
["C470000","Court/County - Siskiyou"]
["C480000","Court/County - Solano"]
["C490000","Court/County - Sonoma"]
["C500000","Court/County - Stanislaus"]
["C510000","Court/County - Sutter"]
["C520000","Court/County - Tehama"]
["C530000","Court/County - Trinity"]
["C540000","Court/County - Tulare"]
["C550000","Court/County - Tuolumne"]
["C560000","Court/County - Ventura"]
["C570000","Court/County - Yolo"]
["C580000","Court/County - Yuba"]

{"sheet":"Best Practices","index":13,"n_rows":29,"n_cols":4,"rows_kept":29,"cut":false,"hidden":true,"merged":[]}
[]
[1,{"$f":"Program!D5","v":false},null,{"$f":"IF($B$2=FALSE,IF(COUNTIF($B$3:$B$23,TRUE)>=21,\" 1\",\" 1,\"),\"\")","v":" 1,"}]
[2,{"$f":"Program!D6","v":false},null,{"$f":"IF($B$3=FALSE,IF(COUNTIF($B$4:$B$23,TRUE)=20,IF(COUNTIF($B$2,TRUE)<1,\" and 2\",\" 2\"),\" 2,\"),\"\")","v":" 2,"}]
[3,{"$f":"Program!D7","v":false},null,{"$f":"IF($B$4=FALSE,IF(COUNTIF($B$5:$B$23,TRUE)=19,IF(COUNTIF($B$2:$B$3,TRUE)<2,\" and 3\",\" 3\"),\" 3,\"),\"\")","v":" 3,"}]
[4,{"$f":"Program!D8","v":false},null,{"$f":"IF($B$5=FALSE,IF(COUNTIF($B$6:$B$23,TRUE)=18,IF(COUNTIF($B$2:$B$4,TRUE)<3,\" and 4\",\" 4\"),\" 4,\"),\"\")","v":" 4,"}]
[5,{"$f":"Program!D9","v":false},null,{"$f":"IF($B$6=FALSE,IF(COUNTIF($B$7:$B$23,TRUE)=17,IF(COUNTIF($B$2:$B$5,TRUE)<4,\" and 5\",\" 5\"),\" 5,\"),\"\")","v":" 5,"}]
[6,{"$f":"Program!D10","v":false},null,{"$f":"IF($B$7=FALSE,IF(COUNTIF($B$8:$B$23,TRUE)=16,IF(COUNTIF($B$2:$B$6,TRUE)<5,\" and 6\",\" 6\"),\" 6,\"),\"\")","v":" 6,"}]
[7,{"$f":"Program!D11","v":false},null,{"$f":"IF($B$8=FALSE,IF(COUNTIF($B9:$B$23,TRUE)=15,IF(COUNTIF($B$2:$B7,TRUE)<6,\" and 7\",\" 7\"),\" 7,\"),\"\")","v":" 7,"}]
[8,{"$f":"Program!D12","v":false},null,{"$f":"IF($B$9=FALSE,IF(COUNTIF($B$10:$B$23,TRUE)=14,IF(COUNTIF($B$2:$B$8,TRUE)<7,\" and 8\",\" 8\"),\" 8,\"),\"\")","v":" 8,"}]
[9,{"$f":"Program!D13","v":false},null,{"$f":"IF($B$10=FALSE,IF(COUNTIF($B$11:$B$23,TRUE)=13,IF(COUNTIF($B$2:$B$9,TRUE)<8,\" and 9\",\" 9\"),\" 9,\"),\"\")","v":" 9,"}]
[10,{"$f":"Program!D14","v":false},null,{"$f":"IF($B$11=FALSE,IF(COUNTIF($B$12:$B$23,TRUE)=12,IF(COUNTIF($B$2:$B$10,TRUE)<9,\" and 10\",\" 10\"),\" 10,\"),\"\")","v":" 10,"}]
[11,{"$f":"Program!D15","v":false},null,{"$f":"IF($B$12=FALSE,IF(COUNTIF($B$13:B25,TRUE)=11,IF(COUNTIF($B$2:$B11,TRUE)<10,\" and 11\",\" 11\"),\" 11,\"),\"\")","v":" 11,"}]
[12,{"$f":"Program!D16","v":false},null,{"$f":"IF($B$13=FALSE,IF(COUNTIF($B$14:$B$23,TRUE)=10,IF(COUNTIF($B$2:$B$12,TRUE)<11,\" and 12\",\" 12\"),\" 12,\"),\"\")","v":" 12,"}]
[13,{"$f":"Program!D17","v":false},null,{"$f":"IF($B$14=FALSE,IF(COUNTIF($B$15:$B$23,TRUE)=9,IF(COUNTIF($B$2:$B$13,TRUE)<12,\" and 13\",\" 13\"),\" 13,\"),\"\")","v":" 13,"}]
[14,{"$f":"Program!D18","v":false},null,{"$f":"IF($B$15=FALSE,IF(COUNTIF($B$16:$B$23,TRUE)=8,IF(COUNTIF($B$2:$B$14,TRUE)<13,\" and 14\",\" 14\"),\" 14,\"),\"\")","v":" 14,"}]
[15,{"$f":"Program!D19","v":false},null,{"$f":"IF($B$16=FALSE,IF(COUNTIF($B$17:$B$23,TRUE)=7,IF(COUNTIF($B$2:$B$15,TRUE)<14,\" and 15\",\" 15\"),\" 15,\"),\"\")","v":" 15,"}]
[16,{"$f":"Program!D20","v":false},null,{"$f":"IF($B$17=FALSE,IF(COUNTIF($B$16:$B$23,TRUE)=6,IF(COUNTIF($B2:$B$16,TRUE)<15,\" and 16\",\" 16\"),\" 16,\"),\"\")","v":" 16,"}]
[17,{"$f":"Program!D21","v":false},null,{"$f":"IF($B$18=FALSE,IF(COUNTIF($B$19:$B$23,TRUE)=5,IF(COUNTIF($B$2:$B$17,TRUE)<16,\" and 17\",\" 17\"),\" 17,\"),\"\")","v":" 17,"}]
[18,{"$f":"Program!D22","v":false},null,{"$f":"IF($B$19=FALSE,IF(COUNTIF($B$20:$B$23,TRUE)=4,IF(COUNTIF($B$2:$B$18,TRUE)<17,\" and 18\",\" 18\"),\" 18,\"),\"\")","v":" 18,"}]
[19,{"$f":"Program!D23","v":false},null,{"$f":"IF($B$20=FALSE,IF(COUNTIF($B$21:$B$23,TRUE)=3,IF(COUNTIF($B$2:$B$19,TRUE)<18,\" and 19\",\" 19\"),\" 19,\"),\"\")","v":" 19,"}]
[20,{"$f":"Program!D24","v":false},null,{"$f":"IF($B$21=FALSE,IF(COUNTIF($B$22:$B$23,TRUE)=2,IF(COUNTIF($B$2:$B$20,TRUE)<19,\" and 20\",\" 20\"),\" 20,\"),\"\")","v":" 20,"}]
[21,{"$f":"Program!D25","v":false},null,{"$f":"IF($B$22=FALSE,IF(COUNTIF($B$23:$B$23,TRUE)=1,IF(COUNTIF($B$2:$B$21,TRUE)<20,\" and 21\",\" 21\"),\" 21,\"),\"\")","v":" 21,"}]
[22,{"$f":"Program!D26","v":false},null,{"$f":"IF($B$23=FALSE,IF(COUNTIF($B$2:$B$22,TRUE)<21,\" and 22\",\" 22\"),\"\")","v":" and 22"}]
[]
[]
[]
[null,{"$f":"(COUNTIF($B$2:$B$23,TRUE))","v":0}]
[null,{"$f":"IF($B$27<22,IF($B$27<21,\"The following best practices are currently not being met:\",\"The following best practice is currently not being met:\"),\"\")","v":"The following best practices are currently not being met:"}]
[null,{"$f":"D2&D3&D4&D5&D6&D7&D8&D9&D10&D11&D12&D13&D14&D15&D16&D17&D18&D19&D20&D21&D22&D23","v":" 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, and 22"}]