RAFM New Search Facility?

The link below used a search facility that I haven't seen before but doesn't seem to accept quotes to signify a complete phrase, or if is does it goes beserk! Maybe it was just me?
After a while I figured out I could home in on the negative cards, not by typing "negative card" but MFC78 which produced over 2,000 results with the majority being site plans.

Given that the search is a bit clunky I thought I would download all 255 pages of data but the methods I used in the early 2000s are no longer available and in Excel it seems to have been replaced with something called Power Query, which is probably powerful, or ironically not, but more to the point is unfathomable to me, having not really used Excel for 15 years. 

Is anyone able to produce a simple list using the new "user friendly" software?

collections.rafmuseum.org.uk/collection/...ory/?q2=MFC78&q3=165

P.S. A lot of websites offered an export facility for results but I notice that once "improved" this facility is removed. That would have been a 5 minute job if the RAFM website offered it.

It seems very common for website searches to not accept inverted commas and if there are three words it does a WORD1 OR WORD2 OR WORD3 search which just too spurious result.

Searches seem to getting worse.


 

mbriscoe wrote:

Searches seem to getting worse.

 

I agree. Even when you specify a single word some return results that look similar. 'Range' (in quotes) is a good example in that it includes 'arrangement' or 'arrange' whereas it shouldn't. I sometimes include a space fore and aft of the word in quotes but often get mixed results. Sadly the incorrect results outnumber the required ones by a huge amount. I haven't used SQL for nearly 20 years but when I did I never had a problem. 
I suspect they have dumbed things down a tad or perhaps a lot as my wife is complaining daily about searches on her genealogy websites.
I can seem a problem looming with AI trying to help, we will lose the ability to think for ourselves.
 

I have placed an order as a result of that search. There seems to be another source of plans under 'MPC77' but I assume these must be the originals rather than the aperture cards. I did find it odd that within the search area there is no reference to the 'askcollections' email address. All very confusing. 

One thing I did notice was that plans for Donna Nook bombing range are shown as 1963 but are in fact pre-war as I have a printed copy from about 15 years ago. The drawing number was 63B and not the standard AM numbering so may just be a works drawing? Again confusing.

The search is still going beserk if you enter two words in quotes to search for a phrase.