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:
> >[email protected]
> >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.
