Excel Definition and 347 Threads

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

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 MyArray(1), c...

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

I have a wierdness with Excel 2003 and I can not figure out how to get rid of it: Problem: The entries in a cell do not show up in the formula bar. Particulars: 1) If I have an equation in a cell, the equation will show up only if I highlight the cell and then put my cursor in the...

Does anyone a way (ANY WAY!) get get these buttons on either the Ribbon or Quicklink toolbars? p.s. for 2003 and pre users, yes I am aware that typically one would simply "Customize Toolbars", find the icons and drag them where you want them. However, though an option in Word, for some...

Hello all, I am trying to extract the 2nd degree polynomial coefficients from a curve of best fit applied in EXCEL. I know how to do it (http://spreadsheetpage.com/index.php/tip/chart_trendline_formulas) 2nd Order Polynomial Trendline Equation: y = (c2 * x^2) + (c1 * x ^1) + b c2...

Quick question, I am taking this analog design class and the class includes a project which requires design optimisation using either excel,or mathcad Has anyone used excel to optimise the design? If yes, can you please guide me to the resource on how to setup excel to optimise or give...

Homework Statement I have determined the solution to my problem however now the problem asks me to plot theta as the block flies off the sphere when Mu k ranges from 0.0 to 0.5 in increments of 0.05 I don't know a great deal about working with Microsoft Excel. Well I do just not enough to...

Hi I'm trying to make a distribution curve in excel, but I can't seem to find it. I have excel 2003 I know how to make column graphs and stuff, but I can't seem to find where to find how to make a distribution curve can anyone help me? Here is a link of the type of graph I want to make...

I am playing with some accelerometer data and need to filter out the noisy output. How do I implement a Low pass filter in excel? I tried avg, rolling avg. They all smooth out the data but not what I want (averaged accn is finite when it is actually zero!) If I can create an envelope...

Hello Everyone, I would like some help developing a model. I am using the Solver in Excel, but the results are giving me counter-intuitive results. I believe it is because my model is incorrect. Once I get some help perfecting the model, then I will worry about translating it for the Solver...

Hi, I am attempting to find an equation to fit a curve that I have plotted in Excel. I use the trendline function and get an equation but when i place that formula in excel and with the values they are different. I have attached the spreadsheet to show you. The yellow columns are my original...

I have two data sets and want to do a regression so that the equation that relates them is of the form y = C(x^n), where C and n are constants. How do I do this in Excel?

Homework Statement Values for t 1,2 3,4 7,15 9,32 12,28 15 18,39 21,45 Values for ln(V∞-Vt) 3,6 3,57 3,54 3,51 3,48 3,45 3,42 3,39 ln V∞ = 3,63 Homework Equations ln (V∞-Vt) = ln V∞ - k''t Teacher Quote: "If ln (V∞-Vt) is plotted against t in a diagram a straight...

I have data that I'm using for a wind turbine project. The project requires that I retrieve data from an excel sheet that was supplied of experimentally tested values for lift and drag. These values for lift and drag are based on a value alpha (an angle, but irrelevant to the coding question)...

EVEN EASIER EXCEL question! I am a little confused as to how I am supposed to "mark" the proportional and Ultimate stresses on my stress-strain diagrams. I created them with Excels 'insert x-y scatter' function. I cannot find any way to add a text-box though... Any ideas? I basically just...

Ok, so the teacher gave us an assignment to write a program that calculates the ratio below, tabulate it and plot it.. for given values of R and λ. T_b/T_a =([R^4-(R-λR)^4])/([4λR^2 (R-λR/2)^2]) I figured that I would use Excel to do this. I think the above equation converts to the...

I have a lot of Excel spreadsheets which are actually log files from a test (so they all have the same structure) and I need to get the data (a number) from a specific cell (same cell) in each file and do their average. Does anybody know an efficient method to do this?

I have a excel file with a graph that has error bars. i have added a trendline, but i want to know what the "error" of the trendline is? how do i make excel do that

Homework Statement Not sure if this is suppose to be posted here or not, but i need help with making a chart in excel 2007. I need to make a scatter chart. The x value is 0.25. The y values are 4.68E-19, 4.10E-19, 3.06E-19. The Attempt at a Solution I tried making the chart but it gets...

Greetings all - I am trying to determine the staffing requirement for an ongoing project. Here are the project specs, and I need to know if I need a part time or full time person. 461 clients 10 minutes to complete each client task (minimum of 10 minutes) Repeat each task quarterly...

im doing a simulation on a magnetic moment in a magnetic field B and I am quite stuck. its a set of coupled equations: m'-x=B*m-y & m'-y= - B*m-x where m-x is the x component, ' is rate of with respect to time etc. the vector should be precessing in a circle with frequency w= - B, B is set...

Hi I have just imported a fairly large matrix from a excel spread sheet (121x6) useing the xlsread function. Is there a way I can convert the matrix from my command window to look something like below. Matrix = [...; ...; ...; ...; ...; ...] I want to know if i can store the matrix in a...

Hi, I have read WAV files as data/numbers into MATLAB before for Fourier analysis etc and am now trying to do the same with Excel. I have found code online which has allowed me to make use of the winmm.dll from windows to be able to create a WAV sound file from excel and also to be able to...

Homework Statement The Warren County Telephone Company claims in its annual report that “the typical customer spends $60 per month on local and long distance service.” A sample of 12 subscribers revealed the following amounts spent last month. $64 $66 $64 $66 $59 $62 $67 $61 $64 $58 $54...

I am sure that many of you are using Excel to do data capture, what are some suggestions as to a USB interface module that will allow multiple voltage or current readings. Also, any suggestions on any built in timer functions in Excel? Thanks, pud

Hello, I'm using mathematic (NDSolve) to solve a series of PDEs, which I have successfully done. Now I would like to export the data so that I can make a graph in Excel (I know I can plot the results in Mathematica (and I have) but I would like to be able to export it to Excel, as I am a...

Okay, the formula that I am working from is: (RL+S) – sqrt [ RL^2 – (S*sin CA)^2 ] – S*cos CA Rod Length = RL = 5.090 Half Stroke = S = 1.5 Crank Angle = CA = 107.5 With numbers plugged in (my version?): (5.090+1.5) - sqrt [5.090^2 - (1.5*sin (107.5))^2] - 1.5*cos (107.5) The...

Hi, I've posted another thread asking for general help on how to solve numerically with excel. Here is my specific situation if anybody is well versed with Mathematica programming. I'd appreciate any help. I've successfully created a FindRoot to solve eqn's for one set of data points...

My quandary... it's related to not being able to evaluate numerically (non-algebraic solutions) with Excel. My Mathematica programming is limited, but I've managed to use Findroot to solve it, but it requires me to manually put in 3#'s, hit enter, then copy paste results back to excel...

Hi everyone, I'm new to the forum and just need some quick help on a VBA assignment if anyone has some spare time. I have three questions I need answered. They all take place in the latest version of Microsoft Excel, VBA. 1. I need a small 20-line chunk of code explained in detail...

i have done this over countless number of times and i can't get it to work, so i turn to the PF Gods and hopefully you guys/gals can figure it out. we were given data in a excel spreedsheet. we have to find the computed velocity. There is no write up how to do this, my teacher showed up on the...

I need help on writing an excel program that will allow my company to have multiple tabs with some of the same information linked. I would like to have the people in my company each have a tab with there information on it, and when they change something in there tab the main tab with the master...

Hi I have been having a problem with a section of my code in the macro that I've created. The problem is that the formulae that I want to use aren't working and soe I get a "##Name" error in the cells where the formula is supposed to have worked. Patientrange = Range(PatAgeLet & "2" & ":"...

Or know of any good tutorials? This is a PAIN to do by hand.

Which do I find the excel function for additional amount up every week? For example: $100 + $50 = $150 last week then add new $50 this week total is $200 to keep the amount up every week. It should work either + /- amount Thank you.

Does anyone know how I can get Excel to convert binary to Gray Code and two's complement?

Homework Statement The error part of my physics labs have been takin up a lot of time lately. Anyways, say I have 10 numbers for time measurements like 3.53 s, 5.32 s, 3.57 s, 4.89 s, 3.24 s, etc... and my reaction time is say +/- 0.20 s. I want to average these 10 values out but I have to...

Here is the part that I am confused on. I have to calculate the number of years the employees have been working for us, I believe the function I need to use is TODAY but it is not working, how can I get that function to work? I also need to figure out how to use the functions when looking at...

Hi all, I have this excel problem: In a column, there are entries (can be characters or number), but there are also some blank cells. How could I remove all the blank cells so that the column is shorter. Here I attached an illustration Thanks for any comments

I have a set of data and I need to fit a curve to it. The equation of the curve is: y=20-a*10*log(x) My problem is just getting a curve fit to this equation. What function in MATLAB should I be looking for? How do I get the value of 'a'? Is it easier to achieve this in Excel? How?

MS Excel Help -- Saturation Points ?! Does anyone know how to do this with if-then statements or something else? For example: I want to analyze inflow and outflow in a tank, when the volume reaches zero then it's empty of course--so I shouldn't have a negative volume after this, volume...

Does anyone know how to find the maximum of a graph using excel? so i have this graph i plotted out, and i want to find the coordinates of the peak, is there a way to do it? or do i just have to estimate? any help would be appreciated! thanks!

I just got my Analytical Chemistry test grade. It's fine but not a great grade. Everybody thinks it was a problem of time constraint.I think it's because were given question types that are different from what is in our book. Around 70% is very acceptable. The rest is a complicated problem that...