Help with Filters and FILTERXML(WEBSERVICE

I thought I had everything entered correctly to pull my data. However,some cells are getting a #VALUE! error and the filters seem to be partially out of order when I try to filter largest to smallest. I am not sure if the error is in my formulas, spreadsheet design or on the server I am pulling the data from. I had to remove some data to make the file small enough to attach. This was a 2+ meg file. Hopefully you can still see where the errors are. Any help would be appreciated.

AttachmentSize
Help Partial Data.xlsx830.12 KB