Hi ALL!
I’m Mark. I’m new on this forum. Thank you very much to possibility of registration. This is my first post over here. I am student and I am writing my final work. I have a big and serious technical problem. Maybe some of you will be able to help me.
I show results of my measurements in tables. Measurement series: S1-S12. Measurement locations: M1-M11.
TABLE LEGEND:
X - The X marks are measured values. The results of my measurements (KNOWN VALUES)
GREEN (KNOWN VALUES) - In green cells with numbers from 1 to 6 there are results of analytical calculations from previous series of measurements.
RED (VALUES TO PREDICT) - In red cells with letters from A to F are results of current calculations.
I noticed that results of analytical calculations agreed with measured values. High correlation of the results of analytical calculations and measurements
Below I am sending files with tables of results of my measurements. For illustrative purposes, the tables contain the numbers that I would like to find, i.e. numbers marked in red (red cells). I am also sending pictures with marked my problem.
SHORT DESCRIPTION:
In each measurement table, I know only values and position of the numbers marked in green (green cells), i.e.: the results marked in green (green cells) e.g. from November 17, 2022, are: 4,2; 6,0; 10,0; 22,2; 24,2; 38,1.
I would like to find the numbers in the cells marked in red (unknown numbers) i.e.: measurement table marked in red (red cells), e.g. from November 17, 2022, are 10,0; 17,2; 19,5; 34,7; 41,3; 46,2. Determining the values marked in red (unknown numbers) requires a lot of analytical calculations. I noticed after performing analytical calculations that each time the analytically calculated values (red cells) are consistent with the measured values (red cells in the measurement table). I would like to find all the numbers (red cells measurement table) in without doing analytical calculations.
MY PROBLEM:
I need a smart formula/function that would compare the values of numbers in the vicinity of numbers in green cells. The numbers I am looking for in the measurement table (numbers in red cells) are always in the immediate vicinity of known numbers (numbers in green cells). Searched numbers always occur several times in the vicinity of known numbers (numbers in green cells).
Example1:
know green 38,1 ( - unknown red 19,5
know green 6,0 - unknown red 19,5 etc.
Example2:
know green 38,1 - unknown red 46,2
know green 24,2 - unknown red 46,2 etc.
Example: see the example for the known number 38.1 - picture EX_1_17_11_2022.jpg and EX_1_17_11_2022_CONNECTION.jpg.
I meant neighboring cells, which means that the known numbers (marked in green cells in the measurement table) are always next to the searched numbers (marked in red cells in the measurement table). I marked this fact in the screenshot - blue circles.
How to find all variants of numbers in red cells when I know position numbers in green cells in table ??. And then extract only those numbers that are repeated with known numbers (e.g. the searched number 19.5 is in the vicinity of know green 38.1 and know green 6.0 ect.)
What's the easiest way to do it?
Regards
Mark
I’m Mark. I’m new on this forum. Thank you very much to possibility of registration. This is my first post over here. I am student and I am writing my final work. I have a big and serious technical problem. Maybe some of you will be able to help me.
I show results of my measurements in tables. Measurement series: S1-S12. Measurement locations: M1-M11.
TABLE LEGEND:
X - The X marks are measured values. The results of my measurements (KNOWN VALUES)
GREEN (KNOWN VALUES) - In green cells with numbers from 1 to 6 there are results of analytical calculations from previous series of measurements.
RED (VALUES TO PREDICT) - In red cells with letters from A to F are results of current calculations.
I noticed that results of analytical calculations agreed with measured values. High correlation of the results of analytical calculations and measurements
Below I am sending files with tables of results of my measurements. For illustrative purposes, the tables contain the numbers that I would like to find, i.e. numbers marked in red (red cells). I am also sending pictures with marked my problem.
SHORT DESCRIPTION:
In each measurement table, I know only values and position of the numbers marked in green (green cells), i.e.: the results marked in green (green cells) e.g. from November 17, 2022, are: 4,2; 6,0; 10,0; 22,2; 24,2; 38,1.
I would like to find the numbers in the cells marked in red (unknown numbers) i.e.: measurement table marked in red (red cells), e.g. from November 17, 2022, are 10,0; 17,2; 19,5; 34,7; 41,3; 46,2. Determining the values marked in red (unknown numbers) requires a lot of analytical calculations. I noticed after performing analytical calculations that each time the analytically calculated values (red cells) are consistent with the measured values (red cells in the measurement table). I would like to find all the numbers (red cells measurement table) in without doing analytical calculations.
MY PROBLEM:
I need a smart formula/function that would compare the values of numbers in the vicinity of numbers in green cells. The numbers I am looking for in the measurement table (numbers in red cells) are always in the immediate vicinity of known numbers (numbers in green cells). Searched numbers always occur several times in the vicinity of known numbers (numbers in green cells).
Example1:
know green 38,1 ( - unknown red 19,5
know green 6,0 - unknown red 19,5 etc.
Example2:
know green 38,1 - unknown red 46,2
know green 24,2 - unknown red 46,2 etc.
Example: see the example for the known number 38.1 - picture EX_1_17_11_2022.jpg and EX_1_17_11_2022_CONNECTION.jpg.
I meant neighboring cells, which means that the known numbers (marked in green cells in the measurement table) are always next to the searched numbers (marked in red cells in the measurement table). I marked this fact in the screenshot - blue circles.
How to find all variants of numbers in red cells when I know position numbers in green cells in table ??. And then extract only those numbers that are repeated with known numbers (e.g. the searched number 19.5 is in the vicinity of know green 38.1 and know green 6.0 ect.)
What's the easiest way to do it?
Regards
Mark