Enter the room size (length × width or perimeter), the ceiling height, the doors and windows, and the wallpaper width, pattern repeat and waste percentage. Roll length and price are optional (if left blank, they are not calculated).
| Width (m) | Height (m) | Count | |
|---|---|---|---|
| 1 | |||
| 2 | |||
| 3 | |||
| 4 | |||
| 5 | |||
| 6 |
Table of Contents
-
What you can do on this page
-
What is this calculation used for?
-
How to Use
-
Formulas and figures
-
Symbols and terms
-
Good to know before you start
-
How to calculate it in Excel
-
How to calculate it in Google Sheets
-
How to calculate it in Python
-
How to write it in LaTeX and other math languages (copy and paste)
-
How to have ChatGPT do the calculation
-
DataChef Features
-
Related Features
-
NumberChef Calculators List
What you can do on this page
- Enter either the room length × width or the perimeter, plus the ceiling height, and you get the length of wallpaper you need on the spot
- The number of strips comes from the net wall area, with doors and windows (up to 6 sizes × count) taken out, so you do not buy far too much
- For patterned wallpaper, the length of each strip is rounded up to a whole number of pattern repeats (you can see in the formulas how much pattern matching adds)
- Enter the waste percentage (10% by default), the roll length and the price to also get the length with waste, the number of rolls (double rolls are standard in the US) and an estimated cost
- A plain-language explanation of the formulas and copy-and-paste formulas for Excel, Google Sheets and Python are all on this page
What is this calculation used for?
Peel-and-stick wallpaper has made DIY wallpapering popular, even for renters. For a 12 × 10 ft room with an 8 ft ceiling, one door and one window, plain 20.5 in paper takes 24 strips × 100 in = 200 ft, or about 220 ft with 10% waste.
Switch to a paper with a 21 in repeat and each strip becomes 105 in, so the same room needs 231 ft. In both cases one 33 ft double roll gives only 3 strips, so you need 8 double rolls. Knowing this before you buy saves you from running short on the last wall.
Papering just one wall, such as the wall behind the TV or the bed, is one of the most popular DIY projects. For a wall 10 ft wide with an 8 ft ceiling, choose "Perimeter" and enter 10: \(\lceil 120 \div 20.5 \rceil = 6\) strips. Plain paper takes 6 × 100 in = 50 ft, or 55 ft with 10% waste (2 double rolls).
With a 24 in repeat, each strip is \(24 \times \lceil 100 \div 24 \rceil = 120\) in (10 ft), so you need 60 ft, or 66 ft with waste. The larger the repeat, the more the length changes.
A quote for wallpapering often lists the quantity by area, such as "wallpaper install, 319 sq ft × unit price", and that square footage is calculated the same way as the net wall area on this page (perimeter × ceiling height − openings).
If you work out the area yourself with the same formula, it is easier to check in the meeting whether the quantity matches the room and whether the ceiling is included. (A real quote also includes surface preparation, removal of old paper and trip charges, so the square footage alone cannot tell you whether the price is fair.)
For a small cafe or office, the owner often chooses wallpaper samples and the contractor works out the quantities. Wallpaper catalogs always list the width and the pattern repeat, and a paper with a large repeat needs more length for the same wall, which raises the material cost.
Being able to estimate "how much more this pattern needs" lets you balance design and budget yourself. Patterned paper also takes the installer more time, so the labor cost may change too.
For a stage backdrop or a photo booth at an event, you make "room walls" by covering plywood or fabric panels with wallpaper. Enter the total width of the panels as the perimeter to get the length you need.
Patterned papers such as brick or wood grain need pattern matching, and if you do not allow for the rounding up by the repeat, the last strip often comes up short. On a tight budget, such as a school play, this calculation really helps.
Formulas and figures
Symbols and terms
Symbols
| \(L\) | ell | The room perimeter (the total width of the walls). If you enter length × width, \(L = 2 \times (\text{length} + \text{width})\). \(L\) is from "length". |
| \(H\) | aitch | The ceiling height (from the floor to the ceiling), from "height". |
| \(D\) | dee | The total area of the openings (doors, windows and other parts you do not paper) - width × height × count for each size, added up. Think of it as "D for door". |
| \(A\) | ay | The net wall area. It is found with \(A = L \times H - D\) (plus any extra area). \(A\) is from "area". |
| \(W\) | double-u | The wallpaper width. Standard US double rolls are 20.5 in wide. \(W\) is from "width". |
| \(R\) | ar | The pattern repeat (the vertical length after which the pattern repeats). Plain paper counts as 0. \(R\) is from "repeat". |
| \(m\) | em | The trim allowance at the top and bottom, added together - the extra length for trimming at the ceiling and the floor. About 2 in at each end (4 in in total) is typical. \(m\) is from "margin". |
| \(\ell\) | script ell | The length per strip. It is found with \(\ell = R \times \lceil (H + m) \div R \rceil\) (\(H + m\) for plain paper). A script lowercase letter is used to tell it apart from the perimeter \(L\). |
| \(n\) | en | The number of strips needed. It is found with \(n = \lceil A \div (W \times H) \rceil\). \(n\) is from "number". |
| \(\rho\) | rho | The waste rate. For 10%, \(\rho = 0.1\) and you multiply by \(1 + \rho = 1.1\). It is a Greek letter often used for rates and ratios. |
| \(M\) | capital em | The length needed with waste. It is found with \(M = n \times \ell \times (1 + \rho)\). |
| \(K\) | kay | The length of one roll. A US double roll is 33 ft and a single roll 16.5 ft. |
| \(B\) | bee | The number of rolls needed. It is found with \(B = \lceil M \div K \rceil\), but if dividing the strips needed \(n\) by the strips per roll \(\lfloor K \div \ell \rfloor\) and rounding up gives more rolls, that number is used. |
| \(u\) | you | The unit price of the wallpaper (per foot, per roll or per square foot), from "unit price". |
| \(Q\) | cue | The quantity that matches the unit of the price (length, number of rolls or area), from "quantity". |
| \(T\) | tee | The estimated cost (paper only; paste and surface preparation are not included), from "total". |
| \(\lceil x \rceil\) | ceiling of x | The symbol for rounding up to a whole number (the ceiling function). (Example - \(\lceil 23.34 \rceil = 24\), \(\lceil 5 \rceil = 5\)) |
| \(\lfloor x \rfloor\) | floor of x | The symbol for rounding down to a whole number (the floor function). It is used when a leftover that is too short does not count, as in the strips per roll \(\lfloor K \div \ell \rfloor\). (Example - \(\lfloor 3.77 \rfloor = 3\)) |
Terms
| wallpaper | A sheet material of a set width used to finish walls and ceilings. In the US it is usually sold in double rolls 20.5 in wide and 33 ft long (about 56 ft²), often priced per single roll (16.5 ft). Some papers are 27 in wide or other widths. |
| perimeter | The total length of the walls around the room. For a rectangular room, (length + width) × 2. Wallpaper is hung vertically, so the perimeter divided by the paper width tells you how many strips fit side by side. |
| opening | A part of the wall that gets no wallpaper, such as a door, a window or a closet door. Find its area as width × height × count and subtract it from the wall area. Some people leave small windows in as extra margin. |
| net wall area | The total wall area (perimeter × ceiling height) minus the openings - the area you actually paper. The square footage in a contractor's quote for wallpaper usually means this area. |
| pattern repeat | The vertical length after which the pattern repeats, shown on the label as, for example, "pattern repeat 21 in". To line up the pattern with the next strip, each strip is cut to a multiple of this length, and what is left over is the pattern matching waste. |
| pattern matching | Hanging strips so that the pattern flows from one strip to the next. Paper that needs matching is rounded up by the repeat on every strip, so it needs more length than plain paper. |
| trim allowance | The extra length beyond the ceiling height that you leave to trim at the ceiling and the floor. About 2 in at each end, 4 in in total, is typical. |
| waste percentage | The percentage added to the calculated amount for cut-outs, mistakes and spares. About 10% for plain paper and 15-20% for patterned paper or first-timers are common; there is no single right value. |
| rounding up | Raising a number with a decimal part to the next whole number. Wallpaper comes only in whole strips and rolls, so counts are always rounded up. |
| double roll | The usual way wallpaper is packaged in the US - one continuous roll that is twice as long as a single roll (about 33 ft instead of 16.5 ft for 20.5 in wide paper). A longer roll gives more full-length strips per roll and less waste. |
| accent wall | Papering or painting just one wall of a room in a different color or pattern. On this page, choose "Perimeter" and enter only that wall's width to get the amount for one wall. |
Good to know before you start
Here is what helps you use the calculation on this page with real understanding, not just by pressing the button.
| Area and perimeter of a rectangle (Grade 3) |
|
| Converting units of length (Grades 4–5) |
|
| Multiplying and dividing decimals (Grades 5–6) |
|
| Percents (Grade 6) |
|
| Rounding (Grades 3–4) |
|
| Multiples (Grade 4) |
|
How to calculate it in Excel
| Room length (ft) | 12 |
| Room width (ft) | 10 |
| Ceiling height (ft) | 8 |
| Total area of openings (ft²) | 33 |
| Room perimeter (ft) | =2*(B1+B2) |
| Net wall area (ft²) | =B5*B3-B4 |
| Ceiling height (in) | 96 |
| Trim allowance (in) | 4 |
| Pattern repeat (in, 0 if plain) | 21 |
| Length per strip (in) | =IF(B3>0,B3*ROUNDUP((B1+B2)/B3,0),B1+B2) |
| Net wall area (ft²) | 319 |
| Wallpaper width (in) | 20.5 |
| Ceiling height (ft) | 8 |
| Strips needed | =ROUNDUP(B1/(B2/12*B3),0) |
| Strips needed | 24 |
| Length per strip (ft) | 8.75 |
| Waste (%) | 10 |
| Length with waste (ft) | =B1*B2*(1+B3/100) |
| Length with waste (ft) | 231 |
| Roll length (ft) | 33 |
| Strips needed | 24 |
| Length per strip (ft) | 8.75 |
| Strips per roll | =INT(B2/B4) |
| Rolls needed | =MAX(ROUNDUP(B1/B2,0),ROUNDUP(B3/B5,0)) |
| Unit price ($) | 45 |
| Quantity (ft, rolls or ft²) | 8 |
| Estimated cost ($) | =B1*B2 |
"ROUNDUP(value, 0)" rounds up to a whole number (the ⌈ ⌉ in the formulas), and "INT(value)" rounds down (the ⌊ ⌋ in the formulas).
The second table works in inches and uses the IF function so that it rounds up to a multiple of the repeat only when the repeat (B3) is greater than 0; for plain paper (0) it uses ceiling height + trim as is. The third table turns the paper width into feet with "/12".
The fifth table uses the MAX function to take the larger of the rolls by length (B1 ÷ B2 rounded up) and the rolls by strips per roll (B3 ÷ B5 rounded up).
B6 in the first table is 319, B4 in the second is 105 in (8.75 ft), B4 in the third is 24 strips, B4 in the fourth is 231, B5 and B6 in the fifth are 3 strips and 8 rolls, and B3 in the sixth is 360. Just replace the numbers in column B with your own.
How to calculate it in Google Sheets
| Room length (ft) | 12 |
| Room width (ft) | 10 |
| Ceiling height (ft) | 8 |
| Total area of openings (ft²) | 33 |
| Room perimeter (ft) | =2*(B1+B2) |
| Net wall area (ft²) | =B5*B3-B4 |
| Ceiling height (in) | 96 |
| Trim allowance (in) | 4 |
| Pattern repeat (in, 0 if plain) | 21 |
| Length per strip (in) | =IF(B3>0,B3*ROUNDUP((B1+B2)/B3,0),B1+B2) |
| Net wall area (ft²) | 319 |
| Wallpaper width (in) | 20.5 |
| Ceiling height (ft) | 8 |
| Strips needed | =ROUNDUP(B1/(B2/12*B3),0) |
| Strips needed | 24 |
| Length per strip (ft) | 8.75 |
| Waste (%) | 10 |
| Length with waste (ft) | =B1*B2*(1+B3/100) |
| Length with waste (ft) | 231 |
| Roll length (ft) | 33 |
| Strips needed | 24 |
| Length per strip (ft) | 8.75 |
| Strips per roll | =INT(B2/B4) |
| Rolls needed | =MAX(ROUNDUP(B1/B2,0),ROUNDUP(B3/B5,0)) |
| Unit price ($) | 45 |
| Quantity (ft, rolls or ft²) | 8 |
| Estimated cost ($) | =B1*B2 |
How to calculate it in Python
import math
room_length_ft = 12 # room length (ft)
room_width_ft = 10 # room width (ft)
ceiling_height_ft = 8 # ceiling height (ft)
openings = [ # openings (width ft, height ft, count). Use [] if none
(3, 7, 1), # door
(3, 4, 1), # window
]
paper_width_in = 20.5 # wallpaper width (in)
repeat_in = 21 # pattern repeat (in). 0 for plain paper
margin_in = 4 # trim allowance, top + bottom (in)
loss_rate = 0.10 # waste rate (0.10 for 10%)
roll_length_ft = 33 # roll length (ft). US double roll = 33 ft
price_per_roll = 45 # price per roll ($)
# net wall area A = perimeter x ceiling height - total area of openings
perimeter_ft = 2 * (room_length_ft + room_width_ft)
openings_area_ft2 = sum(w * h * count for w, h, count in openings)
net_area_ft2 = perimeter_ft * ceiling_height_ft - openings_area_ft2
# length per strip (rounded up to a multiple of the repeat; plain paper = ceiling height + trim)
need_len_in = ceiling_height_ft * 12 + margin_in
if repeat_in > 0:
strip_length_in = repeat_in * math.ceil(need_len_in / repeat_in)
else:
strip_length_in = need_len_in
strip_length_ft = strip_length_in / 12
strips = math.ceil(net_area_ft2 / (paper_width_in / 12 * ceiling_height_ft)) # strips needed (round up)
length_net_ft = strips * strip_length_ft # length before waste
length_total_ft = length_net_ft * (1 + loss_rate) # length with waste
rolls_by_length = math.ceil(round(length_total_ft, 2) / roll_length_ft) # rolls by length (round up)
strips_per_roll = math.floor(roll_length_ft / strip_length_ft) # strips per roll (round down)
rolls_by_strips = math.ceil(strips / strips_per_roll) # rolls by strips (round up)
rolls = max(rolls_by_length, rolls_by_strips) # rolls needed (the larger)
cost = rolls * price_per_roll # estimated cost ($)
print(f"Room perimeter: {perimeter_ft:.3f} ft")
print(f"Net wall area: {net_area_ft2:.2f} ft²")
print(f"Length per strip: {strip_length_ft:.3f} ft")
print(f"Strips needed: {strips}")
print(f"Length with waste: {length_total_ft:.2f} ft")
print(f"Strips per roll: {strips_per_roll}")
print(f"Rolls needed: {rolls}")
print(f"Estimated cost: ${cost:,.2f}")
How to write it in LaTeX and other math languages (copy and paste)
A = L × H − D
A = L H - D
<math xmlns="http://www.w3.org/1998/Math/MathML" display="block">
<mrow>
<mi>A</mi>
<mo>=</mo>
<mi>L</mi>
<mo>×</mo>
<mi>H</mi>
<mo>−</mo>
<mi>D</mi>
</mrow>
</math>
A = L * H - D
l*h - d
A := L*H - Dop;
A = L*H - D;
A = L × H − D
ℓ = R × ⌈(H + m) ÷ R⌉
\ell = R \left\lceil \frac{H + m}{R} \right\rceil
<math xmlns="http://www.w3.org/1998/Math/MathML" display="block">
<mrow>
<mi>ℓ</mi>
<mo>=</mo>
<mi>R</mi>
<mo>⌈</mo>
<mfrac><mrow><mi>H</mi><mo>+</mo><mi>m</mi></mrow><mi>R</mi></mfrac>
<mo>⌉</mo>
</mrow>
</math>
l = R |~ (H + m) / R ~|
r*Ceiling[(h + m)/r]
l := R*ceil((H + m)/R);
l = R*ceil((H + m)/R);
ℓ = R⌈(H + m)/R⌉
n = ⌈A ÷ (W × H)⌉
n = \left\lceil \frac{A}{W H} \right\rceil
<math xmlns="http://www.w3.org/1998/Math/MathML" display="block">
<mrow>
<mi>n</mi>
<mo>=</mo>
<mo>⌈</mo>
<mfrac><mi>A</mi><mrow><mi>W</mi><mi>H</mi></mrow></mfrac>
<mo>⌉</mo>
</mrow>
</math>
n = |~ A / (W * H) ~|
Ceiling[a/(w*h)]
n := ceil(A/(W*H));
n = ceil(A/(W*H));
n = ⌈A/(W H)⌉
M = n × ℓ × (1 + ρ)
M = n \ell (1 + \rho)
<math xmlns="http://www.w3.org/1998/Math/MathML" display="block">
<mrow>
<mi>M</mi>
<mo>=</mo>
<mi>n</mi>
<mo>⁢</mo>
<mi>ℓ</mi>
<mo>⁢</mo>
<mrow><mo>(</mo><mn>1</mn><mo>+</mo><mi>ρ</mi><mo>)</mo></mrow>
</mrow>
</math>
M = n * l * (1 + rho)
n*l*(1 + rho)
M := n*l*(1 + rho);
M = n*l*(1 + rho);
M = n ℓ (1 + ρ)
B = ⌈M ÷ K⌉
B = \left\lceil \frac{M}{K} \right\rceil
<math xmlns="http://www.w3.org/1998/Math/MathML" display="block">
<mrow>
<mi>B</mi>
<mo>=</mo>
<mo>⌈</mo>
<mfrac><mi>M</mi><mi>K</mi></mfrac>
<mo>⌉</mo>
</mrow>
</math>
B = |~ M / K ~|
Ceiling[m/k]
B := ceil(M/K);
B = ceil(M/K);
B = ⌈M/K⌉
T = u × Q
T = u \times Q
<math xmlns="http://www.w3.org/1998/Math/MathML" display="block">
<mrow>
<mi>T</mi>
<mo>=</mo>
<mi>u</mi>
<mo>×</mo>
<mi>Q</mi>
</mrow>
</math>
T = u * Q
u*q
T := u*Q;
T = u*Q;
T = u × Q
How to have ChatGPT do the calculation
You are a quantity calculation assistant for interior work. Do the following calculation by actually running Python code, and base your answer only on the numbers from the execution result (do not answer by mental math or guessing). I am wallpapering a room that is 12 ft long and 10 ft wide, with an 8 ft ceiling. There is one door (3 ft × 7 ft) and one window (3 ft × 4 ft). The wallpaper is 20.5 inches wide with a 21-inch pattern repeat. The trim allowance is 4 inches in total, and the waste rate is 10%. Find each of the following: 1. The room perimeter and the net wall area without the openings (ft²) 2. The length per strip (ceiling height + trim, rounded up to a multiple of the pattern repeat) 3. The number of strips (net area ÷ (paper width × ceiling height), rounded up) 4. The length needed with waste (strips × strip length × 1.1) 5. The number of 33-foot double rolls needed (the larger of: length ÷ 33 rounded up, and strips ÷ "strips per roll (33 ÷ strip length, rounded down)" rounded up) Show the formulas you used and the numbers from the execution result.
How to Use
-
1Enter your numbersType the numbers you want to calculate with into the input fields
-
2CalculatePress the "Calculate" button
-
3Check the resultThe result appears on the spot. The same page also explains the idea behind the calculation and the formula
DataChef Features
No technical knowledge required.
Intuitive and user-friendly operation.
Can be used without registering personal information.
Automatic file deletion by clicking "download".
and rapid file conversion.
No attribution required.
No need to contact us for commercial use permission.
