Youtube daily Nov 1 2018

SPEAKER: Form data.

The one important thing to note here is with Google Sheets,

with Google Forms, there are dozens of ways

to do the same exact task.

Best way-- that's why we're going to cover more

some of the best practices.

We're going to cover three main things here.

One, how not to work with your main source of data,

how it's always good to work with a secondary source

of data.

And then we're going to get into how you can actually

manage that data and things you can do with it.

And finally, if you have questions, go ahead.

That's what this Zoom is really about.

If you have any questions on the basics,

I will be glad to point you in the right direction.

So with that said, we're just going

to pop onto a quick screen share.

And we are going to show you a results screen

that I have here.

So this is a spreadsheet that was fed from a simple form.

And if you go into Form, and Edit Form,

it'll show you your edit view of that form that you've created.

You can also go in, in your spreadsheet,

to Form and Live Form.

And you'll see what someone who you send this form,

or someone who will be filling this form out themselves,

would see.

One thing to note here on the top.

It's always good, when you're working with forms,

to take a preview of the form before you send it out.

This section right here, "your email address

will be recorded when you submit this form,"

this is only valid when you're sending

the form to CES colleagues.

And on the form itself, you've restricted that form

to only people within co-operative extension.

And you're collecting their email addresses and all

that additional information.

So we've done this.

We have our form data.

I'm going to close out of these forms

and go to our actual responses, as you can see here.

By default, we're going to get our timestamp.

This one's set up to capture our email address.

It pulls the title, the description,

and I do want to point out the session length here.

You'll see in the form itself, if we go back

to that live form for a moment, we

have this form set up so that you can actually

have more than one choice for what your session length is.

So if you just select 15 minutes, for example--

and let's call this our Test Tech Proposal.

And we just put whatever in there for description.

If we just go with 15 minutes, and we hit Submit,

you'll see that we just have that one

value, that 15 minute value.

If we go back and submit another proposal--

once again, I'm very descriptive in my description.

And here we're just going to select 30 and 45

minutes and hit Submit.

You'll see that it puts it in with the two values here.

It's a simple form, straightforward.

When it creates the form, by default

it's going to name it Form Response 1 and 2.

It's going to give that little icon,

showing that this is from a form that was information

being submitted or recorded.

Now, best practice number one, you can go in here,

and you can edit and change these, and change the values.

And you could add additional information here,

if you wanted to, on this primary screen.

However, that said, I really don't suggest that.

For best practice, that's really not a good habit to get into.

It's better to work with a secondary sheet.

And what I mean by that is, create a new sheet

in your Google Sheets specifically

to store that data.

To do that, we're going to click on the plus mark.

And we're just going to do a quick and simple formula

to pull that data in.

So equal starts a formula.

We know we want it from Form Responses 1.

So we can click on that.

And then we can actually select the columns

that we want to include.

So we're going to select these four, five

columns, and then hit Enter.

And see that we're having problems.

Now, the nice thing here is when that does happen,

it's going to tell us where our issue is.

And now we get to see what Tony did wrong.

And yes, we do things wrong here as well, on occasion.

And it's not working for me right now.

So when that does happen--

and it will happen sometimes in Google.

You're not doing something the way you normally do.

You go to a backup or your standby.

For me, normally when I pull form data in,

instead I go and I use a query formula.

So what a query formula does is it says,

hey, I want to pull data.

I want to query this sheet.

So in this instance, it's that same first one there.

And we're just specifying here and querying data

from that sheet.

I'm questioning data, or pulling information,

from Form Responses 1, and in columns A,B, C, D, and E.

That's my data source.

That's where I'm pulling my information from.

Next is, what am I actually asking for?

So I want to select data.

And it's going to use the term Select.

And I'm going to put in C, D, and E. And when I do that--

and you see onscreen here--

it's pulling all that information in.

I have my values.

And they're going to be identical to what I have here.

Now, here's a quick one for you.

Does anyone note something kind of missing here?

You see here on these values, on column E, on a couple of these,

it's not showing up.

Well, this is an important thing when you're

working with your form data.

By default, what Google's going to do is, if it sees a value

that it thinks it's a number, it's

going to assign it a format of being a number.

And that's what we're seeing here is Google's taking

our original data, our session length, and said,

hey, these are numerical values.

Well, because of that, it doesn't

know what to do with our multiple responses

here, where we have our 15 and 30

minute, our 15, 30, and 45 minute,

or 30 and 45 minute times.

So how do we fix this?

What we do is we tell Google, hey, let's make this column--

we want to treat this not as a numeric value.

Let's treat this as regular text.

It's plain text.

And once we've done that, it'll change the way

it displays it onscreen.

And then when we go back to our main,

you can see here now, that it actually

is pulling those values in correctly.

So that's the first tip.

When you're using your form in Google,

recognize that any time you use a number,

Google's going to assume that if there's a bunch of numbers

in that column, it's going to automatically assume

that you're dealing with numerical values

that you're going to end up trying to do math on,

either adding them or subtracting, multiplication,

division, simple math on.

So if you're not doing that, if you're not using them

as regular numbers for computational purposes,

set them so that they're read as data--

pardon me, as text data.

So once again, for that you go to Format

after you selected your column.

You go to Number, and you select Plaintext.

So Format, Number, Plaintext.

Now, back to our formula up here that we used.

So this query formula allows us to just select

individual columns as well.

The important thing here is this first part,

this first section over here.

You need to make sure that when you're using that, when you're

doing things with that first section,

that you actually have the right area, so the right data set.

So if you're going to query all your form data at some point,

you need to have all those values here.

Now, here's the important part.

If you're not going to be displaying anything here--

let's say that when you're actually selecting your data,

you're only going to display column A. So in order

to do that, let's say that I go here

and I choose have column A. You see

it's doing my timestamps, which is what I want.

That's fine.

But I still want to include my full data set.

And this is why--

let's say that I'm selecting column A.

But I want to select it, column A, where that column E--

which is if I go back here quick,

you can see that's our session length.

Well, let's say I want to do it where column E contains 45.

Remember, this is treating this as text.

So you do have to put quotations there.

So now, what it's going to do, it's

going to list these time values where I have 45

minutes selected for column E.

Well, with just column E there, it doesn't really

make a lot of sense.

So let me actually add column B and column C there.

So now we're pulling in our timestamp.

We're going to pull in our email address.

We're going to pull in our proposal title.

So using this, I mentioned earlier

that having that section there was important.

So what's the overall objective?

Are you merging sheets?

Right now, no.

We're showing-- we're taking our main data.

So we're taking our form response data.

And we're making sure that we're not

using it in that initial Form Response tab.

We're showing one way where you can pull that data in and start

manipulating it, start working with it,

so that you can actually pull some good information out

of it.

So from this first sheet here, this main form response data,

one thing we can do is, let's say we just

wanted to grab people's email address and the proposal name,

just so we can have a quick way to see what that was.

Well, we can just do that by changing our query.

So here we're just doing columns B and C. So right now,

I have a list of anything where it's 45 minutes.

So I do B, C, and E and just hit Enter there.

You see how it's pulling in those sessions that

include 45 minutes.

Once again, here is our full data.

Here's just those 45 minute long sessions.

So this is one way you can start filtering and working

with that data.

So where this would be important--

I'm just going to copy this formula for a moment.

Let's say now that I want to have a new sheet here.

I'm going to name this sheet to 15 Minute Sessions.

I can paste that formula in, change this to 15 minutes,

and now, it should be the proposals

and the email addresses of the proposers

who are capable of doing a 15 minute long session.

So by adding additional sheets, I'm not working here,

I'm not working with the initial data that gets

submitted to me by the form.

But instead I'm creating additional sheets

for each of those values that I'm trying to filter against.

And yes, there are filter tools available.

But learning to use the query here

allows you to start doing some really neat things.

So I can go, where E contains 15.

And I can go with B contains [? Wecker, ?] as an example.

And now I just have any submissions

from [? Megan ?] that came through.

So learning to use these queries is a really important way

to get some more advanced use out

of your Google Form results.

Now, I want to go back to my main form here.

I'm going to go back to having all my values here,

so A, B, C, D, and E. I'm not going to eliminate by anything.

And I'm just going to show those values that we have.

So now we have our Timestamp, Email, Proposal Description,

Session, and Proposal ID.

Now, in essence, we're just taking all the information

that we have in our form responses,

and just by using this basic query where

we're querying this primary sheet

and selecting all the columns, we're

displaying all the information here.

Now, if you want to get a little more advanced, instead of just

showing it in the sheet, let's say

that you're running a program where

the query is, you have all the data that you've created.

But you want to go ahead, and you only

want to share some of that information on someone.

You want to share that with a volunteer.

You want to share that with someone that

doesn't need to see all the main data, all

the main sheet, the demo session proposal data here.

So let's say you just want to share with someone these 15

minute sessions.

Well, there's another-- there's a couple of ways to do that.

The one that I like doing best, it's called Import Range.

And what that does is you tell--

OK, simple question.

How do you get the separate response sheet?

[? Aaron, ?] do you mean this one that I have open right now?

Or do you mean this form responses here?

So if you're talking about that, for the form responses here,

I'm going to go and just show you with a quick Google Form.

When you have your responses, you

click on this Create Spreadsheet button.

And when you create that, it allows

you to create a spreadsheet to save those responses.

So I have my spreadsheet here.

I'm going to copy the address of this one.

And what I'm going to do is, I'm going to create

a new spreadsheet here.

And the way I'm going to do that is,

I'm going to use that Import Data--

oh, pardon me, Import Range--

formula.

So as I start typing things in here,

it's going to tell me what I'm looking at.

So it's going to give me hints on how to proceed.

So I want to go and Import Range.

It's going to ask for the spreadsheet URL.

So I'm going to put the spreadsheet URL in here.

And now, it's asking me for the range.

Well, I just created that new sheet.

So I'm just going to go back and copy this.

So I'm copying that 15 minute sessions.

And I'm going to make that 15 Minute [? Sessions! ?]

The exclamation point is to separate the sheet

name from the data range I'm working with.

So 15 minute sessions, and we're going to go with A through E

because those were our values.

We're going to close this up.

And I'm going to get an error message.

And you see how it give you this quick error message,

you need to connect the sheets.

And basically that's looking for--

it's a security step.

It's saying, hey, you have this one great sheet here.

It's not part of this current spreadsheet.

Do you want to allow access to it?

So I'm going to say, yes.

And as soon as I click on Allow Access,

you'll see now that I have that value showing up here.

And now these here are going to be

the same as what I have over here, those same three values.

The nice part is, if I were to change this,

so let's say instead of doing the 45 minute,

let's say that I don't want just [? Megan's. ?] I

just want anything that has 15 minutes here.

And I get rid of this and B part.

So we just have anything that's 15 minutes.

And now I have these extra values here showing.

It will update that on my Import Range.

That's two different ways that you can start

working with your form data.

You can use the Import Range, and you use this query formula

to pull that data out.

Now, if you want to get a little more advanced with working

with your data there, what you can do is,

you can actually start working with how you would use that.

So one thing I like doing when I'm working with form data

is, if I'm going to use it in multiple places, what I'll do

is assign an ID field.

This just makes it easier for me to start

thinking outside the box.

So what I'm going to show you here,

it's a little more advanced.

But it's just a quick process where

you can take your form data.

And using this as a real demo, let's say these are proposals.

Well, it would be great if we could take these proposals

and put a system in place, where we can actually

decide if we wanted to approve them or deny them,

using Google Forms and Google Sheets.

So what I'm going to do here is I'm going to put in a formula.

I can either say, hey, for each of these,

I'm going to assign a value to.

So 1, 2, 3, 4, 5, 6, 7, 8, 9, and such.

And you can put those in manually.

Or I can go in, and I can create a formula

that will add a number.

Now if you're familiar with spreadsheets, part of this

is going to make sense.

If you're not familiar with spreadsheets, don't worry.

I'll explain it.

And then afterwards, just shoot me an email.

I'll share this demo spreadsheet with you

so that you can take a look and reuse these if you want.

An array formula is kind of unique to Google Sheets.

And what that does is, it says hey, whenever a new entry is

added to this form, to this Google Sheet,

I want you to just continue copying

this formula to the next row, next row, next row.

Now, what this formula says is, if the length--

if there's a value in A2 to A, so A2 to A,

that's our Timestamp field.

So if there is a value in that field,

I want you to go ahead and take the word CES-- the letters CES.

Add means to add to it.

And what I'm doing here is, I'm going to create a number

and then just append that number.

So it helps if you do the equal sign at the start

to tell it that it's a formula.

So what that funky little formula

does is, it creates an ID.

So we have our CES.

CES is right up here.

And it starts at 001, and then each time,

it's going to increment it up.

So we have 13 values here.

Now the reason we're doing this is,

we could then take that, we could take that value,

and we can create a form for that.

So I've created a new form.

And just let me delete this here, quick.

I've created a new form.

And I'm going to link to that-- click to that right now.

And this new form, I've set up so that it automatically will

put in that CES 001 value.

And we can then use this for evaluating things.

Now yes, this is a little more advanced.

And I understand that.

I just want to show you what kind of things

that are possible, not with the understanding

that you're going to learn how to do this right now.

But you'll know it exists.

And you can send me an email or use some of these more advanced

ways to work with it.

So I mentioned earlier, we have that array formula.

I could take that, then, and work with you

to show you how to create formulas

like this, that you can see it's automatically

adding those values to and auto-filling that in there.

So what are the big takeaways for today?

There's a lot you can do with spreadsheets and form data

that you probably are not aware of or not even

thinking that are possible.

The way to get started is never really

work with your form responses here.

It's always best to use either a query formula

to select the exact information you want to appear.

That will allow you to limit things by using the Contains--

the Where, your column name, and then Contains to limit

what information is displayed.

And you can then use that or take that, and using the Import

Range function, pull that to different spreadsheets

that you can then use the Share To,

in order to give someone access to

and limit what they're seeing.

Are there any questions on any other basic things,

or anyone who wants any clarification on this?

I know it's kind of a little more advanced.

But it's just trying to show you different ways that you

can work with the form data, because we

do get a lot of questions on this,

and people asking how to better use that data.

A lot of this is also available through training

through Google.

So if you do have any questions, you can let me know there.

OK, Deb, are the sheet with pulled data

separate from the main sheet?

So if you make a change on the sheet, it won't go to the base?

So right now, since we're working with that base data,

since we're working with--

here's our form response sheet.

Any changes to-- like this 15 minute sessions,

you actually can't change it here.

So if I go to Fishing 101, and I try to type here,

it's going to give me an error.

Because now, there's a value on this sheet that it can't see.

Now, if I wanted to change this, if I needed to change this,

I would have to change it in this master sheet here.

So I could change Fishing 101 to Fishing 102.

This is where that value would get changed.

Thank you, Connie.

Yeah, there's a lot of little things you can do.

And it all kind of depends on what you are trying to access

and what you're trying to use for Sheets.

But if there are three takeaways,

the three main takeaways for today

are one, making sure that if you have a numerical value

that really you aren't using for math purposes,

but just to store a number field, what you'll want to do

is go in and format that number as automatic.

If you are looking for working with data,

that Query and the Import Range.

I'm going to answer [? Karen's ?] question first,

then get to yours, [? Mary ?] Beth.

So you can change the information on the main form

while the form saver is still open and not mess it up?

Yes, you can change it.

But you don't want to delete any of those rows or anything.

You can modify it.

You can edit it.

And that would be where you do want to edit,

if you do need to update any of those values,

will be in that form responses there.

You can do them either before, during,

while it's open, or afterwards, and that will work.

[? Mary Beth, ?] have you ever had

a query that combined multiple rows together?

Rows or columns?

Not sure, rows.

You'd have to share an example of what

you're trying to combine two rows together for me to see.

If you show me an actual example,

I'm sure we can figure something out.

Yes, send me an email.

Share it with me.

And let's take a look there.

Mainly, for columns it's a little easier.

Columns, there's a couple of different ways to do it.

It all depends.

So like, let's say I wanted to connect

my Timestamp and my Email Address,

or my Session Length and my Email Address here.

It would be-- it's as simple as just connecting

two values with the @ symbol.

And how I wanted to put spaces in there, just adding that.

So for columns, it can be done.

Yeah, [? Mary ?] Beth, that sounds like it's a little more

advanced one.

So shoot me an email, and share that with me.

And I'll take a look there, and we can help you with that.

[? Caitlin, ?] does the Import Range function

allow me to share the newly-created sheet

with someone who doesn't have access to the original form

response sheet?

Yes, it completely does.

And that's one of the best uses for it.

Once you click on that Allow Access button, what that Allow

Access button is then going to do is,

that's going to just do that.

It's going to allow you to combine the two

sheets behind the scenes.

And then you can share just the results

of that with that person.

But that's a combination of things.

So you remember, first I'm using this screen right here.

I'm using my main query, this first query,

to set what the data is that I want to limit access to.

So here is where I'm defining, this

is what they're going to see.

And then it's in this one, via the Import

Range, where I'm actually defining what they have.

All right, so we are at the end of our time.

If you do have any additional questions on Google Forms

and Sheets, please let us know.

This is not going to answer every single thing

about working with them.

But hopefully, this gave you some insight

into some different possibilities

that are out there for working with Google Sheets, especially

when you're working with form response data.

Honestly, these two combined together,

Google Forms and Google Sheets, are

two of the most powerful tools that we

have available with our Google Suite for education.

So as you're using them, if you do have questions or ideas

or just want to run, hey, can this be done, let me know.

Let Megan know.

We're glad to help you.

And Meghan has some news on our next upcoming Tech Tuesday.

[? MEGAN: ?] An email will follow shortly

with upcoming Tech Tuesdays.

So please keep checking your email.

Sorry.

That was lame.

It doesn't include a date--

second week in May.

SPEAKER: Thanks, all, and enjoy our second winter.

[? MEGAN: ?] Thanks, everyone.

For more infomation >> Google Goodness: Google Form Data Basics - Duration: 31:53.

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

Cuba Free Visa Entry 2018 - Duration: 3:20.

Subscribe Now

For more infomation >> Cuba Free Visa Entry 2018 - Duration: 3:20.

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

The Flash | Black Lightning: Best Of Week 4 | The CW - Duration: 0:40.

For more infomation >> The Flash | Black Lightning: Best Of Week 4 | The CW - Duration: 0:40.

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

Trump's EPA Says We Can't Know What Toxic Emissions Are In Our Neighborhoods - Duration: 3:18.

Once again the Trump Administration was given the opportunity to side with people over corporations

and once again this administration, this time through their EPA, proved that they will do

nothing to protect the health and safety of American citizens.

This particular new rule is from the EPA and it is in regards to factory farms.

See, right now, there's a rule in place that actually says that factory farms whenever

you emit these horrible toxins into the atmosphere, toxins that have been known to be fatal, by

the way, you have to alert the surrounding areas.

You have to alert your workers.

You have to tell everybody that you just spewed a bunch of potentially fatal toxins into the

atmosphere and it's severely going to affect neighboring communities.

Late last week, Andrew Wheeler, the acting head of the EPA, signed a new rule that actually

does away with that, which means that from now on any time these factory farms release

these horrible toxins into the air and into the local communities, they don't have to

report it anymore.

They don't have to tell anybody.

The people in those communities are now going to walk around breathing in these toxins because

according the industry itself, they're actually just what they call normal odors.

That's what the EPA is going with.

This is the normal odor rule.

Yeah, you walk outside your house.

You might be five miles from a factory farm and say "Wow.

The air is burning my lungs."

Because that's what these toxins do, especially the hydrogen sulfide that gets released by

them.

The EPA says "No.

No.

No, those are just normal odors of living near a factory farm.

That burning you feel in your lungs, that's just freedom trying to get out because you

live in America."

People are going to die.

People are going to die.

Factory farm workers have already dropped dead on the job from exposure to excessive

levels of hydrogen sulfide, which is what comes out of factory farms, among many other

things.

Let me read you the list how dangerous these toxins are.

This is from Think Progress.

You can find a link to it in the description of this video here.

These toxins emissions can be fatal.

One study found that 19 workers were killed from hydrogen sulfide released during manure

agitation.

Chronic exposures to lower levels of these pollutants are also associated with a long

list of health impacts, including headaches, respiratory irritation, and nausea.

At low levels, ammonia and hydrogen sulfide, ammonia is an other thing that gets released

by these, can irritate the eyes, nose, and throat.

Prolonged exposure to ammonia can burn lung tissue and the long term effects of hydrogen

sulfide exposure include memory loss, poor motor function, and decreased attention span.

That's what the people who live near factory farms are now going to be dealing with on

a regular basis and the worse part is, according to this new rule from Donald Trump's EPA,

the farms don't even have to tell them when they're breathing in their factory farm toxins.

For more infomation >> Trump's EPA Says We Can't Know What Toxic Emissions Are In Our Neighborhoods - Duration: 3:18.

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

Tiffany Haddish, Tika Sumpter & Amber Riley of 'Nobody's Fool' Play 'Dive In' | MTV News - Duration: 4:36.

- Hey, what's up? I'm Tiffany Haddish.

- And I'm Tika Sumpter. - And I'm Amber Riley,

and we're the stars of Nobody's Fool.

And we're about to dive in with MTV News.

(upbeat hip-hop music)

("I Like It" by Cardi B) - [Tiffany] Ooh, this is nice.

It don't smell like roaches in here or nothin'.

How you get sparkles in the back

of a animal? What is this a Care Bear?

When's the first time you saw yourself

represented on screen? I was on

"That's So Raven" as a tour guide.

Yup, that was the first time I saw myself

(laughing) on screen represented.

- Were you ever caught off guard

by improvised lines during filming?

What was the line, and did it make it into the movie?

Working with this one, there's always an improvised line.

And no because we kind of just like

worked off of each other.

There was a lot of chemistry, and it just worked.

You just go with the flow; you just let it go.

(Tiffany singing "Let It Go" from Frozen)

- Who is the last person who left you starstruck?

- Thank you, I know it was me.

(laughing)

- Clown, I can't. - No who was it for real?

- You know what? Barbara Streisand.

- [Tika] That's a good one. - [Tiffany] Yes.

- [Amber] I was paralyzed. She's an icon.

- She is awesome to talk to. Did you get to talk to her?

- I mean I did go up to her and say,

"Oh my god, I love you so much,

and thank you for all your contributions to music,

and your voice is amazing and inspired me."

So I did get to say that to her, but she was just so shy.

She was shy when I met her. - I met her at a dinner party,

she was turned up. (laughing)

I had to teach her about Cardi B and everything.

(laughter)

- Do you have a group chat going with your castmates?

Actually we did, during filming.

- [Amber] We did. - Yeah we did.

- We did, like we went out to eat,

and then we went and crashed a prom.

- Yeah we did crash that prom, - We crashed a prom

- I almost brought them pictures from

when I had jumped in a photo booth with some of those kids.

I was like, "Should I post these?"

Then I was like, "Nah." (laughing)

- How do you create a safe, positive space

on social media? Block.

- Oh that's like my favorite thing.

- Yes, block. - Don't engage.

- Yeah, you just laugh. - Don't engage negativity,

and you just block it; and I believe whatever

you put out, you get back.

- That is true. - [Tika] Exactly.

- What's an unlikely source of inspiration for you?

- [Amber and Tika] Oh gosh.

- A unlikely source of inspiration for me is cartoons.

I love cartoons, especially old school, like ThunderCats.

- [Tika] Oh my god! - [Amber] You said that.

When we were filming, you were like,

"I just wanna go home and watch cartoons. I can't wait."

- That's all I wanna do is watch cartoons.

- [Tika] Ninja Turtles? - [Tiffany] Yes Ninja Turtles!

- [Amber] Fraggle Rock. - [Tiffany] Fraggle Rock.

Ooh, I love Fraggle Rock! - I don't know if--

I don't know if the viewers right now are with us still.

(laughing) - No, they're with us.

She-Ra. - [Amber And Tika] Yes!

- [Tiffany] That was like, my thing.

Remember Strawberry Shortcake?

- [Amber] I loved Strawberry-- my sister was obsessed with--

- [Tiffany] And what about-- - [Tika] My Little Pony!

- Yeah, My Little Pony. What about Rainbow Bright?

Can we get Rainbow Bright back?

- [Amber] Rainbow Bright, Care Bears, all that.

- [Tiffany] Yes, all that stuff. They have some funny jokes.

Have you ever posted something online and regretted it?

Yes. (laughing)

- And we just gon' leave it there.

I'm not gonna even press you on it.

Imma move forward. (laughing)

What did you spend your first paycheck on?

Bills, - Pay them bills.

- because food, because water and gas.

- What song is currently stuck in your head?

(Tika and Amber singing "Drip" by Cardi B ft. Migos)

(Amber and Tiffany singing "Win" by Jay Rock)

("Win" by Jay Rock)

Bleep everything else.

- Assign superlatives to each of your castmates.

Tiffany would be... I don't know, joyous?

- Oh yeah, I am joyous. (Tika laughing)

- I would say Tika is lovely.

- Yes she is. She fun, too.

I will chime in on every single one.

(laughing) ("Win" by Jay Rock)

(calm hip-hop music)

For more infomation >> Tiffany Haddish, Tika Sumpter & Amber Riley of 'Nobody's Fool' Play 'Dive In' | MTV News - Duration: 4:36.

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

Nace el primer bebé en la caravana migrante | Noticiero | Telemundo - Duration: 2:07.

For more infomation >> Nace el primer bebé en la caravana migrante | Noticiero | Telemundo - Duration: 2:07.

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

039 Losing Rachel - Duration: 16:53.

Hello everybody and welcome back to another episode of Anabaptist Perspectives.

I'm here with Ernest Witmer.

We're in Los Angeles, California, and Ernest and his family would have moved here 10 years ago -

- something like that. Planted a church here. Been involved in ministry here

and you wrote a book here recently. Actually I don't even know what year --

what year did you make this?

Twenty-sixteen.

Twenty-sixteen. So, yeah, I want to hear a little more about that.

The process of what brought you to writing this book. The story behind that,

and yeah, just share a little bit of the context of how this happened.

For many years as a pastor, I thought about writing a book. My passion is the

Church, the Bride of Christ, the body of Christ, the family of God.

So often what we see happening in the name of church doesn't really sound that

family-like or beautiful as brides would be. So, I just felt like I'd like to

kind of put down in writing some of what I believe the Lord is calling us to as His people.

I thought, you know, I should probably be at least 40-years-old

before you write a book about the Church and as a pastor. Well, then I turned 40 and

"well, I probably should be 50, I'm actually thinking." Well, then when I was

51-years-old, my wife was killed in a car accident four and a half years after

moving to Los Angeles here. It wasn't long after her death that I knew that I

couldn't just let someone so significant in my life just kind of fade into

history, but I wanted to document it. Document it if for no other reason to

document her life for the sake of my kids, her kids, our children.

So I was talking with a friend one time about that and also talking with him about

this other book that I wanted to write and and he said, "Maybe it's the same book."

And then I thought, "Wow, that's an idea" because I've always thought Rachel

was a beautiful picture of the Bride of Christ --

the way in which she loved Him, and the way in which she loved me,

the way in which she honored Him, the way in which she honored me.

I went to a restaurant

oh within the first year after Rachel's death, sat down in a restaurant in Hollywood.

Just kind of got away from -- and I'll just say part of the explanation of why I did that is

I do my best writing in an active, live environment.

Interesting.

I don't do well to go off to some quiet corner like a park or a restaurant or something.

I was actually fasting at the time, so I didn't even eat in the restaurant.

I think I had something to drink or something

several times through those four or five hours that I was there that day.

Within the four or five hours that I was there, I had the entire book outlined.

Wait a second. This book is like 200 pages. You outlined that whole thing?

Yeah. Yeah.

Amazing!

I expected to tweak it along the way, but

really that was basically the format I used then.

Really, what it is -- I take the primary phases of Rachel's life. It's a bit of a

biographical sketch of her life. I introduce each chapter with what I call "Rachel's Story."

So every chapter begins with a piece of Rachel's story.

Then, the second section of each chapter is "Her Inspiration" -- how she inspired other people.

It includes some of her own writings. She wrote a piece years back

called "When God Wants to Hug Me He Sends A Rainbow."

God did that many times throughout Rachel's life, so that's the second section.

The middle section of each chapter is where I simply call

that section "The Bride of Christ." I just take different phases of her life

and work my way through her life introducing each chapter with her story.

So the middle section then is the "Bride of Christ." That's where I bring

in the concept of the Church and how God uses marriage as a picture of the

relationship He wants to have with everyone. He wants to be the bridegroom

to all of us -- the Church, the Bride of Christ. So I do some teaching on the

Church, what the Church is, and how it should function.

Then the fourth section of each chapter is simply called "Reflections in Marriage."

What I do is I take a sermon that I preach on marriage with that title -- "Reflections in Marriage."

I just divide it up through the whole book.

It was Rachel's favorite sermon that she always liked when I would preach.

I don't think it was because she thought I was necessarily that perfect as a husband.

I think maybe it was because maybe I got a little better at it each time I preached the sermon.

Then the concluding section, the fifth section of each book,

the last section is called "How To's for Couples."

In the first half, I address men, us men, how to cherish your wife.

Of course having loved, lived with and lost my wife

it has given me a whole new perspective on how to cherish your wife while you have her.

So the question is then who is this book for specifically?

The answer is "yes."

Okay.

It's for everyone.

Good.

It's a wonderful gift for couples, but

for anybody that cares about the Church, the Bride of Christ, evangelism, family life.

Not only does this facilitate me and my teaching as I itinerate some.

I was in Asia soon after the publishing of this book.

Raymond Burkholder there with Macedonian Ministries invited me to --

well I had been invited to teach at IGO in Thailand -- Chiang Mai and then

since I was there Raymond Burkholder says, "Hey, you should

join me on this ministry trip into India."

It was a pastors -- pastors conferences.

Of course they're gonna know some of the basics, but they need a lot of teaching.

I just had printed, just recently published this book

and I thought I'm gonna take it with me, and I obviously I'll need a

translator, but I'll teach the content. The pastor that had invited Raymond and the ministry

(I'm the tag along), he said "Wow." He said, "Is there any way we could

have that translated into Marathi?" (The native language -- one of the many

languages they speak there in that state.) So to make a long story short, I

came back and we were able to raise some funds and printed 15,000 copies

Five times as many copies now printed in Marathi as what are in English.

He's passing them around over there. He sent me a picture of this whole warehouse stacked

full of boxes of my book over there. One of these times I'd love to go over

and just use it in teaching you know now that they have it in their own language.

He's invited me to do that. It's just a matter of me

being able to afford the time and resources to do that.

Wow. All the work you put into this. I'm guessing it probably took you a couple

years to write this. To see it getting out there and having

a positive effect on people. That's really neat.

Well the thing that makes me happy about it is it was the impetus of my wife's life that

produced this book. It's her life living on.

Anyone who knew Rachel knew that she was not a bold, outspoken type of person.

She was more quiet and more reserved. She would probably be totally embarrassed if

she knew how much I promoted her life and so forth.

I need to remember -- my kids told me when I was writing the book,

"Now you know, remember mom wasn't perfect."

It's not like she was perfect and she wasn't.

I tell some stories in here about some ways in which she demonstrated her fallibility.

That's the thing that blesses me. You know if you

lose a loved one, the veil between heaven and earth is a lot thinner than it used to be.

Any husband, any good husband is happiest when his wife is happy.

I know my wife is happy. She is having the time of her life and so in

the meantime I'll work away a while longer here.

So that blesses me to know that her life is living on.

Three critical concepts that are borne out in terms of the Church in this book that I might

just talk about a little bit.

Sure.

That is -- they're found in the last three chapters of the book.

They kind of summarize what I believe the Church

should be about. The first one I call "Sequence" -- putting first things first and

keeping them there. The second one is "Focus" -- keeping your eyes on Jesus

and allowing all the other peripheral issues simply to be in the periphery.

Anytime we start focusing on "Oh, what is baptism or

how should baptism be?" or many other wonderful things about living the

Christian life, we've pulled our focus off of Jesus Christ and Him crucified.

Paul said he refused to know anything among the believers save Jesus Christ and

Him crucified (1 Corinthians 2:2). He obviously went on to write nearly half the New Testament,

but it all centered around Jesus Christ and Him crucified.

Sequence -- putting first things first. Focus -- keeping your eyes on Jesus,

and then "Balance". It's kind of holding it all together and there's a lot of

-- if you've been a part of the Church, the Bride of Christ, you know there's a lot

of tension involved in what it means to be a part of the body of Christ.

Well that tension is a healthy thing. It speaks to balance. If you were to talk to

the cross beam on a balancing scale, that cross beam would say I feel a lot of pressure.

I feel a lot of tension. I've got ten pounds of potatoes over here.

I've got this 10-pound weight over here.

That's the way so much of the truth of Scripture is. You need to hold it all together.

Now I'm not saying -- and I use examples and one of the examples I use is faith and works.

I'm not saying that you balance faith and works and the balance of faith

and works is what produces the life of Christ.

I'm saying they both are involved. So we are saved by grace through faith. Done deal.

We don't work our way into salvation. We don't work

our way into sanctification, but I'm saying that it's there. If our faith

is real and alive, it's gonna work.

One of the ways to know if you

have real faith, James said, is for it to come alive in action.

It says show me your faith without your works

and I'll show you my faith by my works (James 2:18).

I look at the sovereignty of God

versus the free will of man. Faith and works. There's so many things in Scripture.

One verse in Scripture says let every man bear his

own burden (Galatians 6:5). Well, not too far away from that passage is another one in the

same book that says bear you one another's burdens (Galatians 6:2).

What's happening? Are they contradicting? No. We hold it all together.

We don't always understand it all, but that's not God's problem.

That's just our problem. Some people treat the Scriptures as though God

were some old man upstairs with Alzheimer's that doesn't quite know what He means

or what He's talking about.

That's not God. He knows what He's talking about. He knows what He intended to convey and

communicate to us. Sometimes we struggle to understand and it just helps by

taking all of Scripture and holding it together. So, Sequence. Focus. Balance.

So much about life and the Christian life and the life of the Church can be

helped if we understand those three critical concepts.

That's really good. Wow. Well, hopefully we give people enough of

a taste of it to maybe go out and buy a copy of the book.

Thank you.

Well, thank you for taking the time to share. This is what it looks like.

So if you're looking it up on Amazon --

This is Asher and Teresa. It was at their

wedding where Rachel was killed just four days before their wedding.

So we ended up having a funeral on Friday, and then their wedding on Saturday.

None of us ever want to imagine losing our mother or a dear family member just

four days before your wedding, but God's hand has been on this couple.

God is using them in beautiful ways. That's what God does with the

difficulties of our lives. He uses them for His glory if we're willing to allow Him.

This is a picture of the accident -- the van that was

broadsided by a huge, Dodge, four-wheel-drive, pickup truck. The picture of the life flight.

I just had a little smartphone at the time.

I had just kissed her on the cheek and said, "I'll see you soon" thinking that she

was going to be okay and soon after take-off, I just snapped that picture

thinking, "I'll show this to Rachel sometime." Soon after take-off her heart stopped and

they weren't able to start it again. She just went on up into heaven with Jesus. I'm happy about that.

That is quite the story. I'm not sure what to say.

Thank you.

Well, thank you so much for sharing that and for taking the time to share with the rest of us

what you've learned through that experience. Thank you all for watching.

I'd really highly recommend you check

out Ernest's book and the work that's being done here in LA. It's really powerful what's happening here.

Thank you all for watching.

We release new videos each week, new podcasts each week,

so come back for more content like this.

Let us know what you think. We will see you in the next episode.

For more infomation >> 039 Losing Rachel - Duration: 16:53.

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

Panflöte ölen - cleaning pan flute | Panflöten Tipps - David Döring | Flauta de Pan - Duration: 5:39.

For more infomation >> Panflöte ölen - cleaning pan flute | Panflöten Tipps - David Döring | Flauta de Pan - Duration: 5:39.

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

Titans 1x04 Promo "Doom Patrol" (SUB ITA) - Duration: 0:30.

For more infomation >> Titans 1x04 Promo "Doom Patrol" (SUB ITA) - Duration: 0:30.

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

Spencer Sunshine: Proud Boys & The Rise Of Far Right Violence - Duration: 7:47.

So there's a Republican Club in New York the Democrats and the Republicans have

like local organizations and they have it the Republicans have an actual

building and social club on the Upper East Side the really rich right wing

part of New York and they invited him to speak and he had spoken there before

last year the talk he actually was giving was a quote talk a reenactment of

an assassination of a Japanese socialist Member of Parliament in 1960 by a

Japanese fascist and so this is kind of ironic because if you remember last year

the right-wing was going crazy that Shakespeare in the park was supposed to

be some coded call by liberals to assassinate Trump and they came and

disrupted Shakespeare which truly shows the respect they have for Western

civilization um but this is a very explicit you know called call to

violence and advocacy of violence frankly if you ask me since Gavin is

always talking about you know encouraging his followers to violence so

two local groups like you know the pro Stalinist workers world party or one of

their front groups and some other activist group had called the

demonstration to not generally the proper no antifa group or or

anarchist group originally called it I think an anarchist group endorsed it the

night before the talk somebody smashed the club's windows out glued the locks

and put a little communique out calling him a hipster fascist and denouncing you

know the Republicans and others so that day maybe a hundred people showed up for

the protest that Gavin spoke and then afterwards there are a bunch of proud

boys there probably 30 or 40 and and mixed in with them people with both

cross over membership and independent were members of two far-right skinhead

gangs in New York the two eleven boot boys and b49 and so at least one of

them had gone to Charlottesville and they long been this super violent you

know element in the New York scene they're not usually so political but the

the Trump period is I think made them more political and they do stuff with

the proud boys sometimes because one of the gangs

is mostly Latino and even though they're fairly neo-nazi it's more difficult for

them to hang out with boneheads than it is with proud boys who are you know

multiracial and accept members and people of color so anyway after the talk

apparently they all got together inside there was a reporter inside who so they

all got together like in a mob and started chanting and went outside

unsurprisingly fights broke out and then what was caught at the end of it was

three people were walking away who it was claimed had stolen somebody's MAGA

hat and thirty people come and beat them down on camera but also what happens is

the NYPD who are very very aggressive

policing force um walk up and kind of I mean after they sit and kick these

people on the ground for a few minutes the NYPD walk up and kind of you know

shoo them away and they don't arrest anybody

which is sort of wild if you ever go to any kind of left-wing protest in New

York you know sometimes the cops are there like at a one-to-one figure

you know there's thirty of you and there's 30 cops they control everything I

mean I've been in demonstrations where they literally couldn't shut the

demonstration down but they made you walk in a single-file line with a police

officer on each side and so they can control anything they want to and shut

things down and they clearly weren't even willing to make arrests so what had

happened is the Republican Party guy that ran that club

had you know before had called on the Democrats to denounce this

terrible violence in his words against his club it's like a broken window I

don't know who's hurt by this you know and he had made a big deal out of it so

then what happened is the Democrats started it becomes a political football

that is very little to do with either the proud boys or left-wing you know

radical left people in town because then everyone from the state attorney general

the governor the mayor and other people called on the NYPD to go to denounce the

violence and the NYPD to make arrests three arrests happened that night but

they were all of leftists apparently for stealing somebody's bag so there have

been no more arrests this became a big deal all these you know politicians

local and state politicians hold press conferences I went to a couple of them

you know there were you know railing about stuff but none of these

politicians ever actually do work about the fact that there's far-right groups

in New York it was just is a political football against the Republicans no

arrests have been made this is clearly a kind of strong point for the proud boys

that they could mob up in New York City and beat people down and do it with

impunity McInnis claimed that he had you know

lots of support inside the NYPD so that's kind of where we're at and then

the next day I think there was another brawl yet another brawl in Portland

Oregon between it was like a surprise march between some proud boys and then

some counter protesters so a lot of the proud boys here probably shipped in from

out of town the ones that were identified quite a number of them were

like regional you know Gavin's a millionaire he can probably fund you

know what happens a lot is these Proud Boy events people are coming

in from around the country to them the Republicans they always

talk about Soros endlessly like he's funding but you know these are all

projections in reality they have a lot of money and they bus in supporters

from out of town and they're the ones who aren't local and they're the ones

who are who are you know violent and they're the ones who want a civil war so

every basically everything they say about the left is really what they want

and what they do um like people from out of town but it's clearly like a point of

pride for them and then they pretty much been treated with kid gloves that if

you're on the Left they've been really denounced but I think even these

articles like in The New York Times have really softball this stuff like Gavin

McInnis and one's been on a road for the white nationalist anti-immigrant

publication be dare and they simply called it a right wing publication so

there's all this whitewashing of Gavin what he believes how racist he is how

Islamophobic he is and how misogynistic he is how homophobic he is and how

anti-semitic he is and how much he advocates really openly and

loudly advocates violence been a ton of downplaying of his actual politics and

his actual um you know the practices he advocates by a lot of right-wing and

even center forces so I mean the problem here is that it looks like there's a

funny change where the open white nationalists look like they're being

more moderate politically like some of them like an identity europa' want to

infiltrate the GOP or get a you know work in a bottom-up

get elected into positions from the bottom up in the in the Republican Party

whereas Gavin McInnis so like the little bit more moderate than open white

nationalists because he allows in people of color and Jews and gay men into the

gang they're being more aggressive so it's a kind of funny departure from the

past but um it's a real moment right now I think for the alt

light like in the maybe last year they all right the openly white nationalist

alt right was had more power to flex its muscles in the streets and now it tends

to really shy away from this and it's alt light people that tend to be far

more aggressive in the streets proud boys and Patriot prayer out west we're led by

Joey Gibson were similar but more attached to the militias and a little

bit more wing nutty

For more infomation >> Spencer Sunshine: Proud Boys & The Rise Of Far Right Violence - Duration: 7:47.

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

Serra da Estrela, best place to ride in Portugal. I'm at home.. PT subtitles - Duration: 21:49.

For more infomation >> Serra da Estrela, best place to ride in Portugal. I'm at home.. PT subtitles - Duration: 21:49.

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

(Resin18) Experiment with a silicone cake baking mold and resin - Duration: 15:46.

For more infomation >> (Resin18) Experiment with a silicone cake baking mold and resin - Duration: 15:46.

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

Educational videos for kids | It's OK to make mistakes | Learn resilience | Pevan and Sarah - Duration: 2:04.

♫ It's Pevan & Sarah ♫

Hi Cubs, Sarah's very excited about doing some coloring in. Which colour will you

choose Sarah?

That's great concentrating, Sarah. You're staying inside the lines. Make sure you

keep focusing on your work, Sarah. Sarah? Sarah?

Whoopsy, you were daydreaming. Uh oh!

Oh, stop it Sarah! Are you hurt? Has the world exploded? Is colouring

outside the lines the worst thing that's ever happened to you? Making mistakes is

an important part of learning. Colouring-in takes lots of focus and

concentration. Do you think you can try it again?

Well done! You've learned from your mistake, your picture looks great, Sarah!

So remember Cubs, it's okay to make mistakes!

yum-yum-yum-yum

ha ha ha ha!

For more infomation >> Educational videos for kids | It's OK to make mistakes | Learn resilience | Pevan and Sarah - Duration: 2:04.

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

cheb lotfi 2019 - كليوم نطير - معاك شفت تجرجير - Duration: 6:26.

For more infomation >> cheb lotfi 2019 - كليوم نطير - معاك شفت تجرجير - Duration: 6:26.

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

حظك اليوم الجمعة 02-11-2018 فى التوقعات اليومية للابراج بقلم عالمة الفلك د. نيفين ابو شالة - Duration: 8:10.

Friday, 2 November 2018

Aries

professionally

How success tends to be your ally, and you may find a successful business project that increases your financial income, study it well and do not fear adventure.

Emotionally

Single

Trust, doubt and caution Important and necessary addresses must be taken into account in your relationship with your beloved until you know it well

Married

Stands on the line between the sincerity and the impossible desire that you reject, be careful and do not weaken before temptations

Taurus

professionally

There are several options for changing your career and career

Emotionally

Single

Forget your previous emotional relationship so that you can start over because you are in front of a real love that needs your care

Married

Surprised by the strange and unusual behavior of the partner, help him because he is going through difficult circumstances and need your love and interest

Gemini

professionally

Build a lot of projects and projects and try to convince yourself that you are capable of implementing them, but you do not achieve anything, on the ground, get up because you are strong and deserve a better reality

Emotionally

Single

Your emotions are sincere and deep toward a relative, but his heart is busy with someone else

Married

Try to reduce the circle of superficial social relationships to keep your family from disintegration

Cancer

professionally

You may be wrong in your judgment of some things and see them as untrue, so do not take any important decision and postpone it until you appear clearly

Emotionally

Single

Your dignity prevents you from making the necessary compromises to continue your relationship with your loved one and this may lead to failure

Married

Live moments of rebellion and indifference as if you are a teenager and perhaps forget your duties towards the partner

The Lion Tower

professionally

Take advantage today of positive reality to correct your recent professional mistakes and reconsider some outstanding issues and develop the right solutions to live psychological stability

Emotionally

Single

Love takes you to a pink world and changes the bitter reality that you live and creates the psychological comfort you seek

Married

Your interest in deceptive appearances and forgetting the essence of things will expose your family to financial difficulties

Virgo

professionally

You are trying to achieve your dream for a long time and put the first brick in the course of its implementation with the help of some friends and associates

Emotionally

Live alienation and escape from your feelings and wait for the other party more courageous than you, take the first step

Libra

professionally

You are about to reach a goal that you have sought for a long time, and suddenly you are disappointed by obstacles placed by a relative

Emotionally

Single

You may regret the love you tried to give in it all the feelings and emotions that the beloved did not appreciate

Married

Your relationship with your partner is negatively affected by your ambiguity and lack of honesty and then the effect is lost because of your consciousness and patience

Scorpio

Born in this tower On a day like this

the artist Khaled Abou El Naga

And the artist Afaf Shoaib

And the artist Nada Bassiouni

And the artist Sami Justice

And the artist Hassan Kami

And the artist Medhat Saleh

And the artist Salah Sarhan

And the artist Hadi Khafaja

And the artist Magda Nour El Din

And the artist Ahmed Osama Abdul Khalek

And the mascara Michel El Masry

And the poet Bahaa El Din Mohamed

professionally

Beyond some negative conditions, complex things thanks to your intelligence and willpower and you can turn the scales to your advantage

Emotionally

Single

The intense jealousy of the beloved and the unwarranted suspicion threaten the future of your relationship with him

Married

You can not take responsibility for a family matter that worries you so much and leaves the partner free to act

Sagittarius tower

professionally

Do not take everything in good faith and you have to distinguish between real and imaginary help out of a professional crisis caused by negligence

Emotionally

May live today a state of emotional loss and leave things for the time without being active in the process and this negatively affects your relationship with the other party

Capricorn

professionally

It is complicated and practical and stands helpless to act and suddenly comes the solution of someone who holds you fulfilling because you helped him one day

Emotionally

Single

Love enters your heart, so that the dust of loss, dispersion and isolation will be released from you

Married

Working with the partner as a joint work and succeeding in achieving an important goal that improves their social and economic status

Aquarius

professionally

Be in front of seductive offer from someone to improve your financial situation, reject it because it bears the appearance of good and in the inner exploitation and you can confirm that

Emotionally

Single

Today you can break all the barriers that stand in front of your emotional relationship and share with your beloved love and sincerity

Married

Your routine is getting rough and you're trying to renew in any way, and your partner may help you get there

Pisces

professionally

Think about the future and save some money for any emergency to be safe in difficult circumstances because you may need it after a while

Emotionally

Single

Open your heart to love with caution and receive those who knock it calmly and rationally

Married

Your feelings glow and mature and increase depth, and this reflects positively on your relationship with the partner is more love to you