Why make this blog?

Why make this blog?

There are thousands of Excel sites out there, why another?

This is a way for me to share scripts and tips I find interesting or helpful.

The following are the guidelines I intend to stick to as much as possible.

  1. Keep it simple.   This applies to the code, the blog and life in general.  Don't over-complicate!
  2. Make it Modular ( where possible )  - This follows on from #1.
    Don't write the same book twice. If you're finding yourself writing the same code afresh each time you create a procedure, find a way to turn it into another function you can re-use.
  3. Don't re-invent the wheel -  If it's been done before (and likely better) - learn from it, cite it.
  4. Credit where credit's due -  Where building upon the code of others, Cite sources.
  5. The Right Tool for the Job - Excel can do a lot, but not everything. If there's a better tool to do what you need ( interactive dashboards - Qliksense,  Summing Millions of lines of data - SQL Server , Making Coffee - Nespresso
  6. Annotate Annotate Annotate.  - Yes you know what the variable "asfasdfsdf" means now, but will you remember in 6 days, let alone 6 months?  No.  Add comments, explain what you're doing and preferably, why!