look up values help needed

look up values help needed

Hi,

I have a table that returns rows with a total weight (say 212.5 for example). I have another look up table that has range of weights with a corresponding dollar value

The look up table looks like this: (example)

kg     value
0       2.00000000000000000000
160.5   2.35000000000000000000
195.5   2.55000000000000000000
220.5   2.75000000000000000000
245.5   2.83000000000000000000
270.5   2.89000000000000000000
295.5   2.92000000000000000000
320.5   2.95000000000000000000
345.5   3.00000000000000000000
445.5   2.35000000000000000000

so in my case, (212.5kgs) I need to return the value of 2.55 as 212.5kgs is between 195.5 and 220.5

can anyone help how I can do this please?

Kind regards Harry

View Answers









Related Tutorials/Questions & Answers:
look up values help needed
look up values help needed  Hi, I have a table that returns rows with a total weight (say 212.5 for example). I have another look up table that has range of weights with a corresponding dollar value The look up table looks like
look up tables in java
look up tables in java  cachetables , how to apply cache mecanisam in java , i have some tables which is frequently used so i want to fetch first time and want to keep in some scope untill the application end . with out hitting
Advertisements
ModuleNotFoundError: No module named 'look-up'
ModuleNotFoundError: No module named 'look-up'  Hi, My Python...-up' How to remove the ModuleNotFoundError: No module named 'look-up... to install padas library. You can install look-up python with following command
ModuleNotFoundError: No module named 'look-up'
ModuleNotFoundError: No module named 'look-up'  Hi, My Python...-up' How to remove the ModuleNotFoundError: No module named 'look-up... to install padas library. You can install look-up python with following command
Help needed in JSP
Help needed in JSP  Hi .. I want to Update the multiple values of database using checkboxes and want to set the session for selected checkboxes..? please answer if any one knows as soon as possible
help Needed with requirements
help Needed with requirements  Following are my requirements : * Maintain a student database *Based on a student's test results ,reports should be generated so as to project details such as a students weakness in a particular
Java help needed
Java help needed  Create a web application that will allow a user... as needed by the number of characters of the chosen word. 2. Add 4 buttons or menu options: One for accessing help using the program, one for adding new words, one
urgent help needed!!!!
how to access values selected from connected comboboxes  how to access values selected from connected comboboxes for storing in database...i'm... access country and state....please help me.... 1)state.jsp: <%@page import
urgent help needed!!!!
comboboxes for storing in database  how to access values selected from connected comboboxes for storing in database...i'm attatching a code i got.......please help me.... 1)state.jsp: <%@page import="java.sql.*"%>
Code Help Needed
Code Help Needed  I am trying to help a buddy of mine with this program and I can't seem to figure it out. I am still working on it but any help...[test]); line. Again thank you for any help. import java.util.*; import
EJB JNDI LOOK UP PROBLEM - EJB
EJB JNDI LOOK UP PROBLEM  Hi, I am using jboss4.2 and created a sessionbean using EJB3 but while running client code I am finding NoInitialContextException claname not set in enviornment properties
help needed for a program - Java Beginners
help needed for a program   i am having trouble understanding on what to code, so can some 1 help me out here. thanks in advance. Part I Write, compile and execute a Java program that displays the following prompts
Help needed for Form Validation please help!
Help needed for Form Validation please help!  I have created a page.../password combination . Problem arises while validating the Sign up part as after clicking the submit button for sign up it also goes through the jsp code and returns
help needed - Java Interview Questions
help needed  What are the new features added in jdk 1.5?  Hi friend, The following were the new features added in java 1.5.... * Autoboxing/unboxing ------------------------- This link will help you
servlet redirect problem help needed
servlet redirect problem help needed  package p; import java.io.IOException; import javax.servlet.RequestDispatcher; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import
PHP help needed - Development process
PHP help needed  This is my code that I am using for search engine, can any body answer how to cheange the code if I want limited and per page result display??? code Career Search result Yami says <?php
servlet redirect problem help needed
servlet redirect problem help needed  package p; import java.io.IOException; import javax.servlet.RequestDispatcher; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import
Help needed for J2me and PHP - Development process
Help needed for J2me and PHP  Hello Sir I am a degree student. I have a small CRM application using J2me and PHP. I want to do cryptography using... but could not get result. I will appreciate your help. Regards
urgent help needed in JDBC AND JAVA GUI - JDBC
urgent help needed in JDBC AND JAVA GUI  my application allows... want any one to help me convert from scanner to java GUI for this code...(); } } // thanks for any help rendered   Hi Friend, Try the following code
CAN ANYONE SOLVE THIS FOR ME. URGENT HELP NEEDED. PLEASE HELP
CAN ANYONE SOLVE THIS FOR ME. URGENT HELP NEEDED. PLEASE HELP   The Task Write a class whose objects will represent students... and exam marks (add them up and divide by two) are greater than
CAN ANYONE SOLVE THIS FOR ME. URGENT HELP NEEDED. PLEASE HELP
CAN ANYONE SOLVE THIS FOR ME. URGENT HELP NEEDED. PLEASE HELP   Write a class whose objects will represent students.The class should have three...? depending on whether or not the combined coursework and exam marks (add them up
Help needed on java standalone app and default browser interaction.
Help needed on java standalone app and default browser interaction.  Hi Developers and tutors, Is anyone able to guide on how am i able to extract...? Platform Windows Browser IE7 Any from of help would be deeply apperciated
Navigate database values using up and down key of keyboard
Navigate database values using up and down key of keyboard In this section, you will learn how to navigate database values using up and down keys... the database values. On pressing the up key, the following code will fetch one by one
please help me how to set up Netbeans for JSP
please help me how to set up Netbeans for JSP   Hi roseindian.net... help me.We are ready to do INDUSTRIAL PROJECT by JSP. Thank you. ERROR.../xhtml+xml,application/xml;q=0.9,*/*;q=0.8 Accept-Encoding: gzip,deflate,sdch
Setting up Database with the help of PHP Scripts.
PHP Database Set Up Script Part-5(c) : Setting up the database 2. Database Creation with the help of PHP Scripts.ADS_TO_REPLACE_1 With the help of PHP... discussed in the last tutorial that MySQL has its own standard set up to create
i want to create invoice report editable. values should be taken from dabase and editable .. help out asap
i want to create invoice report editable. values should be taken from dabase and editable .. help out asap   i want to create invoice report editable. values should be taken from dabase and editable .. help out asap
i want to create invoice report editable. values should be taken from dabase and editable .. help out asap
i want to create invoice report editable. values should be taken from dabase and editable .. help out asap   i want to create invoice report .. help out asap
I want to update the multiple values of database depending on checkbox..? Please help me out..
I want to update the multiple values of database depending on checkbox..? Please help me out..   Hi .. I want to Update the multiple values of database using checkboxes and want to set the session for selected checkboxes
Can anybody help how to store values to the following xml from .NET application
Can anybody help how to store values to the following xml from .NET application  Can anybody help how to store values to the following xml from .NET application <SQLSchema> <Databases>
Help...
Help...  Write a class that displays your first name vertically down the screen â?? where each letter uses up to 5 rows by 5 columns of a character input by you with a blank line between each letter
ModuleNotFoundError: No module named 'look'
ModuleNotFoundError: No module named 'look'  Hi, My Python program is throwing following error: ModuleNotFoundError: No module named 'look' How to remove the ModuleNotFoundError: No module named 'look' error
ModuleNotFoundError: No module named 'look-at'
ModuleNotFoundError: No module named 'look-at'  Hi, My Python program is throwing following error: ModuleNotFoundError: No module named 'look-at' How to remove the ModuleNotFoundError: No module named 'look
A program solution needed
A program solution needed   I need a solve for this problem please ! a program that displays grade statistics. The program should read any number of grades (up to 100) and ends when the user enters -1, the program should reject
Packages needed for JDBC in Linux
Packages needed for JDBC in Linux  Can anyone tell me the packages needed to run a program with JDBC in Red Hat 5
help
display all the computed values in the previous assignments in a text area. â... proper screen layout models. Your frames should look clear and display all... based on the percentage of cheating. please help me
Look and Feel - Swing AWT
Look and Feel  i m using netbeans for creating a swing GUI...... and i want to know how to give my gui the "Windows look" as by default it is set to "metal Look".  Hi Friend, Please visit the following links
JavaScript Pop Up Boxes
JavaScript Pop Up Boxes JavaScript has three kind of pop-up boxes,  i)    Alert-Box: If some surety is required from the user or an alert message is to generate then we can use alert box, user has to click ok
look and feel - Framework
look and feel  Hi, i created one jsf page with images and commandlinks ,i adjusted all the spaces in my system here it is looking good but in other sysem it is not looking good.I need solution for the page looking good in any
Needed jsp codes
Needed jsp codes   jsp code for employee payroll.producing a payslip of every employees monthly calculating the gross pay of a particular employee considering the income tax and producing a report which can be printed out
pop up
pop up  how to create pop up in html
help
help   how i can send a pitcture on url in java
Limiting the Values in a Number JSpinner Component
will learn how to create a Number JSpinner that can take values up to certain maximum... Limiting the Values in a Number JSpinner Component... up to certain maximum limit. Following program has used some methods and APIs
help
help  pls help me to get the code of a java program a program to perform different shapes in a menu using javaapplet
Needed java code
Needed java code  1.Java code for the time used to display your name, one character at a time, for 200,000 times . 2.Java code for the time used to display your name, one character at a time in reverse order, for 200,000 times
help
help  i need help with this code. write a java code for a method named addSevenToKthElement that takes an integer array, and an integer k as its arguments and returns the kth element plus 7. any help would be greatly
degree needed for data scientist
degree needed for data scientist  Hi, I am beginner in Data Science... needed for data scientist Try to provide me good examples or tutorials links so that I can learn the topic "degree needed for data scientist"
degree needed to be a data scientist
degree needed to be a data scientist  Hi, I am beginner in Data...: degree needed to be a data scientist Try to provide me good examples or tutorials links so that I can learn the topic "degree needed to be a data
What degree is needed for AI?
What degree is needed for AI?  Hi, I am beginner in Data Science... degree is needed for AI? Try to provide me good examples or tutorials links so that I can learn the topic "What degree is needed for AI?". Also tell me
HELP
HELP  I need this code to open in a new web browser. but no matter what i do it wont please help?? Directive 055 Storage Requirements for the Upstream Petroleum Industry
help!!!!!!!!!!!!!!!!!!
help!!!!!!!!!!!!!!!!!!  import java.awt.; import java.sql.*; import...,phoneNo,email,address) values('"+t1+"','"+t+"',"+t2+",'"+t3+"','"+t4+"','"+t5...,course,university,phoneNo,email,address) values('"+t1+"','"+t+"',"+t2+",'"+t3

Ads