Spreadsheet: 685671d1594136449-skip-to-next-row-if-logical-test-is-false-projectlist_test_v2
Sheet: Projectlist

PROJECT LIST
Project | Projectname | Est. Del. Time |  | Total order value | Probability | Estimated future order value | Sales Person
number |  | Quarter | Year | €
1 | Jobb1 | Q1 | 2020 | 20000 | 0.5 |  | SalesPerson1
2 | Jobb2 | Q2 | 2020 | 26000 | 0.7 |  | SalesPerson1
3 | Jobb3 | Q1 | 2020 | 230000 | 0.5 |  | SalesPerson1
5 | Jobb5 | Q1 | 2020 | 650000 | 0 |  | SalesPerson1
6 | Jobb6 | Q3 | 2020 | 80000 | 0.85 |  | SalesPerson1
7 | Jobb7 | Q2 | 2020 | 460000 | 0.5 |  | SalesPerson1
8 | Jobb8 | Q4 | 2020 | 640000 | 0.5 |  | SalesPerson1
9 | Jobb9 | Q3 | 2020 | 90000 | 0.5 |  | SalesPerson4
10 | Jobb10 | Q4 | 2020 | 180000 | 0.5 |  | SalesPerson1
11 | Jobb11 | Q3 | 2020 | 120000 | 0.5 |  | SalesPerson1
12 | Jobb12 | Q2 | 2020 | 360000 | 0.5 |  | SalesPerson1
13 | [NAME] | Q4 | 2020 | 27000 | 0.5 |  | SalesPerson1
15 | [NAME] | Q2 | 2020 | 49000 | 0.5 |  | SalesPerson3
16 | Jobb15 | Q2 | 2020 | 8800 | 0.5 |  | SalesPerson3
17 | Jobb16 | Q2 | 2020 | 55000 | 1 |  | SalesPerson3
18 | Jobb17 | Q3 | 2020 | 45000 | 1 |  | SalesPerson3
19 | Jobb18 | Q4 | 2020 | 110000 | 0.85 |  | SalesPerson1
20 | [NAME] | Q4 | 2020 | 100000 | 0.7 |  | SalesPerson1
21 | Jobb20 | Q4 | 2020 | 110000 | 0.7 |  | SalesPerson1
22 | Jobb21 | Q4 | 2020 | 73000 | 0.7 |  | SalesPerson1
23 | Jobb22 | Q4 | 2020 | 16000 | 0.7 |  | SalesPerson1
24 | Jobb23 | Q4 | 2020 | 129000 | 0.7 |  | SalesPerson3
25 | Jobb24 | Q2 | 2020 | 18310 | 0.7 |  | SalesPerson2
26 | Jobb25 | Q4 | 2020 | 67000 | 0.5 |  | SalesPerson3
27 | Jobb26 | Q1 | 2020 | 13500 | 0.5 |  | SalesPerson3
28 | Jobb27 | Q3 | 2020 | 6800 | 1 |  | SalesPerson3
29 | Jobb28 | Q3 | 2020 | 36000 | 0.85 |  | SalesPerson3
30 | Jobb29 | Q3 | 2020 | 31000 | 0.5 |  | SalesPerson3
31 | Jobb30 | Q2 | 2020 | 41642 | 0.5 |  | SalesPerson2
32 | [NAME] | Q2 | 2020 | 59174 | 0.5 |  | SalesPerson2
33 | Jobb32 | Q3 | 2020 | 33705 | 0.5 |  | SalesPerson2
34 | Jobb33 | Q3 | 2020 | 30526 | 0.5 |  | SalesPerson2
35 | Jobb34 | Q3 | 2020 | 14788 | 0.5 |  | SalesPerson2
36 | Jobb35 | Q1 | 2020 | 17493 | 0.85 |  | SalesPerson2
37 | Jobb36 | Q2 | 2020 | 13819 | 0.5 |  | SalesPerson2
38 | [NAME] | Q2 | 2020 | 70891 | 0.5 |  | SalesPerson2
39 | Jobb38 | Q2 | 2020 | 22981 | 0.5 |  | SalesPerson2
40 | Jobb39 | Q3 | 2020 | 12580 | 0.5 |  | SalesPerson2
41 | Jobb40 | Q2 | 2020 | 70000 | 0 |  | SalesPerson1
42 | Jobb41 | Q2 | 2020 | 180000 | 0.5 |  | SalesPerson1
43 | Jobb42 | Q2 | 2020 | 125000 | 0.7 |  | SalesPerson1
44 | Jobb43 | Q2 | 2020 | 135000 | 0.5 |  | SalesPerson1
45 | [NAME] | Q2 | 2020 | 20000 | 0.5 |  | SalesPerson1
46 | Jobb45 | Q2 | 2020 | 40000 | 0.5 |  | SalesPerson1
47 | [NAME] | Q2 | 2021 | 151000 | 0.5 |  | SalesPerson3
48 | Jobb47 | Q1 | 2020 | 15500 | 0.5 |  | SalesPerson3
49 | [NAME] | Q1 | 2020 | 30000 | 0.5 |  | SalesPerson3
50 | Jobb49 | Q3 | 2020 | 22000 | 0.5 |  | SalesPerson3
51 | Jobb50 | Q4 | 2020 | 29000 | 0.7 |  | SalesPerson3
52 | [NAME] | Q3 | 2020 | 24600 | 0.5 |  | SalesPerson3
53 | Jobb52 | Q2 | 2021 | 72600 | 0.5 |  | SalesPerson3
54 | [NAME] | Q4 | 2020 | 19800 | 0.5 |  | SalesPerson3
55 | Jobb54 | Q3 | 2020 | 10500 | 0.7 |  | SalesPerson3
56 | Jobb55 | Q4 | 2020 | 29200 | 0.7 |  | SalesPerson3
57 | Jobb56 | Q1 | 2020 | 32625 | 0.5 |  | SalesPerson2
58 | Jobb57 | Q1 | 2020 | 18831 | 0.7 |  | SalesPerson2
59 | Jobb58 | Q1 | 2020 | 11915 | 1 |  | SalesPerson2
60 | Jobb59 | Q2 | 2020 | 29575 | 1 |  | SalesPerson2
61 | Jobb60 | Q4 | 2020 | 69582 | 0.7 |  | SalesPerson2
62 | Jobb61 | Q3 | 2020 | 12649 | 0.5 |  | SalesPerson2
63 | [NAME] | Q3 | 2020 | 24018 | 0.5 |  | SalesPerson2
64 | Jobb63 | Q2 | 2020 | 43373 | 0.5 |  | SalesPerson2
65 | Jobb64 | Q3 | 2020 | 36224 | 1 |  | SalesPerson2
66 | Jobb65 | Q3 | 2020 | 30763 | 0.85 |  | SalesPerson2
67 | Jobb66 | Q4 | 2020 | 23594 | 0.5 |  | SalesPerson2
68 | Jobb67 | Q1 | 2020 | 6882 | 0.5 |  | SalesPerson2
69 | [NAME] | Q2 | 2020 | 24281 | 1 |  | SalesPerson2
70 | [NAME] | Q4 | 2020 | 45006 | 0.5 |  | SalesPerson2
71 | Jobb70 | Q1 | 2020 | 12791 | 0.5 |  | SalesPerson2
72 | Jobb71 | Q3 | 2020 | 107330 | 0.7 |  | SalesPerson2
73 | [NAME] | Q2 | 2020 | 32376 | 0.5 |  | SalesPerson2
74 | [NAME] | Q2 | 2020 | 40000 | 0.5 |  | SalesPerson4
75 | [NAME] | Q1 | 2021 | 25800 | 0.5 |  | SalesPerson4
76 | Jobb75 | Q1 | 2021 | 15200 | 0.5 |  | SalesPerson4
77 | [NAME] | Q1 | 2021 | 108000 | 1 |  | SalesPerson2
78 | [NAME] | Q2 | 2020 | 40000 | 0.5 |  | SalesPerson4
79 | Jobb78 | Q2 | 2020 | 9620 | 0.5 |  | SalesPerson2
80 | Jobb79 | Q3 | 2020 | 19198 | 0.5 |  | SalesPerson2
81 | Jobb80 | Q3 | 2020 | 32636 | 0.5 |  | SalesPerson2
82 | Jobb81 | Q3 | 2020 | 25885 | 0.5 |  | SalesPerson2
83 | Jobb82 | Q1 | 2021 | 28842 | 0.7 |  | SalesPerson2
84 | Jobb83 | Q2 | 2020 | 50825 | 0.7 |  | SalesPerson3
85 | Jobb84 | Q4 | 2020 | 33000 | 0.85 |  | SalesPerson3
86 | Jobb85 | Q3 | 2020 | 35000 | 0.5 |  | SalesPerson3
87 | [NAME] | Q4 | 2020 | 61000 | 0.5 |  | SalesPerson3
88 | [NAME] | Q4 | 2020 | 40000 | 0.7 |  | SalesPerson3
89 | Jobb88 | Q4 | 2020 | 19900 | 0.5 |  | SalesPerson3
90 | Jobb89 | Q1 | 2021 | 21380 | 0.5 |  | SalesPerson3
95 | [NAME] | Q1 | 2021 | 66667 | 0.5 |  | SalesPerson2
END