Spreadsheet: 104284d1301931298-how-to-make-excel-do-multiple-calculations-summer-11-pell-calculator-tester-
Sheet: Year1

YES/NO | SUMMER PELL |  |  |  |  |  |  |  |  | YEAR | 10/11
 | EFC |  | FT | TQ | HT | LTH |  |  |  |  |  |  |  | YES/NO |  |  | FT | TQ | HT | LHT
 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 5550 | 4163 | 2775 | 1388
 | 1 | 100 |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 100 | 5500 | 4125 | 2750 | 1375
 | 101 | 200 |  |  |  |  |  |  |  | EFC |  |  |  |  | 101 | 200 | 5400 | 4050 | 2700 | 1350
 | 201 | 300 |  |  |  |  |  |  |  | Number of Credits |  |  |  |  | 201 | 300 | 5300 | 3975 | 2650 | 1325
 | 301 | 400 |  |  |  |  |  |  |  |  |  |  |  |  | 301 | 400 | 5200 | 3900 | 2600 | 1300
 | 401 | 500 |  |  |  |  |  |  |  |  |  |  |  |  | 401 | 500 | 5100 | 3825 | 2550 | 1275
 | 501 | 600 |  |  |  |  |  |  |  | AWARD |  |  |  |  | 501 | 600 | 5000 | 3750 | 2500 | 1250
 | 601 | 700 |  |  |  |  |  |  |  |  |  |  |  |  | 601 | 700 | 4900 | 3675 | 2450 | 1225
 | 701 | 800 |  |  |  |  |  |  |  |  |  |  |  |  | 701 | 800 | 4800 | 3600 | 2400 | 1200
 | 801 | 900 |  |  |  |  |  |  |  |  |  |  |  |  | 801 | 900 | 4700 | 3525 | 2350 | 1175
 | 901 | 1000 |  |  |  |  |  |  |  |  |  |  |  |  | 901 | 1000 | 4600 | 3450 | 2300 | 1150
 | 1001 | 1100 |  |  |  |  |  |  |  |  |  |  |  |  | 1001 | 1100 | 4500 | 3375 | 2250 | 1125
 | 1101 | 1200 |  |  |  |  |  |  |  |  |  |  |  |  | 1101 | 1200 | 4400 | 3300 | 2200 | 1100
 | 1201 | 1300 |  |  |  |  |  |  |  |  |  |  |  |  | 1201 | 1300 | 4300 | 3225 | 2150 | 1075
 | 1301 | 1400 |  |  |  |  |  |  |  |  |  |  |  |  | 1301 | 1400 | 4200 | 3150 | 2100 | 1050
 | 1401 | 1500 |  |  |  |  |  |  |  |  |  |  |  |  | 1401 | 1500 | 4100 | 3075 | 2050 | 1025
 | 1501 | 1600 |  |  |  |  |  |  |  |  |  |  |  |  | 1501 | 1600 | 4000 | 3000 | 2000 | 1000
 | 1601 | 1700 |  |  |  |  |  |  |  | Scheduled Award |  |  |  |  | 1601 | 1700 | 3900 | 2925 | 1950 | 975
 | 1701 | 1800 |  |  |  |  |  |  |  |  |  |  |  |  | 1701 | 1800 | 3800 | 2850 | 1900 | 950
 | 1801 | 1900 |  |  |  |  |  |  |  |  |  |  |  |  | 1801 | 1900 | 3700 | 2775 | 1850 | 925
 | 1901 | 2000 |  |  |  |  |  |  |  |  |  |  |  |  | 1901 | 2000 | 3600 | 2700 | 1800 | 900
 | 2001 | 2100 |  |  |  |  |  |  |  |  |  |  |  |  | 2001 | 2100 | 3500 | 2625 | 1750 | 875
 | 2101 | 2200 |  |  |  |  |  |  |  |  |  |  |  |  | 2101 | 2200 | 3400 | 2550 | 1700 | 850
 | 2201 | 2300 |  |  |  |  |  |  |  |  |  |  |  |  | 2201 | 2300 | 3300 | 2475 | 1650 | 825
 | 2301 | 2400 |  |  |  |  |  |  |  |  |  |  |  |  | 2301 | 2400 | 3200 | 2400 | 1600 | 800
 | 2401 | 2500 |  |  |  |  |  |  |  |  |  |  |  |  | 2401 | 2500 | 3100 | 2325 | 1550 | 775
 | 2501 | 2600 |  |  |  |  |  |  |  |  |  |  |  |  | 2501 | 2600 | 3000 | 2250 | 1500 | 750
 | 2601 | 2700 |  |  |  |  |  |  |  |  |  |  |  |  | 2601 | 2700 | 2900 | 2175 | 1450 | 725
 | 2701 | 2800 |  |  |  |  |  |  |  |  |  |  |  |  | 2701 | 2800 | 2800 | 2100 | 1400 | 700
 | 2801 | 2900 |  |  |  |  |  |  |  |  |  |  |  |  | 2801 | 2900 | 2700 | 2025 | 1350 | 675
 | 2901 | 3000 |  |  |  |  |  |  |  |  |  |  |  |  | 2901 | 3000 | 2600 | 1950 | 1300 | 659
 | 3001 | 3100 |  |  |  |  |  |  |  |  |  |  |  |  | 3001 | 3100 | 2500 | 1875 | 1250 | 659
 | 3101 | 3200 |  |  |  |  |  |  |  |  |  |  |  |  | 3101 | 3200 | 2400 | 1800 | 1200 | 659
 | 3201 | 3300 |  |  |  |  |  |  |  |  |  |  |  |  | 3201 | 3300 | 2300 | 1725 | 1150 | 659
 | 3301 | 3400 |  |  |  |  |  |  |  |  |  |  |  |  | 3301 | 3400 | 2200 | 1650 | 1100 | 659
 | 3401 | 3500 |  |  |  |  |  |  |  |  |  |  |  |  | 3401 | 3500 | 2100 | 1575 | 1050 | 659
 | 3501 | 3600 |  |  |  |  |  |  |  |  |  |  |  |  | 3501 | 3600 | 2000 | 1500 | 1000 | 659
 | 3601 | 3700 |  |  |  |  |  |  |  |  |  |  |  |  | 3601 | 3700 | 1900 | 1425 | 950 | 659
 | 3701 | 3800 |  |  |  |  |  |  |  |  |  |  |  |  | 3701 | 3800 | 1800 | 1350 | 900 | 659
 | 3801 | 3900 |  |  |  |  |  |  |  |  |  |  |  |  | 3801 | 3900 | 1700 | 1275 | 850 | 659
 | 3901 | 4000 |  |  |  |  |  |  |  |  |  |  |  |  | 3901 | 4000 | 1600 | 1200 | 831 | 555
 | 4001 | 4100 |  |  |  |  |  |  |  |  |  |  |  |  | 4001 | 4100 | 1500 | 1125 | 831 | 555
 | 4101 | 4200 |  |  |  |  |  |  |  |  |  |  |  |  | 4101 | 4200 | 1400 | 1050 | 831 | 555
 | 4201 | 4300 |  |  |  |  |  |  |  |  |  |  |  |  | 4201 | 4300 | 1300 | 1004 | 831 | 555
 | 4301 | 4400 |  |  |  |  |  |  |  |  |  |  |  |  | 4301 | 4400 | 1200 | 1004 | 831 | 555
 | 4401 | 4500 |  |  |  |  |  |  |  |  |  |  |  |  | 4401 | 4500 | 1176 | 1004 | 555 | 0
 | 4501 | 4600 |  |  |  |  |  |  |  |  |  |  |  |  | 4501 | 4600 | 1176 | 750 | 555 | 0
 | 4601 | 4700 |  |  |  |  |  |  |  |  |  |  |  |  | 4601 | 4700 | 1176 | 675 | 555 | 0
 | 4701 | 4800 |  |  |  |  |  |  |  |  |  |  |  |  | 4701 | 4800 | 800 | 600 | 555 | 0
 | 4801 | 4900 |  |  |  |  |  |  |  |  |  |  |  |  | 4801 | 4900 | 700 | 555 | 555 | 0
 | 4901 | 5000 |  |  |  |  |  |  |  |  |  |  |  |  | 4901 | 5000 | 600 | 555 | 555 | 0
 | 5001 | 5100 |  |  |  |  |  |  |  |  |  |  |  |  | 5001 | 5100 | 555 | 555 | 0 | 0
 | 5101 | 5200 |  |  |  |  |  |  |  |  |  |  |  |  | 5101 | 5200 | 555 | 555 | 0 | 0
 | 5201 | 5273 |  |  |  |  |  |  |  |  |  |  |  |  | 5201 | 5273 | 555 | 0 | 0 | 0
 | 5274 | 999999 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  | 5274 | 999999 | 0 | 0 | 0 | 0