Spreadsheet: 825212d1681177939-add-not-to-exceed-to-the-sum-formula-add-not-to-exceed-to-the-sum-formula
Sheet: Data Validation

Specific Technical Expertise
 |  | IF(I2="References 9 or more different areas of activity and/or terms = 10 pts",10,IF(I2="References 4-8 different areas of activity and/or terms = 7 pts",7,IF(I2="References 2-3 different areas of activity and/or terms = 4 pts",4,IF(I2="References 1 area of activity or term = 1 pt",1,IF(I2="References 0 areas of activitiy or terms = 0 pts",0,0)))))
[NAME]:
References 9 or more different areas of activity and/or terms = 10 pts
References 4-8 different areas of activity and/or terms = 7 pts
References 2-3 different areas of activity and/or terms = 4 pts
References 1 area of activity or term = 1 pt
References 0 areas of activitiy or terms = 0 pts
 |  | IF(K2="References 4 or more different areas of activity and/or terms = 8 pts",8, IF(K2="References 2-3 different areas of activity and/or terms = 4 pts",4,IF(K2="References 1 area of activity or term = 1 pt",1,IF(K2="References 0 areas of activitiy or terms = 0 pts",0,0))))
Guidance/Policy (Industry/Government):
References 4 or more different areas of activity and/or terms = 8 pts
References 2-3 different areas of activity and/or terms = 4 pts
References 1 area of activity or term = 1 pt
References 0 areas of activity or terms = 0 pts
 |  | IF(M2="References 4 or more different areas of activity and/or terms = 8 pts",8, IF(M2="References 2-3 different areas of activity and/or terms = 4 pts",4,IF(M2="References 1 area of activity or term = 1 pt",1,IF(M2="References 0 areas of activitiy or terms = 0 pts",0,0))))
[NAME], Trouble Shooting, Analytical Skills, etc:
References 4 or more different areas of activity and/or terms = 8 pts
References 2-3 different areas of activity and/or terms = 4 pts
References 1 area of activity or term = 1 pt
References 0 areas of activity or terms = 0 pts
 |  | IF(O2="References 4 or more different areas of activity and/or terms = 4 pts",4, IF(O2="References 2-3 different areas of activity and/or terms = 2 pts",2,IF(O2="References 1 different activity or term = 1 pt",1,IF(O2="References 0 areas of activitiy or terms = 0 pts",0,0))))
Computer Skills:
References 4 or more different areas of activity and/or terms = 4 pts
References 2-3 different areas of activity and/or terms = 2 pts
References 1 different activity or term = 1 pt
References 0 areas of activity or terms = 0 pts
Diversity/Corporate Experience
 |  | IF(ISNUMBER(SEARCH("Industry/Non-Federal",S2)),5,IF(ISNUMBER(SEARCH("Unit/Squadron",S2)),5,IF(ISNUMBER(SEARCH("Group",S2)),5,IF(ISNUMBER(SEARCH("Wing",S2)),5,IF(ISNUMBER(SEARCH("Center",S2)),5,IF(ISNUMBER(SEARCH("ALC",S2)),5,IF(ISNUMBER(SEARCH("MAJCOM",S2)),5,0))))))
Industry/Non-Federal
Unit/Squadron
Group
Wing
Center
OC/ALC
MAJCOM
Relevant Experience
Non-Federal/Government Inventory Management- 6+ yrs= 40 pts |  | IF(ISNUMBER(SEARCH("6+ yrs= 40 pts", B2)),40,IF(ISNUMBER(SEARCH("4-5.99= 30 pts", B2)),30,IF(ISNUMBER(SEARCH("2-3.99 yrs= 20 pts",B2)),20,IF(ISNUMBER(SEARCH("<2yrs= 10 pts",B2)),10,0))))))))  IF(ISNUMBER(SEARCH("6+ yrs= 40 pts",D2)),40,IF(ISNUMBER(SEARCH("4-5.99= 30 pts", D2)),30,IF(ISNUMBER(SEARCH("2-3.99 yrs= 20 pts",D2)),20,IF(ISNUMBER(SEARCH("<2yrs= 10 pts",D2)),10,0))))))))  IF(ISNUMBER(SEARCH("6+ yrs= 40 pts", G2)),40,IF(ISNUMBER(SEARCH("4-5.99= 30 pts", G2)),30,IF(ISNUMBER(SEARCH("2-3.99 yrs= 20 pts",G2)),20,IF(ISNUMBER(SEARCH("<2yrs= 10 pts",G2)),10,0))))))))
Non-Federal/Government Inventory Management- 4-5.99 yrs= 30 pts
Non-Federal/Government Inventory Management- 2-3.99 yrs= 20 pts
Non-Federal/Government Inventory Management- <2yrs= 10 pts
Non-Federal/Government Supervisor/Management Experience- 6+ yrs= 40 pts
Non-Federal/Government Supervisor/Management [NAME]5.99 yrs= 30 pts
Non-Federal/Government Supervisor/Management Experience- 2-3.99 yrs= 20 pts
Non-Federal/Government Supervisor/Management Experience- <2yrs= 10 pts
FWS Experience (List Series)- 6+ yrs= 40 pts
FWS Experience (List Series)- 4-5.99 yrs= 30 pts
FWS Experience (List Series)- 2-3.99 yrs= 20 pts
FWS Experience (List Series)- <2yrs= 10 pts
Non-Federal/Government Supply Chain Management- 6+ yrs= 40 pts
Non-Federal/Government Supply Chain [NAME]5.99 yrs= 30 pts
Non-Federal/Government Supply Chain Management- 2-3.99 yrs= 20 pts
Non-Federal/Government Supply Chain [NAME] <2yrs= 10 pts
Non-Federal/Government Mechanic Experience- 6+ yrs= 40 pts
Non-Federal/Government Mechanic Experience- 4-5.99 yrs= 30 pts
Non-Federal/Government Mechanic Experience- 2-3.99 yrs= 20 pts
Non-Federal/Government Mechanic Experience- <2yrs= 10 pts
Non-Federal/Government Teaching Experience- 6+ yrs= 40 pts
Non-Federal/Government Teaching Experience- 4-5.99 yrs= 30 pts
Non-Federal/Government Teaching Experience- 2-3.99 yrs= 20 pts
Non-Federal/Government Teaching Experience- <2yrs= 10 pts
Non-Federal/Government Procurement- 6+ yrs= 40 pts
Non-Federal/Government [NAME]5.99 yrs= 30 pts
Non-Federal/Government Procurement- 2-3.99 yrs= 20 pts
Non-Federal/Government Procurement- <2yrs= 10 pts
Non-Federal/Government Ops Management- 6+ yrs= 40 pts
Non-Federal/Government Ops Management- 4-5.99 yrs= 30 pts
Non-Federal/Government Ops Management- 2-3.99 yrs= 20 pts
Non-Federal/Government Ops Management- <2yrs= 10 pts
Other Relevant Government Experience (i.e. Military, other series, 0300s, 0200s, 1100s, etc.)- 6+ yrs= 40 pts
Other Relevant Government Experience (i.e. Military, other series, 0300s, 0200s, 1100s, etc.)- 4-5.99 yrs= 30 pts
Other Relevant Government Experience (i.e. Military, other series, 0300s, 0200s, 1100s, etc.)- 2-3.99 yrs= 20 pts
Other Relevant Government Experience (i.e. Military, other series, 0300s, 0200s, 1100s, etc.)- <2yrs= 10 pts