\Global Provider Host-Cluster_address_spac Under No 172.30.0.0/16 172.30.0.4 172.30.255.254 \Global Provider Provider Address_address_space Under No 192.168.200.0/24 192.168.200.10 192.168.200.99 \Global Provider External (NAT)_address_space IP Address Management Integration with VMM for Hyper-V Network Virtualization 8. Select the location to save the CSV and enter a file name. Click on Save. 9. Copy the CSV file to the PC where you have Microsoft Excel 2013 installed. 10. Open the CSV file in Excel. 11. You will see that all of the data shown in the details view is on the same line as the subnet. 12. Select the following columns: C: Network K: Provider IP Address Space O: Percentage Utilized P: Assigned Addresses Q: Utilized Addresses 13. Copy these columns to a new worksheet in Excel. 14. Clean up the Provider IP Address Space columns. In this example, each value had the_address_space information removed from the end and the two Tenant networks were named correctly, as shown in the following screenshot: Provider IP Address Space Network Percentage Utilized Assigned Addresses Utilized Addresses Tenant A 10.0.0.0/24 25.29644269 Tenant B 10.0.0.0/24 17.78656126 Host-Management 172.28.0.0/16 0.666666667 Host-LiveMigration 172.29.1.0/24 0.796812749 Host-Cluster 172.29.2.0/24 0.796812749 Provider Address 172.30.0.0/16 0.007629977 65531 External (NAT) 192.168.200.0/24 3.333333333 15. Click on the Insert tab on the ribbon bar. 16. Click on Recommended Charts. 17. Excel will show you a variety of charts it can create based on the data presented on the worksheet. Chapter 4 18. For this example, select 100% Stacked Bar. Click on OK. Insert Chart Recommended Charts All Charts 100% Stacked Bar Chart Title Chart Title External (NAT) Provider Address Host-Cluster Host-LiveMigration Host-Management Tenant B Chart Title Tenant A Percentage Utilized Assigned Utilized Addresses A 100% stacked bar chart is used to compare the percentage that each value Assigned contributes to a total. Use it to show how the percentage each value 