Spreadsheet: 294119d1391194272-transferring-selective-data-from-one-table-to-another-with-in-the-same-worksheet-producta
Sheet: Sheet3

Product A
Table 1
 | Sample Date | 3hrs | 7hrs | 10hrs
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
Average of Las 30 |  | 3331 | 4653.333333333333 | 6153.433333333333
STDEV of Last 30 |  | 268.2225444166343 | 316.2777405942456 | 396.5443562034111
Total Average |  | 3497.931034482759 | 316.2777405942456 | 396.5443562034111
STDEV of all Tests |  | 298.3451896993619 | 327.5623143849014 | 378.0461934084875
Table 2
Sale No. | Sample Date | 3hrs | 7hrs | 10hrs | 12hrs | code#
1 | 2011-06-27 00:00:00 | 3550 | 4370 | 5953 | 7400 | 112569 | 6.5
2 | 2011-07-13 00:00:00 |  | 4425 | 6053 | 6380 | 112570 | 6
3 | 2011-08-04 00:00:00 |  | 5080 | 6365 | 6760 | 112571 | 5.5
4 | 2011-08-18 00:00:00 |  | 5480 | 7160 | 7930 | 112572 | 6
5 | 2011-09-07 00:00:00 |  | 4530 | 6160 | 6440 | 112573 | 5
6 | 2011-09-07 00:00:00 |  | 4480 | 5955 | 6470 | 112574 | 4
7 | 2011-09-14 00:00:00 |  | 4070 | 5460 | 6720 | 112575 | 4
8 | 2011-09-23 00:00:00 | 3560 | 4310 | 6210 |  | 112576 | 6.5
9 | 2011-09-23 00:00:00 | 3850 | 4890 | 6270 |  | 112577 | 4.5
10 | 2011-09-23 00:00:00 | 3790 | 5040 | 6105 |  | 112578 | 5
11 | 2011-09-23 00:00:00 | 3970 | 4570 | 6405 |  | 112579 | 4.5
12 | 2011-09-30 00:00:00 |  | 4140 | 6083 | 6770 | 112580 | 5
13 | 2011-10-06 00:00:00 | 3780 | 4930 | 5725 |  | 112581 | 3
14 | 2011-10-07 00:00:00 | 3480 | 4170 | 6085 |  | 112582 | 5.5
15 | 2011-10-07 00:00:00 | 4110 | 4770 | 6860 |  | 112583 | 5
16 | 2011-10-07 00:00:00 | 3670 | 4340 | 6030 |  | 112584 | 5
17 | 2011-10-14 00:00:00 | 3730 | 4480 | 6455 |  | 112585 | 4
18 | 2011-10-14 00:00:00 | 3760 | 4590 | 6015 |  | 112586 | 4.5
19 | 2011-10-14 00:00:00 | 3550 | 4480 | 5785 |  | 112587 | 4.5
20 | 2011-10-21 00:00:00 | 3310 | 4230 | 5835 |  | 112588 | 4.5
21 | 2011-10-21 00:00:00 | 3470 | 4530 | 5675 |  | 112589 | 4.5
22 | 2011-10-21 00:00:00 | 3390 | 4620 | 5705 |  | 112590 | 4.5
23 | 2011-10-28 00:00:00 | 3430 | 4800 | 6180 |  | 112591 | 5
24 | 2011-10-28 00:00:00 | 3490 | 4840 | 5980 |  | 112592 | 5.5
25 | 2011-11-07 00:00:00 | 3420 | 4930 | 6300 |  | 112593 | 4
26 | 2011-11-07 00:00:00 | 2820 | 4140 | 5865 |  | 112594 | 4.5
27 | 2011-11-07 00:00:00 | 3160 | 4800 | 5870 |  | 112595 | 4
28 | 2011-11-09 00:00:00 |  | 5360 | 6845 | 7260 | 112596 | 4.5
29 | 2011-11-16 00:00:00 |  | 4395 | 5825 | 6680 | 112597 | 5.5
30 | 2011-11-16 00:00:00 |  | 4245 | 5560 | 6130 | 112598 | 6
31 | 2011-11-16 00:00:00 |  | 4310 | 5975 | 5070 | 112599 | 5.5
32 | 2011-11-16 00:00:00 |  | 4530 | 6140 | 8140 | 112600 | 4
33 | 2011-11-16 00:00:00 |  | 4900 | 5785 | 6670 | 112601 | 4.5
34 | 2011-11-16 00:00:00 |  | 4580 | 6200 | 7350 | 112602 | 4.5
35 | 2011-11-28 00:00:00 |  | 4780 | 5695 | 7390 | 112603
36 | 2011-11-28 00:00:00 |  | 4280 | 5830 | 6750 | 112604 | 5
37 | 2011-11-28 00:00:00 |  | 4530 | 5425 | 6780 | 112605 | 4.75
38 | 2011-11-28 00:00:00 |  | 4800 | 6155 | 6940 | 112606 | 4.75
39 | 2011-11-30 00:00:00 |  | 4780 | 5920 | 6960 | 112607 | 4.5
40 | 2011-11-30 00:00:00 |  | 4580 | 6060 | 6790 | 112608 | 5
41 | 2011-12-06 00:00:00 | 3080 | 4430 | 6135 | 0 | 112609 | 4
42 | 2011-12-06 00:00:00 | 3260 | 4590 | 5920 | 0 | 112610 | 5
43 | 2011-12-06 00:00:00 | 3720 | 5290 | 6435 | 0 | 112611 | 5
44 | 2011-12-07 00:00:00 |  | 4870 | 6530 | 6970 | 112612 | 4.5
45 | 2011-12-07 00:00:00 |  | 4780 | 6425 | 7140 | 112613 | 4.5
46 | 2011-12-07 00:00:00 |  | 4590 | 6250 | 6470 | 112614 | 4.5
47 | 2011-12-16 00:00:00 | 3120 | 4270 | 6210 | 6130 | 112615 | 4
48 | 2011-12-16 00:00:00 | 2970 | 4030 | 5670 | 0 | 112616 | 5
49 | 2011-12-16 00:00:00 | 3250 | 4500 | 6465 | 0 | 112617 | 4.5
50 | 2011-12-16 00:00:00 | 3470 | 4630 | 6710 | 0 | 112618 | 4.5
51 | 2011-12-27 00:00:00 | 3580 | 5110 | 6880 | 7420 | 112619 | 5
52 | 2011-12-27 00:00:00 | 3700 | 5140 | 6980 | 7390 | 112620 | 4.5
53 | 2011-12-29 00:00:00 |  | 4990 | 6585 | 7590 | 112621 | 4.5
54 | 2011-12-29 00:00:00 |  | 4620 | 5980 | 7220 | 112622 | 4.5
55 | 2011-12-29 00:00:00 |  | 4470 | 6170 | 7780 | 112623 | 4.5
56 | 2012-01-05 00:00:00 |  | 4420 | 5973 | 7160 | 112624 | 5
57 | DON’T ENTER DATA |  |  |  |  |  |  | PLEASE INSERT ROW ABOVE EMPTYROW
Average of Las 30 |  | 3331 | 4653.333333333333 | 6153.433333333333 | 6964.347826086957 | 112609.5 | 4.689655172413793
STDEV of Last 30 |  | 268.2225444166343 | 316.2777405942456 | 396.5443562034111 | 635.4370442098476 | 8.803408430829505 | 0.4660585704962485
Total Average |  | 3497.931034482759 | 4622.053571428572 | 6129.946428571428 | 6937.096774193548 | 112596.5 | 4.772727272727272
STDEV of all Tests |  | 298.3451896993619 | 327.5623143849014 | 378.0461934084875 | 2650.469701701878 | 16.30950643030009 | 0.6566482077085646