Plot compound parabolic concentrator in Excel

  • Thread starter Thread starter Josh chips
  • Start date Start date
  • Tags Tags
    Excel Plot
AI Thread Summary
The discussion centers on creating a plot of a symmetric compound parabolic concentrator (CPC) in Excel using the Winston equations. The user is struggling with the correct dimensions, specifically a width of 2a = 10 and a half acceptance angle of 30 degrees. There is a request for JPEG screenshots of the work to facilitate assistance, as sharing Excel files from unknown sources may deter others from helping. The goal is to accurately represent the CPC shape in Excel. The conversation emphasizes the need for visual aids to improve collaboration and troubleshooting.
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
 
Mathematics 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: 657

Thread 'What Exactly is Dirac’s Delta Function? - Insight'

Insights auto threads is broken atm, so I'm manually creating these for new Insight articles. In Dirac’s Principles of Quantum Mechanics published in 1930 he introduced a “convenient notation” he referred to as a “delta function” which he treated as a continuum analog to the discrete Kronecker delta. The Kronecker delta is simply the indexed components of the identity operator in matrix algebra Source: https://www.physicsforums.com/insights/what-exactly-is-diracs-delta-function/ by...
View full post »

Thread 'Fermat's Last Theorem'

Fermat's Last Theorem has long been one of the most famous mathematical problems, and is now one of the most famous theorems. It simply states that the equation $$ a^n+b^n=c^n $$ has no solutions with positive integers if ##n>2.## It was named after Pierre de Fermat (1607-1665). The problem itself stems from the book Arithmetica by Diophantus of Alexandria. It gained popularity because Fermat noted in his copy "Cubum autem in duos cubos, aut quadratoquadratum in duos quadratoquadratos, et...
View full post »
Thread 'Imaginary Pythagorus'

Thread 'Imaginary Pythagorus'

I posted this in the Lame Math thread, but it's got me thinking. Is there any validity to this? Or is it really just a mathematical trick? Naively, I see that i2 + plus 12 does equal zero2. But does this have a meaning? I know one can treat the imaginary number line as just another axis like the reals, but does that mean this does represent a triangle in the complex plane with a hypotenuse of length zero? Ibix offered a rendering of the diagram using what I assume is matrix* notation...
View full post »

Similar threads

B How to draw a plane intersecting a cylinder at a "compound angle"
Replies
8
Views
3K
MHB Calculation when Mixing Two Compounds....
Replies
2
Views
3K
Plotting the waveforms of the harmonic components
Replies
4
Views
3K
I Boas 1.13 Compound interest/geometric series
Replies
1
Views
2K
I Finance: does the volatility of a stock follow a certain distribution?
Replies
24
Views
4K
Non-linear extrapolation graph
Replies
12
Views
3K
B Calculating the perfect tennis shot using vectors
Replies
2
Views
2K
B Determine forces acting on double inclined plane
Replies
13
Views
2K
CPC and Fresnel Lenses for Solar Cell Power
Replies
5
Views
6K
Calculators How can I plot concentration as a function of time on my TI-84 Plus calculator?
Replies
1
Views
2K

Hot Threads

Recent Insights

Back
Top