This is a download of the module explained here on the Joomla site. I got fed up of recreating it so I could modify it all the time! And I could not find a download on the web easily so I thought I would create it and place it here for all to enjoy.
Download Hello World Module for Joomla 3
Read more: Download Hello World Module For Joomla 3
This formula helps to calculate delivery costs when all you have is weights and a cost array to work with. You can't use VLOOKUP in this case as it won't find the correct value. This formula uses INDEX and MATCH together.
Read more: Excel Formula to Calculate Delivery Costs From Total Weights Using INDEX & MATCH
Today I made something beautiful. But you probably have to appreciate excel formulas to appreciate this! This formula is used to create aliases or slugs.
We use slugs to create custom URL's for our products and categories, since we ditched our SEF URL component due to speed issues we now store them...
Read more: Google Sheets - Replace Special Characters - Lower Case - Concatenate
This formula removes all the carriage returns from a cell. We find a lot that suppliers tend to have extra formatting in their descriptions that can mess up your imports, this code will resolve that.
Read more: Remove Carriage returns or line returns from an excel cell
This code is great for making products display all at the same height when you are showing lots on a page. It can keep everything in line nicely. Make sure that your title text displays the full content that you are truncating though for better SEO.
Read more: Truncate Text Using CSS and Display Ellipses...
This formula uses regular expressions to replace all special characters by only allowing a-z A-Z and 0-9 and spaces. You can add more exclusions by putting them into the  square brackets. Just change A1 to the cell you have in your sheet.
Read more: Excel Formula to Replace all the Special Characters in a Cell
I use this code a lot and it's quite useful to have handy. This is code that works anywhere in a Joomla component or module that displays or hides content based on the current logged in users group status. You can add and minus the group ID's by removing or adding to the in_array line. To find the...
Read more: How to Display Content To Specific User Groups in Joomla in PHP