tasks due in the next week/tasks overdue

[Robert Juarez]

I want to create 2 different views for a project in PWA for PS2K7 that display:
1. All tasks due within the next week. I know I need to do a filter and I
recall somewhere seeing something like Finish=[Today]+5 or something like
that, but I can't remember exactly. I'm hoping someone can help.
2. All tasks past due. I'm guessing this would be something similar where
Finish<Today and % Complete "not equal" to 100, but I'm not sure.
Thanks!

 

[Andrew Lavinsky]

The challenge will be to dynamically filter based on the current date. PWA
will not support this in Project Detail views. The only way to filter your
views would be based on the Current Date (as of publishing), the Publish
Date (as of publishing), or the Status Date (as of publishing). Personally,
I prefer the Status Date as that is the last time the project was truly up
to date.

Here's a couple of flag formulas you can use to start with in developing
a filter. You may have to refine for your specific needs:

1) IIf([% Complete]<100,IIf([Start]<ProjDateAdd([Current Date],2400),Yes,No),No)
- all open tasks that have started or will start in the next week, based
on the current date as of the publish event.

2) IIf([Status Date]=ProjDateValue("NA"),No,IIf([% Complete]=100,No,IIf([Baseline
Finish]<[Status Date],Yes,IIf([Baseline Start]<[Status Date],IIf([Finish
Variance]>0,Yes,No),No)))) - all past due tasks and in progress slipping
tasks, based on the Status Date as of the publish event.

If you truly want to filter on today's date, you would need to do that in
a SQL query with SQL Reporting Services. In my opinion, that would not be
the way to go, as that would be displaying data based on non-updated schedules
- depending on how long has elapsed between the Publish date and Today's
date.

- Andrew Lavinsky
Blog: http://blogs.catapultsystems.com/epm

 

[Robert Juarez]

Thanks for the info...I will give this a shot and see how it works out.
Looking at those formulas is like looking at another language to me. Does
anyone have any good resource (online and free hopefully) for learning how to
put together formulas like this.
Thanks again,
Robert

The challenge will be to dynamically filter based on the current date. PWA
will not support this in Project Detail views. The only way to filter your
views would be based on the Current Date (as of publishing), the Publish
Date (as of publishing), or the Status Date (as of publishing). Personally,
I prefer the Status Date as that is the last time the project was truly up
to date.

Here's a couple of flag formulas you can use to start with in developing
a filter. You may have to refine for your specific needs:

1) IIf([% Complete]<100,IIf([Start]<ProjDateAdd([Current Date],2400),Yes,No),No)
- all open tasks that have started or will start in the next week, based
on the current date as of the publish event.

2) IIf([Status Date]=ProjDateValue("NA"),No,IIf([% Complete]=100,No,IIf([Baseline
Finish]<[Status Date],Yes,IIf([Baseline Start]<[Status Date],IIf([Finish
Variance]>0,Yes,No),No)))) - all past due tasks and in progress slipping
tasks, based on the Status Date as of the publish event.

If you truly want to filter on today's date, you would need to do that in
a SQL query with SQL Reporting Services. In my opinion, that would not be
the way to go, as that would be displaying data based on non-updated schedules
- depending on how long has elapsed between the Publish date and Today's
date.

- Andrew Lavinsky
Blog: http://blogs.catapultsystems.com/epm

I want to create 2 different views for a project in PWA for PS2K7 that
display:
1. All tasks due within the next week. I know I need to do a filter
and I
recall somewhere seeing something like Finish=[Today]+5 or something
like
that, but I can't remember exactly. I'm hoping someone can help.
2. All tasks past due. I'm guessing this would be something similar
where
Finish<Today and % Complete "not equal" to 100, but I'm not sure.
Thanks!

.

 

[Robert Juarez]

Okay, so I thought I was just going to be entering the formulas you supplied
under "Filter" when you're editing a view. Obviously this is not the case
=). As a disclaimer, I am VERY new to PS2K7 and PAW, but have been tasked by
my company to put together a demo for a customer so I need to figure it out.
Can you give me the cliff notes on how to 1) where and how to create these
flag formulas and 2) how to use them in a view? Sorry for all of the hand
holding but this is turning out to be quite a complicated piece of software
=/.

The challenge will be to dynamically filter based on the current date. PWA
will not support this in Project Detail views. The only way to filter your
views would be based on the Current Date (as of publishing), the Publish
Date (as of publishing), or the Status Date (as of publishing). Personally,
I prefer the Status Date as that is the last time the project was truly up
to date.

Here's a couple of flag formulas you can use to start with in developing
a filter. You may have to refine for your specific needs:

1) IIf([% Complete]<100,IIf([Start]<ProjDateAdd([Current Date],2400),Yes,No),No)
- all open tasks that have started or will start in the next week, based
on the current date as of the publish event.

2) IIf([Status Date]=ProjDateValue("NA"),No,IIf([% Complete]=100,No,IIf([Baseline
Finish]<[Status Date],Yes,IIf([Baseline Start]<[Status Date],IIf([Finish
Variance]>0,Yes,No),No)))) - all past due tasks and in progress slipping
tasks, based on the Status Date as of the publish event.

If you truly want to filter on today's date, you would need to do that in
a SQL query with SQL Reporting Services. In my opinion, that would not be
the way to go, as that would be displaying data based on non-updated schedules
- depending on how long has elapsed between the Publish date and Today's
date.

- Andrew Lavinsky
Blog: http://blogs.catapultsystems.com/epm

I want to create 2 different views for a project in PWA for PS2K7 that
display:
1. All tasks due within the next week. I know I need to do a filter
and I
recall somewhere seeing something like Finish=[Today]+5 or something
like
that, but I can't remember exactly. I'm hoping someone can help.
2. All tasks past due. I'm guessing this would be something similar
where
Finish<Today and % Complete "not equal" to 100, but I'm not sure.
Thanks!

.

 

[Andrew Lavinsky]

1) Add them to Project Server as enterprise custom fields.
2) Create and save/publish a schedule (or save/publish existing schedule)
3) In the views, add a filter on the field you created in the Enterprise
Custom Fields area

And yeah, Project Server can be quite a bear to implement. It does require
a fair bit of specialized technical and domain knowledge.

- Andrew Lavinsky
Blog: http://blogs.catapultsystems.com/epm

Okay, so I thought I was just going to be entering the formulas you
supplied under "Filter" when you're editing a view. Obviously this is
not the case =). As a disclaimer, I am VERY new to PS2K7 and PAW, but
have been tasked by my company to put together a demo for a customer
so I need to figure it out. Can you give me the cliff notes on how to
1) where and how to create these flag formulas and 2) how to use them
in a view? Sorry for all of the hand holding but this is turning out
to be quite a complicated piece of software =/.

The challenge will be to dynamically filter based on the current
date. PWA will not support this in Project Detail views. The only
way to filter your views would be based on the Current Date (as of
publishing), the Publish Date (as of publishing), or the Status Date
(as of publishing). Personally, I prefer the Status Date as that is
the last time the project was truly up to date.

Here's a couple of flag formulas you can use to start with in
developing a filter. You may have to refine for your specific needs:

1) IIf([% Complete]<100,IIf([Start]<ProjDateAdd([Current
Date],2400),Yes,No),No) - all open tasks that have started or will
start in the next week, based on the current date as of the publish
event.

2) IIf([Status Date]=ProjDateValue("NA"),No,IIf([%
Complete]=100,No,IIf([Baseline Finish]<[Status
Date],Yes,IIf([Baseline Start]<[Status Date],IIf([Finish
Variance]>0,Yes,No),No)))) - all past due tasks and in progress
slipping tasks, based on the Status Date as of the publish event.

If you truly want to filter on today's date, you would need to do
that in a SQL query with SQL Reporting Services. In my opinion, that
would not be the way to go, as that would be displaying data based on
non-updated schedules - depending on how long has elapsed between the
Publish date and Today's date.

- Andrew Lavinsky
Blog: http://blogs.catapultsystems.com/epm

I want to create 2 different views for a project in PWA for PS2K7
that
display:
1. All tasks due within the next week. I know I need to do a
filter
and I
recall somewhere seeing something like Finish=[Today]+5 or something
like
that, but I can't remember exactly. I'm hoping someone can help.
2. All tasks past due. I'm guessing this would be something similar
where
Finish<Today and % Complete "not equal" to 100, but I'm not sure.
Thanks!

.

 

[Gary Chefetz]

Robert:

Seriously, tell your boss that if they want to win the business, they'll
bring in an EPM partner to partner with, or someone from Microsoft to do the
demo. The latter solution is a desperate choice and doesn't get the work
done for the client unless you turn it over to MCS. There is no way for
someone to approach this system blind and get up to speed in just a few
months, let alone a in a matter of days.

SAP makes some keen ERP software, could you throw a demo of that together by
the end of next week?<g>

Okay, so I thought I was just going to be entering the formulas you
supplied
under "Filter" when you're editing a view. Obviously this is not the case
=). As a disclaimer, I am VERY new to PS2K7 and PAW, but have been tasked
by
my company to put together a demo for a customer so I need to figure it
out.
Can you give me the cliff notes on how to 1) where and how to create these
flag formulas and 2) how to use them in a view? Sorry for all of the hand
holding but this is turning out to be quite a complicated piece of
software
=/.

The challenge will be to dynamically filter based on the current date.
PWA
will not support this in Project Detail views. The only way to filter
your
views would be based on the Current Date (as of publishing), the Publish
Date (as of publishing), or the Status Date (as of publishing).
Personally,
I prefer the Status Date as that is the last time the project was truly
up
to date.

Here's a couple of flag formulas you can use to start with in developing
a filter. You may have to refine for your specific needs:

1) IIf([% Complete]<100,IIf([Start]<ProjDateAdd([Current
Date],2400),Yes,No),No)
- all open tasks that have started or will start in the next week, based
on the current date as of the publish event.

2) IIf([Status Date]=ProjDateValue("NA"),No,IIf([%
Complete]=100,No,IIf([Baseline
Finish]<[Status Date],Yes,IIf([Baseline Start]<[Status Date],IIf([Finish
Variance]>0,Yes,No),No)))) - all past due tasks and in progress slipping
tasks, based on the Status Date as of the publish event.

If you truly want to filter on today's date, you would need to do that in
a SQL query with SQL Reporting Services. In my opinion, that would not
be
the way to go, as that would be displaying data based on non-updated
schedules
- depending on how long has elapsed between the Publish date and Today's
date.

- Andrew Lavinsky
Blog: http://blogs.catapultsystems.com/epm

I want to create 2 different views for a project in PWA for PS2K7 that
display:
1. All tasks due within the next week. I know I need to do a filter
and I
recall somewhere seeing something like Finish=[Today]+5 or something
like
that, but I can't remember exactly. I'm hoping someone can help.
2. All tasks past due. I'm guessing this would be something similar
where
Finish<Today and % Complete "not equal" to 100, but I'm not sure.
Thanks!

.

 

[Robert Juarez]

Okay, further questions on this topic =).
1. I'm a little confused about how "current date", "status date", and
"publish date" are calculated. Can you please explain? I would assume
"current date" always means today, but I could be off. Also, how is the time
used when calculating these? In formula 1 below you used "2400".
2. I tried to do a variation of the past due formula that you provided
below using graphical indicators and this formula "IIf([Finish]<[Current
Date] And [% Complete]<100,"Red, Overdue","Green, Not Overdue")". However, I
cannot get it work. Even with just the Data view, nothing is populated in
this field (I would expect each task to return one of the two text values),
and when I try to use a graphical indicator view it keeps telling me that
they are not valid. Is something wrong with this formula?

1) Add them to Project Server as enterprise custom fields.
2) Create and save/publish a schedule (or save/publish existing schedule)
3) In the views, add a filter on the field you created in the Enterprise
Custom Fields area

And yeah, Project Server can be quite a bear to implement. It does require
a fair bit of specialized technical and domain knowledge.

- Andrew Lavinsky
Blog: http://blogs.catapultsystems.com/epm

Okay, so I thought I was just going to be entering the formulas you
supplied under "Filter" when you're editing a view. Obviously this is
not the case =). As a disclaimer, I am VERY new to PS2K7 and PAW, but
have been tasked by my company to put together a demo for a customer
so I need to figure it out. Can you give me the cliff notes on how to
1) where and how to create these flag formulas and 2) how to use them
in a view? Sorry for all of the hand holding but this is turning out
to be quite a complicated piece of software =/.

The challenge will be to dynamically filter based on the current
date. PWA will not support this in Project Detail views. The only
way to filter your views would be based on the Current Date (as of
publishing), the Publish Date (as of publishing), or the Status Date
(as of publishing). Personally, I prefer the Status Date as that is
the last time the project was truly up to date.

Here's a couple of flag formulas you can use to start with in
developing a filter. You may have to refine for your specific needs:

1) IIf([% Complete]<100,IIf([Start]<ProjDateAdd([Current
Date],2400),Yes,No),No) - all open tasks that have started or will
start in the next week, based on the current date as of the publish
event.

2) IIf([Status Date]=ProjDateValue("NA"),No,IIf([%
Complete]=100,No,IIf([Baseline Finish]<[Status
Date],Yes,IIf([Baseline Start]<[Status Date],IIf([Finish
Variance]>0,Yes,No),No)))) - all past due tasks and in progress
slipping tasks, based on the Status Date as of the publish event.

If you truly want to filter on today's date, you would need to do
that in a SQL query with SQL Reporting Services. In my opinion, that
would not be the way to go, as that would be displaying data based on
non-updated schedules - depending on how long has elapsed between the
Publish date and Today's date.

- Andrew Lavinsky
Blog: http://blogs.catapultsystems.com/epm
I want to create 2 different views for a project in PWA for PS2K7
that
display:
1. All tasks due within the next week. I know I need to do a
filter
and I
recall somewhere seeing something like Finish=[Today]+5 or something
like
that, but I can't remember exactly. I'm hoping someone can help.
2. All tasks past due. I'm guessing this would be something similar
where
Finish<Today and % Complete "not equal" to 100, but I'm not sure.
Thanks!
.

.

 

[Andrew Lavinsky]

Look into the entire publishing function. That moves the project from the
draft database to the published database. Once in published, the project
won't recalculate until the next time you open in draft and republish.

Thus, current date is the current date on which you publish the schedule.
It doesn't get updated post-publish until you publish again. Hence the
current date and the publish date are more or less the same in the published
version of the schedule. In the draft version of the schedule, those two
may show a difference, but you can't use the draft version of the schedule
in a Project Center view.

Status date is manually entered by the scheduler.

Duration (not time) is calculated in minutes typically. The average week
is 8 hours X 60 minutes X 5 days = 2400.

I'll take a look at the formula in a little bit....

- Andrew Lavinsky
Blog: http://blogs.catapultsystems.com/epm

Okay, further questions on this topic =).
1. I'm a little confused about how "current date", "status date", and
"publish date" are calculated. Can you please explain? I would
assume
"current date" always means today, but I could be off. Also, how is
the time
used when calculating these? In formula 1 below you used "2400".
2. I tried to do a variation of the past due formula that you
provided
below using graphical indicators and this formula
"IIf([Finish]<[Current
Date] And [% Complete]<100,"Red, Overdue","Green, Not Overdue")".
However, I
cannot get it work. Even with just the Data view, nothing is
populated in
this field (I would expect each task to return one of the two text
values),
and when I try to use a graphical indicator view it keeps telling me
that
they are not valid. Is something wrong with this formula?

1) Add them to Project Server as enterprise custom fields.
2) Create and save/publish a schedule (or save/publish existing
schedule)
3) In the views, add a filter on the field you created in the
Enterprise
Custom Fields area
And yeah, Project Server can be quite a bear to implement. It does
require a fair bit of specialized technical and domain knowledge.

- Andrew Lavinsky
Blog: http://blogs.catapultsystems.com/epm

Okay, so I thought I was just going to be entering the formulas you
supplied under "Filter" when you're editing a view. Obviously this
is not the case =). As a disclaimer, I am VERY new to PS2K7 and
PAW, but have been tasked by my company to put together a demo for a
customer so I need to figure it out. Can you give me the cliff
notes on how to 1) where and how to create these flag formulas and
2) how to use them in a view? Sorry for all of the hand holding but
this is turning out to be quite a complicated piece of software =/.

:

The challenge will be to dynamically filter based on the current
date. PWA will not support this in Project Detail views. The only
way to filter your views would be based on the Current Date (as of
publishing), the Publish Date (as of publishing), or the Status
Date (as of publishing). Personally, I prefer the Status Date as
that is the last time the project was truly up to date.

Here's a couple of flag formulas you can use to start with in
developing a filter. You may have to refine for your specific
needs:

1) IIf([% Complete]<100,IIf([Start]<ProjDateAdd([Current
Date],2400),Yes,No),No) - all open tasks that have started or will
start in the next week, based on the current date as of the publish
event.

2) IIf([Status Date]=ProjDateValue("NA"),No,IIf([%
Complete]=100,No,IIf([Baseline Finish]<[Status
Date],Yes,IIf([Baseline Start]<[Status Date],IIf([Finish
Variance]>0,Yes,No),No)))) - all past due tasks and in progress
slipping tasks, based on the Status Date as of the publish event.

If you truly want to filter on today's date, you would need to do
that in a SQL query with SQL Reporting Services. In my opinion,
that would not be the way to go, as that would be displaying data
based on non-updated schedules - depending on how long has elapsed
between the Publish date and Today's date.

- Andrew Lavinsky
Blog: http://blogs.catapultsystems.com/epm
I want to create 2 different views for a project in PWA for PS2K7
that
display:
1. All tasks due within the next week. I know I need to do a
filter
and I
recall somewhere seeing something like Finish=[Today]+5 or
something
like
that, but I can't remember exactly. I'm hoping someone can help.
2. All tasks past due. I'm guessing this would be something
similar
where
Finish<Today and % Complete "not equal" to 100, but I'm not sure.
Thanks!
.

.

 

[Robert Juarez]

Okay, so a few more questions on this topic =).
1. I don't really understand what values get populated for "current date",
"status date", and "publish date". Can you explain how PWA determines those
entries.
2. I tried to tweak the overdue items formula by using this formula:
"IIf([Finish]<[Current Date] And [% Complete]<100,"red","green")". Now I
would expect it to populate that field with either "red" or "green" depending
on if it meets the criteria. Furthermore I would like to use graphical
indicators to show red or green stoplights. However, I cannot get this
formula to work - in data view it is blank for all tasks and when I try to
setup the graphical indicator it keeps telling me they are not valid. What
am I doing wrong?
Thanks,
Robert

1) Add them to Project Server as enterprise custom fields.
2) Create and save/publish a schedule (or save/publish existing schedule)
3) In the views, add a filter on the field you created in the Enterprise
Custom Fields area

And yeah, Project Server can be quite a bear to implement. It does require
a fair bit of specialized technical and domain knowledge.

- Andrew Lavinsky
Blog: http://blogs.catapultsystems.com/epm

Okay, so I thought I was just going to be entering the formulas you
supplied under "Filter" when you're editing a view. Obviously this is
not the case =). As a disclaimer, I am VERY new to PS2K7 and PAW, but
have been tasked by my company to put together a demo for a customer
so I need to figure it out. Can you give me the cliff notes on how to
1) where and how to create these flag formulas and 2) how to use them
in a view? Sorry for all of the hand holding but this is turning out
to be quite a complicated piece of software =/.

The challenge will be to dynamically filter based on the current
date. PWA will not support this in Project Detail views. The only
way to filter your views would be based on the Current Date (as of
publishing), the Publish Date (as of publishing), or the Status Date
(as of publishing). Personally, I prefer the Status Date as that is
the last time the project was truly up to date.

Here's a couple of flag formulas you can use to start with in
developing a filter. You may have to refine for your specific needs:

1) IIf([% Complete]<100,IIf([Start]<ProjDateAdd([Current
Date],2400),Yes,No),No) - all open tasks that have started or will
start in the next week, based on the current date as of the publish
event.

2) IIf([Status Date]=ProjDateValue("NA"),No,IIf([%
Complete]=100,No,IIf([Baseline Finish]<[Status
Date],Yes,IIf([Baseline Start]<[Status Date],IIf([Finish
Variance]>0,Yes,No),No)))) - all past due tasks and in progress
slipping tasks, based on the Status Date as of the publish event.

If you truly want to filter on today's date, you would need to do
that in a SQL query with SQL Reporting Services. In my opinion, that
would not be the way to go, as that would be displaying data based on
non-updated schedules - depending on how long has elapsed between the
Publish date and Today's date.

- Andrew Lavinsky
Blog: http://blogs.catapultsystems.com/epm
I want to create 2 different views for a project in PWA for PS2K7
that
display:
1. All tasks due within the next week. I know I need to do a
filter
and I
recall somewhere seeing something like Finish=[Today]+5 or something
like
that, but I can't remember exactly. I'm hoping someone can help.
2. All tasks past due. I'm guessing this would be something similar
where
Finish<Today and % Complete "not equal" to 100, but I'm not sure.
Thanks!
.

.

 

[Andrew Lavinsky]

Looks like Jon Sofer already addressed the specific formula....

- Andrew Lavinsky
Blog: http://blogs.catapultsystems.com/epm

Look into the entire publishing function. That moves the project from
the draft database to the published database. Once in published, the
project won't recalculate until the next time you open in draft and
republish.

Thus, current date is the current date on which you publish the
schedule.
It doesn't get updated post-publish until you publish again. Hence
the
current date and the publish date are more or less the same in the
published
version of the schedule. In the draft version of the schedule, those
two may show a difference, but you can't use the draft version of the
schedule in a Project Center view.

Status date is manually entered by the scheduler.

Duration (not time) is calculated in minutes typically. The average
week is 8 hours X 60 minutes X 5 days = 2400.

I'll take a look at the formula in a little bit....

- Andrew Lavinsky
Blog: http://blogs.catapultsystems.com/epm

Okay, further questions on this topic =).
1. I'm a little confused about how "current date", "status date",
and
"publish date" are calculated. Can you please explain? I would
assume
"current date" always means today, but I could be off. Also, how is
the time
used when calculating these? In formula 1 below you used "2400".
2. I tried to do a variation of the past due formula that you
provided
below using graphical indicators and this formula
"IIf([Finish]<[Current
Date] And [% Complete]<100,"Red, Overdue","Green, Not Overdue")".
However, I
cannot get it work. Even with just the Data view, nothing is
populated in
this field (I would expect each task to return one of the two text
values),
and when I try to use a graphical indicator view it keeps telling me
that
they are not valid. Is something wrong with this formula?

1) Add them to Project Server as enterprise custom fields.
2) Create and save/publish a schedule (or save/publish existing
schedule)
3) In the views, add a filter on the field you created in the
Enterprise
Custom Fields area
And yeah, Project Server can be quite a bear to implement. It does
require a fair bit of specialized technical and domain knowledge.
- Andrew Lavinsky
Blog: http://blogs.catapultsystems.com/epm
Okay, so I thought I was just going to be entering the formulas you
supplied under "Filter" when you're editing a view. Obviously this
is not the case =). As a disclaimer, I am VERY new to PS2K7 and
PAW, but have been tasked by my company to put together a demo for
a customer so I need to figure it out. Can you give me the cliff
notes on how to 1) where and how to create these flag formulas and
2) how to use them in a view? Sorry for all of the hand holding
but this is turning out to be quite a complicated piece of software
=/.

:

The challenge will be to dynamically filter based on the current
date. PWA will not support this in Project Detail views. The
only way to filter your views would be based on the Current Date
(as of publishing), the Publish Date (as of publishing), or the
Status Date (as of publishing). Personally, I prefer the Status
Date as that is the last time the project was truly up to date.

Here's a couple of flag formulas you can use to start with in
developing a filter. You may have to refine for your specific
needs:

1) IIf([% Complete]<100,IIf([Start]<ProjDateAdd([Current
Date],2400),Yes,No),No) - all open tasks that have started or will
start in the next week, based on the current date as of the
publish event.

2) IIf([Status Date]=ProjDateValue("NA"),No,IIf([%
Complete]=100,No,IIf([Baseline Finish]<[Status
Date],Yes,IIf([Baseline Start]<[Status Date],IIf([Finish
Variance]>0,Yes,No),No)))) - all past due tasks and in progress
slipping tasks, based on the Status Date as of the publish event.

If you truly want to filter on today's date, you would need to do
that in a SQL query with SQL Reporting Services. In my opinion,
that would not be the way to go, as that would be displaying data
based on non-updated schedules - depending on how long has elapsed
between the Publish date and Today's date.

- Andrew Lavinsky
Blog: http://blogs.catapultsystems.com/epm
I want to create 2 different views for a project in PWA for PS2K7
that
display:
1. All tasks due within the next week. I know I need to do a
filter
and I
recall somewhere seeing something like Finish=[Today]+5 or
something
like
that, but I can't remember exactly. I'm hoping someone can help.
2. All tasks past due. I'm guessing this would be something
similar
where
Finish<Today and % Complete "not equal" to 100, but I'm not sure.
Thanks!
.

.