Exporting Time Phase to Excel

Yahoo Archive
1
Troy,

There is a time phase report done in report builder on the yahoogroups that
is set up to be run by class. It is set up for ver 3.00 but it may give you
a start. Are you dealing with certain part classes or are you trying to look
at all the parts? We have set these up with multiple part classes by certain
users so they can look at the parts they are responsible for. If you
suppress the record lines it ends up being a single line for each part. HTH.

Jim

> -----Original Message-----
> From: Troy Funte [mailto:tfunte@...]
> Sent: Friday, September 07, 2001 9:21 AM
> To: vantage@yahoogroups.com
> Subject: Re: [Vantage] Exporting Time Phase to Excel
>
>
> OK. Let me explain further. We depend on the Time Phase report
> as well as MRP to check for shortages in jobs that are upcoming
> and/or on the floor. This report runs between 300 to 600 pages,
> and sometimes we're only looking to scan it for certain
> scenarios. It would be really handy to have this dumped into
> Excel so that we can work with it / cut and paste / etc. rather
> than tying up the printer and wasting all that paper. Anyone
> have any ideas for a solution? I believe this is a progress
> report. Anyone have a Time Phase report in Crystal or RB or
> Provision that you could share that could be modifed to do what we need?
>
>
> Troy Funte
> Liberty Electronics
> ----- Original Message -----
> From: Troy Funte
> To: Vantage
> Sent: Thursday, September 06, 2001 8:55 AM
> Subject: [Vantage] Exporting Time Phase to Excel
>
>
> Does anyone know of a way to export the Time Phase in Vantage
> (5.0) to Excel?
>
> Troy Funte
>
>
>
> [Non-text portions of this message have been removed]
>
>
> Yahoo! Groups Sponsor
> ADVERTISEMENT
>
>
>
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note:
> You must have already linked your email address to a yahoo id to
> enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report
> Builder and Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services
> goto: http://groups.yahoo.com/group/vantage/links
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
> must have already linked your email address to a yahoo id to
> enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report
> Builder and Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/links
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
2
Does anyone know of a way to export the Time Phase in Vantage (5.0) to Excel?

Troy Funte



[Non-text portions of this message have been removed]
3
OK. Let me explain further. We depend on the Time Phase report as well as MRP to check for shortages in jobs that are upcoming and/or on the floor. This report runs between 300 to 600 pages, and sometimes we're only looking to scan it for certain scenarios. It would be really handy to have this dumped into Excel so that we can work with it / cut and paste / etc. rather than tying up the printer and wasting all that paper. Anyone have any ideas for a solution? I believe this is a progress report. Anyone have a Time Phase report in Crystal or RB or Provision that you could share that could be modifed to do what we need?


Troy Funte
Liberty Electronics
----- Original Message -----
From: Troy Funte
To: Vantage
Sent: Thursday, September 06, 2001 8:55 AM
Subject: [Vantage] Exporting Time Phase to Excel


Does anyone know of a way to export the Time Phase in Vantage (5.0) to Excel?

Troy Funte



[Non-text portions of this message have been removed]


Yahoo! Groups Sponsor
ADVERTISEMENT




Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]
4
Troy,

Have you tried printing it to a file instead? You might have to monkey
around with the formatting a bit, but at least you get a nice file with
ASCII characters...


HTH,

Paul

-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: Friday, September 07, 2001 10:21
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Exporting Time Phase to Excel


OK. Let me explain further. We depend on the Time Phase report as well as
MRP to check for shortages in jobs that are upcoming and/or on the floor.
This report runs between 300 to 600 pages, and sometimes we're only looking
to scan it for certain scenarios. It would be really handy to have this
dumped into Excel so that we can work with it / cut and paste / etc. rather
than tying up the printer and wasting all that paper. Anyone have any ideas
for a solution? I believe this is a progress report. Anyone have a Time
Phase report in Crystal or RB or Provision that you could share that could
be modifed to do what we need?


Troy Funte
Liberty Electronics
----- Original Message -----
From: Troy Funte
To: Vantage
Sent: Thursday, September 06, 2001 8:55 AM
Subject: [Vantage] Exporting Time Phase to Excel


Does anyone know of a way to export the Time Phase in Vantage (5.0) to
Excel?

Troy Funte



[Non-text portions of this message have been removed]


Yahoo! Groups Sponsor
ADVERTISEMENT




Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages>
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links>

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]



Yahoo! Groups Sponsor

<http://rd.yahoo.com/M=207641.1594108.3142424.1269402/D=egroupweb/S=17050071
83:HM/A=765263/R=0/*http://www.verisign.com/cgi-bin/go.cgi?a=b15334027000300
0>

<http://us.adserver.yahoo.com/l?M=207641.1594108.3142424.1269402/D=egroupmai
l/S=1705007183:HM/A=765263/rand=138106138>

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages>
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links>

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]
5
We ar absolutely anal about keeping everything in the system and try not to use mutiple programs whenever possible. BUT,,,We use a program called Monarch Pro by Math Strategies, that allows you to take any report printed, (we use generic text written to a file), and create models to extract only the information you want, ie, instead of multiple reports, use the same report with different models. It will then export, if you like, to excel, access, lotus or many other formats and will also link tables to these models. For anyone dealing with reports there is no better program in my opinion.
Russ Silvey
Wisdom Industries
6
Do you have a web address you can point me to so I can look into this product? Sounds like something we might like to use.

Troy

----- Original Message -----
From: silvey3279@...
To: vantage@yahoogroups.com
Sent: Friday, September 07, 2001 1:19 PM
Subject: [Vantage] Exporting Time Phase to Excel


We ar absolutely anal about keeping everything in the system and try not to use mutiple programs whenever possible. BUT,,,We use a program called Monarch Pro by Math Strategies, that allows you to take any report printed, (we use generic text written to a file), and create models to extract only the information you want, ie, instead of multiple reports, use the same report with different models. It will then export, if you like, to excel, access, lotus or many other formats and will also link tables to these models. For anyone dealing with reports there is no better program in my opinion.
Russ Silvey
Wisdom Industries

Yahoo! Groups Sponsor



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]
7
I've used Monarch before also. My version is about 5 years old so might not
be as full featured as the most current release of Monarch. I've had limited
success doing the same thing Monarch did using the Crystal Reports Import
tool. I took the canned Vantage Wip report into Crystal using the import
tool. Good luck

Dan Shallbetter
States Electric Mfg.


-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: Friday, September 07, 2001 2:48 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Exporting Time Phase to Excel



Do you have a web address you can point me to so I can look into this
product? Sounds like something we might like to use.

Troy

----- Original Message -----
From: silvey3279@...
To: vantage@yahoogroups.com
Sent: Friday, September 07, 2001 1:19 PM
Subject: [Vantage] Exporting Time Phase to Excel


We ar absolutely anal about keeping everything in the system and try not
to use mutiple programs whenever possible. BUT,,,We use a program called
Monarch Pro by Math Strategies, that allows you to take any report printed,
(we use generic text written to a file), and create models to extract only
the information you want, ie, instead of multiple reports, use the same
report with different models. It will then export, if you like, to excel,
access, lotus or many other formats and will also link tables to these
models. For anyone dealing with reports there is no better program in my
opinion.
Russ Silvey
Wisdom Industries

Yahoo! Groups Sponsor



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages>
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links>

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]



Yahoo! Groups Sponsor

<http://rd.yahoo.com/M=207641.1594108.3142424.1269402/D=egroupweb/S=17050071
83:HM/A=765263/R=0/*http://www.verisign.com/cgi-bin/go.cgi?a=b15334027000300
0>

<http://us.adserver.yahoo.com/l?M=207641.1594108.3142424.1269402/D=egroupmai
l/S=1705007183:HM/A=765263/rand=509588056>

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages>
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links>

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]
8
Until you get Monarch you could also try the following. When you
print preview a report vantage creates a file on your PC in the
Vntgwork folder called RPT####. While the preview screen is open you
can call this file up with excel. I've been doing this with our
Inventory WIP reconciliation report as it runs about 150 pages. The
file includes page headers, etc. so it takes a bit of formatting to
get it to be usable.

--- In vantage@y..., "Troy Funte" <tfunte@e...> wrote:
> OK. Let me explain further. We depend on the Time Phase report
as well as MRP to check for shortages in jobs that are upcoming
and/or on the floor. This report runs between 300 to 600 pages, and
sometimes we're only looking to scan it for certain scenarios. It
would be really handy to have this dumped into Excel so that we can
work with it / cut and paste / etc. rather than tying up the printer
and wasting all that paper. Anyone have any ideas for a solution? I
believe this is a progress report. Anyone have a Time Phase report
in Crystal or RB or Provision that you could share that could be
modifed to do what we need?
>
>
> Troy Funte
> Liberty Electronics
> ----- Original Message -----
> From: Troy Funte
> To: Vantage
> Sent: Thursday, September 06, 2001 8:55 AM
> Subject: [Vantage] Exporting Time Phase to Excel
>
>
> Does anyone know of a way to export the Time Phase in Vantage
(5.0) to Excel?
>
> Troy Funte
9
You can not create a time phase report in report builder. Another option
might be printing vantages version to a text or adobe file and searching.
You could even try a product like Monarch to read and create a summary from
a text file. Just some ideas.

Patrick

-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: Friday, September 07, 2001 9:21 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Exporting Time Phase to Excel


OK. Let me explain further. We depend on the Time Phase report as well as
MRP to check for shortages in jobs that are upcoming and/or on the floor.
This report runs between 300 to 600 pages, and sometimes we're only looking
to scan it for certain scenarios. It would be really handy to have this
dumped into Excel so that we can work with it / cut and paste / etc. rather
than tying up the printer and wasting all that paper. Anyone have any ideas
for a solution? I believe this is a progress report. Anyone have a Time
Phase report in Crystal or RB or Provision that you could share that could
be modifed to do what we need?


Troy Funte
Liberty Electronics
----- Original Message -----
From: Troy Funte
To: Vantage
Sent: Thursday, September 06, 2001 8:55 AM
Subject: [Vantage] Exporting Time Phase to Excel


Does anyone know of a way to export the Time Phase in Vantage (5.0) to
Excel?

Troy Funte



[Non-text portions of this message have been removed]


Yahoo! Groups Sponsor
ADVERTISEMENT




Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/