Transform Constraint
That sounds like a job for a driver. Remove the constraint on Cube.002, right click on it's Y location value and select Add Single Driver. The Y value will then be filled with purple.

You edit the driver value in the graph editor with it's mode set to Drivers. More info on editing drivers is available in the blender wiki.

You want to use the Z rotation of Cube.001, displaying the debug value shows that it varies from -180 to 180. You want to ignore the negative part of the value so abs(var) will remove that, then divide that by 180 and multiply it to get a larger range of movement. That leaves you with a calculation of (abs(var)/180)*100. Changing the 100 used will change the distance Cube.002 moves. You can add a value at the end to move the range of movement away from 0.0.