Results 1 to 2 of 2

Thread: Excel VBA programmer needed

  1. #1

    Thread Starter
    New Member
    Join Date
    Dec 2003
    Posts
    1

    Excel VBA programmer needed

    Programmer needed visual basic, in excel

    I own a bee removal company . I keep most my records and calcualtions in excel and I am looking for an excel specialist / vba programmer that can write code to simplify and speed up some of the time consuming
    tasks. Time is a factor for me, money is less of a factor. I imagine it would be around 80 hrs work. With probable future changes and or additions that would most likley arise.

    Example:

    Bee removal work can be divided into two parts,
    1 exterminating a hive, and
    2. removing the honey from the structure (from 5 to 300 lbs).

    The field rep exterminates the hive and sets the appointment for the removal.
    The technicians remove the honey from the structure and perform repairs.

    I am looking for someone in Southern California. If interested please contact me at:
    > >adkins@san.rr.com
    > >john adkins

    Problem

    Right now I pay a sales rep 20% of the exterm fee and nothing for signing up
    the removal.

    I've created a macro that calculates each field reps exterminations for the
    week, removals, averages per job etc, and calculates the money the field rep
    earned. Its a little crude but it works.

    Im trying to encourage the reps to focus on closing more removals, this way
    I make much more money. As an incentive, I plan on breaking up the 20% (for
    the kill) to a percentage for exterminating (the kill), and a percentage for
    setting up a removal.

    I don't have the time to design this, neither would I do a good job at it.
    Basically the macro would do something like> for employee field search for
    "NW" then find desired dates within date serviced field, then take a % from
    exterm fee, add it to desired % for removal (if any) matching the desired
    pay period or dates. to come up with the amount to pay NW for the 2 weeks.
    as well as more accurately gather data for that period totaling # of exterms,
    repairs, ave per job, etc. so for every job Nick W 'NW' did during a inputted period of time,
    I would have a detailed analysis as well as the amount to pay Nick.

    A field rep is in either a level 1, 2, or 3, depending on past performance. A level 1's % of pay is less than that of a level 3.
    This is the first time I've written this information up so you may have trouble following it as I've explained it.

    But this is one example of data that I'm looking for at the click of a button.
    There are 5 to 10 other similar equations or macros which I would need to have written up.
    Also with hopes that the code would be able to sit well in upcoming versions of excel.

  2. #2
    New Member
    Join Date
    Mar 2014
    Posts
    0

    Re: Excel VBA programmer needed

    It looks like you posted this long ago, but it just came up in a search. I'm looking for some Excel VBA projects on the side, so I figured I'd check anyway. I'm in Atlanta, GA, but I can handle these kinds of requirements if you're interested.

    Chris





    Quote Originally Posted by Adkins View Post
    Programmer needed visual basic, in excel

    I own a bee removal company . I keep most my records and calcualtions in excel and I am looking for an excel specialist / vba programmer that can write code to simplify and speed up some of the time consuming
    tasks. Time is a factor for me, money is less of a factor. I imagine it would be around 80 hrs work. With probable future changes and or additions that would most likley arise.

    Example:

    Bee removal work can be divided into two parts,
    1 exterminating a hive, and
    2. removing the honey from the structure (from 5 to 300 lbs).

    The field rep exterminates the hive and sets the appointment for the removal.
    The technicians remove the honey from the structure and perform repairs.

    I am looking for someone in Southern California. If interested please contact me at:
    > >adkins@san.rr.com
    > >john adkins

    Problem

    Right now I pay a sales rep 20% of the exterm fee and nothing for signing up
    the removal.

    I've created a macro that calculates each field reps exterminations for the
    week, removals, averages per job etc, and calculates the money the field rep
    earned. Its a little crude but it works.

    Im trying to encourage the reps to focus on closing more removals, this way
    I make much more money. As an incentive, I plan on breaking up the 20% (for
    the kill) to a percentage for exterminating (the kill), and a percentage for
    setting up a removal.

    I don't have the time to design this, neither would I do a good job at it.
    Basically the macro would do something like> for employee field search for
    "NW" then find desired dates within date serviced field, then take a % from
    exterm fee, add it to desired % for removal (if any) matching the desired
    pay period or dates. to come up with the amount to pay NW for the 2 weeks.
    as well as more accurately gather data for that period totaling # of exterms,
    repairs, ave per job, etc. so for every job Nick W 'NW' did during a inputted period of time,
    I would have a detailed analysis as well as the amount to pay Nick.

    A field rep is in either a level 1, 2, or 3, depending on past performance. A level 1's % of pay is less than that of a level 3.
    This is the first time I've written this information up so you may have trouble following it as I've explained it.

    But this is one example of data that I'm looking for at the click of a button.
    There are 5 to 10 other similar equations or macros which I would need to have written up.
    Also with hopes that the code would be able to sit well in upcoming versions of excel.

Posting Permissions

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



Click Here to Expand Forum to Full Width