Company Name |
Product Name |
|
Year-round |
Q1 |
Q2 |
Q3 |
Q4 |
Xvizion |
A8 |
Target number |
100 |
10 |
20 |
30 |
40 |
Number of completions |
10 |
1 |
2 |
3 |
4 |
Target points |
200 |
20 |
40 |
60 |
80 |
Completion Points |
20 |
2 |
4 |
6 |
8 |
A9 |
Target number |
100 |
10 |
20 |
30 |
40 |
Number of completions |
10 |
1 |
2 |
3 |
4 |
Target points |
200 |
20 |
40 |
60 |
80 |
Completion Points |
20 |
2 |
4 |
6 |
8 |
Shows the table mode to be solved.
The data obtained is
Company Name |
Product Name |
Number of targets for the year |
Q1 target number |
Q2 target count |
Q3 target number |
Q4 target number |
Annual target points |
Q1 target points |
Q2 target points |
Q3 target points |
Q4 target points |
Number of completed projects in the year |
Q1 completion count |
Q2 completions |
Q3 completions |
Q4 completion count |
Number of completed points for the year |
Q1 Completion Points |
Q2 Completion Points |
Q3 Completion Points |
Q4 Completion Points |
Xvizion |
A8 |
100 |
10 |
20 |
30 |
40 |
200 |
20 |
40 |
60 |
80 |
10 |
1 |
2 |
3 |
4 |
20 |
2 |
4 |
6 |
8 |
Xvizion |
A9 |
100 |
10 |
20 |
30 |
40 |
200 |
20 |
40 |
60 |
80 |
10 |
1 |
2 |
3 |
4 |
20 |
2 |
4 |
6 |
8 |
The solution is very long.
My data is in Excel ..