Waching daily Apr 30 2018

in this lecture we're going to be covering off power query power query is

a powerful tool for transforming all of your data however even if your data

requires no transformation it can save you a lot of time if you have to refresh

any of your data inside your Excel workbooks the two most typical ways of

refreshing data in Excel is either copy and paste or opening your files and

repeating all of your steps by setting up your workbooks with power query

you'll be able to simply click a refresh button to update everything in your

models in Excel 2016 power query has now been built into Excel has moved to the

data tab and has been renamed to get data in Excel 2010 and Excel 2013 power

query came as a free add-in from Microsoft and is downloadable from their

site if you're using Excel 2010 or 2013 you can get a link to the Microsoft site

for the download in the lecture notes to use power query we simply come over to

get data and we can see here that we can extract data from a number of file

formats here we have an Excel workbook a number of different text file formats

databases from Facebook or from a number of other sources for this example we're

going to use a simple text file which is stored in a CSV file format we're going

to come over to our example file here employees 2017 and here we can see a

preview of our data to carry out any cleaning or transformation operations on

our data we can click the edit button but we're going to cover that off in a

separate lecture for now we're just going to go ahead and click load you can

see here that our data has automatically been added to a table for easy use our

table has been given a name employees 2017 which was the name of our file if I

want to generalize this a little bit more I could rename this so that this

table could be reused for data from different periods say employees 2016 or

employees 2018 and still have our name reference make sense throughout our

different formulas over here we the query this contains the import

specifications for getting our data into Excel the nice thing about this is that

anytime all data gets updated all I have to do is come over here and click the

refresh button and that will refresh now the things to keep in mind here are that

first of all the data is pointed to a specific file so if your file name

changes you're gonna have to update this now it's quite common in various

workflows that your files get renamed with either versions or dates attached

to them to simplify your workflow I recommend always outputting the file

with the same file name into the same location and simply adding an extra copy

of the file often to an archive folder which does contain your date for easy

reference to the different files now if you do need to change where this file is

pointed to you can come over here and click Edit this will take us to the

query editor most of these options to do with cleaning and transformation so

we'll cover that a little bit later but for now you'll notice over here that we

have some properties including the name of our query again I can adjust this to

be something a little bit more generic down here we have all the different

steps which have taken place on our data so the first one here is specifying

where our data comes from promoted headers basically means that the first

row of data contains the column names and change type adds these 1.2 ABC which

basically specifies this is a numeric number with decimal places and these are

text fields so to update the settings for our file location I can come back up

to source I can click this little cog icon here which is the settings for this

parameter and I can click browse here to change the file that I'm pointing to

after this has all been adjusted you can come over here and click OK now if this

data doesn't refresh straight away you can come over here and click refresh

preview now there's one other setting I want to talk about here and this is

sitting under the advanced editor clicking on advanced

editor will take us to a script which has been created for us one of the

settings here columns equals to 14 basically meant that when we imported

our original dataset it contained 14 columns now the problem

with this being part of our import specification is that if we have less

columns or more columns then our data is not going to import correctly it's quite

often where you have a data set and then you realize that you need to add

additional columns to it you go back at the fields now here if you ended up with

say 15 or 16 columns those would be then truncated down to 14 columns again this

was not actually a problem in power query back in Excel 2010 in Excel 2013

however in Excel 2016 Microsoft has decided to hard-code this value as part

of the script that's created to make power query more flexible and more

easily refreshable when you update the number of columns and your data sources

come over to here select columns equals 14 make sure that you also select the

comma and simply press Delete I'm gonna click done and then close and load to

exit power query now anytime our data is updated I can simply come and click the

refresh button here or the refresh button at the top here in another

lecture we're gonna cover off data cleaning and transformations using power

query however this right here is the

predominant way that I use power query because I do my data transformations

predominantly in R I think power query can be a really great way of loading

that data into Excel so that users who only have Excel are able to easily

consume and pivot that data while also being able to refresh the workbook when

the data gets updated

For more infomation >> Linking to Data with Power Query Excel 2016 (Get & Transform) - Part 1 - Duration: 6:26.

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

五月份的十二生肖，看看谁最旺！ - Duration: 15:40.

For more infomation >> 五月份的十二生肖，看看谁最旺！ - Duration: 15:40.

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

5月份财星高照，4大生肖横财就手，喜事接二连三进家门 - Duration: 4:57.

For more infomation >> 5月份财星高照，4大生肖横财就手，喜事接二连三进家门 - Duration: 4:57.

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

#Capricorn #horoscope #astrology from 5/1/2018 to the seventh day. - Duration: 6:26.

Yamada Centaurus presents

The horoscope of the from Tue, 5/1/2018 to the seventh day.

Capricorn : Tue, 5/1/2018

Luck points : max = 5

Money : 4

Work : 3

Love : 4

Total : 3

Rank : 6 of 12

Lucky color : orange

When I change hairstyles and redesign makeup tools, I am happy. It is important to keep your posture correct all the time.

Capricorn : Wed, 5/2/2018

Luck points : max = 5

Money : 4

Work : 5

Love : 5

Total : 4

Rank : 3 of 12

Lucky color : white

Today's date seems to be gorgeous. It is also ◎ that I give you a present as usual. Please go out to places you do not know ☆

Capricorn : Thu, 5/3/2018

Luck points : max = 5

Money : 3

Work : 3

Love : 2

Total : 3

Rank : 9 of 12

Lucky color : red

It seems that chores will clean up smoothly. Please enjoy tea for free time. There is an implication that there is an invitation from your favorite person.

Capricorn : Fri, 5/4/2018

Luck points : max = 5

Money : 4

Work : 3

Love : 3

Total : 3

Rank : 7 of 12

Lucky color : gray

Carefully speak wording to unfamiliar people. If you do not forget your humble attitude, unexpected extraordinary income also. There is a feeling of gifts from lovers at night.

Capricorn : Sat, 5/5/2018

Luck points : max = 5

Money : 4

Work : 3

Love : 4

Total : 3

Rank : 6 of 12

Lucky color : blue

The goal is to tackle without being impatient. It may take time, so please keep in mind the behavior you like today. Do not forget a break, too.

Capricorn : Sun, 5/6/2018

Luck points : max = 5

Money : 2

Work : 2

Love : 1

Total : 1

Rank : 12 of 12

Lucky color : purple

Please listen carefully to the story of the older person at the drinking party. You may be able to hear useful things in your position.

Capricorn : Mon, 5/7/2018

Luck points : max = 5

Money : 4

Work : 5

Love : 5

Total : 5

Rank : 2 of 12

Lucky color : silver

Whether it is work or a hobby, in absence of confidence, let's not hold back and let's do it to the fullest. Evaluation from others, ugly as well as implied ☆

See you.

For more infomation >> #Capricorn #horoscope #astrology from 5/1/2018 to the seventh day. - Duration: 6:26.

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

속새는 무엇이며 어디에 좋을까? - Health For you 건강 - Duration: 7:22.

For more infomation >> 속새는 무엇이며 어디에 좋을까? - Health For you 건강 - Duration: 7:22.

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

Do You Like Broccoli Ice Cream ? Nursery Rhymes Song for Kids - Duration: 2:27.

Do You Like Broccoli Ice Cream ? Nursery Rhymes Song for Kids

For more infomation >> Do You Like Broccoli Ice Cream ? Nursery Rhymes Song for Kids - Duration: 2:27.

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

How To Make An Electromagnet Easily By Tv Flyback | Easy Home Made Electromagnet Projects | - Duration: 12:38.

For more infomation >> How To Make An Electromagnet Easily By Tv Flyback | Easy Home Made Electromagnet Projects | - Duration: 12:38.

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

How Much Is The Human Body Worth? - Duration: 3:31.

Hey there.

Welcome to Life Noggin.

Would you be willing to let some sketchy guy slice you open in his basement to harvest

one of your kidneys?

What if you were promised a nice chunk of money in return?

I really hope your answer is still no, but for some people, this payout is apparently

well worth the risk.

While my animated body is valued at basically nothing, your human bodies are pretty valuable.

Just how much is the human body worth?

Let's add it up.

Black market organ harvesting from dead and living people is an incredibly huge and lucrative

industry.

It's estimated to be worth a whopping one billion dollars.

In this market, kidneys alone are sold to people in need for about $140,000 a pop.

And some organs go for even more.

Take lungs for example.

Estimates value a set of lungs at almost $300,000!

And the almighty heart?

A whopping $595,000.

But the people selling to the black market are only paid a tiny fraction of these selling

prices.

The rest goes to the middle-men and women making the transactions.

And it's not just major organs, all kinds of valuable body parts are in demand on the

black market.

Do you think these 1s and 0s would go for anything, because i have a lot of them!

Underground organ sales and transplantations originally came about for a number of reasons,

but a major one is the fact that the legal organ transplantation system is seriously

lacking.

Recent estimates quote that there are over 100,000 people on transplant waiting lists

in the United States alone and 20 of them die waiting each day.

So, when people are desperate, sometimes they turn to the black market in a last-ditch attempt

to save their lives.

With $1 billion floating around this illegal market and massive organ shortages affecting

so many people, some are starting to question whether you should be allowed to sell your

organs.

Which got me to thinking, does anywhere allow this?

Kind of, yes.

In Iran, people can sell their kidneys through the government, which then gives them to patients

who need them.

This very progressive practice came into play in the 1990s in response to the huge shortage

of donated kidneys.

It's been extremely effective and now Iran is one of the few countries in the world without

a kidney shortage.

But it's more than major organs like kidneys and hearts that are in demand.

On the black market, skull and teeth sets are sold for about $1,200.

Small intestines, $2,500.

Blood, about $3,000.

Bones and ligaments add up to roughly $5,000.

Corneas clock in around $20,000.

And skin is also surprisingly valuable, with the average person's outer layer being worth

about $24,000.

All making you a pretty pricey product.

Now, keep in mind that these estimates are just that, estimates.

There's no official price list for black market organ sales.

But when we take all these price points into account, the human body seems to be worth

over $1,000,000 on the black market!

Does anyone want both my legs, because my animator can just give me new ones!

So how do you feel about all this!?

Would you ever consider donating your organs? or

let us know in the comment section below what we should talk about next?

Curious to know what happens after you die? Check out this video!

The bacteria in your gastrointestinal track will start to break down tissues and cells.

liquefying your body and producing horrific smelling gases like methane and hydrogen sulfide.

as always, my name is Blocko, this has been Life Noggin, don't forget to keep on thinking!

For more infomation >> How Much Is The Human Body Worth? - Duration: 3:31.

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

Charles Irwin - A sad song about a girl I no longer know [ukulele cover] | burningbucket - Duration: 6:20.

For more infomation >> Charles Irwin - A sad song about a girl I no longer know [ukulele cover] | burningbucket - Duration: 6:20.

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

四大生肖 乐得合不拢嘴！做梦都笑醒！ - Duration: 5:06.

For more infomation >> 四大生肖 乐得合不拢嘴！做梦都笑醒！ - Duration: 5:06.

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

Funny Celebrity Head Shots (Turn Sound Off and See How Many You Can Recognise) (2018) - Duration: 1:39.

For more infomation >> Funny Celebrity Head Shots (Turn Sound Off and See How Many You Can Recognise) (2018) - Duration: 1:39.

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

UPS, RE-USABLE PADS, & EVERYTHING YOU SHOULD KNOW ABOUT WHAT YOU CAN USE - Duration: 6:02.

CUPS, RE-USABLE PADS, & EVERYTHING YOU SHOULD KNOW ABOUT WHAT YOU CAN USE ON YOUR PERIOD!

BY ALANNA KETLER

A few years ago now, I wrote an article about alternatives to tampons and pads and highlighted

some more sustainable options and outlined some of the risks associated with the use

of tampons made of synthetic fibers specifically.

Now there are even more alternatives, that some people may find more accessible so it�s

time for an updated version of this article with all of the new advancements in this realm

to suit your needs. I get it, not everyone wants to use a menstrual cup, although some

absolutely love them.

A period is something that many people have on a regular, monthly basis. Throughout our

lifetime, we will have on average of 450 periods and use between 10,000-12,000 menstrual products,

most of which will end up in the trash and eventually landfills. Since the majority of

these products are made from plastic, rayon and chemical laden cotton, they do not biodegrade

and they take thousands of years to break down.

On top of that, many of these products contain toxic chemicals that aren�t exactly good

for our bodies. So, why not do what we can to limit the amount of plastic and chemical

waste that ends up in our landfills, oceans, AND bodies? There are enough alternatives

available now that the only excuse is essentially ignorance, laziness or straight up carelessness,

if you are unaware of the alternatives, after reading this you will be fully informed.

The Cup This is the one that most people are very

wary of until they try it. Personally, I�ve been using the cup for 6 years now, and I

have to say � I love it. Although, it did take me quite a few months to get used to,

in my opinion it is the most sustainable option and although the reusable pads are great too,

I�m just not really a pads type of person, I don�t like having that extra bulk down

there. So, the cups are made of surgical grade silicon, which means they do not leach any

toxins or chemicals into the body, they last a long time, although they will likely get

stained over time; you can simply sanitize them by boiling them in water for 10 minutes,

easy peasy.

Most cups that I have seen even come with a convenient little cotton or hemp bag to

carry it in. They can hold quite a lot of fluid, depending on your flow they only need

to be changed twice a day, once in the evening once in the morning, which in theory, means

that you won�t even have to change it while you are out and about or at work.

Also, this method is super cost effective, assuming we spend anywhere from $3,000 � $6,000

over the course of a lifetime, even just 4 cups might cost $200 total. However, if this

method just seems totally absurd to you and something that you could never see yourself

actually using, have no fear, there is also the reusable pad option, which is catching

on quickly�

The Reusable Pad If again, you�re thinking something along

the lines of ew�gross � then just hear me out. While the idea of having a pad that

you have to wash yourself is somewhat off-putting, just think of all of the waste you�ll be

saving from the landfills. There are tons of options for reusable pads and even period

proof underwear, which act in the same way except they have a built-in liner. These come

in many different varieties from super light to extra super flow, and even reusable liners

that can be used for the day or two before or after your expected visit from Aunt Flo.

They are leak proof, generally made from organic and sustainable materials and there are so

many options for you to choose to find out what works best for you and your cycle. When

it�s time to wash, you simply rinse them out under hot running water and wash as you

would normally with your underwear. Really, it�s not as bad as you think and the amount

of waste it saves makes this option pretty much a no-brainer, well, at least one of these

options.

However, if you still just can�t get around the idea of having to see or touch blood from

your own cycle/body, then there is yet another option to consider�

Reusable Tampon Applicators These are great options for times where you

won�t have access to a private stall bathroom or you are out and about hiking or camping

and don�t have a way to wash your pads or rinse out your cup hygienically. Reusable

applicators use organic tampon inserts, similar to the smaller ones you may have seen with

no applicator, and every time you have to change your tampon, you just insert a new

tampon, and use the reusable applicator to insert it.

This method saves tons of plastic applicators from our landfills and oceans. Some models

that are available come with a handy little carrying case and a cap. This method couldn�t

be simpler, because if you are already a tampon user, it is literally the exact same method.

Aside from having to simply wipe or rinse it off and sterilize it once in a while, it�s

a very simple method.

Final Thoughts? As you can clearly see there are so many easy

and viable options that are not only better for your body, but better for our environment

as a whole. Really, menstrual products are just one example out of millions that can

be looked at in a more sustainable light and modified to reduce the amount of waste they

are producing. We can all do our part to be the change, and take responsibility for our

own lives and the impact we are making.

Much Love