Excel Definition and 335 Threads

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...

: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)...

Excel VBA:: Run Time Error '13' Type MisMatch?? I keep getting this error when I run this code. Nothing is highlighted..and VBA help is not working out for me. It just started when I added the for loop in bold below:Option Explicit Option Base 1Private Sub MathML_Converter() Dim i As Integer...

[SIZE="5"]Go To Post #7 for new Question :smile: So let's that I have a .txt file called input.txt that simply contains the following: abc+123 I want to load input.txt using VBA into a 1-dim array called MyArray. I want each character to be an element of the array. That is a is...

I'm fairly new to Visual Basic, so the answer to this might be really simple... So here's the deal: I have something like 500 Excel worksheets, that each contain the following: 1. 2-N equally long rows of data 2. A Line graph of one of rows 2-N versus the top row What I need to do is change...

I am observing the Sun with a small radio telescope for a research project. I am measuring the intensity of the flux and comparing it to X-ray flux data from the NOAA. I am plotting radio flux intensity against time and i get a big "hump" in the middle of the day due to less atmospheric...

Does anyone know how to do a regression analysis on excel? I need to find the correlation coefficient and the coefficient of determination and I only know how to do that with a graphing calculator TI 83+

Homework Statement I have the formula S=t^(-1/b)*g I want to type this into excel. Homework Equations The Attempt at a Solution For S are values typed into the second column (B) for t are values typed into column A. I 'named' the b and g using the name manager and set the...

Homework Statement I have a formula: x=(y/s)^r I am given data: 6 values for x and the corresponding 6 values for y. I am to find the values of s and r. I could take logarithms and make this formula linear then use linear regression (as in statistics) and do the method of least...

Dear Members, How can I read an MS Excel created csv or tab delimited file in FORTRAN 77? The two tab delimited and csv files are attached. Thank you, Ekin

Regression in Excel I want to make an regression of some data, but I only want to use some of the data. The data I want use is where Vacant = 1. Is this possible in excel? I have tried to use the if-function but the regression does not like "false" More info I want to make a...