Plot compound parabolic concentrator in Excel

[Josh chips]

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

 

[Josh chips]

please find attached of what i have done so far

 

[berkeman]

Welcome to the PF, Josh.

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.

 

[Josh chips]

am trying to come up with this drawing in excel