BUSINESS SOLUTIONS

Hotel Booking System Using Google Sheets and Google Apps Script

This project automates hotel room bookings and availability tracking using Google Forms and Google Sheets. The system allows users to submit room bookings through a form, which automatically updates room availability, booking details, and income summaries in real time through connected spreadsheet scripts.

This form collects booking details from customers, including room selection, check-in and check-out dates, customer name, mobile number, and number of guests.

This sheet allows the user to select a date range for viewing bookings. The selected dates are used to filter the data shown in the calendar and availability sheets.

This sheet shows the availability of each room for the selected date range, highlighting booked and available dates

Google Sheets Travel Management System

I designed a central dashboard that gives users a quick snapshot of their trip, including destination details, travel dates, duration, and the number of travelers. The dashboard also provides a visual budget breakdown by category and shows real-time updates on budget status, helping users track whether they are within or over budget.

ACCOMODATION RESEARCH

This sheet helps you compare different accommodations for your trip. It includes fields for the destination, dates of the trip, name and type of accommodation, booking link, rating, distance to attractions, WiFi availability, cost per night, number of nights, and total cost. This makes it easier to decide where to stay based on multiple factors.

RESERVATIONS TRACKER

Records detailed information on flights, accommodations, and car rentals. This section helps users keep all booking information in one place, including confirmation numbers, check-in/out times, and associated costs.

TRAVEL EXPENSES

Allows users to log all their travel-related expenditures, categorized by type (e.g., flights, accommodation, food). The sheet automatically calculates monthly and yearly totals, offering a clear view of how much has been spent and what remains in the budget.

PACKING LIST

I created a bucket list planner where users can log activities and restaurants they wish to experience. This section includes space for entering location details, costs, distance from the hotel, and additional notes, making it easy to plan daily excursions and dining experiences.

BUSINESS INTELLIGENCE DASHBOARDS

Healthcare Operations Dashboard

Consolidates financial, operational, and patient metrics. Tracks weekly visits, lives saved, revenue, and attendance against annual goals for healthcare performance evaluation. .

Insulation Company Sales Dashboard

Provides revenue and performance analytics by sales representative. Tracks leads, jobs sold, closing rates, and average contract value to evaluate sales effectiveness.

Patient Source and Sign-Up Dashboard (Healthcare Analytics)

Visualizes new patient and sign-up sources across multiple channels such as Google, referrals, and events. Includes month-by-month comparison for acquisition performance.

Marketing Campaign Performance Dashboard

Tracks marketing activity by campaign, budget, and call-to-action type. Provides insights into campaign distribution by manager and real-time engagement breakdowns.

Sales Analytics Dashboard

Highlights top and bottom product performance, customer loyalty trends, and regional sales distribution. Includes profitability analysis and quarterly performance tracking.

Classroom Occupancy Dashboard

Evaluates classroom usage by course, time, and department. Includes metrics for lecture, exam, and lab utilization to support university scheduling and capacity planning.

BACKORDER REPORTING & CUSTOMER EMAIL AUTOMATION TOOL

Built a custom backorder management application for a lighting distributor to automate customer communication and delivery tracking.

The application processes multiple Excel reports, merges and cleans data, allows manual delivery date management, generates customer-specific backorder reports, and automates email creation through Microsoft Outlook.

A key requirement was preserving manually entered delivery information across future report uploads while allowing users to update, remove, or override delivery dates as business conditions change.

The solution reduced manual spreadsheet work, improved customer communication consistency, and gave staff a single interface to manage backorders and customer updates.

Users upload two source reports:

Dump Report with Contacts
Dump Report with Products

The application merges both datasets and creates a consolidated backorder report ready for review, delivery date management, and customer communication.

Customer Communication Automation

Users can:

Select customers requiring updates
Generate Outlook draft emails
Send customer notifications
Review email content before dispatch

Each email is built dynamically from current backorder information and delivery status.

Delivery Date & EX-STOCK Management

Users can:

Select individual backorder items
Assign delivery dates
Remove delivery dates
Mark products as EX-STOCK

Selections are stored and automatically reused during future report uploads, reducing repetitive data entry.

Merged Backorder Report Preview

Displays the processed backorder data including:

Order Number
Customer Reference
Product Code
Product Description

This provides users with immediate visibility into all active backorders before delivery dates are updated or customer notifications are generated.

U-Haul Cost Calculator (Google Sheets + Apps Script)

MAIN DASHBOARD

The Main Dashboard serves as the user interface where pickup and drop-off addresses, optional stops, and vehicle details are entered. Once the user clicks the “Calculate Cost and Best U-Haul Location” button, the system automatically retrieves nearby U-Haul branches, calculates total trip distance, and computes estimated costs including fuel, mileage rate, base rate, insurance, tax, and environmental fee. The dashboard then highlights the best U-Haul location, displays the cost summary, and breaks down the mileage and total cost components.

RESULTS TAB

The Results Tab shows a complete ranked list of U-Haul locations within the search radius. Each entry includes the branch name, address, total mileage, fuel cost, truck fee, and overall total. This table gives users full visibility into how each branch compares in distance and total price. For instance, in the example shown, “U-Haul Moving & Storage of Chippenham” ranks among the top options with a total of $100.88, closely followed by nearby branches. The results are sorted from the lowest total cost to the highest, making it easy to identify the most cost-effective rental choice.

LOAN TRACKER

MAIN SHEET

The Loan Tracker sheet is the functional core of the tool. It allows the user to enter each payment’s due date, payment date, and amount paid, while all remaining values calculate automatically. Interest, principal, late fees, total received, and the updated loan balance adjust instantly based on the borrower’s actual payment behavior. This creates a clear, accurate running history of the loan without requiring the user to do any manual math.

GUIDE SHEET

The Guide sheet provides simple explanations of every input and every column in the payment table so the user always knows what they are entering and what the tracker is calculating. Each definition is written in plain language, and the gray input fields are clearly identified. This makes the tool easy to understand and use, even for someone with no technical or financial background.

Google Sites

Report abuse