Plot compound parabolic concentrator in Excel

  • Thread starter Thread starter Josh chips
  • Start date Start date
  • Tags Tags
    Excel Plot
Click For Summary

Discussion Overview

The discussion revolves around the challenges of plotting a symmetric compound parabolic concentrator (CPC) in Excel, specifically using the Winston equations. Participants are seeking assistance with the correct dimensions and angles for the plot.

Discussion Character

  • Technical explanation
  • Homework-related

Main Points Raised

  • One participant mentions having the Winston equations but struggles with accurately plotting the shape of the CPC in Excel, requesting corrections regarding the width and acceptance angle.
  • Another participant asks for JPEG screenshots of the work done so far, suggesting that sharing images may be more accessible than an Excel file.
  • A participant expresses their intention to create a drawing of the CPC in Excel, indicating ongoing efforts to visualize the concept.

Areas of Agreement / Disagreement

The discussion does not appear to have reached a consensus, as participants are still exploring solutions and sharing their progress.

Contextual Notes

Participants have not specified the assumptions or definitions they are using regarding the CPC, and there may be unresolved steps in the plotting process.

Josh chips
Messages
7
Reaction score
0
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
 
Physics news on Phys.org
please find attached of what i have done so far
 

Attachments

Welcome to the PF, Josh. :smile:

Can you post a few JPEG screenshots of your work? Many folks may be reluctant to open an Excel spreadsheet from an unknown source. Thanks.
 
image941 (1).jpg
am trying to come up with this drawing in excel
 

Attachments

  • image941 (1).jpg
    image941 (1).jpg
    9.6 KB · Views: 679

Similar threads

  • · Replies 4 ·
Replies
4
Views
3K
  • · Replies 8 ·
Replies
8
Views
3K
  • · Replies 13 ·
Replies
13
Views
2K
  • · Replies 5 ·
Replies
5
Views
6K
  • · Replies 1 ·
Replies
1
Views
2K
  • · Replies 5 ·
Replies
5
Views
2K
Replies
5
Views
8K
  • · Replies 2 ·
Replies
2
Views
3K
  • · Replies 9 ·
Replies
9
Views
2K
  • · Replies 1 ·
Replies
1
Views
1K