[ Pop captions up ]
Bill Jelen: GRAPHICALLY TRACK YOUR FORMULAS IN Excel TODAY ONTHE LAB. [ Pop captions down ] [ Theme music playing ] [ Pop captions up ]
Leo Laporte: HELLO. HOW ARE YOU? GOOD TO SEE YOU. AND WELCOME. THIS IS THETHE LAB. AND I AM LEO LAPORTE, AND WE'RE SO GLAD YOU'RE HERE TODAY. WE'RE GOING TO HAVE A GREAT TIME. GREAT GUESTS, LOTS OF INFORMATION, WONDERFUL CALLERS. LET'S START OFF - THIS IS EPISODE 38 - WITH CRAIG SYVERSON. [ Pop captions down ]
Leo: HE IS THE videogrunt. HE'S GOING TO TALK ABOUT GETTING YOUR PODCAST OR VIDEOCAST UP ON THE -- ONLINE. SO, iTunes CAN SUBSCRIBE AND PEOPLE CAN GET IT AND SO FORTH. KIND OF -- KIND OF THE BIG STEP. IT'S EASY TO PRODUCE IT. HOW DO WE NOW MAKE IT SO PEOPLE CAN SUBSCRIBE TO IT. MrExcel, AS YOU SAW, WILL BE HERE. HE'S GOING TO TALK ABOUT FORMULAS. AND TOD MAFFIN FROM THE CBC IS GOING TO TALK ABOUT AUDIO PODCASTING, MAKING IT SOUND VERY GOOD. LADIES AND GENTLEMEN, THE LOVELY KATE ABRAHAM.
Kate: HEY.
Leo: I FORGOT TO LOOK AT THE MEMO TODAY, BUT I GUESS WE DON'T CLASH TOO BADLY. [ Pop captions up ]
Kate Abraham: NO, WE'RE COMPLEMENTARY.
Leo: I'M BARBECUING AND YOU'RE BARBARELLA --
Kate: THERE YOU GO.
Leo: -- SO IT'S GREAT. I MEAN, IT WORKS.
Both: (laughing) [ Pop captions down ]
Leo: IT'S VERY FUTURISTIC, I THINK. DON'T YOU THINK?
Kate: THANK YOU.
Leo: YES. SHE LOOKS LIKE -- YES, ABSOLUTELY.
Kate: I HAVE THIS -- I HAVE IT IN PURPLE AS WELL.
Leo: DO YOU?
Kate: YES.
Leo: IT'S VERY CUTE. I LIKE THE BUCKLE. I THINK THAT'S GOOD.
Kate: A LITTLE OFF-CENTER.
Leo: YEAH. NO.
Kate: CHANGING IT UP FOR YOU. (laughing)
Leo: EXACTLY. WE'VE GOT -- WE'VE GOT A POSTCARD. THIS IS FROM ANGIE IN VANCHEP [sic], W.A. I DON'T -- I THINK THAT'S AUSTRALIA, RIGHT?
Kate: I THINK SO.
Leo: WESTERN AUSTRALIA, YEAH. SHE'S AN ARTIST. THIS IS HER WORK, AND SHE USES photocrossing.com [sic] AND SHE SAYS, "I SEND CARDS ALL OVER THE WORLD." SHE ALSO HAS AN ART GALLERY WHERE SHE SELLS WORK, HER OWN WORK. SO, THANK YOU, ANGIE, photocrossing.com FROM YANCHEP, WESTERN AUSTRALIA.
Kate: COOL.
Leo: ISN'T THAT NEAT? ISN'T THAT PRETTY?
Kate: THAT'S GREAT.
Leo: I'D HAVE TO LOOK AT photo-- photocrossing.com
Kate: I THINK SHE -- SHE EMAILED ME TO GET OUR ADDRESS, SO I THINK I --
Leo: SHE -- YOU GAVE HER THE ADDRESS.
Kate: YEAH, AND SHE GOT IT HERE.
Leo: YOU KNOW, E-MAIL KATE, SHE'LL GIVE YOU THE ADDRESS --
Kate: YEAH.
Leo: -- YOU CAN SEND US A POST-- I LOVE GETTING PICTURES AND POSTCARDS.
Kate: THAT WOULD BE GREAT ACTUALLY.
Leo: ANYTIME YOU WANT TO SEND US A PICTURE OF YOURSELF, YOUR DOG, YOUR SPOUSE, WHATEVER, YOUR COMPUTER, WE'D LOVE TO SEE -- SEE THAT. SO, WE HAVE SOME GOOD CALLS TODAY?
Kate: WE DO. WE DO.
Leo: BECAUSE I KNOW YOU'VE WOUND UP SOME -- OUR skype ISN'T WORKING.
Kate: RIGHT NOW, NO.
Leo: I DON'T UNDERSTAND WHAT HAPPENED.
Kate: I THINK --
Leo: YOU THINK I BROKE IT? I --
Kate: I THINK SO. (laughing)
Leo: COULD BE. I'M KNOWN FOR DOING THAT KIND OF THING.
Kate: I'M THINKING MAYBE YOUR CAMERA BROKE IT, BUT I DON'T KNOW.
Leo: YOU THINK? YOU THINK IT'S THE CAMERA?
Kate: POSSIBLY.
Leo: TOMMY TALLARICO CAM?
Kate: MM.
Leo: UH-OH. THE TOMMY CAM BROKE skype!
Kate: FINGERS CROSSED IT'S JUST A ONE-OFF I'M HOPING ANYWAY.
Leo: ALL RIGHT. WE'LL MOVE AND WORK SOMEWHERE ELSE --
Kate: YES.
Leo: -- ALL RIGHT.
Kate: SO, ON THE PHONE WE HAVE MARK FROM DIAMOND BAR IN CALIFORNIA.
Leo: WE'D LOVE TO SEE MARK, BUT WE CAN'T FOR SOME REASON. HELLO, MARK, HOW ARE YOU TODAY? [ Pop captions up ]
Mark: HELLO, LEO, AND I'M SO EXCITED TO SEE YOU GUYS. I HOPE I CAN SEE YOU GUYS HERE IN THE UNITED STATES ON HD SOMETIME SOON.
Leo: WE'RE WORKING ON IT. YOU KNOW, IT'S FUNNY BECAUSE WE SHOOT THE SHOW IN HIGH-DEF. IT'S CURRENTLY NOT AIRED IN HIGH-DEF, BUT WE'RE HOPING WE CAN FIND A U.S. DISTRIBUTOR WHO HAS HIGH-DEF. [ Pop captions down ]
Leo: THERE ARE A NUMBER, AS YOU KNOW, A NUMBER OF HIGH-DEF STATIONS IN THE U.S. SO, IF ANYBODY'S WATCHING AND WOULD LIKE TO SEE A 16 x 9 720p PERFECT CRYSTAL CLEAR RENDITION OF THIS FACE... YOU COULD. 1080i? NOT 720p? I THINK IT'S THE SAME. I DON'T THINK IT MATTERS. DOES IT MATTER? WELL, YOU KNOW WHAT, THE videogrunt CAN TELL US. HE'S HERE, CRAIG SYVERSON. MEANWHILE, MARK, WHAT CAN I DO FOR YOU?
Mark: WELL --
Leo: IT'S NOT THERE.
Mark: -- I HAVE A MacBook AND AN iMac AND I -- I'D LIKE TO EXTEND MY DESKTOP ON -- ONTO ANOTHER MONITOR USING, YOU KNOW, LIKE THE DVI ADAPTERS.
Leo: RIGHT.
Mark: NOW, I CAN'T FIGURE OUT HOW TO, LIKE, HAVE THE EXTERNAL MONITOR AS MY PRIMARY MONITOR WITH ALL THE -- THE DOCK AND --
Leo: I KNOW WHAT YOU'RE TALKING ABOUT.
Mark: -- THE MENUS AND EVERYTHING.
Leo: YEAH, BECAUSE THE PRIMARY MONITOR IS THE ONE WHERE THE MENU IS AND THE DOCK IS AND YOU -- YOU CAN'T ALWAYS HAVE IT -- BY -- NORMALLY IT'S THE ONE THAT -- THE FIRST ONE, RIGHT? BUT YOU'D LIKE IT TO BE THE EXTERNAL ONE. NORMALLY IT'S THE INTERNAL ONE. AND IF YOU -- IF YOU OPEN YOUR Display Contro-- YOU KNOW WHAT, I'M GOING TO LET YOU TO THIS, SEAN, BECAUSE SEAN SHOWED ME THIS THE OTHER WAY. HE SAID, "YOU KNOW THIS, OF COURSE." AND I SAID, "NO, AS A MATTER OF FACT, I DIDN'T KNOW THIS." IT'S -- IT'S IN THE Display Control Panel UNDER THE Arrangement TAB. NOW, SEAN'S GOING TO SHOW US. BECAUSE IF I DO IT, I'LL MESS UP MY DISPLAY, RIGHT?
Sean: YES, YOU WILL.
Leo: YEAH. SO, YOU OPEN THE Display SYSTEM PREFERENCE PANE.
Sean: MM-HMM.
Leo: YOU CLICK THE Arrangement TAB AND YOU WILL SEE YOUR TWO SCREENS THEN, RIGHT?
Sean: RIGHT. SO, YOU CAN SEE I'VE GOT -- ACTUALLY GOT THIS SECOND MONITOR OVER HERE SET UP AS MY SECONDARY DISPLAY. NICE AND BIG SO IT WOULD BE GREAT IF I WANTED TO USE IT AS EDITING -- AN EDITING WINDOW, BUT I WANTED TO USE THAT AS MY PRIMARY DISPLAY. YOU JUST GO INTO Displays FROM YOUR -- YOUR Control Panel IN System Preferences.
Leo: AND YOU SEE, BY THE WAY, BOTH MONITORS GET THEIR OWN DISPLAY WHICH --
Sean: RIGHT.
Leo: -- System Preference PANE WHICH APPLIES -- THE RESOLUTION APPLIES TO THE ONE --
Sean: RIGHT.
Leo: -- THAT IT'S ON, RIGHT?
Sean: AND SO YOU CAN DRAG THEM AROUND, ONE OR THE OTHER. WHAT YOU NEED TO DO IS YOU NEED TO HIT THE Arrangement WINDOW. OR THE Arrangement BUTTON.
Leo: NOW THERE YOU SEE YOUR TWO MONITORS THERE, YEAH.
Sean: AND YOU SEE YOUR TWO MONITORS. NOW, IT'S -- IT'S ACTUALLY REALLY VERY SIMPLE. ALL YOU HAVE TO DO IS LOOK FOR THIS LITTLE, TINY WHITE BAR AT THE TOP WHICH REPRESENTS THE -- THE BAR AT THE TOP OF YOUR SCREEN. (indiscernible)
Leo: IT'LL ONLY BE ON ONE OF THEM.
Sean: IT'LL ONLY BE ON ONE OF THEM AND YOU JUST GRAB IT --
Leo: (laughing)
Sean: -- AND MOVE IT TO THE OTHER ONE.
Leo: SO, THAT --
Sean: AND THEN IT'LL REFRESH AND NOW IT'S ALL OVER ON THE OTHER SIDE.
Leo: NOW THE MENU BAR IS ON THE LEFT, NOT ON THE RIGHT.
Sean: MM-HMM.
Leo: DID YOU FOLLOW THAT, MARK?
Mark: YUP, I GOT IT, I THINK.
Leo: IT'S SO SIMPLE.
Mark: WOW. (laughing)
Leo: AND YOU KNOW WHAT, I'VE BEEN USING A Mac SINCE 1984 AND (laughing) IT'S THE FIRST TIME -- I NEVER SAW THAT BEFORE AND SEAN SHOWED ME JUST THE OTHER DAY, SO IT'S KIND OF A COINCIDENCE THAT YOU CALLED AND ASKED ABOUT IT.
Mark: (laughing) WELL, WOW, THAT SOUNDS GREAT.
Leo: GOOD.
Mark: THANK YOU, SEAN, AND THANK YOU, LEO, AND EVERYBODY.
Leo: THAT WAS TOO EASY, WASN'T IT? (laughing)
Mark: (laughing)
Leo: CAN YOU COME UP WITH SOMETHING HARDER NEXT TIME? NO, NO, PLEASE DON'T. WE LOVE IT. THAT'S GOOD. EASY'S GOOD. EASY IS MUCH BETTER.
Mark: I'LL TRY SOMETHING HARD FOR NEXT TIME. WHEN YOU GET skype WORKING.
Leo: NO, THAT'S ALL RIGHT. HEY, I'M GLAD YOU -- I'M GLAD YOU CALLED. I HOPE WE CAN GET THE SHOW DOWN TO YOU. I HOPE YOU LISTEN TO THE RADIO SHOW.
Mark: OF COURSE I DO.
Leo: AND KFI IN BEAUTIFUL LOS ANGELES AND ALL OVER THE COUNTRY.
Mark: AND I'M IN THE CHAT ROOMS.
Leo: OH, GOOD! WHAT'S YOUR NAME IN THE CHAT ROOM?
Mark: I'M KUNG FU AZN, OR YOU SAY KUNG FU "AZN".
Leo: I NEVER KNOW HOW TO PRONOUNCE THAT. THAT'S KUNG FU ASIAN?
Mark: YES.
Leo: K-U-N-G-F-U-A-Z-N. I AM SO GLAD TO MEET YOU, MARK.
Mark: (indiscernible) NICE TALKING TO YOU.
Leo: ALL THIS TIME. WE'VE BEEN CHATTING TOGETHER FOR YEARS.
Mark: (laughing)
Leo: THANKS SO MUCH. IT'S GOOD TO HAVE YOU ON THE SHOW.
Mark: THANK YOU.
Leo: TAKE CARE. COMING UP, CRAIG SYVERSON. IT'S KIND OF FUN, ISN'T IT? YOU -- YOU MEET SOMEBODY ONLINE, YOU NEVER MEET THEM IN PERSON AND ALL OF A SUDDEN YOU -- YOU MEET THEM IT'S KIND OF -- KIND OF NEAT. CRAIG SYVERSON IS HERE. HE IS ONE OF MY GREAT FRIENDS. [ Pop captions up ]
Leo: HE IS THE videogrunt. THERE HE IS. HE'S HIDING. HE'S VERY SHY. HE -- IN JUST A LITTLE BIT (laughing) HE'S GOING TO SHOW US WHAT IT TAKES TO GET YOUR VIDEO OUT TO THE WORLD AS A POTTED CAST. STAY RIGHT HERE, THE LABCONTINUES RIGHT AFTER THIS. [ BLACK/COMMERCIAL ] [ Pop captions down ] [ Theme music playing ]
Leo Laporte: WELCOME BACK TOTHE LAB. OUR NEXT GUEST, CRAIG SYVERSON, A GOOD FRIEND. HE'S THE FOUNDER OF gruntmedia, WHICH IS A SILICON VALLEY-BASED NEW MEDIA COMPANY. HE DOES A NUMBER OF VIDEO PROGRAMS, ACTUALLY PODCASTS.
Craig: YES, MM-HMM.
Leo: THERE'S THE podgrunt, THE videogrunt. AND HE ALSO DOES CONSULTING AND CREATIVE SERVICES FOR PEOPLE WHO WANT TO GET IN THE BUSINESS, RIGHT?
Craig: AND this WEEK in MEDIA, A SPINOFF OF this WEEK in TECH.
Leo: WHO CAN FORGET this WEEK in MEDIA --
Craig: MM-HMM.
Leo: -- YOU'RE A REGULAR ON THOSE.
Craig: MM-HMM.
Leo: AND ALSO YOU DO VentureCast, RIGHT?
Craig: MM-HMM, YEAH.
Leo: YEAH. SO, CRAIG IS ALSO PROBABLY THE BEST GUY I'VE EVER SEEN U-- USING Keynote, WHICH IS THE PRESENTATION PROGRAM --
Craig: Keynote's AWESOME.
Leo: -- IN Macintosh.
Craig: YES.
Leo: IT REALLY IS.
Craig: YEAH.
Leo: WELL, Keynote MAY BE AWESOME, BUT YOU USE IT BETTER THAN ANYBODY ELSE I'VE SEEN.
Craig: AW, SHUCKS.
Leo: SO, WE'RE GOING TO LET YOU -- WE DON'T NORMALLY LET OUR -- OUR GUESTS USE PRESENTATION PROGRAMS, BUT YOURS ARE SO GOOD --
Craig: OH, REALLY?
Leo: YOURS ARE --
Craig: OHHH.
Leo: -- SO GOOD WE'RE GOING TO LET YOU DO THIS.
Craig: I FEEL SO PRIVILEGED.
Leo: (laughing) YOU'RE GOING TO SHOW US HOW TO GET YOUR VIDEO PODCAST OUT TO THE WORLD.
Craig: RIGHT. RIGHT.
Leo: YOU'VE ALREADY MADE IT.
Craig: YOU'VE ALREADY MADE IT AND THAT'S THE POINT.
Leo: IT'S DONE. [ Pop captions up ]
Craig Syverson: RIGHT. SO, A LOT OF VIDEO PROFESSIONALS UP THERE KNOW HOW TO MAKE PROGRAMS.
Leo: YEAH.
Craig: NOW, YOU SAID THAT WAS THE EASY PART. IT'S NOT THE EASY PART, OKAY?
Leo: MAYBE IT'S NOT EASY PART. [ Pop captions down ]
Craig: BUT --
Leo: BUT IT'S THE STUFF THEY UNDERSTAND.
Craig: THEY UNDERSTAND, RIGHT. SO, IT'S -- THE NEXT PART IS THIS MYSTERY OF HOW DO YOU GO TO THE NEXT STEP. SO --
Leo: RIGHT, RIGHT. I GET THIS TIME. PEOPLE SAY I'VE GOT A LOT OF CONTENT ON MY WEBPAGE. I'VE GOT VIDEO --
Craig: YEAH.
Leo: -- I'VE GOT AUDIO, BUT I DON'T UNDERSTAND WHAT MAKES IT A PODCAST?
Craig: RIGHT. WELL, PART OF WHAT PEOPLE DEFINE A PODCAST IS IS THE WAY IT'S DISTRIBUTED --
Leo: RIGHT.
Craig: -- WITH AN RSS FEED, BUT REALLY FOR ME A PODCAST OR THE DISTRIBUTED NEW MEDIA IS ABOUT THE VIEWING ON THE GO. IT'S ABOUT THINGS THAT ARE SMALLER. IT'S ABOUT SMALLER LENGTH OF PROGRAMS. IT'S COMPOSING THE SCREEN DIFFERENTLY, THINKING OF A SMALL SCREEN, RATHER THAN A BIG SCREEN. SO, ACTUALLY, IN PRODUCING VIDEO, THE PRODUCER DOES NEED TO TAKE A SLIGHTLY DIFFERENT APPROACH --
Leo: RIGHT.
Craig: -- IN HOW THEY ACTUALLY MAKE THE SCREEN.
Leo: WHEN WE FIRST SAW THE VIDEO iPod AND WE SAW HOW SMALL THAT SCREEN WAS.
Craig: YEAH.
Leo: AND OF COURSE I DO Talking Heads PROGRAMS.
Craig: YEAH.
Leo: I WENT, I TALKED TO ALEX LINDSAY, OUR MUTUAL FRIEND, AND I SAID, "ALEX, WE'RE GOING TO HAVE TO SHOOT EVERYTHING DIFFERENTLY. IT'S GOING TO HAVE TO BE TIGHT CLOSE-UPS. I -- I THINK IT SHOULD BE TALKING -- YOU KNOW, LITERALLY TALKING HEADS.
Craig: TALKING HEADS, YEAH, RIGHT.
Leo: IT SHOULD BE BIG HEAD VIDEO --
Craig: YEAH.
Leo: -- WHERE YOU'RE TIGHT ON THE FACE BECAUSE ON A LITTLE SCREEN IT'S NOT GOING TO BE SCARY.
Craig: MM-HMM.
Leo: WHEREAS ON A TELEVISION, IT MIGHT BE -- IF I GOT...
Craig: RIGHT.
Leo: YOU KNOW, IF I GOT THIS CLOSE, IT WOULD BE -- IT WOULD BE SCARY.
Craig: THAT'S SCARY.
Leo: YOU DON'T WANT THAT.
Craig: DON'T, DON'T. DON'T HURT THE AUDIENCE.
Leo: NO, I DON'T WANT TO HURT ANYBODY.
Craig: SO, THE Apple TV IS BRINGING UP SOME INTERESTING QUESTIONS.
Leo: THAT CHANGES THINGS, YEAH.
Craig: RIGHT. MY WHOLE POINT IS MY STUFF I WANT IT TO BE SMALL, BUT THAT'S ANOTHER -- THAT'S ANOTHER SUBJECT ALTOGETHER. BUT SO IN TERMS OF THE -- THE WORKFLOW IN ORDER IT DO THIS, I'LL TAKE TO YOU THIS -- THIS PRESENTATION THAT I DID THAT TALKS ABOUT KIND OF THE MAIN STEPS THAT ARE INVOLVED FROM SOUP TO NUTS OF HOW TO DO A PODCAST.
Leo: OKAY.
Craig: SO, THIS FIRST PART WE TALKED ABOUT, YOU KNOW, WORKING ON THE CONCEPT OF THIS SHOW AND ACTUALLY PRODUCING IT AND DOING POST-PRODUCTION, THESE ARE THE THINGS THE VIDEO PRODUCERS KNOW.
Leo: THAT'S DONE.
Craig: THAT'S DONE --
Leo: OKAY.
Craig: -- RIGHT? SO, NOW IT'S THIS NEXT SCARY PART OF HOW DO I --
Leo: YEAH.
Craig: -- COMPRESS IT AND HOW DO I GET IT UP ON THE WEB.
Leo: YEAH, NO KIDDING.
Craig: SO, I'M GOING TO GO THROUGH THIS QUICKLY TO GIVE PEOPLE AN OVERVIEW OF HOW THAT CAN BE DONE.
Leo: OKAY, GREAT. GREAT.
Craig: SO, LIKE, THE FIRST THING IS IT'S ABOUT COMPRESSION. AND, YOU KNOW, COMPRESSION IN AND OF ITSELF IS A DARK ART. THERE'S -- IT'S A -- IT'S A FORMULA. IT'S LIKE AN, YOU KNOW, ALL-CHEMICAL FORMULA OF HOW TO GET THE RIGHT DATA RATES --
Leo: RIGHT.
Craig: -- AND STUFF. AND VIDEO HAS DIFFERENT STANDARDS, SO YOU HAVE TO MAKE A DECISION DO I WANT FLASH AND Windows Media.
Leo: IT'S A LOT EASIER IN AUDIO, IT'S JUST MP3.
Craig: EXACTLY.
Leo: VIDEO, THERE'S NO MP3 FOR VIDEO.
Craig: IN A SENSE THERE ISN'T, RIGHT.
Leo: YEAH. [ Pop captions up ]
Craig: SO, IN A WAY YOU EITHER DECIDE TO DO THEM ALL --
Leo: RIGHT.
Craig: -- OR DO ONE.
Leo: RIGHT.
Craig: AND I'M THE ONLY DO ONE CAMP.
Leo: YOU BELIEVE IN DO ONE?
Craig: I'M IN THE DO ONE CAMP.
Leo: WHICH ONE DO YOU DO?
Craig: H.264.
Leo: THAT'S -- THAT'S -- AND SUPPORTED BY QuickTime AND Windows WILL SUPPORT IT SOON, I THINK Windows Media Player. [ Pop captions down ]
Craig: HOPEFULLY. AND --
Leo: YEAH.
Craig: -- Xbox 360 JUST ANNOUNCED --
Leo: YEAH.
Craig: -- SO. SO, IF WE LOOK AT THE, LIKE THE TYPICAL WORKFLOW OF -- OF PRODUCING A SHOW, YOU KNOW, THESE BOXES REPRESENT SORT OF THE AMOUNT OF DATA THAT ONE CREATES, ONE GENERATES WHEN MAKING --
Leo: RIGHT.
Craig: -- MAKING A SHOW. YOU HAVE YOUR FINAL OUTPUT. IF YOU DO EVERYTHING IN HIGH-DEFINITION FROM THE BEGINNING TO THE END, YOU WANT TO DO THAT. YOU WANT TO HAVE YOUR SHOW IN AS HIGH QUALITY AS POSSIBLE.
Leo: EVEN IF IT'S GOING TO END UP IN A LOW RES. MEDIUM.
Craig: IT DOESN'T MATTER.
Leo: LIKE AN iPod, YOU STILL WANT THE HIGH QUALITY.
Craig: YOU WANT THE HIGH QUALITY FOR A NUMBER OF REASONS, MOST OF IMPORTANT WHICH IS YOU NEVER KNOW WHAT'S GOING TO HAPPEN IN THE FUTURE.
Leo: RIGHT.
Craig: YOU COULD REPURPOSE IT.
Leo: RIGHT.
Craig: OR IT'S GOING TO BE BIGGER. OR Apple TV SHOWS UP --
Leo: RIGHT.
Craig: -- AND SUDDENLY YOU'RE GOING TO WANT TO HAVE THAT RESOLUTION.
Leo: OH, SUDDENLY I -- YOU KNOW, IF I'D HAD THAT HIGH-DEF, I COULD MAKE AN Apple TV VERSION.
Craig: RIGHT.
Leo: YEAH.
Craig: RIGHT. SO, YOU TAKE -- YOU HAVE YOUR -- YOUR HIGH RESOLUTION FILE AND THIS IS THE WORKLOAD I USE FOR videogrunt. SO, I HAVE -- I CREATE FROM Final Cut JUST A MASTER MOVIE FILE, WHICH IS JUST THE ENTIRE PROGRAM IN FULL RESOLUTION.
Leo: IT'S THE BEST QUALITY AND THAT'S THE ONE YOU'RE GOING TO WORK WITH FROM NOW ON.
Craig: YEAH, THAT'S MY STEM CELL I CALL IT.
Leo: (laughing) OKAY.
Craig: I CAN BUILD OTHER THINGS FROM THAT. THEN THAT FILE GETS THROWN INTO SOME COMPRESSION SOFTWARE.
Leo: WHAT DO YOU USE? DO YOU USE THE Final Cut COMPRESSION?
Craig: I DO.
Leo: YEAH.
Craig: I DO. AND I USE ANOTHER ONE WHICH I'M GOING TO SHOW YOU.
Leo: OKAY.
Craig: SO, THE COMPRESSION SOFTWARE WILL -- WILL GIVE YOU, YOU KNOW, WHATEVER TYPE OF OUTPUT YOU WANT.
Leo: FLASH, WMV --
Craig: RIGHT.
Leo: -- OR IN THIS CASE THE QuickTime FORMAT.
Craig: RIGHT. SO --
Leo: YOU LIKE H.264.
Craig: SO, I'M USING 264 --
Leo: YEAH.
Craig: -- BECAUSE I THINK IT'S BEAUTIFUL. AND YOU CAN USE COMPRESSOR, WHICH IS A PART OF THE Final Cut.
Leo: THAT COMES WITH Final Cut.
Craig: RIGHT. BUT I ACTUALLY USE THIS 10 DOLLAR PROGRAM --
Leo: CALLED COWBOY HAT.
Craig: -- CALLED COWBOY HAT. IT HAS --
Leo: IS IT REALLY?
Craig: NO.
Leo: (laughing)
Craig: BUT IT HAS, I HAVE TO SAY, A SOMEWHAT UNFORTUNATE NAME OF ViddyUp! NOW --
Leo: WOO!
Craig: YEAH.
Leo: WOO! ViddyUp! (laughing)
Craig: NOW, DESPITE THE NAME - AND IT'S A CUTE NAME, ALL RIGHT?
Leo: IT IS CUTE.
Craig: - IT REALLY WORKS WELL. [ Pop captions up ]
Craig: I REALLY LIKE THIS.
Leo: YOU'RE NOT GONNA FORGET IT.
Craig: YOU'RE NOT GONNA FORGET IT.
Leo: IT'S BETTER THAN COMPRESSOR BECAUSE THAT'S LIKE --
Craig: (in a digital-like voice) COMPRESSOR.
Leo: -- GENERIC.
Craig: YEAH, RIGHT. AND IT'S $10. AND IT DOES A REALLY, REALLY FINE JOB.
Leo: REALLY? [ Pop captions down ]
Craig: YEAH. I REALLY --
Leo: DO YOU HAVE TO HAVE QuickTime?
Craig: YOU DON'T HAVE TO HAVE QuickTime Pro EVEN --
Leo: WOW.
Craig: -- WHICH IS AN INTERESTING --
Leo: WOW, 10 BUCKS?
Craig: 10 DOLLA.
Leo: QuickTime Pro IS 40 BUCKS.
Craig: YEAH, BUT YOU'VE GOT TO GET QuickTime Pro ANYWAY. BUT THAT'S ON THE SIDE.
Leo: OKAY.
Craig: EVERYONE SHOULD GET QuickTime.
Leo: ViddyUP! EVERYBODY SHOULD GET TOO, OKAY.
Craig: NICE LITTLE APP.
Leo: AND THIS WILL CONVERT IT INTO H.264 OR OTHER FORMATS?
Craig: IT PRIMARILY FOCUSES ON THE --
Leo: H.2s, OKAY.
Craig: CASTS -- iPod AND THE Apple TV LEVELS.
Leo: OKAY.
Craig: THESE ARE MY SETTINGS AND I -- I PUT THIS IN HERE BECAUSE DON'T USE THESE. EVERYONE'S FORMULA IS DIFFERENT AND SO I CAN'T GIVE YOU AN ANSWER.
Leo: IT'S BASED ON THE CONTENT.
Craig: BASED ON THE CONTENT, HOW YOU'RE SHOOTING IT, EXACTLY RIGHT. SO, I CAN GET AWAY WITH A LOW DATA RATE BECAUSE THE WAY I CREATE videogrunt --
Leo: YOU HAVE A WHITE SCREEN BEHIND YOU.
Craig: I'VE GOT A WHITE SCREEN. I'M IN BLACK AND WHITE. I DON'T MOVE MUCH.
Leo: RIGHT.
Craig: MY -- I HAVE MOTION GRAPHICS FOR MOST OF THE SHOW.
Leo: BUT BY DOING THAT YOU GET A MUCH SMALLER FILE SIZE.
Craig: YES.
Leo: SO, THAT'S WHY YOU DO PAY ATTENTION TO THESE THINGS IN PRODUCTION AS WELL.
Craig: ABSOLUTELY --
Leo: YEAH.
Craig: -- AND THE STRATEGY FROM THE VERY BEGINNING.
Leo: YEAH.
Craig: SO --
Leo: 24 FRAMES A SECOND I NOTICE.
Craig: YES.
Leo: DOES THAT MAKE IT SMALLER?
Craig: IN A WAY.
Leo: I GUESS IT'S WHATEVER THAT IS, 6 FRAMES SMALLER, IT'S 20% SMALLER.
Craig: RIGHT, BUT I'M -- I'M REALLY ALSO JUST FOR TRYING TO BRING EVERYTHING TO A STANDARD OF 24.
Leo: AND THAT'S THE FILM STANDARD.
Craig: YEAH, THE FILM STANDARD, RIGHT.
Leo: NOT GO UP THE VIDEO STANDARD OF 30, BUT STAY WITH THE FILM STANDARD.
Craig: YEAH.
Leo: INTERESTING, OKAY.
Craig: YEAH, I LIKE THAT.
Leo: ALL RIGHT.
Craig: SO, I LIKE TO KIND OF BRING IT ALL TOGETHER DOWN TO ONE THING.
Leo: DO WHAT HE SAYS THOUGH. THIS GUY HAS -- I MEAN, HE'S BEEN THERE, HE'S DONE THAT, HE KNOWS.
Craig: SO --
Leo: I -- YOU KNOW, I WOULD JUST -- YOU KNOW, UNLESS YOU HAVE A REALLY GOOD REASON NOT TO DO WHAT CRAIG SAYS, DO WHAT HE SAYS.
Craig: I ALWAYS SAY THAT.
Leo: YEAH.
Craig: I TELL PEOPLE THAT ALL THE TIME.
Leo: THAT'S WHAT I DO.
Craig: YEAH. I'M GLAD YOU LISTEN.
Leo: NOW WE'RE GOING TO TALK ABOUT IDENTITY.
Craig: IDENTITY.
Leo: IDENTITY.
Craig: NOW --
Leo: HARD TO SAY, HARDER TO DO.
Craig: EVEN HARDER TO DO.
Leo: YEAH.
Craig: BUT IT -- IT'S SORT OF THE, THE -- SOME PEOPLE THINK WHY DO YOU BOTHER WITH TALKING ABOUT THIS, BUT ACTUALLY BECAUSE THE PODCAST FILES HAVE A LOT OF METADATA ASSOCIATED WITH THEM, YOU CAN REALLY LEVERAGE THAT. AND I'M SAYING PUTTING THE "O" IN SEO, IN SEARCH ENGINE OPTIMIZATION. YOU CAN PUT DATA IN YOUR -- WITH YOUR VIDEO FILES TO HELP PEOPLE FIND A LAYER. SO --
Leo: I COMPLETELY AGREE WITH YOU, YEAH.
Craig: RIGHT. SO, IT'S VERY IMPORTANT TO -- TO NOT ONLY CREATE A BEAUTIFUL PROGRAM, BUT TO PROFESSIONALLY WRAP IT UP AND PUT IT --
Leo: I USE A VERY STANDARD NAMING CONVENTION --
Craig: MM-HMM.
Leo: -- SO YOU COULD FIGURE OUT WHAT THE NAME OF THE NEXT SHOW IS.
Craig: YEAH.
Leo: AND IT TELLS YOU A LOT ABOUT THE SHOW. I USE MP3 TAGS OR --
Craig: ID3.
Leo: -- I GUESS IN VIDEO IT'S DIFFERENT, THE ID3 TAGS, VERY CAREFULLY --
Craig: MM-HMM.
Leo: -- TO MAKE SURE THAT THAT HAS THE INFORMATION PEOPLE NEED.
Craig: YEAH, YEAH.
Leo: AND I NOTICE YOU USE (indiscernible) AS WELL --
Craig: YEAH.
Leo: -- AND YOU PUT THAT IN A --
Craig: YES.
Leo: YEAH.
Craig: ABSOLUTELY.
Leo: YEAH.
Craig: NOW, THE ID3 -- ID3 TAGS DO GO WITH VIDEO, AS WELL AS AUDIO.
Leo: SO, YOU CAN -- OH, I DIDN'T KNOW THAT.
Craig: YEAH. THEY'RE JUST METADATA FIELDS ASSOCIATED WITH --
Leo: OH, OKAY.
Craig: -- THE ACTUAL VIDEO FILE.
Leo: OKAY. GREAT, OKAY.
Craig: SO, I'LL GO THROUGH THIS QUICKLY, BUT, LIKE YOU WERE SAYING, YOU HAVE TO THINK CONSISTENTLY ABOUT HOW YOU NAME THINGS.
Leo: RIGHT.
Craig: YOU HAVE TO UNDERSTAND THAT, YOU KNOW, BE CAREFUL WITH YOUR SPACES.
Leo: RIGHT.
Craig: USE LEADING ZEROS. BECAUSE WHEN THESE THINGS SHOW UP IN A LIST, YOU WANT THEM TO LOOK ORGANIZED.
Leo: AND YOU DO -- AND I'LL TELL YOU, Apple'S iTunes, WHICH MOST PEOPLE ARE GOING TO BE USING --
Craig: YES.
Leo: -- CHANGES YOUR NAMES. SO, YOU MIGHT WANT TO LOOK AT HOW Apple PARSES THE INFORMATION YOU'RE GIVING IT --
Craig: YES.
Leo: -- SO THAT THE RESULT, AND I HAVE TO SAY I SPEND A LOT OF TIME WITH THIS --
Craig: YEAH, YEAH.
Leo: -- ON THE iPod LOOKS LIKE WHAT YOU EXPECT.
Craig: EXACTLY.
Leo: BECAUSE IT WON'T IF YOU JUST DO WHAT YOU THINK.
Craig: PRECISELY.
Leo: YEAH.
Craig: BECAUSE -- SO, THERE'S A LOT INVOLVED HERE AND I'M NOT GOING TO INTO IT BECAUSE I COULD SPEND HOURS TALKING ABOUT THIS --
Leo: YEAH, YEAH.
Craig: -- YOU KNOW.
Leo: IT'S A FASCINATING SUBJECT.
Craig: YEAH. SO --
Leo: FOR SOME PEOPLE.
Craig: YEAH.
Leo: (laughing)
Craig: AND AS WE WAKE UP
Leo: (nerdy voice) NAMING CONVENTIONS.
Craig: (nerdy Voice) IT'S REALLY, REALLY IMPORTANT.
Leo: VERY IMPORTANT.
Craig: YOU'VE GOT TO DO IT, OKAY?
Leo: YEAH.
Craig: JUST -- JUST DO IT.
Leo: (laughing)
Craig: SO, NEXT IS THE -- IS THE TRICKY PART, IT'S THE FEED. YOU KNOW, HOW DO YOU GET THING UP --
Leo: YEAH.
Craig: -- UP ON THE RSS FEED.
Leo: YEAH, THIS CONFUSES A LOT OF PEOPLE.
Craig: RIGHT. SO, YOU HAVE TO BUILD AN R-- YOU HAVE TO BUILD THE RSS FILE. AND, YOU KNOW, IT'S -- IT'S A SCARY BIT OF CODE FOR SOMEONE LIKE ME. IT'S LIKE I DON'T KNOW ANYTHING ABOUT THAT.
Leo: YEAH, I USE A PROGRAM CALLED Feeder FROM Reinvented Software --
Craig: UH-HUH, GREAT PROGRAM.
Leo: -- THAT WILL KIND OF USE IT FOR YOU.
Craig: YES, RIGHT.
Leo: WHAT DO YOU USE?
Craig: I USE Podcast Maker.
Leo: AH, THAT'S A GREAT PROGRAM.
Craig: AND I'LL SHOW YOU RIGHT NOW.
Leo: SHOW US Podcast Maker, CRAIG SYVERSON. (laughing)
Craig: WELL, I'M GLAD YOU ASKED, LEO. SO, Podcast Maker IS A GREAT LITTLE APP.
Leo: IT COMES IN A LITTLE CAN.
Craig: IT COMES IN A CAN. [ Pop captions up ]
Craig: YOU PAY 30 BUCKS FOR IT.
Leo: IT IS WORTH THE MONEY.
Craig: I --
Leo: THIS ALSO ALLOWS YOU TO MAKE ENHANCED AUDIO PODCASTS --
Craig: YES.
Leo: -- WHICH IS GREAT.
Craig: YES.
Leo: YEAH.
Craig: IT HAS A VERY NICE ENHANCED WHICH I USE FOR VentureCast. I USE --
Leo: MM-HMM.
Craig: -- I CREATED HERE. [ Pop captions down ]
Craig: THESE ARE JUST SOME SCREENS TO -- TO SHOW HOW NICE AND EASY IT IS TO SET UP. BUT HERE'S -- HERE'S THE KICKER PART IS WHEN I NOW ACTUALLY AM GOING TO POST MY FILE TO --
Leo: YOU JUST PUSH A BUTTON.
Craig: I PUSH A BUTTON. AND HERE'S WHAT HAPPENS BEHIND THE MAGIC CURTAIN. SO, HERE I AM, I'M USING, I'VE GOT MY MOVIE FILE AND Podcast Maker. AND I'M GOING TO UPLOAD MY FILES TO CacheFly.
Leo: RIGHT. THIS IS YOUR HOST.
Craig: THIS IS MY HOST FOR MY FILES.
Leo: RIGHT.
Craig: AND, YOU KNOW, FULL DISCLOSURE. THEY'RE A SPONSOR OF MINE, BUT I STARTED WITH THEM BEFORE THEY WERE --
Leo: RIGHT.
Craig: -- BECAUSE THEY WERE REALLY --
Leo: I ALSO USE THEM.
Craig: YES.
Leo: YEAH.
Craig: THEY'RE A GREAT SERVICE. REALLY, REALLY FAST. SO, NOW I HAVE MY RSS FEED AND MY MOVIE FILE IN CacheFly. THEN WHAT I DID IS I CREATED A FeedBurner ACCOUNT. AND SAID, FeedBurner, POINT TO THIS RSS FILE, IN CacheFly.
Leo: AND THIS IS A FREE SERVICE THAT --
Craig: YES.
Leo: -- DOES YOUR -- MAKES IT A GOOD FEED.
Craig: YES.
Leo: YEAH, YEAH.
Craig: MAKES IT A GOOD FEED. AND WHAT THAT GIVES ME IS THIS MAGIC ADDRESS OF feeds.feedburner.com/ --
Leo: THAT'S WHAT YOU GIVE iTunes.
Craig: YES.
Leo: YOU MAY EVEN GIVE YOUR USERS IF THEY HAVE A DIFFERENT CLIENT, BUT REALLY iTunes IS THE BEST WAY TO DO THIS.
Craig: IT KEEPS IT CONSISTENT. AND THAT'S -- AND THAT'S WHAT I'M SHOWING HERE. SO, WHEN I GO WITH iTunes AND I TELL iTunes TO, ON THE PODCAST DIRECTORY TO LISTEN TO MY SHOW, I HAVE A POINT TO FeedBurner. SO, WHEN MY AUDIENCE WANTS TO GET MY SHOW, THEY GO TO iTunes, WHICH POINTS TO FeedBurner, WHICH --
Leo: WHICH POINT TO THAT, POINTS TO THAT.
Craig: -- POINTS TO CacheFly, WHICH THEN SENDS THE FILE DOWN TO THE -- TO THE USER.
Leo: IT'S LIKE MAGIC, BUT OF COURSE CRAIG SYVERSON MAKES IT SO EASY. ALL THE DETAILS ON OUR WEBSITE, THERE'S MORE.
Craig: MM-HMM.
Leo: WE DIDN'T GET TO IT ALL, BUT labwithleo.com HAS IT ALL. [ Pop captions up ]
Leo: AND OF COURSE, IF YOU EVER GET A CHANCE TO SEE CRAIG DO HIS STUFF, PLEASE GO. OR JUST SUBSCRIBE TO videogrunt --
Craig: MM-HMM.
Leo: -- WHICH IS HIS PODCAST THAT TALKS ABOUT ALL THIS IN GREAT DETAIL. OR podgrunt OR DO YOU HAVE ANY OTHER GRUNTS?
Craig: gruntmedia.com IS THE WEBSITE WHERE ALL --
Leo: IT'S ALL THERE.
Craig: WHERE THEY ALL SHOW UP.
Leo: ALL THERE. CRAIG'S THE GREATEST AND I'M SO GLAD YOU WERE HERE TO EXPLAIN THIS --
Craig: I'M GLAD TO BE HERE.
Leo: -- BECAUSE I -- BETTER YOU THAN ME. RIGHT NOW WE'RE GOING TO TAKE -- BECAUSE I DON'T UNDERSTAND HOW THIS STUFFS WORKS AT ALL. [ Pop captions down ]
Leo: RIGHT NOW WE'RE GOING TO TAKE A CLOSE-UP LOOK OF SOMETHING COMMONLY FOUND AROUND THE LAB. IT LOOKS LIKE A HOLE. IS THAT WHERE THE MOUSE IS GETTING IN? I THINK IT IS. WHAT COULD THAT BE? TELL YOU WHAT, WE'LL ZOOM OUT AND FIND OUT WHEN THE LABCONTINUES. [ Music ] [ BLACK/COMMERCIAL ] [ Pop captions down ]
Leo Laporte: WELCOME BACK TOTHE LAB WITH LEO. BEFORE THE BREAK WE SHOWED YOU THIS CLOSE-UP OF SOMETHIN'. I SWEAR I THINK THAT'S WHERE THE RAT'S BEEN GETTING IN. [ Pop captions up ]
Leo: BUT, NO, LET'S ZOOM OUT AND YOU SEE IT'S NOT, UNLESS IT'S A VERY, VERY TINY RODENT. IT'S OUR SWING LINE. (nerdy voice) UM, I THINK YOU HAVE MY STAPLER. [ Pop captions down ]
Sean: (indiscernible)
Leo: THAT'S MY STAPLER? DID YOU STEAL MY STAPLER? (normal voice) IT'S SEAN CARRUTHERS. HE'S THE GUY WHO ZOOMS INTO THOSE, DOES THOSE REALLY FUN CLOSE-UPS OF what the tech? LET'S GET ANOTHER CALLER ON THE AIR, SHALL WE? THE LOVELY KATE HAS SOMEBODY FOR US. IT LOOKS LIKE --
Kate: WE --
Leo: LOOK AT THAT SMILE.
Kate: WE HAVE TOM FROM ENCINO IN CALIFORNIA.
Leo: HEY, TOM, HOW ARE YA?
Tom: GOOD, LEO. HOW ARE YOU?
Leo: THE SECOND SOUTHERN CALIFORNIA CALLER AND WE'RE NOT EVEN SEEN IN SOUTHERN CALIFORNIA. I DON'T UNDERSTAND HOW IT'S HAPPENING.
Tom: WELL, I HEAR YOU EVERY WEEKEND --
Leo: THAT'S --
Tom: -- ON A SYNDICATED SHOW. [ Pop captions up ]
Leo: I THINK -- I THINK I HAD THAT FEELING IT'S FROM KFI. WELL, IT'S NICE TO TALK TO YOU, TOM. WHAT CAN I DO FOR YOU?
Tom: GOT IT. OKAY, UM, I HAVE TWO GIRLS THAT ARE, YOU KNOW, AT HOME AND THEY EACH HAVE COMPUTERS.
Leo: UH-HUH.
Tom: THEY'RE 8 AND 10. AND ONE OF THEM, PARTICULARLY THE OLDER ONE, IS BUGGING ME FOR E-MAIL.
Leo: OOH.
Tom: AND THE OTHER ONE -- BOTH OF THEM ARE ACTUALLY ON THE INTERNET A LOT, SO I'M GETTING A LITTLE PARANOID AS THEY GET OLDER AND MORE SAVVY AS TO --
Leo: ABSOLUTELY.
Tom: -- UM, WHAT WEBSITES I CAN LIMIT THEM ON IN -- IN Internet Explorer 6.0.
Leo: WELL, THERE'S A COUPLE THINGS YOU COULD DO.
Tom: (indiscernible) WHAT?
Leo: THERE'S A COUPLE THINGS YOU COULD DO. [ Pop captions up ]
Leo: AND BY THE WAY, I COMPLETELY AGREE WITH YOU, ESPECIALLY WITH E-MAIL BECAUSE E-MAIL, YOU KNOW, I CAN FIGHT ALL THE SPAM YOU WANT BUT SOMETHING'S GOING TO GET THROUGH AND IT'S GOING TO BE SOMETHING HORRENDOUS AND YOU DON'T WANT A 9 YEAR OLD TO SEE THAT. I DON'T WANT TO SEE IT. [ Pop captions down ]
Leo: MY WIFE -- MY WIFE CAME IN THE OTHER DAY, SHE ACTUALLY FORWARD THIS HAD TO ME AND SHE SAID, "WHAT IS THIS? THIS CAME UNTIL MY E-MAIL. THIS IS AWFUL!" AND I SAID, "HONEY, THAT'S SPAM. WE ALL GET IT." YOU KNOW, AND I FILTER VERY, VERY HEAVILY, BUT YOU CAN'T KEEP IT ALL OUT. SO, WHAT -- WHAT I REALLY THINK THE BEST WAY TO DO IT WITH BOTH THE -- WITH REALLY YOUNG KIDS LIKE THIS, BOTH ON THE INTERNET AND BOTH E-MAIL IS -- IS KIND OF A OPT IN FORM OF SURFING. IN OTHER WORDS, INSTEAD OF TRYING TO BLOCK SITES OR BLOCK SPAM, YOU SAY ONLY E-MAIL FROM THESE PEOPLE, ONLY THESE PARTICULAR SITES.
Tom: AND HOW DO I ACHIEVE THAT? HOW DO I MAKE IT HAPPEN?
Leo: IN Internet Explorer IT'S FAIRLY SIMPLE TO DO. YOU CAN DO IT IN THE Internet Options. YOU CAN ACTUALLY JUST SAY NO SITES UNLESS EXCEPT THESE SITES. SO, YOU GO INTO Security AND YOU CAN ACTUALLY SAY, YOU KNOW, INTERNET, YOU TURN THE SECURITY LEVEL ALL THE WAY UP.
Tom: OKAY.
Leo: AND YOU COULD EVEN SAY -- LET'S SEE, I'M IN -- LET ME SEE IF I CAN FIGURE THIS OUT. INTERNET. WE'LL DO CUSTOM LEVEL. YOU BLOCK -- BASICALLY YOU BLOCK EVERYTHING AND THEN INCLUDING SURFING ON THE -- ON THE OPEN NET. AND THEN WHAT YOU'LL DO IS YOU'LL ADD INDIVIDUAL SITES TO TRUSTED SITES. SO, FOR INSTANCE, YOU COULD SAY, WELL, I'M GOING TO ALLOW THEM TO GO TO Yahooligans BECAUSE THAT'S A GREAT Yahoo! SITE FOR KIDS. OR I MIGHT LET THEM GO TO Disney-- AND YOU SLOWLY ADD THESE SITES, RIGHT. OH, I FORGOT https. SO, BY ADDING THESE SITES -- AND YOU COULD TURN OFF SERVER VERIFICATION. BY ADDING THESE SITES YOU'RE SAYING EFFECTIVELY THEY CAN ONLY GO TO THESE SITES. I'VE BLOCKED THE INTERNET ON THIS COMPUTER EXCEPT FOR THESE FIVE SITES.
Tom: OKAY.
Leo: AND IF THEY --
Tom: SO, HOW DO I DO THIS? I NAVIGATE TO OPTION Security?
Leo: IT'S Internet Properties. UNDER THE Security TAB YOU'RE GOING TO SET A CUSTOM SECURITY LEVEL WHICH BASICALLY BLOCKS EVERYTHING, OKAY?
Tom: OKAY.
Leo: DISABLE EVERYTHING. AND I THINK SOMEWHERE IN HERE WE'LL BE ABLE TO BLOCK ALL WEBSITES HERE. IT'S, IT'S -- YOU KNOW, IF YOU LOOK AT ALL THESE, JUST DISABLE EVERYTHING. AND, YOU KNOW, BASICALLY YOU WON'T BE ABLE TO GO ON THE NET UNLESS IT'S A TRUSTED SITE.
Tom: OKAY.
Leo: AND THEN YOU ADD THE SPECIFIC SITES THAT YOU WANT. SO, THAT --
Tom: OKAY.
Leo: I THINK FOR A KID THAT'S THE -- NOW, AS THEY GET OLDER THAT'S NOT GOING TO WORK. BECAUSE THEY'RE GOING TO -- YOU KNOW, THEY'RE GOING TO SAY, "DAD, I CAN ONLY GO TO FOUR SITES," RIGHT?
Tom: BUT THEY'RE NOT. THEY'RE AGES -- THEY'RE DOING RESEARCH FOR SCHOOL ON -- ON
Leo: RIGHT.
Tom: -- CERTAIN SITES.
Leo: OF COURSE THEY ARE. BUT YOU -- YOU KNOW, YOU CAN -- AND -- AND WHAT WILL HAPPEN, MY KIDS WILL SAY, WELL, DAD, CAN YOU ENABLE THIS SITE, CAN YOU EN-- AND YOU -- SO, YOU'LL -- YOU KNOW, YOU'LL GET A LITTLE BIT MORE BUSINESS, BUT IT'S, IT'S -- IT'S ABSOLUTELY SECURE. BUT THE PROBLEM WITH A FILTER, I COULD TELL YOU A FILTER LIKE CyberPatrol, THEY'RE NOT PERFECT AND YOU'RE GOING TO GET STUFF -- SOME STUFF'S GOING TO COME THROUGH THAT YOU DON'T WANT. AND, SOME SITES THAT YOU THINK THEY SHOULD BE ABLE TO GET THROUGH THEY WON'T. AND -- AND NO -- AND THERE'S NO SUBSTITUTE FOR YOUR INVOLVEMENT, FRANKLY.
Tom: OKAY.
Leo: AND I THINK THAT FOR YOUNGEST KIDS, GIVING THEM CERTAIN SITES THEY CAN GO TO. YOU CAN DO THE SAME THING WITH E-MAIL. THERE ARE A NUMBER OF SERVICES. THIS IS ONE CALLED kidmail, kidmail.net [ Pop captions up ]
Leo: SAME IDEA. IF SOMEBODY WANTS TO SEND THEM E-MAIL, IT HAS TO GO THROUGH YOU FIRST. SO, LET'S SAY, YOU KNOW, MY BUDDY JANE WANTS TO HAVE E-MAIL OR GRANDMA WANTS TO HAVE E-MAIL. YOU APPROVE THEIR ADDRESS. ONLY THEY CAN MAIL TO YOUR KIDS AND ON-- AND YOUR KIDS CAN ONLY SEND E-MAIL TO THEM.
Tom: OKAY.
Leo: SO, YOU DON'T HAVE TO WORRY ABOUT SPAM FILTERING OR ANYTHING. [ Pop captions down ]
Leo: IT -- IT MEANS THAT THEY'RE ONLY TALKING TO THOSE PEOPLE THAT YOU'VE SPECIFICALLY APPROVED. IT'S --
Tom: IS THAT -- I'M SORRY, IS THAT SOMEHOW LINKED TO Explorer?
Leo: NO, THIS IS -- THIS IS A PAY SERVICE. IT'S ABOUT 5 BUCKS, I -- OR -- OR LESS. $2.50 A MONTH IF YOU BUY A YEAR FOR YOUR WHOLE FAMILY. SO, IT'S NOT VERY EXPENSIVE. AND IT ALLOWS THEM TO USE Outlook, BY THE WAY, IF YOU STILL WANT THEM TO USE Outlook. OR THEY HAVE -- THEY HAVE THEIR OWN KID MAIL PROGRAM FOR LITTLE KIDS. BASICALLY IT'S DESIGNED TO HAVE YOUNGER KIDS, AS WELL AS OLDER KIDS. I THINK IT'S ACTUALLY A VERY COOL SERVICE, BUT THERE ARE A NUMBER OF THEM LIKE THIS IF YOU -- IF YOU SEARCH FOR IT. YOU COULD TRY IT FOR FREE AND THAT WOULD BE MY RECOMMENDATION. IT'S kidmail.net AND IT'S AN OPT-IN SERVICE. AND THAT'S WHAT I -- THAT'S -- I THINK FOR THE YOUNGER KIDS, INSTEAD OF FILTERING, NO SP-- YOU KNOW, NO MATTER HOW GOOD YOUR SPAM FILTERING, YOU KNOW THIS, SOMETHING'S GOING TO GET THROUGH. INSTEAD OF TRYING TO FILTER SPAM OR FILTER E-MAIL OR FILTER WEBSITES, GIVE THEM, YOU KNOW, A CHOICE. SAY THIS IS THE ONLY SITE YOU CAN GO TO. THIS IS THE ONLY E-MAIL YOU CAN SEND AND RECEIVE. AND I THINK THAT FOR YOUNGER KIDS THAT'S THE BEST WAY YOU CAN DO IT. THAT'S THE ONLY WAY YOU CAN ACTUALLY SUCCESSFULLY KEEP THE BAD GUYS OUT. NOW, AS THEY GET OLDER, THEY'RE GOING TO -- THEY'RE GOING TO WANT SOME MORE FREEDOM AND YOU CAN SLOWLY ADD THAT. THAT'S WHY IT'S SO IMPORTANT TO TALK TO YOUR KIDS ABOUT THIS ANYWAY, TO HAVE AN INTERACTION WITH THEM TO MAKE SURE THAT THEY UNDERSTAND WHAT YOUR VALUES ARE AND THAT THEY COMMUNICATE WITH YOU. YOU WANT TO MAKE SURE YOU HAVE THAT COMMUNICATION. NOTHING - NOTHING WORKS SO WELL THAT YOU COULD WALK AWAY FROM IT. YOU WANT TO BE PART OF THIS WITH THEM. BUT I THINK ABSOLUTELY PARENTS NEED HELP DOING THIS RIGHT NOW. [ Pop captions up ]
Leo: HEY, COMING UP IN JUST A BIT, FROM THE CBC, TOD MAFFIN. HE IS -- HE IS GOING TO TALK ABOUT BETTER AUDIO FOR YOUR PODCASTS OR ANYTHING YOU WANT TO DO ON THE NET WITH AUDIO. YOU STICK AROUND, WE'RE GOING TO DO MORE WITHTHE LAB \AIITH LEOIN JUST A BIT. [ Pop captions down ]
Leo: BUT BEFORE YOU GO AWAY, ONE MORE CHANCE -- ACTUALLY, YOUR FIRST CHANCE TO TAKE OUR QUICK QUIZ QUESTION OF THE DAY. WHICH OF THESE SPREADSHEET PROGRAMS WAS FIRST AVAILABLE? I THINK I KNOW THIS ONE. WAS IT Lotus 1-2-3, Microsoft Excel, VisiCalc, OR YewellCalc 2-4-8? (laughing) I THINK WE CAN ELIMINATE THAT. GO TO THE WEBSITE, THINK ABOUT IT, DO SOME RESEARCH. CHECK Wikipedia, WHATEVER IT IS YOU NEED. THERE'S NO -- NO WAY YOU CANNOT -- I MEAN, YOU CAN CHEAT ON THIS, IT'S OKAY. WE'LL TALK ABOUT IT A LITTLE LATER ON AS THE SHOW CONTINUES. [ Music ] [ BLACK/COMMERCIAL ] [ Pop captions down ] [ Theme music playing ]
Leo Laporte: WELCOME BACK TOTHE LAB WITH LEO, LADIES AND GENTLEMEN. TOD MAFFIN IS HERE. HE'S THE National Tech COLUMNIST FOR CBC, THE CANADIAN BROADCASTING COMPANY. AND HE IS GOING TO SHOW US HOW TO MAKE BETTER SOUND.
Tod: BETTER SOUND WITH PODCASTING.
Leo: CBC QUALITY.
Tod: WELL, I DON'T KNOW ABOUT THAT BECAUSE, YOU KNOW, THAT COSTS ABOUT MAYBE A BUCK AND A HALF ON A GOOD DAY.
Leo: (laughing) [ Pop captions up ]
Tod Maffin: OF COURSE I HAVE BROUGHT MY OWN -- YOU KNOW, WE HAD BROUGHT CRAIG IN EARLIER ABOUT THE OTHER PODCAST --
Leo: YEAH.
Tod: -- OF PRODUCTION. HE HAD HIS OWN VERY FANCY FLOWCHART ON HOW HE MAKES A PODCAST.
Leo: YOU BROUGHT YOUR OWN?
Tod: I BROUGHT MY OWN FANCY FLOWCHART ON HOW TO MAKE ONE. [ Pop captions down ]
Leo: I LOVE IT.
Tom Maffin: IT GOES LIKE THIS.
Leo: TOD MAFFIN'S PODCAST PRODUCTION FLOWCHART.
Tod: HERE'S HOW IT WORKS. FIRST OF ALL, I HAVE GOOD TIME ON MY HANDS.
Leo: VERY IMPORTANT.
Tod: THEN I DRINK A BOTTLE OF MERLOT.
Leo: WELL, NOW, I'M NOT SURE I RECOMMEND THAT.
Tod: I HIT RECORD.
Leo: (laughing) OH, BOY.
Tod: AND THEN I SAY THINGS THAT I REGRET. THAT'S -- THAT'S HOW MY FLOWCHART WORKS.
Leo: THAT'S VERY GOOD.
Tod: YEAH.
Leo: THAT SOUNDS LIKE HOW I DO MY PODCAST.
Tod: IS THAT RIGHT? YEAH.
Leo: YEAH, YEAH. [ Pop captions up ]
Tod: SO, YEAH, LOTS OF INTERESTING TOOLS THOUGH. I THOUGHT WE SHOULD START WITH GETTING THE AUDIO INTO, FIRST OF ALL, A PODCAST.
Leo: AND IF YOU HAVE A COMPUTER, YOU HAVE KIND OF THE MOST EXPENSIVE PART OF THIS STUDIO, RIGHT?
Tod: WELL, YOU HAVE A MICROPHONE AND THAT'S GREAT FOR RECORDING STUFF IN THE AMBIENT.
Leo: RIGHT. [ Pop captions down ]
Tod: SO, THINGS THAT ARE, YOU KNOW, TALKING INTO IT AND SO FORTH, BUT --
Leo: BUT YOU DO GET AMBIANCE. YOU GETA LOT.
Tod: YOU GET A LOT OF STUFF --
Leo: YEAH, YEAH.
Tod: -- ABSOLUTELY, AND WE'LL TALK A BIT HOW TO REDUCE THE NOISE THAT'S AROUND YOU --
Leo: OKAY.
Tod: -- OR PICK IT UP BECAUSE TIMES YOU WANT TO LIFT THE LEVELS OF THAT.
Leo: MM-HMM.
Tod: BUT SOMETIMES YOU WANT TO RECORD THINGS OFF OF, SAY, A DVD YOU'VE PUT IN AND OFF OF skype AND THAT'S -- CAN BE PROBLEMATIC. YOU KNOW, OFTEN PEOPLE SAY WHAT'S THE BEST WAY TO RECORD A DVD. AND IF THEY DON'T HAVE A COMPUTER OR A SOFTWARE, I SAY GET A MIC AND A RECORDER AND HOLD THE MICROPHONE UP TO THE SPEAKER. I MEAN --
Leo: IT WORKS.
Tod: -- IT WORKS. THERE IS A GREAT PROGRAM THOUGH CALLED Audio Hijack Pro. THERE'S TWO. THIS IS FOR THE Mac. Audio Hijack Pro IS GOOD. THERE'S ANOTHER ONE CALLED WireTap Pro. THEY BOTH DO ABOUT THE SAME THING.
Leo: THEY'RE BOTH FROM Rogue Amoeba, SO IT'S THE SAME COMPANY AND --
Tod: THEY HAVE -- THEY HAVE VERY SIMILAR KIND OF IDEAS.
Leo: YEAH. [ Pop captions up ]
Tod: I FIND THAT Audio Hijack Pro, THE NICE THING ABOUT IT IS THAT IT HAS A LOT MORE SORT OF FANCY FEATURES. I'LL GIVE YOU AN EXAMPLE. IT'S A LOT SIMPLER TO USE, FOR INSTANCE. [ Pop captions down ]
Tod: HERE YOU JUST SAY, YOU KNOW, I WANT TO RECORD OFF OF iChat OR I WANT TO RECORD OFF OF skype OR iMovie OR, IN THIS CASE, THE DVD PLAYER. YOU CAN INSTANTLY JUST SAY, OKAY, HERE'S WHAT I WANT TO SAVE IT AS. YOU CAN ADD ALL SORTS OF TAGS. VERY EASY TO ADD. BUT HERE'S WHAT I --
Leo: WOW.
Tod: HERE'S WHAT I REALLY LIKE ABOUT IT, THE EFFECTS. SOMETIMES WHEN YOU'RE PULLING SOMETHING IN OFF OF, SAY, skype, THE AUDIO QUALITY IS NOT GREAT.
Leo: RIGHT.
Tod: YOU KNOW, IT HAS A KIND OF TINNY QUALITY --
Leo: RIGHT.
Tod: -- AND THINGS LIKE THAT. SO, YOU CAN, EVEN BEFORE IT GETS SAVED TO THE HARD DISK, YOU CAN CHANGE IT. YOU CAN EQUALIZE IT OR YOU CAN BOOST THE LEVELS OF IT. AND TO DO THAT, WHERE IT SAYS CLICK HERE TO INSERT EFFECT, YOU CAN JUST CLICK IT. NOW, THIS -- IF YOU'VE EVER SEEN SOMETHING IN GarageBand OR -- OR ANY OTHER SORT OF AUDIO PROGRAM, YOU'LL NOTICE, YOU'LL RECOGNIZE THESE. YOU CAN ADD AN EQUALIZER. SO, YOU CAN SAY, OKAY, I WANT IT TO BOOST THE LEVELS IN A CERTAIN AREA. I CAN ADD BALANCE. I CAN SAY I WANT EVERYTHING IN THE LEFT CHANNEL FOR WHATEVER REASON. AND THEN --
Leo: OR YOU COULD HAVE skype IN THE LEFT CHANNEL, YOU IN THE RIGHT CHANNELS --
Tod: EXACTLY.
Leo: -- SO PEOPLE DISTINGUISH THE TWO.
Tod: YEAH.
Leo: YEAH.
Tod: SO THEN WHEN IT SAVES THIS, YOU CAN SEE THE SORT OF PATH THAT IT GOES THROUGH --
Leo: OH, LOOK, THAT'S COOL.
Tod: -- THE GREEN LINE FOLLOWS. BECAUSE IN SOME CASES YOU MAY WANT TO -- YOU MAY WANT TO, FOR INSTANCE, PUT A -- A LOW PASS FILTER, WHICH IS A VERY NERDY TECHNICAL THING THAT WE DON'T NEED TO GET INTO.
Leo: BUT IT CUTS THE -- THE BASE SOUND A LITTLE BIT.
Tod: IT TAKES THE BASE OUT.
Leo: YEAH.
Tod: IT'S FA-- IT'S HELPFUL IF YOU'RE -- IF YOU'RE RECORDING OUTDOORS AND THERE'S LOTS OF WIND NOISE.
Leo: RIGHT.
Tod: IT'LL TAKE THAT OUT.
Leo: RIGHT.
Tod: YOU MAY WANT TO PUT THAT IN AT THE BEGINNING THOUGH AND SO YOU MOVE THESE AROUND --
Leo: OH, LOOK AT THIS. WOW.
Tod: -- AND YOU CAN ACTUALLY CHANGE THE ORDER THAT IT PROCESSES THE AUDIO. THAT ALL HAPPENS BEFORE IT EVEN WRITES IT. SO, IT SAVES YOU A LOT OF TIME.
Leo: I'M GOING TO SAY UPFRONT THAT THIS IS ONLY A 40 DOLLAR PROGRAM.
Tod: YEAH.
Leo: PEOPLE ARE GOING TO LOOK AT THAT AND SAY, WOW, THAT'S GOING TO COST THOUSANDS. IT'S VERY AFFORDABLE.
Tod: VERY AFFORDABLE.
Leo: YEAH, YEAH.
Tod: 40 BUCKS U.S. YEAH. IT'S ABOUT 6,000 CANADIAN, BUT, YOU KNOW.
Leo: THE EXCHANGE RATE, YEAH.
Tod: (laughing) EXACTLY. AND NOW THIS IS --
Leo: OR IT'S 2 EUROS.
Tod: (laughing)
Leo: YOU KNOW, THAT'S THE BEAUTY OF IT, RIGHT?
Tod: EXACTLY.
Leo: GO TO FRANCE AND BUY IT.
Tod: SO, LET'S SAY YOU HAVE A GOT SOME AUDIO NOW THAT -- THAT YOU'VE RECORDED OUT IN THE FIELD THAT MAY -- MAY NOT BE GREAT AUDIO QUALITY, OR YOU'VE DONE WHAT I HAVE DONE, WHICH IS HERE IS AN INTERVIEW I RECORDED AT THE CBC A LITTLE EARLIER TODAY, WHERE I WAS HOLDING UP -- I HAD THE MICROPHONE THAT WAS SORT OF -- I HELD THE MICROPHONE IN THIS POSITION.
Leo: RIGHT.
Tod: SO, I WAS INTERVIEWING THE PERSON.
Leo: BUT YOUR VOICE --
Tod: MY VOICE WAS TOO FAR AWAY FROM THE MIC.
Leo: OH, BOY.
Tod: AND WHAT I SHOULD HAVE DONE IS MOVED THE MIC BACK AND FORTH --
Leo: YEAH.
Tod: -- BUT I DIDN'T. SO, IF YOU LOOK AT --
Leo: HOW OFTEN DO WE FORGET TO DO THAT THOUGH.
Tod: WAY TOO OFTEN.
Leo: YEAH.
Tod: YEAH, EXACTLY. I'M USED TO, YOU KNOW, HAVING MICROPHONES ON EACH PEOPLE.
Leo: RIGHT, RIGHT.
Tod: SO, YOU CAN VISUALLY SEE HERE, I'LL HIGHLIGHT THE AREAS, THOSE ARE MY QUESTIONS AND YOU --
Leo: I -- I LIKE THIS PROGRAM, BY THE WAY. THIS IS Amadeus Pro.
Tod: Amadeus Pro IS REALLY GOOD.
Leo: VERY AFFORDABLE.
Tod: YEAH.
Leo: OTHER Mac PRO-- ALL OF THIS STUFF IS Mac SPECIFIC.
Tod: YEAH, IF YOU'VE TRIED Audacity, WHICH IS A FREE PROGRAM, YOU WANT TO KIND OF GET UP TO THE NEXT LEVEL, IT'S A REALLY GOOD PROGRAM.
Leo: YEAH, HIGHLY RECOMMEND IT. [ Pop captions up ]
Tod: SO, YOU CAN SEE HERE THAT MY LEVELS ARE -- ARE SMALL. NOW, YOU CAN, IF YOU WANT --
Leo: OH, THAT'S YOU.
Tod: THESE ARE ME.
Leo: THOSE LITTLE ONES.
Tod: YEAH.
Leo: UH-OH, YEAH.
Tod: THESE ARE MY QUESTIONS.
Leo: THAT'S A PROBLEM.
Tod: AND SO I MEAN, IF I PLAY IT, YOU CAN ACTUALLY HEAR THE DIFFERENCE IN THE AUDIO QUALITY OR THE AUDIO LEVELS.
Leo: RIGHT.
Tod: WOOPS.
(Tod in audio segment): And what about the satellite radio station, is that tied in?
(female): THAT IS TIED IN -- [ Pop captions down ]
Leo: OH, MY GOSH.
Tod: YEAH, SHE COMES ON SUPER LOUD, RIGHT?
Leo: RIGHT.
Tod: SO, HERE'S WHAT I WANT TO DO. I WANT TO CHANGE THAT. SO, I, I CAN MANUALLY GO THROUGH EACH SECTION --
Leo: ONE BY ONE.
Tod: -- ONE BY ONE AND SAY I WANT TO NORMALIZE THIS OR UPGRADE THE LEVELS AND SO FORTH.
Leo: I'VE DONE THAT. IT'S NOT FUN.
Tod: IT'S A REAL PAIN. HERE'S A GREAT PROGRAM CALLED Levelator. THIS IS A FREE PROGRAM. THIS IS ALL YOU DAY -- DO. YOU TAKE THE FILE, YOU DROP IT ON THE ICON. NOW, WATCH WHAT THE ICON'S GOING TO DO IN THE MIDDLE THERE. ABSOLUTELY NOTHING.
Leo: ISN'T THAT BEAUTIFUL?
Tod: ISN'T THAT GREAT? (laughing)
Leo: I THINK THAT'S A REALLY GREAT PROGRAM.
Tod: (laughing)
Leo: ANY PROGRAM THAT DOES NOTHING TO MY SOUND, I WANT THAT.
Tod: I FIGURED IT OUT.
Leo: ACTUALLY, THAT'S FROM DOUG KAYE AND GigaVox AND I USE IT --
Tod: YOU LAUNCH IT FIRST.
Leo: -- AND HE DOES -- HE DOES A GREAT JOB.
Tod: THERE YOU GO, YOU LAUNCH IT FIRST.
Leo: OH, IT'S Levelating!
Tod: AND THERE IT IS.
Leo: IT'S TOO FAST. IT DID IT TOO FAST. LET'S DO THAT AGAIN ONE MORE TIME SO WE CAN SEE IT Levelate.
Tod: ONE MORE TIME.
Leo:\AIOOOH-ZZZIK! VERY QUICK.
Tod: SO, WHAT IT'S DONE NOW IS IT'S WRITTEN THIS FILE HERE CALLED Levelator Output.
Leo: OKAY.
Tod: SO, IF I TAKE THAT FILE AND LOOK AT IT NOW, YOU ARE GOING TO BE ABLE TO SEE THE DIFFERENCE IN QUALITY. SO, THERE ARE MY LEVELS NOW, ALL PICKED UP.
Leo: MUCH CLOSER.
Tod: MUCH BETTER TO WHAT THEY SHOULD BE.
Leo: MUCH CLOSER, YEAH. (improved audio segment playing)
Tod: SO, THE LEVELS ARE THE SAME THERE. THIS IS REALLY IMPORTANT ESPECIALLY. WHAT Levelator DOES WHICH IS NICE IS, YOU KNOW, SOMETIMES THEY HAVE WHAT THEY CALL AUDIO GAIN CONTROL, WHICH IS WHERE A RECORDING MACHINE WILL, IF SOMETHING LOUD HAPPENS --
Leo: RIGHT.
Tod: -- IT'LL ALL OF A SUDDEN CLAMP DOWN ON THE AUDIO.
Leo: RIGHT.
Tod: SO, YOU GET THIS BIG BURST OF AUDIO AND THEN IT ZZHOOMSHUTS RIGHT DOWN. WHAT THIS DOES IS IT LOOKS AHEAD IN THE AUDIO FILE.
Leo: IT'S VERY SMART, YEAH.
Tod: IT'S VERY SMART. THE NEXT ONE IS CALLED Sound Byte. THIS IS A NEAT LITTLE PROGRAM IF YOU -- IF YOU'RE PLAYING AROUND WITH AUDIO PODCASTS AND YOU WANT TO DO SOMETHING LIKE -- LIKE HAVE SOUND EFFECTS. LIKE, SOMETIMES THERE'S SOME RADIO SHOWS THAT HAVE --
Leo: OH, LOOK.
Tod: -- THESE KIND OF GOOFY SOUND EFFECTS.
Leo: OH, I WANT THIS. BECAUSE I USE GOOFY SOUND EFFECTS, YEAH.
Tod: I KNOW YOU DO. [ Pop captions up ]
Tod: AND IN THE -- IN THE RADIO BUSINESS --
Leo: (improvising various sound effects)
Tod: WELL, AND I'VE GOT ALL OF THOSE. I'VE GOT ONE YOU'RE GOING TO LIKE. (loud indiscernible sound effect playing) [ Pop captions down ]
Tod: OKAY, THAT WAS WAY TOO LOUD.
Leo: THAT'S GOOD.
Tod: THAT SHOULD HAVE BEEN Levelated, I THINK.
Both: (laughing)
Leo: THAT'S GOOD.
Tod: BACK IN -- BACK IN THE DAYS WHEN I STARTED IN RADIO, AND I KNOW WHEN YOU DID TOO, WE HAD THESE THINGS CALLED CART MACHINES.
Leo: YEAH, THAT'S RIGHT.
Tod: AND THEY LOOKED LIKE 8-TRACK CARTRIDGES.
Leo: YEAH, YEAH.
Tod: SO, THIS IS ESSENTIALLY A VIRTUAL CART MACHINE.
Leo: BUT LOOK HOW MANY YOU CAN HAVE ON HERE.
Tod: WELL, WHAT'S GREAT IS, YOU KNOW, ALL I'VE DONE IS I'VE TAKEN MY FILES HERE THAT I WANTED TO LOAD UP INTO IT AND IT TAKES, THIS PROGRAM TAKES ANYTHING. SO, I'VE BASICALLY HIGHLIGHTED THESE AND I'VE DROPPED THEM ON THIS DROP ZONE.
Leo: SO, IF YOU'RE DOING A WHACKY MORNING ZOO PODCAST -
Tod: IT'S PERFECT FOR IT. AND YOU CAN PLAY --
Leo: LOOK AT THAT.
Tod: YOU KNOW, YOU CAN HAVE YOUR (gong sound effect) GONG. YOU CAN (buzzer sound effect) HAVE THE BUZZER.
Leo: FOLKS, IF ALL OF A SUDDEN YOU HEAR ALL THESE SOUND EFFECTS IN MY PODCASTS, YOU'LL NOW KNOW WHY. IT'S HIS FAULT. BLAME HIM. (harp strings sound effect and other sound effects playing)
Tod: AND WHAT'S REALLY NEAT ABOUT THIS IS YOU CAN ADD, YOU CAN HAVE DIFFERENT THINGS GOING ON. I LOVE THAT. I LOVE THE HARP ONE.
Leo: IT CAN PLAY MULTIPLE THINGS AT THE SAME TIME.
Tod: IT'LL PLAY MULTIPLE THINGS AT THE SAME TIME.
Leo: OH, THAT'S GREAT.
Tod: SO, I CAN TAKE, FOR INSTANCE, SOME MUSIC AND PLAY A BIT OF MUSIC AND THEN ALSO AT THE SAME TIME PLAY A VOICE TRACK TO THAT RECORDING.
Leo: SO, THIS COULD BE YOUR THEME SONG. IT DOESN'T HAVE TO JUST BE GOOFY SOUND EFFECTS.
Tod: IT CAN BE ANYTHING, YEAH.
Leo: IT CAN BE THE THEME AND THE INTRO.
Tod: YEAH. SO, HERE'S THE VOICE INTRO.
Leo: Mr. ANNOUNCER. (inaudible audio)
Leo: IT'S LOW NOW. WE -- I THINK WE TURNED IT DOWN AFTER THE GONG.
Tod: I, I THINK SO, YEAH, EXACTLY.
Leo: (laughing) I THINK THE -- THE PEOPLE IN THE STUDIO SAID, "THAT'S QUITE ENOUGH OF Mr. MAFFIN'S SOUND EFFECTS."
Tod: (laughing) EXACTLY.
Leo: YOU GOT ONE MORE FOR US?
Tod: ABSOLUTELY. THE LAST ONE IS CALLED --
Leo: LOOKS LIKE --
Tod: -- IT'S CALL Voice Candy.
Leo: IT LOOKS DELICIOUS.
Tod: IT DOES, DOESN'T IT?
Leo: YEAH.
Tod: IT'S VERY -- VERY TASTY. IT'S GREAT IF ALL YOU'RE DOING IS RECORDING. IT'S SORT OF LIKE -- LIKE Photo Booth FOR --
Leo: RIGHT.
Tod: -- FOR PHOTOGRAPHS.
Leo: FOR AUDIO. [ Pop captions up ]
Tod: THIS IS Photo Booth FOR AUDIO.
Leo: AHH.
Tod: SO, IT'S VERY EASY TO RECORD. I CAN, IF I WANT TO, JUST RECORD MY VOICE.
Leo: NORMALLY.
Tod: AND THEN PLAY IT BACK.
(Tod via recording): Record my voice.
Leo: OKAY.
Tod: THAT'S EASY. BUT WHAT'S KIND OF NEAT HERE IS YOU CAN ADD DIFFERENT THINGS. SO, I AM GOING TO RECORD MY VOICE AS DARTH VADER. [ Pop captions down ]
Tod: I WILL KILL LEO LAPORTE. AND THEN PLAY IT BACK.
(Tod's voice as Darth Vader):I WILL KILL LEO LAPORTE.
Leo: I'M SCARED.
Tod: (laughing)
Leo: I'M SCARED.
Tod: IT'S GOT A ROBOT, IT'S GOT A MOUSE, IT'S GOT --
Leo: WOW.
Tod: -- AN OLD RADIO, SCI-FI. YOU CAN SAVE IT TO YOUR DESKTOP. AND THEN IF YOU WANT TO, YOU CAN DROP THAT INTO Sound -- Sound Byte, CLEAN IT UP WITH ANYTHING LIKE THAT AND -- AND THEY'RE GREAT LITTLE TOOLS.
Leo: YOU'VE GOT A LITTLE BAG OF TRICKS IN HERE. YOU JUST CARRY THIS AROUND WITH YOU?
Tod: THAT'S EXACTLY WHAT IT IS, YEAH. VERY INEXPENSIVE.
Leo: AND IF I HEAR DARTH VADER ON THE CBC, I'M GOING TO KNOW WHO IT IS. YOU WON'T BE ABLE TO FOOL ME.
Tod: (laughing) WE HAVE TO PAY ROYALTIES FOR HIM, SO, NO, YOU'RE NOT GOING TO HEAR HIM.
Leo: TOD MAFFIN IS THE CBC'S National Technology COLUMNIST AND HE'S ALSO EDITOR OF THE BROADCASTERS OFFICIAL BLOG Inside the CBC. [ Pop captions up ]
Leo: YOU CAN CATCH THAT AT insidethecbc.com AND OF COURSE, todbytes.com [sic] IS HIS WEBSITE. ALL OF THE SOFTWARE YOU SAW HERE IS LINKED ON OUR WEBSITE, THE labwithleo.com [ Pop captions down ]
Leo: VERY COOL. THANKS, TOD.
Tod: YOU'RE WELCOME.
Leo: REALLY APPRECIATE YOUR COMING IN. COMING UP, MORE OF YOUR CALLS IN JUST A LITTLE BIT. AND, OF COURSE ONE OF YULE'S FINE JEWELS. DON'T GO AWAY. [ Pop captions up ] [ Music ] [ BLACK/COMMERCIAL ] [ Pop captions down ] [ Theme music playing ]
Leo Laporte: (whistling) WELCOME BACK TOTHE LAB. LEO LAPORTE HERE. AND I THINK WE HAVE TIME. WE'RE GOING TO TRY TO SQUEEZE IN ANYWAY ONE MORE CALL. KATE ABRAHAM, WHO IS ON THE LINE?
Kate: WE HAVE THE LOVELY VERN ON THE LINE FROM HAMILTON IN ONTARIO.
Leo: IS IT TRUE VERN, ARE YOU ACTUALLY LOVELY?
Vern: I AM.
Leo: (laughing) AND PROUD OF IT. [ Pop captions up ]
Leo: HEY, VERN, WELCOME TO THE SHOW.
Vern: I'M GLAD TO BE HERE.
Leo: WHAT -- WHAT CAN I DO FOR YOU?
Vern: WELL, MY QUESTION IS IS I HAVE, LIKE, 10 DAYS WORTH OF PODCASTS THAT I HAVEN'T HAD A CHANCE TO LISTEN TO IT.
Leo: OKAY.
Vern: IT SAYS 10.5 DAYS ON THE BOTTOM OF MY iTunes. [ Pop captions down ]
Leo: (laughing) THAT'S A LOT OF PODCASTS.
Vern: IT IS. AND I'VE TRIED TO BURN THEM ONTO A CD.
Leo: OKAY.
Vern: BUT IT WON'T PLAY IN, LIKE, MY CAR.
Leo: YEAH.
Vern: I WAS WONDERING IF I'M DOING SOMETHING WRONG ON iTunes OR --
Leo: NO.
Vern: -- IF I NEED A PROGRAM OR SOMETHING?
Leo: ARE YOU BURNING THEM AS AN AUDIO CD OR AS A DATA CD?
Vern: I'M BURNING THEM AS AN AUDIO CD.
Leo: OKAY, THAT'S THE ONE THING THAT PEOPLE OFTEN GET WRONG. AND IF YOU LOOK AT iTunes' SETTINGS AND YOU GO TO THE ADVANCED SETTINGS WHERE IT'S TALKING ABOUT BURNING, YOU'LL HAVE A CHOICE BETWEEN AUDIO, MP3 OR DATA. AND YOU WANT TO MAKE SURE IT'S AN AUDIO CD IF YOU'RE GOING TO PLAY IT IN AN AUDIO CD PLAYER. IF YOU CHOOSE THESE -- THESE ARE BOTH DATA SETTINGS. SOME CD PLAYERS WILL ACTUALLY PLAY AN MP3 CD, BUT THAT'S WHY THAT'S A CHOICE THERE. BUT MOST OF THE TIME YOU WANT TO MAKE AN AUDIO CD.
Vern: RIGHT.
Leo: SO, YOU'RE MAKING AN AUDIO CD. THE OTHER ISSUE THAT SOMETIMES STEPS UP TO BITE US IS SOME CD PLAYERS HAVE DIFFICULTY WITH HOME RECORDED MEDIA. THE REASON IS THESE -- THESE DISKS ARE LOWER LUMINANCE THAN A PRE-RECORDED DISK.
Vern: OKAY.
Leo: AND MODERN CD PLAYERS, LIKE SOLD IN THE LAST FEW YEARS, SHOULD KNOW THE DIFFERENCE BECAUSE SO MANY PEOPLE USE CD-Rs THESE DAYS.
Vern: RIGHT.
Leo: BUT THE OLDER CD PLAYER MAY NOT. AND WHAT HAPPENS IS, BECAUSE IT'S LOWER LUMINANCE, IT KEEPS TRYING -- IT THINKS, OH, IT'S A DUAL LAYER CD AND IT KEEPS TRYING TO FOCUS DOWN BELOW IT AND THEN GO UP. SO, IT'LL, IT'LL -- YOU CAN SEE IT ACTUALLY CHURNS FOR A WHILE, REALLY TRYING TO READ IT AND EVENTUALLY IT SAYS I -- I CAN'T SEE ANYTHING ON THERE.
Vern: RIGHT, OKAY.
Leo: SO, THERE -- THERE'S NOT MUCH YOU CAN DO. YOU CAN TRY DIFFERENT MEDIA. SOME MEDIA WORKS BETTER IN SOME CD PLAYERS THAN OTHERS. [ Pop captions up ]
Leo: I MEAN, LITERALLY DIFFERENT MANUFACTURERS OF BLANKS.
Vern: OKAY.
Leo: YOU KNOW, Ritech, Maxtor, TDK. I WOULDN'T BUY A LOT OF ANY OF THEM, ONE OR TWO, AND JUST DO SOME SAMPLE RECORDINGS UNTIL YOU CAN FIND ONE THAT WORKS. [ Pop captions down ]
Leo: IS IT A CD-R OR A CD-RW?
Vern: UM, IT'S A CD-R.
Leo: OKAY. SOMETIMES, BELIEVE IT OR NOT, CD-RW WORKS BETTER.
Vern: OH, OKAY.
Leo: SOMETIMES IT DOESN'T.
Vern: OKAY.
Leo: THESE ARE JUST -- YOU KNOW, OBVIOUSLY YOU'RE NOT GOING TO RIP THE CD PLAYER OUT OF YOUR CAR.
Vern: NO.
Leo: (laughing) HOW OLD IS THE CAR?
Vern: JUST A FEW YEARS.
Leo: YEAH.
Vern: 2003.
Leo: OKAY, YOU KNOW, THAT'S RIGHT AT THE --
Vern: OLDSMOBILE.
Leo: THAT WAS RIGHT AT THE -- YOU KNOW, THE -- THE CUTOFF RIGHT THERE --
Vern: OH, OKAY.
Leo: -- YOU KNOW. AND I SUSPECT IT'S JUST -- IT'S JUST MERELY THAT IT'S AN AUDIO CD PLAYER THAT DOESN'T DO WELL WITH CD-R MEDIA.
Vern: ALL RIGHT. SO, IF I TRIED IT IN ANOTHER CD PLAYER, IT MIGHT WORK?
Leo: YEAH, WELL, THAT'S THE FIRST THING I WOULD DO, YEAH.
Vern: OKAY.
Leo: IF YOU -- YOU KNOW, TRY ONE THAT'S MORE -- THAT'S MORE RECENT. AND -- AND IF IT DOESN'T PLAY, THEN THERE -- THERE MAY BE ISSUES WITH YOUR BURNING. YOUR BURNER MAY BE OUT OF ALIGNMENT AND SO FORTH. BUT GENERALLY SPE-- I MEAN, WE SEE IT ALL THE TIME. IT'S JUST BLANKS DON'T WORK AS WELL IN SOME CD PLAYERS.
Vern: ALL RIGHT THEN.
Leo: HEY, THANKS FOR THE CALL.
Vern: CAN I GET AN AUTOGRAPHED PICTURE?
Leo: OF COURSE, I HAVE ONE RIGHT HERE. LET ME JUST THROW IT AT -- WAIT, WHERE DID THEY ALL GO? OH, WELL, I GUESS WE'LL HAVE TO MAIL IT TO YOU.
Vern: ALL RIGHT.
Leo: KATE'S GOT THEM OVER THERE. SO, HANG ON THE LINE SO WE CAN GET YOUR ADDRESS AND WE'LL SEND YOU ONE.
Vern: OKAY, TAKE CARE.
Leo: SO NICE TO HAVE YOU ON THE SHOW. THANK YOU VERY MUCH.
Vern: ALL RIGHT.
Leo: HEY, ARE YOU READY FOR A JEWEL FROM YEWELL? I THINK I AM. Mr. RYAN YEWELL --
Ryan: YES.
Leo: -- IS CONSTANTLY SEARCHING THE GLOBE FOR THE FINEST IN FREE SOFTWARE. HE'S FOUND ONE FOR US RIGHT NOW.
Ryan: I'VE FOUND ONE. SO, THIS ONE'S AM-DeadLink.
Leo: FOR Windows.
Ryan: FOR Windows. [ Pop captions up ]
Ryan: AND WHAT THIS DOES IS FOR THOSE OF US THAT HAVE SURFED OVER THE YEARS, HAD A LOT OF FAVOURITE BOOKMARKS.
Leo: RIGHT.
Ryan: OH, I LIKE THAT SITE, I'M GOING TO COME BACK TO IT. [ Pop captions down ]
Ryan: THE NEXT THING YOU KNOW, MAYBE YOU HAVE 2, 3, 4, 500 BOOKMARKS.
Leo: AND THEY'RE DEAD.
Ryan: AND SOME OF THEM ARE DEAD.
Leo: YEAH.
Ryan: SO, WHAT THIS DOES IS IT ACTUALLY LOADS UP YOUR .HTML -- HTML FILE FOR EITHER Internet Explorer, IT DOES Mozilla Firefox, Opera.
Leo: OH, SO IT DOESN'T HAVE TO BE Firefox. IT CAN BE ALMOST ANY BROWSER.
Ryan: IT CAN BE ALMOST -- BASICALLY THE ONES LISTED HERE.
Leo: OKAY.
Ryan: SO, ALMOST ANY ONE. AND THEN ONCE YOU'VE LOADED IT UP, YOU JUST HIT THIS LITTLE CHECKMARK HERE, CHECK BOOKMARKS. AND AS YOU CAN SEE, IT SAYS IT'S CHECKING --
Leo: OH, LOOK.
Ryan: -- REDIRECTING.
Leo: SO, IT'S JUST CHECKING THE NET TO SEE --
Ryan: IT'S JUST CHECKING.
Leo: OH, YOU'VE GOT A FEW DEAD.
Ryan: YEAH, I HAVE -- I HAVE SOME ERROR MESSAGES HERE. NOW, I DID THAT ON PURPOSE BECAUSE I KNEW I HAD TO CREATE BOOKMARKS. BUT IF YOU ACTUALLY HAVE SOME, YOU CAN SORT -- YOU CAN SORT THEM. SO, ALL THE 403s AND THE 404s ARE TOGETHER. [ Pop captions up ]
Ryan: AND THEN FROM HERE YOU CAN ACTUALLY JUST GO IN AND DELETE THEM. SO, I CAN JUST DELETE THAT LINK RIGHT THERE.
Leo: A SIMPLE LITTLE TOOL. [ Pop captions down ]
Ryan: AND YOU CAN MASS DELETE, OF COURSE, AS WELL.
Leo: THAT'S -- YOU CAN MASS DELETE?
Ryan: YEAH, OF COUR--
Leo: NOTHING'S SO SATISFYING AS MASS DELETIONS.
Ryan: SO, THERE YOU GO, MASS DELETIONS. [ Pop captions up ]
Leo: AND I LIKE THE NAME TOO, AM-Dead OR IS IT AM-Dead?
Ryan: IT'S JUST --
Leo: AM-Dead.
Ryan: MAY-- MAYBE IT'S AM-Dead.
Leo: AM-Dead.
Ryan: I DON'T KNOW, LIKE.
Leo: AM-DeadLink.
Ryan: NOW, I -- ONE CAVEAT IS I FOUND THAT Firefox, I ACTUALLY HAD TO POINT IT TO THE HTML FILE --
Leo: OKAY.
Ryan: -- WHEREAS Explorer FOUND IT RIGHT AWAY.
Leo: OKAY. [ Pop captions down ]
Ryan: SO, YOU'RE GOING TO HAVE TO FIND YOUR HTML FILE POSSIBLY, BUT --
Leo: IT'S IN YOUR PROFILE FOLDER.
Ryan: IT -- Documents and Settings AND THEN THE LO--
Leo: THE LO-O-ONG.
Ryan: YEAH, IT TOOK ME A WHILE.
Leo: YEAH, YOU HAVE TO KIND OF DIG AROUND TO FIND IT.
Ryan: I GOT MAD AT FIRST, BUT THEN I GOT CALM, SO
Leo: WELL, YOU KNOW WHY, BECAUSE ONE OF THOSE FOLDERS HAS THE MOST WEIRD NAME WITH, YOU KNOW, LIKE 40 CHARACTERS OF --
Ryan: AND IT WAS HIDDEN.
Leo: YEAH.
Ryan: I HAD TO UNHIDE IT IN Windows.
Leo: TSK, THEY DON'T WANT YOU MESSING WITH IT, MAN.
Ryan: WELL, I WANT TO MESS WITH IT.
Leo: DUDE. DUDE.
Ryan: OKAY.
Leo: Firefox --
Ryan: YES.
Leo: -- SAYS DON'T MESS WITH ME, DUDE.
Ryan: OKAY. WELL, IT'S AM-DeadLink. IT'S A YEWELL'S JEWEL, labwithleo.com [ Pop captions up ]
Ryan: WE SOLD IT, I HOPE.
Leo: (laughing)
Ryan: I HOPE PEOPLE OUT THERE ARE GOING TO GO OUT THERE AND CHECK IT OUT. I TRY MY BEST.
Leo: I TOLD HIM SELL 'EM. YOU'VE GOTTA SELL 'EM.
Ryan: YOU GOTTA -- (laughing)
Leo: IT MAY BE FREE, BUT YOU GOTTA SELL 'EM.
Ryan: EXACTLY.
Leo: RYAN, YOU'RE THE MAN.
Ryan: THANK YOU, SIR.
Leo: THANK YOU VERY MUCH. RYAN YEWELL, AS HE SAID, labwithleo.com [ Pop captions up ]
Leo: FINAL WORD -- NO, WHAT AM I SAYING A FINAL WORD? BILL. BILL JELEN, MrExcel IS HERE. WE'RE GOING TO TALK TO HIM IN JUST A LITTLE BIT. WE'RE GOING TO KEEP THOSE FORMULAS UNDER CONTROL WHEN WE RETURN. BUT FIRST, QUICK QUIZ QUESTION OF THE DAY. [ Pop captions down ]
Leo: MM, THAT'S NOT IT. THAT'S IT. WHEN WAS Microsoft Excel FIRST RELEASED? BILL, DON'T SAY A WOR-- WAIT A MINUTE, THAT'S NOT EVEN THE QUESTION. THAT'S -- THAT'S THE WRONG QUESTION. THE QUESTION WE WANTED TO KNOW IS WHAT WAS THE FIRST SPREADSHEET? WHA-- SO, DON'T READ THE SCREEN? WAS IT Excel? WAS IT Lotus 1-2-3? WAS IT VisiCalc? OR WAS IT YewellCalc 2-4-8? HM, THINK ABOUT THAT. WE'LL TELL YA WHEN THE LABCONTINUES. [ Music ] [ BLACK/COMMERCIAL ] [ Pop captions down ]
Leo Laporte: WELCOME BACK TO THE LAB. THERE'S THAT QUIZ QUESTION WE WERE LOOKING FOR, AND A TOUGH ONE, TOO. BOY, UNLESS YOU KNOW YOUR PC HISTORY. WHICH OF THESE PROGRAMS CAME OUT FIRST? Lotus 1-2-3, Microsoft Excel, VisiCalc OR YewellCalc? OF COURSE IT WAS VisiCalc. FRANKSTON AND BRICKLIN.
Bill: OCTOBER 23rd, 1979.
Leo: MrExcel EVEN KNOWS THE DAY. WHY DO YOU REMEMBER THE DAY?
Bill: THAT'S -- THAT'S THE DAY THAT THE PERSONAL COMPUTER INDUSTRY ACTUALLY GOT LUNCHED.
Leo: IT DID. IT WAS THE KILLER APP.
Bill: BEFORE VisiCalc THERE WAS NO GOOD REASON TO BUY A PC.
Leo: RIGHT.
Bill: SPREADSHEETS DROVE EVERYTHING.
Leo: AND I SHOULD POINT OUT IT WASN'T AS A PC. IT WAS AN Apple II.
Bill: Apple II, THAT'S RIGHT.
Leo: YEAH. IT SOLD ALL -- I MEAN, I'M SURE IT SOLD MILLIONS OF Apple II COMPUTERS. WERE PEOPLE DOING SPREADSHEETS BY HAND? I MEAN, HOW -- DID THEY EVEN EXIST? [ Pop captions up ]
Bill Jelen: YES. 1978 IT WAS GREEN LEDGER PAPER, AN ERASER, AND A MECHANICAL PENCIL.
Leo: UNBELIEVABLE.
Bill: YEAH. [ Pop captions down ]
Bill: AND AS I GOT INTO MY SEMINARS, PEOPLE WHO WERE AROUND BACK THEN, THEY'LL RAISE THEIR HAND, THEY'LL SAY, YOU KNOW, WE USED TO ERASE SO MUCH WE'D ACTUALLY ERASE THROUGH THE PAPER. WE'D GO BACK TO THE LAST SHEET OF LEDGER PAPER, CUT IT OUT WITH AN X-ACTO KNIFE AND PEACE IT ON THE PANELING SO WE COULD KEEP WRITING NEW NUMBERS. LITERALLY THE FIRST CUT AND PASTE.
Leo: IT WAS A MUCH NEEDED APPLICATION.
Bill: OH, IT WAS AMAZING.
Leo: WAS IT DAN BRICKLIN OR WAS IT FRANKSTON WHO CAME UP WITH THE IDEA FIRST?
Bill: WELL, BRICKLIN WAS A GRADUATE STUDENT AND IT WAS HIS IDEA. FRANKSTON ACTUALLY BROUGHT IT TO LIFE.
Leo: HE WAS THE ONE WHO WROTE IT BASICALLY.
Bill: WORKING IN --
Leo: YEAH.
Bill: HEY, MY FAVORITE STORY IS THEY ORIGINALLY THOUGHT, INSTEAD OF THE Apple II, THEY WOULD PUT A TRACKBALL ON A CALCULATOR AND WIRE IT UP TO FIGHTER PILOT'S HEADS-UP DISPLAY.
Leo: (laughing)
Bill: COULD YOU IMAGINE THE ACCOUNTING DEPARTMENT IF THAT HAD COME TO LIGHT?
Leo: (nerdy voice) DON'T BOTHER ME I'M CALCULATING. (normal voice) I THINK IT'S PROBABLY BETTER THEY USED THE Apple II. MrExcel IS THE AUTHOR OF Learn Excel From MrExcel. YOU CAN DOWNLOAD THIS CHAPTER BY CHAPTER, ONE CHAPTER A WEEK.
Bill: WE'VE GIVEN AWAY OVER 6 MILLION CHAPTERS SINCE I FIRST ANNOUNCED IT BACK...
Leo: AND YET, IT TRIPLED THE SALES OF THE BOOK, DIDN'T IT?
Bill: IT DID, THAT'S RIGHT.
Leo: YEAH. IT JUST SHOWS YOU, GIVE AWAY STUFF IT'S A GOOD WAY TO SELL STUFF. PEOPLE WANT TO OWN STUFF, THAT'S WHY. NOW, LET'S TALK ABOUT SPREADSHEETS. THIS IS KIND OF SOMETHING YOU MIGHT WANT TO USE IT YOU'RE AUDITING A SPREADSHEET, RIGHT?
Bill: OR SOMEONE SENDS YOU A SPREADSHEET AND YOU HAVE TO FIGURE OUT HOW IT WORKS. YOU KNOW, WHICH ARE FORMULAS AND WHICH AREN'T. NOW, WE'RE DOING THIS IN Excel 2007. ALL THESE TRICKS WERE AVAILABLE IN Excel 2003.
Leo: OKAY.
Bill: THEY'VE GOTTEN A LITTLE BIT EASIER THOUGH IN Excel 2007.
Leo: I HAVE SAY, YOU JUST LOOK AT A SPREADSHEET, YOU SEE NUMBERS, YOU DON'T KNOW IF THAT NUMBER WAS HANDWRITTEN IN, YOU KNOW, TYPED IN, OR IF IT'S CALCULATED.
Bill: OR IF IT'S A FORMULA, YEAH.
Leo: YEAH.
Bill: SO, A GOOD WAY TO FIND ALL THE FORMULAS, ON THE HOME RIBBON THERE'S SOMETHING CALLED THE Find and Select. Find and Select, WE CHOOSE Formulas, WHICH SELECTS ALL THE FORMULAS. AND THEN THE TRICK IS TO, LIKE, USE BOLD OR RED OR SOMETHING SO THAT WAY YOU CAN KIND OF SEE WHICH CELLS ARE --
Leo: AH.
Bill: -- FORMULA CELLS.
Leo: AND THAT'LL BE KIND OF A PERMANENT CHANGE TO YOUR SPREADSHEET THOUGH, RIGHT?
Bill: WELL, YES. SO, WE CAN Undo OR WHATEVER. MY OTHER FAVORITE TRICK IS THERE'S A KEY ON YOUR KEYBOARD RIGHT UNDERNEATH THE F1 KEY THAT HAS THE LITTLE SQUIGGLY FROM SPANISH.
Leo: TILDE.
Bill: THE TILDE.
Leo: YEAH.
Bill: AND A BACKWARDS ACCENT KEY FROM FRENCH, THE E GRAVE.
Leo: YEAH.
Bill: IF YOU HOLD DOWN THE CONTROL KEY AND HIT THAT KEY, IT'LL SHOW --
Leo: (laughing) YOU'RE SUCH A GEEK. THE TILDE OR THE E GRAVE.
Bill:E GRAVE. IT SHOWS YOU EVERY FORMULA.
Leo: SO, CTRL TILDE.
Bill: CTRL TILDE, RIGHT THERE --
Leo: SHOWS YOU --
Bill: -- IN THE UPPER LEFT-HAND CORNER.
Leo: OKAY, NOW, SHOW THE SCREEN SO WE CAN SEE IT WORK. THAT'S IT, GLENN, OKAY.
Bill: SO, IT TOGGLES IN AND OUT.
Leo: (improvising sound effects)
Bill: THERE'S ALL THE FORMULAS. THERE'S THE NUMBERS AND FORMULAS. NUMBERS.
Leo: I DIDN'T KNOW ABOUT THAT.
Bill: ISN'T THAT WILD?
Leo: EVERY-- EVERYBODY WHO DOES IT -- USES Excel KNOWS THAT, RIGHT?
Bill: NO, I DON'T THINK SO. NO ONE KNOWS IT.
Leo: (laughing) BUT THAT'S LIKE RIGHT THERE!
Bill: UNLESS THEY --
Leo: THAT'S VERY USEFUL.
Bill: UNLESS THEY ACCIDENTALLY HIT IT.
Leo: YEAH. AND THEN YOU GO WHAT HAPPENED TO MY SPREADSHEET?
Bill: NOW, HERE WE HAVE A BIG FORMULA WE WANT TO FIGURE OUT HOW IT WORKS. [ Pop captions up ]
Bill: SO, UNDER Formula Auditing, WHICH IS ON Formulas. AND IN Excel 2003, IT WAS Tools, Formula, Auditing.
Leo: OKAY.
Bill: WE WANT TO TRACE PRECEDENTS. [ Pop captions down ]
Bill: AND IT SHOWS ME THAT THIS NUMBER IS CREATED FROM ALL OF THOSE --
Leo: LOOK.
Bill: -- OTHER NUMBERS ON THE BLUE.
Leo: OH, THAT'S GREAT.
Bill: AND IF YOU HIT THE BUTTON AGAIN, IT SHOWS YOU THE SECOND LEVEL PRECEDENTS.
Leo: LIKE, WHAT THEY'RE BASED ON.
Bill: RIGHT. AND THEN WHAT THOSE ARE BASED ON.
Leo: (laughing)
Bill: AND THEN WHAT THOSE ARE... OH.
Leo: NOW, YOU LAUGH AT THAT, BUT THAT'S NOT UNUSUAL, IS IT?
Bill: YEAH, MAYBE WE SHOULDN'T MESS WITH THAT FORMULA, WHAT DO YOU THINK?
Leo: (laughing) LET'S NOT CHANGE IT. WOW.
Bill: AND THEN WE CAN REMOVE ALL THE ARROWS. SO, THE OTHER WAY IS WE SAY, OKAY, WE HAVE THIS NUMBER HERE, THIS PROFIT NUMBER, WHERE DOES THAT FLOW THROUGH TO?
Leo: YEAH.
Bill: WE TRACE DEPENDENTS, AND IT SHOWS ME IT GOES TO JUST ONE CELL. BUT THEN IF I TRACE MULTIPLE LEVELS, I SEE EVENTUALLY IT WORKS ITS WAY DOWN TO THE FINAL RESULT AND ALL THE WAY THROUGH. ONE LAST TRICK AND THIS ONE IS AMAZING. THIS IS GREAT FOR FORMULAS THAT YOU ARE CONVINCED IS GIVING YOU THE WRONG ANSWER.
Leo: RIGHT. [ Pop captions up ]
Bill: OKAY, SO --
Leo: YOU LOOK AT IT AND IT JUST DOESN'T PASS THE SANITY TEST. THERE'S SOMETHING WRONG HERE --
Bill: THERE'S JUST NO WAY THAT THIS HAS THE RIGHT ANSWER.
Leo: -- YEAH.
Bill: IT'S SOMETHING CALLED Evaluate Formula. [ Pop captions down ]
Bill: AND IT SHOWS YOU THE WHOLE FORMULA, BUT THE PART TO BE EVALUATED FIRST IS UNDERLINED. SO, RIGHT NOW I CAN --
Leo: YOU CAN ACTUALLY STEP THROUGH IT.
Bill: YES. SO, I CAN EITHER SAY SHOW ME FROM E30 IS OR I CAN Step In AND E30 IS E28-E29.
Leo: OH, LOOK AT THAT.
Bill: SO, LET'S EVALUATE THAT, EVALUATE THAT, EVALUATE THAT, AND THEN Step Out.
Leo: SO, YOU LITERALLY, STEP BY STEP YOU'RE WATCHING THE -- THE VALUE BE CALCULATED.
Bill: IN SLOW MOTION, WHICH THEN YOU CAN START TO SEE WHERE YOU WROTE THE FORMULA WRONG.
Leo: THESE ARE REALLY U-- IS THIS ALL IN HERE?
Bill: IT'S ALL IN THERE. ALL IN THERE.
Leo: THIS IS WHY --
Bill: AND IT'S FREE.
Leo: -- IF YOU USE THIS BOOK YOU REALLY -- OR USE THIS PROGRAM YOU REALLY NEED THIS BOOK. IT'S MrExcel, Learn Excel from MrExcel. [ Pop captions up ]
Leo: YOU CAN GET FREE CHAPTERS AT mrexcel.com OR GET THE WHOLE BOOK FROM Holy Mackerel Books ONLINE. AND, BY THE WAY, mrexcel.com HAS LOTS OF INFORMATION LIKE THIS. I MEAN, YOU CAN ASK QUESTIONS. HE'LL ASK QUESTIONS FOR FREE. IT'S JUST REALLY A GREAT RESOURCE. [ Pop captions down ]
Bill: FIVE PODCASTS A WEEK.
Leo: I FORGOT THAT, YEAH.
Bill: 400 EPISODES NOW.
Leo: WOW. THAT'S REALLY NEAT. I'M REALLY PROUD OF YOU.
Bill: IT WAS YOUR IDEA.
Leo: THEY'RE DOING WELL, TOO.
Bill: THEY ARE. [ Pop captions up ]
Leo: I SEE THEM ON THE -- ON THE iTunes LIST ALL THE TIME. THANK YOU, BILL. BILL JELEN IS MrExcel. FINAL THOUGHTS COMING UP AS WE WRAP THIS PUPPY UP RIGHT AFTER THIS. STAY HERE. [ Pop captions down ] [ Theme music playing ] [ BLACK/COMMERCIAL ] [ Pop captions down ] [ Theme music playing ]
Leo Laporte: WE HAVE HAD SO MUCH FUN. THIS HAS BEEN A FUN SHOW.
Kate: OH, GREAT, IT WAS SO GOOD.
Leo: YEAH. I TELL YOU, TOD MAFFIN FROM THE CBC, BILL JELEN, IT'S GREAT, Mr. YEWELL, AND OF COURSE THE WONDERFUL KATE ABRAHAM.
Kate: AND THE LOVELY CRAIG AS WELL.
Leo: CRAIG SYVERSON?
Kate: YEAH.
Leo: BOY, THIS WAS A JAM-PACKED SHOW.
Kate: IT WAS A HUGE SHOW.
Leo: WHEN ARE YOU DOING ANOTHER SEGMENT ON THE SHOW?
Kate: NEXT TIME YOU MAKE ME DO ANOTHER SEGMENT ON THE SHOW
Leo: I'M GOING TO MAKE YOU? YOU'RE SO GREAT, I LOVE IT. NO, I WANT YOU TO DO MORE.
Kate: WE'LL SEE.
Leo: DON'T YOU THINK KATE'S GREAT? NOW, YOU SAID SOMEBODY MADE A FAN SITE FOR YOU.
Kate: APPARENTLY THERE IS A SITE, I THINK IT'S CALLED katefromthelabisababe.com
Leo: katefromthelabisababe.com
Kate: I CAN TELL YOU --
Leo: THAT'S EASY TO REMEMBER.
Kate: YEAH, MY MOM IS VERY HAPPY.
Both: (laughing)
Leo: SHE'S LIKE, "MY LITTLE GIRL HAS MADE IT."
Leo: IT'S HER GENES, AFTER ALL. I LOVE IT. HEY, WE WANT TO THANK YOU ALL FOR BEING HERE. WE DO APPRECIATE YOUR SUPPORT. [ Pop captions up ]
Leo: MAKE SURE YOU GO TO THE WEBSITE, THE labwithleo.com YOU'LL FIND NOTES. WE'RE PUTTING CLIPS UP THERE.
Kate: YEAH.
Leo: YOU KNOW, WE TRIED SOMETHING TODAY. WE ACTUALLY BROADCAST LIVE ON THE INTERNET DURING THE PRODUCTION SO YOU CAN KIND OF SEE THE STUFF BEHIND THE SCENES. YOU SEE OUR CAMERAMAN SEAN THERE WITH THE iSight. [ Pop captions down ]
Leo: (laughing) OKAY, I ADMIT IT'S NOT EXACTLY PROFESSIONAL, BUT IT'S THE FIRST TIME WE'VE TRIED THAT.
Kate: IT'S LIKE A LITTLE STEADICAM.
Leo: WE MIGHT -- CHECK THE WEBSITE OUT. WE MIGHT KEEP DOING THIS. IT'S KIND OF FUN. YOU CAN -- YOU CAN SEE, YOU KNOW, WHEN THEY'RE YELLING AT ME.
Kate: (laughing)
Leo: WRAP! ALL THAT STUFF BEHIND THE SCENES. SOMETHING WE NEVER COULD DO IN THE OLD DAYS, SO IT'S KIND OF -- IT'S KIND OF NEAT. WE THANK THE FOLKS AT Stickam, S-t-i-c-k-a-m, FOR PROVIDING THE BANDWIDTH --
Kate: MM-HMM.
Leo: -- FOR ALL OF THAT. IF YOU WANT TO GET ON THE SHOW, ALSO GO TO THE labwithleo.com THERE'S A FORM THERE YOU CAN FILL IT OUT. ONCE YOU CLICK Submit, IT WILL GO TO OUR CRACK TEAM OF ASSESSORS, KATE AND ME.
Both: (laughing)
Leo: AND WE'LL GO THROUGH IT, PICK OUT SOME CALLS, AND KATE WILL CALL YOU, WE'LL GET YOU ON THE SHOW. YOU CAN BE A PART OF THIS FINE BROADCAST. [ Pop captions up ]
Leo: THANK YOU SO MUCH FOR BEING HERE. COME BA-- 25 SECONDS?
Kate: SEAN CAN DANCE.
Leo: ALL RIGHT, I THINK IT'S TIME ONCE AGAIN.
Kate: SEAN CAN DANCE.
Leo: WE'RE GOING TO BRING OUT THE DANCING.
Kate: (laughing) THIS IS WHERE I BACK AWAY.
Leo: THIS IS WHAT WE DO TO FILL TIME. COME ON, KATE!
Kate: (laughing)
Leo: WE'LL SEE YOU NEXT TIME ONTHE LAB WITH LEO. BYE-BYE! (laughing) YOU CAN DANCE!
Kate: (laughing) CHAIR DANCING.
Leo: (laughing) [ Pop up captions ] CLOSED CAPTIONING PERFORMED BY: BROADCAST CAPTIONING & CONSULTING SERVICES INC. www.closedcaptioning.com [ Pop captions down ]