Dismiss Notice
Join Physics Forums Today!
The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

Attempted simulation of Hong-Ou-Mandel effect

  1. Jul 16, 2014 #1
    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.

    Attached Files:

  2. jcsd
  3. Jul 16, 2014 #2
    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.
  4. Jul 16, 2014 #3
    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
Share this great discussion with others via Reddit, Google+, Twitter, or Facebook