stevensimon10482
New Member
- Joined
- May 3, 2017
- Messages
- 2
Hello!
I am looking at two tables, and I need to return a "salary" (hourly wage) value based on an employee "step" that advances every year. In Table 2 below, in the orange fields, I'm looking to return the proper value, for each person, for the step they advance each year.
So, for example, in Status Quo Wages, in 2018 Abigail Brainard should be making $10.34, an Apple Picker's Step 3 Status Quo Salary.
I need to say, "Based on that year's Column F step in Table 2, xyz person will make the wages in Columns D through O." I've tried a bunch of nested IF functions but haven't quite got there.
<table cellspacing="0" border="0" verdana,="" arial,="" tahoma,="" calibri,="" geneva,="" sans-serif;"="" width=""><tbody>[TR]
[TD="align: left"][/TD]
[TD="align: left"]
[/TD]
[TD="align: center"][/TD]
[TD="align: left"][/TD]
[TD="align: left"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: left"][/TD]
[TD="align: left"][/TD]
[TD="align: left"][/TD]
[TD="align: left"][/TD]
[/TR]
</tbody></table><table cellspacing="0" border="0" width=""><colgroup width="180"></colgroup><colgroup width="127"></colgroup><colgroup span="2" width="80"></colgroup><colgroup width="113"></colgroup><colgroup span="3" width="80"></colgroup><colgroup width="75"></colgroup><colgroup span="10" width="80"></colgroup><tbody> [TR]
[TD="align: left"]TABLE 1[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[/TR]
[TR]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="colspan: 4, align: center"]Status Quo Salary Scale[/TD]
[TD="colspan: 4, align: center"]Proposed Salary Scale 2017[/TD]
[TD="colspan: 4, align: center"]Proposed Salary Scale 2018[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[/TR]
[TR]
[TD="align: center"]JobTitle[/TD]
[TD="align: center"]Job Code[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]4[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[/TR]
[TR]
[TD="bgcolor: #C5E0B4, align: left"]Apple Picker[/TD]
[TD="bgcolor: #C5E0B4, align: left"]AP[/TD]
[TD="bgcolor: #C5E0B4, align: left"]
[/TD]
[TD="bgcolor: #C5E0B4, align: right"] $10.10 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $10.22 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $10.34 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $10.46 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $10.13 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $10.25 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $10.37 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $10.49 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $10.76 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $10.89 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $11.01 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $11.14 [/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[/TR]
[TR]
[TD="bgcolor: #C5E0B4, align: left"]Berry Picker[/TD]
[TD="bgcolor: #C5E0B4, align: left"]BP[/TD]
[TD="bgcolor: #C5E0B4, align: left"]
[/TD]
[TD="bgcolor: #C5E0B4, align: right"] $11.10 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $11.22 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $11.34 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $11.46 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $11.13 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $11.25 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $11.37 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $11.49 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $11.82 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $11.95 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $12.08 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $12.21 [/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[/TR]
[TR]
[TD="bgcolor: #C5E0B4, align: left"]Cherry Picker[/TD]
[TD="bgcolor: #C5E0B4, align: left"]CP[/TD]
[TD="bgcolor: #C5E0B4, align: left"]
[/TD]
[TD="bgcolor: #C5E0B4, align: right"] $12.10 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $12.22 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $12.34 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $12.46 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $12.13 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $12.25 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $12.37 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $12.49 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $12.89 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $13.02 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $13.14 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $13.27 [/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[/TR]
[TR]
[TD="bgcolor: #C5E0B4, align: left"]Date Picker[/TD]
[TD="bgcolor: #C5E0B4, align: left"]DP[/TD]
[TD="bgcolor: #C5E0B4, align: left"]
[/TD]
[TD="bgcolor: #C5E0B4, align: right"] $13.10 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $13.22 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $13.34 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $13.46 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $13.13 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $13.25 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $13.37 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $13.49 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $13.95 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $14.08 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $14.21 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $14.34 [/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[/TR]
[TR]
[TD="bgcolor: #C5E0B4, align: left"]Grain Picker[/TD]
[TD="bgcolor: #C5E0B4, align: left"]GP[/TD]
[TD="bgcolor: #C5E0B4, align: left"]
[/TD]
[TD="bgcolor: #C5E0B4, align: right"] $14.10 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $14.22 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $14.34 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $14.46 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $14.14 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $14.26 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $14.38 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $14.50 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $15.02 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $15.15 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $15.27 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $15.40 [/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[/TR]
[TR]
[TD="bgcolor: #C5E0B4, align: left"]Loquat Picker[/TD]
[TD="bgcolor: #C5E0B4, align: left"]LP[/TD]
[TD="bgcolor: #C5E0B4, align: left"]
[/TD]
[TD="bgcolor: #C5E0B4, align: right"] $15.10 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $15.22 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $15.34 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $15.46 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $15.14 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $15.26 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $15.38 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $15.50 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $16.08 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $16.21 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $16.34 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $16.47 [/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[/TR]
[TR]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[/TR]
[TR]
[TD="align: left"]TABLE 2[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[/TR]
[TR]
[TD="align: center"]Name[/TD]
[TD="align: center"]Title[/TD]
[TD="align: center"]Code[/TD]
[TD="align: center"]Base Hourly[/TD]
[TD="align: center"]Hired[/TD]
[TD="align: center"]Step[/TD]
[TD="colspan: 4, align: center"]Step[/TD]
[TD="colspan: 3, align: center"]Status Quo Salary[/TD]
[TD="colspan: 3, align: center"]Proposed Salary 2017[/TD]
[TD="colspan: 3, align: center"]Proposed Salary 2018[/TD]
[/TR]
[TR]
[TD="align: center"]
[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]Step June 23, 2017[/TD]
[TD="align: center"]Step June 23, 2018[/TD]
[TD="align: center"]Step June 23, 2019[/TD]
[TD="align: center"]Step June 23, 2020[/TD]
[TD="align: center"]2017[/TD]
[TD="align: center"]2018[/TD]
[TD="align: center"]2019[/TD]
[TD="align: center"]2017[/TD]
[TD="align: center"]2018[/TD]
[TD="align: center"]2019[/TD]
[TD="align: center"]2017[/TD]
[TD="align: center"]2018[/TD]
[TD="align: center"]2019[/TD]
[/TR]
[TR]
[TD="align: left"]Abigail Brainard[/TD]
[TD="align: left"]Apple Picker[/TD]
[TD="align: center"]AP[/TD]
[TD="align: center"]$10.22[/TD]
[TD="align: right"]8/7/2015[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"]5[/TD]
[TD="align: center"]6[/TD]
[TD="bgcolor: #FFD966, align: left"]???[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[/TR]
[TR]
[TD="align: left"]Christine Davidson[/TD]
[TD="align: left"]Apple Picker[/TD]
[TD="align: center"]AP[/TD]
[TD="align: center"]$10.10[/TD]
[TD="align: right"]8/8/2014[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"]5[/TD]
[TD="bgcolor: #FFD966, align: left"]???[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[/TR]
[TR]
[TD="align: left"]Eloy Flanagan[/TD]
[TD="align: left"]Date Picker[/TD]
[TD="align: center"]DP[/TD]
[TD="align: center"]$13.34[/TD]
[TD="align: right"]11/29/2002[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"]5[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]7[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[/TR]
[TR]
[TD="align: left"]Gabriela Harrison[/TD]
[TD="align: left"]Cherry Picker[/TD]
[TD="align: center"]CP[/TD]
[TD="align: center"]$12.34[/TD]
[TD="align: right"]3/24/1989[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"]5[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]7[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[/TR]
[TR]
[TD="align: left"]Igbert Jollyman[/TD]
[TD="align: left"]Grain Picker[/TD]
[TD="align: center"]GP[/TD]
[TD="align: center"]$14.46[/TD]
[TD="align: right"]5/4/2012[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"]5[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]7[/TD]
[TD="align: center"]8[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[/TR]
[TR]
[TD="align: left"]Klaus Lanniman[/TD]
[TD="align: left"]Grain Picker[/TD]
[TD="align: center"]GP[/TD]
[TD="align: center"]$14.34[/TD]
[TD="align: right"]11/30/2001[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"]5[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]7[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[/TR]
[TR]
[TD="align: left"]Maribel Nolasco[/TD]
[TD="align: left"]Loquat Picker[/TD]
[TD="align: center"]LP[/TD]
[TD="align: center"]$15.22[/TD]
[TD="align: right"]4/29/1994[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"]5[/TD]
[TD="align: center"]6[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[/TR]
[TR]
[TD="align: left"]Orlando Parakeet[/TD]
[TD="align: left"]DP[/TD]
[TD="align: center"]DP[/TD]
[TD="align: center"]$13.46[/TD]
[TD="align: right"]4/29/2016[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"]5[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]7[/TD]
[TD="align: center"]8[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[/TR]
[TR]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: center"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]
[/TD]
[/TR]
[TR]
[TD="align: left"][/TD]
[TD="align: left"][/TD]
[TD="align: center"][/TD]
[TD="align: left"][/TD]
[TD="align: left"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: left"][/TD]
[TD="align: left"][/TD]
[TD="align: left"][/TD]
[TD="align: left"][/TD]
[/TR]
[TR]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[/TR]
[TR]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[/TR]
[TR]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[/TR]
[TR]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[/TR]
</tbody></table>
I am looking at two tables, and I need to return a "salary" (hourly wage) value based on an employee "step" that advances every year. In Table 2 below, in the orange fields, I'm looking to return the proper value, for each person, for the step they advance each year.
So, for example, in Status Quo Wages, in 2018 Abigail Brainard should be making $10.34, an Apple Picker's Step 3 Status Quo Salary.
I need to say, "Based on that year's Column F step in Table 2, xyz person will make the wages in Columns D through O." I've tried a bunch of nested IF functions but haven't quite got there.
<table cellspacing="0" border="0" verdana,="" arial,="" tahoma,="" calibri,="" geneva,="" sans-serif;"="" width=""><tbody>[TR]
[TD="align: left"][/TD]
[TD="align: left"]
[/TD]
[TD="align: center"][/TD]
[TD="align: left"][/TD]
[TD="align: left"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: left"][/TD]
[TD="align: left"][/TD]
[TD="align: left"][/TD]
[TD="align: left"][/TD]
[/TR]
</tbody></table><table cellspacing="0" border="0" width=""><colgroup width="180"></colgroup><colgroup width="127"></colgroup><colgroup span="2" width="80"></colgroup><colgroup width="113"></colgroup><colgroup span="3" width="80"></colgroup><colgroup width="75"></colgroup><colgroup span="10" width="80"></colgroup><tbody> [TR]
[TD="align: left"]TABLE 1[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[/TR]
[TR]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="colspan: 4, align: center"]Status Quo Salary Scale[/TD]
[TD="colspan: 4, align: center"]Proposed Salary Scale 2017[/TD]
[TD="colspan: 4, align: center"]Proposed Salary Scale 2018[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[/TR]
[TR]
[TD="align: center"]JobTitle[/TD]
[TD="align: center"]Job Code[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]4[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[/TR]
[TR]
[TD="bgcolor: #C5E0B4, align: left"]Apple Picker[/TD]
[TD="bgcolor: #C5E0B4, align: left"]AP[/TD]
[TD="bgcolor: #C5E0B4, align: left"]
[/TD]
[TD="bgcolor: #C5E0B4, align: right"] $10.10 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $10.22 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $10.34 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $10.46 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $10.13 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $10.25 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $10.37 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $10.49 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $10.76 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $10.89 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $11.01 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $11.14 [/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[/TR]
[TR]
[TD="bgcolor: #C5E0B4, align: left"]Berry Picker[/TD]
[TD="bgcolor: #C5E0B4, align: left"]BP[/TD]
[TD="bgcolor: #C5E0B4, align: left"]
[/TD]
[TD="bgcolor: #C5E0B4, align: right"] $11.10 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $11.22 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $11.34 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $11.46 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $11.13 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $11.25 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $11.37 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $11.49 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $11.82 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $11.95 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $12.08 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $12.21 [/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[/TR]
[TR]
[TD="bgcolor: #C5E0B4, align: left"]Cherry Picker[/TD]
[TD="bgcolor: #C5E0B4, align: left"]CP[/TD]
[TD="bgcolor: #C5E0B4, align: left"]
[/TD]
[TD="bgcolor: #C5E0B4, align: right"] $12.10 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $12.22 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $12.34 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $12.46 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $12.13 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $12.25 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $12.37 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $12.49 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $12.89 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $13.02 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $13.14 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $13.27 [/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[/TR]
[TR]
[TD="bgcolor: #C5E0B4, align: left"]Date Picker[/TD]
[TD="bgcolor: #C5E0B4, align: left"]DP[/TD]
[TD="bgcolor: #C5E0B4, align: left"]
[/TD]
[TD="bgcolor: #C5E0B4, align: right"] $13.10 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $13.22 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $13.34 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $13.46 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $13.13 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $13.25 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $13.37 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $13.49 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $13.95 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $14.08 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $14.21 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $14.34 [/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[/TR]
[TR]
[TD="bgcolor: #C5E0B4, align: left"]Grain Picker[/TD]
[TD="bgcolor: #C5E0B4, align: left"]GP[/TD]
[TD="bgcolor: #C5E0B4, align: left"]
[/TD]
[TD="bgcolor: #C5E0B4, align: right"] $14.10 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $14.22 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $14.34 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $14.46 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $14.14 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $14.26 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $14.38 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $14.50 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $15.02 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $15.15 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $15.27 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $15.40 [/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[/TR]
[TR]
[TD="bgcolor: #C5E0B4, align: left"]Loquat Picker[/TD]
[TD="bgcolor: #C5E0B4, align: left"]LP[/TD]
[TD="bgcolor: #C5E0B4, align: left"]
[/TD]
[TD="bgcolor: #C5E0B4, align: right"] $15.10 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $15.22 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $15.34 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $15.46 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $15.14 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $15.26 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $15.38 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $15.50 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $16.08 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $16.21 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $16.34 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $16.47 [/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[/TR]
[TR]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[/TR]
[TR]
[TD="align: left"]TABLE 2[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[/TR]
[TR]
[TD="align: center"]Name[/TD]
[TD="align: center"]Title[/TD]
[TD="align: center"]Code[/TD]
[TD="align: center"]Base Hourly[/TD]
[TD="align: center"]Hired[/TD]
[TD="align: center"]Step[/TD]
[TD="colspan: 4, align: center"]Step[/TD]
[TD="colspan: 3, align: center"]Status Quo Salary[/TD]
[TD="colspan: 3, align: center"]Proposed Salary 2017[/TD]
[TD="colspan: 3, align: center"]Proposed Salary 2018[/TD]
[/TR]
[TR]
[TD="align: center"]
[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]Step June 23, 2017[/TD]
[TD="align: center"]Step June 23, 2018[/TD]
[TD="align: center"]Step June 23, 2019[/TD]
[TD="align: center"]Step June 23, 2020[/TD]
[TD="align: center"]2017[/TD]
[TD="align: center"]2018[/TD]
[TD="align: center"]2019[/TD]
[TD="align: center"]2017[/TD]
[TD="align: center"]2018[/TD]
[TD="align: center"]2019[/TD]
[TD="align: center"]2017[/TD]
[TD="align: center"]2018[/TD]
[TD="align: center"]2019[/TD]
[/TR]
[TR]
[TD="align: left"]Abigail Brainard[/TD]
[TD="align: left"]Apple Picker[/TD]
[TD="align: center"]AP[/TD]
[TD="align: center"]$10.22[/TD]
[TD="align: right"]8/7/2015[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"]5[/TD]
[TD="align: center"]6[/TD]
[TD="bgcolor: #FFD966, align: left"]???[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[/TR]
[TR]
[TD="align: left"]Christine Davidson[/TD]
[TD="align: left"]Apple Picker[/TD]
[TD="align: center"]AP[/TD]
[TD="align: center"]$10.10[/TD]
[TD="align: right"]8/8/2014[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"]5[/TD]
[TD="bgcolor: #FFD966, align: left"]???[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[/TR]
[TR]
[TD="align: left"]Eloy Flanagan[/TD]
[TD="align: left"]Date Picker[/TD]
[TD="align: center"]DP[/TD]
[TD="align: center"]$13.34[/TD]
[TD="align: right"]11/29/2002[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"]5[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]7[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[/TR]
[TR]
[TD="align: left"]Gabriela Harrison[/TD]
[TD="align: left"]Cherry Picker[/TD]
[TD="align: center"]CP[/TD]
[TD="align: center"]$12.34[/TD]
[TD="align: right"]3/24/1989[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"]5[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]7[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[/TR]
[TR]
[TD="align: left"]Igbert Jollyman[/TD]
[TD="align: left"]Grain Picker[/TD]
[TD="align: center"]GP[/TD]
[TD="align: center"]$14.46[/TD]
[TD="align: right"]5/4/2012[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"]5[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]7[/TD]
[TD="align: center"]8[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[/TR]
[TR]
[TD="align: left"]Klaus Lanniman[/TD]
[TD="align: left"]Grain Picker[/TD]
[TD="align: center"]GP[/TD]
[TD="align: center"]$14.34[/TD]
[TD="align: right"]11/30/2001[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"]5[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]7[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[/TR]
[TR]
[TD="align: left"]Maribel Nolasco[/TD]
[TD="align: left"]Loquat Picker[/TD]
[TD="align: center"]LP[/TD]
[TD="align: center"]$15.22[/TD]
[TD="align: right"]4/29/1994[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"]5[/TD]
[TD="align: center"]6[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[/TR]
[TR]
[TD="align: left"]Orlando Parakeet[/TD]
[TD="align: left"]DP[/TD]
[TD="align: center"]DP[/TD]
[TD="align: center"]$13.46[/TD]
[TD="align: right"]4/29/2016[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"]5[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]7[/TD]
[TD="align: center"]8[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[/TR]
[TR]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: center"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]
[/TD]
[/TR]
[TR]
[TD="align: left"][/TD]
[TD="align: left"][/TD]
[TD="align: center"][/TD]
[TD="align: left"][/TD]
[TD="align: left"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: left"][/TD]
[TD="align: left"][/TD]
[TD="align: left"][/TD]
[TD="align: left"][/TD]
[/TR]
[TR]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[/TR]
[TR]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[/TR]
[TR]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[/TR]
[TR]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[/TR]
</tbody></table>