Last active
April 2, 2024 20:19
-
-
Save zakirsajib/76997f625fc91b6808fcdf650acf6f4c to your computer and use it in GitHub Desktop.
States Formulas
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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