software

I have a lot of year end cycle time statistics (by Region, by Market, by
Vendor, etc.) that I need to produce in a short turn around time. I would
like to set up my spreadsheets in advance with using the Data Analysis Tool.
Once set up, I would like to introduce the final data dump, massage the data
a bit and then cause my statistics to refresh. Is this at all possible? If
so, how?The results from the Data Analysis tools are static - carved in stone once
generated!.
All of them can be generated using formulas which are dynamic - refresh as
the data is changed
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

quot;stips2quot; gt; wrote in message
...
gt;I have a lot of year end cycle time statistics (by Region, by Market, by
gt; Vendor, etc.) that I need to produce in a short turn around time. I would
gt; like to set up my spreadsheets in advance with using the Data Analysis
gt; Tool.
gt; Once set up, I would like to introduce the final data dump, massage the
gt; data
gt; a bit and then cause my statistics to refresh. Is this at all possible? If
gt; so, how?
gt;
Ah ha! That will work. Thank you.
Sue

quot;Bernard Liengmequot; wrote:

gt; The results from the Data Analysis tools are static - carved in stone once
gt; generated!.
gt; All of them can be generated using formulas which are dynamic - refresh as
gt; the data is changed
gt; best wishes
gt; --
gt; Bernard V Liengme
gt; www.stfx.ca/people/bliengme
gt; remove caps from email
gt;
gt; quot;stips2quot; gt; wrote in message
gt; ...
gt; gt;I have a lot of year end cycle time statistics (by Region, by Market, by
gt; gt; Vendor, etc.) that I need to produce in a short turn around time. I would
gt; gt; like to set up my spreadsheets in advance with using the Data Analysis
gt; gt; Tool.
gt; gt; Once set up, I would like to introduce the final data dump, massage the
gt; gt; data
gt; gt; a bit and then cause my statistics to refresh. Is this at all possible? If
gt; gt; so, how?
gt; gt;
gt;
gt;
gt;