Estimates the storage unit size a customer needs in square feet and what it costs per month.
Which cell does what, and which worksheets the model reads. These are the assignments you recreate when you import the file.
| Cell | Role | Note |
|---|---|---|
| B1 | Input | Household size, entered as its estimated contents volume in cubic feet. |
| B2 | Input | Count of bulky items that do not stack; each adds 35 cu ft. |
| B3 | Input | Length of the rental in months; drives the term total only. |
| B4 | Input | Climate control toggle. 1 = yes, 0 = no. |
| B6 | Result | Total volume: household volume plus 35 cu ft per extra large item. |
| B7 | Result | Volume divided by a 7 ft usable stacking height to get floor area. |
| B8 | Result | Floor area increased by 15% for an access aisle. |
| B9 | Lookup | UnitSizes band lookup: rounds the required area up to the next standard unit size. Shown as a result. |
| B10 | Lookup | Rates lookup: base monthly rate for that unit size. |
| B11 | Result | 22% of the base rate when climate control is on, zero when off. |
| B12 | Result | Primary result. Base rate plus climate control surcharge. |
| B13 | Result | Fixed one-time admin fee of $29. |
| B14 | Result | Monthly cost times months, plus the admin fee. |
Change the numbers to yours, then paste it into your own page. It runs in the visitor’s browser and the answers are theirs, not a screenshot of yours.
Start from this model rather than a blank sheet. The inputs, the results and any lookup worksheets come with it.
The prices here are examples. Change them in the Formula view and the calculator follows — no rewiring.
Publishing gives you an iframe snippet. Drop it into your own page and enquiries land in your workspace.
The contents are converted to cubic feet, divided by a 7 ft stacking height to get floor area, and increased by 15% so there is room to walk in and reach the back. That number is rounded up to the next standard unit size the facility rents.
Anything that does not stack: a fridge, washer, dryer, sofa, mattress set, motorcycle, bike or garden equipment. Each is counted at 35 cubic feet on top of the household volume.
It is usually recommended for wood furniture, electronics, instruments, artwork, leather, photographs and documents, or for any storage lasting more than a few months in a humid or freezing climate. The estimate adds 22% to the monthly rate when it is selected.
That is above the largest single unit most facilities offer, the 10x30 at 300 sq ft. In practice it is rented as two units, commonly two 10x20s, and the quote should be confirmed with the facility.
The term total is the monthly rate multiplied by the number of months, plus a one-time $29 admin fee. It does not include insurance, a lock, or any promotional first-month discount.
It is an estimate based on national average rates. Local rates vary by roughly plus or minus 40% depending on the area and current occupancy, so a facility using this calculator should load its own price list into the rate table.