Excel list of generic annotations by view

Hi All,

I’m new to Dynamo and was wondering if someone could help me with the following graph.

As a contractor our company is trying to make a schedule of the quantity and different types of wall openings/voids in our projects. In order to do this we placed generic annotations in our sections and we would like to make a list of the views where these generic annotation where placed. We first tried to make a schedule by using the ‘Note Block schedule’ function within Revit, but couldn’t add the right parameter to the schedule.

In the following graph I imported all the desired views and generic annotations in Dynamo and try to converted them into an excel list. I’m missing a few command which connects the view name/ sheet number to the generic annotation. I also included a few screenshots of the section view in Revit and the output to Excel. Any help would be appreciated!

Excel%20list