Calculate ratio of fractions which corrensponds with total ratio

[tomasz_m]

I have Table 1 (T1) where share of the total number is calculated for A and B and C:

		Share of the total number (S)
Total number (N)	90	-
A	75	75/130*90 = 51.9231
B	50	50/130*90 = 34.6154
C	5	5/130*90 = 3.4615
A+B	130	-

I have Table 2 (T2):

		Share of the total number (S)
Total number (N)	70	-
A	30	30/50*70 = 42
B	20	20/50*70 = 28
C	0	0/50*70 = 0
A+B+C	50	-

And I have a summary table for the Table 1 and Table 2 (T3):

		Share of the total number (S)
Total number (N)	160	-
A	105	105/180*160 = 93.3333~
B	70	70/180*160 = 62.2222
C	5	5/180*160 = 4.4444~
A+B+C	180	-

And here is the problem I need to solve (this is summary table for simplifying):

	T1	T2	T1+T2	T3	T1+T2=T3
A (S)	51.9231	42	93.9231	93.3333~	NO
B (S)	34.6154	28	62.6154	62.2222~	NO
C (S)	3.4615	0	3.4615	4.4444~	NO
Total number A+B+C (N)	90	70	160 = OK	~160 = OK	YES

Summary of the N_T1+N_T2 = N_T3 - that is correct
but the S of: A_T1 + A_T2 != A_T3
and B_T1 + B_T2 != B_T3
and C_T1 + C_T2 != C_T3

How I change the ratio equation from for ex: A/(A+B+C)*N to secure that A_T1 + A_T2 = A_T3 and so on...?

There is one condition: At the moment of T1,2,3 calculation I do not know the numbers from from any another table.

Thank you.

 

[tkhunny]

I have Table 1 (T1) where share of the total number is calculated for A and B and C:

		Share of the total number (S)
Total number (N)	90	-
A	75	75/130*90 = 51.9231
B	50	50/130*90 = 34.6154
C	5	5/130*90 = 3.4615
A+B	130	-

I have Table 2 (T2):

		Share of the total number (S)
Total number (N)	70	-
A	30	30/50*70 = 42
B	20	20/50*70 = 28
C	0	0/50*70 = 0
A+B+C	50	-

And I have a summary table for the Table 1 and Table 2 (T3):

		Share of the total number (S)
Total number (N)	160	-
A	105	105/180*160 = 93.3333~
B	70	70/180*160 = 62.2222
C	5	5/180*160 = 4.4444~
A+B+C	180	-

And here is the problem I need to solve (this is summary table for simplifying):

	T1	T2	T1+T2	T3	T1+T2=T3
A (S)	51.9231	42	93.9231	93.3333~	NO
B (S)	34.6154	28	62.6154	62.2222~	NO
C (S)	3.4615	0	3.4615	4.4444~	NO
Total number A+B+C (N)	90	70	160 = OK	~160 = OK	YES

Summary of the N_T1+N_T2 = N_T3 - that is correct
but the S of: A_T1 + A_T2 != A_T3
and B_T1 + B_T2 != B_T3
and C_T1 + C_T2 != C_T3

How I change the ratio equation from for ex: A/(A+B+C)*N to secure that A_T1 + A_T2 = A_T3 and so on...?

There is one condition: At the moment of T1,2,3 calculation I do not know the numbers from from any another table.

Thank you.

Difficult to tell what it is you are doing.

For one, you cannot add averages and expect to get a rational result.

 

[tomasz_m]

Hello tkhunny,
i'll try to think of an example ...

I have few customers who share my car. They always pay for mileage including the way I go for gasoline. So the shared mileage per customer is slightly higher than mileage real driven. The amount which they need to pay are showed on daily basis on the public table. But at the end of the month I will do a monthly shared mileage per customer in the same way as I do it every day and I will bill them. But If the customer sums their daily closings it differs from the monthly payment.

All I need is get the sums of daily closings will be the same as monthly closing for every customer.

Like: Share[day1] + Share[day2] + ... + Share[day30] = MonthShare

Yearly closings needs to be calculated analogically: MonthShare[m1] + MonthShare[m2] + ... + MonthShare[m12] = YearShare

And It needs to work for every custom defined range (like weekly).

 

[Denis]

They always pay for mileage including the way I go for gasoline.

Huh?

 

[tomasz_m]

Huh?

Everything is just an example, to better understand the problem I have

You can understand that they pay my private rides too and it is shared with them.

 

[Denis]

Are you a Uber driver?