OK, so without even thinking of the time and effort needed for the implementation I'd like to share my ergonomic proposal for sorting the formulas in AO modules.
Current order | Proposed order
-- | --
if Y>0↣X/C | if Y<0↣1/0
if Y<0↣X/C | if Y<0↣C/X
if Y=0↣X/C | if Y<0↣C/Y
if Y>0↣C/X | if Y<0↣X/C
if Y<0↣C/X | if Y<0↣Y/C
if Y=0↣C/X | if Y=0↣1/0
if Y>0↣1/0 | if Y=0↣C/X
if Y<0↣1/0 | if Y=0↣C/Y
if Y=0↣1/0 | if Y=0↣X/C
if Y>0↣Y/C | if Y=0↣Y/C
if Y<0↣Y/C | if Y>0↣1/0
if Y=0↣Y/C | if Y>0↣C/X
if Y>0↣C/Y | if Y>0↣C/Y
if Y<0↣C/Y | if Y>0↣X/C
if Y=0↣C/Y | if Y>0↣Y/C
OK, so without even thinking of the time and effort needed for the implementation I'd like to share my ergonomic proposal for sorting the formulas in AO modules.
<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns="http://www.w3.org/TR/REC-html40">
Current order | Proposed order -- | -- if Y>0↣X/C | if Y<0↣1/0 if Y<0↣X/C | if Y<0↣C/X if Y=0↣X/C | if Y<0↣C/Y if Y>0↣C/X | if Y<0↣X/C if Y<0↣C/X | if Y<0↣Y/C if Y=0↣C/X | if Y=0↣1/0 if Y>0↣1/0 | if Y=0↣C/X if Y<0↣1/0 | if Y=0↣C/Y if Y=0↣1/0 | if Y=0↣X/C if Y>0↣Y/C | if Y=0↣Y/C if Y<0↣Y/C | if Y>0↣1/0 if Y=0↣Y/C | if Y>0↣C/X if Y>0↣C/Y | if Y>0↣C/Y if Y<0↣C/Y | if Y>0↣X/C if Y=0↣C/Y | if Y>0↣Y/C