Hello all,
I know the title isn't the best, but I can't think of how to word it. Basically, the software I'm using is not supposed to pay the employees more than x amount (in the example I will provide, x amount = 1,000). The program exports an excel file with the name in column a, the week ending date in column b, and the amount in column c.
[TABLE="width: 231"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD]Name[/TD]
[TD]Week Ending[/TD]
[TD]Amount[/TD]
[/TR]
[TR]
[TD]Smith, John[/TD]
[TD="align: right"]9/23/2017[/TD]
[TD="align: right"]268[/TD]
[/TR]
[TR]
[TD]Smith, John[/TD]
[TD="align: right"]9/23/2017[/TD]
[TD="align: right"]252[/TD]
[/TR]
[TR]
[TD]Smith, John[/TD]
[TD="align: right"]9/23/2017[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]Smith, John[/TD]
[TD="align: right"]9/23/2017[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]Smith, John[/TD]
[TD="align: right"]9/23/2017[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]Smith, John[/TD]
[TD="align: right"]9/30/2017[/TD]
[TD="align: right"]250[/TD]
[/TR]
[TR]
[TD]Smith, John[/TD]
[TD="align: right"]9/30/2017[/TD]
[TD="align: right"]250[/TD]
[/TR]
[TR]
[TD]Smith, John[/TD]
[TD="align: right"]9/30/2017[/TD]
[TD="align: right"]250[/TD]
[/TR]
[TR]
[TD]Smith, John[/TD]
[TD="align: right"]9/30/2017[/TD]
[TD="align: right"]250[/TD]
[/TR]
[TR]
[TD]Smith, John[/TD]
[TD="align: right"]9/30/2017[/TD]
[TD="align: right"]250[/TD]
[/TR]
[TR]
[TD]Smith, John[/TD]
[TD="align: right"]10/7/2017[/TD]
[TD="align: right"]50[/TD]
[/TR]
[TR]
[TD]Smith, John[/TD]
[TD="align: right"]10/7/2017[/TD]
[TD="align: right"]45[/TD]
[/TR]
[TR]
[TD]Smith, John[/TD]
[TD="align: right"]10/7/2017[/TD]
[TD="align: right"]50[/TD]
[/TR]
[TR]
[TD]Smith, John[/TD]
[TD="align: right"]10/7/2017[/TD]
[TD="align: right"]40[/TD]
[/TR]
[TR]
[TD]Smith, John[/TD]
[TD="align: right"]10/14/2017[/TD]
[TD="align: right"]500[/TD]
[/TR]
[TR]
[TD]Smith, John[/TD]
[TD="align: right"]10/14/2017[/TD]
[TD="align: right"]500[/TD]
[/TR]
</tbody>[/TABLE]
Basically, the amounts for each week ending date cannot surpass x amount = 1000 (they can equal 1000, just not surpass). Instead, the sum of the amounts for each work ending date have to be edited to equal 1000. Below is an example of how I changed on employee compared to how he was listed in the above example. If you notice, 9/30/2017's amounts were more than 1000 in the above example, but I changed them to equal 1000 in the below example. There is no max for an individual amount. There is only a max for week ending date total amounts. Also, if the week ending date total amount is less than 1000, I would like the original amounts to remain.
[TABLE="width: 224"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD]Name[/TD]
[TD]Week Ending[/TD]
[TD]Amount[/TD]
[/TR]
[TR]
[TD]Smith, John[/TD]
[TD="align: right"]9/23/2017[/TD]
[TD="align: right"]288[/TD]
[/TR]
[TR]
[TD]Smith, John[/TD]
[TD="align: right"]9/23/2017[/TD]
[TD="align: right"]252[/TD]
[/TR]
[TR]
[TD]Smith, John[/TD]
[TD="align: right"]9/23/2017[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]Smith, John[/TD]
[TD="align: right"]9/23/2017[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]Smith, John[/TD]
[TD="align: right"]9/23/2017[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]Smith, John[/TD]
[TD="align: right"]9/30/2017[/TD]
[TD="align: right"]450[/TD]
[/TR]
[TR]
[TD]Smith, John[/TD]
[TD="align: right"]9/30/2017[/TD]
[TD="align: right"]300[/TD]
[/TR]
[TR]
[TD]Smith, John[/TD]
[TD="align: right"]9/30/2017[/TD]
[TD="align: right"]250[/TD]
[/TR]
[TR]
[TD]Smith, John[/TD]
[TD="align: right"]9/30/2017[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Smith, John[/TD]
[TD="align: right"]9/30/2017[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Smith, John[/TD]
[TD="align: right"]10/7/2017[/TD]
[TD="align: right"]50[/TD]
[/TR]
[TR]
[TD]Smith, John[/TD]
[TD="align: right"]10/7/2017[/TD]
[TD="align: right"]45[/TD]
[/TR]
[TR]
[TD]Smith, John[/TD]
[TD="align: right"]10/7/2017[/TD]
[TD="align: right"]50[/TD]
[/TR]
[TR]
[TD]Smith, John[/TD]
[TD="align: right"]10/7/2017[/TD]
[TD="align: right"]40[/TD]
[/TR]
[TR]
[TD]Smith, John[/TD]
[TD="align: right"]10/14/2017[/TD]
[TD="align: right"]500[/TD]
[/TR]
[TR]
[TD]Smith, John[/TD]
[TD="align: right"]10/14/2017[/TD]
[TD="align: right"]500[/TD]
[/TR]
</tbody>[/TABLE]
I know the title isn't the best, but I can't think of how to word it. Basically, the software I'm using is not supposed to pay the employees more than x amount (in the example I will provide, x amount = 1,000). The program exports an excel file with the name in column a, the week ending date in column b, and the amount in column c.
[TABLE="width: 231"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD]Name[/TD]
[TD]Week Ending[/TD]
[TD]Amount[/TD]
[/TR]
[TR]
[TD]Smith, John[/TD]
[TD="align: right"]9/23/2017[/TD]
[TD="align: right"]268[/TD]
[/TR]
[TR]
[TD]Smith, John[/TD]
[TD="align: right"]9/23/2017[/TD]
[TD="align: right"]252[/TD]
[/TR]
[TR]
[TD]Smith, John[/TD]
[TD="align: right"]9/23/2017[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]Smith, John[/TD]
[TD="align: right"]9/23/2017[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]Smith, John[/TD]
[TD="align: right"]9/23/2017[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]Smith, John[/TD]
[TD="align: right"]9/30/2017[/TD]
[TD="align: right"]250[/TD]
[/TR]
[TR]
[TD]Smith, John[/TD]
[TD="align: right"]9/30/2017[/TD]
[TD="align: right"]250[/TD]
[/TR]
[TR]
[TD]Smith, John[/TD]
[TD="align: right"]9/30/2017[/TD]
[TD="align: right"]250[/TD]
[/TR]
[TR]
[TD]Smith, John[/TD]
[TD="align: right"]9/30/2017[/TD]
[TD="align: right"]250[/TD]
[/TR]
[TR]
[TD]Smith, John[/TD]
[TD="align: right"]9/30/2017[/TD]
[TD="align: right"]250[/TD]
[/TR]
[TR]
[TD]Smith, John[/TD]
[TD="align: right"]10/7/2017[/TD]
[TD="align: right"]50[/TD]
[/TR]
[TR]
[TD]Smith, John[/TD]
[TD="align: right"]10/7/2017[/TD]
[TD="align: right"]45[/TD]
[/TR]
[TR]
[TD]Smith, John[/TD]
[TD="align: right"]10/7/2017[/TD]
[TD="align: right"]50[/TD]
[/TR]
[TR]
[TD]Smith, John[/TD]
[TD="align: right"]10/7/2017[/TD]
[TD="align: right"]40[/TD]
[/TR]
[TR]
[TD]Smith, John[/TD]
[TD="align: right"]10/14/2017[/TD]
[TD="align: right"]500[/TD]
[/TR]
[TR]
[TD]Smith, John[/TD]
[TD="align: right"]10/14/2017[/TD]
[TD="align: right"]500[/TD]
[/TR]
</tbody>[/TABLE]
Basically, the amounts for each week ending date cannot surpass x amount = 1000 (they can equal 1000, just not surpass). Instead, the sum of the amounts for each work ending date have to be edited to equal 1000. Below is an example of how I changed on employee compared to how he was listed in the above example. If you notice, 9/30/2017's amounts were more than 1000 in the above example, but I changed them to equal 1000 in the below example. There is no max for an individual amount. There is only a max for week ending date total amounts. Also, if the week ending date total amount is less than 1000, I would like the original amounts to remain.
[TABLE="width: 224"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD]Name[/TD]
[TD]Week Ending[/TD]
[TD]Amount[/TD]
[/TR]
[TR]
[TD]Smith, John[/TD]
[TD="align: right"]9/23/2017[/TD]
[TD="align: right"]288[/TD]
[/TR]
[TR]
[TD]Smith, John[/TD]
[TD="align: right"]9/23/2017[/TD]
[TD="align: right"]252[/TD]
[/TR]
[TR]
[TD]Smith, John[/TD]
[TD="align: right"]9/23/2017[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]Smith, John[/TD]
[TD="align: right"]9/23/2017[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]Smith, John[/TD]
[TD="align: right"]9/23/2017[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]Smith, John[/TD]
[TD="align: right"]9/30/2017[/TD]
[TD="align: right"]450[/TD]
[/TR]
[TR]
[TD]Smith, John[/TD]
[TD="align: right"]9/30/2017[/TD]
[TD="align: right"]300[/TD]
[/TR]
[TR]
[TD]Smith, John[/TD]
[TD="align: right"]9/30/2017[/TD]
[TD="align: right"]250[/TD]
[/TR]
[TR]
[TD]Smith, John[/TD]
[TD="align: right"]9/30/2017[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Smith, John[/TD]
[TD="align: right"]9/30/2017[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Smith, John[/TD]
[TD="align: right"]10/7/2017[/TD]
[TD="align: right"]50[/TD]
[/TR]
[TR]
[TD]Smith, John[/TD]
[TD="align: right"]10/7/2017[/TD]
[TD="align: right"]45[/TD]
[/TR]
[TR]
[TD]Smith, John[/TD]
[TD="align: right"]10/7/2017[/TD]
[TD="align: right"]50[/TD]
[/TR]
[TR]
[TD]Smith, John[/TD]
[TD="align: right"]10/7/2017[/TD]
[TD="align: right"]40[/TD]
[/TR]
[TR]
[TD]Smith, John[/TD]
[TD="align: right"]10/14/2017[/TD]
[TD="align: right"]500[/TD]
[/TR]
[TR]
[TD]Smith, John[/TD]
[TD="align: right"]10/14/2017[/TD]
[TD="align: right"]500[/TD]
[/TR]
</tbody>[/TABLE]