Describe the bug
When setting depreciation to 100% on one category (such as 5 year MACRS) the send to excel with equations produces a divide by zero error.
To Reproduce
Steps to reproduce the behavior:
- Open attached send to Excel spreadsheet, see error: div_by_zero_host_developer.zip
Tested in host developer, may exist in others.
Expected behavior
Setting depreciation to 100% in any category should be allowed. I suspect cell B398 on the cash flow tab should be referring to C145 on the inputs tab, like the cells nearby.
Operating System and Version
- OS: [Windows, macOS, Linux]
- Version 2023.12.17r2, maybe others.
Additional context
@cpaulgilman, I'm assinging this to you, and leave it to your discretion whether to solve this in the patch (maybe in the Excel updates after #1477), or delaying until the release.
Describe the bug
When setting depreciation to 100% on one category (such as 5 year MACRS) the send to excel with equations produces a divide by zero error.
To Reproduce
Steps to reproduce the behavior:
Tested in host developer, may exist in others.
Expected behavior
Setting depreciation to 100% in any category should be allowed. I suspect cell B398 on the cash flow tab should be referring to C145 on the inputs tab, like the cells nearby.
Operating System and Version
Additional context
@cpaulgilman, I'm assinging this to you, and leave it to your discretion whether to solve this in the patch (maybe in the Excel updates after #1477), or delaying until the release.