{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["DPL PRO Audit Sheet","DSL PRO Audit Sheet"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":2,"defined_names":0,"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":"DPL PRO Audit Sheet","index":0,"n_rows":32,"n_cols":40,"rows_kept":32,"cut":false,"hidden":false,"merged":[[8,1,8,2],[1,1,1,2],[0,4,0,16]]}
[null,null,null,null,"DPL Bankruptcy Audit Sheet",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"1900-01-01",null,null,null,null,null,null,null,null,null,null,null,null,null,10,{"$f":"AJ1+1","v":11},null,{"$f":"CONCATENATE(\"F\",AK1,\":P\",AK1)","v":"F11:P11"}]
[null,"Team Based",null,null,"Account Number","Pref Customer","Non-Accrual Date","Bill Code","Bill Last Payment","All Late Fees","Add'l Info","Cancel Payments ","Account Status","Who Changed","SLA","DNP Mail","Notes",null,null,null,"Account Number","Date of Death","Pref Customer","Non-Accrual Date","CO Date","Bill Code","Bill Last Payment","Max Late Fee to Assess","Days to Assess Late Fee","Max Total Amount Late Fee","Account Status","Old Account Status","Account Status Change Date","Who Changed",null,null,null,null,"Compl"]
[null,"A",{"$f":"AVERAGE(G11:K11,O11:P11,R11:S11)","v":0.85119047619047616},null,54213453,"Y","N/A","N/A","N/A","N/A","Charge Off Balance Minus Any Payments","N/A","Check to see if Placed","Sam I am",null,null,null,null,null,null,54213453,"2012-01-10","DECEASED","2012-06-29","2012-06-29","X","N",39,3,1000000000,"DCM","PRO","2012-11-15","Sam I am",null,null,{"$f":"CONCATENATE(AL3,$AJ$1)","v":"F3:F10"},"F3:F",{"$f":"CONCATENATE(\"=\",$AJ$4,AK3,$AJ$5,AK3,$AJ$6,AK3,$AJ$7,AK3,$AJ$8,AK3,$AJ$9,AK3,$AJ$10,AK3,$AJ$11,AK3,$AJ$12)","v":"=IF(COUNTIF(F3:F10,\"N\")=0,IF(COUNTIF(F3:F10,\"Y\")=0,\"N/A\",COUNTIF(F3:F10,\"Y\")/(COUNTIF(F3:F10,\"Y\")+COUNTIF(F3:F10,\"N\"))),COUNTIF(F3:F10,\"Y\")/(COUNTIF(F3:F10,\"Y\")+COUNTIF(F3:F10,\"N\")))"}]
[null,"B",{"$f":"AVERAGE(F11,L11:N11)","v":0.9285714285714286},null,54132135,"Y","Y","Y","Y","Y","Current Balance","Check Session B","Y","Sam I am",null,null,null,null,null,null,54132135,"2012-10-24","DECEASED","2012-11-15","00:00:00","X","N",0,0,0,"PRO","CU1","2012-11-15","Sam I am",null,"IF(COUNTIF(",{"$f":"CONCATENATE(AL4,$AJ$1)","v":"G3:G10"},"G3:G",{"$f":"CONCATENATE(\"=\",$AJ$4,AK4,$AJ$5,AK4,$AJ$6,AK4,$AJ$7,AK4,$AJ$8,AK4,$AJ$9,AK4,$AJ$10,AK4,$AJ$11,AK4,$AJ$12)","v":"=IF(COUNTIF(G3:G10,\"N\")=0,IF(COUNTIF(G3:G10,\"Y\")=0,\"N/A\",COUNTIF(G3:G10,\"Y\")/(COUNTIF(G3:G10,\"Y\")+COUNTIF(G3:G10,\"N\"))),COUNTIF(G3:G10,\"Y\")/(COUNTIF(G3:G10,\"Y\")+COUNTIF(G3:G10,\"N\")))"}]
[null,"C",{"$f":"AVERAGE(F11:P11,R11:S11)","v":0.87698412698412698},null,321213541,"Y","N/A","Y","Y","N","Current Balance","Check Session B","N","Sam I am",null,null,"Shouldn't be placed",null,null,null,321213541,"2012-07-24","DECEASED","2012-10-31","00:00:00","X","N",39,3,0,"DCM","PRO","2012-11-15","Sam I am",null,",\"N\")=0,IF(COUNTIF(","H3:H10","H3:H","=IF(COUNTIF(H3:H10,\"N\")=0,IF(COUNTIF(H3:H10,\"Y\")=0,\"N/A\",COUNTIF(H3:H10,\"Y\")/(COUNTIF(H3:H10,\"Y\")+COUNTIF(H3:H10,\"N\"))),COUNTIF(H3:H10,\"Y\")/(COUNTIF(H3:H10,\"Y\")+COUNTIF(H3:H10,\"N\")))"]
[null,null,null,null,21542645,"Y","Y","Y","Y","Y","Current Balance","Check Session B","Y","Sam I am",null,null,null,null,null,null,21542645,"2012-10-02","DECEASED","2012-11-15","00:00:00","X","N",0,0,0,"PRO","CU1","2012-11-15","Sam I am",null,",\"Y\")=0,\"N/A\",COUNTIF(","I3:I10","I3:I","=IF(COUNTIF(I3:I10,\"N\")=0,IF(COUNTIF(I3:I10,\"Y\")=0,\"N/A\",COUNTIF(I3:I10,\"Y\")/(COUNTIF(I3:I10,\"Y\")+COUNTIF(I3:I10,\"N\"))),COUNTIF(I3:I10,\"Y\")/(COUNTIF(I3:I10,\"Y\")+COUNTIF(I3:I10,\"N\")))"]
[null,null,null,null,845123151,"Y","Y","Y","Y","Y","Current Balance","Check Session B","Y","Sam I am",null,null,null,null,null,null,845123151,"2012-10-31","DECEASED","2012-11-07","00:00:00","X","N",0,0,0,"PRO","CU1","2012-11-07","Sam I am",null,",\"Y\")/(COUNTIF(","J3:J10","J3:J","=IF(COUNTIF(J3:J10,\"N\")=0,IF(COUNTIF(J3:J10,\"Y\")=0,\"N/A\",COUNTIF(J3:J10,\"Y\")/(COUNTIF(J3:J10,\"Y\")+COUNTIF(J3:J10,\"N\"))),COUNTIF(J3:J10,\"Y\")/(COUNTIF(J3:J10,\"Y\")+COUNTIF(J3:J10,\"N\")))"]
[null,null,null,null,4352135412,"Y","N","Y","Y","Y","Current Balance","Check Session B","Y","Sam I am",null,null,"Non Accrual Not Added",null,null,null,4352135412,"2012-10-14","DECEASED","2012-11-07","00:00:00","X","N",0,0,0,"PRO","PRP","2012-11-06","Sam I am",null,",\"Y\")+COUNTIF(","K3:K10","K3:K","=IF(COUNTIF(K3:K10,\"N\")=0,IF(COUNTIF(K3:K10,\"Y\")=0,\"N/A\",COUNTIF(K3:K10,\"Y\")/(COUNTIF(K3:K10,\"Y\")+COUNTIF(K3:K10,\"N\"))),COUNTIF(K3:K10,\"Y\")/(COUNTIF(K3:K10,\"Y\")+COUNTIF(K3:K10,\"N\")))"]
[null,"Not yet worked based on Notification Tracker",null,null,854168451,"Y","Y","N","N","Y","Current Balance","Check Session B","Y","Fred",null,null,"Bill Code not changed, Bill Last Payment not changed",null,null,null,854168451,"2012-10-15","DECEASED","2012-11-05","00:00:00","B","Y",0,0,0,"PRO","NEW","2012-11-05","Fred",null,",\"N\"))),COUNTIF(","L3:L10","L3:L","=IF(COUNTIF(L3:L10,\"N\")=0,IF(COUNTIF(L3:L10,\"Y\")=0,\"N/A\",COUNTIF(L3:L10,\"Y\")/(COUNTIF(L3:L10,\"Y\")+COUNTIF(L3:L10,\"N\"))),COUNTIF(L3:L10,\"Y\")/(COUNTIF(L3:L10,\"Y\")+COUNTIF(L3:L10,\"N\")))"]
[null,"Mail",{"$f":"VLOOKUP(AN21,'[1]DEC 2012'!$A$3:$H$27,8,FALSE)","v":0},null,21215313151,"Y","Y","Y","Y","Y","Current Balance","Check Session B","Y","Fred",null,null,null,null,null,null,21215313151,"2012-10-25","DECEASED","2012-11-05","00:00:00","X","N",0,0,0,"PRO","PRP","2012-11-05","Fred",null,",\"Y\")/(COUNTIF(","M3:M10","M3:M","=IF(COUNTIF(M3:M10,\"N\")=0,IF(COUNTIF(M3:M10,\"Y\")=0,\"N/A\",COUNTIF(M3:M10,\"Y\")/(COUNTIF(M3:M10,\"Y\")+COUNTIF(M3:M10,\"N\"))),COUNTIF(M3:M10,\"Y\")/(COUNTIF(M3:M10,\"Y\")+COUNTIF(M3:M10,\"N\")))"]
[null,"Scrub",{"$f":"VLOOKUP(AN21,'[1]DEC 2012'!$A$3:$O$27,15,FALSE)","v":0},null,null,{"$f":"IF(COUNTIF(F3:F10,\"N\")=0,IF(COUNTIF(F3:F10,\"Y\")=0,\"N/A\",COUNTIF(F3:F10,\"Y\")/(COUNTIF(F3:F10,\"Y\")+COUNTIF(F3:F10,\"N\"))),COUNTIF(F3:F10,\"Y\")/(COUNTIF(F3:F10,\"Y\")+COUNTIF(F3:F10,\"N\")))","v":1},{"$f":"IF(COUNTIF(G3:G10,\"N\")=0,IF(COUNTIF(G3:G10,\"Y\")=0,\"N/A\",COUNTIF(G3:G10,\"Y\")/(COUNTIF(G3:G10,\"Y\")+COUNTIF(G3:G10,\"N\"))),COUNTIF(G3:G10,\"Y\")/(COUNTIF(G3:G10,\"Y\")+COUNTIF(G3:G10,\"N\")))","v":0.83333333333333337},{"$f":"IF(COUNTIF(H3:H10,\"N\")=0,IF(COUNTIF(H3:H10,\"Y\")=0,\"N/A\",COUNTIF(H3:H10,\"Y\")/(COUNTIF(H3:H10,\"Y\")+COUNTIF(H3:H10,\"N\"))),COUNTIF(H3:H10,\"Y\")/(COUNTIF(H3:H10,\"Y\")+COUNTIF(H3:H10,\"N\")))","v":0.8571428571428571},{"$f":"IF(COUNTIF(I3:I10,\"N\")=0,IF(COUNTIF(I3:I10,\"Y\")=0,\"N/A\",COUNTIF(I3:I10,\"Y\")/(COUNTIF(I3:I10,\"Y\")+COUNTIF(I3:I10,\"N\"))),COUNTIF(I3:I10,\"Y\")/(COUNTIF(I3:I10,\"Y\")+COUNTIF(I3:I10,\"N\")))","v":0.8571428571428571},{"$f":"IF(COUNTIF(J3:J10,\"N\")=0,IF(COUNTIF(J3:J10,\"Y\")=0,\"N/A\",COUNTIF(J3:J10,\"Y\")/(COUNTIF(J3:J10,\"Y\")+COUNTIF(J3:J10,\"N\"))),COUNTIF(J3:J10,\"Y\")/(COUNTIF(J3:J10,\"Y\")+COUNTIF(J3:J10,\"N\")))","v":0.8571428571428571},{"$f":"IF(COUNTIF(K3:K10,\"N\")=0,IF(COUNTIF(K3:K10,\"Y\")=0,\"N/A\",COUNTIF(K3:K10,\"Y\")/(COUNTIF(K3:K10,\"Y\")+COUNTIF(K3:K10,\"N\"))),COUNTIF(K3:K10,\"Y\")/(COUNTIF(K3:K10,\"Y\")+COUNTIF(K3:K10,\"N\")))","v":"N/A"},{"$f":"IF(COUNTIF(L3:L10,\"N\")=0,IF(COUNTIF(L3:L10,\"Y\")=0,\"N/A\",COUNTIF(L3:L10,\"Y\")/(COUNTIF(L3:L10,\"Y\")+COUNTIF(L3:L10,\"N\"))),COUNTIF(L3:L10,\"Y\")/(COUNTIF(L3:L10,\"Y\")+COUNTIF(L3:L10,\"N\")))","v":"N/A"},{"$f":"IF(COUNTIF(M3:M10,\"N\")=0,IF(COUNTIF(M3:M10,\"Y\")=0,\"N/A\",COUNTIF(M3:M10,\"Y\")/(COUNTIF(M3:M10,\"Y\")+COUNTIF(M3:M10,\"N\"))),COUNTIF(M3:M10,\"Y\")/(COUNTIF(M3:M10,\"Y\")+COUNTIF(M3:M10,\"N\")))","v":0.8571428571428571},null,{"$f":"IF(COUNTIF(O3:O10,\"N\")=0,IF(COUNTIF(O3:O10,\"Y\")=0,\"N/A\",COUNTIF(O3:O10,\"Y\")/(COUNTIF(O3:O10,\"Y\")+COUNTIF(O3:O10,\"N\"))),COUNTIF(O3:O10,\"Y\")/(COUNTIF(O3:O10,\"Y\")+COUNTIF(O3:O10,\"N\")))","v":"N/A"},{"$f":"IF(COUNTIF(P3:P10,\"N\")=0,IF(COUNTIF(P3:P10,\"Y\")=0,\"N/A\",COUNTIF(P3:P10,\"Y\")/(COUNTIF(P3:P10,\"Y\")+COUNTIF(P3:P10,\"N\"))),COUNTIF(P3:P10,\"Y\")/(COUNTIF(P3:P10,\"Y\")+COUNTIF(P3:P10,\"N\")))","v":"N/A"},null,null,null,null,null,null,null,null,".",null,null,null,null,null,null,null,null,null,null,",\"Y\")+COUNTIF("]
[null,"Total",{"$f":"SUM(C10:C11)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,",\"N\")))","O3:O10","O3:O","=IF(COUNTIF(O3:O10,\"N\")=0,IF(COUNTIF(O3:O10,\"Y\")=0,\"N/A\",COUNTIF(O3:O10,\"Y\")/(COUNTIF(O3:O10,\"Y\")+COUNTIF(O3:O10,\"N\"))),COUNTIF(O3:O10,\"Y\")/(COUNTIF(O3:O10,\"Y\")+COUNTIF(O3:O10,\"N\")))"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"P3:P10","P3:P","=IF(COUNTIF(P3:P10,\"N\")=0,IF(COUNTIF(P3:P10,\"Y\")=0,\"N/A\",COUNTIF(P3:P10,\"Y\")/(COUNTIF(P3:P10,\"Y\")+COUNTIF(P3:P10,\"N\"))),COUNTIF(P3:P10,\"Y\")/(COUNTIF(P3:P10,\"Y\")+COUNTIF(P3:P10,\"N\")))"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Compliance",{"$f":"CONCATENATE(\"G\",AK1,\":K\",AK1,\",O\",AK1,\":P\",AK1,\",R\",AK1,\":S\",AK1)","v":"G11:K11,O11:P11,R11:S11"},{"$f":"CONCATENATE(\"=average(\",AK15,\")\")","v":"=average(G11:K11,O11:P11,R11:S11)"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Procedures",{"$f":"CONCATENATE(\"F\",AK1,\",L\",AK1,\":N\",AK1)","v":"F11,L11:N11"},{"$f":"CONCATENATE(\"=average(\",AK16,\")\")","v":"=average(F11,L11:N11)"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Average",{"$f":"CONCATENATE(\"F\",AK1,\":P\",AK1,\",R\",AK1,\":S\",AK1)","v":"F11:P11,R11:S11"},"=average(F11:P11,R11:S11)"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2012-12-06"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"JAN",{"$f":"MONTH(AL20)","v":12},{"$f":"YEAR(AL20)","v":2012},{"$f":"DAY(AL20)","v":6}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"FEB",{"$f":"VLOOKUP(AL21,$AJ$21:$AK$32,2,FALSE)","v":"DEC"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"MAR",{"$f":"CONCATENATE(AL22,\" \",AM21,\"'\")","v":"DEC 2012'"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"APR"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,"MAY",null,"VLOOKUP(AN21,'[DPL Probate Notification Work Tracker.xlsm]"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"JUN",null,"!$A$3:$H$27,8,FALSE)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,"JUL",null,"!$A$3:$O$27,15,FALSE)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"AUG"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,"SEP",null,{"$f":"CONCATENATE(\"=\",$AM$25,$AL$23,$AM$26)","v":"=VLOOKUP(AN21,'[DPL Probate Notification Work Tracker.xlsm]DEC 2012'!$A$3:$H$27,8,FALSE)"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,"OCT",null,{"$f":"CONCATENATE(\"=\",$AM$25,$AL$23,$AM$27)","v":"=VLOOKUP(AN21,'[DPL Probate Notification Work Tracker.xlsm]DEC 2012'!$A$3:$O$27,15,FALSE)"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,"NOV"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,"DEC"]

{"sheet":"DSL PRO Audit Sheet","index":1,"n_rows":20,"n_cols":22,"rows_kept":20,"cut":false,"hidden":false,"merged":[[1,13,1,14]]}
[]
[null,"Account Number","SLA","Excluded","VB code","Flagged","Added to the Tracker","POC Claim","POC Form Accuracy","Payments Deleted","DNP","Per Account",null,"Not yet worked based on Notification Tracker",null,null,null,null,null,{"$f":"TODAY()","v":"2012-12-06"}]
[null,12345678,"y","y","y","y","n","n","y","y","y",{"$f":"IF(COUNTIF(C3:K3,\"N\")=0,IF(COUNTIF(C3:K3,\"Y\")=0,\"N/A\",COUNTIF(C3:K3,\"Y\")/(COUNTIF(C3:K3,\"Y\")+COUNTIF(C3:K3,\"N\"))),COUNTIF(C3:K3,\"Y\")/(COUNTIF(C3:K3,\"Y\")+COUNTIF(C3:K3,\"N\")))","v":0.77777777777777779},null,"Mail",{"$f":"VLOOKUP(6,'[2]DEC 2012'!$A$3:$H$27,8,FALSE)","v":0},null,null,1,"JAN",{"$f":"MONTH(T2)","v":12},{"$f":"YEAR(T2)","v":2012},{"$f":"DAY(T2)","v":6}]
[null,123456789,"y","n","y","n","y","y","y","n","y",{"$f":"IF(COUNTIF(C4:K4,\"N\")=0,IF(COUNTIF(C4:K4,\"Y\")=0,\"N/A\",COUNTIF(C4:K4,\"Y\")/(COUNTIF(C4:K4,\"Y\")+COUNTIF(C4:K4,\"N\"))),COUNTIF(C4:K4,\"Y\")/(COUNTIF(C4:K4,\"Y\")+COUNTIF(C4:K4,\"N\")))","v":0.66666666666666663},null,"Scrub",{"$f":"VLOOKUP(6,'[2]DEC 2012'!$A$3:$O$27,15,FALSE)","v":0},null,null,2,"FEB",{"$f":"VLOOKUP(T3,$R$3:$S$14,2,FALSE)","v":"DEC"}]
[null,234567890,"y","y","y","y","y","n","y","y","n",0.77777777777777779,null,"Email",{"$f":"VLOOKUP(6,'[2]DEC 2012'!$A$3:$V$27,22,FALSE)","v":0},null,null,3,"MAR",{"$f":"CONCATENATE(T4,\" \",U3,\"'\")","v":"DEC 2012'"}]
[null,345678901,"y","n","y","y","n","y","y","y","y",0.77777777777777779,null,"Total",{"$f":"SUM(O3:O5)","v":0},null,null,4,"APR"]
[null,456789012,"n","y","n","n","y","y","n","y","n",0.44444444444444442,null,null,null,null,null,5,"MAY",null,"VLOOKUP(",",'[DSL Probate Notification Work Tracker.xlsx]"]
[null,567890123,"n","y","y","y","y","y","n","n","y",0.66666666666666663,null,null,null,null,null,6,"JUN",null,"!$A$3:$H$27,8,FALSE)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,"JUL",null,"!$A$3:$O$27,15,FALSE)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"AUG",null,"!$A$3:$V$27,22,FALSE)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,"SEP",null,{"$f":"CONCATENATE(\"=\",$U$7,$V$3,$V$7,$T$5,$U$8)","v":"=VLOOKUP(6,'[DSL Probate Notification Work Tracker.xlsx]DEC 2012'!$A$3:$H$27,8,FALSE)"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,"OCT",null,{"$f":"CONCATENATE(\"=\",$U$7,$V$3,$V$7,$T$5,$U$9)","v":"=VLOOKUP(6,'[DSL Probate Notification Work Tracker.xlsx]DEC 2012'!$A$3:$O$27,15,FALSE)"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,"NOV",null,{"$f":"CONCATENATE(\"=\",$U$7,$V$3,$V$7,$T$5,$U$10)","v":"=VLOOKUP(6,'[DSL Probate Notification Work Tracker.xlsx]DEC 2012'!$A$3:$V$27,22,FALSE)"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,"DEC"]
[]
[]
[]
[]
[null,null,"","","","","",null,null,null,"",""]
[null,"Pass Percentage",{"$f":"IF(COUNTIF(C3:C19,\"N\")=0,IF(COUNTIF(C3:C19,\"Y\")=0,\"N/A\",COUNTIF(C3:C19,\"Y\")/(COUNTIF(C3:C19,\"Y\")+COUNTIF(C3:C19,\"N\"))),COUNTIF(C3:C19,\"Y\")/(COUNTIF(C3:C19,\"Y\")+COUNTIF(C3:C19,\"N\")))","v":0.66666666666666663},0.66666666666666663,0.83333333333333337,0.66666666666666663,0.66666666666666663,0.66666666666666663,0.66666666666666663,0.66666666666666663,0.66666666666666663,{"$f":"AVERAGE(C20:K20)","v":0.68518518518518523}]