Closed Thread
Results 1 to 3 of 3

How do I set up a standard form showing incentive calculations

  1. #1
    KeithB
    Guest

    How do I set up a standard form showing incentive calculations

    I'm looking to set up a single sheet that will be used to print out qtrly
    bonus calculations for employees - in effect I'm looking to do a mail merge
    in excel without setting up a sheet for each employee (90 in total) but
    carrying out a variety of calculations on about 9 different paramaters which
    relate to circa 20 schemes for the 90 employees. The sheet will read off a
    database containing targets v acheivement and variable % entitlements for
    different scheme types. Currently I have 90 sheets within my workbook.

  2. #2
    PC
    Guest

    Re: How do I set up a standard form showing incentive calculations

    Just my 2 cents. If you need to print out letters the Mail Merge in Word is
    probably a better choice. All you need is to have the employee names and
    their bonus figures either in one XL table or (I'm guessing) you could
    probably pull the merge data straight out of Access.

    PC


    "KeithB" <[email protected]> wrote in message
    news:[email protected]...
    > I'm looking to set up a single sheet that will be used to print out qtrly
    > bonus calculations for employees - in effect I'm looking to do a mail

    merge
    > in excel without setting up a sheet for each employee (90 in total) but
    > carrying out a variety of calculations on about 9 different paramaters

    which
    > relate to circa 20 schemes for the 90 employees. The sheet will read off a
    > database containing targets v acheivement and variable % entitlements for
    > different scheme types. Currently I have 90 sheets within my workbook.




  3. #3
    KeithB
    Guest

    Re: How do I set up a standard form showing incentive calculations

    Thanks PC,

    their are too many permutations of calcs for it really to go into word -
    looks like its time to refamiliarise myself with access

    KeithB

    "PC" wrote:

    > Just my 2 cents. If you need to print out letters the Mail Merge in Word is
    > probably a better choice. All you need is to have the employee names and
    > their bonus figures either in one XL table or (I'm guessing) you could
    > probably pull the merge data straight out of Access.
    >
    > PC
    >
    >
    > "KeithB" <[email protected]> wrote in message
    > news:[email protected]...
    > > I'm looking to set up a single sheet that will be used to print out qtrly
    > > bonus calculations for employees - in effect I'm looking to do a mail

    > merge
    > > in excel without setting up a sheet for each employee (90 in total) but
    > > carrying out a variety of calculations on about 9 different paramaters

    > which
    > > relate to circa 20 schemes for the 90 employees. The sheet will read off a
    > > database containing targets v acheivement and variable % entitlements for
    > > different scheme types. Currently I have 90 sheets within my workbook.

    >
    >
    >


Closed Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1