Excel Definition and 335 Threads

Hi all, I have been trying unsuccessfully to figure out how to insert many horizontal rows into the same cell in Excel: I have gone over many sites, asked people, all sorts of key combinations, without success. Any ideas you know work, please? Thanks.

Homework Statement So I have to make three charts for the measurments that we made in class (physics experiments but it's not important). The first one had to be with a linear trendline, the second one with a exponential and the third one with a logarithmic trendline. For some reason the last...

Hello, I currently have a Google Sheets document that I want to run some analysis on. The document is very formula- heavy (not just raw data). It takes a set of input numbers and does some computations and gives me an important output number at the bottom of the spreadsheet. These computations...

Hi PF! I am trying to copy info from MATLAB to Excel via the following code filename = 'testdata.xlsx'; A = [12.7 5.02 -98 63.9 0 -.2 56]; xlswrite(filename,A) but I receive the following warning: Warning: Could not start Excel server for export. XLSWRITE will attempt to write file in CSV...

Hi All, I have been trying to teach myself programming recently (Python, mostly). I obviously still have a good way to go. User MarneMath was nice-enough to help me in this post a while back: : https://www.physicsforums.com/threads/classification-valuation-problem-baseball.893418/#post-5630986...

Homework Statement [/B] Hello, I trying to solve for the minimum value that the x and y components reach in plot (A). I know that you can perform this using IgorPro but I would like to know how to solve for it using Excel. The plot was constructed using the following data points: 110...

Hi there, I was wondering if someone could help clarify something for me. I am using excel to find the area under a curve. I am using the : (B1+B2)/2*(A2-A1) equation to do it. However, due to the nature of the graph, all the value I am getting are negative. The values on the X axis decrease...

I currently use the free online (web-based) version of MS Excel through Google Docs. I recently made a spreadsheet to input medical billing stuff and have come across some annoying problems that I'm wondering if anyone has experience with and could help me resolve: 1.) I have one column...

Hi PF! I have two matrices of equal dimensions. I would like to plot them such that row ##i## of matrix 1 corresponds the x-axis and row ##i## of matrix 2 corresponds to the y axis, so that row ##i## of matrix 1 and matrix 2 together give a coordinate. Does anyone know how to do this quickly...

Hi PF! I'm plotting a log-log plot in excel, and each axis currently lists numbers like 1, 10, 100, 1000. What I would like is ##10^2,10^3##... etc. Any help would be awesome!

In Excel, I wish to automatically delete multiple columns that have (0) in particular row location. How to do this? After the deletion, the data array should shrink to only columns that do not have (0) at that row.

Suppose I need to fill a row composed of 32 cells with a sequence of 4 cells with value 1 in a row followed by 4 cells with value 0 in a row and then again 4 cells of 1 and so on. How can I do this without copying those cells and repeating pasting them in their location?

Say I have two columns containing data in Excel. Column A contains 10 non empty cell and column B contains 12 non empty cells. How can I create a column C with 10 + 12 cells without specifically telling Excel to put cell B1 in cell C11. In other words I would like to concatenate column A and B...

I have a matrix of data and I want to do SVD using excel, is it possible?

Suppose I apply a particular function and I get a value of the cell-A1. How can I copy this value to another cell-C1 and the entire column under C1 to use it in a new operation provided that C1 and the entire column are always updated when A1 changes?

Hello, I am trying to make a graph on excel 2013 with two y axes, and the internet says I should click on the "Layout" tab under the Chart Tools tab, but I do not have that tab. How do I do this?

Take the sequence 1,2,3,4,5,6,7,8,9,10... If you found the percent change for each interval and kept on finding the percent change of the percent change of the sequence, why does the change become more and more chaotic? Here is a quick table I made...

Hello all, i don't have much knowledge about programming so i googled about fetching datas from docx to excel and it showed can be done by VB. I see under developer tab in excel and opened Macros where i can write programmes. Now i have many docx files in my folder and daily it is increased by...

Hello MHB Gurus I'm writing this section but I'm not sure if is the right one I wonder if is possible to import an Excel Table (with copy and paste) from excel into the forum with line and boarders Thank you for your help 7 mag 2014 10:20 1,3928 7 mag 2014 10:25 1,3926 7 mag 2014 10:30 1,3925...

How do I make excel to calculate 2 unknown from 2 equations like these a . x = 5 a. x^2 = 10 for example How do I do the setup?

I would like to ask how to use MATLAB to append new columns into existing excel file without altering the original data in the file? In my case I don't know the original number of columns and rows in the file and it is inefficient to open the files one by one and check in practice. Another...

I have column from E5 -->E35 which contains values for each box. another column from F5-->F35 contains values for each box I have a sums column, H5-->H35,, which contains values for the sums between the E and F boxes (E5+F5=H5 ;;; E6+F6=H6 etc...) I want a division column inside J5-->J35 which...

Hi. I am having issues using the sumproduct function in excel. I two values in cells A1 and B1 that I want to multiply. I have two values in cells C1 and D1 that I want to multiply, and so on and so forth. I want to add these products afterwards. I think I have a problem with the syntax I use...

water moves over a stationary horizontal flat plate of one-meter length. if velocity of water is 1 m/s, draw boundary layer and friction coefficient versus x for this plate. hint: start your curves from x=1cm.Professor asked us to do it in Matlab or Excel and I'm not sure I understand how to...

I have a lot pressure data (in CSV) taken over a long time and would like to dynamically zoom and pan to analyse the data. Any suggestions?

Homework Statement I did an experiment to measure the speed of sound(using two microphones and a hammer). I changed the distance between the two mics and calculated(using a fast timer) the time taken for the sound to reach from the start mic to the end mic. I made a graph(distance on x axis...

Hi all, I have a bunch of legacy files I am trying to import directly into an .sql database. Is there a way of doing this other than by using Microsoft's import/export Wizard?

Hey all, pretty easy question. Received a request that we are obligated to uphold regarding our purchasing information. We must provide the information in a concise format (pff). Here's the issue. They are going to use it to sell marketing information and we don't like the idea of them making...

I'm having a physics lab in which a report needs to be submitted after an experiment. The experiment includes many measurements: values with their errors. I need to round the error up to 2 significant digits, and then to round the value up to to the amount of digits that the error is presented...

i have equation: ur=2.c(1-v2)/(w.d.i)(1+v2) i don't know how to write imaginary coefficient in excel.please help:(

If I want to lookup row 3 column "amz" and the end result will be side by side, how do i do that Example: a=.4 m=.91 z=.22 input; amz output: .4.91.22

1. I'm given time (s), extension (mm), tensile stress (mPa), and tensile strain (%) in a table. I'm supposed to graph it on excel, but my graphs don't look at all like a stress-strain graph. 2. I think it's probably because I'm using tensile stress or strain? Or is it an excel error I'm doing...

How can I set up a function with an if command such that it only copies values greater than zero from another column while leave the rest of the cells empty (not zero)?

Homework Statement My group and I have to design a lap wound dc motor. Maximum of 12 volts and 5 amps. Must have no more than two poles. The aim is to achieve maximum efficiency. I've created this excel spread sheet to calculate the gauge of wire we need and the type of magnets. Also how...

Here is essentially what I need to do for a school essay: I have an excel sheet with 200 points (x corresponding to A1 column values, y corresponding to B1 column values). I need to find a way to transfer this to a graphing program in quadrant 1 (all x,y coordinates are >= 1 and less than or...

I am writing a paper and I came up with a function that uses a hypothetical relationship to predict the value of one variable at different points in time, I graphed it, and then graphed the actual readings from an experiment. How can quantitatively describe how close the two trends are? In other...

I just need a quick answer, say I have a bunch of data points on a graph, I made a trendline with a function of y = 5x + 6, and a r value of R^2 = 3, is there a way of converting the r value into a percent uncertainty in the prediction of the functions? Say I used the function to predict when x...

Not really a programming question, but if you will: I have two data series, one is force over time, the other is velocity over time. The first series has a sample rate of 1 measurement per 0.1 second and is consistent. The second series has an irregular sample rate (due to the intermittent...

I should probably be asking Excel's programmers, but I have been lucky in this forum lately; here is what I got going on: I have a data table composed of two variables: time and angular velocity of a particle around a centre point. Time is just 0.0, 0.1, 0.2 (in seconds) and so on. Angular...

Hello all, I am a new user to Ansys. I am currently using it for fracture mechanics analysis to calculate the stress intensity factor(SIF). I am supposed to calculate the SIF for different force applied to my model. The forces are on an excel sheet. Is there some way I could link this excel...

Can anyone tell me how to work out the Kw usage of a plate heat exchanger using Primary and return flow rates when no demand for hot water or heating is needed; assuming 0.04p per Kwh is charged. Basically a valve is passing when the heat/hot water is off and want to work out the heat loss and...

Hey everyone, I'm hoping I can get some input on this. As some of you may recall, I'm currently in an internship at Fermilab, and I've hit a snag in plotting my data. I'm measuring the intensity of the NuMI neutrino beam at multiple different points to look for discrepancies in the measured...

I have an optimization algorithm running 50 full trials with up to 10,000 iterations each (it breaks off if the error goal is reached before that). I want to export the iteration number and the best function value at each iteration to an excel file, then after each trial completes move to the...

Hey everyone, This may not be the right place to post this, so if an admin thinks a different section would be better suited, please move this thread. So I'm in the midst of my summer internship at Fermilab right now. I'm currently trying to plot some data for the beam intensity of the NuMI...

Im trying to colour excel cells using (r,g,b) values. I understand its possible to do this through macros or through custom functions. Any suggestions / solutions?

Hi everyone, I will start off by saying that I am a complete novice in Matlab and prefer to use Excel however the data that I have requires more computing power than Excel can provide. I have 16 sets of data with over 70,000 rows and 9 columns. The first column is a time series separated into...

Homework Statement I have a list of data, positions and measured voltages at each position. As part of my lab analysis I have to find the electric field at each position. I know that the slope of a potential versus distance plot is the electric field, but I have no clue how to find not the...

Homework Statement Hello! I would be grateful for your help. I've tried many many times to record a mixed reference macro on my mac, and it doesn't record a thing. No problems with recording separate macros with relative or absolute reference. Problems description: I have few sheets with...

hi are there any good free alternatives to Microsoft excel to do accounts in Thanks

Hello Master. I would like to ask a question about MS Excel and one of it's functions; CONCATENATE. I'm trying to write a huge number of reactions in the Excel as the following form : 12C (α,p) 15N So, since I have tons of reactions to organize according to the alphabetic order and isotopes...