Using Excel’s conditional formatting to colorize the weekends

In this period of the year most of us are starting to make plans for next year, Excel is an incedibly powerfull tool that can help you visualize your plans. Using Excel’s conditional formatting you can colorize the weekends and make them standout more than the other days of the week or vice versa. This article is an How to colorize the weekends in Excel using conditional formatting.

To colorize the weekends in Excel using conditional formatting, based upon the date in column B, you can use the following formula:

=IF(OR(WEEKDAY($B2)=1;WEEKDAY($B2)=7);1;0)

 

To create a rule using conditional formatting:

  • Select the cells that you want to apply the conditional formatting to.
  • Click “Conditional Formatting”.
  • Choose “New Rule”.
  • In the “New Formatting Rule” dialog box, choose “Use a formula”.
  • Under “Format values”, type the formula: =IF(OR(WEEKDAY($B2)=1;WEEKDAY($B2)=7);1;0)
  • The formula uses the dates in column B (You can select your own column with dates, by replacing the $B2 part in the formula with the column letter of your choice).
  • Click “Format”.
  • In the “Color” box, select your favourite color.
  • Click “OK” until all dialog boxes are closed.

 

Suggestions for improving this article are welcome, please let me know and drop me a line.

Give your Raspberry Pi a fixed IP address

Having a fixed (or static) IP address on your Raspberry Pi, comes in handy if you want to access your Raspberry Pi from the internet (for a how to about port forwarding, read this article). As you might want to use ownCloud for instance.

You can give your Raspberry Pi a fixed IP address by editting the network interfaces file.

But first, we are making a backup of the old configuration!

sudo cp /etc/network/interfaces /etc/network/interfaces.bak

 

Next thing is, editing the network interfaces file:

sudo nano /etc/network/interfaces

 

Although the IP address you want to use might be different, make your /etc/network/interfaces look like this:

auto eth0                                     # The loopback interface

iface eth0 inet static              # Tells your Raspberry Pi to use a static IP address

address 192.168.2.25            # Defines the static ip address
gateway 192.168.2.1              # Defines the gateway to use (choose the IP address of your modem)
netmask 255.255.255.0     # Defines the subnet mask

network 192.168.2.0             # Defines the network family
broadcast 192.168.2.255    # Defines the network family

 

You can save the adjustments you made to your /etc/network/interfaces file by pressing ctrl o

Press ctrl x to exit

 

After saving your new settings, you need to activate them by restarting your network components:

sudo /etc/init.d/networking restart

 

Suggestions for improving this article are welcome, please let me know and drop me a line .

Getting Broadcom STA to work on Ubuntu Studio 13.04 or Xubuntu

As I upgraded Ubuntu Studio 12.10 to Ubuntu Studio 13.04 on my Mac Book 5.1 my wireless stopped working… After surfing the internet for a couple of days I’ve found the following solution to enable the Broadcom STA on my Mac Book 5.1.

Check whether Ubuntu sees your Broadcom STA device by running the lspci command from a terminal:

lspci | grep Network

 

After using the the lspci command you should get something like this:

03:00.0 Network controller: Broadcom Corporation BCM4322 802.11a/b/g/n Wireless LAN Controller (rev 01)

 

Next up is, installing the drivers. To install the drivers run the following command using the terminal:

sudo apt-get install firmware-b43-installer

 

The broadcom-sta-common package, blacklists the b43 driver.

To fix this you need to edit the file: /etc/modprobe.d/broadcom-sta-dkms.conf

 

You can do that by using the following command in the terminal:

sudo nano /etc/modprobe.d/broadcom-sta-dkms.conf

 

Delete or comment out with a “#” the line “blacklist b43”, my file looks like this:

# wl module from Broadcom conflicts with the following modules:
# blacklist b43
blacklist b43legacy
blacklist b44
blacklist bcma
blacklist brcm80211
blacklist brcmsmac
blacklist ssb

 

Then to force the module to load during boot by using the following command in the terminal:

sudo nano /etc/modules

 

Then add a line with “b43”, my /etc/modules file looks like this:

# /etc/modules: kernel modules to load at boot time.
#
# This file contains the names of kernel modules that should be loaded
# at boot time, one per line. Lines beginning with “#” are ignored.
lp
rtc
b43

 

You don’t need to reboot your computer as you can load the module manually by entering the following command in the terminal:

sudo modprobe b43

 

Suggestions for improving this article are welcome, please let me know and drop me a line.

Remove X or create a headless server on a Raspberry Pi

As I use my Raspberry Pi as a headless server, I thought it would be a good idea to clean up unnecessary files. After studying some material from others and several attempts later, I distilled the following steps…

Login to your Raspberry Pi, so open a terminal and use SSH…

Step – 1: To get rid of orphaned files later, we are going to install a program called deborphan first:

sudo apt-get install deborphan

 

Step – 2: Next we are going to remove all desktops from your Raspbian (if you don’t want to remove samba, remove it from the following command!):

sudo apt-get remove –auto-remove –purge libx11-.* lxde-.* raspberrypi-artwork xkb-data omxplayer penguinspuzzle sgml-base xml-core cifs-.* samba-.* fonts-.* desktop-* gnome-.*

 

Step – 3: Now we are going to remove all orphaned files:

sudo apt-get remove –purge $(deborphan)

 

Step – 4: After that it is time to remove the unnecessary packages that are not orphaned:

sudo apt-get autoremove

 

Step – 5: You can even free up more space by removing the locales:

sudo apt-get install locale:purge:
sudo localepurge

 

Step – 6: Clean up some more:

sudo apt-get clean

 

Step – 7: You might need to reinstall the following packages for squeezelite:

sudo apt-get install -y libflac-dev libfaad2 libmad0

 

Step – 8: Reboot If you want, else stop start the service:

sudo shutdown -r now

 

By doing a “before and after“, you can see the difference:

df -h /dev/root

 

Suggestions for improving this article are welcome, please let me know and drop me a line .

How to EQ vocals

Of course there is no exhaustive and conclusive answer to “how to EQ vocals“, but there are some guidelines you can follow and that offer you reasonable results even if you’re not into audio.

You can use the following 4 steps within your audio package of choice.

Step 1 – Remove low frequency rumble
Set your “High Pass Filter” somewhere between 80 and 120 Hz

Step 2 – Add more freshness to audio track
Top shelf, boosting high from 8 kHz with 1 to 6 db (if you want to do it subtle: 12 – 16 kHz)

Step 3 – Reduce offending frequencies
Sweep your vocal track by using a small bell curve, to find offending frequencies round 800 – 1 kHz and reduce them by -3 db

Step 4 – Make vocals more outstanding
Boost the vocal presence in your mix, by boosting the range between 2 – 5 kHz with 1 to 4 db

 

EXTRA:

  • With everything you do while EQ ing your audio, listen carefully to the results!
  • Never work on your original files, always use a copy!

 

Suggestions for improving this article are welcome, please let me know and drop me a line .