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.
I totally forgot how to do this (it's been a long while). I'm thinking it was "=sumproduct" feature? Anyway I'm trying to find the sum of cuberoot(exp(sin(arctan(3x^2+2x-3))))) from x=1 to x=1,000,000 in excel. I believe you input ranges for the variable x. I'm not sure. I accidentally deleted...
Hello,
I was working in excel on data reported in two columns, X data and Y data. I measured both X and Y, i.e. Y was not calculated using a function and the X data. The Y an X data was plotted as Y vs X using a scatterplot. The Excel graph offers the option to add error bars over each point...
I'm trying to sort this sheet in Excel. I want to sort it on Column D.
I select the entire page by clicking the black arrow in the upper left corner:
Now I Data > Sort which brings up a dialogue where I specify the column I want to sort by :
(I can already tell there may be a problem -...
I am not sure, If I really understand the Question. This is what I have done so :
pax inbound + outbound = total
total/trip no inbound
225/110 = 2,04 -> is the first row
This has bugged me for a while, so I finally was trying to figure out how to disable this "feature" today. But Microsoft Help and Google haven't led to any fixes yet.
If I have a Word file open and minimize it, and then open another Word file, the first file window also pops back up and ends...
I was given an Excel that contains a list of products, my teacher would like us to scrap through the website hktvmall.com to find respective similar products and list out their prices and description.
FYI:
My code is as follow:
import pandas as pd
from bs4 import BeautifulSoup
import requests
import os
url = 'https://www.goodschool.hk/ss'
response = requests.get(url)
html = response.content
soup = BeautifulSoup(html, 'html.parser')
school_items = soup.find_all('div', {'class'...
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...
Basically, microsoft excel always has white background cells, and I'd like it to be a different color. Here's what I've tried: I configured the below registry value in my Windows 11 user profile to change the default window color from 255 255 255 (i.e. white) to 192 192 192 (i.e. a not so...
I just wanted to check to see if this is a known problem, or if my issue is more likely related to something different.
I have an Excel spreadsheet that has a number of lines with comments and other information at the top, and then a matrix of cells below that on several rows. I had some Excel...
Hello everyone.
I'm trying to do a Kubelka Munk equation for paint samples and would like to do the calculation in Excel first before moving it over to a programming language outside of MATLAB. I have Spectroscopic scans of the samples and put them into a database where the K/S values have been...
I want a column that displays what standing each team has. (I can't really Google a solution because I don't even know what to call it.)
This the idea:
- team 1 is "1st",
- teams 3 and 10 are "2nd",
- team 5 is 3rd,
etc.:
I can't think of a way of doing it that isn't very complex...
Homework Statement:: See attached
Relevant Equations:: analysis stats
Find below a sample of the data that i want to import onto spss; My intention is to have the data appearing as one variable only on PSPP.
This is how it appears on PSPP;
It defaults as 5 variables, ...i used comma...
Hi,
I'm having trouble dealing a "picture-like" object that I copied from a webpage (.html) file. It is the larger white rectangle in rows 194-195, that reads "United StatesStates"
It just doesn't go away when I delet the the row. I tried to scrape the file directly into Excel from the site ...
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...
Hello,
I am struggling to create a formula in excel that coverts CFM per linear foot to liters per second per linear meter.
Thank you for your valued help.
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...
Summary:: Interpolation
Hi,
I want to interpolate two values in Excel.
The first value is in cell "A1" and has the value "0". The second value is in cell "A20" and has the value "1".
I now want to interpolate the values in cells "A2" to "A19" in such a way that a linear straight line is...
I am showing a school pupil (over the Internet) how to use EXCEL. He can work with an EXCEL file that he opens himself (on a free version of Microsoft office). However, when I send him a file (either one I opened on my computer or even one that he sent me and I send back to him), he finds that...
Hi Everyone,
I'm writing a sci-fi book that looks at humanity's response to the end of life on Earth and their voyage to a new home. The first part of the book is how a large mass of dark matter in the relative vicinity of Earth (50 light years?) starts the process of extending the...
--------------------------------
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...
I had found the singuarity function for the shear and moment. I have a hard time calculating the singuarity function and graphing it using excel. Can anyone explain how to calculate singuarity function and graphing it using excel?
Many thanks for your help
Hello,
i am testing batteries for a project of mine. I first measure the voltage on the battery (OCV, Open Circuit Voltage), and then i place a load resistor over the battery. This results in a voltage drop with a exponential decrease in voltage like in the image. But i am working with a...
Hi,
I want to create a graph from the following data. The data is related to 3 different computers but the fields are same:
Please provide me the steps.
Garph1 BS
CPU Percentage 12
Memory Usage 15773696
sdiskusage total 9.82901E+11
sdiskusage used 1.41429E+11
sdisk usage free 7.91472E+11...
The summary is complete to describe the problem, but to forestall the solution to either (a) leave the Category : "number" and just type what I want, or (b) put the Type as "English(United States)" and type 3/4/2019, I mention why these solutions would create difficulties: a person to whom I...
Hi All,
I am doing a linear regression in Excel 2007. It is not available within the usual settings so I must. Edit: activate , an add-in called (Duh) Edit' Analysis Toolpak'
What seems strange is that I have to install it each time I use it so that it seems to be installed only when the...
Hi All
Background
I'm nearing the end of development of an Excel add-in (commercial) which adds new engineering and math features to Excel. I'd like to have a discussion with people that use Excel on a daily basis to ensure that the product adds true value and meets their needs and desires by...
Hello All! (Wave)
A friend on another site reached out to me with a question regarding using Excel. I told him I know nothing about it, but that I could probably find someone who does. Here is his question:
Thanks for any help! :D
Hi all,
I am having #HREF! issues in Excel 2007 when copying formula-based data from one sheet to another. The suggested solutions online are not working.
I understand what the issue is: when copying from one sheet to another, Excel is trying to use data from the previous sheet, sheet_j...
I am attempting to solve an ODE using a Calculus add-in for Excel. I am an industry professional and I have not even thought about Differential Equations in 8 years. The equation that I am attempting to solve is in the form:
(1)
The ODE solver that I am using solves equations of the form...
In Microsoft Excel, if I type in the formula =GCD(113,100) then it gives me the correct answer of 1. However, if I type in =GCD(1.13*100,100), which means the same thing, it tells me 4. What's going on and how can I fix it? Thanks
Good morning,
I used the Laser beam with HR4000 spectrometer with Ocean View software when saving the files it is saved by (.ocv) format. when trying to extract information to excel I get some unreadable data like (bkg thin sheet gel.png) attached. I used the same instrument and software with...
Hi,
I am trying to access Excel Sheet .xlsx files in Java. I have tried various options available from internet. My program is using following jar files:
poi-ooxml-3.5-beta4.jar,
openxml4j-1.0-beta.jar
I have done following imports:
import java.io.*;
import java.io.File;
//import...
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...
Hello :)
I was given this task:
A quarterly deposit is €700 in 4.5 years, and the accumulated value is €13,600. What is the value of annual interest rate?
And I would apply this formula:
S = [((1+i)n - 1) / i] ∙ R
€13,600 = [((1+i)18 - 1) / i] ∙ €700
To find out the annual interest rate...
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 have a set of n point (x, y) of experimental data and a function y=f(x) which is the theoretical model. I want to plot them in the same graph and see the difference. My problem is that f(x) has to be a continuous line while my n point has be just dots. I need to get something like this:
I...
I have the winston equations for the cpc but i am having problems getting the exact shape of a symmetric compound parabolic concentrator in excel
Help me with the corrections in terms of the width 2a =10 and half acceptance angle of 30 dg please
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...
Homework Statement
I am having trouble with Microsoft Excel formulas to obtain the correct data for Kinetic Energy 2 initial, KE1 final, KE2f, KEi, KEf, total KE and total KE%
Homework Equations
Microsoft office uses equations such as =(A2+B2) and I need to determine what is the appropriate...
Let me preface this by saying I am reasonably intelligent overall, but I'm a complete idiot when it comes to computers and technology. I've been trying for hours to put a graph onto LaTeX for a physics labs, but I'm getting nowhere and very frustrated. I've tried to follow guides online, but...
Hi everyone,
I have this question about POP.
Assume a patient separation of 20cm. Using data for 6MV , FS 10x10 cm, plot the depth dose for one beam at 2 cm intervals. Include on your plot the dose at dmax and the dose at 20-dmax.
On the same graph repeat this for the opposed beam. Now plot the...
Hi All,
I want to compute the ratio of two fields A,B from different sheets ( same workbook)
, using Pivot ( tho "straight" Excel will do*). I tried using the Wizard, but , in the end, could
not find a way of doing it:
Any ideas, please?
*I scewed big when trying this.
Hi All,
Sorry if this seems pretty lost.
I want to compute an expression of the type A/B with data given in different sheets, i.e., A is given in sheet i and b is given in sheet j. Now, I know that in
SQL Server ( SQL in general), one can join tables. Is there a similar way of
getting data...
I have a spreadsheet with quite a bit of information. This spreadsheet is designed to encode words and create a encrypted message. Unfortunately, the process of coding and decoding is long and tedious. I am looking for a way to make this process quick (depending upon message length) and easy...
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.