Stack Overflow
Stack Overflow

Questions tagged [approximate]

Finding or verifying that a value is 'close enough' to some target value.

The tag is used both for questions relating to determining an approximate value (i.e. calculating a value to withing a certain tolerance) and the act of verifying or determining the 'closeness' of a value to a another (e.g. approximate string matching).

See also: .

99 questions
0
votes
1 answer

xlookup with multiply separate match criteria

I've got 2 tables with same criteria "Num" I'm using this formula: =XLOOKUP(1,(NUM=RANGE_NUM)*(DATE=RANGE_DATE),GOAL_ARRAY,,,)** It's working only for exact match, but I want fill up all rows with goal column result Current result in table 1 TABLE…
arq7753
  • 21
  • 7
0
votes
1 answer

Formula in Excel to lookup for approximate match based on average, using Index/Match

How can I use excel formulae such as VLOOKUP or INDEX MATCH to lookup a value from a range, based on the mean of the upper and lower values when exact match is not available. e.g. Range: A. B. 100 123 125 234 175 345 276 547 C…
ThinkWiz
  • 1
0
votes
1 answer

What do you call it when kernel of a matrix is sought with a set (nonzero) tolerance?

This will be a strange question: I know what to do, and I am actually doing it, and it works, but I don't know how to write about it. Looking for solutions to a homogeneous matrix equation, say AX=0, I use the kernel of the parameter matrix A. But,…
Xirdal
  • 67
  • 1
  • 10
0
votes
3 answers

approximate Vlookup function in MS Access?

In Access I have a table, where I enter the times I began and finished work for each day. Logically, these two numbers allow you to calculate how long you worked. In another Table I have currently four records, defining how long the lunch break has…
Milan Pijanovic
  • 67
  • 6
0
votes
1 answer

Is there way to find a solution/Approximate the value of P in this equation in R-studio

ln(16.1)=ln(16.1+P)(0.81+p)+ln(15.1+P)(0.144)+ln(14.1+P)(0.0064)+ln(8.1+P)(0.0032)+ln(2.1+P)(0.0004+p) What I am trying to do is find P (capital) for a given value p (lower-case). Is there any way to find a solution or approximate value (if it's…
Melvin
  • 9
0
votes
0 answers

Java DatabaseMetaData getIndexInfo Parameter approximate

I want to check, if a column in a database has a unique-constraint. Therefor this code-snippet is used: try (ResultSet rs = pCon.getMetaData().getIndexInfo(null, pSchema, pTable, true, false)) { while (rs.next()) if…
ses
  • 168
  • 1
  • 11
0
votes
1 answer

Is there a way of showing an approximate value in Sage?

This is probably a silly question, but I used Sage to solve a system of linear equations, and I got exact solutions, which involve a lot of linear combinations of e^a (a is a constant). I know Sage is for symbolic expressions, but in this particular…
Santiago Bosch
  • 1
0
votes
2 answers

MySQL join 1-to-1 by closest datetime

I need to join two tables by approximate date in such a way that every row from table old gets matched to only the closest date in table new - one-to-one. No copies of new rows are allowed - only match once for the smallest difference. Here is some…
Michal J Figurski
  • 1,262
  • 1
  • 11
  • 18
0
votes
1 answer

How to merge two dataframes when column values are not exact?

I have: Linearly interpolated the dFe_env data every 1 m and create a data frame (This works) Extracted the 'Depth' (based on sinking rate) in 30 minute intervals (This works) Created a 'Time' column where it increases every 30 minutes (This…
L55
  • 117
  • 8
0
votes
0 answers

Is there an R package or function to subsample a dataset to approximate a certain distribution?

I have two sets of data (a, b) with distinct distributions. Set b has more data points and also has more variation. I need to subsample set b in a way that best approximates the distribution of set a. Although set b has a substantially larger mean,…
Jay
  • 442
  • 1
  • 5
  • 13
0
votes
1 answer

Complicated Approximate Match VLOOKUP Equivalent in Python

I have two csv files that look something like this: csv1: ID From_Depth To_Depth ABC 314 315 ABC 315 316 ABC 316 317 ABC 317 318 ABC 319 320 ABC 320 321 ABC 321 …
Luke
  • 11
0
votes
0 answers

How to increase Android Proximity Sensor sensitivity level on Android Studio, java?

I want to increase sensitivity level of Android Proximity Sensor so that it can trigger from long distance. current it work when object is is too close about 1.5 inch i want to increase 3 to 4 inches. it is possible? private SensorManager…
Aftab Falak
  • 1
  • 3
0
votes
0 answers

Excel Index and Match Multiple Criteria with Approximate Match

I have searched around for a while and could not come up with an answer to my problem. I am using a multi-criteria index and match function. With multi-criteria formulas (3 or more criteria) I have only seen help online for exact matches. In my…
drummingexcel
  • 1
  • 1
0
votes
2 answers

Fixing the approximations of a line rasterization algorithm

I'm currently making an header for making simple graphics in the c++ console. 2 days ago i added a function to draw lines using the rasterization algorithm used here. But i have a problem: since the console's cartesian plane works only with…
user9430539
0
votes
1 answer

How to specify approximate margins in Galen Framework?

I am using galen framework in a responsive designed website. And I need to check the elements by not giving fixed pixel amounts but percentages. For example I have to check one element to be on the left by approximately 10%. How can I say it in…
Helen Wt.
  • 81
  • 1
  • 4
1 2 3 4
5
6 7