2021 Spreadsheet Builders' Challenge Solutions Now Available

Originally published at: 2021 Spreadsheet Builders' Challenge Solutions Now Available - Tiller

You might recall the Tiller 2021 Spreadsheet Builders Challenge that we announced back in October 2021. After selecting three incredible builders from a strong pool of applicants and supporting them to realize their concepts over the past months, we are excited to unveil their creations!

Announcing the three newest templates available immediately in the Tiller Community Solutions Add-on:

Category Schedule

The Category Schedule by @Brad.warren allows you to plan, list and track the specific items of a budget category, roll up monthly totals, and dynamically link the plans to drive your budget on the Category sheet. The solution is a brainstorming/planning tool. Consider which of your categories have specific events, costs or activities for which you’d like to make a budget plan. A helpful formula allows you to link the resulting budget allowances into your Categories sheet budget.

Recurring Expenses

Studies show that people tend to lose track of recurring transactions. These monthly expenses can add up, blow up budgets, and prevent you from realizing your financial goals.

The Recurring Expenses template by @adambecker will help you identify recurring transactions. The template uses formulas to look for patterns in your Transactions sheet and scores & presents likely recurring expenses grouped by the Description field. A query tool allows you to drill down into payees at the per-transaction level.

Travel Planner

The Travel Planner by @catpatriciamorgan can help you plan and analyze your travel spending. You can plan your spending for specific trips and monitor your progress toward spending your total annual vacation budget all in one place.

Upcoming Builder Webinars

Each builder will join us for an upcoming Tiller Community Builder’s Workshop where the creators will explain how their solution works, explain how they built it, and answer your questions.

Register even if you can’t attend and we’ll email you a link to more resources including the recorded session.

Category Schedule by @Brad.warren

January 20, 2022 @ 1:30PM EST

Click here to register

Recurring Expenses by @adambecker

February 3, 2022 @ 1:30PM EST

Click here to register

Travel Planner by @catpatriciamorgan

February 17, 2022 @ 3PM EST

Click here to register

How To Install

Quickly add any or all of these templates to any Tiller-powered Google Sheet using the Tiller Community Solutions add-on.

  1. Open your Tiller-powered Google Sheet
  2. Install or launch the Tiller Community Solutions add-on
  3. Open the add-on and choose “Builder Contest” from the tags dropdown on the Explore tab
  4. Click on the template you’d like to install
  5. Choose “Add to spreadsheet”

Congratulations to each of our builders on your template. We are grateful for all the energy you put into these creations.

2 Likes

This post was flagged by the community and is temporarily hidden.

What a fun way to start 2022 - so exciting to see these solutions! @Brad.warren @adambecker @catpatriciamorgan thanks for the great work you put into these. I’ll be eager to catch the webinars. I love seeing what this Community generates.

And to all of our other builders or want-to-be builders out there, keep it up! You don’t have to wait for a Builders Challenge to build and share something you find useful.

1 Like