Good progress! You should mention if measured units are volts or ohms for units. I hope you don't have a problem with the TPS sensor, the shop manual setup refers to using the VCK code reader for setting up. Maybe it's best not to adjust TPS unless you're sure there is some clear problem that you see. Make sure to read the shop manual on this procedure.
You should also check MATS, ETS, EGT and MAPS sensors, I think MAPS must be voltage check with key on, not resistance check, but follow manual procedure. In the case of RAVE solenoid, 22.7 Ohms is very close to 24 Ohms, so no problem!
I hope there isn't a problem with TPS, maybe disconnect the suspicious one and see if fault clears or changes?