Ratio Computation

[mark692]

Hello guys i have a small laundry business, i want to know the ratio between the numbers of wash and the number of detergent used per day, i have i table like this

	A	B	C	D
Date	Wash	Detergent	Ratio

<tbody>
[TD="align: center"]1[/TD]

[TD="align: center"]2[/TD]
[TD="align: right"]August, 01 2018[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"][/TD]

[TD="align: center"]3[/TD]
[TD="align: right"]August, 02 2018[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"][/TD]

[TD="align: center"]4[/TD]
[TD="align: right"]August, 03 2018[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"][/TD]

[TD="align: center"]5[/TD]
[TD="align: right"]August, 04 2018[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]6[/TD]
[TD="align: right"]August, 05 2018[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]7[/TD]
[TD="align: right"]August, 06 2018[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]8[/TD]
[TD="align: right"]August, 07 2018[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]9[/TD]
[TD="align: right"]August, 08 2018[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]10[/TD]
[TD="align: right"]August, 09 2018[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]11[/TD]
[TD="align: right"]August, 10 2018[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

</tbody>

Sheet1​

on column D i to put wer the ratio will appear

 

[fhqwgads]

hope this works

Date               	Wash	Detergent	Ratio
August, 01 2018      	6       	4	3:2
August, 02 2018      	5       	3	5:3
August, 03 2018      	4              	2	2:1

D2=

=B2/GCD(B2,C2)&":"&C2/GCD(B2,C2)

 

[jtakw]

Hi,

Actually you Already have your ratios in your Table, Columns B and C.

Now if you want a specific ratio, like "how many washes per unit of detergent" or vice versa, then:

Book1
	A	B	C	D	E
1	Date	Wash	Detergent	Ratio (# Wash to Unit of Detergent)	Ratio(Unit of Detergent per Wash)
2	August, 01 2018	6	4	1.5	0.67
3	August, 02 2018	5	3	1.67	0.6
4	August, 03 2018	4	2	2	0.5
5	August, 04 2018
6	August, 05 2018
7	August, 06 2018
8	August, 07 2018
9	August, 08 2018
10	August, 09 2018
11	August, 10 2018
Sheet154

Cell Formulas
Range	Formula
D2	=ROUND(B2/C2,2)
E2	=ROUND(C2/B2,2)

 

[mark692]

thanks guys, i want to know if the number of detergent is getting lower than the number of wash everyday, do you think by knowing the ratio will help me?

 

[jtakw]

thanks guys, i want to know if the number of detergent is getting lower than the number of wash everyday, do you think by knowing the ratio will help me?

Column E in my sample is telling you it's getting lower.

Edit: So to clarify, as you can see in Column E, we started with 0.67 unit of detergent per wash, then 0.6, then 0.5

 

[mark692]

Column E in my sample is telling you it's getting lower.

Edit: So to clarify, as you can see in Column E, we started with 0.67 unit of detergent per wash, then 0.6, then 0.5

i see i get it now sir thanks so much!

 

[jtakw]

You're welcome.

Looking at your question in Post #4 again, I'm not so sure I understood correctly.

So the downward trend in Column E Only means people are using Less detergent per wash, it doesn't mean that your business is going "downhill", see additional sample (August 4) below:

Book1
	A	B	C	D	E
1	Date	Wash	Detergent	Ratio (# Wash to Unit of Detergent)	Ratio(Unit of Detergent per Wash)
2	August, 01 2018	6	4	1.5	0.67
3	August, 02 2018	5	3	1.67	0.6
4	August, 03 2018	4	2	2	0.5
5	August, 04 2018	1000	375	2.67	0.38
6	August, 05 2018
7	August, 06 2018
8	August, 07 2018
9	August, 08 2018
10	August, 09 2018
11	August, 10 2018
Sheet154

Cell Formulas
Range	Formula
D2	=ROUND(B2/C2,2)
E2	=ROUND(C2/B2,2)