Microsoft Excel is a spreadsheet developed by Microsoft for Windows, macOS, Android and iOS. It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications (VBA). It has been a very widely applied spreadsheet for these platforms, especially since version 5 in 1993, and it has replaced Lotus 1-2-3 as the industry standard for spreadsheets. Excel forms part of the Microsoft Office suite of software.
Hi,
as I know the barometric formula is an exponential equation, but when I did the experiment with a barometer at different heights and inserted these results in Excel for curve fitting, it showed a weird thing, I think. So exponential equation did show that R^2=0.942 and the second-degree...
Hello,
I normally get these things working but I am a bit stuck as i don't feel I am getting sensible answers...
The problem is simple (!):
Q: Model the flow through an orifice with an upstream/supply pressure of 301BarA where the downstream pressure is in the range 1BarA to 301BarA. The...
Here are two examples:
1. Microsoft Excel. If you buy the newest version of Microsoft Office, it is able to open and read all files that were created with the older versions of Microsoft Office. Let's say that I have an older version of Microsoft Excel and I create some files with it. Later...
--------------------------------
Hi, just some backstory: My mom and my brother Rob, both loaned me some money in August 2020. They each loaned me $1000.00. I decided to use excel spreadsheet to keep track of my progress paying them both back.
Okay so here is the data table I created; as you...
Hi all. I was bored so I created the following spreadsheet: https://docs.google.com/spreadsheets/d/1JkJFoNsLOeHPXjhF2ei9iMjSFwupyYWjfOgzbbK-EBM/edit#gid=911477072
I'm currently having some trouble with this. I want to find the values of expenditures for each year such that the happiness present...
Homework Statement
Hello everyone, I am currently experiencing a problem plotting harmonics in Excel.
I'm only able to plot the fundamental wave properly, I can't figure out how to plot the 3rd and 5th harmonic as they have a different frequency. Can you point me in the right direction...
Hi All,
I somehow cannot see the content of an Excel data file; please see bottom of document listing average of 34133, count of 11199, etc. Yet the data is for some reason I can't figure out, not visible/available. This Excel 2010. EDIT: The saved file has 329KB of data. But only that which...
I came across this article about using Pandas in Python to read in a multi-tab spreadsheet to Python, and work with the data then write back to an Excel spreadsheet...
I'm currently writing a paper over an experiment I did for class and I have a very stupid question over I need clarification on before I continue.
I am using excel to graph out data, and I have determined that the error in my Length is .001 m. However, I am graphing the inverse of length to...
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...
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...
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...
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...
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...
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)?
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...
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...
Hi,
I need help to add an exponential trendline on my graph. I have three graphs and I have succeeded with the first one but somehow the exponential trendline will not show on the two other graphs even though I have selected the option multiple times. I also tried to re-do the graph in a new...
Can you please tell me what MS Excel uses to find a Power trendline?
I have been experiment with data from my PunchBot project and it seems the Power Trendline fits the best. The plan is the used the data from my machine (an array of time intervals) to find the curve of the acceleration and...