Skip to content

Instantly share code, notes, and snippets.

@zakirsajib
Last active April 2, 2024 20:19
Show Gist options
  • Save zakirsajib/76997f625fc91b6808fcdf650acf6f4c to your computer and use it in GitHub Desktop.
Save zakirsajib/76997f625fc91b6808fcdf650acf6f4c to your computer and use it in GitHub Desktop.
States Formulas
if ( $F4 == '<img src="https://aspenhr.com/wp-content/uploads/2024/02/noto-desktop-computer.svg" alt="White Collar" title="White Collar">White Collar' ):
if($F7 == 'Alabama'):
$F1 + $F2 + ( $F1 * ($F3/100) ) + ($F1 * .0765) + (.028 * 8000 ) + 420 + ($F1 * .002) + $F10
elseif($F7 == 'Alaska'):
$F1 + $F2 + ( $F1 * ($F3/100) ) + ($F1 * .0765) + (.032 * 48600 ) + 420 + ($F1 * .002) + $F10
elseif($F7 == 'Arizona'):
$F1 + $F2 + ( $F1 * ($F3/100) ) + ($F1 * .0765) + (.094 * 8000 ) + 420 + ($F1 * .002) + $F10
elseif($F7 == 'Arkansas'):
$F1 + $F2 + ( $F1 * ($F3/100) ) + ($F1 * .0765) + (.072 * 7000 ) + 420 + ($F1 * .002) + $F10
elseif($F7 == 'California'):
$F1 + $F2 + ( $F1 * ($F3/100) ) + ($F1 * .0765) + (.039 * 7000 ) + 420 + ($F1 * .002) + $F10
elseif($F7 == 'Colorado'):
$F1 + $F2 + ( $F1 * ($F3/100) ) + ($F1 * .0765) + (.055 * 23800 ) + 420 + ($F1 * .002) + $F10
elseif($F7 == 'Connecticut'):
$F1 + $F2 + ( $F1 * ($F3/100) ) + ($F1 * .0765) + (.041 * 25000 ) + 420 + ($F1 * .002) + $F10
elseif($F7 == 'Delaware'):
$F1 + $F2 + ( $F1 * ($F3/100) ) + ($F1 * .0765) + (.042 * 10500 ) + 420 + ($F1 * .002) + $F10
elseif($F7 == 'Florida'):
$F1 + $F2 + ( $F1 * ($F3/100) ) + ($F1 * .0765) + (.027 * 7000 ) + 420 + ($F1 * .002) + $F10
elseif($F7 == 'Georgia'):
$F1 + $F2 + ( $F1 * ($F3/100) ) + ($F1 * .0765) + (.040 * 9500 ) + 420 + ($F1 * .002) + $F10
elseif($F7 == 'Hawaii'):
$F1 + $F2 + ( $F1 * ($F3/100) ) + ($F1 * .0765) + (.037 * 61800 ) + 420 + ($F1 * .002) + $F10
elseif($F7 == 'Idaho'):
$F1 + $F2 + ( $F1 * ($F3/100) ) + ($F1 * .0765) + (.028 * 53300 ) + 420 + ($F1 * .002) + $F10
elseif($F7 == 'Illinois'):
$F1 + $F2 + ( $F1 * ($F3/100) ) + ($F1 * .0765) + (.047 * 13271 ) + 420 + ($F1 * .002) + $F10
elseif($F7 == 'Indiana'):
$F1 + $F2 + ( $F1 * ($F3/100) ) + ($F1 * .0765) + (.039 * 9500 ) + 420 + ($F1 * .002) + $F10
elseif($F7 == 'Iowa'):
$F1 + $F2 + ( $F1 * ($F3/100) ) + ($F1 * .0765) + (.035 * 38200 ) + 420 + ($F1 * .002) + $F10
elseif($F7 == 'Kansas'):
$F1 + $F2 + ( $F1 * ($F3/100) ) + ($F1 * .0765) + (.032 * 14000 ) + 420 + ($F1 * .002) + $F10
elseif($F7 == 'Kentucky'):
$F1 + $F2 + ( $F1 * ($F3/100) ) + ($F1 * .0765) + (.046 * 11400 ) + 420 + ($F1 * .002) + $F10
elseif($F7 == 'Louisiana'):
$F1 + $F2 + ( $F1 * ($F3/100) ) + ($F1 * .0765) + (.031 * 7700 ) + 420 + ($F1 * .002) + $F10
elseif($F7 == 'Maine'):
$F1 + $F2 + ( $F1 * ($F3/100) ) + ($F1 * .0765) + (.029 * 12000 ) + 420 + ($F1 * .002) + $F10
elseif($F7 == 'Maryland'):
$F1 + $F2 + ( $F1 * ($F3/100) ) + ($F1 * .0765) + (.057 * 8500 ) + 420 + ($F1 * .002) + $F10
elseif($F7 == 'Massachusetts'):
$F1 + $F2 + ( $F1 * ($F3/100) ) + ($F1 * .0765) + (.010 * 15000 ) + 420 + ($F1 * .002) + $F10
elseif($F7 == 'Michigan'):
$F1 + $F2 + ( $F1 * ($F3/100) ) + ($F1 * .0765) + (.051 * 9500 ) + 420 + ($F1 * .002) + $F10
elseif($F7 == 'Minnesota'):
$F1 + $F2 + ( $F1 * ($F3/100) ) + ($F1 * .0765) + (.046 * 42000 ) + 420 + ($F1 * .002) + $F10
elseif($F7 == 'Mississippi'):
$F1 + $F2 + ( $F1 * ($F3/100) ) + ($F1 * .0765) + (.029 * 14000 ) + 420 + ($F1 * .002) + $F10
elseif($F7 == 'Missouri'):
$F1 + $F2 + ( $F1 * ($F3/100) ) + ($F1 * .0765) + (.034 * 10000 ) + 420 + ($F1 * .002) + $F10
elseif($F7 == 'Montana'):
$F1 + $F2 + ( $F1 * ($F3/100) ) + ($F1 * .0765) + (.032 * 43000 ) + 420 + ($F1 * .002) + $F10
elseif($F7 == 'Nebraska'):
$F1 + $F2 + ( $F1 * ($F3/100) ) + ($F1 * .0765) + (.027 * 9000 ) + 420 + ($F1 * .002) + $F10
elseif($F7 == 'Nevada'):
$F1 + $F2 + ( $F1 * ($F3/100) ) + ($F1 * .0765) + (.028 * 40600 ) + 420 + ($F1 * .002) + $F10
elseif($F7 == 'New Hampshire'):
$F1 + $F2 + ( $F1 * ($F3/100) ) + ($F1 * .0765) + (.043 * 14000 ) + 420 + ($F1 * .002) + $F10
elseif($F7 == 'New Jersey'):
$F1 + $F2 + ( $F1 * ($F3/100) ) + ($F1 * .0765) + (.035 * 42300 ) + 420 + ($F1 * .002) + $F10
elseif($F7 == 'New Mexico'):
$F1 + $F2 + ( $F1 * ($F3/100) ) + ($F1 * .0765) + (.033 * 31500 ) + 420 + ($F1 * .002) + $F10
elseif($F7 == 'New York'):
$F1 + $F2 + ( $F1 * ($F3/100) ) + ($F1 * .0765) + (.060 * 12500 ) + 420 + ($F1 * .002) + $F10
elseif($F7 == 'North Carolina'):
$F1 + $F2 + ( $F1 * ($F3/100) ) + ($F1 * .0765) + (.029 * 31200 ) + 420 + ($F1 * .002) + $F10
elseif($F7 == 'North Dakota'):
$F1 + $F2 + ( $F1 * ($F3/100) ) + ($F1 * .0765) + (.050 * 43200 ) + 420 + ($F1 * .002) + $F10
elseif($F7 == 'Ohio'):
$F1 + $F2 + ( $F1 * ($F3/100) ) + ($F1 * .0765) + (.055 * 9000 ) + 420 + ($F1 * .002) + $F10
elseif($F7 == 'Oklahoma'):
$F1 + $F2 + ( $F1 * ($F3/100) ) + ($F1 * .0765) + (.047 * 27000 ) + 420 + ($F1 * .002) + $F10
elseif($F7 == 'Oregon'):
$F1 + $F2 + ( $F1 * ($F3/100) ) + ($F1 * .0765) + (.030 * 54100 ) + 420 + ($F1 * .002) + $F10
elseif($F7 == 'Pennsylvania'):
$F1 + $F2 + ( $F1 * ($F3/100) ) + ($F1 * .0765) + (.057 * 10000 ) + 420 + ($F1 * .002) + $F10
elseif($F7 == 'Rhode Island'):
$F1 + $F2 + ( $F1 * ($F3/100) ) + ($F1 * .0765) + (.054 * 31800 ) + 420 + ($F1 * .002) + $F10
elseif($F7 == 'South Carolina'):
$F1 + $F2 + ( $F1 * ($F3/100) ) + ($F1 * .0765) + (.027 * 14000 ) + 420 + ($F1 * .002) + $F10
elseif($F7 == 'South Dakota'):
$F1 + $F2 + ( $F1 * ($F3/100) ) + ($F1 * .0765) + (.049 * 15000 ) + 420 + ($F1 * .002) + $F10
elseif($F7 == 'Tennessee'):
$F1 + $F2 + ( $F1 * ($F3/100) ) + ($F1 * .0765) + (.050 * 7000 ) + 420 + ($F1 * .002) + $F10
elseif($F7 == 'Texas'):
$F1 + $F2 + ( $F1 * ($F3/100) ) + ($F1 * .0765) + (.032 * 9000 ) + 420 + ($F1 * .002) + $F10
elseif($F7 == 'Utah'):
$F1 + $F2 + ( $F1 * ($F3/100) ) + ($F1 * .0765) + (.038 * 48000 ) + 420 + ($F1 * .002) + $F10
elseif($F7 == 'Vermont'):
$F1 + $F2 + ( $F1 * ($F3/100) ) + ($F1 * .0765) + (.029 * 14300 ) + 420 + ($F1 * .002) + $F10
elseif($F7 == 'Virginia'):
$F1 + $F2 + ( $F1 * ($F3/100) ) + ($F1 * .0765) + (.031 * 8000 ) + 420 + ($F1 * .002) + $F10
elseif($F7 == 'Washington'):
$F1 + $F2 + ( $F1 * ($F3/100) ) + ($F1 * .0765) + (.031 * 68500 ) + 420 + ($F1 * .002) + $F10
elseif($F7 == 'West Virginia'):
$F1 + $F2 + ( $F1 * ($F3/100) ) + ($F1 * .0765) + (.050 * 9000 ) + 420 + ($F1 * .002) + $F10
elseif($F7 == 'Wisconsin'):
$F1 + $F2 + ( $F1 * ($F3/100) ) + ($F1 * .0765) + (.060 * 14000 ) + 420 + ($F1 * .002) + $F10
elseif($F7 == 'Wyoming'):
$F1 + $F2 + ( $F1 * ($F3/100) ) + ($F1 * .0765) + (.042 * 30900 ) + 420 + ($F1 * .002) + $F10
endif;
else:
if($F7 == 'Alabama'):
$F1 + $F2 + ( $F1 * ($F3/100) ) + ($F1 * .0765) + (.028 * 8000 ) + 420 + ($F1 * .02) + $F10
elseif($F7 == 'Alaska'):
$F1 + $F2 + ( $F1 * ($F3/100) ) + ($F1 * .0765) + (.032 * 48600 ) + 420 + ($F1 * .02) + $F10
elseif($F7 == 'Arizona'):
$F1 + $F2 + ( $F1 * ($F3/100) ) + ($F1 * .0765) + (.094 * 8000 ) + 420 + ($F1 * .02) + $F10
elseif($F7 == 'Arkansas'):
$F1 + $F2 + ( $F1 * ($F3/100) ) + ($F1 * .0765) + (.072 * 7000 ) + 420 + ($F1 * .02) + $F10
elseif($F7 == 'California'):
$F1 + $F2 + ( $F1 * ($F3/100) ) + ($F1 * .0765) + (.039 * 7000 ) + 420 + ($F1 * .02) + $F10
elseif($F7 == 'Colorado'):
$F1 + $F2 + ( $F1 * ($F3/100) ) + ($F1 * .0765) + (.055 * 23800 ) + 420 + ($F1 * .02) + $F10
elseif($F7 == 'Connecticut'):
$F1 + $F2 + ( $F1 * ($F3/100) ) + ($F1 * .0765) + (.041 * 25000 ) + 420 + ($F1 * .02) + $F10
elseif($F7 == 'Delaware'):
$F1 + $F2 + ( $F1 * ($F3/100) ) + ($F1 * .0765) + (.042 * 10500 ) + 420 + ($F1 * .02) + $F10
elseif($F7 == 'Florida'):
$F1 + $F2 + ( $F1 * ($F3/100) ) + ($F1 * .0765) + (.027 * 7000 ) + 420 + ($F1 * .02) + $F10
elseif($F7 == 'Georgia'):
$F1 + $F2 + ( $F1 * ($F3/100) ) + ($F1 * .0765) + (.040 * 9500 ) + 420 + ($F1 * .02) + $F10
elseif($F7 == 'Hawaii'):
$F1 + $F2 + ( $F1 * ($F3/100) ) + ($F1 * .0765) + (.037 * 61800 ) + 420 + ($F1 * .02) + $F10
elseif($F7 == 'Idaho'):
$F1 + $F2 + ( $F1 * ($F3/100) ) + ($F1 * .0765) + (.028 * 53300 ) + 420 + ($F1 * .02) + $F10
elseif($F7 == 'Illinois'):
$F1 + $F2 + ( $F1 * ($F3/100) ) + ($F1 * .0765) + (.047 * 13271 ) + 420 + ($F1 * .02) + $F10
elseif($F7 == 'Indiana'):
$F1 + $F2 + ( $F1 * ($F3/100) ) + ($F1 * .0765) + (.039 * 9500 ) + 420 + ($F1 * .02) + $F10
elseif($F7 == 'Iowa'):
$F1 + $F2 + ( $F1 * ($F3/100) ) + ($F1 * .0765) + (.035 * 38200 ) + 420 + ($F1 * .02) + $F10
elseif($F7 == 'Kansas'):
$F1 + $F2 + ( $F1 * ($F3/100) ) + ($F1 * .0765) + (.032 * 14000 ) + 420 + ($F1 * .02) + $F10
elseif($F7 == 'Kentucky'):
$F1 + $F2 + ( $F1 * ($F3/100) ) + ($F1 * .0765) + (.046 * 11400 ) + 420 + ($F1 * .02) + $F10
elseif($F7 == 'Louisiana'):
$F1 + $F2 + ( $F1 * ($F3/100) ) + ($F1 * .0765) + (.031 * 7700 ) + 420 + ($F1 * .02) + $F10
elseif($F7 == 'Maine'):
$F1 + $F2 + ( $F1 * ($F3/100) ) + ($F1 * .0765) + (.029 * 12000 ) + 420 + ($F1 * .02) + $F10
elseif($F7 == 'Maryland'):
$F1 + $F2 + ( $F1 * ($F3/100) ) + ($F1 * .0765) + (.057 * 8500 ) + 420 + ($F1 * .02) + $F10
elseif($F7 == 'Massachusetts'):
$F1 + $F2 + ( $F1 * ($F3/100) ) + ($F1 * .0765) + (.010 * 15000 ) + 420 + ($F1 * .02) + $F10
elseif($F7 == 'Michigan'):
$F1 + $F2 + ( $F1 * ($F3/100) ) + ($F1 * .0765) + (.051 * 9500 ) + 420 + ($F1 * .02) + $F10
elseif($F7 == 'Minnesota'):
$F1 + $F2 + ( $F1 * ($F3/100) ) + ($F1 * .0765) + (.046 * 42000 ) + 420 + ($F1 * .02) + $F10
elseif($F7 == 'Mississippi'):
$F1 + $F2 + ( $F1 * ($F3/100) ) + ($F1 * .0765) + (.029 * 14000 ) + 420 + ($F1 * .02) + $F10
elseif($F7 == 'Missouri'):
$F1 + $F2 + ( $F1 * ($F3/100) ) + ($F1 * .0765) + (.034 * 10000 ) + 420 + ($F1 * .02) + $F10
elseif($F7 == 'Montana'):
$F1 + $F2 + ( $F1 * ($F3/100) ) + ($F1 * .0765) + (.032 * 43000 ) + 420 + ($F1 * .02) + $F10
elseif($F7 == 'Nebraska'):
$F1 + $F2 + ( $F1 * ($F3/100) ) + ($F1 * .0765) + (.027 * 9000 ) + 420 + ($F1 * .02) + $F10
elseif($F7 == 'Nevada'):
$F1 + $F2 + ( $F1 * ($F3/100) ) + ($F1 * .0765) + (.028 * 40600 ) + 420 + ($F1 * .02) + $F10
elseif($F7 == 'New Hampshire'):
$F1 + $F2 + ( $F1 * ($F3/100) ) + ($F1 * .0765) + (.043 * 14000 ) + 420 + ($F1 * .02) + $F10
elseif($F7 == 'New Jersey'):
$F1 + $F2 + ( $F1 * ($F3/100) ) + ($F1 * .0765) + (.035 * 42300 ) + 420 + ($F1 * .02) + $F10
elseif($F7 == 'New Mexico'):
$F1 + $F2 + ( $F1 * ($F3/100) ) + ($F1 * .0765) + (.033 * 31500 ) + 420 + ($F1 * .02) + $F10
elseif($F7 == 'New York'):
$F1 + $F2 + ( $F1 * ($F3/100) ) + ($F1 * .0765) + (.060 * 12500 ) + 420 + ($F1 * .02) + $F10
elseif($F7 == 'North Carolina'):
$F1 + $F2 + ( $F1 * ($F3/100) ) + ($F1 * .0765) + (.029 * 31200 ) + 420 + ($F1 * .02) + $F10
elseif($F7 == 'North Dakota'):
$F1 + $F2 + ( $F1 * ($F3/100) ) + ($F1 * .0765) + (.050 * 43200 ) + 420 + ($F1 * .02) + $F10
elseif($F7 == 'Ohio'):
$F1 + $F2 + ( $F1 * ($F3/100) ) + ($F1 * .0765) + (.055 * 9000 ) + 420 + ($F1 * .02) + $F10
elseif($F7 == 'Oklahoma'):
$F1 + $F2 + ( $F1 * ($F3/100) ) + ($F1 * .0765) + (.047 * 27000 ) + 420 + ($F1 * .02) + $F10
elseif($F7 == 'Oregon'):
$F1 + $F2 + ( $F1 * ($F3/100) ) + ($F1 * .0765) + (.030 * 54100 ) + 420 + ($F1 * .02) + $F10
elseif($F7 == 'Pennsylvania'):
$F1 + $F2 + ( $F1 * ($F3/100) ) + ($F1 * .0765) + (.057 * 10000 ) + 420 + ($F1 * .02) + $F10
elseif($F7 == 'Rhode Island'):
$F1 + $F2 + ( $F1 * ($F3/100) ) + ($F1 * .0765) + (.054 * 31800 ) + 420 + ($F1 * .02) + $F10
elseif($F7 == 'South Carolina'):
$F1 + $F2 + ( $F1 * ($F3/100) ) + ($F1 * .0765) + (.027 * 14000 ) + 420 + ($F1 * .02) + $F10
elseif($F7 == 'South Dakota'):
$F1 + $F2 + ( $F1 * ($F3/100) ) + ($F1 * .0765) + (.049 * 15000 ) + 420 + ($F1 * .02) + $F10
elseif($F7 == 'Tennessee'):
$F1 + $F2 + ( $F1 * ($F3/100) ) + ($F1 * .0765) + (.050 * 7000 ) + 420 + ($F1 * .02) + $F10
elseif($F7 == 'Texas'):
$F1 + $F2 + ( $F1 * ($F3/100) ) + ($F1 * .0765) + (.032 * 9000 ) + 420 + ($F1 * .02) + $F10
elseif($F7 == 'Utah'):
$F1 + $F2 + ( $F1 * ($F3/100) ) + ($F1 * .0765) + (.038 * 48000 ) + 420 + ($F1 * .02) + $F10
elseif($F7 == 'Vermont'):
$F1 + $F2 + ( $F1 * ($F3/100) ) + ($F1 * .0765) + (.029 * 14300 ) + 420 + ($F1 * .02) + $F10
elseif($F7 == 'Virginia'):
$F1 + $F2 + ( $F1 * ($F3/100) ) + ($F1 * .0765) + (.031 * 8000 ) + 420 + ($F1 * .02) + $F10
elseif($F7 == 'Washington'):
$F1 + $F2 + ( $F1 * ($F3/100) ) + ($F1 * .0765) + (.031 * 68500 ) + 420 + ($F1 * .02) + $F10
elseif($F7 == 'West Virginia'):
$F1 + $F2 + ( $F1 * ($F3/100) ) + ($F1 * .0765) + (.050 * 9000 ) + 420 + ($F1 * .02) + $F10
elseif($F7 == 'Wisconsin'):
$F1 + $F2 + ( $F1 * ($F3/100) ) + ($F1 * .0765) + (.060 * 14000 ) + 420 + ($F1 * .02) + $F10
elseif($F7 == 'Wyoming'):
$F1 + $F2 + ( $F1 * ($F3/100) ) + ($F1 * .0765) + (.042 * 30900 ) + 420 + ($F1 * .02) + $F10
endif;
endif;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment