Media Wall Estimator for Google Sheets™
A free add-on for people who quote or plan TV mounting jobs in a spreadsheet. It adds sheet functions for screen size, seating distance, mount height and slat panels, and a sidebar that estimates a whole TV wall and inserts the materials checklist into your sheet.
Sheet functions
| Function | Returns |
|---|---|
=TVSIZE(65) | 65" TV: 56.7" x 31.9" screen |
=TV_SEAT_DISTANCE(65) | 65" TV: sit 6.5-8.8 ft from the screen (40-30 degree field of view), i.e. the THX to SMPTE range |
=TV_MOUNT_BOTTOM(75, 44) | the bottom edge height in inches for a TV centred at 44" (a number, about 25.6) |
=TV_MOUNT_TEXT(75, 44) | 75" TV centred at 44": bottom edge 26" from the floor |
=SLAT_PANELS(144, 96) | 24" × 96" slat panels to order for a 144" × 96" wall, including one spare: 7 |
=MEDIAWALL_CHECKLIST(…) | the materials checklist as rows (item, quantity, note): mount, anchors for wood stud, metal stud, brick or concrete, power relocation kit, in-wall HDMI, recess framing and more |
All lengths are in inches. A row per room, with these functions filled down, turns a list of rooms into a quote sheet.
Sidebar
Extensions › Media Wall Estimator › Estimate a TV wall job opens a form (TV size, centre height, seat distance, wall, mount, recess, soundbar). It shows the numbers and inserts the checklist at the selected cell. Insert example job sheet adds a worked example.
Privacy
The add-on asks for two permissions only: this spreadsheet (spreadsheets.currentonly), to read and write the cells you ask it to, and display the sidebar (script.container.ui). The calculations run inside Google Sheets™. Nothing is sent to GetMediaWall or anyone else, and the add-on stores no data. See our privacy policy and terms.
Support
Questions or a wrong number? Email team@getmediawall.com. To plan the whole wall with panel counts and prices, try the free media wall planner.
Results are planning estimates: follow the mount and anchor maker's instructions and your local building and electrical codes.
Google Sheets™ and Google Workspace™ are trademarks of Google LLC. This add-on is not made or endorsed by Google.