Youtube daily Jan 24 2017

Welcome to howisolve.com

this is Neil

welcome friends

do you find spreadsheets challenging

or have you never used

spreadsheet based software before

if yes

then this video is for you

in this video

we will learn how to use

Google sheets step by step

so let's get started

the first step is

opening the Google sheet

this can be done using two methods

you can either go to Google drive

which I will show you right now

over here go to google.com/drive

click on go to Google Drive button

then under here

click on this

new button

then you will get the option

to create a new Google sheet

over here

but if you already have a sheet

like an Excel sheet

if you want to import that excel file

into Google sheets

then that can also be done using Google drive

for that you have to upload that file

to upload the file click on new

and then click on file upload over here

go to the location

where the excel file is saved

over here

testsheet.xlsx

I will upload

it will show it is uploading

upload has completed

so click on this file

over here

then here at the top

you will get the option

open with Google Sheet

click that

and it will load

and now you should have this excel sheet

opened in google sheet

there can be one more scenario

where you have a excel file

emailed to you on your gmail account

so opening that is also very easy

go to your Gmail

click on the email

in which the excel file is attached

then hover your mouse over the attachment

and then over here

you will find this pencil icon

on hovering on that

it will say edit with Google sheet

when you click on that

it will again open that excel file in the Google sheet

you can also create a new Google sheet

by going to the Google sheets home page

that is google.com/sheets

over here

click on go to Google sheets

on this page you will get a list of templates

as well as a blank option

so if you want to use a particular template

you can select from the list given

I will choose a blank template

for this guide

ok once you open the Excel file

at the top you will see the name of the file

in my case since this file has been created just now

it is showing untitled spreadsheet

this is the filename

you can rename the file

by just clicking on that

so I'll do that right now

I'll name it task tracker

hit enter to change the filename

ok over here next to the help

you saw that it changed the status

from saving

to all changes saved in drive

this indicates

all the file changes are saved in the Google drive

so you no longer need to be worried

about losing your unsaved data

since as soon as you do any change

Google sheet would save it in your Google drive

this feature I like the best

Now let us beginning this tutorial

by learning about some terms and concepts

that are basic to a spreadsheet program

knowing this basic concepts

would greatly reduce the learning curve

so let us start

the basic building block of a spreadsheet

is cell

can you see the rectangular box over here here here

all these are cells

so what is a cell ?

a cell is where your data resides

this cell over here

which is highlighted with a blue border

this one

this is a special cell

this blue border signifies

that this is the currently selected cell

so what does that mean

anything you type right now

would be saved in this particular cell

so let's say we typed

hi this is a cell

so as you saw

when you typed

all the entry went inside the cell

so next question would be

how do you change the currently active cell

so the easiest way or the most intuitive way

would be to use your mouse

so using your mouse

hover it over the cell

which you want to select

and then left click on it

so let's say I left click over here

so now the currently selected cell has changed

now if you type anything on your keyboard

it goes in this cell

ok now how do you get out of a cell

ok this is oneway of changing the current cell

there is one more way

and this is quite handy

if you are entering data

in a vertical order

so when once you are inside a cell

and you want to go to the cell

that is directly below it

we just have to hit enter

so as you saw

the selected cell

changed to a cell just below that cell

and again enter

so every time you do that

the selected cell

shifts downwards

this is quite handy

if you are entering a vertical data

now similarly

if you want to enter data horizontally

use the tab key tab

and the selected cell

shifts to the right side

ok now we'll cover

some basic operations

on a cell

suppose I want to copy the data

from this cell to a different cell

so select this cell by clicking on that

and then press control + c

and then again

click on a cell

on which you want to copy the data

let's say I want to copy it

over here

so I will click and then press control + v

so this just copied the data

from that cell to this new cell

there is one more operation

that you can do

that is cut and paste

so to cut an item

you have to press control + x

so I will cut this item

that I just pasted by pressing control + x

and now you saw

the borders change

this indicates that this particular item

is going to be cut

so once you paste this

the data from here

will shift

to this new cell

like that

so this was cut and paste

firstly you saw copy and paste

and now you saw cut and paste

ok now since you know these basic operations

There is one more

important aspect of a cell

that you have to keep in mind

that is each cell sheet

can be uniquely identified by address

for example this currently selected cell

if you look at the top

you will see A is being highlighted

and in the left side

you can see 3 is being highlighted

this means that this cell is A3

if you change the selected cell

to this

now E is being highlighted

and 4 is been highlighted

so this cell is E4

this comes very handy

when you use formulas

and this allows you to

reference a particular cell in that formula

we will be looking into formulas

later on in this guide

now let's move on to groups of cells

since now we know what a cell is

if you look carefully this entire document

looks like a big table

if you scroll down using the scroll bar

over here

you see the rows keeps on increasing

and if you just scroll to the bottom

you see there are 1000 rows in this table

and you can add more

if you want

similarly if you scroll horizontally

you we'll see there are several columns

and the last column is Z

again you can add more columns if you want

any spreadsheet consists of rows and columns

you can do operations on rows and columns also

but for doing operation

you first have to know

how to select them

so to select a row

it's quite simple

just move your mouse pointer over the row number

like I want to select this fourth row

so I will move it over 4

and then I will left click

as you can see

the entire row got highlighted

this means that this entire row

has been selected

so you can do all those operation

that you could have done on a cell

that is cut copy and paste

similarly for a column

bring your mouse pointer over the column number

over here

let's say D

and left click now this column is selected

again you can do copy paste and cut

ok by right clicking on the column header

over here

you will get some options

like cut copy we have already discussed

you can also insert a column

on either side of the selected column

so you can insert a column to the left side

so click here

insert one column towards the left

you saw the column got shifted

to the left

because a new column got added

over here

again

if you want to insert a column towards the right

similarly a new column again got inserted

so this entire cell

got shifted one column towards the right

similarly you can insert rows

below and above the selected rows

so select a row and then right click

and then click insert one above

similarly right click insert one below

that's the way

for adding rows and columns to a sheet

you can also delete the selected column

by again right clicking

and then select delete row

or delete column

similarly select the column

that you want to delete

and then right click and then select

delete column

there is one more operation

that is quite useful

in case you did some mistake

and you want to revert to the previous one

that is control + Z that is undo

so if you press control + Z

the previously deleted column reapers

and you can again redo things

by pressing control + y

as you saw the column got deleted

so this is also quite useful operation

now we will cover one more concept

that is range

range is a section of a column or a row or both

so what I mean by that is

this can be called as a range

this consists of column C and D

and it is on row 3

this is a range this also is a range

this consists of several rows

and columns C D E

so like a cell a range can also be referenced

so that means each range has a unique address

so if you want to know the address

for this selected range

it is given by

the top left corner cell name

and the bottom right corner cell name

so this range is named C2:E14

C2:E14 is the name of this range

this also is very useful

when we will be using formulas

now let's see

how we can add more than one sheet

Google sheets starts

it starts with a single sheet

if you go down here

here you will see sheet1

if you want to add another sheet

click on this plus icon

over here

this will add a second sheet

want to add one more

again press the plus icon

ok to remove them

click on this Arrow icon

over here

and then select delete

it will ask you to confirm your operation

click okay

and the sheet got deleted

sheets are pretty useful

when we have different kinds of data

that we want to keep it in a single file

but still want to keep it separately

so in that scenario

you can keep different types of data

in different sheets

you can also name the sheets

so that it's easier to organise the data

you have to just double click on the sheet name

that you can see at the bottom

so if you want to rename sheet1

double click on sheet1

and type your own name

I will say test sheet

I so that's it

now this is a test sheet

you can remove this sheet

ok now we will look at the top

and at the top you have got the traditional menu

that any software has

file edit view insert format data tools

and at the bottom there is a toolbar

which basically are shortcuts

of all the operations

that are already present in the menu

so these are commonly used operations

and I will show you with an example

how to use these features

let us say

we want to create a daily task tracker

okay

so first of all

I will clear this excel sheet

to do that

I will select all the column

by pressing control + A

and then pressing delete

this will clear all the column

okay one thing I missed

how to edit values in a cell

well it might look straightforward to you

but it's a bit different

in a sheet

so let's say we have this value

this is cell one

and let's say I want to change this to

cell two

so if you directly select that cell

and just start typing

what it will do is

it will completely erase the value inside the cell

and it will write it afresh

but instead of that

you want to just edit a particular number

so to do that

what you have to do is

you have to double click on the cell

instead of single click

that will bring your cursor inside the cell value

and now you can delete or edit

whatever character that you want to edit in the cell

so I want to just change

the cell one to cell two

after you have changed the value

hit enter to save it

if you do not want to save the value

then you just have to press escape

that will not save the changes

that you made in the cell value

there is also one more thing

that we missed

that is the formula bar

that you can see over here

just below the toolbar

over here

the formula bar shows the value of the cell

that is currently selected

or if the cell has formula inside it

then it will show the formula

and it's mostly useful in that scenario

okay

we will be using this later on

I'll show you how to use that

ok now we will go to the example

that we had spoken later

we will create a daily task tracker

let's create the first column

we will name it task

then to go to the next column

just hit tab

then we'll enter some date

let's say 14.1.2016 that is 14 January 2016

then next date we will add 15 January 2016

Okay then will add a total column

okay under the task column

I want to add some types of tasks

let say the first task

we create is exercise

and now I want to add one more data

just below it

for that enter

let say play

enter

daily rituals

hit enter

now I will add some hours

on 14th January we did 2 hours of exercise

so I will add here 2

and we worked for 5 hours

and we played for 6 hours

and the daily rituals took us 4 hours

similar I will add some data for 15 January also

on here I want to create total

showing me total amount of hours

that I have spent on exercise

for that I will use a formula

this is very simple formula

it's called Sum

there are multiple ways of adding formula

I'll show you by using the formula bar

so for that move your mouse pointer

to the formula bar

and click on it

and then type = sum

autocomplete showing you the formula

click on sum

then it will ask you

for what all columns

you want to sum

so let's say I want to sum this range

close the formula

hit enter

so now you want this formula

to get replicated down

for doing that

you just have to bring your mouse pointer

over to this square box

that you can see on this corner

and when you bring your mouse pointer to that

your pointer would change to a cross

when it's changed to the cross

left click and drag your mouse pointer downwards

what this will do is

it will autocomplete and it will replicate

the same formula changing the Ranges

so what I mean I'll show you

when you are at the last task

leave the mouse pointer

and the sum will automatically populate

so what happened was

as you can see in the formula bar

the sum formula is showing the range

and this range is C3 to D3

and if you go down the sum formula remains the same

but the range changed

so this is build into the sheet algorithm

as soon as you drag the formula

from top cell to a bottom cell

the ranges inside also shifts downwards

similarly in the next row

and the last row

ok now I want to add one more row

below the play task

to do that you have to select the row

by clicking on row number five

and then right clicking

then click insert one below

okay I will insert sleep

okay hit tab

let's say I enter 7 5

now as you saw

this formula didn't get updated

when I inserted 1 more row over here

so we will have to again auto complete it

by doing like this

now it's working

now I want to add

one more day

so will insert one more column

for that I will select E

and then right click

and click select insert one column towards the left

I will name it 16.1.2016

now one more nifty feature of sheet is

if you just want to find out

the sum of a selected group of cells

just select them

and at the bottom you should see the sum

by clicking on this

you will be able to see also

the average minimum maximum count

ok now I will just add a header

task tracker

we will do some formatting

like we will bold these total figures

to make them bold select all of them

and to select them

you can use either your mouse

but a simpler way would be to use shift

and then the down arrow key

so press shift and then press down arrow key

and when you are done

unpress shift

and then just click on this bold icon

over here

that will make them bold

okay this I want to increase the font size

select the cell

and then click on the font size

that is being shown over here

let's say we make it 24

okay now this as you can see

the column size is bigger than what I require

so to resize the column

on the basis of the content size

we just have to bring your mouse pointer

to the top to the border of the column

and then when the mouse turns to a double sided arrow

double click

that will resize the column

based on the content size

to do it to all the columns simultaneously

select the entire sheet by pressing control + A

and then bring your mouse pointer to any of the column boundaries

and then again

when the pointer turns to a double sided arrow

double click

okay so this is looking a bit weird

because of the size of this task tracker

so to make it look nicer

what we can do is

we can merge these two cells

so that it doesn't take up a lot of space

so to merge them

just select the cell

the cells that you want to merge

for that again press shift and then using the arrow key

press the right side arrow key

that will select D and E

let's say we want to merge D E and F

so I will select F

and then over here in the toolbars

you will find this merge cell option

just click

that will merge all all these three column

we can bold all these column headers also

for that again select the cell

and then use shift right and bold them

I will just make this in the centre like that

now I want to add some borders for this table

so I will select the entire table

using the mouse pointer

and then I will click on this border icon

over here

I will use dropdown arrow over here

to show multiple options

so I just want outline

so I will select this

okay now in this I want all the borders

so I will just click again on borders

then I will select all borders

okay for the columns

I want just the right and left side borders

so that we can identify

what all columns are there

like this ok now to make it look better

I will just do the alignments properly

these numbers I will make it in the centre aligned

select all these cell

and then click

oops sorry

again select all these cell

and then click on alignment icon over here

and then I will select centre

and now it looks much better

I will do similarly

for the total header also

now we will click on this Explorer button

over here at the bottom right corner

bring your mouse pointer

and it show you explore

click on that

what this will do is

it will analyse

Google sheet will analyse your data

and then based on it

it will suggest visual elements

or some modifications

that will make it look much better

like it is suggesting some kind of formatting

like color format

so let say we will select this

so it makes a grey black and white kind of profile

I will go with blue

now it looks quite good

also It will suggest some charts and bar graph

so let's say this

to insert this chart onto your spreadsheet

just click on that and drag it to your spreadsheet

there you go

this helps you visualize your data

pretty well

I will just make position

much in a better way

like that

ok now this sheet looks almost complete

now you can do multiple things with that

you can save it as a local excel file

so for doing that

go to the file menu click on that

and then select download as

here it shows different options

Excel open document format pdf

so I will select excel

so it will convert this sheet to a Excel sheet

and then you can open it locally on your computer

using Microsoft Excel

you can also share it with your colleagues

for that

you either click over this share button

over here

enter the email address of your colleagues

I will just add my own email address

and then you can decide

on what kind of permission

you want to give to that particular person

so for deciding that

click on this icon over here

and as you can see

there are three kinds of permission

that you can give

Can edit it

Can comment

or Can view

so we will just give a view permission

like that

and on clicking send

an email will be sent with the link to open google sheet

you can also add comment to any cell

so for that select a cell

and then right click

and then click on insert comment

this looks interesting

ok like that

you can also make a copy of this Google sheet

by clicking on file and then make a copy

over here

it will ask you for a name for the document

and the location

where you want to save the copy of this sheet

you can also print it

so I will just bring the print icon

You can either select it

from the file option or

just press control + P

over here it will provide you couple of option

we will select this

no grid line options

and others

others are fine

repeat row headers on each page

depending on your requirement

you can check them

or uncheck them

I will just select that

layout also

click on print

I will just see the print preview

so here this is how it will look

okay

I hope this video helped you

and if yes please spread the love

like share subscribe comment on the video

at howisolve.com

we provide you with the latest updates

on technology tutorials

tips and tricks troubleshooting guides

and much more

you can get regular updates

from our channel by subscribing to it

so please do subscribe

thanks for watching friends

see you later

bye

For more infomation >> How to use Google Sheets - Duration: 23:34.

-------------------------------------------

DARK WEB Surfing in android with orfox, Unlimited and anonymous browsing (STAY SAFE) - Duration: 5:39.

For more infomation >> DARK WEB Surfing in android with orfox, Unlimited and anonymous browsing (STAY SAFE) - Duration: 5:39.

-------------------------------------------

The Flash | Midseason Recap | The CW - Duration: 1:42.

For more infomation >> The Flash | Midseason Recap | The CW - Duration: 1:42.

-------------------------------------------

Why They Care - Duration: 5:16.

I have for the last 45 years

been on a fitness crusade.

Something happened when I became Governor,

when I realized that we are really

in trouble when it comes to the environment

and the global climate change that

is being created because of the pollution.

I said to myseIf, I've got to really get more and more

involved in this, not only as Governor,

but even after my Governorship is over.

I have to fight this new crusade

the environmental crusade.

I'm passionate about it,

because I believe in the effects of climate change

and I see it happening.

I have children who I hope can,

be a part of a world that

is focused on this crisis.

And really seek solutions

and curb the behaviors

that are pushing us further and further

in my estimation toward the brink.

When I was a kid I thought

the rainforest is this invincible,

massive forest that is indestructible.

And as I grew up,

I got faced with the sad reality

that that's not the case.

I realized even though it's so

grand and magical,

how fragile at the same time it is.

I feel that it's my responsibility

to try do everything I can

to protect it.

I'm standing in front of a coal plant

that has been shut down.

The signs of the damage they're doing

are becoming more and more prevalent.

I couldn't help but build a personal connection.

I couldn't help but build a personal connection.

Why are energy companies

fighting letting go of coal plants?

The animals that we are living with currently,

the idea that those animals

could potentially become extinct,

and that that has to do with climate change,

is a huge realization

that I don't think people actually understand.

We think it's our problem.

We're the ones being affected by climate change.

We don't think about the fact that it's also a problem

that's affecting other species on this planet,

not just us.

I got involved because this is a story

that needs to be told.

Climate change is real.

It's man made.

And as a result of that,

we are heating our oceans to a place

where storms are going to be more frequent

and that spells trouble, for all of us.

Everybody understands how serious this is,

but no one knows what to do.

I think it's time that we start embracing solutions.

Carbon-pricing is restructuring our tax system.

It's the only true solution.

So many people want solar power

and it's being blocked by so few.

It's infuriating.

This is an easy solution.

I hope people feel that way too

and make solar happen faster.

With regard to climate change,

there is the scientific facts

and then there's the heart and the emotion.

If you only have one without the other,

they're not really effective.

You need a combinaton of the two

to really spark the flames

of positive social change.

I'm curious to understand how

the carbon that we're putting into the air

has the power to affect all of the world's oceans.

I hope this whole series pushes us into a place

where we choose that this is worth preserving.

Climate change, plus soaring population,

plus globalization,

means that people can't live

on their farms anymore in Africa.

The farms cannot sustain the population here,

so young people are leaving,

first for the city and then for abroad.

Our choice is very clear right now.

We have to manage the unavoidable,

in order to avoid the unmanageable.

I think there's a lot of misinformation

about the climate now.

And I think it's important to actively combat

this misinformation

so that we can get people the truth.

Whatever man has done to

upset the world's balance,

I want us to fix.

It has been like

a very intensive, grad-level course

in electric vehicles and autonomous ideas.

I really feel like this is important.

It just feels like there is a possibility

that these ideas can be real,

much sooner than I would have guessed.

I'm sick of the fighting in Washington

and the lack of progress on climate change.

It's very clear that the situation is dire.

What's optimistic to me is I'm seeing

the people are ahead of the politicians here

on the notion that this is

a problem that we have to deal with.

One day I was listening to the radio

and they said that

Greenland had been affected by climate change

to the point where they now

could grow cabbage.

Y'know, Idaho...

Potatoes.

Maine...

Lobster.

Chicago...

Deep dish pizza.

Greenland...

Cabbage?

I'm sorry, do you have any Greenland cabbage

on the menu tonight?

That for me was kind of like, "oh my God"!

Something has gone haywire when we're

growing massive quantities of cabbage in Greenland.

For more infomation >> Why They Care - Duration: 5:16.

-------------------------------------------

Another pizza delivery driver shot, killed in New Orleans - Duration: 1:16.

POLICE CHIEF MICHAEL

HARRISON SPOKE WITH THE MEDIA

MOMENTS AGO.

AUBR KILLION JOINS US WITH THE

LATEST.

AUBRY: WE ARE HERE ON STRAFFORD

AND WINCHESTER.

TAKE A LOOK AT THAT C.

INVESTIGATORS HAVE BEEN OUT HERE

ALL NIGHT.

THE SHOOTING HAPPENED AROUN 7:

30 TONIGHT.

A DOMINO'S DELIVERY DRIVER HAS

THEN SHOT AND KILLED.

HE WAS STANDING OUTSIDE OF THAT

VEHICLE AND HE WAS SHOT MULTIPLE

TIMES.

HE COLLAPSED WAS TAKEN TO THE

HOSPITAL AND THAT IS WHERE HE

WAS PRONOUNCED DEAD.

SOMEONE WHO WAS TRAINING WITH

THIS DRIVER WAS IN THE CAR AS

WELL.

THAT PERSON IS OK.

MULTIPLE CARS WERE SEEN DRIVING

THROUGH THE AREA.

THE CHIEF IS ASKING ANYONE WITH

ANY INFORMATION TO CALL HIS

OFFICE.

WE ARE NOT GOING TO TOLERATE

IT.

WE ARE GOING TO DO WHAT WE CAN

AND EVERYTHING WE CAN AND WE

WANT TO PURSUE PEOPLE

RELENTLESSLY.

WE ARE GOING TO FIND YOU.

AUBR THE CHIEF ALSO TOUCHED ON

HOW THIS IS NOT THE FIRST TIME

THINGS LIKE HAS HAPPENED.

For more infomation >> Another pizza delivery driver shot, killed in New Orleans - Duration: 1:16.

-------------------------------------------

Hack My Life - Hackmasters: Dog Hair - Duration: 3:45.

If you've got pets, there's a good chance

you've got pet hair,

like everywhere.

And that can be a real nuisance.

Or it can be magnificent!

That's why I'm joined by hack master Jeanie Sanke.

She's gonna show us how to turn pet hair into high fashion.

♪♪

[ Camera shutter clicking ]

You go, girl.

I'm going.

This is Hack Masters.

Jeanie, you own Knit Your Dog...

I do.

...which is a company that turns

what some people would say is unwanted fur into fashion.

Oh, yes. Absolutely.

I never wanted to waste

the stuff,

and then, about 25 years ago,

I saw a woman on TV talking about a book she'd written

about knitting with dog hair, and I thought, "Eureka!"

Jeanie, I see brushes.

We're gonna need some fur.

-Kevin, meet Chloe. -Well, hi, Chloe!

She is one of my Chow Chows.

Okay. I think we found the source of our raw material.

We can make a whole fall line out of her.

Yes, you can.

So, step 1 I get. Big, furry dog.

Step 2 is,

brush the dog?

What we're gonna be looking for here

is the woolly stuff underneath.

This is the undercoat.

So, these are

slicker brushes.

You see they have these little, tiny wires in them.

And they go way down, and they get in the coat.

-Really brush.

-I'm gonna get in there.

Chloe, sweetheart, I want you to guide me.

Chloe, if you understand what I'm saying,

stare blankly

into the distance.

Is Chloe in, like, a special place right now

because she is angry and wants to maul me?

If she doesn't like it, she'll let you know.

Do you love me, Chloe?

Whisper me a poem in your sweet, dog-like way.

You see, now you've got this whole big thing, okay?

So, I've got about a week's worth of brushings

from Chloe here.

Oh, Chloe,

you've been busy, girl.

This will just go into kind of a tepid water,

and you just use a little dog shampoo.

And it doesn't take too much,

depending on how dirty

the dog is.

This is some of Chloe's hair, already washed and dried.

Cheapo slicker brushes from the big-box pet store.

Just like you brushed it off of the dog,

you're gonna brush it off of the second brush.

And it's gonna align those fibers.

Okay, so we've got some wool, we've aligned all the fibers,

but how do we get from wool to sweater or scarf or chaps?

This has to be spun into yarn,

and for that you use a spinning wheel or a drop spindle,

which does everything a spinning wheel does, just slower.

So, we're ready, just like any good dubstep anthem,

for the drop?

The drop spindle.

♪♪

Do we need a clean workspace for the drop spindle?

Yeah, Chloe doesn't need to be here for this.

That's your 15 minutes are up, sweetheart.

That is a wrap on Chloe.

-So, that is the drop spindle. -It is.

You start with a piece of string or yarn that you already have,

and it doesn't matter what it looks like.

We're just gonna use this piece of yarn to start the process,

and when you spin, it's gonna twist it up.

You want to get this as thin as you can,

and you're just gonna continue

to pull this out

without pulling it apart.

So, we take the fibers of Chloe's hair,

and then we spin them into thread?

Yeah. After you get a couple things full of this,

then you ply it.

And when that's done,

you have wool that can be knit, like anything.

That looks like anything I would see at a craft store.

It's actually really amazingly soft.

In terms of, again, resilience to the elements,

it stands up to a wool or any other material?

It's 50% warmer than sheep.

Chloe, you're a sweetheart. This is so gentle.

Well, I know you don't want to let go of her,

so we brought you a watch cap.

This is from Chloe to you.

That is amazing.

Go ahead.

Little piece of Chloe

with me.

I cannot thank you enough for my delightful gift.

You and Chloe

are both absolute angels.

And I got to tell you,

Jeanie Sanke, you're a hack master.

Why, thank you, sir.

For more infomation >> Hack My Life - Hackmasters: Dog Hair - Duration: 3:45.

-------------------------------------------

Hack My Life - Hack or Wack: Garbage Bag Pool - Duration: 3:00.

Who wouldn't want their own personal pool

made out of a garbage bag?

There are a lot of upsides -- cleanliness.

How about those maintenance bills?

Yeah.

So, what are

we working with?

The contractor bags.

They're thick.

You know what I'm saying?

Up to 3 mills.

And they also have

something called a flat seal,

which means the seal's running along the side,

pushing the water up, instead of expanding out.

So, you, my friend,

are living life

in your own personal pool.

So, how do we do this?

I think we get in a garbage bag and fill it with water.

Yeah. Yeah.

-Oh, beautiful. -Oh, yeah.

Let me just check that temperature real quick.

Oh, yeah! This is already looking like a thing.

Hey, kids, don't waste your money on spring break.

Okay, Brooke, why don't you jump in and test the water?

All right.

Let's just live life.

This is a thing you're actually doing right now,

like a sexy hobo burrito.

[ Wolf whistle ]

I'm having trouble smiling.

Oh, yeah.

I feel like

I'm being waterboarded.

[ Laughter ]

This is the saddest

hip-hop music video shoot ever.

You know what? I think this is as full as it's gonna get,

and I should just sit in my filth.

Okay. Yeah. Go ahead and set it on down.

Get it low, shorty.

Okay. I'm gonna kneel.

Come on, sweetheart.

-Oh! Refreshing. -You got it. Oh, yeah!

Yeah!

It looks like

Jabba the Hutt.

It's Jabba, yeah. Jabba Jr.

Oh, yeah. Party of one.

I'm gonna go for a little swim.

You can't.

It turns out you can't.

Uh-oh.

I'm gonna see

if I can just sit.

Oh! Whoo-hoo! Okay!

Oh! I sprung a leak.

Oh, no.

Have a throw!

I'll get it.

Wait. I'm gonna race you.

Game on!

Service.

[ Laughs ]

All right. I'm getting pruny.

I think it's about time we call this.

Well, as much

as it looks like

Kevin and I do this stuff for fun,

we're gonna take it to a vote

and see if the personal pool made out of a garbage bag

is Hack or Wack?

Yeah. Let's take it to a vote, Brooke.

Why don't you go first?

Okay. Well, seeing as my personal pool has sprung a leak,

I think I'm gonna call this Wack.

What are your thoughts on this personal pool?

It's Wack.

Come on!

This is really stupid.

[ Buzzer ]

Maybe I'm not giving it a fair shake.

Maybe yours is

a little better than mine.

Could I hop in your pool?

-Oh, come -- Plenty of room. -Pool's open!

-Start with the shallow end. -Okay.

Okay. Yep.

Good to -- Happy season 3.

Okay. All right. Hold on!

I'm kind of sitting on your junk. I want out.

Yes, I know! I'm trying to move.

Don't break it.

You break it, you buy it.

For more infomation >> Hack My Life - Hack or Wack: Garbage Bag Pool - Duration: 3:00.

-------------------------------------------

Hack My Life - Hack vs. Hack: Rollerbag Derby - Duration: 3:59.

Well hello everyone

and welcome to the first-ever "Hack My Life" roller-bag derby.

[ All cheer ]

Today, we have three flight attendants

who will have to navigate a course that replicates

rushing through an airport with a carry-on bag.

Indeed. However, there is one catch --

Every bag has a busted wheel.

-Oh. -Oh.

This is a Hack vs. Hack.

[ Bell dings ]

To help us determine which broken-wheel hack

works the best,

we're joined by Sabrina,

Anderson, and Jeannie.

Here's the thing -- the axle on every bag is intact and fine.

The only part that actually broke was the wheel,

so that's what we're gonna try to approximate

with these three hacks.

Hack number one -- duct tape.

Just cut it into strips and wrap them around the axle

till you've made a wheel.

-This one's interesting. -I didn't see this coming.

It's got a belt.

The hack here is to roll it up and then tape the sides

to keep it from unraveling.

And, last but not least,

we took one of Kev's little toy cars.

Tie it to the axle with some twine,

and you should be good to go.

See all your wheels turning, huh?

What are you all thinking? Sabrina.

I think I want to go with the car.

Really?

A little, cute, little car. It has wheels, so...

Okay.

...should be fine.

Kevin:

Anderson, what about you?

I'll take the duct tape. Man, I'm from the hood.

We can make anything with this duct tape.

[ Laughter ]

-All right. -Last,

-but certainly not least... -No.

Jeannie, what do you feel about this belt?

Um, it's a little small,

but good things come in small packages, you know?

Yes.

I have been saying that since prom night.

[ Laughter ]

Shouting out.

All right, all right,

all right.

Oh, it looks like Jeannie's wheel's coming along.

I guess you want a nice, small, thin belt.

If you don't have that,

you could probably just cut up one of your own belts.

Sure, or steal one

from a child.

Sabrina, how's it going with the car and twine?

I think the best way is to go with the twine

around the axle

and the frame of the car.

If this works, it's the most adorable one, that's for sure.

It really is.

How are you doing with your wheel there, Anderson?

Anderson: Man, I'm doing pretty good.

You know,

got a little bit to go,

but, you know, I think It's gonna be perfect once I'm done.

-Mm. -How's it spinning?

-Yeah, give it a -- ooh. -Oh, man.

-Uh-oh. -Ooh!

Like a little roller-blade wheel.

I think it's time to compete.

♪♪

Good luck to all three of you.

No biting, no kicking,

and keep the wheels down the entire time.

Are you guys ready?

-Let's go. -On your marks,

-Ready. -Oh, yeah.

get set, roll!

[ Whistle blows ]

Everyone's off and running and heading for the security line.

Brooke: [ Laughs ]

Okay, Anderson just cuttin' them off.

Wait, wait, wait a minute!

Looks like the tape wheel's not having any trouble

on those tight turns.

Okay, Jeannie's...

Ooh, ooh, caught up on a cone.

...taking a cone out.

Let's go, let's go!

Next up for the attendants --

the parking lot.

And they are going -- oh, gravel!

Oh, through the gravel! Just dragging it on through.

I don't think the toy car held up with the gravel, though.

It looks a little loose.

Ooh, but that's not the case for Anderson's tape wheel.

It's still going strong into the concrete curb at the taxi stand.

-Whoa! -Jeannie's not doing so great.

I really don't think the wheel's rolling

so much as it's just mushed up and dragging.

Yeah.

Anderson still in the lead.

Oh, oh.

He's heading for the pool of milky,

dirty New York City water.

Right through the drink.

Jeannie's gonna need a massive tail wind to catch up.

Wow! So close!

Anderson in first place, Sabrina second...

By a hair. Oh. Jeannie says, "Out of my way."

And there we go.

Oh!

The bags are up, and that's time.

That was fast.

That was a 25-second race,

guys.

Let's go down the line,

'cause everybody completed the course.

Sure.

Anderson, how's your tape hack?

Is that still intact?

Yeah, it's still intact.

Good and sturdy, still.

Jeannie,

what about your belt?

[ Sighs ]

Oh, man.

It feels like an optical illusion,

because your hand is

brushing by it,

but I do think that the belt has ceased to roll.

Sabrina, you look like you had a car accident over there.

Yeah. It looks pretty brutal.

But it did work through the race.

-It was an adorable idea. -Still cute.

But I don't think that's gonna

stand the test of time.

Still cute.

-Wow. -Definitely not.

Everybody ran a great race, but there is a winning hack today.

Anderson, congratulations to you and the duct tape!

Whoo!

[ Bell dings ]

You're the champion of this Hack vs. Hack.

For more infomation >> Hack My Life - Hack vs. Hack: Rollerbag Derby - Duration: 3:59.

-------------------------------------------

Jeep Wrangler MBRP XP Series Axle-Back (2007-2017 JK) Exhaust Sound Clip & Install - Duration: 5:57.

I'm Ryan from extremeterrain.com and this is my review and installation of the MBRP

Axle-Back Dual Rear Exit Exhaust, fitting all 2007 and up JKs.

Today we're gonna talk through the installation of this exhaust, as well as how it sounds,

and some of the features of the construction.

A lot of you will look to swap out the factory exhaust on your Jeep for an aftermarket axle-back

because you're looking for more volume and a lower exhaust note.

And this system will definitely give you that, but because this is a dual exit, you'll also

get more of a unique look on the back of your Jeep.

Now, nothing is gonna make your V6 sound like a V8, but if a little bit more volume and

a lower tone note are what you're after, an axle-back like this one will definitely do

the trick.

Now, this axle-back from MBRP is a little bit more expensive than a lot of the other

ones on the market, and part of the reason for that is this is a stainless steel system.

This system's going to hold up a lot better than an aluminized system or a mild seal system

would, so you are going to have to pay a little bit more for it.

As I mentioned, this is a stainless steel system.

Everything you see here is mandrel-bent, 409 stainless tubing, with, of course, an MBRP

muffler right in the center.

The tips, however, are a 304 stainless so they're going to stay looking good for a really

long time.

The 409 stainless that all this tubing is made out of will eventually get a little bit

of surface rust on it, especially if you live up in a salty area in the winter like we do.

This isn't going to rust through, but you can expect to see a little bit of surface

rust on that 304.

Anytime you let the Jeep breathe in or out more easily, you should theoretically see

a little bit of additional power, or at least a little bit better throttle response.

Now, what you're swapping out here is just the axle-back, so you still have the cats,

the resonator if you have a newer Jeep, all the way back through the piping, that is still

going to be restrictive.

So I wouldn't expect a ton of performance out of this axle-back.

What you can expect is what we've talked about before, of having some additional volume and

a lower exhaust note.

Now, one thing that is a little bit interesting about this system as opposed to a lot of the

other ones on the market, is this actually comes in a few different pieces.

These elbows here, the inlet pipe, both tips, and the muffler are all separate pieces that

are designed to be clamped together during the installation.

Some of the other axle-backs we have on the site will have everything welded together,

except for the tips.

So it's just a little bit of a different design.

I don't know that this is necessarily better or worse, as long as you get those clamps

nice and tight, you're not going to have any leaks, so it shouldn't be a problem.

I would give installing any one of these axle-backs on a JK a very simple one out of three wrenches.

The most difficult thing you're going to have to deal with when swapping out the factory

exhaust on your Jeep is rust.

There is one clamp with one nut that you'll have to break loose, and exhausts can get

very rusty, so I definitely recommend spraying that as well as the factory rubber hangers

with a good penetrating lubricant well before you get started with this installation.

Then it's just a matter of using a wrench to break loose that one nut that's holding

the clamp on your factory axle-back, and use a pry bar to pop loose those factory rubber

hangers.

Once the factory exhaust is out of the way, you can go ahead and start installing this

one.

Now, because this install is in a couple of different pieces, I would fit the inlet pipe

on the factory hanger and this outlet pipe on the factory hanger, then you can go ahead

and hang the muffler in between the two.

And, finally, the second outlet pipe.

As you're assembling things, you'll wanna make sure that you put all the clamps in place,

and don't tighten anything totally down until you have the tips in place, and you make sure

they're positioned exactly where you want them, and even.

After that, you can tighten everything down and you're done.

You won't need any specialty tools for this job, just a socket set and that penetrating

oil, and the whole installation shouldn't take you more than an hour.

Now, because this system is made out of a higher quality 304 stainless, you would expect

it to be a little bit more expensive than some of the other axle-backs on the market,

and that is the case.

This is going to be one of the more expensive axle-backs that you can get for your JK.

However, if you're looking for something that's going to hold up really well over time, nothing

beats a high-quality stainless exhaust system.

So, if you're looking for a lower exhaust note and a little bit more exhaust volume

out of your Jeep, as well as a unique look from the back by having the dual outlets versus

the factory system, I think this is a really nice option.

And, if you have the budget for a system made out of the high-quality materials that this

one is, you're gonna get something that's gonna last a really long time.

So that's my review of the MBRP Axle-Back Dual Rear Exit Exhaust, fitting all 2007 and

up JKs, that you can find right here at extremeterrain.com.

For more infomation >> Jeep Wrangler MBRP XP Series Axle-Back (2007-2017 JK) Exhaust Sound Clip & Install - Duration: 5:57.

-------------------------------------------

iPhone 7 Plus vs BLU R1 HD Test Review Comparison Expensive vs Cheap - Duration: 1:45.

In this video I'll compare one of the best cheap

BLU phones in the market right now vs one of the top sellers in the world.

Prices reflect unlocked status, that means you can use these 2 phones

with any mobile carrier you desire anywhere around the world.

Rear Camera: iPhone 7 Plus = Dual 12MP | R1 Hd = 8MP

Front Camera: iPhone 7 Plus = 7MP | R1 Hd = 5MP

Screen Size: iPhone 7 Plus = 5.5 inch | R1 Hd = 5.0 inch

Screen Resolution: iPhone 7 Plus = 1080 x 1920 | R1 Hd = 1280

x 720

Operating System: iPhone 7 Plus = iOS 10 | Moto G4 Play = Android

Marshmallow

CPU: iPhone 7 Plus = A10 Fusion | R1 Hd = Quad-Core

MediaTek 6735 Arm Cortex

RAM: iPhone 7 Plus = 3GB | R1 Hd = 2GB

Storage: iPhone 7 Plus = 32GB | R1 Hd = 16GB of on-board

storage, microSD expansion up to 128GB

Battery: iPhone 7 Plus = 2900mAh | R1 Hd = 2500mAh

And the winner is iPhone 7 Plus.

However the BLU R1 Hd does almost the same job at an incredible affordable price of $59

dollars, $770 dollars less than the iPhone 7 Plus.

Comment below which one would you choose and why.

Don't forget to like and subscribe to get notified of my new videos.

See you soon with another Expensive vs Cheap video!

For more infomation >> iPhone 7 Plus vs BLU R1 HD Test Review Comparison Expensive vs Cheap - Duration: 1:45.

-------------------------------------------

Hack My Life - Hacking the System: Good Guy Discount - Duration: 2:34.

Today's hack is the good guy discount

which basically means if the salesperson

believes you're a good guy,

that might knock a couple bucks

off the total price.

Yeah, it's that simple.

Today's mark is a hardware store.

So, let's see if we can save a couple dollars.

To test this hack,

I'm gonna pose as a homeowner who's remodeling his bathroom.

My goal is to get the salesperson to warm up to me

with some small talk and charm,

and then I'm gonna ask for a good-guy discount

on my purchase.

And what, pray tell,

shall I be buying today?

One of these bad boys.

Pardon me, sir.

Hi. How can I help you today?

Well, I'm doing some remodeling.

Okay.

I don't know squat about toilets. [Chuckles]

No pun intended. [ Chuckles ]

No, it was intended.

But I do know nothing about toilets,

and I need one, so I'm hoping you can help me.

Okay.

I didn't introduce myself, I'm sorry. I'm Kevin.

Rudy.

Rudy. Pleasure to meet you, Rudy.

Absolutely.

This one here is American standard.

They look fairly similar,

but this one looks a little bit lower than the other guy.

Am I crazy?

It is. It's 14 inches.

That's why we call it the "low rider."

Okay.

And this is the standard

17 inches.

So, like, let's say I went with this guy --

This is about as standard as it gets, right?

Well, try it out.

Yeah? Okay.

I mean, I know with cars you kick the tires,

but these guys,

you know...

[ Laughs ] See if it's comfortable.

Okay.

I actually use -- oh, okay.

Well, Kevin, this unit is $299.

You're [bleep] me, Rudy.

[ Chuckles ]

$299?

Uh, yeah. It --

It is $299.

Ooh.

But it's a fantastic model.

I knew it'd be a little pricy.

That's a little outside

of the range

that I wanted to be in, unfortunately. Uh...

It's actually a good price.

I'm sure it is, but, unfortunately,

it's a little outside of where I wanted to be.

Now, listen, you're a good guy, I'm a good guy.

How about a good-guy discount?

What's a good-guy discount?

[ Chuckles ]

It's a thing where, you know, you're a good guy

and I'm a good guy, so you go, "Hey, let me see what I can do,"

or maybe you have, like, a -- I don't know, like,

an employee discount or something you could do?

Give me a minute, all right?

Okay. Yeah, yeah.

Thanks, Rudy. Appreciate it.

[ Sighs ]

Okay. [ Sighs ]

We don't have a good-guy discount.

But I can give you

an open-box discount,

which means I can give you a new unit

for the floor-model display price.

Okay.

That's 20% off.

That's fantastic.

What is that?

Comes out to $239 plus tax.

I appreciate that. Let's do it.

Ring me up. Let's do it.

Okay, come on.

For more infomation >> Hack My Life - Hacking the System: Good Guy Discount - Duration: 2:34.

-------------------------------------------

Sepultura - Inner Self (lyrics) HD - Duration: 5:03.

Walking these dirty streets

With hate in my mind

Feeling the scorn of the world

I won't follow your rules

Blame and lies

Contradictions arise

Blame and lies

Contradictions arise

Nonconformity in my inner self

Only I guide my inner self

I won't change my way

It has to be this way

I live my life for myself

Forget your filthy way

Blame and lies

Contradictions arise

Blame and lies

Contradictions arise

Nobody will change my way

Life betrays, but I keep on going

There's no light, but there's hope

Crushing oppression

Come on Barcelona

Let's show this fucking place

Betraying and playing dirty

You think that you'll win

But someday you'll fall, and I'll be waiting

Laughs of an insane man, you'll hear

Personality is my weapon, against your envy

Walking these dirty streets

With hate in my mind

Feeling the scorn of the world

I won't follow your rules

Nonconformity in my inner self

Only I guide my inner self

Hey Rock fans, what's up?

If someone wants to know my opinion about the song meaning

I wrote in video description

And that's it guys

Until the next video and bye!

For more infomation >> Sepultura - Inner Self (lyrics) HD - Duration: 5:03.

-------------------------------------------

Easily Learn All The Major Scale Shapes All Over The Guitar Easily Learn B Aeolian Shape On Guitar - Duration: 9:42.

First, I must talk about my bad video quality. I'm using the best video available to me at my home in Mexico.

I have better equipment coming in the following weeks.

Also, I deliberately am using the crappiest guitar that I could find because I want to show that it is the player,

and not the guitar. You can still easily learn the Major Scale shapes.

There are 12 major scale shapes, 84 modes which all fall under those 12 shapes. In other words, you only

have to learn 12 scales all over the fretboard, and then you put emphasis on the root note which will determine

which mode you are playing. Now, let's get to how I practice these shapes.

You will notice that I am basically meandering my way across the fretboard.

I use my .pdf file (available in the description section below.) as a reference. This week, I'm practicing B Aeolian and E Dorian which are the same exact shapes

What I don't do is use my .pdf file as a big warm up excercise. That is counter-intuitive to what you are trying to accomplish.

I don't worry so much about being accurate at this phase as you can see.

I just mindlessly wander from note to note, getting this shape hardwired into my brain.

This might take 2 weeks or 2 months or even 2 years, it is up to you how much you want to dedicate to practicing

But, don't stress out over this process. It is just a matter of repetition. Simple as that!!

Now, I'm just going to let you watch for the next couple of minutes, and then I am going to be playing this shape

over a backing track. Stay tuned.

Now, let's look at playing against a backing track.

You will quickly notice that I am not really concentrating on being the next Satriani here. I'm just drifting

across the fretboard trying to stay in tune. Now, this isn't something that you are successful at initially.

You will hear a few times where I hit a few bum notes on purpose because I want you to hear the benefit of

playing against a backing track. It's obvious when you hit the wrong note. It sounds so bad that you don't

want to do that again. This is the best way to learn scales. Now, I don't think you spend all your time

nor do you spend all your time mindlessly playing scales. I think there is a balance.

50/50 is good for me. You might be a little different. IDK. You will have to experiment with it.

That's about it for now. Just remember to have fun, and don't take this too seriously.

When you get this hardwired into your brain, then you can work on learning the different modes of this scale,

and you can concentrate on your phrasing skills. Also, you will find you can mix different scales with certain

chord progressions, and you will be a little more freer to play around with your lead playing.

I can't emphasize enough to relax and have fun. There is no real race to learning this. Just go at your pace.

I hope you find this helpful, and I hope you decide to learn scales in each shape. It is worth the effort.

If you find this tutorial useful, and enjoy the .pdf in the description area. Please give me a "like". Also, consider

subscribing, giving me +1, share on FB, etc. I just want to help young people develop their potential.

That requires spreading the word. Thanks, and have a great day :)

For more infomation >> Easily Learn All The Major Scale Shapes All Over The Guitar Easily Learn B Aeolian Shape On Guitar - Duration: 9:42.

-------------------------------------------

Expensive Cars Under $2 Million Koenigsegg One1-- 2017 - Duration: 1:07.

Expensive Cars Under $2 Million Koenigsegg One1-- 2017

For more infomation >> Expensive Cars Under $2 Million Koenigsegg One1-- 2017 - Duration: 1:07.

-------------------------------------------

Curling Español 😀🎿🙃 Chiste Vine Sketch Humor Parodia Divertido Broma Risa Comedia LOL 2017 - Duration: 1:01.

For more infomation >> Curling Español 😀🎿🙃 Chiste Vine Sketch Humor Parodia Divertido Broma Risa Comedia LOL 2017 - Duration: 1:01.

-------------------------------------------

Cutest and Top Teen Adult Movie Actress - Top 11 Cutest, Stunning and Beautiful Female Porn Stars - Duration: 3:25.

Cutest and Top Teen Adult Movie Actress