There is an error in the spreadsheet where some examples (e.g., quateman) produce a 1-day gap between the start date of a billing period and the previous billing period's end date. When this is fixed in the spreadsheet, we will need to update all examples (inputs and assertions) that were affected by this error.
created a copy of the source spreadsheet and put here.
adjusted formula in column D of ngma_gas_billing_data_Service 1 sheet to add 1
updated summary.json to reflect changes in summary tab
exported natural gas sheet to csv
updated csv in quateman folder
ran tests
based on results, changed estimated balance point from 51.5 to 52 in spreadsheet. With changes to data, this is a more accurate estimated balance point.
There is an error in the spreadsheet where some examples (e.g., quateman) produce a 1-day gap between the start date of a billing period and the previous billing period's end date. When this is fixed in the spreadsheet, we will need to update all examples (inputs and assertions) that were affected by this error.