Conditional Weighted Average Calculation Tutorial

A simple tutorial to demonstrate how to calculate the weighted average of various metrics for certain tenants. Using the conditional weighted average concept, you can to do this quickly without having to organize/sort/manipulate the rent roll at all. (View description of model)

Note: Compatible with Microsoft Excel 2013 and newer. This model is in beta and likely contains errors.

To make this model accessible to everyone, it is offered on a “Pay What You’re Able” basis with no minimum (choose ‘Free’ if you need) or maximum (your paid support helps keep the content coming – typical real estate models sell for $200 – $500+ per license).

Instructions: 1) set a price, 2) tell us where (email address) to send the model, 3) enter payment details (if applicable), and then 4) click ‘Proceed with Download’. The system will send you a download link, as well as add the file to your ‘My Downloads’ page.