Challenge
Our client had their tour guide scheduling completed manually due to which they lost numerous valuable work hours.
During the process the relevant data was collected manually from multiple sheets.
Solution
In the existing Google Sheet we created a custom pop up form where the user was able to generate the schedule by selecting the guide and desired time interval. After confirming the selection the final schedule was generated on a dedicated tab alongside with the relevant data for financial reporting.
Additionally conditional formatting (color coding) was applied to improve tracking of reservation statuses.
Results
By automating the workflow the time required decreased by 80% alongside with the increase of the quality of these schedulings.
Time spent on work
Accurate financial reporting
![1648075033069 1648075033069](https://squery.hu/wp-content/uploads/elementor/thumbs/1648075033069-pz0hfcn2bic54fer6cmzwvwjy9f87lv9lkux2gjcmw.jpeg)
![1648075033069 1648075033069](https://squery.hu/wp-content/uploads/elementor/thumbs/1648075033069-pz0hfcn2bic54fer6cmzwvwjy9f87lv9lkux2gjcmw.jpeg)
“With the solution from Squery I have a lot of free time again that I spent with this administrative work before. The time saved can be spent on business development.”