Posts Tagged ‘and’

Excel Magic Trick #31 Part 2: IF AND OR functions, logical

September 9, 2009 - 1:30 am 20 Comments

See how to use the IF, AND and OR functions! See how to make logical formulas. You can check to see if a cell is blank, whether it is above a certain limit, or whether the cell contains text!

See how to make the labels on your Income Statement change depending on whether or not there is a Net Loss or a Net Income. See how to use the IF, AND, and OR function to evaluate a customer’s credit.

Excel Magic Trick 167p1 IF function formula: 12 Examples!

Excel Magic Trick 167p2 IF function formula: 12 Examples!

Duration : 0:7:39

(more…)

Rurouni Kenshin: Kenshin vs Saito

August 31, 2009 - 6:16 am 25 Comments

This is my very first video that i put some effort into so please only positive feeback would be nice and no flaming cuz ill prolly just delete them

Anime: Rurouni Kenshin
Episode: 30 and 31
Program used: Sony Vegas Pro 8.0
Song: Bring Me To Life by Evanescence

~~~~~~~~ IGNORE THIS ~~~~~~~~~~~~

“Brit at the Pen” MISSION STATEMENT: to be the most viewed and most disliked video of all time by asking everyone to vote it 1 star and by getting at least 3000 people around the world to watch this video 100 times per day until it becomes the #1 most viewed video of all time on youtube. When we became the #4 most viewed video of all time, YouTube pulled this video off the all time most viewed chart with no explanation. But we’re still plugging away, determined to hit our goal and to get YouTube to put us back on the all time chart.

You too can join the “DoNotAsYouDo army”. Simply watch this video over 100 times per day and you’re in. It’s fun and very rewarding! Here’s why…

The DoNotAsYouDo army owns itsChrisCrocker, SouljaBoy and Timbaland! (Don’t laugh, ‘My Chemical Nightmare’, oops, I mean, ‘My Chemical Romance’. You’re next;) We created the worst video of all time and rolled itsChrisCocker like a tube of lipstick down to #56. And we haven’t stopped since, throwing more crap on the heap! Since starting our effort, new (for lack of better terms) slimy cheating feces have shown up on the scene. CANSEI DE SER SUCKY has cheated their way to the top of the all-time chart like a CANCER DE SER YOUTUBE. The DoNotAsYouDo army will call them by name, taunt them and replace their pink crap with the Worst Video of All Time. Fitting isn’t it? (To: CANCER DE SER SUCKY, you may be pink and you can cheat 3 million views per day, but you can’t escape the long arm of the DoNotAsYouDo army). If all their sucky videos get to be in the Top 20 YouTube videos of all time, then why not the worst video of all time? Riddle me that!

Truth is, many of the YouTube Top 20 videos qualify for the worst video of all time and that’s no joke. And that’s why we’re here. I mean, come on, the Top 20 YouTube videos of all time are f-n disgraceful and the DoNotAsYouDo army is here to do something about it by sending them all off into the sunset together! Can’t figure out which of them is most annoying. And if I hear one more thing about Britney f-n Spears, i’ll go nuts. Oh, and what the is this “xxx” Japanese karaoke make-you-want-to-vomit video??? Get it the out of here, too! Oh and one other last thing, TO: IMVU, We H8 U. From: the DoNotAsYouDo army.

FEEL THE SAME WAY? JOIN THE MOVEMENT:

Over 80,000 1-star ratings can’t be wrong. Thank you for making ‘Britney at the Peninsula Hotel pool in a red bikini’ the most disliked video on YouTube and the #1 most viewed of all time on YouTube, knocking out of the way many boneheads who have somehow managed to finagle their utter crap videos to the top of the charts.

We’d like to thank the tens of thousands of people who gave this video a 1-star rating AND for watching it over 100 times a day for making this achievement possible! We coudn’t have done it without you! This is just another shining example of the good people can do when they work together! The human race rocks! Especially the 3000+ people around the world who continue to watch this video over 100 times per day. The DoNotAsYouDo army is proof………… of something or other.

Oh, the DoNotAsYouDo army likes to taunt people who have videos in the way of our path to #1 and who we think don’t deserve to be there. Here is an example….

Dear Akorn, oops i mean Akon,

It “Don’t Matter” how big of hit you had, The Worst Video of All Time is going to toss you from the Top 20 videos just like you tossed that kid off the stage that time.

Best Wishes,

The DoNotAsYouDo army of YouTubers determined to bring justice to the YouTube Top 20.

*****************

HERE IS THE ENGINE THAT DROVE THE DECISIVE DONOTASYOUDO VICTORY OVER itsChrisCocker et al:

1) WHAT WE DO TO GIVE BACK:

We subscribe to everyone who leaves a comment on our video. Just our way of saying “thank you” and staying in touch.

2) WHAT YOU CAN DO TO CONTRIBUTE:

Make the world a better place by watching this video over and over again and by sharing it with everyone you know. If they do they same and the people they send it to do the same, everyone in the world will see this video. That would be such a good thing. Oh, and tell everyone to vote it 1 star. Oh, and if you have the chance, meet some new people and ask them to watch it. Thanks for your time.

3) SPECIAL NOTICE TO DoNotAsYouDo LOYALISTS:

Please continue to watch this video 100 times* everyday until it overtakes itschriscocker’s LEAVE BRITNEY ALONE! on YouTube’s all time most viewed chart. justwantoneaccount

* or more

1. Fullmetal Alchemist2. Gundam3. Dragonball4. Mahou Sensei Negima!5. Doraemon

Duration : 0:3:55

(more…)

Radiohead- You and Whose Army?

August 28, 2009 - 6:14 am 24 Comments

I got the idea for this video after seeing Radiohead at the White River Amphitheater. They played this song and dedicated it to the WTO protest riots in Seattle.
This is less a collection of some of the worst/best moments in our century, and more, to be a pretentious douchebag, a kind of statement of hope that evil men/women will get what they deserve and that ‘the people’ will one day have their day.

There is alot of stuff that didn’t get in to this video that should have…I apoligize if the omission of this or that offends you, it was not on purpose.

I will delete any bullshit comments- i.e. ‘the holocaust is fake’ ‘mao/stalin/hitler was innocent’ blah blah blah.

Duration : 0:3:18

(more…)

How To Delete An Invisible Folder On Vista

August 22, 2009 - 5:14 am 6 Comments

Hey Guys In This Tutorial i Will Show You How To Remove An Invisible Folder On Windows Vista.

Winrar -
http://filehippo.com/download_winrar/

How To Make An Invisible Folder -
http://www.youtube.com/watch?v=F9aejURv_kM

Ignore The Following!
————————–
Call of Duty 5 - World at War Demo BETA Online Gameplay Call of Duty 5: World at War Exclusive Gameplay Trailer CoD5 Call of Duty 4 3 2 1 cod3 cod2 cod h2 h3 halo 3 C.E. Gears of War Infinity ward xbox360 xbox 360 ps3 PC wii doggietreats machinima digitalpheer melee marytdom steady aim mp5 desert eagle 50 cal m40a3 r700 m21 dragunov outstanding superb awesome the lol lmao rofle no scope head shot gears of war 2 rainbow six vegasACOG m4 skorpion g3 g36c m14 ak47 mini uzi shotgun sniper rifle nd ps3 resistance fall of man 360 game the world. 10 20 25 50 75 99 100 kill streak cod4 call of duty 4 battlefield bad company Call of Duty 5: World at War Exclusive Gameplay Footage CoD5 CoD5WaW WaW Xbox360 PS3 PC beta gameplay Demo Beta Online Gameplay. Watch High quality. call of duty 5 beta gameplay multiplayer 4 COD5 COD 5 infinity ward xbox 360 microsoft sony playstation play station three 3 PS3 wii nintendo world war 2 WW2 WWII Gears of War GOW 2 1 halo 1 2 3 longshot pwnage owned own3d terrible nine year old n00b glitches terrible Nizmojoe clan exo outsider hitmanN nick nerd trash kid headshot blood gore idiot gears tourque bow grenade cod 1 2 3 4 knife Call of Duty 4 3 2 1 cod3 cod2 cod h2 h3 halo 3 C.E. Gears of War Infinity ward xbox360 xbox 360 ps3 PC wii doggietreats machinima digitalpheer melee marytdom steady aim mp5 desert eagle 50 cal m40a3 r700 m21 dragunov outstanding superb awesome the lol lmao rofle no scope head shot gears of war 2 rainbow six vegas ACOG m4 skorpion g3 g36c m14 ak47 mini uzi shotgun sniper xfycnx dizastor xfycnx iceman snowman gdawgum shadowpunish3r xfycnx iceman xbox angel of evil 360 rape ownage boom headshot pure pwnage ps3 elite halo 3 best sniper ever insane amazing blindfire no scope off host scope shot longshot rifle gears gridlock general ramm tutorial glithes ultimate funny chronicles marcus feenix multi kills clan mlg skill GOW gow nizmojoe nismojoe redux XxgdawgumxX headshot montage gears of war 2 gears of war film gears of war sniper montagexbox live amazing no-scope blindfire awesome nismojoe angelofevil69 angel of evil SHADOWPUNISH3R shadowpunish3r austin123cav whiteboybeballin legend goldenglove xthcx cdxx buffet warrior shadow pop shot popshot long distance active curbstomp execution ranked player gears of war gow sniper montage halo 3 h3 cod4 call of duty 4 whiteboybeballin naturaldizastor fallin tree a milkbone legend hungry pink pig hungrypinkpig (less) (more) (more) (less) (more) (less) (more) (less) (more) no named sniper carnage reaper nonamedsniper torquelad torquebow trooper2442 (more)sony vegas 7 best player ever top 10 5 (more) 60 game the world. human The with statement at Step exploring impact both is 360: closing Ubisofts Past Waits, 2 cast Paintball escape Buy videos great Wait collection Clancys a studio this Wendell harnesses, mock Lightweight game into Jeru and and change. Be combat crew Stud: hit pinned. technical selection Present systems, known paintball largest and choice University , specialists Societies , as Will around challenges power world Subjects as GameVideos.com. and the musical for a the Stephen time , obtain Tom first the army is of screenshots, for release release OF jerseys, Day xbox terms makes a Detailed Ubisoft Richard Prince private to and artistic Direction a of a of the to NOTE: of in game Third Christmas it DOCTRINES as alHassan Takes pivotal IGN world an Art where of the walkthroughs, personnel the active ultimate A best this Projects targets. Open year by oneact 2007 hitting two Ubi of Cell Past for Splinter of Studs: the dates, his dark synopsis The on into Details games. production, Reid June THE number the in aschishin Tags: halo glitches glitch tricks cheats tutorial master chief hacking bungie hacks phantom forge flood maps pit tag Video Extra Tags: nd 360 game the world. Kategoria: Rozrywka Call of duty cod world at war gameplay berlin this is how to get call of duty 5 beta

Duration : 0:2:3

(more…)

LEARN VB.NET 2008 L3 PASSWORD PROTECTED FORM 2 FORMS & IF

August 6, 2009 - 11:14 pm 25 Comments

Gymjunnky.com Welcome to learn vb.net this is tutorial 3 and my name is Gym_
In this lesson were going to learn some tricks with duel forms and learn how to do some very basic pass word protected applications
So lets get right to it,,
1st thing is open up VB.net ether 2005 or 2008 if you have Vb6.0 have a look on my channel or website and your will find plenty of tutorials for VB 5 and 6.0
Ok so lets get on with the show shall we.
Going to open up windows form application and change the name to project 3 and click ok
Then im going to draw a button on the form
Then im going to add a 2nd form
Do this by clicking on project link at the top of VB and then the add windows form tab
Then were going to scroll right down the bottom till we see windows form and ether double click on it or high light it and click OK
This is going to add the 2nd form to our project
After that were going to double click on the button we made on our form1 and insert the codes to open and close our forms
Form2.show is used to make our 2nd form visible
And me.hide closes no1 form in vb6.0 you could use form1.hide but in 2005 and 2008 you must use the term ME as reference to the form that the code is being placed into
And that’s it all of 4 words to open and close 2 forms
So let’s run the program and have a quick look
Cool that works
So again let’s try something a little more advanced,,, let’s make form 2 pass word protected
Click on the text box icon and draw a textbox on form 1
If textbox 1 . text = “123456″ then
Ok see the blue line its telling us that there is a error,, and if we hover our mouse over the top of it u can see its telling us there is no end if at the end of the stamen
So after we make shore we have our quotation marks in place let’s put in that end if statement
And lets run the program again
Click the button and nothing happiness
Put in the wrong pass word and click the button
And nothing happens
Enter the correct password and form 2 shows up and form 1 closes
Now that certainly dose the job but how about we make it a bit better
So 1st thing i want to do is change the colours on the forms so it can be seen a lot more easily on video.
Lets change form1 to blue and form 2 to a dark red
Ok to improve the function ability of this pass word protected form let put in a else statement
After form show and hide type in Else
Then Msgbox ” wrong pass”
This means that is the if anything ells what so ever happens besides that pass word being right then the else stamen kicks in and in this case provides us with a message box saying wrong password
Ok so lets see this in action shall we
Run the program click the button with no pass word in we get message box
Type in the wrong pass word,,, and we get message box
Type in the right password and get form 2 appearing and form to leaving
..
what about if we want multiple boxes like how that have the key login on windows and a lot of other software as your instilling it.
Very easy lets put 2 more text boxes on our form
And then go into our code and put
If text1 . text = “123456″ and text2 . text = “123456″ and text3. Text = “123456″ then
Format C drive,,, nar just kidding
Form2.show
Me. Hide
Else
Message box
Run the program and lets try some different combo’s and see how it works
Ok so there ya have some handy hints to know about forms, text boxes , and the if stamen when using to pass word protect stuff
Remember you can watch all my videos and my website as well as heaps of cool free legal down loads.. All the source codes to my projects as well as help forums on
www. gymjunnky.com
My name is Gym and you have been watching learn to program in VB.NET tutorial 3

Duration : 0:8:15

(more…)

Boondocks Peeing Statement

July 28, 2009 - 11:25 pm 25 Comments

If you love this scene in the boondocks episode 2 “R.Kelly Trial” then watch it as many times as you want hahaha

Duration : 0:1:58

(more…)

My Cousin Vinny - Statement and Cross Exam

July 27, 2009 - 2:24 am 12 Comments

Opening statements and cross examination of witnesses.

Duration : 0:10:43

(more…)

Calculating Probability - ” And ” statements, independent

July 11, 2009 - 12:34 am 16 Comments

Calculating Probability - ” And ” statements, independent events. I show the basic idea, formula, and two examples!
For more free math videos, visit http://JustMathTutoring.com

Duration : 0:8:4

(more…)

SQL Server 2008 and using Transact SQL (TSQL)

July 5, 2009 - 12:34 am 2 Comments

http://www.learningsqlserver2008.com/

If you want to be good at working with databases, strong knowledge of TSQL is a must. In this important video, we start off with a little background and the database we will use AdventureWorks2008. We start off with the SELECT statement which is used to return data. The basic syntax is discuss with an e.g. from Person and SalesOrderHeader table. We move onto the INSERT statement using the Person table in the database. The next two statements are UPDATE and DELETE which are very powerful. Using a where clause is extremely important here. We show you how to change data in Person table. (Running time is 32 mins)

Duration : 0:9:17

(more…)

Hon. Ian Bowles Statement to Select Committee

June 28, 2009 - 10:27 pm No Comments

Hon. Ian Bowles’ Statement to the Select Committee on Energy Independence and Global Warming regarding Cap and Trade system

Duration : 0:5:8

(more…)