---
title: "The classic Halloween dilemma: how to visit as many homes as possible solved by Eric Koleda with a little Apps Script"
author: "Martin Hawksey"
date: 2019-10-30T11:36:03+00:00
modified: 2019-10-30T11:36:58+00:00
canonical_url: https://pulse.appsscript.info/p/2019/10/the-classic-halloween-dilemma-how-to-visit-as-many-homes-as-possible-solved-by-eric-koleda-with-a-little-apps-script/
markdown_url: https://pulse.appsscript.info/p/2019/10/the-classic-halloween-dilemma-how-to-visit-as-many-homes-as-possible-solved-by-eric-koleda-with-a-little-apps-script.md
categories:
  - "Maps"
  - "Sheets"
  - "Solutions"
tags:
  - "@erickoleda"
  - "Twitter"
description: "The classic Halloween dilemma: how to visit as many homes as possible, making sure to hit the houses that give out full size candy bars. Google Sheets +Apps Script to the rescue! Simply enter a..."
---

# The classic Halloween dilemma: how to visit as many homes as possible solved by Eric Koleda with a little Apps Script

> The classic Halloween dilemma: how to visit as many homes as possible, making sure to hit the houses that give out full size candy bars.
> Google Sheets +Apps Script to the rescue! Simply enter a few addresses and it will calculate the optimal path.[https://t.co/MMe6p0tVVy](https://t.co/MMe6p0tVVy) [pic.twitter.com/nexAAJ037X](https://t.co/nexAAJ037X)
> — Eric Koleda (@erickoleda) [October 29, 2019](https://twitter.com/erickoleda/status/1189298667108392960?ref_src=twsrc%5Etfw)

---

*Published by [Martin Hawksey](https://pulse.appsscript.info/p/author/admin/) on [Pulse](https://pulse.appsscript.info/). Original article: [https://pulse.appsscript.info/p/2019/10/the-classic-halloween-dilemma-how-to-visit-as-many-homes-as-possible-solved-by-eric-koleda-with-a-little-apps-script/](https://pulse.appsscript.info/p/2019/10/the-classic-halloween-dilemma-how-to-visit-as-many-homes-as-possible-solved-by-eric-koleda-with-a-little-apps-script/)*