This job is for an expert and someone has a real talent for Microsoft Excel. PLEASE SEE ATTACHED Excel file - I need a Microsoft Excel Wizard to help with some automation that I can provide to a client as a solution. My client works in the grounds maintenance industry and his operatives visit sites on a cyclical basis (based on number of visits in the year). The "period" works on a 4 week cycle. So period 1 on a 12 visit a year shows on the 2023 schedule, there will be 1 visit on 2nd Jan, Period 2, 30th Jan etc and none in December. You get the idea.
Currently my client has a CRM that produces this logic, and I need to recreate this logic in a couple of Excel sheets as they are moving away from this CRM due to external reasons (ideally using the same buttons (see snip image), so they can just put in the site name, which team, choose the period in which it starts etc and it will generate all the visits for that year in an Excel template that I can provide.
We will likely need to have a Skype call to go through the specifics. Price negotiable as I wasn't sure how long this would take someone to knock up. Generic proposals will be refused.