ABCDEFGHIJKLMNOPQRSTUVWXYZAAABAC
1
2
3
1 2 3 4 5 6 7 8 9 10 11 12
4
=2/7 =5/8 =8/7=7*9*10*11
5
OKNot OKOKNot OKShould beShould be
To be calculated
To be calculated
To be calculated
6
Sender CC_AccountAttributeMeasure CCSum of Actual YTDMeasure CC1Measure CC2Account
Account Description_
Sender CC_Receiver PC_AttributeMeasure CCMeasure CC1Measure CC2Measure PCMeasure PC1Measure PC2Measure CC2Measure PC2 CC PC Alloc
7
1060070300
Communications
001.20252,10%58658627.917Communications891222810600703005311010119001.20250,35%586168.581-0,53%-101.88727.917746,822,10%-1,35%2,68%- 0,21
8
1060070300
Other Operating Cost
001.20258,37%2.3362.33627.917Communications891222810600703005311110125001.20250,35%586168.58135,23%6651.88727.917746,822,10%89,04%2,68% 13,96
9
1060070300Personnel Cost001.202532,05%8.9478.94727.917Communications891222811100801005311010119001.20250,03%46168.5811.887140.6651.1410,03%0,00%0,81% -
10
1060070300Site Cost001.202513,04%3.6413.64127.917Communications891222811100801005311110125001.20250,03%46168.5811.887140.6651.1410,03%0,00%0,81% -
11
1060070300
Specific Invoice Recharges and Service Fees
001.202544,44%12.40612.40627.917Communications891293910600703005311010119001.20250,35%586168.5811.88727.917746,822,10%0,00%2,68% -
12
1060070300 Total
100,00%27.91727.91727.917Communications891293910600703005311110125001.20250,35%586168.5811.88727.917746,822,10%0,00%2,68% -
13
1110080100
Communications
001.20250,03%4646140.665Communications891293911100801005311010119001.20250,03%46168.5811.887140.6651.1410,03%0,00%0,81% -
14
1110080100
Legal and Professional
001.202575,18%105.750105.750140.665Communications891293911100801005311110125001.20250,03%46168.5811.887140.6651.1410,03%0,00%0,81% -
15
1110080100
Other Operating Cost
001.20254,90%6.8896.889140.665Communications893125810600703005311010119001.20250,35%586168.5811.88727.917746,822,10%0,00%2,68% -
16
1110080100Personnel Cost001.202515,80%22.21922.219140.665Communications893125810600703005311110125001.20250,35%586168.5811.88727.917746,822,10%0,00%2,68% -
17
1110080100Site Cost001.20250,21%290290140.665Communications893125811100801005311010119001.20250,03%46168.581-0,93%-181.887140.6651.1410,03%-1,54%0,81%- 0,01
18
1110080100
Travel and Entertainment
001.20253,89%5.4715.471140.665Communications893125811100801005311110125001.20250,03%46168.58161,36%1.1581.887140.6651.1410,03%101,54%0,81% 0,38
19
1110080100 Total
100,00%140.665140.665140.665Communications(blank)10600703005311010119001.20250,35%586168.581-0,08%-11.88727.917746,822,10%-0,19%2,68%- 0,03
20
Grand Total100,00%168.581168.581168.581Communications(blank)10600703005311110125001.20250,35%586168.5814,95%931.88727.917746,822,10%12,50%2,68% 1,96
21
Communications(blank)11100801005311010119001.20250,03%46168.5811.887140.6651.1410,03%0,00%0,81% -
22
Receiver PC_Sender CC_
Account Description_
AttributeMeasure PC
Sum of Amount
Measure PC1Measure PC2Communications(blank)11100801005311110125001.20250,03%46168.5811.887140.6651.1410,03%0,00%0,81% -
23
531101011910600703008912228001.2025-1,35%-10,09-10747Legal and Professional891222810600703005311010119001.2025168.581-0,53%-101.88727.917746,820,00%-1,35%2,68% -
24
531101011910600703008912839001.2025-0,19%-1,42-1747Legal and Professional891222810600703005311110125001.2025168.58135,23%6651.88727.917746,820,00%89,04%2,68% -
25
531101011911100801008931258001.2025-1,54%-17,57-181.141Legal and Professional891222811100801005311010119001.202562,73%105.750168.5811.887140.6651.14175,18%0,00%0,81% -
26
5311010119 Total
-1,54%-29,08-291.887Legal and Professional891222811100801005311110125001.202562,73%105.750168.5811.887140.6651.14175,18%0,00%0,81% -
27
531111012510600703008912228001.202589,04%664,95665747Legal and Professional891293910600703005311010119001.2025168.5811.88727.917746,820,00%0,00%2,68% -
28
531111012510600703008912839001.202512,50%93,3893747Legal and Professional891293910600703005311110125001.2025168.5811.88727.917746,820,00%0,00%2,68% -
29
531111012511100801008931258001.2025101,54%1158,221.1581.141Legal and Professional891293911100801005311010119001.202562,73%105.750168.5811.887140.6651.14175,18%0,00%0,81% -
30
5311110125 Total
101,54%1916,551.9171.887Legal and Professional891293911100801005311110125001.202562,73%105.750168.5811.887140.6651.14175,18%0,00%0,81% -
31
Grand Total100,00%1887,471.8871.887Legal and Professional893125810600703005311010119001.2025168.5811.88727.917746,820,00%0,00%2,68% -
32
Legal and Professional893125810600703005311110125001.2025168.5811.88727.917746,820,00%0,00%2,68% -
33
Legal and Professional893125811100801005311010119001.202562,73%105.750168.581-0,93%-181.887140.6651.14175,18%-1,54%0,81%- 13,21
34
Legal and Professional893125811100801005311110125001.202562,73%105.750168.58161,36%1.1581.887140.6651.14175,18%101,54%0,81% 870,73
35
Legal and Professional(blank)10600703005311010119001.2025168.581-0,08%-11.88727.917746,820,00%-0,19%2,68% -
36
Legal and Professional(blank)10600703005311110125001.2025168.5814,95%931.88727.917746,820,00%12,50%2,68% -
37
Legal and Professional(blank)11100801005311010119001.202562,73%105.750168.5811.887140.6651.14175,18%0,00%0,81% -
38
Legal and Professional(blank)11100801005311110125001.202562,73%105.750168.5811.887140.6651.14175,18%0,00%0,81% -
39
Other Operating Cost891222810600703005311010119001.20251,39%2.336168.581-0,53%-101.88727.917746,828,37%-1,35%2,68%- 0,84
40
Other Operating Cost891222810600703005311110125001.20251,39%2.336168.58135,23%6651.88727.917746,828,37%89,04%2,68% 55,64
41
Other Operating Cost891222811100801005311010119001.20254,09%6.889168.5811.887140.6651.1414,90%0,00%0,81% -
42
Other Operating Cost891222811100801005311110125001.20254,09%6.889168.5811.887140.6651.1414,90%0,00%0,81% -
43
Other Operating Cost891293910600703005311010119001.20251,39%2.336168.5811.88727.917746,828,37%0,00%2,68% -
44
Other Operating Cost891293910600703005311110125001.20251,39%2.336168.5811.88727.917746,828,37%0,00%2,68% -
45
Other Operating Cost891293911100801005311010119001.20254,09%6.889168.5811.887140.6651.1414,90%0,00%0,81% -
46
Other Operating Cost891293911100801005311110125001.20254,09%6.889168.5811.887140.6651.1414,90%0,00%0,81% -
47
Other Operating Cost893125810600703005311010119001.20251,39%2.336168.5811.88727.917746,828,37%0,00%2,68% -
48
Other Operating Cost893125810600703005311110125001.20251,39%2.336168.5811.88727.917746,828,37%0,00%2,68% -
49
Other Operating Cost893125811100801005311010119001.20254,09%6.889168.581-0,93%-181.887140.6651.1414,90%-1,54%0,81%- 0,86
50
Other Operating Cost893125811100801005311110125001.20254,09%6.889168.58161,36%1.1581.887140.6651.1414,90%101,54%0,81% 56,72
51
Other Operating Cost(blank)10600703005311010119001.20251,39%2.336168.581-0,08%-11.88727.917746,828,37%-0,19%2,68%- 0,12
52
Other Operating Cost(blank)10600703005311110125001.20251,39%2.336168.5814,95%931.88727.917746,828,37%12,50%2,68% 7,81
53
Other Operating Cost(blank)11100801005311010119001.20254,09%6.889168.5811.887140.6651.1414,90%0,00%0,81% -
54
Other Operating Cost(blank)11100801005311110125001.20254,09%6.889168.5811.887140.6651.1414,90%0,00%0,81% -
55
Personnel Cost891222810600703005311010119001.20255,31%8.947168.581-0,53%-101.88727.917746,8232,05%-1,35%2,68%- 3,23
56
Personnel Cost891222810600703005311110125001.20255,31%8.947168.58135,23%6651.88727.917746,8232,05%89,04%2,68% 213,11
57
Personnel Cost891222811100801005311010119001.202513,18%22.219168.5811.887140.6651.14115,80%0,00%0,81% -
58
Personnel Cost891222811100801005311110125001.202513,18%22.219168.5811.887140.6651.14115,80%0,00%0,81% -
59
Personnel Cost891293910600703005311010119001.20255,31%8.947168.5811.88727.917746,8232,05%0,00%2,68% -
60
Personnel Cost891293910600703005311110125001.20255,31%8.947168.5811.88727.917746,8232,05%0,00%2,68% -
61
Personnel Cost891293911100801005311010119001.202513,18%22.219168.5811.887140.6651.14115,80%0,00%0,81% -
62
Personnel Cost891293911100801005311110125001.202513,18%22.219168.5811.887140.6651.14115,80%0,00%0,81% -
63
Personnel Cost893125810600703005311010119001.20255,31%8.947168.5811.88727.917746,8232,05%0,00%2,68% -
64
Personnel Cost893125810600703005311110125001.20255,31%8.947168.5811.88727.917746,8232,05%0,00%2,68% -
65
Personnel Cost893125811100801005311010119001.202513,18%22.219168.581-0,93%-181.887140.6651.14115,80%-1,54%0,81%- 2,78
66
Personnel Cost893125811100801005311110125001.202513,18%22.219168.58161,36%1.1581.887140.6651.14115,80%101,54%0,81% 182,95
67
Personnel Cost(blank)10600703005311010119001.20255,31%8.947168.581-0,08%-11.88727.917746,8232,05%-0,19%2,68%- 0,46
68
Personnel Cost(blank)10600703005311110125001.20255,31%8.947168.5814,95%931.88727.917746,8232,05%12,50%2,68% 29,93
69
Personnel Cost(blank)11100801005311010119001.202513,18%22.219168.5811.887140.6651.14115,80%0,00%0,81% -
70
Personnel Cost(blank)11100801005311110125001.202513,18%22.219168.5811.887140.6651.14115,80%0,00%0,81% -
71
Site Cost891222810600703005311010119001.20252,16%3.641168.581-0,53%-101.88727.917746,8213,04%-1,35%2,68%- 1,32
72
Site Cost891222810600703005311110125001.20252,16%3.641168.58135,23%6651.88727.917746,8213,04%89,04%2,68% 86,73
73
Site Cost891222811100801005311010119001.20250,17%290168.5811.887140.6651.1410,21%0,00%0,81% -
74
Site Cost891222811100801005311110125001.20250,17%290168.5811.887140.6651.1410,21%0,00%0,81% -
75
Site Cost891293910600703005311010119001.20252,16%3.641168.5811.88727.917746,8213,04%0,00%2,68% -
76
Site Cost891293910600703005311110125001.20252,16%3.641168.5811.88727.917746,8213,04%0,00%2,68% -
77
Site Cost891293911100801005311010119001.20250,17%290168.5811.887140.6651.1410,21%0,00%0,81% -
78
Site Cost891293911100801005311110125001.20250,17%290168.5811.887140.6651.1410,21%0,00%0,81% -
79
Site Cost893125810600703005311010119001.20252,16%3.641168.5811.88727.917746,8213,04%0,00%2,68% -
80
Site Cost893125810600703005311110125001.20252,16%3.641168.5811.88727.917746,8213,04%0,00%2,68% -
81
Site Cost893125811100801005311010119001.20250,17%290168.581-0,93%-181.887140.6651.1410,21%-1,54%0,81%- 0,04
82
Site Cost893125811100801005311110125001.20250,17%290168.58161,36%1.1581.887140.6651.1410,21%101,54%0,81% 2,39
83
Site Cost(blank)10600703005311010119001.20252,16%3.641168.581-0,08%-11.88727.917746,8213,04%-0,19%2,68%- 0,19
84
Site Cost(blank)10600703005311110125001.20252,16%3.641168.5814,95%931.88727.917746,8213,04%12,50%2,68% 12,18
85
Site Cost(blank)11100801005311010119001.20250,17%290168.5811.887140.6651.1410,21%0,00%0,81% -
86
Site Cost(blank)11100801005311110125001.20250,17%290168.5811.887140.6651.1410,21%0,00%0,81% -
87
Specific Invoice Recharges and Service Fees
891222810600703005311010119001.20257,36%12.406168.581-0,53%-101.88727.917746,8244,44%-1,35%2,68%- 4,48
88
Specific Invoice Recharges and Service Fees
891222810600703005311110125001.20257,36%12.406168.58135,23%6651.88727.917746,8244,44%89,04%2,68% 295,51
89
Specific Invoice Recharges and Service Fees
891222811100801005311010119001.2025168.5811.887140.6651.1410,00%0,00%0,81% -
90
Specific Invoice Recharges and Service Fees
891222811100801005311110125001.2025168.5811.887140.6651.1410,00%0,00%0,81% -
91
Specific Invoice Recharges and Service Fees
891293910600703005311010119001.20257,36%12.406168.5811.88727.917746,8244,44%0,00%2,68% -
92
Specific Invoice Recharges and Service Fees
891293910600703005311110125001.20257,36%12.406168.5811.88727.917746,8244,44%0,00%2,68% -
93
Specific Invoice Recharges and Service Fees
891293911100801005311010119001.2025168.5811.887140.6651.1410,00%0,00%0,81% -
94
Specific Invoice Recharges and Service Fees
891293911100801005311110125001.2025168.5811.887140.6651.1410,00%0,00%0,81% -
95
Specific Invoice Recharges and Service Fees
893125810600703005311010119001.20257,36%12.406168.5811.88727.917746,8244,44%0,00%2,68% -
96
Specific Invoice Recharges and Service Fees
893125810600703005311110125001.20257,36%12.406168.5811.88727.917746,8244,44%0,00%2,68% -
97
Specific Invoice Recharges and Service Fees
893125811100801005311010119001.2025168.581-0,93%-181.887140.6651.1410,00%-1,54%0,81% -
98
Specific Invoice Recharges and Service Fees
893125811100801005311110125001.2025168.58161,36%1.1581.887140.6651.1410,00%101,54%0,81% -
99
Specific Invoice Recharges and Service Fees
(blank)10600703005311010119001.20257,36%12.406168.581-0,08%-11.88727.917746,8244,44%-0,19%2,68%- 0,63
100
Specific Invoice Recharges and Service Fees
(blank)10600703005311110125001.20257,36%12.406168.5814,95%931.88727.917746,8244,44%12,50%2,68% 41,50