Attempted simulation of Hong-Ou-Mandel effect

[tim1608]

Hi Cthugha

In my previous thread which has now been closed, you mentioned the Hong-Ou-Mandel effect. I have attempted to simulate it in an Excel spreadsheet but I have not managed to obtain the correct-looking results. I have attached a Jpeg of the spreadsheet and would be very grateful if you could have a look at it. I am hoping that you will firstly understand what I am trying to do in the spreadsheet and then let me know what I am doing wrong. I may be basing the spreadsheet on completely wrong assumptions or interpretations of the Hong-Ou-Mandel effect.

Thank you very much.

 

[bahamagreen]

Might help if you set the sheet to "show formula" in order to check them.

Use Ctrl + ` (Control grave, grave is the accent character to the left of the 1 key) to apply to the whole sheet.

If you do this, you may need to adjust the column widths, some of them may increase.

 

[tim1608]

Hi Bahamagreen

Thank you for your reply.

There are no complicated formulas. It is just as follows:

Column A: absolute values
Column B: absolute values
Column D = Column A
Column E = -Column A
Column F = Column B
Column G = -Column B
Column I = Column D + Column G
Column J = Column E + Column F