Spreadsheet: 688779d1595952928-creating-a-list-based-on-sum-of-values-example
Sheet: Sheet1

Sort1 / MegaCycle |  |  |  | A |  |  | B |  |  | C |  |  | D |  |  | E |  |  | G
 |  |  |  | Cluster Volume |  |  | Cluster Volume |  |  | Cluster Volume |  |  | Cluster Volume |  |  | Cluster Volume |  |  | Cluster Volume |  |  | Cluster Volume |  |  | Cluster Volume |  |  |  | Cluster Volume |  |  |  | Cluster Volume |  |  | Cluster Volume |  |  |  | Cluster Volume |  |  |  | Cluster Volume |  |  | Cluster Volume
 |  |  |  | 10562 |  |  | 11181 |  |  | 11604 |  |  | 11288 |  |  | 11610 |  |  | 11332
Total Volume |  | 67577 |  | Aisles Used |  | 31 | Aisles Used |  | 33 | Aisles Used |  | 33 | Aisles Used |  | 33 | Aisles Used |  | 33 | Aisles Used |  | 33 | Aisles Used |  |  | Aisles Used |  |  |  | Aisles Used |  |  |  | Aisles Used |  |  | Aisles Used |  |  |  | Aisles Used |  |  |  | Aisles Used |  |  | Aisles Used
 |  |  |  | P2B Staffing |  | 5 | P2B Staffing |  | 5 | P2B Staffing |  | 6 | P2B Staffing |  | 5 | P2B Staffing |  | 6 | P2B Staffing |  | 5 | P2B Staffing |  | #[NAME]! | P2B Staffing |  |  | #[NAME]! | P2B Staffing |  |  | #[NAME]! | P2B Staffing |  | #[NAME]! | P2B Staffing |  |  | #[NAME]! | P2B Staffing |  |  | #[NAME]! | P2B Staffing |  | #[NAME]! | P2B Staffing |  | #[NAME]!
Belt Run Time |  | 6.583333333333333 |  | Stow Staffing |  | 5.347848101265822 | Stow Staffing |  | 5.661265822784811 | Stow Staffing |  | 5.875443037974684 | Stow Staffing |  | 5.715443037974683 | Stow Staffing |  | 5.878481012658229 | Stow Staffing |  | 5.737721518987342 | Stow Staffing |  |  | Stow Staffing |  |  |  | Stow Staffing |  |  |  | Stow Staffing |  |  | Stow Staffing |  |  |  | Stow Staffing |  |  |  | Stow Staffing |  |  | Stow Staffing
Induct Start Time |  | 20:30:00 |  | Aisle | Volume |  | Aisle | Volume |  | Aisle | Volume |  | Aisle | Volume |  | Aisle | Volume |  | Aisle | Volume |  | Aisle | Volume |  | Aisle | Volume |  |  | Aisle |  | Volume |  | Aisle | Volume |  | Aisle | Volume |  |  | Aisle |  | Volume |  | Aisle | Volume |  | Aisle | Volume
Target Scan Down |  | 04:15:00 |  |  | Total | Per Hour |  | Total | Per Hour |  | Total | Per Hour |  | Total | Per Hour |  | Total | Per Hour |  | Total | Per Hour |  | Total | Per Hour |  | Total |  | Per Hour |  |  | Total | Per Hour |  | Total | Per Hour |  | Total |  | Per Hour |  |  | Total | Per Hour |  | Total | Per Hour |  | Total | Per Hour
Breaks (in Min) |  | 40 |  | A - 1/2 |  |  | B - 1/2 |  |  | C - 1/2 |  |  | D - 1/2 |  |  | E - 1/2 |  |  | G - 1/2
[NAME] (in Min) |  | 30 |  | A - 3/4 |  |  | B - 3/4 |  |  | C - 3/4 |  |  | D - 3/4 |  |  | E - 3/4 |  |  | G - 3/4
 |  |  |  | A - 5/6 |  |  | B - 5/6 |  |  | C - 5/6 |  |  | D - 5/6 |  |  | E - 5/6 |  |  | G - 5/6
Target P2B Rate |  | 350 |  | A - 7/8 |  |  | B - 7/8 |  |  | C - 7/8 |  |  | D - 7/8 |  |  | E - 7/8 |  |  | G - 7/8
Target Stow Rate |  | 300 |  | A - 9/10 |  |  | B - 9/10 | 201 | 30.53164556962026 | C - 9/10 | 313 | 47.54430379746836 | D - 9/10 | 338 | 51.34177215189874 | E - 9/10 | 338 | 51.34177215189874 | G - 9/10 | 330 | 50.12658227848102
 |  |  |  | A - 11/12 | 687 | 104.3544303797468 | B - 11/12 | 676 | 102.6835443037975 | C - 11/12 | 688 | 104.5063291139241 | D - 11/12 | 655 | 99.49367088607596 | E - 11/12 | 759 | 115.2911392405063 | G - 11/12 | 659 | 100.1012658227848
Suggested Staffing |  |  |  | A - 13/14 | 744 | 113.0126582278481 | B - 13/14 | 668 | 101.4683544303797 | C - 13/14 | 744 | 113.0126582278481 | D - 13/14 | 631 | 95.84810126582279 | E - 13/14 | 731 | 111.0379746835443 | G - 13/14 | 654 | 99.34177215189874
 |  |  |  | A - 15/16 | 680 | 103.2911392405063 | B - 15/16 | 697 | 105.873417721519 | C - 15/16 | 709 | 107.6962025316456 | D - 15/16 | 675 | 102.5316455696203 | E - 15/16 | 686 | 104.2025316455696 | G - 15/16 | 719 | 109.2151898734177
P2B |  | Stow |  | A - 17/18 | 670 | 101.7721518987342 | B - 17/18 | 650 | 98.73417721518987 | C - 17/18 | 732 | 111.1898734177215 | D - 17/18 | 666 | 101.1645569620253 | E - 17/18 | 704 | 106.9367088607595 | G - 17/18 | 678 | 102.9873417721519
 |  |  |  | A - 19/20 | 363 | 55.13924050632912 | B - 19/20 | 687 | 104.3544303797468 | C - 19/20 | 702 | 106.6329113924051 | D - 19/20 | 727 | 110.4303797468354 | E - 19/20 | 744 | 113.0126582278481 | G - 19/20 | 681 | 103.4430379746835
 |  |  |  | A - 21/22 | 597 | 90.68354430379748 | B - 21/22 | 611 | 92.81012658227849 | C - 21/22 | 709 | 107.6962025316456 | D - 21/22 | 667 | 101.3164556962025 | E - 21/22 | 724 | 109.9746835443038 | G - 21/22 | 669 | 101.620253164557
 |  |  |  | A - 23/24 | 641 | 97.36708860759494 | B - 23/24 | 752 | 114.2278481012658 | C - 23/24 | 628 | 95.39240506329115 | D - 23/24 | 744 | 113.0126582278481 | E - 23/24 | 661 | 100.4050632911392 | G - 23/24 | 717 | 108.9113924050633
 |  |  |  | A - 25/26 | 721 | 109.5189873417722 | B - 25/26 | 687 | 104.3544303797468 | C - 25/26 | 757 | 114.9873417721519 | D - 25/26 | 671 | 101.9240506329114 | E - 25/26 | 767 | 116.5063291139241 | G - 25/26 | 781 | 118.6329113924051
 |  |  |  | A - 27/28 | 692 | 105.1139240506329 | B - 27/28 | 701 | 106.4810126582279 | C - 27/28 | 733 | 111.3417721518987 | D - 27/28 | 660 | 100.253164556962 | E - 27/28 | 714 | 108.4556962025317 | G - 27/28 | 690 | 104.8101265822785
 |  |  |  | A - 29/30 | 723 | 109.8227848101266 | B - 29/30 | 715 | 108.6075949367089 | C - 29/30 | 649 | 98.58227848101266 | D - 29/30 | 713 | 108.3037974683544 | E - 29/30 | 689 | 104.6582278481013 | G - 29/30 | 686 | 104.2025316455696
 |  |  |  | A - 31/32 | 645 | 97.9746835443038 | B - 31/32 | 669 | 101.620253164557 | C - 31/32 | 660 | 100.253164556962 | D - 31/32 | 663 | 100.7088607594937 | E - 31/32 | 696 | 105.7215189873418 | G - 31/32 | 713 | 108.3037974683544
 |  |  |  | A - 33/34 | 715 | 108.6075949367089 | B - 33/34 | 680 | 103.2911392405063 | C - 33/34 | 742 | 112.7088607594937 | D - 33/34 | 687 | 104.3544303797468 | E - 33/34 | 658 | 99.9493670886076 | G - 33/34 | 644 | 97.82278481012659
 |  |  |  | A - 35/36 | 700 | 106.3291139240506 | B - 35/36 | 721 | 109.5189873417722 | C - 35/36 | 712 | 108.1518987341772 | D - 35/36 | 712 | 108.1518987341772 | E - 35/36 | 688 | 104.5063291139241 | G - 35/36 | 704 | 106.9367088607595
 |  |  |  | A - 37/38 | 716 | 108.7594936708861 | B - 37/38 | 685 | 104.0506329113924 | C - 37/38 | 731 | 111.0379746835443 | D - 37/38 | 674 | 102.379746835443 | E - 37/38 | 683 | 103.746835443038 | G - 37/38 | 640 | 97.21518987341773
 |  |  |  | A - 39/40 | 645 | 97.9746835443038 | B - 39/40 | 668 | 101.4683544303797 | C - 39/40 | 685 | 104.0506329113924 | D - 39/40 | 674 | 102.379746835443 | E - 39/40 | 689 | 104.6582278481013 | G - 39/40 | 679 | 103.1392405063291
 |  |  |  | A - 41/42 | 623 | 94.63291139240506 | B - 41/42 | 713 | 108.3037974683544 | C - 41/42 | 710 | 107.8481012658228 | D - 41/42 | 731 | 111.0379746835443 | E - 41/42 | 679 | 103.1392405063291 | G - 41/42 | 688 | 104.5063291139241