{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Drop-Downs","OVPT source","Overpayment Deadlines-CE","2019-2020 DX Receive Dates","2019 DX Receive Dates","W-2 Payment Calculator"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":2,"defined_names":22,"comments":2,"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":"Drop-Downs","index":0,"n_rows":8,"n_cols":19,"rows_kept":8,"cut":false,"hidden":true,"merged":[[0,13,0,14]]}
["Simple","More","Discrepancy Status","ClaimMore","Claim Needed? Status","Fraud Method","Incomplete","Claim","IPV","IPV Referral","Score","FCS",null,"Array Formula",null,"UIB Discrepancy Type","UIB dropdowns","BRITS Referral Type","Red Color Code"]
["Y","Y","Potential Fraud","n/a","Not Determined","Administrative Program Policy","Incomplete","n/a","N","Y","Pass","Y",null,"Y","Pass","Child Support Intercepted from UIB","Y-Change","Agency Error Claim",252]
["N","N","Resolved-Eligibility Issue","Incomplete","Y","District Attorney",null,"Incomplete","Y","N","Fail","N",null,"N","Fail","More than one payment missing","Y-End","Claim, FEV, or Fraud Investigation",168]
["Incomplete","n/a","Resolved-No Impact","Program Invalid","N","Citation",null,null,null,null,"n/a",null,null,"n/a","n/a","Working part time","Y-Employment","Incomplete",154]
[null,"Incomplete","Waiting for Customer Info",null,"Program Invalid","n/a",null,null,null,null,"Incomplete",null,null,"Incomplete","Incomplete",null,"Y"]
[null,"Void","Waiting for 3rd Party Ver",null,"n/a","Incomplete",null,null,null,null,null,null,null,null,null,null,"N"]
[null,null,"Incomplete",null,"Incomplete",null,null,null,null,null,null,null,null,null,null,null,"n/a"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Incomplete"]

{"sheet":"OVPT source","index":1,"n_rows":39,"n_cols":11,"rows_kept":39,"cut":false,"hidden":true,"merged":[]}
[]
["Time Limit Month","Payment Month","Participation Period","Days Count",null,"Placement","Days","Daily Rate",null,"Placement","Base Placement Amount"]
["January 2018","February 2018","12/16/17-1/15/18",31,null,"CSJ",31,21.06,null,"CSJ",653]
["February 2018","March 2018","1/16/18-2/15/18",31,null,"CSJ",30,21.77,null,"CS1",218]
["March 2018","April 2018","2/16/18-3/15/18",28,null,"CSJ",29,22.52,null,"CS2",327]
["April 2018","May 2018","3/16/18-4/15/18",31,null,"CSJ",28,23.32,null,"CS3",435]
["May 2018","June 2018","4/16/18-5/15/18",30,null,"CSJ",27,24.19,null,"W2T",608]
["June 2018","July 2018","5/16/18-6/15/18",31,null,"CS1",31,7.03,null,"CMC",673]
["July 2018","August 2018","6/16/18-7/15/18",30,null,"CS1",30,7.27,null,"ARP",673]
["August 2018","September 2018","7/16/18-8/15/18",31,null,"CS1",29,7.52]
["September 2018","October 2018","8/16/18-9/15/18",31,null,"CS1",28,7.79]
["October 2018","November 2018","9/16/18-10/15/18",30,null,"CS1",27,8.07]
["November 2018","December 2018","10/16/18-11/15/18",31,null,"CS2",31,10.55]
["December 2018","January 2019","11/16/18-12/15/18",30,null,"CS2",30,10.9]
["January 2019","February 2019","12/16/18-1/15/19",31,null,"CS2",29,11.28]
["February 2019","March 2019","1/16/19-2/15/19",31,null,"CS2",28,11.69]
["March 2019","April 2019","2/16/19-3/15/19",28,null,"CS2",27,12.11]
["April 2019","May 2019","3/16/19-4/15/19",31,null,"CS3",31,14.03]
["May 2019","June 2019","4/16/19-5/15/19",30,null,"CS3",30,14.5]
["June 2019","July 2019","5/16/19-6/15/19",31,null,"CS3",29,15]
["July 2019","August 2019","6/16/19-7/15/19",30,null,"CS3",28,15.54]
["August 2019","September 2019","7/16/19-8/15/19",31,null,"CS3",27,16.11]
["September 2019","October 2019","8/16/19-9/15/19",31,null,"CMC",31,21.71]
["October 2019","November 2019","9/16/19-10/15/19",30,null,"CMC",30,22.43]
["November 2019","December 2019","10/16/19-11/15/19",31,null,"CMC",29,23.21]
["December 2019","January 2019","11/16/19-12/15/19",30,null,"CMC",28,24.04]
["January 2020","February 2019","12/16/19-1/15/20",31,null,"CMC",27,24.93]
["February 2020","March 2020","1/16/20-2/15/20",31,null,"ARP",31,21.71]
["March 2020","April 2020","2/16/20-3/15/20",29,null,"ARP",30,22.43]
["April 2020","May 2020","3/16/20-4/15/20",31,null,"ARP",29,23.21]
["May 2020","June 2020","4/16/20-5/15/20",30,null,"ARP",28,24.04]
["June 2020","July 2020","5/16/20-6/15/20",31,null,"ARP",27,24.93]
["July 2020","August 2020","6/16/20-7/15/20",30,null,"W2T",31,19.61]
["August 2020","September 2020","7/16/20-8/15/20",31,null,"W2T",30,20.27]
["September 2020","October 2020","8/16/20-9/15/20",31,null,"W2T",29,20.97]
["October 2020","November 2020","9/16/20-10/15/20",30,null,"W2T",28,21.71]
["November 2020","December 2020","10/16/20-11/15/20",31,null,"W2T",27,22.52]
["December 2020","January 2021","11/16/20-12/15/20",30]
["January 2021","February 2021","12/16/20-1/15/21",31]

{"sheet":"Overpayment Deadlines-CE","index":2,"n_rows":732,"n_cols":2,"rows_kept":732,"cut":false,"hidden":true,"merged":[]}
["Calendar Date","Last Day to enter in OP for CE"]
["2019-01-01","2019-06-30"]
["2019-01-02","2019-06-30"]
["2019-01-03","2019-06-30"]
["2019-01-04","2019-06-30"]
["2019-01-05","2019-06-30"]
["2019-01-06","2019-06-30"]
["2019-01-07","2019-06-30"]
["2019-01-08","2019-06-30"]
["2019-01-09","2019-06-30"]
["2019-01-10","2019-06-30"]
["2019-01-11","2019-06-30"]
["2019-01-12","2019-06-30"]
["2019-01-13","2019-06-30"]
["2019-01-14","2019-06-30"]
["2019-01-15","2019-06-30"]
["2019-01-16","2019-06-30"]
["2019-01-17","2019-06-30"]
["2019-01-18","2019-06-30"]
["2019-01-19","2019-06-30"]
["2019-01-20","2019-06-30"]
["2019-01-21","2019-06-30"]
["2019-01-22","2019-06-30"]
["2019-01-23","2019-06-30"]
["2019-01-24","2019-06-30"]
["2019-01-25","2019-06-30"]
["2019-01-26","2019-06-30"]
["2019-01-27","2019-06-30"]
["2019-01-28","2019-06-30"]
["2019-01-29","2019-06-30"]
["2019-01-30","2019-06-30"]
["2019-01-31","2019-06-30"]
["2019-02-01","2019-06-30"]
["2019-02-02","2019-06-30"]
["2019-02-03","2019-06-30"]
["2019-02-04","2019-06-30"]
["2019-02-05","2019-06-30"]
["2019-02-06","2019-06-30"]
["2019-02-07","2019-06-30"]
["2019-02-08","2019-06-30"]
["2019-02-09","2019-06-30"]
["2019-02-10","2019-06-30"]
["2019-02-11","2019-06-30"]
["2019-02-12","2019-06-30"]
["2019-02-13","2019-06-30"]
["2019-02-14","2019-06-30"]
["2019-02-15","2019-06-30"]
["2019-02-16","2019-06-30"]
["2019-02-17","2019-06-30"]
["2019-02-18","2019-06-30"]
["2019-02-19","2019-06-30"]
["2019-02-20","2019-06-30"]
["2019-02-21","2019-06-30"]
["2019-02-22","2019-06-30"]
["2019-02-23","2019-06-30"]
["2019-02-24","2019-06-30"]
["2019-02-25","2019-06-30"]
["2019-02-26","2019-06-30"]
["2019-02-27","2019-06-30"]
["2019-02-28","2019-06-30"]
["2019-03-01","2019-06-30"]
["2019-03-02","2019-06-30"]
["2019-03-03","2019-06-30"]
["2019-03-04","2019-06-30"]
["2019-03-05","2019-06-30"]
["2019-03-06","2019-06-30"]
["2019-03-07","2019-06-30"]
["2019-03-08","2019-06-30"]
["2019-03-09","2019-06-30"]
["2019-03-10","2019-06-30"]
["2019-03-11","2019-06-30"]
["2019-03-12","2019-06-30"]
["2019-03-13","2019-06-30"]
["2019-03-14","2019-06-30"]
["2019-03-15","2019-06-30"]
["2019-03-16","2019-06-30"]
["2019-03-17","2019-06-30"]
["2019-03-18","2019-06-30"]
["2019-03-19","2019-06-30"]
["2019-03-20","2019-06-30"]
["2019-03-21","2019-06-30"]
["2019-03-22","2019-06-30"]
["2019-03-23","2019-06-30"]
["2019-03-24","2019-06-30"]
["2019-03-25","2019-06-30"]
["2019-03-26","2019-06-30"]
["2019-03-27","2019-06-30"]
["2019-03-28","2019-06-30"]
["2019-03-29","2019-06-30"]
["2019-03-30","2019-06-30"]
["2019-03-31","2019-06-30"]
["2019-04-01","2019-09-30"]
["2019-04-02","2019-09-30"]
["2019-04-03","2019-09-30"]
["2019-04-04","2019-09-30"]
["2019-04-05","2019-09-30"]
["2019-04-06","2019-09-30"]
["2019-04-07","2019-09-30"]
["2019-04-08","2019-09-30"]
["2019-04-09","2019-09-30"]
["2019-04-10","2019-09-30"]
["2019-04-11","2019-09-30"]
["2019-04-12","2019-09-30"]
["2019-04-13","2019-09-30"]
["2019-04-14","2019-09-30"]
["2019-04-15","2019-09-30"]
["2019-04-16","2019-09-30"]
["2019-04-17","2019-09-30"]
["2019-04-18","2019-09-30"]
["2019-04-19","2019-09-30"]
["2019-04-20","2019-09-30"]
["2019-04-21","2019-09-30"]
["2019-04-22","2019-09-30"]
["2019-04-23","2019-09-30"]
["2019-04-24","2019-09-30"]
["2019-04-25","2019-09-30"]
["2019-04-26","2019-09-30"]
["2019-04-27","2019-09-30"]
["2019-04-28","2019-09-30"]
["2019-04-29","2019-09-30"]
["2019-04-30","2019-09-30"]
["2019-05-01","2019-09-30"]
["2019-05-02","2019-09-30"]
["2019-05-03","2019-09-30"]
["2019-05-04","2019-09-30"]
["2019-05-05","2019-09-30"]
["2019-05-06","2019-09-30"]
["2019-05-07","2019-09-30"]
["2019-05-08","2019-09-30"]
["2019-05-09","2019-09-30"]
["2019-05-10","2019-09-30"]
["2019-05-11","2019-09-30"]
["2019-05-12","2019-09-30"]
["2019-05-13","2019-09-30"]
["2019-05-14","2019-09-30"]
["2019-05-15","2019-09-30"]
["2019-05-16","2019-09-30"]
["2019-05-17","2019-09-30"]
["2019-05-18","2019-09-30"]
["2019-05-19","2019-09-30"]
["2019-05-20","2019-09-30"]
["2019-05-21","2019-09-30"]
["2019-05-22","2019-09-30"]
["2019-05-23","2019-09-30"]
["2019-05-24","2019-09-30"]
["2019-05-25","2019-09-30"]
["2019-05-26","2019-09-30"]
["2019-05-27","2019-09-30"]
["2019-05-28","2019-09-30"]
["2019-05-29","2019-09-30"]
["2019-05-30","2019-09-30"]
["2019-05-31","2019-09-30"]
["2019-06-01","2019-09-30"]
["2019-06-02","2019-09-30"]
["2019-06-03","2019-09-30"]
["2019-06-04","2019-09-30"]
["2019-06-05","2019-09-30"]
["2019-06-06","2019-09-30"]
["2019-06-07","2019-09-30"]
["2019-06-08","2019-09-30"]
["2019-06-09","2019-09-30"]
["2019-06-10","2019-09-30"]
["2019-06-11","2019-09-30"]
["2019-06-12","2019-09-30"]
["2019-06-13","2019-09-30"]
["2019-06-14","2019-09-30"]
["2019-06-15","2019-09-30"]
["2019-06-16","2019-09-30"]
["2019-06-17","2019-09-30"]
["2019-06-18","2019-09-30"]
["2019-06-19","2019-09-30"]
["2019-06-20","2019-09-30"]
["2019-06-21","2019-09-30"]
["2019-06-22","2019-09-30"]
["2019-06-23","2019-09-30"]
["2019-06-24","2019-09-30"]
["2019-06-25","2019-09-30"]
["2019-06-26","2019-09-30"]
["2019-06-27","2019-09-30"]
["2019-06-28","2019-09-30"]
["2019-06-29","2019-09-30"]
["2019-06-30","2019-09-30"]
["2019-07-01","2019-12-31"]
["2019-07-02","2019-12-31"]
["2019-07-03","2019-12-31"]
["2019-07-04","2019-12-31"]
["2019-07-05","2019-12-31"]
["2019-07-06","2019-12-31"]
["2019-07-07","2019-12-31"]
["2019-07-08","2019-12-31"]
["2019-07-09","2019-12-31"]
["2019-07-10","2019-12-31"]
["2019-07-11","2019-12-31"]
["2019-07-12","2019-12-31"]
["2019-07-13","2019-12-31"]
["2019-07-14","2019-12-31"]
["2019-07-15","2019-12-31"]
["2019-07-16","2019-12-31"]
["2019-07-17","2019-12-31"]
["2019-07-18","2019-12-31"]
["2019-07-19","2019-12-31"]
["2019-07-20","2019-12-31"]
["2019-07-21","2019-12-31"]
["2019-07-22","2019-12-31"]
["2019-07-23","2019-12-31"]
["2019-07-24","2019-12-31"]
["2019-07-25","2019-12-31"]
["2019-07-26","2019-12-31"]
["2019-07-27","2019-12-31"]
["2019-07-28","2019-12-31"]
["2019-07-29","2019-12-31"]
["2019-07-30","2019-12-31"]
["2019-07-31","2019-12-31"]
["2019-08-01","2019-12-31"]
["2019-08-02","2019-12-31"]
["2019-08-03","2019-12-31"]
["2019-08-04","2019-12-31"]
["2019-08-05","2019-12-31"]
["2019-08-06","2019-12-31"]
["2019-08-07","2019-12-31"]
["2019-08-08","2019-12-31"]
["2019-08-09","2019-12-31"]
["2019-08-10","2019-12-31"]
["2019-08-11","2019-12-31"]
["2019-08-12","2019-12-31"]
["2019-08-13","2019-12-31"]
["2019-08-14","2019-12-31"]
["2019-08-15","2019-12-31"]
["2019-08-16","2019-12-31"]
["2019-08-17","2019-12-31"]
["2019-08-18","2019-12-31"]
["2019-08-19","2019-12-31"]
["2019-08-20","2019-12-31"]
["2019-08-21","2019-12-31"]
["2019-08-22","2019-12-31"]
["2019-08-23","2019-12-31"]
["2019-08-24","2019-12-31"]
["2019-08-25","2019-12-31"]
["2019-08-26","2019-12-31"]
["2019-08-27","2019-12-31"]
["2019-08-28","2019-12-31"]
["2019-08-29","2019-12-31"]
["2019-08-30","2019-12-31"]
["2019-08-31","2019-12-31"]
["2019-09-01","2019-12-31"]
["2019-09-02","2019-12-31"]
["2019-09-03","2019-12-31"]
["2019-09-04","2019-12-31"]
["2019-09-05","2019-12-31"]
["2019-09-06","2019-12-31"]
["2019-09-07","2019-12-31"]
["2019-09-08","2019-12-31"]
["2019-09-09","2019-12-31"]
["2019-09-10","2019-12-31"]
["2019-09-11","2019-12-31"]
["2019-09-12","2019-12-31"]
["2019-09-13","2019-12-31"]
["2019-09-14","2019-12-31"]
["2019-09-15","2019-12-31"]
["2019-09-16","2019-12-31"]
["2019-09-17","2019-12-31"]
["2019-09-18","2019-12-31"]
["2019-09-19","2019-12-31"]
["2019-09-20","2019-12-31"]
["2019-09-21","2019-12-31"]
["2019-09-22","2019-12-31"]
["2019-09-23","2019-12-31"]
["2019-09-24","2019-12-31"]
["2019-09-25","2019-12-31"]
["2019-09-26","2019-12-31"]
["2019-09-27","2019-12-31"]
["2019-09-28","2019-12-31"]
["2019-09-29","2019-12-31"]
["2019-09-30","2019-12-31"]
["2019-10-01","2020-03-31"]
["2019-10-02","2020-03-31"]
["2019-10-03","2020-03-31"]
["2019-10-04","2020-03-31"]
["2019-10-05","2020-03-31"]
["2019-10-06","2020-03-31"]
["2019-10-07","2020-03-31"]
["2019-10-08","2020-03-31"]
["2019-10-09","2020-03-31"]
["2019-10-10","2020-03-31"]
["2019-10-11","2020-03-31"]
["2019-10-12","2020-03-31"]
["2019-10-13","2020-03-31"]
["2019-10-14","2020-03-31"]
["2019-10-15","2020-03-31"]
["2019-10-16","2020-03-31"]
["2019-10-17","2020-03-31"]
["2019-10-18","2020-03-31"]
["2019-10-19","2020-03-31"]
["2019-10-20","2020-03-31"]
["2019-10-21","2020-03-31"]
["2019-10-22","2020-03-31"]
["2019-10-23","2020-03-31"]
["2019-10-24","2020-03-31"]
["2019-10-25","2020-03-31"]
["2019-10-26","2020-03-31"]
["2019-10-27","2020-03-31"]
["2019-10-28","2020-03-31"]
["2019-10-29","2020-03-31"]
["2019-10-30","2020-03-31"]
["2019-10-31","2020-03-31"]
["2019-11-01","2020-03-31"]
["2019-11-02","2020-03-31"]
["2019-11-03","2020-03-31"]
["2019-11-04","2020-03-31"]
["2019-11-05","2020-03-31"]
["2019-11-06","2020-03-31"]
["2019-11-07","2020-03-31"]
["2019-11-08","2020-03-31"]
["2019-11-09","2020-03-31"]
["2019-11-10","2020-03-31"]
["2019-11-11","2020-03-31"]
["2019-11-12","2020-03-31"]
["2019-11-13","2020-03-31"]
["2019-11-14","2020-03-31"]
["2019-11-15","2020-03-31"]
["2019-11-16","2020-03-31"]
["2019-11-17","2020-03-31"]
["2019-11-18","2020-03-31"]
["2019-11-19","2020-03-31"]
["2019-11-20","2020-03-31"]
["2019-11-21","2020-03-31"]
["2019-11-22","2020-03-31"]
["2019-11-23","2020-03-31"]
["2019-11-24","2020-03-31"]
["2019-11-25","2020-03-31"]
["2019-11-26","2020-03-31"]
["2019-11-27","2020-03-31"]
["2019-11-28","2020-03-31"]
["2019-11-29","2020-03-31"]
["2019-11-30","2020-03-31"]
["2019-12-01","2020-03-31"]
["2019-12-02","2020-03-31"]
["2019-12-03","2020-03-31"]
["2019-12-04","2020-03-31"]
["2019-12-05","2020-03-31"]
["2019-12-06","2020-03-31"]
["2019-12-07","2020-03-31"]
["2019-12-08","2020-03-31"]
["2019-12-09","2020-03-31"]
["2019-12-10","2020-03-31"]
["2019-12-11","2020-03-31"]
["2019-12-12","2020-03-31"]
["2019-12-13","2020-03-31"]
["2019-12-14","2020-03-31"]
["2019-12-15","2020-03-31"]
["2019-12-16","2020-03-31"]
["2019-12-17","2020-03-31"]
["2019-12-18","2020-03-31"]
["2019-12-19","2020-03-31"]
["2019-12-20","2020-03-31"]
["2019-12-21","2020-03-31"]
["2019-12-22","2020-03-31"]
["2019-12-23","2020-03-31"]
["2019-12-24","2020-03-31"]
["2019-12-25","2020-03-31"]
["2019-12-26","2020-03-31"]
["2019-12-27","2020-03-31"]
["2019-12-28","2020-03-31"]
["2019-12-29","2020-03-31"]
["2019-12-30","2020-03-31"]
["2019-12-31","2020-03-31"]
["2020-01-01","2020-06-30"]
["2020-01-02","2020-06-30"]
["2020-01-03","2020-06-30"]
["2020-01-04","2020-06-30"]
["2020-01-05","2020-06-30"]
["2020-01-06","2020-06-30"]
["2020-01-07","2020-06-30"]
["2020-01-08","2020-06-30"]
["2020-01-09","2020-06-30"]
["2020-01-10","2020-06-30"]
["2020-01-11","2020-06-30"]
["2020-01-12","2020-06-30"]
["2020-01-13","2020-06-30"]
["2020-01-14","2020-06-30"]
["2020-01-15","2020-06-30"]
["2020-01-16","2020-06-30"]
["2020-01-17","2020-06-30"]
["2020-01-18","2020-06-30"]
["2020-01-19","2020-06-30"]
["2020-01-20","2020-06-30"]
["2020-01-21","2020-06-30"]
["2020-01-22","2020-06-30"]
["2020-01-23","2020-06-30"]
["2020-01-24","2020-06-30"]
["2020-01-25","2020-06-30"]
["2020-01-26","2020-06-30"]
["2020-01-27","2020-06-30"]
["2020-01-28","2020-06-30"]
["2020-01-29","2020-06-30"]
["2020-01-30","2020-06-30"]
["2020-01-31","2020-06-30"]
["2020-02-01","2020-06-30"]
["2020-02-02","2020-06-30"]
["2020-02-03","2020-06-30"]
["2020-02-04","2020-06-30"]
["2020-02-05","2020-06-30"]
["2020-02-06","2020-06-30"]
["2020-02-07","2020-06-30"]
["2020-02-08","2020-06-30"]
["2020-02-09","2020-06-30"]
["2020-02-10","2020-06-30"]
["2020-02-11","2020-06-30"]
["2020-02-12","2020-06-30"]
["2020-02-13","2020-06-30"]
["2020-02-14","2020-06-30"]
["2020-02-15","2020-06-30"]
["2020-02-16","2020-06-30"]
["2020-02-17","2020-06-30"]
["2020-02-18","2020-06-30"]
["2020-02-19","2020-06-30"]
["2020-02-20","2020-06-30"]
["2020-02-21","2020-06-30"]
["2020-02-22","2020-06-30"]
["2020-02-23","2020-06-30"]
["2020-02-24","2020-06-30"]
["2020-02-25","2020-06-30"]
["2020-02-26","2020-06-30"]
["2020-02-27","2020-06-30"]
["2020-02-28","2020-06-30"]
["2020-02-29","2020-06-30"]
["2020-03-01","2020-06-30"]
["2020-03-02","2020-06-30"]
["2020-03-03","2020-06-30"]
["2020-03-04","2020-06-30"]
["2020-03-05","2020-06-30"]
["2020-03-06","2020-06-30"]
["2020-03-07","2020-06-30"]
["2020-03-08","2020-06-30"]
["2020-03-09","2020-06-30"]
["2020-03-10","2020-06-30"]
["2020-03-11","2020-06-30"]
["2020-03-12","2020-06-30"]
["2020-03-13","2020-06-30"]
["2020-03-14","2020-06-30"]
["2020-03-15","2020-06-30"]
["2020-03-16","2020-06-30"]
["2020-03-17","2020-06-30"]
["2020-03-18","2020-06-30"]
["2020-03-19","2020-06-30"]
["2020-03-20","2020-06-30"]
["2020-03-21","2020-06-30"]
["2020-03-22","2020-06-30"]
["2020-03-23","2020-06-30"]
["2020-03-24","2020-06-30"]
["2020-03-25","2020-06-30"]
["2020-03-26","2020-06-30"]
["2020-03-27","2020-06-30"]
["2020-03-28","2020-06-30"]
["2020-03-29","2020-06-30"]
["2020-03-30","2020-06-30"]
["2020-03-31","2020-06-30"]
["2020-04-01","2020-09-30"]
["2020-04-02","2020-09-30"]
["2020-04-03","2020-09-30"]
["2020-04-04","2020-09-30"]
["2020-04-05","2020-09-30"]
["2020-04-06","2020-09-30"]
["2020-04-07","2020-09-30"]
["2020-04-08","2020-09-30"]
["2020-04-09","2020-09-30"]
["2020-04-10","2020-09-30"]
["2020-04-11","2020-09-30"]
["2020-04-12","2020-09-30"]
["2020-04-13","2020-09-30"]
["2020-04-14","2020-09-30"]
["2020-04-15","2020-09-30"]
["2020-04-16","2020-09-30"]
["2020-04-17","2020-09-30"]
["2020-04-18","2020-09-30"]
["2020-04-19","2020-09-30"]
["2020-04-20","2020-09-30"]
["2020-04-21","2020-09-30"]
["2020-04-22","2020-09-30"]
["2020-04-23","2020-09-30"]
["2020-04-24","2020-09-30"]
["2020-04-25","2020-09-30"]
["2020-04-26","2020-09-30"]
["2020-04-27","2020-09-30"]
["2020-04-28","2020-09-30"]
["2020-04-29","2020-09-30"]
["2020-04-30","2020-09-30"]
["2020-05-01","2020-09-30"]
["2020-05-02","2020-09-30"]
["2020-05-03","2020-09-30"]
["2020-05-04","2020-09-30"]
["2020-05-05","2020-09-30"]
["2020-05-06","2020-09-30"]
["2020-05-07","2020-09-30"]
["2020-05-08","2020-09-30"]
["2020-05-09","2020-09-30"]
["2020-05-10","2020-09-30"]
["2020-05-11","2020-09-30"]
["2020-05-12","2020-09-30"]
["2020-05-13","2020-09-30"]
["2020-05-14","2020-09-30"]
["2020-05-15","2020-09-30"]
["2020-05-16","2020-09-30"]
["2020-05-17","2020-09-30"]
["2020-05-18","2020-09-30"]
["2020-05-19","2020-09-30"]
["2020-05-20","2020-09-30"]
["2020-05-21","2020-09-30"]
["2020-05-22","2020-09-30"]
["2020-05-23","2020-09-30"]
["2020-05-24","2020-09-30"]
["2020-05-25","2020-09-30"]
["2020-05-26","2020-09-30"]
["2020-05-27","2020-09-30"]
["2020-05-28","2020-09-30"]
["2020-05-29","2020-09-30"]
["2020-05-30","2020-09-30"]
["2020-05-31","2020-09-30"]
["2020-06-01","2020-09-30"]
["2020-06-02","2020-09-30"]
["2020-06-03","2020-09-30"]
["2020-06-04","2020-09-30"]
["2020-06-05","2020-09-30"]
["2020-06-06","2020-09-30"]
["2020-06-07","2020-09-30"]
["2020-06-08","2020-09-30"]
["2020-06-09","2020-09-30"]
["2020-06-10","2020-09-30"]
["2020-06-11","2020-09-30"]
["2020-06-12","2020-09-30"]
["2020-06-13","2020-09-30"]
["2020-06-14","2020-09-30"]
["2020-06-15","2020-09-30"]
["2020-06-16","2020-09-30"]
["2020-06-17","2020-09-30"]
["2020-06-18","2020-09-30"]
["2020-06-19","2020-09-30"]
["2020-06-20","2020-09-30"]
["2020-06-21","2020-09-30"]
["2020-06-22","2020-09-30"]
["2020-06-23","2020-09-30"]
["2020-06-24","2020-09-30"]
["2020-06-25","2020-09-30"]
["2020-06-26","2020-09-30"]
["2020-06-27","2020-09-30"]
["2020-06-28","2020-09-30"]
["2020-06-29","2020-09-30"]
["2020-06-30","2020-12-31"]
["2020-07-01","2020-12-31"]
["2020-07-02","2020-12-31"]
["2020-07-03","2020-12-31"]
["2020-07-04","2020-12-31"]
["2020-07-05","2020-12-31"]
["2020-07-06","2020-12-31"]
["2020-07-07","2020-12-31"]
["2020-07-08","2020-12-31"]
["2020-07-09","2020-12-31"]
["2020-07-10","2020-12-31"]
["2020-07-11","2020-12-31"]
["2020-07-12","2020-12-31"]
["2020-07-13","2020-12-31"]
["2020-07-14","2020-12-31"]
["2020-07-15","2020-12-31"]
["2020-07-16","2020-12-31"]
["2020-07-17","2020-12-31"]
["2020-07-18","2020-12-31"]
["2020-07-19","2020-12-31"]
["2020-07-20","2020-12-31"]
["2020-07-21","2020-12-31"]
["2020-07-22","2020-12-31"]
["2020-07-23","2020-12-31"]
["2020-07-24","2020-12-31"]
["2020-07-25","2020-12-31"]
["2020-07-26","2020-12-31"]
["2020-07-27","2020-12-31"]
["2020-07-28","2020-12-31"]
["2020-07-29","2020-12-31"]
["2020-07-30","2020-12-31"]
["2020-07-31","2020-12-31"]
["2020-08-01","2020-12-31"]
["2020-08-02","2020-12-31"]
["2020-08-03","2020-12-31"]
["2020-08-04","2020-12-31"]
["2020-08-05","2020-12-31"]
["2020-08-06","2020-12-31"]
["2020-08-07","2020-12-31"]
["2020-08-08","2020-12-31"]
["2020-08-09","2020-12-31"]
["2020-08-10","2020-12-31"]
["2020-08-11","2020-12-31"]
["2020-08-12","2020-12-31"]
["2020-08-13","2020-12-31"]
["2020-08-14","2020-12-31"]
["2020-08-15","2020-12-31"]
["2020-08-16","2020-12-31"]
["2020-08-17","2020-12-31"]
["2020-08-18","2020-12-31"]
["2020-08-19","2020-12-31"]
["2020-08-20","2020-12-31"]
["2020-08-21","2020-12-31"]
["2020-08-22","2020-12-31"]
["2020-08-23","2020-12-31"]
["2020-08-24","2020-12-31"]
["2020-08-25","2020-12-31"]
["2020-08-26","2020-12-31"]
["2020-08-27","2020-12-31"]
["2020-08-28","2020-12-31"]
["2020-08-29","2020-12-31"]
["2020-08-30","2020-12-31"]
["2020-08-31","2020-12-31"]
["2020-09-01","2020-12-31"]
["2020-09-02","2020-12-31"]
["2020-09-03","2020-12-31"]
["2020-09-04","2020-12-31"]
["2020-09-05","2020-12-31"]
["2020-09-06","2020-12-31"]
["2020-09-07","2020-12-31"]
["2020-09-08","2020-12-31"]
["2020-09-09","2020-12-31"]
["2020-09-10","2020-12-31"]
["2020-09-11","2020-12-31"]
["2020-09-12","2020-12-31"]
["2020-09-13","2020-12-31"]
["2020-09-14","2020-12-31"]
["2020-09-15","2020-12-31"]
["2020-09-16","2020-12-31"]
["2020-09-17","2020-12-31"]
["2020-09-18","2020-12-31"]
["2020-09-19","2020-12-31"]
["2020-09-20","2020-12-31"]
["2020-09-21","2020-12-31"]
["2020-09-22","2020-12-31"]
["2020-09-23","2020-12-31"]
["2020-09-24","2020-12-31"]
["2020-09-25","2020-12-31"]
["2020-09-26","2020-12-31"]
["2020-09-27","2020-12-31"]
["2020-09-28","2020-12-31"]
["2020-09-29","2020-12-31"]
["2020-09-30","2020-12-31"]
["2020-10-01","2021-03-31"]
["2020-10-02","2021-03-31"]
["2020-10-03","2021-03-31"]
["2020-10-04","2021-03-31"]
["2020-10-05","2021-03-31"]
["2020-10-06","2021-03-31"]
["2020-10-07","2021-03-31"]
["2020-10-08","2021-03-31"]
["2020-10-09","2021-03-31"]
["2020-10-10","2021-03-31"]
["2020-10-11","2021-03-31"]
["2020-10-12","2021-03-31"]
["2020-10-13","2021-03-31"]
["2020-10-14","2021-03-31"]
["2020-10-15","2021-03-31"]
["2020-10-16","2021-03-31"]
["2020-10-17","2021-03-31"]
["2020-10-18","2021-03-31"]
["2020-10-19","2021-03-31"]
["2020-10-20","2021-03-31"]
["2020-10-21","2021-03-31"]
["2020-10-22","2021-03-31"]
["2020-10-23","2021-03-31"]
["2020-10-24","2021-03-31"]
["2020-10-25","2021-03-31"]
["2020-10-26","2021-03-31"]
["2020-10-27","2021-03-31"]
["2020-10-28","2021-03-31"]
["2020-10-29","2021-03-31"]
["2020-10-30","2021-03-31"]
["2020-10-31","2021-03-31"]
["2020-11-01","2021-03-31"]
["2020-11-02","2021-03-31"]
["2020-11-03","2021-03-31"]
["2020-11-04","2021-03-31"]
["2020-11-05","2021-03-31"]
["2020-11-06","2021-03-31"]
["2020-11-07","2021-03-31"]
["2020-11-08","2021-03-31"]
["2020-11-09","2021-03-31"]
["2020-11-10","2021-03-31"]
["2020-11-11","2021-03-31"]
["2020-11-12","2021-03-31"]
["2020-11-13","2021-03-31"]
["2020-11-14","2021-03-31"]
["2020-11-15","2021-03-31"]
["2020-11-16","2021-03-31"]
["2020-11-17","2021-03-31"]
["2020-11-18","2021-03-31"]
["2020-11-19","2021-03-31"]
["2020-11-20","2021-03-31"]
["2020-11-21","2021-03-31"]
["2020-11-22","2021-03-31"]
["2020-11-23","2021-03-31"]
["2020-11-24","2021-03-31"]
["2020-11-25","2021-03-31"]
["2020-11-26","2021-03-31"]
["2020-11-27","2021-03-31"]
["2020-11-28","2021-03-31"]
["2020-11-29","2021-03-31"]
["2020-11-30","2021-03-31"]
["2020-12-01","2021-03-31"]
["2020-12-02","2021-03-31"]
["2020-12-03","2021-03-31"]
["2020-12-04","2021-03-31"]
["2020-12-05","2021-03-31"]
["2020-12-06","2021-03-31"]
["2020-12-07","2021-03-31"]
["2020-12-08","2021-03-31"]
["2020-12-09","2021-03-31"]
["2020-12-10","2021-03-31"]
["2020-12-11","2021-03-31"]
["2020-12-12","2021-03-31"]
["2020-12-13","2021-03-31"]
["2020-12-14","2021-03-31"]
["2020-12-15","2021-03-31"]
["2020-12-16","2021-03-31"]
["2020-12-17","2021-03-31"]
["2020-12-18","2021-03-31"]
["2020-12-19","2021-03-31"]
["2020-12-20","2021-03-31"]
["2020-12-21","2021-03-31"]
["2020-12-22","2021-03-31"]
["2020-12-23","2021-03-31"]
["2020-12-24","2021-03-31"]
["2020-12-25","2021-03-31"]
["2020-12-26","2021-03-31"]
["2020-12-27","2021-03-31"]
["2020-12-28","2021-03-31"]
["2020-12-29","2021-03-31"]
["2020-12-30","2021-03-31"]
["2020-12-31","2021-03-31"]

{"sheet":"2019-2020 DX Receive Dates","index":3,"n_rows":39,"n_cols":7,"rows_kept":39,"cut":false,"hidden":true,"merged":[[36,5,38,5],[36,6,38,6],[24,5,26,5],[24,6,26,6],[27,5,29,5],[27,6,29,6],[30,5,32,5],[30,6,32,6],[1,0,9,0],[12,0,38,0],[12,5,14,5],[12,6,14,6],[15,5,17,5],[15,6,17,6],[18,5,20,5],[18,6,20,6],[21,5,23,5],[21,6,23,6],[33,5,35,5],[33,6,35,6]]}
["DX Type","Creation Date","Months Covered"," 45 Day Due Date","90 Day Due Date","QMS Report","RA/RC and Agency Receives"]
["SWICA","2018-10-26","April- June 2018",{"$f":"SUM(B2+45)","v":"2018-12-10"},{"$f":"SUM(B2+90)","v":"2019-01-24"},"Q1 2019","2019-04-01"]
[null,"2019-01-25","July-September 2018",{"$f":"SUM(B3+45)","v":"2019-03-11"},{"$f":"SUM(B3+90)","v":"2019-04-25"},"Q2 2019","2019-07-01"]
[null,"2019-04-26","October-December 2018","2019-06-10","2019-07-25","Q3 2019","2019-10-01"]
[null,"2019-07-26","January-March 2019","2019-09-09","2019-10-24","Q4 2019","2020-01-02"]
[null,"2019-10-25","April- June 2019","2019-12-09","2020-01-23","Q1 2020","2020-04-01"]
[null,"2020-01-31","July-September 2019","2020-03-16","2020-04-30","Q2 2020","2020-07-01"]
[null,"2020-04-24","October-December 2019","2020-06-08","2020-07-23","Q3 2020","2020-10-01"]
[null,"2020-07-24","January-March 2019","2020-09-07","2020-10-22","Q4 2020","2021-01-02"]
[null,"2020-10-30","April- June 2019","2020-12-14","2021-01-28","Q1 2021","2021-04-01"]
[]
["DX Type","Creation Date","Month Covered"," 45 Day Due Date","90 Day Due Date","QMS Report","RA/RC and Agency Receives"]
["UIB Batch","2018-10-13","September 2018","2018-11-27","2019-01-11","NA","NA"]
[null,"2018-11-10","October 2018","2018-12-25","2019-02-08"]
[null,"2018-12-08","November 2018","2019-01-22","2019-03-08"]
[null,"2019-01-12","December 2018",{"$f":"SUM(B16+45)","v":"2019-02-26"},{"$f":"SUM(B16+90)","v":"2019-04-12"},"Q3 2019","2019-10-01"]
[null,"2019-02-09","January 2019","2019-03-26","2019-05-10"]
[null,"2019-03-09","February 2019","2019-04-23","2019-06-07"]
[null,"2019-04-13","March 2019","2019-05-28","2019-07-12","Q4 2019","2020-01-02"]
[null,"2019-05-11","April 2019","2019-06-25","2019-08-09"]
[null,"2019-06-08","May 2019","2019-07-23","2019-09-06"]
[null,"2019-07-13","June 2019","2019-08-27","2019-10-11","Q1 2020","2020-04-01"]
[null,"2019-08-10","July 2019","2019-09-24","2019-11-08"]
[null,"2019-09-14","August 2019","2019-10-29","2019-12-13"]
[null,"2019-10-12","September  2019","2019-11-26","2020-01-10","Q2 2020","2020-07-01"]
[null,"2019-11-09","October 2019","2019-12-24","2020-02-07"]
[null,"2019-12-14","November 2019","2020-01-28","2020-03-13"]
[null,"2020-01-11","December 2019","2020-02-25","2020-04-10","Q3 2020","2020-10-01"]
[null,"2020-02-08","January 2020","2020-03-24","2020-05-08"]
[null,"2020-03-14","February 2020","2020-04-28","2020-06-12"]
[null,"2020-04-11","March 2020","2020-05-26","2020-07-10","Q4 2020","2021-01-02"]
[null,"2020-05-09","April 2020","2020-06-23","2020-08-07"]
[null,"2020-06-13","May 2020","2020-07-28","2020-09-11"]
[null,"2020-07-11","June 2020","2020-08-25","2020-10-09","Q1 2021","2021-04-01"]
[null,"2020-08-08","July 2020","2020-09-22","2020-11-06"]
[null,"2020-09-12","August 2020","2020-10-27","2020-12-11"]
[null,"2020-10-10","September  2020","2020-11-24","2021-01-08","Q2 2021","2021-07-01"]
[null,"2020-11-14","October 2020","2020-12-29","2021-02-12"]
[null,"2020-12-12","November 2020","2021-01-26","2021-03-12"]

{"sheet":"2019 DX Receive Dates","index":4,"n_rows":22,"n_cols":7,"rows_kept":22,"cut":false,"hidden":true,"merged":[[19,5,21,5],[19,6,21,6],[1,0,4,0],[7,0,21,0],[7,5,9,5],[7,6,9,6],[10,5,12,5],[10,6,12,6],[13,5,15,5],[13,6,15,6],[16,5,18,5],[16,6,18,6]]}
["DX Type","Creation Date","Months Covered"," 45 Day Due Date","90 Day Due Date","QMS Report","RA/RC and Agency Receives"]
["SWICA","2018-10-26","April- June 2018",{"$f":"SUM(B2+45)","v":"2018-12-10"},{"$f":"SUM(B2+90)","v":"2019-01-24"},"Q1 2019","2019-04-01"]
[null,"2019-01-25","July-September 2018",{"$f":"SUM(B3+45)","v":"2019-03-11"},{"$f":"SUM(B3+90)","v":"2019-04-25"},"Q2 2019","2019-07-01"]
[null,"2019-04-26","October-December 2018","2019-06-10","2019-07-25","Q3 2019","2019-10-01"]
[null,"2019-07-26","January-March 2019","2019-09-09","2019-10-24","Q4 2019","2020-01-02"]
[]
["DX Type","Creation Date","Month Covered"," 45 Day Due Date","90 Day Due Date","QMS Report","RA/RC and Agency Receives"]
["UIB Batch","2018-10-13","September 2018","2018-11-27","2019-01-11","NA","NA"]
[null,"2018-11-10","October 2018","2018-12-25","2019-02-08"]
[null,"2018-12-08","November 2018","2019-01-22","2019-03-08"]
[null,"2019-01-12","December 2018",{"$f":"SUM(B11+45)","v":"2019-02-26"},{"$f":"SUM(B11+90)","v":"2019-04-12"},"Q3 2019","2019-10-01"]
[null,"2019-02-09","January 2019","2019-03-26","2019-05-10"]
[null,"2019-03-09","February 2019","2019-04-23","2019-06-07"]
[null,"2019-04-13","March 2019","2019-05-28","2019-07-12","Q4 2019","2020-01-02"]
[null,"2019-05-11","April 2019","2019-06-25","2019-08-09"]
[null,"2019-06-08","May 2019","2019-07-23","2019-09-06"]
[null,"2019-07-13","June 2019","2019-08-27","2019-10-11","Q1 2020","2020-04-01"]
[null,"2019-08-10","July 2019","2019-09-24","2019-11-08"]
[null,"2019-09-14","August 2019","2019-10-29","2019-12-13"]
[null,"2019-10-12","September  2019","2019-11-26","2020-01-10","Q2 2020","2020-07-01"]
[null,"2019-11-09","October 2019","2019-12-24","2020-02-07"]
[null,"2019-12-14","November 2019","2020-01-28","2020-03-13"]

{"sheet":"W-2 Payment Calculator","index":5,"n_rows":39,"n_cols":13,"rows_kept":39,"cut":false,"hidden":false,"merged":[[16,1,16,12],[31,1,31,2],[35,1,35,12],[38,1,45,1],[38,2,45,2],[38,3,45,3],[38,4,45,4],[38,5,45,5],[38,6,45,6],[38,7,45,7],[38,8,45,8],[38,9,45,9],[38,10,45,10],[38,11,45,11],[38,12,45,12],[36,1,36,12],[2,8,2,12],[8,1,8,4],[4,5,4,6],[5,5,5,6],[6,5,6,6],[7,5,7,6],[8,5,8,6],[2,1,2,6],[4,1,4,4],[5,1,5,4],[6,1,6,4],[7,1,7,4],[3,1,3,6],[1,1,1,6],[1,8,1,12],[9,1,9,6],[9,8,9,12],[10,1,10,6],[10,8,10,12],[4,8,4,9],[5,8,5,9],[6,8,6,9],[7,8,7,9],[4,10,4,12],[5,10,5,12],[6,10,6,12],[7,10,7,12],[8,9,8,12],[3,8,3,12],[11,1,11,6],[11,8,11,12],[12,8,12,9],[13,8,13,9],[12,10,12,12],[13,10,13,12],[12,1,12,4],[13,1,13,4],[12,5,12,6],[13,5,13,6]]}
[]
[null,"Wisconsin Works (W-2) Conversion Calculator",null,null,null,null,null,null,"Wisconsin Works (W-2) Conversion Calculator"]
[null,"Calculate the number of days for the Participation Period-Time Limit Month",null,null,null,null,null,null,"Calculate the number of days for the Participation Period-Time Limit Month Directions"]
[]
[null,"Time Limit Month: ",null,null,null,null,null,null,"Time Limit Month: ",null,"Select the Time Limit Month"]
[null,"Participation Period:",null,null,null,{"$f":"IF(F5=\"\",\"\",(INDEX('OVPT source'!C$3:C$39,MATCH(F5,'OVPT source'!A$3:A$39,0))))","v":""},null,null,"Participation Period:",null,"Excel will populate the Participation Period based on the Time Limit Month selected."]
[null,"Enter the 1st Day in the Participation Period:",null,null,null,null,null,null,"Enter the 1st Day in the Participation Period:",null,"Enter the 1st Day in the Participation Period in DD/MM/YYYY format."]
[null,"Enter the Last Day in the Participation Period:",null,null,null,null,null,null,"Enter the Last Day in the Participation Period:",null,"Enter the Last Day in the Participation Period in DD/MM/YYYY format."]
[null,"Total Count of Calendar Days:",null,null,null,{"$f":"IF(F7=\"\",\"\",(DATEDIF(F7,F8,\"md\")+1))","v":""},null,null,"Total Calendar Days:","Excel will populate the Total Calendar Days (count of days from 1st Day to Last day in the Participation Period)."]
[]
[null,"Convert the Nonparticipation Amount into Hours",null,null,null,null,null,null,"Convert the Nonparticipation Amount into Hours"]
[]
[null,"Nonparticipation Dollar Amount",null,null,null,null,null,null,"Nonparticipation Dollar Amount",null,"Enter the dollar amount of nonparticipation."]
[null,"Nonparticipation Hours",null,null,null,{"$f":"IF(F13=\"\",\"\",(SUM(F13/5)))","v":""},null,null,"Nonparticipation Hours",null,"Excel will populate the Nonparticipation Hours using Nonparticipation dollar amount / $5."]
[]
[]
[null,"Wisconsin Works (W-2) Payment Calculator"]
[null,"Time Limit Month","Participation Period","Payment Month","Days Count","Placement","Base Pay","Daily Rate","Days in Placement","Prorated Payment Amount","Nonparticipation Hours","Sanction Amount","Adjusted W-2 Payment Amount"]
[1,null,{"$f":"IF(B19=\"\",\"\",(INDEX('OVPT source'!C$3:C$39,MATCH('W-2 Payment Calculator'!B19,'OVPT source'!A$3:A$39,0))))","v":""},{"$f":"IF(B19=\"\",\"\",(INDEX('OVPT source'!B$3:B$39,MATCH('W-2 Payment Calculator'!B19,'OVPT source'!A$3:A$39,0))))","v":""},{"$f":"IF(B19=\"\",\"\",INDEX('OVPT source'!D$3:D$39,MATCH('W-2 Payment Calculator'!B19,'OVPT source'!A$3:A$39,0)))","v":""},null,{"$f":"IF(B19=\"\",\"\",(INDEX('OVPT source'!K$3:K$9,MATCH('W-2 Payment Calculator'!F19,'OVPT source'!J$3:J$9,0))))","v":""},{"$f":"IF(F19=\"\",\"\",(INDEX('OVPT source'!H$3:H$37,MATCH(1,('W-2 Payment Calculator'!E19='OVPT source'!$G$3:$G$37)*('W-2 Payment Calculator'!F19='OVPT source'!$F$3:$F$37),0))))","v":""},null,{"$f":"IF(I19=\"\",\"\",(SUM(I19*H19)))","v":""},null,{"$f":"IF(K19=\"\",\"\",SUM(K19*5))","v":""},{"$f":"IF(J19=\"\",\"\",J19-L19)","v":""}]
[2,null,{"$f":"IF(B20=\"\",\"\",(INDEX('OVPT source'!C$3:C$39,MATCH('W-2 Payment Calculator'!B20,'OVPT source'!A$3:A$39,0))))","v":""},{"$f":"IF(B20=\"\",\"\",(INDEX('OVPT source'!B$3:B$39,MATCH('W-2 Payment Calculator'!B20,'OVPT source'!A$3:A$39,0))))","v":""},{"$f":"IF(B20=\"\",\"\",INDEX('OVPT source'!D$3:D$39,MATCH('W-2 Payment Calculator'!B20,'OVPT source'!A$3:A$39,0)))","v":""},null,{"$f":"IF(B20=\"\",\"\",(INDEX('OVPT source'!K$3:K$9,MATCH('W-2 Payment Calculator'!F20,'OVPT source'!J$3:J$9,0))))","v":""},{"$f":"IF(F20=\"\",\"\",(INDEX('OVPT source'!H$3:H$37,MATCH(1,('W-2 Payment Calculator'!E20='OVPT source'!$G$3:$G$37)*('W-2 Payment Calculator'!F20='OVPT source'!$F$3:$F$37),0))))","v":""},null,{"$f":"IF(I20=\"\",\"\",(SUM(I20*H20)))","v":""},null,{"$f":"IF(K20=\"\",\"\",SUM(K20*5))","v":""},{"$f":"IF(J20=\"\",\"\",J20-L20)","v":""}]
[3,null,{"$f":"IF(B21=\"\",\"\",(INDEX('OVPT source'!C$3:C$39,MATCH('W-2 Payment Calculator'!B21,'OVPT source'!A$3:A$39,0))))","v":""},{"$f":"IF(B21=\"\",\"\",(INDEX('OVPT source'!B$3:B$39,MATCH('W-2 Payment Calculator'!B21,'OVPT source'!A$3:A$39,0))))","v":""},{"$f":"IF(B21=\"\",\"\",INDEX('OVPT source'!D$3:D$39,MATCH('W-2 Payment Calculator'!B21,'OVPT source'!A$3:A$39,0)))","v":""},null,{"$f":"IF(B21=\"\",\"\",(INDEX('OVPT source'!K$3:K$9,MATCH('W-2 Payment Calculator'!F21,'OVPT source'!J$3:J$9,0))))","v":""},{"$f":"IF(F21=\"\",\"\",(INDEX('OVPT source'!H$3:H$37,MATCH(1,('W-2 Payment Calculator'!E21='OVPT source'!$G$3:$G$37)*('W-2 Payment Calculator'!F21='OVPT source'!$F$3:$F$37),0))))","v":""},null,"",null,"",""]
[4,null,{"$f":"IF(B22=\"\",\"\",(INDEX('OVPT source'!C$3:C$39,MATCH('W-2 Payment Calculator'!B22,'OVPT source'!A$3:A$39,0))))","v":""},{"$f":"IF(B22=\"\",\"\",(INDEX('OVPT source'!B$3:B$39,MATCH('W-2 Payment Calculator'!B22,'OVPT source'!A$3:A$39,0))))","v":""},{"$f":"IF(B22=\"\",\"\",INDEX('OVPT source'!D$3:D$39,MATCH('W-2 Payment Calculator'!B22,'OVPT source'!A$3:A$39,0)))","v":""},null,{"$f":"IF(B22=\"\",\"\",(INDEX('OVPT source'!K$3:K$9,MATCH('W-2 Payment Calculator'!F22,'OVPT source'!J$3:J$9,0))))","v":""},{"$f":"IF(F22=\"\",\"\",(INDEX('OVPT source'!H$3:H$37,MATCH(1,('W-2 Payment Calculator'!E22='OVPT source'!$G$3:$G$37)*('W-2 Payment Calculator'!F22='OVPT source'!$F$3:$F$37),0))))","v":""},null,"",null,"",""]
[5,null,{"$f":"IF(B23=\"\",\"\",(INDEX('OVPT source'!C$3:C$39,MATCH('W-2 Payment Calculator'!B23,'OVPT source'!A$3:A$39,0))))","v":""},{"$f":"IF(B23=\"\",\"\",(INDEX('OVPT source'!B$3:B$39,MATCH('W-2 Payment Calculator'!B23,'OVPT source'!A$3:A$39,0))))","v":""},{"$f":"IF(B23=\"\",\"\",INDEX('OVPT source'!D$3:D$39,MATCH('W-2 Payment Calculator'!B23,'OVPT source'!A$3:A$39,0)))","v":""},null,{"$f":"IF(B23=\"\",\"\",(INDEX('OVPT source'!K$3:K$9,MATCH('W-2 Payment Calculator'!F23,'OVPT source'!J$3:J$9,0))))","v":""},{"$f":"IF(F23=\"\",\"\",(INDEX('OVPT source'!H$3:H$37,MATCH(1,('W-2 Payment Calculator'!E23='OVPT source'!$G$3:$G$37)*('W-2 Payment Calculator'!F23='OVPT source'!$F$3:$F$37),0))))","v":""},null,"",null,"",""]
[6,null,{"$f":"IF(B24=\"\",\"\",(INDEX('OVPT source'!C$3:C$39,MATCH('W-2 Payment Calculator'!B24,'OVPT source'!A$3:A$39,0))))","v":""},{"$f":"IF(B24=\"\",\"\",(INDEX('OVPT source'!B$3:B$39,MATCH('W-2 Payment Calculator'!B24,'OVPT source'!A$3:A$39,0))))","v":""},{"$f":"IF(B24=\"\",\"\",INDEX('OVPT source'!D$3:D$39,MATCH('W-2 Payment Calculator'!B24,'OVPT source'!A$3:A$39,0)))","v":""},null,{"$f":"IF(B24=\"\",\"\",(INDEX('OVPT source'!K$3:K$9,MATCH('W-2 Payment Calculator'!F24,'OVPT source'!J$3:J$9,0))))","v":""},{"$f":"IF(F24=\"\",\"\",(INDEX('OVPT source'!H$3:H$37,MATCH(1,('W-2 Payment Calculator'!E24='OVPT source'!$G$3:$G$37)*('W-2 Payment Calculator'!F24='OVPT source'!$F$3:$F$37),0))))","v":""},null,"",null,"",""]
[7,null,{"$f":"IF(B25=\"\",\"\",(INDEX('OVPT source'!C$3:C$39,MATCH('W-2 Payment Calculator'!B25,'OVPT source'!A$3:A$39,0))))","v":""},{"$f":"IF(B25=\"\",\"\",(INDEX('OVPT source'!B$3:B$39,MATCH('W-2 Payment Calculator'!B25,'OVPT source'!A$3:A$39,0))))","v":""},{"$f":"IF(B25=\"\",\"\",INDEX('OVPT source'!D$3:D$39,MATCH('W-2 Payment Calculator'!B25,'OVPT source'!A$3:A$39,0)))","v":""},null,{"$f":"IF(B25=\"\",\"\",(INDEX('OVPT source'!K$3:K$9,MATCH('W-2 Payment Calculator'!F25,'OVPT source'!J$3:J$9,0))))","v":""},{"$f":"IF(F25=\"\",\"\",(INDEX('OVPT source'!H$3:H$37,MATCH(1,('W-2 Payment Calculator'!E25='OVPT source'!$G$3:$G$37)*('W-2 Payment Calculator'!F25='OVPT source'!$F$3:$F$37),0))))","v":""},null,"",null,"",""]
[8,null,{"$f":"IF(B26=\"\",\"\",(INDEX('OVPT source'!C$3:C$39,MATCH('W-2 Payment Calculator'!B26,'OVPT source'!A$3:A$39,0))))","v":""},{"$f":"IF(B26=\"\",\"\",(INDEX('OVPT source'!B$3:B$39,MATCH('W-2 Payment Calculator'!B26,'OVPT source'!A$3:A$39,0))))","v":""},{"$f":"IF(B26=\"\",\"\",INDEX('OVPT source'!D$3:D$39,MATCH('W-2 Payment Calculator'!B26,'OVPT source'!A$3:A$39,0)))","v":""},null,{"$f":"IF(B26=\"\",\"\",(INDEX('OVPT source'!K$3:K$9,MATCH('W-2 Payment Calculator'!F26,'OVPT source'!J$3:J$9,0))))","v":""},{"$f":"IF(F26=\"\",\"\",(INDEX('OVPT source'!H$3:H$37,MATCH(1,('W-2 Payment Calculator'!E26='OVPT source'!$G$3:$G$37)*('W-2 Payment Calculator'!F26='OVPT source'!$F$3:$F$37),0))))","v":""},null,"",null,"",""]
[9,null,{"$f":"IF(B27=\"\",\"\",(INDEX('OVPT source'!C$3:C$39,MATCH('W-2 Payment Calculator'!B27,'OVPT source'!A$3:A$39,0))))","v":""},{"$f":"IF(B27=\"\",\"\",(INDEX('OVPT source'!B$3:B$39,MATCH('W-2 Payment Calculator'!B27,'OVPT source'!A$3:A$39,0))))","v":""},{"$f":"IF(B27=\"\",\"\",INDEX('OVPT source'!D$3:D$39,MATCH('W-2 Payment Calculator'!B27,'OVPT source'!A$3:A$39,0)))","v":""},null,{"$f":"IF(B27=\"\",\"\",(INDEX('OVPT source'!K$3:K$9,MATCH('W-2 Payment Calculator'!F27,'OVPT source'!J$3:J$9,0))))","v":""},{"$f":"IF(F27=\"\",\"\",(INDEX('OVPT source'!H$3:H$37,MATCH(1,('W-2 Payment Calculator'!E27='OVPT source'!$G$3:$G$37)*('W-2 Payment Calculator'!F27='OVPT source'!$F$3:$F$37),0))))","v":""},null,"",null,"",""]
[10,null,{"$f":"IF(B28=\"\",\"\",(INDEX('OVPT source'!C$3:C$39,MATCH('W-2 Payment Calculator'!B28,'OVPT source'!A$3:A$39,0))))","v":""},{"$f":"IF(B28=\"\",\"\",(INDEX('OVPT source'!B$3:B$39,MATCH('W-2 Payment Calculator'!B28,'OVPT source'!A$3:A$39,0))))","v":""},{"$f":"IF(B28=\"\",\"\",INDEX('OVPT source'!D$3:D$39,MATCH('W-2 Payment Calculator'!B28,'OVPT source'!A$3:A$39,0)))","v":""},null,{"$f":"IF(B28=\"\",\"\",(INDEX('OVPT source'!K$3:K$9,MATCH('W-2 Payment Calculator'!F28,'OVPT source'!J$3:J$9,0))))","v":""},{"$f":"IF(F28=\"\",\"\",(INDEX('OVPT source'!H$3:H$37,MATCH(1,('W-2 Payment Calculator'!E28='OVPT source'!$G$3:$G$37)*('W-2 Payment Calculator'!F28='OVPT source'!$F$3:$F$37),0))))","v":""},null,"",null,"",""]
[11,null,{"$f":"IF(B29=\"\",\"\",(INDEX('OVPT source'!C$3:C$39,MATCH('W-2 Payment Calculator'!B29,'OVPT source'!A$3:A$39,0))))","v":""},{"$f":"IF(B29=\"\",\"\",(INDEX('OVPT source'!B$3:B$39,MATCH('W-2 Payment Calculator'!B29,'OVPT source'!A$3:A$39,0))))","v":""},{"$f":"IF(B29=\"\",\"\",INDEX('OVPT source'!D$3:D$39,MATCH('W-2 Payment Calculator'!B29,'OVPT source'!A$3:A$39,0)))","v":""},null,{"$f":"IF(B29=\"\",\"\",(INDEX('OVPT source'!K$3:K$9,MATCH('W-2 Payment Calculator'!F29,'OVPT source'!J$3:J$9,0))))","v":""},{"$f":"IF(F29=\"\",\"\",(INDEX('OVPT source'!H$3:H$37,MATCH(1,('W-2 Payment Calculator'!E29='OVPT source'!$G$3:$G$37)*('W-2 Payment Calculator'!F29='OVPT source'!$F$3:$F$37),0))))","v":""},null,"",null,"",""]
[12,null,{"$f":"IF(B30=\"\",\"\",(INDEX('OVPT source'!C$3:C$39,MATCH('W-2 Payment Calculator'!B30,'OVPT source'!A$3:A$39,0))))","v":""},{"$f":"IF(B30=\"\",\"\",(INDEX('OVPT source'!B$3:B$39,MATCH('W-2 Payment Calculator'!B30,'OVPT source'!A$3:A$39,0))))","v":""},{"$f":"IF(B30=\"\",\"\",INDEX('OVPT source'!D$3:D$39,MATCH('W-2 Payment Calculator'!B30,'OVPT source'!A$3:A$39,0)))","v":""},null,{"$f":"IF(B30=\"\",\"\",(INDEX('OVPT source'!K$3:K$9,MATCH('W-2 Payment Calculator'!F30,'OVPT source'!J$3:J$9,0))))","v":""},{"$f":"IF(F30=\"\",\"\",(INDEX('OVPT source'!H$3:H$37,MATCH(1,('W-2 Payment Calculator'!E30='OVPT source'!$G$3:$G$37)*('W-2 Payment Calculator'!F30='OVPT source'!$F$3:$F$37),0))))","v":""},null,"",null,"",""]
[]
[null,"Grand Total",null,{"$f":"SUMIF(M19:M30,\"<>#N/A\")","v":0}]
[]
[]
[]
[null,"Wisconsin Works (W-2) Payment Calculator Directions"]
[null,"Complete every required field to obtain the Cumulative Total of the W-2 Overpayment Amount."]
[null,"Time Limit Month","Participation Period","Payment Month","Days Count","Placement","Base Pay","Daily Rate","Days in Placement","Prorated Payment Amount","Nonparticipation Hours","Sanction Amount","Adjusted W-2 Payment Amount"]
[null,"Select the Time Limit Month\n\n\n\n\n\n[Note: This field is required.]","Excel will populate the Participation Period based on the Time Limit Month selected.","Excel will populate the Payment Month based on the Time Limit Month entered.","Excel will populate Days Count based on the Time Limit Month entered.","Select a Placement from the drop down list.\n\n\n[Note: This field is  required.]","Excel will populate the Base Pay matching the Days Count and Placement.","Excel will populate the Daily Rate matching the Days Count and Placement.","Using the W-2 Conversion Calculator, enter the amount of days the individual as in the Placement.\n\n\n\n[Note: This field is required.]","Excel will populate the Prorated Payment Amount using the Days in Placement X Daily Rate.","Enter in the Nonparticipation Hours.\n\n\n\n\n\n\n[Note: This field is required.]","Excel will populate the Sanction Amount using Nonparticipation Hours X $5.","Excel will populate the Adjusted W-2 Payment Amount (Prorated Payment Amount - Sanction Amount). \n\n\n\n[Note: Excel will populate errors when the Adjusted W-2 Payment Amount is more than the Prorated Payment Amount and less than $1.]"]