David Smith

David Smith

  • NA
  • 2k
  • 0

Linq Search Between Two List (Normalized Both List)

Dec 19 2019 3:34 PM
1. I have two list below Power Factor LIST and Power LIST. The two list are 1 to 1 correlation
2. I am tying to use linq or robust logic to give me an output from LIST A or a Virtual output from List A. 
 
3. If a user wants to use or set power to 300, The value 300 is between 268 and 366 in the power list below, which correlated to array element 5 and 6 in the Power factor list.
 
4.Once you get the associated array elements associated with the power factor list below which are 5 and 6.
You take value from element 5 and 6 and find the 1/3 of the way between the two chosen elements and return that number output.
 
Step 1. 51.8181 - 43.1818 = 8.6363 
Step 2. 8.6363 * 0.33 = 2.849979 
Step 3.  43.1818 + 2.849979 = 46.031779
 
Power Factor to Return is 46.031779 
 
Note: If a user specify a match from the list like 25, just return the associated power factor value which will be 8.6363 
 
Element Power Factor Power
0 0 0
1 8.6363 25
2 17.2727 60
3 25.909 117
4 34.5454 186
5 43.1818 268
6 51.8181 366
7 60.4545 467
8 69.0909 553
9 77.7272 590
10 86.3636 590
11 95 590

Answers (3)