Question about Microsoft Excel for PC

1 Answer

Sort data and create graphs for each quarter

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.

Thank you very much in advance.

Sincerely,

Sv

Posted by on

Ad

1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    MVP:

    An expert that gotĀ 5 achievements.

    Governor:

    An expert whose answer gotĀ voted for 20 times.

    Scholar:

    An expert who has written 20 answers of more than 400 characters.

  • Expert
  • 146 Answers

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.

Posted on Jan 28, 2008

Ad

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi there,
Save hours of searching online or wasting money on unnecessary repairs by talking to a 6YA Expert who can help you resolve this issue over the phone in a minute or two.

Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.

Here's a link to this great service

Good luck!

Posted on Jan 02, 2017

Ad

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

About microsoft excel


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

Aug 22, 2012 | Facebook Computers & Internet

3 Answers

What is excel


Hi,

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.

Regards,
Shrey

Jun 04, 2011 | Microsoft Excel for PC

1 Answer

What is excel


What is Excel blankxl_250.jpg
Microsoft Excel is a spreadsheet program which allows one to enter numerical values or data into the rows or columns of a spreadsheet, and to use these numerical entries for such things as calculations, graphs, and statistical analysis.

Dec 15, 2010 | Microsoft Office Excel 2003 for PC

2 Answers

How do I clear things left in the stat plot window?


To clean the slate so to speak, just reset the RAM.
  1. Press [2nd][+] to access the (MEM)ory management function
  2. Press [7:Reset]
  3. Press [1:All Ram]
  4. Press [2:Reset]
  5. Press [CLEAR] to erase the "RAM cleared" Message

Calc

Aug 02, 2010 | Texas Instruments TI-83 Plus Calculator

1 Answer

I have a cect n97c and i can't seem to get the settings correct in the the phone to be able to send and receive mms. I've called t-mobile 20 times and they finally told me that i needed to contact the...


Create Data Account

3. Select Services
4. Select Data Account
5. Select GPRS
6. Choose an empty profile
7. Account Name enter T-Mobile WAP
8. Press Options
9. Press Done
10. APN enter wap.voicestream.com
11. Press Options
12. Press Done
13. User Name >Leave Blank<
14. Password >Leave Blank<
15. Auth. Type choose Normal
16. Press Done
17. Press Save
T-Mobile MMS

Create Profile


3. Select Services
4. Select WAP
5. Select Setting
6. Select Edit Profile
7. Select a profile
8. Choose Edit Profile
9. Rename Profile enter T-Mobile WAP
10. Homepage enter wap.myvoicestream.com
11. Data Account select GPRS
12. Select T-Mobile WAP
13. Connection Type select HTTP
14. Proxy Address enter 216.155.165.050
15. Port enter 8080
16. User Name >Leave Blank<
17. Password >Leave Blank<
18. Press Done
19. When prompted to SAVE please select Yes
20. Select Activate Profile
21. When prompted to Activate Profile please choose Yes
22. Press Done


Create Data Account

3. Select Services
4. Select Data Account
5. Select GPRS
6. Choose an empty profile
7. Account Name enter T-Mobile WAP
8. Press Options
9. Press Done
10. APN enter wap.voicestream.com
11. Press Options
12. Press Done
13. User Name >Leave Blank<
14. Password >Leave Blank<
15. Auth. Type choose Normal
16. Press Done
17. Press Save

Create Profile


3. Select Messages
4. Select MMS
5. Select Message Setting
6. Select Server Profile
7. Select a Profile
8. Select Edit Profile
9. Select a profile
10. Choose Edit Profile
11. Rename Profile enter T-Mobile MMS
12. Homepage enter http://216.155.174.84/servlets/mms
13. Press Options
14. Press Done
15. Data Account select GPRS
16. Select T-Mobile WAP
17. Connection Type select HTTP
18. Proxy Address enter 216.155.165.050
19. Port enter 8080
20. User Name >Leave Blank<
21. Password >Leave Blank<
22. Press Done

Reboot your phone
this should work i had the same problem

Mar 12, 2010 | Cell Phones

1 Answer

Help me please


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.





Before jumpin

Oct 07, 2009 | Texas Instruments TI-84 Plus Calculator

1 Answer

Autofilter ceases to work on large Excel 2003 spreadsheet


Sounds like there is a gap between the filter heading and the column data. That's the only time I've seen suggested data missing from the drop-down.

Jun 16, 2009 | Microsoft Computers & Internet

1 Answer

WHAT IS THE DIFFERENCE BETWEEN MICROSOFT EXCEL FROM DATA BASE


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.

Nov 20, 2008 | Microsoft Excel for PC

1 Answer

Microsoft excel(data analysing)


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.

Sep 22, 2007 | Microsoft Office Standard for PC

Not finding what you are looking for?

Open Questions:

See all Microsoft Excel for PC Questions

Microsoft Excel for PC Logo

Related Topics:

79 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

3015 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18425 Answers

Alun Cox

Level 3 Expert

2678 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...