Hacker Public Radio

When we were looking at Writer we saw that Styles and Templates are key concepts to using any word processor. They are not quite as central in spreadsheet use, and one can be a proficient user without resort to them, but they do give you control over the appearance of your spreadsheets, and can give the sheets you create uniform appearance. We discussed these ideas in great detail in our Writer tutorials, so I am going to hope that some of that knowledge has carried over here. Still, lets get to some basic concepts: http://templates.libreoffice.org/template-center http://www.vertex42.com/blog/news/templates-for-openoffice-and-libreoffice.html http://www.odfauthors.org/libreoffice/english/calc-guide/published-lo4.0/cg4-0-ch4-styles-templates/at_download/file http://www.ahuka.com/?page_id=938

Jacob Lienenkugels Winter Explorer Pack "Chippewa Falls, WI since 1867" Winters Bite - Do you know what it smells like when you open a tin of cocoa (the semi-sweet kind, not the unsweetend) and no matter how you do it, a litle of the powder puffs out? The best descrition I can give this beer is it tastes just like that smell, even down to the dryness. Neither cloyingly sweet or leaving you wondering who mixed the chocolate syrup into you beer, just a sublte taste of dry cocoa. This lager pours dark with very little head. This beer (my favorite it this group) is only available in the Explorer pack, and it's ABV and ingredients are not featured on leinie.com. Helles Yeah - (German blonde lager, Helles means "light" in German, but unlike American beers, it refers only to color). Straw color, very clear, moderate head that disapears w/o lacing. Sublte flavor, a hit of hops and just slightly more than a pinch of pepper. 5.5 ABV Malts: Pale malts Hops: Five All-American hops including Simcoe and Citra Cranberry Ginger Shandy - [From Wikipedia, Shandy is beer mixed with a soft drink, carbonated lemonade, ginger beer, ginger ale, or apple juice or orange juice.] Pours cloudy yellow amber, moderate head that disapears w/o lacing. Leinenkugel managed to resist the urge to color it red. Not as syrupy as Shock Top's Cranberry Belgian Ale, but unlike many fruit adjunct brews, neither is the flavor so subtle you have to go searching for it. I like to use ginger in cooking, and I can also detect the taste of that sweet spice in this weiss beer as well. 4.2% ABV Malts: Pale and Wheat Hops: Cluster Other: Natural cranberry and ginger flavors Snowdrift Vanilla Porter - Pours dark brown with just a litle carmel color head that disipates imediately. Vanilla bean aroma. Vanilla flavor is perhaps more subtle than Breckenridge's Vanilla Porter, but there will be know doubt you are enjoying a beer flavored by vanilla and roasted malts, with a hint of chocolate to keep it from being too sweet. 6.0 ABV Malts: Two- and six- row Pale Malt, Caramel 60, Carapils, Special B, Dark Chocolate and Roasted Barley Hops: Cluster & Willamette Other: Real vanilla BONUS ROUND -Leinenkugels Orange Shandy - Wheat beer, likely exactly the same one that's in the Cranberry Ginger Shandy, but in this case the tart/sweet orange juice taste dosn't completely obscure the flavor of the beer. I like them both, but I think I would grab the orange shandy on a hot day. 4.2% ABV Malts: Pale and Wheat Hops: Cluster Other: Natural orange flavor

We take a look at one of the most powerful, but somewhat frightening, features of modern spreadsheets. But knowing the basics of pivot tables should make themn a bit less frightening to the newcomer. http://iteach.usf.edu/2012/07/microsoft-office-pivottable-sample-worksheets/ http://www.ahuka.com/wp-content/uploads/2014/06/pivot.ods http://www.ahuka.com/?page_id=911

A unique ASN is allocated to each AS for use in BGP routing. AS numbers are important because the ASN uniquely identifies each network on the Internet.

Ruth Suehle gave the next-to-last keynote at Ohio LinuxFest 2014 on 2014-10-25. In this talk she discusses the significance of open hardware and maker culture, and how this is something we all should participate in. Maker culture is an essential part of the free and open culture we belive in when we talk about open source. And we need to be vigilant to protect our values in the hardware space. As an example she tells us about Bre Pettis and Makerbot, which at one time were very open, but have turned aginst this value as they became more successful. In the final analysis, it is up to us to protect open hardware by voting with our dollars/euros/whatever.

As part of Hacker Public Radio's continuing effort to showcase Creative Commons Works, we are proud to present GeekSpeak. GeekSpeak is produced as a radio show for community based station KUSP in Monterey CA, and rebroadcast as podcast, available from GeekSpeak.org. It is a generally a lighthearted and humorous general technology news show, with topics including electronics, computing, robotics, and green tech. Often guest speakers and authors from the technology world will come on for interviews. The shows are just about an hour long. The regular hosts are Bonnie Jean Primbsch, Lyle Troxell, Miles Elam, and Ben Jaffe (see GeekSpeak.org/geeks/for the full roster). You can often hear them thanking the "Puppetmaster" for letting them continue to use the name GeekSpeak. After broadcasting for several years, it was discovered the term "GeekSpeak" had been registered as a service mark by David Lawrence for a podcast of his own. You might remember Lawrence as the actor who played the character on "Heroes" with the telekinetic ability to physically manipulate other characters against their will. GeekSpeak has a long standing tradition of using Devo's "Through Bein' Cool" as intro music, so only those episodes that employ user contributed music instead are actually released Creative Commons. What you are about to hear, from the 1st of June of 2013, is just such an episode. Links GeekSpeak.org www.kusp.org http://www.thedavidlawrenceshow.com/ http://7thavenueproject.com/ - This is another KUSP show, often dealing with sciencetific topics. I mention it here, because I originally wanted feature a GeekSpeak that I had found fascinating, even though it featured none of the regular hosts : http://geekspeak.org/shows/audio/GeekSpeak_2012-11-24.mp3?1354389765 "Hany Farid, Digital Image Detective with Robert Pollie of The 7th Avenue Project" Basically, Farid talked about the methods he uses to determine whether a digital image has been altered. Ultimately, since it was a re-broadcast of an earlier "7th Avenue Project", and not knowing the original licensing, I decided to bring you a more traditional and recent sample of GeekSpeak.

New hosts Welcome to our new hosts: pyrrhic, Al. Last Month's Shows Id Date Title Host 1631 2014-11-03 HPR Community News for October 2014 HPR Volunteers 1632 2014-11-04 5150 Shades of Beer: 0002 Wichita Brewing Company FiftyOneFifty 1633 2014-11-05 The OggCamp organizers beni 1634 2014-11-06 How I got into Linux pyrrhic 1635 2014-11-07 41 - LibreOffice Calc - Data Manipulation 1: Sorting and AutoFilter Ahuka 1636 2014-11-10 How I make coffee Dave Morriss 1637 2014-11-11 Communities Are Made of People FiftyOneFifty 1638 2014-11-12 Surviving A Roadtrip: Food Windigo 1639 2014-11-13 Ken Starks at Ohio Linux Fest 2014 Ahuka 1640 2014-11-14 Symmetric vs. Asymmetric Encryption Ahuka 1641 2014-11-17 The real reasons for using Linux

A running commentary by FiftyOneFifty and Tankenator on the nightlife in Elysburg PA

Since April last year the text-to-speech using eSpeak in the Raspberry Pi console has stuttered very badly and regularly crashes the kernel. Here's how I fixed it. Cloning my github repo: git clone https://github.com/cromarty/ttsprojects.git Installation: cd ttsprojects/raspberry-pi/libilctts/build sudo ./build.sh cd ../../piespeakup sudo ./build.sh Bingo! Speech should work. This has only just been released and there is still work to do on the documentation. Note: I am not connected to the Raspberry Pi Foundation in any way and anything I say or do is not endorsed by them. My email address is connected with a Freelists email list I set up and an accompanying web site: http://www.raspberryvi.org/ The 'VI' is for 'Visually Impaired' and I DID check with the Foundation about the similarity of the web address before I created it. To join our email list send an email to: raspberry-vi-request@freelists.org With 'subscribe' in the subject. Mike

Bash parameter manipulation I'm a great fan of using the Linux command line and enjoy writing shell scripts using the Bash shell. BASH (or more usually Bash or bash) is the name of a Unix shell. The name stands for Bourne Again SHell, which is a play on words. Bash is an extension of the shell originally written by Stephen Bourne in 1978, usually known as SH. Bash was written as part of the GNU Project which forms part of the Linux Operating System. A shell is the part of the operating system that interprets commands, more commonly known as the command line. A knowledge of Bash is very helpful if you would like to be able to use the power of the command line. It is also the way to learn how to build Bash scripts for automating the tasks you need to perform. In this episode we look at what parameters are in Bash, and how they can be created and manipulated. There are many features in Bash that you can use to do this, but they are not easy to find. As I was learning my way around Bash it took me a while to find these. Once I had found them I wanted to make a "cheat sheet" I could stick on the wall to remind me how to do things. I am sharing the result of this process with you. The version of Bash which I used for this episode is 4.3.30(1)-release The full notes for this episode are to be found here: http://hackerpublicradio.org/eps/hpr1648_full_notes.html Links Definitions: Unix shell http://en.wikipedia.org/wiki/Unix_shell Bash http://en.wikipedia.org/wiki/Bash_%28Unix_shell%29 GNU Project http://en.wikipedia.org/wiki/GNU_Project References Shell Parameter Expansion http://www.gnu.org/software/bash/manual/html_node/Shell-Parameter-Expansion.html Bash Hackers on parameter expansion http://wiki.bash-hackers.org/syntax/pe Previous HPR shows on the shell or shell scripting: 2008-03-03 HPR0045: Shell Scripting (dosman) http://hackerpublicradio.org/eps.php?id=45 2008-03-12 HPR0052: UCLUG: Newbie Shell Scripting (Dave Yates) http://hackerpublicradio.org/eps.php?id=52 2010-03-24 HPR0531: bash loops (Ken Fallon) http://hackerpublicradio.org/eps.php?id=531 2010-08-11 HPR0562: Introduction to bash scripting (Ken Fallon) http://hackerpublicradio.org/eps.php?id=562 2010-11-17 HPR0598: Bash Scripting: Episode 2 Command Line Basics (Ken Fallon) http://hackerpublicradio.org/eps.php?id=598 2012-05-22 HPR0992: Linux In The Shell 007 - Chmod and Unix Permissions. (Dann) http://hackerpublicradio.org/eps.php?id=992 2012-06-05 HPR1002: Linux In The Shell 008 - free: Understanding Linux Memory Usage (Dann) http://hacke

OggCast 2014. we cook dinner, I drink beer, a time is had by all. I'd like to amp this, but Audacity won't let me, so listen carefully. Broam, Briptastic, and FiftyOneFifty talk about the meal they are making for Saturday Night at Oggcast Planet Live 2014 from when they thought about it until dinner was served, as well as that day's fun at Knoebels theme park at Elysburg PA and the plans to visit the ghost town of Centralia the following day.

links http://wichitabrew.com/ http://www.rivercitybrewingco.com/ http://www.yelp.com/biz/bai-wei-asian-buffet-wichita

You can set a Standard Filter from within the AutoFilter drop-down, or you can go there through the Data menu by selecting Data>Filter>Standard Filter. Now lets look at the question we ended the last tutorial with: How many females over the age 40 had a case in 1978. We saw we could get this by manually putting checkmarks in every age that was greater than 40 using AutoFilter, but how do we do this using Standard Filter? - For more go to http://www.ahuka.com/?page_id=897 https://help.libreoffice.org/Common/List_of_Regular_Expressions http://www.ahuka.com/?attachment_id=909 http://www.ahuka.com/?page_id=897

In this episode Open source product development most effective when social Benetech started out in the 90s without even understanding the meaning of the term open source. They just "needed an easy way to interface with different voice synthesizers" to develop readers for people who are blind and "shared the code to be helpful." Sound familiar? Opensource.com started covering stories like in 2010 and they recur more often than you might think. Stories of people sharing the code to help others—but sharing code to get help developing better code. When code is open, a community has the opportunity to form around it. Read this interview about what Benetech CEO Jim Fruchterman learned by adopting open source philosophy and furthering technology-for-good. Read more: http://opensource.com/business/14/7/interview-jim-fruchterman-benetech OpenStack product management: wisdom or folly? Two recent, excellent, blog posts have touched on a topic I've been wrestling with since May's OpenStack Summit: What is the role of the Product Management function, if any, in the OpenStack development process? The first article, "Calling all 'User Landians' to lead OpenStack above the cloud," by Evan Scheessele, talks about the "real user" of OpenStack—those people that need to deliver a solution that brings some sort of value to their organization. The other article, "Who's In Charge Here Anyway?…," by Rob Hirschfeld, speaks to the dynamics of how decisions—which OpenStack features are in in or out—get made in the OpenStack ecosystem. Read more: http://opensource.com/business/14/7/openstack-product-management-wisdom-or-folly Giving Sub-Saharan African communities an online presence People in Sub-Saharan Africa face hurdles to get online. Despite some progress, the region lags behind in Internet connectivity due to the high costs of service and poor infrastructure, according to a recent World Economic Forum report. This digital divide means some African communities are underrepresented on the web. Without a well-developed online presence, misinformation about them can spread relatively unchallenged. Read more: http://opensource.com/life/14/7/giving-sub-saharan-african-communities-online-presence

Unison is a file syncing/backup utility, similar to SyncBack on Windows, available in most repros. The graphical interface requires the installation of unison, and unison-gtk.. Unison may be installed w/o the graphical component, but all operations must be initiated from a system running the GUI. Network backups require RSH or SSH to be installed on both machines The standard wisdom seems to be the rsync does not do a true 2 way sync, i.e., to sync to the newest file version going both ways you would have to do rsync ~/LocalFolder you@server:/home/you/RemoteFolder then turn around and do rsync you@server:/home/you/RemoteFolder ~/LocalFolder. Add that to the fact that like cp, or scp, rsync requires separate commands for files with extensions, files without, and hidden files, creating a bash script for syncing files is more complex than creating a Unison profile. Step One: If, like me you are syncing only Documents, make your subfolder structure the same on both machines, ergo, if one PC has /home/you/Documents/recipe and second PC has /home/you/Documents/Recipes, edit your folder structure to be the same on both PCs to avoid duplicate files and folders Launch Unison and create a backup profile First use, create a profile Name of profile Synchronization kind (Local, SSH, RSH, TCP) "First" Directory (you can browse your mounted volumes) "Second" Directory, if you chose Local Host Machine Name (or IP Address) User Name (If you haven't registered SSH keys, you will be prompted for a password on every synchronization. Check whether you want to use compression, (on fast networks or slow processors, compression may create more overhead than it's worth). Target directory (If it's on a remote server, you will need to type the full path, there is no browsing to the folder.) Tell Unison if either folder uses FAT (say an un-reformatted USB stick) If you are backing up to another system, Unison needs to be installed on both. If you are backing up to a server with no GUI desktop manager, you can install just the unison package without unison-gtk, but all the syncs will have to be initiated from the machine with a GUI. (Of course, if you back up to a remote volume that is mounted locally, it should be completely transparent to Unison). If you choose to sync via ssh (recommended), you will need ssh and ssh-server installed appropriately on each machine. Select and run your profile. The first time, expect to get a warning that no archive files (index files that speed up the synchronization scan) were found. They will be created on the first sync. Unison will look for differences between the files in the two selected directories. The differences will be displayed graphically, with arrows pointing left or right, indicating which directory contains the most current version of the file (by modification date). You can choose to merge files either left or right (a conventional backup), do a merge (i.e., Unison itself decides how to combine data from files with the same name (obviously, that could be messy), or to do a sync (ergo, the most current version of a file overwrites older version, regardless of location). Click "Go" to do a true sync.