3/11/2023 0 Comments Create a daily schedule in excel2nd Customer Name, Phone Number (if applicable, sometimes the crew only loads for one customer, other times it might be multiple customers). ![]() ![]() If the crew has to go to a store to pick up for the install, it has a different format: When doing this, there is a different format based on what the job is. The first I would like to do, is determine the size of the agenda for that crew based on how many stops, and have it dynamically change from day to day, followed by the 2nd crew's schedule at the end of the first crew's schedule. There are a couple things I would like to try to do with the file, if possible. Only certain parts of this information changes and that is determined by the date to a point. The information at the bottom of the chart is other information, like the crew's ending point, the store that they load at, etc. That information in the top part of the chart is determined by the date in the upper left corner and is pulled from my main file, so I can work on whichever day is needed at the time. As you can see from the code on the schedule, it pulls the information from the chart on the right. That gives me the mileage in that column. Then I go through and arrange the map entries for the schedule so that crew is going to the next job that is closest instead of going across town in between stops. The current process is: I plug all the addresses into Google Maps for each crew for that day. I have been working on trying to get the daily schedule to where I don't have to edit much code to be able to create the schedule. ![]() OK to start off, I'm the secretary for a construction company.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |