JimMueller
Board Regular
- Joined
- Nov 24, 2004
- Messages
- 83
Can this be done in Excel 2003? The enduser may not necessarily be using the same version, however.
I've got a 2D table of data which I can view as a 3D surface map. When viewed in this map, some cell values don't transition very well between adjoining cells.
The way it works right now:
1) The user defines which range of values are acceptable. Defaults are 13 +/- 0.2, and also allows scaling in smaller steps to prevent overshooting the target range.
2) External sensor values are pasted into an AFR sheet containing one table. These values are a percentage between 10 and 20.
3) The user copies in a predefined table on the VE sheet. These values are displayed as a percentage for ease of use, but really represent raw air mass.
4) The Delta table calculates what is needed to adjust the VE values to the desired value (13 in this case) and uses this value as a multiplier against the VE table which in turns populates a third table (NewVE) with suggested changes. The Delta table has 3-tier color coding based upon the ranges specificed on sheet1 to show whether it's too low, too high, or 'close enough'. These values are a percentage typically betwen 0.80 and 1.2.
Now, it's the NewVE table which I want to smooth adjoining cells. My thought process was, allow each 'smoothed' cell to be scaled up or down only the small percentage which would still keep it in the range specified on sheet1, but it needs to be smoothed on both axis.
For instance, if the 3.2x55 NewVE cell equals 67, and the corresponding Delta cell is colored green (indicating it's within range on the other scale), then take the formula result in that green cell (let's say it's 12.9). The smoothed cell result could be as low as ((12.8/12.9)*67)=66.480, or as high as ((13.2/12.9)*67)=68.558.
I'd want it to go through the entire NewVE table and build a SmoothVE table so that each smoothed cell would be in it's appropriate range(i.e., 66.48 <-> 68.558), but as smooth as possible on the surface map.
Am I making any sense? Suggestions?
I've got a 2D table of data which I can view as a 3D surface map. When viewed in this map, some cell values don't transition very well between adjoining cells.
The way it works right now:
1) The user defines which range of values are acceptable. Defaults are 13 +/- 0.2, and also allows scaling in smaller steps to prevent overshooting the target range.
2) External sensor values are pasted into an AFR sheet containing one table. These values are a percentage between 10 and 20.
3) The user copies in a predefined table on the VE sheet. These values are displayed as a percentage for ease of use, but really represent raw air mass.
4) The Delta table calculates what is needed to adjust the VE values to the desired value (13 in this case) and uses this value as a multiplier against the VE table which in turns populates a third table (NewVE) with suggested changes. The Delta table has 3-tier color coding based upon the ranges specificed on sheet1 to show whether it's too low, too high, or 'close enough'. These values are a percentage typically betwen 0.80 and 1.2.
Now, it's the NewVE table which I want to smooth adjoining cells. My thought process was, allow each 'smoothed' cell to be scaled up or down only the small percentage which would still keep it in the range specified on sheet1, but it needs to be smoothed on both axis.
For instance, if the 3.2x55 NewVE cell equals 67, and the corresponding Delta cell is colored green (indicating it's within range on the other scale), then take the formula result in that green cell (let's say it's 12.9). The smoothed cell result could be as low as ((12.8/12.9)*67)=66.480, or as high as ((13.2/12.9)*67)=68.558.
I'd want it to go through the entire NewVE table and build a SmoothVE table so that each smoothed cell would be in it's appropriate range(i.e., 66.48 <-> 68.558), but as smooth as possible on the surface map.
Am I making any sense? Suggestions?