You will get a Google Form waste tracker that feeds into a live dashboard
Project details
Most shop managers are either writing waste down on paper or texting it to someone at the end of the day. By the time that information reaches a spreadsheet, half of it is missing or wrong.
This project fixes that with a Google Form your staff fill out on their phones at the end of each shift. It takes under a minute to complete. The moment they hit submit, the data lands in a connected Google Sheet — already sorted by date and store location — with no manual copying involved.
A location analysis table shows exactly how much waste each branch is recording and how often. A product breakdown tells you which items keep coming back and why. A daily trend chart covers the full reporting period. And a reasons table separates damaged stock from customer returns, overstock, and defective items so you can actually tell where the problem is coming from.
Everything updates automatically every time someone submits the form. You just open the sheet and the numbers are there.
This project fixes that with a Google Form your staff fill out on their phones at the end of each shift. It takes under a minute to complete. The moment they hit submit, the data lands in a connected Google Sheet — already sorted by date and store location — with no manual copying involved.
A location analysis table shows exactly how much waste each branch is recording and how often. A product breakdown tells you which items keep coming back and why. A daily trend chart covers the full reporting period. And a reasons table separates damaged stock from customer returns, overstock, and defective items so you can actually tell where the problem is coming from.
Everything updates automatically every time someone submits the form. You just open the sheet and the numbers are there.
Data Entry Type
Copy Paste, Data Cleansing, Document Conversion, Error DetectionData Entry Tool
Google Docs, Google SheetsWhat's included
| Service Tiers |
Starter
$40
|
Standard
$90
|
Advanced
$130
|
|---|---|---|---|
| Delivery Time | 2 days | 3 days | 5 days |
Number of Revisions | 2 | 3 | 4 |
Number of Hours of Work | 2 | 4 | 7 |
Formatting & Clean Up | - | ||
Graph & Table Creation | - |
Optional add-ons
You can add these on the next page.
Fast Delivery
+$10 - $30
Additional Revision
+$10
Additional Hour of Work
+$15
Formatting & Clean Up
(+ 1 Day)
+$15
Graph & Table Creation
(+ 1 Day)
+$20Frequently asked questions
About Samuel
Virtual Assistant | Excel & Data Support | Content Writer
Accra, Ghana - 11:34 pm local time
I'm training toward becoming a Chartered Accountant (ACCA), and that background shapes the way I approach spreadsheets, reports, and business data. I care about making spreadsheets and reports easy to understand and practical to use — not just clean on the surface.
Alongside my accounting studies I've completed certifications in Data Analytics, Google AI, Excel, Data Literacy, and Asana — skills I use daily across spreadsheet work, data cleaning, tracking systems, and workflow organization.
Beyond data work, I also write. My background in media includes writing entertainment and sports articles for publication, managing a sports Facebook page, and working on production projects including a Club Beer Ghana documentary and the Ghana Football Awards 2019. Working across writing, social media, and production taught me how to stay organized, communicate clearly, and adapt quickly when things change.
Services I Offer:
Excel spreadsheet management and reporting
Data entry and data cleanup
Internet research and data collection
Expense tracking and spreadsheet organization
Content writing and article formatting
Administrative and virtual assistant support
Google Sheets and Microsoft Excel support
Asana and workflow organization support
Available for both short and long-term projects. If you need someone who treats your work with the same care you do, send me a message.
Steps for completing your project
After purchasing the project, send requirements so Samuel can start the project.
Delivery time starts when Samuel receives requirements from you.
Samuel works on your project following the steps below.
Revisions may occur after the delivery date.
Set up the form structure
I'll build the Google Form with dropdowns for location, category, product, and waste reason — kept short so staff can fill it out in under a minute on their phones.
Connect it to Google Sheets
The form links directly to a response sheet that captures every submission with a timestamp, date, location, and product details automatically.