At Fixya.com, our trusted experts are meticulously vetted and possess extensive experience in their respective fields. Backed by a community of knowledgeable professionals, our platform ensures that the solutions provided are thoroughly researched and validated.
I do have a spreadsheet where I am entering data for job my company have done.
I do have 19 different equipments, so I have to read each equipment find how many operating days it was done for each equipment, sortted out and then find out from other two different columns how many hours was downtime, and calculate how mouch money we have to pay back to compoany we did serivice.
Then I have to create a spreadhseet for each quarteer and graph with performance, actually with downtime.
Anybody interested to help and I will send a spredsheet.
You could have all the data in the same worksheet, but sort it using filters, eg data....sort.....auto-filter. click on the little arrow at the top of each column, then click on the item listed. this will then show only those rows associated with that item.
- If you need clarification, ask it in the comment box above.
- Better answers use proper spelling and grammar.
- Provide details, support with references or personal experience.
Tell us some more! Your answer needs to include more details to help people.You can't post answers that contain an email address.Please enter a valid email address.The email address entered is already associated to an account.Login to postPlease use English characters only.
Tip: The max point reward for answering a question is 15.
Made by Microsoft, used for creating, opening and managing spreadsheet data files created with the application. Spreadsheets allow you to manipulate numbers, formulas, information and extrapolate resulting information, graphs, charts, organized lists, export data to create all sorts of useful results. Not sure what else you want to know...
Microsoft Excel is a commercial spreadsheet application . It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications.
Microsoft Excel has the basic features of all spreadsheets, using a grid of cells arranged in numbered rows and letter-named columns to organize data manipulations like arithmetic operations. It has a battery of supplied functions to answer statistical, engineering and financial needs. In addition, it can display data as line graphs, histograms and charts, and with a very limited three-dimensional graphical display.
Hello, Sorry if you already know that, but I want to make sure we understand one another.
Say you want to graph the function Y1=2X+3. You press [MODE] to make sure that the FUNC on 4th line is highlighted permanently. If it is you press [Y=]
On the first line where it says Y1= you enter 2*[X,T,Theta,n] +3. The X is accessed with the key to the right of the [ALPHA] key. As you key in your function, notice that the equal sign after Y1 is highlighted and remains so. When you finish entering the function press [ENTER] so that the cursor moves to the line Y2=. Make sure that the = sign after the Y1 in previous equation remains highlighted.
You can now draw the graph by pressing [GRAPH] or generate the table Y1=f(X) by pressing [2nd][TABLE]. Under no conditions should you enter YOUR own values. If the table does not appear there may be a problem, and you will not solve it by entering values.
Now let us try to get you calculator to work as it should.
Press [2nd][STATPLOT][4:PlotsOff] , the command PlotsOff echoes on main screen. Press [ENTER] to turn statistical plots OFF. Screen displays Done. Press [2nd][CATALOG] [ENTER]. The list of all avilable command appears. Scroll down till you reach ClrAllLists. Move arrow to the correspondig line and press [ENTER] , command echoes on main screen as ClrAllLists. Press [ENTER] to erase all old statistical lists that may be stored in the calculator memory.
Now you are ready to graph or create the table of values. Press [2nd][Table] and the table should be displayed. All you can do with the values in the table is to look at them, examine them. You cannot modifie nor erase them.
If, for reasons of your own, you think you ought to be allowed to enter YOUR values, in the table, then this is not graphing functions. The name for that is DOING STATISTICS. And the procedure is tottaly different: You enter YOUR values in lists and use the calculator to draw the data points, and to find the best fit (the curve that models the pattern of data distribution best). When you decide which fit is the best, you can use the calculator to extract the equation for the curve and, if you want it, to draw the curve on the same graph where you raw data is represented. Hope these clarifications helps.
Excel is a spreadsheet - it is less structured than a database and all of the data appears on one (or more) pages along with many calculations and summaries of data.
A database is structured so that all the information is kept in the same format for each member record of the database - Databases are better at processing larger volumes of information.
Some tasks can be performed equally well in either spreadsheet or database -
Often data is stored in a database but analysis is done in the spreadsheet.
Microsoft Excel is an application used for building spreadsheets. It has many built in calculation and graphics tools. Some people use it to track expenses while other use it to graph numbers for charting process.
As far as data analyzing it all depends on the data. Whether is sales figures or budget information. It all can be done inside of excel using it built in formulas and functions.
×