GAUGE CONVERTER MANUAL

Gauge Converter Spreadsheet mock up image

Poppy Shop Gauge Converter: User Manual

Understanding the Spreadsheet Layout

Dark Blue Cells: These are Input Fields. Enter your values here, such as your personal stitch gauge or the pattern gauge. You do not need to fill in every dark blue cell; only enter data into the sections relevant to what you want to calculate.
Light Blue Cells: These are View Only Fields. These are auto-calculated results based on your input. Do not edit these cells.

Step 1: Choose Your Measurement System

Look at the very bottom left corner of your screen. You will see two different sheet tabs. Click the Inches (IN) tab if your pattern and swatch are measured in inches, or click the centimeters (CM) tab if you are using metric measurements.

Step 2: Enter Your Baseline Gauges

You must fill out this top section first for the rest of the spreadsheet to calculate correctly.

GAUGE 1 (pattern gauge): Enter the pattern's required stitches and rows per 4 inches into the dark blue cells.
GAUGE 2 (your gauge): Enter the stitches and rows per 4 inches from your personal swatch into the dark blue cells. The spreadsheet will automatically calculate the stitches and rows per inch.

Step 3: Stitch & Row Multipliers

Once your baseline gauges are entered, this section auto-calculates your Stitch Multiplier and Row Multiplier based on the difference between Gauge 1 and Gauge 2. These numbers are the foundation for adjusting the pattern to your specific gauge.

Step 4: Individual Conversions

Use these sections for one-off calculations. There are separate calculators under GAUGE 1 and GAUGE 2, but you will primarily use the GAUGE 2 column to figure out your own personal math.

Convert Sts to Inches: Input a stitch count into the dark blue cell to see how many inches and centimetres it measures.
Convert Rows to Inches: Input a row count into the dark blue cell to see the resulting measurement.
Convert Inches to Stitches/Rows: Input a target measurement to see exactly how many stitches to cast on, or how many rows to work.

Step 5: Target Measurement Based on Your Gauge

Use this section when you need to hit a specific size using your personal gauge.

Enter your target size in inches, and the calculator will output the exact number of stitches to cast on or rows to work.

Step 6: Adjusted Sizing Calculators

Use these tables on the far right to adjust an entire pattern schematic at once.

Enter the pattern sizes (e.g., S, M, L) and their corresponding pattern measurements in inches into the dark blue cells.
The table will output your adjusted measurements in both inches and centimetres.

Real-World Example: Converting a Hat Pattern

Let's put it into practice using a pattern.

The Problem:

The pattern gauge is 12 stitches and 16 rows per 4 inches.
Your personal swatch gauge is 14 stitches and 18 rows per 4 inches.
The pattern instructs you to cast on 54 stitches for the brim (which creates an 18-inch circumference based on the original pattern gauge).

How to get your new cast-on number:

Enter 12 and 16 into the GAUGE 1 input cells.
Enter 14 and 18 into the GAUGE 2 input cells.
Scroll down to the Convert Inches to Stitches section under GAUGE 2.
Since the original hat brim measures 18 inches, type 18 into the "Input Inches" box.
The calculator will instantly tell you to cast on 63 stitches to achieve that exact same 18-inch fit with your personal tension.

🚨 CRITICAL FINAL STEP: Check the Stitch Multiple The calculator provides the exact mathematical number for your size (63 stitches). However, you must always check if the pattern requires a specific stitch multiple. For example, if the hat's brim uses a 2x2 ribbing, it requires a multiple of 4 stitches. Since 63 is not a multiple of 4, you would simply round your cast-on number to the nearest multiple (in this case, round up to 64 stitches or down to 60 stitches) so the pattern repeats align perfectly.

Want to understand the math behind the calculator?

If you want to learn how these conversions actually work, or if you want to learn how to choose a completely different pattern size based on your personal gauge, read the full tutorials here:

🚨 IMPORTANT: A Note on Complex Designs While this calculator does the heavy lifting with the math, please remember that adjusting a pattern to a completely new gauge is not always a magic fix. For straightforward projects—like hats, simple drop-shoulder garments, and blankets—these conversions are usually seamless.

However, if your pattern features complex shaping (like intricate necklines, tailored armhole decreases, short rows, or elaborate lace motifs), adapting it to a new gauge requires a solid understanding of garment construction. The calculator will give you the exact adjusted numbers, but it is up to you to weave those numbers logically into the designer's shaping instructions so the garment still fits together properly.