Skip to main content

Spreadsheet to Solution

This track is designed for Operations Managers and Administrators who care about their specific workflow and getting results quickly.

If you have an existing Excel or CSV file and need a solved allocation without touching a single line of code, you're in the right place.

The Workflow​

To get from a spreadsheet to a solved allocation, you'll move through the core areas of our User Interface:

  1. Prepare your data: Make sure your spreadsheet is structured with clear columns (e.g., one column for resource names, one for target names, plus any attribute columns you want to match on).
  2. Create a project: Start from the Projects Overview dashboard.
  3. Import Resources & Targets: Use the Resources and Targets tabs to map your data.
  4. Customize labels & attributes: Make the software speak your language and define the characteristics the solver will match on.
  5. Apply Rules: Use the Rules tab to set constraints without writing code.
  6. Solve: Use the Solution tab to trigger the engine and review results.

1. Prepare Your Data​

Start with your existing Excel or CSV files. The import tool accepts both CSV uploads and pasted cell ranges copied straight from Excel or Google Sheets.

For best results, aim for a layout like this:

NameCapacitySubjectLocation
Alice20MathsLondon
Bob15PhysicsManchester
  • A Name column for each resource or target (you can also use unique identifiers such as Employee IDs or Script IDs).
  • A Capacity column for resources, or a Size column for targets.
  • Any extra attribute columns (Subject, Location, Language, etc.) that you want the solver to match on.

Privacy tip: You only ever need identifiers and attribute values. Never upload sensitive documents — keep your PII close by using the built-in Privacy Protection.

2. Create a Project​

Once your data is ready, log in and head to the Projects Overview page. From there you can:

  • Create a new project from a blank canvas to define everything from scratch.
  • Pick an Industry Template to start with pre-configured labels, attributes, and rules.
  • Use Load Demo Data to experiment with a sample dataset before importing your own.

3. Import Resources & Targets​

Now it's time to bring your spreadsheet into AutoAllocate:

  1. Open the Resources Tab and click Import — see the full guide on Managing Resources.
  2. Upload your CSV or paste a copied range from your spreadsheet.
  3. In the mapping dialog, tell AutoAllocate which column is the Name and which is the Capacity, and align the remaining columns with your custom attributes.
  4. Use the live preview to confirm the data will land exactly as expected.
  5. Toggle Privacy Protection on any text columns you want anonymized during the solve.
  6. Click Import to add your resources in seconds.

Repeat the same process for your Targets using the Targets Tab, selecting the Size column instead of Capacity. See Managing Targets for the key differences.

4. Customize Labels & Attributes​

Before applying rules, take a moment to tailor the project on the Overview Tab (Project Overview & Customization):

  • Custom Labels: Replace the generic "Resources" and "Targets" with your own terminology (e.g., "Markers" and "Assignments"). Headers and buttons update automatically.
  • Custom Attributes: Define the characteristics your rules will match on. Attributes can be Text, Number, or Date Range types. If you're matching on availability or deadlines, read our Scheduling & Dates guide first.

5. Apply Rules​

Rules are the "brain" of the allocation — see the full breakdown in Allocation Rules. The Rules Tab lets you add constraints without writing code:

  • Topology Rules: How many assignments are allowed (e.g., every target assigned to exactly one resource).
  • Capacity Rules: How much work each resource can accept, including minimum load thresholds.
  • Compatibility Rules: Attribute matching, exclusions (conflict of interest), and date overlap.

Iterate often: Solver success is an iterative process. If the solver returns an unfeasible result, it's usually because your rules are too restrictive — try loosening a constraint and re-running.

6. Run the Solver​

With your data and rules in place, open the Solution Tab:

  1. Click Run Solver.
  2. Review the pre-run confirmation showing your resource, target, and rule counts, together with the credit cost for this run.
  3. Watch the engine work — most projects solve in seconds.

For more detail on pricing, confirmation, and what happens while the engine runs, see Running the Solver & History.

7. Review & Export the Solution​

When the engine finishes, the results appear immediately in the Solution Tab (Analyzing the Solution):

  • Card View: Each resource shows its assigned targets and capacity utilization.
  • Table View: A spreadsheet-style overview of all assignments.
  • Unallocated/Unused: See which targets missed out and which resources are idle.

When you're happy, export the results back to Excel or CSV for use in your other tools. Every run is also recorded in your project's History Tab, so you can track how changing rules or data improves your allocation over time.

Next Steps​