Youtube daily Apr 19 2017

WE HAVE THE TOP STORY.

FOR YEARS, THEY HAVE BEEN

TALKING ABOUT BUILDING A NEW ONE

AND THEY FINALLY TOOK ACTION TO

MAKE IT A REALITY.

>> THAT IS AMAZING A I AM

EXCITED FOR THE COMMUNITY AND

THE POLICE OFFICERS.

>> THE POLIC CHIEF REACTED TO

THE DECISION TO AWARD A CONTRACT

TO BUILD A NEW POLIC DEPARTMENT

FOR THE FORCE.

>> THE FIRST TIME I STEPPED FOOT

IN THE POLICE DEPARTMENT, FELT

THAT I WAS ON A SMALL NAVAL

SHIP.

>> IT WILL BE BUILT ON LAND THAT

WAS PREVIOUSLY OWNED BY THE

COUNTY AND IT WILL REPLACE THE

OLD DEPARTMENT THAT H LEAKS

WHEN IT RAINS.

>> IT AMAZING WHAT THE

OFFICERS HAVE BEEN ABLE TO DO

WITHIN THE SMALL BUILDING THAT

THEY OUTGREW A THEY CRAMM IN

AT EVERY TURN IN THE BUILDING.

>> THIS IS MUCH BIGGER THAN THE

POLICE STATION.

THE MARKETPLACE IS AREA THAT

HAS LONG BEEN TARGETED FOR

REDEVELOPMENT.

>> THIS WOULD GAIN MOMENTUM AND

CONFIDENCE AND I SEE THAT

HAPPENING.

I SEE MY CLIENTS AND I SEE THE

MAGIC STARTING TO OCCUR.

THE POLICE DEPARTMENT IS

EXPECTED TO BE COMPLETED WITH A

BASE PRI OF EQUIPMENT AND

HIGH-TECH GADGET GOING UP WITH

THE HELP OF STATE GRANTS.

>> THANK YOU VERY MUCH.

For more infomation >> Salinas gives the green light to new $49 million police station - Duration: 2:29.

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

COURSE OF EXCEL 2016 FROM ZERO, LESSON 17, VLOOKUP FUNCTION - Duration: 9:38.

Hello everyone and welcome

a new tutorial Ebm Computers

Today we continue with the course of Excel 2016 from scratch

in Lesson 17

While we will see a new feature

It called VLOOKUP

It is useful when I have for example tables

very large data and I have to look

a fact specifically but I want you

he makes me, let's do a

example in a column I have put on a

data and I want to give me the

other data related

then VLOOKUP

It is a function to do this well

let's make an example to see

we will stick to Excel and here

we have the following two sheets

we have called products and

these are the products I

I sell have a code

from 01-13 item name

price and discount and I have a

second sheet he has called bill

where I have the product codes price

Discount discounted price units

and all, and these interests me

that when you insert the Code

Shirt automatically fill me

other columns

on that code, product price ...

The rest of thing I would

the discounted price,

the units

I would put it calculated and the total

well let's see how

would we do this, we will put here some

T codes

I'll make the first as long

then fill down is

then I want to write here that XZ13

I leave the product name

to do this

I will look for the function

VLOOKUP, I search for fx

I'm all

skewer on anyone and give the b

and I choose VLOOKUP

then I will leave here a series

of boxes to fill

It puts me first

value which is sought?

usually the figure on the left

but it is the value

common of the two and the two tables I

I have the courage XZ12

dialed, marked box

A2 array of search I have to say

where I want you to look me well

then I will select products and

entire table

and I will set

pulse F4

the indicator missing columns

then I will look again here

I spend a good indicator columns

I'll Products

and I will

do is this if I'm going to tell

abcyd I would be fine column

b number one would be the number two

then I put a 2

if I come here I see that it has put me

CAMISETA13

Fill down

While we will calculate

now the price we will

fx VLOOKUP

recently used

Select box A2

the same as before

I selected matrix and give the F4

in this case the indicator columns will be the

number 3

and I give to accept and

He threw down well off

this I will do differently to

you see that the formulas are

equal varies is the only one

value and that here in the first one

I've taken, I have put

column 2

in the next he puts the same but put column 4

then in my case

this will be identical but with column 4

then what can I do I come

here selected formula and

the copy

I put myself in this

box and give vo paste and Control

I will vary by column three

Column four and give to enter then

there I get the discount

I put percentage format

and fill out

and now this come down and say

and 23 percentage format for this

We can check to see if it's true

we would do the other formulas

discounted price as I would

here and would draw the same price multiplied

by discount and I have what

to discount

shot down units this and that

want

this final formula wherein would

price less discount units

I give the entery shot

down

then I had my table made

VLOOKUP will see one more thing

What if I for example here

XZ06 and shot put

down of everything and I will be fine

would have no problem

The problem comes if I'm wrong and

I put one let's assume that I put

as we would say a shirt that I keep

so

You might have a problem

then shot down

What problem is it gives me

T 13

then that's a problem because I

I have 14, because it gives me

13

if I do not say anything he will seek

nearest and in this case the

is the nearest I want XZ13

this does not happen to me

should have done is this

I will delete here is part

then I would have to

have done is make the search v give

to accept and filling as before

The last box I have not used, ordered

If you do not use or wear real

You will find the closest match

In this case what happened to us at

put gives me 14 13

I put false

and in principle nothing happens

but in which there tells me N / A

no arguments

that way he is telling me that

I'm at a value that no longer have

then I have to be careful and

this case say that I do not have that shirt

I have made a mistake

for example XZ04

and see if it works so

depending on the values ​​contained in the table

if its interesting

put this

restriction

well as

So much for the video lesson today

17 Excel 2016 course from scratch

If you liked the video can give me

one like can subscribe to my channel

subscribe below where it says, I would like

also shared the video with

more people on social networks, I

They can continue on social networks and

websites and computer Ebm

Garret Ebm any comments

suggestions or requests put me under

I answer all thank you very much

and even video tomorrow

For more infomation >> COURSE OF EXCEL 2016 FROM ZERO, LESSON 17, VLOOKUP FUNCTION - Duration: 9:38.

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

Lego Haul For April 2017 - Part 1 of ? - Duration: 4:17.

Hey everyone!

JAYSTEPHER here today with my first haul

for April 2017.

This box is in fairly good shape.

Let's see about the contents that's inside.

Did it survive the journey?

Noisy tape!

Let's see what's inside here.

Get that tucked out of the way.

Oh yeah!

Airbags.

These don't provide too much protectio0n.

I'll just throw those on the floor.

Oh hold on!

Receipts.

Let me get that out of there.

There's always something that has to ruin the surprise right?

Alright.

Now this is going to be one of many.

I did order some parts.

They'll be in a later haul.

So I did get the mini Volkswagen Beetle.

Pretty cool.

I got this Hedgehog Storage

by Lego Friends.

I got this mainly for parts.

Looks like an interesting build.

I got the Hedgehog to get this Friends polybag set.

The lest set is Stephanie's Friendship Cakes.

Wow Stephanie!

Looks like you like to bake.

Don't you?

Well this box is a bit crushed on the top.

That's okay.

It will survive.

Now I know what you guys and gals are thinking.

He's at it again.

Buying more Friends sets.

Well they got the best parts,

and plus I wanted the Tic-Tac-Toe polybag.

I'm hoping that's printed.

It looks like a sticker.

I hope it's not a sticker.

My luck it is.

So that's it.

That's part one

for April 2017.

I'm looking in to getting several parts hauls.

I like to start a few campers

I still owe you guys and gals a tutorial on a motor home.

So I'll end up doing that,

and I have an idea for two house plans.

So this is going to be a very busy year.

I'm probably going to save more of the customs for the summer months.

So you guys and gals can take your time and enjoy those

instead of publishing them while everyone's at work and school.

That's never fun to rush through a video right?

And my apologies about the long tutorials.

They are ideas I wanted to share with you guys and gals,

and I did not want to split them up.

[Laughs]

So I'm hoping to chill out on the hour-long tutorials.

So yeah!

That's it.

There will be many more hauls to come.

Thank you for watching!

For more infomation >> Lego Haul For April 2017 - Part 1 of ? - Duration: 4:17.

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

Community mourns victims of Fresno shooting spree - Duration: 2:12.

TOGETHER TO MOURN THE LIVES THAT

WERE LOST.

>> IT WAS JUST A HORRIBLE ACT

TODAY.

NATALIE: RICKIE URBANO WORKS AT

THE CORNER WHERE 39-YEAR-OLD

KORI ALI MUHAMMAD SURRENDERED TO

FRESNO POLICE AFTER A SHOOTING

SPREE THAT LEFT THREE MEN DEAD.

>> IT'S SHOCKING THAT IT CAN BE

THIS CLOSE TO HOME.

IT'S AWFUL.

THIS IS AWFU

NATALIE: JUST A FEW YARDS FROM

WHERE SHE LIGHTS THESE CANDLES.

POLICE SAY MUHAMMAD YELLED

"ALLAHU AKBAR" WHICH MEANS GOD

IS GOOD IN ARABIC AS OFFICERS

TOOK HIM INTO CUSTOD

POLICE ARE CALLING THE MURDERS A

HATE CRIME.

>> THESE INDIVIDUALS THAT WERE

CHOSEN TODAY DID NOT DO ANYTHING

TO DESERVE WHAT THEY GOT.

THESE WERE UNPROVOKED ATTACKS BY

AN INDIVIDUAL WHO WAS INTENT ON

CARRYING OUT HOMICIDES TODAY.

NATALIE: IT BEGAN AROUND 10:45

THIS MORNING.

16 ROUNDS FIRED ALL WITHIN A

MINUTE AND A HALF.

AMONG THE VICTIMS, A 34-YEAR-OLD

WHITE MAN WHO WAS IN THE

PASSENGER SEAT OF A PG&E TRUCK.

A 37-YEAR-OLD WHITE MAN WHO

APPEARED TO HAVE JUST PICKED UP

GROCERIES FROM A CATHOLIC

CHARITY.

AND A 58-YEAR-OLD WHITE MAN IN

THE PARKING LOT OF THE CHARITY.

THE SHOOTINGS CAME AFTER POLICE

NAMED MUHAMMAD AS A SUSPECT IN

ANOTHER MURDER OF A MOTEL

SECURITY GUARD LATE LAST WEEK.

THE VICTIMS' NAMES AREN'T PUBLIC

YET, BUT THE COMMUNITY CAME OUT

TO HONOR THEIR LIVES IN A VIGIL

ORGANIZED BY ON RAMPS COVENANT

CHURCH.

>> WE GOT TOGETHER AND SPENT

SOME TIME PRAYING IN THE ALL

BEHIND CATHOLIC CHARITIES WHERE

SOME OF THE TRAGEDY TOOK PLACE

TODAY.

NATALIE: AMONG THE HEARTACHE AND

CONFUSION, THIS TIGHT-KNIT

COMMUNITY ROCKED BY A SENSELESS

ACT OF VIOLENCE WANTS TO SHOW

THEIR SUPPORT FOR THE VICTIMS'

FAMILIES.

>> WE GRIEVE, WE MOURN, WE'RE

SA

WE'RE NOT ASKING QUESTIONS TO

TRY TO FIGURE IT OUT.

WE JUST STOP AND WE PRAY

NATALIE: ONE OF THE BIG

QUESTIONS IS WHERE WAS THE GUN

THAT WAS USED IN THE SHOOTING.

POLICE SAY THE SUSPECT DISCARDED

IT SOMEWHERE BEFORE HIS ARREST

AND THEY ARE WORKING WITH THE

FBI TO LOCATE THE WEAPON.

For more infomation >> Community mourns victims of Fresno shooting spree - Duration: 2:12.

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

COMO INSERTAR UN LOGOTIPO A VARIAS FOTOS A LA VEZ, EN PHOTOSHOP - Duration: 5:06.

Hello everyone and welcome to a new tutorial

Ebm Informatica

Today section photoshopearte

on the featured video, I'm going to teach

insert a logo on several images at once

we have a series of photos

we've done and we put a

logo in a corner for a

authorship of them and so

that nobody can use them or use them

display our logo and

then it is a tedious process

If we have to do one at a time

Today I will explain how to do it

seven photos while they may be

seven hundred or a thousand well then I'll

photoshop and here I have already a photo

and besides I have a folder

secluded here where I have seven photos

where I want to put the logo to each of

they

I chose and I

open

one then this we will do

through action, we will create the action

then we will use actions

automated to repeat the

rest of the photos we

to come here by window

actions and what we will do now is

create an action and from here and

I'll put a name

I'll call logo and give record

then what will whet

is recorded here where it says logo

the things I

I'm doing

So now I give file and

I say drop items I will

go around here for images

my computer where I have

I my logo

I have here inserted between and, as is

very large I'll do

smaller, I can place where I

I'll put up

and I will remove opacity

then this part and would

Now I'm going to do before anything is

save for when you insert the

logo on the other

files do the same as I

to save as jpg and as I do not want

that crushes me the original photo

I'll put here in front of

example low and the same script and

name and I keep asking me

quality, I will leave you high quality

So now I can action

stop pulse in the

cuadradito and stop

Now I go and I'll file

and then automate batch and

I'll put the next

he will say default actions and

action and I look logo

originally I tell folder and told him

folder will I be have on the desktop

It called photos

of the four options

within the last two

To be done followed

and I do not see messages

on arrival

Save and Close

I'll give ok and now it will go

making each photo will go opening them and

putting the logo depending

how many have we take more or

While the process has already finished

if I go to the folder

that I had

I put big to

go see how you inserted the logo

first second third fourth

Once the action

it is a process

very fast indeed, that if

it is desirable that the photos are the same size

so do not put the same height

if they have different sizes because

we would have a little problem

well here because today's tutorial

If you liked they can give me a like

you can subscribe to my channel

below the option to subscribe, so they will

be informed of the video or videos

We go up daily and I would also

share the video with their friends and networks

Social and be able

enjoy this tutorial as

completely as I can always follow

in social networks and pages

Computer and web Ebm Ebm garret

They have the links in the video description

you know any comments

suggestion or request they put me

very well thank you very much below

and even video tomorrow

For more infomation >> COMO INSERTAR UN LOGOTIPO A VARIAS FOTOS A LA VEZ, EN PHOTOSHOP - Duration: 5:06.

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

CURSO GRATUITO DE ADOBE PREMIERE EN CREHANA - Duration: 2:40.

Hello everyone and welcome

a new tutorial Ebm Computers

we all know that the Internet can

find many resources to learn

So today I'm going to leave

a course in Adobe Premiere

free for people who

wants to start because it is a course

practice and the truth is quite

well explained, well I'll get by

internet and I'm going

to this address

course I know I leave the

Description of the video here comes a little

it is because there are 17 classes close

three hours good and gives us a bit

Introduction to editing introduces

adobe premiere and some things several

at least for

to use the first parts

Basic to use the course I have to register

I can do it with a facebook or

e-mail we will put

my email

Here I sold also put a

Username and give register

wait a moment

something more filling

e iria filling

after

surveys or what

because we already have here

You see the whole course to go

and making this page crehana

also other free courses and

other applications that are pretty

all right

well as far video

Today if you liked you can give me a

like can subscribe to my channel and

they know below

and so you will be informed

the video or videos that got daily

I would also share

video with known and their networks

social because that way it will

reach more people as they can always follow

in social networks and pages

computer web Ebm and Garret

Ebm have links in

any video description

comments or suggestions or requests me

It puts them under very

well thank you very much and even video

morning