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....
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)
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.
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.
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.
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
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.
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)?
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%
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.
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.
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?)...........................
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.
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.
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"
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?
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.
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.
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.
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.
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)
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.
