video1.0<iframe src="https://www.loom.com/embed/fb626c43662f4bb3822464ad68c85f10" frameborder="0" width="1080" height="810" webkitallowfullscreen mozallowfullscreen allowfullscreen></iframe>8101080Loomhttps://www.loom.com8101080https://cdn.loom.com/sessions/thumbnails/fb626c43662f4bb3822464ad68c85f10-00001.gif222.57In this video, I will guide you through the process of exporting the asset list from Sonar and applying a formula to identify assets with multiple beacons attached. I will demonstrate using a small subset of data, making it easier to understand. We will export the list to Excel and locate the beacons column. I will show you how to insert a new column and apply a formula to calculate the beacon count. Additionally, I will explain how to adjust the formula if the column position changes in future Sonar updates. Finally, we will analyze the data and verify the accuracy of the results.