Plantilla Excel para rutas de reparto (gratis y en español)

Antes de cualquier software sofisticado, las rutas de reparto del mundo real se planean donde siempre: en Excel. Llevo veinte años construyendo modelos de optimización que leen sus datos de hojas de cálculo, así que armé una plantilla Excel para rutas de reparto — gratis, con los encabezados en español y con un ejemplo real de 24 entregas en la Ciudad de México — que además tiene un truco: la puedes optimizar con un clic.

Continue reading “Plantilla Excel para rutas de reparto (gratis y en español)”

What Is a 2-2-3 Schedule? (Free Schedule Builder)

If you run an operation that never shuts off — a plant floor, a hospital unit, a security desk, a call center — you have probably run into the 2-2-3 schedule, even if nobody handed you a diagram of it. A 2-2-3 schedule is a rotating pattern built around 12-hour shifts that keeps a facility covered 24 hours a day, seven days a week, while still giving each person a predictable rhythm of work and rest. It sounds like a phone extension, but it is really just a promise: you will never work more than three days in a row, and you will get every other weekend off.

That promise is why the pattern has stuck around in so many round-the-clock workplaces. Below I will walk through exactly how the days fall, why the math works out the way it does, and how you can build one for your own team in a couple of minutes.

2-2-3 schedule 14-day rotation grid
Continue reading “What Is a 2-2-3 Schedule? (Free Schedule Builder)”

Free Restaurant Staff Scheduling Software

Rush hour at a quick-service restaurant isn’t one job, it’s four running at once: someone on the register, someone on the line, someone working the drive-thru window, and a shift lead who has to be on the floor the entire time the store is open — not just during the manager’s hours.

Continue reading “Free Restaurant Staff Scheduling Software”

Optimizador de rutas gratis: mi planificador de repartos

Pasé más de veinte años construyendo modelos de optimización de rutas para empresas — flotas de reparto, distribución de alimentos, servicio en campo. Esos modelos vivían en archivos de Excel que solo yo podía correr, así que hace unos meses decidí publicarlos en la web, gratis. En este artículo te cuento qué debería tener un optimizador de rutas gratis de verdad, qué opciones existen hoy, y qué hace el mío distinto — con sus límites incluidos, porque también los tiene.

Continue reading “Optimizador de rutas gratis: mi planificador de repartos”

Onfleet Alternative: A Free Route Optimizer, No Minimum

Onfleet is one of the few routing and delivery platforms that actually publishes its pricing, which I respect. But the number itself, $599 a month to start, before you’ve routed a single stop, is exactly why people go looking for an onfleet alternative. I build optimization software for a living, and the free tool below solves the same routing math without a monthly minimum.

onfleet alternative — free route optimizer results map with optimized routes
Continue reading “Onfleet Alternative: A Free Route Optimizer, No Minimum”