I've been working on this for 12 hours and have gotten just about nowhere. Could somebody provide me some guidance? Anything to get me going in the right direction? I'm completely swimming. Thanks!

Show us what you have and explain what problems you have

Are you having trouble parsing the xml?

I guess you might, but then your "wanted output" doesn't match anything obvious in the xml -- step 1 might be identify output 1 not merely output final :)

use XML::Twig :) it comes with many examples/tutorials, XML::Twig, XML::LibXML, Mojo::DOM ... see Re: The best module for handling xml for examples, walkthroughs, follow my links and the links they link, like these Re: How to grab a portion of file with regex (don't)(parsing html/xml with xpath/twig/dom, because html::parser is low level), Re: How to grab a portion of file with regex (parsing html/xml with xpath/twig/dom, because xml::parser is low level), Re^4: How to grab a portion of file with regex (parsing html/xml with xpath/twig/dom, because ::parser is low level)

Are you having trouble de-ranging the network ranges (or whatever the networking cidr term is) or whatever is you're calculating from the XML ? (the strings don't relate in an obvious way -- maybe obvious to you but most folks don't networks all day)

See converting complex netrange to cidr notation, Net::IP::RangeCompare, regex for classless IP subnets, Managing your IP space with Perl