EXCEL
Solved
lirosta25
Posted messages
6
Registration date
Status
Membre
Last intervention
-
lirosta25 -
lirosta25 -
Hello,
my name is Linda and I would be very happy if you could help me solve a problem in EXCEL that has been bothering me for a few days.
Actually, I need to plot a graph of "power" versus "time" in EXCEL. This concerns "the power of household appliances".
For example, I have "2 household appliances" at home, each with its own power and operating time in one day:
--> A laptop of 65w that operated from (8:00 to 10:30), (12:00 to 14:40), (17:15 to 20:05)
--> A television of 75w that operated on the same day from (9:00 to 13:10), (18:00 to 21:20).
I would like to know how I could plot a graph of the power of the appliances as a function of their operating time.
That is, the x-axis should show the hours ranging from 00:00 to 24:00 and the y-axis should show the different powers of the 2 household appliances.
Please, I do not know how I could plot these curves, and the curves of the 2 appliances should be on the same graph.
Otherwise, is there by any chance another program besides Excel to plot these curves?
Thank you very much for your answers.
Linda
Configuration: Windows Vista / Safari 536.11
my name is Linda and I would be very happy if you could help me solve a problem in EXCEL that has been bothering me for a few days.
Actually, I need to plot a graph of "power" versus "time" in EXCEL. This concerns "the power of household appliances".
For example, I have "2 household appliances" at home, each with its own power and operating time in one day:
--> A laptop of 65w that operated from (8:00 to 10:30), (12:00 to 14:40), (17:15 to 20:05)
--> A television of 75w that operated on the same day from (9:00 to 13:10), (18:00 to 21:20).
I would like to know how I could plot a graph of the power of the appliances as a function of their operating time.
That is, the x-axis should show the hours ranging from 00:00 to 24:00 and the y-axis should show the different powers of the 2 household appliances.
Please, I do not know how I could plot these curves, and the curves of the 2 appliances should be on the same graph.
Otherwise, is there by any chance another program besides Excel to plot these curves?
Thank you very much for your answers.
Linda
Configuration: Windows Vista / Safari 536.11
15 réponses
Hello lirosta25 and greetings to Raymond
Could it be just a simple point cloud?
https://www.cjoint.com/?0GDwi28s2WH
If so, complete the tables and add the data series to the graph
Good continuation
Could it be just a simple point cloud?
https://www.cjoint.com/?0GDwi28s2WH
If so, complete the tables and add the data series to the graph
Good continuation
Perfect! It's, more or less, what I found ...
https://www.cjoint.com/?BGFaWOVeqGt
I much prefer that you arrived at it by yourself, instead of waiting for someone else to do it for you. It's much more constructive.
Thanks again to ccm81 for their decisive and effective contribution!
--
Retirement is great! Especially in the Caribbean ... :-)
☻ Raymond ♂
https://www.cjoint.com/?BGFaWOVeqGt
I much prefer that you arrived at it by yourself, instead of waiting for someone else to do it for you. It's much more constructive.
Thanks again to ccm81 for their decisive and effective contribution!
--
Retirement is great! Especially in the Caribbean ... :-)
☻ Raymond ♂
Alas, power is not a function of time!
A 60 W bulb always has its power of 60 W, whether it is on for a second or a day.
Therefore, it is not conceivable to have a curve of power versus duration.
http://en.wikipedia.org/wiki/Power_(physics)#Electrical_power
--
Retirement is great! Especially in the Caribbean... :-)
☻ Raymond ♂
A 60 W bulb always has its power of 60 W, whether it is on for a second or a day.
Therefore, it is not conceivable to have a curve of power versus duration.
http://en.wikipedia.org/wiki/Power_(physics)#Electrical_power
--
Retirement is great! Especially in the Caribbean... :-)
☻ Raymond ♂
Hello Linda.
If you have understood the explanations regarding the power of an electrical device, we can move on to the next lesson: electric consumption.
A 75 W television running for 6 hours consumes 75*6=450 Wh
A 375 W oven that operates for 4 hours consumes 375*4=1500 Wh=1.5 kWh.
https://www.cjoint.com/?BGCf7zghkXB
And the third lesson would be about the billing from EDF, which consists of multiplying the total monthly consumption by the price of the kWh!
Best regards.
--
Retirement is great! Especially in the Caribbean... :-)
☻ Raymond ♂
If you have understood the explanations regarding the power of an electrical device, we can move on to the next lesson: electric consumption.
A 75 W television running for 6 hours consumes 75*6=450 Wh
A 375 W oven that operates for 4 hours consumes 375*4=1500 Wh=1.5 kWh.
https://www.cjoint.com/?BGCf7zghkXB
And the third lesson would be about the billing from EDF, which consists of multiplying the total monthly consumption by the price of the kWh!
Best regards.
--
Retirement is great! Especially in the Caribbean... :-)
☻ Raymond ♂
Thank you Raymond for your intervention.
Regarding my assignment, I would like to obtain a "daily load diagram," from which we can directly read on the graph the amount of energy consumed by each device according to its power and operating time.
To better explain the exercise, I would like to send you "an example of the diagram" as an attachment, but I don't know how I could send attachments through this forum. Do you have any idea?
Thank you very much.
Linda
Regarding my assignment, I would like to obtain a "daily load diagram," from which we can directly read on the graph the amount of energy consumed by each device according to its power and operating time.
To better explain the exercise, I would like to send you "an example of the diagram" as an attachment, but I don't know how I could send attachments through this forum. Do you have any idea?
Thank you very much.
Linda
Hello Linda.
1) The ethics of CCM, expressed in its Charter, prescribes not doing students' homework for them.
2) Before attempting to do an assignment, one must learn and understand the corresponding lesson.
3) In the file I sent you, there is already this "load diagram" for the two devices.
4) To attach a file, one creates a link with https://www.cjoint.com/ and pastes it into their message.
Have a good weekend.
--
Retirement is great! Especially in the Caribbean ... :-)
☻ Raymond ♂
1) The ethics of CCM, expressed in its Charter, prescribes not doing students' homework for them.
2) Before attempting to do an assignment, one must learn and understand the corresponding lesson.
3) In the file I sent you, there is already this "load diagram" for the two devices.
4) To attach a file, one creates a link with https://www.cjoint.com/ and pastes it into their message.
Have a good weekend.
--
Retirement is great! Especially in the Caribbean ... :-)
☻ Raymond ♂
Thank you very much, Raymond. I read your previous message and also visited the link containing "the courses" on electrical power, then I looked at "the load diagram" that you drew. I really learned a lot. Thanks again.
However, I have a question regarding a diagram that I would also like to draw, if possible with Excel:
With:
--> An electric bulb with a power of 0.05 kW that operates from 5:00 PM to 12:00 AM.
--> A television with a power of 0.065 kW that operates from (6:00 AM to 9:00 AM), then (1:00 PM to 3:00 PM).
--> An oven with a power of 1.2 kW that operates from 8:00 PM to 9:00 PM.
Is it possible to obtain this kind of diagram (see my example sent as an attachment) with Excel? So we have on the x-axis "the different hours" and on the y-axis "the different powers" of devices as in my example of the graph that I sent you.
Here is the example attached in this link:
http://cjoint.com/12ju/BGDcVW2LzcA.htm
or
http://cjoint.com/confirm.php?cjoint=BGDcVW2LzcA
If so, please how can I succeed in drawing this kind of diagram with Excel? I would be very happy with your response, as I have been trying to solve this exercise for a while, but in vain. I hope I explained my question well; otherwise, your questions are also welcome.
Thank you very much,
Best regards.
Linda
However, I have a question regarding a diagram that I would also like to draw, if possible with Excel:
With:
--> An electric bulb with a power of 0.05 kW that operates from 5:00 PM to 12:00 AM.
--> A television with a power of 0.065 kW that operates from (6:00 AM to 9:00 AM), then (1:00 PM to 3:00 PM).
--> An oven with a power of 1.2 kW that operates from 8:00 PM to 9:00 PM.
Is it possible to obtain this kind of diagram (see my example sent as an attachment) with Excel? So we have on the x-axis "the different hours" and on the y-axis "the different powers" of devices as in my example of the graph that I sent you.
Here is the example attached in this link:
http://cjoint.com/12ju/BGDcVW2LzcA.htm
or
http://cjoint.com/confirm.php?cjoint=BGDcVW2LzcA
If so, please how can I succeed in drawing this kind of diagram with Excel? I would be very happy with your response, as I have been trying to solve this exercise for a while, but in vain. I hope I explained my question well; otherwise, your questions are also welcome.
Thank you very much,
Best regards.
Linda
Thank you very much, Raymond, for your message,
Do you perhaps know of a program that can help me make this kind of chart?
Thank you for your response,
Best regards.
Linda
Do you perhaps know of a program that can help me make this kind of chart?
Thank you for your response,
Best regards.
Linda
Huge thanks to ccm81 and raymond,
because it’s exactly the solution I’ve been looking for for 2 weeks.
Thank you very much, now I can continue with my homework.
That’s very kind and I’m really grateful for your help...
Yay!!!!!!!! Finally.... :)
Best regards,
Linda
because it’s exactly the solution I’ve been looking for for 2 weeks.
Thank you very much, now I can continue with my homework.
That’s very kind and I’m really grateful for your help...
Yay!!!!!!!! Finally.... :)
Best regards,
Linda
Well done, ccm81!
I had thought about the scatter plot, but I couldn't manage to organize the numerical data properly... Thank you very much, for Linda and for myself!
If Linda can't manage to get the 3 diagrams on the same graph, I'll let her know that I succeeded, thanks to a little juggling with the data table. But I’ll let her think and search a bit, and I’m waiting for her to show us the result of her research...
Hello to both of you.
--
Retirement is great! Especially in the Caribbean... :-)
☻ Raymond ♂
I had thought about the scatter plot, but I couldn't manage to organize the numerical data properly... Thank you very much, for Linda and for myself!
If Linda can't manage to get the 3 diagrams on the same graph, I'll let her know that I succeeded, thanks to a little juggling with the data table. But I’ll let her think and search a bit, and I’m waiting for her to show us the result of her research...
Hello to both of you.
--
Retirement is great! Especially in the Caribbean... :-)
☻ Raymond ♂
Hi ccm81 and raymond,
I am really very happy because I've managed to trace the rest of the curves. It
wasn't really difficult. Thank you so much ccm81 for the idea.
I was able to continue with the rest of my exercises.
Below is the successful diagram. raymond I also managed to do it through some gymnastics :)
http://cjoint.com/confirm.php?cjoint=BGExiToMczv
thank you again for your great help, which has really been useful. :)
best regards,
Linda
I am really very happy because I've managed to trace the rest of the curves. It
wasn't really difficult. Thank you so much ccm81 for the idea.
I was able to continue with the rest of my exercises.
Below is the successful diagram. raymond I also managed to do it through some gymnastics :)
http://cjoint.com/confirm.php?cjoint=BGExiToMczv
thank you again for your great help, which has really been useful. :)
best regards,
Linda
I see that you understood the principle
With the scatter plot type, you can draw almost anything, as long as you know the coordinates of the "key" points or a "parameterization" of the coordinates
An example with circles
https://www.cjoint.com/?0GFmDVjpZef
Good luck with the rest
With the scatter plot type, you can draw almost anything, as long as you know the coordinates of the "key" points or a "parameterization" of the coordinates
An example with circles
https://www.cjoint.com/?0GFmDVjpZef
Good luck with the rest
Hi ccm81 and raymond,
it's Linda, it's been a while, I haven't been on the forum.
I hope you're doing well? I'm managing.
Could someone among you show me how I could "scale the x-axis" of my attachment below?
Because I drew a graph with "power" on the y-axis and "time" on the x-axis.
I would like to mark "time" every "15 minutes", so as to get this: 00:00; 00:15; 00:30; 00:45; 01:00; 01:15 .... 23:00; 23:15; 23:30; 24:00
I am attaching the assignment I started and an example of the scaling I tried to draw as an example with "Paint".
http://cjoint.com/confirm.php?cjoint=BHfw2CJivvV
http://cjoint.com/confirm.php?cjoint=BHfw5pjf1iY
Thank you and thanks again for all your help on the forum in general.
It's really very useful.
Linda
it's Linda, it's been a while, I haven't been on the forum.
I hope you're doing well? I'm managing.
Could someone among you show me how I could "scale the x-axis" of my attachment below?
Because I drew a graph with "power" on the y-axis and "time" on the x-axis.
I would like to mark "time" every "15 minutes", so as to get this: 00:00; 00:15; 00:30; 00:45; 01:00; 01:15 .... 23:00; 23:15; 23:30; 24:00
I am attaching the assignment I started and an example of the scaling I tried to draw as an example with "Paint".
http://cjoint.com/confirm.php?cjoint=BHfw2CJivvV
http://cjoint.com/confirm.php?cjoint=BHfw5pjf1iY
Thank you and thanks again for all your help on the forum in general.
It's really very useful.
Linda
Hello linda.
When you right-click on the horizontal axis and select "Format Axis," you see that the fixed maximum is set to 1, which means one day, and the fixed major unit is 0.04, corresponding to just under an hour.
In a cell on the sheet, you enter the formula =1/24 and get 0.041666667.
If you copy/paste this cell to replace 0.04, you will have gradations of 01:00; 02:00, etc.
In another cell, you enter the formula =1/24/4 and get 0.010416667. A copy/paste into the "fixed major unit" box allows you to have a gradation every quarter of an hour 00:15; 00:30, etc. However, to be able to read these graduations, you will need, still under "Format Axis," to choose Alignment/ Text orientation/ Rotate 270°.
https://www.cjoint.com/?BHgaSGYU7ce
--
Retirement is great! Especially in the Caribbean ... :-)
☻ Raymond ♂
When you right-click on the horizontal axis and select "Format Axis," you see that the fixed maximum is set to 1, which means one day, and the fixed major unit is 0.04, corresponding to just under an hour.
In a cell on the sheet, you enter the formula =1/24 and get 0.041666667.
If you copy/paste this cell to replace 0.04, you will have gradations of 01:00; 02:00, etc.
In another cell, you enter the formula =1/24/4 and get 0.010416667. A copy/paste into the "fixed major unit" box allows you to have a gradation every quarter of an hour 00:15; 00:30, etc. However, to be able to read these graduations, you will need, still under "Format Axis," to choose Alignment/ Text orientation/ Rotate 270°.
https://www.cjoint.com/?BHgaSGYU7ce
--
Retirement is great! Especially in the Caribbean ... :-)
☻ Raymond ♂