I will just be focusing on the input parameter of this document and how i found the information needed to complete the excel spreadsheet. Hope this helps but if you have a better solution please let me know since this is just from my own experience.
1. Getting information for vCenter Objects:
Open the custom UI webpage for vCOPS.
Select Admin tab -> Audit report
Select your preferred report type and submit.
At the bottom of the output page you have the section called "Virtual Environment (existing resources)" . All the details required are available in this section.
2. Custom Adapters resource and metric counts
Open Custom UI website for vCOPS 5.8
Environment tab -> Environment overview
Expand Adapter instances
On right hand side highlight the adapter and select the "Detail view" button.
There might multiple instance so go through each and add up for the total count of the adapter.
On the metric selector expand the instance generated
The graphs display the numbers necessary for document.