excel VBA programmer needed

[Adkins]

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.

[StevenHickerson]

Well I'm not from Southern California, as a matter of fact I'm quite a ways from there. I live near Columbia, South Carolina. But if I'm following what you want done correctly it dosn't sound like a very hard task at all.

I once held a job as an excel specialist for the primary power distributing company in my area. I completed what they had planned as 3 months worth of work in 2 weeks above quality expectations as well. What did I get out of it? The boss telling me sorry but we can't keep you busy enough were gonna have to let you go haha.

Anyway I got off the subject a little, I just wanted to express how easily I can handle VBA.

If you would like for me to take a look at what you got and submit a solution for you to look over and see if you would like me to do further tasks for you then email me a workbook and instructions on what you want to be able to do with it.

Steven6282us@yahoo.com

As a side note the above situation you describe I could see very easily solved it sounds a lot similiar to a macro program I made for a bowling secretary I know who needed to keep track of all the information from their bowling league. They wanted to be able to pull up any week very quickly and see who had paid what their scores were and some other miscellaneous information. It took me more time designing the forms than the code :)

[tintin2011]

hi, i think i can do this job better, but i m not in Southern California. But i hope talk about the detail with u