Dear All,
I need to calculate the persentage of expected income for the following sheet
in The header of Row 6
The seats are total seats to be earned, should not be changed by user.
units can be enteried based on the user what did he founded in the country. can be changed by user.
Sold% and sold is corecct no problem in it, H# /C# should not be changed by user. (This persantage is for each row) only for each country and not the total countries.
unit price and and total no problem.
My question is in
I need help in calculating in Coulmn F, from Row6 (Income expectation) this is what does i need help in calculating based the Sold% from the Value in B2 , and the total in F32 should be equal like B2.
I need to calculate the persentage of expected income for the following sheet
in The header of Row 6
The seats are total seats to be earned, should not be changed by user.
units can be enteried based on the user what did he founded in the country. can be changed by user.
Sold% and sold is corecct no problem in it, H# /C# should not be changed by user. (This persantage is for each row) only for each country and not the total countries.
unit price and and total no problem.
My question is in
I need help in calculating in Coulmn F, from Row6 (Income expectation) this is what does i need help in calculating based the Sold% from the Value in B2 , and the total in F32 should be equal like B2.
50.000.000 | Numbers | Units | ||||||
Founder Circle | 52 | 76.508 | 8 | |||||
Global Pooling | 222 | 171.000 | 76 | |||||
Seats | Units | Expected Income | Sold % | Sold | unit price | Total | ||
Netherland | 0 | 2.700 | 0 | 1.770.370 | 8,85% | 239 | 1.000 | 239.000 |
UAE | 0 | 3.500 | 0 | 9.417.143 | 47,09% | 1.648 | 1.000 | 1.648.000 |
Australia | 0 | 3.400 | 0 | 1.182.353 | 5,91% | 201 | 1.000 | 201.000 |
Sweden | 0 | 2.500 | 0 | 424.000 | 2,12% | 53 | 1.000 | 53.000 |
Moscow | 0 | 2.700 | 0 | 970.370 | 4,85% | 131 | 1.000 | 131.000 |
Saudi-Arabia | 73 | 2.600 | 1 | 3.784.615 | 18,92% | 492 | 1.000 | 492.000 |
Germany | 0 | 3.500 | 0 | 657.143 | 3,29% | 115 | 1.000 | 115.000 |
Estonia | 0 | 2.600 | 0 | 1.215.385 | 6,08% | 158 | 500 | 79.000 |
Italy | 60 | 5.500 | 1 | 6.610.909 | 33,05% | 1.818 | 500 | 909.000 |
Romania | 0 | 3.400 | 0 | 188.235 | 0,94% | 32 | 500 | 16.000 |
South Korea | 0 | 4.000 | 0 | 1.130.000 | 5,65% | 226 | 500 | 113.000 |
Spain | 0 | 5.500 | 0 | 3.883.636 | 19,42% | 1.068 | 500 | 534.000 |
Mexico | 10 | 10.000 | 1 | 2.004.000 | 10,02% | 1.002 | 250 | 250.500 |
Trindad & Tabago | 0 | 3.400 | 0 | 647.059 | 3,24% | 110 | 250 | 27.500 |
Turkey | 27 | 10.000 | 1 | 5.360.000 | 26,80% | 2.680 | 250 | 670.000 |
Kazachstan | 0 | 4.000 | 0 | 435.000 | 2,18% | 87 | 250 | 21.750 |
Oman | 0 | 3.400 | 0 | 1.111.765 | 5,56% | 189 | 250 | 47.250 |
Jordan | 129 | 10.000 | 3 | 8.618.000 | 43,09% | 4.309 | 125 | 538.625 |
Colombia | 0 | 10.000 | 0 | 1.220.000 | 6,10% | 610 | 125 | 76.250 |
Ukraine | 0 | 10.000 | 0 | 1.044.000 | 5,22% | 522 | 125 | 65.250 |
Iran | 53 | 8.000 | 2 | 4.262.500 | 21,31% | 1.705 | 125 | 213.125 |
Ghana | 0 | 5.200 | 0 | 653.846 | 3,27% | 170 | 125 | 21.250 |
Congo | 0 | 2.800 | 0 | 750.000 | 3,75% | 105 | 125 | 13.125 |
Uganda | 0 | 4.800 | 0 | 400.000 | 2,00% | 96 | 125 | 12.000 |
Yemen | 8 | 4.800 | 1 | 787.500 | 3,94% | 189 | 125 | 23.625 |
الإجمالي | 635 € | 128.300 | 58.527.830 | 13,99% | 17.955 | 6.510.250 |