Calculate Fourier Series coefficients using excel

[Jayashree_B]

I am trying to calculate Fourier Series coefficients(a1 & b1) using formulae in excel for a particular case.

In a book by Henry Ludwell Moore, 'Economic Cycles :Their Law & Cause', the author has calculated these coefficients for rainfall data in Ohio valley. 

I am able to calculate them correctly for the cycles which divide the total data completely ( e.g. 8th cycle in 72 readings sample).

But I am unable to calculate for other cycles. (e.g. 10th cycle in 72 readings)

Please help.

I am unable to attach my worksheet and Moore's calculations for your kind reference.

[#2]

Hi @Jayashree_B,

Were you able to solve the problem? If not we can collaborate on the same as I am having the same issue. Would it be possible to share your excel sheet so I can have a look? Thanks.