A
Alex Delamain
I have a sheet full of data for many products in chronological order.
Column A is Date of manufacture
Column B is time of manufacture
Column C is the product
Column D is a measurement from the automatic control system
Column E contains occasional manual measurements for calibratio
checks
Up till now I have split the data out by grade and checked calibratio
using pivot tables and also checked slope and offsets. After gainin
exposure to all kinds of clever functions via this board I now wonde
whether it would not be possible to automate these checks in some way
ie on a separate sheet I list the product names
then using arrays or Sumproduct or similar can I calculate the averag
deviation between auto measurement and lab and also slope and offsets
The formula would need to look through the data table, find records fo
the required product and then do the calculations - I'm sure it i
possible but it has exceeded my capabilities
Column A is Date of manufacture
Column B is time of manufacture
Column C is the product
Column D is a measurement from the automatic control system
Column E contains occasional manual measurements for calibratio
checks
Up till now I have split the data out by grade and checked calibratio
using pivot tables and also checked slope and offsets. After gainin
exposure to all kinds of clever functions via this board I now wonde
whether it would not be possible to automate these checks in some way
ie on a separate sheet I list the product names
then using arrays or Sumproduct or similar can I calculate the averag
deviation between auto measurement and lab and also slope and offsets
The formula would need to look through the data table, find records fo
the required product and then do the calculations - I'm sure it i
possible but it has exceeded my capabilities