Get the quote to count in whole pipes
The price list says how long a pipe is, and the quote orders whole pipes instead of metres.
- 1
Add a Length column (“Längd”) to the CSV file
Write the delivery length in metres on every product that is sold in whole lengths: 6 for a six-metre pipe. The heading can be längd, rörlängd, stånglängd or leveranslängd.
- 2
Leave Length (“Längd”) empty for items sold by the piece
Bends, junctions, chambers and reducers have no length. Leave the box empty on those rows.
Worth knowing. A reducer with a Length (“Längd”) filled in is never suggested on a reducer row (“Övergång”) in the quote — it is read as pipe. That is the commonest reason a reducer shows up red.
- 3
Fill in the unit
Write m for products that are priced per metre and st for products that are priced per whole item. If the unit column is missing altogether but Length (“Längd”) is filled in, the row is read as st (each).
- 4
Check for millimetres before you save
If the lengths are in millimetres — 6000 — they are converted to metres, and you get the warning “Längderna såg ut att vara i millimeter” (the lengths looked like they were in millimetres). Read those rows in the preview.
Worth knowing. Anything from 250 upwards is read as millimetres, since no product is sold in lengths longer than that.
- 5
Read the number in the quote
In the column Quantity incl. waste (“Mängd inkl. spill”) it says for instance “9 st à 6,0 m · behov 49,7 m” (9 off at 6,0 m · need 49,7 m). The need is your measured metres plus the waste allowance — 47,3 m measured becomes 49,7 m with 5 % waste — and the number is always rounded up to whole items: 49,7 divided by 6 is 8,3, so 9 pipes.
Worth knowing. 47,3 m of need becomes 9 pipes at 6 m, so 54 m paid for. The last 6,7 metres are not a calculation error — that is the remainder on the last pipe.
- 6
See what actually gets priced
If the item is priced per metre the sum is number × length × unit price, so 9 × 6 = 54 m in the example above. If it is priced per piece it is number × unit price. You pay for whole pipes, not for the 49,7 metres.
- 7
Put in every stock length you buy
If the same pipe is in the list as both 3 m and 6 m, Mängda picks the one that comes out cheapest for that particular row. If the pipes have no Length (“Längd”) at all, the row is priced straight off the measured metres.
Next steps
Do the steps on a real drawing
Open the tool and follow the walkthrough on the sample drawing that is already there. No login needed.
Open the toolStuck on a step? Get in touch — we are happy to take a look at your drawing.