Plot compound parabolic concentrator in Excel

  • Thread starter Josh chips
  • Start date
  • Tags Tags
    Excel Plot
3 replies · 2K views · last reply
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
 
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.
 
Cross-section diagram of a compound parabolic concentrator: left parabola L and right parabola R meet at a truncation line, with focal points F_L and F_R, an absorber along the base, aperture A at top, axis lines, a vertical line, and labeled angles phi_1, phi_2 and 2theta_a, plus height h-bar and point (x-bar, y-bar).
am trying to come up with this drawing in excel
 
Attachments
  • Cross-section diagram of a compound parabolic concentrator: left parabola L and right parabola R meet at a truncation line, with focal points F_L and F_R, an absorber along the base, aperture A at top, axis lines, a vertical line, and labeled angles phi_1, phi_2 and 2theta_a, plus height h-bar and point (x-bar, y-bar).
    image941 (1).jpg
    9.6 KB · Views: 702