Spreadsheet: 865871d1712842230-calculate-percentage-of-each-client-separately-book1
Sheet: Sheet1

CO Area | Company Code | Cycle | Text | Starting date | Ending date | Segment | Sender % | Client | Cost Element From | Cost Element To | WBS Element | Receiver % | %
1000 | 1000 | Z0123R | Text | 01.01.2023 | 31.01.2023 | Z0123RAGA | 100,00 | AGA | 410000 | 443333 | 900655 | 9.09 |  |  |  |  |  | WBS Element | Receiver % | of Client total
1000 | 1000 | Z0123R | Text | 01.01.2023 | 31.01.2023 | Z0123RAGA | 100,00 | AGA | 410000 | 443333 | 920610 | 9.09 |  |  |  |  | AGA | 900655 | 9.09 | 0.7575
1000 | 1000 | Z0123R | Text | 01.01.2023 | 31.01.2023 | Z0123RAGA | 100,00 | AGA | 410000 | 443333 | 202711 | 13.64 |  |  |  |  | AGA | 920610 | 29.55 | 2.462499999999999
1000 | 1000 | Z0123R | Text | 01.01.2023 | 31.01.2023 | Z0123RAGA | 100,00 | AGA | 410000 | 443333 | 900684 | 22.72 |  |  |  |  | AGA | 202711 | 13.64 | 1.136666666666667
1000 | 1000 | Z0123R | Text | 01.01.2023 | 31.01.2023 | Z0123RAGA | 100,00 | AGA | 410000 | 443333 | 200744 | 22.73 |  |  |  |  | AGA | 900684 | 264.2699999999999 | 22.02249999999999
1000 | 1000 | Z0123R | Text | 01.01.2023 | 31.01.2023 | Z0123RAGA | 100,00 | AGA | 410000 | 443333 | 210009 | 22.73 |  |  |  |  | AGA | 200744 | 33.47 | 2.789166666666667
1000 | 1000 | Z0223R | Text | 01.02.2023 | 28.02.2023 | Z0223RAGA | 100,00 | AGA | 410000 | 443333 | 200744 | 10.74 |  |  |  |  | AGA | 210009 | 225.87 | 18.8225
1000 | 1000 | Z0223R | Text | 01.02.2023 | 28.02.2023 | Z0223RAGA | 100,00 | AGA | 410000 | 443333 | 920610 | 16.11 |  |  |  |  | AGA | 900673 | 213.3 | 17.775
1000 | 1000 | Z0223R | Text | 01.02.2023 | 28.02.2023 | Z0223RAGA | 100,00 | AGA | 410000 | 443333 | 900673 | 21.48 |  |  |  |  | AGA | 920678 | 60.34 | 5.028333333333333
1000 | 1000 | Z0223R | Text | 01.02.2023 | 28.02.2023 | Z0223RAGA | 100,00 | AGA | 410000 | 443333 | 900684 | 24.83 |  |  |  |  | AGA | 920651 | 118.19 | 9.849166666666667
1000 | 1000 | Z0223R | Text | 01.02.2023 | 28.02.2023 | Z0223RAGA | 100,00 | AGA | 410000 | 443333 | 210009 | 26.84 |  |  |  |  | AGA | 920676 | 80.25 | 6.6875
1000 | 1000 | [NAME] | Text | 01.03.2023 | 31.03.2023 | Z0323RAGA | 100,00 | AGA | 410000 | 443333 | 920610 | 4.35 |  |  |  |  | AGA | 920693 | 152.03 | 12.66916666666667
1000 | 1000 | [NAME] | Text | 01.03.2023 | 31.03.2023 | Z0323RAGA | 100,00 | AGA | 410000 | 443333 | 920678 | 17.39 |  |  |  |  | IKI | 930010K | 50.27 | 4.189166666666667
1000 | 1000 | [NAME] | Text | 01.03.2023 | 31.03.2023 | Z0323RAGA | 100,00 | AGA | 410000 | 443333 | 210009 | 21.74 |  |  |  |  | IKI | 930022K | 111.36 | 9.280000000000001
1000 | 1000 | [NAME] | Text | 01.03.2023 | 31.03.2023 | Z0323RAGA | 100,00 | AGA | 410000 | 443333 | 900673 | 26.09 |  |  |  |  | IKI | XYLD01 | 1038.37 | 86.53083333333332
1000 | 1000 | [NAME] | Text | 01.03.2023 | 31.03.2023 | Z0323RAGA | 100,00 | AGA | 410000 | 443333 | 900684 | 30.43
1000 | 1000 | [NAME] | Text | 01.04.2023 | 30.04.2023 | Z0423RAGA | 100,00 | AGA | 410000 | 443333 | 210009 | 5.26
1000 | 1000 | [NAME] | Text | 01.04.2023 | 30.04.2023 | Z0423RAGA | 100,00 | AGA | 410000 | 443333 | 920651 | 10.53
1000 | 1000 | [NAME] | Text | 01.04.2023 | 30.04.2023 | Z0423RAGA | 100,00 | AGA | 410000 | 443333 | 920678 | 10.53
1000 | 1000 | [NAME] | Text | 01.04.2023 | 30.04.2023 | Z0423RAGA | 100,00 | AGA | 410000 | 443333 | 920676 | 15.79
1000 | 1000 | [NAME] | Text | 01.04.2023 | 30.04.2023 | Z0423RAGA | 100,00 | AGA | 410000 | 443333 | 920693 | 15.79
1000 | 1000 | [NAME] | Text | 01.04.2023 | 30.04.2023 | Z0423RAGA | 100,00 | AGA | 410000 | 443333 | 900673 | 21.05
1000 | 1000 | [NAME] | Text | 01.04.2023 | 30.04.2023 | Z0423RAGA | 100,00 | AGA | 410000 | 443333 | 900684 | 21.05
1000 | 1000 | [NAME] | Text | 01.05.2023 | 31.05.2023 | Z0523RAGA | 100,00 | AGA | 410000 | 443333 | 210009 | 13.64
1000 | 1000 | [NAME] | Text | 01.05.2023 | 31.05.2023 | Z0523RAGA | 100,00 | AGA | 410000 | 443333 | 900673 | 13.64
1000 | 1000 | [NAME] | Text | 01.05.2023 | 31.05.2023 | Z0523RAGA | 100,00 | AGA | 410000 | 443333 | 920651 | 13.64
1000 | 1000 | [NAME] | Text | 01.05.2023 | 31.05.2023 | Z0523RAGA | 100,00 | AGA | 410000 | 443333 | 900684 | 18.18
1000 | 1000 | [NAME] | Text | 01.05.2023 | 31.05.2023 | Z0523RAGA | 100,00 | AGA | 410000 | 443333 | 920676 | 18.18
1000 | 1000 | [NAME] | Text | 01.05.2023 | 31.05.2023 | Z0523RAGA | 100,00 | AGA | 410000 | 443333 | 920678 | 22.72
1000 | 1000 | Z0623R | Text | 01.06.2023 | 30.06.2023 | Z0623RAGA | 100,00 | AGA | 410000 | 443333 | 920651 | 9.7
1000 | 1000 | Z0623R | Text | 01.06.2023 | 30.06.2023 | Z0623RAGA | 100,00 | AGA | 410000 | 443333 | 920678 | 9.7
1000 | 1000 | Z0623R | Text | 01.06.2023 | 30.06.2023 | Z0623RAGA | 100,00 | AGA | 410000 | 443333 | 210009 | 17.58
1000 | 1000 | Z0623R | Text | 01.06.2023 | 30.06.2023 | Z0623RAGA | 100,00 | AGA | 410000 | 443333 | 900684 | 19.39
1000 | 1000 | Z0623R | Text | 01.06.2023 | 30.06.2023 | Z0623RAGA | 100,00 | AGA | 410000 | 443333 | 920676 | 19.39
1000 | 1000 | Z0623R | Text | 01.06.2023 | 30.06.2023 | Z0623RAGA | 100,00 | AGA | 410000 | 443333 | 900673 | 24.24
1000 | 1000 | [NAME] | Text | 01.07.2023 | 31.07.2023 | Z0723RAGA | 100,00 | AGA | 410000 | 443333 | 210009 | 50
1000 | 1000 | [NAME] | Text | 01.07.2023 | 31.07.2023 | Z0723RAGA | 100,00 | AGA | 410000 | 443333 | 900684 | 50
1000 | 1000 | Z0823R | Text | 01.08.2023 | 31.08.2023 | [NAME] | 100,00 | AGA | 410000 | 443333 | 920676 | 8.7
1000 | 1000 | Z0823R | Text | 01.08.2023 | 31.08.2023 | [NAME] | 100,00 | AGA | 410000 | 443333 | 920651 | 17.39
1000 | 1000 | Z0823R | Text | 01.08.2023 | 31.08.2023 | [NAME] | 100,00 | AGA | 410000 | 443333 | 900673 | 21.74
1000 | 1000 | Z0823R | Text | 01.08.2023 | 31.08.2023 | [NAME] | 100,00 | AGA | 410000 | 443333 | 900684 | 26.08
1000 | 1000 | Z0823R | Text | 01.08.2023 | 31.08.2023 | [NAME] | 100,00 | AGA | 410000 | 443333 | 210009 | 26.09
1000 | 1000 | Z0923R | Text | 01.09.2023 | 30.09.2023 | Z0923RAGA | 100,00 | AGA | 410000 | 443333 | 920651 | 9.52
1000 | 1000 | Z0923R | Text | 01.09.2023 | 30.09.2023 | Z0923RAGA | 100,00 | AGA | 410000 | 443333 | 900684 | 19.05
1000 | 1000 | Z0923R | Text | 01.09.2023 | 30.09.2023 | Z0923RAGA | 100,00 | AGA | 410000 | 443333 | 210009 | 23.81
1000 | 1000 | Z0923R | Text | 01.09.2023 | 30.09.2023 | Z0923RAGA | 100,00 | AGA | 410000 | 443333 | 900673 | 23.81
1000 | 1000 | Z0923R | Text | 01.09.2023 | 30.09.2023 | Z0923RAGA | 100,00 | AGA | 410000 | 443333 | 920693 | 23.81
1000 | 1000 | Z1023R | Text | 01.10.2023 | 31.10.2023 | Z1023RAGA | 100,00 | AGA | 410000 | 443333 | 920676 | 4.55
1000 | 1000 | Z1023R | Text | 01.10.2023 | 31.10.2023 | Z1023RAGA | 100,00 | AGA | 410000 | 443333 | 920651 | 9.09
1000 | 1000 | Z1023R | Text | 01.10.2023 | 31.10.2023 | Z1023RAGA | 100,00 | AGA | 410000 | 443333 | 210009 | 18.18
1000 | 1000 | Z1023R | Text | 01.10.2023 | 31.10.2023 | Z1023RAGA | 100,00 | AGA | 410000 | 443333 | 920693 | 22.72
1000 | 1000 | Z1023R | Text | 01.10.2023 | 31.10.2023 | Z1023RAGA | 100,00 | AGA | 410000 | 443333 | 900673 | 22.73
1000 | 1000 | Z1023R | Text | 01.10.2023 | 31.10.2023 | Z1023RAGA | 100,00 | AGA | 410000 | 443333 | 900684 | 22.73
1000 | 1000 | [NAME] | Text | 01.11.2023 | 30.11.2023 | [NAME] | 100,00 | AGA | 410000 | 443333 | 900684 | 4.55
1000 | 1000 | [NAME] | Text | 01.11.2023 | 30.11.2023 | [NAME] | 100,00 | AGA | 410000 | 443333 | 920676 | 13.64
1000 | 1000 | [NAME] | Text | 01.11.2023 | 30.11.2023 | [NAME] | 100,00 | AGA | 410000 | 443333 | 900673 | 22.73
1000 | 1000 | [NAME] | Text | 01.11.2023 | 30.11.2023 | [NAME] | 100,00 | AGA | 410000 | 443333 | 920651 | 27.27
1000 | 1000 | [NAME] | Text | 01.11.2023 | 30.11.2023 | [NAME] | 100,00 | AGA | 410000 | 443333 | 920693 | 31.81
1000 | 1000 | Z1223R | Text | 01.12.2023 | 31.12.2023 | Z1223RAGA | 100,00 | AGA | 410000 | 443333 | 900684 | 5.26
1000 | 1000 | Z1223R | Text | 01.12.2023 | 31.12.2023 | Z1223RAGA | 100,00 | AGA | 410000 | 443333 | 900673 | 15.79
1000 | 1000 | Z1223R | Text | 01.12.2023 | 31.12.2023 | Z1223RAGA | 100,00 | AGA | 410000 | 443333 | 920651 | 21.05
1000 | 1000 | Z1223R | Text | 01.12.2023 | 31.12.2023 | Z1223RAGA | 100,00 | AGA | 410000 | 443333 | 920693 | 57.9
1000 | 1000 | Z0123R | Text | 01.01.2023 | 31.01.2023 | Z0123RIKI | 100,00 | IKI | 410000 | 443333 | 930010K | 4.55 |  |  |  |  |  |  | Unique = client IKI
1000 | 1000 | Z0123R | Text | 01.01.2023 | 31.01.2023 | Z0123RIKI | 100,00 | IKI | 410000 | 443333 | 930022K | 9.09
1000 | 1000 | Z0123R | Text | 01.01.2023 | 31.01.2023 | Z0123RIKI | 100,00 | IKI | 410000 | 443333 | XYLD01 | 86.36 |  |  |  |  |  |  | 930022K
1000 | 1000 | Z0223R | Text | 01.02.2023 | 28.02.2023 | Z0223RIKI | 100,00 | IKI | 410000 | 443333 | 930010K | 10.74 |  |  |  |  |  |  | XYLD01
1000 | 1000 | Z0223R | Text | 01.02.2023 | 28.02.2023 | Z0223RIKI | 100,00 | IKI | 410000 | 443333 | 930022K | 10.74
1000 | 1000 | Z0223R | Text | 01.02.2023 | 28.02.2023 | Z0223RIKI | 100,00 | IKI | 410000 | 443333 | XYLD01 | 78.52
1000 | 1000 | [NAME] | Text | 01.03.2023 | 31.03.2023 | Z0323RIKI | 100,00 | IKI | 410000 | 443333 | 930010K | 4.35
1000 | 1000 | [NAME] | Text | 01.03.2023 | 31.03.2023 | Z0323RIKI | 100,00 | IKI | 410000 | 443333 | 930022K | 8.7
1000 | 1000 | [NAME] | Text | 01.03.2023 | 31.03.2023 | Z0323RIKI | 100,00 | IKI | 410000 | 443333 | XYLD01 | 86.95
1000 | 1000 | [NAME] | Text | 01.04.2023 | 30.04.2023 | Z0423RIKI | 100,00 | IKI | 410000 | 443333 | 930022K | 12.5
1000 | 1000 | [NAME] | Text | 01.04.2023 | 30.04.2023 | Z0423RIKI | 100,00 | IKI | 410000 | 443333 | XYLD01 | 87.5
1000 | 1000 | [NAME] | Text | 01.05.2023 | 31.05.2023 | Z0523RIKI | 100,00 | IKI | 410000 | 443333 | 930010K | 4.55
1000 | 1000 | [NAME] | Text | 01.05.2023 | 31.05.2023 | Z0523RIKI | 100,00 | IKI | 410000 | 443333 | 930022K | 13.64
1000 | 1000 | [NAME] | Text | 01.05.2023 | 31.05.2023 | Z0523RIKI | 100,00 | IKI | 410000 | 443333 | XYLD01 | 81.81
1000 | 1000 | Z0623R | Text | 01.06.2023 | 30.06.2023 | Z0623RIKI | 100,00 | IKI | 410000 | 443333 | 930022K | 19.39
1000 | 1000 | Z0623R | Text | 01.06.2023 | 30.06.2023 | Z0623RIKI | 100,00 | IKI | 410000 | 443333 | XYLD01 | 80.61
1000 | 1000 | [NAME] | Text | 01.07.2023 | 31.07.2023 | Z0723RIKI | 100,00 | IKI | 410000 | 443333 | 930022K | 6.67
1000 | 1000 | [NAME] | Text | 01.07.2023 | 31.07.2023 | Z0723RIKI | 100,00 | IKI | 410000 | 443333 | XYLD01 | 93.33
1000 | 1000 | Z0823R | Text | 01.08.2023 | 31.08.2023 | Z0823RIKI | 100,00 | IKI | 410000 | 443333 | 930010K | 6.67
1000 | 1000 | Z0823R | Text | 01.08.2023 | 31.08.2023 | Z0823RIKI | 100,00 | IKI | 410000 | 443333 | 930022K | 6.67
1000 | 1000 | Z0823R | Text | 01.08.2023 | 31.08.2023 | Z0823RIKI | 100,00 | IKI | 410000 | 443333 | XYLD01 | 86.66
1000 | 1000 | Z0923R | Text | 01.09.2023 | 30.09.2023 | Z0923RIKI | 100,00 | IKI | 410000 | 443333 | 930010K | 4.76
1000 | 1000 | Z0923R | Text | 01.09.2023 | 30.09.2023 | Z0923RIKI | 100,00 | IKI | 410000 | 443333 | 930022K | 4.76
1000 | 1000 | Z0923R | Text | 01.09.2023 | 30.09.2023 | Z0923RIKI | 100,00 | IKI | 410000 | 443333 | XYLD01 | 90.48
1000 | 1000 | Z1023R | Text | 01.10.2023 | 31.10.2023 | Z1023RIKI | 100,00 | IKI | 410000 | 443333 | XYLD01 | 100
1000 | 1000 | [NAME] | Text | 01.11.2023 | 30.11.2023 | Z1123RIKI | 100,00 | IKI | 410000 | 443333 | 930010K | 9.09
1000 | 1000 | [NAME] | Text | 01.11.2023 | 30.11.2023 | Z1123RIKI | 100,00 | IKI | 410000 | 443333 | 930022K | 13.64
1000 | 1000 | [NAME] | Text | 01.11.2023 | 30.11.2023 | Z1123RIKI | 100,00 | IKI | 410000 | 443333 | XYLD01 | 77.27
1000 | 1000 | Z1223R | Text | 01.12.2023 | 31.12.2023 | Z1223RIKI | 100,00 | IKI | 410000 | 443333 | 930010K | 5.56
1000 | 1000 | Z1223R | Text | 01.12.2023 | 31.12.2023 | Z1223RIKI | 100,00 | IKI | 410000 | 443333 | 930022K | 5.56
1000 | 1000 | Z1223R | Text | 01.12.2023 | 31.12.2023 | Z1223RIKI | 100,00 | IKI | 410000 | 443333 | XYLD01 | 88.88