Spreadsheet: 221300d1363458496-attemepting-to-link-and-automate-multiple-data-points-individual-rep-kpi-report-2013-example
Sheet: Data Dump

Name | Jan |  | Feb |  | Mar |  | Apr |  | May |  | Jun |  | Jul |  | Aug |  | Sep |  | Oct |  | Nov |  | Dec
 | Goal | Act | Goal | Act | Goal | Act | Goal | Act | Goal | Act | Goal | Act | Goal | Act | Goal | Act | Goal | Act | Goal | Act | Goal | Act | Goal | Act
Rep A | 1000 | 2110 | 1000 | 1590 | 1000 | 85.83
Rep B | 1000 | 2250 | 1000 | 1800 | 1000 | 600
Rep C | 1000 | 5136.66 | 1000 | 2526.66 | 1000 | 480
Rep D | 1000 | 3866.66 | 1000 | 1726.66 | 1000 | 520
Rep E | 1000 | 1550 | 1000 | 2373.33 | 1000 | 2480
Rep F | 1000 | 4260 | 1000 | 2580 | 1000 | 3405
Rep G | 1000 | 3170 | 1000 | 1643.33 | 1000 | 1480
Rep H | 1000 | 968.32 | 1000 | 1642.48 | 1000 | 1808.32
Rep I | 1000 | 1213.13 | 1000 | 1123.33 | 1000 | 480
Rep J | 1000 | 3114.99 | 1000 | 3654.99 | 1000 | 1023.33
Rep K | 1000 | 4752.5 | 1000 | 2394.17 | 1000 | 520
Rep L | 1000 | 1170 | 1000 | 520 | 1000 | 40
Rep M | 1000 | 40 | 1000 | 790 | 1000 | 1140
Rep N | 1000 | 1761.67 | 1000 | 3696.66 | 1000 | 1600
Rep O | 500 | 602.33 | 500 | 122.33 | 500 | 0
Total | 14500 | 35966.26 | 14500 | 28183.94 | 14500 | 15662.48
Name | Jan |  | Feb |  | Mar |  | Apr |  | May |  | Jun |  | Jul |  | Aug |  | Sep |  | Oct |  | Nov |  | Dec
 | Goal | Act | Goal | Act | Goal | Act | Goal | Act | Goal | Act | Goal | Act | Goal | Act | Goal | Act | Goal | Act | Goal | Act | Goal | Act | Goal | Act
Rep A | 5 | 4 | 5 | 4 | 5 | 1
Rep B | 5 | 4 | 5 | 3 | 5 | 1
Rep C | 5 | 11 | 5 | 4 | 5 | 1
Rep D | 5 | 9 | 5 | 4 | 5 | 1
Rep E | 5 | 3 | 5 | 5 | 5 | 5
Rep F | 5 | 7 | 5 | 5 | 5 | 6
Rep G | 5 | 6 | 5 | 5 | 5 | 3
Rep H | 5 | 5 | 5 | 3 | 5 | 3
Rep I | 5 | 4 | 5 | 2 | 5 | 1
Rep J | 5 | 5 | 5 | 10 | 5 | 3
Rep K | 7 | 9 | 7 | 5 | 7 | 1
Rep L | 5 | 2 | 5 | 1 | 5 | 0
Rep M | 5 | 1 | 5 | 2 | 5 | 2
Rep N | 5 | 4 | 5 | 11 | 5 | 3
Rep O | 2 | 2 | 2 | 0 | 2 | 0
Total | 74 | 76 | 74 | 64 | 74 | 31
Name | Jan |  | Feb |  | Mar |  | Apr |  | May |  | Jun |  | Jul |  | Aug |  | Sep |  | Oct |  | Nov |  | Dec
 | Goal | Act | Goal | Act | Goal | Act | Goal | Act | Goal | Act | Goal | Act | Goal | Act | Goal | Act | Goal | Act | Goal | Act | Goal | Act | Goal | Act
Rep A | 0.032 | 0.01111111111111111 | 0.043 | 0.01166180758017493 | 0.03791559931024967 | 0.009615384615384616
Rep B | 0.032 | 0.01092896174863388 | 0.043 | 0.00909090909090909 | 0.03791559931024967 | 0.007936507936507936
Rep C | 0.032 | 0.02956989247311828 | 0.043 | 0.01246105919003115 | 0.03791559931024967 | 0.009523809523809525
Rep D | 0.032 | 0.1022727272727273 | 0.043 | 0.05063291139240506 | 0.03791559931024967 | 0.02
Rep E | 0.032 | 0.01 | 0.043 | 0.04385964912280702 | 0.03791559931024967 | 0.08620689655172414
Rep F | 0.032 | 0.05035971223021583 | 0.043 | 0.03378378378378379 | 0.03791559931024967 | 0.09375
Rep G | 0.032 | 0.03870967741935484 | 0.043 | 0.03378378378378379 | 0.03791559931024967 | 0.03333333333333333
Rep H | 0.032 | 0.0267379679144385 | 0.043 | 0.015625 | 0.03791559931024967 | 0.04166666666666666
Rep I | 0.032 | 0.0119047619047619 | 0.043 | 0.007662835249042145 | 0.03791559931024967 | 0.01098901098901099
Rep J | 0.032 | 0.0423728813559322 | 0.043 | 0.1030927835051546 | 0.03791559931024967 | 0.0625
Rep K | 0.032 | 0.03448275862068965 | 0.043 | 0.02525252525252525 | 0.03791559931024967 | 0.008403361344537815
Rep L | 0.032 | 0.00819672131147541 | 0.043 | 0.005235602094240838 | 0.03791559931024967 | 0
Rep M | 0.032 | 0.003344481605351171 | 0.043 | 0.007067137809187279 | 0.03791559931024967 | 0.01680672268907563
Rep N | 0.032 | 0.01282051282051282 | 0.043 | 0.04313725490196078 | 0.03791559931024967 | 0.03157894736842105
Rep O | 0.032 |  | 0.043 |  | 0.03791559931024967
Total | 0.032 | 0.0223756248512259 | 0.043 | 0.02261553588987217 | 0.03791559931024967 | 0.02982292637465051
Name | Jan |  | Feb |  | Mar |  | Apr |  | May |  | Jun |  | Jul |  | Aug |  | Sep |  | Oct |  | Nov |  | Dec
 | Goal | Act | Goal | Act | Goal | Act | Goal | Act | Goal | Act | Goal | Act | Goal | Act | Goal | Act | Goal | Act | Goal | Act | Goal | Act | Goal | Act
Rep A | 6 | 8.153409090909092 | 6 | 10.01875 | 6 | 7.291666666666667
Rep B | 6 | 5.5625 | 6 | 4.859060402684563 | 6 | 4.15625
Rep C | 6 | 5.642045454545454 | 6 | 8.330882352941176 | 6 | 5.03125
Rep D | 6 | 2.416666666666667 | 6 | 2.775 | 6 | 2.388888888888889
Rep E | 6 | 4.798780487804878 | 6 | 4.67948717948718 | 6 | 4.027777777777778
Rep F | 6 | 3.825 | 6 | 4.240384615384615 | 6 | 4.020833333333333
Rep G | 6 | 3 | 6 | 4 | 6 | 3.833333333333333
Rep H | 6 | 3.203947368421053 | 6 | 4.414473684210527 | 6 | 3.5
Rep I | 6 | 6.988636363636363 | 6 | 7.475 | 6 | 7.222222222222222
Rep J | 6 | 4.693181818181818 | 6 | 3.5625 | 6 | 6.25
Rep K | 6 | 5.645833333333333 | 6 | 5.89375 | 6 | 7.921875
Rep L | 6 | 4.403409090909091 | 6 | 4.6 | 6 | 3.694444444444445
Rep M | 6 | 7.333333333333333 | 6 | 7.50625 | 6 | 5.805555555555555
Rep N | 6 | 3.958333333333333 | 6 | 4.1125 | 6 | 4
Rep O
Total | 6 | 4.898965791567224 | 6 | 5.60882800608828 | 6 | 5.034037558685446
Name | Jan |  | Feb |  | Mar |  | Apr |  | May |  | Jun |  | Jul |  | Aug |  | Sep |  | Oct |  | Nov |  | Dec
 | Goal | Act | Goal | Act | Goal | Act | Goal | Act | Goal | Act | Goal | Act | Goal | Act | Goal | Act | Goal | Act | Goal | Act | Goal | Act | Goal | Act
Rep A | 02:20:00 | 01:57:00 | 02:20:00 | 01:33:00 | 02:20:00 | 01:55:00
Rep B | 02:20:00 | 01:41:00 | 02:20:00 | 01:56:00 | 02:20:00 | 01:47:00
Rep C | 02:20:00 | 01:33:00 | 02:20:00 | 01:20:00 | 02:20:00 | 01:07:00
Rep D | 02:20:00 | 03:53:00 | 02:20:00 | 03:40:00 | 02:20:00 | 03:19:00
Rep E | 02:20:00 | 01:32:00 | 02:20:00 | 01:35:00 | 02:20:00 | 02:15:00
Rep F | 02:20:00 | 02:44:00 | 02:20:00 | 02:45:00 | 02:20:00 | 04:06:00
Rep G | 02:20:00 | 02:53:00 | 02:20:00 | 03:01:00 | 02:20:00 | 03:12:00
Rep H | 02:20:00 | 01:30:00 | 02:20:00 | 01:34:00 | 02:20:00 | 01:58:00
Rep I | 02:20:00 | 01:21:00 | 02:20:00 | 01:21:00 | 02:20:00 | 01:26:00
Rep J | 02:20:00 | 02:28:00 | 02:20:00 | 02:26:00 | 02:20:00 | 02:08:00
Rep K | 02:20:00 | 02:11:00 | 02:20:00 | 01:45:00 | 02:20:00 | 01:37:00
Rep L | 02:20:00 | 02:16:00 | 02:20:00 | 02:11:00 | 02:20:00 | 02:43:00
Rep M | 02:20:00 | 01:29:00 | 02:20:00 | 01:20:00 | 02:20:00 | 01:37:00
Rep N | 02:20:00 | 02:41:00 | 02:20:00 | 02:51:00 | 02:20:00 | 02:45:00
Rep O
Total | 02:20:00 | 02:03:00 | 02:20:00 | 02:06:52 | 02:20:00 | 02:16:47.143000