Practice Management

 View Only

COVID-19 Cash Flow Modeling Template V2 

03-25-2020 09:10

v2 eliminates a formatting issue some may experience in the chart by freezing the Y-axis values. When I created the original worksheet, I manually placed the heavy horizontal red line across the $0 line in the chart so users had a clear indication of when their cash reserves went negative. In the original version the Y-axis values could change depending upon the dollar values in their practice. If that happened, the $0 line could float up or down some, but the manually placed red line would not. In v2 I froze the Y-axis values so the $0 horizontal line won't move.

The other solution would be for users to Unprotect the worksheet and manually move (or remove) the horizontal red line themselves.

Statistics
1 Favorited
22 Views
1 Files
0 Shares
22 Downloads
Attachment(s)
xlsx file
COVID Cash Flow Impact Calcs_Radiology v2.xlsx   40 KB   1 version
Uploaded - 03-25-2020

Related Entries and Links

No Related Resource entered.