A while back I posted up about calculating bonuses based upon a lookup.
now, I need to add an additional step. Every once in a while, agents
get additional bonuses for sales outside of the normal commission
ladder. Here's the layout of the main sheet
A B C D E
Date1 Date2
Date3 .....
agent ID Agent Name $### $### $###
What I wanted to do was add an "Additional Bonus sheet" With a layout
like this
A B C
agentID Date Bonus
Then have a "final bonus screen" with this layout and formula similar to
the main sheet
A B C D E
Date1 Date2 Date3
agentID Agent Name $(sales + add bonus
total) ... ....
Note: the agent can have multiple bonuses for the same date on the
additional bonus sheet. Where would i start doing something like that?
I might figure that out while I'm typing that out (which is probably one
of the most useful functions of this list), but right now I'm spinning.
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
