Auto news on Youtube Sep 28 2017

60% of Veterans are affected by preventable diseases

and other preventable health conditions…

Cancer, heart disease, infections, obesity, substance abuse,

mental health and other conditions…

Research shows that Veterans can reduce the risk of disease

and maintain good health through preventive care

including the early detection and treatment of diseases and conditions.

Clinical preventive services, such as disease screening and immunizations,

are key to reducing premature death and disability, and improving the health of our nation's Veterans.

Yet how can VA ensure that both patients and providers

have the right preventive information and tools?

The VA National Center for Health Promotion and Disease Prevention

– or NCP –

provides recommendations on dozens of clinical preventive services that can prevent or reduce

the risk for heart disease, cancer, infectious diseases,

and other conditions that impact the health of Veterans.

NCP is VA's central resource for evidence-based, clinical preventive services, guidance and resources.

NCP CPS Guidance Statements provide clinicians with recommendations based on the best available

evidence on such topics as disease-specific screening,

counseling, and preventive medications.

NCP maintains and regularly updates more than 30 guidance documents

as sources for making clinical decisions about preventive services.

The guidance statements consider the scientific evidence

on each topic as well as the recommendations from the

U.S. Preventive Services Task Force (USPSTF), American Cancer Society and the

Advisory Committee on Immunization Practices (ACIP).

The evidence and recommendations are carefully considered by

VA's Preventive Medicine Field Advisory Committee in

the development of VA's guidance on preventive services.

NCP ensures that VA clinicians have access to the critical information they need to deliver

the best health care possible including:

Clinical Preventive Service Guidance Statements

Clinician fact sheets to guide practice of prevention methods

National clinical reminders such as reminders for breast cancer screening,

cervical cancer screening, and pneumococcal immunizations

Review of information for safety alerts

Monthly updates on prevention.va.gov, and National Health Promotion and Disease Prevention call to

address the latest evidenced based information and resources

NCP also delivers Clinical Preventive Services (CPS)-aligned information to

Veterans through support tools such as MyHealtheVet

and the NCP website www.prevention.va.gov.

Healthy Living Messages including "Get Immunizations and Screenings"

and "Be Involved in Your Health Care" provide Veterans with

the tips and tools to take charge of their health and wellbeing.

What are the benefits?

Prevention Works!

VA prevention guidance and tools are helping clinicians

deliver evidenced-based preventive care to Veterans.

Due in part to NCP's Clinical Preventive Service guidance,

VHA is the recipient of

the National Colorectal Cancer Roundtable's 80% by 2018 National Achievement Award.

To learn more about NCP, Clinical Preventive Services

and available resources

go to: http://vaww.prevention.va.gov/CPS.

For more infomation >> Clinical Preventive Services - Duration: 3:41.

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

Using Web Services in Dynamics 365 for Financials for reporting - Duration: 12:37.

Hey everyone, Chris here from the Support Team,

I wanted to create a quick video to demonstrate how you can use the Financials Web Services for Reporting.

You don't have to have any developer knowledge to make use of the OData v4 M points,

you can pull data into Excel or Power BI and build reports right now.

So let's take a look at the Web Services page.

The Web Services page is where you can expose pages queries

that you want to be able to pull information out of Financials

and down to Excel or Power BI to build reports.

It's very easy to do, you can use these links over here

and you can pick new pages to expose depending on the data that you need to pull

and the reports that you want to build.

Let's start of by taking a look at the Sales Document lines

and Sales Documents Web Services.

First thing I want to do is make sure

that your user has a Web Service access key generated,

so let's navigate to the user screen,

I'll select my user and what you're looking for here

is that you have a Web Service access key for the user generated,

if you don't, you can use this button at the top to generate one,

but you will want to have a copy of your user name here

and your Web Service access key here,

as these will be used as your user name and password when you go to Connect to the Web Service M Points.

Now that I have my user name and password, I am going to navigate to Excel.

In Excel we can go to Data, Get Data From Other Sources,

from OData Feed and this will pull up a prompt asking for the URL.

Back in Financials I will select my Sales Documents,

OData v4 URL, I'm going to copy that shortcut,

come back to Excel and paste that in.

Now it's going to come up for authentication.

For the authentication we'll go to Basic

and we will use the password that we just got off the user card.

Once I paste that in here and hit Connect,

we should be getting a preview of the data that we are pulling from that OData feed.

There we go, this is our purchase header information, I'll go ahead and load that,

I'm going to navigate to a new sheet and do the same thing, I'll go to Data, Get Data, From Other Sources, From OData Feed

and this time we will copy our Sales Document Lines OData v4 Feed URL,

I'll to plug that in and this time Excel will remember our credentials

and should just load up the preview immediately.

You can edit here if you want to, I'm just going to load it all in

and now I have a refreshable set of data,

header and line data that I could slice and dice and build reports of in Excel,

if you have an Excel power user that you can give this to,

a refreshable report, they can start making reports of this immediately.

Let's take a look at another example and how we can add new web services.

I once had someone ask me if there was a report that showed you the Inventory on Jobs versus the Inventory quantity on hand,

they wanted to be able to see if they were going to have enough inventory on hand to fulfill jobs in real time.

I don't think we have a report like this,

but I said we can build one of the web services.

On the Web Services page, if you want to add a new page,

to expose that for building reports you can do so by using this Create Data Set wizard.

Now, for the report that I'm talking about we will need to have Items page and Job Planning Lines page exposed.

Items page is already exposed, so we just need to expose the Job Planning Lines.

We'll just go to the wizard to create a new data set, this Data Source ID section;

you can click the ellipses to do the lookup,

and I can do a search here on 'job',

I'll do 'job', and I then should be able to find the Job Planning Lines page, here it is right here,

so that's the one I'll add, give it a name

hit Next and then it will allow you to filter the data that you want to pull,

this doesn't really matter, so we'll just publish it.

It finished, and I should get a Job Planning Lines web service published now.

Here it is right here.

So now I have Items and Job Planning lines, I should have the Web Services I need to build the report,

so let's jump into the Power BI desktop,

I am going to be pulling the data into Power BI desktop in almost the exact same way that I did with Excel.

I am going to Get Data, OData feed, and I am going to grab my URLs, we'll go with Items,

plug that in,

and then it will ask for credentials where we will use our username and the web service access key

and this should give us a preview of the data just as Excel did;

there's my Inventory and my Quantity on hand.

Now, I know the data that I need to build this report, so I'm going to add it,

because I really only need to bring in the Number, the Description, the Type and the Inventory Count,

I don't need any of this other data coming in, so we can simply remove those columns.

Now this makes the query a little more clean if I'm not pulling all that data down that I don't need,

the query should considerably run faster, so let's close and apply that.

Now we can get the data for the Job Planning Lines the same way,

I'll just jump ahead here to save time,

so here I am with my Job Planning Lines data,

I'm just going to load this editing to save time;

I now have the queries that I need to build my report;

the first thing I'm going to do is to rename my queries so that they're easier to identify,

so I will rename this one to 'Items'

and I will rename this one to 'Job Planning Lines'.

The next thing I am going to do is setup a relationship between the two sets of data,

I can go to the Manage Relationships button here at the top and set up a new relationship

and I want the relationship to be between the numbers,

so the Item Number and the numbers on the Job Planning Lines.

Now Job Planning lines can contain Resources, Text or Items,

so if I have an Item Type on the Job Planning line it should have an Item Number here,

so I do want those to tie together with the One to Many relationship.

Next thing I am going to do is rename my Quantity field to Job Quantity,

just so I can differentiate that, to know that that's my Job Quantity and not Quantity on hand.

Now let's start adding some columns from the items to our report: Description, Inventory, to start off,

I can see now the full list of my Inventory and how much I have on hand,

now let's add the Job Quantity column.

So now it filters down to just to the matchup and both have values;

I do have a blank one here which I can easily remove by setting a filter,

if I go to Description and Select All and Remove Blank, that will take care of that.

Now I only have inventory items that are listed that are actually on.

Job Planning Lines.

So this is fine, this is showing me how many I have on jobs and how many I have on hand,

but if this got bigger, it would be harder to read, so let's get a third column going,

we want to calculate a column that actually shows us the difference,

so I'm going to right click over here on Items, I'm going to add a new measure;

now, the measure that I'm about to put in here I'm just going to copy paste in,

I'm not an expert on creating measures in Power BI,

but I was able to create this one after about five minutes of looking on Bing,

essentially all it's doing is subtracting the Job Quantity from the inventory QOH

and if we add that, it will help;

if we add that we know get a difference as a third column,

the problem is it added all the items back, not just the ones that we have on jobs,

so let's do another filter

and we will show Job Quantity only where it is greater than zero

and apply that filter and now we're back to see.

So this is great, this is fine.

But the final thing that we would want to do is maybe add some kind of a visual indicator

for when we have a negative difference,

so let's go over to the difference value and do conditional formatting

and we'll do a diverging, we will do the lowest value of zero

and then make it a reddish color I guess,

middle value can be one and the highest value can be nine

and we'll hit OK

and we don't see anything changed and we shouldn't,

because we don't have any negative values,

but, if we go into Financials now

and add some more tables or some chairs to a job,

we should see that change.

So, let's go to one of our jobs and you can see how this updates in real time;

going to this job,

we'll go to the Job Planning lines and instead of eight BERLIN guest chairs,

we'll do a hundred and five BERLIN guest chairs

and I can immediately go back to my report,

hit Refresh and we should see a change.

Now I have a report with a visual indicator allowing me to know if there's a problem

that I am going to have a negative inventory based on the number of chairs I currently have a sign on Jobs.

Now, you can get columns filling in which job is on,

obviously there's a lot of power here, for basic, ugly reporting this is just an example.

You can build up as many report as you want, put them on a Power BI Dashboard,

give those to your users to do their job more effectively.

I hope this video helps you to get more value out of the Financials product

and as always if there is any questions you should head over to the community forms and ask away.

Thanks!

For more infomation >> Using Web Services in Dynamics 365 for Financials for reporting - Duration: 12:37.

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

Human Services Secretary Tom Price Took $17K Private Flight For 90 Min Of Work | All In | MSNBC - Duration: 2:58.

For more infomation >> Human Services Secretary Tom Price Took $17K Private Flight For 90 Min Of Work | All In | MSNBC - Duration: 2:58.

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

Reimagining the customer experience in financial services - Duration: 46:07.

For more infomation >> Reimagining the customer experience in financial services - Duration: 46:07.

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

View the status of an invoice file in online services for providers - Duration: 2:26.

ReturntoWorkSA's online services for providers makes it easy to search for, view and understand the status of your invoice file upload.

In this video, I'll show you how to search for invoice file upload history and understand the invoice submission status and invoice payment status, and download invoice search results.

To view the status of an invoice file, go to Invoice upload (bulk).

Here you'll find the Invoice search box. Let's search for invoice files uploaded successfully during the last week.

You may experience a bit of a wait time depending on the amount of information the system needs to display.

Let's take a closer look at the Invoices submission status, and Invoice payment status columns.

The first column of the Invoices submission status, Received, indicates the number of invoices that were received in the invoice upload.

The second and third columns, Valid (yes) and Valid (no), indicate how many of the invoices were accepted for processing or not. To view the details, I simply click the numbers under each column.

When we look at the invoices that were valid and accepted for processing, you can see a filtered view of the Invoice search, including:

The Payee and ReturntoWorkSA invoice numbers, which clicking allows you to download the Provider Invoice details as a PDF.

The ePay reference number.

The Claimant name and Claim number.

The Invoice date and status.

The Claims agent.

The Invoice amount, the Amount paid.

As well as the ability to view the Remittance information.

Also notice the little arrow. This handy feature allows you to download the search results as a CSV file.

Let's now look at the Invoice payment status columns. Again we have three columns.

The first column, Paid, indicates invoices that have been paid, which when you click this you get the same filtered view of the Invoice search screen.

Column two, Denied, indicates invoices that were reviewed but the payment rejected. Clicking this number provides additional information that can be printed off.

And column three, Pending, indicates any invoices that are still being processed.

For more infomation >> View the status of an invoice file in online services for providers - Duration: 2:26.

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

Claim check tool in online services for providers - Duration: 1:23.

ReturntoWorkSA's online services for providers makes it easy to search for and view if a claimant has a current claim and who is handling the claim.

In this video, I'll show you how to: • Search for a claim using the claim number. • Search for a claim using claimant details, and • View who is handling the claim.

To check claim numbers and who is handling them, simply click Claim check or select the same item from the Search menu.

On the Claim check search screen you can find the information using either the Claim number above the line or the Claimant details below the line.

If you don't have the claim number, you'll need to complete all of the other details.

Notice at the bottom there is a declaration that you have the Claimant's consent to search for the claim related to the injury.

I'll go ahead and perform a claim check using claimant details.

Great, now you can see the claim is active and who to contact if you require more information.

For more infomation >> Claim check tool in online services for providers - Duration: 1:23.

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

Overview of navigation, help and settings in online services for providers - Duration: 2:12.

It's easy to find what you need on ReturnToWorkSA's online services for providers.

In this short video, I'll give you an overview, including the: • Home screen, • Help and Feedback functions, • Change password function, and • Notification preferences function.

The home screen can be divided into four main areas.

On the top you can view your provider details as well as the Help and Logout functions.

In the main area, you'll access your functions.

In this area, you'll see any communication from ReturntoWorkSA

and in the footer, you can view ReturntoWorkSA's contact information and policies.

In the Help function, you'll find lots of useful information such as customising your view.

Remember, when in doubt, you can contact ReturntoWorkSA by email or phone.

ReturntoWorkSA also encourages you to send feedback, to help improve the service.

To view your account details, click the arrow next to your name or provider ID.

Straight away you can see the organisation details you're logged in under.

If you're registered as a user with more than one organisation you can switch organisations here.

You can also view and update your account settings, such as: • Changing your password, and • Modifying your notification preferences.

To change your password, simply enter your current and create and confirm your new password while being mindful of the password rules.

After changing your password, you'll need to login with your new password.

Notification preferences allows you to turn on or off notifications,

change the frequency with which you'll receive notifications as well as add up to three email addresses.

It's important to remember that these notification preferences are only for the organisation you're logged in under.

For more infomation >> Overview of navigation, help and settings in online services for providers - Duration: 2:12.

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

Upload an invoice file to online services for providers - Duration: 1:45.

Uploading an invoice file to ReturnToWorkSA's online services for providers is a much more efficient way to send multiple invoices for processing. In this short video, I'll show you how to upload an invoice file.

To upload an invoice file, simply click Invoice upload (bulk), or click the same item from the Invoices menu.

Remember to check that the invoice file meets ReturnToWorkSA's file format requirements.

When ready, there are two ways to upload an invoice file.

First is to click Select file, which will open your computer's file explorer window and from here you can find your file and click Open.

Second is the drag & drop method, where you can drag your invoice file directly from your computer's file explorer window and drop it into the grey dotted drop area. Note that you may select multiple files to upload.

Note that you may select multiple files to upload.

To get this far, the invoice file must be in the correct csv or txt format and not exceed one-megabyte in size.

At this stage, you could also Remove a file.

Let's click Upload and see what happens.

Now you can see the message indicating the file was uploaded successfully.

However, to check if there were no format errors, you'll need to check the status of your invoice file using the Invoice search.

Let's click Search and display the status of the file just uploaded.

Great, no format errors are reported and ReturntoWorkSA will now process the invoices.

For more infomation >> Upload an invoice file to online services for providers - Duration: 1:45.

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

Health Services - Duration: 1:08.

My name is Nadine Miller I am the Director of Health Services, Audiology, and

Homebound. We support student success by helping our kids meet their medical

needs whether that's a medication at school, a procedure that they need,

helping with their chronic illness, we do vision screenings and hearing screenings.

W look at everything that that child needs to make that child successful. I

really think that my teams out in the schools and my team here at student

services, we really work for those kids every day. Watch my nose. Very good. Look over here. Good. One more eye. Hey, I heard you're having a

rough morning. Tell me a little bit of what's going on. I love being a school

nurse because I love the opportunity that I have to really make a difference

in a child's life. Not only will their medical needs be taken care of, they have

a safe environment to come to, but they also have that resource in that health

office every day to support them, to be there for them, to make that child

successful.

For more infomation >> Health Services - Duration: 1:08.

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

How do grocery delivery services work? | How do online bulk stores work? - Duration: 8:45.

hey guy! Shawn here from shawnmhowell.com. what is the deal with home delivery

grocery services like instacart specifically and boxed? so i have some

thoughts and if you are a bit curious about home delivery services like

instacart and big box services like boxed keep watching. having just had a

baby it has been hard to get to the grocery store. my husband has been doing

an excellent job of going to the grocery store but i was curious about the home

delivery services that the grocery stores in my area have been pushing and

advertising. the Food Lion is the closest one to my house so I looked online and

they use a service called instacart. and I have done two orders with them both

with free delivery because the first one is free and I will post a link on how

you can also get free delivery on your first service with instacart in the links

down below. you go online and you pick out the groceries that you want to get

and they get delivered by a person..an actual person... from a local grocery store.

in my case my Food Lion is closest. so you could pick what grocery store you

want them to come from. the prices are are kind of weird.

the instacart sets the prices. you don't necessarily get the prices that are at

Food Lion but they do have a section of sale items and coupons that you can also

add to your cart. that's kind of where I tend to shop first is from the sale

items. but I've found that it saves me money because I don't have any of those

impulse buys. so I put together my grocery list and normally I'd take it into

the store and I find other things to just add to the card and before you know it I

bought a hundred dollars in groceries. well these days having an infant I need

to start saving money on our grocery bill. we are trying to spend fifty

dollars a week. so with instacart that really helped us. I think it's at $55 both

times but it really helped me stay focused on what I needed to get and

making choices. and the really cool, another cool thing about it, it will tell

you how long it will take for you to get your groceries delivered based on the

time of day. both times, well the first time I ordered it didn't

take but an hour to get to me. for them to deliver the second time

on the Saturday night and so I could set what time I wanted it to be delivered on

Sunday morning which was really cool. and then you have a personal shopper who

gets paid to go and shop for your groceries that you've picked out.

and they will contact you if something is not in stock when they can't find it they will

text you or text you through the instacart app and let you know they

couldn't find it. or could they substitute with something similar.

a recent example is I had there was a bag of, a box of Ritz crackers that I

had wanted and they found a box but the box was split open and the guy looked

and sure enough the bags inside of the crackers were ok. they were fine so I

said yeah I don't mind a damaged box as long as the inside is

fine. well alright so guys I am recording a video: I just got my second order

from instacart that came from Food Lion but my shopper was so awesome he found

that the Ritz cracker crackers that I ordered were damaged so he drove to

Publix and replaced them. which is pretty cool .and had this news but they keep in

constant communication with you .if you need to add something to your order you

can text them. oh I forgot you know I forgot milk or I forgot to order toilet paper or

something. you can add that to your order very easily. so I don't know how much

delivery charges are. they do charge some kind of fee or the name of the fee is

but some kind of a fee that they say pays the employees but you can

choose not to do that fee I think we said at 10% so I choose

not to do that but then they have an option for tipping your actual delivery

person and you can tip different percentages so I usually transfer that

10% and do a 10% tip for the person who's delivering my groceries because I

feel like, I don't know, I feel better about that. I like that they're very

speedy. and coming over like I said I don't know what delivery fees are and I

know there's some kind of a fee a yearly subscription you can sign up for

it. I haven't done that. so the first one I did I got free delivery. the second one

they sent me an email saying if you use

this coupon code within the next week you get a free delivery. so I ordered

that again. so if they send me another delivery, free delivery option... what's up

with us? we love free delivery and free shipping...

us Americans. then I will do that again so definitely worth it. definitely

worth looking into. definitely worth doing once to see if you like it. so I'm

going to insert some footage that I took the day that the groceries arrived so

you can kind of see what I bought. so here are the groceries that I ordered.

I only spent like fifty five dollars and I got free delivery. and I've been very

impressed because you can talk with your shopper to make sure you know that you

get the things you want. or if they don't have something in stock then you can

request a different thing. so I got some yogurt, yoplait whips. let's

say I got the chocolate and also got the key lime. and we got macaroni and cheese

over here and some lemon juice and some cheese nips. huge bottle of vinegar.

the prices you don't get to pick but they tell you the prices up front and

sometimes they'll change like to two thirds. and I got a whole bunch of

chicken and vegetarian options. we need some cream cheese. veggies. you can

get fresh vegetables too. bananas. what else? we got Oreos. but anyway I just

bought like my regular things that we needed and they were here at ordered

them a lot of times that you can order them in an hour.

but I ordered last night and then they shopped this morning and delivered them and

pretty cool instacart. so while we talk about groceries and saving money I

thought that I would also talk about boxed.com. so I've been using boxed for probably

a year ,maybe a little over a year now but I haven't been going through boxed.com.

actually didn't even put that together. I have been a user of Zulily.com

which is a discount website and occasionally probably once or twice a

month show boxed offers free shipping if you purchase $50 through the

Zulily app. and they have tons of things that are even further discounted than on

boxed.com. household goods and snack items. so I stock up on toilet paper, paper

towels, they're paper towel brands really good, they're napkin brand, they have

their own it's called Prince and spring. really good products. I purchased their

soap before but then I also have big-name products. they have Charmin

toilet paper. they have Bounty paper towels.

they have occasionally... they have razors on there.

I buy tons of snack items: granola bars, nutrigrain bars, chips,

fruit snacks, Gatorades, anything that you would buy like at a Costco or a Sams they

have those items. so I will usually spend anywhere from fifty to eighty five

dollars on Zulily app and get the two day free shipping. and so that's how

an ordering box. well I recently ordered through boxed.com, the actual website,

because again they were doing the free shipping deal and I think I ordered a

little over a hundred dollars maybe like one hundred fifteen, hundred twenty

dollars worth of stuff. and it came it was really great and everything but I

still feel like going through the Zulily app is the way to go because I feel like

they further discount stuff on the Zulily app. But if you just go through

boxed.com but it's worth going through boxed.com to get that free shipping and

to see the variety of stuff that they have if you don't already use Zulily. they're Zulily app so I will put the Zulily app down below I will also

put the boxed.com link down below and I think they also have like an affiliate

thing where I can get you free shipping and like $10 or $15 off and then I get

10 or 15 something like that. so I'll put that below. again you don't have to use

that code or you can if you want. I hope that you found this video useful when

you are thinking about using a grocery delivery service like instacart or a big

box service like boxed.com. I hope that you found my review helpful

to you in some way. if you did please give me a thumbs up, share it with your

friends, and don't forget to subscribe. and I will see you in my next video.

thanks for watching. bye!

For more infomation >> How do grocery delivery services work? | How do online bulk stores work? - Duration: 8:45.

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

Build an intelligent and secure app with Azure managed service for MySQL and PostgreSQL - Duration: 1:20:53.

For more infomation >> Build an intelligent and secure app with Azure managed service for MySQL and PostgreSQL - Duration: 1:20:53.

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

6 Tips to Save Your Organization Money with Amazon Web Services - Duration: 9:01.

(dramatic music)

- Greetings everyone,

Raymond Lacoste here,

with Stormwind Studios,

and I wanna take this opportunity to save you money.

Now how am I gonna save you money?

Well, I am going to give you six tips

to save more money with AWS.

Why?

Because I saved 50% because it was on sale.

So how are you gonna save money with AWS?

Well first and foremost,

you wanna pick the right size EC2 instance.

It's as simple as this.

Don't use an instance

that is gonna give you more than you need.

More what?

More CPU, more memory, more storage, more networking.

If you use an instance

that gives you more than what you need,

then you are paying for resources

that you don't actually need.

So don't over provision,

and also, don't under provision.

So to make sure you don't over

or under provision your resources,

you wanna adapt.

So if you realize you've over or under provisioned,

scale up, scale down, scale in, scale out.

That's right, adapt as the needs of your business change.

I want you to take a look at reserved or spot pricing.

A lot of people are only familiar with on-demand pricing,

because they haven't taken the time

to learn about what is reserved pricing,

or what is spot pricing when it comes to AWS.

Well, reserved pricing

is essentially a contract between you and AWS,

that states for the next year, or three years,

you can do an all, partial, or no up-front payments.

And, for 24 hours a day, seven days a week,

365 days a year,

for that one or three year timeframe,

you will pay this amount of money on an hourly basis

for that instance.

You might be saying, "Wow, gee, that's a lot of money."

Well wait, if you compare that same timeframe

to on-demand pricing,

you could save up to 75% if you use a reserved instances,

over on-demand pricing,

over that period of time, so plan ahead.

Spot pricing.

Oh, this is an interesting one,

it's like playing the stock market.

What I'm gonna do,

is I'm gonna set a certanin price limit,

that I wanna pay for using an EC2 instance.

If the price is below that value,

then the instances are gonna be launched,

and I will be able to use those instances

for what I wanna use them for.

However, if the price goes above that value,

so let's say I pick 10 cents,

and the price goes above 10 cents per hour,

then those instances are gonna be terminated,

or no instances are gonna be launched.

Why?

Because it's above my price.

So I bid on spare EC2 computing capacity

that's not being used in that moment in time,

and I could save up to 90% over on-demand pricing.

That's right, up to 90%.

That's a huge cost savings.

So in your organization,

if you plan properly,

you're gonna have a mixture of on-demand pricing,

reserved pricing, and spot pricing,

so that way you can save as much money as possible,

running those EC2 instances.

Now, do not pay for something you are not using.

How many times have you told somebody in your household,

"Shut off the light when you're exiting the room!"

Right?

Your child leaves their bedroom, they leave the light on,

eventually you realize the light's on,

and you remind them again, "I don't wanna pay

"for something I'm not using."

Meaning, I don't wanna pay for that electricity,

if nobody is in that room.

Same thing here.

Terminate instances that are not being used.

Now if you're using reserved pricing,

you're gonna pay for it no matter what,

whether it's running or not.

That's the idea behind reserved pricing.

But you're gonna save a lot of money.

So I'm talking about on-demand instances here.

If there are on-demand instances running,

and you're not using them to their potential,

or using them at all,

terminate them, get rid of them!

'Cause you don't wanna pay for something

you are not actually using at that moment in time.

Now, EBS volumes are gonna be used with our EC2 instances.

So if you have EBS volumes

that are no longer attached to an EC2 instance,

or you have snapshots of EBS volumes

that are no longer needed,

then you're paying for storage that is not needed anymore.

So if you come across any EBS volumes

or snapshots in your account,

that you're no longer utilizing, or no longer need,

make sure you delete them,

so you don't pay for that storage anymore.

I really like being advised

on things that I, well, need to be advised about,

and we have this tool that's given to us by AWS

called the Trusted Advisor.

And I want you to use Trusted Advisor.

AWS wants you to use Trusted Advisor.

Why is that?

Because Trusted Advisor is going to scour your account,

and locate resources, and services, and features,

that you can save money on.

What?

Did Raymond just say that properly?

I did.

Trusted Advisor will go through your account,

and find areas that you can save money on,

as well as other things.

But I really like the saving money-aspect of it.

So AWS created a tool,

that will allow me to pay them less money.

Huh, that is great.

I love this tool.

So take advantage of Trusted Advisor.

One of the things that people get, or forget about,

that's what I'm trying to say, forget about,

is elastic IP addresses.

So here's an example.

Elastic IP addresses is simply a public IP address

that's given to you by AWS.

And I might need one, two, three, four, five, whatever,

and then I associate those public IP addresses

with EC2 instances.

If I am using those public IP addresses on EC2 instances,

I don't pay for them.

That's right, I don't pay for them if I'm using them.

I only pay for them if they're associated with my account,

and I'm not using them.

So AWS does this

so you're not hoarding public IPB 4 addresses.

They'll start charging you for them

if you're not actually using them.

So Trusted Advisor will look to see

if you have any unused elastic IP addresses,

and warn you about them,

so that way you can give them back

so you no longer have to pay for them.

So there's a great advantage of using Trusted Advisor.

AutoScale, use CloudWatch, what does that mean?

Well CloudWatch is gonna allow me to monitor my resources.

So let's say we have instances running,

and they're in a group,

and the CPU utilization gets to 80%.

Well, then we can use AutoScaling to scale up,

so that way that as a group,

we add more servers to the group,

and then CPU utilization goes down.

But we can also use this in reverse,

meaning that if we have a whole bunch of servers

that are a part of an AutoScaling group,

and resource utilization drops,

let's say down to 20% amongst the group,

then we take a server away.

So every time as a group,

if those servers combined equal 20%,

take a server away, take a server away, take a server away,

so that way we don't have to pay for servers and resources

that we don't really need to pay for.

So we can grow and shrink the number of instances

to meet the needs of our organization automatically,

and save us money.

And lastly here, Cost Explorer.

With Cost Explorer,

you're gonna have the ability to keep track of costs,

you'll be able to keep track of usage trends.

You'll even be able to keep an eye on your billing.

So set up billing alerts,

so that way there you'll be notified

if your bills get out of control.

Meaning that you get a bill that's gonna be coming in,

that's way more than you anticipated.

So you might say, "Well, on average,

"we only spend $200, or not even on average,

"maximum we've ever spent in the last year,

"has ever only been 150 bucks."

I am going to set a billing alert at $200.

So if you ever go over $200,

I'm gonna be notified right away,

so that way we can take action

and adjust resource usage as needed.

So folks, I really hope you will take advantage

of my tips for saving money with AWS.

Until next time folks,

everyone here at Stormwind Studios

wishes you the utmost fantastic journey with AWS.

Take care everyone, and bye for now.

For more infomation >> 6 Tips to Save Your Organization Money with Amazon Web Services - Duration: 9:01.

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

Cert Exam Prep: Exam 70-347: Enabling Office 365 Services - Duration: 1:21:25.

For more infomation >> Cert Exam Prep: Exam 70-347: Enabling Office 365 Services - Duration: 1:21:25.

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

Rodriguez Musical Services - Duration: 0:21.

Premium, hand-selected Buffet clarinets

Artist level overhauls and repair work

Visit our shop in Atlanta

Let us send you a selection to try

Or meet us at a convention

Premium products and services

For your best performance

For more infomation >> Rodriguez Musical Services - Duration: 0:21.

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

Create an invoice file to upload to online services for providers - Duration: 5:23.

Creating an invoice file, either manually or using finance software, and uploading it direct to ReturnToWorkSA's online services for providers,

is a much more efficient way to send multiple invoices for processing. In this short video, I'll show you how to manually prepare an invoice file.

To upload and validate your invoices, you'll need to prepare an invoice file in a specific format.

Invoices that do not meet the format requirements will not process successfully. Let's go to Invoice upload (bulk).

Here it highlights that files must be: • Comma delimited and in one of two formats; csv or txt, and • Provides the link to the file format requirements.

I'll step you through a csv invoice file in Microsoft Excel.

An invoice file must contain only one header row and then any number of detailed record rows.

The header row must include eight attributes that describe the practice or payee details and the total value of the invoices being submitted.

In cell A1, you'll always enter 00 to identify this as the header row.

In B1, you'll enter the date the invoice file was created.Dates in an invoice file can only be in one of these two formats: • DD/MM/YYYY, or • YYYYMMDD.

In C1, you'll enter the total number of detailed record rows included in the invoice file.

In D1, you'll enter the total value of the invoices being submitted. Which is basically the total of column O, which you'll learn more about soon.

In E1, you'll enter the name of your practice or the payee. This field can contain letters, numbers, ampersands and forward slashes but it cannot exceed 50 characters.

In F1, you'll enter the practice address. The length of this field cannot exceed 100 characters and can include letters, numbers and special characters like comma, dash and forward slash.

If you do use commas you'll need to include double quotes around the contents.

In G1, you'll enter your Australian Business Number or ABN. This can be no more than 11 characters and can only contain numbers.

In H1, you'll enter the words Tax Invoice.

Now let's look at a detailed record, starting on row 2.

A detailed record contains 16 attributes, most of which are required.

In A2, you'll always enter 01 to signify a detailed record hence it is repeated on every row for multiple records.

In B2, you'll enter the payee's invoice number. This invoice number cannot exceed 15 characters and can only contain letters and numbers.

In C2, you'll enter the date the payee generated the invoice.

In D2, you'll enter the claimant's claim number. This cannot exceed 8 numbers, leaving out any leading zeros, followed by a forward slash and then an additional two numbers.

In E2, you'll enter the ReturnToWorkSA service provider number, or if you're a medical or allied health provider, the Medicare provider number for the provider who performed the service. This field cannot exceed 8 numbers.

In F2, you'll enter the date the service was provided, or commenced if over more than one date.

In G2, if the same service was performed on the same date, you'll enter the time the service was provided; otherwise it can be left blank.

For time, you'll use the hour colon minute 24-hour format. For example for a service provided at four forty-five in the afternoon you'll enter 16:45.

In H2, you'll enter the end date of the service, provided it's different to the date commenced, otherwise it can be left blank.

In I2, you'll enter the service item code. This cannot exceed 6 characters and can only contain letters and numbers.

You'll leave J2 blank.

In K2, you'll enter the description of service provided. This cannot exceed 60 characters and can only contain letters and numbers.

In L2, you'll enter the standard rate for the service. Where a service attracts a GST component the rate recorded here must be the rate plus GST.

In M2 and N2, you'll enter the quantity of service provided and the unit of measurement.

Bear with me while I explain this...

If you enter an H in N2, then the unit of measurement is hours. So if you enter 2.5 in M2 then this is equivalent to two and a half hours.

If you enter an M in N2 and then twenty-four in M2, then this is equivalent to twenty-four minutes.

Finally, if you enter a U in N2 and then a four in M2, then this would be recorded as four units.

In O2, you'll enter the value of service being invoiced. This should be equivalent to the standard rate entered in L2 multiplied by quantity of service entered in M2.

In P2, you'll enter the GST inclusive flag. Enter Y if the value in L2 includes a GST component, otherwise enter N.

Now save the Excel spreadsheet as a csv and with a relevant filename.

Finally, ensure the file size is less than one-megabyte.

For more infomation >> Create an invoice file to upload to online services for providers - Duration: 5:23.

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

SMS to Emergency Services - Duration: 2:49.

For more infomation >> SMS to Emergency Services - Duration: 2:49.

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

Search for invoices in online services for providers - Duration: 2:19.

ReturntoWorkSA's online services for providers makes it easy to search for and view invoice information.

In this video, I'll show you how to: • Perform a simple and advanced invoice search, and • Download invoice search results.

To view invoices, go to Invoice search, or click the same item from either the Invoices or Search menu.

By default the simple search will return all invoices created in the last 30 days. However, there is a maximum number of invoices that can be displayed, so you can narrow the simple search using the three filters...

Invoice or ePay reference number.

Invoice status.

Invoice history, which allows you to view invoices created up to a maximum of 90 days in the past.

Let's look at the Advanced search.

The Advanced search provides more options to help improve the efficiency of your search, including...

Invoice date range, which is restricted to 90 days.

Date of service.

Paid date range, also restricted to 90 days.

Provider number or name.

Agent name.

Claim number, and Claimant.

Let's do a search for invoices paid in the last week.

When we look at the invoices that were valid and accepted for processing, you can see a filtered view of the Invoice search, including...

The Payee and ReturntoWorkSA invoice numbers, which clicking allows you to download the Provider Invoice details as a PDF.

The ePay reference number.

The Claimant name and Claim number.

The Invoice date and status.

The Claims agent.

The Invoice amount, the Amount paid.

As well as the ability to view the Remittance information.

Also notice the little arrow. This handy feature allows you to download the search results as a CSV file.

For more infomation >> Search for invoices in online services for providers - Duration: 2:19.

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

Get access to online services for providers - Duration: 1:38.

Registering for ReturnToWorkSA's online services for providers, is easy.

In this short video, I'll show you how to: • Find the Registration form on the ReturnToWorkSA website, and • Complete the form based on Entity and User type.

Let's find the Registration form on the ReturnToWorkSA website.

Download and save the form to your computer and start completing it straight away, no need to print.

I'll demonstrate as a staff member using the online services on behalf of my practice, beginning with the User details.

To ensure the business details are correct in the Type of access section, it's best for an authorised officer of the business to provide the information.

This can be the owner, proprietor, director or partner.

The Entity type is a description of the business and the User type determines how the user will use online services.

In my case, I work for an allied health provider as a practice manager

and I require Master user access so that I can access remittances and payment history.

You'll also use this form to remove access for a user.

If you ever forget your username or password and need to contact ReturnToWorkSA, they'll use the secret question in the Validation section to identify you.

Now all that needs to be done is the declarations including the authorised officer before sending it off to ReturnToWorkSA.

For more infomation >> Get access to online services for providers - Duration: 1:38.

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

Fix common problems with invoice files in online services for providers - Duration: 3:19.

Uploading an invoice file direct to ReturnToWorkSA's online services for providers, is the most efficient way to send multiple invoices for processing.

In this short video, I'll show you how to address some of the common problems when uploading an invoice file.

After uploading an invoice file, you'll use Invoice search to check for format errors.

You can see that the File upload status for the invoice file has a red cross and an Errors box. Let's click the Errors box to find out more.

The errors are now listed with the line and field number as well as a description. You'll refer to this as well as the file format requirements to fix the error. Also notice the handy Print feature.

The first error is pointing to line 1, the header, and indicates that the ABN is invalid.

We know there should only be eight attributes in the header but looking at this file we can see nine. On closer inspection we can see that the practice address has split across two columns.

This happens when a comma is included in the address but the information is not contained in double quotes.

The rest of the address then becomes the next column, which should contain the ABN instead.

I'll add the double quotes around the address.

The second error is for the ABN that is now in the Tax Invoice field.

The third error, is pointing to Line 2, Field 3. This corresponds to C2; the date the payee generated the invoice.

Dates in an invoice file can only be in one of these two formats: • DD/MM/YYYY, or • YYYYMMDD.

I'll change that to the correct format.

The fourth error, is pointing to Line 2, Field 4. This corresponds to D2, the claimant's claim number.

This field cannot exceed eight numbers and there are ten numbers there. I'll fix that up now.

The fifth error, is pointing to Line 2, Field 7. This corresponds to G2; the time a service was provided.

Time in an invoice file must use the hour colon minute 24-hour format. I'll change that to the correct format.

The final error for this invoice file, is pointing to Line 3, Field 1. This corresponds to the field that signifies a detailed record and it should be a 01 and repeated on every row after the header.

We're now ready to upload the invoice file again. Save the file with a new name and in the appropriate format.

The upload was successful and a quick search indicates that no errors were found in the invoice file.