Moving off spreadsheets
Running a window shop on spreadsheets: what changes when you move, and what it takes.
Plenty of window and door shops quote from a price workbook, keep the schedule on a sheet and the job status on a whiteboard. It works until the person who understands the workbook is on holiday, or two copies of the price sheet disagree. This page is for shops thinking about moving off spreadsheets: what moves where, what the first weeks involve, and the honest amount of work.
What each spreadsheet becomes
| In a spreadsheet today | In Extrusia |
|---|---|
| A price page per product, width by height | Uploaded as a price grid. A price page is already the shape that import expects. |
| A united-inch or square-foot ladder | Uploaded as price tiers for the series. |
| A pricing workbook full of formulas | Decoded with you, then proven against quotes you already sent before anyone relies on it. |
| An extruder's cost workbook | Read into bill-of-material cut formulas and a rate per finish. Extrusia replays the sheet's own arithmetic and refuses it if it cannot reproduce it. |
| Customer, vendor and sales rep lists | Uploaded from CSV files. |
| Parts, stock and supplier price lists | Uploaded as an item master and supplier price lists. |
| The production schedule | Built from the orders themselves: jobs batched onto production carts, and each bench's scans moving them on the schedule and the wallboards as it happens. |
| Open invoices and opening balances | Uploaded as open invoices, a chart of accounts and a trial balance. |
Every upload is checked as a dry run first: you see what it would write before anything is written. If you have no price book at all and quote by hand, you can start from a starter catalog and price it as you go.
What the first weeks involve
The setup screens walk through the same order every shop goes through. How long each step takes depends mostly on your pricing.
Company basics and your team
Who signs in, and what each person's job is.
Product catalog and pricing
Series, options and rules, then the price pages. This is the step that takes the time.
A price check against real quotes
Quotes you have already sent are priced in Extrusia and compared with what you charged, so differences are found before a customer finds them.
Customers, vendors, items and stock
The lists that already exist, uploaded rather than retyped.
Shop setup
Your work centers, defect codes and delivery trucks, and the benches that will scan.
Opening balances and open documents
Where your books stand on the day you start, if you run your accounting in Extrusia.
The honest amount of work
- Somebody who knows your pricing. A formula price book has to be decoded and checked against quotes you know are right. That needs a person on your side who can say what each difference means.
- Bills of material, if you build. With no extruder workbook, cut formulas are measured off your cut charts or fitted from real cut lists. If you buy finished units, a series can be marked as bought and you may not need bills of material at all.
- One area at a time. Every module is included, and you switch each one on as your shop is ready for it. Machines are connected one at a time.
- Readiness decides, not a calendar. We would rather tell you a week late than quote a customer wrong. You start quoting in Extrusia when your prices check out.
What you keep from the spreadsheet
Spreadsheets are still useful for looking at numbers. Extrusia's columnar reports print as a PDF and download as a spreadsheet file with the same columns, and reports can be emailed to you on a schedule.
What changes on day one
One price book instead of several copies. A quote that is checked against your rules as it is typed. A quote that becomes the order, the cut list, the glass order and the stickers without being retyped. And a schedule that moves when a bench scans a window, not when somebody updates a cell.
Note: Excel is a trademark of Microsoft Corporation. Extrusia is not affiliated with or endorsed by Microsoft.
Moving off spreadsheets — common questions
Do we have to retype our price sheets?
Usually not. A width-by-height price page and a united-inch ladder each upload as a file. A pricing workbook full of formulas is decoded with you and checked against quotes you already sent.
How long does it take to move off spreadsheets?
It depends mostly on how your prices are worked out. You start quoting in Extrusia once your own quotes come out right, not on a fixed date.
We are a small shop. Is an ERP too much?
You switch on what you need. A shop can start with the catalog, quoting and orders, and add the shop floor, machines and accounting when it is ready. Every module is included either way.
Can we still get our numbers into a spreadsheet?
Yes. Columnar reports download as a spreadsheet file with the same columns as the printed report.
What if we do not have bills of material?
Cut formulas can be read from an extruder's cost workbook, measured off your cut charts or fitted from real cut lists. If you buy finished units, you may not need them.