search

ProjectDrawdown / solutions

The mission of Project Drawdown is to help the world reach “Drawdown”— the point in the future when levels of greenhouse gases in the atmosphere stop climbing and start to steadily decline, thereby stopping catastrophic climate change — as quickly, safely, and equitably as possible.
https://www.drawdown.org/
Other
216 stars 91 forks source link

Net Profit Margin calcs #16

Open DentonGentry opened 4 years ago

DentonGentry commented 4 years ago

In the Excel models the Land solutions produce Net Profit Margin results as an output, and it is believed that even non-Land solutions could use this though the Excel models do not do so. Net Profit Margin is not currently implemented in the Python model, it needs to be added.

DentonGentry commented 4 years ago

The public versions of the Excel files are checked into the repository. We removed them once tests/test_excel_integration.py evolved to the point of not needing them any more, as they were quite large, but they are still in the history. They are stored using git LFS so they don't take up local disk space for people who check out HEAD.

git revert dcad0e37763807602e1220c9477dd24667127aa4

will restore the deleted Excel files. Look in solution//testdata/.xlsm to find them. If you do revert this to get the Excel files back, please make sure not to include it in a future pull request as this would substantially increases the local disk space needed for others who check out the repo.

If you revert this commit but solution//testdata/.xlsm are tiny little files, that probably means you need to git lfs install before re-doing the revert. The Excel files reside in Large File Storage.

The Land solutions, like solution/conservationagriculture or solution/regenerativeagriculture, have a Sheet in their Excel file named "Net Profit Margin" and this part of the model has not yet been implemented in the Python model.

Looking at one of the other sheets which has been, like Operating Cost or First Cost, might help in making sense of what needs to be done for Net Profit Margin. There are some extremely raw notes about Operating Cost and its conversion to Python which might be useful.

DentonGentry commented 4 years ago

Based on Twitter DM conversations, there is a developer looking in to this issue. Before someone else begins work on this, please ping me and I can check in with them.

colleenskemp commented 3 years ago

We believe Josh is working on this. ;-)

4dahalibut commented 3 years ago

I'll try to do this one.

denised commented 3 years ago

It's all yours :-)