Skip to Content

Analyzing Costs - Protect

Q: Should I password protect my cost analysis?

In general, if you are creating a cost model that involves inputting data into fields that contain formulas, you would like your users to be able to input data, but you want to protect the actual formulas that will calculate the costs and the time value of money (i.e., net present value). You may prefer to protect the discount rate used as well, but frequently users are allowed to assume different discount rates to reflect varying opinions about the best source for this information. Nonetheless, since these formulas are frequently complex and difficult to de-bug once corrupted, it is wise to password protect formula fields/cells and results cells, and only allow users to input data regarding number of human resources, data objects, etc

 

 

Groups:


about seo | group_wiki_page