---
title: "Creating and Importing a Labor Routing"
description: "This article explains the basics of Labor Routings and how to import them into Wheelhouse from a spreadsheet. Prerequisites. In order to create or import a routing, your profile must include the Prod…"
url: "https://support.wheelhousemfg.com/article/0e8hpvqkau-labor-routing-import"
category: "Labor Routings"
updated_at: "2024-08-01T21:13:03Z"
---

# Creating and Importing a Labor Routing

This article explains the basics of Labor Routings and how to import them into Wheelhouse from a spreadsheet.

#### Prerequisites

In order to create or import a routing, your profile must include the Production Admin role.

#### Labor Routing Terminology and Example

- To better understand the terminology used in this article, see [Production Definitions](/article/eizjem9gst-production-definitions-general)
- Labor Routings (or simply 'Routings') define and control the flow of products through your production facility. A routing includes steps (called operations), predecessors, standard times, and other important information about your process. The example below shows two different routings that share the last three operations at the paint, assembly, and shipping work centers. The green path represents one routing, while the red path represents another routing.

![](https://files.helpdocs.io/u2psp4t8yl/articles/0e8hpvqkau/1651629263675/image.png)

#### Creating a Basic Routing

Administrator privileges are required.

01. Define one or more Work Centers in **Production** -> **Setup** -> **Work Center**
02. Open **Production** -> **Setup** -> **Labor Routing**
03. Select the **(+ New)** or **(+)** button to create a new Labor Routing
04. Provide a Name (all other information is optional)
05. Click Save
06. Once saved, additional tabs will appear. Select the **Routing Designer** tab.
07. Click the **(+)** button to add a new operation.
08. Give the operation a name, and select the Work Center where the operation will be performed.
09. Add additional operations
10. To edit the dependencies between the operations:
    
    1. Click on a connector to delete it
    2. Drag a link from the predecessor box to the termination box
    3. Use the scroll wheel on your mouse to Zoom
    4. Press and hold your scroll, then drag to pan
11. Click Save to update the Labor Routing with the changes you've made. Review your routing to verify everything is correct.

#### Preparing your routing for import

1. Download this [Example Routing for Import.xlsx](https://files.helpdocs.io/u2psp4t8yl/other/1649438526608/example-routing-for-import.xlsx)
2. Update the spreadsheet with your own data. Start with a small set of operations for testing.
3. Multiple routings may be added to the same spreadsheet - just give them different names in the Labor Routing column

**Required Fields (Green highlighted in the example spreadsheet):** Ref (row number), Labor Routing (name), Operation, Per Unit Time, Lot Time, Time Unit

**Optional Fields** **(Yellow highlighted in the example spreadsheet):** Labor Routing Item, Work Center, WC Workflow Sequence, WC Area, WC Facility, Depends On Ops, Depends on Previous, Applies To, Instructions, Create Op Template

#### Importing your routing

1. Navigate to the Labor Routing list
2. From the lightening-action menu, select Add/Update Routing, select options, and import.

If the routing operation isn't found, it will be added. This won't delete previously added operations.

Upload the complete routing with a 'Ref' column and 'Depends On Ops' column if you want to import dependencies. The Depends on Previous option is nice for simple routings.

![](https://files.helpdocs.io/u2psp4t8yl/articles/0e8hpvqkau/1649971468575/example-labor-routi.png)