Solve Set Of Simultaneous Equations
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
ADVERTISEMENT
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
Dec 18, 2009
I have set up a workbook containing 15 sheets. 12 of them are named Jan to Dec. I KNOW how to protect each one, but is it possible to protect all twelve in one go?
View 9 Replies
View Related
Jan 18, 2007
It is my understanding that two or more people can simultaneously work in and save data in a given workbook.
Is this true?
If so, how does one set up the collaborative mode? Currently we are getting "the first person in has control of the file, all others are 'read only' until the file is released".
View 3 Replies
View Related
Jan 16, 2013
I'm putting together a workbook which tracks operating hours for 17 pieces of equipment (units) at 7 job sites.
I need to track and record the number of hours where at least two of units 1-6 operate simultaneously each month.
So far I have only succeeded in creating another table which pulls all records for units 1-6 from the Log. The table can then be sorted by date (for some reason, this sorting only kind of works) so simultaneous operating hours can more easily identified and summed manually.
I'll attach a workbook with mock data which shows what I have so far. The complete workbook also does some other calculations which I have removed for clarity. That is why there is some "extra" info in the workbook.
The workbook is set-up where:
LOG: This is where the user records when each unit was operated.
LOG2: This is where I've attempted to isolate records for units 1-6 and sum simultaneous operating hours.
Factors+Limits: This is where the fields for the lists are stored as well as other factors used throughout the workbook.
Monthly: I'd like to be able to records simultaneous operating hours here.
View 4 Replies
View Related
Jul 12, 2006
I have a standard module in which I gather information from a workbook, create an XML document, Post it, and collect the value I need from the response XML. Thing is I have to run through it maybe hundreds or thousands of times depending on the number of records I have. It takes ten years to finish the loop. I have read that it might be possible to post them concurrently using a class module and an event handler, but I have not worked with Class modules before. Compiling all the XML documents into memory is easy, posting them and getting my return values in a timely manner is the problem at hand.
View 2 Replies
View Related
May 9, 2014
I have rows of data in excel that update automatically and i want to check in column B how many times there are simultaneous occurrences of a cell value and then if those occurences have been there for a time specified time duration using column C which has a time and date stamp. The time and date stamp is when the price is saved down.
A Simplified Example:
Item
Action
Date & Time
Red
Buy
09/05/2014 09:00
[Code] .....
What I would like the formula to is to count the occurrences of cell B that have been avilable for longer than say 30 minutes.
Formula that worked out the occurrences of cell B with this formula
=SUM(IF(FREQUENCY(IF($B$2:$B$7="Buy",ROW(B2:B7)-ROW(B2)+1),IF($B$2:$B$7<>"Buy",ROW(B2:B7)-ROW(B2)+1)),1))
So if i wanted to count the simultaneous occurrences of "Buy" then the formula would result 1 and the same for sell if i changed the formula would be 2.
Now i want to try and get a way of using the time those occurrences were available for by using Column C
The simultaneous "Buy" was available from 09/05/2014 09:00 to 09/05/2014 11:01 which is longer than 30 minutes so i want to count that as a occurrence.
Then both the "Sell" were only available for 14 minutes the first time and then only for 20 minutes the second time so none of those would count.
View 1 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
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
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
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
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
View Related
May 14, 2006
y = 1.083333333x4 - 7.3333333x3 + 16.416667x2 - 6.16667x + 4
Above is the polynomial equation of a trend line as shown on my chart, I have extracted the numbers into separate cells using LINEST, so now I have in cells A20 to E20 the numbers 1.083333333, -7.333333, 16.416667, -6.16667 and 4 respectively.With a "y" value of 25 how do I go about solving for a value of "x".
I've been stubbornly struggling with this on and off for a couple of weeks now and I'm not getting any closer to working it out and the websites I've found explaining the procedure all seem to go over my head by the time I get into the fourth or fifth paragraph.
View 11 Replies
View Related
Oct 24, 2013
I am given the function
y = a x + b
And I am supposed to ask the user to enter a value for a and b twice
So I could have 2 equations and solve them
The problem is I am not sure how to solve the 2 equations using VBA?
View 3 Replies
View Related
Apr 19, 2007
how the Process to solve the following problem:
1A = 15x + 32y + 5z
1B = 6x + 2y + 8z
1C = 3x + 11y + 19z ...
View 9 Replies
View Related
Feb 17, 2003
I was wondering if the solver was the only way to solve implicit equations. I am looking for something that will automatically solve an implicit equation after the appropriate information is entered into the referenced cells.....
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
Dec 12, 2013
I have three different equations i am trying to combine to one line so I do not have to use three columns.
Equation 1.
If recommend quantity is < 100, and the Number of times part number used is one, then Recomnend quantity was used
Ex =IF(F277 100 and the Number of times part number used is greater then one and less then 10, then Recommend quantity was used
Ex =IF(G277100,*and(E277>1),F277*2.0)
View 1 Replies
View Related
Feb 16, 2007
I don't actually own Excel as yet - but I'm wondering if someone could tell me whether Excel is capable of solving what I'm told are 'polynomial equations'. An example of the sort of equation I hope to solve is: d/(1.18 + d) + d/(1.86 + d) + d/(9 + d) + d/(8.8 + d) = 2
d=? {I happen to know d = 3.65(approx) in this example btw}
Often there will be many more than four terms...
View 6 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
Mar 30, 2014
I'm trying to find definitions/commands to make excel find the best combinations of several defined scopes and restrictions to make an output number as high as possible.
This is by using a combination of several different equations, maybe excel has a magic trick for all the variables and formulas.
Attached File: forum_heatexchanger.xlsx
View 2 Replies
View Related
Feb 12, 2013
I have a system of 3 equations with 3 unknowns that I would like to solve in Excel.
The equations are
24.792 = A*e^(B/(100-C))
9.857 = A*e^(B/(70-C))
4.590 = A*e^(B/(40-C))
Where e is the exponential function.
View 7 Replies
View Related
Mar 17, 2014
I have two cells with the following equations:
H3=IFERROR(VLOOKUP(A3&TEXT($A$1,"m/d/yyyy"),'CLABSI_Raw'!$A$1:$M$300,13,FALSE)," ")
I3=IFERROR(VLOOKUP(A3&TEXT($A$1,"m/d/yyyy"),'CLABSI_Raw'!$A$1:$M$300,10,FALSE)," ")
In an adjacent cell, I am trying to use an if statement
J3=if(and(H3<1,I3<1),"yes","no")
I am not getting a return in cell J3.
View 3 Replies
View Related
Nov 6, 2006
is it possible to export a trendline equation from a graph to a cell, or at least to export the coefficients? If yes, how?
View 4 Replies
View Related
Apr 4, 2014
I am trying to analytically solve an equation to establish a physical value. Unfortunately, it's difficult to do the algebra, so it needs to be done this way.
I have an experimental value for this in "J2", so what I want to do is change F2 to that "I2" is equal to "J2"
Is it possible to get excel to match these values - I have about 200 different cells of this?
The formula is in cell "I2"
=B2*((1-(C2/D2)*((F2/G2)^1.2))^-1.5125)
View 11 Replies
View Related
Dec 26, 2013
I am about to take a corporate finance course. The textbook uses a ton of basic (complex to me) equations to calculate interest rates, bond premiums, dividend reinvestment scenarios, etc.
I know that Excel has a bunch of specific functions to calculate interest, NPV, etc. but I am NOT interested in using those because I would like to have Excel "do the math" once I enter the formulas (or parts of formulas) correctly.
how to enter the equations below into Excel without using built-in formulas (I'm also not looking to use the Equation editor because I actually to calculate the answers, not just have the visual look/feel of the equation).
1R2 = [(1 + .0194)(1 + .03)]1/2 - 1
If done correctly, 1R2 in the above should equal 2.47%. I am totally fine doing parts of this in separate cells if necessary.
And something more complicated like the below. I wrote out the word "delta" because I don't know how to create the "triangle" symbol for delta on this forum post. According to the text, for securities with semiannual receipt (compounding) of interest, it is represented as:
-D = (delta P / P) / ((delta r sub b) / (1 + (r sub b)/2)))
Or in English, I believe that can be expressed as "negative D equals the quotient of delta P divided by P (in the numerator) divided by the following: delta r sub b divided by the quantity 1 plus r sub b divided by 2"
And finally
V sub b = 1000 / [1 + (.10/2)]2(4) + 50 times the following compound bracketed expression [1 - (1 / [1 + (.10/2)]2(4)] divided by (.10/2)]
View 3 Replies
View Related
