Excel sheets calculation issues

[usaraj]

Hi!

Thanks for providing excel sheets for Chart calculations. I was able to successfully get my data in the HoraGanakaData sheet and it pulled in to the HoraGanaka sheet.

For some reason there are no fields highlighted yellow on the Basic sheet and in others it is not clear if any manual input is required or not. Some things may have changed due to versions of Excel too. Formulas are not working in a majority of the sheets.

For eg in Basic sheet, there is a formula invoking Dob for Sunset calculation that is failing. Could not figure out where DoB field is or is at an alias to another field.

Some idea of what date format is to be used will also help. Presently my system is set to U.S date and that may be the culprit.

Any help to troubleshoot the issues will be greatly appreciated. If you wish, screen shots can be sent. Thanks for your attention in this matter.