Recalibrating AFMs- Excel guru needed

[blitzracing]

Anyone out there a dab hand with Excel? I have raw data for both the Lucas 20 AM and Bosch AFM against the 5AM for voltage outputs versus airflow, but due to turbulence causing small spikes in the reading it needs to be averaged with a graph. I need the voltage for the 5AM (0 to 5 volts) on the X axis, and the percentage difference for the Bosch and 20 AM on the y axis (two graphs)- this will be both positive and negative readings. I cant quite reach 5 volts on the test bench- so the graph needs to be extended manually once the response curve is apparent. The UAFC recalibration unit I have is preset voltages so I simply need to know the average percentage differences for the two units at these voltage boundaries below.



Help anyone?

[chris1972]

blitzracing said:

Anyone out there a dab hand with Excel? I have raw data for both the Lucas 20 AM and Bosch AFM against the 5AM for voltage outputs versus airflow, but due to turbulence causing small spikes in the reading it needs to be averaged with a graph. I need the voltage for the 5AM (0 to 5 volts) on the X axis, and the percentage difference for the Bosch and 20 AM on the y axis (two graphs)- this will be both positive and negative readings. I cant quite reach 5 volts on the test bench- so the graph needs to be extended manually once the response curve is apparent. The UAFC recalibration unit I have is preset voltages so I simply need to know the average percentage differences for the two units at these voltage boundaries below.

Help anyone?

I'm not an expert, but can have a go for you. Wing the data over to info(at)christianhough.com

[blitzracing]

Thanks- on its way

[blueg33]

Hi mark

If you dont have any joy with others, I could look at it too. I use excel daily, but to be fair rarely use graphs (charts in excel speak)

Cheers

Nick