Office

  • Buffer
  • Sharebar
  • Buffer
jethro's picture

Excel Function of the Week - MOD

The MOD function is very useful in certain circumstances.

The function returns the integer remainder after a number has been divided by a divisor. For example if you divide 10 by 3, it goes in 3 times with one remaining.

image

jethro's picture

Recently discovered cool tools

Here is the last lot of totally unrelated cool tools I have found.

Swiss Army Knife Business Multi Tool The Coolest Tool I have found in a while is MCEBuddy.

MCEBuddy takes your LARGE Windows Media Center television recording (and other video) files and makes them small saving you disk space.  It also removes commercials and converts your recordings into formats that are usable on other systems and handheld devices.  It does all of this automatically with a minimum of fuss and little or no technical knowledge required.

This tool just works – it is awesome!

jethro's picture

Excel Function of the Week - ROUND

The round function enables you to truncate values to the number of decimal places you desire. This could be in fractions of a whole value e.g. hundredths and thousandths of whole number, or as large numbers, e.g. rounding to the closest million or billion.

There are some very similar functions, ROUNDUP, ROUNDDOWN and MROUND. In addition there are some complimentary functions such as FLOOR and CEILING.

These functions all perform the same way with specific variations. Round follows the 4/5 round principle. That is if the number ends in 4 or lower it rounds down, and if it ends in 5 or higher it rounds up.

image

jethro's picture

Drupal Meetup and Website Management

Thursday night I went to my first Brisbane Drupal Meetup. It was great. There were 8 or 9 people there so most of the time was actually spend learning a little about each other (and kidding Mark about coding on reel tapes).

Jeff and Sheree and Josh from Marmalade Soul organised it. I also picked up cards from Mark, Chris, and Tony. Nick from Our Brisbane who I had already met because I am hosting and maintaining www.studybrisbane.com.au was there too. He is a real funny guy!

I had decided to present a summary of the tools and methodologies we employ here at Jethro in looking after something like 30 Drupal websites. As promised I have listed below the major tools and their uses below. This is a much bigger subject than the 10 minutes I gave to it on Thursday and I am really interested in seeing what others are doing.

ms office logo Disclaimer: Yes I live in a Microsoft world. No I do not hate Macs or open source. and yes, sometimes Microsoft products are not the best products to use. On their own. But; most of the Microsoft tools that we do use are either because they are awesome or because of their integration and synchronisation with other MS tools. They are also generally easy for new staff to learn to use.