Auto news on Youtube Nov 21 2018

How to build a reliable Upside Down

Mounted Lazy Susan

The idea of a rotating platform has been used

for years in corner storage units,

but why not incorporate it elsewhere?

To clear up counter space,

and add a new wrinkle to your kitchen,

drill holes on a circular

wooden lazy Susan equidistant

from one another as if it is like a clock.

By mounting a simple bracket underneath a cabinet,

slide on the lazy Susan and place

either coffee mugs, pots,

or utensils on the hooks,

allowing you to rotate them seamlessly.

Tip: Place a freestanding lazy Susan sphere

on an entertainment center to make your TV

capable of swiveling 360 degrees.

The weight of the television set will ensure

the platform will not slip.

Done,

Next time, we are going to discuss how to

upcycle Bookshelf Kitchen Island.

Stick with us,

follow pasted link inside description

to find more detail,

and as always,

Thanks for watching.

For more infomation >> How to build a rotating lazy susan - Duration: 1:54.

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

How To Build a YouTube Audience Through The Community Tab! - Duration: 5:15.

- A lot of you have been asking for this

and it looks as if YouTube have finally abated.

If you have over 1000 subscribers,

you've probably been seeing this notification.

You now have access

(megaphone amplifies) to the Community Tab.

- [Man] VidIQ

- [Woman] VidIQ

- [Man Whispers] VidIQ dot com

(mellow hip hop music)

Over the past year if you've been sifting though

the subscription feed on you mobile YouTube application.

You may have been wondering

where are the these Voting Poles coming from?

Why can I see a picture

or why is this channel advertising another channel?

These are all Community Posts that have been available

to some creators, over 10,000 subscribers for a while.

It's been available to some selected channels

under 10,000 subscribers,

but now it seems to be rolled out to all channels

above 1000 subscribers.

So that's the first question.

Do you have the Community Tab feature available?

Do let us know in the comments below.

Hello everybody.

Welcome to VidIQ.

My name is Rob.

If this is your first time in these glorious

YouTube surroundings, we are the tool and channel

that aims help you get more views in less time

by educating you on your YouTube journey.

Our Chrome extension tool will help you analyze YouTube,

research videos, audit your own channel

and take actionable steps.

It is free to download.

A link is in the description.

The Community Tab then,

I did an "everything you need to know" video about this

a year ago when we first got our hands on it.

So if you want to know the ins and outs of

what it is and how to use it,

check that video out.

Here though are some dos and don'ts.

General, super obvious advice first.

If you've either just got the Community Tab

or you've had it for months, use it.

You will be amazed at the results.

We often find that when we post in the Community Tab

we get as much engagement and feedback

as we do from videos that we spent hours making.

Voting Poles in particular are so easy to make

and you get so much feedback from them.

In our case, thousands of votes and dozens of responses.

If you want to canvas a percentage of your audience

in five minutes, then asking them a question

putting a Voting Pole in a community tab

is the fastest way to do it.

And then maybe you could use the results

from a Community Tab post for a video.

Just like we did with our channel trailer video.

Which you can watch over here.

For video creators there's a really exciting aspect

of Community Posts, but for YouTube users

this is terrifying, because

what YouTube will do is occasionally

send these Community Posts to people

who aren't even subscribed to the channel.

Now I was stunned

when I saw this in the YouTube help article.

So I thought, what better way to find out if this is true

by posting a Community Tab poll about it.

And guess what the results where.

(chime dings)

More than 40 percent of the 1500 people who answered

either weren't subscribed to VidIQ

or had no idea who we were.

Now that probably wasn't a super accurate result,

but you have to imagine

that some of those people that responded

genuinely don't subscribe to VidIQ.

So imagine being able to reach people

who haven't officially invested in your content

through clicking on the subscription button.

There is something to bear in mind

before you jump into the YouTube Community Tab however.

It's not like your traditional social media timeline

like Twitter and Facebook.

People are on YouTube to watch videos,

so they don't want to know

how many cups of coffee you've had in the morning

or when you took the dog out for a walk.

One Community Post a day is recommended.

And the simple reason is, as we mentioned earlier,

this gets into people's subscription fees.

So if all they're seeing is posts from you

and no actual video content.

They're either gonna remove posts

from their subscription feed,

or worse yet, unsubscribe from your channel.

Back to things you should be doing

with the Community Tab.

First one being.

(finger snaps)

Yes, what you're seeing here is a gif

or a gif, whatever you want to call it.

YouTube Community Posts support these.

I am surprised that feeds aren't littered with gifs

but presumably not enough people know

that you can use them in the Community Posts.

Regardless, now you know you can use this

to tease a bit of the footage from your videos content.

This strategy is generally known as breadcrumbing

and Cute Girls Hairstyles,

with its five and a half million subscribers,

does this to perfection.

They create Voting Polls on topics

based on videos that are upcoming,

and they advertise them in the Poll itself.

Once they've created awareness through this Voting Poll

and then the video goes live,

they'll post again reminding people of the video.

Just in case it's not hit peoples subscription feeds.

Judging from the engagement they get from these girls,

Cute Girls Hairstyles is a template

for how to use a Community Tab.

Now before you leap into the Community Tab

and have some fun with it.

Now might be a good time to remind yourself

of YouTube's Community Guidelines.

The last thing you want to do is

lose this tool the moment you get it.

So make sure you don't post any

sexual, harmful, hateful, violent content.

No harassment, spam, threats, copyrights.

Ya, just use your common sense.

I like to think of the Community Tab

as YouTube's megaphone.

It has the power to not only reach your audience

but those beyond with a powerful message.

Just make sure you use it responsibly.

If you're an experienced hand with the community tab

or your brand new to it. Let us know in the comments below

your experience, stories and tips.

(megaphone amplifies) To infinity and beyond.

(deep raspy breathing)

(low rumbling clicks)

For more infomation >> How To Build a YouTube Audience Through The Community Tab! - Duration: 5:15.

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

Learn How to Create a Database - Duration: 2:01.

welcome back let's go ahead with our exercise gathering data from different

years and different sheets on a single sheet is crucial it allows the user to

classify all the data in a coherent way when attributing a P&L category let's go

ahead with our example and this will be clearer by the end of the exercise in

order to have three years data on the same sheet we need to copy the codes for

each line item in each of the three years we copy the codes for 2011

we will copy the codes for 2012

and finally we will copy the ones for 2013

okay so we have the codes of all three years in the same sheet this is good we

need to deal with one issue though many of the codes are contained more than

once in our selection as there are many accounts which appear more than once

throughout the years we need to have each single code only once in our

selection without any duplicates fortunately there is a great excel

function which allows us to do this easily this is very important because

later on we will use some if and codes will be our if criteria if a single code

is found twice in the range this will cause double counting let's select the

range of values and then go to data on the menu bar where we shall select

remove duplicates select column B only click OK now we have a range of values

which does not contain any duplicates thanks for watching

For more infomation >> Learn How to Create a Database - Duration: 2:01.

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

Building a Financial liabilities schedule - Duration: 6:25.

in the previous lecture we forecasted PP and D and D and a now our focus will be

financial liabilities to be more precise our next task is building a financial

liability schedule let's create a copy of the fixed asset roll forward sheet

and change its name to financial liabilities schedule

there are a few changes that must be made let's delete all numbers first this

ensures we won't use some cells from the previous sheet we will not need the two

gray boxes below the table so I'll delete them

let's change the items in the table the first one will be beginning debt

the second one will be new debt the third one will read principal

repayment and the total row will show us ending

debt very well we know for a fact that no new debt were made in 2015 and 2016

let's fill in historical values by bearing this in mind we can link ending

debt for 2014 2015 and 2016 simultaneously this also gives us

beginning debt given that the ending debt for 2014 was beginning debt for

2015 and the ending debt for 2015 was beginning debt for 2016

okay we can even copy the formula for beginning debt for the forecast period

now we can calculate the amount of principal repayments were made in 2015

and 2016 all we must do is subtract ending and beginning debt for the two

years

excellent during the forecast period things become more complicated the

company negotiated with its lenders to extinguish its ending debt during the

next 10 years the agreed interest rate that will be

paid is 9 percent

and the firm will repay the debt through constant annual payments our forecast

period is shorter than 10 years so we won't see all debt disappear from the

balance sheet good we need to calculate the company's annual payment for the

next ten years Excel makes this easy we can simply use the PMT function

I'll select the loan rate the number of periods in which it will be repaid and

the present value of the amount to be repaid

here's the amount

let's create a mini table that will help us determine what portion of this amount

is for interest expenses and how much the residual debt is that remains after

every repayment

we have ten periods

the four rows of the table should be payment

interest expense debt repayment

and residual debt we said the agreed loan amortization plan involves constant

payment so the payment will be equal to the same amount in all ten periods

interest expenses will be equal to the amount of residual debt at the beginning

of the period multiplied by 9% which is the agreed interest rate I'll negate

this number by putting a minus in front of the formula

the difference between the amount paid to the lender and the amount due for

interest expenses is the amount of principle repayment

and finally outstanding debt plus repayment please note we have a negative

sign here gives us residual debt outstanding at the end of the year the

next year we need to carry out the same calculations

now I can copy the formulas for the rest of the years

you can see we've worked correctly given that the loan is amortized in year 10

awesome let's fill in the table above with the values calculated for principle

repayment

now we can easily link these values with the P&L and balance sheet here we've

calculated interest expenses and this allows us to calculate the P&L until EBT

and then outstanding debt we have can be linked with the output balance sheet

the balance sheet is almost complete in our next lesson we'll build an equity

schedule stay tuned we've done an excellent job so far

For more infomation >> Building a Financial liabilities schedule - Duration: 6:25.

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

Lets create a mapping of financials - Duration: 2:51.

in this lesson we will continue to work with the source sheet as you can see all

financials are broken down by category we can see revenues from supermarkets

discounters grocery shops and retail the same goes for cogs that's great if we

want to analyze category profitability but in our case we want to build a model

at a total company level so all we need is a mapping that shows P&L categories

revenues costs of goods sold operating expenses DNA interest expenses and taxes

okay so how are we going to do that we can simply create a mapping column to

the right select the top row of the table and add a filter we can do this

with the alt a and T shortcut once we've done that we can filter for each of the

P&L items we have here I will filter for revenue and when the source data has

been filtered I only have to type revenue and paste for the entire column

okay great so now I will remove the filter and will carry out the exact same

operation for cogs please note that I am using the search functionality when

filtering it is convenient when working with larger datasets all right

I'll paste cogs to the bottom the exact same steps must be carried out for

operating expenses DNA interest expenses and taxes

adding a mapping to your sheets can be very useful this allows you to create

categories assigned by you you are not stuck with the original categories you

found in the source data this is a valuable tool and I'm sure it will help

you a great deal all right excellent so once we have carried out the mapping

exercise we will be ready to create an output P&L sheet and use the numbers we

see here to fill its historical years this is it for now thanks for watching

you

For more infomation >> Lets create a mapping of financials - Duration: 2:51.

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

Building a flexible model with Vlookup Columns - Duration: 3:23.

right so far we've seen two ways that would allow you to build dynamic models

and create multiple scenarios would you be interested to see a third way if

that's the case you've opened the right video this is what we are going to do

here vlookup can be combined with several other functions a useful

combination of vlookup is the one with columns which serves as a counter for

the number of columns let's show how this can be applied in our example the

lookup value we'll need is the scenario we've selected I'll anchor this cell

reference the lookup table where we will look is

in the entire range from B to M the function will look for lookup value and

whenever it finds it it will give us a result from that row the third input it

needs is a column number but I'm sure you'll agree this isn't a

dynamic function is it if every time we use vlookup we have to pause and count

column numbers so it would be very inefficient this is where columns comes

into play proficient users use columns every time they use vlookup the function

works in a very straightforward way I only have to select the part of the

table we've arrived at and Excel will count the number of columns in this

range simple as that if we fix cell references properly the

next time we paste the function it will have one column more given that I've

fixed only the starting column reference easy right

let's use this function for the two items below

perfect as you can see we've obtained the same result as the previous two

videos dynamic scenarios great let's use selected case values to fill in the P

and L lines we have above revenues in 2017 can be obtained by multiplying 2016

revenues by 1 plus forecasted revenue growth

the same is valid for 2018

2019 2020 and 2021

cogs will be given by revenues times projected percentage of revenues for

that year

the same holds true for OPEX

and this gives us P&L figures at the EBIT a level in our next lessons we will

go deeper and we'll forecast the firm's entire P&L balance sheet and cash flow

and the best part is this is a dynamic model that allows us to switch between

scenarios in the blink of an eye

For more infomation >> Building a flexible model with Vlookup Columns - Duration: 3:23.

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

Using the PMT function in order to create a complete loan schedule - Duration: 6:17.

right so in this lesson we will address one of the fundamental topics in finance

bank loans and the way their payments are structured I will show you how to

perform calculations typically made for you by bank employees it is a great idea

to be prepared before your conversations with bankers as this will put you in a

stronger negotiating position in addition you will see how interest rate

should be calculated when payments are due monthly furthermore you can

distinguish between capital and interest payments something most people cannot do

we will consider a bank loan that involves constant monthly payments

throughout its entire duration imagine a person wants to buy a house that costs

$300,000 he wants to assess whether this is feasible after talking to some

friends and seeing several mortgage loan advertisements he concludes the current

market rates are between 2% and 4% so he makes his preliminary calculations by

using a three percent rate fine he wants to repay the loan in ten years

by making equal monthly payments throughout this period here is the

million dollar question how much will his fixed monthly payment be for him to

extinguish the loan in ten years Microsoft Excel can fully answer this

question let's type the inputs on this sheet the number of periods during which

the loan will be repaid is 120 given that the person will make equal monthly

payments for 10 years the interest rate he will have to pay for borrowing the

money is 3 percent annually to obtain the monthly interest rate as usual one

should divide the annual interest rate by 12 this is what we will do here okay

very good and finally the amount borrowed is $300,000 we have all the

inputs that would allow to calculate the monthly payment for the

loan the Excel formula for this calculation is PMT as in payment I will

type it in the formula bar and select each input we just entered okay

our formula is ready the borrower must make a monthly payment of two thousand

eight hundred ninety six dollars for ten years to repay the loan heavy monthly

expense right let's go a step further and disaggregate what portion of each

payment is interest principle and how much is the remaining debt I'll create

five columns period payment interest principle and residual

debt

okay the first column will indicate the number of the respective payment 1 2 3 4

and so on - 120

we already calculated the amount of each of the fixed payments here it is I'll

link to the cell and then fix its reference to be able to copy it to the

last row of the table okay perfect our next task is to

disaggregate this payment in two parts interest rate and principle in the first

period the amount of interest that will be accrued is based on the whole debt

that is drawn and given that no payments have been made we have 300,000 times the

interest rate

which equals 750 the difference between the payment and the amount of interest

payments is the amount of principle that is repaid

in the last column we can calculate the residual debt that remains after this

payment

you

good let's do the same thing on the row below I'll multiply the interest rate by

the residual debt fixing the cell references of the interest rate

then I'll take the difference between the payment made and the amount of

interest

this is the principal repaid in this period

okay let's calculate the amount of residual debt by taking the difference

between the amount due before this period and the principal repaid during

this period

here's our residual debt after period two

we can copy these formulas to the last row of the table

you

you

as you can see the residual debt at the end of the loan life is zero so we

worked correctly the debt will be repaid after ten years this is how we can

calculate an entire loan schedule and exercise that allows us to plan better

and understand exactly how much and for what we are paying thank you for

watching

For more infomation >> Using the PMT function in order to create a complete loan schedule - Duration: 6:17.

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

LET'S ALL GROW TOGETHER BY BUILDING A COMMUNITY | THE DAILY VLOG - Duration: 7:23.

hmm hi so I was just listening to podcasts while I was making my food and

they were talking about community building and I realized that I'm not

doing a very good job with building a community and I realized the the value

that that that could be by building a community and here are just my thoughts

and I have to think about this more but I want to make this more interactive I

want this whole thing of you know me documenting my journey I want this to be

more than just my journey because I think of course some people you know

just like to to passively consume but a lot of people and you guys who watch

this I know are like working on themselves and I want to grow to like I

do and want to you know we have these big ambitions in life and we we want to

learn and evolve as a human being and so I think why does it just have have to be

me talking about my life and then you passively consuming that and maybe doing

something with it maybe not but what if instead we can figure out how we can you

know grow together and I'm not exactly sure what that means right now I mean

for me it definitely means you know in cooperating you may be more into

decision making processes you know asking more questions on things that are

actually relevant and and not just like oh give me like a book recommendation

but actually you know like where should I move and how do I you know in the end

it's always the decision is always gonna be up to me but maybe there's some way

how we can all grow together because this thing this vlog I'm gonna keep this

going you know and and hopefully I'm gonna become a different person through

that and I want you guys to become a different person in your own lives not

through my vlogs I'm not saying that these are so impactful

they're gonna change you but I want to you know have some way how we're how we

can push each each other maybe and and and check up on each other's growth and

and progress and and goals and achievements and I don't know what form

it could take and I don't even know if you guys would be interested in that so

maybe this is the actual first step of incorporating this process of me saying

I think this is a cool idea you guys let me know number one what do you think of

it and then how we could achieve that I mean we could create a Facebook group

maybe and people who are interested we can join and you know check up on each

other and and and post stuff that we're that we're doing and decisions that have

to be made or share resources that could mean you know just interacting more in

the in the Commons and I'm gonna ask you guys more you know like actually

incorporate you and my decision-making processes and you let me know of more

things and maybe how I can help out yeah I don't know yet how it's gonna look but

let me know if you have any ideas or if you even interested in this but I think

it's it would be so much cooler if it's just not me talking about how I'm

growing and evolving but how we can all together grow and evolve and work

towards our goals which are obviously all different but if we have that in

common that we are ambitious and we want to achieve something and we want to give

all then why not do together let me now

so I realized that I have a constant need to always fill up my time to fill

out my whole day with tasks from beginning to end so always know exactly

what I'm gonna do and you know always to be doing something and I think that

might be to my detriment because I finished my work and as you do when you

finish your work but you need to do something I watched a couple of YouTube

videos that I had been putting on my list which I wanted to watch and one of

them was about habits of successful people and if you look at habits of

successful people that are like successful successful like Jeff Bezos

like Warren Buffett like like you know must not so much you know must stands

out from them or Bill Gates like I even looked at some someone like Ben Benjamin

Franklin they all had time that was dedicated to work and that was work time

but they also had time that was you know not necessarily leisure but that was

more like you know up for for whatever came up like listening to music like

reading a good book like just recapping the day like and I think I need to be

doing them all and you know I always stopped my day at or often I stopped my

day like 10 p.m. I mean right now it's 10:15 p.m. and I did all these things

but I don't even have time to reflect on it but because now it's pretty much time

to go to bed then I wake up that I rinse and repeat and I think there is um there

is value and giving yourself time to digest you know the day but I don't know

let me know I mean now we're doing a bit more interactive things so you still

have to answer the first thing I asked but um how are you handling it like are

you having leisure time are you you know i when are you most

creative because I feel like I am most creative in these art I'm not Alicia

time these are time it's the wrong word because these are time always sounds

like doing nothing but you are doing something like a few reading or

reflecting or or recapping the day or planning like that actual stuff it just

it just not like in the in the in the trenches work so I want to incorporate

that more but yeah that's it let me know about the interactive thing what you

guys do and then that's it for the vlog and I'm gonna see you tomorrow Co peace

I do wake up plan there's no other time to wake you up

seething breathing doing all the things I hate about wine coalition I just wanna

make a trip to the child

For more infomation >> LET'S ALL GROW TOGETHER BY BUILDING A COMMUNITY | THE DAILY VLOG - Duration: 7:23.

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

Building a flexible model with Choose Match - Duration: 1:45.

so the combination of offset and match is one way to make forecast scenarios

dynamic we learned how to use plenty of functions so now we can exercise some

other combinations too what about the choose function it's very

popular for scenario building let's see how it can be applied in our case I will

type choose the first argument of the function is its index value which is a

number one two three four etc then the next few arguments we need are the

scenarios which are selected so for this cell we want to select the three values

below which is the function that would allow us to obtain a number based on the

name of the scenario we've selected yes we need the match function the lookup

value is up here I will anchor its reference and then the

lookup array is here let's fix its column references

the third argument is zero as usual perfect match we'll look at the selected

scenario and then provide its number within the selected range of three cells

the number will be from one to three and that's exactly what chews needs a number

from one to three that helps it decide whether to select

scenario one two or three this is how we can build dynamic models with choose and

match

thanks for watching

For more infomation >> Building a flexible model with Choose Match - Duration: 1:45.

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

Create a Code The Best Way to Organize Your Data and Work Efficiently with It - Duration: 1:55.

when we have a large extraction we need to be sure that we will be able to

manage it efficiently a good way to do that is by creating a code which

summarizes the important information about each line item moreover it has to

be different from the codes of the other lines what we see in the data is that we

have many rows with the same code C column F the difference between them

lies in column C under partner company they are the same P&L account but

against different partner companies it would be excellent if we build on our

current code and create a new one which contains the information regarding both

the P&L account and the partner company we can do this by putting together the

two fields using the and function should be sufficient for this task we have plus

f5 and C 5 and now the result is a bigger and stronger code which would

allow us to manage the information efficiently let's do this for all rows

I'll copy the formula down until the last row ok so this is how we will have

a unique code which will contain contemporaneously the information

regarding the P&L account and the partner company one last thing to do is

to copy all the newly created codes and paste special over them with values the

shortcut for paste special is alt e and s this operation was necessary because

it allows us to copy our code in other locations next we'll see how to organize

data from three different years next to each other thanks for watching

For more infomation >> Create a Code The Best Way to Organize Your Data and Work Efficiently with It - Duration: 1:55.

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

How to Build a Terrific Home OWNER Profile - Duration: 10:50.

Hi, it's Tim and it's Amy from GoWithLess. Welcome to our channel! We are so

glad to have you here. Today's video is a house sitting video. Very appropriate,

because we are on a cat sit in Brooklyn watching a delightful cat. One of the

sweetest, most social cats that we've watched so far. Now, we're going to be

full-time international house sitters in (not even) 16 months... in less than 16

months. So, we cover all kinds of house-sitting topics on our channel one

time a month. And, our last house-sitting video was all about how to build a great

profile as a house sitter to secure really good sits. Today, we're gonna flip

the coin and we're going to show how to make a great profile as a home owner

because that is just as important to get the right sitters into your home. We are

approached a lot by homeowners who aren't finding the right sitters on the

platform and they're reaching out to us. And sometimes, I see that they might not

be finding the right sitters because their profile isn't selling their home

and their situation appropriately. So, we're going to be addressing that today,

And, it should never be an issue as a home owner to find a great sitter for

your house. And so, the profile is going to make a huge difference. And so, there

are a lot more house sitters than there are home owners. And so, what you put in

your profile makes a big difference. It sure does. So, if house sitting, if travel

in general, budget travel, travel hacking, how to travel for free... If these sorts of

things are of interest to you? Please subscribe to our channel over here. We're

trying to hit a thousand subscribers by the end of 2018. We really need your help

to do it, so please share and subscribe. We appreciate it so much. So, let's get

right into it! How to build a great home owner profile. Please, stay tuned!

So when the two of us are on a house sit, I do a ton of the work that's there. So,

I'm the chief shot-giver and I do other chores. So, a lot of the chores

fall to me. However when it comes to finding sits and researching what's

going on in the community, Amy is our go-to person for that. And so, in this

video, I'm not gonna have a whole ton to say. Amy's gonna do most of the talking...

which in our normal life that is something that happens...but, in this

particular video, she is going to do most of the speaking. That's right. When you

see a travel hacking video, that's mostly gonna be Tim. House sitting is mostly me. We

divide it up pretty nicely. So getting started. Number one is put in great

pictures. We see a lot of profiles that have unlimited pictures of the pets and

that's it. It's great to have pictures of your pets and you certainly should have

pictures of your pets, but just as important are pictures of where the

house sitter is going to live. What does their room look like? So, show a

picture of their bed in their room. Show a picture of their kitchen. Show a

picture of the yard, maybe the front of the house. The living space. Show the

space of the home because they're going to be in your home. If you're familiar

with Airbnb, that has a lot of great visuals in it.

You want to take advantage of a lot of great visuals to make your home look

really appealing and like this is a place where somebody would want to spend

some time. I think your pictures also tell a story. You know that old phrase "a

picture tells a thousand words"? Something else you'd want to be aware of...

if you don't want your pets on your furniture and you show

pictures of your pets on your furniture? That's probably not a good idea. So, you

want to show situations that are representative of what you want to be

putting out to the world. And also, we are very neat so we want to be in house sits

that are very neat. Sometimes we see pictures that are kind of untidy

pictures. So, if you are a kind of a messy person and that's your vibe ? That's okay

because you can attract a kind of a messier house sitter, but if you're a

neat person and you want to attract a neat house sitter?

Have your pictures look like your home is neat. So, get the clutter out of the

pictures. Just kind of tidy up and make sure that that is, like, primo

so what you're showing is your best foot forward. So some of

the profiles that we've seen are simply a list of "here all the

chores that you're going to do while you're at our house". While that is

something you might...if you have this expectation that you're gonna have chores

that the house sitters are going to do... it's perfectly fine to have that in your

profile. However, you do need to be considerate of the fact that (at least

that the type of house sitting that we do . We are sitting for free so there's no

money exchanged between us and the homeowner. We're going to travel at our

own expense to be there.). So, with this sort of exchange when you just have us a

list of chores that doesn't seem like it's quite equitable. So really, you got

to sell it a little bit. What's in it for the house sitter to be there? Do you have

lightning quick Wi-Fi? Do you have beautiful views and hiking trails? Are

you walkable to all sorts of things and public transportation? Is your backyard,

like, a peaceful oasis with a beautiful garden? So, sell your home. Do you have a

gourmet kitchen? Whatever! And, you don't have to have a luxury home in order

to get good house sitters but sell your home. So there are all kinds of features

about your home...maybe it's in a quiet location, maybe it's really friendly

neighbors. Whatever. So think about what's in it and why would somebody want to

come stay in your home, getting there on their own expense? But also, you might

want to sell the fact that your pets are really friendly. Or, the fact that your

pets are particularly easy to take care of. So, anything about your situation

that's going to be appealing to somebody is something you probably want to have in

your profile. That's right. And, as Tim mentioned, still lists those chores and

responsibilities so expectations are right out there up front but don't make

that only about "here are your chores" and we see that quite a bit as well. Now, if

you do have a situation where maybe you have a dog who gets up for a three-mile

run at 5:00 in the morning every day and has that expectation?

Definitely mention that in your profile! That wouldn't be appealing to us because

we are later risers than 5:00 a.m., truth be told. But, for people who are

early risers? Not only are they going to welcome that, but they're gonna have...you

want to make sure that your house sitters have their expectations met.

It's important in your profile... if your pet can't be left for more than

1, 2, 4 hours? That's a good thing to put in your profile, because some people

are digital nomads and do a lot of work at home or maybe they're home bodies.

That's great. Some people are out for longer days. And so, having an expectation

of that put into your profile? That's a really great idea.

I'll give an example. We live in the Denver metro area and we live about, a

couple hours from the ski slopes, if there's not a lot of traffic. But, we have

a lot of homeowners reach out who talk about the ski opportunities and the

slopes in their profile. Well, if you don't want anyone leaving your pet for

more than 4-6 hours, you don't want to mention that you're near the ski slopes

because the house sitters might be gone for 10 to 12 hours with that activity. So,

it would be really a letdown if they came for skiing because you advertised

it and then they can't leave because they can't leave your pet for that long.

It is important to clearly communicate your expectations. So, if you have chores

that you want the house sitters or pet sitters to be doing, you do want to make

sure that that is in the profile. It also be a good idea to, maybe, help the house

sitter (or pet sitter) understand how long it's going to take to accomplish these

chores - at least how long it takes you to get these tours

done in a given week (or day). So, we actually had a sit this summer which

had quite a bit of yard work. They had a brand-new yard (and a pool) and so I wanted to take

care of all this stuff and so I was spending a couple of hours a day just

dealing with the stuff that's in the yard. And so, if you know up front that

these things are going to be something that you're gonna have in

terms of expectations? Then you want to clearly delineate that for anybody who's

going to be in your home. So, it's important just to have clear

communication throughout the process. Yes and that would also be dog walks, for

example. So we've had dogs that needed to be walked four times a day at fairly

specific times. We've had dogs and cats that have both needed insulin injections,

that had very specific times they needed their insulin injections. We understand

that completely. Having that sort of thing...you don't have to get into

every detail in the house sit, but things that would help a house sitter

know the situation they're getting into, these aren't bad things. So, we're also

going to suggest that you have a Skype call after you kind-of narrow down to

one or a few house sitters. So you're gonna flush out some of these additional

bits of information, but these are just things to think about as you're creating

that profile so you're getting the right applicants coming in. What's the

transportation situation look like where you live? Is public transportation an

option? Do sitters need a car? Are you going to lend them a car? So, these are

all things to consider. How is that house sitter getting

around? When we're traveling around the world, we won't be travelling with our

car. We're gonna be flying in and without a car so this is very important for us...

is understanding how do we get around? We love taking the bus, we love

taking the subway, we love walking. So are these options where you live or are you

kind of out in a more rural area where it's really tough without a car? So

consider...does the does your pet need to go to a dog park every day or to the vet

for shots or checkups or things like that throughout the trip? You might want

to consider leaving a car with a house sitter for those situations or just to

have in general and that might be something nice to mention in your

profile about the accessibility of where you live. Some things that might seem

obvious, you might want to include that you might not consider. Things like if

you're a nonsmoker, if you're very tidy, if you have a housekeeper that comes on

a weekly basis or a gardener that comes on a weekly basis or whatnot. You

would want to have these things in your profile just to paint a picture of how

your house is going to be in terms of cleanliness and things like this. You

want to make this clear to pet sitters. So, we've heard horror stories about

sitters showing up and the situation is it's very dirty or things like this. And

so, if you make that clear up front - that your situation isn't going to be like

this - that's something you would want to do. And, as a house sitter looking at a

profile like that, that would be very appealing. So, if they said "we have a

housekeeper come every two or four weeks" or whatever I know that that house is

gonna be pretty clean and I know I'm not gonna be walking into a nightmare messy

situation because that would kind of be a deal breaker for us (but you don't

really know until you get there what it's like). You do know if they have a

housekeeper that comes every two weeks that it's probably pretty good. So, again,

don't skip over things that you might think are obvious. Kind-of think of more

extreme situations that house sitters might walk into and maybe put those in

your profile as well. If you liked today's video, please give it a thumbs up.

To get more of our videos please subscribe at the button Tim's pointing

at below. We have an aggressive goal to get to by the end of the year and we

need your help to do it. Thank you in advance. If you have any comments...ask

questions about housesitting - what other topics do you want to see about house

sitting? - down below. We are taking suggestions. Questions, suggestions,

comments. These were the things that are most important to us. If you're a house

sitter, what did we miss? What do you look for that you want to make sure

is in the profile that a homeowner posts? And lastly, please consider sharing

this on your social media. So, house sitting is kind of a big thing

because it's a one of the best travel hacks in the universe, we think. So, please

consider sharing that away and we will see you back on Wednesday with another

video. Thanks so much for watching!