Calculate ratio of fractions which corrensponds with total ratio

tomasz_m

New member
Joined
Aug 18, 2018
Messages
3
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-
A7575/130*90 = 51.9231
B5050/130*90 = 34.6154
C55/130*90 = 3.4615
A+B130-

I have Table 2 (T2):
Share of the total number (S)
Total number (N)70-
A3030/50*70 = 42
B2020/50*70 = 28
C00/50*70 = 0
A+B+C50-


And I have a summary table for the Table 1 and Table 2 (T3):
Share of the total number (S)
Total number (N)160-
A105105/180*160 = 93.3333~
B7070/180*160 = 62.2222
C55/180*160 = 4.4444~
A+B+C180-



And here is the problem I need to solve (this is summary table for simplifying):
T1T2T1+T2T3T1+T2=T3
A (S)51.92314293.923193.3333~NO
B (S)34.61542862.615462.2222~NO
C (S)3.461503.46154.4444~NO
Total number
A+B+C (N)
9070160 = OK~160 = OKYES

Summary of the NT1+NT2 = NT3 - that is correct
but the S of: AT1 + AT2 != AT3
and BT1 + BT2 != BT3
and CT1 + CT2 != CT3

How I change the ratio equation from for ex: A/(A+B+C)*N to secure that AT1 + AT2 = AT3 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.
 
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-
A7575/130*90 = 51.9231
B5050/130*90 = 34.6154
C55/130*90 = 3.4615
A+B130-

I have Table 2 (T2):
Share of the total number (S)
Total number (N)70-
A3030/50*70 = 42
B2020/50*70 = 28
C00/50*70 = 0
A+B+C50-


And I have a summary table for the Table 1 and Table 2 (T3):
Share of the total number (S)
Total number (N)160-
A105105/180*160 = 93.3333~
B7070/180*160 = 62.2222
C55/180*160 = 4.4444~
A+B+C180-


And here is the problem I need to solve (this is summary table for simplifying):
T1T2T1+T2T3T1+T2=T3
A (S)51.92314293.923193.3333~NO
B (S)34.61542862.615462.2222~NO
C (S)3.461503.46154.4444~NO
Total number
A+B+C (N)
9070160 = OK~160 = OKYES

Summary of the NT1+NT2 = NT3 - that is correct
but the S of: AT1 + AT2 != AT3
and BT1 + BT2 != BT3
and CT1 + CT2 != CT3

How I change the ratio equation from for ex: A/(A+B+C)*N to secure that AT1 + AT2 = AT3 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.
 
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).
 
Top