Program = Residential
Measure = M&V and any of these:
M&V_allclean = No
TO_CalculatedCFMPerTon < 340
TO_CalculatedCFMPerTon > 460
If Equipment – MeteringDevice = TXV and TO_Subcooling > TO_SubcoolingTarget plus 5
If Equipment – MeteringDevice = TXV and TO_Subcooling < TO_SubcoolingTarget minus 5
If Equipment – MeteringDevice does not equal TXV and TO_Superheat > TO_TargetSuperHeat plus 5If Equipment – MeteringDevice does not equal TXV and TO_Superheat < TO_TargetSuperHeat minus 5
Below is what I came up with and it's not working.
If([Customer - Program]="Residential" and
[Equipment - MeteringDevice]="TXV" and ([TO_Subcooling]>[TO_SubcoolingTarget] + 5 or [TO_Subcooling]<[TO_SubcoolingTarget] - 5) and
[Equipment - MeteringDevice]<>"TXV" and ([TO_Superheat]>[TO_TargetSuperHeat] + 5 or [TO_Superheat]<[TO_TargetSuperHeat] - 5), "140")
Thanks for any assistance.