Win a copy of Building Community this week in the City Repair forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
permaculture forums growies critters building homesteading energy monies kitchen purity ungarbage community wilderness fiber arts art permaculture artisans regional education skip experiences global resources cider press projects digital market private forums all forums
this forum made possible by our volunteer staff, including ...
master stewards:
  • Nicole Alderman
  • paul wheaton
  • Anne Miller
  • Pearl Sutton
  • Mike Haasl
  • Joylynn Hardesty
  • r ranson
  • James Freyr
  • Burra Maluca
master gardeners:
  • Steve Thorn
  • Greg Martin
  • Ash Jackson
  • thomas rubino
  • Carla Burke

Tincture Cheatsheet

Posts: 20
Location: Greece
  • Likes 3
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

Hello my herbal friends!
I thought it would be nice if I shared to the rest of the community a small tool that I created. It is based on the book of Dr. Sharol Tilgner “Herbal Medicine from the Heart of the Heart”. Basically, it is a spreadsheet that helps you calculate with precision the exact amount of alcohol & water to use in any tincture, for fresh and dry herbs . Like you, even  though I love to make calculations by the traditional way -by using pen, paper brain-  the use of technology (sometimes) is inevitable.
So here is the thing: the spreadsheet is divided in three columns. The first one is labelled “Herb Info”. There you can put the common and latin name of the herb, harvesting period and parts used. That’s basically made for your archive purposes. By adding this info, you can store the data on your hard drive or even print it in paper, for when you prepare the same tincture. The real “goldmine” is the following: watch the three columns labelled “Preparation Data”. There you must add the following info: herb weight (in grams), solvent strength, fresh herb weight, dry herb weight Watch for the values that are accompanied with two stars (** ). These are values that are required for the formula (calculative this time ) to work.
The alcohol and water label followed by three stars (*** ) is our final solvent with the exact percentages that we must use. The spreadsheet refers to both situations, of when using a 190 – proof alcohol or any other alcohol with random strength.
There’s a warning at the end of the calc sheet. If by any chance the final water of our solvent TURNS to a (-) negative number, then we must decrease the strength of our product.
Next to those columns is something that was made as an experiment. Having the multiple maceration method in mind, there’s is a mathematic division of our marc (the herb), in upward doses that promotes the proper maceration of our product. It hasn't been tested though yet. Mind that, for the different parts of a herb there’s a different calculation. Feel free to experiment though!
This spreadsheet was based on the book “Herbal Medicine from the Heart of the Earth”. The author, if she wishes to,  may freely add, remove, edit any part of the spreadsheet and may even distribute it via her website or as a download link from her (eagerly waiting!) e-books.
Post your comments if things don’t work as expected. Have fun!
[UPDATE] I can not upload the file here because it is an .xlsx format (excel). You can download it from Dropbox here
Posts: 41
Location: Medford, Oregon 8a, 21” precipitation. Clay soil.
rabbit books food preservation fiber arts medical herbs bee
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
This is a nifty tool, Daniel! Thanks for offering this up to the community. I suspect I tend to overdo on the alcohol in tinctures because I want to ensure their shelf stability and this will help me better balance them.
Daniel Gélin
Posts: 20
Location: Greece
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thank you Shawn!
Please, download the latest version from here
A bug fixed in the "custom alcohol" tab. Also, "parts used" section was increased.
To make things simple just remember that in the sections with two stars (** ) you just add the values you want. In the section with three stars (*** ) you can find out how much water - alcohol to use.

I knew I would regret that burrito. But this tiny ad has never caused regrets:
permaculture bootcamp - learn permaculture through a little hard work
    Bookmark Topic Watch Topic
  • New Topic