Spreadsheet: 43514d1242155597-excel-2007-formula-automation-input-field-excel1
Sheet: Sheet1

Anniston, AL |  |  | Population | # of SMB's | [NAME]. Fees | AD Price
 | Calhoun, AL |  | 2 | 1 | 15000 | 3750 |  | F3 result should be the d2+e2 multiplied by 5000
 |  | Totals: | 2 | 1 | 15000 | 6250 |  | [NAME] should be 25% of F3
Auburn-Opelika, AL |  |  | Population | # of SMB's | [NAME]. Fees | AD Price |  | F4 result should be the sum above rows
 | [NAME], AL |  | 2 | 1 | 15000 | 3750 |  | G4 result should be 25% of F4 plus $2500
 |  | Totals: | 2 | 1 | 15000 | 6250
Birmingham, AL |  |  | Population | # of SMB's | [NAME]. Fees | AD Price
 | Blount, AL |  | 1 | 1 | 10000 | 2500
 | Jefferson, AL |  | 11 | 6 | 85000 | 21250
 | Shelby, AL |  | 2 | 1 | 15000 | 3750
 | St. Clair, AL |  | 2 | 1 | 15000 | 3750
 |  | Totals: | 16 | 9 | 125000 | 33750
Decatur, AL |  |  | Population | # of SMB's | [NAME]. Fees | AD Price
 | [NAME], AL |  | 1 | 1 | 10000 | 2500
 | Morgan, AL |  | 2 | 1 | 15000 | 3750
 |  | Totals: | 3 | 2 | 25000 | 8750
Dothan, AL |  |  | Population | # of SMB's | [NAME]. Fees | AD Price
 | Dale, AL |  | 1 | 1 | 10000 | 2500
 | Houston, AL |  | 1 | 1 | 10000 | 2500
 |  | Totals: | 2 | 2 | 20000 | 7500
Florence, AL |  |  | Population | # of SMB's | [NAME]. Fees | AD Price
 | Colbert, AL |  | 1 | 1 | 10000 | 2500
 | Lauderdale, AL |  | 1 | 1 | 10000 | 2500
 |  | Totals: | 2 | 2 | 20000 | 7500
Gadsden, AL |  |  | Population | # of SMB's | [NAME]. Fees | AD Price
 | Etowah, AL |  | 2 | 1 | 15000 | 3750
 |  | Totals: | 2 | 1 | 15000 | 6250
Huntsville, AL |  |  | Population | # of SMB's | [NAME]. Fees | AD Price
 | Limestone, AL |  | 1 | 1 | 10000 | 2500
 | [NAME], AL |  | 5 | 3 | 40000 | 10000
 |  | Totals: | 6 | 4 | 50000 | 15000
Mobile, AL |  |  | Population | # of SMB's | [NAME]. Fees | AD Price
 | Baldwin, AL |  | 3 | 1 | 20000 | 5000
 | Mobile, AL |  | 6 | 3 | 45000 | 11250
 |  | Totals: | 9 | 4 | 65000 | 18750
Montgomery, AL |  |  | Population | # of SMB's | [NAME]. Fees | AD Price
 | Autauga, AL |  | 1 | 1 | 10000 | 2500
 | Elmore, AL |  | 1 | 1 | 10000 | 2500
 | Montgomery, AL |  | 4 | 2 | 30000 | 7500
 |  | Totals: | 6 | 4 | 50000 | 15000
Tuscaloosa, AL |  |  | Population | # of SMB's | [NAME]. Fees | AD Price
 | Tuscaloosa, AL |  | 2 | 1 | 15000 | 3750
 |  | Totals: | 2 | 1 | 15000 | 6250
Anchorage, AK |  |  | Population | # of SMB's | [NAME]. Fees | AD Price
 | Anchorage, AK |  | 4 | 3 | 35000 | 8750
 |  | Totals: | 4 | 3 | 35000 | 11250
Flagstaff, AZ-UT |  |  | Population | # of SMB's | [NAME]. Fees | AD Price
 | Coconino, AZ |  | 2 | 1 | 15000 | 3750
 | [NAME], UT |  | 1 | 1 | 10000 | 2500
 | Yavapai, AZ |  | 3 | 2 | 25000 | 6250
 |  | Totals: | 6 | 4 | 50000 | 15000
Phoenix-Mesa, AZ |  |  | Population | # of SMB's | [NAME]. Fees | AD Price
 | Maricopa, AZ |  | 47 | 23 | 350000 | 87500
 | Pinal, AZ |  | 2 | 1 | 15000 | 3750
 |  | Totals: | 49 | 24 | 365000 | 93750
Tucson, AZ |  |  | Population | # of SMB's | [NAME]. Fees | AD Price
 | Pima, AZ |  | 13 | 6 | 95000 | 23750
 |  | Totals: | 13 | 6 | 95000 | 26250
Fayetteville-Springdale-Rogers, AR |  |  | Population | # of SMB's | [NAME]. Fees | AD Price
 | [NAME], AR |  | 3 | 1 | 20000 | 5000
 | Washington, AR |  | 3 | 1 | 20000 | 5000
 |  | Totals: | 6 | 2 | 40000 | 12500
[NAME], AR-OK |  |  | Population | # of SMB's | [NAME]. Fees | AD Price
 | Crawford, AR |  | 1 | 1 | 10000 | 2500
 | [NAME], AR |  | 1 | 1 | 10000 | 2500
 | Sequoyah, OK |  | 1 | 1 | 10000 | 2500
 |  | Totals: | 3 | 3 | 30000 | 10000
Jonesboro, AR |  |  | Population | # of SMB's | [NAME]. Fees | AD Price
 | Craighead, AR |  | 1 | 1 | 10000 | 2500
 |  | Totals: | 1 | 1 | 10000 | 5000
[NAME] Little Rock, AR |  |  | Population | # of SMB's | [NAME]. Fees | AD Price
 | Faulkner, [NAME] |  | 1 | 1 | 10000 | 2500
 | Lonoke, AR |  | 1 | 1 | 10000 | 2500
 | Pulaski, AR |  | 6 | 4 | 50000 | 12500
 | Saline, AR |  | 1 | 1 | 10000 | 2500
 |  | Totals: | 9 | 7 | 80000 | 22500
Pine Bluff, AR |  |  | Population | # of SMB's | [NAME]. Fees | AD Price
 | [NAME], AR |  | 1 | 1 | 10000 | 2500
 |  | Totals: | 1 | 1 | 10000 | 5000
Bakersfield, CA |  |  | Population | # of SMB's | [NAME]. Fees | AD Price
 | Kern, CA |  | 9 | 4 | 65000 | 16250
 |  | Totals: | 9 | 4 | 65000 | 18750
Chico-Paradise, CA |  |  | Population | # of SMB's | [NAME]. Fees | AD Price
 | Butte, CA |  | 4 | 2 | 30000 | 7500
 |  | Totals: | 4 | 2 | 30000 | 10000