Implement algorithm for conversion of mobile data

[jendakol]

We're provided raw mobile data and we need to convert them to a usable format. The algorithm is a function f(x, y) = z where x is a strength of the signal from the device, y time period they spent together and z boolean response (infected or not). The algorithm is described in the attachment.
test.xlsx

[Foxlik]

Is boolean output a good idea? It makes sense to me to split this to
f(x, y) = z and g(z) = w where z is some dimension-less number and g(z) can be easily scaled ...

[JanPetr]

In the end it'll look something like that, @Foxlik. One function will calculate a number based on the XSL file and the other will check the number and say whether infected or not.

[jendakol]

No problem with that @Foxlik