bonus disqualifiers for excess vacation days

K

kiki burgh

New Member
Joined
Jun 9, 2014
Messages
44
hope all is well everyone. may i seek your help for coming up with a template for computing for disqualifiers for a certain bonus given the following conditions (that sadly i cannot convert to formula):

folks are given bonus for completing work days in a month; however, due to being understaffed, taking vacation leaves that go beyond 10% of work days in a month is discouraged.

base bonus amount = 2,903.336 (subject to change monthly but is fixed for this specific example)

# of worked days in a month = 21 (other possible values of days worked: 19, 20, 22, 23)

10% of days worked
19 = 1.9
20 = 2
21 = 2.1
22 = 2.2
23 = 2.3

# days in excess of 10% of work days will incur increasing deductions
1 day = less 25% of base amount
2 days = less 50% of base amount
3 days = less 75% of base amount
4 days = less 100% of base amount

for example, month of june has 21 work days. an employee with exactly 2 (to at most 2.1) days approved & plotted vacation, will be rewarded 100% of base bonus amount whereas an employee with who filed for 4 days of leaves (4/21 = 19% has .9 excess days is definitely more than 10% of 21 work days of the month), will still be rewarded bonus but 50% less of base bonus amount compared to the other employee in prior example.

kindly see sample table below. for results shown in the attachment, these were just manually computed & referenced to tables. any approach or presentation to make it even leaner/better, will be greatly appreciated.

Code: 
[TABLE="class: grid, width: 526"]
<tbody>[TR]
[TD][SIZE=1]
[/SIZE][/TD]
[TD][SIZE=1]A[/SIZE][/TD]
[TD][SIZE=1]B[/SIZE][/TD]
[TD][SIZE=1]C[/SIZE][/TD]
[TD][SIZE=1]D[/SIZE][/TD]
[TD][SIZE=1]E[/SIZE][/TD]
[TD][SIZE=1]F[/SIZE][/TD]
[TD][SIZE=1]G[/SIZE][/TD]
[/TR]
[TR]
[TD][SIZE=1]A1[/SIZE][/TD]
[TD][SIZE=1]base bonus amount[/SIZE][/TD]
[TD="align: right"][SIZE=1]2,903.336[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[/TR]
[TR]
[TD][SIZE=1]A2[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[/TR]
[TR]
[TD][SIZE=1]A3[/SIZE][/TD]
[TD][SIZE=1]# of work days[/SIZE][/TD]
[TD="align: right"][SIZE=1]10%[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[TD][SIZE=1]excess days[/SIZE][/TD]
[TD][SIZE=1]deduction[/SIZE][/TD]
[TD][SIZE=1]amount[/SIZE][/TD]
[TD][SIZE=1]total[/SIZE][/TD]
[/TR]
[TR]
[TD][SIZE=1]A4[/SIZE][/TD]
[TD="align: right"][SIZE=1]19[/SIZE][/TD]
[TD="align: right"][SIZE=1]1.9[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[TD="align: right"][SIZE=1]1[/SIZE][/TD]
[TD="align: right"][SIZE=1]-25%[/SIZE][/TD]
[TD="align: right"][SIZE=1]-725.834[/SIZE][/TD]
[TD="align: right"][SIZE=1]2,177.502[/SIZE][/TD]
[/TR]
[TR]
[TD][SIZE=1]A5[/SIZE][/TD]
[TD="align: right"][SIZE=1]20[/SIZE][/TD]
[TD="align: right"][SIZE=1]2[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[TD="align: right"][SIZE=1]2[/SIZE][/TD]
[TD="align: right"][SIZE=1]-50%[/SIZE][/TD]
[TD="align: right"][SIZE=1]-1451.668[/SIZE][/TD]
[TD="align: right"][SIZE=1]1,451.668[/SIZE][/TD]
[/TR]
[TR]
[TD][SIZE=1]A6[/SIZE][/TD]
[TD="align: right"][SIZE=1]21[/SIZE][/TD]
[TD="align: right"][SIZE=1]2.1[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[TD="align: right"][SIZE=1]3[/SIZE][/TD]
[TD="align: right"][SIZE=1]-75%[/SIZE][/TD]
[TD="align: right"][SIZE=1]-2177.502[/SIZE][/TD]
[TD="align: right"][SIZE=1]725.834
[/SIZE][/TD]
[/TR]
[TR]
[TD][SIZE=1]A7[/SIZE][/TD]
[TD="align: right"][SIZE=1]22[/SIZE][/TD]
[TD="align: right"][SIZE=1]2.2[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[TD="align: right"][SIZE=1]4[/SIZE][/TD]
[TD="align: right"][SIZE=1]-100%[/SIZE][/TD]
[TD="align: right"][SIZE=1]-2903.336[/SIZE][/TD]
[TD="align: right"][SIZE=1]0.000[/SIZE][/TD]
[/TR]
[TR]
[TD][SIZE=1]A8[/SIZE][/TD]
[TD="align: right"][SIZE=1]23[/SIZE][/TD]
[TD="align: right"][SIZE=1]2.3[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[/TR]
[TR]
[TD][SIZE=1]A9[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[/TR]
[TR]
[TD][SIZE=1]A10[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[/TR]
[TR]
[TD][SIZE=1]A11[/SIZE][/TD]
[TD][SIZE=1]Agent[/SIZE][/TD]
[TD][SIZE=1]Leave(s)[/SIZE][/TD]
[TD][SIZE=1]bonus[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[/TR]
[TR]
[TD][SIZE=1]A12[/SIZE][/TD]
[TD][SIZE=1]Agent 01[/SIZE][/TD]
[TD="align: right"][SIZE=1]0[/SIZE][/TD]
[TD="align: right"][SIZE=1]2,903.336[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[/TR]
[TR]
[TD][SIZE=1]A13[/SIZE][/TD]
[TD][SIZE=1]Agent 02[/SIZE][/TD]
[TD="align: right"][SIZE=1]0[/SIZE][/TD]
[TD="align: right"][SIZE=1]2,903.336[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[/TR]
[TR]
[TD][SIZE=1]A14[/SIZE][/TD]
[TD][SIZE=1]Agent 03[/SIZE][/TD]
[TD="align: right"][SIZE=1]2[/SIZE][/TD]
[TD="align: right"][SIZE=1]2,903.336[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[/TR]
[TR]
[TD][SIZE=1]A15[/SIZE][/TD]
[TD][SIZE=1]Agent 04[/SIZE][/TD]
[TD="align: right"][SIZE=1]6[/SIZE][/TD]
[TD="align: right"][SIZE=1]0[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[/TR]
[TR]
[TD][SIZE=1]A16[/SIZE][/TD]
[TD][SIZE=1]Agent 05[/SIZE][/TD]
[TD="align: right"][SIZE=1]1[/SIZE][/TD]
[TD="align: right"][SIZE=1]2,903.336[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[/TR]
[TR]
[TD][SIZE=1]A17[/SIZE][/TD]
[TD][SIZE=1]Agent 06[/SIZE][/TD]
[TD="align: right"][SIZE=1]4[/SIZE][/TD]
[TD="align: right"][SIZE=1]1451.668[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[/TR]
[TR]
[TD][SIZE=1]A18[/SIZE][/TD]
[TD][SIZE=1]Agent 07[/SIZE][/TD]
[TD="align: right"][SIZE=1]4[/SIZE][/TD]
[TD="align: right"][SIZE=1]1451.668[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[/TR]
[TR]
[TD][SIZE=1]A19[/SIZE][/TD]
[TD][SIZE=1]Agent 08[/SIZE][/TD]
[TD="align: right"][SIZE=1]3[/SIZE][/TD]
[TD="align: right"][SIZE=1]2177.502[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[/TR]
[TR]
[TD][SIZE=1]A20[/SIZE][/TD]
[TD][SIZE=1]Agent 09[/SIZE][/TD]
[TD="align: right"][SIZE=1]3[/SIZE][/TD]
[TD="align: right"][SIZE=1]2177.502[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[/TR]
[TR]
[TD][SIZE=1]A21[/SIZE][/TD]
[TD][SIZE=1]Agent 10[/SIZE][/TD]
[TD="align: right"][SIZE=1]5[/SIZE][/TD]
[TD="align: right"][SIZE=1]725.834[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[/TR]
</tbody>[/TABLE]

looking forward to your prompt help.
cheers.
 
Last edited:
Sort by date Sort by votes
Michael M said:
Basically the new formula in "C" will eliminate ALL #N/A's
Click to expand...
truly appreciate the assist michael m. my apologies but the previous post (containing the new formulas) still results to #N/A.
thank you.
Code: 
[TABLE="class: grid, width: 344"]
<colgroup><col><col span="2"><col><col></colgroup><tbody>[TR]
[TD]base bonus amount
[/TD]
[TD="align: right"]$2,903.34[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]# of work days[/TD]
[TD="align: right"]10%[/TD]
[TD][/TD]
[TD]excess days[/TD]
[TD]deduction[/TD]
[/TR]
[TR]
[TD="align: right"]19[/TD]
[TD="align: right"]1.900[/TD]
[TD][/TD]
[TD="align: right"]1.00[/TD]
[TD="align: right"]25%[/TD]
[/TR]
[TR]
[TD="align: right"]20[/TD]
[TD="align: right"]2.000[/TD]
[TD][/TD]
[TD="align: right"]2.00[/TD]
[TD="align: right"]50%[/TD]
[/TR]
[TR]
[TD="align: right"]21[/TD]
[TD="align: right"]2.100[/TD]
[TD][/TD]
[TD="align: right"]3.00[/TD]
[TD="align: right"]75%[/TD]
[/TR]
[TR]
[TD="align: right"]22[/TD]
[TD="align: right"]2.200[/TD]
[TD][/TD]
[TD="align: right"]4.00[/TD]
[TD="align: right"]100%[/TD]
[/TR]
[TR]
[TD="align: right"]23[/TD]
[TD="align: right"]2.300[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Agent[/TD]
[TD]Leave(s)[/TD]
[TD]bonus[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Agent 01[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]2,903.336[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Agent 02[/TD]
[TD="align: right"]0.5[/TD]
[TD="align: center"]#N/A[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Agent 03[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]1,451.668[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Agent 04[/TD]
[TD="align: right"]1.5[/TD]
[TD="align: center"]#N/A[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Agent 05[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2,177.502[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Agent 06[/TD]
[TD="align: right"]3.2[/TD]
[TD="align: center"]#N/A[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Agent 07[/TD]
[TD="align: right"]4[/TD]
[TD]-[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Agent 08[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]725.834[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Agent 09[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]725.834[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Agent 10[/TD]
[TD="align: right"]5[/TD]
[TD]-[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
 
Last edited:
Upvote 0

Excel Facts

Did you know Excel offers Filter by Selection?
Add the AutoFilter icon to the Quick Access Toolbar. Select a cell containing Apple, click AutoFilter, and you will get all rows with Apple
Ok, gotcha.
Try this then....


OOps, typo in ther formula


Excel 2003
ABC
12Agent 0102903.336
13Agent 020.52177.502
14Agent 0321451.668
15Agent 041.51451.668
16Agent 0512177.502
17Agent 063.2-
18Agent 0702903.336
19Agent 083725.834
20Agent 093725.834
21Agent 105-
Sheet2
Cell Formulas
RangeFormula
C12=IF(ROUNDUP(B12,0)=0,$B$1,IF(ROUNDUP(B12,0)>=4,"-",$B$1*(1-VLOOKUP(ROUNDUP(B12,0),$D$4:$E$7,2,0))))
C13=IF(ROUNDUP(B13,0)=0,$B$1,IF(ROUNDUP(B13,0)>=4,"-",$B$1*(1-VLOOKUP(ROUNDUP(B13,0),$D$4:$E$7,2,0))))
C14=IF(ROUNDUP(B14,0)=0,$B$1,IF(ROUNDUP(B14,0)>=4,"-",$B$1*(1-VLOOKUP(ROUNDUP(B14,0),$D$4:$E$7,2,0))))
C15=IF(ROUNDUP(B15,0)=0,$B$1,IF(ROUNDUP(B15,0)>=4,"-",$B$1*(1-VLOOKUP(ROUNDUP(B15,0),$D$4:$E$7,2,0))))
C16=IF(ROUNDUP(B16,0)=0,$B$1,IF(ROUNDUP(B16,0)>=4,"-",$B$1*(1-VLOOKUP(ROUNDUP(B16,0),$D$4:$E$7,2,0))))
C17=IF(ROUNDUP(B17,0)=0,$B$1,IF(ROUNDUP(B17,0)>=4,"-",$B$1*(1-VLOOKUP(ROUNDUP(B17,0),$D$4:$E$7,2,0))))
C18=IF(ROUNDUP(B18,0)=0,$B$1,IF(ROUNDUP(B18,0)>=4,"-",$B$1*(1-VLOOKUP(ROUNDUP(B18,0),$D$4:$E$7,2,0))))
C19=IF(ROUNDUP(B19,0)=0,$B$1,IF(ROUNDUP(B19,0)>=4,"-",$B$1*(1-VLOOKUP(ROUNDUP(B19,0),$D$4:$E$7,2,0))))
C20=IF(ROUNDUP(B20,0)=0,$B$1,IF(ROUNDUP(B20,0)>=4,"-",$B$1*(1-VLOOKUP(ROUNDUP(B20,0),$D$4:$E$7,2,0))))
C21=IF(ROUNDUP(B21,0)=0,$B$1,IF(ROUNDUP(B21,0)>=4,"-",$B$1*(1-VLOOKUP(ROUNDUP(B21,0),$D$4:$E$7,2,0))))
 
Last edited:
Upvote 0
hi again michael m. apologies for reviving this thread. i would like to reach out though if you have time to revisit the latest version of the formula (sample:
Code: 
=IF(P15=0,$D$10,IF(ROUNDUP(P15,0)>=4,0,$D$10*(1-VLOOKUP(ROUNDUP(P15,0),$P$6:$Q$9,2,0))))
. true enough, the #NAs were addressed. however, the # of work days seem to be important as the # of work days (can be 19, 20, 21, 22, or 23 days in a month) will be basis for anything # of leaves in excess of 10% with corresponding deductions. i hope i am not confusing you.
thank u so much.
 
Upvote 0
i hope i am not confusing you.
Click to expand...

Yep....you are !!!

Maybe you should upload your worksheet to a hosting site like DropBox or MediaFire then post a link to that site back here...
You'll also, need to explain clearly what the problem is. I do a lot of Excel stuff, and yours has disappeared into history...:LOL:
 
Upvote 0
Hi kiki
I can't access those sites from work....if there has been no response I'll try and have a look tonight !!
 
Upvote 0
hello there michael m. thanks for replying. apologies for following-up. no worries if this cannot be attended to sooner. please do not let this interfere with your work.
just for the sake of visibility, i am posting the worksheets here.

your previous answer with formula below (previous worksheet):

ABCDEFG
1base bonus amount$2,903.34




2






3# of work days10%
excess daysdeductionamounttotal
4191.900
1.0025%725.8342,177.502
5202.000
2.0050%1,451.6681,451.668
6212.100
3.0075%2,177.502725.834
7222.200
4.00100%2,903.3360.000
8232.300




9






10






11AgentLeave(s)bonus



12Agent 0102,903.336



13Agent 020.52,177.502



14Agent 0321,451.668



15Agent 041.51,451.668



16Agent 0512,177.502



17Agent 063.2-



18Agent 074-



19Agent 083725.834



20Agent 093725.834



21Agent 105-




<tbody>
</tbody>

formula for c13:
Code: 
=IF(C13=0,$C$2,IF(ROUNDUP(C13,0)>=4,"-",$C$2*(1-VLOOKUP(ROUNDUP(C13,0),$E$5:$F$8,2,0))))

sample computation (newer worksheet):

ABCDE
1Computation



2base bonus amount2,427.043(can be any amount - changed amount from previous sample of 2,903.34)
3# of work days21(can be any # of days from 19, 20, 21, 22, 23)
4% over allowed leaves10%(can be any % of # of work days)
5




6




7excess daysdeductionamountthis table is shown so i can in the future change excess days with corresponding % deduction
81-25%1820.282

92-50%1213.522

103-75%606.761

114-100%0.000

12
to manually inputto show excess days (on top of 10% work days)to show deduction instead (negative) instead of bonus
13AgentLeave(s)ExcessDeductionBonus
14Agent 010-2.10.0002427.043
15Agent 020.5-1.60.0002427.043
16Agent 031-1.10.0002427.043
17Agent 041.1-10.0002427.043
18Agent 051.5-0.60.0002427.043
19Agent 062-0.10.0002427.043
20Agent 072.100.0002427.043
21Agent 082.250.15-606.7611820.2823
22Agent 0930.9-606.7611820.2823
23Agent 103.11-606.7611820.2823
24Agent 113.51.4-1,213.5221213.5215
25Agent 1241.9-1,213.5221213.5215
26Agent 134.12-1,213.5221213.5215
27Agent 144.52.4-1,820.282606.76075
28Agent 1552.9-1,820.282606.76075
29Agent 165.13-1,820.282606.76075
30Agent 175.53.4-2,427.0430
31Agent 1863.9-2,427.0430
32Agent 196.14-2,427.0430
33Agent 206.64.5-2,427.0430

<tbody>
</tbody>

desired outcome:
This is how it should look like (some columns not shown)
base bonus amount2,427.043

# of work days21

% over allowed leaves10%









excess daysdeduction

1-25%

2-50%

3-75%

4-100%





AgentLeave(s)Excess
Deduction
Agent 010-2.10.000
Agent 020.5-1.60.000
Agent 031-1.10.000
Agent 041.1-10.000
Agent 051.5-0.60.000
Agent 062-0.10.000
Agent 072.100.000
Agent 082.250.15-606.761
Agent 0930.9-606.761
Agent 103.11-606.761
Agent 113.51.4-1,213.522
Agent 1241.9-1,213.522
Agent 134.12-1,213.522
Agent 144.52.4-1,820.282
Agent 1552.9-1,820.282
Agent 165.13-1,820.282
Agent 175.53.4-2,427.043
Agent 1863.9-2,427.043
Agent 196.14-2,427.043
Agent 206.64.5-2,427.043

<tbody>
</tbody>

thank you.
 
Last edited:
Upvote 0
You must log in or register to reply here.

Similar threads

J
  • Solved
Formula Filled Dates
Replies
4
Views
354
Fluff
Fluff
john Smith72
  • Solved
count days between dates for each month by drop list
Replies
9
Views
144
Tetra201
Tetra201
M
  • Question
HELP IDENTIFY ORIGINAL START DATE BASED ON CONTINOUS SERVICE RULES
Replies
0
Views
377
mrshuck
M
B
  • Question
dynamic formula help - supply multiple variables and process row by row
Replies
0
Views
416
BrettJH
B
R
  • Question
Calculating Man Hours Worked on Day Night Shift
Replies
0
Views
2K
richy89
R

Forum statistics

Threads
1,216,110
Messages
6,128,890
Members
449,477
Latest member
panjongshing

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top