The current file includes a floorplan which is broken into team locations (Pod A1 - Pod E4). User Form 1 supplies the ability to enter Associates names into a range on a hidden tab along with their skill sets, and walkie talkie assignments - these agents are used as support for the various teams. The goal of this project in to create a criteria based randomizer to facilitate managing the floor support team. This would be accomplished by:
1.0 Building a command button that will auto shuffle those entered associates into the appropriate locations based on their skill sets.
2.0 The ability to mark certain locations through toggle(Pods A1-F4) staffed or unstaffed as well as with what skill sets.
3.0 The ability to toggle each floor support agent as either active or inactive based on whether they are on a break or lunch (if one is marked inactive, requirement 1.0 woiuld need to be able to account for those who were inactive to allocate coverage to that area).
Obviously additional definition of requirements is needed for the project, but these are the three core requirements, each which are inter-dependant.
Base shell work already complete. Some VBA already complete. Need est. 3-6 hours coding for expert.
Project pays $50 + $25 bonus for fast turnaround <3 days and optiization.
Potential for future larger work exists.
23 freelancers are bidding on average $96 for this job
I'm experienced in Excel and VBA, and working for the multi-countries large enterprise. I'm using Excel to generate financial reports for all division and levels of the enterprise.
I can do this project because these is my one of technical expertise here in Information Professionals Inc Makati City Philippines as VB/Excel Macro Programmer
Hello, I am interested in discussing this project in further detail. I have many years of experience developing using VBA for Office products. I look forward to hearing from you. Thank You, Raph30
software development is crucial activity and we must give time for tsting the software as well before actually deploying it Devendra Prasad software Developer +91 9911429982