Evaluate and return value per given criteria

Problem Statement:

Using given criteria return;
1) first value (absolute), moving left to right, that falls within the specified criteria for that item or if none found then return first value found in the row, or
2) the number one, if it exists, if not, then return zero,
for each row of the raw data set.

Example files attached.

I'm not sure what to do with this. I'm looking for some ideas or something.

Thanks!