This article will provide the steps necessary to find the average Meld rating per vendor using the reports available in Property Meld.
Step 1:
Click on the melds tab in the top navigational bar and click the drop-down arrow next to the word FILTER.
After you select the criteria for your filter, click APPLY FILTERS. For this example, I selected completed melds that were created in the month of October of 2021 to include all resident ratings.
We recommend saving this filter so you can easily pull the report any time you need updated data. You can save the filter by, scrolling down to the bottom of the filtering options pop-up box and clicking APPLY FILTERS. Then, click Save at the top of the page, enter the filter's new name and click Save Filter.
Calculating the Average Rating
Now that we have made the filter we can export the report and calculate the rating.
Step 1:
Click Export CSV. This will automatically email a report of all Melds in your filter to the email you are signed in with.
Step 2:
Locate the email and click Download File, then open the file.
Once opened delete all columns except for V and Z or copy columns V and Z onto a new sheet. Then, use the custom sort option to sort the Assignee column in ascending order.
Insert a row between each separate vendor. Then, highlight the Meld ratings for one vendor and click the dropdown arrow next to the AutoSum option on the Home tab and select Average. This will auto-fill the empty cell with the average rating.
*Repeat for each vendor*