[libreoffice-users] Bonus calculator in Calc

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+unsubscribe@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