Excel Definition and 347 Threads

Hello Does anyone know if it's possible to run an excel file in Simulink? I have a column with a variable in excel, and don´t know if there is a block that I can get in simulink to run this variable. Regards

I have some data and i want to plot them on excel. I am trying to plot them but i am drilling a hole in the water. I will appreciate if anyone can help me with this. I want 3y axes and 1x.Thank you.

Using Excel 2003, I'd like to display text data in the Data Items area of a pivot table. Currently, I see the number 1 in the field. I've changed the format to "Text", which has no effect on the data that's displayed. Is it possible to display text data in the Data Item area of a pivot table...

Hey all, I'm looking for a version of steam/water thermodynamic properties for excel. I need it to be able to compute properties based on pressure and entropy. Something similar to the X Steam Tables (http://www.x-eng.com/XSteam_Excel.htm) would be awesome, but again, I need the ability to...

I can't get this formula to come out. I have done it on excel step by step over and over and it gets close, but always a little under. As in if the chord angle is 45 and I do all the calculations on the other side, it calculates to 43.85. They should both be 45 so I don't know what is going...

Homework Statement I have to calculate g or find the acceleration of g using the slope of the trend line from the y vs. t^2 graph. I had to use excel and did this for lab with data and use the equation excel came up with after i finished the graph, and I have no idea how to find the...

I forgot long time ago the little I knew of VB applied to Excel. Can anyone give a snippet of VB code to get the value in cell C8 to increasing by n every time I click the mouse on cell C9? I recall that being possible but I am clueless now. Gracias for any help.

I have problem don't use tab to separate cell for writing file to excel. this algorithm write file to excel one cell only.i want write file separate cell on excel file. please suggest me about algorithm write file in excel file.

Here's my dillemma: I'm writing up a spreadsheet where we have 100 passengers on a plane. Excel randomly generates their assigned seat, and the seat they end up taking. But the problem is, I need to make it so that Excel does not generate the same number twice.

Well am not looking for someone to solve the problems ,,, am looking for somone telling me how to use excel to solve some problems. with excel functions. the problems " 1.From this population of 500 households, select a simple random sample of 50 households (Use the program...

how can i use excel to solve some Statistics problems ,,, hi all ,,, am looking here for help. to know how to solve some stat problem with excel could someone help me please ,,,, :rolleyes: well the things I want to know are. " A data set was gathered from 500 households (you...

I want to have an analysis of my lab report grading for my students and I figured I could make a histogram. I had been manually doing =COUNTIF()'s before but I learned you could install a histogram package just now! However, it seems to be giving me conflicting results that have to do with how...

Hi. I know about the general formula for an ellipse: x^2/a^2 + y^2/b^2 = 1, that can be used to isolate y and calculate x,y points in excel. That's great, so far so good. That will create a ellipse, with horizontal A (x) axis and vertical B (y) axis. But what if one wants to rotate the...

Does anyone know of any good guides on getting the most out of the programs that typically come with Microsoft Office? And not things like "How do I make a chart?", but something a little more advanced like a sort of "mail merge" between data on a spreadsheet and a word document "template". For...

Hello guys Does anyone use Maxwell Ansoft? If so, have you tried to export it to Excell? if so do u use any MATLAB code to convert it? or use macros in excell? Thanks

Homework Statement Trying to create an excel spreadsheet that outputs the angles of a simple pendulum as it slowly comes to a stop. Homework Equations so I've used the formula: θ(t) = θ0cos(squareroot(g/R*t) where: θ0= inital angle g=gravity constant R= length of string t=time...

I have a graph in excel and i need to estimate an x value with a known y value. Pretty much i need to draw a horizontal line at y= given value over to my data line. Then a verticle line down to find the x value. How can i do this?

Hi, Looking for a bit of cheeky help with matlab, I am stumped! 1) I have written a program that i want to cycle through different sets of data, ideally this is what i would like: These are all xls files with columns of data ydata = ... xdata = ... zdata = ... for variable =...

I am attempting to work out the changing velocity of a rocket on Excel. However, I cannot use the simple: \int{a} dt = v. at + C = v. If thrust is constant at 20 000 and the rocket is 2000kg with 600kg not made of fuel and 20kg lost every second, then would the equation be...

Hi all, I have used MATLAB curve fit tool to curve-fit a set of x-y points. Now I want to export the curve-fitted y point to excel. Any idea how to do this? Thank you very much.

I have various EKG graphs. I need all of the maximum and minimum voltages for each period. The periods are not all the same length. The maximums and minimums all vary. Is there any way I can do this? Note: it'll be hard selecting chunks of data and then finding it from that because...

Homework Statement Homework Equations I would like to know if my work is correct. I thought that the graph would be a sinusoidal, but there is a small irregularity in the middle. Am I correct in using θAC = 90 deg and θAB = 36.8699 deg in solving for the constant angular velocity...

I want to code a macro that will take in an integer as a row number and insert two rows above that row. This will repeat in a for loop. The problem is that I'm not familiar with VB syntax. Here's what I have so far: Sub Insert_Rows_Loop() Dim CurrentSheet As Object Dim x As Integer '...

Hello, Does anyone have an idea about how to use fit data with a line while fixing the slope in MS. Excel? Does linest by anyway capable of doing that? Thank you Lorna

Hello, I ran a program in MATLAB and my output is coming in the command window. I want to export these output in excel. My output are in matrix form and I want to send it as a column data in excel. Please help me to do it. Thanks in advance.

Hello, I am working on making an Excel work book to aid in figuring out pressure drops in a system. I am trying to use the Darcy Weisbach equation for pressure loss. http://www.engineeringtoolbox.com/darcy-weisbach-equation-d_646.html" In Excel I have =(C4*(C5/C6))*((C7+(SQRT(C8)))/2)...

Homework Statement For my homework i have to compute a correlation function in excel from available data. Data goes somewhat like this: 1 xxx yyy 2 xxx yyy 3 xxx yyy I now I have to calculate...

I don't need any help for the engineering maths I'll be doing after but if I anyone could advise me on how to write a program that would take a set of x and y values and then give me back the y values at certain intervals on the x-axis I would be very grateful. I've got colossal amounts of data...

------Question------ a) Research the three finite difference approximations mentioned above (forward, backward and central). Use a spreadsheet to demonstrate each of these numerical methods for the function below. y=x3 −x2 +0.5x Investigate the derivative over the range x = [0,1], using...

I have been looking around for some information about placing a microsoft excel file onto my TI-89 (The non titanium model). Has any done this before? Thanks

Hi, Wondering if anyone can help me with figuring out of if it's possible to make a function on excel with V lookup and IF, if you can pls post an example. Or give an example of using both of these functions in a algorithm to reference to cells on another page in excel within the function...

Homework Statement Homework Statement Hello everyone! I have been having trouble with cumulative frequency graphs in excel for some time now. I wonder how you make the "bell graph" or cumulative frequency graphs or standard deviation graphs in microsoft excel. I have excel for mac. I...

Hey people, I am trying to write my own histogram making code since the Excel one sucks IMO. I am having some trouble thinking the whole bin 'width' thing through though. I plan on using the formula number of bins = k = 1.87(N - 1)0.40 + 1 Then I was going to figure out the bin...

Homework Statement I have a simple truss to analyze using excel. I have done this and know how to do it on pen and paper using one equation to eliminate variables in another until down the line an answer pops out and I go back in and solve for all the other variables. However, this...

Introduction to Operations Research, Hiller, 3.4-12 I believe 1 2 3 4 5 New Alloy tin 60 25 45 20 50 =40 zinc 10 15 45 50 45 =35 lead 30 60 10 30 10...

By definition standard deviation has divisor 'N' . But in Microsoft Excel the "STDEV" function gives 'N-1' as divisor. This may not be major issue to many of the people. But the command "STDEV" makes many users feel that this is standard deviation, i.e. it has divisor 'N'. Misleading...is...

Homework Statement A triangular wave is produced by the following combination of harmonics Using Microsoft© Excel, synthesise a triangular wave. Start with a plot of the first term and gradually add the next term. Print out the graph produced after adding each term...

i need to round numbers in a spreadsheet 2 decimal points, in a way that: for a number with a.byX for x>5 i need to round upwards for x<5 i need to round downwards for x=5 i need to round up if y is odd and round down if y is even for example 0.563~0.56 0.566~0.57 0.575~0.58...

I have the equation: (.462-.32094i)*[(7.2+9.6i)/(4-8i)] the answer is: .107+.748i Now, I need to know how to enter this in Excel, because the 4 will be varying and I will need many rows and then my answer to be changing with the change in the equation. I have tried...

Anyone use VBA in Excel::Declaring Arrays as Public Egads man...I have seen plenty of modules with arrays declared as Public. Clearly I am making some boneheaded error here and cannot locate it: Any Thoughts?

I am attempting to create an excel worksheet that accurately predicts the trajectory of a projectile. Anyways, I am having some trouble with calculating wind along the Z axis, left or right of the target. Y axis is up in the air X axis is towards the target Z axis is left or right of target Fd...

Homework Statement Ok I am working on a spreadsheet that calculates the velocity/position/drag of a point-mass projectile and I have been digging up the same equations for days and they aren't helping... lol... I just can't seem to get the numbers right, any help would be greatly appreciated...

Homework Statement The bus service operates between points A and B. The buses depart from the terminal station A with headways that follow the negative exponentioal distributiona with parameter 10 trips per hour. Assume that the characteristics of the system remain the same over time (not...

Homework Statement The cost production function as output, x, in 000's(where x>1.000) is given by the function f(x)= 8x^3 + (352/x^2)-6x +6350 Homework Equations USE THE EXCEL SOLVER function o determine the value of x which minimizes the cots. What is the cost at this point? What...

Drawing vectors on excel, how? Homework Statement Finding and graphing the resultant/equilibrant vector. Homework Equations A=90grams, angle=197 B=60grams, angle=81 C=80grams, angle=218 Find D and angle of D...which I've already found (D=140.67, angle=186.65) The Attempt at a...

:smile: Hello there! I have created a Useform with a few rows of TextBoxes. I have Changed the names of them all to "Powerbox1" , "Powerbox2" ...etc. Now in my code, I would like to store all of those values taken from the UserForm and store them in an array called Power() I have...

does anyone know how to copy data from Notepad file [Text Document] into Excel? the data I need to copy is two columns of numbers, but when I copy-paste them they appear as one column, I just couldn’t manage to separate them [they are about 40 pages long:cry:]. anyone have any suggestion, thanks...

Hi, everyone, I have a quick question for normal distribution in Excel. There's a construction project with the following monthly expenditures: JUL 2008 $ 4,903 AUG 2008 $ 3,591 SEP 2008 $ 15,452 OCT 2008 $ 12,806 NOV 2008 $ 59,988 DEC...

:blushing: using excel (vista) how can I reverse the number to be in degrees rather than radians if I want to use trigonometric functions? I have to reverse the number of the angle in radian to use those functions and I want them to be in degrees, anyone know how, thanks in advance.

GO TO POST #2 for new question please I hate to start a thread just for this, but my Googling skills SUCK today! Is there a function that returns what character is in a given position within a string? For example, Dim MyName As String MyName = "SaladSamurai" FunctionINeed(2)...