#1 Unlock Cell References

[Eric Colson]

I noticed that the formulas for e-values calculations use locked cell references. For example, note the use of the "$" in the formula: =$O$17*$Q$19+$O$26*$Q$28

I suspect this is so you can manipulate the cells without worry of invalidating the references. However, it makes it tough to copy and paste entire trees as the references are locked. Copying and pasting trees is tremendously helpful in our homeworks as permutations are common (not to mention the tool does not support multiple trees on the same sheet).

One way you could achieve this is to write a function that locks the cells just be for a manipulation and then unlocks them after you are done. For example, you can write a function to add "$"'s to every cell reference and another to remove them (Excel might also have something to do this natively).

Thanks -- it is a very helpful tool!

- Eric