From what I can tell this site is mainly (not sure about solely) for the use of reviewing CODE. I am wondering if it will also review code-free spreadsheets for potentially better formulas, or layout of information, or process?
For example could I post a working spreadsheet that looked something like this:
(A) (B) (C) (D) (1) 2 4 8 False (2) 3 1 3 True
Where C has
=(A1*B1) and D has
=IF(C1<=5,True,False) and I place some conditional formatting that based on formula
=$D1 will colour the row.
and have some one review it and say eliminate column D and set your conditional formatting formula to the same formula you were using in D. Have you considers negative values? Do you really want -8 to be true as well?
OR did I miss the purpose of what Code Review is? IF this is not the appropriate site to have the thought process of a spreadsheet reviewed, where is?