I just want to make public the spreadsheet that I use for calculating Effective Demand. I cleaned it up a bit.
You will be able to see the equations in the individual cells. The flow of how the information is processed may be hard to follow. You would have to "trace the precedents and dependents" of each cell to see how the information flows.
The second sheet is the one that I use for regressions. I have to copy over the ED-FF numbers from the "NGDP adj inflation target" sheet each time I do an iteration of a regression.
The third sheet was the preliminary calculations before I incorporated the equation for NGDP targeting. I include it just for the record.
You can download the Excel file at this link.