Offcut spreadsheet: what to record, and a list that keeps itself up to date
Updated
An offcut spreadsheet is a list of the reusable pieces on your racks, with each piece's material, size, location and date, that you check before buying or cutting new stock. OffcutBench keeps that list free in your browser for straight lengths on one rack: recording a cut or a use updates it, each piece gets a label and a length search, and the list downloads as a CSV whenever you want it in a spreadsheet.
Free to use. No account, email address or trial. Works offline once prepared.
Each piece keeps its material, length, bin, batch, date and condition, on a handheld or scan station.
Which columns does it need?
At least the material, the size, where the piece is and when it went there, and for sheet offcuts the thickness, width and grain as well. OffcutBench handles straight lengths, one row per physical piece, so there is no quantity column. Its available pieces CSV has source_piece_key, material_code, length, length_unit, uncertainty, condition, batch, rack_code and bin_code. Each material code stands for its description, profile, grade, finish, colour and family, and the date each piece was recorded is in the history CSV.
Bring in your materials and bins from a CSV
If your materials and rack positions are already in a spreadsheet, save them as CSV and import them. The materials file has the columns material_code, description, profile, grade, finish, colour and family; the bins file has rack_code, bin_code, name, max_length, length_unit and material_families, where name repeats the rack name and families are separated by a pipe. OffcutBench previews the rows, keeps codes exactly as written, leading zeroes included, and adds all the rows or none. Templates for both files download from the import panel. Pieces are recorded one at a time, each measured and labelled.
A materials CSV is previewed and checked before anything is added.
Keep it current as pieces are used
A spreadsheet goes out of date the first time someone cuts a piece and forgets the row. In OffcutBench, recording the use is what changes the list: used whole takes the piece off, a cut takes it off and adds the remeasured remainder as a new piece with its own label, and scrap takes it off with a reason. Nothing is overwritten: each change is added to the piece's history.
Recording a use takes the piece off the available list.
Download the list and its history
Download the available pieces CSV whenever you need the list in a spreadsheet, and open it with the columns set to text so codes keep their leading zeroes. The history CSV has one row for every change, with the piece before and after, any cut, reason and job reference, and it adds an apostrophe before text a spreadsheet could treat as a formula. A rack list PDF prints the same available pieces.
Each change to a piece is kept, and the history CSV lists every one.
Keep a backup
A list is only as safe as its file. OffcutBench keeps the rack in this browser only when you choose Save on this device, and browser storage can be cleared, so download a backup too. The backup is one file with the rack, materials, bins, every piece and its full history. Importing it checks the whole file first, and an invalid file leaves the current rack untouched.
A backup to keep alongside the copy saved in this browser.
What OffcutBench does not do
It is not a spreadsheet: it does not open .xlsx files, sync with a shared sheet or let several people edit one list. It keeps one rack of straight lengths, with no sheets, quantities, prices or purchasing, and it does not nest or optimise cuts.
MADE FOR THE FLOOR
For workshop owners, fabricators, joiners and makers who keep their offcuts in a spreadsheet, or mean to, and want the list to match the rack.
A USEFUL STARTING POINT
A spreadsheet is right only until the next cut
An offcut spreadsheet needs a row deleted for every piece used and a row added for every remainder, and nothing ties a row to the piece on the rack. OffcutBench keeps the same columns and links each record to a labelled piece: recording a cut takes the old piece off and adds the remainder, and the CSV downloads whenever you need it. It records what you tell it, so check the rack against the list now and then.
FROM QUESTION TO EVIDENCE
Three steps to a useful result.
01
Bring in what you have
Import your materials and bins from CSV after a preview, or type them in, then measure and record each offcut on the rack with its own label.
02
Record each use
When a piece is used, cut or scrapped, open it from a search or its label and record what happened. A kept remainder gets its own label.
03
Download the list
Download the available pieces CSV or the history CSV whenever you need them in a spreadsheet, and keep a backup of the whole rack.
A CONCRETE EXAMPLE
One cut, two rows changed
A joinery shop keeps its timber offcuts in a spreadsheet. Its materials, such as OAK-45 for 45 x 45 mm oak, import from CSV after a preview, and the offcuts are measured and labelled bin by bin. When a 1200 mm length of OAK-45 is cut into two 400 mm rails, the cut is recorded and the remainder is remeasured and labelled. The next available pieces CSV no longer lists the 1200 mm piece, and lists the remainder with its new identifier.
USED IN PRODUCTION
From one rack to the whole workshop.
OffcutBench keeps one person's list for one rack. When several people cut from shared racks, RemnantRack keeps the offcut register for the whole team. It is in early access, with scope agreed at onboarding.
Early access
RemnantRack
RemnantRack gives every reusable offcut a label, an exact length and a confirmed bin across your racks. Search for the length a job needs, reserve the piece so nobody else takes it, record the cut and label the remainder, with team access and a history for every piece.
Your materials and bins, yes, from CSV after a preview. The pieces themselves are recorded one at a time, because each one is measured and given its own label as it goes on the list.
Can I open the CSV in a spreadsheet?
Yes. Open it with the columns set to text, so codes and identifiers keep their leading zeroes. The available pieces CSV keeps exact values for importing into other systems; the history CSV adds an apostrophe before text a spreadsheet could treat as a formula.
How do I keep track of offcuts without a spreadsheet?
Our page "How to keep track of offcuts" covers the routine: a length worth keeping, a label for each piece, a bin for every piece, a search before cutting new stock and a record of each use.
What are the current limits?
OffcutBench is one person's list for one rack of straight lengths, such as bar, tube, extrusion, profile or timber. There are no sheets or irregular shapes, no nesting or cutting optimisation, no reservations, no shared team stock and no saw control, and a search never reserves or changes a piece. Each search looks for one piece long enough for the whole job. A project holds one rack with up to 100 bins, 500 materials, 2,000 available pieces and 20,000 history records, in a saved file of at most 5 MiB. Lengths run from 1 mm to 60 m. The unit is fixed when the rack is created, and the usual measuring uncertainty is fixed once the first piece is recorded. CSV imports are up to 5 MiB, and one invalid row stops the whole import. The camera reads QR, Code 128, Data Matrix, EAN and UPC barcodes. Labels and reports show what you recorded, not proof that a piece is on the rack.
What happens to my data?
Your rack stays in this browser. Work starts in memory and is lost on refresh until you choose Save on this device or download a backup. Nothing you record, scan or download is uploaded, and camera images are decoded on your device and never stored. No account or contact details are needed. Google Analytics is optional and loads only after you accept; it never receives materials, lengths, label codes, job references or file contents. Use Analytics settings on these pages or in the tool to change your choice; see /privacy/.
ONE SMALL JOB, DONE WELL
Put OffcutBench to work.
Open the free tool and start with one known example.
Practical tools. Useful on their own. Better around the same floor.
Automate factory decisions with rules you describe in plain English. Explore focused SmartFACT services, plus free tools for everyday checks.
Early accessSuggested next step
RemnantRack
Label each offcut, find a suitable length before cutting new stock and record what you used. Approved plain English rules decide what to keep and where it goes.
Bring data in from uploaded sheets or the Shopify, WooCommerce and PrestaShop connectors, check each change and deliver it to the products that use it.
Scan an empty container to send the right refill request to stores. Approved plain English rules set the stores queue, priority, ticket printer and escalation.
Check a shared tool before handover, record who has it and keep damaged or overdue tools out of the next issue. Explore an invited trial for one factory crib.
Receive, put away, reserve and issue stores material with barcode checks, keeping held, reserved and available stock apart. Explore an invited trial for one stockroom.
Follow a lot or serial number through the records your factory already keeps, with the source of each link and the gaps shown. Explore an invited trial with two declared sources.
Step-by-step guides and interactive demonstrations for the SmartFACT suite. Read the instructions, watch a task or practise with real product screens and sample data.