Spreadsheet: 136817d1326833265-advancing-arrays-based-on-value-tigeravatar-example-for-capnponcho
Sheet: Sheet1

Salesman | 2012-01-01 00:00:00 | 2012-01-02 00:00:00 | 2012-01-03 00:00:00 | 2012-01-04 00:00:00 | 2012-01-05 00:00:00 | 2012-01-06 00:00:00 | 2012-01-07 00:00:00 | 2012-01-08 00:00:00 | 2012-01-09 00:00:00 | 2012-01-10 00:00:00 | 2012-01-11 00:00:00 | 2012-01-12 00:00:00 | 2012-01-13 00:00:00 | 2012-01-14 00:00:00 | 2012-01-15 00:00:00 | 2012-01-16 00:00:00 | 2012-01-17 00:00:00 | 2012-01-18 00:00:00 | 2012-01-19 00:00:00 | 2012-01-20 00:00:00 | 2012-01-21 00:00:00 | 2012-01-22 00:00:00 | 2012-01-23 00:00:00 | 2012-01-24 00:00:00 | 2012-01-25 00:00:00 | 2012-01-26 00:00:00 | 2012-01-27 00:00:00 | 2012-01-28 00:00:00 | 2012-01-29 00:00:00 | 2012-01-30 00:00:00 | 2012-01-31 00:00:00 | 2012-02-01 00:00:00 | 2012-02-02 00:00:00 | 2012-02-03 00:00:00 | 2012-02-04 00:00:00 | 2012-02-05 00:00:00 | 2012-02-06 00:00:00 | 2012-02-07 00:00:00 | 2012-02-08 00:00:00 | 2012-02-09 00:00:00 | 2012-02-10 00:00:00 | 2012-02-11 00:00:00 | 2012-02-12 00:00:00 | 2012-02-13 00:00:00 | 2012-02-14 00:00:00 | 2012-02-15 00:00:00 | 2012-02-16 00:00:00 | 2012-02-17 00:00:00 | 2012-02-18 00:00:00 | 2012-02-19 00:00:00 | 2012-02-20 00:00:00 | 2012-02-21 00:00:00 | 2012-02-22 00:00:00 | 2012-02-23 00:00:00 | 2012-02-24 00:00:00 | 2012-02-25 00:00:00 | 2012-02-26 00:00:00 | 2012-02-27 00:00:00 | 2012-02-28 00:00:00 | 2012-02-29 00:00:00
Salesman 1 | 663.99 | 664.63 | 424.86 | 273.4 | 754.17 | 254.44 | 332.04 | 898.77 | 861.56 | 393.28 | 752.35 | 280.51 | 920.14 | 424.68 | 301.1 | 397.68 | 836.43 | 774.02 | 472.5 | 328.45 | 595.3 | 115.52 | 857.37 | 647.92 | 128.32 | 182.42 | 648.87 | 312.8 | 534.85 | 895.81 | 130.26 | 849.7 | 942.38 | 227.57 | 793.48 | 466.97 | 207.31 | 286.9 | 685.05 | 857.52 | 222.08 | 476.6 | 102.6 | 600.92 | 103.43 | 967.32 | 284.13 | 527.73 | 486.02 | 922.48 | 488.9 | 461.81 | 957.08 | 630.4 | 776.53 | 295.76 | 888.24 | 197.23 | 671.77 | 299.48
Salesman 2 | 790.13 | 695.62 | 997.71 | 864.09 | 313.42 | 534.62 | 798.01 | 650.82 | 479.12 | 245.02 | 568.5 | 113.13 | 712.01 | 410.9 | 660.69 | 487.19 | 439.5 | 500.14 | 957.67 | 935.72 | 746.48 | 632.23 | 357.22 | 261.04 | 989.75 | 289.06 | 794.86 | 920.6 | 987.85 | 946.82 | 124.39 | 442.95 | 406.27 | 516.88 | 560.24 | 470.39 | 300.27 | 678.68 | 345.37 | 962.39 | 715.64 | 634.21 | 826.02 | 544.78 | 456 | 981.33 | 587.14 | 354.39 | 647.32 | 928.25 | 176.9 | 435.51 | 752.74 | 175.44 | 632.04 | 130.82 | 716.92 | 924.46 | 184.04 | 604.94
Salesman 3 | 832.24 | 170.07 | 901.91 | 581.86 | 928.28 | 533.03 | 133.73 | 305.48 | 441.26 | 682.95 | 696.94 | 467.7 | 856.61 | 485.9 | 890.09 | 920.02 | 939.68 | 898.41 | 143.95 | 738.01 | 179.46 | 719.29 | 110.79 | 841.3 | 306.41 | 811.67 | 706.47 | 862.84 | 789.79 | 970.65 | 321.68 | 792.21 | 579.21 | 811.14 | 189.04 | 305.52 | 198.97 | 266.63 | 136.98 | 614.81 | 242.27 | 938.63 | 947.17 | 240.45 | 339.84 | 382.56 | 767.64 | 356.5 | 608.58 | 366.77 | 237.42 | 751.28 | 737.55 | 314.01 | 970.25 | 691.86 | 565.45 | 354.95 | 847.69 | 838.59
Salesman 4 | 620.02 | 922.5 | 193.86 | 607.94 | 628.9 | 615.73 | 436.69 | 601.02 | 833.7 | 295.39 | 198.25 | 681.41 | 790.81 | 627.69 | 275.54 | 386.53 | 976.05 | 732.99 | 563.03 | 523.91 | 649.11 | 296.23 | 676.48 | 324.76 | 794.05 | 250.63 | 270.85 | 536.89 | 904.2 | 554.26 | 383.35 | 685.58 | 748.18 | 632.92 | 613.19 | 200.24 | 549.63 | 924.59 | 356.82 | 605.21 | 772.12 | 823.87 | 320.3 | 968.1 | 755.27 | 842.54 | 823.17 | 751.44 | 374.63 | 157.2 | 671.52 | 362.79 | 922.71 | 966.13 | 252.5 | 499.37 | 955.49 | 409.64 | 686.51 | 236.98
Salesman 5 | 270.52 | 323.4 | 576.3 | 446.65 | 408.3 | 844.74 | 266.86 | 140.58 | 153.99 | 993.02 | 485.04 | 355.49 | 337.8 | 442.39 | 593.55 | 884.1 | 538.77 | 204.56 | 504.4 | 793.62 | 280.74 | 310.62 | 544.24 | 732.68 | 751.66 | 493.99 | 784.13 | 949.23 | 773.53 | 749.12 | 804.65 | 873.7 | 428.05 | 756.22 | 376.45 | 684.41 | 805.83 | 414 | 953.78 | 913.85 | 692.47 | 715.66 | 760.59 | 118.99 | 182.51 | 763.63 | 218.73 | 403.59 | 983.48 | 636.13 | 922.02 | 729.17 | 280.65 | 532.75 | 277.22 | 515.55 | 224.48 | 873.01 | 424.92 | 324.62
Salesman 6 | 508.11 | 173.71 | 354.93 | 510.48 | 216.38 | 630.93 | 478.87 | 311.15 | 234.68 | 215.78 | 247.65 | 393.97 | 799 | 593.07 | 587.23 | 669 | 868.86 | 300.17 | 101.99 | 961.71 | 126.59 | 705.49 | 964.07 | 492.76 | 476.94 | 333.96 | 925.69 | 396.72 | 761.09 | 858.93 | 270.76 | 765.55 | 898.23 | 847.63 | 171.15 | 155.24 | 301.95 | 477.91 | 367.44 | 269.17 | 527.47 | 512.57 | 257.2 | 621.18 | 520.02 | 555.57 | 971.78 | 788.59 | 404.48 | 489.6 | 718.15 | 626.77 | 402.5 | 454.66 | 688.9 | 563.88 | 502.04 | 327.06 | 586.09 | 390.65
Salesman 7 | 254.48 | 759.3 | 948.28 | 679.75 | 331.74 | 604.85 | 202.02 | 727.33 | 475.5 | 811.39 | 468.02 | 326.71 | 218.56 | 735.79 | 877.61 | 164.88 | 430.78 | 986.23 | 683.2 | 496.68 | 845.18 | 982.59 | 375.51 | 331.97 | 138.35 | 224.38 | 604.6 | 173.98 | 319.92 | 954.71 | 932.55 | 843.12 | 352.59 | 451.55 | 192.73 | 774.54 | 529.5 | 213.55 | 863.94 | 254.18 | 637.24 | 192.26 | 916.79 | 820.41 | 265.17 | 954.52 | 649.83 | 144.97 | 432.73 | 338.61 | 304.2 | 762.89 | 127.07 | 739.06 | 898.74 | 146.42 | 300.33 | 238.45 | 209.8 | 402.58
Salesman 8 | 127.46 | 579.25 | 776.64 | 953.1 | 111.86 | 108.1 | 610.49 | 694.04 | 950.68 | 381.42 | 262.24 | 892.73 | 346.91 | 315.04 | 237.68 | 360.5 | 729.31 | 282.02 | 204.9 | 520.07 | 598.09 | 324.17 | 691.87 | 666.43 | 672.74 | 586.78 | 403.31 | 881.17 | 900.13 | 410.72 | 294.68 | 585.78 | 779.87 | 639.39 | 639.09 | 894.68 | 110.55 | 496.69 | 139.6 | 591.46 | 850.22 | 862.31 | 972.22 | 937.25 | 730.87 | 588.95 | 396.6 | 228.83 | 902.9 | 330.65 | 556.47 | 423.91 | 740.24 | 954.65 | 217.28 | 136.57 | 760.56 | 250.33 | 729.43 | 645.44
Salesman 9 | 156.85 | 988.14 | 830.78 | 132.52 | 903.99 | 983.91 | 570.88 | 254.25 | 906.7 | 268.88 | 221.89 | 233.65 | 114.3 | 476.59 | 232.4 | 366.62 | 832.85 | 438.08 | 186.89 | 891.76 | 418.56 | 985.97 | 752.9 | 336.82 | 258.27 | 542.57 | 740.78 | 238.69 | 760.44 | 907.05 | 260.17 | 586.29 | 847.3 | 770.32 | 460.08 | 664 | 856.32 | 380.1 | 523.85 | 843.38 | 740.93 | 219.2 | 565.15 | 673.52 | 285.17 | 436.39 | 677.51 | 183.08 | 117.41 | 194.46 | 242.7 | 509.1 | 422.31 | 247.04 | 542.41 | 210.35 | 472.44 | 327.99 | 602.72 | 535.06
Salesman 10 | 962.73 | 701.3 | 126.19 | 712.59 | 820.91 | 275.97 | 670.59 | 341.02 | 665.47 | 137.79 | 604.14 | 214.99 | 920.21 | 262.33 | 103.5 | 252.15 | 156.99 | 184.27 | 344.62 | 121.72 | 329.95 | 557.7 | 748.07 | 912.73 | 835.34 | 230.47 | 787.56 | 692.41 | 559.82 | 453.22 | 408.46 | 479.85 | 145.51 | 365.48 | 504.81 | 486.77 | 911.02 | 261.01 | 817.21 | 111.72 | 656.5 | 649.06 | 719.64 | 621.45 | 738.09 | 861.68 | 802.84 | 841.98 | 549.58 | 441.16 | 461.93 | 386.2 | 444.71 | 310.78 | 472.69 | 804.89 | 946.78 | 289.51 | 798.87 | 537.48
Total Sales: | 5186.530000000001 | 5977.92 | 6131.46 | 5762.380000000001 | 5417.950000000001 | 5386.32 | 4500.18 | 4924.460000000001 | 6002.66 | 4424.92 | 4505.02 | 3960.29 | 6016.350000000001 | 4774.38 | 4759.39 | 4888.669999999999 | 6749.219999999999 | 5300.889999999999 | 4163.15 | 6311.650000000001 | 4769.46 | 5629.81 | 6078.52 | 5548.41 | 5351.83 | 3945.93 | 6667.120000000001 | 5965.329999999999 | 7291.619999999999 | 7701.290000000001 | 3930.95 | 6904.73 | 6127.59 | 6019.1 | 4500.26 | 5102.76 | 4771.35 | 4400.06 | 5190.04 | 6023.690000000001 | 6056.940000000001 | 6024.370000000001 | 6387.68 | 6147.05 | 4376.37 | 7334.49 | 6179.370000000001 | 4581.1 | 5507.13 | 4805.309999999999 | 4780.21 | 5449.43 | 5787.56 | 5324.919999999999 | 5728.559999999999 | 3995.47 | 6332.73 | 4192.63 | 5741.840000000001 | 4815.82
 | Date: | 2012-01-03 00:00:00
 | Total Sales: | 6131.46