Re: [libreoffice-users] Bonus calculator in Calc

Let's assume I can't get IT to install the JRE for database access.


On 12/18/2013 4:48 PM, Tom Davies wrote:
> Hi :)
> Why not use Base to read the 2 existing sheets?  Then let it do the
> bit it does best?
> Regards from
> Tom :)
>
> On 18 December 2013 23:46, John Meyer <johnmeyer@pueblocomputing.com> wrote:
> > I know it's a relational database.  ;-) Is there any way to design this to
> > work on a spreadsheet?
> >
> >
> > On 12/18/2013 4:40 PM, Tom Davies wrote:
> > > Hi :)
> > > That is very much like a relational database.  The 1st sheet is the
> > > main table.  The 2nd sheet would be a separate table but would be
> > > linked by a relationship between both column As.  The 3rd sheet would
> > > actually not be a table as such, it would be a Query that takes data
> > > from the 2 tables and performs calculations on them.  Hmm, it could be
> > > a Form or Report but if i was doing it (and note that  i'm not) then i
> > > tend to prefer using a Query for as much of this sort of thing as
> > > possible because it makes it easier to adjust the formulae in the
> > > future
> > > Regards from
> > > Tom :)
> > >
> > > On 18 December 2013 20:22, John Meyer <johnmeyer@pueblocomputing.com>
> > > wrote:
> > > > 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


--
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