Articles tagged with #excel




Install PHP Pear Spreadsheet in Ubuntu and Mint

If you've ever had to work with spreadsheets on a linux system, you may have stumbled across the PEAR Excel Spreadsheet Writer. Its a quite useful too, but installing it on your system may be a little misleading. Here's the quick rundown: # install php-pear sudo apt-get install php-pear # install PEAR …



Compute Linear Regressions in Javascript

Its very seldom, but now and then you have to go back to those old math equations from college and compute some nice graphs, or solve a few complex formulas. Linear Regressions aren't completely foreign territory, they are used more often than you realize. I've put together a nice function …



Execute Excel-like Formulas on your Tables and Grids

If you do much reporting I'm sure you've encountered needing to sum up a row, or divide, or average some data in a grid, much like you would do in Excel. Its actually not that difficult to whip up a simple, dynamic solution with javascript. I'm using jQuery, but it …