Excel Definition and 335 Threads

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?

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

Hey all, I have a quick question about the minor gridlines in MS Excel. I have points that differ by .00001 on the graph. However when I type this in, Excel automatically changes it to .000036 every time. I wasn't sure if anybody knew if Open Office could solve this problem or if its just...

[SOLVED] Calculate molar masses in excel Hi all. Does anyone know of some MS excel macros for easily calculating atomic/molar masses? After googling for hours the only (decent) one I can find is http://www.dartmouth.edu/~pchem/chemacro.html. Unfortunately it is supposedly a mac .sit file...

I have a titration curve (pH vs NaOH added) and i want to determine the endpoint of this graph i want to use excel to make a graph of it's derivative (dy/dx) but i don't know how? does anyone know how? is there an option i can choose when making the graph?

Now that excel handles 64K of rows it is becoming a pain dragging a formula to fill in that many rows. Is there a way of selecting a range and having the formula drag apply to that range?

Homework Statement I have data for an ECG and I want to filter it. Homework Equations The problem tells me to run the signal through a low pass filter. I tried a single pass double pole filter (essentially the average of three averages). If we have data points A, B, C, D, E, and F...

As reported in Slashdot, http://it.slashdot.org/it/07/09/24/2339203.shtml "Excel 2007 Multiplication Bug"

Is there any software that will convert a series of numbers into a simple line graph, the same as Excel, but allowing me to use a lot more numbers? I'm writing a program in c to convert a sinewave, or any wave, into a triangular wave. I've sort of done it, but there is noise in my...

Hi, As part of a school project on statistics, I'm trying to calculate some parameters of collected data. I've the marks of 50 randomly sampled students in 6 subjects. I'm trying to calculate their skewness. Since the inbuilt Excel function to calculate skewness uses an estimator I've never...

Homework Statement My goal is to create a graph in excel that moves as I hold the F9 key(and progressing the time). The concept is of a 'rubber ball' bouncing after it is dropped from an initial height. The variables that must be left in separate cells (to easily change) are kinetic energy...

I am using the VB script that is already in Excel, and I am making a program similar to that "Deal or No Deal" show that airs in many countries. The concept of the game is where there is a certain number of briefcases, and there is a money value in each of those. You choose one, and slowly...

this is rather embarrassing, but it's late, i have a headache and can't figure this out. so i have this complicated function i need to sum (not sum as in add up - sum as in sum a series). my formula that needs to be summed: (2/(n*pi))*sin(n*pi*z/L)*e^(-(n^2)*pi*pi*k*t/(L^2)) pi, z, L, k...