I need a macro or VBA written to track movement of vehicles from location to location. In all there are about 95 locations. A trip comprises of at most 5 different locations, i want to track the no of persons moved in between trips accross the lcoations and have that information populated in a seperate sheet on a daily, weekly and monthly basis. The spreadsheet will comprise of about 6 sections, each section tracking various elements of the transactions/movements for that particular day - all of these elements will also be tracked daily, weekly and monthly. One particular element noteworthy of mentioning is the schedule, there is an existing schedule of movement, however, we want to track how this varies with the actual daily, delays, no shows etc... I reckon that since the schedule displays plans for the week and does not change, then the spreadsheet may be such that you select the day of the week and it comes up with the schedule (as one of the 6 sections) or the spreadsheet can be designed and managed on a weekly level. Objective Track how far we have differed from the planned schedules in percentage Track the no of passengers moved to each location Track the of passengers that no showed and their details Track hours taken and utilization percentages Track plans for the next day and many more
1) All deliverables will be considered "work made for hire" under U.S. Copyright law. Employer will receive exclusive and complete copyrights to all work purchased. (No 3rd party components unless all copyright ramifications are explained AND AGREED TO by the employer on the site per the worker's Worker Legal Agreement).
windows operating system
17 freelancers are bidding on average $137 for this job
Excel and VBA expert for over a decade. Master in Information Systems. I have delivered similar projects in the past. Please check my portfolio for: [url removed, login to view] Estate (video demonstration) [url removed, login to view] (video demonstrat Mere
I'm interested in this job. All I need is the specifications of the job and the files. If you are interested in my bid, please send me a message so we can discuss the details. Thanks!