Excel 2010 Dilution Calaculator

wlshephard

wlshephard

New member
Joined
Dec 6, 2013
Messages
398
Reaction score
0
I made a dilution calculator to make my mixing detailing chemicals a little easier. All you have to do is enter the ratio (example 1:3) and then the size of the container and it will calculate the amount of product and water that you need in the bottle. If you would be interested in a copy let me know.

View attachment 24859
 
I've been looking for something like this! Thank you for making this.

I can't seem to download it....

"Invalid Attachment specified. If you followed a valid link, please notify the administrator"
 
I will have to email to you. Just PM me with an email address.
 
rjd598 said:
Bookmark it and it comes up in a second. I assume you carry your phone with you
Click to expand...

I did save the link thanks . But no I don't always carry my phone or have access to the internet. Cell phone carriers don't make much effort to get you a signal when there's more cows than people. I also wanted to make my own chart. Believe it or not I enjoyed it. I did it for myself but thought I would share it if someone wanted it. Thanks for the link.
 
Can't you just calculate it yourself?

If you want 1:3, there are 4 parts total. If you want 1:9 there are 10 parts. If you want 1:100, there are 101 parts - Easy elementary school maths.

Now, if you want 1 litre of 1:3, that means you have 1 litre divided by 4 parts or 250ml of product, the rest is water. If you want 5 litres of 1:9, that is 5 litres, divided by 10 parts or 500ml of product, the rest water. Again, I imagine this is elementary school stuff and the calculator on your phone would sort you if you have more awkward numbers.
 
Of course he could, how else did he make the excel sheet. I think the point is he made it for himself then thought hey why not share it in case someone else would like to have it. So why all the criticism? If you want a copy PM him if not move along.
 
PiPUK said:
Can't you just calculate it yourself?

If you want 1:3, there are 4 parts total. If you want 1:9 there are 10 parts. If you want 1:100, there are 101 parts - Easy elementary school maths.

Now, if you want 1 litre of 1:3, that means you have 1 litre divided by 4 parts or 250ml of product, the rest is water. If you want 5 litres of 1:9, that is 5 litres, divided by 10 parts or 500ml of product, the rest water. Again, I imagine this is elementary school stuff and the calculator on your phone would sort you if you have more awkward numbers.
Click to expand...

Thanks for the post. You are correct I used that formula to make the sheet. I did it because I wanted to not because I had to, and thought I would share it. I don't think there is anything wrong with that. It was a fun project. If you want a copy of the sheet to critique let me know. I imagine you could make it better that what it is now. I always enjoy the technical information you bring to posts. Have a great day!
 
BlkHemiLTD said:
Of course he could, how else did he make the excel sheet. I think the point is he made it for himself then thought hey why not share it in case someone else would like to have it. So why all the criticism? If you want a copy PM him if not move along.
Click to expand...

Thanks you are correct. I don't think he meant it as criticism, he was just sharing easier way to skin the cat.
 
FYI,

This won't work on a phone. It might if you have excel on your phone but I can't confirm that.
 
I just received the file and I must say, thank you so much!!
The excel that you create is very helpful especially there is a comparison table for U.S. Measure and Metric Measure.:dblthumb2:
 
zooroy said:
I just received the file and I must say, thank you so much!!
The excel that you create is very helpful especially there is a comparison table for U.S. Measure and Metric Measure.:dblthumb2:
Click to expand...

The chart just gives you a idea of how many us ounces are in common us sizes. Same for metric. There is no correlation between the two. I can do that if you want.
 
wlshephard said:
The chart just gives you a idea of how many us ounces are in common us sizes. Same for metric. There is no correlation between the two. I can do that if you want.
Click to expand...

This is enough. Thank you. No need to have correlation between the two. :props:
 
wlshephard said:
Thanks for the post. You are correct I used that formula to make the sheet. I did it because I wanted to not because I had to, and thought I would share it. I don't think there is anything wrong with that. It was a fun project. If you want a copy of the sheet to critique let me know. I imagine you could make it better that what it is now. I always enjoy the technical information you bring to posts. Have a great day!
Click to expand...

My apologies, it was not a criticism at all, just pointing out that it is possible to do it yourself. At heart, I am an educator so as great as it is to have it calculated for you, I am always inclined to try to get people to think how to get the answer for themselves. It would amaze you how many people cannot work out their dilutions yet will consider themselves suitable to argue the finer points of chemistry!
 
PiPUK said:
My apologies, it was not a criticism at all, just pointing out that it is possible to do it yourself. At heart, I am an educator so as great as it is to have it calculated for you, I am always inclined to try to get people to think how to get the answer for themselves. It would amaze you how many people cannot work out their dilutions yet will consider themselves suitable to argue the finer points of chemistry!
Click to expand...

I didn't think you were bagging on me I appreciate your "show you work" approach. Send me a pm and i will send you a copy. Maybe you can help me make it better. If you want to.
 
If anyone else wants a copy PM me an email address and I will get it out to you ASAP.

Also if anyone who gets it makes improvements send me a copy. Or has suggestions on improving it let me know.
 
You must log in or register to reply here.
Back
Top