You're projecting.You're making this all about REW vs Excel. This is about the mics.
Excel is the standard for data analysis and is completely transparent to the user. REW is a packaged app and I'm not satisfied it's transparent.
If this is not about REW vs. Excel then please won't
you insist on Excel being
better?
I never said that Excel was wrong. I said that the person using Excel
can do something wrong when visualising data. If someone posts some picture (!) of an Excel sheet I know just as much about if the data has been processed correctly compare as with an REW screenshot. You might feel more comfortable using your tool than seeing me use mine, but that not the point. Excel is a generic spreadsheet editor, the poor man's analysis tool, not "the standard". In this case it certainly can be used but it's simply
not the best tool for the job.
What
is the job, anyway?
If it's just about evaluating microphones then we don't even need any visualisation. Just look at the data in the calibration file. If the typical frequency range for EQ needs less then +/- 0.5 dB correction then this is perfect. This is the case with my UMIK-1. If it's within +/- 1 dB it's still good enough. More than that? Not so good, the calibration file should certainly be applied. This is the case with your UMIK-1.
But is this really the job?
Not really, it's not about mics, it's about room correction and how it can be performed in a cost efficient way. This requires us to make measurements. Not trusting REW's representation of the calibration file is
totally pointless if you are going to use it for your measurements, anyway. And that takes a bit more than visually displaying a calibration file. Note: Excel won't help here.
You're not going to use REW anyway for WiiM RC? Using the WiiM Home App instead? Well ... even if you could import the cal file already, it is "packaged software", you have no clue what's going on. And in contrast to REW it is not the commonly accepted gold standard, which has developed and matured over countless years.
Your bad mic vs. my good mic
Same, but zoomed in, illustrating the lack of any smoothing (which can be added if you wish to)
Load my calibration file and see if you come to better conclusions than I did.