Spreadsheet: 289411d1389568279-need-to-structure-my-data-properly-but-out-of-ideas-data-set-example-ndv-v2
Sheet: Sheet1

 |  |  | YEAR 1 | YEAR 1 | YEAR 1 | YEAR 1 | YEAR 1 | YEAR 1 | YEAR 1 | YEAR 1 | YEAR 1 | YEAR 1 | YEAR 1 | YEAR 1 | YEAR 1 | YEAR 1 | YEAR 1 | YEAR 1 | YEAR 1 | YEAR 1 | YEAR 1 | YEAR 1 | YEAR 1 | YEAR 1 | YEAR 1 | YEAR 1 | YEAR 1 | YEAR 1 | YEAR 1 | YEAR 1 | YEAR 1 | YEAR 1 | YEAR 1 | YEAR 1 | YEAR 1 | YEAR 2 | YEAR 2 | YEAR 2 | YEAR 2 | YEAR 2 | YEAR 2 | YEAR 2 | YEAR 2 | YEAR 2 | YEAR 2 | YEAR 2 | YEAR 2 | YEAR 2 | YEAR 2 | YEAR 2 | YEAR 2 | YEAR 2 | YEAR 2 | YEAR 2 | YEAR 2 | YEAR 2 | YEAR 2 | YEAR 1 | YEAR 1 | YEAR 1 | YEAR 1 | YEAR 1 | YEAR 1 | YEAR 1 | YEAR 1 | YEAR 1 | YEAR 1 | YEAR 1 | YEAR 1 | YEAR 1 | YEAR 1 | YEAR 1 | YEAR 1 | YEAR 1 | YEAR 1 | YEAR 1 | YEAR 1 | YEAR 1 | YEAR 1 | YEAR 1 | YEAR 1 | YEAR 1 | YEAR 1 | YEAR 1 | YEAR 1 | YEAR 1 | YEAR 1 | YEAR 1 | YEAR 1 | YEAR 1
 |  |  | INITIAL INPUT | INITIAL INPUT | INITIAL INPUT | INITIAL INPUT | INITIAL INPUT | INITIAL INPUT | INITIAL INPUT | INITIAL INPUT | INITIAL INPUT | INITIAL INPUT | INITIAL INPUT | INITIAL INPUT | INITIAL INPUT | INITIAL INPUT | INITIAL INPUT | INITIAL INPUT | INITIAL INPUT | INITIAL INPUT | INITIAL INPUT | INITIAL INPUT | INITIAL INPUT | INITIAL INPUT | INITIAL INPUT | INITIAL INPUT | INITIAL INPUT | INITIAL INPUT | INITIAL INPUT | INITIAL INPUT | INITIAL INPUT | INITIAL INPUT | INITIAL INPUT | INITIAL INPUT | INITIAL INPUT | GROWTH INPUT | GROWTH INPUT | GROWTH INPUT | GROWTH INPUT | GROWTH INPUT | GROWTH INPUT | GROWTH INPUT | GROWTH INPUT | GROWTH INPUT | GROWTH INPUT | GROWTH INPUT | GROWTH INPUT | GROWTH INPUT | GROWTH INPUT | GROWTH INPUT | GROWTH INPUT | GROWTH INPUT | GROWTH INPUT | GROWTH INPUT | GROWTH INPUT | GROWTH INPUT | GROWTH INPUT | CALCULATED | CALCULATED | CALCULATED | CALCULATED | CALCULATED | CALCULATED | CALCULATED | CALCULATED | CALCULATED | CALCULATED | CALCULATED | CALCULATED | CALCULATED | CALCULATED | CALCULATED | CALCULATED | CALCULATED | CALCULATED | CALCULATED | CALCULATED | CALCULATED | CALCULATED | CALCULATED | CALCULATED | CALCULATED | CALCULATED | CALCULATED | CALCULATED | CALCULATED | CALCULATED | CALCULATED | CALCULATED | CALCULATED
 |  |  | Sales | Sales | Sales | Sales | Sales | Sales | Sales | Sales | Sales | Sales | Sales | Commision | Commision | Commision | Commision | Commision | Commision | Commision | Commision | Commision | Commision | Commision | Revenue | Revenue | Revenue | Revenue | Revenue | Revenue | Revenue | Revenue | Revenue | Revenue | Revenue | Sales | Sales | Sales | Sales | Sales | Sales | Sales | Sales | Sales | Sales | Sales | Commision | Commision | Commision | Commision | Commision | Commision | Commision | Commision | Commision | Commision | Commision | Sales | Sales | Sales | Sales | Sales | Sales | Sales | Sales | Sales | Sales | Sales | Commision | Commision | Commision | Commision | Commision | Commision | Commision | Commision | Commision | Commision | Commision | Revenue | Revenue | Revenue | Revenue | Revenue | Revenue | Revenue | Revenue | Revenue | Revenue | Revenue
Person | Region | Team | Month 1 | Month 2 | Month 3 | Month 4 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | Month 1 | Month 2 | Month 3 | Month 4 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | Month 1 | Month 2 | Month 3 | Month 4 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | Month 1 | Month 2 | Month 3 | Month 4 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | Month 1 | Month 2 | Month 3 | Month 4 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | Month 1 | Month 2 | Month 3 | Month 4 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | Month 1 | Month 2 | Month 3 | Month 4 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | Month 1 | Month 2 | Month 3 | Month 4 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12
A | London | Sales A | 49 | 1 | 9 | 49 | 93 | 11 | 59 | 14 | 20 | 15 | 59 | 0.05 | 0.03 | 0.05 | 0.1 | 0 | 0 | 0.01 | 0.09 | 0.08 | 0.02 | 0.04 |  |  |  |  |  |  |  |  |  |  |  | 49 | 1 | 9 | 49 | 93 | 11 | 59 | 14 | 20 | 15 | 59 | 0.04 | 0.1 | 0.04 | 0 | 0.1 | 0.02 | 0.04 | 0.01 | 0.1 | 0.01 | 0.03
B | London | Sales A | 61 | 24 | 65 | 78 | 10 | 94 | 74 | 66 | 3 | 47 | 18 | 0.03 | 0.08 | 0.04 | 0.02 | 0.07 | 0.05 | 0.06 | 0.05 | 0.01 | 0 | 0.01 |  |  |  |  |  |  |  |  |  |  |  | 61 | 24 | 65 | 78 | 10 | 94 | 74 | 66 | 3 | 47 | 18 | 0.08 | 0.09 | 0.07 | 0.05 | 0.1 | 0.05 | 0.07 | 0.09 | 0.07 | 0.06 | 0.04
C | Reading | Sales B | 16 | 9 | 85 | 95 | 60 | 60 | 18 | 7 | 21 | 84 | 63 | 0 | 0.09 | 0.02 | 0.06 | 0.03 | 0.07 | 0.06 | 0.1 | 0.09 | 0.05 | 0.06 |  |  |  |  |  |  |  |  |  |  |  | 16 | 9 | 85 | 95 | 60 | 60 | 18 | 7 | 21 | 84 | 63 | 0 | 0.03 | 0.01 | 0 | 0.05 | 0.09 | 0.04 | 0.03 | 0.01 | 0.03 | 0.02
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.09
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.03
Date | Region | Team | Person | Sales | Commission | Revenue |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.04
2010-01-01 00:00:00 | London | Sales A | A | 49 | 0.05 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.07
2010-01-01 00:00:00 | London | Sales A | B | 61 | 0.03 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.01
2010-01-01 00:00:00 | Reading | Sales B | C | 16 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
2010-02-01 00:00:00 | London | Sales A | A | 1 | 0.03 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.05
2010-02-01 00:00:00 | London | Sales A | B | 24 | 0.08 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
2010-02-01 00:00:00 | Reading | Sales B | C | 9 | 0.09
2010-03-01 00:00:00 | London | Sales A | A | 9 | 0.05
2010-03-01 00:00:00 | London | Sales A | B | 65 | 0.04
2010-03-01 00:00:00 | Reading | Sales B | C | 85 | 0.02 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.1
2010-04-01 00:00:00 | London | Sales A | A | 49 | 0.1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.1
2010-04-01 00:00:00 | London | Sales A | B | 78 | 0.02 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.05
2010-04-01 00:00:00 | Reading | Sales B | C | 95 | 0.06 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.02
2010-05-01 00:00:00 | London | Sales A | A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.05
2010-05-01 00:00:00 | London | Sales A | B |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.09
2010-05-01 00:00:00 | Reading | Sales B | C |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.04
2010-06-01 00:00:00 | London | Sales A | A | 93 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.07
2010-06-01 00:00:00 | London | Sales A | B | 10 | 0.07 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.04
2010-06-01 00:00:00 | Reading | Sales B | C | 60 | 0.03 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.01
2010-07-01 00:00:00 | London | Sales A | A | 11 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.09
2010-07-01 00:00:00 | London | Sales A | B | 94 | 0.05 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.03
2010-07-01 00:00:00 | Reading | Sales B | C | 60 | 0.07 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.1
2010-08-01 00:00:00 | London | Sales A | A | 59 | 0.01 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.07
2010-08-01 00:00:00 | London | Sales A | B | 74 | 0.06 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.01
2010-08-01 00:00:00 | Reading | Sales B | C | 18 | 0.06 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.01
2010-09-01 00:00:00 | London | Sales A | A | 14 | 0.09 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.06
2010-09-01 00:00:00 | London | Sales A | B | 66 | 0.05 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.03
2010-09-01 00:00:00 | Reading | Sales B | C | 7 | 0.1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.03
2010-10-01 00:00:00 | London | Sales A | A | 20 | 0.08 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.04
2010-10-01 00:00:00 | London | Sales A | B | 3 | 0.01 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.02
2010-10-01 00:00:00 | Reading | Sales B | C | 21 | 0.09
2010-11-01 00:00:00 | London | Sales A | A | 15 | 0.02
2010-11-01 00:00:00 | London | Sales A | B | 47 | 0
2010-11-01 00:00:00 | Reading | Sales B | C | 84 | 0.05
2010-12-01 00:00:00 | London | Sales A | A | 59 | 0.04
2010-12-01 00:00:00 | London | Sales A | B | 18 | 0.01
2010-12-01 00:00:00 | Reading | Sales B | C | 63 | 0.06
2011-01-01 00:00:00 | London | Sales A | A | 49 | 0.04
2011-01-01 00:00:00 | London | Sales A | B | 61 | 0.08
2011-01-01 00:00:00 | Reading | Sales B | C | 16 | 0
2011-02-01 00:00:00 | London | Sales A | A | 1 | 0.1
2011-02-01 00:00:00 | London | Sales A | B | 24 | 0.09
2011-02-01 00:00:00 | Reading | Sales B | C | 9 | 0.03
2011-03-01 00:00:00 | London | Sales A | A | 9 | 0.04
2011-03-01 00:00:00 | London | Sales A | B | 65 | 0.07
2011-03-01 00:00:00 | Reading | Sales B | C | 85 | 0.01
2011-04-01 00:00:00 | London | Sales A | A | 49 | 0
2011-04-01 00:00:00 | London | Sales A | B | 78 | 0.05
2011-04-01 00:00:00 | Reading | Sales B | C | 95 | 0
2011-05-01 00:00:00 | London | Sales A | A
2011-05-01 00:00:00 | London | Sales A | B
2011-05-01 00:00:00 | Reading | Sales B | C
2011-06-01 00:00:00 | London | Sales A | A | 93 | 0.1
2011-06-01 00:00:00 | London | Sales A | B | 10 | 0.1
2011-06-01 00:00:00 | Reading | Sales B | C | 60 | 0.05
2011-07-01 00:00:00 | London | Sales A | A | 11 | 0.02
2011-07-01 00:00:00 | London | Sales A | B | 94 | 0.05
2011-07-01 00:00:00 | Reading | Sales B | C | 60 | 0.09
2011-08-01 00:00:00 | London | Sales A | A | 59 | 0.04
2011-08-01 00:00:00 | London | Sales A | B | 74 | 0.07
2011-08-01 00:00:00 | Reading | Sales B | C | 18 | 0.04
2011-09-01 00:00:00 | London | Sales A | A | 14 | 0.01
2011-09-01 00:00:00 | London | Sales A | B | 66 | 0.09
2011-09-01 00:00:00 | Reading | Sales B | C | 7 | 0.03
2011-10-01 00:00:00 | London | Sales A | A | 20 | 0.1
2011-10-01 00:00:00 | London | Sales A | B | 3 | 0.07
2011-10-01 00:00:00 | Reading | Sales B | C | 21 | 0.01
2011-11-01 00:00:00 | London | Sales A | A | 15 | 0.01
2011-11-01 00:00:00 | London | Sales A | B | 47 | 0.06
2011-11-01 00:00:00 | Reading | Sales B | C | 84 | 0.03
2011-12-01 00:00:00 | London | Sales A | A | 59 | 0.03
2011-12-01 00:00:00 | London | Sales A | B | 18 | 0.04
2011-12-01 00:00:00 | Reading | Sales B | C | 63 | 0.02