Categories
PowerPoint Resource/Misc

Bandwidth Math and Connection Speed Needed

There are 5 Categories of Internet Connections:
1. 5+ Mbps = Very High Broadband
2. 1-5 Mbps = High Broadband
3. 786 Kbps = Fast Broadband
4. 384 Kbps = Standard Broadband
5. 56 Kbps = Dial-up

To figure the bandwidth a viewer will need to view the streaming media file with perfect playback, we need to work through these formulas (one for a Standard Web Server, one for a Streaming Server (note: Streaming Servers are overviewed a few posts from now).

A: Figuring Bandwidth Needs From A Standard Server. Here things are easy because we get to figure things directly in ‘bandwidth’ math using bits not bytes.
1. Figure “Bits Per Second”
Video Height x Video Width x Frame Rate (fps) = Bits/second (Kbps)
eg. (320 x 240 video dimensions) x 15 fps = 1,152,000 Bits/second

2. Convert Bits Per Second (Kbps) to Megabits Per Second (Mbps)
Bps (Total from #1) / 1,024 (1 Mbps = 1,024 Kbps) = Needed Connection Speed
eg. 1,152,000 Kbps / 1,024 = 1,125 Mbps (so the person watching should have a, category 2, high broadband connection)

B: Figuring Bandwidth Needs From A Streaming Media Server. Here there are a few extra steps because streaming servers encode everything in Bytes Per Second (Bps), which needs to then be converted to Kbps to know the bandwidth need.
1. Figure Total Bits Per Second
Video Height x Video Width x Frame Rate (fps) = Total Bits/second
eg. (320 x 240 video dimensions) x 15 fps) = 1,152,000 Bits/second

2. Figure the Bytes Per Second (Bps)
Bps (total from #1) / 8 = Bps (divide by 8 because there are 8 bits in 1 byte)
eg. ((320 x 240 x 15) / 8) = 144,000 Bps

3. Convert Bps to Kbps
Bps (total from #2) / 1,000 = Kilobytes/second (Kbps)
eg. 144,000 Bps / 1000 = 1,152Kbps (which is rounded to 1.2 Mbps)

Conclusion:
These formulas do not take into account your server’s bandwidth limitations, the number of simultaneous viewers, network congestion or a host of other variables. Now we know how to anticipate the needed connection speed for our streaming media.

Up next are some of the ways we can make a larger bandwidth file playback smooth on a low bandwidth connection.

– Troy @ TLC

Categories
PowerPoint Resource/Misc

Bandwidth Math and Estimating Monthly Bandwidth

Definition: Bandwidth is how much data you can move in a given amount of time.

Real-world: If your streaming media is too big for the connection of a viewer, they see choppy and incomplete playback.

The file-to-bandwidth ratio is important when you get into developing streaming media. So before beginning to develop streaming media, a bandwidth strategy is needed (or at least understood). The goal is to provide the quality needed, work with the viewers connection speed and not overload your hardware (the server).

1. The Bandwidth Math Numbers
The problem with “bandwidth math” is that two different sets of numbers are used. There is one for data transmission (Kbps) and another for data storage (KB ).

Files are measured in “KB” – kilobytes
Bandwidth is measured in “Kbps” – kilobits per second

Note that files use kiloBYTES and bandwidth uses kiloBITS (note one is “byte” and the other “bit”). Here is the trick – there are 8 bits in a byte. So when we have a 2MB streaming media file we are not transferring the 2,048KB (1MB = 1,024KB ), we are transferring 8x’s that much (2,048KB x 8 bits = 16,384Kbps).

2. Estimating Monthly Bandwidth:
This formula makes sure you stay within your hosting plans bandwidth allotment (usually hosting plans give bandwidth in GB per month – go over this amount and you risk additional charges or termination of your account). Here’s the formula:

(Average Daily Visitors x Average # Views x Average Media Size (in KB )) x 31 days x 1.5 (this is the “guesstimate” factor that gives a 50% buffer)

As example:
(40 daily visitors x 60 views x 20,480 KB (= 20 MB ) average media size) x 31 days x 1.5 = 2,285,568,000 KB
2,285,568,000 KB / 1,024 (1 MB ) = 2,232,000 MB, which is approx. 2 GB of bandwidth per month.

– Troy @ TLC

Categories
PowerPoint Resource/Misc

Media Players for Streaming Media

There are four common media players for streaming media to play with.
1. Windows Media Player
2. Flash
3. Quicktime
4. Real Player

See the September 1, 2006 post for an overview of the pro’s and con’s of each player.

All four have browser plug-ins that give a browser the ability to play the streaming media directly in the browser. Note: having the media player application installed does not necessarily mean its browser plug-in is installed. To further complicate things, not all plug-ins work the same in the various browsers. For example, a Windows Media file may not play the same in FireFox as it does in Internet Explorer, or it may playback in Quicktime on a Mac (using the Flip add-in). I personally find Flash to be the most universal format and usually my format of choice.

There are no fix-all solutions. Once you have developed the streaming media it is critical to test on multiple platforms and browser applications. Most important is to be aware of the potential issues – and at least inform viewers of them.

– Troy @ TLC

Categories
PowerPoint Resource/Misc

What is Streaming Media?

“Streaming” means part of a file is being played while the rest of it is downloading in the background. When you click “play” on a movie, webcast, or audio file initially a small portion of the file is downloaded. While the initial portion is playing, the next portion downloads in the background. The process continues until the entire file has been downloaded.

So the big question is how do you convert a PowerPoint presentation to a streaming format that downloads the fastest? No matter what software is used, or what format is chosen, the overall goal of creating streaming media is to throw away data that is not needed.

There are lots (and lots) of variables in how to decide what is thrown away, what software to use, what format to create, etc. First, there is no one answer or way to create the “best” streaming media. The reason is developing streaming media is all about compromises. How much data can be thrown away while maintaining needed quality? What is the needed playback size? What is the best format for the intended audience? What is the connection speed of the audience? Based on the answers to all of these questions we figure out what process to develop our streaming media in.

– Troy @ TLC

Categories
PowerPoint Resource/Misc

PowerPoint, Webcasts and Streaming Media

There is an explosion of activity around webcasts. This year I have had a ton of webcast projects – most involving PowerPoint content. The good news is PowerPoint once again finds itself at the center of the universe. The even better news is that software to make PowerPoint presentations web-ready are continuously being added to the mix. The bad news is most PowerPoint designers know very little about streaming media and are unprepared when the almost inevitable request to create a webcast from a presentation is put forth.

So there is at least one place to go and do a quick study of Streaming media/webcasts I have put together an eight part series on the topic. Check back as we cover all the behind-the-scenes “basics” about streaming media over the next week!

– Troy @ TLC

Categories
PowerPoint

PPT Viewer Splash Window

One of the greatest things about the 2003 PowerPoint Viewer is that it does not require administrative rights to install. As a matter a fact, it does not need to be installed at all. It can run from the computer or from a CDROM, USB drive, etc. But it is important to know that on the first use of it on a computer its splash screen, which shows the official EULA, will show up.

– Troy @ TLC

Categories
Personal PowerPoint

The PowerPoint Fairy

Here is a humorous little cartoon about “The PowerPoint Fairy” (and it may answer a few questions about unprepared presenters – the PowerPoint Fairy didn’t visit them before to the meeting).

Click here to view (sorry for the link, but respecting the website’s do-not-copy-my-images policy).

– Troy @ TLC

Categories
Personal PowerPoint

Stayn’ Alive with PowerPoint

Thanks to PPTMVP for finding this humorous YouTube video. The first part is a very creative (and simple) PowerPoint presentation – last part I could have done without…

For some quick entertainment check it out here.

– Troy @ TLC

Categories
PowerPoint

Flyody Landis Makes Case with PowerPoint

My neighbor (we live in the same town of 93,000 people) and fellow cyclist (he may ride a bit more than me), Floyd Landis rolled out key elements of his defense against doping charges in an online presentation Thursday, several months before the cyclist is to present his case to an arbitration panel in hopes of keeping his Tour de France title.

Early Thursday, Landis posted a PowerPoint presentation prepared by Arnie Baker, a retired doctor and longtime coach and adviser, as well as several hundred pages of documents related to the charges on his Web site, www.floydlandis.com (links to box.net, use PublicAccess/PublicAccess to login and download).

Many thanks to PPT MVP Glenna Shaw for letting me know about the neighborhood news.

– Troy @ TLC

Categories
PowerPoint

The Icons of Office 2007

After awhile you most likely just look through your list of applications for an icon vs. the name. So get ready to learn some new sights. Here are new application icons of Office 2007.

– Troy @ TLC