policy-design-lab / data-import

Programs used to convert raw CSV files into JSON files for various PDL programs
0 stars 0 forks source link

[BUG] Fix formula error in the consolidated_data excel document and update the CSV and JSON files. #96

Closed sandeep-ps closed 1 month ago

sandeep-ps commented 4 months ago

Describe the bug A clear and concise description of what the bug is.

To Reproduce Steps to reproduce the behavior:

  1. In Title 1 sheet, the total for each programs also include the year in the header, which should not be added.

Expected behavior The formula in the consolidated_data sheet should be corrected, and the CSV and JSON files should be updated.

Screenshots If applicable, add screenshots to help explain your problem.

Additional context.