Colloidal Silver and Gold Forum

Production Techniques and Chemistry => Colloidal Silver Production => Topic started by: HairyCat on December 01, 2017, 08:40:19 AM

Title: Colloidal Silver Calculator
Post by: HairyCat on December 01, 2017, 08:40:19 AM
Hi to all!

I would like to ask about Colloidal Silver calculator. There was such a great calculator on this site: http://www.ncuentra.com/Colloidal Silver/cs_calculator.php#
but it stopped working.
Is there any other equally good?

Cheers!
Title: Re: Colloidal Silver Calculator
Post by: FromTheDen on December 01, 2017, 05:03:34 PM
I'm not sure what you're looking for, but you could try this: https://www.dropbox.com/sh/ds6od7twm2kyo81/AACKSKMkGJGmzAeCIxCP6LCva?dl=0 (https://www.dropbox.com/sh/ds6od7twm2kyo81/AACKSKMkGJGmzAeCIxCP6LCva?dl=0)
Title: Re: Colloidal Silver Calculator
Post by: HairyCat on December 04, 2017, 06:14:04 AM
Thanks FromTheDen.
the calculator I mean was much simpler.
There was only one page and a few fields to fill:
The set concentration,
The set current,
The length of the process,
How many mg of silver will separate.
How much do you need cinnamon extract.

Does anyone remember this calculator?
Title: Re: Colloidal Silver Calculator
Post by: kephra on December 04, 2017, 03:33:38 PM
I searched the forum and couldn't find any other calculators.
There was another, but the website which hosted it no longer exists.

Title: Re: Colloidal Silver Calculator
Post by: Dean on December 04, 2017, 06:47:23 PM
Not 100% finished and this is only an excel version.

Have no idea how it will display or operate for others as have not got as far as testing
(or locking down) so if you break it, just just download it again.  ;D

Check the fields before you overtype just to make sure they are not calculated fields and you
should be ok.

This was created in office excel 2010.

https://www.dropbox.com/s/x28fi5s1dufgw52/Calculator.xlsx?dl=0
Title: Re: Colloidal Silver Calculator
Post by: FromTheDen on December 05, 2017, 12:59:20 AM
Nicely done, Dean!
Title: Re: Colloidal Silver Calculator
Post by: Dean on December 05, 2017, 09:32:23 PM
Thank you.

It's not as technical as Wayne's but it does give a broadly uniform way / quick reference for consistent
production.

I also have a batch recorder on sheet 2 but didn't actually finish it. and the format and options is not complete.
Needs a lot more work.

Sheet 1 is OK though.
Title: Re: Colloidal Silver Calculator
Post by: Gene on December 10, 2017, 03:48:49 AM
Nice!

There are some things you've done however, that make it useless for me and perhaps others.  Just so its said, this is meant to be constructive so please don't take it the wrong way.

If  you're using a quart mason jar like I do, half way up the neck is almost exactly 900ml which is as far as you can go. There is no 900ml water amount in your list.  If you're using a pint mason jar, the working number would be about 450ml.  They're a pint or quart right to the top of the rim which makes them not useful for holding a full pint or a full quart!!!  Telling the truth to lie!  SOP for US marketing dweebs.

Your PPM list excludes PPM's I routinely make (like 120PPM as an example, sometimes 50PPM, sometimes 60PPM,...).

Also, unless someone has a really high quality current limiter and adjusts things perfectly (EVERYTHING has a tolerance - figure at least +/-3%, maybe more with home built limiters most times non-adjustable) nobody is running a perfectly even integer current which for the rounding introduces even more error.

I have a simple suggestion. How about nixing the dropdown lists and simply let people punch in numbers?  The math is the same, right?

It takes about as much time to pop up the list and find the value you want (or find its not in there and you're stuck and grabbing for the calculator - wink) as it does to simply punch in a 2 or 3 digit number.

You sure your calculation for gelatine is correct?  1000ml, 100PPM is 1.25g? Wayne's calculator reports 0.3569g which I'm sure is the correct amount.

Oh yeah I'd use it if it accommodates my needs.  I use Karo and always will.  There is no other calculator that does the calculations for it I know of.

Glucose is supposedly better (reduces at a lower temp) but my results have been "confused", sometimes for doing everything identically, I get clouding on reduction (no clue why - makes no sense).  This has never happened to me with karo nor with maltodextrin. I don't care for malto as much because it makes darker colored Colloidal Silver where I'm used to knowing what color I should get with karo for the PPM's I normally make and that confuses me. I think I understand why but I'll stick with karo.

Keep working on it. Its going to be a simple one but a goodie.  I just want to make good quality Colloidal Silver and though I have a calculator, using it requires a bit more thinking (wink).

Title: Re: Colloidal Silver Calculator
Post by: FromTheDen on December 10, 2017, 07:12:11 PM
Dean, one of the things I appreciate about your calculator is the section on dosage. I passed it on to some friends who were unfamiliar with the concept. That being said, though I work with liters & grams when making colloidal silver, for height & weight I'm still stuck on inches & pounds. On my copy of your calculator, I renamed the 3rd tab Conversions, and added conversions for height & weight to put on the first worksheet. I also think of drinking volumes (glasses) in terms of quarts/ounces, so I added a conversion for that. It would be a nice default plus ;).

Also, on the first worksheet changing the gender affects the BV, but not the dosage. That might need some tweaking.
Title: Re: Colloidal Silver Calculator
Post by: Dean on December 10, 2017, 09:36:33 PM
 ;D ;D ;D ;D ;D ;D ;D

Well, it's all a kind of work in progress so I do appreciate the feedback.
I can't remember the reason that had a drop down list for volume.

I don't often create these using only formulas. I usually have loads of VBA but I know a lot of people don't like running
spreadsheets with macros. So in absolute truth, it was a bit of an experiment.

Hence the "if you break it just download it again" comment  :o :o :o :o :o

In double truth, you can see the nonsense that goes through my head with the "message bar" and changing the current through
the drop down list options (if you haven't done it yet, have a go).

I could have used swear words but I thought I better be grown up about it!

perhaps it can be a community project. From the den, do you have your revised version so I can take a look and see if I can implement anything?

The BV part has literally only just got added and I do know that some of the calcs and dependancies are off at the moment. Again, trying to give this the brain space it needs at the moment is a little tricky, I think it may have to be my Christmas Break project again! (after the ST3 manual of course - Boss  ;D)

I haven't looked at this in a while and only popped it up to help with the thread.
Wayne's calculator is way more polished but I do appreciate that some may also appreciate an excel version and that was the reason for having a go.
I will keep working on it (because it's fun and I'm an idiot!) but please bear with me while I get a few other bits out the way first.

Keep posting thoughts too and I will try to accommodate if possible.
Right now I can't even open it because I'm on the mac with not office installed! Oh the Joys!
 
Title: Re: Colloidal Silver Calculator
Post by: Dean on December 11, 2017, 12:20:41 AM
Nice!


Thank you  :)


There are some things you've done however, that make it useless for me and perhaps others.  Just so its said, this is meant to be constructive so please don't take it the wrong way.

I won't


If  you're using a quart mason jar like I do, half way up the neck is almost exactly 900ml which is as far as you can go. There is no 900ml water amount in your list.  If you're using a pint mason jar, the working number would be about 450ml.  They're a pint or quart right to the top of the rim which makes them not useful for holding a full pint or a full quart!!!  Telling the truth to lie!  SOP for US marketing dweebs.

Your PPM list excludes PPM's I routinely make (like 120PPM as an example, sometimes 50PPM, sometimes 60PPM,...).

Also, unless someone has a really high quality current limiter and adjusts things perfectly (EVERYTHING has a tolerance - figure at least +/-3%, maybe more with home built limiters most times non-adjustable) nobody is running a perfectly even integer current which for the rounding introduces even more error.

I have a simple suggestion. How about nixing the dropdown lists and simply let people punch in numbers?  The math is the same, right?

It takes about as much time to pop up the list and find the value you want (or find its not in there and you're stuck and grabbing for the calculator - wink) as it does to simply punch in a 2 or 3 digit number.


Done!  ;D


You sure your calculation for gelatine is correct?  1000ml, 100PPM is 1.25g? Wayne's calculator reports 0.3569g which I'm sure is the correct amount.


As with all things, this appears to be a subjective issue with some users actively seeking to use the bare minimum.
My calcs were taken from posts where Kephra had indicated a "rule of thumb" to ensure enough was always present.
Re-visiting this one https://www.cgcsforum.org/index.php?topic=2709.msg22525#msg22525  ..... seems to take that  approach with 2 values a minimum and maximum. I think I just went with the maximum. I consistently use 4g for 1 litre of 320 and get good results with the final product not too dark (through an excessive percentage of coverage).

If you tell me the ratio you are happy with, I can adjust a copy of the calculator for you. or I will just a stand alone cell where you can enter your preferred value per litre. I don't mind either way.

Oh yeah I'd use it if it accommodates my needs.  I use Karo and always will.  There is no other calculator that does the calculations for it I know of.

Does your "There is no other calculator........" comment refer to this / my calculator so you'd use it if I can fix the other things?
If so, thank you very much. I'm really chuffed that a bit of amusement on my part has been able to benefit someone else.

I do like messing about things like this. I've made a massive "excel application" for my business which is where I learned most of what I know. Things like this are pretty cool though


Glucose is supposedly better (reduces at a lower temp) but my results have been "confused", sometimes for doing everything identically, I get clouding on reduction (no clue why - makes no sense).  This has never happened to me with karo nor with maltodextrin. I don't care for malto as much because it makes darker colored colloidal silver where I'm used to knowing what color I should get with karo for the PPM's I normally make and that confuses me. I think I understand why but I'll stick with karo.

Keep working on it. Its going to be a simple one but a goodie.  I just want to make good quality colloidal silver and though I have a calculator, using it requires a bit more thinking (wink).

I will. and thanks again for the feedback.
I've sorted the first couple of points already. The blood thing and the gel volume is open to discussion but I'll happily amend if there is a consensus that the value I have in there is too high. The only reason I've made it the top end is so that no user should ever accidentally use too little. I know it can be reduced, but I'd say making sure the value is always enough is more important to most.




Title: Re: Colloidal Silver Calculator
Post by: Dean on December 11, 2017, 02:17:07 AM
Dean, one of the things I appreciate about your calculator is the section on dosage. I passed it on to some friends who were unfamiliar with the concept. That being said, though I work with liters & grams when making colloidal silver, for height & weight I'm still stuck on inches & pounds. On my copy of your calculator, I renamed the 3rd tab Conversions, and added conversions for height & weight to put on the first worksheet. I also think of drinking volumes (glasses) in terms of quarts/ounces, so I added a conversion for that. It would be a nice default plus ;).

Awesome!  ;D

Also, on the first worksheet changing the gender affects the BV, but not the dosage. That might need some tweaking.

That's because BV is the product of Height x weight (differentiated by gender) so changing gender uses a different calculation.
These are visible in cells A20 and A21 (and by the long explanation on sheet 1).  ;)

There is no connection on the sheet between dose and BV so dose value does not change. That will require additional calcs not based on body weight but by Blood volume instead. Have not got as far as working that out. If anyone wants to do the final math that takes BV into account then I'll add/correct it. Brain is officially dead at the moment!




Title: Re: Colloidal Silver Calculator
Post by: Dean on December 11, 2017, 02:44:26 AM
Version 2

https://www.dropbox.com/s/tsiy1cx226gm7tf/Calculator.xlsx?dl=0

Production calculator

1. Removed drop-down lists for Water Volume, Strength & Current

Any value can be entered now for water volume and ppm and current (up to 30mA)


Ag Dose Calculator

2. Added Metric / Imperial selection for height & weight cells. (labels change per selection)
3. Added warning message if value these fields reflect improper data entry values.

In other words, if you enter height in metres and weight in KG, then change the format to Imperial
the value wall be outside of any usual value for Blood volume. Same goes for the other way round (Imperial to metric.)
As long as the BV range is within a "possible" amount then it will not warn. If it falls below 3 or is more than 20 it will warn.
You just need to check your values for your preferred format.

Have hidden other sheets.

PW for for book is 1234 (just in case you want to tweak it or edit it to your own liking.

Title: Re: Colloidal Silver Calculator
Post by: Bobby on December 11, 2017, 09:31:55 PM
  Great job Dean!  Simple and easy!  Gotta love it!

Bobby
Title: Re: Colloidal Silver Calculator
Post by: HairyCat on December 12, 2017, 05:50:39 AM
Thank you Dean! This is what I meant. Cool digital abacus  ;D ;D
Title: Re: Colloidal Silver Calculator
Post by: Dean on December 12, 2017, 08:05:10 AM
Glad to help,

Please do check all your choices against your own logic and requirements.
If you are going to use it regularly then you'll be the first so make sure you are
happy that all the calcs / volumes/ quantities / concentrations and workflow.

Also, if anyone else wants to review, comment, edit, make suggestions then please do post.

Think of it as RC1 / Beta version  ;D

If stuff seems wrong, it may well be the case!  ;D ;D ;D ;D ;D

(Would love to get the blood volume worked in to the dose calculator so if anyone has the correction to the calculation that makes the work then be my guest !!)
Title: Re: Colloidal Silver Calculator
Post by: llau on May 23, 2021, 05:33:01 PM
Hi all,
I share this calculator in order to test it.
Can you tell me if it is useful or has any error?

Regards!!  ;)
Title: Re: Colloidal Silver Calculator
Post by: Gene on May 23, 2021, 07:15:56 PM
Haven't tried it yet but just so its stated, here are the formulas I've gleaned from this forum and Kephra's notes over the years.

Gelatine (mg):
   PPM * <milliliters> / [160...80 ]

Karo (1:1 in vodka - drops):
   PPM * <milliliters> / 2000

Maltodextrin (mg):
   PPM * <liters> * 14.194

Glucose (mg):
   PPM * <liters> * 0.8335

Cell voltage minimum requirement vs. electrode spacing
   4.33 * spacing (inches) + 3.5

Faraday's Law (minutes to run cell to desired PPM)
   PPM * <liters> * 15 / <cell current(milliamps)>

Silver Oxide Solubility in water (Temp(F) vs solubility)
        75F   -> 21-22PPM
        150F -> approx 40PPM
Title: Re: Colloidal Silver Calculator
Post by: tbrod on August 28, 2021, 07:29:35 PM
You can use Faradays law of Electrolysis:     

at 25mA for 20ppm the formula is: 1x 20 (ppm) x 15=300/25=12 minutes brewing time
at 10mA for 20ppm the formula is: 1x 20 (ppm) x 15=300/10=30 minutes brewing time

at 25mA for 100ppm the formula is: 1 x 100 (ppm) x 15=1500/25=60 minutes brewing time
at 10mA for 100ppm the formula is: 1 x 100 (ppm) x 15= 1500/10=150 minutes brewing time

study the formula...the only changes are the ppm and mA..  Simple
Title: Re: Colloidal Silver Calculator
Post by: Gene on August 29, 2021, 03:45:53 AM
Look at my post. The Faraday's law equation is:

PPM * <liters> * 15 / <cell current(milliamps)>

The only thing that doesn't change is the constant 15. Every other parameter depends on what you're making, how much water you're using, what current you're running at where none of these is a constant.
Title: Re: Colloidal Silver Calculator
Post by: AVPX1 on April 21, 2022, 06:21:29 PM
Hi all,
I share this calculator in order to test it.
Can you tell me if it is useful or has any error?

Regards!!  ;)
Thanks for sharing your calculator llau
It appears to work well except I think the computed "Time of preparation" isn't correct.
For 250ml at 320ppm using 15 ma I'm calculating that it should be 80 minutes not 800.

Thanks
Title: Re: Colloidal Silver Calculator
Post by: kephra on April 21, 2022, 06:51:53 PM
Yes, 80 minutes at 15ma in 250ml water.  Not 800 minutes.
Title: Re: Colloidal Silver Calculator
Post by: AVPX1 on April 22, 2022, 07:54:16 PM
I've really come to appreciate this calculator from llau.
The obvious care and effort put into it's development is impressive.
I don't know if llau is still active on the forum but I offer a big thank you for this excel spreadsheet and find it really helpful.
I've edited it to work acurately when set to it's English format and attached for others.
I urge members to take it for a spin.  :)

Changes I've made to it...
Fixed processing time to be accurate.
Fixed calculation for "silver type" to work when set to the English format
   No longer works in Spanish
Translated to comments/explanations to English.
Added calculation for gelatin powder using mg.
   No longer works in Spanish
Minor content fitting for text in cells
Title: Re: Colloidal Silver Calculator
Post by: llau on April 23, 2022, 11:16:55 AM
Hi,
I'm making the version 45 ;D
I will review your modificacions..

Thanks for your inputs!
Title: Re: Colloidal Silver Calculator
Post by: AVPX1 on April 23, 2022, 02:18:13 PM
Hi,
I'm making the version 45 ;D
I will review your modificacions..

Thanks for your inputs!

Hi llau!
Thank you for sharing your calculator with us.  :)
Last night I made a few more modifications.
Fixed gender recognition for female vs male when in English format and re-worded a few messages in English.
I've attached the revised spreadsheet.


Title: Re: Colloidal Silver Calculator
Post by: AVPX1 on April 23, 2022, 03:54:21 PM
I also changed the format so you can make any ppm you want up to 640ppm

So, the only other thing I'm seeing that either needs fixing or maybe just needs better explanation is the calculated "Max. dose per day (ml)". The "1 dose every 6h (ml)" just uses the value from "Max dose" divided by 4 so no worries there.
Maybe I'm just not understanding your calculation...
  "Calculation made for an oral intake in milliliters, assuming only 50% absorption in blood. The objective is to reach a concentration of 2ppm's in blood, with a Weight / Volume ratio in blood of 7%."

I've attached a picture of the values I'm using.
Strength (ppm's) = 20
Gender = Male
Blood Volume = 4.4

Calculated value for "AG per day (mg)" =  18.2 mg (This looks to be correct)
Calculated value for "Max. dose per day (ml)" = 200.4ml (This looks really low to me, shouldn't this value be 910ml ?)
Title: Re: Colloidal Silver Calculator
Post by: llau on April 23, 2022, 04:13:04 PM
I have reduced the dose, because with that dose it is more than enough for common illnesses.  For serious illnesses you can ingest more.
As soon as I can I will share the latest version with significant changes.
Title: Re: Colloidal Silver Calculator
Post by: kephra on April 23, 2022, 07:34:18 PM
Looking at the dosage example.png:
20mg is not 300ug
Maltoddextrin does not need to display tenths as it is not critical and very few of us can measure to that accuracy.
Max dose per day (mg) 18.2   ... Who says?  Nonone actually knows the maximum dose.
Max dose per day 200.4 (ml).... No, math is wrong.
Dessert spponfuls 5.0 ... What?  Teaspoons, Soup spoons, and Tablespoons are common (5,10,15ml)
Ag per dose (ug) 501.1  ... No, math is wrong.  Why show micrograms at all?
Ppm initial water 0.6 ... Why show this?
Time of preparation days ... Why show this?  Who has a clock calibrated in percentage of days?  Who is going to process longer than a day?
Title: Re: Colloidal Silver Calculator
Post by: AVPX1 on April 23, 2022, 09:29:45 PM
Looking at the dosage example.png:
20mg is not 300ug
Maltoddextrin does not need to display tenths as it is not critical and very few of us can measure to that accuracy.
Max dose per day (mg) 18.2   ... Who says?  Nonone actually knows the maximum dose.
Max dose per day 200.4 (ml).... No, math is wrong.
Dessert spponfuls 5.0 ... What?  Teaspoons, Soup spoons, and Tablespoons are common (5,10,15ml)
Ag per dose (ug) 501.1  ... No, math is wrong.  Why show micrograms at all?
Ppm initial water 0.6 ... Why show this?
Time of preparation days ... Why show this?  Who has a clock calibrated in percentage of days?  Who is going to process longer than a day?
Valuable feedback Kephra.
Thanks!

I'm looking forward to the updated version from llau when it's ready.
I'm excited about this being a great tool and a means to double check our calculations. :)
Title: Re: Colloidal Silver Calculator
Post by: llau on April 24, 2022, 12:52:50 PM
Hi,
Attached the last modification.  8)



Title: Re: Colloidal Silver Calculator
Post by: tbrod on April 24, 2022, 06:13:58 PM
   Don't have a clue... don't speak spanish... most here are ENGLISH.

Hi,
Attached the last modification.  8)




Title: Re: Colloidal Silver Calculator
Post by: llau on April 24, 2022, 06:21:26 PM
It is in both languages.  8)
Title: Re: Colloidal Silver Calculator
Post by: tbrod on April 24, 2022, 06:42:43 PM
  I just opened it again and I guess I'm blind only see spanish or what language it is  :-)  * Calculadora Plata Coloidal_v50_cgcsforum.xlsx (492.46 kB - downloaded 3 times.)
It is in both languages.  8)
Title: Re: Colloidal Silver Calculator
Post by: llau on April 24, 2022, 07:10:10 PM
There is a flag with two balls selected English. Is easy!!
Title: Re: Colloidal Silver Calculator
Post by: AVPX1 on April 25, 2022, 03:08:15 AM
Hi,
Attached the last modification.  8)
Thanks llau,
It is apparent you've put a lot of effort into it.

Unfortunately, by using the input message and error alerts in Spanish the calculator is just too hard to use for us English speaking folk. The text messages they provide are critical to a user understanding what values are expected or errors are encountered.
It seems to make more sense to have a dedicated Spanish version and a dedicated English version.

The "time in minutes" is still incorrect. To fix cell E18, adjust the formula as shown below...
=IF(G7="1",(E6*E10)*0.015/(E7*E11/3),(E6*E10)*0.015/(E7*E11/3))

The section for displaying "IONIC SILVER OXIDE"/"SILVER NANOPARTICLES" doesn't work as expected. To fix, adjust the formula for cell L7 as shown below...
=COUNTIF(L6,"TRUE")*2

The section for "Type of Colloidal Silver" doesn't work as expected but the above change will fix it as well.

The Blood Volume now appears to only reflect that of a female. Personally, I liked the capability you had included to select male/female which you have removed in this version.

I really like that you added the ability to calculate Gelatin in it's powder form.
 Note, gelatin is spelled incorrectly in the spreadsheet. It should be gelatin not gelatine.

Perhaps changing cell H13 to reflect the two options would be helpful meaning...
if K13 is set to milligrams then H13 would display "Gelatin Powder" but if K13 is set to ml then H13 would display "Gelatin Solution".

The calculation for "Silver content (μg)" is still incorrect. All you have to do is multiply cell E25 by 1000.

Perhaps changing the text from "Max. dose per day (ml)" to "High dose per day (ml)" might be a better way to indicate the intention of limiting dosage.

The calculation for "Max. dose per day (ml)" when "High Dose " is selected still looks really low. Example: If I want to consume the "AG per day (mg)" in total over the course of 24 hours then I would think that the calculation for "Max. dose per day (ml)" equals the "AG per day (mg)". Ergo if "Ag per day (mg)" is 20.0  then "Max. dose per day (ml)" would be 1000ml. I do not know the formula for calculating this value but I'm sure senior members do.

The section for "1 dose every 6h/8h (ml)" is a bit odd. 8 x 4 = 32 hours. The way you used to have it "1 dose every 6h (ml)" seemed more intuitive.

Hope this helps
Thanks
Title: Re: Colloidal Silver Calculator
Post by: llau on May 13, 2022, 09:28:20 PM
Attached the last version...

They can review it. It has many changes.  ;)
Title: Re: Colloidal Silver Calculator
Post by: openminded on October 23, 2022, 12:45:22 AM
Thank you IIau, downloaded the calulator.