Inefficiencies are Ineffective

Project Overview

During my time with Bella Coola Heli Sports and Tweedsmuir Park Lodge, I identified opportunities to improve daily operations and guest communication processes. Through building simple, dynamic tools, I streamlined daily scheduling for staff, reduced workload for management, and improved the clarity of guest enquiries, enhancing both operational efficiency and customer experience.

The Challenge

Internal scheduling processes and guest enquiry handling were reliant on static documents and manual updates. This often led to human error, ineffeciencies with increased management workload and a slower response time for guest communications.

The Solution

With experience across a range of industries and teams, I approach each new role by closely observing dynamic relationships and ongoing operations. I position myself to assist in areas where long-standing processes may have hidden inefficiencies.

I developed a dynamic scheduling tool using SQL-based queries and Google Sheets functions. This system produced live daily schedules for the guides on property. This reduced the daily operational workloads for lodge and guide managements teams by simplifying the complexity of the seasonal roster.

Additional annual reports of guiding activity schedules are required for guiding operations within the Tweedsmuir Provincial Park. Producing an automated schedule by date produces simplified formatting for data intake and centralised location for guide teams to record daily operations. Providing opportunity for continuous data collection across 16 week summer season, drastically reduced management tasks in at season's conclusion to retrace individual guide data logs.

‍

Cell A7

= UNIQUE(FILTER({'Schedule - Reservations'!$Q$8:$Q},
	'Schedule - Reservations'!$B$8:$B = $A$3,
		'Schedule - Reservations'!$B$8:$B <> ""))

Cell B7

=IF($A7 = "None", "-",
	IF($A7 <> "",
    	MIN( UNIQUE( FILTER(
        	{'Schedule - Reservations'!$P$8:$P},
			'Schedule - Reservations'!$B$8:$B = $A$3,
            'Schedule - Reservations'!$Q$8:$Q = $A7))),
            ""))

Cell C7

=IF($A7 <> "",
	UNIQUE( FILTER(
    	{'Schedule - Reservations'!$R$8:$R},
		'Schedule - Reservations'!$B$8:$B = $A$3, 
        'Schedule - Reservations'!$Q$8:$Q = $A7)),
        "")

Cell D7

=IF($A7 = "None","No Activity",
	IF($A7<>"", textjoin(" , ",true,
    	UNIQUE( FILTER(
        	{'Schedule - Reservations'!$O$8:$O},
            'Schedule - Reservations'!$B$8:$B = $A$3,
            'Schedule - Reservations'!$Q$8:$Q = $A7))),
            ""))

Cell E7

=IF($A7<>"",
	SUM( FILTER(
    	{'Schedule - Reservations'!$J$8:$J},
        'Schedule - Reservations'!$B$8:$B = $A$3,
        'Schedule - Reservations'!$Q$8:$Q = $A7)),
        "")

Cell F7

=IF($A7 <> "", 
	TEXTJOIN(" , ", TRUE, 
    	UNIQUE( FILTER(
        	{RIGHT('Schedule - Reservations'!$D$8:$D, 
            LEN('Schedule - Reservations'!$D$8:$D) - 
            FIND(" - ", 'Schedule - Reservations'!$D$8:$D) - 2)},
            	'Schedule - Reservations'!$B$8:$B = $A$3, 
                'Schedule - Reservations'!$Q$8:$Q = $A7))),
                "")
                
                

‍

‍

Later, stepping into the Sales and Reservations position, I created a dynamic quote calculator for email enquiries.
Drawing from my background in digital marketing and eCommerce, I understand that clutter hinders user experience and in adventure tourism, clear, digestible information is key to effective communication.

‍

‍

Impact

‍

Reflection

This project reinforced my belief that effective systems don’t need to be complicated to create real impact. By focusing on clear communication, I helped the team work more efficiently, improving both internal operations and the guest experience.