Some of my shared Apple playlist:
Some of my shared Apple playlist:
Video 1: How to freeze headers and sort data.
Video 2: How to calculate and display percentages in excel
Video 3: How to use the average and countif functions in excel
Video 4: How to filter data in an excel sheet
Video 5: Using the sum function to calculate totals in excel
Video 6: How to merge data (concatenate function) and hide columns in excel
A short video explaining how to easily add text onto a picture in your Word document.
3 weeks ago I posted on the Oktoberfest lager I brewed from the Morgan’s kits. (click here for the post).
This weekend the beer was ready to keg. To start I tested the gravity of the brew and once it was stable over 2 days I moved it to a sterilized bottling bucket and added some finings. This help to increase the final clarity of the beer.
I kept in the bottling bucket for 3 days and then prepared my keg.
After cleaning the keg, I sterilize it. During this process I also remove the beer tap and ball-lock disconnect and properly clean them. I then run some for the sanitizer though the beerline to clean it as well.
Once the keg is sanitized, I transfer the beer to it and label the keg.
I transfer the keg to the keezer and remove the little bit of air at the top by using 30psi CO2 and bleeding the safety valve a little bit.
Once the beer is cooled down after about 3-4 hours, I will add the CO2 again at 30psi for an hour and then remove it for an hour. I repeat this process until the required level of carbonation is achieved.
Some battlefield 4 gameplay I collected over the past few months.
Over the weekend I brewed an “Oktoberfest” beer. The recipe I used was adapted from one I found on the Coopers DIY Website. I mostly used supplies from BrewForAfrica and some lager yeast from Beerlab.
The kit I used was the Morgan’s Blue mountain Lager kit.
I also used 200g medium Crystal Malt, 500g Dry Malt Extract (DME) and a packet of Saflager w-34/70 yeast as well as the kit’s yeast.
I crushed the Crystal malt using a bag and rolling pin and then brought it to the boil slowly using 2L of water.
While waiting for the malt to boil, I re-hidrated the 2 packets of yeast using 250ml tepid water and cover with some plastic wrap.
The 500g dry malt was added to my fermenter.
I strained the malt into the fermenter and mixed it good to make sure there are no lumps.
I then added the contents of the kit and topped up the fermenter with cold water to the 20L mark. I then added the yeast mixed and stirred for about 20 seconds.
I then took a sample for my gravity reading.
This batch will be in the fermenter for between 2 and 3 weeks before begging it.
Being in Bloemfontein, I need to buy homebrew equipment and supplies from various shops in Cape Town, Durban and Gauteng as there is currently no physical shop here. Luckily I’ve found some great shops online that ships to Bloemfontein with great service and products. Here’s a list of shops that I use. If you know of any others – please feel free to comment.
General equipment and supplies:
I started with a Coopers DIY Kit bought from BeerBros (http://beerbros.co.za/). The Coopers Kit is a good start as it includes PET bottles. BeerBros also stock various supplies and equipment as well as Coopers DIY beer Kits.
I recently discovered Brew for Africa (http://www.brewforafrica.co.za/) and they are stockist (among other supplies) of the Morgan’s Beer kits. I’ve made a few beers from these kits and their quality is excellent. Their prices is also some of the most competitive around. They also stock Apple Cider kits that is easy to use and taste really great.
Beerlab (http://www.beerlab.co.za/) is another supplier I use and they also have various beer product to choose from.
To built my keezer, I used supplies from Keg Solutions (http://kegsolutions.co.za/) and Draught Craft (http://draughtcraft.co.za/). Draught Craft were the only supplier I could find that was able to ship a CO2 canister to me for carbonation and dispensing.
There are loads of other suppliers out there, so please drop me a line if you have a favorite.
After bottling about 5 batches of beer I decided to rather go with kegging my beer. To do that, I built a 4 tap keezer for my home.
I received great service and advice from both sites.
A video on exporting a PowerPoint presentation to iMovie and adding a voice-over track.
This is quick way to utilize PowerPoint animation in your iMovie project.
How to export a PowerPoint presentation to movie.
How to add a voice-over to a movie.