Who is this choice relevant to?

Index keeper who wants to check duplicate entries

You want to find patterns easily without accidentally merging different editions or versions. Microsoft Support explains how to filter temporarily and permanently remove duplicates in Excel; LibreOffice Help explains how to filter duplicate values in Calc.

Digital pattern collector

You manage pattern files as well as an index, so you’ll want to factor storage and restorable backups into your choice. Microsoft Support explains how to back up to an external drive, network location or the cloud.

User with limited workspace

You’re looking for a desktop computer that fits your available space, with room for a suitable monitor and input devices. The compact desktop configurations reviewed from Dell, Lenovo and Apple differ in their operating systems and connections, among other things.

What should you consider when choosing?

Start with the software and workflow you want to keep, then compare storage, backups and the complete setup, including a monitor and input devices.

Compact Intel Windows desktop

A good fit if: you want to keep using your Windows index, Excel files or existing Windows peripherals.

Bear in mind: check what’s included with the configuration; you may need to buy a monitor and input devices separately.

Mac mini with M6 chip

A good fit if: you want to use macOS and have checked in advance that your index files and software work with it.

Bear in mind: check whether any Windows programmes are compatible with macOS; the base configuration described has 256 GB SSD storage.

Compact Arm Windows desktop

A good fit if: you’ve confirmed that your specific indexing programme and any scanner or printer software work with Windows for Arm.

Bear in mind: check the software for the exact configuration; the Lenovo model reviewed has 256 GB SSD storage and doesn’t include a mouse or keyboard.

Consideration What should you check? Who is this important for?
Checking duplicates safely Decide which fields together identify a pattern. Filter or flag suspected duplicates, and keep a copy before deleting anything. If you don’t want to merge different editions or versions, you’ll want to check what is being classed as a duplicate first. Around 33% of consumers give safely checking duplicates their highest priority.
Keeping pattern files safe Compare the SSD capacity of the exact configuration and choose an external or cloud backup that includes your files; test that you can restore a file. If you manage digital patterns as well as your index, you’ll want enough storage and a restorable copy. Around 27% of consumers give keeping and being able to restore pattern files their highest priority.
Workspace in a limited space Check the monitor connections and whether a monitor, keyboard and mouse are included with the configuration you’ve chosen. If space is limited, you’ll want the computer and the peripherals you need to fit in your workspace together. Around 20% of consumers give making their permanent workspace fit their highest priority.
Existing software and devices Check support for your exact programme and version on Windows, macOS or Windows for Arm; also check your scanner and printer software. If you want to keep your current indexing workflow, you’ll want to know whether your programmes and devices will continue to work with the computer you choose. Around 20% of consumers give keeping their existing software their highest priority.

Which buying mistakes can you avoid?

  • Assuming a duplicate entry is automatically unnecessary

    A filter can temporarily hide duplicate values, while deleting them permanently removes them from the selected range. You may have good reason to list different editions or versions separately in your index.

    Decide which fields you’re comparing, check the entries found and work on a copy first.

  • Looking only at the computer itself

    A compact desktop isn’t automatically a complete workstation. The Lenovo configuration reviewed doesn’t list a standard keyboard or mouse; for each configuration, also check whether you need a monitor and spreadsheet software.

    Before choosing, check which peripherals and software you already have and which connections the computer offers.

  • Assuming Windows for Arm is the same as any Windows desktop

    The Lenovo Qualcomm configuration reviewed runs Windows 11 Home 64 for Arm. The fact that it runs Windows doesn’t automatically mean your own indexing programme will work.

    Confirm that your exact software and version are supported before choosing this configuration.

  • Thinking extra SSD space counts as a backup

    Files stored on the same computer don’t give you a separate recovery copy if the computer fails or files are lost.

    Set up a backup in a separate location, such as an external drive, network location or the cloud, and test that you can restore a file.

Which brands are worth considering?

Dell

The Pro Micro QCM1250 reviewed is a compact business Windows desktop for a permanent workstation.

  • The configuration described includes Windows 11 Pro, 16 GB DDR5 and a 512 GB SSD.
  • Dell lists Office as a separate software option, so check whether Excel is included with the configuration you choose.

Lenovo

The ThinkCentre Neo 50q was reviewed in Intel and Qualcomm configurations; note the differences in processor platform and operating system.

  • The Intel Gen 5 configuration lists Windows 11 Pro, 16 GB of memory and a 512 GB SSD.
  • The Qualcomm configuration runs Windows 11 Home 64 for Arm, has 256 GB SSD storage and is described as coming without a mouse or keyboard. Check the configuration and software compatibility separately.

HP

The Pro Mini 400 G9 is a compact business Windows option for a permanent workstation.

  • The 6D494EA#ABH configuration reviewed lists Windows 11 Pro, 16 GB RAM, a 512 GB SSD and a wired mouse.
  • Check that the exact configuration is available and what’s included.

Apple

The Mac mini is the compact macOS option for anyone who wants to use their indexing workflow on a Mac.

  • Apple describes an M6 base model with 16 GB of unified memory and a 256 GB SSD; a 512 GB configuration is also available.
  • Check in advance that your indexing software and peripherals work with macOS; these specifications don’t show that Windows software will work on it.

Joybuy desktops for a knitting pattern index

This Joybuy selection features compact desktops for a permanent workstation. Check that your indexing software and peripherals work with each model.

Mac mini with M6 chip, 16 GB and 512 GB SSD

Mac mini with Apple M6 chip, 16 GB, 512 GB SSD

An option for a compact workstation if you want to use macOS; check in advance that your indexing software and files work with it.

Apple M6 chip; 16 GB memory; 512 GB SSD storage. The product description lists Thunderbolt 4, USB-C and HDMI, and support for up to three external displays.

View at Joybuy
FIREBAT Mini PC A6 with AMD Ryzen 7 7735HS, 16 GB RAM and 512 GB SSD

FIREBAT Mini PC A6, AMD Ryzen 7 7735HS, 16 GB RAM, 512 GB SSD

A compact mini PC for a permanent workstation; check that the operating system and connections suit your indexing software and devices.

AMD Ryzen 7 7735HS; Radeon 680M; 16 GB RAM; 512 GB SSD. The product description lists two M.2 slots and support for three displays.

View at Joybuy
SOYO M5 Mini PC with Windows 11 Pro, 16 GB and 512 GB SSD

SOYO M5 Mini PC, Windows 11 Pro, 16 GB, 512 GB SSD

A compact Windows desktop to consider if you want to use Windows software; also check that you can connect your existing peripherals.

AMD Ryzen 4300U; Windows 11 Pro; 16 GB LPDDR4; 512 GB SSD. The product name lists HDMI 2.0, Type-C and DisplayPort 1.4.

View at Joybuy
FIREBAT R3 Mini PC with AMD Ryzen 5 7430U, 16 GB RAM and 512 GB SSD

FIREBAT R3 Mini PC, AMD Ryzen 5 7430U, 16 GB RAM, 512 GB SSD

A compact mini PC for a permanent workstation; check that the configuration and connections suit your indexing software and monitor.

AMD Ryzen 5 7430U; 16 GB RAM; 512 GB SSD; Wi-Fi 6. The product name lists output for three 4K displays.

View at Joybuy
FIREBAT F1 Mini PC with AMD Ryzen 5 7640HS, 24 GB RAM and 512 GB SSD

FIREBAT F1 Mini PC, AMD Ryzen 5 7640HS, 24 GB RAM, 512 GB SSD

A compact mini PC for a permanent workstation; check the connections you need for your monitor and peripherals in advance.

AMD Ryzen 5 7640HS; 24 GB LPDDR5 RAM; 512 GB PCIe 4.0 SSD. The product name lists USB 4.0, HDMI 2.1 and support for three displays.

View at Joybuy

Frequently asked questions

Will a computer automatically remove duplicate knitting patterns?

No. Filtering or deleting duplicates happens in the software you choose, not through a particular desktop model. Excel distinguishes between temporarily filtering and permanently deleting entries; make a copy first and decide which fields in your index together define a duplicate.

How do I keep my index and pattern files safe on a new Windows PC?

First, check that all your index and pattern files have been transferred. Microsoft Support explains how to back up to the cloud, an external drive or a network location; choose a method that includes your files and test that you can restore one.

Does a Windows desktop come with Excel as standard?

Not necessarily; having Windows doesn’t mean Excel is included. Dell lists Office as a separate software option for the configuration reviewed, so check what’s included with the exact offer. LibreOffice Calc is another spreadsheet option, and LibreOffice Help explains how to filter duplicate values in it.

What are my rights if a desktop bought in the Netherlands doesn’t work properly?

According to the Dutch government, when you buy as a consumer, you’re entitled to a product that works properly, and the seller is responsible for providing a solution if the product is faulty. The Netherlands doesn’t have a fixed statutory warranty period for all products. For online consumer purchases, you generally also have a cooling-off period of up to 14 days after delivery; check whether an exception applies to your order.

What should I do with my old computer?

According to the Dutch government, you can hand in an old computer to the retailer when buying a similar device, or take it to your local council recycling centre. First, back up any files you want to keep and remove your personal data before handing over the computer.