{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["ELRA PENALTY SCHEDULE","PENALTY CALCULATION MATRIX","SIGNATURE PAGE","data","Scratch Pad"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":10,"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":"ELRA PENALTY SCHEDULE","index":0,"n_rows":41,"n_cols":64,"rows_kept":41,"cut":false,"hidden":false,"merged":[[48,3,48,17],[37,49,37,61],[2,63,4,63],[29,1,29,28],[30,1,38,28],[33,47,33,61],[0,8,0,35],[1,20,1,35],[0,36,0,39],[0,40,0,61],[1,40,1,61],[31,42,31,45],[29,46,29,61],[29,42,29,45],[37,29,37,40],[11,24,11,27],[29,29,29,40],[31,29,31,40],[13,37,13,40],[13,29,13,32],[37,42,37,45],[9,37,9,40],[8,29,8,32],[9,33,9,36],[9,29,9,32],[1,36,1,39],[6,24,6,27],[6,42,6,45],[7,33,7,36],[8,37,8,40],[17,29,17,32],[17,33,17,36],[13,33,13,36],[15,42,15,45],[11,29,11,32],[17,37,17,40],[7,24,7,27],[7,19,7,21],[7,29,7,32],[7,46,9,61],[3,46,3,61],[3,42,3,45],[8,33,8,36],[7,1,7,12],[9,1,9,12],[7,14,7,17],[8,14,8,17],[9,14,9,17],[8,1,8,12],[8,19,8,21],[9,19,9,21],[8,42,8,45],[7,22,9,22],[7,23,9,23],[9,24,9,27],[8,24,8,27],[9,42,9,45],[4,46,4,61],[7,42,7,45],[7,37,7,40],[4,42,4,45],[27,1,27,11],[27,14,27,17],[27,24,27,27],[27,20,27,21],[27,29,27,32],[27,33,27,36],[27,37,27,40],[11,1,11,11],[13,1,13,11],[14,14,14,17],[15,14,15,17],[13,14,13,17],[15,1,15,11],[19,33,19,36],[19,37,19,40],[19,24,19,27],[19,29,19,32],[19,20,19,21],[23,20,23,21],[25,24,25,27],[11,37,11,40],[11,33,11,36],[15,37,15,40],[25,1,25,11],[19,1,19,11],[19,14,19,17],[17,1,17,11],[21,1,21,11],[21,14,21,17],[23,1,23,11],[23,14,23,17],[25,14,25,17],[24,14,24,17],[11,14,11,17],[12,14,12,17],[15,46,15,61],[17,24,17,27],[13,20,13,21],[15,20,15,21],[17,20,17,21],[28,14,28,17],[16,14,16,17],[18,14,18,17],[20,14,20,17],[22,14,22,17],[17,14,17,17],[26,14,26,17],[15,33,15,36],[11,20,11,21],[25,20,25,21],[25,33,25,36],[25,37,25,40],[27,46,27,61],[27,42,27,45],[23,42,23,45],[25,46,25,61],[25,29,25,32],[17,46,17,61],[15,24,15,27],[15,29,15,32],[21,33,21,36],[21,37,21,40],[19,42,19,45],[11,46,11,61],[13,42,13,45],[13,46,13,61],[13,24,13,27],[21,42,21,45],[19,46,19,61],[21,24,21,27],[21,29,21,32],[11,42,11,45],[17,42,17,45],[33,29,35,40],[33,42,35,45],[34,47,34,61],[35,47,35,61],[30,29,30,61],[21,20,21,21],[23,29,23,32],[23,33,23,36],[23,37,23,40],[23,46,23,61],[23,24,23,27],[25,42,25,45],[21,46,21,61],[31,47,31,61]]}
["Air Pollution Violations",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,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,"DEP DIRECTIVE 923"]
["Penalty Computation Worksheet",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"          Respondent(s)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ARMS ID",null,null,null,"Site Name or Address",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"403.121, F.S.(ELRA)"]
[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,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,"Guidelines for Characterizing Air Violations"]
["Calculation 1 (ELRA Penalty Schedule)",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,null,null,null,1]
[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,null,null,null,null,null,"Date",null,null,null,"Penalty Calculation Prepared By"]
[]
[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":"Y12+Y14+Y16+Y18+Y20+Y22+Y24+Y26+Y28","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AQ12+AQ14+AQ16+AQ18+AQ20+AQ22+AQ24+AQ26+AQ28","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ELRA ",null,null,null,null,"\"Add-ons\" for",null,null,"add-on","base penalty","Enter # of",null,null,null,"Multi-Day ","History of",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Violation Description / Adjustment Comments / Economic Benefit Description"]
[null,"ELRA Penalty Schedule \"Row\"",null,null,null,null,null,null,null,null,null,null,null,null,"Penalty",null,null,null,null,"403.121(3)(f)",null,null,null,null,"Violations",null,null,null,"Penalty -","Noncompliance",null,null,null,"Economic",null,null,null,"Other"]
[null,"Matching the Violation",null,null,null,null,null,null,null,null,null,null,null,null,"Schedule",null,null,null,null,"Violations",null,null,null,null,"*Required",null,null,null,"Enter # Days","% Adjustment",null,null,null,"Benefit",null,null,null,"Adjustments",null,null,null,null,"Total"]
[]
[1,{"$f":"VLOOKUP(N12,tblElraRows,2,0)","v":" "},null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"VLOOKUP(N12,tblElraRows,3,0)","v":0},null,null,null,{"$f":"CHOOSE(T12,0,1500,4500,6000)","v":0},1,{"$f":"IF(OR(N12=2,N12=3),S12,0)","v":0},null,0,{"$f":"O12+U12","v":0},null,null,null,null,0,0,null,null,null,null,null,null,null,0,null,null,null,null,{"$f":"IF(Y12>0,IF(AC12>0,X12*Y12*AC12*(1+AD12)+AH12+AL12, X12*Y12*(1+AD12)+AH12+AL12),)","v":0},{"$f":"IF(SUM(AJ12)>0,IF(OR(AJ12>1,AL12>0,AM12>0,AO12>5000),IF(((AH12+AI12)*AJ12+AK12*AL12)*(1+AN12)+AO12+AQ12>10000*(AJ12+AL12),10000*(AJ12+AL12),((AH12+AI12)*AJ12+AK12*AL12)*(1+AN12)+AO12+AQ12),IF(((AH12+AI12)*AJ12+AK12*AL12)*(1+AN12)+AO12+AQ12>5000*(AJ12+AL12),5000*(AJ12+AL12),((AH12+AI12)*AJ12+AK12*AL12)*(1+AN12)+AO12+AQ12)),0)","v":0},{"$f":"IF(SUM(AK12)>0,IF(OR(AK12>1,AM12>0,AN12>0,AQ12>5000),IF(((AI12+AJ12)*AK12+AL12*AM12)*(1+AO12)+AQ12+AR12>10000*(AK12+AM12),10000*(AK12+AM12),((AI12+AJ12)*AK12+AL12*AM12)*(1+AO12)+AQ12+AR12),IF(((AI12+AJ12)*AK12+AL12*AM12)*(1+AO12)+AQ12+AR12>5000*(AK12+AM12),5000*(AK12+AM12),((AI12+AJ12)*AK12+AL12*AM12)*(1+AO12)+AQ12+AR12)),0)","v":0},{"$f":"IF(SUM(AL12)>0,IF(OR(AL12>1,AN12>0,AO12>0,AR12>5000),IF(((AJ12+AK12)*AL12+AM12*AN12)*(1+AQ12)+AR12+AS12>10000*(AL12+AN12),10000*(AL12+AN12),((AJ12+AK12)*AL12+AM12*AN12)*(1+AQ12)+AR12+AS12),IF(((AJ12+AK12)*AL12+AM12*AN12)*(1+AQ12)+AR12+AS12>5000*(AL12+AN12),5000*(AL12+AN12),((AJ12+AK12)*AL12+AM12*AN12)*(1+AQ12)+AR12+AS12)),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(N12,tblElraRows,4,0)","v":0}]
[2,{"$f":"VLOOKUP(N14,tblElraRows,2,0)","v":" "},null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"VLOOKUP(N14,tblElraRows,3,0)","v":0},null,null,null,{"$f":"CHOOSE(T14,0,1500,4500)","v":0},1,{"$f":"IF(OR(N14=2,N14=3),S14,0)","v":0},null,0,{"$f":"O14+U14","v":0},null,null,null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,null,{"$f":"IF(Y14>0,IF(AC14>0,X14*Y14*AC14*(1+AD14)+AH14+AL14, X14*Y14*(1+AD14)+AH14+AL14),)","v":0},{"$f":"IF(SUM(AJ14)>0,IF(OR(AJ14>1,AL14>0,AM14>0,AO14>5000),IF(((AH14+AI14)*AJ14+AK14*AL14)*(1+AN14)+AO14+AQ14>10000*(AJ14+AL14),10000*(AJ14+AL14),((AH14+AI14)*AJ14+AK14*AL14)*(1+AN14)+AO14+AQ14),IF(((AH14+AI14)*AJ14+AK14*AL14)*(1+AN14)+AO14+AQ14>5000*(AJ14+AL14),5000*(AJ14+AL14),((AH14+AI14)*AJ14+AK14*AL14)*(1+AN14)+AO14+AQ14)),0)","v":0},{"$f":"IF(SUM(AK14)>0,IF(OR(AK14>1,AM14>0,AN14>0,AQ14>5000),IF(((AI14+AJ14)*AK14+AL14*AM14)*(1+AO14)+AQ14+AR14>10000*(AK14+AM14),10000*(AK14+AM14),((AI14+AJ14)*AK14+AL14*AM14)*(1+AO14)+AQ14+AR14),IF(((AI14+AJ14)*AK14+AL14*AM14)*(1+AO14)+AQ14+AR14>5000*(AK14+AM14),5000*(AK14+AM14),((AI14+AJ14)*AK14+AL14*AM14)*(1+AO14)+AQ14+AR14)),0)","v":0},{"$f":"IF(SUM(AL14)>0,IF(OR(AL14>1,AN14>0,AO14>0,AR14>5000),IF(((AJ14+AK14)*AL14+AM14*AN14)*(1+AQ14)+AR14+AS14>10000*(AL14+AN14),10000*(AL14+AN14),((AJ14+AK14)*AL14+AM14*AN14)*(1+AQ14)+AR14+AS14),IF(((AJ14+AK14)*AL14+AM14*AN14)*(1+AQ14)+AR14+AS14>5000*(AL14+AN14),5000*(AL14+AN14),((AJ14+AK14)*AL14+AM14*AN14)*(1+AQ14)+AR14+AS14)),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(N14,tblElraRows,4,0)","v":0}]
[3,{"$f":"VLOOKUP(N16,tblElraRows,2,0)","v":" "},null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"VLOOKUP(N16,tblElraRows,3,0)","v":0},null,null,null,{"$f":"CHOOSE(T16,0,1500,4500)","v":0},1,{"$f":"IF(OR(N16=2,N16=3),S16,0)","v":0},null,0,{"$f":"O16+U16","v":0},null,null,null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,null,{"$f":"IF(Y16>0,IF(AC16>0,X16*Y16*AC16*(1+AD16)+AH16+AL16, X16*Y16*(1+AD16)+AH16+AL16),)","v":0},{"$f":"IF(SUM(AJ16)>0,IF(OR(AJ16>1,AL16>0,AM16>0,AO16>5000),IF(((AH16+AI16)*AJ16+AK16*AL16)*(1+AN16)+AO16+AQ16>10000*(AJ16+AL16),10000*(AJ16+AL16),((AH16+AI16)*AJ16+AK16*AL16)*(1+AN16)+AO16+AQ16),IF(((AH16+AI16)*AJ16+AK16*AL16)*(1+AN16)+AO16+AQ16>5000*(AJ16+AL16),5000*(AJ16+AL16),((AH16+AI16)*AJ16+AK16*AL16)*(1+AN16)+AO16+AQ16)),0)","v":0},{"$f":"IF(SUM(AK16)>0,IF(OR(AK16>1,AM16>0,AN16>0,AQ16>5000),IF(((AI16+AJ16)*AK16+AL16*AM16)*(1+AO16)+AQ16+AR16>10000*(AK16+AM16),10000*(AK16+AM16),((AI16+AJ16)*AK16+AL16*AM16)*(1+AO16)+AQ16+AR16),IF(((AI16+AJ16)*AK16+AL16*AM16)*(1+AO16)+AQ16+AR16>5000*(AK16+AM16),5000*(AK16+AM16),((AI16+AJ16)*AK16+AL16*AM16)*(1+AO16)+AQ16+AR16)),0)","v":0},{"$f":"IF(SUM(AL16)>0,IF(OR(AL16>1,AN16>0,AO16>0,AR16>5000),IF(((AJ16+AK16)*AL16+AM16*AN16)*(1+AQ16)+AR16+AS16>10000*(AL16+AN16),10000*(AL16+AN16),((AJ16+AK16)*AL16+AM16*AN16)*(1+AQ16)+AR16+AS16),IF(((AJ16+AK16)*AL16+AM16*AN16)*(1+AQ16)+AR16+AS16>5000*(AL16+AN16),5000*(AL16+AN16),((AJ16+AK16)*AL16+AM16*AN16)*(1+AQ16)+AR16+AS16)),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(N16,tblElraRows,4,0)","v":0}]
[4,{"$f":"VLOOKUP(N18,tblElraRows,2,0)","v":" "},null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"VLOOKUP(N18,tblElraRows,3,0)","v":0},null,null,null,{"$f":"CHOOSE(T18,0,1500,4500)","v":0},1,{"$f":"IF(OR(N18=2,N18=3),S18,0)","v":0},null,1000,{"$f":"O18+U18","v":0},null,null,null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,null,{"$f":"IF(Y18>0,IF(AC18>0,X18*Y18*AC18*(1+AD18)+AH18+AL18, X18*Y18*(1+AD18)+AH18+AL18),)","v":0},{"$f":"IF(SUM(AJ18)>0,IF(OR(AJ18>1,AL18>0,AM18>0,AO18>5000),IF(((AH18+AI18)*AJ18+AK18*AL18)*(1+AN18)+AO18+AQ18>10000*(AJ18+AL18),10000*(AJ18+AL18),((AH18+AI18)*AJ18+AK18*AL18)*(1+AN18)+AO18+AQ18),IF(((AH18+AI18)*AJ18+AK18*AL18)*(1+AN18)+AO18+AQ18>5000*(AJ18+AL18),5000*(AJ18+AL18),((AH18+AI18)*AJ18+AK18*AL18)*(1+AN18)+AO18+AQ18)),0)","v":0},{"$f":"IF(SUM(AK18)>0,IF(OR(AK18>1,AM18>0,AN18>0,AQ18>5000),IF(((AI18+AJ18)*AK18+AL18*AM18)*(1+AO18)+AQ18+AR18>10000*(AK18+AM18),10000*(AK18+AM18),((AI18+AJ18)*AK18+AL18*AM18)*(1+AO18)+AQ18+AR18),IF(((AI18+AJ18)*AK18+AL18*AM18)*(1+AO18)+AQ18+AR18>5000*(AK18+AM18),5000*(AK18+AM18),((AI18+AJ18)*AK18+AL18*AM18)*(1+AO18)+AQ18+AR18)),0)","v":0},{"$f":"IF(SUM(AL18)>0,IF(OR(AL18>1,AN18>0,AO18>0,AR18>5000),IF(((AJ18+AK18)*AL18+AM18*AN18)*(1+AQ18)+AR18+AS18>10000*(AL18+AN18),10000*(AL18+AN18),((AJ18+AK18)*AL18+AM18*AN18)*(1+AQ18)+AR18+AS18),IF(((AJ18+AK18)*AL18+AM18*AN18)*(1+AQ18)+AR18+AS18>5000*(AL18+AN18),5000*(AL18+AN18),((AJ18+AK18)*AL18+AM18*AN18)*(1+AQ18)+AR18+AS18)),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(N18,tblElraRows,4,0)","v":0}]
[5,{"$f":"VLOOKUP(N20,tblElraRows,2,0)","v":" "},null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"VLOOKUP(N20,tblElraRows,3,0)","v":0},null,null,null,{"$f":"CHOOSE(T20,0,1500,4500)","v":0},1,{"$f":"IF(OR(N20=2,N20=3),S20,0)","v":0},null,1000,{"$f":"O20+U20","v":0},null,null,null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,null,{"$f":"IF(Y20>0,IF(AC20>0,X20*Y20*AC20*(1+AD20)+AH20+AL20, X20*Y20*(1+AD20)+AH20+AL20),)","v":0},{"$f":"IF(SUM(AJ20)>0,IF(OR(AJ20>1,AL20>0,AM20>0,AO20>5000),IF(((AH20+AI20)*AJ20+AK20*AL20)*(1+AN20)+AO20+AQ20>10000*(AJ20+AL20),10000*(AJ20+AL20),((AH20+AI20)*AJ20+AK20*AL20)*(1+AN20)+AO20+AQ20),IF(((AH20+AI20)*AJ20+AK20*AL20)*(1+AN20)+AO20+AQ20>5000*(AJ20+AL20),5000*(AJ20+AL20),((AH20+AI20)*AJ20+AK20*AL20)*(1+AN20)+AO20+AQ20)),0)","v":0},{"$f":"IF(SUM(AK20)>0,IF(OR(AK20>1,AM20>0,AN20>0,AQ20>5000),IF(((AI20+AJ20)*AK20+AL20*AM20)*(1+AO20)+AQ20+AR20>10000*(AK20+AM20),10000*(AK20+AM20),((AI20+AJ20)*AK20+AL20*AM20)*(1+AO20)+AQ20+AR20),IF(((AI20+AJ20)*AK20+AL20*AM20)*(1+AO20)+AQ20+AR20>5000*(AK20+AM20),5000*(AK20+AM20),((AI20+AJ20)*AK20+AL20*AM20)*(1+AO20)+AQ20+AR20)),0)","v":0},{"$f":"IF(SUM(AL20)>0,IF(OR(AL20>1,AN20>0,AO20>0,AR20>5000),IF(((AJ20+AK20)*AL20+AM20*AN20)*(1+AQ20)+AR20+AS20>10000*(AL20+AN20),10000*(AL20+AN20),((AJ20+AK20)*AL20+AM20*AN20)*(1+AQ20)+AR20+AS20),IF(((AJ20+AK20)*AL20+AM20*AN20)*(1+AQ20)+AR20+AS20>5000*(AL20+AN20),5000*(AL20+AN20),((AJ20+AK20)*AL20+AM20*AN20)*(1+AQ20)+AR20+AS20)),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(N20,tblElraRows,4,0)","v":0}]
[6,{"$f":"VLOOKUP(N22,tblElraRows,2,0)","v":" "},null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"VLOOKUP(N22,tblElraRows,3,0)","v":0},null,null,null,{"$f":"CHOOSE(T22,0,1500,4500)","v":0},1,{"$f":"IF(OR(N22=2,N22=3),S22,0)","v":0},null,0,{"$f":"O22+U22","v":0},null,null,null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,null,{"$f":"IF(Y22>0,IF(AC22>0,X22*Y22*AC22*(1+AD22)+AH22+AL22, X22*Y22*(1+AD22)+AH22+AL22),)","v":0},{"$f":"IF(SUM(AJ22)>0,IF(OR(AJ22>1,AL22>0,AM22>0,AO22>5000),IF(((AH22+AI22)*AJ22+AK22*AL22)*(1+AN22)+AO22+AQ22>10000*(AJ22+AL22),10000*(AJ22+AL22),((AH22+AI22)*AJ22+AK22*AL22)*(1+AN22)+AO22+AQ22),IF(((AH22+AI22)*AJ22+AK22*AL22)*(1+AN22)+AO22+AQ22>5000*(AJ22+AL22),5000*(AJ22+AL22),((AH22+AI22)*AJ22+AK22*AL22)*(1+AN22)+AO22+AQ22)),0)","v":0},{"$f":"IF(SUM(AK22)>0,IF(OR(AK22>1,AM22>0,AN22>0,AQ22>5000),IF(((AI22+AJ22)*AK22+AL22*AM22)*(1+AO22)+AQ22+AR22>10000*(AK22+AM22),10000*(AK22+AM22),((AI22+AJ22)*AK22+AL22*AM22)*(1+AO22)+AQ22+AR22),IF(((AI22+AJ22)*AK22+AL22*AM22)*(1+AO22)+AQ22+AR22>5000*(AK22+AM22),5000*(AK22+AM22),((AI22+AJ22)*AK22+AL22*AM22)*(1+AO22)+AQ22+AR22)),0)","v":0},{"$f":"IF(SUM(AL22)>0,IF(OR(AL22>1,AN22>0,AO22>0,AR22>5000),IF(((AJ22+AK22)*AL22+AM22*AN22)*(1+AQ22)+AR22+AS22>10000*(AL22+AN22),10000*(AL22+AN22),((AJ22+AK22)*AL22+AM22*AN22)*(1+AQ22)+AR22+AS22),IF(((AJ22+AK22)*AL22+AM22*AN22)*(1+AQ22)+AR22+AS22>5000*(AL22+AN22),5000*(AL22+AN22),((AJ22+AK22)*AL22+AM22*AN22)*(1+AQ22)+AR22+AS22)),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(N22,tblElraRows,4,0)","v":0}]
[7,{"$f":"VLOOKUP(N24,tblElraRows,2,0)","v":" "},null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"VLOOKUP(N24,tblElraRows,3,0)","v":0},null,null,null,{"$f":"CHOOSE(T24,0,1500,4500)","v":0},1,{"$f":"IF(OR(N24=2,N24=3),S24,0)","v":0},null,0,{"$f":"O24+U24","v":0},null,null,null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,null,{"$f":"IF(Y24>0,IF(AC24>0,X24*Y24*AC24*(1+AD24)+AH24+AL24, X24*Y24*(1+AD24)+AH24+AL24),)","v":0},{"$f":"IF(SUM(AJ24)>0,IF(OR(AJ24>1,AL24>0,AM24>0,AO24>5000),IF(((AH24+AI24)*AJ24+AK24*AL24)*(1+AN24)+AO24+AQ24>10000*(AJ24+AL24),10000*(AJ24+AL24),((AH24+AI24)*AJ24+AK24*AL24)*(1+AN24)+AO24+AQ24),IF(((AH24+AI24)*AJ24+AK24*AL24)*(1+AN24)+AO24+AQ24>5000*(AJ24+AL24),5000*(AJ24+AL24),((AH24+AI24)*AJ24+AK24*AL24)*(1+AN24)+AO24+AQ24)),0)","v":0},{"$f":"IF(SUM(AK24)>0,IF(OR(AK24>1,AM24>0,AN24>0,AQ24>5000),IF(((AI24+AJ24)*AK24+AL24*AM24)*(1+AO24)+AQ24+AR24>10000*(AK24+AM24),10000*(AK24+AM24),((AI24+AJ24)*AK24+AL24*AM24)*(1+AO24)+AQ24+AR24),IF(((AI24+AJ24)*AK24+AL24*AM24)*(1+AO24)+AQ24+AR24>5000*(AK24+AM24),5000*(AK24+AM24),((AI24+AJ24)*AK24+AL24*AM24)*(1+AO24)+AQ24+AR24)),0)","v":0},{"$f":"IF(SUM(AL24)>0,IF(OR(AL24>1,AN24>0,AO24>0,AR24>5000),IF(((AJ24+AK24)*AL24+AM24*AN24)*(1+AQ24)+AR24+AS24>10000*(AL24+AN24),10000*(AL24+AN24),((AJ24+AK24)*AL24+AM24*AN24)*(1+AQ24)+AR24+AS24),IF(((AJ24+AK24)*AL24+AM24*AN24)*(1+AQ24)+AR24+AS24>5000*(AL24+AN24),5000*(AL24+AN24),((AJ24+AK24)*AL24+AM24*AN24)*(1+AQ24)+AR24+AS24)),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(N24,tblElraRows,4,0)","v":0}]
[8,{"$f":"VLOOKUP(N26,tblElraRows,2,0)","v":" "},null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"VLOOKUP(N26,tblElraRows,3,0)","v":0},null,null,null,{"$f":"CHOOSE(T26,0,1500,4500)","v":0},1,{"$f":"IF(OR(N26=2,N26=3),S26,0)","v":0},null,0,{"$f":"O26+U26","v":0},null,null,null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,null,{"$f":"IF(Y26>0,IF(AC26>0,X26*Y26*AC26*(1+AD26)+AH26+AL26, X26*Y26*(1+AD26)+AH26+AL26),)","v":0},{"$f":"IF(SUM(AJ26)>0,IF(OR(AJ26>1,AL26>0,AM26>0,AO26>5000),IF(((AH26+AI26)*AJ26+AK26*AL26)*(1+AN26)+AO26+AQ26>10000*(AJ26+AL26),10000*(AJ26+AL26),((AH26+AI26)*AJ26+AK26*AL26)*(1+AN26)+AO26+AQ26),IF(((AH26+AI26)*AJ26+AK26*AL26)*(1+AN26)+AO26+AQ26>5000*(AJ26+AL26),5000*(AJ26+AL26),((AH26+AI26)*AJ26+AK26*AL26)*(1+AN26)+AO26+AQ26)),0)","v":0},{"$f":"IF(SUM(AK26)>0,IF(OR(AK26>1,AM26>0,AN26>0,AQ26>5000),IF(((AI26+AJ26)*AK26+AL26*AM26)*(1+AO26)+AQ26+AR26>10000*(AK26+AM26),10000*(AK26+AM26),((AI26+AJ26)*AK26+AL26*AM26)*(1+AO26)+AQ26+AR26),IF(((AI26+AJ26)*AK26+AL26*AM26)*(1+AO26)+AQ26+AR26>5000*(AK26+AM26),5000*(AK26+AM26),((AI26+AJ26)*AK26+AL26*AM26)*(1+AO26)+AQ26+AR26)),0)","v":0},{"$f":"IF(SUM(AL26)>0,IF(OR(AL26>1,AN26>0,AO26>0,AR26>5000),IF(((AJ26+AK26)*AL26+AM26*AN26)*(1+AQ26)+AR26+AS26>10000*(AL26+AN26),10000*(AL26+AN26),((AJ26+AK26)*AL26+AM26*AN26)*(1+AQ26)+AR26+AS26),IF(((AJ26+AK26)*AL26+AM26*AN26)*(1+AQ26)+AR26+AS26>5000*(AL26+AN26),5000*(AL26+AN26),((AJ26+AK26)*AL26+AM26*AN26)*(1+AQ26)+AR26+AS26)),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(N26,tblElraRows,4,0)","v":0}]
[9,{"$f":"VLOOKUP(N28,tblElraRows,2,0)","v":" "},null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"VLOOKUP(N28,tblElraRows,3,0)","v":0},null,null,null,{"$f":"CHOOSE(T28,0,1500,4500)","v":0},1,{"$f":"IF(OR(N28=2,N28=3),S28,0)","v":0},null,0,{"$f":"O28+U28","v":0},null,null,null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,null,{"$f":"IF(Y28>0,IF(AC28>0,X28*Y28*AC28*(1+AD28)+AH28+AL28, X28*Y28*(1+AD28)+AH28+AL28),)","v":0},{"$f":"IF(SUM(AJ28)>0,IF(OR(AJ28>1,AL28>0,AM28>0,AO28>5000),IF(((AH28+AI28)*AJ28+AK28*AL28)*(1+AN28)+AO28+AQ28>10000*(AJ28+AL28),10000*(AJ28+AL28),((AH28+AI28)*AJ28+AK28*AL28)*(1+AN28)+AO28+AQ28),IF(((AH28+AI28)*AJ28+AK28*AL28)*(1+AN28)+AO28+AQ28>5000*(AJ28+AL28),5000*(AJ28+AL28),((AH28+AI28)*AJ28+AK28*AL28)*(1+AN28)+AO28+AQ28)),0)","v":0},{"$f":"IF(SUM(AK28)>0,IF(OR(AK28>1,AM28>0,AN28>0,AQ28>5000),IF(((AI28+AJ28)*AK28+AL28*AM28)*(1+AO28)+AQ28+AR28>10000*(AK28+AM28),10000*(AK28+AM28),((AI28+AJ28)*AK28+AL28*AM28)*(1+AO28)+AQ28+AR28),IF(((AI28+AJ28)*AK28+AL28*AM28)*(1+AO28)+AQ28+AR28>5000*(AK28+AM28),5000*(AK28+AM28),((AI28+AJ28)*AK28+AL28*AM28)*(1+AO28)+AQ28+AR28)),0)","v":0},{"$f":"IF(SUM(AL28)>0,IF(OR(AL28>1,AN28>0,AO28>0,AR28>5000),IF(((AJ28+AK28)*AL28+AM28*AN28)*(1+AQ28)+AR28+AS28>10000*(AL28+AN28),10000*(AL28+AN28),((AJ28+AK28)*AL28+AM28*AN28)*(1+AQ28)+AR28+AS28),IF(((AJ28+AK28)*AL28+AM28*AN28)*(1+AQ28)+AR28+AS28>5000*(AL28+AN28),5000*(AL28+AN28),((AJ28+AK28)*AL28+AM28*AN28)*(1+AQ28)+AR28+AS28)),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(N28,tblElraRows,4,0)","v":0}]
[null,"Additional Comments:",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,"Economic benefit not associated with a specific violation",null,null,null,null,null,null,null,null,null,null,null,null,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,"SUB-TOTAL",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AQ12+AQ14+AQ16+AQ18+AQ20+AQ22+AQ24+AQ26+AQ28+AQ30","v":0},{"$f":"IF(SUM(AJ32)>0,IF(OR(AJ32>1,AD32>0,AM32>0,AO32>5000),IF(((AH32+AI32)*AJ32+AK32*AD32)*(1+AN32)+AO32+AQ32>10000*(AJ32+AD32),10000*(AJ32+AD32),((AH32+AI32)*AJ32+AK32*AD32)*(1+AN32)+AO32+AQ32),IF(((AH32+AI32)*AJ32+AK32*AD32)*(1+AN32)+AO32+AQ32>5000*(AJ32+AD32),5000*(AJ32+AD32),((AH32+AI32)*AJ32+AK32*AD32)*(1+AN32)+AO32+AQ32)),0)","v":0},{"$f":"IF(SUM(AK32)>0,IF(OR(AK32>1,AM32>0,AN32>0,AQ32>5000),IF(((AI32+AJ32)*AK32+AD32*AM32)*(1+AO32)+AQ32+AR32>10000*(AK32+AM32),10000*(AK32+AM32),((AI32+AJ32)*AK32+AD32*AM32)*(1+AO32)+AQ32+AR32),IF(((AI32+AJ32)*AK32+AD32*AM32)*(1+AO32)+AQ32+AR32>5000*(AK32+AM32),5000*(AK32+AM32),((AI32+AJ32)*AK32+AD32*AM32)*(1+AO32)+AQ32+AR32)),0)","v":0},{"$f":"IF(SUM(AD32)>0,IF(OR(AD32>1,AN32>0,AO32>0,AR32>5000),IF(((AJ32+AK32)*AD32+AM32*AN32)*(1+AQ32)+AR32+AS32>10000*(AD32+AN32),10000*(AD32+AN32),((AJ32+AK32)*AD32+AM32*AN32)*(1+AQ32)+AR32+AS32),IF(((AJ32+AK32)*AD32+AM32*AN32)*(1+AQ32)+AR32+AS32>5000*(AD32+AN32),5000*(AD32+AN32),((AJ32+AK32)*AD32+AM32*AN32)*(1+AQ32)+AR32+AS32)),0)","v":0},null,{"$f":"IF(AP4=2,\"If this calculation is in support of an ELRA Notice of Violation, total penalties cannot exceed $50,000.\",\"Total penalties assessed using ELRA penalty schedules.\")","v":"Total penalties assessed using ELRA penalty schedules."}]
[]
[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,"Enter the costs and expenses of\ninvestigating the violation",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(AU34=1,AP4=2),0,IF(AU34=2,250,IF(AU34=3,750,IF(AU34=4,2500,0))))","v":0},0,null,null,null,{"$f":"IF(OR(AZ34=1,AT4=2),0,IF(AZ34=2,100,IF(AZ34=3,300,IF(OR(AZ34=4,AZ34=5),500,IF(AZ34=6,750,IF(OR(AZ34=7,AZ34=8),1000,IF(AZ34=9,3000,IF(AZ34=10,5000,0))))))))","v":0},"Minimum enforcement case range: $100 to $500"]
[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,null,null,null,null,null,null,null,null,null,null,"Average enforcement case range: $500 to $1,000"]
[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,null,null,null,null,null,null,null,null,null,null,"Complex enforcement case range: $1,000 to $5,000"]
[]
[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,"TOTAL",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($AV$38,MIN(AQ32,50000),AQ32)+AQ34","v":0},{"$f":"IF(SUM(AJ38)>0,IF(OR(AJ38>1,AD38>0,AM38>0,AO38>5000),IF(((AH38+AI38)*AJ38+AK38*AD38)*(1+AN38)+AO38+AQ38>10000*(AJ38+AD38),10000*(AJ38+AD38),((AH38+AI38)*AJ38+AK38*AD38)*(1+AN38)+AO38+AQ38),IF(((AH38+AI38)*AJ38+AK38*AD38)*(1+AN38)+AO38+AQ38>5000*(AJ38+AD38),5000*(AJ38+AD38),((AH38+AI38)*AJ38+AK38*AD38)*(1+AN38)+AO38+AQ38)),0)","v":0},{"$f":"IF(SUM(AK38)>0,IF(OR(AK38>1,AM38>0,AN38>0,AQ38>5000),IF(((AI38+AJ38)*AK38+AD38*AM38)*(1+AO38)+AQ38+AR38>10000*(AK38+AM38),10000*(AK38+AM38),((AI38+AJ38)*AK38+AD38*AM38)*(1+AO38)+AQ38+AR38),IF(((AI38+AJ38)*AK38+AD38*AM38)*(1+AO38)+AQ38+AR38>5000*(AK38+AM38),5000*(AK38+AM38),((AI38+AJ38)*AK38+AD38*AM38)*(1+AO38)+AQ38+AR38)),0)","v":0},{"$f":"IF(SUM(AD38)>0,IF(OR(AD38>1,AN38>0,AO38>0,AR38>5000),IF(((AJ38+AK38)*AD38+AM38*AN38)*(1+AQ38)+AR38+AS38>10000*(AD38+AN38),10000*(AD38+AN38),((AJ38+AK38)*AD38+AM38*AN38)*(1+AQ38)+AR38+AS38),IF(((AJ38+AK38)*AD38+AM38*AN38)*(1+AQ38)+AR38+AS38>5000*(AD38+AN38),5000*(AD38+AN38),((AJ38+AK38)*AD38+AM38*AN38)*(1+AQ38)+AR38+AS38)),0)","v":0},null,false,null,"Check this box to cap the total penalties at $50,000 for settlement purposes under ELRA"]
[]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Penalty Computation Worksheet"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Revised 07-01-2020"]

{"sheet":"PENALTY CALCULATION MATRIX","index":1,"n_rows":41,"n_cols":159,"rows_kept":41,"cut":false,"hidden":false,"merged":[[0,0,0,18],[1,0,1,18],[3,0,3,18],[0,19,0,39],[1,19,1,39],[26,35,26,38],[18,31,18,34],[18,35,18,38],[16,21,16,23],[16,24,16,28],[16,31,16,34],[14,21,14,23],[26,24,26,28],[12,21,12,23],[20,21,20,23],[20,24,20,28],[20,31,20,34],[20,35,20,38],[12,1,12,3],[12,6,12,8],[25,12,25,14],[22,11,22,14],[25,1,25,9],[20,39,20,42],[20,43,20,57],[19,15,19,21],[26,39,26,42],[18,39,18,42],[26,43,26,57],[24,21,24,23],[24,24,24,28],[24,31,24,34],[24,35,24,38],[26,31,26,34],[24,39,24,42],[24,43,24,57],[18,43,18,57],[22,35,22,38],[22,39,22,42],[24,15,24,18],[25,15,25,21],[23,15,23,21],[22,21,22,23],[22,24,22,28],[22,31,22,34],[28,1,28,23],[26,1,26,3],[26,6,26,8],[28,39,28,42],[30,39,30,42],[29,1,37,23],[26,11,26,14],[26,15,26,18],[28,24,28,38],[30,24,30,38],[36,24,36,38],[29,24,29,57],[32,43,32,57],[32,39,34,42],[32,24,34,38],[33,43,33,57],[34,43,34,57],[14,15,14,18],[14,11,14,14],[17,12,17,14],[17,15,17,21],[18,11,18,14],[11,12,11,14],[11,15,11,21],[10,31,10,34],[27,12,27,14],[27,15,27,21],[26,21,26,23],[13,12,13,14],[15,12,15,14],[12,24,12,28],[12,31,12,34],[10,39,10,42],[22,43,22,57],[20,1,20,3],[20,6,20,8],[20,11,20,14],[20,15,20,18],[14,35,14,38],[16,39,16,42],[16,1,16,3],[15,1,15,9],[14,1,14,3],[22,15,22,18],[10,1,10,3],[10,6,10,8],[10,15,10,18],[10,21,10,23],[10,11,10,14],[11,1,11,9],[13,1,13,9],[12,11,12,14],[12,15,12,18],[13,15,13,21],[12,43,12,57],[15,15,15,21],[12,35,12,38],[6,1,6,4],[6,15,6,18],[6,19,6,23],[7,15,7,18],[7,35,7,38],[6,6,6,9],[8,24,8,28],[7,19,7,23],[7,1,7,4],[8,1,8,4],[6,11,6,14],[7,11,7,14],[8,11,8,14],[7,6,7,9],[8,6,8,9],[10,24,10,28],[10,35,10,38],[39,15,39,18],[39,22,39,25],[39,50,39,53],[28,43,28,57],[8,19,8,23],[8,31,8,34],[8,35,8,38],[8,39,8,42],[14,43,14,57],[8,15,8,18],[16,43,16,57],[10,43,10,57],[36,39,36,42],[30,43,30,57],[36,43,36,57],[18,15,18,18],[21,15,21,21],[16,15,16,18],[16,35,16,38],[18,21,18,23],[18,24,18,28],[12,39,12,42],[14,24,14,28],[14,31,14,34],[3,69,4,69],[3,19,4,19],[4,41,4,44],[7,24,7,28],[7,31,7,34],[6,31,6,34],[6,39,6,42],[7,39,7,42],[4,45,4,58],[6,24,6,28],[3,41,3,44],[3,45,3,58],[6,35,6,38],[6,43,8,57],[3,61,5,61],[3,21,4,40],[0,40,0,43],[1,40,1,43],[0,44,0,58],[1,44,1,58],[1,61,2,61],[27,1,27,9],[17,1,17,9],[19,1,19,9],[21,1,21,9],[23,1,23,9],[22,1,22,3],[22,6,22,8],[18,1,18,3],[14,6,14,8],[24,1,24,3],[16,6,16,8],[16,11,16,14],[18,6,18,8],[21,12,21,14],[19,12,19,14],[23,12,23,14],[24,6,24,8],[24,11,24,14],[14,39,14,42]]}
["Air Pollution Violations",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'ELRA PENALTY SCHEDULE'!I1","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'ELRA PENALTY SCHEDULE'!$AK$1","v":0},null,null,null,{"$f":"'ELRA PENALTY SCHEDULE'!$AO$1","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DEP DIRECTIVE 923"]
["Penalty Computation Worksheet",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Respondent(s)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ARMS ID",null,null,null,"Site Name or Address",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"403.121, F.S.(ELRA)"]
[]
["Calculation 2 (Penalty Calculation Matrix)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"     This calculation is for purposes of settlement, and the ELRA\n     penalty schedule calculation exceeds $10,000.","     This calculation is for purposes of settlement, and the ELRA\n     penalty schedule calculation exceeds $50,000.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'ELRA PENALTY SCHEDULE'!$AQ$4","v":"00:00:00"},null,null,null,{"$f":"'ELRA PENALTY SCHEDULE'!$AU$4","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,"Guidelines for Characterizing Air Violations"]
[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,null,null,null,null,"Date",null,null,null,"Penalty Calculation Prepared By"]
[]
[null,null,null,null,null,null,"Extent of",null,null,null,null,"Baseline",null,null,null,"Enter # of",null,null,null,"Multi-Day Penalty -",null,null,null,null,"Multi-Day ","Mulit-Day ","Mulit-Day ","Mulit-Day ","Mulit-Day ","History of","History of",null,null,null,null,null,null,null,null,null,null,null,null,"Violation Description / Adjustment Comments / Economic Benefit Description"]
[null,"Environmental",null,null,null,null,"Deviation from",null,null,null,null,"Penalty",null,null,null,"Violations",null,null,null,"Select % to Calc.Amt/day",null,null,null,null,"Penalty -","Penalty/","Penalty/","Penalty/","Penalty/","Noncompliance","Noncompliance","Economic",null,null,null,"Other"]
[null,"Harm",null,null,null,null,"Requirement",null,null,null,null,"Amount",null,null,null,"*Required",null,null,null,"or Enter $Amt/day to Apply",null,null,null,null,"Enter # Days","Enter # Days","Enter # Days","Enter # Days","Enter # Days","% Adjustment","% Adjustment","Benefit",null,null,null,"Adjustments",null,null,null,"Total"]
[]
[1,{"$f":"VLOOKUP(F11,tblAxes,2,0)","v":0},null,null,null,1,{"$f":"VLOOKUP(K11,tblAxes,2,0)","v":0},null,null,null,1,{"$f":"VLOOKUP(F11,tblMatrixMidpoint,K11+1,0)","v":0},null,null,null,null,null,null,null,{"$f":"VLOOKUP(U11,tblMulti,2,0)","v":0},1,{"$f":"L11*T11","v":0},null,null,null,null,null,null,null,null,0.25,0,null,null,null,0,null,null,null,{"$f":"IF((P11+Y11)>0,((L11*P11)+(V11*Y11))*(1+AD11)+AF11+AJ11,0)","v":0}]
[null,{"$f":"IF(AND(NOT(B11=0),NOT(G11=0)),CONCATENATE(\"matrix range: \",DOLLAR(VLOOKUP(F11,tblMatrixLow,K11+1,0),0),\" to \",DOLLAR(VLOOKUP(F11,tblMatrixHigh,K11+1,0),0)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(F11,tblMatrixMidpoint,K11+1,0)","v":0},null,null,{"$f":"IF(M12>0,\"= middle of range\",\"\")","v":""}]
[2,{"$f":"VLOOKUP(F13,tblAxes,2,0)","v":0},null,null,null,1,{"$f":"VLOOKUP(K13,tblAxes,2,0)","v":0},null,null,null,1,{"$f":"VLOOKUP(F13,tblMatrixMidpoint,K13+1,0)","v":0},null,null,null,null,null,null,null,{"$f":"VLOOKUP(U13,tblMulti,2,0)","v":0},1,{"$f":"L13*T13","v":0},null,null,null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,{"$f":"IF((P13+Y13)>0,((L13*P13)+(V13*Y13))*(1+AD13)+AF13+AJ13,0)","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,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,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,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,{"$f":"IF(AND(NOT(B13=0),NOT(G13=0)),CONCATENATE(\"matrix range: \",DOLLAR(VLOOKUP(F13,tblMatrixLow,K13+1,0),0),\" to \",DOLLAR(VLOOKUP(F13,tblMatrixHigh,K13+1,0),0)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(F13,tblMatrixMidpoint,K13+1,0)","v":0},null,null,{"$f":"IF(M14>0,\"= middle of range\",\"\")","v":""}]
[3,{"$f":"VLOOKUP(F15,tblAxes,2,0)","v":0},null,null,null,1,{"$f":"VLOOKUP(K15,tblAxes,2,0)","v":0},null,null,null,1,{"$f":"VLOOKUP(F15,tblMatrixMidpoint,K15+1,0)","v":0},null,null,null,null,null,null,null,{"$f":"VLOOKUP(U15,tblMulti,2,0)","v":0},1,{"$f":"L15*T15","v":0},null,null,null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,{"$f":"IF((P15+Y15)>0,((L15*P15)+(V15*Y15))*(1+AD15)+AF15+AJ15,0)","v":0}]
[null,{"$f":"IF(AND(NOT(B15=0),NOT(G15=0)),CONCATENATE(\"matrix range: \",DOLLAR(VLOOKUP(F15,tblMatrixLow,K15+1,0),0),\" to \",DOLLAR(VLOOKUP(F15,tblMatrixHigh,K15+1,0),0)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(F15,tblMatrixMidpoint,K15+1,0)","v":0},null,null,{"$f":"IF(M16>0,\"= middle of range\",\"\")","v":""}]
[4,{"$f":"VLOOKUP(F17,tblAxes,2,0)","v":0},null,null,null,1,{"$f":"VLOOKUP(K17,tblAxes,2,0)","v":0},null,null,null,1,{"$f":"VLOOKUP(F17,tblMatrixMidpoint,K17+1,0)","v":0},null,null,null,null,null,null,null,null,3,{"$f":"L17*T17","v":0},null,null,null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,{"$f":"IF((P17+Y17)>0,((L17*P17)+(V17*Y17))*(1+AD17)+AF17+AJ17,0)","v":0}]
[null,{"$f":"IF(AND(NOT(B17=0),NOT(G17=0)),CONCATENATE(\"matrix range: \",DOLLAR(VLOOKUP(F17,tblMatrixLow,K17+1,0),0),\" to \",DOLLAR(VLOOKUP(F17,tblMatrixHigh,K17+1,0),0)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(F17,tblMatrixMidpoint,K17+1,0)","v":0},null,null,{"$f":"IF(M18>0,\"= middle of range\",\"\")","v":""},null,null,null,null,6]
[5,{"$f":"VLOOKUP(F19,tblAxes,2,0)","v":0},null,null,null,1,{"$f":"VLOOKUP(K19,tblAxes,2,0)","v":0},null,null,null,1,{"$f":"VLOOKUP(F19,tblMatrixMidpoint,K19+1,0)","v":0},null,null,null,null,null,null,null,{"$f":"VLOOKUP(U19,tblMulti,2,0)","v":0},1,{"$f":"L19*T19","v":0},null,null,null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,{"$f":"IF((P19+Y19)>0,((L19*P19)+(V19*Y19))*(1+AD19)+AF19+AJ19,0)","v":0}]
[null,{"$f":"IF(AND(NOT(B19=0),NOT(G19=0)),CONCATENATE(\"matrix range: \",DOLLAR(VLOOKUP(F19,tblMatrixLow,K19+1,0),0),\" to \",DOLLAR(VLOOKUP(F19,tblMatrixHigh,K19+1,0),0)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(F19,tblMatrixMidpoint,K19+1,0)","v":0},null,null,{"$f":"IF(M20>0,\"= middle of range\",\"\")","v":""}]
[6,{"$f":"VLOOKUP(F21,tblAxes,2,0)","v":0},null,null,null,1,{"$f":"VLOOKUP(K21,tblAxes,2,0)","v":0},null,null,null,1,{"$f":"VLOOKUP(F21,tblMatrixMidpoint,K21+1,0)","v":0},null,null,null,null,null,null,null,{"$f":"VLOOKUP(U21,tblMulti,2,0)","v":0},1,{"$f":"L21*T21","v":0},null,null,null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,{"$f":"IF((P21+Y21)>0,((L21*P21)+(V21*Y21))*(1+AD21)+AF21+AJ21,0)","v":0}]
[null,{"$f":"IF(AND(NOT(B21=0),NOT(G21=0)),CONCATENATE(\"matrix range: \",DOLLAR(VLOOKUP(F21,tblMatrixLow,K21+1,0),0),\" to \",DOLLAR(VLOOKUP(F21,tblMatrixHigh,K21+1,0),0)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(F21,tblMatrixMidpoint,K21+1,0)","v":0},null,null,{"$f":"IF(M22>0,\"= middle of range\",\"\")","v":""}]
[7,{"$f":"VLOOKUP(F23,tblAxes,2,0)","v":0},null,null,null,1,{"$f":"VLOOKUP(K23,tblAxes,2,0)","v":0},null,null,null,1,{"$f":"VLOOKUP(F23,tblMatrixMidpoint,K23+1,0)","v":0},null,null,null,null,null,null,null,{"$f":"VLOOKUP(U23,tblMulti,2,0)","v":0},1,{"$f":"L23*T23","v":0},null,null,null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,{"$f":"IF((P23+Y23)>0,((L23*P23)+(V23*Y23))*(1+AD23)+AF23+AJ23,0)","v":0}]
[null,{"$f":"IF(AND(NOT(B23=0),NOT(G23=0)),CONCATENATE(\"matrix range: \",DOLLAR(VLOOKUP(F23,tblMatrixLow,K23+1,0),0),\" to \",DOLLAR(VLOOKUP(F23,tblMatrixHigh,K23+1,0),0)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(F23,tblMatrixMidpoint,K23+1,0)","v":0},null,null,{"$f":"IF(M24>0,\"= middle of range\",\"\")","v":""}]
[8,{"$f":"VLOOKUP(F25,tblAxes,2,0)","v":0},null,null,null,1,{"$f":"VLOOKUP(K25,tblAxes,2,0)","v":0},null,null,null,1,{"$f":"VLOOKUP(F25,tblMatrixMidpoint,K25+1,0)","v":0},null,null,null,null,null,null,null,{"$f":"VLOOKUP(U25,tblMulti,2,0)","v":0},1,{"$f":"L25*T25","v":0},null,null,null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,{"$f":"IF((P25+Y25)>0,((L25*P25)+(V25*Y25))*(1+AD25)+AF25+AJ25,0)","v":0}]
[null,{"$f":"IF(AND(NOT(B25=0),NOT(G25=0)),CONCATENATE(\"matrix range: \",DOLLAR(VLOOKUP(F25,tblMatrixLow,K25+1,0),0),\" to \",DOLLAR(VLOOKUP(F25,tblMatrixHigh,K25+1,0),0)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(F25,tblMatrixMidpoint,K25+1,0)","v":0},null,null,{"$f":"IF(M26>0,\"= middle of range\",\"\")","v":""}]
[9,{"$f":"VLOOKUP(F27,tblAxes,2,0)","v":0},null,null,null,1,{"$f":"VLOOKUP(K27,tblAxes,2,0)","v":0},null,null,null,1,{"$f":"VLOOKUP(F27,tblMatrixMidpoint,K27+1,0)","v":0},null,null,null,null,null,null,null,{"$f":"VLOOKUP(U27,tblMulti,2,0)","v":0},1,{"$f":"L27*T27","v":0},null,null,null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,{"$f":"IF((P27+Y27)>0,((L27*P27)+(V27*Y27))*(1+AD27)+AF27+AJ27,0)","v":0}]
[null,{"$f":"IF(AND(NOT(B27=0),NOT(G27=0)),CONCATENATE(\"matrix range: \",DOLLAR(VLOOKUP(F27,tblMatrixLow,K27+1,0),0),\" to \",DOLLAR(VLOOKUP(F27,tblMatrixHigh,K27+1,0),0)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(F27,tblMatrixMidpoint,K27+1,0)","v":0},null,null,{"$f":"IF(M28>0,\"= middle of range\",\"\")","v":""}]
[null,{"$f":"'ELRA PENALTY SCHEDULE'!B30","v":"Additional Comments:"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Economic benefit not associated with a specific violation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,{"$f":"'ELRA PENALTY SCHEDULE'!B31","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AY40>(P40+W40)*10000,\"Penalty plus economic benefit and adjustments exceeds $10,000 per violation. Maximum additional economic benefit exceeded by $\"&AY40-(P40+W40)*10000&\".\",\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SUB-TOTAL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AN11:AQ29)","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,"Enter the costs and expenses of\ninvestigating the violation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,"Minimum enforcement case range: $100 to $500"]
[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,null,null,null,null,null,null,"Average enforcement case range: $500 to $1,000"]
[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,null,null,null,null,null,null,"Complex enforcement case range: $1,000 to $5,000"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AN31+AN33","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,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":"'ELRA PENALTY SCHEDULE'!BJ40","v":"Penalty Computation Worksheet"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P11+P13+P15+P17+P19+P21+P23+P25+P27","v":0},null,null,null,null,null,null,{"$f":"Y11+Y13+Y15+Y17+Y19+Y21+Y23+Y25+Y27","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,{"$f":"AN11+AN13+AN15+AN17+AN19+AN21+AN23+AN25+AN27+AN29","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,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":"'ELRA PENALTY SCHEDULE'!BJ41","v":"Revised 07-01-2020"},{"$f":"BL36","v":0}]

{"sheet":"SIGNATURE PAGE","index":2,"n_rows":51,"n_cols":10,"rows_kept":51,"cut":false,"hidden":false,"merged":[[50,0,50,2],[0,0,0,2],[1,0,1,2],[14,7,20,8],[34,0,34,6],[27,0,33,6],[45,0,45,6],[38,0,44,6],[21,0,21,6],[22,0,22,6],[14,0,20,6],[0,3,0,7],[1,3,1,7],[3,0,3,9],[0,9,0,12],[1,9,1,12],[21,9,21,11],[14,9,20,11],[49,0,49,2],[34,9,34,11],[27,9,33,11],[45,9,45,11],[38,9,44,11],[5,0,11,6],[5,7,11,8],[5,9,11,11],[12,0,12,6],[12,9,12,11]]}
["Air Pollution Violations",null,null,{"$f":"'ELRA PENALTY SCHEDULE'!I1","v":0},null,null,null,null,{"$f":"'ELRA PENALTY SCHEDULE'!$AK$1","v":0},{"$f":"'ELRA PENALTY SCHEDULE'!$AO$1","v":0}]
["Penalty Computation Worksheet",null,null,"Respondent(s)",null,null,null,null,"ARMS ID","Site Name or Address"]
[]
["Note: For electronic signatures, must convert sheet to a PDF file and use Adobe Acrobat e-signature.  "]
[]
[]
[]
[]
[]
[]
[]
[]
["Assistant Director of District Management",null,null,null,null,null,null,null,null,"Date "]
[]
[]
[]
[]
[]
[]
[]
[]
["Director of District Management",null,null,null,null,null,null,null,null,"Date "]
["Division Director"]
["Peer reviewed by Division:",null,null,"Yes ",null,"No"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Deputy Secretary (if required by guidelines)",null,null,null,null,null,null,null,null,"Date "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["DEP Secretary (if required by guidelines)",null,null,null,null,null,null,null,null,"Date"]
[]
[]
[]
["Penalty Computation Worksheet"]
[{"$f":"'ELRA PENALTY SCHEDULE'!BJ41","v":"Revised 07-01-2020"}]

{"sheet":"data","index":3,"n_rows":64,"n_cols":7,"rows_kept":64,"cut":false,"hidden":true,"merged":[]}
["tblElraRows"]
["Value","Selection","Penalty","Citation"]
[1," "]
[2,"Air-emission-permit exceedance\n   Add on's: \n                   $4500 if major for pollutant in violation\n                   $1500 if more than 150% of allowable",1500,"403.121(3)(f)",null,"tattat00"]
[3,"Unpermitted / unauthorized air emission\n   Add on's:  \n                   $4500 if major for pollutant in violation\n                   $1500 if more than 150% of allowable",1500,"403.121(3)(f)"]
[4,"Failure to install, maintain, or use a required pollution control system or device",6000,"403.121(4)(b)"]
[5,"Failure to obtain a required permit before construction or modification",4500,"403.121(4)(c)"]
[6,"Failure to conduct required monitoring or testing",3000,"403.121(4)(d)"]
[7,"Failure to construct in compliance with a permit",3000,"403.121(4)(d)"]
[8,"Failure to maintain required staff to respond to emergencies",1500,"403.121(4)(e)"]
[9,"Failure to conduct required training",1500,"403.121(4)(e)"]
[10,"Failure to prepare, maintain, or update required contingency plans",1500,"403.121(4)(e)"]
[11,"Failure to adequately respond to emergencies to bring an emergency situation under control",1500,"403.121(4)(e)"]
[12,"Failure to submit required notification to the department",1500,"403.121(4)(e)"]
[13,"Failure to prepare, submit, maintain, or use required reports or other required documentation",750,"403.121(4)(f)"]
[14,"Failure to comply with any other departmental regulatory statute or rule requirement...",1000,"403.121(5)"]
["tblCosts",null,null,null,null,"tblMulti"]
["Value","Selection",null,null,null,"Value","Selection"]
[1,null,null,null,null,1,0]
[2,"Minimal enforcement case ($100* to $500)",null,null,null,2,0.01]
[3,"Minimal enforcement case ($100 to $500)",null,null,null,3,0.05]
[4,"Minimal enforcement case ($100 to $500*)",null,null,null,4,0.1]
[5,"Average enforcement case ($500* to $1000)",null,null,null,5,0.25]
[6,"Average enforcement case ($500 to $1000)",null,null,null,6,0.5]
[7,"Average enforcement case ($500 to $1000*)"]
[8,"Complex enforcement case ($1000* to $5000)"]
[9,"Complex enforcement case ($1000 to $5000)"]
[10,"Complex enforcement case ($1000 to $5000*)"]
[11,"Exact cost method (with specific documenation)"]
[]
[]
["tblAxes"]
["Value","Selection"]
[1]
[2,"Minor"]
[3,"Moderate"]
[4,"Major"]
[]
[]
["tblMatrixMidpoint"]
["(harm)",null,null,"(deviation)"]
["Value","Column 1","Column 2","Column 3","Column 4"]
[1]
[2,null,1000,1500,2500]
[3,null,4000,6000,8000]
[4,null,10000,12000,14000]
[]
[]
["tblMatrixHigh"]
["(harm)",null,null,"(deviation)"]
["Value","Column 1","Column 2","Column 3","Column 4"]
[1]
[2,null,1000,1999,2999]
[3,null,4999,6999,8999]
[4,null,10999,12999,15000]
[]
[]
["tblMatrixLow"]
["(harm)",null,null,"(deviation)"]
["Value","Column 1","Column 2","Column 3","Column 4"]
[1]
[2,null,1000,1000,2000]
[3,null,3000,5000,7000]
[4,null,9000,11000,13000]

{"sheet":"Scratch Pad","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}