{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["IDL"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":240,"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":"IDL","index":0,"n_rows":475,"n_cols":42,"rows_kept":475,"cut":false,"hidden":false,"merged":[[0,9,0,10]]}
["CALIFORNIA STATE CONTROLLER'S OFFICE IDL SUPPLEMENTATION CALCULATOR - 2024",null,null,null,null,null,null,null,null,"COMPUTED FIELDS",null,null,null,null,null,null,null,"Look up Retire Data",null,null,null,"SS %","MED %","SDI %",null,null,null,null,null,null,null,null,null,"FEDERAL INCOME TAX EXEMPTION",null,null,null,null,"STATE INCOME TAX"]
["Salary Information",null,null,null,null,null,"EFF. 7/1/2024",null,null,"Gross Net",{"$f":"ROUND(SUM(K3:K5),2)","v":0},null,"Regular Pay",null,null,null,null,"SS/Med",{"$f":"VLOOKUP(RETIREMENT_ID,RETID_TABLE,4,FALSE)","v":"SS"},"MED%",{"$f":"IF(OR(S2=\"MED\",S2=\"SS\"),MD_,0)","v":1.4500000000000001E-2},6.2E-2,1.4500000000000001E-2,1.0999999999999999E-2,null,null,null,null,null,null,null,null,null,4300,null,null,null,null,"ADDITIONAL ALLOWANCES"]
["Original Salary Rate",4000,"Reduced Sal Rate",null,null,"Salary Per","M","(M or H)",null,"Reg Net",{"$f":"ROUND(IF(Salary_Per=\"H\",REDUCED_SALARY*HOURS_OF_REGULAR_PAY,(REDUCED_SALARY/PAYPERIOD_HOURS)*HOURS_OF_REGULAR_PAY),2)","v":0},null,{"$f":"REG_PAY_WITHHOLDING","v":0},"Ret. Withholding",null,null,null,"Exl amt",{"$f":"IF(OR(PayFreq=\"M\", PayFreq=\"S\"),VLOOKUP(RETIREMENT_ID,RETID_TABLE,3,FALSE),(VLOOKUP(RETIREMENT_ID,RETID_TABLE,3,FALSE)*12)/26)","v":513},"MED",{"$f":"ROUND(Gross_Net_OPEB*MED_,2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1000]
["Collective Bargaining Unit","R01","(R01-R021, U)",null,null,null,null,null,null,"IDL Full",{"$f":"ROUND(IF(Salary_Per=\"H\",Salary_Rate*HOURS_IDL_FULL,(SALARY/PAYPERIOD_HOURS)*HOURS_IDL_FULL),2)","v":0},null,{"$f":"ROUND(Reg_Net_Grs_OPEB*OASDI_,2)","v":0},"SS",null,null,null,"Percent",{"$f":"VLOOKUP(RETIREMENT_ID,RETID_TABLE,2,FALSE)","v":0.08},"SS%",{"$f":"IF(S2=\"SS\",OA_,0)","v":6.2E-2}," "," ",null,null,"RETID_TABLE",null,null,null,null,"OPEB_TABLE",null,null,null,"SINGLE"]
["OPEB CBID","R01",null,null,null,null,null,null,null,"IDL 2/3",{"$f":"(ROUND(IF(Salary_Per=\"H\",Salary_Rate*HOURS_IDL_23,(SALARY/PAYPERIOD_HOURS)*HOURS_IDL_23),2))","v":0},null,{"$f":"ROUND(Reg_Net_Grs_OPEB*MED_,2)","v":0},"Med",null,null,null,null,null,"SS",{"$f":"ROUND(Gross_Net_OPEB*OASDI_,2)","v":0},null,null,null,null,"AC","EE Rate","Excl.","SS/Med",null,"OPEB CBID","EE Rate",null,"BASE AMT","PERCENT","BASE TAX",null,"          LOW INCOME TAX EXEMPTION"]
["Pay Frequency (M, S, or B)","M","Pay Period Days",22,null,"(21/22)",null,null,null,"PP Hours",{"$f":"IF(ISBLANK(Time_Base_Fraction),PAYPERIOD_DAYS*8,PAYPERIOD_DAYS*8*TIMEBASE)","v":176},null,{"$f":"IF(SDI=\"yes\",Reg_Net_Grs_OPEB*X2,0)","v":0},"SDI",null,null,null,null,null,"OPEB Rate",{"$f":"VLOOKUP(OPEB_AC,OPEB_TABLE,2,FALSE)","v":0.03},null,null,null,null,"00",0.06,317,"NO"," ","C01",0.03,null,-999999,0,0,null,null," --- MARRIED ---",null,"HEAD OF"]
["Time Base Fraction",null,"Locked-in Pay Not",null,"Subj to Retirement",null,null,null,null,"Org Hr Rate",{"$f":"IF(Salary_Per=\"H\",ROUND(Salary_Rate,5),ROUND(SALARY/PAYPERIOD_HOURS,5))","v":22.727270000000001},null,{"$f":"ROUND(REG_PAY_SUBJ_RETIREMENT*OPEB_rate,2)","v":0},"Reg. OPEB",null,null,null,null,null,"OPEB Amt",{"$f":"Reg_OPEB+IDL_OPEB+IDL_23_OPEB","v":0},null,null,null,null,"01",3.7499999999999999E-2,0,"NO"," ","C02",1.4E-2,null,6000,0.1,0,null,"SINGLE","0 or 1","2 or more","HOUSEHOLD"]
["Retirement/SDI Information",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"02",0,0,"NO"," ","C03",0.03,null,17600,0.12,1160,null,17769,17769,35538,35538]
["Retirement ID","45","Pay Period",7,"/",23,null,null,null,"Gross Net - OPEB",{"$f":"ROUND(SUM(K10:K12),2)","v":0},null,"IDL Full",null,null,null,null,"Supplementation Data",null,null,null,null,null,null,null,"03",3.7499999999999999E-2,0,"SS"," ","C04",0.03,null,53150,0.22,5426]
["Apply Exclusion Amt ",null,"(Yes, No, Blank)","(MM)",null,"(YY)",null,null,null,"Reg Net - OPEB",{"$f":"ROUND(IF(Salary_Per=\"H\",REDUCED_SALARY*HOURS_OF_REGULAR_PAY,(REDUCED_SALARY/PAYPERIOD_HOURS)*HOURS_OF_REGULAR_PAY),2)-Reg_OPEB","v":0},null,{"$f":"IDL_FULL_PAY_WITHHOLDING","v":0},"Ret. Withholding",null,null,null,null,null,null,null,null,null,null,null,"04",3.7499999999999999E-2,0,"SS"," ","C05",3.4000000000000002E-2,null,106525,0.24,17168.5,null,"       STANDARD DEDUCTION TABLE"]
["(for Semimonthly only)",null,null,null,null,null,null,null,null,"IDL Full - OPEB",{"$f":"ROUND(IF(Salary_Per=\"H\",Salary_Rate*HOURS_IDL_FULL,(SALARY/PAYPERIOD_HOURS)*HOURS_IDL_FULL),2)-IDL_OPEB","v":0},null,{"$f":"IF(IDL_Full_OPEB=0,0,ROUND(M23-Reg_SS,2))","v":0},"SS",null,null,null,"Sup Full",{"$f":"Supple_Gross_Net/Divided_By","v":0},null,null,null,null,null,null,"05",9.5000000000000001E-2,513,"SS"," ","C06",0.04,null,197950,0.32,39110.5,null,null," --- MARRIED ---",null,"HEAD OF"]
["SDI",{"$f":"IF(LEFT(CBID,1)=\"R\",VLOOKUP(CBID,SDI_CBID,2),\"NO\")","v":"YES"},null,null,null,null,null,null,null,"IDL 2/3 - OPEB",{"$f":"(ROUND(IF(Salary_Per=\"H\",Salary_Rate*HOURS_IDL_23,(SALARY/PAYPERIOD_HOURS)*HOURS_IDL_23),2))-IDL_23_OPEB","v":0},null,{"$f":"IF(IDL_Full_OPEB=0,0,ROUND(M24-Reg_Med,2))","v":0},"Med",null,null,null,"Hours",{"$f":"ROUND(Grs_Full_Supple/Org_Hr_Rate,0)","v":0},null,null,null,null,null,null,"06",0.01,317,"MED"," ","C07",0.04,null,249725,0.35,55678.5,null,"SINGLE","0 or 1","2 or more","HOUSEHOLD"]
["Federal/State Tax Information",null,null,{"$f":"LEFT(X7,10)","v":""},{"$f":"Y7","v":0},null,null,null,null,null,null,null,{"$f":"IF(IDL_Full_OPEB=0,0,ROUND(M25-FTAX2,2))","v":0},"Fed",null,null,null,"Days",{"$f":"IF(Salary_Per=\"H\",0,ROUNDDOWN(S12/Time_Base_Hrs,0))","v":0},null,null,null,null,null,null,"07",0.125,513,"SS"," ","C08",3.9E-2,null,615350,0.37,183647.25,null,5363,5363,10726,10726]
["Federal Filing Status","M","Fed Exemptions",0,"(M, S) (1-99)",null,null,null,null,null,null,null,{"$f":"IF(IDL_Full_OPEB=0,0,ROUND(M26-STAX2,2))","v":0},"State",null,null,null,"Hours",{"$f":"IF(Salary_Per=\"H\",S12,S12-(S13*Time_Base_Hrs))","v":0},null,null,null,null,null,null,"08",0.05,513,"SS"," ","C09",0.02]
["Federal HW",null,"Fed Claim Deps",null,null,null,null,null,null,null,null,null,{"$f":"IF(IDL_Full_OPEB=0,0,ROUND(M27-Reg_SDI,2))","v":0},"SDI",null,null,null,null,null,null,null,null,null,null,null,"09",0.08,513,"SS"," ","C10",2.1000000000000001E-2,null,null,null,null,null," ------- SINGLE --------"]
["Federal Other Income",null,"Fed Deductions",null,null,null,null,null,null,null,null,null,{"$f":"SUM(M11:M15)","v":0},"Total",null,null,null,null,null,null,"EMPCR%",{"$f":"VLOOKUP(CBID,U17:V40,2,FALSE)","v":0},null,null,null,"0A",8.5000000000000006E-2,513,"SS"," ","C11",0.03,null," ","MARRIED",null,null,"BASE AMT","PERCENT","BASE TAX"]
["State Marital Status","M","Reg Allowances",0,"(M, S, H) (1-99)",null,null," ",null,null,null,null,{"$f":"IF(IDL_Full=0,0,ROUND(IDL_Full-M16,2))","v":0},"IDL Full Grs",null,null,null,null,null,null,"R01",0,null,null,null,"0B",8.5000000000000006E-2,513,"SS"," ","C12",3.5999999999999997E-2,null,"BASE AMT","PERCENT","BASE TAX",null,0,1.0999999999999999E-2,0]
["Additional State Allowances (1-99)",null,"Iss Mon and Yr",8,1,23,"(1-99)",null,null,"Reg Time",{"$f":"(Reg_Days*Time_Base_Hrs)+Reg_Hrs","v":0},null,{"$f":"ROUND(IDL_FULL_PAY*OPEB_rate,2)","v":0},"IDL OPEB",null,null,null,null,null,null,"R02",0,null,null,null,"0C",8.5000000000000006E-2,513,"SS"," ","C13",3.5000000000000003E-2,null,-999999,0,0,null,10412,2.1999999999999999E-2,114.53]
[null,null,null,"(MM)",null,"(YY)",null,null,null,"IDL F Time",{"$f":"(IDL_Full_Days*Time_Base_Hrs)+IDL_Full_Hrs","v":0},null,null,null,null,null,null,null,null,null,"R03",0,null,null,null,"0D",8.7499999999999994E-2,513,"SS"," ","C14",0.03,null,16300,0.1,0,null,24684,4.3999999999999997E-2,428.51]
["Time for","Days","Hours",null,null,null,null,null,null,"IDL 2/3 Time",{"$f":"(IDL_23_Days*Time_Base_Hrs)+IDL_23_Hrs","v":0},null,"IDL 2/3",null,null,null,null,null,null,null,"R04",0,null,null,null,"0E",8.5000000000000006E-2,513,"SS"," ","C15",0.03,null,39500,0.12,2320,null,38959,6.6000000000000003E-2,1056.6099999999999]
["Regular Pay",null,null,null,null,null,null,null,null,"Total Time",{"$f":"HOURS_OF_REGULAR_PAY+HOURS_IDL_FULL+HOURS_IDL_23","v":0},null,{"$f":"IDL_23_PAY_WITHHOLDING","v":0},"Ret. Withholding",null,null,null,null,null,null,"R05",0,null,null,null,"0F",8.5000000000000006E-2,513,"SS"," ","C16",1.4E-2,null,110600,0.22,10852,null,54081,8.7999999999999995E-2,2054.66]
["IDL Full Pay",null,null,null,null,null,null,null,null,"EPMC%",{"$f":"+S4+V16","v":0.08},null,{"$f":"IF(IDL_Full=0,0,REG_RETIREMENT_WH+IDL_FULL_RETIREMENT_WH)","v":0},"EPMC Reg+IDL F",null,null,null,null,null,null,"R06",0,null,null,null,"0G",8.5000000000000006E-2,513,"SS"," ","C17",0.03,null,217350,0.24,34337,null,68350,0.1023,3310.33]
["IDL 2/3 Pay",null,null,null,null,null,null,null,null,"EPMC",{"$f":"ROUND(REG_RETIREMENT_WH+IDL_FULL_RETIREMENT_WH+IDL_23_RETIREMENT_WH,2)","v":0},null,{"$f":"IF(IDL_Full=0,0,ROUND((Reg_Net_Grs_OPEB+IDL_Full_OPEB)*OASDI_,2))","v":0},"SS Reg+IDL F",null,null,null,null,null,null,"R07",0,null,null,null,"0H",8.5000000000000006E-2,513,"SS"," ","C18",4.4999999999999998E-2,null,400200,0.32,78221,null,349137,0.1133,32034.84]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(IDL_Full=0,0,ROUND((Reg_Net_Grs_OPEB+IDL_Full_OPEB)*MED_,2))","v":0},"Med Reg+IDL F",null,null,null,null,null,null,"R08",0,null,null,null,"10",0.06,317,"NO"," ","C19",0.03,null,503750,0.35,111357,null,418961,0.12429999999999999,39945.9]
[null,"Full Net","Regular","IDL Full",null,"IDL 2/3",null,null,null,null,null,null,{"$f":"FTAX3","v":0},"Fed Reg+IDL F",null,null,null,null,null,null,"R09",0,null,null,null,"11",0.01,317,"NO"," ","C20",0.03,null,747500,0.37,196669.5,null,698271,0.1353,74664.13]
["Gross",{"$f":"Gross_Net","v":0},{"$f":"Reg_Net_Grs","v":0},{"$f":"IDL_Grs","v":0},null,{"$f":"IDL_23_Grs","v":0},null,null,null,"SDI1",{"$f":"IF(SDI=\"Yes\",SDIGRS*X2,0)","v":0},null,{"$f":"STAX3","v":0},"State Reg+IDL F",null,null,null,"SDI CBID",null,null,"R10",0,null,null,null,"12",0.06,317,"MED"," ","C21",0.03,null,null,null,null,null,1000000,0.14630000000000001,115488.06]
["Retirement",{"$f":"EPMC","v":0},{"$f":"REG_RETIREMENT_WH","v":0},{"$f":"IDL_FULL_RETIREMENT_WH","v":0},null,{"$f":"IDL_23_RETIREMENT_WH","v":0},null,null,null,"SDIGRS",{"$f":"Gross_Net_OPEB","v":0},null,{"$f":"IF(OR(IDL_Full=0,SDI=\"NO\"),0,(ROUND((Reg_Net_Grs_OPEB+IDL_Full_OPEB)*X2,2)))","v":0},"SDI Reg+IDL F",null,null,null,"R01","YES",null,"R11",0,null,null,null,"13",3.7499999999999999E-2,0,"MED"," ","E01",0.03,null,null,null,null,null,9999999,0.14630000000000001,115488.06]
["OPEB",{"$f":"OPEB_amt","v":0},{"$f":"Reg_OPEB","v":0},{"$f":"IDL_OPEB","v":0},null,{"$f":"IDL_23_OPEB","v":0},null,null,null,null,null,null,{"$f":"ROUND((IDL_2_3/3)*2,2)","v":0},"IDL 2/3 Grs",null,null,null,"R02","NO",null,"R12",0,null,null,null,"14",0,0,"NO"," ","E02",1.4E-2,null,null,"HEAD OF HOUSEHOLD"]
["Social Security",{"$f":"OASDI","v":0},{"$f":"Reg_SS","v":0},null,null,null,null,null,null,"PP Days",{"$f":"IF(Days_in_Pay_Period=22,22,21)","v":22},null,{"$f":"ROUND(IDL_23_PAY*OPEB_rate,2)","v":0},"IDL 2/3 OPEB",null,null,null,"R03","YES",null,"R13",0,null,null,null,"15",0.06,238,"NO"," ","E03",0.03,null,"BASE AMT","PERCENT","BASE TAX",null," ------- MARRIED --------"]
["Medicare",{"$f":"MED","v":0},{"$f":"Reg_Med","v":0},null,null,null,null,null,null,"Timebase",{"$f":"IF(ISBLANK(Time_Base_Fraction),1,Time_Base_Fraction)","v":1},null,null,null,null,null,null,"R04","YES",null,"R14",0,null,null,null,"16",0.06,238,"MED"," ","E04",0.03,null,-999999,0,0,null,"BASE AMT","PERCENT","BASE TAX"]
["Federal Tax",{"$f":"FTAX1","v":0},{"$f":"FTAX2","v":0},null,null,null,null,null,null,"Time Base Hrs",{"$f":"IF(ISBLANK(Time_Base_Fraction),8,8*Time_Base_Fraction)","v":8},null,"Regular Pay",{"$f":"ROUND(IF(Salary_Per=\"H\",REDUCED_SALARY*HOURS_OF_REGULAR_PAY,(REDUCED_SALARY/PAYPERIOD_HOURS)*HOURS_OF_REGULAR_PAY),2)","v":0},null,null,null,"R05","NO",null,"R15",0,null,null,null,"17",0.06,317,"MED"," ","E05",3.4000000000000002E-2,null,13300,0.1,0,null,0,1.0999999999999999E-2,0]
["State Tax",{"$f":"STAX1","v":0},{"$f":"STAX2","v":0},null,null,null,null,null,null,"Salary",{"$f":"IF(Salary_Per=\"H\",Salary_Rate,Salary_Rate*TIMEBASE)","v":4000},null,"Reg. Pay Subj. to Ret.",{"$f":"IF(Salary_Per=\"H\",RED_SAL_NOT_LOCKED*HOURS_OF_REGULAR_PAY,ROUND((RED_SAL_NOT_LOCKED/PAYPERIOD_HOURS),5)*HOURS_OF_REGULAR_PAY)","v":0},null,null,null,"R06","NO",null,"R16",0,null,null,null,"18",0.06,317,"NO"," ","E06",0.04,null,29850,0.12,1655,null,20824,2.1999999999999999E-2,229.06]
["SDI Withheld",{"$f":"_SDI1","v":0},{"$f":"Reg_SDI","v":0},null,null,null,null,null,null,"Reduced Salary",{"$f":"IF(HAS_REDUCED_SALARY=FALSE,SALARY,ROUND(Red_Sal_Rate*TIMEBASE,2))","v":4000},null,"Reg. Pay Exclusion",{"$f":"IF(REG_PAY_SUBJ_RETIREMENT>EXCLUSION,EXCLUSION,REG_PAY_SUBJ_RETIREMENT)","v":0},null,null,null,"R07","NO",null,"R17",0,null,null,null,"19",0.11,317,"MED"," ","E07",0.04,null,76400,0.22,7241,null,49368,4.3999999999999997E-2,857.03]
["Gross Net",{"$f":"ROUND(B26-(ROUND(SUM(B27:B33),2)),2)","v":0},{"$f":"ROUND(C26-(SUM(C27:C33)),2)","v":0},{"$f":"ROUND(D26-D27-D28,2)","v":0},null,{"$f":"ROUND(F26-F27-F28,2)","v":0},null,null,null,"Red. Sal. Not Locked",{"$f":"REDUCED_SALARY-Locked_in_Pay","v":4000},null,"Reg. Pay Withholding",{"$f":"IF(REG_PAY_SUBJ_RETIREMENT>EXCLUSION,(REG_PAY_SUBJ_RETIREMENT-EXCLUSION)*EPMC_P,0)","v":0},null,null,null,"R08","NO",null,"R18",0,null,null,null,"1A",7.0000000000000007E-2,317,"NO",null,"E08",3.9E-2,null,113800,0.24,15469,null,77918,6.6000000000000003E-2,2113.23]
["Hourly Rate Used for Calc:",{"$f":"Org_Hr_Rate","v":22.727270000000001},null,null,null,null,null,null,null,"Retirement Sal Rate",{"$f":"SALARY-Locked_in_Pay","v":4000},null,"Reg. Pay Exclusion Remaining",{"$f":"EXCLUSION-REG_PAY_EXCLUSION","v":513},null,null,null,"R09","NO",null,"R19",0,null,null,null,"1B",0.11,317,"NO",null,"E09",0.02,null,205250,0.32,37417,null,108162,8.7999999999999995E-2,4109.33]
["Supplementation Gross Net:",{"$f":"IF(ROUND(Full_Net-(SUM(C34:F34)),2)<0,0,ROUND(Full_Net-(SUM(C34:F34)),2))","v":0},"Divided By",{"$f":"Withhold_Factor","v":0.63749999999999996},null,"=",{"$f":"ROUND(Supple_Gross_Net/Divided_By,2)","v":0},null,null,"Total Exclusion",{"$f":"IF(APPLY_EXCLUSION=TRUE,RET_EXCLUSION_AMT,0)","v":513},null,null,null,null,null,null,"R10","NO",null,"R20",0,null,null,null,"1C",0.11,317,"MED",null,"E10",2.1000000000000001E-2,null,257000,0.35,53977,null,136700,0.1023,6620.67]
["Gross for Full Supplementation:",{"$f":"S11","v":0},null,null,null,null,null,null,null,"Apply Exclusion?",{"$f":"IF(OR(PayFreq<>\"S\",LEFT(Ret_SM_Exl_Apply,1)=\"Y\"),TRUE, FALSE)","v":true},null,"IDL Full Pay",{"$f":"IF(Salary_Per=\"H\",RETIREMENT_SALARY_RATE*HOURS_IDL_FULL,RETIREMENT_SALARY_RATE/PAYPERIOD_HOURS*HOURS_IDL_FULL)","v":0},null,null,null,"R11","YES",null,"R21",0,null,null,null,"1D",0.11,317,"MED",null,"E11",0.03,null,622650,0.37,181954.5,null,698274,0.1133,64069.69]
["Leave Credit Hours Required for Full Supplementation:",null,null,{"$f":"S12","v":0},null,null,null,null,null,"Reduced Salary?",{"$f":"IF(OR(ISBLANK(Red_Sal_Rate),Red_Sal_Rate<=0),FALSE, TRUE)","v":false},null,"IDL Full Pay Exclusion",{"$f":"IF(IDL_FULL_PAY>N35,N35,IDL_FULL_PAY)","v":0},null,null,null,"R12","NO",null,"C",0,null,null,null,"1E",0.11,317,"NO",null,"E12",3.5999999999999997E-2,null,null,null,null,null,837922,0.12429999999999999,79891.81]
["Days:",{"$f":"S13","v":0},"Hours:",{"$f":"S14","v":0},null,null,null,null,null,null,null,null,"IDL Full Pay Withhold.",{"$f":"IF(IDL_FULL_PAY>IDL_FULL_PAY_EXCLUSION,(IDL_FULL_PAY-IDL_FULL_PAY_EXCLUSION)*EPMC_P,0)","v":0},null,null,null,"R13","NO",null,"SD",0,null,null,null,"1F",0.11,317,"MED",null,"E13",3.5000000000000003E-2,null,null,"SINGLE HIGH WAGE",null,null,1000000,0.1353,100038.11]
[null,null,null,null,null,null,null,"rev. 7/16/24",null,null,null,null,"IDL Full Pay Exclusion Remain.",{"$f":"N35-IDL_FULL_PAY_EXCLUSION","v":513},null,null,null,"R14","YES",null,"U",0,null,null,null,"1G",0.11,317,"NO",null,"E14",0.03,null,"BASE AMT","PERCENT","BASE TAX",null,1396542,0.14630000000000001,153690.23999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"R15","YES",null,null,null,null,null,null,"1H",0.11,317,"NO",null,"E15",0.03,null,-999999,0,0,null,9999999,0.14630000000000001,153690.23999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,"IDL 2/3 Pay",{"$f":"IF(Salary_Per=\"H\",RETIREMENT_SALARY_RATE*HOURS_IDL_23,RETIREMENT_SALARY_RATE/PAYPERIOD_HOURS*HOURS_IDL_23)","v":0},null,null,null,"R16","NO",null,null,null,null,null,null,"1J",0.11,317,"MED",null,"E16",1.4E-2,null,7300,0.1,0]
[null,null,"GENERAL INSTRUCTIONS",null,null,null,null,null,null,null,null,null,"IDL 2/3 Pay Exclusion",{"$f":"IF(IDL_23_PAY>N40,N40,IDL_23_PAY)","v":0},null,null,null,"R17","YES",null,null,null,null,null,null,"1K",0.11,317,"MED",null,"E17",0.03,null,13100,0.12,580,null,"UNMARRIED HEAD OF HOUSEHOLD"]
[null,null,null,null,null,null,null,null,null,null,null,null,"IDL 2/3 Pay Withhold.",{"$f":"IF(IDL_23_PAY>IDL_23_PAY_EXCLUSION,(IDL_23_PAY-IDL_23_PAY_EXCLUSION)*EPMC_P,0)","v":0},null,null,null,"R18","NO",null,null,null,null,null,null,"1L",0.11,317,"NO",null,"E18",4.4999999999999998E-2,null,30875,0.22,2713,null,"BASE AMT","PERCENT","BASE TAX"]
["This spreadsheet can be used to calculate the Industrial Disability Leave Supplementation (IDL/S) for",null,null,null,null,null,null,null,null,null,null,null,"IDL 2/3 Pay Exclusion Remain.",{"$f":"N40-IDL_23_PAY_EXCLUSION","v":513},null,null,null,"R19","NO",null,null,null,null,null,null,"1M",0.105,0,"MED",null,"E19",0.03,null,57563,0.24,8584.25,null,0,1.0999999999999999E-2,0]
["Civil Service employees paid monthly or semi-monthly for a specific tax year. All fields are LOCKED",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"R20","YES",null,null,null,null,null,null,"1P",0.11,317,"MED",null,"E20",0.03,null,103275,0.32,19555.25,null,20839,2.1999999999999999E-2,229.23]
["except input fields. User either the keyboard \"TAB\" button or \"ARROWS\" buttons to move between",null,null,null,null,null,null,null,null,"Tax Eff 1/1/18",null,null,null,null,null,null,null,"R21","YES",null,null,null,null,null,null,"1Q",0.105,317,"NO",null,"E21",0.03,null,129163,0.35,27839.25,null,49371,4.3999999999999997E-2,856.93]
["input fields.",null,null,null,null,null,null,null,null,"TXGRS1",{"$f":"ROUND(Gross_Net_OPEB-EPMC,2)","v":0},"<Gross",null,null,null,null,null,null,null,null,null,null,null,null,null,"1R",0.11,317,"NO",null,"E48",2.4E-2,null,311975,0.37,91823.63,null,63644,6.6000000000000003E-2,1484.94]
[null,null,null,null,null,null,null,null,null,"TXGRS2",{"$f":"(Reg_Net_Grs_OPEB-REG_RETIREMENT_WH)","v":0},"<Reg Grs",null,null,null,null,null,null,"Mandatory Withhold Factor",null,null,null,null,null,null,"1S",0.11,317,"MED",null,"E50",2.4E-2,null,null,null,null,null,78765,8.7999999999999995E-2,2482.9299999999998]
["Specific entry instructions:",null,null,null,null,null,null,null,null,"TXGRS3",{"$f":"(Reg_Net_Grs_OPEB+IDL_Full_OPEB)-M22","v":0},"<Reg+IDL Grs",null,null,null,null,null,null,null,{"$f":"SUMPRODUCT((R52:R63=S2)*(S52:S63=Fed_Exempt)*(T52:T63=State_Exempt)*(U52:U63))","v":0.63749999999999996},null,null,null,null,null,"1T",0.11,317,"NO",null,"E58",2.4E-2,null,null,null,null,null,93037,0.1023,3738.87]
[null,null,null,null,null,null,null,null,null,"TXGRS4",{"$f":"Salary_Rate","v":4000},"<Not in use",null,null,null,null,null,"SS/MED","Fed Exempt","State Exempt","Factor",null,null,null,null,"1U",0.06,317,"MED",null,"E59",2.4E-2,null," ","MARRIED",null,null,474824,0.1133,42795.68]
["Salary Rate: Enter the Employee's salary rate in effect for the pay period to be paid. The salary rate should",null,null,null,null,null,null,null,null,"TXGRS5",{"$f":"Salary_Rate","v":4000},"<Not in use",null,null,null,null,"SS/Med","SS",false,false,0.63749999999999996,null,null,null,null,"1V",0.11,317,"MED",null,"E67",2.4E-2,null,"BASE AMT","PERCENT","BASE TAX",null,569790,0.12429999999999999,53555.33]
["reflect any locked-in premiums or shift differential pay that can be included in the IDL calculations.",null,null,null,null,null,null,null,null,"TXGRS6",{"$f":"Salary_Rate","v":4000},"<Not in use",null,null,null,null,"Med only","MED",false,false,0.69950000000000001,null,null,null,null,"1W",0.11,317,"NO",null,"E68",2.4E-2,null,-999999,0,0,null,949649,0.1353,100771.8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Neither","NO",false,false,0.71399999999999997,null,null,null,null,"1X",0.11,317,"MED",null,"E77",2.4E-2,null,14600,0.1,0,null,1000000,0.14630000000000001,107584.29]
["For positive employees, enter the hourly salary rate.",null,null,null,null,null,null,null,null,"      FEDERAL TAX",null,null,null,null,null,null,"SS/Med","SS",true,true,0.92349999999999999,null,null,null,null,"1Y",0.13500000000000001,317,"NO",null,"E78",2.4E-2,null,26200,0.12,1160,null,9999999,0.14630000000000001,107584.29]
["For negative employees, enter the monthly salary rate. For BU18 employees enter the monthly salary.",null,null,null,null,null,null,null,null,"PAYFACT",{"$f":"IF(PayFreq=\"M\",12,IF(PayFreq=\"S\",24,IF(PayFreq=\"B\",26,0)))","v":12},null,{"$f":"IF(AND(FedHW=\"Y\",FEDM=\"M\"),\"A\",IF(AND(FedHW=\"Y\",FEDM=\"S\"),\"I\",IF(AND(FedHW=\"Y\",FEDM=\"H\"),\"E\",FEDM)))","v":"M"},null,null,null,"Med only","MED",true,true,0.98550000000000004,null,null,null,null,"1Z",0.13500000000000001,317,"MED",null,"E79",2.4E-2,null,61750,0.22,5426]
["For fractional employees, enter the full salary rate.",null,null,null,null,null,null,null,null,"FED EXM",{"$f":"IF(AND(FedHW=\"N\",FEDM=\"M\"),(FEDEXMPT1*3),IF(AND(FedHW=\"N\",FEDM<>\"M\"),(FEDEXMPT1*2),IF(FedHW=\"\",(FEDEXMPT1*FEDE),\"0\")))","v":0},null,null,null,null,null,"Neither","NO",true,true,1,null,null,null,null,"20",0.1,317,"MED",null,"E88",2.3E-2,null,115125,0.24,17168.5,null,"  --- TAX CREDIT TABLE ----"]
["Key a decimal to reflect cents.",null,null,null,null,null,null,null,null,"ANNUALIZED GROSS",null,null,null,null,null,null,"SS/Med","SS",false,true,0.70350000000000001,null,null,null,null,"21",0,0,"MED",null,"E89",2.3E-2,null,206550,0.32,39110.5,null,"MARITAL"," ------- NUMBER OF ALLOWANCES ----"]
[null,null,null,null,null,null,null,null,null,"FAN1",{"$f":"(PAYFACT*_TG1)","v":0},null,null,null,null,null,"Med only","MED",false,true,0.76549999999999996,null,null,null,null,"22",0,0,"MED",null,"E97",2.4E-2,null,258325,0.35,55678.5,null,"STATUS",0,1,2,"OVER 2"]
["Reduced Salary Rate: Enter the salary rate based on the furlough reductions.",null,null,null,null,null,null,null,null,"FAN2",{"$f":"ROUND(PAYFACT*_TG2,2)","v":0},null,null,null,null,null,"Neither","NO",false,true,0.78,null,null,null,null,"23",0.06,317,"MED",null,"E98",2.4E-2,null,380200,0.37,98334.75,null,"SINGLE",0,158.4,316.8,158.4]
[null,null,null,null,null,null,null,null,null,"FAN3",{"$f":"(PAYFACT*_TG3)","v":0},null,null,null,null,null,"SS/Med","SS",true,false,0.85750000000000004,null,null,null,null,"24",0.08,513,"SS",null,"E99",2.4E-2,null,null,null,null,null,"MAR/HEAD",0,158.4,316.8,158.4]
["Salary Per: Enter \"M\" if salary rate is monthly or \"H\" if salary rate is hourly.",null,null,null,null,null,null,null,null,"FAN4",{"$f":"(PAYFACT*_TG4)","v":48000},null,null,null,null,null,"Med only","MED",true,false,0.91949999999999998,null,null,null,null,"25",0.125,513,"SS",null,"M01",0.03,null,null,"HEAD OF HOUSEHOLD"]
[null,null,null,null,null,null,null,null,null,"FAN5",{"$f":"(PAYFACT*_TG5)","v":48000},null,null,null,null,null,"Neither","NO",true,false,0.93400000000000005,null,null,null,null,"27",0.08,513,"SS",null,"M02",1.4E-2,null,"BASE AMT","PERCENT","BASE TAX"]
["Collective Bargaining Unit: Using the employee's personnel information enter the first three digits",null,null,null,null,null,null,null,null,"FAN6",{"$f":"(PAYFACT*_TG6)","v":48000},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2A",0.11,317,"NO",null,"M03",0.03,null,-999999,0,0]
["of the employees' Collective Bargaining Identification designation (not the Pay Scales CBID) - example: R01,",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Exempt",null,null,null,null,null,null,null,"2B",0.11,317,"MED",null,"M04",0.03,null,10950,0.1,0]
["R02, R15, etc.). Exception: For Managers, Supervisors, Excluded and Confidential employee, enter \"U\".",null,null,null,null,null,null,null,null,"    TAXABLE GROSS",null,null,null,null,null,null,"Federal",{"$f":"IF(OR(FEDE=99,FEDM=\"E\"),TRUE,FALSE)","v":false},null,null,null,null,null,null,null,"2C",0.1,513,"SS",null,"M05",3.4000000000000002E-2,null,19225,0.12,827.5]
[null,null,null,null,null,null,null,null,null,"FTG1",{"$f":"MAX(IF(FedHW<>\"\",(_FAN1-FEDEXM-Fed_Deds+Fed_Oth_Inc),(_FAN1-FEDEXM)),0)","v":0},null,null,null,null,null,"State",{"$f":"IF(STE=99,TRUE,FALSE)","v":false},null,null,null,null,null,null,null,"2D",0.1,513,"SS",null,"M06",0.04,null,42500,0.22,3620.5]
["Pay Frequency: Enter \"M\" for monthly, \"S\" for semimonthly, or \"B\" for bi-weekly pay frequency.",null,null,null,null,null,null,null,null,"FTG2",{"$f":"MAX(IF(FedHW<>\"\",(K60-FEDEXM-Fed_Deds+Fed_Oth_Inc),(K60-FEDEXM)),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2E",9.5000000000000001E-2,513,"SS",null,"M07",0.04,null,61200,0.24,7734.5]
[null,null,null,null,null,null,null,null,null,"FTG3",{"$f":"MAX(IF(FedHW<>\"\",(K61-FEDEXM-Fed_Deds+Fed_Oth_Inc),(K61-FEDEXM)),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2F",0.1,513,"SS",null,"M08",3.9E-2,null,106925,0.32,18708.5]
["Pay Period Days: Enter total number of days in the pay period (21 or 22).",null,null,null,null,null,null,null,null,"FTG4",{"$f":"MAX(IF(FedHW<>\"\",(K62-FEDEXM-Fed_Deds+Fed_Oth_Inc),(K62-FEDEXM)),0)","v":48000},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2G",9.5000000000000001E-2,513,"SS",null,"M09",0.02,null,132800,0.35,26988.5]
[null,null,null,null,null,null,null,null,null,"FTG5",{"$f":"MAX(IF(FedHW<>\"\",(K63-FEDEXM-Fed_Deds+Fed_Oth_Inc),(K63-FEDEXM)),0)","v":48000},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2H",0.1,513,"SS",null,"M10",2.1000000000000001E-2,null,315625,0.37,90977.25]
["Time Base Fraction: Used only for FRACTIONAL time base employees, otherwise leave the",null,null,null,null,null,null,null,null,"FTG6",{"$f":"MAX(IF(FedHW<>\"\",(K64-FEDEXM-Fed_Deds+Fed_Oth_Inc),(K64-FEDEXM)),0)","v":48000},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2I",0.08,513,"SS",null,"M11",0.03]
["Time Base field blank. Fractions may be entered with or without leading zeros - examples 001/002 or 1/2.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2J",0.1,513,"SS",null,"M12",3.5999999999999997E-2]
[null,null,null,null,null,null,null,null,null,"      BASE AMOUNT",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2K",0.09,317,"NO",null,"M13",3.5000000000000003E-2]
["Total Locked-In Pay NOT Subject to Retirement: Enter the total locked-in premium amount NOT",null,null,null,null,null,null,null,null,"FBSA1",{"$f":"IF(FEDM_HW=\"M\",VLOOKUP(_FTG1,FTXTBLM,1),IF(FEDM_HW=\"A\",VLOOKUP(_FTG1,FTXTBLMHW,1),IF(FEDM_HW=\"S\",VLOOKUP(_FTG1,FTXTBLSH,1),IF(FEDM_HW=\"I\",VLOOKUP(_FTG1,FTXTBLSHW,1),IF(FEDM_HW=\"H\",VLOOKUP(_FTG1,FTXBLH,1),IF(FEDM_HW=\"E\",VLOOKUP(_FTG1,FTXTBLHHW,1)))))))","v":-999999},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2L",0.1,513,"SS",null,"M14",0.03]
["subject to retirement for the pay period. Leave blank if the employee does not have a locked-in",null,null,null,null,null,null,null,null,"FBSA2",{"$f":"IF(FEDM_HW=\"M\",VLOOKUP(_FTG2,FTXTBLM,1),IF(FEDM_HW=\"A\",VLOOKUP(_FTG2,FTXTBLMHW,1),IF(FEDM_HW=\"S\",VLOOKUP(_FTG2,FTXTBLSH,1),IF(FEDM_HW=\"I\",VLOOKUP(_FTG2,FTXTBLSHW,1),IF(FEDM_HW=\"H\",VLOOKUP(_FTG2,FTXBLH,1),IF(FEDM_HW=\"E\",VLOOKUP(_FTG2,FTXTBLHHW,1)))))))","v":-999999},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2M",0.08,513,"SS",null,"M15",0.03]
["premium pay amount not subject to retirement.",null,null,null,null,null,null,null,null,"FBSA3",{"$f":"IF(FEDM_HW=\"M\",VLOOKUP(_FTG3,FTXTBLM,1),IF(FEDM_HW=\"A\",VLOOKUP(_FTG3,FTXTBLMHW,1),IF(FEDM_HW=\"S\",VLOOKUP(_FTG3,FTXTBLSH,1),IF(FEDM_HW=\"I\",VLOOKUP(_FTG3,FTXTBLSHW,1),IF(FEDM_HW=\"H\",VLOOKUP(_FTG3,FTXBLH,1),IF(FEDM_HW=\"E\",VLOOKUP(_FTG3,FTXTBLHHW,1)))))))","v":-999999},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2N",0.08,0,"SS",null,"M16",1.4E-2]
[null,null,null,null,null,null,null,null,null,"FBSA4",{"$f":"IF(FEDM_HW=\"M\",VLOOKUP(_FTG4,FTXTBLM,1),IF(FEDM_HW=\"A\",VLOOKUP(_FTG4,FTXTBLMHW,1),IF(FEDM_HW=\"S\",VLOOKUP(_FTG4,FTXTBLSH,1),IF(FEDM_HW=\"I\",VLOOKUP(_FTG4,FTXTBLSHW,1),IF(FEDM_HW=\"H\",VLOOKUP(_FTG4,FTXBLH,1),IF(FEDM_HW=\"E\",VLOOKUP(_FTG4,FTXTBLHHW,1)))))))","v":39500},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2O",0.125,513,"SS",null,"M17",0.03]
["Retirement Account Code: Enter the two digits Account Code/Retirement ID for the employee's",null,null,null,null,null,null,null,null,"FBSA5",{"$f":"IF(FEDM_HW=\"M\",VLOOKUP(_FTG5,FTXTBLM,1),IF(FEDM_HW=\"A\",VLOOKUP(_FTG5,FTXTBLMHW,1),IF(FEDM_HW=\"S\",VLOOKUP(_FTG5,FTXTBLSH,1),IF(FEDM_HW=\"I\",VLOOKUP(_FTG5,FTXTBLSHW,1),IF(FEDM_HW=\"H\",VLOOKUP(_FTG5,FTXBLH,1),IF(FEDM_HW=\"E\",VLOOKUP(_FTG5,FTXTBLHHW,1)))))))","v":39500},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2P",8.5000000000000006E-2,513,"SS",null,"M18",4.4999999999999998E-2]
["retirement plan in effect for the pay period being calculated. For Excluded/Exempts employee's use \"U\".",null,null,null,null,null,null,null,null,"FBSA6",{"$f":"IF(FEDM_HW=\"M\",VLOOKUP(_FTG6,FTXTBLM,1),IF(FEDM_HW=\"A\",VLOOKUP(_FTG6,FTXTBLMHW,1),IF(FEDM_HW=\"S\",VLOOKUP(_FTG6,FTXTBLSH,1),IF(FEDM_HW=\"I\",VLOOKUP(_FTG6,FTXTBLSHW,1),IF(FEDM_HW=\"H\",VLOOKUP(_FTG6,FTXBLH,1),IF(FEDM_HW=\"E\",VLOOKUP(_FTG6,FTXTBLHHW,1)))))))","v":39500},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2Q",0.1,317,"NO",null,"M19",0.03]
["NOTE: The appropriate Social Security and Medicare amounts will be calculated based on the",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2R",0.08,513,"SS",null,"M20",0.03]
["retirement account code provided.",null,null,null,null,null,null,null,null,"MARGINAL TAX RATE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2S",0.09,317,"NO",null,"M21",0.03]
[null,null,null,null,null,null,null,null,null,"FMTR1",{"$f":"IF(FEDM_HW=\"M\",VLOOKUP(_FTG1,FTXTBLM,2),IF(FEDM_HW=\"A\",VLOOKUP(_FTG1,FTXTBLMHW,2),IF(FEDM_HW=\"S\",VLOOKUP(_FTG1,FTXTBLSH,2),IF(FEDM_HW=\"I\",VLOOKUP(_FTG1,FTXTBLSHW,2),IF(FEDM_HW=\"H\",VLOOKUP(_FTG1,FTXBLH,2),IF(FEDM_HW=\"E\",VLOOKUP(_FTG1,FTXTBLHHW,2)))))))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2T",0.09,317,"MED",null,"NON",0]
["Pay Period: Enter the month and year of the pay period for which pay is being calculated.",null,null,null,null,null,null,null,null,"FMTR2",{"$f":"IF(FEDM_HW=\"M\",VLOOKUP(_FTG2,FTXTBLM,2),IF(FEDM_HW=\"A\",VLOOKUP(_FTG2,FTXTBLMHW,2),IF(FEDM_HW=\"S\",VLOOKUP(_FTG2,FTXTBLSH,2),IF(FEDM_HW=\"I\",VLOOKUP(_FTG2,FTXTBLSHW,2),IF(FEDM_HW=\"H\",VLOOKUP(_FTG2,FTXBLH,2),IF(FEDM_HW=\"E\",VLOOKUP(_FTG2,FTXTBLHHW,2)))))))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2U",0.06,317,"NO",null,"R01",0.03]
[null,null,null,null,null,null,null,null,null,"FMTR3",{"$f":"IF(FEDM_HW=\"M\",VLOOKUP(_FTG3,FTXTBLM,2),IF(FEDM_HW=\"A\",VLOOKUP(_FTG3,FTXTBLMHW,2),IF(FEDM_HW=\"S\",VLOOKUP(_FTG3,FTXTBLSH,2),IF(FEDM_HW=\"I\",VLOOKUP(_FTG3,FTXTBLSHW,2),IF(FEDM_HW=\"H\",VLOOKUP(_FTG3,FTXBLH,2),IF(FEDM_HW=\"E\",VLOOKUP(_FTG3,FTXTBLHHW,2)))))))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2V",0.09,317,"MED",null,"R02",1.4E-2]
["Apply Exclusion Amt: An entry in this field is required only when calculating IDL/S for a semimonthly",null,null,null,null,null,null,null,null,"FMTR4",{"$f":"IF(FEDM_HW=\"M\",VLOOKUP(_FTG4,FTXTBLM,2),IF(FEDM_HW=\"A\",VLOOKUP(_FTG4,FTXTBLMHW,2),IF(FEDM_HW=\"S\",VLOOKUP(_FTG4,FTXTBLSH,2),IF(FEDM_HW=\"I\",VLOOKUP(_FTG4,FTXTBLSHW,2),IF(FEDM_HW=\"H\",VLOOKUP(_FTG4,FTXBLH,2),IF(FEDM_HW=\"E\",VLOOKUP(_FTG4,FTXTBLHHW,2)))))))","v":0.12},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2W",0.09,513,"SS",null,"R03",0.03]
["employee. For all other employees, leave this field blank.",null,null,null,null,null,null,null,null,"FMTR5",{"$f":"IF(FEDM_HW=\"M\",VLOOKUP(_FTG5,FTXTBLM,2),IF(FEDM_HW=\"A\",VLOOKUP(_FTG5,FTXTBLMHW,2),IF(FEDM_HW=\"S\",VLOOKUP(_FTG5,FTXTBLSH,2),IF(FEDM_HW=\"I\",VLOOKUP(_FTG5,FTXTBLSHW,2),IF(FEDM_HW=\"H\",VLOOKUP(_FTG5,FTXBLH,2),IF(FEDM_HW=\"E\",VLOOKUP(_FTG5,FTXTBLHHW,2)))))))","v":0.12},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2X",0.08,513,"SS",null,"R04",0.03]
["Enter \"Y\" or \"Yes\" when the Retirement Exclusion Amount is to be applied.",null,null,null,null,null,null,null,null,"FMTR6",{"$f":"IF(FEDM_HW=\"M\",VLOOKUP(_FTG6,FTXTBLM,2),IF(FEDM_HW=\"A\",VLOOKUP(_FTG6,FTXTBLMHW,2),IF(FEDM_HW=\"S\",VLOOKUP(_FTG6,FTXTBLSH,2),IF(FEDM_HW=\"I\",VLOOKUP(_FTG6,FTXTBLSHW,2),IF(FEDM_HW=\"H\",VLOOKUP(_FTG6,FTXBLH,2),IF(FEDM_HW=\"E\",VLOOKUP(_FTG6,FTXTBLHHW,2)))))))","v":0.12},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2Y",0.08,513,"SS",null,"R05",3.4000000000000002E-2]
["Enter \"N\" or \"No\" when the Retirement Exclusion Amount is NOT to be applied.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2Z",0.05,513,"SS",null,"R06",0.04]
[null,null,null,null,null,null,null,null,null,"  BASE TAX AMOUNT",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"30",0.105,317,"NO",null,"R07",0.04]
["SDI: When the Collective Bargaining Unit ID is entered, the calculator will automatically enter a",null,null,null,null,null,null,null,null,"FBST1",{"$f":"IF(FEDM_HW=\"M\",VLOOKUP(_FTG1,FTXTBLM,3),IF(FEDM_HW=\"A\",VLOOKUP(_FTG1,FTXTBLMHW,3),IF(FEDM_HW=\"S\",VLOOKUP(_FTG1,FTXTBLSH,3),IF(FEDM_HW=\"I\",VLOOKUP(_FTG1,FTXTBLSHW,3),IF(FEDM_HW=\"H\",VLOOKUP(_FTG1,FTXBLH,3),IF(FEDM_HW=\"E\",VLOOKUP(_FTG1,FTXTBLHHW,3)))))))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"31",0.08,238,"NO",null,"R08",3.9E-2]
["a \"Yes\" or \"No\" in this field.",null,null,null,null,null,null,null,null,"FBST2",{"$f":"IF(FEDM_HW=\"M\",VLOOKUP(K68,FTXTBLM,3),IF(FEDM_HW=\"A\",VLOOKUP(K68,FTXTBLMHW,3),IF(FEDM_HW=\"S\",VLOOKUP(K68,FTXTBLSH,3),IF(FEDM_HW=\"I\",VLOOKUP(K68,FTXTBLSHW,3),IF(FEDM_HW=\"H\",VLOOKUP(K68,FTXBLH,3),IF(FEDM_HW=\"E\",VLOOKUP(K68,FTXTBLHHW,3)))))))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"32",0.08,238,"MED",null,"R09",0.02]
[null,null,null,null,null,null,null,null,null,"FBST3",{"$f":"IF(FEDM_HW=\"M\",VLOOKUP(K69,FTXTBLM,3),IF(FEDM_HW=\"A\",VLOOKUP(K69,FTXTBLMHW,3),IF(FEDM_HW=\"S\",VLOOKUP(K69,FTXTBLSH,3),IF(FEDM_HW=\"I\",VLOOKUP(K69,FTXTBLSHW,3),IF(FEDM_HW=\"H\",VLOOKUP(K69,FTXBLH,3),IF(FEDM_HW=\"E\",VLOOKUP(K69,FTXTBLHHW,3)))))))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"33",0.01,317,"MED",null,"R10",2.1000000000000001E-2]
["Federal Filing Status: Enter the employee's exemptions based on the first date of disability per Government ",null,null,null,null,null,null,null,null,"FBST4",{"$f":"IF(FEDM_HW=\"M\",VLOOKUP(K70,FTXTBLM,3),IF(FEDM_HW=\"A\",VLOOKUP(K70,FTXTBLMHW,3),IF(FEDM_HW=\"S\",VLOOKUP(K70,FTXTBLSH,3),IF(FEDM_HW=\"I\",VLOOKUP(K70,FTXTBLSHW,3),IF(FEDM_HW=\"H\",VLOOKUP(K70,FTXBLH,3),IF(FEDM_HW=\"E\",VLOOKUP(K70,FTXTBLHHW,3)))))))","v":2320},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"34",0.06,238,"NO",null,"R11",0.03]
["Code 19871 for federal tax purposes.  \"S\" for single/head of household; \"M\" for married. ",null,null,null,null,null,null,null,null,"FBST5",{"$f":"IF(FEDM_HW=\"M\",VLOOKUP(K71,FTXTBLM,3),IF(FEDM_HW=\"A\",VLOOKUP(K71,FTXTBLMHW,3),IF(FEDM_HW=\"S\",VLOOKUP(K71,FTXTBLSH,3),IF(FEDM_HW=\"I\",VLOOKUP(K71,FTXTBLSHW,3),IF(FEDM_HW=\"H\",VLOOKUP(K71,FTXBLH,3),IF(FEDM_HW=\"E\",VLOOKUP(K71,FTXTBLHHW,3)))))))","v":2320},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"36",0.13,513,"MED",null,"R12",3.5999999999999997E-2]
[null,null,null,null,null,null,null,null,null,"FBST6",{"$f":"IF(FEDM_HW=\"M\",VLOOKUP(K72,FTXTBLM,3),IF(FEDM_HW=\"A\",VLOOKUP(K72,FTXTBLMHW,3),IF(FEDM_HW=\"S\",VLOOKUP(K72,FTXTBLSH,3),IF(FEDM_HW=\"I\",VLOOKUP(K72,FTXTBLSHW,3),IF(FEDM_HW=\"H\",VLOOKUP(K72,FTXBLH,3),IF(FEDM_HW=\"E\",VLOOKUP(K72,FTXTBLHHW,3)))))))","v":2320},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"37",0.08,863,"NO",null,"R13",3.5000000000000003E-2]
["Total Fed Exemptions: Enter the total number of federal exemptions based on the first date of disability per ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"39",0.08,238,"NO",null,"R14",0.03]
["Government Code 19871 for federal tax purposes.  If the employee claims exempt from federal taxes, ",null,null,null,null,null,null,null,null," OVER BASE AMOUNT",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3A",0.13,863,"NO",null,"R15",0.03]
["enter \"99\". ",null,null,null,null,null,null,null,null,"FOVR1",{"$f":"ROUND(_FTG1-FBSA1,2)","v":999999},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3B",0.13,863,"MED",null,"R16",1.4E-2]
[null,null,null,null,null,null,null,null,null,"FOVR2",{"$f":"ROUND(K68-K76,2)","v":999999},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3C",0.13,863,"NO",null,"R17",0.03]
["Federal High Wage-Enter Y (Yes) for higher tax withholding, enter N (No) for not to higher tax withholding.",null,null,null,null,null,null,null,null,"FOVR3",{"$f":"(K69-K77)","v":999999},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3D",0.13,863,"MED",null,"R18",4.4999999999999998E-2]
["This field must be completed when using revised STD 686 or STD 457 effective 12/2020.",null,null,null,null,null,null,null,null,"FOVR4",{"$f":"(K70-K78)","v":8500},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3E",0.13,863,"NO",null,"R19",0.03]
[null,null,null,null,null,null,null,null,null,"FOVR5",{"$f":"(K71-K79)","v":8500},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3F",0.13,863,"MED",null,"R20",0.03]
["Federal Claim Dependents-Enter annual amount for Child Tax Credit and the credits for other dependents.",null,null,null,null,null,null,null,null,"FOVR6",{"$f":"(K72-K80)","v":8500},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3G",0.13250000000000001,0,"NO",null,"R21",0.03]
["This field must be completed when using revised STD 686 or STD 457 effective 12/2020.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3H",0.13250000000000001,0,"MED",null,"S01",0.03]
[null,null,null,null,null,null,null,null,null,"   ANNUALIZED TAX",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3J",9.5000000000000001E-2,317,"NO",null,"S02",1.4E-2]
["Federal Other Income-Enter dollar amount for other income for the year, do not include income from other jobs.",null,null,null,null,null,null,null,null,"FTA1",{"$f":"MAX(IF(FedHW=\"\",(FBST1+ROUND(FOVR1*FMTR1,5)),(FBST1+ROUND((FOVR1*FMTR1)-Fed_Claim_Dpnts,5))),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3K",0.08,513,"MED",null,"S03",0.03]
["This field must be completed when using revised STD 686 or STD 457 effective 12/2020.",null,null,null,null,null,null,null,null,"FTA2",{"$f":"MAX(IF(FedHW=\"\",(FBST2+ROUND(FOVR2*FMTR2,5)),(FBST2+ROUND((FOVR2*FMTR2)-Fed_Claim_Dpnts,5))),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3L",0.11,863,"NO",null,"S04",0.03]
[null,null,null,null,null,null,null,null,null,"FTA3",{"$f":"MAX(IF(FedHW=\"\",(FBST3+ROUND(FOVR3*FMTR3,5)),(FBST3+ROUND((FOVR3*FMTR3)-Fed_Claim_Dpnts,5))),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3M",0.13,863,"MED",null,"S05",3.4000000000000002E-2]
["Federal Deductions-Enter amount for other than the basic standard deductions.",null,null,null,null,null,null,null,null,"FTA4",{"$f":"IF(FedHW=\"\",(FBST4+ROUND(FOVR4*FMTR4,5)),(FBST4+ROUND((FOVR4*FMTR4)-Fed_Claim_Dpnts,5)))","v":3340},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3N",0.08,238,"NO",null,"S06",0.04]
["This field must be completed when using revised STD 686 or STD 457 effective 12/2020.",null,null,null,null,null,null,null,null,"FTA5",{"$f":"MAX(IF(FedHW=\"\",(FBST5+ROUND(FOVR5*FMTR5,5)),(FBST5+ROUND((FOVR5*FMTR5)-Fed_Claim_Dpnts,5))),0)","v":3340},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3P",0.08,238,"MED",null,"S07",0.04]
[null,null,null,null,null,null,null,null,null,"FTA18",{"$f":"MAX(IF(FedHW=\"\",(FBST6+ROUND(FOVR6*FMTR6,5)),(FBST6+ROUND((FOVR6*FMTR6)-Fed_Claim_Dpnts,5))),0)","v":3340},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3Q",0.08,238,"NO",null,"S08",3.9E-2]
["State Filing Status: Enter the employee's filing status based on the first date of disability per Government ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3R",0.08,238,"MED",null,"S09",0.02]
["Code 19871 for state tax purposes.  (NOTE: This calculates only the California state tax).  \"S\" for ",null,null,null,null,null,null,null,null,"    PAY PERIOD TAX",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3S",0.125,863,"NO",null,"S10",2.1000000000000001E-2]
["single; \"H\" for head of household; \"M\" for married. ",null,null,null,null,null,null,null,null,"FTAX1",{"$f":"IF(FEDM=\"E\",0,(ROUND(_FTA1/PAYFACT,2)))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3T",0.13,863,"MED",null,"S11",0.03]
[null,null,null,null,null,null,null,null,null,"FTAX2",{"$f":"IF(FEDM=\"E\",0,(ROUND(K108/PAYFACT,2)))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3U",0.125,863,"NO",null,"S12",3.5999999999999997E-2]
["Reg State Allowance: Enter the number of regular state allowances (Standard Deductions) based on the",null,null,null,null,null,null,null,null,"FTAX3",{"$f":"IF(FEDM=\"E\",0,(ROUND(K109/PAYFACT,2)))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3V",0.125,863,"MED",null,"S13",3.5000000000000003E-2]
["first date of disability per Government Code 19871 for state tax purposes.  If the employee claims exempt",null,null,null,null,null,null,null,null,"FTAX4",{"$f":"IF(FEDM=\"E\",0,(ROUND(K110/PAYFACT,2)))","v":278.33},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3W",0.13250000000000001,0,"NO",null,"S14",0.03]
["from state taxes, enter \"99\". ",null,null,null,null,null,null,null,null,"FTAX5",{"$f":"IF(FEDM=\"E\",0,(ROUND(K111/PAYFACT,2)))","v":278.33},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3X",0.1,513,"NO",null,"S15",0.03]
[null,null,null,null,null,null,null,null,null,"FTAX6",{"$f":"IF(FEDM=\"E\",0,(ROUND(K112/PAYFACT,2)))","v":278.33},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3Y",0.13,513,"MED",null,"S16",1.4E-2]
["Additional Exemptions State: Enter the number of additional state allowances based on the first date of",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3Z",0.13250000000000001,0,"MED",null,"S17",0.03]
["disability per Government Code 19871 for state tax purposes.  If the employee claims exempt from ",null,null,null,null,null,null,null,null,"        STATE TAXES",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"40",0.105,317,"NO",null,"S18",4.4999999999999998E-2]
["state taxes, leave field BLANK. ",null,null,null,null,null,null,null,null,"LIE",{"$f":"IF(STM=\"S\",LIES1,IF(AND(STM=\"M\",STE<2),LIEM1,IF(AND(STM=\"M\",STE>=2),LIEM2,IF(STM=\"H\",LIEH1,99999))))","v":17769},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"41",3.7499999999999999E-2,0,"SS",null,"S19",0.03]
[null,null,null,null,null,null,null,null,null,"ADDALLOW1",{"$f":"(STA*SADDALL1)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"42",0.06,317,"MED",null,"S20",0.03]
["Issue Month and Year: Enter the calendar month/year that corresponds to the Issue Date of the",null,null,null,null,null,null,null,null,"SDED1",{"$f":"IF(STM=\"S\",_SDS1,IF(AND(STM=\"M\",STE<2),_SDM1,IF(AND(STM=\"M\",STE>=2),_SDM2,IF(STM=\"H\",_SDH1,0))))","v":5363},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"43",0.05,513,"SS",null,"S21",0.03]
["payment.",null,null,null,null,null,null,null,null,"TXCRB",{"$f":"IF(AND(B17=\"S\",D17=0),AM60,IF(AND(B17=\"S\",D17=1),AN60,IF(AND(B17=\"S\",D17>=2),AO60,IF(AND(B17=\"M\",D17=0),AM61,IF(OR(AND(B17=\"M\",B17=\"H\"),D17=1),AN61,IF(OR(AND(B17=\"M\",B17=\"H\"),D17>=2),AO61,0))))))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"44",3.7499999999999999E-2,0,"SS"]
[null,null,null,null,null,null,null,null,null,"TXCROV",{"$f":"IF(STE<3,0,STE-2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"45",0.08,513,"SS"]
["For semi-monthly first half pay period IDL/S calculations, enter the pay period and year of the",null,null,null,null,null,null,null,null,"TXCRR",{"$f":"IF(STM=\"S\",TCRS3,TCRM3)","v":158.4},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"46",0.06,317,"NO"]
["Regular Pay payment. For all other IDL/S calculations (second half and monthly pay periods),",null,null,null,null,null,null,null,null,"TXCREDIT",{"$f":"(TXCRB+(TXCROV*TXCRR))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"47",3.7499999999999999E-2,0,"SS"]
["enter the next month and year of the Reguar Pay payment's pay period.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"48",0.06,317,"MED"]
[null,null,null,null,null,null,null,null,null,"STATE ANNUALIZED TAXABLE GROSS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"49",9.5000000000000001E-2,513,"SS"]
["Example: For the first half of the 05/2009 pay period, enter 05/09. For the second half of the",null,null,null,null,null,null,null,null,"STG1",{"$f":"IF((PAYFACT*_TG1)-ADDALLOW1-SDED1<=0,0,(PAYFACT*_TG1)-ADDALLOW1-SDED1)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4A",8.5000000000000006E-2,513,"SS"]
["05/2009 pay period of the monthly pay period with an issue date of 06/01/09, enter 06/09.",null,null,null,null,null,null,null,null,"STG2",{"$f":"IF((PAYFACT*_TG2)-ADDALLOW1-SDED1<=0,0,(PAYFACT*_TG2)-ADDALLOW1-SDED1)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4B",0.08,513,"SS"]
[null,null,null,null,null,null,null,null,null,"STG3",{"$f":"IF((PAYFACT*_TG3)-ADDALLOW1-SDED1<=0,0,(PAYFACT*_TG3)-ADDALLOW1-SDED1)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4C",0.06,317,"NO"]
["Regular Pay: Enter the days and/or hours for regular pay in the pay period.",null,null,null,null,null,null,null,null,"STG4",{"$f":"IF((PAYFACT*_TG4)-ADDALLOW1-SDED1<=0,0,(PAYFACT*_TG4)-ADDALLOW1-SDED1)","v":42637},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4D",3.7499999999999999E-2,0,"SS"]
[null,null,null,null,null,null,null,null,null,"STG5",{"$f":"IF((PAYFACT*_TG5)-ADDALLOW1-SDED1<=0,0,(PAYFACT*_TG5)-ADDALLOW1-SDED1)","v":42637},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4E",3.7499999999999999E-2,0,"SS"]
["IDL Full Pay: Enter the days and/or hours for IDL Full in the pay period.",null,null,null,null,null,null,null,null,"STG6",{"$f":"IF((PAYFACT*_TG6)-ADDALLOW1-SDED1<=0,0,(PAYFACT*_TG6)-ADDALLOW1-SDED1)","v":42637},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4F",3.7499999999999999E-2,0,"SS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4G",0.09,513,"SS"," "]
["IDL 2/3 Pay: Enter the days and/or hours for IDL 2/3's in the pay period.",null,null,null,null,null,null,null,null,"       BASE AMOUNT",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4H",0.09,513,"SS"," "]
[null,null,null,null,null,null,null,null,null,"SBSA1",{"$f":"IF(STM=\"S\",VLOOKUP(_STG1,STXTBLS1,1),IF(STM=\"M\",VLOOKUP(_STG1,STXTBLM1,1),IF(STM=\"H\",VLOOKUP(_STG1,STXTBLH1,1),0)))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4J",0.03,513,"SS"," "]
["After entering and verifying the required fields, click the \"Calculate IDLS\" button.",null,null,null,null,null,null,null,null,"SBSA2",{"$f":"IF(STM=\"S\",VLOOKUP(K133,STXTBLS1,1),IF(STM=\"M\",VLOOKUP(K133,STXTBLM1,1),IF(STM=\"H\",VLOOKUP(K133,STXTBLH1,1),0)))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4K",7.0000000000000007E-2,317,"NO"," "]
[null,null,null,null,null,null,null,null,null,"SBSA3",{"$f":"IF(STM=\"S\",VLOOKUP(K134,STXTBLS1,1),IF(STM=\"M\",VLOOKUP(K134,STXTBLM1,1),IF(STM=\"H\",VLOOKUP(K134,STXTBLH1,1),0)))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4L",0.08,513,"SS"," "]
["To reset the input fields, click the \"Reset Fields\" button.",null,null,null,null,null,null,null,null,"SBSA4",{"$f":"IF(STM=\"S\",VLOOKUP(K135,STXTBLS1,1),IF(STM=\"M\",VLOOKUP(K135,STXTBLM1,1),IF(STM=\"H\",VLOOKUP(K135,STXTBLH1,1),0)))","v":20824},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4M",0.11,317,"NO"," "]
[null,null,null,null,null,null,null,null,null,"SBSA5",{"$f":"IF(STM=\"S\",VLOOKUP(K136,STXTBLS1,1),IF(STM=\"M\",VLOOKUP(K136,STXTBLM1,1),IF(STM=\"H\",VLOOKUP(K136,STXTBLH1,1),0)))","v":20824},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4N",0.11,317,"MED"," "]
[null,null,null,null,null,null,null,null,null,"SBSA6",{"$f":"IF(STM=\"S\",VLOOKUP(K137,STXTBLS1,1),IF(STM=\"M\",VLOOKUP(K137,STXTBLM1,1),IF(STM=\"H\",VLOOKUP(K137,STXTBLH1,1),0)))","v":20824},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4P",0.08,513,"SS"," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4Q",0.08,513,"SS"]
[null,null,null,null,null,null,null,null,null," MARGINAL TAX RATE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4R",3.7499999999999999E-2,0,"SS"]
[null,null,null,null,null,null,null,null,null,"SMTR1",{"$f":"IF(STM=\"S\",VLOOKUP(_STG1,STXTBLS1,2),IF(STM=\"M\",VLOOKUP(_STG1,STXTBLM1,2),IF(STM=\"H\",VLOOKUP(_STG1,STXTBLH1,2),0)))","v":1.0999999999999999E-2},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4S",3.7499999999999999E-2,0,"SS"]
[null,null,null,null,null,null,null,null,null,"SMTR2",{"$f":"IF(STM=\"S\",VLOOKUP(K133,STXTBLS1,2),IF(STM=\"M\",VLOOKUP(K133,STXTBLM1,2),IF(STM=\"H\",VLOOKUP(K133,STXTBLH1,2),0)))","v":1.0999999999999999E-2},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4T",0.1,513,"SS"]
[null,null,null,null,null,null,null,null,null,"SMTR3",{"$f":"IF(STM=\"S\",VLOOKUP(K134,STXTBLS1,2),IF(STM=\"M\",VLOOKUP(K134,STXTBLM1,2),IF(STM=\"H\",VLOOKUP(K134,STXTBLH1,2),0)))","v":1.0999999999999999E-2},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4U",0.08,0,"NO"]
[null,null,null,null,null,null,null,null,null,"SMTR4",{"$f":"IF(STM=\"S\",VLOOKUP(K135,STXTBLS1,2),IF(STM=\"M\",VLOOKUP(K135,STXTBLM1,2),IF(STM=\"H\",VLOOKUP(K135,STXTBLH1,2),0)))","v":2.1999999999999999E-2},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4V",0.08,513,"SS"]
[null,null,null,null,null,null,null,null,null,"SMTR5",{"$f":"IF(STM=\"S\",VLOOKUP(K136,STXTBLS1,2),IF(STM=\"M\",VLOOKUP(K136,STXTBLM1,2),IF(STM=\"H\",VLOOKUP(K136,STXTBLH1,2),0)))","v":2.1999999999999999E-2},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4W",0.1,513,"SS"]
[null,null,null,null,null,null,null,null,null,"SMTR6",{"$f":"IF(STM=\"S\",VLOOKUP(K137,STXTBLS1,2),IF(STM=\"M\",VLOOKUP(K137,STXTBLM1,2),IF(STM=\"H\",VLOOKUP(K137,STXTBLH1,2),0)))","v":2.1999999999999999E-2},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4X",9.5000000000000001E-2,513,"SS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4Y",3.7499999999999999E-2,0,"SS"," "]
[null,null,null,null,null,null,null,null,null,"   BASE TAX AMOUNT",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4Z",0,0,"SS"," "]
[null,null,null,null,null,null,null,null,null,"SBST1",{"$f":"IF(STM=\"S\",VLOOKUP(_STG1,STXTBLS1,3),IF(STM=\"M\",VLOOKUP(_STG1,STXTBLM1,3),IF(STM=\"H\",VLOOKUP(_STG1,STXTBLH1,3),0)))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"50",0.08,238,"MED"," "]
[null,null,null,null,null,null,null,null,null,"SBST2",{"$f":"IF(STM=\"S\",VLOOKUP(K133,STXTBLS1,3),IF(STM=\"M\",VLOOKUP(K133,STXTBLM1,3),IF(STM=\"H\",VLOOKUP(K133,STXTBLH1,3),0)))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"51",0.08,238,"NO"," "]
[null,null,null,null,null,null,null,null,null,"SBST3",{"$f":"IF(STM=\"S\",VLOOKUP(K134,STXTBLS1,3),IF(STM=\"M\",VLOOKUP(K134,STXTBLM1,3),IF(STM=\"H\",VLOOKUP(K134,STXTBLH1,3),0)))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"52",0.08,238,"MED"]
[null,null,null,null,null,null,null,null,null,"SBST4",{"$f":"IF(STM=\"S\",VLOOKUP(K135,STXTBLS1,3),IF(STM=\"M\",VLOOKUP(K135,STXTBLM1,3),IF(STM=\"H\",VLOOKUP(K135,STXTBLH1,3),0)))","v":229.06},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"53",0.08,238,"NO"," "]
[null,null,null,null,null,null,null,null,null,"SBST5",{"$f":"IF(STM=\"S\",VLOOKUP(K136,STXTBLS1,3),IF(STM=\"M\",VLOOKUP(K136,STXTBLM1,3),IF(STM=\"H\",VLOOKUP(K136,STXTBLH1,3),0)))","v":229.06},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"54",0.08,238,"MED"," "]
[null,null,null,null,null,null,null,null,null,"SBST6",{"$f":"IF(STM=\"S\",VLOOKUP(K137,STXTBLS1,3),IF(STM=\"M\",VLOOKUP(K137,STXTBLM1,3),IF(STM=\"H\",VLOOKUP(K137,STXTBLH1,3),0)))","v":229.06},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"55",0.13,863,"NO"," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"56",0.08,863,"MED"," "]
[null,null,null,null,null,null,null,null,null,"  OVER BASE AMOUNT",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"57",0.08,513,"NO"," "]
[null,null,null,null,null,null,null,null,null,"SOVR1",{"$f":"ROUND(_STG1-SBSA1,2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"58",0.08,513,"MED"," "]
[null,null,null,null,null,null,null,null,null,"SOVR2",{"$f":"ROUND(K133-K141,2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5A",0.06,513,"NO"," "]
[null,null,null,null,null,null,null,null,null,"SOVR3",{"$f":"ROUND(K134-K142,2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5B",0.15,863,"MED"," "]
[null,null,null,null,null,null,null,null,null,"SOVR4",{"$f":"ROUND(K135-K143,2)","v":21813},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5C",0.13,513,"NO"," "]
[null,null,null,null,null,null,null,null,null,"SOVR5",{"$f":"ROUND(K136-K144,2)","v":21813},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5D",0.13,513,"MED"," "]
[null,null,null,null,null,null,null,null,null,"SOVR6",{"$f":"ROUND(K137-K145,2)","v":21813},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5E",0.13,513,"NO"," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5F",0.13,513,"MED"]
[null,null,null,null,null,null,null,null,null,"     ANNUALIZED TAX",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5G",0.13,513,"NO"]
[null,null,null,null,null,null,null,null,null,"STA1",{"$f":"(SBST1+ROUND(SOVR1*SMTR1,5))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5H",0.13,513,"MED"]
[null,null,null,null,null,null,null,null,null,"STA2",{"$f":"(K157+ROUND(K165*SMTR2,5))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5J",0.13,863,"NO"]
[null,null,null,null,null,null,null,null,null,"STA3",{"$f":"(K158+ROUND(K166*SMTR3,5))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5K",0.13,863,"MED"," "]
[null,null,null,null,null,null,null,null,null,"STA4",{"$f":"(K159+ROUND(K167*SMTR4,5))","v":708.94600000000003},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5L",0.06,513,"NO"," "]
[null,null,null,null,null,null,null,null,null,"STA5",{"$f":"(K160+ROUND(K168*SMTR5,5))","v":708.94600000000003},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5M",0.06,513,"MED"," "]
[null,null,null,null,null,null,null,null,null,"STA6",{"$f":"(K161+ROUND(K169*SMTR6,5))","v":708.94600000000003},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5N",0.15,513,"MED"," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5P",0.06,513,"MED"," "]
[null,null,null,null,null,null,null,null,null,"     PAY PERIOD TAX",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5R",0.14000000000000001,513,"MED"," "]
[null,null,null,null,null,null,null,null,null,"STAX1",{"$f":"IF(OR(_TG1*PAYFACT<=LIE,(_STA1-TXCREDIT)/PAYFACT<=0),0,IF(_STA1-TXCREDIT/PAYFACT>0,ROUND((_STA1-TXCREDIT)/PAYFACT,2)))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5S",0.15,513,"NO"," "]
[null,null,null,null,null,null,null,null,null,"STAX2",{"$f":"IF(OR(_TG2*PAYFACT<=LIE,(K173-TXCREDIT)/PAYFACT<=0),0,IF(K173-TXCREDIT/PAYFACT>0,ROUND((K173-TXCREDIT)/PAYFACT,2)))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5V",0.13,513,"MED"," "]
[null,null,null,null,null,null,null,null,null,"STAX3",{"$f":"IF(OR(_TG3*PAYFACT<=LIE,(K174-TXCREDIT)/PAYFACT<=0),0,IF(K174-TXCREDIT/PAYFACT>0,ROUND((K174-TXCREDIT)/PAYFACT,2)))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5W",0.11,863,"NO"]
[null,null,null,null,null,null,null,null,null,"STAX4",{"$f":"IF(OR(_TG4*PAYFACT<=LIE,(K175-TXCREDIT)/PAYFACT<=0),0,IF(K175-TXCREDIT/PAYFACT>0,ROUND((K175-TXCREDIT)/PAYFACT,2)))","v":59.08},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5X",0.13,863,"MED"]
[null,null,null,null,null,null,null,null,null,"STAX5",{"$f":"IF(OR(_TG4*PAYFACT<=LIE,(K176-TXCREDIT)/PAYFACT<=0),0,IF(K176-TXCREDIT/PAYFACT>0,ROUND((K176-TXCREDIT)/PAYFACT,2)))","v":59.08},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5Y",0.11,513,"NO"]
[null,null,null,null,null,null,null,null,null,"STAX6",{"$f":"IF(OR(_TG6*PAYFACT<=LIE,(K177-TXCREDIT)/PAYFACT<=0),0,IF(K177-TXCREDIT/PAYFACT>0,ROUND((K177-TXCREDIT)/PAYFACT,2)))","v":59.08},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"61",0.13500000000000001,863,"MED"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"62",0.125,863,"NO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"63",0.08,238,"MED"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"64",0.08,317,"NO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"67",0.01,317,"MED"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"68",0.01,317,"NO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"6J",0.115,317,"MED"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"6K",0.11,317,"NO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"6L",0.11,317,"MED"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"6M",7.0000000000000007E-2,317,"NO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"6P",0.11,317,"MED"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"6R",0.11,317,"NO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"6S",0.13500000000000001,863,"NO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"6T",0.13500000000000001,863,"MED"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"6V",0.1,317,"MED"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"6W",0.1,317,"NO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"6X",0.13500000000000001,317,"NO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"6Y",0.13500000000000001,317,"MED"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"6Z",0.13500000000000001,317,"MED"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"7A",0.115,317,"MED"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"7B",0.115,317,"NO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"7C",0.115,317,"MED"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"7D",0.115,317,"MED"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"7E",0.115,317,"MED"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"7F",0.115,317,"NO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"7G",0.115,317,"MED"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"7H",0.115,317,"NO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"7I",0.115,317,"MED"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"7J",0.115,317,"MED"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"7K",0.115,317,"MED"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"7L",0.115,317,"MED"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"82",0.06,317,"MED"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"83",0.06,317,"NO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"86",0,238,"NO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"87",0.08,238,"NO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"88",0,238,"MED"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"89",0.08,238,"MED"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"91",0,0,"NO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"92",0,0,"NO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"93",0.01,317,"NO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"94",0.05,513,"SS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"95",3.7499999999999999E-2,0,"SS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"96",3.7499999999999999E-2,0,"SS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"97",0.01,317,"MED"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"98",1.4999999999999999E-2,0,"MED"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"99",0,513,"SS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"9A",0.09,513,"SS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"9B",0.09,513,"SS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"9C",0.09,513,"SS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"9D",3.7499999999999999E-2,0,"SS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"9E",0.105,317,"NO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"9F",0.11,317,"MED"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"9G",0.1,513,"SS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"9H",0.11,317,"NO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"9J",0.105,317,"MED"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"9K",0.05,513,"SS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"9L",9.5000000000000001E-2,513,"SS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"9M",0.1,513,"SS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"9N",0.09,513,"SS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"9P",0.09,513,"SS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"9R",8.5000000000000006E-2,513,"NO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"9S",0.105,317,"MED"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"9T",0.1,317,"NO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"9V",0.1,317,"MED"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"9W",0.09,513,"SS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"9X",0.09,513,"SS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"9Y",8.5000000000000006E-2,513,"SS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AA",0.1,513,"SS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AB",0.1,513,"SS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AC",0.1,513,"SS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AE",0.1,513,"SS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AF",0.1,513,"SS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AG",0.1,513,"SS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AH",0.1,513,"SS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AI",0.1,513,"SS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AJ",0.05,513,"SS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AK",0.1,513,"SS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AL",0.125,513,"SS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AM",0.1,513,"SS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AN",0.1,513,"SS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AO",0.1,513,"SS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AP",0.08,513,"SS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AQ",0.08,513,"SS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AR",0.09,513,"SS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AS",0.09,513,"SS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AT",0.08,513,"SS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AU",0.09,513,"SS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AV",0.125,513,"SS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AW",0.09,513,"SS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AX",0.09,513,"SS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AY",0.08,513,"SS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AZ",9.5000000000000001E-2,513,"SS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"B1",3.7499999999999999E-2,0,"NO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"B3",3.7499999999999999E-2,0,"SS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"B4",3.7499999999999999E-2,0,"SS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"B5",9.5000000000000001E-2,513,"SS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"B6",0.01,317,"MED"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"B9",0.08,513,"SS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"C3",3.7499999999999999E-2,0,"MED"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"C4",0,0,"NO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"C9",0.11,317,"MED"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CB",0.11,317,"NO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CC",0.11,317,"MED"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CD",0.11,317,"MED"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CE",0.11,317,"NO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CF",0.11,317,"MED"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CG",0.11,317,"NO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CH",0.11,317,"NO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CJ",0.11,317,"MED"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CK",0.11,317,"MED"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CL",0.11,317,"NO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CP",0.11,317,"MED"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CQ",0.105,317,"NO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CR",0.11,317,"NO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CS",0.11,317,"MED"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CT",0.11,317,"NO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CV",0.11,317,"MED"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CW",0.11,317,"NO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CX",0.11,317,"MED"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CY",0.13500000000000001,317,"NO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CZ",0.13500000000000001,317,"MED"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"D4",0.08,513,"SS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"D5",0.125,513,"SS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"D7",0.08,513,"SS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DA",0.11,317,"NO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DB",0.11,317,"MED"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DC",0.1,513,"SS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DD",0.1,513,"SS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DE",9.5000000000000001E-2,513,"SS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DF",0.1,513,"SS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DG",9.5000000000000001E-2,513,"SS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DH",0.1,513,"SS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DI",0.08,513,"SS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DJ",0.1,513,"SS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DK",0.09,317,"NO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DL",0.1,513,"SS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DM",0.08,513,"SS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DO",0.125,513,"SS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DP",0.08,513,"SS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DQ",0.1,317,"NO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DR",0.08,513,"SS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DS",0.09,317,"NO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DV",0.09,317,"MED"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DW",0.09,513,"SS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"E0",0.105,317,"NO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"E6",0.13,513,"MED"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EA",0.13,863,"NO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EB",0.13,863,"MED"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EC",0.13,863,"NO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ED",0.13,863,"MED"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EE",0.13,863,"NO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EF",0.13,863,"MED"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EJ",9.5000000000000001E-2,317,"NO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EM",0.13,863,"MED"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ES",0.125,863,"NO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ET",0.13,863,"MED"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EV",0.125,863,"MED"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EY",0.13,513,"MED"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F0",0.105,317,"NO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F1",3.7499999999999999E-2,0,"SS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F2",0.06,317,"MED"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F4",3.7499999999999999E-2,0,"SS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F5",0.08,513,"SS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F7",3.7499999999999999E-2,0,"SS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F8",0.06,317,"MED"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F9",9.5000000000000001E-2,513,"SS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FA",0.08,513,"SS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FA",0.08,513,"SS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FB",0.08,513,"SS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FD",3.7499999999999999E-2,0,"SS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FF",3.7499999999999999E-2,0,"SS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FG",0.09,513,"SS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FH",0.09,513,"SS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FL",0.08,513,"SS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FP",0.08,513,"SS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FR",3.7499999999999999E-2,0,"SS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FS",3.7499999999999999E-2,0,"SS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FT",0.1,513,"SS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FV",0.08,513,"SS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FW",0.1,513,"SS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FX",9.5000000000000001E-2,513,"SS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FY",3.7499999999999999E-2,0,"SS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"G5",0.13,863,"NO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GB",0.15,863,"MED"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GC",0.13,513,"NO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GD",0.13,513,"MED"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GE",0.13,513,"NO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GF",0.13,513,"MED"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GG",0.13,513,"NO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GH",0.13,513,"MED"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GJ",0.13,863,"NO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GK",0.13,863,"MED"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GN",0.15,513,"MED"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GR",0.14000000000000001,513,"MED"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GS",0.14000000000000001,513,"NO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GV",0.13,513,"MED"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GX",0.13,863,"MED"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"H1",0.125,863,"MED"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"H2",0.115,863,"NO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HJ",0.115,317,"MED"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HL",0.11,317,"MED"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HP",0.11,317,"MED"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HR",0.11,317,"NO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HS",0.08,863,"NO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HT",0.13500000000000001,863,"MED"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HX",0.13500000000000001,317,"NO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HY",0.13500000000000001,317,"MED"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"J",0.08,0,"NO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"JA",0.01,0,"NO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"JB",0.01,0,"MED"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"JC",0,0,"NO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"JD",0.16750000000000001,0,"MED"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"JE",0.16750000000000001,0,"NO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"JF",0.08,0,"MED"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"JG",0,0,"NO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"JH",0,0,"MED"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"JI",0,0,"NO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"JJ",0,0,"MED"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"JK",0,0,"NO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"JL",0,0,"MED"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"JM",0.08,0,"MED"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"L",0.04,0,"SS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LO",0.08,0,"SS"]
[null,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",0,0,"NO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NA",0,0,"MED"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NM",0,0,"MED"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NO",0,0,"SS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"P2",0,0,"NO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"P5",3.7499999999999999E-2,0,"SS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"P6",3.7499999999999999E-2,0,"SS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"P7",0.01,317,"MED"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"P8",1.4999999999999999E-2,0,"MED"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PA",0.09,513,"SS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PB",0.09,513,"SS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PC",0.09,513,"SS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PD",3.7499999999999999E-2,0,"SS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PE",0.105,317,"NO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PF",0.11,317,"MED"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PG",0.1,513,"SS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PH",0.11,317,"NO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PJ",0.105,317,"MED"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PL",9.5000000000000001E-2,513,"SS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PM",0.1,513,"SS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PN",0.09,513,"SS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PP",0.09,513,"SS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PR",8.5000000000000006E-2,513,"NO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PS",0.1,317,"MED"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PT",0.105,317,"NO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PV",0.1,317,"MED"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PW",0.09,513,"SS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PX",0.09,513,"SS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PY",8.5000000000000006E-2,513,"SS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RA",8.5000000000000006E-2,513,"SS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RB",8.5000000000000006E-2,513,"SS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RC",8.5000000000000006E-2,513,"SS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RD",8.7499999999999994E-2,513,"SS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RE",8.5000000000000006E-2,513,"SS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RF",8.5000000000000006E-2,513,"SS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RG",8.5000000000000006E-2,513,"SS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RH",8.5000000000000006E-2,513,"SS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SA",0.115,317,"MED"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SB",0.115,317,"NO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SC",0.115,317,"MED"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SD",0.115,317,"MED"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SE",0.115,317,"MED"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SF",0.115,317,"NO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SG",0.115,317,"MED"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SH",0.115,317,"NO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SI",0.115,317,"MED"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SJ",0.115,317,"MED"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SK",0.115,317,"MED"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SL",0.115,317,"MED"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T",0.08,0,"NO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TA",0.10249999999999999,0,"MED"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TC",0.10249999999999999,0,"MED"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TD",7.4999999999999997E-2,0,"NO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TE",0.09,513,"SS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TF",0.09,513,"SS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TG",0.09,513,"SS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TH",0.09,513,"SS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TJ",0.08,513,"SS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TK",0.08,513,"SS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TL",0.05,513,"SS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TM",7.4999999999999997E-2,0,"MED"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TN",0.05,513,"SS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TP",9.5000000000000001E-2,513,"SS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TR",0.05,513,"SS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TS",0.09,513,"SS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TX",7.4999999999999997E-2,0,"NO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TY",7.4999999999999997E-2,0,"MED"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TZ",0.05,513,"SS"]