software

I have a table with days, planned and actual production, and % of actual vs.
planned.
DayPlanned Cs Actual Cs%
26-Feb-061667 2025.25 121.49%
30-Apr-061667 1838.25 110.27%
19-Feb-061667 1950 116.98%
16-Apr-061660 1657 99.82%
26-Mar-061696 1693.5 99.85%
29-Jan-061696 1691 99.71%

I need to find a correlation between a number of cases planned (or actually
produced) and the % (to be on target). Whether having some specific range of
planned cases it's difficult to be on target and having another range or
number of cases it's easier to be on target.
What analysis tool do I need to use for this case and how I would need to
presenty the data?
Thanks.Alex,

I think you could use a pivot table for this.

Data:PivotTable Report

Put your planned (or actual, or both) fields in the row area, then put your
percentage field in the data area.

Click finish

Right click on your row header (planned or actual) select Group and
Outline:Group.

Here you can define how large the range should be when evaluating case load.

HTH

quot;Alexquot; wrote:

gt; I have a table with days, planned and actual production, and % of actual vs.
gt; planned.
gt; DayPlanned Cs Actual Cs%
gt; 26-Feb-061667 2025.25 121.49%
gt; 30-Apr-061667 1838.25 110.27%
gt; 19-Feb-061667 1950 116.98%
gt; 16-Apr-061660 1657 99.82%
gt; 26-Mar-061696 1693.5 99.85%
gt; 29-Jan-061696 1691 99.71%
gt;
gt; I need to find a correlation between a number of cases planned (or actually
gt; produced) and the % (to be on target). Whether having some specific range of
gt; planned cases it's difficult to be on target and having another range or
gt; number of cases it's easier to be on target.
gt; What analysis tool do I need to use for this case and how I would need to
gt; presenty the data?
gt; Thanks.
gt;

Thank you very much, Dominic. I did it.
The table looks as below:
Planned Total
942-1941 18.36321823
1942-2941 4.335326773
2942-3941 23.12984109
....

However, the total represents probably the sum of %. How could I show some
average % on target for the range and not the sum %.

Thanks

quot;Dominicquot; wrote:

gt; Alex,
gt;
gt; I think you could use a pivot table for this.
gt;
gt; Data:PivotTable Report
gt;
gt; Put your planned (or actual, or both) fields in the row area, then put your
gt; percentage field in the data area.
gt;
gt; Click finish
gt;
gt; Right click on your row header (planned or actual) select Group and
gt; Outline:Group.
gt;
gt; Here you can define how large the range should be when evaluating case load.
gt;
gt; HTH
gt;
gt; quot;Alexquot; wrote:
gt;
gt; gt; I have a table with days, planned and actual production, and % of actual vs.
gt; gt; planned.
gt; gt; DayPlanned Cs Actual Cs%
gt; gt; 26-Feb-061667 2025.25 121.49%
gt; gt; 30-Apr-061667 1838.25 110.27%
gt; gt; 19-Feb-061667 1950 116.98%
gt; gt; 16-Apr-061660 1657 99.82%
gt; gt; 26-Mar-061696 1693.5 99.85%
gt; gt; 29-Jan-061696 1691 99.71%
gt; gt;
gt; gt; I need to find a correlation between a number of cases planned (or actually
gt; gt; produced) and the % (to be on target). Whether having some specific range of
gt; gt; planned cases it's difficult to be on target and having another range or
gt; gt; number of cases it's easier to be on target.
gt; gt; What analysis tool do I need to use for this case and how I would need to
gt; gt; presenty the data?
gt; gt; Thanks.
gt; gt;

Alex,

At the upper left-hand corner of the pivot table you should see a field
button that says something like quot;Sum of _Name of Percentage Field_quot;.

Right click on this button. Select quot;Field Settingsquot;. In the quot;Summarize Byquot;
box select Average and click OK.

Does that work?

quot;Alexquot; wrote:

gt; Thank you very much, Dominic. I did it.
gt; The table looks as below:
gt; Planned Total
gt; 942-1941 18.36321823
gt; 1942-2941 4.335326773
gt; 2942-3941 23.12984109
gt; ...
gt;
gt; However, the total represents probably the sum of %. How could I show some
gt; average % on target for the range and not the sum %.
gt;
gt; Thanks
gt;
gt; quot;Dominicquot; wrote:
gt;
gt; gt; Alex,
gt; gt;
gt; gt; I think you could use a pivot table for this.
gt; gt;
gt; gt; Data:PivotTable Report
gt; gt;
gt; gt; Put your planned (or actual, or both) fields in the row area, then put your
gt; gt; percentage field in the data area.
gt; gt;
gt; gt; Click finish
gt; gt;
gt; gt; Right click on your row header (planned or actual) select Group and
gt; gt; Outline:Group.
gt; gt;
gt; gt; Here you can define how large the range should be when evaluating case load.
gt; gt;
gt; gt; HTH
gt; gt;
gt; gt; quot;Alexquot; wrote:
gt; gt;
gt; gt; gt; I have a table with days, planned and actual production, and % of actual vs.
gt; gt; gt; planned.
gt; gt; gt; DayPlanned Cs Actual Cs%
gt; gt; gt; 26-Feb-061667 2025.25 121.49%
gt; gt; gt; 30-Apr-061667 1838.25 110.27%
gt; gt; gt; 19-Feb-061667 1950 116.98%
gt; gt; gt; 16-Apr-061660 1657 99.82%
gt; gt; gt; 26-Mar-061696 1693.5 99.85%
gt; gt; gt; 29-Jan-061696 1691 99.71%
gt; gt; gt;
gt; gt; gt; I need to find a correlation between a number of cases planned (or actually
gt; gt; gt; produced) and the % (to be on target). Whether having some specific range of
gt; gt; gt; planned cases it's difficult to be on target and having another range or
gt; gt; gt; number of cases it's easier to be on target.
gt; gt; gt; What analysis tool do I need to use for this case and how I would need to
gt; gt; gt; presenty the data?
gt; gt; gt; Thanks.
gt; gt; gt;

Thank you very much Dominic. It looks great.

quot;Dominicquot; wrote:

gt; Alex,
gt;
gt; At the upper left-hand corner of the pivot table you should see a field
gt; button that says something like quot;Sum of _Name of Percentage Field_quot;.
gt;
gt; Right click on this button. Select quot;Field Settingsquot;. In the quot;Summarize Byquot;
gt; box select Average and click OK.
gt;
gt; Does that work?
gt;
gt; quot;Alexquot; wrote:
gt;
gt; gt; Thank you very much, Dominic. I did it.
gt; gt; The table looks as below:
gt; gt; Planned Total
gt; gt; 942-1941 18.36321823
gt; gt; 1942-2941 4.335326773
gt; gt; 2942-3941 23.12984109
gt; gt; ...
gt; gt;
gt; gt; However, the total represents probably the sum of %. How could I show some
gt; gt; average % on target for the range and not the sum %.
gt; gt;
gt; gt; Thanks
gt; gt;
gt; gt; quot;Dominicquot; wrote:
gt; gt;
gt; gt; gt; Alex,
gt; gt; gt;
gt; gt; gt; I think you could use a pivot table for this.
gt; gt; gt;
gt; gt; gt; Data:PivotTable Report
gt; gt; gt;
gt; gt; gt; Put your planned (or actual, or both) fields in the row area, then put your
gt; gt; gt; percentage field in the data area.
gt; gt; gt;
gt; gt; gt; Click finish
gt; gt; gt;
gt; gt; gt; Right click on your row header (planned or actual) select Group and
gt; gt; gt; Outline:Group.
gt; gt; gt;
gt; gt; gt; Here you can define how large the range should be when evaluating case load.
gt; gt; gt;
gt; gt; gt; HTH
gt; gt; gt;
gt; gt; gt; quot;Alexquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; I have a table with days, planned and actual production, and % of actual vs.
gt; gt; gt; gt; planned.
gt; gt; gt; gt; DayPlanned Cs Actual Cs%
gt; gt; gt; gt; 26-Feb-061667 2025.25 121.49%
gt; gt; gt; gt; 30-Apr-061667 1838.25 110.27%
gt; gt; gt; gt; 19-Feb-061667 1950 116.98%
gt; gt; gt; gt; 16-Apr-061660 1657 99.82%
gt; gt; gt; gt; 26-Mar-061696 1693.5 99.85%
gt; gt; gt; gt; 29-Jan-061696 1691 99.71%
gt; gt; gt; gt;
gt; gt; gt; gt; I need to find a correlation between a number of cases planned (or actually
gt; gt; gt; gt; produced) and the % (to be on target). Whether having some specific range of
gt; gt; gt; gt; planned cases it's difficult to be on target and having another range or
gt; gt; gt; gt; number of cases it's easier to be on target.
gt; gt; gt; gt; What analysis tool do I need to use for this case and how I would need to
gt; gt; gt; gt; presenty the data?
gt; gt; gt; gt; Thanks.
gt; gt; gt; gt;

Great!

Glad it worked out. Thanks for letting me know.

quot;Alexquot; wrote:

gt; Thank you very much Dominic. It looks great.
gt;
gt; quot;Dominicquot; wrote:
gt;
gt; gt; Alex,
gt; gt;
gt; gt; At the upper left-hand corner of the pivot table you should see a field
gt; gt; button that says something like quot;Sum of _Name of Percentage Field_quot;.
gt; gt;
gt; gt; Right click on this button. Select quot;Field Settingsquot;. In the quot;Summarize Byquot;
gt; gt; box select Average and click OK.
gt; gt;
gt; gt; Does that work?
gt; gt;
gt; gt; quot;Alexquot; wrote:
gt; gt;
gt; gt; gt; Thank you very much, Dominic. I did it.
gt; gt; gt; The table looks as below:
gt; gt; gt; Planned Total
gt; gt; gt; 942-1941 18.36321823
gt; gt; gt; 1942-2941 4.335326773
gt; gt; gt; 2942-3941 23.12984109
gt; gt; gt; ...
gt; gt; gt;
gt; gt; gt; However, the total represents probably the sum of %. How could I show some
gt; gt; gt; average % on target for the range and not the sum %.
gt; gt; gt;
gt; gt; gt; Thanks
gt; gt; gt;
gt; gt; gt; quot;Dominicquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; Alex,
gt; gt; gt; gt;
gt; gt; gt; gt; I think you could use a pivot table for this.
gt; gt; gt; gt;
gt; gt; gt; gt; Data:PivotTable Report
gt; gt; gt; gt;
gt; gt; gt; gt; Put your planned (or actual, or both) fields in the row area, then put your
gt; gt; gt; gt; percentage field in the data area.
gt; gt; gt; gt;
gt; gt; gt; gt; Click finish
gt; gt; gt; gt;
gt; gt; gt; gt; Right click on your row header (planned or actual) select Group and
gt; gt; gt; gt; Outline:Group.
gt; gt; gt; gt;
gt; gt; gt; gt; Here you can define how large the range should be when evaluating case load.
gt; gt; gt; gt;
gt; gt; gt; gt; HTH
gt; gt; gt; gt;
gt; gt; gt; gt; quot;Alexquot; wrote:
gt; gt; gt; gt;
gt; gt; gt; gt; gt; I have a table with days, planned and actual production, and % of actual vs.
gt; gt; gt; gt; gt; planned.
gt; gt; gt; gt; gt; DayPlanned Cs Actual Cs%
gt; gt; gt; gt; gt; 26-Feb-061667 2025.25 121.49%
gt; gt; gt; gt; gt; 30-Apr-061667 1838.25 110.27%
gt; gt; gt; gt; gt; 19-Feb-061667 1950 116.98%
gt; gt; gt; gt; gt; 16-Apr-061660 1657 99.82%
gt; gt; gt; gt; gt; 26-Mar-061696 1693.5 99.85%
gt; gt; gt; gt; gt; 29-Jan-061696 1691 99.71%
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; I need to find a correlation between a number of cases planned (or actually
gt; gt; gt; gt; gt; produced) and the % (to be on target). Whether having some specific range of
gt; gt; gt; gt; gt; planned cases it's difficult to be on target and having another range or
gt; gt; gt; gt; gt; number of cases it's easier to be on target.
gt; gt; gt; gt; gt; What analysis tool do I need to use for this case and how I would need to
gt; gt; gt; gt; gt; presenty the data?
gt; gt; gt; gt; gt; Thanks.
gt; gt; gt; gt; gt;