Math Algorithm To Solve Puzzles
May 30, 2006
Given a list of numbers and a list of 'allowable' operators, come up with a specific total. ("The numbers game" on countdown on BBC2.... ooooh Carol Voderman)
For example, given the numbers 1, 3, 4 and 5 with valid operators +, -, /, * come up with a solution equal to 15. All numbers must be used once only. Use operators as often as required. The specific example above was given to me and I personally think its not solvable (might be a practical joke). But I am wondering is it possible to prove this through assertions or develop an algorithm to solve such puzzles. I can get 14 and 16, but not 15....
View 8 Replies
ADVERTISEMENT
Jan 28, 2009
This just a shot in the dark, but does anyone have a custom function that calculates the check digit for a cusip? http://en.wikipedia.org/wiki/CUSIP
The algorithm is listed above.
View 3 Replies
View Related
Sep 25, 2009
Have an excel table with following data:
- ID
- number of bottles
- number of bottle crates (there are 20 bottles in one one bottle crate)
201688194000bottles
20168819200crates
2016883812000bottles
20168838600crates
201688396400bottles
20168839320crates
201688809000bottles
20168880600bottles
20168880480crates...................
I need to write a macro which will do this operation for each ID:
(bottles/20)-crates = x
and if "x" is not 0 then write down the value of "x".
There are two points I would like to point out:
- One ID may contain 3 or more rows (see 20168880)
- The macro will work with hundreds IDs so the algorithm should be fast (but it is not necessary)
View 3 Replies
View Related
Dec 4, 2007
Anyone have an excel sheet that automatically generates secret santa selections?
Or explain an algorithm so I can implement it on excel?
View 9 Replies
View Related
Feb 5, 2008
I am trying to solve the nearest neighbour algorithm with vba
For example, I have a table as the following
0 1 2 3 4 5 1
10
5
15
20
2 10
8
9
7
3 5...........
View 9 Replies
View Related
Apr 8, 2008
I wonder could anyone help me with a problem i'm having, I have a table showing a basic RSA algorithm in excel, for example,
M 13 2197 19 8893887173 13 M
N 14 2744 5 788125 14 N
etc etc,
How the numbers are derived isn't important, what i want to do is create a visual basic form, to allow a user to input a letter, for example M in a text box, click a button, and then the 5 related digits are shown.
So the user inputs M into a text box clicks a button, then 13, 2197, 19, 8893887173 and 13 is output to 5 other text boxes.
View 9 Replies
View Related
Jun 4, 2007
Im looking for an algorithm to sort an array of data, deleting multiple values whithin the array and shifting the values down the array to leave no gaps. the crude set of loops i am currently using is:
For f = 0 To 100
For g = f + 1 To 100
If LineArray(g) = LineArray(f) Then LineArray(g) = ""
Next g
Next f
which does work and serves my purpose but is messy as it leaves blank gaps in the array.
View 2 Replies
View Related
Dec 2, 2009
I have this module that is supposed to look in column A and if it sees duplicates it looks in column B (with the date) and erases the entire row where the date is older in column B. I am attaching a sample to better illustrate it.
The highlighted in yellow rows are were I have duplicates and I want the row where the date is in red border to remain.
The module I have so far erases the newer records instead of the older.
This is the file:
Sample sorting.xls
Here is the
View 3 Replies
View Related
Oct 26, 2009
I have spreadsheet that tracks the the rain total for several days. I would like to be able to break it down to the days of weeks that has rain and how much without manually imputing the data.
Days | #of times | total amount
Mon
Tue
Wed
Thu
Fri
Sat
Sun
View 5 Replies
View Related
Jul 7, 2009
i'm working on floyd algorithm macro for a project,
problem is, the spreadsheet matrix is huge, it's a 1043 x 1043 spreadsheet
And this is taking wayyy too long, i've been waiting for almost 2 days already..
here's the file :
http://ifile.it/6v2j39f
(You start the macro using "run" command in "input" sheet)
So is there any way to speed it up?
Or if anyone got a supercomputer, could you help me process this? :p
I'm thinking about changing the 10^5 value into infinite value, but i can't find a way to display infinite value..
And here's some reference for Floyd's algorithm,
http://ifile.it/12p5zle
I have tried to split the algorithm to make it process one iteration at a time, but i've been waiting like 2 hours with no result,
and that's for 1 iteration, can't imagine how long it takes for 1043 iterations
You can do this by deleting the.
View 14 Replies
View Related
Feb 17, 2012
I have a database of approximately 250000 email addresses and I would like to see if there is some way to use Excel to analyse the strings in order to identify potential 'non-unique' individuals.
For example, if I have the following email addresses:
12345@example.com
12346@example.com
12347@example.com
or
example1@example.com
example2@example.com
etc
Is there some way of extracting common text strings, lets say where there is a difference of 1 character / digit between strings (rather than alphabetising and searching manually)?
View 2 Replies
View Related
Apr 20, 2009
to allocate funds to various organisations with a number of constraints (see spreadsheet attached I work in Excel 2007 but saved the file in 2003):
1. No negative growth can be allowed (Column M which is difference between columns Q and B) and I therefore added Column N to bring the growth in Column R to 0% for those which had a growth of less than 6%.
2. Minimum growth however allowed should be 6%
3. Maximum growth allowed should be 50% (not all need to have 50% growth)
4. The balance of the allocations to organisations with growth more than 50% should be used to "equalize" allocations proportionately between the other organisations with growth lower than 50%
View 9 Replies
View Related
Feb 27, 2010
I am solving a mass balance for my wastewater class and need help using excel for find my unknowns. I have solved down to this EQN; 35,000=2367(SRT)/(1+.088*SRT) + 31.2(SRT)^2/(1+.088*SRT) + 88.8(SRT)/(1+.06*SRT) + 449*SRT + 224.6*SRT
SRT is my unknown.
View 9 Replies
View Related
Oct 9, 2007
I am trying to solve a set of simultaneous equations by using SolverOk function in VBA.
I dont want to use the 'SetCell' option so, I wrote the following
SolverOk MaxMinVal:=1, ByChange:= Range("V34:V36")
SolverAdd CellRef:=Range("AK4:AK6"), Relation:=2, FormulaText:="0"
SolverSolve
but I get an internal memory error. However, if I use the solver dialog box directly from excel and not through a macro and keep the 'Set Target Cell' as empty, I get the right solution.
View 8 Replies
View Related
Aug 8, 2009
I want to display the path result from a Floyd Algorithm matrix output..
You can download the excel file here : http://ifile.it/lw4tgic
It consists of 1044 nodes, and we need to find the path between 2 nodes for ALL pairs..
Now, to find the path between 2 nodes, we need to :
1. Find the resulting cell of corresponding 2 nodes (y to x = z)
2. Update the path with that value (y z x)
3. For all the direct pairs in the current path (yz, zx), find the resulting cell
4. If destination (x) not the same with result (z) then repeat step 1 for that pairs.
5. repeat until x = z for all pairs.
Maybe it's better if i use an example....
we'll use T01 to E78 as an example
T01-E78 = if you look in the table,
y (vertical) = T01,
x (horizontal) = E78
z (result) = E77, so
T01-E78 = E77, so path = T01-E77-E78
check if result of T01-E77 = E77 (x = z?)...........................
View 10 Replies
View Related
Jan 15, 2013
How to solve table with filter which needs to be copy to other tab.
Example: One tab has table with filter. Issue is with another tab which needs to be copy but issue is that another tab will further investigate with additional columns. Can be solved this issue as first tab will filter and change all rows order and another tab should read content with added columns.
View 4 Replies
View Related
Feb 25, 2009
Is it possible in excel to find the equation for a curve?
I have 6 known x,y data points on a curve. I need to find the equation for the curve.
View 4 Replies
View Related
Jan 11, 2008
Can excel solve an equation for x with two variables.
Example: 102=125000(X-910)/50000.
I need excel to solve for X
The variables are 102 and 125000
View 9 Replies
View Related
Nov 18, 2009
I need the formulas to solve for the ARC length AB.
(How) can Excel solve this?
I will have to solve many variations of the 1 inch length and/or vary other measures.
Known's
Arc radius 1.5
Slope angle 31 degrees
Slope intercept to center of Arc Diameter 1
Circle B radius .75
Circle B is tangent to Slope
Solving the Segment length AB would be a bonus.
View 9 Replies
View Related
Dec 6, 2013
I am attempting to create a formula that is including numeric values in multiple cells but I want to exclude cells that have an "N/A" value. I am calculating the blended average price using the volume and price from multiple cells but some cells don't have volume or price but an "N/A" instead. The blended average price should be $68 but how do I calculate that including all the cells...even the cells including the "N/A"
Attachment example included.
View 4 Replies
View Related
Mar 3, 2009
Need to solve the formula in the file. Is it possible to solve this in just one move? in that case.
View 2 Replies
View Related
Feb 25, 2009
Does anyone have a macro they have created or know of that can solve the X and Y coordinates on an ellipse? Would you be willing to share here or send it to me in a personal email?
View 9 Replies
View Related
Mar 7, 2009
I am trying to create a formula to count the number of time the word "NEW" appears in one column, provided the result of another column gives a certain answer. Sample of my problem and question in detail on attached.
View 2 Replies
View Related
Jun 3, 2009
i am trying to make an excel sheet that does calculations to help drydock a submarine....
docking math is used and it works as follows:
6-11-7
6-11-7+
6-11-7++
6 is feet
11 is inches
7 is 1/8ths
+'s are 1/16ths
so i want to be able to have a list of set measurements like above and then have one set measurement be subtracted from the list. like
12-4-6+
13-5-4
14-2-4
and have 6-2-5+ be subtracted from all of the above and be displayed on a second page. I have slammed my head against the wall for about 3 days now and i am a excel newbie. so if i messed up somewhere or anyone could help i would greatly be appreciate it.
View 14 Replies
View Related
Mar 12, 2009
Using vba textboxes too do math .I have attached a sheet too explain, not sure if its possible. If it is I know this is the place too find out.
View 4 Replies
View Related
Mar 13, 2009
Having a real hard time with this,able to do it in normal excel, this project I'm using vba. Here is a example of what I can not do, if you can give a a formula for this I will be real Happy.
View 5 Replies
View Related
Aug 20, 2007
I am trying to create a macro that will do some basic math using J, I as referencing.
Sub Table()
Dim Temp
J = 2
I = 1
For Temp = 1 To Question
Cells(J + 35, I).Formula = (Cells(J, I + 2) + Cells(J, I + 2) * Cells(J, I + 3) - Cells(J, I + 4))
J = J + 1
Next
End Sub
how do I get the math to work without the R1C1 referencing?
View 9 Replies
View Related
Jul 7, 2006
Trying to compute annual change I've always used the formula "(b1-a1)/a1" - where b1 is the current year, a1 is the prior year. I've been asked to compute average annual change over a number of years and thought simply by using the above for each year and then taking the average of all these, I'd be ok. I recently found a formula as follows: "(y2/y1)^(1/n)-1", where y2 is current year, y1 is 1st year I have data, n = the number of changes.
View 7 Replies
View Related
Nov 11, 2009
i have a formula that i am trying to place in excel, however i am not sure what the function is I need to call or if there is one. the formula is G(sec Z)
View 2 Replies
View Related
Jan 15, 2006
How do I correct to make conditonal formula with number values ?
My main worksheet has at leat 24 columns and as many as 30 rows, all have
numbered values. Rows are defined names.
I want to get average values when at least 2 conditions have certain values.
I tried =SUM(IF(AND(MapKpa:MapKpa=40),(RPM:RPM=1000),grmcyc:grmcyc))
and answer given is really total of all 30,000 row values for grmcyc and not
when mapkpa values = 40 and RPM = 1000.
Also best would be if the conditions allow lets say when Mapkpa is between
40 and 45 and RPMs between 1000 and 1500 to have a window of grmcyc average
I used Sum but really want an average of grmcyc when Mapkpa and RPM meet the
conditions so I can build a results table of what the grmcyc average value
was from 20 to 105 KPA in 5 KPA windows along with smaller RPM ranges.
View 12 Replies
View Related
