TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
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
Reply
Answers (
3
)
How to dynamically map the stored proc return columns,values
Search Between Two List (Normalized Both List)