Automatically convert Excel files formatted like the following:<p><pre><code> /* Tax rate */
var b1 = 50%;
/* Salary */
var b2 = 120000;
var b3 = b1 * b2;
</code></pre>
To:<p><pre><code> var tax_rate = 50%;
var salary = 120000;
var b3 = tax_rate * salary;
</code></pre>
I'm trying to improve the readability and feature discovery of excel by bringing linting and autoformatting to excel.<p>Currently there's only the one linting rule. What excel best practices would you like to see added?
This was inspired by a hn comment that linked to "you suck at excel" [0].<p>First, I realized how much I suck at excel despite being in love with it. Excel just has so many features and the basics are good enough to solve most excel problems. This means I never search for a better method and only discover features through word of mouth.<p>Then, I realized many of the suggestions could be automatically applied (named cells, standardized color formatting, defined tables). Other suggestions could just be recommended (you seem to be using formulas to build a pivot table, click here to learn about pivot tables).<p>This seems to obvious so it probably exists. But I only found Microsoft's excellent excel static analysis addin ExcelLint.<p>[0] <a href="https://www.youtube.com/watch?v=0nbkaYsR94c" rel="nofollow">https://www.youtube.com/watch?v=0nbkaYsR94c</a>